7:
8: PROCEDURE Get_Terminations_Sql(
9: p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
10: x_custom_sql OUT NOCOPY VARCHAR2,
11: x_custom_output OUT NOCOPY bis_query_attributes_tbl) IS
12:
13: l_query VARCHAR2(32767);
14: l_view_by VARCHAR2(120);
15: l_view_by_col VARCHAR2(120);
281:
282: PROCEDURE Get_Terminations_Detail_Sql(
283: p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
284: x_custom_sql OUT NOCOPY VARCHAR2,
285: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
286:
287: l_query VARCHAR2(32767);
288: l_where_clause VARCHAR2(2000);
289: l_rpt_specific_where VARCHAR2(2000);
397: ******************************************************************/
398: PROCEDURE get_terminations_trend_sql(
399: p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
400: x_custom_sql OUT NOCOPY VARCHAR2,
401: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
402:
403: -- Variables associated with the parameter portlet
404: l_query VARCHAR2(32767);
405: l_view_by VARCHAR2(120);