eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_COPY_MODIFIERS_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 184: FROM qp_list_lines qll,qp_pricing_attributes qpa

180:
181: CURSOR del_dup_cur(a_new_list_header_id NUMBER)
182: IS
183: SELECT distinct qll.list_line_id,qpa.product_attribute_context,qpa.product_attribute,qpa.product_attr_value
184: FROM qp_list_lines qll,qp_pricing_attributes qpa
185: WHERE qll.list_header_id=a_new_list_header_id
186: AND qll.list_line_id=qpa.list_line_id(+);
187:
188: l_status BOOLEAN := TRUE;

Line 230: DELETE qp_pricing_Attributes

226: IF l_status= FALSE THEN
227: DELETE FROM qp_rltd_modifiers
228: WHERE from_RLTD_MODIFIER_ID=l_del_dup_cur_rec.list_line_id;
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;

Line 249: DELETE qp_pricing_attributes pa

245:
246: FOR l_del_dup_cur_rec IN del_dup_cur(p_new_list_header_id)
247: LOOP
248:
249: DELETE qp_pricing_attributes pa
250: WHERE pa.list_line_id = l_del_dup_cur_rec.list_line_id;
251:
252: DELETE qp_list_lines
253: WHERE CURRENT OF del_dup_cur;

Line 381: CURSOR qp_pricing_attributes_cur(p_from_discount_line_id NUMBER)

377: FROM qp_list_lines
378: WHERE list_header_id = p_from_discount_header_id
379: AND ((end_date_active IS NULL) OR (trunc(end_date_active) >= trunc(sysdate))); --Added for 2476973
380:
381: CURSOR qp_pricing_attributes_cur(p_from_discount_line_id NUMBER)
382: IS
383: SELECT *
384: FROM qp_pricing_attributes
385: WHERE list_line_id = p_from_discount_line_id;

Line 384: FROM qp_pricing_attributes

380:
381: CURSOR qp_pricing_attributes_cur(p_from_discount_line_id NUMBER)
382: IS
383: SELECT *
384: FROM qp_pricing_attributes
385: WHERE list_line_id = p_from_discount_line_id;
386:
387: CURSOR qp_rltd_modifiers_cur(a_list_line_id NUMBER)
388: IS

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

1336:
1337: END IF;
1338:
1339:
1340: /* Copy the qp_pricing_attributes records for each discount line being
1341: copied */
1342:
1343: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur
1344: (l_qp_discount_lines_rec.list_line_id)

Line 1343: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur

1339:
1340: /* Copy the qp_pricing_attributes records for each discount line being
1341: copied */
1342:
1343: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur
1344: (l_qp_discount_lines_rec.list_line_id)
1345: -- basically the from_discount_list_line_id
1346: LOOP
1347:

Line 1349: SELECT qp_pricing_attributes_s.nextval

1345: -- basically the from_discount_list_line_id
1346: LOOP
1347:
1348: -- Get next pricing_attribute_id
1349: SELECT qp_pricing_attributes_s.nextval
1350: INTO l_new_pricing_attribute_id
1351: FROM dual;
1352:
1353: IF l_qp_discount_lines_rec.list_line_type_code = 'PBH' AND

Line 1355: AND l_qp_pricing_attributes_rec.list_line_id = l_qp_discount_lines_rec.list_line_id

1351: FROM dual;
1352:
1353: IF l_qp_discount_lines_rec.list_line_type_code = 'PBH' AND
1354: (l_qp_discount_lines_rec.continuous_price_break_flag IS NULL OR l_qp_discount_lines_rec.continuous_price_break_flag <> 'Y')
1355: AND l_qp_pricing_attributes_rec.list_line_id = l_qp_discount_lines_rec.list_line_id
1356: THEN
1357: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attribute :=
1358: l_qp_pricing_attributes_rec.product_attribute;
1359: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attr_value:=

Line 1358: l_qp_pricing_attributes_rec.product_attribute;

1354: (l_qp_discount_lines_rec.continuous_price_break_flag IS NULL OR l_qp_discount_lines_rec.continuous_price_break_flag <> 'Y')
1355: AND l_qp_pricing_attributes_rec.list_line_id = l_qp_discount_lines_rec.list_line_id
1356: THEN
1357: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attribute :=
1358: l_qp_pricing_attributes_rec.product_attribute;
1359: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attr_value:=
1360: l_qp_pricing_attributes_rec.product_attr_value;
1361: END IF;
1362:

Line 1360: l_qp_pricing_attributes_rec.product_attr_value;

1356: THEN
1357: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attribute :=
1358: l_qp_pricing_attributes_rec.product_attribute;
1359: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attr_value:=
1360: l_qp_pricing_attributes_rec.product_attr_value;
1361: END IF;
1362:
1363:
1364:

Line 1365: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N'

1361: END IF;
1362:
1363:
1364:
1365: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N'
1366: then
1367:
1368: BEGIN
1369:

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

1367:
1368: BEGIN
1369:
1370: l_pric_attr_value_from_number :=
1371: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
1372:
1373: l_pric_attr_value_to_number :=
1374: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
1375:

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

1370: l_pric_attr_value_from_number :=
1371: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
1372:
1373: l_pric_attr_value_to_number :=
1374: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
1375:
1376: EXCEPTION
1377: WHEN VALUE_ERROR THEN
1378: NULL;

Line 1385: INSERT INTO qp_pricing_attributes

1381: END;
1382:
1383: end if;
1384:
1385: INSERT INTO qp_pricing_attributes
1386: (pricing_attribute_id,
1387: creation_date,
1388: created_by,
1389: last_update_date,

Line 1450: l_qp_pricing_attributes_rec.pricing_phase_id,

1446: sysdate,
1447: l_conc_request_id,
1448: l_new_discount_line_id, /* new discount line id */
1449: l_new_discount_header_id,
1450: l_qp_pricing_attributes_rec.pricing_phase_id,
1451: l_qp_pricing_attributes_rec.qualification_ind,
1452: l_qp_pricing_attributes_rec.excluder_flag,
1453: l_qp_pricing_attributes_rec.accumulate_flag,
1454: l_qp_pricing_attributes_rec.product_attribute_context,

Line 1451: l_qp_pricing_attributes_rec.qualification_ind,

1447: l_conc_request_id,
1448: l_new_discount_line_id, /* new discount line id */
1449: l_new_discount_header_id,
1450: l_qp_pricing_attributes_rec.pricing_phase_id,
1451: l_qp_pricing_attributes_rec.qualification_ind,
1452: l_qp_pricing_attributes_rec.excluder_flag,
1453: l_qp_pricing_attributes_rec.accumulate_flag,
1454: l_qp_pricing_attributes_rec.product_attribute_context,
1455: l_qp_pricing_attributes_rec.product_attribute,

Line 1452: l_qp_pricing_attributes_rec.excluder_flag,

1448: l_new_discount_line_id, /* new discount line id */
1449: l_new_discount_header_id,
1450: l_qp_pricing_attributes_rec.pricing_phase_id,
1451: l_qp_pricing_attributes_rec.qualification_ind,
1452: l_qp_pricing_attributes_rec.excluder_flag,
1453: l_qp_pricing_attributes_rec.accumulate_flag,
1454: l_qp_pricing_attributes_rec.product_attribute_context,
1455: l_qp_pricing_attributes_rec.product_attribute,
1456: l_qp_pricing_attributes_rec.product_attr_value,

Line 1453: l_qp_pricing_attributes_rec.accumulate_flag,

1449: l_new_discount_header_id,
1450: l_qp_pricing_attributes_rec.pricing_phase_id,
1451: l_qp_pricing_attributes_rec.qualification_ind,
1452: l_qp_pricing_attributes_rec.excluder_flag,
1453: l_qp_pricing_attributes_rec.accumulate_flag,
1454: l_qp_pricing_attributes_rec.product_attribute_context,
1455: l_qp_pricing_attributes_rec.product_attribute,
1456: l_qp_pricing_attributes_rec.product_attr_value,
1457: l_qp_pricing_attributes_rec.product_uom_code,

Line 1454: l_qp_pricing_attributes_rec.product_attribute_context,

1450: l_qp_pricing_attributes_rec.pricing_phase_id,
1451: l_qp_pricing_attributes_rec.qualification_ind,
1452: l_qp_pricing_attributes_rec.excluder_flag,
1453: l_qp_pricing_attributes_rec.accumulate_flag,
1454: l_qp_pricing_attributes_rec.product_attribute_context,
1455: l_qp_pricing_attributes_rec.product_attribute,
1456: l_qp_pricing_attributes_rec.product_attr_value,
1457: l_qp_pricing_attributes_rec.product_uom_code,
1458: l_qp_pricing_attributes_rec.pricing_attribute_context,

Line 1455: l_qp_pricing_attributes_rec.product_attribute,

1451: l_qp_pricing_attributes_rec.qualification_ind,
1452: l_qp_pricing_attributes_rec.excluder_flag,
1453: l_qp_pricing_attributes_rec.accumulate_flag,
1454: l_qp_pricing_attributes_rec.product_attribute_context,
1455: l_qp_pricing_attributes_rec.product_attribute,
1456: l_qp_pricing_attributes_rec.product_attr_value,
1457: l_qp_pricing_attributes_rec.product_uom_code,
1458: l_qp_pricing_attributes_rec.pricing_attribute_context,
1459: l_qp_pricing_attributes_rec.pricing_attribute,

Line 1456: l_qp_pricing_attributes_rec.product_attr_value,

1452: l_qp_pricing_attributes_rec.excluder_flag,
1453: l_qp_pricing_attributes_rec.accumulate_flag,
1454: l_qp_pricing_attributes_rec.product_attribute_context,
1455: l_qp_pricing_attributes_rec.product_attribute,
1456: l_qp_pricing_attributes_rec.product_attr_value,
1457: l_qp_pricing_attributes_rec.product_uom_code,
1458: l_qp_pricing_attributes_rec.pricing_attribute_context,
1459: l_qp_pricing_attributes_rec.pricing_attribute,
1460: l_qp_pricing_attributes_rec.pricing_attr_value_from,

Line 1457: l_qp_pricing_attributes_rec.product_uom_code,

1453: l_qp_pricing_attributes_rec.accumulate_flag,
1454: l_qp_pricing_attributes_rec.product_attribute_context,
1455: l_qp_pricing_attributes_rec.product_attribute,
1456: l_qp_pricing_attributes_rec.product_attr_value,
1457: l_qp_pricing_attributes_rec.product_uom_code,
1458: l_qp_pricing_attributes_rec.pricing_attribute_context,
1459: l_qp_pricing_attributes_rec.pricing_attribute,
1460: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1461: l_qp_pricing_attributes_rec.pricing_attr_value_to,

Line 1458: l_qp_pricing_attributes_rec.pricing_attribute_context,

1454: l_qp_pricing_attributes_rec.product_attribute_context,
1455: l_qp_pricing_attributes_rec.product_attribute,
1456: l_qp_pricing_attributes_rec.product_attr_value,
1457: l_qp_pricing_attributes_rec.product_uom_code,
1458: l_qp_pricing_attributes_rec.pricing_attribute_context,
1459: l_qp_pricing_attributes_rec.pricing_attribute,
1460: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1461: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1462: l_qp_pricing_attributes_rec.attribute_grouping_no,

Line 1459: l_qp_pricing_attributes_rec.pricing_attribute,

1455: l_qp_pricing_attributes_rec.product_attribute,
1456: l_qp_pricing_attributes_rec.product_attr_value,
1457: l_qp_pricing_attributes_rec.product_uom_code,
1458: l_qp_pricing_attributes_rec.pricing_attribute_context,
1459: l_qp_pricing_attributes_rec.pricing_attribute,
1460: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1461: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1462: l_qp_pricing_attributes_rec.attribute_grouping_no,
1463: l_qp_pricing_attributes_rec.context,

Line 1460: l_qp_pricing_attributes_rec.pricing_attr_value_from,

1456: l_qp_pricing_attributes_rec.product_attr_value,
1457: l_qp_pricing_attributes_rec.product_uom_code,
1458: l_qp_pricing_attributes_rec.pricing_attribute_context,
1459: l_qp_pricing_attributes_rec.pricing_attribute,
1460: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1461: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1462: l_qp_pricing_attributes_rec.attribute_grouping_no,
1463: l_qp_pricing_attributes_rec.context,
1464: l_qp_pricing_attributes_rec.attribute1,

Line 1461: l_qp_pricing_attributes_rec.pricing_attr_value_to,

1457: l_qp_pricing_attributes_rec.product_uom_code,
1458: l_qp_pricing_attributes_rec.pricing_attribute_context,
1459: l_qp_pricing_attributes_rec.pricing_attribute,
1460: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1461: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1462: l_qp_pricing_attributes_rec.attribute_grouping_no,
1463: l_qp_pricing_attributes_rec.context,
1464: l_qp_pricing_attributes_rec.attribute1,
1465: l_qp_pricing_attributes_rec.attribute2,

Line 1462: l_qp_pricing_attributes_rec.attribute_grouping_no,

1458: l_qp_pricing_attributes_rec.pricing_attribute_context,
1459: l_qp_pricing_attributes_rec.pricing_attribute,
1460: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1461: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1462: l_qp_pricing_attributes_rec.attribute_grouping_no,
1463: l_qp_pricing_attributes_rec.context,
1464: l_qp_pricing_attributes_rec.attribute1,
1465: l_qp_pricing_attributes_rec.attribute2,
1466: l_qp_pricing_attributes_rec.attribute3,

Line 1463: l_qp_pricing_attributes_rec.context,

1459: l_qp_pricing_attributes_rec.pricing_attribute,
1460: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1461: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1462: l_qp_pricing_attributes_rec.attribute_grouping_no,
1463: l_qp_pricing_attributes_rec.context,
1464: l_qp_pricing_attributes_rec.attribute1,
1465: l_qp_pricing_attributes_rec.attribute2,
1466: l_qp_pricing_attributes_rec.attribute3,
1467: l_qp_pricing_attributes_rec.attribute4,

Line 1464: l_qp_pricing_attributes_rec.attribute1,

1460: l_qp_pricing_attributes_rec.pricing_attr_value_from,
1461: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1462: l_qp_pricing_attributes_rec.attribute_grouping_no,
1463: l_qp_pricing_attributes_rec.context,
1464: l_qp_pricing_attributes_rec.attribute1,
1465: l_qp_pricing_attributes_rec.attribute2,
1466: l_qp_pricing_attributes_rec.attribute3,
1467: l_qp_pricing_attributes_rec.attribute4,
1468: l_qp_pricing_attributes_rec.attribute5,

Line 1465: l_qp_pricing_attributes_rec.attribute2,

1461: l_qp_pricing_attributes_rec.pricing_attr_value_to,
1462: l_qp_pricing_attributes_rec.attribute_grouping_no,
1463: l_qp_pricing_attributes_rec.context,
1464: l_qp_pricing_attributes_rec.attribute1,
1465: l_qp_pricing_attributes_rec.attribute2,
1466: l_qp_pricing_attributes_rec.attribute3,
1467: l_qp_pricing_attributes_rec.attribute4,
1468: l_qp_pricing_attributes_rec.attribute5,
1469: l_qp_pricing_attributes_rec.attribute6,

Line 1466: l_qp_pricing_attributes_rec.attribute3,

1462: l_qp_pricing_attributes_rec.attribute_grouping_no,
1463: l_qp_pricing_attributes_rec.context,
1464: l_qp_pricing_attributes_rec.attribute1,
1465: l_qp_pricing_attributes_rec.attribute2,
1466: l_qp_pricing_attributes_rec.attribute3,
1467: l_qp_pricing_attributes_rec.attribute4,
1468: l_qp_pricing_attributes_rec.attribute5,
1469: l_qp_pricing_attributes_rec.attribute6,
1470: l_qp_pricing_attributes_rec.attribute7,

Line 1467: l_qp_pricing_attributes_rec.attribute4,

1463: l_qp_pricing_attributes_rec.context,
1464: l_qp_pricing_attributes_rec.attribute1,
1465: l_qp_pricing_attributes_rec.attribute2,
1466: l_qp_pricing_attributes_rec.attribute3,
1467: l_qp_pricing_attributes_rec.attribute4,
1468: l_qp_pricing_attributes_rec.attribute5,
1469: l_qp_pricing_attributes_rec.attribute6,
1470: l_qp_pricing_attributes_rec.attribute7,
1471: l_qp_pricing_attributes_rec.attribute8,

Line 1468: l_qp_pricing_attributes_rec.attribute5,

1464: l_qp_pricing_attributes_rec.attribute1,
1465: l_qp_pricing_attributes_rec.attribute2,
1466: l_qp_pricing_attributes_rec.attribute3,
1467: l_qp_pricing_attributes_rec.attribute4,
1468: l_qp_pricing_attributes_rec.attribute5,
1469: l_qp_pricing_attributes_rec.attribute6,
1470: l_qp_pricing_attributes_rec.attribute7,
1471: l_qp_pricing_attributes_rec.attribute8,
1472: l_qp_pricing_attributes_rec.attribute9,

Line 1469: l_qp_pricing_attributes_rec.attribute6,

1465: l_qp_pricing_attributes_rec.attribute2,
1466: l_qp_pricing_attributes_rec.attribute3,
1467: l_qp_pricing_attributes_rec.attribute4,
1468: l_qp_pricing_attributes_rec.attribute5,
1469: l_qp_pricing_attributes_rec.attribute6,
1470: l_qp_pricing_attributes_rec.attribute7,
1471: l_qp_pricing_attributes_rec.attribute8,
1472: l_qp_pricing_attributes_rec.attribute9,
1473: l_qp_pricing_attributes_rec.attribute10,

Line 1470: l_qp_pricing_attributes_rec.attribute7,

1466: l_qp_pricing_attributes_rec.attribute3,
1467: l_qp_pricing_attributes_rec.attribute4,
1468: l_qp_pricing_attributes_rec.attribute5,
1469: l_qp_pricing_attributes_rec.attribute6,
1470: l_qp_pricing_attributes_rec.attribute7,
1471: l_qp_pricing_attributes_rec.attribute8,
1472: l_qp_pricing_attributes_rec.attribute9,
1473: l_qp_pricing_attributes_rec.attribute10,
1474: l_qp_pricing_attributes_rec.attribute11,

Line 1471: l_qp_pricing_attributes_rec.attribute8,

1467: l_qp_pricing_attributes_rec.attribute4,
1468: l_qp_pricing_attributes_rec.attribute5,
1469: l_qp_pricing_attributes_rec.attribute6,
1470: l_qp_pricing_attributes_rec.attribute7,
1471: l_qp_pricing_attributes_rec.attribute8,
1472: l_qp_pricing_attributes_rec.attribute9,
1473: l_qp_pricing_attributes_rec.attribute10,
1474: l_qp_pricing_attributes_rec.attribute11,
1475: l_qp_pricing_attributes_rec.attribute12,

Line 1472: l_qp_pricing_attributes_rec.attribute9,

1468: l_qp_pricing_attributes_rec.attribute5,
1469: l_qp_pricing_attributes_rec.attribute6,
1470: l_qp_pricing_attributes_rec.attribute7,
1471: l_qp_pricing_attributes_rec.attribute8,
1472: l_qp_pricing_attributes_rec.attribute9,
1473: l_qp_pricing_attributes_rec.attribute10,
1474: l_qp_pricing_attributes_rec.attribute11,
1475: l_qp_pricing_attributes_rec.attribute12,
1476: l_qp_pricing_attributes_rec.attribute13,

Line 1473: l_qp_pricing_attributes_rec.attribute10,

1469: l_qp_pricing_attributes_rec.attribute6,
1470: l_qp_pricing_attributes_rec.attribute7,
1471: l_qp_pricing_attributes_rec.attribute8,
1472: l_qp_pricing_attributes_rec.attribute9,
1473: l_qp_pricing_attributes_rec.attribute10,
1474: l_qp_pricing_attributes_rec.attribute11,
1475: l_qp_pricing_attributes_rec.attribute12,
1476: l_qp_pricing_attributes_rec.attribute13,
1477: l_qp_pricing_attributes_rec.attribute14,

Line 1474: l_qp_pricing_attributes_rec.attribute11,

1470: l_qp_pricing_attributes_rec.attribute7,
1471: l_qp_pricing_attributes_rec.attribute8,
1472: l_qp_pricing_attributes_rec.attribute9,
1473: l_qp_pricing_attributes_rec.attribute10,
1474: l_qp_pricing_attributes_rec.attribute11,
1475: l_qp_pricing_attributes_rec.attribute12,
1476: l_qp_pricing_attributes_rec.attribute13,
1477: l_qp_pricing_attributes_rec.attribute14,
1478: l_qp_pricing_attributes_rec.attribute15,

Line 1475: l_qp_pricing_attributes_rec.attribute12,

1471: l_qp_pricing_attributes_rec.attribute8,
1472: l_qp_pricing_attributes_rec.attribute9,
1473: l_qp_pricing_attributes_rec.attribute10,
1474: l_qp_pricing_attributes_rec.attribute11,
1475: l_qp_pricing_attributes_rec.attribute12,
1476: l_qp_pricing_attributes_rec.attribute13,
1477: l_qp_pricing_attributes_rec.attribute14,
1478: l_qp_pricing_attributes_rec.attribute15,
1479: l_qp_pricing_attributes_rec.product_attribute_datatype,

Line 1476: l_qp_pricing_attributes_rec.attribute13,

1472: l_qp_pricing_attributes_rec.attribute9,
1473: l_qp_pricing_attributes_rec.attribute10,
1474: l_qp_pricing_attributes_rec.attribute11,
1475: l_qp_pricing_attributes_rec.attribute12,
1476: l_qp_pricing_attributes_rec.attribute13,
1477: l_qp_pricing_attributes_rec.attribute14,
1478: l_qp_pricing_attributes_rec.attribute15,
1479: l_qp_pricing_attributes_rec.product_attribute_datatype,
1480: l_qp_pricing_attributes_rec.pricing_attribute_datatype,

Line 1477: l_qp_pricing_attributes_rec.attribute14,

1473: l_qp_pricing_attributes_rec.attribute10,
1474: l_qp_pricing_attributes_rec.attribute11,
1475: l_qp_pricing_attributes_rec.attribute12,
1476: l_qp_pricing_attributes_rec.attribute13,
1477: l_qp_pricing_attributes_rec.attribute14,
1478: l_qp_pricing_attributes_rec.attribute15,
1479: l_qp_pricing_attributes_rec.product_attribute_datatype,
1480: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
1481: l_qp_pricing_attributes_rec.comparison_operator_code,

Line 1478: l_qp_pricing_attributes_rec.attribute15,

1474: l_qp_pricing_attributes_rec.attribute11,
1475: l_qp_pricing_attributes_rec.attribute12,
1476: l_qp_pricing_attributes_rec.attribute13,
1477: l_qp_pricing_attributes_rec.attribute14,
1478: l_qp_pricing_attributes_rec.attribute15,
1479: l_qp_pricing_attributes_rec.product_attribute_datatype,
1480: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
1481: l_qp_pricing_attributes_rec.comparison_operator_code,
1482: l_pric_attr_value_from_number,

Line 1479: l_qp_pricing_attributes_rec.product_attribute_datatype,

1475: l_qp_pricing_attributes_rec.attribute12,
1476: l_qp_pricing_attributes_rec.attribute13,
1477: l_qp_pricing_attributes_rec.attribute14,
1478: l_qp_pricing_attributes_rec.attribute15,
1479: l_qp_pricing_attributes_rec.product_attribute_datatype,
1480: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
1481: l_qp_pricing_attributes_rec.comparison_operator_code,
1482: l_pric_attr_value_from_number,
1483: l_pric_attr_value_to_number

Line 1480: l_qp_pricing_attributes_rec.pricing_attribute_datatype,

1476: l_qp_pricing_attributes_rec.attribute13,
1477: l_qp_pricing_attributes_rec.attribute14,
1478: l_qp_pricing_attributes_rec.attribute15,
1479: l_qp_pricing_attributes_rec.product_attribute_datatype,
1480: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
1481: l_qp_pricing_attributes_rec.comparison_operator_code,
1482: l_pric_attr_value_from_number,
1483: l_pric_attr_value_to_number
1484: --ENH Upgrade BOAPI for orig_sys...ref RAVI

Line 1481: l_qp_pricing_attributes_rec.comparison_operator_code,

1477: l_qp_pricing_attributes_rec.attribute14,
1478: l_qp_pricing_attributes_rec.attribute15,
1479: l_qp_pricing_attributes_rec.product_attribute_datatype,
1480: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
1481: l_qp_pricing_attributes_rec.comparison_operator_code,
1482: l_pric_attr_value_from_number,
1483: l_pric_attr_value_to_number
1484: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1485: --,to_char(l_new_pricing_attribute_id)