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.INL_CHARGE_PVT dependencies on QP_PREQ_GRP

Line 639: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;

635: l_currency_code DBMS_SQL.varchar2_table;
636: l_line_quantities DBMS_SQL.number_table;
637: l_line_1ary_quantities DBMS_SQL.number_table; --BUG#8928845
638:
639: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
640: l_line_id_tbl QP_PREQ_GRP.number_type;
641: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
642: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
643: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type;

Line 640: l_line_id_tbl QP_PREQ_GRP.number_type;

636: l_line_quantities DBMS_SQL.number_table;
637: l_line_1ary_quantities DBMS_SQL.number_table; --BUG#8928845
638:
639: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
640: l_line_id_tbl QP_PREQ_GRP.number_type;
641: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
642: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
643: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type;
644: l_active_date_first_tbl QP_PREQ_GRP.date_type;

Line 641: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;

637: l_line_1ary_quantities DBMS_SQL.number_table; --BUG#8928845
638:
639: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
640: l_line_id_tbl QP_PREQ_GRP.number_type;
641: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
642: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
643: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type;
644: l_active_date_first_tbl QP_PREQ_GRP.date_type;
645: l_active_date_second_tbl QP_PREQ_GRP.date_type;

Line 642: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;

638:
639: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
640: l_line_id_tbl QP_PREQ_GRP.number_type;
641: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
642: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
643: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type;
644: l_active_date_first_tbl QP_PREQ_GRP.date_type;
645: l_active_date_second_tbl QP_PREQ_GRP.date_type;
646: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;

Line 643: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type;

639: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
640: l_line_id_tbl QP_PREQ_GRP.number_type;
641: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
642: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
643: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type;
644: l_active_date_first_tbl QP_PREQ_GRP.date_type;
645: l_active_date_second_tbl QP_PREQ_GRP.date_type;
646: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
647: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type;

Line 644: l_active_date_first_tbl QP_PREQ_GRP.date_type;

640: l_line_id_tbl QP_PREQ_GRP.number_type;
641: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
642: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
643: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type;
644: l_active_date_first_tbl QP_PREQ_GRP.date_type;
645: l_active_date_second_tbl QP_PREQ_GRP.date_type;
646: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
647: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type;
648: l_line_unit_price_tbl QP_PREQ_GRP.number_type;

Line 645: l_active_date_second_tbl QP_PREQ_GRP.date_type;

641: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
642: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
643: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type;
644: l_active_date_first_tbl QP_PREQ_GRP.date_type;
645: l_active_date_second_tbl QP_PREQ_GRP.date_type;
646: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
647: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type;
648: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
649: l_line_quantity_tbl QP_PREQ_GRP.number_type;

Line 646: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;

642: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
643: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type;
644: l_active_date_first_tbl QP_PREQ_GRP.date_type;
645: l_active_date_second_tbl QP_PREQ_GRP.date_type;
646: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
647: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type;
648: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
649: l_line_quantity_tbl QP_PREQ_GRP.number_type;
650: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;

Line 647: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type;

643: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type;
644: l_active_date_first_tbl QP_PREQ_GRP.date_type;
645: l_active_date_second_tbl QP_PREQ_GRP.date_type;
646: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
647: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type;
648: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
649: l_line_quantity_tbl QP_PREQ_GRP.number_type;
650: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
651: l_currency_code_tbl QP_PREQ_GRP.varchar_type;

Line 648: l_line_unit_price_tbl QP_PREQ_GRP.number_type;

644: l_active_date_first_tbl QP_PREQ_GRP.date_type;
645: l_active_date_second_tbl QP_PREQ_GRP.date_type;
646: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
647: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type;
648: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
649: l_line_quantity_tbl QP_PREQ_GRP.number_type;
650: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
651: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
652: l_price_flag_tbl QP_PREQ_GRP.varchar_type;

Line 649: l_line_quantity_tbl QP_PREQ_GRP.number_type;

645: l_active_date_second_tbl QP_PREQ_GRP.date_type;
646: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
647: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type;
648: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
649: l_line_quantity_tbl QP_PREQ_GRP.number_type;
650: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
651: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
652: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
653: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;

Line 650: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;

646: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
647: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type;
648: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
649: l_line_quantity_tbl QP_PREQ_GRP.number_type;
650: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
651: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
652: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
653: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
654: l_priced_quantity_tbl QP_PREQ_GRP.number_type;

Line 651: l_currency_code_tbl QP_PREQ_GRP.varchar_type;

647: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type;
648: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
649: l_line_quantity_tbl QP_PREQ_GRP.number_type;
650: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
651: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
652: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
653: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
654: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
655: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;

Line 652: l_price_flag_tbl QP_PREQ_GRP.varchar_type;

648: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
649: l_line_quantity_tbl QP_PREQ_GRP.number_type;
650: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
651: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
652: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
653: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
654: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
655: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
656: l_unit_price_tbl QP_PREQ_GRP.number_type;

Line 653: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;

649: l_line_quantity_tbl QP_PREQ_GRP.number_type;
650: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
651: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
652: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
653: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
654: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
655: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
656: l_unit_price_tbl QP_PREQ_GRP.number_type;
657: l_percent_price_tbl QP_PREQ_GRP.number_type;

Line 654: l_priced_quantity_tbl QP_PREQ_GRP.number_type;

650: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
651: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
652: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
653: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
654: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
655: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
656: l_unit_price_tbl QP_PREQ_GRP.number_type;
657: l_percent_price_tbl QP_PREQ_GRP.number_type;
658: l_uom_quantity_tbl QP_PREQ_GRP.number_type;

Line 655: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;

651: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
652: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
653: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
654: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
655: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
656: l_unit_price_tbl QP_PREQ_GRP.number_type;
657: l_percent_price_tbl QP_PREQ_GRP.number_type;
658: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
659: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

Line 656: l_unit_price_tbl QP_PREQ_GRP.number_type;

652: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
653: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
654: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
655: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
656: l_unit_price_tbl QP_PREQ_GRP.number_type;
657: l_percent_price_tbl QP_PREQ_GRP.number_type;
658: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
659: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
660: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

Line 657: l_percent_price_tbl QP_PREQ_GRP.number_type;

653: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
654: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
655: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
656: l_unit_price_tbl QP_PREQ_GRP.number_type;
657: l_percent_price_tbl QP_PREQ_GRP.number_type;
658: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
659: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
660: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
661: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;

Line 658: l_uom_quantity_tbl QP_PREQ_GRP.number_type;

654: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
655: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
656: l_unit_price_tbl QP_PREQ_GRP.number_type;
657: l_percent_price_tbl QP_PREQ_GRP.number_type;
658: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
659: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
660: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
661: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
662: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;

Line 659: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

655: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
656: l_unit_price_tbl QP_PREQ_GRP.number_type;
657: l_percent_price_tbl QP_PREQ_GRP.number_type;
658: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
659: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
660: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
661: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
662: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
663: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;

Line 660: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

656: l_unit_price_tbl QP_PREQ_GRP.number_type;
657: l_percent_price_tbl QP_PREQ_GRP.number_type;
658: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
659: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
660: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
661: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
662: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
663: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
664: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;

Line 661: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;

657: l_percent_price_tbl QP_PREQ_GRP.number_type;
658: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
659: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
660: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
661: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
662: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
663: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
664: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
665: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;

Line 662: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;

658: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
659: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
660: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
661: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
662: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
663: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
664: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
665: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
666: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;

Line 663: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;

659: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
660: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
661: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
662: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
663: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
664: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
665: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
666: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
667: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;

Line 664: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;

660: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
661: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
662: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
663: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
664: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
665: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
666: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
667: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
668: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;

Line 665: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;

661: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
662: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
663: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
664: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
665: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
666: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
667: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
668: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
669: l_price_list_id_tbl QP_PREQ_GRP.number_type;

Line 666: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;

662: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
663: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
664: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
665: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
666: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
667: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
668: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
669: l_price_list_id_tbl QP_PREQ_GRP.number_type;
670: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;

Line 667: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;

663: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
664: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
665: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
666: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
667: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
668: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
669: l_price_list_id_tbl QP_PREQ_GRP.number_type;
670: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
671: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;

Line 668: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;

664: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
665: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
666: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
667: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
668: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
669: l_price_list_id_tbl QP_PREQ_GRP.number_type;
670: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
671: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
672: l_line_category_tbl QP_PREQ_GRP.varchar_type;

Line 669: l_price_list_id_tbl QP_PREQ_GRP.number_type;

665: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
666: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
667: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
668: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
669: l_price_list_id_tbl QP_PREQ_GRP.number_type;
670: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
671: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
672: l_line_category_tbl QP_PREQ_GRP.varchar_type;
673: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;

Line 670: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;

666: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
667: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
668: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
669: l_price_list_id_tbl QP_PREQ_GRP.number_type;
670: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
671: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
672: l_line_category_tbl QP_PREQ_GRP.varchar_type;
673: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
674: l_control_rec QP_PREQ_GRP.control_record_type;

Line 671: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;

667: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
668: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
669: l_price_list_id_tbl QP_PREQ_GRP.number_type;
670: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
671: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
672: l_line_category_tbl QP_PREQ_GRP.varchar_type;
673: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
674: l_control_rec QP_PREQ_GRP.control_record_type;
675:

Line 672: l_line_category_tbl QP_PREQ_GRP.varchar_type;

668: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
669: l_price_list_id_tbl QP_PREQ_GRP.number_type;
670: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
671: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
672: l_line_category_tbl QP_PREQ_GRP.varchar_type;
673: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
674: l_control_rec QP_PREQ_GRP.control_record_type;
675:
676: l_freight_charge_rec_tbl freight_charge_tbl;

Line 673: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;

669: l_price_list_id_tbl QP_PREQ_GRP.number_type;
670: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
671: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
672: l_line_category_tbl QP_PREQ_GRP.varchar_type;
673: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
674: l_control_rec QP_PREQ_GRP.control_record_type;
675:
676: l_freight_charge_rec_tbl freight_charge_tbl;
677: l_freight_charge_tbl freight_charge_tbl;

Line 674: l_control_rec QP_PREQ_GRP.control_record_type;

670: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
671: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
672: l_line_category_tbl QP_PREQ_GRP.varchar_type;
673: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
674: l_control_rec QP_PREQ_GRP.control_record_type;
675:
676: l_freight_charge_rec_tbl freight_charge_tbl;
677: l_freight_charge_tbl freight_charge_tbl;
678: l_qp_cost_table qp_price_result_tbl;

Line 1052: l_usage_pricing_type_tbl(l_line_index) := QP_PREQ_GRP.g_regular_usage_type;

1048: l_line_quantity_tbl(l_line_index) := NULL; -- Ordered Quantity
1049: l_line_uom_code_tbl(l_line_index) := NULL; -- Ordered UOM Code
1050: l_currency_code_tbl(l_line_index) := p_ship_ln_group_rec.currency_code;-- Currency Code
1051: l_price_flag_tbl(l_line_index) := 'Y'; -- Price Flag can have 'Y', 'N'(No pricing),'P'(Phase)
1052: l_usage_pricing_type_tbl(l_line_index) := QP_PREQ_GRP.g_regular_usage_type;
1053: l_priced_quantity_tbl(l_line_index) := NULL;
1054: l_priced_uom_code_tbl(l_line_index) := NULL;
1055: l_unit_price_tbl(l_line_index) := NULL;
1056: l_percent_price_tbl(l_line_index) := NULL;

Line 1062: l_pricing_status_code_tbl(l_line_index) := QP_PREQ_GRP.g_status_unchanged;

1058: l_adjusted_unit_price_tbl(l_line_index) := NULL;
1059: l_upd_adjusted_unit_price_tbl(l_line_index) := NULL;
1060: l_processed_flag_tbl(l_line_index) := NULL;
1061: l_processing_order_tbl(l_line_index) := NULL;
1062: l_pricing_status_code_tbl(l_line_index) := QP_PREQ_GRP.g_status_unchanged;
1063: l_pricing_status_text_tbl(l_line_index) := NULL;
1064: l_rounding_flag_tbl(l_line_index) := NULL;
1065: l_rounding_factor_tbl(l_line_index) := NULL;
1066: l_qualifiers_exist_flag_tbl(l_line_index) := 'N';

Line 1141: l_usage_pricing_type_tbl(l_line_index) := QP_PREQ_GRP.g_regular_usage_type;

1137: l_line_quantity_tbl(l_line_index) := NVL(p_ship_ln_tbl(j).quantity, 1); -- Ordered Quantity
1138: l_line_uom_code_tbl(l_line_index) := p_ship_ln_tbl(j).unit_of_measure; -- Ordered UOM Code
1139: l_currency_code_tbl(l_line_index) := p_ship_ln_tbl(j).currency_code; -- Currency Code
1140: l_price_flag_tbl(l_line_index) := 'Y'; -- Price Flag can have 'Y', 'N'(No pricing), 'P'(Phase)
1141: l_usage_pricing_type_tbl(l_line_index) := QP_PREQ_GRP.g_regular_usage_type;
1142: l_priced_quantity_tbl(l_line_index) := NVL(p_ship_ln_tbl(j).quantity, 1);
1143: l_priced_uom_code_tbl(l_line_index) := p_ship_ln_tbl(j).unit_of_measure;
1144: l_unit_price_tbl(l_line_index) := p_ship_ln_tbl(j).unit_price;
1145: l_percent_price_tbl(l_line_index) := NULL;

Line 1151: l_pricing_status_code_tbl(l_line_index) := QP_PREQ_GRP.g_status_unchanged;

1147: l_adjusted_unit_price_tbl(l_line_index) := NULL;
1148: l_upd_adjusted_unit_price_tbl(l_line_index) := NULL;
1149: l_processed_flag_tbl(l_line_index) := NULL;
1150: l_processing_order_tbl(l_line_index) := NULL;
1151: l_pricing_status_code_tbl(l_line_index) := QP_PREQ_GRP.g_status_unchanged;
1152: l_pricing_status_text_tbl(l_line_index) := NULL;
1153: l_rounding_flag_tbl(l_line_index) := NULL;
1154: l_rounding_factor_tbl(l_line_index) := NULL;
1155: l_qualifiers_exist_flag_tbl(l_line_index) := 'N';

Line 1172: l_debug_info := 'Call QP_PREQ_GRP.INSERT_LINES2 to insert into qp_preq_lines_tmp table';

1168: l_currency_code(p_ship_ln_tbl(j).shipment_line_id) := p_ship_ln_tbl(j).currency_code;
1169: l_line_index := l_line_index + 1;
1170: END LOOP;
1171:
1172: l_debug_info := 'Call QP_PREQ_GRP.INSERT_LINES2 to insert into qp_preq_lines_tmp table';
1173: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1174: p_procedure_name => l_proc_name,
1175: p_debug_info => l_debug_info);
1176:

Line 1178: QP_PREQ_GRP.INSERT_LINES2(

1174: p_procedure_name => l_proc_name,
1175: p_debug_info => l_debug_info);
1176:
1177: -- Insert the request lines into the pricing temporary table qp_preq_lines_tmp
1178: QP_PREQ_GRP.INSERT_LINES2(
1179: p_line_index => l_line_index_tbl,
1180: p_line_type_code => l_line_type_code_tbl,
1181: p_pricing_effective_date => l_pricinl_effective_date_tbl,
1182: p_active_date_first => l_active_date_first_tbl,