DBA Data[Home] [Help]

APPS.INV_TRX_UTIL_PUB dependencies on WMS_DISPATCHED_TASKS

Line 1975: DELETE wms_dispatched_tasks

1971: END IF;
1972: END IF;
1973:
1974: -- Deleting the Task
1975: DELETE wms_dispatched_tasks
1976: WHERE transaction_temp_id = p_transaction_temp_id;
1977:
1978: IF l_debug = 1 THEN
1979: TRACE('Records deleted in WDT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');

Line 2235: DELETE wms_dispatched_tasks WHERE transaction_temp_id = p_parent_line_id;

2231: IF l_debug = 1 THEN
2232: TRACE('Deleting the Parent Task with Txn Temp ID = ' || p_parent_line_id, 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2233: END IF;
2234:
2235: DELETE wms_dispatched_tasks WHERE transaction_temp_id = p_parent_line_id;
2236: DELETE mtl_material_transactions_temp WHERE transaction_temp_id = p_parent_line_id;
2237: END IF;
2238: END IF;
2239: EXCEPTION