Code Listing 1: Defining the employee_level_qp specification

 1  CREATE OR REPLACE PACKAGE employee_level_qp
 2  IS
 3    TYPE employee_level_rc IS 
 4      REF CURSOR RETURN employee_level%ROWTYPE;
 5 
 6    FUNCTION allrows_CV RETURN employee_level_rc;
 7  END employee_level_qp;
 8  /