PACKAGE: APPS.OKI_DBI_SRM_RNWL_PVT

Source

1 PACKAGE OKI_DBI_SRM_RNWL_PVT AS
2 /* $Header: OKIIRNWS.pls 120.1 2006/03/28 23:28:36 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_top_bookings_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_renewal_forecast_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     PROCEDURE get_late_rnwl_table_sql (
25     p_param                     IN       bis_pmv_page_parameter_tbl
26   , x_custom_sql                OUT NOCOPY VARCHAR2
27   , x_custom_output             OUT NOCOPY bis_query_attributes_tbl) ;
28 
29     PROCEDURE get_cncl_table_sql (
30     p_param                     IN       bis_pmv_page_parameter_tbl
31   , x_custom_sql                OUT NOCOPY VARCHAR2
32   , x_custom_output             OUT NOCOPY bis_query_attributes_tbl);
33 
34     PROCEDURE get_cancellations_sql (
35     p_param                     IN       bis_pmv_page_parameter_tbl
36   , x_custom_sql                OUT NOCOPY VARCHAR2
37   , x_custom_output             OUT NOCOPY bis_query_attributes_tbl);
38 
39    PROCEDURE get_bucket_sql(
40    p_param 			IN 	 bis_pmv_page_parameter_tbl
41  , x_custom_sql  		OUT NOCOPY VARCHAR2
42  , x_custom_output 		OUT NOCOPY bis_query_attributes_tbl);
43 
44    PROCEDURE get_bkng_trend_sql(
45 
46    p_param 			IN BIS_PMV_PAGE_PARAMETER_TBL,
47    x_custom_sql  		OUT NOCOPY VARCHAR2,
48    x_custom_output 		OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL);
49 
50    FUNCTION get_bkng_trend_sel_clause
51       RETURN VARCHAR2;
52 
53 
54    PROCEDURE get_bkngs_by_cust_sql (
55    p_param                     IN       bis_pmv_page_parameter_tbl,
56    x_custom_sql                OUT NOCOPY VARCHAR2,
57    x_custom_output             OUT NOCOPY bis_query_attributes_tbl);
58 
59 
60    PROCEDURE get_exp_bkngs_by_cust_sql (
61    p_param                     IN       bis_pmv_page_parameter_tbl,
62    x_custom_sql                OUT NOCOPY VARCHAR2,
63    x_custom_output             OUT NOCOPY bis_query_attributes_tbl);
64 
65 
66    PROCEDURE get_cancln_by_cust_sql (
67    p_param                     IN       bis_pmv_page_parameter_tbl,
68    x_custom_sql                OUT NOCOPY VARCHAR2,
69    x_custom_output             OUT NOCOPY bis_query_attributes_tbl);
70 
71 
72 END oki_dbi_srm_rnwl_pvt ;