DBA Data[Home] [Help]

APPS.WIP_PICKING_PUB dependencies on WIP_FLOW_SCHEDULES

Line 265: from wip_flow_schedules

261: where wip_entity_id = p_wip_entity_id;
262: if(l_entityType = wip_constants.flow) then --flow schedule
263: select allocated_flag
264: into l_flow
265: from wip_flow_schedules
266: where wip_entity_id = p_wip_entity_id
267: for update of allocated_flag nowait; --set error code if row is locked
268:
269: update wip_flow_schedules

Line 269: update wip_flow_schedules

265: from wip_flow_schedules
266: where wip_entity_id = p_wip_entity_id
267: for update of allocated_flag nowait; --set error code if row is locked
268:
269: update wip_flow_schedules
270: set allocated_flag = 'Y'
271: where wip_entity_id = p_wip_entity_id;
272: return;
273: end if;