353:
354: --API start
355: if (p_new_transaction_temp_id is not null) then
356: --replace the transaction_temp_id for msnt row with this one.
357: UPDATE mtl_serial_numbers_temp
358: SET transaction_temp_id = p_new_transaction_temp_id
359: WHERE transaction_temp_id = p_transaction_temp_id
360: AND fm_serial_number = p_serial;
361: --restamp the group mark id in msn.
358: SET transaction_temp_id = p_new_transaction_temp_id
359: WHERE transaction_temp_id = p_transaction_temp_id
360: AND fm_serial_number = p_serial;
361: --restamp the group mark id in msn.
362: UPDATE mtl_serial_numbers
363: SET group_mark_id = p_new_transaction_temp_id
364: WHERE group_mark_id = p_transaction_temp_id
365: AND serial_number = p_serial;
366: else
364: WHERE group_mark_id = p_transaction_temp_id
365: AND serial_number = p_serial;
366: else
367: --delete current msnt row and then unmark serial
368: DELETE FROM mtl_serial_numbers_temp
369: WHERE transaction_temp_id = p_transaction_temp_id
370: and fm_serial_number = p_serial;
371: --Can also use serial_check.inv_unmark_serial
372: UPDATE mtl_serial_numbers
368: DELETE FROM mtl_serial_numbers_temp
369: WHERE transaction_temp_id = p_transaction_temp_id
370: and fm_serial_number = p_serial;
371: --Can also use serial_check.inv_unmark_serial
372: UPDATE mtl_serial_numbers
373: SET line_mark_id = -1
374: , group_mark_id = -1
375: , lot_line_mark_id = -1
376: WHERE group_mark_id = p_transaction_temp_id
432:
433: --API start
434: --Not using inv_trx_util_pub.insert_ser_trx and serial_check.inv_mark_serial
435: --because of bug 2798128
436: INSERT INTO mtl_serial_numbers_temp(transaction_temp_id
437: , fm_serial_number, to_serial_number, serial_prefix
438: , last_update_date, last_updated_by, creation_date, created_by
439: )
440: VALUES(p_transaction_temp_id,p_serial, p_serial, 1
440: VALUES(p_transaction_temp_id,p_serial, p_serial, 1
441: , SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id);
442: l_insert_count := SQL%ROWCOUNT;
443:
444: UPDATE mtl_serial_numbers
445: SET group_mark_id = p_transaction_temp_id
446: WHERE serial_number = p_serial
447: AND current_organization_id = p_organization_id
448: AND inventory_item_id = p_inventory_item_id;