Wednesday, 29 November 2017

Adding multiple responsibilities to user account

/* Formatted on 2017/11/29 16:15 (Formatter Plus v4.8.8) */
DECLARE
   v_user_name             VARCHAR2 (100) := 'LOKANADHAM_THANDLAM';
   v_responsibility_name   VARCHAR2 (100);
   v_application_name      VARCHAR2 (100);
   v_responsibility_key    VARCHAR2 (100);
   v_security_group        VARCHAR2 (100);  
   v_description           VARCHAR2 (100);

   CURSOR x_cur
   IS
      SELECT fa.application_short_name, fr.responsibility_key
        FROM fnd_responsibility fr,
             fnd_application fa,
             fnd_responsibility_tl frt
       WHERE fr.application_id = fa.application_id
         AND fr.responsibility_id = frt.responsibility_id
         AND frt.LANGUAGE = USERENV ('LANG')
         AND frt.responsibility_name IN
                ('EMR AR Setup with Inquiry NGSO NG',
                 'EMR AR Setup with Inquiry NKG CN',
                 'EMR AR Setup with Inquiry NLSO NL',
                 'EMR AR Setup with Inquiry PIC RMT',
                 'EMR AR Setup with Inquiry PR',
                 'EMR AR Setup with Inquiry PSO PL',
                 'EMR AR Setup with Inquiry PSYS',
                 'EMR AR Setup with Inquiry PTSO PT',
                 'EMR AR Setup with Inquiry PVG CN',
                 'EMR AR Setup with Inquiry PWS',
                 'EMR AR Setup with Inquiry PWS CN',
                 'EMR AR Setup with Inquiry QASO QA',
                 'EMR AR Setup with Inquiry RAS USA',
                 'EMR AR Setup with Inquiry REG',
                 'EMR AR Setup with Inquiry REG CTU CN',
                 'EMR AR Setup with Inquiry REG SH CN',
                 'EMR AR Setup with Inquiry RFM NO',
                 'EMR AR Setup with Inquiry RFM RO',
                 'EMR AR Setup with Inquiry RMT FJR AE',
                 'EMR AR Setup with Inquiry RNI RMT',
                 'EMR AR Setup with Inquiry ROSO RO',
                 'EMR AR Setup with Inquiry ROX NO',
                 'EMR AR Setup with Inquiry RTH NO',
                 'EMR AR Setup with Inquiry SAHUB SA',
                 'EMR AR Setup with Inquiry SDC SG',
                 'EMR AR Setup with Inquiry SEN KR',
                 'EMR AR Setup with Inquiry SKNM SK',
                 'EMR AR Setup with Inquiry SKSO SK',
                 'EMR AR Setup with Inquiry SNG SG',
                 'EMR AR Setup with Inquiry SUB MY',
                 'EMR AR Setup with Inquiry SZ HU',
                 'EMR AR Setup with Inquiry TAR IT',
                 'EMR AR Setup with Inquiry TES',
                 'EMR AR Setup with Inquiry TESCOM DE',
                 'EMR AR Setup with Inquiry UKHQ',
                 'EMR AR Setup with Inquiry USD CN SG',
                 'EMR AR Setup with Inquiry VA HLO NL',
                 'EMR AR Setup with Inquiry VA HU',
                 'EMR AR Setup with Inquiry VA JHB ZA',
                 'EMR AR Setup with Inquiry VA MY',
                 'EMR AR Setup with Inquiry VA SG',
                 'EMR AR Setup with Inquiry VA WCH DE',
                 'EMR AR Setup with Inquiry VA WUQ CN',
                 'EMR AR Setup with Inquiry VLVS MEX',
                 'EMR AR Setup with Inquiry VLVS SG',
                 'EMR AR Setup with Inquiry FCEC IN',
                 'EMR AR Setup with Inquiry FRCL FR',
                 'EMR AR Setup with Inquiry FRSI MNL',
                 'EMR AR Setup with Inquiry FRSO FR',
                 'EMR AR Setup with Inquiry FSO FI',
                 'EMR AR Setup with Inquiry GASO GA',
                 'EMR AR Setup with Inquiry GB MBY',
                 'EMR AR Setup with Inquiry GBHUB GB',
                 'EMR AR Setup with Inquiry GBSO GB',
                 'EMR AR Setup with Inquiry GQSO GQ',
                 'EMR AR Setup with Inquiry HCM VN',
                 'EMR AR Setup with Inquiry HEIC',
                 'EMR AR Setup with Inquiry HRSO HR',
                 'EMR AR Setup with Inquiry HRT DE',
                 'EMR AR Setup with Inquiry HSO HU',
                 'EMR AR Setup with Inquiry IEC',
                 'EMR AR Setup with Inquiry IESO IE',
                 'EMR AR Setup with Inquiry IQSO IQ',
                 'EMR AR Setup with Inquiry ISO IT',
                 'EMR AR Setup with Inquiry ITSO IT',
                 'EMR AR Setup with Inquiry IVS CAN',
                 'EMR AR Setup with Inquiry IVS USA',
                 'EMR AR Setup with Inquiry JUSO SA',
                 'EMR AR Setup with Inquiry KRL DE',
                 'EMR AR Setup with Inquiry KWSO KW',
                 'EMR AR Setup with Inquiry LLLP',
                 'EMR AR Setup with Inquiry LQD USA',
                 'EMR AR Setup with Inquiry LYSO LY',
                 'EMR AR Setup with Inquiry MASO MA',
                 'EMR AR Setup with Inquiry MEL AU',
                 'EMR AR Setup with Inquiry MEX',
                 'EMR AR Setup with Inquiry MHM',
                 'EMR AR Setup with Inquiry MMI USA',
                 'EMR AR Setup with Inquiry MUM IN',
                 'EMR AP Setup with Inquiry FRSO FR',
                 'EMR AP Setup with Inquiry FSA FR',
                 'EMR AP Setup with Inquiry FSO FI',
                 'EMR AP Setup with Inquiry GBHUB GB',
                 'EMR AP Setup with Inquiry GBSO GB',
                 'EMR AP Setup with Inquiry GTMC RMT',
                 'EMR AP Setup with Inquiry HCM VN',
                 'EMR AP Setup with Inquiry HEIC',
                 'EMR AP Setup with Inquiry HRSO HR',
                 'EMR AP Setup with Inquiry HRT DE',
                 'EMR AP Setup with Inquiry HSO HU',
                 'EMR AP Setup with Inquiry HVM',
                 'EMR AP Setup with Inquiry IEC',
                 'EMR AP Setup with Inquiry IESO IE',
                 'EMR AP Setup with Inquiry ISO IT',
                 'EMR AP Setup with Inquiry ITSO IT',
                 'EMR AP Setup with Inquiry IVS CAN',
                 'EMR AP Setup with Inquiry IVS USA',
                 'EMR AP Setup with Inquiry JPSO JP',
                 'EMR AP Setup with Inquiry JUSO SA',
                 'EMR AP Setup with Inquiry KRL DE',
                 'EMR AP Setup with Inquiry LLLP',
                 'EMR AP Setup with Inquiry LQD USA',
                 'EMR AP Setup with Inquiry MEL AU',
                 'EMR AP Setup with Inquiry MEX',
                 'EMR AP Setup with Inquiry MHM',
                 'EMR AP Setup with Inquiry MMI',
                 'EMR AP Setup with Inquiry MUM IN',
                 'EMR AP Setup with Inquiry NKG CN',
                 'EMR AP Setup with Inquiry NLSO NL',
                 'EMR AP Setup with Inquiry NSO NO',
                 'EMR AP Setup with Inquiry PAD USA',
                 'EMR AP Setup with Inquiry PIC RMT',
                 'EMR AP Setup with Inquiry PR',
                 'EMR AP Setup with Inquiry PSO PL',
                 'EMR AP Setup with Inquiry PSOL',
                 'EMR AP Setup with Inquiry PTSO PT',
                 'EMR AP Setup with Inquiry PVG CN',
                 'EMR AP Setup with Inquiry PWS',
                 'EMR AP Setup with Inquiry PWS CN',
                 'EMR AP Setup with Inquiry PWS PL',
                 'EMR AP Setup with Inquiry QASO QA',
                 'EMR AP Setup with Inquiry RAS USA',
                 'EMR AP Setup with Inquiry REG',
                 'EMR AP Setup with Inquiry REG SH CN',
                 'EMR AP Setup with Inquiry RFM NO',
                 'EMR AP Setup with Inquiry RFM RO',
                 'EMR AP Setup with Inquiry RMT',
                 'EMR AP Setup with Inquiry RNI RMT',
                 'EMR AP Setup with Inquiry ROSO RO',
                 'EMR AP Setup with Inquiry ROX NO',
                 'EMR AP Setup with Inquiry RSS NO',
                 'EMR AP Setup with Inquiry RTH NO',
                 'EMR AP Setup with Inquiry SAHUB SA',
                 'EMR AP Setup with Inquiry SDC SG',
                 'EMR AP Setup with Inquiry SEN KR',
                 'EMR AP Setup with Inquiry SESO SE',
                 'EMR AP Setup with Inquiry SKNM SK',
                 'EMR AP Setup with Inquiry SKSO SK',
                 'EMR AP Setup with Inquiry SMMC RMT',
                 'EMR AP Setup with Inquiry SNG SG',
                 'EMR AP Setup with Inquiry SUB MY',
                 'EMR AP Setup with Inquiry SZ HU',
                 'EMR AP Setup with Inquiry TAR IT',
                 'EMR AP Setup with Inquiry TES',
                 'EMR AP Setup with Inquiry TESCOM DE',
                 'EMR AP Setup with Inquiry TF CH MX',
                 'EMR AP Setup with Inquiry UKHQ',
                 'EMR AP Setup with Inquiry USD CN SG',
                 'EMR AP Setup with Inquiry VA HLO NL',
                 'EMR AP Setup with Inquiry VA HU',
                 'EMR AP Setup with Inquiry VA JHB ZA',
                 'EMR AP Setup with Inquiry VA MY',
                 'EMR AP Setup with Inquiry VA PTL GB',
                 'EMR AP Setup with Inquiry VA SG',
                 'EMR AP Setup with Inquiry VA WCH DE',
                 'EMR AP Setup with Inquiry VA WUQ CN',
                 'EMR AP Setup with Inquiry VAD USA',
                 'EMR AP Setup with Inquiry VLVS',
                 'EMR AP Setup with Inquiry WESS RMT',
                 'EMR AP Setup with Inquiry WSL DE',
                 'EMR AP Setups EEEC',
                 'EMR AP Setups PSYS',
                 'EMR AP Setup with Inquiry BAO VLVS CN',
                 'EMR AP Setup with Inquiry BESO BE',
                 'EMR AP Setup with Inquiry BKK TH',
                 'EMR PA Setup with Inquiry FRSO FR',
                 'EMR PA Setup with Inquiry FSA FR',
                 'EMR PA Setup with Inquiry FSO FI',
                 'EMR PA Setup with Inquiry GASO GA',
                 'EMR PA Setup with Inquiry GBHUB GB',
                 'EMR PA Setup with Inquiry GBSO GB',
                 'EMR PA Setup with Inquiry GQSO GQ',
                 'EMR PA Setup with Inquiry HEIC',
                 'EMR PA Setup with Inquiry HRSO HR',
                 'EMR PA Setup with Inquiry HSO HU',
                 'EMR PA Setup with Inquiry HVM',
                 'EMR PA Setup with Inquiry IEC',
                 'EMR PA Setup with Inquiry IESO IE',
                 'EMR PA Setup with Inquiry IQSO IQ',
                 'EMR PA Setup with Inquiry ITSO IT',
                 'EMR PA Setup with Inquiry JPSO JP',
                 'EMR PA Setup with Inquiry JUSO SA',
                 'EMR PA Setup with Inquiry KUSO IQ',
                 'EMR PA Setup with Inquiry KWSO KW',
                 'EMR PA Setup with Inquiry LLLP',
                 'EMR PA Setup with Inquiry LTSO LT',
                 'EMR PA Setup with Inquiry LYSO LY',
                 'EMR PA Setup with Inquiry MASO MA',
                 'EMR PA Setup with Inquiry MEL AU',
                 'EMR PA Setup with Inquiry MEX',
                 'EMR PA Setup with Inquiry MHM',
                 'EMR PA Setup with Inquiry MMI',
                 'EMR PA Setup with Inquiry NGSO NG',
                 'EMR PA Setup with Inquiry NIL VLVS MY',
                 'EMR PA Setup with Inquiry NLSO NL',
                 'EMR PA Setup with Inquiry NSO NO',
                 'EMR PA Setup with Inquiry PE',
                 'EMR PA Setup with Inquiry PIC RMT',
                 'EMR PA Setup with Inquiry PR',
                 'EMR PA Setup with Inquiry PSOPL',
                 'EMR PA Setup with Inquiry PSYS',
                 'EMR PA Setup with Inquiry PVG CN',
                 'EMR PA Setup with Inquiry PWS',
                 'EMR PA Setup with Inquiry PWS CN',
                 'EMR PA Setup with Inquiry PWS PL',
                 'EMR PA Setup with Inquiry QASO QA',
                 'EMR PA Setup with Inquiry RAS USA',
                 'EMR PA Setup with Inquiry REG',
                 'EMR PA Setup with Inquiry REG USA',
                 'EMR PA Setup with Inquiry RFM NO',
                 'EMR PA Setup with Inquiry RMT',
                 'EMR PA Setup with Inquiry RMT FJR AE',
                 'EMR PA Setup with Inquiry RNI RMT',
                 'EMR PA Setup with Inquiry ROSO RO',
                 'EMR PA Setup with Inquiry RSS NO',
                 'EMR PA Setup with Inquiry SEN KR',
                 'EMR PA Setup with Inquiry SESO SE',
                 'EMR PA Setup with Inquiry SGW SG',
                 'EMR PA Setup with Inquiry SKN',
                 'EMR PA Setup with Inquiry SKSO SK',
                 'EMR PA Setup with Inquiry SNG SG',
                 'EMR PA Setup with Inquiry SUB MY',
                 'EMR PA Setup with Inquiry SZ HU',
                 'EMR PA Setup with Inquiry TAR',
                 'EMR PA Setup with Inquiry TF CH MX',
                 'EMR PA Setup with Inquiry TRSO TR',
                 'EMR PA Setup with Inquiry UKHQ',
                 'EMR PA Setup with Inquiry USD CN SG',
                 'EMR PA Setup with Inquiry VA DE',
                 'EMR PA Setup with Inquiry VA NL',
                 'EMR PA Setup with Inquiry VA USA',
                 'EMR PA Setup with Inquiry VLVS CN',
                 'EMR PA Setup with Inquiry VLVS IT',
                 'EMR PA Setup with Inquiry VLVS MEX',
                 'EMR PA Setup with Inquiry VLVS SG',
                 'EMR PA Setup with Inquiry VLVS USA',
                 'EMR PA Setup with Inquiry WUQ VLVS CN',
                 'EMR AP Invoice User RAS USA',
                 'EMR AP Manager BR',
                 'EMR AP Manager MUM IN',
                 'EMR AP Manager PVG CN',
                 'EMR AP Manager RAS USA',
                 'EMR AP Setup with Inquiry AKSO SA',
                 'EMR AP Setup with Inquiry ARG',
                 'EMR AP Setup with Inquiry AUHSO AE',
                 'EMR AP Setup with Inquiry BR',
                 'EMR AP Super User ARG',
                 'EMR APC Admin User RAS',
                 'EMR APC Setup with Inquiry RAS',
                 'EMR APC User RAS',
                 'EMR AR Inquiry TES',
                 'EMR AR Manager RAS USA',
                 'EMR AR Manager TES',
                 'EMR AR Setup with Inquiry ARG',
                 'EMR AR Setup with Inquiry CLUJ3 RO',
                 'EMR AR Setup with Inquiry DESO DE',
                 'EMR ASCP Planner RAF',
                 'EMR ASCP Planner RAW',
                 'EMR Alert Manager',
                 'EMR BOM Admin User RAS',
                 'EMR BOM Manufacturing Engineering RAW',
                 'EMR CSA Level1 RAM',
                 'EMR CSA Level1 RWF',
                 'EMR CSA Level1 RWR',
                 'EMR DFF Segments Administrator',
                 'EMR FA Setup User TF CH MX',
                 'EMR FA Setup with Inquiry TF CH MX',
                 'EMR GDS Supplier Maintenance AKSO SA',
                 'EMR GDS Supplier Maintenance JUSO SA',
                 'EMR GDS Supplier Maintenance QASO QA',
                 'EMR GDS Supplier Maintenance SAHUB SA',
                 'EMR GL Manager AUHSO AE',
                 'EMR GL Manager LQD USA',
                 'EMR GL Manager MEL AU',
                 'EMR GL Manager MUM IN',
                 'EMR GL Manager PR',
                 'EMR GL Manager PVG CN',
                 'EMR GL Open/Close (4-4-5) DMC MEX',
                 'EMR GL Open/Close (Legal SOB) PSO PL',
                 'EMR GL Open/Close (Legal) BR',
                 'EMR GL Open/Close (Legal) DMC MEX',
                 'EMR GL Open/Close CREEC CRC',
                 'EMR GL Open/Close EDE NL',
                 'EMR GL Open/Close PVG CN',
                 'EMR GL Open/Close REG CTU CN',
                 'EMR GL Open/Close REG SH CN',
                 'EMR GL Open/Close STA REG CTU CN',
                 'EMR GL Open/Close STAT AOSO AO',
                 'EMR GL Open/Close STAT GASO GA',
                 'EMR GL Open/Close USD CN SG',
                 'EMR GL Set Up with Inquiry BAO VLVS CN',
                 'EMR GL Setup with Inquiry (4-4-5) DMC MEX',
                 'EMR GL Setup with Inquiry (Legal) BR',
                 'EMR GL Setup with Inquiry (Legal) DMC MEX',
                 'EMR GL Setup with Inquiry (SOB 4-4-5) MEX',
                 'EMR GL Setup with Inquiry (SOB GAAP) CORP MEX',
                 'EMR GL Setup with Inquiry (SOB GAAP) EGS MEX',
                 'EMR GL Setup with Inquiry (SOB Legal) CORP MEX',
                 'EMR GL Setup with Inquiry (SOB Legal) EGS MEX',
                 'EMR GL Setup with Inquiry (SOB Legal) MEX',
                 'EMR GL Setup with Inquiry ACK NZ',
                 'EMR GL Setup with Inquiry ALL FR',
                 'EMR GL Setup with Inquiry AOSO AO',
                 'EMR GL Setup with Inquiry ARG',
                 'EMR GL Setup with Inquiry ASO AT',
                 'EMR GL Setup with Inquiry AUHSO AE',
                 'EMR GL Setup with Inquiry AZSO AZ',
                 'EMR GL Setup with Inquiry BESO BE',
                 'EMR GL Setup with Inquiry BMMC BEJ CN',
                 'EMR GL Setup with Inquiry CHHQ',
                 'EMR GL Setup with Inquiry CHSO CH',
                 'EMR GL Setup with Inquiry CLUJ RO',
                 'EMR GL Setup with Inquiry CLUJ2 RO',
                 'EMR GL Setup with Inquiry CLUJ3 RO',
                 'EMR GL Setup with Inquiry CREEC CRC',
                 'EMR GL Setup with Inquiry CZSO CZ',
                 'EMR GL Setup with Inquiry Corporate SOB VLVS MEX',
                 'EMR GL Setup with Inquiry DESO DE',
                 'EMR GL Setup with Inquiry DKSO DK',
                 'EMR GL Setup with Inquiry DXB HUB AE',
                 'EMR GL Setup with Inquiry EDE NL',
                 'EMR GL Setup with Inquiry EGSO EG',
                 'EMR GL Setup with Inquiry ESSO ES',
                 'EMR GL Setup with Inquiry FRSI MNL',
                 'EMR GL Setup with Inquiry FSO FI',
                 'EMR GL Setup with Inquiry GASO GA',
                 'EMR GL Setup with Inquiry GBHUB GB',
                 'EMR GL Setup with Inquiry GBSO GB',
                 'EMR GL Setup with Inquiry HCM VN',
                 'EMR GL Setup with Inquiry HRSO HR',
                 'EMR GL Setup with Inquiry HRT DE',
                 'EMR GL Setup with Inquiry HSO HU',
                 'EMR GL Setup with Inquiry IESO IE',
                 'EMR GL Setup with Inquiry IQSO IQ',
                 'EMR GL Setup with Inquiry ISO IT',
                 'EMR GL Setup with Inquiry ITSO IT',
                 'EMR GL Setup with Inquiry JPSO JP',
                 'EMR GL Setup with Inquiry JUSO SA',
                 'EMR GL Setup with Inquiry KUSO IQ',
                 'EMR GL Setup with Inquiry KWSO KW',
                 'EMR GL Setup with Inquiry KZSO KZ',
                 'EMR GL Setup with Inquiry LQD USA',
                 'EMR GL Setup with Inquiry LTSO LT',
                 'EMR GL Setup with Inquiry LYSO LY',
                 'EMR GL Setup with Inquiry Legal SOB VLVS MEX',
                 'EMR GL Setup with Inquiry MASO MA',
                 'EMR GL Setup with Inquiry MEL AU',
                 'EMR GL Setup with Inquiry MUM IN',
                 'EMR GL Setup with Inquiry NGSO NG',
                 'EMR GL Setup with Inquiry NLSO NL',
                 'EMR GL Setup with Inquiry NSO NO',
                 'EMR GL Setup with Inquiry PE',
                 'EMR GL Setup with Inquiry PR',
                 'EMR GL Setup with Inquiry PSO PL',
                 'EMR GL Setup with Inquiry PTSO PT',
                 'EMR GL Setup with Inquiry PVG CN',
                 'EMR GL Setup with Inquiry PWS PL',
                 'EMR GL Setup with Inquiry QASO QA',
                 'EMR GL Setup with Inquiry RAS USA',
                 'EMR GL Setup with Inquiry REG',
                 'EMR GL Setup with Inquiry RMT',
                 'EMR GL Setup with Inquiry RNI RMT',
                 'EMR GL Setup with Inquiry ROSO RO',
                 'EMR GL Setup with Inquiry RTH NO',
                 'EMR GL Setup with Inquiry RTR SE',
                 'EMR GL Setup with Inquiry RUSO RU',
                 'EMR GL Setup with Inquiry SESO SE',
                 'EMR GL Setup with Inquiry SKNM SK',
                 'EMR GL Setup with Inquiry SKNM STAT SK',
                 'EMR GL Setup with Inquiry SKSO SK',
                 'EMR GL Setup with Inquiry SKSO STAT SK',
                 'EMR GL Setup with Inquiry SNG SG',
                 'EMR GL Setup with Inquiry STAT AOSO AO',
                 'EMR GL Setup with Inquiry STAT BHSO BH',
                 'EMR GL Setup with Inquiry STAT CGSO CG',
                 'EMR GL Setup with Inquiry STAT CZ',
                 'EMR GL Setup with Inquiry STAT DXB HUB AE',
                 'EMR GL Setup with Inquiry STAT EGSO EG',
                 'EMR GL Setup with Inquiry STAT FR',
                 'EMR GL Setup with Inquiry STAT FRCL',
                 'EMR GL Setup with Inquiry STAT GQSO GQ',
                 'EMR GL Setup with Inquiry STAT KUSO IQ',
                 'EMR GL Setup with Inquiry STAT KWSO KW',
                 'EMR GL Setup with Inquiry STAT LYSO LY',
                 'EMR GL Setup with Inquiry STAT MASO MA',
                 'EMR GL Setup with Inquiry STAT NGSO NG',
                 'EMR GL Setup with Inquiry STAT TAR IT',
                 'EMR GL Setup with Inquiry STAT VLV HUB SA',
                 'EMR GL Setup with Inquiry SZ HU',
                 'EMR GL Setup with Inquiry TAR IT',
                 'EMR GL Setup with Inquiry TRSO TR',
                 'EMR GL Setup with Inquiry UASO UA',
                 'EMR GL Setup with Inquiry USA',
                 'EMR GL Setup with Inquiry VA JHB ZA',
                 'EMR GL Setup with Inquiry VA SG',
                 'EMR GL Setup with Inquiry VLVS SG',
                 'EMR GL Setup with inquiry Consolidation ANZ',
                 'EMR GL Web ADI JPSO JP',
                 'EMR GL Web ADI SNG SG',
                 'EMR Global HR Manager ARG',
                 'EMR Global HR Manager BR',
                 'EMR Global HR Manager MEL AU',
                 'EMR Global HR Manager RAS USA',
                 'EMR INV Admin User RAF',
                 'EMR INV Admin User RAM',
                 'EMR INV Admin User RAW',
                 'EMR INV Admin User RWF',
                 'EMR INV Admin User RWR',
                 'EMR INV Setup with Inquiry DSY',
                 'EMR INV Setup with Inquiry REG',
                 'EMR IT Development',
                 'EMR IT Profile Administrator',
                 'EMR IT Sysadmin',
                 'EMR Internet Expense Auditor ARG',
                 'EMR Internet Expense Auditor BR',
                 'EMR Internet Expense User MUM IN',
                 'EMR Internet Expenses Auditor PVG CN',
                 'EMR ME Closing Dashboard PVG CN',
                 'EMR NOETIX Global Finance User 3LP',
                 'EMR OM Setup with Inquiry NLSO NL',
                 'EMR ONT Order Management LLLP',
                 'EMR ONT Order Management RAS',
                 'EMR ONT Order Management VA',
                 'EMR ONT Setup with Inquiry RAS',
                 'EMR ONT Setup with Inquiry VA HU',
                 'EMR PA Administrator DSK USA',
                 'EMR PA PROJ ADMIN DESO DE',
                 'EMR PA PROJ ADMIN PSYS',
                 'EMR PA PROJ ADMIN RAS USA',
                 'EMR PA PROJ INQUIRY RAS USA',
                 'EMR PA Setup with Inquiry DESO DE',
                 'EMR PA Setup with Inquiry ESSO ES',
                 'EMR PA-GL Open/Close FRSO FR',
                 'EMR PA-GL Open/Close RAS USA',
                 'EMR PO Buyer BR',
                 'EMR PO Buyer MMI',
                 'EMR PO Comprador - Logística ARG',
                 'EMR PO Inquiry BR',
                 'EMR PO Inspection Receiver BR',
                 'EMR PO Receiver RAF',
                 'EMR PO Receiver RAM',
                 'EMR PO Receiver RAW',
                 'EMR PO Receiver SOR BR',
                 'EMR PO Requestor BR',
                 'EMR PO Requestor RAS',
                 'EMR PO Requisiciones / Recepción ARG',
                 'EMR PO Setup with Inquiry BR',
                 'EMR PO Setup with Inquiry MMI',
                 'EMR Planner Purchasing MMI',
                 'EMR User Administrator',
                 'EMR WIP Admin User RAF',
                 'EMR WIP Admin User RAW',
                 'EMR WSH Shipping Administrator  VA HU',
                 'EMR WSH Shipping Administrator RAS',
                 'EMR WSH Shipping Administrator VA',
                 'EMR Web ADI Manager MEL AU',
                 'EMR XX Oracle IT Support Resource',
                 'EMR iExpense Administrator RAS USA',
                 'Workflow Administrator',
                 'Workflow Administrator Web Applications',
                 'XML Publisher Administrator',
                 'EMR FA Setup with Inquiry (AxI) ARG',
                 'EMR FA Setup with Inquiry ACK NZ',
                 'EMR FA Setup with Inquiry AKSO SA',
                 'EMR FA Setup with Inquiry AOSO AO',
                 'EMR FA Setup with Inquiry ARG',
                 'EMR FA Setup with Inquiry ASO AT',
                 'EMR FA Setup with Inquiry AUHSO AE',
                 'EMR FA Setup with Inquiry AYD TH',
                 'EMR FA Setup with Inquiry BAO VLVS CN',
                 'EMR FA Setup with Inquiry BHSO BH',
                 'EMR FA Setup with Inquiry BKK TH',
                 'EMR FA Setup with Inquiry BMMC BEJ CN',
                 'EMR FA Setup with Inquiry CER VLVS FR',
                 'EMR FA Setup with Inquiry CGSO CG',
                 'EMR FA Setup with Inquiry CHHQ',
                 'EMR FA Setup with Inquiry CHSO CH',
                 'EMR FA Setup with Inquiry CLUJ RO',
                 'EMR FA Setup with Inquiry CLUJ2 RO',
                 'EMR FA Setup with Inquiry CORP MEX',
                 'EMR FA Setup with Inquiry CREEC CRC',
                 'EMR FA Setup with Inquiry CZSO CZ',
                 'EMR FA Setup with Inquiry DESO DE',
                 'EMR FA Setup with Inquiry DGC USA',
                 'EMR FA Setup with Inquiry DKSO DK',
                 'EMR FA Setup with Inquiry DMC USA',
                 'EMR FA Setup with Inquiry DSI RMT',
                 'EMR FA Setup with Inquiry DSK USA',
                 'EMR FA Setup with Inquiry DXB HUB AE',
                 'EMR FA Setup with Inquiry DXBSO AE',
                 'EMR FA Setup with Inquiry EBIC BEJ CN',
                 'EMR FA Setup with Inquiry EDE NL',
                 'EMR FA Setup with Inquiry EECL',
                 'EMR FA Setup with Inquiry EEEC',
                 'EMR FA Setup with Inquiry EPSI',
                 'EMR FA Setup with Inquiry ESSO ES',
                 'EMR FA Setup with Inquiry FCEC IN',
                 'EMR FA Setup with Inquiry FRCL FR',
                 'EMR FA Setup with Inquiry FRSI MNL',
                 'EMR FA Setup with Inquiry FRSO FR',
                 'EMR FA Setup with Inquiry FSA FR',
                 'EMR FA Setup with Inquiry FSO FI',
                 'EMR FA Setup with Inquiry GASO GA',
                 'EMR FA Setup with Inquiry GBHUB GB',
                 'EMR FA Setup with Inquiry GBSO GB',
                 'EMR FA Setup with Inquiry GQSO GQ',
                 'EMR FA Setup with Inquiry HCM VN',
                 'EMR FA Setup with Inquiry HRSO HR',
                 'EMR FA Setup with Inquiry HRT DE',
                 'EMR FA Setup with Inquiry HSO HU',
                 'EMR FA Setup with Inquiry IEC',
                 'EMR FA Setup with Inquiry IESO IE',
                 'EMR FA Setup with Inquiry IQSO IQ',
                 'EMR FA Setup with Inquiry ITSO IT',
                 'EMR FA Setup with Inquiry IVS CAN',
                 'EMR FA Setup with Inquiry IVS USA',
                 'EMR FA Setup with Inquiry JPSO JP',
                 'EMR FA Setup with Inquiry JUSO SA',
                 'EMR FA Setup with Inquiry KRL DE',
                 'EMR FA Setup with Inquiry KWSO KW',
                 'EMR FA Setup with Inquiry LQD USA',
                 'EMR FA Setup with Inquiry LYSO LY',
                 'EMR FA Setup with Inquiry MASO MA',
                 'EMR FA Setup with Inquiry MEL AU',
                 'EMR FA Setup with Inquiry MEX',
                 'EMR FA Setup with Inquiry MHM',
                 'EMR FA Setup with Inquiry MMI MXN',
                 'EMR FA Setup with Inquiry MMI USA',
                 'EMR FA Setup with Inquiry MUM IN',
                 'EMR FA Setup with Inquiry NGSO NG',
                 'EMR FA Setup with Inquiry NKG CN',
                 'EMR FA Setup with Inquiry NLSO NL',
                 'EMR FA Setup with Inquiry NSO NO',
                 'EMR FA Setup with Inquiry PAD USA',
                 'EMR FA Setup with Inquiry PIC RMT',
                 'EMR FA Setup with Inquiry PSO PL',
                 'EMR FA Setup with Inquiry PSYS',
                 'EMR FA Setup with Inquiry PTSO PT',
                 'EMR FA Setup with Inquiry PVG CN',
                 'EMR FA Setup with Inquiry PWS',
                 'EMR FA Setup with Inquiry PWS CN',
                 'EMR FA Setup with Inquiry QASO QA',
                 'EMR FA Setup with Inquiry RAS USA',
                 'EMR FA Setup with Inquiry REG SH CN',
                 'EMR FA Setup with Inquiry Regs USA',
                 'EMR FA Setup with Inquiry RFM NO',
                 'EMR FA Setup with Inquiry RFM RO',
                 'EMR FA Setup with Inquiry RMT',
                 'EMR FA Setup with Inquiry RMT FJR AE',
                 'EMR FA Setup with Inquiry RNI RMT',
                 'EMR FA Setup with Inquiry ROSO RO',
                 'EMR FA Setup with Inquiry ROX NO',
                 'EMR FA Setup with Inquiry RSS NO',
                 'EMR FA Setup with Inquiry RTH NO',
                 'EMR FA Setup with Inquiry SAHUB SA',
                 'EMR FA Setup with Inquiry SEN KR',
                 'EMR FA Setup with Inquiry SESO SE',
                 'EMR FA Setup with Inquiry SKNM SK',
                 'EMR FA Setup with Inquiry SKSO SK',
                 'EMR FA Setup with Inquiry SNG SG',
                 'EMR FA Setup with Inquiry SUB MY',
                 'EMR FA Setup with Inquiry SZ HU',
                 'EMR FA Setup with Inquiry TAR IT',
                 'EMR FA Setup with Inquiry TES',
                 'EMR FA Setup with Inquiry TESCOM DE',
                 'EMR FA Setup with Inquiry TF CH MX',
                 'EMR FA Setup with Inquiry UKHQ',
                 'EMR FA Setup with Inquiry USD CN SG',
                 'EMR FA Setup with Inquiry VA HLO NL',
                 'EMR FA Setup with Inquiry VA HU',
                 'EMR FA Setup with Inquiry VA JHB ZA',
                 'EMR FA Setup with Inquiry VA MY',
                 'EMR FA Setup with Inquiry VA PTL GB',
                 'EMR FA Setup with Inquiry VA SG',
                 'EMR FA Setup with Inquiry VA WCH DE',
                 'EMR FA Setup with Inquiry VA WUQ CN',
                 'EMR FA Setup with Inquiry VAD USA',
                 'EMR FA Setup with Inquiry VLVS',
                 'EMR FA Setup with Inquiry WSL DE'
                );
BEGIN
   FOR i IN x_cur
   LOOP
      fnd_user_pkg.addresp (username            => v_user_name,
                            resp_app            => i.application_short_name,
                            resp_key            => i.responsibility_key,
                            security_group      => 'STANDARD',
                            description         => NULL,
                            start_date          => SYSDATE,
                            end_date            => NULL
                           );
   END LOOP;

   COMMIT;
   DBMS_OUTPUT.put_line (   'Responsiblity '
                         || v_responsibility_name
                         || ' is attached to the user '
                         || v_user_name
                         || ' Successfully'
                        );
EXCEPTION
   WHEN OTHERS
   THEN
      DBMS_OUTPUT.put_line
         (   'Error encountered while attaching responsibilty to the user and the error is '
          || SQLERRM
         );

END;