[Home] [Help]
318: Optionally if a new allocation temp id is provided, it can split this serial to
319: the new allocation temp id. This API does not adjust the quantities at the MMTT
320: or MTLT level and assumes that they have been adjusted by another API call.
321: Currently this API assumes that the serial numbers have a range of 1 (the
322: pick release process allocates serial numbers individually, not in ranges), this
323: assumption can be relaxed in the future by first splitting the range into
324: individual rows, then deleting just the row for this serial number.
325: */
326: PROCEDURE remove_serial(
320: or MTLT level and assumes that they have been adjusted by another API call.
321: Currently this API assumes that the serial numbers have a range of 1 (the
322: pick release process allocates serial numbers individually, not in ranges), this
323: assumption can be relaxed in the future by first splitting the range into
324: individual rows, then deleting just the row for this serial number.
325: */
326: PROCEDURE remove_serial(
327: p_init_msg_list IN VARCHAR2,
328: p_commit IN VARCHAR2,
630: || ',p_lot='|| p_lot || ',p_primary_quantity='|| p_primary_quantity|| ')');
631: end if;
632:
633: --API start
634: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL into l_ser_trx_id from dual;
635: update mtl_transaction_lots_temp
636: set serial_transaction_temp_id = l_ser_trx_id
637: where transaction_temp_id = p_transaction_temp_id
638: and lot_number = p_lot