eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_BI_SM_KPI_PVT dependencies on BIS_QUERY_ATTRIBUTES

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 19: l_custom_rec BIS_QUERY_ATTRIBUTES;-- :=

15: l_comparison_type VARCHAR2(3200);
16: l_currency_code VARCHAR2(3200);
17: l_minisite VARCHAR2(3200);
18: l_minisite_id VARCHAR2(3200);
19: l_custom_rec BIS_QUERY_ATTRIBUTES;-- :=
20: -- BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
21: dbg_msg VARCHAR2(3200);
22: l_g_p VARCHAR2(30);
23: l_g_s VARCHAR2(30);

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 201: l_custom_rec BIS_QUERY_ATTRIBUTES ;

197: l_c_d VARCHAR2(3200);
198: l_minisite VARCHAR2(3200);
199: l_minisite_id VARCHAR2(3200);
200: l_assist_type VARCHAR2(3200) ;
201: l_custom_rec BIS_QUERY_ATTRIBUTES ;
202: dbg_msg VARCHAR2(3200);
203: l_g_p VARCHAR2(30);
204: l_g_s VARCHAR2(30);
205: l_c_filter VARCHAR2(1000);

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 461: l_custom_rec BIS_QUERY_ATTRIBUTES ;

457: l_currency_code VARCHAR2(3200);
458: l_minisite VARCHAR2(3200);
459: l_minisite_id VARCHAR2(3200);
460: l_assist_type VARCHAR2(3200) ;
461: l_custom_rec BIS_QUERY_ATTRIBUTES ;
462: dbg_msg VARCHAR2(3200);
463: BEGIN
464: NULL;
465: END GET_AVG_ORD_KPI_SQL;

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 484: l_custom_rec BIS_QUERY_ATTRIBUTES ;

480: l_currency_code VARCHAR2(3200);
481: l_minisite VARCHAR2(3200);
482: l_minisite_id VARCHAR2(3200);
483: l_assist_type VARCHAR2(3200) ;
484: l_custom_rec BIS_QUERY_ATTRIBUTES ;
485: dbg_msg VARCHAR2(3200);
486: BEGIN
487:
488: NULL;

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 509: l_custom_rec BIS_QUERY_ATTRIBUTES ;

505: l_currency_code VARCHAR2(3200);
506: l_minisite VARCHAR2(3200);
507: l_minisite_id VARCHAR2(3200);
508: l_assist_type VARCHAR2(3200);
509: l_custom_rec BIS_QUERY_ATTRIBUTES ;
510: dbg_msg VARCHAR2(3200);
511:
512: BEGIN
513: NULL;

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 533: l_custom_rec BIS_QUERY_ATTRIBUTES ;

529: l_currency_code VARCHAR2(3200);
530: l_minisite VARCHAR2(3200);
531: l_minisite_id VARCHAR2(3200);
532: l_assist_type VARCHAR2(3200) ;
533: l_custom_rec BIS_QUERY_ATTRIBUTES ;
534: dbg_msg VARCHAR2(3200);
535:
536: BEGIN
537:

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 559: l_custom_rec BIS_QUERY_ATTRIBUTES ;

555: l_currency_code VARCHAR2(3200);
556: l_minisite VARCHAR2(3200);
557: l_minisite_id VARCHAR2(3200);
558: l_assist_type VARCHAR2(3200);
559: l_custom_rec BIS_QUERY_ATTRIBUTES ;
560: dbg_msg VARCHAR2(3200);
561: BEGIN
562:
563: NULL;

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;

Line 583: l_custom_rec BIS_QUERY_ATTRIBUTES ;

579: l_currency_code VARCHAR2(3200);
580: l_minisite VARCHAR2(3200);
581: l_minisite_id VARCHAR2(3200);
582: l_assist_type VARCHAR2(3200) ;
583: l_custom_rec BIS_QUERY_ATTRIBUTES ;
584: dbg_msg VARCHAR2(3200);
585:
586: BEGIN
587: