How to update JSON value in Oracle by adding over there value from another column?

I would like to update values in JSON in my table in Oracle which look like (same values for about 80 rows):

{
    "common": [{
        "code": ["FIRST_CODE"]
    }]
}

and make it looks like this:

{
    "common": [{
        "code": ["FIRST_CODE"],
        "type": 1
    }]
}

I want to get type from column TYPE_ID from the same table (it contains only 1 and 2 values).
Can you help me please - how can I do it correctly? Because now I've written the following script and it works but it did not change my table:

DECLARE
  v_my_json VARCHAR2(4000);
  v_type NUMBER;
BEGIN
  FOR rec IN (
    SELECT *
    FROM database.table t
    WHERE MY_JSON LIKE '{
    "common": [{
        "code": ["FIRST_CODE"]
    }]
}'
  )
  LOOP

    SELECT TYPE_ID
    INTO v_type
    FROM database.table
    WHERE ID = rec.ID;

    v_my_json := REPLACE(rec.MY_JSON,
        '{
    "common": [{
        "code": ["FIRST_CODE"]
    }]
}',
        '{
    "common": [{
        "code": ["FIRST_CODE"], 
        "type": ' || v_type || '}]');

    UPDATE database.table
    SET MY_JSON = v_my_json
    WHERE ID = rec.ID;
  END LOOP;
END;
/

Don't use string functions to deal with JSON. Use JSON functions instead: JSON_TRANSFORM.

with sample(json_val, other_col) as (
  select '{
    "common": [{
        "code": ["FIRST_CODE"]
    }, {
    "code": ["ANOTHER_ARRAY_ITEM"]
  }]
}', 1
  from dual
)
select
  json_val,
  json_transform(
    json_val,
    insert '$.common[*].type' = other_col
  ) as new_val
from sample

fiddle