Search This Blog

Sunday, September 2, 2012

FND_SUBMIT: Request Set Submission



The code snippet  below can be used as the skeleton for the program that submits a request set in Oracle EBS

/* To submit a Request set which is having STAGE1 and STAGE2. STAGE1 is having 'FNDSCARU' and 'FNDPRNEV' programs. STAGE2 is having 'FNDSCURS'. */
/* set the context for the request set FNDRSTEST */
success := fnd_submit.set_request_set('FND', 'FNDRSTEST');
if ( success ) then
/* submit program FNDSCARU which is in stage STAGE1 */
success := fnd_submit.submit_program('FND','FNDSCARU', 'STAGE1', CHR(0),'','','','','','','','','', ...arguments...);
if ( not success ) then
raise submit_failed;
end if;
/* submit program FNDPRNEV which is in stage STAGE1 */
success := fnd_submit.submit_program('FND','FNDPRNEV', 'STAGE1','','','','','','','','','','', CHR(0),'','','','','','','','','', ...arguments...);
if ( not success ) then
raise submit_failed;
end if;
/* submit program FNDSCURS which is in stage STAGE2 */
success := fnd_submit.submit_program('FND','FNDSCURS', 'STAGE2', CHR(0),'','','','','','','','','', ...arguments...);
if ( not success ) then
raise submit_failed;
end if; /* Submit the Request Set */
req_id := fnd_submit.submit_set(null,FALSE);
end if;
For details about these request set submission API, visit...
http://egeapp.egeseramik.com:8000/pls/prod/fndgfm/fnd_help.get/US/fnd/@fndsubm

No comments:

Post a Comment