ROS.2030600 -r    !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Biblioteca deve ser especificada., *0Abrir Biblioteca- +Salvar Biblioteca wDe:! Para:+ )0_Contorno PL/SQLA ?%No possvel abrir o arquivo %[1]s.usC A'Arquivo %[1]s j existe. Sobregrav-lo?f dJUnidade de programa %[1]s j est sendo editada em outra janela do editor./ -Unidade de Programa3 1%[1]s (Somente Leitura)M K1Realmente deseja deletar esta unidade de programa0E C a)String de pesquisa deve ser especificada.07 5Expresso regular invlida./ -Procurar/SubstituirM K1Procurar/Substituir Todas as Unidades de ProgramaW U;A origem da unidade de programa armazenada est incompleta.: 8_Unidade de programa armazenada( & DROP %s %s; ^ \BwRealmente deseja descontinuar a unidade de programa armazenada %s? sAdvertncia: A origem no est salva adequadamente no banco de dados. Exportar o texto de origem para um arquivo?> $Nome da tabela deve ser especificadoP N4wCorpo do gatilho deve ser um cdigo PL/SQL completo.G E+wInstruo de gatilho deve ser especificada.@ >$No est editando um gatilho vlido."  CREATE- +CREATE OR REPLACE# !wTRIGGER"  wBEFORE! ::_AFTER ni spONre( &IN FOR EACH ROW   WHEN N ' % : wREFERENCINGm"  |_OLD AS> "  prNEW ASna ::OFun- +.<_DROP TRIGGER %s; ::=) 'KA BEGIN END;CED% #io TRIG_%03u ACG E{ +wRealmente deseja descontinuar o gatilho %s? F D= *Unidade de programa deve ser especificada.B @&Nmero da linha deve ser especificado.0P N4wCorpo do gatilho deve ser um cdigo PL/SQL completo., *_. v tZO Quick Tour no pde ser localizado. Por favor, reinstale o Quick Tour e tente novamente.0, *Abrindo arquivo.A ? %wNo foi possvel localizar o arquivo.S Q 7wNo possvel truncar um arquivo que s pode ser lido.$0@00"`0000string0000000000000000000000000000P0r@08x "&`0850b0#p08x "5&0850b0708x $9(08g50b0;08x"= &080b50?008x $A (0850b50@E08x $M ( "00x white0"00x 50b50,gray72@$00x "^ r88gWr75g50b0P*08x ( & (*50 00r25g75b50`*08x ( $ &(b5 00r50g88b500,00x $ & (*b5a r25g50b75@,00x $ & (*b5b r50g50b75,00x $ & (*b5c r75g50b75,00x $ & (*5bd r88g50b75,00x $ & (*75e r100g50b75*00x" $ &(b7fr0g50b8850,00x $ & (*b7g r25g50b88@,00x $ & (*b7h r50g50b88,00x $ & (*b7i r75g50b88,00x $ & (*5bj r88g50b88,00x $ & (*88k r100g50b88*00x# $ &(b8l r0g50b1000,00x $ & (*b8m r25g50b100@,00x $ & (*b8n r50g50b100,00x $ & (*b8o r75g50b100,00x $ & (*5bp r88g50b100.00x & ( *,10q r100g50b100'00x "$%@ryellow+00x $ &()b1s darkyellow*00x "$ &(b1tmagenta0.00x &( *,b1u darkmagenta(00x " $&0vgray48(00x " $&dwgray44\\\(00x " $&dxgray40(00x " $&ygray36ףף'00x! "$%zr0g75b0)00x " $&'\({r25g75b0@ )00x " $&'|r50g75b0" $)00x " $&'}r75g75b0&)00x " $&'0~r88g75b0T+00x $ &() r100g75b0g.08x& ( *,00r0g75b50b0`$0@00"Vp` 0800X/p0808YSTATUS/CLEAR_ALL_MASTER_DETAILS0ld0C DEFGH0ASYSTEM.BLOCK_STATUSSYSTEM.BLOCK_STATUS0CLEAR_ALL_MASTER_DETAILS14d1PC!DEFGH1lASYSTEM.RECORD_STATUSSYSTEM.RECORD_STATUS1P10_05_AGO_200203_04_251d2C"DEFG H2$ASYSTEM.MODESYSTEM.MODE 222233$3D3d3P11_05_AGO_200203_04_25P12_05_AGO_200203_04_25P13_05_AGO_200203_04_25P14_05_AGO_200203_04_25P15_05_AGO_200203_04_25P16_05_AGO_200203_04_25P17_05_AGO_200203_04_25P18_05_AGO_200203_04_25P19_05_AGO_200203_04_25$00x !"--black--------------------------------------------- gv_module constant varchar2(40) := 'NKW_DNT'; gv_version constant varchar2(10) := '2.0.2'; gv_comments constant varchar2(80) := 'Dynamic Triggers'; type tab_button is table of varchar2(80) index by binary_integer; gt_button tab_button; ------------------------------------------------------------------ -- SET_ENV ------------------------------------------------------------------ procedure set_env; ---------------------------------------------------------- -- BOLD_BUTTON ---------------------------------------------------------- procedure bold_button; end pkg_frm;0800Rstring0000000000000000000000000000xT$UPL$8jUD$(O Q4L$ D$0PQRWZ3fG PQL$@OD$8L$PdL$\L$$PH苓3P󪋓L$RUUL$9D$L$L$\p"D$L$L$\QD$L$\;D$L$tL$\hffD$L$GL$\D$L$(L$\L$<t'$O@ȃD$4jP$QURftD$49u UUD$3$9qv2\$,|$(PFCP$9qw֋D$(PiD$0P\D$]_^[d$d$SVWً|$$U?l$09>81XPD$u]_^[;D$Pˋ7!PjPPV PV}D$P]_^[+D$ˉD$tWD$,L$l$D$L$4L$ |$t$t$t$ ̓D$D$D$N;D$w‹D$P]_^[ P ȋ+w D$,]PVjjP+ҋP͋GPS PS]_^[D$,PO 3QWGRjPVPV]_^[$$T$tSD$ VW$Uf>uF3$fF P+$$31]_^[t HfD$pt&jLL$PQt]_^[t D$phL$jPVQt]_^[t 33fN $|$+3jD$PD$$TL$PPV$PSQpD$jL$PUQN9\$D$PT$3U\$,D$|$ startitm ) THEN Go_Item(startitm); Check_Package_Failure; END IF; END; -- -- End default relation program section --  END;ON-POPULATE-DETAILS (MAIN)@@ @ @$@p3A vgtbziB$@p4A vgtbzoB@$@q.A vgtbhalB$@q/A vgtbhacB$@q0A vgtbharB$@q1A vgtbvatB$@q2A vgtbvacB$@q3A vgtbvabB@$@p A vgtbbtfB$@pA vgtbstbB@0r08086D1  $ P8_05_AGO_200203_04_25BEGIN -- -- Begin default relation program section -- BEGIN Clear_All_Master_Details; END; -- -- End default relation program section --  END;ON-CLEAR-DETAILS (Form)e08086D1  $ P9_05_AGO_200203_04_25BEGIN #begin pkg_frm.bold_button; end;  END;WHEN-NEW-BLOCK-INSTANCE (Form)0800 P008086D"1  $ P11_05_AGO_200203_04_25BEGIN Sbegin if (:system.mode = 'NORMAL') then go_block('dtgc'); end if; end;  END;WHEN-BUTTON-PRESSED (MAIN.DTGC)08086D"1  $ P12_05_AGO_200203_04_25BEGIN Sbegin if (:system.mode = 'NORMAL') then go_block('dvla'); end if; end;  END;WHEN-BUTTON-PRESSED (MAIN.DVLA)08086D"1  $ P13_05_AGO_200203_04_25BEGIN Sbegin if (:system.mode = 'NORMAL') then go_block('dvda'); end if; end;  END;WHEN-BUTTON-PRESSED (MAIN.DVDA)da08086D"1  $ P14_05_AGO_200203_04_25BEGIN Sbegin if (:system.mode = 'NORMAL') then go_block('ccvi'); end if; end;  END;WHEN-BUTTON-PRESSED (MAIN.CCVI)e 0808!6D"1  $ P15_05_AGO_200203_04_25BEGIN Sbegin if (:system.mode = 'NORMAL') then go_block('ccvs'); end if; end;  END;WHEN-BUTTON-PRESSED (MAIN.CCVS) sAdvertncia: A origem no est salva adequadamente no banco de dados. Exportar o texto de origem para um arquivo?> $Nome da tabela deve ser especificadoP N4wCorpo do gatilho deve ser um cdigo PL/SQL completo.G E+wInstruo de gatilho deve ser especificada.@ >$No est editando um gatilho vlido."  CREATE- +CREATE OR REPLACE# !wTRIGGER"  wBEFORE! ::_AFTER ni spONre( &IN FOR EACH ROW   WHEN N ' % : wREFERENCINGm"  |_OLD AS> "  prNEW ASna ::OFun- +.<_DROP TRIGGER %s; ::=) 'KA BEGIN END;CED% #io TRIG_%03u ACG E{ +wRealmente deseja descontinuar o gatilho %s? F D= *Unidade de programa deve ser especificada.B @&Nmero da linha deve ser especificado.0P N4wCorpo do gatilho deve ser um cdigo PL/SQL completo., *_. v tZO Quick Tour no pde ser localizado. Por favor, reinstale o Quick Tour e tente novamente.0, *Abrindo arquivo.A ? %wNo foi possvel localizar o arquivo.S Q 7wNo possvel truncar um arquivo que s pode ser lido.$0@00"`0000string0000000000000000000000000000P h0r<hh: (FRM50_BUFFER table contains user's buffer.hh,ROSATTRIBSclass attributes8+hh)ROSLFDESCros lf descrip)hh'50ROSOBJMAPros name->id+hh) *ROSSTRINGStk2 uiStrings*hh( (ROSSTRUCTSstruct types@*hh(ROSTK2RESVtk2 reservedb7PhhN8TOOL_MODULEtable contains information about different module$pp"b7VG_COLORVG_COLOR+pp $&'()VG_COLORITEMID@+pp $&'()VG_COLORCELLID@-pp &()*+VG_COLORNAME_SET@ /pp (*+,-VG_COLORNAME_LENGTH /pp (*+,-VG_COLORCOLOR_NAMEx'pp "#$%VG_COLORRED )pp "$%&'VG_COLORGREEN 88b)pp "$%&'VG_COLORBLUE 0g808086D1  $ P0_05_AGO_200203_04_25BEGIN %begin pkg_frm_trg.post_form; end;  END;POST-FORM (Form)08086D1  $ P1_05_AGO_200203_04_25BEGIN $begin pkg_frm_trg.key_menu; end;  END;KEY-MENU (Form)st08086D1  $ P2_05_AGO_200203_04_25BEGIN &begin pkg_frm_trg.on_message; end;  END;ON-MESSAGE (Form) (0808 6D1  $ P3_05_AGO_200203_04_25BEGIN %begin pkg_frm_trg.key_clrfrm; end; END;KEY-CLRFRM (Form)0808 6D1  $ P4_05_AGO_200203_04_25BEGIN Zbegin pkg_frm.set_env; pkg_frm_trg.pre_form; :system.message_level := '10'; end;  END;PRE-FORM (Form)0808 6D1  $ P5_05_AGO_200203_04_25BEGIN #begin pkg_frm_trg.on_error; end; END;ON-ERROR (Form)* ,08086D1  $ P6_05_AGO_200203_04_25BEGIN %begin pkg_frm_trg.key_print; end;  END;KEY-PRINT (Form)08086D1  $ P7_05_AGO_200203_04_25BEGIN $begin pkg_frm_trg.key_help; end;  END;KEY-HELP (Form) ,. 00r88g100b75208x * , .0 00r100g100b75US.08x' ( *,US 00r0g100b88008x ( * ,._2 00r25g100b88@008x ( * ,. 00r50g100b88008x ( * ,.ST 00r75g100b88008x ( * ,.  00r88g100b88208x * , .0 00r100g100b88008x( * ,. 00r0g100b100208x * , .020 00r25g100b100@_2208x * , .0_A 00r50g100b1006_208x * , .0 00r75g100b100208x * , .05 00r88g100b10004208x * , .0 00r100g100b100--*:BFe(f jnp(z~(((v_ SQL*FormstFORM50C:\nulaya\hpg\fmb\nkw_dnt.fmbntxg:6رxg:6;Copyright (c) Oracle Corporation 1990. All Rights Reserved.; (0in*b (0gt+  (0--,------------------------------------------------------- -- SET_ENV ------------------------------------------------------------------ procedure set_env; ---------------------------------------------------------- -- BOLD_BUTTON ---------------------------------------------------------- procedure bold_button; end pkg_frm;0800Rstring0000000000000000000000000000`H0r0808#6D"1  $ P16_05_AGO_200203_04_25BEGIN Sbegin if (:system.mode = 'NORMAL') then go_block('ccvr'); end if; end;  END;WHEN-BUTTON-PRESSED (MAIN.CCVR)0808%6D"1  $ P17_05_AGO_200203_04_25BEGIN Sbegin if (:system.mode = 'NORMAL') then go_block('ccvc'); end if; end;  END;WHEN-BUTTON-PRESSED (MAIN.CCVC)-0808'6D"1  $ P18_05_AGO_200203_04_25BEGIN Sbegin if (:system.mode = 'NORMAL') then go_block('eapb'); end if; end;  END;WHEN-BUTTON-PRESSED (MAIN.EAPB)60808)6D"1  $ P19_05_AGO_200203_04_25BEGIN Sbegin if (:system.mode = 'NORMAL') then go_block('eppc'); end if; end;  END;WHEN-BUTTON-PRESSED (MAIN.EPPC)0808+6D1  $ yP20_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-NXTREC (DTGC)0020808-6D1  $ wP21_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-DOWN (DTGC)0808/6D1  $ yP22_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-CLRREC (DTGC)1080816D1  $ yP23_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-NXTSET (DTGC)FOR080836D1  $ zP24_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-SCRDOWN (DTGC)ON-ERROR (Form)xto08086D1  $ P6_05_AGO_200203_04_25BEGIN %begin pkg_frm_trg.key_print; end;  END;KEY-PRINT (Form)08086D1  $ P7_05_AGO_200203_04_25BEGIN $begin pkg_frm_trg.key_help; end;  END;KEY-HELP (Form)um cdigo PL/SQL completo.G E+wInstruo de gatilho deve ser especificada.@ >$No est editando um gatilho vlido."  CREATE- +CREATE OR REPLACE# !wTRIGGER"  wBEFORE! ::_AFTER ni spONre( &IN FOR EACH ROW   WHEN N ' % : wREFERENCINGm"  |_OLD AS> "  prNEW ASna ::OFun- +.<_DROP TRIGGER %s; ::=) 'KA BEGIN END;CED% #io TRIG_%03u ACG E{ +wRealmente deseja descontinuar o gatilho %s? F D= *Unidade de programa deve ser especificada.B @&Nmero da linha deve ser especificado.0P N4wCorpo do gatilho deve ser um cdigo PL/SQL completo., *_. v tZO Quick Tour no pde ser localizado. Por favor, reinstale o Quick Tour e tente novamente.0, *Abrindo arquivo.A ? %wNo foi possvel localizar o arquivo.S Q 7wNo possvel truncar um arquivo que s pode ser lido.$0@00"`0000string0000000000000000000000000000p0r 0808 56D 1  $ P25_05_AGO_200203_04_25BEGIN Ybegin if (:log.column_id is not null) then begin declare cursor get_cur is select a.column_name from user_tab_columns a where (a.table_name = :main.table_name) and (a.column_id = :log.column_id); begin if (not get_cur%ISOPEN) then open get_cur; end if; fetch get_cur into :log.column_name; if (get_cur%NOTFOUND) then :dvda.column_name := null; synchronize; pkg_frm_obj.message('Column does not exists on table.'); raise form_trigger_failure; end if; if (get_cur%ISOPEN) then close get_cur; end if; end; end; else :log.column_name := null; end if; end;  END;"WHEN-VALIDATE-ITEM (LOG.COLUMN_ID)6D1  $ yP20_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-NXTREC (DTGC)0020808-6D1  $ wP21_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-DOWN (DTGC)0808/6D1  $ yP22_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-CLRREC (DTGC)1080816D1  $ yP23_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-NXTSET (DTGC)FOR080836D1  $ zP24_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-SCRDOWN (DTGC)ON-ERROR (Form)xto08086D1  $ P6_05_AGO_200203_04_25BEGIN %begin pkg_frm_trg.key_print; end;  END;KEY-PRINT (Form)08086D1  $ P7_05_AGO_200203_04_25BEGIN $begin pkg_frm_trg.key_help; end;  END;KEY-HELP (Form)um cdigo PL/SQL completo.G E+wInstruo de gatilho deve ser especificada.@ >$No est editando um gatilho vlido."  CREATE- +CREATE OR REPLACE# !wTRIGGER"  wBEFORE! ::_AFTER ni spONre( &IN FOR EACH ROW   WHEN N ' % : wREFERENCINGm"  |_OLD AS> "  prNEW ASna ::OFun- +.<_DROP TRIGGER %s; ::=) 'KA BEGIN END;CED% #io TRIG_%03u ACG E{ +wRealmente deseja descontinuar o gatilho %s? F D= *Unidade de programa deve ser especificada.B @&Nmero da linha deve ser especificado.0P N4wCorpo do gatilho deve ser um cdigo PL/SQL completo., *_. v tZO Quick Tour no pde ser localizado. Por favor, reinstale o Quick Tour e tente novamente.0, *Abrindo arquivo.A ? %wNo foi possvel localizar o arquivo.S Q 7wNo possvel truncar um arquivo que s pode ser lido.$0@00"`0000string00000000000000000000000000000r080876D 1  $ P26_05_AGO_200203_04_25BEGIN cbegin if (:dvla.column_id is not null) then begin declare cursor get_cur is select a.column_name from user_tab_columns a where (a.table_name = :main.table_name) and (a.column_id = :dvla.column_id); begin if (not get_cur%ISOPEN) then open get_cur; end if; fetch get_cur into :dvla.column_name; if (get_cur%NOTFOUND) then bell; :dvla.column_name := null; synchronize; pkg_frm_obj.message('Column does not exists on table.'); raise form_trigger_failure; end if; if (get_cur%ISOPEN) then close get_cur; end if; end; end; else :dvla.column_name := null; end if; end;  END;#WHEN-VALIDATE-ITEM (DVLA.COLUMN_ID)1  $ yP20_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-NXTREC (DTGC)0020808-6D1  $ wP21_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-DOWN (DTGC)0808/6D1  $ yP22_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-CLRREC (DTGC)1080816D1  $ yP23_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-NXTSET (DTGC)FOR080836D1  $ zP24_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-SCRDOWN (DTGC)ON-ERROR (Form)xto08086D1  $ P6_05_AGO_200203_04_25BEGIN %begin pkg_frm_trg.key_print; end;  END;KEY-PRINT (Form)08086D1  $ P7_05_AGO_200203_04_25BEGIN $begin pkg_frm_trg.key_help; end;  END;KEY-HELP (Form)um cdigo PL/SQL completo.G E+wInstruo de gatilho deve ser especificada.@ >$No est editando um gatilho vlido."  CREATE- +CREATE OR REPLACE# !wTRIGGER"  wBEFORE! ::_AFTER ni spONre( &IN FOR EACH ROW   WHEN N ' % : wREFERENCINGm"  |_OLD AS> "  prNEW ASna ::OFun- +.<_DROP TRIGGER %s; ::=) 'KA BEGIN END;CED% #io TRIG_%03u ACG E{ +wRealmente deseja descontinuar o gatilho %s? F D= *Unidade de programa deve ser especificada.B @&Nmero da linha deve ser especificado.0P N4wCorpo do gatilho deve ser um cdigo PL/SQL completo., *_. v tZO Quick Tour no pde ser localizado. Por favor, reinstale o Quick Tour e tente novamente.0, *Abrindo arquivo.A ? %wNo foi possvel localizar o arquivo.S Q 7wNo possvel truncar um arquivo que s pode ser lido.$0@00"`0000string00000000000000000000000000000r080896D 1  $ P27_05_AGO_200203_04_25BEGIN cbegin if (:dvda.column_id is not null) then begin declare cursor get_cur is select a.column_name from user_tab_columns a where (a.table_name = :main.table_name) and (a.column_id = :dvda.column_id); begin if (not get_cur%ISOPEN) then open get_cur; end if; fetch get_cur into :dvda.column_name; if (get_cur%NOTFOUND) then bell; :dvda.column_name := null; synchronize; pkg_frm_obj.message('Column does not exists on table.'); raise form_trigger_failure; end if; if (get_cur%ISOPEN) then close get_cur; end if; end; end; else :dvda.column_name := null; end if; end;  END;#WHEN-VALIDATE-ITEM (DVDA.COLUMN_ID)1  $ yP20_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-NXTREC (DTGC)0020808-6D1  $ wP21_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-DOWN (DTGC)0808/6D1  $ yP22_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-CLRREC (DTGC)1080816D1  $ yP23_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-NXTSET (DTGC)FOR080836D1  $ zP24_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-SCRDOWN (DTGC)ON-ERROR (Form)xto08086D1  $ P6_05_AGO_200203_04_25BEGIN %begin pkg_frm_trg.key_print; end;  END;KEY-PRINT (Form)08086D1  $ P7_05_AGO_200203_04_25BEGIN $begin pkg_frm_trg.key_help; end;  END;KEY-HELP (Form)um cdigo PL/SQL completo.G E+wInstruo de gatilho deve ser especificada.@ >$No est editando um gatilho vlido."  CREATE- +CREATE OR REPLACE# !wTRIGGER"  wBEFORE! ::_AFTER ni spONre( &IN FOR EACH ROW   WHEN N ' % : wREFERENCINGm"  |_OLD AS> "  prNEW ASna ::OFun- +.<_DROP TRIGGER %s; ::=) 'KA BEGIN END;CED% #io TRIG_%03u ACG E{ +wRealmente deseja descontinuar o gatilho %s? F D= *Unidade de programa deve ser especificada.B @&Nmero da linha deve ser especificado.0P N4wCorpo do gatilho deve ser um cdigo PL/SQL completo., *_. v tZO Quick Tour no pde ser localizado. Por favor, reinstale o Quick Tour e tente novamente.0, *Abrindo arquivo.A ? %wNo foi possvel localizar o arquivo.S Q 7wNo possvel truncar um arquivo que s pode ser lido.$0@00"`0000string00000000000000000000000000000r0808;6D 1  $ P28_05_AGO_200203_04_25BEGIN cbegin if (:ccvi.column_id is not null) then begin declare cursor get_cur is select a.column_name from user_tab_columns a where (a.table_name = :main.table_name) and (a.column_id = :ccvi.column_id); begin if (not get_cur%ISOPEN) then open get_cur; end if; fetch get_cur into :ccvi.column_name; if (get_cur%NOTFOUND) then bell; :ccvi.column_name := null; synchronize; pkg_frm_obj.message('Column does not exists on table.'); raise form_trigger_failure; end if; if (get_cur%ISOPEN) then close get_cur; end if; end; end; else :ccvi.column_name := null; end if; end;  END;#WHEN-VALIDATE-ITEM (CCVI.COLUMN_ID)1  $ yP20_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-NXTREC (DTGC)0020808-6D1  $ wP21_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-DOWN (DTGC)0808/6D1  $ yP22_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-CLRREC (DTGC)1080816D1  $ yP23_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-NXTSET (DTGC)FOR080836D1  $ zP24_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-SCRDOWN (DTGC)ON-ERROR (Form)xto08086D1  $ P6_05_AGO_200203_04_25BEGIN %begin pkg_frm_trg.key_print; end;  END;KEY-PRINT (Form)08086D1  $ P7_05_AGO_200203_04_25BEGIN $begin pkg_frm_trg.key_help; end;  END;KEY-HELP (Form)um cdigo PL/SQL completo.G E+wInstruo de gatilho deve ser especificada.@ >$No est editando um gatilho vlido."  CREATE- +CREATE OR REPLACE# !wTRIGGER"  wBEFORE! ::_AFTER ni spONre( &IN FOR EACH ROW   WHEN N ' % : wREFERENCINGm"  |_OLD AS> "  prNEW ASna ::OFun- +.<_DROP TRIGGER %s; ::=) 'KA BEGIN END;CED% #io TRIG_%03u ACG E{ +wRealmente deseja descontinuar o gatilho %s? F D= *Unidade de programa deve ser especificada.B @&Nmero da linha deve ser especificado.0P N4wCorpo do gatilho deve ser um cdigo PL/SQL completo., *_. v tZO Quick Tour no pde ser localizado. Por favor, reinstale o Quick Tour e tente novamente.0, *Abrindo arquivo.A ? %wNo foi possvel localizar o arquivo.S Q 7wNo possvel truncar um arquivo que s pode ser lido.$0@00"`0000string00000000000000000000000000000r0808=6D 1  $ P29_05_AGO_200203_04_25BEGIN cbegin if (:ccvs.column_id is not null) then begin declare cursor get_cur is select a.column_name from user_tab_columns a where (a.table_name = :main.table_name) and (a.column_id = :ccvs.column_id); begin if (not get_cur%ISOPEN) then open get_cur; end if; fetch get_cur into :ccvs.column_name; if (get_cur%NOTFOUND) then bell; :ccvs.column_name := null; synchronize; pkg_frm_obj.message('Column does not exists on table.'); raise form_trigger_failure; end if; if (get_cur%ISOPEN) then close get_cur; end if; end; end; else :ccvs.column_name := null; end if; end;  END;#WHEN-VALIDATE-ITEM (CCVS.COLUMN_ID)1  $ yP20_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-NXTREC (DTGC)0020808-6D1  $ wP21_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-DOWN (DTGC)0808/6D1  $ yP22_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-CLRREC (DTGC)1080816D1  $ yP23_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-NXTSET (DTGC)FOR080836D1  $ zP24_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-SCRDOWN (DTGC)ON-ERROR (Form)xto08086D1  $ P6_05_AGO_200203_04_25BEGIN %begin pkg_frm_trg.key_print; end;  END;KEY-PRINT (Form)08086D1  $ P7_05_AGO_200203_04_25BEGIN $begin pkg_frm_trg.key_help; end;  END;KEY-HELP (Form)um cdigo PL/SQL completo.G E+wInstruo de gatilho deve ser especificada.@ >$No est editando um gatilho vlido."  CREATE- +CREATE OR REPLACE# !wTRIGGER"  wBEFORE! ::_AFTER ni spONre( &IN FOR EACH ROW   WHEN N ' % : wREFERENCINGm"  |_OLD AS> "  prNEW ASna ::OFun- +.<_DROP TRIGGER %s; ::=) 'KA BEGIN END;CED% #io TRIG_%03u ACG E{ +wRealmente deseja descontinuar o gatilho %s? F D= *Unidade de programa deve ser especificada.B @&Nmero da linha deve ser especificado.0P N4wCorpo do gatilho deve ser um cdigo PL/SQL completo., *_. v tZO Quick Tour no pde ser localizado. Por favor, reinstale o Quick Tour e tente novamente.0, *Abrindo arquivo.A ? %wNo foi possvel localizar o arquivo.S Q 7wNo possvel truncar um arquivo que s pode ser lido.$0@00"`0000string00000000000000000000000000000r0808?6D 1  $ P30_05_AGO_200203_04_25BEGIN cbegin if (:ccvr.column_id is not null) then begin declare cursor get_cur is select a.column_name from user_tab_columns a where (a.table_name = :main.table_name) and (a.column_id = :ccvr.column_id); begin if (not get_cur%ISOPEN) then open get_cur; end if; fetch get_cur into :ccvr.column_name; if (get_cur%NOTFOUND) then bell; :ccvr.column_name := null; synchronize; pkg_frm_obj.message('Column does not exists on table.'); raise form_trigger_failure; end if; if (get_cur%ISOPEN) then close get_cur; end if; end; end; else :ccvr.column_name := null; end if; end;  END;#WHEN-VALIDATE-ITEM (CCVR.COLUMN_ID)1  $ yP20_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-NXTREC (DTGC)0020808-6D1  $ wP21_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-DOWN (DTGC)0808/6D1  $ yP22_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-CLRREC (DTGC)1080816D1  $ yP23_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-NXTSET (DTGC)FOR080836D1  $ zP24_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-SCRDOWN (DTGC)ON-ERROR (Form)xto08086D1  $ P6_05_AGO_200203_04_25BEGIN %begin pkg_frm_trg.key_print; end;  END;KEY-PRINT (Form)08086D1  $ P7_05_AGO_200203_04_25BEGIN $begin pkg_frm_trg.key_help; end;  END;KEY-HELP (Form)um cdigo PL/SQL completo.G E+wInstruo de gatilho deve ser especificada.@ >$No est editando um gatilho vlido."  CREATE- +CREATE OR REPLACE# !wTRIGGER"  wBEFORE! ::_AFTER ni spONre( &IN FOR EACH ROW   WHEN N ' % : wREFERENCINGm"  |_OLD AS> "  prNEW ASna ::OFun- +.<_DROP TRIGGER %s; ::=) 'KA BEGIN END;CED% #io TRIG_%03u ACG E{ +wRealmente deseja descontinuar o gatilho %s? F D= *Unidade de programa deve ser especificada.B @&Nmero da linha deve ser especificado.0P N4wCorpo do gatilho deve ser um cdigo PL/SQL completo., *_. v tZO Quick Tour no pde ser localizado. Por favor, reinstale o Quick Tour e tente novamente.0, *Abrindo arquivo.A ? %wNo foi possvel localizar o arquivo.S Q 7wNo possvel truncar um arquivo que s pode ser lido.$0@00"`0000string000000000000000000000000000080r0808A6D 1  $ P31_05_AGO_200203_04_25BEGIN cbegin if (:ccvc.column_id is not null) then begin declare cursor get_cur is select a.column_name from user_tab_columns a where (a.table_name = :main.table_name) and (a.column_id = :ccvc.column_id); begin if (not get_cur%ISOPEN) then open get_cur; end if; fetch get_cur into :ccvc.column_name; if (get_cur%NOTFOUND) then bell; :ccvc.column_name := null; synchronize; pkg_frm_obj.message('Column does not exists on table.'); raise form_trigger_failure; end if; if (get_cur%ISOPEN) then close get_cur; end if; end; end; else :ccvc.column_name := null; end if; end;  END;#WHEN-VALIDATE-ITEM (CCVC.COLUMN_ID)0808CBM6( 2 22 2@222P23_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-NXTSET (DTGC)FOR080836D1  $ zP24_05_AGO_200203_04_25BEGIN begin null; end;  END;KEY-SCRDOWN (DTGC)ON-ERROR (Form)xto08086D1  $ P6_05_AGO_200203_04_25BEGIN %begin pkg_frm_trg.key_print; end;  END;KEY-PRINT (Form)08086D1  $ P7_05_AGO_200203_04_25BEGIN $begin pkg_frm_trg.key_help; end;  END;KEY-HELP (Form)um cdigo PL/SQL completo.G E+wInstruo de gatilho deve ser especificada.@ >$No est editando um gatilho vlido."  CREATE- +CREATE OR REPLACE# !wTRIGGER"  wBEFORE! ::_AFTER ni spONre( &IN FOR EACH ROW   WHEN N ' % : wREFERENCINGm"  |_OLD AS> "  prNEW ASna ::OFun- +.<_DROP TRIGGER %s; ::=) 'KA BEGIN END;CED% #io TRIG_%03u ACG E{ +wRealmente deseja descontinuar o gatilho %s? F D= *Unidade de programa deve ser especificada.B @&Nmero da linha deve ser especificado.0P N4wCorpo do gatilho deve ser um cdigo PL/SQL completo., *_. v tZO Quick Tour no pde ser localizado. Por favor, reinstale o Quick Tour e tente novamente.0, *Abrindo arquivo.A ? %wNo foi possvel localizar o arquivo.S Q 7wNo possvel truncar um arquivo que s pode ser lido.$0@00"`0000string0000000000000000000000000000L0r0808EBM6(  $0808GBM6( 2 22 2@22260808IBM6( 80808K6: 1  $ CHECK_PACKAGE_FAILUREvProcedure Check_Package_Failure IS BEGIN IF NOT ( Form_Success ) THEN RAISE Form_Trigger_Failure; END IF; END;808 6D1  $ P5_05_AGO_200203_04_25BEGIN #begin pkg_frm_trg.on_error; end; END;ON-ERROR (Form)* ,08086D1  $ P6_05_AGO_200203_04_25BEGIN %begin pkg_frm_trg.key_print; end;  END;KEY-PRINT (Form)08086D1  $ P7_05_AGO_200203_04_25BEGIN $begin pkg_frm_trg.key_help; end;  END;KEY-HELP (Form) ,. 00r88g100b75208x * , .0 00r100g100b75US.08x' ( *,US 00r0g100b88008x ( * ,._2 00r25g100b88@008x ( * ,. 00r50g100b88008x ( * ,.ST 00r75g100b88008x ( * ,.  00r88g100b88208x * , .0 00r100g100b88008x( * ,. 00r0g100b100208x * , .020 00r25g100b100@_2208x * , .0_A 00r50g100b1006_208x * , .0 00r75g100b100208x * , .05 00r88g100b10004208x * , .0 00r100g100b100--*:BFe(f jnp(z~(((v_ SQL*FormstFORM50C:\nulaya\hpg\fmb\nkw_dnt.fmbntxg:6رxg:6;Copyright (c) Oracle Corporation 1990. All Rights Reserved.; (0in*b (0gt+  (0--,------------------------------------------------------- -- SET_ENV ------------------------------------------------------------------ procedure set_env; ---------------------------------------------------------- -- BOLD_BUTTON ---------------------------------------------------------- procedure bold_button; end pkg_frm;0800Rstring0000000000000000000000000000!l6:  1  $ CLEAR_ALL_MASTER_DETAILSsPROCEDURE Clear_All_Master_Details IS mastblk VARCHAR2(30); -- Initial Master Block Causing Coord coordop VARCHAR2(30); -- Operation Causing the Coord trigblk VARCHAR2(30); -- Cur Block On-Clear-Details Fires On startitm VARCHAR2(61); -- Item in which cursor started frmstat VARCHAR2(15); -- Form Status curblk VARCHAR2(30); -- Current Block currel VARCHAR2(30); -- Current Relation curdtl VARCHAR2(30); -- Current Detail Block FUNCTION First_Changed_Block_Below(Master VARCHAR2) RETURN VARCHAR2 IS curblk VARCHAR2(30); -- Current Block currel VARCHAR2(30); -- Current Relation retblk VARCHAR2(30); -- Return Block BEGIN -- -- Initialize Local Vars -- curblk := Master; currel := Get_Block_Property(curblk, FIRST_MASTER_RELATION); -- -- While there exists another relation for this block -- WHILE currel IS NOT NULL LOOP -- -- Get the name of the detail block -- curblk := Get_Relation_Property(currel, DETAIL_NAME); -- -- If this block has changes, return its name -- IF ( Get_Block_Property(curblk, STATUS) = 'CHANGED' ) THEN RETURN curblk; ELSE -- -- No changes, recursively look for changed blocks below -- retblk := First_Changed_Block_Below(curblk); -- -- If some block below is changed, return its name -- IF retblk IS NOT NULL THEN RETURN retblk; ELSE -- -- Consider the next relation -- currel := Get_Relation_Property(currel, NEXT_MASTER_RELATION); END IF; END IF; END LOOP; -- -- No changed blocks were found -- RETURN NULL; END First_Changed_Block_Below; BEGIN -- -- Init Local Vars -- mastblk := :System.Master_Block; coordop := :System.Coordination_Operation; trigblk := :System.Trigger_Block; startitm := :System.Cursor_Item; frmstat := :System.Form_Status; -- -- If the coordination operation is anything but CLEAR_RECORD or -- SYNCHRONIZE_BLOCKS, then continue checking. -- IF coordop NOT IN ('CLEAR_RECORD', 'SYNCHRONIZE_BLOCKS') THEN -- -- If we're processing the driving master block... -- IF mastblk = trigblk THEN -- -- If something in the form is changed, find the -- first changed block below the master -- IF frmstat = 'CHANGED' THEN curblk := First_Changed_Block_Below(mastblk); -- -- If we find a changed block below, go there -- and Ask to commit the changes. -- IF curblk IS NOT NULL THEN Go_Block(curblk); Check_Package_Failure; Clear_Block(ASK_COMMIT); -- -- If user cancels commit dialog, raise error -- IF NOT ( :System.Form_Status = 'QUERY' OR :System.Block_Status = 'NEW' ) THEN RAISE Form_Trigger_Failure; END IF; END IF; END IF; END IF; END IF; -- -- Clear all the detail blocks for this master without -- any further asking to commit. -- currel := Get_Block_Property(trigblk, FIRST_MASTER_RELATION); WHILE currel IS NOT NULL LOOP curdtl := Get_Relation_Property(currel, DETAIL_NAME); IF Get_Block_Property(curdtl, STATUS) <> 'NEW' THEN Go_Block(curdtl); Check_Package_Failure; Clear_Block(NO_VALIDATE); IF :System.Block_Status <> 'NEW' THEN RAISE Form_Trigger_Failure; END IF; END IF; currel := Get_Relation_Property(currel, NEXT_MASTER_RELATION); END LOOP; -- -- Put cursor back where it started -- IF :System.Cursor_Item <> startitm THEN Go_Item(startitm); Check_Package_Failure; END IF; EXCEPTION WHEN Form_Trigger_Failure THEN IF :System.Cursor_Item <> startitm THEN Go_Item(startitm); END IF; RAISE; END Clear_All_Master_Details; HH#l6:1  $ PKG_FRMipackage body pkg_frm is ------------------------------------------------------------------ ----------------------- Private Session -------------------------- ------------------------------------------------------------------ ------------------------------------------------------------------ ------------------------ Public Session -------------------------- ------------------------------------------------------------------ ------------------------------------------------------------------ -- SET_ENV ------------------------------------------------------------------ procedure set_env is begin pkg_frm_env.gv_module := gv_module; pkg_frm_env.gv_version := gv_version; pkg_frm_env.gv_comments := gv_comments; end set_env; ---------------------------------------------------------- -- BOLD_BUTTON ---------------------------------------------------------- procedure bold_button is lv_this varchar2(80); lv_item item; i binary_integer; begin if (not gt_button.exists(gt_button.first)) then gt_button(1) := 'MAIN.DTGC'; gt_button(2) := 'MAIN.DVLA'; gt_button(3) := 'MAIN.DVDA'; gt_button(4) := 'MAIN.CCVI'; gt_button(5) := 'MAIN.CCVS'; gt_button(6) := 'MAIN.CCVR'; gt_button(7) := 'MAIN.CCVC'; gt_button(8) := 'MAIN.EPPC'; gt_button(9) := 'MAIN.EAPB'; end if; lv_this := 'MAIN.' || :system.current_block; i := gt_button.first; while (i is not null) loop lv_item := find_item(gt_button(i)); if (lv_this = gt_button(i)) then set_item_property(lv_item, visual_attribute, 'bold'); else set_item_property(lv_item, visual_attribute, ''); end if; i := gt_button.next(i); end loop; end bold_button; end pkg_frm;wvgibpswindow vgibexwindow  .vgibecwindow  vgmisq_helpstringvgiicp11stringvgiicp9stringvgmimgstringomvgmissstringkiosfstring_]picstring[YogbstringTRogdstringRPvgnoprstringQOvgeirsldstringJHlayerstringIGvgeicgmistringA?vgegftrnstring86vgecnogpstring+)vgeimemstring vgibslwindowvgiblywindow vgibaowindow0vgmitx_helpstringvgmirt_helpstringvgmigr_helpstringvgiicp8stringvgiib1stringvgiiedstring|zallfilestringgepalstring][vgeucscfstring;9vgecmtogstring20vgiblwwindow   vgibdtwindow *vgibdgwindow2vgibdbwindow"vgibdawindowvgiicp13stringvgiicp2stringvgmisqstringxvokstringHFvgiaccszstringECundostringvgiicp12stringvgiicp10stringvgmielstringsqvgmisrstringmksqlstringb`vgmior_helpstringvgmied_helpstringvgmiplstringvttxtstringa_vgegfildstringB@vgianalystring'%vgiangtvstring&$vgiassbgstringvgegtlktstringvgeicpalstringvgmipl_help @0r0808M6: 1  $ QUERY_MASTER_DETAILSRPROCEDURE Query_Master_Details(rel_id Relation,detail VARCHAR2) IS oldmsg VARCHAR2(2); -- Old Message Level Setting reldef VARCHAR2(5); -- Relation Deferred Setting BEGIN -- -- Initialize Local Variable(s) -- reldef := Get_Relation_Property(rel_id, DEFERRED_COORDINATION); oldmsg := :System.Message_Level; -- -- If NOT Deferred, Goto detail and execute the query. -- IF reldef = 'FALSE' THEN Go_Block(detail); Check_Package_Failure; :System.Message_Level := '10'; Execute_Query; :System.Message_Level := oldmsg; ELSE -- -- Relation is deferred, mark the detail block as un-coordinated -- Set_Block_Property(detail, COORDINATION_STATUS, NON_COORDINATED); END IF; EXCEPTION WHEN Form_Trigger_Failure THEN :System.Message_Level := oldmsg; RAISE; END Query_Master_Details; 0800N0808Q6:1  $ yPKG_FRMDpackage pkg_frm is ------------------------------------------------------------------ -- Variables, Records, Constants, Exceptions, PL/SQL Tables... ------------------------------------------------------------------ gv_module constant varchar2(40) := 'NKW_DNT'; gv_version constant varchar2(10) := '2.0.2'; gv_comments constant varchar2(80) := 'Dynamic Triggers'; type tab_button is table of varchar2(80) index by binary_integer; gt_button tab_button; ------------------------------------------------------------------ -- SET_ENV ------------------------------------------------------------------ procedure set_env; ---------------------------------------------------------- -- BOLD_BUTTON ---------------------------------------------------------- procedure bold_button; end pkg_frm;0800R$0@00"Tp`$0@00"Vp` 0800X/p0808YSTATUS/CLEAR_ALL_MASTER_DETAILS0ld0C DEFGH0ASYSTEM.BLOCK_STATUSSYSTEM.BLOCK_STATUS0CLEAR_ALL_MASTER_DETAILS14d1PC!DEFGH1lASYSTEM.RECORD_STATUSSYSTEM.RECORD_STATUS1P10_05_AGO_200203_04_251d2C"DEFG H2$ASYSTEM.MODESYSTEM.MODE 222233$3D3d3P11_05_AGO_200203_04_25P12_05_AGO_200203_04_25P13_05_AGO_200203_04_25P14_05_AGO_200203_04_25P15_05_AGO_200203_04_25P16_05_AGO_200203_04_25P17_05_AGO_200203_04_25P18_05_AGO_200203_04_25P19_05_AGO_200203_04_25$00x !"--black--------------------------------------------- gv_module constant varchar2(40) := 'NKW_DNT'; gv_version constant varchar2(10) := '2.0.2'; gv_comments constant varchar2(80) := 'Dynamic Triggers'; type tab_button is table of varchar2(80) index by binary_integer; gt_button tab_button; ------------------------------------------------------------------ -- SET_ENV ------------------------------------------------------------------ procedure set_env; ---------------------------------------------------------- -- BOLD_BUTTON ---------------------------------------------------------- procedure bold_button; end pkg_frm;0800Rstring0000000000000000000000000000 0r(00x " $&white%00x "#greenAST)00x# $&'E  darkgreenils(00x " $&RCgray96 = = =(00x " $&sagray92zzz(00x " $& Rgray88(00x " $&nigray84(((%00x !"# Gr0g0b0rop(00x "$%&DI r25g0b0@(00x "$%&; r50g0b0(00x "$%& e r75g0b0(00x "$%&E' r88g0b0(00x "$%&ag r100g0b0(00x!" $&0'r0g0b50*00x "$ &(evr25g0b50@SE*00x "$ &( dr50g0b50de*00x "$ &(edr75g0b50oc*00x "$ &(ATr88g0b50OR,00x $& (*TI r100g0b50(00x!" $&ysr0g0b75*00x "$ &(ENr25g0b75@ai*00x "$ &(8r50g0b75*00x "$ &(r75g0b751*00x "$ &(PKr88g0b75ge,00x $& (*-- r100g0b75(00x!" $&--r0g0b88*00x "$ &( Er25g0b88@Ta*00x "$ &(--r50g0b88--*00x "$ &(--r75g0b88on*00x "$ &(_Dr88g0b88 ,00x $& (*2. r100g0b88(00x"# $&'D r0g0b100,00x $& (*bl! r25g0b100@,00x $& (*gt" r50g0b100,00x $& (*--# r75g0b100,00x $& (*--$ r88g0b100,00x $& (*--% r100g0b100&00x  "$t_&gray--*00x " $ &(--'darkgray--&00x "$--(cyanr--*00x" $ &(--)darkcyaned(00x " $&rm*gray80333333(00x " $&+gray76=p=p=p00"Tp`$0@00"Vp` 0800X/p0808YSTATUS/CLEAR_ALL_MASTER_DETAILS0ld0C DEFGH0ASYSTEM.BLOCK_STATUSSYSTEM.BLOCK_STATUS0CLEAR_ALL_MASTER_DETAILS14d1PC!DEFGH1lASYSTEM.RECORD_STATUSSYSTEM.RECORD_STATUS1P10_05_AGO_200203_04_251d2C"DEFG H2$ASYSTEM.MODESYSTEM.MODE 222233$3D3d3P11_05_AGO_200203_04_25P12_05_AGO_200203_04_25P13_05_AGO_200203_04_25P14_05_AGO_200203_04_25P15_05_AGO_200203_04_25P16_05_AGO_200203_04_25P17_05_AGO_200203_04_25P18_05_AGO_200203_04_25P19_05_AGO_200203_04_25$00x !"--black--------------------------------------------- gv_module constant varchar2(40) := 'NKW_DNT'; gv_version constant varchar2(10) := '2.0.2'; gv_comments constant varchar2(80) := 'Dynamic Triggers'; type tab_button is table of varchar2(80) index by binary_integer; gt_button tab_button; ------------------------------------------------------------------ -- SET_ENV ------------------------------------------------------------------ procedure set_env; ---------------------------------------------------------- -- BOLD_BUTTON ---------------------------------------------------------- procedure bold_button; end pkg_frm;0800Rstring000000000000000000000000000000r(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%E .r0g25b0@)00x " $&' $/r25g25b0@@= =)00x " $&'sa0r50g25b0@)00x " $&'1r75g25b0@()00x " $&'ay2r88g25b0@0+00x $ &()3 r100g25b0@*00x" $ &(4r0g25b50@ ",00x $ & (*5 r25g25b50@@,00x $ & (*6 r50g25b50@,00x $ & (*07 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (* "9 r100g25b50@*00x" $ &( ":r0g25b750@50,00x $ & (* "; r25g25b75@@,00x $ & (* "< r50g25b75@,00x $ & (* $= r75g25b75@,00x $ & (*!> r88g25b75@,00x $ & (* &? r100g25b75@*00x" $ &( &@r0g25b885@,00x $ & (* &A r25g25b88@@,00x $ & (* &B r50g25b88@,00x $ & (* (C r75g25b88@,00x $ & (* $D r88g25b88@,00x $ & (* EE r100g25b88@*00x# $ &(--F r0g25b100@--,00x $ & (*--G r25g25b100@@,00x $ & (*_DH r50g25b100@,00x $ & (*2.I r75g25b100@,00x $ & (*'DJ r88g25b100@.00x & ( *, K r100g25b100@$00x  !"0gLred(00x "$%&--Mdarkred$00x " (Nblue(00x"# $&Odarkblue(00x " $&0Pgray64\(\(\((00x " $&0Qgray60ffffff(00x " $&Rgray56ppp(00x " $&Sgray52zzz'00x! "$%Tr0g50b0 )00x " $&'Ur25g50b0@" $)00x " $&'"Vr50g50b0`$0@00"Vp` 0800X/p0808YSTATUS/CLEAR_ALL_MASTER_DETAILS0ld0C DEFGH0ASYSTEM.BLOCK_STATUSSYSTEM.BLOCK_STATUS0CLEAR_ALL_MASTER_DETAILS14d1PC!DEFGH1lASYSTEM.RECORD_STATUSSYSTEM.RECORD_STATUS1P10_05_AGO_200203_04_251d2C"DEFG H2$ASYSTEM.MODESYSTEM.MODE 222233$3D3d3P11_05_AGO_200203_04_25P12_05_AGO_200203_04_25P13_05_AGO_200203_04_25P14_05_AGO_200203_04_25P15_05_AGO_200203_04_25P16_05_AGO_200203_04_25P17_05_AGO_200203_04_25P18_05_AGO_200203_04_25P19_05_AGO_200203_04_25$00x !"--black--------------------------------------------- gv_module constant varchar2(40) := 'NKW_DNT'; gv_version constant varchar2(10) := '2.0.2'; gv_comments constant varchar2(80) := 'Dynamic Triggers'; type tab_button is table of varchar2(80) index by binary_integer; gt_button tab_button; ------------------------------------------------------------------ -- SET_ENV ------------------------------------------------------------------ procedure set_env; ---------------------------------------------------------- -- BOLD_BUTTON ---------------------------------------------------------- procedure bold_button; end pkg_frm;0800Rstring0000000000000000000000000000@0r)00x " $&'Wr75g50b0)00x " $&'Xr88g50b0'+00x $ &()g2Y r100g50b0*00x" $ &(b0Zr0g50b500,00x $ & (*b0[ r25g50b50@,00x $ & (*b0\ r50g50b50,00x $ & (*b0] r75g50b50,00x $ & (*5b^ r88g50b50,00x $ & (*50_ r100g50b50*00x" $ &(b5`r0g50b7500,00x $ & (*b5a r25g50b75@,00x $ & (*b5b r50g50b75,00x $ & (*b5c r75g50b75,00x $ & (*5bd r88g50b75,00x $ & (*75e r100g50b75*00x" $ &(b7fr0g50b8850,00x $ & (*b7g r25g50b88@,00x $ & (*b7h r50g50b88,00x $ & (*b7i r75g50b88,00x $ & (*5bj r88g50b88,00x $ & (*88k r100g50b88*00x# $ &(b8l r0g50b1000,00x $ & (*b8m r25g50b100@,00x $ & (*b8n r50g50b100,00x $ & (*b8o r75g50b100,00x $ & (*5bp r88g50b100.00x & ( *,10q r100g50b100'00x "$%@ryellow+00x $ &()b1s darkyellow*00x "$ &(b1tmagenta0.00x &( *,b1u darkmagenta(00x " $&0vgray48(00x " $&dwgray44\\\(00x " $&dxgray40(00x " $&ygray36ףף'00x! "$%zr0g75b0)00x " $&'\({r25g75b0@ )00x " $&'|r50g75b0" $)00x " $&'}r75g75b0&)00x " $&'0~r88g75b0T+00x $ &() r100g75b0g.08x& ( *,00r0g75b50b0`$0@00"Vp` 0800X/p0808YSTATUS/CLEAR_ALL_MASTER_DETAILS0ld0C DEFGH0ASYSTEM.BLOCK_STATUSSYSTEM.BLOCK_STATUS0CLEAR_ALL_MASTER_DETAILS14d1PC!DEFGH1lASYSTEM.RECORD_STATUSSYSTEM.RECORD_STATUS1P10_05_AGO_200203_04_251d2C"DEFG H2$ASYSTEM.MODESYSTEM.MODE 222233$3D3d3P11_05_AGO_200203_04_25P12_05_AGO_200203_04_25P13_05_AGO_200203_04_25P14_05_AGO_200203_04_25P15_05_AGO_200203_04_25P16_05_AGO_200203_04_25P17_05_AGO_200203_04_25P18_05_AGO_200203_04_25P19_05_AGO_200203_04_25$00x !"--black--------------------------------------------- gv_module constant varchar2(40) := 'NKW_DNT'; gv_version constant varchar2(10) := '2.0.2'; gv_comments constant varchar2(80) := 'Dynamic Triggers'; type tab_button is table of varchar2(80) index by binary_integer; gt_button tab_button; ------------------------------------------------------------------ -- SET_ENV ------------------------------------------------------------------ procedure set_env; ---------------------------------------------------------- -- BOLD_BUTTON ---------------------------------------------------------- procedure bold_button; end pkg_frm;0800Rstring0000000000000000000000000000P0r008x ( * ,.` 00r25g75b50@008x ( * ,. 00r50g75b50008x ( * ,.8 00r75g75b50008x ( * ,.50 00r88g75b50008x ( * ,.@ 00r100g75b50.08x& ( *,00r0g75b750008x ( * ,.ay 00r25g75b75@008x ( * ,. 00r50g75b75008x ( * ,.8 00r75g75b75008x ( * ,. 00r88g75b75008x ( * ,. $ 00r100g75b75.08x& ( *, (00r0g75b885008x ( * ,.5b 00r25g75b88@008x ( * ,.  00r50g75b88008x ( * ,.g5 00r75g75b88008x ( * ,.b8 00r88g75b88008x ( * ,. 00r100g75b88.08x' ( *, 00r0g75b100 (008x ( * ,. 00r25g75b100@008x ( * ,. 00r50g75b100008x ( * ,.0 00r75g75b100008x ( * ,. 00r88g75b100208x * , .0 $ 00r100g75b100.08x & ( *,5b00custom1.08x & ( *, 00custom2.08x & ( *,00custom30.08x & ( *,ll00custom4,08x $ & (*00gray32,08x $ & (*a00gray28QQQ,08x $ & (*00gray24,08x $ & (*\00gray20+08x% &()00r0g88b0$-08x & (*+00r25g88b0@z-08x & (*+00r50g88b05b0-08x & (*+ "00r75g88b0-08x & (*+&00r88g88b0&/08x ( *,-0 00r100g88b0.08x& ( *, 00r0g88b50008x ( * ,.00 00r25g88b50@$0@00"Vp` 0800X/p0808YSTATUS/CLEAR_ALL_MASTER_DETAILS0ld0C DEFGH0ASYSTEM.BLOCK_STATUSSYSTEM.BLOCK_STATUS0CLEAR_ALL_MASTER_DETAILS14d1PC!DEFGH1lASYSTEM.RECORD_STATUSSYSTEM.RECORD_STATUS1P10_05_AGO_200203_04_251d2C"DEFG H2$ASYSTEM.MODESYSTEM.MODE 222233$3D3d3P11_05_AGO_200203_04_25P12_05_AGO_200203_04_25P13_05_AGO_200203_04_25P14_05_AGO_200203_04_25P15_05_AGO_200203_04_25P16_05_AGO_200203_04_25P17_05_AGO_200203_04_25P18_05_AGO_200203_04_25P19_05_AGO_200203_04_25$00x !"--black--------------------------------------------- gv_module constant varchar2(40) := 'NKW_DNT'; gv_version constant varchar2(10) := '2.0.2'; gv_comments constant varchar2(80) := 'Dynamic Triggers'; type tab_button is table of varchar2(80) index by binary_integer; gt_button tab_button; ------------------------------------------------------------------ -- SET_ENV ------------------------------------------------------------------ procedure set_env; ---------------------------------------------------------- -- BOLD_BUTTON ---------------------------------------------------------- procedure bold_button; end pkg_frm;0800Rstring0000000000000000000000000000` |0r008x ( * ,.` 00r50g88b50008x ( * ,. 00r75g88b50008x ( * ,.8 00r88g88b50008x ( * ,.50 00r100g88b50.08x& ( *,@00r0g88b750008x ( * ,. 00r25g88b75@008x ( * ,.ay 00r50g88b75008x ( * ,. 00r75g88b75008x ( * ,.8 00r88g88b75008x ( * ,. 00r100g88b75.08x& ( *, $00r0g88b885008x ( * ,. ( 00r25g88b88@008x ( * ,.5b 00r50g88b88008x ( * ,.  00r75g88b88008x ( * ,.g5 00r88g88b88008x ( * ,.b8 00r100g88b88.08x' ( *, 00r0g88b100008x ( * ,. 00r25g88b100@008x ( * ,. 00r50g88b100008x ( * ,. 00r75g88b100008x ( * ,.0 00r88g88b100208x * , .0 00r100g88b100.08x & ( *,00custom5.08x & ( *,5b00custom6.08x & ( *, 00custom7.08x & ( *,00custom80,08x $ & (*ll00gray16 ,08x $ & (* (00gray12GGG,08x $ & (* (00gray8,08x $ & (* (00gray4-08x& (*+ (00r0g100b0/08x ( *,- 00r25g100b0@/08x ( *,- 00r50g100b0/08x ( *,- 00r75g100b0/08x ( *,- 00r88g100b0/08x ( *,- 00r100g100b0.08x' ( *, 00r0g100b50008x ( * ,. 00r25g100b50@008x ( * ,. 00r50g100b50008x ( * ,. 00r75g100b50008x ( * ,. 00r88g100b50208x * , .0 00r100g100b50ER.08x' ( *, 00r0g100b75E008x ( * ,. 00r25g100b75@008x ( * ,..B 00r50g100b75008x ( * ,. 00r75g100b75008x ( * ,. 00r88g100b75208x * , .0 00r100g100b75US.08x' ( *,US 00r0g100b88008x ( * ,._2 00r25g100b88@008x ( * ,. 00r50g100b88008x ( * ,.ST 00r75g100b88008x ( * ,.  00r88g100b88208x * , .0 00r100g100b88008x( * ,. 00r0g100b100208x * , .020 00r25g100b100@_2208x * , .0_A 00r50g100b1006_208x * , .0 00r75g100b100208x * , .05 00r88g100b10004208x * , .0 00r100g100b100--*:BFe(f jnp(z~(((v_ SQL*FormstFORM50C:\nulaya\hpg\fmb\nkw_dnt.fmbntxg:6رxg:6;Copyright (c) Oracle Corporation 1990. All Rights Reserved.; (0in*b (0gt+  (0--,------------------------------------------------------- -- SET_ENV ------------------------------------------------------------------ procedure set_env; ---------------------------------------------------------- -- BOLD_BUTTON ---------------------------------------------------------- procedure bold_button; end pkg_frm;0800Rstring0000000000000000000000000000p l$03@;Pa\:t @ b8c$kHng``AoNKW_DNTihj8khtPTBl8I##$$$ $,$4$H$X$h$t$$$$$$$$%%%%(%4%H%`%h%t%%%%%%%%%&&&$&0&L&h&&&&&&' ' '('0'@'P'X'`'l't''''''''''(( (((,(<(P(`(p(((((((((((()) ))()<)L)\)l))))))* *$*<*T*l*|********+++,+@+P+X+h+x+++++++++,,,$,4,D,X,h,x,,,,,,,,----(-4-<-D-T-d-p-x----------... .,.4.<.L.\.p.x........///4/D/L/`/|//////0040<0T0h0p0x0000011,141D1L1d1|1111122 20282P2h2222233 33$383D3T3d3t33333333344$404L4X4x4444444455505<5D5L5`5t55555555556666,646D6L6`6p666666667777$707<7L7\7l77777777777788 88 8(8<8H8P8X8l88888889 9 949H9\9d9l9x999999999:::,:4:<:P:d:l:t:::::::::; ;;;,;<;L;`;t;;;;;;;;;;<<< <4<@>> >4>@>T>h>p>x>>>>>>>>>??? ?4?H?P?X?h?x????????@@@ @4@@@T@h@p@x@@@@@@@@@AAA A4AHAPAXAhAxAAAAAAAABBB B4B@BTBhBpBxBBBBBBBBBCCC C4CHCPCXChCxCCCCCCCCDDDD,D8DLD`DhDpDDDDDDDDDEEEE,E@EHEPE`EpEEEEEEEEFFFF,F8FLF`FhFpFFFFFFFFFGGGG,G@GHGPG`GpGGGGGGGGHH HH(H4HHH\HdHllHHHHHHHHHII II(I<IDILI\IlI|IIIIIIIJJJJ$J0JDJXJ`JhJ|JJJJJJJJKKKK$K8K@KHKXKhKxKKKKKKKKLL LL,LDLTLdLtLLLLLLLLMMM(M8MLM`MtMMMMMMMMMNNN$N<NTNlN|NNNNNNNNOOO(O8OHOXOhOxOOOOOOOOPPP$P4PDPXPlPPPPPPPQQQ$Q0Q<QPQdQtQQQQQQQQQQRR RRR,R<RHR\RpR|RRRRSSSS(S8S@SHStSSSSSTT,T4T<TDTLT\TpTTTTTTTTTTU UUU0UDUTUdUlU|UUUUUUV VLVXVVVVVVVW$WDWTWdWWWWXXX$X4X<X`XXXXXXXXYYYY(Y8YHYXYhYtYYYYYYYZ ZHZPZXZlZZZZZZZZZZ[[[([8[@[L[\[l[|[[[[\\ \\0\8\@\H\t\\\\\\]],]@]P]`]h]t]]]]]]]^^^0^8^@^X^l^^^^__ _4_H_X_`_t________``<`H`P`X```````aa8aHaXahapaaaaaabbbb$b4bDblbbbbbccc c0c8c@cXchcxccccccccccccd d4d\dhdxddddddde ee,eTedete|eeeeeeeeeefff f(f0f@fPfXfdftffffffffffgggg$g8gLg\glgtgggggggghhh$h,h4h<h`hhhphxhhhlFinancial State [v1.0.1]VistaPrestaoVencimentoDiasNulaya InfoMRF_FORMSForm IDVIPDias360 dias31 dias30 dias29 dias28 diasDataPlano de Prestaes1998ValorTotaisSaldoJurosFinanciamentoN de PrestaesNDevidoRendidoAplicadoNCalcular...Dynamic TriggersDevelopmentAnlise de PrestaesTaxaValor Plano de Pagamento Anlise de PrestaesPrestaes Iguais Sem EntradaPrestaes Iguais Sem EntradaObject IDObject IDLast DDL TimeLast DDL TimeObject NameObject NameVersionVersionStatusDDisableEnablePurposeDescriptionScopeBytesForm IDForm IDBlock NameBlock NameWhere ClauseDML SourceDML SourceDML SourceSelect SourceSelect SourceSource ViewIDYYYYScopeVersionObject NameObject IDForm IDPurposeForm StatusForm StatusScope DefinitionDelete Allowed ?Delete Allowed ?Update Allowed ?Update Allowed ?Insert Allowed ?Insert Allowed ?Select Allowed ?Select Allowed ?Block NameBlock Name#Select AllowedDelete AllowedUpdate AllowedInsert AllowedProductionDevelopmentForm StatusForm StatusLocationFFileSystemDataBaseVIPBlock NameBlock Name#DML SourceDML SourceList LabelSelect SourceSelect SourceDataTypeBlock NameBlock NameColumn ViewVARCHAR2Varchar2DateNumberDML SourceDML SourceDescriptionForm NameForm NameReport NameForm IDForm IDVIPForm IDForm IDVIPForm NameForm NameReport NameForm IDForm IDVIPForm IDForm IDVIPBlock NameBlock NameWhere ClauseYE tambm....andOu ento...E tambm...Valor de comparao...Valor de Comparao...Operador de comparaoSeja...=No Padro...Maior ou Igual a...Maior que...Menor ou Igual a...Menor que...Diferente de...lIgual a...Coluna do relatrio para comparaoOnde a coluna...?Onde a coluna...Imprimir...YOrdem decrescenteOrdem crescenteOrdem do valor da coluna.Ordem do valor da coluna.asc3 Coluna de Ordenao3 Coluna de Ordenao?Coluna...NEm seguida por...Ordem decrescenteOrdem crescenteOrdem do valor da coluna.Ordem do valor da coluna.asc2 Coluna de Ordenao2 Coluna de Ordenao?Coluna...NEm seguida por...Ordem decrescenteOrdem crescenteOrdem do valor da coluna.Ordem do valor da coluna.asc1 Coluna de Ordenao1 Coluna de Ordenao?Coluna...NOrdenar por...RunDescendentAscendentSort by...DescendentAscendentSort by...DescendentAscendentSort by...And/OrValueOperatorColumnRelational OperatorValueComparison OperatorLikeGreater then or equal toGreater thenLess then or equal toLess thenNot equal toEqual toColumnColumnorandObject StatusObject StatusStatusObject TypeObject TypeObject TypeCreatedCreatedCreatedLast DDLTimestampDumpOpWAppendDefault fileOpOpen fileOpcdcihsbc.txtCompileTimestampTimestampSynonym NameSynonym NameSynonymsObject NameObject NameObject NameDropCreateUsernameUsernameUsernameObject NameObject NameTable NameYExecuteNSelectNYInsertNYUpdateNYGrant / RevokeDeleteNYDelete FlagDelete FlagUpdate FlagUpdate FlagInsert FlagInsert FlagSelect FlagSelect FlagExecute FlagExecute FlagObject TypeObject TypeObject TypeQueryUsernameUsernameUsersDeleteUpdateInsertSelectExecuteGrant / RevokeQueryDelete FlagDelete FlagNYUpdate FlagUpdate FlagNYInsert FlagInsert FlagNYSelect FlagSelect FlagNYExecute FlagExecute FlagNYUsernameUsernameUsernameObject TypeObject TypeObject TypeObject NameObject NameView NameDeleteUpdateInsertSelectExecuteGrant / RevokeQueryDelete FlagDelete FlagNYUpdate FlagUpdate FlagNYInsert FlagInsert FlagNYSelect FlagSelect FlagNYExecute FlagExecute FlagNYUsernameUsernameUsernameObject TypeObject TypeObject TypeObject NameObject NamePackage NameGrant / RevokeQueryDelete FlagDelete FlagNYUpdate FlagUpdate FlagNYInsert FlagInsert FlagNYSelect FlagSelect FlagNYExecute FlagExecute FlagNYUsernameUsernameUsernameObject TypeObject TypeObject TypelObject NameObject NameProcedure NameGrant / RevokeQueryDelete FlagDelete FlagNYUpdate FlagUpdate FlagNYInsert FlagInsert FlagNYSelect FlagSelect FlagNYExecute FlagExecute FlagNYUsernameUsernameUsernameObject TypeObject TypeObject TypeObject NameObject NameFunction NameGrant / RevokeQueryDelete FlagDelete FlagNYUpdate FlagUpdate FlagNYInsert FlagInsert FlagNYSelect FlagSelect FlagNYExecute FlagExecute FlagNYUsernameUsernameUsernameObject TypeObject TypeObject TypeObject NameObject NameViewsGrant / RevokeQueryDelete FlagDelete FlagNYUpdate FlagUpdate FlagNYInsert FlagInsert FlagNYSelect FlagSelect FlagNYExecute FlagExecute FlagNYUsernameUsernameUsernameObject TypeObject TypeObject TypeObject NameObject NameColumn NameGrant / RevokeQueryDelete FlagDelete FlagNYUpdate FlagUpdate FlagNYInsert FlagInsert FlagNYSelect FlagSelect FlagNYExecute FlagExecute FlagNYUsernameUsernameUsernameObject TypeObject TypeObject TypeObject NameObject NameFunctionsGrant / RevokeQueryDelete FlagDelete FlagNYUpdate FlagUpdate FlagNYInsert FlagInsert FlagNYSelect FlagSelect FlagNYExecute FlagExecute FlagNYUsernameUsernameUsernameObject TypeObject TypeObject TypeObject NameObject NameProceduresGrant / RevokeQueryDelete FlagDelete FlagNYUpdate FlagUpdate FlagNYInsert FlagInsert FlagNYSelect FlagSelect FlagNYExecute FlagExecute FlagNYUsernameUsernameUsernameObject TypeObject TypeObject TypeObject NameObject NamePackagesTable NameTable NameTablespace NameTable NameTable NameTable NameTable NameTable NameTable NameColumn IDColumn ID#Column NameColumn NameColumn NameData TypeData TypeData TypeData LengthData LengthData LengthData ScaleData ScaleData PrecisionData PrecisionNullableNullableNCommentsCommentsCommentsTablespace NameTablespace NameTablespace NameNullableNullableNData ScaleData ScaleData PrecisionData PrecisionData LengthData LengthData LengthData TypeData TypeData TypeColumn IDColumn IDCol#Index NameIndex NameIndex NamelTable NameTable NameTable NameUniquenessUniquenessUniquenessCommentsCommentsCommentsColumn NameColumn NameColumn NameColumn PositionColumn PositionPos.Column NameColumn NameIndex NameTable NameTable NameTable NameDVDADVLAColumn NameColumn NameColumn IDColumn ID#UpdatingUpdatingIInsertingInsertingIDeletingDeletingINNNDate ValueDate ValueDateNumber ValueNumber ValueNumberLiteral ValueLiteral ValueLiteral ValueUnchecked=NVL Checked=AssignmentUnchecked=NVL Checked=AssignmentNIInsertingInsertingNIDefault Values and Literal AssignmentsUpdatingInsertingAssignmentNVLDefault Values and Dynamic AssignmentsUnchecked=NVL Checked=AssignmentUnchecked=NVL Checked=AssignmentNIArgumentsNumber ValueNumber ValueNumberDate ValueDate ValueDateUpdatingUpdatingNIInsertingInsertingNIColumn NameColumn NameColumn IDColumn ID#UpdatingInsertingAssignmentNVLUpdatingInserting Default Values - Literal Assignments Default Values - Dynamic AssignmentsDefault Values - Dynamic AssignmentsDVDADefault Values - Literal AssignmentsDefault Values - Literal AssignmentsDVLAAssignmentNVLUpdatingInserting Default Values - Dynamic Assignments General Procedure ScopeUpdatingInserting Check Column Value - Integrity Assertion Failed MessageAssertion Failed MessageAssertion Failed MessageColumn NameColumn NameColumn IDColumn ID#Check Column Value - IntegrityCheck Column Value - IntegrityCCVIUpdatingInsertingTable NameTable NameTable NameTable NameTable NameTable NameDVLADVDATable NameTable NameTable NameAssignmentNVLUpdatingInsertingAssignmentNVLUpdatingInsertingDynamic Trigger General ControlUnchecked=NVL Checked=AssignmentUnchecked=NVL Checked=AssignmentNILiteral ValueLiteral ValueLiteral ValueUpdatingUpdatingNINDefault ValuesColumn NameColumn NameColumn IDColumn ID#DVLATable NameTable NameTable Name Dynamic Trigger - General Control Check Column Value IntegrityCheck Column Value IntegrityDTGCNCheck Columns ValuesNCCVI - Check Column Value - Integrity Check Column Value - Range CCVINULLAssertion Failed MessageAssertion Failed MessageAssertion Failed MessageColumn NameColumn NameColumn IDColumn ID#CCVRTable NameTable NameTable NameCheck Column Value - RangeCheck Column Value - RangeCCVRNCCVR - Check Column Value - RangePackaged FunctionAssertion TextAssertion TextComparison Text Check Column Value - Consistency Assertion Failed MessageAssertion Failed MessageAssertion Failed MessageAssertion TextAssertion TextArgumentsColumn NameColumn NameColumn IDColumn IlD#CCVCTable NameTable NameTable NameCheck Column Value - ConsistencyCheck Column Value - ConsistencyCCVCNCCVR - Check Column Value - ConsistencyPackaged FunctionPackaged FunctionPackaged FunctionAssertion Failed MessageAssertion Failed MessageAssertion Failed MessageArgumentsArgumentsArgumentsPackaged FunctionPackaged FunctionPackaged FunctionColumn NameColumn NameColumn IDColumn ID#CCVSTable NameTable NameTable Name Check Column Value - Standards Check Column Value - ConsistencyCheck Column Value - ConsistencyCCVSUpdatingInserting Execute Packaged Procedure Code ArgumentsPackaged ProcedureUpdatingUpdatingNIInsertingInsertingNIIDID#DVDATable NameTable NameTable NameExecute Packaged Procedure CodeExecute Packaged Procedure CodeEPPCDeletingDeletingNIDeletingExecute Anonymous PL/SQL BlockExecute Anonymous PL/SQL BlockEAPBDeletingUpdatingInserting Execute Anonymous PL/SQL Block DeletingDeletingNIPL/SQL BlockPackaged ProcedureUpdatingUpdatingNIInsertingInsertingNIColumn IDColumn ID#DVDATable NameTable NameTable NameDeletingDeletingNIUpdatingUpdatingNIInsertingInsertingNIColumn NameColumn NameColumn IDColumn ID#Table NameTable NameTable Name DML Action Audit Log DeletingUpdatingInsertingNDML Action Audit LogNExecute Anonymous PL/SQL BlockNExecute Packaged Procedure CodeRun ConditionmIllPTBNKW_DNTMRF_FORMSMAINDEFAULT&SMARTBARE 88 8d88808t888\D,<u:POST-FORMPOST-FORM Zlnkw_obj_frm.olb ] ^<NKW_OBJ_FRM ^<DPOST-FORM` Dpu:KEY-MENUKEY-MENUZnkw_obj_frm.olb],^NKW_OBJ_FRM^TDKEY-MENUDu:ON-MESSAGEON-MESSAGEZ nkw_obj_frm.olb]4p^\NKW_OBJ_FRMl^DON-MESSAGEDu:KEY-CLRFRMKEY-CLRFRMZ8Pnkw_obj_frm.olb]x^NKW_OBJ_FRM^DKEY-CLRFRM,D<Lu:PRE-FORMPRE-FORMZ|nkw_obj_frm.olb]^LNKW_OBJ_FRM ^L DPRE-FORMp!Du:ON-ERRORON-ERROR"Znkw_obj_frm.olb#]<$^(NKW_OBJ_FRM%^dDON-ERROR&Du:KEY-PRINTKEY-PRINT'Znkw_obj_frm.olb(]D)^lNKW_OBJ_FRM*^DKEY-PRINT+Du:KEY-HELPKEY-HELP,ZH`nkw_obj_frm.olb-].^NKW_OBJ_FRM/^DKEY-HELP,0DD :ON-CLEAR-DETAILSON-CLEAR-DETAILS1D :WHEN-NEW-BLOCK-INSTANCEWHEN-NEW-BLOCK-INSTANCE2 3,<MESSAGEMESSAGE4Zlnkw_obj_frm.olb5]6^<NKW_OBJ_FRM7^<MESSAGEH8T`ADVISEADVISE9Znkw_obj_frm.olb:] ;^`NKW_OBJ_FRM<^`4ADVISE= `> NKW_LIB_FRMNKW_LIB_FRMnkw_lib_frm.pll? H`Xt *8IO@   ,g@BA("HdT&'<% `\:h0MAINMAINOFFUSER_TABLESMAINgray8AE8BDH  P:ON-POPULATE-DETAILSON-POPULATE-DETAILSC X|DxDH+ *A%XB!t u<iy gh jikl( 87 LJOCL|\lZ4~oTABLE_NAMETABLE_NAMEMAINMS Sans SerifblackwhiteTable NameMS Sans Serifr0g25b50Table NameTable Name|EH*A!tu-i ygh jikl|: Z~ lDTGCDTGCDTGCMAINMS Sans SerifblackwhiteCheck Column Value IntegrityCheck Column Value IntegrityFE8@pGD| :WHEN-BUTTON-PRESSEDWHEN-BUTTON-PRESSEDHH*A!tu-i ygh jikl|(:TDECZ~DVLADVLADVLAMAINMS Sans SerifblackwhiteDefault Values - Literal AssignmentsDefault Values - Literal AssignmentsIE8tJD :WHEN-BUTTON-PRESSEDWHEN-BUTTON-PRESSEDKH*A!t/u-i yg h jikl ,|8d:AB@Z~DVDADVDADVDAMAINMS Sans SerifblackwhiteDefault Values - Dynamic AssignmentsDefault Values - Dynamic AssignmentsLE8MD:WHEN-BUTTON-PRESSEDWHEN-BUTTON-PRESSEDNH$0*A!<tTu-i ygHh jikl\h|t:XYWZ~CCVICCVICCVIMAINMS Sans SerifblackwhiteCheck Column Value - IntegrityCheck Column Value - IntegrityOE8 PD(:WHEN-BUTTON-PRESSEDWHEN-BUTTON-PRESSEDDQHP\*A!htuu-i ygth jikl|:Z~CCVSCCVSCCVSMAINMS Sans SerifblackwhiteCheck Column Value - ConsistencyCheck Column Value - ConsistencyRE8@SDD\:WHEN-BUTTON-PRESSEDWHEN-BUTTON-PRESSEDxTH*A!tu-i ygh jikl|:Z~CCVRCCVRCCVRMAINMS Sans SerifblackwhiteCheck Column Value - RangeCheck Column Value - RangeUE84dVDx:WHEN-BUTTON-PRESSEDWHEN-BUTTON-PRESSEDWH*A!tu-i ygh jikl| :HZ~CCVCCCVCCCVCMAINMS Sans SerifblackwhiteCheck Column Value - ConsistencyCheck Column Value - ConsistencyXE8hYD:WHEN-BUTTON-PRESSEDWHEN-BUTTON-PRESSEDZH*A!tu-i ygh jikl |,P:tZ~EAPBEAPBEAPBMAINMS Sans SerifblackwhiteExecute Anonymous PL/SQL Block "lExecute Anonymous PL/SQL Block[E8\D:WHEN-BUTTON-PRESSEDWHEN-BUTTON-PRESSED]H*A! tu-i yg,h jikl@L|X:Z~EPPCEPPCEPPCMAINMS Sans SerifblackwhiteExecute Packaged Procedure CodeExecute Packaged Procedure Code^E8_D:WHEN-BUTTON-PRESSEDWHEN-BUTTON-PRESSED`C D0x`aBHDB@REL_DVDAREL_DVDADVDAmain.table_name=dvda.table_namebBHDB@REL_DVLAREL_DVLADVLAmain.table_name=dvla.table_name8cBHHDXdB@REL_DTGCREL_DTGCDTGCmain.table_name=dtgc.table_namedBHDB@REL_CCVRREL_CCVRCCVRmain.table_name=ccvr.table_nameeBHDB@REL_CCVCREL_CCVCCCVCmain.table_name=ccvc.table_name$fBH4DDPB@REL_CCVSREL_CCVSCCVSmain.table_name=ccvs.table_namegBHDB@REL_CCVIREL_CCVICCVImain.table_name=ccvi.table_namelhBH|DB@REL_COLSREL_COLSCOLSmain.table_name=cols.object_nameiBH D0<B@REL_LOGREL_LOGLOGmain.table_name=log.table_namejBHDB@REL_EAPBREL_EAPBEAPBmain.table_name=eapb.table_nameTkBHdDtB@REL_EPPCREL_EPPCEPPCmain.table_name=eppc.table_name`llx  BA("d&'% COLSCOLSOFFVIW_NKW_COLUMNSCOLUMN_IDMAINgray8m Dttn* *A%J!t u=iy gh jikl 7 LJOC|$4Z4~oOBJECT_NAMEOBJECT_NAMEMAIN.TABLE_NAMEMS Sans SerifblackwhiteTable NameMS Sans Serifr0g25b50Table NameTable Nameo+ *A%B!tuity gh jikl (7 LJOC<|L`Z4~oCOLUMN_NAMECOLUMN_NAMEMAINMS Sans SerifblackwhiteColumn NameMS Sans Serifr0g20$l5b50Column NameColumn Name p0 *A%B!,t uiy g8h jiklLXd l7 LJOC|Z4~oCOLUMN_IDCOLUMN_IDMAINMS Sans Serifblackgray4#MS Sans Serifr0g25b50Column IDColumn ID(q,8 *A%B!HtuiAy gTh jiklhtÀ Ð7 LJOCä|ôZ4~oDATA_TYPEDATA_TYPEMAINMS Sans SerifblackwhiteData TypeMS Sans Serifr0g25b50Data TypeData Typelr0| *A%B!Ōtui y gŘh jiklŬŸ 7 LJOC|Z4~oNULLABLENULLABLEMAINMS Sans SerifblackwhiteNMS Sans Serifr0g25b50NullableNullables U gC  (" d(&'b% W0:<DTGCDTGCNKW_DNT_DTGCNKW_DNT_DTGCgray8tE8|888l8ȼǬuDǼ:KEY-NXTRECKEY-NXTRECvD :KEY-DOWNKEY-DOWNLwD\:KEY-CLRRECKEY-CLRRECȜxDȬ:KEY-NXTSETKEY-NXTSETyD:KEY-SCRDOWNKEY-SCRDOWNz\˴l$Ҡ{. *A%XBJ!$,t u<iy g4h jiklHT` p7 LJOC˄|˔ˤZ4~oTABLE_NAMETABLE_NAMEMAIN.TABLE_NAMEMS Sans SerifblackwhiteTable NameMS Sans Serifr0g25b50Table NameTable Name|!*A&J! tufiy g,h jikl@P|\d=<>;&Z4~LOGIESLOGIESDML Action Audit LogYNNMAINMS Sans Serifr0g25b50grayΌ}!ΘΤ*θA&J!tuxiy gh jikl|}|~{&Z4~DVIESDVIESDefault ValuesYNNMAINMS Sans Serifr0g25b50grayD~@l!P\*xAЀ&ЈJ!Аtuiy gМh jiklа|&Z4~CCVIESCCVIESCheck Columns ValuesYNNMAINMS Sans Serifr0g25b50gray!*<AD&LJ!Ttuiy g`h jiklt҄|ҐҘEDFC&Z4~EPPCEPPCExecute Packaged Procedure CodeYNNMAINMS Sans Serifr0g25b50gray!*A& J!tuiy g h jikl4D|PXA@B?&Z4~EAPBEAPBExecute Anonymous PL/SQL BlockYNNMAINMS Sans Serifr0g25b50gray   ,gDLC \("pd|&Y'd% [ՄՐLOGLOGOFFVIW_NKW_DNT_LOGIESCOLUMN_IDNKW_DNT_LOGIESMAINgray80``.p *A%׀XטBJ!נרt u<iy gװh jikl 7 LJOC| 564Z4~oTABLE_NAMETABLE_NAMEMAIN.TABLE_NAMEMS Sans SerifblackwhiteTable NameMS Sans Serifr0g25b50Table NameTable Name`0 *A%!tudiy gh jikl( 07 LJOCD|Td:t231Z4~oCOLUMN_IDCOLUMN_IDMAINMS Sans Serifblackwhite#MS Sans Serifr0g25b50Column IDColumn IDE8ڔD0:WHEN-VALIDATE-ITEMWHEN-VALIDATE-ITEMD`'X*A!lxtudixy g܀h jiklܔܠܬ 7 LJOC0/Z4~oCOLUMN_NAMECOLUMN_NAMEMAINMS Sans Serifblackgray4Column NameMS Sans Serifr0g25b50Column Name`!,@*HAP&X!`lt8uei y gth jiklވޔ|ޠް-,.+&Z~INSERT_FLAGINSERT_FLAGIYNNMAINMS Sans SerifblackgrayInsertingInserting`!*A& !(4tPlCuei y g<h jiklP\|hx)(*'&Z~UPDATE_FLAGUPDATE_FLAGIYNNMAINMS Sans SerifblackgrayUpdatingUpdating`"*A&J!tNuei y g h jikl ,|8H%$&#&Z~DELETE_FLAGDELETE_FLAGIYNNMAINMS Sans SerifblackgrayDeletingDeleting   $g<LC \("pd|&'b% \DVLADVLAOFFVIW_NKW_DNT_DVIESDNT='DVLA'COLUMN_IDNKW_DNT_DVIESDVLAgray8@l4pX. *A%XBJ!t u<iy gh jikl 7 LJOC| 0`a_Z4~oTABLE_NAMETABLE_NAMEMAIN.TABLE_NAMEMS Sans SerifblackwhiteTable NameMS Sans Serifr0g25b50Table NameTable NameX *A% Ji-ybDNTDNTDVLAtX0 *A%!tubiy gh jikl 7 LJOC|: Z4~oCOLUMN_IDCOLUMN_IDDVLAMS Sans Serifblackwhite#MS Sans Serifr0g25b50Column IDColumn IDE8@pD:WHEN-VALIDATE-ITEMWHEN-VALIDATE-ITEMX'*A!$tubiyy g,h jikl@LX l7 LJOCZ4~oCOLUMN_NAMECOLUMN_NAMEDVLAMS Sans Serifblackgray4Column NameMS Sans Serifr0g25b50Column NameX!*A&! tyuci y g h jikl4@|L\&Z~INSERT_FLAGINSERT_FLAGIYNNDVLAMS Sans SerifblackgrayInsertingInsertingX!*A&!tuci y gh jikl|$&Z~UPDATE_FLAGUPDATE_FLAGIYNNDVLAMS Sans Serifblackgray`lUpdatingUpdatingX0 *A%n!tubiIy gh jikl , @7 LJOCT|dxZ4~oTEXTTEXTDVLAMS Sans SerifblackwhiteLiteral ValueMS Sans Serifr0g25b50Literal ValueLiteral ValueX!*A&!tuci y gh jikl |$L&Z~ANVLANVLIANNDVLAMS Sans SerifblackgrayUnchecked=NVL Checked=AssignmentUnchecked=NVL Checked=Assignment(4  @gXhC x("d&'b% ZDVDADVDAOFFVIW_NKW_DNT_DVIESDNT='DVDA'COLUMN_IDNKW_DNT_DVIESDVDAgray8  dX t. *A%XBJ!t u<iy gh jikl  7 LJOC4|DTefdZ4~oTABLE_NAMETABLE_NAMEMAIN.TABLE_NAMEMS Sans SerifblackwhiteTable NameMS Sans Serifr0g25b50Table NameTable Namet *A% Ji-ycDNTDNTDVDAt0 *A%!tubiy gh jikl 7 LJOC|$4:D786Z4~oCOLUMN_IDCOLUMN_IDDVDAMS Sans Serifblackwhite#da 0800 0800 0800( 0800 00800@0800 `0800p 0800N*0808(?7@@@@$@$@%@$@$@$@$@$@$@@$@ed MessageAssertion Failed MessageColumn NameColumn NameColumn IDColumn ID#CCVRTable NameTable NameTable NameCheck Column Value - RangeCheck Column Value - RangeCCVRNCCVR - Check Column Value - RangePackaged FunctionAssertion TextAssertion TextComparison Text Check Column Value - Consistency Assertion Failed MessageAssertion Failed MessageAssertion Failed MessageAssertion TextAssertion TextArgumentsColumn NameColumn NameColumn IDColumn Ip lMS Sans Serifr0g25b50Column IDColumn IDE8dD:WHEN-VALIDATE-ITEMWHEN-VALIDATE-ITEMt'(*A!<Htubixy gPh jikldp| 7 LJOC54Z4~oCOLUMN_NAMECOLUMN_NAMEDVDAMS Sans Serifblackgray4Column NameMS Sans Serifr0g25b50Column Namet!*A &(!0<tyuci y gDh jiklXd|p2130&Z~INSERT_FLAGINSERT_FLAGIYNNDVDAMS Sans SerifblackgrayInsertingInsertingt!*A&!tuci y g h jikl ,|8H.-/,&Z~UPDATE_FLAGUPDATE_FLAGIYNNDVDAMS Sans SerifblackgrayUpdatingUpdatingt2 *A%Pn(0!<tubiIygHh jikl\htY 7 LJOC|Z4~oPKG_FUNCTIONPKG_FUNCTIONWHITEDVDAMS Sans SerifblackwhitePackaged FunctionMS Sans Serifr0g25b50 pt3 | *A%n  !  tu}iIy@g h jikl   Y  7 LJOC |  $%#Z4~oTEXTTEXTWHITEDVDACourier NewblackwhiteArgumentsMS Sans Serifr0g25b50 Ht" T `* hA p& xJ!  tuci y g h jikl  |  ! "&Z~ANVLANVLIANNDVDAMS Sans SerifblackgrayUnchecked=NVL Checked=AssignmentUnchecked=NVL Checked=Assignment      g C ("(d4&'b% \<HCCVICCVIOFFVIW_NKW_DNT_CCVIESDNT='CCVI'COLUMN_IDNKW_DNT_CCVIESCCVIgray8Pl .( *A%8XPBJ!X`t u<iy ghh jikl| 7 LJOC|]^\Z4~o lTABLE_NAMETABLE_NAMEMAIN.TABLE_NAMEMS Sans SerifblackwhiteTable NameMS Sans Serifr0g25b50Table NameTable Name`  l*A% xJi-yDNTDNTCCVI$ 14 *A%!DPtubiy gXh jikllx 7 LJOC|:UVTZ4~oCOLUMN_IDCOLUMN_IDCCVIMS Sans Serifblackwhite#MS Sans Serifr0g25b50Column IDColumn IDE8 D8:WHEN-VALIDATE-ITEMWHEN-VALIDATE-ITEM **A!tubixy gh jikl  47 LJOCHXSRZ4~oCOLUMN_NAMECOLUMN_NAMECCVIMS Sans Serifblackgray4Column NameMS Sans Serifr0g25b50Column Name 30 *A%NnDL!T`tyubijy ghh jikl| 7 LJOC|PQOZ4~oAPP_MESSAGEAPP_MESSAGECCVIMS Sans SerifblackwhiteAssertion Failed MessageMS Sans Serifr0g25b50Assertion Failed MessageAssertion Failed Message *A%Ji-yTEXTTEXTNULLlx  gC ("d&'b% \CCVSCCVSOFFVIW_NKW_DNT_CCVIESDNT='CCVS'COLUMN_IDNKW_DNT_CCVIESCCVSgray8L@! #(%'. *A%X BJ!t u<iy g$h jikl8DP `7 LJOCt|Z4~oTABLE_NAMETABLE_NAMEMAIN.TABLE_NAMEMS Sans SerifblackwhiteTable NameMS Sans Serifr0g25b50Table NameTable Name (*A% 4Ji-yDNTDNTCCVS1 *A%J!  tubiy g h jikl ( 4 @  H7 LJOC \| l |: Z4~olCOLUMN_IDCOLUMN_IDCCVSMS Sans Serifblackwhite#MS Sans Serifr0g25b50Column IDColumn IDE8  D@ :WHEN-VALIDATE-ITEMWHEN-VALIDATE-ITEM"t*"*AJ!""tubixy g"h jikl""" "7 LJOC##Z4~oCOLUMN_NAMECOLUMN_NAMECCVSMS Sans Serifblackgray4Column NameMS Sans Serifr0g25b50Column Name$3$ *A%Pn%%J!%% tyubiiyg%(h jikl%<%H%T %l7 LJOC%|%%Z4~oPKG_FUNCTIONPKG_FUNCTIONWHITECCVSMS Sans SerifblackwhitePackaged FunctionMS Sans Serifr0g25b50Packaged FunctionPackaged Function'8,'D*A%'P'XJ!'d'ptyu}iiy$g'xh jik' '7 LJOC'|''4~oTEXTTEXTWHITECCVSCourier NewArgumentsMS Sans Serifr0g25b50ArgumentsArguments)3) *A%Nn))J!))tyuiiyg)h jikl)**  *,7 LJOC*@|*P*pZ4~oAPP_MESSAGEAPP_MESSAGEWHITECCVSMS Sans SerifblackwhiteAssertion Failed MessageMS Sans Serifr0g25b50Assertion Failed MessageAssertion Failed Message+8+D+P  +\g+t+C +("+d+&'b% \++CCVRCCVROFFVIW_NKW_DNT_CCVIESDNT='CCVR'COLUMN_IDNKW_DNT_CCVIESCCVRgray8,.h/136-*.- *A%-X-BJ!--t u<iy g-h jikl-.. .$7 LJOC.8|.H.XZ4~oTABLE_NAMETABLE_NAMEMAIN.TABLE_NAMEMS Sans SerifblackwhiteTable NameMS Sans Serifr0g25b50Table NameTable Name.* .*A% .Ji-yDNTDNTCCVR0*10 *A%J!00tubiy g0h jikl001 1 7 LlJOC1 |101@:1PZ4~oCOLUMN_IDCOLUMN_IDCCVRMS Sans Serifblackwhite#MS Sans Serifr0g25b50Column IDColumn IDE81p1D/1:WHEN-VALIDATE-ITEMWHEN-VALIDATE-ITEM38**3L*AJ!3`3ltubixy g3th jikl333 37 LJOC33Z4~oCOLUMN_NAMECOLUMN_NAMECCVRMS Sans Serifblackgray4Column NameMS Sans Serifr0g25b50Column Name5d*,5p*A%5|5J!55tyubiiy@g5h jik5 57 LJOC5|564~oTEXTTEXTWHITECCVRCourier NewComparison TextMS Sans Serifr0g25b50Assertion TextAssertion Text7*37 *A%Nn77J!88tyuiiyg8h jikl808<8H 8h7 LJOC8||88Z4~oAPP_MESSAGEAPP_MESSAGEWHITECCVRMS Sans SerifblackwhiteAssertion Failed MessageMS Sans Serifr0g25b50Assertion Failed MessageAssertion Failed Message9t99  9g99C 9("9d9&'b% \9:CCVCCCVCOFFVIW_NKW_DNT_CCVIESDNT='CCVC'COLUMN_IDNKW_DNT_CCVIESCCVCgray8:T<=H@B8DF;8.; *A%;X<BJ!<<$t u<iy g<,h jikl<@81> *A%J!??tubiy g?h jikl?0?<?H ?P7 LJOC?d|?t?:?Z4~oCOLUMN_IDCOLUMN_IDCCVCMS Sans Serifblackwhite#MS Sans Serifr0g25b50Column IDColumn IDE8??Dl=H? :WHEN-VALIDATE-ITEMWHEN-VALIDATE-ITEMA8+A*AJ!AAtubixy gAh jiklAAA B7 LJOCBB$Z4~oCOLUMN_NAMECOLUMN_NAMECCVCMS Sans Serifblackgray4Column NameMS Sans Serifr0g25b50Column NameC83C *A%PnDDJ!D$tyubiiygD0h jiklDDDPD\ Dt7 LJOCD|DDZ4~oPKG_FUNCTIONPKG_FUNCTIONWHITECCVCMS Sans SerifblackwhitePackaged FunctionMS Sans Serifr0g25b50Packaged FunctionPackaged FunctionF@8,FL*A%FXF`J!FlFxtyu}iiy$gFh jikF F7 LJOCF|FF4~oTEXTTEXTWHITECCVCCourier NewArgumentsMS Sans Serifr0g25b50Assertion TextAssertion TextH83H *A%NnHHJ!HHtyuiiygHh jiklIII I<7 LJOCIP|I`IZ4~oAPP_MESSAGEAPP_MESSAGEWHITECCVCMS Sans SerifblackwhiteAssertion Failed MessageMS Sans Serifr0g25b50Assertion Failed MessageAssertion Failed MessageJHJTJ`  JhgJ|JC J("JdJ&'b% [JJEAPBEAPBNKW_DNT_EAPBNKW_DNT_EAPBgray8JM<LlI.L| *A%LXLBJ!LLt u<iy gLh jiklLLL L7 LJOCM |MM,!" Z4~oTABLE_NAMETABLE_NAMEMAIN.TABLE_NAMEMS Sans SerifblackwhiteTable NameMS Sans Serifr0g25b50Table NameTable NameNI4O *A%nO O!O O,tubiy[[gO4h jiklOHOTO`Y Ot7 LJOCO|OOZ4~oTEXTTEXTWHITEEAPBCourier NewblackwhitePL/SQL BlockMS Sans Serifr0g25b50PPlP\Ph  PtgPPC P("PdP&'b% PPEPPCEPPCOFFNKW_DNT_EPPCNKW_DNT_EPPCEPPCgray8Q$S|UWpY8Z]l_RO.R *A%RXRBJ!RRt u<iy gRh jiklSSS( S87 LJOCSL|S\SlZ4~oTABLE_NAMETABLE_NAMEMAIN.TABLE_NAMEMS Sans SerifblackwhiteTable NameMS Sans Serifr0g25b50Table NameTable NameUO0U *A%!U,U8tubiy gU@h jiklUTU`Ul Ut7 LJOCU|UUZ4~oPKGIDPKGIDEPPCMS Sans Serifblackwhite#MS Sans Serifr0g25b50IDIDVO!VV*VAW&W!WWtuci y gW$h jiklW8WD|WPW`&Z~INSERT_FLAGINSERT_FLAGIYNNEPPCMS Sans SerifblackgrayInsertingInsertingXO!XX*XAX&X!XXtuci y gXh jiklYY |YY(&Z~UPDATE_FLAGUPDATE_FLAGIYNNEPPCMS Sans SerifblackgrayUpdatingUpdatingZXO!ZlZ*ZAZ&Z!Ztuci y gZh jiklZZ|ZZ&Z~DELETE_FLAGDELETE_FLAGIYNNEPPCMS Sans SerifblackgrayDeletingDeleting\O3\ *A%Pn\\!\\tubiy g\h jikl]]] Y ]87 LJOC]L|]\]dZ4~oPKG_PROCEDUREPKG_PROCEDUREEPPCMS Sans SerifblackwhitePackaged ProcedureMS Sans Serifr0g25b50_O3_0 *A%n_D_L!_X_dtubiyg_lh jikl___Y _7 LJOC_|__Z4~oPKG_ARGUMENTSPKG_ARGUMENTSWHITEEPPCCourier NewblackwhiteArgumentlsMS Sans Serifr0g25b50aO3a *A%naa!atuiy1gah jiklaaaY b7 LJOCb|b(b0HIGZ4~oRUNIFRUNIFWHITEEPPCCourier NewblackwhiteRun ConditionMS Sans Serifr0g25b50 bTDӘDc  c_h^Doc iyc,]d MAINMAINMAIN cdf fhkPlhmHmp$qsLtvxy`c bcdMAIN_LOGOMAIN_LOGOZd4dLnkw_obj_frm.olb]dtd^ddNKW_OBJ_FRM^dd MAIN_LOGOe be$e8MAIN_MOLDURAMAIN_MOLDURAZehenkw_obj_frm.olb]ee^e8eNKW_OBJ_FRM^e8f  MAIN_MOLDURAfp bf % GROUP177GROUP177gX bgd % tu iJy gp[g|gggrTITLETITLEgray12nonewhitenoneUggTfghCMPTXT55CMPTXT55Wh(hVg hGhghh jiklhm#ZM~TEXTSTR56TEXTSTR56Dynamic TriggersMS Sans Serifdarkredi bi % tui8y i[iiijrDEPTODEPTOgray12nonewhitenoneUj$jLThj\jlCMPTXT58CMPTXT58WjjVj$ k Gkgk0h jiklkDm$Z~TEXTSTR59TEXTSTR59DevelopmentMS Sans Serifgray8l bl  % t u-iyql0[l<lPl\rGRAPHIC217GRAPHIC217gray12transparentwhitesolidm bm  % tu>i ym0[m<&rRECT281RECT281graynonem bm % GROUP302GROUP302np bn % tuEiry n[nnnrTEXT256TEXT256gray16transparentsolidUnoTmoo$CMPTXT257CMPTXT257WoDoVn oGogph jiklpmZMl~TEXTSTR258TEXTSTR258 Dynamic Trigger - General Control MS Sans Serifdarkredp bp % tuUiyp[p&rRECT317RECT317graynoneq\ bql % q|GROUP342GROUP342 qq qr % rGROUP332GROUP332 r4r qs % t uiyqs[s s4s@rGRAPHIC146GRAPHIC146gray12transparentwhitesolids bs % tuTiyttRECT347RECT347gray8solidt bt % tuEiry t[uuu rGRAPHIC349GRAPHIC349gray16transparentsolidUu@uhTtuxuCMPTXT257CMPTXT257WuvVu@ v(Gv8gvTh jiklvhm7ZM~TEXTSTR258TEXTSTR258 DML Action Audit Log MS Sans Serifdarkredv bv % vGROUP350GROUP350 w wxw vxw % t9uXiyqw`RECT252RECT252r0g50b75xp vxx % tDuXiyqxMGRAPHIC253GRAPHIC253darkredy0 vxy@ % tNuXiyqyP GRAPHIC338GRAPHIC338r100g0b0y by % yGROUP341GROUP341 z(z{|d~z y`z % tfuCiyqzRECT263RECT263gray8{t y`{ % tkuGiyq{`RECT252RECT252r0g50b75|4 y`|D % tuGiyq|TMGRAPHIC253GRAPHIC253darkred} y`}, % ttuFiy }<[}H}T}`rTEXT264TEXT264gray8nonenoneU}}T|d}}CMPTXT265CMPTXT265W}~XV} ~hG~xg~h jikl~m:Z~TEXTSTR266TEXTSTR266InsertingMS Sans Serifblack` y`p % tuFi y [rGRAPHIC267GRAPHIC267lgray8nonenoneUT~ CMPTXT265CMPTXT265W,V Ggh jiklm9Z~TEXTSTR266TEXTSTR266UpdatingMS Sans Serifblack| y` % tuGiyq GRAPHIC339GRAPHIC339r100g0b0d y`t % tuFiy [rGRAPHIC340GRAPHIC340gray8nonenoneUTCMPTXT265CMPTXT265 W0!V Ggh jiklm8Z~TEXTSTR266TEXTSTR266DeletingMS Sans Serifblack"Lb= @gh jikl[0<HZr~D !"#$%&'()*+,-./@01@2634D56789:;dMS Sans Serifblackgray16transparentblackblacksolid# -NO>_ ^o`a>iy]d< DVLADVLAMAIN$ X% T  % tuEiry 0[<P\rTEXT256TEXT256gray16transparentsolid&U|'TXCMPTXT257CMPTXT257(WT)V| dGtgh jiklm?ZM~TEXTSTR258TEXTSTR258 Default Values - Literal Assignments MS Sans Serifdarkred|* T % tuSiyRECT241RECT241gray8whitesolidP+ T` % tuWiyqpGRAPHIC259GRAPHIC259r100g75b50, T % GROUP291GROUP291- 8t.  % t$uCi]yqRECT263RECT263gray8/  % t)uGiyq`RECT252RECT252r0g50b75D0 T % tTuGiyqdMGRAPHIC253GRAPHIC253darkred,1 < % t2uFiy L[XdprTEXT264TEXT264gray8nonenonel2U3TtCMPTXT265CMPTXT2654Wh5V xGgh jiklm>Z~TEXTSTR266TEXTSTR266InsertingMS Sans Serifblackp6  % t]uFi y [rGRAPHIC267GRAPHIC267gray8nonenone7U8T CMPTXT265CMPTXT2659W<:V Ggh jiklm=Z~TEXTSTR266TEXTSTR266UpdatingMS Sans SerifblackT; Td % tGROUP290GROUP290< x8xlL= \ % tuCiiyqlGRAPHIC274GRAPHIC274gray8>  % tuGiyq(GRAPHIC259GRAPHIC259r100g75b50?  % tuFiy [(4rGRAPHIC269GRAPHIC269gray8nonenone@UT|AT8CMPTXT265CMPTXT265BW,CVT <GLgXh jikllm<Z~TEXTSTR266TEXTSTR266NVLMS Sans Serifblack0D @ % tuEi)y P[\htrGRAPHIC270GRAPHIC270gray8nonenoneEUFTxCMPTXT265CMPTXT265GWlHV |Ggh jiklm;Z~TEXTSTR266TEXTSTR266AssignmentMS Sans SerifblackLI \ % tuFi y   <!IMAGE272IMAGE272J   % tuFi y   <"IMAGE273IMAGE273tK T % GROUP330GROUP330L |LM \ % tzuWiyql`RECT252RECT252r0g50b75 N  % tuWiyq,MGRAPHIC253GRAPHIC253darkredOLT= @g<h jiklP\[h|Zr~D !"#$%&'()*+,-./@01@2634D56789:;dMS Sans Serifblackgray!l16transparentblackblacksolid8P D-NO>_ ^oP`a>iy\]d DVDADVDAMAINQ  Hh\R l % tuEiry |[rTEXT256TEXT256gray16transparentsolidSUTTCMPTXT257CMPTXT257UW0VV Ggh jiklmJZM~TEXTSTR258TEXTSTR258 Default Values - Dynamic Assignments MS Sans SerifdarkredW  % tuSiyRECT241RECT241gray8whitesolidX  % tuWiyqGRAPHIC259GRAPHIC259r100g75b50$Y 4 % DGRAPHIC298GRAPHIC298Z @[ $ % t$uCi]yq4RECT263RECT263gray8\  % t)uGiyq`RECT252RECT252r0g50b75]  % tTuGiyqMGRAPHIC253GRAPHIC253darkredx^  % t2uFiy [rTEXT264TEXT264gray8nonenone_U`T$CMPTXT265CMPTXT265aWDbV Ggh jiklmjZ~TEXTSTR266TEXTSTR266InsertingMS Sans Serifblackc  % t]uFi y [rGRAPHIC267GRAPHIC267gray8nonenonedU HeTXhCMPTXT265CMPTXT265fWgV Gg(h jikl<miZ~TEXTSTR266TEXTSTR266UpdatingMS Sans Serifblackh  % GROUP290GROUP290i j H % tuCiiyqGRAPHIC274GRAPHIC274gray8Tk Hd % tuGiyqtGRAPHIC259GRAPHIC259r100g75b50<l HL % tuFiy \[htrGRAPHIC269GRAP #lHIC269gray8nonenonemUnTCMPTXT265CMPTXT265oWxpV Ggh jiklmhZ~TEXTSTR266TEXTSTR266NVLMS Sans Serifblack|q H % tuEi)y [rGRAPHIC270GRAPHIC270gray8nonenonerUsT(CMPTXT265CMPTXT265tWHuV Ggh jiklmgZ~TEXTSTR266TEXTSTR266AssignmentMS Sans Serifblackv H % tuFi y   <#IMAGE272IMAGE272Hw HX % tuFi y   <$IMAGE273IMAGE273x  % GROUP331GROUP331y z h % tzuWiyq`RECT252RECT252r0g50b75X{ hh % tuWiyqxMGRAPHIC253GRAPHIC253darkred|L= @gh jikl[Zr~D !"#$%&'()*+,-./@01@2634D56789:;dMS Sans Serifblackgray16transparentblackblacksolid} -NO>_ ^o`a>iy]d4 CCVICCVIMAIN~ 8  % tuEiry [rTEXT256TEXT256gray16transparentsolidUT,<CMPTXT257CMPTXT257W\V Ggh jikl(mNZM~TEXTSTR258TEXTSTR258 Check Column Value - Integrity MS Sans Serifdarkred  % tuSiy(RECT241RECT241gray8whitesolidL= @g4h jiklHT[`tZr~D !"#$%&'()*+,-./@01@2634D56789:;dMS Sans Seri0lfblackgray16transparentblackblacksolid0 <-NO>_ ^oH`a>iyT]d CCVSCCVSMAIN |4 D % tuEiry T[`trTEXT256TEXT256gray16transparentsolidUT|CMPTXT257CMPTXT257WxV ˆG˜gh jiklmZM~TEXTSTR258TEXTSTR258 Check Column Value - Standards MS Sans SerifdarkredÜ ì % tuSiyüRECT241RECT241gray8whitesolidL= @gh jikl[  ,8Zr~D !"#$%&'()*+,-./@01@2634D56789:;dMS Sans Serifblackgray16transparentblackblacksolid -NO>_ ^o`a>iy]dʈ CCVRCCVRMAIN (Ɍ D % tuEiry [  ,rTEXT256TEXT256gray16transparentsolidULtT(ȄȔCMPTXT257CMPTXT257Wȴ$VL 4GDghh jikl|mZM~TEXTSTR258TEXTSTR258 Check Column Value - Range MS Sans SerifdarkredD DT % tuSiydp|RECT241RECT241gray8whitesolidLD= @g̈h jikl̨̜[̴Zr~D !"#$%&'()*+,-./@01@2634D56789:;dMS Sans Serifblackgray16transparentblackblacksolid̈́ ͐-NO>_ ^o͜`a>iyͨ]d4 CCVCCCVCMAIN 8Έ Θ % tuEiry Ψ[δrTEXT256TEXT256gray16transparentsolidUT,<CMPTXT257CMPT@lXT257W\V Ggh jikl(mZM~TEXTSTR258TEXTSTR258 Check Column Value - Consistency MS Sans Serifdarkred  % tuSiy(RECT241RECT241gray8whitesolidL= @g4h jiklHT[`tӀӌZr~D !"#$%&'()*+,-./@01@2634D56789:;dMS Sans Serifblackgray16transparentblackblacksolid0 <-NO>_ ^oH`a>iyT]d EAPBEAPBMAIN |4 ӘD % tuEiry T[`tՀrTEXT256TEXT256gray16transparentsolidUՠT|CMPTXT257CMPTXT257WxVՠ ֈG֘gh jiklm ZM~TEXTSTR258TEXTSTR258 Execute Anonymous PL/SQL Block MS Sans Serifdarkredל Ә׬ % tuSiy׼RECT241RECT241gray8whitesolidLӘ= @gh jikl[  ,8Zr~D !"#$%&'()*+,-./@01@2634D56789:;dMS Sans Serifblackgray16transparentblackblacksolid -NO>_ ^o`a>iy]d EPPCEPPCMAIN Pݸ޴t4 D % tuEiry ([4HTrTEXT256TEXT256gray16transparentsolidUtܜTPܬܼCMPTXT257CMPTXT257WLVt \Glgݔh jiklݨmZM~TEXTSTR258TEXTSTR258 Execute Packaged Procedure Code MS Sans Serifdarkredp Dހ % tuSiyސޜިRECT241RECT241gray8whitesolidD DT % tuWiyqd`PlRECT252RECT252r0g50b75 D % tuWiyq$MGRAPHIC253GRAPHIC253darkred D % tuWiyq GRAPHIC338GRAPHIC338r100g0b0L D\ % lGROUP341GROUP341 x8<@L \ % teuCiyqlRECT263RECT263gray8  % tjuGiyq(`RECT252RECT252r0g50b75  % tuGiyqMGRAPHIC253GRAPHIC253darkred  % tsuFiy [rTEXT264TEXT264gray8nonenoneU<TL\CMPTXT265CMPTXT265W|V G gh jikl0mZ~TEXTSTR266TEXTSTR266InsertingMS Sans Serifblack  % tuFi y [ ,8rGRAPHIC267GRAPHIC267gray8nonenoneUXT<CMPTXT265CMPTXT265W0VX @GPg`h jikltmZ~TEXTSTR266TEXTSTR266UpdatingMS Sans Serifblack   % tuGiyq0 GRAPHIC339GRAPHIC339r100g0b0  % tuFiy [$0<rGRAPHIC340GRAPHIC340gray8nonenoneU\T@CMPTXT265CMPTXT265W4V\ DGTgdh jiklxmZ~TEXTSTR266TEXTSTR266DeletingMS Sans Serifblack< DL % tu~iy\htGRAPHIC355GRAPHIC355gray8whitesolidLD= 0gh jikl[Zr~D !"#$%&'()*+,-./@01@2634D56789:;dMS Sans Serifblackwhitenoneblackwhitenone;t`lT:p%CHECK_PACKAGE_FAILURECHECK_PACKAGE_FAILURE:&QUERY_MASTER_DETAILSQUERY_MASTER_DETAILS4:T'CLEAR_ALL_MASTER_DETAILSCLEAR_ALL_MASTER_DETAILS:(PKG_FRMPKG_FRM:)PKG_FRMPKG_FRMKbb$bDbdbbbbbb(bHbhbbbbb b (b Hb hbbbbb,J8DcVA22VA22Ztnkw_obj_frm.olb]^DNKW_OBJ_FRM^DJVA22LJXdcVA21VA21Znkw_obj_frm.olb]^dNKW_OBJ_FRM^d8JVA21lJxcVA20VA20Znkw_obj_frm.olb]0^NKW_OBJ_FRM^XJVA20JcVA19VA19Znkw_obj_frm.olb]P^<NKW_OBJ_FRM^xJVA19JcVA18VA18Z nkw_obj_frm.olb]4p^\NKW_OBJ_FRM^JVA18JcVA17VA17Z,nkw_obj_frm.olb]T^|NKW_OBJ_FRM^JVA17JcVA16VA16Z4Lnkw_obj_frm.olb]t^NKW_OBJ_FRM^JVA16VA15VA15HIC340gray8nonenoneU\T@CMPTXT265CMPTXT265W4V\ DGTgdh jiklxmZ~TEXTSTR266TEXTSTR266DeletingMS Sans Serifblack< DL % tu~iy\htGRAPHIC355GRAPHIC355gray8whitesolidLD= 0gh jikl[Zr~D !"#$%&'()*+,-./@01@2634D56789:;dMS Sans Serifblackwhitenoneblackwhitenone;tplJ(cZXpnkw_obj_frm.olb]^(NKW_OBJ_FRM^(JVA150J<HcVA14VA14Zxnkw_obj_frm.olb]^HNKW_OBJ_FRM^HJVA14PJ\hcVA13VA13Znkw_obj_frm.olb]^hNKW_OBJ_FRM^h<JVA13pJ|cVA12VA12Znkw_obj_frm.olb]4^ NKW_OBJ_FRM ^\JVA12 JcVA11VA11 Znkw_obj_frm.olb ]T ^@NKW_OBJ_FRM^|JVA11JcVA10VA10Znkw_obj_frm.olb]8t^`NKW_OBJ_FRM^JVA10JcVA09VA09Z0nkw_obj_frm.olb]X^NKW_OBJ_FRM^JVA09JcVA08VA08Z8Pnkw_obj_frm.olb]x^NKW_OBJ_FRM^JVA08 J  (cVA07VA07Z X pnkw_obj_frm.olb ]  !^ ( NKW_OBJ_FRM"^ ( JVA07 0#J < HcVA06VA06$Z x nkw_obj_frm.olb%]  &^ H NKW_OBJ_FRM'^ H JVA06 P(J \ hcVA05VA05)Z  nkw_obj_frm.olb*]  +^ h NKW_OBJ_FRM,^ h <JVA05 p-J | cVA04VA04.Z  nkw_obj_frm.olb/]  40^  NKW_OBJ_FRM1^  \JVA04 2J  cVA03VA033Z  nkw_obj_frm.olb4]T5^ @NKW_OBJ_FRM6^ |JVA037JcVA02VA028Znkw_obj_frm.olb9]8t:^`NKW_OBJ_FRM;^JVA02<JcVA01VA01=lZ0nkw_obj_frm.olb>]X?^NKW_OBJ_FRM@^JVA01AJcWHITEWHITEBZ8Pnkw_obj_frm.olbC]xD^NKW_OBJ_FRME^JWHITEFJ(cOFFOFFGZXpnkw_obj_frm.olbH]I^(NKW_OBJ_FRMJ^(JOFF0KJ<jcBOLDBOLDLOjhMN 3+`viynkMAINMAIN1998Ne@@@@d@@L@@@ T@!@#@$\@%@'@(p@)@+$@, @,@-@.t@/\@0@0@14OdPCDEFGHlASYSTEM.CURRENT_BLOCKSYSTEM.CURRENT_BLOCKPPKG_FRMQd $C DEFGHAMAIN.TABLE_NAMEMAIN.TABLE_NAMER]LS^tTABLE_NAMET^MAINU0PpP25_05_AGO_200203_04_25P26_05_AGO_200203_04_25P27_05_AGO_200203_04_25P28_05_AGO_200203_04_25P29_05_AGO_200203_04_25P30_05_AGO_200203_04_25P31_05_AGO_200203_04_25P10_05_AGO_200203_04_25hVd|C DEFGH$ALOG.COLUMN_IDLOG.COLUMN_IDW]X^COLUMN_IDY^LOGZDP25_05_AGO_200203_04_25[dC DEFGHALOG.COLUMN_NAMELOG.COLUMN_NAME\]P]^d<COLUMN_NAME^^dxLOG_P25_05_AGO_200203_04_25`d4LCDEFGHADVDA.COLUMN_NAMEDVDA.COLUMN_NAMEa]tb^COLUMN_NAMEc^DVDAd ,P25_05_AGO_200203_04_25P27_05_AGO_200203_04_25edCDEFGH`ADVLA.COLUMN_IDDVLA.COLUMN_IDf],g^LCOLUMN_IDh^LTDVLAiP26_05_AGO_200203_04_25jd(CDEFGHADVLA.COLUMN_NAMEDVLA.COLUMN_NAMEk]Pl^xCOLUMN_NAMEm^DVLAnP26_05_AGO_200203_04_25XodlCDEFGH ADVDA.COLUMN_IDDVDA.COLUMN_IDp]q^COLUMN_IDlr^ DVDAs 4P27_05_AGO_200203_04_25 td  CDEFGH!hACCVI.COLUMN_IDCCVI.COLUMN_IDu] !4v^ T!$COLUMN_IDw^ T!\CCVIx!P28_05_AGO_200203_04_25"yd""0CDEFGH"ACCVI.COLUMN_NAMECCVI.COLUMN_NAMEz]"X"{^!"COLUMN_NAME|^!"CCVI}"P28_05_AGO_200203_04_25#`~d#t#CDEFGH$ACCVS.COLUMN_IDCCVS.COLUMN_ID]##^##COLUMN_ID^#$CCVS$<P29_05_AGO_200203_04_25$d$$CDEFGH%|ACCVS.COLUMN_NAMECCVS.COLUMN_NAME]% %H^$\%4COLUMN_NAME^$\%pCCVS%P29_05_AGO_200203_04_25&d&(&<CDEFGH&ACCVR.COLUMN_IDCCVR.COLUMN_ID]&d&^%&COLUMN_ID^%&CCVR&P30_05_AGO_200203_04_25'hd''CDEFGH(0ACCVR.COLUMN_NAMECCVR.COLUMN_NAME]''^''COLUMN_NAME^'($CCVR(PP30_05_AGO_200203_04_25(d((CDEFGH)ACCVC.COLUMN_IDCCVC.COLUMN_ID]))P^(p)@COLUMN_ID^(p)xCCVC)P31_05_AGO_200203_04_25*d*4*LCDEFGH*ACCVC.COLUMN_NAMECCVC.COLUMN_NAME]*t*^)*COLUMN_NAME^)*CCVC+P31_05_AGO_200203_04_25+td+CDEFGH+ASYSTEM.MESSAGE_LEVELSYSTEM.MESSAGE_LEVEL++QUERY_MASTER_DETAILSP4_05_AGO_200203_04_25,\d,xCDEFGH,ASYSTEM.MASTER_BLOCKSYSTEM.MASTER_BLOCK,CLEAR_ALL_MASTER_DETAILS-$d-HCDEFGH-lASYSTEM.COORDINATION_OPERATIONSYSTEM.COORDINATION_OPERATION-CLEAR_ALL_MASTER_DETAILS-d.CDEFGH.4ASYSTEM.TRIGGER_BLOCKSYSTEM.TRIGGER_BLOCK.TCLEAR_ALL_MASTER_DETAILS.d.CDEFGH.ASYSTEM.CURSOR_ITEMSYSTEM.CURSOR_ITEM//<CLEAR_ALL_MASTER_DETAILSP10_05_AGO_200203_04_25/d/CDEFGH/ASYSTEM.FORM_STATUSSYSTEM.FORM_