APPS.WMS_CONTROL_BOARD dependencies on WMS_DISPATCHED_TASKS

Line 451: FROM WMS_DISPATCHED_TASKS

447: , status
448: , priority
449: , person_id
450: , person_resource_id
451: FROM WMS_DISPATCHED_TASKS
452: WHERE transaction_temp_id = p_transaction_temp_id
453: AND task_id = p_task_id
454: FOR UPDATE OF status, priority, person_id, person_resource_id NOWAIT;
455:

Line 716: UPDATE wms_dispatched_tasks

712: ) IS
713: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
714: BEGIN
715: --dbms_output.put_line('in update wdt');
716: UPDATE wms_dispatched_tasks
717: SET
718: person_resource_id = p_person_resource_id
719: , person_id = p_person_id
720: , priority = p_priority

Line 758: SELECT wms_dispatched_tasks_s.NEXTVAL

754: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
755: BEGIN
756:
757: --Get value from sequence for next task id
758: SELECT wms_dispatched_tasks_s.NEXTVAL
759: INTO l_next_task_id
760: FROM dual ;
761:
762: -- Obtain org_id, user_task_type and task_type

Line 779: INSERT INTO WMS_DISPATCHED_TASKS

775:
776: --dbms_output.put_line('Before Insert into WMSDT');
777:
778:
779: INSERT INTO WMS_DISPATCHED_TASKS
780: ( TASK_ID
781: , TRANSACTION_TEMP_ID
782: , ORGANIZATION_ID
783: , USER_TASK_TYPE

Line 826: DELETE FROM wms_dispatched_tasks

822: PROCEDURE delete_from_wdt(
823: p_transaction_temp_id IN NUMBER , p_task_id IN NUMBER) IS
824: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
825: BEGIN
826: DELETE FROM wms_dispatched_tasks
827: WHERE transaction_temp_id = p_transaction_temp_id
828: AND task_id = nvl(p_task_id, task_id);
829:
830: END delete_from_wdt;