[Home] [Help]
1460: | |
1461: | Description : This API will be called by INV create_logical_transactions |
1462: | API to do a bulk insert into mtl_transaction_lot_numbers if|
1463: | the item is lot control and insert into |
1464: | mtl_unit_transactions if the item is serial control. |
1465: | |
1466: | Input Parameters : |
1467: | p_api_version_number - API version number |
1468: | p_init_msg_lst - Whether initialize the error message list or not|
1854: ,l_mtln.ATTRIBUTE15
1855: );
1856:
1857: -- If it's serial control and the serial_number_control_code is 2, 5
1858: -- then also insert into the mtl_unit_transactions
1859: -- serial_number_control_code = 2 -- Predefined serial numbers
1860: -- serial_number_control_code = 5 -- Dynamic entry at inventory receipt
1861: IF (p_serial_control_code in (2, 5)) THEN
1862: IF (l_debug = 1) THEN
2327: CYCLES_SINCE_MARK,
2328: NUMBER_OF_REPAIRS,
2329: PRODUCT_CODE,
2330: PRODUCT_TRANSACTION_ID
2331: FROM mtl_unit_transactions
2332: WHERE transaction_id = p_transaction_id;
2333: BEGIN
2334: IF (l_debug = 1) THEN
2335: debug_print('Enter inv_mut_insert', 9);
2342: END IF;
2343:
2344: IF (p_parent_serial_trx_id IS NOT NULL OR p_parent_serial_trx_id > 0) THEN
2345: FOR l_mut in mut_cur(p_parent_serial_trx_id) LOOP
2346: INSERT INTO mtl_unit_transactions
2347: (
2348: TRANSACTION_ID
2349: ,LAST_UPDATE_DATE
2350: ,LAST_UPDATED_BY
2504: x_serial_number_tbl(l_index) := l_mut.serial_number;
2505: END LOOP; -- end of loop l_mut
2506: ELSE
2507: forall i IN 1..x_serial_number_tbl.COUNT
2508: INSERT INTO mtl_unit_transactions
2509: (
2510: TRANSACTION_ID
2511: ,LAST_UPDATE_DATE
2512: ,LAST_UPDATED_BY