508: print_debug('Lot Secondary Qty = ' || l_lot_sec_qty, l_api_name, g_info);
509: END IF;
510:
511: IF p_serial_control_code NOT IN (1,6) THEN
512: INSERT INTO mtl_serial_numbers_temp(
513: transaction_temp_id
514: , fm_serial_number, to_serial_number, serial_prefix
515: , last_update_date, last_updated_by, creation_date, created_by
516: )
528: --after splitting the allocation
529: UPDATE mtl_serial_numbers
530: SET group_mark_id = l_serial_txn_temp_id
531: , line_mark_id = l_serial_txn_temp_id
532: WHERE serial_number IN (SELECT fm_serial_number FROM mtl_serial_numbers_temp
533: WHERE transaction_temp_id = l_serial_txn_temp_id)
534: AND inventory_item_id = l_item_id;
535: l_update_count := SQL%ROWCOUNT;
536:
547: EXIT WHEN l_rem_txn_qty <= 0;
548: END LOOP;
549: ELSIF p_serial_control_code NOT IN (1,6) THEN
550: -- If Serial Controlled, create Serial Records
551: INSERT INTO mtl_serial_numbers_temp(
552: transaction_temp_id
553: , fm_serial_number, to_serial_number, serial_prefix
554: , last_update_date, last_updated_by, creation_date, created_by
555: )
566: --after splitting the allocation
567: UPDATE mtl_serial_numbers
568: SET group_mark_id = x_new_txn_temp_id
569: , line_mark_id= x_new_txn_temp_id
570: WHERE serial_number IN (SELECT fm_serial_number FROM mtl_serial_numbers_temp
571: WHERE transaction_temp_id = x_new_txn_temp_id)
572: AND inventory_item_id = l_item_id;
573: l_update_count := SQL%ROWCOUNT;
574: