DBA Data[Home] [Help]

APPS.AHL_CMP_PVT dependencies on EAM_PROCESS_WO_PUB

Line 2548: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Before calling EAM_PROCESS_WO_PUB.'

2544: and task.instance_id = p_instance_id;
2545: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Openworkorders for the instance::' || l_open_wo_count);
2546: END IF;
2547: IF (l_log_statement >= l_log_current_level) THEN
2548: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Before calling EAM_PROCESS_WO_PUB.'
2549: || 'process_wo');
2550: SELECT COUNT(wip_entity_id) INTO l_wipEntityIds FROM wip_discrete_jobs
2551: where maintenance_object_id = p_instance_id;
2552: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'EAMWOcount Before exec'

Line 2583: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'After calling EAM_PROCESS_WO_PUB.'

2579: RAISE FND_API.G_EXC_ERROR;
2580: END IF;
2581: END IF;
2582: IF (l_log_statement >= l_log_current_level) THEN
2583: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'After calling EAM_PROCESS_WO_PUB.'
2584: || 'process_wo');
2585: SELECT COUNT(wip_entity_id) INTO l_wipEntityIds FROM wip_discrete_jobs
2586: where maintenance_object_id = p_instance_id;
2587: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'EAMWOcount after exec'

Line 3124: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

3120: l_item_id NUMBER;
3121: l_organization_id NUMBER;
3122: l_wo_status_code NUMBER;
3123: l_msg_count NUMBER;
3124: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3125: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3126: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3127: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3128: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 3125: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

3121: l_organization_id NUMBER;
3122: l_wo_status_code NUMBER;
3123: l_msg_count NUMBER;
3124: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3125: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3126: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3127: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3128: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3129: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 3126: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

3122: l_wo_status_code NUMBER;
3123: l_msg_count NUMBER;
3124: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3125: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3126: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3127: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3128: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3129: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3130: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 3127: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

3123: l_msg_count NUMBER;
3124: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3125: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3126: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3127: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3128: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3129: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3130: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3131: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 3128: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

3124: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3125: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3126: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3127: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3128: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3129: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3130: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3131: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3132: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 3129: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

3125: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3126: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3127: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3128: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3129: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3130: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3131: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3132: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3133: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 3130: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

3126: l_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3127: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3128: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3129: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3130: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3131: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3132: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3133: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3134: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 3131: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

3127: l_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3128: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3129: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3130: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3131: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3132: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3133: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3134: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3135: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

Line 3132: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

3128: l_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3129: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3130: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3131: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3132: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3133: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3134: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3135: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3136: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

Line 3133: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

3129: l_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3130: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3131: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3132: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3133: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3134: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3135: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3136: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3137: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

Line 3134: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

3130: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3131: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3132: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3133: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3134: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3135: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3136: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3137: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3138: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

Line 3135: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;

3131: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3132: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3133: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3134: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3135: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3136: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3137: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3138: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3139: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

Line 3136: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;

3132: l_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3133: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3134: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3135: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3136: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3137: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3138: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3139: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3140: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

Line 3137: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;

3133: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
3134: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3135: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3136: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3137: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3138: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3139: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3140: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3141: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

Line 3138: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;

3134: l_out_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;
3135: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3136: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3137: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3138: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3139: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3140: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3141: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3142:

Line 3139: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;

3135: l_out_eam_op_network_tbl EAM_PROCESS_WO_PUB.eam_op_network_tbl_type;
3136: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3137: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3138: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3139: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3140: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3141: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3142:
3143: l_msg_index_out NUMBER;

Line 3140: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;

3136: l_out_eam_res_tbl EAM_PROCESS_WO_PUB.eam_res_tbl_type;
3137: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3138: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3139: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3140: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3141: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3142:
3143: l_msg_index_out NUMBER;
3144:

Line 3141: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;

3137: l_out_eam_res_inst_tbl EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type;
3138: l_out_eam_sub_res_tbl EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type;
3139: l_out_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3140: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
3141: l_out_eam_direct_items_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3142:
3143: l_msg_index_out NUMBER;
3144:
3145: l_api_name CONSTANT VARCHAR2(30) := 'Update_EAM_Workorders';

Line 3189: l_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;

3185: l_eam_wo_rec.organization_id := l_organization_id;
3186: l_eam_wo_rec.rebuild_item_id := l_item_id;
3187: l_eam_wo_rec.maintenance_object_id := p_instance_id;
3188: l_eam_wo_rec.status_type := TO_NUMBER(l_wo_status_code);
3189: l_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
3190:
3191: -- Invoke EAM BO API for Updating the Job
3192: EAM_PROCESS_WO_PUB.process_wo
3193: (

Line 3192: EAM_PROCESS_WO_PUB.process_wo

3188: l_eam_wo_rec.status_type := TO_NUMBER(l_wo_status_code);
3189: l_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
3190:
3191: -- Invoke EAM BO API for Updating the Job
3192: EAM_PROCESS_WO_PUB.process_wo
3193: (
3194: p_bo_identifier => l_bo_identifier,
3195: p_api_version_number => 1.0,
3196: p_init_msg_list => l_init_msg_list,

Line 3226: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'After calling EAM_PROCESS_WO_PUB.'

3222: );
3223:
3224:
3225: IF (l_log_statement >= l_log_current_level) THEN
3226: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'After calling EAM_PROCESS_WO_PUB.'
3227: || 'process_wo');
3228: END IF;
3229:
3230: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN