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_PRICE_ADJUSTMENTS_PKG dependencies on QP_PREQ_GRP

Line 60: ,p_order_line_id_tbl IN QP_PREQ_GRP.NUMBER_TYPE

56:
57: PROCEDURE delete_line_adjs
58: (p_draft_id IN NUMBER
59: ,p_order_header_id IN NUMBER
60: ,p_order_line_id_tbl IN QP_PREQ_GRP.NUMBER_TYPE
61: ,p_pricing_events IN VARCHAR2
62: --Bug:8598002 renamed p_retro_pricing to p_pricing_call_src, to distinguish calls from retro and auto creation
63: ,p_pricing_call_src IN VARCHAR2
64: --To fix price override not allowed error

Line 408: ,p_order_line_id_tbl IN QP_PREQ_GRP.NUMBER_TYPE := G_EMPTY_NUMBER_TYPE

404: -------------------------------------------------------------------------------
405: PROCEDURE popl_manual_overridden_adj
406: (p_draft_id IN NUMBER
407: ,p_order_header_id IN NUMBER
408: ,p_order_line_id_tbl IN QP_PREQ_GRP.NUMBER_TYPE := G_EMPTY_NUMBER_TYPE
409: ,p_quantity_tbl IN QP_PREQ_GRP.NUMBER_TYPE := G_EMPTY_NUMBER_TYPE
410: ,x_return_status OUT NOCOPY VARCHAR2
411: )
412: IS

Line 409: ,p_quantity_tbl IN QP_PREQ_GRP.NUMBER_TYPE := G_EMPTY_NUMBER_TYPE

405: PROCEDURE popl_manual_overridden_adj
406: (p_draft_id IN NUMBER
407: ,p_order_header_id IN NUMBER
408: ,p_order_line_id_tbl IN QP_PREQ_GRP.NUMBER_TYPE := G_EMPTY_NUMBER_TYPE
409: ,p_quantity_tbl IN QP_PREQ_GRP.NUMBER_TYPE := G_EMPTY_NUMBER_TYPE
410: ,x_return_status OUT NOCOPY VARCHAR2
411: )
412: IS
413: --

Line 426: l_from_list_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;

422: m PLS_INTEGER; --used "m" instead of "l", as "l" looks like number "1"
423:
424: --Line Details got from cursor Start
425: l_line_det_index PLS_INTEGER;
426: l_from_list_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
427: l_from_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
428: l_from_list_line_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
429: l_from_list_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
430: l_list_line_no_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 427: l_from_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;

423:
424: --Line Details got from cursor Start
425: l_line_det_index PLS_INTEGER;
426: l_from_list_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
427: l_from_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
428: l_from_list_line_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
429: l_from_list_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
430: l_list_line_no_tbl QP_PREQ_GRP.VARCHAR_TYPE;
431:

Line 428: l_from_list_line_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;

424: --Line Details got from cursor Start
425: l_line_det_index PLS_INTEGER;
426: l_from_list_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
427: l_from_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
428: l_from_list_line_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
429: l_from_list_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
430: l_list_line_no_tbl QP_PREQ_GRP.VARCHAR_TYPE;
431:
432: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 429: l_from_list_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

425: l_line_det_index PLS_INTEGER;
426: l_from_list_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
427: l_from_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
428: l_from_list_line_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
429: l_from_list_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
430: l_list_line_no_tbl QP_PREQ_GRP.VARCHAR_TYPE;
431:
432: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
433: l_operand_value_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 430: l_list_line_no_tbl QP_PREQ_GRP.VARCHAR_TYPE;

426: l_from_list_header_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
427: l_from_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
428: l_from_list_line_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
429: l_from_list_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
430: l_list_line_no_tbl QP_PREQ_GRP.VARCHAR_TYPE;
431:
432: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
433: l_operand_value_tbl QP_PREQ_GRP.VARCHAR_TYPE;
434:

Line 432: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

428: l_from_list_line_type_tbl QP_PREQ_GRP.VARCHAR_TYPE;
429: l_from_list_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
430: l_list_line_no_tbl QP_PREQ_GRP.VARCHAR_TYPE;
431:
432: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
433: l_operand_value_tbl QP_PREQ_GRP.VARCHAR_TYPE;
434:
435: l_updated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
436: l_applied_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 433: l_operand_value_tbl QP_PREQ_GRP.VARCHAR_TYPE;

429: l_from_list_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
430: l_list_line_no_tbl QP_PREQ_GRP.VARCHAR_TYPE;
431:
432: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
433: l_operand_value_tbl QP_PREQ_GRP.VARCHAR_TYPE;
434:
435: l_updated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
436: l_applied_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
437: l_override_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 435: l_updated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

431:
432: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
433: l_operand_value_tbl QP_PREQ_GRP.VARCHAR_TYPE;
434:
435: l_updated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
436: l_applied_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
437: l_override_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
438: l_automatic_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
439:

Line 436: l_applied_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

432: l_operand_calc_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
433: l_operand_value_tbl QP_PREQ_GRP.VARCHAR_TYPE;
434:
435: l_updated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
436: l_applied_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
437: l_override_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
438: l_automatic_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
439:
440: l_pricing_group_seq_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 437: l_override_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

433: l_operand_value_tbl QP_PREQ_GRP.VARCHAR_TYPE;
434:
435: l_updated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
436: l_applied_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
437: l_override_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
438: l_automatic_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
439:
440: l_pricing_group_seq_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
441: l_price_break_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 438: l_automatic_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;

434:
435: l_updated_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
436: l_applied_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
437: l_override_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
438: l_automatic_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
439:
440: l_pricing_group_seq_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
441: l_price_break_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
442: l_modifier_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 440: l_pricing_group_seq_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

436: l_applied_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
437: l_override_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
438: l_automatic_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
439:
440: l_pricing_group_seq_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
441: l_price_break_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
442: l_modifier_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
443: l_change_reason_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
444: l_change_reason_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 441: l_price_break_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

437: l_override_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
438: l_automatic_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
439:
440: l_pricing_group_seq_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
441: l_price_break_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
442: l_modifier_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
443: l_change_reason_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
444: l_change_reason_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
445:

Line 442: l_modifier_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

438: l_automatic_flag_tbl QP_PREQ_GRP.VARCHAR_TYPE;
439:
440: l_pricing_group_seq_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
441: l_price_break_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
442: l_modifier_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
443: l_change_reason_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
444: l_change_reason_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
445:
446: l_price_adjustment_id_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 443: l_change_reason_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

439:
440: l_pricing_group_seq_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
441: l_price_break_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
442: l_modifier_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
443: l_change_reason_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
444: l_change_reason_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
445:
446: l_price_adjustment_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
447: l_rltd_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 444: l_change_reason_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;

440: l_pricing_group_seq_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
441: l_price_break_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
442: l_modifier_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
443: l_change_reason_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
444: l_change_reason_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
445:
446: l_price_adjustment_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
447: l_rltd_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
448: l_relationship_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 446: l_price_adjustment_id_tbl QP_PREQ_GRP.NUMBER_TYPE;

442: l_modifier_level_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
443: l_change_reason_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
444: l_change_reason_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
445:
446: l_price_adjustment_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
447: l_rltd_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
448: l_relationship_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
449: l_rltd_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
450: --Line Details from cursor End

Line 447: l_rltd_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;

443: l_change_reason_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
444: l_change_reason_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
445:
446: l_price_adjustment_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
447: l_rltd_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
448: l_relationship_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
449: l_rltd_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
450: --Line Details from cursor End
451:

Line 448: l_relationship_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

444: l_change_reason_text_tbl QP_PREQ_GRP.VARCHAR_TYPE;
445:
446: l_price_adjustment_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
447: l_rltd_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
448: l_relationship_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
449: l_rltd_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
450: --Line Details from cursor End
451:
452:

Line 449: l_rltd_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;

445:
446: l_price_adjustment_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
447: l_rltd_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
448: l_relationship_type_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
449: l_rltd_list_line_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
450: --Line Details from cursor End
451:
452:
453: --Line Detail pl/sql tables Start

Line 454: l_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;

450: --Line Details from cursor End
451:
452:
453: --Line Detail pl/sql tables Start
454: l_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
455: l_line_detail_type_code QP_PREQ_GRP.VARCHAR_TYPE;
456: l_price_break_type_code QP_PREQ_GRP.VARCHAR_TYPE;
457: l_list_price QP_PREQ_GRP.NUMBER_TYPE;
458: l_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 455: l_line_detail_type_code QP_PREQ_GRP.VARCHAR_TYPE;

451:
452:
453: --Line Detail pl/sql tables Start
454: l_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
455: l_line_detail_type_code QP_PREQ_GRP.VARCHAR_TYPE;
456: l_price_break_type_code QP_PREQ_GRP.VARCHAR_TYPE;
457: l_list_price QP_PREQ_GRP.NUMBER_TYPE;
458: l_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
459: l_created_from_list_header_id QP_PREQ_GRP.NUMBER_TYPE;

Line 456: l_price_break_type_code QP_PREQ_GRP.VARCHAR_TYPE;

452:
453: --Line Detail pl/sql tables Start
454: l_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
455: l_line_detail_type_code QP_PREQ_GRP.VARCHAR_TYPE;
456: l_price_break_type_code QP_PREQ_GRP.VARCHAR_TYPE;
457: l_list_price QP_PREQ_GRP.NUMBER_TYPE;
458: l_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
459: l_created_from_list_header_id QP_PREQ_GRP.NUMBER_TYPE;
460: l_created_from_list_line_id QP_PREQ_GRP.NUMBER_TYPE;

Line 457: l_list_price QP_PREQ_GRP.NUMBER_TYPE;

453: --Line Detail pl/sql tables Start
454: l_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
455: l_line_detail_type_code QP_PREQ_GRP.VARCHAR_TYPE;
456: l_price_break_type_code QP_PREQ_GRP.VARCHAR_TYPE;
457: l_list_price QP_PREQ_GRP.NUMBER_TYPE;
458: l_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
459: l_created_from_list_header_id QP_PREQ_GRP.NUMBER_TYPE;
460: l_created_from_list_line_id QP_PREQ_GRP.NUMBER_TYPE;
461: l_created_from_list_line_type QP_PREQ_GRP.VARCHAR_TYPE;

Line 458: l_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;

454: l_line_detail_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
455: l_line_detail_type_code QP_PREQ_GRP.VARCHAR_TYPE;
456: l_price_break_type_code QP_PREQ_GRP.VARCHAR_TYPE;
457: l_list_price QP_PREQ_GRP.NUMBER_TYPE;
458: l_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
459: l_created_from_list_header_id QP_PREQ_GRP.NUMBER_TYPE;
460: l_created_from_list_line_id QP_PREQ_GRP.NUMBER_TYPE;
461: l_created_from_list_line_type QP_PREQ_GRP.VARCHAR_TYPE;
462: l_created_from_list_type_code QP_PREQ_GRP.VARCHAR_TYPE;

Line 459: l_created_from_list_header_id QP_PREQ_GRP.NUMBER_TYPE;

455: l_line_detail_type_code QP_PREQ_GRP.VARCHAR_TYPE;
456: l_price_break_type_code QP_PREQ_GRP.VARCHAR_TYPE;
457: l_list_price QP_PREQ_GRP.NUMBER_TYPE;
458: l_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
459: l_created_from_list_header_id QP_PREQ_GRP.NUMBER_TYPE;
460: l_created_from_list_line_id QP_PREQ_GRP.NUMBER_TYPE;
461: l_created_from_list_line_type QP_PREQ_GRP.VARCHAR_TYPE;
462: l_created_from_list_type_code QP_PREQ_GRP.VARCHAR_TYPE;
463: l_created_from_sql QP_PREQ_GRP.VARCHAR_TYPE;

Line 460: l_created_from_list_line_id QP_PREQ_GRP.NUMBER_TYPE;

456: l_price_break_type_code QP_PREQ_GRP.VARCHAR_TYPE;
457: l_list_price QP_PREQ_GRP.NUMBER_TYPE;
458: l_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
459: l_created_from_list_header_id QP_PREQ_GRP.NUMBER_TYPE;
460: l_created_from_list_line_id QP_PREQ_GRP.NUMBER_TYPE;
461: l_created_from_list_line_type QP_PREQ_GRP.VARCHAR_TYPE;
462: l_created_from_list_type_code QP_PREQ_GRP.VARCHAR_TYPE;
463: l_created_from_sql QP_PREQ_GRP.VARCHAR_TYPE;
464: l_pricing_group_sequence QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 461: l_created_from_list_line_type QP_PREQ_GRP.VARCHAR_TYPE;

457: l_list_price QP_PREQ_GRP.NUMBER_TYPE;
458: l_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
459: l_created_from_list_header_id QP_PREQ_GRP.NUMBER_TYPE;
460: l_created_from_list_line_id QP_PREQ_GRP.NUMBER_TYPE;
461: l_created_from_list_line_type QP_PREQ_GRP.VARCHAR_TYPE;
462: l_created_from_list_type_code QP_PREQ_GRP.VARCHAR_TYPE;
463: l_created_from_sql QP_PREQ_GRP.VARCHAR_TYPE;
464: l_pricing_group_sequence QP_PREQ_GRP.PLS_INTEGER_TYPE;
465: l_pricing_phase_id QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 462: l_created_from_list_type_code QP_PREQ_GRP.VARCHAR_TYPE;

458: l_line_index QP_PREQ_GRP.PLS_INTEGER_TYPE;
459: l_created_from_list_header_id QP_PREQ_GRP.NUMBER_TYPE;
460: l_created_from_list_line_id QP_PREQ_GRP.NUMBER_TYPE;
461: l_created_from_list_line_type QP_PREQ_GRP.VARCHAR_TYPE;
462: l_created_from_list_type_code QP_PREQ_GRP.VARCHAR_TYPE;
463: l_created_from_sql QP_PREQ_GRP.VARCHAR_TYPE;
464: l_pricing_group_sequence QP_PREQ_GRP.PLS_INTEGER_TYPE;
465: l_pricing_phase_id QP_PREQ_GRP.PLS_INTEGER_TYPE;
466: l_operand_calculation_code QP_PREQ_GRP.VARCHAR_TYPE;

Line 463: l_created_from_sql QP_PREQ_GRP.VARCHAR_TYPE;

459: l_created_from_list_header_id QP_PREQ_GRP.NUMBER_TYPE;
460: l_created_from_list_line_id QP_PREQ_GRP.NUMBER_TYPE;
461: l_created_from_list_line_type QP_PREQ_GRP.VARCHAR_TYPE;
462: l_created_from_list_type_code QP_PREQ_GRP.VARCHAR_TYPE;
463: l_created_from_sql QP_PREQ_GRP.VARCHAR_TYPE;
464: l_pricing_group_sequence QP_PREQ_GRP.PLS_INTEGER_TYPE;
465: l_pricing_phase_id QP_PREQ_GRP.PLS_INTEGER_TYPE;
466: l_operand_calculation_code QP_PREQ_GRP.VARCHAR_TYPE;
467: l_operand_value QP_PREQ_GRP.VARCHAR_TYPE;

Line 464: l_pricing_group_sequence QP_PREQ_GRP.PLS_INTEGER_TYPE;

460: l_created_from_list_line_id QP_PREQ_GRP.NUMBER_TYPE;
461: l_created_from_list_line_type QP_PREQ_GRP.VARCHAR_TYPE;
462: l_created_from_list_type_code QP_PREQ_GRP.VARCHAR_TYPE;
463: l_created_from_sql QP_PREQ_GRP.VARCHAR_TYPE;
464: l_pricing_group_sequence QP_PREQ_GRP.PLS_INTEGER_TYPE;
465: l_pricing_phase_id QP_PREQ_GRP.PLS_INTEGER_TYPE;
466: l_operand_calculation_code QP_PREQ_GRP.VARCHAR_TYPE;
467: l_operand_value QP_PREQ_GRP.VARCHAR_TYPE;
468: l_substitution_type_code QP_PREQ_GRP.VARCHAR_TYPE;

Line 465: l_pricing_phase_id QP_PREQ_GRP.PLS_INTEGER_TYPE;

461: l_created_from_list_line_type QP_PREQ_GRP.VARCHAR_TYPE;
462: l_created_from_list_type_code QP_PREQ_GRP.VARCHAR_TYPE;
463: l_created_from_sql QP_PREQ_GRP.VARCHAR_TYPE;
464: l_pricing_group_sequence QP_PREQ_GRP.PLS_INTEGER_TYPE;
465: l_pricing_phase_id QP_PREQ_GRP.PLS_INTEGER_TYPE;
466: l_operand_calculation_code QP_PREQ_GRP.VARCHAR_TYPE;
467: l_operand_value QP_PREQ_GRP.VARCHAR_TYPE;
468: l_substitution_type_code QP_PREQ_GRP.VARCHAR_TYPE;
469: l_substitution_value_from QP_PREQ_GRP.VARCHAR_TYPE;

Line 466: l_operand_calculation_code QP_PREQ_GRP.VARCHAR_TYPE;

462: l_created_from_list_type_code QP_PREQ_GRP.VARCHAR_TYPE;
463: l_created_from_sql QP_PREQ_GRP.VARCHAR_TYPE;
464: l_pricing_group_sequence QP_PREQ_GRP.PLS_INTEGER_TYPE;
465: l_pricing_phase_id QP_PREQ_GRP.PLS_INTEGER_TYPE;
466: l_operand_calculation_code QP_PREQ_GRP.VARCHAR_TYPE;
467: l_operand_value QP_PREQ_GRP.VARCHAR_TYPE;
468: l_substitution_type_code QP_PREQ_GRP.VARCHAR_TYPE;
469: l_substitution_value_from QP_PREQ_GRP.VARCHAR_TYPE;
470: l_substitution_value_to QP_PREQ_GRP.VARCHAR_TYPE;

Line 467: l_operand_value QP_PREQ_GRP.VARCHAR_TYPE;

463: l_created_from_sql QP_PREQ_GRP.VARCHAR_TYPE;
464: l_pricing_group_sequence QP_PREQ_GRP.PLS_INTEGER_TYPE;
465: l_pricing_phase_id QP_PREQ_GRP.PLS_INTEGER_TYPE;
466: l_operand_calculation_code QP_PREQ_GRP.VARCHAR_TYPE;
467: l_operand_value QP_PREQ_GRP.VARCHAR_TYPE;
468: l_substitution_type_code QP_PREQ_GRP.VARCHAR_TYPE;
469: l_substitution_value_from QP_PREQ_GRP.VARCHAR_TYPE;
470: l_substitution_value_to QP_PREQ_GRP.VARCHAR_TYPE;
471: l_ask_for_flag QP_PREQ_GRP.VARCHAR_TYPE;

Line 468: l_substitution_type_code QP_PREQ_GRP.VARCHAR_TYPE;

464: l_pricing_group_sequence QP_PREQ_GRP.PLS_INTEGER_TYPE;
465: l_pricing_phase_id QP_PREQ_GRP.PLS_INTEGER_TYPE;
466: l_operand_calculation_code QP_PREQ_GRP.VARCHAR_TYPE;
467: l_operand_value QP_PREQ_GRP.VARCHAR_TYPE;
468: l_substitution_type_code QP_PREQ_GRP.VARCHAR_TYPE;
469: l_substitution_value_from QP_PREQ_GRP.VARCHAR_TYPE;
470: l_substitution_value_to QP_PREQ_GRP.VARCHAR_TYPE;
471: l_ask_for_flag QP_PREQ_GRP.VARCHAR_TYPE;
472: l_price_formula_id QP_PREQ_GRP.NUMBER_TYPE;

Line 469: l_substitution_value_from QP_PREQ_GRP.VARCHAR_TYPE;

465: l_pricing_phase_id QP_PREQ_GRP.PLS_INTEGER_TYPE;
466: l_operand_calculation_code QP_PREQ_GRP.VARCHAR_TYPE;
467: l_operand_value QP_PREQ_GRP.VARCHAR_TYPE;
468: l_substitution_type_code QP_PREQ_GRP.VARCHAR_TYPE;
469: l_substitution_value_from QP_PREQ_GRP.VARCHAR_TYPE;
470: l_substitution_value_to QP_PREQ_GRP.VARCHAR_TYPE;
471: l_ask_for_flag QP_PREQ_GRP.VARCHAR_TYPE;
472: l_price_formula_id QP_PREQ_GRP.NUMBER_TYPE;
473: l_pricing_status_code QP_PREQ_GRP.VARCHAR_TYPE;

Line 470: l_substitution_value_to QP_PREQ_GRP.VARCHAR_TYPE;

466: l_operand_calculation_code QP_PREQ_GRP.VARCHAR_TYPE;
467: l_operand_value QP_PREQ_GRP.VARCHAR_TYPE;
468: l_substitution_type_code QP_PREQ_GRP.VARCHAR_TYPE;
469: l_substitution_value_from QP_PREQ_GRP.VARCHAR_TYPE;
470: l_substitution_value_to QP_PREQ_GRP.VARCHAR_TYPE;
471: l_ask_for_flag QP_PREQ_GRP.VARCHAR_TYPE;
472: l_price_formula_id QP_PREQ_GRP.NUMBER_TYPE;
473: l_pricing_status_code QP_PREQ_GRP.VARCHAR_TYPE;
474: l_pricing_status_text QP_PREQ_GRP.VARCHAR_TYPE;

Line 471: l_ask_for_flag QP_PREQ_GRP.VARCHAR_TYPE;

467: l_operand_value QP_PREQ_GRP.VARCHAR_TYPE;
468: l_substitution_type_code QP_PREQ_GRP.VARCHAR_TYPE;
469: l_substitution_value_from QP_PREQ_GRP.VARCHAR_TYPE;
470: l_substitution_value_to QP_PREQ_GRP.VARCHAR_TYPE;
471: l_ask_for_flag QP_PREQ_GRP.VARCHAR_TYPE;
472: l_price_formula_id QP_PREQ_GRP.NUMBER_TYPE;
473: l_pricing_status_code QP_PREQ_GRP.VARCHAR_TYPE;
474: l_pricing_status_text QP_PREQ_GRP.VARCHAR_TYPE;
475: l_product_precedence QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 472: l_price_formula_id QP_PREQ_GRP.NUMBER_TYPE;

468: l_substitution_type_code QP_PREQ_GRP.VARCHAR_TYPE;
469: l_substitution_value_from QP_PREQ_GRP.VARCHAR_TYPE;
470: l_substitution_value_to QP_PREQ_GRP.VARCHAR_TYPE;
471: l_ask_for_flag QP_PREQ_GRP.VARCHAR_TYPE;
472: l_price_formula_id QP_PREQ_GRP.NUMBER_TYPE;
473: l_pricing_status_code QP_PREQ_GRP.VARCHAR_TYPE;
474: l_pricing_status_text QP_PREQ_GRP.VARCHAR_TYPE;
475: l_product_precedence QP_PREQ_GRP.PLS_INTEGER_TYPE;
476: l_incompatablility_grp_code QP_PREQ_GRP.VARCHAR_TYPE;

Line 473: l_pricing_status_code QP_PREQ_GRP.VARCHAR_TYPE;

469: l_substitution_value_from QP_PREQ_GRP.VARCHAR_TYPE;
470: l_substitution_value_to QP_PREQ_GRP.VARCHAR_TYPE;
471: l_ask_for_flag QP_PREQ_GRP.VARCHAR_TYPE;
472: l_price_formula_id QP_PREQ_GRP.NUMBER_TYPE;
473: l_pricing_status_code QP_PREQ_GRP.VARCHAR_TYPE;
474: l_pricing_status_text QP_PREQ_GRP.VARCHAR_TYPE;
475: l_product_precedence QP_PREQ_GRP.PLS_INTEGER_TYPE;
476: l_incompatablility_grp_code QP_PREQ_GRP.VARCHAR_TYPE;
477: l_processed_flag QP_PREQ_GRP.VARCHAR_TYPE;

Line 474: l_pricing_status_text QP_PREQ_GRP.VARCHAR_TYPE;

470: l_substitution_value_to QP_PREQ_GRP.VARCHAR_TYPE;
471: l_ask_for_flag QP_PREQ_GRP.VARCHAR_TYPE;
472: l_price_formula_id QP_PREQ_GRP.NUMBER_TYPE;
473: l_pricing_status_code QP_PREQ_GRP.VARCHAR_TYPE;
474: l_pricing_status_text QP_PREQ_GRP.VARCHAR_TYPE;
475: l_product_precedence QP_PREQ_GRP.PLS_INTEGER_TYPE;
476: l_incompatablility_grp_code QP_PREQ_GRP.VARCHAR_TYPE;
477: l_processed_flag QP_PREQ_GRP.VARCHAR_TYPE;
478: l_applied_flag QP_PREQ_GRP.VARCHAR_TYPE;

Line 475: l_product_precedence QP_PREQ_GRP.PLS_INTEGER_TYPE;

471: l_ask_for_flag QP_PREQ_GRP.VARCHAR_TYPE;
472: l_price_formula_id QP_PREQ_GRP.NUMBER_TYPE;
473: l_pricing_status_code QP_PREQ_GRP.VARCHAR_TYPE;
474: l_pricing_status_text QP_PREQ_GRP.VARCHAR_TYPE;
475: l_product_precedence QP_PREQ_GRP.PLS_INTEGER_TYPE;
476: l_incompatablility_grp_code QP_PREQ_GRP.VARCHAR_TYPE;
477: l_processed_flag QP_PREQ_GRP.VARCHAR_TYPE;
478: l_applied_flag QP_PREQ_GRP.VARCHAR_TYPE;
479: l_automatic_flag QP_PREQ_GRP.VARCHAR_TYPE;

Line 476: l_incompatablility_grp_code QP_PREQ_GRP.VARCHAR_TYPE;

472: l_price_formula_id QP_PREQ_GRP.NUMBER_TYPE;
473: l_pricing_status_code QP_PREQ_GRP.VARCHAR_TYPE;
474: l_pricing_status_text QP_PREQ_GRP.VARCHAR_TYPE;
475: l_product_precedence QP_PREQ_GRP.PLS_INTEGER_TYPE;
476: l_incompatablility_grp_code QP_PREQ_GRP.VARCHAR_TYPE;
477: l_processed_flag QP_PREQ_GRP.VARCHAR_TYPE;
478: l_applied_flag QP_PREQ_GRP.VARCHAR_TYPE;
479: l_automatic_flag QP_PREQ_GRP.VARCHAR_TYPE;
480: l_override_flag QP_PREQ_GRP.VARCHAR_TYPE;

Line 477: l_processed_flag QP_PREQ_GRP.VARCHAR_TYPE;

473: l_pricing_status_code QP_PREQ_GRP.VARCHAR_TYPE;
474: l_pricing_status_text QP_PREQ_GRP.VARCHAR_TYPE;
475: l_product_precedence QP_PREQ_GRP.PLS_INTEGER_TYPE;
476: l_incompatablility_grp_code QP_PREQ_GRP.VARCHAR_TYPE;
477: l_processed_flag QP_PREQ_GRP.VARCHAR_TYPE;
478: l_applied_flag QP_PREQ_GRP.VARCHAR_TYPE;
479: l_automatic_flag QP_PREQ_GRP.VARCHAR_TYPE;
480: l_override_flag QP_PREQ_GRP.VARCHAR_TYPE;
481: l_primary_uom_flag QP_PREQ_GRP.VARCHAR_TYPE;

Line 478: l_applied_flag QP_PREQ_GRP.VARCHAR_TYPE;

474: l_pricing_status_text QP_PREQ_GRP.VARCHAR_TYPE;
475: l_product_precedence QP_PREQ_GRP.PLS_INTEGER_TYPE;
476: l_incompatablility_grp_code QP_PREQ_GRP.VARCHAR_TYPE;
477: l_processed_flag QP_PREQ_GRP.VARCHAR_TYPE;
478: l_applied_flag QP_PREQ_GRP.VARCHAR_TYPE;
479: l_automatic_flag QP_PREQ_GRP.VARCHAR_TYPE;
480: l_override_flag QP_PREQ_GRP.VARCHAR_TYPE;
481: l_primary_uom_flag QP_PREQ_GRP.VARCHAR_TYPE;
482: l_print_on_invoice_flag QP_PREQ_GRP.VARCHAR_TYPE;

Line 479: l_automatic_flag QP_PREQ_GRP.VARCHAR_TYPE;

475: l_product_precedence QP_PREQ_GRP.PLS_INTEGER_TYPE;
476: l_incompatablility_grp_code QP_PREQ_GRP.VARCHAR_TYPE;
477: l_processed_flag QP_PREQ_GRP.VARCHAR_TYPE;
478: l_applied_flag QP_PREQ_GRP.VARCHAR_TYPE;
479: l_automatic_flag QP_PREQ_GRP.VARCHAR_TYPE;
480: l_override_flag QP_PREQ_GRP.VARCHAR_TYPE;
481: l_primary_uom_flag QP_PREQ_GRP.VARCHAR_TYPE;
482: l_print_on_invoice_flag QP_PREQ_GRP.VARCHAR_TYPE;
483: l_modifier_level_code QP_PREQ_GRP.VARCHAR_TYPE;

Line 480: l_override_flag QP_PREQ_GRP.VARCHAR_TYPE;

476: l_incompatablility_grp_code QP_PREQ_GRP.VARCHAR_TYPE;
477: l_processed_flag QP_PREQ_GRP.VARCHAR_TYPE;
478: l_applied_flag QP_PREQ_GRP.VARCHAR_TYPE;
479: l_automatic_flag QP_PREQ_GRP.VARCHAR_TYPE;
480: l_override_flag QP_PREQ_GRP.VARCHAR_TYPE;
481: l_primary_uom_flag QP_PREQ_GRP.VARCHAR_TYPE;
482: l_print_on_invoice_flag QP_PREQ_GRP.VARCHAR_TYPE;
483: l_modifier_level_code QP_PREQ_GRP.VARCHAR_TYPE;
484: l_benefit_qty QP_PREQ_GRP.NUMBER_TYPE;

Line 481: l_primary_uom_flag QP_PREQ_GRP.VARCHAR_TYPE;

477: l_processed_flag QP_PREQ_GRP.VARCHAR_TYPE;
478: l_applied_flag QP_PREQ_GRP.VARCHAR_TYPE;
479: l_automatic_flag QP_PREQ_GRP.VARCHAR_TYPE;
480: l_override_flag QP_PREQ_GRP.VARCHAR_TYPE;
481: l_primary_uom_flag QP_PREQ_GRP.VARCHAR_TYPE;
482: l_print_on_invoice_flag QP_PREQ_GRP.VARCHAR_TYPE;
483: l_modifier_level_code QP_PREQ_GRP.VARCHAR_TYPE;
484: l_benefit_qty QP_PREQ_GRP.NUMBER_TYPE;
485: l_benefit_uom_code QP_PREQ_GRP.VARCHAR_TYPE;

Line 482: l_print_on_invoice_flag QP_PREQ_GRP.VARCHAR_TYPE;

478: l_applied_flag QP_PREQ_GRP.VARCHAR_TYPE;
479: l_automatic_flag QP_PREQ_GRP.VARCHAR_TYPE;
480: l_override_flag QP_PREQ_GRP.VARCHAR_TYPE;
481: l_primary_uom_flag QP_PREQ_GRP.VARCHAR_TYPE;
482: l_print_on_invoice_flag QP_PREQ_GRP.VARCHAR_TYPE;
483: l_modifier_level_code QP_PREQ_GRP.VARCHAR_TYPE;
484: l_benefit_qty QP_PREQ_GRP.NUMBER_TYPE;
485: l_benefit_uom_code QP_PREQ_GRP.VARCHAR_TYPE;
486: l_list_line_no QP_PREQ_GRP.VARCHAR_TYPE;

Line 483: l_modifier_level_code QP_PREQ_GRP.VARCHAR_TYPE;

479: l_automatic_flag QP_PREQ_GRP.VARCHAR_TYPE;
480: l_override_flag QP_PREQ_GRP.VARCHAR_TYPE;
481: l_primary_uom_flag QP_PREQ_GRP.VARCHAR_TYPE;
482: l_print_on_invoice_flag QP_PREQ_GRP.VARCHAR_TYPE;
483: l_modifier_level_code QP_PREQ_GRP.VARCHAR_TYPE;
484: l_benefit_qty QP_PREQ_GRP.NUMBER_TYPE;
485: l_benefit_uom_code QP_PREQ_GRP.VARCHAR_TYPE;
486: l_list_line_no QP_PREQ_GRP.VARCHAR_TYPE;
487: l_accrual_flag QP_PREQ_GRP.VARCHAR_TYPE;

Line 484: l_benefit_qty QP_PREQ_GRP.NUMBER_TYPE;

480: l_override_flag QP_PREQ_GRP.VARCHAR_TYPE;
481: l_primary_uom_flag QP_PREQ_GRP.VARCHAR_TYPE;
482: l_print_on_invoice_flag QP_PREQ_GRP.VARCHAR_TYPE;
483: l_modifier_level_code QP_PREQ_GRP.VARCHAR_TYPE;
484: l_benefit_qty QP_PREQ_GRP.NUMBER_TYPE;
485: l_benefit_uom_code QP_PREQ_GRP.VARCHAR_TYPE;
486: l_list_line_no QP_PREQ_GRP.VARCHAR_TYPE;
487: l_accrual_flag QP_PREQ_GRP.VARCHAR_TYPE;
488: l_accrual_conversion_rate QP_PREQ_GRP.NUMBER_TYPE;

Line 485: l_benefit_uom_code QP_PREQ_GRP.VARCHAR_TYPE;

481: l_primary_uom_flag QP_PREQ_GRP.VARCHAR_TYPE;
482: l_print_on_invoice_flag QP_PREQ_GRP.VARCHAR_TYPE;
483: l_modifier_level_code QP_PREQ_GRP.VARCHAR_TYPE;
484: l_benefit_qty QP_PREQ_GRP.NUMBER_TYPE;
485: l_benefit_uom_code QP_PREQ_GRP.VARCHAR_TYPE;
486: l_list_line_no QP_PREQ_GRP.VARCHAR_TYPE;
487: l_accrual_flag QP_PREQ_GRP.VARCHAR_TYPE;
488: l_accrual_conversion_rate QP_PREQ_GRP.NUMBER_TYPE;
489: l_estim_accrual_rate QP_PREQ_GRP.NUMBER_TYPE;

Line 486: l_list_line_no QP_PREQ_GRP.VARCHAR_TYPE;

482: l_print_on_invoice_flag QP_PREQ_GRP.VARCHAR_TYPE;
483: l_modifier_level_code QP_PREQ_GRP.VARCHAR_TYPE;
484: l_benefit_qty QP_PREQ_GRP.NUMBER_TYPE;
485: l_benefit_uom_code QP_PREQ_GRP.VARCHAR_TYPE;
486: l_list_line_no QP_PREQ_GRP.VARCHAR_TYPE;
487: l_accrual_flag QP_PREQ_GRP.VARCHAR_TYPE;
488: l_accrual_conversion_rate QP_PREQ_GRP.NUMBER_TYPE;
489: l_estim_accrual_rate QP_PREQ_GRP.NUMBER_TYPE;
490: l_recurring_flag QP_PREQ_GRP.VARCHAR_TYPE;

Line 487: l_accrual_flag QP_PREQ_GRP.VARCHAR_TYPE;

483: l_modifier_level_code QP_PREQ_GRP.VARCHAR_TYPE;
484: l_benefit_qty QP_PREQ_GRP.NUMBER_TYPE;
485: l_benefit_uom_code QP_PREQ_GRP.VARCHAR_TYPE;
486: l_list_line_no QP_PREQ_GRP.VARCHAR_TYPE;
487: l_accrual_flag QP_PREQ_GRP.VARCHAR_TYPE;
488: l_accrual_conversion_rate QP_PREQ_GRP.NUMBER_TYPE;
489: l_estim_accrual_rate QP_PREQ_GRP.NUMBER_TYPE;
490: l_recurring_flag QP_PREQ_GRP.VARCHAR_TYPE;
491: l_selected_volume_attr QP_PREQ_GRP.VARCHAR_TYPE;

Line 488: l_accrual_conversion_rate QP_PREQ_GRP.NUMBER_TYPE;

484: l_benefit_qty QP_PREQ_GRP.NUMBER_TYPE;
485: l_benefit_uom_code QP_PREQ_GRP.VARCHAR_TYPE;
486: l_list_line_no QP_PREQ_GRP.VARCHAR_TYPE;
487: l_accrual_flag QP_PREQ_GRP.VARCHAR_TYPE;
488: l_accrual_conversion_rate QP_PREQ_GRP.NUMBER_TYPE;
489: l_estim_accrual_rate QP_PREQ_GRP.NUMBER_TYPE;
490: l_recurring_flag QP_PREQ_GRP.VARCHAR_TYPE;
491: l_selected_volume_attr QP_PREQ_GRP.VARCHAR_TYPE;
492: l_rounding_factor QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 489: l_estim_accrual_rate QP_PREQ_GRP.NUMBER_TYPE;

485: l_benefit_uom_code QP_PREQ_GRP.VARCHAR_TYPE;
486: l_list_line_no QP_PREQ_GRP.VARCHAR_TYPE;
487: l_accrual_flag QP_PREQ_GRP.VARCHAR_TYPE;
488: l_accrual_conversion_rate QP_PREQ_GRP.NUMBER_TYPE;
489: l_estim_accrual_rate QP_PREQ_GRP.NUMBER_TYPE;
490: l_recurring_flag QP_PREQ_GRP.VARCHAR_TYPE;
491: l_selected_volume_attr QP_PREQ_GRP.VARCHAR_TYPE;
492: l_rounding_factor QP_PREQ_GRP.PLS_INTEGER_TYPE;
493: l_header_limit_exists QP_PREQ_GRP.VARCHAR_TYPE;

Line 490: l_recurring_flag QP_PREQ_GRP.VARCHAR_TYPE;

486: l_list_line_no QP_PREQ_GRP.VARCHAR_TYPE;
487: l_accrual_flag QP_PREQ_GRP.VARCHAR_TYPE;
488: l_accrual_conversion_rate QP_PREQ_GRP.NUMBER_TYPE;
489: l_estim_accrual_rate QP_PREQ_GRP.NUMBER_TYPE;
490: l_recurring_flag QP_PREQ_GRP.VARCHAR_TYPE;
491: l_selected_volume_attr QP_PREQ_GRP.VARCHAR_TYPE;
492: l_rounding_factor QP_PREQ_GRP.PLS_INTEGER_TYPE;
493: l_header_limit_exists QP_PREQ_GRP.VARCHAR_TYPE;
494: l_line_limit_exists QP_PREQ_GRP.VARCHAR_TYPE;

Line 491: l_selected_volume_attr QP_PREQ_GRP.VARCHAR_TYPE;

487: l_accrual_flag QP_PREQ_GRP.VARCHAR_TYPE;
488: l_accrual_conversion_rate QP_PREQ_GRP.NUMBER_TYPE;
489: l_estim_accrual_rate QP_PREQ_GRP.NUMBER_TYPE;
490: l_recurring_flag QP_PREQ_GRP.VARCHAR_TYPE;
491: l_selected_volume_attr QP_PREQ_GRP.VARCHAR_TYPE;
492: l_rounding_factor QP_PREQ_GRP.PLS_INTEGER_TYPE;
493: l_header_limit_exists QP_PREQ_GRP.VARCHAR_TYPE;
494: l_line_limit_exists QP_PREQ_GRP.VARCHAR_TYPE;
495: l_charge_type_code QP_PREQ_GRP.VARCHAR_TYPE;

Line 492: l_rounding_factor QP_PREQ_GRP.PLS_INTEGER_TYPE;

488: l_accrual_conversion_rate QP_PREQ_GRP.NUMBER_TYPE;
489: l_estim_accrual_rate QP_PREQ_GRP.NUMBER_TYPE;
490: l_recurring_flag QP_PREQ_GRP.VARCHAR_TYPE;
491: l_selected_volume_attr QP_PREQ_GRP.VARCHAR_TYPE;
492: l_rounding_factor QP_PREQ_GRP.PLS_INTEGER_TYPE;
493: l_header_limit_exists QP_PREQ_GRP.VARCHAR_TYPE;
494: l_line_limit_exists QP_PREQ_GRP.VARCHAR_TYPE;
495: l_charge_type_code QP_PREQ_GRP.VARCHAR_TYPE;
496: l_charge_subtype_code QP_PREQ_GRP.VARCHAR_TYPE;

Line 493: l_header_limit_exists QP_PREQ_GRP.VARCHAR_TYPE;

489: l_estim_accrual_rate QP_PREQ_GRP.NUMBER_TYPE;
490: l_recurring_flag QP_PREQ_GRP.VARCHAR_TYPE;
491: l_selected_volume_attr QP_PREQ_GRP.VARCHAR_TYPE;
492: l_rounding_factor QP_PREQ_GRP.PLS_INTEGER_TYPE;
493: l_header_limit_exists QP_PREQ_GRP.VARCHAR_TYPE;
494: l_line_limit_exists QP_PREQ_GRP.VARCHAR_TYPE;
495: l_charge_type_code QP_PREQ_GRP.VARCHAR_TYPE;
496: l_charge_subtype_code QP_PREQ_GRP.VARCHAR_TYPE;
497: l_currency_detail_id QP_PREQ_GRP.NUMBER_TYPE;

Line 494: l_line_limit_exists QP_PREQ_GRP.VARCHAR_TYPE;

490: l_recurring_flag QP_PREQ_GRP.VARCHAR_TYPE;
491: l_selected_volume_attr QP_PREQ_GRP.VARCHAR_TYPE;
492: l_rounding_factor QP_PREQ_GRP.PLS_INTEGER_TYPE;
493: l_header_limit_exists QP_PREQ_GRP.VARCHAR_TYPE;
494: l_line_limit_exists QP_PREQ_GRP.VARCHAR_TYPE;
495: l_charge_type_code QP_PREQ_GRP.VARCHAR_TYPE;
496: l_charge_subtype_code QP_PREQ_GRP.VARCHAR_TYPE;
497: l_currency_detail_id QP_PREQ_GRP.NUMBER_TYPE;
498: l_currency_header_id QP_PREQ_GRP.NUMBER_TYPE;

Line 495: l_charge_type_code QP_PREQ_GRP.VARCHAR_TYPE;

491: l_selected_volume_attr QP_PREQ_GRP.VARCHAR_TYPE;
492: l_rounding_factor QP_PREQ_GRP.PLS_INTEGER_TYPE;
493: l_header_limit_exists QP_PREQ_GRP.VARCHAR_TYPE;
494: l_line_limit_exists QP_PREQ_GRP.VARCHAR_TYPE;
495: l_charge_type_code QP_PREQ_GRP.VARCHAR_TYPE;
496: l_charge_subtype_code QP_PREQ_GRP.VARCHAR_TYPE;
497: l_currency_detail_id QP_PREQ_GRP.NUMBER_TYPE;
498: l_currency_header_id QP_PREQ_GRP.NUMBER_TYPE;
499: l_selling_rounding_factor QP_PREQ_GRP.NUMBER_TYPE;

Line 496: l_charge_subtype_code QP_PREQ_GRP.VARCHAR_TYPE;

492: l_rounding_factor QP_PREQ_GRP.PLS_INTEGER_TYPE;
493: l_header_limit_exists QP_PREQ_GRP.VARCHAR_TYPE;
494: l_line_limit_exists QP_PREQ_GRP.VARCHAR_TYPE;
495: l_charge_type_code QP_PREQ_GRP.VARCHAR_TYPE;
496: l_charge_subtype_code QP_PREQ_GRP.VARCHAR_TYPE;
497: l_currency_detail_id QP_PREQ_GRP.NUMBER_TYPE;
498: l_currency_header_id QP_PREQ_GRP.NUMBER_TYPE;
499: l_selling_rounding_factor QP_PREQ_GRP.NUMBER_TYPE;
500: l_order_currency QP_PREQ_GRP.VARCHAR_TYPE;

Line 497: l_currency_detail_id QP_PREQ_GRP.NUMBER_TYPE;

493: l_header_limit_exists QP_PREQ_GRP.VARCHAR_TYPE;
494: l_line_limit_exists QP_PREQ_GRP.VARCHAR_TYPE;
495: l_charge_type_code QP_PREQ_GRP.VARCHAR_TYPE;
496: l_charge_subtype_code QP_PREQ_GRP.VARCHAR_TYPE;
497: l_currency_detail_id QP_PREQ_GRP.NUMBER_TYPE;
498: l_currency_header_id QP_PREQ_GRP.NUMBER_TYPE;
499: l_selling_rounding_factor QP_PREQ_GRP.NUMBER_TYPE;
500: l_order_currency QP_PREQ_GRP.VARCHAR_TYPE;
501: l_pricing_effective_date QP_PREQ_GRP.DATE_TYPE;

Line 498: l_currency_header_id QP_PREQ_GRP.NUMBER_TYPE;

494: l_line_limit_exists QP_PREQ_GRP.VARCHAR_TYPE;
495: l_charge_type_code QP_PREQ_GRP.VARCHAR_TYPE;
496: l_charge_subtype_code QP_PREQ_GRP.VARCHAR_TYPE;
497: l_currency_detail_id QP_PREQ_GRP.NUMBER_TYPE;
498: l_currency_header_id QP_PREQ_GRP.NUMBER_TYPE;
499: l_selling_rounding_factor QP_PREQ_GRP.NUMBER_TYPE;
500: l_order_currency QP_PREQ_GRP.VARCHAR_TYPE;
501: l_pricing_effective_date QP_PREQ_GRP.DATE_TYPE;
502: l_base_currency_code QP_PREQ_GRP.VARCHAR_TYPE;

Line 499: l_selling_rounding_factor QP_PREQ_GRP.NUMBER_TYPE;

495: l_charge_type_code QP_PREQ_GRP.VARCHAR_TYPE;
496: l_charge_subtype_code QP_PREQ_GRP.VARCHAR_TYPE;
497: l_currency_detail_id QP_PREQ_GRP.NUMBER_TYPE;
498: l_currency_header_id QP_PREQ_GRP.NUMBER_TYPE;
499: l_selling_rounding_factor QP_PREQ_GRP.NUMBER_TYPE;
500: l_order_currency QP_PREQ_GRP.VARCHAR_TYPE;
501: l_pricing_effective_date QP_PREQ_GRP.DATE_TYPE;
502: l_base_currency_code QP_PREQ_GRP.VARCHAR_TYPE;
503: l_line_quantity QP_PREQ_GRP.NUMBER_TYPE;

Line 500: l_order_currency QP_PREQ_GRP.VARCHAR_TYPE;

496: l_charge_subtype_code QP_PREQ_GRP.VARCHAR_TYPE;
497: l_currency_detail_id QP_PREQ_GRP.NUMBER_TYPE;
498: l_currency_header_id QP_PREQ_GRP.NUMBER_TYPE;
499: l_selling_rounding_factor QP_PREQ_GRP.NUMBER_TYPE;
500: l_order_currency QP_PREQ_GRP.VARCHAR_TYPE;
501: l_pricing_effective_date QP_PREQ_GRP.DATE_TYPE;
502: l_base_currency_code QP_PREQ_GRP.VARCHAR_TYPE;
503: l_line_quantity QP_PREQ_GRP.NUMBER_TYPE;
504: l_updated_flag QP_PREQ_GRP.VARCHAR_TYPE;

Line 501: l_pricing_effective_date QP_PREQ_GRP.DATE_TYPE;

497: l_currency_detail_id QP_PREQ_GRP.NUMBER_TYPE;
498: l_currency_header_id QP_PREQ_GRP.NUMBER_TYPE;
499: l_selling_rounding_factor QP_PREQ_GRP.NUMBER_TYPE;
500: l_order_currency QP_PREQ_GRP.VARCHAR_TYPE;
501: l_pricing_effective_date QP_PREQ_GRP.DATE_TYPE;
502: l_base_currency_code QP_PREQ_GRP.VARCHAR_TYPE;
503: l_line_quantity QP_PREQ_GRP.NUMBER_TYPE;
504: l_updated_flag QP_PREQ_GRP.VARCHAR_TYPE;
505: l_calculation_code QP_PREQ_GRP.VARCHAR_TYPE;

Line 502: l_base_currency_code QP_PREQ_GRP.VARCHAR_TYPE;

498: l_currency_header_id QP_PREQ_GRP.NUMBER_TYPE;
499: l_selling_rounding_factor QP_PREQ_GRP.NUMBER_TYPE;
500: l_order_currency QP_PREQ_GRP.VARCHAR_TYPE;
501: l_pricing_effective_date QP_PREQ_GRP.DATE_TYPE;
502: l_base_currency_code QP_PREQ_GRP.VARCHAR_TYPE;
503: l_line_quantity QP_PREQ_GRP.NUMBER_TYPE;
504: l_updated_flag QP_PREQ_GRP.VARCHAR_TYPE;
505: l_calculation_code QP_PREQ_GRP.VARCHAR_TYPE;
506: l_change_reason_code QP_PREQ_GRP.VARCHAR_TYPE;

Line 503: l_line_quantity QP_PREQ_GRP.NUMBER_TYPE;

499: l_selling_rounding_factor QP_PREQ_GRP.NUMBER_TYPE;
500: l_order_currency QP_PREQ_GRP.VARCHAR_TYPE;
501: l_pricing_effective_date QP_PREQ_GRP.DATE_TYPE;
502: l_base_currency_code QP_PREQ_GRP.VARCHAR_TYPE;
503: l_line_quantity QP_PREQ_GRP.NUMBER_TYPE;
504: l_updated_flag QP_PREQ_GRP.VARCHAR_TYPE;
505: l_calculation_code QP_PREQ_GRP.VARCHAR_TYPE;
506: l_change_reason_code QP_PREQ_GRP.VARCHAR_TYPE;
507: l_change_reason_text QP_PREQ_GRP.VARCHAR_TYPE;

Line 504: l_updated_flag QP_PREQ_GRP.VARCHAR_TYPE;

500: l_order_currency QP_PREQ_GRP.VARCHAR_TYPE;
501: l_pricing_effective_date QP_PREQ_GRP.DATE_TYPE;
502: l_base_currency_code QP_PREQ_GRP.VARCHAR_TYPE;
503: l_line_quantity QP_PREQ_GRP.NUMBER_TYPE;
504: l_updated_flag QP_PREQ_GRP.VARCHAR_TYPE;
505: l_calculation_code QP_PREQ_GRP.VARCHAR_TYPE;
506: l_change_reason_code QP_PREQ_GRP.VARCHAR_TYPE;
507: l_change_reason_text QP_PREQ_GRP.VARCHAR_TYPE;
508:

Line 505: l_calculation_code QP_PREQ_GRP.VARCHAR_TYPE;

501: l_pricing_effective_date QP_PREQ_GRP.DATE_TYPE;
502: l_base_currency_code QP_PREQ_GRP.VARCHAR_TYPE;
503: l_line_quantity QP_PREQ_GRP.NUMBER_TYPE;
504: l_updated_flag QP_PREQ_GRP.VARCHAR_TYPE;
505: l_calculation_code QP_PREQ_GRP.VARCHAR_TYPE;
506: l_change_reason_code QP_PREQ_GRP.VARCHAR_TYPE;
507: l_change_reason_text QP_PREQ_GRP.VARCHAR_TYPE;
508:
509: l_price_adjustment_id QP_PREQ_GRP.NUMBER_TYPE;

Line 506: l_change_reason_code QP_PREQ_GRP.VARCHAR_TYPE;

502: l_base_currency_code QP_PREQ_GRP.VARCHAR_TYPE;
503: l_line_quantity QP_PREQ_GRP.NUMBER_TYPE;
504: l_updated_flag QP_PREQ_GRP.VARCHAR_TYPE;
505: l_calculation_code QP_PREQ_GRP.VARCHAR_TYPE;
506: l_change_reason_code QP_PREQ_GRP.VARCHAR_TYPE;
507: l_change_reason_text QP_PREQ_GRP.VARCHAR_TYPE;
508:
509: l_price_adjustment_id QP_PREQ_GRP.NUMBER_TYPE;
510:

Line 507: l_change_reason_text QP_PREQ_GRP.VARCHAR_TYPE;

503: l_line_quantity QP_PREQ_GRP.NUMBER_TYPE;
504: l_updated_flag QP_PREQ_GRP.VARCHAR_TYPE;
505: l_calculation_code QP_PREQ_GRP.VARCHAR_TYPE;
506: l_change_reason_code QP_PREQ_GRP.VARCHAR_TYPE;
507: l_change_reason_text QP_PREQ_GRP.VARCHAR_TYPE;
508:
509: l_price_adjustment_id QP_PREQ_GRP.NUMBER_TYPE;
510:
511: l_accum_context QP_PREQ_GRP.VARCHAR_TYPE;

Line 509: l_price_adjustment_id QP_PREQ_GRP.NUMBER_TYPE;

505: l_calculation_code QP_PREQ_GRP.VARCHAR_TYPE;
506: l_change_reason_code QP_PREQ_GRP.VARCHAR_TYPE;
507: l_change_reason_text QP_PREQ_GRP.VARCHAR_TYPE;
508:
509: l_price_adjustment_id QP_PREQ_GRP.NUMBER_TYPE;
510:
511: l_accum_context QP_PREQ_GRP.VARCHAR_TYPE;
512: l_accum_attribute QP_PREQ_GRP.VARCHAR_TYPE;
513: l_accum_flag QP_PREQ_GRP.VARCHAR_TYPE;

Line 511: l_accum_context QP_PREQ_GRP.VARCHAR_TYPE;

507: l_change_reason_text QP_PREQ_GRP.VARCHAR_TYPE;
508:
509: l_price_adjustment_id QP_PREQ_GRP.NUMBER_TYPE;
510:
511: l_accum_context QP_PREQ_GRP.VARCHAR_TYPE;
512: l_accum_attribute QP_PREQ_GRP.VARCHAR_TYPE;
513: l_accum_flag QP_PREQ_GRP.VARCHAR_TYPE;
514: l_break_uom_code QP_PREQ_GRP.VARCHAR_TYPE;
515: l_break_uom_context QP_PREQ_GRP.VARCHAR_TYPE;

Line 512: l_accum_attribute QP_PREQ_GRP.VARCHAR_TYPE;

508:
509: l_price_adjustment_id QP_PREQ_GRP.NUMBER_TYPE;
510:
511: l_accum_context QP_PREQ_GRP.VARCHAR_TYPE;
512: l_accum_attribute QP_PREQ_GRP.VARCHAR_TYPE;
513: l_accum_flag QP_PREQ_GRP.VARCHAR_TYPE;
514: l_break_uom_code QP_PREQ_GRP.VARCHAR_TYPE;
515: l_break_uom_context QP_PREQ_GRP.VARCHAR_TYPE;
516: l_break_uom_attribute QP_PREQ_GRP.VARCHAR_TYPE;

Line 513: l_accum_flag QP_PREQ_GRP.VARCHAR_TYPE;

509: l_price_adjustment_id QP_PREQ_GRP.NUMBER_TYPE;
510:
511: l_accum_context QP_PREQ_GRP.VARCHAR_TYPE;
512: l_accum_attribute QP_PREQ_GRP.VARCHAR_TYPE;
513: l_accum_flag QP_PREQ_GRP.VARCHAR_TYPE;
514: l_break_uom_code QP_PREQ_GRP.VARCHAR_TYPE;
515: l_break_uom_context QP_PREQ_GRP.VARCHAR_TYPE;
516: l_break_uom_attribute QP_PREQ_GRP.VARCHAR_TYPE;
517: l_process_code QP_PREQ_GRP.VARCHAR_TYPE;

Line 514: l_break_uom_code QP_PREQ_GRP.VARCHAR_TYPE;

510:
511: l_accum_context QP_PREQ_GRP.VARCHAR_TYPE;
512: l_accum_attribute QP_PREQ_GRP.VARCHAR_TYPE;
513: l_accum_flag QP_PREQ_GRP.VARCHAR_TYPE;
514: l_break_uom_code QP_PREQ_GRP.VARCHAR_TYPE;
515: l_break_uom_context QP_PREQ_GRP.VARCHAR_TYPE;
516: l_break_uom_attribute QP_PREQ_GRP.VARCHAR_TYPE;
517: l_process_code QP_PREQ_GRP.VARCHAR_TYPE;
518: --Line Detail pl/sql tables End

Line 515: l_break_uom_context QP_PREQ_GRP.VARCHAR_TYPE;

511: l_accum_context QP_PREQ_GRP.VARCHAR_TYPE;
512: l_accum_attribute QP_PREQ_GRP.VARCHAR_TYPE;
513: l_accum_flag QP_PREQ_GRP.VARCHAR_TYPE;
514: l_break_uom_code QP_PREQ_GRP.VARCHAR_TYPE;
515: l_break_uom_context QP_PREQ_GRP.VARCHAR_TYPE;
516: l_break_uom_attribute QP_PREQ_GRP.VARCHAR_TYPE;
517: l_process_code QP_PREQ_GRP.VARCHAR_TYPE;
518: --Line Detail pl/sql tables End
519:

Line 516: l_break_uom_attribute QP_PREQ_GRP.VARCHAR_TYPE;

512: l_accum_attribute QP_PREQ_GRP.VARCHAR_TYPE;
513: l_accum_flag QP_PREQ_GRP.VARCHAR_TYPE;
514: l_break_uom_code QP_PREQ_GRP.VARCHAR_TYPE;
515: l_break_uom_context QP_PREQ_GRP.VARCHAR_TYPE;
516: l_break_uom_attribute QP_PREQ_GRP.VARCHAR_TYPE;
517: l_process_code QP_PREQ_GRP.VARCHAR_TYPE;
518: --Line Detail pl/sql tables End
519:
520: l_line_detail_index_mapping QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 517: l_process_code QP_PREQ_GRP.VARCHAR_TYPE;

513: l_accum_flag QP_PREQ_GRP.VARCHAR_TYPE;
514: l_break_uom_code QP_PREQ_GRP.VARCHAR_TYPE;
515: l_break_uom_context QP_PREQ_GRP.VARCHAR_TYPE;
516: l_break_uom_attribute QP_PREQ_GRP.VARCHAR_TYPE;
517: l_process_code QP_PREQ_GRP.VARCHAR_TYPE;
518: --Line Detail pl/sql tables End
519:
520: l_line_detail_index_mapping QP_PREQ_GRP.PLS_INTEGER_TYPE;
521:

Line 520: l_line_detail_index_mapping QP_PREQ_GRP.PLS_INTEGER_TYPE;

516: l_break_uom_attribute QP_PREQ_GRP.VARCHAR_TYPE;
517: l_process_code QP_PREQ_GRP.VARCHAR_TYPE;
518: --Line Detail pl/sql tables End
519:
520: l_line_detail_index_mapping QP_PREQ_GRP.PLS_INTEGER_TYPE;
521:
522: --Related Line Detail pl/sql tables start
523: l_line_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
524: l_line_detail_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 523: l_line_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

519:
520: l_line_detail_index_mapping QP_PREQ_GRP.PLS_INTEGER_TYPE;
521:
522: --Related Line Detail pl/sql tables start
523: l_line_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
524: l_line_detail_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
525: l_relationship_type_code_rtbl QP_PREQ_GRP.VARCHAR_TYPE;
526:
527: l_rltd_line_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 524: l_line_detail_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

520: l_line_detail_index_mapping QP_PREQ_GRP.PLS_INTEGER_TYPE;
521:
522: --Related Line Detail pl/sql tables start
523: l_line_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
524: l_line_detail_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
525: l_relationship_type_code_rtbl QP_PREQ_GRP.VARCHAR_TYPE;
526:
527: l_rltd_line_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
528: l_rltd_line_detail_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 525: l_relationship_type_code_rtbl QP_PREQ_GRP.VARCHAR_TYPE;

521:
522: --Related Line Detail pl/sql tables start
523: l_line_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
524: l_line_detail_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
525: l_relationship_type_code_rtbl QP_PREQ_GRP.VARCHAR_TYPE;
526:
527: l_rltd_line_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
528: l_rltd_line_detail_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
529:

Line 527: l_rltd_line_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

523: l_line_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
524: l_line_detail_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
525: l_relationship_type_code_rtbl QP_PREQ_GRP.VARCHAR_TYPE;
526:
527: l_rltd_line_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
528: l_rltd_line_detail_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
529:
530: l_list_line_id_rtbl QP_PREQ_GRP.NUMBER_TYPE;
531: l_rltd_list_line_id_rtbl QP_PREQ_GRP.NUMBER_TYPE;

Line 528: l_rltd_line_detail_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

524: l_line_detail_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
525: l_relationship_type_code_rtbl QP_PREQ_GRP.VARCHAR_TYPE;
526:
527: l_rltd_line_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
528: l_rltd_line_detail_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
529:
530: l_list_line_id_rtbl QP_PREQ_GRP.NUMBER_TYPE;
531: l_rltd_list_line_id_rtbl QP_PREQ_GRP.NUMBER_TYPE;
532: l_pricing_status_text_rtbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 530: l_list_line_id_rtbl QP_PREQ_GRP.NUMBER_TYPE;

526:
527: l_rltd_line_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
528: l_rltd_line_detail_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
529:
530: l_list_line_id_rtbl QP_PREQ_GRP.NUMBER_TYPE;
531: l_rltd_list_line_id_rtbl QP_PREQ_GRP.NUMBER_TYPE;
532: l_pricing_status_text_rtbl QP_PREQ_GRP.VARCHAR_TYPE;
533: --Related Line Detail pl/sql tables end
534:

Line 531: l_rltd_list_line_id_rtbl QP_PREQ_GRP.NUMBER_TYPE;

527: l_rltd_line_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
528: l_rltd_line_detail_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
529:
530: l_list_line_id_rtbl QP_PREQ_GRP.NUMBER_TYPE;
531: l_rltd_list_line_id_rtbl QP_PREQ_GRP.NUMBER_TYPE;
532: l_pricing_status_text_rtbl QP_PREQ_GRP.VARCHAR_TYPE;
533: --Related Line Detail pl/sql tables end
534:
535: --Line Attribute pl/sql tables Start

Line 532: l_pricing_status_text_rtbl QP_PREQ_GRP.VARCHAR_TYPE;

528: l_rltd_line_detail_index_rtbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
529:
530: l_list_line_id_rtbl QP_PREQ_GRP.NUMBER_TYPE;
531: l_rltd_list_line_id_rtbl QP_PREQ_GRP.NUMBER_TYPE;
532: l_pricing_status_text_rtbl QP_PREQ_GRP.VARCHAR_TYPE;
533: --Related Line Detail pl/sql tables end
534:
535: --Line Attribute pl/sql tables Start
536: l_line_index_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 536: l_line_index_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

532: l_pricing_status_text_rtbl QP_PREQ_GRP.VARCHAR_TYPE;
533: --Related Line Detail pl/sql tables end
534:
535: --Line Attribute pl/sql tables Start
536: l_line_index_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
537: l_line_detail_index_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
538: l_attribute_level_atbl QP_PREQ_GRP.VARCHAR_TYPE;
539: l_attribute_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
540: l_list_header_id_atbl QP_PREQ_GRP.NUMBER_TYPE;

Line 537: l_line_detail_index_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

533: --Related Line Detail pl/sql tables end
534:
535: --Line Attribute pl/sql tables Start
536: l_line_index_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
537: l_line_detail_index_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
538: l_attribute_level_atbl QP_PREQ_GRP.VARCHAR_TYPE;
539: l_attribute_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
540: l_list_header_id_atbl QP_PREQ_GRP.NUMBER_TYPE;
541: l_list_line_id_atbl QP_PREQ_GRP.NUMBER_TYPE;

Line 538: l_attribute_level_atbl QP_PREQ_GRP.VARCHAR_TYPE;

534:
535: --Line Attribute pl/sql tables Start
536: l_line_index_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
537: l_line_detail_index_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
538: l_attribute_level_atbl QP_PREQ_GRP.VARCHAR_TYPE;
539: l_attribute_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
540: l_list_header_id_atbl QP_PREQ_GRP.NUMBER_TYPE;
541: l_list_line_id_atbl QP_PREQ_GRP.NUMBER_TYPE;
542: l_context_atbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 539: l_attribute_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;

535: --Line Attribute pl/sql tables Start
536: l_line_index_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
537: l_line_detail_index_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
538: l_attribute_level_atbl QP_PREQ_GRP.VARCHAR_TYPE;
539: l_attribute_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
540: l_list_header_id_atbl QP_PREQ_GRP.NUMBER_TYPE;
541: l_list_line_id_atbl QP_PREQ_GRP.NUMBER_TYPE;
542: l_context_atbl QP_PREQ_GRP.VARCHAR_TYPE;
543: l_attribute_atbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 540: l_list_header_id_atbl QP_PREQ_GRP.NUMBER_TYPE;

536: l_line_index_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
537: l_line_detail_index_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
538: l_attribute_level_atbl QP_PREQ_GRP.VARCHAR_TYPE;
539: l_attribute_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
540: l_list_header_id_atbl QP_PREQ_GRP.NUMBER_TYPE;
541: l_list_line_id_atbl QP_PREQ_GRP.NUMBER_TYPE;
542: l_context_atbl QP_PREQ_GRP.VARCHAR_TYPE;
543: l_attribute_atbl QP_PREQ_GRP.VARCHAR_TYPE;
544: l_value_from_atbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 541: l_list_line_id_atbl QP_PREQ_GRP.NUMBER_TYPE;

537: l_line_detail_index_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
538: l_attribute_level_atbl QP_PREQ_GRP.VARCHAR_TYPE;
539: l_attribute_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
540: l_list_header_id_atbl QP_PREQ_GRP.NUMBER_TYPE;
541: l_list_line_id_atbl QP_PREQ_GRP.NUMBER_TYPE;
542: l_context_atbl QP_PREQ_GRP.VARCHAR_TYPE;
543: l_attribute_atbl QP_PREQ_GRP.VARCHAR_TYPE;
544: l_value_from_atbl QP_PREQ_GRP.VARCHAR_TYPE;
545: l_setup_value_from_atbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 542: l_context_atbl QP_PREQ_GRP.VARCHAR_TYPE;

538: l_attribute_level_atbl QP_PREQ_GRP.VARCHAR_TYPE;
539: l_attribute_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
540: l_list_header_id_atbl QP_PREQ_GRP.NUMBER_TYPE;
541: l_list_line_id_atbl QP_PREQ_GRP.NUMBER_TYPE;
542: l_context_atbl QP_PREQ_GRP.VARCHAR_TYPE;
543: l_attribute_atbl QP_PREQ_GRP.VARCHAR_TYPE;
544: l_value_from_atbl QP_PREQ_GRP.VARCHAR_TYPE;
545: l_setup_value_from_atbl QP_PREQ_GRP.VARCHAR_TYPE;
546: l_value_to_atbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 543: l_attribute_atbl QP_PREQ_GRP.VARCHAR_TYPE;

539: l_attribute_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
540: l_list_header_id_atbl QP_PREQ_GRP.NUMBER_TYPE;
541: l_list_line_id_atbl QP_PREQ_GRP.NUMBER_TYPE;
542: l_context_atbl QP_PREQ_GRP.VARCHAR_TYPE;
543: l_attribute_atbl QP_PREQ_GRP.VARCHAR_TYPE;
544: l_value_from_atbl QP_PREQ_GRP.VARCHAR_TYPE;
545: l_setup_value_from_atbl QP_PREQ_GRP.VARCHAR_TYPE;
546: l_value_to_atbl QP_PREQ_GRP.VARCHAR_TYPE;
547: l_setup_value_to_atbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 544: l_value_from_atbl QP_PREQ_GRP.VARCHAR_TYPE;

540: l_list_header_id_atbl QP_PREQ_GRP.NUMBER_TYPE;
541: l_list_line_id_atbl QP_PREQ_GRP.NUMBER_TYPE;
542: l_context_atbl QP_PREQ_GRP.VARCHAR_TYPE;
543: l_attribute_atbl QP_PREQ_GRP.VARCHAR_TYPE;
544: l_value_from_atbl QP_PREQ_GRP.VARCHAR_TYPE;
545: l_setup_value_from_atbl QP_PREQ_GRP.VARCHAR_TYPE;
546: l_value_to_atbl QP_PREQ_GRP.VARCHAR_TYPE;
547: l_setup_value_to_atbl QP_PREQ_GRP.VARCHAR_TYPE;
548: l_grouping_number_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 545: l_setup_value_from_atbl QP_PREQ_GRP.VARCHAR_TYPE;

541: l_list_line_id_atbl QP_PREQ_GRP.NUMBER_TYPE;
542: l_context_atbl QP_PREQ_GRP.VARCHAR_TYPE;
543: l_attribute_atbl QP_PREQ_GRP.VARCHAR_TYPE;
544: l_value_from_atbl QP_PREQ_GRP.VARCHAR_TYPE;
545: l_setup_value_from_atbl QP_PREQ_GRP.VARCHAR_TYPE;
546: l_value_to_atbl QP_PREQ_GRP.VARCHAR_TYPE;
547: l_setup_value_to_atbl QP_PREQ_GRP.VARCHAR_TYPE;
548: l_grouping_number_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
549: l_no_qualifiers_in_grp_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 546: l_value_to_atbl QP_PREQ_GRP.VARCHAR_TYPE;

542: l_context_atbl QP_PREQ_GRP.VARCHAR_TYPE;
543: l_attribute_atbl QP_PREQ_GRP.VARCHAR_TYPE;
544: l_value_from_atbl QP_PREQ_GRP.VARCHAR_TYPE;
545: l_setup_value_from_atbl QP_PREQ_GRP.VARCHAR_TYPE;
546: l_value_to_atbl QP_PREQ_GRP.VARCHAR_TYPE;
547: l_setup_value_to_atbl QP_PREQ_GRP.VARCHAR_TYPE;
548: l_grouping_number_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
549: l_no_qualifiers_in_grp_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
550: l_compar_oper_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 547: l_setup_value_to_atbl QP_PREQ_GRP.VARCHAR_TYPE;

543: l_attribute_atbl QP_PREQ_GRP.VARCHAR_TYPE;
544: l_value_from_atbl QP_PREQ_GRP.VARCHAR_TYPE;
545: l_setup_value_from_atbl QP_PREQ_GRP.VARCHAR_TYPE;
546: l_value_to_atbl QP_PREQ_GRP.VARCHAR_TYPE;
547: l_setup_value_to_atbl QP_PREQ_GRP.VARCHAR_TYPE;
548: l_grouping_number_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
549: l_no_qualifiers_in_grp_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
550: l_compar_oper_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
551: l_validated_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 548: l_grouping_number_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

544: l_value_from_atbl QP_PREQ_GRP.VARCHAR_TYPE;
545: l_setup_value_from_atbl QP_PREQ_GRP.VARCHAR_TYPE;
546: l_value_to_atbl QP_PREQ_GRP.VARCHAR_TYPE;
547: l_setup_value_to_atbl QP_PREQ_GRP.VARCHAR_TYPE;
548: l_grouping_number_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
549: l_no_qualifiers_in_grp_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
550: l_compar_oper_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
551: l_validated_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
552: l_applied_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 549: l_no_qualifiers_in_grp_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

545: l_setup_value_from_atbl QP_PREQ_GRP.VARCHAR_TYPE;
546: l_value_to_atbl QP_PREQ_GRP.VARCHAR_TYPE;
547: l_setup_value_to_atbl QP_PREQ_GRP.VARCHAR_TYPE;
548: l_grouping_number_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
549: l_no_qualifiers_in_grp_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
550: l_compar_oper_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
551: l_validated_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
552: l_applied_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
553: l_pricing_status_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 550: l_compar_oper_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;

546: l_value_to_atbl QP_PREQ_GRP.VARCHAR_TYPE;
547: l_setup_value_to_atbl QP_PREQ_GRP.VARCHAR_TYPE;
548: l_grouping_number_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
549: l_no_qualifiers_in_grp_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
550: l_compar_oper_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
551: l_validated_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
552: l_applied_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
553: l_pricing_status_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
554: l_pricing_status_text_atbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 551: l_validated_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;

547: l_setup_value_to_atbl QP_PREQ_GRP.VARCHAR_TYPE;
548: l_grouping_number_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
549: l_no_qualifiers_in_grp_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
550: l_compar_oper_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
551: l_validated_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
552: l_applied_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
553: l_pricing_status_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
554: l_pricing_status_text_atbl QP_PREQ_GRP.VARCHAR_TYPE;
555: l_qualifier_precedence_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 552: l_applied_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;

548: l_grouping_number_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
549: l_no_qualifiers_in_grp_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
550: l_compar_oper_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
551: l_validated_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
552: l_applied_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
553: l_pricing_status_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
554: l_pricing_status_text_atbl QP_PREQ_GRP.VARCHAR_TYPE;
555: l_qualifier_precedence_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
556: l_datatype_atbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 553: l_pricing_status_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;

549: l_no_qualifiers_in_grp_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
550: l_compar_oper_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
551: l_validated_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
552: l_applied_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
553: l_pricing_status_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
554: l_pricing_status_text_atbl QP_PREQ_GRP.VARCHAR_TYPE;
555: l_qualifier_precedence_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
556: l_datatype_atbl QP_PREQ_GRP.VARCHAR_TYPE;
557: l_pricing_attr_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 554: l_pricing_status_text_atbl QP_PREQ_GRP.VARCHAR_TYPE;

550: l_compar_oper_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
551: l_validated_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
552: l_applied_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
553: l_pricing_status_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
554: l_pricing_status_text_atbl QP_PREQ_GRP.VARCHAR_TYPE;
555: l_qualifier_precedence_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
556: l_datatype_atbl QP_PREQ_GRP.VARCHAR_TYPE;
557: l_pricing_attr_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
558: l_qualifier_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 555: l_qualifier_precedence_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

551: l_validated_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
552: l_applied_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
553: l_pricing_status_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
554: l_pricing_status_text_atbl QP_PREQ_GRP.VARCHAR_TYPE;
555: l_qualifier_precedence_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
556: l_datatype_atbl QP_PREQ_GRP.VARCHAR_TYPE;
557: l_pricing_attr_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
558: l_qualifier_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
559: l_product_uom_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 556: l_datatype_atbl QP_PREQ_GRP.VARCHAR_TYPE;

552: l_applied_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
553: l_pricing_status_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
554: l_pricing_status_text_atbl QP_PREQ_GRP.VARCHAR_TYPE;
555: l_qualifier_precedence_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
556: l_datatype_atbl QP_PREQ_GRP.VARCHAR_TYPE;
557: l_pricing_attr_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
558: l_qualifier_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
559: l_product_uom_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
560: l_excluder_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 557: l_pricing_attr_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;

553: l_pricing_status_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
554: l_pricing_status_text_atbl QP_PREQ_GRP.VARCHAR_TYPE;
555: l_qualifier_precedence_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
556: l_datatype_atbl QP_PREQ_GRP.VARCHAR_TYPE;
557: l_pricing_attr_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
558: l_qualifier_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
559: l_product_uom_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
560: l_excluder_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
561: l_pricing_phase_id_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 558: l_qualifier_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;

554: l_pricing_status_text_atbl QP_PREQ_GRP.VARCHAR_TYPE;
555: l_qualifier_precedence_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
556: l_datatype_atbl QP_PREQ_GRP.VARCHAR_TYPE;
557: l_pricing_attr_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
558: l_qualifier_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
559: l_product_uom_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
560: l_excluder_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
561: l_pricing_phase_id_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
562: l_incomp_grp_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 559: l_product_uom_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;

555: l_qualifier_precedence_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
556: l_datatype_atbl QP_PREQ_GRP.VARCHAR_TYPE;
557: l_pricing_attr_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
558: l_qualifier_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
559: l_product_uom_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
560: l_excluder_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
561: l_pricing_phase_id_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
562: l_incomp_grp_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
563: l_line_detail_type_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 560: l_excluder_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;

556: l_datatype_atbl QP_PREQ_GRP.VARCHAR_TYPE;
557: l_pricing_attr_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
558: l_qualifier_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
559: l_product_uom_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
560: l_excluder_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
561: l_pricing_phase_id_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
562: l_incomp_grp_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
563: l_line_detail_type_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
564: l_modifier_level_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 561: l_pricing_phase_id_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

557: l_pricing_attr_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
558: l_qualifier_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
559: l_product_uom_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
560: l_excluder_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
561: l_pricing_phase_id_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
562: l_incomp_grp_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
563: l_line_detail_type_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
564: l_modifier_level_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
565: l_primary_uom_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 562: l_incomp_grp_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;

558: l_qualifier_type_atbl QP_PREQ_GRP.VARCHAR_TYPE;
559: l_product_uom_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
560: l_excluder_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
561: l_pricing_phase_id_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
562: l_incomp_grp_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
563: l_line_detail_type_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
564: l_modifier_level_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
565: l_primary_uom_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
566: --Line Attribute pl/sql tables End

Line 563: l_line_detail_type_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;

559: l_product_uom_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
560: l_excluder_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
561: l_pricing_phase_id_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
562: l_incomp_grp_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
563: l_line_detail_type_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
564: l_modifier_level_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
565: l_primary_uom_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
566: --Line Attribute pl/sql tables End
567:

Line 564: l_modifier_level_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;

560: l_excluder_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
561: l_pricing_phase_id_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
562: l_incomp_grp_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
563: l_line_detail_type_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
564: l_modifier_level_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
565: l_primary_uom_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
566: --Line Attribute pl/sql tables End
567:
568: l_min_price_adj_id NUMBER;

Line 565: l_primary_uom_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;

561: l_pricing_phase_id_atbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
562: l_incomp_grp_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
563: l_line_detail_type_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
564: l_modifier_level_code_atbl QP_PREQ_GRP.VARCHAR_TYPE;
565: l_primary_uom_flag_atbl QP_PREQ_GRP.VARCHAR_TYPE;
566: --Line Attribute pl/sql tables End
567:
568: l_min_price_adj_id NUMBER;
569: l_return_status_text VARCHAR2(2000);

Line 579: AND (ADJV.automatic_flag = QP_PREQ_GRP.G_NO -- If modifier is not automatic. i.e., manual

575: FROM PO_PRICE_ADJUSTMENTS_V ADJV
576: WHERE ADJV.po_header_id = p_order_header_id --ADJV.draft_id = p_draft_id --sometimes draft_id may be passed as null
577: AND ADJV.po_line_id = p_order_line_id
578: AND NVL(ADJV.applied_flag,'Y') = 'Y' --To avoid applying manual modifiers selected and cancelled by the user
579: AND (ADJV.automatic_flag = QP_PREQ_GRP.G_NO -- If modifier is not automatic. i.e., manual
580: OR
581: (ADJV.automatic_flag = QP_PREQ_GRP.G_YES -- If modifier is automatic, changed and overridable
582: AND
583: ADJV.updated_flag = QP_PREQ_GRP.G_YES

Line 581: (ADJV.automatic_flag = QP_PREQ_GRP.G_YES -- If modifier is automatic, changed and overridable

577: AND ADJV.po_line_id = p_order_line_id
578: AND NVL(ADJV.applied_flag,'Y') = 'Y' --To avoid applying manual modifiers selected and cancelled by the user
579: AND (ADJV.automatic_flag = QP_PREQ_GRP.G_NO -- If modifier is not automatic. i.e., manual
580: OR
581: (ADJV.automatic_flag = QP_PREQ_GRP.G_YES -- If modifier is automatic, changed and overridable
582: AND
583: ADJV.updated_flag = QP_PREQ_GRP.G_YES
584: AND
585: ADJV.update_allowed = QP_PREQ_GRP.G_YES

Line 583: ADJV.updated_flag = QP_PREQ_GRP.G_YES

579: AND (ADJV.automatic_flag = QP_PREQ_GRP.G_NO -- If modifier is not automatic. i.e., manual
580: OR
581: (ADJV.automatic_flag = QP_PREQ_GRP.G_YES -- If modifier is automatic, changed and overridable
582: AND
583: ADJV.updated_flag = QP_PREQ_GRP.G_YES
584: AND
585: ADJV.update_allowed = QP_PREQ_GRP.G_YES
586: )
587: );

Line 585: ADJV.update_allowed = QP_PREQ_GRP.G_YES

581: (ADJV.automatic_flag = QP_PREQ_GRP.G_YES -- If modifier is automatic, changed and overridable
582: AND
583: ADJV.updated_flag = QP_PREQ_GRP.G_YES
584: AND
585: ADJV.update_allowed = QP_PREQ_GRP.G_YES
586: )
587: );
588:
589:

Line 619: AND (ADJV.automatic_flag = QP_PREQ_GRP.G_NO -- If modifier is not automatic. i.e., manual

615: FROM PO_PRICE_ADJUSTMENTS_V ADJV
616: WHERE ADJV.po_header_id = p_order_header_id --ADJV.draft_id = p_draft_id --sometimes draft_id may be passed as null
617: AND ADJV.po_line_id = p_order_line_id
618: AND NVL(ADJV.applied_flag,'Y') = 'Y' --To avoid applying manual modifiers selected and cancelled by the user
619: AND (ADJV.automatic_flag = QP_PREQ_GRP.G_NO -- If modifier is not automatic. i.e., manual
620: OR
621: (ADJV.automatic_flag = QP_PREQ_GRP.G_YES -- If modifier is automatic, changed and overridable
622: AND
623: ADJV.updated_flag = QP_PREQ_GRP.G_YES

Line 621: (ADJV.automatic_flag = QP_PREQ_GRP.G_YES -- If modifier is automatic, changed and overridable

617: AND ADJV.po_line_id = p_order_line_id
618: AND NVL(ADJV.applied_flag,'Y') = 'Y' --To avoid applying manual modifiers selected and cancelled by the user
619: AND (ADJV.automatic_flag = QP_PREQ_GRP.G_NO -- If modifier is not automatic. i.e., manual
620: OR
621: (ADJV.automatic_flag = QP_PREQ_GRP.G_YES -- If modifier is automatic, changed and overridable
622: AND
623: ADJV.updated_flag = QP_PREQ_GRP.G_YES
624: AND
625: ADJV.update_allowed = QP_PREQ_GRP.G_YES

Line 623: ADJV.updated_flag = QP_PREQ_GRP.G_YES

619: AND (ADJV.automatic_flag = QP_PREQ_GRP.G_NO -- If modifier is not automatic. i.e., manual
620: OR
621: (ADJV.automatic_flag = QP_PREQ_GRP.G_YES -- If modifier is automatic, changed and overridable
622: AND
623: ADJV.updated_flag = QP_PREQ_GRP.G_YES
624: AND
625: ADJV.update_allowed = QP_PREQ_GRP.G_YES
626: )
627: )

Line 625: ADJV.update_allowed = QP_PREQ_GRP.G_YES

621: (ADJV.automatic_flag = QP_PREQ_GRP.G_YES -- If modifier is automatic, changed and overridable
622: AND
623: ADJV.updated_flag = QP_PREQ_GRP.G_YES
624: AND
625: ADJV.update_allowed = QP_PREQ_GRP.G_YES
626: )
627: )
628: ORDER BY ADJV.price_adjustment_id ASC;
629:

Line 649: AND (ATTRV.automatic_flag = QP_PREQ_GRP.G_NO -- If modifier is not automatic. i.e., manual

645: FROM PO_PRICE_ADJ_ATTRIBS_V ATTRV
646: WHERE ATTRV.po_header_id = p_order_header_id --ATTRV.draft_id = p_draft_id --sometimes draft_id may be passed as null
647: AND ATTRV.po_line_id = p_order_line_id
648: AND NVL(ATTRV.applied_flag,'Y') = 'Y' --To avoid applying manual modifiers selected and cancelled by the user
649: AND (ATTRV.automatic_flag = QP_PREQ_GRP.G_NO -- If modifier is not automatic. i.e., manual
650: OR
651: (ATTRV.automatic_flag = QP_PREQ_GRP.G_YES -- If modifier is automatic, changed and overridable
652: AND
653: ATTRV.updated_flag = QP_PREQ_GRP.G_YES

Line 651: (ATTRV.automatic_flag = QP_PREQ_GRP.G_YES -- If modifier is automatic, changed and overridable

647: AND ATTRV.po_line_id = p_order_line_id
648: AND NVL(ATTRV.applied_flag,'Y') = 'Y' --To avoid applying manual modifiers selected and cancelled by the user
649: AND (ATTRV.automatic_flag = QP_PREQ_GRP.G_NO -- If modifier is not automatic. i.e., manual
650: OR
651: (ATTRV.automatic_flag = QP_PREQ_GRP.G_YES -- If modifier is automatic, changed and overridable
652: AND
653: ATTRV.updated_flag = QP_PREQ_GRP.G_YES
654: AND
655: ATTRV.update_allowed = QP_PREQ_GRP.G_YES

Line 653: ATTRV.updated_flag = QP_PREQ_GRP.G_YES

649: AND (ATTRV.automatic_flag = QP_PREQ_GRP.G_NO -- If modifier is not automatic. i.e., manual
650: OR
651: (ATTRV.automatic_flag = QP_PREQ_GRP.G_YES -- If modifier is automatic, changed and overridable
652: AND
653: ATTRV.updated_flag = QP_PREQ_GRP.G_YES
654: AND
655: ATTRV.update_allowed = QP_PREQ_GRP.G_YES
656: )
657: )

Line 655: ATTRV.update_allowed = QP_PREQ_GRP.G_YES

651: (ATTRV.automatic_flag = QP_PREQ_GRP.G_YES -- If modifier is automatic, changed and overridable
652: AND
653: ATTRV.updated_flag = QP_PREQ_GRP.G_YES
654: AND
655: ATTRV.update_allowed = QP_PREQ_GRP.G_YES
656: )
657: )
658: ORDER BY ATTRV.price_adjustment_id ASC;
659:

Line 919: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Initialize parameters before calling Insert Line Details in QP_PREQ_GRP');

915: END IF;
916: ELSE
917: l_progress := '140';
918: IF g_debug_stmt THEN
919: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Initialize parameters before calling Insert Line Details in QP_PREQ_GRP');
920: END IF;
921: m := 0;
922: FOR j IN l_price_adjustment_id_tbl.FIRST .. l_price_adjustment_id_tbl.LAST
923: LOOP

Line 952: IF (l_automatic_flag_tbl(j) = QP_PREQ_GRP.G_NO) THEN

948: l_applied_flag(m) := l_applied_flag_tbl(j);
949: l_override_flag(m) := l_override_flag_tbl(j);
950: l_automatic_flag(m) := l_automatic_flag_tbl(j);
951:
952: IF (l_automatic_flag_tbl(j) = QP_PREQ_GRP.G_NO) THEN
953: l_updated_flag(m) := QP_PREQ_GRP.G_YES;
954: l_applied_flag(m) := QP_PREQ_GRP.G_YES; --the value l_applied_flag_tbl(j) from the cursor Should always be 'Y', this line can be removed once confirmed
955: ELSE
956: l_updated_flag(m) := l_updated_flag_tbl(j); -- if automatic, it can be either Y or N

Line 953: l_updated_flag(m) := QP_PREQ_GRP.G_YES;

949: l_override_flag(m) := l_override_flag_tbl(j);
950: l_automatic_flag(m) := l_automatic_flag_tbl(j);
951:
952: IF (l_automatic_flag_tbl(j) = QP_PREQ_GRP.G_NO) THEN
953: l_updated_flag(m) := QP_PREQ_GRP.G_YES;
954: l_applied_flag(m) := QP_PREQ_GRP.G_YES; --the value l_applied_flag_tbl(j) from the cursor Should always be 'Y', this line can be removed once confirmed
955: ELSE
956: l_updated_flag(m) := l_updated_flag_tbl(j); -- if automatic, it can be either Y or N
957: END IF;

Line 954: l_applied_flag(m) := QP_PREQ_GRP.G_YES; --the value l_applied_flag_tbl(j) from the cursor Should always be 'Y', this line can be removed once confirmed

950: l_automatic_flag(m) := l_automatic_flag_tbl(j);
951:
952: IF (l_automatic_flag_tbl(j) = QP_PREQ_GRP.G_NO) THEN
953: l_updated_flag(m) := QP_PREQ_GRP.G_YES;
954: l_applied_flag(m) := QP_PREQ_GRP.G_YES; --the value l_applied_flag_tbl(j) from the cursor Should always be 'Y', this line can be removed once confirmed
955: ELSE
956: l_updated_flag(m) := l_updated_flag_tbl(j); -- if automatic, it can be either Y or N
957: END IF;
958:

Line 972: l_process_code(m) := QP_PREQ_GRP.G_STATUS_NEW;

968: --Line Details Type Code cannot be null. Set it to 'NULL' string
969: l_line_detail_type_code(m) := 'NULL';
970:
971: --Set the process code
972: l_process_code(m) := QP_PREQ_GRP.G_STATUS_NEW;
973: l_processed_flag(m) := NULL;
974:
975: --Set line quantity
976: IF (p_quantity_tbl.exists(i)) THEN

Line 983: l_pricing_status_code(m) := QP_PREQ_GRP.G_STATUS_UNCHANGED;

979: l_line_quantity(m) := 1;
980: END IF;
981:
982: --Set the pricing status to unchanged for the pricing engine to consider the adjsutment
983: l_pricing_status_code(m) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
984: l_pricing_status_text(m) := NULL;
985:
986: --Initiailize the other parameters as NULL
987: l_list_price(m) := NULL;

Line 1077: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Initialize parameters before calling Insert Line Attr Details in QP_PREQ_GRP');

1073: l_validated_flag_atbl;
1074:
1075: l_progress := '160';
1076: IF g_debug_stmt THEN
1077: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Initialize parameters before calling Insert Line Attr Details in QP_PREQ_GRP');
1078: END IF;
1079: IF l_line_detail_index_atbl.count > 0 THEN
1080: FOR j IN l_line_detail_index_atbl.FIRST .. l_line_detail_index_atbl.LAST
1081: LOOP

Line 1103: l_pricing_status_code_atbl(j) := QP_PREQ_GRP.G_STATUS_NEW;

1099: l_no_qualifiers_in_grp_atbl(j) := NULL;
1100: --l_compar_oper_type_atbl(j) := NULL; --Initialized in fetch statement
1101: --l_validated_flag_atbl(j) := NULL; --Initialized in fetch statement
1102: l_applied_flag_atbl(j) := NULL;
1103: l_pricing_status_code_atbl(j) := QP_PREQ_GRP.G_STATUS_NEW;
1104: l_pricing_status_text_atbl(j) := NULL;
1105: l_qualifier_precedence_atbl(j) := NULL;
1106: l_datatype_atbl(j) := NULL;
1107: l_pricing_attr_flag_atbl(j) := NULL;

Line 1122: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling bulk insert procedure QP_PREQ_GRP.INSERT_LDETS2 to insert line details');

1118: END IF;
1119:
1120: l_progress := '170';
1121: IF g_debug_stmt THEN
1122: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling bulk insert procedure QP_PREQ_GRP.INSERT_LDETS2 to insert line details');
1123: END IF;
1124:
1125: IF l_price_adjustment_id_tbl.count > 0 THEN
1126: QP_PREQ_GRP.INSERT_LDETS2

Line 1126: QP_PREQ_GRP.INSERT_LDETS2

1122: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling bulk insert procedure QP_PREQ_GRP.INSERT_LDETS2 to insert line details');
1123: END IF;
1124:
1125: IF l_price_adjustment_id_tbl.count > 0 THEN
1126: QP_PREQ_GRP.INSERT_LDETS2
1127: (p_line_detail_index => l_line_detail_index
1128: ,p_line_detail_type_code => l_line_detail_type_code
1129: ,p_price_break_type_code => l_price_break_type_code
1130: ,p_list_price => l_list_price

Line 1216: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling bulk insert procedure QP_PREQ_GRP.INSERT_RLTD_LINES2 to insert relationship between lines');

1212:
1213:
1214: l_progress := '190';
1215: IF g_debug_stmt THEN
1216: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling bulk insert procedure QP_PREQ_GRP.INSERT_RLTD_LINES2 to insert relationship between lines');
1217: END IF;
1218: IF l_line_detail_index_rtbl.count > 0 THEN
1219: QP_PREQ_GRP.INSERT_RLTD_LINES2
1220: (p_line_index => l_line_index_rtbl

Line 1219: QP_PREQ_GRP.INSERT_RLTD_LINES2

1215: IF g_debug_stmt THEN
1216: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling bulk insert procedure QP_PREQ_GRP.INSERT_RLTD_LINES2 to insert relationship between lines');
1217: END IF;
1218: IF l_line_detail_index_rtbl.count > 0 THEN
1219: QP_PREQ_GRP.INSERT_RLTD_LINES2
1220: (p_line_index => l_line_index_rtbl
1221: ,p_line_detail_index => l_line_detail_index_rtbl
1222: ,p_relationship_type_code => l_relationship_type_code_rtbl
1223: ,p_related_line_index => l_rltd_line_index_rtbl

Line 1255: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling bulk insert procedure QP_PREQ_GRP.INSERT_LINE_ATTRS2 to insert line attribute details');

1251:
1252:
1253: l_progress := '210';
1254: IF g_debug_stmt THEN
1255: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling bulk insert procedure QP_PREQ_GRP.INSERT_LINE_ATTRS2 to insert line attribute details');
1256: END IF;
1257: IF l_line_detail_index_atbl.count > 0 THEN
1258: QP_PREQ_GRP.INSERT_LINE_ATTRS2
1259: (p_line_index_tbl => l_line_index_atbl

Line 1258: QP_PREQ_GRP.INSERT_LINE_ATTRS2

1254: IF g_debug_stmt THEN
1255: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling bulk insert procedure QP_PREQ_GRP.INSERT_LINE_ATTRS2 to insert line attribute details');
1256: END IF;
1257: IF l_line_detail_index_atbl.count > 0 THEN
1258: QP_PREQ_GRP.INSERT_LINE_ATTRS2
1259: (p_line_index_tbl => l_line_index_atbl
1260: ,p_line_detail_index_tbl => l_line_detail_index_atbl
1261: ,p_attribute_level_tbl => l_attribute_level_atbl
1262: ,p_attribute_type_tbl => l_attribute_type_atbl

Line 1380: ,p_order_line_id_tbl IN QP_PREQ_GRP.NUMBER_TYPE := G_EMPTY_NUMBER_TYPE

1376: -------------------------------------------------------------------------------
1377: PROCEDURE extract_price_adjustments
1378: (p_draft_id IN NUMBER
1379: ,p_order_header_id IN NUMBER
1380: ,p_order_line_id_tbl IN QP_PREQ_GRP.NUMBER_TYPE := G_EMPTY_NUMBER_TYPE
1381: ,p_pricing_events IN VARCHAR2
1382: ,p_calculate_flag IN VARCHAR2
1383: ,p_doc_sub_type IN VARCHAR2
1384: --Bug:8598002 renamed p_retro_pricing to p_pricing_call_src, to distinguish calls from retro and auto creation

Line 1407: WHERE LDUP.process_code IN (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_UPDATED)

1403: ,LDUP.line_detail_index
1404: FROM QP_LDETS_V LDUP
1405: ,QP_PREQ_LINES_TMP QLUP
1406: ,PO_PRICE_ADJUSTMENTS_DRAFT ADJ
1407: WHERE LDUP.process_code IN (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_UPDATED)
1408: AND LDUP.list_line_id = ADJ.list_line_id
1409: AND ADJ.po_line_id = QLUP.line_id
1410: AND ADJ.draft_id = p_draft_id --For now draft_id in this place can never be null, but this condition needs to be changed or removed if null value is allowed in draft_id
1411: AND QLUP.line_index = LDUP.line_index

Line 1412: AND QLUP.pricing_status_code IN (QP_PREQ_GRP.G_STATUS_UPDATED) --QP_PREQ_GRP.G_STATUS_NEW

1408: AND LDUP.list_line_id = ADJ.list_line_id
1409: AND ADJ.po_line_id = QLUP.line_id
1410: AND ADJ.draft_id = p_draft_id --For now draft_id in this place can never be null, but this condition needs to be changed or removed if null value is allowed in draft_id
1411: AND QLUP.line_index = LDUP.line_index
1412: AND QLUP.pricing_status_code IN (QP_PREQ_GRP.G_STATUS_UPDATED) --QP_PREQ_GRP.G_STATUS_NEW
1413: AND QLUP.process_status <> 'NOT_VALID'
1414: AND QLUP.line_type_code = 'LINE';
1415:
1416: --

Line 1462: IF (p_calculate_flag <> QP_PREQ_GRP.G_CALCULATE_ONLY) THEN

1458: IF g_debug_stmt THEN
1459: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Extract adjustments from QP temp tables');
1460: END IF;
1461:
1462: IF (p_calculate_flag <> QP_PREQ_GRP.G_CALCULATE_ONLY) THEN
1463: l_progress := '040';
1464: IF g_debug_stmt THEN
1465: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Delete outdated adjustments and dependant details');
1466: END IF;

Line 1504: IF (p_calculate_flag <> QP_PREQ_GRP.G_CALCULATE_ONLY) THEN

1500: PO_DEBUG.debug_stmt(l_log_head,l_progress,'UPDATED '|| SQL%ROWCOUNT ||' LINE LEVEL ADJUSTMENTS');
1501: END IF;
1502: END LOOP;
1503:
1504: IF (p_calculate_flag <> QP_PREQ_GRP.G_CALCULATE_ONLY) THEN
1505: --Insert new Adjustments into PO ADJUSTMENTS table
1506: --Used Progress code from 270 to 350
1507: insert_adj
1508: (p_draft_id => p_draft_id

Line 1569: ,p_order_line_id_tbl IN QP_PREQ_GRP.NUMBER_TYPE

1565:
1566: PROCEDURE delete_line_adjs
1567: (p_draft_id IN NUMBER
1568: ,p_order_header_id IN NUMBER
1569: ,p_order_line_id_tbl IN QP_PREQ_GRP.NUMBER_TYPE
1570: ,p_pricing_events IN VARCHAR2
1571: --Bug:8598002 renamed p_retro_pricing to p_pricing_call_src, to distinguish calls from retro and auto creation
1572: ,p_pricing_call_src IN VARCHAR2
1573: ,p_allow_price_override_flag IN VARCHAR2

Line 1584: l_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;

1580: l_progress VARCHAR2(4) := '50';
1581:
1582: i PLS_INTEGER;
1583: j PLS_INTEGER;
1584: l_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1585: BEGIN
1586: IF g_debug_stmt THEN
1587: PO_DEBUG.debug_stmt(p_log_head,l_progress,'Delete old line adjustments for lines with pricing_status_code UPDATED');
1588: END IF;

Line 1636: AND LD.process_code IN (QP_PREQ_GRP.G_STATUS_UPDATED

1632: -- = decode(l_price_flag, 'Y', nvl(QPP.user_freeze_override_flag, QPP.freeze_override_flag), 'P', 'Y'))
1633: AND ADJD.list_line_id NOT IN (SELECT LD.list_line_id
1634: FROM qp_ldets_v LD
1635: WHERE LD.line_index = l_line_index
1636: AND LD.process_code IN (QP_PREQ_GRP.G_STATUS_UPDATED
1637: ,QP_PREQ_GRP.G_STATUS_UNCHANGED
1638: ,QP_PREQ_GRP.G_STATUS_NEW)
1639: AND (LD.applied_flag = 'Y'
1640: OR

Line 1637: ,QP_PREQ_GRP.G_STATUS_UNCHANGED

1633: AND ADJD.list_line_id NOT IN (SELECT LD.list_line_id
1634: FROM qp_ldets_v LD
1635: WHERE LD.line_index = l_line_index
1636: AND LD.process_code IN (QP_PREQ_GRP.G_STATUS_UPDATED
1637: ,QP_PREQ_GRP.G_STATUS_UNCHANGED
1638: ,QP_PREQ_GRP.G_STATUS_NEW)
1639: AND (LD.applied_flag = 'Y'
1640: OR
1641: (nvl(ld.applied_flag, 'N') = 'N'

Line 1638: ,QP_PREQ_GRP.G_STATUS_NEW)

1634: FROM qp_ldets_v LD
1635: WHERE LD.line_index = l_line_index
1636: AND LD.process_code IN (QP_PREQ_GRP.G_STATUS_UPDATED
1637: ,QP_PREQ_GRP.G_STATUS_UNCHANGED
1638: ,QP_PREQ_GRP.G_STATUS_NEW)
1639: AND (LD.applied_flag = 'Y'
1640: OR
1641: (nvl(ld.applied_flag, 'N') = 'N'
1642: AND

Line 1847: l_price_adjustment_id_tbl QP_PREQ_GRP.NUMBER_TYPE;

1843: ,p_log_head IN VARCHAR2)
1844: IS
1845: --
1846: l_progress VARCHAR2(4) := '270';
1847: l_price_adjustment_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1848: l_rltd_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1849: i PLS_INTEGER;
1850: BEGIN
1851:

Line 1848: l_rltd_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;

1844: IS
1845: --
1846: l_progress VARCHAR2(4) := '270';
1847: l_price_adjustment_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1848: l_rltd_price_adj_id_tbl QP_PREQ_GRP.NUMBER_TYPE;
1849: i PLS_INTEGER;
1850: BEGIN
1851:
1852: IF g_debug_stmt THEN

Line 2063: AND LDETS.process_code = QP_PREQ_GRP.G_STATUS_NEW

2059: FROM QP_LDETS_v LDETS
2060: , QP_PREQ_LINES_TMP QLINE
2061: , QP_LIST_HEADERS_B QH
2062: WHERE LDETS.list_header_id = QH.list_header_id
2063: AND LDETS.process_code = QP_PREQ_GRP.G_STATUS_NEW
2064: AND QLINE.pricing_status_code IN (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_UPDATED)
2065: AND QLINE.process_status <> 'NOT_VALID'
2066: AND LDETS.line_index = QLINE.line_index
2067: AND (nvl(LDETS.automatic_flag, 'N') = 'Y')

Line 2064: AND QLINE.pricing_status_code IN (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_UPDATED)

2060: , QP_PREQ_LINES_TMP QLINE
2061: , QP_LIST_HEADERS_B QH
2062: WHERE LDETS.list_header_id = QH.list_header_id
2063: AND LDETS.process_code = QP_PREQ_GRP.G_STATUS_NEW
2064: AND QLINE.pricing_status_code IN (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_UPDATED)
2065: AND QLINE.process_status <> 'NOT_VALID'
2066: AND LDETS.line_index = QLINE.line_index
2067: AND (nvl(LDETS.automatic_flag, 'N') = 'Y')
2068: AND LDETS.created_from_list_type_code NOT IN ('PRL', 'AGR')

Line 2099: AND RLTD.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW;

2095: AND RLTD.RELATED_LINE_INDEX = QPL.LINE_INDEX
2096: AND RLTD.RELATED_LIST_LINE_ID = RADJ.LIST_LINE_ID
2097: AND ADJ.PO_LINE_ID = RADJ.PO_LINE_ID
2098: AND ADJ.draft_id = RADJ.draft_id
2099: AND RLTD.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW;
2100:
2101: --Update adjustment table with parent record
2102: FORALL i IN l_rltd_price_adj_id_tbl.FIRST..l_rltd_price_adj_id_tbl.LAST
2103: UPDATE PO_PRICE_ADJUSTMENTS_DRAFT ADJ

Line 2139: AND LDETS.process_code IN (QP_PREQ_GRP.G_STATUS_UNCHANGED, QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_NEW)

2135: AND LDETS.line_index = QPL.line_index
2136: AND ADJ.pricing_phase_id IN (SELECT QEP.pricing_phase_id
2137: FROM qp_event_phases QEP
2138: WHERE instr(p_pricing_events, QEP.pricing_event_code || ',') > 0)
2139: AND LDETS.process_code IN (QP_PREQ_GRP.G_STATUS_UNCHANGED, QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_NEW)
2140: AND nvl(ADJ.updated_flag, 'N') = 'N'
2141: AND QPL.line_id = ADJ.po_line_id
2142: AND QPL.process_status <> 'NOT_VALID'
2143: AND QPL.line_type_code = 'LINE'

Line 2144: AND QPL.pricing_status_code IN (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_UPDATED);

2140: AND nvl(ADJ.updated_flag, 'N') = 'N'
2141: AND QPL.line_id = ADJ.po_line_id
2142: AND QPL.process_status <> 'NOT_VALID'
2143: AND QPL.line_type_code = 'LINE'
2144: AND QPL.pricing_status_code IN (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_UPDATED);
2145: --
2146: BEGIN
2147: --
2148: IF g_debug_stmt THEN