APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on WMS_DISPATCHED_TASKS

Line 115: --Get MMTT id from WMS_Dispatched_tasks

111: IF (l_debug = 1) THEN
112: mdebug('Inside wms_txnrsn_actions_pub.Inadequate Quantity: Before update quantity ');
113: END IF;
114:
115: --Get MMTT id from WMS_Dispatched_tasks
116: SELECT transaction_temp_id
117: INTO l_mmtt_id
118: FROM wms_dispatched_tasks
119: WHERE task_id=p_task_id;

Line 118: FROM wms_dispatched_tasks

114:
115: --Get MMTT id from WMS_Dispatched_tasks
116: SELECT transaction_temp_id
117: INTO l_mmtt_id
118: FROM wms_dispatched_tasks
119: WHERE task_id=p_task_id;
120: IF (l_debug = 1) THEN
121: mdebug('l_mmtt_id: '|| l_mmtt_id);
122: END IF;

Line 735: DELETE FROM wms_dispatched_tasks

731:
732: -- zero out the quantity of mmtt in order to do pick release again
733:
734: -- delete task
735: DELETE FROM wms_dispatched_tasks
736: WHERE transaction_temp_id = l_mmtt_id;
737: -- transfer reservation is taking care of detailed_quantity in mtl_reservations
738: -- zero the quantity for original mmtt line so pick release is going to work
739:

Line 1607: SELECT 1 FROM wms_dispatched_tasks

1603: -- without the condition curtail pick for bulk pick will fail since this cursor picks up child mmtt lines
1604: AND mmtt.item_lot_control_code = 1
1605: AND mmtt.item_serial_control_code in (1,6)
1606: AND NOT EXISTS (
1607: SELECT 1 FROM wms_dispatched_tasks
1608: WHERE transaction_temp_id= mmtt.transaction_temp_id
1609: AND status in (4,9)) ;
1610:
1611: BEGIN

Line 1941: DELETE FROM wms_dispatched_tasks WHERE transaction_temp_id = p_temp_id;

1937: END IF;
1938: -- MRANA : added the following 3392471 . : 26-feb-04
1939: -- Cascade delete the current MMTT and WDT That was just processed
1940:
1941: DELETE FROM wms_dispatched_tasks WHERE transaction_temp_id = p_temp_id;
1942: IF SQL%NOTFOUND THEN
1943: mdebug ('NO WDT TO DELETE' );
1944: -- could not find the task to delete.. do not worry
1945: null;

Line 2137: DELETE FROM wms_dispatched_tasks WHERE transaction_temp_id = p_temp_id;

2133: l_progress := '320';
2134: IF (l_debug = 1) THEN
2135: mdebug ('l_progress: ' || l_progress );
2136: END IF;
2137: DELETE FROM wms_dispatched_tasks WHERE transaction_temp_id = p_temp_id;
2138:
2139: IF SQL%NOTFOUND THEN
2140: mdebug ('NO WDT TO DELETE' );
2141: -- could not find the task to delete.. do not worry