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_AO_KPI_PRTLT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 36: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

32: l_agent_group VARCHAR2(3000);
33:
34: BEGIN
35: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
36: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
37:
38: IF (FND_PROFILE.DEFINED('BIX_PMV_AO_TARCONT')) THEN
39: begin
40: l_contgoal := TO_NUMBER(FND_PROFILE.VALUE('BIX_PMV_AO_TARCONT'));

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

441:
442:
443: l_custom_rec.attribute_name := ':l_cust_row_type';
444: l_custom_rec.attribute_value:= 'C';
445: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
446: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
447:
448: p_custom_output.Extend();
449: p_custom_output(p_custom_output.count) := l_custom_rec;

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

442:
443: l_custom_rec.attribute_name := ':l_cust_row_type';
444: l_custom_rec.attribute_value:= 'C';
445: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
446: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
447:
448: p_custom_output.Extend();
449: p_custom_output(p_custom_output.count) := l_custom_rec;
450:

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

449: p_custom_output(p_custom_output.count) := l_custom_rec;
450:
451: l_custom_rec.attribute_name := ':l_class_row_type';
452: l_custom_rec.attribute_value:= 'C';
453: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
454: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
455:
456: p_custom_output.Extend();
457: p_custom_output(p_custom_output.count) := l_custom_rec;

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

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

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

457: p_custom_output(p_custom_output.count) := l_custom_rec;
458:
459: l_custom_rec.attribute_name := ':l_period_type_id';
460: l_custom_rec.attribute_value:= 1;
461: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
462: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
463:
464: p_custom_output.Extend();
465: p_custom_output(p_custom_output.count) := l_custom_rec;

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

458:
459: l_custom_rec.attribute_name := ':l_period_type_id';
460: l_custom_rec.attribute_value:= 1;
461: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
462: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
463:
464: p_custom_output.Extend();
465: p_custom_output(p_custom_output.count) := l_custom_rec;
466:

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

468: IF l_call_center IS NOT NULL
469: THEN
470: l_custom_rec.attribute_name := ':l_call_center';
471: l_custom_rec.attribute_value:= l_call_center;
472: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
473: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
474:
475: p_custom_output.Extend();
476: p_custom_output(p_custom_output.count) := l_custom_rec;

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

469: THEN
470: l_custom_rec.attribute_name := ':l_call_center';
471: l_custom_rec.attribute_value:= l_call_center;
472: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
473: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
474:
475: p_custom_output.Extend();
476: p_custom_output(p_custom_output.count) := l_custom_rec;
477: END IF;

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

478: IF l_campaign_id IS NOT NULL
479: THEN
480: l_custom_rec.attribute_name := ':l_campaign_id';
481: l_custom_rec.attribute_value:= l_campaign_id;
482: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
483: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
484:
485: p_custom_output.Extend();
486: p_custom_output(p_custom_output.count) := l_custom_rec;

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

479: THEN
480: l_custom_rec.attribute_name := ':l_campaign_id';
481: l_custom_rec.attribute_value:= l_campaign_id;
482: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
483: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
484:
485: p_custom_output.Extend();
486: p_custom_output(p_custom_output.count) := l_custom_rec;
487: END IF;

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

489: IF l_schedule_id IS NOT NULL
490: THEN
491: l_custom_rec.attribute_name := ':l_schedule_id';
492: l_custom_rec.attribute_value:= l_schedule_id;
493: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
494: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
495:
496: p_custom_output.Extend();
497: p_custom_output(p_custom_output.count) := l_custom_rec;

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

490: THEN
491: l_custom_rec.attribute_name := ':l_schedule_id';
492: l_custom_rec.attribute_value:= l_schedule_id;
493: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
494: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
495:
496: p_custom_output.Extend();
497: p_custom_output(p_custom_output.count) := l_custom_rec;
498: END IF;

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

499: IF l_source_code_id IS NOT NULL
500: THEN
501: l_custom_rec.attribute_name := ':l_source_code_id';
502: l_custom_rec.attribute_value:= l_source_code_id;
503: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
504: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
505:
506: p_custom_output.Extend();
507: p_custom_output(p_custom_output.count) := l_custom_rec;

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

500: THEN
501: l_custom_rec.attribute_name := ':l_source_code_id';
502: l_custom_rec.attribute_value:= l_source_code_id;
503: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
504: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
505:
506: p_custom_output.Extend();
507: p_custom_output(p_custom_output.count) := l_custom_rec;
508: END IF;

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

509:
510:
511: l_custom_rec.attribute_name := ':l_application_id';
512: l_custom_rec.attribute_value := 696;
513: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
514: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
515:
516: p_custom_output.EXTEND;
517: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

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

510:
511: l_custom_rec.attribute_name := ':l_application_id';
512: l_custom_rec.attribute_value := 696;
513: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
514: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
515:
516: p_custom_output.EXTEND;
517: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
518: