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

Line 89: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

85:
86: BEGIN
87: /*Intializing Variables */
88: g_pkg := 'bil.patch.115.sql.BIL_BI_TREND_MGMT_RPTS_PKG.';
89: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
90: l_proc := 'BIL_BI_FST_WON_TREND.';
91: l_parameter_valid := FALSE;
92: l_region_id := 'BIL_BI_FRCST_WON_QUOTA_TREND';
93: l_yes := 'Y';

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

880: l_bind_ctr := 1;
881:
882: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
883:
884: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
885: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
886: l_custom_rec.attribute_value := l_viewby;
887: x_custom_output.Extend();
888: x_custom_output(l_bind_ctr) := l_custom_rec;

Line 885: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

881:
882: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
883:
884: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
885: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
886: l_custom_rec.attribute_value := l_viewby;
887: x_custom_output.Extend();
888: x_custom_output(l_bind_ctr) := l_custom_rec;
889:

Line 894: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

890: l_bind_ctr:=l_bind_ctr+1;
891:
892: l_custom_rec.attribute_name := ':curr_prd_start_date';
893: l_custom_rec.attribute_value := TO_CHAR(l_curr_start_date,'DD/MM/YYYY');
894: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
895: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
896: x_custom_output.Extend();
897: x_custom_output(l_bind_ctr) := l_custom_rec;
898:

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

891:
892: l_custom_rec.attribute_name := ':curr_prd_start_date';
893: l_custom_rec.attribute_value := TO_CHAR(l_curr_start_date,'DD/MM/YYYY');
894: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
895: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
896: x_custom_output.Extend();
897: x_custom_output(l_bind_ctr) := l_custom_rec;
898:
899: l_bind_ctr := l_bind_ctr + 1;

Line 903: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

899: l_bind_ctr := l_bind_ctr + 1;
900:
901: l_custom_rec.attribute_name := ':l_curr_eff_end_date';
902: l_custom_rec.attribute_value := TO_CHAR(l_curr_eff_end_date,'DD/MM/YYYY');
903: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
904: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
905: x_custom_output.Extend();
906: x_custom_output(l_bind_ctr) := l_custom_rec;
907:

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

900:
901: l_custom_rec.attribute_name := ':l_curr_eff_end_date';
902: l_custom_rec.attribute_value := TO_CHAR(l_curr_eff_end_date,'DD/MM/YYYY');
903: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
904: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
905: x_custom_output.Extend();
906: x_custom_output(l_bind_ctr) := l_custom_rec;
907:
908: l_bind_ctr := l_bind_ctr + 1;

Line 912: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

908: l_bind_ctr := l_bind_ctr + 1;
909:
910: l_custom_rec.attribute_name := ':l_curr_start_date';
911: l_custom_rec.attribute_value := TO_CHAR(l_curr_start_date,'DD/MM/YYYY');
912: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
913: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
914: x_custom_output.Extend();
915: x_custom_output(l_bind_ctr) := l_custom_rec;
916:

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

909:
910: l_custom_rec.attribute_name := ':l_curr_start_date';
911: l_custom_rec.attribute_value := TO_CHAR(l_curr_start_date,'DD/MM/YYYY');
912: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
913: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
914: x_custom_output.Extend();
915: x_custom_output(l_bind_ctr) := l_custom_rec;
916:
917: l_bind_ctr := l_bind_ctr+1;

Line 921: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

917: l_bind_ctr := l_bind_ctr+1;
918:
919: l_custom_rec.attribute_name := ':l_prev_start_date';
920: l_custom_rec.attribute_value := TO_CHAR(l_prev_start_date,'DD/MM/YYYY');
921: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
922: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
923: x_custom_output.Extend();
924: x_custom_output(l_bind_ctr) := l_custom_rec;
925:

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

918:
919: l_custom_rec.attribute_name := ':l_prev_start_date';
920: l_custom_rec.attribute_value := TO_CHAR(l_prev_start_date,'DD/MM/YYYY');
921: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
922: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
923: x_custom_output.Extend();
924: x_custom_output(l_bind_ctr) := l_custom_rec;
925:
926: l_bind_ctr := l_bind_ctr+1;

Line 930: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

926: l_bind_ctr := l_bind_ctr+1;
927:
928: l_custom_rec.attribute_name := ':l_curr_as_of_date';
929: l_custom_rec.attribute_value := TO_CHAR(l_curr_as_of_date,'DD/MM/YYYY');
930: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
931: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
932: x_custom_output.Extend();
933: x_custom_output(l_bind_ctr) := l_custom_rec;
934:

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

927:
928: l_custom_rec.attribute_name := ':l_curr_as_of_date';
929: l_custom_rec.attribute_value := TO_CHAR(l_curr_as_of_date,'DD/MM/YYYY');
930: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
931: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
932: x_custom_output.Extend();
933: x_custom_output(l_bind_ctr) := l_custom_rec;
934:
935: l_bind_ctr:=l_bind_ctr+1;

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

935: l_bind_ctr:=l_bind_ctr+1;
936:
937: l_custom_rec.attribute_name := ':l_record_type_id';
938: l_custom_rec.attribute_value := l_record_type_id;
939: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
940: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
941: x_custom_output.Extend();
942: x_custom_output(l_bind_ctr) := l_custom_rec;
943:

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

936:
937: l_custom_rec.attribute_name := ':l_record_type_id';
938: l_custom_rec.attribute_value := l_record_type_id;
939: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
940: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
941: x_custom_output.Extend();
942: x_custom_output(l_bind_ctr) := l_custom_rec;
943:
944: l_bind_ctr := l_bind_ctr+1;

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

944: l_bind_ctr := l_bind_ctr+1;
945:
946: l_custom_rec.attribute_name := ':l_bitand_id';
947: l_custom_rec.attribute_value := l_bitand_id;
948: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
949: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
950: x_custom_output.Extend();
951: x_custom_output(l_bind_ctr) := l_custom_rec;
952:

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

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

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

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

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

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

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

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

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

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

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

970: l_bind_ctr := l_bind_ctr+1;
971:
972: l_custom_rec.attribute_name := ':l_sg_id_num';
973: l_custom_rec.attribute_value := l_sg_id_num;
974: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
975: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
976: x_custom_output.Extend();
977: x_custom_output(l_bind_ctr) := l_custom_rec;
978:

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

971:
972: l_custom_rec.attribute_name := ':l_sg_id_num';
973: l_custom_rec.attribute_value := l_sg_id_num;
974: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
975: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
976: x_custom_output.Extend();
977: x_custom_output(l_bind_ctr) := l_custom_rec;
978:
979: l_bind_ctr := l_bind_ctr+1;

Line 984: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

980:
981: IF l_parent_sls_grp_id IS NOT NULL THEN
982: l_custom_rec.attribute_name := ':l_parent_sls_grp_id';
983: l_custom_rec.attribute_value := l_parent_sls_grp_id;
984: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
985: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
986: x_custom_output.Extend();
987: x_custom_output(l_bind_ctr) := l_custom_rec;
988:

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

981: IF l_parent_sls_grp_id IS NOT NULL THEN
982: l_custom_rec.attribute_name := ':l_parent_sls_grp_id';
983: l_custom_rec.attribute_value := l_parent_sls_grp_id;
984: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
985: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
986: x_custom_output.Extend();
987: x_custom_output(l_bind_ctr) := l_custom_rec;
988:
989: l_bind_ctr := l_bind_ctr+1;

Line 995: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

991:
992:
993: l_custom_rec.attribute_name := ':l_resource_id';
994: l_custom_rec.attribute_value := l_resource_id;
995: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
996: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
997: x_custom_output.Extend();
998: x_custom_output(l_bind_ctr) := l_custom_rec;
999:

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

992:
993: l_custom_rec.attribute_name := ':l_resource_id';
994: l_custom_rec.attribute_value := l_resource_id;
995: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
996: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
997: x_custom_output.Extend();
998: x_custom_output(l_bind_ctr) := l_custom_rec;
999:
1000: l_bind_ctr := l_bind_ctr+1;

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

1001:
1002:
1003: l_custom_rec.attribute_name := ':l_fst_crdt_type';
1004: l_custom_rec.attribute_value := l_fst_crdt_type;
1005: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1006: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1007: x_custom_output.Extend();
1008: x_custom_output(l_bind_ctr) := l_custom_rec;
1009:

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

1002:
1003: l_custom_rec.attribute_name := ':l_fst_crdt_type';
1004: l_custom_rec.attribute_value := l_fst_crdt_type;
1005: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1006: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1007: x_custom_output.Extend();
1008: x_custom_output(l_bind_ctr) := l_custom_rec;
1009:
1010: l_bind_ctr := l_bind_ctr+1;

Line 1014: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

1010: l_bind_ctr := l_bind_ctr+1;
1011:
1012: l_custom_rec.attribute_name := ':l_prev_date';
1013: l_custom_rec.attribute_value := TO_CHAR(l_prev_date,'DD/MM/YYYY');
1014: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1015: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1016: x_custom_output.Extend();
1017: x_custom_output(l_bind_ctr) := l_custom_rec;
1018:

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

