APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on WMS_DISPATCHED_TASKS

Line 117: --Get MMTT id from WMS_Dispatched_tasks

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

Line 120: FROM wms_dispatched_tasks

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

Line 850: DELETE FROM wms_dispatched_tasks

846: END IF;--}
847:
848: -- zero out the quantity of mmtt in order to do pick release again
849: -- delete task
850: DELETE FROM wms_dispatched_tasks
851: WHERE transaction_temp_id = l_mmtt_id;
852:
853: -- transfer reservation is taking care of detailed_quantity in mtl_reservations
854: -- zero the quantity for original mmtt line so pick release is going to work

Line 2136: SELECT 1 FROM wms_dispatched_tasks

2132: SELECT 1 FROM MTL_SERIAL_NUMBERS_TEMP MSNT
2133: WHERE MSNT.TRANSACTION_TEMP_ID= mmtt.transaction_temp_id --Should not have serials allocated.
2134: )
2135: AND NOT EXISTS (
2136: SELECT 1 FROM wms_dispatched_tasks
2137: WHERE transaction_temp_id= mmtt.transaction_temp_id
2138: AND status in (4,9)) ;
2139:
2140: BEGIN

Line 2499: DELETE FROM wms_dispatched_tasks WHERE transaction_temp_id = p_temp_id;

2495: END IF;
2496: -- MRANA : added the following 3392471 . : 26-feb-04
2497: -- Cascade delete the current MMTT and WDT That was just processed
2498:
2499: DELETE FROM wms_dispatched_tasks WHERE transaction_temp_id = p_temp_id;
2500: IF SQL%NOTFOUND THEN
2501: mdebug ('NO WDT TO DELETE' );
2502: -- could not find the task to delete.. do not worry
2503: null;

Line 2769: DELETE FROM wms_dispatched_tasks WHERE transaction_temp_id = p_temp_id;

2765: l_progress := '320';
2766: IF (l_debug = 1) THEN
2767: mdebug ('l_progress: ' || l_progress );
2768: END IF;
2769: DELETE FROM wms_dispatched_tasks WHERE transaction_temp_id = p_temp_id;
2770:
2771: IF SQL%NOTFOUND THEN
2772: mdebug ('NO WDT TO DELETE' );
2773: -- could not find the task to delete.. do not worry