112:
113: l_other_message VARCHAR2(20000);
114: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
115:
116: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
117: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
118: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
119: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
120: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
113: l_other_message VARCHAR2(20000);
114: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
115:
116: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
117: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
118: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
119: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
120: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
121: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
114: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
115:
116: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
117: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
118: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
119: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
120: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
121: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
122: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
115:
116: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
117: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
118: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
119: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
120: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
121: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
122: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
123: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
116: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
117: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
118: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
119: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
120: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
121: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
122: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
123: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
124: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
117: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
118: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
119: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
120: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
121: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
122: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
123: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
124: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
125:
118: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
119: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
120: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
121: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
122: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
123: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
124: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
125:
126: l_parent_workorder VARCHAR2(240);
119: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
120: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
121: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
122: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
123: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
124: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
125:
126: l_parent_workorder VARCHAR2(240);
127: l_child_workorder VARCHAR2(240);
120: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
121: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
122: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
123: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
124: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
125:
126: l_parent_workorder VARCHAR2(240);
127: l_child_workorder VARCHAR2(240);
128: l_wo_relationship_exc_tbl EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type;
124: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
125:
126: l_parent_workorder VARCHAR2(240);
127: l_child_workorder VARCHAR2(240);
128: l_wo_relationship_exc_tbl EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type;
129: BEGIN
130:
131: -- Standard Start of API savepoint
132: SAVEPOINT EAM_WN_ADD_WO;
852:
853: l_date_chk_return_status VARCHAR2(1);
854: l_output_dir VARCHAR2(512);
855:
856: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
857:
858: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
859: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
860: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
854: l_output_dir VARCHAR2(512);
855:
856: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
857:
858: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
859: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
860: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
861: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
862: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
855:
856: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
857:
858: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
859: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
860: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
861: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
862: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
863: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
856: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
857:
858: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
859: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
860: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
861: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
862: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
863: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
864: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
857:
858: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
859: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
860: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
861: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
862: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
863: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
864: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
865: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
858: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
859: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
860: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
861: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
862: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
863: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
864: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
865: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
866: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
859: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
860: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
861: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
862: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
863: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
864: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
865: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
866: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
867: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
860: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
861: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
862: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
863: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
864: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
865: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
866: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
867: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
868: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
861: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
862: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
863: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
864: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
865: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
866: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
867: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
868: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
869: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
862: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
863: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
864: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
865: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
866: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
867: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
868: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
869: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
870: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
863: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
864: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
865: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
866: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
867: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
868: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
869: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
870: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
871: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
864: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
865: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
866: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
867: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
868: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
869: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
870: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
871: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
872: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
865: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
866: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
867: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
868: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
869: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
870: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
871: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
872: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
873: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
866: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
867: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
868: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
869: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
870: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
871: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
872: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
873: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
874: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
867: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
868: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
869: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
870: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
871: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
872: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
873: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
874: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
875:
868: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
869: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
870: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
871: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
872: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
873: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
874: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
875:
876: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
869: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
870: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
871: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
872: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
873: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
874: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
875:
876: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
877: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
870: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
871: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
872: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
873: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
874: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
875:
876: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
877: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
878: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
872: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
873: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
874: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
875:
876: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
877: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
878: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
879: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
880: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
873: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
874: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
875:
876: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
877: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
878: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
879: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
880: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
881: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
874: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
875:
876: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
877: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
878: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
879: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
880: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
881: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
882: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
875:
876: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
877: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
878: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
879: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
880: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
881: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
882: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
883: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
876: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
877: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
878: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
879: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
880: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
881: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
882: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
883: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
884: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
877: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
878: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
879: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
880: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
881: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
882: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
883: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
884: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
885: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
878: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
879: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
880: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
881: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
882: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
883: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
884: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
885: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
886: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
879: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
880: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
881: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
882: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
883: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
884: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
885: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
886: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
887: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
880: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
881: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
882: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
883: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
884: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
885: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
886: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
887: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
888: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
881: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
882: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
883: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
884: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
885: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
886: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
887: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
888: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
889: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
882: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
883: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
884: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
885: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
886: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
887: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
888: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
889: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
890: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
883: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
884: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
885: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
886: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
887: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
888: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
889: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
890: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
891: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
884: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
885: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
886: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
887: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
888: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
889: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
890: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
891: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
892: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
885: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
886: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
887: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
888: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
889: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
890: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
891: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
892: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
893: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
886: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
887: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
888: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
889: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
890: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
891: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
892: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
893: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
894: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
887: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
888: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
889: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
890: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
891: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
892: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
893: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
894: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
895:
888: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
889: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
890: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
891: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
892: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
893: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
894: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
895:
896:
889: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
890: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
891: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
892: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
893: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
894: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
895:
896:
897: BEGIN
890: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
891: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
892: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
893: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
894: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
895:
896:
897: BEGIN
898:
918: l_eam_wo_rec.DUE_DATE := p_required_due_date;
919:
920: -- insert into the table
921: l_eam_wo_tbl(1) := l_eam_wo_rec;
922: EAM_PROCESS_WO_PUB.Process_Master_Child_WO(
923: p_bo_identifier => 'EAM'
924: , p_init_msg_list => TRUE
925: , p_api_version_number => 1.0
926: , p_eam_wo_tbl => l_eam_wo_tbl
1030:
1031: l_other_message VARCHAR2(20000);
1032: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1033:
1034: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1035: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1036: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1037: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1038: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1031: l_other_message VARCHAR2(20000);
1032: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1033:
1034: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1035: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1036: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1037: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1038: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1039: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1032: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1033:
1034: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1035: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1036: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1037: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1038: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1039: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1040: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1033:
1034: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1035: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1036: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1037: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1038: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1039: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1040: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1041: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1034: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1035: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1036: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1037: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1038: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1039: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1040: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1041: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1042: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1035: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1036: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1037: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1038: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1039: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1040: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1041: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1042: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1043:
1036: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1037: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1038: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1039: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1040: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1041: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1042: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1043:
1044: l_prior_workorder VARCHAR2(240);
1037: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1038: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1039: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1040: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1041: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1042: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1043:
1044: l_prior_workorder VARCHAR2(240);
1045: l_next_workorder VARCHAR2(240);
1038: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1039: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1040: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1041: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1042: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1043:
1044: l_prior_workorder VARCHAR2(240);
1045: l_next_workorder VARCHAR2(240);
1046:
1241: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1242: l_other_message VARCHAR2(20000);
1243: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1244:
1245: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1246: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1247: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1248: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1249: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1242: l_other_message VARCHAR2(20000);
1243: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1244:
1245: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1246: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1247: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1248: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1249: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1250: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1243: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1244:
1245: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1246: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1247: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1248: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1249: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1250: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1251: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1244:
1245: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1246: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1247: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1248: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1249: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1250: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1251: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1252: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1245: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1246: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1247: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1248: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1249: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1250: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1251: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1252: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1253: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1246: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1247: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1248: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1249: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1250: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1251: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1252: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1253: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1254:
1247: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1248: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1249: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1250: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1251: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1252: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1253: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1254:
1255: l_prior_workorder VARCHAR2(240);
1248: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1249: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1250: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1251: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1252: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1253: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1254:
1255: l_prior_workorder VARCHAR2(240);
1256: l_next_workorder VARCHAR2(240);
1249: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1250: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1251: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1252: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1253: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1254:
1255: l_prior_workorder VARCHAR2(240);
1256: l_next_workorder VARCHAR2(240);
1257: l_wo_relationship_exc_tbl EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type;
1253: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1254:
1255: l_prior_workorder VARCHAR2(240);
1256: l_next_workorder VARCHAR2(240);
1257: l_wo_relationship_exc_tbl EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type;
1258:
1259: BEGIN
1260:
1261:
1660:
1661: l_other_message VARCHAR2(20000);
1662: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1663:
1664: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1665: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1666: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1667: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1668: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1661: l_other_message VARCHAR2(20000);
1662: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1663:
1664: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1665: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1666: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1667: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1668: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1669: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1662: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1663:
1664: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1665: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1666: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1667: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1668: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1669: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1670: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1663:
1664: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1665: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1666: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1667: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1668: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1669: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1670: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1671: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1664: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1665: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1666: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1667: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1668: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1669: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1670: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1671: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1672: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1665: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1666: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1667: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1668: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1669: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1670: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1671: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1672: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1673:
1666: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1667: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1668: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1669: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1670: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1671: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1672: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1673:
1674: TYPE l_relationship_records IS REF CURSOR RETURN WIP_SCHED_RELATIONSHIPS%ROWTYPE;
1667: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1668: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1669: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1670: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1671: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1672: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1673:
1674: TYPE l_relationship_records IS REF CURSOR RETURN WIP_SCHED_RELATIONSHIPS%ROWTYPE;
1675: l_constraining_children l_relationship_records;
1668: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1669: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1670: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1671: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1672: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1673:
1674: TYPE l_relationship_records IS REF CURSOR RETURN WIP_SCHED_RELATIONSHIPS%ROWTYPE;
1675: l_constraining_children l_relationship_records;
1676: l_relationship_record WIP_SCHED_RELATIONSHIPS%ROWTYPE;