166:
167: l_assembly_item_name varchar2(81);
168: l_today date := sysdate;
169:
170: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
171: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
172: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
173: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
174: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
167: l_assembly_item_name varchar2(81);
168: l_today date := sysdate;
169:
170: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
171: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
172: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
173: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
174: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
175: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
168: l_today date := sysdate;
169:
170: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
171: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
172: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
173: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
174: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
175: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
176:
169:
170: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
171: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
172: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
173: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
174: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
175: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
176:
177: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
170: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
171: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
172: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
173: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
174: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
175: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
176:
177: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
178: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
171: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
172: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
173: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
174: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
175: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
176:
177: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
178: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
179: o_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
173: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
174: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
175: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
176:
177: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
178: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
179: o_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
180: o_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
181: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
174: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
175: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
176:
177: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
178: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
179: o_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
180: o_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
181: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
182: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
175: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
176:
177: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
178: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
179: o_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
180: o_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
181: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
182: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
183:
176:
177: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
178: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
179: o_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
180: o_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
181: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
182: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
183:
184: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
177: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
178: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
179: o_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
180: o_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
181: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
182: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
183:
184: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
185: t_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
178: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
179: o_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
180: o_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
181: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
182: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
183:
184: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
185: t_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
186: t_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
180: o_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
181: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
182: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
183:
184: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
185: t_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
186: t_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
187: t_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
188: t_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
181: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
182: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
183:
184: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
185: t_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
186: t_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
187: t_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
188: t_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
189:
182: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
183:
184: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
185: t_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
186: t_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
187: t_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
188: t_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
189:
190: a_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
183:
184: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
185: t_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
186: t_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
187: t_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
188: t_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
189:
190: a_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
191:
184: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
185: t_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
186: t_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
187: t_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
188: t_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
189:
190: a_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
191:
192: o_return_status Varchar2(8);
186: t_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
187: t_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
188: t_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
189:
190: a_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
191:
192: o_return_status Varchar2(8);
193: o_msg_count Number;
194: l_msg varchar2(1000);
1363: CLOSE c_networks;
1364:
1365: error_handler.initialize;
1366:
1367: Bom_Rtg_Pub.Process_Rtg( p_rtg_header_rec =>l_rtg_header_rec
1368: ,p_rtg_revision_tbl =>l_rtg_revision_tbl
1369: ,p_operation_tbl =>l_operation_tbl
1370: ,p_op_resource_tbl =>l_op_resource_tbl
1371: ,p_sub_resource_tbl =>l_sub_resource_tbl