APPS.WIP_BOMROUTING_PVT dependencies on WIP_OPERATIONS

Line 374: delete from wip_operations

370: wip_update_setup_resources.delete_setup_resources_pub(
371: p_wip_entity_id => p_wipEntityID,
372: p_organization_id => p_orgID);
373:
374: delete from wip_operations
375: where wip_entity_id = p_wipEntityID
376: and organization_id = p_orgID;
377:
378: delete from wip_operation_resources

Line 535: update wip_operations

531: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
532: raise fnd_api.g_exc_unexpected_error;
533: end if;
534: else
535: update wip_operations
536: set first_unit_start_date = p_startDate,
537: first_unit_completion_date = p_startDate,
538: last_unit_start_date = p_startDate,
539: last_unit_completion_date = p_startDate

Line 558: from wip_operations wo

554:
555: -- need to adjust the data required field
556: update wip_requirement_operations wro
557: set wro.date_required = (select nvl(max(wo.first_unit_start_date), l_startDate)
558: from wip_operations wo
559: where wo.organization_id = wro.organization_id
560: and wo.wip_entity_id = wro.wip_entity_id
561: and wo.operation_seq_num = abs(wro.operation_seq_num))
562: where wro.wip_entity_id = p_wipEntityID