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;
878:
879: l_date_chk_return_status VARCHAR2(1);
880: l_output_dir VARCHAR2(512);
881:
882: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
883:
884: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
885: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
886: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
880: l_output_dir VARCHAR2(512);
881:
882: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
883:
884: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
885: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
886: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
887: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
888: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
881:
882: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
883:
884: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
885: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
886: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
887: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
888: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
889: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
882: l_eam_wo_rec eam_process_wo_pub.eam_wo_rec_type;
883:
884: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
885: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
886: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
887: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
888: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
889: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
890: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
883:
884: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
885: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
886: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
887: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
888: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
889: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
890: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
891: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
884: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
885: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
886: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
887: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
888: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
889: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
890: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
891: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
892: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
885: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
886: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
887: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
888: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
889: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
890: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
891: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
892: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
893: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
886: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
887: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
888: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
889: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
890: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
891: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
892: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
893: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
894: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
887: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
888: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
889: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
890: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
891: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
892: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
893: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
894: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
895: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
888: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
889: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
890: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
891: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
892: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
893: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
894: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
895: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
896: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
889: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
890: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
891: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
892: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
893: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
894: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
895: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
896: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
897: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
890: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
891: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
892: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
893: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
894: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
895: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
896: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
897: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
898: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
891: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
892: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
893: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
894: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
895: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
896: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
897: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
898: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
899: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
892: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
893: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
894: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
895: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
896: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
897: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
898: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
899: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
900: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
893: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
894: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
895: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
896: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
897: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
898: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
899: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
900: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
901:
894: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
895: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
896: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
897: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
898: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
899: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
900: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
901:
902: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
895: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
896: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
897: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
898: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
899: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
900: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
901:
902: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
903: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
896: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
897: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
898: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
899: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
900: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
901:
902: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
903: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
904: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
898: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
899: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
900: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
901:
902: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
903: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
904: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
905: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
906: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
899: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
900: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
901:
902: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
903: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
904: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
905: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
906: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
907: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
900: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
901:
902: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
903: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
904: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
905: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
906: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
907: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
908: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
901:
902: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
903: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
904: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
905: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
906: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
907: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
908: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
909: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
902: l_out_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
903: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
904: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
905: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
906: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
907: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
908: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
909: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
910: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
903: l_out_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
904: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
905: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
906: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
907: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
908: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
909: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
910: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
911: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
904: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
905: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
906: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
907: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
908: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
909: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
910: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
911: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
912: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
905: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
906: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
907: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
908: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
909: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
910: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
911: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
912: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
913: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
906: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
907: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
908: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
909: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
910: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
911: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
912: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
913: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
914: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
907: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
908: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
909: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
910: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
911: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
912: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
913: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
914: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
915: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
908: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
909: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
910: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
911: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
912: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
913: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
914: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
915: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
916: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
909: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
910: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
911: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
912: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
913: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
914: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
915: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
916: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
917: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
910: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
911: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
912: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
913: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
914: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
915: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
916: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
917: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
918: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
911: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
912: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
913: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
914: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
915: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
916: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
917: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
918: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
919: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
912: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
913: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
914: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
915: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
916: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
917: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
918: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
919: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
920: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
913: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
914: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
915: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
916: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
917: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
918: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
919: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
920: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
921:
914: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
915: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
916: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
917: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
918: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
919: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
920: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
921:
922:
915: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
916: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
917: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
918: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
919: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
920: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
921:
922:
923: BEGIN
916: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
917: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
918: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
919: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
920: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
921:
922:
923: BEGIN
924:
944: l_eam_wo_rec.DUE_DATE := p_required_due_date;
945:
946: -- insert into the table
947: l_eam_wo_tbl(1) := l_eam_wo_rec;
948: EAM_PROCESS_WO_PUB.Process_Master_Child_WO(
949: p_bo_identifier => 'EAM'
950: , p_init_msg_list => TRUE
951: , p_api_version_number => 1.0
952: , p_eam_wo_tbl => l_eam_wo_tbl
1056:
1057: l_other_message VARCHAR2(20000);
1058: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1059:
1060: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1061: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1062: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1063: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1064: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1057: l_other_message VARCHAR2(20000);
1058: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1059:
1060: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1061: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1062: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1063: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1064: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1065: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1058: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1059:
1060: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1061: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1062: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1063: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1064: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1065: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1066: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1059:
1060: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1061: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1062: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1063: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1064: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1065: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1066: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1067: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1060: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1061: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1062: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1063: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1064: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1065: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1066: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1067: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1068: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1061: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1062: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1063: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1064: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1065: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1066: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1067: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1068: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1069:
1062: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1063: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1064: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1065: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1066: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1067: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1068: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1069:
1070: l_prior_workorder VARCHAR2(240);
1063: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1064: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1065: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1066: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1067: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1068: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1069:
1070: l_prior_workorder VARCHAR2(240);
1071: l_next_workorder VARCHAR2(240);
1064: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1065: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1066: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1067: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1068: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1069:
1070: l_prior_workorder VARCHAR2(240);
1071: l_next_workorder VARCHAR2(240);
1072:
1267: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1268: l_other_message VARCHAR2(20000);
1269: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1270:
1271: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1272: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1273: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1274: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1275: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1268: l_other_message VARCHAR2(20000);
1269: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1270:
1271: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1272: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1273: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1274: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1275: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1276: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1269: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1270:
1271: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1272: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1273: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1274: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1275: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1276: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1277: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1270:
1271: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1272: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1273: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1274: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1275: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1276: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1277: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1278: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1271: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1272: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1273: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1274: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1275: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1276: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1277: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1278: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1279: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1272: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1273: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1274: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1275: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1276: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1277: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1278: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1279: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1280:
1273: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1274: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1275: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1276: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1277: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1278: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1279: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1280:
1281: l_prior_workorder VARCHAR2(240);
1274: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1275: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1276: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1277: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1278: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1279: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1280:
1281: l_prior_workorder VARCHAR2(240);
1282: l_next_workorder VARCHAR2(240);
1275: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1276: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1277: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1278: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1279: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1280:
1281: l_prior_workorder VARCHAR2(240);
1282: l_next_workorder VARCHAR2(240);
1283: l_wo_relationship_exc_tbl EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type;
1279: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1280:
1281: l_prior_workorder VARCHAR2(240);
1282: l_next_workorder VARCHAR2(240);
1283: l_wo_relationship_exc_tbl EAM_PROCESS_WO_PUB.wo_relationship_exc_tbl_type;
1284:
1285: BEGIN
1286:
1287:
1686:
1687: l_other_message VARCHAR2(20000);
1688: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1689:
1690: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1691: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1692: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1693: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1694: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1687: l_other_message VARCHAR2(20000);
1688: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1689:
1690: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1691: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1692: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1693: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1694: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1695: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1688: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
1689:
1690: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1691: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1692: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1693: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1694: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1695: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1696: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1689:
1690: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1691: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1692: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1693: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1694: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1695: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1696: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1697: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1690: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1691: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1692: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1693: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1694: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1695: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1696: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1697: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1698: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1691: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1692: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1693: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1694: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1695: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1696: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1697: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1698: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1699:
1692: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type ;
1693: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1694: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1695: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1696: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1697: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1698: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1699:
1700: TYPE l_relationship_records IS REF CURSOR RETURN WIP_SCHED_RELATIONSHIPS%ROWTYPE;
1693: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1694: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1695: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1696: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1697: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1698: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1699:
1700: TYPE l_relationship_records IS REF CURSOR RETURN WIP_SCHED_RELATIONSHIPS%ROWTYPE;
1701: l_constraining_children l_relationship_records;
1694: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type ;
1695: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type ;
1696: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type ;
1697: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type ;
1698: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type ;
1699:
1700: TYPE l_relationship_records IS REF CURSOR RETURN WIP_SCHED_RELATIONSHIPS%ROWTYPE;
1701: l_constraining_children l_relationship_records;
1702: l_relationship_record WIP_SCHED_RELATIONSHIPS%ROWTYPE;