DBA Data[Home] [Help]

APPS.QP_ARCHIVE_ENTITY_PVT dependencies on QP_NUMBER

Line 491: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);

487:
488: BEGIN
489:
490: l_pric_attr_value_from_number :=
491: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
492:
493: l_pric_attr_value_to_number :=
494: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
495:

Line 494: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);

490: l_pric_attr_value_from_number :=
491: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
492:
493: l_pric_attr_value_to_number :=
494: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
495:
496: EXCEPTION
497: WHEN VALUE_ERROR THEN
498: NULL;

Line 1446: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);

1442: FOR l_qp_qualifiers_rec IN qp_qualifiers_cur(p_entity, l_context,l_attribute)
1443: LOOP
1444: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' THEN
1445: BEGIN
1446: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1447: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1448: EXCEPTION
1449: WHEN VALUE_ERROR THEN
1450: NULL;

Line 1447: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);

1443: LOOP
1444: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' THEN
1445: BEGIN
1446: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1447: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1448: EXCEPTION
1449: WHEN VALUE_ERROR THEN
1450: NULL;
1451: WHEN OTHERS THEN

Line 1577: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);

1573: FOR l_qp_qualifiers_rec IN qp_headers_qualifiers_cur(p_entity)
1574: LOOP
1575: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' THEN
1576: BEGIN
1577: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1578: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1579: EXCEPTION
1580: WHEN VALUE_ERROR THEN
1581: NULL;

Line 1578: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);

1574: LOOP
1575: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' THEN
1576: BEGIN
1577: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1578: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1579: EXCEPTION
1580: WHEN VALUE_ERROR THEN
1581: NULL;
1582: WHEN OTHERS THEN

Line 1979: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);

1975: FOR l_qp_qualifiers_rec IN qp_line_qualifiers_cur(p_entity,l_qp_list_lines_rec.list_line_id)
1976: LOOP
1977: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' then
1978: BEGIN
1979: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1980: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1981: EXCEPTION
1982: WHEN VALUE_ERROR THEN
1983: NULL;

Line 1980: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);

1976: LOOP
1977: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' then
1978: BEGIN
1979: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1980: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1981: EXCEPTION
1982: WHEN VALUE_ERROR THEN
1983: NULL;
1984: WHEN OTHERS THEN

Line 2116: l_pric_attr_value_from_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);

2112: /* Archive List lines pricing attributes */
2113: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (l_qp_list_lines_rec.list_line_id) LOOP
2114: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N' then
2115: BEGIN
2116: l_pric_attr_value_from_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
2117: l_pric_attr_value_to_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
2118: EXCEPTION
2119: WHEN VALUE_ERROR THEN
2120: NULL;

Line 2117: l_pric_attr_value_to_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);

2113: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (l_qp_list_lines_rec.list_line_id) LOOP
2114: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N' then
2115: BEGIN
2116: l_pric_attr_value_from_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
2117: l_pric_attr_value_to_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
2118: EXCEPTION
2119: WHEN VALUE_ERROR THEN
2120: NULL;
2121: WHEN OTHERS THEN