APPS.IBE_BI_SM_KPI_PVT dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 7: x_custom_output OUT NOCOPY bis_query_attributes_TBL

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);
10: l_parameter_name VARCHAR2(3200);
11: l_asof_date DATE;

Line 145: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

141: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
142: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_new_cust_kpi_sql.query',l_custom_sql);
143: END IF;
144:
145: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
146: x_custom_output.Extend(4);
147:
148: l_custom_rec.attribute_name := ':l_asof_date' ;
149: l_custom_rec.attribute_value:= to_char(l_asof_date,'dd/mm/yyyy');

Line 188: x_custom_output OUT NOCOPY bis_query_attributes_TBL

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
191: l_parameter_name VARCHAR2(3200);
192: l_asof_date DATE;

Line 374: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

370: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
371: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_cart_ord_kpi_sql.query',l_custom_sql);
372: END IF;
373:
374: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
375: x_custom_output.Extend(8);
376:
377: l_custom_rec.attribute_name := ':l_asof_date' ;
378: l_custom_rec.attribute_value:= to_char(l_asof_date,'dd/mm/yyyy');

Line 448: x_custom_output OUT NOCOPY bis_query_attributes_TBL

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);
451: l_parameter_name VARCHAR2(3200);
452: l_asof_date DATE;

Line 471: x_custom_output OUT NOCOPY bis_query_attributes_TBL

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);
474: l_parameter_name VARCHAR2(3200);
475: l_asof_date DATE;

Line 496: x_custom_output OUT NOCOPY bis_query_attributes_TBL

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);
499: l_parameter_name VARCHAR2(3200);
500: l_asof_date DATE;

Line 520: x_custom_output OUT NOCOPY bis_query_attributes_TBL

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);
523: l_parameter_name VARCHAR2(3200);
524: l_asof_date DATE;

Line 546: x_custom_output OUT NOCOPY bis_query_attributes_TBL

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);
549: l_parameter_name VARCHAR2(3200);
550: l_asof_date DATE;

Line 570: x_custom_output OUT NOCOPY bis_query_attributes_TBL

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);
573: l_parameter_name VARCHAR2(3200);
574: l_asof_date DATE;