APPS.QP_ARCHIVE_ENTITY_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 255: CURSOR qp_pricing_attributes_cur(p_from_list_line_id NUMBER)

251: l_pric_attr_value_from_number NUMBER := NULL;
252: l_pric_attr_value_to_number NUMBER := NULL;
253:
254:
255: CURSOR qp_pricing_attributes_cur(p_from_list_line_id NUMBER)
256: IS
257: SELECT *
258: FROM qp_pricing_attributes
259: WHERE list_line_id = p_from_list_line_id;

Line 258: FROM qp_pricing_attributes

254:
255: CURSOR qp_pricing_attributes_cur(p_from_list_line_id NUMBER)
256: IS
257: SELECT *
258: FROM qp_pricing_attributes
259: WHERE list_line_id = p_from_list_line_id;
260:
261: BEGIN
262:

Line 483: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (p_to_rltd_modifier_id)

479: DELETE FROM QP_LIST_LINES WHERE list_line_id = p_to_rltd_modifier_id;
480:
481: --Archive the pricing attributes
482:
483: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (p_to_rltd_modifier_id)
484: LOOP
485: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N'
486: THEN
487:

Line 485: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N'

481: --Archive the pricing attributes
482:
483: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (p_to_rltd_modifier_id)
484: LOOP
485: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N'
486: THEN
487:
488: BEGIN
489:

Line 491: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);

487:
488: BEGIN
489:
490: l_pric_attr_value_from_number :=
491: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
492:
493: l_pric_attr_value_to_number :=
494: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
495:

Line 494: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);

490: l_pric_attr_value_from_number :=
491: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
492:
493: l_pric_attr_value_to_number :=
494: qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
495:
496: EXCEPTION
497: WHEN VALUE_ERROR THEN
498: NULL;

Line 565: (l_qp_pricing_attributes_rec.pricing_attribute_id,

561: PRICING_SEGMENT_ID,
562: ARCH_PURG_REQUEST_ID
563: )
564: VALUES
565: (l_qp_pricing_attributes_rec.pricing_attribute_id,
566: l_qp_pricing_attributes_rec.creation_date,
567: l_qp_pricing_attributes_rec.created_by,
568: l_qp_pricing_attributes_rec.last_update_date,
569: l_qp_pricing_attributes_rec.last_updated_by,

Line 566: l_qp_pricing_attributes_rec.creation_date,

562: ARCH_PURG_REQUEST_ID
563: )
564: VALUES
565: (l_qp_pricing_attributes_rec.pricing_attribute_id,
566: l_qp_pricing_attributes_rec.creation_date,
567: l_qp_pricing_attributes_rec.created_by,
568: l_qp_pricing_attributes_rec.last_update_date,
569: l_qp_pricing_attributes_rec.last_updated_by,
570: l_qp_pricing_attributes_rec.last_update_login,

Line 567: l_qp_pricing_attributes_rec.created_by,

563: )
564: VALUES
565: (l_qp_pricing_attributes_rec.pricing_attribute_id,
566: l_qp_pricing_attributes_rec.creation_date,
567: l_qp_pricing_attributes_rec.created_by,
568: l_qp_pricing_attributes_rec.last_update_date,
569: l_qp_pricing_attributes_rec.last_updated_by,
570: l_qp_pricing_attributes_rec.last_update_login,
571: l_qp_pricing_attributes_rec.program_application_id,

Line 568: l_qp_pricing_attributes_rec.last_update_date,

564: VALUES
565: (l_qp_pricing_attributes_rec.pricing_attribute_id,
566: l_qp_pricing_attributes_rec.creation_date,
567: l_qp_pricing_attributes_rec.created_by,
568: l_qp_pricing_attributes_rec.last_update_date,
569: l_qp_pricing_attributes_rec.last_updated_by,
570: l_qp_pricing_attributes_rec.last_update_login,
571: l_qp_pricing_attributes_rec.program_application_id,
572: l_qp_pricing_attributes_rec.program_id,

Line 569: l_qp_pricing_attributes_rec.last_updated_by,

565: (l_qp_pricing_attributes_rec.pricing_attribute_id,
566: l_qp_pricing_attributes_rec.creation_date,
567: l_qp_pricing_attributes_rec.created_by,
568: l_qp_pricing_attributes_rec.last_update_date,
569: l_qp_pricing_attributes_rec.last_updated_by,
570: l_qp_pricing_attributes_rec.last_update_login,
571: l_qp_pricing_attributes_rec.program_application_id,
572: l_qp_pricing_attributes_rec.program_id,
573: l_qp_pricing_attributes_rec.program_update_date,

Line 570: l_qp_pricing_attributes_rec.last_update_login,

566: l_qp_pricing_attributes_rec.creation_date,
567: l_qp_pricing_attributes_rec.created_by,
568: l_qp_pricing_attributes_rec.last_update_date,
569: l_qp_pricing_attributes_rec.last_updated_by,
570: l_qp_pricing_attributes_rec.last_update_login,
571: l_qp_pricing_attributes_rec.program_application_id,
572: l_qp_pricing_attributes_rec.program_id,
573: l_qp_pricing_attributes_rec.program_update_date,
574: l_qp_pricing_attributes_rec.request_id,

Line 571: l_qp_pricing_attributes_rec.program_application_id,

567: l_qp_pricing_attributes_rec.created_by,
568: l_qp_pricing_attributes_rec.last_update_date,
569: l_qp_pricing_attributes_rec.last_updated_by,
570: l_qp_pricing_attributes_rec.last_update_login,
571: l_qp_pricing_attributes_rec.program_application_id,
572: l_qp_pricing_attributes_rec.program_id,
573: l_qp_pricing_attributes_rec.program_update_date,
574: l_qp_pricing_attributes_rec.request_id,
575: l_qp_pricing_attributes_rec.list_line_id,

Line 572: l_qp_pricing_attributes_rec.program_id,

568: l_qp_pricing_attributes_rec.last_update_date,
569: l_qp_pricing_attributes_rec.last_updated_by,
570: l_qp_pricing_attributes_rec.last_update_login,
571: l_qp_pricing_attributes_rec.program_application_id,
572: l_qp_pricing_attributes_rec.program_id,
573: l_qp_pricing_attributes_rec.program_update_date,
574: l_qp_pricing_attributes_rec.request_id,
575: l_qp_pricing_attributes_rec.list_line_id,
576: l_qp_pricing_attributes_rec.list_header_id,

Line 573: l_qp_pricing_attributes_rec.program_update_date,

569: l_qp_pricing_attributes_rec.last_updated_by,
570: l_qp_pricing_attributes_rec.last_update_login,
571: l_qp_pricing_attributes_rec.program_application_id,
572: l_qp_pricing_attributes_rec.program_id,
573: l_qp_pricing_attributes_rec.program_update_date,
574: l_qp_pricing_attributes_rec.request_id,
575: l_qp_pricing_attributes_rec.list_line_id,
576: l_qp_pricing_attributes_rec.list_header_id,
577: l_qp_pricing_attributes_rec.pricing_phase_id,

Line 574: l_qp_pricing_attributes_rec.request_id,

570: l_qp_pricing_attributes_rec.last_update_login,
571: l_qp_pricing_attributes_rec.program_application_id,
572: l_qp_pricing_attributes_rec.program_id,
573: l_qp_pricing_attributes_rec.program_update_date,
574: l_qp_pricing_attributes_rec.request_id,
575: l_qp_pricing_attributes_rec.list_line_id,
576: l_qp_pricing_attributes_rec.list_header_id,
577: l_qp_pricing_attributes_rec.pricing_phase_id,
578: l_qp_pricing_attributes_rec.qualification_ind,

Line 575: l_qp_pricing_attributes_rec.list_line_id,

571: l_qp_pricing_attributes_rec.program_application_id,
572: l_qp_pricing_attributes_rec.program_id,
573: l_qp_pricing_attributes_rec.program_update_date,
574: l_qp_pricing_attributes_rec.request_id,
575: l_qp_pricing_attributes_rec.list_line_id,
576: l_qp_pricing_attributes_rec.list_header_id,
577: l_qp_pricing_attributes_rec.pricing_phase_id,
578: l_qp_pricing_attributes_rec.qualification_ind,
579: l_qp_pricing_attributes_rec.excluder_flag,

Line 576: l_qp_pricing_attributes_rec.list_header_id,

572: l_qp_pricing_attributes_rec.program_id,
573: l_qp_pricing_attributes_rec.program_update_date,
574: l_qp_pricing_attributes_rec.request_id,
575: l_qp_pricing_attributes_rec.list_line_id,
576: l_qp_pricing_attributes_rec.list_header_id,
577: l_qp_pricing_attributes_rec.pricing_phase_id,
578: l_qp_pricing_attributes_rec.qualification_ind,
579: l_qp_pricing_attributes_rec.excluder_flag,
580: l_qp_pricing_attributes_rec.accumulate_flag,

Line 577: l_qp_pricing_attributes_rec.pricing_phase_id,

573: l_qp_pricing_attributes_rec.program_update_date,
574: l_qp_pricing_attributes_rec.request_id,
575: l_qp_pricing_attributes_rec.list_line_id,
576: l_qp_pricing_attributes_rec.list_header_id,
577: l_qp_pricing_attributes_rec.pricing_phase_id,
578: l_qp_pricing_attributes_rec.qualification_ind,
579: l_qp_pricing_attributes_rec.excluder_flag,
580: l_qp_pricing_attributes_rec.accumulate_flag,
581: l_qp_pricing_attributes_rec.product_attribute_context,

Line 578: l_qp_pricing_attributes_rec.qualification_ind,

574: l_qp_pricing_attributes_rec.request_id,
575: l_qp_pricing_attributes_rec.list_line_id,
576: l_qp_pricing_attributes_rec.list_header_id,
577: l_qp_pricing_attributes_rec.pricing_phase_id,
578: l_qp_pricing_attributes_rec.qualification_ind,
579: l_qp_pricing_attributes_rec.excluder_flag,
580: l_qp_pricing_attributes_rec.accumulate_flag,
581: l_qp_pricing_attributes_rec.product_attribute_context,
582: l_qp_pricing_attributes_rec.product_attribute,

Line 579: l_qp_pricing_attributes_rec.excluder_flag,

575: l_qp_pricing_attributes_rec.list_line_id,
576: l_qp_pricing_attributes_rec.list_header_id,
577: l_qp_pricing_attributes_rec.pricing_phase_id,
578: l_qp_pricing_attributes_rec.qualification_ind,
579: l_qp_pricing_attributes_rec.excluder_flag,
580: l_qp_pricing_attributes_rec.accumulate_flag,
581: l_qp_pricing_attributes_rec.product_attribute_context,
582: l_qp_pricing_attributes_rec.product_attribute,
583: l_qp_pricing_attributes_rec.product_attr_value,

Line 580: l_qp_pricing_attributes_rec.accumulate_flag,

576: l_qp_pricing_attributes_rec.list_header_id,
577: l_qp_pricing_attributes_rec.pricing_phase_id,
578: l_qp_pricing_attributes_rec.qualification_ind,
579: l_qp_pricing_attributes_rec.excluder_flag,
580: l_qp_pricing_attributes_rec.accumulate_flag,
581: l_qp_pricing_attributes_rec.product_attribute_context,
582: l_qp_pricing_attributes_rec.product_attribute,
583: l_qp_pricing_attributes_rec.product_attr_value,
584: l_qp_pricing_attributes_rec.product_uom_code,

Line 581: l_qp_pricing_attributes_rec.product_attribute_context,

577: l_qp_pricing_attributes_rec.pricing_phase_id,
578: l_qp_pricing_attributes_rec.qualification_ind,
579: l_qp_pricing_attributes_rec.excluder_flag,
580: l_qp_pricing_attributes_rec.accumulate_flag,
581: l_qp_pricing_attributes_rec.product_attribute_context,
582: l_qp_pricing_attributes_rec.product_attribute,
583: l_qp_pricing_attributes_rec.product_attr_value,
584: l_qp_pricing_attributes_rec.product_uom_code,
585: l_qp_pricing_attributes_rec.pricing_attribute_context,

Line 582: l_qp_pricing_attributes_rec.product_attribute,

578: l_qp_pricing_attributes_rec.qualification_ind,
579: l_qp_pricing_attributes_rec.excluder_flag,
580: l_qp_pricing_attributes_rec.accumulate_flag,
581: l_qp_pricing_attributes_rec.product_attribute_context,
582: l_qp_pricing_attributes_rec.product_attribute,
583: l_qp_pricing_attributes_rec.product_attr_value,
584: l_qp_pricing_attributes_rec.product_uom_code,
585: l_qp_pricing_attributes_rec.pricing_attribute_context,
586: l_qp_pricing_attributes_rec.pricing_attribute,

Line 583: l_qp_pricing_attributes_rec.product_attr_value,

579: l_qp_pricing_attributes_rec.excluder_flag,
580: l_qp_pricing_attributes_rec.accumulate_flag,
581: l_qp_pricing_attributes_rec.product_attribute_context,
582: l_qp_pricing_attributes_rec.product_attribute,
583: l_qp_pricing_attributes_rec.product_attr_value,
584: l_qp_pricing_attributes_rec.product_uom_code,
585: l_qp_pricing_attributes_rec.pricing_attribute_context,
586: l_qp_pricing_attributes_rec.pricing_attribute,
587: l_qp_pricing_attributes_rec.pricing_attr_value_from,

Line 584: l_qp_pricing_attributes_rec.product_uom_code,

580: l_qp_pricing_attributes_rec.accumulate_flag,
581: l_qp_pricing_attributes_rec.product_attribute_context,
582: l_qp_pricing_attributes_rec.product_attribute,
583: l_qp_pricing_attributes_rec.product_attr_value,
584: l_qp_pricing_attributes_rec.product_uom_code,
585: l_qp_pricing_attributes_rec.pricing_attribute_context,
586: l_qp_pricing_attributes_rec.pricing_attribute,
587: l_qp_pricing_attributes_rec.pricing_attr_value_from,
588: l_qp_pricing_attributes_rec.pricing_attr_value_to,

Line 585: l_qp_pricing_attributes_rec.pricing_attribute_context,

581: l_qp_pricing_attributes_rec.product_attribute_context,
582: l_qp_pricing_attributes_rec.product_attribute,
583: l_qp_pricing_attributes_rec.product_attr_value,
584: l_qp_pricing_attributes_rec.product_uom_code,
585: l_qp_pricing_attributes_rec.pricing_attribute_context,
586: l_qp_pricing_attributes_rec.pricing_attribute,
587: l_qp_pricing_attributes_rec.pricing_attr_value_from,
588: l_qp_pricing_attributes_rec.pricing_attr_value_to,
589: l_qp_pricing_attributes_rec.attribute_grouping_no,

Line 586: l_qp_pricing_attributes_rec.pricing_attribute,

582: l_qp_pricing_attributes_rec.product_attribute,
583: l_qp_pricing_attributes_rec.product_attr_value,
584: l_qp_pricing_attributes_rec.product_uom_code,
585: l_qp_pricing_attributes_rec.pricing_attribute_context,
586: l_qp_pricing_attributes_rec.pricing_attribute,
587: l_qp_pricing_attributes_rec.pricing_attr_value_from,
588: l_qp_pricing_attributes_rec.pricing_attr_value_to,
589: l_qp_pricing_attributes_rec.attribute_grouping_no,
590: l_qp_pricing_attributes_rec.context,

Line 587: l_qp_pricing_attributes_rec.pricing_attr_value_from,

583: l_qp_pricing_attributes_rec.product_attr_value,
584: l_qp_pricing_attributes_rec.product_uom_code,
585: l_qp_pricing_attributes_rec.pricing_attribute_context,
586: l_qp_pricing_attributes_rec.pricing_attribute,
587: l_qp_pricing_attributes_rec.pricing_attr_value_from,
588: l_qp_pricing_attributes_rec.pricing_attr_value_to,
589: l_qp_pricing_attributes_rec.attribute_grouping_no,
590: l_qp_pricing_attributes_rec.context,
591: l_qp_pricing_attributes_rec.attribute1,

Line 588: l_qp_pricing_attributes_rec.pricing_attr_value_to,

584: l_qp_pricing_attributes_rec.product_uom_code,
585: l_qp_pricing_attributes_rec.pricing_attribute_context,
586: l_qp_pricing_attributes_rec.pricing_attribute,
587: l_qp_pricing_attributes_rec.pricing_attr_value_from,
588: l_qp_pricing_attributes_rec.pricing_attr_value_to,
589: l_qp_pricing_attributes_rec.attribute_grouping_no,
590: l_qp_pricing_attributes_rec.context,
591: l_qp_pricing_attributes_rec.attribute1,
592: l_qp_pricing_attributes_rec.attribute2,

Line 589: l_qp_pricing_attributes_rec.attribute_grouping_no,

585: l_qp_pricing_attributes_rec.pricing_attribute_context,
586: l_qp_pricing_attributes_rec.pricing_attribute,
587: l_qp_pricing_attributes_rec.pricing_attr_value_from,
588: l_qp_pricing_attributes_rec.pricing_attr_value_to,
589: l_qp_pricing_attributes_rec.attribute_grouping_no,
590: l_qp_pricing_attributes_rec.context,
591: l_qp_pricing_attributes_rec.attribute1,
592: l_qp_pricing_attributes_rec.attribute2,
593: l_qp_pricing_attributes_rec.attribute3,

Line 590: l_qp_pricing_attributes_rec.context,

586: l_qp_pricing_attributes_rec.pricing_attribute,
587: l_qp_pricing_attributes_rec.pricing_attr_value_from,
588: l_qp_pricing_attributes_rec.pricing_attr_value_to,
589: l_qp_pricing_attributes_rec.attribute_grouping_no,
590: l_qp_pricing_attributes_rec.context,
591: l_qp_pricing_attributes_rec.attribute1,
592: l_qp_pricing_attributes_rec.attribute2,
593: l_qp_pricing_attributes_rec.attribute3,
594: l_qp_pricing_attributes_rec.attribute4,

Line 591: l_qp_pricing_attributes_rec.attribute1,

587: l_qp_pricing_attributes_rec.pricing_attr_value_from,
588: l_qp_pricing_attributes_rec.pricing_attr_value_to,
589: l_qp_pricing_attributes_rec.attribute_grouping_no,
590: l_qp_pricing_attributes_rec.context,
591: l_qp_pricing_attributes_rec.attribute1,
592: l_qp_pricing_attributes_rec.attribute2,
593: l_qp_pricing_attributes_rec.attribute3,
594: l_qp_pricing_attributes_rec.attribute4,
595: l_qp_pricing_attributes_rec.attribute5,

Line 592: l_qp_pricing_attributes_rec.attribute2,

588: l_qp_pricing_attributes_rec.pricing_attr_value_to,
589: l_qp_pricing_attributes_rec.attribute_grouping_no,
590: l_qp_pricing_attributes_rec.context,
591: l_qp_pricing_attributes_rec.attribute1,
592: l_qp_pricing_attributes_rec.attribute2,
593: l_qp_pricing_attributes_rec.attribute3,
594: l_qp_pricing_attributes_rec.attribute4,
595: l_qp_pricing_attributes_rec.attribute5,
596: l_qp_pricing_attributes_rec.attribute6,

Line 593: l_qp_pricing_attributes_rec.attribute3,

589: l_qp_pricing_attributes_rec.attribute_grouping_no,
590: l_qp_pricing_attributes_rec.context,
591: l_qp_pricing_attributes_rec.attribute1,
592: l_qp_pricing_attributes_rec.attribute2,
593: l_qp_pricing_attributes_rec.attribute3,
594: l_qp_pricing_attributes_rec.attribute4,
595: l_qp_pricing_attributes_rec.attribute5,
596: l_qp_pricing_attributes_rec.attribute6,
597: l_qp_pricing_attributes_rec.attribute7,

Line 594: l_qp_pricing_attributes_rec.attribute4,

590: l_qp_pricing_attributes_rec.context,
591: l_qp_pricing_attributes_rec.attribute1,
592: l_qp_pricing_attributes_rec.attribute2,
593: l_qp_pricing_attributes_rec.attribute3,
594: l_qp_pricing_attributes_rec.attribute4,
595: l_qp_pricing_attributes_rec.attribute5,
596: l_qp_pricing_attributes_rec.attribute6,
597: l_qp_pricing_attributes_rec.attribute7,
598: l_qp_pricing_attributes_rec.attribute8,

Line 595: l_qp_pricing_attributes_rec.attribute5,

591: l_qp_pricing_attributes_rec.attribute1,
592: l_qp_pricing_attributes_rec.attribute2,
593: l_qp_pricing_attributes_rec.attribute3,
594: l_qp_pricing_attributes_rec.attribute4,
595: l_qp_pricing_attributes_rec.attribute5,
596: l_qp_pricing_attributes_rec.attribute6,
597: l_qp_pricing_attributes_rec.attribute7,
598: l_qp_pricing_attributes_rec.attribute8,
599: l_qp_pricing_attributes_rec.attribute9,

Line 596: l_qp_pricing_attributes_rec.attribute6,

592: l_qp_pricing_attributes_rec.attribute2,
593: l_qp_pricing_attributes_rec.attribute3,
594: l_qp_pricing_attributes_rec.attribute4,
595: l_qp_pricing_attributes_rec.attribute5,
596: l_qp_pricing_attributes_rec.attribute6,
597: l_qp_pricing_attributes_rec.attribute7,
598: l_qp_pricing_attributes_rec.attribute8,
599: l_qp_pricing_attributes_rec.attribute9,
600: l_qp_pricing_attributes_rec.attribute10,

Line 597: l_qp_pricing_attributes_rec.attribute7,

593: l_qp_pricing_attributes_rec.attribute3,
594: l_qp_pricing_attributes_rec.attribute4,
595: l_qp_pricing_attributes_rec.attribute5,
596: l_qp_pricing_attributes_rec.attribute6,
597: l_qp_pricing_attributes_rec.attribute7,
598: l_qp_pricing_attributes_rec.attribute8,
599: l_qp_pricing_attributes_rec.attribute9,
600: l_qp_pricing_attributes_rec.attribute10,
601: l_qp_pricing_attributes_rec.attribute11,

Line 598: l_qp_pricing_attributes_rec.attribute8,

594: l_qp_pricing_attributes_rec.attribute4,
595: l_qp_pricing_attributes_rec.attribute5,
596: l_qp_pricing_attributes_rec.attribute6,
597: l_qp_pricing_attributes_rec.attribute7,
598: l_qp_pricing_attributes_rec.attribute8,
599: l_qp_pricing_attributes_rec.attribute9,
600: l_qp_pricing_attributes_rec.attribute10,
601: l_qp_pricing_attributes_rec.attribute11,
602: l_qp_pricing_attributes_rec.attribute12,

Line 599: l_qp_pricing_attributes_rec.attribute9,

595: l_qp_pricing_attributes_rec.attribute5,
596: l_qp_pricing_attributes_rec.attribute6,
597: l_qp_pricing_attributes_rec.attribute7,
598: l_qp_pricing_attributes_rec.attribute8,
599: l_qp_pricing_attributes_rec.attribute9,
600: l_qp_pricing_attributes_rec.attribute10,
601: l_qp_pricing_attributes_rec.attribute11,
602: l_qp_pricing_attributes_rec.attribute12,
603: l_qp_pricing_attributes_rec.attribute13,

Line 600: l_qp_pricing_attributes_rec.attribute10,

596: l_qp_pricing_attributes_rec.attribute6,
597: l_qp_pricing_attributes_rec.attribute7,
598: l_qp_pricing_attributes_rec.attribute8,
599: l_qp_pricing_attributes_rec.attribute9,
600: l_qp_pricing_attributes_rec.attribute10,
601: l_qp_pricing_attributes_rec.attribute11,
602: l_qp_pricing_attributes_rec.attribute12,
603: l_qp_pricing_attributes_rec.attribute13,
604: l_qp_pricing_attributes_rec.attribute14,

Line 601: l_qp_pricing_attributes_rec.attribute11,

597: l_qp_pricing_attributes_rec.attribute7,
598: l_qp_pricing_attributes_rec.attribute8,
599: l_qp_pricing_attributes_rec.attribute9,
600: l_qp_pricing_attributes_rec.attribute10,
601: l_qp_pricing_attributes_rec.attribute11,
602: l_qp_pricing_attributes_rec.attribute12,
603: l_qp_pricing_attributes_rec.attribute13,
604: l_qp_pricing_attributes_rec.attribute14,
605: l_qp_pricing_attributes_rec.attribute15,

Line 602: l_qp_pricing_attributes_rec.attribute12,

598: l_qp_pricing_attributes_rec.attribute8,
599: l_qp_pricing_attributes_rec.attribute9,
600: l_qp_pricing_attributes_rec.attribute10,
601: l_qp_pricing_attributes_rec.attribute11,
602: l_qp_pricing_attributes_rec.attribute12,
603: l_qp_pricing_attributes_rec.attribute13,
604: l_qp_pricing_attributes_rec.attribute14,
605: l_qp_pricing_attributes_rec.attribute15,
606: l_qp_pricing_attributes_rec.product_attribute_datatype,

Line 603: l_qp_pricing_attributes_rec.attribute13,

599: l_qp_pricing_attributes_rec.attribute9,
600: l_qp_pricing_attributes_rec.attribute10,
601: l_qp_pricing_attributes_rec.attribute11,
602: l_qp_pricing_attributes_rec.attribute12,
603: l_qp_pricing_attributes_rec.attribute13,
604: l_qp_pricing_attributes_rec.attribute14,
605: l_qp_pricing_attributes_rec.attribute15,
606: l_qp_pricing_attributes_rec.product_attribute_datatype,
607: l_qp_pricing_attributes_rec.pricing_attribute_datatype,

Line 604: l_qp_pricing_attributes_rec.attribute14,

600: l_qp_pricing_attributes_rec.attribute10,
601: l_qp_pricing_attributes_rec.attribute11,
602: l_qp_pricing_attributes_rec.attribute12,
603: l_qp_pricing_attributes_rec.attribute13,
604: l_qp_pricing_attributes_rec.attribute14,
605: l_qp_pricing_attributes_rec.attribute15,
606: l_qp_pricing_attributes_rec.product_attribute_datatype,
607: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
608: l_qp_pricing_attributes_rec.comparison_operator_code,

Line 605: l_qp_pricing_attributes_rec.attribute15,

601: l_qp_pricing_attributes_rec.attribute11,
602: l_qp_pricing_attributes_rec.attribute12,
603: l_qp_pricing_attributes_rec.attribute13,
604: l_qp_pricing_attributes_rec.attribute14,
605: l_qp_pricing_attributes_rec.attribute15,
606: l_qp_pricing_attributes_rec.product_attribute_datatype,
607: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
608: l_qp_pricing_attributes_rec.comparison_operator_code,
609: l_pric_attr_value_from_number,

Line 606: l_qp_pricing_attributes_rec.product_attribute_datatype,

602: l_qp_pricing_attributes_rec.attribute12,
603: l_qp_pricing_attributes_rec.attribute13,
604: l_qp_pricing_attributes_rec.attribute14,
605: l_qp_pricing_attributes_rec.attribute15,
606: l_qp_pricing_attributes_rec.product_attribute_datatype,
607: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
608: l_qp_pricing_attributes_rec.comparison_operator_code,
609: l_pric_attr_value_from_number,
610: l_pric_attr_value_to_number,

Line 607: l_qp_pricing_attributes_rec.pricing_attribute_datatype,

603: l_qp_pricing_attributes_rec.attribute13,
604: l_qp_pricing_attributes_rec.attribute14,
605: l_qp_pricing_attributes_rec.attribute15,
606: l_qp_pricing_attributes_rec.product_attribute_datatype,
607: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
608: l_qp_pricing_attributes_rec.comparison_operator_code,
609: l_pric_attr_value_from_number,
610: l_pric_attr_value_to_number,
611: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,

Line 608: l_qp_pricing_attributes_rec.comparison_operator_code,

604: l_qp_pricing_attributes_rec.attribute14,
605: l_qp_pricing_attributes_rec.attribute15,
606: l_qp_pricing_attributes_rec.product_attribute_datatype,
607: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
608: l_qp_pricing_attributes_rec.comparison_operator_code,
609: l_pric_attr_value_from_number,
610: l_pric_attr_value_to_number,
611: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,
612: l_qp_pricing_attributes_rec.SEARCH_IND,

Line 611: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,

607: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
608: l_qp_pricing_attributes_rec.comparison_operator_code,
609: l_pric_attr_value_from_number,
610: l_pric_attr_value_to_number,
611: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,
612: l_qp_pricing_attributes_rec.SEARCH_IND,
613: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,
614: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
615: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,

Line 612: l_qp_pricing_attributes_rec.SEARCH_IND,

608: l_qp_pricing_attributes_rec.comparison_operator_code,
609: l_pric_attr_value_from_number,
610: l_pric_attr_value_to_number,
611: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,
612: l_qp_pricing_attributes_rec.SEARCH_IND,
613: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,
614: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
615: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,
616: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,

Line 613: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,

609: l_pric_attr_value_from_number,
610: l_pric_attr_value_to_number,
611: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,
612: l_qp_pricing_attributes_rec.SEARCH_IND,
613: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,
614: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
615: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,
616: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,
617: l_qp_pricing_attributes_rec.PRODUCT_SEGMENT_ID,

Line 614: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,

610: l_pric_attr_value_to_number,
611: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,
612: l_qp_pricing_attributes_rec.SEARCH_IND,
613: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,
614: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
615: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,
616: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,
617: l_qp_pricing_attributes_rec.PRODUCT_SEGMENT_ID,
618: l_qp_pricing_attributes_rec.PRICING_SEGMENT_ID,

Line 615: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,

611: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,
612: l_qp_pricing_attributes_rec.SEARCH_IND,
613: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,
614: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
615: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,
616: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,
617: l_qp_pricing_attributes_rec.PRODUCT_SEGMENT_ID,
618: l_qp_pricing_attributes_rec.PRICING_SEGMENT_ID,
619: p_conc_request_id

Line 616: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,

612: l_qp_pricing_attributes_rec.SEARCH_IND,
613: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,
614: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
615: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,
616: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,
617: l_qp_pricing_attributes_rec.PRODUCT_SEGMENT_ID,
618: l_qp_pricing_attributes_rec.PRICING_SEGMENT_ID,
619: p_conc_request_id
620: );

Line 617: l_qp_pricing_attributes_rec.PRODUCT_SEGMENT_ID,

613: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,
614: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
615: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,
616: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,
617: l_qp_pricing_attributes_rec.PRODUCT_SEGMENT_ID,
618: l_qp_pricing_attributes_rec.PRICING_SEGMENT_ID,
619: p_conc_request_id
620: );
621: g_count_pricing_att := g_count_pricing_att + sql%rowcount;

Line 618: l_qp_pricing_attributes_rec.PRICING_SEGMENT_ID,

614: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
615: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,
616: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,
617: l_qp_pricing_attributes_rec.PRODUCT_SEGMENT_ID,
618: l_qp_pricing_attributes_rec.PRICING_SEGMENT_ID,
619: p_conc_request_id
620: );
621: g_count_pricing_att := g_count_pricing_att + sql%rowcount;
622:

Line 623: --Delete the records from qp_pricing_attributes table

619: p_conc_request_id
620: );
621: g_count_pricing_att := g_count_pricing_att + sql%rowcount;
622:
623: --Delete the records from qp_pricing_attributes table
624:
625: DELETE FROM QP_PRICING_ATTRIBUTES WHERE pricing_attribute_id = l_qp_pricing_attributes_rec.pricing_attribute_id
626: and list_line_id = l_qp_pricing_attributes_rec.list_line_id
627: and list_header_id = l_qp_pricing_attributes_rec.list_header_id;

Line 625: DELETE FROM QP_PRICING_ATTRIBUTES WHERE pricing_attribute_id = l_qp_pricing_attributes_rec.pricing_attribute_id

621: g_count_pricing_att := g_count_pricing_att + sql%rowcount;
622:
623: --Delete the records from qp_pricing_attributes table
624:
625: DELETE FROM QP_PRICING_ATTRIBUTES WHERE pricing_attribute_id = l_qp_pricing_attributes_rec.pricing_attribute_id
626: and list_line_id = l_qp_pricing_attributes_rec.list_line_id
627: and list_header_id = l_qp_pricing_attributes_rec.list_header_id;
628:
629: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */

Line 626: and list_line_id = l_qp_pricing_attributes_rec.list_line_id

622:
623: --Delete the records from qp_pricing_attributes table
624:
625: DELETE FROM QP_PRICING_ATTRIBUTES WHERE pricing_attribute_id = l_qp_pricing_attributes_rec.pricing_attribute_id
626: and list_line_id = l_qp_pricing_attributes_rec.list_line_id
627: and list_header_id = l_qp_pricing_attributes_rec.list_header_id;
628:
629: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
630:

Line 627: and list_header_id = l_qp_pricing_attributes_rec.list_header_id;

623: --Delete the records from qp_pricing_attributes table
624:
625: DELETE FROM QP_PRICING_ATTRIBUTES WHERE pricing_attribute_id = l_qp_pricing_attributes_rec.pricing_attribute_id
626: and list_line_id = l_qp_pricing_attributes_rec.list_line_id
627: and list_header_id = l_qp_pricing_attributes_rec.list_header_id;
628:
629: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
630:
631: END DELETE_CHILD;

Line 629: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */

625: DELETE FROM QP_PRICING_ATTRIBUTES WHERE pricing_attribute_id = l_qp_pricing_attributes_rec.pricing_attribute_id
626: and list_line_id = l_qp_pricing_attributes_rec.list_line_id
627: and list_header_id = l_qp_pricing_attributes_rec.list_header_id;
628:
629: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
630:
631: END DELETE_CHILD;
632:
633:

Line 812: CURSOR qp_pricing_attributes_cur(p_from_list_line_id NUMBER)

808:
809: TYPE lines_cur_typ IS REF CURSOR;
810: qp_list_lines_cv lines_cur_typ;
811:
812: CURSOR qp_pricing_attributes_cur(p_from_list_line_id NUMBER)
813: IS
814: SELECT *
815: FROM qp_pricing_attributes
816: WHERE list_line_id = p_from_list_line_id;

Line 815: FROM qp_pricing_attributes

811:
812: CURSOR qp_pricing_attributes_cur(p_from_list_line_id NUMBER)
813: IS
814: SELECT *
815: FROM qp_pricing_attributes
816: WHERE list_line_id = p_from_list_line_id;
817:
818: CURSOR qp_headers_qualifiers_cur(p_from_discount_header_id NUMBER)
819: IS

Line 994: FROM qp_pricing_attributes a

990: IF nvl(p_all_lines,'N') = 'N' THEN
991: IF p_product_context is not NULL THEN
992: l_select_stmt := l_select_stmt || 'AND q.list_line_id IN
993: (SELECT DISTINCT a.list_line_id
994: FROM qp_pricing_attributes a
995: WHERE a.list_line_id = q.list_line_id
996: and EXCLUDER_FLAG =''N'''; --This would take care of Exculded Items.
997:
998: IF p_product_attribute = 'PRICING_ATTRIBUTE1' THEN

Line 1237: FROM qp_pricing_attributes a

1233: END IF; --Pricing Attribute end
1234: ELSE --Product_context is null
1235: -- changed the not in condition to in for the bug 7315038
1236: l_select_stmt := l_select_stmt || 'AND q.list_line_id in (SELECT DISTINCT a.list_line_id
1237: FROM qp_pricing_attributes a
1238: WHERE a.list_line_id = q.list_line_id)';
1239: END IF; -- Product_context end
1240: ELSE
1241: l_select_stmt := l_select_stmt || 'AND q.list_line_id not in (SELECT DISTINCT a.to_rltd_modifier_id

Line 2113: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (l_qp_list_lines_rec.list_line_id) LOOP

2109: END IF;
2110: END IF; -- List type code end
2111:
2112: /* Archive List lines pricing attributes */
2113: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (l_qp_list_lines_rec.list_line_id) LOOP
2114: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N' then
2115: BEGIN
2116: l_pric_attr_value_from_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
2117: l_pric_attr_value_to_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);

Line 2114: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N' then

2110: END IF; -- List type code end
2111:
2112: /* Archive List lines pricing attributes */
2113: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (l_qp_list_lines_rec.list_line_id) LOOP
2114: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N' then
2115: BEGIN
2116: l_pric_attr_value_from_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
2117: l_pric_attr_value_to_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
2118: EXCEPTION

Line 2116: l_pric_attr_value_from_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);

2112: /* Archive List lines pricing attributes */
2113: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (l_qp_list_lines_rec.list_line_id) LOOP
2114: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N' then
2115: BEGIN
2116: l_pric_attr_value_from_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
2117: l_pric_attr_value_to_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
2118: EXCEPTION
2119: WHEN VALUE_ERROR THEN
2120: NULL;

Line 2117: l_pric_attr_value_to_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);

2113: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (l_qp_list_lines_rec.list_line_id) LOOP
2114: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N' then
2115: BEGIN
2116: l_pric_attr_value_from_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
2117: l_pric_attr_value_to_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
2118: EXCEPTION
2119: WHEN VALUE_ERROR THEN
2120: NULL;
2121: WHEN OTHERS THEN

Line 2187: l_qp_pricing_attributes_rec.pricing_attribute_id,

2183: ARCH_PURG_REQUEST_ID
2184: )
2185: VALUES
2186: (
2187: l_qp_pricing_attributes_rec.pricing_attribute_id,
2188: l_qp_pricing_attributes_rec.creation_date,
2189: l_qp_pricing_attributes_rec.created_by,
2190: l_qp_pricing_attributes_rec.last_update_date,
2191: l_qp_pricing_attributes_rec.last_updated_by,

Line 2188: l_qp_pricing_attributes_rec.creation_date,

2184: )
2185: VALUES
2186: (
2187: l_qp_pricing_attributes_rec.pricing_attribute_id,
2188: l_qp_pricing_attributes_rec.creation_date,
2189: l_qp_pricing_attributes_rec.created_by,
2190: l_qp_pricing_attributes_rec.last_update_date,
2191: l_qp_pricing_attributes_rec.last_updated_by,
2192: l_qp_pricing_attributes_rec.last_update_login,

Line 2189: l_qp_pricing_attributes_rec.created_by,

2185: VALUES
2186: (
2187: l_qp_pricing_attributes_rec.pricing_attribute_id,
2188: l_qp_pricing_attributes_rec.creation_date,
2189: l_qp_pricing_attributes_rec.created_by,
2190: l_qp_pricing_attributes_rec.last_update_date,
2191: l_qp_pricing_attributes_rec.last_updated_by,
2192: l_qp_pricing_attributes_rec.last_update_login,
2193: l_qp_pricing_attributes_rec.program_application_id,

Line 2190: l_qp_pricing_attributes_rec.last_update_date,

2186: (
2187: l_qp_pricing_attributes_rec.pricing_attribute_id,
2188: l_qp_pricing_attributes_rec.creation_date,
2189: l_qp_pricing_attributes_rec.created_by,
2190: l_qp_pricing_attributes_rec.last_update_date,
2191: l_qp_pricing_attributes_rec.last_updated_by,
2192: l_qp_pricing_attributes_rec.last_update_login,
2193: l_qp_pricing_attributes_rec.program_application_id,
2194: l_qp_pricing_attributes_rec.program_id,

Line 2191: l_qp_pricing_attributes_rec.last_updated_by,

2187: l_qp_pricing_attributes_rec.pricing_attribute_id,
2188: l_qp_pricing_attributes_rec.creation_date,
2189: l_qp_pricing_attributes_rec.created_by,
2190: l_qp_pricing_attributes_rec.last_update_date,
2191: l_qp_pricing_attributes_rec.last_updated_by,
2192: l_qp_pricing_attributes_rec.last_update_login,
2193: l_qp_pricing_attributes_rec.program_application_id,
2194: l_qp_pricing_attributes_rec.program_id,
2195: l_qp_pricing_attributes_rec.program_update_date,

Line 2192: l_qp_pricing_attributes_rec.last_update_login,

2188: l_qp_pricing_attributes_rec.creation_date,
2189: l_qp_pricing_attributes_rec.created_by,
2190: l_qp_pricing_attributes_rec.last_update_date,
2191: l_qp_pricing_attributes_rec.last_updated_by,
2192: l_qp_pricing_attributes_rec.last_update_login,
2193: l_qp_pricing_attributes_rec.program_application_id,
2194: l_qp_pricing_attributes_rec.program_id,
2195: l_qp_pricing_attributes_rec.program_update_date,
2196: l_qp_pricing_attributes_rec.request_id,

Line 2193: l_qp_pricing_attributes_rec.program_application_id,

2189: l_qp_pricing_attributes_rec.created_by,
2190: l_qp_pricing_attributes_rec.last_update_date,
2191: l_qp_pricing_attributes_rec.last_updated_by,
2192: l_qp_pricing_attributes_rec.last_update_login,
2193: l_qp_pricing_attributes_rec.program_application_id,
2194: l_qp_pricing_attributes_rec.program_id,
2195: l_qp_pricing_attributes_rec.program_update_date,
2196: l_qp_pricing_attributes_rec.request_id,
2197: l_qp_list_lines_rec.list_line_id,

Line 2194: l_qp_pricing_attributes_rec.program_id,

2190: l_qp_pricing_attributes_rec.last_update_date,
2191: l_qp_pricing_attributes_rec.last_updated_by,
2192: l_qp_pricing_attributes_rec.last_update_login,
2193: l_qp_pricing_attributes_rec.program_application_id,
2194: l_qp_pricing_attributes_rec.program_id,
2195: l_qp_pricing_attributes_rec.program_update_date,
2196: l_qp_pricing_attributes_rec.request_id,
2197: l_qp_list_lines_rec.list_line_id,
2198: p_entity,

Line 2195: l_qp_pricing_attributes_rec.program_update_date,

2191: l_qp_pricing_attributes_rec.last_updated_by,
2192: l_qp_pricing_attributes_rec.last_update_login,
2193: l_qp_pricing_attributes_rec.program_application_id,
2194: l_qp_pricing_attributes_rec.program_id,
2195: l_qp_pricing_attributes_rec.program_update_date,
2196: l_qp_pricing_attributes_rec.request_id,
2197: l_qp_list_lines_rec.list_line_id,
2198: p_entity,
2199: l_qp_pricing_attributes_rec.pricing_phase_id,

Line 2196: l_qp_pricing_attributes_rec.request_id,

2192: l_qp_pricing_attributes_rec.last_update_login,
2193: l_qp_pricing_attributes_rec.program_application_id,
2194: l_qp_pricing_attributes_rec.program_id,
2195: l_qp_pricing_attributes_rec.program_update_date,
2196: l_qp_pricing_attributes_rec.request_id,
2197: l_qp_list_lines_rec.list_line_id,
2198: p_entity,
2199: l_qp_pricing_attributes_rec.pricing_phase_id,
2200: l_qp_pricing_attributes_rec.qualification_ind,

Line 2199: l_qp_pricing_attributes_rec.pricing_phase_id,

2195: l_qp_pricing_attributes_rec.program_update_date,
2196: l_qp_pricing_attributes_rec.request_id,
2197: l_qp_list_lines_rec.list_line_id,
2198: p_entity,
2199: l_qp_pricing_attributes_rec.pricing_phase_id,
2200: l_qp_pricing_attributes_rec.qualification_ind,
2201: l_qp_pricing_attributes_rec.excluder_flag,
2202: l_qp_pricing_attributes_rec.accumulate_flag,
2203: l_qp_pricing_attributes_rec.product_attribute_context,

Line 2200: l_qp_pricing_attributes_rec.qualification_ind,

2196: l_qp_pricing_attributes_rec.request_id,
2197: l_qp_list_lines_rec.list_line_id,
2198: p_entity,
2199: l_qp_pricing_attributes_rec.pricing_phase_id,
2200: l_qp_pricing_attributes_rec.qualification_ind,
2201: l_qp_pricing_attributes_rec.excluder_flag,
2202: l_qp_pricing_attributes_rec.accumulate_flag,
2203: l_qp_pricing_attributes_rec.product_attribute_context,
2204: l_qp_pricing_attributes_rec.product_attribute,

Line 2201: l_qp_pricing_attributes_rec.excluder_flag,

2197: l_qp_list_lines_rec.list_line_id,
2198: p_entity,
2199: l_qp_pricing_attributes_rec.pricing_phase_id,
2200: l_qp_pricing_attributes_rec.qualification_ind,
2201: l_qp_pricing_attributes_rec.excluder_flag,
2202: l_qp_pricing_attributes_rec.accumulate_flag,
2203: l_qp_pricing_attributes_rec.product_attribute_context,
2204: l_qp_pricing_attributes_rec.product_attribute,
2205: l_qp_pricing_attributes_rec.product_attr_value,

Line 2202: l_qp_pricing_attributes_rec.accumulate_flag,

2198: p_entity,
2199: l_qp_pricing_attributes_rec.pricing_phase_id,
2200: l_qp_pricing_attributes_rec.qualification_ind,
2201: l_qp_pricing_attributes_rec.excluder_flag,
2202: l_qp_pricing_attributes_rec.accumulate_flag,
2203: l_qp_pricing_attributes_rec.product_attribute_context,
2204: l_qp_pricing_attributes_rec.product_attribute,
2205: l_qp_pricing_attributes_rec.product_attr_value,
2206: l_qp_pricing_attributes_rec.product_uom_code,

Line 2203: l_qp_pricing_attributes_rec.product_attribute_context,

2199: l_qp_pricing_attributes_rec.pricing_phase_id,
2200: l_qp_pricing_attributes_rec.qualification_ind,
2201: l_qp_pricing_attributes_rec.excluder_flag,
2202: l_qp_pricing_attributes_rec.accumulate_flag,
2203: l_qp_pricing_attributes_rec.product_attribute_context,
2204: l_qp_pricing_attributes_rec.product_attribute,
2205: l_qp_pricing_attributes_rec.product_attr_value,
2206: l_qp_pricing_attributes_rec.product_uom_code,
2207: l_qp_pricing_attributes_rec.pricing_attribute_context,

Line 2204: l_qp_pricing_attributes_rec.product_attribute,

2200: l_qp_pricing_attributes_rec.qualification_ind,
2201: l_qp_pricing_attributes_rec.excluder_flag,
2202: l_qp_pricing_attributes_rec.accumulate_flag,
2203: l_qp_pricing_attributes_rec.product_attribute_context,
2204: l_qp_pricing_attributes_rec.product_attribute,
2205: l_qp_pricing_attributes_rec.product_attr_value,
2206: l_qp_pricing_attributes_rec.product_uom_code,
2207: l_qp_pricing_attributes_rec.pricing_attribute_context,
2208: l_qp_pricing_attributes_rec.pricing_attribute,

Line 2205: l_qp_pricing_attributes_rec.product_attr_value,

2201: l_qp_pricing_attributes_rec.excluder_flag,
2202: l_qp_pricing_attributes_rec.accumulate_flag,
2203: l_qp_pricing_attributes_rec.product_attribute_context,
2204: l_qp_pricing_attributes_rec.product_attribute,
2205: l_qp_pricing_attributes_rec.product_attr_value,
2206: l_qp_pricing_attributes_rec.product_uom_code,
2207: l_qp_pricing_attributes_rec.pricing_attribute_context,
2208: l_qp_pricing_attributes_rec.pricing_attribute,
2209: l_qp_pricing_attributes_rec.pricing_attr_value_from,

Line 2206: l_qp_pricing_attributes_rec.product_uom_code,

2202: l_qp_pricing_attributes_rec.accumulate_flag,
2203: l_qp_pricing_attributes_rec.product_attribute_context,
2204: l_qp_pricing_attributes_rec.product_attribute,
2205: l_qp_pricing_attributes_rec.product_attr_value,
2206: l_qp_pricing_attributes_rec.product_uom_code,
2207: l_qp_pricing_attributes_rec.pricing_attribute_context,
2208: l_qp_pricing_attributes_rec.pricing_attribute,
2209: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2210: l_qp_pricing_attributes_rec.pricing_attr_value_to,

Line 2207: l_qp_pricing_attributes_rec.pricing_attribute_context,

2203: l_qp_pricing_attributes_rec.product_attribute_context,
2204: l_qp_pricing_attributes_rec.product_attribute,
2205: l_qp_pricing_attributes_rec.product_attr_value,
2206: l_qp_pricing_attributes_rec.product_uom_code,
2207: l_qp_pricing_attributes_rec.pricing_attribute_context,
2208: l_qp_pricing_attributes_rec.pricing_attribute,
2209: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2210: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2211: l_qp_pricing_attributes_rec.attribute_grouping_no,

Line 2208: l_qp_pricing_attributes_rec.pricing_attribute,

2204: l_qp_pricing_attributes_rec.product_attribute,
2205: l_qp_pricing_attributes_rec.product_attr_value,
2206: l_qp_pricing_attributes_rec.product_uom_code,
2207: l_qp_pricing_attributes_rec.pricing_attribute_context,
2208: l_qp_pricing_attributes_rec.pricing_attribute,
2209: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2210: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2211: l_qp_pricing_attributes_rec.attribute_grouping_no,
2212: l_qp_pricing_attributes_rec.context,

Line 2209: l_qp_pricing_attributes_rec.pricing_attr_value_from,

2205: l_qp_pricing_attributes_rec.product_attr_value,
2206: l_qp_pricing_attributes_rec.product_uom_code,
2207: l_qp_pricing_attributes_rec.pricing_attribute_context,
2208: l_qp_pricing_attributes_rec.pricing_attribute,
2209: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2210: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2211: l_qp_pricing_attributes_rec.attribute_grouping_no,
2212: l_qp_pricing_attributes_rec.context,
2213: l_qp_pricing_attributes_rec.attribute1,

Line 2210: l_qp_pricing_attributes_rec.pricing_attr_value_to,

2206: l_qp_pricing_attributes_rec.product_uom_code,
2207: l_qp_pricing_attributes_rec.pricing_attribute_context,
2208: l_qp_pricing_attributes_rec.pricing_attribute,
2209: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2210: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2211: l_qp_pricing_attributes_rec.attribute_grouping_no,
2212: l_qp_pricing_attributes_rec.context,
2213: l_qp_pricing_attributes_rec.attribute1,
2214: l_qp_pricing_attributes_rec.attribute2,

Line 2211: l_qp_pricing_attributes_rec.attribute_grouping_no,

2207: l_qp_pricing_attributes_rec.pricing_attribute_context,
2208: l_qp_pricing_attributes_rec.pricing_attribute,
2209: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2210: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2211: l_qp_pricing_attributes_rec.attribute_grouping_no,
2212: l_qp_pricing_attributes_rec.context,
2213: l_qp_pricing_attributes_rec.attribute1,
2214: l_qp_pricing_attributes_rec.attribute2,
2215: l_qp_pricing_attributes_rec.attribute3,

Line 2212: l_qp_pricing_attributes_rec.context,

2208: l_qp_pricing_attributes_rec.pricing_attribute,
2209: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2210: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2211: l_qp_pricing_attributes_rec.attribute_grouping_no,
2212: l_qp_pricing_attributes_rec.context,
2213: l_qp_pricing_attributes_rec.attribute1,
2214: l_qp_pricing_attributes_rec.attribute2,
2215: l_qp_pricing_attributes_rec.attribute3,
2216: l_qp_pricing_attributes_rec.attribute4,

Line 2213: l_qp_pricing_attributes_rec.attribute1,

2209: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2210: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2211: l_qp_pricing_attributes_rec.attribute_grouping_no,
2212: l_qp_pricing_attributes_rec.context,
2213: l_qp_pricing_attributes_rec.attribute1,
2214: l_qp_pricing_attributes_rec.attribute2,
2215: l_qp_pricing_attributes_rec.attribute3,
2216: l_qp_pricing_attributes_rec.attribute4,
2217: l_qp_pricing_attributes_rec.attribute5,

Line 2214: l_qp_pricing_attributes_rec.attribute2,

2210: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2211: l_qp_pricing_attributes_rec.attribute_grouping_no,
2212: l_qp_pricing_attributes_rec.context,
2213: l_qp_pricing_attributes_rec.attribute1,
2214: l_qp_pricing_attributes_rec.attribute2,
2215: l_qp_pricing_attributes_rec.attribute3,
2216: l_qp_pricing_attributes_rec.attribute4,
2217: l_qp_pricing_attributes_rec.attribute5,
2218: l_qp_pricing_attributes_rec.attribute6,

Line 2215: l_qp_pricing_attributes_rec.attribute3,

2211: l_qp_pricing_attributes_rec.attribute_grouping_no,
2212: l_qp_pricing_attributes_rec.context,
2213: l_qp_pricing_attributes_rec.attribute1,
2214: l_qp_pricing_attributes_rec.attribute2,
2215: l_qp_pricing_attributes_rec.attribute3,
2216: l_qp_pricing_attributes_rec.attribute4,
2217: l_qp_pricing_attributes_rec.attribute5,
2218: l_qp_pricing_attributes_rec.attribute6,
2219: l_qp_pricing_attributes_rec.attribute7,

Line 2216: l_qp_pricing_attributes_rec.attribute4,

2212: l_qp_pricing_attributes_rec.context,
2213: l_qp_pricing_attributes_rec.attribute1,
2214: l_qp_pricing_attributes_rec.attribute2,
2215: l_qp_pricing_attributes_rec.attribute3,
2216: l_qp_pricing_attributes_rec.attribute4,
2217: l_qp_pricing_attributes_rec.attribute5,
2218: l_qp_pricing_attributes_rec.attribute6,
2219: l_qp_pricing_attributes_rec.attribute7,
2220: l_qp_pricing_attributes_rec.attribute8,

Line 2217: l_qp_pricing_attributes_rec.attribute5,

2213: l_qp_pricing_attributes_rec.attribute1,
2214: l_qp_pricing_attributes_rec.attribute2,
2215: l_qp_pricing_attributes_rec.attribute3,
2216: l_qp_pricing_attributes_rec.attribute4,
2217: l_qp_pricing_attributes_rec.attribute5,
2218: l_qp_pricing_attributes_rec.attribute6,
2219: l_qp_pricing_attributes_rec.attribute7,
2220: l_qp_pricing_attributes_rec.attribute8,
2221: l_qp_pricing_attributes_rec.attribute9,

Line 2218: l_qp_pricing_attributes_rec.attribute6,

2214: l_qp_pricing_attributes_rec.attribute2,
2215: l_qp_pricing_attributes_rec.attribute3,
2216: l_qp_pricing_attributes_rec.attribute4,
2217: l_qp_pricing_attributes_rec.attribute5,
2218: l_qp_pricing_attributes_rec.attribute6,
2219: l_qp_pricing_attributes_rec.attribute7,
2220: l_qp_pricing_attributes_rec.attribute8,
2221: l_qp_pricing_attributes_rec.attribute9,
2222: l_qp_pricing_attributes_rec.attribute10,

Line 2219: l_qp_pricing_attributes_rec.attribute7,

2215: l_qp_pricing_attributes_rec.attribute3,
2216: l_qp_pricing_attributes_rec.attribute4,
2217: l_qp_pricing_attributes_rec.attribute5,
2218: l_qp_pricing_attributes_rec.attribute6,
2219: l_qp_pricing_attributes_rec.attribute7,
2220: l_qp_pricing_attributes_rec.attribute8,
2221: l_qp_pricing_attributes_rec.attribute9,
2222: l_qp_pricing_attributes_rec.attribute10,
2223: l_qp_pricing_attributes_rec.attribute11,

Line 2220: l_qp_pricing_attributes_rec.attribute8,

2216: l_qp_pricing_attributes_rec.attribute4,
2217: l_qp_pricing_attributes_rec.attribute5,
2218: l_qp_pricing_attributes_rec.attribute6,
2219: l_qp_pricing_attributes_rec.attribute7,
2220: l_qp_pricing_attributes_rec.attribute8,
2221: l_qp_pricing_attributes_rec.attribute9,
2222: l_qp_pricing_attributes_rec.attribute10,
2223: l_qp_pricing_attributes_rec.attribute11,
2224: l_qp_pricing_attributes_rec.attribute12,

Line 2221: l_qp_pricing_attributes_rec.attribute9,

2217: l_qp_pricing_attributes_rec.attribute5,
2218: l_qp_pricing_attributes_rec.attribute6,
2219: l_qp_pricing_attributes_rec.attribute7,
2220: l_qp_pricing_attributes_rec.attribute8,
2221: l_qp_pricing_attributes_rec.attribute9,
2222: l_qp_pricing_attributes_rec.attribute10,
2223: l_qp_pricing_attributes_rec.attribute11,
2224: l_qp_pricing_attributes_rec.attribute12,
2225: l_qp_pricing_attributes_rec.attribute13,

Line 2222: l_qp_pricing_attributes_rec.attribute10,

2218: l_qp_pricing_attributes_rec.attribute6,
2219: l_qp_pricing_attributes_rec.attribute7,
2220: l_qp_pricing_attributes_rec.attribute8,
2221: l_qp_pricing_attributes_rec.attribute9,
2222: l_qp_pricing_attributes_rec.attribute10,
2223: l_qp_pricing_attributes_rec.attribute11,
2224: l_qp_pricing_attributes_rec.attribute12,
2225: l_qp_pricing_attributes_rec.attribute13,
2226: l_qp_pricing_attributes_rec.attribute14,

Line 2223: l_qp_pricing_attributes_rec.attribute11,

2219: l_qp_pricing_attributes_rec.attribute7,
2220: l_qp_pricing_attributes_rec.attribute8,
2221: l_qp_pricing_attributes_rec.attribute9,
2222: l_qp_pricing_attributes_rec.attribute10,
2223: l_qp_pricing_attributes_rec.attribute11,
2224: l_qp_pricing_attributes_rec.attribute12,
2225: l_qp_pricing_attributes_rec.attribute13,
2226: l_qp_pricing_attributes_rec.attribute14,
2227: l_qp_pricing_attributes_rec.attribute15,

Line 2224: l_qp_pricing_attributes_rec.attribute12,

2220: l_qp_pricing_attributes_rec.attribute8,
2221: l_qp_pricing_attributes_rec.attribute9,
2222: l_qp_pricing_attributes_rec.attribute10,
2223: l_qp_pricing_attributes_rec.attribute11,
2224: l_qp_pricing_attributes_rec.attribute12,
2225: l_qp_pricing_attributes_rec.attribute13,
2226: l_qp_pricing_attributes_rec.attribute14,
2227: l_qp_pricing_attributes_rec.attribute15,
2228: l_qp_pricing_attributes_rec.product_attribute_datatype,

Line 2225: l_qp_pricing_attributes_rec.attribute13,

2221: l_qp_pricing_attributes_rec.attribute9,
2222: l_qp_pricing_attributes_rec.attribute10,
2223: l_qp_pricing_attributes_rec.attribute11,
2224: l_qp_pricing_attributes_rec.attribute12,
2225: l_qp_pricing_attributes_rec.attribute13,
2226: l_qp_pricing_attributes_rec.attribute14,
2227: l_qp_pricing_attributes_rec.attribute15,
2228: l_qp_pricing_attributes_rec.product_attribute_datatype,
2229: l_qp_pricing_attributes_rec.pricing_attribute_datatype,

Line 2226: l_qp_pricing_attributes_rec.attribute14,

2222: l_qp_pricing_attributes_rec.attribute10,
2223: l_qp_pricing_attributes_rec.attribute11,
2224: l_qp_pricing_attributes_rec.attribute12,
2225: l_qp_pricing_attributes_rec.attribute13,
2226: l_qp_pricing_attributes_rec.attribute14,
2227: l_qp_pricing_attributes_rec.attribute15,
2228: l_qp_pricing_attributes_rec.product_attribute_datatype,
2229: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
2230: l_qp_pricing_attributes_rec.comparison_operator_code,

Line 2227: l_qp_pricing_attributes_rec.attribute15,

2223: l_qp_pricing_attributes_rec.attribute11,
2224: l_qp_pricing_attributes_rec.attribute12,
2225: l_qp_pricing_attributes_rec.attribute13,
2226: l_qp_pricing_attributes_rec.attribute14,
2227: l_qp_pricing_attributes_rec.attribute15,
2228: l_qp_pricing_attributes_rec.product_attribute_datatype,
2229: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
2230: l_qp_pricing_attributes_rec.comparison_operator_code,
2231: l_pric_attr_value_from_number,

Line 2228: l_qp_pricing_attributes_rec.product_attribute_datatype,

2224: l_qp_pricing_attributes_rec.attribute12,
2225: l_qp_pricing_attributes_rec.attribute13,
2226: l_qp_pricing_attributes_rec.attribute14,
2227: l_qp_pricing_attributes_rec.attribute15,
2228: l_qp_pricing_attributes_rec.product_attribute_datatype,
2229: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
2230: l_qp_pricing_attributes_rec.comparison_operator_code,
2231: l_pric_attr_value_from_number,
2232: l_pric_attr_value_to_number,

Line 2229: l_qp_pricing_attributes_rec.pricing_attribute_datatype,

2225: l_qp_pricing_attributes_rec.attribute13,
2226: l_qp_pricing_attributes_rec.attribute14,
2227: l_qp_pricing_attributes_rec.attribute15,
2228: l_qp_pricing_attributes_rec.product_attribute_datatype,
2229: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
2230: l_qp_pricing_attributes_rec.comparison_operator_code,
2231: l_pric_attr_value_from_number,
2232: l_pric_attr_value_to_number,
2233: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,

Line 2230: l_qp_pricing_attributes_rec.comparison_operator_code,

2226: l_qp_pricing_attributes_rec.attribute14,
2227: l_qp_pricing_attributes_rec.attribute15,
2228: l_qp_pricing_attributes_rec.product_attribute_datatype,
2229: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
2230: l_qp_pricing_attributes_rec.comparison_operator_code,
2231: l_pric_attr_value_from_number,
2232: l_pric_attr_value_to_number,
2233: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,
2234: l_qp_pricing_attributes_rec.SEARCH_IND,

Line 2233: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,

2229: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
2230: l_qp_pricing_attributes_rec.comparison_operator_code,
2231: l_pric_attr_value_from_number,
2232: l_pric_attr_value_to_number,
2233: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,
2234: l_qp_pricing_attributes_rec.SEARCH_IND,
2235: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,
2236: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
2237: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,

Line 2234: l_qp_pricing_attributes_rec.SEARCH_IND,

2230: l_qp_pricing_attributes_rec.comparison_operator_code,
2231: l_pric_attr_value_from_number,
2232: l_pric_attr_value_to_number,
2233: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,
2234: l_qp_pricing_attributes_rec.SEARCH_IND,
2235: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,
2236: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
2237: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,
2238: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,

Line 2235: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,

2231: l_pric_attr_value_from_number,
2232: l_pric_attr_value_to_number,
2233: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,
2234: l_qp_pricing_attributes_rec.SEARCH_IND,
2235: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,
2236: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
2237: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,
2238: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,
2239: l_qp_pricing_attributes_rec.PRODUCT_SEGMENT_ID,

Line 2236: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,

2232: l_pric_attr_value_to_number,
2233: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,
2234: l_qp_pricing_attributes_rec.SEARCH_IND,
2235: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,
2236: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
2237: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,
2238: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,
2239: l_qp_pricing_attributes_rec.PRODUCT_SEGMENT_ID,
2240: l_qp_pricing_attributes_rec.PRICING_SEGMENT_ID,

Line 2237: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,

2233: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,
2234: l_qp_pricing_attributes_rec.SEARCH_IND,
2235: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,
2236: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
2237: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,
2238: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,
2239: l_qp_pricing_attributes_rec.PRODUCT_SEGMENT_ID,
2240: l_qp_pricing_attributes_rec.PRICING_SEGMENT_ID,
2241: l_conc_request_id

Line 2238: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,

2234: l_qp_pricing_attributes_rec.SEARCH_IND,
2235: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,
2236: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
2237: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,
2238: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,
2239: l_qp_pricing_attributes_rec.PRODUCT_SEGMENT_ID,
2240: l_qp_pricing_attributes_rec.PRICING_SEGMENT_ID,
2241: l_conc_request_id
2242: );

Line 2239: l_qp_pricing_attributes_rec.PRODUCT_SEGMENT_ID,

2235: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,
2236: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
2237: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,
2238: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,
2239: l_qp_pricing_attributes_rec.PRODUCT_SEGMENT_ID,
2240: l_qp_pricing_attributes_rec.PRICING_SEGMENT_ID,
2241: l_conc_request_id
2242: );
2243:

Line 2240: l_qp_pricing_attributes_rec.PRICING_SEGMENT_ID,

2236: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
2237: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,
2238: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,
2239: l_qp_pricing_attributes_rec.PRODUCT_SEGMENT_ID,
2240: l_qp_pricing_attributes_rec.PRICING_SEGMENT_ID,
2241: l_conc_request_id
2242: );
2243:
2244: g_count_pricing_att := g_count_pricing_att + sql%rowcount;

Line 2246: DELETE FROM qp_pricing_attributes

2242: );
2243:
2244: g_count_pricing_att := g_count_pricing_att + sql%rowcount;
2245:
2246: DELETE FROM qp_pricing_attributes
2247: WHERE pricing_attribute_id = l_qp_pricing_attributes_rec.pricing_attribute_id
2248: AND list_line_id = l_qp_list_lines_rec.list_line_id and list_header_id = p_entity;
2249:
2250: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */

Line 2247: WHERE pricing_attribute_id = l_qp_pricing_attributes_rec.pricing_attribute_id

2243:
2244: g_count_pricing_att := g_count_pricing_att + sql%rowcount;
2245:
2246: DELETE FROM qp_pricing_attributes
2247: WHERE pricing_attribute_id = l_qp_pricing_attributes_rec.pricing_attribute_id
2248: AND list_line_id = l_qp_list_lines_rec.list_line_id and list_header_id = p_entity;
2249:
2250: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
2251:

Line 2250: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */

2246: DELETE FROM qp_pricing_attributes
2247: WHERE pricing_attribute_id = l_qp_pricing_attributes_rec.pricing_attribute_id
2248: AND list_line_id = l_qp_list_lines_rec.list_line_id and list_header_id = p_entity;
2249:
2250: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
2251:
2252: END IF; --Insert flag
2253: ELSE --Limit exists
2254: fnd_file.put_line(FND_FILE.LOG,'Limit exists for this line and it cannot be archived : '||l_qp_list_lines_rec.list_line_id);