13: FUNCTION get_kpi_filter_where return VARCHAR2;
14: ----
15: -- public methods
16:
17: PROCEDURE status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
18: x_custom_sql OUT NOCOPY VARCHAR2,
19: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
20: IS
21: l_query varchar2(4000);
74:
75: END;
76:
77:
78: PROCEDURE trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
79: x_custom_sql OUT NOCOPY VARCHAR2,
80: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
81: IS
82: l_query varchar2(32000);
126: x_custom_sql := l_query;
127:
128: END;
129:
130: PROCEDURE kpi_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
131: x_custom_sql OUT NOCOPY VARCHAR2,
132: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
133: IS
134: