aaze

CREATE OR REPLACE PROCEDURE P1_6_SALARISVERHOGING 
(
  P_PERSNR IN S_EMP.ID%TYPE
) AS 
  V_TITLE     S_EMP.TITLE%TYPE;
BEGIN
  SELECT UPPER(TITLE)
  INTO V_TITLE
  FROM S_EMP
  WHERE ID = P_PERSNR;
 
  CASE
    WHEN V_TITLE = 'STOCK CLERK' THEN
      UPDATE S_EMP
      SET SALARY = SALARY * 1.025
      WHERE ID = P_PERSNR;
      DBMS_OUTPUT.PUT_LINE('Clerck Updated');
    WHEN V_TITLE = 'SALES REPRESENTATIVE' THEN
      IF P1_5_TOTAALBEDRAG_ORDERS(P_PERSNR) > 100000 THEN
        UPDATE S_EMP
        SET SALARY = SALARY * 1.03
        WHERE ID = P_PERSNR;
        DBMS_OUTPUT.PUT_LINE('Sales representative Updated');
      ELSE
        DBMS_OUTPUT.PUT_LINE('Sales representative NOT Updated');
      END IF;
    WHEN V_TITLE = 'WAREHOUSE MANAGER' THEN
      UPDATE S_EMP
      SET SALARY = SALARY * 1.05
      WHERE ID = P_PERSNR;
      DBMS_OUTPUT.PUT_LINE('Warehousemanager updated');
  END CASE;
  COMMIT;
END P1_6_SALARISVERHOGING;