APPS.QP_DELAYED_REQUESTS_UTIL dependencies on QP_NUMBER

Line 757: order by qp_number.canonical_to_number(qpa.PRICING_ATTR_VALUE_FROM);

753: and ql.list_line_type_code IN ('SUR', 'DIS', 'PLL')
754: and qrm.to_rltd_modifier_id = ql.list_line_id
755: and qrm.rltd_modifier_grp_type = 'PRICE BREAK'
756: and qrm.from_rltd_modifier_id = p_list_line_id
757: order by qp_number.canonical_to_number(qpa.PRICING_ATTR_VALUE_FROM);
758:
759: BEGIN
760: x_return_status := FND_API.G_RET_STS_SUCCESS;
761:

Line 767: IF qp_number.canonical_to_number(c_break_lines_attr_val_rec.PRICING_ATTR_VALUE_FROM) >=

763:
764: FOR c_break_lines_attr_val_rec in c_break_lines_attr_values(p_list_line_id)
765: LOOP
766:
767: IF qp_number.canonical_to_number(c_break_lines_attr_val_rec.PRICING_ATTR_VALUE_FROM) >=
768: qp_number.canonical_to_number(c_break_lines_attr_val_rec.PRICING_ATTR_VALUE_TO)
769: THEN
770: l_status := 'FROM_NOT_LESS_THAN_TO';
771: EXIT;

Line 768: qp_number.canonical_to_number(c_break_lines_attr_val_rec.PRICING_ATTR_VALUE_TO)

764: FOR c_break_lines_attr_val_rec in c_break_lines_attr_values(p_list_line_id)
765: LOOP
766:
767: IF qp_number.canonical_to_number(c_break_lines_attr_val_rec.PRICING_ATTR_VALUE_FROM) >=
768: qp_number.canonical_to_number(c_break_lines_attr_val_rec.PRICING_ATTR_VALUE_TO)
769: THEN
770: l_status := 'FROM_NOT_LESS_THAN_TO';
771: EXIT;
772: END IF;

Line 775: IF qp_number.canonical_to_number(c_break_lines_attr_val_rec.PRICING_ATTR_VALUE_FROM) <> 0

771: EXIT;
772: END IF;
773:
774: IF l_break_count = 0 THEN
775: IF qp_number.canonical_to_number(c_break_lines_attr_val_rec.PRICING_ATTR_VALUE_FROM) <> 0
776: THEN
777: l_status := 'NON_ZERO_FIRST_VALUE';
778: EXIT;
779: END IF;

Line 781: IF qp_number.canonical_to_number(c_break_lines_attr_val_rec.PRICING_ATTR_VALUE_FROM) > l_old_value_to

777: l_status := 'NON_ZERO_FIRST_VALUE';
778: EXIT;
779: END IF;
780: ELSE
781: IF qp_number.canonical_to_number(c_break_lines_attr_val_rec.PRICING_ATTR_VALUE_FROM) > l_old_value_to
782: THEN
783: l_status := 'GAP';
784: EXIT;
785: ELSIF qp_number.canonical_to_number(c_break_lines_attr_val_rec.PRICING_ATTR_VALUE_FROM) < l_old_value_to

Line 785: ELSIF qp_number.canonical_to_number(c_break_lines_attr_val_rec.PRICING_ATTR_VALUE_FROM) < l_old_value_to

781: IF qp_number.canonical_to_number(c_break_lines_attr_val_rec.PRICING_ATTR_VALUE_FROM) > l_old_value_to
782: THEN
783: l_status := 'GAP';
784: EXIT;
785: ELSIF qp_number.canonical_to_number(c_break_lines_attr_val_rec.PRICING_ATTR_VALUE_FROM) < l_old_value_to
786: THEN
787: l_status := 'OVERLAP';
788: EXIT;
789: END IF;

Line 792: l_old_value_from := qp_number.canonical_to_number(c_break_lines_attr_val_rec.PRICING_ATTR_VALUE_FROM);

788: EXIT;
789: END IF;
790: END IF;
791:
792: l_old_value_from := qp_number.canonical_to_number(c_break_lines_attr_val_rec.PRICING_ATTR_VALUE_FROM);
793: l_old_value_to := qp_number.canonical_to_number(c_break_lines_attr_val_rec.PRICING_ATTR_VALUE_TO);
794:
795:
796: l_break_count := l_break_count+1;

Line 793: l_old_value_to := qp_number.canonical_to_number(c_break_lines_attr_val_rec.PRICING_ATTR_VALUE_TO);

789: END IF;
790: END IF;
791:
792: l_old_value_from := qp_number.canonical_to_number(c_break_lines_attr_val_rec.PRICING_ATTR_VALUE_FROM);
793: l_old_value_to := qp_number.canonical_to_number(c_break_lines_attr_val_rec.PRICING_ATTR_VALUE_TO);
794:
795:
796: l_break_count := l_break_count+1;
797: END LOOP;