APPS.RCV_WSH_INTERFACE_PKG dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 2299: INSERT INTO mtl_transaction_lots_interface

2295: ELSIF (p_source = 'RCV') THEN
2296: SELECT mtl_material_transactions_s.nextval INTO l_temp_id FROM DUAL; -- Bug 11831232
2297: END IF;
2298: --
2299: INSERT INTO mtl_transaction_lots_interface
2300: ( transaction_interface_id,
2301: last_update_date,
2302: last_updated_by,
2303: creation_date,

Line 2565: UPDATE mtl_transaction_lots_interface

2561: END LOOP;
2562: END IF;
2563: --
2564: IF (l_lot_inserted AND l_serial_inserted) THEN
2565: UPDATE mtl_transaction_lots_interface
2566: SET serial_transaction_temp_id = l_serial_temp_id
2567: WHERE transaction_interface_id = l_temp_id;
2568: END IF;
2569: --

Line 2924: DELETE FROM mtl_transaction_lots_interface

2920: END;
2921: asn_debug.put_line('After deleting MSNI : count = ' || sql%rowcount);
2922: --
2923: BEGIN
2924: DELETE FROM mtl_transaction_lots_interface
2925: WHERE product_transaction_id IN
2926: (SELECT interface_transaction_id
2927: FROM rcv_transactions_interface
2928: WHERE group_id = p_group_id