APPS.ENG_REVISED_ITEM_UTIL dependencies on BOM_INVENTORY_COMPONENTS

Line 297: FROM bom_inventory_components

293: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type := p_Mesg_Token_Tbl;
294:
295: CURSOR c_getRevisedComps IS
296: SELECT component_sequence_id
297: FROM bom_inventory_components
298: WHERE revised_item_sequence_id = rev_item_seq;
299:
300:
301: CURSOR c_getRevisedOps IS

Line 361: -- Delete the rows from bom_inventory_components

357: , p_login_id => login
358: );
359: END LOOP;
360:
361: -- Delete the rows from bom_inventory_components
362:
363: DELETE FROM bom_components_b --BOM_INVENTORY_COMPONENTS IC -- R12: Modified for common bom changes
364: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq;
365:

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

359: END LOOP;
360:
361: -- Delete the rows from bom_inventory_components
362:
363: DELETE FROM bom_components_b --BOM_INVENTORY_COMPONENTS IC -- R12: Modified for common bom changes
364: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq;
365:
366: -- Delete item revisions created by revised items on ECO
367: /* delete from MTL_ITEM_REVISIONS_TL

Line 390: FROM BOM_INVENTORY_COMPONENTS C

386: DELETE FROM BOM_BILL_OF_MATERIALS B
387: WHERE B.BILL_SEQUENCE_ID = bill_seq_id
388: AND B.PENDING_FROM_ECN = change_order
389: AND NOT EXISTS (SELECT NULL
390: FROM BOM_INVENTORY_COMPONENTS C
391: WHERE C.BILL_SEQUENCE_ID = B.BILL_SEQUENCE_ID
392: AND (C.REVISED_ITEM_SEQUENCE_ID IS NULL
393: OR C.REVISED_ITEM_SEQUENCE_ID <> rev_item_seq))
394: AND ( (B.ALTERNATE_BOM_DESIGNATOR IS NULL

Line 610: UPDATE bom_inventory_components

606: , p_revised_item_sequence_id NUMBER
607: )
608: IS
609: BEGIN
610: UPDATE bom_inventory_components
611: SET from_end_item_unit_number = p_new_from_end_item_number
612: WHERE revised_item_sequence_id = p_revised_item_sequence_id
613: AND implementation_date IS NOT NULL;
614: END Update_Component_Unit_Number;

Line 1519: UPDATE BOM_INVENTORY_COMPONENTS

1515: UPDATE BOM_OPERATION_SEQUENCES
1516: SET eco_for_production = p_revised_item_rec.eco_for_production
1517: WHERE revised_item_sequence_id = p_rev_item_unexp_rec.revised_item_sequence_id ;
1518:
1519: UPDATE BOM_INVENTORY_COMPONENTS
1520: SET eco_for_production = p_revised_item_rec.eco_for_production
1521: WHERE revised_item_sequence_id = p_rev_item_unexp_rec.revised_item_sequence_id ;
1522:
1523: 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 2559: UPDATE BOM_INVENTORY_COMPONENTS bic

2555: AND revised_item_sequence_id = p_revised_item_sequence_id;
2556: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Updated '|| SQL%ROWCOUNT ||'rows for item revision effectivity'); END IF;
2557:
2558: -- update revised components EFFECTIVITY_DATE
2559: UPDATE BOM_INVENTORY_COMPONENTS bic
2560: SET bic.EFFECTIVITY_DATE = p_effectivity_date
2561: WHERE bic.CHANGE_NOTICE = l_rev_item.change_notice
2562: AND bic.revised_item_sequence_id = p_revised_item_sequence_id
2563: AND bic.bill_sequence_id = l_rev_item.bill_sequence_id

Line 2572: UPDATE BOM_INVENTORY_COMPONENTS bic1

2568: AND bic.IMPLEMENTATION_DATE IS NULL;
2569: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Updated '|| SQL%ROWCOUNT ||'rows for component effectivity' ); END IF;
2570:
2571: -- update revised components DISABLE_DATE
2572: UPDATE BOM_INVENTORY_COMPONENTS bic1
2573: SET bic1.DISABLE_DATE = p_effectivity_date
2574: WHERE bic1.CHANGE_NOTICE = l_rev_item.change_notice
2575: AND bic1.ACD_TYPE = 3 -- ACD Type: Disable
2576: AND revised_item_sequence_id = p_revised_item_sequence_id