DBA Data[Home] [Help]

APPS.IEX_STRATEGY_CNT_PUB dependencies on MO_GLOBAL

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

2412: l_c_org_count number := 0;
2413: -- end added by snuthala for bug 10221334 on 21-10-2010
2414: CURSOR c_org IS
2415: SELECT organization_id from hr_operating_units where
2416: mo_global.check_access(organization_id) = 'Y'
2417: AND organization_id = nvl(P_ORG_ID,organization_id);
2418:
2419: -- Start for bug 8708271 multi level strategy
2420:

Line 2456: where mo_global.check_access(a.organization_id) = 'Y'

2452:
2453: CURSOR c_check_ou_methods (p_org_id number) IS
2454: SELECT COUNT(1)
2455: from hr_operating_units a, IEX_app_preferences_b b
2456: where mo_global.check_access(a.organization_id) = 'Y'
2457: and a.organization_id = b.org_id
2458: and b.collections_method = 'STRATEGIES'
2459: and b.enabled_flag ='Y'
2460: AND organization_id = nvl(p_org_id,organization_id);

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

2567: END IF;
2568: -- end for bug 11844672
2569: fnd_file.put_line(FND_FILE.LOG, ' Party Level Strategy Override value ' || l_party_override );
2570: fnd_file.put_line(FND_FILE.LOG, ' Operating Unit Level Strategy Override value ' || l_org_override);
2571: MO_GLOBAL.INIT('IEX');
2572: IF P_ORG_ID IS NOT NULL THEN
2573: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
2574: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || p_org_id);
2575: ELSE

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

2569: fnd_file.put_line(FND_FILE.LOG, ' Party Level Strategy Override value ' || l_party_override );
2570: fnd_file.put_line(FND_FILE.LOG, ' Operating Unit Level Strategy Override value ' || l_org_override);
2571: MO_GLOBAL.INIT('IEX');
2572: IF P_ORG_ID IS NOT NULL THEN
2573: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
2574: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || p_org_id);
2575: ELSE
2576: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
2577: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');

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

2572: IF P_ORG_ID IS NOT NULL THEN
2573: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
2574: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || p_org_id);
2575: ELSE
2576: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
2577: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
2578: END IF;
2579: FOR I_ORG IN C_ORG LOOP -- Moac Changes. Loop through for Party.
2580: MO_GLOBAL.SET_POLICY_CONTEXT('S',I_ORG.organization_id); -- Moac Changes. Set Org.

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

2576: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
2577: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
2578: END IF;
2579: FOR I_ORG IN C_ORG LOOP -- Moac Changes. Loop through for Party.
2580: MO_GLOBAL.SET_POLICY_CONTEXT('S',I_ORG.organization_id); -- Moac Changes. Set Org.
2581: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside Party Loop, Operating Unit Set =' ||I_ORG.organization_id);
2582: l_org_id:=mo_global.get_current_org_id;
2583: -- Start for bug 8708271 multi level strategy
2584: l_c_org_count := l_c_org_count + 1; -- added by snuthala for bug 10221334 on 21-10-2010

Line 2582: l_org_id:=mo_global.get_current_org_id;

2578: END IF;
2579: FOR I_ORG IN C_ORG LOOP -- Moac Changes. Loop through for Party.
2580: MO_GLOBAL.SET_POLICY_CONTEXT('S',I_ORG.organization_id); -- Moac Changes. Set Org.
2581: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside Party Loop, Operating Unit Set =' ||I_ORG.organization_id);
2582: l_org_id:=mo_global.get_current_org_id;
2583: -- Start for bug 8708271 multi level strategy
2584: l_c_org_count := l_c_org_count + 1; -- added by snuthala for bug 10221334 on 21-10-2010
2585: if l_org_override ='Y' then
2586: fnd_file.put_line(FND_FILE.LOG, 'Operating Unit Level override is on');

Line 4083: ' mo_global.check_access(organization_id) = ''Y''';

4079: close c_mou_account;
4080: -- End adding by gnramasa for bug 8833868 3-Sep-09
4081: -- Start added by snuthala for bug 10221334 on 21-10-2010
4082: vPLSQL2 := 'SELECT organization_id,name from hr_operating_units where '||
4083: ' mo_global.check_access(organization_id) = ''Y''';
4084: if p_org_id IS NOT NULL then
4085: vPLSQL2 := vPLSQL2 || ' and organization_id = nvl(' || p_org_id ||' ,organization_id) ';
4086: end if;
4087: