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 580: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;

576: l_exception_msg VARCHAR2(2000);
577: l_currency_code DBMS_SQL.varchar2_table;
578: l_line_quantities DBMS_SQL.number_table;
579:
580: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
581: l_line_id_tbl QP_PREQ_GRP.number_type;
582: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
583: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
584: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type;

Line 581: l_line_id_tbl QP_PREQ_GRP.number_type;

577: l_currency_code DBMS_SQL.varchar2_table;
578: l_line_quantities DBMS_SQL.number_table;
579:
580: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
581: l_line_id_tbl QP_PREQ_GRP.number_type;
582: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
583: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
584: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type;
585: l_active_date_first_tbl QP_PREQ_GRP.date_type;

Line 582: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;

578: l_line_quantities DBMS_SQL.number_table;
579:
580: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
581: l_line_id_tbl QP_PREQ_GRP.number_type;
582: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
583: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
584: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type;
585: l_active_date_first_tbl QP_PREQ_GRP.date_type;
586: l_active_date_second_tbl QP_PREQ_GRP.date_type;

Line 583: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;

579:
580: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
581: l_line_id_tbl QP_PREQ_GRP.number_type;
582: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
583: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
584: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type;
585: l_active_date_first_tbl QP_PREQ_GRP.date_type;
586: l_active_date_second_tbl QP_PREQ_GRP.date_type;
587: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;

Line 584: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type;

580: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
581: l_line_id_tbl QP_PREQ_GRP.number_type;
582: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
583: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
584: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type;
585: l_active_date_first_tbl QP_PREQ_GRP.date_type;
586: l_active_date_second_tbl QP_PREQ_GRP.date_type;
587: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
588: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type;

Line 585: l_active_date_first_tbl QP_PREQ_GRP.date_type;

581: l_line_id_tbl QP_PREQ_GRP.number_type;
582: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
583: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
584: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type;
585: l_active_date_first_tbl QP_PREQ_GRP.date_type;
586: l_active_date_second_tbl QP_PREQ_GRP.date_type;
587: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
588: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type;
589: l_line_unit_price_tbl QP_PREQ_GRP.number_type;

Line 586: l_active_date_second_tbl QP_PREQ_GRP.date_type;

582: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
583: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
584: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type;
585: l_active_date_first_tbl QP_PREQ_GRP.date_type;
586: l_active_date_second_tbl QP_PREQ_GRP.date_type;
587: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
588: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type;
589: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
590: l_line_quantity_tbl QP_PREQ_GRP.number_type;

Line 587: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;

583: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
584: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type;
585: l_active_date_first_tbl QP_PREQ_GRP.date_type;
586: l_active_date_second_tbl QP_PREQ_GRP.date_type;
587: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
588: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type;
589: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
590: l_line_quantity_tbl QP_PREQ_GRP.number_type;
591: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;

Line 588: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type;

584: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type;
585: l_active_date_first_tbl QP_PREQ_GRP.date_type;
586: l_active_date_second_tbl QP_PREQ_GRP.date_type;
587: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
588: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type;
589: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
590: l_line_quantity_tbl QP_PREQ_GRP.number_type;
591: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
592: l_currency_code_tbl QP_PREQ_GRP.varchar_type;

Line 589: l_line_unit_price_tbl QP_PREQ_GRP.number_type;

585: l_active_date_first_tbl QP_PREQ_GRP.date_type;
586: l_active_date_second_tbl QP_PREQ_GRP.date_type;
587: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
588: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type;
589: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
590: l_line_quantity_tbl QP_PREQ_GRP.number_type;
591: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
592: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
593: l_price_flag_tbl QP_PREQ_GRP.varchar_type;

Line 590: l_line_quantity_tbl QP_PREQ_GRP.number_type;

586: l_active_date_second_tbl QP_PREQ_GRP.date_type;
587: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
588: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type;
589: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
590: l_line_quantity_tbl QP_PREQ_GRP.number_type;
591: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
592: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
593: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
594: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;

Line 591: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;

587: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
588: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type;
589: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
590: l_line_quantity_tbl QP_PREQ_GRP.number_type;
591: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
592: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
593: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
594: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
595: l_priced_quantity_tbl QP_PREQ_GRP.number_type;

Line 592: l_currency_code_tbl QP_PREQ_GRP.varchar_type;

588: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type;
589: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
590: l_line_quantity_tbl QP_PREQ_GRP.number_type;
591: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
592: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
593: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
594: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
595: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
596: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;

Line 593: l_price_flag_tbl QP_PREQ_GRP.varchar_type;

589: l_line_unit_price_tbl QP_PREQ_GRP.number_type;
590: l_line_quantity_tbl QP_PREQ_GRP.number_type;
591: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
592: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
593: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
594: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
595: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
596: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
597: l_unit_price_tbl QP_PREQ_GRP.number_type;

Line 594: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;

590: l_line_quantity_tbl QP_PREQ_GRP.number_type;
591: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
592: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
593: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
594: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
595: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
596: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
597: l_unit_price_tbl QP_PREQ_GRP.number_type;
598: l_percent_price_tbl QP_PREQ_GRP.number_type;

Line 595: l_priced_quantity_tbl QP_PREQ_GRP.number_type;

591: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
592: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
593: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
594: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
595: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
596: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
597: l_unit_price_tbl QP_PREQ_GRP.number_type;
598: l_percent_price_tbl QP_PREQ_GRP.number_type;
599: l_uom_quantity_tbl QP_PREQ_GRP.number_type;

Line 596: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;

592: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
593: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
594: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
595: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
596: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
597: l_unit_price_tbl QP_PREQ_GRP.number_type;
598: l_percent_price_tbl QP_PREQ_GRP.number_type;
599: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
600: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

Line 597: l_unit_price_tbl QP_PREQ_GRP.number_type;

593: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
594: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
595: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
596: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
597: l_unit_price_tbl QP_PREQ_GRP.number_type;
598: l_percent_price_tbl QP_PREQ_GRP.number_type;
599: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
600: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
601: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

Line 598: l_percent_price_tbl QP_PREQ_GRP.number_type;

594: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
595: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
596: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
597: l_unit_price_tbl QP_PREQ_GRP.number_type;
598: l_percent_price_tbl QP_PREQ_GRP.number_type;
599: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
600: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
601: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
602: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;

Line 599: l_uom_quantity_tbl QP_PREQ_GRP.number_type;

595: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
596: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
597: l_unit_price_tbl QP_PREQ_GRP.number_type;
598: l_percent_price_tbl QP_PREQ_GRP.number_type;
599: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
600: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
601: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
602: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
603: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;

Line 600: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

596: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
597: l_unit_price_tbl QP_PREQ_GRP.number_type;
598: l_percent_price_tbl QP_PREQ_GRP.number_type;
599: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
600: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
601: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
602: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
603: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
604: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;

Line 601: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

597: l_unit_price_tbl QP_PREQ_GRP.number_type;
598: l_percent_price_tbl QP_PREQ_GRP.number_type;
599: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
600: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
601: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
602: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
603: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
604: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
605: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;

Line 602: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;

598: l_percent_price_tbl QP_PREQ_GRP.number_type;
599: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
600: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
601: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
602: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
603: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
604: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
605: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
606: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;

Line 603: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;

599: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
600: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
601: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
602: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
603: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
604: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
605: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
606: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
607: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;

Line 604: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;

600: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
601: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
602: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
603: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
604: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
605: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
606: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
607: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
608: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;

Line 605: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;

601: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
602: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
603: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
604: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
605: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
606: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
607: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
608: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
609: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;

Line 606: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;

602: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
603: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
604: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
605: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
606: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
607: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
608: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
609: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
610: l_price_list_id_tbl QP_PREQ_GRP.number_type;

Line 607: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;

603: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
604: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
605: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
606: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
607: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
608: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
609: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
610: l_price_list_id_tbl QP_PREQ_GRP.number_type;
611: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;

Line 608: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;

604: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
605: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
606: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
607: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
608: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
609: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
610: l_price_list_id_tbl QP_PREQ_GRP.number_type;
611: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
612: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;

Line 609: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;

605: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
606: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
607: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
608: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
609: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
610: l_price_list_id_tbl QP_PREQ_GRP.number_type;
611: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
612: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
613: l_line_category_tbl QP_PREQ_GRP.varchar_type;

Line 610: l_price_list_id_tbl QP_PREQ_GRP.number_type;

606: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
607: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
608: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
609: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
610: l_price_list_id_tbl QP_PREQ_GRP.number_type;
611: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
612: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
613: l_line_category_tbl QP_PREQ_GRP.varchar_type;
614: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;

Line 611: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;

607: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
608: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
609: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
610: l_price_list_id_tbl QP_PREQ_GRP.number_type;
611: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
612: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
613: l_line_category_tbl QP_PREQ_GRP.varchar_type;
614: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
615: l_control_rec QP_PREQ_GRP.control_record_type;

Line 612: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;

608: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
609: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
610: l_price_list_id_tbl QP_PREQ_GRP.number_type;
611: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
612: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
613: l_line_category_tbl QP_PREQ_GRP.varchar_type;
614: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
615: l_control_rec QP_PREQ_GRP.control_record_type;
616:

Line 613: l_line_category_tbl QP_PREQ_GRP.varchar_type;

609: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
610: l_price_list_id_tbl QP_PREQ_GRP.number_type;
611: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
612: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
613: l_line_category_tbl QP_PREQ_GRP.varchar_type;
614: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
615: l_control_rec QP_PREQ_GRP.control_record_type;
616:
617: l_freight_charge_rec_tbl freight_charge_tbl;

Line 614: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;

610: l_price_list_id_tbl QP_PREQ_GRP.number_type;
611: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
612: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
613: l_line_category_tbl QP_PREQ_GRP.varchar_type;
614: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
615: l_control_rec QP_PREQ_GRP.control_record_type;
616:
617: l_freight_charge_rec_tbl freight_charge_tbl;
618: l_freight_charge_tbl freight_charge_tbl;

Line 615: l_control_rec QP_PREQ_GRP.control_record_type;

611: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
612: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
613: l_line_category_tbl QP_PREQ_GRP.varchar_type;
614: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
615: l_control_rec QP_PREQ_GRP.control_record_type;
616:
617: l_freight_charge_rec_tbl freight_charge_tbl;
618: l_freight_charge_tbl freight_charge_tbl;
619: l_qp_cost_table qp_price_result_tbl;

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

696: l_line_quantity_tbl(l_line_index) := NULL; -- Ordered Quantity
697: l_line_uom_code_tbl(l_line_index) := NULL; -- Ordered UOM Code
698: l_currency_code_tbl(l_line_index) := p_ship_ln_group_rec.currency_code;-- Currency Code
699: l_price_flag_tbl(l_line_index) := 'Y'; -- Price Flag can have 'Y', 'N'(No pricing),'P'(Phase)
700: l_usage_pricing_type_tbl(l_line_index) := QP_PREQ_GRP.g_regular_usage_type;
701: l_priced_quantity_tbl(l_line_index) := NULL;
702: l_priced_uom_code_tbl(l_line_index) := NULL;
703: l_unit_price_tbl(l_line_index) := NULL;
704: l_percent_price_tbl(l_line_index) := NULL;

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

706: l_adjusted_unit_price_tbl(l_line_index) := NULL;
707: l_upd_adjusted_unit_price_tbl(l_line_index) := NULL;
708: l_processed_flag_tbl(l_line_index) := NULL;
709: l_processing_order_tbl(l_line_index) := NULL;
710: l_pricing_status_code_tbl(l_line_index) := QP_PREQ_GRP.g_status_unchanged;
711: l_pricing_status_text_tbl(l_line_index) := NULL;
712: l_rounding_flag_tbl(l_line_index) := NULL;
713: l_rounding_factor_tbl(l_line_index) := NULL;
714: l_qualifiers_exist_flag_tbl(l_line_index) := 'N';

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

782: l_line_quantity_tbl(l_line_index) := NVL(p_ship_ln_tbl(j).quantity, 1); -- Ordered Quantity
783: l_line_uom_code_tbl(l_line_index) := p_ship_ln_tbl(j).unit_of_measure; -- Ordered UOM Code
784: l_currency_code_tbl(l_line_index) := p_ship_ln_tbl(j).currency_code; -- Currency Code
785: l_price_flag_tbl(l_line_index) := 'Y'; -- Price Flag can have 'Y', 'N'(No pricing), 'P'(Phase)
786: l_usage_pricing_type_tbl(l_line_index) := QP_PREQ_GRP.g_regular_usage_type;
787: l_priced_quantity_tbl(l_line_index) := NVL(p_ship_ln_tbl(j).quantity, 1);
788: l_priced_uom_code_tbl(l_line_index) := p_ship_ln_tbl(j).unit_of_measure;
789: l_unit_price_tbl(l_line_index) := p_ship_ln_tbl(j).unit_price;
790: l_percent_price_tbl(l_line_index) := NULL;

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

792: l_adjusted_unit_price_tbl(l_line_index) := NULL;
793: l_upd_adjusted_unit_price_tbl(l_line_index) := NULL;
794: l_processed_flag_tbl(l_line_index) := NULL;
795: l_processing_order_tbl(l_line_index) := NULL;
796: l_pricing_status_code_tbl(l_line_index) := QP_PREQ_GRP.g_status_unchanged;
797: l_pricing_status_text_tbl(l_line_index) := NULL;
798: l_rounding_flag_tbl(l_line_index) := NULL;
799: l_rounding_factor_tbl(l_line_index) := NULL;
800: l_qualifiers_exist_flag_tbl(l_line_index) := 'N';

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

811: l_currency_code(p_ship_ln_tbl(j).shipment_line_id) := p_ship_ln_tbl(j).currency_code;
812: l_line_index := l_line_index + 1;
813: END LOOP;
814:
815: l_debug_info := 'Call QP_PREQ_GRP.INSERT_LINES2 to insert into qp_preq_lines_tmp table';
816: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
817: p_procedure_name => l_proc_name,
818: p_debug_info => l_debug_info);
819:

Line 821: QP_PREQ_GRP.INSERT_LINES2(p_line_index => l_line_index_tbl,

817: p_procedure_name => l_proc_name,
818: p_debug_info => l_debug_info);
819:
820: -- Insert the request lines into the pricing temporary table qp_preq_lines_tmp
821: QP_PREQ_GRP.INSERT_LINES2(p_line_index => l_line_index_tbl,
822: p_line_type_code => l_line_type_code_tbl,
823: p_pricing_effective_date => l_pricinl_effective_date_tbl,
824: p_active_date_first => l_active_date_first_tbl,
825: p_active_date_first_type => l_active_date_first_type_tbl,