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 104: MO_GLOBAL.INIT('IEX');

100: BEGIN
101:
102: -- SAVEPOINT start_prom_enumeration;
103: -- Moac Changes start. Set the policy context.
104: MO_GLOBAL.INIT('IEX');
105: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);
106: -- Moac Changes End. Set the policy context.
107:
108: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);

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

101:
102: -- SAVEPOINT start_prom_enumeration;
103: -- Moac Changes start. Set the policy context.
104: MO_GLOBAL.INIT('IEX');
105: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);
106: -- Moac Changes End. Set the policy context.
107:
108: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
109: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');

Line 468: SET_MO_GLOBAL;

464: --end bug#6717849 schekuri 31-Jul-2009
465:
466: BEGIN
467:
468: SET_MO_GLOBAL;
469:
470: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
471: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
472: -- l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK

Line 829: SET_MO_GLOBAL;

825: --end bug#6717849 schekuri 31-Jul-2009
826:
827: BEGIN
828:
829: SET_MO_GLOBAL;
830:
831: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
832: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
833: -- l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK

Line 1224: SET_MO_GLOBAL;

1220: --end bug#6717849 schekuri 31-Jul-2009
1221:
1222: BEGIN
1223:
1224: SET_MO_GLOBAL;
1225:
1226: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1227: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1228: --l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK