1 PACKAGE IBE_BI_TOP_ACT_PVT AS
2 /* $Header: IBEVBITOPACTS.pls 120.1 2005/09/16 05:52:17 appldev ship $ */
3
4 /**************************************************************************/
5 /* This procedure will return the SQL for Store Top Orders Portlet */
6 /**************************************************************************/
7
8 PROCEDURE GET_TOP_ORDERS_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 SQL for Store Top Carts Portlet */
15 /**************************************************************************/
16
17 PROCEDURE GET_TOP_CARTS_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 /* This procedure will return the SQL for Store Top Customers Portlet */
24 /**************************************************************************/
25
26 PROCEDURE GET_TOP_CUSTOMERS_SQL(
27 p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
28 x_custom_sql OUT NOCOPY VARCHAR2,
29 x_custom_output OUT NOCOPY bis_query_attributes_TBL );
30
31 /**************************************************************************/
32 /* This procedure will return the SQL for Store Top Products Portlet */
33 /**************************************************************************/
34
35 PROCEDURE GET_TOP_PRODUCTS_SQL(
36 p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
37 x_custom_sql OUT NOCOPY VARCHAR2,
38 x_custom_output OUT NOCOPY bis_query_attributes_TBL );
39
40 END IBE_BI_TOP_ACT_PVT;