SELECT DISTINCT fr.responsibility_id, frx.application_id
INTO l_responsibility_id, l_application_id
FROM apps.fnd_responsibility frx, apps.fnd_responsibility_tl fr
WHERE fr.responsibility_id = frx.responsibility_id
AND LOWER (fr.responsibility_name) LIKE LOWER ('XXTest Resp');
WHERE user_name = 'DAYAKAR';
--To set environment context.
--Submitting Concurrent Request
fnd_request.submit_request (application => 'XXCUST',
program => 'XXEMP',
description => 'XXTest Employee Details',
start_time => SYSDATE,
sub_request => FALSE,
argument1 => 'Smith'
IF l_request_id = 0
DBMS_OUTPUT.put_line ('Concurrent request
failed to submit');
Submitted the Concurrent Request');
DBMS_OUTPUT.put_line ( 'Error While Submitting
Concurrent Request '
|| TO_CHAR (SQLCODE)