DBA Data[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;