';
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 '||
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;
ZW2џџџџ
ўџџџџџџ
ўCCџџџџ
Џ Z hџџџџ
в ўџџџџџџ
п ўIBџџџџ
с ў hџџџџ
т ўџџџџџџ
у ўLSџџџџ
ф ўpџџџџ
х ўR џџџџ
ц ў) џџџџ
ч ў џџџџ
ш ў) џџџџ
щ ў Qџџџџ
ъ ў+ џџџџ
ў џџџџ
х Z+џџџџ
Е ZGTџџџџ
Z( џџџџ
Њ ўR_џџџџ
Zџџџџ
# ўRE № џџџџ 0800Ј c џџџџр r џџџџ 0800Ј
т р џџџџ 0800Ј
Ё № џџџџу0808Јс Ы Ы 1 А $ Ы В BEFOREREPORT Dfunction BeforeReport return boolean is
begin
return TRUE;
end; A B ЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭ wЧ SYS STANDARD $ ЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭ 8 & "PKG INIT"BEFOREREPORT"" | ! " џџ $ ЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭ 8 N "BEFOREREPORT"BOOLEAN"TRUE"" (
% ) * . 0 4 8 : > @ L h , Д Е e З Є Б O
џ
џџ d , plsql_compiler_flags"nls_length_semantics" INTERPRETED,DEBUG"BYTE" ЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭ H ics" % hg !x h џџџџ N BEFOREREPORT d @ @ Zџџџџ X0000Ј VD Dfunction BeforeReport return boolean is
begin
return TRUE;
end;џџџџц0808Јф Ю Ю 1 А $ Ю В
AFTERPFORM Afunction AfterPForm return boolean is
begin
return (TRUE);
end; I B ЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭ wЧ SYS STANDARD $ ЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭ 8 & "PKG INIT"AFTERPFORM"" | ! " џџ $ ЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭ 8 Q "AFTERPFORM"BOOLEAN"TRUE"" 6
% ) * . 0 4 7 ; = A C O h , Д Е Z e З Є Б O
џ
џџ d , plsql_compiler_flags"nls_length_semantics" INTERPRETED,DEBUG"BYTE" ЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭ H ics" % hg !x h џџџџ
N AFTERPFORM d @ @ 00џџџџ U0000Ј SA Afunction AfterPForm return boolean is
begin
return (TRUE);
end;* ,џџџџ 0800Ј Ж џџџџ Й0808Ј З Ё Ёfunction AfterReport return boolean is
begin
G$_REPORT_SECURITY.G$_REPORT_REVOKE_ACCESS;
return (TRUE);
exception
when others then
return (FALSE);
end;
00џџџџ 0000Ј
v v
SELECT TO_CHAR(empno) || RPAD(ename, 10) || RPAD(job, 9) || TO_CHAR(deptno) from emp where deptno = :dept
,џџџџ 6JRZc(f jnрs(z~р((((ppppp н SQL*ReportWriter REPORT EKU gxjfile о EKUxf
EKUxi
Є ! 5 @ 0р п 00r25g100b100 @ џџџџc_џџџџ 208x * , . 0џџ р 00r50g100b100 џџџџ џџџџ 208x * , . 0 с 00r75g100b100 Р џџџџ00џџџџ 208x * , . 08 т 00r88g100b100 р џџџџ5g75b100Р Р џџР џџ( В TIV/
џџ 8000Ј Ў џџџд 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 џџџџ N AFTERREPORT ) d h @ @ Ж0ЗИЙКЛ0М0ТpТЦЪ0ЫЬЭЮЯабвгдеpкpклpл B_tbvdetc_like_term_aid_ind :; Aw S W 6U A w S џD џџџџЩ .b dpj lr(vpvpv8x8z8|8~x0 0Ё0Ђ0ЃЄЅІЇ0Ј0ЎpЎВЖ0ЗИЙКЛМНОПРСpЦpЦЧpЧ PB_8 dF_like ЋsT2Њ ; sЋ 2T Њ 6U џ џ џџџџ
џ ўW2џџџџ
џўџџџџ
ўPRџџџџ
ўџџџџ
ў џџџџ
ўW2џџџџ
ўџџџџџџ
ўINџџџџ
ўhџџџџ
ўџџџџџџ
ўATџџџџ
+ ў$hџџџџ
ZP џџџџ
Zdeџџџџ
Zџџџџџџ
ZARџџџџ
Zџџџџ
Z џџџџ
ZW2џџџџ
ўџџџџџџ
ўCCџџџџ
Џ Z hџџџџ
в ўџџџџџџ
п ўIBџџџџ
с ў hџџџџ
т ўџџџџџџ
у ўLSџџџџ
ф ўpџџџџ
х ўR џџџџ
ц ў) џџџџ
ч ў џџџџ
ш ў) џџџџ
щ ў Qџџџџ
ъ ў+ џџџџ
ў џџџџ
х Z+џџџџ
Е ZGTџџџџ
Z( џџџџ
Њ ўR_џџџџ
Zџџџџ
# ўRE Q џџџџ 00 Q ` +J Detail Code Report
ОВ ю jj Yn А L PB ` ` ` А L PB ` ` `
џџџџ 00 Q џџџџ 00 Q ROR* User not authorized to access TGRDETC - 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 TGRDETC - report terminated.');
return (FALSE);
--
WHEN INVALID_ACCESS THEN
SRW.MESSAGE(1000,'*ERROR* Invalid password tried - report terminated.');
return (FA џџџџ r џџџџ Џ1fpgrstuvwpzzp{p~~000
000p ЁpЂpЂЂЃЄЅpІpІІЇЈЉpЊpЊЊЋЌp [BACKGROUND
t No P Run in Background џџџџ З1fpgstuvwxp~~pp000000p ЁЂЃЄpЅpЅЅІЇЈpЉpЎЎЏАБpВpВВГДpЕ Е\ORIENTATION No Default P Orientation џџџџ Џ1fpgopqrstpzzp{p{{|}~000000
ppp ЁЂpЃpІІЇЈЉpЊpЊЊЋЌp ]DECIMAL Decimal Indicator џџџџ Г1fpgqrstuvpzzp{p{{|}~000000
p pЁpЁЁЂЃЄpЅpЊЊЋЌpЎpЎЎЏАpБ Б^THOUSANDS Thousands Indicator џџџџ Ї1fpgpqrstupvvpwpwwxy z|0}0~0000ppppp ЁpЂpЂЂЃЄpЅ Ѕ_CURRENCY Currency Symbol џџџџ Ћ1fpgnopqrspvvpwpyyz{|}0~00000pppp pЂЂЃЄЅpІpІІЇЈpЉ Љ`COPIES 1 Number of Copies џџџџ З1fpgqrstuvpzzp{p 000000p ЁЂЃЄЅІpЇpЇЇЈЉЊpЋpЎЎЏАБpВpВВГДpЕ ЕaDESFORMAT dflt Destination Format Эџџџџ Џ1fpgopqrstpzzp{p{{|} ~00000
0ppp ЁЂpЃpІІЇЈЉpЊpЊЊЋЌp bDESNAME Destination Name џџџџ З1fpgopqrstpzzp{p
000000p ЁЂЃЄpЅpЅЅІЇЈpЉpЎЎЏАБpВpВВГДpЕ ЕcDESTYPE Screen P Destination Type nџџџџ М1 fphmnopqrpvvpwpwwxyz{0|0}0~000p
ppЁЈЉЊЋpЌpЎЎЏАБpВpЗЗИЙpК КZDEPT
select deptno from dept deptno DEPT џџџџ о1 fph ppp000000p(ЂІЇ ЈЊЋЌppЎЏАpБpЖЖЗИЙpКpййклpм мkTO_CHAR_empno_RPAD_ename_10_RP h ll de c! t d ' DEPT TO_CHAR_EMPNO_RPAD_ENAME_10_RP ERPFORM"" | ! " џџ $ ЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭ 8 Q "AFTERPFORM"BOOLEAN"TRUE"" 6
% ) * . 0 4 7 ; = A C O h , Д Е Z e З Є Б O
џ
џџ d , plsql_compiler_flags"nls_length_semantics" INTERPRETED,DEBUG"BYTE" ЋЭЋЭЋЭЋЭЋЭЋЭЋЭЋЭ H ics" % hg !x h џџџџ
N AFTERPFORM d @ @ 00џџџџ U0000Ј SA Afunction AfterPForm return boolean is
begin
return (TRUE);
end;* ,џџџџ 0800Ј Ж џџџџ Й0808Ј З Ё Ёfunction AfterReport return boolean is
begin
G$_REPORT_SECURITY.G$_REPORT_REVOKE_ACCESS;
return (TRUE);
exception
when others then
return (FALSE);
end;
00џџџџ 0000Ј
v v
SELECT TO_CHAR(empno) || RPAD(ename, 10) || RPAD(job, 9) || TO_CHAR(deptno) from emp where deptno = :dept
,џџџџ 6JRZc(f jnрs(z~р((((ppppp н SQL*ReportWriter REPORT EKU gxjfile о EKUxf
EKUxi
Є ! 5 @ 0р п 00r25g100b100 @ џџџџc_џџџџ 208x * , . 0џџ р 00r50g100b100 џџџџ џџџџ 208x * , . 0 с 00r75g100b100 Р џџџџ00џџџџ 208x * , . 08 т 00r88g100b100 р џџџџ5g75b100Р Р џџР џџ( В TIV/
џџ 8000Ј Ў