154: WHEN OTHERS THEN NULL;
155: END;
156: --
157: BEGIN
158: DELETE FROM mtl_serial_numbers_temp
159: WHERE product_transaction_id = p_bkup_rti_id;
160:
161: IF (g_asn_debug = 'Y') THEN
162: asn_debug.put_line('DELETED MSNT');
1559: p_delivery_id IN NUMBER) IS
1560:
1561: CURSOR msnt_cursor IS
1562: SELECT *
1563: FROM mtl_serial_numbers_temp
1564: WHERE transaction_temp_id = p_wdd_rec.transaction_temp_id;
1565:
1566: l_temp_id NUMBER; -- Bug 11831232
1567: l_deliver_subinv rcv_transactions.subinventory%TYPE := NULL;