13: ----
14:
15: PROCEDURE status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
16: x_custom_sql OUT NOCOPY VARCHAR2,
17: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
18: IS
19: l_query varchar2(4000);
20: l_view_by varchar2(120);
21: l_view_by_col varchar2(120);
75:
76:
77: PROCEDURE trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
78: x_custom_sql OUT NOCOPY VARCHAR2,
79: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
80: IS
81: l_query varchar2(32767);
82: l_view_by varchar2(120);
83: l_view_by_col varchar2(120);
128:
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: l_query varchar2(4000);
135: l_view_by varchar2(120);
136: l_view_by_col varchar2(120);