Running a Concurrent from PLSQL in oracle apps


DECLARE
v_request_id NUMBER;
ln_temp number;
BEGIN

apps.fnd_global.apps_initialize ( user_id => 0, resp_id => 50007, resp_appl_id => 201 );
——–CALLING STANDARD RECEIVING TRANSACTION PROCESSOR ———————————
select apps.rcv_interface_groups_s.nextval into ln_temp from dual;

v_request_id := apps.fnd_request.submit_request ( application => ‘PO’,
PROGRAM => ‘RVCTP’,
argument1 => ‘BATCH’,
argument2 => ln_temp
— argument3 => 204
);
commit;
dbms_output.put_line(‘Request Id’||v_request_id);
END;

About pacesettergraam

A good and realistic person

Posted on October 19, 2014, in Uncategorized. Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: