APPS.MSC_PURGE_LID dependencies on MSC_APPS_INSTANCES

Line 42: FROM MSC_APPS_INSTANCES mai

38:
39: SELECT mai.enable_flag,
40: mai.st_status
41: INTO lv_instance_enabled, lv_staging_table_status
42: FROM MSC_APPS_INSTANCES mai
43: WHERE mai.INSTANCE_ID= v_instance_id
44: AND mai.instance_type IN (G_INS_OTHER,G_INS_EXCH) ;
45:
46:

Line 1718: FROM MSC_APPS_INSTANCES

1714: SELECT DECODE( M2A_DBLINK, NULL, ' ', '@'||M2A_DBLINK)
1715:
1716: INTO lv_dblink
1717:
1718: FROM MSC_APPS_INSTANCES
1719:
1720: WHERE INSTANCE_ID= pInstId;
1721:
1722:

Line 2005: -- Delete Instance from MSC_INST_PARTITIONS, MSC_APPS_INSTANCES, MRP_AP_APPS_INSTANCES_ALL GET_DBLINK(pInstId NUMBER)

2001:
2002:
2003:
2004:
2005: -- Delete Instance from MSC_INST_PARTITIONS, MSC_APPS_INSTANCES, MRP_AP_APPS_INSTANCES_ALL GET_DBLINK(pInstId NUMBER)
2006:
2007:
2008:
2009: -- get source schema short name.

Line 2099: BEGIN -- delete from MSC_APPS_INSTANCES --

2095: END;
2096:
2097: --
2098:
2099: BEGIN -- delete from MSC_APPS_INSTANCES --
2100:
2101: lv_qry_str := 'DELETE FROM MSC_APPS_INSTANCES WHERE instance_id IN '||lv_inst_str;
2102:
2103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1,lv_qry_str);

Line 2101: lv_qry_str := 'DELETE FROM MSC_APPS_INSTANCES WHERE instance_id IN '||lv_inst_str;

2097: --
2098:
2099: BEGIN -- delete from MSC_APPS_INSTANCES --
2100:
2101: lv_qry_str := 'DELETE FROM MSC_APPS_INSTANCES WHERE instance_id IN '||lv_inst_str;
2102:
2103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1,lv_qry_str);
2104:
2105: EXECUTE IMMEDIATE lv_qry_str;

Line 2113: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1,'Error while deleting from MSC_APPS_INSTANCES --'||SQLERRM);

2109: WHEN OTHERS THEN
2110:
2111: RETCODE := MSC_UTIL.G_WARNING;
2112:
2113: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1,'Error while deleting from MSC_APPS_INSTANCES --'||SQLERRM);
2114:
2115: END;
2116:
2117: COMMIT;

Line 2863: select instance_type into lv_inst_type from msc_apps_instances where instance_id = pINSTANCE_ID;

2859: ||' from msc_entity_table_map_v where nvl(delete_flag,2) = 1 and '
2860: ||' UPPER(entity_name)= :entityname'
2861: ;
2862:
2863: select instance_type into lv_inst_type from msc_apps_instances where instance_id = pINSTANCE_ID;
2864:
2865: if lv_inst_type = G_INS_OTHER then
2866: lv_sql1 := replace(lv_sql1, 'entity_name', 'leg_entity_name');
2867: end if;