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;
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
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.
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
How can we generate report output in excel format?
in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory
Explain master-detail relationship with some examples.
What is the difference between flex mode and confined mode?
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
Explain the different levels at which oracle form services interact.
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
What do you understand by lov and how can it be used?
i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame
did u received a single file or multiple files
Name the different triggers supported by oracle reports and their firing order.
what is difference between group above and group left report
what is a package n what r the packages availbla in report