eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RCV_INTEGRATION_APIS dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 1073: * This procedure inserts a record into MTL_SERIAL_NUMBERS_INTERFACE

1069:
1070: /*----------------------------------------------------------------------------
1071: * PROCEDURE: insert_msni
1072: * Description:
1073: * This procedure inserts a record into MTL_SERIAL_NUMBERS_INTERFACE
1074: * Generate transaction_interface_id if the parameter is NULL
1075: * Generate product_transaction_id if the parameter is NULL
1076: * The insert logic is based on the parameter p_att_exist.
1077: * If p_att_exist is "N" Then (attributes are not available in table)

Line 1293: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE

1289:
1290: TYPE msni_rec_tp IS RECORD (
1291: fm_serial_number mtl_serial_numbers.serial_number%TYPE
1292: , to_serial_number mtl_serial_numbers.serial_number%TYPE
1293: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE
1294: , status_id mtl_serial_numbers.status_id%TYPE
1295: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE
1296: , product_code mtl_serial_numbers_interface.product_code%TYPE
1297: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE

Line 1295: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE

1291: fm_serial_number mtl_serial_numbers.serial_number%TYPE
1292: , to_serial_number mtl_serial_numbers.serial_number%TYPE
1293: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE
1294: , status_id mtl_serial_numbers.status_id%TYPE
1295: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE
1296: , product_code mtl_serial_numbers_interface.product_code%TYPE
1297: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
1298: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
1299: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE

Line 1296: , product_code mtl_serial_numbers_interface.product_code%TYPE

1292: , to_serial_number mtl_serial_numbers.serial_number%TYPE
1293: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE
1294: , status_id mtl_serial_numbers.status_id%TYPE
1295: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE
1296: , product_code mtl_serial_numbers_interface.product_code%TYPE
1297: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
1298: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
1299: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
1300: , origination_date mtl_serial_numbers.origination_date%TYPE

Line 1354: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE

1350: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
1351: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
1352: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
1353: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
1354: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE
1355: , attribute1 mtl_serial_numbers.attribute1%TYPE
1356: , attribute2 mtl_serial_numbers.attribute2%TYPE
1357: , attribute3 mtl_serial_numbers.attribute3%TYPE
1358: , attribute4 mtl_serial_numbers.attribute4%TYPE

Line 1392: l_source_code mtl_serial_numbers_interface.source_code%TYPE;

1388: l_range_numbers NUMBER; --no. of serial numbers in the range
1389: l_msni_tbl_count NUMBER; --Count of records to be inserted
1390: l_user_id NUMBER := fnd_global.user_id;
1391: l_login_id NUMBER := fnd_global.login_id;
1392: l_source_code mtl_serial_numbers_interface.source_code%TYPE;
1393: l_source_line_id mtl_serial_numbers_interface.source_line_id%TYPE;
1394: l_api_version CONSTANT NUMBER := 1.0;
1395: l_api_name CONSTANT VARCHAR2(30) := 'insert_mtli';
1396: l_success NUMBER;

Line 1393: l_source_line_id mtl_serial_numbers_interface.source_line_id%TYPE;

1389: l_msni_tbl_count NUMBER; --Count of records to be inserted
1390: l_user_id NUMBER := fnd_global.user_id;
1391: l_login_id NUMBER := fnd_global.login_id;
1392: l_source_code mtl_serial_numbers_interface.source_code%TYPE;
1393: l_source_line_id mtl_serial_numbers_interface.source_line_id%TYPE;
1394: l_api_version CONSTANT NUMBER := 1.0;
1395: l_api_name CONSTANT VARCHAR2(30) := 'insert_mtli';
1396: l_success NUMBER;
1397: l_progress NUMBER; --Progress Indicator

Line 1565: --inserted into MTL_SERIAL_NUMBERS_INTERFACE. Loop through the table and

1561: END LOOP; --END For each serial number in the range
1562: END IF; --END IF p_att_exist = 'N'
1563:
1564: --At this stage, we have a PL/SQL table containing one or more rows to be
1565: --inserted into MTL_SERIAL_NUMBERS_INTERFACE. Loop through the table and
1566: --insert each record
1567: l_msni_tbl_count := l_msni_rec_tbl.COUNT;
1568:
1569: IF (l_debug = 1) THEN

Line 1582: INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE (

1578: END IF;
1579:
1580: FOR i IN 1 .. l_msni_tbl_count LOOP
1581:
1582: INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE (
1583: transaction_interface_id
1584: , source_code
1585: , source_line_id
1586: , last_update_date