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_MODIFIERS_PVT dependencies on QP_QUALIFIERS

Line 233: delete qp_qualifiers

229:
230: DELETE qp_pricing_Attributes
231: where list_line_id=l_del_dup_cur_rec.list_line_id;
232:
233: delete qp_qualifiers
234: where list_line_id=l_del_dup_cur_rec.list_line_id;
235:
236: DELETE qp_list_lines
237: where list_line_id=l_del_dup_cur_rec.list_line_id;

Line 341: FROM qp_qualifiers a

337: CURSOR qp_from_discounts_cur(p_from_list_header_id NUMBER, p_context VARCHAR2,
338: p_attribute VARCHAR2)
339: IS
340: SELECT list_header_id
341: FROM qp_qualifiers a
342: WHERE a.qualifier_context = p_context
343: AND a.qualifier_attribute = p_attribute
344: AND a.qualifier_attr_value = TO_CHAR(p_from_list_header_id)
345: AND a.list_header_id IN

Line 359: CURSOR qp_qualifiers_cur(p_from_discount_header_id NUMBER)

355: FROM qp_list_headers_ALL_b
356: WHERE list_header_id = p_from_list_header_id
357: AND list_type_code in ('DLT','DEL','CHARGES','PRO','SLT');
358:
359: CURSOR qp_qualifiers_cur(p_from_discount_header_id NUMBER)
360: IS
361: SELECT *
362: FROM qp_qualifiers
363: WHERE list_header_id = p_from_discount_header_id and

Line 362: FROM qp_qualifiers

358:
359: CURSOR qp_qualifiers_cur(p_from_discount_header_id NUMBER)
360: IS
361: SELECT *
362: FROM qp_qualifiers
363: WHERE list_header_id = p_from_discount_header_id and
364: list_line_id = -1;
365:
366: CURSOR qp_line_qualifiers_cur(p_from_discount_header_id NUMBER,

Line 370: FROM qp_qualifiers

366: CURSOR qp_line_qualifiers_cur(p_from_discount_header_id NUMBER,
367: p_from_discount_line_id NUMBER)
368: IS
369: SELECT *
370: FROM qp_qualifiers
371: WHERE list_header_id = p_from_discount_header_id and
372: list_line_id = p_from_discount_line_id ;
373:
374: CURSOR qp_discount_lines_cur(p_from_discount_header_id NUMBER)

Line 726: FOR l_qp_qualifiers_rec IN

722: QP_Security.create_default_grants( p_instance_type => QP_Security.G_MODIFIER_OBJECT,
723: p_instance_pk1 => l_new_discount_header_id,
724: x_return_status => x_result);
725: --
726: FOR l_qp_qualifiers_rec IN
727: qp_qualifiers_cur(qp_from_discounts_rec.list_header_id)
728: LOOP
729:
730: --Get new qualifier_id

Line 727: qp_qualifiers_cur(qp_from_discounts_rec.list_header_id)

723: p_instance_pk1 => l_new_discount_header_id,
724: x_return_status => x_result);
725: --
726: FOR l_qp_qualifiers_rec IN
727: qp_qualifiers_cur(qp_from_discounts_rec.list_header_id)
728: LOOP
729:
730: --Get new qualifier_id
731: SELECT qp_qualifiers_s.nextval

Line 731: SELECT qp_qualifiers_s.nextval

727: qp_qualifiers_cur(qp_from_discounts_rec.list_header_id)
728: LOOP
729:
730: --Get new qualifier_id
731: SELECT qp_qualifiers_s.nextval
732: INTO l_new_qualifier_id
733: FROM dual;
734:
735: /*

Line 736: IF l_qp_qualifiers_rec.qualifier_attr_value =

732: INTO l_new_qualifier_id
733: FROM dual;
734:
735: /*
736: IF l_qp_qualifiers_rec.qualifier_attr_value =
737: TO_CHAR(p_from_list_header_id) AND
738: l_qp_qualifiers_rec.qualifier_context = p_context AND
739: l_qp_qualifiers_rec.qualifier_attribute = p_attribute
740: THEN

Line 738: l_qp_qualifiers_rec.qualifier_context = p_context AND

734:
735: /*
736: IF l_qp_qualifiers_rec.qualifier_attr_value =
737: TO_CHAR(p_from_list_header_id) AND
738: l_qp_qualifiers_rec.qualifier_context = p_context AND
739: l_qp_qualifiers_rec.qualifier_attribute = p_attribute
740: THEN
741: l_qp_qualifiers_rec.qualifier_attr_value :=
742: TO_CHAR(p_new_list_header_id);

Line 739: l_qp_qualifiers_rec.qualifier_attribute = p_attribute

735: /*
736: IF l_qp_qualifiers_rec.qualifier_attr_value =
737: TO_CHAR(p_from_list_header_id) AND
738: l_qp_qualifiers_rec.qualifier_context = p_context AND
739: l_qp_qualifiers_rec.qualifier_attribute = p_attribute
740: THEN
741: l_qp_qualifiers_rec.qualifier_attr_value :=
742: TO_CHAR(p_new_list_header_id);
743: END IF;

Line 741: l_qp_qualifiers_rec.qualifier_attr_value :=

737: TO_CHAR(p_from_list_header_id) AND
738: l_qp_qualifiers_rec.qualifier_context = p_context AND
739: l_qp_qualifiers_rec.qualifier_attribute = p_attribute
740: THEN
741: l_qp_qualifiers_rec.qualifier_attr_value :=
742: TO_CHAR(p_new_list_header_id);
743: END IF;
744: */
745:

Line 759: IF l_qp_qualifiers_rec.qualifier_datatype = 'N'

755: WHEN OTHERS THEN
756: NULL;
757: END;
758:
759: IF l_qp_qualifiers_rec.qualifier_datatype = 'N'
760: then
761:
762: BEGIN
763:

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

761:
762: BEGIN
763:
764: l_qual_attr_value_from_number :=
765: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
766:
767: l_qual_attr_value_to_number :=
768: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
769:

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

764: l_qual_attr_value_from_number :=
765: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
766:
767: l_qual_attr_value_to_number :=
768: qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
769:
770: EXCEPTION
771: WHEN VALUE_ERROR THEN
772: NULL;

Line 780: INSERT INTO qp_qualifiers

776:
777: end if;
778:
779: --Insert new qualifier
780: INSERT INTO qp_qualifiers
781: (
782: qualifier_id,
783: creation_date,
784: created_by,

Line 849: l_qp_qualifiers_rec.excluder_flag,

845: l_conc_program_application_id,
846: l_conc_program_id,
847: sysdate,
848: l_conc_request_id,
849: l_qp_qualifiers_rec.excluder_flag,
850: l_qp_qualifiers_rec.comparison_operator_code,
851: l_qp_qualifiers_rec.qualifier_context,
852: l_qp_qualifiers_rec.qualifier_attribute,
853: l_qp_qualifiers_rec.context,

Line 850: l_qp_qualifiers_rec.comparison_operator_code,

846: l_conc_program_id,
847: sysdate,
848: l_conc_request_id,
849: l_qp_qualifiers_rec.excluder_flag,
850: l_qp_qualifiers_rec.comparison_operator_code,
851: l_qp_qualifiers_rec.qualifier_context,
852: l_qp_qualifiers_rec.qualifier_attribute,
853: l_qp_qualifiers_rec.context,
854: l_qp_qualifiers_rec.attribute1,

Line 851: l_qp_qualifiers_rec.qualifier_context,

847: sysdate,
848: l_conc_request_id,
849: l_qp_qualifiers_rec.excluder_flag,
850: l_qp_qualifiers_rec.comparison_operator_code,
851: l_qp_qualifiers_rec.qualifier_context,
852: l_qp_qualifiers_rec.qualifier_attribute,
853: l_qp_qualifiers_rec.context,
854: l_qp_qualifiers_rec.attribute1,
855: l_qp_qualifiers_rec.attribute2,

Line 852: l_qp_qualifiers_rec.qualifier_attribute,

848: l_conc_request_id,
849: l_qp_qualifiers_rec.excluder_flag,
850: l_qp_qualifiers_rec.comparison_operator_code,
851: l_qp_qualifiers_rec.qualifier_context,
852: l_qp_qualifiers_rec.qualifier_attribute,
853: l_qp_qualifiers_rec.context,
854: l_qp_qualifiers_rec.attribute1,
855: l_qp_qualifiers_rec.attribute2,
856: l_qp_qualifiers_rec.attribute3,

Line 853: l_qp_qualifiers_rec.context,

849: l_qp_qualifiers_rec.excluder_flag,
850: l_qp_qualifiers_rec.comparison_operator_code,
851: l_qp_qualifiers_rec.qualifier_context,
852: l_qp_qualifiers_rec.qualifier_attribute,
853: l_qp_qualifiers_rec.context,
854: l_qp_qualifiers_rec.attribute1,
855: l_qp_qualifiers_rec.attribute2,
856: l_qp_qualifiers_rec.attribute3,
857: l_qp_qualifiers_rec.attribute4,

Line 854: l_qp_qualifiers_rec.attribute1,

850: l_qp_qualifiers_rec.comparison_operator_code,
851: l_qp_qualifiers_rec.qualifier_context,
852: l_qp_qualifiers_rec.qualifier_attribute,
853: l_qp_qualifiers_rec.context,
854: l_qp_qualifiers_rec.attribute1,
855: l_qp_qualifiers_rec.attribute2,
856: l_qp_qualifiers_rec.attribute3,
857: l_qp_qualifiers_rec.attribute4,
858: l_qp_qualifiers_rec.attribute5,

Line 855: l_qp_qualifiers_rec.attribute2,

851: l_qp_qualifiers_rec.qualifier_context,
852: l_qp_qualifiers_rec.qualifier_attribute,
853: l_qp_qualifiers_rec.context,
854: l_qp_qualifiers_rec.attribute1,
855: l_qp_qualifiers_rec.attribute2,
856: l_qp_qualifiers_rec.attribute3,
857: l_qp_qualifiers_rec.attribute4,
858: l_qp_qualifiers_rec.attribute5,
859: l_qp_qualifiers_rec.attribute6,

Line 856: l_qp_qualifiers_rec.attribute3,

852: l_qp_qualifiers_rec.qualifier_attribute,
853: l_qp_qualifiers_rec.context,
854: l_qp_qualifiers_rec.attribute1,
855: l_qp_qualifiers_rec.attribute2,
856: l_qp_qualifiers_rec.attribute3,
857: l_qp_qualifiers_rec.attribute4,
858: l_qp_qualifiers_rec.attribute5,
859: l_qp_qualifiers_rec.attribute6,
860: l_qp_qualifiers_rec.attribute7,

Line 857: l_qp_qualifiers_rec.attribute4,

853: l_qp_qualifiers_rec.context,
854: l_qp_qualifiers_rec.attribute1,
855: l_qp_qualifiers_rec.attribute2,
856: l_qp_qualifiers_rec.attribute3,
857: l_qp_qualifiers_rec.attribute4,
858: l_qp_qualifiers_rec.attribute5,
859: l_qp_qualifiers_rec.attribute6,
860: l_qp_qualifiers_rec.attribute7,
861: l_qp_qualifiers_rec.attribute8,

Line 858: l_qp_qualifiers_rec.attribute5,

854: l_qp_qualifiers_rec.attribute1,
855: l_qp_qualifiers_rec.attribute2,
856: l_qp_qualifiers_rec.attribute3,
857: l_qp_qualifiers_rec.attribute4,
858: l_qp_qualifiers_rec.attribute5,
859: l_qp_qualifiers_rec.attribute6,
860: l_qp_qualifiers_rec.attribute7,
861: l_qp_qualifiers_rec.attribute8,
862: l_qp_qualifiers_rec.attribute9,

Line 859: l_qp_qualifiers_rec.attribute6,

855: l_qp_qualifiers_rec.attribute2,
856: l_qp_qualifiers_rec.attribute3,
857: l_qp_qualifiers_rec.attribute4,
858: l_qp_qualifiers_rec.attribute5,
859: l_qp_qualifiers_rec.attribute6,
860: l_qp_qualifiers_rec.attribute7,
861: l_qp_qualifiers_rec.attribute8,
862: l_qp_qualifiers_rec.attribute9,
863: l_qp_qualifiers_rec.attribute10,

Line 860: l_qp_qualifiers_rec.attribute7,

856: l_qp_qualifiers_rec.attribute3,
857: l_qp_qualifiers_rec.attribute4,
858: l_qp_qualifiers_rec.attribute5,
859: l_qp_qualifiers_rec.attribute6,
860: l_qp_qualifiers_rec.attribute7,
861: l_qp_qualifiers_rec.attribute8,
862: l_qp_qualifiers_rec.attribute9,
863: l_qp_qualifiers_rec.attribute10,
864: l_qp_qualifiers_rec.attribute11,

Line 861: l_qp_qualifiers_rec.attribute8,

857: l_qp_qualifiers_rec.attribute4,
858: l_qp_qualifiers_rec.attribute5,
859: l_qp_qualifiers_rec.attribute6,
860: l_qp_qualifiers_rec.attribute7,
861: l_qp_qualifiers_rec.attribute8,
862: l_qp_qualifiers_rec.attribute9,
863: l_qp_qualifiers_rec.attribute10,
864: l_qp_qualifiers_rec.attribute11,
865: l_qp_qualifiers_rec.attribute12,

Line 862: l_qp_qualifiers_rec.attribute9,

858: l_qp_qualifiers_rec.attribute5,
859: l_qp_qualifiers_rec.attribute6,
860: l_qp_qualifiers_rec.attribute7,
861: l_qp_qualifiers_rec.attribute8,
862: l_qp_qualifiers_rec.attribute9,
863: l_qp_qualifiers_rec.attribute10,
864: l_qp_qualifiers_rec.attribute11,
865: l_qp_qualifiers_rec.attribute12,
866: l_qp_qualifiers_rec.attribute13,

Line 863: l_qp_qualifiers_rec.attribute10,

859: l_qp_qualifiers_rec.attribute6,
860: l_qp_qualifiers_rec.attribute7,
861: l_qp_qualifiers_rec.attribute8,
862: l_qp_qualifiers_rec.attribute9,
863: l_qp_qualifiers_rec.attribute10,
864: l_qp_qualifiers_rec.attribute11,
865: l_qp_qualifiers_rec.attribute12,
866: l_qp_qualifiers_rec.attribute13,
867: l_qp_qualifiers_rec.attribute14,

Line 864: l_qp_qualifiers_rec.attribute11,

860: l_qp_qualifiers_rec.attribute7,
861: l_qp_qualifiers_rec.attribute8,
862: l_qp_qualifiers_rec.attribute9,
863: l_qp_qualifiers_rec.attribute10,
864: l_qp_qualifiers_rec.attribute11,
865: l_qp_qualifiers_rec.attribute12,
866: l_qp_qualifiers_rec.attribute13,
867: l_qp_qualifiers_rec.attribute14,
868: l_qp_qualifiers_rec.attribute15,

Line 865: l_qp_qualifiers_rec.attribute12,

861: l_qp_qualifiers_rec.attribute8,
862: l_qp_qualifiers_rec.attribute9,
863: l_qp_qualifiers_rec.attribute10,
864: l_qp_qualifiers_rec.attribute11,
865: l_qp_qualifiers_rec.attribute12,
866: l_qp_qualifiers_rec.attribute13,
867: l_qp_qualifiers_rec.attribute14,
868: l_qp_qualifiers_rec.attribute15,
869: l_qp_qualifiers_rec.qualifier_rule_id,

Line 866: l_qp_qualifiers_rec.attribute13,

862: l_qp_qualifiers_rec.attribute9,
863: l_qp_qualifiers_rec.attribute10,
864: l_qp_qualifiers_rec.attribute11,
865: l_qp_qualifiers_rec.attribute12,
866: l_qp_qualifiers_rec.attribute13,
867: l_qp_qualifiers_rec.attribute14,
868: l_qp_qualifiers_rec.attribute15,
869: l_qp_qualifiers_rec.qualifier_rule_id,
870: l_qp_qualifiers_rec.qualifier_grouping_no,

Line 867: l_qp_qualifiers_rec.attribute14,

863: l_qp_qualifiers_rec.attribute10,
864: l_qp_qualifiers_rec.attribute11,
865: l_qp_qualifiers_rec.attribute12,
866: l_qp_qualifiers_rec.attribute13,
867: l_qp_qualifiers_rec.attribute14,
868: l_qp_qualifiers_rec.attribute15,
869: l_qp_qualifiers_rec.qualifier_rule_id,
870: l_qp_qualifiers_rec.qualifier_grouping_no,
871: l_qp_qualifiers_rec.qualifier_attr_value,

Line 868: l_qp_qualifiers_rec.attribute15,

864: l_qp_qualifiers_rec.attribute11,
865: l_qp_qualifiers_rec.attribute12,
866: l_qp_qualifiers_rec.attribute13,
867: l_qp_qualifiers_rec.attribute14,
868: l_qp_qualifiers_rec.attribute15,
869: l_qp_qualifiers_rec.qualifier_rule_id,
870: l_qp_qualifiers_rec.qualifier_grouping_no,
871: l_qp_qualifiers_rec.qualifier_attr_value,
872: l_new_discount_header_id,

Line 869: l_qp_qualifiers_rec.qualifier_rule_id,

865: l_qp_qualifiers_rec.attribute12,
866: l_qp_qualifiers_rec.attribute13,
867: l_qp_qualifiers_rec.attribute14,
868: l_qp_qualifiers_rec.attribute15,
869: l_qp_qualifiers_rec.qualifier_rule_id,
870: l_qp_qualifiers_rec.qualifier_grouping_no,
871: l_qp_qualifiers_rec.qualifier_attr_value,
872: l_new_discount_header_id,
873: --l_qp_qualifiers_rec.list_line_id,

Line 870: l_qp_qualifiers_rec.qualifier_grouping_no,

866: l_qp_qualifiers_rec.attribute13,
867: l_qp_qualifiers_rec.attribute14,
868: l_qp_qualifiers_rec.attribute15,
869: l_qp_qualifiers_rec.qualifier_rule_id,
870: l_qp_qualifiers_rec.qualifier_grouping_no,
871: l_qp_qualifiers_rec.qualifier_attr_value,
872: l_new_discount_header_id,
873: --l_qp_qualifiers_rec.list_line_id,
874: -1, ---l_qp_qualifiers_rec.list_line_id,

Line 871: l_qp_qualifiers_rec.qualifier_attr_value,

867: l_qp_qualifiers_rec.attribute14,
868: l_qp_qualifiers_rec.attribute15,
869: l_qp_qualifiers_rec.qualifier_rule_id,
870: l_qp_qualifiers_rec.qualifier_grouping_no,
871: l_qp_qualifiers_rec.qualifier_attr_value,
872: l_new_discount_header_id,
873: --l_qp_qualifiers_rec.list_line_id,
874: -1, ---l_qp_qualifiers_rec.list_line_id,
875: l_qp_qualifiers_rec.created_from_rule_id,

Line 873: --l_qp_qualifiers_rec.list_line_id,

869: l_qp_qualifiers_rec.qualifier_rule_id,
870: l_qp_qualifiers_rec.qualifier_grouping_no,
871: l_qp_qualifiers_rec.qualifier_attr_value,
872: l_new_discount_header_id,
873: --l_qp_qualifiers_rec.list_line_id,
874: -1, ---l_qp_qualifiers_rec.list_line_id,
875: l_qp_qualifiers_rec.created_from_rule_id,
876: l_qp_qualifiers_rec.start_date_active,
877: l_qp_qualifiers_rec.end_date_active,

Line 874: -1, ---l_qp_qualifiers_rec.list_line_id,

870: l_qp_qualifiers_rec.qualifier_grouping_no,
871: l_qp_qualifiers_rec.qualifier_attr_value,
872: l_new_discount_header_id,
873: --l_qp_qualifiers_rec.list_line_id,
874: -1, ---l_qp_qualifiers_rec.list_line_id,
875: l_qp_qualifiers_rec.created_from_rule_id,
876: l_qp_qualifiers_rec.start_date_active,
877: l_qp_qualifiers_rec.end_date_active,
878: l_qp_qualifiers_rec.qualifier_precedence,

Line 875: l_qp_qualifiers_rec.created_from_rule_id,

871: l_qp_qualifiers_rec.qualifier_attr_value,
872: l_new_discount_header_id,
873: --l_qp_qualifiers_rec.list_line_id,
874: -1, ---l_qp_qualifiers_rec.list_line_id,
875: l_qp_qualifiers_rec.created_from_rule_id,
876: l_qp_qualifiers_rec.start_date_active,
877: l_qp_qualifiers_rec.end_date_active,
878: l_qp_qualifiers_rec.qualifier_precedence,
879: l_qp_qualifiers_rec.qualifier_datatype,

Line 876: l_qp_qualifiers_rec.start_date_active,

872: l_new_discount_header_id,
873: --l_qp_qualifiers_rec.list_line_id,
874: -1, ---l_qp_qualifiers_rec.list_line_id,
875: l_qp_qualifiers_rec.created_from_rule_id,
876: l_qp_qualifiers_rec.start_date_active,
877: l_qp_qualifiers_rec.end_date_active,
878: l_qp_qualifiers_rec.qualifier_precedence,
879: l_qp_qualifiers_rec.qualifier_datatype,
880: l_qp_qualifiers_rec.qualifier_attr_value_to,

Line 877: l_qp_qualifiers_rec.end_date_active,

873: --l_qp_qualifiers_rec.list_line_id,
874: -1, ---l_qp_qualifiers_rec.list_line_id,
875: l_qp_qualifiers_rec.created_from_rule_id,
876: l_qp_qualifiers_rec.start_date_active,
877: l_qp_qualifiers_rec.end_date_active,
878: l_qp_qualifiers_rec.qualifier_precedence,
879: l_qp_qualifiers_rec.qualifier_datatype,
880: l_qp_qualifiers_rec.qualifier_attr_value_to,
881: l_active_flag,

Line 878: l_qp_qualifiers_rec.qualifier_precedence,

874: -1, ---l_qp_qualifiers_rec.list_line_id,
875: l_qp_qualifiers_rec.created_from_rule_id,
876: l_qp_qualifiers_rec.start_date_active,
877: l_qp_qualifiers_rec.end_date_active,
878: l_qp_qualifiers_rec.qualifier_precedence,
879: l_qp_qualifiers_rec.qualifier_datatype,
880: l_qp_qualifiers_rec.qualifier_attr_value_to,
881: l_active_flag,
882: l_list_type_code,

Line 879: l_qp_qualifiers_rec.qualifier_datatype,

875: l_qp_qualifiers_rec.created_from_rule_id,
876: l_qp_qualifiers_rec.start_date_active,
877: l_qp_qualifiers_rec.end_date_active,
878: l_qp_qualifiers_rec.qualifier_precedence,
879: l_qp_qualifiers_rec.qualifier_datatype,
880: l_qp_qualifiers_rec.qualifier_attr_value_to,
881: l_active_flag,
882: l_list_type_code,
883: l_qual_attr_value_from_number,

Line 880: l_qp_qualifiers_rec.qualifier_attr_value_to,

876: l_qp_qualifiers_rec.start_date_active,
877: l_qp_qualifiers_rec.end_date_active,
878: l_qp_qualifiers_rec.qualifier_precedence,
879: l_qp_qualifiers_rec.qualifier_datatype,
880: l_qp_qualifiers_rec.qualifier_attr_value_to,
881: l_active_flag,
882: l_list_type_code,
883: l_qual_attr_value_from_number,
884: l_qual_attr_value_to_number,

Line 885: l_qp_qualifiers_rec.search_ind,

881: l_active_flag,
882: l_list_type_code,
883: l_qual_attr_value_from_number,
884: l_qual_attr_value_to_number,
885: l_qp_qualifiers_rec.search_ind,
886: l_qp_qualifiers_rec.distinct_row_count,
887: l_qp_qualifiers_rec.qualifier_group_cnt,
888: l_qp_qualifiers_rec.header_quals_exist_flag,
889: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA

Line 886: l_qp_qualifiers_rec.distinct_row_count,

882: l_list_type_code,
883: l_qual_attr_value_from_number,
884: l_qual_attr_value_to_number,
885: l_qp_qualifiers_rec.search_ind,
886: l_qp_qualifiers_rec.distinct_row_count,
887: l_qp_qualifiers_rec.qualifier_group_cnt,
888: l_qp_qualifiers_rec.header_quals_exist_flag,
889: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
890: --ENH Upgrade BOAPI for orig_sys...ref RAVI

Line 887: l_qp_qualifiers_rec.qualifier_group_cnt,

883: l_qual_attr_value_from_number,
884: l_qual_attr_value_to_number,
885: l_qp_qualifiers_rec.search_ind,
886: l_qp_qualifiers_rec.distinct_row_count,
887: l_qp_qualifiers_rec.qualifier_group_cnt,
888: l_qp_qualifiers_rec.header_quals_exist_flag,
889: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
890: --ENH Upgrade BOAPI for orig_sys...ref RAVI
891: --,to_char(l_new_qualifier_id)

Line 888: l_qp_qualifiers_rec.header_quals_exist_flag,

884: l_qual_attr_value_to_number,
885: l_qp_qualifiers_rec.search_ind,
886: l_qp_qualifiers_rec.distinct_row_count,
887: l_qp_qualifiers_rec.qualifier_group_cnt,
888: l_qp_qualifiers_rec.header_quals_exist_flag,
889: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
890: --ENH Upgrade BOAPI for orig_sys...ref RAVI
891: --,to_char(l_new_qualifier_id)
892: --,null

Line 889: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA

885: l_qp_qualifiers_rec.search_ind,
886: l_qp_qualifiers_rec.distinct_row_count,
887: l_qp_qualifiers_rec.qualifier_group_cnt,
888: l_qp_qualifiers_rec.header_quals_exist_flag,
889: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
890: --ENH Upgrade BOAPI for orig_sys...ref RAVI
891: --,to_char(l_new_qualifier_id)
892: --,null
893: --,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)

Line 1142: SELECT qp_qualifiers_s.nextval

1138: l_qp_discount_lines_rec.list_line_id)
1139: LOOP
1140:
1141: --Get new qualifier_id
1142: SELECT qp_qualifiers_s.nextval
1143: INTO l_new_qualifier_id
1144: FROM dual;
1145:
1146: /*

Line 1191: INSERT INTO qp_qualifiers

1187:
1188: end if;
1189:
1190: --Insert new qualifier
1191: INSERT INTO qp_qualifiers
1192: (
1193: qualifier_id,
1194: creation_date,
1195: created_by,

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

1583: ----
1584: --Delete_Duplicate_Lines(p_effective_dates_flag, l_new_list_header_id);
1585: Delete_Duplicate_Lines(p_effective_dates_flag, l_new_discount_header_id); --for 2222562
1586:
1587: /* This code will call the API to update the denormalized columns on QP_QUALIFIERS*/
1588: QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS
1589: (ERR_BUFF => errbuf,
1590: RETCODE => retcode,
1591: --P_LIST_HEADER_ID => l_new_list_header_id);

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

1593:
1594:
1595: if retcode = 2 then
1596: --error from update denormalized columns
1597: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
1598: else
1599: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');
1600: end if;
1601:

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

1595: if retcode = 2 then
1596: --error from update denormalized columns
1597: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
1598: else
1599: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');
1600: end if;
1601:
1602: --Upgrade Non-Continuous Price Breaks
1603: