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 374: CURSOR qp_rltd_modifiers_cur(a_list_line_id NUMBER)

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
376: SELECT *
377: FROM qp_rltd_modifiers
378: WHERE from_rltd_modifier_id = a_list_line_id;

Line 377: FROM qp_rltd_modifiers

373:
374: CURSOR qp_rltd_modifiers_cur(a_list_line_id NUMBER)
375: IS
376: SELECT *
377: FROM qp_rltd_modifiers
378: WHERE from_rltd_modifier_id = a_list_line_id;
379:
380: --bug#6636843
381: CURSOR qp_list_headers_tl_cur(a_list_hdr_id qp_list_headers_tl.list_header_id%TYPE)

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

1102: END LOOP; /* For copying pricing attributes for each discount line */
1103:
1104: END LOOP; /* For copying discount lines*/
1105:
1106: /* Copy qp_rltd_modifiers for the Price Break Parent list_lines chosen
1107: above which are stored in the mapping table */
1108:
1109: IF l_mapping_tbl.COUNT > 0 THEN
1110: FOR l_count IN 1..l_mapping_tbl.COUNT

Line 1115: FOR l_qp_rltd_modifiers_rec IN qp_rltd_modifiers_cur(

1111: LOOP
1112:
1113: IF l_mapping_tbl(l_count).list_line_type_code = 'PBH' THEN
1114:
1115: FOR l_qp_rltd_modifiers_rec IN qp_rltd_modifiers_cur(
1116: l_mapping_tbl(l_count).old_list_line_id)
1117: LOOP
1118:
1119: SELECT qp_rltd_modifiers_s.nextval

Line 1119: SELECT qp_rltd_modifiers_s.nextval

1115: FOR l_qp_rltd_modifiers_rec IN qp_rltd_modifiers_cur(
1116: l_mapping_tbl(l_count).old_list_line_id)
1117: LOOP
1118:
1119: SELECT qp_rltd_modifiers_s.nextval
1120: INTO l_new_rltd_modifier_id
1121: FROM dual;
1122:
1123: l_new_from_id := Get_New_Id(

Line 1124: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,

1120: INTO l_new_rltd_modifier_id
1121: FROM dual;
1122:
1123: l_new_from_id := Get_New_Id(
1124: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,
1125: l_mapping_tbl);
1126: l_new_to_id := Get_New_Id(
1127: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,
1128: l_mapping_tbl);

Line 1127: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,

1123: l_new_from_id := Get_New_Id(
1124: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,
1125: l_mapping_tbl);
1126: l_new_to_id := Get_New_Id(
1127: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,
1128: l_mapping_tbl);
1129: INSERT INTO qp_rltd_modifiers
1130: (creation_date,
1131: created_by,

Line 1129: INSERT INTO qp_rltd_modifiers

1125: l_mapping_tbl);
1126: l_new_to_id := Get_New_Id(
1127: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,
1128: l_mapping_tbl);
1129: INSERT INTO qp_rltd_modifiers
1130: (creation_date,
1131: created_by,
1132: last_update_date,
1133: last_updated_by,

Line 1163: l_qp_rltd_modifiers_rec.context,

1159: p_user_id,
1160: sysdate,
1161: p_user_id,
1162: p_conc_login_id,
1163: l_qp_rltd_modifiers_rec.context,
1164: l_qp_rltd_modifiers_rec.attribute1,
1165: l_qp_rltd_modifiers_rec.attribute2,
1166: l_qp_rltd_modifiers_rec.attribute3,
1167: l_qp_rltd_modifiers_rec.attribute4,

Line 1164: l_qp_rltd_modifiers_rec.attribute1,

1160: sysdate,
1161: p_user_id,
1162: p_conc_login_id,
1163: l_qp_rltd_modifiers_rec.context,
1164: l_qp_rltd_modifiers_rec.attribute1,
1165: l_qp_rltd_modifiers_rec.attribute2,
1166: l_qp_rltd_modifiers_rec.attribute3,
1167: l_qp_rltd_modifiers_rec.attribute4,
1168: l_qp_rltd_modifiers_rec.attribute5,

Line 1165: l_qp_rltd_modifiers_rec.attribute2,

1161: p_user_id,
1162: p_conc_login_id,
1163: l_qp_rltd_modifiers_rec.context,
1164: l_qp_rltd_modifiers_rec.attribute1,
1165: l_qp_rltd_modifiers_rec.attribute2,
1166: l_qp_rltd_modifiers_rec.attribute3,
1167: l_qp_rltd_modifiers_rec.attribute4,
1168: l_qp_rltd_modifiers_rec.attribute5,
1169: l_qp_rltd_modifiers_rec.attribute6,

Line 1166: l_qp_rltd_modifiers_rec.attribute3,

1162: p_conc_login_id,
1163: l_qp_rltd_modifiers_rec.context,
1164: l_qp_rltd_modifiers_rec.attribute1,
1165: l_qp_rltd_modifiers_rec.attribute2,
1166: l_qp_rltd_modifiers_rec.attribute3,
1167: l_qp_rltd_modifiers_rec.attribute4,
1168: l_qp_rltd_modifiers_rec.attribute5,
1169: l_qp_rltd_modifiers_rec.attribute6,
1170: l_qp_rltd_modifiers_rec.attribute7,

Line 1167: l_qp_rltd_modifiers_rec.attribute4,

1163: l_qp_rltd_modifiers_rec.context,
1164: l_qp_rltd_modifiers_rec.attribute1,
1165: l_qp_rltd_modifiers_rec.attribute2,
1166: l_qp_rltd_modifiers_rec.attribute3,
1167: l_qp_rltd_modifiers_rec.attribute4,
1168: l_qp_rltd_modifiers_rec.attribute5,
1169: l_qp_rltd_modifiers_rec.attribute6,
1170: l_qp_rltd_modifiers_rec.attribute7,
1171: l_qp_rltd_modifiers_rec.attribute8,

Line 1168: l_qp_rltd_modifiers_rec.attribute5,

1164: l_qp_rltd_modifiers_rec.attribute1,
1165: l_qp_rltd_modifiers_rec.attribute2,
1166: l_qp_rltd_modifiers_rec.attribute3,
1167: l_qp_rltd_modifiers_rec.attribute4,
1168: l_qp_rltd_modifiers_rec.attribute5,
1169: l_qp_rltd_modifiers_rec.attribute6,
1170: l_qp_rltd_modifiers_rec.attribute7,
1171: l_qp_rltd_modifiers_rec.attribute8,
1172: l_qp_rltd_modifiers_rec.attribute9,

Line 1169: l_qp_rltd_modifiers_rec.attribute6,

1165: l_qp_rltd_modifiers_rec.attribute2,
1166: l_qp_rltd_modifiers_rec.attribute3,
1167: l_qp_rltd_modifiers_rec.attribute4,
1168: l_qp_rltd_modifiers_rec.attribute5,
1169: l_qp_rltd_modifiers_rec.attribute6,
1170: l_qp_rltd_modifiers_rec.attribute7,
1171: l_qp_rltd_modifiers_rec.attribute8,
1172: l_qp_rltd_modifiers_rec.attribute9,
1173: l_qp_rltd_modifiers_rec.attribute10,

Line 1170: l_qp_rltd_modifiers_rec.attribute7,

1166: l_qp_rltd_modifiers_rec.attribute3,
1167: l_qp_rltd_modifiers_rec.attribute4,
1168: l_qp_rltd_modifiers_rec.attribute5,
1169: l_qp_rltd_modifiers_rec.attribute6,
1170: l_qp_rltd_modifiers_rec.attribute7,
1171: l_qp_rltd_modifiers_rec.attribute8,
1172: l_qp_rltd_modifiers_rec.attribute9,
1173: l_qp_rltd_modifiers_rec.attribute10,
1174: l_qp_rltd_modifiers_rec.attribute11,

Line 1171: l_qp_rltd_modifiers_rec.attribute8,

1167: l_qp_rltd_modifiers_rec.attribute4,
1168: l_qp_rltd_modifiers_rec.attribute5,
1169: l_qp_rltd_modifiers_rec.attribute6,
1170: l_qp_rltd_modifiers_rec.attribute7,
1171: l_qp_rltd_modifiers_rec.attribute8,
1172: l_qp_rltd_modifiers_rec.attribute9,
1173: l_qp_rltd_modifiers_rec.attribute10,
1174: l_qp_rltd_modifiers_rec.attribute11,
1175: l_qp_rltd_modifiers_rec.attribute12,

Line 1172: l_qp_rltd_modifiers_rec.attribute9,

1168: l_qp_rltd_modifiers_rec.attribute5,
1169: l_qp_rltd_modifiers_rec.attribute6,
1170: l_qp_rltd_modifiers_rec.attribute7,
1171: l_qp_rltd_modifiers_rec.attribute8,
1172: l_qp_rltd_modifiers_rec.attribute9,
1173: l_qp_rltd_modifiers_rec.attribute10,
1174: l_qp_rltd_modifiers_rec.attribute11,
1175: l_qp_rltd_modifiers_rec.attribute12,
1176: l_qp_rltd_modifiers_rec.attribute13,

Line 1173: l_qp_rltd_modifiers_rec.attribute10,

1169: l_qp_rltd_modifiers_rec.attribute6,
1170: l_qp_rltd_modifiers_rec.attribute7,
1171: l_qp_rltd_modifiers_rec.attribute8,
1172: l_qp_rltd_modifiers_rec.attribute9,
1173: l_qp_rltd_modifiers_rec.attribute10,
1174: l_qp_rltd_modifiers_rec.attribute11,
1175: l_qp_rltd_modifiers_rec.attribute12,
1176: l_qp_rltd_modifiers_rec.attribute13,
1177: l_qp_rltd_modifiers_rec.attribute14,

Line 1174: l_qp_rltd_modifiers_rec.attribute11,

1170: l_qp_rltd_modifiers_rec.attribute7,
1171: l_qp_rltd_modifiers_rec.attribute8,
1172: l_qp_rltd_modifiers_rec.attribute9,
1173: l_qp_rltd_modifiers_rec.attribute10,
1174: l_qp_rltd_modifiers_rec.attribute11,
1175: l_qp_rltd_modifiers_rec.attribute12,
1176: l_qp_rltd_modifiers_rec.attribute13,
1177: l_qp_rltd_modifiers_rec.attribute14,
1178: l_qp_rltd_modifiers_rec.attribute15,

Line 1175: l_qp_rltd_modifiers_rec.attribute12,

1171: l_qp_rltd_modifiers_rec.attribute8,
1172: l_qp_rltd_modifiers_rec.attribute9,
1173: l_qp_rltd_modifiers_rec.attribute10,
1174: l_qp_rltd_modifiers_rec.attribute11,
1175: l_qp_rltd_modifiers_rec.attribute12,
1176: l_qp_rltd_modifiers_rec.attribute13,
1177: l_qp_rltd_modifiers_rec.attribute14,
1178: l_qp_rltd_modifiers_rec.attribute15,
1179: l_new_rltd_modifier_id,

Line 1176: l_qp_rltd_modifiers_rec.attribute13,

1172: l_qp_rltd_modifiers_rec.attribute9,
1173: l_qp_rltd_modifiers_rec.attribute10,
1174: l_qp_rltd_modifiers_rec.attribute11,
1175: l_qp_rltd_modifiers_rec.attribute12,
1176: l_qp_rltd_modifiers_rec.attribute13,
1177: l_qp_rltd_modifiers_rec.attribute14,
1178: l_qp_rltd_modifiers_rec.attribute15,
1179: l_new_rltd_modifier_id,
1180: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,

Line 1177: l_qp_rltd_modifiers_rec.attribute14,

1173: l_qp_rltd_modifiers_rec.attribute10,
1174: l_qp_rltd_modifiers_rec.attribute11,
1175: l_qp_rltd_modifiers_rec.attribute12,
1176: l_qp_rltd_modifiers_rec.attribute13,
1177: l_qp_rltd_modifiers_rec.attribute14,
1178: l_qp_rltd_modifiers_rec.attribute15,
1179: l_new_rltd_modifier_id,
1180: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
1181: l_new_from_id,

Line 1178: l_qp_rltd_modifiers_rec.attribute15,

1174: l_qp_rltd_modifiers_rec.attribute11,
1175: l_qp_rltd_modifiers_rec.attribute12,
1176: l_qp_rltd_modifiers_rec.attribute13,
1177: l_qp_rltd_modifiers_rec.attribute14,
1178: l_qp_rltd_modifiers_rec.attribute15,
1179: l_new_rltd_modifier_id,
1180: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
1181: l_new_from_id,
1182: l_new_to_id,

Line 1180: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,

1176: l_qp_rltd_modifiers_rec.attribute13,
1177: l_qp_rltd_modifiers_rec.attribute14,
1178: l_qp_rltd_modifiers_rec.attribute15,
1179: l_new_rltd_modifier_id,
1180: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
1181: l_new_from_id,
1182: l_new_to_id,
1183: l_qp_rltd_modifiers_rec.rltd_modifier_grp_type
1184: );

Line 1183: l_qp_rltd_modifiers_rec.rltd_modifier_grp_type

1179: l_new_rltd_modifier_id,
1180: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
1181: l_new_from_id,
1182: l_new_to_id,
1183: l_qp_rltd_modifiers_rec.rltd_modifier_grp_type
1184: );
1185:
1186: END LOOP; -- Loop through rltd modifiers records
1187: END IF; --For lines that are Parent Price Break lines

Line 1423: CURSOR qp_rltd_modifiers_cur(a_list_line_id NUMBER)

1419: And a.list_type_code = 'PRL'
1420: )*/
1421: );
1422:
1423: CURSOR qp_rltd_modifiers_cur(a_list_line_id NUMBER)
1424: IS
1425: SELECT *
1426: FROM qp_rltd_modifiers
1427: WHERE from_rltd_modifier_id = a_list_line_id;

Line 1426: FROM qp_rltd_modifiers

1422:
1423: CURSOR qp_rltd_modifiers_cur(a_list_line_id NUMBER)
1424: IS
1425: SELECT *
1426: FROM qp_rltd_modifiers
1427: WHERE from_rltd_modifier_id = a_list_line_id;
1428:
1429: BEGIN
1430:

Line 2184: from qp_rltd_modifiers

2180:
2181: insert_flag :='N';
2182: BEGIN
2183: select from_rltd_modifier_id into l_line_id
2184: from qp_rltd_modifiers
2185: where to_rltd_modifier_id=l_qp_list_lines_rec.list_line_id;
2186: Exception
2187: when no_data_found then
2188: l_line_id:=null;

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

2592:
2593: CLOSE qp_list_lines_cv;
2594:
2595:
2596: /* Copy qp_rltd_modifiers for the Price Break Parent list_lines chosen
2597: above which are stored in the mapping table */
2598: IF l_mapping_tbl.COUNT > 0 THEN
2599: FOR l_count IN 1..l_mapping_tbl.COUNT
2600: LOOP

Line 2604: FOR l_qp_rltd_modifiers_rec IN qp_rltd_modifiers_cur(

2600: LOOP
2601:
2602: IF l_mapping_tbl(l_count).list_line_type_code = 'PBH' THEN
2603:
2604: FOR l_qp_rltd_modifiers_rec IN qp_rltd_modifiers_cur(
2605: l_mapping_tbl(l_count).old_list_line_id)
2606: LOOP
2607:
2608: SELECT qp_rltd_modifiers_s.nextval

Line 2608: SELECT qp_rltd_modifiers_s.nextval

2604: FOR l_qp_rltd_modifiers_rec IN qp_rltd_modifiers_cur(
2605: l_mapping_tbl(l_count).old_list_line_id)
2606: LOOP
2607:
2608: SELECT qp_rltd_modifiers_s.nextval
2609: INTO l_new_rltd_modifier_id
2610: FROM dual;
2611:
2612: l_new_from_id := Get_New_Id(

Line 2613: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,

2609: INTO l_new_rltd_modifier_id
2610: FROM dual;
2611:
2612: l_new_from_id := Get_New_Id(
2613: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,
2614: l_mapping_tbl);
2615: l_new_to_id := Get_New_Id(
2616: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,
2617: l_mapping_tbl);

Line 2616: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,

2612: l_new_from_id := Get_New_Id(
2613: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,
2614: l_mapping_tbl);
2615: l_new_to_id := Get_New_Id(
2616: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,
2617: l_mapping_tbl);
2618: INSERT INTO qp_rltd_modifiers
2619: (creation_date,
2620: created_by,

Line 2618: INSERT INTO qp_rltd_modifiers

2614: l_mapping_tbl);
2615: l_new_to_id := Get_New_Id(
2616: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,
2617: l_mapping_tbl);
2618: INSERT INTO qp_rltd_modifiers
2619: (creation_date,
2620: created_by,
2621: last_update_date,
2622: last_updated_by,

Line 2652: l_qp_rltd_modifiers_rec.context,

2648: l_user_id,
2649: sysdate,
2650: l_user_id,
2651: l_conc_login_id,
2652: l_qp_rltd_modifiers_rec.context,
2653: l_qp_rltd_modifiers_rec.attribute1,
2654: l_qp_rltd_modifiers_rec.attribute2,
2655: l_qp_rltd_modifiers_rec.attribute3,
2656: l_qp_rltd_modifiers_rec.attribute4,

Line 2653: l_qp_rltd_modifiers_rec.attribute1,

2649: sysdate,
2650: l_user_id,
2651: l_conc_login_id,
2652: l_qp_rltd_modifiers_rec.context,
2653: l_qp_rltd_modifiers_rec.attribute1,
2654: l_qp_rltd_modifiers_rec.attribute2,
2655: l_qp_rltd_modifiers_rec.attribute3,
2656: l_qp_rltd_modifiers_rec.attribute4,
2657: l_qp_rltd_modifiers_rec.attribute5,

Line 2654: l_qp_rltd_modifiers_rec.attribute2,

2650: l_user_id,
2651: l_conc_login_id,
2652: l_qp_rltd_modifiers_rec.context,
2653: l_qp_rltd_modifiers_rec.attribute1,
2654: l_qp_rltd_modifiers_rec.attribute2,
2655: l_qp_rltd_modifiers_rec.attribute3,
2656: l_qp_rltd_modifiers_rec.attribute4,
2657: l_qp_rltd_modifiers_rec.attribute5,
2658: l_qp_rltd_modifiers_rec.attribute6,

Line 2655: l_qp_rltd_modifiers_rec.attribute3,

2651: l_conc_login_id,
2652: l_qp_rltd_modifiers_rec.context,
2653: l_qp_rltd_modifiers_rec.attribute1,
2654: l_qp_rltd_modifiers_rec.attribute2,
2655: l_qp_rltd_modifiers_rec.attribute3,
2656: l_qp_rltd_modifiers_rec.attribute4,
2657: l_qp_rltd_modifiers_rec.attribute5,
2658: l_qp_rltd_modifiers_rec.attribute6,
2659: l_qp_rltd_modifiers_rec.attribute7,

Line 2656: l_qp_rltd_modifiers_rec.attribute4,

2652: l_qp_rltd_modifiers_rec.context,
2653: l_qp_rltd_modifiers_rec.attribute1,
2654: l_qp_rltd_modifiers_rec.attribute2,
2655: l_qp_rltd_modifiers_rec.attribute3,
2656: l_qp_rltd_modifiers_rec.attribute4,
2657: l_qp_rltd_modifiers_rec.attribute5,
2658: l_qp_rltd_modifiers_rec.attribute6,
2659: l_qp_rltd_modifiers_rec.attribute7,
2660: l_qp_rltd_modifiers_rec.attribute8,

Line 2657: l_qp_rltd_modifiers_rec.attribute5,

2653: l_qp_rltd_modifiers_rec.attribute1,
2654: l_qp_rltd_modifiers_rec.attribute2,
2655: l_qp_rltd_modifiers_rec.attribute3,
2656: l_qp_rltd_modifiers_rec.attribute4,
2657: l_qp_rltd_modifiers_rec.attribute5,
2658: l_qp_rltd_modifiers_rec.attribute6,
2659: l_qp_rltd_modifiers_rec.attribute7,
2660: l_qp_rltd_modifiers_rec.attribute8,
2661: l_qp_rltd_modifiers_rec.attribute9,

Line 2658: l_qp_rltd_modifiers_rec.attribute6,

2654: l_qp_rltd_modifiers_rec.attribute2,
2655: l_qp_rltd_modifiers_rec.attribute3,
2656: l_qp_rltd_modifiers_rec.attribute4,
2657: l_qp_rltd_modifiers_rec.attribute5,
2658: l_qp_rltd_modifiers_rec.attribute6,
2659: l_qp_rltd_modifiers_rec.attribute7,
2660: l_qp_rltd_modifiers_rec.attribute8,
2661: l_qp_rltd_modifiers_rec.attribute9,
2662: l_qp_rltd_modifiers_rec.attribute10,

Line 2659: l_qp_rltd_modifiers_rec.attribute7,

2655: l_qp_rltd_modifiers_rec.attribute3,
2656: l_qp_rltd_modifiers_rec.attribute4,
2657: l_qp_rltd_modifiers_rec.attribute5,
2658: l_qp_rltd_modifiers_rec.attribute6,
2659: l_qp_rltd_modifiers_rec.attribute7,
2660: l_qp_rltd_modifiers_rec.attribute8,
2661: l_qp_rltd_modifiers_rec.attribute9,
2662: l_qp_rltd_modifiers_rec.attribute10,
2663: l_qp_rltd_modifiers_rec.attribute11,

Line 2660: l_qp_rltd_modifiers_rec.attribute8,

2656: l_qp_rltd_modifiers_rec.attribute4,
2657: l_qp_rltd_modifiers_rec.attribute5,
2658: l_qp_rltd_modifiers_rec.attribute6,
2659: l_qp_rltd_modifiers_rec.attribute7,
2660: l_qp_rltd_modifiers_rec.attribute8,
2661: l_qp_rltd_modifiers_rec.attribute9,
2662: l_qp_rltd_modifiers_rec.attribute10,
2663: l_qp_rltd_modifiers_rec.attribute11,
2664: l_qp_rltd_modifiers_rec.attribute12,

Line 2661: l_qp_rltd_modifiers_rec.attribute9,

2657: l_qp_rltd_modifiers_rec.attribute5,
2658: l_qp_rltd_modifiers_rec.attribute6,
2659: l_qp_rltd_modifiers_rec.attribute7,
2660: l_qp_rltd_modifiers_rec.attribute8,
2661: l_qp_rltd_modifiers_rec.attribute9,
2662: l_qp_rltd_modifiers_rec.attribute10,
2663: l_qp_rltd_modifiers_rec.attribute11,
2664: l_qp_rltd_modifiers_rec.attribute12,
2665: l_qp_rltd_modifiers_rec.attribute13,

Line 2662: l_qp_rltd_modifiers_rec.attribute10,

2658: l_qp_rltd_modifiers_rec.attribute6,
2659: l_qp_rltd_modifiers_rec.attribute7,
2660: l_qp_rltd_modifiers_rec.attribute8,
2661: l_qp_rltd_modifiers_rec.attribute9,
2662: l_qp_rltd_modifiers_rec.attribute10,
2663: l_qp_rltd_modifiers_rec.attribute11,
2664: l_qp_rltd_modifiers_rec.attribute12,
2665: l_qp_rltd_modifiers_rec.attribute13,
2666: l_qp_rltd_modifiers_rec.attribute14,

Line 2663: l_qp_rltd_modifiers_rec.attribute11,

2659: l_qp_rltd_modifiers_rec.attribute7,
2660: l_qp_rltd_modifiers_rec.attribute8,
2661: l_qp_rltd_modifiers_rec.attribute9,
2662: l_qp_rltd_modifiers_rec.attribute10,
2663: l_qp_rltd_modifiers_rec.attribute11,
2664: l_qp_rltd_modifiers_rec.attribute12,
2665: l_qp_rltd_modifiers_rec.attribute13,
2666: l_qp_rltd_modifiers_rec.attribute14,
2667: l_qp_rltd_modifiers_rec.attribute15,

Line 2664: l_qp_rltd_modifiers_rec.attribute12,

2660: l_qp_rltd_modifiers_rec.attribute8,
2661: l_qp_rltd_modifiers_rec.attribute9,
2662: l_qp_rltd_modifiers_rec.attribute10,
2663: l_qp_rltd_modifiers_rec.attribute11,
2664: l_qp_rltd_modifiers_rec.attribute12,
2665: l_qp_rltd_modifiers_rec.attribute13,
2666: l_qp_rltd_modifiers_rec.attribute14,
2667: l_qp_rltd_modifiers_rec.attribute15,
2668: l_new_rltd_modifier_id,

Line 2665: l_qp_rltd_modifiers_rec.attribute13,

2661: l_qp_rltd_modifiers_rec.attribute9,
2662: l_qp_rltd_modifiers_rec.attribute10,
2663: l_qp_rltd_modifiers_rec.attribute11,
2664: l_qp_rltd_modifiers_rec.attribute12,
2665: l_qp_rltd_modifiers_rec.attribute13,
2666: l_qp_rltd_modifiers_rec.attribute14,
2667: l_qp_rltd_modifiers_rec.attribute15,
2668: l_new_rltd_modifier_id,
2669: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,

Line 2666: l_qp_rltd_modifiers_rec.attribute14,

2662: l_qp_rltd_modifiers_rec.attribute10,
2663: l_qp_rltd_modifiers_rec.attribute11,
2664: l_qp_rltd_modifiers_rec.attribute12,
2665: l_qp_rltd_modifiers_rec.attribute13,
2666: l_qp_rltd_modifiers_rec.attribute14,
2667: l_qp_rltd_modifiers_rec.attribute15,
2668: l_new_rltd_modifier_id,
2669: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
2670: l_new_from_id,

Line 2667: l_qp_rltd_modifiers_rec.attribute15,

2663: l_qp_rltd_modifiers_rec.attribute11,
2664: l_qp_rltd_modifiers_rec.attribute12,
2665: l_qp_rltd_modifiers_rec.attribute13,
2666: l_qp_rltd_modifiers_rec.attribute14,
2667: l_qp_rltd_modifiers_rec.attribute15,
2668: l_new_rltd_modifier_id,
2669: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
2670: l_new_from_id,
2671: l_new_to_id,

Line 2669: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,

2665: l_qp_rltd_modifiers_rec.attribute13,
2666: l_qp_rltd_modifiers_rec.attribute14,
2667: l_qp_rltd_modifiers_rec.attribute15,
2668: l_new_rltd_modifier_id,
2669: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
2670: l_new_from_id,
2671: l_new_to_id,
2672: l_qp_rltd_modifiers_rec.rltd_modifier_grp_type
2673: );

Line 2672: l_qp_rltd_modifiers_rec.rltd_modifier_grp_type

2668: l_new_rltd_modifier_id,
2669: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
2670: l_new_from_id,
2671: l_new_to_id,
2672: l_qp_rltd_modifiers_rec.rltd_modifier_grp_type
2673: );
2674:
2675: END LOOP; -- Loop through rltd modifiers records
2676: END IF; --For lines that are Parent Price Break lines