20: -- 12-MAR-01 Masanori Kimizuka Initial Creation
21: --
22: ***************************************************************************/
23:
24: -- Invoker for Bom_Rtg_Pub.Process_Rtg
25: PROCEDURE Process_Rtg
26: ( p_bo_identifier IN VARCHAR2 := 'RTG'
27: , p_api_version_number IN NUMBER := 1.0
28: , p_init_msg_list IN BOOLEAN := FALSE
25: PROCEDURE Process_Rtg
26: ( p_bo_identifier IN VARCHAR2 := 'RTG'
27: , p_api_version_number IN NUMBER := 1.0
28: , p_init_msg_list IN BOOLEAN := FALSE
29: , p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
30: :=Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
31: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
32: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
33: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
26: ( p_bo_identifier IN VARCHAR2 := 'RTG'
27: , p_api_version_number IN NUMBER := 1.0
28: , p_init_msg_list IN BOOLEAN := FALSE
29: , p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
30: :=Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
31: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
32: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
33: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
34: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL
27: , p_api_version_number IN NUMBER := 1.0
28: , p_init_msg_list IN BOOLEAN := FALSE
29: , p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
30: :=Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
31: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
32: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
33: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
34: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL
35: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
28: , p_init_msg_list IN BOOLEAN := FALSE
29: , p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
30: :=Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
31: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
32: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
33: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
34: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL
35: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
36: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
29: , p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
30: :=Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
31: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
32: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
33: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
34: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL
35: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
36: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
37: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
30: :=Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
31: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
32: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
33: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
34: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL
35: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
36: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
37: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
38: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
31: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
32: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
33: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
34: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL
35: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
36: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
37: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
38: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
39: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
32: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
33: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
34: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL
35: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
36: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
37: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
38: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
39: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
40: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
33: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
34: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL
35: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
36: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
37: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
38: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
39: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
40: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
41: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
34: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL
35: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
36: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
37: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
38: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
39: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
40: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
41: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
42: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
35: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
36: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
37: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
38: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
39: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
40: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
41: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
42: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
43: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
36: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
37: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
38: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
39: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
40: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
41: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
42: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
43: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
44: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
37: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
38: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
39: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
40: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
41: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
42: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
43: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
44: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
45: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
38: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
39: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
40: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
41: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
42: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
43: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
44: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
45: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
46: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
39: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
40: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
41: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
42: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
43: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
44: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
45: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
46: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
47: , x_return_status IN OUT NOCOPY VARCHAR2
40: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
41: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
42: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
43: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
44: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
45: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
46: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
47: , x_return_status IN OUT NOCOPY VARCHAR2
48: , x_msg_count IN OUT NOCOPY NUMBER
41: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
42: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
43: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
44: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
45: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
46: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
47: , x_return_status IN OUT NOCOPY VARCHAR2
48: , x_msg_count IN OUT NOCOPY NUMBER
49: , p_debug IN VARCHAR2 := 'N'
42: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
43: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
44: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
45: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
46: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
47: , x_return_status IN OUT NOCOPY VARCHAR2
48: , x_msg_count IN OUT NOCOPY NUMBER
49: , p_debug IN VARCHAR2 := 'N'
50: , p_output_dir IN VARCHAR2 := NULL
54:
55: BEGIN
56:
57:
58: Bom_Rtg_Pub.Process_Rtg
59: ( p_bo_identifier => p_bo_identifier
60: , p_api_version_number => p_api_version_number
61: , p_init_msg_list => p_init_msg_list
62: , p_rtg_header_rec => p_rtg_header_rec