In this assignment you are going to deliver Oracle PL/SQL package. This package helps HR department to managing employees.
You need to create Oracle PL/SQL Package name emp_mng_pkg with following functionality:
A)Onboarding Employee
B)Commission Raising
C)Leaving Employee
A) Your package should have package specification and body
B) Onboarding Employee: Create onboarding function which get all employees information from employees table in HR schema employee table and return new employee id.
C) Commission Raising: Creating Commission Raising procedure which get employee id and commission rate from employees table in HR schema and increase it by 2% for all not null commission rate employees and 1% if it's null commission rate. Raising Commission
D) Leaving Procedure: Leaving Procedure should get employee id, first name and last name and apply changes to employees' table.
Note 1: Your code should be able to manage errors (error handling) in all your procedures and function
Note 2: You should invoke function and procedures and submit your answers with output. Assignment without output receive 0 mark.