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;
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
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
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,
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)
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
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
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: /*
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
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);
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;
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:
755: WHEN OTHERS THEN
756: NULL;
757: END;
758:
759: IF l_qp_qualifiers_rec.qualifier_datatype = 'N'
760: then
761:
762: BEGIN
763:
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:
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;
776:
777: end if;
778:
779: --Insert new qualifier
780: INSERT INTO qp_qualifiers
781: (
782: qualifier_id,
783: creation_date,
784: created_by,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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
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)
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
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)
1137: l_qp_discount_lines_rec.list_line_id)
1138: LOOP
1139:
1140: --Get new qualifier_id
1141: SELECT qp_qualifiers_s.nextval
1142: INTO l_new_qualifier_id
1143: FROM dual;
1144:
1145: /*
1186:
1187: end if;
1188:
1189: --Insert new qualifier
1190: INSERT INTO qp_qualifiers
1191: (
1192: qualifier_id,
1193: creation_date,
1194: created_by,
1582: ----
1583: --Delete_Duplicate_Lines(p_effective_dates_flag, l_new_list_header_id);
1584: Delete_Duplicate_Lines(p_effective_dates_flag, l_new_discount_header_id); --for 2222562
1585:
1586: /* This code will call the API to update the denormalized columns on QP_QUALIFIERS*/
1587: QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS
1588: (ERR_BUFF => errbuf,
1589: RETCODE => retcode,
1590: --P_LIST_HEADER_ID => l_new_list_header_id);
1592:
1593:
1594: if retcode = 2 then
1595: --error from update denormalized columns
1596: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
1597: else
1598: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');
1599: end if;
1600:
1594: if retcode = 2 then
1595: --error from update denormalized columns
1596: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
1597: else
1598: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');
1599: end if;
1600:
1601: --Upgrade Non-Continuous Price Breaks
1602: