APPS.BOM_BILL_OF_MATLS_PKG dependencies on BOM_BILL_OF_MATERIALS

Line 24: From bom_bill_of_materials bom,

20: bom.common_assembly_item_id,
21: bom.common_organization_id,
22: msi.base_item_id,
23: bom.source_bill_sequence_id
24: From bom_bill_of_materials bom,
25: mtl_system_items msi
26: Where bom.bill_sequence_id = P_Bill_Sequence_id
27: and msi.inventory_item_id = bom.assembly_item_id
28: and msi.organization_id = bom.organization_id;

Line 120: (SELECT 1 FROM bom_bill_of_materials

116: dummy NUMBER;
117: BEGIN
118: SELECT 1 INTO dummy FROM dual
119: WHERE not exists
120: (SELECT 1 FROM bom_bill_of_materials
121: WHERE assembly_item_id = X_Assembly_item_id
122: AND nvl(alternate_bom_designator,'no alt') =
123: nvl(X_alternate_bom_designator,'no alt')
124: AND organization_id = X_organization_id

Line 174: CURSOR C IS SELECT rowid FROM BOM_BILL_OF_MATERIALS

170:
171: ) IS
172: l_preferred_flag Varchar2(1);
173: x_err_text varchar2(2000);
174: CURSOR C IS SELECT rowid FROM BOM_BILL_OF_MATERIALS
175: WHERE bill_sequence_id = X_Bill_Sequence_Id;
176: CURSOR C2 IS SELECT bom_inventory_components_s.nextval FROM sys.dual;
177: BEGIN
178: if (X_Bill_Sequence_Id is NULL) then

Line 188: FROM bom_bill_of_materials

184: X_Common_Bill_Sequence_Id := X_Bill_Sequence_Id;
185: ELSE
186: SELECT bill_sequence_id
187: INTO X_Common_Bill_Sequence_Id
188: FROM bom_bill_of_materials
189: WHERE organization_id = X_Common_Organization_Id
190: AND bill_sequence_id = common_bill_sequence_id
191: AND assembly_item_id = X_Common_Assembly_Item_Id
192: AND NVL(alternate_bom_designator, 'NONE') =

Line 201: INSERT INTO BOM_BILL_OF_MATERIALS

197: p_organization_id => X_Organization_Id,
198: p_alternate_bom_code => X_Alternate_Bom_Designator,
199: x_err_text => x_err_text);
200:
201: INSERT INTO BOM_BILL_OF_MATERIALS
202: ( assembly_item_id,
203: organization_id,
204: alternate_bom_designator,
205: last_update_date,

Line 346: FROM BOM_BILL_OF_MATERIALS

342: X_implementation_date DATE := NULL
343: ) IS
344: CURSOR C IS
345: SELECT *
346: FROM BOM_BILL_OF_MATERIALS
347: WHERE rowid = X_Rowid
348: FOR UPDATE of Bill_Sequence_Id NOWAIT;
349: Recinfo C%ROWTYPE;
350:

Line 492: FROM bom_bill_of_materials

488: X_Common_Bill_Sequence_Id := X_Bill_Sequence_Id;
489: ELSE
490: SELECT bill_sequence_id
491: INTO X_Common_Bill_Sequence_Id
492: FROM bom_bill_of_materials
493: WHERE organization_id = X_Common_Organization_Id
494: AND bill_sequence_id = common_bill_sequence_id
495: AND assembly_item_id = X_Common_Assembly_Item_Id
496: AND NVL(alternate_bom_designator, 'NONE') =

Line 500: UPDATE BOM_BILL_OF_MATERIALS

496: AND NVL(alternate_bom_designator, 'NONE') =
497: NVL(X_Alternate_Bom_Designator,'NONE');
498: END IF;
499:
500: UPDATE BOM_BILL_OF_MATERIALS
501: SET
502: assembly_item_id = X_Assembly_Item_Id,
503: organization_id = X_Organization_Id,
504: alternate_bom_designator = X_Alternate_Bom_Designator,

Line 542: FROM bom_bill_of_materials

538: Raise NO_DATA_FOUND;
539: end if;
540:
541: SELECT creation_date,created_by INTO l_creation_date,l_created_by
542: FROM bom_bill_of_materials
543: WHERE organization_id = X_Organization_Id
544: AND bill_sequence_id = X_Bill_Sequence_Id
545: AND assembly_item_id = X_Assembly_Item_Id
546: AND NVL(alternate_bom_designator, 'NONE') =

Line 578: DELETE FROM BOM_BILL_OF_MATERIALS

574: l_specific_assembly_comment VARCHAR2(240);
575: -- bill_seq_id NUMBER; -- 4306013
576:
577: BEGIN
578: DELETE FROM BOM_BILL_OF_MATERIALS
579: WHERE rowid = X_Rowid;
580:
581: -- Getting the structure name and comments to raise the business event
582: -- SELECT bbm.Organization_Id, bbm.Assembly_Item_Id, bbm.Alternate_Bom_Designator, specific_assembly_comment

Line 584: -- FROM Bom_Bill_Of_Materials bbm

580:
581: -- Getting the structure name and comments to raise the business event
582: -- SELECT bbm.Organization_Id, bbm.Assembly_Item_Id, bbm.Alternate_Bom_Designator, specific_assembly_comment
583: -- INTO l_Organization_Id, l_Assembly_Item_Id, l_Structure_Name, l_specific_assembly_comment
584: -- FROM Bom_Bill_Of_Materials bbm
585: -- WHERE rowid = X_Rowid;
586:
587: -- SELECT bill_sequence_id into bill_seq_id
588: -- from bom_structures_b