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_LIST_LINES

Line 87: FROM qp_list_lines a

83: /*
84: CURSOR del_dup_cur (a_new_list_header_id NUMBER)
85: IS
86: SELECT *
87: FROM qp_list_lines a
88: WHERE EXISTS (SELECT NULL
89: FROM qp_list_lines b
90: WHERE a.inventory_item_id = b.inventory_item_id
91: AND a.list_line_type_code = b.list_line_type_code

Line 89: FROM qp_list_lines b

85: IS
86: SELECT *
87: FROM qp_list_lines a
88: WHERE EXISTS (SELECT NULL
89: FROM qp_list_lines b
90: WHERE a.inventory_item_id = b.inventory_item_id
91: AND a.list_line_type_code = b.list_line_type_code
92: AND a.list_header_id = b.list_header_id
93: AND a.list_header_id = a_new_list_header_id

Line 188: FROM qp_list_lines

184:
185: CURSOR list_lines_cur (a_new_list_header_id NUMBER)
186: IS
187: SELECT list_line_id
188: FROM qp_list_lines
189: WHERE list_header_id=a_new_list_header_id;
190:
191: l_status BOOLEAN := TRUE;
192: l_rows number := 0;

Line 261: DELETE qp_list_lines

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;
263: */
264: END IF;
265:

Line 276: DELETE qp_list_lines

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;
278:
279: END LOOP;
280: */

Line 365: FROM qp_list_lines

361:
362: CURSOR qp_discount_lines_cur(p_from_discount_header_id NUMBER)
363: IS
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

Line 756: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)

752: l_qp_qualifiers_rec.header_quals_exist_flag,
753: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
754: --ENH Upgrade BOAPI for orig_sys...ref RAVI
755: ,to_char(l_new_qualifier_id)
756: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)
757: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)
758: );
759:
760: END LOOP; /* For copying qualifiers */

Line 770: SELECT qp_list_lines_s.nextval

766: qp_discount_lines_cur (qp_from_discounts_rec.list_header_id)
767: LOOP
768:
769: --Get New Discount Line Id
770: SELECT qp_list_lines_s.nextval
771: INTO l_new_discount_line_id
772: FROM dual;
773:
774: --Insert Discount Line

Line 775: INSERT INTO qp_list_lines

771: INTO l_new_discount_line_id
772: FROM dual;
773:
774: --Insert Discount Line
775: INSERT INTO qp_list_lines
776: (
777: list_line_id,
778: creation_date,
779: created_by,

Line 1098: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_new_discount_line_id)

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)
1098: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_new_discount_line_id)
1099: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)
1100: );
1101:
1102: END LOOP; /* For copying pricing attributes for each discount line */

