46: insCtx DBMS_XMLSave.ctxType;
47: rows NUMBER;
48: ename_v VARCHAR2(20);
49:
50: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
51: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
52: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
53: := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
54: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
47: rows NUMBER;
48: ename_v VARCHAR2(20);
49:
50: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
51: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
52: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
53: := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
54: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
55: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
48: ename_v VARCHAR2(20);
49:
50: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
51: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
52: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
53: := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
54: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
55: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
56: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
49:
50: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
51: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
52: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
53: := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
54: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
55: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
56: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
57: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
50: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
51: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
52: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
53: := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
54: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
55: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
56: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
57: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
58: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
51: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
52: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
53: := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
54: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
55: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
56: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
57: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
58: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
59: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
52: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
53: := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
54: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
55: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
56: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
57: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
58: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
59: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
60: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
53: := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
54: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
55: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
56: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
57: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
58: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
59: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
60: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
61: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
54: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
55: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
56: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
57: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
58: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
59: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
60: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
61: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
62: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
55: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
56: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
57: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
58: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
59: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
60: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
61: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
62: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
63: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
56: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
57: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
58: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
59: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
60: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
61: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
62: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
63: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
64: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
57: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
58: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
59: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
60: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
61: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
62: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
63: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
64: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
65: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
58: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
59: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
60: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
61: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
62: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
63: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
64: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
65: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
66: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
59: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
60: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
61: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
62: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
63: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
64: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
65: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
66: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
67: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
60: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
61: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
62: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
63: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
64: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
65: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
66: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
67: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
61: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
62: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
63: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
64: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
65: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
66: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
67: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
69: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
62: x_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type
63: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
64: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
65: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
66: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
67: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
69: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
70: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
63: := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
64: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
65: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
66: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
67: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
69: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
70: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
71: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
64: x_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
65: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
66: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
67: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
69: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
70: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
71: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
72: x_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
65: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
66: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
67: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
69: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
70: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
71: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
72: x_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
73: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
66: x_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type
67: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
69: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
70: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
71: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
72: x_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
73: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
74:
67: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
69: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
70: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
71: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
72: x_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
73: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
74:
75: CURSOR rtg_hdr_CUR IS
68: x_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type
69: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
70: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
71: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
72: x_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
73: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
74:
75: CURSOR rtg_hdr_CUR IS
76: SELECT tmp.AssemblyItemName
69: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
70: x_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type
71: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
72: x_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type
73: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
74:
75: CURSOR rtg_hdr_CUR IS
76: SELECT tmp.AssemblyItemName
77: , tmp.OrganizationCode
986: END LOOP;
987: CLOSE rtg_op_networks_CUR;
988: BOM_GLOBALS.Set_Caller_Type('MIGRATION');
989: ERROR_HANDLER.Initialize;
990: BOM_RTG_PUB.Process_RTG(p_rtg_header_rec => l_rtg_header_rec
991: , p_rtg_revision_tbl => l_rtg_revision_tbl
992: , p_operation_tbl => l_operation_tbl
993: , p_op_resource_tbl => l_op_resource_tbl
994: , p_sub_resource_tbl => l_sub_resource_tbl