DBA Data[Home] [Help]

APPS.OE_OE_FORM_PRICE_LLINE dependencies on OE_GLOBALS

Line 103: l_control_rec OE_GLOBALS.Control_Rec_Type;

99: IS
100: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
101: l_Price_LLine_val_rec OE_Price_List_PUB.Price_List_Line_Val_Rec_Type;
102: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
103: l_control_rec OE_GLOBALS.Control_Rec_Type;
104: l_return_status VARCHAR2(1);
105: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
106: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
107: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

Line 161: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_CREATE;

157: l_Price_LLine_rec.context := 'NULL';
158:
159: -- Set Operation to Create
160:
161: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_CREATE;
162:
163: -- Populate Price_LLine table
164:
165: l_Price_LLine_tbl(1) := l_Price_LLine_rec;

Line 437: l_control_rec OE_GLOBALS.Control_Rec_Type;

433: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
434: l_Price_LLine_val_rec OE_Price_List_PUB.Price_List_Line_Val_Rec_Type;
435: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
436: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
437: l_control_rec OE_GLOBALS.Control_Rec_Type;
438: l_return_status VARCHAR2(1);
439: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
440: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
441: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

Line 657: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

653: END IF;
654: oe_debug_pub.add('price list line id 5555 is : ');
655:
656: IF FND_API.To_Boolean(l_Price_LLine_rec.db_flag) THEN
657: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
658: ELSE
659: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_CREATE;
660: END IF;
661:

Line 659: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_CREATE;

655:
656: IF FND_API.To_Boolean(l_Price_LLine_rec.db_flag) THEN
657: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
658: ELSE
659: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_CREATE;
660: END IF;
661:
662: -- Populate Price_LLine table
663:

Line 774: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute1,

770: );
771:
772: -- Return changed attributes.
773:
774: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute1,
775: l_Price_LLine_rec.attribute1)
776: THEN
777: x_attribute1 := l_x_Price_LLine_rec.attribute1;
778: END IF;

Line 780: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute10,

776: THEN
777: x_attribute1 := l_x_Price_LLine_rec.attribute1;
778: END IF;
779:
780: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute10,
781: l_Price_LLine_rec.attribute10)
782: THEN
783: x_attribute10 := l_x_Price_LLine_rec.attribute10;
784: END IF;

Line 786: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute11,

782: THEN
783: x_attribute10 := l_x_Price_LLine_rec.attribute10;
784: END IF;
785:
786: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute11,
787: l_Price_LLine_rec.attribute11)
788: THEN
789: x_attribute11 := l_x_Price_LLine_rec.attribute11;
790: END IF;

Line 792: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute12,

788: THEN
789: x_attribute11 := l_x_Price_LLine_rec.attribute11;
790: END IF;
791:
792: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute12,
793: l_Price_LLine_rec.attribute12)
794: THEN
795: x_attribute12 := l_x_Price_LLine_rec.attribute12;
796: END IF;

Line 798: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute13,

794: THEN
795: x_attribute12 := l_x_Price_LLine_rec.attribute12;
796: END IF;
797:
798: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute13,
799: l_Price_LLine_rec.attribute13)
800: THEN
801: x_attribute13 := l_x_Price_LLine_rec.attribute13;
802: END IF;

Line 804: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute14,

800: THEN
801: x_attribute13 := l_x_Price_LLine_rec.attribute13;
802: END IF;
803:
804: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute14,
805: l_Price_LLine_rec.attribute14)
806: THEN
807: x_attribute14 := l_x_Price_LLine_rec.attribute14;
808: END IF;

Line 810: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute15,

806: THEN
807: x_attribute14 := l_x_Price_LLine_rec.attribute14;
808: END IF;
809:
810: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute15,
811: l_Price_LLine_rec.attribute15)
812: THEN
813: x_attribute15 := l_x_Price_LLine_rec.attribute15;
814: END IF;

Line 816: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute2,

812: THEN
813: x_attribute15 := l_x_Price_LLine_rec.attribute15;
814: END IF;
815:
816: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute2,
817: l_Price_LLine_rec.attribute2)
818: THEN
819: x_attribute2 := l_x_Price_LLine_rec.attribute2;
820: END IF;

Line 822: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute3,

818: THEN
819: x_attribute2 := l_x_Price_LLine_rec.attribute2;
820: END IF;
821:
822: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute3,
823: l_Price_LLine_rec.attribute3)
824: THEN
825: x_attribute3 := l_x_Price_LLine_rec.attribute3;
826: END IF;

Line 828: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute4,

824: THEN
825: x_attribute3 := l_x_Price_LLine_rec.attribute3;
826: END IF;
827:
828: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute4,
829: l_Price_LLine_rec.attribute4)
830: THEN
831: x_attribute4 := l_x_Price_LLine_rec.attribute4;
832: END IF;

Line 834: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute5,

830: THEN
831: x_attribute4 := l_x_Price_LLine_rec.attribute4;
832: END IF;
833:
834: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute5,
835: l_Price_LLine_rec.attribute5)
836: THEN
837: x_attribute5 := l_x_Price_LLine_rec.attribute5;
838: END IF;

Line 840: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute6,

836: THEN
837: x_attribute5 := l_x_Price_LLine_rec.attribute5;
838: END IF;
839:
840: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute6,
841: l_Price_LLine_rec.attribute6)
842: THEN
843: x_attribute6 := l_x_Price_LLine_rec.attribute6;
844: END IF;

Line 846: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute7,

842: THEN
843: x_attribute6 := l_x_Price_LLine_rec.attribute6;
844: END IF;
845:
846: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute7,
847: l_Price_LLine_rec.attribute7)
848: THEN
849: x_attribute7 := l_x_Price_LLine_rec.attribute7;
850: END IF;

Line 852: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute8,

848: THEN
849: x_attribute7 := l_x_Price_LLine_rec.attribute7;
850: END IF;
851:
852: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute8,
853: l_Price_LLine_rec.attribute8)
854: THEN
855: x_attribute8 := l_x_Price_LLine_rec.attribute8;
856: END IF;

Line 858: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute9,

854: THEN
855: x_attribute8 := l_x_Price_LLine_rec.attribute8;
856: END IF;
857:
858: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.attribute9,
859: l_Price_LLine_rec.attribute9)
860: THEN
861: x_attribute9 := l_x_Price_LLine_rec.attribute9;
862: END IF;

Line 864: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.comments,

860: THEN
861: x_attribute9 := l_x_Price_LLine_rec.attribute9;
862: END IF;
863:
864: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.comments,
865: l_Price_LLine_rec.comments)
866: THEN
867: x_comments := l_x_Price_LLine_rec.comments;
868: END IF;

Line 870: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.context,

866: THEN
867: x_comments := l_x_Price_LLine_rec.comments;
868: END IF;
869:
870: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.context,
871: l_Price_LLine_rec.context)
872: THEN
873: x_context := l_x_Price_LLine_rec.context;
874: END IF;

Line 876: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.customer_item_id,

872: THEN
873: x_context := l_x_Price_LLine_rec.context;
874: END IF;
875:
876: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.customer_item_id,
877: l_Price_LLine_rec.customer_item_id)
878: THEN
879: x_customer_item_id := l_x_Price_LLine_rec.customer_item_id;
880: x_customer_item := l_Price_LLine_val_rec.customer_item;

Line 883: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.end_date_active,

879: x_customer_item_id := l_x_Price_LLine_rec.customer_item_id;
880: x_customer_item := l_Price_LLine_val_rec.customer_item;
881: END IF;
882:
883: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.end_date_active,
884: l_Price_LLine_rec.end_date_active)
885: THEN
886: x_end_date_active := l_x_Price_LLine_rec.end_date_active;
887: END IF;

Line 889: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.inventory_item_id,

885: THEN
886: x_end_date_active := l_x_Price_LLine_rec.end_date_active;
887: END IF;
888:
889: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.inventory_item_id,
890: l_Price_LLine_rec.inventory_item_id)
891: THEN
892: x_inventory_item_id := l_x_Price_LLine_rec.inventory_item_id;
893: x_inventory_item := l_Price_LLine_val_rec.inventory_item;

Line 896: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.list_price,

892: x_inventory_item_id := l_x_Price_LLine_rec.inventory_item_id;
893: x_inventory_item := l_Price_LLine_val_rec.inventory_item;
894: END IF;
895:
896: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.list_price,
897: l_Price_LLine_rec.list_price)
898: THEN
899: x_list_price := l_x_Price_LLine_rec.list_price;
900: END IF;

Line 902: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.method_code,

898: THEN
899: x_list_price := l_x_Price_LLine_rec.list_price;
900: END IF;
901:
902: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.method_code,
903: l_Price_LLine_rec.method_code)
904: THEN
905: x_method_code := l_x_Price_LLine_rec.method_code;
906: x_method := l_Price_LLine_val_rec.method;

Line 909: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.price_list_id,

905: x_method_code := l_x_Price_LLine_rec.method_code;
906: x_method := l_Price_LLine_val_rec.method;
907: END IF;
908:
909: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.price_list_id,
910: l_Price_LLine_rec.price_list_id)
911: THEN
912: x_price_list_id := l_x_Price_LLine_rec.price_list_id;
913: x_price_list := l_Price_LLine_val_rec.price_list;

Line 916: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.price_list_line_id,

912: x_price_list_id := l_x_Price_LLine_rec.price_list_id;
913: x_price_list := l_Price_LLine_val_rec.price_list;
914: END IF;
915:
916: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.price_list_line_id,
917: l_Price_LLine_rec.price_list_line_id)
918: THEN
919: x_price_list_line_id := l_x_Price_LLine_rec.price_list_line_id;
920: x_price_list_line := l_Price_LLine_val_rec.price_list_line;

Line 923: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute1,

919: x_price_list_line_id := l_x_Price_LLine_rec.price_list_line_id;
920: x_price_list_line := l_Price_LLine_val_rec.price_list_line;
921: END IF;
922:
923: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute1,
924: l_Price_LLine_rec.pricing_attribute1)
925: THEN
926: x_pricing_attribute1 := l_x_Price_LLine_rec.pricing_attribute1;
927: END IF;

Line 929: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute10,

925: THEN
926: x_pricing_attribute1 := l_x_Price_LLine_rec.pricing_attribute1;
927: END IF;
928:
929: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute10,
930: l_Price_LLine_rec.pricing_attribute10)
931: THEN
932: x_pricing_attribute10 := l_x_Price_LLine_rec.pricing_attribute10;
933: END IF;

Line 935: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute11,

931: THEN
932: x_pricing_attribute10 := l_x_Price_LLine_rec.pricing_attribute10;
933: END IF;
934:
935: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute11,
936: l_Price_LLine_rec.pricing_attribute11)
937: THEN
938: x_pricing_attribute11 := l_x_Price_LLine_rec.pricing_attribute11;
939: END IF;

Line 941: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute12,

937: THEN
938: x_pricing_attribute11 := l_x_Price_LLine_rec.pricing_attribute11;
939: END IF;
940:
941: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute12,
942: l_Price_LLine_rec.pricing_attribute12)
943: THEN
944: x_pricing_attribute12 := l_x_Price_LLine_rec.pricing_attribute12;
945: END IF;

Line 947: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute13,

943: THEN
944: x_pricing_attribute12 := l_x_Price_LLine_rec.pricing_attribute12;
945: END IF;
946:
947: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute13,
948: l_Price_LLine_rec.pricing_attribute13)
949: THEN
950: x_pricing_attribute13 := l_x_Price_LLine_rec.pricing_attribute13;
951: END IF;

Line 953: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute14,

949: THEN
950: x_pricing_attribute13 := l_x_Price_LLine_rec.pricing_attribute13;
951: END IF;
952:
953: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute14,
954: l_Price_LLine_rec.pricing_attribute14)
955: THEN
956: x_pricing_attribute14 := l_x_Price_LLine_rec.pricing_attribute14;
957: END IF;

Line 959: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute15,

955: THEN
956: x_pricing_attribute14 := l_x_Price_LLine_rec.pricing_attribute14;
957: END IF;
958:
959: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute15,
960: l_Price_LLine_rec.pricing_attribute15)
961: THEN
962: x_pricing_attribute15 := l_x_Price_LLine_rec.pricing_attribute15;
963: END IF;

Line 965: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute2,

961: THEN
962: x_pricing_attribute15 := l_x_Price_LLine_rec.pricing_attribute15;
963: END IF;
964:
965: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute2,
966: l_Price_LLine_rec.pricing_attribute2)
967: THEN
968: x_pricing_attribute2 := l_x_Price_LLine_rec.pricing_attribute2;
969: END IF;

Line 971: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute3,

967: THEN
968: x_pricing_attribute2 := l_x_Price_LLine_rec.pricing_attribute2;
969: END IF;
970:
971: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute3,
972: l_Price_LLine_rec.pricing_attribute3)
973: THEN
974: x_pricing_attribute3 := l_x_Price_LLine_rec.pricing_attribute3;
975: END IF;

Line 977: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute4,

973: THEN
974: x_pricing_attribute3 := l_x_Price_LLine_rec.pricing_attribute3;
975: END IF;
976:
977: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute4,
978: l_Price_LLine_rec.pricing_attribute4)
979: THEN
980: x_pricing_attribute4 := l_x_Price_LLine_rec.pricing_attribute4;
981: END IF;

