APPS.MSC_CL_WIP_ODS_LOAD dependencies on MSC_JOB_OPERATIONS

Line 441: lv_tbl:= 'MSC_JOB_OPERATIONS';

437: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
438: lv_tbl:= 'JOB_OPERATIONS_'||MSC_CL_COLLECTION.v_instance_code;
439: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
440: ELSE
441: lv_tbl:= 'MSC_JOB_OPERATIONS';
442: lv_supplies_tbl:= 'MSC_SUPPLIES';
443: END IF;
444:
445: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

Line 474: DELETE MSC_JOB_OPERATIONS

470: lv_SR_INSTANCE_ID;
471:
472: EXIT WHEN cgen%NOTFOUND;
473:
474: DELETE MSC_JOB_OPERATIONS
475: WHERE PLAN_ID= -1
476: AND TRANSACTION_ID = lv_TRANSACTION_ID
477: AND SR_INSTANCE_ID = lv_SR_INSTANCE_ID
478: AND OPERATION_SEQ_NUM = nvl(lv_OPERATION_SEQ_NUM,OPERATION_SEQ_NUM);

Line 630: UPDATE MSC_JOB_OPERATIONS

626: BEGIN
627:
628: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
629:
630: UPDATE MSC_JOB_OPERATIONS
631: SET
632: RECOMMENDED = lv_RECOMMENDED,
633: NETWORK_START_END = lv_NETWORK_START_END,
634: RECO_START_DATE = lv_RECO_START_DATE,

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

701:
702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
703: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
704: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
705: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
707:
708: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
709: RAISE;

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

714:
715: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
716: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
717: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
718: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
719: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
720:
721: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
722: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

731: END;
732:
733: END LOOP;
734:
735: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Total MSC_JOB_OPERATIONS = '|| total_count);
736: END IF;
737:
738: CLOSE cgen;
739:

Line 750: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_JOB_OPERATIONS'

746: lv_tbl:= 'JOB_OPERATIONS_'||MSC_CL_COLLECTION.v_instance_code;
747:
748: lv_sql_stmt:=
749: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
750: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_JOB_OPERATIONS'
751: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
752: ||' AND plan_id = -1 '
753: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
754:

Line 772: 'MSC_JOB_OPERATIONS',

768:
769: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
770: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
771: lv_retcode,
772: 'MSC_JOB_OPERATIONS',
773: MSC_CL_COLLECTION.v_instance_code,
774: MSC_UTIL.G_WARNING
775: );
776: