[Home] [Help]
360: Optionally if a new allocation temp id is provided, it can split this serial to
361: the new allocation temp id. This API does not adjust the quantities at the MMTT
362: or MTLT level and assumes that they have been adjusted by another API call.
363: Currently this API assumes that the serial numbers have a range of 1 (the
364: pick release process allocates serial numbers individually, not in ranges), this
365: assumption can be relaxed in the future by first splitting the range into
366: individual rows, then deleting just the row for this serial number.
367: */
368: PROCEDURE remove_serial(
362: or MTLT level and assumes that they have been adjusted by another API call.
363: Currently this API assumes that the serial numbers have a range of 1 (the
364: pick release process allocates serial numbers individually, not in ranges), this
365: assumption can be relaxed in the future by first splitting the range into
366: individual rows, then deleting just the row for this serial number.
367: */
368: PROCEDURE remove_serial(
369: p_init_msg_list IN VARCHAR2,
370: p_commit IN VARCHAR2,
685: || ',p_lot='|| p_lot || ',p_primary_quantity='|| p_primary_quantity|| ')');
686: end if;
687:
688: --API start
689: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL into l_ser_trx_id from dual;
690: update mtl_transaction_lots_temp
691: set serial_transaction_temp_id = l_ser_trx_id
692: where transaction_temp_id = p_transaction_temp_id
693: and lot_number = p_lot