DBA Data[Home] [Help]

APPS.OKI_DBI_NSCM_TRM_PVT dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 9: p_param IN BIS_PMV_PAGE_PARAMETER_TBL,

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);

Line 283: p_param IN BIS_PMV_PAGE_PARAMETER_TBL,

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);

Line 399: p_param IN BIS_PMV_PAGE_PARAMETER_TBL,

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