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 1089: * This procedure inserts a record into MTL_SERIAL_NUMBERS_INTERFACE

1085:
1086: /*----------------------------------------------------------------------------
1087: * PROCEDURE: insert_msni
1088: * Description:
1089: * This procedure inserts a record into MTL_SERIAL_NUMBERS_INTERFACE
1090: * Generate transaction_interface_id if the parameter is NULL
1091: * Generate product_transaction_id if the parameter is NULL
1092: * The insert logic is based on the parameter p_att_exist.
1093: * If p_att_exist is "N" Then (attributes are not available in table)

Line 1309: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE

1305:
1306: TYPE msni_rec_tp IS RECORD (
1307: fm_serial_number mtl_serial_numbers.serial_number%TYPE
1308: , to_serial_number mtl_serial_numbers.serial_number%TYPE
1309: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE
1310: , status_id mtl_serial_numbers.status_id%TYPE
1311: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE
1312: , product_code mtl_serial_numbers_interface.product_code%TYPE
1313: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE

Line 1311: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE

1307: fm_serial_number mtl_serial_numbers.serial_number%TYPE
1308: , to_serial_number mtl_serial_numbers.serial_number%TYPE
1309: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE
1310: , status_id mtl_serial_numbers.status_id%TYPE
1311: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE
1312: , product_code mtl_serial_numbers_interface.product_code%TYPE
1313: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
1314: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
1315: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE

Line 1312: , product_code mtl_serial_numbers_interface.product_code%TYPE

1308: , to_serial_number mtl_serial_numbers.serial_number%TYPE
1309: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE
1310: , status_id mtl_serial_numbers.status_id%TYPE
1311: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE
1312: , product_code mtl_serial_numbers_interface.product_code%TYPE
1313: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
1314: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
1315: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
1316: , origination_date mtl_serial_numbers.origination_date%TYPE

Line 1370: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE

1366: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
1367: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
1368: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
1369: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
1370: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE
1371: , attribute1 mtl_serial_numbers.attribute1%TYPE
1372: , attribute2 mtl_serial_numbers.attribute2%TYPE
1373: , attribute3 mtl_serial_numbers.attribute3%TYPE
1374: , attribute4 mtl_serial_numbers.attribute4%TYPE

Line 1408: l_source_code mtl_serial_numbers_interface.source_code%TYPE;

1404: l_range_numbers NUMBER; --no. of serial numbers in the range
1405: l_msni_tbl_count NUMBER; --Count of records to be inserted
1406: l_user_id NUMBER := fnd_global.user_id;
1407: l_login_id NUMBER := fnd_global.login_id;
1408: l_source_code mtl_serial_numbers_interface.source_code%TYPE;
1409: l_source_line_id mtl_serial_numbers_interface.source_line_id%TYPE;
1410: l_api_version CONSTANT NUMBER := 1.0;
1411: l_api_name CONSTANT VARCHAR2(30) := 'insert_mtli';
1412: l_success NUMBER;

Line 1409: l_source_line_id mtl_serial_numbers_interface.source_line_id%TYPE;

1405: l_msni_tbl_count NUMBER; --Count of records to be inserted
1406: l_user_id NUMBER := fnd_global.user_id;
1407: l_login_id NUMBER := fnd_global.login_id;
1408: l_source_code mtl_serial_numbers_interface.source_code%TYPE;
1409: l_source_line_id mtl_serial_numbers_interface.source_line_id%TYPE;
1410: l_api_version CONSTANT NUMBER := 1.0;
1411: l_api_name CONSTANT VARCHAR2(30) := 'insert_mtli';
1412: l_success NUMBER;
1413: l_progress NUMBER; --Progress Indicator

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

1577: END LOOP; --END For each serial number in the range
1578: END IF; --END IF p_att_exist = 'N'
1579:
1580: --At this stage, we have a PL/SQL table containing one or more rows to be
1581: --inserted into MTL_SERIAL_NUMBERS_INTERFACE. Loop through the table and
1582: --insert each record
1583: l_msni_tbl_count := l_msni_rec_tbl.COUNT;
1584:
1585: IF (l_debug = 1) THEN

Line 1598: INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE (

1594: END IF;
1595:
1596: FOR i IN 1 .. l_msni_tbl_count LOOP
1597:
1598: INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE (
1599: transaction_interface_id
1600: , source_code
1601: , source_line_id
1602: , last_update_date