APPS.INV_RCV_INTEGRATION_APIS dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 461: l_source_code mtl_transaction_lots_interface.source_code%TYPE;

457: l_attribute12 mtl_lot_numbers.attribute12%type := p_attribute12;
458: l_attribute13 mtl_lot_numbers.attribute13%type := p_attribute13;
459: l_attribute14 mtl_lot_numbers.attribute14%type := p_attribute14;
460: l_attribute15 mtl_lot_numbers.attribute15%type := p_attribute15;
461: l_source_code mtl_transaction_lots_interface.source_code%TYPE;
462: l_source_line_id mtl_transaction_lots_interface.source_line_id%TYPE;
463: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE;
464: l_api_version CONSTANT NUMBER := 1.0;
465: l_api_name CONSTANT VARCHAR2(30) := 'insert_mtli';

Line 462: l_source_line_id mtl_transaction_lots_interface.source_line_id%TYPE;

458: l_attribute13 mtl_lot_numbers.attribute13%type := p_attribute13;
459: l_attribute14 mtl_lot_numbers.attribute14%type := p_attribute14;
460: l_attribute15 mtl_lot_numbers.attribute15%type := p_attribute15;
461: l_source_code mtl_transaction_lots_interface.source_code%TYPE;
462: l_source_line_id mtl_transaction_lots_interface.source_line_id%TYPE;
463: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE;
464: l_api_version CONSTANT NUMBER := 1.0;
465: l_api_name CONSTANT VARCHAR2(30) := 'insert_mtli';
466: l_progress NUMBER; --Progress Indicator

Line 511: FROM mtl_transaction_lots_interface MTLI

507: SELECT 1
508: , serial_transaction_temp_id
509: INTO l_lot_count
510: , x_serial_transaction_temp_id
511: FROM mtl_transaction_lots_interface MTLI
512: WHERE transaction_interface_id = p_transaction_interface_id
513: AND product_transaction_id = p_product_transaction_id
514: AND Ltrim(Rtrim(lot_number)) = Ltrim(Rtrim(p_lot_number))
515: AND ROWNUM = 1

Line 538: UPDATE mtl_transaction_lots_interface

534: print_debug('Count of lots records for the intf id: ' || l_lot_count, 4);
535: END IF;
536:
537: IF l_lot_count = 1 THEN
538: UPDATE mtl_transaction_lots_interface
539: SET transaction_quantity = transaction_quantity + p_transaction_quantity
540: , primary_quantity = primary_quantity + p_primary_quantity
541: , secondary_transaction_quantity = secondary_transaction_quantity + p_secondary_quantity
542: WHERE transaction_interface_id = p_transaction_interface_id

Line 712: INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE (

708: else
709: l_lot_status_id := l_status_id;
710: END IF;
711:
712: INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE (
713: transaction_interface_id
714: , source_code
715: , source_line_id
716: , last_update_date