Ref Cursor and Dynamic Query in Oracle Reports

hi,
We normally use ref cursors for our reporting - all stored in a package in the database.
This way all the work needed by the query is done by the database.
This works fine where the parametmers are known at run time.

But now I need to write a report where the parameters will only be determined at run time.

I've tried defining my type

TYPE RDMC_TEST_DATA is RECORD
    ( SCHEME_ID                         TS_SCHEMES.SCHEME_ID%TYPE,
      APPLICATION_ID                 TD_APPLICATIONS.APPLICATION_ID%TYPE,
      Customer_No                       TD_APPLICATIONS.CUSTOMER_ID%TYPE,
      DATE_OF_APPLICATION     TD_APPLICATIONS.DATE_OF_APPLICATION%TYPE);