APPS.MSC_CL_WIP_ODS_LOAD dependencies on MSC_JOB_OP_RES_INSTANCES

Line 77: lv_tbl:= 'MSC_JOB_OP_RES_INSTANCES';

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

Line 124: DELETE MSC_JOB_OP_RES_INSTANCES

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

Line 239: UPDATE MSC_JOB_OP_RES_INSTANCES

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

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

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

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

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

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

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

Line 340: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_JOB_OP_RES_INSTANCES'

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

Line 362: 'MSC_JOB_OP_RES_INSTANCES',

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