APPS.RCV_WSH_INTERFACE_PKG dependencies on MTL_SERIAL_NUMBERS

Line 158: DELETE FROM mtl_serial_numbers_temp

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');

Line 1563: FROM mtl_serial_numbers_temp

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;

Line 2384: UPDATE mtl_serial_numbers

2380: END IF;
2381: --
2382: -- Transfer tagged serial to receipt org if return is done from another org ie, direct txr is completed at this point.
2383: IF (l_serial_tagged = 2 AND l_rti_org_id <> p_wdd_rec.organization_id) THEN
2384: UPDATE mtl_serial_numbers
2385: SET current_organization_id = l_rti_org_id
2386: WHERE inventory_item_id = l_rti_item_id
2387: AND current_organization_id = p_wdd_rec.organization_id
2388: AND serial_number between wsn_rec.fm_serial_number and nvl(wsn_rec.to_serial_number,wsn_rec.fm_serial_number) -- Bug 10120533

Line 2393: INSERT INTO mtl_serial_numbers_interface

2389: AND length(serial_number) = length(wsn_rec.fm_serial_number); -- Bug 10120533
2390: END IF;
2391:
2392: -- This will be changed to pick from WSN once shipping patch is ready.
2393: INSERT INTO mtl_serial_numbers_interface
2394: ( transaction_interface_id,
2395: product_code,
2396: product_transaction_id,
2397: last_update_date,

Line 2911: DELETE FROM mtl_serial_numbers_interface

2907: BEGIN
2908:
2909: -- Deleting errored RTI/MSNI/MTLI
2910: BEGIN
2911: DELETE FROM mtl_serial_numbers_interface
2912: WHERE product_transaction_id IN
2913: (SELECT interface_transaction_id
2914: FROM rcv_transactions_interface
2915: WHERE group_id = p_group_id