satish

• Mar 9th, 2006

 

fnd_request.submit_request(parameters) by using this we can submit the concurrent program thru pl/sql.

Visitor

• Apr 12th, 2006

 

May need to include a line before this for Apps initialization:

FND_GLOBAL.APPS_INITIALIZE (user_id,resp_id, resp_appl_id)

amit.aticool@gmail.com

 Profile Answers by amit.aticool@gmail.com 

• Apr 14th, 2006

 

through the help of the PL /QCl  Coding

Vijayveer Singh

• May 24th, 2006

 

The below procedure will submit the request from the back end where

application is Short name of application under which the program is registered.

program is concurrent program name for which the request has to be submitted

declare
 conc_id number(10);

begin
 FND_GLOBAL.APPS_INITIALIZE (user_id,resp_id, resp_appl_id);
 conc_id:=submit_request('application','program');
 dbms_output.put_line(conc_id);
end;

The above program will print the Concurrent request ID.

arun

• Jul 25th, 2006

 

How to pass the parameters required by the concurrent process which we trigger thru PL/SQL

Adi_phaniK

 Profile Answers by Adi_phaniK 

• Oct 2nd, 2009

 

If you want to run a concurrent request in application through PL/SQL code, then you can used an inbuilt funtion in Apps.

Fnd_request.submit_Request

Junaid Usman

• Aug 4th, 2011

 

{geshibot language="oracle8"}---- Junaid Usman (JBS)
DECLARE
l_request_id NUMBER(30);
begin
FND_GLOBAL.APPS_INITIALIZE(user_id => 7938,
resp_id => 52342,
resp_appl_id => 660);
l_request_id := FND_REQUEST.SUBMIT_REQUEST(
application =>'ONT',
program =>'test_report2',
description => 'Concurrent Test Report2',
start_time => SYSDATE
);
DBMS_OUTPUT.PUT_LINE(l_request_id);
commit;
end;
{/geshibot}