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; */ --bug#13045009

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; */ --bug#13045009
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; */ --bug#13045009
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; */ --bug#13045009

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; */ --bug#13045009
628:
629: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
630:
631: ---bug#13045009

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; */ --bug#13045009
628:
629: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
630:
631: ---bug#13045009
632: DELETE FROM QP_PRICING_ATTRIBUTES
633: WHERE-- pricing_attribute_id = l_qp_pricing_attributes_rec.pricing_attribute_id and

Line 632: DELETE FROM QP_PRICING_ATTRIBUTES

628:
629: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
630:
631: ---bug#13045009
632: DELETE FROM QP_PRICING_ATTRIBUTES
633: WHERE-- pricing_attribute_id = l_qp_pricing_attributes_rec.pricing_attribute_id and
634: list_line_id = p_to_rltd_modifier_id; --l_qp_pricing_attributes_rec.list_line_id;
635: --and list_header_id = l_qp_pricing_attributes_rec.list_header_id;
636: ---bug#13045009

Line 633: WHERE-- pricing_attribute_id = l_qp_pricing_attributes_rec.pricing_attribute_id and

629: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
630:
631: ---bug#13045009
632: DELETE FROM QP_PRICING_ATTRIBUTES
633: WHERE-- pricing_attribute_id = l_qp_pricing_attributes_rec.pricing_attribute_id and
634: list_line_id = p_to_rltd_modifier_id; --l_qp_pricing_attributes_rec.list_line_id;
635: --and list_header_id = l_qp_pricing_attributes_rec.list_header_id;
636: ---bug#13045009
637:

Line 634: list_line_id = p_to_rltd_modifier_id; --l_qp_pricing_attributes_rec.list_line_id;

630:
631: ---bug#13045009
632: DELETE FROM QP_PRICING_ATTRIBUTES
633: WHERE-- pricing_attribute_id = l_qp_pricing_attributes_rec.pricing_attribute_id and
634: list_line_id = p_to_rltd_modifier_id; --l_qp_pricing_attributes_rec.list_line_id;
635: --and list_header_id = l_qp_pricing_attributes_rec.list_header_id;
636: ---bug#13045009
637:
638: END DELETE_CHILD;

Line 635: --and list_header_id = l_qp_pricing_attributes_rec.list_header_id;

631: ---bug#13045009
632: DELETE FROM QP_PRICING_ATTRIBUTES
633: WHERE-- pricing_attribute_id = l_qp_pricing_attributes_rec.pricing_attribute_id and
634: list_line_id = p_to_rltd_modifier_id; --l_qp_pricing_attributes_rec.list_line_id;
635: --and list_header_id = l_qp_pricing_attributes_rec.list_header_id;
636: ---bug#13045009
637:
638: END DELETE_CHILD;
639:

Line 833: CURSOR qp_pricing_attributes_cur(p_from_list_line_id NUMBER)

829:
830: TYPE lines_cur_typ IS REF CURSOR;
831: qp_list_lines_cv lines_cur_typ;
832:
833: CURSOR qp_pricing_attributes_cur(p_from_list_line_id NUMBER)
834: IS
835: SELECT *
836: FROM qp_pricing_attributes
837: WHERE list_line_id = p_from_list_line_id;

Line 836: FROM qp_pricing_attributes

832:
833: CURSOR qp_pricing_attributes_cur(p_from_list_line_id NUMBER)
834: IS
835: SELECT *
836: FROM qp_pricing_attributes
837: WHERE list_line_id = p_from_list_line_id;
838:
839: CURSOR qp_headers_qualifiers_cur(p_from_discount_header_id NUMBER)
840: IS

Line 1015: FROM qp_pricing_attributes a

1011: IF nvl(p_all_lines,'N') = 'N' THEN
1012: IF p_product_context is not NULL THEN
1013: l_select_stmt := l_select_stmt || 'AND q.list_line_id IN
1014: (SELECT DISTINCT a.list_line_id
1015: FROM qp_pricing_attributes a
1016: WHERE a.list_line_id = q.list_line_id
1017: and EXCLUDER_FLAG =''N'''; --This would take care of Exculded Items.
1018:
1019: IF p_product_attribute = 'PRICING_ATTRIBUTE1' THEN

Line 1303: FROM qp_pricing_attributes a

1299: END IF; --Pricing Attribute end
1300: ELSE --Product_context is null
1301: -- changed the not in condition to in for the bug 7315038
1302: l_select_stmt := l_select_stmt || 'AND q.list_line_id in (SELECT DISTINCT a.list_line_id
1303: FROM qp_pricing_attributes a
1304: WHERE a.list_line_id = q.list_line_id)';
1305: END IF; -- Product_context end
1306: ELSE
1307: l_select_stmt := l_select_stmt || 'AND q.list_line_id not in (SELECT DISTINCT a.to_rltd_modifier_id

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

2175: END IF;
2176: END IF; -- List type code end
2177:
2178: /* Archive List lines pricing attributes */
2179: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (l_qp_list_lines_rec.list_line_id) LOOP
2180: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N' then
2181: BEGIN
2182: l_pric_attr_value_from_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
2183: l_pric_attr_value_to_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);

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

2176: END IF; -- List type code end
2177:
2178: /* Archive List lines pricing attributes */
2179: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (l_qp_list_lines_rec.list_line_id) LOOP
2180: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N' then
2181: BEGIN
2182: l_pric_attr_value_from_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
2183: l_pric_attr_value_to_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
2184: EXCEPTION

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

2178: /* Archive List lines pricing attributes */
2179: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (l_qp_list_lines_rec.list_line_id) LOOP
2180: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N' then
2181: BEGIN
2182: l_pric_attr_value_from_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
2183: l_pric_attr_value_to_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
2184: EXCEPTION
2185: WHEN VALUE_ERROR THEN
2186: NULL;

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

2179: FOR l_qp_pricing_attributes_rec IN qp_pricing_attributes_cur (l_qp_list_lines_rec.list_line_id) LOOP
2180: IF l_qp_pricing_attributes_rec.pricing_attribute_datatype = 'N' then
2181: BEGIN
2182: l_pric_attr_value_from_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_from);
2183: l_pric_attr_value_to_number := qp_number.canonical_to_number(l_qp_pricing_attributes_rec.pricing_attr_value_to);
2184: EXCEPTION
2185: WHEN VALUE_ERROR THEN
2186: NULL;
2187: WHEN OTHERS THEN

Line 2253: l_qp_pricing_attributes_rec.pricing_attribute_id,

2249: ARCH_PURG_REQUEST_ID
2250: )
2251: VALUES
2252: (
2253: l_qp_pricing_attributes_rec.pricing_attribute_id,
2254: l_qp_pricing_attributes_rec.creation_date,
2255: l_qp_pricing_attributes_rec.created_by,
2256: l_qp_pricing_attributes_rec.last_update_date,
2257: l_qp_pricing_attributes_rec.last_updated_by,

Line 2254: l_qp_pricing_attributes_rec.creation_date,

2250: )
2251: VALUES
2252: (
2253: l_qp_pricing_attributes_rec.pricing_attribute_id,
2254: l_qp_pricing_attributes_rec.creation_date,
2255: l_qp_pricing_attributes_rec.created_by,
2256: l_qp_pricing_attributes_rec.last_update_date,
2257: l_qp_pricing_attributes_rec.last_updated_by,
2258: l_qp_pricing_attributes_rec.last_update_login,

Line 2255: l_qp_pricing_attributes_rec.created_by,

2251: VALUES
2252: (
2253: l_qp_pricing_attributes_rec.pricing_attribute_id,
2254: l_qp_pricing_attributes_rec.creation_date,
2255: l_qp_pricing_attributes_rec.created_by,
2256: l_qp_pricing_attributes_rec.last_update_date,
2257: l_qp_pricing_attributes_rec.last_updated_by,
2258: l_qp_pricing_attributes_rec.last_update_login,
2259: l_qp_pricing_attributes_rec.program_application_id,

Line 2256: l_qp_pricing_attributes_rec.last_update_date,

2252: (
2253: l_qp_pricing_attributes_rec.pricing_attribute_id,
2254: l_qp_pricing_attributes_rec.creation_date,
2255: l_qp_pricing_attributes_rec.created_by,
2256: l_qp_pricing_attributes_rec.last_update_date,
2257: l_qp_pricing_attributes_rec.last_updated_by,
2258: l_qp_pricing_attributes_rec.last_update_login,
2259: l_qp_pricing_attributes_rec.program_application_id,
2260: l_qp_pricing_attributes_rec.program_id,

Line 2257: l_qp_pricing_attributes_rec.last_updated_by,

2253: l_qp_pricing_attributes_rec.pricing_attribute_id,
2254: l_qp_pricing_attributes_rec.creation_date,
2255: l_qp_pricing_attributes_rec.created_by,
2256: l_qp_pricing_attributes_rec.last_update_date,
2257: l_qp_pricing_attributes_rec.last_updated_by,
2258: l_qp_pricing_attributes_rec.last_update_login,
2259: l_qp_pricing_attributes_rec.program_application_id,
2260: l_qp_pricing_attributes_rec.program_id,
2261: l_qp_pricing_attributes_rec.program_update_date,

Line 2258: l_qp_pricing_attributes_rec.last_update_login,

2254: l_qp_pricing_attributes_rec.creation_date,
2255: l_qp_pricing_attributes_rec.created_by,
2256: l_qp_pricing_attributes_rec.last_update_date,
2257: l_qp_pricing_attributes_rec.last_updated_by,
2258: l_qp_pricing_attributes_rec.last_update_login,
2259: l_qp_pricing_attributes_rec.program_application_id,
2260: l_qp_pricing_attributes_rec.program_id,
2261: l_qp_pricing_attributes_rec.program_update_date,
2262: l_qp_pricing_attributes_rec.request_id,

Line 2259: l_qp_pricing_attributes_rec.program_application_id,

2255: l_qp_pricing_attributes_rec.created_by,
2256: l_qp_pricing_attributes_rec.last_update_date,
2257: l_qp_pricing_attributes_rec.last_updated_by,
2258: l_qp_pricing_attributes_rec.last_update_login,
2259: l_qp_pricing_attributes_rec.program_application_id,
2260: l_qp_pricing_attributes_rec.program_id,
2261: l_qp_pricing_attributes_rec.program_update_date,
2262: l_qp_pricing_attributes_rec.request_id,
2263: l_qp_list_lines_rec.list_line_id,

Line 2260: l_qp_pricing_attributes_rec.program_id,

2256: l_qp_pricing_attributes_rec.last_update_date,
2257: l_qp_pricing_attributes_rec.last_updated_by,
2258: l_qp_pricing_attributes_rec.last_update_login,
2259: l_qp_pricing_attributes_rec.program_application_id,
2260: l_qp_pricing_attributes_rec.program_id,
2261: l_qp_pricing_attributes_rec.program_update_date,
2262: l_qp_pricing_attributes_rec.request_id,
2263: l_qp_list_lines_rec.list_line_id,
2264: p_entity,

Line 2261: l_qp_pricing_attributes_rec.program_update_date,

2257: l_qp_pricing_attributes_rec.last_updated_by,
2258: l_qp_pricing_attributes_rec.last_update_login,
2259: l_qp_pricing_attributes_rec.program_application_id,
2260: l_qp_pricing_attributes_rec.program_id,
2261: l_qp_pricing_attributes_rec.program_update_date,
2262: l_qp_pricing_attributes_rec.request_id,
2263: l_qp_list_lines_rec.list_line_id,
2264: p_entity,
2265: l_qp_pricing_attributes_rec.pricing_phase_id,

Line 2262: l_qp_pricing_attributes_rec.request_id,

2258: l_qp_pricing_attributes_rec.last_update_login,
2259: l_qp_pricing_attributes_rec.program_application_id,
2260: l_qp_pricing_attributes_rec.program_id,
2261: l_qp_pricing_attributes_rec.program_update_date,
2262: l_qp_pricing_attributes_rec.request_id,
2263: l_qp_list_lines_rec.list_line_id,
2264: p_entity,
2265: l_qp_pricing_attributes_rec.pricing_phase_id,
2266: l_qp_pricing_attributes_rec.qualification_ind,

Line 2265: l_qp_pricing_attributes_rec.pricing_phase_id,

2261: l_qp_pricing_attributes_rec.program_update_date,
2262: l_qp_pricing_attributes_rec.request_id,
2263: l_qp_list_lines_rec.list_line_id,
2264: p_entity,
2265: l_qp_pricing_attributes_rec.pricing_phase_id,
2266: l_qp_pricing_attributes_rec.qualification_ind,
2267: l_qp_pricing_attributes_rec.excluder_flag,
2268: l_qp_pricing_attributes_rec.accumulate_flag,
2269: l_qp_pricing_attributes_rec.product_attribute_context,

Line 2266: l_qp_pricing_attributes_rec.qualification_ind,

2262: l_qp_pricing_attributes_rec.request_id,
2263: l_qp_list_lines_rec.list_line_id,
2264: p_entity,
2265: l_qp_pricing_attributes_rec.pricing_phase_id,
2266: l_qp_pricing_attributes_rec.qualification_ind,
2267: l_qp_pricing_attributes_rec.excluder_flag,
2268: l_qp_pricing_attributes_rec.accumulate_flag,
2269: l_qp_pricing_attributes_rec.product_attribute_context,
2270: l_qp_pricing_attributes_rec.product_attribute,

Line 2267: l_qp_pricing_attributes_rec.excluder_flag,

2263: l_qp_list_lines_rec.list_line_id,
2264: p_entity,
2265: l_qp_pricing_attributes_rec.pricing_phase_id,
2266: l_qp_pricing_attributes_rec.qualification_ind,
2267: l_qp_pricing_attributes_rec.excluder_flag,
2268: l_qp_pricing_attributes_rec.accumulate_flag,
2269: l_qp_pricing_attributes_rec.product_attribute_context,
2270: l_qp_pricing_attributes_rec.product_attribute,
2271: l_qp_pricing_attributes_rec.product_attr_value,

Line 2268: l_qp_pricing_attributes_rec.accumulate_flag,

2264: p_entity,
2265: l_qp_pricing_attributes_rec.pricing_phase_id,
2266: l_qp_pricing_attributes_rec.qualification_ind,
2267: l_qp_pricing_attributes_rec.excluder_flag,
2268: l_qp_pricing_attributes_rec.accumulate_flag,
2269: l_qp_pricing_attributes_rec.product_attribute_context,
2270: l_qp_pricing_attributes_rec.product_attribute,
2271: l_qp_pricing_attributes_rec.product_attr_value,
2272: l_qp_pricing_attributes_rec.product_uom_code,

Line 2269: l_qp_pricing_attributes_rec.product_attribute_context,

2265: l_qp_pricing_attributes_rec.pricing_phase_id,
2266: l_qp_pricing_attributes_rec.qualification_ind,
2267: l_qp_pricing_attributes_rec.excluder_flag,
2268: l_qp_pricing_attributes_rec.accumulate_flag,
2269: l_qp_pricing_attributes_rec.product_attribute_context,
2270: l_qp_pricing_attributes_rec.product_attribute,
2271: l_qp_pricing_attributes_rec.product_attr_value,
2272: l_qp_pricing_attributes_rec.product_uom_code,
2273: l_qp_pricing_attributes_rec.pricing_attribute_context,

Line 2270: l_qp_pricing_attributes_rec.product_attribute,

2266: l_qp_pricing_attributes_rec.qualification_ind,
2267: l_qp_pricing_attributes_rec.excluder_flag,
2268: l_qp_pricing_attributes_rec.accumulate_flag,
2269: l_qp_pricing_attributes_rec.product_attribute_context,
2270: l_qp_pricing_attributes_rec.product_attribute,
2271: l_qp_pricing_attributes_rec.product_attr_value,
2272: l_qp_pricing_attributes_rec.product_uom_code,
2273: l_qp_pricing_attributes_rec.pricing_attribute_context,
2274: l_qp_pricing_attributes_rec.pricing_attribute,

Line 2271: l_qp_pricing_attributes_rec.product_attr_value,

2267: l_qp_pricing_attributes_rec.excluder_flag,
2268: l_qp_pricing_attributes_rec.accumulate_flag,
2269: l_qp_pricing_attributes_rec.product_attribute_context,
2270: l_qp_pricing_attributes_rec.product_attribute,
2271: l_qp_pricing_attributes_rec.product_attr_value,
2272: l_qp_pricing_attributes_rec.product_uom_code,
2273: l_qp_pricing_attributes_rec.pricing_attribute_context,
2274: l_qp_pricing_attributes_rec.pricing_attribute,
2275: l_qp_pricing_attributes_rec.pricing_attr_value_from,

Line 2272: l_qp_pricing_attributes_rec.product_uom_code,

2268: l_qp_pricing_attributes_rec.accumulate_flag,
2269: l_qp_pricing_attributes_rec.product_attribute_context,
2270: l_qp_pricing_attributes_rec.product_attribute,
2271: l_qp_pricing_attributes_rec.product_attr_value,
2272: l_qp_pricing_attributes_rec.product_uom_code,
2273: l_qp_pricing_attributes_rec.pricing_attribute_context,
2274: l_qp_pricing_attributes_rec.pricing_attribute,
2275: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2276: l_qp_pricing_attributes_rec.pricing_attr_value_to,

Line 2273: l_qp_pricing_attributes_rec.pricing_attribute_context,

2269: l_qp_pricing_attributes_rec.product_attribute_context,
2270: l_qp_pricing_attributes_rec.product_attribute,
2271: l_qp_pricing_attributes_rec.product_attr_value,
2272: l_qp_pricing_attributes_rec.product_uom_code,
2273: l_qp_pricing_attributes_rec.pricing_attribute_context,
2274: l_qp_pricing_attributes_rec.pricing_attribute,
2275: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2276: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2277: l_qp_pricing_attributes_rec.attribute_grouping_no,

Line 2274: l_qp_pricing_attributes_rec.pricing_attribute,

2270: l_qp_pricing_attributes_rec.product_attribute,
2271: l_qp_pricing_attributes_rec.product_attr_value,
2272: l_qp_pricing_attributes_rec.product_uom_code,
2273: l_qp_pricing_attributes_rec.pricing_attribute_context,
2274: l_qp_pricing_attributes_rec.pricing_attribute,
2275: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2276: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2277: l_qp_pricing_attributes_rec.attribute_grouping_no,
2278: l_qp_pricing_attributes_rec.context,

Line 2275: l_qp_pricing_attributes_rec.pricing_attr_value_from,

2271: l_qp_pricing_attributes_rec.product_attr_value,
2272: l_qp_pricing_attributes_rec.product_uom_code,
2273: l_qp_pricing_attributes_rec.pricing_attribute_context,
2274: l_qp_pricing_attributes_rec.pricing_attribute,
2275: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2276: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2277: l_qp_pricing_attributes_rec.attribute_grouping_no,
2278: l_qp_pricing_attributes_rec.context,
2279: l_qp_pricing_attributes_rec.attribute1,

Line 2276: l_qp_pricing_attributes_rec.pricing_attr_value_to,

2272: l_qp_pricing_attributes_rec.product_uom_code,
2273: l_qp_pricing_attributes_rec.pricing_attribute_context,
2274: l_qp_pricing_attributes_rec.pricing_attribute,
2275: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2276: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2277: l_qp_pricing_attributes_rec.attribute_grouping_no,
2278: l_qp_pricing_attributes_rec.context,
2279: l_qp_pricing_attributes_rec.attribute1,
2280: l_qp_pricing_attributes_rec.attribute2,

Line 2277: l_qp_pricing_attributes_rec.attribute_grouping_no,

2273: l_qp_pricing_attributes_rec.pricing_attribute_context,
2274: l_qp_pricing_attributes_rec.pricing_attribute,
2275: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2276: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2277: l_qp_pricing_attributes_rec.attribute_grouping_no,
2278: l_qp_pricing_attributes_rec.context,
2279: l_qp_pricing_attributes_rec.attribute1,
2280: l_qp_pricing_attributes_rec.attribute2,
2281: l_qp_pricing_attributes_rec.attribute3,

Line 2278: l_qp_pricing_attributes_rec.context,

2274: l_qp_pricing_attributes_rec.pricing_attribute,
2275: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2276: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2277: l_qp_pricing_attributes_rec.attribute_grouping_no,
2278: l_qp_pricing_attributes_rec.context,
2279: l_qp_pricing_attributes_rec.attribute1,
2280: l_qp_pricing_attributes_rec.attribute2,
2281: l_qp_pricing_attributes_rec.attribute3,
2282: l_qp_pricing_attributes_rec.attribute4,

Line 2279: l_qp_pricing_attributes_rec.attribute1,

2275: l_qp_pricing_attributes_rec.pricing_attr_value_from,
2276: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2277: l_qp_pricing_attributes_rec.attribute_grouping_no,
2278: l_qp_pricing_attributes_rec.context,
2279: l_qp_pricing_attributes_rec.attribute1,
2280: l_qp_pricing_attributes_rec.attribute2,
2281: l_qp_pricing_attributes_rec.attribute3,
2282: l_qp_pricing_attributes_rec.attribute4,
2283: l_qp_pricing_attributes_rec.attribute5,

Line 2280: l_qp_pricing_attributes_rec.attribute2,

2276: l_qp_pricing_attributes_rec.pricing_attr_value_to,
2277: l_qp_pricing_attributes_rec.attribute_grouping_no,
2278: l_qp_pricing_attributes_rec.context,
2279: l_qp_pricing_attributes_rec.attribute1,
2280: l_qp_pricing_attributes_rec.attribute2,
2281: l_qp_pricing_attributes_rec.attribute3,
2282: l_qp_pricing_attributes_rec.attribute4,
2283: l_qp_pricing_attributes_rec.attribute5,
2284: l_qp_pricing_attributes_rec.attribute6,

Line 2281: l_qp_pricing_attributes_rec.attribute3,

2277: l_qp_pricing_attributes_rec.attribute_grouping_no,
2278: l_qp_pricing_attributes_rec.context,
2279: l_qp_pricing_attributes_rec.attribute1,
2280: l_qp_pricing_attributes_rec.attribute2,
2281: l_qp_pricing_attributes_rec.attribute3,
2282: l_qp_pricing_attributes_rec.attribute4,
2283: l_qp_pricing_attributes_rec.attribute5,
2284: l_qp_pricing_attributes_rec.attribute6,
2285: l_qp_pricing_attributes_rec.attribute7,

Line 2282: l_qp_pricing_attributes_rec.attribute4,

2278: l_qp_pricing_attributes_rec.context,
2279: l_qp_pricing_attributes_rec.attribute1,
2280: l_qp_pricing_attributes_rec.attribute2,
2281: l_qp_pricing_attributes_rec.attribute3,
2282: l_qp_pricing_attributes_rec.attribute4,
2283: l_qp_pricing_attributes_rec.attribute5,
2284: l_qp_pricing_attributes_rec.attribute6,
2285: l_qp_pricing_attributes_rec.attribute7,
2286: l_qp_pricing_attributes_rec.attribute8,

Line 2283: l_qp_pricing_attributes_rec.attribute5,

2279: l_qp_pricing_attributes_rec.attribute1,
2280: l_qp_pricing_attributes_rec.attribute2,
2281: l_qp_pricing_attributes_rec.attribute3,
2282: l_qp_pricing_attributes_rec.attribute4,
2283: l_qp_pricing_attributes_rec.attribute5,
2284: l_qp_pricing_attributes_rec.attribute6,
2285: l_qp_pricing_attributes_rec.attribute7,
2286: l_qp_pricing_attributes_rec.attribute8,
2287: l_qp_pricing_attributes_rec.attribute9,

Line 2284: l_qp_pricing_attributes_rec.attribute6,

2280: l_qp_pricing_attributes_rec.attribute2,
2281: l_qp_pricing_attributes_rec.attribute3,
2282: l_qp_pricing_attributes_rec.attribute4,
2283: l_qp_pricing_attributes_rec.attribute5,
2284: l_qp_pricing_attributes_rec.attribute6,
2285: l_qp_pricing_attributes_rec.attribute7,
2286: l_qp_pricing_attributes_rec.attribute8,
2287: l_qp_pricing_attributes_rec.attribute9,
2288: l_qp_pricing_attributes_rec.attribute10,

Line 2285: l_qp_pricing_attributes_rec.attribute7,

2281: l_qp_pricing_attributes_rec.attribute3,
2282: l_qp_pricing_attributes_rec.attribute4,
2283: l_qp_pricing_attributes_rec.attribute5,
2284: l_qp_pricing_attributes_rec.attribute6,
2285: l_qp_pricing_attributes_rec.attribute7,
2286: l_qp_pricing_attributes_rec.attribute8,
2287: l_qp_pricing_attributes_rec.attribute9,
2288: l_qp_pricing_attributes_rec.attribute10,
2289: l_qp_pricing_attributes_rec.attribute11,

Line 2286: l_qp_pricing_attributes_rec.attribute8,

2282: l_qp_pricing_attributes_rec.attribute4,
2283: l_qp_pricing_attributes_rec.attribute5,
2284: l_qp_pricing_attributes_rec.attribute6,
2285: l_qp_pricing_attributes_rec.attribute7,
2286: l_qp_pricing_attributes_rec.attribute8,
2287: l_qp_pricing_attributes_rec.attribute9,
2288: l_qp_pricing_attributes_rec.attribute10,
2289: l_qp_pricing_attributes_rec.attribute11,
2290: l_qp_pricing_attributes_rec.attribute12,

Line 2287: l_qp_pricing_attributes_rec.attribute9,

2283: l_qp_pricing_attributes_rec.attribute5,
2284: l_qp_pricing_attributes_rec.attribute6,
2285: l_qp_pricing_attributes_rec.attribute7,
2286: l_qp_pricing_attributes_rec.attribute8,
2287: l_qp_pricing_attributes_rec.attribute9,
2288: l_qp_pricing_attributes_rec.attribute10,
2289: l_qp_pricing_attributes_rec.attribute11,
2290: l_qp_pricing_attributes_rec.attribute12,
2291: l_qp_pricing_attributes_rec.attribute13,

Line 2288: l_qp_pricing_attributes_rec.attribute10,

2284: l_qp_pricing_attributes_rec.attribute6,
2285: l_qp_pricing_attributes_rec.attribute7,
2286: l_qp_pricing_attributes_rec.attribute8,
2287: l_qp_pricing_attributes_rec.attribute9,
2288: l_qp_pricing_attributes_rec.attribute10,
2289: l_qp_pricing_attributes_rec.attribute11,
2290: l_qp_pricing_attributes_rec.attribute12,
2291: l_qp_pricing_attributes_rec.attribute13,
2292: l_qp_pricing_attributes_rec.attribute14,

Line 2289: l_qp_pricing_attributes_rec.attribute11,

2285: l_qp_pricing_attributes_rec.attribute7,
2286: l_qp_pricing_attributes_rec.attribute8,
2287: l_qp_pricing_attributes_rec.attribute9,
2288: l_qp_pricing_attributes_rec.attribute10,
2289: l_qp_pricing_attributes_rec.attribute11,
2290: l_qp_pricing_attributes_rec.attribute12,
2291: l_qp_pricing_attributes_rec.attribute13,
2292: l_qp_pricing_attributes_rec.attribute14,
2293: l_qp_pricing_attributes_rec.attribute15,

Line 2290: l_qp_pricing_attributes_rec.attribute12,

2286: l_qp_pricing_attributes_rec.attribute8,
2287: l_qp_pricing_attributes_rec.attribute9,
2288: l_qp_pricing_attributes_rec.attribute10,
2289: l_qp_pricing_attributes_rec.attribute11,
2290: l_qp_pricing_attributes_rec.attribute12,
2291: l_qp_pricing_attributes_rec.attribute13,
2292: l_qp_pricing_attributes_rec.attribute14,
2293: l_qp_pricing_attributes_rec.attribute15,
2294: l_qp_pricing_attributes_rec.product_attribute_datatype,

Line 2291: l_qp_pricing_attributes_rec.attribute13,

2287: l_qp_pricing_attributes_rec.attribute9,
2288: l_qp_pricing_attributes_rec.attribute10,
2289: l_qp_pricing_attributes_rec.attribute11,
2290: l_qp_pricing_attributes_rec.attribute12,
2291: l_qp_pricing_attributes_rec.attribute13,
2292: l_qp_pricing_attributes_rec.attribute14,
2293: l_qp_pricing_attributes_rec.attribute15,
2294: l_qp_pricing_attributes_rec.product_attribute_datatype,
2295: l_qp_pricing_attributes_rec.pricing_attribute_datatype,

Line 2292: l_qp_pricing_attributes_rec.attribute14,

2288: l_qp_pricing_attributes_rec.attribute10,
2289: l_qp_pricing_attributes_rec.attribute11,
2290: l_qp_pricing_attributes_rec.attribute12,
2291: l_qp_pricing_attributes_rec.attribute13,
2292: l_qp_pricing_attributes_rec.attribute14,
2293: l_qp_pricing_attributes_rec.attribute15,
2294: l_qp_pricing_attributes_rec.product_attribute_datatype,
2295: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
2296: l_qp_pricing_attributes_rec.comparison_operator_code,

Line 2293: l_qp_pricing_attributes_rec.attribute15,

2289: l_qp_pricing_attributes_rec.attribute11,
2290: l_qp_pricing_attributes_rec.attribute12,
2291: l_qp_pricing_attributes_rec.attribute13,
2292: l_qp_pricing_attributes_rec.attribute14,
2293: l_qp_pricing_attributes_rec.attribute15,
2294: l_qp_pricing_attributes_rec.product_attribute_datatype,
2295: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
2296: l_qp_pricing_attributes_rec.comparison_operator_code,
2297: l_pric_attr_value_from_number,

Line 2294: l_qp_pricing_attributes_rec.product_attribute_datatype,

2290: l_qp_pricing_attributes_rec.attribute12,
2291: l_qp_pricing_attributes_rec.attribute13,
2292: l_qp_pricing_attributes_rec.attribute14,
2293: l_qp_pricing_attributes_rec.attribute15,
2294: l_qp_pricing_attributes_rec.product_attribute_datatype,
2295: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
2296: l_qp_pricing_attributes_rec.comparison_operator_code,
2297: l_pric_attr_value_from_number,
2298: l_pric_attr_value_to_number,

Line 2295: l_qp_pricing_attributes_rec.pricing_attribute_datatype,

2291: l_qp_pricing_attributes_rec.attribute13,
2292: l_qp_pricing_attributes_rec.attribute14,
2293: l_qp_pricing_attributes_rec.attribute15,
2294: l_qp_pricing_attributes_rec.product_attribute_datatype,
2295: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
2296: l_qp_pricing_attributes_rec.comparison_operator_code,
2297: l_pric_attr_value_from_number,
2298: l_pric_attr_value_to_number,
2299: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,

Line 2296: l_qp_pricing_attributes_rec.comparison_operator_code,

2292: l_qp_pricing_attributes_rec.attribute14,
2293: l_qp_pricing_attributes_rec.attribute15,
2294: l_qp_pricing_attributes_rec.product_attribute_datatype,
2295: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
2296: l_qp_pricing_attributes_rec.comparison_operator_code,
2297: l_pric_attr_value_from_number,
2298: l_pric_attr_value_to_number,
2299: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,
2300: l_qp_pricing_attributes_rec.SEARCH_IND,

Line 2299: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,

2295: l_qp_pricing_attributes_rec.pricing_attribute_datatype,
2296: l_qp_pricing_attributes_rec.comparison_operator_code,
2297: l_pric_attr_value_from_number,
2298: l_pric_attr_value_to_number,
2299: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,
2300: l_qp_pricing_attributes_rec.SEARCH_IND,
2301: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,
2302: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
2303: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,

Line 2300: l_qp_pricing_attributes_rec.SEARCH_IND,

2296: l_qp_pricing_attributes_rec.comparison_operator_code,
2297: l_pric_attr_value_from_number,
2298: l_pric_attr_value_to_number,
2299: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,
2300: l_qp_pricing_attributes_rec.SEARCH_IND,
2301: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,
2302: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
2303: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,
2304: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,

Line 2301: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,

2297: l_pric_attr_value_from_number,
2298: l_pric_attr_value_to_number,
2299: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,
2300: l_qp_pricing_attributes_rec.SEARCH_IND,
2301: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,
2302: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
2303: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,
2304: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,
2305: l_qp_pricing_attributes_rec.PRODUCT_SEGMENT_ID,

Line 2302: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,

2298: l_pric_attr_value_to_number,
2299: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,
2300: l_qp_pricing_attributes_rec.SEARCH_IND,
2301: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,
2302: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
2303: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,
2304: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,
2305: l_qp_pricing_attributes_rec.PRODUCT_SEGMENT_ID,
2306: l_qp_pricing_attributes_rec.PRICING_SEGMENT_ID,

Line 2303: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,

2299: l_qp_pricing_attributes_rec.DISTINCT_ROW_COUNT,
2300: l_qp_pricing_attributes_rec.SEARCH_IND,
2301: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,
2302: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
2303: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,
2304: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,
2305: l_qp_pricing_attributes_rec.PRODUCT_SEGMENT_ID,
2306: l_qp_pricing_attributes_rec.PRICING_SEGMENT_ID,
2307: l_conc_request_id

Line 2304: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,

2300: l_qp_pricing_attributes_rec.SEARCH_IND,
2301: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,
2302: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
2303: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,
2304: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,
2305: l_qp_pricing_attributes_rec.PRODUCT_SEGMENT_ID,
2306: l_qp_pricing_attributes_rec.PRICING_SEGMENT_ID,
2307: l_conc_request_id
2308: );

Line 2305: l_qp_pricing_attributes_rec.PRODUCT_SEGMENT_ID,

2301: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_POSITIVE,
2302: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
2303: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,
2304: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,
2305: l_qp_pricing_attributes_rec.PRODUCT_SEGMENT_ID,
2306: l_qp_pricing_attributes_rec.PRICING_SEGMENT_ID,
2307: l_conc_request_id
2308: );
2309:

Line 2306: l_qp_pricing_attributes_rec.PRICING_SEGMENT_ID,

2302: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_POSITIVE,
2303: l_qp_pricing_attributes_rec.PATTERN_VALUE_FROM_NEGATIVE,
2304: l_qp_pricing_attributes_rec.PATTERN_VALUE_TO_NEGATIVE,
2305: l_qp_pricing_attributes_rec.PRODUCT_SEGMENT_ID,
2306: l_qp_pricing_attributes_rec.PRICING_SEGMENT_ID,
2307: l_conc_request_id
2308: );
2309:
2310: g_count_pricing_att := g_count_pricing_att + sql%rowcount;

Line 2313: /* DELETE FROM qp_pricing_attributes

2309:
2310: g_count_pricing_att := g_count_pricing_att + sql%rowcount;
2311:
2312: ---bug#13045009
2313: /* DELETE FROM qp_pricing_attributes
2314: WHERE pricing_attribute_id = l_qp_pricing_attributes_rec.pricing_attribute_id
2315: AND list_line_id = l_qp_list_lines_rec.list_line_id and list_header_id = p_entity; */
2316: ---bug#13045009
2317:

Line 2314: WHERE pricing_attribute_id = l_qp_pricing_attributes_rec.pricing_attribute_id

2310: g_count_pricing_att := g_count_pricing_att + sql%rowcount;
2311:
2312: ---bug#13045009
2313: /* DELETE FROM qp_pricing_attributes
2314: WHERE pricing_attribute_id = l_qp_pricing_attributes_rec.pricing_attribute_id
2315: AND list_line_id = l_qp_list_lines_rec.list_line_id and list_header_id = p_entity; */
2316: ---bug#13045009
2317:
2318: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */

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

2314: WHERE pricing_attribute_id = l_qp_pricing_attributes_rec.pricing_attribute_id
2315: AND list_line_id = l_qp_list_lines_rec.list_line_id and list_header_id = p_entity; */
2316: ---bug#13045009
2317:
2318: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
2319: -- fnd_file.put_line(FND_FILE.LOG,'JP TEST --' || l_id_count);
2320: l_list_line_id_tbl(l_id_count) := l_qp_list_lines_rec.list_line_id;
2321: l_id_count := l_id_count+1;
2322:

Line 2331: DELETE FROM QP_PRICING_ATTRIBUTES

2327: END IF;
2328: END LOOP; /* Cursor qp_list_lines_cv LOOP */
2329: ---bug#13045009
2330: FORALL i IN l_list_line_id_tbl.first .. l_list_line_id_tbl.last
2331: DELETE FROM QP_PRICING_ATTRIBUTES
2332: WHERE list_line_id = l_list_line_id_tbl(i)
2333: AND list_header_id = p_entity;
2334: ---bug#13045009
2335: CLOSE qp_list_lines_cv;