20: FUNCTION get_trend_sel_clause(p_view_by_dim IN VARCHAR2, p_url IN VARCHAR2)
21: return VARCHAR2;
22:
23:
24: PROCEDURE get_rpt_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
25: x_custom_sql OUT NOCOPY VARCHAR2,
26: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
27: IS
28: l_query VARCHAR2(15000);
248: /*
249: Report query for viewby = time
250: */
251:
252: PROCEDURE get_trd_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
253: x_custom_sql OUT NOCOPY VARCHAR2,
254: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
255: IS
256: l_query VARCHAR2(15000);