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 689: TYPE qp_list_lines_rec IS RECORD (

685: l_insert_flag varchar2(1);
686: l_cnt number:=0;
687: l_err_count number:=0;
688:
689: TYPE qp_list_lines_rec IS RECORD (
690: list_line_id QP_LIST_LINES.list_line_id%TYPE,
691: creation_date QP_LIST_LINES.creation_date%TYPE,
692: created_by QP_LIST_LINES.created_by%TYPE,
693: last_update_date QP_LIST_LINES.last_update_date%TYPE,

Line 690: list_line_id QP_LIST_LINES.list_line_id%TYPE,

686: l_cnt number:=0;
687: l_err_count number:=0;
688:
689: TYPE qp_list_lines_rec IS RECORD (
690: list_line_id QP_LIST_LINES.list_line_id%TYPE,
691: creation_date QP_LIST_LINES.creation_date%TYPE,
692: created_by QP_LIST_LINES.created_by%TYPE,
693: last_update_date QP_LIST_LINES.last_update_date%TYPE,
694: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,

Line 691: creation_date QP_LIST_LINES.creation_date%TYPE,

687: l_err_count number:=0;
688:
689: TYPE qp_list_lines_rec IS RECORD (
690: list_line_id QP_LIST_LINES.list_line_id%TYPE,
691: creation_date QP_LIST_LINES.creation_date%TYPE,
692: created_by QP_LIST_LINES.created_by%TYPE,
693: last_update_date QP_LIST_LINES.last_update_date%TYPE,
694: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
695: last_update_login QP_LIST_LINES.last_update_login%TYPE,

Line 692: created_by QP_LIST_LINES.created_by%TYPE,

688:
689: TYPE qp_list_lines_rec IS RECORD (
690: list_line_id QP_LIST_LINES.list_line_id%TYPE,
691: creation_date QP_LIST_LINES.creation_date%TYPE,
692: created_by QP_LIST_LINES.created_by%TYPE,
693: last_update_date QP_LIST_LINES.last_update_date%TYPE,
694: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
695: last_update_login QP_LIST_LINES.last_update_login%TYPE,
696: program_application_id QP_LIST_LINES.program_application_id%TYPE,

Line 693: last_update_date QP_LIST_LINES.last_update_date%TYPE,

689: TYPE qp_list_lines_rec IS RECORD (
690: list_line_id QP_LIST_LINES.list_line_id%TYPE,
691: creation_date QP_LIST_LINES.creation_date%TYPE,
692: created_by QP_LIST_LINES.created_by%TYPE,
693: last_update_date QP_LIST_LINES.last_update_date%TYPE,
694: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
695: last_update_login QP_LIST_LINES.last_update_login%TYPE,
696: program_application_id QP_LIST_LINES.program_application_id%TYPE,
697: program_id QP_LIST_LINES.program_id%TYPE,

Line 694: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,

690: list_line_id QP_LIST_LINES.list_line_id%TYPE,
691: creation_date QP_LIST_LINES.creation_date%TYPE,
692: created_by QP_LIST_LINES.created_by%TYPE,
693: last_update_date QP_LIST_LINES.last_update_date%TYPE,
694: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
695: last_update_login QP_LIST_LINES.last_update_login%TYPE,
696: program_application_id QP_LIST_LINES.program_application_id%TYPE,
697: program_id QP_LIST_LINES.program_id%TYPE,
698: program_update_date QP_LIST_LINES.program_update_date%TYPE,

Line 695: last_update_login QP_LIST_LINES.last_update_login%TYPE,

691: creation_date QP_LIST_LINES.creation_date%TYPE,
692: created_by QP_LIST_LINES.created_by%TYPE,
693: last_update_date QP_LIST_LINES.last_update_date%TYPE,
694: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
695: last_update_login QP_LIST_LINES.last_update_login%TYPE,
696: program_application_id QP_LIST_LINES.program_application_id%TYPE,
697: program_id QP_LIST_LINES.program_id%TYPE,
698: program_update_date QP_LIST_LINES.program_update_date%TYPE,
699: request_id QP_LIST_LINES.request_id%TYPE,

Line 696: program_application_id QP_LIST_LINES.program_application_id%TYPE,

692: created_by QP_LIST_LINES.created_by%TYPE,
693: last_update_date QP_LIST_LINES.last_update_date%TYPE,
694: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
695: last_update_login QP_LIST_LINES.last_update_login%TYPE,
696: program_application_id QP_LIST_LINES.program_application_id%TYPE,
697: program_id QP_LIST_LINES.program_id%TYPE,
698: program_update_date QP_LIST_LINES.program_update_date%TYPE,
699: request_id QP_LIST_LINES.request_id%TYPE,
700: list_header_id QP_LIST_LINES.list_header_id%TYPE,

Line 697: program_id QP_LIST_LINES.program_id%TYPE,

693: last_update_date QP_LIST_LINES.last_update_date%TYPE,
694: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
695: last_update_login QP_LIST_LINES.last_update_login%TYPE,
696: program_application_id QP_LIST_LINES.program_application_id%TYPE,
697: program_id QP_LIST_LINES.program_id%TYPE,
698: program_update_date QP_LIST_LINES.program_update_date%TYPE,
699: request_id QP_LIST_LINES.request_id%TYPE,
700: list_header_id QP_LIST_LINES.list_header_id%TYPE,
701: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,

Line 698: program_update_date QP_LIST_LINES.program_update_date%TYPE,

694: last_updated_by QP_LIST_LINES.last_updated_by%TYPE,
695: last_update_login QP_LIST_LINES.last_update_login%TYPE,
696: program_application_id QP_LIST_LINES.program_application_id%TYPE,
697: program_id QP_LIST_LINES.program_id%TYPE,
698: program_update_date QP_LIST_LINES.program_update_date%TYPE,
699: request_id QP_LIST_LINES.request_id%TYPE,
700: list_header_id QP_LIST_LINES.list_header_id%TYPE,
701: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
702: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,

Line 699: request_id QP_LIST_LINES.request_id%TYPE,

695: last_update_login QP_LIST_LINES.last_update_login%TYPE,
696: program_application_id QP_LIST_LINES.program_application_id%TYPE,
697: program_id QP_LIST_LINES.program_id%TYPE,
698: program_update_date QP_LIST_LINES.program_update_date%TYPE,
699: request_id QP_LIST_LINES.request_id%TYPE,
700: list_header_id QP_LIST_LINES.list_header_id%TYPE,
701: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
702: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
703: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,

Line 700: list_header_id QP_LIST_LINES.list_header_id%TYPE,

696: program_application_id QP_LIST_LINES.program_application_id%TYPE,
697: program_id QP_LIST_LINES.program_id%TYPE,
698: program_update_date QP_LIST_LINES.program_update_date%TYPE,
699: request_id QP_LIST_LINES.request_id%TYPE,
700: list_header_id QP_LIST_LINES.list_header_id%TYPE,
701: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
702: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
703: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
704: list_price QP_LIST_LINES.list_price%TYPE,

Line 701: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,

697: program_id QP_LIST_LINES.program_id%TYPE,
698: program_update_date QP_LIST_LINES.program_update_date%TYPE,
699: request_id QP_LIST_LINES.request_id%TYPE,
700: list_header_id QP_LIST_LINES.list_header_id%TYPE,
701: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
702: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
703: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
704: list_price QP_LIST_LINES.list_price%TYPE,
705: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,

Line 702: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,

698: program_update_date QP_LIST_LINES.program_update_date%TYPE,
699: request_id QP_LIST_LINES.request_id%TYPE,
700: list_header_id QP_LIST_LINES.list_header_id%TYPE,
701: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
702: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
703: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
704: list_price QP_LIST_LINES.list_price%TYPE,
705: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
706: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,

Line 703: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,

699: request_id QP_LIST_LINES.request_id%TYPE,
700: list_header_id QP_LIST_LINES.list_header_id%TYPE,
701: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
702: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
703: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
704: list_price QP_LIST_LINES.list_price%TYPE,
705: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
706: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
707: organization_id QP_LIST_LINES.organization_id%TYPE,

Line 704: list_price QP_LIST_LINES.list_price%TYPE,

700: list_header_id QP_LIST_LINES.list_header_id%TYPE,
701: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
702: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
703: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
704: list_price QP_LIST_LINES.list_price%TYPE,
705: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
706: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
707: organization_id QP_LIST_LINES.organization_id%TYPE,
708: related_item_id QP_LIST_LINES.related_item_id%TYPE,

Line 705: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,

701: list_line_type_code QP_LIST_LINES.list_line_type_code%TYPE,
702: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
703: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
704: list_price QP_LIST_LINES.list_price%TYPE,
705: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
706: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
707: organization_id QP_LIST_LINES.organization_id%TYPE,
708: related_item_id QP_LIST_LINES.related_item_id%TYPE,
709: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,

Line 706: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,

702: automatic_flag QP_LIST_LINES.automatic_flag%TYPE,
703: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
704: list_price QP_LIST_LINES.list_price%TYPE,
705: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
706: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
707: organization_id QP_LIST_LINES.organization_id%TYPE,
708: related_item_id QP_LIST_LINES.related_item_id%TYPE,
709: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
710: substitution_context QP_LIST_LINES.substitution_context%TYPE,

Line 707: organization_id QP_LIST_LINES.organization_id%TYPE,

703: modifier_level_code QP_LIST_LINES.modifier_level_code%TYPE,
704: list_price QP_LIST_LINES.list_price%TYPE,
705: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
706: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
707: organization_id QP_LIST_LINES.organization_id%TYPE,
708: related_item_id QP_LIST_LINES.related_item_id%TYPE,
709: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
710: substitution_context QP_LIST_LINES.substitution_context%TYPE,
711: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,

Line 708: related_item_id QP_LIST_LINES.related_item_id%TYPE,

704: list_price QP_LIST_LINES.list_price%TYPE,
705: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
706: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
707: organization_id QP_LIST_LINES.organization_id%TYPE,
708: related_item_id QP_LIST_LINES.related_item_id%TYPE,
709: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
710: substitution_context QP_LIST_LINES.substitution_context%TYPE,
711: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
712: substitution_value QP_LIST_LINES.substitution_value%TYPE,

Line 709: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,

705: primary_uom_flag QP_LIST_LINES.primary_uom_flag%TYPE,
706: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
707: organization_id QP_LIST_LINES.organization_id%TYPE,
708: related_item_id QP_LIST_LINES.related_item_id%TYPE,
709: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
710: substitution_context QP_LIST_LINES.substitution_context%TYPE,
711: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
712: substitution_value QP_LIST_LINES.substitution_value%TYPE,
713: revision QP_LIST_LINES.revision%TYPE,

Line 710: substitution_context QP_LIST_LINES.substitution_context%TYPE,

706: inventory_item_id QP_LIST_LINES.inventory_item_id%TYPE,
707: organization_id QP_LIST_LINES.organization_id%TYPE,
708: related_item_id QP_LIST_LINES.related_item_id%TYPE,
709: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
710: substitution_context QP_LIST_LINES.substitution_context%TYPE,
711: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
712: substitution_value QP_LIST_LINES.substitution_value%TYPE,
713: revision QP_LIST_LINES.revision%TYPE,
714: revision_date QP_LIST_LINES.revision_date%TYPE,

Line 711: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,

707: organization_id QP_LIST_LINES.organization_id%TYPE,
708: related_item_id QP_LIST_LINES.related_item_id%TYPE,
709: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
710: substitution_context QP_LIST_LINES.substitution_context%TYPE,
711: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
712: substitution_value QP_LIST_LINES.substitution_value%TYPE,
713: revision QP_LIST_LINES.revision%TYPE,
714: revision_date QP_LIST_LINES.revision_date%TYPE,
715: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,

Line 712: substitution_value QP_LIST_LINES.substitution_value%TYPE,

708: related_item_id QP_LIST_LINES.related_item_id%TYPE,
709: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
710: substitution_context QP_LIST_LINES.substitution_context%TYPE,
711: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
712: substitution_value QP_LIST_LINES.substitution_value%TYPE,
713: revision QP_LIST_LINES.revision%TYPE,
714: revision_date QP_LIST_LINES.revision_date%TYPE,
715: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
716: context QP_LIST_LINES.context%TYPE,

Line 713: revision QP_LIST_LINES.revision%TYPE,

709: relationship_type_id QP_LIST_LINES.relationship_type_id%TYPE,
710: substitution_context QP_LIST_LINES.substitution_context%TYPE,
711: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
712: substitution_value QP_LIST_LINES.substitution_value%TYPE,
713: revision QP_LIST_LINES.revision%TYPE,
714: revision_date QP_LIST_LINES.revision_date%TYPE,
715: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
716: context QP_LIST_LINES.context%TYPE,
717: attribute1 QP_LIST_LINES.attribute1%TYPE,

Line 714: revision_date QP_LIST_LINES.revision_date%TYPE,

710: substitution_context QP_LIST_LINES.substitution_context%TYPE,
711: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
712: substitution_value QP_LIST_LINES.substitution_value%TYPE,
713: revision QP_LIST_LINES.revision%TYPE,
714: revision_date QP_LIST_LINES.revision_date%TYPE,
715: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
716: context QP_LIST_LINES.context%TYPE,
717: attribute1 QP_LIST_LINES.attribute1%TYPE,
718: attribute2 QP_LIST_LINES.attribute2%TYPE,

Line 715: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,

711: substitution_attribute QP_LIST_LINES.substitution_attribute%TYPE,
712: substitution_value QP_LIST_LINES.substitution_value%TYPE,
713: revision QP_LIST_LINES.revision%TYPE,
714: revision_date QP_LIST_LINES.revision_date%TYPE,
715: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
716: context QP_LIST_LINES.context%TYPE,
717: attribute1 QP_LIST_LINES.attribute1%TYPE,
718: attribute2 QP_LIST_LINES.attribute2%TYPE,
719: comments QP_LIST_LINES.comments%TYPE,

Line 716: context QP_LIST_LINES.context%TYPE,

712: substitution_value QP_LIST_LINES.substitution_value%TYPE,
713: revision QP_LIST_LINES.revision%TYPE,
714: revision_date QP_LIST_LINES.revision_date%TYPE,
715: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
716: context QP_LIST_LINES.context%TYPE,
717: attribute1 QP_LIST_LINES.attribute1%TYPE,
718: attribute2 QP_LIST_LINES.attribute2%TYPE,
719: comments QP_LIST_LINES.comments%TYPE,
720: attribute3 QP_LIST_LINES.attribute3%TYPE,

Line 717: attribute1 QP_LIST_LINES.attribute1%TYPE,

713: revision QP_LIST_LINES.revision%TYPE,
714: revision_date QP_LIST_LINES.revision_date%TYPE,
715: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
716: context QP_LIST_LINES.context%TYPE,
717: attribute1 QP_LIST_LINES.attribute1%TYPE,
718: attribute2 QP_LIST_LINES.attribute2%TYPE,
719: comments QP_LIST_LINES.comments%TYPE,
720: attribute3 QP_LIST_LINES.attribute3%TYPE,
721: attribute4 QP_LIST_LINES.attribute4%TYPE,

Line 718: attribute2 QP_LIST_LINES.attribute2%TYPE,

714: revision_date QP_LIST_LINES.revision_date%TYPE,
715: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
716: context QP_LIST_LINES.context%TYPE,
717: attribute1 QP_LIST_LINES.attribute1%TYPE,
718: attribute2 QP_LIST_LINES.attribute2%TYPE,
719: comments QP_LIST_LINES.comments%TYPE,
720: attribute3 QP_LIST_LINES.attribute3%TYPE,
721: attribute4 QP_LIST_LINES.attribute4%TYPE,
722: attribute5 QP_LIST_LINES.attribute5%TYPE,

Line 719: comments QP_LIST_LINES.comments%TYPE,

715: revision_reason_code QP_LIST_LINES.revision_reason_code%TYPE,
716: context QP_LIST_LINES.context%TYPE,
717: attribute1 QP_LIST_LINES.attribute1%TYPE,
718: attribute2 QP_LIST_LINES.attribute2%TYPE,
719: comments QP_LIST_LINES.comments%TYPE,
720: attribute3 QP_LIST_LINES.attribute3%TYPE,
721: attribute4 QP_LIST_LINES.attribute4%TYPE,
722: attribute5 QP_LIST_LINES.attribute5%TYPE,
723: attribute6 QP_LIST_LINES.attribute6%TYPE,

Line 720: attribute3 QP_LIST_LINES.attribute3%TYPE,

716: context QP_LIST_LINES.context%TYPE,
717: attribute1 QP_LIST_LINES.attribute1%TYPE,
718: attribute2 QP_LIST_LINES.attribute2%TYPE,
719: comments QP_LIST_LINES.comments%TYPE,
720: attribute3 QP_LIST_LINES.attribute3%TYPE,
721: attribute4 QP_LIST_LINES.attribute4%TYPE,
722: attribute5 QP_LIST_LINES.attribute5%TYPE,
723: attribute6 QP_LIST_LINES.attribute6%TYPE,
724: attribute7 QP_LIST_LINES.attribute7%TYPE,

Line 721: attribute4 QP_LIST_LINES.attribute4%TYPE,

717: attribute1 QP_LIST_LINES.attribute1%TYPE,
718: attribute2 QP_LIST_LINES.attribute2%TYPE,
719: comments QP_LIST_LINES.comments%TYPE,
720: attribute3 QP_LIST_LINES.attribute3%TYPE,
721: attribute4 QP_LIST_LINES.attribute4%TYPE,
722: attribute5 QP_LIST_LINES.attribute5%TYPE,
723: attribute6 QP_LIST_LINES.attribute6%TYPE,
724: attribute7 QP_LIST_LINES.attribute7%TYPE,
725: attribute8 QP_LIST_LINES.attribute8%TYPE,

Line 722: attribute5 QP_LIST_LINES.attribute5%TYPE,

718: attribute2 QP_LIST_LINES.attribute2%TYPE,
719: comments QP_LIST_LINES.comments%TYPE,
720: attribute3 QP_LIST_LINES.attribute3%TYPE,
721: attribute4 QP_LIST_LINES.attribute4%TYPE,
722: attribute5 QP_LIST_LINES.attribute5%TYPE,
723: attribute6 QP_LIST_LINES.attribute6%TYPE,
724: attribute7 QP_LIST_LINES.attribute7%TYPE,
725: attribute8 QP_LIST_LINES.attribute8%TYPE,
726: attribute9 QP_LIST_LINES.attribute9%TYPE,

Line 723: attribute6 QP_LIST_LINES.attribute6%TYPE,

719: comments QP_LIST_LINES.comments%TYPE,
720: attribute3 QP_LIST_LINES.attribute3%TYPE,
721: attribute4 QP_LIST_LINES.attribute4%TYPE,
722: attribute5 QP_LIST_LINES.attribute5%TYPE,
723: attribute6 QP_LIST_LINES.attribute6%TYPE,
724: attribute7 QP_LIST_LINES.attribute7%TYPE,
725: attribute8 QP_LIST_LINES.attribute8%TYPE,
726: attribute9 QP_LIST_LINES.attribute9%TYPE,
727: attribute10 QP_LIST_LINES.attribute10%TYPE,

Line 724: attribute7 QP_LIST_LINES.attribute7%TYPE,

720: attribute3 QP_LIST_LINES.attribute3%TYPE,
721: attribute4 QP_LIST_LINES.attribute4%TYPE,
722: attribute5 QP_LIST_LINES.attribute5%TYPE,
723: attribute6 QP_LIST_LINES.attribute6%TYPE,
724: attribute7 QP_LIST_LINES.attribute7%TYPE,
725: attribute8 QP_LIST_LINES.attribute8%TYPE,
726: attribute9 QP_LIST_LINES.attribute9%TYPE,
727: attribute10 QP_LIST_LINES.attribute10%TYPE,
728: attribute11 QP_LIST_LINES.attribute11%TYPE,

Line 725: attribute8 QP_LIST_LINES.attribute8%TYPE,

721: attribute4 QP_LIST_LINES.attribute4%TYPE,
722: attribute5 QP_LIST_LINES.attribute5%TYPE,
723: attribute6 QP_LIST_LINES.attribute6%TYPE,
724: attribute7 QP_LIST_LINES.attribute7%TYPE,
725: attribute8 QP_LIST_LINES.attribute8%TYPE,
726: attribute9 QP_LIST_LINES.attribute9%TYPE,
727: attribute10 QP_LIST_LINES.attribute10%TYPE,
728: attribute11 QP_LIST_LINES.attribute11%TYPE,
729: attribute12 QP_LIST_LINES.attribute12%TYPE,

Line 726: attribute9 QP_LIST_LINES.attribute9%TYPE,

722: attribute5 QP_LIST_LINES.attribute5%TYPE,
723: attribute6 QP_LIST_LINES.attribute6%TYPE,
724: attribute7 QP_LIST_LINES.attribute7%TYPE,
725: attribute8 QP_LIST_LINES.attribute8%TYPE,
726: attribute9 QP_LIST_LINES.attribute9%TYPE,
727: attribute10 QP_LIST_LINES.attribute10%TYPE,
728: attribute11 QP_LIST_LINES.attribute11%TYPE,
729: attribute12 QP_LIST_LINES.attribute12%TYPE,
730: attribute13 QP_LIST_LINES.attribute13%TYPE,

Line 727: attribute10 QP_LIST_LINES.attribute10%TYPE,

723: attribute6 QP_LIST_LINES.attribute6%TYPE,
724: attribute7 QP_LIST_LINES.attribute7%TYPE,
725: attribute8 QP_LIST_LINES.attribute8%TYPE,
726: attribute9 QP_LIST_LINES.attribute9%TYPE,
727: attribute10 QP_LIST_LINES.attribute10%TYPE,
728: attribute11 QP_LIST_LINES.attribute11%TYPE,
729: attribute12 QP_LIST_LINES.attribute12%TYPE,
730: attribute13 QP_LIST_LINES.attribute13%TYPE,
731: attribute14 QP_LIST_LINES.attribute14%TYPE,

Line 728: attribute11 QP_LIST_LINES.attribute11%TYPE,

724: attribute7 QP_LIST_LINES.attribute7%TYPE,
725: attribute8 QP_LIST_LINES.attribute8%TYPE,
726: attribute9 QP_LIST_LINES.attribute9%TYPE,
727: attribute10 QP_LIST_LINES.attribute10%TYPE,
728: attribute11 QP_LIST_LINES.attribute11%TYPE,
729: attribute12 QP_LIST_LINES.attribute12%TYPE,
730: attribute13 QP_LIST_LINES.attribute13%TYPE,
731: attribute14 QP_LIST_LINES.attribute14%TYPE,
732: attribute15 QP_LIST_LINES.attribute15%TYPE,

Line 729: attribute12 QP_LIST_LINES.attribute12%TYPE,

725: attribute8 QP_LIST_LINES.attribute8%TYPE,
726: attribute9 QP_LIST_LINES.attribute9%TYPE,
727: attribute10 QP_LIST_LINES.attribute10%TYPE,
728: attribute11 QP_LIST_LINES.attribute11%TYPE,
729: attribute12 QP_LIST_LINES.attribute12%TYPE,
730: attribute13 QP_LIST_LINES.attribute13%TYPE,
731: attribute14 QP_LIST_LINES.attribute14%TYPE,
732: attribute15 QP_LIST_LINES.attribute15%TYPE,
733: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,

Line 730: attribute13 QP_LIST_LINES.attribute13%TYPE,

726: attribute9 QP_LIST_LINES.attribute9%TYPE,
727: attribute10 QP_LIST_LINES.attribute10%TYPE,
728: attribute11 QP_LIST_LINES.attribute11%TYPE,
729: attribute12 QP_LIST_LINES.attribute12%TYPE,
730: attribute13 QP_LIST_LINES.attribute13%TYPE,
731: attribute14 QP_LIST_LINES.attribute14%TYPE,
732: attribute15 QP_LIST_LINES.attribute15%TYPE,
733: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
734: percent_price QP_LIST_LINES.percent_price%TYPE,

Line 731: attribute14 QP_LIST_LINES.attribute14%TYPE,

727: attribute10 QP_LIST_LINES.attribute10%TYPE,
728: attribute11 QP_LIST_LINES.attribute11%TYPE,
729: attribute12 QP_LIST_LINES.attribute12%TYPE,
730: attribute13 QP_LIST_LINES.attribute13%TYPE,
731: attribute14 QP_LIST_LINES.attribute14%TYPE,
732: attribute15 QP_LIST_LINES.attribute15%TYPE,
733: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
734: percent_price QP_LIST_LINES.percent_price%TYPE,
735: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,

Line 732: attribute15 QP_LIST_LINES.attribute15%TYPE,

728: attribute11 QP_LIST_LINES.attribute11%TYPE,
729: attribute12 QP_LIST_LINES.attribute12%TYPE,
730: attribute13 QP_LIST_LINES.attribute13%TYPE,
731: attribute14 QP_LIST_LINES.attribute14%TYPE,
732: attribute15 QP_LIST_LINES.attribute15%TYPE,
733: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
734: percent_price QP_LIST_LINES.percent_price%TYPE,
735: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
736: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,

Line 733: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,

729: attribute12 QP_LIST_LINES.attribute12%TYPE,
730: attribute13 QP_LIST_LINES.attribute13%TYPE,
731: attribute14 QP_LIST_LINES.attribute14%TYPE,
732: attribute15 QP_LIST_LINES.attribute15%TYPE,
733: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
734: percent_price QP_LIST_LINES.percent_price%TYPE,
735: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
736: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
737: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,

Line 734: percent_price QP_LIST_LINES.percent_price%TYPE,

730: attribute13 QP_LIST_LINES.attribute13%TYPE,
731: attribute14 QP_LIST_LINES.attribute14%TYPE,
732: attribute15 QP_LIST_LINES.attribute15%TYPE,
733: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
734: percent_price QP_LIST_LINES.percent_price%TYPE,
735: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
736: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
737: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
738: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,

Line 735: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,

731: attribute14 QP_LIST_LINES.attribute14%TYPE,
732: attribute15 QP_LIST_LINES.attribute15%TYPE,
733: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
734: percent_price QP_LIST_LINES.percent_price%TYPE,
735: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
736: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
737: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
738: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
739: operand QP_LIST_LINES.operand%TYPE,

Line 736: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,

732: attribute15 QP_LIST_LINES.attribute15%TYPE,
733: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
734: percent_price QP_LIST_LINES.percent_price%TYPE,
735: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
736: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
737: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
738: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
739: operand QP_LIST_LINES.operand%TYPE,
740: override_flag QP_LIST_LINES.override_flag%TYPE,

Line 737: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,

733: price_break_type_code QP_LIST_LINES.price_break_type_code%TYPE,
734: percent_price QP_LIST_LINES.percent_price%TYPE,
735: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
736: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
737: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
738: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
739: operand QP_LIST_LINES.operand%TYPE,
740: override_flag QP_LIST_LINES.override_flag%TYPE,
741: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,

Line 738: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,

734: percent_price QP_LIST_LINES.percent_price%TYPE,
735: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
736: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
737: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
738: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
739: operand QP_LIST_LINES.operand%TYPE,
740: override_flag QP_LIST_LINES.override_flag%TYPE,
741: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
742: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,

Line 739: operand QP_LIST_LINES.operand%TYPE,

735: price_by_formula_id QP_LIST_LINES.price_by_formula_id%TYPE,
736: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
737: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
738: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
739: operand QP_LIST_LINES.operand%TYPE,
740: override_flag QP_LIST_LINES.override_flag%TYPE,
741: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
742: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
743: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,

Line 740: override_flag QP_LIST_LINES.override_flag%TYPE,

736: number_effective_periods QP_LIST_LINES.number_effective_periods%TYPE,
737: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
738: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
739: operand QP_LIST_LINES.operand%TYPE,
740: override_flag QP_LIST_LINES.override_flag%TYPE,
741: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
742: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
743: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
744: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,

Line 741: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,

737: effective_period_uom QP_LIST_LINES.effective_period_uom%TYPE,
738: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
739: operand QP_LIST_LINES.operand%TYPE,
740: override_flag QP_LIST_LINES.override_flag%TYPE,
741: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
742: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
743: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
744: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
745: start_date_active QP_LIST_LINES.start_date_active%TYPE,

Line 742: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,

738: arithmetic_operator QP_LIST_LINES.arithmetic_operator%TYPE,
739: operand QP_LIST_LINES.operand%TYPE,
740: override_flag QP_LIST_LINES.override_flag%TYPE,
741: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
742: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
743: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
744: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
745: start_date_active QP_LIST_LINES.start_date_active%TYPE,
746: end_date_active QP_LIST_LINES.end_date_active%TYPE,

Line 743: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,

739: operand QP_LIST_LINES.operand%TYPE,
740: override_flag QP_LIST_LINES.override_flag%TYPE,
741: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
742: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
743: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
744: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
745: start_date_active QP_LIST_LINES.start_date_active%TYPE,
746: end_date_active QP_LIST_LINES.end_date_active%TYPE,
747: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,

Line 744: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,

740: override_flag QP_LIST_LINES.override_flag%TYPE,
741: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
742: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
743: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
744: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
745: start_date_active QP_LIST_LINES.start_date_active%TYPE,
746: end_date_active QP_LIST_LINES.end_date_active%TYPE,
747: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
748: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,

Line 745: start_date_active QP_LIST_LINES.start_date_active%TYPE,

741: print_on_invoice_flag QP_LIST_LINES.print_on_invoice_flag%TYPE,
742: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
743: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
744: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
745: start_date_active QP_LIST_LINES.start_date_active%TYPE,
746: end_date_active QP_LIST_LINES.end_date_active%TYPE,
747: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
748: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
749: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,

Line 746: end_date_active QP_LIST_LINES.end_date_active%TYPE,

742: rebate_transaction_type_code QP_LIST_LINES.rebate_transaction_type_code%TYPE,
743: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
744: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
745: start_date_active QP_LIST_LINES.start_date_active%TYPE,
746: end_date_active QP_LIST_LINES.end_date_active%TYPE,
747: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
748: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
749: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
750: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,

Line 747: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,

743: estim_accrual_rate QP_LIST_LINES.estim_accrual_rate%TYPE,
744: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
745: start_date_active QP_LIST_LINES.start_date_active%TYPE,
746: end_date_active QP_LIST_LINES.end_date_active%TYPE,
747: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
748: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
749: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
750: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
751: list_line_no QP_LIST_LINES.list_line_no%TYPE,

Line 748: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,

744: generate_using_formula_id QP_LIST_LINES.generate_using_formula_id%TYPE,
745: start_date_active QP_LIST_LINES.start_date_active%TYPE,
746: end_date_active QP_LIST_LINES.end_date_active%TYPE,
747: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
748: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
749: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
750: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
751: list_line_no QP_LIST_LINES.list_line_no%TYPE,
752: product_precedence QP_LIST_LINES.product_precedence%TYPE,

Line 749: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,

745: start_date_active QP_LIST_LINES.start_date_active%TYPE,
746: end_date_active QP_LIST_LINES.end_date_active%TYPE,
747: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
748: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
749: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
750: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
751: list_line_no QP_LIST_LINES.list_line_no%TYPE,
752: product_precedence QP_LIST_LINES.product_precedence%TYPE,
753: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,

Line 750: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,

746: end_date_active QP_LIST_LINES.end_date_active%TYPE,
747: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
748: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
749: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
750: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
751: list_line_no QP_LIST_LINES.list_line_no%TYPE,
752: product_precedence QP_LIST_LINES.product_precedence%TYPE,
753: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
754: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,

Line 751: list_line_no QP_LIST_LINES.list_line_no%TYPE,

747: reprice_flag QP_LIST_LINES.reprice_flag%TYPE,
748: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
749: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
750: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
751: list_line_no QP_LIST_LINES.list_line_no%TYPE,
752: product_precedence QP_LIST_LINES.product_precedence%TYPE,
753: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
754: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
755: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,

Line 752: product_precedence QP_LIST_LINES.product_precedence%TYPE,

748: accrual_flag QP_LIST_LINES.accrual_flag%TYPE,
749: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
750: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
751: list_line_no QP_LIST_LINES.list_line_no%TYPE,
752: product_precedence QP_LIST_LINES.product_precedence%TYPE,
753: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
754: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
755: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
756: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,

Line 753: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,

749: pricing_group_sequence QP_LIST_LINES.pricing_group_sequence%TYPE,
750: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
751: list_line_no QP_LIST_LINES.list_line_no%TYPE,
752: product_precedence QP_LIST_LINES.product_precedence%TYPE,
753: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
754: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
755: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
756: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
757: expiration_date QP_LIST_LINES.expiration_date%TYPE,

Line 754: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,

750: incompatibility_grp_code QP_LIST_LINES.incompatibility_grp_code%TYPE,
751: list_line_no QP_LIST_LINES.list_line_no%TYPE,
752: product_precedence QP_LIST_LINES.product_precedence%TYPE,
753: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
754: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
755: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
756: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
757: expiration_date QP_LIST_LINES.expiration_date%TYPE,
758: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,

Line 755: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,

751: list_line_no QP_LIST_LINES.list_line_no%TYPE,
752: product_precedence QP_LIST_LINES.product_precedence%TYPE,
753: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
754: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
755: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
756: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
757: expiration_date QP_LIST_LINES.expiration_date%TYPE,
758: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
759: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,

Line 756: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,

752: product_precedence QP_LIST_LINES.product_precedence%TYPE,
753: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
754: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
755: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
756: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
757: expiration_date QP_LIST_LINES.expiration_date%TYPE,
758: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
759: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
760: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,

Line 757: expiration_date QP_LIST_LINES.expiration_date%TYPE,

753: pricing_phase_id QP_LIST_LINES.pricing_phase_id%TYPE,
754: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
755: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
756: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
757: expiration_date QP_LIST_LINES.expiration_date%TYPE,
758: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
759: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
760: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
761: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,

Line 758: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,

754: expiration_period_start_date QP_LIST_LINES.expiration_period_start_date%TYPE,
755: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
756: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
757: expiration_date QP_LIST_LINES.expiration_date%TYPE,
758: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
759: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
760: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
761: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
762: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,

Line 759: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,

755: number_expiration_periods QP_LIST_LINES.number_expiration_periods%TYPE,
756: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
757: expiration_date QP_LIST_LINES.expiration_date%TYPE,
758: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
759: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
760: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
761: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
762: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
763: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,

Line 760: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,

756: expiration_period_uom QP_LIST_LINES.expiration_period_uom%TYPE,
757: expiration_date QP_LIST_LINES.expiration_date%TYPE,
758: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
759: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
760: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
761: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
762: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
763: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
764: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,

Line 761: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,

757: expiration_date QP_LIST_LINES.expiration_date%TYPE,
758: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
759: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
760: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
761: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
762: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
763: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
764: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
765: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,

Line 762: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,

758: estim_gl_value QP_LIST_LINES.estim_gl_value%TYPE,
759: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
760: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
761: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
762: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
763: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
764: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
765: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
766: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,

Line 763: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,

759: accrual_conversion_rate QP_LIST_LINES.accrual_conversion_rate%TYPE,
760: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
761: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
762: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
763: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
764: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
765: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
766: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
767: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,

Line 764: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,

760: benefit_price_list_line_id QP_LIST_LINES.benefit_price_list_line_id%TYPE,
761: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
762: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
763: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
764: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
765: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
766: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
767: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
768: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,

Line 765: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,

761: proration_type_code QP_LIST_LINES.proration_type_code%TYPE,
762: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
763: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
764: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
765: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
766: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
767: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
768: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
769: recurring_value QP_LIST_LINES.recurring_value%TYPE,

Line 766: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,

762: benefit_qty QP_LIST_LINES.benefit_qty%TYPE,
763: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
764: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
765: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
766: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
767: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
768: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
769: recurring_value QP_LIST_LINES.recurring_value%TYPE,
770: LIST_PRICE_UOM_CODE QP_LIST_LINES.LIST_PRICE_UOM_CODE%TYPE,

Line 767: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,

763: benefit_uom_code QP_LIST_LINES.benefit_uom_code%TYPE,
764: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
765: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
766: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
767: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
768: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
769: recurring_value QP_LIST_LINES.recurring_value%TYPE,
770: LIST_PRICE_UOM_CODE QP_LIST_LINES.LIST_PRICE_UOM_CODE%TYPE,
771: BASE_QTY QP_LIST_LINES.BASE_QTY%TYPE,

Line 768: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,

764: charge_type_code QP_LIST_LINES.charge_type_code%TYPE,
765: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
766: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
767: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
768: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
769: recurring_value QP_LIST_LINES.recurring_value%TYPE,
770: LIST_PRICE_UOM_CODE QP_LIST_LINES.LIST_PRICE_UOM_CODE%TYPE,
771: BASE_QTY QP_LIST_LINES.BASE_QTY%TYPE,
772: BASE_UOM_CODE QP_LIST_LINES.BASE_UOM_CODE%TYPE,

Line 769: recurring_value QP_LIST_LINES.recurring_value%TYPE,

765: charge_subtype_code QP_LIST_LINES.charge_subtype_code%TYPE,
766: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
767: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
768: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
769: recurring_value QP_LIST_LINES.recurring_value%TYPE,
770: LIST_PRICE_UOM_CODE QP_LIST_LINES.LIST_PRICE_UOM_CODE%TYPE,
771: BASE_QTY QP_LIST_LINES.BASE_QTY%TYPE,
772: BASE_UOM_CODE QP_LIST_LINES.BASE_UOM_CODE%TYPE,
773: ACCRUAL_QTY QP_LIST_LINES.ACCRUAL_QTY%TYPE,

Line 770: LIST_PRICE_UOM_CODE QP_LIST_LINES.LIST_PRICE_UOM_CODE%TYPE,

766: benefit_limit QP_LIST_LINES.benefit_limit%TYPE,
767: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
768: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
769: recurring_value QP_LIST_LINES.recurring_value%TYPE,
770: LIST_PRICE_UOM_CODE QP_LIST_LINES.LIST_PRICE_UOM_CODE%TYPE,
771: BASE_QTY QP_LIST_LINES.BASE_QTY%TYPE,
772: BASE_UOM_CODE QP_LIST_LINES.BASE_UOM_CODE%TYPE,
773: ACCRUAL_QTY QP_LIST_LINES.ACCRUAL_QTY%TYPE,
774: ACCRUAL_UOM_CODE QP_LIST_LINES.ACCRUAL_UOM_CODE%TYPE,

Line 771: BASE_QTY QP_LIST_LINES.BASE_QTY%TYPE,

767: include_on_returns_flag QP_LIST_LINES.include_on_returns_flag%TYPE,
768: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
769: recurring_value QP_LIST_LINES.recurring_value%TYPE,
770: LIST_PRICE_UOM_CODE QP_LIST_LINES.LIST_PRICE_UOM_CODE%TYPE,
771: BASE_QTY QP_LIST_LINES.BASE_QTY%TYPE,
772: BASE_UOM_CODE QP_LIST_LINES.BASE_UOM_CODE%TYPE,
773: ACCRUAL_QTY QP_LIST_LINES.ACCRUAL_QTY%TYPE,
774: ACCRUAL_UOM_CODE QP_LIST_LINES.ACCRUAL_UOM_CODE%TYPE,
775: RECURRING_FLAG QP_LIST_LINES.RECURRING_FLAG%TYPE,

Line 772: BASE_UOM_CODE QP_LIST_LINES.BASE_UOM_CODE%TYPE,

768: qualification_ind QP_LIST_LINES.qualification_ind%TYPE,
769: recurring_value QP_LIST_LINES.recurring_value%TYPE,
770: LIST_PRICE_UOM_CODE QP_LIST_LINES.LIST_PRICE_UOM_CODE%TYPE,
771: BASE_QTY QP_LIST_LINES.BASE_QTY%TYPE,
772: BASE_UOM_CODE QP_LIST_LINES.BASE_UOM_CODE%TYPE,
773: ACCRUAL_QTY QP_LIST_LINES.ACCRUAL_QTY%TYPE,
774: ACCRUAL_UOM_CODE QP_LIST_LINES.ACCRUAL_UOM_CODE%TYPE,
775: RECURRING_FLAG QP_LIST_LINES.RECURRING_FLAG%TYPE,
776: LIMIT_EXISTS_FLAG QP_LIST_LINES.LIMIT_EXISTS_FLAG%TYPE,

Line 773: ACCRUAL_QTY QP_LIST_LINES.ACCRUAL_QTY%TYPE,

769: recurring_value QP_LIST_LINES.recurring_value%TYPE,
770: LIST_PRICE_UOM_CODE QP_LIST_LINES.LIST_PRICE_UOM_CODE%TYPE,
771: BASE_QTY QP_LIST_LINES.BASE_QTY%TYPE,
772: BASE_UOM_CODE QP_LIST_LINES.BASE_UOM_CODE%TYPE,
773: ACCRUAL_QTY QP_LIST_LINES.ACCRUAL_QTY%TYPE,
774: ACCRUAL_UOM_CODE QP_LIST_LINES.ACCRUAL_UOM_CODE%TYPE,
775: RECURRING_FLAG QP_LIST_LINES.RECURRING_FLAG%TYPE,
776: LIMIT_EXISTS_FLAG QP_LIST_LINES.LIMIT_EXISTS_FLAG%TYPE,
777: GROUP_COUNT QP_LIST_LINES.GROUP_COUNT%TYPE

Line 774: ACCRUAL_UOM_CODE QP_LIST_LINES.ACCRUAL_UOM_CODE%TYPE,

770: LIST_PRICE_UOM_CODE QP_LIST_LINES.LIST_PRICE_UOM_CODE%TYPE,
771: BASE_QTY QP_LIST_LINES.BASE_QTY%TYPE,
772: BASE_UOM_CODE QP_LIST_LINES.BASE_UOM_CODE%TYPE,
773: ACCRUAL_QTY QP_LIST_LINES.ACCRUAL_QTY%TYPE,
774: ACCRUAL_UOM_CODE QP_LIST_LINES.ACCRUAL_UOM_CODE%TYPE,
775: RECURRING_FLAG QP_LIST_LINES.RECURRING_FLAG%TYPE,
776: LIMIT_EXISTS_FLAG QP_LIST_LINES.LIMIT_EXISTS_FLAG%TYPE,
777: GROUP_COUNT QP_LIST_LINES.GROUP_COUNT%TYPE
778: ,NET_AMOUNT_FLAG QP_LIST_LINES.NET_AMOUNT_FLAG%TYPE

Line 775: RECURRING_FLAG QP_LIST_LINES.RECURRING_FLAG%TYPE,

771: BASE_QTY QP_LIST_LINES.BASE_QTY%TYPE,
772: BASE_UOM_CODE QP_LIST_LINES.BASE_UOM_CODE%TYPE,
773: ACCRUAL_QTY QP_LIST_LINES.ACCRUAL_QTY%TYPE,
774: ACCRUAL_UOM_CODE QP_LIST_LINES.ACCRUAL_UOM_CODE%TYPE,
775: RECURRING_FLAG QP_LIST_LINES.RECURRING_FLAG%TYPE,
776: LIMIT_EXISTS_FLAG QP_LIST_LINES.LIMIT_EXISTS_FLAG%TYPE,
777: GROUP_COUNT QP_LIST_LINES.GROUP_COUNT%TYPE
778: ,NET_AMOUNT_FLAG QP_LIST_LINES.NET_AMOUNT_FLAG%TYPE
779: ,CUSTOMER_ITEM_ID QP_LIST_LINES.CUSTOMER_ITEM_ID%TYPE

Line 776: LIMIT_EXISTS_FLAG QP_LIST_LINES.LIMIT_EXISTS_FLAG%TYPE,

772: BASE_UOM_CODE QP_LIST_LINES.BASE_UOM_CODE%TYPE,
773: ACCRUAL_QTY QP_LIST_LINES.ACCRUAL_QTY%TYPE,
774: ACCRUAL_UOM_CODE QP_LIST_LINES.ACCRUAL_UOM_CODE%TYPE,
775: RECURRING_FLAG QP_LIST_LINES.RECURRING_FLAG%TYPE,
776: LIMIT_EXISTS_FLAG QP_LIST_LINES.LIMIT_EXISTS_FLAG%TYPE,
777: GROUP_COUNT QP_LIST_LINES.GROUP_COUNT%TYPE
778: ,NET_AMOUNT_FLAG QP_LIST_LINES.NET_AMOUNT_FLAG%TYPE
779: ,CUSTOMER_ITEM_ID QP_LIST_LINES.CUSTOMER_ITEM_ID%TYPE
780: ,ACCUM_CONTEXT QP_LIST_LINES.ACCUM_CONTEXT%TYPE

Line 777: GROUP_COUNT QP_LIST_LINES.GROUP_COUNT%TYPE

773: ACCRUAL_QTY QP_LIST_LINES.ACCRUAL_QTY%TYPE,
774: ACCRUAL_UOM_CODE QP_LIST_LINES.ACCRUAL_UOM_CODE%TYPE,
775: RECURRING_FLAG QP_LIST_LINES.RECURRING_FLAG%TYPE,
776: LIMIT_EXISTS_FLAG QP_LIST_LINES.LIMIT_EXISTS_FLAG%TYPE,
777: GROUP_COUNT QP_LIST_LINES.GROUP_COUNT%TYPE
778: ,NET_AMOUNT_FLAG QP_LIST_LINES.NET_AMOUNT_FLAG%TYPE
779: ,CUSTOMER_ITEM_ID QP_LIST_LINES.CUSTOMER_ITEM_ID%TYPE
780: ,ACCUM_CONTEXT QP_LIST_LINES.ACCUM_CONTEXT%TYPE
781: ,ACCUM_ATTRIBUTE QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE

Line 778: ,NET_AMOUNT_FLAG QP_LIST_LINES.NET_AMOUNT_FLAG%TYPE

774: ACCRUAL_UOM_CODE QP_LIST_LINES.ACCRUAL_UOM_CODE%TYPE,
775: RECURRING_FLAG QP_LIST_LINES.RECURRING_FLAG%TYPE,
776: LIMIT_EXISTS_FLAG QP_LIST_LINES.LIMIT_EXISTS_FLAG%TYPE,
777: GROUP_COUNT QP_LIST_LINES.GROUP_COUNT%TYPE
778: ,NET_AMOUNT_FLAG QP_LIST_LINES.NET_AMOUNT_FLAG%TYPE
779: ,CUSTOMER_ITEM_ID QP_LIST_LINES.CUSTOMER_ITEM_ID%TYPE
780: ,ACCUM_CONTEXT QP_LIST_LINES.ACCUM_CONTEXT%TYPE
781: ,ACCUM_ATTRIBUTE QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE
782: ,ACCUM_ATTR_RUN_SRC_FLAG QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE

Line 779: ,CUSTOMER_ITEM_ID QP_LIST_LINES.CUSTOMER_ITEM_ID%TYPE

775: RECURRING_FLAG QP_LIST_LINES.RECURRING_FLAG%TYPE,
776: LIMIT_EXISTS_FLAG QP_LIST_LINES.LIMIT_EXISTS_FLAG%TYPE,
777: GROUP_COUNT QP_LIST_LINES.GROUP_COUNT%TYPE
778: ,NET_AMOUNT_FLAG QP_LIST_LINES.NET_AMOUNT_FLAG%TYPE
779: ,CUSTOMER_ITEM_ID QP_LIST_LINES.CUSTOMER_ITEM_ID%TYPE
780: ,ACCUM_CONTEXT QP_LIST_LINES.ACCUM_CONTEXT%TYPE
781: ,ACCUM_ATTRIBUTE QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE
782: ,ACCUM_ATTR_RUN_SRC_FLAG QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE
783: ,BREAK_UOM_CODE QP_LIST_LINES.BREAK_UOM_CODE%TYPE

Line 780: ,ACCUM_CONTEXT QP_LIST_LINES.ACCUM_CONTEXT%TYPE

776: LIMIT_EXISTS_FLAG QP_LIST_LINES.LIMIT_EXISTS_FLAG%TYPE,
777: GROUP_COUNT QP_LIST_LINES.GROUP_COUNT%TYPE
778: ,NET_AMOUNT_FLAG QP_LIST_LINES.NET_AMOUNT_FLAG%TYPE
779: ,CUSTOMER_ITEM_ID QP_LIST_LINES.CUSTOMER_ITEM_ID%TYPE
780: ,ACCUM_CONTEXT QP_LIST_LINES.ACCUM_CONTEXT%TYPE
781: ,ACCUM_ATTRIBUTE QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE
782: ,ACCUM_ATTR_RUN_SRC_FLAG QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE
783: ,BREAK_UOM_CODE QP_LIST_LINES.BREAK_UOM_CODE%TYPE
784: ,BREAK_UOM_CONTEXT QP_LIST_LINES.BREAK_UOM_CONTEXT%TYPE

Line 781: ,ACCUM_ATTRIBUTE QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE

777: GROUP_COUNT QP_LIST_LINES.GROUP_COUNT%TYPE
778: ,NET_AMOUNT_FLAG QP_LIST_LINES.NET_AMOUNT_FLAG%TYPE
779: ,CUSTOMER_ITEM_ID QP_LIST_LINES.CUSTOMER_ITEM_ID%TYPE
780: ,ACCUM_CONTEXT QP_LIST_LINES.ACCUM_CONTEXT%TYPE
781: ,ACCUM_ATTRIBUTE QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE
782: ,ACCUM_ATTR_RUN_SRC_FLAG QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE
783: ,BREAK_UOM_CODE QP_LIST_LINES.BREAK_UOM_CODE%TYPE
784: ,BREAK_UOM_CONTEXT QP_LIST_LINES.BREAK_UOM_CONTEXT%TYPE
785: ,BREAK_UOM_ATTRIBUTE QP_LIST_LINES.BREAK_UOM_ATTRIBUTE%TYPE

Line 782: ,ACCUM_ATTR_RUN_SRC_FLAG QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE

778: ,NET_AMOUNT_FLAG QP_LIST_LINES.NET_AMOUNT_FLAG%TYPE
779: ,CUSTOMER_ITEM_ID QP_LIST_LINES.CUSTOMER_ITEM_ID%TYPE
780: ,ACCUM_CONTEXT QP_LIST_LINES.ACCUM_CONTEXT%TYPE
781: ,ACCUM_ATTRIBUTE QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE
782: ,ACCUM_ATTR_RUN_SRC_FLAG QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE
783: ,BREAK_UOM_CODE QP_LIST_LINES.BREAK_UOM_CODE%TYPE
784: ,BREAK_UOM_CONTEXT QP_LIST_LINES.BREAK_UOM_CONTEXT%TYPE
785: ,BREAK_UOM_ATTRIBUTE QP_LIST_LINES.BREAK_UOM_ATTRIBUTE%TYPE
786: ,PATTERN_ID QP_LIST_LINES.PATTERN_ID%TYPE

Line 783: ,BREAK_UOM_CODE QP_LIST_LINES.BREAK_UOM_CODE%TYPE

779: ,CUSTOMER_ITEM_ID QP_LIST_LINES.CUSTOMER_ITEM_ID%TYPE
780: ,ACCUM_CONTEXT QP_LIST_LINES.ACCUM_CONTEXT%TYPE
781: ,ACCUM_ATTRIBUTE QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE
782: ,ACCUM_ATTR_RUN_SRC_FLAG QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE
783: ,BREAK_UOM_CODE QP_LIST_LINES.BREAK_UOM_CODE%TYPE
784: ,BREAK_UOM_CONTEXT QP_LIST_LINES.BREAK_UOM_CONTEXT%TYPE
785: ,BREAK_UOM_ATTRIBUTE QP_LIST_LINES.BREAK_UOM_ATTRIBUTE%TYPE
786: ,PATTERN_ID QP_LIST_LINES.PATTERN_ID%TYPE
787: ,PRODUCT_UOM_CODE QP_LIST_LINES.PRODUCT_UOM_CODE%TYPE

Line 784: ,BREAK_UOM_CONTEXT QP_LIST_LINES.BREAK_UOM_CONTEXT%TYPE

780: ,ACCUM_CONTEXT QP_LIST_LINES.ACCUM_CONTEXT%TYPE
781: ,ACCUM_ATTRIBUTE QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE
782: ,ACCUM_ATTR_RUN_SRC_FLAG QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE
783: ,BREAK_UOM_CODE QP_LIST_LINES.BREAK_UOM_CODE%TYPE
784: ,BREAK_UOM_CONTEXT QP_LIST_LINES.BREAK_UOM_CONTEXT%TYPE
785: ,BREAK_UOM_ATTRIBUTE QP_LIST_LINES.BREAK_UOM_ATTRIBUTE%TYPE
786: ,PATTERN_ID QP_LIST_LINES.PATTERN_ID%TYPE
787: ,PRODUCT_UOM_CODE QP_LIST_LINES.PRODUCT_UOM_CODE%TYPE
788: ,PRICING_ATTRIBUTE_COUNT QP_LIST_LINES.PRICING_ATTRIBUTE_COUNT%TYPE

Line 785: ,BREAK_UOM_ATTRIBUTE QP_LIST_LINES.BREAK_UOM_ATTRIBUTE%TYPE

781: ,ACCUM_ATTRIBUTE QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE
782: ,ACCUM_ATTR_RUN_SRC_FLAG QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE
783: ,BREAK_UOM_CODE QP_LIST_LINES.BREAK_UOM_CODE%TYPE
784: ,BREAK_UOM_CONTEXT QP_LIST_LINES.BREAK_UOM_CONTEXT%TYPE
785: ,BREAK_UOM_ATTRIBUTE QP_LIST_LINES.BREAK_UOM_ATTRIBUTE%TYPE
786: ,PATTERN_ID QP_LIST_LINES.PATTERN_ID%TYPE
787: ,PRODUCT_UOM_CODE QP_LIST_LINES.PRODUCT_UOM_CODE%TYPE
788: ,PRICING_ATTRIBUTE_COUNT QP_LIST_LINES.PRICING_ATTRIBUTE_COUNT%TYPE
789: ,HASH_KEY QP_LIST_LINES.HASH_KEY%TYPE

Line 786: ,PATTERN_ID QP_LIST_LINES.PATTERN_ID%TYPE

782: ,ACCUM_ATTR_RUN_SRC_FLAG QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE
783: ,BREAK_UOM_CODE QP_LIST_LINES.BREAK_UOM_CODE%TYPE
784: ,BREAK_UOM_CONTEXT QP_LIST_LINES.BREAK_UOM_CONTEXT%TYPE
785: ,BREAK_UOM_ATTRIBUTE QP_LIST_LINES.BREAK_UOM_ATTRIBUTE%TYPE
786: ,PATTERN_ID QP_LIST_LINES.PATTERN_ID%TYPE
787: ,PRODUCT_UOM_CODE QP_LIST_LINES.PRODUCT_UOM_CODE%TYPE
788: ,PRICING_ATTRIBUTE_COUNT QP_LIST_LINES.PRICING_ATTRIBUTE_COUNT%TYPE
789: ,HASH_KEY QP_LIST_LINES.HASH_KEY%TYPE
790: ,CACHE_KEY QP_LIST_LINES.CACHE_KEY%TYPE

Line 787: ,PRODUCT_UOM_CODE QP_LIST_LINES.PRODUCT_UOM_CODE%TYPE

783: ,BREAK_UOM_CODE QP_LIST_LINES.BREAK_UOM_CODE%TYPE
784: ,BREAK_UOM_CONTEXT QP_LIST_LINES.BREAK_UOM_CONTEXT%TYPE
785: ,BREAK_UOM_ATTRIBUTE QP_LIST_LINES.BREAK_UOM_ATTRIBUTE%TYPE
786: ,PATTERN_ID QP_LIST_LINES.PATTERN_ID%TYPE
787: ,PRODUCT_UOM_CODE QP_LIST_LINES.PRODUCT_UOM_CODE%TYPE
788: ,PRICING_ATTRIBUTE_COUNT QP_LIST_LINES.PRICING_ATTRIBUTE_COUNT%TYPE
789: ,HASH_KEY QP_LIST_LINES.HASH_KEY%TYPE
790: ,CACHE_KEY QP_LIST_LINES.CACHE_KEY%TYPE
791: );

Line 788: ,PRICING_ATTRIBUTE_COUNT QP_LIST_LINES.PRICING_ATTRIBUTE_COUNT%TYPE

784: ,BREAK_UOM_CONTEXT QP_LIST_LINES.BREAK_UOM_CONTEXT%TYPE
785: ,BREAK_UOM_ATTRIBUTE QP_LIST_LINES.BREAK_UOM_ATTRIBUTE%TYPE
786: ,PATTERN_ID QP_LIST_LINES.PATTERN_ID%TYPE
787: ,PRODUCT_UOM_CODE QP_LIST_LINES.PRODUCT_UOM_CODE%TYPE
788: ,PRICING_ATTRIBUTE_COUNT QP_LIST_LINES.PRICING_ATTRIBUTE_COUNT%TYPE
789: ,HASH_KEY QP_LIST_LINES.HASH_KEY%TYPE
790: ,CACHE_KEY QP_LIST_LINES.CACHE_KEY%TYPE
791: );
792:

Line 789: ,HASH_KEY QP_LIST_LINES.HASH_KEY%TYPE

785: ,BREAK_UOM_ATTRIBUTE QP_LIST_LINES.BREAK_UOM_ATTRIBUTE%TYPE
786: ,PATTERN_ID QP_LIST_LINES.PATTERN_ID%TYPE
787: ,PRODUCT_UOM_CODE QP_LIST_LINES.PRODUCT_UOM_CODE%TYPE
788: ,PRICING_ATTRIBUTE_COUNT QP_LIST_LINES.PRICING_ATTRIBUTE_COUNT%TYPE
789: ,HASH_KEY QP_LIST_LINES.HASH_KEY%TYPE
790: ,CACHE_KEY QP_LIST_LINES.CACHE_KEY%TYPE
791: );
792:
793: l_mapping_tbl mapping_tbl;

Line 790: ,CACHE_KEY QP_LIST_LINES.CACHE_KEY%TYPE

786: ,PATTERN_ID QP_LIST_LINES.PATTERN_ID%TYPE
787: ,PRODUCT_UOM_CODE QP_LIST_LINES.PRODUCT_UOM_CODE%TYPE
788: ,PRICING_ATTRIBUTE_COUNT QP_LIST_LINES.PRICING_ATTRIBUTE_COUNT%TYPE
789: ,HASH_KEY QP_LIST_LINES.HASH_KEY%TYPE
790: ,CACHE_KEY QP_LIST_LINES.CACHE_KEY%TYPE
791: );
792:
793: l_mapping_tbl mapping_tbl;
794: l_select_stmt VARCHAR2(9000);

Line 795: l_qp_list_lines_rec QP_LIST_LINES_REC;

791: );
792:
793: l_mapping_tbl mapping_tbl;
794: l_select_stmt VARCHAR2(9000);
795: l_qp_list_lines_rec QP_LIST_LINES_REC;
796: l_context VARCHAR2(30);
797: l_attribute VARCHAR2(30);
798: l_count NUMBER := 0;
799:

Line 810: qp_list_lines_cv lines_cur_typ;

806: l_min_date date := to_date('01/01/1900','DD/MM/YYYY');
807: l_max_date date := to_date('31/12/9999','DD/MM/YYYY');
808:
809: TYPE lines_cur_typ IS REF CURSOR;
810: qp_list_lines_cv lines_cur_typ;
811:
812: CURSOR qp_pricing_attributes_cur(p_from_list_line_id NUMBER)
813: IS
814: SELECT *

Line 978: FROM qp_list_lines q

974: ,q.PRODUCT_UOM_CODE
975: ,q.PRICING_ATTRIBUTE_COUNT
976: ,q.HASH_KEY
977: ,q.CACHE_KEY
978: FROM qp_list_lines q
979: WHERE q.list_header_id = :hdr
980: and nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||'''))
981: >=nvl(trunc(fnd_date.canonical_to_date(:sdat)),
982: nvl(trunc(q.start_date_active),fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(l_min_date)||''')))

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

1242: FROM qp_rltd_modifiers a
1243: WHERE a.to_rltd_modifier_id = q.list_line_id)';
1244: END IF; --all_lines end
1245:
1246: 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;
1247: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
1248: if(qp_list_lines_cv%NOTFOUND) THEN -- No list lines found satisfying the search criteria entered.
1249: CLOSE qp_list_lines_cv;
1250: RAISE NO_DATA_FOUND;

Line 1247: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;

1243: WHERE a.to_rltd_modifier_id = q.list_line_id)';
1244: END IF; --all_lines end
1245:
1246: 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;
1247: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
1248: if(qp_list_lines_cv%NOTFOUND) THEN -- No list lines found satisfying the search criteria entered.
1249: CLOSE qp_list_lines_cv;
1250: RAISE NO_DATA_FOUND;
1251: end if;

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

1244: END IF; --all_lines end
1245:
1246: 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;
1247: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
1248: if(qp_list_lines_cv%NOTFOUND) THEN -- No list lines found satisfying the search criteria entered.
1249: CLOSE qp_list_lines_cv;
1250: RAISE NO_DATA_FOUND;
1251: end if;
1252: CLOSE qp_list_lines_cv;

Line 1249: CLOSE qp_list_lines_cv;

1245:
1246: 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;
1247: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
1248: if(qp_list_lines_cv%NOTFOUND) THEN -- No list lines found satisfying the search criteria entered.
1249: CLOSE qp_list_lines_cv;
1250: RAISE NO_DATA_FOUND;
1251: end if;
1252: CLOSE qp_list_lines_cv;
1253:

Line 1252: CLOSE qp_list_lines_cv;

1248: if(qp_list_lines_cv%NOTFOUND) THEN -- No list lines found satisfying the search criteria entered.
1249: CLOSE qp_list_lines_cv;
1250: RAISE NO_DATA_FOUND;
1251: end if;
1252: CLOSE qp_list_lines_cv;
1253:
1254: /** Following code inserts pricing entity list header information into QP_ARCH_LIST_HEADERS_B **/
1255:
1256: INSERT INTO QP_ARCH_LIST_HEADERS_B

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

1701:
1702: END IF;
1703:
1704: /** Following code Archives price list lines information.**/
1705: 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;
1706: LOOP
1707: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
1708: EXIT WHEN qp_list_lines_cv%NOTFOUND;
1709:

Line 1707: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;

1703:
1704: /** Following code Archives price list lines information.**/
1705: 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;
1706: LOOP
1707: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
1708: EXIT WHEN qp_list_lines_cv%NOTFOUND;
1709:
1710: l_insert_flag := 'N'; --Reset the flag
1711:

Line 1708: EXIT WHEN qp_list_lines_cv%NOTFOUND;

1704: /** Following code Archives price list lines information.**/
1705: 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;
1706: LOOP
1707: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
1708: EXIT WHEN qp_list_lines_cv%NOTFOUND;
1709:
1710: l_insert_flag := 'N'; --Reset the flag
1711:
1712: --Check if limit exists

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

1709:
1710: l_insert_flag := 'N'; --Reset the flag
1711:
1712: --Check if limit exists
1713: IF nvl(l_qp_list_lines_rec.LIMIT_EXISTS_FLAG,'N') = 'N' THEN
1714: l_insert_flag :='Y';
1715:
1716: -- Check if line part of a formula
1717: SELECT count(*) into l_cnt

Line 1720: AND PRICE_LIST_LINE_ID=l_qp_list_lines_rec.list_line_id;

1716: -- Check if line part of a formula
1717: SELECT count(*) into l_cnt
1718: FROM QP_PRICE_FORMULA_LINES
1719: WHERE PRICE_FORMULA_LINE_TYPE_CODE = 'PLL'
1720: AND PRICE_LIST_LINE_ID=l_qp_list_lines_rec.list_line_id;
1721:
1722: IF l_cnt=0 THEN
1723: l_insert_flag :='Y';
1724: ELSE

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

1722: IF l_cnt=0 THEN
1723: l_insert_flag :='Y';
1724: ELSE
1725: l_insert_flag :='N';
1726: fnd_file.put_line(FND_FILE.LOG,'Price List line used in formula.Do not archive : '||l_qp_list_lines_rec.list_line_id);
1727: l_err_count := l_err_count+1;
1728: END IF;
1729:
1730: IF l_insert_flag ='Y' THEN

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

1729:
1730: IF l_insert_flag ='Y' THEN
1731: --Check if line a Coupon or a Benefit line or a parent to the same
1732: IF l_list_type_code = 'PRO' or l_list_type_code = 'DEL' THEN
1733: IF (l_qp_list_lines_rec.list_line_type_code = 'CIE') OR
1734: LINE_EXISTS_IN_RLTD(l_qp_list_lines_rec.list_line_id) THEN
1735: l_insert_flag :='N';
1736: fnd_file.put_line(FND_FILE.LOG,'COUPON or related BENEFIT line.Do not archive : '||l_qp_list_lines_rec.list_line_id);
1737: l_err_count := l_err_count+1;

Line 1734: LINE_EXISTS_IN_RLTD(l_qp_list_lines_rec.list_line_id) THEN

1730: IF l_insert_flag ='Y' THEN
1731: --Check if line a Coupon or a Benefit line or a parent to the same
1732: IF l_list_type_code = 'PRO' or l_list_type_code = 'DEL' THEN
1733: IF (l_qp_list_lines_rec.list_line_type_code = 'CIE') OR
1734: LINE_EXISTS_IN_RLTD(l_qp_list_lines_rec.list_line_id) THEN
1735: l_insert_flag :='N';
1736: fnd_file.put_line(FND_FILE.LOG,'COUPON or related BENEFIT line.Do not archive : '||l_qp_list_lines_rec.list_line_id);
1737: l_err_count := l_err_count+1;
1738: END IF;

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

1732: IF l_list_type_code = 'PRO' or l_list_type_code = 'DEL' THEN
1733: IF (l_qp_list_lines_rec.list_line_type_code = 'CIE') OR
1734: LINE_EXISTS_IN_RLTD(l_qp_list_lines_rec.list_line_id) THEN
1735: l_insert_flag :='N';
1736: fnd_file.put_line(FND_FILE.LOG,'COUPON or related BENEFIT line.Do not archive : '||l_qp_list_lines_rec.list_line_id);
1737: l_err_count := l_err_count+1;
1738: END IF;
1739: END IF;
1740: END IF;

Line 1850: l_qp_list_lines_rec.list_line_id,

1846: ,ARCH_PURG_REQUEST_ID
1847: )
1848: VALUES
1849: (
1850: l_qp_list_lines_rec.list_line_id,
1851: l_qp_list_lines_rec.creation_date,
1852: l_qp_list_lines_rec.created_by,
1853: l_qp_list_lines_rec.last_update_date,
1854: l_qp_list_lines_rec.last_updated_by,

Line 1851: l_qp_list_lines_rec.creation_date,

1847: )
1848: VALUES
1849: (
1850: l_qp_list_lines_rec.list_line_id,
1851: l_qp_list_lines_rec.creation_date,
1852: l_qp_list_lines_rec.created_by,
1853: l_qp_list_lines_rec.last_update_date,
1854: l_qp_list_lines_rec.last_updated_by,
1855: l_qp_list_lines_rec.last_update_login,

Line 1852: l_qp_list_lines_rec.created_by,

1848: VALUES
1849: (
1850: l_qp_list_lines_rec.list_line_id,
1851: l_qp_list_lines_rec.creation_date,
1852: l_qp_list_lines_rec.created_by,
1853: l_qp_list_lines_rec.last_update_date,
1854: l_qp_list_lines_rec.last_updated_by,
1855: l_qp_list_lines_rec.last_update_login,
1856: l_qp_list_lines_rec.program_application_id,

Line 1853: l_qp_list_lines_rec.last_update_date,

1849: (
1850: l_qp_list_lines_rec.list_line_id,
1851: l_qp_list_lines_rec.creation_date,
1852: l_qp_list_lines_rec.created_by,
1853: l_qp_list_lines_rec.last_update_date,
1854: l_qp_list_lines_rec.last_updated_by,
1855: l_qp_list_lines_rec.last_update_login,
1856: l_qp_list_lines_rec.program_application_id,
1857: l_qp_list_lines_rec.program_id,

Line 1854: l_qp_list_lines_rec.last_updated_by,

1850: l_qp_list_lines_rec.list_line_id,
1851: l_qp_list_lines_rec.creation_date,
1852: l_qp_list_lines_rec.created_by,
1853: l_qp_list_lines_rec.last_update_date,
1854: l_qp_list_lines_rec.last_updated_by,
1855: l_qp_list_lines_rec.last_update_login,
1856: l_qp_list_lines_rec.program_application_id,
1857: l_qp_list_lines_rec.program_id,
1858: l_qp_list_lines_rec.program_update_date,

Line 1855: l_qp_list_lines_rec.last_update_login,

1851: l_qp_list_lines_rec.creation_date,
1852: l_qp_list_lines_rec.created_by,
1853: l_qp_list_lines_rec.last_update_date,
1854: l_qp_list_lines_rec.last_updated_by,
1855: l_qp_list_lines_rec.last_update_login,
1856: l_qp_list_lines_rec.program_application_id,
1857: l_qp_list_lines_rec.program_id,
1858: l_qp_list_lines_rec.program_update_date,
1859: l_qp_list_lines_rec.request_id,

Line 1856: l_qp_list_lines_rec.program_application_id,

1852: l_qp_list_lines_rec.created_by,
1853: l_qp_list_lines_rec.last_update_date,
1854: l_qp_list_lines_rec.last_updated_by,
1855: l_qp_list_lines_rec.last_update_login,
1856: l_qp_list_lines_rec.program_application_id,
1857: l_qp_list_lines_rec.program_id,
1858: l_qp_list_lines_rec.program_update_date,
1859: l_qp_list_lines_rec.request_id,
1860: p_entity,

Line 1857: l_qp_list_lines_rec.program_id,

1853: l_qp_list_lines_rec.last_update_date,
1854: l_qp_list_lines_rec.last_updated_by,
1855: l_qp_list_lines_rec.last_update_login,
1856: l_qp_list_lines_rec.program_application_id,
1857: l_qp_list_lines_rec.program_id,
1858: l_qp_list_lines_rec.program_update_date,
1859: l_qp_list_lines_rec.request_id,
1860: p_entity,
1861: l_qp_list_lines_rec.list_line_type_code,

Line 1858: l_qp_list_lines_rec.program_update_date,

1854: l_qp_list_lines_rec.last_updated_by,
1855: l_qp_list_lines_rec.last_update_login,
1856: l_qp_list_lines_rec.program_application_id,
1857: l_qp_list_lines_rec.program_id,
1858: l_qp_list_lines_rec.program_update_date,
1859: l_qp_list_lines_rec.request_id,
1860: p_entity,
1861: l_qp_list_lines_rec.list_line_type_code,
1862: l_qp_list_lines_rec.start_date_active,

Line 1859: l_qp_list_lines_rec.request_id,

1855: l_qp_list_lines_rec.last_update_login,
1856: l_qp_list_lines_rec.program_application_id,
1857: l_qp_list_lines_rec.program_id,
1858: l_qp_list_lines_rec.program_update_date,
1859: l_qp_list_lines_rec.request_id,
1860: p_entity,
1861: l_qp_list_lines_rec.list_line_type_code,
1862: l_qp_list_lines_rec.start_date_active,
1863: l_qp_list_lines_rec.end_date_active,

Line 1861: l_qp_list_lines_rec.list_line_type_code,

1857: l_qp_list_lines_rec.program_id,
1858: l_qp_list_lines_rec.program_update_date,
1859: l_qp_list_lines_rec.request_id,
1860: p_entity,
1861: l_qp_list_lines_rec.list_line_type_code,
1862: l_qp_list_lines_rec.start_date_active,
1863: l_qp_list_lines_rec.end_date_active,
1864: l_qp_list_lines_rec.automatic_flag,
1865: l_qp_list_lines_rec.modifier_level_code,

Line 1862: l_qp_list_lines_rec.start_date_active,

1858: l_qp_list_lines_rec.program_update_date,
1859: l_qp_list_lines_rec.request_id,
1860: p_entity,
1861: l_qp_list_lines_rec.list_line_type_code,
1862: l_qp_list_lines_rec.start_date_active,
1863: l_qp_list_lines_rec.end_date_active,
1864: l_qp_list_lines_rec.automatic_flag,
1865: l_qp_list_lines_rec.modifier_level_code,
1866: l_qp_list_lines_rec.list_price,

Line 1863: l_qp_list_lines_rec.end_date_active,

1859: l_qp_list_lines_rec.request_id,
1860: p_entity,
1861: l_qp_list_lines_rec.list_line_type_code,
1862: l_qp_list_lines_rec.start_date_active,
1863: l_qp_list_lines_rec.end_date_active,
1864: l_qp_list_lines_rec.automatic_flag,
1865: l_qp_list_lines_rec.modifier_level_code,
1866: l_qp_list_lines_rec.list_price,
1867: l_qp_list_lines_rec.primary_uom_flag,

Line 1864: l_qp_list_lines_rec.automatic_flag,

1860: p_entity,
1861: l_qp_list_lines_rec.list_line_type_code,
1862: l_qp_list_lines_rec.start_date_active,
1863: l_qp_list_lines_rec.end_date_active,
1864: l_qp_list_lines_rec.automatic_flag,
1865: l_qp_list_lines_rec.modifier_level_code,
1866: l_qp_list_lines_rec.list_price,
1867: l_qp_list_lines_rec.primary_uom_flag,
1868: l_qp_list_lines_rec.inventory_item_id,

Line 1865: l_qp_list_lines_rec.modifier_level_code,

1861: l_qp_list_lines_rec.list_line_type_code,
1862: l_qp_list_lines_rec.start_date_active,
1863: l_qp_list_lines_rec.end_date_active,
1864: l_qp_list_lines_rec.automatic_flag,
1865: l_qp_list_lines_rec.modifier_level_code,
1866: l_qp_list_lines_rec.list_price,
1867: l_qp_list_lines_rec.primary_uom_flag,
1868: l_qp_list_lines_rec.inventory_item_id,
1869: l_qp_list_lines_rec.organization_id,

Line 1866: l_qp_list_lines_rec.list_price,

1862: l_qp_list_lines_rec.start_date_active,
1863: l_qp_list_lines_rec.end_date_active,
1864: l_qp_list_lines_rec.automatic_flag,
1865: l_qp_list_lines_rec.modifier_level_code,
1866: l_qp_list_lines_rec.list_price,
1867: l_qp_list_lines_rec.primary_uom_flag,
1868: l_qp_list_lines_rec.inventory_item_id,
1869: l_qp_list_lines_rec.organization_id,
1870: l_qp_list_lines_rec.related_item_id,

Line 1867: l_qp_list_lines_rec.primary_uom_flag,

1863: l_qp_list_lines_rec.end_date_active,
1864: l_qp_list_lines_rec.automatic_flag,
1865: l_qp_list_lines_rec.modifier_level_code,
1866: l_qp_list_lines_rec.list_price,
1867: l_qp_list_lines_rec.primary_uom_flag,
1868: l_qp_list_lines_rec.inventory_item_id,
1869: l_qp_list_lines_rec.organization_id,
1870: l_qp_list_lines_rec.related_item_id,
1871: l_qp_list_lines_rec.relationship_type_id,

Line 1868: l_qp_list_lines_rec.inventory_item_id,

1864: l_qp_list_lines_rec.automatic_flag,
1865: l_qp_list_lines_rec.modifier_level_code,
1866: l_qp_list_lines_rec.list_price,
1867: l_qp_list_lines_rec.primary_uom_flag,
1868: l_qp_list_lines_rec.inventory_item_id,
1869: l_qp_list_lines_rec.organization_id,
1870: l_qp_list_lines_rec.related_item_id,
1871: l_qp_list_lines_rec.relationship_type_id,
1872: l_qp_list_lines_rec.substitution_context,

Line 1869: l_qp_list_lines_rec.organization_id,

1865: l_qp_list_lines_rec.modifier_level_code,
1866: l_qp_list_lines_rec.list_price,
1867: l_qp_list_lines_rec.primary_uom_flag,
1868: l_qp_list_lines_rec.inventory_item_id,
1869: l_qp_list_lines_rec.organization_id,
1870: l_qp_list_lines_rec.related_item_id,
1871: l_qp_list_lines_rec.relationship_type_id,
1872: l_qp_list_lines_rec.substitution_context,
1873: l_qp_list_lines_rec.substitution_attribute,

Line 1870: l_qp_list_lines_rec.related_item_id,

1866: l_qp_list_lines_rec.list_price,
1867: l_qp_list_lines_rec.primary_uom_flag,
1868: l_qp_list_lines_rec.inventory_item_id,
1869: l_qp_list_lines_rec.organization_id,
1870: l_qp_list_lines_rec.related_item_id,
1871: l_qp_list_lines_rec.relationship_type_id,
1872: l_qp_list_lines_rec.substitution_context,
1873: l_qp_list_lines_rec.substitution_attribute,
1874: l_qp_list_lines_rec.substitution_value,

Line 1871: l_qp_list_lines_rec.relationship_type_id,

1867: l_qp_list_lines_rec.primary_uom_flag,
1868: l_qp_list_lines_rec.inventory_item_id,
1869: l_qp_list_lines_rec.organization_id,
1870: l_qp_list_lines_rec.related_item_id,
1871: l_qp_list_lines_rec.relationship_type_id,
1872: l_qp_list_lines_rec.substitution_context,
1873: l_qp_list_lines_rec.substitution_attribute,
1874: l_qp_list_lines_rec.substitution_value,
1875: l_qp_list_lines_rec.revision,

Line 1872: l_qp_list_lines_rec.substitution_context,

1868: l_qp_list_lines_rec.inventory_item_id,
1869: l_qp_list_lines_rec.organization_id,
1870: l_qp_list_lines_rec.related_item_id,
1871: l_qp_list_lines_rec.relationship_type_id,
1872: l_qp_list_lines_rec.substitution_context,
1873: l_qp_list_lines_rec.substitution_attribute,
1874: l_qp_list_lines_rec.substitution_value,
1875: l_qp_list_lines_rec.revision,
1876: l_qp_list_lines_rec.revision_date,

Line 1873: l_qp_list_lines_rec.substitution_attribute,

1869: l_qp_list_lines_rec.organization_id,
1870: l_qp_list_lines_rec.related_item_id,
1871: l_qp_list_lines_rec.relationship_type_id,
1872: l_qp_list_lines_rec.substitution_context,
1873: l_qp_list_lines_rec.substitution_attribute,
1874: l_qp_list_lines_rec.substitution_value,
1875: l_qp_list_lines_rec.revision,
1876: l_qp_list_lines_rec.revision_date,
1877: l_qp_list_lines_rec.revision_reason_code,

Line 1874: l_qp_list_lines_rec.substitution_value,

1870: l_qp_list_lines_rec.related_item_id,
1871: l_qp_list_lines_rec.relationship_type_id,
1872: l_qp_list_lines_rec.substitution_context,
1873: l_qp_list_lines_rec.substitution_attribute,
1874: l_qp_list_lines_rec.substitution_value,
1875: l_qp_list_lines_rec.revision,
1876: l_qp_list_lines_rec.revision_date,
1877: l_qp_list_lines_rec.revision_reason_code,
1878: l_qp_list_lines_rec.context,

Line 1875: l_qp_list_lines_rec.revision,

1871: l_qp_list_lines_rec.relationship_type_id,
1872: l_qp_list_lines_rec.substitution_context,
1873: l_qp_list_lines_rec.substitution_attribute,
1874: l_qp_list_lines_rec.substitution_value,
1875: l_qp_list_lines_rec.revision,
1876: l_qp_list_lines_rec.revision_date,
1877: l_qp_list_lines_rec.revision_reason_code,
1878: l_qp_list_lines_rec.context,
1879: l_qp_list_lines_rec.attribute1,

Line 1876: l_qp_list_lines_rec.revision_date,

1872: l_qp_list_lines_rec.substitution_context,
1873: l_qp_list_lines_rec.substitution_attribute,
1874: l_qp_list_lines_rec.substitution_value,
1875: l_qp_list_lines_rec.revision,
1876: l_qp_list_lines_rec.revision_date,
1877: l_qp_list_lines_rec.revision_reason_code,
1878: l_qp_list_lines_rec.context,
1879: l_qp_list_lines_rec.attribute1,
1880: l_qp_list_lines_rec.attribute2,

Line 1877: l_qp_list_lines_rec.revision_reason_code,

1873: l_qp_list_lines_rec.substitution_attribute,
1874: l_qp_list_lines_rec.substitution_value,
1875: l_qp_list_lines_rec.revision,
1876: l_qp_list_lines_rec.revision_date,
1877: l_qp_list_lines_rec.revision_reason_code,
1878: l_qp_list_lines_rec.context,
1879: l_qp_list_lines_rec.attribute1,
1880: l_qp_list_lines_rec.attribute2,
1881: l_qp_list_lines_rec.comments,

Line 1878: l_qp_list_lines_rec.context,

1874: l_qp_list_lines_rec.substitution_value,
1875: l_qp_list_lines_rec.revision,
1876: l_qp_list_lines_rec.revision_date,
1877: l_qp_list_lines_rec.revision_reason_code,
1878: l_qp_list_lines_rec.context,
1879: l_qp_list_lines_rec.attribute1,
1880: l_qp_list_lines_rec.attribute2,
1881: l_qp_list_lines_rec.comments,
1882: l_qp_list_lines_rec.attribute3,

Line 1879: l_qp_list_lines_rec.attribute1,

1875: l_qp_list_lines_rec.revision,
1876: l_qp_list_lines_rec.revision_date,
1877: l_qp_list_lines_rec.revision_reason_code,
1878: l_qp_list_lines_rec.context,
1879: l_qp_list_lines_rec.attribute1,
1880: l_qp_list_lines_rec.attribute2,
1881: l_qp_list_lines_rec.comments,
1882: l_qp_list_lines_rec.attribute3,
1883: l_qp_list_lines_rec.attribute4,

Line 1880: l_qp_list_lines_rec.attribute2,

1876: l_qp_list_lines_rec.revision_date,
1877: l_qp_list_lines_rec.revision_reason_code,
1878: l_qp_list_lines_rec.context,
1879: l_qp_list_lines_rec.attribute1,
1880: l_qp_list_lines_rec.attribute2,
1881: l_qp_list_lines_rec.comments,
1882: l_qp_list_lines_rec.attribute3,
1883: l_qp_list_lines_rec.attribute4,
1884: l_qp_list_lines_rec.attribute5,

Line 1881: l_qp_list_lines_rec.comments,

1877: l_qp_list_lines_rec.revision_reason_code,
1878: l_qp_list_lines_rec.context,
1879: l_qp_list_lines_rec.attribute1,
1880: l_qp_list_lines_rec.attribute2,
1881: l_qp_list_lines_rec.comments,
1882: l_qp_list_lines_rec.attribute3,
1883: l_qp_list_lines_rec.attribute4,
1884: l_qp_list_lines_rec.attribute5,
1885: l_qp_list_lines_rec.attribute6,

Line 1882: l_qp_list_lines_rec.attribute3,

1878: l_qp_list_lines_rec.context,
1879: l_qp_list_lines_rec.attribute1,
1880: l_qp_list_lines_rec.attribute2,
1881: l_qp_list_lines_rec.comments,
1882: l_qp_list_lines_rec.attribute3,
1883: l_qp_list_lines_rec.attribute4,
1884: l_qp_list_lines_rec.attribute5,
1885: l_qp_list_lines_rec.attribute6,
1886: l_qp_list_lines_rec.attribute7,

Line 1883: l_qp_list_lines_rec.attribute4,

1879: l_qp_list_lines_rec.attribute1,
1880: l_qp_list_lines_rec.attribute2,
1881: l_qp_list_lines_rec.comments,
1882: l_qp_list_lines_rec.attribute3,
1883: l_qp_list_lines_rec.attribute4,
1884: l_qp_list_lines_rec.attribute5,
1885: l_qp_list_lines_rec.attribute6,
1886: l_qp_list_lines_rec.attribute7,
1887: l_qp_list_lines_rec.attribute8,

Line 1884: l_qp_list_lines_rec.attribute5,

1880: l_qp_list_lines_rec.attribute2,
1881: l_qp_list_lines_rec.comments,
1882: l_qp_list_lines_rec.attribute3,
1883: l_qp_list_lines_rec.attribute4,
1884: l_qp_list_lines_rec.attribute5,
1885: l_qp_list_lines_rec.attribute6,
1886: l_qp_list_lines_rec.attribute7,
1887: l_qp_list_lines_rec.attribute8,
1888: l_qp_list_lines_rec.attribute9,

Line 1885: l_qp_list_lines_rec.attribute6,

1881: l_qp_list_lines_rec.comments,
1882: l_qp_list_lines_rec.attribute3,
1883: l_qp_list_lines_rec.attribute4,
1884: l_qp_list_lines_rec.attribute5,
1885: l_qp_list_lines_rec.attribute6,
1886: l_qp_list_lines_rec.attribute7,
1887: l_qp_list_lines_rec.attribute8,
1888: l_qp_list_lines_rec.attribute9,
1889: l_qp_list_lines_rec.attribute10,

Line 1886: l_qp_list_lines_rec.attribute7,

1882: l_qp_list_lines_rec.attribute3,
1883: l_qp_list_lines_rec.attribute4,
1884: l_qp_list_lines_rec.attribute5,
1885: l_qp_list_lines_rec.attribute6,
1886: l_qp_list_lines_rec.attribute7,
1887: l_qp_list_lines_rec.attribute8,
1888: l_qp_list_lines_rec.attribute9,
1889: l_qp_list_lines_rec.attribute10,
1890: l_qp_list_lines_rec.attribute11,

Line 1887: l_qp_list_lines_rec.attribute8,

1883: l_qp_list_lines_rec.attribute4,
1884: l_qp_list_lines_rec.attribute5,
1885: l_qp_list_lines_rec.attribute6,
1886: l_qp_list_lines_rec.attribute7,
1887: l_qp_list_lines_rec.attribute8,
1888: l_qp_list_lines_rec.attribute9,
1889: l_qp_list_lines_rec.attribute10,
1890: l_qp_list_lines_rec.attribute11,
1891: l_qp_list_lines_rec.attribute12,

Line 1888: l_qp_list_lines_rec.attribute9,

1884: l_qp_list_lines_rec.attribute5,
1885: l_qp_list_lines_rec.attribute6,
1886: l_qp_list_lines_rec.attribute7,
1887: l_qp_list_lines_rec.attribute8,
1888: l_qp_list_lines_rec.attribute9,
1889: l_qp_list_lines_rec.attribute10,
1890: l_qp_list_lines_rec.attribute11,
1891: l_qp_list_lines_rec.attribute12,
1892: l_qp_list_lines_rec.attribute13,

Line 1889: l_qp_list_lines_rec.attribute10,

1885: l_qp_list_lines_rec.attribute6,
1886: l_qp_list_lines_rec.attribute7,
1887: l_qp_list_lines_rec.attribute8,
1888: l_qp_list_lines_rec.attribute9,
1889: l_qp_list_lines_rec.attribute10,
1890: l_qp_list_lines_rec.attribute11,
1891: l_qp_list_lines_rec.attribute12,
1892: l_qp_list_lines_rec.attribute13,
1893: l_qp_list_lines_rec.attribute14,

Line 1890: l_qp_list_lines_rec.attribute11,

1886: l_qp_list_lines_rec.attribute7,
1887: l_qp_list_lines_rec.attribute8,
1888: l_qp_list_lines_rec.attribute9,
1889: l_qp_list_lines_rec.attribute10,
1890: l_qp_list_lines_rec.attribute11,
1891: l_qp_list_lines_rec.attribute12,
1892: l_qp_list_lines_rec.attribute13,
1893: l_qp_list_lines_rec.attribute14,
1894: l_qp_list_lines_rec.attribute15,

Line 1891: l_qp_list_lines_rec.attribute12,

1887: l_qp_list_lines_rec.attribute8,
1888: l_qp_list_lines_rec.attribute9,
1889: l_qp_list_lines_rec.attribute10,
1890: l_qp_list_lines_rec.attribute11,
1891: l_qp_list_lines_rec.attribute12,
1892: l_qp_list_lines_rec.attribute13,
1893: l_qp_list_lines_rec.attribute14,
1894: l_qp_list_lines_rec.attribute15,
1895: l_qp_list_lines_rec.price_break_type_code,

Line 1892: l_qp_list_lines_rec.attribute13,

1888: l_qp_list_lines_rec.attribute9,
1889: l_qp_list_lines_rec.attribute10,
1890: l_qp_list_lines_rec.attribute11,
1891: l_qp_list_lines_rec.attribute12,
1892: l_qp_list_lines_rec.attribute13,
1893: l_qp_list_lines_rec.attribute14,
1894: l_qp_list_lines_rec.attribute15,
1895: l_qp_list_lines_rec.price_break_type_code,
1896: l_qp_list_lines_rec.percent_price,

Line 1893: l_qp_list_lines_rec.attribute14,

1889: l_qp_list_lines_rec.attribute10,
1890: l_qp_list_lines_rec.attribute11,
1891: l_qp_list_lines_rec.attribute12,
1892: l_qp_list_lines_rec.attribute13,
1893: l_qp_list_lines_rec.attribute14,
1894: l_qp_list_lines_rec.attribute15,
1895: l_qp_list_lines_rec.price_break_type_code,
1896: l_qp_list_lines_rec.percent_price,
1897: l_qp_list_lines_rec.price_by_formula_id,

Line 1894: l_qp_list_lines_rec.attribute15,

1890: l_qp_list_lines_rec.attribute11,
1891: l_qp_list_lines_rec.attribute12,
1892: l_qp_list_lines_rec.attribute13,
1893: l_qp_list_lines_rec.attribute14,
1894: l_qp_list_lines_rec.attribute15,
1895: l_qp_list_lines_rec.price_break_type_code,
1896: l_qp_list_lines_rec.percent_price,
1897: l_qp_list_lines_rec.price_by_formula_id,
1898: l_qp_list_lines_rec.number_effective_periods,

Line 1895: l_qp_list_lines_rec.price_break_type_code,

1891: l_qp_list_lines_rec.attribute12,
1892: l_qp_list_lines_rec.attribute13,
1893: l_qp_list_lines_rec.attribute14,
1894: l_qp_list_lines_rec.attribute15,
1895: l_qp_list_lines_rec.price_break_type_code,
1896: l_qp_list_lines_rec.percent_price,
1897: l_qp_list_lines_rec.price_by_formula_id,
1898: l_qp_list_lines_rec.number_effective_periods,
1899: l_qp_list_lines_rec.effective_period_uom,

Line 1896: l_qp_list_lines_rec.percent_price,

1892: l_qp_list_lines_rec.attribute13,
1893: l_qp_list_lines_rec.attribute14,
1894: l_qp_list_lines_rec.attribute15,
1895: l_qp_list_lines_rec.price_break_type_code,
1896: l_qp_list_lines_rec.percent_price,
1897: l_qp_list_lines_rec.price_by_formula_id,
1898: l_qp_list_lines_rec.number_effective_periods,
1899: l_qp_list_lines_rec.effective_period_uom,
1900: l_qp_list_lines_rec.arithmetic_operator,

Line 1897: l_qp_list_lines_rec.price_by_formula_id,

1893: l_qp_list_lines_rec.attribute14,
1894: l_qp_list_lines_rec.attribute15,
1895: l_qp_list_lines_rec.price_break_type_code,
1896: l_qp_list_lines_rec.percent_price,
1897: l_qp_list_lines_rec.price_by_formula_id,
1898: l_qp_list_lines_rec.number_effective_periods,
1899: l_qp_list_lines_rec.effective_period_uom,
1900: l_qp_list_lines_rec.arithmetic_operator,
1901: l_qp_list_lines_rec.operand,

Line 1898: l_qp_list_lines_rec.number_effective_periods,

1894: l_qp_list_lines_rec.attribute15,
1895: l_qp_list_lines_rec.price_break_type_code,
1896: l_qp_list_lines_rec.percent_price,
1897: l_qp_list_lines_rec.price_by_formula_id,
1898: l_qp_list_lines_rec.number_effective_periods,
1899: l_qp_list_lines_rec.effective_period_uom,
1900: l_qp_list_lines_rec.arithmetic_operator,
1901: l_qp_list_lines_rec.operand,
1902: l_qp_list_lines_rec.override_flag,

Line 1899: l_qp_list_lines_rec.effective_period_uom,

1895: l_qp_list_lines_rec.price_break_type_code,
1896: l_qp_list_lines_rec.percent_price,
1897: l_qp_list_lines_rec.price_by_formula_id,
1898: l_qp_list_lines_rec.number_effective_periods,
1899: l_qp_list_lines_rec.effective_period_uom,
1900: l_qp_list_lines_rec.arithmetic_operator,
1901: l_qp_list_lines_rec.operand,
1902: l_qp_list_lines_rec.override_flag,
1903: l_qp_list_lines_rec.print_on_invoice_flag,

Line 1900: l_qp_list_lines_rec.arithmetic_operator,

1896: l_qp_list_lines_rec.percent_price,
1897: l_qp_list_lines_rec.price_by_formula_id,
1898: l_qp_list_lines_rec.number_effective_periods,
1899: l_qp_list_lines_rec.effective_period_uom,
1900: l_qp_list_lines_rec.arithmetic_operator,
1901: l_qp_list_lines_rec.operand,
1902: l_qp_list_lines_rec.override_flag,
1903: l_qp_list_lines_rec.print_on_invoice_flag,
1904: l_qp_list_lines_rec.rebate_transaction_type_code,

Line 1901: l_qp_list_lines_rec.operand,

1897: l_qp_list_lines_rec.price_by_formula_id,
1898: l_qp_list_lines_rec.number_effective_periods,
1899: l_qp_list_lines_rec.effective_period_uom,
1900: l_qp_list_lines_rec.arithmetic_operator,
1901: l_qp_list_lines_rec.operand,
1902: l_qp_list_lines_rec.override_flag,
1903: l_qp_list_lines_rec.print_on_invoice_flag,
1904: l_qp_list_lines_rec.rebate_transaction_type_code,
1905: l_qp_list_lines_rec.estim_accrual_rate,

Line 1902: l_qp_list_lines_rec.override_flag,

1898: l_qp_list_lines_rec.number_effective_periods,
1899: l_qp_list_lines_rec.effective_period_uom,
1900: l_qp_list_lines_rec.arithmetic_operator,
1901: l_qp_list_lines_rec.operand,
1902: l_qp_list_lines_rec.override_flag,
1903: l_qp_list_lines_rec.print_on_invoice_flag,
1904: l_qp_list_lines_rec.rebate_transaction_type_code,
1905: l_qp_list_lines_rec.estim_accrual_rate,
1906: l_qp_list_lines_rec.generate_using_formula_id,

Line 1903: l_qp_list_lines_rec.print_on_invoice_flag,

1899: l_qp_list_lines_rec.effective_period_uom,
1900: l_qp_list_lines_rec.arithmetic_operator,
1901: l_qp_list_lines_rec.operand,
1902: l_qp_list_lines_rec.override_flag,
1903: l_qp_list_lines_rec.print_on_invoice_flag,
1904: l_qp_list_lines_rec.rebate_transaction_type_code,
1905: l_qp_list_lines_rec.estim_accrual_rate,
1906: l_qp_list_lines_rec.generate_using_formula_id,
1907: l_qp_list_lines_rec.reprice_flag,

Line 1904: l_qp_list_lines_rec.rebate_transaction_type_code,

1900: l_qp_list_lines_rec.arithmetic_operator,
1901: l_qp_list_lines_rec.operand,
1902: l_qp_list_lines_rec.override_flag,
1903: l_qp_list_lines_rec.print_on_invoice_flag,
1904: l_qp_list_lines_rec.rebate_transaction_type_code,
1905: l_qp_list_lines_rec.estim_accrual_rate,
1906: l_qp_list_lines_rec.generate_using_formula_id,
1907: l_qp_list_lines_rec.reprice_flag,
1908: l_qp_list_lines_rec.accrual_flag,

Line 1905: l_qp_list_lines_rec.estim_accrual_rate,

1901: l_qp_list_lines_rec.operand,
1902: l_qp_list_lines_rec.override_flag,
1903: l_qp_list_lines_rec.print_on_invoice_flag,
1904: l_qp_list_lines_rec.rebate_transaction_type_code,
1905: l_qp_list_lines_rec.estim_accrual_rate,
1906: l_qp_list_lines_rec.generate_using_formula_id,
1907: l_qp_list_lines_rec.reprice_flag,
1908: l_qp_list_lines_rec.accrual_flag,
1909: l_qp_list_lines_rec.pricing_group_sequence,

Line 1906: l_qp_list_lines_rec.generate_using_formula_id,

1902: l_qp_list_lines_rec.override_flag,
1903: l_qp_list_lines_rec.print_on_invoice_flag,
1904: l_qp_list_lines_rec.rebate_transaction_type_code,
1905: l_qp_list_lines_rec.estim_accrual_rate,
1906: l_qp_list_lines_rec.generate_using_formula_id,
1907: l_qp_list_lines_rec.reprice_flag,
1908: l_qp_list_lines_rec.accrual_flag,
1909: l_qp_list_lines_rec.pricing_group_sequence,
1910: l_qp_list_lines_rec.incompatibility_grp_code,

Line 1907: l_qp_list_lines_rec.reprice_flag,

1903: l_qp_list_lines_rec.print_on_invoice_flag,
1904: l_qp_list_lines_rec.rebate_transaction_type_code,
1905: l_qp_list_lines_rec.estim_accrual_rate,
1906: l_qp_list_lines_rec.generate_using_formula_id,
1907: l_qp_list_lines_rec.reprice_flag,
1908: l_qp_list_lines_rec.accrual_flag,
1909: l_qp_list_lines_rec.pricing_group_sequence,
1910: l_qp_list_lines_rec.incompatibility_grp_code,
1911: l_qp_list_lines_rec.list_line_no,

Line 1908: l_qp_list_lines_rec.accrual_flag,

1904: l_qp_list_lines_rec.rebate_transaction_type_code,
1905: l_qp_list_lines_rec.estim_accrual_rate,
1906: l_qp_list_lines_rec.generate_using_formula_id,
1907: l_qp_list_lines_rec.reprice_flag,
1908: l_qp_list_lines_rec.accrual_flag,
1909: l_qp_list_lines_rec.pricing_group_sequence,
1910: l_qp_list_lines_rec.incompatibility_grp_code,
1911: l_qp_list_lines_rec.list_line_no,
1912: l_qp_list_lines_rec.product_precedence,

Line 1909: l_qp_list_lines_rec.pricing_group_sequence,

1905: l_qp_list_lines_rec.estim_accrual_rate,
1906: l_qp_list_lines_rec.generate_using_formula_id,
1907: l_qp_list_lines_rec.reprice_flag,
1908: l_qp_list_lines_rec.accrual_flag,
1909: l_qp_list_lines_rec.pricing_group_sequence,
1910: l_qp_list_lines_rec.incompatibility_grp_code,
1911: l_qp_list_lines_rec.list_line_no,
1912: l_qp_list_lines_rec.product_precedence,
1913: l_qp_list_lines_rec.pricing_phase_id,

Line 1910: l_qp_list_lines_rec.incompatibility_grp_code,

1906: l_qp_list_lines_rec.generate_using_formula_id,
1907: l_qp_list_lines_rec.reprice_flag,
1908: l_qp_list_lines_rec.accrual_flag,
1909: l_qp_list_lines_rec.pricing_group_sequence,
1910: l_qp_list_lines_rec.incompatibility_grp_code,
1911: l_qp_list_lines_rec.list_line_no,
1912: l_qp_list_lines_rec.product_precedence,
1913: l_qp_list_lines_rec.pricing_phase_id,
1914: l_qp_list_lines_rec.expiration_period_start_date,

Line 1911: l_qp_list_lines_rec.list_line_no,

1907: l_qp_list_lines_rec.reprice_flag,
1908: l_qp_list_lines_rec.accrual_flag,
1909: l_qp_list_lines_rec.pricing_group_sequence,
1910: l_qp_list_lines_rec.incompatibility_grp_code,
1911: l_qp_list_lines_rec.list_line_no,
1912: l_qp_list_lines_rec.product_precedence,
1913: l_qp_list_lines_rec.pricing_phase_id,
1914: l_qp_list_lines_rec.expiration_period_start_date,
1915: l_qp_list_lines_rec.number_expiration_periods,

Line 1912: l_qp_list_lines_rec.product_precedence,

1908: l_qp_list_lines_rec.accrual_flag,
1909: l_qp_list_lines_rec.pricing_group_sequence,
1910: l_qp_list_lines_rec.incompatibility_grp_code,
1911: l_qp_list_lines_rec.list_line_no,
1912: l_qp_list_lines_rec.product_precedence,
1913: l_qp_list_lines_rec.pricing_phase_id,
1914: l_qp_list_lines_rec.expiration_period_start_date,
1915: l_qp_list_lines_rec.number_expiration_periods,
1916: l_qp_list_lines_rec.expiration_period_uom,

Line 1913: l_qp_list_lines_rec.pricing_phase_id,

1909: l_qp_list_lines_rec.pricing_group_sequence,
1910: l_qp_list_lines_rec.incompatibility_grp_code,
1911: l_qp_list_lines_rec.list_line_no,
1912: l_qp_list_lines_rec.product_precedence,
1913: l_qp_list_lines_rec.pricing_phase_id,
1914: l_qp_list_lines_rec.expiration_period_start_date,
1915: l_qp_list_lines_rec.number_expiration_periods,
1916: l_qp_list_lines_rec.expiration_period_uom,
1917: l_qp_list_lines_rec.expiration_date,

Line 1914: l_qp_list_lines_rec.expiration_period_start_date,

1910: l_qp_list_lines_rec.incompatibility_grp_code,
1911: l_qp_list_lines_rec.list_line_no,
1912: l_qp_list_lines_rec.product_precedence,
1913: l_qp_list_lines_rec.pricing_phase_id,
1914: l_qp_list_lines_rec.expiration_period_start_date,
1915: l_qp_list_lines_rec.number_expiration_periods,
1916: l_qp_list_lines_rec.expiration_period_uom,
1917: l_qp_list_lines_rec.expiration_date,
1918: l_qp_list_lines_rec.estim_gl_value,

Line 1915: l_qp_list_lines_rec.number_expiration_periods,

1911: l_qp_list_lines_rec.list_line_no,
1912: l_qp_list_lines_rec.product_precedence,
1913: l_qp_list_lines_rec.pricing_phase_id,
1914: l_qp_list_lines_rec.expiration_period_start_date,
1915: l_qp_list_lines_rec.number_expiration_periods,
1916: l_qp_list_lines_rec.expiration_period_uom,
1917: l_qp_list_lines_rec.expiration_date,
1918: l_qp_list_lines_rec.estim_gl_value,
1919: l_qp_list_lines_rec.accrual_conversion_rate,

Line 1916: l_qp_list_lines_rec.expiration_period_uom,

1912: l_qp_list_lines_rec.product_precedence,
1913: l_qp_list_lines_rec.pricing_phase_id,
1914: l_qp_list_lines_rec.expiration_period_start_date,
1915: l_qp_list_lines_rec.number_expiration_periods,
1916: l_qp_list_lines_rec.expiration_period_uom,
1917: l_qp_list_lines_rec.expiration_date,
1918: l_qp_list_lines_rec.estim_gl_value,
1919: l_qp_list_lines_rec.accrual_conversion_rate,
1920: l_qp_list_lines_rec.benefit_price_list_line_id,

Line 1917: l_qp_list_lines_rec.expiration_date,

1913: l_qp_list_lines_rec.pricing_phase_id,
1914: l_qp_list_lines_rec.expiration_period_start_date,
1915: l_qp_list_lines_rec.number_expiration_periods,
1916: l_qp_list_lines_rec.expiration_period_uom,
1917: l_qp_list_lines_rec.expiration_date,
1918: l_qp_list_lines_rec.estim_gl_value,
1919: l_qp_list_lines_rec.accrual_conversion_rate,
1920: l_qp_list_lines_rec.benefit_price_list_line_id,
1921: l_qp_list_lines_rec.proration_type_code,

Line 1918: l_qp_list_lines_rec.estim_gl_value,

1914: l_qp_list_lines_rec.expiration_period_start_date,
1915: l_qp_list_lines_rec.number_expiration_periods,
1916: l_qp_list_lines_rec.expiration_period_uom,
1917: l_qp_list_lines_rec.expiration_date,
1918: l_qp_list_lines_rec.estim_gl_value,
1919: l_qp_list_lines_rec.accrual_conversion_rate,
1920: l_qp_list_lines_rec.benefit_price_list_line_id,
1921: l_qp_list_lines_rec.proration_type_code,
1922: l_qp_list_lines_rec.benefit_qty,

Line 1919: l_qp_list_lines_rec.accrual_conversion_rate,

1915: l_qp_list_lines_rec.number_expiration_periods,
1916: l_qp_list_lines_rec.expiration_period_uom,
1917: l_qp_list_lines_rec.expiration_date,
1918: l_qp_list_lines_rec.estim_gl_value,
1919: l_qp_list_lines_rec.accrual_conversion_rate,
1920: l_qp_list_lines_rec.benefit_price_list_line_id,
1921: l_qp_list_lines_rec.proration_type_code,
1922: l_qp_list_lines_rec.benefit_qty,
1923: l_qp_list_lines_rec.benefit_uom_code,

Line 1920: l_qp_list_lines_rec.benefit_price_list_line_id,

1916: l_qp_list_lines_rec.expiration_period_uom,
1917: l_qp_list_lines_rec.expiration_date,
1918: l_qp_list_lines_rec.estim_gl_value,
1919: l_qp_list_lines_rec.accrual_conversion_rate,
1920: l_qp_list_lines_rec.benefit_price_list_line_id,
1921: l_qp_list_lines_rec.proration_type_code,
1922: l_qp_list_lines_rec.benefit_qty,
1923: l_qp_list_lines_rec.benefit_uom_code,
1924: l_qp_list_lines_rec.charge_type_code,

Line 1921: l_qp_list_lines_rec.proration_type_code,

1917: l_qp_list_lines_rec.expiration_date,
1918: l_qp_list_lines_rec.estim_gl_value,
1919: l_qp_list_lines_rec.accrual_conversion_rate,
1920: l_qp_list_lines_rec.benefit_price_list_line_id,
1921: l_qp_list_lines_rec.proration_type_code,
1922: l_qp_list_lines_rec.benefit_qty,
1923: l_qp_list_lines_rec.benefit_uom_code,
1924: l_qp_list_lines_rec.charge_type_code,
1925: l_qp_list_lines_rec.charge_subtype_code,

Line 1922: l_qp_list_lines_rec.benefit_qty,

1918: l_qp_list_lines_rec.estim_gl_value,
1919: l_qp_list_lines_rec.accrual_conversion_rate,
1920: l_qp_list_lines_rec.benefit_price_list_line_id,
1921: l_qp_list_lines_rec.proration_type_code,
1922: l_qp_list_lines_rec.benefit_qty,
1923: l_qp_list_lines_rec.benefit_uom_code,
1924: l_qp_list_lines_rec.charge_type_code,
1925: l_qp_list_lines_rec.charge_subtype_code,
1926: l_qp_list_lines_rec.benefit_limit,

Line 1923: l_qp_list_lines_rec.benefit_uom_code,

1919: l_qp_list_lines_rec.accrual_conversion_rate,
1920: l_qp_list_lines_rec.benefit_price_list_line_id,
1921: l_qp_list_lines_rec.proration_type_code,
1922: l_qp_list_lines_rec.benefit_qty,
1923: l_qp_list_lines_rec.benefit_uom_code,
1924: l_qp_list_lines_rec.charge_type_code,
1925: l_qp_list_lines_rec.charge_subtype_code,
1926: l_qp_list_lines_rec.benefit_limit,
1927: l_qp_list_lines_rec.include_on_returns_flag,

Line 1924: l_qp_list_lines_rec.charge_type_code,

1920: l_qp_list_lines_rec.benefit_price_list_line_id,
1921: l_qp_list_lines_rec.proration_type_code,
1922: l_qp_list_lines_rec.benefit_qty,
1923: l_qp_list_lines_rec.benefit_uom_code,
1924: l_qp_list_lines_rec.charge_type_code,
1925: l_qp_list_lines_rec.charge_subtype_code,
1926: l_qp_list_lines_rec.benefit_limit,
1927: l_qp_list_lines_rec.include_on_returns_flag,
1928: l_qp_list_lines_rec.qualification_ind,

Line 1925: l_qp_list_lines_rec.charge_subtype_code,

1921: l_qp_list_lines_rec.proration_type_code,
1922: l_qp_list_lines_rec.benefit_qty,
1923: l_qp_list_lines_rec.benefit_uom_code,
1924: l_qp_list_lines_rec.charge_type_code,
1925: l_qp_list_lines_rec.charge_subtype_code,
1926: l_qp_list_lines_rec.benefit_limit,
1927: l_qp_list_lines_rec.include_on_returns_flag,
1928: l_qp_list_lines_rec.qualification_ind,
1929: l_qp_list_lines_rec.recurring_value,

Line 1926: l_qp_list_lines_rec.benefit_limit,

1922: l_qp_list_lines_rec.benefit_qty,
1923: l_qp_list_lines_rec.benefit_uom_code,
1924: l_qp_list_lines_rec.charge_type_code,
1925: l_qp_list_lines_rec.charge_subtype_code,
1926: l_qp_list_lines_rec.benefit_limit,
1927: l_qp_list_lines_rec.include_on_returns_flag,
1928: l_qp_list_lines_rec.qualification_ind,
1929: l_qp_list_lines_rec.recurring_value,
1930: l_qp_list_lines_rec.LIST_PRICE_UOM_CODE,

Line 1927: l_qp_list_lines_rec.include_on_returns_flag,

1923: l_qp_list_lines_rec.benefit_uom_code,
1924: l_qp_list_lines_rec.charge_type_code,
1925: l_qp_list_lines_rec.charge_subtype_code,
1926: l_qp_list_lines_rec.benefit_limit,
1927: l_qp_list_lines_rec.include_on_returns_flag,
1928: l_qp_list_lines_rec.qualification_ind,
1929: l_qp_list_lines_rec.recurring_value,
1930: l_qp_list_lines_rec.LIST_PRICE_UOM_CODE,
1931: l_qp_list_lines_rec.BASE_QTY,

Line 1928: l_qp_list_lines_rec.qualification_ind,

1924: l_qp_list_lines_rec.charge_type_code,
1925: l_qp_list_lines_rec.charge_subtype_code,
1926: l_qp_list_lines_rec.benefit_limit,
1927: l_qp_list_lines_rec.include_on_returns_flag,
1928: l_qp_list_lines_rec.qualification_ind,
1929: l_qp_list_lines_rec.recurring_value,
1930: l_qp_list_lines_rec.LIST_PRICE_UOM_CODE,
1931: l_qp_list_lines_rec.BASE_QTY,
1932: l_qp_list_lines_rec.BASE_UOM_CODE,

Line 1929: l_qp_list_lines_rec.recurring_value,

1925: l_qp_list_lines_rec.charge_subtype_code,
1926: l_qp_list_lines_rec.benefit_limit,
1927: l_qp_list_lines_rec.include_on_returns_flag,
1928: l_qp_list_lines_rec.qualification_ind,
1929: l_qp_list_lines_rec.recurring_value,
1930: l_qp_list_lines_rec.LIST_PRICE_UOM_CODE,
1931: l_qp_list_lines_rec.BASE_QTY,
1932: l_qp_list_lines_rec.BASE_UOM_CODE,
1933: l_qp_list_lines_rec.ACCRUAL_QTY,

Line 1930: l_qp_list_lines_rec.LIST_PRICE_UOM_CODE,

1926: l_qp_list_lines_rec.benefit_limit,
1927: l_qp_list_lines_rec.include_on_returns_flag,
1928: l_qp_list_lines_rec.qualification_ind,
1929: l_qp_list_lines_rec.recurring_value,
1930: l_qp_list_lines_rec.LIST_PRICE_UOM_CODE,
1931: l_qp_list_lines_rec.BASE_QTY,
1932: l_qp_list_lines_rec.BASE_UOM_CODE,
1933: l_qp_list_lines_rec.ACCRUAL_QTY,
1934: l_qp_list_lines_rec.ACCRUAL_UOM_CODE,

Line 1931: l_qp_list_lines_rec.BASE_QTY,

1927: l_qp_list_lines_rec.include_on_returns_flag,
1928: l_qp_list_lines_rec.qualification_ind,
1929: l_qp_list_lines_rec.recurring_value,
1930: l_qp_list_lines_rec.LIST_PRICE_UOM_CODE,
1931: l_qp_list_lines_rec.BASE_QTY,
1932: l_qp_list_lines_rec.BASE_UOM_CODE,
1933: l_qp_list_lines_rec.ACCRUAL_QTY,
1934: l_qp_list_lines_rec.ACCRUAL_UOM_CODE,
1935: l_qp_list_lines_rec.RECURRING_FLAG,

Line 1932: l_qp_list_lines_rec.BASE_UOM_CODE,

1928: l_qp_list_lines_rec.qualification_ind,
1929: l_qp_list_lines_rec.recurring_value,
1930: l_qp_list_lines_rec.LIST_PRICE_UOM_CODE,
1931: l_qp_list_lines_rec.BASE_QTY,
1932: l_qp_list_lines_rec.BASE_UOM_CODE,
1933: l_qp_list_lines_rec.ACCRUAL_QTY,
1934: l_qp_list_lines_rec.ACCRUAL_UOM_CODE,
1935: l_qp_list_lines_rec.RECURRING_FLAG,
1936: l_qp_list_lines_rec.LIMIT_EXISTS_FLAG,

Line 1933: l_qp_list_lines_rec.ACCRUAL_QTY,

1929: l_qp_list_lines_rec.recurring_value,
1930: l_qp_list_lines_rec.LIST_PRICE_UOM_CODE,
1931: l_qp_list_lines_rec.BASE_QTY,
1932: l_qp_list_lines_rec.BASE_UOM_CODE,
1933: l_qp_list_lines_rec.ACCRUAL_QTY,
1934: l_qp_list_lines_rec.ACCRUAL_UOM_CODE,
1935: l_qp_list_lines_rec.RECURRING_FLAG,
1936: l_qp_list_lines_rec.LIMIT_EXISTS_FLAG,
1937: l_qp_list_lines_rec.GROUP_COUNT,

Line 1934: l_qp_list_lines_rec.ACCRUAL_UOM_CODE,

1930: l_qp_list_lines_rec.LIST_PRICE_UOM_CODE,
1931: l_qp_list_lines_rec.BASE_QTY,
1932: l_qp_list_lines_rec.BASE_UOM_CODE,
1933: l_qp_list_lines_rec.ACCRUAL_QTY,
1934: l_qp_list_lines_rec.ACCRUAL_UOM_CODE,
1935: l_qp_list_lines_rec.RECURRING_FLAG,
1936: l_qp_list_lines_rec.LIMIT_EXISTS_FLAG,
1937: l_qp_list_lines_rec.GROUP_COUNT,
1938: l_qp_list_lines_rec.NET_AMOUNT_FLAG,

Line 1935: l_qp_list_lines_rec.RECURRING_FLAG,

1931: l_qp_list_lines_rec.BASE_QTY,
1932: l_qp_list_lines_rec.BASE_UOM_CODE,
1933: l_qp_list_lines_rec.ACCRUAL_QTY,
1934: l_qp_list_lines_rec.ACCRUAL_UOM_CODE,
1935: l_qp_list_lines_rec.RECURRING_FLAG,
1936: l_qp_list_lines_rec.LIMIT_EXISTS_FLAG,
1937: l_qp_list_lines_rec.GROUP_COUNT,
1938: l_qp_list_lines_rec.NET_AMOUNT_FLAG,
1939: l_qp_list_lines_rec.CUSTOMER_ITEM_ID,

Line 1936: l_qp_list_lines_rec.LIMIT_EXISTS_FLAG,

1932: l_qp_list_lines_rec.BASE_UOM_CODE,
1933: l_qp_list_lines_rec.ACCRUAL_QTY,
1934: l_qp_list_lines_rec.ACCRUAL_UOM_CODE,
1935: l_qp_list_lines_rec.RECURRING_FLAG,
1936: l_qp_list_lines_rec.LIMIT_EXISTS_FLAG,
1937: l_qp_list_lines_rec.GROUP_COUNT,
1938: l_qp_list_lines_rec.NET_AMOUNT_FLAG,
1939: l_qp_list_lines_rec.CUSTOMER_ITEM_ID,
1940: l_qp_list_lines_rec.ACCUM_CONTEXT,

Line 1937: l_qp_list_lines_rec.GROUP_COUNT,

1933: l_qp_list_lines_rec.ACCRUAL_QTY,
1934: l_qp_list_lines_rec.ACCRUAL_UOM_CODE,
1935: l_qp_list_lines_rec.RECURRING_FLAG,
1936: l_qp_list_lines_rec.LIMIT_EXISTS_FLAG,
1937: l_qp_list_lines_rec.GROUP_COUNT,
1938: l_qp_list_lines_rec.NET_AMOUNT_FLAG,
1939: l_qp_list_lines_rec.CUSTOMER_ITEM_ID,
1940: l_qp_list_lines_rec.ACCUM_CONTEXT,
1941: l_qp_list_lines_rec.ACCUM_ATTRIBUTE,

Line 1938: l_qp_list_lines_rec.NET_AMOUNT_FLAG,

1934: l_qp_list_lines_rec.ACCRUAL_UOM_CODE,
1935: l_qp_list_lines_rec.RECURRING_FLAG,
1936: l_qp_list_lines_rec.LIMIT_EXISTS_FLAG,
1937: l_qp_list_lines_rec.GROUP_COUNT,
1938: l_qp_list_lines_rec.NET_AMOUNT_FLAG,
1939: l_qp_list_lines_rec.CUSTOMER_ITEM_ID,
1940: l_qp_list_lines_rec.ACCUM_CONTEXT,
1941: l_qp_list_lines_rec.ACCUM_ATTRIBUTE,
1942: l_qp_list_lines_rec.ACCUM_ATTR_RUN_SRC_FLAG,

Line 1939: l_qp_list_lines_rec.CUSTOMER_ITEM_ID,

1935: l_qp_list_lines_rec.RECURRING_FLAG,
1936: l_qp_list_lines_rec.LIMIT_EXISTS_FLAG,
1937: l_qp_list_lines_rec.GROUP_COUNT,
1938: l_qp_list_lines_rec.NET_AMOUNT_FLAG,
1939: l_qp_list_lines_rec.CUSTOMER_ITEM_ID,
1940: l_qp_list_lines_rec.ACCUM_CONTEXT,
1941: l_qp_list_lines_rec.ACCUM_ATTRIBUTE,
1942: l_qp_list_lines_rec.ACCUM_ATTR_RUN_SRC_FLAG,
1943: l_qp_list_lines_rec.BREAK_UOM_CODE,

Line 1940: l_qp_list_lines_rec.ACCUM_CONTEXT,

1936: l_qp_list_lines_rec.LIMIT_EXISTS_FLAG,
1937: l_qp_list_lines_rec.GROUP_COUNT,
1938: l_qp_list_lines_rec.NET_AMOUNT_FLAG,
1939: l_qp_list_lines_rec.CUSTOMER_ITEM_ID,
1940: l_qp_list_lines_rec.ACCUM_CONTEXT,
1941: l_qp_list_lines_rec.ACCUM_ATTRIBUTE,
1942: l_qp_list_lines_rec.ACCUM_ATTR_RUN_SRC_FLAG,
1943: l_qp_list_lines_rec.BREAK_UOM_CODE,
1944: l_qp_list_lines_rec.BREAK_UOM_CONTEXT,

Line 1941: l_qp_list_lines_rec.ACCUM_ATTRIBUTE,

1937: l_qp_list_lines_rec.GROUP_COUNT,
1938: l_qp_list_lines_rec.NET_AMOUNT_FLAG,
1939: l_qp_list_lines_rec.CUSTOMER_ITEM_ID,
1940: l_qp_list_lines_rec.ACCUM_CONTEXT,
1941: l_qp_list_lines_rec.ACCUM_ATTRIBUTE,
1942: l_qp_list_lines_rec.ACCUM_ATTR_RUN_SRC_FLAG,
1943: l_qp_list_lines_rec.BREAK_UOM_CODE,
1944: l_qp_list_lines_rec.BREAK_UOM_CONTEXT,
1945: l_qp_list_lines_rec.BREAK_UOM_ATTRIBUTE,

Line 1942: l_qp_list_lines_rec.ACCUM_ATTR_RUN_SRC_FLAG,

1938: l_qp_list_lines_rec.NET_AMOUNT_FLAG,
1939: l_qp_list_lines_rec.CUSTOMER_ITEM_ID,
1940: l_qp_list_lines_rec.ACCUM_CONTEXT,
1941: l_qp_list_lines_rec.ACCUM_ATTRIBUTE,
1942: l_qp_list_lines_rec.ACCUM_ATTR_RUN_SRC_FLAG,
1943: l_qp_list_lines_rec.BREAK_UOM_CODE,
1944: l_qp_list_lines_rec.BREAK_UOM_CONTEXT,
1945: l_qp_list_lines_rec.BREAK_UOM_ATTRIBUTE,
1946: l_qp_list_lines_rec.PATTERN_ID ,

Line 1943: l_qp_list_lines_rec.BREAK_UOM_CODE,

1939: l_qp_list_lines_rec.CUSTOMER_ITEM_ID,
1940: l_qp_list_lines_rec.ACCUM_CONTEXT,
1941: l_qp_list_lines_rec.ACCUM_ATTRIBUTE,
1942: l_qp_list_lines_rec.ACCUM_ATTR_RUN_SRC_FLAG,
1943: l_qp_list_lines_rec.BREAK_UOM_CODE,
1944: l_qp_list_lines_rec.BREAK_UOM_CONTEXT,
1945: l_qp_list_lines_rec.BREAK_UOM_ATTRIBUTE,
1946: l_qp_list_lines_rec.PATTERN_ID ,
1947: l_qp_list_lines_rec.PRODUCT_UOM_CODE,

Line 1944: l_qp_list_lines_rec.BREAK_UOM_CONTEXT,

1940: l_qp_list_lines_rec.ACCUM_CONTEXT,
1941: l_qp_list_lines_rec.ACCUM_ATTRIBUTE,
1942: l_qp_list_lines_rec.ACCUM_ATTR_RUN_SRC_FLAG,
1943: l_qp_list_lines_rec.BREAK_UOM_CODE,
1944: l_qp_list_lines_rec.BREAK_UOM_CONTEXT,
1945: l_qp_list_lines_rec.BREAK_UOM_ATTRIBUTE,
1946: l_qp_list_lines_rec.PATTERN_ID ,
1947: l_qp_list_lines_rec.PRODUCT_UOM_CODE,
1948: l_qp_list_lines_rec.PRICING_ATTRIBUTE_COUNT,

Line 1945: l_qp_list_lines_rec.BREAK_UOM_ATTRIBUTE,

1941: l_qp_list_lines_rec.ACCUM_ATTRIBUTE,
1942: l_qp_list_lines_rec.ACCUM_ATTR_RUN_SRC_FLAG,
1943: l_qp_list_lines_rec.BREAK_UOM_CODE,
1944: l_qp_list_lines_rec.BREAK_UOM_CONTEXT,
1945: l_qp_list_lines_rec.BREAK_UOM_ATTRIBUTE,
1946: l_qp_list_lines_rec.PATTERN_ID ,
1947: l_qp_list_lines_rec.PRODUCT_UOM_CODE,
1948: l_qp_list_lines_rec.PRICING_ATTRIBUTE_COUNT,
1949: l_qp_list_lines_rec.HASH_KEY ,

Line 1946: l_qp_list_lines_rec.PATTERN_ID ,

1942: l_qp_list_lines_rec.ACCUM_ATTR_RUN_SRC_FLAG,
1943: l_qp_list_lines_rec.BREAK_UOM_CODE,
1944: l_qp_list_lines_rec.BREAK_UOM_CONTEXT,
1945: l_qp_list_lines_rec.BREAK_UOM_ATTRIBUTE,
1946: l_qp_list_lines_rec.PATTERN_ID ,
1947: l_qp_list_lines_rec.PRODUCT_UOM_CODE,
1948: l_qp_list_lines_rec.PRICING_ATTRIBUTE_COUNT,
1949: l_qp_list_lines_rec.HASH_KEY ,
1950: l_qp_list_lines_rec.CACHE_KEY,

Line 1947: l_qp_list_lines_rec.PRODUCT_UOM_CODE,

1943: l_qp_list_lines_rec.BREAK_UOM_CODE,
1944: l_qp_list_lines_rec.BREAK_UOM_CONTEXT,
1945: l_qp_list_lines_rec.BREAK_UOM_ATTRIBUTE,
1946: l_qp_list_lines_rec.PATTERN_ID ,
1947: l_qp_list_lines_rec.PRODUCT_UOM_CODE,
1948: l_qp_list_lines_rec.PRICING_ATTRIBUTE_COUNT,
1949: l_qp_list_lines_rec.HASH_KEY ,
1950: l_qp_list_lines_rec.CACHE_KEY,
1951: l_conc_request_id

Line 1948: l_qp_list_lines_rec.PRICING_ATTRIBUTE_COUNT,

1944: l_qp_list_lines_rec.BREAK_UOM_CONTEXT,
1945: l_qp_list_lines_rec.BREAK_UOM_ATTRIBUTE,
1946: l_qp_list_lines_rec.PATTERN_ID ,
1947: l_qp_list_lines_rec.PRODUCT_UOM_CODE,
1948: l_qp_list_lines_rec.PRICING_ATTRIBUTE_COUNT,
1949: l_qp_list_lines_rec.HASH_KEY ,
1950: l_qp_list_lines_rec.CACHE_KEY,
1951: l_conc_request_id
1952: );

Line 1949: l_qp_list_lines_rec.HASH_KEY ,

1945: l_qp_list_lines_rec.BREAK_UOM_ATTRIBUTE,
1946: l_qp_list_lines_rec.PATTERN_ID ,
1947: l_qp_list_lines_rec.PRODUCT_UOM_CODE,
1948: l_qp_list_lines_rec.PRICING_ATTRIBUTE_COUNT,
1949: l_qp_list_lines_rec.HASH_KEY ,
1950: l_qp_list_lines_rec.CACHE_KEY,
1951: l_conc_request_id
1952: );
1953:

Line 1950: l_qp_list_lines_rec.CACHE_KEY,

1946: l_qp_list_lines_rec.PATTERN_ID ,
1947: l_qp_list_lines_rec.PRODUCT_UOM_CODE,
1948: l_qp_list_lines_rec.PRICING_ATTRIBUTE_COUNT,
1949: l_qp_list_lines_rec.HASH_KEY ,
1950: l_qp_list_lines_rec.CACHE_KEY,
1951: l_conc_request_id
1952: );
1953:
1954: g_count_list_line:=g_count_list_line + sql%rowcount;

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

1955:
1956: /*If the list_line_rec is a Price Break Parent Line or a promotional or other item discount parent line then
1957: store the list line id in a mapping-array for later use*/
1958:
1959: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' OR
1960: l_qp_list_lines_rec.list_line_type_code = 'OID' OR
1961: l_qp_list_lines_rec.list_line_type_code = 'PRG' THEN
1962:
1963: l_count := l_count + 1;

Line 1960: l_qp_list_lines_rec.list_line_type_code = 'OID' OR

1956: /*If the list_line_rec is a Price Break Parent Line or a promotional or other item discount parent line then
1957: store the list line id in a mapping-array for later use*/
1958:
1959: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' OR
1960: l_qp_list_lines_rec.list_line_type_code = 'OID' OR
1961: l_qp_list_lines_rec.list_line_type_code = 'PRG' THEN
1962:
1963: l_count := l_count + 1;
1964: l_mapping_tbl(l_count).list_line_type_code := l_qp_list_lines_rec.list_line_type_code;

Line 1961: l_qp_list_lines_rec.list_line_type_code = 'PRG' THEN

1957: store the list line id in a mapping-array for later use*/
1958:
1959: IF l_qp_list_lines_rec.list_line_type_code = 'PBH' OR
1960: l_qp_list_lines_rec.list_line_type_code = 'OID' OR
1961: l_qp_list_lines_rec.list_line_type_code = 'PRG' THEN
1962:
1963: l_count := l_count + 1;
1964: l_mapping_tbl(l_count).list_line_type_code := l_qp_list_lines_rec.list_line_type_code;
1965: l_mapping_tbl(l_count).list_line_id := l_qp_list_lines_rec.list_line_id;

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

1960: l_qp_list_lines_rec.list_line_type_code = 'OID' OR
1961: l_qp_list_lines_rec.list_line_type_code = 'PRG' THEN
1962:
1963: l_count := l_count + 1;
1964: l_mapping_tbl(l_count).list_line_type_code := l_qp_list_lines_rec.list_line_type_code;
1965: l_mapping_tbl(l_count).list_line_id := l_qp_list_lines_rec.list_line_id;
1966: END IF;
1967:
1968: DELETE FROM QP_LIST_LINES WHERE list_line_id = l_qp_list_lines_rec.list_line_id and list_header_id = p_entity;

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

1961: l_qp_list_lines_rec.list_line_type_code = 'PRG' THEN
1962:
1963: l_count := l_count + 1;
1964: l_mapping_tbl(l_count).list_line_type_code := l_qp_list_lines_rec.list_line_type_code;
1965: l_mapping_tbl(l_count).list_line_id := l_qp_list_lines_rec.list_line_id;
1966: END IF;
1967:
1968: DELETE FROM QP_LIST_LINES WHERE list_line_id = l_qp_list_lines_rec.list_line_id and list_header_id = p_entity;
1969:

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

1964: l_mapping_tbl(l_count).list_line_type_code := l_qp_list_lines_rec.list_line_type_code;
1965: l_mapping_tbl(l_count).list_line_id := l_qp_list_lines_rec.list_line_id;
1966: END IF;
1967:
1968: DELETE FROM QP_LIST_LINES WHERE list_line_id = l_qp_list_lines_rec.list_line_id and list_header_id = p_entity;
1969:
1970: /*Insert line level qualifiers in case of Modifiers */
1971: IF l_list_type_code NOT IN ('PRL','AGR') THEN
1972: IF l_qp_list_lines_rec.list_line_id is not null AND

Line 1972: IF l_qp_list_lines_rec.list_line_id is not null AND

1968: DELETE FROM QP_LIST_LINES WHERE list_line_id = l_qp_list_lines_rec.list_line_id and list_header_id = p_entity;
1969:
1970: /*Insert line level qualifiers in case of Modifiers */
1971: IF l_list_type_code NOT IN ('PRL','AGR') THEN
1972: IF l_qp_list_lines_rec.list_line_id is not null AND
1973: l_qp_list_lines_rec.list_line_id <> -1 THEN
1974:
1975: FOR l_qp_qualifiers_rec IN qp_line_qualifiers_cur(p_entity,l_qp_list_lines_rec.list_line_id)
1976: LOOP

Line 1973: l_qp_list_lines_rec.list_line_id <> -1 THEN

1969:
1970: /*Insert line level qualifiers in case of Modifiers */
1971: IF l_list_type_code NOT IN ('PRL','AGR') THEN
1972: IF l_qp_list_lines_rec.list_line_id is not null AND
1973: l_qp_list_lines_rec.list_line_id <> -1 THEN
1974:
1975: FOR l_qp_qualifiers_rec IN qp_line_qualifiers_cur(p_entity,l_qp_list_lines_rec.list_line_id)
1976: LOOP
1977: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' then

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

1971: IF l_list_type_code NOT IN ('PRL','AGR') THEN
1972: IF l_qp_list_lines_rec.list_line_id is not null AND
1973: l_qp_list_lines_rec.list_line_id <> -1 THEN
1974:
1975: FOR l_qp_qualifiers_rec IN qp_line_qualifiers_cur(p_entity,l_qp_list_lines_rec.list_line_id)
1976: LOOP
1977: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' then
1978: BEGIN
1979: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);

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

2109: END IF;
2110: END IF; -- List type code end
2111:
2112: /* Archive List lines pricing attributes */
2113: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (l_qp_list_lines_rec.list_line_id) LOOP
2114: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N' then
2115: BEGIN
2116: l_pric_attr_value_from_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
2117: l_pric_attr_value_to_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);

Line 2197: l_qp_list_lines_rec.list_line_id,

2193: l_qp_pricing_attributes_rec.program_application_id,
2194: l_qp_pricing_attributes_rec.program_id,
2195: l_qp_pricing_attributes_rec.program_update_date,
2196: l_qp_pricing_attributes_rec.request_id,
2197: l_qp_list_lines_rec.list_line_id,
2198: p_entity,
2199: l_qp_pricing_attributes_rec.pricing_phase_id,
2200: l_qp_pricing_attributes_rec.qualification_ind,
2201: l_qp_pricing_attributes_rec.excluder_flag,

Line 2248: AND list_line_id = l_qp_list_lines_rec.list_line_id and list_header_id = p_entity;

2244: g_count_pricing_att := g_count_pricing_att + sql%rowcount;
2245:
2246: DELETE FROM qp_pricing_attributes
2247: WHERE pricing_attribute_id = l_qp_pricing_attributes_rec.pricing_attribute_id
2248: AND list_line_id = l_qp_list_lines_rec.list_line_id and list_header_id = p_entity;
2249:
2250: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
2251:
2252: END IF; --Insert flag

Line 2254: 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);

2250: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
2251:
2252: END IF; --Insert flag
2253: ELSE --Limit exists
2254: 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);
2255: l_err_count := l_err_count+1;
2256: END IF;
2257: END LOOP; /* Cursor qp_list_lines_cv LOOP */
2258:

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

2253: ELSE --Limit exists
2254: 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);
2255: l_err_count := l_err_count+1;
2256: END IF;
2257: END LOOP; /* Cursor qp_list_lines_cv LOOP */
2258:
2259: CLOSE qp_list_lines_cv;
2260:
2261: /* Archive the qp_rltd_modifiers for the Price Break Parent list_lines chosen

Line 2259: CLOSE qp_list_lines_cv;

2255: l_err_count := l_err_count+1;
2256: END IF;
2257: END LOOP; /* Cursor qp_list_lines_cv LOOP */
2258:
2259: CLOSE qp_list_lines_cv;
2260:
2261: /* Archive the qp_rltd_modifiers for the Price Break Parent list_lines chosen
2262: above which are stored in the mapping table */
2263: