APPS.ENG_REVISED_ITEMS_PKG dependencies on BOM_INVENTORY_COMPONENTS

Line 46: from BOM_INVENTORY_COMPONENTS

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

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

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

Line 101: from BOM_INVENTORY_COMPONENTS bic

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

Line 129: from BOM_INVENTORY_COMPONENTS bic

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

Line 611: update BOM_INVENTORY_COMPONENTS

607: OR bcb.common_component_sequence_id = bcb.component_sequence_id)
608: AND bcb.IMPLEMENTATION_DATE IS NULL;
609:
610: BEGIN
611: update BOM_INVENTORY_COMPONENTS
612: set effectivity_date = x_scheduled_date,
613: from_end_item_unit_number = x_from_end_item_unit_number
614: where change_notice = x_change_notice
615: and bill_sequence_id = x_bill_sequence_id

Line 623: update BOM_INVENTORY_COMPONENTS

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