Line 1269: TYPE qp_list_lines_rec IS RECORD (

1265: l_max_list_line_id NUMBER;
1266:
1267:
1268:
1269: TYPE qp_list_lines_rec IS RECORD (
1270: list_line_id QP_LIST_LINES.list_line_id%TYPE,
1271: creation_date QP_LIST_LINES.creation_date%TYPE,
1272: created_by QP_LIST_LINES.created_by%TYPE,
1273: last_update_date QP_LIST_LINES.last_update_date%TYPE,

Line 1270: list_line_id QP_LIST_LINES.list_line_id%TYPE,

1266:
1267:
1268:
1269: TYPE qp_list_lines_rec IS RECORD (
1270: list_line_id QP_LIST_LINES.list_line_id%TYPE,
1271: creation_date QP_LIST_LINES.creation_date%TYPE,
1272: created_by QP_LIST_LINES.created_by%TYPE,
1273: last_update_date QP_LIST_LINES.last_update_date%TYPE,
1274: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,

Line 1271: creation_date QP_LIST_LINES.creation_date%TYPE,

1267:
1268:
1269: TYPE qp_list_lines_rec IS RECORD (
1270: list_line_id QP_LIST_LINES.list_line_id%TYPE,
1271: creation_date QP_LIST_LINES.creation_date%TYPE,
1272: created_by QP_LIST_LINES.created_by%TYPE,
1273: last_update_date QP_LIST_LINES.last_update_date%TYPE,
1274: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
1275: last_update_login QP_LIST_LINES.last_update_login%TYPE,

Line 1272: created_by QP_LIST_LINES.created_by%TYPE,

1268:
1269: TYPE qp_list_lines_rec IS RECORD (
1270: list_line_id QP_LIST_LINES.list_line_id%TYPE,
1271: creation_date QP_LIST_LINES.creation_date%TYPE,
1272: created_by QP_LIST_LINES.created_by%TYPE,
1273: last_update_date QP_LIST_LINES.last_update_date%TYPE,
1274: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
1275: last_update_login QP_LIST_LINES.last_update_login%TYPE,
1276: program_application_id QP_LIST_LINES.program_application_id%TYPE,

Line 1273: last_update_date QP_LIST_LINES.last_update_date%TYPE,

1269: TYPE qp_list_lines_rec IS RECORD (
1270: list_line_id QP_LIST_LINES.list_line_id%TYPE,
1271: creation_date QP_LIST_LINES.creation_date%TYPE,
1272: created_by QP_LIST_LINES.created_by%TYPE,
1273: last_update_date QP_LIST_LINES.last_update_date%TYPE,
1274: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
1275: last_update_login QP_LIST_LINES.last_update_login%TYPE,
1276: program_application_id QP_LIST_LINES.program_application_id%TYPE,
1277: program_id QP_LIST_LINES.program_id%TYPE,

Line 1274: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,

1270: list_line_id QP_LIST_LINES.list_line_id%TYPE,
1271: creation_date QP_LIST_LINES.creation_date%TYPE,
1272: created_by QP_LIST_LINES.created_by%TYPE,
1273: last_update_date QP_LIST_LINES.last_update_date%TYPE,
1274: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
1275: last_update_login QP_LIST_LINES.last_update_login%TYPE,
1276: program_application_id QP_LIST_LINES.program_application_id%TYPE,
1277: program_id QP_LIST_LINES.program_id%TYPE,
1278: program_update_date QP_LIST_LINES.program_update_date%TYPE,

Line 1275: last_update_login QP_LIST_LINES.last_update_login%TYPE,

1271: creation_date QP_LIST_LINES.creation_date%TYPE,
1272: created_by QP_LIST_LINES.created_by%TYPE,
1273: last_update_date QP_LIST_LINES.last_update_date%TYPE,
1274: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
1275: last_update_login QP_LIST_LINES.last_update_login%TYPE,
1276: program_application_id QP_LIST_LINES.program_application_id%TYPE,
1277: program_id QP_LIST_LINES.program_id%TYPE,
1278: program_update_date QP_LIST_LINES.program_update_date%TYPE,
1279: request_id QP_LIST_LINES.request_id%TYPE,

Line 1276: program_application_id QP_LIST_LINES.program_application_id%TYPE,

1272: created_by QP_LIST_LINES.created_by%TYPE,
1273: last_update_date QP_LIST_LINES.last_update_date%TYPE,
1274: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
1275: last_update_login QP_LIST_LINES.last_update_login%TYPE,
1276: program_application_id QP_LIST_LINES.program_application_id%TYPE,
1277: program_id QP_LIST_LINES.program_id%TYPE,
1278: program_update_date QP_LIST_LINES.program_update_date%TYPE,
1279: request_id QP_LIST_LINES.request_id%TYPE,
1280: list_header_id QP_LIST_LINES.list_header_id%TYPE,

Line 1277: program_id QP_LIST_LINES.program_id%TYPE,

1273: last_update_date QP_LIST_LINES.last_update_date%TYPE,
1274: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
1275: last_update_login QP_LIST_LINES.last_update_login%TYPE,
1276: program_application_id QP_LIST_LINES.program_application_id%TYPE,
1277: program_id QP_LIST_LINES.program_id%TYPE,
1278: program_update_date QP_LIST_LINES.program_update_date%TYPE,
1279: request_id QP_LIST_LINES.request_id%TYPE,
1280: list_header_id QP_LIST_LINES.list_header_id%TYPE,
1281: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,

Line 1278: program_update_date QP_LIST_LINES.program_update_date%TYPE,

1274: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
1275: last_update_login QP_LIST_LINES.last_update_login%TYPE,
1276: program_application_id QP_LIST_LINES.program_application_id%TYPE,
1277: program_id QP_LIST_LINES.program_id%TYPE,
1278: program_update_date QP_LIST_LINES.program_update_date%TYPE,
1279: request_id QP_LIST_LINES.request_id%TYPE,
1280: list_header_id QP_LIST_LINES.list_header_id%TYPE,
1281: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
1282: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,

Line 1279: request_id QP_LIST_LINES.request_id%TYPE,

1275: last_update_login QP_LIST_LINES.last_update_login%TYPE,
1276: program_application_id QP_LIST_LINES.program_application_id%TYPE,
1277: program_id QP_LIST_LINES.program_id%TYPE,
1278: program_update_date QP_LIST_LINES.program_update_date%TYPE,
1279: request_id QP_LIST_LINES.request_id%TYPE,
1280: list_header_id QP_LIST_LINES.list_header_id%TYPE,
1281: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
1282: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
1283: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,

Line 1280: list_header_id QP_LIST_LINES.list_header_id%TYPE,

1276: program_application_id QP_LIST_LINES.program_application_id%TYPE,
1277: program_id QP_LIST_LINES.program_id%TYPE,
1278: program_update_date QP_LIST_LINES.program_update_date%TYPE,
1279: request_id QP_LIST_LINES.request_id%TYPE,
1280: list_header_id QP_LIST_LINES.list_header_id%TYPE,
1281: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
1282: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
1283: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
1284: list_price QP_LIST_LINES.list_price%TYPE,

Line 1281: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,

1277: program_id QP_LIST_LINES.program_id%TYPE,
1278: program_update_date QP_LIST_LINES.program_update_date%TYPE,
1279: request_id QP_LIST_LINES.request_id%TYPE,
1280: list_header_id QP_LIST_LINES.list_header_id%TYPE,
1281: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
1282: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
1283: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
1284: list_price QP_LIST_LINES.list_price%TYPE,
1285: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,

Line 1282: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,

1278: program_update_date QP_LIST_LINES.program_update_date%TYPE,
1279: request_id QP_LIST_LINES.request_id%TYPE,
1280: list_header_id QP_LIST_LINES.list_header_id%TYPE,
1281: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
1282: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
1283: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
1284: list_price QP_LIST_LINES.list_price%TYPE,
1285: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
1286: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,

Line 1283: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,

1279: request_id QP_LIST_LINES.request_id%TYPE,
1280: list_header_id QP_LIST_LINES.list_header_id%TYPE,
1281: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
1282: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
1283: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
1284: list_price QP_LIST_LINES.list_price%TYPE,
1285: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
1286: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
1287: organization_id QP_LIST_LINES.organization_id%TYPE,

Line 1284: list_price QP_LIST_LINES.list_price%TYPE,

1280: list_header_id QP_LIST_LINES.list_header_id%TYPE,
1281: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
1282: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
1283: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
1284: list_price QP_LIST_LINES.list_price%TYPE,
1285: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
1286: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
1287: organization_id QP_LIST_LINES.organization_id%TYPE,
1288: related_item_id QP_LIST_LINES.related_item_id%TYPE,

Line 1285: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,

1281: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
1282: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
1283: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
1284: list_price QP_LIST_LINES.list_price%TYPE,
1285: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
1286: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
1287: organization_id QP_LIST_LINES.organization_id%TYPE,
1288: related_item_id QP_LIST_LINES.related_item_id%TYPE,
1289: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,

Line 1286: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,

1282: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
1283: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
1284: list_price QP_LIST_LINES.list_price%TYPE,
1285: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
1286: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
1287: organization_id QP_LIST_LINES.organization_id%TYPE,
1288: related_item_id QP_LIST_LINES.related_item_id%TYPE,
1289: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
1290: substitution_context QP_LIST_LINES.substitution_context%TYPE,

Line 1287: organization_id QP_LIST_LINES.organization_id%TYPE,

1283: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
1284: list_price QP_LIST_LINES.list_price%TYPE,
1285: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
1286: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
1287: organization_id QP_LIST_LINES.organization_id%TYPE,
1288: related_item_id QP_LIST_LINES.related_item_id%TYPE,
1289: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
1290: substitution_context QP_LIST_LINES.substitution_context%TYPE,
1291: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,

Line 1288: related_item_id QP_LIST_LINES.related_item_id%TYPE,

1284: list_price QP_LIST_LINES.list_price%TYPE,
1285: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
1286: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
1287: organization_id QP_LIST_LINES.organization_id%TYPE,
1288: related_item_id QP_LIST_LINES.related_item_id%TYPE,
1289: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
1290: substitution_context QP_LIST_LINES.substitution_context%TYPE,
1291: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
1292: substitution_value QP_LIST_LINES.substitution_value%TYPE,

Line 1289: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,

1285: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
1286: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
1287: organization_id QP_LIST_LINES.organization_id%TYPE,
1288: related_item_id QP_LIST_LINES.related_item_id%TYPE,
1289: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
1290: substitution_context QP_LIST_LINES.substitution_context%TYPE,
1291: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
1292: substitution_value QP_LIST_LINES.substitution_value%TYPE,
1293: revision QP_LIST_LINES.revision%TYPE,

Line 1290: substitution_context QP_LIST_LINES.substitution_context%TYPE,

1286: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
1287: organization_id QP_LIST_LINES.organization_id%TYPE,
1288: related_item_id QP_LIST_LINES.related_item_id%TYPE,
1289: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
1290: substitution_context QP_LIST_LINES.substitution_context%TYPE,
1291: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
1292: substitution_value QP_LIST_LINES.substitution_value%TYPE,
1293: revision QP_LIST_LINES.revision%TYPE,
1294: revision_date QP_LIST_LINES.revision_date%TYPE,

Line 1291: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,

1287: organization_id QP_LIST_LINES.organization_id%TYPE,
1288: related_item_id QP_LIST_LINES.related_item_id%TYPE,
1289: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
1290: substitution_context QP_LIST_LINES.substitution_context%TYPE,
1291: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
1292: substitution_value QP_LIST_LINES.substitution_value%TYPE,
1293: revision QP_LIST_LINES.revision%TYPE,
1294: revision_date QP_LIST_LINES.revision_date%TYPE,
1295: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,

Line 1292: substitution_value QP_LIST_LINES.substitution_value%TYPE,

1288: related_item_id QP_LIST_LINES.related_item_id%TYPE,
1289: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
1290: substitution_context QP_LIST_LINES.substitution_context%TYPE,
1291: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
1292: substitution_value QP_LIST_LINES.substitution_value%TYPE,
1293: revision QP_LIST_LINES.revision%TYPE,
1294: revision_date QP_LIST_LINES.revision_date%TYPE,
1295: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
1296: context QP_LIST_LINES.context%TYPE,

Line 1293: revision QP_LIST_LINES.revision%TYPE,

1289: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
1290: substitution_context QP_LIST_LINES.substitution_context%TYPE,
1291: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
1292: substitution_value QP_LIST_LINES.substitution_value%TYPE,
1293: revision QP_LIST_LINES.revision%TYPE,
1294: revision_date QP_LIST_LINES.revision_date%TYPE,
1295: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
1296: context QP_LIST_LINES.context%TYPE,
1297: attribute1 QP_LIST_LINES.attribute1%TYPE,

Line 1294: revision_date QP_LIST_LINES.revision_date%TYPE,

1290: substitution_context QP_LIST_LINES.substitution_context%TYPE,
1291: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
1292: substitution_value QP_LIST_LINES.substitution_value%TYPE,
1293: revision QP_LIST_LINES.revision%TYPE,
1294: revision_date QP_LIST_LINES.revision_date%TYPE,
1295: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
1296: context QP_LIST_LINES.context%TYPE,
1297: attribute1 QP_LIST_LINES.attribute1%TYPE,
1298: attribute2 QP_LIST_LINES.attribute2%TYPE,

Line 1295: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,

1291: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
1292: substitution_value QP_LIST_LINES.substitution_value%TYPE,
1293: revision QP_LIST_LINES.revision%TYPE,
1294: revision_date QP_LIST_LINES.revision_date%TYPE,
1295: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
1296: context QP_LIST_LINES.context%TYPE,
1297: attribute1 QP_LIST_LINES.attribute1%TYPE,
1298: attribute2 QP_LIST_LINES.attribute2%TYPE,
1299: comments QP_LIST_LINES.comments%TYPE,

Line 1296: context QP_LIST_LINES.context%TYPE,

1292: substitution_value QP_LIST_LINES.substitution_value%TYPE,
1293: revision QP_LIST_LINES.revision%TYPE,
1294: revision_date QP_LIST_LINES.revision_date%TYPE,
1295: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
1296: context QP_LIST_LINES.context%TYPE,
1297: attribute1 QP_LIST_LINES.attribute1%TYPE,
1298: attribute2 QP_LIST_LINES.attribute2%TYPE,
1299: comments QP_LIST_LINES.comments%TYPE,
1300: attribute3 QP_LIST_LINES.attribute3%TYPE,

Line 1297: attribute1 QP_LIST_LINES.attribute1%TYPE,

1293: revision QP_LIST_LINES.revision%TYPE,
1294: revision_date QP_LIST_LINES.revision_date%TYPE,
1295: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
1296: context QP_LIST_LINES.context%TYPE,
1297: attribute1 QP_LIST_LINES.attribute1%TYPE,
1298: attribute2 QP_LIST_LINES.attribute2%TYPE,
1299: comments QP_LIST_LINES.comments%TYPE,
1300: attribute3 QP_LIST_LINES.attribute3%TYPE,
1301: attribute4 QP_LIST_LINES.attribute4%TYPE,

Line 1298: attribute2 QP_LIST_LINES.attribute2%TYPE,

1294: revision_date QP_LIST_LINES.revision_date%TYPE,
1295: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
1296: context QP_LIST_LINES.context%TYPE,
1297: attribute1 QP_LIST_LINES.attribute1%TYPE,
1298: attribute2 QP_LIST_LINES.attribute2%TYPE,
1299: comments QP_LIST_LINES.comments%TYPE,
1300: attribute3 QP_LIST_LINES.attribute3%TYPE,
1301: attribute4 QP_LIST_LINES.attribute4%TYPE,
1302: attribute5 QP_LIST_LINES.attribute5%TYPE,

Line 1299: comments QP_LIST_LINES.comments%TYPE,

1295: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
1296: context QP_LIST_LINES.context%TYPE,
1297: attribute1 QP_LIST_LINES.attribute1%TYPE,
1298: attribute2 QP_LIST_LINES.attribute2%TYPE,
1299: comments QP_LIST_LINES.comments%TYPE,
1300: attribute3 QP_LIST_LINES.attribute3%TYPE,
1301: attribute4 QP_LIST_LINES.attribute4%TYPE,
1302: attribute5 QP_LIST_LINES.attribute5%TYPE,
1303: attribute6 QP_LIST_LINES.attribute6%TYPE,

Line 1300: attribute3 QP_LIST_LINES.attribute3%TYPE,

1296: context QP_LIST_LINES.context%TYPE,
1297: attribute1 QP_LIST_LINES.attribute1%TYPE,
1298: attribute2 QP_LIST_LINES.attribute2%TYPE,
1299: comments QP_LIST_LINES.comments%TYPE,
1300: attribute3 QP_LIST_LINES.attribute3%TYPE,
1301: attribute4 QP_LIST_LINES.attribute4%TYPE,
1302: attribute5 QP_LIST_LINES.attribute5%TYPE,
1303: attribute6 QP_LIST_LINES.attribute6%TYPE,
1304: attribute7 QP_LIST_LINES.attribute7%TYPE,

Line 1301: attribute4 QP_LIST_LINES.attribute4%TYPE,

1297: attribute1 QP_LIST_LINES.attribute1%TYPE,
1298: attribute2 QP_LIST_LINES.attribute2%TYPE,
1299: comments QP_LIST_LINES.comments%TYPE,
1300: attribute3 QP_LIST_LINES.attribute3%TYPE,
1301: attribute4 QP_LIST_LINES.attribute4%TYPE,
1302: attribute5 QP_LIST_LINES.attribute5%TYPE,
1303: attribute6 QP_LIST_LINES.attribute6%TYPE,
1304: attribute7 QP_LIST_LINES.attribute7%TYPE,
1305: attribute8 QP_LIST_LINES.attribute8%TYPE,

Line 1302: attribute5 QP_LIST_LINES.attribute5%TYPE,

1298: attribute2 QP_LIST_LINES.attribute2%TYPE,
1299: comments QP_LIST_LINES.comments%TYPE,
1300: attribute3 QP_LIST_LINES.attribute3%TYPE,
1301: attribute4 QP_LIST_LINES.attribute4%TYPE,
1302: attribute5 QP_LIST_LINES.attribute5%TYPE,
1303: attribute6 QP_LIST_LINES.attribute6%TYPE,
1304: attribute7 QP_LIST_LINES.attribute7%TYPE,
1305: attribute8 QP_LIST_LINES.attribute8%TYPE,
1306: attribute9 QP_LIST_LINES.attribute9%TYPE,

Line 1303: attribute6 QP_LIST_LINES.attribute6%TYPE,

1299: comments QP_LIST_LINES.comments%TYPE,
1300: attribute3 QP_LIST_LINES.attribute3%TYPE,
1301: attribute4 QP_LIST_LINES.attribute4%TYPE,
1302: attribute5 QP_LIST_LINES.attribute5%TYPE,
1303: attribute6 QP_LIST_LINES.attribute6%TYPE,
1304: attribute7 QP_LIST_LINES.attribute7%TYPE,
1305: attribute8 QP_LIST_LINES.attribute8%TYPE,
1306: attribute9 QP_LIST_LINES.attribute9%TYPE,
1307: attribute10 QP_LIST_LINES.attribute10%TYPE,

Line 1304: attribute7 QP_LIST_LINES.attribute7%TYPE,

1300: attribute3 QP_LIST_LINES.attribute3%TYPE,
1301: attribute4 QP_LIST_LINES.attribute4%TYPE,
1302: attribute5 QP_LIST_LINES.attribute5%TYPE,
1303: attribute6 QP_LIST_LINES.attribute6%TYPE,
1304: attribute7 QP_LIST_LINES.attribute7%TYPE,
1305: attribute8 QP_LIST_LINES.attribute8%TYPE,
1306: attribute9 QP_LIST_LINES.attribute9%TYPE,
1307: attribute10 QP_LIST_LINES.attribute10%TYPE,
1308: attribute11 QP_LIST_LINES.attribute11%TYPE,

Line 1305: attribute8 QP_LIST_LINES.attribute8%TYPE,

1301: attribute4 QP_LIST_LINES.attribute4%TYPE,
1302: attribute5 QP_LIST_LINES.attribute5%TYPE,
1303: attribute6 QP_LIST_LINES.attribute6%TYPE,
1304: attribute7 QP_LIST_LINES.attribute7%TYPE,
1305: attribute8 QP_LIST_LINES.attribute8%TYPE,
1306: attribute9 QP_LIST_LINES.attribute9%TYPE,
1307: attribute10 QP_LIST_LINES.attribute10%TYPE,
1308: attribute11 QP_LIST_LINES.attribute11%TYPE,
1309: attribute12 QP_LIST_LINES.attribute12%TYPE,

Line 1306: attribute9 QP_LIST_LINES.attribute9%TYPE,

1302: attribute5 QP_LIST_LINES.attribute5%TYPE,
1303: attribute6 QP_LIST_LINES.attribute6%TYPE,
1304: attribute7 QP_LIST_LINES.attribute7%TYPE,
1305: attribute8 QP_LIST_LINES.attribute8%TYPE,
1306: attribute9 QP_LIST_LINES.attribute9%TYPE,
1307: attribute10 QP_LIST_LINES.attribute10%TYPE,
1308: attribute11 QP_LIST_LINES.attribute11%TYPE,
1309: attribute12 QP_LIST_LINES.attribute12%TYPE,
1310: attribute13 QP_LIST_LINES.attribute13%TYPE,

Line 1307: attribute10 QP_LIST_LINES.attribute10%TYPE,

1303: attribute6 QP_LIST_LINES.attribute6%TYPE,
1304: attribute7 QP_LIST_LINES.attribute7%TYPE,
1305: attribute8 QP_LIST_LINES.attribute8%TYPE,
1306: attribute9 QP_LIST_LINES.attribute9%TYPE,
1307: attribute10 QP_LIST_LINES.attribute10%TYPE,
1308: attribute11 QP_LIST_LINES.attribute11%TYPE,
1309: attribute12 QP_LIST_LINES.attribute12%TYPE,
1310: attribute13 QP_LIST_LINES.attribute13%TYPE,
1311: attribute14 QP_LIST_LINES.attribute14%TYPE,

Line 1308: attribute11 QP_LIST_LINES.attribute11%TYPE,

1304: attribute7 QP_LIST_LINES.attribute7%TYPE,
1305: attribute8 QP_LIST_LINES.attribute8%TYPE,
1306: attribute9 QP_LIST_LINES.attribute9%TYPE,
1307: attribute10 QP_LIST_LINES.attribute10%TYPE,
1308: attribute11 QP_LIST_LINES.attribute11%TYPE,
1309: attribute12 QP_LIST_LINES.attribute12%TYPE,
1310: attribute13 QP_LIST_LINES.attribute13%TYPE,
1311: attribute14 QP_LIST_LINES.attribute14%TYPE,
1312: attribute15 QP_LIST_LINES.attribute15%TYPE,

Line 1309: attribute12 QP_LIST_LINES.attribute12%TYPE,

1305: attribute8 QP_LIST_LINES.attribute8%TYPE,
1306: attribute9 QP_LIST_LINES.attribute9%TYPE,
1307: attribute10 QP_LIST_LINES.attribute10%TYPE,
1308: attribute11 QP_LIST_LINES.attribute11%TYPE,
1309: attribute12 QP_LIST_LINES.attribute12%TYPE,
1310: attribute13 QP_LIST_LINES.attribute13%TYPE,
1311: attribute14 QP_LIST_LINES.attribute14%TYPE,
1312: attribute15 QP_LIST_LINES.attribute15%TYPE,
1313: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,

Line 1310: attribute13 QP_LIST_LINES.attribute13%TYPE,

1306: attribute9 QP_LIST_LINES.attribute9%TYPE,
1307: attribute10 QP_LIST_LINES.attribute10%TYPE,
1308: attribute11 QP_LIST_LINES.attribute11%TYPE,
1309: attribute12 QP_LIST_LINES.attribute12%TYPE,
1310: attribute13 QP_LIST_LINES.attribute13%TYPE,
1311: attribute14 QP_LIST_LINES.attribute14%TYPE,
1312: attribute15 QP_LIST_LINES.attribute15%TYPE,
1313: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
1314: percent_price QP_LIST_LINES.percent_price%TYPE,

Line 1311: attribute14 QP_LIST_LINES.attribute14%TYPE,

1307: attribute10 QP_LIST_LINES.attribute10%TYPE,
1308: attribute11 QP_LIST_LINES.attribute11%TYPE,
1309: attribute12 QP_LIST_LINES.attribute12%TYPE,
1310: attribute13 QP_LIST_LINES.attribute13%TYPE,
1311: attribute14 QP_LIST_LINES.attribute14%TYPE,
1312: attribute15 QP_LIST_LINES.attribute15%TYPE,
1313: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
1314: percent_price QP_LIST_LINES.percent_price%TYPE,
1315: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,

Line 1312: attribute15 QP_LIST_LINES.attribute15%TYPE,

1308: attribute11 QP_LIST_LINES.attribute11%TYPE,
1309: attribute12 QP_LIST_LINES.attribute12%TYPE,
1310: attribute13 QP_LIST_LINES.attribute13%TYPE,
1311: attribute14 QP_LIST_LINES.attribute14%TYPE,
1312: attribute15 QP_LIST_LINES.attribute15%TYPE,
1313: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
1314: percent_price QP_LIST_LINES.percent_price%TYPE,
1315: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
1316: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,

Line 1313: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,

1309: attribute12 QP_LIST_LINES.attribute12%TYPE,
1310: attribute13 QP_LIST_LINES.attribute13%TYPE,
1311: attribute14 QP_LIST_LINES.attribute14%TYPE,
1312: attribute15 QP_LIST_LINES.attribute15%TYPE,
1313: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
1314: percent_price QP_LIST_LINES.percent_price%TYPE,
1315: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
1316: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
1317: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,

Line 1314: percent_price QP_LIST_LINES.percent_price%TYPE,

1310: attribute13 QP_LIST_LINES.attribute13%TYPE,
1311: attribute14 QP_LIST_LINES.attribute14%TYPE,
1312: attribute15 QP_LIST_LINES.attribute15%TYPE,
1313: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
1314: percent_price QP_LIST_LINES.percent_price%TYPE,
1315: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
1316: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
1317: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
1318: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,

Line 1315: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,

1311: attribute14 QP_LIST_LINES.attribute14%TYPE,
1312: attribute15 QP_LIST_LINES.attribute15%TYPE,
1313: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
1314: percent_price QP_LIST_LINES.percent_price%TYPE,
1315: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
1316: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
1317: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
1318: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
1319: operand QP_LIST_LINES.operand%TYPE,

Line 1316: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,

1312: attribute15 QP_LIST_LINES.attribute15%TYPE,
1313: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
1314: percent_price QP_LIST_LINES.percent_price%TYPE,
1315: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
1316: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
1317: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
1318: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
1319: operand QP_LIST_LINES.operand%TYPE,
1320: override_flag QP_LIST_LINES.override_flag%TYPE,

Line 1317: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,

1313: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
1314: percent_price QP_LIST_LINES.percent_price%TYPE,
1315: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
1316: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
1317: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
1318: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
1319: operand QP_LIST_LINES.operand%TYPE,
1320: override_flag QP_LIST_LINES.override_flag%TYPE,
1321: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,

Line 1318: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,

1314: percent_price QP_LIST_LINES.percent_price%TYPE,
1315: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
1316: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
1317: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
1318: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
1319: operand QP_LIST_LINES.operand%TYPE,
1320: override_flag QP_LIST_LINES.override_flag%TYPE,
1321: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
1322: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,

Line 1319: operand QP_LIST_LINES.operand%TYPE,

1315: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
1316: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
1317: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
1318: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
1319: operand QP_LIST_LINES.operand%TYPE,
1320: override_flag QP_LIST_LINES.override_flag%TYPE,
1321: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
1322: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
1323: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,

Line 1320: override_flag QP_LIST_LINES.override_flag%TYPE,

1316: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
1317: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
1318: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
1319: operand QP_LIST_LINES.operand%TYPE,
1320: override_flag QP_LIST_LINES.override_flag%TYPE,
1321: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
1322: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
1323: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
1324: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,

Line 1321: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,

1317: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
1318: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
1319: operand QP_LIST_LINES.operand%TYPE,
1320: override_flag QP_LIST_LINES.override_flag%TYPE,
1321: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
1322: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
1323: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
1324: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
1325: start_date_active QP_LIST_LINES.start_date_active%TYPE,

Line 1322: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,

1318: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
1319: operand QP_LIST_LINES.operand%TYPE,
1320: override_flag QP_LIST_LINES.override_flag%TYPE,
1321: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
1322: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
1323: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
1324: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
1325: start_date_active QP_LIST_LINES.start_date_active%TYPE,
1326: end_date_active QP_LIST_LINES.end_date_active%TYPE,

Line 1323: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,

1319: operand QP_LIST_LINES.operand%TYPE,
1320: override_flag QP_LIST_LINES.override_flag%TYPE,
1321: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
1322: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
1323: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
1324: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
1325: start_date_active QP_LIST_LINES.start_date_active%TYPE,
1326: end_date_active QP_LIST_LINES.end_date_active%TYPE,
1327: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,

Line 1324: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,

1320: override_flag QP_LIST_LINES.override_flag%TYPE,
1321: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
1322: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
1323: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
1324: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
1325: start_date_active QP_LIST_LINES.start_date_active%TYPE,
1326: end_date_active QP_LIST_LINES.end_date_active%TYPE,
1327: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
1328: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,

Line 1325: start_date_active QP_LIST_LINES.start_date_active%TYPE,

1321: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
1322: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
1323: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
1324: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
1325: start_date_active QP_LIST_LINES.start_date_active%TYPE,
1326: end_date_active QP_LIST_LINES.end_date_active%TYPE,
1327: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
1328: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
1329: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,

Line 1326: end_date_active QP_LIST_LINES.end_date_active%TYPE,

1322: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
1323: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
1324: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
1325: start_date_active QP_LIST_LINES.start_date_active%TYPE,
1326: end_date_active QP_LIST_LINES.end_date_active%TYPE,
1327: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
1328: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
1329: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
1330: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,

Line 1327: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,

1323: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
1324: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
1325: start_date_active QP_LIST_LINES.start_date_active%TYPE,
1326: end_date_active QP_LIST_LINES.end_date_active%TYPE,
1327: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
1328: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
1329: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
1330: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
1331: list_line_no QP_LIST_LINES.list_line_no%TYPE,

Line 1328: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,

1324: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
1325: start_date_active QP_LIST_LINES.start_date_active%TYPE,
1326: end_date_active QP_LIST_LINES.end_date_active%TYPE,
1327: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
1328: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
1329: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
1330: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
1331: list_line_no QP_LIST_LINES.list_line_no%TYPE,
1332: product_precedence QP_LIST_LINES.product_precedence%TYPE,

Line 1329: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,

1325: start_date_active QP_LIST_LINES.start_date_active%TYPE,
1326: end_date_active QP_LIST_LINES.end_date_active%TYPE,
1327: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
1328: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
1329: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
1330: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
1331: list_line_no QP_LIST_LINES.list_line_no%TYPE,
1332: product_precedence QP_LIST_LINES.product_precedence%TYPE,
1333: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,

Line 1330: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,

1326: end_date_active QP_LIST_LINES.end_date_active%TYPE,
1327: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
1328: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
1329: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
1330: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
1331: list_line_no QP_LIST_LINES.list_line_no%TYPE,
1332: product_precedence QP_LIST_LINES.product_precedence%TYPE,
1333: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
1334: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,

Line 1331: list_line_no QP_LIST_LINES.list_line_no%TYPE,

1327: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
1328: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
1329: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
1330: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
1331: list_line_no QP_LIST_LINES.list_line_no%TYPE,
1332: product_precedence QP_LIST_LINES.product_precedence%TYPE,
1333: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
1334: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
1335: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,

Line 1332: product_precedence QP_LIST_LINES.product_precedence%TYPE,

1328: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
1329: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
1330: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
1331: list_line_no QP_LIST_LINES.list_line_no%TYPE,
1332: product_precedence QP_LIST_LINES.product_precedence%TYPE,
1333: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
1334: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
1335: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
1336: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,

Line 1333: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,

1329: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
1330: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
1331: list_line_no QP_LIST_LINES.list_line_no%TYPE,
1332: product_precedence QP_LIST_LINES.product_precedence%TYPE,
1333: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
1334: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
1335: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
1336: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
1337: expiration_date QP_LIST_LINES.expiration_date%TYPE,

Line 1334: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,

1330: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
1331: list_line_no QP_LIST_LINES.list_line_no%TYPE,
1332: product_precedence QP_LIST_LINES.product_precedence%TYPE,
1333: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
1334: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
1335: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
1336: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
1337: expiration_date QP_LIST_LINES.expiration_date%TYPE,
1338: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,

Line 1335: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,

1331: list_line_no QP_LIST_LINES.list_line_no%TYPE,
1332: product_precedence QP_LIST_LINES.product_precedence%TYPE,
1333: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
1334: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
1335: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
1336: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
1337: expiration_date QP_LIST_LINES.expiration_date%TYPE,
1338: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
1339: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,

Line 1336: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,

1332: product_precedence QP_LIST_LINES.product_precedence%TYPE,
1333: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
1334: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
1335: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
1336: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
1337: expiration_date QP_LIST_LINES.expiration_date%TYPE,
1338: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
1339: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
1340: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,

Line 1337: expiration_date QP_LIST_LINES.expiration_date%TYPE,

1333: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
1334: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
1335: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
1336: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
1337: expiration_date QP_LIST_LINES.expiration_date%TYPE,
1338: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
1339: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
1340: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
1341: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,

Line 1338: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,

1334: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
1335: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
1336: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
1337: expiration_date QP_LIST_LINES.expiration_date%TYPE,
1338: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
1339: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
1340: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
1341: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
1342: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,

Line 1339: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,

1335: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
1336: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
1337: expiration_date QP_LIST_LINES.expiration_date%TYPE,
1338: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
1339: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
1340: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
1341: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
1342: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
1343: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,

Line 1340: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,

1336: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
1337: expiration_date QP_LIST_LINES.expiration_date%TYPE,
1338: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
1339: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
1340: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
1341: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
1342: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
1343: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
1344: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,

Line 1341: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,

1337: expiration_date QP_LIST_LINES.expiration_date%TYPE,
1338: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
1339: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
1340: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
1341: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
1342: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
1343: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
1344: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
1345: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,

Line 1342: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,

1338: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
1339: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
1340: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
1341: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
1342: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
1343: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
1344: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
1345: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
1346: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,

Line 1343: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,

1339: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
1340: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
1341: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
1342: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
1343: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
1344: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
1345: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
1346: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
1347: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,

Line 1344: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,

1340: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
1341: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
1342: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
1343: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
1344: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
1345: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
1346: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
1347: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
1348: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,

Line 1345: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,

1341: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
1342: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
1343: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
1344: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
1345: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
1346: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
1347: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
1348: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
1349: recurring_value QP_LIST_LINES.recurring_value%TYPE, -- block pricing

Line 1346: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,

1342: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
1343: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
1344: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
1345: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
1346: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
1347: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
1348: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
1349: recurring_value QP_LIST_LINES.recurring_value%TYPE, -- block pricing
1350: continuous_price_break_flag QP_LIST_LINES.continuous_price_break_flag%TYPE

Line 1347: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,

1343: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
1344: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
1345: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
1346: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
1347: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
1348: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
1349: recurring_value QP_LIST_LINES.recurring_value%TYPE, -- block pricing
1350: continuous_price_break_flag QP_LIST_LINES.continuous_price_break_flag%TYPE
1351: --Continuous Price Breaks

Line 1348: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,

1344: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
1345: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
1346: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
1347: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
1348: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
1349: recurring_value QP_LIST_LINES.recurring_value%TYPE, -- block pricing
1350: continuous_price_break_flag QP_LIST_LINES.continuous_price_break_flag%TYPE
1351: --Continuous Price Breaks
1352: );

Line 1349: recurring_value QP_LIST_LINES.recurring_value%TYPE, -- block pricing

1345: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
1346: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
1347: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
1348: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
1349: recurring_value QP_LIST_LINES.recurring_value%TYPE, -- block pricing
1350: continuous_price_break_flag QP_LIST_LINES.continuous_price_break_flag%TYPE
1351: --Continuous Price Breaks
1352: );
1353:

Line 1350: continuous_price_break_flag QP_LIST_LINES.continuous_price_break_flag%TYPE

1346: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
1347: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
1348: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
1349: recurring_value QP_LIST_LINES.recurring_value%TYPE, -- block pricing
1350: continuous_price_break_flag QP_LIST_LINES.continuous_price_break_flag%TYPE
1351: --Continuous Price Breaks
1352: );
1353:
1354: l_non_cont_pbh_id_tbl QP_UTIL.price_brk_attr_val_tab; --Continuous Price Breaks

Line 1361: l_qp_list_lines_rec qp_list_lines_rec;

1357:
1358: l_mapping_tbl mapping_tbl;
1359:
1360: l_select_stmt VARCHAR2(9000);
1361: l_qp_list_lines_rec qp_list_lines_rec;
1362: l_context VARCHAR2(30);
1363: l_attribute VARCHAR2(30);
1364:
1365: l_exists NUMBER := 0;

Line 1382: qp_list_lines_cv lines_cur_typ;

1378: l_qual_attr_value_from_number NUMBER := NULL;
1379: l_qual_attr_value_to_number NUMBER := NULL;
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 *

Line 1848: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)

1844: l_qp_qualifiers_rec.header_quals_exist_flag,
1845: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
1846: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1847: ,to_char(l_new_qualifier_id)
1848: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)
1849: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_qp_qualifiers_rec.list_header_id)
1850: );
1851:
1852:

Line 1958: FROM qp_list_lines q

1954: q.qualification_ind,
1955: q.recurring_value, -- block pricing
1956: q.continuous_price_break_flag --Continuous Price Breaks
1957:
1958: FROM qp_list_lines q
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

Line 2149: OPEN qp_list_lines_cv FOR l_select_stmt USING p_from_list_header_id;

2145: -- debug
2146: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||l_select_stmt);
2147:
2148: IF (p_category_id is null) and (p_category_set_id is null) then
2149: OPEN qp_list_lines_cv FOR l_select_stmt USING p_from_list_header_id;
2150: end if;
2151: IF ( nvl(p_category_id, 0) <> 0 AND nvl(p_category_set_id, 0) <> 0) THEN
2152: OPEN qp_list_lines_cv FOR l_select_stmt USING p_from_list_header_id,p_category_id,p_category_id,v_pte_code,v_source_system_code,p_category_set_id;
2153: END IF;

Line 2152: OPEN qp_list_lines_cv FOR l_select_stmt USING p_from_list_header_id,p_category_id,p_category_id,v_pte_code,v_source_system_code,p_category_set_id;

2148: IF (p_category_id is null) and (p_category_set_id is null) then
2149: OPEN qp_list_lines_cv FOR l_select_stmt USING p_from_list_header_id;
2150: end if;
2151: IF ( nvl(p_category_id, 0) <> 0 AND nvl(p_category_set_id, 0) <> 0) THEN
2152: OPEN qp_list_lines_cv FOR l_select_stmt USING p_from_list_header_id,p_category_id,p_category_id,v_pte_code,v_source_system_code,p_category_set_id;
2153: END IF;
2154: IF ( nvl(p_category_id, 0) = 0 AND nvl(p_category_set_id, 0) <> 0) THEN
2155: OPEN qp_list_lines_cv FOR l_select_stmt USING p_from_list_header_id,p_category_set_id;
2156: END IF;

Line 2155: OPEN qp_list_lines_cv FOR l_select_stmt USING p_from_list_header_id,p_category_set_id;

2151: IF ( nvl(p_category_id, 0) <> 0 AND nvl(p_category_set_id, 0) <> 0) THEN
2152: OPEN qp_list_lines_cv FOR l_select_stmt USING p_from_list_header_id,p_category_id,p_category_id,v_pte_code,v_source_system_code,p_category_set_id;
2153: END IF;
2154: IF ( nvl(p_category_id, 0) = 0 AND nvl(p_category_set_id, 0) <> 0) THEN
2155: OPEN qp_list_lines_cv FOR l_select_stmt USING p_from_list_header_id,p_category_set_id;
2156: END IF;
2157: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'opened list_lines cursor');
2158:
2159: --This is the fetch loop

Line 2164: --of the from_price_list into qp_list_lines(for the New Price List)

2160: LOOP
2161: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'inside loop ');
2162:
2163: --Insert each fetched record(Price List Line without Discount Line)
2164: --of the from_price_list into qp_list_lines(for the New Price List)
2165: --provided the segment values of the lines lie in the input ranges.
2166:
2167: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
2168: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'after fetch ');

Line 2167: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;

2163: --Insert each fetched record(Price List Line without Discount Line)
2164: --of the from_price_list into qp_list_lines(for the New Price List)
2165: --provided the segment values of the lines lie in the input ranges.
2166:
2167: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
2168: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'after fetch ');
2169: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2170:
2171: EXIT WHEN qp_list_lines_cv%NOTFOUND;

Line 2169: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);

2165: --provided the segment values of the lines lie in the input ranges.
2166:
2167: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
2168: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'after fetch ');
2169: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2170:
2171: EXIT WHEN qp_list_lines_cv%NOTFOUND;
2172: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2173:

Line 2171: EXIT WHEN qp_list_lines_cv%NOTFOUND;

2167: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
2168: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'after fetch ');
2169: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2170:
2171: EXIT WHEN qp_list_lines_cv%NOTFOUND;
2172: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2173:
2174:
2175: /* Added for 3067774.When price listr line is end dated,its related lines e.g. child lines

Line 2172: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);

2168: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'after fetch ');
2169: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2170:
2171: EXIT WHEN qp_list_lines_cv%NOTFOUND;
2172: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2173:
2174:
2175: /* Added for 3067774.When price listr line is end dated,its related lines e.g. child lines
2176: are still active. Cursor qp_list_lines_cv selects all active lines, therefore,

Line 2176: are still active. Cursor qp_list_lines_cv selects all active lines, therefore,

2172: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2173:
2174:
2175: /* Added for 3067774.When price listr line is end dated,its related lines e.g. child lines
2176: are still active. Cursor qp_list_lines_cv selects all active lines, therefore,
2177: orphaned child lines are also copied to new price list.The following logic
2178: excludes such orphaned lines from being copied. */
2179:
2180:

Line 2185: where to_rltd_modifier_id=l_qp_list_lines_rec.list_line_id;

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;
2189: End;

Line 2195: select count(*) into l_cnt from qp_list_lines where list_line_id=l_line_id

2191: If l_line_id is null then
2192: insert_flag :='Y';
2193: Else
2194: Begin
2195: select count(*) into l_cnt from qp_list_lines where list_line_id=l_line_id
2196: AND ((end_date_active IS NULL) OR (trunc(end_date_active) >= trunc(sysdate)));
2197: Exception
2198: when no_data_found then
2199: l_cnt:=0;

Line 2214: SELECT qp_list_lines_s.nextval

2210:
2211:
2212: -- Get next list_line_id
2213:
2214: SELECT qp_list_lines_s.nextval
2215: INTO l_new_list_line_id
2216: FROM dual;
2217:
2218: INSERT INTO qp_list_lines

Line 2218: INSERT INTO qp_list_lines

2214: SELECT qp_list_lines_s.nextval
2215: INTO l_new_list_line_id
2216: FROM dual;
2217:
2218: INSERT INTO qp_list_lines
2219: (
2220: list_line_id,
2221: creation_date,
2222: created_by,

Line 2318: l_qp_list_lines_rec.list_line_type_code,

2314: l_conc_program_id,
2315: sysdate,
2316: l_conc_request_id,
2317: l_new_list_header_id,
2318: l_qp_list_lines_rec.list_line_type_code,
2319: DECODE (p_effective_dates_flag,
2320: 'Y', l_qp_list_lines_rec.start_date_active,
2321: NULL), /* If flag='Y', retain start date from copied line */
2322: /* else default start date */

Line 2320: 'Y', l_qp_list_lines_rec.start_date_active,

2316: l_conc_request_id,
2317: l_new_list_header_id,
2318: l_qp_list_lines_rec.list_line_type_code,
2319: DECODE (p_effective_dates_flag,
2320: 'Y', l_qp_list_lines_rec.start_date_active,
2321: NULL), /* If flag='Y', retain start date from copied line */
2322: /* else default start date */
2323: DECODE (p_effective_dates_flag,
2324: 'Y', l_qp_list_lines_rec.end_date_active,

Line 2324: 'Y', l_qp_list_lines_rec.end_date_active,

2320: 'Y', l_qp_list_lines_rec.start_date_active,
2321: NULL), /* If flag='Y', retain start date from copied line */
2322: /* else default start date */
2323: DECODE (p_effective_dates_flag,
2324: 'Y', l_qp_list_lines_rec.end_date_active,
2325: NULL), /* If flag='Y', retain end date from copied line */
2326: /* else default end date */
2327: l_qp_list_lines_rec.automatic_flag,
2328: l_qp_list_lines_rec.modifier_level_code,

Line 2327: l_qp_list_lines_rec.automatic_flag,

2323: DECODE (p_effective_dates_flag,
2324: 'Y', l_qp_list_lines_rec.end_date_active,
2325: NULL), /* If flag='Y', retain end date from copied line */
2326: /* else default end date */
2327: l_qp_list_lines_rec.automatic_flag,
2328: l_qp_list_lines_rec.modifier_level_code,
2329: l_qp_list_lines_rec.list_price,
2330: l_qp_list_lines_rec.primary_uom_flag,
2331: l_qp_list_lines_rec.inventory_item_id,

Line 2328: l_qp_list_lines_rec.modifier_level_code,

2324: 'Y', l_qp_list_lines_rec.end_date_active,
2325: NULL), /* If flag='Y', retain end date from copied line */
2326: /* else default end date */
2327: l_qp_list_lines_rec.automatic_flag,
2328: l_qp_list_lines_rec.modifier_level_code,
2329: l_qp_list_lines_rec.list_price,
2330: l_qp_list_lines_rec.primary_uom_flag,
2331: l_qp_list_lines_rec.inventory_item_id,
2332: l_qp_list_lines_rec.organization_id,

Line 2329: l_qp_list_lines_rec.list_price,

2325: NULL), /* If flag='Y', retain end date from copied line */
2326: /* else default end date */
2327: l_qp_list_lines_rec.automatic_flag,
2328: l_qp_list_lines_rec.modifier_level_code,
2329: l_qp_list_lines_rec.list_price,
2330: l_qp_list_lines_rec.primary_uom_flag,
2331: l_qp_list_lines_rec.inventory_item_id,
2332: l_qp_list_lines_rec.organization_id,
2333: l_qp_list_lines_rec.related_item_id,

Line 2330: l_qp_list_lines_rec.primary_uom_flag,

2326: /* else default end date */
2327: l_qp_list_lines_rec.automatic_flag,
2328: l_qp_list_lines_rec.modifier_level_code,
2329: l_qp_list_lines_rec.list_price,
2330: l_qp_list_lines_rec.primary_uom_flag,
2331: l_qp_list_lines_rec.inventory_item_id,
2332: l_qp_list_lines_rec.organization_id,
2333: l_qp_list_lines_rec.related_item_id,
2334: l_qp_list_lines_rec.relationship_type_id,

Line 2331: l_qp_list_lines_rec.inventory_item_id,

2327: l_qp_list_lines_rec.automatic_flag,
2328: l_qp_list_lines_rec.modifier_level_code,
2329: l_qp_list_lines_rec.list_price,
2330: l_qp_list_lines_rec.primary_uom_flag,
2331: l_qp_list_lines_rec.inventory_item_id,
2332: l_qp_list_lines_rec.organization_id,
2333: l_qp_list_lines_rec.related_item_id,
2334: l_qp_list_lines_rec.relationship_type_id,
2335: l_qp_list_lines_rec.substitution_context,

Line 2332: l_qp_list_lines_rec.organization_id,

2328: l_qp_list_lines_rec.modifier_level_code,
2329: l_qp_list_lines_rec.list_price,
2330: l_qp_list_lines_rec.primary_uom_flag,
2331: l_qp_list_lines_rec.inventory_item_id,
2332: l_qp_list_lines_rec.organization_id,
2333: l_qp_list_lines_rec.related_item_id,
2334: l_qp_list_lines_rec.relationship_type_id,
2335: l_qp_list_lines_rec.substitution_context,
2336: l_qp_list_lines_rec.substitution_attribute,

Line 2333: l_qp_list_lines_rec.related_item_id,

2329: l_qp_list_lines_rec.list_price,
2330: l_qp_list_lines_rec.primary_uom_flag,
2331: l_qp_list_lines_rec.inventory_item_id,
2332: l_qp_list_lines_rec.organization_id,
2333: l_qp_list_lines_rec.related_item_id,
2334: l_qp_list_lines_rec.relationship_type_id,
2335: l_qp_list_lines_rec.substitution_context,
2336: l_qp_list_lines_rec.substitution_attribute,
2337: l_qp_list_lines_rec.substitution_value,

Line 2334: l_qp_list_lines_rec.relationship_type_id,

2330: l_qp_list_lines_rec.primary_uom_flag,
2331: l_qp_list_lines_rec.inventory_item_id,
2332: l_qp_list_lines_rec.organization_id,
2333: l_qp_list_lines_rec.related_item_id,
2334: l_qp_list_lines_rec.relationship_type_id,
2335: l_qp_list_lines_rec.substitution_context,
2336: l_qp_list_lines_rec.substitution_attribute,
2337: l_qp_list_lines_rec.substitution_value,
2338: l_qp_list_lines_rec.revision,

Line 2335: l_qp_list_lines_rec.substitution_context,

2331: l_qp_list_lines_rec.inventory_item_id,
2332: l_qp_list_lines_rec.organization_id,
2333: l_qp_list_lines_rec.related_item_id,
2334: l_qp_list_lines_rec.relationship_type_id,
2335: l_qp_list_lines_rec.substitution_context,
2336: l_qp_list_lines_rec.substitution_attribute,
2337: l_qp_list_lines_rec.substitution_value,
2338: l_qp_list_lines_rec.revision,
2339: l_qp_list_lines_rec.revision_date,

Line 2336: l_qp_list_lines_rec.substitution_attribute,

2332: l_qp_list_lines_rec.organization_id,
2333: l_qp_list_lines_rec.related_item_id,
2334: l_qp_list_lines_rec.relationship_type_id,
2335: l_qp_list_lines_rec.substitution_context,
2336: l_qp_list_lines_rec.substitution_attribute,
2337: l_qp_list_lines_rec.substitution_value,
2338: l_qp_list_lines_rec.revision,
2339: l_qp_list_lines_rec.revision_date,
2340: l_qp_list_lines_rec.revision_reason_code,

Line 2337: l_qp_list_lines_rec.substitution_value,

2333: l_qp_list_lines_rec.related_item_id,
2334: l_qp_list_lines_rec.relationship_type_id,
2335: l_qp_list_lines_rec.substitution_context,
2336: l_qp_list_lines_rec.substitution_attribute,
2337: l_qp_list_lines_rec.substitution_value,
2338: l_qp_list_lines_rec.revision,
2339: l_qp_list_lines_rec.revision_date,
2340: l_qp_list_lines_rec.revision_reason_code,
2341: l_qp_list_lines_rec.context,

Line 2338: l_qp_list_lines_rec.revision,

2334: l_qp_list_lines_rec.relationship_type_id,
2335: l_qp_list_lines_rec.substitution_context,
2336: l_qp_list_lines_rec.substitution_attribute,
2337: l_qp_list_lines_rec.substitution_value,
2338: l_qp_list_lines_rec.revision,
2339: l_qp_list_lines_rec.revision_date,
2340: l_qp_list_lines_rec.revision_reason_code,
2341: l_qp_list_lines_rec.context,
2342: l_qp_list_lines_rec.attribute1,

Line 2339: l_qp_list_lines_rec.revision_date,

2335: l_qp_list_lines_rec.substitution_context,
2336: l_qp_list_lines_rec.substitution_attribute,
2337: l_qp_list_lines_rec.substitution_value,
2338: l_qp_list_lines_rec.revision,
2339: l_qp_list_lines_rec.revision_date,
2340: l_qp_list_lines_rec.revision_reason_code,
2341: l_qp_list_lines_rec.context,
2342: l_qp_list_lines_rec.attribute1,
2343: l_qp_list_lines_rec.attribute2,

Line 2340: l_qp_list_lines_rec.revision_reason_code,

2336: l_qp_list_lines_rec.substitution_attribute,
2337: l_qp_list_lines_rec.substitution_value,
2338: l_qp_list_lines_rec.revision,
2339: l_qp_list_lines_rec.revision_date,
2340: l_qp_list_lines_rec.revision_reason_code,
2341: l_qp_list_lines_rec.context,
2342: l_qp_list_lines_rec.attribute1,
2343: l_qp_list_lines_rec.attribute2,
2344: l_qp_list_lines_rec.comments,

Line 2341: l_qp_list_lines_rec.context,

2337: l_qp_list_lines_rec.substitution_value,
2338: l_qp_list_lines_rec.revision,
2339: l_qp_list_lines_rec.revision_date,
2340: l_qp_list_lines_rec.revision_reason_code,
2341: l_qp_list_lines_rec.context,
2342: l_qp_list_lines_rec.attribute1,
2343: l_qp_list_lines_rec.attribute2,
2344: l_qp_list_lines_rec.comments,
2345: l_qp_list_lines_rec.attribute3,

Line 2342: l_qp_list_lines_rec.attribute1,

2338: l_qp_list_lines_rec.revision,
2339: l_qp_list_lines_rec.revision_date,
2340: l_qp_list_lines_rec.revision_reason_code,
2341: l_qp_list_lines_rec.context,
2342: l_qp_list_lines_rec.attribute1,
2343: l_qp_list_lines_rec.attribute2,
2344: l_qp_list_lines_rec.comments,
2345: l_qp_list_lines_rec.attribute3,
2346: l_qp_list_lines_rec.attribute4,

Line 2343: l_qp_list_lines_rec.attribute2,

2339: l_qp_list_lines_rec.revision_date,
2340: l_qp_list_lines_rec.revision_reason_code,
2341: l_qp_list_lines_rec.context,
2342: l_qp_list_lines_rec.attribute1,
2343: l_qp_list_lines_rec.attribute2,
2344: l_qp_list_lines_rec.comments,
2345: l_qp_list_lines_rec.attribute3,
2346: l_qp_list_lines_rec.attribute4,
2347: l_qp_list_lines_rec.attribute5,

Line 2344: l_qp_list_lines_rec.comments,

2340: l_qp_list_lines_rec.revision_reason_code,
2341: l_qp_list_lines_rec.context,
2342: l_qp_list_lines_rec.attribute1,
2343: l_qp_list_lines_rec.attribute2,
2344: l_qp_list_lines_rec.comments,
2345: l_qp_list_lines_rec.attribute3,
2346: l_qp_list_lines_rec.attribute4,
2347: l_qp_list_lines_rec.attribute5,
2348: l_qp_list_lines_rec.attribute6,

Line 2345: l_qp_list_lines_rec.attribute3,

2341: l_qp_list_lines_rec.context,
2342: l_qp_list_lines_rec.attribute1,
2343: l_qp_list_lines_rec.attribute2,
2344: l_qp_list_lines_rec.comments,
2345: l_qp_list_lines_rec.attribute3,
2346: l_qp_list_lines_rec.attribute4,
2347: l_qp_list_lines_rec.attribute5,
2348: l_qp_list_lines_rec.attribute6,
2349: l_qp_list_lines_rec.attribute7,

Line 2346: l_qp_list_lines_rec.attribute4,

2342: l_qp_list_lines_rec.attribute1,
2343: l_qp_list_lines_rec.attribute2,
2344: l_qp_list_lines_rec.comments,
2345: l_qp_list_lines_rec.attribute3,
2346: l_qp_list_lines_rec.attribute4,
2347: l_qp_list_lines_rec.attribute5,
2348: l_qp_list_lines_rec.attribute6,
2349: l_qp_list_lines_rec.attribute7,
2350: l_qp_list_lines_rec.attribute8,

Line 2347: l_qp_list_lines_rec.attribute5,

2343: l_qp_list_lines_rec.attribute2,
2344: l_qp_list_lines_rec.comments,
2345: l_qp_list_lines_rec.attribute3,
2346: l_qp_list_lines_rec.attribute4,
2347: l_qp_list_lines_rec.attribute5,
2348: l_qp_list_lines_rec.attribute6,
2349: l_qp_list_lines_rec.attribute7,
2350: l_qp_list_lines_rec.attribute8,
2351: l_qp_list_lines_rec.attribute9,

Line 2348: l_qp_list_lines_rec.attribute6,

2344: l_qp_list_lines_rec.comments,
2345: l_qp_list_lines_rec.attribute3,
2346: l_qp_list_lines_rec.attribute4,
2347: l_qp_list_lines_rec.attribute5,
2348: l_qp_list_lines_rec.attribute6,
2349: l_qp_list_lines_rec.attribute7,
2350: l_qp_list_lines_rec.attribute8,
2351: l_qp_list_lines_rec.attribute9,
2352: l_qp_list_lines_rec.attribute10,

Line 2349: l_qp_list_lines_rec.attribute7,

2345: l_qp_list_lines_rec.attribute3,
2346: l_qp_list_lines_rec.attribute4,
2347: l_qp_list_lines_rec.attribute5,
2348: l_qp_list_lines_rec.attribute6,
2349: l_qp_list_lines_rec.attribute7,
2350: l_qp_list_lines_rec.attribute8,
2351: l_qp_list_lines_rec.attribute9,
2352: l_qp_list_lines_rec.attribute10,
2353: l_qp_list_lines_rec.attribute11,

Line 2350: l_qp_list_lines_rec.attribute8,

2346: l_qp_list_lines_rec.attribute4,
2347: l_qp_list_lines_rec.attribute5,
2348: l_qp_list_lines_rec.attribute6,
2349: l_qp_list_lines_rec.attribute7,
2350: l_qp_list_lines_rec.attribute8,
2351: l_qp_list_lines_rec.attribute9,
2352: l_qp_list_lines_rec.attribute10,
2353: l_qp_list_lines_rec.attribute11,
2354: l_qp_list_lines_rec.attribute12,

Line 2351: l_qp_list_lines_rec.attribute9,

2347: l_qp_list_lines_rec.attribute5,
2348: l_qp_list_lines_rec.attribute6,
2349: l_qp_list_lines_rec.attribute7,
2350: l_qp_list_lines_rec.attribute8,
2351: l_qp_list_lines_rec.attribute9,
2352: l_qp_list_lines_rec.attribute10,
2353: l_qp_list_lines_rec.attribute11,
2354: l_qp_list_lines_rec.attribute12,
2355: l_qp_list_lines_rec.attribute13,

Line 2352: l_qp_list_lines_rec.attribute10,

2348: l_qp_list_lines_rec.attribute6,
2349: l_qp_list_lines_rec.attribute7,
2350: l_qp_list_lines_rec.attribute8,
2351: l_qp_list_lines_rec.attribute9,
2352: l_qp_list_lines_rec.attribute10,
2353: l_qp_list_lines_rec.attribute11,
2354: l_qp_list_lines_rec.attribute12,
2355: l_qp_list_lines_rec.attribute13,
2356: l_qp_list_lines_rec.attribute14,

Line 2353: l_qp_list_lines_rec.attribute11,

2349: l_qp_list_lines_rec.attribute7,
2350: l_qp_list_lines_rec.attribute8,
2351: l_qp_list_lines_rec.attribute9,
2352: l_qp_list_lines_rec.attribute10,
2353: l_qp_list_lines_rec.attribute11,
2354: l_qp_list_lines_rec.attribute12,
2355: l_qp_list_lines_rec.attribute13,
2356: l_qp_list_lines_rec.attribute14,
2357: l_qp_list_lines_rec.attribute15,

Line 2354: l_qp_list_lines_rec.attribute12,

2350: l_qp_list_lines_rec.attribute8,
2351: l_qp_list_lines_rec.attribute9,
2352: l_qp_list_lines_rec.attribute10,
2353: l_qp_list_lines_rec.attribute11,
2354: l_qp_list_lines_rec.attribute12,
2355: l_qp_list_lines_rec.attribute13,
2356: l_qp_list_lines_rec.attribute14,
2357: l_qp_list_lines_rec.attribute15,
2358: l_qp_list_lines_rec.price_break_type_code,

Line 2355: l_qp_list_lines_rec.attribute13,

2351: l_qp_list_lines_rec.attribute9,
2352: l_qp_list_lines_rec.attribute10,
2353: l_qp_list_lines_rec.attribute11,
2354: l_qp_list_lines_rec.attribute12,
2355: l_qp_list_lines_rec.attribute13,
2356: l_qp_list_lines_rec.attribute14,
2357: l_qp_list_lines_rec.attribute15,
2358: l_qp_list_lines_rec.price_break_type_code,
2359: l_qp_list_lines_rec.percent_price,

Line 2356: l_qp_list_lines_rec.attribute14,

2352: l_qp_list_lines_rec.attribute10,
2353: l_qp_list_lines_rec.attribute11,
2354: l_qp_list_lines_rec.attribute12,
2355: l_qp_list_lines_rec.attribute13,
2356: l_qp_list_lines_rec.attribute14,
2357: l_qp_list_lines_rec.attribute15,
2358: l_qp_list_lines_rec.price_break_type_code,
2359: l_qp_list_lines_rec.percent_price,
2360: l_qp_list_lines_rec.price_by_formula_id,

Line 2357: l_qp_list_lines_rec.attribute15,

2353: l_qp_list_lines_rec.attribute11,
2354: l_qp_list_lines_rec.attribute12,
2355: l_qp_list_lines_rec.attribute13,
2356: l_qp_list_lines_rec.attribute14,
2357: l_qp_list_lines_rec.attribute15,
2358: l_qp_list_lines_rec.price_break_type_code,
2359: l_qp_list_lines_rec.percent_price,
2360: l_qp_list_lines_rec.price_by_formula_id,
2361: l_qp_list_lines_rec.number_effective_periods,

Line 2358: l_qp_list_lines_rec.price_break_type_code,

2354: l_qp_list_lines_rec.attribute12,
2355: l_qp_list_lines_rec.attribute13,
2356: l_qp_list_lines_rec.attribute14,
2357: l_qp_list_lines_rec.attribute15,
2358: l_qp_list_lines_rec.price_break_type_code,
2359: l_qp_list_lines_rec.percent_price,
2360: l_qp_list_lines_rec.price_by_formula_id,
2361: l_qp_list_lines_rec.number_effective_periods,
2362: l_qp_list_lines_rec.effective_period_uom,

Line 2359: l_qp_list_lines_rec.percent_price,

2355: l_qp_list_lines_rec.attribute13,
2356: l_qp_list_lines_rec.attribute14,
2357: l_qp_list_lines_rec.attribute15,
2358: l_qp_list_lines_rec.price_break_type_code,
2359: l_qp_list_lines_rec.percent_price,
2360: l_qp_list_lines_rec.price_by_formula_id,
2361: l_qp_list_lines_rec.number_effective_periods,
2362: l_qp_list_lines_rec.effective_period_uom,
2363: l_qp_list_lines_rec.arithmetic_operator,

Line 2360: l_qp_list_lines_rec.price_by_formula_id,

2356: l_qp_list_lines_rec.attribute14,
2357: l_qp_list_lines_rec.attribute15,
2358: l_qp_list_lines_rec.price_break_type_code,
2359: l_qp_list_lines_rec.percent_price,
2360: l_qp_list_lines_rec.price_by_formula_id,
2361: l_qp_list_lines_rec.number_effective_periods,
2362: l_qp_list_lines_rec.effective_period_uom,
2363: l_qp_list_lines_rec.arithmetic_operator,
2364: l_qp_list_lines_rec.operand,

Line 2361: l_qp_list_lines_rec.number_effective_periods,

2357: l_qp_list_lines_rec.attribute15,
2358: l_qp_list_lines_rec.price_break_type_code,
2359: l_qp_list_lines_rec.percent_price,
2360: l_qp_list_lines_rec.price_by_formula_id,
2361: l_qp_list_lines_rec.number_effective_periods,
2362: l_qp_list_lines_rec.effective_period_uom,
2363: l_qp_list_lines_rec.arithmetic_operator,
2364: l_qp_list_lines_rec.operand,
2365: l_qp_list_lines_rec.override_flag,

Line 2362: l_qp_list_lines_rec.effective_period_uom,

2358: l_qp_list_lines_rec.price_break_type_code,
2359: l_qp_list_lines_rec.percent_price,
2360: l_qp_list_lines_rec.price_by_formula_id,
2361: l_qp_list_lines_rec.number_effective_periods,
2362: l_qp_list_lines_rec.effective_period_uom,
2363: l_qp_list_lines_rec.arithmetic_operator,
2364: l_qp_list_lines_rec.operand,
2365: l_qp_list_lines_rec.override_flag,
2366: l_qp_list_lines_rec.print_on_invoice_flag,

Line 2363: l_qp_list_lines_rec.arithmetic_operator,

2359: l_qp_list_lines_rec.percent_price,
2360: l_qp_list_lines_rec.price_by_formula_id,
2361: l_qp_list_lines_rec.number_effective_periods,
2362: l_qp_list_lines_rec.effective_period_uom,
2363: l_qp_list_lines_rec.arithmetic_operator,
2364: l_qp_list_lines_rec.operand,
2365: l_qp_list_lines_rec.override_flag,
2366: l_qp_list_lines_rec.print_on_invoice_flag,
2367: l_qp_list_lines_rec.rebate_transaction_type_code,

Line 2364: l_qp_list_lines_rec.operand,

2360: l_qp_list_lines_rec.price_by_formula_id,
2361: l_qp_list_lines_rec.number_effective_periods,
2362: l_qp_list_lines_rec.effective_period_uom,
2363: l_qp_list_lines_rec.arithmetic_operator,
2364: l_qp_list_lines_rec.operand,
2365: l_qp_list_lines_rec.override_flag,
2366: l_qp_list_lines_rec.print_on_invoice_flag,
2367: l_qp_list_lines_rec.rebate_transaction_type_code,
2368: l_qp_list_lines_rec.estim_accrual_rate,

Line 2365: l_qp_list_lines_rec.override_flag,

2361: l_qp_list_lines_rec.number_effective_periods,
2362: l_qp_list_lines_rec.effective_period_uom,
2363: l_qp_list_lines_rec.arithmetic_operator,
2364: l_qp_list_lines_rec.operand,
2365: l_qp_list_lines_rec.override_flag,
2366: l_qp_list_lines_rec.print_on_invoice_flag,
2367: l_qp_list_lines_rec.rebate_transaction_type_code,
2368: l_qp_list_lines_rec.estim_accrual_rate,
2369: l_qp_list_lines_rec.generate_using_formula_id,

Line 2366: l_qp_list_lines_rec.print_on_invoice_flag,

2362: l_qp_list_lines_rec.effective_period_uom,
2363: l_qp_list_lines_rec.arithmetic_operator,
2364: l_qp_list_lines_rec.operand,
2365: l_qp_list_lines_rec.override_flag,
2366: l_qp_list_lines_rec.print_on_invoice_flag,
2367: l_qp_list_lines_rec.rebate_transaction_type_code,
2368: l_qp_list_lines_rec.estim_accrual_rate,
2369: l_qp_list_lines_rec.generate_using_formula_id,
2370: l_qp_list_lines_rec.reprice_flag,

Line 2367: l_qp_list_lines_rec.rebate_transaction_type_code,

2363: l_qp_list_lines_rec.arithmetic_operator,
2364: l_qp_list_lines_rec.operand,
2365: l_qp_list_lines_rec.override_flag,
2366: l_qp_list_lines_rec.print_on_invoice_flag,
2367: l_qp_list_lines_rec.rebate_transaction_type_code,
2368: l_qp_list_lines_rec.estim_accrual_rate,
2369: l_qp_list_lines_rec.generate_using_formula_id,
2370: l_qp_list_lines_rec.reprice_flag,
2371: l_qp_list_lines_rec.accrual_flag,

Line 2368: l_qp_list_lines_rec.estim_accrual_rate,

2364: l_qp_list_lines_rec.operand,
2365: l_qp_list_lines_rec.override_flag,
2366: l_qp_list_lines_rec.print_on_invoice_flag,
2367: l_qp_list_lines_rec.rebate_transaction_type_code,
2368: l_qp_list_lines_rec.estim_accrual_rate,
2369: l_qp_list_lines_rec.generate_using_formula_id,
2370: l_qp_list_lines_rec.reprice_flag,
2371: l_qp_list_lines_rec.accrual_flag,
2372: l_qp_list_lines_rec.pricing_group_sequence,

Line 2369: l_qp_list_lines_rec.generate_using_formula_id,

2365: l_qp_list_lines_rec.override_flag,
2366: l_qp_list_lines_rec.print_on_invoice_flag,
2367: l_qp_list_lines_rec.rebate_transaction_type_code,
2368: l_qp_list_lines_rec.estim_accrual_rate,
2369: l_qp_list_lines_rec.generate_using_formula_id,
2370: l_qp_list_lines_rec.reprice_flag,
2371: l_qp_list_lines_rec.accrual_flag,
2372: l_qp_list_lines_rec.pricing_group_sequence,
2373: l_qp_list_lines_rec.incompatibility_grp_code,

Line 2370: l_qp_list_lines_rec.reprice_flag,

2366: l_qp_list_lines_rec.print_on_invoice_flag,
2367: l_qp_list_lines_rec.rebate_transaction_type_code,
2368: l_qp_list_lines_rec.estim_accrual_rate,
2369: l_qp_list_lines_rec.generate_using_formula_id,
2370: l_qp_list_lines_rec.reprice_flag,
2371: l_qp_list_lines_rec.accrual_flag,
2372: l_qp_list_lines_rec.pricing_group_sequence,
2373: l_qp_list_lines_rec.incompatibility_grp_code,
2374: l_qp_list_lines_rec.list_line_no,

Line 2371: l_qp_list_lines_rec.accrual_flag,

2367: l_qp_list_lines_rec.rebate_transaction_type_code,
2368: l_qp_list_lines_rec.estim_accrual_rate,
2369: l_qp_list_lines_rec.generate_using_formula_id,
2370: l_qp_list_lines_rec.reprice_flag,
2371: l_qp_list_lines_rec.accrual_flag,
2372: l_qp_list_lines_rec.pricing_group_sequence,
2373: l_qp_list_lines_rec.incompatibility_grp_code,
2374: l_qp_list_lines_rec.list_line_no,
2375: l_qp_list_lines_rec.product_precedence,

Line 2372: l_qp_list_lines_rec.pricing_group_sequence,

2368: l_qp_list_lines_rec.estim_accrual_rate,
2369: l_qp_list_lines_rec.generate_using_formula_id,
2370: l_qp_list_lines_rec.reprice_flag,
2371: l_qp_list_lines_rec.accrual_flag,
2372: l_qp_list_lines_rec.pricing_group_sequence,
2373: l_qp_list_lines_rec.incompatibility_grp_code,
2374: l_qp_list_lines_rec.list_line_no,
2375: l_qp_list_lines_rec.product_precedence,
2376: l_qp_list_lines_rec.pricing_phase_id,

Line 2373: l_qp_list_lines_rec.incompatibility_grp_code,

2369: l_qp_list_lines_rec.generate_using_formula_id,
2370: l_qp_list_lines_rec.reprice_flag,
2371: l_qp_list_lines_rec.accrual_flag,
2372: l_qp_list_lines_rec.pricing_group_sequence,
2373: l_qp_list_lines_rec.incompatibility_grp_code,
2374: l_qp_list_lines_rec.list_line_no,
2375: l_qp_list_lines_rec.product_precedence,
2376: l_qp_list_lines_rec.pricing_phase_id,
2377: l_qp_list_lines_rec.expiration_period_start_date,

Line 2374: l_qp_list_lines_rec.list_line_no,

2370: l_qp_list_lines_rec.reprice_flag,
2371: l_qp_list_lines_rec.accrual_flag,
2372: l_qp_list_lines_rec.pricing_group_sequence,
2373: l_qp_list_lines_rec.incompatibility_grp_code,
2374: l_qp_list_lines_rec.list_line_no,
2375: l_qp_list_lines_rec.product_precedence,
2376: l_qp_list_lines_rec.pricing_phase_id,
2377: l_qp_list_lines_rec.expiration_period_start_date,
2378: l_qp_list_lines_rec.number_expiration_periods,

Line 2375: l_qp_list_lines_rec.product_precedence,

2371: l_qp_list_lines_rec.accrual_flag,
2372: l_qp_list_lines_rec.pricing_group_sequence,
2373: l_qp_list_lines_rec.incompatibility_grp_code,
2374: l_qp_list_lines_rec.list_line_no,
2375: l_qp_list_lines_rec.product_precedence,
2376: l_qp_list_lines_rec.pricing_phase_id,
2377: l_qp_list_lines_rec.expiration_period_start_date,
2378: l_qp_list_lines_rec.number_expiration_periods,
2379: l_qp_list_lines_rec.expiration_period_uom,

Line 2376: l_qp_list_lines_rec.pricing_phase_id,

2372: l_qp_list_lines_rec.pricing_group_sequence,
2373: l_qp_list_lines_rec.incompatibility_grp_code,
2374: l_qp_list_lines_rec.list_line_no,
2375: l_qp_list_lines_rec.product_precedence,
2376: l_qp_list_lines_rec.pricing_phase_id,
2377: l_qp_list_lines_rec.expiration_period_start_date,
2378: l_qp_list_lines_rec.number_expiration_periods,
2379: l_qp_list_lines_rec.expiration_period_uom,
2380: l_qp_list_lines_rec.expiration_date,

Line 2377: l_qp_list_lines_rec.expiration_period_start_date,

2373: l_qp_list_lines_rec.incompatibility_grp_code,
2374: l_qp_list_lines_rec.list_line_no,
2375: l_qp_list_lines_rec.product_precedence,
2376: l_qp_list_lines_rec.pricing_phase_id,
2377: l_qp_list_lines_rec.expiration_period_start_date,
2378: l_qp_list_lines_rec.number_expiration_periods,
2379: l_qp_list_lines_rec.expiration_period_uom,
2380: l_qp_list_lines_rec.expiration_date,
2381: l_qp_list_lines_rec.estim_gl_value,

Line 2378: l_qp_list_lines_rec.number_expiration_periods,

2374: l_qp_list_lines_rec.list_line_no,
2375: l_qp_list_lines_rec.product_precedence,
2376: l_qp_list_lines_rec.pricing_phase_id,
2377: l_qp_list_lines_rec.expiration_period_start_date,
2378: l_qp_list_lines_rec.number_expiration_periods,
2379: l_qp_list_lines_rec.expiration_period_uom,
2380: l_qp_list_lines_rec.expiration_date,
2381: l_qp_list_lines_rec.estim_gl_value,
2382: l_qp_list_lines_rec.accrual_conversion_rate,

Line 2379: l_qp_list_lines_rec.expiration_period_uom,

2375: l_qp_list_lines_rec.product_precedence,
2376: l_qp_list_lines_rec.pricing_phase_id,
2377: l_qp_list_lines_rec.expiration_period_start_date,
2378: l_qp_list_lines_rec.number_expiration_periods,
2379: l_qp_list_lines_rec.expiration_period_uom,
2380: l_qp_list_lines_rec.expiration_date,
2381: l_qp_list_lines_rec.estim_gl_value,
2382: l_qp_list_lines_rec.accrual_conversion_rate,
2383: l_qp_list_lines_rec.benefit_price_list_line_id,

Line 2380: l_qp_list_lines_rec.expiration_date,

2376: l_qp_list_lines_rec.pricing_phase_id,
2377: l_qp_list_lines_rec.expiration_period_start_date,
2378: l_qp_list_lines_rec.number_expiration_periods,
2379: l_qp_list_lines_rec.expiration_period_uom,
2380: l_qp_list_lines_rec.expiration_date,
2381: l_qp_list_lines_rec.estim_gl_value,
2382: l_qp_list_lines_rec.accrual_conversion_rate,
2383: l_qp_list_lines_rec.benefit_price_list_line_id,
2384: l_qp_list_lines_rec.proration_type_code,

Line 2381: l_qp_list_lines_rec.estim_gl_value,

2377: l_qp_list_lines_rec.expiration_period_start_date,
2378: l_qp_list_lines_rec.number_expiration_periods,
2379: l_qp_list_lines_rec.expiration_period_uom,
2380: l_qp_list_lines_rec.expiration_date,
2381: l_qp_list_lines_rec.estim_gl_value,
2382: l_qp_list_lines_rec.accrual_conversion_rate,
2383: l_qp_list_lines_rec.benefit_price_list_line_id,
2384: l_qp_list_lines_rec.proration_type_code,
2385: l_qp_list_lines_rec.benefit_qty,

Line 2382: l_qp_list_lines_rec.accrual_conversion_rate,

2378: l_qp_list_lines_rec.number_expiration_periods,
2379: l_qp_list_lines_rec.expiration_period_uom,
2380: l_qp_list_lines_rec.expiration_date,
2381: l_qp_list_lines_rec.estim_gl_value,
2382: l_qp_list_lines_rec.accrual_conversion_rate,
2383: l_qp_list_lines_rec.benefit_price_list_line_id,
2384: l_qp_list_lines_rec.proration_type_code,
2385: l_qp_list_lines_rec.benefit_qty,
2386: l_qp_list_lines_rec.benefit_uom_code,

Line 2383: l_qp_list_lines_rec.benefit_price_list_line_id,

2379: l_qp_list_lines_rec.expiration_period_uom,
2380: l_qp_list_lines_rec.expiration_date,
2381: l_qp_list_lines_rec.estim_gl_value,
2382: l_qp_list_lines_rec.accrual_conversion_rate,
2383: l_qp_list_lines_rec.benefit_price_list_line_id,
2384: l_qp_list_lines_rec.proration_type_code,
2385: l_qp_list_lines_rec.benefit_qty,
2386: l_qp_list_lines_rec.benefit_uom_code,
2387: l_qp_list_lines_rec.charge_type_code,

Line 2384: l_qp_list_lines_rec.proration_type_code,

2380: l_qp_list_lines_rec.expiration_date,
2381: l_qp_list_lines_rec.estim_gl_value,
2382: l_qp_list_lines_rec.accrual_conversion_rate,
2383: l_qp_list_lines_rec.benefit_price_list_line_id,
2384: l_qp_list_lines_rec.proration_type_code,
2385: l_qp_list_lines_rec.benefit_qty,
2386: l_qp_list_lines_rec.benefit_uom_code,
2387: l_qp_list_lines_rec.charge_type_code,
2388: l_qp_list_lines_rec.charge_subtype_code,

Line 2385: l_qp_list_lines_rec.benefit_qty,

2381: l_qp_list_lines_rec.estim_gl_value,
2382: l_qp_list_lines_rec.accrual_conversion_rate,
2383: l_qp_list_lines_rec.benefit_price_list_line_id,
2384: l_qp_list_lines_rec.proration_type_code,
2385: l_qp_list_lines_rec.benefit_qty,
2386: l_qp_list_lines_rec.benefit_uom_code,
2387: l_qp_list_lines_rec.charge_type_code,
2388: l_qp_list_lines_rec.charge_subtype_code,
2389: l_qp_list_lines_rec.benefit_limit,

Line 2386: l_qp_list_lines_rec.benefit_uom_code,

2382: l_qp_list_lines_rec.accrual_conversion_rate,
2383: l_qp_list_lines_rec.benefit_price_list_line_id,
2384: l_qp_list_lines_rec.proration_type_code,
2385: l_qp_list_lines_rec.benefit_qty,
2386: l_qp_list_lines_rec.benefit_uom_code,
2387: l_qp_list_lines_rec.charge_type_code,
2388: l_qp_list_lines_rec.charge_subtype_code,
2389: l_qp_list_lines_rec.benefit_limit,
2390: l_qp_list_lines_rec.include_on_returns_flag,

Line 2387: l_qp_list_lines_rec.charge_type_code,

2383: l_qp_list_lines_rec.benefit_price_list_line_id,
2384: l_qp_list_lines_rec.proration_type_code,
2385: l_qp_list_lines_rec.benefit_qty,
2386: l_qp_list_lines_rec.benefit_uom_code,
2387: l_qp_list_lines_rec.charge_type_code,
2388: l_qp_list_lines_rec.charge_subtype_code,
2389: l_qp_list_lines_rec.benefit_limit,
2390: l_qp_list_lines_rec.include_on_returns_flag,
2391: l_qp_list_lines_rec.qualification_ind,

Line 2388: l_qp_list_lines_rec.charge_subtype_code,

2384: l_qp_list_lines_rec.proration_type_code,
2385: l_qp_list_lines_rec.benefit_qty,
2386: l_qp_list_lines_rec.benefit_uom_code,
2387: l_qp_list_lines_rec.charge_type_code,
2388: l_qp_list_lines_rec.charge_subtype_code,
2389: l_qp_list_lines_rec.benefit_limit,
2390: l_qp_list_lines_rec.include_on_returns_flag,
2391: l_qp_list_lines_rec.qualification_ind,
2392: l_qp_list_lines_rec.recurring_value, -- block pricing

Line 2389: l_qp_list_lines_rec.benefit_limit,

2385: l_qp_list_lines_rec.benefit_qty,
2386: l_qp_list_lines_rec.benefit_uom_code,
2387: l_qp_list_lines_rec.charge_type_code,
2388: l_qp_list_lines_rec.charge_subtype_code,
2389: l_qp_list_lines_rec.benefit_limit,
2390: l_qp_list_lines_rec.include_on_returns_flag,
2391: l_qp_list_lines_rec.qualification_ind,
2392: l_qp_list_lines_rec.recurring_value, -- block pricing
2393: decode(l_qp_list_lines_rec.list_line_type_code,'PBH','Y',

Line 2390: l_qp_list_lines_rec.include_on_returns_flag,

2386: l_qp_list_lines_rec.benefit_uom_code,
2387: l_qp_list_lines_rec.charge_type_code,
2388: l_qp_list_lines_rec.charge_subtype_code,
2389: l_qp_list_lines_rec.benefit_limit,
2390: l_qp_list_lines_rec.include_on_returns_flag,
2391: l_qp_list_lines_rec.qualification_ind,
2392: l_qp_list_lines_rec.recurring_value, -- block pricing
2393: decode(l_qp_list_lines_rec.list_line_type_code,'PBH','Y',
2394: l_qp_list_lines_rec.continuous_price_break_flag) -- Continuous Price Breaks

Line 2391: l_qp_list_lines_rec.qualification_ind,

2387: l_qp_list_lines_rec.charge_type_code,
2388: l_qp_list_lines_rec.charge_subtype_code,
2389: l_qp_list_lines_rec.benefit_limit,
2390: l_qp_list_lines_rec.include_on_returns_flag,
2391: l_qp_list_lines_rec.qualification_ind,
2392: l_qp_list_lines_rec.recurring_value, -- block pricing
2393: decode(l_qp_list_lines_rec.list_line_type_code,'PBH','Y',
2394: l_qp_list_lines_rec.continuous_price_break_flag) -- Continuous Price Breaks
2395: --ENH Upgrade BOAPI for orig_sys...ref RAVI

Line 2392: l_qp_list_lines_rec.recurring_value, -- block pricing

2388: l_qp_list_lines_rec.charge_subtype_code,
2389: l_qp_list_lines_rec.benefit_limit,
2390: l_qp_list_lines_rec.include_on_returns_flag,
2391: l_qp_list_lines_rec.qualification_ind,
2392: l_qp_list_lines_rec.recurring_value, -- block pricing
2393: decode(l_qp_list_lines_rec.list_line_type_code,'PBH','Y',
2394: l_qp_list_lines_rec.continuous_price_break_flag) -- Continuous Price Breaks
2395: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2396: ,to_char(l_qp_list_lines_rec.list_line_id) --7309992

Line 2393: decode(l_qp_list_lines_rec.list_line_type_code,'PBH','Y',

2389: l_qp_list_lines_rec.benefit_limit,
2390: l_qp_list_lines_rec.include_on_returns_flag,
2391: l_qp_list_lines_rec.qualification_ind,
2392: l_qp_list_lines_rec.recurring_value, -- block pricing
2393: decode(l_qp_list_lines_rec.list_line_type_code,'PBH','Y',
2394: l_qp_list_lines_rec.continuous_price_break_flag) -- Continuous Price Breaks
2395: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2396: ,to_char(l_qp_list_lines_rec.list_line_id) --7309992
2397: ,to_char(l_qp_list_lines_rec.list_header_id) --7309992

Line 2394: l_qp_list_lines_rec.continuous_price_break_flag) -- Continuous Price Breaks

2390: l_qp_list_lines_rec.include_on_returns_flag,
2391: l_qp_list_lines_rec.qualification_ind,
2392: l_qp_list_lines_rec.recurring_value, -- block pricing
2393: decode(l_qp_list_lines_rec.list_line_type_code,'PBH','Y',
2394: l_qp_list_lines_rec.continuous_price_break_flag) -- Continuous Price Breaks
2395: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2396: ,to_char(l_qp_list_lines_rec.list_line_id) --7309992
2397: ,to_char(l_qp_list_lines_rec.list_header_id) --7309992
2398: --(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id)

Line 2396: ,to_char(l_qp_list_lines_rec.list_line_id) --7309992

2392: l_qp_list_lines_rec.recurring_value, -- block pricing
2393: decode(l_qp_list_lines_rec.list_line_type_code,'PBH','Y',
2394: l_qp_list_lines_rec.continuous_price_break_flag) -- Continuous Price Breaks
2395: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2396: ,to_char(l_qp_list_lines_rec.list_line_id) --7309992
2397: ,to_char(l_qp_list_lines_rec.list_header_id) --7309992
2398: --(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id)
2399: );
2400: fnd_file.put_line(FND_FILE.LOG,'Inserted line');

Line 2397: ,to_char(l_qp_list_lines_rec.list_header_id) --7309992

2393: decode(l_qp_list_lines_rec.list_line_type_code,'PBH','Y',
2394: l_qp_list_lines_rec.continuous_price_break_flag) -- Continuous Price Breaks
2395: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2396: ,to_char(l_qp_list_lines_rec.list_line_id) --7309992
2397: ,to_char(l_qp_list_lines_rec.list_header_id) --7309992
2398: --(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id)
2399: );
2400: fnd_file.put_line(FND_FILE.LOG,'Inserted line');
2401: fnd_file.put_line(FND_FILE.LOG,'list_line_id ' || l_new_list_line_id);

Line 2402: fnd_file.put_line(FND_FILE.LOG,'list_line_type_code ' || l_qp_list_lines_rec.list_line_type_code);

2398: --(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id)
2399: );
2400: fnd_file.put_line(FND_FILE.LOG,'Inserted line');
2401: fnd_file.put_line(FND_FILE.LOG,'list_line_id ' || l_new_list_line_id);
2402: fnd_file.put_line(FND_FILE.LOG,'list_line_type_code ' || l_qp_list_lines_rec.list_line_type_code);
2403:
2404:
2405: /*If the list_line_rec is a Price Break Parent Line or Price Break Line then
2406: store the old and new list line id in a mapping-array for later use*/

Line 2408: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' OR

2404:
2405: /*If the list_line_rec is a Price Break Parent Line or Price Break Line then
2406: store the old and new list line id in a mapping-array for later use*/
2407:
2408: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' OR
2409: Price_Break_Line(l_qp_list_lines_rec.list_line_id)
2410: THEN
2411: l_count := l_count + 1;
2412: l_mapping_tbl(l_count).list_line_type_code :=

Line 2409: Price_Break_Line(l_qp_list_lines_rec.list_line_id)

2405: /*If the list_line_rec is a Price Break Parent Line or Price Break Line then
2406: store the old and new list line id in a mapping-array for later use*/
2407:
2408: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' OR
2409: Price_Break_Line(l_qp_list_lines_rec.list_line_id)
2410: THEN
2411: l_count := l_count + 1;
2412: l_mapping_tbl(l_count).list_line_type_code :=
2413: l_qp_list_lines_rec.list_line_type_code;

Line 2413: l_qp_list_lines_rec.list_line_type_code;

2409: Price_Break_Line(l_qp_list_lines_rec.list_line_id)
2410: THEN
2411: l_count := l_count + 1;
2412: l_mapping_tbl(l_count).list_line_type_code :=
2413: l_qp_list_lines_rec.list_line_type_code;
2414: l_mapping_tbl(l_count).old_list_line_id :=
2415: l_qp_list_lines_rec.list_line_id;
2416: l_mapping_tbl(l_count).new_list_line_id := l_new_list_line_id;
2417: END IF;

Line 2415: l_qp_list_lines_rec.list_line_id;

2411: l_count := l_count + 1;
2412: l_mapping_tbl(l_count).list_line_type_code :=
2413: l_qp_list_lines_rec.list_line_type_code;
2414: l_mapping_tbl(l_count).old_list_line_id :=
2415: l_qp_list_lines_rec.list_line_id;
2416: l_mapping_tbl(l_count).new_list_line_id := l_new_list_line_id;
2417: END IF;
2418:
2419: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' AND

Line 2419: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' AND

2415: l_qp_list_lines_rec.list_line_id;
2416: l_mapping_tbl(l_count).new_list_line_id := l_new_list_line_id;
2417: END IF;
2418:
2419: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' AND
2420: (l_qp_list_lines_rec.continuous_price_break_flag IS NULL OR l_qp_list_lines_rec.continuous_price_break_flag <> 'Y')
2421: THEN
2422: l_non_cont_count := l_non_cont_count + 1;
2423: l_non_cont_pbh_id_tbl(l_non_cont_count).price_break_header_id := l_new_list_line_id;

Line 2420: (l_qp_list_lines_rec.continuous_price_break_flag IS NULL OR l_qp_list_lines_rec.continuous_price_break_flag <> 'Y')

2416: l_mapping_tbl(l_count).new_list_line_id := l_new_list_line_id;
2417: END IF;
2418:
2419: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' AND
2420: (l_qp_list_lines_rec.continuous_price_break_flag IS NULL OR l_qp_list_lines_rec.continuous_price_break_flag <> 'Y')
2421: THEN
2422: l_non_cont_count := l_non_cont_count + 1;
2423: l_non_cont_pbh_id_tbl(l_non_cont_count).price_break_header_id := l_new_list_line_id;
2424: l_non_cont_pbh_id_tbl(l_non_cont_count).list_line_no := l_qp_list_lines_rec.list_line_no;

Line 2424: l_non_cont_pbh_id_tbl(l_non_cont_count).list_line_no := l_qp_list_lines_rec.list_line_no;

2420: (l_qp_list_lines_rec.continuous_price_break_flag IS NULL OR l_qp_list_lines_rec.continuous_price_break_flag <> 'Y')
2421: THEN
2422: l_non_cont_count := l_non_cont_count + 1;
2423: l_non_cont_pbh_id_tbl(l_non_cont_count).price_break_header_id := l_new_list_line_id;
2424: l_non_cont_pbh_id_tbl(l_non_cont_count).list_line_no := l_qp_list_lines_rec.list_line_no;
2425:
2426: IF p_effective_dates_flag = 'Y' THEN
2427: l_non_cont_pbh_id_tbl(l_non_cont_count).start_date_active := l_qp_list_lines_rec.start_date_active;
2428: l_non_cont_pbh_id_tbl(l_non_cont_count).end_date_active := l_qp_list_lines_rec.end_date_active;

Line 2427: l_non_cont_pbh_id_tbl(l_non_cont_count).start_date_active := l_qp_list_lines_rec.start_date_active;

2423: l_non_cont_pbh_id_tbl(l_non_cont_count).price_break_header_id := l_new_list_line_id;
2424: l_non_cont_pbh_id_tbl(l_non_cont_count).list_line_no := l_qp_list_lines_rec.list_line_no;
2425:
2426: IF p_effective_dates_flag = 'Y' THEN
2427: l_non_cont_pbh_id_tbl(l_non_cont_count).start_date_active := l_qp_list_lines_rec.start_date_active;
2428: l_non_cont_pbh_id_tbl(l_non_cont_count).end_date_active := l_qp_list_lines_rec.end_date_active;
2429: END IF;
2430:
2431: END IF;

Line 2428: l_non_cont_pbh_id_tbl(l_non_cont_count).end_date_active := l_qp_list_lines_rec.end_date_active;

2424: l_non_cont_pbh_id_tbl(l_non_cont_count).list_line_no := l_qp_list_lines_rec.list_line_no;
2425:
2426: IF p_effective_dates_flag = 'Y' THEN
2427: l_non_cont_pbh_id_tbl(l_non_cont_count).start_date_active := l_qp_list_lines_rec.start_date_active;
2428: l_non_cont_pbh_id_tbl(l_non_cont_count).end_date_active := l_qp_list_lines_rec.end_date_active;
2429: END IF;
2430:
2431: END IF;
2432:

Line 2440: l_qp_list_lines_rec.list_line_id)

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
2444: SELECT qp_pricing_attributes_s.nextval

Line 2448: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' AND

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
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 :=

Line 2449: (l_qp_list_lines_rec.continuous_price_break_flag IS NULL OR l_qp_list_lines_rec.continuous_price_break_flag <> 'Y')

2445: INTO l_new_pricing_attribute_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;

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 2580: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_new_list_line_id)

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)
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);

Line 2591: END LOOP; /* Cursor qp_list_lines_cv LOOP */

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;
2594:
2595:

Line 2593: CLOSE qp_list_lines_cv;

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;
2594:
2595:
2596: /* Copy qp_rltd_modifiers for the Price Break Parent list_lines chosen
2597: above which are stored in the mapping table */

Line 2735: from qp_list_lines

2731: fnd_file.put_line(FND_FILE.LOG,'Price list copy completed successfully');
2732: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
2733: select min(list_line_id), max(list_line_id)
2734: into l_min_list_line_id, l_max_list_line_id
2735: from qp_list_lines
2736: where list_header_id = l_new_list_header_id;
2737:
2738:
2739: QP_ATTR_GRP_PVT.Update_Qual_Segment_id(l_new_list_header_id,