ROS.60050( pr    !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~\(h rwldd_\(h rwlfx]f_\(h rwspar_\^(h rwpwoff]f_tu0808Ys[9\9(h rwvrb]_fg\7(h rwvdm]_fg\6(h rwvlp]_fg\8(h rwvpf]_fg\e(h open_\@(h save_\r(h rwrn_\(h print_\(h cut_\(h copy_\(h paste_\p3(h rwzmin_\p4(h rwzmot_\1(h rwfwiz_\Y(h help_tu0I0808GZ11s[ 9\\\ \ \q)(h rwlpl]_fg\q(h rwlpc]_fg\q*(h rwlpg]_fg\q8(h rwlpf]_fgtu|0000m|port a42OlPrints the active report!OlClear_86edOlDeletes the selected objects08r !gr 08 rwetb"pe08etb_fpea/08 tl1t08W5 00 @ 08erifL 08 Mis 08WQ 08S 08 SerifT 08,W @08#X `08([ 00sagen 88 088Sans Ser P88  `88( p88ge 88  88ns Serif 88 881@ 8808z 088box, @888 P88 88 graic 88 88 88" 88 finispt 88 88 c P88 generate_to_web c! c!" c!"S c!T# graphic drawnFG123vOP$%4567 intro mlabel(OP12,h-A  MS Sans Serif567 finishopts radiog rwetc_rgeh rwetc_rgea9L:FG,h-d  MS Sans Serif generate_to_web checkbox  MS Sans Serif(sage  MS Sans Serif@r08+,2p6p60088@BCD_1 pekuorep pgoqorepp (0@YZ0[\]^_xb8b8d8f8hjkplplpttpupfthG_EMPNOg=*%&4G_EMPNOLIST_G_EMPNO/bpclmnopqprrpspwwxyz{0|dpē` 88 P 88RI  0 88 ri&00x $D r88g25b88/,08x *popwwx 00r100g75b100,08x *p 00r100g100b100@8&p'+,2p6POutput ModegQ_1mbpchijknopqrspvvpwpzz{|}~000000ppppppiDEPT BACPwbpcrstuPRun in Background/bpcopqrstpzzp{pP_USER_CONNECT`lZp[de(fpjpppp\ORIENTATION NoDefaultPOrieB_DEPTNO0\JpKTU(VpZ/bpcklmnoppvvpwpwwxyz{0|0}0~000pF_DEPTNO0pppp]DECIMALDecimal Indicator/bpcmnopqrpvvpwpwwxyz{0|0}0~000ppppppp^THOUSANDSThousands Indicator/bpclmnopqprrpspsstu vx0y0z0{0|0}0~ppppppp_CURRENCYCurrency Symbol/bpcjklmnoprrpspuuvwxy0z0{0|0}0~0ppppppp`COPIES1Number of Copies/bpcmnopqrpvvpwp||}~ 000000pppppppaDESFORMATdfltDestination Formatk/bpcklmnoppvvpwpwwxy z|0}0~0000pppppppbDESNAMEDestination Name /bpcklmnoppvvpwp~~000000pppppppcDESTYPEScreenPDestination Type>$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 o $ c"FUNCTION"AFTERREPORT"RETURN"BOOLEAN"G$_REPORT_SECURITY"G$_REPORT_REVOKE_ACCESS"TRUE"OTHERS"FALSE"" #$(357<?CGHLOSW\]_cfjlnh,WkeZ SeZO          dͫͫͫͫͫͫͫ0D ??  &'$%$%kkhg!`D0 AFTERREPORT  &2 %&X\@@00b0808function AfterReport return boolean is begin G$_REPORT_SECURITY.G$_REPORT_REVOKE_ACCESS; return (TRUE); exception when others then return (FALSE); end;.:00008&&select * from emp where deptno = :dept*>FNW(Z^bg(nrw(~(((SQL*ReportWriterKgREPORTEKUpgxjwordt/tEKUxg  EKUxi vx * , .0 00r75g100b100208x * , .0 00r88g100b10000r75g75b100008x ( * ,. 00r88g75b100x0r 88u z 2jk0l0m0n8p8rt v0x0yz{0|}~ppppppppr%rHrHr]r]r]r]r]rbbrcrffrjrrrsrtreC Rj xg  | 2



$GXJWORDB(F0JK@N@R@V@Z0^0_0`0a0b0c d0f0ghi8j8l0nopqrpsppfr]r]r@@PjjReport ParametersEnter values for the parameters$00x !"black(00x " $&rwhite%00x "#green)00x# $&' darkgreen(00x " $&gray96 = = =(00x " $&8jgray92zzz(00x " $&gray88(00x " $&gray84(((%00x !"#r0g0b0(00x "$%&p[ r25g0b0@(00x "$%& r50g0b0(00x "$%&_H r75g0b0(00x "$%& r88g0b0(00x "$%& r100g0b0(00x!" $&r0g0b50*00x "$ &(r25g0b50@*00x "$ &(r50g0b50*00x "$ &(r75g0b50p[*00x "$ &(r88g0b50,00x $& (* r100g0b50(00x!" $&r0g0b75*00x "$ &(r25g0b75@0*00x "$ &(r50g0b75p*00x "$ &(r75g0b75na*00x "$ &(r88g0b75l,00x $& (*0 r100g0b75(00x!" $&r0g0b88*00x "$ &(Pr25g0b88@ T*00x "$ &(r50g0b88*00x "$ &(r75g0b88*00x "$ &(r88g0b88,00x $& (* r100g0b88(00x"# $& r0g0b100,00x $& (*! r25g0b100@,00x $& (*RE" r50g0b100,00x $& (*KE# r75g0b100,00x $& (*$ r88g0b100,00x $& (*n% r100g0b100&00x  "$&gray*00x " $ &('darkgray&00x "$(cyanr *00x" $ &()darkcyan(00x " $&*gray80333333(00x " $&+gray76=p=p=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%.r0g25b0@)00x " $&'/r25g25b0@@)00x " $&'D0r50g25b0@)00x " $&'1r75g25b0@)00x " $&'2r88g25b0@+00x $ &()g3 r100g25b0@*00x" $ &(4r0g25b50@RE,00x $ & (*5 r25g25b50@@,00x $ & (*6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (* b9 r100g25b50@*00x" $ &(CC:r0g25b750@E),00x $ & (*he; r25g25b75@@,00x $ & (*&< r50g25b75@,00x $ & (*= r75g25b75@,00x $ & (*Re> r88g25b75@,00x $ & (*t? r100g25b75@*00x" $ &( *@r0g25b885@5g,00x $ & (*8A r25g25b88@@,00x $ & (*5gB r50g25b88@,00x $ & (*00C r75g25b88@@ xr.hh,pjROSATTRIBSclass attributes0+hh)0ROSLFDESCros lf descripD)hh'ROSOBJMAPros name->id+hh)ROSSTRINGStk2 uiStrings**hh(8jROSSTRUCTSstruct types*hh(ROSTK2RESVtk2 reservedhhSRW2_ANCHOR8&h!"h#$SRW2_BODY_LOCATION $h h!"pfSRW2_BOILERPLATEhhSRW2_BUTTON!hhSRW2_COLUMN#hh !SRW2_DATA_MODEL $h h!"SRW2_DISPLAY_TAG%h !h"#8rSRW2_DISTRIBUTION'0 hh0SRW2_ELEMENThhSRW2_FIELD)h$%h&'SRW2_FORMAT_EXCEPTION&hh SRW2_FRAME hh SRW2_GROUP#hh !SRW2_GROUP_NODE#"hh SRW2_HYPERLINK"$h h!"SRW2_JAVA_APPLET$(h#$h%&SRW2_JAVA_PROPERTIES%hhhSRW2_LAYOUT p%h !h"#zSRW2_LAYOUT_GROUP hhhSRW2_LINKhhRSRW2_LISTS `hhjSRW2_MATRIXr'h"#h$%SRW2_OGD_COLUMN_MAP$h h!"SRW2_OG_DOCUMENT#hh !0hSRW2_PARAM_FORMrhhSRW2_QUERYh%h !h"#SRW2_TEXT_SEGMENT^0^hhlTOOL_ACCESSr hh|TOOL_COMMENT hhTOOL_LIBRARY hhp^TOOL_MODULEhhhprTOOL_PLSQLx$pp"0VG_COLORVG_COLOR+pp $&'()VG_COLORITEMIDS@^+pp $&'()VG_COLORCELLIDS@v-pp &()*+VG_COLORNAME_SET@ /pp (*+,-VG_COLORNAME_LENGTH l/pp (*+,-VG_COLORCOLOR_NAMEx'pp "#$%VG_COLORRED ^)pp "$%&'VG_COLORGREEN uv)pp "$%&'VG_COLORBLUE v"x #Empno@Z"x lEnamet xJob xMgr%x#8` Hiredatekl xxSal!xComm#x!erDeptno0x.Word output example.x,0Using New version!xnsDept88  `88( p88ge 88  88ns Serif 88 881@ 8808z 088box, @888 P88 88 graic 88 88 88" 88 finispt 88 88 c P88 generate_to_web c! c!" c!"S c!T# graphic drawnFG123vOP$%4567 intro mlabel(OP12,h-A  MS Sans Serif567 finishopts radiog rwetc_rgeh rwetc_rgea9L:FG,h-d  MS Sans Serif generate_to_web checkbox  MS Sans Serif(sage  MS Sans SerifPr 88pj RIBSclass attributes0+hh)0ROSLFDESCros lf descripD)hh'ROSOBJMAPros name->id+hh)ROSSTRINGStk2 uiStrings**hh(8jROSSTRUCTSstruct types*hh(ROSTK2RESVtk2 reservedhhSRW2_ANCHOR8&h!"h#$SRW2_BODY_LOCATION $h h!"pfSRW2_BOILERPLATEhhSRW2_BUTTON!hhSRW2_COLUMN#hh !SRW2_DATA_MODEL $h h!"SRW2_DISPLAY_TAG%h !h"#8rSRW2_DISTRIBUTION'0 hh0SRW2_ELEMENThhSRW2_FIELD)h$%h&'SRW2_FORMAT_EXCEPTION&hh SRW2_FRAME hh SRW2_GROUP#hh !SRW2_GROUP_NODE#"hh SRW2_HYPERLINK"$h h!"SRW2_JAVA_APPLET$(h#$h%&SRW2_JAVA_PROPERTIES%hhhSRW2_LAYOUT p%h !h"#zSRW2_LAYOUT_GROUP hhhSRW2_LINKhhRSRW2_LISTS `hhjSRW2_MATRIXr'h"#h$%SRW2_OGD_COLUMN_MAP$h h!"SRW2_OG_DOCUMENT#hh !0hSRW2_PARAM_FORMrhhSRW2_QUERYh%h !h"#SRW2_TEXT_SEGMENT^0^hhlTOOL_ACCESSr hh|TOOL_COMMENT hhTOOL_LIBRARY hhp^TOOL_MODULEhhhprTOOL_PLSQLx$pp"0VG_COLORVG_COLOR+pp $&'()VG_COLORITEMIDS@^+pp $&'()VG_COLORCELLIDS@v-pp &()*+VG_COLORNAME_SET@ /pp (*+,-VG_COLORNAME_LENGTH l/pp (*+,-VG_COLORCOLOR_NAMEx'pp "#$%VG_COLORRED ^)pp "$%&'VG_COLORGREEN uv)pp "$%&'VG_COLORBLUE v"x #Empno@Z"x lEnamet xJob xMgr%x#8` Hiredatekl xxSal!xComm#x!erDeptno0x.Word output example.x,0Using New version!xnsDept88  `88( p88ge 88  88ns Serif 88 881@ 8808z 088box, @888 P88 88 graic 88 88 88" 88 finispt 88 88 c P88 generate_to_web c! c!" c!"S c!T# graphic drawnFG123vOP$%4567 intro mlabel(OP12,h-A  MS Sans Serif567 finishopts radiog rwetc_rgeh rwetc_rgea9L:FG,h-d  MS Sans Serif generate_to_web checkbox  MS Sans Serif(sage  MS Sans Serif`r 88pj RIBSclass attributes0+hh)0ROSLFDESCros lf descripD)hh'ROSOBJMAPros name->id+hh)ROSSTRINGStk2 uiStrings**hh(8jROSSTRUCTSstruct types*hh(ROSTK2RESVtk2 reservedhhSRW2_ANCHOR8&h!"h#$SRW2_BODY_LOCATION $h h!"pfSRW2_BOILERPLATEhhSRW2_BUTTON!hhSRW2_COLUMN#hh !SRW2_DATA_MODEL $h h!"SRW2_DISPLAY_TAG%h !h"#8rSRW2_DISTRIBUTION'0 hh0SRW2_ELEMENThhSRW2_FIELD)h$%h&'SRW2_FORMAT_EXCEPTION&hh SRW2_FRAME hh SRW2_GROUP#hh !SRW2_GROUP_NODE#"hh SRW2_HYPERLINK"$h h!"SRW2_JAVA_APPLET$(h#$h%&SRW2_JAVA_PROPERTIES%hhhSRW2_LAYOUT p%h !h"#zSRW2_LAYOUT_GROUP hhhSRW2_LINKhhRSRW2_LISTS `hhjSRW2_MATRIXr'h"#h$%SRW2_OGD_COLUMN_MAP$h h!"SRW2_OG_DOCUMENT#hh !0hSRW2_PARAM_FORMrhhSRW2_QUERYh%h !h"#SRW2_TEXT_SEGMENT^0^hhlTOOL_ACCESSr hh|TOOL_COMMENT hhTOOL_LIBRARY hhp^TOOL_MODULEhhhprTOOL_PLSQLx$pp"0VG_COLORVG_COLOR+pp $&'()VG_COLORITEMIDS@^+pp $&'()VG_COLORCELLIDS@v-pp &()*+VG_COLORNAME_SET@ /pp (*+,-VG_COLORNAME_LENGTH l/pp (*+,-VG_COLORCOLOR_NAMEx'pp "#$%VG_COLORRED ^)pp "$%&'VG_COLORGREEN uv)pp "$%&'VG_COLORBLUE v"x #Empno@Z"x lEnamet xJob xMgr%x#8` Hiredatekl xxSal!xComm#x!erDeptno0x.Word output example.x,0Using New version!xnsDept88  `88( p88ge 88  88ns Serif 88 881@ 8808z 088box, @888 P88 88 graic 88 88 88" 88 finispt 88 88 c P88 generate_to_web c! c!" c!"S c!T# graphic drawnFG123vOP$%4567 intro mlabel(OP12,h-A  MS Sans Serif567 finishopts radiog rwetc_rgeh rwetc_rgea9L:FG,h-d  MS Sans Serif generate_to_web checkbox  MS Sans Serif(sage  MS Sans SerifpTrO N(0@@00@@@@@@000000ppp 00880@@11AA AAAA11A"A&1*1+A.A2A6A:A>AB1F1GHIJKLMdpēLPB `` jjLPB ``LPB ``  !"h#$SRW2_BODY_LOCATION $h h!"pfSRW2_BOILERPLATEhhSRW2_BUTTON!hhSRW2_COLUMN#hh !SRW2_DATA_MODEL $h h!"SRW2_DISPLAY_TAG%h !h"#8rSRW2_DISTRIBUTION'0 hh0SRW2_ELEMENThhSRW2_FIELD)h$%h&'SRW2_FORMAT_EXCEPTION&hh SRW2_FRAME hh SRW2_GROUP#hh !SRW2_GROUP_NODE#"hh SRW2_HYPERLINK"$h h!"SRW2_JAVA_APPLET$(h#$h%&SRW2_JAVA_PROPERTIES%hhhSRW2_LAYOUT p%h !h"#zSRW2_LAYOUT_GROUP hhhSRW2_LINKhhRSRW2_LISTS `hhjSRW2_MATRIXr'h"#h$%SRW2_OGD_COLUMN_MAP$h h!"SRW2_OG_DOCUMENT#hh !0hSRW2_PARAM_FORMrhhSRW2_QUERYh%h !h"#SRW2_TEXT_SEGMENT^0^hhlTOOL_ACCESSr hh|TOOL_COMMENT hhTOOL_LIBRARY hhp^TOOL_MODULEhhhprTOOL_PLSQLx$pp"0VG_COLORVG_COLOR+pp $&'()VG_COLORITEMIDS@^+pp $&'()VG_COLORCELLIDS@v-pp &()*+VG_COLORNAME_SET@ /pp (*+,-VG_COLORNAME_LENGTH l/pp (*+,-VG_COLORCOLOR_NAMEx'pp "#$%VG_COLORRED ^)pp "$%&'VG_COLORGREEN uv)pp "$%&'VG_COLORBLUE v"x #Empno@Z"x lEnamet xJob xMgr%x#8` Hiredatekl xxSal!xComm#x!erDeptno0x.Word output example.x,0Using New version!xnsDept88  `88( p88ge 88  88ns Serif 88 881@ 8808z 088box, @888 P88 88 graic 88 88 88" 88 finispt 88 88 c P88 generate_to_web c! c!" c!"S c!T# graphic drawnFG123vOP$%4567 intro mlabel(OP12,h-A  MS Sans Serif567 finishopts radiog rwetc_rgeh rwetc_rgea9L:FG,h-d  MS Sans Serif generate_to_web checkbox  MS Sans Serif(sage  MS Sans Serifr pgoqorep@00@@@@@@000000ppp 00880@@11AA AAAA11A"A&1*1+A.A2A6A:A>AB1F1GHIJKLMdpēLPB `` jjLPB ``LPB ``  !"h#$SRW2_BODY_LOCATION $h h!"pfSRW2_BOILERPLATEhhSRW2_BUTTON!hhSRW2_COLUMN#hh !SRW2_DATA_MODEL $h h!"SRW2_DISPLAY_TAG%h !h"#8rSRW2_DISTRIBUTION'0 hh0SRW2_ELEMENThhSRW2_FIELD)h$%h&'SRW2_FORMAT_EXCEPTION&hh SRW2_FRAME hh SRW2_GROUP#hh !SRW2_GROUP_NODE#"hh SRW2_HYPERLINK"$h h!"SRW2_JAVA_APPLET$(h#$h%&SRW2_JAVA_PROPERTIES%hhhSRW2_LAYOUT p%h !h"#zSRW2_LAYOUT_GROUP hhhSRW2_LINKhhRSRW2_LISTS `hhjSRW2_MATRIXr'h"#h$%SRW2_OGD_COLUMN_MAP$h h!"SRW2_OG_DOCUMENT#hh !0hSRW2_PARAM_FORMrhhSRW2_QUERYh%h !h"#SRW2_TEXT_SEGMENT^0^hhlTOOL_ACCESSr hh|TOOL_COMMENT hhTOOL_LIBRARY hhp^TOOL_MODULEhhhprTOOL_PLSQLx$pp"0VG_COLORVG_COLOR+pp $&'()VG_COLORITEMIDS@^+pp $&'()VG_COLORCELLIDS@v-pp &()*+VG_COLORNAME_SET@ /pp (*+,-VG_COLORNAME_LENGTH l/pp (*+,-VG_COLORCOLOR_NAMEx'pp "#$%VG_COLORRED ^)pp "$%&'VG_COLORGREEN uv)pp "$%&'VG_COLORBLUE v"x #Empno@Z"x lEnamet xJob xMgr%x#8` Hiredatekl xxSal!xComm#x!erDeptno0x.Word output example.x,0Using New version!xnsDept88  `88( p88ge 88  88ns Serif 88 881@ 8808z 088box, @888 P88 88 graic 88 88 88" 88 finispt 88 88 c P88 generate_to_web c! c!" c!"S c!T# graphic drawnFG123vOP$%4567 intro mlabel(OP12,h-A  MS Sans Serif567 finishopts radiog rwetc_rgeh rwetc_rgea9L:FG,h-d  MS Sans Serif generate_to_web checkbox  MS Sans Serif(sage  MS Sans Serifr pekuorep@00@@@@@@000000ppp 00880@@11AA AAAA11A"A&1*1+A.A2A6A:A>AB1F1GHIJKLMdpēLPB `` jjLPB ``LPB ``  !"h#$SRW2_BODY_LOCATION $h h!"pfSRW2_BOILERPLATEhhSRW2_BUTTON!hhSRW2_COLUMN#hh !SRW2_DATA_MODEL $h h!"SRW2_DISPLAY_TAG%h !h"#8rSRW2_DISTRIBUTION'0 hh0SRW2_ELEMENThhSRW2_FIELD)h$%h&'SRW2_FORMAT_EXCEPTION&hh SRW2_FRAME hh SRW2_GROUP#hh !SRW2_GROUP_NODE#"hh SRW2_HYPERLINK"$h h!"SRW2_JAVA_APPLET$(h#$h%&SRW2_JAVA_PROPERTIES%hhhSRW2_LAYOUT p%h !h"#zSRW2_LAYOUT_GROUP hhhSRW2_LINKhhRSRW2_LISTS `hhjSRW2_MATRIXr'h"#h$%SRW2_OGD_COLUMN_MAP$h h!"SRW2_OG_DOCUMENT#hh !0hSRW2_PARAM_FORMrhhSRW2_QUERYh%h !h"#SRW2_TEXT_SEGMENT^0^hhlTOOL_ACCESSr hh|TOOL_COMMENT hhTOOL_LIBRARY hhp^TOOL_MODULEhhhprTOOL_PLSQLx$pp"0VG_COLORVG_COLOR+pp $&'()VG_COLORITEMIDS@^+pp $&'()VG_COLORCELLIDS@v-pp &()*+VG_COLORNAME_SET@ /pp (*+,-VG_COLORNAME_LENGTH l/pp (*+,-VG_COLORCOLOR_NAMEx'pp "#$%VG_COLORRED ^)pp "$%&'VG_COLORGREEN uv)pp "$%&'VG_COLORBLUE v"x #Empno@Z"x lEnamet xJob xMgr%x#8` Hiredatekl xxSal!xComm#x!erDeptno0x.Word output example.x,0Using New version!xnsDept88  `88( p88ge 88  88ns Serif 88 881@ 8808z 088box, @888 P88 88 graic 88 88 88" 88 finispt 88 88 c P88 generate_to_web c! c!" c!"S c!T# graphic drawnFG123vOP$%4567 intro mlabel(OP12,h-A  MS Sans Serif567 finishopts radiog rwetc_rgeh rwetc_rgea9L:FG,h-d  MS Sans Serif generate_to_web checkbox  MS Sans Serif(sage  MS Sans Serifdr]0808[EE Oracle HTML Navigator
$%&'VG_COLORGREEN uv)pp "$%&'VG_COLORBLUE v"x #Empno@Z"x lEnamet xJob xMgr%x#8` Hiredatekl xxSal!xComm#x!erDeptno0x.Word output example.x,0Using New version!xnsDept88  `88( p88ge 88  88ns Serif 88 881@ 8808z 088box, @888 P88 88 graic 88 88 88" 88 finispt 88 88 c P88 generate_to_web c! c!" c!"S c!T# graphic drawnFG123vOP$%4567 intro mlabel(OP12,h-A  MS Sans Serif567 finishopts radiog rwetc_rgeh rwetc_rgea9L:FG,h-d  MS Sans Serif generate_to_web checkbox  MS Sans Serif(sage  MS Sans Serifr,00x $ & (*ED r88g25b88@,00x $ & (*EAE r100g25b88@*00x# $ &(inF r0g25b100@to,00x $ & (* &G r25g25b100@@,00x $ & (*fiH r50g25b100@,00x $ & (*ilI r75g25b100@,00x $ & (* tJ r88g25b100@.00x & ( *,geK r100g25b100@e $00x  !"[0Lred(00x "$%&paMdarkred$00x "/ Nblue(00x"# $&t Odarkblue(00x " $& jPgray64\(\(\((00x " $& Qgray60ffffff(00x " $&rwRgray56ppp(00x " $& *Sgray52zzz'00x! "$%ndTr0g50b0e)00x " $&'/*Ur25g50b0@ */)00x " $&'f(Vr50g50b0 { )00x " $&'geWr75g50b0); )00x " $&'/ Xr88g50b0m) +00x $ &()geY r100g50b0=*00x" $ &(m,Zr0g50b50 ,00x $ & (*d [ r25g50b50@,00x $ & (*ni\ r50g50b50,00x $ & (*fo] r75g50b50,00x $ & (*ue^ r88g50b50,00x $ & (*ge_ r100g50b50*00x" $ &(ag`r0g50b750);,00x $ & (*Y>a r25g50b75@,00x $ & (*; b r50g50b75,00x $ & (*T c r75g50b75,00x $ & (*.fd r88g50b75,00x $ & (*one r100g50b75*00x" $ &(tofr0g50b885on,00x $ & (*> g r25g50b88@,00x $ & (*tdh r50g50b88,00x $ & (*ori r75g50b88,00x $ & (*ALj r88g50b88,00x $ & (*cek r100g50b88*00x# $ &(GRl r0g50b100,00x $ & (*BLm r25g50b100@,00x $ & (*pnn r50g50b100,00x $ & (*o r75g50b100,00x $ & (*p r88g50b100.00x & ( *,q r100g50b100'00x "$%lryellow+00x $ &()s darkyellowr*00x "$ &(tmagenta.00x &( *,u darkmagenta(00x " $&vgray48(00x " $& wgray44\\\(00x " $&xgray40(00x " $&8ygray36ףף'00x! "$%zr0g75b0)00x " $&'0{r25g75b0@,)00x " $&'P|r50g75b0)00x " $&'}r75g75b0)00x " $&'~r88g75b0+00x $ &() r100g75b0.08x& ( *,P00r0g75b50008x ( * ,. 00r25g75b50@008x ( * ,. 00r50g75b50008x ( * ,. 00r75g75b50008x ( * ,. 00r88g75b50008x ( * ,.# 00r100g75b50.08x& ( *,100r0g75b750O008x ( * ,. 00r25g75b75@008x ( * ,.in 00r50g75b75008x ( * ,. 00r75g75b75008x ( * ,. 00r88g75b75008x ( * ,. 00r100g75b75.08x& ( *,g00r0g75b885 008x ( * ,. 00r25g75b88@008x ( * ,.- 00r50g75b88008x ( * ,. 00r75g75b88008x ( * ,.bo 00r88g75b88008x ( * ,. 00r100g75b88.08x' ( *, 00r0g75b100 S008x ( * ,. 00r25g75b100@008x ( * ,. 00r50g75b100008x ( * ,. 00r75g75b100008x ( * ,. 00r88g75b100pr208x * , .0E 00r100g75b100.08x & ( *,0000custom10.08x & ( *,1000custom2.08x & ( *,@00custom3 $.08x & ( *,00custom4 (,08x $ & (*00gray32,08x $ & (*00gray28QQQ,08x $ & (*e 00gray24,08x $ & (*00gray20+08x% &()000r0g88b0-08x & (*+"00r25g88b0@-08x & (*+ j00r50g88b0(-08x & (*+ay00r75g88b0-08x & (*+p00r88g88b0" $/08x ( *,- 00r100g88b0.08x& ( *,00r0g88b50b0008x ( * ,. " 00r25g88b50@008x ( * ,.& 00r50g88b50008x ( * ,./  00r75g88b50008x ( * ,.  00r88g88b50008x ( * ,.g5 00r100g88b50.08x& ( *,b500r0g88b750008x ( * ,. 00r25g88b75@008x ( * ,. 00r50g88b75008x ( * ,. 00r75g88b75008x ( * ,. 00r88g88b75008x ( * ,.0 00r100g88b75.08x& ( *,00r0g88b885b7008x ( * ,. $ 00r25g88b88@008x ( * ,. ( 00r50g88b88008x ( * ,.on 00r75g88b88008x ( * ,. 00r88g88b88008x ( * ,.5g 00r100g88b88.08x' ( *,b8 00r0g88b100008x ( * ,. 00r25g88b100@008x ( * ,. 00r50g88b100008x ( * ,. 00r75g88b100008x ( * ,. 00r88g88b100208x * , .00 00r100g88b100b1.08x & ( *, $00custom5.08x & ( *, (00custom6.08x & ( *,00custom7.08x & ( *,l00custom8,08x $ & (*rk00gray16 ,08x $ & (*ge00gray12GGG,08x $ & (*rk00gray8,08x $ & (*00gray4-08x& (*+ay00r0g100b0/08x ( *,- 00r25g100b0@$/08x ( *,- 00r50g100b0/08x ( *,- 00r75g100b00/08x ( *,- " 00r88g100b0/08x ( *,-& 00r100g100b0.08x' ( *, 00r0g100b50008x ( * ,.  00r25g100b50@008x ( * ,.00 00r50g100b50008x ( * ,.00 00r75g100b50008x ( * ,.00 00r88g100b50208x * , .000 00r100g100b508.08x' ( *,8g 00r0g100b758008x ( * ,.00 00r25g100b75@008x ( * ,.g7 00r50g100b75008x ( * ,.5g 00r75g100b75008x ( * ,.0g 00r88g100b75208x * , .05g 00r100g100b75.08x' ( *,b7 00r0g100b88008x ( * ,.5b 00r25g100b88@008x ( * ,.88 00r50g100b88008x ( * ,.b8 00r75g100b88008x ( * ,.b8 00r88g100b88208x * , .0b8 00r100g100b88 (008x( * ,. 00r0g100b100208x * , .0 00r25g100b100@ *208x * , .0 S 00r50g100b100208x * , .0 00r75g100b100208x * , .0 00r88g100b10000r75g75b100008x ( * ,. 00r88g75b100r208x * , .0E 00r100g100b100]>p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ[]>p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ[ m4h>p?p?p?0KLMNOPQRSTUV XZ[\]^_`abcdefCourier New  h>p?p?p?0KLMNOPQRSTUV XZ[\]^_`abcdefCourier New ]>p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ[ouq ]>p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ[ouq 8h>p?p?p?0KLMNOPQRSTUV XZ[\]^_`abcdefCourier New  j>p?p?p?0MNOPQRSTUVWX Z\]^_`abcdefghMS Sans Serif ,j>p?p?p?0MNOPQRSTUVWX Z\]^_`abcdefghMS Sans Serifj>p?p?p?0MNOPQRSTUVWX Z\]^_`abcdefghMS Sans Serif g8j>p?p?p?0MNOPQRSTUVWX Z\]^_`abcdefghMS Sans Serifq 1p"&'*./beforepform -p"#&*+afterpform 1p"&'*./afterreport@ pp%p/5670809:;<=>kEMPNOemp.EMPNOEMPNOg@ pp%p/5670809:;<=>nENAMEemp.ENAMEENAME g: pp#p+/01020345678qJOBemp.JOBJOB g: pp#p+/01020345678tMGRemp.MGRMGRgI pp(p5>?@0A0BCDEFGwHIREDATEemp.HIREDATEHIREDATE g 00: pp#p+/01020345678zSALemp.SALSALg@= pp$p-2340506789:;}COMMemp.COMMCOMMg8C pp&p189:0;0<=>?@ADEPTNOemp.DEPTNODEPTNOg 00r88g88b100208x * , .00 00r100g88b100b1.08x & ( *, $00custom5.08x & ( *, (00custom6.08x & ( *,00custom7.08x & ( *,l00custom8,08x $ & (*rk00gray16 ,08x $ & (*ge00gray12GGG,08x $ & (*rk00gray8,08x $ & (*00gray4-08x& (*+ay00r0g100b0/08x ( *,- 00r25g100b0@$/08x ( *,- 00r50g100b0/08x ( *,- 00r75g100b00/08x ( *,- " 00r88g100b0/08x ( *,-& 00r100g100b0.08x' ( *, 00r0g100b50008x ( * ,.  00r25g100b50@008x ( * ,.00 00r50g100b50008x ( * ,.00 00r75g100b50008x ( * ,.00 00r88g100b50208x * , .000 00r100g100b508.08x' ( *,8g 00r0g100b758008x ( * ,.00 00r25g100b75@008x ( * ,.g7 00r50g100b75008x ( * ,.5g 00r75g100b75008x ( * ,.0g 00r88g100b75208x * , .05g 00r100g100b75.08x' ( *,b7 00r0g100b88008x ( * ,.5b 00r25g100b88@008x ( * ,.88 00r50g100b88008x ( * ,.b8 00r75g100b88008x ( * ,.b8 00r88g100b88208x * , .0b8 00r100g100b88 (008x( * ,. 00r0g100b100208x * , .0 00r25g100b100@ *208x * , .0 S 00r50g100b100208x * , .0 00r75g100b100208x * , .0 00r88g100b10000r75g75b100008x ( * ,. 00r88g75b100Xr/bpchijklmpnnpopoopqrs0t0u0v0w0x0ypzppppppiDEPT  Deptselect deptno from deptdeptnoDEPTK/bpcijklmnprrpspsstuvw0x0y0z0{0|0}p~  ppppppjEMPNOhkEmpno`'o frEMPNO/bpcijklmnprrpspsstuvw0x0y0z0{0|0}p~( ppppppmENAMEhn Ename`'ENAME/bpcghijklprrpspsstuvw0x0y0z0{0|0}p~( pppppppJOBhq Job_'JOBP/bpcghijklprrpspsstuvw0x0y0z0{0|0}p~  ppppppsMGRhtMgr`'MGR/bpclmnopqprrpspsstuvw0x0y0z0{0|0}p~( ppppppvHIREDATEhw Hiredate'_ 'BHIREDATEX/bpcghijklprrpspsstuvw0x0y0z0{0|0}p~( ppppppySALhzhwSal_'SAL/bpchijklmpnnpopoopqrs0t0u0v0w0x0ypz( pppppp|COMMh}Commal_'COMM/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~  ppppppDEPTNOhDeptno@'DEPTNO102/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~~ppppppP_PASS 'P_PASSEH/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~~ppppppP_ROLE 'P_ROLEpp&p189:0;0<=>?@ADEPTNOemp.DEPTNODEPTNOg 00r88g88b100208x * , .00 00r100g88b100b1.08x & ( *, $00custom5.08x & ( *, (00custom6.08x & ( *,00custom7.08x & ( *,l00custom8,08x $ & (*rk00gray16 ,08x $ & (*ge00gray12GGG,08x $ & (*rk00gray8,08x $ & (*00gray4-08x& (*+ay00r0g100b0/08x ( *,- 00r25g100b0@$/08x ( *,- 00r50g100b0/08x ( *,- 00r75g100b00/08x ( *,- " 00r88g100b0/08x ( *,-& 00r100g100b0.08x' ( *, 00r0g100b50008x ( * ,.  00r25g100b50@008x ( * ,.00 00r50g100b50008x ( * ,.00 00r75g100b50008x ( * ,.00 00r88g100b50208x * , .000 00r100g100b508.08x' ( *,8g 00r0g100b758008x ( * ,.00 00r25g100b75@008x ( * ,.g7 00r50g100b75008x ( * ,.5g 00r75g100b75008x ( * ,.0g 00r88g100b75208x * , .05g 00r100g100b75.08x' ( *,b7 00r0g100b88008x ( * ,.5b 00r25g100b88@008x ( * ,.88 00r50g100b88008x ( * ,.b8 00r75g100b88008x ( * ,.b8 00r88g100b88208x * , .0b8 00r100g100b88 (008x( * ,. 00r0g100b100208x * , .0 00r25g100b100@ *208x * , .0 S 00r50g100b100208x * , .0 00r75g100b100208x * , .0 00r88g100b10000r75g75b100008x ( * ,. 00r88g75b100r~#JpKTU(VpZpZ@Z8^8`8bdefghijkl0m0n0opppr0rstuvwxyz{|F_DEPTNO0pt~#JpKST(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|PF_DEPT00@uippppppjEMPNOhkEmpno`'o frEMPNO/bpcijklmnprrpspsstuvw0x0y0z0{0|0}p~( ppppppmENAMEhn Ename`'ENAME/bpcghijklprrpspsstuvw0x0y0z0{0|0}p~( pppppppJOBhq Job_'JOBP/bpcghijklprrpspsstuvw0x0y0z0{0|0}p~  ppppppsMGRhtMgr`'MGR/bpclmnopqprrpspsstuvw0x0y0z0{0|0}p~( ppppppvHIREDATEhw Hiredate'_ 'BHIREDATEX/bpcghijklprrpspsstuvw0x0y0z0{0|0}p~( ppppppySALhzhwSal_'SAL/bpchijklmpnnpopoopqrs0t0u0v0w0x0ypz( pppppp|COMMh}Commal_'COMM/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~  ppppppDEPTNOhDeptno@'DEPTNO102/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~~ppppppP_PASS 'P_PASSEH/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~~ppppppP_ROLE 'P_ROLEpp&p189:0;0<=>?@ADEPTNOemp.DEPTNODEPTNOg 00r88g88b100208x * , .00 00r100g88b100b1.08x & ( *, $00custom5.08x & ( *, (00custom6.08x & ( *,00custom7.08x & ( *,l00custom8,08x $ & (*rk00gray16 ,08x $ & (*ge00gray12GGG,08x $ & (*rk00gray8,08x $ & (*00gray4-08x& (*+ay00r0g100b0/08x ( *,- 00r25g100b0@$/08x ( *,- 00r50g100b0/08x ( *,- 00r75g100b00/08x ( *,- " 00r88g100b0/08x ( *,-& 00r100g100b0.08x' ( *, 00r0g100b50008x ( * ,.  00r25g100b50@008x ( * ,.00 00r50g100b50008x ( * ,.00 00r75g100b50008x ( * ,.00 00r88g100b50208x * , .000 00r100g100b508.08x' ( *,8g 00r0g100b758008x ( * ,.00 00r25g100b75@008x ( * ,.g7 00r50g100b75008x ( * ,.5g 00r75g100b75008x ( * ,.0g 00r88g100b75208x * , .05g 00r100g100b75.08x' ( *,b7 00r0g100b88008x ( * ,.5b 00r25g100b88@008x ( * ,.88 00r50g100b88008x ( * ,.b8 00r75g100b88008x ( * ,.b8 00r88g100b88208x * , .0b8 00r100g100b88 (008x( * ,. 00r0g100b100208x * , .0 00r25g100b100@ *208x * , .0 S 00r50g100b100208x * , .0 00r75g100b100208x * , .0 00r88g100b10000r75g75b100008x ( * ,. 00r88g75b100l1  $ 0 BEFOREPFORMfunction BeforePForm return boolean is vc_parameter_form varchar2(4000); vc_hidden_runtime_values varchar2(1000); vc_report_name varchar2(50); hold_cmd VARCHAR2(240); /* **** This section must be commented out in 6.x, uncomment when upgrading to 7.1 obj ORA_JAVA.JOBJECT; x VARCHAR2(100); exc ORA_JAVA.JOBJECT; -- Exceptions. -- NO_OBJECT EXCEPTION; NO_INST EXCEPTION; NO_ACCESS EXCEPTION; NO_PASSWORD EXCEPTION; INVALID_VERSION EXCEPTION; INVALID_ACCESS EXCEPTION; NAME_MISMATCH EXCEPTION; -- -- Exception pragmas. -- PRAGMA EXCEPTION_INIT(NO_OBJECT,-20100); PRAGMA EXCEPTION_INIT(NO_INST,-20101); PRAGMA EXCEPTION_INIT(NO_ACCESS,-20102); PRAGMA EXCEPTION_INIT(NO_PASSWORD,-20103); PRAGMA EXCEPTION_INIT(INVALID_VERSION,-20104); PRAGMA EXCEPTION_INIT(INVALID_ACCESS,-20105); PRAGMA EXCEPTION_INIT(NAME_MISMATCH,-20106); */ begin srw.get_report_name(vc_report_name); -- -- Start Security Check -- Version checking not turned on at EKU so -- -- version number not relevant but a number must be passed -- -- In the 6x version of ekuorep, this is a dummy routine that does nothing -- -- In 7.1, this is SCT's routine that actually sets the security G$_REPORT_SECURITY.G$_REPORT_VERIFY_ACCESS( upper(vc_report_name), '7.1' ) ; vc_parameter_form := GWZ$_SET_HTML (upper(vc_report_name), -- Report name 3, -- Generate Word HTML 'RTF', -- Output Format (not really needed) NULL, -- ASCII Delimiter (optional) NULL, -- Field name for java scripts (types 5-8) NULL, -- Verbage to select PDF output (types 5-8) NULL, -- Verbage to select Excel output (types 5-8) NULL, -- Verbage to select Word output (types 5-8) :p_role, -- Banner role passed to report :P_pass, -- Banner role password passed to report :P_user_connect, -- Connect string passed to report NULL,NULL,NULL); -- Reserved for future expansion srw.set_before_form_html (srw.text_escape, vc_parameter_form); return (TRUE); -- exception /* uncomment these exceptions when compiling in 7.1 WHEN NO_OBJECT THEN SRW.MESSAGE(1000,'*ERROR* No parameters were passed - report terminated.'); return (FALSE); WHEN NO_INST THEN SRW.MESSAGE(1000,'*ERROR* No records found on GUBIPRF - report terminated.'); return (FALSE); WHEN NO_ACCESS THEN SRW.MESSAGE(1000,'*ERROR* User not authorized to access ' || vc_report_name || ' - report terminated.'); return (FALSE); WHEN NO_PASSWORD THEN SRW.MESSAGE(1000,'*ERROR* No password found on GUBROLE - report terminated.'); return (FALSE); WHEN INVALID_VERSION THEN SRW.MESSAGE(1000,'*ERROR* Invalid version of ' || vc_report_name || ' - report terminated.'); return (FALSE); WHEN INVALID_ACCESS THEN SRW.MESSAGE(1000,'*ERROR* Invalid password tried - report terminated.'); return (FALSE); WHEN ORA_JAVA.EXCEPTION_THROWN THEN SRW.MESSAGE(1000, '*ERROR* Report Server Configuration - report terminated.'); ORA_JAVA.CLEAR_EXCEPTION; return (FALSE); */ WHEN OTHERS THEN SRW.MESSAGE(1000,'ERROR: ' || SUBSTR(SQLERRM,1,190)); --SRW.MESSAGE(1000, '*ERROR* Before Parm trigger could not set database role - reporlt terminated.'); return (FALSE); end; @@Pf6lClick or drag a rectangle to create a Ref Cursor Query w)'lig lExpress Querynd OM fh3lClick or drag a rectangle to create a Express Queryh20ilTable of Records QueryXVj< ot"lDrag a rectangle to create a field!owulChart>< tv"lDrag a rectangle to create a chart!WewlFrame><x"lDrag a rectangle to create a framett(&nuy lFrame SelectQOizz5lClick inside of a frame to select it and its childrentm+)iz{lRepeating FrameeHFdi|,lDrag a rectangle to create a repeating frame%#on} lLink Filewsdbma~HlDrag a rectangle to create a boilerplate object that is linked to a file'%rd lOLE2 ObjectcECso)lDrag a rectangle to create an OLE2 objecthom*(tlSearch Forwardit*(eelucolsfecUSls9lFind the next object in the Navigator matching the stringringcnticonfileautoskipcanreordercontentwdcontenthtenablednitemsidhiddentearoffhelpsubmenuacceleratorstandardkeykeyvalmodifierscsstatestartgroupiconcantitlevtatypehtatypestatustypestatusclassstatushtaclasshtavtaclassvtamenuiconsizeshowlabelscanvasmovablewdhtviewclasscasefoldsplitmodestringpageresourcecurrentcanapplyeventprocnameeventargnamefgcolorcompressbuttonspropertiesdataismappedmaprequestisdragsourcenumrowscellsvalueishorizselectedenableeanblesrctltgttl 0800~0@0800 P0800` 0800p$0800"%  0800cecrwlfsstring{yrwdqestringig;rwbf_parameterFonts;9FieldsboxDatabox TypeboxSectionsboxTemplatesboxFinishedQueryboxrwwt_Expresswizardvgmisq_helpstringrwbwvpulmenurwlfs_helpstring|zrwlbstringqorwdqe_helpstringjhrwbwolwindowKIrwbwdowindow,*!rwbwfewindow*(Yrwbwetwindow)'rwbwtpwindow%#lrwbhrewindow#!rwbwtrwindow" rwbwfi1windowrwbwcmwindowrwbwdiwindow#rwbwmrwindowrwbwrgwindowrwbwcnwindow  rwbwsrwindow  rwbwgiwindow  HyperlinksWWboxMatrixCellbox rwbwmfwindow vgmitx_helpstringvgmirt_helpstringvgmigr_helpstringrwlo lfunction BeforePForm return boolean is vc_parameter_form varchar2(4000); vc_hidden_runtime_values varchar2(1000); vc_report_name varchar2(50); hold_cmd VARCHAR2(240); /* **** This section must be commented out in 6.x, uncomment when upgrading to 7.1 obj ORA_JAVA.JOBJECT; x VARCHAR2(100); exc ORA_JAVA.JOBJECT; -- Exceptions. -- NO_OBJECT EXCEPTION; NO_INST EXCEPTION; NO_ACCESS EXCEPTION; NO_PASSWORD EXCEPTION; INVALID_VERSION EXCEPTION; INVALID_ACCESS EXCEPTION; NAME_MISMATCH EXCEPTION; -- -- Exception pragmas. -- PRAGMA EXCEPTION_INIT(NO_OBJECT,-20100); PRAGMA EXCEPTION_INIT(NO_INST,-20101); PRAGMA EXCEPTION_INIT(NO_ACCESS,-20102); PRAGMA EXCEPTION_INIT(NO_PASSWORD,-20103); PRAGMA EXCEPTION_INIT(INVALID_VERSION,-20104); PRAGMA EXCEPTION_INIT(INVALID_ACCESS,-20105); PRAGMA EXCEPTION_INIT(NAME_MISMATCH,-20106); */ begin srw.get_report_name(vc_report_name); -- -- Start Security Check -- Version checking not turned on at EKU so -- -- version number not relevant but a number must be passed -- -- In the 6x version of ekuorep, this is a dummy routine that does nothing -- -- In 7.1, this is SCT's routine that actually sets the security G$_REPORT_SECURITY.G$_REPORT_VERIFY_ACCESS( upper(vc_report_name), '7.1' ) ; vc_parameter_form := GWZ$_SET_HTML (upper(vc_report_name), -- Report name 3, -- Generate Word HTML 'RTF', -- Output Format (not really needed) NULL, -- ASCII Delimiter (optional) NULL, -- Field name for java scripts (types 5-8) NULL, -- Verbage to select PDF output (types 5-8) NULL, -- Verbage to select Excel output (types 5-8) NULL, -- Verbage to select Word output (types 5-8) :p_role, -- Banner role passed to report :P_pass, -- Banner role password passed to report :P_user_connect, -- Connect string passed to report NULL,NULL,NULL); -- Reserved for future expansion srw.set_before_form_html (srw.text_escape, vc_parameter_form); return (TRUE); -- exception /* uncomment these exceptions when compiling in 7.1 WHEN NO_OBJECT THEN SRW.MESSAGE(1000,'*ERROR* No parameters were passed - report terminated.'); return (FALSE); WHEN NO_INST THEN SRW.MESSAGE(1000,'*ERROR* No records found on GUBIPRF - report terminated.'); return (FALSE); WHEN NO_ACCESS THEN SRW.MESSAGE(1000,'*ERROR* User not authorized to access ' || vc_report_name || ' - report terminated.'); return (FALSE); WHEN NO_PASSWORD THEN SRW.MESSAGE(1000,'*ERROR* No password found on GUBROLE - report terminated.'); return (FALSE); WHEN INVALID_VERSION THEN SRW.MESSAGE(1000,'*ERROR* Invalid version of ' || vc_report_name || ' - report terminated.'); return (FALSE); WHEN INVALID_ACCESS THEN SRW.MESSAGE(1000,'*ERROR* Invalid password tried - report terminated.'); return (FALSE); WHEN ORA_JAVA.EXCEPTION_THROWN THEN SRW.MESSAGE(1000, '*ERROR* Report Server Configuration - report terminated.'); ORA_JAVA.CLEAR_EXCEPTION; return (FALSE); */ WHEN OTHERS THEN SRW.MESSAGE(1000,'ERROR: ' || SUBSTR(SQLERRM,1,190)); --SRW.MESSAGE(1000, '*ERROR* Before Parm trigger could not set database role - report terminated.'); return (FALSE); end; o0r 080000800 u0808s]]1 $ ] AFTERPFORMDfunction AfterPForm return boolean is begin return (TRUE); end;Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"AFTERPFORM""n$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08J *"FUNCTION"AFTERPFORM"RETURN"BOOLEAN"TRUE""( #$(357;>BDHh,eZO      dͫͫͫͫͫͫͫ0D   % hg!ll\D0 AFTERPFORM X@@X0000VDDfunction AfterPForm return boolean is begin return (TRUE); end;]0808[EE1 $ E AFTERREPORTfunction AfterReport return boolean is begin G$_REPORT_SECURITY.G$_REPORT_REVOKE_ACCESS; return (TRUE); exception when others then return (FALSE); end;akͫͫͫͫͫͫͫw SYSSTANDARD /LekuorepG$_REPORT_SECURITY $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"AFTERREPORT""n>$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 o $ c"FUNCTION"AFTERREPORT"RETURN"BOOLEAN"G$_REPORT_SECURITY"G$_REPORT_REVOKE_ACCESS"TRUE"OTHERS"FALSE"" #$(357<?CGHLOSW\]_cfjlnh,WkeZ SeZO          dͫͫͫͫͫͫͫ0D ??  &'$%$%kkhg!`D0 AFTERREPORT  &2 %&X\@@00b0808function AfterReport return boolean is begin G$_REPORT_SECURITY.G$_REPORT_REVOKE_ACCESS; return (TRUE); exception when others then return (FALSE); end;.:00008&&select * from emp where deptno = :dept*>FNW(Z^bg(nrw(~(((SQL*ReportWriterKgREPORTEKUpgxjwordt/tEKUxg  EKUxi vx * , .0 00r75g100b100208x * , .0 00r88g100b10000r75g75b100008x ( * ,. 00r88g75b100@trF&p'+,2p6p6p66788:8<8>8@BCDgQ_1EUff FpGOPQRST0UVW0XYZ0[\]^_xb8b8d8f8hjkplplpttpupfthG_EMPNOg=*%&4G_EMPNOLIST_G_EMPNO/bpclmnopqprrpspwwxyz{0|0}0~000pppppppYPRINTJOB YesPShow Print Job Dialog/bpchijklmpnnpopwwxyz{0|0}0~000pppppppZMODE DefaultPOutput Mode/bpcnopqrspvvpwpzz{|}~000000ppppppp[BACKGROUND tNoPRun in Background/bpcopqrstpzzp{p000000ppppppp\ORIENTATION NoDefaultPOrientation/bpcklmnoppvvpwpwwxyz{0|0}0~000ppppppp]DECIMALDecimal Indicator/bpcmnopqrpvvpwpwwxyz{0|0}0~000ppppppp^THOUSANDSThousands Indicator/bpclmnopqprrpspsstu vx0y0z0{0|0}0~ppppppp_CURRENCYCurrency Symbol/bpcjklmnoprrpspuuvwxy0z0{0|0}0~0ppppppp`COPIES1Number of Copies/bpcmnopqrpvvpwp||}~ 000000pppppppaDESFORMATdfltDestination Formatk/bpcklmnoppvvpwpwwxy z|0}0~0000pppppppbDESNAMEDestination Name /bpcklmnoppvvpwp~~000000pppppppcDESTYPEScreenPDestination Type>$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 o $ c"FUNCTION"AFTERREPORT"RETURN"BOOLEAN"G$_REPORT_SECURITY"G$_REPORT_REVOKE_ACCESS"TRUE"OTHERS"FALSE"" #$(357<?CGHLOSW\]_cfjlnh,WkeZ SeZO          dͫͫͫͫͫͫͫ0D ??  &'$%$%kkhg!`D0 AFTERREPORT  &2 %&X\@@00b0808function AfterReport return boolean is begin G$_REPORT_SECURITY.G$_REPORT_REVOKE_ACCESS; return (TRUE); exception when others then return (FALSE); end;.:00008&&select * from emp where deptno = :dept*>FNW(Z^bg(nrw(~(((SQL*ReportWriterKgREPORTEKUpgxjwordt/tEKUxg  EKUxi vx * , .0 00r75g100b100208x * , .0 00r88g100b10000r75g75b100008x ( * ,. 00r88g75b100P0r/bpcrstuvwpzzp{p{{|}~000000pppppppP_USER_CONNECT2 P_ROP_USER_CONNECT/bpclmnopqprrpspsstuvw0x0y0z0{0|0}p~~ppppppP_ACTIONd P_ACTION/bpcpqrstupvvpwpwwxyz{0|0}0~000pppppppP_SERVERNAME2 P_SERVERNAME6*Zp[cd(jpnpn0n0o8p8rtuvxz000000p00B_EMPNOͫ0OhR*Zp[cd(jpnpn8n0p8r8tvwxx~000000p0`B_ENAMEͫ0D*Zp[ab(fpjpj8j0l8n8prstxz000000p0_DB_JOB0606*Zp[ab(fpjpj8j0l8n8prstxz000000p0B_MGR 0T0T*Zp[fg(jpnpn8n0p8r8tvwxx~000000p0B_HIREDATE 00jTjk*Zp[ab(fpjpj@j0n8p8rtuvxz000000p0SB_SALTE0j|*Zp[bc(fpjpj@j0n8p8rtuvxz000000p0flB_COMME0jxy z|0}0~0000pppppppbDESNAMEDestination Name /bpcklmnoppvvpwp~~000000pppppppcDESTYPEScreenPDestination Type>$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 o $ c"FUNCTION"AFTERREPORT"RETURN"BOOLEAN"G$_REPORT_SECURITY"G$_REPORT_REVOKE_ACCESS"TRUE"OTHERS"FALSE"" #$(357<?CGHLOSW\]_cfjlnh,WkeZ SeZO          dͫͫͫͫͫͫͫ0D ??  &'$%$%kkhg!`D0 AFTERREPORT  &2 %&X\@@00b0808function AfterReport return boolean is begin G$_REPORT_SECURITY.G$_REPORT_REVOKE_ACCESS; return (TRUE); exception when others then return (FALSE); end;.:00008&&select * from emp where deptno = :dept*>FNW(Z^bg(nrw(~(((SQL*ReportWriterKgREPORTEKUpgxjwordt/tEKUxg  EKUxi vx * , .0 00r75g100b100208x * , .0 00r88g100b10000r75g75b100008x ( * ,. 00r88g75b100`r*Zp[de(fpjpj@j0n8p8rtuvxz000000p0crB_DEPTNO0jS*Zp[`a(bpfpf8f8h8j8lnopxv000000p0esPB_1&rF98&rF98*Zp[`a(bpfpf8f8h8j8lnopxv000000p0PB_2ISISY*Zp[cd(jpnpn8n8p8r8tvwxx~~000000p0 $PB_DEPTq SIS   )   S      C      (   O      %      %~BpCST(Zp^p^0^0_@b8fhijk0l0m0n0o0p0qr0s0tuvwxyz{|M_G_EMPNO_GRPFRp0 hvBpCQR TpVpV0V0W@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstM_G_EMPNO_HDRph(vBpCMN(RpVpV0V8X@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstR_G_EMPNOR0h~#JpKST(Zp^p^0^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_EMPNO00j~#JpKST(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_ENAME00mz#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_JOB006pz#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_MGR 00Tspo~#JpKVW(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_HIREDATE 00jv~#JpKQR(VpZpZ@Z8^8`8bdefghijkl0m0n0opppr0rstuvwxyz{|F_SAL TE0y8~#JpKRS(VpZpZ@Z8^8`8bdefghijkl0m0n0opppr0rstuvwxyz{|F_COMME0| 08 SerifT 08,W @08#X `08([ 00sagen 88 088Sans Ser P88  `88( p88ge 88  88ns Serif 88 881@ 8808z 088box, @888 P88 88 graic 88 88 88" 88 finispt 88 88 c P88 generate_to_web c! c!" c!"S c!T# graphic drawnFG123vOP$%4567 intro mlabel(OP12,h-A  MS Sans Serif567 finishopts radiog rwetc_rgeh rwetc_rgea9L:FG,h-d  MS Sans Serif generate_to_web checkbox  MS Sans Serif(sage  MS Sans Serif