1011:
1012: l_custom_rec.attribute_name := ':l_prev_date';
1013: l_custom_rec.attribute_value := TO_CHAR(l_prev_date,'DD/MM/YYYY');
1014: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1015: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1016: x_custom_output.Extend();
1017: x_custom_output(l_bind_ctr) := l_custom_rec;
1018:
1019: l_bind_ctr := l_bind_ctr+1;

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

1020:
1021: IF l_prodcat_id IS NOT NULL THEN
1022: l_custom_rec.attribute_name :=':l_prodcat_id';
1023: l_custom_rec.attribute_value :=l_prodcat_id;
1024: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1025: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1026: x_custom_output.Extend();
1027: x_custom_output(l_bind_ctr):=l_custom_rec;
1028:

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

1021: IF l_prodcat_id IS NOT NULL THEN
1022: l_custom_rec.attribute_name :=':l_prodcat_id';
1023: l_custom_rec.attribute_value :=l_prodcat_id;
1024: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1025: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1026: x_custom_output.Extend();
1027: x_custom_output(l_bind_ctr):=l_custom_rec;
1028:
1029: l_bind_ctr:=l_bind_ctr+1;

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

1030: END IF;
1031: IF l_prodcat_id IS NOT NULL THEN
1032: l_custom_rec.attribute_name :=':l_prodcat';
1033: l_custom_rec.attribute_value :=l_prodcat_id;
1034: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1035: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1036: x_custom_output.Extend();
1037: x_custom_output(l_bind_ctr):=l_custom_rec;
1038:

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

1031: IF l_prodcat_id IS NOT NULL THEN
1032: l_custom_rec.attribute_name :=':l_prodcat';
1033: l_custom_rec.attribute_value :=l_prodcat_id;
1034: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1035: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1036: x_custom_output.Extend();
1037: x_custom_output(l_bind_ctr):=l_custom_rec;
1038:
1039: l_bind_ctr:=l_bind_ctr+1;

Line 1160: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

1156:
1157: BEGIN
1158: /* Intializing Variables */
1159: g_pkg := 'bil.patch.115.sql.BIL_BI_TREND_MGMT_RPTS_PKG.';
1160: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
1161: l_parameter_valid := FALSE;
1162: -- l_pipeline_req := TRUE;
1163: l_region_id := 'BIL_BI_FRCST_PIPE_TREND';
1164: l_proc := 'BIL_BI_FRCST_PIPE_TREND.';

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

1917: l_bind_ctr := 1;
1918:
1919: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1920:
1921: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1922: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1923: l_custom_rec.attribute_value := l_viewby;
1924: x_custom_attr.Extend();
1925: x_custom_attr(l_bind_ctr):=l_custom_rec;

Line 1922: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

1918:
1919: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1920:
1921: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1922: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1923: l_custom_rec.attribute_value := l_viewby;
1924: x_custom_attr.Extend();
1925: x_custom_attr(l_bind_ctr):=l_custom_rec;
1926:

Line 1931: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;

1927: l_bind_ctr:=l_bind_ctr+1;
1928:
1929: l_custom_rec.attribute_name :=':curr_prd_start_date';
1930: l_custom_rec.attribute_value := TO_CHAR(l_curr_start_date,'dd/mm/yyyy');
1931: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1932: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1933: x_custom_attr.Extend();
1934: x_custom_attr(l_bind_ctr):=l_custom_rec;
1935:

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

1928:
1929: l_custom_rec.attribute_name :=':curr_prd_start_date';
1930: l_custom_rec.attribute_value := TO_CHAR(l_curr_start_date,'dd/mm/yyyy');
1931: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1932: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1933: x_custom_attr.Extend();
1934: x_custom_attr(l_bind_ctr):=l_custom_rec;
1935:
1936: l_bind_ctr := l_bind_ctr + 1;

Line 1940: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;

1936: l_bind_ctr := l_bind_ctr + 1;
1937:
1938: l_custom_rec.attribute_name :=':l_curr_eff_end_date';
1939: l_custom_rec.attribute_value :=TO_CHAR(l_curr_eff_end_date,'dd/mm/yyyy');
1940: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1941: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1942: x_custom_attr.Extend();
1943: x_custom_attr(l_bind_ctr):=l_custom_rec;
1944:

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

1937:
1938: l_custom_rec.attribute_name :=':l_curr_eff_end_date';
1939: l_custom_rec.attribute_value :=TO_CHAR(l_curr_eff_end_date,'dd/mm/yyyy');
1940: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1941: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1942: x_custom_attr.Extend();
1943: x_custom_attr(l_bind_ctr):=l_custom_rec;
1944:
1945: l_bind_ctr := l_bind_ctr + 1;

Line 1949: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

1945: l_bind_ctr := l_bind_ctr + 1;
1946:
1947: l_custom_rec.attribute_name := ':l_curr_start_date';
1948: l_custom_rec.attribute_value := TO_CHAR(l_curr_start_date,'dd/mm/yyyy');
1949: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1950: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1951: x_custom_attr.Extend();
1952: x_custom_attr(l_bind_ctr):=l_custom_rec;
1953:

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

1946:
1947: l_custom_rec.attribute_name := ':l_curr_start_date';
1948: l_custom_rec.attribute_value := TO_CHAR(l_curr_start_date,'dd/mm/yyyy');
1949: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1950: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1951: x_custom_attr.Extend();
1952: x_custom_attr(l_bind_ctr):=l_custom_rec;
1953:
1954: l_bind_ctr:=l_bind_ctr+1;

Line 1958: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

1954: l_bind_ctr:=l_bind_ctr+1;
1955:
1956: l_custom_rec.attribute_name := ':l_prev_start_date';
1957: l_custom_rec.attribute_value := TO_CHAR(l_prev_start_date,'dd/mm/yyyy');
1958: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1959: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1960: x_custom_attr.Extend();
1961: x_custom_attr(l_bind_ctr):=l_custom_rec;
1962:

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

1955:
1956: l_custom_rec.attribute_name := ':l_prev_start_date';
1957: l_custom_rec.attribute_value := TO_CHAR(l_prev_start_date,'dd/mm/yyyy');
1958: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1959: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1960: x_custom_attr.Extend();
1961: x_custom_attr(l_bind_ctr):=l_custom_rec;
1962:
1963: l_bind_ctr:=l_bind_ctr+1;

Line 1967: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

1963: l_bind_ctr:=l_bind_ctr+1;
1964:
1965: l_custom_rec.attribute_name := ':l_curr_as_of_date';
1966: l_custom_rec.attribute_value := TO_CHAR(l_curr_as_of_date,'dd/mm/yyyy');
1967: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1968: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1969: x_custom_attr.Extend();
1970: x_custom_attr(l_bind_ctr):=l_custom_rec;
1971:

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

1964:
1965: l_custom_rec.attribute_name := ':l_curr_as_of_date';
1966: l_custom_rec.attribute_value := TO_CHAR(l_curr_as_of_date,'dd/mm/yyyy');
1967: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1968: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1969: x_custom_attr.Extend();
1970: x_custom_attr(l_bind_ctr):=l_custom_rec;
1971:
1972: l_bind_ctr:=l_bind_ctr+1;

Line 1976: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

1972: l_bind_ctr:=l_bind_ctr+1;
1973:
1974: l_custom_rec.attribute_name := ':l_snap_date';
1975: l_custom_rec.attribute_value := TO_CHAR(l_snap_date,'dd/mm/yyyy');
1976: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1977: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1978: x_custom_attr.Extend();
1979: x_custom_attr(l_bind_ctr):=l_custom_rec;
1980:

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

1973:
1974: l_custom_rec.attribute_name := ':l_snap_date';
1975: l_custom_rec.attribute_value := TO_CHAR(l_snap_date,'dd/mm/yyyy');
1976: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1977: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1978: x_custom_attr.Extend();
1979: x_custom_attr(l_bind_ctr):=l_custom_rec;
1980:
1981: l_bind_ctr:=l_bind_ctr+1;

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

1981: l_bind_ctr:=l_bind_ctr+1;
1982:
1983: l_custom_rec.attribute_name := ':l_record_type_id';
1984: l_custom_rec.attribute_value := l_record_type_id;
1985: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1986: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1987: x_custom_attr.Extend();
1988: x_custom_attr(l_bind_ctr):=l_custom_rec;
1989:

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

1982:
1983: l_custom_rec.attribute_name := ':l_record_type_id';
1984: l_custom_rec.attribute_value := l_record_type_id;
1985: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1986: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1987: x_custom_attr.Extend();
1988: x_custom_attr(l_bind_ctr):=l_custom_rec;
1989:
1990: l_bind_ctr:=l_bind_ctr+1;

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

1990: l_bind_ctr:=l_bind_ctr+1;
1991:
1992: l_custom_rec.attribute_name :=':l_bitand_id';
1993: l_custom_rec.attribute_value :=l_bitand_id;
1994: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1995: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1996: x_custom_attr.Extend();
1997: x_custom_attr(l_bind_ctr):=l_custom_rec;
1998:

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

1991:
1992: l_custom_rec.attribute_name :=':l_bitand_id';
1993: l_custom_rec.attribute_value :=l_bitand_id;
1994: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1995: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1996: x_custom_attr.Extend();
1997: x_custom_attr(l_bind_ctr):=l_custom_rec;
1998:
1999: l_bind_ctr:=l_bind_ctr+1;

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

2000:
2001:
2002: l_custom_rec.attribute_name :=':l_yes';
2003: l_custom_rec.attribute_value :=l_yes;
2004: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2005: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2006: x_custom_attr.Extend();
2007: x_custom_attr(l_bind_ctr):=l_custom_rec;
2008: l_bind_ctr:=l_bind_ctr+1;

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

2001:
2002: l_custom_rec.attribute_name :=':l_yes';
2003: l_custom_rec.attribute_value :=l_yes;
2004: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2005: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2006: x_custom_attr.Extend();
2007: x_custom_attr(l_bind_ctr):=l_custom_rec;
2008: l_bind_ctr:=l_bind_ctr+1;
2009:

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

2008: l_bind_ctr:=l_bind_ctr+1;
2009:
2010: l_custom_rec.attribute_name :=':l_period_type';
2011: l_custom_rec.attribute_value :=l_period_type;
2012: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2013: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2014: x_custom_attr.Extend();
2015: x_custom_attr(l_bind_ctr):=l_custom_rec;
2016:

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

2009:
2010: l_custom_rec.attribute_name :=':l_period_type';
2011: l_custom_rec.attribute_value :=l_period_type;
2012: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2013: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2014: x_custom_attr.Extend();
2015: x_custom_attr(l_bind_ctr):=l_custom_rec;
2016:
2017: l_bind_ctr:=l_bind_ctr+1;

Line 2021: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

2017: l_bind_ctr:=l_bind_ctr+1;
2018:
2019: l_custom_rec.attribute_name :=':l_sg_id_num';
2020: l_custom_rec.attribute_value := l_sg_id_num;
2021: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
2022: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2023: x_custom_attr.Extend();
2024: x_custom_attr(l_bind_ctr):=l_custom_rec;
2025:

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

2018:
2019: l_custom_rec.attribute_name :=':l_sg_id_num';
2020: l_custom_rec.attribute_value := l_sg_id_num;
2021: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
2022: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2023: x_custom_attr.Extend();
2024: x_custom_attr(l_bind_ctr):=l_custom_rec;
2025:
2026: l_bind_ctr:=l_bind_ctr+1;

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

2028:
2029: if(l_parent_sls_grp_id is not null) then
2030: l_custom_rec.attribute_name :=':l_parent_sls_grp_id';
2031: l_custom_rec.attribute_value :=l_parent_sls_grp_id;
2032: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2033: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2034: x_custom_attr.Extend();
2035: x_custom_attr(l_bind_ctr):=l_custom_rec;
2036: l_bind_ctr:=l_bind_ctr+1;

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

2029: if(l_parent_sls_grp_id is not null) then
2030: l_custom_rec.attribute_name :=':l_parent_sls_grp_id';
2031: l_custom_rec.attribute_value :=l_parent_sls_grp_id;
2032: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2033: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2034: x_custom_attr.Extend();
2035: x_custom_attr(l_bind_ctr):=l_custom_rec;
2036: l_bind_ctr:=l_bind_ctr+1;
2037: end if;

Line 2041: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

2037: end if;
2038:
2039: l_custom_rec.attribute_name := ':l_resource_id';
2040: l_custom_rec.attribute_value := l_resource_id;
2041: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
2042: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2043: x_custom_attr.Extend();
2044: x_custom_attr(l_bind_ctr) := l_custom_rec;
2045:

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

2038:
2039: l_custom_rec.attribute_name := ':l_resource_id';
2040: l_custom_rec.attribute_value := l_resource_id;
2041: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
2042: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2043: x_custom_attr.Extend();
2044: x_custom_attr(l_bind_ctr) := l_custom_rec;
2045:
2046: l_bind_ctr:=l_bind_ctr+1;

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

2046: l_bind_ctr:=l_bind_ctr+1;
2047:
2048: l_custom_rec.attribute_name :=':l_fst_crdt_type';
2049: l_custom_rec.attribute_value :=l_fst_crdt_type;
2050: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2051: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2052: x_custom_attr.Extend();
2053: x_custom_attr(l_bind_ctr):=l_custom_rec;
2054:

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

2047:
2048: l_custom_rec.attribute_name :=':l_fst_crdt_type';
2049: l_custom_rec.attribute_value :=l_fst_crdt_type;
2050: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2051: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2052: x_custom_attr.Extend();
2053: x_custom_attr(l_bind_ctr):=l_custom_rec;
2054:
2055: l_bind_ctr:=l_bind_ctr+1;

Line 2059: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2055: l_bind_ctr:=l_bind_ctr+1;
2056:
2057: l_custom_rec.attribute_name := ':l_prev_snap_date';
2058: l_custom_rec.attribute_value := to_char(l_prev_snap_date,'dd/mm/yyyy');
2059: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2060: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2061: x_custom_attr.Extend();
2062: x_custom_attr(l_bind_ctr):=l_custom_rec;
2063:

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

2056:
2057: l_custom_rec.attribute_name := ':l_prev_snap_date';
2058: l_custom_rec.attribute_value := to_char(l_prev_snap_date,'dd/mm/yyyy');
2059: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2060: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2061: x_custom_attr.Extend();
2062: x_custom_attr(l_bind_ctr):=l_custom_rec;
2063:
2064: l_bind_ctr:=l_bind_ctr+1;

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

2065:
2066: IF l_prodcat IS NOT NULL THEN
2067: l_custom_rec.attribute_name :=':l_prodcat';
2068: l_custom_rec.attribute_value :=l_prodcat;
2069: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2070: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2071: x_custom_attr.Extend();
2072: x_custom_attr(l_bind_ctr):=l_custom_rec;
2073: l_bind_ctr:=l_bind_ctr+1;

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

2066: IF l_prodcat IS NOT NULL THEN
2067: l_custom_rec.attribute_name :=':l_prodcat';
2068: l_custom_rec.attribute_value :=l_prodcat;
2069: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2070: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2071: x_custom_attr.Extend();
2072: x_custom_attr(l_bind_ctr):=l_custom_rec;
2073: l_bind_ctr:=l_bind_ctr+1;
2074: END IF;

Line 2203: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

2199: END IF;
2200:
2201:
2202: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
2203: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
2204:
2205: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl =>p_page_parameter_tbl,
2206: p_region_id =>l_region_id,
2207: x_period_type =>l_period_type,

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

2577: END IF;
2578:
2579: /* Bind parameters */
2580: l_bind_ctr:=1;
2581: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
2582: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
2583: l_custom_rec.attribute_value := l_viewby;
2584: x_custom_attr.Extend();
2585: x_custom_attr(l_bind_ctr) := l_custom_rec;

Line 2582: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

2578:
2579: /* Bind parameters */
2580: l_bind_ctr:=1;
2581: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
2582: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
2583: l_custom_rec.attribute_value := l_viewby;
2584: x_custom_attr.Extend();
2585: x_custom_attr(l_bind_ctr) := l_custom_rec;
2586: l_bind_ctr := l_bind_ctr+1;

Line 2590: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

2586: l_bind_ctr := l_bind_ctr+1;
2587:
2588: l_custom_rec.attribute_name := ':l_curr_page_time_id';
2589: l_custom_rec.attribute_value := l_curr_page_time_id;
2590: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
2591: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2592: x_custom_attr.Extend();
2593: x_custom_attr(l_bind_ctr) := l_custom_rec;
2594: l_bind_ctr := l_bind_ctr+1;

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

2587:
2588: l_custom_rec.attribute_name := ':l_curr_page_time_id';
2589: l_custom_rec.attribute_value := l_curr_page_time_id;
2590: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
2591: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2592: x_custom_attr.Extend();
2593: x_custom_attr(l_bind_ctr) := l_custom_rec;
2594: l_bind_ctr := l_bind_ctr+1;
2595:

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

2594: l_bind_ctr := l_bind_ctr+1;
2595:
2596: l_custom_rec.attribute_name :=':l_yes';
2597: l_custom_rec.attribute_value :=l_yes;
2598: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2599: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2600: x_custom_attr.Extend();
2601: x_custom_attr(l_bind_ctr):=l_custom_rec;
2602: l_bind_ctr:=l_bind_ctr+1;

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

2595:
2596: l_custom_rec.attribute_name :=':l_yes';
2597: l_custom_rec.attribute_value :=l_yes;
2598: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2599: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2600: x_custom_attr.Extend();
2601: x_custom_attr(l_bind_ctr):=l_custom_rec;
2602: l_bind_ctr:=l_bind_ctr+1;
2603:

Line 2606: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2602: l_bind_ctr:=l_bind_ctr+1;
2603:
2604: l_custom_rec.attribute_name := ':l_snapshot_date';
2605: l_custom_rec.attribute_value := TO_CHAR(l_snapshot_date,'DD/MM/YYYY');
2606: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2607: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2608: x_custom_attr.Extend();
2609: x_custom_attr(l_bind_ctr) := l_custom_rec;
2610: l_bind_ctr := l_bind_ctr+1;

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

2603:
2604: l_custom_rec.attribute_name := ':l_snapshot_date';
2605: l_custom_rec.attribute_value := TO_CHAR(l_snapshot_date,'DD/MM/YYYY');
2606: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2607: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2608: x_custom_attr.Extend();
2609: x_custom_attr(l_bind_ctr) := l_custom_rec;
2610: l_bind_ctr := l_bind_ctr+1;
2611:

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

2610: l_bind_ctr := l_bind_ctr+1;
2611:
2612: l_custom_rec.attribute_name :=':l_sg_id';
2613: l_custom_rec.attribute_value := l_sg_id;
2614: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2615: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2616: x_custom_attr.Extend();
2617: x_custom_attr(l_bind_ctr) := l_custom_rec;
2618: l_bind_ctr := l_bind_ctr+1;

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

2611:
2612: l_custom_rec.attribute_name :=':l_sg_id';
2613: l_custom_rec.attribute_value := l_sg_id;
2614: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2615: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2616: x_custom_attr.Extend();
2617: x_custom_attr(l_bind_ctr) := l_custom_rec;
2618: l_bind_ctr := l_bind_ctr+1;
2619:

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

2618: l_bind_ctr := l_bind_ctr+1;
2619:
2620: l_custom_rec.attribute_name := ':l_resource_id';
2621: l_custom_rec.attribute_value := l_resource_id;
2622: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2623: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2624: x_custom_attr.Extend();
2625: x_custom_attr(l_bind_ctr) := l_custom_rec;
2626: l_bind_ctr := l_bind_ctr+1;

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

2619:
2620: l_custom_rec.attribute_name := ':l_resource_id';
2621: l_custom_rec.attribute_value := l_resource_id;
2622: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2623: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2624: x_custom_attr.Extend();
2625: x_custom_attr(l_bind_ctr) := l_custom_rec;
2626: l_bind_ctr := l_bind_ctr+1;
2627:

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

2626: l_bind_ctr := l_bind_ctr+1;
2627:
2628: l_custom_rec.attribute_name := ':l_record_type_id';
2629: l_custom_rec.attribute_value := l_record_type_id;
2630: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2631: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2632: x_custom_attr.Extend();
2633: x_custom_attr(l_bind_ctr) := l_custom_rec;
2634: l_bind_ctr := l_bind_ctr+1;

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

2627:
2628: l_custom_rec.attribute_name := ':l_record_type_id';
2629: l_custom_rec.attribute_value := l_record_type_id;
2630: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2631: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2632: x_custom_attr.Extend();
2633: x_custom_attr(l_bind_ctr) := l_custom_rec;
2634: l_bind_ctr := l_bind_ctr+1;
2635:

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

2634: l_bind_ctr := l_bind_ctr+1;
2635:
2636: l_custom_rec.attribute_name := ':l_bitand_id';
2637: l_custom_rec.attribute_value := l_bitand_id;
2638: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2639: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2640: x_custom_attr.Extend();
2641: x_custom_attr(l_bind_ctr) := l_custom_rec;
2642: l_bind_ctr := l_bind_ctr+1;

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

2635:
2636: l_custom_rec.attribute_name := ':l_bitand_id';
2637: l_custom_rec.attribute_value := l_bitand_id;
2638: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2639: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2640: x_custom_attr.Extend();
2641: x_custom_attr(l_bind_ctr) := l_custom_rec;
2642: l_bind_ctr := l_bind_ctr+1;
2643:

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

2642: l_bind_ctr := l_bind_ctr+1;
2643:
2644: l_custom_rec.attribute_name := ':l_period_type';
2645: l_custom_rec.attribute_value := l_period_type;
2646: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2647: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2648: x_custom_attr.Extend();
2649: x_custom_attr(l_bind_ctr) := l_custom_rec;
2650: l_bind_ctr := l_bind_ctr+1;

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

2643:
2644: l_custom_rec.attribute_name := ':l_period_type';
2645: l_custom_rec.attribute_value := l_period_type;
2646: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2647: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2648: x_custom_attr.Extend();
2649: x_custom_attr(l_bind_ctr) := l_custom_rec;
2650: l_bind_ctr := l_bind_ctr+1;
2651:

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

2651:
2652: IF(l_prodcat IS NOT NULL) THEN
2653: l_custom_rec.attribute_name := ':l_prodcat';
2654: l_custom_rec.attribute_value := l_prodcat;
2655: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2656: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2657: x_custom_attr.Extend();
2658: x_custom_attr(l_bind_ctr) := l_custom_rec;
2659: l_bind_ctr := l_bind_ctr+1;

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

2652: IF(l_prodcat IS NOT NULL) THEN
2653: l_custom_rec.attribute_name := ':l_prodcat';
2654: l_custom_rec.attribute_value := l_prodcat;
2655: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2656: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2657: x_custom_attr.Extend();
2658: x_custom_attr(l_bind_ctr) := l_custom_rec;
2659: l_bind_ctr := l_bind_ctr+1;
2660: END IF;

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

2660: END IF;
2661:
2662: l_custom_rec.attribute_name := ':l_fst_crdt_type';
2663: l_custom_rec.attribute_value := l_fst_crdt_type;
2664: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2665: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2666: x_custom_attr.Extend();
2667: x_custom_attr(l_bind_ctr) := l_custom_rec;
2668: l_bind_ctr := l_bind_ctr+1;

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

2661:
2662: l_custom_rec.attribute_name := ':l_fst_crdt_type';
2663: l_custom_rec.attribute_value := l_fst_crdt_type;
2664: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2665: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2666: x_custom_attr.Extend();
2667: x_custom_attr(l_bind_ctr) := l_custom_rec;
2668: l_bind_ctr := l_bind_ctr+1;
2669:

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

2668: l_bind_ctr := l_bind_ctr+1;
2669:
2670: l_custom_rec.attribute_name := ':l_page_period_type';
2671: l_custom_rec.attribute_value := l_page_period_type;
2672: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2673: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2674: x_custom_attr.Extend();
2675: x_custom_attr(l_bind_ctr) := l_custom_rec;
2676: l_bind_ctr := l_bind_ctr+1;

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

2669:
2670: l_custom_rec.attribute_name := ':l_page_period_type';
2671: l_custom_rec.attribute_value := l_page_period_type;
2672: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2673: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2674: x_custom_attr.Extend();
2675: x_custom_attr(l_bind_ctr) := l_custom_rec;
2676: l_bind_ctr := l_bind_ctr+1;
2677:

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

2677:
2678: if(l_parent_sls_grp_id is not null) then
2679: l_custom_rec.attribute_name :=':l_parent_sls_grp_id';
2680: l_custom_rec.attribute_value :=l_parent_sls_grp_id;
2681: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2682: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2683: x_custom_attr.Extend();
2684: x_custom_attr(l_bind_ctr):=l_custom_rec;
2685: l_bind_ctr:=l_bind_ctr+1;

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

2678: if(l_parent_sls_grp_id is not null) then
2679: l_custom_rec.attribute_name :=':l_parent_sls_grp_id';
2680: l_custom_rec.attribute_value :=l_parent_sls_grp_id;
2681: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2682: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2683: x_custom_attr.Extend();
2684: x_custom_attr(l_bind_ctr):=l_custom_rec;
2685: l_bind_ctr:=l_bind_ctr+1;
2686: end if;

Line 2818: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

2814: END IF;
2815:
2816:
2817: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
2818: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
2819:
2820:
2821: BIL_BI_UTIL_PKG.GET_OTHER_PROFILES(x_DebugMode => l_DebugMode);
2822:

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

3073:
3074: /* Bind parameters */
3075: l_bind_ctr:=1;
3076:
3077: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
3078: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
3079: l_custom_rec.attribute_value :=l_viewby;
3080: x_custom_attr.Extend();
3081: x_custom_attr(l_bind_ctr):=l_custom_rec;

Line 3078: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

3074: /* Bind parameters */
3075: l_bind_ctr:=1;
3076:
3077: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
3078: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
3079: l_custom_rec.attribute_value :=l_viewby;
3080: x_custom_attr.Extend();
3081: x_custom_attr(l_bind_ctr):=l_custom_rec;
3082: l_bind_ctr:=l_bind_ctr+1;

Line 3086: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;

3082: l_bind_ctr:=l_bind_ctr+1;
3083:
3084: l_custom_rec.attribute_name :=':l_curr_start_date';
3085: l_custom_rec.attribute_value :=to_char(l_curr_start_date,'dd/mm/yyyy');
3086: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3087: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3088: x_custom_attr.Extend();
3089: x_custom_attr(l_bind_ctr):=l_custom_rec;
3090: l_bind_ctr:=l_bind_ctr+1;

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

