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.BIX_PMV_AI_KPI_PRTLT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 29: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

25: l_view_by VARCHAR2(3000);
26:
27: BEGIN
28: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
29: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
30:
31: IF (FND_PROFILE.DEFINED('BIX_CALL_SLGOAL_PERCENT')) THEN
32: BEGIN
33: l_goal := TO_NUMBER(FND_PROFILE.VALUE('BIX_CALL_SLGOAL_PERCENT'));

Line 431: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

427: p_sql_text := l_sqltext;
428:
429: l_custom_rec.attribute_name := ':l_cust_row_type';
430: l_custom_rec.attribute_value:= 'CDPR';
431: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
432: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
433:
434: p_custom_output.Extend();
435: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 432: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

428:
429: l_custom_rec.attribute_name := ':l_cust_row_type';
430: l_custom_rec.attribute_value:= 'CDPR';
431: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
432: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
433:
434: p_custom_output.Extend();
435: p_custom_output(p_custom_output.count) := l_custom_rec;
436:

Line 439: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

435: p_custom_output(p_custom_output.count) := l_custom_rec;
436:
437: l_custom_rec.attribute_name := ':l_class_row_type';
438: l_custom_rec.attribute_value:= 'CDR';
439: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
440: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
441:
442: p_custom_output.Extend();
443: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 440: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

436:
437: l_custom_rec.attribute_name := ':l_class_row_type';
438: l_custom_rec.attribute_value:= 'CDR';
439: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
440: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
441:
442: p_custom_output.Extend();
443: p_custom_output(p_custom_output.count) := l_custom_rec;
444:

Line 447: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

443: p_custom_output(p_custom_output.count) := l_custom_rec;
444:
445: l_custom_rec.attribute_name := ':l_period_type_id';
446: l_custom_rec.attribute_value:= 1;
447: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
448: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
449:
450: p_custom_output.Extend();
451: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 448: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

444:
445: l_custom_rec.attribute_name := ':l_period_type_id';
446: l_custom_rec.attribute_value:= 1;
447: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
448: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
449:
450: p_custom_output.Extend();
451: p_custom_output(p_custom_output.count) := l_custom_rec;
452:

Line 455: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

451: p_custom_output(p_custom_output.count) := l_custom_rec;
452:
453: l_custom_rec.attribute_name := ':l_period_start_time';
454: l_custom_rec.attribute_value:= '00:00';
455: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
456: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
457:
458: p_custom_output.Extend();
459: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 456: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

452:
453: l_custom_rec.attribute_name := ':l_period_start_time';
454: l_custom_rec.attribute_value:= '00:00';
455: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
456: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
457:
458: p_custom_output.Extend();
459: p_custom_output(p_custom_output.count) := l_custom_rec;
460:

Line 465: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

461: IF l_call_center IS NOT NULL
462: THEN
463: l_custom_rec.attribute_name := ':l_call_center';
464: l_custom_rec.attribute_value:= l_call_center;
465: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
466: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
467:
468: p_custom_output.Extend();
469: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 466: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

462: THEN
463: l_custom_rec.attribute_name := ':l_call_center';
464: l_custom_rec.attribute_value:= l_call_center;
465: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
466: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
467:
468: p_custom_output.Extend();
469: p_custom_output(p_custom_output.count) := l_custom_rec;
470: END IF;

Line 476: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

472: IF l_classification IS NOT NULL
473: THEN
474: l_custom_rec.attribute_name := ':l_classification';
475: l_custom_rec.attribute_value:= l_classification;
476: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
477: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
478:
479: p_custom_output.EXTEND;
480: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

Line 477: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

473: THEN
474: l_custom_rec.attribute_name := ':l_classification';
475: l_custom_rec.attribute_value:= l_classification;
476: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
477: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
478:
479: p_custom_output.EXTEND;
480: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
481: END IF;

Line 487: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

483: IF l_dnis IS NOT NULL AND l_dnis NOT IN ('INBOUND','OUTBOUND')
484: THEN
485: l_custom_rec.attribute_name := ':l_dnis';
486: l_custom_rec.attribute_value:= l_dnis;
487: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
488: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
489:
490: p_custom_output.Extend();
491: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 488: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

484: THEN
485: l_custom_rec.attribute_name := ':l_dnis';
486: l_custom_rec.attribute_value:= l_dnis;
487: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
488: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
489:
490: p_custom_output.Extend();
491: p_custom_output(p_custom_output.count) := l_custom_rec;
492: END IF;

Line 496: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

492: END IF;
493:
494: l_custom_rec.attribute_name := ':l_application_id';
495: l_custom_rec.attribute_value := 696;
496: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
497: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
498:
499: p_custom_output.EXTEND;
500: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

Line 497: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

493:
494: l_custom_rec.attribute_name := ':l_application_id';
495: l_custom_rec.attribute_value := 696;
496: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
497: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
498:
499: p_custom_output.EXTEND;
500: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
501: