| procedure | type | parameter | datatype | in/out |
|---|---|---|---|---|
| CREATE_DEPT | PACKAGE | return value | NUMBER | OUT |
| CREATE_DEPT | PACKAGE | DEPARTMENT_ID | NUMBER | IN |
| CREATE_DEPT | PACKAGE | LOCATION_ID | NUMBER | IN |
| HIRE | PACKAGE | return value | NUMBER | OUT |
| HIRE | PACKAGE | LAST_NAME | VARCHAR2 | IN |
| HIRE | PACKAGE | JOB_ID | VARCHAR2 | IN |
| HIRE | PACKAGE | MANAGER_ID | NUMBER | IN |
| HIRE | PACKAGE | SALARY | NUMBER | IN |
| HIRE | PACKAGE | COMMISSION_PCT | NUMBER | IN |
| HIRE | PACKAGE | DEPARTMENT_ID | NUMBER | IN |
| INCREASE_COMM | PACKAGE | EMPLOYEE_ID | NUMBER | IN |
| INCREASE_COMM | PACKAGE | COMM_INCR | NUMBER | IN |
| INCREASE_SAL | PACKAGE | EMPLOYEE_ID | NUMBER | IN |
| INCREASE_SAL | PACKAGE | SALARY_INCR | NUMBER | IN |
| REMOVE_DEPT | PACKAGE | DEPARTMENT_ID | NUMBER | IN |
| REMOVE_EMP | PACKAGE | EMPLOYEE_ID | NUMBER | IN |
| CREATE_DEPT | PACKAGE | return value | NUMBER | OUT |
| CREATE_DEPT | PACKAGE | DEPARTMENT_ID | NUMBER | IN |
| CREATE_DEPT | PACKAGE | LOCATION_ID | NUMBER | IN |
| HIRE | PACKAGE | return value | NUMBER | OUT |
| HIRE | PACKAGE | LAST_NAME | VARCHAR2 | IN |
| HIRE | PACKAGE | JOB_ID | VARCHAR2 | IN |
| HIRE | PACKAGE | MANAGER_ID | NUMBER | IN |
| HIRE | PACKAGE | SALARY | NUMBER | IN |
| HIRE | PACKAGE | COMMISSION_PCT | NUMBER | IN |
| HIRE | PACKAGE | DEPARTMENT_ID | NUMBER | IN |
| INCREASE_COMM | PACKAGE | EMPLOYEE_ID | NUMBER | IN |
| INCREASE_COMM | PACKAGE | COMM_INCR | NUMBER | IN |
| INCREASE_SAL | PACKAGE | EMPLOYEE_ID | NUMBER | IN |
| INCREASE_SAL | PACKAGE | SALARY_INCR | NUMBER | IN |
| REMOVE_DEPT | PACKAGE | DEPARTMENT_ID | NUMBER | IN |
| REMOVE_EMP | PACKAGE | EMPLOYEE_ID | NUMBER | IN |
| ADD_JOB_HISTORY | PROCEDURE | P_EMP_ID | NUMBER | IN |
| ADD_JOB_HISTORY | PROCEDURE | P_START_DATE | DATE | IN |
| ADD_JOB_HISTORY | PROCEDURE | P_END_DATE | DATE | IN |
| ADD_JOB_HISTORY | PROCEDURE | P_JOB_ID | VARCHAR2 (10) | IN |
| ADD_JOB_HISTORY | PROCEDURE | P_DEPARTMENT_ID | NUMBER | IN |
| USELESS | FUNCTION | return value | NUMBER | OUT |