DECLARE
l_user_id
NUMBER;
l_resp_id
NUMBER;
l_app_id
NUMBER;
CURSOR C1
IS
SELECT user_id
FROM fnd_user
WHERE user_name IN
('ALOK_TIWARI',
'ABHISH_CHIKKAVEERAIAH',
'ANASURYA_K',
'ARATI_SWAIN',
'ASHA_KM',
'ASHOK_BODEMPUDI',
'ASHWINI_SC',
'CATHERINE_CHARLES',
'DEEPA_SRINIVASAN',
'DEEPAK_ANAND',
'GATTU_SAILAKSHMI',
'GAURAV_NAYAK',
'GOPIKRISHNA_DASARI',
'KEERTHI_YERRAMSETTI',
'LAVANYA_SETHOLA',
'LOKESH_KUMAR',
'MADHAVA_VEMURI',
'MADHUSOODANA_SUBBANNA',
'MAHADEVAIAH_KEMPASHETTY',
'MAHALAKSHMI_KHANNA',
'MAHESWAR_ALAVALAPATI',
'MURALI_JEGATHEESE',
'NITHYA_DA',
'NITISH_ANAND',
'PAVAN_NAGARAJAMURTHY',
'PREETI_WALI',
'RAJAN_KESHRI',
'RAVI_PATEL',
'RENUKA_PATIL',
'SAHITHI_BUDITHI',
'SANDHYA_RAMAIAH',
'SANTOSHI_ANNARAO',
'SHRUTHI_R',
'SHUBHAM_DHOLU',
'SHWETA_MADGUNI',
'SIRISHA_KM',
'SIVAKUMAR_CHANDRAIAH',
'SPOORTHI_G',
'TEEKACHAR_SOSALE',
'BHAVANI_VANTARI',
'VISHWANATH_HEGNE',
'WASEEM_KHAN');
BEGIN
SELECT responsibility_id, application_id
INTO l_resp_id,
l_app_id
FROM fnd_responsibility
WHERE responsibility_key = 'EMR_IT_SUPPORT';
FOR I IN C1
LOOP
fnd_user_resp_groups_api.insert_assignment (
user_id => I.user_id,
responsibility_id => l_resp_id,
responsibility_application_id => l_app_id,
security_group_id => NULL,
start_date => SYSDATE,
end_date => NULL,
description => NULL);
COMMIT;
END LOOP;
EXCEPTION
WHEN OTHERS
THEN
raise_application_error (
-20001,
'An
error was encountered - ' || SQLCODE || '
-ERROR- ' || SQLERRM);
END;