[Home] [Help]
PACKAGE: APPS.OKI_DBI_NSCM_TRM_PVT
Source
1 PACKAGE OKI_DBI_NSCM_TRM_PVT AS
2 /* $Header: OKIPNTRS.pls 120.1 2006/03/28 23:32:39 asparama noship $ */
3
4 PROCEDURE Get_Terminations_Sql(
5 p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
6 x_custom_sql OUT NOCOPY VARCHAR2,
7 x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
8
9 FUNCTION Get_Terminations_Sel_Clause(
10 p_view_by_dim IN VARCHAR2,
11 p_view_by_col IN VARCHAR2) RETURN VARCHAR2;
12
13 PROCEDURE Get_Terminations_Detail_Sql(
14 p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
15 x_custom_sql OUT NOCOPY VARCHAR2,
16 x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
17
18 PROCEDURE Get_Terminations_Trend_Sql(
19 p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
20 x_custom_sql OUT NOCOPY VARCHAR2,
21 x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
22
23 FUNCTION Get_Trm_Trend_Sel_Clause RETURN VARCHAR2;
24
25 END OKI_DBI_NSCM_TRM_PVT;