74: l_msg_count NUMBER;
75: l_msg_data VARCHAR2(1000);
76: l_error_message VARCHAR2(1000);
77:
78: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
79: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
80: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
81: l_eam_res_inst_rec EAM_PROCESS_WO_PUB.eam_res_inst_rec_type;
82: l_eam_res_usage_rec EAM_PROCESS_WO_PUB.eam_res_usage_rec_type;
75: l_msg_data VARCHAR2(1000);
76: l_error_message VARCHAR2(1000);
77:
78: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
79: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
80: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
81: l_eam_res_inst_rec EAM_PROCESS_WO_PUB.eam_res_inst_rec_type;
82: l_eam_res_usage_rec EAM_PROCESS_WO_PUB.eam_res_usage_rec_type;
83: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
76: l_error_message VARCHAR2(1000);
77:
78: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
79: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
80: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
81: l_eam_res_inst_rec EAM_PROCESS_WO_PUB.eam_res_inst_rec_type;
82: l_eam_res_usage_rec EAM_PROCESS_WO_PUB.eam_res_usage_rec_type;
83: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
84:
77:
78: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
79: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
80: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
81: l_eam_res_inst_rec EAM_PROCESS_WO_PUB.eam_res_inst_rec_type;
82: l_eam_res_usage_rec EAM_PROCESS_WO_PUB.eam_res_usage_rec_type;
83: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
84:
85: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
78: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
79: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
80: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
81: l_eam_res_inst_rec EAM_PROCESS_WO_PUB.eam_res_inst_rec_type;
82: l_eam_res_usage_rec EAM_PROCESS_WO_PUB.eam_res_usage_rec_type;
83: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
84:
85: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
86: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
79: l_eam_op_rec EAM_PROCESS_WO_PUB.eam_op_rec_type;
80: l_eam_res_rec EAM_PROCESS_WO_PUB.eam_res_rec_type;
81: l_eam_res_inst_rec EAM_PROCESS_WO_PUB.eam_res_inst_rec_type;
82: l_eam_res_usage_rec EAM_PROCESS_WO_PUB.eam_res_usage_rec_type;
83: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
84:
85: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
86: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
87: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
81: l_eam_res_inst_rec EAM_PROCESS_WO_PUB.eam_res_inst_rec_type;
82: l_eam_res_usage_rec EAM_PROCESS_WO_PUB.eam_res_usage_rec_type;
83: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
84:
85: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
86: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
87: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
88: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
89: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
82: l_eam_res_usage_rec EAM_PROCESS_WO_PUB.eam_res_usage_rec_type;
83: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
84:
85: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
86: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
87: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
88: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
89: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
90: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
83: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
84:
85: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
86: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
87: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
88: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
89: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
90: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
91: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
84:
85: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
86: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
87: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
88: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
89: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
90: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
91: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
92: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
85: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
86: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
87: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
88: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
89: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
90: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
91: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
92: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
93: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
86: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
87: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
88: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
89: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
90: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
91: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
92: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
93: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
94: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
87: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
88: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
89: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
90: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
91: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
92: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
93: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
94: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
95: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
88: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
89: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
90: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
91: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
92: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
93: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
94: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
95: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
96: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
89: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
90: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
91: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
92: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
93: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
94: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
95: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
96: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
97: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
90: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
91: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
92: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
93: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
94: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
95: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
96: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
97: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
98: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
91: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
92: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
93: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
94: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
95: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
96: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
97: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
98: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
99: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
92: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
93: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
94: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
95: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
96: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
97: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
98: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
99: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
100: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
93: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
94: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
95: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
96: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
97: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
98: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
99: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
100: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
101: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
94: l_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
95: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
96: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
97: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
98: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
99: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
100: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
101: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
102:
95: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
96: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
97: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
98: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
99: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
100: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
101: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
102:
103: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
96: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
97: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
98: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
99: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
100: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
101: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
102:
103: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
104: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
97: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
98: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
99: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
100: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
101: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
102:
103: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
104: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
105: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
99: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
100: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
101: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
102:
103: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
104: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
105: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
106: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
107: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
100: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
101: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
102:
103: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
104: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
105: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
106: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
107: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
108: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
101: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
102:
103: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
104: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
105: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
106: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
107: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
108: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
109: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
102:
103: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
104: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
105: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
106: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
107: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
108: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
109: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
110: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
103: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
104: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
105: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
106: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
107: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
108: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
109: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
110: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
111: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
104: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
105: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
106: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
107: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
108: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
109: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
110: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
111: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
112: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
105: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
106: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
107: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
108: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
109: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
110: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
111: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
112: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
113: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
106: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
107: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
108: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
109: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
110: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
111: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
112: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
113: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
114: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
107: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
108: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
109: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
110: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
111: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
112: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
113: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
114: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
115: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
108: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
109: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
110: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
111: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
112: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
113: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
114: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
115: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
116: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
109: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
110: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
111: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
112: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
113: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
114: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
115: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
116: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
117: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
110: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
111: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
112: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
113: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
114: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
115: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
116: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
117: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
118: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
111: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
112: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
113: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
114: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
115: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
116: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
117: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
118: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
119: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
112: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
113: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
114: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
115: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
116: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
117: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
118: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
119: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
120:
113: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
114: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
115: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
116: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
117: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
118: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
119: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
120:
121: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
114: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
115: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
116: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
117: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
118: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
119: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
120:
121: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
122: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
115: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
116: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
117: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
118: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
119: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
120:
121: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
122: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
123:
117: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
118: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
119: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
120:
121: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
122: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
123:
124: l_cur_firm_flag NUMBER;
125: l_cur_non_firm_flag NUMBER;
118: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
119: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
120:
121: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
122: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
123:
124: l_cur_firm_flag NUMBER;
125: l_cur_non_firm_flag NUMBER;
126:
464:
465: /* Call Work Order API to perform the operations */
466:
467:
468: eam_process_wo_pub.PROCESS_MASTER_CHILD_WO
469: ( p_bo_identifier => 'EAM'
470: , p_init_msg_list => TRUE
471: , p_api_version_number => 1.0
472: , p_eam_wo_relations_tbl => l_eam_wo_relations_tbl