SQL> CREATE OR REPLACE PACKAGE TYPE_DEF_PKG
  2  AS
  3    CURSOR EMP_CUR IS SELECT EMPNO, ENAME FROM EMP;
  4    TYPE EMP_RCT IS REF CURSOR RETURN EMP_CUR%ROWTYPE;
  5    TYPE EMP_AAT IS TABLE OF EMP_CUR%ROWTYPE;
  6    FUNCTION TBL_FUNC_AA (CV_IN IN EMP_RCT) RETURN EMP_AAT;
  7  END;
  8  /

Package created.

SQL> CREATE OR REPLACE PACKAGE BODY TYPE_DEF_PKG AS
  2    FUNCTION TBL_FUNC_AA (CV_IN IN EMP_RCT) RETURN EMP_AAT
  3     IS
  4       RETVAL EMP_AAT := EMP_AAT();
  5       REC CV_IN%ROWTYPE;
  6    BEGIN
  7       FETCH CV_IN BULK COLLECT INTO RETVAL;
  8       CLOSE CV_IN;
  9       RETURN RETVAL;
 10    END;
 11  END;
 12  /

Package body created.

SQL> DECLARE
  2    L_AA_VAR TYPE_DEF_PKG.EMP_AAT := TYPE_DEF_PKG.EMP_AAT();
  3    CUR_VAR_AA TYPE_DEF_PKG.EMP_RCT;
  4  BEGIN
  5    OPEN CUR_VAR_AA FOR SELECT EMPNO, ENAME FROM EMP;
  6    L_AA_VAR.EXTEND(14);
  7    L_AA_VAR := TYPE_DEF_PKG.TBL_FUNC_AA(CUR_VAR_AA);
  8
  9    FOR REC IN (SELECT * FROM TABLE(L_AA_VAR))
 10      LOOP
 11        NULL;
 12        DBMS_OUTPUT.PUT_LINE(REC.ATTR_1 || ' - ' || REC.ATTR_2);
 13      END LOOP;
 14  END;
 15  /
7839 - KING
7698 - BLAKE
7782 - CLARK
7566 - JONES
7788 - SCOTT
7902 - FORD
7369 - SMITH
7499 - ALLEN
7521 - WARD
7654 - MARTIN
7844 - TURNER
7876 - ADAMS
7900 - JAMES
7934 - MILLER

PL/SQL procedure successfully completed.