APPS.BOM_RTG_HEADER_UTIL dependencies on BOM_OPERATIONAL_ROUTINGS

Line 116: FROM bom_operational_routings

112: , l_rtg_header_rec.attribute12
113: , l_rtg_header_rec.attribute13
114: , l_rtg_header_rec.attribute14
115: , l_rtg_header_rec.attribute15
116: FROM bom_operational_routings
117: WHERE assembly_item_id = p_assembly_item_id
118: AND organization_id = p_organization_id
119: AND NVL(alternate_routing_designator, FND_API.G_MISS_CHAR )
120: = NVL( p_alternate_routing_code, FND_API.G_MISS_CHAR )

Line 161: INSERT INTO bom_operational_routings

157:
158: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Writing Rtg Header rec for ' || p_rtg_header_rec.assembly_item_name); END IF;
159:
160: --bug:3254815 Update request id, prog id, prog appl id and prog update date.
161: INSERT INTO bom_operational_routings
162: ( assembly_item_id
163: , organization_id
164: , alternate_routing_designator
165: , common_assembly_item_id

Line 347: UPDATE bom_operational_routings

343: Error_Handler.Write_Debug('Updating routing seq '
344: || p_rtg_header_unexp_rec.routing_sequence_id);
345: END IF;
346:
347: UPDATE bom_operational_routings
348: SET common_assembly_item_id =
349: p_rtg_header_unexp_rec.common_assembly_item_id
350: , common_routing_sequence_id =
351: p_rtg_header_unexp_rec.common_routing_sequence_id

Line 511: * writes to the bom_operational_routings.

507: * Parameters out: Messgae Token Table
508: * Return Status
509: * Purpose : This is the only procedure that the user will have
510: * access to when he/she needs to perform any kind of
511: * writes to the bom_operational_routings.
512: *********************************************************************/
513: PROCEDURE Perform_Writes
514: ( p_rtg_header_rec IN Bom_Rtg_Pub.rtg_header_Rec_Type
515: , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.rtg_header_Unexposed_Rec_Type