I would like to create a package that contains to PL/SQL blocks:

department
dept_id location
1 London
2 New York
3 Singapore
4 Tokyo


employee
emp_id dept_id salary tier_id
1 2 20000 4
2 4 200000 1
3 3 25000 4
4 1 60000 2
5 1 30000 3


tier
tier_id tier_name
1 Director
2 Manager
3 Analyst
4 Intern


The first procedure will take in an department ID and will return both the current timestamp and a list of the different distinct tiers belonging to that department ID. These will be returned as two separate parameters.

The second stored procedure will take in a tier ID and provide back the second highest salary for that tier.

Any help would be appreciated