eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_UWQ_POP_SUM_TBL_PVT dependencies on MO_GLOBAL

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

390: x boolean;
391:
392: CURSOR c_org(c_org_id number) IS
393: SELECT organization_id from hr_operating_units where
394: mo_global.check_access(organization_id) = 'Y'
395: AND organization_id = nvl(c_org_id,organization_id);
396:
397: --Begin Bug 8942646 12-Oct-2009 barathsr
398: CURSOR c_get_level IS

Line 455: mo_global.init('IEX');

451:
452:
453: if (G_OU_LVL_ENB='Y' or G_PARTY_LVL_ENB='Y') then
454: if G_OU_LVL_ENB='Y' then
455: mo_global.init('IEX');
456: if p_org_id is null then
457: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
458: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
459: --open c_org(l_org_id);

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

453: if (G_OU_LVL_ENB='Y' or G_PARTY_LVL_ENB='Y') then
454: if G_OU_LVL_ENB='Y' then
455: mo_global.init('IEX');
456: if p_org_id is null then
457: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
458: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
459: --open c_org(l_org_id);
460: else
461: MO_GLOBAL.SET_POLICY_CONTEXT('S',p_ORG_ID);

Line 461: MO_GLOBAL.SET_POLICY_CONTEXT('S',p_ORG_ID);

457: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
458: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
459: --open c_org(l_org_id);
460: else
461: MO_GLOBAL.SET_POLICY_CONTEXT('S',p_ORG_ID);
462: end if;
463:
464: for i in c_org(p_org_id) loop
465: l_curr_org_id:=i.organization_id;

Line 649: mo_global.init('IEX');

645: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'truncate table ' || l_truncate_table);
646: EXECUTE IMMEDIATE 'truncate table ' || l_truncate_table;
647: LogMessage(FND_LOG.LEVEL_STATEMENT,'Truncated whole table');
648: else
649: mo_global.init('IEX');
650: if p_org_id is null then
651: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
652: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
653: else

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

647: LogMessage(FND_LOG.LEVEL_STATEMENT,'Truncated whole table');
648: else
649: mo_global.init('IEX');
650: if p_org_id is null then
651: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
652: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
653: else
654: MO_GLOBAL.SET_POLICY_CONTEXT('S',p_ORG_ID);
655: end if;

Line 654: MO_GLOBAL.SET_POLICY_CONTEXT('S',p_ORG_ID);

650: if p_org_id is null then
651: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
652: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
653: else
654: MO_GLOBAL.SET_POLICY_CONTEXT('S',p_ORG_ID);
655: end if;
656: for i in c_org(p_org_id) loop
657: l_org_id:=i.organization_id;
658: LogMessage(FND_LOG.LEVEL_STATEMENT,'Delete records corresponding to the org_id passed-->'||l_org_id);

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

745: order by nvl(org_id,0) desc ;
746:
747: CURSOR c_org(c_org_id number) IS
748: SELECT organization_id from hr_operating_units where
749: mo_global.check_access(organization_id) = 'Y'
750: AND organization_id = nvl(c_org_id,organization_id);
751:
752: l_allowed_lvl varchar2(20);
753: l_curr_org_id number;

Line 832: mo_global.init('IEX');

828:
829:
830: if (G_OU_LVL_ENB='Y' or G_PARTY_LVL_ENB='Y') then
831: if G_OU_LVL_ENB='Y' then
832: mo_global.init('IEX');
833: if p_org_id is null then
834:
835: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
836: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');

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

831: if G_OU_LVL_ENB='Y' then
832: mo_global.init('IEX');
833: if p_org_id is null then
834:
835: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
836: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
837: --open c_org(l_org_id);
838: else
839: MO_GLOBAL.SET_POLICY_CONTEXT('S',p_ORG_ID);

Line 839: MO_GLOBAL.SET_POLICY_CONTEXT('S',p_ORG_ID);

835: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
836: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
837: --open c_org(l_org_id);
838: else
839: MO_GLOBAL.SET_POLICY_CONTEXT('S',p_ORG_ID);
840: end if;
841:
842: for i in c_org(p_org_id) loop
843: l_curr_org_id:=i.organization_id;

Line 845: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_curr_org_id );

841:
842: for i in c_org(p_org_id) loop
843: l_curr_org_id:=i.organization_id;
844: FND_FILE.PUT_LINE(FND_FILE.LOG, 'org_id is-->'||l_curr_org_id);
845: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_curr_org_id );
846:
847: -- update_trx_bal_summ('CP',l_curr_org_id);
848: FND_FILE.PUT_LINE(FND_FILE.LOG,'into OU level');
849:

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

13520: AND iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
13521:
13522: CURSOR c_org(c_org_id number) IS
13523: SELECT organization_id from hr_operating_units where
13524: mo_global.check_access(organization_id) = 'Y'
13525: AND organization_id = nvl(c_org_id,organization_id);
13526:
13527: BEGIN
13528:

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

13539:
13540:
13541: if (G_OU_LVL_ENB='Y' or G_PARTY_LVL_ENB='Y') then
13542: if G_OU_LVL_ENB='Y' then
13543: MO_GLOBAL.INIT('IEX');
13544: --l_org_id:=mo_global.get_current_org_id;
13545: select org_id
13546: into l_org_id
13547: from fnd_concurrent_requests

Line 13544: --l_org_id:=mo_global.get_current_org_id;

13540:
13541: if (G_OU_LVL_ENB='Y' or G_PARTY_LVL_ENB='Y') then
13542: if G_OU_LVL_ENB='Y' then
13543: MO_GLOBAL.INIT('IEX');
13544: --l_org_id:=mo_global.get_current_org_id;
13545: select org_id
13546: into l_org_id
13547: from fnd_concurrent_requests
13548: where request_id=FND_GLOBAL.CONC_REQUEST_ID;

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

13547: from fnd_concurrent_requests
13548: where request_id=FND_GLOBAL.CONC_REQUEST_ID;
13549:
13550: if l_org_id is null then
13551: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
13552: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
13553: --open c_org(l_org_id);
13554: else
13555: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_ORG_ID);

Line 13555: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_ORG_ID);

13551: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
13552: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
13553: --open c_org(l_org_id);
13554: else
13555: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_ORG_ID);
13556: end if;
13557: for i in c_org(l_org_id) loop
13558: l_curr_org_id:=i.organization_id;
13559: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_curr_org_id );

Line 13559: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_curr_org_id );

13555: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_ORG_ID);
13556: end if;
13557: for i in c_org(l_org_id) loop
13558: l_curr_org_id:=i.organization_id;
13559: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_curr_org_id );
13560: FND_FILE.PUT_LINE(FND_FILE.LOG,'into OU level');
13561: FND_FILE.PUT_LINE(FND_FILE.LOG,'into OU level-->'||l_curr_org_id);
13562: open c_get_level(l_curr_org_id);
13563: fetch c_get_level into G_SYSTEM_LEVEL;

Line 13800: mo_global.set_policy_context('S',r_org.org_id);

13796:
13797: -- Loop runs for each operating unit once and each time loops for all IEU_PARAM_PK_VALUE values
13798: for r_org in c_orgs loop
13799:
13800: mo_global.set_policy_context('S',r_org.org_id);
13801: j := 1;
13802: for r_aging in c_aging_summary(r_org.org_id) loop
13803:
13804: IEX_AGING_BUCKETS_PKG.QUERY_AGING_LINES(p_api_version => 1.0,