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

Line 415: l_control_rec QP_PREQ_GRP.control_record_type;

411: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
412:
413: l_line_id NUMBER := nvl(p_order_line_id, 1);
414: l_return_status_text VARCHAR2(2000);
415: l_control_rec QP_PREQ_GRP.control_record_type;
416: l_pass_line VARCHAR2(1);
417:
418: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
419: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;

Line 418: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;

414: l_return_status_text VARCHAR2(2000);
415: l_control_rec QP_PREQ_GRP.control_record_type;
416: l_pass_line VARCHAR2(1);
417:
418: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
419: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
420: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
421: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
422: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;

Line 419: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;

415: l_control_rec QP_PREQ_GRP.control_record_type;
416: l_pass_line VARCHAR2(1);
417:
418: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
419: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
420: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
421: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
422: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
423: l_active_date_second_tbl QP_PREQ_GRP.date_type ;

Line 420: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;

416: l_pass_line VARCHAR2(1);
417:
418: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
419: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
420: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
421: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
422: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
423: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
424: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;

Line 421: l_active_date_first_tbl QP_PREQ_GRP.date_type ;

417:
418: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
419: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
420: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
421: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
422: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
423: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
424: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
425: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;

Line 422: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;

418: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
419: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
420: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
421: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
422: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
423: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
424: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
425: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
426: l_line_quantity_tbl QP_PREQ_GRP.number_type ;

Line 423: l_active_date_second_tbl QP_PREQ_GRP.date_type ;

419: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
420: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
421: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
422: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
423: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
424: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
425: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
426: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
427: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;

Line 424: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;

420: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
421: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
422: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
423: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
424: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
425: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
426: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
427: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
428: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;

Line 425: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;

421: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
422: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
423: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
424: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
425: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
426: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
427: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
428: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
429: l_priced_quantity_tbl QP_PREQ_GRP.number_type;

Line 426: l_line_quantity_tbl QP_PREQ_GRP.number_type ;

422: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
423: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
424: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
425: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
426: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
427: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
428: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
429: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
430: l_uom_quantity_tbl QP_PREQ_GRP.number_type;

Line 427: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;

423: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
424: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
425: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
426: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
427: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
428: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
429: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
430: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
431: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;

Line 428: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;

424: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
425: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
426: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
427: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
428: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
429: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
430: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
431: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
432: l_currency_code_tbl QP_PREQ_GRP.varchar_type;

Line 429: l_priced_quantity_tbl QP_PREQ_GRP.number_type;

425: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
426: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
427: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
428: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
429: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
430: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
431: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
432: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
433: l_unit_price_tbl QP_PREQ_GRP.number_type;

Line 430: l_uom_quantity_tbl QP_PREQ_GRP.number_type;

426: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
427: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
428: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
429: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
430: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
431: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
432: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
433: l_unit_price_tbl QP_PREQ_GRP.number_type;
434: l_percent_price_tbl QP_PREQ_GRP.number_type;

Line 431: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;

427: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
428: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
429: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
430: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
431: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
432: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
433: l_unit_price_tbl QP_PREQ_GRP.number_type;
434: l_percent_price_tbl QP_PREQ_GRP.number_type;
435: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

Line 432: l_currency_code_tbl QP_PREQ_GRP.varchar_type;

428: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
429: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
430: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
431: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
432: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
433: l_unit_price_tbl QP_PREQ_GRP.number_type;
434: l_percent_price_tbl QP_PREQ_GRP.number_type;
435: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
436: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

Line 433: l_unit_price_tbl QP_PREQ_GRP.number_type;

429: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
430: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
431: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
432: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
433: l_unit_price_tbl QP_PREQ_GRP.number_type;
434: l_percent_price_tbl QP_PREQ_GRP.number_type;
435: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
436: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
437: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;

Line 434: l_percent_price_tbl QP_PREQ_GRP.number_type;

430: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
431: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
432: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
433: l_unit_price_tbl QP_PREQ_GRP.number_type;
434: l_percent_price_tbl QP_PREQ_GRP.number_type;
435: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
436: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
437: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
438: l_price_flag_tbl QP_PREQ_GRP.varchar_type;

Line 435: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

431: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
432: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
433: l_unit_price_tbl QP_PREQ_GRP.number_type;
434: l_percent_price_tbl QP_PREQ_GRP.number_type;
435: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
436: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
437: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
438: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
439: l_line_id_tbl QP_PREQ_GRP.number_type;

Line 436: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

432: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
433: l_unit_price_tbl QP_PREQ_GRP.number_type;
434: l_percent_price_tbl QP_PREQ_GRP.number_type;
435: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
436: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
437: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
438: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
439: l_line_id_tbl QP_PREQ_GRP.number_type;
440: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;

Line 437: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;

433: l_unit_price_tbl QP_PREQ_GRP.number_type;
434: l_percent_price_tbl QP_PREQ_GRP.number_type;
435: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
436: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
437: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
438: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
439: l_line_id_tbl QP_PREQ_GRP.number_type;
440: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
441: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;

Line 438: l_price_flag_tbl QP_PREQ_GRP.varchar_type;

434: l_percent_price_tbl QP_PREQ_GRP.number_type;
435: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
436: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
437: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
438: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
439: l_line_id_tbl QP_PREQ_GRP.number_type;
440: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
441: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
442: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;

Line 439: l_line_id_tbl QP_PREQ_GRP.number_type;

435: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
436: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
437: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
438: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
439: l_line_id_tbl QP_PREQ_GRP.number_type;
440: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
441: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
442: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
443: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;

Line 440: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;

436: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
437: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
438: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
439: l_line_id_tbl QP_PREQ_GRP.number_type;
440: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
441: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
442: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
443: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
444: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;

Line 441: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;

437: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
438: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
439: l_line_id_tbl QP_PREQ_GRP.number_type;
440: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
441: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
442: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
443: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
444: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
445: l_price_list_id_tbl QP_PREQ_GRP.number_type;

Line 442: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;

438: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
439: l_line_id_tbl QP_PREQ_GRP.number_type;
440: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
441: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
442: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
443: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
444: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
445: l_price_list_id_tbl QP_PREQ_GRP.number_type;
446: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;

Line 443: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;

439: l_line_id_tbl QP_PREQ_GRP.number_type;
440: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
441: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
442: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
443: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
444: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
445: l_price_list_id_tbl QP_PREQ_GRP.number_type;
446: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
447: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;

Line 444: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;

440: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
441: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
442: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
443: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
444: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
445: l_price_list_id_tbl QP_PREQ_GRP.number_type;
446: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
447: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
448: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;

Line 445: l_price_list_id_tbl QP_PREQ_GRP.number_type;

441: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
442: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
443: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
444: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
445: l_price_list_id_tbl QP_PREQ_GRP.number_type;
446: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
447: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
448: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
449: l_line_category_tbl QP_PREQ_GRP.varchar_type;

Line 446: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;

442: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
443: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
444: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
445: l_price_list_id_tbl QP_PREQ_GRP.number_type;
446: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
447: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
448: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
449: l_line_category_tbl QP_PREQ_GRP.varchar_type;
450: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;

Line 447: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;

443: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
444: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
445: l_price_list_id_tbl QP_PREQ_GRP.number_type;
446: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
447: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
448: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
449: l_line_category_tbl QP_PREQ_GRP.varchar_type;
450: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
451: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;

Line 448: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;

444: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
445: l_price_list_id_tbl QP_PREQ_GRP.number_type;
446: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
447: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
448: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
449: l_line_category_tbl QP_PREQ_GRP.varchar_type;
450: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
451: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
452: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;

Line 449: l_line_category_tbl QP_PREQ_GRP.varchar_type;

445: l_price_list_id_tbl QP_PREQ_GRP.number_type;
446: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
447: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
448: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
449: l_line_category_tbl QP_PREQ_GRP.varchar_type;
450: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
451: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
452: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
453:

Line 450: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;

446: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
447: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
448: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
449: l_line_category_tbl QP_PREQ_GRP.varchar_type;
450: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
451: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
452: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
453:
454: l_price_status_code QP_PREQ_LINES_TMP.pricing_status_code%TYPE;

Line 451: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;

447: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
448: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
449: l_line_category_tbl QP_PREQ_GRP.varchar_type;
450: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
451: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
452: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
453:
454: l_price_status_code QP_PREQ_LINES_TMP.pricing_status_code%TYPE;
455: l_price_status_text QP_PREQ_LINES_TMP.pricing_status_text%TYPE;

Line 452: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;

448: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
449: l_line_category_tbl QP_PREQ_GRP.varchar_type;
450: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
451: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
452: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
453:
454: l_price_status_code QP_PREQ_LINES_TMP.pricing_status_code%TYPE;
455: l_price_status_text QP_PREQ_LINES_TMP.pricing_status_text%TYPE;
456:

Line 623: l_usage_pricing_type_tbl(1) := QP_PREQ_GRP.g_regular_usage_type;

619: l_currency_code_tbl(1) := p_currency_code;-- Currency Code
620: l_price_flag_tbl(1) := 'Y'; -- Price Flag can have 'Y',
621: -- 'N'(No pricing),
622: -- 'P'(Phase)
623: l_usage_pricing_type_tbl(1) := QP_PREQ_GRP.g_regular_usage_type;
624: -- Bug 3564136, don't pass 0, pass 1 instead
625: -- Bug 3315550, should pass 1 instead of NULL
626: l_priced_quantity_tbl(1) := NVL(p_quantity, 1);
627: -- Bug 3564136, don't pass 0, pass 1 instead

Line 639: l_pricing_status_code_tbl(1) := QP_PREQ_GRP.g_status_unchanged;

635: l_adjusted_unit_price_tbl(1) := null;
636: l_upd_adjusted_unit_price_tbl(1) := null;
637: l_processed_flag_tbl(1) := null;
638: l_processing_order_tbl(1) := null;
639: l_pricing_status_code_tbl(1) := QP_PREQ_GRP.g_status_unchanged;
640: l_pricing_status_text_tbl(1) := null;
641: l_rounding_flag_tbl(1) := null;
642: l_rounding_factor_tbl(1) := null;
643: l_qualifiers_exist_flag_tbl(1) := 'N';

Line 656: QP_PREQ_GRP.INSERT_LINES2

652: IF g_debug_stmt THEN
653: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Call INSERT_LINES2');
654: END IF;
655:
656: QP_PREQ_GRP.INSERT_LINES2
657: (p_line_index => l_line_index_tbl,
658: p_line_type_code => l_line_type_code_tbl,
659: p_pricing_effective_date => l_pricinl_effective_date_tbl,
660: p_active_date_first => l_active_date_first_tbl,

Line 714: -- Don't call QP_PREQ_GRP.INSERT_LINE_ATTRS2 since PO has no

710: FND_MSG_PUB.Add;
711: RAISE FND_API.G_EXC_ERROR;
712: END IF;
713:
714: -- Don't call QP_PREQ_GRP.INSERT_LINE_ATTRS2 since PO has no
715: -- ASK_FOR attributes
716:
717: l_progress := '180';
718: IF g_debug_stmt THEN

Line 1026: l_control_rec QP_PREQ_GRP.control_record_type;

1022: l_exception_msg FND_NEW_MESSAGES.message_text%TYPE;
1023: l_qp_license VARCHAR2(30) := NULL;
1024: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
1025: l_return_status_text VARCHAR2(2000);
1026: l_control_rec QP_PREQ_GRP.control_record_type;
1027: l_pass_line VARCHAR2(1);
1028: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
1029: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
1030: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;

Line 1028: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;

1024: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
1025: l_return_status_text VARCHAR2(2000);
1026: l_control_rec QP_PREQ_GRP.control_record_type;
1027: l_pass_line VARCHAR2(1);
1028: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
1029: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
1030: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
1031: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1032: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;

Line 1029: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;

1025: l_return_status_text VARCHAR2(2000);
1026: l_control_rec QP_PREQ_GRP.control_record_type;
1027: l_pass_line VARCHAR2(1);
1028: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
1029: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
1030: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
1031: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1032: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1033: l_active_date_second_tbl QP_PREQ_GRP.date_type ;

Line 1030: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;

1026: l_control_rec QP_PREQ_GRP.control_record_type;
1027: l_pass_line VARCHAR2(1);
1028: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
1029: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
1030: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
1031: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1032: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1033: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1034: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;

Line 1031: l_active_date_first_tbl QP_PREQ_GRP.date_type ;

1027: l_pass_line VARCHAR2(1);
1028: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
1029: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
1030: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
1031: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1032: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1033: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1034: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1035: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;

Line 1032: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;

1028: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
1029: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
1030: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
1031: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1032: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1033: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1034: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1035: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1036: l_line_quantity_tbl QP_PREQ_GRP.number_type ;

Line 1033: l_active_date_second_tbl QP_PREQ_GRP.date_type ;

1029: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
1030: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
1031: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1032: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1033: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1034: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1035: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1036: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1037: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;

Line 1034: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;

1030: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
1031: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1032: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1033: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1034: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1035: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1036: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1037: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1038: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;

Line 1035: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;

1031: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1032: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1033: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1034: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1035: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1036: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1037: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1038: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1039: l_priced_quantity_tbl QP_PREQ_GRP.number_type;

Line 1036: l_line_quantity_tbl QP_PREQ_GRP.number_type ;

1032: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1033: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1034: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1035: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1036: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1037: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1038: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1039: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1040: l_uom_quantity_tbl QP_PREQ_GRP.number_type;

Line 1037: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;

1033: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1034: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1035: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1036: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1037: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1038: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1039: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1040: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1041: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;

Line 1038: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;

1034: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1035: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1036: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1037: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1038: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1039: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1040: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1041: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1042: l_currency_code_tbl QP_PREQ_GRP.varchar_type;

Line 1039: l_priced_quantity_tbl QP_PREQ_GRP.number_type;

1035: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1036: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1037: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1038: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1039: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1040: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1041: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1042: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1043: l_unit_price_tbl QP_PREQ_GRP.number_type;

Line 1040: l_uom_quantity_tbl QP_PREQ_GRP.number_type;

1036: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1037: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1038: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1039: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1040: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1041: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1042: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1043: l_unit_price_tbl QP_PREQ_GRP.number_type;
1044: l_percent_price_tbl QP_PREQ_GRP.number_type;

Line 1041: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;

1037: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1038: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1039: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1040: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1041: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1042: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1043: l_unit_price_tbl QP_PREQ_GRP.number_type;
1044: l_percent_price_tbl QP_PREQ_GRP.number_type;
1045: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

Line 1042: l_currency_code_tbl QP_PREQ_GRP.varchar_type;

1038: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1039: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1040: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1041: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1042: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1043: l_unit_price_tbl QP_PREQ_GRP.number_type;
1044: l_percent_price_tbl QP_PREQ_GRP.number_type;
1045: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1046: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

Line 1043: l_unit_price_tbl QP_PREQ_GRP.number_type;

1039: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1040: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1041: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1042: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1043: l_unit_price_tbl QP_PREQ_GRP.number_type;
1044: l_percent_price_tbl QP_PREQ_GRP.number_type;
1045: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1046: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1047: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;

Line 1044: l_percent_price_tbl QP_PREQ_GRP.number_type;

1040: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1041: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1042: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1043: l_unit_price_tbl QP_PREQ_GRP.number_type;
1044: l_percent_price_tbl QP_PREQ_GRP.number_type;
1045: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1046: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1047: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1048: l_price_flag_tbl QP_PREQ_GRP.varchar_type;

Line 1045: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

1041: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1042: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1043: l_unit_price_tbl QP_PREQ_GRP.number_type;
1044: l_percent_price_tbl QP_PREQ_GRP.number_type;
1045: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1046: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1047: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1048: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1049: l_line_id_tbl QP_PREQ_GRP.number_type;

Line 1046: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

1042: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1043: l_unit_price_tbl QP_PREQ_GRP.number_type;
1044: l_percent_price_tbl QP_PREQ_GRP.number_type;
1045: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1046: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1047: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1048: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1049: l_line_id_tbl QP_PREQ_GRP.number_type;
1050: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;

Line 1047: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;

1043: l_unit_price_tbl QP_PREQ_GRP.number_type;
1044: l_percent_price_tbl QP_PREQ_GRP.number_type;
1045: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1046: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1047: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1048: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1049: l_line_id_tbl QP_PREQ_GRP.number_type;
1050: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1051: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;

Line 1048: l_price_flag_tbl QP_PREQ_GRP.varchar_type;

1044: l_percent_price_tbl QP_PREQ_GRP.number_type;
1045: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1046: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1047: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1048: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1049: l_line_id_tbl QP_PREQ_GRP.number_type;
1050: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1051: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1052: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;

Line 1049: l_line_id_tbl QP_PREQ_GRP.number_type;

1045: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1046: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1047: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1048: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1049: l_line_id_tbl QP_PREQ_GRP.number_type;
1050: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1051: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1052: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1053: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;

Line 1050: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;

1046: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1047: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1048: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1049: l_line_id_tbl QP_PREQ_GRP.number_type;
1050: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1051: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1052: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1053: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1054: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;

Line 1051: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;

1047: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1048: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1049: l_line_id_tbl QP_PREQ_GRP.number_type;
1050: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1051: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1052: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1053: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1054: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1055: l_price_list_id_tbl QP_PREQ_GRP.number_type;

Line 1052: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;

1048: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1049: l_line_id_tbl QP_PREQ_GRP.number_type;
1050: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1051: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1052: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1053: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1054: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1055: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1056: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;

Line 1053: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;

1049: l_line_id_tbl QP_PREQ_GRP.number_type;
1050: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1051: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1052: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1053: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1054: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1055: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1056: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1057: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;

Line 1054: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;

1050: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1051: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1052: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1053: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1054: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1055: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1056: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1057: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1058: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;

Line 1055: l_price_list_id_tbl QP_PREQ_GRP.number_type;

1051: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1052: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1053: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1054: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1055: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1056: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1057: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1058: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1059: l_line_category_tbl QP_PREQ_GRP.varchar_type;

Line 1056: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;

1052: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1053: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1054: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1055: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1056: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1057: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1058: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1059: l_line_category_tbl QP_PREQ_GRP.varchar_type;
1060: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;

Line 1057: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;

1053: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1054: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1055: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1056: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1057: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1058: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1059: l_line_category_tbl QP_PREQ_GRP.varchar_type;
1060: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
1061: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;

Line 1058: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;

1054: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1055: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1056: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1057: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1058: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1059: l_line_category_tbl QP_PREQ_GRP.varchar_type;
1060: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
1061: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
1062: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;

Line 1059: l_line_category_tbl QP_PREQ_GRP.varchar_type;

1055: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1056: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1057: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1058: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1059: l_line_category_tbl QP_PREQ_GRP.varchar_type;
1060: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
1061: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
1062: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
1063: i PLS_INTEGER :=1;

Line 1060: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;

1056: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1057: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1058: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1059: l_line_category_tbl QP_PREQ_GRP.varchar_type;
1060: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
1061: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
1062: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
1063: i PLS_INTEGER :=1;
1064: j PLS_INTEGER :=1;

Line 1061: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;

1057: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1058: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1059: l_line_category_tbl QP_PREQ_GRP.varchar_type;
1060: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
1061: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
1062: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
1063: i PLS_INTEGER :=1;
1064: j PLS_INTEGER :=1;
1065: k PLS_INTEGER :=1;

Line 1062: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;

1058: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1059: l_line_category_tbl QP_PREQ_GRP.varchar_type;
1060: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
1061: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
1062: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
1063: i PLS_INTEGER :=1;
1064: j PLS_INTEGER :=1;
1065: k PLS_INTEGER :=1;
1066: l_freight_charge_rec_tbl Freight_Charges_Rec_Tbl_Type;

Line 1224: l_usage_pricing_type_tbl(i) := QP_PREQ_GRP.g_regular_usage_type;

1220: l_currency_code_tbl(i) := p_header_rec.currency_code;-- Currency Code
1221: l_price_flag_tbl(i) := 'Y'; -- Price Flag can have 'Y',
1222: -- 'N'(No pricing),
1223: -- 'P'(Phase)
1224: l_usage_pricing_type_tbl(i) := QP_PREQ_GRP.g_regular_usage_type;
1225: l_priced_quantity_tbl(i) := NULL;
1226: l_priced_uom_code_tbl(i) := null;
1227: l_unit_price_tbl(i) := null;
1228: l_percent_price_tbl(i) := null;

Line 1234: l_pricing_status_code_tbl(i) := QP_PREQ_GRP.g_status_unchanged;

1230: l_adjusted_unit_price_tbl(i) := null;
1231: l_upd_adjusted_unit_price_tbl(i) := null;
1232: l_processed_flag_tbl(i) := null;
1233: l_processing_order_tbl(i) := null;
1234: l_pricing_status_code_tbl(i) := QP_PREQ_GRP.g_status_unchanged;
1235: l_pricing_status_text_tbl(i) := null;
1236: l_rounding_flag_tbl(i) := null;
1237: l_rounding_factor_tbl(i) := null;
1238: l_qualifiers_exist_flag_tbl(i) := 'N';

Line 1345: l_usage_pricing_type_tbl(i) := QP_PREQ_GRP.g_regular_usage_type;

1341: l_currency_code_tbl(i) := p_line_rec_tbl(j).currency_code;-- Currency Code
1342: l_price_flag_tbl(i) := 'Y'; -- Price Flag can have 'Y',
1343: -- 'N'(No pricing),
1344: -- 'P'(Phase)
1345: l_usage_pricing_type_tbl(i) := QP_PREQ_GRP.g_regular_usage_type;
1346: l_priced_quantity_tbl(i) := NVL(p_line_rec_tbl(j).quantity, 1);
1347: IF (l_priced_quantity_tbl(i) = 0) THEN
1348: l_priced_quantity_tbl(i) := 1;
1349: END IF;

Line 1358: l_pricing_status_code_tbl(i) := QP_PREQ_GRP.g_status_unchanged;

1354: l_adjusted_unit_price_tbl(i) := null;
1355: l_upd_adjusted_unit_price_tbl(i):= null;
1356: l_processed_flag_tbl(i) := null;
1357: l_processing_order_tbl(i) := null;
1358: l_pricing_status_code_tbl(i) := QP_PREQ_GRP.g_status_unchanged;
1359: l_pricing_status_text_tbl(i) := null;
1360: l_rounding_flag_tbl(i) := null;
1361: l_rounding_factor_tbl(i) := null;
1362: l_qualifiers_exist_flag_tbl(i) := 'N';

Line 1379: QP_PREQ_GRP.INSERT_LINES2

1375: IF g_debug_stmt THEN
1376: PO_LOG.stmt(l_log_head,d_pos,'Call INSERT_LINES2');
1377: END IF;
1378:
1379: QP_PREQ_GRP.INSERT_LINES2
1380: (p_line_index => l_line_index_tbl,
1381: p_line_type_code => l_line_type_code_tbl,
1382: p_pricing_effective_date => l_pricinl_effective_date_tbl,
1383: p_active_date_first => l_active_date_first_tbl,

Line 1437: -- Don't call QP_PREQ_GRP.INSERT_LINE_ATTRS2 since PO has no

1433: FND_MSG_PUB.Add;
1434: RAISE FND_API.G_EXC_ERROR;
1435: END IF;
1436:
1437: -- Don't call QP_PREQ_GRP.INSERT_LINE_ATTRS2 since PO has no
1438: -- ASK_FOR attributes
1439:
1440: d_pos:= 200;
1441: IF g_debug_stmt THEN