You did not follow the example to which you are referring.
The refcursor type cust_cursor is declared in the package speck.
Two procedures get_records and get_it are in the package body.
get_records opens the refcursor for a select statement and returns it as an out argument. get_it fetches rows and puts it to dbms_output buffer.

You need to use refcursor type that is declared in package reporting.
create a function in the package that you are creating that accepts an in argument of reporting.refcursor type. Got it?
d