DBA Data[Home] [Help]

APPS.INV_TRX_UTIL_PUB dependencies on WMS_DISPATCHED_TASKS

Line 2130: DELETE wms_dispatched_tasks

2126: END IF;
2127: END IF;
2128:
2129: -- Deleting the Task
2130: DELETE wms_dispatched_tasks
2131: WHERE transaction_temp_id = p_transaction_temp_id;
2132:
2133: IF l_debug = 1 THEN
2134: TRACE('Records deleted in WDT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');

Line 2431: DELETE wms_dispatched_tasks WHERE transaction_temp_id = p_parent_line_id;

2427: IF l_debug = 1 THEN
2428: TRACE('Deleting the Parent Task with Txn Temp ID = ' || p_parent_line_id, 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2429: END IF;
2430:
2431: DELETE wms_dispatched_tasks WHERE transaction_temp_id = p_parent_line_id;
2432: DELETE mtl_material_transactions_temp WHERE transaction_temp_id = p_parent_line_id;
2433: END IF;
2434: END IF;
2435: EXCEPTION