eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKI_DBI_SRM_RNWL_PVT dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 5: p_param IN bis_pmv_page_parameter_tbl

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(

Line 10: 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 (

Line 15: 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 (

Line 20: 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 (

Line 25: 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 (

Line 30: 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 (

Line 35: 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(

Line 40: 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(

Line 46: p_param IN BIS_PMV_PAGE_PARAMETER_TBL,

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

Line 55: p_param IN bis_pmv_page_parameter_tbl,

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:

Line 61: p_param IN bis_pmv_page_parameter_tbl,

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:

Line 67: p_param IN bis_pmv_page_parameter_tbl,

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: