1091: BEGIN
1092: IF p_QUALIFIERS_rec.qualifier_datatype = 'N'
1093: then
1094: l_qual_attr_value_from_number :=
1095: qp_number.canonical_to_number(p_QUALIFIERS_rec.qualifier_attr_value);
1096:
1097: l_qual_attr_value_to_number :=
1098: qp_number.canonical_to_number(p_QUALIFIERS_rec.qualifier_attr_value_to);
1099:
1094: l_qual_attr_value_from_number :=
1095: qp_number.canonical_to_number(p_QUALIFIERS_rec.qualifier_attr_value);
1096:
1097: l_qual_attr_value_to_number :=
1098: qp_number.canonical_to_number(p_QUALIFIERS_rec.qualifier_attr_value_to);
1099:
1100: l_qual_attr_value_from :=
1101: qp_number.number_to_canonical(l_qual_attr_value_from_number); --4418053
1102: ELSE
1097: l_qual_attr_value_to_number :=
1098: qp_number.canonical_to_number(p_QUALIFIERS_rec.qualifier_attr_value_to);
1099:
1100: l_qual_attr_value_from :=
1101: qp_number.number_to_canonical(l_qual_attr_value_from_number); --4418053
1102: ELSE
1103:
1104: l_qual_attr_value_from := p_QUALIFIERS_rec.qualifier_attr_value; --4418053
1105:
1292:
1293: IF p_QUALIFIERS_rec.qualifier_datatype = 'N'
1294: then
1295: l_qual_attr_value_from_number :=
1296: qp_number.canonical_to_number(p_QUALIFIERS_rec.qualifier_attr_value);
1297:
1298: l_qual_attr_value_to_number :=
1299: qp_number.canonical_to_number(p_QUALIFIERS_rec.qualifier_attr_value_to);
1300:
1295: l_qual_attr_value_from_number :=
1296: qp_number.canonical_to_number(p_QUALIFIERS_rec.qualifier_attr_value);
1297:
1298: l_qual_attr_value_to_number :=
1299: qp_number.canonical_to_number(p_QUALIFIERS_rec.qualifier_attr_value_to);
1300:
1301: l_qual_attr_value_from :=
1302: qp_number.number_to_canonical(l_qual_attr_value_from_number); --4418053
1303: ELSE
1298: l_qual_attr_value_to_number :=
1299: qp_number.canonical_to_number(p_QUALIFIERS_rec.qualifier_attr_value_to);
1300:
1301: l_qual_attr_value_from :=
1302: qp_number.number_to_canonical(l_qual_attr_value_from_number); --4418053
1303: ELSE
1304:
1305: l_qual_attr_value_from := p_QUALIFIERS_rec.qualifier_attr_value; --4418053
1306: