Date: Thu, 09 Sep 1999 11:02:04 -0400
From: Mohan Thanikanti mthanika@camail2.harvard.edu
To: oraapps-l@cpa.qc.ca
Subject: RE: AP URGENT-Scheduled Report Date
Message-ID: 4.1.19990909103444.00963a10@camail2.harvard.edu

Hi,

Actually you can find about the Fnd_submit in   Oracle Applications
Standard Manual.

Incase you did not find the manual....

1. First find out the Parameters the report takes.
2.  The  arguments for the function   FND_REQUEST.SUBMIT_REQUEST  are
                  ( application,
                     program,
                      description,
                       start_time,
                      submit_request,
                      argument1,
argument2,
,..

argument100).

For example  for  Posting program

         V_req_id := apps.fnd_request.submit_request(
                                                                    'SQLGL',

'GLPPOS',
                                                                    '',
                                                                    '',
                                                                    FALSE,

to_char(v_set_of_books_id),

to_char(V_chart_of_accounts_id),

to_char(V_posting_run_id),

chr(0),'','','','',
                                                                     '',
'', '', '', '', '', '', '', '', '',
                                                                     '',
'', '', '', '', '', '', '', '', '',
                                                                     '',
'', '', '', '', '', '', '', '', '',
                                                                     '',
'', '', '', '', '', '', '', '', '',
                                                                     '',
'', '', '', '', '', '', '', '', '',
                                                                     '',
'', '', '', '', '', '', '', '', '',
                                                                     '',
'', '', '', '', '', '', '', '', '',
                                                                     '',
'', '', '', '', '', '', '', '', '',
                                                                     '',
'', '', '', '', '', '', '', '', '',
                                                                     '',
'');

You need not worry about the description,start_time  and  you need not give
any null values for  other arguments also  i.e.

even the following    statement  works.
         V_req_id := apps.fnd_request.submit_request(
                                                                    'SQLGL',

'GLPPOS',
                                                                    '',
                                                                    '',
                                                                    FALSE,

to_char(v_set_of_books_id),

to_char(V_chart_of_accounts_id),

to_char(V_posting_run_id),
                                                                    chr(0));

The output of this function is the Request Id.

Hope this helps.

MOHAN