DBA Data[Home] [Help]

APPS.OE_EXT_CREDIT_EXPOSURE_PVT dependencies on MO_GLOBAL

Line 24: G_org_id NUMBER := mo_global.get_current_org_id; -- MOAC Changes TO_NUMBER(FND_PROFILE.value('ORG_ID'));

20: G_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
21: G_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
22: G_user_id NUMBER := FND_GLOBAL.USER_ID;
23: G_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
24: G_org_id NUMBER := mo_global.get_current_org_id; -- MOAC Changes TO_NUMBER(FND_PROFILE.value('ORG_ID'));
25:
26: ---------------------------
27: -- PROCEDURES AND FUNCTIONS
28: ---------------------------

Line 481: MO_GLOBAL.set_policy_context('S', p_exposure_rec.org_id);

477: x_return_status := FND_API.G_RET_STS_SUCCESS;
478:
479: /* Added the following line to fix the bug 6451056 */
480:
481: MO_GLOBAL.set_policy_context('S', p_exposure_rec.org_id);
482:
483:
484: IF p_exposure_rec.bill_to_site_use_id IS NOT NULL THEN
485: BEGIN

Line 1135: WHERE mo_global.check_access(ou.organization_id) = 'Y';

1131: -- MOAC start
1132: CURSOR l_secured_ou_cur IS
1133: SELECT ou.organization_id
1134: FROM hr_operating_units ou
1135: WHERE mo_global.check_access(ou.organization_id) = 'Y';
1136:
1137: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1138: -- MOAC end
1139:

Line 1180: MO_GLOBAL.set_policy_context('S', l_org_id);

1176: -- MOAC start
1177: l_org_id := p_org_id;
1178:
1179: IF l_org_id IS NOT NULL THEN
1180: MO_GLOBAL.set_policy_context('S', l_org_id);
1181:
1182: UPDATE oe_exposure_interface
1183: SET exposure_interface_id = OE_EXPOSURE_INTERFACE_S.NextVal,
1184: import_status_code = G_PROCESSING,

Line 1204: l_org_id := mo_global.get_current_org_id;

1200: into l_org_id;
1201: EXIT WHEN l_secured_ou_cur%NOTFOUND;
1202:
1203: IF l_org_id IS NULL THEN
1204: l_org_id := mo_global.get_current_org_id;
1205: END IF;
1206:
1207: MO_GLOBAL.set_policy_context('S', l_org_id);
1208:

Line 1207: MO_GLOBAL.set_policy_context('S', l_org_id);

1203: IF l_org_id IS NULL THEN
1204: l_org_id := mo_global.get_current_org_id;
1205: END IF;
1206:
1207: MO_GLOBAL.set_policy_context('S', l_org_id);
1208:
1209: UPDATE oe_exposure_interface
1210: SET exposure_interface_id = OE_EXPOSURE_INTERFACE_S.NextVal,
1211: import_status_code = G_PROCESSING,

Line 1375: WHERE mo_global.check_access(ou.organization_id) = 'Y';

1371: IS
1372: CURSOR l_secured_ou_cur IS
1373: SELECT ou.organization_id
1374: FROM hr_operating_units ou
1375: WHERE mo_global.check_access(ou.organization_id) = 'Y';
1376:
1377: l_org_id NUMBER;
1378: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1379:

Line 1389: MO_GLOBAL.set_policy_context('S', l_org_id);

1385: OE_DEBUG_PUB.Add('OEXVECEB: In Purge');
1386: END IF;
1387:
1388: IF l_org_id IS NOT NULL THEN
1389: MO_GLOBAL.set_policy_context('S', l_org_id);
1390:
1391: DELETE FROM oe_credit_summaries
1392: WHERE exposure_source_code = NVL(p_exposure_source_code, exposure_source_code)
1393: AND balance_type = 18

Line 1409: l_org_id := mo_global.get_current_org_id;

1405: into l_org_id;
1406: EXIT WHEN l_secured_ou_cur%NOTFOUND;
1407:
1408: IF l_org_id IS NULL THEN
1409: l_org_id := mo_global.get_current_org_id;
1410: END IF;
1411:
1412: MO_GLOBAL.set_policy_context('S', l_org_id);
1413:

Line 1412: MO_GLOBAL.set_policy_context('S', l_org_id);

1408: IF l_org_id IS NULL THEN
1409: l_org_id := mo_global.get_current_org_id;
1410: END IF;
1411:
1412: MO_GLOBAL.set_policy_context('S', l_org_id);
1413:
1414: DELETE FROM oe_credit_summaries
1415: WHERE exposure_source_code = NVL(p_exposure_source_code, exposure_source_code)
1416: AND balance_type = 18