APPS.BOM_OP_NETWORK_UTIL dependencies on BOM_OPERATIONAL_ROUTINGS

Line 417: * writes to the bom_operational_routings.

413: * Parameters OUT: Messgae Token Table
414: * Return Status
415: * Purpose : This is the only procedure that the user will have
416: * access to when he/she needs to perform any kind of
417: * writes to the bom_operational_routings.
418: *********************************************************************/
419: PROCEDURE Perform_Writes
420: ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
421: , p_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type

Line 518: from bom_operational_routings where

514: x_return_status := FND_API.G_RET_STS_SUCCESS;
515:
516: select routing_sequence_id, cfm_routing_flag
517: into l_routing_sequence_id,l_cfm_routing_flag
518: from bom_operational_routings where
519: routing_sequence_id = p_routing_sequence_id;
520: -- Get Common Routing Seq Id from System Info Rec.
521: -- If the value is Null, set Common Routing Seq Id.
522: l_common_routing_sequence_id := BOM_Rtg_Globals.Get_Common_Rtg_Seq_id ;

Line 529: FROM bom_operational_routings

525: l_common_routing_sequence_id = FND_API.G_MISS_NUM THEN
526: BEGIN
527: SELECT common_routing_sequence_id
528: INTO l_common_routing_sequence_id
529: FROM bom_operational_routings
530: WHERE routing_sequence_id = l_routing_sequence_id;
531: END ;
532: BOM_Rtg_Globals.Set_Common_Rtg_Seq_id
533: ( p_common_rtg_seq_id => l_common_routing_sequence_id );

Line 649: from bom_operational_routings where

645: assembly_item_id , organization_id
646: into l_routing_sequence_id,l_cfm_routing_flag,
647: l_rtg_comp_sub_inv , l_rtg_comp_sub_loc,
648: l_assembly_item_id , l_org_id
649: from bom_operational_routings where
650: routing_sequence_id = p_routing_sequence_id;
651:
652: -- Get Common Routing Seq Id from System Info Rec.
653: -- If the value is Null, set Common Routing Seq Id.

Line 661: FROM bom_operational_routings

657: l_common_routing_sequence_id = FND_API.G_MISS_NUM THEN
658: BEGIN
659: SELECT common_routing_sequence_id
660: INTO l_common_routing_sequence_id
661: FROM bom_operational_routings
662: WHERE routing_sequence_id = l_routing_sequence_id;
663: END ;
664: BOM_Rtg_Globals.Set_Common_Rtg_Seq_id
665: ( p_common_rtg_seq_id => l_common_routing_sequence_id );