635:
636: BEGIN
637:
638: l_qual_attr_value_from_number :=
639: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
640:
641: l_qual_attr_value_to_number :=
642: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
643:
638: l_qual_attr_value_from_number :=
639: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
640:
641: l_qual_attr_value_to_number :=
642: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
643:
644: EXCEPTION
645: WHEN VALUE_ERROR THEN
646: NULL;
987:
988: BEGIN
989:
990: l_pric_attr_value_from_number :=
991: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
992:
993: l_pric_attr_value_to_number :=
994: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
995:
990: l_pric_attr_value_from_number :=
991: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
992:
993: l_pric_attr_value_to_number :=
994: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
995:
996: EXCEPTION
997: WHEN VALUE_ERROR THEN
998: NULL;
1901:
1902: BEGIN
1903:
1904: l_qual_attr_value_from_number :=
1905: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1906:
1907: l_qual_attr_value_to_number :=
1908: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1909:
1904: l_qual_attr_value_from_number :=
1905: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1906:
1907: l_qual_attr_value_to_number :=
1908: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1909:
1910: EXCEPTION
1911: WHEN VALUE_ERROR THEN
1912: NULL;
2643:
2644: BEGIN
2645:
2646: l_pric_attr_value_from_number :=
2647: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
2648:
2649: l_pric_attr_value_to_number :=
2650: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
2651:
2646: l_pric_attr_value_from_number :=
2647: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
2648:
2649: l_pric_attr_value_to_number :=
2650: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
2651:
2652: EXCEPTION
2653: WHEN VALUE_ERROR THEN
2654: NULL;