Answer Posted / fatima hussain

DECLARE
PL_ID PARAMLIST;
PL_NAME VARCHAR2(100) := 'PL_ACCCODE';
BEGIN

PL_ID := GET_PARAMETER_LIST(PL_NAME);
IF NOT ID_NULL(PL_ID) THEN
DESTROY_PARAMETER_LIST(PL_ID);
END IF;

PL_ID := CREATE_PARAMETER_LIST(PL_NAME);

(Add more parameter according to your need and also use the
additional line of code according to to your need)

ADD_PARAMETER(PL_ID, 'P_DATE1',
TEXT_PARAMETER, :CON_BLK.DATE1);
ADD_PARAMETER(PL_ID, 'P_DATE2',
TEXT_PARAMETER, :CON_BLK.DATE2);

ADD_PARAMETER(PL_ID, 'PARAMFORM', TEXT_PARAMETER,'NO');
RUN_PRODUCT(REPORTS, 'Report_Name.rdf',
SYNCHRONOUS,RUNTIME,FILESYSTEM, PL_ID);

END;

where do u put the report file

2045

---

how do u place it in required folder

1870

---

all steps of bitmap report?

2303

---

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1234

---

What is responsibility and how u attach How to create user and how u attach with responsibility.

1991

---

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

1843

---

i am writing a query select EmpNo from Emp how can i call in after parameter form

2051

---

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

2068

---

In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

1854

---

How to create Drill down report?

2078

---

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

982

---

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

966

---

Explain how can you use the same lov for 2 columns?

1080

---

What do you understand by lov and how can it be used?

1014

---

what exactly u write in when_new_form_instance

3383

---