Submitting concurrent program through trigger
I am trying to submit a concurrent program through trigger, but it's not getting submitted.
Below is my code:
create or replace trigger xx_notification
AFTER UPDATE OF STATUS_CODE on APPS.fnd_concurrent_requests
for EACH ROW
when (new.concurrent_program_id = 168366)
declare
v_request_id NUMBER := 0;
result BOOLEAN;
Begin
result := fnd_request.set_mode(TRUE);
fnd_profile.put('RESP_ID', 20420);
fnd_profile.put('RESP_APPL_ID', 1);
fnd_profile.put('USER_ID', 0);
--fnd_global.apps_initialize(fnd_global.user_id, fnd_global.resp_id, fnd_global.resp_appl_id);
v_request_id := fnd_request.submit_request(application => 'XX___',