49: l_old_flag VARCHAR2(1);
50: l_req_id NUMBER;
51:
52: -- parameters needed for the WO wrapper API call
53: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
54: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
55: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
56: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
57: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
50: l_req_id NUMBER;
51:
52: -- parameters needed for the WO wrapper API call
53: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
54: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
55: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
56: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
57: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
58: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
51:
52: -- parameters needed for the WO wrapper API call
53: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
54: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
55: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
56: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
57: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
58: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
59: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
52: -- parameters needed for the WO wrapper API call
53: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
54: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
55: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
56: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
57: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
58: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
59: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
60: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
53: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
54: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
55: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
56: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
57: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
58: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
59: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
60: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
61: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
54: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
55: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
56: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
57: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
58: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
59: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
60: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
61: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
62: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
55: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
56: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
57: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
58: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
59: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
60: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
61: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
62: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
63: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
56: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
57: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
58: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
59: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
60: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
61: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
62: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
63: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
64: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
57: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
58: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
59: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
60: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
61: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
62: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
63: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
64: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
65: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
58: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
59: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
60: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
61: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
62: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
63: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
64: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
65: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
66: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
59: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
60: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
61: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
62: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
63: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
64: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
65: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
66: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
67: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
60: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
61: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
62: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
63: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
64: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
65: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
66: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
67: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
68: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
61: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
62: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
63: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
64: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
65: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
66: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
67: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
68: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
69: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
62: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
63: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
64: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
65: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
66: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
67: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
68: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
69: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
70: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
63: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
64: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
65: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
66: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
67: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
68: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
69: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
70: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
71:
64: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
65: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
66: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
67: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
68: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
69: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
70: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
71:
72: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
65: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
66: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
67: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
68: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
69: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
70: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
71:
72: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
73: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
66: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
67: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
68: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
69: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
70: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
71:
72: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
73: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
74: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
68: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
69: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
70: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
71:
72: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
73: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
74: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
75: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
76: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
69: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
70: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
71:
72: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
73: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
74: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
75: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
76: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
77: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
70: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
71:
72: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
73: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
74: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
75: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
76: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
77: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
78: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
71:
72: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
73: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
74: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
75: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
76: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
77: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
78: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
79: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
72: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
73: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
74: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
75: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
76: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
77: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
78: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
79: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
80: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
73: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
74: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
75: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
76: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
77: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
78: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
79: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
80: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
81: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
74: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
75: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
76: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
77: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
78: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
79: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
80: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
81: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
82: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
75: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
76: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
77: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
78: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
79: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
80: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
81: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
82: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
83: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
76: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
77: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
78: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
79: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
80: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
81: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
82: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
83: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
84: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
77: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
78: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
79: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
80: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
81: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
82: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
83: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
84: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
85: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
78: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
79: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
80: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
81: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
82: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
83: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
84: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
85: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
86: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
79: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
80: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
81: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
82: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
83: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
84: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
85: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
86: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
87: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
80: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
81: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
82: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
83: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
84: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
85: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
86: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
87: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
88: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
81: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
82: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
83: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
84: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
85: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
86: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
87: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
88: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
89: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
82: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
83: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
84: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
85: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
86: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
87: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
88: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
89: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
90:
83: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
84: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
85: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
86: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
87: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
88: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
89: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
90:
91: l_return_status VARCHAR2(1);
84: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
85: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
86: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
87: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
88: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
89: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
90:
91: l_return_status VARCHAR2(1);
92: l_msl_count NUMBER;
85: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
86: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
87: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
88: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
89: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
90:
91: l_return_status VARCHAR2(1);
92: l_msl_count NUMBER;
93: l_message_text VARCHAR2(256);
203: END ;
204:
205: if(sugg_rec.action_type IN (2,6,7)) then
206: -- Reschedule
207: l_eam_wo_tbl(i).transaction_type := eam_process_wo_pub.G_OPR_UPDATE;
208:
209: l_eam_wo_tbl(i).organization_id := sugg_rec.organization_id;
210: l_eam_wo_tbl(i).wip_entity_id := sugg_rec.wip_entity_id;
211:
230: l_eam_wo_tbl(i).seq_id := sugg_rec.seq_id;
231:
232: elsif(sugg_rec.action_type = 3) then
233: -- Cancel
234: l_eam_wo_tbl(i).transaction_type := eam_process_wo_pub.G_OPR_UPDATE;
235:
236: l_eam_wo_tbl(i).organization_id := sugg_rec.organization_id;
237: l_eam_wo_tbl(i).wip_entity_id := sugg_rec.wip_entity_id;
238: l_eam_wo_tbl(i).status_type := 7; -- cancelled
238: l_eam_wo_tbl(i).status_type := 7; -- cancelled
239: l_eam_wo_tbl(i).user_defined_status_id := 98; --cancelled by pm added for 12i
240: elsif(sugg_rec.action_type = 1) then
241: -- Create
242: l_eam_wo_tbl(i).transaction_type := eam_process_wo_pub.G_OPR_CREATE;
243: l_eam_wo_tbl(i).batch_id := p_pm_group_id;
244: l_eam_wo_tbl(i).header_id := i;
245: l_eam_wo_tbl(i).maintenance_object_source := 1; -- EAM
246: l_eam_wo_tbl(i).maintenance_object_type := sugg_rec.maintenance_object_type;
331: l_eam_wo_relations_tbl(i).TOP_LEVEL_OBJECT_TYPE_ID :=1;
332: l_eam_wo_relations_tbl(i).TOP_LEVEL_HEADER_ID :=p_parent_wo_id;
333:
334: l_eam_wo_relations_tbl(i).RETURN_STATUS :=null;
335: l_eam_wo_relations_tbl(i).TRANSACTION_TYPE :=EAM_PROCESS_WO_PUB.G_OPR_CREATE;
336: end if;
337:
338: if(p_planner_code is not null) then -- WO Defaults ER 16094794
339: l_eam_wo_tbl(i).planner_type := p_planner_code;
372:
373: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);
374:
375:
376: eam_process_wo_pub.PROCESS_MASTER_CHILD_WO
377: ( p_bo_identifier => 'EAM'
378: , p_init_msg_list => TRUE
379: , p_api_version_number => 1.0
380: , p_eam_wo_relations_tbl => l_eam_wo_relations_tbl
451: l_old_flag VARCHAR2(1);
452: l_req_id NUMBER;
453:
454: -- parameters needed for the WO wrapper API call
455: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
456: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
457: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
458: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
459: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
452: l_req_id NUMBER;
453:
454: -- parameters needed for the WO wrapper API call
455: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
456: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
457: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
458: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
459: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
460: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
453:
454: -- parameters needed for the WO wrapper API call
455: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
456: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
457: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
458: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
459: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
460: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
461: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
454: -- parameters needed for the WO wrapper API call
455: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
456: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
457: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
458: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
459: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
460: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
461: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
462: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
455: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
456: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
457: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
458: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
459: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
460: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
461: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
462: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
463: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
456: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
457: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
458: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
459: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
460: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
461: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
462: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
463: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
464: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
457: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
458: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
459: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
460: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
461: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
462: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
463: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
464: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
465: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
458: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
459: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
460: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
461: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
462: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
463: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
464: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
465: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
466: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
459: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
460: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
461: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
462: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
463: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
464: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
465: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
466: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
467: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
460: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
461: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
462: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
463: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
464: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
465: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
466: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
467: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
468: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
461: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
462: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
463: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
464: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
465: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
466: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
467: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
468: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
469: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
462: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
463: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
464: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
465: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
466: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
467: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
468: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
469: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
470: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
463: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
464: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
465: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
466: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
467: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
468: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
469: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
470: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
471: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
464: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
465: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
466: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
467: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
468: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
469: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
470: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
471: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
472: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
465: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
466: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
467: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
468: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
469: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
470: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
471: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
472: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
473:
466: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
467: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
468: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
469: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
470: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
471: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
472: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
473:
474: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
467: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
468: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
469: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
470: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
471: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
472: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
473:
474: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
475: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
468: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
469: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
470: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
471: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
472: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
473:
474: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
475: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
476: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
470: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
471: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
472: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
473:
474: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
475: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
476: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
477: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
478: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
471: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
472: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
473:
474: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
475: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
476: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
477: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
478: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
479: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
472: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
473:
474: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
475: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
476: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
477: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
478: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
479: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
480: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
473:
474: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
475: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
476: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
477: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
478: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
479: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
480: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
481: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
474: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
475: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
476: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
477: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
478: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
479: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
480: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
481: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
482: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
475: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
476: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
477: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
478: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
479: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
480: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
481: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
482: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
483: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
476: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
477: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
478: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
479: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
480: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
481: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
482: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
483: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
484: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
477: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
478: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
479: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
480: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
481: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
482: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
483: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
484: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
485: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
478: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
479: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
480: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
481: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
482: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
483: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
484: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
485: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
486: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
479: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
480: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
481: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
482: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
483: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
484: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
485: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
486: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
487: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
480: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
481: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
482: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
483: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
484: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
485: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
486: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
487: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
488: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
481: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
482: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
483: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
484: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
485: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
486: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
487: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
488: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
489: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
482: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
483: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
484: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
485: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
486: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
487: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
488: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
489: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
490: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
483: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
484: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
485: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
486: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
487: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
488: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
489: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
490: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
491: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
484: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
485: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
486: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
487: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
488: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
489: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
490: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
491: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
492:
485: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
486: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
487: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
488: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
489: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
490: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
491: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
492:
493: l_return_status VARCHAR2(1);
486: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
487: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
488: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
489: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
490: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
491: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
492:
493: l_return_status VARCHAR2(1);
494: l_msl_count NUMBER;
487: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
488: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
489: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
490: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
491: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
492:
493: l_return_status VARCHAR2(1);
494: l_msl_count NUMBER;
495: l_message_text VARCHAR2(256);
565:
566: l_eam_wo_tbl(i).plan_maintenance := 'Y';
567: --fnd_file.put_line(FND_FILE.LOG, 'Anton: Create');
568: -- Create
569: l_eam_wo_tbl(i).transaction_type := eam_process_wo_pub.G_OPR_CREATE;
570: l_eam_wo_tbl(i).batch_id := p_pm_group_id;
571: l_eam_wo_tbl(i).header_id := i;
572: l_eam_wo_tbl(i).maintenance_object_source := 1; -- EAM
573: l_eam_wo_tbl(i).maintenance_object_type := sugg_rec.maintenance_object_type;
638: l_eam_wo_relations_tbl(i).TOP_LEVEL_OBJECT_TYPE_ID :=1;
639: l_eam_wo_relations_tbl(i).TOP_LEVEL_HEADER_ID :=p_parent_wo_id;
640:
641: l_eam_wo_relations_tbl(i).RETURN_STATUS :=null;
642: l_eam_wo_relations_tbl(i).TRANSACTION_TYPE :=EAM_PROCESS_WO_PUB.G_OPR_CREATE;
643: end if;
644:
645: i := i + 1;
646: j := j + 1;
653: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);
654:
655:
656:
657: eam_process_wo_pub.PROCESS_MASTER_CHILD_WO
658: ( p_bo_identifier => 'EAM'
659: , p_init_msg_list => TRUE
660: , p_api_version_number => 1.0
661: , p_eam_wo_relations_tbl => l_eam_wo_relations_tbl
922: l_shutdown_type VARCHAR2(30); --Added for bug 7133506
923:
924: /* added for calling WO API */
925:
926: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
927: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
928: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
929: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
930: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
923:
924: /* added for calling WO API */
925:
926: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
927: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
928: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
929: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
930: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
931: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
924: /* added for calling WO API */
925:
926: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
927: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
928: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
929: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
930: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
931: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
932: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
925:
926: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
927: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
928: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
929: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
930: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
931: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
932: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
933: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
926: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
927: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
928: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
929: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
930: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
931: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
932: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
933: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
934: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
927: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
928: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
929: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
930: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
931: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
932: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
933: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
934: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
935: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
928: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
929: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
930: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
931: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
932: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
933: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
934: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
935: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
936: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
929: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
930: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
931: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
932: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
933: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
934: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
935: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
936: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
937: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
930: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
931: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
932: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
933: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
934: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
935: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
936: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
937: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
938: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
931: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
932: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
933: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
934: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
935: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
936: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
937: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
938: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
939: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
932: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
933: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
934: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
935: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
936: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
937: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
938: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
939: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
940: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
933: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
934: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
935: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
936: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
937: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
938: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
939: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
940: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
941: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
934: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
935: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
936: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
937: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
938: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
939: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
940: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
941: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
942: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
935: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
936: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
937: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
938: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
939: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
940: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
941: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
942: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
943: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
936: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
937: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
938: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
939: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
940: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
941: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
942: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
943: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
944: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
937: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
938: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
939: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
940: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
941: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
942: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
943: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
944: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
945:
938: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
939: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
940: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
941: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
942: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
943: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
944: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
945:
946: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
939: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
940: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
941: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
942: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
943: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
944: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
945:
946: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
947: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
940: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
941: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
942: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
943: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
944: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
945:
946: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
947: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
948: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
942: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
943: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
944: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
945:
946: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
947: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
948: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
949: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
950: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
943: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
944: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
945:
946: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
947: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
948: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
949: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
950: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
951: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
944: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
945:
946: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
947: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
948: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
949: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
950: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
951: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
952: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
945:
946: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
947: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
948: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
949: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
950: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
951: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
952: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
953: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
946: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
947: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
948: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
949: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
950: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
951: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
952: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
953: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
954: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
947: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
948: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
949: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
950: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
951: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
952: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
953: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
954: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
955: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
948: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
949: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
950: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
951: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
952: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
953: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
954: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
955: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
956: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
949: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
950: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
951: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
952: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
953: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
954: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
955: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
956: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
957: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
950: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
951: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
952: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
953: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
954: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
955: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
956: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
957: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
958: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
951: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
952: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
953: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
954: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
955: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
956: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
957: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
958: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
959: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
952: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
953: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
954: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
955: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
956: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
957: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
958: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
959: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
960: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
953: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
954: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
955: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
956: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
957: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
958: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
959: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
960: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
961: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
954: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
955: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
956: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
957: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
958: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
959: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
960: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
961: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
962: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
955: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
956: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
957: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
958: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
959: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
960: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
961: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
962: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
963:
956: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
957: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
958: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
959: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
960: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
961: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
962: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
963:
964: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
957: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
958: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
959: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
960: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
961: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
962: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
963:
964: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
965:
958: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
959: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
960: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
961: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
962: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
963:
964: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
965:
966: l_output_dir VARCHAR2(512);
960: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
961: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
962: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
963:
964: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
965:
966: l_output_dir VARCHAR2(512);
967: i number;
968: j number;
1037: exit when l_wip_entity_id = work_orders_released.LAST;
1038: l_wip_entity_id := work_orders_released.NEXT(l_wip_entity_id);
1039: END LOOP;
1040:
1041: EAM_PROCESS_WO_PUB.Process_Master_Child_WO
1042: ( p_bo_identifier => 'EAM'
1043: , p_init_msg_list => TRUE
1044: , p_api_version_number => 1.0
1045: , p_eam_wo_tbl => l_eam_wo_tbl
1130: l_err_occured VARCHAR2(1);
1131:
1132: /* added for calling WO API */
1133:
1134: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1135: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1136: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1137: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1138: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1131:
1132: /* added for calling WO API */
1133:
1134: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1135: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1136: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1137: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1138: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1139: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1132: /* added for calling WO API */
1133:
1134: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1135: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1136: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1137: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1138: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1139: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1140: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1133:
1134: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1135: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1136: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1137: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1138: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1139: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1140: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1141: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1134: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1135: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1136: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1137: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1138: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1139: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1140: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1141: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1142: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1135: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1136: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1137: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1138: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1139: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1140: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1141: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1142: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1143: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1136: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1137: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1138: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1139: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1140: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1141: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1142: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1143: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1144: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1137: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1138: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1139: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1140: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1141: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1142: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1143: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1144: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1145: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1138: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1139: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1140: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1141: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1142: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1143: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1144: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1145: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1146: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1139: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1140: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1141: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1142: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1143: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1144: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1145: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1146: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1147: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1140: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1141: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1142: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1143: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1144: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1145: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1146: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1147: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1148: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1141: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1142: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1143: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1144: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1145: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1146: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1147: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1148: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1149: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1142: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1143: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1144: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1145: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1146: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1147: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1148: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1149: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1150: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1143: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1144: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1145: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1146: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1147: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1148: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1149: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1150: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1151: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1144: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1145: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1146: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1147: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1148: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1149: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1150: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1151: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1152: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
1145: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1146: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1147: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1148: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1149: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1150: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1151: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1152: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
1153:
1146: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1147: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1148: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1149: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1150: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1151: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1152: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
1153:
1154: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1147: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1148: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1149: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1150: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1151: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1152: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
1153:
1154: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1155: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1148: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1149: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1150: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1151: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1152: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
1153:
1154: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1155: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1156: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1150: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1151: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1152: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
1153:
1154: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1155: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1156: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1157: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1158: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1151: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1152: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
1153:
1154: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1155: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1156: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1157: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1158: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1159: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1152: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
1153:
1154: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1155: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1156: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1157: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1158: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1159: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1160: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1153:
1154: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1155: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1156: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1157: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1158: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1159: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1160: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1161: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1154: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1155: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1156: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1157: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1158: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1159: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1160: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1161: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1162: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1155: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1156: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1157: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1158: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1159: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1160: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1161: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1162: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1163: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1156: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1157: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1158: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1159: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1160: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1161: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1162: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1163: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1164: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1157: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1158: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1159: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1160: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1161: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1162: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1163: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1164: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1165: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1158: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1159: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1160: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1161: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1162: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1163: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1164: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1165: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1166: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1159: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1160: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1161: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1162: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1163: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1164: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1165: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1166: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1167: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1160: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1161: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1162: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1163: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1164: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1165: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1166: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1167: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1168: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1161: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1162: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1163: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1164: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1165: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1166: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1167: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1168: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1169: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1162: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1163: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1164: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1165: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1166: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1167: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1168: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1169: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1170: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1163: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1164: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1165: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1166: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1167: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1168: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1169: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1170: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1171:
1164: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1165: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1166: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1167: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1168: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1169: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1170: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1171:
1172: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1165: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1166: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1167: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1168: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1169: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1170: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1171:
1172: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1173: l_eam_wo_rec_1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1166: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1167: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1168: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1169: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1170: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1171:
1172: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1173: l_eam_wo_rec_1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1174: l_output_dir VARCHAR2(512);
1168: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1169: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1170: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1171:
1172: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1173: l_eam_wo_rec_1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1174: l_output_dir VARCHAR2(512);
1175: i number;
1176: j number;
1169: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1170: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1171:
1172: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1173: l_eam_wo_rec_1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1174: l_output_dir VARCHAR2(512);
1175: i number;
1176: j number;
1177: begin
1197: l_eam_wo_rec.batch_id := 1;
1198: l_eam_wo_rec.wip_entity_id := l_wip_entity_id;
1199: l_eam_wo_rec.organization_id := l_org_id;
1200: l_eam_wo_rec.status_type := 3;
1201: l_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
1202: l_eam_wo_rec.user_id := fnd_global.user_id; /*added for bug 8408518*/
1203: l_eam_wo_rec.responsibility_id := fnd_global.resp_id; /*added for bug 8408518*/
1204: l_eam_wo_tbl(i) :=l_eam_wo_rec;
1205: i := i + 1;
1206: exit when l_wip_entity_id = work_orders_unreleased.LAST;
1207: l_wip_entity_id := work_orders_unreleased.NEXT(l_wip_entity_id);
1208: END LOOP;
1209:
1210: EAM_PROCESS_WO_PUB.Process_Master_Child_WO
1211: ( p_bo_identifier => 'EAM'
1212: , p_init_msg_list => TRUE
1213: , p_api_version_number => 1.0
1214: , p_eam_wo_tbl => l_eam_wo_tbl
1272: l_eam_wo_rec_1.batch_id := 1;
1273: l_eam_wo_rec_1.wip_entity_id := l_wip_entity_id;
1274: l_eam_wo_rec_1.organization_id := l_org_id;
1275: l_eam_wo_rec_1.status_type := 3;
1276: l_eam_wo_rec_1.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
1277: l_eam_wo_tbl_1(j) :=l_eam_wo_rec_1;
1278: j := j + 1;
1279: exit when l_wip_entity_id = work_orders_not_ready.LAST ;
1280: l_wip_entity_id := work_orders_not_ready.NEXT(l_wip_entity_id);
1279: exit when l_wip_entity_id = work_orders_not_ready.LAST ;
1280: l_wip_entity_id := work_orders_not_ready.NEXT(l_wip_entity_id);
1281: END LOOP;
1282:
1283: EAM_PROCESS_WO_PUB.Process_Master_Child_WO
1284: ( p_bo_identifier => 'EAM'
1285: , p_init_msg_list => TRUE
1286: , p_api_version_number => 1.0
1287: , p_eam_wo_tbl => l_eam_wo_tbl_1