Connecting Tech Pros Worldwide Help | Site Map

Concurrent request from procedure

Familiar Sight
 
Join Date: Jun 2007
Posts: 151
#1: Mar 18 '09
Hi all,

I have a stored procedure registered with the following details

short name: delegateproc
executable: delegateproc

attached to application developer request group.

and i am calling this in plsql:

decalre
v_req_id number;
begin

v_req_id :=FND_REQUEST.SUBMIT_REQUEST('FND','DELEGATEPROC', NULL,SYSDATE,'FALSE','','','','','','',.... UPTO 100 PARAMETERS);

commit;

end;


Is this correct syntax. Is FND the short name for Application Object Library?
debasisdas's Avatar
Moderator
 
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,500
#2: Mar 18 '09

re: Concurrent request from procedure


what exactly are you doing in the procedure by passing over 100 parameters.
Familiar Sight
 
Join Date: Jun 2007
Posts: 151
#3: Mar 19 '09

re: Concurrent request from procedure


I am running the concurrent program(DELEGATEPROC) from backend. I hope the synatx for fnd_requests.submit_requests has 100 parameters.
amitpatel66's Avatar
Moderator
 
Join Date: Mar 2007
Location: Hyderabad, India
Posts: 2,192
#4: Mar 19 '09

re: Concurrent request from procedure


Yes the FND_REQUEST.SUBMIT_REQUEST API takes in 100 parameters. Just say NULL to those for which you DO NOT pass any value.

You can check the short name for the application in which you have registered your concurrent program from the window Application Developer Responsibility -> Application
Familiar Sight
 
Join Date: Jun 2007
Posts: 151
#5: Mar 19 '09

re: Concurrent request from procedure


Thanks a lot !

It worked for me and the short name for Application Object Library is FND
Reply


Similar Oracle Database bytes