eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_QP_FORM_PLL_PRICING_ATTR dependencies on QP_GLOBALS

Line 86: l_control_rec QP_GLOBALS.Control_Rec_Type;

82: IS
83: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
84: l_PRICING_ATTR_val_rec QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;
85: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
86: l_control_rec QP_GLOBALS.Control_Rec_Type;
87: l_return_status VARCHAR2(1);
88: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
89: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
90: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 146: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_CREATE;

142: l_PRICING_ATTR_rec.context := NULL;
143:
144: -- Set Operation to Create
145:
146: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_CREATE;
147:
148: -- Populate PRICING_ATTR table
149:
150: l_PRICING_ATTR_tbl(1) := l_PRICING_ATTR_rec;

Line 382: l_control_rec QP_GLOBALS.Control_Rec_Type;

378: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
379: l_PRICING_ATTR_val_rec QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;
380: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
381: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
382: l_control_rec QP_GLOBALS.Control_Rec_Type;
383: l_return_status VARCHAR2(1);
384: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
385: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
386: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 507: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

503:
504: -- Set Operation.
505:
506: IF FND_API.To_Boolean(l_PRICING_ATTR_rec.db_flag) THEN
507: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
508: ELSE
509: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_CREATE;
510: END IF;
511:

Line 509: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_CREATE;

505:
506: IF FND_API.To_Boolean(l_PRICING_ATTR_rec.db_flag) THEN
507: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
508: ELSE
509: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_CREATE;
510: END IF;
511:
512: -- Populate PRICING_ATTR table
513:

Line 595: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.accumulate_flag,

591: );
592:
593: -- Return changed attributes.
594:
595: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.accumulate_flag,
596: l_PRICING_ATTR_rec.accumulate_flag)
597: THEN
598: x_accumulate_flag := l_x_PRICING_ATTR_rec.accumulate_flag;
599: x_accumulate := l_PRICING_ATTR_val_rec.accumulate;

Line 602: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.from_rltd_modifier_id,

598: x_accumulate_flag := l_x_PRICING_ATTR_rec.accumulate_flag;
599: x_accumulate := l_PRICING_ATTR_val_rec.accumulate;
600: END IF;
601:
602: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.from_rltd_modifier_id,
603: l_PRICING_ATTR_rec.from_rltd_modifier_id)
604: THEN
605: x_from_rltd_modifier_id := l_x_PRICING_ATTR_rec.from_rltd_modifier_id;
606: END IF;

Line 608: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute1,

604: THEN
605: x_from_rltd_modifier_id := l_x_PRICING_ATTR_rec.from_rltd_modifier_id;
606: END IF;
607:
608: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute1,
609: l_PRICING_ATTR_rec.attribute1)
610: THEN
611: x_attribute1 := l_x_PRICING_ATTR_rec.attribute1;
612: END IF;

Line 614: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute10,

610: THEN
611: x_attribute1 := l_x_PRICING_ATTR_rec.attribute1;
612: END IF;
613:
614: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute10,
615: l_PRICING_ATTR_rec.attribute10)
616: THEN
617: x_attribute10 := l_x_PRICING_ATTR_rec.attribute10;
618: END IF;

Line 620: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute11,

616: THEN
617: x_attribute10 := l_x_PRICING_ATTR_rec.attribute10;
618: END IF;
619:
620: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute11,
621: l_PRICING_ATTR_rec.attribute11)
622: THEN
623: x_attribute11 := l_x_PRICING_ATTR_rec.attribute11;
624: END IF;

Line 626: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute12,

622: THEN
623: x_attribute11 := l_x_PRICING_ATTR_rec.attribute11;
624: END IF;
625:
626: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute12,
627: l_PRICING_ATTR_rec.attribute12)
628: THEN
629: x_attribute12 := l_x_PRICING_ATTR_rec.attribute12;
630: END IF;

Line 632: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute13,

628: THEN
629: x_attribute12 := l_x_PRICING_ATTR_rec.attribute12;
630: END IF;
631:
632: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute13,
633: l_PRICING_ATTR_rec.attribute13)
634: THEN
635: x_attribute13 := l_x_PRICING_ATTR_rec.attribute13;
636: END IF;

Line 638: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute14,

634: THEN
635: x_attribute13 := l_x_PRICING_ATTR_rec.attribute13;
636: END IF;
637:
638: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute14,
639: l_PRICING_ATTR_rec.attribute14)
640: THEN
641: x_attribute14 := l_x_PRICING_ATTR_rec.attribute14;
642: END IF;

Line 644: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute15,

640: THEN
641: x_attribute14 := l_x_PRICING_ATTR_rec.attribute14;
642: END IF;
643:
644: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute15,
645: l_PRICING_ATTR_rec.attribute15)
646: THEN
647: x_attribute15 := l_x_PRICING_ATTR_rec.attribute15;
648: END IF;

Line 650: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute2,

646: THEN
647: x_attribute15 := l_x_PRICING_ATTR_rec.attribute15;
648: END IF;
649:
650: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute2,
651: l_PRICING_ATTR_rec.attribute2)
652: THEN
653: x_attribute2 := l_x_PRICING_ATTR_rec.attribute2;
654: END IF;

Line 656: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute3,

652: THEN
653: x_attribute2 := l_x_PRICING_ATTR_rec.attribute2;
654: END IF;
655:
656: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute3,
657: l_PRICING_ATTR_rec.attribute3)
658: THEN
659: x_attribute3 := l_x_PRICING_ATTR_rec.attribute3;
660: END IF;

Line 662: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute4,

658: THEN
659: x_attribute3 := l_x_PRICING_ATTR_rec.attribute3;
660: END IF;
661:
662: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute4,
663: l_PRICING_ATTR_rec.attribute4)
664: THEN
665: x_attribute4 := l_x_PRICING_ATTR_rec.attribute4;
666: END IF;

Line 668: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute5,

664: THEN
665: x_attribute4 := l_x_PRICING_ATTR_rec.attribute4;
666: END IF;
667:
668: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute5,
669: l_PRICING_ATTR_rec.attribute5)
670: THEN
671: x_attribute5 := l_x_PRICING_ATTR_rec.attribute5;
672: END IF;

Line 674: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute6,

670: THEN
671: x_attribute5 := l_x_PRICING_ATTR_rec.attribute5;
672: END IF;
673:
674: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute6,
675: l_PRICING_ATTR_rec.attribute6)
676: THEN
677: x_attribute6 := l_x_PRICING_ATTR_rec.attribute6;
678: END IF;

Line 680: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute7,

676: THEN
677: x_attribute6 := l_x_PRICING_ATTR_rec.attribute6;
678: END IF;
679:
680: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute7,
681: l_PRICING_ATTR_rec.attribute7)
682: THEN
683: x_attribute7 := l_x_PRICING_ATTR_rec.attribute7;
684: END IF;

Line 686: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute8,

682: THEN
683: x_attribute7 := l_x_PRICING_ATTR_rec.attribute7;
684: END IF;
685:
686: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute8,
687: l_PRICING_ATTR_rec.attribute8)
688: THEN
689: x_attribute8 := l_x_PRICING_ATTR_rec.attribute8;
690: END IF;

Line 692: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute9,

688: THEN
689: x_attribute8 := l_x_PRICING_ATTR_rec.attribute8;
690: END IF;
691:
692: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute9,
693: l_PRICING_ATTR_rec.attribute9)
694: THEN
695: x_attribute9 := l_x_PRICING_ATTR_rec.attribute9;
696: END IF;

Line 698: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute_grouping_no,

694: THEN
695: x_attribute9 := l_x_PRICING_ATTR_rec.attribute9;
696: END IF;
697:
698: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.attribute_grouping_no,
699: l_PRICING_ATTR_rec.attribute_grouping_no)
700: THEN
701: x_attribute_grouping_no := l_x_PRICING_ATTR_rec.attribute_grouping_no;
702: END IF;

Line 704: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.context,

700: THEN
701: x_attribute_grouping_no := l_x_PRICING_ATTR_rec.attribute_grouping_no;
702: END IF;
703:
704: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.context,
705: l_PRICING_ATTR_rec.context)
706: THEN
707: x_context := l_x_PRICING_ATTR_rec.context;
708: END IF;

Line 710: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.excluder_flag,

706: THEN
707: x_context := l_x_PRICING_ATTR_rec.context;
708: END IF;
709:
710: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.excluder_flag,
711: l_PRICING_ATTR_rec.excluder_flag)
712: THEN
713: x_excluder_flag := l_x_PRICING_ATTR_rec.excluder_flag;
714: x_excluder := l_PRICING_ATTR_val_rec.excluder;

Line 717: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.list_line_id,

713: x_excluder_flag := l_x_PRICING_ATTR_rec.excluder_flag;
714: x_excluder := l_PRICING_ATTR_val_rec.excluder;
715: END IF;
716:
717: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.list_line_id,
718: l_PRICING_ATTR_rec.list_line_id)
719: THEN
720: x_list_line_id := l_x_PRICING_ATTR_rec.list_line_id;
721: x_list_line := l_PRICING_ATTR_val_rec.list_line;

Line 724: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.pricing_attribute,

720: x_list_line_id := l_x_PRICING_ATTR_rec.list_line_id;
721: x_list_line := l_PRICING_ATTR_val_rec.list_line;
722: END IF;
723:
724: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.pricing_attribute,
725: l_PRICING_ATTR_rec.pricing_attribute)
726: THEN
727: x_pricing_attribute := l_x_PRICING_ATTR_rec.pricing_attribute;
728: END IF;

Line 730: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.pricing_attribute_context,

726: THEN
727: x_pricing_attribute := l_x_PRICING_ATTR_rec.pricing_attribute;
728: END IF;
729:
730: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.pricing_attribute_context,
731: l_PRICING_ATTR_rec.pricing_attribute_context)
732: THEN
733: x_pricing_attribute_context := l_x_PRICING_ATTR_rec.pricing_attribute_context;
734: END IF;

Line 736: /* IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.pricing_attribute_id,

732: THEN
733: x_pricing_attribute_context := l_x_PRICING_ATTR_rec.pricing_attribute_context;
734: END IF;
735:
736: /* IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.pricing_attribute_id,
737: l_PRICING_ATTR_rec.pricing_attribute_id)
738: THEN
739: x_pricing_attribute_id := l_x_PRICING_ATTR_rec.pricing_attribute_id;
740: x_pricing_attribute := l_PRICING_ATTR_val_rec.pricing_attribute;

Line 743: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.pricing_attr_value_from,

739: x_pricing_attribute_id := l_x_PRICING_ATTR_rec.pricing_attribute_id;
740: x_pricing_attribute := l_PRICING_ATTR_val_rec.pricing_attribute;
741: END IF;
742: */
743: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.pricing_attr_value_from,
744: l_PRICING_ATTR_rec.pricing_attr_value_from)
745: THEN
746: x_pricing_attr_value_from := l_x_PRICING_ATTR_rec.pricing_attr_value_from;
747: END IF;

Line 749: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.pricing_attr_value_to,

745: THEN
746: x_pricing_attr_value_from := l_x_PRICING_ATTR_rec.pricing_attr_value_from;
747: END IF;
748:
749: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.pricing_attr_value_to,
750: l_PRICING_ATTR_rec.pricing_attr_value_to)
751: THEN
752: x_pricing_attr_value_to := l_x_PRICING_ATTR_rec.pricing_attr_value_to;
753: END IF;

Line 755: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.product_attribute,

751: THEN
752: x_pricing_attr_value_to := l_x_PRICING_ATTR_rec.pricing_attr_value_to;
753: END IF;
754:
755: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.product_attribute,
756: l_PRICING_ATTR_rec.product_attribute)
757: THEN
758: x_product_attribute := l_x_PRICING_ATTR_rec.product_attribute;
759: END IF;

Line 761: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.product_attribute_context,

757: THEN
758: x_product_attribute := l_x_PRICING_ATTR_rec.product_attribute;
759: END IF;
760:
761: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.product_attribute_context,
762: l_PRICING_ATTR_rec.product_attribute_context)
763: THEN
764: x_product_attribute_context := l_x_PRICING_ATTR_rec.product_attribute_context;
765: END IF;

Line 767: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.product_attr_value,

763: THEN
764: x_product_attribute_context := l_x_PRICING_ATTR_rec.product_attribute_context;
765: END IF;
766:
767: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.product_attr_value,
768: l_PRICING_ATTR_rec.product_attr_value)
769: THEN
770: x_product_attr_value := l_x_PRICING_ATTR_rec.product_attr_value;
771: END IF;

Line 773: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.product_uom_code,

769: THEN
770: x_product_attr_value := l_x_PRICING_ATTR_rec.product_attr_value;
771: END IF;
772:
773: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.product_uom_code,
774: l_PRICING_ATTR_rec.product_uom_code)
775: THEN
776: x_product_uom_code := l_x_PRICING_ATTR_rec.product_uom_code;
777: x_product_uom := l_PRICING_ATTR_val_rec.product_uom;

Line 780: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.comparison_operator_code,

776: x_product_uom_code := l_x_PRICING_ATTR_rec.product_uom_code;
777: x_product_uom := l_PRICING_ATTR_val_rec.product_uom;
778: END IF;
779:
780: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.comparison_operator_code,
781: l_PRICING_ATTR_rec.comparison_operator_code)
782: THEN
783: x_comparison_operator_code := l_PRICING_ATTR_rec.comparison_operator_code;
784: END IF;

Line 786: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.pricing_attribute_datatype,

782: THEN
783: x_comparison_operator_code := l_PRICING_ATTR_rec.comparison_operator_code;
784: END IF;
785:
786: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.pricing_attribute_datatype,
787: l_PRICING_ATTR_rec.pricing_attribute_datatype)
788: THEN
789: x_pricing_attribute_datatype := l_PRICING_ATTR_rec.pricing_attribute_datatype;
790: END IF;

Line 792: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.product_attribute_datatype,

788: THEN
789: x_pricing_attribute_datatype := l_PRICING_ATTR_rec.pricing_attribute_datatype;
790: END IF;
791:
792: IF NOT QP_GLOBALS.Equal(l_x_PRICING_ATTR_rec.product_attribute_datatype,
793: l_PRICING_ATTR_rec.product_attribute_datatype)
794: THEN
795: x_product_attribute_datatype := l_PRICING_ATTR_rec.product_attribute_datatype;
796: END IF;

Line 886: l_control_rec QP_GLOBALS.Control_Rec_Type;

882: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
883: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
884: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
885: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
886: l_control_rec QP_GLOBALS.Control_Rec_Type;
887: l_return_status VARCHAR2(1);
888: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
889: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
890: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 928: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

924:
925: -- Set Operation.
926:
927: IF FND_API.To_Boolean(l_PRICING_ATTR_rec.db_flag) THEN
928: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
929: ELSE
930: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_CREATE;
931: END IF;
932:

Line 930: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_CREATE;

926:
927: IF FND_API.To_Boolean(l_PRICING_ATTR_rec.db_flag) THEN
928: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
929: ELSE
930: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_CREATE;
931: END IF;
932:
933: -- Populate PRICING_ATTR table
934:

Line 1061: l_control_rec QP_GLOBALS.Control_Rec_Type;

1057: )
1058: IS
1059: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1060: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1061: l_control_rec QP_GLOBALS.Control_Rec_Type;
1062: l_return_status VARCHAR2(1);
1063: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1064: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1065: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1102: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_DELETE;

1098: );
1099:
1100: -- Set Operation.
1101:
1102: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_DELETE;
1103:
1104: -- Populate PRICING_ATTR table
1105:
1106: l_PRICING_ATTR_tbl(1) := l_PRICING_ATTR_rec;

Line 1117: IF (QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES <> 'N' or QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES IS NULL)

1113: into l_start_date_active, l_end_date_active, l_revision, l_list_header_id
1114: from qp_list_lines
1115: where list_line_id = l_pricing_attr_rec.list_line_id;
1116:
1117: IF (QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES <> 'N' or QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES IS NULL)
1118: THEN -- 5018856, 5024919 do not log request if N
1119:
1120: oe_debug_pub.add('about to log a request to check duplicate list lines ');
1121:

Line 1123: ( p_entity_code => QP_GLOBALS.G_ENTITY_ALL

1119:
1120: oe_debug_pub.add('about to log a request to check duplicate list lines ');
1121:
1122: QP_DELAYED_REQUESTS_PVT.Log_Request
1123: ( p_entity_code => QP_GLOBALS.G_ENTITY_ALL
1124: , p_entity_id => l_pricing_attr_rec.list_line_id
1125: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL
1126: , p_requesting_entity_id => l_pricing_attr_rec.list_line_id
1127: , p_request_type => QP_GLOBALS.G_DUPLICATE_LIST_LINES

Line 1125: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL

1121:
1122: QP_DELAYED_REQUESTS_PVT.Log_Request
1123: ( p_entity_code => QP_GLOBALS.G_ENTITY_ALL
1124: , p_entity_id => l_pricing_attr_rec.list_line_id
1125: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL
1126: , p_requesting_entity_id => l_pricing_attr_rec.list_line_id
1127: , p_request_type => QP_GLOBALS.G_DUPLICATE_LIST_LINES
1128: , p_param1 => l_list_header_id
1129: , p_param2 => fnd_date.date_to_canonical(l_start_date_active) --2739511

Line 1127: , p_request_type => QP_GLOBALS.G_DUPLICATE_LIST_LINES

1123: ( p_entity_code => QP_GLOBALS.G_ENTITY_ALL
1124: , p_entity_id => l_pricing_attr_rec.list_line_id
1125: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL
1126: , p_requesting_entity_id => l_pricing_attr_rec.list_line_id
1127: , p_request_type => QP_GLOBALS.G_DUPLICATE_LIST_LINES
1128: , p_param1 => l_list_header_id
1129: , p_param2 => fnd_date.date_to_canonical(l_start_date_active) --2739511
1130: , p_param3 => fnd_date.date_to_canonical(l_end_date_active) --2739511
1131: , p_param4 => l_revision

Line 1146: END IF; -- END IF QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES <> 'N' -- 5018856,, 5024919

1142:
1143: oe_debug_pub.add('after logging delayed request ');
1144:
1145: -- end bug2301959
1146: END IF; -- END IF QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES <> 'N' -- 5018856,, 5024919
1147:
1148: oe_debug_pub.add('Logging a request to update qualification_ind ', 1);
1149: qp_delayed_requests_PVT.log_request(
1150: p_entity_code => QP_GLOBALS.G_ENTITY_Price_List_Line,

Line 1150: p_entity_code => QP_GLOBALS.G_ENTITY_Price_List_Line,

1146: END IF; -- END IF QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES <> 'N' -- 5018856,, 5024919
1147:
1148: oe_debug_pub.add('Logging a request to update qualification_ind ', 1);
1149: qp_delayed_requests_PVT.log_request(
1150: p_entity_code => QP_GLOBALS.G_ENTITY_Price_List_Line,
1151: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1152: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Price_List_Line,
1153: p_requesting_entity_id => l_PRICING_ATTR_rec.list_line_id,
1154: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

Line 1152: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Price_List_Line,

1148: oe_debug_pub.add('Logging a request to update qualification_ind ', 1);
1149: qp_delayed_requests_PVT.log_request(
1150: p_entity_code => QP_GLOBALS.G_ENTITY_Price_List_Line,
1151: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1152: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Price_List_Line,
1153: p_requesting_entity_id => l_PRICING_ATTR_rec.list_line_id,
1154: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
1155: x_return_status => l_return_status);
1156:

Line 1154: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

1150: p_entity_code => QP_GLOBALS.G_ENTITY_Price_List_Line,
1151: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1152: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Price_List_Line,
1153: p_requesting_entity_id => l_PRICING_ATTR_rec.list_line_id,
1154: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
1155: x_return_status => l_return_status);
1156:
1157: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1158:

Line 1256: l_control_rec QP_GLOBALS.Control_Rec_Type;

1252: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1253: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1254: )
1255: IS
1256: l_control_rec QP_GLOBALS.Control_Rec_Type;
1257: l_return_status VARCHAR2(1);
1258: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1259: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1260: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1271: l_control_rec.process_entity := QP_GLOBALS.G_ENTITY_PRICING_ATTR;

1267: -- Set control flags.
1268:
1269: l_control_rec.controlled_operation := TRUE;
1270: l_control_rec.process := TRUE;
1271: l_control_rec.process_entity := QP_GLOBALS.G_ENTITY_PRICING_ATTR;
1272:
1273: l_control_rec.default_attributes := FALSE;
1274: l_control_rec.change_attributes := FALSE;
1275: l_control_rec.validate_entity := FALSE;

Line 1464: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_LOCK;

1460: l_PRICING_ATTR_rec.program_application_id := p_program_application_id;
1461: l_PRICING_ATTR_rec.program_id := p_program_id;
1462: l_PRICING_ATTR_rec.program_update_date := p_program_update_date;
1463: l_PRICING_ATTR_rec.request_id := p_request_id;
1464: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_LOCK;
1465: l_PRICING_ATTR_rec.comparison_operator_code := p_comparison_operator_code;
1466: l_PRICING_ATTR_rec.pricing_attribute_datatype := p_pricing_attribute_datatype;
1467: l_PRICING_ATTR_rec.product_attribute_datatype := p_product_attribute_datatype;
1468:

Line 1618: p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR

1614: BEGIN
1615: OE_MSG_PUB.initialize;
1616: x_return_status := FND_API.G_RET_STS_SUCCESS;
1617: QP_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
1618: p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
1619: ,p_entity_id => p_pricing_attribute_id
1620: ,x_return_status => l_return_status);
1621:
1622: OE_MSG_PUB.Count_And_Get

Line 1705: l_control_rec QP_GLOBALS.Control_Rec_Type;

1701: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1702: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1703: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1704: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1705: l_control_rec QP_GLOBALS.Control_Rec_Type;
1706: l_return_status varchar2(1);
1707: l_continuous_price_break_flag varchar2(1);
1708:
1709:

Line 1955: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_CREATE;

1951: l_PRICING_ATTR_rec.product_attribute_datatype := l_implicit_rec.product_attribute_datatype;
1952: l_PRICING_ATTR_rec.pricing_attr_value_from_number := l_implicit_rec.PRICING_ATTR_VALUE_FROM_NUMBER;
1953: l_PRICING_ATTR_rec.pricing_attr_value_to_number := l_implicit_rec.PRICING_ATTR_VALUE_TO_NUMBER;
1954: l_PRICING_ATTR_rec.qualification_ind := l_implicit_rec.QUALIFICATION_IND;
1955: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_CREATE;
1956:
1957: l_PRICING_ATTR_tbl(l_PRICING_ATTR_tbl.COUNT + 1) := l_PRICING_ATTR_rec;
1958:
1959: END LOOP;

Line 2054: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_CREATE;

2050: l_PRICE_LIST_LINE_rec.break_uom_code := l_implicit_rec.BREAK_UOM_CODE;
2051: l_PRICE_LIST_LINE_rec.break_uom_context := l_implicit_rec.BREAK_UOM_CONTEXT;
2052: l_PRICE_LIST_LINE_rec.break_uom_attribute := l_implicit_rec.BREAK_UOM_ATTRIBUTE;
2053: l_PRICE_LIST_LINE_rec.db_flag := FND_API.G_TRUE;
2054: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_CREATE;
2055:
2056:
2057: l_PRICE_LIST_LINE_tbl(l_PRICE_LIST_LINE_tbl.COUNT + 1) := l_PRICE_LIST_LINE_rec;
2058:

Line 2112: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_CREATE;

2108: l_PRICING_ATTR_rec.product_attribute_datatype := l_implicit_attr_rec.product_attribute_datatype;
2109: l_PRICING_ATTR_rec.pricing_attr_value_from_number := l_implicit_attr_rec.PRICING_ATTR_VALUE_FROM_NUMBER;
2110: l_PRICING_ATTR_rec.pricing_attr_value_to_number := l_implicit_attr_rec.PRICING_ATTR_VALUE_TO_NUMBER;
2111: l_PRICING_ATTR_rec.qualification_ind := l_implicit_attr_rec.QUALIFICATION_IND;
2112: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_CREATE;
2113:
2114: l_PRICING_ATTR_tbl(l_PRICING_ATTR_tbl.COUNT + 1) := l_PRICING_ATTR_rec;
2115:
2116: END LOOP;

Line 2158: ( p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR

2154:
2155: -- Upgrade Non Continuous Price Break Lines into Continuous Price Break Lines.
2156: IF (l_continuous_price_break_flag<>'Y' OR l_continuous_price_break_flag IS NULL )and l_list_line_type_code='PBH' THEN
2157: qp_delayed_requests_PVT.log_request
2158: ( p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
2159: , p_entity_id =>p_x_new_list_line_id
2160: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
2161: , p_requesting_entity_id => p_x_new_list_line_id
2162: , p_request_type => QP_Globals.G_UPGRADE_PRICE_BREAKS

Line 2160: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR

2156: IF (l_continuous_price_break_flag<>'Y' OR l_continuous_price_break_flag IS NULL )and l_list_line_type_code='PBH' THEN
2157: qp_delayed_requests_PVT.log_request
2158: ( p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
2159: , p_entity_id =>p_x_new_list_line_id
2160: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
2161: , p_requesting_entity_id => p_x_new_list_line_id
2162: , p_request_type => QP_Globals.G_UPGRADE_PRICE_BREAKS
2163: , p_param1 => null
2164: , p_param2 => null

Line 2162: , p_request_type => QP_Globals.G_UPGRADE_PRICE_BREAKS

2158: ( p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
2159: , p_entity_id =>p_x_new_list_line_id
2160: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
2161: , p_requesting_entity_id => p_x_new_list_line_id
2162: , p_request_type => QP_Globals.G_UPGRADE_PRICE_BREAKS
2163: , p_param1 => null
2164: , p_param2 => null
2165: , p_param3 => null
2166: , x_return_status => l_return_status);

Line 2170: ( p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR

2166: , x_return_status => l_return_status);
2167:
2168:
2169: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2170: ( p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
2171: , x_return_status => l_return_status);
2172: END IF;
2173: oe_debug_pub.add('QPXFPLAB - l_return_status = ' || l_return_status);
2174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN