Use the following API to add responsibility to a user from backend.
set serveroutput on
DECLARE
p_user_name VARCHAR2(50) := '&Enter_UserName';
p_resp_name VARCHAR2(50) := '&Enter_ResponsibilityName';
p_user_id NUMBER(10) := 0;
p_responsibility_id NUMBER(10) := 0;
p_application_id NUMBER(10) := 0;
BEGIN
BEGIN
SELECT USER_ID
INTO p_user_id
FROM FND_USER
WHERE UPPER(USER_NAME) = UPPER(p_user_name);
EXCEPTION
WHEN NO_DATA_FOUND THEN
dbms_output.put_line('User not found');
raise;
WHEN OTHERS THEN
dbms_output.put_line('Error finding User.');
raise;
END;
BEGIN
SELECT application_id, responsibility_id
INTO p_application_id, p_responsibility_id
FROM FND_RESPONSIBILITY_TL
WHERE UPPER(RESPONSIBILITY_NAME) LIKE UPPER(p_resp_name);
EXCEPTION
WHEN NO_DATA_FOUND THEN
dbms_output.put_line('Responsibility not found.');
raise;
WHEN TOO_MANY_ROWS
dbms_output.put_line('More than one responsibility found with this name.');
raise;
WHEN OTHERS THEN
dbms_output.put_line('Error finding responsibility.');
raise;
END;
BEGIN
fnd_user_resp_groups_api.insert_assignment(user_id => p_user_id
,responsibility_id => p_responsibility_id
,responsibility_application_id => p_application_id
,security_group_id => 0
,start_date => SYSDATE - 1
,end_date => NULL
,description => 'Loaded from Backend.');
commit;
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line('Error calling the API');
raise;
END;
END;
Hope this helps.
|
| |
| Network Rail | Extn: 085 50379 |
