85:
86: PROCEDURE get_dso(
87: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
88: p_dso_sql OUT NOCOPY VARCHAR2,
89: p_dso_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
90: ) IS
91:
92: sqlstmt VARCHAR2(20000); -- Variable that stores the final SQL query
93: l_view_by VARCHAR2(240); -- Variable to store the viewby based on viewby selected in the report
272:
273: PROCEDURE get_dso_trend(
274: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
275: p_dso_sql OUT NOCOPY VARCHAR2,
276: p_dso_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
277: ) IS
278:
279: sqlstmt VARCHAR2(20000); -- Variable that stores the final SQL query
280: l_customer_where VARCHAR2(240); -- Variable to store the dynamic customer filter