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_RLTD_MODIFIERS

Line 23: FROM qp_rltd_modifiers

19:
20: CURSOR price_break_line_cur(a_list_line_id NUMBER)
21: IS
22: SELECT to_rltd_modifier_id
23: FROM qp_rltd_modifiers
24: WHERE to_rltd_modifier_id = a_list_line_id;
25:
26: BEGIN
27:

Line 383: CURSOR qp_rltd_modifiers_cur(a_list_line_id NUMBER)

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
385: SELECT *
386: FROM qp_rltd_modifiers
387: WHERE from_rltd_modifier_id = a_list_line_id;

Line 386: FROM qp_rltd_modifiers

382:
383: CURSOR qp_rltd_modifiers_cur(a_list_line_id NUMBER)
384: IS
385: SELECT *
386: FROM qp_rltd_modifiers
387: WHERE from_rltd_modifier_id = a_list_line_id;
388:
389: --bug#6636843
390: CURSOR qp_list_headers_tl_cur(a_list_hdr_id qp_list_headers_tl.list_header_id%TYPE)

Line 1287: /* Copy qp_rltd_modifiers for the Price Break Parent list_lines chosen

1283: END LOOP; /* For copying qualifiers */---Added for bug 8326619
1284: -------------------bug 8326619--------------------------------
1285: END LOOP; /* For copying discount lines*/
1286:
1287: /* Copy qp_rltd_modifiers for the Price Break Parent list_lines chosen
1288: above which are stored in the mapping table */
1289:
1290: IF l_mapping_tbl.COUNT > 0 THEN
1291: FOR l_count IN 1..l_mapping_tbl.COUNT

Line 1296: FOR l_qp_rltd_modifiers_rec IN qp_rltd_modifiers_cur(

1292: LOOP
1293:
1294: IF l_mapping_tbl(l_count).list_line_type_code = 'PBH' THEN
1295:
1296: FOR l_qp_rltd_modifiers_rec IN qp_rltd_modifiers_cur(
1297: l_mapping_tbl(l_count).old_list_line_id)
1298: LOOP
1299:
1300: SELECT qp_rltd_modifiers_s.nextval

Line 1300: SELECT qp_rltd_modifiers_s.nextval

1296: FOR l_qp_rltd_modifiers_rec IN qp_rltd_modifiers_cur(
1297: l_mapping_tbl(l_count).old_list_line_id)
1298: LOOP
1299:
1300: SELECT qp_rltd_modifiers_s.nextval
1301: INTO l_new_rltd_modifier_id
1302: FROM dual;
1303:
1304: l_new_from_id := Get_New_Id(

Line 1305: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,

1301: INTO l_new_rltd_modifier_id
1302: FROM dual;
1303:
1304: l_new_from_id := Get_New_Id(
1305: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,
1306: l_mapping_tbl);
1307: l_new_to_id := Get_New_Id(
1308: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,
1309: l_mapping_tbl);

Line 1308: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,

1304: l_new_from_id := Get_New_Id(
1305: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,
1306: l_mapping_tbl);
1307: l_new_to_id := Get_New_Id(
1308: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,
1309: l_mapping_tbl);
1310: INSERT INTO qp_rltd_modifiers
1311: (creation_date,
1312: created_by,

Line 1310: INSERT INTO qp_rltd_modifiers

1306: l_mapping_tbl);
1307: l_new_to_id := Get_New_Id(
1308: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,
1309: l_mapping_tbl);
1310: INSERT INTO qp_rltd_modifiers
1311: (creation_date,
1312: created_by,
1313: last_update_date,
1314: last_updated_by,

Line 1344: l_qp_rltd_modifiers_rec.context,

1340: p_user_id,
1341: sysdate,
1342: p_user_id,
1343: p_conc_login_id,
1344: l_qp_rltd_modifiers_rec.context,
1345: l_qp_rltd_modifiers_rec.attribute1,
1346: l_qp_rltd_modifiers_rec.attribute2,
1347: l_qp_rltd_modifiers_rec.attribute3,
1348: l_qp_rltd_modifiers_rec.attribute4,

Line 1345: l_qp_rltd_modifiers_rec.attribute1,

1341: sysdate,
1342: p_user_id,
1343: p_conc_login_id,
1344: l_qp_rltd_modifiers_rec.context,
1345: l_qp_rltd_modifiers_rec.attribute1,
1346: l_qp_rltd_modifiers_rec.attribute2,
1347: l_qp_rltd_modifiers_rec.attribute3,
1348: l_qp_rltd_modifiers_rec.attribute4,
1349: l_qp_rltd_modifiers_rec.attribute5,

Line 1346: l_qp_rltd_modifiers_rec.attribute2,

1342: p_user_id,
1343: p_conc_login_id,
1344: l_qp_rltd_modifiers_rec.context,
1345: l_qp_rltd_modifiers_rec.attribute1,
1346: l_qp_rltd_modifiers_rec.attribute2,
1347: l_qp_rltd_modifiers_rec.attribute3,
1348: l_qp_rltd_modifiers_rec.attribute4,
1349: l_qp_rltd_modifiers_rec.attribute5,
1350: l_qp_rltd_modifiers_rec.attribute6,

Line 1347: l_qp_rltd_modifiers_rec.attribute3,

1343: p_conc_login_id,
1344: l_qp_rltd_modifiers_rec.context,
1345: l_qp_rltd_modifiers_rec.attribute1,
1346: l_qp_rltd_modifiers_rec.attribute2,
1347: l_qp_rltd_modifiers_rec.attribute3,
1348: l_qp_rltd_modifiers_rec.attribute4,
1349: l_qp_rltd_modifiers_rec.attribute5,
1350: l_qp_rltd_modifiers_rec.attribute6,
1351: l_qp_rltd_modifiers_rec.attribute7,

Line 1348: l_qp_rltd_modifiers_rec.attribute4,

1344: l_qp_rltd_modifiers_rec.context,
1345: l_qp_rltd_modifiers_rec.attribute1,
1346: l_qp_rltd_modifiers_rec.attribute2,
1347: l_qp_rltd_modifiers_rec.attribute3,
1348: l_qp_rltd_modifiers_rec.attribute4,
1349: l_qp_rltd_modifiers_rec.attribute5,
1350: l_qp_rltd_modifiers_rec.attribute6,
1351: l_qp_rltd_modifiers_rec.attribute7,
1352: l_qp_rltd_modifiers_rec.attribute8,

Line 1349: l_qp_rltd_modifiers_rec.attribute5,

1345: l_qp_rltd_modifiers_rec.attribute1,
1346: l_qp_rltd_modifiers_rec.attribute2,
1347: l_qp_rltd_modifiers_rec.attribute3,
1348: l_qp_rltd_modifiers_rec.attribute4,
1349: l_qp_rltd_modifiers_rec.attribute5,
1350: l_qp_rltd_modifiers_rec.attribute6,
1351: l_qp_rltd_modifiers_rec.attribute7,
1352: l_qp_rltd_modifiers_rec.attribute8,
1353: l_qp_rltd_modifiers_rec.attribute9,

Line 1350: l_qp_rltd_modifiers_rec.attribute6,

1346: l_qp_rltd_modifiers_rec.attribute2,
1347: l_qp_rltd_modifiers_rec.attribute3,
1348: l_qp_rltd_modifiers_rec.attribute4,
1349: l_qp_rltd_modifiers_rec.attribute5,
1350: l_qp_rltd_modifiers_rec.attribute6,
1351: l_qp_rltd_modifiers_rec.attribute7,
1352: l_qp_rltd_modifiers_rec.attribute8,
1353: l_qp_rltd_modifiers_rec.attribute9,
1354: l_qp_rltd_modifiers_rec.attribute10,

Line 1351: l_qp_rltd_modifiers_rec.attribute7,

1347: l_qp_rltd_modifiers_rec.attribute3,
1348: l_qp_rltd_modifiers_rec.attribute4,
1349: l_qp_rltd_modifiers_rec.attribute5,
1350: l_qp_rltd_modifiers_rec.attribute6,
1351: l_qp_rltd_modifiers_rec.attribute7,
1352: l_qp_rltd_modifiers_rec.attribute8,
1353: l_qp_rltd_modifiers_rec.attribute9,
1354: l_qp_rltd_modifiers_rec.attribute10,
1355: l_qp_rltd_modifiers_rec.attribute11,

Line 1352: l_qp_rltd_modifiers_rec.attribute8,

1348: l_qp_rltd_modifiers_rec.attribute4,
1349: l_qp_rltd_modifiers_rec.attribute5,
1350: l_qp_rltd_modifiers_rec.attribute6,
1351: l_qp_rltd_modifiers_rec.attribute7,
1352: l_qp_rltd_modifiers_rec.attribute8,
1353: l_qp_rltd_modifiers_rec.attribute9,
1354: l_qp_rltd_modifiers_rec.attribute10,
1355: l_qp_rltd_modifiers_rec.attribute11,
1356: l_qp_rltd_modifiers_rec.attribute12,

Line 1353: l_qp_rltd_modifiers_rec.attribute9,

1349: l_qp_rltd_modifiers_rec.attribute5,
1350: l_qp_rltd_modifiers_rec.attribute6,
1351: l_qp_rltd_modifiers_rec.attribute7,
1352: l_qp_rltd_modifiers_rec.attribute8,
1353: l_qp_rltd_modifiers_rec.attribute9,
1354: l_qp_rltd_modifiers_rec.attribute10,
1355: l_qp_rltd_modifiers_rec.attribute11,
1356: l_qp_rltd_modifiers_rec.attribute12,
1357: l_qp_rltd_modifiers_rec.attribute13,

Line 1354: l_qp_rltd_modifiers_rec.attribute10,

1350: l_qp_rltd_modifiers_rec.attribute6,
1351: l_qp_rltd_modifiers_rec.attribute7,
1352: l_qp_rltd_modifiers_rec.attribute8,
1353: l_qp_rltd_modifiers_rec.attribute9,
1354: l_qp_rltd_modifiers_rec.attribute10,
1355: l_qp_rltd_modifiers_rec.attribute11,
1356: l_qp_rltd_modifiers_rec.attribute12,
1357: l_qp_rltd_modifiers_rec.attribute13,
1358: l_qp_rltd_modifiers_rec.attribute14,

Line 1355: l_qp_rltd_modifiers_rec.attribute11,

1351: l_qp_rltd_modifiers_rec.attribute7,
1352: l_qp_rltd_modifiers_rec.attribute8,
1353: l_qp_rltd_modifiers_rec.attribute9,
1354: l_qp_rltd_modifiers_rec.attribute10,
1355: l_qp_rltd_modifiers_rec.attribute11,
1356: l_qp_rltd_modifiers_rec.attribute12,
1357: l_qp_rltd_modifiers_rec.attribute13,
1358: l_qp_rltd_modifiers_rec.attribute14,
1359: l_qp_rltd_modifiers_rec.attribute15,

Line 1356: l_qp_rltd_modifiers_rec.attribute12,

1352: l_qp_rltd_modifiers_rec.attribute8,
1353: l_qp_rltd_modifiers_rec.attribute9,
1354: l_qp_rltd_modifiers_rec.attribute10,
1355: l_qp_rltd_modifiers_rec.attribute11,
1356: l_qp_rltd_modifiers_rec.attribute12,
1357: l_qp_rltd_modifiers_rec.attribute13,
1358: l_qp_rltd_modifiers_rec.attribute14,
1359: l_qp_rltd_modifiers_rec.attribute15,
1360: l_new_rltd_modifier_id,

Line 1357: l_qp_rltd_modifiers_rec.attribute13,

1353: l_qp_rltd_modifiers_rec.attribute9,
1354: l_qp_rltd_modifiers_rec.attribute10,
1355: l_qp_rltd_modifiers_rec.attribute11,
1356: l_qp_rltd_modifiers_rec.attribute12,
1357: l_qp_rltd_modifiers_rec.attribute13,
1358: l_qp_rltd_modifiers_rec.attribute14,
1359: l_qp_rltd_modifiers_rec.attribute15,
1360: l_new_rltd_modifier_id,
1361: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,

Line 1358: l_qp_rltd_modifiers_rec.attribute14,

1354: l_qp_rltd_modifiers_rec.attribute10,
1355: l_qp_rltd_modifiers_rec.attribute11,
1356: l_qp_rltd_modifiers_rec.attribute12,
1357: l_qp_rltd_modifiers_rec.attribute13,
1358: l_qp_rltd_modifiers_rec.attribute14,
1359: l_qp_rltd_modifiers_rec.attribute15,
1360: l_new_rltd_modifier_id,
1361: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
1362: l_new_from_id,

Line 1359: l_qp_rltd_modifiers_rec.attribute15,

1355: l_qp_rltd_modifiers_rec.attribute11,
1356: l_qp_rltd_modifiers_rec.attribute12,
1357: l_qp_rltd_modifiers_rec.attribute13,
1358: l_qp_rltd_modifiers_rec.attribute14,
1359: l_qp_rltd_modifiers_rec.attribute15,
1360: l_new_rltd_modifier_id,
1361: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
1362: l_new_from_id,
1363: l_new_to_id,

Line 1361: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,

1357: l_qp_rltd_modifiers_rec.attribute13,
1358: l_qp_rltd_modifiers_rec.attribute14,
1359: l_qp_rltd_modifiers_rec.attribute15,
1360: l_new_rltd_modifier_id,
1361: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
1362: l_new_from_id,
1363: l_new_to_id,
1364: l_qp_rltd_modifiers_rec.rltd_modifier_grp_type
1365: );

Line 1364: l_qp_rltd_modifiers_rec.rltd_modifier_grp_type

1360: l_new_rltd_modifier_id,
1361: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
1362: l_new_from_id,
1363: l_new_to_id,
1364: l_qp_rltd_modifiers_rec.rltd_modifier_grp_type
1365: );
1366:
1367: END LOOP; -- Loop through rltd modifiers records
1368: END IF; --For lines that are Parent Price Break lines

Line 1605: CURSOR qp_rltd_modifiers_cur(a_list_line_id NUMBER)

1601: And a.list_type_code = 'PRL'
1602: )*/
1603: );
1604:
1605: CURSOR qp_rltd_modifiers_cur(a_list_line_id NUMBER)
1606: IS
1607: SELECT *
1608: FROM qp_rltd_modifiers
1609: WHERE from_rltd_modifier_id = a_list_line_id;

Line 1608: FROM qp_rltd_modifiers

1604:
1605: CURSOR qp_rltd_modifiers_cur(a_list_line_id NUMBER)
1606: IS
1607: SELECT *
1608: FROM qp_rltd_modifiers
1609: WHERE from_rltd_modifier_id = a_list_line_id;
1610:
1611: BEGIN
1612:

Line 2367: from qp_rltd_modifiers

2363:
2364: insert_flag :='N';
2365: BEGIN
2366: select from_rltd_modifier_id into l_line_id
2367: from qp_rltd_modifiers
2368: where to_rltd_modifier_id=l_qp_list_lines_rec.list_line_id;
2369: Exception
2370: when no_data_found then
2371: l_line_id:=null;

Line 2779: /* Copy qp_rltd_modifiers for the Price Break Parent list_lines chosen

2775:
2776: CLOSE qp_list_lines_cv;
2777:
2778:
2779: /* Copy qp_rltd_modifiers for the Price Break Parent list_lines chosen
2780: above which are stored in the mapping table */
2781: IF l_mapping_tbl.COUNT > 0 THEN
2782: FOR l_count IN 1..l_mapping_tbl.COUNT
2783: LOOP

Line 2787: FOR l_qp_rltd_modifiers_rec IN qp_rltd_modifiers_cur(

2783: LOOP
2784:
2785: IF l_mapping_tbl(l_count).list_line_type_code = 'PBH' THEN
2786:
2787: FOR l_qp_rltd_modifiers_rec IN qp_rltd_modifiers_cur(
2788: l_mapping_tbl(l_count).old_list_line_id)
2789: LOOP
2790:
2791: SELECT qp_rltd_modifiers_s.nextval

Line 2791: SELECT qp_rltd_modifiers_s.nextval

2787: FOR l_qp_rltd_modifiers_rec IN qp_rltd_modifiers_cur(
2788: l_mapping_tbl(l_count).old_list_line_id)
2789: LOOP
2790:
2791: SELECT qp_rltd_modifiers_s.nextval
2792: INTO l_new_rltd_modifier_id
2793: FROM dual;
2794:
2795: l_new_from_id := Get_New_Id(

Line 2796: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,

2792: INTO l_new_rltd_modifier_id
2793: FROM dual;
2794:
2795: l_new_from_id := Get_New_Id(
2796: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,
2797: l_mapping_tbl);
2798: l_new_to_id := Get_New_Id(
2799: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,
2800: l_mapping_tbl);

Line 2799: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,

2795: l_new_from_id := Get_New_Id(
2796: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,
2797: l_mapping_tbl);
2798: l_new_to_id := Get_New_Id(
2799: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,
2800: l_mapping_tbl);
2801: INSERT INTO qp_rltd_modifiers
2802: (creation_date,
2803: created_by,

Line 2801: INSERT INTO qp_rltd_modifiers

2797: l_mapping_tbl);
2798: l_new_to_id := Get_New_Id(
2799: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,
2800: l_mapping_tbl);
2801: INSERT INTO qp_rltd_modifiers
2802: (creation_date,
2803: created_by,
2804: last_update_date,
2805: last_updated_by,

Line 2835: l_qp_rltd_modifiers_rec.context,

2831: l_user_id,
2832: sysdate,
2833: l_user_id,
2834: l_conc_login_id,
2835: l_qp_rltd_modifiers_rec.context,
2836: l_qp_rltd_modifiers_rec.attribute1,
2837: l_qp_rltd_modifiers_rec.attribute2,
2838: l_qp_rltd_modifiers_rec.attribute3,
2839: l_qp_rltd_modifiers_rec.attribute4,

Line 2836: l_qp_rltd_modifiers_rec.attribute1,

2832: sysdate,
2833: l_user_id,
2834: l_conc_login_id,
2835: l_qp_rltd_modifiers_rec.context,
2836: l_qp_rltd_modifiers_rec.attribute1,
2837: l_qp_rltd_modifiers_rec.attribute2,
2838: l_qp_rltd_modifiers_rec.attribute3,
2839: l_qp_rltd_modifiers_rec.attribute4,
2840: l_qp_rltd_modifiers_rec.attribute5,

Line 2837: l_qp_rltd_modifiers_rec.attribute2,

2833: l_user_id,
2834: l_conc_login_id,
2835: l_qp_rltd_modifiers_rec.context,
2836: l_qp_rltd_modifiers_rec.attribute1,
2837: l_qp_rltd_modifiers_rec.attribute2,
2838: l_qp_rltd_modifiers_rec.attribute3,
2839: l_qp_rltd_modifiers_rec.attribute4,
2840: l_qp_rltd_modifiers_rec.attribute5,
2841: l_qp_rltd_modifiers_rec.attribute6,

Line 2838: l_qp_rltd_modifiers_rec.attribute3,

2834: l_conc_login_id,
2835: l_qp_rltd_modifiers_rec.context,
2836: l_qp_rltd_modifiers_rec.attribute1,
2837: l_qp_rltd_modifiers_rec.attribute2,
2838: l_qp_rltd_modifiers_rec.attribute3,
2839: l_qp_rltd_modifiers_rec.attribute4,
2840: l_qp_rltd_modifiers_rec.attribute5,
2841: l_qp_rltd_modifiers_rec.attribute6,
2842: l_qp_rltd_modifiers_rec.attribute7,

Line 2839: l_qp_rltd_modifiers_rec.attribute4,

2835: l_qp_rltd_modifiers_rec.context,
2836: l_qp_rltd_modifiers_rec.attribute1,
2837: l_qp_rltd_modifiers_rec.attribute2,
2838: l_qp_rltd_modifiers_rec.attribute3,
2839: l_qp_rltd_modifiers_rec.attribute4,
2840: l_qp_rltd_modifiers_rec.attribute5,
2841: l_qp_rltd_modifiers_rec.attribute6,
2842: l_qp_rltd_modifiers_rec.attribute7,
2843: l_qp_rltd_modifiers_rec.attribute8,

Line 2840: l_qp_rltd_modifiers_rec.attribute5,

2836: l_qp_rltd_modifiers_rec.attribute1,
2837: l_qp_rltd_modifiers_rec.attribute2,
2838: l_qp_rltd_modifiers_rec.attribute3,
2839: l_qp_rltd_modifiers_rec.attribute4,
2840: l_qp_rltd_modifiers_rec.attribute5,
2841: l_qp_rltd_modifiers_rec.attribute6,
2842: l_qp_rltd_modifiers_rec.attribute7,
2843: l_qp_rltd_modifiers_rec.attribute8,
2844: l_qp_rltd_modifiers_rec.attribute9,

Line 2841: l_qp_rltd_modifiers_rec.attribute6,

2837: l_qp_rltd_modifiers_rec.attribute2,
2838: l_qp_rltd_modifiers_rec.attribute3,
2839: l_qp_rltd_modifiers_rec.attribute4,
2840: l_qp_rltd_modifiers_rec.attribute5,
2841: l_qp_rltd_modifiers_rec.attribute6,
2842: l_qp_rltd_modifiers_rec.attribute7,
2843: l_qp_rltd_modifiers_rec.attribute8,
2844: l_qp_rltd_modifiers_rec.attribute9,
2845: l_qp_rltd_modifiers_rec.attribute10,

Line 2842: l_qp_rltd_modifiers_rec.attribute7,

2838: l_qp_rltd_modifiers_rec.attribute3,
2839: l_qp_rltd_modifiers_rec.attribute4,
2840: l_qp_rltd_modifiers_rec.attribute5,
2841: l_qp_rltd_modifiers_rec.attribute6,
2842: l_qp_rltd_modifiers_rec.attribute7,
2843: l_qp_rltd_modifiers_rec.attribute8,
2844: l_qp_rltd_modifiers_rec.attribute9,
2845: l_qp_rltd_modifiers_rec.attribute10,
2846: l_qp_rltd_modifiers_rec.attribute11,

Line 2843: l_qp_rltd_modifiers_rec.attribute8,

2839: l_qp_rltd_modifiers_rec.attribute4,
2840: l_qp_rltd_modifiers_rec.attribute5,
2841: l_qp_rltd_modifiers_rec.attribute6,
2842: l_qp_rltd_modifiers_rec.attribute7,
2843: l_qp_rltd_modifiers_rec.attribute8,
2844: l_qp_rltd_modifiers_rec.attribute9,
2845: l_qp_rltd_modifiers_rec.attribute10,
2846: l_qp_rltd_modifiers_rec.attribute11,
2847: l_qp_rltd_modifiers_rec.attribute12,

Line 2844: l_qp_rltd_modifiers_rec.attribute9,

2840: l_qp_rltd_modifiers_rec.attribute5,
2841: l_qp_rltd_modifiers_rec.attribute6,
2842: l_qp_rltd_modifiers_rec.attribute7,
2843: l_qp_rltd_modifiers_rec.attribute8,
2844: l_qp_rltd_modifiers_rec.attribute9,
2845: l_qp_rltd_modifiers_rec.attribute10,
2846: l_qp_rltd_modifiers_rec.attribute11,
2847: l_qp_rltd_modifiers_rec.attribute12,
2848: l_qp_rltd_modifiers_rec.attribute13,

Line 2845: l_qp_rltd_modifiers_rec.attribute10,

2841: l_qp_rltd_modifiers_rec.attribute6,
2842: l_qp_rltd_modifiers_rec.attribute7,
2843: l_qp_rltd_modifiers_rec.attribute8,
2844: l_qp_rltd_modifiers_rec.attribute9,
2845: l_qp_rltd_modifiers_rec.attribute10,
2846: l_qp_rltd_modifiers_rec.attribute11,
2847: l_qp_rltd_modifiers_rec.attribute12,
2848: l_qp_rltd_modifiers_rec.attribute13,
2849: l_qp_rltd_modifiers_rec.attribute14,

Line 2846: l_qp_rltd_modifiers_rec.attribute11,

2842: l_qp_rltd_modifiers_rec.attribute7,
2843: l_qp_rltd_modifiers_rec.attribute8,
2844: l_qp_rltd_modifiers_rec.attribute9,
2845: l_qp_rltd_modifiers_rec.attribute10,
2846: l_qp_rltd_modifiers_rec.attribute11,
2847: l_qp_rltd_modifiers_rec.attribute12,
2848: l_qp_rltd_modifiers_rec.attribute13,
2849: l_qp_rltd_modifiers_rec.attribute14,
2850: l_qp_rltd_modifiers_rec.attribute15,

Line 2847: l_qp_rltd_modifiers_rec.attribute12,

2843: l_qp_rltd_modifiers_rec.attribute8,
2844: l_qp_rltd_modifiers_rec.attribute9,
2845: l_qp_rltd_modifiers_rec.attribute10,
2846: l_qp_rltd_modifiers_rec.attribute11,
2847: l_qp_rltd_modifiers_rec.attribute12,
2848: l_qp_rltd_modifiers_rec.attribute13,
2849: l_qp_rltd_modifiers_rec.attribute14,
2850: l_qp_rltd_modifiers_rec.attribute15,
2851: l_new_rltd_modifier_id,

Line 2848: l_qp_rltd_modifiers_rec.attribute13,

2844: l_qp_rltd_modifiers_rec.attribute9,
2845: l_qp_rltd_modifiers_rec.attribute10,
2846: l_qp_rltd_modifiers_rec.attribute11,
2847: l_qp_rltd_modifiers_rec.attribute12,
2848: l_qp_rltd_modifiers_rec.attribute13,
2849: l_qp_rltd_modifiers_rec.attribute14,
2850: l_qp_rltd_modifiers_rec.attribute15,
2851: l_new_rltd_modifier_id,
2852: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,

Line 2849: l_qp_rltd_modifiers_rec.attribute14,

2845: l_qp_rltd_modifiers_rec.attribute10,
2846: l_qp_rltd_modifiers_rec.attribute11,
2847: l_qp_rltd_modifiers_rec.attribute12,
2848: l_qp_rltd_modifiers_rec.attribute13,
2849: l_qp_rltd_modifiers_rec.attribute14,
2850: l_qp_rltd_modifiers_rec.attribute15,
2851: l_new_rltd_modifier_id,
2852: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
2853: l_new_from_id,

Line 2850: l_qp_rltd_modifiers_rec.attribute15,

2846: l_qp_rltd_modifiers_rec.attribute11,
2847: l_qp_rltd_modifiers_rec.attribute12,
2848: l_qp_rltd_modifiers_rec.attribute13,
2849: l_qp_rltd_modifiers_rec.attribute14,
2850: l_qp_rltd_modifiers_rec.attribute15,
2851: l_new_rltd_modifier_id,
2852: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
2853: l_new_from_id,
2854: l_new_to_id,

Line 2852: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,

2848: l_qp_rltd_modifiers_rec.attribute13,
2849: l_qp_rltd_modifiers_rec.attribute14,
2850: l_qp_rltd_modifiers_rec.attribute15,
2851: l_new_rltd_modifier_id,
2852: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
2853: l_new_from_id,
2854: l_new_to_id,
2855: l_qp_rltd_modifiers_rec.rltd_modifier_grp_type
2856: );

Line 2855: l_qp_rltd_modifiers_rec.rltd_modifier_grp_type

2851: l_new_rltd_modifier_id,
2852: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
2853: l_new_from_id,
2854: l_new_to_id,
2855: l_qp_rltd_modifiers_rec.rltd_modifier_grp_type
2856: );
2857:
2858: END LOOP; -- Loop through rltd modifiers records
2859: END IF; --For lines that are Parent Price Break lines