/*
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;