APPS.MSC_CL_WIP_ODS_LOAD dependencies on MSC_JOB_OP_RESOURCES

Line 826: lv_tbl:= 'MSC_JOB_OP_RESOURCES';

822: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
823: lv_tbl:= 'JOB_OP_RESOURCES_'||MSC_CL_COLLECTION.v_instance_code;
824: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
825: ELSE
826: lv_tbl:= 'MSC_JOB_OP_RESOURCES';
827: lv_supplies_tbl:= 'MSC_SUPPLIES';
828: END IF;
829:
830: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

Line 861: DELETE MSC_JOB_OP_RESOURCES

857: lv_SR_INSTANCE_ID;
858:
859: EXIT WHEN cgen%NOTFOUND;
860:
861: DELETE MSC_JOB_OP_RESOURCES
862: WHERE PLAN_ID= -1
863: AND TRANSACTION_ID = lv_TRANSACTION_ID
864: AND SR_INSTANCE_ID = lv_SR_INSTANCE_ID
865: AND OPERATION_SEQ_NUM = nvl(lv_OPERATION_SEQ_NUM,OPERATION_SEQ_NUM)

Line 1032: UPDATE MSC_JOB_OP_RESOURCES

1028: BEGIN
1029:
1030: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1031:
1032: UPDATE MSC_JOB_OP_RESOURCES
1033: SET
1034: RECOMMENDED = lv_RECOMMENDED,
1035: RECO_START_DATE = lv_RECO_START_DATE,
1036: RECO_COMPLETION_DATE = lv_RECO_COMPLETION_DATE,

Line 1117: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');

1113:
1114: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1115: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1116: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1117: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1119:
1120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1121: RAISE;

Line 1130: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');

1126:
1127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1128: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1129: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1130: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1131: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1132:
1133: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1134: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

Line 1146: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Total MSC_JOB_OP_RESOURCES = '|| total_count);

1142:
1143: END;
1144: END LOOP;
1145:
1146: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Total MSC_JOB_OP_RESOURCES = '|| total_count);
1147: END IF;
1148:
1149: CLOSE cgen;
1150:

Line 1161: ||' SELECT * from MSC_JOB_OP_RESOURCES'

1157: lv_tbl:= 'JOB_OP_RESOURCES_'||MSC_CL_COLLECTION.v_instance_code;
1158:
1159: lv_sql_stmt:=
1160: 'INSERT INTO '||lv_tbl
1161: ||' SELECT * from MSC_JOB_OP_RESOURCES'
1162: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1163: ||' AND plan_id = -1 '
1164: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
1165:

Line 1183: 'MSC_JOB_OP_RESOURCES',

1179:
1180: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1181: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1182: lv_retcode,
1183: 'MSC_JOB_OP_RESOURCES',
1184: MSC_CL_COLLECTION.v_instance_code,
1185: MSC_UTIL.G_WARNING
1186: );
1187: