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 1341: /* Copy the qp_pricing_attributes records for each discount line being

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

Line 1344: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur

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

Line 1350: SELECT qp_pricing_attributes_s.nextval

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

Line 1356: AND l_qp_pricing_attributes_rec.list_line_id = l_qp_discount_lines_rec.list_line_id

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

Line 1359: l_qp_pricing_attributes_rec.product_attribute;

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

Line 1361: l_qp_pricing_attributes_rec.product_attr_value;

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

Line 1366: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N'

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

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

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

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

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

Line 1386: INSERT INTO qp_pricing_attributes

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

Line 1451: l_qp_pricing_attributes_rec.pricing_phase_id,

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

Line 1452: l_qp_pricing_attributes_rec.qualification_ind,

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

Line 1453: l_qp_pricing_attributes_rec.excluder_flag,

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

Line 1454: l_qp_pricing_attributes_rec.accumulate_flag,

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

Line 1455: l_qp_pricing_attributes_rec.product_attribute_context,

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

Line 1456: l_qp_pricing_attributes_rec.product_attribute,

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

Line 1457: l_qp_pricing_attributes_rec.product_attr_value,

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

Line 1458: l_qp_pricing_attributes_rec.product_uom_code,

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

Line 1459: l_qp_pricing_attributes_rec.pricing_attribute_context,

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

Line 1460: l_qp_pricing_attributes_rec.pricing_attribute,

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

Line 1461: l_qp_pricing_attributes_rec.pricing_attr_value_from,

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

Line 1462: l_qp_pricing_attributes_rec.pricing_attr_value_to,

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

Line 1463: l_qp_pricing_attributes_rec.attribute_grouping_no,

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

Line 1464: l_qp_pricing_attributes_rec.context,

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

Line 1465: l_qp_pricing_attributes_rec.attribute1,

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

Line 1466: l_qp_pricing_attributes_rec.attribute2,

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

Line 1467: l_qp_pricing_attributes_rec.attribute3,

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

Line 1468: l_qp_pricing_attributes_rec.attribute4,

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

Line 1469: l_qp_pricing_attributes_rec.attribute5,

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

Line 1470: l_qp_pricing_attributes_rec.attribute6,

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

Line 1471: l_qp_pricing_attributes_rec.attribute7,

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

Line 1472: l_qp_pricing_attributes_rec.attribute8,

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

Line 1473: l_qp_pricing_attributes_rec.attribute9,

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

Line 1474: l_qp_pricing_attributes_rec.attribute10,

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

Line 1475: l_qp_pricing_attributes_rec.attribute11,

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

Line 1476: l_qp_pricing_attributes_rec.attribute12,

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

Line 1477: l_qp_pricing_attributes_rec.attribute13,

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

Line 1478: l_qp_pricing_attributes_rec.attribute14,

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

Line 1479: l_qp_pricing_attributes_rec.attribute15,

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

Line 1480: l_qp_pricing_attributes_rec.product_attribute_datatype,

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

Line 1481: l_qp_pricing_attributes_rec.pricing_attribute_datatype,

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

Line 1482: l_qp_pricing_attributes_rec.comparison_operator_code,

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