1: PACKAGE IBW_BI_VST_CMP_KPI_PVT AS
2: /* $Header: ibwbvcks.pls 120.1 2005/09/25 08:03 narao noship $ */
3:
4: PROCEDURE GET_VISTR_CONV_TRND_SQL (
5: p_pmv_parameters 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:
8: );
9:
10:
11: PROCEDURE GET_VISIT_TREND_SQL(
12: p_pmv_parameters 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:
15: );
16:
17: PROCEDURE GET_WEB_CAMPAIGN_SQL
18: (
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:
21: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
22: );
23:
24: PROCEDURE GET_KPI_SQL(
25: p_pmv_parameters 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: