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

Line 1101: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

1097:
1098: /* Binds */
1099:
1100: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1101: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1102:
1103: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1104: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1105: l_custom_rec.attribute_value := l_viewby;

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

1099:
1100: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1101: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1102:
1103: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1104: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1105: l_custom_rec.attribute_value := l_viewby;
1106: x_custom_attr.Extend();
1107: x_custom_attr(1):=l_custom_rec;

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

1100: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1101: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1102:
1103: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1104: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1105: l_custom_rec.attribute_value := l_viewby;
1106: x_custom_attr.Extend();
1107: x_custom_attr(1):=l_custom_rec;
1108: l_bind_ctr := l_bind_ctr+1;

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

1108: l_bind_ctr := l_bind_ctr+1;
1109:
1110: l_custom_rec.attribute_name := ':l_snap_date';
1111: l_custom_rec.attribute_value := TO_CHAR(l_snap_date,'DD/MM/YYYY');
1112: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1113: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1114: x_custom_attr.Extend();
1115: x_custom_attr(l_bind_ctr) := l_custom_rec;
1116: l_bind_ctr := l_bind_ctr+1;

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

1109:
1110: l_custom_rec.attribute_name := ':l_snap_date';
1111: l_custom_rec.attribute_value := TO_CHAR(l_snap_date,'DD/MM/YYYY');
1112: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1113: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1114: x_custom_attr.Extend();
1115: x_custom_attr(l_bind_ctr) := l_custom_rec;
1116: l_bind_ctr := l_bind_ctr+1;
1117:

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

1116: l_bind_ctr := l_bind_ctr+1;
1117:
1118: l_custom_rec.attribute_name := ':l_snapshot_date';
1119: l_custom_rec.attribute_value := TO_CHAR(l_snapshot_date,'DD/MM/YYYY');
1120: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1121: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1122: x_custom_attr.Extend();
1123: x_custom_attr(l_bind_ctr) := l_custom_rec;
1124: l_bind_ctr := l_bind_ctr+1;

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

1117:
1118: l_custom_rec.attribute_name := ':l_snapshot_date';
1119: l_custom_rec.attribute_value := TO_CHAR(l_snapshot_date,'DD/MM/YYYY');
1120: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1121: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1122: x_custom_attr.Extend();
1123: x_custom_attr(l_bind_ctr) := l_custom_rec;
1124: l_bind_ctr := l_bind_ctr+1;
1125:

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

1124: l_bind_ctr := l_bind_ctr+1;
1125:
1126: l_custom_rec.attribute_name := ':l_prev_snap_date';
1127: l_custom_rec.attribute_value := TO_CHAR(l_prev_snap_date,'DD/MM/YYYY');
1128: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1129: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1130: x_custom_attr.Extend();
1131: x_custom_attr(l_bind_ctr) := l_custom_rec;
1132: l_bind_ctr := l_bind_ctr+1;

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

1125:
1126: l_custom_rec.attribute_name := ':l_prev_snap_date';
1127: l_custom_rec.attribute_value := TO_CHAR(l_prev_snap_date,'DD/MM/YYYY');
1128: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1129: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1130: x_custom_attr.Extend();
1131: x_custom_attr(l_bind_ctr) := l_custom_rec;
1132: l_bind_ctr := l_bind_ctr+1;
1133:

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

1132: l_bind_ctr := l_bind_ctr+1;
1133:
1134: l_custom_rec.attribute_name := ':l_prev_date';
1135: l_custom_rec.attribute_value := TO_CHAR(l_prev_date,'DD/MM/YYYY');
1136: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1137: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1138: x_custom_attr.Extend();
1139: x_custom_attr(l_bind_ctr) := l_custom_rec;
1140: l_bind_ctr := l_bind_ctr+1;

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

1133:
1134: l_custom_rec.attribute_name := ':l_prev_date';
1135: l_custom_rec.attribute_value := TO_CHAR(l_prev_date,'DD/MM/YYYY');
1136: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1137: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1138: x_custom_attr.Extend();
1139: x_custom_attr(l_bind_ctr) := l_custom_rec;
1140: l_bind_ctr := l_bind_ctr+1;
1141:

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

1140: l_bind_ctr := l_bind_ctr+1;
1141:
1142: l_custom_rec.attribute_name := ':l_period_type';
1143: l_custom_rec.attribute_value := l_period_type;
1144: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1145: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1146: x_custom_attr.Extend();
1147: x_custom_attr(l_bind_ctr) := l_custom_rec;
1148: l_bind_ctr := l_bind_ctr+1;

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

1141:
1142: l_custom_rec.attribute_name := ':l_period_type';
1143: l_custom_rec.attribute_value := l_period_type;
1144: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1145: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1146: x_custom_attr.Extend();
1147: x_custom_attr(l_bind_ctr) := l_custom_rec;
1148: l_bind_ctr := l_bind_ctr+1;
1149:

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

1148: l_bind_ctr := l_bind_ctr+1;
1149:
1150: l_custom_rec.attribute_name := ':l_conv_rate_selected';
1151: l_custom_rec.attribute_value := l_conv_rate_selected;
1152: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1153: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1154: x_custom_attr.Extend();
1155: x_custom_attr(l_bind_ctr) := l_custom_rec;
1156: l_bind_ctr := l_bind_ctr+1;

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

1149:
1150: l_custom_rec.attribute_name := ':l_conv_rate_selected';
1151: l_custom_rec.attribute_value := l_conv_rate_selected;
1152: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1153: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1154: x_custom_attr.Extend();
1155: x_custom_attr(l_bind_ctr) := l_custom_rec;
1156: l_bind_ctr := l_bind_ctr+1;
1157:

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

1156: l_bind_ctr := l_bind_ctr+1;
1157:
1158: l_custom_rec.attribute_name := ':l_sg_id_num';
1159: l_custom_rec.attribute_value := l_sg_id_num;
1160: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1161: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1162: x_custom_attr.Extend();
1163: x_custom_attr(l_bind_ctr) := l_custom_rec;
1164: l_bind_ctr := l_bind_ctr+1;

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

1157:
1158: l_custom_rec.attribute_name := ':l_sg_id_num';
1159: l_custom_rec.attribute_value := l_sg_id_num;
1160: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1161: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1162: x_custom_attr.Extend();
1163: x_custom_attr(l_bind_ctr) := l_custom_rec;
1164: l_bind_ctr := l_bind_ctr+1;
1165:

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

1165:
1166: IF l_parent_sales_group_id IS NOT NULL THEN
1167: l_custom_rec.attribute_name := ':l_parent_sales_group_id';
1168: l_custom_rec.attribute_value := l_parent_sales_group_id;
1169: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1170: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1171: x_custom_attr.Extend();
1172: x_custom_attr(l_bind_ctr) := l_custom_rec;
1173: l_bind_ctr := l_bind_ctr+1;

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

1166: IF l_parent_sales_group_id IS NOT NULL THEN
1167: l_custom_rec.attribute_name := ':l_parent_sales_group_id';
1168: l_custom_rec.attribute_value := l_parent_sales_group_id;
1169: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1170: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1171: x_custom_attr.Extend();
1172: x_custom_attr(l_bind_ctr) := l_custom_rec;
1173: l_bind_ctr := l_bind_ctr+1;
1174: END IF;

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

1175:
1176: IF l_resource_id IS NOT NULL THEN
1177: l_custom_rec.attribute_name := ':l_resource_id';
1178: l_custom_rec.attribute_value := l_resource_id;
1179: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1180: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1181: x_custom_attr.Extend();
1182: x_custom_attr(l_bind_ctr) := l_custom_rec;
1183: l_bind_ctr := l_bind_ctr+1;

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

1176: IF l_resource_id IS NOT NULL THEN
1177: l_custom_rec.attribute_name := ':l_resource_id';
1178: l_custom_rec.attribute_value := l_resource_id;
1179: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1180: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1181: x_custom_attr.Extend();
1182: x_custom_attr(l_bind_ctr) := l_custom_rec;
1183: l_bind_ctr := l_bind_ctr+1;
1184: END IF;

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

1184: END IF;
1185:
1186: l_custom_rec.attribute_name := ':l_yes';
1187: l_custom_rec.attribute_value := 'Y';
1188: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1189: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1190: x_custom_attr.Extend();
1191: x_custom_attr(l_bind_ctr) := l_custom_rec;
1192: l_bind_ctr := l_bind_ctr+1;

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

1185:
1186: l_custom_rec.attribute_name := ':l_yes';
1187: l_custom_rec.attribute_value := 'Y';
1188: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1189: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1190: x_custom_attr.Extend();
1191: x_custom_attr(l_bind_ctr) := l_custom_rec;
1192: l_bind_ctr := l_bind_ctr+1;
1193:

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

1193:
1194: IF l_prodcat IS NOT NULL THEN
1195: l_custom_rec.attribute_name := ':l_prodcat';
1196: l_custom_rec.attribute_value := l_prodcat;
1197: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1198: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1199: x_custom_attr.Extend();
1200: x_custom_attr(l_bind_ctr) := l_custom_rec;
1201: l_bind_ctr := l_bind_ctr+1;

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

1194: IF l_prodcat IS NOT NULL THEN
1195: l_custom_rec.attribute_name := ':l_prodcat';
1196: l_custom_rec.attribute_value := l_prodcat;
1197: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1198: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1199: x_custom_attr.Extend();
1200: x_custom_attr(l_bind_ctr) := l_custom_rec;
1201: l_bind_ctr := l_bind_ctr+1;
1202:

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

1202:
1203: END IF;
1204: l_custom_rec.attribute_name :=':l_unassigned_value';
1205: l_custom_rec.attribute_value :=l_unassigned_value;
1206: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1207: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1208: x_custom_attr.Extend();
1209: x_custom_attr(l_bind_ctr):=l_custom_rec;
1210: l_bind_ctr:=l_bind_ctr+1;

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

1203: END IF;
1204: l_custom_rec.attribute_name :=':l_unassigned_value';
1205: l_custom_rec.attribute_value :=l_unassigned_value;
1206: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1207: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1208: x_custom_attr.Extend();
1209: x_custom_attr(l_bind_ctr):=l_custom_rec;
1210: l_bind_ctr:=l_bind_ctr+1;
1211:

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

1210: l_bind_ctr:=l_bind_ctr+1;
1211:
1212: l_custom_rec.attribute_name :=':l_cat_assign';
1213: l_custom_rec.attribute_value :=l_cat_assign;
1214: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1215: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1216: x_custom_attr.Extend();
1217: x_custom_attr(l_bind_ctr):=l_custom_rec;
1218: l_bind_ctr:=l_bind_ctr+1;

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

1211:
1212: l_custom_rec.attribute_name :=':l_cat_assign';
1213: l_custom_rec.attribute_value :=l_cat_assign;
1214: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1215: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1216: x_custom_attr.Extend();
1217: x_custom_attr(l_bind_ctr):=l_custom_rec;
1218: l_bind_ctr:=l_bind_ctr+1;
1219:

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

1218: l_bind_ctr:=l_bind_ctr+1;
1219:
1220: l_custom_rec.attribute_name :=':l_bucket1';
1221: l_custom_rec.attribute_value :=l_bucket1;
1222: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1223: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1224: x_custom_attr.Extend();
1225: x_custom_attr(l_bind_ctr):=l_custom_rec;
1226: l_bind_ctr:=l_bind_ctr+1;

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

1219:
1220: l_custom_rec.attribute_name :=':l_bucket1';
1221: l_custom_rec.attribute_value :=l_bucket1;
1222: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1223: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1224: x_custom_attr.Extend();
1225: x_custom_attr(l_bind_ctr):=l_custom_rec;
1226: l_bind_ctr:=l_bind_ctr+1;
1227:

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

1226: l_bind_ctr:=l_bind_ctr+1;
1227:
1228: l_custom_rec.attribute_name :=':l_bucket2';
1229: l_custom_rec.attribute_value :=l_bucket2;
1230: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1231: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1232: x_custom_attr.Extend();
1233: x_custom_attr(l_bind_ctr):=l_custom_rec;
1234: l_bind_ctr:=l_bind_ctr+1;

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

1227:
1228: l_custom_rec.attribute_name :=':l_bucket2';
1229: l_custom_rec.attribute_value :=l_bucket2;
1230: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1231: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1232: x_custom_attr.Extend();
1233: x_custom_attr(l_bind_ctr):=l_custom_rec;
1234: l_bind_ctr:=l_bind_ctr+1;
1235:

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

1234: l_bind_ctr:=l_bind_ctr+1;
1235:
1236: l_custom_rec.attribute_name :=':l_bucket3';
1237: l_custom_rec.attribute_value :=l_bucket3;
1238: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1239: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1240: x_custom_attr.Extend();
1241: x_custom_attr(l_bind_ctr):=l_custom_rec;
1242: l_bind_ctr:=l_bind_ctr+1;

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

1235:
1236: l_custom_rec.attribute_name :=':l_bucket3';
1237: l_custom_rec.attribute_value :=l_bucket3;
1238: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1239: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1240: x_custom_attr.Extend();
1241: x_custom_attr(l_bind_ctr):=l_custom_rec;
1242: l_bind_ctr:=l_bind_ctr+1;
1243:

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

1242: l_bind_ctr:=l_bind_ctr+1;
1243:
1244: l_custom_rec.attribute_name :=':l_bucket4';
1245: l_custom_rec.attribute_value :=l_bucket4;
1246: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1247: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1248: x_custom_attr.Extend();
1249: x_custom_attr(l_bind_ctr):=l_custom_rec;
1250: l_bind_ctr:=l_bind_ctr+1;

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

1243:
1244: l_custom_rec.attribute_name :=':l_bucket4';
1245: l_custom_rec.attribute_value :=l_bucket4;
1246: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1247: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1248: x_custom_attr.Extend();
1249: x_custom_attr(l_bind_ctr):=l_custom_rec;
1250: l_bind_ctr:=l_bind_ctr+1;
1251: l_custom_rec.attribute_name :=':l_bucket5';

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

1249: x_custom_attr(l_bind_ctr):=l_custom_rec;
1250: l_bind_ctr:=l_bind_ctr+1;
1251: l_custom_rec.attribute_name :=':l_bucket5';
1252: l_custom_rec.attribute_value :=l_bucket5;
1253: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1254: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1255: x_custom_attr.Extend();
1256: x_custom_attr(l_bind_ctr):=l_custom_rec;
1257: l_bind_ctr:=l_bind_ctr+1;

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

1250: l_bind_ctr:=l_bind_ctr+1;
1251: l_custom_rec.attribute_name :=':l_bucket5';
1252: l_custom_rec.attribute_value :=l_bucket5;
1253: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1254: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1255: x_custom_attr.Extend();
1256: x_custom_attr(l_bind_ctr):=l_custom_rec;
1257: l_bind_ctr:=l_bind_ctr+1;
1258: l_custom_rec.attribute_name :=':l_bucket6';

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

1256: x_custom_attr(l_bind_ctr):=l_custom_rec;
1257: l_bind_ctr:=l_bind_ctr+1;
1258: l_custom_rec.attribute_name :=':l_bucket6';
1259: l_custom_rec.attribute_value :=l_bucket6;
1260: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1261: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1262: x_custom_attr.Extend();
1263: x_custom_attr(l_bind_ctr):=l_custom_rec;
1264: l_bind_ctr:=l_bind_ctr+1;

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

1257: l_bind_ctr:=l_bind_ctr+1;
1258: l_custom_rec.attribute_name :=':l_bucket6';
1259: l_custom_rec.attribute_value :=l_bucket6;
1260: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1261: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1262: x_custom_attr.Extend();
1263: x_custom_attr(l_bind_ctr):=l_custom_rec;
1264: l_bind_ctr:=l_bind_ctr+1;
1265: l_custom_rec.attribute_name :=':l_bucket7';

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

1263: x_custom_attr(l_bind_ctr):=l_custom_rec;
1264: l_bind_ctr:=l_bind_ctr+1;
1265: l_custom_rec.attribute_name :=':l_bucket7';
1266: l_custom_rec.attribute_value :=l_bucket7;
1267: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1268: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1269: x_custom_attr.Extend();
1270: x_custom_attr(l_bind_ctr):=l_custom_rec;
1271: l_bind_ctr:=l_bind_ctr+1;

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

1264: l_bind_ctr:=l_bind_ctr+1;
1265: l_custom_rec.attribute_name :=':l_bucket7';
1266: l_custom_rec.attribute_value :=l_bucket7;
1267: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1268: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1269: x_custom_attr.Extend();
1270: x_custom_attr(l_bind_ctr):=l_custom_rec;
1271: l_bind_ctr:=l_bind_ctr+1;
1272: l_custom_rec.attribute_name :=':l_bucket8';

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

1270: x_custom_attr(l_bind_ctr):=l_custom_rec;
1271: l_bind_ctr:=l_bind_ctr+1;
1272: l_custom_rec.attribute_name :=':l_bucket8';
1273: l_custom_rec.attribute_value :=l_bucket8;
1274: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1275: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1276: x_custom_attr.Extend();
1277: x_custom_attr(l_bind_ctr):=l_custom_rec;
1278: l_bind_ctr:=l_bind_ctr+1;

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

1271: l_bind_ctr:=l_bind_ctr+1;
1272: l_custom_rec.attribute_name :=':l_bucket8';
1273: l_custom_rec.attribute_value :=l_bucket8;
1274: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1275: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1276: x_custom_attr.Extend();
1277: x_custom_attr(l_bind_ctr):=l_custom_rec;
1278: l_bind_ctr:=l_bind_ctr+1;
1279: l_custom_rec.attribute_name :=':l_bucket9';

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

1277: x_custom_attr(l_bind_ctr):=l_custom_rec;
1278: l_bind_ctr:=l_bind_ctr+1;
1279: l_custom_rec.attribute_name :=':l_bucket9';
1280: l_custom_rec.attribute_value :=l_bucket9;
1281: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1282: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1283: x_custom_attr.Extend();
1284: x_custom_attr(l_bind_ctr):=l_custom_rec;
1285: l_bind_ctr:=l_bind_ctr+1;

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

1278: l_bind_ctr:=l_bind_ctr+1;
1279: l_custom_rec.attribute_name :=':l_bucket9';
1280: l_custom_rec.attribute_value :=l_bucket9;
1281: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1282: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1283: x_custom_attr.Extend();
1284: x_custom_attr(l_bind_ctr):=l_custom_rec;
1285: l_bind_ctr:=l_bind_ctr+1;
1286: l_custom_rec.attribute_name :=':l_bucket10';

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

1284: x_custom_attr(l_bind_ctr):=l_custom_rec;
1285: l_bind_ctr:=l_bind_ctr+1;
1286: l_custom_rec.attribute_name :=':l_bucket10';
1287: l_custom_rec.attribute_value :=l_bucket10;
1288: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1289: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1290: x_custom_attr.Extend();
1291: x_custom_attr(l_bind_ctr):=l_custom_rec;
1292: l_bind_ctr:=l_bind_ctr+1;

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

1285: l_bind_ctr:=l_bind_ctr+1;
1286: l_custom_rec.attribute_name :=':l_bucket10';
1287: l_custom_rec.attribute_value :=l_bucket10;
1288: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1289: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1290: x_custom_attr.Extend();
1291: x_custom_attr(l_bind_ctr):=l_custom_rec;
1292: l_bind_ctr:=l_bind_ctr+1;
1293:

Line 1527: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

1523: END IF;
1524:
1525:
1526: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1527: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1528:
1529: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl => p_page_parameter_tbl
1530: ,p_region_id => l_region_id
1531: ,x_period_type => l_period_type

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

2248:
2249: --Bind parameters
2250: l_bind_ctr := 1;
2251:
2252: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
2253: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
2254: l_custom_rec.attribute_value := l_viewby;
2255: x_custom_attr.Extend();
2256: x_custom_attr(l_bind_ctr) := l_custom_rec;

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

2249: --Bind parameters
2250: l_bind_ctr := 1;
2251:
2252: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
2253: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
2254: l_custom_rec.attribute_value := l_viewby;
2255: x_custom_attr.Extend();
2256: x_custom_attr(l_bind_ctr) := l_custom_rec;
2257: l_bind_ctr := l_bind_ctr+1;

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

2257: l_bind_ctr := l_bind_ctr+1;
2258:
2259: l_custom_rec.attribute_name := ':l_curr_page_time_id';
2260: l_custom_rec.attribute_value := l_curr_page_time_id;
2261: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
2262: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2263: x_custom_attr.Extend();
2264: x_custom_attr(l_bind_ctr) := l_custom_rec;
2265: l_bind_ctr := l_bind_ctr+1;

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

2258:
2259: l_custom_rec.attribute_name := ':l_curr_page_time_id';
2260: l_custom_rec.attribute_value := l_curr_page_time_id;
2261: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
2262: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2263: x_custom_attr.Extend();
2264: x_custom_attr(l_bind_ctr) := l_custom_rec;
2265: l_bind_ctr := l_bind_ctr+1;
2266:

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

2265: l_bind_ctr := l_bind_ctr+1;
2266:
2267: l_custom_rec.attribute_name := ':l_curr_as_of_date';
2268: l_custom_rec.attribute_value := TO_CHAR(l_curr_as_of_date,'DD/MM/YYYY');
2269: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2270: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2271: x_custom_attr.Extend();
2272: x_custom_attr(l_bind_ctr) := l_custom_rec;
2273: l_bind_ctr := l_bind_ctr+1;

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

2266:
2267: l_custom_rec.attribute_name := ':l_curr_as_of_date';
2268: l_custom_rec.attribute_value := TO_CHAR(l_curr_as_of_date,'DD/MM/YYYY');
2269: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2270: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2271: x_custom_attr.Extend();
2272: x_custom_attr(l_bind_ctr) := l_custom_rec;
2273: l_bind_ctr := l_bind_ctr+1;
2274:

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

2273: l_bind_ctr := l_bind_ctr+1;
2274:
2275: l_custom_rec.attribute_name := ':l_snap_date';
2276: l_custom_rec.attribute_value := TO_CHAR(l_snap_date,'DD/MM/YYYY');
2277: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2278: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2279: x_custom_attr.Extend();
2280: x_custom_attr(l_bind_ctr) := l_custom_rec;
2281: l_bind_ctr := l_bind_ctr+1;

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

2274:
2275: l_custom_rec.attribute_name := ':l_snap_date';
2276: l_custom_rec.attribute_value := TO_CHAR(l_snap_date,'DD/MM/YYYY');
2277: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2278: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2279: x_custom_attr.Extend();
2280: x_custom_attr(l_bind_ctr) := l_custom_rec;
2281: l_bind_ctr := l_bind_ctr+1;
2282:

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

2281: l_bind_ctr := l_bind_ctr+1;
2282:
2283: l_custom_rec.attribute_name := ':l_snapshot_date';
2284: l_custom_rec.attribute_value := TO_CHAR(l_snapshot_date,'DD/MM/YYYY');
2285: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2286: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2287: x_custom_attr.Extend();
2288: x_custom_attr(l_bind_ctr) := l_custom_rec;
2289: l_bind_ctr := l_bind_ctr+1;

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

2282:
2283: l_custom_rec.attribute_name := ':l_snapshot_date';
2284: l_custom_rec.attribute_value := TO_CHAR(l_snapshot_date,'DD/MM/YYYY');
2285: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2286: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2287: x_custom_attr.Extend();
2288: x_custom_attr(l_bind_ctr) := l_custom_rec;
2289: l_bind_ctr := l_bind_ctr+1;
2290:

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

2289: l_bind_ctr := l_bind_ctr+1;
2290:
2291: l_custom_rec.attribute_name := ':l_record_type_id';
2292: l_custom_rec.attribute_value := l_record_type_id;
2293: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2294: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2295: x_custom_attr.Extend();
2296: x_custom_attr(l_bind_ctr) := l_custom_rec;
2297: l_bind_ctr := l_bind_ctr+1;

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

2290:
2291: l_custom_rec.attribute_name := ':l_record_type_id';
2292: l_custom_rec.attribute_value := l_record_type_id;
2293: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2294: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2295: x_custom_attr.Extend();
2296: x_custom_attr(l_bind_ctr) := l_custom_rec;
2297: l_bind_ctr := l_bind_ctr+1;
2298:

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

2297: l_bind_ctr := l_bind_ctr+1;
2298:
2299: l_custom_rec.attribute_name := ':l_sg_id_num';
2300: l_custom_rec.attribute_value := l_sg_id_num;
2301: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
2302: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2303: x_custom_attr.Extend();
2304: x_custom_attr(l_bind_ctr) := l_custom_rec;
2305: l_bind_ctr := l_bind_ctr+1;

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

2298:
2299: l_custom_rec.attribute_name := ':l_sg_id_num';
2300: l_custom_rec.attribute_value := l_sg_id_num;
2301: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
2302: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2303: x_custom_attr.Extend();
2304: x_custom_attr(l_bind_ctr) := l_custom_rec;
2305: l_bind_ctr := l_bind_ctr+1;
2306:

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

2306:
2307: IF l_parent_sales_group_id IS NOT NULL THEN
2308: l_custom_rec.attribute_name := ':l_parent_sales_group_id';
2309: l_custom_rec.attribute_value := l_parent_sales_group_id;
2310: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
2311: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2312: x_custom_attr.Extend();
2313: x_custom_attr(l_bind_ctr) := l_custom_rec;
2314: l_bind_ctr := l_bind_ctr+1;

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

2307: IF l_parent_sales_group_id IS NOT NULL THEN
2308: l_custom_rec.attribute_name := ':l_parent_sales_group_id';
2309: l_custom_rec.attribute_value := l_parent_sales_group_id;
2310: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
2311: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2312: x_custom_attr.Extend();
2313: x_custom_attr(l_bind_ctr) := l_custom_rec;
2314: l_bind_ctr := l_bind_ctr+1;
2315: END IF;

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

2315: END IF;
2316: IF l_resource_id IS NOT NULL THEN
2317: l_custom_rec.attribute_name := ':l_resource_id';
2318: l_custom_rec.attribute_value := l_resource_id;
2319: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
2320: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2321: x_custom_attr.Extend();
2322: x_custom_attr(l_bind_ctr) := l_custom_rec;
2323: l_bind_ctr := l_bind_ctr+1;

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

2316: IF l_resource_id IS NOT NULL THEN
2317: l_custom_rec.attribute_name := ':l_resource_id';
2318: l_custom_rec.attribute_value := l_resource_id;
2319: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
2320: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2321: x_custom_attr.Extend();
2322: x_custom_attr(l_bind_ctr) := l_custom_rec;
2323: l_bind_ctr := l_bind_ctr+1;
2324: END IF;

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

2324: END IF;
2325:
2326: l_custom_rec.attribute_name := ':l_period_type';
2327: l_custom_rec.attribute_value := l_period_type;
2328: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2329: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2330: x_custom_attr.Extend();
2331: x_custom_attr(l_bind_ctr) := l_custom_rec;
2332: l_bind_ctr := l_bind_ctr+1;

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

2325:
2326: l_custom_rec.attribute_name := ':l_period_type';
2327: l_custom_rec.attribute_value := l_period_type;
2328: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2329: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2330: x_custom_attr.Extend();
2331: x_custom_attr(l_bind_ctr) := l_custom_rec;
2332: l_bind_ctr := l_bind_ctr+1;
2333:

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

2332: l_bind_ctr := l_bind_ctr+1;
2333:
2334: l_custom_rec.attribute_name := ':l_start_date';
2335: l_custom_rec.attribute_value := TO_CHAR(l_start_date,'DD/MM/YYYY');
2336: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2337: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2338: x_custom_attr.Extend();
2339: x_custom_attr(l_bind_ctr) := l_custom_rec;
2340: l_bind_ctr := l_bind_ctr+1;

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

2333:
2334: l_custom_rec.attribute_name := ':l_start_date';
2335: l_custom_rec.attribute_value := TO_CHAR(l_start_date,'DD/MM/YYYY');
2336: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2337: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2338: x_custom_attr.Extend();
2339: x_custom_attr(l_bind_ctr) := l_custom_rec;
2340: l_bind_ctr := l_bind_ctr+1;
2341:

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

2340: l_bind_ctr := l_bind_ctr+1;
2341:
2342: l_custom_rec.attribute_name := ':l_yes';
2343: l_custom_rec.attribute_value := 'Y';
2344: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2345: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2346: x_custom_attr.Extend();
2347: x_custom_attr(l_bind_ctr) := l_custom_rec;
2348: l_bind_ctr := l_bind_ctr+1;

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

2341:
2342: l_custom_rec.attribute_name := ':l_yes';
2343: l_custom_rec.attribute_value := 'Y';
2344: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2345: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2346: x_custom_attr.Extend();
2347: x_custom_attr(l_bind_ctr) := l_custom_rec;
2348: l_bind_ctr := l_bind_ctr+1;
2349: IF l_prodcat_id IS NOT NULL THEN

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

2348: l_bind_ctr := l_bind_ctr+1;
2349: IF l_prodcat_id IS NOT NULL THEN
2350: l_custom_rec.attribute_name :=':l_productcat_id';
2351: l_custom_rec.attribute_value :=l_prodcat;
2352: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2353: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2354: x_custom_attr.Extend();
2355: x_custom_attr(l_bind_ctr):=l_custom_rec;
2356: l_bind_ctr:=l_bind_ctr+1;

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

2349: IF l_prodcat_id IS NOT NULL THEN
2350: l_custom_rec.attribute_name :=':l_productcat_id';
2351: l_custom_rec.attribute_value :=l_prodcat;
2352: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2353: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2354: x_custom_attr.Extend();
2355: x_custom_attr(l_bind_ctr):=l_custom_rec;
2356: l_bind_ctr:=l_bind_ctr+1;
2357:

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

2356: l_bind_ctr:=l_bind_ctr+1;
2357:
2358: l_custom_rec.attribute_name :=':l_prodcat_id';
2359: l_custom_rec.attribute_value :=l_prodcat;
2360: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2361: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2362: x_custom_attr.Extend();
2363: x_custom_attr(l_bind_ctr):=l_custom_rec;
2364: l_bind_ctr:=l_bind_ctr+1;

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

2357:
2358: l_custom_rec.attribute_name :=':l_prodcat_id';
2359: l_custom_rec.attribute_value :=l_prodcat;
2360: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2361: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2362: x_custom_attr.Extend();
2363: x_custom_attr(l_bind_ctr):=l_custom_rec;
2364: l_bind_ctr:=l_bind_ctr+1;
2365:

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

2364: l_bind_ctr:=l_bind_ctr+1;
2365:
2366: l_custom_rec.attribute_name :=':l_prodcat';
2367: l_custom_rec.attribute_value :=l_prodcat;
2368: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2369: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2370: x_custom_attr.Extend();
2371: x_custom_attr(l_bind_ctr):=l_custom_rec;
2372: l_bind_ctr:=l_bind_ctr+1;

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

2365:
2366: l_custom_rec.attribute_name :=':l_prodcat';
2367: l_custom_rec.attribute_value :=l_prodcat;
2368: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2369: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2370: x_custom_attr.Extend();
2371: x_custom_attr(l_bind_ctr):=l_custom_rec;
2372: l_bind_ctr:=l_bind_ctr+1;
2373:

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

2373:
2374: ELSE
2375: l_custom_rec.attribute_name :=':l_unassigned_value';
2376: l_custom_rec.attribute_value :=l_unassigned_value;
2377: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2378: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2379: x_custom_attr.Extend();
2380: x_custom_attr(l_bind_ctr):=l_custom_rec;
2381: l_bind_ctr:=l_bind_ctr+1;

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

2374: ELSE
2375: l_custom_rec.attribute_name :=':l_unassigned_value';
2376: l_custom_rec.attribute_value :=l_unassigned_value;
2377: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2378: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2379: x_custom_attr.Extend();
2380: x_custom_attr(l_bind_ctr):=l_custom_rec;
2381: l_bind_ctr:=l_bind_ctr+1;
2382: END IF;

Line 2501: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

2497: END IF;
2498:
2499:
2500: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
2501: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
2502:
2503: FOR i IN 1..p_page_parameter_tbl.count
2504: LOOP
2505: IF p_page_parameter_tbl(i).parameter_name = 'CURRENCY+FII_CURRENCIES' THEN

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

2739: /* Bind parameters */
2740:
2741: l_custom_rec.attribute_name :=':l_sg_id_num';
2742: l_custom_rec.attribute_value := l_sg_id_num;
2743: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
2744: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2745: x_custom_attr.Extend();
2746:
2747: x_custom_attr(l_bind_ctr):=l_custom_rec;

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

2740:
2741: l_custom_rec.attribute_name :=':l_sg_id_num';
2742: l_custom_rec.attribute_value := l_sg_id_num;
2743: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
2744: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2745: x_custom_attr.Extend();
2746:
2747: x_custom_attr(l_bind_ctr):=l_custom_rec;
2748:

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

2750:
2751: IF l_resource_id IS NOT NULL THEN
2752: l_custom_rec.attribute_name :=':l_resource_id';
2753: l_custom_rec.attribute_value := l_resource_id;
2754: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
2755: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2756: x_custom_attr.Extend();
2757: x_custom_attr(l_bind_ctr):=l_custom_rec;
2758: l_bind_ctr:=l_bind_ctr+1;

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

2751: IF l_resource_id IS NOT NULL THEN
2752: l_custom_rec.attribute_name :=':l_resource_id';
2753: l_custom_rec.attribute_value := l_resource_id;
2754: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
2755: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2756: x_custom_attr.Extend();
2757: x_custom_attr(l_bind_ctr):=l_custom_rec;
2758: l_bind_ctr:=l_bind_ctr+1;
2759: END IF;

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

2759: END IF;
2760:
2761: l_custom_rec.attribute_name :=':l_opty_status';
2762: l_custom_rec.attribute_value := l_opty_status;
2763: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2764: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2765: x_custom_attr.Extend();
2766: x_custom_attr(l_bind_ctr):=l_custom_rec;
2767: l_bind_ctr:=l_bind_ctr+1;

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

2760:
2761: l_custom_rec.attribute_name :=':l_opty_status';
2762: l_custom_rec.attribute_value := l_opty_status;
2763: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2764: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2765: x_custom_attr.Extend();
2766: x_custom_attr(l_bind_ctr):=l_custom_rec;
2767: l_bind_ctr:=l_bind_ctr+1;
2768:

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

2768:
2769:
2770: l_custom_rec.attribute_name :=':l_rep_r_grp';
2771: l_custom_rec.attribute_value := l_rep_r_grp;
2772: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2773: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2774: x_custom_attr.Extend();
2775: x_custom_attr(l_bind_ctr):=l_custom_rec;
2776: l_bind_ctr:=l_bind_ctr+1;

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

2769:
2770: l_custom_rec.attribute_name :=':l_rep_r_grp';
2771: l_custom_rec.attribute_value := l_rep_r_grp;
2772: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2773: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2774: x_custom_attr.Extend();
2775: x_custom_attr(l_bind_ctr):=l_custom_rec;
2776: l_bind_ctr:=l_bind_ctr+1;
2777:

Line 2885: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

2881:
2882: /* Initializing variables*/
2883:
2884: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
2885: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
2886: l_bind_ctr := 1;
2887: l_parameter_valid := TRUE;
2888:
2889: l_region_id := 'BIL_BI_OPPTY_LINE_DETAIL';

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

3214: /* Bind Parameters */
3215:
3216: l_custom_rec.attribute_name :=':l_salesgroup_id';
3217: l_custom_rec.attribute_value := l_salesgroup_id;
3218: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
3219: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3220: x_custom_attr.Extend();
3221: x_custom_attr(l_bind_ctr):=l_custom_rec;
3222: l_bind_ctr:=l_bind_ctr+1;

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

3215:
3216: l_custom_rec.attribute_name :=':l_salesgroup_id';
3217: l_custom_rec.attribute_value := l_salesgroup_id;
3218: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
3219: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3220: x_custom_attr.Extend();
3221: x_custom_attr(l_bind_ctr):=l_custom_rec;
3222: l_bind_ctr:=l_bind_ctr+1;
3223:

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

3223:
3224:
3225: l_custom_rec.attribute_name :=':l_resource_id';
3226: l_custom_rec.attribute_value := l_resource_id;
3227: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
3228: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3229: x_custom_attr.Extend();
3230: x_custom_attr(l_bind_ctr):=l_custom_rec;
3231: l_bind_ctr:=l_bind_ctr+1;

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

3224:
3225: l_custom_rec.attribute_name :=':l_resource_id';
3226: l_custom_rec.attribute_value := l_resource_id;
3227: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
3228: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3229: x_custom_attr.Extend();
3230: x_custom_attr(l_bind_ctr):=l_custom_rec;
3231: l_bind_ctr:=l_bind_ctr+1;
3232:

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

3233:
3234: IF l_prodcat_id IS NOT NULL THEN
3235: l_custom_rec.attribute_name :=':l_prodcat_id';
3236: l_custom_rec.attribute_value := l_prodcat_id;
3237: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3238: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3239: x_custom_attr.Extend();
3240: x_custom_attr(l_bind_ctr):=l_custom_rec;
3241: l_bind_ctr:=l_bind_ctr+1;

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

3234: IF l_prodcat_id IS NOT NULL THEN
3235: l_custom_rec.attribute_name :=':l_prodcat_id';
3236: l_custom_rec.attribute_value := l_prodcat_id;
3237: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3238: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3239: x_custom_attr.Extend();
3240: x_custom_attr(l_bind_ctr):=l_custom_rec;
3241: l_bind_ctr:=l_bind_ctr+1;
3242: END IF;

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

3242: END IF;
3243:
3244: l_custom_rec.attribute_name := ':l_asof_date';
3245: l_custom_rec.attribute_value := TO_CHAR(l_asof_date,'DD/MM/YYYY');
3246: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3247: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3248: x_custom_attr.Extend();
3249: x_custom_attr(l_bind_ctr) := l_custom_rec;
3250: l_bind_ctr := l_bind_ctr+1;

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

3243:
3244: l_custom_rec.attribute_name := ':l_asof_date';
3245: l_custom_rec.attribute_value := TO_CHAR(l_asof_date,'DD/MM/YYYY');
3246: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
3247: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3248: x_custom_attr.Extend();
3249: x_custom_attr(l_bind_ctr) := l_custom_rec;
3250: l_bind_ctr := l_bind_ctr+1;
3251:

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

3251:
3252:
3253: l_custom_rec.attribute_name := ':l_period_type';
3254: l_custom_rec.attribute_value := l_period_type;
3255: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3256: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3257: x_custom_attr.Extend();
3258: x_custom_attr(l_bind_ctr) := l_custom_rec;
3259: l_bind_ctr := l_bind_ctr+1;

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

3252:
3253: l_custom_rec.attribute_name := ':l_period_type';
3254: l_custom_rec.attribute_value := l_period_type;
3255: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
3256: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
3257: x_custom_attr.Extend();
3258: x_custom_attr(l_bind_ctr) := l_custom_rec;
3259: l_bind_ctr := l_bind_ctr+1;
3260: