DBA Data[Home] [Help]

APPS.EAM_FORECAST_PVT dependencies on EAM_PROCESS_WO_PUB

Line 3132: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;

3128: l_old_flag VARCHAR2(1);
3129: l_req_id NUMBER;
3130:
3131: -- parameters needed for the WO wrapper API call
3132: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
3133: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
3134: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
3135: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
3136: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;

Line 3133: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;

3129: l_req_id NUMBER;
3130:
3131: -- parameters needed for the WO wrapper API call
3132: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
3133: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
3134: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
3135: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
3136: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
3137: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;

Line 3134: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;

3130:
3131: -- parameters needed for the WO wrapper API call
3132: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
3133: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
3134: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
3135: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
3136: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
3137: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
3138: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;

Line 3135: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;

3131: -- parameters needed for the WO wrapper API call
3132: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
3133: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
3134: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
3135: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
3136: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
3137: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
3138: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
3139: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;

Line 3136: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;

3132: l_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
3133: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
3134: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
3135: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
3136: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
3137: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
3138: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
3139: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
3140: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;

Line 3137: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;

3133: l_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
3134: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
3135: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
3136: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
3137: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
3138: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
3139: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
3140: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
3141: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 3138: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;

3134: l_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
3135: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
3136: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
3137: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
3138: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
3139: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
3140: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
3141: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3142: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

Line 3139: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;

3135: l_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
3136: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
3137: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
3138: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
3139: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
3140: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
3141: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3142: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3143: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

Line 3140: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;

3136: l_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
3137: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
3138: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
3139: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
3140: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
3141: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3142: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3143: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3144: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

Line 3141: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

3137: l_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
3138: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
3139: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
3140: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
3141: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3142: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3143: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3144: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3145: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

Line 3142: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

3138: l_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
3139: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
3140: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
3141: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3142: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3143: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3144: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3145: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3146: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

Line 3143: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

3139: l_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
3140: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
3141: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3142: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3143: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3144: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3145: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3146: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3147: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

Line 3144: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

3140: l_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
3141: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3142: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3143: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3144: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3145: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3146: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3147: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3148: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

Line 3145: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

3141: l_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3142: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3143: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3144: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3145: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3146: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3147: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3148: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3149: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

Line 3146: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

3142: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3143: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3144: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3145: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3146: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3147: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3148: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3149: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3150:

Line 3147: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

3143: l_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3144: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3145: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3146: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3147: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3148: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3149: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3150:
3151: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;

Line 3148: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

3144: l_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3145: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3146: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3147: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3148: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3149: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3150:
3151: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
3152: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;

Line 3149: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

3145: l_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3146: l_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3147: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3148: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3149: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3150:
3151: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
3152: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
3153: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;

Line 3151: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;

3147: l_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3148: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3149: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3150:
3151: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
3152: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
3153: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
3154: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
3155: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;

Line 3152: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;

3148: l_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3149: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3150:
3151: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
3152: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
3153: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
3154: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
3155: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
3156: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;

Line 3153: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;

3149: l_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3150:
3151: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
3152: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
3153: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
3154: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
3155: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
3156: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
3157: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;

Line 3154: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;

3150:
3151: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
3152: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
3153: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
3154: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
3155: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
3156: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
3157: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
3158: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;

Line 3155: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;

3151: l_out_eam_wo_tbl eam_process_wo_pub.eam_wo_tbl_type;
3152: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
3153: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
3154: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
3155: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
3156: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
3157: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
3158: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
3159: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;

Line 3156: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;

3152: l_out_eam_wo_relations_tbl eam_process_wo_pub.eam_wo_relations_tbl_type;
3153: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
3154: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
3155: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
3156: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
3157: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
3158: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
3159: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
3160: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 3157: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;

3153: l_out_eam_op_tbl eam_process_wo_pub.eam_op_tbl_type;
3154: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
3155: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
3156: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
3157: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
3158: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
3159: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
3160: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3161: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

Line 3158: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;

3154: l_out_eam_op_network_tbl eam_process_wo_pub.eam_op_network_tbl_type;
3155: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
3156: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
3157: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
3158: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
3159: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
3160: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3161: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3162: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

Line 3159: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;

3155: l_out_eam_res_tbl eam_process_wo_pub.eam_res_tbl_type;
3156: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
3157: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
3158: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
3159: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
3160: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3161: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3162: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3163: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

Line 3160: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

3156: l_out_eam_res_inst_tbl eam_process_wo_pub.eam_res_inst_tbl_type;
3157: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
3158: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
3159: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
3160: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3161: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3162: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3163: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3164: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

Line 3161: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

3157: l_out_eam_sub_res_tbl eam_process_wo_pub.eam_sub_res_tbl_type;
3158: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
3159: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
3160: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3161: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3162: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3163: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3164: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3165: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

Line 3162: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;

3158: l_out_eam_res_usage_tbl eam_process_wo_pub.eam_res_usage_tbl_type;
3159: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
3160: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3161: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3162: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3163: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3164: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3165: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3166: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

Line 3163: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;

3159: l_out_eam_mat_req_tbl eam_process_wo_pub.eam_mat_req_tbl_type;
3160: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3161: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3162: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3163: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3164: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3165: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3166: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3167: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

Line 3164: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;

3160: l_out_eam_direct_item_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3161: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3162: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3163: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3164: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3165: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3166: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3167: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3168: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

Line 3165: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;

3161: l_out_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;
3162: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3163: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3164: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3165: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3166: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3167: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3168: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3169:

Line 3166: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;

3162: l_out_eam_wo_quality_tbl EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type;
3163: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3164: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3165: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3166: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3167: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3168: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3169:
3170: l_return_status VARCHAR2(1);

Line 3167: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;

3163: l_out_eam_meter_reading_tbl EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type;
3164: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3165: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3166: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3167: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3168: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3169:
3170: l_return_status VARCHAR2(1);
3171: l_msl_count NUMBER;

Line 3168: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;

3164: l_out_eam_wo_comp_rebuild_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type;
3165: l_out_eam_wo_comp_mr_read_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type;
3166: l_out_eam_op_comp_tbl EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type;
3167: l_out_eam_request_tbl EAM_PROCESS_WO_PUB.eam_request_tbl_type;
3168: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
3169:
3170: l_return_status VARCHAR2(1);
3171: l_msl_count NUMBER;
3172: l_message_text VARCHAR2(256);

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

3253: if(sugg_rec.action_type IN (2,6,7,1,4)) then
3254: debug('EXPANDING: ' || sugg_rec.action_type);
3255: l_eam_wo_tbl(i).plan_maintenance := 'Y';
3256:
3257: l_eam_wo_tbl(i).transaction_type := eam_process_wo_pub.G_OPR_CREATE;
3258: l_eam_wo_tbl(i).source_code := 'BUD'; -- budget forecast ER 14323372
3259:
3260: l_eam_wo_tbl(i).maintenance_object_source := 1; -- EAM
3261: l_eam_wo_tbl(i).maintenance_object_type := sugg_rec.maintenance_object_type;

Line 3319: eam_process_wo_pub.PROCESS_MASTER_CHILD_WO

3315:
3316: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);
3317: debug('CALLING PROCCESS: ' || l_eam_wo_tbl.COUNT);
3318:
3319: eam_process_wo_pub.PROCESS_MASTER_CHILD_WO
3320: ( p_bo_identifier => 'EAM'
3321: , p_init_msg_list => TRUE
3322: , p_api_version_number => 1.0
3323: , p_eam_wo_relations_tbl => l_eam_wo_relations_tbl