APPS.MSC_CL_SUPPLY_ODS_LOAD dependencies on MSC_APPS_INSTANCES

Line 33: from msc_apps_instances

29: LOOP
30:
31: select nvl(SUPPLIES_LOAD_FLAG,MSC_CL_COLLECTION.G_JOB_NOT_DONE)
32: into lv_is_job_done
33: from msc_apps_instances
34: where instance_id = MSC_CL_COLLECTION.v_instance_id;
35:
36: select (SYSDATE- MSC_CL_COLLECTION.START_TIME) into lv_process_time from dual;
37:

Line 115: update msc_apps_instances

111:
112: EXCEPTION
113: WHEN OTHERS THEN
114: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
115: update msc_apps_instances
116: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
117: where instance_id = MSC_CL_COLLECTION.v_instance_id;
118: commit;
119: RETURN FALSE;

Line 2098: update msc_apps_instances

2094: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2095: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2096: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2097:
2098: update msc_apps_instances
2099: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
2100: where instance_id = MSC_CL_COLLECTION.v_instance_id;
2101: commit;
2102:

Line 2244: update msc_apps_instances

2240: EXCEPTION
2241:
2242: WHEN MSC_CL_COLLECTION.SUPPLIES_INDEX_FAIL THEN
2243:
2244: update msc_apps_instances
2245: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
2246: where instance_id = MSC_CL_COLLECTION.v_instance_id;
2247: commit;
2248: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'MSC_CL_COLLECTION.SUPPLIES_INDEX_FAIL failed');

Line 2254: update msc_apps_instances

2250: RAISE;
2251:
2252: WHEN OTHERS THEN
2253:
2254: update msc_apps_instances
2255: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
2256: where instance_id = MSC_CL_COLLECTION.v_instance_id;
2257: commit;
2258:

Line 3210: update msc_apps_instances

3206: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3207: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3209:
3210: update msc_apps_instances
3211: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
3212: where instance_id = MSC_CL_COLLECTION.v_instance_id;
3213: commit;
3214:

Line 3964: update msc_apps_instances

3960: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3961: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3962: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3963:
3964: update msc_apps_instances
3965: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
3966: where instance_id = MSC_CL_COLLECTION.v_instance_id;
3967: commit;
3968:

Line 4303: update msc_apps_instances

4299:
4300:
4301: EXCEPTION
4302: WHEN OTHERS THEN
4303: update msc_apps_instances
4304: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
4305: where instance_id = MSC_CL_COLLECTION.v_instance_id;
4306: commit;
4307:

Line 4659: UPDATE msc_apps_instances

4655: COMMIT;
4656: EXCEPTION
4657: WHEN OTHERS
4658: THEN
4659: UPDATE msc_apps_instances
4660: SET SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
4661: WHERE instance_id = MSC_CL_COLLECTION.v_instance_id;
4662:
4663: COMMIT;