[Home] [Help]
1478: | |
1479: | Description : This API will be called by INV create_logical_transactions |
1480: | API to do a bulk insert into mtl_transaction_lot_numbers if|
1481: | the item is lot control and insert into |
1482: | mtl_unit_transactions if the item is serial control. |
1483: | |
1484: | Input Parameters : |
1485: | p_api_version_number - API version number |
1486: | p_init_msg_lst - Whether initialize the error message list or not|
1906: ,l_mtln.ATTRIBUTE15
1907: );
1908:
1909: -- If it's serial control and the serial_number_control_code is 2, 5
1910: -- then also insert into the mtl_unit_transactions
1911: -- serial_number_control_code = 2 -- Predefined serial numbers
1912: -- serial_number_control_code = 5 -- Dynamic entry at inventory receipt
1913: IF (p_serial_control_code in (2, 5)) THEN
1914: IF (l_debug = 1) THEN
2379: CYCLES_SINCE_MARK,
2380: NUMBER_OF_REPAIRS,
2381: PRODUCT_CODE,
2382: PRODUCT_TRANSACTION_ID
2383: FROM mtl_unit_transactions
2384: WHERE transaction_id = p_transaction_id;
2385: BEGIN
2386: IF (l_debug = 1) THEN
2387: debug_print('Enter inv_mut_insert', 9);
2394: END IF;
2395:
2396: IF (p_parent_serial_trx_id IS NOT NULL OR p_parent_serial_trx_id > 0) THEN
2397: FOR l_mut in mut_cur(p_parent_serial_trx_id) LOOP
2398: INSERT INTO mtl_unit_transactions
2399: (
2400: TRANSACTION_ID
2401: ,LAST_UPDATE_DATE
2402: ,LAST_UPDATED_BY
2556: x_serial_number_tbl(l_index) := l_mut.serial_number;
2557: END LOOP; -- end of loop l_mut
2558: ELSE
2559: forall i IN 1..x_serial_number_tbl.COUNT
2560: INSERT INTO mtl_unit_transactions
2561: (
2562: TRANSACTION_ID
2563: ,LAST_UPDATE_DATE
2564: ,LAST_UPDATED_BY