5: * Procedure to return the query for Terminations portlet
6: ******************************************************************/
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);
279: RETURN l_query;
280: END Get_Trm_Dtl_Sel_Clause;
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);
395: /******************************************************************
396: * Procedure to return the query for Terminations TREND portlet
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