APPS.MSC_CL_WIP_ODS_LOAD dependencies on MSC_JOB_OPERATIONS

Line 436: lv_tbl:= 'MSC_JOB_OPERATIONS';

432: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
433: lv_tbl:= 'JOB_OPERATIONS_'||MSC_CL_COLLECTION.v_instance_code;
434: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
435: ELSE
436: lv_tbl:= 'MSC_JOB_OPERATIONS';
437: lv_supplies_tbl:= 'MSC_SUPPLIES';
438: END IF;
439:
440: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

Line 469: DELETE MSC_JOB_OPERATIONS

465: lv_SR_INSTANCE_ID;
466:
467: EXIT WHEN cgen%NOTFOUND;
468:
469: DELETE MSC_JOB_OPERATIONS
470: WHERE PLAN_ID= -1
471: AND TRANSACTION_ID = lv_TRANSACTION_ID
472: AND SR_INSTANCE_ID = lv_SR_INSTANCE_ID
473: AND OPERATION_SEQ_NUM = nvl(lv_OPERATION_SEQ_NUM,OPERATION_SEQ_NUM);

Line 609: UPDATE MSC_JOB_OPERATIONS

605: BEGIN
606:
607: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
608:
609: UPDATE MSC_JOB_OPERATIONS
610: SET
611: RECOMMENDED = lv_RECOMMENDED,
612: NETWORK_START_END = lv_NETWORK_START_END,
613: RECO_START_DATE = lv_RECO_START_DATE,

Line 680: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');

676:
677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
678: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
679: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
680: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
681: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
682:
683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
684: RAISE;

Line 693: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');

689:
690: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
691: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
692: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
693: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
694: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
695:
696: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
697: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

Line 710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Total MSC_JOB_OPERATIONS = '|| total_count);

706: END;
707:
708: END LOOP;
709:
710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Total MSC_JOB_OPERATIONS = '|| total_count);
711: END IF;
712:
713: CLOSE cgen;
714:

Line 725: ||' SELECT * from MSC_JOB_OPERATIONS'

721: lv_tbl:= 'JOB_OPERATIONS_'||MSC_CL_COLLECTION.v_instance_code;
722:
723: lv_sql_stmt:=
724: 'INSERT INTO '||lv_tbl
725: ||' SELECT * from MSC_JOB_OPERATIONS'
726: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
727: ||' AND plan_id = -1 '
728: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
729:

Line 747: 'MSC_JOB_OPERATIONS',

743:
744: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
745: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
746: lv_retcode,
747: 'MSC_JOB_OPERATIONS',
748: MSC_CL_COLLECTION.v_instance_code,
749: MSC_UTIL.G_WARNING
750: );
751: