DBA Data[Home] [Help]

APPS.EAM_RES_INST_UTILITY_PVT dependencies on WIP_OPERATION_RESOURCE_USAGE

Line 265: DELETE FROM WIP_OPERATION_RESOURCE_USAGE

261:
262: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Resource Instance Usages: '|| p_eam_res_inst_rec.instance_id); END IF;
263:
264: IF p_eam_res_inst_rec.serial_number is NULL THEN
265: DELETE FROM WIP_OPERATION_RESOURCE_USAGE
266: WHERE wip_entity_id = p_eam_res_inst_rec.wip_entity_id
267: AND organization_id = p_eam_res_inst_rec.organization_id
268: AND operation_seq_num = p_eam_res_inst_rec.operation_seq_num
269: AND resource_seq_num = p_eam_res_inst_rec.resource_seq_num

Line 272: DELETE FROM WIP_OPERATION_RESOURCE_USAGE

268: AND operation_seq_num = p_eam_res_inst_rec.operation_seq_num
269: AND resource_seq_num = p_eam_res_inst_rec.resource_seq_num
270: AND instance_id = p_eam_res_inst_rec.instance_id;
271: ELSE
272: DELETE FROM WIP_OPERATION_RESOURCE_USAGE
273: WHERE wip_entity_id = p_eam_res_inst_rec.wip_entity_id
274: AND organization_id = p_eam_res_inst_rec.organization_id
275: AND operation_seq_num = p_eam_res_inst_rec.operation_seq_num
276: AND resource_seq_num = p_eam_res_inst_rec.resource_seq_num