1-How to run report from form in form9iDS
2-From which site I can get max oracle pdf books
3-how to learn oracle apps(finacial) on cheap cast
How to run report from form in form9iDS
-
- Posts: 1
- Joined: Fri May 19, 2006 8:01 am
- Location: Kenya
- Contact:
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
by using web.show_document we are bound to put all parameter in address
Look @ code
DECLARE
report_para_list paramlist;
vc_url varchar2(1000);
BEGIN
IF :FDATE IS NULL THEN
SET_ALERT('Enter Value in From Date Field..','Alert');
GO_ITEM('FDATE');
RAISE FORM_TRIGGER_FAILURE;
END IF;
IF :TDATE IS NULL THEN
SET_ALERT('Enter Value in To Date Field..','Alert');
GO_ITEM('TDATE');
RAISE FORM_TRIGGER_FAILURE;
END IF;
IF ARTY IS NULL THEN
SET_ALERT('Enter Value in Party Name Field..','Alert');
GO_ITEM('PARTY');
RAISE FORM_TRIGGER_FAILURE;
END IF;
-----Look @ this Vc_url
vc_url:='http://lgs:8888/reports/rwservlet?serve ... RAMFORM=NO';
-----Look @ this Vc_url
WEB.SHOW_DOCUMENT(vc_url,'_blank');
NEW_FORM('CB_MAINFORM');
/* This is Forms 6i Code
report_para_list := Create_Parameter_list('TEMP');
Add_Parameter(report_para_list,'FDATE',Text_Parameter,TO_CHAR(TO_DATE(:FDATE,'DD-MON-YYYY'),'DDMMYYYY'));
Add_Parameter(report_para_list,'TDATE',Text_Parameter,TO_CHAR(TO_DATE(:TDATE,'DD-MON-YYYY'),'DDMMYYYY'));
Add_Parameter(report_para_list,'PARTY',Text_Parameter,:IID);
Add_Parameter(report_para_list, 'PARAMFORM', TEXT_PARAMETER, 'NO');
Run_Product(Reports,'HAWALA_PARTY_WISE',SYNCHRONOUS,RUNTIME,FILESYSTEM,report_para_list,NULL);
Destroy_Parameter_List(report_para_list);
NEW_FORM('CB_MAINFORM');
This is Forms 6i Code
*/
END;
How can i do more secure the report(adress not shown in address bar)
Look @ code
DECLARE
report_para_list paramlist;
vc_url varchar2(1000);
BEGIN
IF :FDATE IS NULL THEN
SET_ALERT('Enter Value in From Date Field..','Alert');
GO_ITEM('FDATE');
RAISE FORM_TRIGGER_FAILURE;
END IF;
IF :TDATE IS NULL THEN
SET_ALERT('Enter Value in To Date Field..','Alert');
GO_ITEM('TDATE');
RAISE FORM_TRIGGER_FAILURE;
END IF;
IF ARTY IS NULL THEN
SET_ALERT('Enter Value in Party Name Field..','Alert');
GO_ITEM('PARTY');
RAISE FORM_TRIGGER_FAILURE;
END IF;
-----Look @ this Vc_url
vc_url:='http://lgs:8888/reports/rwservlet?serve ... RAMFORM=NO';
-----Look @ this Vc_url
WEB.SHOW_DOCUMENT(vc_url,'_blank');
NEW_FORM('CB_MAINFORM');
/* This is Forms 6i Code
report_para_list := Create_Parameter_list('TEMP');
Add_Parameter(report_para_list,'FDATE',Text_Parameter,TO_CHAR(TO_DATE(:FDATE,'DD-MON-YYYY'),'DDMMYYYY'));
Add_Parameter(report_para_list,'TDATE',Text_Parameter,TO_CHAR(TO_DATE(:TDATE,'DD-MON-YYYY'),'DDMMYYYY'));
Add_Parameter(report_para_list,'PARTY',Text_Parameter,:IID);
Add_Parameter(report_para_list, 'PARAMFORM', TEXT_PARAMETER, 'NO');
Run_Product(Reports,'HAWALA_PARTY_WISE',SYNCHRONOUS,RUNTIME,FILESYSTEM,report_para_list,NULL);
Destroy_Parameter_List(report_para_list);
NEW_FORM('CB_MAINFORM');
This is Forms 6i Code
*/
END;
How can i do more secure the report(adress not shown in address bar)
Who is online
Users browsing this forum: No registered users and 7 guests