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 368: CURSOR qp_pricing_attributes_cur(p_from_discount_line_id NUMBER)

364: SELECT *
365: FROM qp_list_lines
366: WHERE list_header_id = p_from_discount_header_id;
367:
368: CURSOR qp_pricing_attributes_cur(p_from_discount_line_id NUMBER)
369: IS
370: SELECT *
371: FROM qp_pricing_attributes
372: WHERE list_line_id = p_from_discount_line_id;

Line 371: FROM qp_pricing_attributes

367:
368: CURSOR qp_pricing_attributes_cur(p_from_discount_line_id NUMBER)
369: IS
370: SELECT *
371: FROM qp_pricing_attributes
372: WHERE list_line_id = p_from_discount_line_id;
373:
374: CURSOR qp_rltd_modifiers_cur(a_list_line_id NUMBER)
375: IS

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

958: l_mapping_tbl(l_count).new_list_line_id := l_new_discount_line_id;
959: END IF;
960:
961:
962: /* Copy the qp_pricing_attributes records for each discount line being
963: copied */
964:
965: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur
966: (l_qp_discount_lines_rec.list_line_id)

Line 965: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur

961:
962: /* Copy the qp_pricing_attributes records for each discount line being
963: copied */
964:
965: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur
966: (l_qp_discount_lines_rec.list_line_id)
967: -- basically the from_discount_list_line_id
968: LOOP
969:

Line 971: SELECT qp_pricing_attributes_s.nextval

967: -- basically the from_discount_list_line_id
968: LOOP
969:
970: -- Get next pricing_attribute_id
971: SELECT qp_pricing_attributes_s.nextval
972: INTO l_new_pricing_attribute_id
973: FROM dual;
974:
975:

Line 976: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N'

972: INTO l_new_pricing_attribute_id
973: FROM dual;
974:
975:
976: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N'
977: then
978:
979: BEGIN
980:

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

978:
979: BEGIN
980:
981: l_pric_attr_value_from_number :=
982: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
983:
984: l_pric_attr_value_to_number :=
985: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
986:

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

981: l_pric_attr_value_from_number :=
982: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
983:
984: l_pric_attr_value_to_number :=
985: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
986:
987: EXCEPTION
988: WHEN VALUE_ERROR THEN
989: NULL;

Line 997: INSERT INTO qp_pricing_attributes

993:
994: end if;
995:
996:
997: INSERT INTO qp_pricing_attributes
998: (pricing_attribute_id,
999: creation_date,
1000: created_by,
1001: last_update_date,

Line 1062: l_qp_pricing_attributes_rec.pricing_phase_id,

1058: sysdate,
1059: p_conc_request_id,
1060: l_new_discount_line_id, /* new discount line id */
1061: l_new_discount_header_id,
1062: l_qp_pricing_attributes_rec.pricing_phase_id,
1063: l_qp_pricing_attributes_rec.qualification_ind,
1064: l_qp_pricing_attributes_rec.excluder_flag,
1065: l_qp_pricing_attributes_rec.accumulate_flag,
1066: l_qp_pricing_attributes_rec.product_attribute_context,

Line 1063: l_qp_pricing_attributes_rec.qualification_ind,

1059: p_conc_request_id,
1060: l_new_discount_line_id, /* new discount line id */
1061: l_new_discount_header_id,
1062: l_qp_pricing_attributes_rec.pricing_phase_id,
1063: l_qp_pricing_attributes_rec.qualification_ind,
1064: l_qp_pricing_attributes_rec.excluder_flag,
1065: l_qp_pricing_attributes_rec.accumulate_flag,
1066: l_qp_pricing_attributes_rec.product_attribute_context,
1067: l_qp_pricing_attributes_rec.product_attribute,

Line 1064: l_qp_pricing_attributes_rec.excluder_flag,

1060: l_new_discount_line_id, /* new discount line id */
1061: l_new_discount_header_id,
1062: l_qp_pricing_attributes_rec.pricing_phase_id,
1063: l_qp_pricing_attributes_rec.qualification_ind,
1064: l_qp_pricing_attributes_rec.excluder_flag,
1065: l_qp_pricing_attributes_rec.accumulate_flag,
1066: l_qp_pricing_attributes_rec.product_attribute_context,
1067: l_qp_pricing_attributes_rec.product_attribute,
1068: l_qp_pricing_attributes_rec.product_attr_value,

Line 1065: l_qp_pricing_attributes_rec.accumulate_flag,

1061: l_new_discount_header_id,
1062: l_qp_pricing_attributes_rec.pricing_phase_id,
1063: l_qp_pricing_attributes_rec.qualification_ind,
1064: l_qp_pricing_attributes_rec.excluder_flag,
1065: l_qp_pricing_attributes_rec.accumulate_flag,
1066: l_qp_pricing_attributes_rec.product_attribute_context,
1067: l_qp_pricing_attributes_rec.product_attribute,
1068: l_qp_pricing_attributes_rec.product_attr_value,
1069: l_qp_pricing_attributes_rec.product_uom_code,

Line 1066: l_qp_pricing_attributes_rec.product_attribute_context,

1062: l_qp_pricing_attributes_rec.pricing_phase_id,
1063: l_qp_pricing_attributes_rec.qualification_ind,
1064: l_qp_pricing_attributes_rec.excluder_flag,
1065: l_qp_pricing_attributes_rec.accumulate_flag,
1066: l_qp_pricing_attributes_rec.product_attribute_context,
1067: l_qp_pricing_attributes_rec.product_attribute,
1068: l_qp_pricing_attributes_rec.product_attr_value,
1069: l_qp_pricing_attributes_rec.product_uom_code,
1070: l_qp_pricing_attributes_rec.pricing_attribute_context,

Line 1067: l_qp_pricing_attributes_rec.product_attribute,

1063: l_qp_pricing_attributes_rec.qualification_ind,
1064: l_qp_pricing_attributes_rec.excluder_flag,
1065: l_qp_pricing_attributes_rec.accumulate_flag,
1066: l_qp_pricing_attributes_rec.product_attribute_context,
1067: l_qp_pricing_attributes_rec.product_attribute,
1068: l_qp_pricing_attributes_rec.product_attr_value,
1069: l_qp_pricing_attributes_rec.product_uom_code,
1070: l_qp_pricing_attributes_rec.pricing_attribute_context,
1071: l_qp_pricing_attributes_rec.pricing_attribute,

Line 1068: l_qp_pricing_attributes_rec.product_attr_value,

1064: l_qp_pricing_attributes_rec.excluder_flag,
1065: l_qp_pricing_attributes_rec.accumulate_flag,
1066: l_qp_pricing_attributes_rec.product_attribute_context,
1067: l_qp_pricing_attributes_rec.product_attribute,
1068: l_qp_pricing_attributes_rec.product_attr_value,
1069: l_qp_pricing_attributes_rec.product_uom_code,
1070: l_qp_pricing_attributes_rec.pricing_attribute_context,
1071: l_qp_pricing_attributes_rec.pricing_attribute,
1072: l_qp_pricing_attributes_rec.pricing_attr_value_from,

Line 1069: l_qp_pricing_attributes_rec.product_uom_code,

1065: l_qp_pricing_attributes_rec.accumulate_flag,
1066: l_qp_pricing_attributes_rec.product_attribute_context,
1067: l_qp_pricing_attributes_rec.product_attribute,
1068: l_qp_pricing_attributes_rec.product_attr_value,
1069: l_qp_pricing_attributes_rec.product_uom_code,
1070: l_qp_pricing_attributes_rec.pricing_attribute_context,
1071: l_qp_pricing_attributes_rec.pricing_attribute,
1072: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1073: l_qp_pricing_attributes_rec.pricing_attr_value_to,

Line 1070: l_qp_pricing_attributes_rec.pricing_attribute_context,

1066: l_qp_pricing_attributes_rec.product_attribute_context,
1067: l_qp_pricing_attributes_rec.product_attribute,
1068: l_qp_pricing_attributes_rec.product_attr_value,
1069: l_qp_pricing_attributes_rec.product_uom_code,
1070: l_qp_pricing_attributes_rec.pricing_attribute_context,
1071: l_qp_pricing_attributes_rec.pricing_attribute,
1072: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1073: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1074: l_qp_pricing_attributes_rec.attribute_grouping_no,

Line 1071: l_qp_pricing_attributes_rec.pricing_attribute,

1067: l_qp_pricing_attributes_rec.product_attribute,
1068: l_qp_pricing_attributes_rec.product_attr_value,
1069: l_qp_pricing_attributes_rec.product_uom_code,
1070: l_qp_pricing_attributes_rec.pricing_attribute_context,
1071: l_qp_pricing_attributes_rec.pricing_attribute,
1072: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1073: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1074: l_qp_pricing_attributes_rec.attribute_grouping_no,
1075: l_qp_pricing_attributes_rec.context,

Line 1072: l_qp_pricing_attributes_rec.pricing_attr_value_from,

1068: l_qp_pricing_attributes_rec.product_attr_value,
1069: l_qp_pricing_attributes_rec.product_uom_code,
1070: l_qp_pricing_attributes_rec.pricing_attribute_context,
1071: l_qp_pricing_attributes_rec.pricing_attribute,
1072: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1073: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1074: l_qp_pricing_attributes_rec.attribute_grouping_no,
1075: l_qp_pricing_attributes_rec.context,
1076: l_qp_pricing_attributes_rec.attribute1,

Line 1073: l_qp_pricing_attributes_rec.pricing_attr_value_to,

1069: l_qp_pricing_attributes_rec.product_uom_code,
1070: l_qp_pricing_attributes_rec.pricing_attribute_context,
1071: l_qp_pricing_attributes_rec.pricing_attribute,
1072: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1073: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1074: l_qp_pricing_attributes_rec.attribute_grouping_no,
1075: l_qp_pricing_attributes_rec.context,
1076: l_qp_pricing_attributes_rec.attribute1,
1077: l_qp_pricing_attributes_rec.attribute2,

Line 1074: l_qp_pricing_attributes_rec.attribute_grouping_no,

1070: l_qp_pricing_attributes_rec.pricing_attribute_context,
1071: l_qp_pricing_attributes_rec.pricing_attribute,
1072: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1073: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1074: l_qp_pricing_attributes_rec.attribute_grouping_no,
1075: l_qp_pricing_attributes_rec.context,
1076: l_qp_pricing_attributes_rec.attribute1,
1077: l_qp_pricing_attributes_rec.attribute2,
1078: l_qp_pricing_attributes_rec.attribute3,

Line 1075: l_qp_pricing_attributes_rec.context,

1071: l_qp_pricing_attributes_rec.pricing_attribute,
1072: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1073: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1074: l_qp_pricing_attributes_rec.attribute_grouping_no,
1075: l_qp_pricing_attributes_rec.context,
1076: l_qp_pricing_attributes_rec.attribute1,
1077: l_qp_pricing_attributes_rec.attribute2,
1078: l_qp_pricing_attributes_rec.attribute3,
1079: l_qp_pricing_attributes_rec.attribute4,

Line 1076: l_qp_pricing_attributes_rec.attribute1,

1072: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1073: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1074: l_qp_pricing_attributes_rec.attribute_grouping_no,
1075: l_qp_pricing_attributes_rec.context,
1076: l_qp_pricing_attributes_rec.attribute1,
1077: l_qp_pricing_attributes_rec.attribute2,
1078: l_qp_pricing_attributes_rec.attribute3,
1079: l_qp_pricing_attributes_rec.attribute4,
1080: l_qp_pricing_attributes_rec.attribute5,

Line 1077: l_qp_pricing_attributes_rec.attribute2,

1073: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1074: l_qp_pricing_attributes_rec.attribute_grouping_no,
1075: l_qp_pricing_attributes_rec.context,
1076: l_qp_pricing_attributes_rec.attribute1,
1077: l_qp_pricing_attributes_rec.attribute2,
1078: l_qp_pricing_attributes_rec.attribute3,
1079: l_qp_pricing_attributes_rec.attribute4,
1080: l_qp_pricing_attributes_rec.attribute5,
1081: l_qp_pricing_attributes_rec.attribute6,

Line 1078: l_qp_pricing_attributes_rec.attribute3,

1074: l_qp_pricing_attributes_rec.attribute_grouping_no,
1075: l_qp_pricing_attributes_rec.context,
1076: l_qp_pricing_attributes_rec.attribute1,
1077: l_qp_pricing_attributes_rec.attribute2,
1078: l_qp_pricing_attributes_rec.attribute3,
1079: l_qp_pricing_attributes_rec.attribute4,
1080: l_qp_pricing_attributes_rec.attribute5,
1081: l_qp_pricing_attributes_rec.attribute6,
1082: l_qp_pricing_attributes_rec.attribute7,

Line 1079: l_qp_pricing_attributes_rec.attribute4,

1075: l_qp_pricing_attributes_rec.context,
1076: l_qp_pricing_attributes_rec.attribute1,
1077: l_qp_pricing_attributes_rec.attribute2,
1078: l_qp_pricing_attributes_rec.attribute3,
1079: l_qp_pricing_attributes_rec.attribute4,
1080: l_qp_pricing_attributes_rec.attribute5,
1081: l_qp_pricing_attributes_rec.attribute6,
1082: l_qp_pricing_attributes_rec.attribute7,
1083: l_qp_pricing_attributes_rec.attribute8,

Line 1080: l_qp_pricing_attributes_rec.attribute5,

1076: l_qp_pricing_attributes_rec.attribute1,
1077: l_qp_pricing_attributes_rec.attribute2,
1078: l_qp_pricing_attributes_rec.attribute3,
1079: l_qp_pricing_attributes_rec.attribute4,
1080: l_qp_pricing_attributes_rec.attribute5,
1081: l_qp_pricing_attributes_rec.attribute6,
1082: l_qp_pricing_attributes_rec.attribute7,
1083: l_qp_pricing_attributes_rec.attribute8,
1084: l_qp_pricing_attributes_rec.attribute9,

Line 1081: l_qp_pricing_attributes_rec.attribute6,

1077: l_qp_pricing_attributes_rec.attribute2,
1078: l_qp_pricing_attributes_rec.attribute3,
1079: l_qp_pricing_attributes_rec.attribute4,
1080: l_qp_pricing_attributes_rec.attribute5,
1081: l_qp_pricing_attributes_rec.attribute6,
1082: l_qp_pricing_attributes_rec.attribute7,
1083: l_qp_pricing_attributes_rec.attribute8,
1084: l_qp_pricing_attributes_rec.attribute9,
1085: l_qp_pricing_attributes_rec.attribute10,

Line 1082: l_qp_pricing_attributes_rec.attribute7,

1078: l_qp_pricing_attributes_rec.attribute3,
1079: l_qp_pricing_attributes_rec.attribute4,
1080: l_qp_pricing_attributes_rec.attribute5,
1081: l_qp_pricing_attributes_rec.attribute6,
1082: l_qp_pricing_attributes_rec.attribute7,
1083: l_qp_pricing_attributes_rec.attribute8,
1084: l_qp_pricing_attributes_rec.attribute9,
1085: l_qp_pricing_attributes_rec.attribute10,
1086: l_qp_pricing_attributes_rec.attribute11,

Line 1083: l_qp_pricing_attributes_rec.attribute8,

1079: l_qp_pricing_attributes_rec.attribute4,
1080: l_qp_pricing_attributes_rec.attribute5,
1081: l_qp_pricing_attributes_rec.attribute6,
1082: l_qp_pricing_attributes_rec.attribute7,
1083: l_qp_pricing_attributes_rec.attribute8,
1084: l_qp_pricing_attributes_rec.attribute9,
1085: l_qp_pricing_attributes_rec.attribute10,
1086: l_qp_pricing_attributes_rec.attribute11,
1087: l_qp_pricing_attributes_rec.attribute12,

Line 1084: l_qp_pricing_attributes_rec.attribute9,

1080: l_qp_pricing_attributes_rec.attribute5,
1081: l_qp_pricing_attributes_rec.attribute6,
1082: l_qp_pricing_attributes_rec.attribute7,
1083: l_qp_pricing_attributes_rec.attribute8,
1084: l_qp_pricing_attributes_rec.attribute9,
1085: l_qp_pricing_attributes_rec.attribute10,
1086: l_qp_pricing_attributes_rec.attribute11,
1087: l_qp_pricing_attributes_rec.attribute12,
1088: l_qp_pricing_attributes_rec.attribute13,

Line 1085: l_qp_pricing_attributes_rec.attribute10,

1081: l_qp_pricing_attributes_rec.attribute6,
1082: l_qp_pricing_attributes_rec.attribute7,
1083: l_qp_pricing_attributes_rec.attribute8,
1084: l_qp_pricing_attributes_rec.attribute9,
1085: l_qp_pricing_attributes_rec.attribute10,
1086: l_qp_pricing_attributes_rec.attribute11,
1087: l_qp_pricing_attributes_rec.attribute12,
1088: l_qp_pricing_attributes_rec.attribute13,
1089: l_qp_pricing_attributes_rec.attribute14,

Line 1086: l_qp_pricing_attributes_rec.attribute11,

1082: l_qp_pricing_attributes_rec.attribute7,
1083: l_qp_pricing_attributes_rec.attribute8,
1084: l_qp_pricing_attributes_rec.attribute9,
1085: l_qp_pricing_attributes_rec.attribute10,
1086: l_qp_pricing_attributes_rec.attribute11,
1087: l_qp_pricing_attributes_rec.attribute12,
1088: l_qp_pricing_attributes_rec.attribute13,
1089: l_qp_pricing_attributes_rec.attribute14,
1090: l_qp_pricing_attributes_rec.attribute15,

Line 1087: l_qp_pricing_attributes_rec.attribute12,

1083: l_qp_pricing_attributes_rec.attribute8,
1084: l_qp_pricing_attributes_rec.attribute9,
1085: l_qp_pricing_attributes_rec.attribute10,
1086: l_qp_pricing_attributes_rec.attribute11,
1087: l_qp_pricing_attributes_rec.attribute12,
1088: l_qp_pricing_attributes_rec.attribute13,
1089: l_qp_pricing_attributes_rec.attribute14,
1090: l_qp_pricing_attributes_rec.attribute15,
1091: l_qp_pricing_attributes_rec.product_attribute_datatype,

Line 1088: l_qp_pricing_attributes_rec.attribute13,

1084: l_qp_pricing_attributes_rec.attribute9,
1085: l_qp_pricing_attributes_rec.attribute10,
1086: l_qp_pricing_attributes_rec.attribute11,
1087: l_qp_pricing_attributes_rec.attribute12,
1088: l_qp_pricing_attributes_rec.attribute13,
1089: l_qp_pricing_attributes_rec.attribute14,
1090: l_qp_pricing_attributes_rec.attribute15,
1091: l_qp_pricing_attributes_rec.product_attribute_datatype,
1092: l_qp_pricing_attributes_rec.pricing_attribute_datatype,

Line 1089: l_qp_pricing_attributes_rec.attribute14,

1085: l_qp_pricing_attributes_rec.attribute10,
1086: l_qp_pricing_attributes_rec.attribute11,
1087: l_qp_pricing_attributes_rec.attribute12,
1088: l_qp_pricing_attributes_rec.attribute13,
1089: l_qp_pricing_attributes_rec.attribute14,
1090: l_qp_pricing_attributes_rec.attribute15,
1091: l_qp_pricing_attributes_rec.product_attribute_datatype,
1092: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
1093: l_qp_pricing_attributes_rec.comparison_operator_code,

Line 1090: l_qp_pricing_attributes_rec.attribute15,

1086: l_qp_pricing_attributes_rec.attribute11,
1087: l_qp_pricing_attributes_rec.attribute12,
1088: l_qp_pricing_attributes_rec.attribute13,
1089: l_qp_pricing_attributes_rec.attribute14,
1090: l_qp_pricing_attributes_rec.attribute15,
1091: l_qp_pricing_attributes_rec.product_attribute_datatype,
1092: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
1093: l_qp_pricing_attributes_rec.comparison_operator_code,
1094: l_pric_attr_value_from_number,

Line 1091: l_qp_pricing_attributes_rec.product_attribute_datatype,

1087: l_qp_pricing_attributes_rec.attribute12,
1088: l_qp_pricing_attributes_rec.attribute13,
1089: l_qp_pricing_attributes_rec.attribute14,
1090: l_qp_pricing_attributes_rec.attribute15,
1091: l_qp_pricing_attributes_rec.product_attribute_datatype,
1092: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
1093: l_qp_pricing_attributes_rec.comparison_operator_code,
1094: l_pric_attr_value_from_number,
1095: l_pric_attr_value_to_number

Line 1092: l_qp_pricing_attributes_rec.pricing_attribute_datatype,

1088: l_qp_pricing_attributes_rec.attribute13,
1089: l_qp_pricing_attributes_rec.attribute14,
1090: l_qp_pricing_attributes_rec.attribute15,
1091: l_qp_pricing_attributes_rec.product_attribute_datatype,
1092: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
1093: l_qp_pricing_attributes_rec.comparison_operator_code,
1094: l_pric_attr_value_from_number,
1095: l_pric_attr_value_to_number
1096: --ENH Upgrade BOAPI for orig_sys...ref RAVI

Line 1093: l_qp_pricing_attributes_rec.comparison_operator_code,

1089: l_qp_pricing_attributes_rec.attribute14,
1090: l_qp_pricing_attributes_rec.attribute15,
1091: l_qp_pricing_attributes_rec.product_attribute_datatype,
1092: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
1093: l_qp_pricing_attributes_rec.comparison_operator_code,
1094: l_pric_attr_value_from_number,
1095: l_pric_attr_value_to_number
1096: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1097: ,to_char(l_new_pricing_attribute_id)

Line 1384: CURSOR qp_pricing_attributes_cur(p_from_list_line_id NUMBER)

1380:
1381: TYPE lines_cur_typ IS REF CURSOR;
1382: qp_list_lines_cv lines_cur_typ;
1383:
1384: CURSOR qp_pricing_attributes_cur(p_from_list_line_id NUMBER)
1385: IS
1386: SELECT *
1387: FROM qp_pricing_attributes
1388: WHERE list_line_id = p_from_list_line_id;

Line 1387: FROM qp_pricing_attributes

1383:
1384: CURSOR qp_pricing_attributes_cur(p_from_list_line_id NUMBER)
1385: IS
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 */

Line 1963: FROM qp_pricing_attributes a

1959: WHERE q.list_header_id = :frm
1960: AND (q.end_date_active IS NULL OR trunc(q.end_date_active) >= trunc(sysdate)) --Modified by dhgupta for 2100785
1961: AND q.list_line_id IN
1962: (SELECT DISTINCT a.list_line_id
1963: FROM qp_pricing_attributes a
1964: WHERE a.list_line_id = q.list_line_id ';
1965:
1966: IF (nvl(p_category_id, 0) <> 0 OR nvl(p_category_set_id, 0) <> 0) -- bug 4127037
1967: OR (p_segment1_lohi <> ''''' AND ''''') OR (p_segment2_lohi <> ''''' AND ''''')

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

2434: /*Also copy the Pricing Attributes for the copied line of the
2435: from_price_list to the new pricelist and associate it with the
2436: new_list_line_id*/
2437:
2438: /* Select qp_pricing_attributes records for the 'from' list_line_id */
2439: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (
2440: l_qp_list_lines_rec.list_line_id)
2441: LOOP
2442:

Line 2439: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (

2435: from_price_list to the new pricelist and associate it with the
2436: new_list_line_id*/
2437:
2438: /* Select qp_pricing_attributes records for the 'from' list_line_id */
2439: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (
2440: l_qp_list_lines_rec.list_line_id)
2441: LOOP
2442:
2443: -- Get next pricing_attribute_id

Line 2444: SELECT qp_pricing_attributes_s.nextval

2440: l_qp_list_lines_rec.list_line_id)
2441: LOOP
2442:
2443: -- Get next pricing_attribute_id
2444: SELECT qp_pricing_attributes_s.nextval
2445: INTO l_new_pricing_attribute_id
2446: FROM dual;
2447:
2448: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' AND

Line 2450: AND l_qp_pricing_attributes_rec.list_line_id = l_qp_list_lines_rec.list_line_id

2446: FROM dual;
2447:
2448: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' AND
2449: (l_qp_list_lines_rec.continuous_price_break_flag IS NULL OR l_qp_list_lines_rec.continuous_price_break_flag <> 'Y')
2450: AND l_qp_pricing_attributes_rec.list_line_id = l_qp_list_lines_rec.list_line_id
2451: THEN
2452: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attribute :=
2453: l_qp_pricing_attributes_rec.product_attribute;
2454: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attr_value:=

Line 2453: l_qp_pricing_attributes_rec.product_attribute;

2449: (l_qp_list_lines_rec.continuous_price_break_flag IS NULL OR l_qp_list_lines_rec.continuous_price_break_flag <> 'Y')
2450: AND l_qp_pricing_attributes_rec.list_line_id = l_qp_list_lines_rec.list_line_id
2451: THEN
2452: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attribute :=
2453: l_qp_pricing_attributes_rec.product_attribute;
2454: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attr_value:=
2455: l_qp_pricing_attributes_rec.product_attr_value;
2456: END IF;
2457:

Line 2455: l_qp_pricing_attributes_rec.product_attr_value;

2451: THEN
2452: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attribute :=
2453: l_qp_pricing_attributes_rec.product_attribute;
2454: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attr_value:=
2455: l_qp_pricing_attributes_rec.product_attr_value;
2456: END IF;
2457:
2458: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N'
2459: then

Line 2458: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N'

2454: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attr_value:=
2455: l_qp_pricing_attributes_rec.product_attr_value;
2456: END IF;
2457:
2458: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N'
2459: then
2460:
2461: BEGIN
2462:

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

2460:
2461: BEGIN
2462:
2463: l_pric_attr_value_from_number :=
2464: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
2465:
2466: l_pric_attr_value_to_number :=
2467: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
2468:

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

2463: l_pric_attr_value_from_number :=
2464: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
2465:
2466: l_pric_attr_value_to_number :=
2467: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
2468:
2469: EXCEPTION
2470: WHEN VALUE_ERROR THEN
2471: NULL;

Line 2479: INSERT INTO qp_pricing_attributes

2475:
2476: end if;
2477:
2478:
2479: INSERT INTO qp_pricing_attributes
2480: (pricing_attribute_id,
2481: creation_date,
2482: created_by,
2483: last_update_date,

Line 2544: l_qp_pricing_attributes_rec.pricing_phase_id,

2540: sysdate,
2541: l_conc_request_id,
2542: l_new_list_line_id, /* new list line id */
2543: l_new_list_header_id,
2544: l_qp_pricing_attributes_rec.pricing_phase_id,
2545: l_qp_pricing_attributes_rec.qualification_ind,
2546: l_qp_pricing_attributes_rec.excluder_flag,
2547: l_qp_pricing_attributes_rec.accumulate_flag,
2548: l_qp_pricing_attributes_rec.product_attribute_context,

Line 2545: l_qp_pricing_attributes_rec.qualification_ind,

2541: l_conc_request_id,
2542: l_new_list_line_id, /* new list line id */
2543: l_new_list_header_id,
2544: l_qp_pricing_attributes_rec.pricing_phase_id,
2545: l_qp_pricing_attributes_rec.qualification_ind,
2546: l_qp_pricing_attributes_rec.excluder_flag,
2547: l_qp_pricing_attributes_rec.accumulate_flag,
2548: l_qp_pricing_attributes_rec.product_attribute_context,
2549: l_qp_pricing_attributes_rec.product_attribute,

Line 2546: l_qp_pricing_attributes_rec.excluder_flag,

2542: l_new_list_line_id, /* new list line id */
2543: l_new_list_header_id,
2544: l_qp_pricing_attributes_rec.pricing_phase_id,
2545: l_qp_pricing_attributes_rec.qualification_ind,
2546: l_qp_pricing_attributes_rec.excluder_flag,
2547: l_qp_pricing_attributes_rec.accumulate_flag,
2548: l_qp_pricing_attributes_rec.product_attribute_context,
2549: l_qp_pricing_attributes_rec.product_attribute,
2550: l_qp_pricing_attributes_rec.product_attr_value,

Line 2547: l_qp_pricing_attributes_rec.accumulate_flag,

2543: l_new_list_header_id,
2544: l_qp_pricing_attributes_rec.pricing_phase_id,
2545: l_qp_pricing_attributes_rec.qualification_ind,
2546: l_qp_pricing_attributes_rec.excluder_flag,
2547: l_qp_pricing_attributes_rec.accumulate_flag,
2548: l_qp_pricing_attributes_rec.product_attribute_context,
2549: l_qp_pricing_attributes_rec.product_attribute,
2550: l_qp_pricing_attributes_rec.product_attr_value,
2551: l_qp_pricing_attributes_rec.product_uom_code,

Line 2548: l_qp_pricing_attributes_rec.product_attribute_context,

2544: l_qp_pricing_attributes_rec.pricing_phase_id,
2545: l_qp_pricing_attributes_rec.qualification_ind,
2546: l_qp_pricing_attributes_rec.excluder_flag,
2547: l_qp_pricing_attributes_rec.accumulate_flag,
2548: l_qp_pricing_attributes_rec.product_attribute_context,
2549: l_qp_pricing_attributes_rec.product_attribute,
2550: l_qp_pricing_attributes_rec.product_attr_value,
2551: l_qp_pricing_attributes_rec.product_uom_code,
2552: l_qp_pricing_attributes_rec.pricing_attribute_context,

Line 2549: l_qp_pricing_attributes_rec.product_attribute,

2545: l_qp_pricing_attributes_rec.qualification_ind,
2546: l_qp_pricing_attributes_rec.excluder_flag,
2547: l_qp_pricing_attributes_rec.accumulate_flag,
2548: l_qp_pricing_attributes_rec.product_attribute_context,
2549: l_qp_pricing_attributes_rec.product_attribute,
2550: l_qp_pricing_attributes_rec.product_attr_value,
2551: l_qp_pricing_attributes_rec.product_uom_code,
2552: l_qp_pricing_attributes_rec.pricing_attribute_context,
2553: l_qp_pricing_attributes_rec.pricing_attribute,

Line 2550: l_qp_pricing_attributes_rec.product_attr_value,

2546: l_qp_pricing_attributes_rec.excluder_flag,
2547: l_qp_pricing_attributes_rec.accumulate_flag,
2548: l_qp_pricing_attributes_rec.product_attribute_context,
2549: l_qp_pricing_attributes_rec.product_attribute,
2550: l_qp_pricing_attributes_rec.product_attr_value,
2551: l_qp_pricing_attributes_rec.product_uom_code,
2552: l_qp_pricing_attributes_rec.pricing_attribute_context,
2553: l_qp_pricing_attributes_rec.pricing_attribute,
2554: l_qp_pricing_attributes_rec.pricing_attr_value_from,

Line 2551: l_qp_pricing_attributes_rec.product_uom_code,

2547: l_qp_pricing_attributes_rec.accumulate_flag,
2548: l_qp_pricing_attributes_rec.product_attribute_context,
2549: l_qp_pricing_attributes_rec.product_attribute,
2550: l_qp_pricing_attributes_rec.product_attr_value,
2551: l_qp_pricing_attributes_rec.product_uom_code,
2552: l_qp_pricing_attributes_rec.pricing_attribute_context,
2553: l_qp_pricing_attributes_rec.pricing_attribute,
2554: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2555: l_qp_pricing_attributes_rec.pricing_attr_value_to,

Line 2552: l_qp_pricing_attributes_rec.pricing_attribute_context,

2548: l_qp_pricing_attributes_rec.product_attribute_context,
2549: l_qp_pricing_attributes_rec.product_attribute,
2550: l_qp_pricing_attributes_rec.product_attr_value,
2551: l_qp_pricing_attributes_rec.product_uom_code,
2552: l_qp_pricing_attributes_rec.pricing_attribute_context,
2553: l_qp_pricing_attributes_rec.pricing_attribute,
2554: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2555: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2556: l_qp_pricing_attributes_rec.attribute_grouping_no,

Line 2553: l_qp_pricing_attributes_rec.pricing_attribute,

2549: l_qp_pricing_attributes_rec.product_attribute,
2550: l_qp_pricing_attributes_rec.product_attr_value,
2551: l_qp_pricing_attributes_rec.product_uom_code,
2552: l_qp_pricing_attributes_rec.pricing_attribute_context,
2553: l_qp_pricing_attributes_rec.pricing_attribute,
2554: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2555: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2556: l_qp_pricing_attributes_rec.attribute_grouping_no,
2557: l_qp_pricing_attributes_rec.context,

Line 2554: l_qp_pricing_attributes_rec.pricing_attr_value_from,

2550: l_qp_pricing_attributes_rec.product_attr_value,
2551: l_qp_pricing_attributes_rec.product_uom_code,
2552: l_qp_pricing_attributes_rec.pricing_attribute_context,
2553: l_qp_pricing_attributes_rec.pricing_attribute,
2554: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2555: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2556: l_qp_pricing_attributes_rec.attribute_grouping_no,
2557: l_qp_pricing_attributes_rec.context,
2558: l_qp_pricing_attributes_rec.attribute1,

Line 2555: l_qp_pricing_attributes_rec.pricing_attr_value_to,

2551: l_qp_pricing_attributes_rec.product_uom_code,
2552: l_qp_pricing_attributes_rec.pricing_attribute_context,
2553: l_qp_pricing_attributes_rec.pricing_attribute,
2554: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2555: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2556: l_qp_pricing_attributes_rec.attribute_grouping_no,
2557: l_qp_pricing_attributes_rec.context,
2558: l_qp_pricing_attributes_rec.attribute1,
2559: l_qp_pricing_attributes_rec.attribute2,

Line 2556: l_qp_pricing_attributes_rec.attribute_grouping_no,

2552: l_qp_pricing_attributes_rec.pricing_attribute_context,
2553: l_qp_pricing_attributes_rec.pricing_attribute,
2554: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2555: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2556: l_qp_pricing_attributes_rec.attribute_grouping_no,
2557: l_qp_pricing_attributes_rec.context,
2558: l_qp_pricing_attributes_rec.attribute1,
2559: l_qp_pricing_attributes_rec.attribute2,
2560: l_qp_pricing_attributes_rec.attribute3,

Line 2557: l_qp_pricing_attributes_rec.context,

2553: l_qp_pricing_attributes_rec.pricing_attribute,
2554: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2555: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2556: l_qp_pricing_attributes_rec.attribute_grouping_no,
2557: l_qp_pricing_attributes_rec.context,
2558: l_qp_pricing_attributes_rec.attribute1,
2559: l_qp_pricing_attributes_rec.attribute2,
2560: l_qp_pricing_attributes_rec.attribute3,
2561: l_qp_pricing_attributes_rec.attribute4,

Line 2558: l_qp_pricing_attributes_rec.attribute1,

2554: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2555: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2556: l_qp_pricing_attributes_rec.attribute_grouping_no,
2557: l_qp_pricing_attributes_rec.context,
2558: l_qp_pricing_attributes_rec.attribute1,
2559: l_qp_pricing_attributes_rec.attribute2,
2560: l_qp_pricing_attributes_rec.attribute3,
2561: l_qp_pricing_attributes_rec.attribute4,
2562: l_qp_pricing_attributes_rec.attribute5,

Line 2559: l_qp_pricing_attributes_rec.attribute2,

2555: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2556: l_qp_pricing_attributes_rec.attribute_grouping_no,
2557: l_qp_pricing_attributes_rec.context,
2558: l_qp_pricing_attributes_rec.attribute1,
2559: l_qp_pricing_attributes_rec.attribute2,
2560: l_qp_pricing_attributes_rec.attribute3,
2561: l_qp_pricing_attributes_rec.attribute4,
2562: l_qp_pricing_attributes_rec.attribute5,
2563: l_qp_pricing_attributes_rec.attribute6,

Line 2560: l_qp_pricing_attributes_rec.attribute3,

2556: l_qp_pricing_attributes_rec.attribute_grouping_no,
2557: l_qp_pricing_attributes_rec.context,
2558: l_qp_pricing_attributes_rec.attribute1,
2559: l_qp_pricing_attributes_rec.attribute2,
2560: l_qp_pricing_attributes_rec.attribute3,
2561: l_qp_pricing_attributes_rec.attribute4,
2562: l_qp_pricing_attributes_rec.attribute5,
2563: l_qp_pricing_attributes_rec.attribute6,
2564: l_qp_pricing_attributes_rec.attribute7,

Line 2561: l_qp_pricing_attributes_rec.attribute4,

2557: l_qp_pricing_attributes_rec.context,
2558: l_qp_pricing_attributes_rec.attribute1,
2559: l_qp_pricing_attributes_rec.attribute2,
2560: l_qp_pricing_attributes_rec.attribute3,
2561: l_qp_pricing_attributes_rec.attribute4,
2562: l_qp_pricing_attributes_rec.attribute5,
2563: l_qp_pricing_attributes_rec.attribute6,
2564: l_qp_pricing_attributes_rec.attribute7,
2565: l_qp_pricing_attributes_rec.attribute8,

Line 2562: l_qp_pricing_attributes_rec.attribute5,

2558: l_qp_pricing_attributes_rec.attribute1,
2559: l_qp_pricing_attributes_rec.attribute2,
2560: l_qp_pricing_attributes_rec.attribute3,
2561: l_qp_pricing_attributes_rec.attribute4,
2562: l_qp_pricing_attributes_rec.attribute5,
2563: l_qp_pricing_attributes_rec.attribute6,
2564: l_qp_pricing_attributes_rec.attribute7,
2565: l_qp_pricing_attributes_rec.attribute8,
2566: l_qp_pricing_attributes_rec.attribute9,

Line 2563: l_qp_pricing_attributes_rec.attribute6,

2559: l_qp_pricing_attributes_rec.attribute2,
2560: l_qp_pricing_attributes_rec.attribute3,
2561: l_qp_pricing_attributes_rec.attribute4,
2562: l_qp_pricing_attributes_rec.attribute5,
2563: l_qp_pricing_attributes_rec.attribute6,
2564: l_qp_pricing_attributes_rec.attribute7,
2565: l_qp_pricing_attributes_rec.attribute8,
2566: l_qp_pricing_attributes_rec.attribute9,
2567: l_qp_pricing_attributes_rec.attribute10,

Line 2564: l_qp_pricing_attributes_rec.attribute7,

2560: l_qp_pricing_attributes_rec.attribute3,
2561: l_qp_pricing_attributes_rec.attribute4,
2562: l_qp_pricing_attributes_rec.attribute5,
2563: l_qp_pricing_attributes_rec.attribute6,
2564: l_qp_pricing_attributes_rec.attribute7,
2565: l_qp_pricing_attributes_rec.attribute8,
2566: l_qp_pricing_attributes_rec.attribute9,
2567: l_qp_pricing_attributes_rec.attribute10,
2568: l_qp_pricing_attributes_rec.attribute11,

Line 2565: l_qp_pricing_attributes_rec.attribute8,

2561: l_qp_pricing_attributes_rec.attribute4,
2562: l_qp_pricing_attributes_rec.attribute5,
2563: l_qp_pricing_attributes_rec.attribute6,
2564: l_qp_pricing_attributes_rec.attribute7,
2565: l_qp_pricing_attributes_rec.attribute8,
2566: l_qp_pricing_attributes_rec.attribute9,
2567: l_qp_pricing_attributes_rec.attribute10,
2568: l_qp_pricing_attributes_rec.attribute11,
2569: l_qp_pricing_attributes_rec.attribute12,

Line 2566: l_qp_pricing_attributes_rec.attribute9,

2562: l_qp_pricing_attributes_rec.attribute5,
2563: l_qp_pricing_attributes_rec.attribute6,
2564: l_qp_pricing_attributes_rec.attribute7,
2565: l_qp_pricing_attributes_rec.attribute8,
2566: l_qp_pricing_attributes_rec.attribute9,
2567: l_qp_pricing_attributes_rec.attribute10,
2568: l_qp_pricing_attributes_rec.attribute11,
2569: l_qp_pricing_attributes_rec.attribute12,
2570: l_qp_pricing_attributes_rec.attribute13,

Line 2567: l_qp_pricing_attributes_rec.attribute10,

2563: l_qp_pricing_attributes_rec.attribute6,
2564: l_qp_pricing_attributes_rec.attribute7,
2565: l_qp_pricing_attributes_rec.attribute8,
2566: l_qp_pricing_attributes_rec.attribute9,
2567: l_qp_pricing_attributes_rec.attribute10,
2568: l_qp_pricing_attributes_rec.attribute11,
2569: l_qp_pricing_attributes_rec.attribute12,
2570: l_qp_pricing_attributes_rec.attribute13,
2571: l_qp_pricing_attributes_rec.attribute14,

Line 2568: l_qp_pricing_attributes_rec.attribute11,

2564: l_qp_pricing_attributes_rec.attribute7,
2565: l_qp_pricing_attributes_rec.attribute8,
2566: l_qp_pricing_attributes_rec.attribute9,
2567: l_qp_pricing_attributes_rec.attribute10,
2568: l_qp_pricing_attributes_rec.attribute11,
2569: l_qp_pricing_attributes_rec.attribute12,
2570: l_qp_pricing_attributes_rec.attribute13,
2571: l_qp_pricing_attributes_rec.attribute14,
2572: l_qp_pricing_attributes_rec.attribute15,

Line 2569: l_qp_pricing_attributes_rec.attribute12,

2565: l_qp_pricing_attributes_rec.attribute8,
2566: l_qp_pricing_attributes_rec.attribute9,
2567: l_qp_pricing_attributes_rec.attribute10,
2568: l_qp_pricing_attributes_rec.attribute11,
2569: l_qp_pricing_attributes_rec.attribute12,
2570: l_qp_pricing_attributes_rec.attribute13,
2571: l_qp_pricing_attributes_rec.attribute14,
2572: l_qp_pricing_attributes_rec.attribute15,
2573: l_qp_pricing_attributes_rec.product_attribute_datatype,

Line 2570: l_qp_pricing_attributes_rec.attribute13,

2566: l_qp_pricing_attributes_rec.attribute9,
2567: l_qp_pricing_attributes_rec.attribute10,
2568: l_qp_pricing_attributes_rec.attribute11,
2569: l_qp_pricing_attributes_rec.attribute12,
2570: l_qp_pricing_attributes_rec.attribute13,
2571: l_qp_pricing_attributes_rec.attribute14,
2572: l_qp_pricing_attributes_rec.attribute15,
2573: l_qp_pricing_attributes_rec.product_attribute_datatype,
2574: l_qp_pricing_attributes_rec.pricing_attribute_datatype,

Line 2571: l_qp_pricing_attributes_rec.attribute14,

2567: l_qp_pricing_attributes_rec.attribute10,
2568: l_qp_pricing_attributes_rec.attribute11,
2569: l_qp_pricing_attributes_rec.attribute12,
2570: l_qp_pricing_attributes_rec.attribute13,
2571: l_qp_pricing_attributes_rec.attribute14,
2572: l_qp_pricing_attributes_rec.attribute15,
2573: l_qp_pricing_attributes_rec.product_attribute_datatype,
2574: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
2575: l_qp_pricing_attributes_rec.comparison_operator_code,

Line 2572: l_qp_pricing_attributes_rec.attribute15,

2568: l_qp_pricing_attributes_rec.attribute11,
2569: l_qp_pricing_attributes_rec.attribute12,
2570: l_qp_pricing_attributes_rec.attribute13,
2571: l_qp_pricing_attributes_rec.attribute14,
2572: l_qp_pricing_attributes_rec.attribute15,
2573: l_qp_pricing_attributes_rec.product_attribute_datatype,
2574: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
2575: l_qp_pricing_attributes_rec.comparison_operator_code,
2576: l_pric_attr_value_from_number,

Line 2573: l_qp_pricing_attributes_rec.product_attribute_datatype,

2569: l_qp_pricing_attributes_rec.attribute12,
2570: l_qp_pricing_attributes_rec.attribute13,
2571: l_qp_pricing_attributes_rec.attribute14,
2572: l_qp_pricing_attributes_rec.attribute15,
2573: l_qp_pricing_attributes_rec.product_attribute_datatype,
2574: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
2575: l_qp_pricing_attributes_rec.comparison_operator_code,
2576: l_pric_attr_value_from_number,
2577: l_pric_attr_value_to_number

Line 2574: l_qp_pricing_attributes_rec.pricing_attribute_datatype,

2570: l_qp_pricing_attributes_rec.attribute13,
2571: l_qp_pricing_attributes_rec.attribute14,
2572: l_qp_pricing_attributes_rec.attribute15,
2573: l_qp_pricing_attributes_rec.product_attribute_datatype,
2574: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
2575: l_qp_pricing_attributes_rec.comparison_operator_code,
2576: l_pric_attr_value_from_number,
2577: l_pric_attr_value_to_number
2578: --ENH Upgrade BOAPI for orig_sys...ref RAVI

Line 2575: l_qp_pricing_attributes_rec.comparison_operator_code,

2571: l_qp_pricing_attributes_rec.attribute14,
2572: l_qp_pricing_attributes_rec.attribute15,
2573: l_qp_pricing_attributes_rec.product_attribute_datatype,
2574: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
2575: l_qp_pricing_attributes_rec.comparison_operator_code,
2576: l_pric_attr_value_from_number,
2577: l_pric_attr_value_to_number
2578: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2579: ,to_char(l_new_pricing_attribute_id)

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

2580: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_new_list_line_id)
2581: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id)
2582: );
2583: fnd_file.put_line(FND_FILE.LOG,'Inserted pricing attribute');
2584: fnd_file.put_line(FND_FILE.LOG,'product_attribute_context ' || l_qp_pricing_attributes_rec.product_attribute_context);
2585: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);
2586: fnd_file.put_line(FND_FILE.LOG,'product_attr_value ' || l_qp_pricing_attributes_rec.product_attr_value);
2587: fnd_file.put_line(FND_FILE.LOG,'product_uom_code ' || l_qp_pricing_attributes_rec.product_uom_code);
2588:

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

2581: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id)
2582: );
2583: fnd_file.put_line(FND_FILE.LOG,'Inserted pricing attribute');
2584: fnd_file.put_line(FND_FILE.LOG,'product_attribute_context ' || l_qp_pricing_attributes_rec.product_attribute_context);
2585: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);
2586: fnd_file.put_line(FND_FILE.LOG,'product_attr_value ' || l_qp_pricing_attributes_rec.product_attr_value);
2587: fnd_file.put_line(FND_FILE.LOG,'product_uom_code ' || l_qp_pricing_attributes_rec.product_uom_code);
2588:
2589: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */

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

2582: );
2583: fnd_file.put_line(FND_FILE.LOG,'Inserted pricing attribute');
2584: fnd_file.put_line(FND_FILE.LOG,'product_attribute_context ' || l_qp_pricing_attributes_rec.product_attribute_context);
2585: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);
2586: fnd_file.put_line(FND_FILE.LOG,'product_attr_value ' || l_qp_pricing_attributes_rec.product_attr_value);
2587: fnd_file.put_line(FND_FILE.LOG,'product_uom_code ' || l_qp_pricing_attributes_rec.product_uom_code);
2588:
2589: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
2590: end if; --bug3067774

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

2583: fnd_file.put_line(FND_FILE.LOG,'Inserted pricing attribute');
2584: fnd_file.put_line(FND_FILE.LOG,'product_attribute_context ' || l_qp_pricing_attributes_rec.product_attribute_context);
2585: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);
2586: fnd_file.put_line(FND_FILE.LOG,'product_attr_value ' || l_qp_pricing_attributes_rec.product_attr_value);
2587: fnd_file.put_line(FND_FILE.LOG,'product_uom_code ' || l_qp_pricing_attributes_rec.product_uom_code);
2588:
2589: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
2590: end if; --bug3067774
2591: END LOOP; /* Cursor qp_list_lines_cv LOOP */

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

2585: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);
2586: fnd_file.put_line(FND_FILE.LOG,'product_attr_value ' || l_qp_pricing_attributes_rec.product_attr_value);
2587: fnd_file.put_line(FND_FILE.LOG,'product_uom_code ' || l_qp_pricing_attributes_rec.product_uom_code);
2588:
2589: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
2590: end if; --bug3067774
2591: END LOOP; /* Cursor qp_list_lines_cv LOOP */
2592:
2593: CLOSE qp_list_lines_cv;