CREATE OR REPLACE PACKAGE TEST_VIEW AS
  FUNCTION get_date RETURN DATE;  
  
  FUNCTION set_date(i_mode NUMBER) RETURN NUMBER;
  
  FUNCTION several_select_from_same_view (
      i_date1 IN DATE
    , i_date2 IN DATE
  ) RETURN SYS_REFCURSOR;
END TEST_VIEW;
/

CREATE OR REPLACE VIEW V_TEST AS
  WITH params AS
         (SELECT TEST_VIEW.get_date one_day
            FROM DUAL
          )
     , cursor_emulation AS
         (
           SELECT TO_DATE('01-july-2016') one_day FROM DUAL
           UNION ALL
           SELECT TO_DATE('02-july-2016') one_day FROM DUAL
           UNION ALL
           SELECT TO_DATE('03-july-2016') one_day FROM DUAL
         )
      SELECT ce.*
        FROM cursor_emulation ce
           , params p
       WHERE ce.one_day = p.one_day;
       
CREATE OR REPLACE PACKAGE BODY TEST_VIEW AS
  g_date DATE;
  g_date1 DATE;
  g_date2 DATE;  

  FUNCTION get_date RETURN DATE IS
  BEGIN    
    RETURN g_date;
  END get_date;
  
  FUNCTION set_date(i_mode NUMBER) RETURN NUMBER IS
  BEGIN            
    IF i_mode = 1 THEN
      g_date := g_date1;
    ELSE
      g_date := g_date2;
    END IF;
    RETURN 1;
  END set_date;
  
  FUNCTION several_select_from_same_view (
      i_date1 IN DATE
    , i_date2 IN DATE
  ) RETURN SYS_REFCURSOR IS l_result SYS_REFCURSOR;
  BEGIN 
    g_date := NULL;
    g_date1 := i_date1;
    g_date2 := i_date2;
                    
    OPEN l_result FOR
      SELECT * FROM V_TEST WHERE SET_DATE(1) = 1
      UNION ALL                                  
      SELECT * FROM V_TEST WHERE SET_DATE(2) = 1;
      
    RETURN l_result;
  END several_select_from_same_view;
END TEST_VIEW;
/ 

SELECT TEST_VIEW.several_select_from_same_view(TO_DATE('01-july-2016'), TO_DATE('03-july-2016')) FROM DUAL