APPS.MSC_CL_WIP_ODS_LOAD dependencies on MSC_JOB_OP_RESOURCES

Line 851: lv_tbl:= 'MSC_JOB_OP_RESOURCES';

847: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
848: lv_tbl:= 'JOB_OP_RESOURCES_'||MSC_CL_COLLECTION.v_instance_code;
849: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
850: ELSE
851: lv_tbl:= 'MSC_JOB_OP_RESOURCES';
852: lv_supplies_tbl:= 'MSC_SUPPLIES';
853: END IF;
854:
855: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

Line 886: DELETE MSC_JOB_OP_RESOURCES

882: lv_SR_INSTANCE_ID;
883:
884: EXIT WHEN cgen%NOTFOUND;
885:
886: DELETE MSC_JOB_OP_RESOURCES
887: WHERE PLAN_ID= -1
888: AND TRANSACTION_ID = lv_TRANSACTION_ID
889: AND SR_INSTANCE_ID = lv_SR_INSTANCE_ID
890: AND OPERATION_SEQ_NUM = nvl(lv_OPERATION_SEQ_NUM,OPERATION_SEQ_NUM)

Line 1057: UPDATE MSC_JOB_OP_RESOURCES

1053: BEGIN
1054:
1055: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1056:
1057: UPDATE MSC_JOB_OP_RESOURCES
1058: SET
1059: RECOMMENDED = lv_RECOMMENDED,
1060: RECO_START_DATE = lv_RECO_START_DATE,
1061: RECO_COMPLETION_DATE = lv_RECO_COMPLETION_DATE,

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

1138:
1139: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1140: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1141: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1142: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1143: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1144:
1145: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1146: RAISE;

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

1151:
1152: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1153: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1154: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1155: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1157:
1158: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1159: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

1167:
1168: END;
1169: END LOOP;
1170:
1171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Total MSC_JOB_OP_RESOURCES = '|| total_count);
1172: END IF;
1173:
1174: CLOSE cgen;
1175:

Line 1186: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_JOB_OP_RESOURCES'

1182: lv_tbl:= 'JOB_OP_RESOURCES_'||MSC_CL_COLLECTION.v_instance_code;
1183:
1184: lv_sql_stmt:=
1185: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
1186: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_JOB_OP_RESOURCES'
1187: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1188: ||' AND plan_id = -1 '
1189: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
1190:

Line 1208: 'MSC_JOB_OP_RESOURCES',

1204:
1205: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1206: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1207: lv_retcode,
1208: 'MSC_JOB_OP_RESOURCES',
1209: MSC_CL_COLLECTION.v_instance_code,
1210: MSC_UTIL.G_WARNING
1211: );
1212: