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;
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what are the new features introduced in oracle form services in 11g release 2?
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
What are the various configuration files that are used by oracle forms?
What is a matrix report and how many minimum groups are required to prepare the same?
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
What is a canvas in oracle forms?
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
difference between global n context sensitive segments?
Explain the different levels at which oracle form services interact.
what is a package n what r the packages availbla in report
Explain how one can iterate through items and records in a specified block?
did u received a single file or multiple files
i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output
What do you understand by lov and how can it be used?