ROS.60050(Pr    !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~8000800080008000800080008000800080008000800080008000 8000!8000"8000#8000$8000%8000&8000'8000(8000)8000*8000+8000,8000-8000.8000/800008000180002800038000480005800068000780008800098000:8000;8000<8000=8000>8000?8000@8000A8000B8000C8000D8000E8000F8000G8000H8000I8000J8000K8000L8000M8000N8000O8000P8000Q8000R8000S8000T8000U8000V8000W8000X8000Y8000Z8000[8000\8000]8000^8000_8000`8000a8000b8000c8000d8000e8000f8000g8000h8000i8000j8000k8000l8000m8000n8000o8000p8000q8000r8000s8000t8000u8000v@r08bc(fpj@j" p 0View on screen0% p#Save as text fileEp (0@/*Zp[de(fpjpj@j0n8p8rtuvxz000000p0dp(A` 88 P 88 0 88 {&00x $pf8f8h8jD r88g25b880,08x *p0 00r100g75b100,08x *V 00r100g100b100mbpchijkz*Zp[`a(bpfpf8f8h8j8lnopxvvz0~000iDEPT 00wbpcrstuPB_2IS*P_USER_CONNECTr@lZp[bc(fpj0000p0PB_DEPTq SǮB_COMME0\JpKQR(VpZ*Zp[`a(bpfpf8f8h8jF_SAL TE000000p0PB_3U-U US U-U U St*Zp[`a(bpfpf8f8h8j8lnopxv000000p06PB_4 Me S  Me Sr* Zp\ab(fpjpj8j8l8n8prstxz000000p0PB_5 V;Uj  V;Uj v            0               j   ߊ         S         ~BpCST(Zp^p^0^0_@b8fhijk0l0m0n0o0p0qr0s0tuvwxyz{|M_G_EMPNO_GRPFRp0 hvBpCQR TpVpV0V0W@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstM_G_EMPNO_HDRphvBpCMN(RpVpV0V8X@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstR_G_EMPNOR0h0~#JpKST(Zp^p^0^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_EMPNO00j~#JpKST(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_ENAME00mz#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_JOB006p0z#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_MGR 00Ts~#JpKVW(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_HIREDATE 00jvT8000U8000V8000W8000X8000Y8000Z8000[8000\8000]8000^8000_8000`8000a8000b8000c8000d8000e8000f8000g8000h8000i8000j8000k8000l8000m8000n8000o8000p8000q8000r8000s8000t8000u8000vx0r 88pj  2jk0l0m0n8p8rt v0x0yz{0|}~ppppppppr%rHrHr]r]r]r]r]rbbrcrffrjrrrsrtreC R~jxg  | 2



$GXJJXCLB(F0JK@N@R@V@Z0^0_0`0a0b0c d0f0ghi8j8l0nop rtpupp@fr]r]r@@PjjReport ParametersEnter values for the parametersE$00x !"black(00x " $&p[white%00x "#green0)00x# $&'B_ darkgreen(00x " $&gray96 = = =(00x " $&*gray92zzz(00x " $&0gray88(00x " $&6gray84(((%00x !"# r0g0b0(00x "$%&r r25g0b0@(00x "$%&0 r50g0b0(00x "$%& r75g0b0(00x "$%& V r88g0b0(00x "$%& r100g0b0(00x!" $& r0g0b50*00x "$ &( r25g0b50@ *00x "$ &(r50g0b50*00x "$ &( r75g0b50 *00x "$ &(r88g0b50,00x $& (* r100g0b50(00x!" $&r0g0b75*00x "$ &(0lr25g0b75@v*00x "$ &(FRr50g0b75*00x "$ &(r75g0b750V*00x "$ &(jr88g0b75t,00x $& (* r100g0b75(00x!" $&0Vr0g0b88*00x "$ &(rr25g0b88@*00x "$ &(r50g0b88pK*00x "$ &(jr75g0b880r*00x "$ &(NOr88g0b88,00x $& (* r100g0b88(00x"# $&0p r0g0b100,00x $& (*! r25g0b100@,00x $& (*pK" r50g0b100,00x $& (*0n# r75g0b100,00x $& (*$ r88g0b100,00x $& (*8^% r100g0b100&00x  "$v&gray0*00x " $ &('darkgraypK&00x "$j(cyanrpr*00x" $ &(_H)darkcyan(00x " $&*gray80333333(00x " $&+gray76=p=p=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%0.r0g25b0@)00x " $&'/r25g25b0@@)00x " $&'0r50g25b0@)00x " $&'01r75g25b0@)00x " $&'2r88g25b0@+00x $ &()3 r100g25b0@*00x" $ &(04r0g25b50@,00x $ & (*5 r25g25b50@@,00x $ & (*6 r50g25b50@,00x $ & (*07 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (*9 r100g25b50@*00x" $ &(0:r0g25b750@,00x $ & (*; r25g25b75@@,00x $ & (*< r50g25b75@,00x $ & (*0= r75g25b75@,00x $ & (*> r88g25b75@,00x $ & (*? r100g25b75@*00x" $ &(0@r0g25b885@,00x $ & (*A r25g25b88@@,00x $ & (*B r50g25b88@,00x $ & (*0C r75g25b88@8000v@ r.hh,pjROSATTRIBSclass attributest+hh)ROSLFDESCros lf descripH)hh'rfROSOBJMAPros name->id R+hh) ROSSTRINGStk2 uiStringsc*hh(ffROSSTRUCTSstruct types> *hh(onROSTK2RESVtk2 reservedmehh_aSRW2_ANCHOR &h!"h#$arSRW2_BODY_LOCATION al$h h!"ntSRW2_BOILERPLATEhh> SRW2_BUTTON!rhhelSRW2_COLUMN>#hh !ubSRW2_DATA_MODEL =$h h!"e=SRW2_DISPLAY_TAG%h !h"# hh=5SRW2_ELEMENThh r88g25b75@,00x $ & (*? r100g25b75@*00x" $ &(0@r0g25b885@,00x $ & (*A r25g25b88@@,00x $ & (*B r50g25b88@,00x $ & (*0C r75g25b88@8000vPr 88pj RIBSclass attributest+hh)ROSLFDESCros lf descripH)hh'rfROSOBJMAPros name->id R+hh) ROSSTRINGStk2 uiStringsc*hh(ffROSSTRUCTSstruct types> *hh(onROSTK2RESVtk2 reservedmehh_aSRW2_ANCHOR &h!"h#$arSRW2_BODY_LOCATION al$h h!"ntSRW2_BOILERPLATEhh> SRW2_BUTTON!rhhelSRW2_COLUMN>#hh !ubSRW2_DATA_MODEL =$h h!"e=SRW2_DISPLAY_TAG%h !h"# hh=5SRW2_ELEMENThh r88g25b75@,00x $ & (*? r100g25b75@*00x" $ &(0@r0g25b885@,00x $ & (*A r25g25b88@@,00x $ & (*B r50g25b88@,00x $ & (*0C r75g25b88@8000v`r 88pj RIBSclass attributest+hh)ROSLFDESCros lf descripH)hh'rfROSOBJMAPros name->id R+hh) ROSSTRINGStk2 uiStringsc*hh(ffROSSTRUCTSstruct types> *hh(onROSTK2RESVtk2 reservedmehh_aSRW2_ANCHOR &h!"h#$arSRW2_BODY_LOCATION al$h h!"ntSRW2_BOILERPLATEhh> SRW2_BUTTON!rhhelSRW2_COLUMN>#hh !ubSRW2_DATA_MODEL =$h h!"e=SRW2_DISPLAY_TAG%h !h"# hh=5SRW2_ELEMENThh r88g25b75@,00x $ & (*? r100g25b75@*00x" $ &(0@r0g25b885@,00x $ & (*A r25g25b88@@,00x $ & (*B r50g25b88@,00x $ & (*0C r75g25b88@8000vpTrO N(0@@00@@@@@@000000ppp 00880@@11AA AAAA11A"A&1*1+A.A2A6A:A>AB1F1GHIJKLM dp(ALPB `` =jjLPB ``LPB ``  !"h#$arSRW2_BODY_LOCATION al$h h!"ntSRW2_BOILERPLATEhh> SRW2_BUTTON!rhhelSRW2_COLUMN>#hh !ubSRW2_DATA_MODEL =$h h!"e=SRW2_DISPLAY_TAG%h !h"# hh=5SRW2_ELEMENThh r88g25b75@,00x $ & (*? r100g25b75@*00x" $ &(0@r0g25b885@,00x $ & (*A r25g25b88@@,00x $ & (*B r50g25b88@,00x $ & (*0C r75g25b88@8000v,r% p#@Save as text file0000ppp 00880@@11AA AAAA11A"A&1*1+A.A2A6A:A>AB1F1GHIJKLM dp(ALPB `` =jjLPB ``LPB ``  !"h#$arSRW2_BODY_LOCATION al$h h!"ntSRW2_BOILERPLATEhh> SRW2_BUTTON!rhhelSRW2_COLUMN>#hh !ubSRW2_DATA_MODEL =$h h!"e=SRW2_DISPLAY_TAG%h !h"# hh=5SRW2_ELEMENThh r88g25b75@,00x $ & (*? r100g25b75@*00x" $ &(0@r0g25b885@,00x $ & (*A r25g25b88@@,00x $ & (*B r50g25b88@,00x $ & (*0C r75g25b88@8000v(r" p @View on screenle0000ppp 00880@@11AA AAAA11A"A&1*1+A.A2A6A:A>AB1F1GHIJKLM dp(ALPB `` =jjLPB ``LPB ``  !"h#$arSRW2_BODY_LOCATION al$h h!"ntSRW2_BOILERPLATEhh> SRW2_BUTTON!rhhelSRW2_COLUMN>#hh !ubSRW2_DATA_MODEL =$h h!"e=SRW2_DISPLAY_TAG%h !h"# hh=5SRW2_ELEMENThh r88g25b75@,00x $ & (*? r100g25b75@*00x" $ &(0@r0g25b885@,00x $ & (*A r25g25b88@@,00x $ & (*B r50g25b88@,00x $ & (*0C r75g25b88@8000v tr]0808[EE Oracle HTML Navigator
$%08000800P0800a 0808function AfterPForm return boolean is begin -- outputs to a tab-delimited file CHR if :output = 'Save as text file' then if :desformat <> 'delimiteddata' then :destype := 'FILE'; :desformat := 'Delimiteddata'; :desname := 'C:\emp-excel.txt'; --change FILENAME to meaningful name srw.message(051,'The report is being saved to C:\emp-excel.txt'); --change FILENAME to meaningful name end if; end if; return (TRUE); end;:00008&&select * from emp where deptno = :dept t*>FNW(Z ^bg(nrw(~(((SQL*ReportWriterpuREPORTEKUgxjjxcltEKUxg  EKUxi 0vt is &1 x/pKrouted to a PDF file(cyanrpr*00x" $ &(_H)darkcyan(00x " $&*gray80333333(00x " $&+gray76=p=p=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%0.r0g25b0@)00x " $&'/r25g25b0@@)00x " $&'0r50g25b0@)00x " $&'01r75g25b0@)00x " $&'2r88g25b0@+00x $ &()3 r100g25b0@*00x" $ &(04r0g25b50@,00x $ & (*5 r25g25b50@@,00x $ & (*6 r50g25b50@,00x $ & (*07 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (*9 r100g25b50@*00x" $ &(0:r0g25b750@,00x $ & (*; r25g25b75@@,00x $ & (*< r50g25b75@,00x $ & (*0= r75g25b75@,00x $ & (*> r88g25b75@,00x $ & (*? r100g25b75@*00x" $ &(0@r0g25b885@,00x $ & (*A r25g25b88@@,00x $ & (*B r50g25b88@,00x $ & (*0C r75g25b88@8000vr,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# $ &(0l r0g50b100,00x $ & (*m r25g50b100@,00x $ & (*8n r50g50b100,00x $ & (* io r75g50b100,00x $ & (*CHp r88g50b100.00x & ( *,f q r100g50b100ed'00x "$%= ryellows+00x $ &() s darkyellowe*00x "$ &(LEtmagenta n.00x &( *,heu darkmagenta t(00x " $&anvgray48(00x " $&enwgray44\\\(00x " $&0xgray40(00x " $&deygray36ףף'00x! "$%(zr0g75b0e)00x " $&'{r25g75b0@)00x " $&'0|r50g75b0 is)00x " $&'pK}r75g75b0 a )00x " $&'~r88g75b0$ &+00x $ &() r100g75b0$.08x& ( *,00r0g75b50008x ( * ,. 00r25g75b50@008x ( * ,. $ 00r50g75b50008x ( * ,. 00r75g75b50008x ( * ,.b0 00r88g75b50008x ( * ,.@ 00r100g75b50.08x& ( *,00r0g75b750&008x ( * ,. 00r25g75b75@008x ( * ,. 00r50g75b75008x ( * ,.0 00r75g75b75008x ( * ,. 00r88g75b75008x ( * ,. $ 00r100g75b75.08x& ( *, (00r0g75b885008x ( * ,. 00r25g75b88@008x ( * ,. 00r50g75b88008x ( * ,.5g 00r75g75b88008x ( * ,.b7 00r88g75b88008x ( * ,. 00r100g75b88.08x' ( *, 00r0g75b100 (008x ( * ,. 00r25g75b100@008x ( * ,. 00r50g75b100008x ( * ,.0 00r75g75b100008x ( * ,. 00r88g75b1008@8000vpr208x * , .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 & ( *,f 00custom7ed.08x & ( *,= 00custom8,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 ( 00r50g100b100208x * , .0 00r75g100b100208x * , .0 00r88g100b10000r75g75b100008x ( * ,. 00r88g75b1008@8000vr208x * , .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@0NOPQRSTUVWXY Z\]^_`abcdefghMS Sans Serifq 1p"&'*./beforepform -p"#&*+afterpform @ pp%p/5670809:;<=>kEMPNOemp.EMPNOEMPNOg@ pp%p/5670809:;<=>nENAMEemp.ENAMEENAME g: pp#p+/01020345678qJOBemp.JOBJOB gb8: pp#p+/01020345678tMGRemp.MGRMGRgI pp(p5>?@0A0BCDEFGwHIREDATEemp.HIREDATEHIREDATE g : pp#p+/01020345678zSALemp.SALSALg10= pp$p-2340506789:;}COMMemp.COMMCOMMg0C pp&p189:0;0<=>?@ADEPTNOemp.DEPTNODEPTNOgF&p'+,2p6p6p66788:8<8>8@BCDgQ_1BEUff FpGOPQRST0UVW0XYZ0[\]^_xb8b8d8f8hjkplplpttpup &hG_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 Background0/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 Symbol5g/bpcjklmnoprrpspuuvwxy0z0{0|0}0~0ppppppp`COPIES1Number of Copies0g/bpcmnopqrpvvpwp||}~ 000000pppppppaDESFORMATdfltDestination Format8/bpcklmnoppvvpwpwwxy z|0}0~0000pppppppbDESNAMEDestination Name ./bpcklmnoppvvpwp~~000000pppppppcDESTYPEScreenPDestination Type0vXr/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_'COMMe/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~  ppppppDEPTNOhDeptno@'DEPTNO#p+/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~~ppppppP_PASS 'P_PASS78/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~~ppppppP_ROLE 'P_ROLEgF&p'+,2p6p6p66788:8<8>8@BCDgQ_1BEUff FpGOPQRST0UVW0XYZ0[\]^_xb8b8d8f8hjkplplpttpup &hG_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 Background0/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 Symbol5g/bpcjklmnoprrpspuuvwxy0z0{0|0}0~0ppppppp`COPIES1Number of Copies0g/bpcmnopqrpvvpwp||}~ 000000pppppppaDESFORMATdfltDestination Format8/bpcklmnoppvvpwpwwxy z|0}0~0000pppppppbDESNAMEDestination Name ./bpcklmnoppvvpwp~~000000pppppppcDESTYPEScreenPDestination Type0vr~#JpKQR(VpZpZ@Z8^8`8bdefghijkl0m0n0opppr0rstuvwxyz{|F_SAL TE0ypt~#JpKRS(VpZpZ@Z8^8`8bdefghijkl0m0n0opppr0rstuvwxyz{|F_COMME0|p~#JpKTU(VpZpZ@Z8^8`8bdefghijkl0m0n0opppr0rstuvwxyz{|F_DEPTNO0t~#JpKST(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|PF_DEPT00uiAMv#JpKPQ(RpVpV8V8X8Z8\^_`abcdef0g0h0ipjpj0jklmnopqrstPF_11*>  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_'COMMe/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~  ppppppDEPTNOhDeptno@'DEPTNO#p+/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~~ppppppP_PASS 'P_PASS78/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~~ppppppP_ROLE 'P_ROLEgF&p'+,2p6p6p66788:8<8>8@BCDgQ_1BEUff FpGOPQRST0UVW0XYZ0[\]^_xb8b8d8f8hjkplplpttpup &hG_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 Background0/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 Symbol5g/bpcjklmnoprrpspuuvwxy0z0{0|0}0~0ppppppp`COPIES1Number of Copies0g/bpcmnopqrpvvpwp||}~ 000000pppppppaDESFORMATdfltDestination Format8/bpcklmnoppvvpwpwwxy z|0}0~0000pppppppbDESNAMEDestination Name ./bpcklmnoppvvpwp~~000000pppppppcDESTYPEScreenPDestination Type0v"l1  $  BEFOREPFORMPfunction BeforePForm return boolean is vc_parameter_form varchar2(4000); vc_hidden_runtime_values varchar2(1000); vc_report_name varchar2(50); hold_cmd VARCHAR2(240); begin if :P_Role IS NOT NULL then if substr(:P_Pass,1,1) = chr(34) then Hold_Cmd := :P_Role || ' IDENTIFIED BY '||:P_Pass; else Hold_Cmd := :P_Role || ' IDENTIFIED BY '|| chr(34) ||:P_Pass ||chr(34); end if; DBMS_SESSION.SET_ROLE(Hold_Cmd); end if; srw.get_report_name(vc_report_name); vc_hidden_runtime_values:='report='||rtrim(vc_report_name)||'.rep' ||'&destype=Cache'||'&userid='||:p_user_connect ||'&server='||:p_servername; vc_parameter_form:='' ||'' ||'
' ||'' ||'' ||'' ||'' ||'' ||'

' ||'
' ||'


'; srw.set_before_form_html (srw.text_escape, vc_parameter_form); return (TRUE); end; @@eter_form); return (TRUE); end; @@ /,D 7 . G #K !"3J' ( / 3 7  102 546P98:;<< ?@@BCC E!F"#F$,H%I&'I &) $%,-.$%(d,-.ͫͫͫͫͫͫͫ0D ]     %Y   8  P4 4.hH&'Hp% % hg!88D0 AFTERPFORMrtfFILErtfC:\emp-word.rtf3,The report is being saved to C:\emp-word.rtf2(H P\( `(4 %0 < H T s~X` d8pPxhp, @@( * , . 00r75g100b88008x( * , . 00r88g100b88208x* , . 0 00r100g100b88008x(* , . 00r0g100b100208x* , . 0 00r25g100b100@208x* , . 0 00r50g100b100208x* , . 0 00r75g100b100208x* , . 0 00r88g100b100208x* , . 0 00r100g100b10025b88@$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); begin if :P_Role IS NOT NULL then if substr(:P_Pass,1,1) = chr(34) then Hold_Cmd := :P_Role || ' IDENTIFIED BY '||:P_Pass; else Hold_Cmd := :P_Role || ' IDENTIFIED BY '|| chr(34) ||:P_Pass ||chr(34); end if; DBMS_SESSION.SET_ROLE(Hold_Cmd); end if; srw.get_report_name(vc_report_name); vc_hidden_runtime_values:='report='||rtrim(vc_report_name)||'.rep' ||'&destype=Cache'||'&userid='||:p_user_connect ||'&server='||:p_servername; vc_parameter_form:='' ||'' ||'' ||'' ||'' ||'' ||'' ||'' ||'

' ||'
' ||'


'; srw.set_before_form_html (srw.text_escape, vc_parameter_form); return (TRUE); end; 0 /  H 5 1G  L  92 K  =3 O   92 R "#A 4U%(Y&'3X,  -  5  9 =A  768 (;:<?>@PCBDEFF IJJ# M N!"N #P$Q%&Q'S(T)*T+,V,W-.W& +. !$)*1234)*.d2134ͫͫͫͫͫͫͫ0D k W 8    j `  S I044H  `H H.x\&'\% % hg!XXD0 AFTERPFORMSave as text filertfFILErtfC:\emp-word.doc3,The report is being saved to C:\emp-word.doc:(\ 4  d( (4(H  %<H T ` Xp0xH`x,  @@OMME0| ~#JKpTUV(ZpZpZ@^8`8b8defghijklm0n0o0pprpr0stuvwxyz{|F_DEPTNO0  l1 $"a AFTERPFORMfunction AfterPForm return boolean is begin -- outputs to a tab-delimited file CHR if :output = 'Save as text file' then if :desformat <> 'delimiteddata' then :destype := 'FILE'; :desformat := 'Delimiteddata'; :desname := 'C:\emp-excel.txt'; --change FILENAME to meaningful name srw.message(051,'The report is being saved to C:\emp-excel.txt'); --change FILENAME to meaningful name end if; end if; return (TRUE); end; 9Rͫͫͫͫͫͫͫw SYSSTANDARD SRW $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"AFTERPFORM""n$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08/ZZZZ) $ EA eeAeeAeeAeeAAAeAAeAAeAAeAAeAAe"FUNCTION"AFTERPFORM"RETURN"BOOLEAN"OUTPUT""="Save as text file"DESFORMAT"!="delimiteddata"DESTYPE"FILE"Delimiteddata"DESNAME"C:\emp-excel.txt"SRW"MESSAGE"051"The report is being saved to C:\emp-excel.txt"TRUE"": #$(357:>CGHOTVY]bfgnsuy  #+/258;CDGJRSVYadgoru}h,<.|n<.|n n n nWkQneZOcQcQcQcQQcQcQcQcQcQc     "%    0 /  H 5 1G  L  92 K  =3 O   92R"#A 4U%(Y&'3X,  -  5  9 =A  768 (;:<?>@PCBDEFF  IJJ# M N!"N# P$Q%&Q'S(T)*T+-V,W-.W& +. !$)*1234)*.d2134ͫͫͫͫͫͫͫ0D k s 8    j `  S I044H  `H H.x\&'\% % hg!tt4D0 AFTERPFORMSave as text file delimiteddataFILE DelimiteddataC:\emp-excel.txt3-The report is being saved to C:\emp-excel.txt:(\ 4  d( (4(H  %<H T ` Xp 0H `x-  @@ , . 00r75g75b100008x( * , . 00r88g75b1000 r/bpcrstuvwpzzp{p{{|}~000000pppppppP_USER_CONNECT2 P_ROP_USER_CONNECTS/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~~ppppppOutput( OUTPUT#/ bpdqrstuvpzzp{p{{|}~000000pppppppP_SERVERNAME 2 OUTPP_SERVERNAME/ bpdmnopqrpvvpwpwwxyz{0|0}0~000pppppppP_ACTIONd P_ACTION*Zp[cd(jpnpn0n0o8p8rtuvxz000000p0B_EMPNO 0h_*Zp[cd(jpnpn8n0p8r8tvwxx~000000p0NB_ENAME 0*Zp[ab(fpjpj8j0l8n8prstxz000000p00B_JOB0606*Zp[ab(fpjpj8j0l8n8prstxz000000p0B_MGR 0T0T*Zp[fg(jpnpn8n0p8r8tvwxx~000000p0B_HIREDATE 00jTj*Zp[ab(fpjpj@j0n8p8rtuvxz000000p0B_SALTE0j800098000:8000;8000<8000=8000>8000?8000@8000A8000B8000C8000D8000E8000F8000G8000H8000I8000J8000K8000L8000M8000N8000O8000P8000Q8000R8000S8000T8000U8000V8000W8000X8000Y8000Z8000[8000\8000]8000^8000_8000`8000a8000b8000c8000d8000e8000f8000g8000h8000i8000j8000k8000l8000m8000n8000o8000p8000q8000r8000s8000t8000u8000v@ r*Zp[bc(fpjpj@j0n8p8rtuvxz000000p0pB_COMME0j/*Zp[de(fpjpj@j0n8p8rtuvxz000000p0B_DEPTNO0j{*Zp[`a(bpfpf8f8h8j8lnopxv000000p0 PB_1rVrVz*Zp[`a(bpfpf8f8h8j8lnopxvvz0~00000p0PB_2IS*Zp[cd(jpnpn8n8p8r8tvwxx~000000p0PB_DEPTq Sq S*Zp[`a(bpfpf8f8h8j8lnopxv000000p0PB_3U-U US U-U U St*Zp[`a(bpfpf8f8h8j8lnopxv000000p06PB_4 Me S  Me Sr* Zp\ab(fpjpj8j8l8n8prstxz000000p0PB_5 V;Uj  V;Uj v            0               j   ߊ         S         ~BpCST(Zp^p^0^0_@b8fhijk0l0m0n0o0p0qr0s0tuvwxyz{|M_G_EMPNO_GRPFRp0 hvBpCQR TpVpV0V0W@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstM_G_EMPNO_HDRphvBpCMN(RpVpV0V8X@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstR_G_EMPNOR0h0~#JpKST(Zp^p^0^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_EMPNO00j~#JpKST(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_ENAME00mz#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_JOB006p0z#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_MGR 00Ts~#JpKVW(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_HIREDATE 00jvT8000U8000V8000W8000X8000Y8000Z8000[8000\8000]8000^8000_8000`8000a8000b8000c8000d8000e8000f8000g8000h8000i8000j8000k8000l8000m8000n8000o8000p8000q8000r8000s8000t8000u8000v