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.QP_COPY_PRICELIST_PVT dependencies on QP_QUALIFIERS

Line 347: FROM qp_qualifiers a

343: CURSOR qp_from_discounts_cur(p_from_list_header_id NUMBER, p_context VARCHAR2,
344: p_attribute VARCHAR2)
345: IS
346: SELECT list_header_id
347: FROM qp_qualifiers a
348: WHERE a.qualifier_context = p_context
349: AND a.qualifier_attribute = p_attribute
350: AND a.qualifier_attr_value = TO_CHAR(p_from_list_header_id)
351: AND a.list_header_id IN

Line 360: FROM qp_qualifiers

356:
357: CURSOR qp_hdr_qualifiers_cur(p_from_discount_header_id NUMBER) -- Name changed for cursor for bug 8326619 and an extra condition added
358: IS
359: SELECT *
360: FROM qp_qualifiers
361: WHERE list_header_id = p_from_discount_header_id
362: AND list_line_id = -1;
363:
364: CURSOR qp_lin_qualifiers_cur(p_from_discount_header_id NUMBER) -- Added cursor for bug 8326619

Line 367: FROM qp_qualifiers

363:
364: CURSOR qp_lin_qualifiers_cur(p_from_discount_header_id NUMBER) -- Added cursor for bug 8326619
365: IS
366: SELECT *
367: FROM qp_qualifiers
368: WHERE list_header_id = p_from_discount_header_id
369: AND list_line_id <> -1;
370:
371: CURSOR qp_discount_lines_cur(p_from_discount_header_id NUMBER)

Line 602: FOR l_qp_qualifiers_rec IN

598:
599: /* Copy all qualifiers for the discount and in case of the qualifier
600: being the from-pricelist replace it with the new pricelist*/
601:
602: FOR l_qp_qualifiers_rec IN
603: qp_hdr_qualifiers_cur(qp_from_discounts_rec.list_header_id) --- cursor changed for bug 8326619
604: LOOP
605:
606: --Get new qualifier_id

Line 607: SELECT qp_qualifiers_s.nextval

603: qp_hdr_qualifiers_cur(qp_from_discounts_rec.list_header_id) --- cursor changed for bug 8326619
604: LOOP
605:
606: --Get new qualifier_id
607: SELECT qp_qualifiers_s.nextval
608: INTO l_new_qualifier_id
609: FROM dual;
610:
611: IF l_qp_qualifiers_rec.qualifier_attr_value =

Line 611: IF l_qp_qualifiers_rec.qualifier_attr_value =

607: SELECT qp_qualifiers_s.nextval
608: INTO l_new_qualifier_id
609: FROM dual;
610:
611: IF l_qp_qualifiers_rec.qualifier_attr_value =
612: TO_CHAR(p_from_list_header_id) AND
613: l_qp_qualifiers_rec.qualifier_context = p_context AND
614: l_qp_qualifiers_rec.qualifier_attribute = p_attribute
615: THEN

Line 613: l_qp_qualifiers_rec.qualifier_context = p_context AND

609: FROM dual;
610:
611: IF l_qp_qualifiers_rec.qualifier_attr_value =
612: TO_CHAR(p_from_list_header_id) AND
613: l_qp_qualifiers_rec.qualifier_context = p_context AND
614: l_qp_qualifiers_rec.qualifier_attribute = p_attribute
615: THEN
616: l_qp_qualifiers_rec.qualifier_attr_value :=
617: TO_CHAR(p_new_list_header_id);

Line 614: l_qp_qualifiers_rec.qualifier_attribute = p_attribute

610:
611: IF l_qp_qualifiers_rec.qualifier_attr_value =
612: TO_CHAR(p_from_list_header_id) AND
613: l_qp_qualifiers_rec.qualifier_context = p_context AND
614: l_qp_qualifiers_rec.qualifier_attribute = p_attribute
615: THEN
616: l_qp_qualifiers_rec.qualifier_attr_value :=
617: TO_CHAR(p_new_list_header_id);
618: END IF;

Line 616: l_qp_qualifiers_rec.qualifier_attr_value :=

612: TO_CHAR(p_from_list_header_id) AND
613: l_qp_qualifiers_rec.qualifier_context = p_context AND
614: l_qp_qualifiers_rec.qualifier_attribute = p_attribute
615: THEN
616: l_qp_qualifiers_rec.qualifier_attr_value :=
617: TO_CHAR(p_new_list_header_id);
618: END IF;
619:
620: BEGIN

Line 633: IF l_qp_qualifiers_rec.qualifier_datatype = 'N'

629: WHEN OTHERS THEN
630: NULL;
631: END;
632:
633: IF l_qp_qualifiers_rec.qualifier_datatype = 'N'
634: then
635:
636: BEGIN
637:

Line 639: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);

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:

Line 642: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);

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;

Line 654: INSERT INTO qp_qualifiers

650:
651: end if;
652:
653: --Insert new qualifier
654: INSERT INTO qp_qualifiers
655: (
656: qualifier_id,
657: creation_date,
658: created_by,

Line 723: l_qp_qualifiers_rec.excluder_flag,

719: p_conc_program_application_id,
720: p_conc_program_id,
721: sysdate,
722: p_conc_request_id,
723: l_qp_qualifiers_rec.excluder_flag,
724: l_qp_qualifiers_rec.comparison_operator_code,
725: l_qp_qualifiers_rec.qualifier_context,
726: l_qp_qualifiers_rec.qualifier_attribute,
727: l_qp_qualifiers_rec.context,

Line 724: l_qp_qualifiers_rec.comparison_operator_code,

720: p_conc_program_id,
721: sysdate,
722: p_conc_request_id,
723: l_qp_qualifiers_rec.excluder_flag,
724: l_qp_qualifiers_rec.comparison_operator_code,
725: l_qp_qualifiers_rec.qualifier_context,
726: l_qp_qualifiers_rec.qualifier_attribute,
727: l_qp_qualifiers_rec.context,
728: l_qp_qualifiers_rec.attribute1,

Line 725: l_qp_qualifiers_rec.qualifier_context,

721: sysdate,
722: p_conc_request_id,
723: l_qp_qualifiers_rec.excluder_flag,
724: l_qp_qualifiers_rec.comparison_operator_code,
725: l_qp_qualifiers_rec.qualifier_context,
726: l_qp_qualifiers_rec.qualifier_attribute,
727: l_qp_qualifiers_rec.context,
728: l_qp_qualifiers_rec.attribute1,
729: l_qp_qualifiers_rec.attribute2,

Line 726: l_qp_qualifiers_rec.qualifier_attribute,

722: p_conc_request_id,
723: l_qp_qualifiers_rec.excluder_flag,
724: l_qp_qualifiers_rec.comparison_operator_code,
725: l_qp_qualifiers_rec.qualifier_context,
726: l_qp_qualifiers_rec.qualifier_attribute,
727: l_qp_qualifiers_rec.context,
728: l_qp_qualifiers_rec.attribute1,
729: l_qp_qualifiers_rec.attribute2,
730: l_qp_qualifiers_rec.attribute3,

Line 727: l_qp_qualifiers_rec.context,

723: l_qp_qualifiers_rec.excluder_flag,
724: l_qp_qualifiers_rec.comparison_operator_code,
725: l_qp_qualifiers_rec.qualifier_context,
726: l_qp_qualifiers_rec.qualifier_attribute,
727: l_qp_qualifiers_rec.context,
728: l_qp_qualifiers_rec.attribute1,
729: l_qp_qualifiers_rec.attribute2,
730: l_qp_qualifiers_rec.attribute3,
731: l_qp_qualifiers_rec.attribute4,

Line 728: l_qp_qualifiers_rec.attribute1,

724: l_qp_qualifiers_rec.comparison_operator_code,
725: l_qp_qualifiers_rec.qualifier_context,
726: l_qp_qualifiers_rec.qualifier_attribute,
727: l_qp_qualifiers_rec.context,
728: l_qp_qualifiers_rec.attribute1,
729: l_qp_qualifiers_rec.attribute2,
730: l_qp_qualifiers_rec.attribute3,
731: l_qp_qualifiers_rec.attribute4,
732: l_qp_qualifiers_rec.attribute5,

Line 729: l_qp_qualifiers_rec.attribute2,

725: l_qp_qualifiers_rec.qualifier_context,
726: l_qp_qualifiers_rec.qualifier_attribute,
727: l_qp_qualifiers_rec.context,
728: l_qp_qualifiers_rec.attribute1,
729: l_qp_qualifiers_rec.attribute2,
730: l_qp_qualifiers_rec.attribute3,
731: l_qp_qualifiers_rec.attribute4,
732: l_qp_qualifiers_rec.attribute5,
733: l_qp_qualifiers_rec.attribute6,

Line 730: l_qp_qualifiers_rec.attribute3,

726: l_qp_qualifiers_rec.qualifier_attribute,
727: l_qp_qualifiers_rec.context,
728: l_qp_qualifiers_rec.attribute1,
729: l_qp_qualifiers_rec.attribute2,
730: l_qp_qualifiers_rec.attribute3,
731: l_qp_qualifiers_rec.attribute4,
732: l_qp_qualifiers_rec.attribute5,
733: l_qp_qualifiers_rec.attribute6,
734: l_qp_qualifiers_rec.attribute7,

Line 731: l_qp_qualifiers_rec.attribute4,

727: l_qp_qualifiers_rec.context,
728: l_qp_qualifiers_rec.attribute1,
729: l_qp_qualifiers_rec.attribute2,
730: l_qp_qualifiers_rec.attribute3,
731: l_qp_qualifiers_rec.attribute4,
732: l_qp_qualifiers_rec.attribute5,
733: l_qp_qualifiers_rec.attribute6,
734: l_qp_qualifiers_rec.attribute7,
735: l_qp_qualifiers_rec.attribute8,

Line 732: l_qp_qualifiers_rec.attribute5,

728: l_qp_qualifiers_rec.attribute1,
729: l_qp_qualifiers_rec.attribute2,
730: l_qp_qualifiers_rec.attribute3,
731: l_qp_qualifiers_rec.attribute4,
732: l_qp_qualifiers_rec.attribute5,
733: l_qp_qualifiers_rec.attribute6,
734: l_qp_qualifiers_rec.attribute7,
735: l_qp_qualifiers_rec.attribute8,
736: l_qp_qualifiers_rec.attribute9,

Line 733: l_qp_qualifiers_rec.attribute6,

729: l_qp_qualifiers_rec.attribute2,
730: l_qp_qualifiers_rec.attribute3,
731: l_qp_qualifiers_rec.attribute4,
732: l_qp_qualifiers_rec.attribute5,
733: l_qp_qualifiers_rec.attribute6,
734: l_qp_qualifiers_rec.attribute7,
735: l_qp_qualifiers_rec.attribute8,
736: l_qp_qualifiers_rec.attribute9,
737: l_qp_qualifiers_rec.attribute10,

Line 734: l_qp_qualifiers_rec.attribute7,

730: l_qp_qualifiers_rec.attribute3,
731: l_qp_qualifiers_rec.attribute4,
732: l_qp_qualifiers_rec.attribute5,
733: l_qp_qualifiers_rec.attribute6,
734: l_qp_qualifiers_rec.attribute7,
735: l_qp_qualifiers_rec.attribute8,
736: l_qp_qualifiers_rec.attribute9,
737: l_qp_qualifiers_rec.attribute10,
738: l_qp_qualifiers_rec.attribute11,

Line 735: l_qp_qualifiers_rec.attribute8,

731: l_qp_qualifiers_rec.attribute4,
732: l_qp_qualifiers_rec.attribute5,
733: l_qp_qualifiers_rec.attribute6,
734: l_qp_qualifiers_rec.attribute7,
735: l_qp_qualifiers_rec.attribute8,
736: l_qp_qualifiers_rec.attribute9,
737: l_qp_qualifiers_rec.attribute10,
738: l_qp_qualifiers_rec.attribute11,
739: l_qp_qualifiers_rec.attribute12,

Line 736: l_qp_qualifiers_rec.attribute9,

732: l_qp_qualifiers_rec.attribute5,
733: l_qp_qualifiers_rec.attribute6,
734: l_qp_qualifiers_rec.attribute7,
735: l_qp_qualifiers_rec.attribute8,
736: l_qp_qualifiers_rec.attribute9,
737: l_qp_qualifiers_rec.attribute10,
738: l_qp_qualifiers_rec.attribute11,
739: l_qp_qualifiers_rec.attribute12,
740: l_qp_qualifiers_rec.attribute13,

Line 737: l_qp_qualifiers_rec.attribute10,

733: l_qp_qualifiers_rec.attribute6,
734: l_qp_qualifiers_rec.attribute7,
735: l_qp_qualifiers_rec.attribute8,
736: l_qp_qualifiers_rec.attribute9,
737: l_qp_qualifiers_rec.attribute10,
738: l_qp_qualifiers_rec.attribute11,
739: l_qp_qualifiers_rec.attribute12,
740: l_qp_qualifiers_rec.attribute13,
741: l_qp_qualifiers_rec.attribute14,

Line 738: l_qp_qualifiers_rec.attribute11,

734: l_qp_qualifiers_rec.attribute7,
735: l_qp_qualifiers_rec.attribute8,
736: l_qp_qualifiers_rec.attribute9,
737: l_qp_qualifiers_rec.attribute10,
738: l_qp_qualifiers_rec.attribute11,
739: l_qp_qualifiers_rec.attribute12,
740: l_qp_qualifiers_rec.attribute13,
741: l_qp_qualifiers_rec.attribute14,
742: l_qp_qualifiers_rec.attribute15,

Line 739: l_qp_qualifiers_rec.attribute12,

735: l_qp_qualifiers_rec.attribute8,
736: l_qp_qualifiers_rec.attribute9,
737: l_qp_qualifiers_rec.attribute10,
738: l_qp_qualifiers_rec.attribute11,
739: l_qp_qualifiers_rec.attribute12,
740: l_qp_qualifiers_rec.attribute13,
741: l_qp_qualifiers_rec.attribute14,
742: l_qp_qualifiers_rec.attribute15,
743: l_qp_qualifiers_rec.qualifier_rule_id,

Line 740: l_qp_qualifiers_rec.attribute13,

736: l_qp_qualifiers_rec.attribute9,
737: l_qp_qualifiers_rec.attribute10,
738: l_qp_qualifiers_rec.attribute11,
739: l_qp_qualifiers_rec.attribute12,
740: l_qp_qualifiers_rec.attribute13,
741: l_qp_qualifiers_rec.attribute14,
742: l_qp_qualifiers_rec.attribute15,
743: l_qp_qualifiers_rec.qualifier_rule_id,
744: l_qp_qualifiers_rec.qualifier_grouping_no,

Line 741: l_qp_qualifiers_rec.attribute14,

737: l_qp_qualifiers_rec.attribute10,
738: l_qp_qualifiers_rec.attribute11,
739: l_qp_qualifiers_rec.attribute12,
740: l_qp_qualifiers_rec.attribute13,
741: l_qp_qualifiers_rec.attribute14,
742: l_qp_qualifiers_rec.attribute15,
743: l_qp_qualifiers_rec.qualifier_rule_id,
744: l_qp_qualifiers_rec.qualifier_grouping_no,
745: l_qp_qualifiers_rec.qualifier_attr_value,

Line 742: l_qp_qualifiers_rec.attribute15,

738: l_qp_qualifiers_rec.attribute11,
739: l_qp_qualifiers_rec.attribute12,
740: l_qp_qualifiers_rec.attribute13,
741: l_qp_qualifiers_rec.attribute14,
742: l_qp_qualifiers_rec.attribute15,
743: l_qp_qualifiers_rec.qualifier_rule_id,
744: l_qp_qualifiers_rec.qualifier_grouping_no,
745: l_qp_qualifiers_rec.qualifier_attr_value,
746: l_new_discount_header_id,

Line 743: l_qp_qualifiers_rec.qualifier_rule_id,

739: l_qp_qualifiers_rec.attribute12,
740: l_qp_qualifiers_rec.attribute13,
741: l_qp_qualifiers_rec.attribute14,
742: l_qp_qualifiers_rec.attribute15,
743: l_qp_qualifiers_rec.qualifier_rule_id,
744: l_qp_qualifiers_rec.qualifier_grouping_no,
745: l_qp_qualifiers_rec.qualifier_attr_value,
746: l_new_discount_header_id,
747: l_qp_qualifiers_rec.list_line_id,

Line 744: l_qp_qualifiers_rec.qualifier_grouping_no,

740: l_qp_qualifiers_rec.attribute13,
741: l_qp_qualifiers_rec.attribute14,
742: l_qp_qualifiers_rec.attribute15,
743: l_qp_qualifiers_rec.qualifier_rule_id,
744: l_qp_qualifiers_rec.qualifier_grouping_no,
745: l_qp_qualifiers_rec.qualifier_attr_value,
746: l_new_discount_header_id,
747: l_qp_qualifiers_rec.list_line_id,
748: l_qp_qualifiers_rec.created_from_rule_id,

Line 745: l_qp_qualifiers_rec.qualifier_attr_value,

741: l_qp_qualifiers_rec.attribute14,
742: l_qp_qualifiers_rec.attribute15,
743: l_qp_qualifiers_rec.qualifier_rule_id,
744: l_qp_qualifiers_rec.qualifier_grouping_no,
745: l_qp_qualifiers_rec.qualifier_attr_value,
746: l_new_discount_header_id,
747: l_qp_qualifiers_rec.list_line_id,
748: l_qp_qualifiers_rec.created_from_rule_id,
749: l_qp_qualifiers_rec.start_date_active,

Line 747: l_qp_qualifiers_rec.list_line_id,

743: l_qp_qualifiers_rec.qualifier_rule_id,
744: l_qp_qualifiers_rec.qualifier_grouping_no,
745: l_qp_qualifiers_rec.qualifier_attr_value,
746: l_new_discount_header_id,
747: l_qp_qualifiers_rec.list_line_id,
748: l_qp_qualifiers_rec.created_from_rule_id,
749: l_qp_qualifiers_rec.start_date_active,
750: l_qp_qualifiers_rec.end_date_active,
751: l_qp_qualifiers_rec.qualifier_precedence,

Line 748: l_qp_qualifiers_rec.created_from_rule_id,

744: l_qp_qualifiers_rec.qualifier_grouping_no,
745: l_qp_qualifiers_rec.qualifier_attr_value,
746: l_new_discount_header_id,
747: l_qp_qualifiers_rec.list_line_id,
748: l_qp_qualifiers_rec.created_from_rule_id,
749: l_qp_qualifiers_rec.start_date_active,
750: l_qp_qualifiers_rec.end_date_active,
751: l_qp_qualifiers_rec.qualifier_precedence,
752: l_qp_qualifiers_rec.qualifier_datatype,

Line 749: l_qp_qualifiers_rec.start_date_active,

745: l_qp_qualifiers_rec.qualifier_attr_value,
746: l_new_discount_header_id,
747: l_qp_qualifiers_rec.list_line_id,
748: l_qp_qualifiers_rec.created_from_rule_id,
749: l_qp_qualifiers_rec.start_date_active,
750: l_qp_qualifiers_rec.end_date_active,
751: l_qp_qualifiers_rec.qualifier_precedence,
752: l_qp_qualifiers_rec.qualifier_datatype,
753: l_qp_qualifiers_rec.qualifier_attr_value_to,

Line 750: l_qp_qualifiers_rec.end_date_active,

746: l_new_discount_header_id,
747: l_qp_qualifiers_rec.list_line_id,
748: l_qp_qualifiers_rec.created_from_rule_id,
749: l_qp_qualifiers_rec.start_date_active,
750: l_qp_qualifiers_rec.end_date_active,
751: l_qp_qualifiers_rec.qualifier_precedence,
752: l_qp_qualifiers_rec.qualifier_datatype,
753: l_qp_qualifiers_rec.qualifier_attr_value_to,
754: l_active_flag,

Line 751: l_qp_qualifiers_rec.qualifier_precedence,

747: l_qp_qualifiers_rec.list_line_id,
748: l_qp_qualifiers_rec.created_from_rule_id,
749: l_qp_qualifiers_rec.start_date_active,
750: l_qp_qualifiers_rec.end_date_active,
751: l_qp_qualifiers_rec.qualifier_precedence,
752: l_qp_qualifiers_rec.qualifier_datatype,
753: l_qp_qualifiers_rec.qualifier_attr_value_to,
754: l_active_flag,
755: l_list_type_code,

Line 752: l_qp_qualifiers_rec.qualifier_datatype,

748: l_qp_qualifiers_rec.created_from_rule_id,
749: l_qp_qualifiers_rec.start_date_active,
750: l_qp_qualifiers_rec.end_date_active,
751: l_qp_qualifiers_rec.qualifier_precedence,
752: l_qp_qualifiers_rec.qualifier_datatype,
753: l_qp_qualifiers_rec.qualifier_attr_value_to,
754: l_active_flag,
755: l_list_type_code,
756: l_qual_attr_value_from_number,

Line 753: l_qp_qualifiers_rec.qualifier_attr_value_to,

749: l_qp_qualifiers_rec.start_date_active,
750: l_qp_qualifiers_rec.end_date_active,
751: l_qp_qualifiers_rec.qualifier_precedence,
752: l_qp_qualifiers_rec.qualifier_datatype,
753: l_qp_qualifiers_rec.qualifier_attr_value_to,
754: l_active_flag,
755: l_list_type_code,
756: l_qual_attr_value_from_number,
757: l_qual_attr_value_to_number,

Line 758: l_qp_qualifiers_rec.search_ind,

754: l_active_flag,
755: l_list_type_code,
756: l_qual_attr_value_from_number,
757: l_qual_attr_value_to_number,
758: l_qp_qualifiers_rec.search_ind,
759: l_qp_qualifiers_rec.distinct_row_count,
760: l_qp_qualifiers_rec.qualifier_group_cnt,
761: l_qp_qualifiers_rec.header_quals_exist_flag,
762: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA

Line 759: l_qp_qualifiers_rec.distinct_row_count,

755: l_list_type_code,
756: l_qual_attr_value_from_number,
757: l_qual_attr_value_to_number,
758: l_qp_qualifiers_rec.search_ind,
759: l_qp_qualifiers_rec.distinct_row_count,
760: l_qp_qualifiers_rec.qualifier_group_cnt,
761: l_qp_qualifiers_rec.header_quals_exist_flag,
762: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
763: --ENH Upgrade BOAPI for orig_sys...ref RAVI

Line 760: l_qp_qualifiers_rec.qualifier_group_cnt,

756: l_qual_attr_value_from_number,
757: l_qual_attr_value_to_number,
758: l_qp_qualifiers_rec.search_ind,
759: l_qp_qualifiers_rec.distinct_row_count,
760: l_qp_qualifiers_rec.qualifier_group_cnt,
761: l_qp_qualifiers_rec.header_quals_exist_flag,
762: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
763: --ENH Upgrade BOAPI for orig_sys...ref RAVI
764: ,to_char(l_new_qualifier_id)

Line 761: l_qp_qualifiers_rec.header_quals_exist_flag,

757: l_qual_attr_value_to_number,
758: l_qp_qualifiers_rec.search_ind,
759: l_qp_qualifiers_rec.distinct_row_count,
760: l_qp_qualifiers_rec.qualifier_group_cnt,
761: l_qp_qualifiers_rec.header_quals_exist_flag,
762: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
763: --ENH Upgrade BOAPI for orig_sys...ref RAVI
764: ,to_char(l_new_qualifier_id)
765: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)

Line 762: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA

758: l_qp_qualifiers_rec.search_ind,
759: l_qp_qualifiers_rec.distinct_row_count,
760: l_qp_qualifiers_rec.qualifier_group_cnt,
761: l_qp_qualifiers_rec.header_quals_exist_flag,
762: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
763: --ENH Upgrade BOAPI for orig_sys...ref RAVI
764: ,to_char(l_new_qualifier_id)
765: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)
766: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)

Line 765: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)

761: l_qp_qualifiers_rec.header_quals_exist_flag,
762: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
763: --ENH Upgrade BOAPI for orig_sys...ref RAVI
764: ,to_char(l_new_qualifier_id)
765: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)
766: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)
767: );
768:
769: END LOOP; /* For copying qualifiers */

Line 1116: FOR l_qp_qualifiers_rec IN

1112: -------------------bug 8326619--------------------------------
1113: /* Copy all qualifiers for the discount and in case of the qualifier
1114: being the from-pricelist replace it with the new pricelist*/---Added for bug 8326619
1115:
1116: FOR l_qp_qualifiers_rec IN
1117: qp_lin_qualifiers_cur(qp_from_discounts_rec.list_header_id)
1118: LOOP
1119:
1120: --Get new qualifier_id

Line 1121: SELECT qp_qualifiers_s.nextval

1117: qp_lin_qualifiers_cur(qp_from_discounts_rec.list_header_id)
1118: LOOP
1119:
1120: --Get new qualifier_id
1121: SELECT qp_qualifiers_s.nextval
1122: INTO l_new_qualifier_id
1123: FROM dual;
1124:
1125: IF l_qp_qualifiers_rec.qualifier_attr_value =

Line 1125: IF l_qp_qualifiers_rec.qualifier_attr_value =

1121: SELECT qp_qualifiers_s.nextval
1122: INTO l_new_qualifier_id
1123: FROM dual;
1124:
1125: IF l_qp_qualifiers_rec.qualifier_attr_value =
1126: TO_CHAR(p_from_list_header_id) AND
1127: l_qp_qualifiers_rec.qualifier_context = p_context AND
1128: l_qp_qualifiers_rec.qualifier_attribute = p_attribute
1129: THEN

Line 1127: l_qp_qualifiers_rec.qualifier_context = p_context AND

1123: FROM dual;
1124:
1125: IF l_qp_qualifiers_rec.qualifier_attr_value =
1126: TO_CHAR(p_from_list_header_id) AND
1127: l_qp_qualifiers_rec.qualifier_context = p_context AND
1128: l_qp_qualifiers_rec.qualifier_attribute = p_attribute
1129: THEN
1130: l_qp_qualifiers_rec.qualifier_attr_value :=
1131: TO_CHAR(p_new_list_header_id);

Line 1128: l_qp_qualifiers_rec.qualifier_attribute = p_attribute

1124:
1125: IF l_qp_qualifiers_rec.qualifier_attr_value =
1126: TO_CHAR(p_from_list_header_id) AND
1127: l_qp_qualifiers_rec.qualifier_context = p_context AND
1128: l_qp_qualifiers_rec.qualifier_attribute = p_attribute
1129: THEN
1130: l_qp_qualifiers_rec.qualifier_attr_value :=
1131: TO_CHAR(p_new_list_header_id);
1132: END IF;

Line 1130: l_qp_qualifiers_rec.qualifier_attr_value :=

1126: TO_CHAR(p_from_list_header_id) AND
1127: l_qp_qualifiers_rec.qualifier_context = p_context AND
1128: l_qp_qualifiers_rec.qualifier_attribute = p_attribute
1129: THEN
1130: l_qp_qualifiers_rec.qualifier_attr_value :=
1131: TO_CHAR(p_new_list_header_id);
1132: END IF;
1133:
1134: BEGIN

Line 1146: IF l_qp_qualifiers_rec.qualifier_datatype = 'N'

1142: WHEN OTHERS THEN
1143: NULL;
1144: END;
1145:
1146: IF l_qp_qualifiers_rec.qualifier_datatype = 'N'
1147: then
1148:
1149: BEGIN
1150:

Line 1152: fnd_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);

1148:
1149: BEGIN
1150:
1151: l_qual_attr_value_from_number :=
1152: fnd_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1153:
1154: l_qual_attr_value_to_number :=
1155: fnd_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1156:

Line 1155: fnd_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);

1151: l_qual_attr_value_from_number :=
1152: fnd_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1153:
1154: l_qual_attr_value_to_number :=
1155: fnd_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1156:
1157: EXCEPTION
1158: WHEN VALUE_ERROR THEN
1159: NULL;

Line 1167: INSERT INTO qp_qualifiers

1163:
1164: end if;
1165:
1166: --Insert new qualifier
1167: INSERT INTO qp_qualifiers
1168: (
1169: qualifier_id,
1170: creation_date,
1171: created_by,

Line 1236: l_qp_qualifiers_rec.excluder_flag,

1232: p_conc_program_application_id,
1233: p_conc_program_id,
1234: sysdate,
1235: p_conc_request_id,
1236: l_qp_qualifiers_rec.excluder_flag,
1237: l_qp_qualifiers_rec.comparison_operator_code,
1238: l_qp_qualifiers_rec.qualifier_context,
1239: l_qp_qualifiers_rec.qualifier_attribute,
1240: l_qp_qualifiers_rec.context,

Line 1237: l_qp_qualifiers_rec.comparison_operator_code,

1233: p_conc_program_id,
1234: sysdate,
1235: p_conc_request_id,
1236: l_qp_qualifiers_rec.excluder_flag,
1237: l_qp_qualifiers_rec.comparison_operator_code,
1238: l_qp_qualifiers_rec.qualifier_context,
1239: l_qp_qualifiers_rec.qualifier_attribute,
1240: l_qp_qualifiers_rec.context,
1241: l_qp_qualifiers_rec.attribute1,

Line 1238: l_qp_qualifiers_rec.qualifier_context,

1234: sysdate,
1235: p_conc_request_id,
1236: l_qp_qualifiers_rec.excluder_flag,
1237: l_qp_qualifiers_rec.comparison_operator_code,
1238: l_qp_qualifiers_rec.qualifier_context,
1239: l_qp_qualifiers_rec.qualifier_attribute,
1240: l_qp_qualifiers_rec.context,
1241: l_qp_qualifiers_rec.attribute1,
1242: l_qp_qualifiers_rec.attribute2,

Line 1239: l_qp_qualifiers_rec.qualifier_attribute,

1235: p_conc_request_id,
1236: l_qp_qualifiers_rec.excluder_flag,
1237: l_qp_qualifiers_rec.comparison_operator_code,
1238: l_qp_qualifiers_rec.qualifier_context,
1239: l_qp_qualifiers_rec.qualifier_attribute,
1240: l_qp_qualifiers_rec.context,
1241: l_qp_qualifiers_rec.attribute1,
1242: l_qp_qualifiers_rec.attribute2,
1243: l_qp_qualifiers_rec.attribute3,

Line 1240: l_qp_qualifiers_rec.context,

1236: l_qp_qualifiers_rec.excluder_flag,
1237: l_qp_qualifiers_rec.comparison_operator_code,
1238: l_qp_qualifiers_rec.qualifier_context,
1239: l_qp_qualifiers_rec.qualifier_attribute,
1240: l_qp_qualifiers_rec.context,
1241: l_qp_qualifiers_rec.attribute1,
1242: l_qp_qualifiers_rec.attribute2,
1243: l_qp_qualifiers_rec.attribute3,
1244: l_qp_qualifiers_rec.attribute4,

Line 1241: l_qp_qualifiers_rec.attribute1,

1237: l_qp_qualifiers_rec.comparison_operator_code,
1238: l_qp_qualifiers_rec.qualifier_context,
1239: l_qp_qualifiers_rec.qualifier_attribute,
1240: l_qp_qualifiers_rec.context,
1241: l_qp_qualifiers_rec.attribute1,
1242: l_qp_qualifiers_rec.attribute2,
1243: l_qp_qualifiers_rec.attribute3,
1244: l_qp_qualifiers_rec.attribute4,
1245: l_qp_qualifiers_rec.attribute5,

Line 1242: l_qp_qualifiers_rec.attribute2,

1238: l_qp_qualifiers_rec.qualifier_context,
1239: l_qp_qualifiers_rec.qualifier_attribute,
1240: l_qp_qualifiers_rec.context,
1241: l_qp_qualifiers_rec.attribute1,
1242: l_qp_qualifiers_rec.attribute2,
1243: l_qp_qualifiers_rec.attribute3,
1244: l_qp_qualifiers_rec.attribute4,
1245: l_qp_qualifiers_rec.attribute5,
1246: l_qp_qualifiers_rec.attribute6,

Line 1243: l_qp_qualifiers_rec.attribute3,

1239: l_qp_qualifiers_rec.qualifier_attribute,
1240: l_qp_qualifiers_rec.context,
1241: l_qp_qualifiers_rec.attribute1,
1242: l_qp_qualifiers_rec.attribute2,
1243: l_qp_qualifiers_rec.attribute3,
1244: l_qp_qualifiers_rec.attribute4,
1245: l_qp_qualifiers_rec.attribute5,
1246: l_qp_qualifiers_rec.attribute6,
1247: l_qp_qualifiers_rec.attribute7,

Line 1244: l_qp_qualifiers_rec.attribute4,

1240: l_qp_qualifiers_rec.context,
1241: l_qp_qualifiers_rec.attribute1,
1242: l_qp_qualifiers_rec.attribute2,
1243: l_qp_qualifiers_rec.attribute3,
1244: l_qp_qualifiers_rec.attribute4,
1245: l_qp_qualifiers_rec.attribute5,
1246: l_qp_qualifiers_rec.attribute6,
1247: l_qp_qualifiers_rec.attribute7,
1248: l_qp_qualifiers_rec.attribute8,

Line 1245: l_qp_qualifiers_rec.attribute5,

1241: l_qp_qualifiers_rec.attribute1,
1242: l_qp_qualifiers_rec.attribute2,
1243: l_qp_qualifiers_rec.attribute3,
1244: l_qp_qualifiers_rec.attribute4,
1245: l_qp_qualifiers_rec.attribute5,
1246: l_qp_qualifiers_rec.attribute6,
1247: l_qp_qualifiers_rec.attribute7,
1248: l_qp_qualifiers_rec.attribute8,
1249: l_qp_qualifiers_rec.attribute9,

Line 1246: l_qp_qualifiers_rec.attribute6,

1242: l_qp_qualifiers_rec.attribute2,
1243: l_qp_qualifiers_rec.attribute3,
1244: l_qp_qualifiers_rec.attribute4,
1245: l_qp_qualifiers_rec.attribute5,
1246: l_qp_qualifiers_rec.attribute6,
1247: l_qp_qualifiers_rec.attribute7,
1248: l_qp_qualifiers_rec.attribute8,
1249: l_qp_qualifiers_rec.attribute9,
1250: l_qp_qualifiers_rec.attribute10,

Line 1247: l_qp_qualifiers_rec.attribute7,

1243: l_qp_qualifiers_rec.attribute3,
1244: l_qp_qualifiers_rec.attribute4,
1245: l_qp_qualifiers_rec.attribute5,
1246: l_qp_qualifiers_rec.attribute6,
1247: l_qp_qualifiers_rec.attribute7,
1248: l_qp_qualifiers_rec.attribute8,
1249: l_qp_qualifiers_rec.attribute9,
1250: l_qp_qualifiers_rec.attribute10,
1251: l_qp_qualifiers_rec.attribute11,

Line 1248: l_qp_qualifiers_rec.attribute8,

1244: l_qp_qualifiers_rec.attribute4,
1245: l_qp_qualifiers_rec.attribute5,
1246: l_qp_qualifiers_rec.attribute6,
1247: l_qp_qualifiers_rec.attribute7,
1248: l_qp_qualifiers_rec.attribute8,
1249: l_qp_qualifiers_rec.attribute9,
1250: l_qp_qualifiers_rec.attribute10,
1251: l_qp_qualifiers_rec.attribute11,
1252: l_qp_qualifiers_rec.attribute12,

Line 1249: l_qp_qualifiers_rec.attribute9,

1245: l_qp_qualifiers_rec.attribute5,
1246: l_qp_qualifiers_rec.attribute6,
1247: l_qp_qualifiers_rec.attribute7,
1248: l_qp_qualifiers_rec.attribute8,
1249: l_qp_qualifiers_rec.attribute9,
1250: l_qp_qualifiers_rec.attribute10,
1251: l_qp_qualifiers_rec.attribute11,
1252: l_qp_qualifiers_rec.attribute12,
1253: l_qp_qualifiers_rec.attribute13,

Line 1250: l_qp_qualifiers_rec.attribute10,

1246: l_qp_qualifiers_rec.attribute6,
1247: l_qp_qualifiers_rec.attribute7,
1248: l_qp_qualifiers_rec.attribute8,
1249: l_qp_qualifiers_rec.attribute9,
1250: l_qp_qualifiers_rec.attribute10,
1251: l_qp_qualifiers_rec.attribute11,
1252: l_qp_qualifiers_rec.attribute12,
1253: l_qp_qualifiers_rec.attribute13,
1254: l_qp_qualifiers_rec.attribute14,

Line 1251: l_qp_qualifiers_rec.attribute11,

1247: l_qp_qualifiers_rec.attribute7,
1248: l_qp_qualifiers_rec.attribute8,
1249: l_qp_qualifiers_rec.attribute9,
1250: l_qp_qualifiers_rec.attribute10,
1251: l_qp_qualifiers_rec.attribute11,
1252: l_qp_qualifiers_rec.attribute12,
1253: l_qp_qualifiers_rec.attribute13,
1254: l_qp_qualifiers_rec.attribute14,
1255: l_qp_qualifiers_rec.attribute15,

Line 1252: l_qp_qualifiers_rec.attribute12,

1248: l_qp_qualifiers_rec.attribute8,
1249: l_qp_qualifiers_rec.attribute9,
1250: l_qp_qualifiers_rec.attribute10,
1251: l_qp_qualifiers_rec.attribute11,
1252: l_qp_qualifiers_rec.attribute12,
1253: l_qp_qualifiers_rec.attribute13,
1254: l_qp_qualifiers_rec.attribute14,
1255: l_qp_qualifiers_rec.attribute15,
1256: l_qp_qualifiers_rec.qualifier_rule_id,

Line 1253: l_qp_qualifiers_rec.attribute13,

1249: l_qp_qualifiers_rec.attribute9,
1250: l_qp_qualifiers_rec.attribute10,
1251: l_qp_qualifiers_rec.attribute11,
1252: l_qp_qualifiers_rec.attribute12,
1253: l_qp_qualifiers_rec.attribute13,
1254: l_qp_qualifiers_rec.attribute14,
1255: l_qp_qualifiers_rec.attribute15,
1256: l_qp_qualifiers_rec.qualifier_rule_id,
1257: l_qp_qualifiers_rec.qualifier_grouping_no,

Line 1254: l_qp_qualifiers_rec.attribute14,

1250: l_qp_qualifiers_rec.attribute10,
1251: l_qp_qualifiers_rec.attribute11,
1252: l_qp_qualifiers_rec.attribute12,
1253: l_qp_qualifiers_rec.attribute13,
1254: l_qp_qualifiers_rec.attribute14,
1255: l_qp_qualifiers_rec.attribute15,
1256: l_qp_qualifiers_rec.qualifier_rule_id,
1257: l_qp_qualifiers_rec.qualifier_grouping_no,
1258: l_qp_qualifiers_rec.qualifier_attr_value,

Line 1255: l_qp_qualifiers_rec.attribute15,

1251: l_qp_qualifiers_rec.attribute11,
1252: l_qp_qualifiers_rec.attribute12,
1253: l_qp_qualifiers_rec.attribute13,
1254: l_qp_qualifiers_rec.attribute14,
1255: l_qp_qualifiers_rec.attribute15,
1256: l_qp_qualifiers_rec.qualifier_rule_id,
1257: l_qp_qualifiers_rec.qualifier_grouping_no,
1258: l_qp_qualifiers_rec.qualifier_attr_value,
1259: l_new_discount_header_id,

Line 1256: l_qp_qualifiers_rec.qualifier_rule_id,

1252: l_qp_qualifiers_rec.attribute12,
1253: l_qp_qualifiers_rec.attribute13,
1254: l_qp_qualifiers_rec.attribute14,
1255: l_qp_qualifiers_rec.attribute15,
1256: l_qp_qualifiers_rec.qualifier_rule_id,
1257: l_qp_qualifiers_rec.qualifier_grouping_no,
1258: l_qp_qualifiers_rec.qualifier_attr_value,
1259: l_new_discount_header_id,
1260: l_new_discount_line_id,

Line 1257: l_qp_qualifiers_rec.qualifier_grouping_no,

1253: l_qp_qualifiers_rec.attribute13,
1254: l_qp_qualifiers_rec.attribute14,
1255: l_qp_qualifiers_rec.attribute15,
1256: l_qp_qualifiers_rec.qualifier_rule_id,
1257: l_qp_qualifiers_rec.qualifier_grouping_no,
1258: l_qp_qualifiers_rec.qualifier_attr_value,
1259: l_new_discount_header_id,
1260: l_new_discount_line_id,
1261: --l_qp_qualifiers_rec.list_line_id, changed for bug 8326619

Line 1258: l_qp_qualifiers_rec.qualifier_attr_value,

1254: l_qp_qualifiers_rec.attribute14,
1255: l_qp_qualifiers_rec.attribute15,
1256: l_qp_qualifiers_rec.qualifier_rule_id,
1257: l_qp_qualifiers_rec.qualifier_grouping_no,
1258: l_qp_qualifiers_rec.qualifier_attr_value,
1259: l_new_discount_header_id,
1260: l_new_discount_line_id,
1261: --l_qp_qualifiers_rec.list_line_id, changed for bug 8326619
1262: l_qp_qualifiers_rec.created_from_rule_id,

Line 1261: --l_qp_qualifiers_rec.list_line_id, changed for bug 8326619

1257: l_qp_qualifiers_rec.qualifier_grouping_no,
1258: l_qp_qualifiers_rec.qualifier_attr_value,
1259: l_new_discount_header_id,
1260: l_new_discount_line_id,
1261: --l_qp_qualifiers_rec.list_line_id, changed for bug 8326619
1262: l_qp_qualifiers_rec.created_from_rule_id,
1263: l_qp_qualifiers_rec.start_date_active,
1264: l_qp_qualifiers_rec.end_date_active,
1265: l_qp_qualifiers_rec.qualifier_precedence,

Line 1262: l_qp_qualifiers_rec.created_from_rule_id,

1258: l_qp_qualifiers_rec.qualifier_attr_value,
1259: l_new_discount_header_id,
1260: l_new_discount_line_id,
1261: --l_qp_qualifiers_rec.list_line_id, changed for bug 8326619
1262: l_qp_qualifiers_rec.created_from_rule_id,
1263: l_qp_qualifiers_rec.start_date_active,
1264: l_qp_qualifiers_rec.end_date_active,
1265: l_qp_qualifiers_rec.qualifier_precedence,
1266: l_qp_qualifiers_rec.qualifier_datatype,

Line 1263: l_qp_qualifiers_rec.start_date_active,

1259: l_new_discount_header_id,
1260: l_new_discount_line_id,
1261: --l_qp_qualifiers_rec.list_line_id, changed for bug 8326619
1262: l_qp_qualifiers_rec.created_from_rule_id,
1263: l_qp_qualifiers_rec.start_date_active,
1264: l_qp_qualifiers_rec.end_date_active,
1265: l_qp_qualifiers_rec.qualifier_precedence,
1266: l_qp_qualifiers_rec.qualifier_datatype,
1267: l_qp_qualifiers_rec.qualifier_attr_value_to,

Line 1264: l_qp_qualifiers_rec.end_date_active,

1260: l_new_discount_line_id,
1261: --l_qp_qualifiers_rec.list_line_id, changed for bug 8326619
1262: l_qp_qualifiers_rec.created_from_rule_id,
1263: l_qp_qualifiers_rec.start_date_active,
1264: l_qp_qualifiers_rec.end_date_active,
1265: l_qp_qualifiers_rec.qualifier_precedence,
1266: l_qp_qualifiers_rec.qualifier_datatype,
1267: l_qp_qualifiers_rec.qualifier_attr_value_to,
1268: l_active_flag,

Line 1265: l_qp_qualifiers_rec.qualifier_precedence,

1261: --l_qp_qualifiers_rec.list_line_id, changed for bug 8326619
1262: l_qp_qualifiers_rec.created_from_rule_id,
1263: l_qp_qualifiers_rec.start_date_active,
1264: l_qp_qualifiers_rec.end_date_active,
1265: l_qp_qualifiers_rec.qualifier_precedence,
1266: l_qp_qualifiers_rec.qualifier_datatype,
1267: l_qp_qualifiers_rec.qualifier_attr_value_to,
1268: l_active_flag,
1269: l_list_type_code,

Line 1266: l_qp_qualifiers_rec.qualifier_datatype,

1262: l_qp_qualifiers_rec.created_from_rule_id,
1263: l_qp_qualifiers_rec.start_date_active,
1264: l_qp_qualifiers_rec.end_date_active,
1265: l_qp_qualifiers_rec.qualifier_precedence,
1266: l_qp_qualifiers_rec.qualifier_datatype,
1267: l_qp_qualifiers_rec.qualifier_attr_value_to,
1268: l_active_flag,
1269: l_list_type_code,
1270: l_qual_attr_value_from_number,

Line 1267: l_qp_qualifiers_rec.qualifier_attr_value_to,

1263: l_qp_qualifiers_rec.start_date_active,
1264: l_qp_qualifiers_rec.end_date_active,
1265: l_qp_qualifiers_rec.qualifier_precedence,
1266: l_qp_qualifiers_rec.qualifier_datatype,
1267: l_qp_qualifiers_rec.qualifier_attr_value_to,
1268: l_active_flag,
1269: l_list_type_code,
1270: l_qual_attr_value_from_number,
1271: l_qual_attr_value_to_number,

Line 1272: l_qp_qualifiers_rec.search_ind,

1268: l_active_flag,
1269: l_list_type_code,
1270: l_qual_attr_value_from_number,
1271: l_qual_attr_value_to_number,
1272: l_qp_qualifiers_rec.search_ind,
1273: l_qp_qualifiers_rec.distinct_row_count,
1274: l_qp_qualifiers_rec.qualifier_group_cnt,
1275: l_qp_qualifiers_rec.header_quals_exist_flag,
1276: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA

Line 1273: l_qp_qualifiers_rec.distinct_row_count,

1269: l_list_type_code,
1270: l_qual_attr_value_from_number,
1271: l_qual_attr_value_to_number,
1272: l_qp_qualifiers_rec.search_ind,
1273: l_qp_qualifiers_rec.distinct_row_count,
1274: l_qp_qualifiers_rec.qualifier_group_cnt,
1275: l_qp_qualifiers_rec.header_quals_exist_flag,
1276: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
1277: --ENH Upgrade BOAPI for orig_sys...ref RAVI

Line 1274: l_qp_qualifiers_rec.qualifier_group_cnt,

1270: l_qual_attr_value_from_number,
1271: l_qual_attr_value_to_number,
1272: l_qp_qualifiers_rec.search_ind,
1273: l_qp_qualifiers_rec.distinct_row_count,
1274: l_qp_qualifiers_rec.qualifier_group_cnt,
1275: l_qp_qualifiers_rec.header_quals_exist_flag,
1276: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
1277: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1278: ,to_char(l_new_qualifier_id)

Line 1275: l_qp_qualifiers_rec.header_quals_exist_flag,

1271: l_qual_attr_value_to_number,
1272: l_qp_qualifiers_rec.search_ind,
1273: l_qp_qualifiers_rec.distinct_row_count,
1274: l_qp_qualifiers_rec.qualifier_group_cnt,
1275: l_qp_qualifiers_rec.header_quals_exist_flag,
1276: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
1277: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1278: ,to_char(l_new_qualifier_id)
1279: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)

Line 1276: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA

1272: l_qp_qualifiers_rec.search_ind,
1273: l_qp_qualifiers_rec.distinct_row_count,
1274: l_qp_qualifiers_rec.qualifier_group_cnt,
1275: l_qp_qualifiers_rec.header_quals_exist_flag,
1276: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
1277: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1278: ,to_char(l_new_qualifier_id)
1279: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)
1280: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)

Line 1279: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)

1275: l_qp_qualifiers_rec.header_quals_exist_flag,
1276: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
1277: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1278: ,to_char(l_new_qualifier_id)
1279: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)
1280: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)
1281: );
1282:
1283: END LOOP; /* For copying qualifiers */---Added for bug 8326619

Line 1572: /* First part of cursor qp_qualifiers_cur selects qualifiers while the second part

1568: SELECT *
1569: FROM qp_pricing_attributes
1570: WHERE list_line_id = p_from_list_line_id;
1571:
1572: /* First part of cursor qp_qualifiers_cur selects qualifiers while the second part
1573: selects secondary price list */
1574:
1575: CURSOR qp_qualifiers_cur(p_from_list_header_id NUMBER, p_context VARCHAR2,
1576: p_attribute VARCHAR2, p_discount_flag VARCHAR2)

Line 1575: CURSOR qp_qualifiers_cur(p_from_list_header_id NUMBER, p_context VARCHAR2,

1571:
1572: /* First part of cursor qp_qualifiers_cur selects qualifiers while the second part
1573: selects secondary price list */
1574:
1575: CURSOR qp_qualifiers_cur(p_from_list_header_id NUMBER, p_context VARCHAR2,
1576: p_attribute VARCHAR2, p_discount_flag VARCHAR2)
1577: IS
1578: SELECT *
1579: FROM qp_qualifiers q

Line 1579: FROM qp_qualifiers q

1575: CURSOR qp_qualifiers_cur(p_from_list_header_id NUMBER, p_context VARCHAR2,
1576: p_attribute VARCHAR2, p_discount_flag VARCHAR2)
1577: IS
1578: SELECT *
1579: FROM qp_qualifiers q
1580: WHERE (q.list_header_id = p_from_list_header_id AND
1581: q.qualifier_attribute <> p_attribute AND --Added for 2200425
1582: Exists (Select Null
1583: --fix for bug 4673872

Line 1863: FOR l_qp_qualifiers_rec IN qp_qualifiers_cur(p_from_list_header_id, l_context,

1859: ELSE
1860: QP_UTIL.Get_Context_Attribute('PRICE_LIST_ID', l_context, l_attribute);
1861: END IF;
1862:
1863: FOR l_qp_qualifiers_rec IN qp_qualifiers_cur(p_from_list_header_id, l_context,
1864: l_attribute, p_discount_flag)
1865: LOOP
1866:
1867: --Get new qualifier_id

Line 1868: SELECT qp_qualifiers_s.nextval

1864: l_attribute, p_discount_flag)
1865: LOOP
1866:
1867: --Get new qualifier_id
1868: SELECT qp_qualifiers_s.nextval
1869: INTO l_new_qualifier_id
1870: FROM dual;
1871:
1872: --To associate newly copied qualifiers (including secondary pricelists)

Line 1874: IF p_from_list_header_id = l_qp_qualifiers_rec.list_header_id THEN

1870: FROM dual;
1871:
1872: --To associate newly copied qualifiers (including secondary pricelists)
1873: --to the new price list
1874: IF p_from_list_header_id = l_qp_qualifiers_rec.list_header_id THEN
1875: l_qp_qualifiers_rec.list_header_id := l_new_list_header_id;
1876: END IF;
1877:
1878: --If From PriceList is Self-Qualifier

Line 1875: l_qp_qualifiers_rec.list_header_id := l_new_list_header_id;

1871:
1872: --To associate newly copied qualifiers (including secondary pricelists)
1873: --to the new price list
1874: IF p_from_list_header_id = l_qp_qualifiers_rec.list_header_id THEN
1875: l_qp_qualifiers_rec.list_header_id := l_new_list_header_id;
1876: END IF;
1877:
1878: --If From PriceList is Self-Qualifier
1879: IF l_qp_qualifiers_rec.qualifier_context = l_context AND

Line 1879: IF l_qp_qualifiers_rec.qualifier_context = l_context AND

1875: l_qp_qualifiers_rec.list_header_id := l_new_list_header_id;
1876: END IF;
1877:
1878: --If From PriceList is Self-Qualifier
1879: IF l_qp_qualifiers_rec.qualifier_context = l_context AND
1880: l_qp_qualifiers_rec.qualifier_attribute = l_attribute AND
1881: l_qp_qualifiers_rec.qualifier_attr_value = TO_CHAR(p_from_list_header_id)
1882: THEN
1883: l_qp_qualifiers_rec.qualifier_attr_value := TO_CHAR(l_new_list_header_id);

Line 1880: l_qp_qualifiers_rec.qualifier_attribute = l_attribute AND

1876: END IF;
1877:
1878: --If From PriceList is Self-Qualifier
1879: IF l_qp_qualifiers_rec.qualifier_context = l_context AND
1880: l_qp_qualifiers_rec.qualifier_attribute = l_attribute AND
1881: l_qp_qualifiers_rec.qualifier_attr_value = TO_CHAR(p_from_list_header_id)
1882: THEN
1883: l_qp_qualifiers_rec.qualifier_attr_value := TO_CHAR(l_new_list_header_id);
1884: END IF;

Line 1881: l_qp_qualifiers_rec.qualifier_attr_value = TO_CHAR(p_from_list_header_id)

1877:
1878: --If From PriceList is Self-Qualifier
1879: IF l_qp_qualifiers_rec.qualifier_context = l_context AND
1880: l_qp_qualifiers_rec.qualifier_attribute = l_attribute AND
1881: l_qp_qualifiers_rec.qualifier_attr_value = TO_CHAR(p_from_list_header_id)
1882: THEN
1883: l_qp_qualifiers_rec.qualifier_attr_value := TO_CHAR(l_new_list_header_id);
1884: END IF;
1885:

Line 1883: l_qp_qualifiers_rec.qualifier_attr_value := TO_CHAR(l_new_list_header_id);

1879: IF l_qp_qualifiers_rec.qualifier_context = l_context AND
1880: l_qp_qualifiers_rec.qualifier_attribute = l_attribute AND
1881: l_qp_qualifiers_rec.qualifier_attr_value = TO_CHAR(p_from_list_header_id)
1882: THEN
1883: l_qp_qualifiers_rec.qualifier_attr_value := TO_CHAR(l_new_list_header_id);
1884: END IF;
1885:
1886: BEGIN
1887:

Line 1892: WHERE LIST_HEADER_ID = l_qp_qualifiers_rec.list_header_id;

1888: SELECT ACTIVE_FLAG, LIST_TYPE_CODE
1889: INTO l_active_flag, l_list_type_code
1890: --fix for bug 4673872
1891: FROM QP_LIST_HEADERS_ALL_B
1892: WHERE LIST_HEADER_ID = l_qp_qualifiers_rec.list_header_id;
1893:
1894: EXCEPTION
1895: WHEN OTHERS THEN
1896: NULL;

Line 1899: IF l_qp_qualifiers_rec.qualifier_datatype = 'N'

1895: WHEN OTHERS THEN
1896: NULL;
1897: END;
1898:
1899: IF l_qp_qualifiers_rec.qualifier_datatype = 'N'
1900: then
1901:
1902: BEGIN
1903:

Line 1905: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);

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:

Line 1908: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);

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;

Line 1919: --Insert into qp_qualifiers

1915: END;
1916:
1917: end if;
1918:
1919: --Insert into qp_qualifiers
1920: INSERT INTO qp_qualifiers
1921: (
1922: qualifier_id,
1923: creation_date,

Line 1920: INSERT INTO qp_qualifiers

1916:
1917: end if;
1918:
1919: --Insert into qp_qualifiers
1920: INSERT INTO qp_qualifiers
1921: (
1922: qualifier_id,
1923: creation_date,
1924: created_by,

Line 1989: l_qp_qualifiers_rec.excluder_flag,

1985: l_conc_program_application_id,
1986: l_conc_program_id,
1987: sysdate,
1988: l_conc_request_id,
1989: l_qp_qualifiers_rec.excluder_flag,
1990: l_qp_qualifiers_rec.comparison_operator_code,
1991: l_qp_qualifiers_rec.qualifier_context,
1992: l_qp_qualifiers_rec.qualifier_attribute,
1993: l_qp_qualifiers_rec.context,

Line 1990: l_qp_qualifiers_rec.comparison_operator_code,

1986: l_conc_program_id,
1987: sysdate,
1988: l_conc_request_id,
1989: l_qp_qualifiers_rec.excluder_flag,
1990: l_qp_qualifiers_rec.comparison_operator_code,
1991: l_qp_qualifiers_rec.qualifier_context,
1992: l_qp_qualifiers_rec.qualifier_attribute,
1993: l_qp_qualifiers_rec.context,
1994: l_qp_qualifiers_rec.attribute1,

Line 1991: l_qp_qualifiers_rec.qualifier_context,

1987: sysdate,
1988: l_conc_request_id,
1989: l_qp_qualifiers_rec.excluder_flag,
1990: l_qp_qualifiers_rec.comparison_operator_code,
1991: l_qp_qualifiers_rec.qualifier_context,
1992: l_qp_qualifiers_rec.qualifier_attribute,
1993: l_qp_qualifiers_rec.context,
1994: l_qp_qualifiers_rec.attribute1,
1995: l_qp_qualifiers_rec.attribute2,

Line 1992: l_qp_qualifiers_rec.qualifier_attribute,

1988: l_conc_request_id,
1989: l_qp_qualifiers_rec.excluder_flag,
1990: l_qp_qualifiers_rec.comparison_operator_code,
1991: l_qp_qualifiers_rec.qualifier_context,
1992: l_qp_qualifiers_rec.qualifier_attribute,
1993: l_qp_qualifiers_rec.context,
1994: l_qp_qualifiers_rec.attribute1,
1995: l_qp_qualifiers_rec.attribute2,
1996: l_qp_qualifiers_rec.attribute3,

Line 1993: l_qp_qualifiers_rec.context,

1989: l_qp_qualifiers_rec.excluder_flag,
1990: l_qp_qualifiers_rec.comparison_operator_code,
1991: l_qp_qualifiers_rec.qualifier_context,
1992: l_qp_qualifiers_rec.qualifier_attribute,
1993: l_qp_qualifiers_rec.context,
1994: l_qp_qualifiers_rec.attribute1,
1995: l_qp_qualifiers_rec.attribute2,
1996: l_qp_qualifiers_rec.attribute3,
1997: l_qp_qualifiers_rec.attribute4,

Line 1994: l_qp_qualifiers_rec.attribute1,

1990: l_qp_qualifiers_rec.comparison_operator_code,
1991: l_qp_qualifiers_rec.qualifier_context,
1992: l_qp_qualifiers_rec.qualifier_attribute,
1993: l_qp_qualifiers_rec.context,
1994: l_qp_qualifiers_rec.attribute1,
1995: l_qp_qualifiers_rec.attribute2,
1996: l_qp_qualifiers_rec.attribute3,
1997: l_qp_qualifiers_rec.attribute4,
1998: l_qp_qualifiers_rec.attribute5,

Line 1995: l_qp_qualifiers_rec.attribute2,

1991: l_qp_qualifiers_rec.qualifier_context,
1992: l_qp_qualifiers_rec.qualifier_attribute,
1993: l_qp_qualifiers_rec.context,
1994: l_qp_qualifiers_rec.attribute1,
1995: l_qp_qualifiers_rec.attribute2,
1996: l_qp_qualifiers_rec.attribute3,
1997: l_qp_qualifiers_rec.attribute4,
1998: l_qp_qualifiers_rec.attribute5,
1999: l_qp_qualifiers_rec.attribute6,

Line 1996: l_qp_qualifiers_rec.attribute3,

1992: l_qp_qualifiers_rec.qualifier_attribute,
1993: l_qp_qualifiers_rec.context,
1994: l_qp_qualifiers_rec.attribute1,
1995: l_qp_qualifiers_rec.attribute2,
1996: l_qp_qualifiers_rec.attribute3,
1997: l_qp_qualifiers_rec.attribute4,
1998: l_qp_qualifiers_rec.attribute5,
1999: l_qp_qualifiers_rec.attribute6,
2000: l_qp_qualifiers_rec.attribute7,

Line 1997: l_qp_qualifiers_rec.attribute4,

1993: l_qp_qualifiers_rec.context,
1994: l_qp_qualifiers_rec.attribute1,
1995: l_qp_qualifiers_rec.attribute2,
1996: l_qp_qualifiers_rec.attribute3,
1997: l_qp_qualifiers_rec.attribute4,
1998: l_qp_qualifiers_rec.attribute5,
1999: l_qp_qualifiers_rec.attribute6,
2000: l_qp_qualifiers_rec.attribute7,
2001: l_qp_qualifiers_rec.attribute8,

Line 1998: l_qp_qualifiers_rec.attribute5,

1994: l_qp_qualifiers_rec.attribute1,
1995: l_qp_qualifiers_rec.attribute2,
1996: l_qp_qualifiers_rec.attribute3,
1997: l_qp_qualifiers_rec.attribute4,
1998: l_qp_qualifiers_rec.attribute5,
1999: l_qp_qualifiers_rec.attribute6,
2000: l_qp_qualifiers_rec.attribute7,
2001: l_qp_qualifiers_rec.attribute8,
2002: l_qp_qualifiers_rec.attribute9,

Line 1999: l_qp_qualifiers_rec.attribute6,

1995: l_qp_qualifiers_rec.attribute2,
1996: l_qp_qualifiers_rec.attribute3,
1997: l_qp_qualifiers_rec.attribute4,
1998: l_qp_qualifiers_rec.attribute5,
1999: l_qp_qualifiers_rec.attribute6,
2000: l_qp_qualifiers_rec.attribute7,
2001: l_qp_qualifiers_rec.attribute8,
2002: l_qp_qualifiers_rec.attribute9,
2003: l_qp_qualifiers_rec.attribute10,

Line 2000: l_qp_qualifiers_rec.attribute7,

1996: l_qp_qualifiers_rec.attribute3,
1997: l_qp_qualifiers_rec.attribute4,
1998: l_qp_qualifiers_rec.attribute5,
1999: l_qp_qualifiers_rec.attribute6,
2000: l_qp_qualifiers_rec.attribute7,
2001: l_qp_qualifiers_rec.attribute8,
2002: l_qp_qualifiers_rec.attribute9,
2003: l_qp_qualifiers_rec.attribute10,
2004: l_qp_qualifiers_rec.attribute11,

Line 2001: l_qp_qualifiers_rec.attribute8,

1997: l_qp_qualifiers_rec.attribute4,
1998: l_qp_qualifiers_rec.attribute5,
1999: l_qp_qualifiers_rec.attribute6,
2000: l_qp_qualifiers_rec.attribute7,
2001: l_qp_qualifiers_rec.attribute8,
2002: l_qp_qualifiers_rec.attribute9,
2003: l_qp_qualifiers_rec.attribute10,
2004: l_qp_qualifiers_rec.attribute11,
2005: l_qp_qualifiers_rec.attribute12,

Line 2002: l_qp_qualifiers_rec.attribute9,

1998: l_qp_qualifiers_rec.attribute5,
1999: l_qp_qualifiers_rec.attribute6,
2000: l_qp_qualifiers_rec.attribute7,
2001: l_qp_qualifiers_rec.attribute8,
2002: l_qp_qualifiers_rec.attribute9,
2003: l_qp_qualifiers_rec.attribute10,
2004: l_qp_qualifiers_rec.attribute11,
2005: l_qp_qualifiers_rec.attribute12,
2006: l_qp_qualifiers_rec.attribute13,

Line 2003: l_qp_qualifiers_rec.attribute10,

1999: l_qp_qualifiers_rec.attribute6,
2000: l_qp_qualifiers_rec.attribute7,
2001: l_qp_qualifiers_rec.attribute8,
2002: l_qp_qualifiers_rec.attribute9,
2003: l_qp_qualifiers_rec.attribute10,
2004: l_qp_qualifiers_rec.attribute11,
2005: l_qp_qualifiers_rec.attribute12,
2006: l_qp_qualifiers_rec.attribute13,
2007: l_qp_qualifiers_rec.attribute14,

Line 2004: l_qp_qualifiers_rec.attribute11,

2000: l_qp_qualifiers_rec.attribute7,
2001: l_qp_qualifiers_rec.attribute8,
2002: l_qp_qualifiers_rec.attribute9,
2003: l_qp_qualifiers_rec.attribute10,
2004: l_qp_qualifiers_rec.attribute11,
2005: l_qp_qualifiers_rec.attribute12,
2006: l_qp_qualifiers_rec.attribute13,
2007: l_qp_qualifiers_rec.attribute14,
2008: l_qp_qualifiers_rec.attribute15,

Line 2005: l_qp_qualifiers_rec.attribute12,

2001: l_qp_qualifiers_rec.attribute8,
2002: l_qp_qualifiers_rec.attribute9,
2003: l_qp_qualifiers_rec.attribute10,
2004: l_qp_qualifiers_rec.attribute11,
2005: l_qp_qualifiers_rec.attribute12,
2006: l_qp_qualifiers_rec.attribute13,
2007: l_qp_qualifiers_rec.attribute14,
2008: l_qp_qualifiers_rec.attribute15,
2009: l_qp_qualifiers_rec.qualifier_rule_id,

Line 2006: l_qp_qualifiers_rec.attribute13,

2002: l_qp_qualifiers_rec.attribute9,
2003: l_qp_qualifiers_rec.attribute10,
2004: l_qp_qualifiers_rec.attribute11,
2005: l_qp_qualifiers_rec.attribute12,
2006: l_qp_qualifiers_rec.attribute13,
2007: l_qp_qualifiers_rec.attribute14,
2008: l_qp_qualifiers_rec.attribute15,
2009: l_qp_qualifiers_rec.qualifier_rule_id,
2010: l_qp_qualifiers_rec.qualifier_grouping_no,

Line 2007: l_qp_qualifiers_rec.attribute14,

2003: l_qp_qualifiers_rec.attribute10,
2004: l_qp_qualifiers_rec.attribute11,
2005: l_qp_qualifiers_rec.attribute12,
2006: l_qp_qualifiers_rec.attribute13,
2007: l_qp_qualifiers_rec.attribute14,
2008: l_qp_qualifiers_rec.attribute15,
2009: l_qp_qualifiers_rec.qualifier_rule_id,
2010: l_qp_qualifiers_rec.qualifier_grouping_no,
2011: l_qp_qualifiers_rec.qualifier_attr_value,

Line 2008: l_qp_qualifiers_rec.attribute15,

2004: l_qp_qualifiers_rec.attribute11,
2005: l_qp_qualifiers_rec.attribute12,
2006: l_qp_qualifiers_rec.attribute13,
2007: l_qp_qualifiers_rec.attribute14,
2008: l_qp_qualifiers_rec.attribute15,
2009: l_qp_qualifiers_rec.qualifier_rule_id,
2010: l_qp_qualifiers_rec.qualifier_grouping_no,
2011: l_qp_qualifiers_rec.qualifier_attr_value,
2012: l_qp_qualifiers_rec.list_header_id,

Line 2009: l_qp_qualifiers_rec.qualifier_rule_id,

2005: l_qp_qualifiers_rec.attribute12,
2006: l_qp_qualifiers_rec.attribute13,
2007: l_qp_qualifiers_rec.attribute14,
2008: l_qp_qualifiers_rec.attribute15,
2009: l_qp_qualifiers_rec.qualifier_rule_id,
2010: l_qp_qualifiers_rec.qualifier_grouping_no,
2011: l_qp_qualifiers_rec.qualifier_attr_value,
2012: l_qp_qualifiers_rec.list_header_id,
2013: l_qp_qualifiers_rec.list_line_id,

Line 2010: l_qp_qualifiers_rec.qualifier_grouping_no,

2006: l_qp_qualifiers_rec.attribute13,
2007: l_qp_qualifiers_rec.attribute14,
2008: l_qp_qualifiers_rec.attribute15,
2009: l_qp_qualifiers_rec.qualifier_rule_id,
2010: l_qp_qualifiers_rec.qualifier_grouping_no,
2011: l_qp_qualifiers_rec.qualifier_attr_value,
2012: l_qp_qualifiers_rec.list_header_id,
2013: l_qp_qualifiers_rec.list_line_id,
2014: l_qp_qualifiers_rec.created_from_rule_id,

Line 2011: l_qp_qualifiers_rec.qualifier_attr_value,

2007: l_qp_qualifiers_rec.attribute14,
2008: l_qp_qualifiers_rec.attribute15,
2009: l_qp_qualifiers_rec.qualifier_rule_id,
2010: l_qp_qualifiers_rec.qualifier_grouping_no,
2011: l_qp_qualifiers_rec.qualifier_attr_value,
2012: l_qp_qualifiers_rec.list_header_id,
2013: l_qp_qualifiers_rec.list_line_id,
2014: l_qp_qualifiers_rec.created_from_rule_id,
2015: l_qp_qualifiers_rec.start_date_active,

Line 2012: l_qp_qualifiers_rec.list_header_id,

2008: l_qp_qualifiers_rec.attribute15,
2009: l_qp_qualifiers_rec.qualifier_rule_id,
2010: l_qp_qualifiers_rec.qualifier_grouping_no,
2011: l_qp_qualifiers_rec.qualifier_attr_value,
2012: l_qp_qualifiers_rec.list_header_id,
2013: l_qp_qualifiers_rec.list_line_id,
2014: l_qp_qualifiers_rec.created_from_rule_id,
2015: l_qp_qualifiers_rec.start_date_active,
2016: l_qp_qualifiers_rec.end_date_active,

Line 2013: l_qp_qualifiers_rec.list_line_id,

2009: l_qp_qualifiers_rec.qualifier_rule_id,
2010: l_qp_qualifiers_rec.qualifier_grouping_no,
2011: l_qp_qualifiers_rec.qualifier_attr_value,
2012: l_qp_qualifiers_rec.list_header_id,
2013: l_qp_qualifiers_rec.list_line_id,
2014: l_qp_qualifiers_rec.created_from_rule_id,
2015: l_qp_qualifiers_rec.start_date_active,
2016: l_qp_qualifiers_rec.end_date_active,
2017: l_qp_qualifiers_rec.qualifier_precedence,

Line 2014: l_qp_qualifiers_rec.created_from_rule_id,

2010: l_qp_qualifiers_rec.qualifier_grouping_no,
2011: l_qp_qualifiers_rec.qualifier_attr_value,
2012: l_qp_qualifiers_rec.list_header_id,
2013: l_qp_qualifiers_rec.list_line_id,
2014: l_qp_qualifiers_rec.created_from_rule_id,
2015: l_qp_qualifiers_rec.start_date_active,
2016: l_qp_qualifiers_rec.end_date_active,
2017: l_qp_qualifiers_rec.qualifier_precedence,
2018: l_qp_qualifiers_rec.qualifier_datatype,

Line 2015: l_qp_qualifiers_rec.start_date_active,

2011: l_qp_qualifiers_rec.qualifier_attr_value,
2012: l_qp_qualifiers_rec.list_header_id,
2013: l_qp_qualifiers_rec.list_line_id,
2014: l_qp_qualifiers_rec.created_from_rule_id,
2015: l_qp_qualifiers_rec.start_date_active,
2016: l_qp_qualifiers_rec.end_date_active,
2017: l_qp_qualifiers_rec.qualifier_precedence,
2018: l_qp_qualifiers_rec.qualifier_datatype,
2019: l_qp_qualifiers_rec.qualifier_attr_value_to,

Line 2016: l_qp_qualifiers_rec.end_date_active,

2012: l_qp_qualifiers_rec.list_header_id,
2013: l_qp_qualifiers_rec.list_line_id,
2014: l_qp_qualifiers_rec.created_from_rule_id,
2015: l_qp_qualifiers_rec.start_date_active,
2016: l_qp_qualifiers_rec.end_date_active,
2017: l_qp_qualifiers_rec.qualifier_precedence,
2018: l_qp_qualifiers_rec.qualifier_datatype,
2019: l_qp_qualifiers_rec.qualifier_attr_value_to,
2020: l_active_flag,

Line 2017: l_qp_qualifiers_rec.qualifier_precedence,

2013: l_qp_qualifiers_rec.list_line_id,
2014: l_qp_qualifiers_rec.created_from_rule_id,
2015: l_qp_qualifiers_rec.start_date_active,
2016: l_qp_qualifiers_rec.end_date_active,
2017: l_qp_qualifiers_rec.qualifier_precedence,
2018: l_qp_qualifiers_rec.qualifier_datatype,
2019: l_qp_qualifiers_rec.qualifier_attr_value_to,
2020: l_active_flag,
2021: l_list_type_code,

Line 2018: l_qp_qualifiers_rec.qualifier_datatype,

2014: l_qp_qualifiers_rec.created_from_rule_id,
2015: l_qp_qualifiers_rec.start_date_active,
2016: l_qp_qualifiers_rec.end_date_active,
2017: l_qp_qualifiers_rec.qualifier_precedence,
2018: l_qp_qualifiers_rec.qualifier_datatype,
2019: l_qp_qualifiers_rec.qualifier_attr_value_to,
2020: l_active_flag,
2021: l_list_type_code,
2022: l_qual_attr_value_from_number,

Line 2019: l_qp_qualifiers_rec.qualifier_attr_value_to,

2015: l_qp_qualifiers_rec.start_date_active,
2016: l_qp_qualifiers_rec.end_date_active,
2017: l_qp_qualifiers_rec.qualifier_precedence,
2018: l_qp_qualifiers_rec.qualifier_datatype,
2019: l_qp_qualifiers_rec.qualifier_attr_value_to,
2020: l_active_flag,
2021: l_list_type_code,
2022: l_qual_attr_value_from_number,
2023: l_qual_attr_value_to_number,

Line 2024: l_qp_qualifiers_rec.search_ind,

2020: l_active_flag,
2021: l_list_type_code,
2022: l_qual_attr_value_from_number,
2023: l_qual_attr_value_to_number,
2024: l_qp_qualifiers_rec.search_ind,
2025: l_qp_qualifiers_rec.distinct_row_count,
2026: l_qp_qualifiers_rec.qualifier_group_cnt,
2027: l_qp_qualifiers_rec.header_quals_exist_flag,
2028: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA

Line 2025: l_qp_qualifiers_rec.distinct_row_count,

2021: l_list_type_code,
2022: l_qual_attr_value_from_number,
2023: l_qual_attr_value_to_number,
2024: l_qp_qualifiers_rec.search_ind,
2025: l_qp_qualifiers_rec.distinct_row_count,
2026: l_qp_qualifiers_rec.qualifier_group_cnt,
2027: l_qp_qualifiers_rec.header_quals_exist_flag,
2028: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
2029: --ENH Upgrade BOAPI for orig_sys...ref RAVI

Line 2026: l_qp_qualifiers_rec.qualifier_group_cnt,

2022: l_qual_attr_value_from_number,
2023: l_qual_attr_value_to_number,
2024: l_qp_qualifiers_rec.search_ind,
2025: l_qp_qualifiers_rec.distinct_row_count,
2026: l_qp_qualifiers_rec.qualifier_group_cnt,
2027: l_qp_qualifiers_rec.header_quals_exist_flag,
2028: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
2029: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2030: ,to_char(l_new_qualifier_id)

Line 2027: l_qp_qualifiers_rec.header_quals_exist_flag,

2023: l_qual_attr_value_to_number,
2024: l_qp_qualifiers_rec.search_ind,
2025: l_qp_qualifiers_rec.distinct_row_count,
2026: l_qp_qualifiers_rec.qualifier_group_cnt,
2027: l_qp_qualifiers_rec.header_quals_exist_flag,
2028: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
2029: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2030: ,to_char(l_new_qualifier_id)
2031: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)

Line 2028: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA

2024: l_qp_qualifiers_rec.search_ind,
2025: l_qp_qualifiers_rec.distinct_row_count,
2026: l_qp_qualifiers_rec.qualifier_group_cnt,
2027: l_qp_qualifiers_rec.header_quals_exist_flag,
2028: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
2029: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2030: ,to_char(l_new_qualifier_id)
2031: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)
2032: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_qp_qualifiers_rec.list_header_id)

Line 2031: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)

2027: l_qp_qualifiers_rec.header_quals_exist_flag,
2028: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
2029: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2030: ,to_char(l_new_qualifier_id)
2031: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)
2032: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_qp_qualifiers_rec.list_header_id)
2033: );
2034:
2035:

Line 2032: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_qp_qualifiers_rec.list_header_id)

2028: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
2029: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2030: ,to_char(l_new_qualifier_id)
2031: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)
2032: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_qp_qualifiers_rec.list_header_id)
2033: );
2034:
2035:
2036: END LOOP;

Line 2867: /* This code will call the API to update the denormalized columns on QP_QUALIFIERS*/

2863:
2864:
2865: Delete_Duplicate_Lines(p_effective_dates_flag, l_new_list_header_id);
2866:
2867: /* This code will call the API to update the denormalized columns on QP_QUALIFIERS*/
2868: QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS
2869: (ERR_BUFF => errbuf,
2870: RETCODE => retcode,
2871: P_LIST_HEADER_ID => l_new_list_header_id,

Line 2878: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');

2874:
2875:
2876: if retcode = 2 then
2877: --error from update denormalized columns
2878: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
2879: else
2880: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');
2881: end if;
2882:

Line 2880: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');

2876: if retcode = 2 then
2877: --error from update denormalized columns
2878: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
2879: else
2880: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');
2881: end if;
2882:
2883:
2884: --Upgrade Non-Continuous Price Breaks