create table emp_test(id number,name varchar2(20),deptno number, sal number); 
 
insert into emp_test values(751,'Ward',30,1000);
insert into emp_test values(752,'Allen',30,1000);
insert into emp_test values(753,'turner',30,1000);

create or replace 
PACKAGE employee_details
    AS
    
    TYPE typ_tab_dept_no IS TABLE OF emp_test.deptno%type;
    
    v_typ_tab_dept_no typ_tab_dept_no:= typ_tab_dept_no();
    
    
    TYPE details
    IS
      RECORD
      (
        p_name   VARCHAR2(40),
        p_emp_id NUMBER );
        
   TYPE table_employees
   IS
     TABLE OF details;
     
     procedure get_employees(
         p_deptno in v_typ_tab_dept_no,
         p_sal IN emp_test.sal%TYPE,
         emp_rec OUT table_employees );
         
   END employee_details;

create or replace 
PACKAGE BODY employee_details
    AS
    PROCEDURE get_employees(
          p_deptno IN v_typ_tab_dept_no,
          p_sal IN emp_test.sal%TYPE,
          emp_rec OUT table_employees )
    IS
    begin
     select name, id bulk collect into emp_rec from emp_test et
     inner join table(p_deptno) t1
      ON et.deptno = t1.column_value
     where  sal > p_sal;
   END get_employees;
   END employee_details ;
   

SQL> create table EMP_TEST as select * from emp;

Table created.

SQL> create or replace
  2  PACKAGE employee_details
  3      AS
  4
  5      TYPE typ_tab_dept_no IS TABLE OF emp_test.deptno%type;
  6
  7      v_typ_tab_dept_no typ_tab_dept_no:= typ_tab_dept_no();
  8
  9
 10      TYPE details
 11      IS
 12        RECORD
 13        (
 14          p_name   VARCHAR2(40),
 15          p_emp_id NUMBER );
 16
 17     TYPE table_employees
 18     IS
 19       TABLE OF details;
 20
 21       procedure get_employees(
 22           p_deptno in v_typ_tab_dept_no,
 23           p_sal IN emp_test.sal%TYPE,
 24           emp_rec OUT table_employees );
 25
 26     END employee_details;
 27  /

Warning: Package created with compilation errors.

SQL> sho err
Errors for PACKAGE EMPLOYEE_DETAILS:
LINE/COL ERROR
-------- -------------------------------------------------------------------------------------
20/6     PL/SQL: Declaration ignored
21/22    PLS-00488: 'V_TYP_TAB_DEPT_NO' must be a type

SQL> create or replace
  2  PACKAGE employee_details
  3      AS
  4
  5      TYPE typ_tab_dept_no IS TABLE OF emp_test.deptno%type;
  6
  7      v_typ_tab_dept_no typ_tab_dept_no:= typ_tab_dept_no();
  8
  9
 10      TYPE details
 11      IS
 12        RECORD
 13        (
 14          p_name   VARCHAR2(40),
 15          p_emp_id NUMBER );
 16
 17     TYPE table_employees
 18     IS
 19       TABLE OF details;
 20
 21       procedure get_employees(
 22           p_deptno in typ_tab_dept_no,
 23           p_sal IN emp_test.sal%TYPE,
 24           emp_rec OUT table_employees );
 25
 26     END employee_details;
 27  /

Package created.