APPS.MSC_PURGE_LID dependencies on MSC_APPS_INSTANCES

Line 39: FROM MSC_APPS_INSTANCES mai

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

Line 1676: FROM MSC_APPS_INSTANCES

1672: SELECT DECODE( M2A_DBLINK, NULL, ' ', '@'||M2A_DBLINK)
1673:
1674: INTO lv_dblink
1675:
1676: FROM MSC_APPS_INSTANCES
1677:
1678: WHERE INSTANCE_ID= pInstId;
1679:
1680:

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

1959:
1960:
1961:
1962:
1963: -- Delete Instance from MSC_INST_PARTITIONS, MSC_APPS_INSTANCES, MRP_AP_APPS_INSTANCES_ALL GET_DBLINK(pInstId NUMBER)
1964:
1965:
1966:
1967: -- get source schema short name.

Line 2057: BEGIN -- delete from MSC_APPS_INSTANCES --

2053: END;
2054:
2055: --
2056:
2057: BEGIN -- delete from MSC_APPS_INSTANCES --
2058:
2059: lv_qry_str := 'DELETE FROM '||lv_schema||'.MSC_APPS_INSTANCES WHERE instance_id IN '||lv_inst_str;
2060:
2061: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1,lv_qry_str);

Line 2059: lv_qry_str := 'DELETE FROM '||lv_schema||'.MSC_APPS_INSTANCES WHERE instance_id IN '||lv_inst_str;

2055: --
2056:
2057: BEGIN -- delete from MSC_APPS_INSTANCES --
2058:
2059: lv_qry_str := 'DELETE FROM '||lv_schema||'.MSC_APPS_INSTANCES WHERE instance_id IN '||lv_inst_str;
2060:
2061: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1,lv_qry_str);
2062:
2063: EXECUTE IMMEDIATE lv_qry_str;

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

2067: WHEN OTHERS THEN
2068:
2069: RETCODE := MSC_UTIL.G_WARNING;
2070:
2071: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1,'Error while deleting from MSC_APPS_INSTANCES --'||SQLERRM);
2072:
2073: END;
2074:
2075: COMMIT;