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 423: l_order_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;

419: l_qp_license_product VARCHAR2(30) := NULL; /*Added for bug 8762015*/
420: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
421:
422: --Enhanced Pricing Start:
423: l_order_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
424: l_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
425: l_pricing_events VARCHAR2(30) := 'PO_BATCH';
426: l_draft_id NUMBER;
427: l_retro_pricing VARCHAR2(1);

Line 424: l_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;

420: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
421:
422: --Enhanced Pricing Start:
423: l_order_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
424: l_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
425: l_pricing_events VARCHAR2(30) := 'PO_BATCH';
426: l_draft_id NUMBER;
427: l_retro_pricing VARCHAR2(1);
428: l_allow_price_override_flag PO_LINES_ALL.allow_price_override_flag%TYPE;

Line 433: l_control_rec QP_PREQ_GRP.control_record_type;

429: --Enhanced Pricing End:
430:
431: l_line_id NUMBER := nvl(p_order_line_id, 1);
432: l_return_status_text VARCHAR2(2000);
433: l_control_rec QP_PREQ_GRP.control_record_type;
434: l_pass_line VARCHAR2(1);
435:
436: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
437: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;

Line 436: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;

432: l_return_status_text VARCHAR2(2000);
433: l_control_rec QP_PREQ_GRP.control_record_type;
434: l_pass_line VARCHAR2(1);
435:
436: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
437: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
438: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
439: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
440: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;

Line 437: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;

433: l_control_rec QP_PREQ_GRP.control_record_type;
434: l_pass_line VARCHAR2(1);
435:
436: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
437: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
438: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
439: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
440: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
441: l_active_date_second_tbl QP_PREQ_GRP.date_type ;

Line 438: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;

434: l_pass_line VARCHAR2(1);
435:
436: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
437: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
438: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
439: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
440: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
441: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
442: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;

Line 439: l_active_date_first_tbl QP_PREQ_GRP.date_type ;

435:
436: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
437: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
438: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
439: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
440: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
441: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
442: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
443: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;

Line 440: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;

436: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
437: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
438: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
439: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
440: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
441: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
442: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
443: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
444: l_line_quantity_tbl QP_PREQ_GRP.number_type ;

Line 441: l_active_date_second_tbl QP_PREQ_GRP.date_type ;

437: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
438: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
439: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
440: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
441: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
442: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
443: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
444: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
445: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;

Line 442: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;

438: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
439: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
440: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
441: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
442: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
443: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
444: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
445: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
446: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;

Line 443: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;

439: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
440: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
441: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
442: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
443: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
444: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
445: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
446: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
447: l_priced_quantity_tbl QP_PREQ_GRP.number_type;

Line 444: l_line_quantity_tbl QP_PREQ_GRP.number_type ;

440: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
441: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
442: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
443: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
444: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
445: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
446: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
447: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
448: l_uom_quantity_tbl QP_PREQ_GRP.number_type;

Line 445: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;

441: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
442: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
443: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
444: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
445: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
446: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
447: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
448: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
449: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;

Line 446: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;

442: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
443: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
444: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
445: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
446: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
447: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
448: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
449: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
450: l_currency_code_tbl QP_PREQ_GRP.varchar_type;

Line 447: l_priced_quantity_tbl QP_PREQ_GRP.number_type;

443: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
444: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
445: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
446: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
447: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
448: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
449: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
450: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
451: l_unit_price_tbl QP_PREQ_GRP.number_type;

Line 448: l_uom_quantity_tbl QP_PREQ_GRP.number_type;

444: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
445: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
446: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
447: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
448: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
449: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
450: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
451: l_unit_price_tbl QP_PREQ_GRP.number_type;
452: l_percent_price_tbl QP_PREQ_GRP.number_type;

Line 449: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;

445: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
446: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
447: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
448: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
449: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
450: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
451: l_unit_price_tbl QP_PREQ_GRP.number_type;
452: l_percent_price_tbl QP_PREQ_GRP.number_type;
453: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

Line 450: l_currency_code_tbl QP_PREQ_GRP.varchar_type;

446: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
447: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
448: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
449: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
450: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
451: l_unit_price_tbl QP_PREQ_GRP.number_type;
452: l_percent_price_tbl QP_PREQ_GRP.number_type;
453: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
454: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

Line 451: l_unit_price_tbl QP_PREQ_GRP.number_type;

447: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
448: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
449: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
450: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
451: l_unit_price_tbl QP_PREQ_GRP.number_type;
452: l_percent_price_tbl QP_PREQ_GRP.number_type;
453: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
454: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
455: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;

Line 452: l_percent_price_tbl QP_PREQ_GRP.number_type;

448: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
449: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
450: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
451: l_unit_price_tbl QP_PREQ_GRP.number_type;
452: l_percent_price_tbl QP_PREQ_GRP.number_type;
453: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
454: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
455: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
456: l_price_flag_tbl QP_PREQ_GRP.varchar_type;

Line 453: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

449: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
450: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
451: l_unit_price_tbl QP_PREQ_GRP.number_type;
452: l_percent_price_tbl QP_PREQ_GRP.number_type;
453: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
454: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
455: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
456: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
457: l_line_id_tbl QP_PREQ_GRP.number_type;

Line 454: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

450: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
451: l_unit_price_tbl QP_PREQ_GRP.number_type;
452: l_percent_price_tbl QP_PREQ_GRP.number_type;
453: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
454: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
455: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
456: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
457: l_line_id_tbl QP_PREQ_GRP.number_type;
458: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;

Line 455: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;

451: l_unit_price_tbl QP_PREQ_GRP.number_type;
452: l_percent_price_tbl QP_PREQ_GRP.number_type;
453: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
454: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
455: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
456: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
457: l_line_id_tbl QP_PREQ_GRP.number_type;
458: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
459: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;

Line 456: l_price_flag_tbl QP_PREQ_GRP.varchar_type;

452: l_percent_price_tbl QP_PREQ_GRP.number_type;
453: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
454: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
455: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
456: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
457: l_line_id_tbl QP_PREQ_GRP.number_type;
458: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
459: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
460: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;

Line 457: l_line_id_tbl QP_PREQ_GRP.number_type;

453: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
454: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
455: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
456: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
457: l_line_id_tbl QP_PREQ_GRP.number_type;
458: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
459: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
460: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
461: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;

Line 458: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;

454: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
455: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
456: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
457: l_line_id_tbl QP_PREQ_GRP.number_type;
458: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
459: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
460: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
461: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
462: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;

Line 459: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;

455: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
456: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
457: l_line_id_tbl QP_PREQ_GRP.number_type;
458: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
459: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
460: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
461: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
462: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
463: l_price_list_id_tbl QP_PREQ_GRP.number_type;

Line 460: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;

456: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
457: l_line_id_tbl QP_PREQ_GRP.number_type;
458: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
459: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
460: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
461: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
462: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
463: l_price_list_id_tbl QP_PREQ_GRP.number_type;
464: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;

Line 461: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;

457: l_line_id_tbl QP_PREQ_GRP.number_type;
458: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
459: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
460: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
461: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
462: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
463: l_price_list_id_tbl QP_PREQ_GRP.number_type;
464: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
465: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;

Line 462: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;

458: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
459: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
460: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
461: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
462: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
463: l_price_list_id_tbl QP_PREQ_GRP.number_type;
464: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
465: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
466: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;

Line 463: l_price_list_id_tbl QP_PREQ_GRP.number_type;

459: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
460: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
461: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
462: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
463: l_price_list_id_tbl QP_PREQ_GRP.number_type;
464: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
465: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
466: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
467: l_line_category_tbl QP_PREQ_GRP.varchar_type;

Line 464: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;

460: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
461: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
462: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
463: l_price_list_id_tbl QP_PREQ_GRP.number_type;
464: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
465: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
466: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
467: l_line_category_tbl QP_PREQ_GRP.varchar_type;
468: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;

Line 465: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;

461: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
462: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
463: l_price_list_id_tbl QP_PREQ_GRP.number_type;
464: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
465: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
466: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
467: l_line_category_tbl QP_PREQ_GRP.varchar_type;
468: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
469: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;

Line 466: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;

462: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
463: l_price_list_id_tbl QP_PREQ_GRP.number_type;
464: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
465: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
466: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
467: l_line_category_tbl QP_PREQ_GRP.varchar_type;
468: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
469: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
470: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;

Line 467: l_line_category_tbl QP_PREQ_GRP.varchar_type;

463: l_price_list_id_tbl QP_PREQ_GRP.number_type;
464: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
465: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
466: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
467: l_line_category_tbl QP_PREQ_GRP.varchar_type;
468: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
469: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
470: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
471:

Line 468: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;

464: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
465: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
466: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
467: l_line_category_tbl QP_PREQ_GRP.varchar_type;
468: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
469: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
470: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
471:
472: l_price_status_code QP_PREQ_LINES_TMP.pricing_status_code%TYPE;

Line 469: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;

465: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
466: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
467: l_line_category_tbl QP_PREQ_GRP.varchar_type;
468: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
469: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
470: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
471:
472: l_price_status_code QP_PREQ_LINES_TMP.pricing_status_code%TYPE;
473: l_price_status_text QP_PREQ_LINES_TMP.pricing_status_text%TYPE;

Line 470: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;

466: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
467: l_line_category_tbl QP_PREQ_GRP.varchar_type;
468: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
469: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
470: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
471:
472: l_price_status_code QP_PREQ_LINES_TMP.pricing_status_code%TYPE;
473: l_price_status_text QP_PREQ_LINES_TMP.pricing_status_text%TYPE;
474:

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

649: l_currency_code_tbl(1) := p_currency_code;-- Currency Code
650: l_price_flag_tbl(1) := 'Y'; -- Price Flag can have 'Y',
651: -- 'N'(No pricing),
652: -- 'P'(Phase)
653: l_usage_pricing_type_tbl(1) := QP_PREQ_GRP.g_regular_usage_type;
654: -- Bug 3564136, don't pass 0, pass 1 instead
655: -- Bug 3315550, should pass 1 instead of NULL
656: l_priced_quantity_tbl(1) := NVL(p_quantity, 1);
657: -- Bug 3564136, don't pass 0, pass 1 instead

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

665: l_adjusted_unit_price_tbl(1) := null;
666: l_upd_adjusted_unit_price_tbl(1) := null;
667: l_processed_flag_tbl(1) := null;
668: l_processing_order_tbl(1) := null;
669: l_pricing_status_code_tbl(1) := QP_PREQ_GRP.g_status_unchanged;
670: l_pricing_status_text_tbl(1) := null;
671: l_rounding_flag_tbl(1) := null;
672: l_rounding_factor_tbl(1) := null;
673: l_qualifiers_exist_flag_tbl(1) := 'N';

Line 686: QP_PREQ_GRP.INSERT_LINES2

682: IF g_debug_stmt THEN
683: PO_DEBUG.debug_stmt(l_log_head, l_progress,'Call INSERT_LINES2');
684: END IF;
685:
686: QP_PREQ_GRP.INSERT_LINES2
687: (p_line_index => l_line_index_tbl,
688: p_line_type_code => l_line_type_code_tbl,
689: p_pricing_effective_date => l_pricinl_effective_date_tbl,
690: p_active_date_first => l_active_date_first_tbl,

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

740: FND_MSG_PUB.Add;
741: RAISE FND_API.G_EXC_ERROR;
742: END IF;
743:
744: -- Don't call QP_PREQ_GRP.INSERT_LINE_ATTRS2 since PO has no
745: -- ASK_FOR attributes
746:
747: --Enhanced Pricing Start: Call to populate manual and overridden modifiers in QP temp tables
748: --Check if the agreement allows price override

Line 1111: l_control_rec QP_PREQ_GRP.control_record_type;

1107: l_exception_msg FND_NEW_MESSAGES.message_text%TYPE;
1108: l_qp_license VARCHAR2(30) := NULL;
1109: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
1110: l_return_status_text VARCHAR2(2000);
1111: l_control_rec QP_PREQ_GRP.control_record_type;
1112: l_pass_line VARCHAR2(1);
1113: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
1114: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
1115: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;

Line 1113: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;

1109: l_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
1110: l_return_status_text VARCHAR2(2000);
1111: l_control_rec QP_PREQ_GRP.control_record_type;
1112: l_pass_line VARCHAR2(1);
1113: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
1114: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
1115: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
1116: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1117: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;

Line 1114: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;

1110: l_return_status_text VARCHAR2(2000);
1111: l_control_rec QP_PREQ_GRP.control_record_type;
1112: l_pass_line VARCHAR2(1);
1113: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
1114: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
1115: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
1116: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1117: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1118: l_active_date_second_tbl QP_PREQ_GRP.date_type ;

Line 1115: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;

1111: l_control_rec QP_PREQ_GRP.control_record_type;
1112: l_pass_line VARCHAR2(1);
1113: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
1114: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
1115: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
1116: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1117: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1118: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1119: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;

Line 1116: l_active_date_first_tbl QP_PREQ_GRP.date_type ;

1112: l_pass_line VARCHAR2(1);
1113: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
1114: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
1115: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
1116: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1117: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1118: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1119: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1120: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;

Line 1117: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;

1113: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
1114: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
1115: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
1116: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1117: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1118: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1119: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1120: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1121: l_line_quantity_tbl QP_PREQ_GRP.number_type ;

Line 1118: l_active_date_second_tbl QP_PREQ_GRP.date_type ;

1114: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
1115: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
1116: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1117: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1118: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1119: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1120: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1121: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1122: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;

Line 1119: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;

1115: l_pricinl_effective_date_tbl QP_PREQ_GRP.date_type ;
1116: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1117: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1118: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1119: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1120: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1121: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1122: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1123: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;

Line 1120: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;

1116: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1117: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1118: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1119: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1120: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1121: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1122: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1123: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1124: l_priced_quantity_tbl QP_PREQ_GRP.number_type;

Line 1121: l_line_quantity_tbl QP_PREQ_GRP.number_type ;

1117: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1118: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1119: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1120: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1121: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1122: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1123: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1124: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1125: l_uom_quantity_tbl QP_PREQ_GRP.number_type;

Line 1122: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;

1118: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1119: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1120: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1121: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1122: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1123: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1124: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1125: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1126: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;

Line 1123: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;

1119: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1120: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1121: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1122: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1123: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1124: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1125: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1126: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1127: l_currency_code_tbl QP_PREQ_GRP.varchar_type;

Line 1124: l_priced_quantity_tbl QP_PREQ_GRP.number_type;

1120: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1121: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1122: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1123: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1124: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1125: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1126: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1127: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1128: l_unit_price_tbl QP_PREQ_GRP.number_type;

Line 1125: l_uom_quantity_tbl QP_PREQ_GRP.number_type;

1121: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1122: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1123: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1124: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1125: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1126: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1127: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1128: l_unit_price_tbl QP_PREQ_GRP.number_type;
1129: l_percent_price_tbl QP_PREQ_GRP.number_type;

Line 1126: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;

1122: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1123: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1124: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1125: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1126: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1127: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1128: l_unit_price_tbl QP_PREQ_GRP.number_type;
1129: l_percent_price_tbl QP_PREQ_GRP.number_type;
1130: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

Line 1127: l_currency_code_tbl QP_PREQ_GRP.varchar_type;

1123: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1124: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1125: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1126: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1127: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1128: l_unit_price_tbl QP_PREQ_GRP.number_type;
1129: l_percent_price_tbl QP_PREQ_GRP.number_type;
1130: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1131: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

Line 1128: l_unit_price_tbl QP_PREQ_GRP.number_type;

1124: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1125: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1126: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1127: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1128: l_unit_price_tbl QP_PREQ_GRP.number_type;
1129: l_percent_price_tbl QP_PREQ_GRP.number_type;
1130: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1131: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1132: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;

Line 1129: l_percent_price_tbl QP_PREQ_GRP.number_type;

1125: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1126: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1127: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1128: l_unit_price_tbl QP_PREQ_GRP.number_type;
1129: l_percent_price_tbl QP_PREQ_GRP.number_type;
1130: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1131: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1132: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1133: l_price_flag_tbl QP_PREQ_GRP.varchar_type;

Line 1130: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

1126: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1127: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1128: l_unit_price_tbl QP_PREQ_GRP.number_type;
1129: l_percent_price_tbl QP_PREQ_GRP.number_type;
1130: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1131: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1132: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1133: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1134: l_line_id_tbl QP_PREQ_GRP.number_type;

Line 1131: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

1127: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1128: l_unit_price_tbl QP_PREQ_GRP.number_type;
1129: l_percent_price_tbl QP_PREQ_GRP.number_type;
1130: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1131: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1132: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1133: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1134: l_line_id_tbl QP_PREQ_GRP.number_type;
1135: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;

Line 1132: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;

1128: l_unit_price_tbl QP_PREQ_GRP.number_type;
1129: l_percent_price_tbl QP_PREQ_GRP.number_type;
1130: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1131: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1132: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1133: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1134: l_line_id_tbl QP_PREQ_GRP.number_type;
1135: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1136: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;

Line 1133: l_price_flag_tbl QP_PREQ_GRP.varchar_type;

1129: l_percent_price_tbl QP_PREQ_GRP.number_type;
1130: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1131: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1132: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1133: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1134: l_line_id_tbl QP_PREQ_GRP.number_type;
1135: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1136: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1137: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;

Line 1134: l_line_id_tbl QP_PREQ_GRP.number_type;

1130: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1131: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1132: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1133: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1134: l_line_id_tbl QP_PREQ_GRP.number_type;
1135: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1136: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1137: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1138: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;

Line 1135: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;

1131: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1132: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1133: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1134: l_line_id_tbl QP_PREQ_GRP.number_type;
1135: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1136: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1137: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1138: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1139: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;

Line 1136: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;

1132: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1133: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1134: l_line_id_tbl QP_PREQ_GRP.number_type;
1135: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1136: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1137: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1138: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1139: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1140: l_price_list_id_tbl QP_PREQ_GRP.number_type;

Line 1137: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;

1133: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1134: l_line_id_tbl QP_PREQ_GRP.number_type;
1135: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1136: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1137: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1138: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1139: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1140: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1141: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;

Line 1138: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;

1134: l_line_id_tbl QP_PREQ_GRP.number_type;
1135: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1136: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1137: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1138: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1139: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1140: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1141: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1142: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;

Line 1139: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;

1135: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1136: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1137: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1138: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1139: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1140: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1141: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1142: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1143: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;

Line 1140: l_price_list_id_tbl QP_PREQ_GRP.number_type;

1136: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1137: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1138: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1139: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1140: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1141: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1142: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1143: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1144: l_line_category_tbl QP_PREQ_GRP.varchar_type;

Line 1141: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;

1137: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1138: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1139: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1140: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1141: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1142: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1143: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1144: l_line_category_tbl QP_PREQ_GRP.varchar_type;
1145: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;

Line 1142: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;

1138: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1139: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1140: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1141: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1142: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1143: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1144: l_line_category_tbl QP_PREQ_GRP.varchar_type;
1145: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
1146: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;

Line 1143: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;

1139: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1140: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1141: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1142: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1143: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1144: l_line_category_tbl QP_PREQ_GRP.varchar_type;
1145: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
1146: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
1147: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;

Line 1144: l_line_category_tbl QP_PREQ_GRP.varchar_type;

1140: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1141: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1142: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1143: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1144: l_line_category_tbl QP_PREQ_GRP.varchar_type;
1145: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
1146: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
1147: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
1148: i PLS_INTEGER := 1;

Line 1145: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;

1141: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1142: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1143: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1144: l_line_category_tbl QP_PREQ_GRP.varchar_type;
1145: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
1146: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
1147: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
1148: i PLS_INTEGER := 1;
1149: j PLS_INTEGER := 1;

Line 1146: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;

1142: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1143: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1144: l_line_category_tbl QP_PREQ_GRP.varchar_type;
1145: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
1146: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
1147: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
1148: i PLS_INTEGER := 1;
1149: j PLS_INTEGER := 1;
1150: k PLS_INTEGER := 1;

Line 1147: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;

1143: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1144: l_line_category_tbl QP_PREQ_GRP.varchar_type;
1145: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
1146: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
1147: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
1148: i PLS_INTEGER := 1;
1149: j PLS_INTEGER := 1;
1150: k PLS_INTEGER := 1;
1151: l_freight_charge_rec_tbl Freight_Charges_Rec_Tbl_Type;

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

1306: l_currency_code_tbl(i) := p_header_rec.currency_code;-- Currency Code
1307: l_price_flag_tbl(i) := 'Y'; -- Price Flag can have 'Y',
1308: -- 'N'(No pricing),
1309: -- 'P'(Phase)
1310: l_usage_pricing_type_tbl(i) := QP_PREQ_GRP.g_regular_usage_type;
1311: l_priced_quantity_tbl(i) := null;
1312: l_priced_uom_code_tbl(i) := null;
1313: l_unit_price_tbl(i) := null;
1314: l_percent_price_tbl(i) := null;

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

1316: l_adjusted_unit_price_tbl(i) := null;
1317: l_upd_adjusted_unit_price_tbl(i) := null;
1318: l_processed_flag_tbl(i) := null;
1319: l_processing_order_tbl(i) := null;
1320: l_pricing_status_code_tbl(i) := QP_PREQ_GRP.g_status_unchanged;
1321: l_pricing_status_text_tbl(i) := null;
1322: l_rounding_flag_tbl(i) := null;
1323: l_rounding_factor_tbl(i) := null;
1324: l_qualifiers_exist_flag_tbl(i) := 'N';

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

1428: l_currency_code_tbl(i) := p_line_rec_tbl(j).currency_code;-- Currency Code
1429: l_price_flag_tbl(i) := 'Y'; -- Price Flag can have 'Y',
1430: -- 'N'(No pricing),
1431: -- 'P'(Phase)
1432: l_usage_pricing_type_tbl(i) := QP_PREQ_GRP.g_regular_usage_type;
1433: l_priced_quantity_tbl(i) := NVL(p_line_rec_tbl(j).quantity, 1);
1434: IF (l_priced_quantity_tbl(i) = 0) THEN
1435: l_priced_quantity_tbl(i) := 1;
1436: END IF;

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

1441: l_adjusted_unit_price_tbl(i) := null;
1442: l_upd_adjusted_unit_price_tbl(i) := null;
1443: l_processed_flag_tbl(i) := null;
1444: l_processing_order_tbl(i) := null;
1445: l_pricing_status_code_tbl(i) := QP_PREQ_GRP.g_status_unchanged;
1446: l_pricing_status_text_tbl(i) := null;
1447: l_rounding_flag_tbl(i) := null;
1448: l_rounding_factor_tbl(i) := null;
1449: l_qualifiers_exist_flag_tbl(i) := 'N';

Line 1466: QP_PREQ_GRP.INSERT_LINES2

1462: IF g_debug_stmt THEN
1463: PO_LOG.stmt(l_log_head, d_pos,'Call INSERT_LINES2');
1464: END IF;
1465:
1466: QP_PREQ_GRP.INSERT_LINES2
1467: (p_line_index => l_line_index_tbl,
1468: p_line_type_code => l_line_type_code_tbl,
1469: p_pricing_effective_date => l_pricinl_effective_date_tbl,
1470: p_active_date_first => l_active_date_first_tbl,

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

1520: FND_MSG_PUB.Add;
1521: RAISE FND_API.G_EXC_ERROR;
1522: END IF;
1523:
1524: -- Don't call QP_PREQ_GRP.INSERT_LINE_ATTRS2 since PO has no
1525: -- ASK_FOR attributes
1526:
1527: d_pos := 200;
1528: IF g_debug_stmt THEN

Line 1843: l_control_rec QP_PREQ_GRP.control_record_type;

1839:
1840:
1841: l_line_id NUMBER := nvl(p_order_line_id, 1);
1842: l_return_status_text VARCHAR2(2000);
1843: l_control_rec QP_PREQ_GRP.control_record_type;
1844: l_pass_line VARCHAR2(1);
1845:
1846: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
1847: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;

Line 1846: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;

1842: l_return_status_text VARCHAR2(2000);
1843: l_control_rec QP_PREQ_GRP.control_record_type;
1844: l_pass_line VARCHAR2(1);
1845:
1846: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
1847: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
1848: l_pricing_effective_date_tbl QP_PREQ_GRP.date_type ;
1849: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1850: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;

Line 1847: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;

1843: l_control_rec QP_PREQ_GRP.control_record_type;
1844: l_pass_line VARCHAR2(1);
1845:
1846: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
1847: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
1848: l_pricing_effective_date_tbl QP_PREQ_GRP.date_type ;
1849: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1850: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1851: l_active_date_second_tbl QP_PREQ_GRP.date_type ;

Line 1848: l_pricing_effective_date_tbl QP_PREQ_GRP.date_type ;

1844: l_pass_line VARCHAR2(1);
1845:
1846: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
1847: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
1848: l_pricing_effective_date_tbl QP_PREQ_GRP.date_type ;
1849: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1850: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1851: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1852: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;

Line 1849: l_active_date_first_tbl QP_PREQ_GRP.date_type ;

1845:
1846: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
1847: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
1848: l_pricing_effective_date_tbl QP_PREQ_GRP.date_type ;
1849: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1850: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1851: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1852: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1853: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;

Line 1850: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;

1846: l_line_index_tbl QP_PREQ_GRP.pls_integer_type;
1847: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
1848: l_pricing_effective_date_tbl QP_PREQ_GRP.date_type ;
1849: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1850: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1851: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1852: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1853: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1854: l_line_quantity_tbl QP_PREQ_GRP.number_type ;

Line 1851: l_active_date_second_tbl QP_PREQ_GRP.date_type ;

1847: l_line_type_code_tbl QP_PREQ_GRP.varchar_type;
1848: l_pricing_effective_date_tbl QP_PREQ_GRP.date_type ;
1849: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1850: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1851: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1852: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1853: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1854: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1855: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;

Line 1852: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;

1848: l_pricing_effective_date_tbl QP_PREQ_GRP.date_type ;
1849: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1850: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1851: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1852: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1853: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1854: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1855: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1856: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;

Line 1853: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;

1849: l_active_date_first_tbl QP_PREQ_GRP.date_type ;
1850: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1851: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1852: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1853: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1854: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1855: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1856: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1857: l_priced_quantity_tbl QP_PREQ_GRP.number_type;

Line 1854: l_line_quantity_tbl QP_PREQ_GRP.number_type ;

1850: l_active_date_first_type_tbl QP_PREQ_GRP.varchar_type;
1851: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1852: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1853: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1854: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1855: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1856: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1857: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1858: l_uom_quantity_tbl QP_PREQ_GRP.number_type;

Line 1855: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;

1851: l_active_date_second_tbl QP_PREQ_GRP.date_type ;
1852: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1853: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1854: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1855: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1856: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1857: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1858: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1859: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;

Line 1856: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;

1852: l_active_date_second_type_tbl QP_PREQ_GRP.varchar_type ;
1853: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1854: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1855: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1856: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1857: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1858: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1859: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1860: l_currency_code_tbl QP_PREQ_GRP.varchar_type;

Line 1857: l_priced_quantity_tbl QP_PREQ_GRP.number_type;

1853: l_line_unit_price_tbl QP_PREQ_GRP.number_type ;
1854: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1855: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1856: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1857: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1858: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1859: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1860: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1861: l_unit_price_tbl QP_PREQ_GRP.number_type;

Line 1858: l_uom_quantity_tbl QP_PREQ_GRP.number_type;

1854: l_line_quantity_tbl QP_PREQ_GRP.number_type ;
1855: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1856: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1857: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1858: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1859: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1860: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1861: l_unit_price_tbl QP_PREQ_GRP.number_type;
1862: l_percent_price_tbl QP_PREQ_GRP.number_type;

Line 1859: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;

1855: l_line_uom_code_tbl QP_PREQ_GRP.varchar_type;
1856: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1857: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1858: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1859: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1860: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1861: l_unit_price_tbl QP_PREQ_GRP.number_type;
1862: l_percent_price_tbl QP_PREQ_GRP.number_type;
1863: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

Line 1860: l_currency_code_tbl QP_PREQ_GRP.varchar_type;

1856: l_request_type_code_tbl QP_PREQ_GRP.varchar_type;
1857: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1858: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1859: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1860: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1861: l_unit_price_tbl QP_PREQ_GRP.number_type;
1862: l_percent_price_tbl QP_PREQ_GRP.number_type;
1863: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1864: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

Line 1861: l_unit_price_tbl QP_PREQ_GRP.number_type;

1857: l_priced_quantity_tbl QP_PREQ_GRP.number_type;
1858: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1859: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1860: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1861: l_unit_price_tbl QP_PREQ_GRP.number_type;
1862: l_percent_price_tbl QP_PREQ_GRP.number_type;
1863: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1864: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1865: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;

Line 1862: l_percent_price_tbl QP_PREQ_GRP.number_type;

1858: l_uom_quantity_tbl QP_PREQ_GRP.number_type;
1859: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1860: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1861: l_unit_price_tbl QP_PREQ_GRP.number_type;
1862: l_percent_price_tbl QP_PREQ_GRP.number_type;
1863: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1864: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1865: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1866: l_price_flag_tbl QP_PREQ_GRP.varchar_type;

Line 1863: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

1859: l_priced_uom_code_tbl QP_PREQ_GRP.varchar_type;
1860: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1861: l_unit_price_tbl QP_PREQ_GRP.number_type;
1862: l_percent_price_tbl QP_PREQ_GRP.number_type;
1863: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1864: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1865: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1866: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1867: l_line_id_tbl QP_PREQ_GRP.number_type;

Line 1864: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;

1860: l_currency_code_tbl QP_PREQ_GRP.varchar_type;
1861: l_unit_price_tbl QP_PREQ_GRP.number_type;
1862: l_percent_price_tbl QP_PREQ_GRP.number_type;
1863: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1864: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1865: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1866: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1867: l_line_id_tbl QP_PREQ_GRP.number_type;
1868: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;

Line 1865: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;

1861: l_unit_price_tbl QP_PREQ_GRP.number_type;
1862: l_percent_price_tbl QP_PREQ_GRP.number_type;
1863: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1864: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1865: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1866: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1867: l_line_id_tbl QP_PREQ_GRP.number_type;
1868: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1869: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;

Line 1866: l_price_flag_tbl QP_PREQ_GRP.varchar_type;

1862: l_percent_price_tbl QP_PREQ_GRP.number_type;
1863: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1864: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1865: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1866: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1867: l_line_id_tbl QP_PREQ_GRP.number_type;
1868: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1869: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1870: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;

Line 1867: l_line_id_tbl QP_PREQ_GRP.number_type;

1863: l_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1864: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1865: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1866: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1867: l_line_id_tbl QP_PREQ_GRP.number_type;
1868: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1869: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1870: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1871: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;

Line 1868: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;

1864: l_upd_adjusted_unit_price_tbl QP_PREQ_GRP.number_type;
1865: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1866: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1867: l_line_id_tbl QP_PREQ_GRP.number_type;
1868: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1869: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1870: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1871: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1872: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;

Line 1869: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;

1865: l_processed_flag_tbl QP_PREQ_GRP.varchar_type;
1866: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1867: l_line_id_tbl QP_PREQ_GRP.number_type;
1868: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1869: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1870: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1871: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1872: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1873: l_price_list_id_tbl QP_PREQ_GRP.number_type;

Line 1870: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;

1866: l_price_flag_tbl QP_PREQ_GRP.varchar_type;
1867: l_line_id_tbl QP_PREQ_GRP.number_type;
1868: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1869: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1870: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1871: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1872: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1873: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1874: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;

Line 1871: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;

1867: l_line_id_tbl QP_PREQ_GRP.number_type;
1868: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1869: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1870: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1871: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1872: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1873: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1874: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1875: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;

Line 1872: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;

1868: l_processing_order_tbl QP_PREQ_GRP.pls_integer_type;
1869: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1870: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1871: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1872: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1873: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1874: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1875: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1876: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;

Line 1873: l_price_list_id_tbl QP_PREQ_GRP.number_type;

1869: l_rounding_factor_tbl QP_PREQ_GRP.pls_integer_type;
1870: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1871: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1872: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1873: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1874: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1875: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1876: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1877: l_line_category_tbl QP_PREQ_GRP.varchar_type;

Line 1874: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;

1870: l_rounding_flag_tbl QP_PREQ_GRP.flag_type;
1871: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1872: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1873: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1874: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1875: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1876: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1877: l_line_category_tbl QP_PREQ_GRP.varchar_type;
1878: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;

Line 1875: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;

1871: l_qualifiers_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1872: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1873: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1874: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1875: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1876: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1877: l_line_category_tbl QP_PREQ_GRP.varchar_type;
1878: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
1879: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;

Line 1876: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;

1872: l_pricing_attrs_exist_flag_tbl QP_PREQ_GRP.varchar_type;
1873: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1874: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1875: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1876: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1877: l_line_category_tbl QP_PREQ_GRP.varchar_type;
1878: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
1879: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
1880: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;

Line 1877: l_line_category_tbl QP_PREQ_GRP.varchar_type;

1873: l_price_list_id_tbl QP_PREQ_GRP.number_type;
1874: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1875: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1876: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1877: l_line_category_tbl QP_PREQ_GRP.varchar_type;
1878: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
1879: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
1880: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
1881:

Line 1878: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;

1874: l_pl_validated_flag_tbl QP_PREQ_GRP.varchar_type;
1875: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1876: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1877: l_line_category_tbl QP_PREQ_GRP.varchar_type;
1878: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
1879: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
1880: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
1881:
1882: l_price_status_code QP_PREQ_LINES_TMP.pricing_status_code%TYPE;

Line 1879: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;

1875: l_price_request_code_tbl QP_PREQ_GRP.varchar_type;
1876: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1877: l_line_category_tbl QP_PREQ_GRP.varchar_type;
1878: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
1879: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
1880: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
1881:
1882: l_price_status_code QP_PREQ_LINES_TMP.pricing_status_code%TYPE;
1883: l_price_status_text QP_PREQ_LINES_TMP.pricing_status_text%TYPE;

Line 1880: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;

1876: l_usage_pricing_type_tbl QP_PREQ_GRP.varchar_type;
1877: l_line_category_tbl QP_PREQ_GRP.varchar_type;
1878: l_pricing_status_code_tbl QP_PREQ_GRP.varchar_type;
1879: l_pricing_status_text_tbl QP_PREQ_GRP.varchar_type;
1880: l_list_price_overide_flag_tbl QP_PREQ_GRP.varchar_type;
1881:
1882: l_price_status_code QP_PREQ_LINES_TMP.pricing_status_code%TYPE;
1883: l_price_status_text QP_PREQ_LINES_TMP.pricing_status_text%TYPE;
1884:

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

2041:
2042: l_line_uom_code_tbl(1) := l_uom_code; -- Ordered UOM Code
2043: l_currency_code_tbl(1) := p_currency_code;-- Currency Code
2044: l_price_flag_tbl(1) := 'Y'; -- Price Flag can have 'Y', 'N'(No pricing), 'P'(Phase)
2045: l_usage_pricing_type_tbl(1) := QP_PREQ_GRP.g_regular_usage_type;
2046:
2047: -- should pass 1 instead of NULL
2048: l_priced_quantity_tbl(1) := NVL(p_quantity, 1);
2049: -- don't pass 0, pass 1 instead

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

2058: l_adjusted_unit_price_tbl(1) := NULL;
2059: l_upd_adjusted_unit_price_tbl(1) := NULL;
2060: l_processed_flag_tbl(1) := NULL;
2061: l_processing_order_tbl(1) := NULL;
2062: l_pricing_status_code_tbl(1) := QP_PREQ_GRP.g_status_unchanged;
2063: l_pricing_status_text_tbl(1) := NULL;
2064: l_rounding_flag_tbl(1) := NULL;
2065: l_rounding_factor_tbl(1) := NULL;
2066: l_qualifiers_exist_flag_tbl(1) := 'N';

Line 2079: QP_PREQ_GRP.INSERT_LINES2

2075: IF g_debug_stmt THEN
2076: PO_DEBUG.debug_stmt(l_log_head, l_progress,'Call INSERT_LINES2');
2077: END IF;
2078:
2079: QP_PREQ_GRP.INSERT_LINES2
2080: (p_line_index => l_line_index_tbl,
2081: p_line_type_code => l_line_type_code_tbl,
2082: p_pricing_effective_date => l_pricing_effective_date_tbl,
2083: p_active_date_first => l_active_date_first_tbl,

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

2133: FND_MSG_PUB.Add;
2134: RAISE FND_API.G_EXC_ERROR;
2135: END IF;
2136:
2137: -- Don't call QP_PREQ_GRP.INSERT_LINE_ATTRS2 since PO has no
2138: -- ASK_FOR attributes
2139:
2140: l_progress := '180';
2141: IF g_debug_stmt THEN

Line 2146: l_control_rec.manual_adjustments_call_flag := qp_preq_grp.G_YES;

2142: PO_DEBUG.debug_stmt(l_log_head, l_progress,
2143: 'Populate Control Record for Pricing Request Call to fetch the manual modifiers');
2144: END IF;
2145:
2146: l_control_rec.manual_adjustments_call_flag := qp_preq_grp.G_YES;
2147: l_control_rec.calculate_flag := 'Y';
2148: l_control_rec.simulation_flag := 'N';
2149: l_control_rec.pricing_event := 'PO_BATCH';
2150: l_control_rec.temp_table_insert_flag := 'N';