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 do you understand by lov?

992

---

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.

2184

---

What is the difference between bind and lexical parameter?

1022

---

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

1031

---

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

2248

---

What is an oracle report?

999

---

what is difference between group above and group left report

3767

---

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

2074

---

how to send file attachment from oracle forms

2502

---

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

4523

---

why the Ctl file u put only in bin folder why not in other folder

2007

---

what is a package n what r the packages availbla in report

2043

---

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

987

---

Explain the various types of oracle report?

1026

---

In what sequence do triggers get fired by oracle forms?

920

---