3083:
3084: l_custom_rec.attribute_name :=':l_curr_start_date';
3085: l_custom_rec.attribute_value :=to_char(l_curr_start_date,'dd/mm/yyyy');
3086: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3087: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3088: x_custom_attr.Extend();
3089: x_custom_attr(l_bind_ctr):=l_custom_rec;
3090: l_bind_ctr:=l_bind_ctr+1;
3091:

Line 3094: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;

3090: l_bind_ctr:=l_bind_ctr+1;
3091:
3092: l_custom_rec.attribute_name :=':l_curr_as_of_date';
3093: l_custom_rec.attribute_value :=to_char(l_curr_as_of_date,'dd/mm/yyyy');
3094: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3095: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3096: x_custom_attr.Extend();
3097: x_custom_attr(l_bind_ctr):=l_custom_rec;
3098: l_bind_ctr:=l_bind_ctr+1;

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

3091:
3092: l_custom_rec.attribute_name :=':l_curr_as_of_date';
3093: l_custom_rec.attribute_value :=to_char(l_curr_as_of_date,'dd/mm/yyyy');
3094: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3095: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3096: x_custom_attr.Extend();
3097: x_custom_attr(l_bind_ctr):=l_custom_rec;
3098: l_bind_ctr:=l_bind_ctr+1;
3099:

Line 3102: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;

3098: l_bind_ctr:=l_bind_ctr+1;
3099:
3100: l_custom_rec.attribute_name :=':l_curr_eff_end_date';
3101: l_custom_rec.attribute_value :=to_char(l_curr_eff_end_date,'dd/mm/yyyy');
3102: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3103: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3104: x_custom_attr.Extend();
3105: x_custom_attr(l_bind_ctr):=l_custom_rec;
3106: l_bind_ctr:=l_bind_ctr+1;

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

3099:
3100: l_custom_rec.attribute_name :=':l_curr_eff_end_date';
3101: l_custom_rec.attribute_value :=to_char(l_curr_eff_end_date,'dd/mm/yyyy');
3102: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3103: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3104: x_custom_attr.Extend();
3105: x_custom_attr(l_bind_ctr):=l_custom_rec;
3106: l_bind_ctr:=l_bind_ctr+1;
3107:

Line 3110: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;

3106: l_bind_ctr:=l_bind_ctr+1;
3107:
3108: l_custom_rec.attribute_name :=':l_prev_eff_end_date';
3109: l_custom_rec.attribute_value :=to_char(l_prev_eff_end_date,'dd/mm/yyyy');
3110: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3111: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3112: x_custom_attr.Extend();
3113: x_custom_attr(l_bind_ctr):=l_custom_rec;
3114: l_bind_ctr:=l_bind_ctr+1;

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

3107:
3108: l_custom_rec.attribute_name :=':l_prev_eff_end_date';
3109: l_custom_rec.attribute_value :=to_char(l_prev_eff_end_date,'dd/mm/yyyy');
3110: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3111: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3112: x_custom_attr.Extend();
3113: x_custom_attr(l_bind_ctr):=l_custom_rec;
3114: l_bind_ctr:=l_bind_ctr+1;
3115:

Line 3118: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;

3114: l_bind_ctr:=l_bind_ctr+1;
3115:
3116: l_custom_rec.attribute_name :=':l_snapshot_date';
3117: l_custom_rec.attribute_value :=to_char(l_snapshot_date,'dd/mm/yyyy');
3118: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3119: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3120: x_custom_attr.Extend();
3121: x_custom_attr(l_bind_ctr):=l_custom_rec;
3122: l_bind_ctr:=l_bind_ctr+1;

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

3115:
3116: l_custom_rec.attribute_name :=':l_snapshot_date';
3117: l_custom_rec.attribute_value :=to_char(l_snapshot_date,'dd/mm/yyyy');
3118: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3119: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3120: x_custom_attr.Extend();
3121: x_custom_attr(l_bind_ctr):=l_custom_rec;
3122: l_bind_ctr:=l_bind_ctr+1;
3123:

Line 3126: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;

3122: l_bind_ctr:=l_bind_ctr+1;
3123:
3124: l_custom_rec.attribute_name :=':l_prev_snap_date';
3125: l_custom_rec.attribute_value :=to_char(l_prev_snap_date,'dd/mm/yyyy');
3126: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3127: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3128: x_custom_attr.Extend();
3129: x_custom_attr(l_bind_ctr):=l_custom_rec;
3130: l_bind_ctr:=l_bind_ctr+1;

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

3123:
3124: l_custom_rec.attribute_name :=':l_prev_snap_date';
3125: l_custom_rec.attribute_value :=to_char(l_prev_snap_date,'dd/mm/yyyy');
3126: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3127: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3128: x_custom_attr.Extend();
3129: x_custom_attr(l_bind_ctr):=l_custom_rec;
3130: l_bind_ctr:=l_bind_ctr+1;
3131:

Line 3134: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

3130: l_bind_ctr:=l_bind_ctr+1;
3131:
3132: l_custom_rec.attribute_name :=':l_curr_page_time_id';
3133: l_custom_rec.attribute_value :=l_curr_page_time_id;
3134: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
3135: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3136: x_custom_attr.Extend();
3137: x_custom_attr(l_bind_ctr):=l_custom_rec;
3138: l_bind_ctr:=l_bind_ctr+1;

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

3131:
3132: l_custom_rec.attribute_name :=':l_curr_page_time_id';
3133: l_custom_rec.attribute_value :=l_curr_page_time_id;
3134: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
3135: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3136: x_custom_attr.Extend();
3137: x_custom_attr(l_bind_ctr):=l_custom_rec;
3138: l_bind_ctr:=l_bind_ctr+1;
3139:

Line 3142: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

3138: l_bind_ctr:=l_bind_ctr+1;
3139:
3140: l_custom_rec.attribute_name :=':l_prev_page_time_id';
3141: l_custom_rec.attribute_value :=l_prev_page_time_id;
3142: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
3143: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3144: x_custom_attr.Extend();
3145: x_custom_attr(l_bind_ctr):=l_custom_rec;
3146: l_bind_ctr:=l_bind_ctr+1;

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

3139:
3140: l_custom_rec.attribute_name :=':l_prev_page_time_id';
3141: l_custom_rec.attribute_value :=l_prev_page_time_id;
3142: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
3143: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3144: x_custom_attr.Extend();
3145: x_custom_attr(l_bind_ctr):=l_custom_rec;
3146: l_bind_ctr:=l_bind_ctr+1;
3147:

Line 3150: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;

3146: l_bind_ctr:=l_bind_ctr+1;
3147:
3148: l_custom_rec.attribute_name :=':l_prev_start_date';
3149: l_custom_rec.attribute_value :=to_char(l_prev_start_date,'dd/mm/yyyy');
3150: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3151: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3152: x_custom_attr.Extend();
3153: x_custom_attr(l_bind_ctr):=l_custom_rec;
3154: l_bind_ctr:=l_bind_ctr+1;

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

3147:
3148: l_custom_rec.attribute_name :=':l_prev_start_date';
3149: l_custom_rec.attribute_value :=to_char(l_prev_start_date,'dd/mm/yyyy');
3150: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3151: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3152: x_custom_attr.Extend();
3153: x_custom_attr(l_bind_ctr):=l_custom_rec;
3154: l_bind_ctr:=l_bind_ctr+1;
3155:

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

3154: l_bind_ctr:=l_bind_ctr+1;
3155:
3156: l_custom_rec.attribute_name :=':l_calendar_id';
3157: l_custom_rec.attribute_value :=l_calendar_id;
3158: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3159: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3160: x_custom_attr.Extend();
3161: x_custom_attr(l_bind_ctr):=l_custom_rec;
3162: l_bind_ctr:=l_bind_ctr+1;

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

3155:
3156: l_custom_rec.attribute_name :=':l_calendar_id';
3157: l_custom_rec.attribute_value :=l_calendar_id;
3158: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3159: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3160: x_custom_attr.Extend();
3161: x_custom_attr(l_bind_ctr):=l_custom_rec;
3162: l_bind_ctr:=l_bind_ctr+1;
3163:

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

3162: l_bind_ctr:=l_bind_ctr+1;
3163:
3164: l_custom_rec.attribute_name :=':l_sg_id';
3165: l_custom_rec.attribute_value :=l_sg_id;
3166: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3167: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3168: x_custom_attr.Extend();
3169: x_custom_attr(l_bind_ctr):=l_custom_rec;
3170: l_bind_ctr:=l_bind_ctr+1;

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

3163:
3164: l_custom_rec.attribute_name :=':l_sg_id';
3165: l_custom_rec.attribute_value :=l_sg_id;
3166: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3167: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3168: x_custom_attr.Extend();
3169: x_custom_attr(l_bind_ctr):=l_custom_rec;
3170: l_bind_ctr:=l_bind_ctr+1;
3171:

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

3170: l_bind_ctr:=l_bind_ctr+1;
3171:
3172: l_custom_rec.attribute_name :=':l_psg_id';
3173: l_custom_rec.attribute_value :=l_psg_id;
3174: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3175: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3176: x_custom_attr.Extend();
3177: x_custom_attr(l_bind_ctr):=l_custom_rec;
3178: l_bind_ctr:=l_bind_ctr+1;

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

