DBA Data[Home] [Help]

APPS.IEX_UWQ_PROM_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_PROM_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_PROM_NODES
32: (P_RESOURCE_ID IN NUMBER
33: ,P_LANGUAGE IN VARCHAR2

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

94: BEGIN
95:
96: -- SAVEPOINT start_prom_enumeration;
97: -- Moac Changes start. Set the policy context.
98: MO_GLOBAL.INIT('IEX');
99: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);
100: -- Moac Changes End. Set the policy context.
101:
102: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);

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

95:
96: -- SAVEPOINT start_prom_enumeration;
97: -- Moac Changes start. Set the policy context.
98: MO_GLOBAL.INIT('IEX');
99: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);
100: -- Moac Changes End. Set the policy context.
101:
102: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
103: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');

Line 436: SET_MO_GLOBAL;

432: l_strategy_level VARCHAR2(30);
433:
434: BEGIN
435:
436: SET_MO_GLOBAL;
437:
438: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
439: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
440: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));

Line 752: SET_MO_GLOBAL;

748: l_strategy_level VARCHAR2(30);
749:
750: BEGIN
751:
752: SET_MO_GLOBAL;
753:
754: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
755: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
756: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));

Line 1102: SET_MO_GLOBAL;

1098: l_strategy_level VARCHAR2(30);
1099:
1100: BEGIN
1101:
1102: SET_MO_GLOBAL;
1103:
1104: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1105: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1106: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));