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 346: FROM qp_qualifiers a

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

Line 356: CURSOR qp_qualifiers_cur(p_from_discount_header_id NUMBER)

352: --fix for bug 4673872
353: FROM qp_list_headers_all_b
354: WHERE list_type_code = 'DLT');
355:
356: CURSOR qp_qualifiers_cur(p_from_discount_header_id NUMBER)
357: IS
358: SELECT *
359: FROM qp_qualifiers
360: WHERE list_header_id = p_from_discount_header_id;

Line 359: FROM qp_qualifiers

355:
356: CURSOR qp_qualifiers_cur(p_from_discount_header_id NUMBER)
357: IS
358: SELECT *
359: FROM qp_qualifiers
360: WHERE list_header_id = p_from_discount_header_id;
361:
362: CURSOR qp_discount_lines_cur(p_from_discount_header_id NUMBER)
363: IS

Line 593: FOR l_qp_qualifiers_rec IN

589:
590: /* Copy all qualifiers for the discount and in case of the qualifier
591: being the from-pricelist replace it with the new pricelist*/
592:
593: FOR l_qp_qualifiers_rec IN
594: qp_qualifiers_cur(qp_from_discounts_rec.list_header_id)
595: LOOP
596:
597: --Get new qualifier_id

Line 594: qp_qualifiers_cur(qp_from_discounts_rec.list_header_id)

590: /* Copy all qualifiers for the discount and in case of the qualifier
591: being the from-pricelist replace it with the new pricelist*/
592:
593: FOR l_qp_qualifiers_rec IN
594: qp_qualifiers_cur(qp_from_discounts_rec.list_header_id)
595: LOOP
596:
597: --Get new qualifier_id
598: SELECT qp_qualifiers_s.nextval

Line 598: SELECT qp_qualifiers_s.nextval

594: qp_qualifiers_cur(qp_from_discounts_rec.list_header_id)
595: LOOP
596:
597: --Get new qualifier_id
598: SELECT qp_qualifiers_s.nextval
599: INTO l_new_qualifier_id
600: FROM dual;
601:
602: IF l_qp_qualifiers_rec.qualifier_attr_value =

Line 602: IF l_qp_qualifiers_rec.qualifier_attr_value =

598: SELECT qp_qualifiers_s.nextval
599: INTO l_new_qualifier_id
600: FROM dual;
601:
602: IF l_qp_qualifiers_rec.qualifier_attr_value =
603: TO_CHAR(p_from_list_header_id) AND
604: l_qp_qualifiers_rec.qualifier_context = p_context AND
605: l_qp_qualifiers_rec.qualifier_attribute = p_attribute
606: THEN

Line 604: l_qp_qualifiers_rec.qualifier_context = p_context AND

600: FROM dual;
601:
602: IF l_qp_qualifiers_rec.qualifier_attr_value =
603: TO_CHAR(p_from_list_header_id) AND
604: l_qp_qualifiers_rec.qualifier_context = p_context AND
605: l_qp_qualifiers_rec.qualifier_attribute = p_attribute
606: THEN
607: l_qp_qualifiers_rec.qualifier_attr_value :=
608: TO_CHAR(p_new_list_header_id);

Line 605: l_qp_qualifiers_rec.qualifier_attribute = p_attribute

601:
602: IF l_qp_qualifiers_rec.qualifier_attr_value =
603: TO_CHAR(p_from_list_header_id) AND
604: l_qp_qualifiers_rec.qualifier_context = p_context AND
605: l_qp_qualifiers_rec.qualifier_attribute = p_attribute
606: THEN
607: l_qp_qualifiers_rec.qualifier_attr_value :=
608: TO_CHAR(p_new_list_header_id);
609: END IF;

Line 607: l_qp_qualifiers_rec.qualifier_attr_value :=

603: TO_CHAR(p_from_list_header_id) AND
604: l_qp_qualifiers_rec.qualifier_context = p_context AND
605: l_qp_qualifiers_rec.qualifier_attribute = p_attribute
606: THEN
607: l_qp_qualifiers_rec.qualifier_attr_value :=
608: TO_CHAR(p_new_list_header_id);
609: END IF;
610:
611: BEGIN

Line 624: IF l_qp_qualifiers_rec.qualifier_datatype = 'N'

620: WHEN OTHERS THEN
621: NULL;
622: END;
623:
624: IF l_qp_qualifiers_rec.qualifier_datatype = 'N'
625: then
626:
627: BEGIN
628:

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

626:
627: BEGIN
628:
629: l_qual_attr_value_from_number :=
630: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
631:
632: l_qual_attr_value_to_number :=
633: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
634:

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

629: l_qual_attr_value_from_number :=
630: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
631:
632: l_qual_attr_value_to_number :=
633: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
634:
635: EXCEPTION
636: WHEN VALUE_ERROR THEN
637: NULL;

Line 645: INSERT INTO qp_qualifiers

641:
642: end if;
643:
644: --Insert new qualifier
645: INSERT INTO qp_qualifiers
646: (
647: qualifier_id,
648: creation_date,
649: created_by,

Line 714: l_qp_qualifiers_rec.excluder_flag,

710: p_conc_program_application_id,
711: p_conc_program_id,
712: sysdate,
713: p_conc_request_id,
714: l_qp_qualifiers_rec.excluder_flag,
715: l_qp_qualifiers_rec.comparison_operator_code,
716: l_qp_qualifiers_rec.qualifier_context,
717: l_qp_qualifiers_rec.qualifier_attribute,
718: l_qp_qualifiers_rec.context,

Line 715: l_qp_qualifiers_rec.comparison_operator_code,

711: p_conc_program_id,
712: sysdate,
713: p_conc_request_id,
714: l_qp_qualifiers_rec.excluder_flag,
715: l_qp_qualifiers_rec.comparison_operator_code,
716: l_qp_qualifiers_rec.qualifier_context,
717: l_qp_qualifiers_rec.qualifier_attribute,
718: l_qp_qualifiers_rec.context,
719: l_qp_qualifiers_rec.attribute1,

Line 716: l_qp_qualifiers_rec.qualifier_context,

712: sysdate,
713: p_conc_request_id,
714: l_qp_qualifiers_rec.excluder_flag,
715: l_qp_qualifiers_rec.comparison_operator_code,
716: l_qp_qualifiers_rec.qualifier_context,
717: l_qp_qualifiers_rec.qualifier_attribute,
718: l_qp_qualifiers_rec.context,
719: l_qp_qualifiers_rec.attribute1,
720: l_qp_qualifiers_rec.attribute2,

Line 717: l_qp_qualifiers_rec.qualifier_attribute,

713: p_conc_request_id,
714: l_qp_qualifiers_rec.excluder_flag,
715: l_qp_qualifiers_rec.comparison_operator_code,
716: l_qp_qualifiers_rec.qualifier_context,
717: l_qp_qualifiers_rec.qualifier_attribute,
718: l_qp_qualifiers_rec.context,
719: l_qp_qualifiers_rec.attribute1,
720: l_qp_qualifiers_rec.attribute2,
721: l_qp_qualifiers_rec.attribute3,

Line 718: l_qp_qualifiers_rec.context,

714: l_qp_qualifiers_rec.excluder_flag,
715: l_qp_qualifiers_rec.comparison_operator_code,
716: l_qp_qualifiers_rec.qualifier_context,
717: l_qp_qualifiers_rec.qualifier_attribute,
718: l_qp_qualifiers_rec.context,
719: l_qp_qualifiers_rec.attribute1,
720: l_qp_qualifiers_rec.attribute2,
721: l_qp_qualifiers_rec.attribute3,
722: l_qp_qualifiers_rec.attribute4,

Line 719: l_qp_qualifiers_rec.attribute1,

715: l_qp_qualifiers_rec.comparison_operator_code,
716: l_qp_qualifiers_rec.qualifier_context,
717: l_qp_qualifiers_rec.qualifier_attribute,
718: l_qp_qualifiers_rec.context,
719: l_qp_qualifiers_rec.attribute1,
720: l_qp_qualifiers_rec.attribute2,
721: l_qp_qualifiers_rec.attribute3,
722: l_qp_qualifiers_rec.attribute4,
723: l_qp_qualifiers_rec.attribute5,

Line 720: l_qp_qualifiers_rec.attribute2,

716: l_qp_qualifiers_rec.qualifier_context,
717: l_qp_qualifiers_rec.qualifier_attribute,
718: l_qp_qualifiers_rec.context,
719: l_qp_qualifiers_rec.attribute1,
720: l_qp_qualifiers_rec.attribute2,
721: l_qp_qualifiers_rec.attribute3,
722: l_qp_qualifiers_rec.attribute4,
723: l_qp_qualifiers_rec.attribute5,
724: l_qp_qualifiers_rec.attribute6,

Line 721: l_qp_qualifiers_rec.attribute3,

717: l_qp_qualifiers_rec.qualifier_attribute,
718: l_qp_qualifiers_rec.context,
719: l_qp_qualifiers_rec.attribute1,
720: l_qp_qualifiers_rec.attribute2,
721: l_qp_qualifiers_rec.attribute3,
722: l_qp_qualifiers_rec.attribute4,
723: l_qp_qualifiers_rec.attribute5,
724: l_qp_qualifiers_rec.attribute6,
725: l_qp_qualifiers_rec.attribute7,

Line 722: l_qp_qualifiers_rec.attribute4,

718: l_qp_qualifiers_rec.context,
719: l_qp_qualifiers_rec.attribute1,
720: l_qp_qualifiers_rec.attribute2,
721: l_qp_qualifiers_rec.attribute3,
722: l_qp_qualifiers_rec.attribute4,
723: l_qp_qualifiers_rec.attribute5,
724: l_qp_qualifiers_rec.attribute6,
725: l_qp_qualifiers_rec.attribute7,
726: l_qp_qualifiers_rec.attribute8,

Line 723: l_qp_qualifiers_rec.attribute5,

719: l_qp_qualifiers_rec.attribute1,
720: l_qp_qualifiers_rec.attribute2,
721: l_qp_qualifiers_rec.attribute3,
722: l_qp_qualifiers_rec.attribute4,
723: l_qp_qualifiers_rec.attribute5,
724: l_qp_qualifiers_rec.attribute6,
725: l_qp_qualifiers_rec.attribute7,
726: l_qp_qualifiers_rec.attribute8,
727: l_qp_qualifiers_rec.attribute9,

Line 724: l_qp_qualifiers_rec.attribute6,

720: l_qp_qualifiers_rec.attribute2,
721: l_qp_qualifiers_rec.attribute3,
722: l_qp_qualifiers_rec.attribute4,
723: l_qp_qualifiers_rec.attribute5,
724: l_qp_qualifiers_rec.attribute6,
725: l_qp_qualifiers_rec.attribute7,
726: l_qp_qualifiers_rec.attribute8,
727: l_qp_qualifiers_rec.attribute9,
728: l_qp_qualifiers_rec.attribute10,

Line 725: l_qp_qualifiers_rec.attribute7,

721: l_qp_qualifiers_rec.attribute3,
722: l_qp_qualifiers_rec.attribute4,
723: l_qp_qualifiers_rec.attribute5,
724: l_qp_qualifiers_rec.attribute6,
725: l_qp_qualifiers_rec.attribute7,
726: l_qp_qualifiers_rec.attribute8,
727: l_qp_qualifiers_rec.attribute9,
728: l_qp_qualifiers_rec.attribute10,
729: l_qp_qualifiers_rec.attribute11,

Line 726: l_qp_qualifiers_rec.attribute8,

722: l_qp_qualifiers_rec.attribute4,
723: l_qp_qualifiers_rec.attribute5,
724: l_qp_qualifiers_rec.attribute6,
725: l_qp_qualifiers_rec.attribute7,
726: l_qp_qualifiers_rec.attribute8,
727: l_qp_qualifiers_rec.attribute9,
728: l_qp_qualifiers_rec.attribute10,
729: l_qp_qualifiers_rec.attribute11,
730: l_qp_qualifiers_rec.attribute12,

Line 727: l_qp_qualifiers_rec.attribute9,

723: l_qp_qualifiers_rec.attribute5,
724: l_qp_qualifiers_rec.attribute6,
725: l_qp_qualifiers_rec.attribute7,
726: l_qp_qualifiers_rec.attribute8,
727: l_qp_qualifiers_rec.attribute9,
728: l_qp_qualifiers_rec.attribute10,
729: l_qp_qualifiers_rec.attribute11,
730: l_qp_qualifiers_rec.attribute12,
731: l_qp_qualifiers_rec.attribute13,

Line 728: l_qp_qualifiers_rec.attribute10,

724: l_qp_qualifiers_rec.attribute6,
725: l_qp_qualifiers_rec.attribute7,
726: l_qp_qualifiers_rec.attribute8,
727: l_qp_qualifiers_rec.attribute9,
728: l_qp_qualifiers_rec.attribute10,
729: l_qp_qualifiers_rec.attribute11,
730: l_qp_qualifiers_rec.attribute12,
731: l_qp_qualifiers_rec.attribute13,
732: l_qp_qualifiers_rec.attribute14,

Line 729: l_qp_qualifiers_rec.attribute11,

725: l_qp_qualifiers_rec.attribute7,
726: l_qp_qualifiers_rec.attribute8,
727: l_qp_qualifiers_rec.attribute9,
728: l_qp_qualifiers_rec.attribute10,
729: l_qp_qualifiers_rec.attribute11,
730: l_qp_qualifiers_rec.attribute12,
731: l_qp_qualifiers_rec.attribute13,
732: l_qp_qualifiers_rec.attribute14,
733: l_qp_qualifiers_rec.attribute15,

Line 730: l_qp_qualifiers_rec.attribute12,

726: l_qp_qualifiers_rec.attribute8,
727: l_qp_qualifiers_rec.attribute9,
728: l_qp_qualifiers_rec.attribute10,
729: l_qp_qualifiers_rec.attribute11,
730: l_qp_qualifiers_rec.attribute12,
731: l_qp_qualifiers_rec.attribute13,
732: l_qp_qualifiers_rec.attribute14,
733: l_qp_qualifiers_rec.attribute15,
734: l_qp_qualifiers_rec.qualifier_rule_id,

Line 731: l_qp_qualifiers_rec.attribute13,

727: l_qp_qualifiers_rec.attribute9,
728: l_qp_qualifiers_rec.attribute10,
729: l_qp_qualifiers_rec.attribute11,
730: l_qp_qualifiers_rec.attribute12,
731: l_qp_qualifiers_rec.attribute13,
732: l_qp_qualifiers_rec.attribute14,
733: l_qp_qualifiers_rec.attribute15,
734: l_qp_qualifiers_rec.qualifier_rule_id,
735: l_qp_qualifiers_rec.qualifier_grouping_no,

Line 732: l_qp_qualifiers_rec.attribute14,

728: l_qp_qualifiers_rec.attribute10,
729: l_qp_qualifiers_rec.attribute11,
730: l_qp_qualifiers_rec.attribute12,
731: l_qp_qualifiers_rec.attribute13,
732: l_qp_qualifiers_rec.attribute14,
733: l_qp_qualifiers_rec.attribute15,
734: l_qp_qualifiers_rec.qualifier_rule_id,
735: l_qp_qualifiers_rec.qualifier_grouping_no,
736: l_qp_qualifiers_rec.qualifier_attr_value,

Line 733: l_qp_qualifiers_rec.attribute15,

729: l_qp_qualifiers_rec.attribute11,
730: l_qp_qualifiers_rec.attribute12,
731: l_qp_qualifiers_rec.attribute13,
732: l_qp_qualifiers_rec.attribute14,
733: l_qp_qualifiers_rec.attribute15,
734: l_qp_qualifiers_rec.qualifier_rule_id,
735: l_qp_qualifiers_rec.qualifier_grouping_no,
736: l_qp_qualifiers_rec.qualifier_attr_value,
737: l_new_discount_header_id,

Line 734: l_qp_qualifiers_rec.qualifier_rule_id,

730: l_qp_qualifiers_rec.attribute12,
731: l_qp_qualifiers_rec.attribute13,
732: l_qp_qualifiers_rec.attribute14,
733: l_qp_qualifiers_rec.attribute15,
734: l_qp_qualifiers_rec.qualifier_rule_id,
735: l_qp_qualifiers_rec.qualifier_grouping_no,
736: l_qp_qualifiers_rec.qualifier_attr_value,
737: l_new_discount_header_id,
738: l_qp_qualifiers_rec.list_line_id,

Line 735: l_qp_qualifiers_rec.qualifier_grouping_no,

731: l_qp_qualifiers_rec.attribute13,
732: l_qp_qualifiers_rec.attribute14,
733: l_qp_qualifiers_rec.attribute15,
734: l_qp_qualifiers_rec.qualifier_rule_id,
735: l_qp_qualifiers_rec.qualifier_grouping_no,
736: l_qp_qualifiers_rec.qualifier_attr_value,
737: l_new_discount_header_id,
738: l_qp_qualifiers_rec.list_line_id,
739: l_qp_qualifiers_rec.created_from_rule_id,

Line 736: l_qp_qualifiers_rec.qualifier_attr_value,

732: l_qp_qualifiers_rec.attribute14,
733: l_qp_qualifiers_rec.attribute15,
734: l_qp_qualifiers_rec.qualifier_rule_id,
735: l_qp_qualifiers_rec.qualifier_grouping_no,
736: l_qp_qualifiers_rec.qualifier_attr_value,
737: l_new_discount_header_id,
738: l_qp_qualifiers_rec.list_line_id,
739: l_qp_qualifiers_rec.created_from_rule_id,
740: l_qp_qualifiers_rec.start_date_active,

Line 738: l_qp_qualifiers_rec.list_line_id,

734: l_qp_qualifiers_rec.qualifier_rule_id,
735: l_qp_qualifiers_rec.qualifier_grouping_no,
736: l_qp_qualifiers_rec.qualifier_attr_value,
737: l_new_discount_header_id,
738: l_qp_qualifiers_rec.list_line_id,
739: l_qp_qualifiers_rec.created_from_rule_id,
740: l_qp_qualifiers_rec.start_date_active,
741: l_qp_qualifiers_rec.end_date_active,
742: l_qp_qualifiers_rec.qualifier_precedence,

Line 739: l_qp_qualifiers_rec.created_from_rule_id,

735: l_qp_qualifiers_rec.qualifier_grouping_no,
736: l_qp_qualifiers_rec.qualifier_attr_value,
737: l_new_discount_header_id,
738: l_qp_qualifiers_rec.list_line_id,
739: l_qp_qualifiers_rec.created_from_rule_id,
740: l_qp_qualifiers_rec.start_date_active,
741: l_qp_qualifiers_rec.end_date_active,
742: l_qp_qualifiers_rec.qualifier_precedence,
743: l_qp_qualifiers_rec.qualifier_datatype,

Line 740: l_qp_qualifiers_rec.start_date_active,

736: l_qp_qualifiers_rec.qualifier_attr_value,
737: l_new_discount_header_id,
738: l_qp_qualifiers_rec.list_line_id,
739: l_qp_qualifiers_rec.created_from_rule_id,
740: l_qp_qualifiers_rec.start_date_active,
741: l_qp_qualifiers_rec.end_date_active,
742: l_qp_qualifiers_rec.qualifier_precedence,
743: l_qp_qualifiers_rec.qualifier_datatype,
744: l_qp_qualifiers_rec.qualifier_attr_value_to,

Line 741: l_qp_qualifiers_rec.end_date_active,

737: l_new_discount_header_id,
738: l_qp_qualifiers_rec.list_line_id,
739: l_qp_qualifiers_rec.created_from_rule_id,
740: l_qp_qualifiers_rec.start_date_active,
741: l_qp_qualifiers_rec.end_date_active,
742: l_qp_qualifiers_rec.qualifier_precedence,
743: l_qp_qualifiers_rec.qualifier_datatype,
744: l_qp_qualifiers_rec.qualifier_attr_value_to,
745: l_active_flag,

Line 742: l_qp_qualifiers_rec.qualifier_precedence,

738: l_qp_qualifiers_rec.list_line_id,
739: l_qp_qualifiers_rec.created_from_rule_id,
740: l_qp_qualifiers_rec.start_date_active,
741: l_qp_qualifiers_rec.end_date_active,
742: l_qp_qualifiers_rec.qualifier_precedence,
743: l_qp_qualifiers_rec.qualifier_datatype,
744: l_qp_qualifiers_rec.qualifier_attr_value_to,
745: l_active_flag,
746: l_list_type_code,

Line 743: l_qp_qualifiers_rec.qualifier_datatype,

739: l_qp_qualifiers_rec.created_from_rule_id,
740: l_qp_qualifiers_rec.start_date_active,
741: l_qp_qualifiers_rec.end_date_active,
742: l_qp_qualifiers_rec.qualifier_precedence,
743: l_qp_qualifiers_rec.qualifier_datatype,
744: l_qp_qualifiers_rec.qualifier_attr_value_to,
745: l_active_flag,
746: l_list_type_code,
747: l_qual_attr_value_from_number,

Line 744: l_qp_qualifiers_rec.qualifier_attr_value_to,

740: l_qp_qualifiers_rec.start_date_active,
741: l_qp_qualifiers_rec.end_date_active,
742: l_qp_qualifiers_rec.qualifier_precedence,
743: l_qp_qualifiers_rec.qualifier_datatype,
744: l_qp_qualifiers_rec.qualifier_attr_value_to,
745: l_active_flag,
746: l_list_type_code,
747: l_qual_attr_value_from_number,
748: l_qual_attr_value_to_number,

Line 749: l_qp_qualifiers_rec.search_ind,

745: l_active_flag,
746: l_list_type_code,
747: l_qual_attr_value_from_number,
748: l_qual_attr_value_to_number,
749: l_qp_qualifiers_rec.search_ind,
750: l_qp_qualifiers_rec.distinct_row_count,
751: l_qp_qualifiers_rec.qualifier_group_cnt,
752: l_qp_qualifiers_rec.header_quals_exist_flag,
753: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA

Line 750: l_qp_qualifiers_rec.distinct_row_count,

746: l_list_type_code,
747: l_qual_attr_value_from_number,
748: l_qual_attr_value_to_number,
749: l_qp_qualifiers_rec.search_ind,
750: l_qp_qualifiers_rec.distinct_row_count,
751: l_qp_qualifiers_rec.qualifier_group_cnt,
752: l_qp_qualifiers_rec.header_quals_exist_flag,
753: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
754: --ENH Upgrade BOAPI for orig_sys...ref RAVI

Line 751: l_qp_qualifiers_rec.qualifier_group_cnt,

747: l_qual_attr_value_from_number,
748: l_qual_attr_value_to_number,
749: l_qp_qualifiers_rec.search_ind,
750: l_qp_qualifiers_rec.distinct_row_count,
751: l_qp_qualifiers_rec.qualifier_group_cnt,
752: l_qp_qualifiers_rec.header_quals_exist_flag,
753: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
754: --ENH Upgrade BOAPI for orig_sys...ref RAVI
755: ,to_char(l_new_qualifier_id)

Line 752: l_qp_qualifiers_rec.header_quals_exist_flag,

748: l_qual_attr_value_to_number,
749: l_qp_qualifiers_rec.search_ind,
750: l_qp_qualifiers_rec.distinct_row_count,
751: l_qp_qualifiers_rec.qualifier_group_cnt,
752: l_qp_qualifiers_rec.header_quals_exist_flag,
753: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
754: --ENH Upgrade BOAPI for orig_sys...ref RAVI
755: ,to_char(l_new_qualifier_id)
756: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)

Line 753: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA

749: l_qp_qualifiers_rec.search_ind,
750: l_qp_qualifiers_rec.distinct_row_count,
751: l_qp_qualifiers_rec.qualifier_group_cnt,
752: l_qp_qualifiers_rec.header_quals_exist_flag,
753: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
754: --ENH Upgrade BOAPI for orig_sys...ref RAVI
755: ,to_char(l_new_qualifier_id)
756: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)
757: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)

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

752: l_qp_qualifiers_rec.header_quals_exist_flag,
753: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
754: --ENH Upgrade BOAPI for orig_sys...ref RAVI
755: ,to_char(l_new_qualifier_id)
756: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)
757: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)
758: );
759:
760: END LOOP; /* For copying qualifiers */

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

1386: SELECT *
1387: FROM qp_pricing_attributes
1388: WHERE list_line_id = p_from_list_line_id;
1389:
1390: /* First part of cursor qp_qualifiers_cur selects qualifiers while the second part
1391: selects secondary price list */
1392:
1393: CURSOR qp_qualifiers_cur(p_from_list_header_id NUMBER, p_context VARCHAR2,
1394: p_attribute VARCHAR2, p_discount_flag VARCHAR2)

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

1389:
1390: /* First part of cursor qp_qualifiers_cur selects qualifiers while the second part
1391: selects secondary price list */
1392:
1393: CURSOR qp_qualifiers_cur(p_from_list_header_id NUMBER, p_context VARCHAR2,
1394: p_attribute VARCHAR2, p_discount_flag VARCHAR2)
1395: IS
1396: SELECT *
1397: FROM qp_qualifiers q

Line 1397: FROM qp_qualifiers q

1393: CURSOR qp_qualifiers_cur(p_from_list_header_id NUMBER, p_context VARCHAR2,
1394: p_attribute VARCHAR2, p_discount_flag VARCHAR2)
1395: IS
1396: SELECT *
1397: FROM qp_qualifiers q
1398: WHERE (q.list_header_id = p_from_list_header_id AND
1399: q.qualifier_attribute <> p_attribute AND --Added for 2200425
1400: Exists (Select Null
1401: --fix for bug 4673872

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

1676: ELSE
1677: QP_UTIL.Get_Context_Attribute('PRICE_LIST_ID', l_context, l_attribute);
1678: END IF;
1679:
1680: FOR l_qp_qualifiers_rec IN qp_qualifiers_cur(p_from_list_header_id, l_context,
1681: l_attribute, p_discount_flag)
1682: LOOP
1683:
1684: --Get new qualifier_id

Line 1685: SELECT qp_qualifiers_s.nextval

1681: l_attribute, p_discount_flag)
1682: LOOP
1683:
1684: --Get new qualifier_id
1685: SELECT qp_qualifiers_s.nextval
1686: INTO l_new_qualifier_id
1687: FROM dual;
1688:
1689: --To associate newly copied qualifiers (including secondary pricelists)

Line 1691: IF p_from_list_header_id = l_qp_qualifiers_rec.list_header_id THEN

1687: FROM dual;
1688:
1689: --To associate newly copied qualifiers (including secondary pricelists)
1690: --to the new price list
1691: IF p_from_list_header_id = l_qp_qualifiers_rec.list_header_id THEN
1692: l_qp_qualifiers_rec.list_header_id := l_new_list_header_id;
1693: END IF;
1694:
1695: --If From PriceList is Self-Qualifier

Line 1692: l_qp_qualifiers_rec.list_header_id := l_new_list_header_id;

1688:
1689: --To associate newly copied qualifiers (including secondary pricelists)
1690: --to the new price list
1691: IF p_from_list_header_id = l_qp_qualifiers_rec.list_header_id THEN
1692: l_qp_qualifiers_rec.list_header_id := l_new_list_header_id;
1693: END IF;
1694:
1695: --If From PriceList is Self-Qualifier
1696: IF l_qp_qualifiers_rec.qualifier_context = l_context AND

Line 1696: IF l_qp_qualifiers_rec.qualifier_context = l_context AND

1692: l_qp_qualifiers_rec.list_header_id := l_new_list_header_id;
1693: END IF;
1694:
1695: --If From PriceList is Self-Qualifier
1696: IF l_qp_qualifiers_rec.qualifier_context = l_context AND
1697: l_qp_qualifiers_rec.qualifier_attribute = l_attribute AND
1698: l_qp_qualifiers_rec.qualifier_attr_value = TO_CHAR(p_from_list_header_id)
1699: THEN
1700: l_qp_qualifiers_rec.qualifier_attr_value := TO_CHAR(l_new_list_header_id);

Line 1697: l_qp_qualifiers_rec.qualifier_attribute = l_attribute AND

1693: END IF;
1694:
1695: --If From PriceList is Self-Qualifier
1696: IF l_qp_qualifiers_rec.qualifier_context = l_context AND
1697: l_qp_qualifiers_rec.qualifier_attribute = l_attribute AND
1698: l_qp_qualifiers_rec.qualifier_attr_value = TO_CHAR(p_from_list_header_id)
1699: THEN
1700: l_qp_qualifiers_rec.qualifier_attr_value := TO_CHAR(l_new_list_header_id);
1701: END IF;

Line 1698: l_qp_qualifiers_rec.qualifier_attr_value = TO_CHAR(p_from_list_header_id)

1694:
1695: --If From PriceList is Self-Qualifier
1696: IF l_qp_qualifiers_rec.qualifier_context = l_context AND
1697: l_qp_qualifiers_rec.qualifier_attribute = l_attribute AND
1698: l_qp_qualifiers_rec.qualifier_attr_value = TO_CHAR(p_from_list_header_id)
1699: THEN
1700: l_qp_qualifiers_rec.qualifier_attr_value := TO_CHAR(l_new_list_header_id);
1701: END IF;
1702:

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

1696: IF l_qp_qualifiers_rec.qualifier_context = l_context AND
1697: l_qp_qualifiers_rec.qualifier_attribute = l_attribute AND
1698: l_qp_qualifiers_rec.qualifier_attr_value = TO_CHAR(p_from_list_header_id)
1699: THEN
1700: l_qp_qualifiers_rec.qualifier_attr_value := TO_CHAR(l_new_list_header_id);
1701: END IF;
1702:
1703: BEGIN
1704:

Line 1709: WHERE LIST_HEADER_ID = l_qp_qualifiers_rec.list_header_id;

1705: SELECT ACTIVE_FLAG, LIST_TYPE_CODE
1706: INTO l_active_flag, l_list_type_code
1707: --fix for bug 4673872
1708: FROM QP_LIST_HEADERS_ALL_B
1709: WHERE LIST_HEADER_ID = l_qp_qualifiers_rec.list_header_id;
1710:
1711: EXCEPTION
1712: WHEN OTHERS THEN
1713: NULL;

Line 1716: IF l_qp_qualifiers_rec.qualifier_datatype = 'N'

1712: WHEN OTHERS THEN
1713: NULL;
1714: END;
1715:
1716: IF l_qp_qualifiers_rec.qualifier_datatype = 'N'
1717: then
1718:
1719: BEGIN
1720:

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

1718:
1719: BEGIN
1720:
1721: l_qual_attr_value_from_number :=
1722: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1723:
1724: l_qual_attr_value_to_number :=
1725: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1726:

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

1721: l_qual_attr_value_from_number :=
1722: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1723:
1724: l_qual_attr_value_to_number :=
1725: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1726:
1727: EXCEPTION
1728: WHEN VALUE_ERROR THEN
1729: NULL;

Line 1736: --Insert into qp_qualifiers

1732: END;
1733:
1734: end if;
1735:
1736: --Insert into qp_qualifiers
1737: INSERT INTO qp_qualifiers
1738: (
1739: qualifier_id,
1740: creation_date,

Line 1737: INSERT INTO qp_qualifiers

1733:
1734: end if;
1735:
1736: --Insert into qp_qualifiers
1737: INSERT INTO qp_qualifiers
1738: (
1739: qualifier_id,
1740: creation_date,
1741: created_by,

Line 1806: l_qp_qualifiers_rec.excluder_flag,

1802: l_conc_program_application_id,
1803: l_conc_program_id,
1804: sysdate,
1805: l_conc_request_id,
1806: l_qp_qualifiers_rec.excluder_flag,
1807: l_qp_qualifiers_rec.comparison_operator_code,
1808: l_qp_qualifiers_rec.qualifier_context,
1809: l_qp_qualifiers_rec.qualifier_attribute,
1810: l_qp_qualifiers_rec.context,

Line 1807: l_qp_qualifiers_rec.comparison_operator_code,

1803: l_conc_program_id,
1804: sysdate,
1805: l_conc_request_id,
1806: l_qp_qualifiers_rec.excluder_flag,
1807: l_qp_qualifiers_rec.comparison_operator_code,
1808: l_qp_qualifiers_rec.qualifier_context,
1809: l_qp_qualifiers_rec.qualifier_attribute,
1810: l_qp_qualifiers_rec.context,
1811: l_qp_qualifiers_rec.attribute1,

Line 1808: l_qp_qualifiers_rec.qualifier_context,

1804: sysdate,
1805: l_conc_request_id,
1806: l_qp_qualifiers_rec.excluder_flag,
1807: l_qp_qualifiers_rec.comparison_operator_code,
1808: l_qp_qualifiers_rec.qualifier_context,
1809: l_qp_qualifiers_rec.qualifier_attribute,
1810: l_qp_qualifiers_rec.context,
1811: l_qp_qualifiers_rec.attribute1,
1812: l_qp_qualifiers_rec.attribute2,

Line 1809: l_qp_qualifiers_rec.qualifier_attribute,

1805: l_conc_request_id,
1806: l_qp_qualifiers_rec.excluder_flag,
1807: l_qp_qualifiers_rec.comparison_operator_code,
1808: l_qp_qualifiers_rec.qualifier_context,
1809: l_qp_qualifiers_rec.qualifier_attribute,
1810: l_qp_qualifiers_rec.context,
1811: l_qp_qualifiers_rec.attribute1,
1812: l_qp_qualifiers_rec.attribute2,
1813: l_qp_qualifiers_rec.attribute3,

Line 1810: l_qp_qualifiers_rec.context,

1806: l_qp_qualifiers_rec.excluder_flag,
1807: l_qp_qualifiers_rec.comparison_operator_code,
1808: l_qp_qualifiers_rec.qualifier_context,
1809: l_qp_qualifiers_rec.qualifier_attribute,
1810: l_qp_qualifiers_rec.context,
1811: l_qp_qualifiers_rec.attribute1,
1812: l_qp_qualifiers_rec.attribute2,
1813: l_qp_qualifiers_rec.attribute3,
1814: l_qp_qualifiers_rec.attribute4,

Line 1811: l_qp_qualifiers_rec.attribute1,

1807: l_qp_qualifiers_rec.comparison_operator_code,
1808: l_qp_qualifiers_rec.qualifier_context,
1809: l_qp_qualifiers_rec.qualifier_attribute,
1810: l_qp_qualifiers_rec.context,
1811: l_qp_qualifiers_rec.attribute1,
1812: l_qp_qualifiers_rec.attribute2,
1813: l_qp_qualifiers_rec.attribute3,
1814: l_qp_qualifiers_rec.attribute4,
1815: l_qp_qualifiers_rec.attribute5,

Line 1812: l_qp_qualifiers_rec.attribute2,

1808: l_qp_qualifiers_rec.qualifier_context,
1809: l_qp_qualifiers_rec.qualifier_attribute,
1810: l_qp_qualifiers_rec.context,
1811: l_qp_qualifiers_rec.attribute1,
1812: l_qp_qualifiers_rec.attribute2,
1813: l_qp_qualifiers_rec.attribute3,
1814: l_qp_qualifiers_rec.attribute4,
1815: l_qp_qualifiers_rec.attribute5,
1816: l_qp_qualifiers_rec.attribute6,

Line 1813: l_qp_qualifiers_rec.attribute3,

1809: l_qp_qualifiers_rec.qualifier_attribute,
1810: l_qp_qualifiers_rec.context,
1811: l_qp_qualifiers_rec.attribute1,
1812: l_qp_qualifiers_rec.attribute2,
1813: l_qp_qualifiers_rec.attribute3,
1814: l_qp_qualifiers_rec.attribute4,
1815: l_qp_qualifiers_rec.attribute5,
1816: l_qp_qualifiers_rec.attribute6,
1817: l_qp_qualifiers_rec.attribute7,

Line 1814: l_qp_qualifiers_rec.attribute4,

1810: l_qp_qualifiers_rec.context,
1811: l_qp_qualifiers_rec.attribute1,
1812: l_qp_qualifiers_rec.attribute2,
1813: l_qp_qualifiers_rec.attribute3,
1814: l_qp_qualifiers_rec.attribute4,
1815: l_qp_qualifiers_rec.attribute5,
1816: l_qp_qualifiers_rec.attribute6,
1817: l_qp_qualifiers_rec.attribute7,
1818: l_qp_qualifiers_rec.attribute8,

Line 1815: l_qp_qualifiers_rec.attribute5,

1811: l_qp_qualifiers_rec.attribute1,
1812: l_qp_qualifiers_rec.attribute2,
1813: l_qp_qualifiers_rec.attribute3,
1814: l_qp_qualifiers_rec.attribute4,
1815: l_qp_qualifiers_rec.attribute5,
1816: l_qp_qualifiers_rec.attribute6,
1817: l_qp_qualifiers_rec.attribute7,
1818: l_qp_qualifiers_rec.attribute8,
1819: l_qp_qualifiers_rec.attribute9,

Line 1816: l_qp_qualifiers_rec.attribute6,

1812: l_qp_qualifiers_rec.attribute2,
1813: l_qp_qualifiers_rec.attribute3,
1814: l_qp_qualifiers_rec.attribute4,
1815: l_qp_qualifiers_rec.attribute5,
1816: l_qp_qualifiers_rec.attribute6,
1817: l_qp_qualifiers_rec.attribute7,
1818: l_qp_qualifiers_rec.attribute8,
1819: l_qp_qualifiers_rec.attribute9,
1820: l_qp_qualifiers_rec.attribute10,

Line 1817: l_qp_qualifiers_rec.attribute7,

1813: l_qp_qualifiers_rec.attribute3,
1814: l_qp_qualifiers_rec.attribute4,
1815: l_qp_qualifiers_rec.attribute5,
1816: l_qp_qualifiers_rec.attribute6,
1817: l_qp_qualifiers_rec.attribute7,
1818: l_qp_qualifiers_rec.attribute8,
1819: l_qp_qualifiers_rec.attribute9,
1820: l_qp_qualifiers_rec.attribute10,
1821: l_qp_qualifiers_rec.attribute11,

Line 1818: l_qp_qualifiers_rec.attribute8,

1814: l_qp_qualifiers_rec.attribute4,
1815: l_qp_qualifiers_rec.attribute5,
1816: l_qp_qualifiers_rec.attribute6,
1817: l_qp_qualifiers_rec.attribute7,
1818: l_qp_qualifiers_rec.attribute8,
1819: l_qp_qualifiers_rec.attribute9,
1820: l_qp_qualifiers_rec.attribute10,
1821: l_qp_qualifiers_rec.attribute11,
1822: l_qp_qualifiers_rec.attribute12,

Line 1819: l_qp_qualifiers_rec.attribute9,

1815: l_qp_qualifiers_rec.attribute5,
1816: l_qp_qualifiers_rec.attribute6,
1817: l_qp_qualifiers_rec.attribute7,
1818: l_qp_qualifiers_rec.attribute8,
1819: l_qp_qualifiers_rec.attribute9,
1820: l_qp_qualifiers_rec.attribute10,
1821: l_qp_qualifiers_rec.attribute11,
1822: l_qp_qualifiers_rec.attribute12,
1823: l_qp_qualifiers_rec.attribute13,

Line 1820: l_qp_qualifiers_rec.attribute10,

1816: l_qp_qualifiers_rec.attribute6,
1817: l_qp_qualifiers_rec.attribute7,
1818: l_qp_qualifiers_rec.attribute8,
1819: l_qp_qualifiers_rec.attribute9,
1820: l_qp_qualifiers_rec.attribute10,
1821: l_qp_qualifiers_rec.attribute11,
1822: l_qp_qualifiers_rec.attribute12,
1823: l_qp_qualifiers_rec.attribute13,
1824: l_qp_qualifiers_rec.attribute14,

Line 1821: l_qp_qualifiers_rec.attribute11,

1817: l_qp_qualifiers_rec.attribute7,
1818: l_qp_qualifiers_rec.attribute8,
1819: l_qp_qualifiers_rec.attribute9,
1820: l_qp_qualifiers_rec.attribute10,
1821: l_qp_qualifiers_rec.attribute11,
1822: l_qp_qualifiers_rec.attribute12,
1823: l_qp_qualifiers_rec.attribute13,
1824: l_qp_qualifiers_rec.attribute14,
1825: l_qp_qualifiers_rec.attribute15,

Line 1822: l_qp_qualifiers_rec.attribute12,

1818: l_qp_qualifiers_rec.attribute8,
1819: l_qp_qualifiers_rec.attribute9,
1820: l_qp_qualifiers_rec.attribute10,
1821: l_qp_qualifiers_rec.attribute11,
1822: l_qp_qualifiers_rec.attribute12,
1823: l_qp_qualifiers_rec.attribute13,
1824: l_qp_qualifiers_rec.attribute14,
1825: l_qp_qualifiers_rec.attribute15,
1826: l_qp_qualifiers_rec.qualifier_rule_id,

Line 1823: l_qp_qualifiers_rec.attribute13,

1819: l_qp_qualifiers_rec.attribute9,
1820: l_qp_qualifiers_rec.attribute10,
1821: l_qp_qualifiers_rec.attribute11,
1822: l_qp_qualifiers_rec.attribute12,
1823: l_qp_qualifiers_rec.attribute13,
1824: l_qp_qualifiers_rec.attribute14,
1825: l_qp_qualifiers_rec.attribute15,
1826: l_qp_qualifiers_rec.qualifier_rule_id,
1827: l_qp_qualifiers_rec.qualifier_grouping_no,

Line 1824: l_qp_qualifiers_rec.attribute14,

1820: l_qp_qualifiers_rec.attribute10,
1821: l_qp_qualifiers_rec.attribute11,
1822: l_qp_qualifiers_rec.attribute12,
1823: l_qp_qualifiers_rec.attribute13,
1824: l_qp_qualifiers_rec.attribute14,
1825: l_qp_qualifiers_rec.attribute15,
1826: l_qp_qualifiers_rec.qualifier_rule_id,
1827: l_qp_qualifiers_rec.qualifier_grouping_no,
1828: l_qp_qualifiers_rec.qualifier_attr_value,

Line 1825: l_qp_qualifiers_rec.attribute15,

1821: l_qp_qualifiers_rec.attribute11,
1822: l_qp_qualifiers_rec.attribute12,
1823: l_qp_qualifiers_rec.attribute13,
1824: l_qp_qualifiers_rec.attribute14,
1825: l_qp_qualifiers_rec.attribute15,
1826: l_qp_qualifiers_rec.qualifier_rule_id,
1827: l_qp_qualifiers_rec.qualifier_grouping_no,
1828: l_qp_qualifiers_rec.qualifier_attr_value,
1829: l_qp_qualifiers_rec.list_header_id,

Line 1826: l_qp_qualifiers_rec.qualifier_rule_id,

1822: l_qp_qualifiers_rec.attribute12,
1823: l_qp_qualifiers_rec.attribute13,
1824: l_qp_qualifiers_rec.attribute14,
1825: l_qp_qualifiers_rec.attribute15,
1826: l_qp_qualifiers_rec.qualifier_rule_id,
1827: l_qp_qualifiers_rec.qualifier_grouping_no,
1828: l_qp_qualifiers_rec.qualifier_attr_value,
1829: l_qp_qualifiers_rec.list_header_id,
1830: l_qp_qualifiers_rec.list_line_id,

Line 1827: l_qp_qualifiers_rec.qualifier_grouping_no,

1823: l_qp_qualifiers_rec.attribute13,
1824: l_qp_qualifiers_rec.attribute14,
1825: l_qp_qualifiers_rec.attribute15,
1826: l_qp_qualifiers_rec.qualifier_rule_id,
1827: l_qp_qualifiers_rec.qualifier_grouping_no,
1828: l_qp_qualifiers_rec.qualifier_attr_value,
1829: l_qp_qualifiers_rec.list_header_id,
1830: l_qp_qualifiers_rec.list_line_id,
1831: l_qp_qualifiers_rec.created_from_rule_id,

Line 1828: l_qp_qualifiers_rec.qualifier_attr_value,

1824: l_qp_qualifiers_rec.attribute14,
1825: l_qp_qualifiers_rec.attribute15,
1826: l_qp_qualifiers_rec.qualifier_rule_id,
1827: l_qp_qualifiers_rec.qualifier_grouping_no,
1828: l_qp_qualifiers_rec.qualifier_attr_value,
1829: l_qp_qualifiers_rec.list_header_id,
1830: l_qp_qualifiers_rec.list_line_id,
1831: l_qp_qualifiers_rec.created_from_rule_id,
1832: l_qp_qualifiers_rec.start_date_active,

Line 1829: l_qp_qualifiers_rec.list_header_id,

1825: l_qp_qualifiers_rec.attribute15,
1826: l_qp_qualifiers_rec.qualifier_rule_id,
1827: l_qp_qualifiers_rec.qualifier_grouping_no,
1828: l_qp_qualifiers_rec.qualifier_attr_value,
1829: l_qp_qualifiers_rec.list_header_id,
1830: l_qp_qualifiers_rec.list_line_id,
1831: l_qp_qualifiers_rec.created_from_rule_id,
1832: l_qp_qualifiers_rec.start_date_active,
1833: l_qp_qualifiers_rec.end_date_active,

Line 1830: l_qp_qualifiers_rec.list_line_id,

1826: l_qp_qualifiers_rec.qualifier_rule_id,
1827: l_qp_qualifiers_rec.qualifier_grouping_no,
1828: l_qp_qualifiers_rec.qualifier_attr_value,
1829: l_qp_qualifiers_rec.list_header_id,
1830: l_qp_qualifiers_rec.list_line_id,
1831: l_qp_qualifiers_rec.created_from_rule_id,
1832: l_qp_qualifiers_rec.start_date_active,
1833: l_qp_qualifiers_rec.end_date_active,
1834: l_qp_qualifiers_rec.qualifier_precedence,

Line 1831: l_qp_qualifiers_rec.created_from_rule_id,

1827: l_qp_qualifiers_rec.qualifier_grouping_no,
1828: l_qp_qualifiers_rec.qualifier_attr_value,
1829: l_qp_qualifiers_rec.list_header_id,
1830: l_qp_qualifiers_rec.list_line_id,
1831: l_qp_qualifiers_rec.created_from_rule_id,
1832: l_qp_qualifiers_rec.start_date_active,
1833: l_qp_qualifiers_rec.end_date_active,
1834: l_qp_qualifiers_rec.qualifier_precedence,
1835: l_qp_qualifiers_rec.qualifier_datatype,

Line 1832: l_qp_qualifiers_rec.start_date_active,

1828: l_qp_qualifiers_rec.qualifier_attr_value,
1829: l_qp_qualifiers_rec.list_header_id,
1830: l_qp_qualifiers_rec.list_line_id,
1831: l_qp_qualifiers_rec.created_from_rule_id,
1832: l_qp_qualifiers_rec.start_date_active,
1833: l_qp_qualifiers_rec.end_date_active,
1834: l_qp_qualifiers_rec.qualifier_precedence,
1835: l_qp_qualifiers_rec.qualifier_datatype,
1836: l_qp_qualifiers_rec.qualifier_attr_value_to,

Line 1833: l_qp_qualifiers_rec.end_date_active,

1829: l_qp_qualifiers_rec.list_header_id,
1830: l_qp_qualifiers_rec.list_line_id,
1831: l_qp_qualifiers_rec.created_from_rule_id,
1832: l_qp_qualifiers_rec.start_date_active,
1833: l_qp_qualifiers_rec.end_date_active,
1834: l_qp_qualifiers_rec.qualifier_precedence,
1835: l_qp_qualifiers_rec.qualifier_datatype,
1836: l_qp_qualifiers_rec.qualifier_attr_value_to,
1837: l_active_flag,

Line 1834: l_qp_qualifiers_rec.qualifier_precedence,

1830: l_qp_qualifiers_rec.list_line_id,
1831: l_qp_qualifiers_rec.created_from_rule_id,
1832: l_qp_qualifiers_rec.start_date_active,
1833: l_qp_qualifiers_rec.end_date_active,
1834: l_qp_qualifiers_rec.qualifier_precedence,
1835: l_qp_qualifiers_rec.qualifier_datatype,
1836: l_qp_qualifiers_rec.qualifier_attr_value_to,
1837: l_active_flag,
1838: l_list_type_code,

Line 1835: l_qp_qualifiers_rec.qualifier_datatype,

1831: l_qp_qualifiers_rec.created_from_rule_id,
1832: l_qp_qualifiers_rec.start_date_active,
1833: l_qp_qualifiers_rec.end_date_active,
1834: l_qp_qualifiers_rec.qualifier_precedence,
1835: l_qp_qualifiers_rec.qualifier_datatype,
1836: l_qp_qualifiers_rec.qualifier_attr_value_to,
1837: l_active_flag,
1838: l_list_type_code,
1839: l_qual_attr_value_from_number,

Line 1836: l_qp_qualifiers_rec.qualifier_attr_value_to,

1832: l_qp_qualifiers_rec.start_date_active,
1833: l_qp_qualifiers_rec.end_date_active,
1834: l_qp_qualifiers_rec.qualifier_precedence,
1835: l_qp_qualifiers_rec.qualifier_datatype,
1836: l_qp_qualifiers_rec.qualifier_attr_value_to,
1837: l_active_flag,
1838: l_list_type_code,
1839: l_qual_attr_value_from_number,
1840: l_qual_attr_value_to_number,

Line 1841: l_qp_qualifiers_rec.search_ind,

1837: l_active_flag,
1838: l_list_type_code,
1839: l_qual_attr_value_from_number,
1840: l_qual_attr_value_to_number,
1841: l_qp_qualifiers_rec.search_ind,
1842: l_qp_qualifiers_rec.distinct_row_count,
1843: l_qp_qualifiers_rec.qualifier_group_cnt,
1844: l_qp_qualifiers_rec.header_quals_exist_flag,
1845: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA

Line 1842: l_qp_qualifiers_rec.distinct_row_count,

1838: l_list_type_code,
1839: l_qual_attr_value_from_number,
1840: l_qual_attr_value_to_number,
1841: l_qp_qualifiers_rec.search_ind,
1842: l_qp_qualifiers_rec.distinct_row_count,
1843: l_qp_qualifiers_rec.qualifier_group_cnt,
1844: l_qp_qualifiers_rec.header_quals_exist_flag,
1845: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
1846: --ENH Upgrade BOAPI for orig_sys...ref RAVI

Line 1843: l_qp_qualifiers_rec.qualifier_group_cnt,

1839: l_qual_attr_value_from_number,
1840: l_qual_attr_value_to_number,
1841: l_qp_qualifiers_rec.search_ind,
1842: l_qp_qualifiers_rec.distinct_row_count,
1843: l_qp_qualifiers_rec.qualifier_group_cnt,
1844: l_qp_qualifiers_rec.header_quals_exist_flag,
1845: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
1846: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1847: ,to_char(l_new_qualifier_id)

Line 1844: l_qp_qualifiers_rec.header_quals_exist_flag,

1840: l_qual_attr_value_to_number,
1841: l_qp_qualifiers_rec.search_ind,
1842: l_qp_qualifiers_rec.distinct_row_count,
1843: l_qp_qualifiers_rec.qualifier_group_cnt,
1844: l_qp_qualifiers_rec.header_quals_exist_flag,
1845: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
1846: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1847: ,to_char(l_new_qualifier_id)
1848: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)

Line 1845: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA

1841: l_qp_qualifiers_rec.search_ind,
1842: l_qp_qualifiers_rec.distinct_row_count,
1843: l_qp_qualifiers_rec.qualifier_group_cnt,
1844: l_qp_qualifiers_rec.header_quals_exist_flag,
1845: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
1846: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1847: ,to_char(l_new_qualifier_id)
1848: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)
1849: ,(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 1848: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)

1844: l_qp_qualifiers_rec.header_quals_exist_flag,
1845: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
1846: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1847: ,to_char(l_new_qualifier_id)
1848: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)
1849: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_qp_qualifiers_rec.list_header_id)
1850: );
1851:
1852:

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

1845: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
1846: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1847: ,to_char(l_new_qualifier_id)
1848: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)
1849: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_qp_qualifiers_rec.list_header_id)
1850: );
1851:
1852:
1853: END LOOP;

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

2680:
2681:
2682: Delete_Duplicate_Lines(p_effective_dates_flag, l_new_list_header_id);
2683:
2684: /* This code will call the API to update the denormalized columns on QP_QUALIFIERS*/
2685: QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS
2686: (ERR_BUFF => errbuf,
2687: RETCODE => retcode,
2688: P_LIST_HEADER_ID => l_new_list_header_id);

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

2689:
2690:
2691: if retcode = 2 then
2692: --error from update denormalized columns
2693: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
2694: else
2695: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');
2696: end if;
2697:

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

2691: if retcode = 2 then
2692: --error from update denormalized columns
2693: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
2694: else
2695: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');
2696: end if;
2697:
2698:
2699: --Upgrade Non-Continuous Price Breaks