DECLARE
CURSOR c1_cur IS SELECT u.user_name
u.user_id u.end_date u.start_date u.description
FROM fnd_user u
WHERE u.user_name = ('JAI')--Existing User
AND (u.end_date IS NULL OR u.end_date = TO_DATE('31-dec-4712' 'dd-mon-yyyy'))
ORDER BY u.user_name;
BEGIN
FOR c1 IN c1_cur LOOP
BEGIN
fnd_user_pkg.addresp(username => c1.user_name --varchar2
resp_app => 'SYSADMIN' --varchar2
resp_key => 'SYSTEM_ADMINISTRATOR' --varchar2
security_group => 'STANDARD' --varchar2
description => c1.description --varchar2
start_date => sysdate --date
end_date => c1.end_date --date
);
dbms_output.put_line('Inserted '||c1.user_name);
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line('ERROR '||c1.user_name|| SQLERRM);
END;
END LOOP;
COMMIT;
END;
/
CURSOR c1_cur IS SELECT u.user_name
u.user_id u.end_date u.start_date u.description
FROM fnd_user u
WHERE u.user_name = ('JAI')--Existing User
AND (u.end_date IS NULL OR u.end_date = TO_DATE('31-dec-4712' 'dd-mon-yyyy'))
ORDER BY u.user_name;
BEGIN
FOR c1 IN c1_cur LOOP
BEGIN
fnd_user_pkg.addresp(username => c1.user_name --varchar2
resp_app => 'SYSADMIN' --varchar2
resp_key => 'SYSTEM_ADMINISTRATOR' --varchar2
security_group => 'STANDARD' --varchar2
description => c1.description --varchar2
start_date => sysdate --date
end_date => c1.end_date --date
);
dbms_output.put_line('Inserted '||c1.user_name);
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line('ERROR '||c1.user_name|| SQLERRM);
END;
END LOOP;
COMMIT;
END;
/
No comments:
Post a Comment