1 PACKAGE IBE_BI_ORD_GRAPH_PVT AS
2 /* $Header: IBEVBIORDGRAS.pls 120.1 2005/09/16 06:11:14 appldev ship $ */
3 /**************************************************************************/
4 /* This procedure will return the Query for Order Graph Portlet */
5 /**************************************************************************/
6
7 PROCEDURE GET_ORDER_GRAPH_SQL(
8 p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
9 x_custom_sql OUT NOCOPY VARCHAR2,
10 x_custom_output OUT NOCOPY bis_query_attributes_TBL );
11
12 /**************************************************************************/
13 /* This procedure will return the Query for Average Order */
14 /* Value Graph Portlet */
15 /**************************************************************************/
16
17 PROCEDURE GET_AVG_ORD_GRAPH_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 Query for Average Order Discount */
24 /* Graph Portlet */
25 /**************************************************************************/
26
27 PROCEDURE GET_AVG_DISC_GRAPH_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 END IBE_BI_ORD_GRAPH_PVT;