51: ) IS
52: SELECT mmtt.organization_id
53: , mmtt.transfer_lpn_id
54: , wdt.task_id
55: FROM mtl_material_transactions_temp mmtt
56: , wms_dispatched_tasks wdt
57: WHERE mmtt.transaction_temp_id = p_temp_id
58: AND wdt.transaction_temp_id = mmtt.transaction_temp_id;
59:
215: ELSE
216: DELETE wms_dispatched_tasks
217: WHERE transaction_temp_id = p_parent_temp_id;
218:
219: DELETE mtl_material_transactions_temp
220: WHERE transaction_temp_id = p_parent_temp_id;
221: END IF;
222:
223: EXCEPTION