html

DECLARE
    l_empno     emp.empno%type;
    l_values    apex_json.t_values;
    l_row_count PLS_INTEGER;
BEGIN
    apex_debug.message('inside process Bulk Update Commission');
    -- parse text to JSON
    apex_json.parse(p_values => l_values, p_source => :P5_SELECTED_ROWS);
    -- get number of rows selected
    l_row_count := apex_json.get_count(p_path => 'rows', p_values => l_values);
    -- loop through the selected rows
    FOR i IN 1..l_row_count LOOP
        -- get Primary Key value from JSON data
        l_empno := null;
        -- if primary key column type is not a number type, then remove TO_NUMBER part
        l_empno := TO_NUMBER(apex_json.get_varchar2(p_path => 'rows[%d].empNo', p0 => i, p_values => l_values));
        apex_debug.message('l_empno' || l_empno);
        -- update employee commission
        -- remove TO_NUMBER if your input item type is not a NUMBER
        UPDATE emp
        SET comm = sal*TO_NUMBER(:P5_COMMISSION)/100
        WHERE empno = l_empno;
    END LOOP;
END;