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 507: FROM mtl_transaction_lots_interface MTLI

503: SELECT 1
504: , serial_transaction_temp_id
505: INTO l_lot_count
506: , x_serial_transaction_temp_id
507: FROM mtl_transaction_lots_interface MTLI
508: WHERE transaction_interface_id = p_transaction_interface_id
509: AND product_transaction_id = p_product_transaction_id
510: AND Ltrim(Rtrim(lot_number)) = Ltrim(Rtrim(p_lot_number))
511: AND ROWNUM = 1

Line 534: UPDATE mtl_transaction_lots_interface

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

Line 696: INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE (

692: END IF;
693: END;
694: END IF; --END IF p_att_exist = 'Y'
695:
696: INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE (
697: transaction_interface_id
698: , source_code
699: , source_line_id
700: , last_update_date