';
-- -- set the modified before form value, overwriting the default.
-- -- If you want to change the look of the parameter form then you
-- -- can do this here as well
srw.set_before_form_html (srw.text_escape, vc_parameter_form);
return (TRUE);
--
exception
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 FRR134B - 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 FRR134B - 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;03"-20104"-20105"-20106"3"7"9"14"8"56"2"55"63"64"23"54"38"21"57"27"51"" J
% ) * . 0 7 ; > F K L S W Z b g h o s v ~ $%(/03:;>EFIMQRUY]^aeijmquvy} "#(,3:;@DIJOSXY^bghmqxy~ " @ l 1 $ AFTERREPORT function AfterReport return boolean is
begin
G$_REPORT_SECURITY.G$_REPORT_REVOKE_ACCESS;
return (TRUE);
exception
when others then
return (FALSE);
end; l ͫͫͫͫͫͫͫ w SYS STANDARD /LgoqorepG$_REPORT_SECURITY $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 & "PKG INIT"AFTERREPORT"" | ! " 5 $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 v
$
L "AFTERREPORT"BOOLEAN"G$_REPORT_SECURITY"G$_REPORT_REVOKE_ACCESS"TRUE"FALSE""
% ) * . 0 4 8 ; @ A E H L N R U Y [ \ a e g s u h , k W Z e S Z e O
/
d , plsql_compiler_flags"nls_length_semantics" INTERPRETED,DEBUG"BYTE" ͫͫͫͫͫͫͫ H 6 6 ics" $ %$ %k k hg ! l AFTERREPORT ) d h @ @ @ @ @ @ @ @ A A A ? ? ? C D D D D D D D E E E C C C G H H H H H I I H H I I H H H H J J J G G G L M M M M M M M N N N L L L P Q Q Q Q Q R R Q Q R R Q Q Q Q S S S P P P U V V V V V V V W W W U U U Y Y Y Z Z Z Z Z Z Z [ [ [ [ [ \ \ \ Y Y Y ^ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ a a a ^ ^ ^ > b ! " # % ) ) ) ) . . / / 1 1 1 1 1 1 1 2 2 1 2 2 1 2 2 1 1 4 4 4 5 5 4 5 5 4 4 6 6 4 6 6 4 7 7 4 7 7 4 ; @ @ @ D D D H H H I I H H M M M Q Q Q R R Q Q V V V Z Z Z [ _ _ _ _ _ _ _
#
0 6 0 0 G ' ) 7 9 D F F % ' 1 3 $ & H J " " /
!
" " ) 1 3 " "
# ! # % ) ( ' 0 G G 9 9 ' ' & & J J ! ! ) ) " N ` ` /
n n _ o o _
d p
p _
q q _ %
" # $ ' % _ + d ) r r - + _
2
/ 0 1 4 2 _ s ` 6 _ t ` 9 _ u ` P r 1fpgtuvwxypzzp{p{{|}~000000pppppppp p_servername 2
P_SERVERNAME .bpckl(rpvpv0v0w8x8z|}~x000000p0ppp B_EMPNO 0
ĵe -Țe * .bpckl(rpvpv8v0x8z8|~x000000p0ppp B_ENAME 0 fpg .bpcij(nprpr8r0t8v8xz{|x000000p0ppp veB_JOB 0 6 0 6 0 .bpcij(nprpr8r0t8v8xz{|x000000p0ppp B_MGR
0 T 0 T p .bpcno(rpvpv8v0x8z8|~x000000p0ppp sB_HIREDATE 00 j T j w .bpcij(nprpr@r0v8x8z|}~x000000p0ppp 0|B_SAL TE 0 j _ .bpcjk(nprpr@r0v8x8z|}~x000000p0ppp B_COMM E 0 j .bpclm(nprpr@r0v8x8z|}~x000000p0ppp B_DEPTNO 0 j wp .bpchi(jpnpn8n8p8r8tvwxx~~000000p0ppp PB_1 &r 3 Q_1 E Uff FpGOPQRST0UVW0XYZ0[\]^_xb8b8d8f8hjkplplpt tpup hG_EMPNO g =*%&4 G_EMPNO LIST_G_EMPNO 1fpgpqrstupvvpwp{{|}~000000pppppppp YPRINTJOB Yes P Show Print Job Dialog e y 1fpglmnopqprrpsp{{|}~000000pppppppp ZMODE Default P Output Mode 1fpgrstuvwpzzp{p~~000000pppppppp [BACKGROUND
t No P Run in Background 0 1fpgstuvwxp~~pp000000pppppppp \ORIENTATION No Default P Orientation ( 1fpgopqrstpzzp{p{{|}~000000pppppppp ]DECIMAL Decimal Indicator 1 1fpgqrstuvpzzp{p{{|}~000000pppppppp ^THOUSANDS Thousands Indicator 1fpgpqrstupvvpwpwwxy z|0}0~0000pppppppp _CURRENCY Currency Symbol b 1fpgnopqrspvvpwpyyz{|}0~00000pppppppp `COPIES 1 Number of Copies 1fpgqrstuvpzzp{p 000000pppppppp aDESFORMAT dflt Destination Format * 1fpgopqrstpzzp{p{{|} ~000000pppppppp bDESNAME Destination Name
x ( * , .EK
00r88g75b100 8000 & ` r .bpchi(jpnpn8n8p8r8tvwxx~~000000p0ppp raPB_2 IS l>
.bpckl(rpvpv8v8x8z8|~x000000p0ppp >
PB_DEPT q
S val
t
r
c
d
n
d
>
/
<
> FpGWX(^pbpb0b0c@f8jlmno0p0q0r0s0t0uv0w0xyz{|}~p l M_G_EMPNO_GRPFR pp0 h 0c z FpGUV XpZpZ0Z0[@^8bdefg0h0i0j0k0l0mn0o0pqrstuvwpx x M_G_EMPNO_HDR h ra z FpGQR(VpZpZ0Z8\@^8bdefg0h0i0j0k0l0mn0o0pqrstuvwpx x R_G_EMPNO R 0 h ee %NpOWX(^pbpb0b8d8f8hjklmnopqr0s0t0upvpv0vwxyz{|}~pp F_EMPNO 0 0 j ay %NpOWX(^pbpb8b8d8f8hjklmnopqr0s0t0upvpv0vwxyz{|}~pp F_ENAME 0 0 m ~ %NpOUV(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{p|p| |F_JOB 00 6 p 0 ~ %NpOUV(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{p|p| |F_MGR 00 T s 0 %NpOZ[(^pbpb8b8d8f8hjklmnopqr0s0t0upvpv0vwxyz{|}~pp F_HIREDATE 00 j v 5g %NpOUV(Zp^p^@^8b8d8fhijklmnop0q0r0sptpv0vwxyz{|}~pp F_SAL
TE 0 y %NpOVW(Zp^p^@^8b8d8fhijklmnop0q0r0sptpv0vwxyz{|}~pp F_COMM E 0 | & %NpOXY(Zp^p^@^8b8d8fhijklmnop0q0r0sptpv0vwxyz{|}~pp F_DEPTNO 0 %NpOWX(^pbpb8b8d8f8hjklmnopqr0s0t0upvpv0vwxyz{|}~pp PF_DEPT 0 0 @ ui 0x "$ & (0 r75g0b88 *00x "$ & ( r88g0b88 RI ,00x $& ( * r100g0b88 (00x"# $ & r0g0b100 ,00x $& ( *0 ! r25g0b100 @ ,00x $& ( *p " r50g0b100 ,00x $& ( *tp # r75g0b100 ,00x $& ( *s $ r88g0b100 ,00x $& ( * %
r100g0b100 &00x " $AC & gray t *00x " $ & (gr ' darkgray &00x " $x ( cyan r *00x" $ & ( ) darkcyan (00x " $ &TA * gray80333333 (00x " $ &at + gray76=p=p=p (00x " $ &p , gray72GGG (00x " $ & - gray68QQQ '00x! "$ % . r0g25b0 @ )00x " $& 'l / r25g25b0@ @ )00x " $& 'r 0 r50g25b0 @ {| )00x " $& ' 1 r75g25b0 @ p )00x " $& 'HO 2 r88g25b0 @ +00x $ &( )r 3 r100g25b0 @ *00x" $ & (u 4 r0g25b50 @ 0} ,00x $ & ( *p 5 r25g25b50 @ @ ,00x $ & ( * 6 r50g25b50 @ ,00x $ & ( * 7 r75g25b50 @ ,00x $ & ( *0~ 8 r88g25b50 @ ,00x $ & ( * 9
r100g25b50@ *00x" $ & (Nu : r0g25b75 0@ ,00x $ & ( *pg ; r25g25b75 @ @ ,00x $ & ( * < r50g25b75 @ ,00x $ & ( * = r75g25b75 @ ,00x $ & ( *ti > r88g25b75 @ ,00x $ & ( *p ?
r100g25b75@ *00x" $ & ( @ r0g25b88 5@ p ,00x $ & ( *ES A r25g25b88 @ @ ,00x $ & ( *
B r50g25b88 @ ,00x $ & ( *b1 C r75g25b88 @ 8000 &