Line 983: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute5,

979: THEN
980: x_pricing_attribute4 := l_x_Price_LLine_rec.pricing_attribute4;
981: END IF;
982:
983: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute5,
984: l_Price_LLine_rec.pricing_attribute5)
985: THEN
986: x_pricing_attribute5 := l_x_Price_LLine_rec.pricing_attribute5;
987: END IF;

Line 989: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute6,

985: THEN
986: x_pricing_attribute5 := l_x_Price_LLine_rec.pricing_attribute5;
987: END IF;
988:
989: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute6,
990: l_Price_LLine_rec.pricing_attribute6)
991: THEN
992: x_pricing_attribute6 := l_x_Price_LLine_rec.pricing_attribute6;
993: END IF;

Line 995: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute7,

991: THEN
992: x_pricing_attribute6 := l_x_Price_LLine_rec.pricing_attribute6;
993: END IF;
994:
995: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute7,
996: l_Price_LLine_rec.pricing_attribute7)
997: THEN
998: x_pricing_attribute7 := l_x_Price_LLine_rec.pricing_attribute7;
999: END IF;

Line 1001: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute8,

997: THEN
998: x_pricing_attribute7 := l_x_Price_LLine_rec.pricing_attribute7;
999: END IF;
1000:
1001: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute8,
1002: l_Price_LLine_rec.pricing_attribute8)
1003: THEN
1004: x_pricing_attribute8 := l_x_Price_LLine_rec.pricing_attribute8;
1005: END IF;

Line 1007: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute9,

1003: THEN
1004: x_pricing_attribute8 := l_x_Price_LLine_rec.pricing_attribute8;
1005: END IF;
1006:
1007: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_attribute9,
1008: l_Price_LLine_rec.pricing_attribute9)
1009: THEN
1010: x_pricing_attribute9 := l_x_Price_LLine_rec.pricing_attribute9;
1011: END IF;

Line 1013: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_context,

1009: THEN
1010: x_pricing_attribute9 := l_x_Price_LLine_rec.pricing_attribute9;
1011: END IF;
1012:
1013: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_context,
1014: l_Price_LLine_rec.pricing_context)
1015: THEN
1016: x_pricing_context := l_x_Price_LLine_rec.pricing_context;
1017: END IF;

Line 1019: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_rule_id,

1015: THEN
1016: x_pricing_context := l_x_Price_LLine_rec.pricing_context;
1017: END IF;
1018:
1019: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.pricing_rule_id,
1020: l_Price_LLine_rec.pricing_rule_id)
1021: THEN
1022: x_pricing_rule_id := l_x_Price_LLine_rec.pricing_rule_id;
1023: x_pricing_rule := l_Price_LLine_val_rec.pricing_rule;

Line 1026: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.reprice_flag,

1022: x_pricing_rule_id := l_x_Price_LLine_rec.pricing_rule_id;
1023: x_pricing_rule := l_Price_LLine_val_rec.pricing_rule;
1024: END IF;
1025:
1026: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.reprice_flag,
1027: l_Price_LLine_rec.reprice_flag)
1028: THEN
1029: x_reprice_flag := l_x_Price_LLine_rec.reprice_flag;
1030: x_reprice := l_Price_LLine_val_rec.reprice;

Line 1033: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.revision,

1029: x_reprice_flag := l_x_Price_LLine_rec.reprice_flag;
1030: x_reprice := l_Price_LLine_val_rec.reprice;
1031: END IF;
1032:
1033: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.revision,
1034: l_Price_LLine_rec.revision)
1035: THEN
1036: x_revision := l_x_Price_LLine_rec.revision;
1037: END IF;

Line 1039: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.revision_date,

1035: THEN
1036: x_revision := l_x_Price_LLine_rec.revision;
1037: END IF;
1038:
1039: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.revision_date,
1040: l_Price_LLine_rec.revision_date)
1041: THEN
1042: x_revision_date := l_x_Price_LLine_rec.revision_date;
1043: END IF;

Line 1045: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.revision_reason_code,

1041: THEN
1042: x_revision_date := l_x_Price_LLine_rec.revision_date;
1043: END IF;
1044:
1045: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.revision_reason_code,
1046: l_Price_LLine_rec.revision_reason_code)
1047: THEN
1048: x_revision_reason_code := l_x_Price_LLine_rec.revision_reason_code;
1049: x_revision_reason := l_Price_LLine_val_rec.revision_reason;

Line 1054: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.creation_date,

1050: END IF;
1051:
1052: -- New Add
1053:
1054: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.creation_date,
1055: l_Price_LLine_rec.creation_date)
1056: THEN
1057: x_creation_date := l_x_Price_LLine_rec.creation_date;
1058: END IF;

Line 1061: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.start_date_active,

1057: x_creation_date := l_x_Price_LLine_rec.creation_date;
1058: END IF;
1059:
1060:
1061: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.start_date_active,
1062: l_Price_LLine_rec.start_date_active)
1063: THEN
1064: x_start_date_active := l_x_Price_LLine_rec.start_date_active;
1065: END IF;

Line 1067: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.unit_code,

1063: THEN
1064: x_start_date_active := l_x_Price_LLine_rec.start_date_active;
1065: END IF;
1066:
1067: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.unit_code,
1068: l_Price_LLine_rec.unit_code)
1069: THEN
1070: x_unit_code := l_x_Price_LLine_rec.unit_code;
1071: x_unit := l_Price_LLine_val_rec.unit;

Line 1074: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.primary,

1070: x_unit_code := l_x_Price_LLine_rec.unit_code;
1071: x_unit := l_Price_LLine_val_rec.unit;
1072: END IF;
1073:
1074: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.primary,
1075: l_Price_LLine_rec.primary)
1076: THEN
1077: x_primary := l_x_Price_LLine_rec.primary;
1078: END IF;

Line 1080: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.list_line_type_code,

1076: THEN
1077: x_primary := l_x_Price_LLine_rec.primary;
1078: END IF;
1079:
1080: IF NOT OE_GLOBALS.Equal(l_x_Price_LLine_rec.list_line_type_code,
1081: l_Price_LLine_rec.list_line_type_code)
1082: THEN
1083: x_list_line_type_code := l_x_Price_LLine_rec.list_line_type_code;
1084: END IF;

Line 1176: l_control_rec OE_GLOBALS.Control_Rec_Type;

1172: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1173: l_old_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1174: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1175: l_old_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1176: l_control_rec OE_GLOBALS.Control_Rec_Type;
1177: l_return_status VARCHAR2(1);
1178: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1179: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1180: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

Line 1228: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

1224: 'Price_List_Line_Id: ' || l_Price_LLine_rec.price_list_line_id);
1225: -- Set Operation.
1226:
1227: IF FND_API.To_Boolean(l_Price_LLine_rec.db_flag) THEN
1228: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1229: ELSE
1230: oe_debug_pub.add('create price list line');
1231: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1232: END IF;

Line 1231: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_CREATE;

1227: IF FND_API.To_Boolean(l_Price_LLine_rec.db_flag) THEN
1228: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1229: ELSE
1230: oe_debug_pub.add('create price list line');
1231: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1232: END IF;
1233:
1234: --Revision Control S
1235: IF ( ( l_old_Price_LLine_rec.revision <> FND_API.G_MISS_CHAR )

Line 1251: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_CREATE;

1247: oe_debug_pub.add('new revision is also null');
1248: END IF;
1249:
1250: select qp_list_lines_s.nextval into l_Price_LLine_rec.price_list_line_id from dual;
1251: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1252: l_Price_LLine_rec.db_flag := FND_API.G_FALSE;
1253: END IF;
1254: --Revision Control E
1255:

Line 1378: l_control_rec OE_GLOBALS.Control_Rec_Type;

1374: )
1375: IS
1376: l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1377: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1378: l_control_rec OE_GLOBALS.Control_Rec_Type;
1379: l_return_status VARCHAR2(1);
1380: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1381: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1382: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

Line 1418: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_DELETE;

1414: );
1415:
1416: -- Set Operation.
1417:
1418: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1419:
1420: -- Populate Price_LLine table
1421:
1422: l_Price_LLine_tbl(1) := l_Price_LLine_rec;

Line 1521: l_control_rec OE_GLOBALS.Control_Rec_Type;

1517: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1518: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1519: )
1520: IS
1521: l_control_rec OE_GLOBALS.Control_Rec_Type;
1522: l_return_status VARCHAR2(1);
1523: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1524: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1525: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

Line 1543: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_PRICE_LLINE;

1539: -- Set control flags.
1540:
1541: l_control_rec.controlled_operation := TRUE;
1542: l_control_rec.process := TRUE;
1543: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_PRICE_LLINE;
1544:
1545: l_control_rec.default_attributes := FALSE;
1546: l_control_rec.change_attributes := FALSE;
1547: l_control_rec.validate_entity := FALSE;