APPS.INV_MATERIAL_ALLOCATIONS_GRP dependencies on MTL_SERIAL_NUMBERS

Line 402: UPDATE mtl_serial_numbers_temp

398:
399: --API start
400: if (p_new_transaction_temp_id is not null) then
401: --replace the transaction_temp_id for msnt row with this one.
402: UPDATE mtl_serial_numbers_temp
403: SET transaction_temp_id = p_new_transaction_temp_id
404: WHERE transaction_temp_id = p_transaction_temp_id
405: AND fm_serial_number = p_serial;
406: --restamp the group mark id in msn. needed for bug 2798128 (expects temp id)

Line 407: UPDATE mtl_serial_numbers

403: SET transaction_temp_id = p_new_transaction_temp_id
404: WHERE transaction_temp_id = p_transaction_temp_id
405: AND fm_serial_number = p_serial;
406: --restamp the group mark id in msn. needed for bug 2798128 (expects temp id)
407: UPDATE mtl_serial_numbers
408: SET group_mark_id = p_new_transaction_temp_id
409: WHERE group_mark_id = p_transaction_temp_id
410: AND serial_number = p_serial;
411: else

Line 413: DELETE FROM mtl_serial_numbers_temp

409: WHERE group_mark_id = p_transaction_temp_id
410: AND serial_number = p_serial;
411: else
412: --delete current msnt row and then unmark serial
413: DELETE FROM mtl_serial_numbers_temp
414: WHERE transaction_temp_id = p_transaction_temp_id
415: and fm_serial_number = p_serial;
416: --Can also use serial_check.inv_unmark_serial
417: UPDATE mtl_serial_numbers

Line 417: UPDATE mtl_serial_numbers

413: DELETE FROM mtl_serial_numbers_temp
414: WHERE transaction_temp_id = p_transaction_temp_id
415: and fm_serial_number = p_serial;
416: --Can also use serial_check.inv_unmark_serial
417: UPDATE mtl_serial_numbers
418: SET line_mark_id = -1
419: , group_mark_id = -1
420: , lot_line_mark_id = -1
421: WHERE inventory_item_id = p_inventory_item_id --no need of org id, item and serial are unique

Line 491: UPDATE mtl_serial_numbers

487: --Restamping group_mark_id in MSN as transaction temp id. The default from
488: --insert_ser_trx or from inv_mark_serial is transaction header id which is
489: --not acceptable because of bug 2798128 (expects temp id, not hdr id)
490: if (l_insert_err_code = 0) then -- 0 = success
491: UPDATE mtl_serial_numbers
492: SET group_mark_id = p_transaction_temp_id
493: WHERE serial_number = p_serial
494: AND current_organization_id = p_organization_id
495: AND inventory_item_id = p_inventory_item_id;