1 PACKAGE IBE_BI_SM_KPI_PVT AS
2 /* $Header: IBEVBISMKPIS.pls 120.1 2005/09/16 05:51:58 appldev ship $ */
3
4 /***********************************************************************/
5 /* This procedure will return the Query for New Customers KPI */
6 /***********************************************************************/
7
8 PROCEDURE GET_NEW_CUST_KPI_SQL(
9 p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
10 x_custom_sql OUT NOCOPY VARCHAR2,
11 x_custom_output OUT NOCOPY bis_query_attributes_TBL );
12
13 /***********************************************************************/
14 /* This procedure will return the Query for Average Order Value KPI */
15 /***********************************************************************/
16
17 PROCEDURE GET_CART_ORD_KPIS_SQL(
18 p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
19 x_custom_sql OUT NOCOPY VARCHAR2,
20 x_custom_output OUT NOCOPY bis_query_attributes_TBL );
21
22 /***********************************************************************/
23 /***********************************************************************/
24 /* This procedure will return the Query for Average Order Value KPI */
25 /***********************************************************************/
26
27 PROCEDURE GET_AVG_ORD_KPI_SQL(
28 p_pmv_parameters 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 /***********************************************************************/
33 /* This procedure will return the Query for Booked Order Value KPI */
34 /***********************************************************************/
35
36 PROCEDURE GET_BOOK_ORD_KPI_SQL(
37 p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
38 x_custom_sql OUT NOCOPY VARCHAR2,
39 x_custom_output OUT NOCOPY bis_query_attributes_TBL );
40
41 /***********************************************************************/
42 /* This procedure will return the Query for Carts KPI */
43 /***********************************************************************/
44
45 PROCEDURE GET_CARTS_KPI_SQL(
46 p_pmv_parameters 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 /***********************************************************************/
51 /* This procedure will return the Query for Converted Carts KPI */
52 /***********************************************************************/
53
54 PROCEDURE GET_CARTS_CONV_KPI_SQL(
55 p_pmv_parameters 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 /* This procedure will return the Query for Average Order Discount KPI */
61 /***********************************************************************/
62
63 PROCEDURE GET_AVG_DISC_KPI_SQL(
64 p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
65 x_custom_sql OUT NOCOPY VARCHAR2,
66 x_custom_output OUT NOCOPY bis_query_attributes_TBL );
67
68 /***********************************************************************/
69 /* This procedure will return the Query for Campaign Orders KPI */
70 /***********************************************************************/
71
72 PROCEDURE GET_CAMP_ORD_KPI_SQL(
73 p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
74 x_custom_sql OUT NOCOPY VARCHAR2,
75 x_custom_output OUT NOCOPY bis_query_attributes_TBL );
76
77 END IBE_BI_SM_KPI_PVT;