DBA Data[Home] [Help]

APPS.QP_QP_FORM_PRICE_LIST dependencies on QP_GLOBALS

Line 100: l_control_rec QP_GLOBALS.Control_Rec_Type;

96: )
97: IS
98: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
99: l_PRICE_LIST_val_rec QP_Price_List_PUB.Price_List_Val_Rec_Type;
100: l_control_rec QP_GLOBALS.Control_Rec_Type;
101: l_return_status VARCHAR2(1);
102: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
103: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
104: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 157: l_PRICE_LIST_rec.operation := QP_GLOBALS.G_OPR_CREATE;

153: l_PRICE_LIST_rec.context := NULL;
154:
155: -- Set Operation to Create
156:
157: l_PRICE_LIST_rec.operation := QP_GLOBALS.G_OPR_CREATE;
158:
159: -- Call QP_LIST_HEADERS_PVT.Process_PRICE_LIST
160:
161: QP_LIST_HEADERS_PVT.Process_PRICE_LIST

Line 417: l_control_rec QP_GLOBALS.Control_Rec_Type;

413: IS
414: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
415: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
416: l_PRICE_LIST_val_rec QP_Price_List_PUB.Price_List_Val_Rec_Type;
417: l_control_rec QP_GLOBALS.Control_Rec_Type;
418: l_return_status VARCHAR2(1);
419: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
420: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
421: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 571: l_PRICE_LIST_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

567:
568: -- Set Operation.
569:
570: IF FND_API.To_Boolean(l_PRICE_LIST_rec.db_flag) THEN
571: l_PRICE_LIST_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
572: ELSE
573: l_PRICE_LIST_rec.operation := QP_GLOBALS.G_OPR_CREATE;
574: END IF;
575:

Line 573: l_PRICE_LIST_rec.operation := QP_GLOBALS.G_OPR_CREATE;

569:
570: IF FND_API.To_Boolean(l_PRICE_LIST_rec.db_flag) THEN
571: l_PRICE_LIST_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
572: ELSE
573: l_PRICE_LIST_rec.operation := QP_GLOBALS.G_OPR_CREATE;
574: END IF;
575:
576: -- Call QP_LIST_HEADERS_PVT.Process_PRICE_LIST
577:

Line 670: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute1,

666: );
667:
668: -- Return changed attributes.
669:
670: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute1,
671: l_PRICE_LIST_rec.attribute1)
672: THEN
673: x_attribute1 := l_x_PRICE_LIST_rec.attribute1;
674: END IF;

Line 676: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute10,

672: THEN
673: x_attribute1 := l_x_PRICE_LIST_rec.attribute1;
674: END IF;
675:
676: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute10,
677: l_PRICE_LIST_rec.attribute10)
678: THEN
679: x_attribute10 := l_x_PRICE_LIST_rec.attribute10;
680: END IF;

Line 682: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute11,

678: THEN
679: x_attribute10 := l_x_PRICE_LIST_rec.attribute10;
680: END IF;
681:
682: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute11,
683: l_PRICE_LIST_rec.attribute11)
684: THEN
685: x_attribute11 := l_x_PRICE_LIST_rec.attribute11;
686: END IF;

Line 688: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute12,

684: THEN
685: x_attribute11 := l_x_PRICE_LIST_rec.attribute11;
686: END IF;
687:
688: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute12,
689: l_PRICE_LIST_rec.attribute12)
690: THEN
691: x_attribute12 := l_x_PRICE_LIST_rec.attribute12;
692: END IF;

Line 694: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute13,

690: THEN
691: x_attribute12 := l_x_PRICE_LIST_rec.attribute12;
692: END IF;
693:
694: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute13,
695: l_PRICE_LIST_rec.attribute13)
696: THEN
697: x_attribute13 := l_x_PRICE_LIST_rec.attribute13;
698: END IF;

Line 700: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute14,

