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;

In what sequence do triggers get fired by oracle forms?

938

---

How can we expand Parameter Form Canvas on Reports 6i?

2402

---

What is an oracle report?

1028

---

how report can be generated if we have the database designed in oracle 10g?

1865

---

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

2267

---

What do we mean by record group in oracle forms?

1052

---

did u received a single file or multiple files

2002

---

Explain the different levels at which oracle form services interact.

1030

---

how do u compile a form i.e .fmb file in Unix or in dos

4557

---

How to create Drill down report?

2109

---

What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

4599

---

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1875

---

What do you understand by oracle forms and why are they required?

988

---

how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

1956

---

What are the various configuration files that are used by oracle forms?

1014

---