APPS.EAM_OP_UTILITY_PVT dependencies on WIP_EAM_DIRECT_ITEMS

Line 316: FROM wip_eam_direct_items

312: and wip_entity_id = p_eam_op_rec.wip_entity_id ;
313: END IF;
314:
315: SELECT count(*) INTO l_count
316: FROM wip_eam_direct_items
317: WHERE organization_id = p_eam_op_rec.organization_id
318: AND wip_entity_id = p_eam_op_rec.wip_entity_id
319: AND operation_seq_num = 1
320: AND rownum <=1;

Line 332: from wip_eam_direct_items

328:
329: IF (l_min_op_seq_num is not null) THEN
330: begin
331: select department_id into l_department_id
332: from wip_eam_direct_items
333: where organization_id = p_eam_op_rec.organization_id
334: and wip_entity_id = p_eam_op_rec.wip_entity_id
335: and operation_seq_num = l_min_op_seq_num;
336: exception when no_data_found then

Line 341: update wip_eam_direct_items

337: null;
338: end;
339: END IF;
340:
341: update wip_eam_direct_items
342: set operation_seq_num = l_min_op_seq_num,
343: department_id = l_department_id
344: where operation_seq_num = 1
345: and organization_id = p_eam_op_rec.organization_id

Line 451: UPDATE WIP_EAM_DIRECT_ITEMS

447: WHERE organization_id = p_eam_op_rec.organization_id
448: AND wip_entity_id = p_eam_op_rec.wip_entity_id
449: AND operation_seq_num = p_eam_op_rec.operation_seq_num ;
450:
451: UPDATE WIP_EAM_DIRECT_ITEMS
452: SET Department_id = p_eam_op_rec.department_id
453: WHERE organization_id = p_eam_op_rec.organization_id
454: AND wip_entity_id = p_eam_op_rec.wip_entity_id
455: AND operation_seq_num = p_eam_op_rec.operation_seq_num ;