696: THEN
697: x_attribute13 := l_x_PRICE_LIST_rec.attribute13;
698: END IF;
699:
700: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute14,
701: l_PRICE_LIST_rec.attribute14)
702: THEN
703: x_attribute14 := l_x_PRICE_LIST_rec.attribute14;
704: END IF;

Line 706: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute15,

702: THEN
703: x_attribute14 := l_x_PRICE_LIST_rec.attribute14;
704: END IF;
705:
706: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute15,
707: l_PRICE_LIST_rec.attribute15)
708: THEN
709: x_attribute15 := l_x_PRICE_LIST_rec.attribute15;
710: END IF;

Line 712: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute2,

708: THEN
709: x_attribute15 := l_x_PRICE_LIST_rec.attribute15;
710: END IF;
711:
712: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute2,
713: l_PRICE_LIST_rec.attribute2)
714: THEN
715: x_attribute2 := l_x_PRICE_LIST_rec.attribute2;
716: END IF;

Line 718: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute3,

714: THEN
715: x_attribute2 := l_x_PRICE_LIST_rec.attribute2;
716: END IF;
717:
718: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute3,
719: l_PRICE_LIST_rec.attribute3)
720: THEN
721: x_attribute3 := l_x_PRICE_LIST_rec.attribute3;
722: END IF;

Line 724: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute4,

720: THEN
721: x_attribute3 := l_x_PRICE_LIST_rec.attribute3;
722: END IF;
723:
724: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute4,
725: l_PRICE_LIST_rec.attribute4)
726: THEN
727: x_attribute4 := l_x_PRICE_LIST_rec.attribute4;
728: END IF;

Line 730: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute5,

726: THEN
727: x_attribute4 := l_x_PRICE_LIST_rec.attribute4;
728: END IF;
729:
730: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute5,
731: l_PRICE_LIST_rec.attribute5)
732: THEN
733: x_attribute5 := l_x_PRICE_LIST_rec.attribute5;
734: END IF;

Line 736: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute6,

732: THEN
733: x_attribute5 := l_x_PRICE_LIST_rec.attribute5;
734: END IF;
735:
736: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute6,
737: l_PRICE_LIST_rec.attribute6)
738: THEN
739: x_attribute6 := l_x_PRICE_LIST_rec.attribute6;
740: END IF;

Line 742: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute7,

738: THEN
739: x_attribute6 := l_x_PRICE_LIST_rec.attribute6;
740: END IF;
741:
742: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute7,
743: l_PRICE_LIST_rec.attribute7)
744: THEN
745: x_attribute7 := l_x_PRICE_LIST_rec.attribute7;
746: END IF;

Line 748: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute8,

744: THEN
745: x_attribute7 := l_x_PRICE_LIST_rec.attribute7;
746: END IF;
747:
748: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute8,
749: l_PRICE_LIST_rec.attribute8)
750: THEN
751: x_attribute8 := l_x_PRICE_LIST_rec.attribute8;
752: END IF;

Line 754: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute9,

750: THEN
751: x_attribute8 := l_x_PRICE_LIST_rec.attribute8;
752: END IF;
753:
754: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.attribute9,
755: l_PRICE_LIST_rec.attribute9)
756: THEN
757: x_attribute9 := l_x_PRICE_LIST_rec.attribute9;
758: END IF;

Line 760: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.automatic_flag,

756: THEN
757: x_attribute9 := l_x_PRICE_LIST_rec.attribute9;
758: END IF;
759:
760: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.automatic_flag,
761: l_PRICE_LIST_rec.automatic_flag)
762: THEN
763: x_automatic_flag := l_x_PRICE_LIST_rec.automatic_flag;
764: x_automatic := l_PRICE_LIST_val_rec.automatic;

Line 767: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.comments,

763: x_automatic_flag := l_x_PRICE_LIST_rec.automatic_flag;
764: x_automatic := l_PRICE_LIST_val_rec.automatic;
765: END IF;
766:
767: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.comments,
768: l_PRICE_LIST_rec.comments)
769: THEN
770: x_comments := l_x_PRICE_LIST_rec.comments;
771: END IF;

Line 773: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.context,

769: THEN
770: x_comments := l_x_PRICE_LIST_rec.comments;
771: END IF;
772:
773: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.context,
774: l_PRICE_LIST_rec.context)
775: THEN
776: x_context := l_x_PRICE_LIST_rec.context;
777: END IF;

Line 779: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.currency_code,

775: THEN
776: x_context := l_x_PRICE_LIST_rec.context;
777: END IF;
778:
779: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.currency_code,
780: l_PRICE_LIST_rec.currency_code)
781: THEN
782: x_currency_code := l_x_PRICE_LIST_rec.currency_code;
783: x_currency := l_PRICE_LIST_val_rec.currency;

Line 786: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.discount_lines_flag,

782: x_currency_code := l_x_PRICE_LIST_rec.currency_code;
783: x_currency := l_PRICE_LIST_val_rec.currency;
784: END IF;
785:
786: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.discount_lines_flag,
787: l_PRICE_LIST_rec.discount_lines_flag)
788: THEN
789: x_discount_lines_flag := l_x_PRICE_LIST_rec.discount_lines_flag;
790: x_discount_lines := l_PRICE_LIST_val_rec.discount_lines;

Line 793: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.end_date_active,

789: x_discount_lines_flag := l_x_PRICE_LIST_rec.discount_lines_flag;
790: x_discount_lines := l_PRICE_LIST_val_rec.discount_lines;
791: END IF;
792:
793: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.end_date_active,
794: l_PRICE_LIST_rec.end_date_active)
795: THEN
796: x_end_date_active := l_x_PRICE_LIST_rec.end_date_active;
797: END IF;

Line 799: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.freight_terms_code,

795: THEN
796: x_end_date_active := l_x_PRICE_LIST_rec.end_date_active;
797: END IF;
798:
799: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.freight_terms_code,
800: l_PRICE_LIST_rec.freight_terms_code)
801: THEN
802: x_freight_terms_code := l_x_PRICE_LIST_rec.freight_terms_code;
803: x_freight_terms := l_PRICE_LIST_val_rec.freight_terms;

Line 806: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.gsa_indicator,

802: x_freight_terms_code := l_x_PRICE_LIST_rec.freight_terms_code;
803: x_freight_terms := l_PRICE_LIST_val_rec.freight_terms;
804: END IF;
805:
806: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.gsa_indicator,
807: l_PRICE_LIST_rec.gsa_indicator)
808: THEN
809: x_gsa_indicator := l_x_PRICE_LIST_rec.gsa_indicator;
810: END IF;

Line 812: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.list_header_id,

808: THEN
809: x_gsa_indicator := l_x_PRICE_LIST_rec.gsa_indicator;
810: END IF;
811:
812: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.list_header_id,
813: l_PRICE_LIST_rec.list_header_id)
814: THEN
815: x_list_header_id := l_x_PRICE_LIST_rec.list_header_id;
816: x_list_header := l_PRICE_LIST_val_rec.list_header;

Line 819: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.list_type_code,

815: x_list_header_id := l_x_PRICE_LIST_rec.list_header_id;
816: x_list_header := l_PRICE_LIST_val_rec.list_header;
817: END IF;
818:
819: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.list_type_code,
820: l_PRICE_LIST_rec.list_type_code)
821: THEN
822: x_list_type_code := l_x_PRICE_LIST_rec.list_type_code;
823: x_list_type := l_PRICE_LIST_val_rec.list_type;

Line 826: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.version_no,

822: x_list_type_code := l_x_PRICE_LIST_rec.list_type_code;
823: x_list_type := l_PRICE_LIST_val_rec.list_type;
824: END IF;
825:
826: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.version_no,
827: l_PRICE_LIST_rec.version_no)
828: THEN
829: x_version_no := l_x_PRICE_LIST_rec.version_no;
830: END IF;

Line 832: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.active_flag,

828: THEN
829: x_version_no := l_x_PRICE_LIST_rec.version_no;
830: END IF;
831: -- added active_flag
832: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.active_flag,
833: l_PRICE_LIST_rec.active_flag)
834: THEN
835: x_active_flag := l_x_PRICE_LIST_rec.active_flag;
836: END IF;

Line 838: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.mobile_download,

834: THEN
835: x_active_flag := l_x_PRICE_LIST_rec.active_flag;
836: END IF;
837: -- mkarya for bug 1944882 - added mobile_download
838: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.mobile_download,
839: l_PRICE_LIST_rec.mobile_download)
840: THEN
841: x_mobile_download := l_x_PRICE_LIST_rec.mobile_download;
842: END IF;

Line 844: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.prorate_flag,

840: THEN
841: x_mobile_download := l_x_PRICE_LIST_rec.mobile_download;
842: END IF;
843:
844: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.prorate_flag,
845: l_PRICE_LIST_rec.prorate_flag)
846: THEN
847: x_prorate_flag := l_x_PRICE_LIST_rec.prorate_flag;
848: x_prorate := l_PRICE_LIST_val_rec.prorate;

Line 851: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.rounding_factor,

847: x_prorate_flag := l_x_PRICE_LIST_rec.prorate_flag;
848: x_prorate := l_PRICE_LIST_val_rec.prorate;
849: END IF;
850:
851: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.rounding_factor,
852: l_PRICE_LIST_rec.rounding_factor)
853: THEN
854: x_rounding_factor := l_x_PRICE_LIST_rec.rounding_factor;
855: END IF;

Line 857: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.ship_method_code,

853: THEN
854: x_rounding_factor := l_x_PRICE_LIST_rec.rounding_factor;
855: END IF;
856:
857: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.ship_method_code,
858: l_PRICE_LIST_rec.ship_method_code)
859: THEN
860: x_ship_method_code := l_x_PRICE_LIST_rec.ship_method_code;
861: x_ship_method := l_PRICE_LIST_val_rec.ship_method;

Line 864: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.start_date_active,

860: x_ship_method_code := l_x_PRICE_LIST_rec.ship_method_code;
861: x_ship_method := l_PRICE_LIST_val_rec.ship_method;
862: END IF;
863:
864: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.start_date_active,
865: l_PRICE_LIST_rec.start_date_active)
866: THEN
867: x_start_date_active := l_x_PRICE_LIST_rec.start_date_active;
868: END IF;

Line 870: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.terms_id,

866: THEN
867: x_start_date_active := l_x_PRICE_LIST_rec.start_date_active;
868: END IF;
869:
870: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.terms_id,
871: l_PRICE_LIST_rec.terms_id)
872: THEN
873: x_terms_id := l_x_PRICE_LIST_rec.terms_id;
874: x_terms := l_PRICE_LIST_val_rec.terms;

Line 877: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.name,

873: x_terms_id := l_x_PRICE_LIST_rec.terms_id;
874: x_terms := l_PRICE_LIST_val_rec.terms;
875: END IF;
876:
877: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.name,
878: l_PRICE_LIST_rec.name)
879: THEN
880: x_name := l_x_PRICE_LIST_rec.name;
881: END IF;

Line 883: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.description,

879: THEN
880: x_name := l_x_PRICE_LIST_rec.name;
881: END IF;
882:
883: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.description,
884: l_PRICE_LIST_rec.description)
885: THEN
886: x_description := l_x_PRICE_LIST_rec.description;
887: END IF;

Line 890: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.currency_header_id,

886: x_description := l_x_PRICE_LIST_rec.description;
887: END IF;
888:
889: -- Multi-Currency SunilPandey
890: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.currency_header_id,
891: l_PRICE_LIST_rec.currency_header_id)
892: THEN
893: x_currency_header_id := l_x_PRICE_LIST_rec.currency_header_id;
894: x_currency_header := l_PRICE_LIST_val_rec.currency_header;

Line 898: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.pte_code,

894: x_currency_header := l_PRICE_LIST_val_rec.currency_header;
895: END IF;
896:
897: -- Attribute Manager Giri
898: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.pte_code,
899: l_PRICE_LIST_rec.pte_code)
900: THEN
901: x_pte_code := l_x_PRICE_LIST_rec.pte_code;
902: x_pte := l_PRICE_LIST_val_rec.pte;

Line 906: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.list_source_code,

902: x_pte := l_PRICE_LIST_val_rec.pte;
903: END IF;
904:
905: -- Blanket Sales Order
906: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.list_source_code,
907: l_PRICE_LIST_rec.list_source_code)
908: THEN
909: x_list_source_code := l_x_PRICE_LIST_rec.list_source_code;
910: x_orig_system_header_ref := l_PRICE_LIST_val_rec.orig_system_header_ref;

Line 914: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.global_flag,

910: x_orig_system_header_ref := l_PRICE_LIST_val_rec.orig_system_header_ref;
911: END IF;
912:
913: -- Pricing Security gtippire
914: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.global_flag,
915: l_PRICE_LIST_rec.global_flag)
916: THEN
917: x_global_flag := l_x_PRICE_LIST_rec.global_flag;
918: END IF;

Line 921: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.source_system_code,

917: x_global_flag := l_x_PRICE_LIST_rec.global_flag;
918: END IF;
919:
920: -- Blanket Pricing
921: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.source_system_code,
922: l_PRICE_LIST_rec.source_system_code)
923: THEN
924: x_source_system_code := l_x_PRICE_LIST_rec.source_system_code;
925: END IF;

Line 927: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.shareable_flag,

923: THEN
924: x_source_system_code := l_x_PRICE_LIST_rec.source_system_code;
925: END IF;
926:
927: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.shareable_flag,
928: l_PRICE_LIST_rec.shareable_flag)
929: THEN
930: x_shareable_flag := l_x_PRICE_LIST_rec.shareable_flag;
931: END IF;

Line 933: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.sold_to_org_id,

929: THEN
930: x_shareable_flag := l_x_PRICE_LIST_rec.shareable_flag;
931: END IF;
932:
933: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.sold_to_org_id,
934: l_PRICE_LIST_rec.sold_to_org_id)
935: THEN
936: x_sold_to_org_id := l_x_PRICE_LIST_rec.sold_to_org_id;
937: END IF;

Line 939: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.locked_from_list_header_id,

935: THEN
936: x_sold_to_org_id := l_x_PRICE_LIST_rec.sold_to_org_id;
937: END IF;
938:
939: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.locked_from_list_header_id,
940: l_PRICE_LIST_rec.locked_from_list_header_id)
941: THEN
942: x_locked_from_list_header_id :=
943: l_x_PRICE_LIST_rec.locked_from_list_header_id;

Line 947: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.org_id,

943: l_x_PRICE_LIST_rec.locked_from_list_header_id;
944: END IF;
945:
946: --added for MOAC
947: IF NOT QP_GLOBALS.Equal(l_x_PRICE_LIST_rec.org_id,
948: l_PRICE_LIST_rec.org_id)
949: THEN
950: x_org_id := l_x_PRICE_LIST_rec.org_id;
951: END IF;

Line 1037: l_control_rec QP_GLOBALS.Control_Rec_Type;

1033: )
1034: IS
1035: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1036: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1037: l_control_rec QP_GLOBALS.Control_Rec_Type;
1038: l_return_status VARCHAR2(1);
1039: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1040: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1041: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1078: l_PRICE_LIST_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

1074:
1075: -- Set Operation.
1076:
1077: IF FND_API.To_Boolean(l_PRICE_LIST_rec.db_flag) THEN
1078: l_PRICE_LIST_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
1079: ELSE
1080: l_PRICE_LIST_rec.operation := QP_GLOBALS.G_OPR_CREATE;
1081: END IF;
1082:

Line 1080: l_PRICE_LIST_rec.operation := QP_GLOBALS.G_OPR_CREATE;

1076:
1077: IF FND_API.To_Boolean(l_PRICE_LIST_rec.db_flag) THEN
1078: l_PRICE_LIST_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
1079: ELSE
1080: l_PRICE_LIST_rec.operation := QP_GLOBALS.G_OPR_CREATE;
1081: END IF;
1082:
1083: -- Call QP_LIST_HEADERS_PVT.Process_PRICE_LIST
1084:

