eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.MSC_CL_ROUTING_ODS_LOAD dependencies on MSC_OPERATION_RESOURCE_SEQS

Line 1156: lv_tbl:= 'MSC_OPERATION_RESOURCE_SEQS';

1152:
1153: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1154: lv_tbl:= 'OPERATION_RESOURCE_SEQS_'||MSC_CL_COLLECTION.v_instance_code;
1155: ELSE
1156: lv_tbl:= 'MSC_OPERATION_RESOURCE_SEQS';
1157: END IF;
1158:
1159: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1160: -- We want to delete all BOM related data and get new stuff.

Line 1161: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);

1157: END IF;
1158:
1159: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1160: -- We want to delete all BOM related data and get new stuff.
1161: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);
1162:
1163: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1164: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1165: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);

Line 1165: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);

1161: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);
1162:
1163: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1164: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1165: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);
1166: ELSE
1167: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1168: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1169: END IF;

Line 1168: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

1164: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1165: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1);
1166: ELSE
1167: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1168: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCE_SEQS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1169: END IF;
1170: END IF;
1171:
1172: BEGIN

Line 1224: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCE_SEQS');

1220:
1221: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1222: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1223: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OP_RESOURCE_SEQ');
1224: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCE_SEQS');
1225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1226:
1227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1228: RAISE;

Line 1234: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCE_SEQS');

1230: ELSE
1231: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1232: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1233: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OP_RESOURCE_SEQ');
1234: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCE_SEQS');
1235: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1236:
1237: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1238:

Line 1290: DELETE MSC_OPERATION_RESOURCE_SEQS

1286:
1287: FOR c_rec IN c7_d LOOP
1288:
1289: IF c_rec.OPERATION_SEQUENCE_ID IS NOT NULL THEN
1290: DELETE MSC_OPERATION_RESOURCE_SEQS
1291: WHERE PLAN_ID= -1
1292: AND ROUTING_SEQUENCE_ID= c_rec.ROUTING_SEQUENCE_ID
1293: AND OPERATION_SEQUENCE_ID= c_rec.OPERATION_SEQUENCE_ID
1294: AND RESOURCE_SEQ_NUM= c_rec.RESOURCE_SEQ_NUM

Line 1297: DELETE MSC_OPERATION_RESOURCE_SEQS

1293: AND OPERATION_SEQUENCE_ID= c_rec.OPERATION_SEQUENCE_ID
1294: AND RESOURCE_SEQ_NUM= c_rec.RESOURCE_SEQ_NUM
1295: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;
1296: ELSE
1297: DELETE MSC_OPERATION_RESOURCE_SEQS
1298: WHERE PLAN_ID= -1
1299: AND ROUTING_SEQUENCE_ID= c_rec.ROUTING_SEQUENCE_ID
1300: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;
1301: END IF;

Line 1316: UPDATE MSC_OPERATION_RESOURCE_SEQS

1312: BEGIN
1313:
1314: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1315:
1316: UPDATE MSC_OPERATION_RESOURCE_SEQS
1317: SET
1318: SCHEDULE_FLAG= c_rec.SCHEDULE_FLAG,
1319: RESOURCE_OFFSET_PERCENT= c_rec.RESOURCE_OFFSET_PERCENT,
1320: DEPARTMENT_ID= c_rec.DEPARTMENT_ID,

Line 1374: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCE_SEQS');

1370:
1371: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1372: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1373: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OP_RESOURCE_SEQ');
1374: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCE_SEQS');
1375: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1376:
1377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1378: RAISE;

Line 1386: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCE_SEQS');

1382:
1383: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1384: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1385: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OP_RESOURCE_SEQ');
1386: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCE_SEQS');
1387: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1388:
1389: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1390: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');

Line 1422: ||' SELECT * from MSC_OPERATION_RESOURCE_SEQS'

1418: lv_tbl:= 'OPERATION_RESOURCE_SEQS_'||MSC_CL_COLLECTION.v_instance_code;
1419:
1420: lv_sql_stmt:=
1421: 'INSERT INTO '||lv_tbl
1422: ||' SELECT * from MSC_OPERATION_RESOURCE_SEQS'
1423: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1424: ||' AND plan_id = -1 '
1425: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
1426:

Line 1437: 'MSC_OPERATION_RESOURCE_SEQS',

1433:
1434: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1435: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1436: lv_retcode,
1437: 'MSC_OPERATION_RESOURCE_SEQS',
1438: MSC_CL_COLLECTION.v_instance_code,
1439: MSC_UTIL.G_WARNING
1440: );
1441: