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 374: FROM qp_list_lines

370:
371: CURSOR qp_discount_lines_cur(p_from_discount_header_id NUMBER)
372: IS
373: SELECT *
374: FROM qp_list_lines
375: WHERE list_header_id = p_from_discount_header_id;
376:
377: CURSOR qp_pricing_attributes_cur(p_from_discount_line_id NUMBER)
378: IS

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

761: l_qp_qualifiers_rec.header_quals_exist_flag,
762: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
763: --ENH Upgrade BOAPI for orig_sys...ref RAVI
764: ,to_char(l_new_qualifier_id)
765: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)
766: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)
767: );
768:
769: END LOOP; /* For copying qualifiers */

Line 779: SELECT qp_list_lines_s.nextval

775: qp_discount_lines_cur (qp_from_discounts_rec.list_header_id)
776: LOOP
777:
778: --Get New Discount Line Id
779: SELECT qp_list_lines_s.nextval
780: INTO l_new_discount_line_id
781: FROM dual;
782:
783: --Insert Discount Line

Line 784: INSERT INTO qp_list_lines

780: INTO l_new_discount_line_id
781: FROM dual;
782:
783: --Insert Discount Line
784: INSERT INTO qp_list_lines
785: (
786: list_line_id,
787: creation_date,
788: created_by,

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

1103: l_pric_attr_value_from_number,
1104: l_pric_attr_value_to_number
1105: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1106: ,to_char(l_new_pricing_attribute_id)
1107: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_new_discount_line_id)
1108: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)
1109: );
1110:
1111: END LOOP; /* For copying pricing attributes for each discount line */

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

1275: l_qp_qualifiers_rec.header_quals_exist_flag,
1276: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
1277: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1278: ,to_char(l_new_qualifier_id)
1279: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)
1280: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_discount_header_id)
1281: );
1282:
1283: END LOOP; /* For copying qualifiers */---Added for bug 8326619

Line 1451: TYPE qp_list_lines_rec IS RECORD (

1447: l_max_list_line_id NUMBER;
1448:
1449:
1450:
1451: TYPE qp_list_lines_rec IS RECORD (
1452: list_line_id QP_LIST_LINES.list_line_id%TYPE,
1453: creation_date QP_LIST_LINES.creation_date%TYPE,
1454: created_by QP_LIST_LINES.created_by%TYPE,
1455: last_update_date QP_LIST_LINES.last_update_date%TYPE,

Line 1452: list_line_id QP_LIST_LINES.list_line_id%TYPE,

1448:
1449:
1450:
1451: TYPE qp_list_lines_rec IS RECORD (
1452: list_line_id QP_LIST_LINES.list_line_id%TYPE,
1453: creation_date QP_LIST_LINES.creation_date%TYPE,
1454: created_by QP_LIST_LINES.created_by%TYPE,
1455: last_update_date QP_LIST_LINES.last_update_date%TYPE,
1456: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,

Line 1453: creation_date QP_LIST_LINES.creation_date%TYPE,

1449:
1450:
1451: TYPE qp_list_lines_rec IS RECORD (
1452: list_line_id QP_LIST_LINES.list_line_id%TYPE,
1453: creation_date QP_LIST_LINES.creation_date%TYPE,
1454: created_by QP_LIST_LINES.created_by%TYPE,
1455: last_update_date QP_LIST_LINES.last_update_date%TYPE,
1456: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
1457: last_update_login QP_LIST_LINES.last_update_login%TYPE,

Line 1454: created_by QP_LIST_LINES.created_by%TYPE,

1450:
1451: TYPE qp_list_lines_rec IS RECORD (
1452: list_line_id QP_LIST_LINES.list_line_id%TYPE,
1453: creation_date QP_LIST_LINES.creation_date%TYPE,
1454: created_by QP_LIST_LINES.created_by%TYPE,
1455: last_update_date QP_LIST_LINES.last_update_date%TYPE,
1456: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
1457: last_update_login QP_LIST_LINES.last_update_login%TYPE,
1458: program_application_id QP_LIST_LINES.program_application_id%TYPE,

Line 1455: last_update_date QP_LIST_LINES.last_update_date%TYPE,

1451: TYPE qp_list_lines_rec IS RECORD (
1452: list_line_id QP_LIST_LINES.list_line_id%TYPE,
1453: creation_date QP_LIST_LINES.creation_date%TYPE,
1454: created_by QP_LIST_LINES.created_by%TYPE,
1455: last_update_date QP_LIST_LINES.last_update_date%TYPE,
1456: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
1457: last_update_login QP_LIST_LINES.last_update_login%TYPE,
1458: program_application_id QP_LIST_LINES.program_application_id%TYPE,
1459: program_id QP_LIST_LINES.program_id%TYPE,

Line 1456: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,

1452: list_line_id QP_LIST_LINES.list_line_id%TYPE,
1453: creation_date QP_LIST_LINES.creation_date%TYPE,
1454: created_by QP_LIST_LINES.created_by%TYPE,
1455: last_update_date QP_LIST_LINES.last_update_date%TYPE,
1456: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
1457: last_update_login QP_LIST_LINES.last_update_login%TYPE,
1458: program_application_id QP_LIST_LINES.program_application_id%TYPE,
1459: program_id QP_LIST_LINES.program_id%TYPE,
1460: program_update_date QP_LIST_LINES.program_update_date%TYPE,

Line 1457: last_update_login QP_LIST_LINES.last_update_login%TYPE,

1453: creation_date QP_LIST_LINES.creation_date%TYPE,
1454: created_by QP_LIST_LINES.created_by%TYPE,
1455: last_update_date QP_LIST_LINES.last_update_date%TYPE,
1456: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
1457: last_update_login QP_LIST_LINES.last_update_login%TYPE,
1458: program_application_id QP_LIST_LINES.program_application_id%TYPE,
1459: program_id QP_LIST_LINES.program_id%TYPE,
1460: program_update_date QP_LIST_LINES.program_update_date%TYPE,
1461: request_id QP_LIST_LINES.request_id%TYPE,

Line 1458: program_application_id QP_LIST_LINES.program_application_id%TYPE,

1454: created_by QP_LIST_LINES.created_by%TYPE,
1455: last_update_date QP_LIST_LINES.last_update_date%TYPE,
1456: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
1457: last_update_login QP_LIST_LINES.last_update_login%TYPE,
1458: program_application_id QP_LIST_LINES.program_application_id%TYPE,
1459: program_id QP_LIST_LINES.program_id%TYPE,
1460: program_update_date QP_LIST_LINES.program_update_date%TYPE,
1461: request_id QP_LIST_LINES.request_id%TYPE,
1462: list_header_id QP_LIST_LINES.list_header_id%TYPE,

Line 1459: program_id QP_LIST_LINES.program_id%TYPE,

1455: last_update_date QP_LIST_LINES.last_update_date%TYPE,
1456: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
1457: last_update_login QP_LIST_LINES.last_update_login%TYPE,
1458: program_application_id QP_LIST_LINES.program_application_id%TYPE,
1459: program_id QP_LIST_LINES.program_id%TYPE,
1460: program_update_date QP_LIST_LINES.program_update_date%TYPE,
1461: request_id QP_LIST_LINES.request_id%TYPE,
1462: list_header_id QP_LIST_LINES.list_header_id%TYPE,
1463: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,

Line 1460: program_update_date QP_LIST_LINES.program_update_date%TYPE,

1456: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
1457: last_update_login QP_LIST_LINES.last_update_login%TYPE,
1458: program_application_id QP_LIST_LINES.program_application_id%TYPE,
1459: program_id QP_LIST_LINES.program_id%TYPE,
1460: program_update_date QP_LIST_LINES.program_update_date%TYPE,
1461: request_id QP_LIST_LINES.request_id%TYPE,
1462: list_header_id QP_LIST_LINES.list_header_id%TYPE,
1463: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
1464: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,

Line 1461: request_id QP_LIST_LINES.request_id%TYPE,

1457: last_update_login QP_LIST_LINES.last_update_login%TYPE,
1458: program_application_id QP_LIST_LINES.program_application_id%TYPE,
1459: program_id QP_LIST_LINES.program_id%TYPE,
1460: program_update_date QP_LIST_LINES.program_update_date%TYPE,
1461: request_id QP_LIST_LINES.request_id%TYPE,
1462: list_header_id QP_LIST_LINES.list_header_id%TYPE,
1463: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
1464: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
1465: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,

Line 1462: list_header_id QP_LIST_LINES.list_header_id%TYPE,

1458: program_application_id QP_LIST_LINES.program_application_id%TYPE,
1459: program_id QP_LIST_LINES.program_id%TYPE,
1460: program_update_date QP_LIST_LINES.program_update_date%TYPE,
1461: request_id QP_LIST_LINES.request_id%TYPE,
1462: list_header_id QP_LIST_LINES.list_header_id%TYPE,
1463: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
1464: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
1465: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
1466: list_price QP_LIST_LINES.list_price%TYPE,

Line 1463: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,

1459: program_id QP_LIST_LINES.program_id%TYPE,
1460: program_update_date QP_LIST_LINES.program_update_date%TYPE,
1461: request_id QP_LIST_LINES.request_id%TYPE,
1462: list_header_id QP_LIST_LINES.list_header_id%TYPE,
1463: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
1464: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
1465: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
1466: list_price QP_LIST_LINES.list_price%TYPE,
1467: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,

Line 1464: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,

1460: program_update_date QP_LIST_LINES.program_update_date%TYPE,
1461: request_id QP_LIST_LINES.request_id%TYPE,
1462: list_header_id QP_LIST_LINES.list_header_id%TYPE,
1463: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
1464: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
1465: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
1466: list_price QP_LIST_LINES.list_price%TYPE,
1467: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
1468: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,

Line 1465: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,

1461: request_id QP_LIST_LINES.request_id%TYPE,
1462: list_header_id QP_LIST_LINES.list_header_id%TYPE,
1463: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
1464: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
1465: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
1466: list_price QP_LIST_LINES.list_price%TYPE,
1467: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
1468: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
1469: organization_id QP_LIST_LINES.organization_id%TYPE,

Line 1466: list_price QP_LIST_LINES.list_price%TYPE,

1462: list_header_id QP_LIST_LINES.list_header_id%TYPE,
1463: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
1464: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
1465: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
1466: list_price QP_LIST_LINES.list_price%TYPE,
1467: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
1468: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
1469: organization_id QP_LIST_LINES.organization_id%TYPE,
1470: related_item_id QP_LIST_LINES.related_item_id%TYPE,

Line 1467: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,

1463: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
1464: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
1465: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
1466: list_price QP_LIST_LINES.list_price%TYPE,
1467: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
1468: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
1469: organization_id QP_LIST_LINES.organization_id%TYPE,
1470: related_item_id QP_LIST_LINES.related_item_id%TYPE,
1471: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,

Line 1468: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,

1464: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
1465: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
1466: list_price QP_LIST_LINES.list_price%TYPE,
1467: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
1468: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
1469: organization_id QP_LIST_LINES.organization_id%TYPE,
1470: related_item_id QP_LIST_LINES.related_item_id%TYPE,
1471: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
1472: substitution_context QP_LIST_LINES.substitution_context%TYPE,

Line 1469: organization_id QP_LIST_LINES.organization_id%TYPE,

1465: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
1466: list_price QP_LIST_LINES.list_price%TYPE,
1467: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
1468: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
1469: organization_id QP_LIST_LINES.organization_id%TYPE,
1470: related_item_id QP_LIST_LINES.related_item_id%TYPE,
1471: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
1472: substitution_context QP_LIST_LINES.substitution_context%TYPE,
1473: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,

Line 1470: related_item_id QP_LIST_LINES.related_item_id%TYPE,

1466: list_price QP_LIST_LINES.list_price%TYPE,
1467: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
1468: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
1469: organization_id QP_LIST_LINES.organization_id%TYPE,
1470: related_item_id QP_LIST_LINES.related_item_id%TYPE,
1471: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
1472: substitution_context QP_LIST_LINES.substitution_context%TYPE,
1473: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
1474: substitution_value QP_LIST_LINES.substitution_value%TYPE,

Line 1471: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,

1467: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
1468: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
1469: organization_id QP_LIST_LINES.organization_id%TYPE,
1470: related_item_id QP_LIST_LINES.related_item_id%TYPE,
1471: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
1472: substitution_context QP_LIST_LINES.substitution_context%TYPE,
1473: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
1474: substitution_value QP_LIST_LINES.substitution_value%TYPE,
1475: revision QP_LIST_LINES.revision%TYPE,

Line 1472: substitution_context QP_LIST_LINES.substitution_context%TYPE,

1468: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
1469: organization_id QP_LIST_LINES.organization_id%TYPE,
1470: related_item_id QP_LIST_LINES.related_item_id%TYPE,
1471: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
1472: substitution_context QP_LIST_LINES.substitution_context%TYPE,
1473: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
1474: substitution_value QP_LIST_LINES.substitution_value%TYPE,
1475: revision QP_LIST_LINES.revision%TYPE,
1476: revision_date QP_LIST_LINES.revision_date%TYPE,

Line 1473: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,

1469: organization_id QP_LIST_LINES.organization_id%TYPE,
1470: related_item_id QP_LIST_LINES.related_item_id%TYPE,
1471: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
1472: substitution_context QP_LIST_LINES.substitution_context%TYPE,
1473: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
1474: substitution_value QP_LIST_LINES.substitution_value%TYPE,
1475: revision QP_LIST_LINES.revision%TYPE,
1476: revision_date QP_LIST_LINES.revision_date%TYPE,
1477: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,

Line 1474: substitution_value QP_LIST_LINES.substitution_value%TYPE,

1470: related_item_id QP_LIST_LINES.related_item_id%TYPE,
1471: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
1472: substitution_context QP_LIST_LINES.substitution_context%TYPE,
1473: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
1474: substitution_value QP_LIST_LINES.substitution_value%TYPE,
1475: revision QP_LIST_LINES.revision%TYPE,
1476: revision_date QP_LIST_LINES.revision_date%TYPE,
1477: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
1478: context QP_LIST_LINES.context%TYPE,

Line 1475: revision QP_LIST_LINES.revision%TYPE,

1471: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
1472: substitution_context QP_LIST_LINES.substitution_context%TYPE,
1473: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
1474: substitution_value QP_LIST_LINES.substitution_value%TYPE,
1475: revision QP_LIST_LINES.revision%TYPE,
1476: revision_date QP_LIST_LINES.revision_date%TYPE,
1477: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
1478: context QP_LIST_LINES.context%TYPE,
1479: attribute1 QP_LIST_LINES.attribute1%TYPE,

Line 1476: revision_date QP_LIST_LINES.revision_date%TYPE,

1472: substitution_context QP_LIST_LINES.substitution_context%TYPE,
1473: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
1474: substitution_value QP_LIST_LINES.substitution_value%TYPE,
1475: revision QP_LIST_LINES.revision%TYPE,
1476: revision_date QP_LIST_LINES.revision_date%TYPE,
1477: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
1478: context QP_LIST_LINES.context%TYPE,
1479: attribute1 QP_LIST_LINES.attribute1%TYPE,
1480: attribute2 QP_LIST_LINES.attribute2%TYPE,

Line 1477: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,

1473: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
1474: substitution_value QP_LIST_LINES.substitution_value%TYPE,
1475: revision QP_LIST_LINES.revision%TYPE,
1476: revision_date QP_LIST_LINES.revision_date%TYPE,
1477: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
1478: context QP_LIST_LINES.context%TYPE,
1479: attribute1 QP_LIST_LINES.attribute1%TYPE,
1480: attribute2 QP_LIST_LINES.attribute2%TYPE,
1481: comments QP_LIST_LINES.comments%TYPE,

Line 1478: context QP_LIST_LINES.context%TYPE,

1474: substitution_value QP_LIST_LINES.substitution_value%TYPE,
1475: revision QP_LIST_LINES.revision%TYPE,
1476: revision_date QP_LIST_LINES.revision_date%TYPE,
1477: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
1478: context QP_LIST_LINES.context%TYPE,
1479: attribute1 QP_LIST_LINES.attribute1%TYPE,
1480: attribute2 QP_LIST_LINES.attribute2%TYPE,
1481: comments QP_LIST_LINES.comments%TYPE,
1482: attribute3 QP_LIST_LINES.attribute3%TYPE,

Line 1479: attribute1 QP_LIST_LINES.attribute1%TYPE,

1475: revision QP_LIST_LINES.revision%TYPE,
1476: revision_date QP_LIST_LINES.revision_date%TYPE,
1477: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
1478: context QP_LIST_LINES.context%TYPE,
1479: attribute1 QP_LIST_LINES.attribute1%TYPE,
1480: attribute2 QP_LIST_LINES.attribute2%TYPE,
1481: comments QP_LIST_LINES.comments%TYPE,
1482: attribute3 QP_LIST_LINES.attribute3%TYPE,
1483: attribute4 QP_LIST_LINES.attribute4%TYPE,

Line 1480: attribute2 QP_LIST_LINES.attribute2%TYPE,

1476: revision_date QP_LIST_LINES.revision_date%TYPE,
1477: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
1478: context QP_LIST_LINES.context%TYPE,
1479: attribute1 QP_LIST_LINES.attribute1%TYPE,
1480: attribute2 QP_LIST_LINES.attribute2%TYPE,
1481: comments QP_LIST_LINES.comments%TYPE,
1482: attribute3 QP_LIST_LINES.attribute3%TYPE,
1483: attribute4 QP_LIST_LINES.attribute4%TYPE,
1484: attribute5 QP_LIST_LINES.attribute5%TYPE,

Line 1481: comments QP_LIST_LINES.comments%TYPE,

1477: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
1478: context QP_LIST_LINES.context%TYPE,
1479: attribute1 QP_LIST_LINES.attribute1%TYPE,
1480: attribute2 QP_LIST_LINES.attribute2%TYPE,
1481: comments QP_LIST_LINES.comments%TYPE,
1482: attribute3 QP_LIST_LINES.attribute3%TYPE,
1483: attribute4 QP_LIST_LINES.attribute4%TYPE,
1484: attribute5 QP_LIST_LINES.attribute5%TYPE,
1485: attribute6 QP_LIST_LINES.attribute6%TYPE,

Line 1482: attribute3 QP_LIST_LINES.attribute3%TYPE,

1478: context QP_LIST_LINES.context%TYPE,
1479: attribute1 QP_LIST_LINES.attribute1%TYPE,
1480: attribute2 QP_LIST_LINES.attribute2%TYPE,
1481: comments QP_LIST_LINES.comments%TYPE,
1482: attribute3 QP_LIST_LINES.attribute3%TYPE,
1483: attribute4 QP_LIST_LINES.attribute4%TYPE,
1484: attribute5 QP_LIST_LINES.attribute5%TYPE,
1485: attribute6 QP_LIST_LINES.attribute6%TYPE,
1486: attribute7 QP_LIST_LINES.attribute7%TYPE,

Line 1483: attribute4 QP_LIST_LINES.attribute4%TYPE,

1479: attribute1 QP_LIST_LINES.attribute1%TYPE,
1480: attribute2 QP_LIST_LINES.attribute2%TYPE,
1481: comments QP_LIST_LINES.comments%TYPE,
1482: attribute3 QP_LIST_LINES.attribute3%TYPE,
1483: attribute4 QP_LIST_LINES.attribute4%TYPE,
1484: attribute5 QP_LIST_LINES.attribute5%TYPE,
1485: attribute6 QP_LIST_LINES.attribute6%TYPE,
1486: attribute7 QP_LIST_LINES.attribute7%TYPE,
1487: attribute8 QP_LIST_LINES.attribute8%TYPE,

Line 1484: attribute5 QP_LIST_LINES.attribute5%TYPE,

1480: attribute2 QP_LIST_LINES.attribute2%TYPE,
1481: comments QP_LIST_LINES.comments%TYPE,
1482: attribute3 QP_LIST_LINES.attribute3%TYPE,
1483: attribute4 QP_LIST_LINES.attribute4%TYPE,
1484: attribute5 QP_LIST_LINES.attribute5%TYPE,
1485: attribute6 QP_LIST_LINES.attribute6%TYPE,
1486: attribute7 QP_LIST_LINES.attribute7%TYPE,
1487: attribute8 QP_LIST_LINES.attribute8%TYPE,
1488: attribute9 QP_LIST_LINES.attribute9%TYPE,

Line 1485: attribute6 QP_LIST_LINES.attribute6%TYPE,

1481: comments QP_LIST_LINES.comments%TYPE,
1482: attribute3 QP_LIST_LINES.attribute3%TYPE,
1483: attribute4 QP_LIST_LINES.attribute4%TYPE,
1484: attribute5 QP_LIST_LINES.attribute5%TYPE,
1485: attribute6 QP_LIST_LINES.attribute6%TYPE,
1486: attribute7 QP_LIST_LINES.attribute7%TYPE,
1487: attribute8 QP_LIST_LINES.attribute8%TYPE,
1488: attribute9 QP_LIST_LINES.attribute9%TYPE,
1489: attribute10 QP_LIST_LINES.attribute10%TYPE,

Line 1486: attribute7 QP_LIST_LINES.attribute7%TYPE,

1482: attribute3 QP_LIST_LINES.attribute3%TYPE,
1483: attribute4 QP_LIST_LINES.attribute4%TYPE,
1484: attribute5 QP_LIST_LINES.attribute5%TYPE,
1485: attribute6 QP_LIST_LINES.attribute6%TYPE,
1486: attribute7 QP_LIST_LINES.attribute7%TYPE,
1487: attribute8 QP_LIST_LINES.attribute8%TYPE,
1488: attribute9 QP_LIST_LINES.attribute9%TYPE,
1489: attribute10 QP_LIST_LINES.attribute10%TYPE,
1490: attribute11 QP_LIST_LINES.attribute11%TYPE,

Line 1487: attribute8 QP_LIST_LINES.attribute8%TYPE,

1483: attribute4 QP_LIST_LINES.attribute4%TYPE,
1484: attribute5 QP_LIST_LINES.attribute5%TYPE,
1485: attribute6 QP_LIST_LINES.attribute6%TYPE,
1486: attribute7 QP_LIST_LINES.attribute7%TYPE,
1487: attribute8 QP_LIST_LINES.attribute8%TYPE,
1488: attribute9 QP_LIST_LINES.attribute9%TYPE,
1489: attribute10 QP_LIST_LINES.attribute10%TYPE,
1490: attribute11 QP_LIST_LINES.attribute11%TYPE,
1491: attribute12 QP_LIST_LINES.attribute12%TYPE,

Line 1488: attribute9 QP_LIST_LINES.attribute9%TYPE,

1484: attribute5 QP_LIST_LINES.attribute5%TYPE,
1485: attribute6 QP_LIST_LINES.attribute6%TYPE,
1486: attribute7 QP_LIST_LINES.attribute7%TYPE,
1487: attribute8 QP_LIST_LINES.attribute8%TYPE,
1488: attribute9 QP_LIST_LINES.attribute9%TYPE,
1489: attribute10 QP_LIST_LINES.attribute10%TYPE,
1490: attribute11 QP_LIST_LINES.attribute11%TYPE,
1491: attribute12 QP_LIST_LINES.attribute12%TYPE,
1492: attribute13 QP_LIST_LINES.attribute13%TYPE,

Line 1489: attribute10 QP_LIST_LINES.attribute10%TYPE,

1485: attribute6 QP_LIST_LINES.attribute6%TYPE,
1486: attribute7 QP_LIST_LINES.attribute7%TYPE,
1487: attribute8 QP_LIST_LINES.attribute8%TYPE,
1488: attribute9 QP_LIST_LINES.attribute9%TYPE,
1489: attribute10 QP_LIST_LINES.attribute10%TYPE,
1490: attribute11 QP_LIST_LINES.attribute11%TYPE,
1491: attribute12 QP_LIST_LINES.attribute12%TYPE,
1492: attribute13 QP_LIST_LINES.attribute13%TYPE,
1493: attribute14 QP_LIST_LINES.attribute14%TYPE,

Line 1490: attribute11 QP_LIST_LINES.attribute11%TYPE,

1486: attribute7 QP_LIST_LINES.attribute7%TYPE,
1487: attribute8 QP_LIST_LINES.attribute8%TYPE,
1488: attribute9 QP_LIST_LINES.attribute9%TYPE,
1489: attribute10 QP_LIST_LINES.attribute10%TYPE,
1490: attribute11 QP_LIST_LINES.attribute11%TYPE,
1491: attribute12 QP_LIST_LINES.attribute12%TYPE,
1492: attribute13 QP_LIST_LINES.attribute13%TYPE,
1493: attribute14 QP_LIST_LINES.attribute14%TYPE,
1494: attribute15 QP_LIST_LINES.attribute15%TYPE,

Line 1491: attribute12 QP_LIST_LINES.attribute12%TYPE,

1487: attribute8 QP_LIST_LINES.attribute8%TYPE,
1488: attribute9 QP_LIST_LINES.attribute9%TYPE,
1489: attribute10 QP_LIST_LINES.attribute10%TYPE,
1490: attribute11 QP_LIST_LINES.attribute11%TYPE,
1491: attribute12 QP_LIST_LINES.attribute12%TYPE,
1492: attribute13 QP_LIST_LINES.attribute13%TYPE,
1493: attribute14 QP_LIST_LINES.attribute14%TYPE,
1494: attribute15 QP_LIST_LINES.attribute15%TYPE,
1495: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,

Line 1492: attribute13 QP_LIST_LINES.attribute13%TYPE,

1488: attribute9 QP_LIST_LINES.attribute9%TYPE,
1489: attribute10 QP_LIST_LINES.attribute10%TYPE,
1490: attribute11 QP_LIST_LINES.attribute11%TYPE,
1491: attribute12 QP_LIST_LINES.attribute12%TYPE,
1492: attribute13 QP_LIST_LINES.attribute13%TYPE,
1493: attribute14 QP_LIST_LINES.attribute14%TYPE,
1494: attribute15 QP_LIST_LINES.attribute15%TYPE,
1495: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
1496: percent_price QP_LIST_LINES.percent_price%TYPE,

Line 1493: attribute14 QP_LIST_LINES.attribute14%TYPE,

1489: attribute10 QP_LIST_LINES.attribute10%TYPE,
1490: attribute11 QP_LIST_LINES.attribute11%TYPE,
1491: attribute12 QP_LIST_LINES.attribute12%TYPE,
1492: attribute13 QP_LIST_LINES.attribute13%TYPE,
1493: attribute14 QP_LIST_LINES.attribute14%TYPE,
1494: attribute15 QP_LIST_LINES.attribute15%TYPE,
1495: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
1496: percent_price QP_LIST_LINES.percent_price%TYPE,
1497: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,

Line 1494: attribute15 QP_LIST_LINES.attribute15%TYPE,

1490: attribute11 QP_LIST_LINES.attribute11%TYPE,
1491: attribute12 QP_LIST_LINES.attribute12%TYPE,
1492: attribute13 QP_LIST_LINES.attribute13%TYPE,
1493: attribute14 QP_LIST_LINES.attribute14%TYPE,
1494: attribute15 QP_LIST_LINES.attribute15%TYPE,
1495: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
1496: percent_price QP_LIST_LINES.percent_price%TYPE,
1497: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
1498: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,

Line 1495: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,

1491: attribute12 QP_LIST_LINES.attribute12%TYPE,
1492: attribute13 QP_LIST_LINES.attribute13%TYPE,
1493: attribute14 QP_LIST_LINES.attribute14%TYPE,
1494: attribute15 QP_LIST_LINES.attribute15%TYPE,
1495: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
1496: percent_price QP_LIST_LINES.percent_price%TYPE,
1497: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
1498: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
1499: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,

Line 1496: percent_price QP_LIST_LINES.percent_price%TYPE,

1492: attribute13 QP_LIST_LINES.attribute13%TYPE,
1493: attribute14 QP_LIST_LINES.attribute14%TYPE,
1494: attribute15 QP_LIST_LINES.attribute15%TYPE,
1495: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
1496: percent_price QP_LIST_LINES.percent_price%TYPE,
1497: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
1498: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
1499: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
1500: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,

Line 1497: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,

1493: attribute14 QP_LIST_LINES.attribute14%TYPE,
1494: attribute15 QP_LIST_LINES.attribute15%TYPE,
1495: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
1496: percent_price QP_LIST_LINES.percent_price%TYPE,
1497: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
1498: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
1499: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
1500: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
1501: operand QP_LIST_LINES.operand%TYPE,

Line 1498: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,

1494: attribute15 QP_LIST_LINES.attribute15%TYPE,
1495: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
1496: percent_price QP_LIST_LINES.percent_price%TYPE,
1497: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
1498: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
1499: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
1500: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
1501: operand QP_LIST_LINES.operand%TYPE,
1502: override_flag QP_LIST_LINES.override_flag%TYPE,

Line 1499: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,

1495: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
1496: percent_price QP_LIST_LINES.percent_price%TYPE,
1497: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
1498: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
1499: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
1500: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
1501: operand QP_LIST_LINES.operand%TYPE,
1502: override_flag QP_LIST_LINES.override_flag%TYPE,
1503: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,

Line 1500: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,

1496: percent_price QP_LIST_LINES.percent_price%TYPE,
1497: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
1498: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
1499: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
1500: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
1501: operand QP_LIST_LINES.operand%TYPE,
1502: override_flag QP_LIST_LINES.override_flag%TYPE,
1503: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
1504: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,

Line 1501: operand QP_LIST_LINES.operand%TYPE,

1497: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
1498: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
1499: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
1500: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
1501: operand QP_LIST_LINES.operand%TYPE,
1502: override_flag QP_LIST_LINES.override_flag%TYPE,
1503: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
1504: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
1505: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,

Line 1502: override_flag QP_LIST_LINES.override_flag%TYPE,

1498: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
1499: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
1500: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
1501: operand QP_LIST_LINES.operand%TYPE,
1502: override_flag QP_LIST_LINES.override_flag%TYPE,
1503: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
1504: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
1505: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
1506: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,

Line 1503: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,

1499: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
1500: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
1501: operand QP_LIST_LINES.operand%TYPE,
1502: override_flag QP_LIST_LINES.override_flag%TYPE,
1503: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
1504: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
1505: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
1506: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
1507: start_date_active QP_LIST_LINES.start_date_active%TYPE,

Line 1504: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,

1500: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
1501: operand QP_LIST_LINES.operand%TYPE,
1502: override_flag QP_LIST_LINES.override_flag%TYPE,
1503: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
1504: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
1505: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
1506: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
1507: start_date_active QP_LIST_LINES.start_date_active%TYPE,
1508: end_date_active QP_LIST_LINES.end_date_active%TYPE,

Line 1505: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,

1501: operand QP_LIST_LINES.operand%TYPE,
1502: override_flag QP_LIST_LINES.override_flag%TYPE,
1503: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
1504: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
1505: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
1506: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
1507: start_date_active QP_LIST_LINES.start_date_active%TYPE,
1508: end_date_active QP_LIST_LINES.end_date_active%TYPE,
1509: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,

Line 1506: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,

1502: override_flag QP_LIST_LINES.override_flag%TYPE,
1503: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
1504: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
1505: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
1506: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
1507: start_date_active QP_LIST_LINES.start_date_active%TYPE,
1508: end_date_active QP_LIST_LINES.end_date_active%TYPE,
1509: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
1510: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,

Line 1507: start_date_active QP_LIST_LINES.start_date_active%TYPE,

1503: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
1504: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
1505: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
1506: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
1507: start_date_active QP_LIST_LINES.start_date_active%TYPE,
1508: end_date_active QP_LIST_LINES.end_date_active%TYPE,
1509: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
1510: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
1511: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,

Line 1508: end_date_active QP_LIST_LINES.end_date_active%TYPE,

1504: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
1505: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
1506: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
1507: start_date_active QP_LIST_LINES.start_date_active%TYPE,
1508: end_date_active QP_LIST_LINES.end_date_active%TYPE,
1509: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
1510: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
1511: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
1512: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,

Line 1509: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,

1505: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
1506: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
1507: start_date_active QP_LIST_LINES.start_date_active%TYPE,
1508: end_date_active QP_LIST_LINES.end_date_active%TYPE,
1509: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
1510: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
1511: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
1512: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
1513: list_line_no QP_LIST_LINES.list_line_no%TYPE,

Line 1510: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,

1506: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
1507: start_date_active QP_LIST_LINES.start_date_active%TYPE,
1508: end_date_active QP_LIST_LINES.end_date_active%TYPE,
1509: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
1510: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
1511: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
1512: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
1513: list_line_no QP_LIST_LINES.list_line_no%TYPE,
1514: product_precedence QP_LIST_LINES.product_precedence%TYPE,

Line 1511: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,

1507: start_date_active QP_LIST_LINES.start_date_active%TYPE,
1508: end_date_active QP_LIST_LINES.end_date_active%TYPE,
1509: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
1510: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
1511: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
1512: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
1513: list_line_no QP_LIST_LINES.list_line_no%TYPE,
1514: product_precedence QP_LIST_LINES.product_precedence%TYPE,
1515: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,

Line 1512: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,

1508: end_date_active QP_LIST_LINES.end_date_active%TYPE,
1509: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
1510: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
1511: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
1512: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
1513: list_line_no QP_LIST_LINES.list_line_no%TYPE,
1514: product_precedence QP_LIST_LINES.product_precedence%TYPE,
1515: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
1516: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,

Line 1513: list_line_no QP_LIST_LINES.list_line_no%TYPE,

1509: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
1510: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
1511: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
1512: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
1513: list_line_no QP_LIST_LINES.list_line_no%TYPE,
1514: product_precedence QP_LIST_LINES.product_precedence%TYPE,
1515: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
1516: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
1517: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,

Line 1514: product_precedence QP_LIST_LINES.product_precedence%TYPE,

1510: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
1511: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
1512: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
1513: list_line_no QP_LIST_LINES.list_line_no%TYPE,
1514: product_precedence QP_LIST_LINES.product_precedence%TYPE,
1515: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
1516: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
1517: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
1518: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,

Line 1515: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,

1511: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
1512: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
1513: list_line_no QP_LIST_LINES.list_line_no%TYPE,
1514: product_precedence QP_LIST_LINES.product_precedence%TYPE,
1515: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
1516: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
1517: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
1518: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
1519: expiration_date QP_LIST_LINES.expiration_date%TYPE,

Line 1516: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,

1512: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
1513: list_line_no QP_LIST_LINES.list_line_no%TYPE,
1514: product_precedence QP_LIST_LINES.product_precedence%TYPE,
1515: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
1516: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
1517: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
1518: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
1519: expiration_date QP_LIST_LINES.expiration_date%TYPE,
1520: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,

Line 1517: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,

1513: list_line_no QP_LIST_LINES.list_line_no%TYPE,
1514: product_precedence QP_LIST_LINES.product_precedence%TYPE,
1515: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
1516: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
1517: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
1518: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
1519: expiration_date QP_LIST_LINES.expiration_date%TYPE,
1520: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
1521: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,

Line 1518: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,

1514: product_precedence QP_LIST_LINES.product_precedence%TYPE,
1515: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
1516: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
1517: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
1518: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
1519: expiration_date QP_LIST_LINES.expiration_date%TYPE,
1520: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
1521: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
1522: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,

Line 1519: expiration_date QP_LIST_LINES.expiration_date%TYPE,

1515: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
1516: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
1517: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
1518: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
1519: expiration_date QP_LIST_LINES.expiration_date%TYPE,
1520: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
1521: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
1522: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
1523: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,

Line 1520: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,

1516: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
1517: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
1518: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
1519: expiration_date QP_LIST_LINES.expiration_date%TYPE,
1520: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
1521: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
1522: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
1523: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
1524: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,

Line 1521: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,

1517: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
1518: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
1519: expiration_date QP_LIST_LINES.expiration_date%TYPE,
1520: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
1521: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
1522: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
1523: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
1524: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
1525: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,

Line 1522: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,

1518: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
1519: expiration_date QP_LIST_LINES.expiration_date%TYPE,
1520: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
1521: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
1522: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
1523: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
1524: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
1525: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
1526: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,

Line 1523: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,

1519: expiration_date QP_LIST_LINES.expiration_date%TYPE,
1520: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
1521: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
1522: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
1523: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
1524: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
1525: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
1526: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
1527: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,

Line 1524: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,

1520: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
1521: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
1522: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
1523: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
1524: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
1525: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
1526: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
1527: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
1528: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,

Line 1525: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,

1521: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
1522: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
1523: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
1524: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
1525: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
1526: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
1527: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
1528: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
1529: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,

Line 1526: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,

1522: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
1523: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
1524: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
1525: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
1526: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
1527: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
1528: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
1529: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
1530: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,

Line 1527: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,

1523: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
1524: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
1525: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
1526: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
1527: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
1528: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
1529: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
1530: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
1531: recurring_value QP_LIST_LINES.recurring_value%TYPE, -- block pricing

Line 1528: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,

1524: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
1525: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
1526: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
1527: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
1528: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
1529: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
1530: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
1531: recurring_value QP_LIST_LINES.recurring_value%TYPE, -- block pricing
1532: continuous_price_break_flag QP_LIST_LINES.continuous_price_break_flag%TYPE

Line 1529: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,

1525: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
1526: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
1527: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
1528: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
1529: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
1530: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
1531: recurring_value QP_LIST_LINES.recurring_value%TYPE, -- block pricing
1532: continuous_price_break_flag QP_LIST_LINES.continuous_price_break_flag%TYPE
1533: --Continuous Price Breaks

Line 1530: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,

1526: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
1527: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
1528: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
1529: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
1530: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
1531: recurring_value QP_LIST_LINES.recurring_value%TYPE, -- block pricing
1532: continuous_price_break_flag QP_LIST_LINES.continuous_price_break_flag%TYPE
1533: --Continuous Price Breaks
1534: );

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

1527: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
1528: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
1529: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
1530: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
1531: recurring_value QP_LIST_LINES.recurring_value%TYPE, -- block pricing
1532: continuous_price_break_flag QP_LIST_LINES.continuous_price_break_flag%TYPE
1533: --Continuous Price Breaks
1534: );
1535:

Line 1532: continuous_price_break_flag QP_LIST_LINES.continuous_price_break_flag%TYPE

1528: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
1529: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
1530: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
1531: recurring_value QP_LIST_LINES.recurring_value%TYPE, -- block pricing
1532: continuous_price_break_flag QP_LIST_LINES.continuous_price_break_flag%TYPE
1533: --Continuous Price Breaks
1534: );
1535:
1536: l_non_cont_pbh_id_tbl QP_UTIL.price_brk_attr_val_tab; --Continuous Price Breaks

Line 1543: l_qp_list_lines_rec qp_list_lines_rec;

1539:
1540: l_mapping_tbl mapping_tbl;
1541:
1542: l_select_stmt VARCHAR2(9000);
1543: l_qp_list_lines_rec qp_list_lines_rec;
1544: l_context VARCHAR2(30);
1545: l_attribute VARCHAR2(30);
1546:
1547: l_exists NUMBER := 0;

Line 1564: qp_list_lines_cv lines_cur_typ;

1560: l_qual_attr_value_from_number NUMBER := NULL;
1561: l_qual_attr_value_to_number NUMBER := NULL;
1562:
1563: TYPE lines_cur_typ IS REF CURSOR;
1564: qp_list_lines_cv lines_cur_typ;
1565:
1566: CURSOR qp_pricing_attributes_cur(p_from_list_line_id NUMBER)
1567: IS
1568: SELECT *

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

2027: l_qp_qualifiers_rec.header_quals_exist_flag,
2028: l_qp_qualifiers_rec.qualify_hier_descendents_flag -- Added for TCA
2029: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2030: ,to_char(l_new_qualifier_id)
2031: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_qp_qualifiers_rec.list_line_id)
2032: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_qp_qualifiers_rec.list_header_id)
2033: );
2034:
2035:

Line 2141: FROM qp_list_lines q

2137: q.qualification_ind,
2138: q.recurring_value, -- block pricing
2139: q.continuous_price_break_flag --Continuous Price Breaks
2140:
2141: FROM qp_list_lines q
2142: WHERE q.list_header_id = :frm
2143: AND (q.end_date_active IS NULL OR trunc(q.end_date_active) >= trunc(sysdate)) --Modified by dhgupta for 2100785
2144: AND q.list_line_id IN
2145: (SELECT DISTINCT a.list_line_id

Line 2332: OPEN qp_list_lines_cv FOR l_select_stmt USING p_from_list_header_id;

2328: -- debug
2329: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||l_select_stmt);
2330:
2331: IF (p_category_id is null) and (p_category_set_id is null) then
2332: OPEN qp_list_lines_cv FOR l_select_stmt USING p_from_list_header_id;
2333: end if;
2334: IF ( nvl(p_category_id, 0) <> 0 AND nvl(p_category_set_id, 0) <> 0) THEN
2335: 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;
2336: END IF;

Line 2335: 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;

2331: IF (p_category_id is null) and (p_category_set_id is null) then
2332: OPEN qp_list_lines_cv FOR l_select_stmt USING p_from_list_header_id;
2333: end if;
2334: IF ( nvl(p_category_id, 0) <> 0 AND nvl(p_category_set_id, 0) <> 0) THEN
2335: 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;
2336: END IF;
2337: IF ( nvl(p_category_id, 0) = 0 AND nvl(p_category_set_id, 0) <> 0) THEN
2338: OPEN qp_list_lines_cv FOR l_select_stmt USING p_from_list_header_id,p_category_set_id;
2339: END IF;

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

2334: IF ( nvl(p_category_id, 0) <> 0 AND nvl(p_category_set_id, 0) <> 0) THEN
2335: 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;
2336: END IF;
2337: IF ( nvl(p_category_id, 0) = 0 AND nvl(p_category_set_id, 0) <> 0) THEN
2338: OPEN qp_list_lines_cv FOR l_select_stmt USING p_from_list_header_id,p_category_set_id;
2339: END IF;
2340: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'opened list_lines cursor');
2341:
2342: --This is the fetch loop

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

2343: LOOP
2344: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'inside loop ');
2345:
2346: --Insert each fetched record(Price List Line without Discount Line)
2347: --of the from_price_list into qp_list_lines(for the New Price List)
2348: --provided the segment values of the lines lie in the input ranges.
2349:
2350: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
2351: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'after fetch ');

Line 2350: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;

2346: --Insert each fetched record(Price List Line without Discount Line)
2347: --of the from_price_list into qp_list_lines(for the New Price List)
2348: --provided the segment values of the lines lie in the input ranges.
2349:
2350: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
2351: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'after fetch ');
2352: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2353:
2354: EXIT WHEN qp_list_lines_cv%NOTFOUND;

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

2348: --provided the segment values of the lines lie in the input ranges.
2349:
2350: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
2351: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'after fetch ');
2352: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2353:
2354: EXIT WHEN qp_list_lines_cv%NOTFOUND;
2355: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2356:

Line 2354: EXIT WHEN qp_list_lines_cv%NOTFOUND;

2350: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
2351: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'after fetch ');
2352: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2353:
2354: EXIT WHEN qp_list_lines_cv%NOTFOUND;
2355: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2356:
2357:
2358: /* Added for 3067774.When price listr line is end dated,its related lines e.g. child lines

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

2351: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'after fetch ');
2352: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2353:
2354: EXIT WHEN qp_list_lines_cv%NOTFOUND;
2355: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2356:
2357:
2358: /* Added for 3067774.When price listr line is end dated,its related lines e.g. child lines
2359: are still active. Cursor qp_list_lines_cv selects all active lines, therefore,

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

2355: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2356:
2357:
2358: /* Added for 3067774.When price listr line is end dated,its related lines e.g. child lines
2359: are still active. Cursor qp_list_lines_cv selects all active lines, therefore,
2360: orphaned child lines are also copied to new price list.The following logic
2361: excludes such orphaned lines from being copied. */
2362:
2363:

Line 2368: where to_rltd_modifier_id=l_qp_list_lines_rec.list_line_id;

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

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

2374: If l_line_id is null then
2375: insert_flag :='Y';
2376: Else
2377: Begin
2378: select count(*) into l_cnt from qp_list_lines where list_line_id=l_line_id
2379: AND ((end_date_active IS NULL) OR (trunc(end_date_active) >= trunc(sysdate)));
2380: Exception
2381: when no_data_found then
2382: l_cnt:=0;

Line 2397: SELECT qp_list_lines_s.nextval

2393:
2394:
2395: -- Get next list_line_id
2396:
2397: SELECT qp_list_lines_s.nextval
2398: INTO l_new_list_line_id
2399: FROM dual;
2400:
2401: INSERT INTO qp_list_lines

Line 2401: INSERT INTO qp_list_lines

2397: SELECT qp_list_lines_s.nextval
2398: INTO l_new_list_line_id
2399: FROM dual;
2400:
2401: INSERT INTO qp_list_lines
2402: (
2403: list_line_id,
2404: creation_date,
2405: created_by,

Line 2501: l_qp_list_lines_rec.list_line_type_code,

2497: l_conc_program_id,
2498: sysdate,
2499: l_conc_request_id,
2500: l_new_list_header_id,
2501: l_qp_list_lines_rec.list_line_type_code,
2502: DECODE (p_effective_dates_flag,
2503: 'Y', l_qp_list_lines_rec.start_date_active,
2504: NULL), /* If flag='Y', retain start date from copied line */
2505: /* else default start date */

Line 2503: 'Y', l_qp_list_lines_rec.start_date_active,

2499: l_conc_request_id,
2500: l_new_list_header_id,
2501: l_qp_list_lines_rec.list_line_type_code,
2502: DECODE (p_effective_dates_flag,
2503: 'Y', l_qp_list_lines_rec.start_date_active,
2504: NULL), /* If flag='Y', retain start date from copied line */
2505: /* else default start date */
2506: DECODE (p_effective_dates_flag,
2507: 'Y', l_qp_list_lines_rec.end_date_active,

Line 2507: 'Y', l_qp_list_lines_rec.end_date_active,

2503: 'Y', l_qp_list_lines_rec.start_date_active,
2504: NULL), /* If flag='Y', retain start date from copied line */
2505: /* else default start date */
2506: DECODE (p_effective_dates_flag,
2507: 'Y', l_qp_list_lines_rec.end_date_active,
2508: NULL), /* If flag='Y', retain end date from copied line */
2509: /* else default end date */
2510: l_qp_list_lines_rec.automatic_flag,
2511: l_qp_list_lines_rec.modifier_level_code,

Line 2510: l_qp_list_lines_rec.automatic_flag,

2506: DECODE (p_effective_dates_flag,
2507: 'Y', l_qp_list_lines_rec.end_date_active,
2508: NULL), /* If flag='Y', retain end date from copied line */
2509: /* else default end date */
2510: l_qp_list_lines_rec.automatic_flag,
2511: l_qp_list_lines_rec.modifier_level_code,
2512: l_qp_list_lines_rec.list_price,
2513: l_qp_list_lines_rec.primary_uom_flag,
2514: l_qp_list_lines_rec.inventory_item_id,

Line 2511: l_qp_list_lines_rec.modifier_level_code,

2507: 'Y', l_qp_list_lines_rec.end_date_active,
2508: NULL), /* If flag='Y', retain end date from copied line */
2509: /* else default end date */
2510: l_qp_list_lines_rec.automatic_flag,
2511: l_qp_list_lines_rec.modifier_level_code,
2512: l_qp_list_lines_rec.list_price,
2513: l_qp_list_lines_rec.primary_uom_flag,
2514: l_qp_list_lines_rec.inventory_item_id,
2515: l_qp_list_lines_rec.organization_id,

Line 2512: l_qp_list_lines_rec.list_price,

2508: NULL), /* If flag='Y', retain end date from copied line */
2509: /* else default end date */
2510: l_qp_list_lines_rec.automatic_flag,
2511: l_qp_list_lines_rec.modifier_level_code,
2512: l_qp_list_lines_rec.list_price,
2513: l_qp_list_lines_rec.primary_uom_flag,
2514: l_qp_list_lines_rec.inventory_item_id,
2515: l_qp_list_lines_rec.organization_id,
2516: l_qp_list_lines_rec.related_item_id,

Line 2513: l_qp_list_lines_rec.primary_uom_flag,

2509: /* else default end date */
2510: l_qp_list_lines_rec.automatic_flag,
2511: l_qp_list_lines_rec.modifier_level_code,
2512: l_qp_list_lines_rec.list_price,
2513: l_qp_list_lines_rec.primary_uom_flag,
2514: l_qp_list_lines_rec.inventory_item_id,
2515: l_qp_list_lines_rec.organization_id,
2516: l_qp_list_lines_rec.related_item_id,
2517: l_qp_list_lines_rec.relationship_type_id,

Line 2514: l_qp_list_lines_rec.inventory_item_id,

2510: l_qp_list_lines_rec.automatic_flag,
2511: l_qp_list_lines_rec.modifier_level_code,
2512: l_qp_list_lines_rec.list_price,
2513: l_qp_list_lines_rec.primary_uom_flag,
2514: l_qp_list_lines_rec.inventory_item_id,
2515: l_qp_list_lines_rec.organization_id,
2516: l_qp_list_lines_rec.related_item_id,
2517: l_qp_list_lines_rec.relationship_type_id,
2518: l_qp_list_lines_rec.substitution_context,

Line 2515: l_qp_list_lines_rec.organization_id,

2511: l_qp_list_lines_rec.modifier_level_code,
2512: l_qp_list_lines_rec.list_price,
2513: l_qp_list_lines_rec.primary_uom_flag,
2514: l_qp_list_lines_rec.inventory_item_id,
2515: l_qp_list_lines_rec.organization_id,
2516: l_qp_list_lines_rec.related_item_id,
2517: l_qp_list_lines_rec.relationship_type_id,
2518: l_qp_list_lines_rec.substitution_context,
2519: l_qp_list_lines_rec.substitution_attribute,

Line 2516: l_qp_list_lines_rec.related_item_id,

2512: l_qp_list_lines_rec.list_price,
2513: l_qp_list_lines_rec.primary_uom_flag,
2514: l_qp_list_lines_rec.inventory_item_id,
2515: l_qp_list_lines_rec.organization_id,
2516: l_qp_list_lines_rec.related_item_id,
2517: l_qp_list_lines_rec.relationship_type_id,
2518: l_qp_list_lines_rec.substitution_context,
2519: l_qp_list_lines_rec.substitution_attribute,
2520: l_qp_list_lines_rec.substitution_value,

Line 2517: l_qp_list_lines_rec.relationship_type_id,

2513: l_qp_list_lines_rec.primary_uom_flag,
2514: l_qp_list_lines_rec.inventory_item_id,
2515: l_qp_list_lines_rec.organization_id,
2516: l_qp_list_lines_rec.related_item_id,
2517: l_qp_list_lines_rec.relationship_type_id,
2518: l_qp_list_lines_rec.substitution_context,
2519: l_qp_list_lines_rec.substitution_attribute,
2520: l_qp_list_lines_rec.substitution_value,
2521: l_qp_list_lines_rec.revision,

Line 2518: l_qp_list_lines_rec.substitution_context,

2514: l_qp_list_lines_rec.inventory_item_id,
2515: l_qp_list_lines_rec.organization_id,
2516: l_qp_list_lines_rec.related_item_id,
2517: l_qp_list_lines_rec.relationship_type_id,
2518: l_qp_list_lines_rec.substitution_context,
2519: l_qp_list_lines_rec.substitution_attribute,
2520: l_qp_list_lines_rec.substitution_value,
2521: l_qp_list_lines_rec.revision,
2522: l_qp_list_lines_rec.revision_date,

Line 2519: l_qp_list_lines_rec.substitution_attribute,

2515: l_qp_list_lines_rec.organization_id,
2516: l_qp_list_lines_rec.related_item_id,
2517: l_qp_list_lines_rec.relationship_type_id,
2518: l_qp_list_lines_rec.substitution_context,
2519: l_qp_list_lines_rec.substitution_attribute,
2520: l_qp_list_lines_rec.substitution_value,
2521: l_qp_list_lines_rec.revision,
2522: l_qp_list_lines_rec.revision_date,
2523: l_qp_list_lines_rec.revision_reason_code,

Line 2520: l_qp_list_lines_rec.substitution_value,

2516: l_qp_list_lines_rec.related_item_id,
2517: l_qp_list_lines_rec.relationship_type_id,
2518: l_qp_list_lines_rec.substitution_context,
2519: l_qp_list_lines_rec.substitution_attribute,
2520: l_qp_list_lines_rec.substitution_value,
2521: l_qp_list_lines_rec.revision,
2522: l_qp_list_lines_rec.revision_date,
2523: l_qp_list_lines_rec.revision_reason_code,
2524: l_qp_list_lines_rec.context,

Line 2521: l_qp_list_lines_rec.revision,

2517: l_qp_list_lines_rec.relationship_type_id,
2518: l_qp_list_lines_rec.substitution_context,
2519: l_qp_list_lines_rec.substitution_attribute,
2520: l_qp_list_lines_rec.substitution_value,
2521: l_qp_list_lines_rec.revision,
2522: l_qp_list_lines_rec.revision_date,
2523: l_qp_list_lines_rec.revision_reason_code,
2524: l_qp_list_lines_rec.context,
2525: l_qp_list_lines_rec.attribute1,

Line 2522: l_qp_list_lines_rec.revision_date,

2518: l_qp_list_lines_rec.substitution_context,
2519: l_qp_list_lines_rec.substitution_attribute,
2520: l_qp_list_lines_rec.substitution_value,
2521: l_qp_list_lines_rec.revision,
2522: l_qp_list_lines_rec.revision_date,
2523: l_qp_list_lines_rec.revision_reason_code,
2524: l_qp_list_lines_rec.context,
2525: l_qp_list_lines_rec.attribute1,
2526: l_qp_list_lines_rec.attribute2,

Line 2523: l_qp_list_lines_rec.revision_reason_code,

2519: l_qp_list_lines_rec.substitution_attribute,
2520: l_qp_list_lines_rec.substitution_value,
2521: l_qp_list_lines_rec.revision,
2522: l_qp_list_lines_rec.revision_date,
2523: l_qp_list_lines_rec.revision_reason_code,
2524: l_qp_list_lines_rec.context,
2525: l_qp_list_lines_rec.attribute1,
2526: l_qp_list_lines_rec.attribute2,
2527: l_qp_list_lines_rec.comments,

Line 2524: l_qp_list_lines_rec.context,

2520: l_qp_list_lines_rec.substitution_value,
2521: l_qp_list_lines_rec.revision,
2522: l_qp_list_lines_rec.revision_date,
2523: l_qp_list_lines_rec.revision_reason_code,
2524: l_qp_list_lines_rec.context,
2525: l_qp_list_lines_rec.attribute1,
2526: l_qp_list_lines_rec.attribute2,
2527: l_qp_list_lines_rec.comments,
2528: l_qp_list_lines_rec.attribute3,

Line 2525: l_qp_list_lines_rec.attribute1,

2521: l_qp_list_lines_rec.revision,
2522: l_qp_list_lines_rec.revision_date,
2523: l_qp_list_lines_rec.revision_reason_code,
2524: l_qp_list_lines_rec.context,
2525: l_qp_list_lines_rec.attribute1,
2526: l_qp_list_lines_rec.attribute2,
2527: l_qp_list_lines_rec.comments,
2528: l_qp_list_lines_rec.attribute3,
2529: l_qp_list_lines_rec.attribute4,

Line 2526: l_qp_list_lines_rec.attribute2,

2522: l_qp_list_lines_rec.revision_date,
2523: l_qp_list_lines_rec.revision_reason_code,
2524: l_qp_list_lines_rec.context,
2525: l_qp_list_lines_rec.attribute1,
2526: l_qp_list_lines_rec.attribute2,
2527: l_qp_list_lines_rec.comments,
2528: l_qp_list_lines_rec.attribute3,
2529: l_qp_list_lines_rec.attribute4,
2530: l_qp_list_lines_rec.attribute5,

Line 2527: l_qp_list_lines_rec.comments,

2523: l_qp_list_lines_rec.revision_reason_code,
2524: l_qp_list_lines_rec.context,
2525: l_qp_list_lines_rec.attribute1,
2526: l_qp_list_lines_rec.attribute2,
2527: l_qp_list_lines_rec.comments,
2528: l_qp_list_lines_rec.attribute3,
2529: l_qp_list_lines_rec.attribute4,
2530: l_qp_list_lines_rec.attribute5,
2531: l_qp_list_lines_rec.attribute6,

Line 2528: l_qp_list_lines_rec.attribute3,

2524: l_qp_list_lines_rec.context,
2525: l_qp_list_lines_rec.attribute1,
2526: l_qp_list_lines_rec.attribute2,
2527: l_qp_list_lines_rec.comments,
2528: l_qp_list_lines_rec.attribute3,
2529: l_qp_list_lines_rec.attribute4,
2530: l_qp_list_lines_rec.attribute5,
2531: l_qp_list_lines_rec.attribute6,
2532: l_qp_list_lines_rec.attribute7,

Line 2529: l_qp_list_lines_rec.attribute4,

2525: l_qp_list_lines_rec.attribute1,
2526: l_qp_list_lines_rec.attribute2,
2527: l_qp_list_lines_rec.comments,
2528: l_qp_list_lines_rec.attribute3,
2529: l_qp_list_lines_rec.attribute4,
2530: l_qp_list_lines_rec.attribute5,
2531: l_qp_list_lines_rec.attribute6,
2532: l_qp_list_lines_rec.attribute7,
2533: l_qp_list_lines_rec.attribute8,

Line 2530: l_qp_list_lines_rec.attribute5,

2526: l_qp_list_lines_rec.attribute2,
2527: l_qp_list_lines_rec.comments,
2528: l_qp_list_lines_rec.attribute3,
2529: l_qp_list_lines_rec.attribute4,
2530: l_qp_list_lines_rec.attribute5,
2531: l_qp_list_lines_rec.attribute6,
2532: l_qp_list_lines_rec.attribute7,
2533: l_qp_list_lines_rec.attribute8,
2534: l_qp_list_lines_rec.attribute9,

Line 2531: l_qp_list_lines_rec.attribute6,

2527: l_qp_list_lines_rec.comments,
2528: l_qp_list_lines_rec.attribute3,
2529: l_qp_list_lines_rec.attribute4,
2530: l_qp_list_lines_rec.attribute5,
2531: l_qp_list_lines_rec.attribute6,
2532: l_qp_list_lines_rec.attribute7,
2533: l_qp_list_lines_rec.attribute8,
2534: l_qp_list_lines_rec.attribute9,
2535: l_qp_list_lines_rec.attribute10,

Line 2532: l_qp_list_lines_rec.attribute7,

2528: l_qp_list_lines_rec.attribute3,
2529: l_qp_list_lines_rec.attribute4,
2530: l_qp_list_lines_rec.attribute5,
2531: l_qp_list_lines_rec.attribute6,
2532: l_qp_list_lines_rec.attribute7,
2533: l_qp_list_lines_rec.attribute8,
2534: l_qp_list_lines_rec.attribute9,
2535: l_qp_list_lines_rec.attribute10,
2536: l_qp_list_lines_rec.attribute11,

Line 2533: l_qp_list_lines_rec.attribute8,

2529: l_qp_list_lines_rec.attribute4,
2530: l_qp_list_lines_rec.attribute5,
2531: l_qp_list_lines_rec.attribute6,
2532: l_qp_list_lines_rec.attribute7,
2533: l_qp_list_lines_rec.attribute8,
2534: l_qp_list_lines_rec.attribute9,
2535: l_qp_list_lines_rec.attribute10,
2536: l_qp_list_lines_rec.attribute11,
2537: l_qp_list_lines_rec.attribute12,

Line 2534: l_qp_list_lines_rec.attribute9,

2530: l_qp_list_lines_rec.attribute5,
2531: l_qp_list_lines_rec.attribute6,
2532: l_qp_list_lines_rec.attribute7,
2533: l_qp_list_lines_rec.attribute8,
2534: l_qp_list_lines_rec.attribute9,
2535: l_qp_list_lines_rec.attribute10,
2536: l_qp_list_lines_rec.attribute11,
2537: l_qp_list_lines_rec.attribute12,
2538: l_qp_list_lines_rec.attribute13,

Line 2535: l_qp_list_lines_rec.attribute10,

2531: l_qp_list_lines_rec.attribute6,
2532: l_qp_list_lines_rec.attribute7,
2533: l_qp_list_lines_rec.attribute8,
2534: l_qp_list_lines_rec.attribute9,
2535: l_qp_list_lines_rec.attribute10,
2536: l_qp_list_lines_rec.attribute11,
2537: l_qp_list_lines_rec.attribute12,
2538: l_qp_list_lines_rec.attribute13,
2539: l_qp_list_lines_rec.attribute14,

Line 2536: l_qp_list_lines_rec.attribute11,

2532: l_qp_list_lines_rec.attribute7,
2533: l_qp_list_lines_rec.attribute8,
2534: l_qp_list_lines_rec.attribute9,
2535: l_qp_list_lines_rec.attribute10,
2536: l_qp_list_lines_rec.attribute11,
2537: l_qp_list_lines_rec.attribute12,
2538: l_qp_list_lines_rec.attribute13,
2539: l_qp_list_lines_rec.attribute14,
2540: l_qp_list_lines_rec.attribute15,

Line 2537: l_qp_list_lines_rec.attribute12,

2533: l_qp_list_lines_rec.attribute8,
2534: l_qp_list_lines_rec.attribute9,
2535: l_qp_list_lines_rec.attribute10,
2536: l_qp_list_lines_rec.attribute11,
2537: l_qp_list_lines_rec.attribute12,
2538: l_qp_list_lines_rec.attribute13,
2539: l_qp_list_lines_rec.attribute14,
2540: l_qp_list_lines_rec.attribute15,
2541: l_qp_list_lines_rec.price_break_type_code,

Line 2538: l_qp_list_lines_rec.attribute13,

2534: l_qp_list_lines_rec.attribute9,
2535: l_qp_list_lines_rec.attribute10,
2536: l_qp_list_lines_rec.attribute11,
2537: l_qp_list_lines_rec.attribute12,
2538: l_qp_list_lines_rec.attribute13,
2539: l_qp_list_lines_rec.attribute14,
2540: l_qp_list_lines_rec.attribute15,
2541: l_qp_list_lines_rec.price_break_type_code,
2542: l_qp_list_lines_rec.percent_price,

Line 2539: l_qp_list_lines_rec.attribute14,

2535: l_qp_list_lines_rec.attribute10,
2536: l_qp_list_lines_rec.attribute11,
2537: l_qp_list_lines_rec.attribute12,
2538: l_qp_list_lines_rec.attribute13,
2539: l_qp_list_lines_rec.attribute14,
2540: l_qp_list_lines_rec.attribute15,
2541: l_qp_list_lines_rec.price_break_type_code,
2542: l_qp_list_lines_rec.percent_price,
2543: l_qp_list_lines_rec.price_by_formula_id,

Line 2540: l_qp_list_lines_rec.attribute15,

2536: l_qp_list_lines_rec.attribute11,
2537: l_qp_list_lines_rec.attribute12,
2538: l_qp_list_lines_rec.attribute13,
2539: l_qp_list_lines_rec.attribute14,
2540: l_qp_list_lines_rec.attribute15,
2541: l_qp_list_lines_rec.price_break_type_code,
2542: l_qp_list_lines_rec.percent_price,
2543: l_qp_list_lines_rec.price_by_formula_id,
2544: l_qp_list_lines_rec.number_effective_periods,

Line 2541: l_qp_list_lines_rec.price_break_type_code,

2537: l_qp_list_lines_rec.attribute12,
2538: l_qp_list_lines_rec.attribute13,
2539: l_qp_list_lines_rec.attribute14,
2540: l_qp_list_lines_rec.attribute15,
2541: l_qp_list_lines_rec.price_break_type_code,
2542: l_qp_list_lines_rec.percent_price,
2543: l_qp_list_lines_rec.price_by_formula_id,
2544: l_qp_list_lines_rec.number_effective_periods,
2545: l_qp_list_lines_rec.effective_period_uom,

Line 2542: l_qp_list_lines_rec.percent_price,

2538: l_qp_list_lines_rec.attribute13,
2539: l_qp_list_lines_rec.attribute14,
2540: l_qp_list_lines_rec.attribute15,
2541: l_qp_list_lines_rec.price_break_type_code,
2542: l_qp_list_lines_rec.percent_price,
2543: l_qp_list_lines_rec.price_by_formula_id,
2544: l_qp_list_lines_rec.number_effective_periods,
2545: l_qp_list_lines_rec.effective_period_uom,
2546: l_qp_list_lines_rec.arithmetic_operator,

Line 2543: l_qp_list_lines_rec.price_by_formula_id,

2539: l_qp_list_lines_rec.attribute14,
2540: l_qp_list_lines_rec.attribute15,
2541: l_qp_list_lines_rec.price_break_type_code,
2542: l_qp_list_lines_rec.percent_price,
2543: l_qp_list_lines_rec.price_by_formula_id,
2544: l_qp_list_lines_rec.number_effective_periods,
2545: l_qp_list_lines_rec.effective_period_uom,
2546: l_qp_list_lines_rec.arithmetic_operator,
2547: l_qp_list_lines_rec.operand,

Line 2544: l_qp_list_lines_rec.number_effective_periods,

2540: l_qp_list_lines_rec.attribute15,
2541: l_qp_list_lines_rec.price_break_type_code,
2542: l_qp_list_lines_rec.percent_price,
2543: l_qp_list_lines_rec.price_by_formula_id,
2544: l_qp_list_lines_rec.number_effective_periods,
2545: l_qp_list_lines_rec.effective_period_uom,
2546: l_qp_list_lines_rec.arithmetic_operator,
2547: l_qp_list_lines_rec.operand,
2548: l_qp_list_lines_rec.override_flag,

Line 2545: l_qp_list_lines_rec.effective_period_uom,

2541: l_qp_list_lines_rec.price_break_type_code,
2542: l_qp_list_lines_rec.percent_price,
2543: l_qp_list_lines_rec.price_by_formula_id,
2544: l_qp_list_lines_rec.number_effective_periods,
2545: l_qp_list_lines_rec.effective_period_uom,
2546: l_qp_list_lines_rec.arithmetic_operator,
2547: l_qp_list_lines_rec.operand,
2548: l_qp_list_lines_rec.override_flag,
2549: l_qp_list_lines_rec.print_on_invoice_flag,

Line 2546: l_qp_list_lines_rec.arithmetic_operator,

2542: l_qp_list_lines_rec.percent_price,
2543: l_qp_list_lines_rec.price_by_formula_id,
2544: l_qp_list_lines_rec.number_effective_periods,
2545: l_qp_list_lines_rec.effective_period_uom,
2546: l_qp_list_lines_rec.arithmetic_operator,
2547: l_qp_list_lines_rec.operand,
2548: l_qp_list_lines_rec.override_flag,
2549: l_qp_list_lines_rec.print_on_invoice_flag,
2550: l_qp_list_lines_rec.rebate_transaction_type_code,

Line 2547: l_qp_list_lines_rec.operand,

2543: l_qp_list_lines_rec.price_by_formula_id,
2544: l_qp_list_lines_rec.number_effective_periods,
2545: l_qp_list_lines_rec.effective_period_uom,
2546: l_qp_list_lines_rec.arithmetic_operator,
2547: l_qp_list_lines_rec.operand,
2548: l_qp_list_lines_rec.override_flag,
2549: l_qp_list_lines_rec.print_on_invoice_flag,
2550: l_qp_list_lines_rec.rebate_transaction_type_code,
2551: l_qp_list_lines_rec.estim_accrual_rate,

Line 2548: l_qp_list_lines_rec.override_flag,

2544: l_qp_list_lines_rec.number_effective_periods,
2545: l_qp_list_lines_rec.effective_period_uom,
2546: l_qp_list_lines_rec.arithmetic_operator,
2547: l_qp_list_lines_rec.operand,
2548: l_qp_list_lines_rec.override_flag,
2549: l_qp_list_lines_rec.print_on_invoice_flag,
2550: l_qp_list_lines_rec.rebate_transaction_type_code,
2551: l_qp_list_lines_rec.estim_accrual_rate,
2552: l_qp_list_lines_rec.generate_using_formula_id,

Line 2549: l_qp_list_lines_rec.print_on_invoice_flag,

2545: l_qp_list_lines_rec.effective_period_uom,
2546: l_qp_list_lines_rec.arithmetic_operator,
2547: l_qp_list_lines_rec.operand,
2548: l_qp_list_lines_rec.override_flag,
2549: l_qp_list_lines_rec.print_on_invoice_flag,
2550: l_qp_list_lines_rec.rebate_transaction_type_code,
2551: l_qp_list_lines_rec.estim_accrual_rate,
2552: l_qp_list_lines_rec.generate_using_formula_id,
2553: l_qp_list_lines_rec.reprice_flag,

Line 2550: l_qp_list_lines_rec.rebate_transaction_type_code,

2546: l_qp_list_lines_rec.arithmetic_operator,
2547: l_qp_list_lines_rec.operand,
2548: l_qp_list_lines_rec.override_flag,
2549: l_qp_list_lines_rec.print_on_invoice_flag,
2550: l_qp_list_lines_rec.rebate_transaction_type_code,
2551: l_qp_list_lines_rec.estim_accrual_rate,
2552: l_qp_list_lines_rec.generate_using_formula_id,
2553: l_qp_list_lines_rec.reprice_flag,
2554: l_qp_list_lines_rec.accrual_flag,

Line 2551: l_qp_list_lines_rec.estim_accrual_rate,

2547: l_qp_list_lines_rec.operand,
2548: l_qp_list_lines_rec.override_flag,
2549: l_qp_list_lines_rec.print_on_invoice_flag,
2550: l_qp_list_lines_rec.rebate_transaction_type_code,
2551: l_qp_list_lines_rec.estim_accrual_rate,
2552: l_qp_list_lines_rec.generate_using_formula_id,
2553: l_qp_list_lines_rec.reprice_flag,
2554: l_qp_list_lines_rec.accrual_flag,
2555: l_qp_list_lines_rec.pricing_group_sequence,

Line 2552: l_qp_list_lines_rec.generate_using_formula_id,

2548: l_qp_list_lines_rec.override_flag,
2549: l_qp_list_lines_rec.print_on_invoice_flag,
2550: l_qp_list_lines_rec.rebate_transaction_type_code,
2551: l_qp_list_lines_rec.estim_accrual_rate,
2552: l_qp_list_lines_rec.generate_using_formula_id,
2553: l_qp_list_lines_rec.reprice_flag,
2554: l_qp_list_lines_rec.accrual_flag,
2555: l_qp_list_lines_rec.pricing_group_sequence,
2556: l_qp_list_lines_rec.incompatibility_grp_code,

Line 2553: l_qp_list_lines_rec.reprice_flag,

2549: l_qp_list_lines_rec.print_on_invoice_flag,
2550: l_qp_list_lines_rec.rebate_transaction_type_code,
2551: l_qp_list_lines_rec.estim_accrual_rate,
2552: l_qp_list_lines_rec.generate_using_formula_id,
2553: l_qp_list_lines_rec.reprice_flag,
2554: l_qp_list_lines_rec.accrual_flag,
2555: l_qp_list_lines_rec.pricing_group_sequence,
2556: l_qp_list_lines_rec.incompatibility_grp_code,
2557: l_qp_list_lines_rec.list_line_no,

Line 2554: l_qp_list_lines_rec.accrual_flag,

2550: l_qp_list_lines_rec.rebate_transaction_type_code,
2551: l_qp_list_lines_rec.estim_accrual_rate,
2552: l_qp_list_lines_rec.generate_using_formula_id,
2553: l_qp_list_lines_rec.reprice_flag,
2554: l_qp_list_lines_rec.accrual_flag,
2555: l_qp_list_lines_rec.pricing_group_sequence,
2556: l_qp_list_lines_rec.incompatibility_grp_code,
2557: l_qp_list_lines_rec.list_line_no,
2558: l_qp_list_lines_rec.product_precedence,

Line 2555: l_qp_list_lines_rec.pricing_group_sequence,

2551: l_qp_list_lines_rec.estim_accrual_rate,
2552: l_qp_list_lines_rec.generate_using_formula_id,
2553: l_qp_list_lines_rec.reprice_flag,
2554: l_qp_list_lines_rec.accrual_flag,
2555: l_qp_list_lines_rec.pricing_group_sequence,
2556: l_qp_list_lines_rec.incompatibility_grp_code,
2557: l_qp_list_lines_rec.list_line_no,
2558: l_qp_list_lines_rec.product_precedence,
2559: l_qp_list_lines_rec.pricing_phase_id,

Line 2556: l_qp_list_lines_rec.incompatibility_grp_code,

2552: l_qp_list_lines_rec.generate_using_formula_id,
2553: l_qp_list_lines_rec.reprice_flag,
2554: l_qp_list_lines_rec.accrual_flag,
2555: l_qp_list_lines_rec.pricing_group_sequence,
2556: l_qp_list_lines_rec.incompatibility_grp_code,
2557: l_qp_list_lines_rec.list_line_no,
2558: l_qp_list_lines_rec.product_precedence,
2559: l_qp_list_lines_rec.pricing_phase_id,
2560: l_qp_list_lines_rec.expiration_period_start_date,

Line 2557: l_qp_list_lines_rec.list_line_no,

2553: l_qp_list_lines_rec.reprice_flag,
2554: l_qp_list_lines_rec.accrual_flag,
2555: l_qp_list_lines_rec.pricing_group_sequence,
2556: l_qp_list_lines_rec.incompatibility_grp_code,
2557: l_qp_list_lines_rec.list_line_no,
2558: l_qp_list_lines_rec.product_precedence,
2559: l_qp_list_lines_rec.pricing_phase_id,
2560: l_qp_list_lines_rec.expiration_period_start_date,
2561: l_qp_list_lines_rec.number_expiration_periods,

Line 2558: l_qp_list_lines_rec.product_precedence,

2554: l_qp_list_lines_rec.accrual_flag,
2555: l_qp_list_lines_rec.pricing_group_sequence,
2556: l_qp_list_lines_rec.incompatibility_grp_code,
2557: l_qp_list_lines_rec.list_line_no,
2558: l_qp_list_lines_rec.product_precedence,
2559: l_qp_list_lines_rec.pricing_phase_id,
2560: l_qp_list_lines_rec.expiration_period_start_date,
2561: l_qp_list_lines_rec.number_expiration_periods,
2562: l_qp_list_lines_rec.expiration_period_uom,

Line 2559: l_qp_list_lines_rec.pricing_phase_id,

2555: l_qp_list_lines_rec.pricing_group_sequence,
2556: l_qp_list_lines_rec.incompatibility_grp_code,
2557: l_qp_list_lines_rec.list_line_no,
2558: l_qp_list_lines_rec.product_precedence,
2559: l_qp_list_lines_rec.pricing_phase_id,
2560: l_qp_list_lines_rec.expiration_period_start_date,
2561: l_qp_list_lines_rec.number_expiration_periods,
2562: l_qp_list_lines_rec.expiration_period_uom,
2563: l_qp_list_lines_rec.expiration_date,

Line 2560: l_qp_list_lines_rec.expiration_period_start_date,

2556: l_qp_list_lines_rec.incompatibility_grp_code,
2557: l_qp_list_lines_rec.list_line_no,
2558: l_qp_list_lines_rec.product_precedence,
2559: l_qp_list_lines_rec.pricing_phase_id,
2560: l_qp_list_lines_rec.expiration_period_start_date,
2561: l_qp_list_lines_rec.number_expiration_periods,
2562: l_qp_list_lines_rec.expiration_period_uom,
2563: l_qp_list_lines_rec.expiration_date,
2564: l_qp_list_lines_rec.estim_gl_value,

Line 2561: l_qp_list_lines_rec.number_expiration_periods,

2557: l_qp_list_lines_rec.list_line_no,
2558: l_qp_list_lines_rec.product_precedence,
2559: l_qp_list_lines_rec.pricing_phase_id,
2560: l_qp_list_lines_rec.expiration_period_start_date,
2561: l_qp_list_lines_rec.number_expiration_periods,
2562: l_qp_list_lines_rec.expiration_period_uom,
2563: l_qp_list_lines_rec.expiration_date,
2564: l_qp_list_lines_rec.estim_gl_value,
2565: l_qp_list_lines_rec.accrual_conversion_rate,

Line 2562: l_qp_list_lines_rec.expiration_period_uom,

2558: l_qp_list_lines_rec.product_precedence,
2559: l_qp_list_lines_rec.pricing_phase_id,
2560: l_qp_list_lines_rec.expiration_period_start_date,
2561: l_qp_list_lines_rec.number_expiration_periods,
2562: l_qp_list_lines_rec.expiration_period_uom,
2563: l_qp_list_lines_rec.expiration_date,
2564: l_qp_list_lines_rec.estim_gl_value,
2565: l_qp_list_lines_rec.accrual_conversion_rate,
2566: l_qp_list_lines_rec.benefit_price_list_line_id,

Line 2563: l_qp_list_lines_rec.expiration_date,

2559: l_qp_list_lines_rec.pricing_phase_id,
2560: l_qp_list_lines_rec.expiration_period_start_date,
2561: l_qp_list_lines_rec.number_expiration_periods,
2562: l_qp_list_lines_rec.expiration_period_uom,
2563: l_qp_list_lines_rec.expiration_date,
2564: l_qp_list_lines_rec.estim_gl_value,
2565: l_qp_list_lines_rec.accrual_conversion_rate,
2566: l_qp_list_lines_rec.benefit_price_list_line_id,
2567: l_qp_list_lines_rec.proration_type_code,

Line 2564: l_qp_list_lines_rec.estim_gl_value,

2560: l_qp_list_lines_rec.expiration_period_start_date,
2561: l_qp_list_lines_rec.number_expiration_periods,
2562: l_qp_list_lines_rec.expiration_period_uom,
2563: l_qp_list_lines_rec.expiration_date,
2564: l_qp_list_lines_rec.estim_gl_value,
2565: l_qp_list_lines_rec.accrual_conversion_rate,
2566: l_qp_list_lines_rec.benefit_price_list_line_id,
2567: l_qp_list_lines_rec.proration_type_code,
2568: l_qp_list_lines_rec.benefit_qty,

Line 2565: l_qp_list_lines_rec.accrual_conversion_rate,

2561: l_qp_list_lines_rec.number_expiration_periods,
2562: l_qp_list_lines_rec.expiration_period_uom,
2563: l_qp_list_lines_rec.expiration_date,
2564: l_qp_list_lines_rec.estim_gl_value,
2565: l_qp_list_lines_rec.accrual_conversion_rate,
2566: l_qp_list_lines_rec.benefit_price_list_line_id,
2567: l_qp_list_lines_rec.proration_type_code,
2568: l_qp_list_lines_rec.benefit_qty,
2569: l_qp_list_lines_rec.benefit_uom_code,

Line 2566: l_qp_list_lines_rec.benefit_price_list_line_id,

2562: l_qp_list_lines_rec.expiration_period_uom,
2563: l_qp_list_lines_rec.expiration_date,
2564: l_qp_list_lines_rec.estim_gl_value,
2565: l_qp_list_lines_rec.accrual_conversion_rate,
2566: l_qp_list_lines_rec.benefit_price_list_line_id,
2567: l_qp_list_lines_rec.proration_type_code,
2568: l_qp_list_lines_rec.benefit_qty,
2569: l_qp_list_lines_rec.benefit_uom_code,
2570: l_qp_list_lines_rec.charge_type_code,

Line 2567: l_qp_list_lines_rec.proration_type_code,

2563: l_qp_list_lines_rec.expiration_date,
2564: l_qp_list_lines_rec.estim_gl_value,
2565: l_qp_list_lines_rec.accrual_conversion_rate,
2566: l_qp_list_lines_rec.benefit_price_list_line_id,
2567: l_qp_list_lines_rec.proration_type_code,
2568: l_qp_list_lines_rec.benefit_qty,
2569: l_qp_list_lines_rec.benefit_uom_code,
2570: l_qp_list_lines_rec.charge_type_code,
2571: l_qp_list_lines_rec.charge_subtype_code,

Line 2568: l_qp_list_lines_rec.benefit_qty,

2564: l_qp_list_lines_rec.estim_gl_value,
2565: l_qp_list_lines_rec.accrual_conversion_rate,
2566: l_qp_list_lines_rec.benefit_price_list_line_id,
2567: l_qp_list_lines_rec.proration_type_code,
2568: l_qp_list_lines_rec.benefit_qty,
2569: l_qp_list_lines_rec.benefit_uom_code,
2570: l_qp_list_lines_rec.charge_type_code,
2571: l_qp_list_lines_rec.charge_subtype_code,
2572: l_qp_list_lines_rec.benefit_limit,

Line 2569: l_qp_list_lines_rec.benefit_uom_code,

2565: l_qp_list_lines_rec.accrual_conversion_rate,
2566: l_qp_list_lines_rec.benefit_price_list_line_id,
2567: l_qp_list_lines_rec.proration_type_code,
2568: l_qp_list_lines_rec.benefit_qty,
2569: l_qp_list_lines_rec.benefit_uom_code,
2570: l_qp_list_lines_rec.charge_type_code,
2571: l_qp_list_lines_rec.charge_subtype_code,
2572: l_qp_list_lines_rec.benefit_limit,
2573: l_qp_list_lines_rec.include_on_returns_flag,

Line 2570: l_qp_list_lines_rec.charge_type_code,

2566: l_qp_list_lines_rec.benefit_price_list_line_id,
2567: l_qp_list_lines_rec.proration_type_code,
2568: l_qp_list_lines_rec.benefit_qty,
2569: l_qp_list_lines_rec.benefit_uom_code,
2570: l_qp_list_lines_rec.charge_type_code,
2571: l_qp_list_lines_rec.charge_subtype_code,
2572: l_qp_list_lines_rec.benefit_limit,
2573: l_qp_list_lines_rec.include_on_returns_flag,
2574: l_qp_list_lines_rec.qualification_ind,

Line 2571: l_qp_list_lines_rec.charge_subtype_code,

2567: l_qp_list_lines_rec.proration_type_code,
2568: l_qp_list_lines_rec.benefit_qty,
2569: l_qp_list_lines_rec.benefit_uom_code,
2570: l_qp_list_lines_rec.charge_type_code,
2571: l_qp_list_lines_rec.charge_subtype_code,
2572: l_qp_list_lines_rec.benefit_limit,
2573: l_qp_list_lines_rec.include_on_returns_flag,
2574: l_qp_list_lines_rec.qualification_ind,
2575: l_qp_list_lines_rec.recurring_value, -- block pricing

Line 2572: l_qp_list_lines_rec.benefit_limit,

2568: l_qp_list_lines_rec.benefit_qty,
2569: l_qp_list_lines_rec.benefit_uom_code,
2570: l_qp_list_lines_rec.charge_type_code,
2571: l_qp_list_lines_rec.charge_subtype_code,
2572: l_qp_list_lines_rec.benefit_limit,
2573: l_qp_list_lines_rec.include_on_returns_flag,
2574: l_qp_list_lines_rec.qualification_ind,
2575: l_qp_list_lines_rec.recurring_value, -- block pricing
2576: decode(nvl(FND_PROFILE.VALUE('QP_CONTINUOUS_PB'),'Y'),'Y','Y','N') -- Continuous Price Breaks -- 14103598

Line 2573: l_qp_list_lines_rec.include_on_returns_flag,

2569: l_qp_list_lines_rec.benefit_uom_code,
2570: l_qp_list_lines_rec.charge_type_code,
2571: l_qp_list_lines_rec.charge_subtype_code,
2572: l_qp_list_lines_rec.benefit_limit,
2573: l_qp_list_lines_rec.include_on_returns_flag,
2574: l_qp_list_lines_rec.qualification_ind,
2575: l_qp_list_lines_rec.recurring_value, -- block pricing
2576: decode(nvl(FND_PROFILE.VALUE('QP_CONTINUOUS_PB'),'Y'),'Y','Y','N') -- Continuous Price Breaks -- 14103598
2577: --ENH Upgrade BOAPI for orig_sys...ref RAVI

Line 2574: l_qp_list_lines_rec.qualification_ind,

2570: l_qp_list_lines_rec.charge_type_code,
2571: l_qp_list_lines_rec.charge_subtype_code,
2572: l_qp_list_lines_rec.benefit_limit,
2573: l_qp_list_lines_rec.include_on_returns_flag,
2574: l_qp_list_lines_rec.qualification_ind,
2575: l_qp_list_lines_rec.recurring_value, -- block pricing
2576: decode(nvl(FND_PROFILE.VALUE('QP_CONTINUOUS_PB'),'Y'),'Y','Y','N') -- Continuous Price Breaks -- 14103598
2577: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2578: --,to_char(l_qp_list_lines_rec.list_line_id) --7309992

Line 2575: l_qp_list_lines_rec.recurring_value, -- block pricing

2571: l_qp_list_lines_rec.charge_subtype_code,
2572: l_qp_list_lines_rec.benefit_limit,
2573: l_qp_list_lines_rec.include_on_returns_flag,
2574: l_qp_list_lines_rec.qualification_ind,
2575: l_qp_list_lines_rec.recurring_value, -- block pricing
2576: decode(nvl(FND_PROFILE.VALUE('QP_CONTINUOUS_PB'),'Y'),'Y','Y','N') -- Continuous Price Breaks -- 14103598
2577: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2578: --,to_char(l_qp_list_lines_rec.list_line_id) --7309992
2579: --,to_char(l_qp_list_lines_rec.list_header_id) --7309992

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

2574: l_qp_list_lines_rec.qualification_ind,
2575: l_qp_list_lines_rec.recurring_value, -- block pricing
2576: decode(nvl(FND_PROFILE.VALUE('QP_CONTINUOUS_PB'),'Y'),'Y','Y','N') -- Continuous Price Breaks -- 14103598
2577: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2578: --,to_char(l_qp_list_lines_rec.list_line_id) --7309992
2579: --,to_char(l_qp_list_lines_rec.list_header_id) --7309992
2580: ,to_char(l_new_list_line_id) --bug#12423441
2581: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id) --bug#12423441
2582: );

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

2575: l_qp_list_lines_rec.recurring_value, -- block pricing
2576: decode(nvl(FND_PROFILE.VALUE('QP_CONTINUOUS_PB'),'Y'),'Y','Y','N') -- Continuous Price Breaks -- 14103598
2577: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2578: --,to_char(l_qp_list_lines_rec.list_line_id) --7309992
2579: --,to_char(l_qp_list_lines_rec.list_header_id) --7309992
2580: ,to_char(l_new_list_line_id) --bug#12423441
2581: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id) --bug#12423441
2582: );
2583: fnd_file.put_line(FND_FILE.LOG,'Inserted line');

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

2581: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id) --bug#12423441
2582: );
2583: fnd_file.put_line(FND_FILE.LOG,'Inserted line');
2584: fnd_file.put_line(FND_FILE.LOG,'list_line_id ' || l_new_list_line_id);
2585: fnd_file.put_line(FND_FILE.LOG,'list_line_type_code ' || l_qp_list_lines_rec.list_line_type_code);
2586:
2587:
2588: /*If the list_line_rec is a Price Break Parent Line or Price Break Line then
2589: store the old and new list line id in a mapping-array for later use*/

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

2587:
2588: /*If the list_line_rec is a Price Break Parent Line or Price Break Line then
2589: store the old and new list line id in a mapping-array for later use*/
2590:
2591: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' OR
2592: Price_Break_Line(l_qp_list_lines_rec.list_line_id)
2593: THEN
2594: l_count := l_count + 1;
2595: l_mapping_tbl(l_count).list_line_type_code :=

Line 2592: Price_Break_Line(l_qp_list_lines_rec.list_line_id)

2588: /*If the list_line_rec is a Price Break Parent Line or Price Break Line then
2589: store the old and new list line id in a mapping-array for later use*/
2590:
2591: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' OR
2592: Price_Break_Line(l_qp_list_lines_rec.list_line_id)
2593: THEN
2594: l_count := l_count + 1;
2595: l_mapping_tbl(l_count).list_line_type_code :=
2596: l_qp_list_lines_rec.list_line_type_code;

Line 2596: l_qp_list_lines_rec.list_line_type_code;

2592: Price_Break_Line(l_qp_list_lines_rec.list_line_id)
2593: THEN
2594: l_count := l_count + 1;
2595: l_mapping_tbl(l_count).list_line_type_code :=
2596: l_qp_list_lines_rec.list_line_type_code;
2597: l_mapping_tbl(l_count).old_list_line_id :=
2598: l_qp_list_lines_rec.list_line_id;
2599: l_mapping_tbl(l_count).new_list_line_id := l_new_list_line_id;
2600: END IF;

Line 2598: l_qp_list_lines_rec.list_line_id;

2594: l_count := l_count + 1;
2595: l_mapping_tbl(l_count).list_line_type_code :=
2596: l_qp_list_lines_rec.list_line_type_code;
2597: l_mapping_tbl(l_count).old_list_line_id :=
2598: l_qp_list_lines_rec.list_line_id;
2599: l_mapping_tbl(l_count).new_list_line_id := l_new_list_line_id;
2600: END IF;
2601:
2602: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' AND

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

2598: l_qp_list_lines_rec.list_line_id;
2599: l_mapping_tbl(l_count).new_list_line_id := l_new_list_line_id;
2600: END IF;
2601:
2602: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' AND
2603: (l_qp_list_lines_rec.continuous_price_break_flag IS NULL OR l_qp_list_lines_rec.continuous_price_break_flag <> 'Y')
2604: THEN
2605: l_non_cont_count := l_non_cont_count + 1;
2606: l_non_cont_pbh_id_tbl(l_non_cont_count).price_break_header_id := l_new_list_line_id;

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

2599: l_mapping_tbl(l_count).new_list_line_id := l_new_list_line_id;
2600: END IF;
2601:
2602: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' AND
2603: (l_qp_list_lines_rec.continuous_price_break_flag IS NULL OR l_qp_list_lines_rec.continuous_price_break_flag <> 'Y')
2604: THEN
2605: l_non_cont_count := l_non_cont_count + 1;
2606: l_non_cont_pbh_id_tbl(l_non_cont_count).price_break_header_id := l_new_list_line_id;
2607: l_non_cont_pbh_id_tbl(l_non_cont_count).list_line_no := l_qp_list_lines_rec.list_line_no;

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

2603: (l_qp_list_lines_rec.continuous_price_break_flag IS NULL OR l_qp_list_lines_rec.continuous_price_break_flag <> 'Y')
2604: THEN
2605: l_non_cont_count := l_non_cont_count + 1;
2606: l_non_cont_pbh_id_tbl(l_non_cont_count).price_break_header_id := l_new_list_line_id;
2607: l_non_cont_pbh_id_tbl(l_non_cont_count).list_line_no := l_qp_list_lines_rec.list_line_no;
2608:
2609: IF p_effective_dates_flag = 'Y' THEN
2610: l_non_cont_pbh_id_tbl(l_non_cont_count).start_date_active := l_qp_list_lines_rec.start_date_active;
2611: l_non_cont_pbh_id_tbl(l_non_cont_count).end_date_active := l_qp_list_lines_rec.end_date_active;

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

2606: l_non_cont_pbh_id_tbl(l_non_cont_count).price_break_header_id := l_new_list_line_id;
2607: l_non_cont_pbh_id_tbl(l_non_cont_count).list_line_no := l_qp_list_lines_rec.list_line_no;
2608:
2609: IF p_effective_dates_flag = 'Y' THEN
2610: l_non_cont_pbh_id_tbl(l_non_cont_count).start_date_active := l_qp_list_lines_rec.start_date_active;
2611: l_non_cont_pbh_id_tbl(l_non_cont_count).end_date_active := l_qp_list_lines_rec.end_date_active;
2612: END IF;
2613:
2614: END IF;

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

2607: l_non_cont_pbh_id_tbl(l_non_cont_count).list_line_no := l_qp_list_lines_rec.list_line_no;
2608:
2609: IF p_effective_dates_flag = 'Y' THEN
2610: l_non_cont_pbh_id_tbl(l_non_cont_count).start_date_active := l_qp_list_lines_rec.start_date_active;
2611: l_non_cont_pbh_id_tbl(l_non_cont_count).end_date_active := l_qp_list_lines_rec.end_date_active;
2612: END IF;
2613:
2614: END IF;
2615:

Line 2623: l_qp_list_lines_rec.list_line_id)

2619: new_list_line_id*/
2620:
2621: /* Select qp_pricing_attributes records for the 'from' list_line_id */
2622: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (
2623: l_qp_list_lines_rec.list_line_id)
2624: LOOP
2625:
2626: -- Get next pricing_attribute_id
2627: SELECT qp_pricing_attributes_s.nextval

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

2627: SELECT qp_pricing_attributes_s.nextval
2628: INTO l_new_pricing_attribute_id
2629: FROM dual;
2630:
2631: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' AND
2632: (l_qp_list_lines_rec.continuous_price_break_flag IS NULL OR l_qp_list_lines_rec.continuous_price_break_flag <> 'Y')
2633: AND l_qp_pricing_attributes_rec.list_line_id = l_qp_list_lines_rec.list_line_id
2634: THEN
2635: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attribute :=

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

2628: INTO l_new_pricing_attribute_id
2629: FROM dual;
2630:
2631: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' AND
2632: (l_qp_list_lines_rec.continuous_price_break_flag IS NULL OR l_qp_list_lines_rec.continuous_price_break_flag <> 'Y')
2633: AND l_qp_pricing_attributes_rec.list_line_id = l_qp_list_lines_rec.list_line_id
2634: THEN
2635: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attribute :=
2636: l_qp_pricing_attributes_rec.product_attribute;

Line 2633: AND l_qp_pricing_attributes_rec.list_line_id = l_qp_list_lines_rec.list_line_id

2629: FROM dual;
2630:
2631: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' AND
2632: (l_qp_list_lines_rec.continuous_price_break_flag IS NULL OR l_qp_list_lines_rec.continuous_price_break_flag <> 'Y')
2633: AND l_qp_pricing_attributes_rec.list_line_id = l_qp_list_lines_rec.list_line_id
2634: THEN
2635: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attribute :=
2636: l_qp_pricing_attributes_rec.product_attribute;
2637: l_non_cont_pbh_id_tbl(l_non_cont_count).product_attr_value:=

Line 2763: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_new_list_line_id)

2759: l_pric_attr_value_from_number,
2760: l_pric_attr_value_to_number
2761: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2762: ,to_char(l_new_pricing_attribute_id)
2763: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_new_list_line_id)
2764: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id)
2765: );
2766: fnd_file.put_line(FND_FILE.LOG,'Inserted pricing attribute');
2767: fnd_file.put_line(FND_FILE.LOG,'product_attribute_context ' || l_qp_pricing_attributes_rec.product_attribute_context);

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

2770: fnd_file.put_line(FND_FILE.LOG,'product_uom_code ' || l_qp_pricing_attributes_rec.product_uom_code);
2771:
2772: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
2773: end if; --bug3067774
2774: END LOOP; /* Cursor qp_list_lines_cv LOOP */
2775:
2776: CLOSE qp_list_lines_cv;
2777:
2778:

Line 2776: CLOSE qp_list_lines_cv;

2772: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
2773: end if; --bug3067774
2774: END LOOP; /* Cursor qp_list_lines_cv LOOP */
2775:
2776: CLOSE qp_list_lines_cv;
2777:
2778:
2779: /* Copy qp_rltd_modifiers for the Price Break Parent list_lines chosen
2780: above which are stored in the mapping table */

Line 2920: from qp_list_lines

2916: fnd_file.put_line(FND_FILE.LOG,'Price list copy completed successfully');
2917: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
2918: select min(list_line_id), max(list_line_id)
2919: into l_min_list_line_id, l_max_list_line_id
2920: from qp_list_lines
2921: where list_header_id = l_new_list_header_id;
2922:
2923:
2924: QP_ATTR_GRP_PVT.Update_Qual_Segment_id(l_new_list_header_id,

Line 2943: from qp_list_lines

2939: begin
2940:
2941: select min(list_line_id), max(list_line_id)
2942: into l_min_list_line_id, l_max_list_line_id
2943: from qp_list_lines
2944: where list_header_id = l_list_header_id;
2945:
2946:
2947: QP_PS_ATTR_GRP_PVT.Update_Qual_Segment_id(l_new_list_header_id,