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 458: FROM bom_bill_of_materials

454: -- Added for bug 8208327
455: CURSOR c_CheckCommon IS
456: SELECT NVL(common_bill_sequence_id,bill_sequence_id) common_bill_seq,
457: bill_sequence_id
458: FROM bom_bill_of_materials
459: WHERE bill_sequence_id = p_bom_head_unexp_rec.bill_sequence_id;
460:
461: l_is_common_bom BOOLEAN := FALSE;
462: -- End Added for bug 8208327

Line 488: UPDATE bom_bill_of_materials

484: --If bom is common bom, then do not update commmon_assembly_item_id, common_organization_id,
485: --and common_bill_sequence_id.
486:
487: IF l_is_common_bom = TRUE THEN
488: UPDATE bom_bill_of_materials
489: SET specific_assembly_comment =
490: DECODE(p_bom_header_rec.assembly_comment,
491: FND_API.G_MISS_CHAR,
492: NULL,

Line 531: UPDATE bom_bill_of_materials

527: --If bom is not a common bom, then update commmon_assembly_item_id, common_organization_id,
528: --and common_bill_sequence_id.
529: ELSE
530:
531: UPDATE bom_bill_of_materials
532: SET common_assembly_item_id =
533: DECODE(p_bom_head_unexp_rec.common_assembly_item_id,
534: FND_API.G_MISS_NUM,
535: null,

Line 618: * BOM_Bill_Of_Materials by creating a delete Group.

614: * BOM Header unexposed column record
615: * Parameters OUT: Message Token Table
616: * Return Status
617: * Purpose : Procedure will perfrom an Delete from the
618: * BOM_Bill_Of_Materials by creating a delete Group.
619: *********************************************************************/
620: PROCEDURE Delete_Row
621: ( p_bom_header_rec IN BOM_Bo_Pub.Bom_Head_Rec_Type
622: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type

Line 715: * writes to the bom_bill_of_materials table.

711: * Parameters OUT: Messgae Token Table
712: * Return Status
713: * Purpose : This is the only procedure that the user will have
714: * access to when he/she needs to perform any kind of
715: * writes to the bom_bill_of_materials table.
716: *********************************************************************/
717: PROCEDURE Perform_Writes
718: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
719: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type