--PAKIET
CREATE OR REPLACE PACKAGE pracownicy AS
    PROCEDURE add_emp(inout_emp IN OUT EMP%ROWTYPE);
    PROCEDURE change_emp(in_emp EMP%ROWTYPE);
    PROCEDURE delete_emp(in_id NUMBER);
    PROCEDURE change_salary(in_id NUMBER, in_percent NUMBER);
    PROCEDURE top_n_emp(in_n NUMBER);
    PROCEDURE change_dept(in_emp_id NUMBER, in_dept_id NUMBER);
    PROCEDURE stat_emp(in_command VARCHAR2);
END pracownicy;

CREATE OR REPLACE PACKAGE BODY pracownicy AS
    --1
    PROCEDURE add_emp(inout_emp IN OUT EMP%ROWTYPE) IS
    BEGIN
        inout_emp.id := emp_id.NEXTVAL;
        INSERT INTO emp VALUES (inout_emp.id, inout_emp.last_name, inout_emp.first_name, inout_emp.userid, inout_emp.start_date,
            inout_emp.comments, inout_emp.manager_id, inout_emp.title, inout_emp.dept_id, inout_emp.salary, inout_emp.commission_pct);
        COMMIT;
    END add_emp;
    --2
    PROCEDURE change_emp(in_emp EMP%ROWTYPE) IS
    BEGIN
        DBMS_OUTPUT.put_line('not implemented');
    END change_emp;
    --3
    PROCEDURE delete_emp(in_id NUMBER) IS
    BEGIN
        DBMS_OUTPUT.put_line('not implemented');
    END delete_emp;
    --4
    PROCEDURE change_salary(in_id NUMBER, in_percent NUMBER) IS
    BEGIN
        DBMS_OUTPUT.put_line('not implemented');
    END change_salary;
    --5
    PROCEDURE top_n_emp(in_n NUMBER) IS
    BEGIN
        DBMS_OUTPUT.put_line('not implemented');
    END top_n_emp;
    --6
    PROCEDURE change_dept(in_emp_id NUMBER, in_dept_id NUMBER) IS
    BEGIN
        DBMS_OUTPUT.put_line('not implemented');
    END change_dept;
    --7
    PROCEDURE stat_emp(in_command VARCHAR2) IS
    BEGIN
        DBMS_OUTPUT.put_line('not implemented');
    END stat_emp;

END pracownicy;

SET SERVEROUTPUT ON;

DECLARE
    pracownik EMP%ROWTYPE;
BEGIN
    SELECT 0, 'nazwisko', 'imie', 'login11', SYSDATE, NULL, NULL, 'VP, Operations', 10, 1300, NULL
    INTO pracownik
    FROM dual;
    DBMS_OUTPUT.put_line('ID: ' || pracownik.id);
    pracownicy.add_emp(pracownik);
    DBMS_OUTPUT.put_line('ID: ' || pracownik.id);
END;