The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_ser_trx(p_trx_tmp_id IN VARCHAR2,
p_serial_trx_tmp_id IN NUMBER,
p_trx_header_id IN NUMBER,
p_user_id IN NUMBER,
p_fm_ser_num IN VARCHAR2,
p_to_ser_num IN VARCHAR2,
p_item_id IN NUMBER,
p_org_id IN NUMBER,
x_err_code OUT NOCOPY NUMBER,
x_err_message OUT NOCOPY VARCHAR2) IS
BEGIN
x_err_code := inv_trx_util_pub.insert_ser_trx(
p_trx_tmp_id => p_serial_trx_tmp_id,
p_user_id => p_user_id,
p_fm_ser_num => p_fm_ser_num,
p_to_ser_num => p_to_ser_num,
x_proc_msg => x_err_message);
END insert_ser_trx;
update mtl_transaction_lots_temp
set serial_transaction_temp_id = mtl_material_transactions_s.nextval
where transaction_temp_id = p_trx_tmp_id and lot_number = p_lot_number;