APPS.WMS_TASK_DISPATCH_DEVICE dependencies on WMS_DISPATCHED_TASKS

Line 200: DELETE FROM WMS_DISPATCHED_TASKS

196: AND organization_id=p_org_id;
197:
198: IF p_retain_dispatched_tasks ='N' or SQL%ROWCOUNT >1 THEN
199: -- signed off all the dispatched but not started tasks for this user
200: DELETE FROM WMS_DISPATCHED_TASKS
201: WHERE person_id = p_Employee_Id
202: and organization_id = p_org_id
203: and task_type IN (1, 3, 4, 5, 6)
204: and status IN (1,3,9); -- delete the Active task too, patchset I

Line 206: UPDATE WMS_DISPATCHED_TASKS

202: and organization_id = p_org_id
203: and task_type IN (1, 3, 4, 5, 6)
204: and status IN (1,3,9); -- delete the Active task too, patchset I
205: ELSE
206: UPDATE WMS_DISPATCHED_TASKS
207: SET status = 3
208: WHERE status = 9
209: and person_id = p_Employee_ID
210: and organization_id = p_org_id

Line 314: DELETE FROM WMS_DISPATCHED_TASKS

310: AND device_id = p_device_id;
311:
312: IF p_retain_dispatched_tasks ='N' or SQL%ROWCOUNT >1 THEN
313: -- signed off all the dispatched but not started tasks for this user
314: DELETE FROM WMS_DISPATCHED_TASKS
315: WHERE person_id = p_Employee_Id
316: and organization_id = p_org_id
317: and device_id = p_device_id
318: and task_type IN (1, 3, 4, 5, 6)

Line 321: UPDATE WMS_DISPATCHED_TASKS

317: and device_id = p_device_id
318: and task_type IN (1, 3, 4, 5, 6)
319: and status IN (1,3,9); -- delete the Active task too, patchset I
320: ELSE
321: UPDATE WMS_DISPATCHED_TASKS
322: SET status = 3
323: WHERE status = 9
324: and person_id = p_Employee_ID
325: and organization_id = p_org_id