APPS.BOM_BOM_HEADER_UTIL dependencies on BOM_BILL_OF_MATERIALS

Line 24: -- bom_structures_b instead of bom_bill_of_materials.

20: -- 19-Aug-2003 Hari Gelli added obj_name, pk1_value, pk2_value in insert_row
21: -- 06-Feb-2004 Vani added Is_Preferred Flag for inserts
22: -- 11-JAN-2005 Vani added effectivity control in Insert_Row
23: -- 21-FEB-2005 Vani added query_table_row method to query from
24: -- bom_structures_b instead of bom_bill_of_materials.
25: -- 06-MAY-2005 Abhsihek Rudresh Common BOM Attrs Update
26: -- 13-JUL-06 Bhavnesh Patel Added support for Structure Type
27: ****************************************************************************/
28:

Line 122: FROM bom_bill_of_materials

118: , l_bom_head_unexp_rec.common_bill_sequence_id
119: , l_bom_head_unexp_rec.bill_sequence_id
120: , l_bom_head_unexp_rec.structure_type_id
121: , l_bom_header_rec.bom_implementation_date
122: FROM bom_bill_of_materials
123: WHERE assembly_item_id = p_assembly_item_id
124: AND organization_id = p_organization_id
125: AND effectivity_control <>4 -- Rev effective structures should be filtered.
126: AND NVL(alternate_bom_designator, 'XXXX') =

Line 268: * BOM_Bill_Of_Materials table thus creating a new bill

264: * BOM Header unexposed column record
265: * Parameters OUT: Message Token Table
266: * Return Status
267: * Purpose : Procedure will perfrom an insert into the
268: * BOM_Bill_Of_Materials table thus creating a new bill
269: *********************************************************************/
270: PROCEDURE Insert_Row
271: ( p_bom_header_rec IN BOM_Bo_Pub.Bom_Head_Rec_Type
272: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type

Line 294: INSERT INTO bom_bill_of_materials

290: p_alternate_bom_code => p_bom_header_rec.alternate_bom_code,
291: x_err_text => x_err_text);
292:
293: --bug:3254815 Update request id, prog id, prog appl id and prog update date.
294: INSERT INTO bom_bill_of_materials
295: ( assembly_item_id
296: , organization_id
297: , alternate_bom_designator
298: , common_assembly_item_id

Line 444: * BOM_Bill_Of_Materials table.

440: * BOM Header unexposed column record
441: * Parameters OUT: Message Token Table
442: * Return Status
443: * Purpose : Procedure will perfrom an Update into the
444: * BOM_Bill_Of_Materials table.
445: *********************************************************************/
446: PROCEDURE Update_Row
447: ( p_bom_header_rec IN BOM_Bo_Pub.Bom_Head_Rec_Type
448: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type

Line 463: UPDATE bom_bill_of_materials

459: IF Bom_Globals.Get_Debug = 'Y' THEN
460: Error_Handler.Write_Debug('Updating bill seq ' || p_bom_head_unexp_rec.bill_sequence_id);
461: END IF;
462:
463: UPDATE bom_bill_of_materials
464: SET common_assembly_item_id =
465: DECODE(p_bom_head_unexp_rec.common_assembly_item_id,
466: FND_API.G_MISS_NUM,
467: null,

Line 548: * BOM_Bill_Of_Materials by creating a delete Group.

544: * BOM Header unexposed column record
545: * Parameters OUT: Message Token Table
546: * Return Status
547: * Purpose : Procedure will perfrom an Delete from the
548: * BOM_Bill_Of_Materials by creating a delete Group.
549: *********************************************************************/
550: PROCEDURE Delete_Row
551: ( p_bom_header_rec IN BOM_Bo_Pub.Bom_Head_Rec_Type
552: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type

Line 645: * writes to the bom_bill_of_materials table.

641: * Parameters OUT: Messgae Token Table
642: * Return Status
643: * Purpose : This is the only procedure that the user will have
644: * access to when he/she needs to perform any kind of
645: * writes to the bom_bill_of_materials table.
646: *********************************************************************/
647: PROCEDURE Perform_Writes
648: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
649: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type