APPS.ENG_REVISED_ITEM_UTIL dependencies on BOM_INVENTORY_COMPONENTS

Line 280: FROM bom_inventory_components

276: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type := p_Mesg_Token_Tbl;
277:
278: CURSOR c_getRevisedComps IS
279: SELECT component_sequence_id
280: FROM bom_inventory_components
281: WHERE revised_item_sequence_id = rev_item_seq;
282:
283:
284: CURSOR c_getRevisedOps IS

Line 344: -- Delete the rows from bom_inventory_components

340: , p_login_id => login
341: );
342: END LOOP;
343:
344: -- Delete the rows from bom_inventory_components
345:
346: DELETE FROM bom_components_b --BOM_INVENTORY_COMPONENTS IC -- R12: Modified for common bom changes
347: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq;
348:

Line 346: DELETE FROM bom_components_b --BOM_INVENTORY_COMPONENTS IC -- R12: Modified for common bom changes

342: END LOOP;
343:
344: -- Delete the rows from bom_inventory_components
345:
346: DELETE FROM bom_components_b --BOM_INVENTORY_COMPONENTS IC -- R12: Modified for common bom changes
347: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq;
348:
349: -- Delete item revisions created by revised items on ECO
350: /* delete from MTL_ITEM_REVISIONS_TL

Line 373: FROM BOM_INVENTORY_COMPONENTS C

369: DELETE FROM BOM_BILL_OF_MATERIALS B
370: WHERE B.BILL_SEQUENCE_ID = bill_seq_id
371: AND B.PENDING_FROM_ECN = change_order
372: AND NOT EXISTS (SELECT NULL
373: FROM BOM_INVENTORY_COMPONENTS C
374: WHERE C.BILL_SEQUENCE_ID = B.BILL_SEQUENCE_ID
375: AND (C.REVISED_ITEM_SEQUENCE_ID IS NULL
376: OR C.REVISED_ITEM_SEQUENCE_ID <> rev_item_seq))
377: AND ( (B.ALTERNATE_BOM_DESIGNATOR IS NULL

Line 593: UPDATE bom_inventory_components

589: , p_revised_item_sequence_id NUMBER
590: )
591: IS
592: BEGIN
593: UPDATE bom_inventory_components
594: SET from_end_item_unit_number = p_new_from_end_item_number
595: WHERE revised_item_sequence_id = p_revised_item_sequence_id
596: AND implementation_date IS NOT NULL;
597: END Update_Component_Unit_Number;

Line 1501: UPDATE BOM_INVENTORY_COMPONENTS

1497: UPDATE BOM_OPERATION_SEQUENCES
1498: SET eco_for_production = p_revised_item_rec.eco_for_production
1499: WHERE revised_item_sequence_id = p_rev_item_unexp_rec.revised_item_sequence_id ;
1500:
1501: UPDATE BOM_INVENTORY_COMPONENTS
1502: SET eco_for_production = p_revised_item_rec.eco_for_production
1503: WHERE revised_item_sequence_id = p_rev_item_unexp_rec.revised_item_sequence_id ;
1504:
1505: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('After Updating Eco_For_Production in Rev Comps and Rev Ops'); END IF;

Line 2535: UPDATE BOM_INVENTORY_COMPONENTS bic

2531: AND revised_item_sequence_id = p_revised_item_sequence_id;
2532: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Updated '|| SQL%ROWCOUNT ||'rows for item revision effectivity'); END IF;
2533:
2534: -- update revised components EFFECTIVITY_DATE
2535: UPDATE BOM_INVENTORY_COMPONENTS bic
2536: SET bic.EFFECTIVITY_DATE = p_effectivity_date
2537: WHERE bic.CHANGE_NOTICE = l_rev_item.change_notice
2538: AND bic.revised_item_sequence_id = p_revised_item_sequence_id
2539: AND bic.bill_sequence_id = l_rev_item.bill_sequence_id

Line 2548: UPDATE BOM_INVENTORY_COMPONENTS bic1

2544: AND bic.IMPLEMENTATION_DATE IS NULL;
2545: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Updated '|| SQL%ROWCOUNT ||'rows for component effectivity' ); END IF;
2546:
2547: -- update revised components DISABLE_DATE
2548: UPDATE BOM_INVENTORY_COMPONENTS bic1
2549: SET bic1.DISABLE_DATE = p_effectivity_date
2550: WHERE bic1.CHANGE_NOTICE = l_rev_item.change_notice
2551: AND bic1.ACD_TYPE = 3 -- ACD Type: Disable
2552: AND revised_item_sequence_id = p_revised_item_sequence_id