Line 1197: l_control_rec QP_GLOBALS.Control_Rec_Type;

1193: , p_list_header_id IN NUMBER
1194: )
1195: IS
1196: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1197: l_control_rec QP_GLOBALS.Control_Rec_Type;
1198: l_return_status VARCHAR2(1);
1199: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1200: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1201: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1232: l_PRICE_LIST_rec.operation := QP_GLOBALS.G_OPR_DELETE;

1228: );
1229:
1230: -- Set Operation.
1231:
1232: l_PRICE_LIST_rec.operation := QP_GLOBALS.G_OPR_DELETE;
1233:
1234: -- Call QP_LIST_HEADERS_PVT.Process_PRICE_LIST
1235:
1236: QP_LIST_HEADERS_PVT.Process_PRICE_LIST

Line 1327: l_control_rec QP_GLOBALS.Control_Rec_Type;

1323: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1324: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1325: )
1326: IS
1327: l_control_rec QP_GLOBALS.Control_Rec_Type;
1328: l_return_status VARCHAR2(1);
1329: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1330: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1331: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1342: l_control_rec.process_entity := QP_GLOBALS.G_ENTITY_PRICE_LIST;

1338: -- Set control flags.
1339:
1340: l_control_rec.controlled_operation := TRUE;
1341: l_control_rec.process := TRUE;
1342: l_control_rec.process_entity := QP_GLOBALS.G_ENTITY_PRICE_LIST;
1343:
1344: l_control_rec.default_attributes := FALSE;
1345: l_control_rec.change_attributes := FALSE;
1346: l_control_rec.validate_entity := FALSE;

Line 1442: l_control_rec QP_GLOBALS.Control_Rec_Type;

1438: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1439: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1440: )
1441: IS
1442: l_control_rec QP_GLOBALS.Control_Rec_Type;
1443: l_return_status VARCHAR2(1);
1444: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1445: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1446: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1457: l_control_rec.process_entity := QP_GLOBALS.G_ENTITY_ALL;

1453: -- Set control flags.
1454:
1455: l_control_rec.controlled_operation := TRUE;
1456: l_control_rec.process := TRUE;
1457: l_control_rec.process_entity := QP_GLOBALS.G_ENTITY_ALL;
1458:
1459: l_control_rec.default_attributes := FALSE;
1460: l_control_rec.change_attributes := FALSE;
1461: l_control_rec.validate_entity := FALSE;

Line 1676: l_PRICE_LIST_rec.operation := QP_GLOBALS.G_OPR_LOCK;

1672: l_PRICE_LIST_rec.active_flag := p_active_flag;
1673: l_PRICE_LIST_rec.mobile_download := p_mobile_download; -- mkarya for bug 1944882
1674: l_PRICE_LIST_rec.currency_header_id := p_currency_header_id; -- Multi-Currency SunilPandey
1675: l_PRICE_LIST_rec.pte_code := p_pte_code; -- Attribute Manager Giri
1676: l_PRICE_LIST_rec.operation := QP_GLOBALS.G_OPR_LOCK;
1677: l_PRICE_LIST_rec.list_source_code := p_list_source_code ; --Blanket Sales Order
1678: l_PRICE_LIST_rec.orig_system_header_ref := p_orig_system_header_ref ; --Blanket Sales Order
1679: l_PRICE_LIST_rec.global_flag := p_global_flag ; --Pricing Security gtippire
1680: l_PRICE_LIST_rec.source_system_code := p_source_system_code;

Line 1830: p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST

1826: BEGIN
1827: OE_MSG_PUB.initialize;
1828: x_return_status := FND_API.G_RET_STS_SUCCESS;
1829: QP_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
1830: p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST
1831: ,p_entity_id => p_list_header_id
1832: ,x_return_status => l_return_status);
1833:
1834: OE_MSG_PUB.Count_And_Get