DBA Data[Home] [Help]

APPS.EAM_FORECAST_PVT dependencies on EAM_PROCESS_WO_PUB

Line 2794: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;

2790: l_old_flag VARCHAR2(1);
2791: l_req_id NUMBER;
2792:
2793: -- parameters needed for the WO wrapper API call
2794: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
2795: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
2796: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
2797: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
2798: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;

Line 2795: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;

2791: l_req_id NUMBER;
2792:
2793: -- parameters needed for the WO wrapper API call
2794: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
2795: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
2796: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
2797: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
2798: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
2799: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;

Line 2796: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;

2792:
2793: -- parameters needed for the WO wrapper API call
2794: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
2795: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
2796: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
2797: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
2798: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
2799: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
2800: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;

Line 2797: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;

2793: -- parameters needed for the WO wrapper API call
2794: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
2795: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
2796: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
2797: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
2798: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
2799: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
2800: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
2801: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;

Line 2798: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;

2794: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
2795: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
2796: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
2797: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
2798: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
2799: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
2800: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
2801: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
2802: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;

Line 2799: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;

2795: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
2796: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
2797: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
2798: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
2799: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
2800: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
2801: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
2802: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
2803: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 2800: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;

2796: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
2797: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
2798: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
2799: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
2800: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
2801: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
2802: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
2803: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2804: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

Line 2801: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;

2797: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
2798: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
2799: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
2800: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
2801: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
2802: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
2803: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2804: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2805: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

Line 2802: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;

2798: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
2799: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
2800: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
2801: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
2802: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
2803: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2804: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2805: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2806: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

Line 2803: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

2799: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
2800: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
2801: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
2802: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
2803: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2804: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2805: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2806: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2807: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

Line 2804: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

2800: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
2801: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
2802: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
2803: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2804: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2805: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2806: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2807: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2808: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

Line 2805: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

2801: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
2802: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
2803: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2804: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2805: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2806: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2807: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2808: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2809: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

Line 2806: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

2802: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
2803: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2804: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2805: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2806: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2807: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2808: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2809: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2810: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

Line 2807: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

2803: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2804: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2805: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2806: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2807: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2808: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2809: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2810: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2811: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

Line 2808: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

2804: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2805: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2806: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2807: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2808: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2809: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2810: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2811: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2812:

Line 2809: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

2805: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2806: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2807: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2808: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2809: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2810: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2811: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2812:
2813: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;

Line 2810: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

2806: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2807: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2808: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2809: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2810: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2811: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2812:
2813: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
2814: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;

Line 2811: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

2807: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2808: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2809: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2810: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2811: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2812:
2813: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
2814: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
2815: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;

Line 2813: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;

2809: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2810: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2811: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2812:
2813: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
2814: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
2815: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
2816: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
2817: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;

Line 2814: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;

2810: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2811: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2812:
2813: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
2814: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
2815: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
2816: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
2817: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
2818: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;

Line 2815: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;

2811: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2812:
2813: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
2814: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
2815: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
2816: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
2817: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
2818: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
2819: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;

Line 2816: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;

2812:
2813: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
2814: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
2815: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
2816: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
2817: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
2818: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
2819: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
2820: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;

Line 2817: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;

2813: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
2814: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
2815: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
2816: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
2817: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
2818: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
2819: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
2820: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
2821: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;

Line 2818: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;

2814: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
2815: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
2816: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
2817: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
2818: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
2819: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
2820: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
2821: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
2822: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 2819: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;

2815: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
2816: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
2817: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
2818: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
2819: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
2820: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
2821: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
2822: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2823: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

Line 2820: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;

2816: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
2817: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
2818: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
2819: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
2820: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
2821: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
2822: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2823: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2824: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

Line 2821: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;

2817: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
2818: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
2819: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
2820: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
2821: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
2822: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2823: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2824: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2825: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

Line 2822: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

2818: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
2819: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
2820: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
2821: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
2822: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2823: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2824: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2825: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2826: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

Line 2823: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

2819: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
2820: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
2821: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
2822: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2823: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2824: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2825: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2826: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2827: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

Line 2824: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

2820: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
2821: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
2822: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2823: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2824: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2825: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2826: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2827: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2828: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

Line 2825: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

2821: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
2822: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2823: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2824: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2825: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2826: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2827: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2828: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2829: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

Line 2826: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

2822: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
2823: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2824: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2825: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2826: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2827: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2828: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2829: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2830: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

Line 2827: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

2823: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
2824: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2825: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2826: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2827: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2828: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2829: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2830: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2831:

Line 2828: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

2824: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
2825: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2826: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2827: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2828: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2829: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2830: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2831:
2832: l_return_status VARCHAR2(1);

Line 2829: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

2825: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
2826: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2827: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2828: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2829: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2830: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2831:
2832: l_return_status VARCHAR2(1);
2833: l_msl_count NUMBER;

Line 2830: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

2826: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
2827: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
2828: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
2829: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
2830: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
2831:
2832: l_return_status VARCHAR2(1);
2833: l_msl_count NUMBER;
2834: l_message_text VARCHAR2(256);

Line 2919: l_eam_wo_tbl(i).transaction_type := eam_process_wo_pub.G_OPR_CREATE;

2915: if(sugg_rec.action_type IN (2,6,7,1,4)) then
2916: debug('EXPANDING: ' || sugg_rec.action_type);
2917: l_eam_wo_tbl(i).plan_maintenance := 'Y';
2918:
2919: l_eam_wo_tbl(i).transaction_type := eam_process_wo_pub.G_OPR_CREATE;
2920:
2921: l_eam_wo_tbl(i).maintenance_object_source := 1; -- EAM
2922: l_eam_wo_tbl(i).maintenance_object_type := sugg_rec.maintenance_object_type;
2923: l_eam_wo_tbl(i).maintenance_object_id := sugg_rec.maintenance_object_id;

Line 2980: eam_process_wo_pub.PROCESS_MASTER_CHILD_WO

2976:
2977: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);
2978: debug('CALLING PROCCESS: ' || l_eam_wo_tbl.COUNT);
2979:
2980: eam_process_wo_pub.PROCESS_MASTER_CHILD_WO
2981: ( p_bo_identifier => 'EAM'
2982: , p_init_msg_list => TRUE
2983: , p_api_version_number => 1.0
2984: , p_eam_wo_relations_tbl => l_eam_wo_relations_tbl