PROCEDURE Fpr_Print_Advice(s_fbflag varchar2,s_advnum varchar2) IS
s_parlst paramlist;
s_repnam varchar2(100);
Begin
If s_fbflag = 'FO' Then
:global.program_name := 'strfoadv.rdf';
ElsIf s_fbflag = 'BO' Then
:global.program_name := 'strboadv.rdf';
Else
Base_Message_Box('Not a valid Front Office / Back Office Flag');
Raise Form_Trigger_Failure;
End If;
s_parlst := Get_Parameter_List('s_pardat');
IF Id_Null(s_parlst) THEN
s_parlst := Create_Parameter_List('s_pardat');
Else
Destroy_Parameter_List('s_pardat');
s_parlst := Create_Parameter_List('s_pardat');
End if;
Add_Parameter(s_parlst,'P0',TEXT_PARAMETER,:crq1.brancd);
Add_Parameter(s_parlst,'P1',TEXT_PARAMETER,s_advnum);
--s_repnam := 'c:\syed\':global.program_name;
s_repnam := :global.sypthdir:global.program_name;
Add_parameter(s_parlst,'PARAMFORM',TEXT_PARAMETER,'NO');
Add_Parameter(s_parlst,'DESTYPE',TEXT_PARAMETER,'SCREEN');
Run_Product(Reports,s_repnam,Synchronous,Runtime,Filesystem,s_parlst,NULL);
End;
Halim, a Georgia Tech graduate Senior Database Engineer/Data Architect based in Atlanta, USA, is an Oracle OCP DBA and Developer, Certified Cloud Architect Professional, and OCI Autonomous Database Specialist. With extensive expertise in database design, configuration, tuning, capacity planning, RAC, DG, scripting, Python, APEX, and PL/SQL, he combines technical mastery with a passion for innovation. Notably, Halim secured 16th place worldwide in PL/SQL Challenge Cup Playoff on the year 2010.
Monday, September 28, 2009
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
-
ASSM states3 weeks ago
-
UKOUG Discover 20241 month ago
-
-
-
-
-
-
-
-
Moving Sideways8 years ago
-
-
Upcoming Events...11 years ago
-
No comments:
Post a Comment