APPS.IBE_BI_SM_KPI_PVT dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 5: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,

1: PACKAGE BODY IBE_BI_SM_KPI_PVT AS
2: /* $Header: IBEVBISMKPIB.pls 120.8 2006/06/26 08:57:11 gjothiku ship $ */
3:
4: PROCEDURE GET_NEW_CUST_KPI_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: ) IS
9: l_custom_sql VARCHAR2(15000);

Line 186: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,

182: END GET_NEW_CUST_KPI_SQL;
183:
184:
185: PROCEDURE GET_CART_ORD_KPIS_SQL(
186: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
187: x_custom_sql OUT NOCOPY VARCHAR2,
188: x_custom_output OUT NOCOPY bis_query_attributes_TBL
189: ) IS
190: l_custom_sql VARCHAR2(15000); --4660266

Line 446: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,

442: END GET_CART_ORD_KPIS_SQL;
443:
444:
445: PROCEDURE GET_AVG_ORD_KPI_SQL(
446: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
447: x_custom_sql OUT NOCOPY VARCHAR2,
448: x_custom_output OUT NOCOPY bis_query_attributes_TBL
449: ) IS
450: l_custom_sql VARCHAR2(4000);

Line 469: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,

465: END GET_AVG_ORD_KPI_SQL;
466:
467:
468: PROCEDURE GET_BOOK_ORD_KPI_SQL(
469: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
470: x_custom_sql OUT NOCOPY VARCHAR2,
471: x_custom_output OUT NOCOPY bis_query_attributes_TBL
472: ) IS
473: l_custom_sql VARCHAR2(4000);

Line 494: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,

490:
491:
492:
493: PROCEDURE GET_CARTS_KPI_SQL(
494: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
495: x_custom_sql OUT NOCOPY VARCHAR2,
496: x_custom_output OUT NOCOPY bis_query_attributes_TBL
497: ) IS
498: l_custom_sql VARCHAR2(4000);

Line 518: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,

514: END GET_CARTS_KPI_SQL;
515:
516:
517: PROCEDURE GET_CARTS_CONV_KPI_SQL(
518: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
519: x_custom_sql OUT NOCOPY VARCHAR2,
520: x_custom_output OUT NOCOPY bis_query_attributes_TBL
521: ) IS
522: l_custom_sql VARCHAR2(4000);

Line 544: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,

540:
541:
542:
543: PROCEDURE GET_AVG_DISC_KPI_SQL(
544: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
545: x_custom_sql OUT NOCOPY VARCHAR2,
546: x_custom_output OUT NOCOPY bis_query_attributes_TBL
547: ) IS
548: l_custom_sql VARCHAR2(4000);

Line 568: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,

564: END GET_AVG_DISC_KPI_SQL;
565:
566:
567: PROCEDURE GET_CAMP_ORD_KPI_SQL(
568: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,
569: x_custom_sql OUT NOCOPY VARCHAR2,
570: x_custom_output OUT NOCOPY bis_query_attributes_TBL
571: ) IS
572: l_custom_sql VARCHAR2(4000);