3171:
3172: l_custom_rec.attribute_name :=':l_psg_id';
3173: l_custom_rec.attribute_value :=l_psg_id;
3174: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3175: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3176: x_custom_attr.Extend();
3177: x_custom_attr(l_bind_ctr):=l_custom_rec;
3178: l_bind_ctr:=l_bind_ctr+1;
3179:

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

3180:
3181: if(l_resource_id is not null) then
3182: l_custom_rec.attribute_name :=':l_resource_id';
3183: l_custom_rec.attribute_value :=l_resource_id;
3184: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3185: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3186: x_custom_attr.Extend();
3187: x_custom_attr(l_bind_ctr):=l_custom_rec;
3188: l_bind_ctr:=l_bind_ctr+1;

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

3181: if(l_resource_id is not null) then
3182: l_custom_rec.attribute_name :=':l_resource_id';
3183: l_custom_rec.attribute_value :=l_resource_id;
3184: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3185: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3186: x_custom_attr.Extend();
3187: x_custom_attr(l_bind_ctr):=l_custom_rec;
3188: l_bind_ctr:=l_bind_ctr+1;
3189: end if;

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

3189: end if;
3190:
3191: l_custom_rec.attribute_name :=':l_bitand_id';
3192: l_custom_rec.attribute_value :=l_bitand_id;
3193: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3194: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3195: x_custom_attr.Extend();
3196: x_custom_attr(l_bind_ctr):=l_custom_rec;
3197: l_bind_ctr:=l_bind_ctr+1;

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

3190:
3191: l_custom_rec.attribute_name :=':l_bitand_id';
3192: l_custom_rec.attribute_value :=l_bitand_id;
3193: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3194: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3195: x_custom_attr.Extend();
3196: x_custom_attr(l_bind_ctr):=l_custom_rec;
3197: l_bind_ctr:=l_bind_ctr+1;
3198:

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

3197: l_bind_ctr:=l_bind_ctr+1;
3198:
3199: l_custom_rec.attribute_name :=':l_period_type';
3200: l_custom_rec.attribute_value :=l_period_type;
3201: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3202: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3203: x_custom_attr.Extend();
3204: x_custom_attr(l_bind_ctr):=l_custom_rec;
3205: l_bind_ctr:=l_bind_ctr+1;

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

3198:
3199: l_custom_rec.attribute_name :=':l_period_type';
3200: l_custom_rec.attribute_value :=l_period_type;
3201: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3202: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3203: x_custom_attr.Extend();
3204: x_custom_attr(l_bind_ctr):=l_custom_rec;
3205: l_bind_ctr:=l_bind_ctr+1;
3206:

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

3206:
3207: IF(l_productcat_id IS NOT NULL) THEN
3208: l_custom_rec.attribute_name :=':l_productcat_id';
3209: l_custom_rec.attribute_value :=l_productcat_id;
3210: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3211: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3212: x_custom_attr.Extend();
3213: x_custom_attr(l_bind_ctr):=l_custom_rec;
3214: l_bind_ctr:=l_bind_ctr+1;

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

3207: IF(l_productcat_id IS NOT NULL) THEN
3208: l_custom_rec.attribute_name :=':l_productcat_id';
3209: l_custom_rec.attribute_value :=l_productcat_id;
3210: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3211: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3212: x_custom_attr.Extend();
3213: x_custom_attr(l_bind_ctr):=l_custom_rec;
3214: l_bind_ctr:=l_bind_ctr+1;
3215: END IF;

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

3216:
3217: IF(l_productcat_id IS NOT NULL) THEN
3218: l_custom_rec.attribute_name :=':l_prodcat';
3219: l_custom_rec.attribute_value :=l_productcat_id;
3220: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3221: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3222: x_custom_attr.Extend();
3223: x_custom_attr(l_bind_ctr):=l_custom_rec;
3224: l_bind_ctr:=l_bind_ctr+1;

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

3217: IF(l_productcat_id IS NOT NULL) THEN
3218: l_custom_rec.attribute_name :=':l_prodcat';
3219: l_custom_rec.attribute_value :=l_productcat_id;
3220: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3221: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3222: x_custom_attr.Extend();
3223: x_custom_attr(l_bind_ctr):=l_custom_rec;
3224: l_bind_ctr:=l_bind_ctr+1;
3225: END IF;

Line 3356: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

3352:
3353: END IF;
3354:
3355: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
3356: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
3357:
3358: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl =>p_page_parameter_tbl,
3359: p_region_id =>l_region_id,
3360: x_period_type =>l_period_type,

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

3659:
3660: /* Bind parameters */
3661: l_bind_ctr:=1;
3662:
3663: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
3664: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
3665: l_custom_rec.attribute_value :=l_viewby;
3666: x_custom_attr.Extend();
3667: x_custom_attr(l_bind_ctr):=l_custom_rec;

Line 3664: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

3660: /* Bind parameters */
3661: l_bind_ctr:=1;
3662:
3663: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
3664: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
3665: l_custom_rec.attribute_value :=l_viewby;
3666: x_custom_attr.Extend();
3667: x_custom_attr(l_bind_ctr):=l_custom_rec;
3668: l_bind_ctr:=l_bind_ctr+1;

Line 3672: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;

3668: l_bind_ctr:=l_bind_ctr+1;
3669:
3670: l_custom_rec.attribute_name :=':l_curr_start_date';
3671: l_custom_rec.attribute_value :=to_char(l_curr_start_date,'dd/mm/yyyy');
3672: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3673: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3674: x_custom_attr.Extend();
3675: x_custom_attr(l_bind_ctr):=l_custom_rec;
3676: l_bind_ctr:=l_bind_ctr+1;

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

3669:
3670: l_custom_rec.attribute_name :=':l_curr_start_date';
3671: l_custom_rec.attribute_value :=to_char(l_curr_start_date,'dd/mm/yyyy');
3672: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3673: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3674: x_custom_attr.Extend();
3675: x_custom_attr(l_bind_ctr):=l_custom_rec;
3676: l_bind_ctr:=l_bind_ctr+1;
3677:

Line 3680: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;

3676: l_bind_ctr:=l_bind_ctr+1;
3677:
3678: l_custom_rec.attribute_name :=':l_curr_eff_end_date';
3679: l_custom_rec.attribute_value :=to_char(l_curr_eff_end_date,'dd/mm/yyyy');
3680: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3681: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3682: x_custom_attr.Extend();
3683: x_custom_attr(l_bind_ctr):=l_custom_rec;
3684: l_bind_ctr:=l_bind_ctr+1;

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

3677:
3678: l_custom_rec.attribute_name :=':l_curr_eff_end_date';
3679: l_custom_rec.attribute_value :=to_char(l_curr_eff_end_date,'dd/mm/yyyy');
3680: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3681: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3682: x_custom_attr.Extend();
3683: x_custom_attr(l_bind_ctr):=l_custom_rec;
3684: l_bind_ctr:=l_bind_ctr+1;
3685:

Line 3688: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

3684: l_bind_ctr:=l_bind_ctr+1;
3685:
3686: l_custom_rec.attribute_name :=':l_record_type_id';
3687: l_custom_rec.attribute_value :=l_record_type_id;
3688: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
3689: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3690: x_custom_attr.Extend();
3691: x_custom_attr(l_bind_ctr):=l_custom_rec;
3692: l_bind_ctr:=l_bind_ctr+1;

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

3685:
3686: l_custom_rec.attribute_name :=':l_record_type_id';
3687: l_custom_rec.attribute_value :=l_record_type_id;
3688: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
3689: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3690: x_custom_attr.Extend();
3691: x_custom_attr(l_bind_ctr):=l_custom_rec;
3692: l_bind_ctr:=l_bind_ctr+1;
3693:

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

3693:
3694:
3695: l_custom_rec.attribute_name :=':l_yes';
3696: l_custom_rec.attribute_value :=l_yes;
3697: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3698: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3699: x_custom_attr.Extend();
3700: x_custom_attr(l_bind_ctr):=l_custom_rec;
3701: l_bind_ctr:=l_bind_ctr+1;

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

3694:
3695: l_custom_rec.attribute_name :=':l_yes';
3696: l_custom_rec.attribute_value :=l_yes;
3697: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3698: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3699: x_custom_attr.Extend();
3700: x_custom_attr(l_bind_ctr):=l_custom_rec;
3701: l_bind_ctr:=l_bind_ctr+1;
3702:

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

3701: l_bind_ctr:=l_bind_ctr+1;
3702:
3703: l_custom_rec.attribute_name :=':l_sg_id';
3704: l_custom_rec.attribute_value :=l_sg_id;
3705: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3706: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3707: x_custom_attr.Extend();
3708: x_custom_attr(l_bind_ctr):=l_custom_rec;
3709: l_bind_ctr:=l_bind_ctr+1;

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

