DBA Data[Home] [Help]

APPS.EAM_OP_COMP_UTILITY_PVT dependencies on WIP_OPERATIONS

Line 291: FROM wip_operations wo

287:
288: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entered Package EAM_OP_COMP_UTILITY_PVT.update_row procedure..'); END IF;
289:
290: SELECT wo.shutdown_type INTO l_shutdown_type
291: FROM wip_operations wo
292: WHERE wo.wip_entity_id = p_eam_op_comp_rec.wip_entity_id
293: AND wo.operation_seq_num = p_eam_op_comp_rec.operation_seq_num;
294:
295: -- Enhancemnet Bug 3852846

Line 308: UPDATE wip_operations

304: AND operation_seq_num = p_eam_op_comp_rec.operation_seq_num
305: AND enable_flag = 'Y' OR enable_flag IS NULL;
306: END IF;
307:
308: UPDATE wip_operations
309: SET
310: operation_completed = decode(p_eam_op_comp_rec.transaction_type,EAM_PROCESS_WO_PVT.G_OPR_COMPLETE,'Y',EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE,'N'),
311: quantity_completed = 1,
312: last_updated_by = FND_GLOBAL.user_id,