Answer Posted / sonal

DECLARE
pl_id PARAMLIST;

BEGIN
pl_id := CREATE_PARAMETER_LIST('quotation');
IF NOT ID_NULL(pl_id) THEN
Add_parameter(pl_id,'DESTYPE',TEXT_PARAMETER, :DESTYPE);
ADD_PARAMETER(pl_id,'DESFORMAT',TEXT_PARAMETER,:DESFORMAT);
ADD_PARAMETER(pl_id,'DESNAME',TEXT_PARAMETER,:DESNAME);
Add_parameter(pl_id,'MODE',TEXT_PARAMETER, 'BITMAP');
Add_parameter
(pl_id,'untcd',TEXT_PARAMETER,:GLOBAL.G_STRUNITCODE);
Add_parameter
(pl_id,'FYCD',TEXT_PARAMETER,:GLOBAL.G_STRFINYEARCODE);
Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');

IF :id is not nullTHEN
Run_Product
(REPORTS,PLANDETAIL.rep',SYNCHRONOUS,RUNTIME,FILESYSTEM,
pl_id, NULL);
DESTROY_PARAMETER_LIST(pl_id);
END IF;
end if;
end;

what are bind variables?

802

---

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1889

---

List out the oracle forms configuration files?

799

---

In what sequence do triggers get fired by oracle forms?

723

---

what are the new features introduced in oracle form services in 11g release 2?

795

---

what is oracle forms?

857

---

if u want to delete all these detail block etc what will happen in form

1726

---

Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

1901

---

if some data is not transfered where it will get stored

1678

---

what are the oracle forms services components include?

751

---

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...

1913

---

What do we mean by record group in oracle forms?

818

---

I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

2632

---

what is the difference between call_form, new_form and open_form?

948

---

Name the different triggers associated with oracle forms having a master-detail relationship.

699

---