Submitting Concurrent Program from backend

Apps Initialization :

begin
fnd_global.apps_initialize ( 25665 –>USER_ID<
, 51201–>RESP_ID<
,665–>RESP_APPL_ID<
);
end;

Submit Program:

declare
ln_request_id number ;
begin

ln_request_id :=
fnd_request.submit_request ('FND',                -- application
'COCN_PGM_SHORT_NAME',-- program short name
'',                   -- description
'',                   -- start time
FALSE,                -- sub request
'Argument1',          -- argument1
'Argument2',          -- argument2
'N',                  -- argument3
NULL,                 -- argument4
NULL,                 -- argument5
'Argument6',          -- argument6
CHR (0)               -- represents end of arguments
);

commit;
dbms_output.put_line (‘Concurrent reques_id : ‘|| ln_request_id ||sqlerrm);
IF ln_request_id = 0
THEN
dbms_output.put_line (‘Concurrent request failed to submit’);
END IF;
end ;

Advertisements

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