ROS.60050( r    !"#$%&'()*+,-./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@@r08QR(VpZ@ZP08ghijl" p vView on screen% p#Save as text filept pekuorep pgoqorepp (0@stuvwxyz{|F_COMME0|p~#JpKTU(VpZpZ@Z8^8`8bdefghijkl0m0n0opppr0rstuvwxyzdpd` 88 P 88# T0 88h l&00x $uvwxD r88g25b88PT,08x *i 00r100g75b100,08x *8X8Z8\^ 00r100g100b100`8&p'+,2p6qrstPF_11*gQ_1mbpchijkJob_'JOBP/bpcghijklprrpspsstuvw0xiDEPT }p~pwbpcrstuppppsMGRhtMgr`'MGRP_USER_CONNECTmlZp[de(fpjuvw0x0y0z0{0|0}p~( ppppppvHIREDATB_DEPTNO0\JpKQR(VpZ 'BHIREDATEX/bpcghijklprrF_SAL TE00y0z0{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 & ( *,00custom70.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 ( * ,. 00r88g75b1008000vx0r 88  2jk0l0m0n8p8rt v0x0yz{0|}~ppppppppr%rHrHr]r]r]r]r]rbbrcrffrjrrrsrtrCeC Rhjxg  | 2



$GXJJXCLB(F0JK@N@R@V@Z0^0_0`0a0b0c d0f0ghi8j8l0nop rtpuppfr]r]r@@PjjReport ParametersEnter values for the parametersH$00x !"black(00x " $&white%00x "#green)00x# $&' darkgreen(00x " $&gray96 = = =(00x " $&gray92zzz(00x " $&gray88(00x " $&Dgray84(((%00x !"#r0g0b0(00x "$%& r25g0b0@(00x "$%& r50g0b0(00x "$%&OR r75g0b0(00x "$%& r88g0b0(00x "$%& r100g0b0(00x!" $&PFr0g0b50*00x "$ &(E)r25g0b50@8*00x "$ &( r50g0b50AF*00x "$ &(rRr75g0b50an*00x "$ &(CUr88g0b50OK,00x $& (* e r100g0b50(00x!" $&d;r0g0b75*00x "$ &(r25g0b75@YS*00x "$ &(ekr50g0b75CU*00x "$ &(r75g0b75*00x "$ &(r88g0b75,00x $& (* r100g0b75(00x!" $&NIr0g0b88*00x "$ &(r25g0b88@*00x "$ &(r50g0b88*00x "$ &(r75g0b88*00x "$ &(r88g0b88,00x $& (* r100g0b88(00x"# $& r0g0b100,00x $& (*! r25g0b100@,00x $& (*OO" r50g0b100,00x $& (*S"# r75g0b100,00x $& (*3$ r88g0b100,00x $& (*h% r100g0b100&00x  "$O&gray*00x " $ &('darkgray&00x "$(cyanr*00x" $ &()darkcyan(00x " $&*gray80333333(00x " $&+gray76=p=p=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%.r0g25b0@)00x " $&'/r25g25b0@@ͫ)00x " $&'0r50g25b0@)00x " $&'1r75g25b0@)00x " $&'2r88g25b0@+00x $ &()3 r100g25b0@*00x" $ &(4r0g25b50@,00x $ & (* 5 r25g25b50@@,00x $ & (* 6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (* 9 r100g25b50@*00x" $ &( r:r0g25b750@pt,00x $ & (*ur; r25g25b75@@,00x $ & (* *< r50g25b75@,00x $ & (*N= r75g25b75@,00x $ & (*it> r88g25b75@,00x $ & (*g ? r100g25b75@*00x" $ &( .@r0g25b885@0b,00x $ & (*A r25g25b88@@,00x $ & (*b1B r50g25b88@,00x $ & (*8gC r75g25b88@8000v@ r.hh,p6ROSATTRIBSclass attributes+hh)fROSLFDESCros lf descripT)hh'^ROSOBJMAPros name->idup+hh)ROSSTRINGStk2 uiStringsN*hh(ROSSTRUCTSstruct typespw*hh(0ROSTK2RESVtk2 reservedhhSRW2_ANCHOR &h!"h#$SRW2_BODY_LOCATION $h h!"ntSRW2_BOILERPLATEhhzSRW2_BUTTON!hhSRW2_COLUMN#hh ! SRW2_DATA_MODEL $h h!"SRW2_DISPLAY_TAG%h !h"#qSRW2_DISTRIBUTION'~0 hhSRW2_ELEMENThhSRW2_FIELDD)h$%h&'SRW2_FORMAT_EXCEPTION&hh/SRW2_FRAMEthh0SRW2_GROUP#hh !SRW2_GROUP_NODE#"hh SRW2_HYPERLINK"$h h!"nSRW2_JAVA_APPLET$(h#$h%&lSRW2_JAVA_PROPERTIES%hhSRW2_LAYOUT %h !h"#pSRW2_LAYOUT_GROUP hhciSRW2_LINKhhSRW2_LISTS nhhxSRW2_MATRIX'h"#h$%pSRW2_OGD_COLUMN_MAP$h h!"SRW2_OG_DOCUMENT#hh !rSRW2_PARAM_FORMhhmSRW2_QUERYps%h !h"#0}SRW2_TEXT_SEGMENThhpTOOL_ACCESSC hhTOOL_COMMENT hh0TOOL_LIBRARY hhvTOOL_MODULE~hhpTOOL_PLSQL$pp"OPVG_COLORVG_COLOR+pp $&'()VG_COLORITEMID@+pp $&'()VG_COLORCELLID@-pp &()*+VG_COLORNAME_SET@ /pp (*+,-VG_COLORNAME_LENGTH F/pp (*+,-VG_COLORCOLOR_NAMExp'pp "#$%VG_COLORRED )pp "$%&'VG_COLORGREEN )pp "$%&'VG_COLORBLUE "x pcEmpnov"x 0Ename xJob xcrMgr%x# Hiredate & xSal!x5gComm#x!ͰDeptno5x3 $PDF/Excel output example(.x,Using new version!x10Dept,#x! Output,00x $& (*S"# r75g0b100,00x $& (*3$ r88g0b100,00x $& (*h% r100g0b100&00x  "$O&gray*00x " $ &('darkgray&00x "$(cyanr*00x" $ &()darkcyan(00x " $&*gray80333333(00x " $&+gray76=p=p=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%.r0g25b0@)00x " $&'/r25g25b0@@ͫ)00x " $&'0r50g25b0@)00x " $&'1r75g25b0@)00x " $&'2r88g25b0@+00x $ &()3 r100g25b0@*00x" $ &(4r0g25b50@,00x $ & (* 5 r25g25b50@@,00x $ & (* 6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (* 9 r100g25b50@*00x" $ &( r:r0g25b750@pt,00x $ & (*ur; r25g25b75@@,00x $ & (* *< r50g25b75@,00x $ & (*N= r75g25b75@,00x $ & (*it> r88g25b75@,00x $ & (*g ? r100g25b75@*00x" $ &( .@r0g25b885@0b,00x $ & (*A r25g25b88@@,00x $ & (*b1B r50g25b88@,00x $ & (*8gC r75g25b88@8000vPr 88u zp{p{{|}~000000pppppppP_USER_CONNECT2 P_ROP_USER_CONNECTS/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~~ppppppOutput( OUTPUT"h#/ bpdqrstuvpzzp{p{{|}~000000pppppppP_SERVERNAME 2 OUTPP_SERVERNAME/ bpdmnopqrpvvpwpwwxyz{0|0}0~000pppppppP_ACTIONd P_ACTION*Zp[cd(jpnpn0n0o8p8rtuvxz000000p00B_EMPNOͫ0/h"*Zp[cd(jpnpn8n0p8r8tvwxx~000000p0B_ENAMEͫ02*Zp[ab(fpjpj8j0l8n8prstxz000000p0"B_JOB0606*Zp[ab(fpjpj8j0l8n8prstxz000000p0B_MGR 0T0T*Zp[fg(jpnpn8n0p8r8tvwxx~000000p0B_HIREDATE 00jTj*Zp[ab(fpjpj@j0n8p8rtuvxz000000p0B_SALTE0j*Zp[bc(fpjpj@j0n8p8rtuvxz000000p0B_COMME0j"x 0Ename xJob xcrMgr%x# Hiredate & xSal!x5gComm#x!ͰDeptno5x3 $PDF/Excel output example(.x,Using new version!x10Dept,#x! Output,00x $& (*S"# r75g0b100,00x $& (*3$ r88g0b100,00x $& (*h% r100g0b100&00x  "$O&gray*00x " $ &('darkgray&00x "$(cyanr*00x" $ &()darkcyan(00x " $&*gray80333333(00x " $&+gray76=p=p=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%.r0g25b0@)00x " $&'/r25g25b0@@ͫ)00x " $&'0r50g25b0@)00x " $&'1r75g25b0@)00x " $&'2r88g25b0@+00x $ &()3 r100g25b0@*00x" $ &(4r0g25b50@,00x $ & (* 5 r25g25b50@@,00x $ & (* 6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (* 9 r100g25b50@*00x" $ &( r:r0g25b750@pt,00x $ & (*ur; r25g25b75@@,00x $ & (* *< r50g25b75@,00x $ & (*N= r75g25b75@,00x $ & (*it> r88g25b75@,00x $ & (*g ? r100g25b75@*00x" $ &( .@r0g25b885@0b,00x $ & (*A r25g25b88@@,00x $ & (*b1B r50g25b88@,00x $ & (*8gC r75g25b88@8000v`r 88pj 8p8rtuvxz000000p0pB_DEPTNO0j/*Zp[`a(bpfpf8f8h8j8lnopxv000000p0PB_1rVrVz*Zp[`a(bpfpf8f8h8j8lnopxv000000p0PB_2ISISx*Zp[cd(jpnpn8n8p8r8tvwxx~000000p0 PB_DEPTq Sq S*Zp[`a(bpfpf8f8h8j8lnopxv000000p0PB_3U-U US U-U U S                        j   ݒ   ߜ      ~BpCST(Zp^p^0^0_@b8fhijk0l0m0n0o0p0qr0s0tuvwxyz{|M_G_EMPNO_GRPFRp0 h0vBpCQR TpVpV0V0W@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstM_G_EMPNO_HDRphvBpCMN(RpVpV0V8X@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstR_G_EMPNOR0hE~#JpKST(Zp^p^0^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_EMPNO00j0~#JpKST(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_ENAME00mz#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_JOB006pz#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_MGR 00Ts~#JpKVW(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_HIREDATE 00jv!x5gComm#x!ͰDeptno5x3 $PDF/Excel output example(.x,Using new version!x10Dept,#x! Output,00x $& (*S"# r75g0b100,00x $& (*3$ r88g0b100,00x $& (*h% r100g0b100&00x  "$O&gray*00x " $ &('darkgray&00x "$(cyanr*00x" $ &()darkcyan(00x " $&*gray80333333(00x " $&+gray76=p=p=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%.r0g25b0@)00x " $&'/r25g25b0@@ͫ)00x " $&'0r50g25b0@)00x " $&'1r75g25b0@)00x " $&'2r88g25b0@+00x $ &()3 r100g25b0@*00x" $ &(4r0g25b50@,00x $ & (* 5 r25g25b50@@,00x $ & (* 6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (* 9 r100g25b50@*00x" $ &( r:r0g25b750@pt,00x $ & (*ur; r25g25b75@@,00x $ & (* *< r50g25b75@,00x $ & (*N= r75g25b75@,00x $ & (*it> r88g25b75@,00x $ & (*g ? r100g25b75@*00x" $ &( .@r0g25b885@0b,00x $ & (*A r25g25b88@@,00x $ & (*b1B r50g25b88@,00x $ & (*8gC r75g25b88@8000vpTrO N(0@@00@@@@@@000000ppp 00880@@11AA AAAA11A"A&1*1+A.A2A6A:A>AB1F1GHIJKLMdpdLPB `` jjLPB ``LPB ``  z*Zp[`a(bpfpf8f8h8j8lnopxv000000p0PB_2ISISx*Zp[cd(jpnpn8n8p8r8tvwxx~000000p0 PB_DEPTq Sq S*Zp[`a(bpfpf8f8h8j8lnopxv000000p0PB_3U-U US U-U U S                        j   ݒ   ߜ      ~BpCST(Zp^p^0^0_@b8fhijk0l0m0n0o0p0qr0s0tuvwxyz{|M_G_EMPNO_GRPFRp0 h0vBpCQR TpVpV0V0W@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstM_G_EMPNO_HDRphvBpCMN(RpVpV0V8X@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstR_G_EMPNOR0hE~#JpKST(Zp^p^0^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_EMPNO00j0~#JpKST(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_ENAME00mz#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_JOB006pz#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_MGR 00Ts~#JpKVW(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_HIREDATE 00jv!x5gComm#x!ͰDeptno5x3 $PDF/Excel output example(.x,Using new version!x10Dept,#x! Output,00x $& (*S"# r75g0b100,00x $& (*3$ r88g0b100,00x $& (*h% r100g0b100&00x  "$O&gray*00x " $ &('darkgray&00x "$(cyanr*00x" $ &()darkcyan(00x " $&*gray80333333(00x " $&+gray76=p=p=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%.r0g25b0@)00x " $&'/r25g25b0@@ͫ)00x " $&'0r50g25b0@)00x " $&'1r75g25b0@)00x " $&'2r88g25b0@+00x $ &()3 r100g25b0@*00x" $ &(4r0g25b50@,00x $ & (* 5 r25g25b50@@,00x $ & (* 6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (* 9 r100g25b50@*00x" $ &( r:r0g25b750@pt,00x $ & (*ur; r25g25b75@@,00x $ & (* *< r50g25b75@,00x $ & (*N= r75g25b75@,00x $ & (*it> r88g25b75@,00x $ & (*g ? r100g25b75@*00x" $ &( .@r0g25b885@0b,00x $ & (*A r25g25b88@@,00x $ & (*b1B r50g25b88@,00x $ & (*8gC r75g25b88@8000vr pgoqorep@00@@@@@@000000ppp 00880@@11AA AAAA11A"A&1*1+A.A2A6A:A>AB1F1GHIJKLMdpdLPB `` jjLPB ``LPB ``  z*Zp[`a(bpfpf8f8h8j8lnopxv000000p0PB_2ISISx*Zp[cd(jpnpn8n8p8r8tvwxx~000000p0 PB_DEPTq Sq S*Zp[`a(bpfpf8f8h8j8lnopxv000000p0PB_3U-U US U-U U S                        j   ݒ   ߜ      ~BpCST(Zp^p^0^0_@b8fhijk0l0m0n0o0p0qr0s0tuvwxyz{|M_G_EMPNO_GRPFRp0 h0vBpCQR TpVpV0V0W@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstM_G_EMPNO_HDRphvBpCMN(RpVpV0V8X@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstR_G_EMPNOR0hE~#JpKST(Zp^p^0^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_EMPNO00j0~#JpKST(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_ENAME00mz#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_JOB006pz#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_MGR 00Ts~#JpKVW(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_HIREDATE 00jv!x5gComm#x!ͰDeptno5x3 $PDF/Excel output example(.x,Using new version!x10Dept,#x! Output,00x $& (*S"# r75g0b100,00x $& (*3$ r88g0b100,00x $& (*h% r100g0b100&00x  "$O&gray*00x " $ &('darkgray&00x "$(cyanr*00x" $ &()darkcyan(00x " $&*gray80333333(00x " $&+gray76=p=p=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%.r0g25b0@)00x " $&'/r25g25b0@@ͫ)00x " $&'0r50g25b0@)00x " $&'1r75g25b0@)00x " $&'2r88g25b0@+00x $ &()3 r100g25b0@*00x" $ &(4r0g25b50@,00x $ & (* 5 r25g25b50@@,00x $ & (* 6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (* 9 r100g25b50@*00x" $ &( r:r0g25b750@pt,00x $ & (*ur; r25g25b75@@,00x $ & (* *< r50g25b75@,00x $ & (*N= r75g25b75@,00x $ & (*it> r88g25b75@,00x $ & (*g ? r100g25b75@*00x" $ &( .@r0g25b885@0b,00x $ & (*A r25g25b88@@,00x $ & (*b1B r50g25b88@,00x $ & (*8gC r75g25b88@8000vr pekuorep@00@@@@@@000000ppp 00880@@11AA AAAA11A"A&1*1+A.A2A6A:A>AB1F1GHIJKLMdpdLPB `` jjLPB ``LPB ``  z*Zp[`a(bpfpf8f8h8j8lnopxv000000p0PB_2ISISx*Zp[cd(jpnpn8n8p8r8tvwxx~000000p0 PB_DEPTq Sq S*Zp[`a(bpfpf8f8h8j8lnopxv000000p0PB_3U-U US U-U U S                        j   ݒ   ߜ      ~BpCST(Zp^p^0^0_@b8fhijk0l0m0n0o0p0qr0s0tuvwxyz{|M_G_EMPNO_GRPFRp0 h0vBpCQR TpVpV0V0W@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstM_G_EMPNO_HDRphvBpCMN(RpVpV0V8X@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstR_G_EMPNOR0hE~#JpKST(Zp^p^0^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_EMPNO00j0~#JpKST(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_ENAME00mz#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_JOB006pz#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_MGR 00Ts~#JpKVW(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_HIREDATE 00jv!x5gComm#x!ͰDeptno5x3 $PDF/Excel output example(.x,Using new version!x10Dept,#x! Output,00x $& (*S"# r75g0b100,00x $& (*3$ r88g0b100,00x $& (*h% r100g0b100&00x  "$O&gray*00x " $ &('darkgray&00x "$(cyanr*00x" $ &()darkcyan(00x " $&*gray80333333(00x " $&+gray76=p=p=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%.r0g25b0@)00x " $&'/r25g25b0@@ͫ)00x " $&'0r50g25b0@)00x " $&'1r75g25b0@)00x " $&'2r88g25b0@+00x $ &()3 r100g25b0@*00x" $ &(4r0g25b50@,00x $ & (* 5 r25g25b50@@,00x $ & (* 6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (* 9 r100g25b50@*00x" $ &( r:r0g25b750@pt,00x $ & (*ur; r25g25b75@@,00x $ & (* *< r50g25b75@,00x $ & (*N= r75g25b75@,00x $ & (*it> r88g25b75@,00x $ & (*g ? r100g25b75@*00x" $ &( .@r0g25b885@0b,00x $ & (*A r25g25b88@@,00x $ & (*b1B r50g25b88@,00x $ & (*8gC r75g25b88@8000v,r% p#pSave as text file0000ppp 00880@@11AA AAAA11A"A&1*1+A.A2A6A:A>AB1F1GHIJKLMdpdLPB `` jjLPB ``LPB ``  z*Zp[`a(bpfpf8f8h8j8lnopxv000000p0PB_2ISISx*Zp[cd(jpnpn8n8p8r8tvwxx~000000p0 PB_DEPTq Sq S*Zp[`a(bpfpf8f8h8j8lnopxv000000p0PB_3U-U US U-U U S                        j   ݒ   ߜ      ~BpCST(Zp^p^0^0_@b8fhijk0l0m0n0o0p0qr0s0tuvwxyz{|M_G_EMPNO_GRPFRp0 h0vBpCQR TpVpV0V0W@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstM_G_EMPNO_HDRphvBpCMN(RpVpV0V8X@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstR_G_EMPNOR0hE~#JpKST(Zp^p^0^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_EMPNO00j0~#JpKST(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_ENAME00mz#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_JOB006pz#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_MGR 00Ts~#JpKVW(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_HIREDATE 00jv!x5gComm#x!ͰDeptno5x3 $PDF/Excel output example(.x,Using new version!x10Dept,#x! Output,00x $& (*S"# r75g0b100,00x $& (*3$ r88g0b100,00x $& (*h% r100g0b100&00x  "$O&gray*00x " $ &('darkgray&00x "$(cyanr*00x" $ &()darkcyan(00x " $&*gray80333333(00x " $&+gray76=p=p=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%.r0g25b0@)00x " $&'/r25g25b0@@ͫ)00x " $&'0r50g25b0@)00x " $&'1r75g25b0@)00x " $&'2r88g25b0@+00x $ &()3 r100g25b0@*00x" $ &(4r0g25b50@,00x $ & (* 5 r25g25b50@@,00x $ & (* 6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (* 9 r100g25b50@*00x" $ &( r:r0g25b750@pt,00x $ & (*ur; r25g25b75@@,00x $ & (* *< r50g25b75@,00x $ & (*N= r75g25b75@,00x $ & (*it> r88g25b75@,00x $ & (*g ? r100g25b75@*00x" $ &( .@r0g25b885@0b,00x $ & (*A r25g25b88@@,00x $ & (*b1B r50g25b88@,00x $ & (*8gC r75g25b88@8000v(r" p pView on screenle0000ppp 00880@@11AA AAAA11A"A&1*1+A.A2A6A:A>AB1F1GHIJKLMdpdLPB `` jjLPB ``LPB ``  z*Zp[`a(bpfpf8f8h8j8lnopxv000000p0PB_2ISISx*Zp[cd(jpnpn8n8p8r8tvwxx~000000p0 PB_DEPTq Sq S*Zp[`a(bpfpf8f8h8j8lnopxv000000p0PB_3U-U US U-U U S                        j   ݒ   ߜ      ~BpCST(Zp^p^0^0_@b8fhijk0l0m0n0o0p0qr0s0tuvwxyz{|M_G_EMPNO_GRPFRp0 h0vBpCQR TpVpV0V0W@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstM_G_EMPNO_HDRphvBpCMN(RpVpV0V8X@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstR_G_EMPNOR0hE~#JpKST(Zp^p^0^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_EMPNO00j0~#JpKST(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_ENAME00mz#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_JOB006pz#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_MGR 00Ts~#JpKVW(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_HIREDATE 00jv!x5gComm#x!ͰDeptno5x3 $PDF/Excel output example(.x,Using new version!x10Dept,#x! Output,00x $& (*S"# r75g0b100,00x $& (*3$ r88g0b100,00x $& (*h% r100g0b100&00x  "$O&gray*00x " $ &('darkgray&00x "$(cyanr*00x" $ &()darkcyan(00x " $&*gray80333333(00x " $&+gray76=p=p=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%.r0g25b0@)00x " $&'/r25g25b0@@ͫ)00x " $&'0r50g25b0@)00x " $&'1r75g25b0@)00x " $&'2r88g25b0@+00x $ &()3 r100g25b0@*00x" $ &(4r0g25b50@,00x $ & (* 5 r25g25b50@@,00x $ & (* 6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (* 9 r100g25b50@*00x" $ &( r:r0g25b750@pt,00x $ & (*ur; r25g25b75@@,00x $ & (* *< r50g25b75@,00x $ & (*N= r75g25b75@,00x $ & (*it> r88g25b75@,00x $ & (*g ? r100g25b75@*00x" $ &( .@r0g25b885@0b,00x $ & (*A r25g25b88@@,00x $ & (*b1B r50g25b88@,00x $ & (*8gC r75g25b88@8000vdr]0808[EE Oracle HTML Navigator
uvwxF_JOB006pz#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_MGR 00Ts~#JpKVW(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_HIREDATE 00jv!x5gComm#x!ͰDeptno5x3 $PDF/Excel output example(.x,Using new version!x10Dept,#x! Output,00x $& (*S"# r75g0b100,00x $& (*3$ r88g0b100,00x $& (*h% r100g0b100&00x  "$O&gray*00x " $ &('darkgray&00x "$(cyanr*00x" $ &()darkcyan(00x " $&*gray80333333(00x " $&+gray76=p=p=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%.r0g25b0@)00x " $&'/r25g25b0@@ͫ)00x " $&'0r50g25b0@)00x " $&'1r75g25b0@)00x " $&'2r88g25b0@+00x $ &()3 r100g25b0@*00x" $ &(4r0g25b50@,00x $ & (* 5 r25g25b50@@,00x $ & (* 6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (* 9 r100g25b50@*00x" $ &( r:r0g25b750@pt,00x $ & (*ur; r25g25b75@@,00x $ & (* *< r50g25b75@,00x $ & (*N= r75g25b75@,00x $ & (*it> r88g25b75@,00x $ & (*g ? r100g25b75@*00x" $ &( .@r0g25b885@0b,00x $ & (*A r25g25b88@@,00x $ & (*b1B r50g25b88@,00x $ & (*8gC r75g25b88@8000vr,00x $ & (*RID r88g25b88@,00x $ & (*SLE r100g25b88@*00x# $ &(SOF r0g25b100@id,00x $ & (*SSG r25g25b100@@,00x $ & (*SSH r50g25b100@,00x $ & (*STI r75g25b100@,00x $ & (*W2J r88g25b100@.00x & ( *,ATK r100g25b100@$00x  !"Lred(00x "$%&Mdarkred$00x "Nblue(00x"# $&hOdarkblue(00x " $&OLPgray64\(\(\((00x " $&VQgray60ffffff(00x " $&ITRgray56ppp(00x " $&ORSgray52zzz'00x! "$%_CTr0g50b0@)00x " $&'+Ur25g50b0@E_L)00x " $&' (Vr50g50b0CO)00x " $&'Wr75g50b0LOR)00x " $&' "Xr88g50b0GR+00x $ &() "Y r100g50b0L*00x" $ &(Zr0g50b50,00x $ & (*0[ r25g50b50@,00x $ & (*\ r50g50b50,00x $ & (*] r75g50b50,00x $ & (*0^ r88g50b50,00x $ & (*_ r100g50b50*00x" $ &(`r0g50b750,00x $ & (*0a r25g50b75@,00x $ & (*b r50g50b75,00x $ & (*c r75g50b75,00x $ & (*0d r88g50b75,00x $ & (*e r100g50b75*00x" $ &(fr0g50b885,00x $ & (*0g r25g50b88@,00x $ & (*h r50g50b88,00x $ & (*i r75g50b88,00x $ & (*0j r88g50b88,00x $ & (*k r100g50b88*00x# $ &(l r0g50b100,00x $ & (*0m r25g50b100@,00x $ & (*n r50g50b100,00x $ & (*o r75g50b100,00x $ & (*0p r88g50b100.00x & ( *,q r100g50b1000'00x "$%ryellow+00x $ &()0s darkyellow*00x "$ &(tmagenta.00x &( *,u darkmagenta(00x " $&0vgray48(00x " $&wgray44\\\(00x " $&xgray40(00x " $&ygray36ףף'00x! "$%0zr0g75b0)00x " $&'{r25g75b0@)00x " $&'|r50g75b00)00x " $&'}r75g75b0)00x " $&'~r88g75b0+00x $ &() r100g75b0.08x& ( *,00r0g75b50008x ( * ,. 00r25g75b50@008x ( * ,. 00r50g75b50008x ( * ,. 00r75g75b50008x ( * ,. 00r88g75b50008x ( * ,.0 00r100g75b50.08x& ( *,00r0g75b750008x ( * ,.0 00r25g75b75@008x ( * ,. 00r50g75b75008x ( * ,. 00r75g75b75008x ( * ,. 00r88g75b75008x ( * ,. 00r100g75b75.08x& ( *,00r0g75b885008x ( * ,. 00r25g75b88@008x ( * ,.0 00r50g75b88008x ( * ,. 00r75g75b88008x ( * ,.0 00r88g75b88008x ( * ,. 00r100g75b88.08x' ( *, 00r0g75b100008x ( * ,. 00r25g75b100@008x ( * ,. 00r50g75b100008x ( * ,. 00r75g75b100008x ( * ,. 00r88g75b1008000vpr208x * , .0RI 00r100g75b100.08x & ( *,0000custom10.08x & ( *,1000custom2.08x & ( *,@00custom3 $.08x & ( *,00custom4 (,08x $ & (*00gray32,08x $ & (*00gray28QQQ,08x $ & (*00gray24,08x $ & (*00gray20+08x% &()000r0g88b0-08x & (*+"00r25g88b0@-08x & (*+OL00r50g88b0(-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 ( * ,. 00r75g88b88008x ( * ,. 00r88g88b88008x ( * ,.5g 00r100g88b88.08x' ( *,b8 00r0g88b100008x ( * ,. 00r25g88b100@008x ( * ,. 00r50g88b100008x ( * ,. 00r75g88b100008x ( * ,. 00r88g88b100208x * , .00 00r100g88b100b1.08x & ( *, $00custom5.08x & ( *, (00custom6.08x & ( *,00custom70.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 ( * ,. 00r88g75b1008000vr208x * , .0RI 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 1 p"&'*./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 & ( *,00custom70.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 ( * ,. 00r88g75b1008000vXr/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 & ( *,00custom70.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 ( * ,. 00r88g75b1008000vr~#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_'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 & ( *,00custom70.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 ( * ,. 00r88g75b1008000v l1  $  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 5, -- Generate PDF HTML 'delimiteddata', -- Output Format NULL, -- ASCII Delimiter (optional) 'Output', -- Field name for java scripts (types 5-8) 'View on screen', -- Verbage to select PDF output (types 5-8) 'Save as text file', -- 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; @0 l@8 box,D-8 graphic" intro" graph_fp c!" c!"S c!T# graphic drawnFG123vOP$%4567 intro mlabel(OP12,h-2  MS Sans Serif567 fieldpicker graph_fp rwetb_fpeh rwetb_fpea tlist<W  MS Sans Serif tlist<W  MS Sans Serif,h-# label( ucfpUsage  MS Sans Serif label( ucfpUsage  MS Sans Serif88001 @8808zz box,D-8 graphic" intro" finishopts c!" 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(uN8808L66RESFILE___um p8headerfieldrwbf_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 5, -- Generate PDF HTML 'delimiteddata', -- Output Format NULL, -- ASCII Delimiter (optional) 'Output', -- Field name for java scripts (types 5-8) 'View on screen', -- Verbage to select PDF output (types 5-8) 'Save as text file', -- 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; vgmigr_helpstringrwloP r 0800 00800@t0808r\\1 $ \ AFTERPFORMCfunction 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@@W0000UCCfunction 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 vv v&v2v %&X\@@25g0808function 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*ReportWriterKgREPORTEKU gxjjxclt .EKUxg  EKUxi vx * , .0 00r75g100b100208x * , .0 00r88g100b10000r75g75b100008x ( * ,. 00r88g75b1008000v`trF&p'+,2p6p6p66788:8<8>8@BCDgQ_1EUff FpGOPQRST0UVW0XYZ0[\]^_xb8b8d8f8hjkplplpttpupjhG_EMPNOg=*%&4G_EMPNOLIST_G_EMPNO/bpclmnopqprrpspwwxyz{0|0}0~000pppppppYPRINTJOB YesPShow Print Job Dialognt/bpchijklmpnnpopwwxyz{0|0}0~000pppppppZMODE DefaultPOutput Mode r88g25b75@,00x $ & (*g ? r100g25b75@*00x" $ &( .@r0g25b885@0b,00x $ & (*A r25g25b88@@,00x $ & (*b1B r50g25b88@,00x $ & (*8gC r75g25b88@8000vpr/bpcrstuvwpzzp{p{{|}~000000pppppppP_USER_CONNECT2 P_ROP_USER_CONNECTS/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~~ppppppOutput( OUTPUT"h#/ bpdqrstuvpzzp{p{{|}~000000pppppppP_SERVERNAME 2 OUTPP_SERVERNAME/ bpdmnopqrpvvpwpwwxyz{0|0}0~000pppppppP_ACTIONd P_ACTION*Zp[cd(jpnpn0n0o8p8rtuvxz000000p00B_EMPNOͫ0/h"*Zp[cd(jpnpn8n0p8r8tvwxx~000000p0B_ENAMEͫ02*Zp[ab(fpjpj8j0l8n8prstxz000000p0"B_JOB0606*Zp[ab(fpjpj8j0l8n8prstxz000000p0B_MGR 0T0T*Zp[fg(jpnpn8n0p8r8tvwxx~000000p0B_HIREDATE 00jTj*Zp[ab(fpjpj@j0n8p8rtuvxz000000p0B_SALTE0j*Zp[bc(fpjpj@j0n8p8rtuvxz000000p0B_COMME0j"x 0Ename xJob xcrMgr%x# Hiredate & xSal!x5gComm#x!ͰDeptno5x3 $PDF/Excel output example(.x,Using new version!x10Dept,#x! Output,00x $& (*S"# r75g0b100,00x $& (*3$ r88g0b100,00x $& (*h% r100g0b100&00x  "$O&gray*00x " $ &('darkgray&00x "$(cyanr*00x" $ &()darkcyan(00x " $&*gray80333333(00x " $&+gray76=p=p=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%.r0g25b0@)00x " $&'/r25g25b0@@ͫ)00x " $&'0r50g25b0@)00x " $&'1r75g25b0@)00x " $&'2r88g25b0@+00x $ &()3 r100g25b0@*00x" $ &(4r0g25b50@,00x $ & (* 5 r25g25b50@@,00x $ & (* 6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (* 9 r100g25b50@*00x" $ &( r:r0g25b750@pt,00x $ & (*ur; r25g25b75@@,00x $ & (* *< r50g25b75@,00x $ & (*N= r75g25b75@,00x $ & (*it> r88g25b75@,00x $ & (*g ? r100g25b75@*00x" $ &( .@r0g25b885@0b,00x $ & (*A r25g25b88@@,00x $ & (*b1B r50g25b88@,00x $ & (*8gC r75g25b88@8000vr*Zp[de(fpjpj@j0n8p8rtuvxz000000p0pB_DEPTNO0j/*Zp[`a(bpfpf8f8h8j8lnopxv000000p0PB_1rVrVz*Zp[`a(bpfpf8f8h8j8lnopxv000000p0PB_2ISISx*Zp[cd(jpnpn8n8p8r8tvwxx~000000p0 PB_DEPTq Sq S*Zp[`a(bpfpf8f8h8j8lnopxv000000p0PB_3U-U US U-U U S                        j   ݒ   ߜ      ~BpCST(Zp^p^0^0_@b8fhijk0l0m0n0o0p0qr0s0tuvwxyz{|M_G_EMPNO_GRPFRp0 h0vBpCQR TpVpV0V0W@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstM_G_EMPNO_HDRphvBpCMN(RpVpV0V8X@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstR_G_EMPNOR0hE~#JpKST(Zp^p^0^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_EMPNO00j0~#JpKST(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_ENAME00mz#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_JOB006pz#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_MGR 00Ts~#JpKVW(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_HIREDATE 00jv!x5gComm#x!ͰDeptno5x3 $PDF/Excel output example(.x,Using new version!x10Dept,#x! Output,00x $& (*S"# r75g0b100,00x $& (*3$ r88g0b100,00x $& (*h% r100g0b100&00x  "$O&gray*00x " $ &('darkgray&00x "$(cyanr*00x" $ &()darkcyan(00x " $&*gray80333333(00x " $&+gray76=p=p=p(00x " $&,gray72GGG(00x " $&-gray68QQQ'00x! "$%.r0g25b0@)00x " $&'/r25g25b0@@ͫ)00x " $&'0r50g25b0@)00x " $&'1r75g25b0@)00x " $&'2r88g25b0@+00x $ &()3 r100g25b0@*00x" $ &(4r0g25b50@,00x $ & (* 5 r25g25b50@@,00x $ & (* 6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (*8 r88g25b50@,00x $ & (* 9 r100g25b50@*00x" $ &( r:r0g25b750@pt,00x $ & (*ur; r25g25b75@@,00x $ & (* *< r50g25b75@,00x $ & (*N= r75g25b75@,00x $ & (*it> r88g25b75@,00x $ & (*g ? r100g25b75@*00x" $ &( .@r0g25b885@0b,00x $ & (*A r25g25b88@@,00x $ & (*b1B r50g25b88@,00x $ & (*8gC r75g25b88@8000v