APPS.ENG_REVISED_ITEMS_PKG dependencies on BOM_INVENTORY_COMPONENTS

Line 48: from BOM_INVENTORY_COMPONENTS

44: values (x_sequence_id, x_revised_item_id);
45:
46: insert into BOM_LISTS (sequence_id, assembly_item_id)
47: select distinct(x_sequence_id), component_item_id
48: from BOM_INVENTORY_COMPONENTS
49: where bill_sequence_id = x_bill_sequence_id;
50: END Insert_BOM_Lists;
51:
52:

Line 94: in bom_inventory_components,if an another session is open that is

90: and change_notice = x_change_notice;
91:
92: /* Deletion from BOM_BILL_OF_MATERIALS is stopped from ENGFDECN form
93: This was done to fix the bug 1381912 as this causes orphan records
94: in bom_inventory_components,if an another session is open that is
95: using same bill header for entering the components.Now we change the
96: column value of pending_from_ecn to null,instead of deleting records
97: from bom_bill_of_mterials */
98: /*

Line 103: from BOM_INVENTORY_COMPONENTS bic

99: delete from BOM_BILL_OF_MATERIALS bom
100: where bom.bill_sequence_id = x_bill_sequence_id
101: and bom.pending_from_ecn = x_change_notice
102: and not exists (select null
103: from BOM_INVENTORY_COMPONENTS bic
104: where bic.bill_sequence_id = bom.bill_sequence_id
105: and (bic.change_notice is null
106: or
107: bic.change_notice <> x_change_notice

Line 131: from BOM_INVENTORY_COMPONENTS bic

127: set pending_from_ecn = null
128: where bom.bill_sequence_id = x_bill_sequence_id
129: and bom.pending_from_ecn = x_change_notice
130: and not exists (select null
131: from BOM_INVENTORY_COMPONENTS bic
132: where bic.bill_sequence_id = bom.bill_sequence_id
133: and (bic.change_notice is null
134: or
135: bic.change_notice <> x_change_notice

Line 613: update BOM_INVENTORY_COMPONENTS

609: OR bcb.common_component_sequence_id = bcb.component_sequence_id)
610: AND bcb.IMPLEMENTATION_DATE IS NULL;
611:
612: BEGIN
613: update BOM_INVENTORY_COMPONENTS
614: set effectivity_date = x_scheduled_date,
615: from_end_item_unit_number = x_from_end_item_unit_number,
616: last_update_date = sysdate, --Bug 9240045 fix
617: last_updated_by = BOM_Globals.Get_User_Id, --Bug 9240045 fix

Line 628: update BOM_INVENTORY_COMPONENTS

624: -- This is to ensure that the destination bill's revised item
625: -- reschedule doesnt affect its components effectivity date
626: and implementation_date is null;
627:
628: update BOM_INVENTORY_COMPONENTS
629: set disable_date = x_scheduled_date
630: where change_notice = x_change_notice
631: and bill_sequence_id = x_bill_sequence_id
632: and revised_item_sequence_id = x_revised_item_sequence_id

Line 640: update BOM_INVENTORY_COMPONENTS

636: --Bug 9238945 fix
637: --Because of R12 common bom enhancement, ecos can be created in dependent orgs
638: -- where material info can be changed. The following update statement updates the
639: --effectivity date of inventory components in such ecos
640: update BOM_INVENTORY_COMPONENTS
641: set effectivity_date = x_scheduled_date,
642: from_end_item_unit_number = x_from_end_item_unit_number,
643: last_update_date = sysdate,
644: last_updated_by = BOM_Globals.Get_User_Id,