3702:
3703: l_custom_rec.attribute_name :=':l_sg_id';
3704: l_custom_rec.attribute_value :=l_sg_id;
3705: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3706: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3707: x_custom_attr.Extend();
3708: x_custom_attr(l_bind_ctr):=l_custom_rec;
3709: l_bind_ctr:=l_bind_ctr+1;
3710:

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

3710:
3711: IF(l_resource_id is not null) THEN
3712: l_custom_rec.attribute_name :=':l_resource_id';
3713: l_custom_rec.attribute_value :=l_resource_id;
3714: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3715: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3716: x_custom_attr.Extend();
3717: x_custom_attr(l_bind_ctr):=l_custom_rec;
3718: l_bind_ctr:=l_bind_ctr+1;

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

3711: IF(l_resource_id is not null) THEN
3712: l_custom_rec.attribute_name :=':l_resource_id';
3713: l_custom_rec.attribute_value :=l_resource_id;
3714: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3715: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3716: x_custom_attr.Extend();
3717: x_custom_attr(l_bind_ctr):=l_custom_rec;
3718: l_bind_ctr:=l_bind_ctr+1;
3719: END IF;

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

3720:
3721: if(l_parent_sls_grp_id is not null) then
3722: l_custom_rec.attribute_name :=':l_parent_sls_grp_id';
3723: l_custom_rec.attribute_value :=l_parent_sls_grp_id;
3724: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3725: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3726: x_custom_attr.Extend();
3727: x_custom_attr(l_bind_ctr):=l_custom_rec;
3728: l_bind_ctr:=l_bind_ctr+1;

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

3721: if(l_parent_sls_grp_id is not null) then
3722: l_custom_rec.attribute_name :=':l_parent_sls_grp_id';
3723: l_custom_rec.attribute_value :=l_parent_sls_grp_id;
3724: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3725: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3726: x_custom_attr.Extend();
3727: x_custom_attr(l_bind_ctr):=l_custom_rec;
3728: l_bind_ctr:=l_bind_ctr+1;
3729: end if;

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

3734:
3735: IF(l_productcat_id IS NOT NULL) THEN
3736: l_custom_rec.attribute_name :=':l_productcat_id';
3737: l_custom_rec.attribute_value :=l_productcat_id;
3738: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3739: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3740: x_custom_attr.Extend();
3741: x_custom_attr(l_bind_ctr):=l_custom_rec;
3742: l_bind_ctr:=l_bind_ctr+1;

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

3735: IF(l_productcat_id IS NOT NULL) THEN
3736: l_custom_rec.attribute_name :=':l_productcat_id';
3737: l_custom_rec.attribute_value :=l_productcat_id;
3738: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3739: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3740: x_custom_attr.Extend();
3741: x_custom_attr(l_bind_ctr):=l_custom_rec;
3742: l_bind_ctr:=l_bind_ctr+1;
3743: END IF;

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

3744:
3745: IF(l_productcat_id IS NOT NULL) THEN
3746: l_custom_rec.attribute_name :=':l_prodcat';
3747: l_custom_rec.attribute_value :=l_productcat_id;
3748: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3749: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3750: x_custom_attr.Extend();
3751: x_custom_attr(l_bind_ctr):=l_custom_rec;
3752: l_bind_ctr:=l_bind_ctr+1;

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

3745: IF(l_productcat_id IS NOT NULL) THEN
3746: l_custom_rec.attribute_name :=':l_prodcat';
3747: l_custom_rec.attribute_value :=l_productcat_id;
3748: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3749: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3750: x_custom_attr.Extend();
3751: x_custom_attr(l_bind_ctr):=l_custom_rec;
3752: l_bind_ctr:=l_bind_ctr+1;
3753: END IF;

Line 3759: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;

3755: /* LATEST SNAPSHOT IMPLEMENTATION */
3756:
3757: l_custom_rec.attribute_name :=':l_snapshot_date';
3758: l_custom_rec.attribute_value :=to_char(l_snapshot_date,'dd/mm/yyyy');
3759: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3760: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3761: x_custom_attr.Extend();
3762: x_custom_attr(l_bind_ctr):=l_custom_rec;
3763: l_bind_ctr:=l_bind_ctr+1;

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

3756:
3757: l_custom_rec.attribute_name :=':l_snapshot_date';
3758: l_custom_rec.attribute_value :=to_char(l_snapshot_date,'dd/mm/yyyy');
3759: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3760: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3761: x_custom_attr.Extend();
3762: x_custom_attr(l_bind_ctr):=l_custom_rec;
3763: l_bind_ctr:=l_bind_ctr+1;
3764:

Line 3895: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

3891: END IF;
3892:
3893:
3894: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
3895: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
3896:
3897:
3898: BIL_BI_UTIL_PKG.GET_OTHER_PROFILES(x_DebugMode => l_DebugMode);
3899:

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

4276:
4277: /* Bind parameters */
4278: l_bind_ctr:=1;
4279:
4280: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
4281: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
4282: l_custom_rec.attribute_value := l_viewby;
4283: x_custom_attr.Extend();
4284: x_custom_attr(l_bind_ctr):=l_custom_rec;

Line 4281: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

4277: /* Bind parameters */
4278: l_bind_ctr:=1;
4279:
4280: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
4281: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
4282: l_custom_rec.attribute_value := l_viewby;
4283: x_custom_attr.Extend();
4284: x_custom_attr(l_bind_ctr):=l_custom_rec;
4285: l_bind_ctr:=l_bind_ctr+1;

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

4285: l_bind_ctr:=l_bind_ctr+1;
4286:
4287: /* l_custom_rec.attribute_name :=':l_no_comp_period';
4288: l_custom_rec.attribute_value :=l_no_comp_period;
4289: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4290: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4291: x_custom_attr.Extend();
4292: x_custom_attr(l_bind_ctr):=l_custom_rec;
4293: l_bind_ctr:=l_bind_ctr+1;*/

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

4286:
4287: /* l_custom_rec.attribute_name :=':l_no_comp_period';
4288: l_custom_rec.attribute_value :=l_no_comp_period;
4289: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4290: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4291: x_custom_attr.Extend();
4292: x_custom_attr(l_bind_ctr):=l_custom_rec;
4293: l_bind_ctr:=l_bind_ctr+1;*/
4294:

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

4293: l_bind_ctr:=l_bind_ctr+1;*/
4294:
4295: l_custom_rec.attribute_name :=':l_yes';
4296: l_custom_rec.attribute_value :=l_yes;
4297: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4298: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4299: x_custom_attr.Extend();
4300: x_custom_attr(l_bind_ctr):=l_custom_rec;
4301: l_bind_ctr:=l_bind_ctr+1;

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

4294:
4295: l_custom_rec.attribute_name :=':l_yes';
4296: l_custom_rec.attribute_value :=l_yes;
4297: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4298: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4299: x_custom_attr.Extend();
4300: x_custom_attr(l_bind_ctr):=l_custom_rec;
4301: l_bind_ctr:=l_bind_ctr+1;
4302:

Line 4306: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.DATE_BIND;

4302:
4303:
4304: l_custom_rec.attribute_name :=':l_curr_as_of_date';
4305: l_custom_rec.attribute_value :=TO_CHAR(l_curr_as_of_date,'DD/MM/YYYY');
4306: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
4307: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4308: x_custom_attr.Extend();
4309: x_custom_attr(l_bind_ctr):=l_custom_rec;
4310: l_bind_ctr:=l_bind_ctr+1;

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

4303:
4304: l_custom_rec.attribute_name :=':l_curr_as_of_date';
4305: l_custom_rec.attribute_value :=TO_CHAR(l_curr_as_of_date,'DD/MM/YYYY');
4306: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.DATE_BIND;
4307: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4308: x_custom_attr.Extend();
4309: x_custom_attr(l_bind_ctr):=l_custom_rec;
4310: l_bind_ctr:=l_bind_ctr+1;
4311:

Line 4314: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

4310: l_bind_ctr:=l_bind_ctr+1;
4311:
4312: l_custom_rec.attribute_name :=':l_curr_page_time_id';
4313: l_custom_rec.attribute_value :=l_curr_page_time_id;
4314: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
4315: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4316: x_custom_attr.Extend();
4317: x_custom_attr(l_bind_ctr):=l_custom_rec;
4318: l_bind_ctr:=l_bind_ctr+1;

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

4311:
4312: l_custom_rec.attribute_name :=':l_curr_page_time_id';
4313: l_custom_rec.attribute_value :=l_curr_page_time_id;
4314: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
4315: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4316: x_custom_attr.Extend();
4317: x_custom_attr(l_bind_ctr):=l_custom_rec;
4318: l_bind_ctr:=l_bind_ctr+1;
4319: l_custom_rec.attribute_name :=':l_prev_page_time_id';

Line 4321: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

4317: x_custom_attr(l_bind_ctr):=l_custom_rec;
4318: l_bind_ctr:=l_bind_ctr+1;
4319: l_custom_rec.attribute_name :=':l_prev_page_time_id';
4320: l_custom_rec.attribute_value :=l_prev_page_time_id;
4321: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
4322: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4323: x_custom_attr.Extend();
4324: x_custom_attr(l_bind_ctr):=l_custom_rec;
4325: l_bind_ctr:=l_bind_ctr+1;

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

