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

118: BEGIN
119:
120: -- SAVEPOINT start_delin_enumeration;
121: --Moac Changes Start. Set the context.
122: MO_GLOBAL.INIT('IEX');
123: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);
124: --Moac Changes End. Set the context.
125:
126: l_str_and := ' AND ';

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

119:
120: -- SAVEPOINT start_delin_enumeration;
121: --Moac Changes Start. Set the context.
122: MO_GLOBAL.INIT('IEX');
123: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);
124: --Moac Changes End. Set the context.
125:
126: l_str_and := ' AND ';
127: l_str_del := ' AND NUMBER_OF_DELINQUENCIES > 0 ';

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

632:
633: L VARCHAR2(240);
634:
635: CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS
636: WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';
637:
638: CURSOR c_strategy_level IS
639: SELECT PREFERENCE_VALUE
640: FROM IEX_APP_PREFERENCES_B

Line 662: SET_MO_GLOBAL;

658:
659: BEGIN
660: -- SAVEPOINT start_delin_enumeration;
661:
662: SET_MO_GLOBAL;
663:
664:
665: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
666: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');

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

1195:
1196: L VARCHAR2(240);
1197:
1198: CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS
1199: WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';
1200:
1201: CURSOR c_strategy_level IS
1202: SELECT PREFERENCE_VALUE
1203: FROM IEX_APP_PREFERENCES_B

Line 1223: SET_MO_GLOBAL;

1219: --end bug#6717849 schekuri 31-Jul-2009
1220:
1221: BEGIN
1222:
1223: SET_MO_GLOBAL;
1224:
1225: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1226: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
1227: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);

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

1874: L VARCHAR2(240);
1875:
1876:
1877: CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS
1878: WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';
1879:
1880: CURSOR c_strategy_level IS
1881: SELECT PREFERENCE_VALUE
1882: FROM IEX_APP_PREFERENCES_B

Line 1902: SET_MO_GLOBAL;

1898: --end bug#6717849 schekuri 31-Jul-2009
1899:
1900: BEGIN
1901:
1902: SET_MO_GLOBAL;
1903:
1904:
1905: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1906: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');