DBA Data[Home] [Help]

APPS.IEX_UWQ_DELIN_ENUMS_PVT dependencies on MO_GLOBAL

Line 8: PROCEDURE SET_MO_GLOBAL IS

4: -- Sub-Program Units
5:
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

Line 11: WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';

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');
15: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);

Line 14: MO_GLOBAL.INIT('IEX');

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');
15: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);
16:
17:
18: FOR I_ORG IN C_ORG_ID LOOP

Line 15: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);

11: WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';
12: BEGIN
13:
14: MO_GLOBAL.INIT('IEX');
15: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);
16:
17:
18: FOR I_ORG IN C_ORG_ID LOOP
19: MO_GLOBAL.SET_POLICY_CONTEXT('S',I_ORG.ORGANIZATION_ID);

Line 19: MO_GLOBAL.SET_POLICY_CONTEXT('S',I_ORG.ORGANIZATION_ID);

15: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);
16:
17:
18: FOR I_ORG IN C_ORG_ID LOOP
19: MO_GLOBAL.SET_POLICY_CONTEXT('S',I_ORG.ORGANIZATION_ID);
20:
21: L := IEX_UTILITIES.get_cache_value('GL_CURRENCY'||I_ORG.ORGANIZATION_ID,
22: 'SELECT GLSOB.CURRENCY_CODE CURRENCY from GL_SETS_OF_BOOKS GLSOB, AR_SYSTEM_PARAMETERS ARSYS WHERE ARSYS.SET_OF_BOOKS_ID ' ||
23: ' = GLSOB.SET_OF_BOOKS_ID');

Line 27: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);

23: ' = GLSOB.SET_OF_BOOKS_ID');
24: L := IEX_UTILITIES.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE'||I_ORG.ORGANIZATION_ID, 'SELECT DEFAULT_EXCHANGE_RATE_TYPE FROM AR_CMGT_SETUP_OPTIONS');
25: END LOOP;
26:
27: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);
28:
29: END SET_MO_GLOBAL;
30:
31: PROCEDURE ENUMERATE_DELIN_NODES

Line 29: END SET_MO_GLOBAL;

25: END LOOP;
26:
27: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);
28:
29: END SET_MO_GLOBAL;
30:
31: PROCEDURE ENUMERATE_DELIN_NODES
32: (P_RESOURCE_ID IN NUMBER
33: ,P_LANGUAGE IN VARCHAR2

Line 108: MO_GLOBAL.INIT('IEX');

104: BEGIN
105:
106: -- SAVEPOINT start_delin_enumeration;
107: --Moac Changes Start. Set the context.
108: MO_GLOBAL.INIT('IEX');
109: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);
110: --Moac Changes End. Set the context.
111:
112: l_str_and := ' AND ';

Line 109: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);

105:
106: -- SAVEPOINT start_delin_enumeration;
107: --Moac Changes Start. Set the context.
108: MO_GLOBAL.INIT('IEX');
109: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);
110: --Moac Changes End. Set the context.
111:
112: l_str_and := ' AND ';
113: l_str_del := ' AND NUMBER_OF_DELINQUENCIES > 0 ';

Line 526: WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';

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
530: FROM IEX_APP_PREFERENCES_B

Line 540: SET_MO_GLOBAL;

536:
537: BEGIN
538: -- SAVEPOINT start_delin_enumeration;
539:
540: SET_MO_GLOBAL;
541:
542:
543: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
544: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');

Line 1055: WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';

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
1059: FROM IEX_APP_PREFERENCES_B

Line 1067: SET_MO_GLOBAL;

1063: l_group_check number;
1064:
1065: BEGIN
1066:
1067: SET_MO_GLOBAL;
1068:
1069: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1070: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
1071: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);

Line 1699: WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';

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
1703: FROM IEX_APP_PREFERENCES_B

Line 1711: SET_MO_GLOBAL;

1707: l_group_check number;
1708:
1709: BEGIN
1710:
1711: SET_MO_GLOBAL;
1712:
1713:
1714: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1715: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');