26: g_LoginId number;
27: g_RequestId number;
28: g_ProgramId number;
29: g_ApplicationId number;
30: g_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
31: g_rtg_revs_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
32: g_op_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
33: g_op_res_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
34: g_sub_op_res_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
27: g_RequestId number;
28: g_ProgramId number;
29: g_ApplicationId number;
30: g_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
31: g_rtg_revs_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
32: g_op_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
33: g_op_res_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
34: g_sub_op_res_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
35: g_nwk_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
28: g_ProgramId number;
29: g_ApplicationId number;
30: g_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
31: g_rtg_revs_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
32: g_op_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
33: g_op_res_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
34: g_sub_op_res_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
35: g_nwk_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
36:
29: g_ApplicationId number;
30: g_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
31: g_rtg_revs_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
32: g_op_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
33: g_op_res_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
34: g_sub_op_res_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
35: g_nwk_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
36:
37: --for updating interface tables
30: g_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
31: g_rtg_revs_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
32: g_op_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
33: g_op_res_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
34: g_sub_op_res_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
35: g_nwk_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
36:
37: --for updating interface tables
38: g_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type;
31: g_rtg_revs_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
32: g_op_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
33: g_op_res_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
34: g_sub_op_res_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
35: g_nwk_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
36:
37: --for updating interface tables
38: g_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type;
39: g_op_rec Bom_Rtg_Pub.Operation_Rec_Type;
34: g_sub_op_res_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
35: g_nwk_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
36:
37: --for updating interface tables
38: g_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type;
39: g_op_rec Bom_Rtg_Pub.Operation_Rec_Type;
40: g_op_res_rec Bom_Rtg_Pub.Op_Resource_Rec_Type;
41: g_sub_op_res_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type;
42: g_nwk_rec Bom_Rtg_Pub.Op_Network_Rec_Type;
35: g_nwk_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
36:
37: --for updating interface tables
38: g_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type;
39: g_op_rec Bom_Rtg_Pub.Operation_Rec_Type;
40: g_op_res_rec Bom_Rtg_Pub.Op_Resource_Rec_Type;
41: g_sub_op_res_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type;
42: g_nwk_rec Bom_Rtg_Pub.Op_Network_Rec_Type;
43:
36:
37: --for updating interface tables
38: g_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type;
39: g_op_rec Bom_Rtg_Pub.Operation_Rec_Type;
40: g_op_res_rec Bom_Rtg_Pub.Op_Resource_Rec_Type;
41: g_sub_op_res_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type;
42: g_nwk_rec Bom_Rtg_Pub.Op_Network_Rec_Type;
43:
44:
37: --for updating interface tables
38: g_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type;
39: g_op_rec Bom_Rtg_Pub.Operation_Rec_Type;
40: g_op_res_rec Bom_Rtg_Pub.Op_Resource_Rec_Type;
41: g_sub_op_res_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type;
42: g_nwk_rec Bom_Rtg_Pub.Op_Network_Rec_Type;
43:
44:
45: FUNCTION Update_Rtg_Interface_Tables(
38: g_rtg_revision_rec Bom_Rtg_Pub.Rtg_Revision_Rec_Type;
39: g_op_rec Bom_Rtg_Pub.Operation_Rec_Type;
40: g_op_res_rec Bom_Rtg_Pub.Op_Resource_Rec_Type;
41: g_sub_op_res_rec Bom_Rtg_Pub.Sub_Resource_Rec_Type;
42: g_nwk_rec Bom_Rtg_Pub.Op_Network_Rec_Type;
43:
44:
45: FUNCTION Update_Rtg_Interface_Tables(
46: x_err_text IN OUT NOCOPY VARCHAR2)
341: LOOP
342:
343: /* Initialize all the variables in business object */
344:
345: g_rtg_header_rec := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
346: g_rtg_revs_tbl := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
347: g_op_tbl := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
348: g_op_res_tbl := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
349: g_sub_op_res_tbl := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
342:
343: /* Initialize all the variables in business object */
344:
345: g_rtg_header_rec := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
346: g_rtg_revs_tbl := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
347: g_op_tbl := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
348: g_op_res_tbl := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
349: g_sub_op_res_tbl := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
350: g_nwk_tbl := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
343: /* Initialize all the variables in business object */
344:
345: g_rtg_header_rec := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
346: g_rtg_revs_tbl := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
347: g_op_tbl := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
348: g_op_res_tbl := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
349: g_sub_op_res_tbl := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
350: g_nwk_tbl := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
351: l_assembly_item_name := NULL;
344:
345: g_rtg_header_rec := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
346: g_rtg_revs_tbl := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
347: g_op_tbl := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
348: g_op_res_tbl := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
349: g_sub_op_res_tbl := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
350: g_nwk_tbl := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
351: l_assembly_item_name := NULL;
352: l_org_code := NULL;
345: g_rtg_header_rec := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
346: g_rtg_revs_tbl := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
347: g_op_tbl := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
348: g_op_res_tbl := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
349: g_sub_op_res_tbl := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
350: g_nwk_tbl := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
351: l_assembly_item_name := NULL;
352: l_org_code := NULL;
353: l_alt_rtg_desig := NULL;
346: g_rtg_revs_tbl := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
347: g_op_tbl := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
348: g_op_res_tbl := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
349: g_sub_op_res_tbl := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
350: g_nwk_tbl := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
351: l_assembly_item_name := NULL;
352: l_org_code := NULL;
353: l_alt_rtg_desig := NULL;
354: empty_bo :='Y';
774:
775: SAVEPOINT osfm_rtg_check ; --for osfm routings bug#3134027
776:
777: if (empty_bo ='N') then -- Calling the RBO public API
778: bom_rtg_pub.process_rtg
779: ( p_bo_identifier => 'RTG'
780: , p_api_version_number => 1.0
781: , p_init_msg_list => TRUE
782: , p_rtg_header_rec => g_rtg_header_rec