SET SERVEROUTPUT ON
DECLARE 
  P_CUST_ID VARCHAR2(32);
  P_INPT_CD VARCHAR2(2);
  P_PROD_CD VARCHAR2(20);
  P_RLSED_DT DATE;
  P_FIRST_IN VARCHAR2(32767);
  P_EXCL_TBL_IN VARCHAR2(32767);
  P_HIST_DATE DATE;
  P_CURSOR SYS_REFCURSOR;

BEGIN 
  P_CUST_ID := NULL;
  P_INPT_CD := NULL;
  P_PROD_CD := NULL;
  P_RLSED_DT := NULL;
  P_FIRST_IN := NULL;
  P_EXCL_TBL_IN := NULL;
  P_HIST_DATE := NULL;
  -- P_CURSOR := NULL;  Modify the code to initialize this parameter

  PKG_SEARCH.SEARCH_TXNS('', 'A', 'RETURNS', '10-NOV-2014','R', 'F', '09-NOV-2014', P_CURSOR );
  --DBMS_OUTPUT.PUT_LINE(' V_RETURN = '  || '  ' ||  P_CURSOR);
  COMMIT; 
END; 
/

VARIABLE CUR REFCURSOR
BEGIN 
    PKG_SEARCH.SEARCH_TXNS('','A','RETURNS',DATE '2014-11-10','R','F',DATE '2014-11-09',:CUR);
END; 
/
PRINT CUR