PACKAGE: APPS.OKI_DBI_SRM_PRNWL_PVT

Source

1 PACKAGE OKI_DBI_SRM_PRNWL_PVT AS
2 /* $Header: OKIIPRNS.pls 120.1 2006/03/28 23:28:06 asparama noship $ */
3 
4     PROCEDURE get_table_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     PROCEDURE get_bookings_sql(
10     p_param                     IN       bis_pmv_page_parameter_tbl
11   , x_custom_sql                OUT NOCOPY VARCHAR2
12   , x_custom_output             OUT NOCOPY bis_query_attributes_tbl);
13 
14     PROCEDURE get_rrate_sql(
15     p_param                     IN       bis_pmv_page_parameter_tbl
16   , x_custom_sql                OUT NOCOPY VARCHAR2
17   , x_custom_output             OUT NOCOPY bis_query_attributes_tbl);
18 
19    PROCEDURE get_pr_trend_sql(
20    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_trend_sel_clause
25    RETURN VARCHAR2;
26 
27    PROCEDURE get_bkngs_by_cust_sql (
28     p_param                     IN       bis_pmv_page_parameter_tbl
29   , x_custom_sql                OUT NOCOPY VARCHAR2
30   , x_custom_output             OUT NOCOPY bis_query_attributes_tbl);
31 
32 END oki_dbi_srm_prnwl_pvt ;