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

Line 37: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

33:
34: BEGIN
35: /* Initialize p_custom_output and l_custom_rec */
36: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
37: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
38:
39: l_where_clause := NULL;
40: l_call_center := NULL;
41: l_view_by := NULL;

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

994:
995:
996: l_custom_rec.attribute_name := ':l_unknown' ;
997: l_custom_rec.attribute_value:= l_unknown;
998: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
999: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1000:
1001: p_custom_output.Extend();
1002: p_custom_output(p_custom_output.count) := l_custom_rec;

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

995:
996: l_custom_rec.attribute_name := ':l_unknown' ;
997: l_custom_rec.attribute_value:= l_unknown;
998: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
999: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1000:
1001: p_custom_output.Extend();
1002: p_custom_output(p_custom_output.count) := l_custom_rec;
1003:

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

1004: -- p_custom_output.EXTEND();
1005: IF l_call_center IS NOT NULL THEN
1006: l_custom_rec.attribute_name := ':l_call_center' ;
1007: l_custom_rec.attribute_value:= l_call_center;
1008: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1009: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1010:
1011: p_custom_output.Extend();
1012: p_custom_output(p_custom_output.count) := l_custom_rec;

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

1005: IF l_call_center IS NOT NULL THEN
1006: l_custom_rec.attribute_name := ':l_call_center' ;
1007: l_custom_rec.attribute_value:= l_call_center;
1008: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1009: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1010:
1011: p_custom_output.Extend();
1012: p_custom_output(p_custom_output.count) := l_custom_rec;
1013: END IF;

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

1014: IF l_campaign_id IS NOT NULL
1015: THEN
1016: l_custom_rec.attribute_name := ':l_campaign_id';
1017: l_custom_rec.attribute_value:= l_campaign_id;
1018: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1019: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1020:
1021: p_custom_output.Extend();
1022: p_custom_output(p_custom_output.count) := l_custom_rec;

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

1015: THEN
1016: l_custom_rec.attribute_name := ':l_campaign_id';
1017: l_custom_rec.attribute_value:= l_campaign_id;
1018: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1019: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1020:
1021: p_custom_output.Extend();
1022: p_custom_output(p_custom_output.count) := l_custom_rec;
1023: END IF;

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

1025: IF l_schedule_id IS NOT NULL
1026: THEN
1027: l_custom_rec.attribute_name := ':l_schedule_id';
1028: l_custom_rec.attribute_value:= l_schedule_id;
1029: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1030: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1031:
1032: p_custom_output.Extend();
1033: p_custom_output(p_custom_output.count) := l_custom_rec;

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

1026: THEN
1027: l_custom_rec.attribute_name := ':l_schedule_id';
1028: l_custom_rec.attribute_value:= l_schedule_id;
1029: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1030: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1031:
1032: p_custom_output.Extend();
1033: p_custom_output(p_custom_output.count) := l_custom_rec;
1034: END IF;

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

1035: IF l_source_code_id IS NOT NULL
1036: THEN
1037: l_custom_rec.attribute_name := ':l_source_code_id';
1038: l_custom_rec.attribute_value:= l_source_code_id;
1039: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1040: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1041:
1042: p_custom_output.Extend();
1043: p_custom_output(p_custom_output.count) := l_custom_rec;

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

1036: THEN
1037: l_custom_rec.attribute_name := ':l_source_code_id';
1038: l_custom_rec.attribute_value:= l_source_code_id;
1039: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1040: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1041:
1042: p_custom_output.Extend();
1043: p_custom_output(p_custom_output.count) := l_custom_rec;
1044: END IF;

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

1046: IF l_view_by = 'CAMPAIGN+CAMPAIGN' THEN
1047:
1048: l_custom_rec.attribute_name := ':l_camp';
1049: l_custom_rec.attribute_value:= 'CAMP';
1050: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1051: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1052:
1053: p_custom_output.Extend();
1054: p_custom_output(p_custom_output.count) := l_custom_rec;

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

1047:
1048: l_custom_rec.attribute_name := ':l_camp';
1049: l_custom_rec.attribute_value:= 'CAMP';
1050: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1051: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1052:
1053: p_custom_output.Extend();
1054: p_custom_output(p_custom_output.count) := l_custom_rec;
1055:

Line 1059: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

1055:
1056: END IF;
1057:
1058:
1059: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1060: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
1061: l_custom_rec.attribute_value := l_view_by;
1062:
1063: p_custom_output.EXTEND();

Line 1060: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;

1056: END IF;
1057:
1058:
1059: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1060: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
1061: l_custom_rec.attribute_value := l_view_by;
1062:
1063: p_custom_output.EXTEND();
1064: p_custom_output(p_custom_output.COUNT) := l_custom_rec;