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_PRICING_ATTRIBUTES

Line 258: DELETE qp_pricing_attributes pa

254: END IF;
255:
256: /* Commented out for 2397463 */
257: /*
258: DELETE qp_pricing_attributes pa
259: WHERE pa.list_line_id = l_list_lines_id.list_line_id;
260:
261: DELETE qp_list_lines
262: WHERE list_line_id = l_list_lines_id.list_line_id;

Line 273: DELETE qp_pricing_attributes pa

269: /*
270: FOR l_del_dup_cur_rec IN del_dup_cur(p_new_list_header_id)
271: LOOP
272:
273: DELETE qp_pricing_attributes pa
274: WHERE pa.list_line_id = l_del_dup_cur_rec.list_line_id;
275:
276: DELETE qp_list_lines
277: WHERE CURRENT OF del_dup_cur;

Line 377: CURSOR qp_pricing_attributes_cur(p_from_discount_line_id NUMBER)

373: SELECT *
374: FROM qp_list_lines
375: WHERE list_header_id = p_from_discount_header_id;
376:
377: CURSOR qp_pricing_attributes_cur(p_from_discount_line_id NUMBER)
378: IS
379: SELECT *
380: FROM qp_pricing_attributes
381: WHERE list_line_id = p_from_discount_line_id;

Line 380: FROM qp_pricing_attributes

376:
377: CURSOR qp_pricing_attributes_cur(p_from_discount_line_id NUMBER)
378: IS
379: SELECT *
380: FROM qp_pricing_attributes
381: WHERE list_line_id = p_from_discount_line_id;
382:
383: CURSOR qp_rltd_modifiers_cur(a_list_line_id NUMBER)
384: IS

Line 971: /* Copy the qp_pricing_attributes records for each discount line being

967: l_mapping_tbl(l_count).new_list_line_id := l_new_discount_line_id;
968: END IF;
969:
970:
971: /* Copy the qp_pricing_attributes records for each discount line being
972: copied */
973:
974: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur
975: (l_qp_discount_lines_rec.list_line_id)

Line 974: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur

970:
971: /* Copy the qp_pricing_attributes records for each discount line being
972: copied */
973:
974: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur
975: (l_qp_discount_lines_rec.list_line_id)
976: -- basically the from_discount_list_line_id
977: LOOP
978:

Line 980: SELECT qp_pricing_attributes_s.nextval

976: -- basically the from_discount_list_line_id
977: LOOP
978:
979: -- Get next pricing_attribute_id
980: SELECT qp_pricing_attributes_s.nextval
981: INTO l_new_pricing_attribute_id
982: FROM dual;
983:
984:

Line 985: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N'

981: INTO l_new_pricing_attribute_id
982: FROM dual;
983:
984:
985: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N'
986: then
987:
988: BEGIN
989:

Line 991: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);

987:
988: BEGIN
989:
990: l_pric_attr_value_from_number :=
991: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
992:
993: l_pric_attr_value_to_number :=
994: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
995:

Line 994: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);

990: l_pric_attr_value_from_number :=
991: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
992:
993: l_pric_attr_value_to_number :=
994: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
995:
996: EXCEPTION
997: WHEN VALUE_ERROR THEN
998: NULL;

Line 1006: INSERT INTO qp_pricing_attributes

1002:
1003: end if;
1004:
1005:
1006: INSERT INTO qp_pricing_attributes
1007: (pricing_attribute_id,
1008: creation_date,
1009: created_by,
1010: last_update_date,

Line 1071: l_qp_pricing_attributes_rec.pricing_phase_id,

1067: sysdate,
1068: p_conc_request_id,
1069: l_new_discount_line_id, /* new discount line id */
1070: l_new_discount_header_id,
1071: l_qp_pricing_attributes_rec.pricing_phase_id,
1072: l_qp_pricing_attributes_rec.qualification_ind,
1073: l_qp_pricing_attributes_rec.excluder_flag,
1074: l_qp_pricing_attributes_rec.accumulate_flag,
1075: l_qp_pricing_attributes_rec.product_attribute_context,

Line 1072: l_qp_pricing_attributes_rec.qualification_ind,

1068: p_conc_request_id,
1069: l_new_discount_line_id, /* new discount line id */
1070: l_new_discount_header_id,
1071: l_qp_pricing_attributes_rec.pricing_phase_id,
1072: l_qp_pricing_attributes_rec.qualification_ind,
1073: l_qp_pricing_attributes_rec.excluder_flag,
1074: l_qp_pricing_attributes_rec.accumulate_flag,
1075: l_qp_pricing_attributes_rec.product_attribute_context,
1076: l_qp_pricing_attributes_rec.product_attribute,

Line 1073: l_qp_pricing_attributes_rec.excluder_flag,

1069: l_new_discount_line_id, /* new discount line id */
1070: l_new_discount_header_id,
1071: l_qp_pricing_attributes_rec.pricing_phase_id,
1072: l_qp_pricing_attributes_rec.qualification_ind,
1073: l_qp_pricing_attributes_rec.excluder_flag,
1074: l_qp_pricing_attributes_rec.accumulate_flag,
1075: l_qp_pricing_attributes_rec.product_attribute_context,
1076: l_qp_pricing_attributes_rec.product_attribute,
1077: l_qp_pricing_attributes_rec.product_attr_value,

Line 1074: l_qp_pricing_attributes_rec.accumulate_flag,

1070: l_new_discount_header_id,
1071: l_qp_pricing_attributes_rec.pricing_phase_id,
1072: l_qp_pricing_attributes_rec.qualification_ind,
1073: l_qp_pricing_attributes_rec.excluder_flag,
1074: l_qp_pricing_attributes_rec.accumulate_flag,
1075: l_qp_pricing_attributes_rec.product_attribute_context,
1076: l_qp_pricing_attributes_rec.product_attribute,
1077: l_qp_pricing_attributes_rec.product_attr_value,
1078: l_qp_pricing_attributes_rec.product_uom_code,

Line 1075: l_qp_pricing_attributes_rec.product_attribute_context,

1071: l_qp_pricing_attributes_rec.pricing_phase_id,
1072: l_qp_pricing_attributes_rec.qualification_ind,
1073: l_qp_pricing_attributes_rec.excluder_flag,
1074: l_qp_pricing_attributes_rec.accumulate_flag,
1075: l_qp_pricing_attributes_rec.product_attribute_context,
1076: l_qp_pricing_attributes_rec.product_attribute,
1077: l_qp_pricing_attributes_rec.product_attr_value,
1078: l_qp_pricing_attributes_rec.product_uom_code,
1079: l_qp_pricing_attributes_rec.pricing_attribute_context,

Line 1076: l_qp_pricing_attributes_rec.product_attribute,

1072: l_qp_pricing_attributes_rec.qualification_ind,
1073: l_qp_pricing_attributes_rec.excluder_flag,
1074: l_qp_pricing_attributes_rec.accumulate_flag,
1075: l_qp_pricing_attributes_rec.product_attribute_context,
1076: l_qp_pricing_attributes_rec.product_attribute,
1077: l_qp_pricing_attributes_rec.product_attr_value,
1078: l_qp_pricing_attributes_rec.product_uom_code,
1079: l_qp_pricing_attributes_rec.pricing_attribute_context,
1080: l_qp_pricing_attributes_rec.pricing_attribute,

Line 1077: l_qp_pricing_attributes_rec.product_attr_value,

1073: l_qp_pricing_attributes_rec.excluder_flag,
1074: l_qp_pricing_attributes_rec.accumulate_flag,
1075: l_qp_pricing_attributes_rec.product_attribute_context,
1076: l_qp_pricing_attributes_rec.product_attribute,
1077: l_qp_pricing_attributes_rec.product_attr_value,
1078: l_qp_pricing_attributes_rec.product_uom_code,
1079: l_qp_pricing_attributes_rec.pricing_attribute_context,
1080: l_qp_pricing_attributes_rec.pricing_attribute,
1081: l_qp_pricing_attributes_rec.pricing_attr_value_from,

Line 1078: l_qp_pricing_attributes_rec.product_uom_code,

1074: l_qp_pricing_attributes_rec.accumulate_flag,
1075: l_qp_pricing_attributes_rec.product_attribute_context,
1076: l_qp_pricing_attributes_rec.product_attribute,
1077: l_qp_pricing_attributes_rec.product_attr_value,
1078: l_qp_pricing_attributes_rec.product_uom_code,
1079: l_qp_pricing_attributes_rec.pricing_attribute_context,
1080: l_qp_pricing_attributes_rec.pricing_attribute,
1081: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1082: l_qp_pricing_attributes_rec.pricing_attr_value_to,

Line 1079: l_qp_pricing_attributes_rec.pricing_attribute_context,

1075: l_qp_pricing_attributes_rec.product_attribute_context,
1076: l_qp_pricing_attributes_rec.product_attribute,
1077: l_qp_pricing_attributes_rec.product_attr_value,
1078: l_qp_pricing_attributes_rec.product_uom_code,
1079: l_qp_pricing_attributes_rec.pricing_attribute_context,
1080: l_qp_pricing_attributes_rec.pricing_attribute,
1081: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1082: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1083: l_qp_pricing_attributes_rec.attribute_grouping_no,

Line 1080: l_qp_pricing_attributes_rec.pricing_attribute,

1076: l_qp_pricing_attributes_rec.product_attribute,
1077: l_qp_pricing_attributes_rec.product_attr_value,
1078: l_qp_pricing_attributes_rec.product_uom_code,
1079: l_qp_pricing_attributes_rec.pricing_attribute_context,
1080: l_qp_pricing_attributes_rec.pricing_attribute,
1081: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1082: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1083: l_qp_pricing_attributes_rec.attribute_grouping_no,
1084: l_qp_pricing_attributes_rec.context,

Line 1081: l_qp_pricing_attributes_rec.pricing_attr_value_from,

1077: l_qp_pricing_attributes_rec.product_attr_value,
1078: l_qp_pricing_attributes_rec.product_uom_code,
1079: l_qp_pricing_attributes_rec.pricing_attribute_context,
1080: l_qp_pricing_attributes_rec.pricing_attribute,
1081: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1082: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1083: l_qp_pricing_attributes_rec.attribute_grouping_no,
1084: l_qp_pricing_attributes_rec.context,
1085: l_qp_pricing_attributes_rec.attribute1,

Line 1082: l_qp_pricing_attributes_rec.pricing_attr_value_to,

1078: l_qp_pricing_attributes_rec.product_uom_code,
1079: l_qp_pricing_attributes_rec.pricing_attribute_context,
1080: l_qp_pricing_attributes_rec.pricing_attribute,
1081: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1082: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1083: l_qp_pricing_attributes_rec.attribute_grouping_no,
1084: l_qp_pricing_attributes_rec.context,
1085: l_qp_pricing_attributes_rec.attribute1,
1086: l_qp_pricing_attributes_rec.attribute2,

Line 1083: l_qp_pricing_attributes_rec.attribute_grouping_no,

1079: l_qp_pricing_attributes_rec.pricing_attribute_context,
1080: l_qp_pricing_attributes_rec.pricing_attribute,
1081: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1082: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1083: l_qp_pricing_attributes_rec.attribute_grouping_no,
1084: l_qp_pricing_attributes_rec.context,
1085: l_qp_pricing_attributes_rec.attribute1,
1086: l_qp_pricing_attributes_rec.attribute2,
1087: l_qp_pricing_attributes_rec.attribute3,

Line 1084: l_qp_pricing_attributes_rec.context,

1080: l_qp_pricing_attributes_rec.pricing_attribute,
1081: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1082: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1083: l_qp_pricing_attributes_rec.attribute_grouping_no,
1084: l_qp_pricing_attributes_rec.context,
1085: l_qp_pricing_attributes_rec.attribute1,
1086: l_qp_pricing_attributes_rec.attribute2,
1087: l_qp_pricing_attributes_rec.attribute3,
1088: l_qp_pricing_attributes_rec.attribute4,

Line 1085: l_qp_pricing_attributes_rec.attribute1,

1081: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1082: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1083: l_qp_pricing_attributes_rec.attribute_grouping_no,
1084: l_qp_pricing_attributes_rec.context,
1085: l_qp_pricing_attributes_rec.attribute1,
1086: l_qp_pricing_attributes_rec.attribute2,
1087: l_qp_pricing_attributes_rec.attribute3,
1088: l_qp_pricing_attributes_rec.attribute4,
1089: l_qp_pricing_attributes_rec.attribute5,

Line 1086: l_qp_pricing_attributes_rec.attribute2,

1082: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1083: l_qp_pricing_attributes_rec.attribute_grouping_no,
1084: l_qp_pricing_attributes_rec.context,
1085: l_qp_pricing_attributes_rec.attribute1,
1086: l_qp_pricing_attributes_rec.attribute2,
1087: l_qp_pricing_attributes_rec.attribute3,
1088: l_qp_pricing_attributes_rec.attribute4,
1089: l_qp_pricing_attributes_rec.attribute5,
1090: l_qp_pricing_attributes_rec.attribute6,

Line 1087: l_qp_pricing_attributes_rec.attribute3,

1083: l_qp_pricing_attributes_rec.attribute_grouping_no,
1084: l_qp_pricing_attributes_rec.context,
1085: l_qp_pricing_attributes_rec.attribute1,
1086: l_qp_pricing_attributes_rec.attribute2,
1087: l_qp_pricing_attributes_rec.attribute3,
1088: l_qp_pricing_attributes_rec.attribute4,
1089: l_qp_pricing_attributes_rec.attribute5,
1090: l_qp_pricing_attributes_rec.attribute6,
1091: l_qp_pricing_attributes_rec.attribute7,

Line 1088: l_qp_pricing_attributes_rec.attribute4,

1084: l_qp_pricing_attributes_rec.context,
1085: l_qp_pricing_attributes_rec.attribute1,
1086: l_qp_pricing_attributes_rec.attribute2,
1087: l_qp_pricing_attributes_rec.attribute3,
1088: l_qp_pricing_attributes_rec.attribute4,
1089: l_qp_pricing_attributes_rec.attribute5,
1090: l_qp_pricing_attributes_rec.attribute6,
1091: l_qp_pricing_attributes_rec.attribute7,
1092: l_qp_pricing_attributes_rec.attribute8,

Line 1089: l_qp_pricing_attributes_rec.attribute5,

1085: l_qp_pricing_attributes_rec.attribute1,
1086: l_qp_pricing_attributes_rec.attribute2,
1087: l_qp_pricing_attributes_rec.attribute3,
1088: l_qp_pricing_attributes_rec.attribute4,
1089: l_qp_pricing_attributes_rec.attribute5,
1090: l_qp_pricing_attributes_rec.attribute6,
1091: l_qp_pricing_attributes_rec.attribute7,
1092: l_qp_pricing_attributes_rec.attribute8,
1093: l_qp_pricing_attributes_rec.attribute9,

Line 1090: l_qp_pricing_attributes_rec.attribute6,

1086: l_qp_pricing_attributes_rec.attribute2,
1087: l_qp_pricing_attributes_rec.attribute3,
1088: l_qp_pricing_attributes_rec.attribute4,
1089: l_qp_pricing_attributes_rec.attribute5,
1090: l_qp_pricing_attributes_rec.attribute6,
1091: l_qp_pricing_attributes_rec.attribute7,
1092: l_qp_pricing_attributes_rec.attribute8,
1093: l_qp_pricing_attributes_rec.attribute9,
1094: l_qp_pricing_attributes_rec.attribute10,

Line 1091: l_qp_pricing_attributes_rec.attribute7,

1087: l_qp_pricing_attributes_rec.attribute3,
1088: l_qp_pricing_attributes_rec.attribute4,
1089: l_qp_pricing_attributes_rec.attribute5,
1090: l_qp_pricing_attributes_rec.attribute6,
1091: l_qp_pricing_attributes_rec.attribute7,
1092: l_qp_pricing_attributes_rec.attribute8,
1093: l_qp_pricing_attributes_rec.attribute9,
1094: l_qp_pricing_attributes_rec.attribute10,
1095: l_qp_pricing_attributes_rec.attribute11,

Line 1092: l_qp_pricing_attributes_rec.attribute8,

1088: l_qp_pricing_attributes_rec.attribute4,
1089: l_qp_pricing_attributes_rec.attribute5,
1090: l_qp_pricing_attributes_rec.attribute6,
1091: l_qp_pricing_attributes_rec.attribute7,
1092: l_qp_pricing_attributes_rec.attribute8,
1093: l_qp_pricing_attributes_rec.attribute9,
1094: l_qp_pricing_attributes_rec.attribute10,
1095: l_qp_pricing_attributes_rec.attribute11,
1096: l_qp_pricing_attributes_rec.attribute12,

Line 1093: l_qp_pricing_attributes_rec.attribute9,

1089: l_qp_pricing_attributes_rec.attribute5,
1090: l_qp_pricing_attributes_rec.attribute6,
1091: l_qp_pricing_attributes_rec.attribute7,
1092: l_qp_pricing_attributes_rec.attribute8,
1093: l_qp_pricing_attributes_rec.attribute9,
1094: l_qp_pricing_attributes_rec.attribute10,
1095: l_qp_pricing_attributes_rec.attribute11,
1096: l_qp_pricing_attributes_rec.attribute12,
1097: l_qp_pricing_attributes_rec.attribute13,

Line 1094: l_qp_pricing_attributes_rec.attribute10,

1090: l_qp_pricing_attributes_rec.attribute6,
1091: l_qp_pricing_attributes_rec.attribute7,
1092: l_qp_pricing_attributes_rec.attribute8,
1093: l_qp_pricing_attributes_rec.attribute9,
1094: l_qp_pricing_attributes_rec.attribute10,
1095: l_qp_pricing_attributes_rec.attribute11,
1096: l_qp_pricing_attributes_rec.attribute12,
1097: l_qp_pricing_attributes_rec.attribute13,
1098: l_qp_pricing_attributes_rec.attribute14,

Line 1095: l_qp_pricing_attributes_rec.attribute11,

1091: l_qp_pricing_attributes_rec.attribute7,
1092: l_qp_pricing_attributes_rec.attribute8,
1093: l_qp_pricing_attributes_rec.attribute9,
1094: l_qp_pricing_attributes_rec.attribute10,
1095: l_qp_pricing_attributes_rec.attribute11,
1096: l_qp_pricing_attributes_rec.attribute12,
1097: l_qp_pricing_attributes_rec.attribute13,
1098: l_qp_pricing_attributes_rec.attribute14,
1099: l_qp_pricing_attributes_rec.attribute15,

Line 1096: l_qp_pricing_attributes_rec.attribute12,

1092: l_qp_pricing_attributes_rec.attribute8,
1093: l_qp_pricing_attributes_rec.attribute9,
1094: l_qp_pricing_attributes_rec.attribute10,
1095: l_qp_pricing_attributes_rec.attribute11,
1096: l_qp_pricing_attributes_rec.attribute12,
1097: l_qp_pricing_attributes_rec.attribute13,
1098: l_qp_pricing_attributes_rec.attribute14,
1099: l_qp_pricing_attributes_rec.attribute15,
1100: l_qp_pricing_attributes_rec.product_attribute_datatype,

Line 1097: l_qp_pricing_attributes_rec.attribute13,

1093: l_qp_pricing_attributes_rec.attribute9,
1094: l_qp_pricing_attributes_rec.attribute10,
1095: l_qp_pricing_attributes_rec.attribute11,
1096: l_qp_pricing_attributes_rec.attribute12,
1097: l_qp_pricing_attributes_rec.attribute13,
1098: l_qp_pricing_attributes_rec.attribute14,
1099: l_qp_pricing_attributes_rec.attribute15,
1100: l_qp_pricing_attributes_rec.product_attribute_datatype,
1101: l_qp_pricing_attributes_rec.pricing_attribute_datatype,

Line 1098: l_qp_pricing_attributes_rec.attribute14,

1094: l_qp_pricing_attributes_rec.attribute10,
1095: l_qp_pricing_attributes_rec.attribute11,
1096: l_qp_pricing_attributes_rec.attribute12,
1097: l_qp_pricing_attributes_rec.attribute13,
1098: l_qp_pricing_attributes_rec.attribute14,
1099: l_qp_pricing_attributes_rec.attribute15,
1100: l_qp_pricing_attributes_rec.product_attribute_datatype,
1101: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
1102: l_qp_pricing_attributes_rec.comparison_operator_code,

Line 1099: l_qp_pricing_attributes_rec.attribute15,

1095: l_qp_pricing_attributes_rec.attribute11,
1096: l_qp_pricing_attributes_rec.attribute12,
1097: l_qp_pricing_attributes_rec.attribute13,
1098: l_qp_pricing_attributes_rec.attribute14,
1099: l_qp_pricing_attributes_rec.attribute15,
1100: l_qp_pricing_attributes_rec.product_attribute_datatype,
1101: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
1102: l_qp_pricing_attributes_rec.comparison_operator_code,
1103: l_pric_attr_value_from_number,

Line 1100: l_qp_pricing_attributes_rec.product_attribute_datatype,

1096: l_qp_pricing_attributes_rec.attribute12,
1097: l_qp_pricing_attributes_rec.attribute13,
1098: l_qp_pricing_attributes_rec.attribute14,
1099: l_qp_pricing_attributes_rec.attribute15,
1100: l_qp_pricing_attributes_rec.product_attribute_datatype,
1101: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
1102: l_qp_pricing_attributes_rec.comparison_operator_code,
1103: l_pric_attr_value_from_number,
1104: l_pric_attr_value_to_number

Line 1101: l_qp_pricing_attributes_rec.pricing_attribute_datatype,

1097: l_qp_pricing_attributes_rec.attribute13,
1098: l_qp_pricing_attributes_rec.attribute14,
1099: l_qp_pricing_attributes_rec.attribute15,
1100: l_qp_pricing_attributes_rec.product_attribute_datatype,
1101: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
1102: l_qp_pricing_attributes_rec.comparison_operator_code,
1103: l_pric_attr_value_from_number,
1104: l_pric_attr_value_to_number
1105: --ENH Upgrade BOAPI for orig_sys...ref RAVI

Line 1102: l_qp_pricing_attributes_rec.comparison_operator_code,

1098: l_qp_pricing_attributes_rec.attribute14,
1099: l_qp_pricing_attributes_rec.attribute15,
1100: l_qp_pricing_attributes_rec.product_attribute_datatype,
1101: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
1102: l_qp_pricing_attributes_rec.comparison_operator_code,
1103: l_pric_attr_value_from_number,
1104: l_pric_attr_value_to_number
1105: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1106: ,to_char(l_new_pricing_attribute_id)

Line 1566: CURSOR qp_pricing_attributes_cur(p_from_list_line_id NUMBER)

1562:
1563: TYPE lines_cur_typ IS REF CURSOR;
1564: qp_list_lines_cv lines_cur_typ;
1565:
1566: CURSOR qp_pricing_attributes_cur(p_from_list_line_id NUMBER)
1567: IS
1568: SELECT *
1569: FROM qp_pricing_attributes
1570: WHERE list_line_id = p_from_list_line_id;

Line 1569: FROM qp_pricing_attributes

1565:
1566: CURSOR qp_pricing_attributes_cur(p_from_list_line_id NUMBER)
1567: IS
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 */

Line 2146: FROM qp_pricing_attributes a

2142: WHERE q.list_header_id = :frm
2143: AND (q.end_date_active IS NULL OR trunc(q.end_date_active) >= trunc(sysdate)) --Modified by dhgupta for 2100785
2144: AND q.list_line_id IN
2145: (SELECT DISTINCT a.list_line_id
2146: FROM qp_pricing_attributes a
2147: WHERE a.list_line_id = q.list_line_id ';
2148:
2149: IF (nvl(p_category_id, 0) <> 0 OR nvl(p_category_set_id, 0) <> 0) -- bug 4127037
2150: OR (p_segment1_lohi <> ''''' AND ''''') OR (p_segment2_lohi <> ''''' AND ''''')

Line 2621: /* Select qp_pricing_attributes records for the 'from' list_line_id */

2617: /*Also copy the Pricing Attributes for the copied line of the
2618: from_price_list to the new pricelist and associate it with the
2619: new_list_line_id*/
2620:
2621: /* Select qp_pricing_attributes records for the 'from' list_line_id */
2622: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (
2623: l_qp_list_lines_rec.list_line_id)
2624: LOOP
2625:

Line 2622: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (

2618: from_price_list to the new pricelist and associate it with the
2619: new_list_line_id*/
2620:
2621: /* Select qp_pricing_attributes records for the 'from' list_line_id */
2622: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (
2623: l_qp_list_lines_rec.list_line_id)
2624: LOOP
2625:
2626: -- Get next pricing_attribute_id

Line 2627: SELECT qp_pricing_attributes_s.nextval

2623: l_qp_list_lines_rec.list_line_id)
2624: LOOP
2625:
2626: -- Get next pricing_attribute_id
2627: SELECT qp_pricing_attributes_s.nextval
2628: INTO l_new_pricing_attribute_id
2629: FROM dual;
2630:
2631: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' AND

Line 2633: AND l_qp_pricing_attributes_rec.list_line_id = l_qp_list_lines_rec.list_line_id

2629: FROM dual;
2630:
2631: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' AND
2632: (l_qp_list_lines_rec.continuous_price_break_flag IS NULL OR l_qp_list_lines_rec.continuous_price_break_flag <> 'Y')
2633: AND l_qp_pricing_attributes_rec.list_line_id = l_qp_list_lines_rec.list_line_id
2634: THEN
2635: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attribute :=
2636: l_qp_pricing_attributes_rec.product_attribute;
2637: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attr_value:=

Line 2636: l_qp_pricing_attributes_rec.product_attribute;

2632: (l_qp_list_lines_rec.continuous_price_break_flag IS NULL OR l_qp_list_lines_rec.continuous_price_break_flag <> 'Y')
2633: AND l_qp_pricing_attributes_rec.list_line_id = l_qp_list_lines_rec.list_line_id
2634: THEN
2635: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attribute :=
2636: l_qp_pricing_attributes_rec.product_attribute;
2637: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attr_value:=
2638: l_qp_pricing_attributes_rec.product_attr_value;
2639: END IF;
2640:

Line 2638: l_qp_pricing_attributes_rec.product_attr_value;

2634: THEN
2635: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attribute :=
2636: l_qp_pricing_attributes_rec.product_attribute;
2637: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attr_value:=
2638: l_qp_pricing_attributes_rec.product_attr_value;
2639: END IF;
2640:
2641: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N'
2642: then

Line 2641: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N'

2637: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attr_value:=
2638: l_qp_pricing_attributes_rec.product_attr_value;
2639: END IF;
2640:
2641: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N'
2642: then
2643:
2644: BEGIN
2645:

Line 2647: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);

2643:
2644: BEGIN
2645:
2646: l_pric_attr_value_from_number :=
2647: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
2648:
2649: l_pric_attr_value_to_number :=
2650: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
2651:

Line 2650: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);

2646: l_pric_attr_value_from_number :=
2647: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
2648:
2649: l_pric_attr_value_to_number :=
2650: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
2651:
2652: EXCEPTION
2653: WHEN VALUE_ERROR THEN
2654: NULL;

Line 2662: INSERT INTO qp_pricing_attributes

2658:
2659: end if;
2660:
2661:
2662: INSERT INTO qp_pricing_attributes
2663: (pricing_attribute_id,
2664: creation_date,
2665: created_by,
2666: last_update_date,

Line 2727: l_qp_pricing_attributes_rec.pricing_phase_id,

2723: sysdate,
2724: l_conc_request_id,
2725: l_new_list_line_id, /* new list line id */
2726: l_new_list_header_id,
2727: l_qp_pricing_attributes_rec.pricing_phase_id,
2728: l_qp_pricing_attributes_rec.qualification_ind,
2729: l_qp_pricing_attributes_rec.excluder_flag,
2730: l_qp_pricing_attributes_rec.accumulate_flag,
2731: l_qp_pricing_attributes_rec.product_attribute_context,

Line 2728: l_qp_pricing_attributes_rec.qualification_ind,

2724: l_conc_request_id,
2725: l_new_list_line_id, /* new list line id */
2726: l_new_list_header_id,
2727: l_qp_pricing_attributes_rec.pricing_phase_id,
2728: l_qp_pricing_attributes_rec.qualification_ind,
2729: l_qp_pricing_attributes_rec.excluder_flag,
2730: l_qp_pricing_attributes_rec.accumulate_flag,
2731: l_qp_pricing_attributes_rec.product_attribute_context,
2732: l_qp_pricing_attributes_rec.product_attribute,

Line 2729: l_qp_pricing_attributes_rec.excluder_flag,

2725: l_new_list_line_id, /* new list line id */
2726: l_new_list_header_id,
2727: l_qp_pricing_attributes_rec.pricing_phase_id,
2728: l_qp_pricing_attributes_rec.qualification_ind,
2729: l_qp_pricing_attributes_rec.excluder_flag,
2730: l_qp_pricing_attributes_rec.accumulate_flag,
2731: l_qp_pricing_attributes_rec.product_attribute_context,
2732: l_qp_pricing_attributes_rec.product_attribute,
2733: l_qp_pricing_attributes_rec.product_attr_value,

Line 2730: l_qp_pricing_attributes_rec.accumulate_flag,

2726: l_new_list_header_id,
2727: l_qp_pricing_attributes_rec.pricing_phase_id,
2728: l_qp_pricing_attributes_rec.qualification_ind,
2729: l_qp_pricing_attributes_rec.excluder_flag,
2730: l_qp_pricing_attributes_rec.accumulate_flag,
2731: l_qp_pricing_attributes_rec.product_attribute_context,
2732: l_qp_pricing_attributes_rec.product_attribute,
2733: l_qp_pricing_attributes_rec.product_attr_value,
2734: l_qp_pricing_attributes_rec.product_uom_code,

Line 2731: l_qp_pricing_attributes_rec.product_attribute_context,

2727: l_qp_pricing_attributes_rec.pricing_phase_id,
2728: l_qp_pricing_attributes_rec.qualification_ind,
2729: l_qp_pricing_attributes_rec.excluder_flag,
2730: l_qp_pricing_attributes_rec.accumulate_flag,
2731: l_qp_pricing_attributes_rec.product_attribute_context,
2732: l_qp_pricing_attributes_rec.product_attribute,
2733: l_qp_pricing_attributes_rec.product_attr_value,
2734: l_qp_pricing_attributes_rec.product_uom_code,
2735: l_qp_pricing_attributes_rec.pricing_attribute_context,

Line 2732: l_qp_pricing_attributes_rec.product_attribute,

2728: l_qp_pricing_attributes_rec.qualification_ind,
2729: l_qp_pricing_attributes_rec.excluder_flag,
2730: l_qp_pricing_attributes_rec.accumulate_flag,
2731: l_qp_pricing_attributes_rec.product_attribute_context,
2732: l_qp_pricing_attributes_rec.product_attribute,
2733: l_qp_pricing_attributes_rec.product_attr_value,
2734: l_qp_pricing_attributes_rec.product_uom_code,
2735: l_qp_pricing_attributes_rec.pricing_attribute_context,
2736: l_qp_pricing_attributes_rec.pricing_attribute,

Line 2733: l_qp_pricing_attributes_rec.product_attr_value,

2729: l_qp_pricing_attributes_rec.excluder_flag,
2730: l_qp_pricing_attributes_rec.accumulate_flag,
2731: l_qp_pricing_attributes_rec.product_attribute_context,
2732: l_qp_pricing_attributes_rec.product_attribute,
2733: l_qp_pricing_attributes_rec.product_attr_value,
2734: l_qp_pricing_attributes_rec.product_uom_code,
2735: l_qp_pricing_attributes_rec.pricing_attribute_context,
2736: l_qp_pricing_attributes_rec.pricing_attribute,
2737: l_qp_pricing_attributes_rec.pricing_attr_value_from,

Line 2734: l_qp_pricing_attributes_rec.product_uom_code,

2730: l_qp_pricing_attributes_rec.accumulate_flag,
2731: l_qp_pricing_attributes_rec.product_attribute_context,
2732: l_qp_pricing_attributes_rec.product_attribute,
2733: l_qp_pricing_attributes_rec.product_attr_value,
2734: l_qp_pricing_attributes_rec.product_uom_code,
2735: l_qp_pricing_attributes_rec.pricing_attribute_context,
2736: l_qp_pricing_attributes_rec.pricing_attribute,
2737: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2738: l_qp_pricing_attributes_rec.pricing_attr_value_to,

Line 2735: l_qp_pricing_attributes_rec.pricing_attribute_context,

2731: l_qp_pricing_attributes_rec.product_attribute_context,
2732: l_qp_pricing_attributes_rec.product_attribute,
2733: l_qp_pricing_attributes_rec.product_attr_value,
2734: l_qp_pricing_attributes_rec.product_uom_code,
2735: l_qp_pricing_attributes_rec.pricing_attribute_context,
2736: l_qp_pricing_attributes_rec.pricing_attribute,
2737: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2738: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2739: l_qp_pricing_attributes_rec.attribute_grouping_no,

Line 2736: l_qp_pricing_attributes_rec.pricing_attribute,

2732: l_qp_pricing_attributes_rec.product_attribute,
2733: l_qp_pricing_attributes_rec.product_attr_value,
2734: l_qp_pricing_attributes_rec.product_uom_code,
2735: l_qp_pricing_attributes_rec.pricing_attribute_context,
2736: l_qp_pricing_attributes_rec.pricing_attribute,
2737: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2738: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2739: l_qp_pricing_attributes_rec.attribute_grouping_no,
2740: l_qp_pricing_attributes_rec.context,

Line 2737: l_qp_pricing_attributes_rec.pricing_attr_value_from,

2733: l_qp_pricing_attributes_rec.product_attr_value,
2734: l_qp_pricing_attributes_rec.product_uom_code,
2735: l_qp_pricing_attributes_rec.pricing_attribute_context,
2736: l_qp_pricing_attributes_rec.pricing_attribute,
2737: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2738: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2739: l_qp_pricing_attributes_rec.attribute_grouping_no,
2740: l_qp_pricing_attributes_rec.context,
2741: l_qp_pricing_attributes_rec.attribute1,

Line 2738: l_qp_pricing_attributes_rec.pricing_attr_value_to,

2734: l_qp_pricing_attributes_rec.product_uom_code,
2735: l_qp_pricing_attributes_rec.pricing_attribute_context,
2736: l_qp_pricing_attributes_rec.pricing_attribute,
2737: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2738: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2739: l_qp_pricing_attributes_rec.attribute_grouping_no,
2740: l_qp_pricing_attributes_rec.context,
2741: l_qp_pricing_attributes_rec.attribute1,
2742: l_qp_pricing_attributes_rec.attribute2,

Line 2739: l_qp_pricing_attributes_rec.attribute_grouping_no,

2735: l_qp_pricing_attributes_rec.pricing_attribute_context,
2736: l_qp_pricing_attributes_rec.pricing_attribute,
2737: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2738: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2739: l_qp_pricing_attributes_rec.attribute_grouping_no,
2740: l_qp_pricing_attributes_rec.context,
2741: l_qp_pricing_attributes_rec.attribute1,
2742: l_qp_pricing_attributes_rec.attribute2,
2743: l_qp_pricing_attributes_rec.attribute3,

Line 2740: l_qp_pricing_attributes_rec.context,

2736: l_qp_pricing_attributes_rec.pricing_attribute,
2737: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2738: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2739: l_qp_pricing_attributes_rec.attribute_grouping_no,
2740: l_qp_pricing_attributes_rec.context,
2741: l_qp_pricing_attributes_rec.attribute1,
2742: l_qp_pricing_attributes_rec.attribute2,
2743: l_qp_pricing_attributes_rec.attribute3,
2744: l_qp_pricing_attributes_rec.attribute4,

Line 2741: l_qp_pricing_attributes_rec.attribute1,

2737: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2738: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2739: l_qp_pricing_attributes_rec.attribute_grouping_no,
2740: l_qp_pricing_attributes_rec.context,
2741: l_qp_pricing_attributes_rec.attribute1,
2742: l_qp_pricing_attributes_rec.attribute2,
2743: l_qp_pricing_attributes_rec.attribute3,
2744: l_qp_pricing_attributes_rec.attribute4,
2745: l_qp_pricing_attributes_rec.attribute5,

Line 2742: l_qp_pricing_attributes_rec.attribute2,

2738: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2739: l_qp_pricing_attributes_rec.attribute_grouping_no,
2740: l_qp_pricing_attributes_rec.context,
2741: l_qp_pricing_attributes_rec.attribute1,
2742: l_qp_pricing_attributes_rec.attribute2,
2743: l_qp_pricing_attributes_rec.attribute3,
2744: l_qp_pricing_attributes_rec.attribute4,
2745: l_qp_pricing_attributes_rec.attribute5,
2746: l_qp_pricing_attributes_rec.attribute6,

Line 2743: l_qp_pricing_attributes_rec.attribute3,

2739: l_qp_pricing_attributes_rec.attribute_grouping_no,
2740: l_qp_pricing_attributes_rec.context,
2741: l_qp_pricing_attributes_rec.attribute1,
2742: l_qp_pricing_attributes_rec.attribute2,
2743: l_qp_pricing_attributes_rec.attribute3,
2744: l_qp_pricing_attributes_rec.attribute4,
2745: l_qp_pricing_attributes_rec.attribute5,
2746: l_qp_pricing_attributes_rec.attribute6,
2747: l_qp_pricing_attributes_rec.attribute7,

Line 2744: l_qp_pricing_attributes_rec.attribute4,

2740: l_qp_pricing_attributes_rec.context,
2741: l_qp_pricing_attributes_rec.attribute1,
2742: l_qp_pricing_attributes_rec.attribute2,
2743: l_qp_pricing_attributes_rec.attribute3,
2744: l_qp_pricing_attributes_rec.attribute4,
2745: l_qp_pricing_attributes_rec.attribute5,
2746: l_qp_pricing_attributes_rec.attribute6,
2747: l_qp_pricing_attributes_rec.attribute7,
2748: l_qp_pricing_attributes_rec.attribute8,

Line 2745: l_qp_pricing_attributes_rec.attribute5,

2741: l_qp_pricing_attributes_rec.attribute1,
2742: l_qp_pricing_attributes_rec.attribute2,
2743: l_qp_pricing_attributes_rec.attribute3,
2744: l_qp_pricing_attributes_rec.attribute4,
2745: l_qp_pricing_attributes_rec.attribute5,
2746: l_qp_pricing_attributes_rec.attribute6,
2747: l_qp_pricing_attributes_rec.attribute7,
2748: l_qp_pricing_attributes_rec.attribute8,
2749: l_qp_pricing_attributes_rec.attribute9,

Line 2746: l_qp_pricing_attributes_rec.attribute6,

2742: l_qp_pricing_attributes_rec.attribute2,
2743: l_qp_pricing_attributes_rec.attribute3,
2744: l_qp_pricing_attributes_rec.attribute4,
2745: l_qp_pricing_attributes_rec.attribute5,
2746: l_qp_pricing_attributes_rec.attribute6,
2747: l_qp_pricing_attributes_rec.attribute7,
2748: l_qp_pricing_attributes_rec.attribute8,
2749: l_qp_pricing_attributes_rec.attribute9,
2750: l_qp_pricing_attributes_rec.attribute10,

Line 2747: l_qp_pricing_attributes_rec.attribute7,

2743: l_qp_pricing_attributes_rec.attribute3,
2744: l_qp_pricing_attributes_rec.attribute4,
2745: l_qp_pricing_attributes_rec.attribute5,
2746: l_qp_pricing_attributes_rec.attribute6,
2747: l_qp_pricing_attributes_rec.attribute7,
2748: l_qp_pricing_attributes_rec.attribute8,
2749: l_qp_pricing_attributes_rec.attribute9,
2750: l_qp_pricing_attributes_rec.attribute10,
2751: l_qp_pricing_attributes_rec.attribute11,

Line 2748: l_qp_pricing_attributes_rec.attribute8,

2744: l_qp_pricing_attributes_rec.attribute4,
2745: l_qp_pricing_attributes_rec.attribute5,
2746: l_qp_pricing_attributes_rec.attribute6,
2747: l_qp_pricing_attributes_rec.attribute7,
2748: l_qp_pricing_attributes_rec.attribute8,
2749: l_qp_pricing_attributes_rec.attribute9,
2750: l_qp_pricing_attributes_rec.attribute10,
2751: l_qp_pricing_attributes_rec.attribute11,
2752: l_qp_pricing_attributes_rec.attribute12,

Line 2749: l_qp_pricing_attributes_rec.attribute9,

2745: l_qp_pricing_attributes_rec.attribute5,
2746: l_qp_pricing_attributes_rec.attribute6,
2747: l_qp_pricing_attributes_rec.attribute7,
2748: l_qp_pricing_attributes_rec.attribute8,
2749: l_qp_pricing_attributes_rec.attribute9,
2750: l_qp_pricing_attributes_rec.attribute10,
2751: l_qp_pricing_attributes_rec.attribute11,
2752: l_qp_pricing_attributes_rec.attribute12,
2753: l_qp_pricing_attributes_rec.attribute13,

Line 2750: l_qp_pricing_attributes_rec.attribute10,

2746: l_qp_pricing_attributes_rec.attribute6,
2747: l_qp_pricing_attributes_rec.attribute7,
2748: l_qp_pricing_attributes_rec.attribute8,
2749: l_qp_pricing_attributes_rec.attribute9,
2750: l_qp_pricing_attributes_rec.attribute10,
2751: l_qp_pricing_attributes_rec.attribute11,
2752: l_qp_pricing_attributes_rec.attribute12,
2753: l_qp_pricing_attributes_rec.attribute13,
2754: l_qp_pricing_attributes_rec.attribute14,

Line 2751: l_qp_pricing_attributes_rec.attribute11,

2747: l_qp_pricing_attributes_rec.attribute7,
2748: l_qp_pricing_attributes_rec.attribute8,
2749: l_qp_pricing_attributes_rec.attribute9,
2750: l_qp_pricing_attributes_rec.attribute10,
2751: l_qp_pricing_attributes_rec.attribute11,
2752: l_qp_pricing_attributes_rec.attribute12,
2753: l_qp_pricing_attributes_rec.attribute13,
2754: l_qp_pricing_attributes_rec.attribute14,
2755: l_qp_pricing_attributes_rec.attribute15,

Line 2752: l_qp_pricing_attributes_rec.attribute12,

2748: l_qp_pricing_attributes_rec.attribute8,
2749: l_qp_pricing_attributes_rec.attribute9,
2750: l_qp_pricing_attributes_rec.attribute10,
2751: l_qp_pricing_attributes_rec.attribute11,
2752: l_qp_pricing_attributes_rec.attribute12,
2753: l_qp_pricing_attributes_rec.attribute13,
2754: l_qp_pricing_attributes_rec.attribute14,
2755: l_qp_pricing_attributes_rec.attribute15,
2756: l_qp_pricing_attributes_rec.product_attribute_datatype,

Line 2753: l_qp_pricing_attributes_rec.attribute13,

2749: l_qp_pricing_attributes_rec.attribute9,
2750: l_qp_pricing_attributes_rec.attribute10,
2751: l_qp_pricing_attributes_rec.attribute11,
2752: l_qp_pricing_attributes_rec.attribute12,
2753: l_qp_pricing_attributes_rec.attribute13,
2754: l_qp_pricing_attributes_rec.attribute14,
2755: l_qp_pricing_attributes_rec.attribute15,
2756: l_qp_pricing_attributes_rec.product_attribute_datatype,
2757: l_qp_pricing_attributes_rec.pricing_attribute_datatype,

Line 2754: l_qp_pricing_attributes_rec.attribute14,

2750: l_qp_pricing_attributes_rec.attribute10,
2751: l_qp_pricing_attributes_rec.attribute11,
2752: l_qp_pricing_attributes_rec.attribute12,
2753: l_qp_pricing_attributes_rec.attribute13,
2754: l_qp_pricing_attributes_rec.attribute14,
2755: l_qp_pricing_attributes_rec.attribute15,
2756: l_qp_pricing_attributes_rec.product_attribute_datatype,
2757: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
2758: l_qp_pricing_attributes_rec.comparison_operator_code,

Line 2755: l_qp_pricing_attributes_rec.attribute15,

2751: l_qp_pricing_attributes_rec.attribute11,
2752: l_qp_pricing_attributes_rec.attribute12,
2753: l_qp_pricing_attributes_rec.attribute13,
2754: l_qp_pricing_attributes_rec.attribute14,
2755: l_qp_pricing_attributes_rec.attribute15,
2756: l_qp_pricing_attributes_rec.product_attribute_datatype,
2757: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
2758: l_qp_pricing_attributes_rec.comparison_operator_code,
2759: l_pric_attr_value_from_number,

Line 2756: l_qp_pricing_attributes_rec.product_attribute_datatype,

2752: l_qp_pricing_attributes_rec.attribute12,
2753: l_qp_pricing_attributes_rec.attribute13,
2754: l_qp_pricing_attributes_rec.attribute14,
2755: l_qp_pricing_attributes_rec.attribute15,
2756: l_qp_pricing_attributes_rec.product_attribute_datatype,
2757: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
2758: l_qp_pricing_attributes_rec.comparison_operator_code,
2759: l_pric_attr_value_from_number,
2760: l_pric_attr_value_to_number

Line 2757: l_qp_pricing_attributes_rec.pricing_attribute_datatype,

2753: l_qp_pricing_attributes_rec.attribute13,
2754: l_qp_pricing_attributes_rec.attribute14,
2755: l_qp_pricing_attributes_rec.attribute15,
2756: l_qp_pricing_attributes_rec.product_attribute_datatype,
2757: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
2758: l_qp_pricing_attributes_rec.comparison_operator_code,
2759: l_pric_attr_value_from_number,
2760: l_pric_attr_value_to_number
2761: --ENH Upgrade BOAPI for orig_sys...ref RAVI

Line 2758: l_qp_pricing_attributes_rec.comparison_operator_code,

2754: l_qp_pricing_attributes_rec.attribute14,
2755: l_qp_pricing_attributes_rec.attribute15,
2756: l_qp_pricing_attributes_rec.product_attribute_datatype,
2757: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
2758: l_qp_pricing_attributes_rec.comparison_operator_code,
2759: l_pric_attr_value_from_number,
2760: l_pric_attr_value_to_number
2761: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2762: ,to_char(l_new_pricing_attribute_id)

Line 2767: fnd_file.put_line(FND_FILE.LOG,'product_attribute_context ' || l_qp_pricing_attributes_rec.product_attribute_context);

2763: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_new_list_line_id)
2764: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id)
2765: );
2766: fnd_file.put_line(FND_FILE.LOG,'Inserted pricing attribute');
2767: fnd_file.put_line(FND_FILE.LOG,'product_attribute_context ' || l_qp_pricing_attributes_rec.product_attribute_context);
2768: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);
2769: fnd_file.put_line(FND_FILE.LOG,'product_attr_value ' || l_qp_pricing_attributes_rec.product_attr_value);
2770: fnd_file.put_line(FND_FILE.LOG,'product_uom_code ' || l_qp_pricing_attributes_rec.product_uom_code);
2771:

Line 2768: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);

2764: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id)
2765: );
2766: fnd_file.put_line(FND_FILE.LOG,'Inserted pricing attribute');
2767: fnd_file.put_line(FND_FILE.LOG,'product_attribute_context ' || l_qp_pricing_attributes_rec.product_attribute_context);
2768: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);
2769: fnd_file.put_line(FND_FILE.LOG,'product_attr_value ' || l_qp_pricing_attributes_rec.product_attr_value);
2770: fnd_file.put_line(FND_FILE.LOG,'product_uom_code ' || l_qp_pricing_attributes_rec.product_uom_code);
2771:
2772: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */

Line 2769: fnd_file.put_line(FND_FILE.LOG,'product_attr_value ' || l_qp_pricing_attributes_rec.product_attr_value);

2765: );
2766: fnd_file.put_line(FND_FILE.LOG,'Inserted pricing attribute');
2767: fnd_file.put_line(FND_FILE.LOG,'product_attribute_context ' || l_qp_pricing_attributes_rec.product_attribute_context);
2768: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);
2769: fnd_file.put_line(FND_FILE.LOG,'product_attr_value ' || l_qp_pricing_attributes_rec.product_attr_value);
2770: fnd_file.put_line(FND_FILE.LOG,'product_uom_code ' || l_qp_pricing_attributes_rec.product_uom_code);
2771:
2772: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
2773: end if; --bug3067774

Line 2770: fnd_file.put_line(FND_FILE.LOG,'product_uom_code ' || l_qp_pricing_attributes_rec.product_uom_code);

2766: fnd_file.put_line(FND_FILE.LOG,'Inserted pricing attribute');
2767: fnd_file.put_line(FND_FILE.LOG,'product_attribute_context ' || l_qp_pricing_attributes_rec.product_attribute_context);
2768: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);
2769: fnd_file.put_line(FND_FILE.LOG,'product_attr_value ' || l_qp_pricing_attributes_rec.product_attr_value);
2770: fnd_file.put_line(FND_FILE.LOG,'product_uom_code ' || l_qp_pricing_attributes_rec.product_uom_code);
2771:
2772: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
2773: end if; --bug3067774
2774: END LOOP; /* Cursor qp_list_lines_cv LOOP */

Line 2772: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */

2768: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);
2769: fnd_file.put_line(FND_FILE.LOG,'product_attr_value ' || l_qp_pricing_attributes_rec.product_attr_value);
2770: fnd_file.put_line(FND_FILE.LOG,'product_uom_code ' || l_qp_pricing_attributes_rec.product_uom_code);
2771:
2772: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
2773: end if; --bug3067774
2774: END LOOP; /* Cursor qp_list_lines_cv LOOP */
2775:
2776: CLOSE qp_list_lines_cv;