48: l_old_flag VARCHAR2(1);
49: l_req_id NUMBER;
50:
51: -- parameters needed for the WO wrapper API call
52: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
53: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
54: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
55: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
56: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
49: l_req_id NUMBER;
50:
51: -- parameters needed for the WO wrapper API call
52: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
53: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
54: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
55: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
56: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
57: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
50:
51: -- parameters needed for the WO wrapper API call
52: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
53: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
54: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
55: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
56: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
57: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
58: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
51: -- parameters needed for the WO wrapper API call
52: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
53: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
54: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
55: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
56: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
57: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
58: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
59: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
52: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
53: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
54: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
55: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
56: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
57: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
58: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
59: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
60: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
53: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
54: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
55: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
56: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
57: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
58: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
59: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
60: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
61: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
54: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
55: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
56: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
57: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
58: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
59: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
60: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
61: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
62: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
55: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
56: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
57: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
58: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
59: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
60: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
61: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
62: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
63: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
56: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
57: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
58: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
59: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
60: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
61: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
62: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
63: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
64: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
57: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
58: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
59: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
60: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
61: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
62: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
63: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
64: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
65: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
58: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
59: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
60: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
61: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
62: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
63: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
64: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
65: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
66: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
59: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
60: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
61: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
62: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
63: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
64: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
65: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
66: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
67: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
60: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
61: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
62: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
63: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
64: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
65: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
66: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
67: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
68: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
61: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
62: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
63: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
64: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
65: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
66: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
67: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
68: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
69: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
62: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
63: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
64: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
65: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
66: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
67: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
68: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
69: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
70:
63: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
64: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
65: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
66: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
67: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
68: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
69: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
70:
71: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
64: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
65: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
66: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
67: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
68: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
69: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
70:
71: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
72: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
65: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
66: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
67: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
68: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
69: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
70:
71: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
72: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
73: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
67: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
68: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
69: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
70:
71: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
72: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
73: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
74: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
75: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
68: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
69: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
70:
71: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
72: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
73: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
74: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
75: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
76: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
69: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
70:
71: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
72: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
73: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
74: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
75: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
76: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
77: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
70:
71: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
72: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
73: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
74: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
75: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
76: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
77: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
78: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
71: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
72: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
73: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
74: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
75: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
76: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
77: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
78: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
79: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
72: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
73: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
74: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
75: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
76: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
77: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
78: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
79: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
80: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
73: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
74: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
75: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
76: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
77: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
78: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
79: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
80: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
81: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
74: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
75: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
76: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
77: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
78: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
79: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
80: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
81: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
82: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
75: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
76: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
77: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
78: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
79: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
80: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
81: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
82: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
83: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
76: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
77: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
78: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
79: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
80: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
81: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
82: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
83: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
84: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
77: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
78: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
79: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
80: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
81: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
82: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
83: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
84: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
85: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
78: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
79: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
80: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
81: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
82: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
83: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
84: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
85: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
86: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
79: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
80: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
81: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
82: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
83: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
84: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
85: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
86: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
87: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
80: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
81: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
82: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
83: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
84: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
85: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
86: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
87: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
88: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
81: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
82: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
83: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
84: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
85: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
86: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
87: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
88: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
89:
82: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
83: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
84: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
85: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
86: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
87: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
88: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
89:
90: l_return_status VARCHAR2(1);
83: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
84: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
85: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
86: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
87: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
88: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
89:
90: l_return_status VARCHAR2(1);
91: l_msl_count NUMBER;
84: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
85: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
86: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
87: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
88: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
89:
90: l_return_status VARCHAR2(1);
91: l_msl_count NUMBER;
92: l_message_text VARCHAR2(256);
178: l_eam_wo_tbl(i).responsibility_id := fnd_global.resp_id;
179:
180: if(sugg_rec.action_type IN (2,6,7)) then
181: -- Reschedule
182: l_eam_wo_tbl(i).transaction_type := eam_process_wo_pub.G_OPR_UPDATE;
183:
184: l_eam_wo_tbl(i).organization_id := sugg_rec.organization_id;
185: l_eam_wo_tbl(i).wip_entity_id := sugg_rec.wip_entity_id;
186:
205: l_eam_wo_tbl(i).seq_id := sugg_rec.seq_id;
206:
207: elsif(sugg_rec.action_type = 3) then
208: -- Cancel
209: l_eam_wo_tbl(i).transaction_type := eam_process_wo_pub.G_OPR_UPDATE;
210:
211: l_eam_wo_tbl(i).organization_id := sugg_rec.organization_id;
212: l_eam_wo_tbl(i).wip_entity_id := sugg_rec.wip_entity_id;
213: l_eam_wo_tbl(i).status_type := 7; -- cancelled
213: l_eam_wo_tbl(i).status_type := 7; -- cancelled
214: l_eam_wo_tbl(i).user_defined_status_id := 98; --cancelled by pm added for 12i
215: elsif(sugg_rec.action_type = 1) then
216: -- Create
217: l_eam_wo_tbl(i).transaction_type := eam_process_wo_pub.G_OPR_CREATE;
218: l_eam_wo_tbl(i).batch_id := p_pm_group_id;
219: l_eam_wo_tbl(i).header_id := i;
220: l_eam_wo_tbl(i).maintenance_object_source := 1; -- EAM
221: l_eam_wo_tbl(i).maintenance_object_type := sugg_rec.maintenance_object_type;
294: l_eam_wo_relations_tbl(i).TOP_LEVEL_OBJECT_TYPE_ID :=1;
295: l_eam_wo_relations_tbl(i).TOP_LEVEL_HEADER_ID :=p_parent_wo_id;
296:
297: l_eam_wo_relations_tbl(i).RETURN_STATUS :=null;
298: l_eam_wo_relations_tbl(i).TRANSACTION_TYPE :=EAM_PROCESS_WO_PUB.G_OPR_CREATE;
299: end if;
300:
301: end if;
302: close c1;
321:
322: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);
323:
324:
325: eam_process_wo_pub.PROCESS_MASTER_CHILD_WO
326: ( p_bo_identifier => 'EAM'
327: , p_init_msg_list => TRUE
328: , p_api_version_number => 1.0
329: , p_eam_wo_relations_tbl => l_eam_wo_relations_tbl
400: l_old_flag VARCHAR2(1);
401: l_req_id NUMBER;
402:
403: -- parameters needed for the WO wrapper API call
404: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
405: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
406: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
407: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
408: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
401: l_req_id NUMBER;
402:
403: -- parameters needed for the WO wrapper API call
404: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
405: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
406: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
407: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
408: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
409: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
402:
403: -- parameters needed for the WO wrapper API call
404: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
405: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
406: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
407: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
408: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
409: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
410: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
403: -- parameters needed for the WO wrapper API call
404: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
405: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
406: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
407: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
408: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
409: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
410: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
411: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
404: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
405: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
406: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
407: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
408: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
409: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
410: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
411: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
412: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
405: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
406: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
407: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
408: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
409: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
410: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
411: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
412: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
413: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
406: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
407: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
408: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
409: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
410: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
411: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
412: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
413: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
414: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
407: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
408: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
409: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
410: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
411: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
412: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
413: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
414: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
415: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
408: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
409: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
410: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
411: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
412: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
413: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
414: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
415: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
416: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
409: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
410: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
411: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
412: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
413: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
414: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
415: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
416: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
417: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
410: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
411: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
412: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
413: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
414: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
415: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
416: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
417: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
418: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
411: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
412: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
413: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
414: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
415: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
416: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
417: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
418: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
419: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
412: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
413: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
414: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
415: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
416: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
417: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
418: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
419: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
420: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
413: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
414: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
415: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
416: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
417: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
418: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
419: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
420: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
421: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
414: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
415: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
416: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
417: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
418: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
419: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
420: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
421: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
422:
415: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
416: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
417: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
418: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
419: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
420: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
421: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
422:
423: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
416: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
417: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
418: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
419: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
420: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
421: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
422:
423: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
424: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
417: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
418: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
419: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
420: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
421: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
422:
423: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
424: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
425: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
419: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
420: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
421: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
422:
423: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
424: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
425: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
426: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
427: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
420: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
421: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
422:
423: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
424: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
425: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
426: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
427: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
428: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
421: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
422:
423: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
424: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
425: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
426: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
427: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
428: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
429: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
422:
423: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
424: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
425: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
426: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
427: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
428: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
429: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
430: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
423: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
424: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
425: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
426: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
427: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
428: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
429: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
430: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
431: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
424: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
425: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
426: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
427: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
428: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
429: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
430: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
431: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
432: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
425: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
426: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
427: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
428: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
429: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
430: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
431: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
432: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
433: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
426: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
427: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
428: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
429: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
430: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
431: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
432: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
433: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
434: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
427: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
428: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
429: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
430: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
431: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
432: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
433: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
434: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
435: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
428: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
429: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
430: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
431: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
432: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
433: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
434: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
435: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
436: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
429: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
430: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
431: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
432: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
433: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
434: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
435: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
436: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
437: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
430: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
431: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
432: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
433: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
434: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
435: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
436: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
437: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
438: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
431: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
432: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
433: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
434: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
435: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
436: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
437: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
438: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
439: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
432: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
433: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
434: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
435: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
436: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
437: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
438: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
439: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
440: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
433: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
434: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
435: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
436: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
437: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
438: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
439: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
440: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
441:
434: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
435: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
436: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
437: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
438: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
439: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
440: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
441:
442: l_return_status VARCHAR2(1);
435: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
436: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
437: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
438: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
439: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
440: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
441:
442: l_return_status VARCHAR2(1);
443: l_msl_count NUMBER;
436: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
437: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
438: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
439: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
440: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
441:
442: l_return_status VARCHAR2(1);
443: l_msl_count NUMBER;
444: l_message_text VARCHAR2(256);
514:
515: l_eam_wo_tbl(i).plan_maintenance := 'Y';
516: --fnd_file.put_line(FND_FILE.LOG, 'Anton: Create');
517: -- Create
518: l_eam_wo_tbl(i).transaction_type := eam_process_wo_pub.G_OPR_CREATE;
519: l_eam_wo_tbl(i).batch_id := p_pm_group_id;
520: l_eam_wo_tbl(i).header_id := i;
521: l_eam_wo_tbl(i).maintenance_object_source := 1; -- EAM
522: l_eam_wo_tbl(i).maintenance_object_type := sugg_rec.maintenance_object_type;
586: l_eam_wo_relations_tbl(i).TOP_LEVEL_OBJECT_TYPE_ID :=1;
587: l_eam_wo_relations_tbl(i).TOP_LEVEL_HEADER_ID :=p_parent_wo_id;
588:
589: l_eam_wo_relations_tbl(i).RETURN_STATUS :=null;
590: l_eam_wo_relations_tbl(i).TRANSACTION_TYPE :=EAM_PROCESS_WO_PUB.G_OPR_CREATE;
591: end if;
592:
593: i := i + 1;
594: j := j + 1;
601: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);
602:
603:
604:
605: eam_process_wo_pub.PROCESS_MASTER_CHILD_WO
606: ( p_bo_identifier => 'EAM'
607: , p_init_msg_list => TRUE
608: , p_api_version_number => 1.0
609: , p_eam_wo_relations_tbl => l_eam_wo_relations_tbl
869: l_scheduled_completion_date date;
870:
871: /* added for calling WO API */
872:
873: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
874: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
875: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
876: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
877: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
870:
871: /* added for calling WO API */
872:
873: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
874: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
875: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
876: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
877: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
878: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
871: /* added for calling WO API */
872:
873: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
874: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
875: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
876: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
877: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
878: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
879: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
872:
873: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
874: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
875: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
876: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
877: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
878: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
879: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
880: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
873: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
874: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
875: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
876: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
877: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
878: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
879: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
880: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
881: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
874: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
875: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
876: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
877: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
878: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
879: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
880: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
881: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
882: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
875: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
876: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
877: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
878: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
879: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
880: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
881: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
882: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
883: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
876: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
877: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
878: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
879: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
880: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
881: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
882: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
883: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
884: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
877: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
878: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
879: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
880: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
881: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
882: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
883: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
884: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
885: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
878: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
879: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
880: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
881: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
882: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
883: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
884: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
885: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
886: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
879: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
880: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
881: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
882: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
883: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
884: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
885: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
886: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
887: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
880: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
881: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
882: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
883: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
884: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
885: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
886: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
887: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
888: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
881: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
882: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
883: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
884: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
885: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
886: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
887: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
888: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
889: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
882: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
883: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
884: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
885: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
886: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
887: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
888: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
889: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
890: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
883: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
884: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
885: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
886: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
887: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
888: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
889: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
890: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
891: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
884: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
885: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
886: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
887: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
888: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
889: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
890: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
891: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
892:
885: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
886: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
887: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
888: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
889: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
890: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
891: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
892:
893: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
886: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
887: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
888: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
889: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
890: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
891: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
892:
893: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
894: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
887: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
888: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
889: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
890: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
891: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
892:
893: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
894: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
895: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
889: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
890: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
891: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
892:
893: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
894: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
895: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
896: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
897: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
890: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
891: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
892:
893: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
894: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
895: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
896: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
897: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
898: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
891: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
892:
893: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
894: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
895: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
896: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
897: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
898: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
899: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
892:
893: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
894: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
895: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
896: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
897: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
898: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
899: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
900: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
893: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
894: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
895: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
896: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
897: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
898: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
899: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
900: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
901: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
894: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
895: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
896: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
897: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
898: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
899: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
900: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
901: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
902: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
895: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
896: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
897: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
898: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
899: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
900: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
901: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
902: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
903: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
896: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
897: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
898: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
899: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
900: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
901: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
902: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
903: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
904: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
897: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
898: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
899: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
900: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
901: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
902: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
903: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
904: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
905: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
898: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
899: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
900: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
901: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
902: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
903: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
904: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
905: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
906: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
899: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
900: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
901: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
902: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
903: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
904: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
905: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
906: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
907: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
900: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
901: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
902: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
903: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
904: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
905: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
906: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
907: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
908: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
901: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
902: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
903: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
904: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
905: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
906: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
907: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
908: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
909: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
902: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
903: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
904: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
905: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
906: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
907: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
908: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
909: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
910:
903: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
904: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
905: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
906: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
907: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
908: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
909: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
910:
911: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
904: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
905: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
906: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
907: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
908: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
909: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
910:
911: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
912:
905: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
906: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
907: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
908: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
909: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
910:
911: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
912:
913: l_output_dir VARCHAR2(512);
907: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
908: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
909: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
910:
911: l_eam_wo_comp_rec EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type;
912:
913: l_output_dir VARCHAR2(512);
914: i number;
915: j number;
948: exit when l_wip_entity_id = work_orders_released.LAST;
949: l_wip_entity_id := work_orders_released.NEXT(l_wip_entity_id);
950: END LOOP;
951:
952: EAM_PROCESS_WO_PUB.Process_Master_Child_WO
953: ( p_bo_identifier => 'EAM'
954: , p_init_msg_list => TRUE
955: , p_api_version_number => 1.0
956: , p_eam_wo_tbl => l_eam_wo_tbl
1041: l_err_occured VARCHAR2(1);
1042:
1043: /* added for calling WO API */
1044:
1045: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1046: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1047: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1048: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1049: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1042:
1043: /* added for calling WO API */
1044:
1045: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1046: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1047: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1048: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1049: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1050: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1043: /* added for calling WO API */
1044:
1045: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1046: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1047: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1048: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1049: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1050: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1051: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1044:
1045: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1046: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1047: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1048: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1049: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1050: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1051: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1052: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1045: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1046: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1047: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1048: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1049: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1050: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1051: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1052: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1053: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1046: l_eam_wo_tbl_1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1047: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1048: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1049: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1050: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1051: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1052: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1053: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1054: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1047: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1048: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1049: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1050: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1051: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1052: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1053: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1054: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1055: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1048: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1049: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1050: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1051: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1052: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1053: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1054: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1055: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1056: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1049: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1050: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1051: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1052: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1053: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1054: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1055: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1056: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1057: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1050: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1051: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1052: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1053: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1054: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1055: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1056: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1057: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1058: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1051: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1052: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1053: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1054: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1055: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1056: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1057: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1058: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1059: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1052: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1053: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1054: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1055: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1056: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1057: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1058: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1059: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1060: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1053: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1054: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1055: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1056: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1057: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1058: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1059: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1060: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1061: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1054: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1055: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1056: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1057: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1058: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1059: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1060: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1061: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1062: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1055: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1056: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1057: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1058: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1059: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1060: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1061: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1062: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1063: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
1056: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1057: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1058: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1059: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1060: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1061: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1062: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1063: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
1064:
1057: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1058: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1059: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1060: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1061: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1062: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1063: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
1064:
1065: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1058: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1059: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1060: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1061: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1062: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1063: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
1064:
1065: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1066: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1059: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1060: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1061: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1062: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1063: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
1064:
1065: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1066: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1067: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1061: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1062: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1063: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
1064:
1065: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1066: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1067: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1068: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1069: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1062: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1063: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
1064:
1065: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1066: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1067: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1068: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1069: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1070: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1063: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
1064:
1065: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1066: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1067: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1068: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1069: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1070: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1071: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1064:
1065: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1066: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1067: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1068: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1069: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1070: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1071: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1072: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1065: l_eam_wo_tbl1 EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
1066: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1067: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1068: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1069: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1070: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1071: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1072: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1073: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1066: l_eam_wo_relations_tbl1 EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
1067: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1068: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1069: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1070: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1071: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1072: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1073: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1074: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1067: l_eam_op_tbl1 EAM_PROCESS_WO_PUB.eam_op_tbl_type;
1068: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1069: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1070: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1071: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1072: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1073: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1074: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1075: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1068: l_eam_op_network_tbl1 EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
1069: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1070: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1071: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1072: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1073: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1074: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1075: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1076: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1069: l_eam_res_tbl1 EAM_PROCESS_WO_PUB.eam_res_tbl_type;
1070: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1071: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1072: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1073: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1074: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1075: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1076: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1077: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1070: l_eam_res_inst_tbl1 EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
1071: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1072: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1073: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1074: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1075: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1076: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1077: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1078: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1071: l_eam_sub_res_tbl1 EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
1072: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1073: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1074: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1075: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1076: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1077: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1078: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1079: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1072: l_eam_mat_req_tbl1 EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
1073: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1074: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1075: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1076: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1077: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1078: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1079: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1080: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1073: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
1074: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1075: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1076: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1077: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1078: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1079: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1080: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1081: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1074: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
1075: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1076: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1077: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1078: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1079: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1080: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1081: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1082:
1075: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
1076: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1077: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1078: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1079: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1080: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1081: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1082:
1083: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1076: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
1077: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1078: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1079: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1080: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1081: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1082:
1083: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1084: l_eam_wo_rec_1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1077: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
1078: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
1079: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1080: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1081: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1082:
1083: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1084: l_eam_wo_rec_1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1085: l_output_dir VARCHAR2(512);
1079: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
1080: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1081: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1082:
1083: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1084: l_eam_wo_rec_1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1085: l_output_dir VARCHAR2(512);
1086: i number;
1087: j number;
1080: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
1081: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1082:
1083: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1084: l_eam_wo_rec_1 EAM_PROCESS_WO_PUB.eam_wo_rec_type;
1085: l_output_dir VARCHAR2(512);
1086: i number;
1087: j number;
1088: begin
1108: l_eam_wo_rec.batch_id := 1;
1109: l_eam_wo_rec.wip_entity_id := l_wip_entity_id;
1110: l_eam_wo_rec.organization_id := l_org_id;
1111: l_eam_wo_rec.status_type := 3;
1112: l_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
1113: l_eam_wo_tbl(i) :=l_eam_wo_rec;
1114: i := i + 1;
1115: exit when l_wip_entity_id = work_orders_unreleased.LAST;
1116: l_wip_entity_id := work_orders_unreleased.NEXT(l_wip_entity_id);
1115: exit when l_wip_entity_id = work_orders_unreleased.LAST;
1116: l_wip_entity_id := work_orders_unreleased.NEXT(l_wip_entity_id);
1117: END LOOP;
1118:
1119: EAM_PROCESS_WO_PUB.Process_Master_Child_WO
1120: ( p_bo_identifier => 'EAM'
1121: , p_init_msg_list => TRUE
1122: , p_api_version_number => 1.0
1123: , p_eam_wo_tbl => l_eam_wo_tbl
1181: l_eam_wo_rec_1.batch_id := 1;
1182: l_eam_wo_rec_1.wip_entity_id := l_wip_entity_id;
1183: l_eam_wo_rec_1.organization_id := l_org_id;
1184: l_eam_wo_rec_1.status_type := 3;
1185: l_eam_wo_rec_1.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
1186: l_eam_wo_tbl_1(j) :=l_eam_wo_rec_1;
1187: j := j + 1;
1188: exit when l_wip_entity_id = work_orders_not_ready.LAST ;
1189: l_wip_entity_id := work_orders_not_ready.NEXT(l_wip_entity_id);
1188: exit when l_wip_entity_id = work_orders_not_ready.LAST ;
1189: l_wip_entity_id := work_orders_not_ready.NEXT(l_wip_entity_id);
1190: END LOOP;
1191:
1192: EAM_PROCESS_WO_PUB.Process_Master_Child_WO
1193: ( p_bo_identifier => 'EAM'
1194: , p_init_msg_list => TRUE
1195: , p_api_version_number => 1.0
1196: , p_eam_wo_tbl => l_eam_wo_tbl_1