Answer Posted / gaurav singh
PROCEDURE call_rep IS
BEGIN
declare
pi_id paramlist;
oth varchar2(30);
N_COPIES varchar2(5);
F_N VARCHAR2(30);
COD varchar(30);
typ VARCHAR2(1);
comp_code varchar2(2);
supplier_code number(6);
STORE_VAR VARCHAR2(50);
alrt_var number;
vc_reportserverjob varchar2(100);
report_job_id varchar2(100);
repid report_object;
v_rep_status varchar2(100);
begin
--------------------------------------
repid:=find_report_object('RP2RRO');
proc_path('path of ur rdf',store_var);
store_var:=store_var||rdf name';
set_report_object_property
(repid,report_filename,store_var);
set_report_object_property
(repid,report_server,:global.r_server);
set_report_object_property
(repid,report_execution_mode,runtime);
set_report_object_property
(repid,report_comm_mode,synchronous);
set_report_object_property
(repid,report_destype,cache);
set_report_object_property
(repid,report_desformat,:GLOBAL.dsfmt);
----------------------------------------------------
------
pi_id := get_parameter_list('it_param');
if not Id_null(pi_id) then
destroy_parameter_list(pi_id);
end if;
pi_id := create_parameter_list('it_param');
add_parameter(pi_id,'order_no',TEXT_PARAMETER,COD);
add_parameter
(pi_id,'order_date',TEXT_PARAMETER,to_char
add_parameter(pi_id,'comp_code',TEXT_PARAMETER,comp_code);
add_parameter
(pi_id,'supplier_code',TEXT_PARAMETER,supplier_code);
add_parameter
(pi_id,'PARAMFORM',TEXT_PARAMETER,'NO');
vc_reportserverjob := RUN_REPORT_OBJECT
(repid,pi_id);
report_job_id:=substr
(vc_reportserverjob,length(:global.r_server)+2,length
(vc_reportserverjob));
v_rep_status:=report_object_status
(vc_reportserverjob);
if v_rep_status='FINISHED' then
web.show_document
('http://'||:global.host||':'||:global.port||'/reports/rwser
vlet/getjobid'|| report_job_id||'?
server='||:global.r_server,'_blank');
else
message ('error when running report'||v_rep_status);
end if;
go_item('dt_pur_order.nu_price');
show_view('cg$page_1');
end;
END;
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Name the different triggers associated with oracle forms having a master-detail relationship.
What is a canvas in oracle forms?
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
can you convert or reverse engineer a fmx back to a fmb file?
what is tripstop report?
hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
Explain the various types of oracle report?
Explain master-detail relationship with some examples.
how report can be generated if we have the database designed in oracle 10g?
What are the various configuration files that are used by oracle forms?
How to create Drill down report?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
what exactly u write in when_new_form_instance
what are bind variables?