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 is difference between group above and group left report

3871

---

Explain how one can iterate through items and records in a specified block?

1217

---

difference between global n context sensitive segments?

2728

---

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

1073

---

How can we generate report output in excel format?

1036

---

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

1362

---

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

2292

---

What do you understand by oracle forms?

1113

---

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2061

---

Explain the various types of oracle report?

1132

---

Explain master-detail relationship with some examples.

1052

---

What is an oracle report?

1120

---

What is a canvas in oracle forms?

1113

---

HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1500

---

from where do u receive the information to develop report

2050

---