APPS.MSC_CL_WIP_ODS_LOAD dependencies on MSC_JOB_OP_RES_INSTANCES

Line 76: lv_tbl:= 'MSC_JOB_OP_RES_INSTANCES';

72: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
73: lv_tbl:= 'JOB_OP_RES_INSTANCES_'||MSC_CL_COLLECTION.v_instance_code;
74: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
75: ELSE
76: lv_tbl:= 'MSC_JOB_OP_RES_INSTANCES';
77: lv_supplies_tbl:= 'MSC_SUPPLIES';
78: END IF;
79:
80: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

Line 123: DELETE MSC_JOB_OP_RES_INSTANCES

119: lv_SR_INSTANCE_ID;
120:
121: EXIT WHEN cgen%NOTFOUND;
122:
123: DELETE MSC_JOB_OP_RES_INSTANCES
124: WHERE PLAN_ID= -1
125: AND TRANSACTION_ID = lv_TRANSACTION_ID
126: AND SR_INSTANCE_ID = lv_SR_INSTANCE_ID
127: AND OPERATION_SEQ_NUM = nvl(lv_OPERATION_SEQ_NUM,OPERATION_SEQ_NUM)

Line 238: UPDATE MSC_JOB_OP_RES_INSTANCES

234: BEGIN
235:
236: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
237: /* we can get rid of thsi update if we insert in ad table when instance is updated */
238: UPDATE MSC_JOB_OP_RES_INSTANCES
239: SET
240: START_DATE = lv_START_DATE,
241: COMPLETION_DATE = lv_COMPLETION_DATE,
242: BATCH_NUMBER = lv_BATCH_NUMBER,

Line 295: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RES_INSTANCES');

291:
292: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
293: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
294: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES_INSTANCE');
295: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RES_INSTANCES');
296: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
297:
298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
299: RAISE;

Line 308: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RES_INSTANCES');

304:
305: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
306: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
307: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES_INSTANCE');
308: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RES_INSTANCES');
309: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
310:
311: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
312: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

Line 324: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Total MSC_JOB_OP_RES_INSTANCES = '|| to_char(total_count));

320:
321: END;
322: END LOOP;
323:
324: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Total MSC_JOB_OP_RES_INSTANCES = '|| to_char(total_count));
325: END IF; /* cgen%ISOPEN */
326:
327: CLOSE cgen;
328:

Line 339: ||' SELECT * from MSC_JOB_OP_RES_INSTANCES'

335: lv_tbl:= 'JOB_OP_RES_INSTANCES_'||MSC_CL_COLLECTION.v_instance_code;
336:
337: lv_sql_stmt:=
338: 'INSERT INTO '||lv_tbl
339: ||' SELECT * from MSC_JOB_OP_RES_INSTANCES'
340: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
341: ||' AND plan_id = -1 '
342: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
343:

Line 361: 'MSC_JOB_OP_RES_INSTANCES',

357:
358: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
359: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
360: lv_retcode,
361: 'MSC_JOB_OP_RES_INSTANCES',
362: MSC_CL_COLLECTION.v_instance_code,
363: MSC_UTIL.G_WARNING
364: );
365: