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

Line 860: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

856: l_unsolicited VARCHAR2(50);
857: l_unknown VARCHAR2(50);
858:
859: BEGIN
860: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
861: IF p_func_area='ICSTR' THEN
862: l_custom_rec.attribute_name := ':l_unknown';
863: l_custom_rec.attribute_value := FND_MESSAGE.GET_STRING('BIX','BIX_PMV_UNKNOWN');
864: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

Line 864: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

860: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
861: IF p_func_area='ICSTR' THEN
862: l_custom_rec.attribute_name := ':l_unknown';
863: l_custom_rec.attribute_value := FND_MESSAGE.GET_STRING('BIX','BIX_PMV_UNKNOWN');
864: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
865: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
866: x_custom_output.EXTEND;
867: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
868: END IF;

Line 865: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

861: IF p_func_area='ICSTR' THEN
862: l_custom_rec.attribute_name := ':l_unknown';
863: l_custom_rec.attribute_value := FND_MESSAGE.GET_STRING('BIX','BIX_PMV_UNKNOWN');
864: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
865: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
866: x_custom_output.EXTEND;
867: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
868: END IF;
869: IF p_func_area='IOUTP' THEN

Line 872: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

868: END IF;
869: IF p_func_area='IOUTP' THEN
870: l_custom_rec.attribute_name := ':l_lookup_type';
871: l_custom_rec.attribute_value := 'BIX_PMV_AI_OUTCOMES';
872: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
873: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
874: x_custom_output.EXTEND;
875: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
876: END IF;

Line 873: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

869: IF p_func_area='IOUTP' THEN
870: l_custom_rec.attribute_name := ':l_lookup_type';
871: l_custom_rec.attribute_value := 'BIX_PMV_AI_OUTCOMES';
872: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
873: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
874: x_custom_output.EXTEND;
875: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
876: END IF;
877: IF p_func_area='IORRR' THEN

Line 888: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

884: END IF;
885:
886: l_custom_rec.attribute_name := ':l_outcome_filter';
887: l_custom_rec.attribute_value := -1;
888: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
889: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
890: x_custom_output.EXTEND;
891: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
892:

Line 889: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;

885:
886: l_custom_rec.attribute_name := ':l_outcome_filter';
887: l_custom_rec.attribute_value := -1;
888: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
889: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
890: x_custom_output.EXTEND;
891: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
892:
893: l_custom_rec.attribute_name := ':l_unknown';

Line 895: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

891: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
892:
893: l_custom_rec.attribute_name := ':l_unknown';
894: l_custom_rec.attribute_value := l_unknown;
895: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
896: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
897: x_custom_output.EXTEND;
898: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
899:

Line 896: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

892:
893: l_custom_rec.attribute_name := ':l_unknown';
894: l_custom_rec.attribute_value := l_unknown;
895: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
896: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
897: x_custom_output.EXTEND;
898: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
899:
900: END IF;

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

937: END IF;
938:
939: l_custom_rec.attribute_name := ':l_inbound';
940: l_custom_rec.attribute_value:= l_inbound;
941: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
942: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
943:
944: x_custom_output.Extend();
945: x_custom_output(x_custom_output.count) := l_custom_rec;

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

938:
939: l_custom_rec.attribute_name := ':l_inbound';
940: l_custom_rec.attribute_value:= l_inbound;
941: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
942: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
943:
944: x_custom_output.Extend();
945: x_custom_output(x_custom_output.count) := l_custom_rec;
946:

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

945: x_custom_output(x_custom_output.count) := l_custom_rec;
946:
947: l_custom_rec.attribute_name := ':l_direct';
948: l_custom_rec.attribute_value:= l_direct;
949: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
950: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
951:
952: x_custom_output.Extend();
953: x_custom_output(x_custom_output.count) := l_custom_rec;

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

946:
947: l_custom_rec.attribute_name := ':l_direct';
948: l_custom_rec.attribute_value:= l_direct;
949: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
950: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
951:
952: x_custom_output.Extend();
953: x_custom_output(x_custom_output.count) := l_custom_rec;
954:

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

953: x_custom_output(x_custom_output.count) := l_custom_rec;
954:
955: l_custom_rec.attribute_name := ':l_dialed';
956: l_custom_rec.attribute_value:= l_dialed;
957: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
958: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
959:
960: x_custom_output.Extend();
961: x_custom_output(x_custom_output.count) := l_custom_rec;

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

954:
955: l_custom_rec.attribute_name := ':l_dialed';
956: l_custom_rec.attribute_value:= l_dialed;
957: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
958: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
959:
960: x_custom_output.Extend();
961: x_custom_output(x_custom_output.count) := l_custom_rec;
962:

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

961: x_custom_output(x_custom_output.count) := l_custom_rec;
962:
963: l_custom_rec.attribute_name := ':l_webcall';
964: l_custom_rec.attribute_value:= l_webcall;
965: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
966: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
967:
968: x_custom_output.Extend();
969: x_custom_output(x_custom_output.count) := l_custom_rec;

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

962:
963: l_custom_rec.attribute_name := ':l_webcall';
964: l_custom_rec.attribute_value:= l_webcall;
965: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
966: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
967:
968: x_custom_output.Extend();
969: x_custom_output(x_custom_output.count) := l_custom_rec;
970:

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

969: x_custom_output(x_custom_output.count) := l_custom_rec;
970:
971: l_custom_rec.attribute_name := ':l_unsolicited';
972: l_custom_rec.attribute_value:= l_unsolicited;
973: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
974: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
975:
976: x_custom_output.Extend();
977: x_custom_output(x_custom_output.count) := l_custom_rec;

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

970:
971: l_custom_rec.attribute_name := ':l_unsolicited';
972: l_custom_rec.attribute_value:= l_unsolicited;
973: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
974: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
975:
976: x_custom_output.Extend();
977: x_custom_output(x_custom_output.count) := l_custom_rec;
978:

Line 981: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

977: x_custom_output(x_custom_output.count) := l_custom_rec;
978:
979: END IF;
980: IF g_dnis is NOT NULL AND g_dnis NOT IN ('INBOUND','OUTBOUND') THEN
981: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
982: l_custom_rec.attribute_name := ':l_dnis';
983: l_custom_rec.attribute_value := g_dnis;
984: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
985: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

Line 984: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

980: IF g_dnis is NOT NULL AND g_dnis NOT IN ('INBOUND','OUTBOUND') THEN
981: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
982: l_custom_rec.attribute_name := ':l_dnis';
983: l_custom_rec.attribute_value := g_dnis;
984: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
985: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
986: x_custom_output.EXTEND;
987: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
988: END IF;

Line 985: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

981: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
982: l_custom_rec.attribute_name := ':l_dnis';
983: l_custom_rec.attribute_value := g_dnis;
984: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
985: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
986: x_custom_output.EXTEND;
987: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
988: END IF;
989:

Line 993: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

989:
990: IF p_func_area='IAGTR' THEN
991: l_custom_rec.attribute_name := ':l_agent_group';
992: l_custom_rec.attribute_value := g_agent_group;
993: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
994: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
995: x_custom_output.EXTEND;
996: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
997: END IF;

Line 994: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

990: IF p_func_area='IAGTR' THEN
991: l_custom_rec.attribute_name := ':l_agent_group';
992: l_custom_rec.attribute_value := g_agent_group;
993: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
994: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
995: x_custom_output.EXTEND;
996: x_custom_output (x_custom_output.COUNT) := l_custom_rec;
997: END IF;
998: