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.

APPS.MSC_CL_BOM_ODS_LOAD dependencies on MSC_PROCESS_EFFECTIVITY

Line 1243: FROM MSC_PROCESS_EFFECTIVITY mpe,

1239: mpe.ROUTING_SEQUENCE_ID,
1240: mpe.BILL_SEQUENCE_ID,
1241: TO_NUMBER(NULL),
1242: mpe.SR_INSTANCE_ID
1243: FROM MSC_PROCESS_EFFECTIVITY mpe,
1244: MSC_ST_PROCESS_EFFECTIVITY mspe
1245: WHERE mspe.Bill_Sequence_ID= mpe.Bill_Sequence_ID
1246: AND mspe.Routing_Sequence_ID <> mpe.Routing_Sequence_ID
1247: AND mspe.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 1278: DELETE MSC_PROCESS_EFFECTIVITY

1274:
1275: -- deleting if the record already existed.
1276: FOR c_rec IN c_del_leg LOOP
1277:
1278: DELETE MSC_PROCESS_EFFECTIVITY
1279: WHERE PLAN_ID= -1
1280: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1281: AND ( ROUTING_SEQUENCE_ID = c_rec.ROUTING_SEQUENCE_ID
1282: OR BILL_SEQUENCE_ID= c_rec.BILL_SEQUENCE_ID );

Line 1293: lv_sql_stmt1 := ' DELETE MSC_PROCESS_EFFECTIVITY '

1289: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1290:
1291: FOR c_rec IN c8_d LOOP
1292: ---5470477
1293: lv_sql_stmt1 := ' DELETE MSC_PROCESS_EFFECTIVITY '
1294: ||' WHERE PLAN_ID= -1 '
1295: ||' AND SR_INSTANCE_ID= :SR_INSTANCE_ID ';
1296:
1297: BEGIN --- To use bind variables as far as possible

Line 1355: DELETE MSC_PROCESS_EFFECTIVITY

1351: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'LINE_ID: ' || c_rec.LINE_ID);
1352: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '-----------------------------');
1353: END;
1354: /*
1355: DELETE MSC_PROCESS_EFFECTIVITY
1356: WHERE PLAN_ID= -1
1357: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
1358: AND ( ( ITEM_ID= c_rec.INVENTORY_ITEM_ID
1359: AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID

Line 1378: UPDATE MSC_PROCESS_EFFECTIVITY

1374: BEGIN
1375:
1376: /* bug 1244578 fix */
1377:
1378: UPDATE MSC_PROCESS_EFFECTIVITY
1379: SET
1380: MINIMUM_QUANTITY= c_rec.MINIMUM_QUANTITY,
1381: MAXIMUM_QUANTITY= c_rec.MAXIMUM_QUANTITY,
1382: PREFERENCE= c_rec.PREFERENCE,

Line 1410: INSERT INTO MSC_PROCESS_EFFECTIVITY

1406: AND c_rec.LINE_ID IS NULL));
1407:
1408: IF SQL%NOTFOUND THEN
1409:
1410: INSERT INTO MSC_PROCESS_EFFECTIVITY
1411: ( PLAN_ID,
1412: PROCESS_SEQUENCE_ID,
1413: ITEM_ID,
1414: ORGANIZATION_ID,

Line 1437: MSC_PROCESS_EFFECTIVITY_S.NEXTVAL,

1433: CREATION_DATE,
1434: CREATED_BY)
1435: VALUES
1436: ( -1,
1437: MSC_PROCESS_EFFECTIVITY_S.NEXTVAL,
1438: c_rec.INVENTORY_ITEM_ID,
1439: c_rec.ORGANIZATION_ID,
1440: c_rec.EFFECTIVITY_DATE,
1441: c_rec.DISABLE_DATE,

Line 1478: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');

1474:
1475: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1476: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1477: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1478: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1479: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1480:
1481: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1482: RAISE;

Line 1490: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');

1486:
1487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1488: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1489: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROCESS_EFFECTIVITY');
1490: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROCESS_EFFECTIVITY');
1491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1492:
1493: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1494: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

Line 1526: /* DELETE MSC_PROCESS_EFFECTIVITY

1522: /* if it's complete refresh, delete the old records after the insert/update */
1523: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1524: -- We want to delete all BOM related data and get new stuff.
1525:
1526: /* DELETE MSC_PROCESS_EFFECTIVITY
1527: WHERE PLAN_ID= -1
1528: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1529: AND REFRESH_NUMBER <> MSC_CL_COLLECTION.v_last_collection_id; */
1530:

Line 1533: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROCESS_EFFECTIVITY', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

1529: AND REFRESH_NUMBER <> MSC_CL_COLLECTION.v_last_collection_id; */
1530:
1531: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1532: v_sub_str :='AND REFRESH_NUMBER <>'||MSC_CL_COLLECTION.v_last_collection_id;
1533: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROCESS_EFFECTIVITY', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1534: ELSE
1535: v_sub_str :=' AND ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1536: ||' AND REFRESH_NUMBER <>'||MSC_CL_COLLECTION.v_last_collection_id;
1537: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROCESS_EFFECTIVITY', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line 1537: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROCESS_EFFECTIVITY', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

1533: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROCESS_EFFECTIVITY', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1534: ELSE
1535: v_sub_str :=' AND ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1536: ||' AND REFRESH_NUMBER <>'||MSC_CL_COLLECTION.v_last_collection_id;
1537: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROCESS_EFFECTIVITY', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1538: END IF;
1539:
1540:
1541: