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 2026: update msc_apps_instances

2022: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2023: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2024: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2025:
2026: update msc_apps_instances
2027: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
2028: where instance_id = MSC_CL_COLLECTION.v_instance_id;
2029: commit;
2030:

Line 2136: update msc_apps_instances

2132: EXCEPTION
2133:
2134: WHEN MSC_CL_COLLECTION.SUPPLIES_INDEX_FAIL THEN
2135:
2136: update msc_apps_instances
2137: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
2138: where instance_id = MSC_CL_COLLECTION.v_instance_id;
2139: commit;
2140: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'MSC_CL_COLLECTION.SUPPLIES_INDEX_FAIL failed');

Line 2146: update msc_apps_instances

2142: RAISE;
2143:
2144: WHEN OTHERS THEN
2145:
2146: update msc_apps_instances
2147: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
2148: where instance_id = MSC_CL_COLLECTION.v_instance_id;
2149: commit;
2150:

Line 3050: update msc_apps_instances

3046: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3047: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3048: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3049:
3050: update msc_apps_instances
3051: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
3052: where instance_id = MSC_CL_COLLECTION.v_instance_id;
3053: commit;
3054:

Line 3741: update msc_apps_instances

3737: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3738: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3739: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3740:
3741: update msc_apps_instances
3742: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
3743: where instance_id = MSC_CL_COLLECTION.v_instance_id;
3744: commit;
3745:

Line 4042: update msc_apps_instances

4038: COMMIT;
4039:
4040: EXCEPTION
4041: WHEN OTHERS THEN
4042: update msc_apps_instances
4043: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR
4044: where instance_id = MSC_CL_COLLECTION.v_instance_id;
4045: commit;
4046: