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: -- Bug 14773855. Update allocated Flag when Move order is back ordered.
269: if p_primary_quantity > 0 then

Line 270: update 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: -- Bug 14773855. Update allocated Flag when Move order is back ordered.
269: if p_primary_quantity > 0 then
270: update wip_flow_schedules
271: set allocated_flag = 'Y'
272: where wip_entity_id = p_wip_entity_id;
273: return;
274: else

Line 275: update wip_flow_schedules

271: set allocated_flag = 'Y'
272: where wip_entity_id = p_wip_entity_id;
273: return;
274: else
275: update wip_flow_schedules
276: set allocated_flag = 'N'
277: where wip_entity_id = p_wip_entity_id;
278: return;
279: end if;