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_ARCHIVE_ENTITY_PVT dependencies on QP_LIST_LINES

Line 473: FROM QP_LIST_LINES

469: ,PRICING_ATTRIBUTE_COUNT
470: ,HASH_KEY
471: ,CACHE_KEY
472: ,p_conc_request_id
473: FROM QP_LIST_LINES
474: WHERE list_line_id = p_to_rltd_modifier_id;
475: g_count_list_line:=g_count_list_line + sql%rowcount;
476:
477: --Delete from QP_LIST_LINES

Line 477: --Delete from QP_LIST_LINES

473: FROM QP_LIST_LINES
474: WHERE list_line_id = p_to_rltd_modifier_id;
475: g_count_list_line:=g_count_list_line + sql%rowcount;
476:
477: --Delete from QP_LIST_LINES
478:
479: DELETE FROM QP_LIST_LINES WHERE list_line_id = p_to_rltd_modifier_id;
480:
481: --Archive the pricing attributes

Line 479: DELETE FROM QP_LIST_LINES WHERE list_line_id = p_to_rltd_modifier_id;

475: g_count_list_line:=g_count_list_line + sql%rowcount;
476:
477: --Delete from QP_LIST_LINES
478:
479: DELETE FROM QP_LIST_LINES WHERE list_line_id = p_to_rltd_modifier_id;
480:
481: --Archive the pricing attributes
482:
483: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (p_to_rltd_modifier_id)

Line 696: TYPE qp_list_lines_rec IS RECORD (

692: l_insert_flag varchar2(1);
693: l_cnt number:=0;
694: l_err_count number:=0;
695:
696: TYPE qp_list_lines_rec IS RECORD (
697: list_line_id QP_LIST_LINES.list_line_id%TYPE,
698: creation_date QP_LIST_LINES.creation_date%TYPE,
699: created_by QP_LIST_LINES.created_by%TYPE,
700: last_update_date QP_LIST_LINES.last_update_date%TYPE,

Line 697: list_line_id QP_LIST_LINES.list_line_id%TYPE,

693: l_cnt number:=0;
694: l_err_count number:=0;
695:
696: TYPE qp_list_lines_rec IS RECORD (
697: list_line_id QP_LIST_LINES.list_line_id%TYPE,
698: creation_date QP_LIST_LINES.creation_date%TYPE,
699: created_by QP_LIST_LINES.created_by%TYPE,
700: last_update_date QP_LIST_LINES.last_update_date%TYPE,
701: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,

Line 698: creation_date QP_LIST_LINES.creation_date%TYPE,

694: l_err_count number:=0;
695:
696: TYPE qp_list_lines_rec IS RECORD (
697: list_line_id QP_LIST_LINES.list_line_id%TYPE,
698: creation_date QP_LIST_LINES.creation_date%TYPE,
699: created_by QP_LIST_LINES.created_by%TYPE,
700: last_update_date QP_LIST_LINES.last_update_date%TYPE,
701: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
702: last_update_login QP_LIST_LINES.last_update_login%TYPE,

Line 699: created_by QP_LIST_LINES.created_by%TYPE,

695:
696: TYPE qp_list_lines_rec IS RECORD (
697: list_line_id QP_LIST_LINES.list_line_id%TYPE,
698: creation_date QP_LIST_LINES.creation_date%TYPE,
699: created_by QP_LIST_LINES.created_by%TYPE,
700: last_update_date QP_LIST_LINES.last_update_date%TYPE,
701: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
702: last_update_login QP_LIST_LINES.last_update_login%TYPE,
703: program_application_id QP_LIST_LINES.program_application_id%TYPE,

Line 700: last_update_date QP_LIST_LINES.last_update_date%TYPE,

696: TYPE qp_list_lines_rec IS RECORD (
697: list_line_id QP_LIST_LINES.list_line_id%TYPE,
698: creation_date QP_LIST_LINES.creation_date%TYPE,
699: created_by QP_LIST_LINES.created_by%TYPE,
700: last_update_date QP_LIST_LINES.last_update_date%TYPE,
701: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
702: last_update_login QP_LIST_LINES.last_update_login%TYPE,
703: program_application_id QP_LIST_LINES.program_application_id%TYPE,
704: program_id QP_LIST_LINES.program_id%TYPE,

Line 701: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,

697: list_line_id QP_LIST_LINES.list_line_id%TYPE,
698: creation_date QP_LIST_LINES.creation_date%TYPE,
699: created_by QP_LIST_LINES.created_by%TYPE,
700: last_update_date QP_LIST_LINES.last_update_date%TYPE,
701: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
702: last_update_login QP_LIST_LINES.last_update_login%TYPE,
703: program_application_id QP_LIST_LINES.program_application_id%TYPE,
704: program_id QP_LIST_LINES.program_id%TYPE,
705: program_update_date QP_LIST_LINES.program_update_date%TYPE,

Line 702: last_update_login QP_LIST_LINES.last_update_login%TYPE,

698: creation_date QP_LIST_LINES.creation_date%TYPE,
699: created_by QP_LIST_LINES.created_by%TYPE,
700: last_update_date QP_LIST_LINES.last_update_date%TYPE,
701: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
702: last_update_login QP_LIST_LINES.last_update_login%TYPE,
703: program_application_id QP_LIST_LINES.program_application_id%TYPE,
704: program_id QP_LIST_LINES.program_id%TYPE,
705: program_update_date QP_LIST_LINES.program_update_date%TYPE,
706: request_id QP_LIST_LINES.request_id%TYPE,

Line 703: program_application_id QP_LIST_LINES.program_application_id%TYPE,

699: created_by QP_LIST_LINES.created_by%TYPE,
700: last_update_date QP_LIST_LINES.last_update_date%TYPE,
701: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
702: last_update_login QP_LIST_LINES.last_update_login%TYPE,
703: program_application_id QP_LIST_LINES.program_application_id%TYPE,
704: program_id QP_LIST_LINES.program_id%TYPE,
705: program_update_date QP_LIST_LINES.program_update_date%TYPE,
706: request_id QP_LIST_LINES.request_id%TYPE,
707: list_header_id QP_LIST_LINES.list_header_id%TYPE,

Line 704: program_id QP_LIST_LINES.program_id%TYPE,

700: last_update_date QP_LIST_LINES.last_update_date%TYPE,
701: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
702: last_update_login QP_LIST_LINES.last_update_login%TYPE,
703: program_application_id QP_LIST_LINES.program_application_id%TYPE,
704: program_id QP_LIST_LINES.program_id%TYPE,
705: program_update_date QP_LIST_LINES.program_update_date%TYPE,
706: request_id QP_LIST_LINES.request_id%TYPE,
707: list_header_id QP_LIST_LINES.list_header_id%TYPE,
708: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,

Line 705: program_update_date QP_LIST_LINES.program_update_date%TYPE,

701: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
702: last_update_login QP_LIST_LINES.last_update_login%TYPE,
703: program_application_id QP_LIST_LINES.program_application_id%TYPE,
704: program_id QP_LIST_LINES.program_id%TYPE,
705: program_update_date QP_LIST_LINES.program_update_date%TYPE,
706: request_id QP_LIST_LINES.request_id%TYPE,
707: list_header_id QP_LIST_LINES.list_header_id%TYPE,
708: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
709: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,

Line 706: request_id QP_LIST_LINES.request_id%TYPE,

702: last_update_login QP_LIST_LINES.last_update_login%TYPE,
703: program_application_id QP_LIST_LINES.program_application_id%TYPE,
704: program_id QP_LIST_LINES.program_id%TYPE,
705: program_update_date QP_LIST_LINES.program_update_date%TYPE,
706: request_id QP_LIST_LINES.request_id%TYPE,
707: list_header_id QP_LIST_LINES.list_header_id%TYPE,
708: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
709: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
710: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,

Line 707: list_header_id QP_LIST_LINES.list_header_id%TYPE,

703: program_application_id QP_LIST_LINES.program_application_id%TYPE,
704: program_id QP_LIST_LINES.program_id%TYPE,
705: program_update_date QP_LIST_LINES.program_update_date%TYPE,
706: request_id QP_LIST_LINES.request_id%TYPE,
707: list_header_id QP_LIST_LINES.list_header_id%TYPE,
708: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
709: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
710: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
711: list_price QP_LIST_LINES.list_price%TYPE,

Line 708: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,

704: program_id QP_LIST_LINES.program_id%TYPE,
705: program_update_date QP_LIST_LINES.program_update_date%TYPE,
706: request_id QP_LIST_LINES.request_id%TYPE,
707: list_header_id QP_LIST_LINES.list_header_id%TYPE,
708: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
709: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
710: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
711: list_price QP_LIST_LINES.list_price%TYPE,
712: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,

Line 709: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,

705: program_update_date QP_LIST_LINES.program_update_date%TYPE,
706: request_id QP_LIST_LINES.request_id%TYPE,
707: list_header_id QP_LIST_LINES.list_header_id%TYPE,
708: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
709: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
710: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
711: list_price QP_LIST_LINES.list_price%TYPE,
712: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
713: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,

Line 710: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,

706: request_id QP_LIST_LINES.request_id%TYPE,
707: list_header_id QP_LIST_LINES.list_header_id%TYPE,
708: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
709: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
710: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
711: list_price QP_LIST_LINES.list_price%TYPE,
712: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
713: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
714: organization_id QP_LIST_LINES.organization_id%TYPE,

Line 711: list_price QP_LIST_LINES.list_price%TYPE,

707: list_header_id QP_LIST_LINES.list_header_id%TYPE,
708: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
709: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
710: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
711: list_price QP_LIST_LINES.list_price%TYPE,
712: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
713: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
714: organization_id QP_LIST_LINES.organization_id%TYPE,
715: related_item_id QP_LIST_LINES.related_item_id%TYPE,

Line 712: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,

708: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
709: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
710: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
711: list_price QP_LIST_LINES.list_price%TYPE,
712: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
713: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
714: organization_id QP_LIST_LINES.organization_id%TYPE,
715: related_item_id QP_LIST_LINES.related_item_id%TYPE,
716: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,

Line 713: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,

709: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
710: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
711: list_price QP_LIST_LINES.list_price%TYPE,
712: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
713: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
714: organization_id QP_LIST_LINES.organization_id%TYPE,
715: related_item_id QP_LIST_LINES.related_item_id%TYPE,
716: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
717: substitution_context QP_LIST_LINES.substitution_context%TYPE,

Line 714: organization_id QP_LIST_LINES.organization_id%TYPE,

710: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
711: list_price QP_LIST_LINES.list_price%TYPE,
712: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
713: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
714: organization_id QP_LIST_LINES.organization_id%TYPE,
715: related_item_id QP_LIST_LINES.related_item_id%TYPE,
716: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
717: substitution_context QP_LIST_LINES.substitution_context%TYPE,
718: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,

Line 715: related_item_id QP_LIST_LINES.related_item_id%TYPE,

711: list_price QP_LIST_LINES.list_price%TYPE,
712: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
713: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
714: organization_id QP_LIST_LINES.organization_id%TYPE,
715: related_item_id QP_LIST_LINES.related_item_id%TYPE,
716: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
717: substitution_context QP_LIST_LINES.substitution_context%TYPE,
718: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
719: substitution_value QP_LIST_LINES.substitution_value%TYPE,

Line 716: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,

712: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
713: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
714: organization_id QP_LIST_LINES.organization_id%TYPE,
715: related_item_id QP_LIST_LINES.related_item_id%TYPE,
716: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
717: substitution_context QP_LIST_LINES.substitution_context%TYPE,
718: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
719: substitution_value QP_LIST_LINES.substitution_value%TYPE,
720: revision QP_LIST_LINES.revision%TYPE,

Line 717: substitution_context QP_LIST_LINES.substitution_context%TYPE,

713: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
714: organization_id QP_LIST_LINES.organization_id%TYPE,
715: related_item_id QP_LIST_LINES.related_item_id%TYPE,
716: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
717: substitution_context QP_LIST_LINES.substitution_context%TYPE,
718: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
719: substitution_value QP_LIST_LINES.substitution_value%TYPE,
720: revision QP_LIST_LINES.revision%TYPE,
721: revision_date QP_LIST_LINES.revision_date%TYPE,

Line 718: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,

714: organization_id QP_LIST_LINES.organization_id%TYPE,
715: related_item_id QP_LIST_LINES.related_item_id%TYPE,
716: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
717: substitution_context QP_LIST_LINES.substitution_context%TYPE,
718: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
719: substitution_value QP_LIST_LINES.substitution_value%TYPE,
720: revision QP_LIST_LINES.revision%TYPE,
721: revision_date QP_LIST_LINES.revision_date%TYPE,
722: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,

Line 719: substitution_value QP_LIST_LINES.substitution_value%TYPE,

715: related_item_id QP_LIST_LINES.related_item_id%TYPE,
716: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
717: substitution_context QP_LIST_LINES.substitution_context%TYPE,
718: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
719: substitution_value QP_LIST_LINES.substitution_value%TYPE,
720: revision QP_LIST_LINES.revision%TYPE,
721: revision_date QP_LIST_LINES.revision_date%TYPE,
722: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
723: context QP_LIST_LINES.context%TYPE,

Line 720: revision QP_LIST_LINES.revision%TYPE,

716: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
717: substitution_context QP_LIST_LINES.substitution_context%TYPE,
718: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
719: substitution_value QP_LIST_LINES.substitution_value%TYPE,
720: revision QP_LIST_LINES.revision%TYPE,
721: revision_date QP_LIST_LINES.revision_date%TYPE,
722: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
723: context QP_LIST_LINES.context%TYPE,
724: attribute1 QP_LIST_LINES.attribute1%TYPE,

Line 721: revision_date QP_LIST_LINES.revision_date%TYPE,

717: substitution_context QP_LIST_LINES.substitution_context%TYPE,
718: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
719: substitution_value QP_LIST_LINES.substitution_value%TYPE,
720: revision QP_LIST_LINES.revision%TYPE,
721: revision_date QP_LIST_LINES.revision_date%TYPE,
722: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
723: context QP_LIST_LINES.context%TYPE,
724: attribute1 QP_LIST_LINES.attribute1%TYPE,
725: attribute2 QP_LIST_LINES.attribute2%TYPE,

Line 722: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,

718: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
719: substitution_value QP_LIST_LINES.substitution_value%TYPE,
720: revision QP_LIST_LINES.revision%TYPE,
721: revision_date QP_LIST_LINES.revision_date%TYPE,
722: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
723: context QP_LIST_LINES.context%TYPE,
724: attribute1 QP_LIST_LINES.attribute1%TYPE,
725: attribute2 QP_LIST_LINES.attribute2%TYPE,
726: comments QP_LIST_LINES.comments%TYPE,

Line 723: context QP_LIST_LINES.context%TYPE,

719: substitution_value QP_LIST_LINES.substitution_value%TYPE,
720: revision QP_LIST_LINES.revision%TYPE,
721: revision_date QP_LIST_LINES.revision_date%TYPE,
722: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
723: context QP_LIST_LINES.context%TYPE,
724: attribute1 QP_LIST_LINES.attribute1%TYPE,
725: attribute2 QP_LIST_LINES.attribute2%TYPE,
726: comments QP_LIST_LINES.comments%TYPE,
727: attribute3 QP_LIST_LINES.attribute3%TYPE,

Line 724: attribute1 QP_LIST_LINES.attribute1%TYPE,

720: revision QP_LIST_LINES.revision%TYPE,
721: revision_date QP_LIST_LINES.revision_date%TYPE,
722: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
723: context QP_LIST_LINES.context%TYPE,
724: attribute1 QP_LIST_LINES.attribute1%TYPE,
725: attribute2 QP_LIST_LINES.attribute2%TYPE,
726: comments QP_LIST_LINES.comments%TYPE,
727: attribute3 QP_LIST_LINES.attribute3%TYPE,
728: attribute4 QP_LIST_LINES.attribute4%TYPE,

Line 725: attribute2 QP_LIST_LINES.attribute2%TYPE,

721: revision_date QP_LIST_LINES.revision_date%TYPE,
722: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
723: context QP_LIST_LINES.context%TYPE,
724: attribute1 QP_LIST_LINES.attribute1%TYPE,
725: attribute2 QP_LIST_LINES.attribute2%TYPE,
726: comments QP_LIST_LINES.comments%TYPE,
727: attribute3 QP_LIST_LINES.attribute3%TYPE,
728: attribute4 QP_LIST_LINES.attribute4%TYPE,
729: attribute5 QP_LIST_LINES.attribute5%TYPE,

Line 726: comments QP_LIST_LINES.comments%TYPE,

722: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
723: context QP_LIST_LINES.context%TYPE,
724: attribute1 QP_LIST_LINES.attribute1%TYPE,
725: attribute2 QP_LIST_LINES.attribute2%TYPE,
726: comments QP_LIST_LINES.comments%TYPE,
727: attribute3 QP_LIST_LINES.attribute3%TYPE,
728: attribute4 QP_LIST_LINES.attribute4%TYPE,
729: attribute5 QP_LIST_LINES.attribute5%TYPE,
730: attribute6 QP_LIST_LINES.attribute6%TYPE,

Line 727: attribute3 QP_LIST_LINES.attribute3%TYPE,

723: context QP_LIST_LINES.context%TYPE,
724: attribute1 QP_LIST_LINES.attribute1%TYPE,
725: attribute2 QP_LIST_LINES.attribute2%TYPE,
726: comments QP_LIST_LINES.comments%TYPE,
727: attribute3 QP_LIST_LINES.attribute3%TYPE,
728: attribute4 QP_LIST_LINES.attribute4%TYPE,
729: attribute5 QP_LIST_LINES.attribute5%TYPE,
730: attribute6 QP_LIST_LINES.attribute6%TYPE,
731: attribute7 QP_LIST_LINES.attribute7%TYPE,

Line 728: attribute4 QP_LIST_LINES.attribute4%TYPE,

724: attribute1 QP_LIST_LINES.attribute1%TYPE,
725: attribute2 QP_LIST_LINES.attribute2%TYPE,
726: comments QP_LIST_LINES.comments%TYPE,
727: attribute3 QP_LIST_LINES.attribute3%TYPE,
728: attribute4 QP_LIST_LINES.attribute4%TYPE,
729: attribute5 QP_LIST_LINES.attribute5%TYPE,
730: attribute6 QP_LIST_LINES.attribute6%TYPE,
731: attribute7 QP_LIST_LINES.attribute7%TYPE,
732: attribute8 QP_LIST_LINES.attribute8%TYPE,

Line 729: attribute5 QP_LIST_LINES.attribute5%TYPE,

725: attribute2 QP_LIST_LINES.attribute2%TYPE,
726: comments QP_LIST_LINES.comments%TYPE,
727: attribute3 QP_LIST_LINES.attribute3%TYPE,
728: attribute4 QP_LIST_LINES.attribute4%TYPE,
729: attribute5 QP_LIST_LINES.attribute5%TYPE,
730: attribute6 QP_LIST_LINES.attribute6%TYPE,
731: attribute7 QP_LIST_LINES.attribute7%TYPE,
732: attribute8 QP_LIST_LINES.attribute8%TYPE,
733: attribute9 QP_LIST_LINES.attribute9%TYPE,

Line 730: attribute6 QP_LIST_LINES.attribute6%TYPE,

726: comments QP_LIST_LINES.comments%TYPE,
727: attribute3 QP_LIST_LINES.attribute3%TYPE,
728: attribute4 QP_LIST_LINES.attribute4%TYPE,
729: attribute5 QP_LIST_LINES.attribute5%TYPE,
730: attribute6 QP_LIST_LINES.attribute6%TYPE,
731: attribute7 QP_LIST_LINES.attribute7%TYPE,
732: attribute8 QP_LIST_LINES.attribute8%TYPE,
733: attribute9 QP_LIST_LINES.attribute9%TYPE,
734: attribute10 QP_LIST_LINES.attribute10%TYPE,

Line 731: attribute7 QP_LIST_LINES.attribute7%TYPE,

727: attribute3 QP_LIST_LINES.attribute3%TYPE,
728: attribute4 QP_LIST_LINES.attribute4%TYPE,
729: attribute5 QP_LIST_LINES.attribute5%TYPE,
730: attribute6 QP_LIST_LINES.attribute6%TYPE,
731: attribute7 QP_LIST_LINES.attribute7%TYPE,
732: attribute8 QP_LIST_LINES.attribute8%TYPE,
733: attribute9 QP_LIST_LINES.attribute9%TYPE,
734: attribute10 QP_LIST_LINES.attribute10%TYPE,
735: attribute11 QP_LIST_LINES.attribute11%TYPE,

Line 732: attribute8 QP_LIST_LINES.attribute8%TYPE,

728: attribute4 QP_LIST_LINES.attribute4%TYPE,
729: attribute5 QP_LIST_LINES.attribute5%TYPE,
730: attribute6 QP_LIST_LINES.attribute6%TYPE,
731: attribute7 QP_LIST_LINES.attribute7%TYPE,
732: attribute8 QP_LIST_LINES.attribute8%TYPE,
733: attribute9 QP_LIST_LINES.attribute9%TYPE,
734: attribute10 QP_LIST_LINES.attribute10%TYPE,
735: attribute11 QP_LIST_LINES.attribute11%TYPE,
736: attribute12 QP_LIST_LINES.attribute12%TYPE,

Line 733: attribute9 QP_LIST_LINES.attribute9%TYPE,

729: attribute5 QP_LIST_LINES.attribute5%TYPE,
730: attribute6 QP_LIST_LINES.attribute6%TYPE,
731: attribute7 QP_LIST_LINES.attribute7%TYPE,
732: attribute8 QP_LIST_LINES.attribute8%TYPE,
733: attribute9 QP_LIST_LINES.attribute9%TYPE,
734: attribute10 QP_LIST_LINES.attribute10%TYPE,
735: attribute11 QP_LIST_LINES.attribute11%TYPE,
736: attribute12 QP_LIST_LINES.attribute12%TYPE,
737: attribute13 QP_LIST_LINES.attribute13%TYPE,

Line 734: attribute10 QP_LIST_LINES.attribute10%TYPE,

730: attribute6 QP_LIST_LINES.attribute6%TYPE,
731: attribute7 QP_LIST_LINES.attribute7%TYPE,
732: attribute8 QP_LIST_LINES.attribute8%TYPE,
733: attribute9 QP_LIST_LINES.attribute9%TYPE,
734: attribute10 QP_LIST_LINES.attribute10%TYPE,
735: attribute11 QP_LIST_LINES.attribute11%TYPE,
736: attribute12 QP_LIST_LINES.attribute12%TYPE,
737: attribute13 QP_LIST_LINES.attribute13%TYPE,
738: attribute14 QP_LIST_LINES.attribute14%TYPE,

Line 735: attribute11 QP_LIST_LINES.attribute11%TYPE,

731: attribute7 QP_LIST_LINES.attribute7%TYPE,
732: attribute8 QP_LIST_LINES.attribute8%TYPE,
733: attribute9 QP_LIST_LINES.attribute9%TYPE,
734: attribute10 QP_LIST_LINES.attribute10%TYPE,
735: attribute11 QP_LIST_LINES.attribute11%TYPE,
736: attribute12 QP_LIST_LINES.attribute12%TYPE,
737: attribute13 QP_LIST_LINES.attribute13%TYPE,
738: attribute14 QP_LIST_LINES.attribute14%TYPE,
739: attribute15 QP_LIST_LINES.attribute15%TYPE,

Line 736: attribute12 QP_LIST_LINES.attribute12%TYPE,

732: attribute8 QP_LIST_LINES.attribute8%TYPE,
733: attribute9 QP_LIST_LINES.attribute9%TYPE,
734: attribute10 QP_LIST_LINES.attribute10%TYPE,
735: attribute11 QP_LIST_LINES.attribute11%TYPE,
736: attribute12 QP_LIST_LINES.attribute12%TYPE,
737: attribute13 QP_LIST_LINES.attribute13%TYPE,
738: attribute14 QP_LIST_LINES.attribute14%TYPE,
739: attribute15 QP_LIST_LINES.attribute15%TYPE,
740: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,

Line 737: attribute13 QP_LIST_LINES.attribute13%TYPE,

733: attribute9 QP_LIST_LINES.attribute9%TYPE,
734: attribute10 QP_LIST_LINES.attribute10%TYPE,
735: attribute11 QP_LIST_LINES.attribute11%TYPE,
736: attribute12 QP_LIST_LINES.attribute12%TYPE,
737: attribute13 QP_LIST_LINES.attribute13%TYPE,
738: attribute14 QP_LIST_LINES.attribute14%TYPE,
739: attribute15 QP_LIST_LINES.attribute15%TYPE,
740: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
741: percent_price QP_LIST_LINES.percent_price%TYPE,

Line 738: attribute14 QP_LIST_LINES.attribute14%TYPE,

734: attribute10 QP_LIST_LINES.attribute10%TYPE,
735: attribute11 QP_LIST_LINES.attribute11%TYPE,
736: attribute12 QP_LIST_LINES.attribute12%TYPE,
737: attribute13 QP_LIST_LINES.attribute13%TYPE,
738: attribute14 QP_LIST_LINES.attribute14%TYPE,
739: attribute15 QP_LIST_LINES.attribute15%TYPE,
740: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
741: percent_price QP_LIST_LINES.percent_price%TYPE,
742: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,

Line 739: attribute15 QP_LIST_LINES.attribute15%TYPE,

735: attribute11 QP_LIST_LINES.attribute11%TYPE,
736: attribute12 QP_LIST_LINES.attribute12%TYPE,
737: attribute13 QP_LIST_LINES.attribute13%TYPE,
738: attribute14 QP_LIST_LINES.attribute14%TYPE,
739: attribute15 QP_LIST_LINES.attribute15%TYPE,
740: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
741: percent_price QP_LIST_LINES.percent_price%TYPE,
742: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
743: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,

Line 740: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,

736: attribute12 QP_LIST_LINES.attribute12%TYPE,
737: attribute13 QP_LIST_LINES.attribute13%TYPE,
738: attribute14 QP_LIST_LINES.attribute14%TYPE,
739: attribute15 QP_LIST_LINES.attribute15%TYPE,
740: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
741: percent_price QP_LIST_LINES.percent_price%TYPE,
742: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
743: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
744: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,

Line 741: percent_price QP_LIST_LINES.percent_price%TYPE,

737: attribute13 QP_LIST_LINES.attribute13%TYPE,
738: attribute14 QP_LIST_LINES.attribute14%TYPE,
739: attribute15 QP_LIST_LINES.attribute15%TYPE,
740: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
741: percent_price QP_LIST_LINES.percent_price%TYPE,
742: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
743: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
744: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
745: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,

Line 742: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,

738: attribute14 QP_LIST_LINES.attribute14%TYPE,
739: attribute15 QP_LIST_LINES.attribute15%TYPE,
740: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
741: percent_price QP_LIST_LINES.percent_price%TYPE,
742: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
743: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
744: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
745: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
746: operand QP_LIST_LINES.operand%TYPE,

Line 743: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,

739: attribute15 QP_LIST_LINES.attribute15%TYPE,
740: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
741: percent_price QP_LIST_LINES.percent_price%TYPE,
742: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
743: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
744: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
745: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
746: operand QP_LIST_LINES.operand%TYPE,
747: override_flag QP_LIST_LINES.override_flag%TYPE,

Line 744: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,

740: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
741: percent_price QP_LIST_LINES.percent_price%TYPE,
742: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
743: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
744: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
745: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
746: operand QP_LIST_LINES.operand%TYPE,
747: override_flag QP_LIST_LINES.override_flag%TYPE,
748: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,

Line 745: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,

741: percent_price QP_LIST_LINES.percent_price%TYPE,
742: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
743: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
744: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
745: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
746: operand QP_LIST_LINES.operand%TYPE,
747: override_flag QP_LIST_LINES.override_flag%TYPE,
748: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
749: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,

Line 746: operand QP_LIST_LINES.operand%TYPE,

742: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
743: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
744: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
745: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
746: operand QP_LIST_LINES.operand%TYPE,
747: override_flag QP_LIST_LINES.override_flag%TYPE,
748: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
749: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
750: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,

Line 747: override_flag QP_LIST_LINES.override_flag%TYPE,

743: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
744: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
745: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
746: operand QP_LIST_LINES.operand%TYPE,
747: override_flag QP_LIST_LINES.override_flag%TYPE,
748: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
749: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
750: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
751: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,

Line 748: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,

744: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
745: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
746: operand QP_LIST_LINES.operand%TYPE,
747: override_flag QP_LIST_LINES.override_flag%TYPE,
748: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
749: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
750: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
751: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
752: start_date_active QP_LIST_LINES.start_date_active%TYPE,

Line 749: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,

745: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
746: operand QP_LIST_LINES.operand%TYPE,
747: override_flag QP_LIST_LINES.override_flag%TYPE,
748: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
749: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
750: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
751: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
752: start_date_active QP_LIST_LINES.start_date_active%TYPE,
753: end_date_active QP_LIST_LINES.end_date_active%TYPE,

Line 750: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,

746: operand QP_LIST_LINES.operand%TYPE,
747: override_flag QP_LIST_LINES.override_flag%TYPE,
748: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
749: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
750: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
751: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
752: start_date_active QP_LIST_LINES.start_date_active%TYPE,
753: end_date_active QP_LIST_LINES.end_date_active%TYPE,
754: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,

Line 751: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,

747: override_flag QP_LIST_LINES.override_flag%TYPE,
748: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
749: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
750: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
751: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
752: start_date_active QP_LIST_LINES.start_date_active%TYPE,
753: end_date_active QP_LIST_LINES.end_date_active%TYPE,
754: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
755: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,

Line 752: start_date_active QP_LIST_LINES.start_date_active%TYPE,

748: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
749: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
750: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
751: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
752: start_date_active QP_LIST_LINES.start_date_active%TYPE,
753: end_date_active QP_LIST_LINES.end_date_active%TYPE,
754: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
755: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
756: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,

Line 753: end_date_active QP_LIST_LINES.end_date_active%TYPE,

749: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
750: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
751: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
752: start_date_active QP_LIST_LINES.start_date_active%TYPE,
753: end_date_active QP_LIST_LINES.end_date_active%TYPE,
754: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
755: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
756: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
757: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,

Line 754: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,

750: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
751: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
752: start_date_active QP_LIST_LINES.start_date_active%TYPE,
753: end_date_active QP_LIST_LINES.end_date_active%TYPE,
754: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
755: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
756: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
757: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
758: list_line_no QP_LIST_LINES.list_line_no%TYPE,

Line 755: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,

751: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
752: start_date_active QP_LIST_LINES.start_date_active%TYPE,
753: end_date_active QP_LIST_LINES.end_date_active%TYPE,
754: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
755: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
756: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
757: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
758: list_line_no QP_LIST_LINES.list_line_no%TYPE,
759: product_precedence QP_LIST_LINES.product_precedence%TYPE,

Line 756: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,

752: start_date_active QP_LIST_LINES.start_date_active%TYPE,
753: end_date_active QP_LIST_LINES.end_date_active%TYPE,
754: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
755: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
756: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
757: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
758: list_line_no QP_LIST_LINES.list_line_no%TYPE,
759: product_precedence QP_LIST_LINES.product_precedence%TYPE,
760: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,

Line 757: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,

753: end_date_active QP_LIST_LINES.end_date_active%TYPE,
754: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
755: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
756: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
757: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
758: list_line_no QP_LIST_LINES.list_line_no%TYPE,
759: product_precedence QP_LIST_LINES.product_precedence%TYPE,
760: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
761: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,

Line 758: list_line_no QP_LIST_LINES.list_line_no%TYPE,

754: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
755: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
756: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
757: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
758: list_line_no QP_LIST_LINES.list_line_no%TYPE,
759: product_precedence QP_LIST_LINES.product_precedence%TYPE,
760: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
761: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
762: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,

Line 759: product_precedence QP_LIST_LINES.product_precedence%TYPE,

755: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
756: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
757: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
758: list_line_no QP_LIST_LINES.list_line_no%TYPE,
759: product_precedence QP_LIST_LINES.product_precedence%TYPE,
760: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
761: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
762: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
763: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,

Line 760: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,

756: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
757: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
758: list_line_no QP_LIST_LINES.list_line_no%TYPE,
759: product_precedence QP_LIST_LINES.product_precedence%TYPE,
760: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
761: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
762: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
763: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
764: expiration_date QP_LIST_LINES.expiration_date%TYPE,

Line 761: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,

757: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
758: list_line_no QP_LIST_LINES.list_line_no%TYPE,
759: product_precedence QP_LIST_LINES.product_precedence%TYPE,
760: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
761: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
762: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
763: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
764: expiration_date QP_LIST_LINES.expiration_date%TYPE,
765: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,

Line 762: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,

758: list_line_no QP_LIST_LINES.list_line_no%TYPE,
759: product_precedence QP_LIST_LINES.product_precedence%TYPE,
760: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
761: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
762: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
763: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
764: expiration_date QP_LIST_LINES.expiration_date%TYPE,
765: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
766: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,

Line 763: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,

759: product_precedence QP_LIST_LINES.product_precedence%TYPE,
760: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
761: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
762: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
763: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
764: expiration_date QP_LIST_LINES.expiration_date%TYPE,
765: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
766: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
767: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,

Line 764: expiration_date QP_LIST_LINES.expiration_date%TYPE,

760: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
761: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
762: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
763: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
764: expiration_date QP_LIST_LINES.expiration_date%TYPE,
765: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
766: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
767: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
768: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,

Line 765: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,

761: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
762: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
763: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
764: expiration_date QP_LIST_LINES.expiration_date%TYPE,
765: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
766: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
767: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
768: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
769: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,

Line 766: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,

762: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
763: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
764: expiration_date QP_LIST_LINES.expiration_date%TYPE,
765: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
766: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
767: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
768: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
769: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
770: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,

Line 767: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,

763: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
764: expiration_date QP_LIST_LINES.expiration_date%TYPE,
765: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
766: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
767: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
768: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
769: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
770: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
771: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,

Line 768: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,

764: expiration_date QP_LIST_LINES.expiration_date%TYPE,
765: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
766: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
767: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
768: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
769: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
770: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
771: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
772: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,

Line 769: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,

765: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
766: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
767: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
768: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
769: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
770: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
771: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
772: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
773: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,

Line 770: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,

766: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
767: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
768: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
769: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
770: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
771: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
772: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
773: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
774: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,

Line 771: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,

767: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
768: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
769: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
770: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
771: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
772: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
773: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
774: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
775: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,

Line 772: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,

768: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
769: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
770: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
771: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
772: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
773: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
774: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
775: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
776: recurring_value QP_LIST_LINES.recurring_value%TYPE,

Line 773: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,

769: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
770: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
771: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
772: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
773: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
774: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
775: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
776: recurring_value QP_LIST_LINES.recurring_value%TYPE,
777: LIST_PRICE_UOM_CODE QP_LIST_LINES.LIST_PRICE_UOM_CODE%TYPE,

Line 774: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,

770: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
771: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
772: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
773: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
774: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
775: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
776: recurring_value QP_LIST_LINES.recurring_value%TYPE,
777: LIST_PRICE_UOM_CODE QP_LIST_LINES.LIST_PRICE_UOM_CODE%TYPE,
778: BASE_QTY QP_LIST_LINES.BASE_QTY%TYPE,

Line 775: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,

771: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
772: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
773: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
774: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
775: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
776: recurring_value QP_LIST_LINES.recurring_value%TYPE,
777: LIST_PRICE_UOM_CODE QP_LIST_LINES.LIST_PRICE_UOM_CODE%TYPE,
778: BASE_QTY QP_LIST_LINES.BASE_QTY%TYPE,
779: BASE_UOM_CODE QP_LIST_LINES.BASE_UOM_CODE%TYPE,

Line 776: recurring_value QP_LIST_LINES.recurring_value%TYPE,

772: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
773: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
774: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
775: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
776: recurring_value QP_LIST_LINES.recurring_value%TYPE,
777: LIST_PRICE_UOM_CODE QP_LIST_LINES.LIST_PRICE_UOM_CODE%TYPE,
778: BASE_QTY QP_LIST_LINES.BASE_QTY%TYPE,
779: BASE_UOM_CODE QP_LIST_LINES.BASE_UOM_CODE%TYPE,
780: ACCRUAL_QTY QP_LIST_LINES.ACCRUAL_QTY%TYPE,

Line 777: LIST_PRICE_UOM_CODE QP_LIST_LINES.LIST_PRICE_UOM_CODE%TYPE,

773: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
774: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
775: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
776: recurring_value QP_LIST_LINES.recurring_value%TYPE,
777: LIST_PRICE_UOM_CODE QP_LIST_LINES.LIST_PRICE_UOM_CODE%TYPE,
778: BASE_QTY QP_LIST_LINES.BASE_QTY%TYPE,
779: BASE_UOM_CODE QP_LIST_LINES.BASE_UOM_CODE%TYPE,
780: ACCRUAL_QTY QP_LIST_LINES.ACCRUAL_QTY%TYPE,
781: ACCRUAL_UOM_CODE QP_LIST_LINES.ACCRUAL_UOM_CODE%TYPE,

Line 778: BASE_QTY QP_LIST_LINES.BASE_QTY%TYPE,

774: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
775: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
776: recurring_value QP_LIST_LINES.recurring_value%TYPE,
777: LIST_PRICE_UOM_CODE QP_LIST_LINES.LIST_PRICE_UOM_CODE%TYPE,
778: BASE_QTY QP_LIST_LINES.BASE_QTY%TYPE,
779: BASE_UOM_CODE QP_LIST_LINES.BASE_UOM_CODE%TYPE,
780: ACCRUAL_QTY QP_LIST_LINES.ACCRUAL_QTY%TYPE,
781: ACCRUAL_UOM_CODE QP_LIST_LINES.ACCRUAL_UOM_CODE%TYPE,
782: RECURRING_FLAG QP_LIST_LINES.RECURRING_FLAG%TYPE,

Line 779: BASE_UOM_CODE QP_LIST_LINES.BASE_UOM_CODE%TYPE,

775: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
776: recurring_value QP_LIST_LINES.recurring_value%TYPE,
777: LIST_PRICE_UOM_CODE QP_LIST_LINES.LIST_PRICE_UOM_CODE%TYPE,
778: BASE_QTY QP_LIST_LINES.BASE_QTY%TYPE,
779: BASE_UOM_CODE QP_LIST_LINES.BASE_UOM_CODE%TYPE,
780: ACCRUAL_QTY QP_LIST_LINES.ACCRUAL_QTY%TYPE,
781: ACCRUAL_UOM_CODE QP_LIST_LINES.ACCRUAL_UOM_CODE%TYPE,
782: RECURRING_FLAG QP_LIST_LINES.RECURRING_FLAG%TYPE,
783: LIMIT_EXISTS_FLAG QP_LIST_LINES.LIMIT_EXISTS_FLAG%TYPE,

Line 780: ACCRUAL_QTY QP_LIST_LINES.ACCRUAL_QTY%TYPE,

776: recurring_value QP_LIST_LINES.recurring_value%TYPE,
777: LIST_PRICE_UOM_CODE QP_LIST_LINES.LIST_PRICE_UOM_CODE%TYPE,
778: BASE_QTY QP_LIST_LINES.BASE_QTY%TYPE,
779: BASE_UOM_CODE QP_LIST_LINES.BASE_UOM_CODE%TYPE,
780: ACCRUAL_QTY QP_LIST_LINES.ACCRUAL_QTY%TYPE,
781: ACCRUAL_UOM_CODE QP_LIST_LINES.ACCRUAL_UOM_CODE%TYPE,
782: RECURRING_FLAG QP_LIST_LINES.RECURRING_FLAG%TYPE,
783: LIMIT_EXISTS_FLAG QP_LIST_LINES.LIMIT_EXISTS_FLAG%TYPE,
784: GROUP_COUNT QP_LIST_LINES.GROUP_COUNT%TYPE

Line 781: ACCRUAL_UOM_CODE QP_LIST_LINES.ACCRUAL_UOM_CODE%TYPE,

777: LIST_PRICE_UOM_CODE QP_LIST_LINES.LIST_PRICE_UOM_CODE%TYPE,
778: BASE_QTY QP_LIST_LINES.BASE_QTY%TYPE,
779: BASE_UOM_CODE QP_LIST_LINES.BASE_UOM_CODE%TYPE,
780: ACCRUAL_QTY QP_LIST_LINES.ACCRUAL_QTY%TYPE,
781: ACCRUAL_UOM_CODE QP_LIST_LINES.ACCRUAL_UOM_CODE%TYPE,
782: RECURRING_FLAG QP_LIST_LINES.RECURRING_FLAG%TYPE,
783: LIMIT_EXISTS_FLAG QP_LIST_LINES.LIMIT_EXISTS_FLAG%TYPE,
784: GROUP_COUNT QP_LIST_LINES.GROUP_COUNT%TYPE
785: ,NET_AMOUNT_FLAG QP_LIST_LINES.NET_AMOUNT_FLAG%TYPE

Line 782: RECURRING_FLAG QP_LIST_LINES.RECURRING_FLAG%TYPE,

778: BASE_QTY QP_LIST_LINES.BASE_QTY%TYPE,
779: BASE_UOM_CODE QP_LIST_LINES.BASE_UOM_CODE%TYPE,
780: ACCRUAL_QTY QP_LIST_LINES.ACCRUAL_QTY%TYPE,
781: ACCRUAL_UOM_CODE QP_LIST_LINES.ACCRUAL_UOM_CODE%TYPE,
782: RECURRING_FLAG QP_LIST_LINES.RECURRING_FLAG%TYPE,
783: LIMIT_EXISTS_FLAG QP_LIST_LINES.LIMIT_EXISTS_FLAG%TYPE,
784: GROUP_COUNT QP_LIST_LINES.GROUP_COUNT%TYPE
785: ,NET_AMOUNT_FLAG QP_LIST_LINES.NET_AMOUNT_FLAG%TYPE
786: ,CUSTOMER_ITEM_ID QP_LIST_LINES.CUSTOMER_ITEM_ID%TYPE

Line 783: LIMIT_EXISTS_FLAG QP_LIST_LINES.LIMIT_EXISTS_FLAG%TYPE,

779: BASE_UOM_CODE QP_LIST_LINES.BASE_UOM_CODE%TYPE,
780: ACCRUAL_QTY QP_LIST_LINES.ACCRUAL_QTY%TYPE,
781: ACCRUAL_UOM_CODE QP_LIST_LINES.ACCRUAL_UOM_CODE%TYPE,
782: RECURRING_FLAG QP_LIST_LINES.RECURRING_FLAG%TYPE,
783: LIMIT_EXISTS_FLAG QP_LIST_LINES.LIMIT_EXISTS_FLAG%TYPE,
784: GROUP_COUNT QP_LIST_LINES.GROUP_COUNT%TYPE
785: ,NET_AMOUNT_FLAG QP_LIST_LINES.NET_AMOUNT_FLAG%TYPE
786: ,CUSTOMER_ITEM_ID QP_LIST_LINES.CUSTOMER_ITEM_ID%TYPE
787: ,ACCUM_CONTEXT QP_LIST_LINES.ACCUM_CONTEXT%TYPE

Line 784: GROUP_COUNT QP_LIST_LINES.GROUP_COUNT%TYPE

780: ACCRUAL_QTY QP_LIST_LINES.ACCRUAL_QTY%TYPE,
781: ACCRUAL_UOM_CODE QP_LIST_LINES.ACCRUAL_UOM_CODE%TYPE,
782: RECURRING_FLAG QP_LIST_LINES.RECURRING_FLAG%TYPE,
783: LIMIT_EXISTS_FLAG QP_LIST_LINES.LIMIT_EXISTS_FLAG%TYPE,
784: GROUP_COUNT QP_LIST_LINES.GROUP_COUNT%TYPE
785: ,NET_AMOUNT_FLAG QP_LIST_LINES.NET_AMOUNT_FLAG%TYPE
786: ,CUSTOMER_ITEM_ID QP_LIST_LINES.CUSTOMER_ITEM_ID%TYPE
787: ,ACCUM_CONTEXT QP_LIST_LINES.ACCUM_CONTEXT%TYPE
788: ,ACCUM_ATTRIBUTE QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE

Line 785: ,NET_AMOUNT_FLAG QP_LIST_LINES.NET_AMOUNT_FLAG%TYPE

781: ACCRUAL_UOM_CODE QP_LIST_LINES.ACCRUAL_UOM_CODE%TYPE,
782: RECURRING_FLAG QP_LIST_LINES.RECURRING_FLAG%TYPE,
783: LIMIT_EXISTS_FLAG QP_LIST_LINES.LIMIT_EXISTS_FLAG%TYPE,
784: GROUP_COUNT QP_LIST_LINES.GROUP_COUNT%TYPE
785: ,NET_AMOUNT_FLAG QP_LIST_LINES.NET_AMOUNT_FLAG%TYPE
786: ,CUSTOMER_ITEM_ID QP_LIST_LINES.CUSTOMER_ITEM_ID%TYPE
787: ,ACCUM_CONTEXT QP_LIST_LINES.ACCUM_CONTEXT%TYPE
788: ,ACCUM_ATTRIBUTE QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE
789: ,ACCUM_ATTR_RUN_SRC_FLAG QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE

Line 786: ,CUSTOMER_ITEM_ID QP_LIST_LINES.CUSTOMER_ITEM_ID%TYPE

782: RECURRING_FLAG QP_LIST_LINES.RECURRING_FLAG%TYPE,
783: LIMIT_EXISTS_FLAG QP_LIST_LINES.LIMIT_EXISTS_FLAG%TYPE,
784: GROUP_COUNT QP_LIST_LINES.GROUP_COUNT%TYPE
785: ,NET_AMOUNT_FLAG QP_LIST_LINES.NET_AMOUNT_FLAG%TYPE
786: ,CUSTOMER_ITEM_ID QP_LIST_LINES.CUSTOMER_ITEM_ID%TYPE
787: ,ACCUM_CONTEXT QP_LIST_LINES.ACCUM_CONTEXT%TYPE
788: ,ACCUM_ATTRIBUTE QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE
789: ,ACCUM_ATTR_RUN_SRC_FLAG QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE
790: ,BREAK_UOM_CODE QP_LIST_LINES.BREAK_UOM_CODE%TYPE

Line 787: ,ACCUM_CONTEXT QP_LIST_LINES.ACCUM_CONTEXT%TYPE

783: LIMIT_EXISTS_FLAG QP_LIST_LINES.LIMIT_EXISTS_FLAG%TYPE,
784: GROUP_COUNT QP_LIST_LINES.GROUP_COUNT%TYPE
785: ,NET_AMOUNT_FLAG QP_LIST_LINES.NET_AMOUNT_FLAG%TYPE
786: ,CUSTOMER_ITEM_ID QP_LIST_LINES.CUSTOMER_ITEM_ID%TYPE
787: ,ACCUM_CONTEXT QP_LIST_LINES.ACCUM_CONTEXT%TYPE
788: ,ACCUM_ATTRIBUTE QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE
789: ,ACCUM_ATTR_RUN_SRC_FLAG QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE
790: ,BREAK_UOM_CODE QP_LIST_LINES.BREAK_UOM_CODE%TYPE
791: ,BREAK_UOM_CONTEXT QP_LIST_LINES.BREAK_UOM_CONTEXT%TYPE

Line 788: ,ACCUM_ATTRIBUTE QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE

784: GROUP_COUNT QP_LIST_LINES.GROUP_COUNT%TYPE
785: ,NET_AMOUNT_FLAG QP_LIST_LINES.NET_AMOUNT_FLAG%TYPE
786: ,CUSTOMER_ITEM_ID QP_LIST_LINES.CUSTOMER_ITEM_ID%TYPE
787: ,ACCUM_CONTEXT QP_LIST_LINES.ACCUM_CONTEXT%TYPE
788: ,ACCUM_ATTRIBUTE QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE
789: ,ACCUM_ATTR_RUN_SRC_FLAG QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE
790: ,BREAK_UOM_CODE QP_LIST_LINES.BREAK_UOM_CODE%TYPE
791: ,BREAK_UOM_CONTEXT QP_LIST_LINES.BREAK_UOM_CONTEXT%TYPE
792: ,BREAK_UOM_ATTRIBUTE QP_LIST_LINES.BREAK_UOM_ATTRIBUTE%TYPE

Line 789: ,ACCUM_ATTR_RUN_SRC_FLAG QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE

785: ,NET_AMOUNT_FLAG QP_LIST_LINES.NET_AMOUNT_FLAG%TYPE
786: ,CUSTOMER_ITEM_ID QP_LIST_LINES.CUSTOMER_ITEM_ID%TYPE
787: ,ACCUM_CONTEXT QP_LIST_LINES.ACCUM_CONTEXT%TYPE
788: ,ACCUM_ATTRIBUTE QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE
789: ,ACCUM_ATTR_RUN_SRC_FLAG QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE
790: ,BREAK_UOM_CODE QP_LIST_LINES.BREAK_UOM_CODE%TYPE
791: ,BREAK_UOM_CONTEXT QP_LIST_LINES.BREAK_UOM_CONTEXT%TYPE
792: ,BREAK_UOM_ATTRIBUTE QP_LIST_LINES.BREAK_UOM_ATTRIBUTE%TYPE
793: ,PATTERN_ID QP_LIST_LINES.PATTERN_ID%TYPE

Line 790: ,BREAK_UOM_CODE QP_LIST_LINES.BREAK_UOM_CODE%TYPE

786: ,CUSTOMER_ITEM_ID QP_LIST_LINES.CUSTOMER_ITEM_ID%TYPE
787: ,ACCUM_CONTEXT QP_LIST_LINES.ACCUM_CONTEXT%TYPE
788: ,ACCUM_ATTRIBUTE QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE
789: ,ACCUM_ATTR_RUN_SRC_FLAG QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE
790: ,BREAK_UOM_CODE QP_LIST_LINES.BREAK_UOM_CODE%TYPE
791: ,BREAK_UOM_CONTEXT QP_LIST_LINES.BREAK_UOM_CONTEXT%TYPE
792: ,BREAK_UOM_ATTRIBUTE QP_LIST_LINES.BREAK_UOM_ATTRIBUTE%TYPE
793: ,PATTERN_ID QP_LIST_LINES.PATTERN_ID%TYPE
794: ,PRODUCT_UOM_CODE QP_LIST_LINES.PRODUCT_UOM_CODE%TYPE

Line 791: ,BREAK_UOM_CONTEXT QP_LIST_LINES.BREAK_UOM_CONTEXT%TYPE

787: ,ACCUM_CONTEXT QP_LIST_LINES.ACCUM_CONTEXT%TYPE
788: ,ACCUM_ATTRIBUTE QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE
789: ,ACCUM_ATTR_RUN_SRC_FLAG QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE
790: ,BREAK_UOM_CODE QP_LIST_LINES.BREAK_UOM_CODE%TYPE
791: ,BREAK_UOM_CONTEXT QP_LIST_LINES.BREAK_UOM_CONTEXT%TYPE
792: ,BREAK_UOM_ATTRIBUTE QP_LIST_LINES.BREAK_UOM_ATTRIBUTE%TYPE
793: ,PATTERN_ID QP_LIST_LINES.PATTERN_ID%TYPE
794: ,PRODUCT_UOM_CODE QP_LIST_LINES.PRODUCT_UOM_CODE%TYPE
795: ,PRICING_ATTRIBUTE_COUNT QP_LIST_LINES.PRICING_ATTRIBUTE_COUNT%TYPE

Line 792: ,BREAK_UOM_ATTRIBUTE QP_LIST_LINES.BREAK_UOM_ATTRIBUTE%TYPE

788: ,ACCUM_ATTRIBUTE QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE
789: ,ACCUM_ATTR_RUN_SRC_FLAG QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE
790: ,BREAK_UOM_CODE QP_LIST_LINES.BREAK_UOM_CODE%TYPE
791: ,BREAK_UOM_CONTEXT QP_LIST_LINES.BREAK_UOM_CONTEXT%TYPE
792: ,BREAK_UOM_ATTRIBUTE QP_LIST_LINES.BREAK_UOM_ATTRIBUTE%TYPE
793: ,PATTERN_ID QP_LIST_LINES.PATTERN_ID%TYPE
794: ,PRODUCT_UOM_CODE QP_LIST_LINES.PRODUCT_UOM_CODE%TYPE
795: ,PRICING_ATTRIBUTE_COUNT QP_LIST_LINES.PRICING_ATTRIBUTE_COUNT%TYPE
796: ,HASH_KEY QP_LIST_LINES.HASH_KEY%TYPE

Line 793: ,PATTERN_ID QP_LIST_LINES.PATTERN_ID%TYPE

789: ,ACCUM_ATTR_RUN_SRC_FLAG QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE
790: ,BREAK_UOM_CODE QP_LIST_LINES.BREAK_UOM_CODE%TYPE
791: ,BREAK_UOM_CONTEXT QP_LIST_LINES.BREAK_UOM_CONTEXT%TYPE
792: ,BREAK_UOM_ATTRIBUTE QP_LIST_LINES.BREAK_UOM_ATTRIBUTE%TYPE
793: ,PATTERN_ID QP_LIST_LINES.PATTERN_ID%TYPE
794: ,PRODUCT_UOM_CODE QP_LIST_LINES.PRODUCT_UOM_CODE%TYPE
795: ,PRICING_ATTRIBUTE_COUNT QP_LIST_LINES.PRICING_ATTRIBUTE_COUNT%TYPE
796: ,HASH_KEY QP_LIST_LINES.HASH_KEY%TYPE
797: ,CACHE_KEY QP_LIST_LINES.CACHE_KEY%TYPE

Line 794: ,PRODUCT_UOM_CODE QP_LIST_LINES.PRODUCT_UOM_CODE%TYPE

790: ,BREAK_UOM_CODE QP_LIST_LINES.BREAK_UOM_CODE%TYPE
791: ,BREAK_UOM_CONTEXT QP_LIST_LINES.BREAK_UOM_CONTEXT%TYPE
792: ,BREAK_UOM_ATTRIBUTE QP_LIST_LINES.BREAK_UOM_ATTRIBUTE%TYPE
793: ,PATTERN_ID QP_LIST_LINES.PATTERN_ID%TYPE
794: ,PRODUCT_UOM_CODE QP_LIST_LINES.PRODUCT_UOM_CODE%TYPE
795: ,PRICING_ATTRIBUTE_COUNT QP_LIST_LINES.PRICING_ATTRIBUTE_COUNT%TYPE
796: ,HASH_KEY QP_LIST_LINES.HASH_KEY%TYPE
797: ,CACHE_KEY QP_LIST_LINES.CACHE_KEY%TYPE
798: );

Line 795: ,PRICING_ATTRIBUTE_COUNT QP_LIST_LINES.PRICING_ATTRIBUTE_COUNT%TYPE

791: ,BREAK_UOM_CONTEXT QP_LIST_LINES.BREAK_UOM_CONTEXT%TYPE
792: ,BREAK_UOM_ATTRIBUTE QP_LIST_LINES.BREAK_UOM_ATTRIBUTE%TYPE
793: ,PATTERN_ID QP_LIST_LINES.PATTERN_ID%TYPE
794: ,PRODUCT_UOM_CODE QP_LIST_LINES.PRODUCT_UOM_CODE%TYPE
795: ,PRICING_ATTRIBUTE_COUNT QP_LIST_LINES.PRICING_ATTRIBUTE_COUNT%TYPE
796: ,HASH_KEY QP_LIST_LINES.HASH_KEY%TYPE
797: ,CACHE_KEY QP_LIST_LINES.CACHE_KEY%TYPE
798: );
799:

Line 796: ,HASH_KEY QP_LIST_LINES.HASH_KEY%TYPE

792: ,BREAK_UOM_ATTRIBUTE QP_LIST_LINES.BREAK_UOM_ATTRIBUTE%TYPE
793: ,PATTERN_ID QP_LIST_LINES.PATTERN_ID%TYPE
794: ,PRODUCT_UOM_CODE QP_LIST_LINES.PRODUCT_UOM_CODE%TYPE
795: ,PRICING_ATTRIBUTE_COUNT QP_LIST_LINES.PRICING_ATTRIBUTE_COUNT%TYPE
796: ,HASH_KEY QP_LIST_LINES.HASH_KEY%TYPE
797: ,CACHE_KEY QP_LIST_LINES.CACHE_KEY%TYPE
798: );
799:
800: l_mapping_tbl mapping_tbl;

Line 797: ,CACHE_KEY QP_LIST_LINES.CACHE_KEY%TYPE

793: ,PATTERN_ID QP_LIST_LINES.PATTERN_ID%TYPE
794: ,PRODUCT_UOM_CODE QP_LIST_LINES.PRODUCT_UOM_CODE%TYPE
795: ,PRICING_ATTRIBUTE_COUNT QP_LIST_LINES.PRICING_ATTRIBUTE_COUNT%TYPE
796: ,HASH_KEY QP_LIST_LINES.HASH_KEY%TYPE
797: ,CACHE_KEY QP_LIST_LINES.CACHE_KEY%TYPE
798: );
799:
800: l_mapping_tbl mapping_tbl;
801: l_select_stmt VARCHAR2(9000);

Line 802: l_qp_list_lines_rec QP_LIST_LINES_REC;

798: );
799:
800: l_mapping_tbl mapping_tbl;
801: l_select_stmt VARCHAR2(9000);
802: l_qp_list_lines_rec QP_LIST_LINES_REC;
803: l_context VARCHAR2(30);
804: l_attribute VARCHAR2(30);
805: l_count NUMBER := 0;
806:

Line 807: TYPE l_list_line_id_tbl_type IS TABLE OF QP_LIST_LINES.list_line_id%TYPE INDEX BY BINARY_INTEGER; --bug#13045009

803: l_context VARCHAR2(30);
804: l_attribute VARCHAR2(30);
805: l_count NUMBER := 0;
806:
807: TYPE l_list_line_id_tbl_type IS TABLE OF QP_LIST_LINES.list_line_id%TYPE INDEX BY BINARY_INTEGER; --bug#13045009
808:
809: l_list_line_id_tbl l_list_line_id_tbl_type; --bug#13045009
810: l_id_count NUMBER := 0; --bug#13045009
811:

Line 831: qp_list_lines_cv lines_cur_typ;

827: l_min_date date := to_date('01/01/1900','DD/MM/YYYY');
828: l_max_date date := to_date('31/12/9999','DD/MM/YYYY');
829:
830: TYPE lines_cur_typ IS REF CURSOR;
831: qp_list_lines_cv lines_cur_typ;
832:
833: CURSOR qp_pricing_attributes_cur(p_from_list_line_id NUMBER)
834: IS
835: SELECT *

Line 999: FROM qp_list_lines q

995: ,q.PRODUCT_UOM_CODE
996: ,q.PRICING_ATTRIBUTE_COUNT
997: ,q.HASH_KEY
998: ,q.CACHE_KEY
999: FROM qp_list_lines q
1000: WHERE q.list_header_id = :hdr
1001: and nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||'''))
1002: >=nvl(trunc(fnd_date.canonical_to_date(:sdat)),
1003: nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||''')))

Line 1312: OPEN qp_list_lines_cv FOR l_select_stmt USING p_entity,p_start_date_active,p_end_date_active,p_created_by,p_creation_date;

1308: FROM qp_rltd_modifiers a
1309: WHERE a.to_rltd_modifier_id = q.list_line_id)';
1310: END IF; --all_lines end
1311:
1312: OPEN qp_list_lines_cv FOR l_select_stmt USING p_entity,p_start_date_active,p_end_date_active,p_created_by,p_creation_date;
1313: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
1314: if(qp_list_lines_cv%NOTFOUND) THEN -- No list lines found satisfying the search criteria entered.
1315: CLOSE qp_list_lines_cv;
1316: RAISE NO_DATA_FOUND;

Line 1313: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;

1309: WHERE a.to_rltd_modifier_id = q.list_line_id)';
1310: END IF; --all_lines end
1311:
1312: OPEN qp_list_lines_cv FOR l_select_stmt USING p_entity,p_start_date_active,p_end_date_active,p_created_by,p_creation_date;
1313: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
1314: if(qp_list_lines_cv%NOTFOUND) THEN -- No list lines found satisfying the search criteria entered.
1315: CLOSE qp_list_lines_cv;
1316: RAISE NO_DATA_FOUND;
1317: end if;

Line 1314: if(qp_list_lines_cv%NOTFOUND) THEN -- No list lines found satisfying the search criteria entered.

1310: END IF; --all_lines end
1311:
1312: OPEN qp_list_lines_cv FOR l_select_stmt USING p_entity,p_start_date_active,p_end_date_active,p_created_by,p_creation_date;
1313: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
1314: if(qp_list_lines_cv%NOTFOUND) THEN -- No list lines found satisfying the search criteria entered.
1315: CLOSE qp_list_lines_cv;
1316: RAISE NO_DATA_FOUND;
1317: end if;
1318: CLOSE qp_list_lines_cv;

Line 1315: CLOSE qp_list_lines_cv;

1311:
1312: OPEN qp_list_lines_cv FOR l_select_stmt USING p_entity,p_start_date_active,p_end_date_active,p_created_by,p_creation_date;
1313: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
1314: if(qp_list_lines_cv%NOTFOUND) THEN -- No list lines found satisfying the search criteria entered.
1315: CLOSE qp_list_lines_cv;
1316: RAISE NO_DATA_FOUND;
1317: end if;
1318: CLOSE qp_list_lines_cv;
1319:

Line 1318: CLOSE qp_list_lines_cv;

1314: if(qp_list_lines_cv%NOTFOUND) THEN -- No list lines found satisfying the search criteria entered.
1315: CLOSE qp_list_lines_cv;
1316: RAISE NO_DATA_FOUND;
1317: end if;
1318: CLOSE qp_list_lines_cv;
1319:
1320: /** Following code inserts pricing entity list header information into QP_ARCH_LIST_HEADERS_B **/
1321:
1322: INSERT INTO QP_ARCH_LIST_HEADERS_B

Line 1771: OPEN qp_list_lines_cv FOR l_select_stmt USING p_entity,p_start_date_active,p_end_date_active,p_created_by,p_creation_date;

1767:
1768: END IF;
1769:
1770: /** Following code Archives price list lines information.**/
1771: OPEN qp_list_lines_cv FOR l_select_stmt USING p_entity,p_start_date_active,p_end_date_active,p_created_by,p_creation_date;
1772: LOOP
1773: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
1774: EXIT WHEN qp_list_lines_cv%NOTFOUND;
1775:

Line 1773: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;

1769:
1770: /** Following code Archives price list lines information.**/
1771: OPEN qp_list_lines_cv FOR l_select_stmt USING p_entity,p_start_date_active,p_end_date_active,p_created_by,p_creation_date;
1772: LOOP
1773: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
1774: EXIT WHEN qp_list_lines_cv%NOTFOUND;
1775:
1776: l_insert_flag := 'N'; --Reset the flag
1777:

Line 1774: EXIT WHEN qp_list_lines_cv%NOTFOUND;

1770: /** Following code Archives price list lines information.**/
1771: OPEN qp_list_lines_cv FOR l_select_stmt USING p_entity,p_start_date_active,p_end_date_active,p_created_by,p_creation_date;
1772: LOOP
1773: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
1774: EXIT WHEN qp_list_lines_cv%NOTFOUND;
1775:
1776: l_insert_flag := 'N'; --Reset the flag
1777:
1778: --Check if limit exists

Line 1779: IF nvl(l_qp_list_lines_rec.LIMIT_EXISTS_FLAG,'N') = 'N' THEN

1775:
1776: l_insert_flag := 'N'; --Reset the flag
1777:
1778: --Check if limit exists
1779: IF nvl(l_qp_list_lines_rec.LIMIT_EXISTS_FLAG,'N') = 'N' THEN
1780: l_insert_flag :='Y';
1781:
1782: -- Check if line part of a formula
1783: SELECT count(*) into l_cnt

Line 1786: AND PRICE_LIST_LINE_ID=l_qp_list_lines_rec.list_line_id;

1782: -- Check if line part of a formula
1783: SELECT count(*) into l_cnt
1784: FROM QP_PRICE_FORMULA_LINES
1785: WHERE PRICE_FORMULA_LINE_TYPE_CODE = 'PLL'
1786: AND PRICE_LIST_LINE_ID=l_qp_list_lines_rec.list_line_id;
1787:
1788: IF l_cnt=0 THEN
1789: l_insert_flag :='Y';
1790: ELSE

Line 1792: fnd_file.put_line(FND_FILE.LOG,'Price List line used in formula.Do not archive : '||l_qp_list_lines_rec.list_line_id);

1788: IF l_cnt=0 THEN
1789: l_insert_flag :='Y';
1790: ELSE
1791: l_insert_flag :='N';
1792: fnd_file.put_line(FND_FILE.LOG,'Price List line used in formula.Do not archive : '||l_qp_list_lines_rec.list_line_id);
1793: l_err_count := l_err_count+1;
1794: END IF;
1795:
1796: IF l_insert_flag ='Y' THEN

Line 1799: IF (l_qp_list_lines_rec.list_line_type_code = 'CIE') OR

1795:
1796: IF l_insert_flag ='Y' THEN
1797: --Check if line a Coupon or a Benefit line or a parent to the same
1798: IF l_list_type_code = 'PRO' or l_list_type_code = 'DEL' THEN
1799: IF (l_qp_list_lines_rec.list_line_type_code = 'CIE') OR
1800: LINE_EXISTS_IN_RLTD(l_qp_list_lines_rec.list_line_id) THEN
1801: l_insert_flag :='N';
1802: fnd_file.put_line(FND_FILE.LOG,'COUPON or related BENEFIT line.Do not archive : '||l_qp_list_lines_rec.list_line_id);
1803: l_err_count := l_err_count+1;

Line 1800: LINE_EXISTS_IN_RLTD(l_qp_list_lines_rec.list_line_id) THEN

1796: IF l_insert_flag ='Y' THEN
1797: --Check if line a Coupon or a Benefit line or a parent to the same
1798: IF l_list_type_code = 'PRO' or l_list_type_code = 'DEL' THEN
1799: IF (l_qp_list_lines_rec.list_line_type_code = 'CIE') OR
1800: LINE_EXISTS_IN_RLTD(l_qp_list_lines_rec.list_line_id) THEN
1801: l_insert_flag :='N';
1802: fnd_file.put_line(FND_FILE.LOG,'COUPON or related BENEFIT line.Do not archive : '||l_qp_list_lines_rec.list_line_id);
1803: l_err_count := l_err_count+1;
1804: END IF;

Line 1802: fnd_file.put_line(FND_FILE.LOG,'COUPON or related BENEFIT line.Do not archive : '||l_qp_list_lines_rec.list_line_id);

1798: IF l_list_type_code = 'PRO' or l_list_type_code = 'DEL' THEN
1799: IF (l_qp_list_lines_rec.list_line_type_code = 'CIE') OR
1800: LINE_EXISTS_IN_RLTD(l_qp_list_lines_rec.list_line_id) THEN
1801: l_insert_flag :='N';
1802: fnd_file.put_line(FND_FILE.LOG,'COUPON or related BENEFIT line.Do not archive : '||l_qp_list_lines_rec.list_line_id);
1803: l_err_count := l_err_count+1;
1804: END IF;
1805: END IF;
1806: END IF;

Line 1916: l_qp_list_lines_rec.list_line_id,

1912: ,ARCH_PURG_REQUEST_ID
1913: )
1914: VALUES
1915: (
1916: l_qp_list_lines_rec.list_line_id,
1917: l_qp_list_lines_rec.creation_date,
1918: l_qp_list_lines_rec.created_by,
1919: l_qp_list_lines_rec.last_update_date,
1920: l_qp_list_lines_rec.last_updated_by,

Line 1917: l_qp_list_lines_rec.creation_date,

1913: )
1914: VALUES
1915: (
1916: l_qp_list_lines_rec.list_line_id,
1917: l_qp_list_lines_rec.creation_date,
1918: l_qp_list_lines_rec.created_by,
1919: l_qp_list_lines_rec.last_update_date,
1920: l_qp_list_lines_rec.last_updated_by,
1921: l_qp_list_lines_rec.last_update_login,

Line 1918: l_qp_list_lines_rec.created_by,

1914: VALUES
1915: (
1916: l_qp_list_lines_rec.list_line_id,
1917: l_qp_list_lines_rec.creation_date,
1918: l_qp_list_lines_rec.created_by,
1919: l_qp_list_lines_rec.last_update_date,
1920: l_qp_list_lines_rec.last_updated_by,
1921: l_qp_list_lines_rec.last_update_login,
1922: l_qp_list_lines_rec.program_application_id,

Line 1919: l_qp_list_lines_rec.last_update_date,

1915: (
1916: l_qp_list_lines_rec.list_line_id,
1917: l_qp_list_lines_rec.creation_date,
1918: l_qp_list_lines_rec.created_by,
1919: l_qp_list_lines_rec.last_update_date,
1920: l_qp_list_lines_rec.last_updated_by,
1921: l_qp_list_lines_rec.last_update_login,
1922: l_qp_list_lines_rec.program_application_id,
1923: l_qp_list_lines_rec.program_id,

Line 1920: l_qp_list_lines_rec.last_updated_by,

1916: l_qp_list_lines_rec.list_line_id,
1917: l_qp_list_lines_rec.creation_date,
1918: l_qp_list_lines_rec.created_by,
1919: l_qp_list_lines_rec.last_update_date,
1920: l_qp_list_lines_rec.last_updated_by,
1921: l_qp_list_lines_rec.last_update_login,
1922: l_qp_list_lines_rec.program_application_id,
1923: l_qp_list_lines_rec.program_id,
1924: l_qp_list_lines_rec.program_update_date,

Line 1921: l_qp_list_lines_rec.last_update_login,

1917: l_qp_list_lines_rec.creation_date,
1918: l_qp_list_lines_rec.created_by,
1919: l_qp_list_lines_rec.last_update_date,
1920: l_qp_list_lines_rec.last_updated_by,
1921: l_qp_list_lines_rec.last_update_login,
1922: l_qp_list_lines_rec.program_application_id,
1923: l_qp_list_lines_rec.program_id,
1924: l_qp_list_lines_rec.program_update_date,
1925: l_qp_list_lines_rec.request_id,

Line 1922: l_qp_list_lines_rec.program_application_id,

1918: l_qp_list_lines_rec.created_by,
1919: l_qp_list_lines_rec.last_update_date,
1920: l_qp_list_lines_rec.last_updated_by,
1921: l_qp_list_lines_rec.last_update_login,
1922: l_qp_list_lines_rec.program_application_id,
1923: l_qp_list_lines_rec.program_id,
1924: l_qp_list_lines_rec.program_update_date,
1925: l_qp_list_lines_rec.request_id,
1926: p_entity,

Line 1923: l_qp_list_lines_rec.program_id,

1919: l_qp_list_lines_rec.last_update_date,
1920: l_qp_list_lines_rec.last_updated_by,
1921: l_qp_list_lines_rec.last_update_login,
1922: l_qp_list_lines_rec.program_application_id,
1923: l_qp_list_lines_rec.program_id,
1924: l_qp_list_lines_rec.program_update_date,
1925: l_qp_list_lines_rec.request_id,
1926: p_entity,
1927: l_qp_list_lines_rec.list_line_type_code,

Line 1924: l_qp_list_lines_rec.program_update_date,

1920: l_qp_list_lines_rec.last_updated_by,
1921: l_qp_list_lines_rec.last_update_login,
1922: l_qp_list_lines_rec.program_application_id,
1923: l_qp_list_lines_rec.program_id,
1924: l_qp_list_lines_rec.program_update_date,
1925: l_qp_list_lines_rec.request_id,
1926: p_entity,
1927: l_qp_list_lines_rec.list_line_type_code,
1928: l_qp_list_lines_rec.start_date_active,

Line 1925: l_qp_list_lines_rec.request_id,

1921: l_qp_list_lines_rec.last_update_login,
1922: l_qp_list_lines_rec.program_application_id,
1923: l_qp_list_lines_rec.program_id,
1924: l_qp_list_lines_rec.program_update_date,
1925: l_qp_list_lines_rec.request_id,
1926: p_entity,
1927: l_qp_list_lines_rec.list_line_type_code,
1928: l_qp_list_lines_rec.start_date_active,
1929: l_qp_list_lines_rec.end_date_active,

Line 1927: l_qp_list_lines_rec.list_line_type_code,

1923: l_qp_list_lines_rec.program_id,
1924: l_qp_list_lines_rec.program_update_date,
1925: l_qp_list_lines_rec.request_id,
1926: p_entity,
1927: l_qp_list_lines_rec.list_line_type_code,
1928: l_qp_list_lines_rec.start_date_active,
1929: l_qp_list_lines_rec.end_date_active,
1930: l_qp_list_lines_rec.automatic_flag,
1931: l_qp_list_lines_rec.modifier_level_code,

Line 1928: l_qp_list_lines_rec.start_date_active,

1924: l_qp_list_lines_rec.program_update_date,
1925: l_qp_list_lines_rec.request_id,
1926: p_entity,
1927: l_qp_list_lines_rec.list_line_type_code,
1928: l_qp_list_lines_rec.start_date_active,
1929: l_qp_list_lines_rec.end_date_active,
1930: l_qp_list_lines_rec.automatic_flag,
1931: l_qp_list_lines_rec.modifier_level_code,
1932: l_qp_list_lines_rec.list_price,

Line 1929: l_qp_list_lines_rec.end_date_active,

1925: l_qp_list_lines_rec.request_id,
1926: p_entity,
1927: l_qp_list_lines_rec.list_line_type_code,
1928: l_qp_list_lines_rec.start_date_active,
1929: l_qp_list_lines_rec.end_date_active,
1930: l_qp_list_lines_rec.automatic_flag,
1931: l_qp_list_lines_rec.modifier_level_code,
1932: l_qp_list_lines_rec.list_price,
1933: l_qp_list_lines_rec.primary_uom_flag,

Line 1930: l_qp_list_lines_rec.automatic_flag,

1926: p_entity,
1927: l_qp_list_lines_rec.list_line_type_code,
1928: l_qp_list_lines_rec.start_date_active,
1929: l_qp_list_lines_rec.end_date_active,
1930: l_qp_list_lines_rec.automatic_flag,
1931: l_qp_list_lines_rec.modifier_level_code,
1932: l_qp_list_lines_rec.list_price,
1933: l_qp_list_lines_rec.primary_uom_flag,
1934: l_qp_list_lines_rec.inventory_item_id,

Line 1931: l_qp_list_lines_rec.modifier_level_code,

1927: l_qp_list_lines_rec.list_line_type_code,
1928: l_qp_list_lines_rec.start_date_active,
1929: l_qp_list_lines_rec.end_date_active,
1930: l_qp_list_lines_rec.automatic_flag,
1931: l_qp_list_lines_rec.modifier_level_code,
1932: l_qp_list_lines_rec.list_price,
1933: l_qp_list_lines_rec.primary_uom_flag,
1934: l_qp_list_lines_rec.inventory_item_id,
1935: l_qp_list_lines_rec.organization_id,

Line 1932: l_qp_list_lines_rec.list_price,

1928: l_qp_list_lines_rec.start_date_active,
1929: l_qp_list_lines_rec.end_date_active,
1930: l_qp_list_lines_rec.automatic_flag,
1931: l_qp_list_lines_rec.modifier_level_code,
1932: l_qp_list_lines_rec.list_price,
1933: l_qp_list_lines_rec.primary_uom_flag,
1934: l_qp_list_lines_rec.inventory_item_id,
1935: l_qp_list_lines_rec.organization_id,
1936: l_qp_list_lines_rec.related_item_id,

Line 1933: l_qp_list_lines_rec.primary_uom_flag,

1929: l_qp_list_lines_rec.end_date_active,
1930: l_qp_list_lines_rec.automatic_flag,
1931: l_qp_list_lines_rec.modifier_level_code,
1932: l_qp_list_lines_rec.list_price,
1933: l_qp_list_lines_rec.primary_uom_flag,
1934: l_qp_list_lines_rec.inventory_item_id,
1935: l_qp_list_lines_rec.organization_id,
1936: l_qp_list_lines_rec.related_item_id,
1937: l_qp_list_lines_rec.relationship_type_id,

Line 1934: l_qp_list_lines_rec.inventory_item_id,

1930: l_qp_list_lines_rec.automatic_flag,
1931: l_qp_list_lines_rec.modifier_level_code,
1932: l_qp_list_lines_rec.list_price,
1933: l_qp_list_lines_rec.primary_uom_flag,
1934: l_qp_list_lines_rec.inventory_item_id,
1935: l_qp_list_lines_rec.organization_id,
1936: l_qp_list_lines_rec.related_item_id,
1937: l_qp_list_lines_rec.relationship_type_id,
1938: l_qp_list_lines_rec.substitution_context,

Line 1935: l_qp_list_lines_rec.organization_id,

1931: l_qp_list_lines_rec.modifier_level_code,
1932: l_qp_list_lines_rec.list_price,
1933: l_qp_list_lines_rec.primary_uom_flag,
1934: l_qp_list_lines_rec.inventory_item_id,
1935: l_qp_list_lines_rec.organization_id,
1936: l_qp_list_lines_rec.related_item_id,
1937: l_qp_list_lines_rec.relationship_type_id,
1938: l_qp_list_lines_rec.substitution_context,
1939: l_qp_list_lines_rec.substitution_attribute,

Line 1936: l_qp_list_lines_rec.related_item_id,

1932: l_qp_list_lines_rec.list_price,
1933: l_qp_list_lines_rec.primary_uom_flag,
1934: l_qp_list_lines_rec.inventory_item_id,
1935: l_qp_list_lines_rec.organization_id,
1936: l_qp_list_lines_rec.related_item_id,
1937: l_qp_list_lines_rec.relationship_type_id,
1938: l_qp_list_lines_rec.substitution_context,
1939: l_qp_list_lines_rec.substitution_attribute,
1940: l_qp_list_lines_rec.substitution_value,

Line 1937: l_qp_list_lines_rec.relationship_type_id,

1933: l_qp_list_lines_rec.primary_uom_flag,
1934: l_qp_list_lines_rec.inventory_item_id,
1935: l_qp_list_lines_rec.organization_id,
1936: l_qp_list_lines_rec.related_item_id,
1937: l_qp_list_lines_rec.relationship_type_id,
1938: l_qp_list_lines_rec.substitution_context,
1939: l_qp_list_lines_rec.substitution_attribute,
1940: l_qp_list_lines_rec.substitution_value,
1941: l_qp_list_lines_rec.revision,

Line 1938: l_qp_list_lines_rec.substitution_context,

1934: l_qp_list_lines_rec.inventory_item_id,
1935: l_qp_list_lines_rec.organization_id,
1936: l_qp_list_lines_rec.related_item_id,
1937: l_qp_list_lines_rec.relationship_type_id,
1938: l_qp_list_lines_rec.substitution_context,
1939: l_qp_list_lines_rec.substitution_attribute,
1940: l_qp_list_lines_rec.substitution_value,
1941: l_qp_list_lines_rec.revision,
1942: l_qp_list_lines_rec.revision_date,

Line 1939: l_qp_list_lines_rec.substitution_attribute,

1935: l_qp_list_lines_rec.organization_id,
1936: l_qp_list_lines_rec.related_item_id,
1937: l_qp_list_lines_rec.relationship_type_id,
1938: l_qp_list_lines_rec.substitution_context,
1939: l_qp_list_lines_rec.substitution_attribute,
1940: l_qp_list_lines_rec.substitution_value,
1941: l_qp_list_lines_rec.revision,
1942: l_qp_list_lines_rec.revision_date,
1943: l_qp_list_lines_rec.revision_reason_code,

Line 1940: l_qp_list_lines_rec.substitution_value,

1936: l_qp_list_lines_rec.related_item_id,
1937: l_qp_list_lines_rec.relationship_type_id,
1938: l_qp_list_lines_rec.substitution_context,
1939: l_qp_list_lines_rec.substitution_attribute,
1940: l_qp_list_lines_rec.substitution_value,
1941: l_qp_list_lines_rec.revision,
1942: l_qp_list_lines_rec.revision_date,
1943: l_qp_list_lines_rec.revision_reason_code,
1944: l_qp_list_lines_rec.context,

Line 1941: l_qp_list_lines_rec.revision,

1937: l_qp_list_lines_rec.relationship_type_id,
1938: l_qp_list_lines_rec.substitution_context,
1939: l_qp_list_lines_rec.substitution_attribute,
1940: l_qp_list_lines_rec.substitution_value,
1941: l_qp_list_lines_rec.revision,
1942: l_qp_list_lines_rec.revision_date,
1943: l_qp_list_lines_rec.revision_reason_code,
1944: l_qp_list_lines_rec.context,
1945: l_qp_list_lines_rec.attribute1,

Line 1942: l_qp_list_lines_rec.revision_date,

1938: l_qp_list_lines_rec.substitution_context,
1939: l_qp_list_lines_rec.substitution_attribute,
1940: l_qp_list_lines_rec.substitution_value,
1941: l_qp_list_lines_rec.revision,
1942: l_qp_list_lines_rec.revision_date,
1943: l_qp_list_lines_rec.revision_reason_code,
1944: l_qp_list_lines_rec.context,
1945: l_qp_list_lines_rec.attribute1,
1946: l_qp_list_lines_rec.attribute2,

Line 1943: l_qp_list_lines_rec.revision_reason_code,

1939: l_qp_list_lines_rec.substitution_attribute,
1940: l_qp_list_lines_rec.substitution_value,
1941: l_qp_list_lines_rec.revision,
1942: l_qp_list_lines_rec.revision_date,
1943: l_qp_list_lines_rec.revision_reason_code,
1944: l_qp_list_lines_rec.context,
1945: l_qp_list_lines_rec.attribute1,
1946: l_qp_list_lines_rec.attribute2,
1947: l_qp_list_lines_rec.comments,

Line 1944: l_qp_list_lines_rec.context,

1940: l_qp_list_lines_rec.substitution_value,
1941: l_qp_list_lines_rec.revision,
1942: l_qp_list_lines_rec.revision_date,
1943: l_qp_list_lines_rec.revision_reason_code,
1944: l_qp_list_lines_rec.context,
1945: l_qp_list_lines_rec.attribute1,
1946: l_qp_list_lines_rec.attribute2,
1947: l_qp_list_lines_rec.comments,
1948: l_qp_list_lines_rec.attribute3,

Line 1945: l_qp_list_lines_rec.attribute1,

1941: l_qp_list_lines_rec.revision,
1942: l_qp_list_lines_rec.revision_date,
1943: l_qp_list_lines_rec.revision_reason_code,
1944: l_qp_list_lines_rec.context,
1945: l_qp_list_lines_rec.attribute1,
1946: l_qp_list_lines_rec.attribute2,
1947: l_qp_list_lines_rec.comments,
1948: l_qp_list_lines_rec.attribute3,
1949: l_qp_list_lines_rec.attribute4,

Line 1946: l_qp_list_lines_rec.attribute2,

1942: l_qp_list_lines_rec.revision_date,
1943: l_qp_list_lines_rec.revision_reason_code,
1944: l_qp_list_lines_rec.context,
1945: l_qp_list_lines_rec.attribute1,
1946: l_qp_list_lines_rec.attribute2,
1947: l_qp_list_lines_rec.comments,
1948: l_qp_list_lines_rec.attribute3,
1949: l_qp_list_lines_rec.attribute4,
1950: l_qp_list_lines_rec.attribute5,

Line 1947: l_qp_list_lines_rec.comments,

1943: l_qp_list_lines_rec.revision_reason_code,
1944: l_qp_list_lines_rec.context,
1945: l_qp_list_lines_rec.attribute1,
1946: l_qp_list_lines_rec.attribute2,
1947: l_qp_list_lines_rec.comments,
1948: l_qp_list_lines_rec.attribute3,
1949: l_qp_list_lines_rec.attribute4,
1950: l_qp_list_lines_rec.attribute5,
1951: l_qp_list_lines_rec.attribute6,

Line 1948: l_qp_list_lines_rec.attribute3,

1944: l_qp_list_lines_rec.context,
1945: l_qp_list_lines_rec.attribute1,
1946: l_qp_list_lines_rec.attribute2,
1947: l_qp_list_lines_rec.comments,
1948: l_qp_list_lines_rec.attribute3,
1949: l_qp_list_lines_rec.attribute4,
1950: l_qp_list_lines_rec.attribute5,
1951: l_qp_list_lines_rec.attribute6,
1952: l_qp_list_lines_rec.attribute7,

Line 1949: l_qp_list_lines_rec.attribute4,

1945: l_qp_list_lines_rec.attribute1,
1946: l_qp_list_lines_rec.attribute2,
1947: l_qp_list_lines_rec.comments,
1948: l_qp_list_lines_rec.attribute3,
1949: l_qp_list_lines_rec.attribute4,
1950: l_qp_list_lines_rec.attribute5,
1951: l_qp_list_lines_rec.attribute6,
1952: l_qp_list_lines_rec.attribute7,
1953: l_qp_list_lines_rec.attribute8,

Line 1950: l_qp_list_lines_rec.attribute5,

1946: l_qp_list_lines_rec.attribute2,
1947: l_qp_list_lines_rec.comments,
1948: l_qp_list_lines_rec.attribute3,
1949: l_qp_list_lines_rec.attribute4,
1950: l_qp_list_lines_rec.attribute5,
1951: l_qp_list_lines_rec.attribute6,
1952: l_qp_list_lines_rec.attribute7,
1953: l_qp_list_lines_rec.attribute8,
1954: l_qp_list_lines_rec.attribute9,

Line 1951: l_qp_list_lines_rec.attribute6,

1947: l_qp_list_lines_rec.comments,
1948: l_qp_list_lines_rec.attribute3,
1949: l_qp_list_lines_rec.attribute4,
1950: l_qp_list_lines_rec.attribute5,
1951: l_qp_list_lines_rec.attribute6,
1952: l_qp_list_lines_rec.attribute7,
1953: l_qp_list_lines_rec.attribute8,
1954: l_qp_list_lines_rec.attribute9,
1955: l_qp_list_lines_rec.attribute10,

Line 1952: l_qp_list_lines_rec.attribute7,

1948: l_qp_list_lines_rec.attribute3,
1949: l_qp_list_lines_rec.attribute4,
1950: l_qp_list_lines_rec.attribute5,
1951: l_qp_list_lines_rec.attribute6,
1952: l_qp_list_lines_rec.attribute7,
1953: l_qp_list_lines_rec.attribute8,
1954: l_qp_list_lines_rec.attribute9,
1955: l_qp_list_lines_rec.attribute10,
1956: l_qp_list_lines_rec.attribute11,

Line 1953: l_qp_list_lines_rec.attribute8,

1949: l_qp_list_lines_rec.attribute4,
1950: l_qp_list_lines_rec.attribute5,
1951: l_qp_list_lines_rec.attribute6,
1952: l_qp_list_lines_rec.attribute7,
1953: l_qp_list_lines_rec.attribute8,
1954: l_qp_list_lines_rec.attribute9,
1955: l_qp_list_lines_rec.attribute10,
1956: l_qp_list_lines_rec.attribute11,
1957: l_qp_list_lines_rec.attribute12,

Line 1954: l_qp_list_lines_rec.attribute9,

1950: l_qp_list_lines_rec.attribute5,
1951: l_qp_list_lines_rec.attribute6,
1952: l_qp_list_lines_rec.attribute7,
1953: l_qp_list_lines_rec.attribute8,
1954: l_qp_list_lines_rec.attribute9,
1955: l_qp_list_lines_rec.attribute10,
1956: l_qp_list_lines_rec.attribute11,
1957: l_qp_list_lines_rec.attribute12,
1958: l_qp_list_lines_rec.attribute13,

Line 1955: l_qp_list_lines_rec.attribute10,

1951: l_qp_list_lines_rec.attribute6,
1952: l_qp_list_lines_rec.attribute7,
1953: l_qp_list_lines_rec.attribute8,
1954: l_qp_list_lines_rec.attribute9,
1955: l_qp_list_lines_rec.attribute10,
1956: l_qp_list_lines_rec.attribute11,
1957: l_qp_list_lines_rec.attribute12,
1958: l_qp_list_lines_rec.attribute13,
1959: l_qp_list_lines_rec.attribute14,

Line 1956: l_qp_list_lines_rec.attribute11,

1952: l_qp_list_lines_rec.attribute7,
1953: l_qp_list_lines_rec.attribute8,
1954: l_qp_list_lines_rec.attribute9,
1955: l_qp_list_lines_rec.attribute10,
1956: l_qp_list_lines_rec.attribute11,
1957: l_qp_list_lines_rec.attribute12,
1958: l_qp_list_lines_rec.attribute13,
1959: l_qp_list_lines_rec.attribute14,
1960: l_qp_list_lines_rec.attribute15,

Line 1957: l_qp_list_lines_rec.attribute12,

1953: l_qp_list_lines_rec.attribute8,
1954: l_qp_list_lines_rec.attribute9,
1955: l_qp_list_lines_rec.attribute10,
1956: l_qp_list_lines_rec.attribute11,
1957: l_qp_list_lines_rec.attribute12,
1958: l_qp_list_lines_rec.attribute13,
1959: l_qp_list_lines_rec.attribute14,
1960: l_qp_list_lines_rec.attribute15,
1961: l_qp_list_lines_rec.price_break_type_code,

Line 1958: l_qp_list_lines_rec.attribute13,

1954: l_qp_list_lines_rec.attribute9,
1955: l_qp_list_lines_rec.attribute10,
1956: l_qp_list_lines_rec.attribute11,
1957: l_qp_list_lines_rec.attribute12,
1958: l_qp_list_lines_rec.attribute13,
1959: l_qp_list_lines_rec.attribute14,
1960: l_qp_list_lines_rec.attribute15,
1961: l_qp_list_lines_rec.price_break_type_code,
1962: l_qp_list_lines_rec.percent_price,

Line 1959: l_qp_list_lines_rec.attribute14,

1955: l_qp_list_lines_rec.attribute10,
1956: l_qp_list_lines_rec.attribute11,
1957: l_qp_list_lines_rec.attribute12,
1958: l_qp_list_lines_rec.attribute13,
1959: l_qp_list_lines_rec.attribute14,
1960: l_qp_list_lines_rec.attribute15,
1961: l_qp_list_lines_rec.price_break_type_code,
1962: l_qp_list_lines_rec.percent_price,
1963: l_qp_list_lines_rec.price_by_formula_id,

Line 1960: l_qp_list_lines_rec.attribute15,

1956: l_qp_list_lines_rec.attribute11,
1957: l_qp_list_lines_rec.attribute12,
1958: l_qp_list_lines_rec.attribute13,
1959: l_qp_list_lines_rec.attribute14,
1960: l_qp_list_lines_rec.attribute15,
1961: l_qp_list_lines_rec.price_break_type_code,
1962: l_qp_list_lines_rec.percent_price,
1963: l_qp_list_lines_rec.price_by_formula_id,
1964: l_qp_list_lines_rec.number_effective_periods,

Line 1961: l_qp_list_lines_rec.price_break_type_code,

1957: l_qp_list_lines_rec.attribute12,
1958: l_qp_list_lines_rec.attribute13,
1959: l_qp_list_lines_rec.attribute14,
1960: l_qp_list_lines_rec.attribute15,
1961: l_qp_list_lines_rec.price_break_type_code,
1962: l_qp_list_lines_rec.percent_price,
1963: l_qp_list_lines_rec.price_by_formula_id,
1964: l_qp_list_lines_rec.number_effective_periods,
1965: l_qp_list_lines_rec.effective_period_uom,

Line 1962: l_qp_list_lines_rec.percent_price,

1958: l_qp_list_lines_rec.attribute13,
1959: l_qp_list_lines_rec.attribute14,
1960: l_qp_list_lines_rec.attribute15,
1961: l_qp_list_lines_rec.price_break_type_code,
1962: l_qp_list_lines_rec.percent_price,
1963: l_qp_list_lines_rec.price_by_formula_id,
1964: l_qp_list_lines_rec.number_effective_periods,
1965: l_qp_list_lines_rec.effective_period_uom,
1966: l_qp_list_lines_rec.arithmetic_operator,

Line 1963: l_qp_list_lines_rec.price_by_formula_id,

1959: l_qp_list_lines_rec.attribute14,
1960: l_qp_list_lines_rec.attribute15,
1961: l_qp_list_lines_rec.price_break_type_code,
1962: l_qp_list_lines_rec.percent_price,
1963: l_qp_list_lines_rec.price_by_formula_id,
1964: l_qp_list_lines_rec.number_effective_periods,
1965: l_qp_list_lines_rec.effective_period_uom,
1966: l_qp_list_lines_rec.arithmetic_operator,
1967: l_qp_list_lines_rec.operand,

Line 1964: l_qp_list_lines_rec.number_effective_periods,

1960: l_qp_list_lines_rec.attribute15,
1961: l_qp_list_lines_rec.price_break_type_code,
1962: l_qp_list_lines_rec.percent_price,
1963: l_qp_list_lines_rec.price_by_formula_id,
1964: l_qp_list_lines_rec.number_effective_periods,
1965: l_qp_list_lines_rec.effective_period_uom,
1966: l_qp_list_lines_rec.arithmetic_operator,
1967: l_qp_list_lines_rec.operand,
1968: l_qp_list_lines_rec.override_flag,

Line 1965: l_qp_list_lines_rec.effective_period_uom,

1961: l_qp_list_lines_rec.price_break_type_code,
1962: l_qp_list_lines_rec.percent_price,
1963: l_qp_list_lines_rec.price_by_formula_id,
1964: l_qp_list_lines_rec.number_effective_periods,
1965: l_qp_list_lines_rec.effective_period_uom,
1966: l_qp_list_lines_rec.arithmetic_operator,
1967: l_qp_list_lines_rec.operand,
1968: l_qp_list_lines_rec.override_flag,
1969: l_qp_list_lines_rec.print_on_invoice_flag,

Line 1966: l_qp_list_lines_rec.arithmetic_operator,

1962: l_qp_list_lines_rec.percent_price,
1963: l_qp_list_lines_rec.price_by_formula_id,
1964: l_qp_list_lines_rec.number_effective_periods,
1965: l_qp_list_lines_rec.effective_period_uom,
1966: l_qp_list_lines_rec.arithmetic_operator,
1967: l_qp_list_lines_rec.operand,
1968: l_qp_list_lines_rec.override_flag,
1969: l_qp_list_lines_rec.print_on_invoice_flag,
1970: l_qp_list_lines_rec.rebate_transaction_type_code,

Line 1967: l_qp_list_lines_rec.operand,

1963: l_qp_list_lines_rec.price_by_formula_id,
1964: l_qp_list_lines_rec.number_effective_periods,
1965: l_qp_list_lines_rec.effective_period_uom,
1966: l_qp_list_lines_rec.arithmetic_operator,
1967: l_qp_list_lines_rec.operand,
1968: l_qp_list_lines_rec.override_flag,
1969: l_qp_list_lines_rec.print_on_invoice_flag,
1970: l_qp_list_lines_rec.rebate_transaction_type_code,
1971: l_qp_list_lines_rec.estim_accrual_rate,

Line 1968: l_qp_list_lines_rec.override_flag,

1964: l_qp_list_lines_rec.number_effective_periods,
1965: l_qp_list_lines_rec.effective_period_uom,
1966: l_qp_list_lines_rec.arithmetic_operator,
1967: l_qp_list_lines_rec.operand,
1968: l_qp_list_lines_rec.override_flag,
1969: l_qp_list_lines_rec.print_on_invoice_flag,
1970: l_qp_list_lines_rec.rebate_transaction_type_code,
1971: l_qp_list_lines_rec.estim_accrual_rate,
1972: l_qp_list_lines_rec.generate_using_formula_id,

Line 1969: l_qp_list_lines_rec.print_on_invoice_flag,

1965: l_qp_list_lines_rec.effective_period_uom,
1966: l_qp_list_lines_rec.arithmetic_operator,
1967: l_qp_list_lines_rec.operand,
1968: l_qp_list_lines_rec.override_flag,
1969: l_qp_list_lines_rec.print_on_invoice_flag,
1970: l_qp_list_lines_rec.rebate_transaction_type_code,
1971: l_qp_list_lines_rec.estim_accrual_rate,
1972: l_qp_list_lines_rec.generate_using_formula_id,
1973: l_qp_list_lines_rec.reprice_flag,

Line 1970: l_qp_list_lines_rec.rebate_transaction_type_code,

1966: l_qp_list_lines_rec.arithmetic_operator,
1967: l_qp_list_lines_rec.operand,
1968: l_qp_list_lines_rec.override_flag,
1969: l_qp_list_lines_rec.print_on_invoice_flag,
1970: l_qp_list_lines_rec.rebate_transaction_type_code,
1971: l_qp_list_lines_rec.estim_accrual_rate,
1972: l_qp_list_lines_rec.generate_using_formula_id,
1973: l_qp_list_lines_rec.reprice_flag,
1974: l_qp_list_lines_rec.accrual_flag,

Line 1971: l_qp_list_lines_rec.estim_accrual_rate,

1967: l_qp_list_lines_rec.operand,
1968: l_qp_list_lines_rec.override_flag,
1969: l_qp_list_lines_rec.print_on_invoice_flag,
1970: l_qp_list_lines_rec.rebate_transaction_type_code,
1971: l_qp_list_lines_rec.estim_accrual_rate,
1972: l_qp_list_lines_rec.generate_using_formula_id,
1973: l_qp_list_lines_rec.reprice_flag,
1974: l_qp_list_lines_rec.accrual_flag,
1975: l_qp_list_lines_rec.pricing_group_sequence,

Line 1972: l_qp_list_lines_rec.generate_using_formula_id,

1968: l_qp_list_lines_rec.override_flag,
1969: l_qp_list_lines_rec.print_on_invoice_flag,
1970: l_qp_list_lines_rec.rebate_transaction_type_code,
1971: l_qp_list_lines_rec.estim_accrual_rate,
1972: l_qp_list_lines_rec.generate_using_formula_id,
1973: l_qp_list_lines_rec.reprice_flag,
1974: l_qp_list_lines_rec.accrual_flag,
1975: l_qp_list_lines_rec.pricing_group_sequence,
1976: l_qp_list_lines_rec.incompatibility_grp_code,

Line 1973: l_qp_list_lines_rec.reprice_flag,

1969: l_qp_list_lines_rec.print_on_invoice_flag,
1970: l_qp_list_lines_rec.rebate_transaction_type_code,
1971: l_qp_list_lines_rec.estim_accrual_rate,
1972: l_qp_list_lines_rec.generate_using_formula_id,
1973: l_qp_list_lines_rec.reprice_flag,
1974: l_qp_list_lines_rec.accrual_flag,
1975: l_qp_list_lines_rec.pricing_group_sequence,
1976: l_qp_list_lines_rec.incompatibility_grp_code,
1977: l_qp_list_lines_rec.list_line_no,

Line 1974: l_qp_list_lines_rec.accrual_flag,

1970: l_qp_list_lines_rec.rebate_transaction_type_code,
1971: l_qp_list_lines_rec.estim_accrual_rate,
1972: l_qp_list_lines_rec.generate_using_formula_id,
1973: l_qp_list_lines_rec.reprice_flag,
1974: l_qp_list_lines_rec.accrual_flag,
1975: l_qp_list_lines_rec.pricing_group_sequence,
1976: l_qp_list_lines_rec.incompatibility_grp_code,
1977: l_qp_list_lines_rec.list_line_no,
1978: l_qp_list_lines_rec.product_precedence,

Line 1975: l_qp_list_lines_rec.pricing_group_sequence,

1971: l_qp_list_lines_rec.estim_accrual_rate,
1972: l_qp_list_lines_rec.generate_using_formula_id,
1973: l_qp_list_lines_rec.reprice_flag,
1974: l_qp_list_lines_rec.accrual_flag,
1975: l_qp_list_lines_rec.pricing_group_sequence,
1976: l_qp_list_lines_rec.incompatibility_grp_code,
1977: l_qp_list_lines_rec.list_line_no,
1978: l_qp_list_lines_rec.product_precedence,
1979: l_qp_list_lines_rec.pricing_phase_id,

Line 1976: l_qp_list_lines_rec.incompatibility_grp_code,

1972: l_qp_list_lines_rec.generate_using_formula_id,
1973: l_qp_list_lines_rec.reprice_flag,
1974: l_qp_list_lines_rec.accrual_flag,
1975: l_qp_list_lines_rec.pricing_group_sequence,
1976: l_qp_list_lines_rec.incompatibility_grp_code,
1977: l_qp_list_lines_rec.list_line_no,
1978: l_qp_list_lines_rec.product_precedence,
1979: l_qp_list_lines_rec.pricing_phase_id,
1980: l_qp_list_lines_rec.expiration_period_start_date,

Line 1977: l_qp_list_lines_rec.list_line_no,

1973: l_qp_list_lines_rec.reprice_flag,
1974: l_qp_list_lines_rec.accrual_flag,
1975: l_qp_list_lines_rec.pricing_group_sequence,
1976: l_qp_list_lines_rec.incompatibility_grp_code,
1977: l_qp_list_lines_rec.list_line_no,
1978: l_qp_list_lines_rec.product_precedence,
1979: l_qp_list_lines_rec.pricing_phase_id,
1980: l_qp_list_lines_rec.expiration_period_start_date,
1981: l_qp_list_lines_rec.number_expiration_periods,

Line 1978: l_qp_list_lines_rec.product_precedence,

1974: l_qp_list_lines_rec.accrual_flag,
1975: l_qp_list_lines_rec.pricing_group_sequence,
1976: l_qp_list_lines_rec.incompatibility_grp_code,
1977: l_qp_list_lines_rec.list_line_no,
1978: l_qp_list_lines_rec.product_precedence,
1979: l_qp_list_lines_rec.pricing_phase_id,
1980: l_qp_list_lines_rec.expiration_period_start_date,
1981: l_qp_list_lines_rec.number_expiration_periods,
1982: l_qp_list_lines_rec.expiration_period_uom,

Line 1979: l_qp_list_lines_rec.pricing_phase_id,

1975: l_qp_list_lines_rec.pricing_group_sequence,
1976: l_qp_list_lines_rec.incompatibility_grp_code,
1977: l_qp_list_lines_rec.list_line_no,
1978: l_qp_list_lines_rec.product_precedence,
1979: l_qp_list_lines_rec.pricing_phase_id,
1980: l_qp_list_lines_rec.expiration_period_start_date,
1981: l_qp_list_lines_rec.number_expiration_periods,
1982: l_qp_list_lines_rec.expiration_period_uom,
1983: l_qp_list_lines_rec.expiration_date,

Line 1980: l_qp_list_lines_rec.expiration_period_start_date,

1976: l_qp_list_lines_rec.incompatibility_grp_code,
1977: l_qp_list_lines_rec.list_line_no,
1978: l_qp_list_lines_rec.product_precedence,
1979: l_qp_list_lines_rec.pricing_phase_id,
1980: l_qp_list_lines_rec.expiration_period_start_date,
1981: l_qp_list_lines_rec.number_expiration_periods,
1982: l_qp_list_lines_rec.expiration_period_uom,
1983: l_qp_list_lines_rec.expiration_date,
1984: l_qp_list_lines_rec.estim_gl_value,

Line 1981: l_qp_list_lines_rec.number_expiration_periods,

1977: l_qp_list_lines_rec.list_line_no,
1978: l_qp_list_lines_rec.product_precedence,
1979: l_qp_list_lines_rec.pricing_phase_id,
1980: l_qp_list_lines_rec.expiration_period_start_date,
1981: l_qp_list_lines_rec.number_expiration_periods,
1982: l_qp_list_lines_rec.expiration_period_uom,
1983: l_qp_list_lines_rec.expiration_date,
1984: l_qp_list_lines_rec.estim_gl_value,
1985: l_qp_list_lines_rec.accrual_conversion_rate,

Line 1982: l_qp_list_lines_rec.expiration_period_uom,

1978: l_qp_list_lines_rec.product_precedence,
1979: l_qp_list_lines_rec.pricing_phase_id,
1980: l_qp_list_lines_rec.expiration_period_start_date,
1981: l_qp_list_lines_rec.number_expiration_periods,
1982: l_qp_list_lines_rec.expiration_period_uom,
1983: l_qp_list_lines_rec.expiration_date,
1984: l_qp_list_lines_rec.estim_gl_value,
1985: l_qp_list_lines_rec.accrual_conversion_rate,
1986: l_qp_list_lines_rec.benefit_price_list_line_id,

Line 1983: l_qp_list_lines_rec.expiration_date,

1979: l_qp_list_lines_rec.pricing_phase_id,
1980: l_qp_list_lines_rec.expiration_period_start_date,
1981: l_qp_list_lines_rec.number_expiration_periods,
1982: l_qp_list_lines_rec.expiration_period_uom,
1983: l_qp_list_lines_rec.expiration_date,
1984: l_qp_list_lines_rec.estim_gl_value,
1985: l_qp_list_lines_rec.accrual_conversion_rate,
1986: l_qp_list_lines_rec.benefit_price_list_line_id,
1987: l_qp_list_lines_rec.proration_type_code,

Line 1984: l_qp_list_lines_rec.estim_gl_value,

1980: l_qp_list_lines_rec.expiration_period_start_date,
1981: l_qp_list_lines_rec.number_expiration_periods,
1982: l_qp_list_lines_rec.expiration_period_uom,
1983: l_qp_list_lines_rec.expiration_date,
1984: l_qp_list_lines_rec.estim_gl_value,
1985: l_qp_list_lines_rec.accrual_conversion_rate,
1986: l_qp_list_lines_rec.benefit_price_list_line_id,
1987: l_qp_list_lines_rec.proration_type_code,
1988: l_qp_list_lines_rec.benefit_qty,

Line 1985: l_qp_list_lines_rec.accrual_conversion_rate,

1981: l_qp_list_lines_rec.number_expiration_periods,
1982: l_qp_list_lines_rec.expiration_period_uom,
1983: l_qp_list_lines_rec.expiration_date,
1984: l_qp_list_lines_rec.estim_gl_value,
1985: l_qp_list_lines_rec.accrual_conversion_rate,
1986: l_qp_list_lines_rec.benefit_price_list_line_id,
1987: l_qp_list_lines_rec.proration_type_code,
1988: l_qp_list_lines_rec.benefit_qty,
1989: l_qp_list_lines_rec.benefit_uom_code,

Line 1986: l_qp_list_lines_rec.benefit_price_list_line_id,

1982: l_qp_list_lines_rec.expiration_period_uom,
1983: l_qp_list_lines_rec.expiration_date,
1984: l_qp_list_lines_rec.estim_gl_value,
1985: l_qp_list_lines_rec.accrual_conversion_rate,
1986: l_qp_list_lines_rec.benefit_price_list_line_id,
1987: l_qp_list_lines_rec.proration_type_code,
1988: l_qp_list_lines_rec.benefit_qty,
1989: l_qp_list_lines_rec.benefit_uom_code,
1990: l_qp_list_lines_rec.charge_type_code,

Line 1987: l_qp_list_lines_rec.proration_type_code,

1983: l_qp_list_lines_rec.expiration_date,
1984: l_qp_list_lines_rec.estim_gl_value,
1985: l_qp_list_lines_rec.accrual_conversion_rate,
1986: l_qp_list_lines_rec.benefit_price_list_line_id,
1987: l_qp_list_lines_rec.proration_type_code,
1988: l_qp_list_lines_rec.benefit_qty,
1989: l_qp_list_lines_rec.benefit_uom_code,
1990: l_qp_list_lines_rec.charge_type_code,
1991: l_qp_list_lines_rec.charge_subtype_code,

Line 1988: l_qp_list_lines_rec.benefit_qty,

1984: l_qp_list_lines_rec.estim_gl_value,
1985: l_qp_list_lines_rec.accrual_conversion_rate,
1986: l_qp_list_lines_rec.benefit_price_list_line_id,
1987: l_qp_list_lines_rec.proration_type_code,
1988: l_qp_list_lines_rec.benefit_qty,
1989: l_qp_list_lines_rec.benefit_uom_code,
1990: l_qp_list_lines_rec.charge_type_code,
1991: l_qp_list_lines_rec.charge_subtype_code,
1992: l_qp_list_lines_rec.benefit_limit,

Line 1989: l_qp_list_lines_rec.benefit_uom_code,

1985: l_qp_list_lines_rec.accrual_conversion_rate,
1986: l_qp_list_lines_rec.benefit_price_list_line_id,
1987: l_qp_list_lines_rec.proration_type_code,
1988: l_qp_list_lines_rec.benefit_qty,
1989: l_qp_list_lines_rec.benefit_uom_code,
1990: l_qp_list_lines_rec.charge_type_code,
1991: l_qp_list_lines_rec.charge_subtype_code,
1992: l_qp_list_lines_rec.benefit_limit,
1993: l_qp_list_lines_rec.include_on_returns_flag,

Line 1990: l_qp_list_lines_rec.charge_type_code,

1986: l_qp_list_lines_rec.benefit_price_list_line_id,
1987: l_qp_list_lines_rec.proration_type_code,
1988: l_qp_list_lines_rec.benefit_qty,
1989: l_qp_list_lines_rec.benefit_uom_code,
1990: l_qp_list_lines_rec.charge_type_code,
1991: l_qp_list_lines_rec.charge_subtype_code,
1992: l_qp_list_lines_rec.benefit_limit,
1993: l_qp_list_lines_rec.include_on_returns_flag,
1994: l_qp_list_lines_rec.qualification_ind,

Line 1991: l_qp_list_lines_rec.charge_subtype_code,

1987: l_qp_list_lines_rec.proration_type_code,
1988: l_qp_list_lines_rec.benefit_qty,
1989: l_qp_list_lines_rec.benefit_uom_code,
1990: l_qp_list_lines_rec.charge_type_code,
1991: l_qp_list_lines_rec.charge_subtype_code,
1992: l_qp_list_lines_rec.benefit_limit,
1993: l_qp_list_lines_rec.include_on_returns_flag,
1994: l_qp_list_lines_rec.qualification_ind,
1995: l_qp_list_lines_rec.recurring_value,

Line 1992: l_qp_list_lines_rec.benefit_limit,

1988: l_qp_list_lines_rec.benefit_qty,
1989: l_qp_list_lines_rec.benefit_uom_code,
1990: l_qp_list_lines_rec.charge_type_code,
1991: l_qp_list_lines_rec.charge_subtype_code,
1992: l_qp_list_lines_rec.benefit_limit,
1993: l_qp_list_lines_rec.include_on_returns_flag,
1994: l_qp_list_lines_rec.qualification_ind,
1995: l_qp_list_lines_rec.recurring_value,
1996: l_qp_list_lines_rec.LIST_PRICE_UOM_CODE,

Line 1993: l_qp_list_lines_rec.include_on_returns_flag,

1989: l_qp_list_lines_rec.benefit_uom_code,
1990: l_qp_list_lines_rec.charge_type_code,
1991: l_qp_list_lines_rec.charge_subtype_code,
1992: l_qp_list_lines_rec.benefit_limit,
1993: l_qp_list_lines_rec.include_on_returns_flag,
1994: l_qp_list_lines_rec.qualification_ind,
1995: l_qp_list_lines_rec.recurring_value,
1996: l_qp_list_lines_rec.LIST_PRICE_UOM_CODE,
1997: l_qp_list_lines_rec.BASE_QTY,

Line 1994: l_qp_list_lines_rec.qualification_ind,

1990: l_qp_list_lines_rec.charge_type_code,
1991: l_qp_list_lines_rec.charge_subtype_code,
1992: l_qp_list_lines_rec.benefit_limit,
1993: l_qp_list_lines_rec.include_on_returns_flag,
1994: l_qp_list_lines_rec.qualification_ind,
1995: l_qp_list_lines_rec.recurring_value,
1996: l_qp_list_lines_rec.LIST_PRICE_UOM_CODE,
1997: l_qp_list_lines_rec.BASE_QTY,
1998: l_qp_list_lines_rec.BASE_UOM_CODE,

Line 1995: l_qp_list_lines_rec.recurring_value,

1991: l_qp_list_lines_rec.charge_subtype_code,
1992: l_qp_list_lines_rec.benefit_limit,
1993: l_qp_list_lines_rec.include_on_returns_flag,
1994: l_qp_list_lines_rec.qualification_ind,
1995: l_qp_list_lines_rec.recurring_value,
1996: l_qp_list_lines_rec.LIST_PRICE_UOM_CODE,
1997: l_qp_list_lines_rec.BASE_QTY,
1998: l_qp_list_lines_rec.BASE_UOM_CODE,
1999: l_qp_list_lines_rec.ACCRUAL_QTY,

Line 1996: l_qp_list_lines_rec.LIST_PRICE_UOM_CODE,

1992: l_qp_list_lines_rec.benefit_limit,
1993: l_qp_list_lines_rec.include_on_returns_flag,
1994: l_qp_list_lines_rec.qualification_ind,
1995: l_qp_list_lines_rec.recurring_value,
1996: l_qp_list_lines_rec.LIST_PRICE_UOM_CODE,
1997: l_qp_list_lines_rec.BASE_QTY,
1998: l_qp_list_lines_rec.BASE_UOM_CODE,
1999: l_qp_list_lines_rec.ACCRUAL_QTY,
2000: l_qp_list_lines_rec.ACCRUAL_UOM_CODE,

Line 1997: l_qp_list_lines_rec.BASE_QTY,

1993: l_qp_list_lines_rec.include_on_returns_flag,
1994: l_qp_list_lines_rec.qualification_ind,
1995: l_qp_list_lines_rec.recurring_value,
1996: l_qp_list_lines_rec.LIST_PRICE_UOM_CODE,
1997: l_qp_list_lines_rec.BASE_QTY,
1998: l_qp_list_lines_rec.BASE_UOM_CODE,
1999: l_qp_list_lines_rec.ACCRUAL_QTY,
2000: l_qp_list_lines_rec.ACCRUAL_UOM_CODE,
2001: l_qp_list_lines_rec.RECURRING_FLAG,

Line 1998: l_qp_list_lines_rec.BASE_UOM_CODE,

1994: l_qp_list_lines_rec.qualification_ind,
1995: l_qp_list_lines_rec.recurring_value,
1996: l_qp_list_lines_rec.LIST_PRICE_UOM_CODE,
1997: l_qp_list_lines_rec.BASE_QTY,
1998: l_qp_list_lines_rec.BASE_UOM_CODE,
1999: l_qp_list_lines_rec.ACCRUAL_QTY,
2000: l_qp_list_lines_rec.ACCRUAL_UOM_CODE,
2001: l_qp_list_lines_rec.RECURRING_FLAG,
2002: l_qp_list_lines_rec.LIMIT_EXISTS_FLAG,

Line 1999: l_qp_list_lines_rec.ACCRUAL_QTY,

1995: l_qp_list_lines_rec.recurring_value,
1996: l_qp_list_lines_rec.LIST_PRICE_UOM_CODE,
1997: l_qp_list_lines_rec.BASE_QTY,
1998: l_qp_list_lines_rec.BASE_UOM_CODE,
1999: l_qp_list_lines_rec.ACCRUAL_QTY,
2000: l_qp_list_lines_rec.ACCRUAL_UOM_CODE,
2001: l_qp_list_lines_rec.RECURRING_FLAG,
2002: l_qp_list_lines_rec.LIMIT_EXISTS_FLAG,
2003: l_qp_list_lines_rec.GROUP_COUNT,

Line 2000: l_qp_list_lines_rec.ACCRUAL_UOM_CODE,

1996: l_qp_list_lines_rec.LIST_PRICE_UOM_CODE,
1997: l_qp_list_lines_rec.BASE_QTY,
1998: l_qp_list_lines_rec.BASE_UOM_CODE,
1999: l_qp_list_lines_rec.ACCRUAL_QTY,
2000: l_qp_list_lines_rec.ACCRUAL_UOM_CODE,
2001: l_qp_list_lines_rec.RECURRING_FLAG,
2002: l_qp_list_lines_rec.LIMIT_EXISTS_FLAG,
2003: l_qp_list_lines_rec.GROUP_COUNT,
2004: l_qp_list_lines_rec.NET_AMOUNT_FLAG,

Line 2001: l_qp_list_lines_rec.RECURRING_FLAG,

1997: l_qp_list_lines_rec.BASE_QTY,
1998: l_qp_list_lines_rec.BASE_UOM_CODE,
1999: l_qp_list_lines_rec.ACCRUAL_QTY,
2000: l_qp_list_lines_rec.ACCRUAL_UOM_CODE,
2001: l_qp_list_lines_rec.RECURRING_FLAG,
2002: l_qp_list_lines_rec.LIMIT_EXISTS_FLAG,
2003: l_qp_list_lines_rec.GROUP_COUNT,
2004: l_qp_list_lines_rec.NET_AMOUNT_FLAG,
2005: l_qp_list_lines_rec.CUSTOMER_ITEM_ID,

Line 2002: l_qp_list_lines_rec.LIMIT_EXISTS_FLAG,

1998: l_qp_list_lines_rec.BASE_UOM_CODE,
1999: l_qp_list_lines_rec.ACCRUAL_QTY,
2000: l_qp_list_lines_rec.ACCRUAL_UOM_CODE,
2001: l_qp_list_lines_rec.RECURRING_FLAG,
2002: l_qp_list_lines_rec.LIMIT_EXISTS_FLAG,
2003: l_qp_list_lines_rec.GROUP_COUNT,
2004: l_qp_list_lines_rec.NET_AMOUNT_FLAG,
2005: l_qp_list_lines_rec.CUSTOMER_ITEM_ID,
2006: l_qp_list_lines_rec.ACCUM_CONTEXT,

Line 2003: l_qp_list_lines_rec.GROUP_COUNT,

1999: l_qp_list_lines_rec.ACCRUAL_QTY,
2000: l_qp_list_lines_rec.ACCRUAL_UOM_CODE,
2001: l_qp_list_lines_rec.RECURRING_FLAG,
2002: l_qp_list_lines_rec.LIMIT_EXISTS_FLAG,
2003: l_qp_list_lines_rec.GROUP_COUNT,
2004: l_qp_list_lines_rec.NET_AMOUNT_FLAG,
2005: l_qp_list_lines_rec.CUSTOMER_ITEM_ID,
2006: l_qp_list_lines_rec.ACCUM_CONTEXT,
2007: l_qp_list_lines_rec.ACCUM_ATTRIBUTE,

Line 2004: l_qp_list_lines_rec.NET_AMOUNT_FLAG,

2000: l_qp_list_lines_rec.ACCRUAL_UOM_CODE,
2001: l_qp_list_lines_rec.RECURRING_FLAG,
2002: l_qp_list_lines_rec.LIMIT_EXISTS_FLAG,
2003: l_qp_list_lines_rec.GROUP_COUNT,
2004: l_qp_list_lines_rec.NET_AMOUNT_FLAG,
2005: l_qp_list_lines_rec.CUSTOMER_ITEM_ID,
2006: l_qp_list_lines_rec.ACCUM_CONTEXT,
2007: l_qp_list_lines_rec.ACCUM_ATTRIBUTE,
2008: l_qp_list_lines_rec.ACCUM_ATTR_RUN_SRC_FLAG,

Line 2005: l_qp_list_lines_rec.CUSTOMER_ITEM_ID,

2001: l_qp_list_lines_rec.RECURRING_FLAG,
2002: l_qp_list_lines_rec.LIMIT_EXISTS_FLAG,
2003: l_qp_list_lines_rec.GROUP_COUNT,
2004: l_qp_list_lines_rec.NET_AMOUNT_FLAG,
2005: l_qp_list_lines_rec.CUSTOMER_ITEM_ID,
2006: l_qp_list_lines_rec.ACCUM_CONTEXT,
2007: l_qp_list_lines_rec.ACCUM_ATTRIBUTE,
2008: l_qp_list_lines_rec.ACCUM_ATTR_RUN_SRC_FLAG,
2009: l_qp_list_lines_rec.BREAK_UOM_CODE,

Line 2006: l_qp_list_lines_rec.ACCUM_CONTEXT,

2002: l_qp_list_lines_rec.LIMIT_EXISTS_FLAG,
2003: l_qp_list_lines_rec.GROUP_COUNT,
2004: l_qp_list_lines_rec.NET_AMOUNT_FLAG,
2005: l_qp_list_lines_rec.CUSTOMER_ITEM_ID,
2006: l_qp_list_lines_rec.ACCUM_CONTEXT,
2007: l_qp_list_lines_rec.ACCUM_ATTRIBUTE,
2008: l_qp_list_lines_rec.ACCUM_ATTR_RUN_SRC_FLAG,
2009: l_qp_list_lines_rec.BREAK_UOM_CODE,
2010: l_qp_list_lines_rec.BREAK_UOM_CONTEXT,

Line 2007: l_qp_list_lines_rec.ACCUM_ATTRIBUTE,

2003: l_qp_list_lines_rec.GROUP_COUNT,
2004: l_qp_list_lines_rec.NET_AMOUNT_FLAG,
2005: l_qp_list_lines_rec.CUSTOMER_ITEM_ID,
2006: l_qp_list_lines_rec.ACCUM_CONTEXT,
2007: l_qp_list_lines_rec.ACCUM_ATTRIBUTE,
2008: l_qp_list_lines_rec.ACCUM_ATTR_RUN_SRC_FLAG,
2009: l_qp_list_lines_rec.BREAK_UOM_CODE,
2010: l_qp_list_lines_rec.BREAK_UOM_CONTEXT,
2011: l_qp_list_lines_rec.BREAK_UOM_ATTRIBUTE,

Line 2008: l_qp_list_lines_rec.ACCUM_ATTR_RUN_SRC_FLAG,

2004: l_qp_list_lines_rec.NET_AMOUNT_FLAG,
2005: l_qp_list_lines_rec.CUSTOMER_ITEM_ID,
2006: l_qp_list_lines_rec.ACCUM_CONTEXT,
2007: l_qp_list_lines_rec.ACCUM_ATTRIBUTE,
2008: l_qp_list_lines_rec.ACCUM_ATTR_RUN_SRC_FLAG,
2009: l_qp_list_lines_rec.BREAK_UOM_CODE,
2010: l_qp_list_lines_rec.BREAK_UOM_CONTEXT,
2011: l_qp_list_lines_rec.BREAK_UOM_ATTRIBUTE,
2012: l_qp_list_lines_rec.PATTERN_ID ,

Line 2009: l_qp_list_lines_rec.BREAK_UOM_CODE,

2005: l_qp_list_lines_rec.CUSTOMER_ITEM_ID,
2006: l_qp_list_lines_rec.ACCUM_CONTEXT,
2007: l_qp_list_lines_rec.ACCUM_ATTRIBUTE,
2008: l_qp_list_lines_rec.ACCUM_ATTR_RUN_SRC_FLAG,
2009: l_qp_list_lines_rec.BREAK_UOM_CODE,
2010: l_qp_list_lines_rec.BREAK_UOM_CONTEXT,
2011: l_qp_list_lines_rec.BREAK_UOM_ATTRIBUTE,
2012: l_qp_list_lines_rec.PATTERN_ID ,
2013: l_qp_list_lines_rec.PRODUCT_UOM_CODE,

Line 2010: l_qp_list_lines_rec.BREAK_UOM_CONTEXT,

2006: l_qp_list_lines_rec.ACCUM_CONTEXT,
2007: l_qp_list_lines_rec.ACCUM_ATTRIBUTE,
2008: l_qp_list_lines_rec.ACCUM_ATTR_RUN_SRC_FLAG,
2009: l_qp_list_lines_rec.BREAK_UOM_CODE,
2010: l_qp_list_lines_rec.BREAK_UOM_CONTEXT,
2011: l_qp_list_lines_rec.BREAK_UOM_ATTRIBUTE,
2012: l_qp_list_lines_rec.PATTERN_ID ,
2013: l_qp_list_lines_rec.PRODUCT_UOM_CODE,
2014: l_qp_list_lines_rec.PRICING_ATTRIBUTE_COUNT,

Line 2011: l_qp_list_lines_rec.BREAK_UOM_ATTRIBUTE,

2007: l_qp_list_lines_rec.ACCUM_ATTRIBUTE,
2008: l_qp_list_lines_rec.ACCUM_ATTR_RUN_SRC_FLAG,
2009: l_qp_list_lines_rec.BREAK_UOM_CODE,
2010: l_qp_list_lines_rec.BREAK_UOM_CONTEXT,
2011: l_qp_list_lines_rec.BREAK_UOM_ATTRIBUTE,
2012: l_qp_list_lines_rec.PATTERN_ID ,
2013: l_qp_list_lines_rec.PRODUCT_UOM_CODE,
2014: l_qp_list_lines_rec.PRICING_ATTRIBUTE_COUNT,
2015: l_qp_list_lines_rec.HASH_KEY ,

Line 2012: l_qp_list_lines_rec.PATTERN_ID ,

2008: l_qp_list_lines_rec.ACCUM_ATTR_RUN_SRC_FLAG,
2009: l_qp_list_lines_rec.BREAK_UOM_CODE,
2010: l_qp_list_lines_rec.BREAK_UOM_CONTEXT,
2011: l_qp_list_lines_rec.BREAK_UOM_ATTRIBUTE,
2012: l_qp_list_lines_rec.PATTERN_ID ,
2013: l_qp_list_lines_rec.PRODUCT_UOM_CODE,
2014: l_qp_list_lines_rec.PRICING_ATTRIBUTE_COUNT,
2015: l_qp_list_lines_rec.HASH_KEY ,
2016: l_qp_list_lines_rec.CACHE_KEY,

Line 2013: l_qp_list_lines_rec.PRODUCT_UOM_CODE,

2009: l_qp_list_lines_rec.BREAK_UOM_CODE,
2010: l_qp_list_lines_rec.BREAK_UOM_CONTEXT,
2011: l_qp_list_lines_rec.BREAK_UOM_ATTRIBUTE,
2012: l_qp_list_lines_rec.PATTERN_ID ,
2013: l_qp_list_lines_rec.PRODUCT_UOM_CODE,
2014: l_qp_list_lines_rec.PRICING_ATTRIBUTE_COUNT,
2015: l_qp_list_lines_rec.HASH_KEY ,
2016: l_qp_list_lines_rec.CACHE_KEY,
2017: l_conc_request_id

Line 2014: l_qp_list_lines_rec.PRICING_ATTRIBUTE_COUNT,

2010: l_qp_list_lines_rec.BREAK_UOM_CONTEXT,
2011: l_qp_list_lines_rec.BREAK_UOM_ATTRIBUTE,
2012: l_qp_list_lines_rec.PATTERN_ID ,
2013: l_qp_list_lines_rec.PRODUCT_UOM_CODE,
2014: l_qp_list_lines_rec.PRICING_ATTRIBUTE_COUNT,
2015: l_qp_list_lines_rec.HASH_KEY ,
2016: l_qp_list_lines_rec.CACHE_KEY,
2017: l_conc_request_id
2018: );

Line 2015: l_qp_list_lines_rec.HASH_KEY ,

2011: l_qp_list_lines_rec.BREAK_UOM_ATTRIBUTE,
2012: l_qp_list_lines_rec.PATTERN_ID ,
2013: l_qp_list_lines_rec.PRODUCT_UOM_CODE,
2014: l_qp_list_lines_rec.PRICING_ATTRIBUTE_COUNT,
2015: l_qp_list_lines_rec.HASH_KEY ,
2016: l_qp_list_lines_rec.CACHE_KEY,
2017: l_conc_request_id
2018: );
2019:

Line 2016: l_qp_list_lines_rec.CACHE_KEY,

2012: l_qp_list_lines_rec.PATTERN_ID ,
2013: l_qp_list_lines_rec.PRODUCT_UOM_CODE,
2014: l_qp_list_lines_rec.PRICING_ATTRIBUTE_COUNT,
2015: l_qp_list_lines_rec.HASH_KEY ,
2016: l_qp_list_lines_rec.CACHE_KEY,
2017: l_conc_request_id
2018: );
2019:
2020: g_count_list_line:=g_count_list_line + sql%rowcount;

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

2021:
2022: /*If the list_line_rec is a Price Break Parent Line or a promotional or other item discount parent line then
2023: store the list line id in a mapping-array for later use*/
2024:
2025: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' OR
2026: l_qp_list_lines_rec.list_line_type_code = 'OID' OR
2027: l_qp_list_lines_rec.list_line_type_code = 'PRG' THEN
2028:
2029: l_count := l_count + 1;

Line 2026: l_qp_list_lines_rec.list_line_type_code = 'OID' OR

2022: /*If the list_line_rec is a Price Break Parent Line or a promotional or other item discount parent line then
2023: store the list line id in a mapping-array for later use*/
2024:
2025: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' OR
2026: l_qp_list_lines_rec.list_line_type_code = 'OID' OR
2027: l_qp_list_lines_rec.list_line_type_code = 'PRG' THEN
2028:
2029: l_count := l_count + 1;
2030: l_mapping_tbl(l_count).list_line_type_code := l_qp_list_lines_rec.list_line_type_code;

Line 2027: l_qp_list_lines_rec.list_line_type_code = 'PRG' THEN

2023: store the list line id in a mapping-array for later use*/
2024:
2025: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' OR
2026: l_qp_list_lines_rec.list_line_type_code = 'OID' OR
2027: l_qp_list_lines_rec.list_line_type_code = 'PRG' THEN
2028:
2029: l_count := l_count + 1;
2030: l_mapping_tbl(l_count).list_line_type_code := l_qp_list_lines_rec.list_line_type_code;
2031: l_mapping_tbl(l_count).list_line_id := l_qp_list_lines_rec.list_line_id;

Line 2030: l_mapping_tbl(l_count).list_line_type_code := l_qp_list_lines_rec.list_line_type_code;

2026: l_qp_list_lines_rec.list_line_type_code = 'OID' OR
2027: l_qp_list_lines_rec.list_line_type_code = 'PRG' THEN
2028:
2029: l_count := l_count + 1;
2030: l_mapping_tbl(l_count).list_line_type_code := l_qp_list_lines_rec.list_line_type_code;
2031: l_mapping_tbl(l_count).list_line_id := l_qp_list_lines_rec.list_line_id;
2032: END IF;
2033:
2034: DELETE FROM QP_LIST_LINES WHERE list_line_id = l_qp_list_lines_rec.list_line_id and list_header_id = p_entity;

Line 2031: l_mapping_tbl(l_count).list_line_id := l_qp_list_lines_rec.list_line_id;

2027: l_qp_list_lines_rec.list_line_type_code = 'PRG' THEN
2028:
2029: l_count := l_count + 1;
2030: l_mapping_tbl(l_count).list_line_type_code := l_qp_list_lines_rec.list_line_type_code;
2031: l_mapping_tbl(l_count).list_line_id := l_qp_list_lines_rec.list_line_id;
2032: END IF;
2033:
2034: DELETE FROM QP_LIST_LINES WHERE list_line_id = l_qp_list_lines_rec.list_line_id and list_header_id = p_entity;
2035:

Line 2034: DELETE FROM QP_LIST_LINES WHERE list_line_id = l_qp_list_lines_rec.list_line_id and list_header_id = p_entity;

2030: l_mapping_tbl(l_count).list_line_type_code := l_qp_list_lines_rec.list_line_type_code;
2031: l_mapping_tbl(l_count).list_line_id := l_qp_list_lines_rec.list_line_id;
2032: END IF;
2033:
2034: DELETE FROM QP_LIST_LINES WHERE list_line_id = l_qp_list_lines_rec.list_line_id and list_header_id = p_entity;
2035:
2036: /*Insert line level qualifiers in case of Modifiers */
2037: IF l_list_type_code NOT IN ('PRL','AGR') THEN
2038: IF l_qp_list_lines_rec.list_line_id is not null AND

Line 2038: IF l_qp_list_lines_rec.list_line_id is not null AND

2034: DELETE FROM QP_LIST_LINES WHERE list_line_id = l_qp_list_lines_rec.list_line_id and list_header_id = p_entity;
2035:
2036: /*Insert line level qualifiers in case of Modifiers */
2037: IF l_list_type_code NOT IN ('PRL','AGR') THEN
2038: IF l_qp_list_lines_rec.list_line_id is not null AND
2039: l_qp_list_lines_rec.list_line_id <> -1 THEN
2040:
2041: FOR l_qp_qualifiers_rec IN qp_line_qualifiers_cur(p_entity,l_qp_list_lines_rec.list_line_id)
2042: LOOP

Line 2039: l_qp_list_lines_rec.list_line_id <> -1 THEN

2035:
2036: /*Insert line level qualifiers in case of Modifiers */
2037: IF l_list_type_code NOT IN ('PRL','AGR') THEN
2038: IF l_qp_list_lines_rec.list_line_id is not null AND
2039: l_qp_list_lines_rec.list_line_id <> -1 THEN
2040:
2041: FOR l_qp_qualifiers_rec IN qp_line_qualifiers_cur(p_entity,l_qp_list_lines_rec.list_line_id)
2042: LOOP
2043: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' then

Line 2041: FOR l_qp_qualifiers_rec IN qp_line_qualifiers_cur(p_entity,l_qp_list_lines_rec.list_line_id)

2037: IF l_list_type_code NOT IN ('PRL','AGR') THEN
2038: IF l_qp_list_lines_rec.list_line_id is not null AND
2039: l_qp_list_lines_rec.list_line_id <> -1 THEN
2040:
2041: FOR l_qp_qualifiers_rec IN qp_line_qualifiers_cur(p_entity,l_qp_list_lines_rec.list_line_id)
2042: LOOP
2043: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' then
2044: BEGIN
2045: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);

Line 2179: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (l_qp_list_lines_rec.list_line_id) LOOP

2175: END IF;
2176: END IF; -- List type code end
2177:
2178: /* Archive List lines pricing attributes */
2179: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (l_qp_list_lines_rec.list_line_id) LOOP
2180: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N' then
2181: BEGIN
2182: l_pric_attr_value_from_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
2183: l_pric_attr_value_to_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);

Line 2263: l_qp_list_lines_rec.list_line_id,

2259: l_qp_pricing_attributes_rec.program_application_id,
2260: l_qp_pricing_attributes_rec.program_id,
2261: l_qp_pricing_attributes_rec.program_update_date,
2262: l_qp_pricing_attributes_rec.request_id,
2263: l_qp_list_lines_rec.list_line_id,
2264: p_entity,
2265: l_qp_pricing_attributes_rec.pricing_phase_id,
2266: l_qp_pricing_attributes_rec.qualification_ind,
2267: l_qp_pricing_attributes_rec.excluder_flag,

Line 2315: AND list_line_id = l_qp_list_lines_rec.list_line_id and list_header_id = p_entity; */

2311:
2312: ---bug#13045009
2313: /* DELETE FROM qp_pricing_attributes
2314: WHERE pricing_attribute_id = l_qp_pricing_attributes_rec.pricing_attribute_id
2315: AND list_line_id = l_qp_list_lines_rec.list_line_id and list_header_id = p_entity; */
2316: ---bug#13045009
2317:
2318: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
2319: -- fnd_file.put_line(FND_FILE.LOG,'JP TEST --' || l_id_count);

Line 2320: l_list_line_id_tbl(l_id_count) := l_qp_list_lines_rec.list_line_id;

2316: ---bug#13045009
2317:
2318: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
2319: -- fnd_file.put_line(FND_FILE.LOG,'JP TEST --' || l_id_count);
2320: l_list_line_id_tbl(l_id_count) := l_qp_list_lines_rec.list_line_id;
2321: l_id_count := l_id_count+1;
2322:
2323: END IF; --Insert flag
2324: ELSE --Limit exists

Line 2325: fnd_file.put_line(FND_FILE.LOG,'Limit exists for this line and it cannot be archived : '||l_qp_list_lines_rec.list_line_id);

2321: l_id_count := l_id_count+1;
2322:
2323: END IF; --Insert flag
2324: ELSE --Limit exists
2325: fnd_file.put_line(FND_FILE.LOG,'Limit exists for this line and it cannot be archived : '||l_qp_list_lines_rec.list_line_id);
2326: l_err_count := l_err_count+1;
2327: END IF;
2328: END LOOP; /* Cursor qp_list_lines_cv LOOP */
2329: ---bug#13045009

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

2324: ELSE --Limit exists
2325: fnd_file.put_line(FND_FILE.LOG,'Limit exists for this line and it cannot be archived : '||l_qp_list_lines_rec.list_line_id);
2326: l_err_count := l_err_count+1;
2327: END IF;
2328: END LOOP; /* Cursor qp_list_lines_cv LOOP */
2329: ---bug#13045009
2330: FORALL i IN l_list_line_id_tbl.first .. l_list_line_id_tbl.last
2331: DELETE FROM QP_PRICING_ATTRIBUTES
2332: WHERE list_line_id = l_list_line_id_tbl(i)

Line 2335: CLOSE qp_list_lines_cv;

2331: DELETE FROM QP_PRICING_ATTRIBUTES
2332: WHERE list_line_id = l_list_line_id_tbl(i)
2333: AND list_header_id = p_entity;
2334: ---bug#13045009
2335: CLOSE qp_list_lines_cv;
2336:
2337: /* Archive the qp_rltd_modifiers for the Price Break Parent list_lines chosen
2338: above which are stored in the mapping table */
2339: