6: PG_DEBUG NUMBER(2);
7:
8: PROCEDURE SET_MO_GLOBAL IS
9: L VARCHAR2(240);
10: CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS
11: WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';
12: BEGIN
13:
14: MO_GLOBAL.INIT('IEX');
521: l_additional_where VARCHAR2(2000);
522:
523: L VARCHAR2(240);
524:
525: CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS
526: WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';
527:
528: CURSOR c_strategy_level IS
529: SELECT PREFERENCE_VALUE
1050: l_additional_where2 VARCHAR2(2000);
1051:
1052: L VARCHAR2(240);
1053:
1054: CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS
1055: WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';
1056:
1057: CURSOR c_strategy_level IS
1058: SELECT PREFERENCE_VALUE
1694:
1695: L VARCHAR2(240);
1696:
1697:
1698: CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS
1699: WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';
1700:
1701: CURSOR c_strategy_level IS
1702: SELECT PREFERENCE_VALUE