DBA Data[Home] [Help]

APPS.IEX_METRIC_CONCUR_PVT dependencies on MO_GLOBAL

Line 60: mo_global.check_access(organization_id) = 'Y'

56: --Moac Changes. Define Cursor for org_id. Start.
57:
58: CURSOR c_org IS
59: SELECT organization_id from hr_operating_units where
60: mo_global.check_access(organization_id) = 'Y'
61: AND organization_id = nvl(P_ORG_ID,organization_id);
62:
63: --Moac Changes. Define Cursor for org_id. End.
64:

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

102: --Moac Changes. Commented the profile value. End.
103:
104: --Moac Changes. Initilize set the Policy. Start
105:
106: MO_GLOBAL.INIT('IEX');
107: IF P_ORG_ID IS NOT NULL THEN
108: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
109: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || p_org_id);
110: ELSE

Line 108: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.

104: --Moac Changes. Initilize set the Policy. Start
105:
106: MO_GLOBAL.INIT('IEX');
107: IF P_ORG_ID IS NOT NULL THEN
108: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
109: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || p_org_id);
110: ELSE
111: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
112: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');

Line 111: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.

107: IF P_ORG_ID IS NOT NULL THEN
108: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
109: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || p_org_id);
110: ELSE
111: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
112: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
113: END IF;
114:
115: --Moac Changes. Initilize,set the Policy. End.

Line 150: MO_GLOBAL.SET_POLICY_CONTEXT('S',I_ORG.organization_id); -- Moac Changes. Set Org.

146: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Purge complete>>>>>');
147: -- End fix bug #5009901-JYPARK-delete records by batch size for performance
148:
149: FOR I_ORG IN C_ORG LOOP -- Moac Changes. Loop through for Party.
150: MO_GLOBAL.SET_POLICY_CONTEXT('S',I_ORG.organization_id); -- Moac Changes. Set Org.
151: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside Party Loop, Operating Unit Set =' ||I_ORG.organization_id);
152:
153: i := 0;
154: FOR r_party IN c_party LOOP

Line 201: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.

197: END LOOP; -- Moac Changes. Org Loop.
198:
199: --Moac Changes. Re-Initialize after the Party Loop is complete. Start.
200: IF P_ORG_ID IS NOT NULL THEN
201: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
202: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Reset after party loop, Operating Unit=' || p_org_id);
203: ELSE
204: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
205: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Reset after party loop, Operating Unit=' || 'All');

Line 204: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.

200: IF P_ORG_ID IS NOT NULL THEN
201: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
202: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Reset after party loop, Operating Unit=' || p_org_id);
203: ELSE
204: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
205: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Reset after party loop, Operating Unit=' || 'All');
206: END IF;
207: --Moac Changes. Re-Initialize after the Party Loop is complete. Start.
208:

Line 210: MO_GLOBAL.SET_POLICY_CONTEXT('S',I_ORG.organization_id); -- Moac Changes. Set Org.

206: END IF;
207: --Moac Changes. Re-Initialize after the Party Loop is complete. Start.
208:
209: FOR I_ORG IN C_ORG LOOP -- Moac Changes. Loop through for Party.
210: MO_GLOBAL.SET_POLICY_CONTEXT('S',I_ORG.organization_id); -- Moac Changes. Set Org.
211: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside Account Loop, Operating Unit Set =' ||I_ORG.organization_id);
212: i := 0;
213: l_party_id_tbl.DELETE;
214:

Line 263: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.

259: END LOOP; --Moac Change. Org Loop.
260:
261: --Moac Changes. Re-Initilize,set the Policy. Start
262: IF P_ORG_ID IS NOT NULL THEN
263: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
264: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Reset after Account loop, Operating Unit=' || p_org_id);
265: ELSE
266: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
267: END IF;

Line 266: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.

262: IF P_ORG_ID IS NOT NULL THEN
263: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
264: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Reset after Account loop, Operating Unit=' || p_org_id);
265: ELSE
266: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
267: END IF;
268: --Moac Changes. Initilize, set the Policy. End.
269:
270: