100:
101: -----------------------------------------------------------------------------------------------------------
102: -- This procedure will provide sql statements to retrieve data for Collection Effectiveness Index Summary
103: PROCEDURE get_coll_eff_index(
104: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, coll_eff_sql out NOCOPY VARCHAR2,
105: coll_eff_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
106:
107: sqlstmt VARCHAR2(30000);
108:
411: END get_coll_eff_index;
412:
413: ----------------------------------------------------------------------------------------------
414: --Procedure for Collection Effectiveness Report
415: PROCEDURE get_coll_eff(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
416: coll_eff_sql out NOCOPY VARCHAR2, coll_eff_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
417:
418: sqlstmt VARCHAR2(15000);
419:
713:
714: END get_coll_eff;
715:
716: -- This procedure will provide sql statement to retrieve data for Collection Effectiveness Report
717: PROCEDURE get_coll_eff_trend(p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
718: coll_eff_trend_sql out NOCOPY VARCHAR2, coll_eff_trend_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
719:
720: sqlstmt VARCHAR2(32767); --Final sql statement
721: l_curr_sql_stmt VARCHAR2(10000); --Intermediate sql statement to hold the Current periods sql