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.

[Home] [Help]

APPS.MO_GLOBAL dependencies on MO_GLOB_ORG_ACCESS_TMP

Line 265: -- Populate Org Information in MO_GLOB_ORG_ACCESS_TMP

261:
262: END IF;
263:
264: --
265: -- Populate Org Information in MO_GLOB_ORG_ACCESS_TMP
266: --
267: -- Bug fix 4511279
268: -- Need to populate temp table even when access mode is "S"
269: --

Line 359: INTO mo_glob_org_access_tmp_remote

355: then
356: $if fnd_adg_compile_directive.enable_rpc
357: $then
358: INSERT
359: INTO mo_glob_org_access_tmp_remote
360: (organization_id
361: , organization_name)
362: VALUES (t_common_org_id(i)
363: , t_common_ou_name(i));

Line 370: INTO mo_glob_org_access_tmp

366: $end
367: else
368:
369: INSERT
370: INTO mo_glob_org_access_tmp
371: (organization_id
372: , organization_name)
373: VALUES (t_common_org_id(i)
374: , t_common_ou_name(i));

Line 387: INTO mo_glob_org_access_tmp_remote

383: then
384: $if fnd_adg_compile_directive.enable_rpc
385: $then
386: INSERT
387: INTO mo_glob_org_access_tmp_remote
388: (organization_id
389: , organization_name)
390: VALUES (t_org_id(i)
391: , t_ou_name(i));

Line 398: INTO mo_glob_org_access_tmp

394: $end
395: else
396:
397: INSERT
398: INTO mo_glob_org_access_tmp
399: (organization_id
400: , organization_name)
401: VALUES (t_org_id(i)
402: , t_ou_name(i));

Line 435: 'Inserted '||g_ou_count||' record(s) into MO_GLOB_ORG_ACCESS_TMP');

431:
432: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
433: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
434: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.temp_table_insert',
435: 'Inserted '||g_ou_count||' record(s) into MO_GLOB_ORG_ACCESS_TMP');
436: END IF;
437:
438: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 479: 'Before flushing MO_GLOB_ORG_ACCESS_TMP');

475:
476: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
477: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
478: 'fnd.plsql.MO_GLOBAL.DELETE_ORGS.begin',
479: 'Before flushing MO_GLOB_ORG_ACCESS_TMP');
480: END IF;
481:
482: if ( fnd_adg_support.is_standby )
483: then

Line 486: DELETE FROM mo_glob_org_access_tmp_remote;

482: if ( fnd_adg_support.is_standby )
483: then
484: $if fnd_adg_compile_directive.enable_rpc
485: $then
486: DELETE FROM mo_glob_org_access_tmp_remote;
487: $else
488: null;
489: $end
490: else

Line 491: DELETE FROM mo_glob_org_access_tmp;

487: $else
488: null;
489: $end
490: else
491: DELETE FROM mo_glob_org_access_tmp;
492: end if;
493:
494: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
495: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

Line 497: 'MO_GLOB_ORG_ACCESS_TMP was flushed');

493:
494: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
495: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
496: 'fnd.plsql.MO_GLOBAL.DELETE_ORGS.end',
497: 'MO_GLOB_ORG_ACCESS_TMP was flushed');
498: END IF;
499:
500: EXCEPTION
501: WHEN OTHERS THEN

Line 903: FROM mo_glob_org_access_tmp_remote oa

899: $then
900: if ( fnd_adg_support.is_standby )
901: then
902: RETURN 'EXISTS (SELECT /*+ no_unnest */ 1 --bug 13891445
903: FROM mo_glob_org_access_tmp_remote oa
904: WHERE oa.organization_id = org_id)';
905: end if;
906: $end
907:

Line 909: FROM mo_glob_org_access_tmp oa

905: end if;
906: $end
907:
908: RETURN 'EXISTS (SELECT /*+ no_unnest */ 1 --bug 13891445
909: FROM mo_glob_org_access_tmp oa
910: WHERE oa.organization_id = org_id)';
911:
912: ELSIF g_access_mode in ('A','B') THEN
913: RETURN 'org_id <> -3113'; -- Bug5109430 filter seed data from policy predicate

Line 1016: FROM mo_glob_org_access_tmp_remote

1012: then
1013:
1014: SELECT 'Y'
1015: INTO l_org_exists
1016: FROM mo_glob_org_access_tmp_remote
1017: WHERE organization_id = p_org_id;
1018: RETURN 'Y';
1019:
1020: end if;

Line 1025: FROM mo_glob_org_access_tmp

1021: $end
1022:
1023: SELECT 'Y'
1024: INTO l_org_exists
1025: FROM mo_glob_org_access_tmp
1026: WHERE organization_id = p_org_id;
1027: RETURN 'Y';
1028:
1029: ELSIF GET_CURRENT_ORG_ID IS NOT NULL THEN

Line 1061: l_ou_name mo_glob_org_access_tmp.organization_name%TYPE;

1057: --
1058: FUNCTION get_ou_name(p_org_id NUMBER)
1059: RETURN VARCHAR2 IS
1060:
1061: l_ou_name mo_glob_org_access_tmp.organization_name%TYPE;
1062:
1063: BEGIN
1064:
1065: $if fnd_adg_compile_directive.enable_rpc

Line 1072: FROM mo_glob_org_access_tmp_remote

1068: then
1069:
1070: SELECT organization_name
1071: INTO l_ou_name
1072: FROM mo_glob_org_access_tmp_remote
1073: WHERE organization_id = p_org_id;
1074: RETURN l_ou_name;
1075:
1076: end if;

Line 1081: FROM mo_glob_org_access_tmp

1077: $end
1078:
1079: SELECT organization_name
1080: INTO l_ou_name
1081: FROM mo_glob_org_access_tmp
1082: WHERE organization_id = p_org_id;
1083: RETURN l_ou_name;
1084:
1085: EXCEPTION

Line 1650: FROM mo_glob_org_access_tmp_remote oa

1646: $then
1647: if ( fnd_adg_support.is_standby )
1648: then
1649: RETURN '(EXISTS (SELECT 1
1650: FROM mo_glob_org_access_tmp_remote oa
1651: WHERE oa.organization_id = org_id))
1652: OR (org_id = -3116)';
1653: end if;
1654: $end

Line 1656: FROM mo_glob_org_access_tmp oa

1652: OR (org_id = -3116)';
1653: end if;
1654: $end
1655: RETURN '(EXISTS (SELECT 1
1656: FROM mo_glob_org_access_tmp oa
1657: WHERE oa.organization_id = org_id))
1658: OR (org_id = -3116)';
1659: ELSIF g_access_mode in ('A','B') THEN
1660: RETURN 'org_id <> -3113'; -- Bug5109430 filter seed data from policy predicate

Line 1692: -- select organization_id BULK COLLECT INTO l_ou_id_tab from mo_glob_org_access_tmp;

1688: FUNCTION get_ou_tab RETURN OrgIdTab
1689: IS
1690: BEGIN
1691: -- use memory instead of hitting the table
1692: -- select organization_id BULK COLLECT INTO l_ou_id_tab from mo_glob_org_access_tmp;
1693: RETURN g_ou_id_tab;
1694: END get_ou_tab;
1695:
1696: --