4318: l_bind_ctr:=l_bind_ctr+1;
4319: l_custom_rec.attribute_name :=':l_prev_page_time_id';
4320: l_custom_rec.attribute_value :=l_prev_page_time_id;
4321: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
4322: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4323: x_custom_attr.Extend();
4324: x_custom_attr(l_bind_ctr):=l_custom_rec;
4325: l_bind_ctr:=l_bind_ctr+1;
4326: l_custom_rec.attribute_name :=':l_calendar_id';

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

4324: x_custom_attr(l_bind_ctr):=l_custom_rec;
4325: l_bind_ctr:=l_bind_ctr+1;
4326: l_custom_rec.attribute_name :=':l_calendar_id';
4327: l_custom_rec.attribute_value :=l_calendar_id;
4328: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4329: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4330: x_custom_attr.Extend();
4331: x_custom_attr(l_bind_ctr):=l_custom_rec;
4332: l_bind_ctr:=l_bind_ctr+1;

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

4325: l_bind_ctr:=l_bind_ctr+1;
4326: l_custom_rec.attribute_name :=':l_calendar_id';
4327: l_custom_rec.attribute_value :=l_calendar_id;
4328: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4329: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4330: x_custom_attr.Extend();
4331: x_custom_attr(l_bind_ctr):=l_custom_rec;
4332: l_bind_ctr:=l_bind_ctr+1;
4333: l_custom_rec.attribute_name :=':l_sg_id';

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

4331: x_custom_attr(l_bind_ctr):=l_custom_rec;
4332: l_bind_ctr:=l_bind_ctr+1;
4333: l_custom_rec.attribute_name :=':l_sg_id';
4334: l_custom_rec.attribute_value :=l_sg_id;
4335: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4336: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4337: x_custom_attr.Extend();
4338: x_custom_attr(l_bind_ctr):=l_custom_rec;
4339: l_bind_ctr:=l_bind_ctr+1;

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

4332: l_bind_ctr:=l_bind_ctr+1;
4333: l_custom_rec.attribute_name :=':l_sg_id';
4334: l_custom_rec.attribute_value :=l_sg_id;
4335: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4336: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4337: x_custom_attr.Extend();
4338: x_custom_attr(l_bind_ctr):=l_custom_rec;
4339: l_bind_ctr:=l_bind_ctr+1;
4340:

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

4340:
4341: if(l_resource_id is not null) then
4342: l_custom_rec.attribute_name :=':l_resource_id';
4343: l_custom_rec.attribute_value :=l_resource_id;
4344: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4345: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4346: x_custom_attr.Extend();
4347: x_custom_attr(l_bind_ctr):=l_custom_rec;
4348: l_bind_ctr:=l_bind_ctr+1;

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

4341: if(l_resource_id is not null) then
4342: l_custom_rec.attribute_name :=':l_resource_id';
4343: l_custom_rec.attribute_value :=l_resource_id;
4344: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4345: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4346: x_custom_attr.Extend();
4347: x_custom_attr(l_bind_ctr):=l_custom_rec;
4348: l_bind_ctr:=l_bind_ctr+1;
4349: end if;

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

4349: end if;
4350: if(l_parent_sls_grp_id is not null) then
4351: l_custom_rec.attribute_name :=':l_parent_sls_grp_id';
4352: l_custom_rec.attribute_value :=l_parent_sls_grp_id;
4353: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4354: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4355: x_custom_attr.Extend();
4356: x_custom_attr(l_bind_ctr):=l_custom_rec;
4357: l_bind_ctr:=l_bind_ctr+1;

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

4350: if(l_parent_sls_grp_id is not null) then
4351: l_custom_rec.attribute_name :=':l_parent_sls_grp_id';
4352: l_custom_rec.attribute_value :=l_parent_sls_grp_id;
4353: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4354: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4355: x_custom_attr.Extend();
4356: x_custom_attr(l_bind_ctr):=l_custom_rec;
4357: l_bind_ctr:=l_bind_ctr+1;
4358: end if;

Line 4361: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

4357: l_bind_ctr:=l_bind_ctr+1;
4358: end if;
4359: l_custom_rec.attribute_name :=':l_bitand_id';
4360: l_custom_rec.attribute_value :=l_bitand_id;
4361: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
4362: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4363: x_custom_attr.Extend();
4364: x_custom_attr(l_bind_ctr):=l_custom_rec;
4365: l_bind_ctr:=l_bind_ctr+1;

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

4358: end if;
4359: l_custom_rec.attribute_name :=':l_bitand_id';
4360: l_custom_rec.attribute_value :=l_bitand_id;
4361: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
4362: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4363: x_custom_attr.Extend();
4364: x_custom_attr(l_bind_ctr):=l_custom_rec;
4365: l_bind_ctr:=l_bind_ctr+1;
4366: l_custom_rec.attribute_name :=':l_record_type_id';

Line 4368: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

4364: x_custom_attr(l_bind_ctr):=l_custom_rec;
4365: l_bind_ctr:=l_bind_ctr+1;
4366: l_custom_rec.attribute_name :=':l_record_type_id';
4367: l_custom_rec.attribute_value :=l_record_type_id;
4368: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
4369: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4370: x_custom_attr.Extend();
4371: x_custom_attr(l_bind_ctr):=l_custom_rec;
4372: l_bind_ctr:=l_bind_ctr+1;

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

4365: l_bind_ctr:=l_bind_ctr+1;
4366: l_custom_rec.attribute_name :=':l_record_type_id';
4367: l_custom_rec.attribute_value :=l_record_type_id;
4368: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
4369: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4370: x_custom_attr.Extend();
4371: x_custom_attr(l_bind_ctr):=l_custom_rec;
4372: l_bind_ctr:=l_bind_ctr+1;
4373: l_custom_rec.attribute_name :=':l_period_type';

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

4371: x_custom_attr(l_bind_ctr):=l_custom_rec;
4372: l_bind_ctr:=l_bind_ctr+1;
4373: l_custom_rec.attribute_name :=':l_period_type';
4374: l_custom_rec.attribute_value :=l_period_type;
4375: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4376: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4377: x_custom_attr.Extend();
4378: x_custom_attr(l_bind_ctr):=l_custom_rec;
4379: l_bind_ctr:=l_bind_ctr+1;

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

4372: l_bind_ctr:=l_bind_ctr+1;
4373: l_custom_rec.attribute_name :=':l_period_type';
4374: l_custom_rec.attribute_value :=l_period_type;
4375: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4376: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4377: x_custom_attr.Extend();
4378: x_custom_attr(l_bind_ctr):=l_custom_rec;
4379: l_bind_ctr:=l_bind_ctr+1;
4380:

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

4380:
4381: IF (l_prodcat IS NOT NULL) THEN
4382: l_custom_rec.attribute_name :=':l_prodcat';
4383: l_custom_rec.attribute_value :=l_prodcat;
4384: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4385: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4386: x_custom_attr.Extend();
4387: x_custom_attr(l_bind_ctr):=l_custom_rec;
4388: l_bind_ctr:=l_bind_ctr+1;

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

4381: IF (l_prodcat IS NOT NULL) THEN
4382: l_custom_rec.attribute_name :=':l_prodcat';
4383: l_custom_rec.attribute_value :=l_prodcat;
4384: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4385: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4386: x_custom_attr.Extend();
4387: x_custom_attr(l_bind_ctr):=l_custom_rec;
4388: l_bind_ctr:=l_bind_ctr+1;
4389: END IF;

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

4390:
4391: IF(l_product_id IS NOT NULL) THEN
4392: l_custom_rec.attribute_name :=':l_product_id';
4393: l_custom_rec.attribute_value :=l_product_id;
4394: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4395: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4396: x_custom_attr.Extend();
4397: x_custom_attr(l_bind_ctr):=l_custom_rec;
4398: l_bind_ctr:=l_bind_ctr+1;

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

4391: IF(l_product_id IS NOT NULL) THEN
4392: l_custom_rec.attribute_name :=':l_product_id';
4393: l_custom_rec.attribute_value :=l_product_id;
4394: l_custom_rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4395: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4396: x_custom_attr.Extend();
4397: x_custom_attr(l_bind_ctr):=l_custom_rec;
4398: l_bind_ctr:=l_bind_ctr+1;
4399: END IF;

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

4400:
4401:
4402: l_custom_rec.attribute_name := ':l_fst_crdt_type';
4403: l_custom_rec.attribute_value := l_fst_crdt_type;
4404: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4405: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4406: x_custom_attr.Extend();
4407: x_custom_attr(l_bind_ctr):= l_custom_rec;
4408: l_bind_ctr:=l_bind_ctr+1;

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

4401:
4402: l_custom_rec.attribute_name := ':l_fst_crdt_type';
4403: l_custom_rec.attribute_value := l_fst_crdt_type;
4404: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
4405: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
4406: x_custom_attr.Extend();
4407: x_custom_attr(l_bind_ctr):= l_custom_rec;
4408: l_bind_ctr:=l_bind_ctr+1;
4409: