PACKAGE: APPS.ISC_DEPOT_COMPLETION_PKG

Source

1 PACKAGE ISC_DEPOT_COMPLETION_PKG AS
2 --$Header: iscdepotcomprqs.pls 120.0 2005/05/25 17:17:07 appldev noship $
3 
4 PROCEDURE GET_COMPLETION_TBL_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
5                               x_custom_sql OUT NOCOPY VARCHAR2,
6                               x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
7 
8 PROCEDURE GET_COMPLETION_TRD_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
9                               x_custom_sql OUT NOCOPY VARCHAR2,
10                               x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
11 
12 PROCEDURE GET_COMPLETION_DTL_TBL_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
13 				     x_custom_sql OUT NOCOPY VARCHAR2,
14 				     x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
15 
16 PROCEDURE GET_LAT_COMP_DTL_TBL_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
17 				    x_custom_sql OUT NOCOPY VARCHAR2,
18 				    x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
19 
20 PROCEDURE GET_LAT_COMP_AGNG_TBL_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
21 				   x_custom_sql OUT NOCOPY VARCHAR2,
22 				   x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
23 
24 FUNCTION GET_BUCKET_DRILL_ACROSS_URL (p_function_name VARCHAR2,
25                                       p_bucket_number NUMBER)
26 RETURN VARCHAR2;
27 
28 END ISC_DEPOT_COMPLETION_PKG;