DBA Data[Home] [Help]

APPS.IBE_BI_SM_KPI_PVT dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 11: x_custom_output OUT NOCOPY bis_query_attributes_TBL );

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: /***********************************************************************/

Line 20: x_custom_output OUT NOCOPY bis_query_attributes_TBL );

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 */

Line 30: x_custom_output OUT NOCOPY bis_query_attributes_TBL );

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: /***********************************************************************/

Line 39: x_custom_output OUT NOCOPY bis_query_attributes_TBL );

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: /***********************************************************************/

Line 48: x_custom_output OUT NOCOPY bis_query_attributes_TBL );

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: /***********************************************************************/

Line 57: x_custom_output OUT NOCOPY bis_query_attributes_TBL );

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: /***********************************************************************/

Line 66: x_custom_output OUT NOCOPY bis_query_attributes_TBL );

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: /***********************************************************************/

Line 75: x_custom_output OUT NOCOPY bis_query_attributes_TBL );

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;