PL/SQL UPDATE DATA

DECLARE
  PROCEDURE p (
    sales  NUMBER,
    quota  NUMBER,
    emp_id NUMBER
  )
  IS
    bonus    NUMBER := 0;
    updated  VARCHAR2(3) := 'No';
  BEGIN
    IF sales > (quota + 200) THEN
      bonus := (sales - quota)/4;
 
      UPDATE employees
      SET salary = salary + bonus 
      WHERE employee_id = emp_id;
 
      updated := 'Yes';
    END IF;
 
    DBMS_OUTPUT.PUT_LINE (
      'Table updated?  ' || updated || ', ' || 
      'bonus = ' || bonus || '.'
    );
  END p;
  
  sales_val  NUMBER;
  quota_val  NUMBER;
  emp_id_val NUMBER;

BEGIN

  -- Retrieve values from the sales_data table
  SELECT sales, quota, emp_id INTO sales_val, quota_val, emp_id_val
  FROM sales_data
  WHERE some_condition; -- Adjust the condition based on your needs
  
  -- Call the procedure with the retrieved values
  p(sales_val, quota_val, emp_id_val);
END;