APPS.ENG_REVISED_ITEMS_PKG dependencies on BOM_BILL_OF_MATERIALS

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

86: and revised_item_id = x_revised_item_id
87: and revised_item_sequence_id = x_revised_item_sequence_id
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

Line 97: delete from BOM_BILL_OF_MATERIALS bom

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

Line 111: from BOM_BILL_OF_MATERIALS bom2

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

Line 124: update BOM_BILL_OF_MATERIALS bom

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

Line 139: from BOM_BILL_OF_MATERIALS bom2

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

Line 158: from BOM_BILL_OF_MATERIALS bom

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

Line 204: insert into BOM_BILL_OF_MATERIALS (

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