APPS.ENG_REVISED_ITEMS_PKG dependencies on BOM_BILL_OF_MATERIALS

Line 92: /* Deletion from BOM_BILL_OF_MATERIALS is stopped from ENGFDECN form

88: and revised_item_id = x_revised_item_id
89: and revised_item_sequence_id = x_revised_item_sequence_id
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

Line 99: delete from BOM_BILL_OF_MATERIALS bom

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: /*
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

Line 113: from BOM_BILL_OF_MATERIALS bom2

109: (bic.change_notice = x_change_notice
110: and bic.revised_item_sequence_id <> x_revised_item_sequence_id)))
111: and ((bom.alternate_bom_designator is null
112: and not exists (select null
113: from BOM_BILL_OF_MATERIALS bom2
114: where bom2.organization_id = bom.organization_id
115: and bom2.assembly_item_id = bom.assembly_item_id
116: and bom2.alternate_bom_designator is not null))
117: or

Line 126: update BOM_BILL_OF_MATERIALS bom

122: and eri.bill_sequence_id = bom.bill_sequence_id
123: and eri.change_notice <> x_change_notice))
124: );
125: */
126: update BOM_BILL_OF_MATERIALS bom
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

Line 141: from BOM_BILL_OF_MATERIALS bom2

137: (bic.change_notice = x_change_notice
138: and bic.revised_item_sequence_id <> x_revised_item_sequence_id)))
139: and ((bom.alternate_bom_designator is null
140: and not exists (select null
141: from BOM_BILL_OF_MATERIALS bom2
142: where bom2.organization_id = bom.organization_id
143: and bom2.assembly_item_id = bom.assembly_item_id
144: and bom2.alternate_bom_designator is not null))
145: or

Line 160: from BOM_BILL_OF_MATERIALS bom

156: where bill_sequence_id = x_bill_sequence_id
157: and organization_id = x_organization_id
158: and implementation_date is null
159: and not exists (select null
160: from BOM_BILL_OF_MATERIALS bom
161: where bom.bill_sequence_id = x_bill_sequence_id);
162:
163: END Delete_Details;
164:

Line 206: insert into BOM_BILL_OF_MATERIALS (

202: from mtl_system_items
203: where inventory_item_id = x_assembly_item_id
204: and organization_id = x_organization_id;
205:
206: insert into BOM_BILL_OF_MATERIALS (
207: assembly_item_id,
208: organization_id,
209: alternate_BOM_designator,
210: last_update_date,