[Home] [Help]
257:
258: END IF;
259:
260: --
261: -- Populate Org Information in MO_GLOB_ORG_ACCESS_TMP
262: --
263: -- Bug fix 4511279
264: -- Need to populate temp table even when access mode is "S"
265: --
322:
323: IF(sync_ind = 'Y') AND ( t_delete_org_id.COUNT < t_pref_org_id.COUNT) THEN
324: FOR i IN t_common_org_id.FIRST .. t_common_org_id.LAST LOOP
325: INSERT
326: INTO mo_glob_org_access_tmp
327: (organization_id
328: , organization_name)
329: VALUES (t_common_org_id(i)
330: , t_common_ou_name(i));
333: END LOOP;
334: ELSE
335: FOR i IN t_org_id.FIRST .. t_org_id.LAST LOOP
336: INSERT
337: INTO mo_glob_org_access_tmp
338: (organization_id
339: , organization_name)
340: VALUES (t_org_id(i)
341: , t_ou_name(i));
368:
369: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
370: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
371: 'fnd.plsql.MO_GLOBAL.POPULATE_ORGS.temp_table_insert',
372: 'Inserted '||g_ou_count||' record(s) into MO_GLOB_ORG_ACCESS_TMP');
373: END IF;
374:
375: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
376: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
412:
413: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
414: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
415: 'fnd.plsql.MO_GLOBAL.DELETE_ORGS.begin',
416: 'Before flushing MO_GLOB_ORG_ACCESS_TMP');
417: END IF;
418:
419: DELETE FROM mo_glob_org_access_tmp;
420:
415: 'fnd.plsql.MO_GLOBAL.DELETE_ORGS.begin',
416: 'Before flushing MO_GLOB_ORG_ACCESS_TMP');
417: END IF;
418:
419: DELETE FROM mo_glob_org_access_tmp;
420:
421: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
422: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
423: 'fnd.plsql.MO_GLOBAL.DELETE_ORGS.end',
420:
421: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
422: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
423: 'fnd.plsql.MO_GLOBAL.DELETE_ORGS.end',
424: 'MO_GLOB_ORG_ACCESS_TMP was flushed');
425: END IF;
426:
427: EXCEPTION
428: WHEN OTHERS THEN
799:
800: ELSIF g_access_mode IS NOT NULL THEN
801: IF g_access_mode = 'M' THEN
802: RETURN 'EXISTS (SELECT 1
803: FROM mo_glob_org_access_tmp oa
804: WHERE oa.organization_id = org_id)';
805: ELSIF g_access_mode in ('A','B') THEN
806: RETURN 'org_id <> -3113'; -- Bug5109430 filter seed data from policy predicate
807: ELSIF g_access_mode = 'S' THEN
900: -- if mo initialization is done
901:
902: SELECT 'Y'
903: INTO l_org_exists
904: FROM mo_glob_org_access_tmp
905: WHERE organization_id = p_org_id;
906: RETURN 'Y';
907:
908: ELSIF GET_CURRENT_ORG_ID IS NOT NULL THEN
936: --
937: FUNCTION get_ou_name(p_org_id NUMBER)
938: RETURN VARCHAR2 IS
939:
940: l_ou_name mo_glob_org_access_tmp.organization_name%TYPE;
941:
942: BEGIN
943:
944: SELECT organization_name
942: BEGIN
943:
944: SELECT organization_name
945: INTO l_ou_name
946: FROM mo_glob_org_access_tmp
947: WHERE organization_id = p_org_id;
948: RETURN l_ou_name;
949:
950: EXCEPTION
1506: RETURN 'org_id = sys_context(''multi_org2'',''current_org_id'') OR (org_id = -3116)';
1507:
1508: ELSIF g_access_mode = 'M' THEN
1509: RETURN '(EXISTS (SELECT 1
1510: FROM mo_glob_org_access_tmp oa
1511: WHERE oa.organization_id = org_id))
1512: OR (org_id = -3116)';
1513: ELSIF g_access_mode in ('A','B') THEN
1514: RETURN 'org_id <> -3113'; -- Bug5109430 filter seed data from policy predicate
1542: FUNCTION get_ou_tab RETURN OrgIdTab
1543: IS
1544: BEGIN
1545: -- use memory instead of hitting the table
1546: -- select organization_id BULK COLLECT INTO l_ou_id_tab from mo_glob_org_access_tmp;
1547: RETURN g_ou_id_tab;
1548: END get_ou_tab;
1549:
1550: --