[Home] [Help]
900: -- , x_Line_Price_Att_rec OUT OE_Order_PUB.Line_Price_Att_Rec_Type
901: )
902: IS
903: l_index NUMBER := 0;
904: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
905: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
906: BEGIN
907:
908: -- Load out record
901: )
902: IS
903: l_index NUMBER := 0;
904: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
905: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
906: BEGIN
907:
908: -- Load out record
909:
913: -- every changed attribute clear its dependent fields.
914:
915: IF p_attr_id = FND_API.G_MISS_NUM THEN
916:
917: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute1,p_old_Line_price_att_rec.attribute1)
918: THEN
919: l_index := l_index + 1;
920: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE1;
921: END IF;
919: l_index := l_index + 1;
920: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE1;
921: END IF;
922:
923: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute10,p_old_Line_price_att_rec.attribute10)
924: THEN
925: l_index := l_index + 1;
926: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE10;
927: END IF;
925: l_index := l_index + 1;
926: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE10;
927: END IF;
928:
929: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute11,p_old_Line_price_att_rec.attribute11)
930: THEN
931: l_index := l_index + 1;
932: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE11;
933: END IF;
931: l_index := l_index + 1;
932: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE11;
933: END IF;
934:
935: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute12,p_old_Line_price_att_rec.attribute12)
936: THEN
937: l_index := l_index + 1;
938: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE12;
939: END IF;
937: l_index := l_index + 1;
938: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE12;
939: END IF;
940:
941: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute13,p_old_Line_price_att_rec.attribute13)
942: THEN
943: l_index := l_index + 1;
944: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE13;
945: END IF;
943: l_index := l_index + 1;
944: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE13;
945: END IF;
946:
947: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute14,p_old_Line_price_att_rec.attribute14)
948: THEN
949: l_index := l_index + 1;
950: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE14;
951: END IF;
949: l_index := l_index + 1;
950: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE14;
951: END IF;
952:
953: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute15,p_old_Line_price_att_rec.attribute15)
954: THEN
955: l_index := l_index + 1;
956: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE15;
957: END IF;
955: l_index := l_index + 1;
956: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE15;
957: END IF;
958:
959: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute2,p_old_Line_price_att_rec.attribute2)
960: THEN
961: l_index := l_index + 1;
962: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE2;
963: END IF;
961: l_index := l_index + 1;
962: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE2;
963: END IF;
964:
965: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute3,p_old_Line_price_att_rec.attribute3)
966: THEN
967: l_index := l_index + 1;
968: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE3;
969: END IF;
967: l_index := l_index + 1;
968: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE3;
969: END IF;
970:
971: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute4,p_old_Line_price_att_rec.attribute4)
972: THEN
973: l_index := l_index + 1;
974: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE4;
975: END IF;
973: l_index := l_index + 1;
974: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE4;
975: END IF;
976:
977: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute5,p_old_Line_price_att_rec.attribute5)
978: THEN
979: l_index := l_index + 1;
980: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE5;
981: END IF;
979: l_index := l_index + 1;
980: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE5;
981: END IF;
982:
983: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute6,p_old_Line_price_att_rec.attribute6)
984: THEN
985: l_index := l_index + 1;
986: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE6;
987: END IF;
985: l_index := l_index + 1;
986: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE6;
987: END IF;
988:
989: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute7,p_old_Line_price_att_rec.attribute7)
990: THEN
991: l_index := l_index + 1;
992: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE7;
993: END IF;
991: l_index := l_index + 1;
992: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE7;
993: END IF;
994:
995: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute8,p_old_Line_price_att_rec.attribute8)
996: THEN
997: l_index := l_index + 1;
998: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE8;
999: END IF;
997: l_index := l_index + 1;
998: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE8;
999: END IF;
1000:
1001: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute9,p_old_Line_price_att_rec.attribute9)
1002: THEN
1003: l_index := l_index + 1;
1004: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE9;
1005: END IF;
1003: l_index := l_index + 1;
1004: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE9;
1005: END IF;
1006:
1007: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.context,p_old_Line_price_att_rec.context)
1008: THEN
1009: l_index := l_index + 1;
1010: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_CONTEXT;
1011: END IF;
1009: l_index := l_index + 1;
1010: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_CONTEXT;
1011: END IF;
1012:
1013: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.created_by,p_old_Line_price_att_rec.created_by)
1014: THEN
1015: l_index := l_index + 1;
1016: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_CREATED_BY;
1017: END IF;
1015: l_index := l_index + 1;
1016: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_CREATED_BY;
1017: END IF;
1018:
1019: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.creation_date,p_old_Line_price_att_rec.creation_date)
1020: THEN
1021: l_index := l_index + 1;
1022: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_CREATION_DATE;
1023: END IF;
1021: l_index := l_index + 1;
1022: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_CREATION_DATE;
1023: END IF;
1024:
1025: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.flex_title,p_old_Line_price_att_rec.flex_title)
1026: THEN
1027: l_index := l_index + 1;
1028: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_FLEX_TITLE;
1029: END IF;
1027: l_index := l_index + 1;
1028: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_FLEX_TITLE;
1029: END IF;
1030:
1031: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.header_id,p_old_Line_price_att_rec.header_id)
1032: THEN
1033: l_index := l_index + 1;
1034: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_HEADER;
1035: END IF;
1033: l_index := l_index + 1;
1034: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_HEADER;
1035: END IF;
1036:
1037: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.last_updated_by,p_old_Line_price_att_rec.last_updated_by)
1038: THEN
1039: l_index := l_index + 1;
1040: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_LAST_UPDATED_BY;
1041: END IF;
1039: l_index := l_index + 1;
1040: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_LAST_UPDATED_BY;
1041: END IF;
1042:
1043: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.last_update_date,p_old_Line_price_att_rec.last_update_date)
1044: THEN
1045: l_index := l_index + 1;
1046: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_LAST_UPDATE_DATE;
1047: END IF;
1045: l_index := l_index + 1;
1046: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_LAST_UPDATE_DATE;
1047: END IF;
1048:
1049: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.last_update_login,p_old_Line_price_att_rec.last_update_login)
1050: THEN
1051: l_index := l_index + 1;
1052: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_LAST_UPDATE_LOGIN;
1053: END IF;
1051: l_index := l_index + 1;
1052: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_LAST_UPDATE_LOGIN;
1053: END IF;
1054:
1055: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.line_id,p_old_Line_price_att_rec.line_id)
1056: THEN
1057: l_index := l_index + 1;
1058: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_LINE;
1059: END IF;
1057: l_index := l_index + 1;
1058: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_LINE;
1059: END IF;
1060:
1061: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.order_price_attrib_id,p_old_Line_price_att_rec.order_price_attrib_id)
1062: THEN
1063: l_index := l_index + 1;
1064: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ORDER_PRICE_ATTRIB;
1065: END IF;
1063: l_index := l_index + 1;
1064: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ORDER_PRICE_ATTRIB;
1065: END IF;
1066:
1067: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute1,p_old_Line_price_att_rec.pricing_attribute1)
1068: THEN
1069: l_index := l_index + 1;
1070: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE1;
1071: END IF;
1069: l_index := l_index + 1;
1070: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE1;
1071: END IF;
1072:
1073: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute10,p_old_Line_price_att_rec.pricing_attribute10)
1074: THEN
1075: l_index := l_index + 1;
1076: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE10;
1077: END IF;
1075: l_index := l_index + 1;
1076: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE10;
1077: END IF;
1078:
1079: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute100,p_old_Line_price_att_rec.pricing_attribute100)
1080: THEN
1081: l_index := l_index + 1;
1082: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE100;
1083: END IF;
1081: l_index := l_index + 1;
1082: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE100;
1083: END IF;
1084:
1085: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute11,p_old_Line_price_att_rec.pricing_attribute11)
1086: THEN
1087: l_index := l_index + 1;
1088: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE11;
1089: END IF;
1087: l_index := l_index + 1;
1088: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE11;
1089: END IF;
1090:
1091: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute12,p_old_Line_price_att_rec.pricing_attribute12)
1092: THEN
1093: l_index := l_index + 1;
1094: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE12;
1095: END IF;
1093: l_index := l_index + 1;
1094: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE12;
1095: END IF;
1096:
1097: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute13,p_old_Line_price_att_rec.pricing_attribute13)
1098: THEN
1099: l_index := l_index + 1;
1100: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE13;
1101: END IF;
1099: l_index := l_index + 1;
1100: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE13;
1101: END IF;
1102:
1103: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute14,p_old_Line_price_att_rec.pricing_attribute14)
1104: THEN
1105: l_index := l_index + 1;
1106: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE14;
1107: END IF;
1105: l_index := l_index + 1;
1106: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE14;
1107: END IF;
1108:
1109: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute15,p_old_Line_price_att_rec.pricing_attribute15)
1110: THEN
1111: l_index := l_index + 1;
1112: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE15;
1113: END IF;
1111: l_index := l_index + 1;
1112: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE15;
1113: END IF;
1114:
1115: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute16,p_old_Line_price_att_rec.pricing_attribute16)
1116: THEN
1117: l_index := l_index + 1;
1118: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE16;
1119: END IF;
1117: l_index := l_index + 1;
1118: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE16;
1119: END IF;
1120:
1121: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute17,p_old_Line_price_att_rec.pricing_attribute17)
1122: THEN
1123: l_index := l_index + 1;
1124: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE17;
1125: END IF;
1123: l_index := l_index + 1;
1124: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE17;
1125: END IF;
1126:
1127: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute18,p_old_Line_price_att_rec.pricing_attribute18)
1128: THEN
1129: l_index := l_index + 1;
1130: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE18;
1131: END IF;
1129: l_index := l_index + 1;
1130: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE18;
1131: END IF;
1132:
1133: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute19,p_old_Line_price_att_rec.pricing_attribute19)
1134: THEN
1135: l_index := l_index + 1;
1136: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE19;
1137: END IF;
1135: l_index := l_index + 1;
1136: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE19;
1137: END IF;
1138:
1139: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute2,p_old_Line_price_att_rec.pricing_attribute2)
1140: THEN
1141: l_index := l_index + 1;
1142: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE2;
1143: END IF;
1141: l_index := l_index + 1;
1142: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE2;
1143: END IF;
1144:
1145: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute20,p_old_Line_price_att_rec.pricing_attribute20)
1146: THEN
1147: l_index := l_index + 1;
1148: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE20;
1149: END IF;
1147: l_index := l_index + 1;
1148: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE20;
1149: END IF;
1150:
1151: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute21,p_old_Line_price_att_rec.pricing_attribute21)
1152: THEN
1153: l_index := l_index + 1;
1154: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE21;
1155: END IF;
1153: l_index := l_index + 1;
1154: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE21;
1155: END IF;
1156:
1157: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute22,p_old_Line_price_att_rec.pricing_attribute22)
1158: THEN
1159: l_index := l_index + 1;
1160: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE22;
1161: END IF;
1159: l_index := l_index + 1;
1160: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE22;
1161: END IF;
1162:
1163: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute23,p_old_Line_price_att_rec.pricing_attribute23)
1164: THEN
1165: l_index := l_index + 1;
1166: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE23;
1167: END IF;
1165: l_index := l_index + 1;
1166: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE23;
1167: END IF;
1168:
1169: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute24,p_old_Line_price_att_rec.pricing_attribute24)
1170: THEN
1171: l_index := l_index + 1;
1172: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE24;
1173: END IF;
1171: l_index := l_index + 1;
1172: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE24;
1173: END IF;
1174:
1175: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute25,p_old_Line_price_att_rec.pricing_attribute25)
1176: THEN
1177: l_index := l_index + 1;
1178: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE25;
1179: END IF;
1177: l_index := l_index + 1;
1178: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE25;
1179: END IF;
1180:
1181: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute26,p_old_Line_price_att_rec.pricing_attribute26)
1182: THEN
1183: l_index := l_index + 1;
1184: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE26;
1185: END IF;
1183: l_index := l_index + 1;
1184: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE26;
1185: END IF;
1186:
1187: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute27,p_old_Line_price_att_rec.pricing_attribute27)
1188: THEN
1189: l_index := l_index + 1;
1190: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE27;
1191: END IF;
1189: l_index := l_index + 1;
1190: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE27;
1191: END IF;
1192:
1193: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute28,p_old_Line_price_att_rec.pricing_attribute28)
1194: THEN
1195: l_index := l_index + 1;
1196: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE28;
1197: END IF;
1195: l_index := l_index + 1;
1196: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE28;
1197: END IF;
1198:
1199: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute29,p_old_Line_price_att_rec.pricing_attribute29)
1200: THEN
1201: l_index := l_index + 1;
1202: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE29;
1203: END IF;
1201: l_index := l_index + 1;
1202: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE29;
1203: END IF;
1204:
1205: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute3,p_old_Line_price_att_rec.pricing_attribute3)
1206: THEN
1207: l_index := l_index + 1;
1208: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE3;
1209: END IF;
1207: l_index := l_index + 1;
1208: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE3;
1209: END IF;
1210:
1211: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute30,p_old_Line_price_att_rec.pricing_attribute30)
1212: THEN
1213: l_index := l_index + 1;
1214: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE30;
1215: END IF;
1213: l_index := l_index + 1;
1214: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE30;
1215: END IF;
1216:
1217: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute31,p_old_Line_price_att_rec.pricing_attribute31)
1218: THEN
1219: l_index := l_index + 1;
1220: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE31;
1221: END IF;
1219: l_index := l_index + 1;
1220: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE31;
1221: END IF;
1222:
1223: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute32,p_old_Line_price_att_rec.pricing_attribute32)
1224: THEN
1225: l_index := l_index + 1;
1226: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE32;
1227: END IF;
1225: l_index := l_index + 1;
1226: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE32;
1227: END IF;
1228:
1229: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute33,p_old_Line_price_att_rec.pricing_attribute33)
1230: THEN
1231: l_index := l_index + 1;
1232: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE33;
1233: END IF;
1231: l_index := l_index + 1;
1232: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE33;
1233: END IF;
1234:
1235: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute34,p_old_Line_price_att_rec.pricing_attribute34)
1236: THEN
1237: l_index := l_index + 1;
1238: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE34;
1239: END IF;
1237: l_index := l_index + 1;
1238: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE34;
1239: END IF;
1240:
1241: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute35,p_old_Line_price_att_rec.pricing_attribute35)
1242: THEN
1243: l_index := l_index + 1;
1244: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE35;
1245: END IF;
1243: l_index := l_index + 1;
1244: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE35;
1245: END IF;
1246:
1247: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute36,p_old_Line_price_att_rec.pricing_attribute36)
1248: THEN
1249: l_index := l_index + 1;
1250: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE36;
1251: END IF;
1249: l_index := l_index + 1;
1250: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE36;
1251: END IF;
1252:
1253: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute37,p_old_Line_price_att_rec.pricing_attribute37)
1254: THEN
1255: l_index := l_index + 1;
1256: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE37;
1257: END IF;
1255: l_index := l_index + 1;
1256: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE37;
1257: END IF;
1258:
1259: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute38,p_old_Line_price_att_rec.pricing_attribute38)
1260: THEN
1261: l_index := l_index + 1;
1262: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE38;
1263: END IF;
1261: l_index := l_index + 1;
1262: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE38;
1263: END IF;
1264:
1265: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute39,p_old_Line_price_att_rec.pricing_attribute39)
1266: THEN
1267: l_index := l_index + 1;
1268: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE39;
1269: END IF;
1270:
1271:
1272: -- Stopped Here
1273:
1274: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute4,p_old_Line_price_att_rec.pricing_attribute4)
1275: THEN
1276: l_index := l_index + 1;
1277: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE4;
1278: END IF;
1276: l_index := l_index + 1;
1277: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE4;
1278: END IF;
1279:
1280: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute40,p_old_Line_price_att_rec.pricing_attribute40)
1281: THEN
1282: l_index := l_index + 1;
1283: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE40;
1284: END IF;
1282: l_index := l_index + 1;
1283: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE40;
1284: END IF;
1285:
1286: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute41,p_old_Line_price_att_rec.pricing_attribute41)
1287: THEN
1288: l_index := l_index + 1;
1289: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE41;
1290: END IF;
1288: l_index := l_index + 1;
1289: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE41;
1290: END IF;
1291:
1292: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute42,p_old_Line_price_att_rec.pricing_attribute42)
1293: THEN
1294: l_index := l_index + 1;
1295: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE42;
1296: END IF;
1294: l_index := l_index + 1;
1295: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE42;
1296: END IF;
1297:
1298: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute43,p_old_Line_price_att_rec.pricing_attribute43)
1299: THEN
1300: l_index := l_index + 1;
1301: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE43;
1302: END IF;
1300: l_index := l_index + 1;
1301: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE43;
1302: END IF;
1303:
1304: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute44,p_old_Line_price_att_rec.pricing_attribute44)
1305: THEN
1306: l_index := l_index + 1;
1307: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE44;
1308: END IF;
1306: l_index := l_index + 1;
1307: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE44;
1308: END IF;
1309:
1310: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute45,p_old_Line_price_att_rec.pricing_attribute45)
1311: THEN
1312: l_index := l_index + 1;
1313: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE45;
1314: END IF;
1312: l_index := l_index + 1;
1313: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE45;
1314: END IF;
1315:
1316: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute46,p_old_Line_price_att_rec.pricing_attribute46)
1317: THEN
1318: l_index := l_index + 1;
1319: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE46;
1320: END IF;
1318: l_index := l_index + 1;
1319: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE46;
1320: END IF;
1321:
1322: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute47,p_old_Line_price_att_rec.pricing_attribute47)
1323: THEN
1324: l_index := l_index + 1;
1325: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE47;
1326: END IF;
1324: l_index := l_index + 1;
1325: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE47;
1326: END IF;
1327:
1328: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute48,p_old_Line_price_att_rec.pricing_attribute48)
1329: THEN
1330: l_index := l_index + 1;
1331: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE48;
1332: END IF;
1330: l_index := l_index + 1;
1331: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE48;
1332: END IF;
1333:
1334: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute49,p_old_Line_price_att_rec.pricing_attribute49)
1335: THEN
1336: l_index := l_index + 1;
1337: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE49;
1338: END IF;
1336: l_index := l_index + 1;
1337: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE49;
1338: END IF;
1339:
1340: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute5,p_old_Line_price_att_rec.pricing_attribute5)
1341: THEN
1342: l_index := l_index + 1;
1343: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE5;
1344: END IF;
1342: l_index := l_index + 1;
1343: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE5;
1344: END IF;
1345:
1346: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute50,p_old_Line_price_att_rec.pricing_attribute50)
1347: THEN
1348: l_index := l_index + 1;
1349: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE50;
1350: END IF;
1348: l_index := l_index + 1;
1349: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE50;
1350: END IF;
1351:
1352: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute51,p_old_Line_price_att_rec.pricing_attribute51)
1353: THEN
1354: l_index := l_index + 1;
1355: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE51;
1356: END IF;
1354: l_index := l_index + 1;
1355: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE51;
1356: END IF;
1357:
1358: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute52,p_old_Line_price_att_rec.pricing_attribute52)
1359: THEN
1360: l_index := l_index + 1;
1361: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE52;
1362: END IF;
1360: l_index := l_index + 1;
1361: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE52;
1362: END IF;
1363:
1364: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute53,p_old_Line_price_att_rec.pricing_attribute53)
1365: THEN
1366: l_index := l_index + 1;
1367: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE53;
1368: END IF;
1366: l_index := l_index + 1;
1367: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE53;
1368: END IF;
1369:
1370: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute54,p_old_Line_price_att_rec.pricing_attribute54)
1371: THEN
1372: l_index := l_index + 1;
1373: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE54;
1374: END IF;
1372: l_index := l_index + 1;
1373: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE54;
1374: END IF;
1375:
1376: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute55,p_old_Line_price_att_rec.pricing_attribute55)
1377: THEN
1378: l_index := l_index + 1;
1379: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE55;
1380: END IF;
1378: l_index := l_index + 1;
1379: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE55;
1380: END IF;
1381:
1382: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute56,p_old_Line_price_att_rec.pricing_attribute56)
1383: THEN
1384: l_index := l_index + 1;
1385: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE56;
1386: END IF;
1384: l_index := l_index + 1;
1385: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE56;
1386: END IF;
1387:
1388: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute57,p_old_Line_price_att_rec.pricing_attribute57)
1389: THEN
1390: l_index := l_index + 1;
1391: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE57;
1392: END IF;
1390: l_index := l_index + 1;
1391: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE57;
1392: END IF;
1393:
1394: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute58,p_old_Line_price_att_rec.pricing_attribute58)
1395: THEN
1396: l_index := l_index + 1;
1397: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE58;
1398: END IF;
1396: l_index := l_index + 1;
1397: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE58;
1398: END IF;
1399:
1400: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute59,p_old_Line_price_att_rec.pricing_attribute59)
1401: THEN
1402: l_index := l_index + 1;
1403: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE59;
1404: END IF;
1402: l_index := l_index + 1;
1403: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE59;
1404: END IF;
1405:
1406: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute6,p_old_Line_price_att_rec.pricing_attribute6)
1407: THEN
1408: l_index := l_index + 1;
1409: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE6;
1410: END IF;
1408: l_index := l_index + 1;
1409: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE6;
1410: END IF;
1411:
1412: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute60,p_old_Line_price_att_rec.pricing_attribute60)
1413: THEN
1414: l_index := l_index + 1;
1415: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE60;
1416: END IF;
1414: l_index := l_index + 1;
1415: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE60;
1416: END IF;
1417:
1418: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute61,p_old_Line_price_att_rec.pricing_attribute61)
1419: THEN
1420: l_index := l_index + 1;
1421: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE61;
1422: END IF;
1420: l_index := l_index + 1;
1421: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE61;
1422: END IF;
1423:
1424: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute62,p_old_Line_price_att_rec.pricing_attribute62)
1425: THEN
1426: l_index := l_index + 1;
1427: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE62;
1428: END IF;
1426: l_index := l_index + 1;
1427: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE62;
1428: END IF;
1429:
1430: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute63,p_old_Line_price_att_rec.pricing_attribute63)
1431: THEN
1432: l_index := l_index + 1;
1433: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE63;
1434: END IF;
1432: l_index := l_index + 1;
1433: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE63;
1434: END IF;
1435:
1436: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute64,p_old_Line_price_att_rec.pricing_attribute64)
1437: THEN
1438: l_index := l_index + 1;
1439: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE64;
1440: END IF;
1438: l_index := l_index + 1;
1439: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE64;
1440: END IF;
1441:
1442: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute65,p_old_Line_price_att_rec.pricing_attribute65)
1443: THEN
1444: l_index := l_index + 1;
1445: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE65;
1446: END IF;
1444: l_index := l_index + 1;
1445: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE65;
1446: END IF;
1447:
1448: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute66,p_old_Line_price_att_rec.pricing_attribute66)
1449: THEN
1450: l_index := l_index + 1;
1451: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE66;
1452: END IF;
1450: l_index := l_index + 1;
1451: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE66;
1452: END IF;
1453:
1454: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute67,p_old_Line_price_att_rec.pricing_attribute67)
1455: THEN
1456: l_index := l_index + 1;
1457: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE67;
1458: END IF;
1456: l_index := l_index + 1;
1457: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE67;
1458: END IF;
1459:
1460: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute68,p_old_Line_price_att_rec.pricing_attribute68)
1461: THEN
1462: l_index := l_index + 1;
1463: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE68;
1464: END IF;
1462: l_index := l_index + 1;
1463: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE68;
1464: END IF;
1465:
1466: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute69,p_old_Line_price_att_rec.pricing_attribute69)
1467: THEN
1468: l_index := l_index + 1;
1469: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE69;
1470: END IF;
1468: l_index := l_index + 1;
1469: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE69;
1470: END IF;
1471:
1472: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute7,p_old_Line_price_att_rec.pricing_attribute7)
1473: THEN
1474: l_index := l_index + 1;
1475: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE7;
1476: END IF;
1474: l_index := l_index + 1;
1475: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE7;
1476: END IF;
1477:
1478: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute70,p_old_Line_price_att_rec.pricing_attribute70)
1479: THEN
1480: l_index := l_index + 1;
1481: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE70;
1482: END IF;
1480: l_index := l_index + 1;
1481: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE70;
1482: END IF;
1483:
1484: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute71,p_old_Line_price_att_rec.pricing_attribute71)
1485: THEN
1486: l_index := l_index + 1;
1487: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE71;
1488: END IF;
1486: l_index := l_index + 1;
1487: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE71;
1488: END IF;
1489:
1490: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute72,p_old_Line_price_att_rec.pricing_attribute72)
1491: THEN
1492: l_index := l_index + 1;
1493: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE72;
1494: END IF;
1492: l_index := l_index + 1;
1493: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE72;
1494: END IF;
1495:
1496: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute73,p_old_Line_price_att_rec.pricing_attribute73)
1497: THEN
1498: l_index := l_index + 1;
1499: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE73;
1500: END IF;
1498: l_index := l_index + 1;
1499: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE73;
1500: END IF;
1501:
1502: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute74,p_old_Line_price_att_rec.pricing_attribute74)
1503: THEN
1504: l_index := l_index + 1;
1505: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE74;
1506: END IF;
1504: l_index := l_index + 1;
1505: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE74;
1506: END IF;
1507:
1508: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute75,p_old_Line_price_att_rec.pricing_attribute75)
1509: THEN
1510: l_index := l_index + 1;
1511: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE75;
1512: END IF;
1510: l_index := l_index + 1;
1511: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE75;
1512: END IF;
1513:
1514: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute76,p_old_Line_price_att_rec.pricing_attribute76)
1515: THEN
1516: l_index := l_index + 1;
1517: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE76;
1518: END IF;
1516: l_index := l_index + 1;
1517: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE76;
1518: END IF;
1519:
1520: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute77,p_old_Line_price_att_rec.pricing_attribute77)
1521: THEN
1522: l_index := l_index + 1;
1523: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE77;
1524: END IF;
1522: l_index := l_index + 1;
1523: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE77;
1524: END IF;
1525:
1526: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute78,p_old_Line_price_att_rec.pricing_attribute78)
1527: THEN
1528: l_index := l_index + 1;
1529: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE78;
1530: END IF;
1528: l_index := l_index + 1;
1529: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE78;
1530: END IF;
1531:
1532: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute79,p_old_Line_price_att_rec.pricing_attribute79)
1533: THEN
1534: l_index := l_index + 1;
1535: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE79;
1536: END IF;
1534: l_index := l_index + 1;
1535: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE79;
1536: END IF;
1537:
1538: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute8,p_old_Line_price_att_rec.pricing_attribute8)
1539: THEN
1540: l_index := l_index + 1;
1541: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE8;
1542: END IF;
1540: l_index := l_index + 1;
1541: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE8;
1542: END IF;
1543:
1544: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute80,p_old_Line_price_att_rec.pricing_attribute80)
1545: THEN
1546: l_index := l_index + 1;
1547: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE80;
1548: END IF;
1546: l_index := l_index + 1;
1547: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE80;
1548: END IF;
1549:
1550: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute81,p_old_Line_price_att_rec.pricing_attribute81)
1551: THEN
1552: l_index := l_index + 1;
1553: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE81;
1554: END IF;
1552: l_index := l_index + 1;
1553: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE81;
1554: END IF;
1555:
1556: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute82,p_old_Line_price_att_rec.pricing_attribute82)
1557: THEN
1558: l_index := l_index + 1;
1559: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE82;
1560: END IF;
1558: l_index := l_index + 1;
1559: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE82;
1560: END IF;
1561:
1562: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute83,p_old_Line_price_att_rec.pricing_attribute83)
1563: THEN
1564: l_index := l_index + 1;
1565: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE83;
1566: END IF;
1564: l_index := l_index + 1;
1565: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE83;
1566: END IF;
1567:
1568: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute84,p_old_Line_price_att_rec.pricing_attribute84)
1569: THEN
1570: l_index := l_index + 1;
1571: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE84;
1572: END IF;
1570: l_index := l_index + 1;
1571: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE84;
1572: END IF;
1573:
1574: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute85,p_old_Line_price_att_rec.pricing_attribute85)
1575: THEN
1576: l_index := l_index + 1;
1577: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE85;
1578: END IF;
1576: l_index := l_index + 1;
1577: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE85;
1578: END IF;
1579:
1580: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute86,p_old_Line_price_att_rec.pricing_attribute86)
1581: THEN
1582: l_index := l_index + 1;
1583: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE86;
1584: END IF;
1582: l_index := l_index + 1;
1583: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE86;
1584: END IF;
1585:
1586: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute87,p_old_Line_price_att_rec.pricing_attribute87)
1587: THEN
1588: l_index := l_index + 1;
1589: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE87;
1590: END IF;
1588: l_index := l_index + 1;
1589: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE87;
1590: END IF;
1591:
1592: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute88,p_old_Line_price_att_rec.pricing_attribute88)
1593: THEN
1594: l_index := l_index + 1;
1595: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE88;
1596: END IF;
1594: l_index := l_index + 1;
1595: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE88;
1596: END IF;
1597:
1598: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute89,p_old_Line_price_att_rec.pricing_attribute89)
1599: THEN
1600: l_index := l_index + 1;
1601: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE89;
1602: END IF;
1600: l_index := l_index + 1;
1601: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE89;
1602: END IF;
1603:
1604: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute9,p_old_Line_price_att_rec.pricing_attribute9)
1605: THEN
1606: l_index := l_index + 1;
1607: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE9;
1608: END IF;
1606: l_index := l_index + 1;
1607: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE9;
1608: END IF;
1609:
1610: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute90,p_old_Line_price_att_rec.pricing_attribute90)
1611: THEN
1612: l_index := l_index + 1;
1613: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE90;
1614: END IF;
1612: l_index := l_index + 1;
1613: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE90;
1614: END IF;
1615:
1616: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute91,p_old_Line_price_att_rec.pricing_attribute91)
1617: THEN
1618: l_index := l_index + 1;
1619: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE91;
1620: END IF;
1618: l_index := l_index + 1;
1619: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE91;
1620: END IF;
1621:
1622: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute92,p_old_Line_price_att_rec.pricing_attribute92)
1623: THEN
1624: l_index := l_index + 1;
1625: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE92;
1626: END IF;
1624: l_index := l_index + 1;
1625: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE92;
1626: END IF;
1627:
1628: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute93,p_old_Line_price_att_rec.pricing_attribute93)
1629: THEN
1630: l_index := l_index + 1;
1631: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE93;
1632: END IF;
1630: l_index := l_index + 1;
1631: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE93;
1632: END IF;
1633:
1634: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute94,p_old_Line_price_att_rec.pricing_attribute94)
1635: THEN
1636: l_index := l_index + 1;
1637: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE94;
1638: END IF;
1636: l_index := l_index + 1;
1637: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE94;
1638: END IF;
1639:
1640: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute95,p_old_Line_price_att_rec.pricing_attribute95)
1641: THEN
1642: l_index := l_index + 1;
1643: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE95;
1644: END IF;
1642: l_index := l_index + 1;
1643: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE95;
1644: END IF;
1645:
1646: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute96,p_old_Line_price_att_rec.pricing_attribute96)
1647: THEN
1648: l_index := l_index + 1;
1649: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE96;
1650: END IF;
1648: l_index := l_index + 1;
1649: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE96;
1650: END IF;
1651:
1652: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute97,p_old_Line_price_att_rec.pricing_attribute97)
1653: THEN
1654: l_index := l_index + 1;
1655: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE97;
1656: END IF;
1654: l_index := l_index + 1;
1655: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE97;
1656: END IF;
1657:
1658: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute98,p_old_Line_price_att_rec.pricing_attribute98)
1659: THEN
1660: l_index := l_index + 1;
1661: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE98;
1662: END IF;
1660: l_index := l_index + 1;
1661: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE98;
1662: END IF;
1663:
1664: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute99,p_old_Line_price_att_rec.pricing_attribute99)
1665: THEN
1666: l_index := l_index + 1;
1667: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE99;
1668: END IF;
1666: l_index := l_index + 1;
1667: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE99;
1668: END IF;
1669:
1670: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_context,p_old_Line_price_att_rec.pricing_context)
1671: THEN
1672: l_index := l_index + 1;
1673: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_CONTEXT;
1674: END IF;
1672: l_index := l_index + 1;
1673: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_CONTEXT;
1674: END IF;
1675:
1676: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.program_application_id,p_old_Line_price_att_rec.program_application_id)
1677: THEN
1678: l_index := l_index + 1;
1679: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PROGRAM_APPLICATION;
1680: END IF;
1678: l_index := l_index + 1;
1679: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PROGRAM_APPLICATION;
1680: END IF;
1681:
1682: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.program_id,p_old_Line_price_att_rec.program_id)
1683: THEN
1684: l_index := l_index + 1;
1685: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PROGRAM;
1686: END IF;
1684: l_index := l_index + 1;
1685: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PROGRAM;
1686: END IF;
1687:
1688: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.program_update_date,p_old_Line_price_att_rec.program_update_date)
1689: THEN
1690: l_index := l_index + 1;
1691: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PROGRAM_UPDATE_DATE;
1692: END IF;
1690: l_index := l_index + 1;
1691: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PROGRAM_UPDATE_DATE;
1692: END IF;
1693:
1694: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.request_id,p_old_Line_price_att_rec.request_id)
1695: THEN
1696: l_index := l_index + 1;
1697: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_REQUEST;
1698: END IF;
1696: l_index := l_index + 1;
1697: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_REQUEST;
1698: END IF;
1699:
1700: IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.orig_sys_atts_ref,p_old_Line_price_att_rec.orig_sys_atts_ref)
1701: THEN
1702: l_index := l_index + 1;
1703: l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ORIG_SYS_ATTS_REF;
1704: END IF;
3263: BEGIN
3264:
3265: -- x_Line_price_att_rec := p_Line_Price_Att_rec;
3266:
3267: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.override_flag,p_old_Line_price_att_rec.override_flag)
3268: THEN
3269: l_price_flag := TRUE;
3270: END IF;
3271:
3270: END IF;
3271:
3272:
3273:
3274: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute1,p_old_Line_price_att_rec.attribute1)
3275: THEN
3276: NULL;
3277: END IF;
3278:
3275: THEN
3276: NULL;
3277: END IF;
3278:
3279: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute10,p_old_Line_price_att_rec.attribute10)
3280: THEN
3281: NULL;
3282: END IF;
3283:
3280: THEN
3281: NULL;
3282: END IF;
3283:
3284: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute11,p_old_Line_price_att_rec.attribute11)
3285: THEN
3286: NULL;
3287: END IF;
3288:
3285: THEN
3286: NULL;
3287: END IF;
3288:
3289: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute12,p_old_Line_price_att_rec.attribute12)
3290: THEN
3291: NULL;
3292: END IF;
3293:
3290: THEN
3291: NULL;
3292: END IF;
3293:
3294: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute13,p_old_Line_price_att_rec.attribute13)
3295: THEN
3296: NULL;
3297: END IF;
3298:
3295: THEN
3296: NULL;
3297: END IF;
3298:
3299: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute14,p_old_Line_price_att_rec.attribute14)
3300: THEN
3301: NULL;
3302: END IF;
3303:
3300: THEN
3301: NULL;
3302: END IF;
3303:
3304: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute15,p_old_Line_price_att_rec.attribute15)
3305: THEN
3306: NULL;
3307: END IF;
3308:
3305: THEN
3306: NULL;
3307: END IF;
3308:
3309: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute2,p_old_Line_price_att_rec.attribute2)
3310: THEN
3311: NULL;
3312: END IF;
3313:
3310: THEN
3311: NULL;
3312: END IF;
3313:
3314: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute3,p_old_Line_price_att_rec.attribute3)
3315: THEN
3316: NULL;
3317: END IF;
3318:
3315: THEN
3316: NULL;
3317: END IF;
3318:
3319: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute4,p_old_Line_price_att_rec.attribute4)
3320: THEN
3321: NULL;
3322: END IF;
3323:
3320: THEN
3321: NULL;
3322: END IF;
3323:
3324: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute5,p_old_Line_price_att_rec.attribute5)
3325: THEN
3326: NULL;
3327: END IF;
3328:
3325: THEN
3326: NULL;
3327: END IF;
3328:
3329: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute6,p_old_Line_price_att_rec.attribute6)
3330: THEN
3331: NULL;
3332: END IF;
3333:
3330: THEN
3331: NULL;
3332: END IF;
3333:
3334: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute7,p_old_Line_price_att_rec.attribute7)
3335: THEN
3336: NULL;
3337: END IF;
3338:
3335: THEN
3336: NULL;
3337: END IF;
3338:
3339: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute8,p_old_Line_price_att_rec.attribute8)
3340: THEN
3341: NULL;
3342: END IF;
3343:
3340: THEN
3341: NULL;
3342: END IF;
3343:
3344: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute9,p_old_Line_price_att_rec.attribute9)
3345: THEN
3346: NULL;
3347: END IF;
3348:
3345: THEN
3346: NULL;
3347: END IF;
3348:
3349: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.context,p_old_Line_price_att_rec.context)
3350: THEN
3351: NULL;
3352: END IF;
3353:
3350: THEN
3351: NULL;
3352: END IF;
3353:
3354: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.created_by,p_old_Line_price_att_rec.created_by)
3355: THEN
3356: NULL;
3357: END IF;
3358:
3355: THEN
3356: NULL;
3357: END IF;
3358:
3359: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.creation_date,p_old_Line_price_att_rec.creation_date)
3360: THEN
3361: NULL;
3362: END IF;
3363:
3360: THEN
3361: NULL;
3362: END IF;
3363:
3364: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.flex_title,p_old_Line_price_att_rec.flex_title)
3365: THEN
3366: l_price_flag := TRUE;
3367: END IF;
3368:
3365: THEN
3366: l_price_flag := TRUE;
3367: END IF;
3368:
3369: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.header_id,p_old_Line_price_att_rec.header_id)
3370: THEN
3371: l_price_flag := TRUE;
3372: END IF;
3373:
3370: THEN
3371: l_price_flag := TRUE;
3372: END IF;
3373:
3374: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.last_updated_by,p_old_Line_price_att_rec.last_updated_by)
3375: THEN
3376: NULL;
3377: END IF;
3378:
3375: THEN
3376: NULL;
3377: END IF;
3378:
3379: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.last_update_date,p_old_Line_price_att_rec.last_update_date)
3380: THEN
3381: NULL;
3382: END IF;
3383:
3380: THEN
3381: NULL;
3382: END IF;
3383:
3384: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.last_update_login,p_old_Line_price_att_rec.last_update_login)
3385: THEN
3386: NULL;
3387: END IF;
3388:
3385: THEN
3386: NULL;
3387: END IF;
3388:
3389: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.line_id,p_old_Line_price_att_rec.line_id)
3390: THEN
3391: l_price_flag := TRUE;
3392: END IF;
3393:
3390: THEN
3391: l_price_flag := TRUE;
3392: END IF;
3393:
3394: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.order_price_attrib_id,p_old_Line_price_att_rec.order_price_attrib_id)
3395: THEN
3396: NULL;
3397: END IF;
3398:
3395: THEN
3396: NULL;
3397: END IF;
3398:
3399: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute1,p_old_Line_price_att_rec.pricing_attribute1)
3400: THEN
3401: l_price_flag := TRUE;
3402: -- lkxu: added for OTA integration, call the OTA API dynamically if
3403: -- the pricing context is OTA_PRICING.
3400: THEN
3401: l_price_flag := TRUE;
3402: -- lkxu: added for OTA integration, call the OTA API dynamically if
3403: -- the pricing context is OTA_PRICING.
3404: IF oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_context, 'OTA') THEN
3405: -- application id for OTA is 810.
3406: --IF fnd_installation.get(810, 810, l_ins_status, l_industry) THEN
3407:
3408: -- bug 1701377
3405: -- application id for OTA is 810.
3406: --IF fnd_installation.get(810, 810, l_ins_status, l_industry) THEN
3407:
3408: -- bug 1701377
3409: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN
3410: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);
3411: END IF;
3412:
3413: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN
3406: --IF fnd_installation.get(810, 810, l_ins_status, l_industry) THEN
3407:
3408: -- bug 1701377
3409: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN
3410: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);
3411: END IF;
3412:
3413: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN
3414: BEGIN
3409: IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN
3410: OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);
3411: END IF;
3412:
3413: IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN
3414: BEGIN
3415: SELECT order_quantity_uom
3416: INTO l_order_quantity_uom
3417: FROM oe_order_lines_all
3457: END IF;
3458: END IF;
3459: END IF;
3460:
3461: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute10,p_old_Line_price_att_rec.pricing_attribute10)
3462: THEN
3463: l_price_flag := TRUE;
3464: END IF;
3465:
3462: THEN
3463: l_price_flag := TRUE;
3464: END IF;
3465:
3466: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute100,p_old_Line_price_att_rec.pricing_attribute100)
3467: THEN
3468: l_price_flag := TRUE;
3469: END IF;
3470:
3467: THEN
3468: l_price_flag := TRUE;
3469: END IF;
3470:
3471: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute11,p_old_Line_price_att_rec.pricing_attribute11)
3472: THEN
3473: l_price_flag := TRUE;
3474: END IF;
3475:
3472: THEN
3473: l_price_flag := TRUE;
3474: END IF;
3475:
3476: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute12,p_old_Line_price_att_rec.pricing_attribute12)
3477: THEN
3478: l_price_flag := TRUE;
3479: END IF;
3480:
3477: THEN
3478: l_price_flag := TRUE;
3479: END IF;
3480:
3481: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute13,p_old_Line_price_att_rec.pricing_attribute13)
3482: THEN
3483: l_price_flag := TRUE;
3484: END IF;
3485:
3482: THEN
3483: l_price_flag := TRUE;
3484: END IF;
3485:
3486: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute14,p_old_Line_price_att_rec.pricing_attribute14)
3487: THEN
3488: l_price_flag := TRUE;
3489: END IF;
3490:
3487: THEN
3488: l_price_flag := TRUE;
3489: END IF;
3490:
3491: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute15,p_old_Line_price_att_rec.pricing_attribute15)
3492: THEN
3493: l_price_flag := TRUE;
3494: END IF;
3495:
3492: THEN
3493: l_price_flag := TRUE;
3494: END IF;
3495:
3496: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute16,p_old_Line_price_att_rec.pricing_attribute16)
3497: THEN
3498: l_price_flag := TRUE;
3499: END IF;
3500:
3497: THEN
3498: l_price_flag := TRUE;
3499: END IF;
3500:
3501: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute17,p_old_Line_price_att_rec.pricing_attribute17)
3502: THEN
3503: l_price_flag := TRUE;
3504: END IF;
3505:
3502: THEN
3503: l_price_flag := TRUE;
3504: END IF;
3505:
3506: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute18,p_old_Line_price_att_rec.pricing_attribute18)
3507: THEN
3508: l_price_flag := TRUE;
3509: END IF;
3510:
3507: THEN
3508: l_price_flag := TRUE;
3509: END IF;
3510:
3511: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute19,p_old_Line_price_att_rec.pricing_attribute19)
3512: THEN
3513: l_price_flag := TRUE;
3514: END IF;
3515:
3512: THEN
3513: l_price_flag := TRUE;
3514: END IF;
3515:
3516: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute2,p_old_Line_price_att_rec.pricing_attribute2)
3517: THEN
3518: l_price_flag := TRUE;
3519: END IF;
3520:
3517: THEN
3518: l_price_flag := TRUE;
3519: END IF;
3520:
3521: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute20,p_old_Line_price_att_rec.pricing_attribute20)
3522: THEN
3523: l_price_flag := TRUE;
3524: END IF;
3525:
3522: THEN
3523: l_price_flag := TRUE;
3524: END IF;
3525:
3526: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute21,p_old_Line_price_att_rec.pricing_attribute21)
3527: THEN
3528: l_price_flag := TRUE;
3529: END IF;
3530:
3527: THEN
3528: l_price_flag := TRUE;
3529: END IF;
3530:
3531: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute22,p_old_Line_price_att_rec.pricing_attribute22)
3532: THEN
3533: l_price_flag := TRUE;
3534: END IF;
3535:
3532: THEN
3533: l_price_flag := TRUE;
3534: END IF;
3535:
3536: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute23,p_old_Line_price_att_rec.pricing_attribute23)
3537: THEN
3538: l_price_flag := TRUE;
3539: END IF;
3540:
3537: THEN
3538: l_price_flag := TRUE;
3539: END IF;
3540:
3541: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute24,p_old_Line_price_att_rec.pricing_attribute24)
3542: THEN
3543: l_price_flag := TRUE;
3544: END IF;
3545:
3542: THEN
3543: l_price_flag := TRUE;
3544: END IF;
3545:
3546: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute25,p_old_Line_price_att_rec.pricing_attribute25)
3547: THEN
3548: l_price_flag := TRUE;
3549: END IF;
3550:
3547: THEN
3548: l_price_flag := TRUE;
3549: END IF;
3550:
3551: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute26,p_old_Line_price_att_rec.pricing_attribute26)
3552: THEN
3553: l_price_flag := TRUE;
3554: END IF;
3555:
3552: THEN
3553: l_price_flag := TRUE;
3554: END IF;
3555:
3556: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute27,p_old_Line_price_att_rec.pricing_attribute27)
3557: THEN
3558: l_price_flag := TRUE;
3559: END IF;
3560:
3557: THEN
3558: l_price_flag := TRUE;
3559: END IF;
3560:
3561: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute28,p_old_Line_price_att_rec.pricing_attribute28)
3562: THEN
3563: l_price_flag := TRUE;
3564: END IF;
3565:
3562: THEN
3563: l_price_flag := TRUE;
3564: END IF;
3565:
3566: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute29,p_old_Line_price_att_rec.pricing_attribute29)
3567: THEN
3568: l_price_flag := TRUE;
3569: END IF;
3570:
3567: THEN
3568: l_price_flag := TRUE;
3569: END IF;
3570:
3571: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute3,p_old_Line_price_att_rec.pricing_attribute3)
3572: THEN
3573: l_price_flag := TRUE;
3574: END IF;
3575:
3572: THEN
3573: l_price_flag := TRUE;
3574: END IF;
3575:
3576: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute30,p_old_Line_price_att_rec.pricing_attribute30)
3577: THEN
3578: l_price_flag := TRUE;
3579: END IF;
3580:
3577: THEN
3578: l_price_flag := TRUE;
3579: END IF;
3580:
3581: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute31,p_old_Line_price_att_rec.pricing_attribute31)
3582: THEN
3583: l_price_flag := TRUE;
3584: END IF;
3585:
3582: THEN
3583: l_price_flag := TRUE;
3584: END IF;
3585:
3586: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute32,p_old_Line_price_att_rec.pricing_attribute32)
3587: THEN
3588: l_price_flag := TRUE;
3589: END IF;
3590:
3587: THEN
3588: l_price_flag := TRUE;
3589: END IF;
3590:
3591: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute33,p_old_Line_price_att_rec.pricing_attribute33)
3592: THEN
3593: l_price_flag := TRUE;
3594: END IF;
3595:
3592: THEN
3593: l_price_flag := TRUE;
3594: END IF;
3595:
3596: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute34,p_old_Line_price_att_rec.pricing_attribute34)
3597: THEN
3598: l_price_flag := TRUE;
3599: END IF;
3600:
3597: THEN
3598: l_price_flag := TRUE;
3599: END IF;
3600:
3601: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute35,p_old_Line_price_att_rec.pricing_attribute35)
3602: THEN
3603: l_price_flag := TRUE;
3604: END IF;
3605:
3602: THEN
3603: l_price_flag := TRUE;
3604: END IF;
3605:
3606: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute36,p_old_Line_price_att_rec.pricing_attribute36)
3607: THEN
3608: l_price_flag := TRUE;
3609: END IF;
3610:
3607: THEN
3608: l_price_flag := TRUE;
3609: END IF;
3610:
3611: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute37,p_old_Line_price_att_rec.pricing_attribute37)
3612: THEN
3613: l_price_flag := TRUE;
3614: END IF;
3615:
3612: THEN
3613: l_price_flag := TRUE;
3614: END IF;
3615:
3616: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute38,p_old_Line_price_att_rec.pricing_attribute38)
3617: THEN
3618: l_price_flag := TRUE;
3619: END IF;
3620:
3617: THEN
3618: l_price_flag := TRUE;
3619: END IF;
3620:
3621: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute39,p_old_Line_price_att_rec.pricing_attribute39)
3622: THEN
3623: l_price_flag := TRUE;
3624: END IF;
3625:
3622: THEN
3623: l_price_flag := TRUE;
3624: END IF;
3625:
3626: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute4,p_old_Line_price_att_rec.pricing_attribute4)
3627: THEN
3628: l_price_flag := TRUE;
3629: END IF;
3630:
3627: THEN
3628: l_price_flag := TRUE;
3629: END IF;
3630:
3631: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute40,p_old_Line_price_att_rec.pricing_attribute40)
3632: THEN
3633: l_price_flag := TRUE;
3634: END IF;
3635:
3632: THEN
3633: l_price_flag := TRUE;
3634: END IF;
3635:
3636: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute41,p_old_Line_price_att_rec.pricing_attribute41)
3637: THEN
3638: l_price_flag := TRUE;
3639: END IF;
3640:
3637: THEN
3638: l_price_flag := TRUE;
3639: END IF;
3640:
3641: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute42,p_old_Line_price_att_rec.pricing_attribute42)
3642: THEN
3643: l_price_flag := TRUE;
3644: END IF;
3645:
3642: THEN
3643: l_price_flag := TRUE;
3644: END IF;
3645:
3646: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute43,p_old_Line_price_att_rec.pricing_attribute43)
3647: THEN
3648: l_price_flag := TRUE;
3649: END IF;
3650:
3647: THEN
3648: l_price_flag := TRUE;
3649: END IF;
3650:
3651: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute44,p_old_Line_price_att_rec.pricing_attribute44)
3652: THEN
3653: l_price_flag := TRUE;
3654: END IF;
3655:
3652: THEN
3653: l_price_flag := TRUE;
3654: END IF;
3655:
3656: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute45,p_old_Line_price_att_rec.pricing_attribute45)
3657: THEN
3658: l_price_flag := TRUE;
3659: END IF;
3660:
3657: THEN
3658: l_price_flag := TRUE;
3659: END IF;
3660:
3661: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute46,p_old_Line_price_att_rec.pricing_attribute46)
3662: THEN
3663: l_price_flag := TRUE;
3664: END IF;
3665:
3662: THEN
3663: l_price_flag := TRUE;
3664: END IF;
3665:
3666: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute47,p_old_Line_price_att_rec.pricing_attribute47)
3667: THEN
3668: l_price_flag := TRUE;
3669: END IF;
3670:
3667: THEN
3668: l_price_flag := TRUE;
3669: END IF;
3670:
3671: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute48,p_old_Line_price_att_rec.pricing_attribute48)
3672: THEN
3673: l_price_flag := TRUE;
3674: END IF;
3675:
3672: THEN
3673: l_price_flag := TRUE;
3674: END IF;
3675:
3676: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute49,p_old_Line_price_att_rec.pricing_attribute49)
3677: THEN
3678: l_price_flag := TRUE;
3679: END IF;
3680:
3677: THEN
3678: l_price_flag := TRUE;
3679: END IF;
3680:
3681: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute5,p_old_Line_price_att_rec.pricing_attribute5)
3682: THEN
3683: l_price_flag := TRUE;
3684: END IF;
3685:
3682: THEN
3683: l_price_flag := TRUE;
3684: END IF;
3685:
3686: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute50,p_old_Line_price_att_rec.pricing_attribute50)
3687: THEN
3688: l_price_flag := TRUE;
3689: END IF;
3690:
3687: THEN
3688: l_price_flag := TRUE;
3689: END IF;
3690:
3691: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute51,p_old_Line_price_att_rec.pricing_attribute51)
3692: THEN
3693: l_price_flag := TRUE;
3694: END IF;
3695:
3692: THEN
3693: l_price_flag := TRUE;
3694: END IF;
3695:
3696: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute52,p_old_Line_price_att_rec.pricing_attribute52)
3697: THEN
3698: l_price_flag := TRUE;
3699: END IF;
3700:
3697: THEN
3698: l_price_flag := TRUE;
3699: END IF;
3700:
3701: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute53,p_old_Line_price_att_rec.pricing_attribute53)
3702: THEN
3703: l_price_flag := TRUE;
3704: END IF;
3705:
3702: THEN
3703: l_price_flag := TRUE;
3704: END IF;
3705:
3706: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute54,p_old_Line_price_att_rec.pricing_attribute54)
3707: THEN
3708: l_price_flag := TRUE;
3709: END IF;
3710:
3707: THEN
3708: l_price_flag := TRUE;
3709: END IF;
3710:
3711: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute55,p_old_Line_price_att_rec.pricing_attribute55)
3712: THEN
3713: l_price_flag := TRUE;
3714: END IF;
3715:
3712: THEN
3713: l_price_flag := TRUE;
3714: END IF;
3715:
3716: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute56,p_old_Line_price_att_rec.pricing_attribute56)
3717: THEN
3718: l_price_flag := TRUE;
3719: END IF;
3720:
3717: THEN
3718: l_price_flag := TRUE;
3719: END IF;
3720:
3721: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute57,p_old_Line_price_att_rec.pricing_attribute57)
3722: THEN
3723: l_price_flag := TRUE;
3724: END IF;
3725:
3722: THEN
3723: l_price_flag := TRUE;
3724: END IF;
3725:
3726: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute58,p_old_Line_price_att_rec.pricing_attribute58)
3727: THEN
3728: l_price_flag := TRUE;
3729: END IF;
3730:
3727: THEN
3728: l_price_flag := TRUE;
3729: END IF;
3730:
3731: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute59,p_old_Line_price_att_rec.pricing_attribute59)
3732: THEN
3733: l_price_flag := TRUE;
3734: END IF;
3735:
3732: THEN
3733: l_price_flag := TRUE;
3734: END IF;
3735:
3736: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute6,p_old_Line_price_att_rec.pricing_attribute6)
3737: THEN
3738: l_price_flag := TRUE;
3739: END IF;
3740:
3737: THEN
3738: l_price_flag := TRUE;
3739: END IF;
3740:
3741: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute60,p_old_Line_price_att_rec.pricing_attribute60)
3742: THEN
3743: l_price_flag := TRUE;
3744: END IF;
3745:
3742: THEN
3743: l_price_flag := TRUE;
3744: END IF;
3745:
3746: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute61,p_old_Line_price_att_rec.pricing_attribute61)
3747: THEN
3748: l_price_flag := TRUE;
3749: END IF;
3750:
3747: THEN
3748: l_price_flag := TRUE;
3749: END IF;
3750:
3751: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute62,p_old_Line_price_att_rec.pricing_attribute62)
3752: THEN
3753: l_price_flag := TRUE;
3754: END IF;
3755:
3752: THEN
3753: l_price_flag := TRUE;
3754: END IF;
3755:
3756: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute63,p_old_Line_price_att_rec.pricing_attribute63)
3757: THEN
3758: l_price_flag := TRUE;
3759: END IF;
3760:
3757: THEN
3758: l_price_flag := TRUE;
3759: END IF;
3760:
3761: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute64,p_old_Line_price_att_rec.pricing_attribute64)
3762: THEN
3763: l_price_flag := TRUE;
3764: END IF;
3765:
3762: THEN
3763: l_price_flag := TRUE;
3764: END IF;
3765:
3766: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute65,p_old_Line_price_att_rec.pricing_attribute65)
3767: THEN
3768: l_price_flag := TRUE;
3769: END IF;
3770:
3767: THEN
3768: l_price_flag := TRUE;
3769: END IF;
3770:
3771: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute66,p_old_Line_price_att_rec.pricing_attribute66)
3772: THEN
3773: l_price_flag := TRUE;
3774: END IF;
3775:
3772: THEN
3773: l_price_flag := TRUE;
3774: END IF;
3775:
3776: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute67,p_old_Line_price_att_rec.pricing_attribute67)
3777: THEN
3778: l_price_flag := TRUE;
3779: END IF;
3780:
3777: THEN
3778: l_price_flag := TRUE;
3779: END IF;
3780:
3781: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute68,p_old_Line_price_att_rec.pricing_attribute68)
3782: THEN
3783: l_price_flag := TRUE;
3784: END IF;
3785:
3782: THEN
3783: l_price_flag := TRUE;
3784: END IF;
3785:
3786: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute69,p_old_Line_price_att_rec.pricing_attribute69)
3787: THEN
3788: l_price_flag := TRUE;
3789: END IF;
3790:
3787: THEN
3788: l_price_flag := TRUE;
3789: END IF;
3790:
3791: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute7,p_old_Line_price_att_rec.pricing_attribute7)
3792: THEN
3793: l_price_flag := TRUE;
3794: END IF;
3795:
3792: THEN
3793: l_price_flag := TRUE;
3794: END IF;
3795:
3796: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute70,p_old_Line_price_att_rec.pricing_attribute70)
3797: THEN
3798: l_price_flag := TRUE;
3799: END IF;
3800:
3797: THEN
3798: l_price_flag := TRUE;
3799: END IF;
3800:
3801: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute71,p_old_Line_price_att_rec.pricing_attribute71)
3802: THEN
3803: l_price_flag := TRUE;
3804: END IF;
3805:
3802: THEN
3803: l_price_flag := TRUE;
3804: END IF;
3805:
3806: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute72,p_old_Line_price_att_rec.pricing_attribute72)
3807: THEN
3808: l_price_flag := TRUE;
3809: END IF;
3810:
3807: THEN
3808: l_price_flag := TRUE;
3809: END IF;
3810:
3811: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute73,p_old_Line_price_att_rec.pricing_attribute73)
3812: THEN
3813: l_price_flag := TRUE;
3814: END IF;
3815:
3812: THEN
3813: l_price_flag := TRUE;
3814: END IF;
3815:
3816: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute74,p_old_Line_price_att_rec.pricing_attribute74)
3817: THEN
3818: l_price_flag := TRUE;
3819: END IF;
3820:
3817: THEN
3818: l_price_flag := TRUE;
3819: END IF;
3820:
3821: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute75,p_old_Line_price_att_rec.pricing_attribute75)
3822: THEN
3823: l_price_flag := TRUE;
3824: END IF;
3825:
3822: THEN
3823: l_price_flag := TRUE;
3824: END IF;
3825:
3826: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute76,p_old_Line_price_att_rec.pricing_attribute76)
3827: THEN
3828: l_price_flag := TRUE;
3829: END IF;
3830:
3827: THEN
3828: l_price_flag := TRUE;
3829: END IF;
3830:
3831: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute77,p_old_Line_price_att_rec.pricing_attribute77)
3832: THEN
3833: l_price_flag := TRUE;
3834: END IF;
3835:
3832: THEN
3833: l_price_flag := TRUE;
3834: END IF;
3835:
3836: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute78,p_old_Line_price_att_rec.pricing_attribute78)
3837: THEN
3838: l_price_flag := TRUE;
3839: END IF;
3840:
3837: THEN
3838: l_price_flag := TRUE;
3839: END IF;
3840:
3841: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute79,p_old_Line_price_att_rec.pricing_attribute79)
3842: THEN
3843: l_price_flag := TRUE;
3844: END IF;
3845:
3842: THEN
3843: l_price_flag := TRUE;
3844: END IF;
3845:
3846: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute8,p_old_Line_price_att_rec.pricing_attribute8)
3847: THEN
3848: l_price_flag := TRUE;
3849: END IF;
3850:
3847: THEN
3848: l_price_flag := TRUE;
3849: END IF;
3850:
3851: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute80,p_old_Line_price_att_rec.pricing_attribute80)
3852: THEN
3853: l_price_flag := TRUE;
3854: END IF;
3855:
3852: THEN
3853: l_price_flag := TRUE;
3854: END IF;
3855:
3856: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute81,p_old_Line_price_att_rec.pricing_attribute81)
3857: THEN
3858: l_price_flag := TRUE;
3859: END IF;
3860:
3857: THEN
3858: l_price_flag := TRUE;
3859: END IF;
3860:
3861: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute82,p_old_Line_price_att_rec.pricing_attribute82)
3862: THEN
3863: l_price_flag := TRUE;
3864: END IF;
3865:
3862: THEN
3863: l_price_flag := TRUE;
3864: END IF;
3865:
3866: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute83,p_old_Line_price_att_rec.pricing_attribute83)
3867: THEN
3868: l_price_flag := TRUE;
3869: END IF;
3870:
3867: THEN
3868: l_price_flag := TRUE;
3869: END IF;
3870:
3871: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute84,p_old_Line_price_att_rec.pricing_attribute84)
3872: THEN
3873: l_price_flag := TRUE;
3874: END IF;
3875:
3872: THEN
3873: l_price_flag := TRUE;
3874: END IF;
3875:
3876: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute85,p_old_Line_price_att_rec.pricing_attribute85)
3877: THEN
3878: l_price_flag := TRUE;
3879: END IF;
3880:
3877: THEN
3878: l_price_flag := TRUE;
3879: END IF;
3880:
3881: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute86,p_old_Line_price_att_rec.pricing_attribute86)
3882: THEN
3883: l_price_flag := TRUE;
3884: END IF;
3885:
3882: THEN
3883: l_price_flag := TRUE;
3884: END IF;
3885:
3886: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute87,p_old_Line_price_att_rec.pricing_attribute87)
3887: THEN
3888: l_price_flag := TRUE;
3889: END IF;
3890:
3887: THEN
3888: l_price_flag := TRUE;
3889: END IF;
3890:
3891: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute88,p_old_Line_price_att_rec.pricing_attribute88)
3892: THEN
3893: l_price_flag := TRUE;
3894: END IF;
3895:
3892: THEN
3893: l_price_flag := TRUE;
3894: END IF;
3895:
3896: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute89,p_old_Line_price_att_rec.pricing_attribute89)
3897: THEN
3898: l_price_flag := TRUE;
3899: END IF;
3900:
3897: THEN
3898: l_price_flag := TRUE;
3899: END IF;
3900:
3901: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute9,p_old_Line_price_att_rec.pricing_attribute9)
3902: THEN
3903: l_price_flag := TRUE;
3904: END IF;
3905:
3902: THEN
3903: l_price_flag := TRUE;
3904: END IF;
3905:
3906: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute90,p_old_Line_price_att_rec.pricing_attribute90)
3907: THEN
3908: l_price_flag := TRUE;
3909: END IF;
3910:
3907: THEN
3908: l_price_flag := TRUE;
3909: END IF;
3910:
3911: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute91,p_old_Line_price_att_rec.pricing_attribute91)
3912: THEN
3913: l_price_flag := TRUE;
3914: END IF;
3915:
3912: THEN
3913: l_price_flag := TRUE;
3914: END IF;
3915:
3916: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute92,p_old_Line_price_att_rec.pricing_attribute92)
3917: THEN
3918: l_price_flag := TRUE;
3919: END IF;
3920:
3917: THEN
3918: l_price_flag := TRUE;
3919: END IF;
3920:
3921: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute93,p_old_Line_price_att_rec.pricing_attribute93)
3922: THEN
3923: l_price_flag := TRUE;
3924: END IF;
3925:
3922: THEN
3923: l_price_flag := TRUE;
3924: END IF;
3925:
3926: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute94,p_old_Line_price_att_rec.pricing_attribute94)
3927: THEN
3928: l_price_flag := TRUE;
3929: END IF;
3930:
3927: THEN
3928: l_price_flag := TRUE;
3929: END IF;
3930:
3931: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute95,p_old_Line_price_att_rec.pricing_attribute95)
3932: THEN
3933: l_price_flag := TRUE;
3934: END IF;
3935:
3932: THEN
3933: l_price_flag := TRUE;
3934: END IF;
3935:
3936: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute96,p_old_Line_price_att_rec.pricing_attribute96)
3937: THEN
3938: l_price_flag := TRUE;
3939: END IF;
3940:
3937: THEN
3938: l_price_flag := TRUE;
3939: END IF;
3940:
3941: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute97,p_old_Line_price_att_rec.pricing_attribute97)
3942: THEN
3943: l_price_flag := TRUE;
3944: END IF;
3945:
3942: THEN
3943: l_price_flag := TRUE;
3944: END IF;
3945:
3946: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute98,p_old_Line_price_att_rec.pricing_attribute98)
3947: THEN
3948: l_price_flag := TRUE;
3949: END IF;
3950:
3947: THEN
3948: l_price_flag := TRUE;
3949: END IF;
3950:
3951: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute99,p_old_Line_price_att_rec.pricing_attribute99)
3952: THEN
3953: l_price_flag := TRUE;
3954: END IF;
3955:
3952: THEN
3953: l_price_flag := TRUE;
3954: END IF;
3955:
3956: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_context,p_old_Line_price_att_rec.pricing_context)
3957: THEN
3958: l_price_flag := TRUE;
3959: END IF;
3960:
3957: THEN
3958: l_price_flag := TRUE;
3959: END IF;
3960:
3961: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.program_application_id,p_old_Line_price_att_rec.program_application_id)
3962: THEN
3963: NULL;
3964: END IF;
3965:
3962: THEN
3963: NULL;
3964: END IF;
3965:
3966: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.program_id,p_old_Line_price_att_rec.program_id)
3967: THEN
3968: NULL;
3969: END IF;
3970:
3967: THEN
3968: NULL;
3969: END IF;
3970:
3971: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.program_update_date,p_old_Line_price_att_rec.program_update_date)
3972: THEN
3973: NULL;
3974: END IF;
3975:
3972: THEN
3973: NULL;
3974: END IF;
3975:
3976: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.request_id,p_old_Line_price_att_rec.request_id)
3977: THEN
3978: NULL;
3979: END IF;
3980:
3977: THEN
3978: NULL;
3979: END IF;
3980:
3981: IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.orig_sys_atts_ref,p_old_Line_price_att_rec.orig_sys_atts_ref)
3982: THEN
3983: NULL;
3984: END IF;
3985: --for bug 2702382 begin
3982: THEN
3983: NULL;
3984: END IF;
3985: --for bug 2702382 begin
3986: if p_x_line_price_att_rec.operation = OE_GLOBALS.G_OPR_DELETE
3987: and p_x_line_price_att_rec.flex_title = 'QP_ATTR_DEFNS_QUALIFIER'
3988: and p_x_line_price_att_rec.pricing_context = 'MODLIST'
3989: and p_x_line_price_att_rec.pricing_attribute1 is not null
3990: then
4055: --Need to register changed line so that repricing for this line will happen
4056: oe_debug_pub.add(' Before calling registered changed lines from ulpab');
4057: OE_LINE_ADJ_UTIL.Register_Changed_Lines(p_line_id=> p_x_Line_Price_Att_rec.line_id,
4058: p_header_id=>p_x_Line_Price_Att_rec.header_id,
4059: p_operation=>OE_GLOBALS.G_OPR_UPDATE);
4060: oe_debug_pub.add(' After calling registered changed line');
4061:
4062: --for bug 2456108 begin
4063: if (p_x_line_price_att_rec.flex_title = 'QP_ATTR_DEFNS_QUALIFIER') then
4061:
4062: --for bug 2456108 begin
4063: if (p_x_line_price_att_rec.flex_title = 'QP_ATTR_DEFNS_QUALIFIER') then
4064: OE_delayed_requests_Pvt.log_request(
4065: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4066: p_entity_id => p_x_Line_Price_Att_rec.line_id,
4067: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4068: p_requesting_entity_id => p_x_Line_Price_Att_rec.line_id,
4069: p_request_unique_key1 => l_pricing_event,
4063: if (p_x_line_price_att_rec.flex_title = 'QP_ATTR_DEFNS_QUALIFIER') then
4064: OE_delayed_requests_Pvt.log_request(
4065: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4066: p_entity_id => p_x_Line_Price_Att_rec.line_id,
4067: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4068: p_requesting_entity_id => p_x_Line_Price_Att_rec.line_id,
4069: p_request_unique_key1 => l_pricing_event,
4070: p_param1 => p_x_Line_Price_Att_rec.header_id,
4071: p_param2 => l_pricing_event,
4068: p_requesting_entity_id => p_x_Line_Price_Att_rec.line_id,
4069: p_request_unique_key1 => l_pricing_event,
4070: p_param1 => p_x_Line_Price_Att_rec.header_id,
4071: p_param2 => l_pricing_event,
4072: p_request_type => OE_GLOBALS.G_PRICE_LINE,
4073: x_return_status => l_return_status);
4074: elsif (p_x_line_price_att_rec.flex_title = 'QP_ATTR_DEFNS_PRICING') then
4075:
4076: -- for bug 3533776: Find out whether order event needs all lines to be sent
4078:
4079: IF l_debug_level > 0 THEN
4080: oe_debug_pub.add('SummaryFlag:'||l_order_status_rec.SUMMARY_LINE_FLAG||'ALL_LINES_FLAG:'||
4081: l_order_status_rec.ALL_LINES_FLAG||' CHANGED_LINE_FLAG:'||l_order_status_rec.CHANGED_LINES_FLAG);
4082: oe_debug_pub.add('G_DEFER_PRICING'||OE_GLOBALS.G_DEFER_PRICING);
4083: if (OE_GLOBALS.G_UI_FLAG) then
4084: oe_debug_pub.add('ui mode');
4085: end if;
4086: END IF;
4079: IF l_debug_level > 0 THEN
4080: oe_debug_pub.add('SummaryFlag:'||l_order_status_rec.SUMMARY_LINE_FLAG||'ALL_LINES_FLAG:'||
4081: l_order_status_rec.ALL_LINES_FLAG||' CHANGED_LINE_FLAG:'||l_order_status_rec.CHANGED_LINES_FLAG);
4082: oe_debug_pub.add('G_DEFER_PRICING'||OE_GLOBALS.G_DEFER_PRICING);
4083: if (OE_GLOBALS.G_UI_FLAG) then
4084: oe_debug_pub.add('ui mode');
4085: end if;
4086: END IF;
4087:
4087:
4088: -- If 'ORDER' event doesn't require sending in all lines, let's just price the current line
4089: If l_order_status_rec.ALL_LINES_FLAG = 'N'
4090: AND l_order_status_rec.SUMMARY_LINE_FLAG = 'N'
4091: AND (OE_GLOBALS.G_UI_FLAG)
4092: AND (OE_GLOBALS.G_DEFER_PRICING = 'N') THEN
4093: OE_delayed_requests_Pvt.log_request(
4094: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
4095: p_entity_id => p_x_Line_Price_Att_rec.line_id,
4088: -- If 'ORDER' event doesn't require sending in all lines, let's just price the current line
4089: If l_order_status_rec.ALL_LINES_FLAG = 'N'
4090: AND l_order_status_rec.SUMMARY_LINE_FLAG = 'N'
4091: AND (OE_GLOBALS.G_UI_FLAG)
4092: AND (OE_GLOBALS.G_DEFER_PRICING = 'N') THEN
4093: OE_delayed_requests_Pvt.log_request(
4094: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
4095: p_entity_id => p_x_Line_Price_Att_rec.line_id,
4096: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
4090: AND l_order_status_rec.SUMMARY_LINE_FLAG = 'N'
4091: AND (OE_GLOBALS.G_UI_FLAG)
4092: AND (OE_GLOBALS.G_DEFER_PRICING = 'N') THEN
4093: OE_delayed_requests_Pvt.log_request(
4094: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
4095: p_entity_id => p_x_Line_Price_Att_rec.line_id,
4096: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
4097: p_requesting_entity_id => p_x_Line_Price_Att_rec.line_id,
4098: p_request_unique_key1 => l_pricing_event,
4092: AND (OE_GLOBALS.G_DEFER_PRICING = 'N') THEN
4093: OE_delayed_requests_Pvt.log_request(
4094: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
4095: p_entity_id => p_x_Line_Price_Att_rec.line_id,
4096: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
4097: p_requesting_entity_id => p_x_Line_Price_Att_rec.line_id,
4098: p_request_unique_key1 => l_pricing_event,
4099: p_param1 => p_x_Line_Price_Att_rec.line_id,
4100: p_param2 => l_pricing_event,
4097: p_requesting_entity_id => p_x_Line_Price_Att_rec.line_id,
4098: p_request_unique_key1 => l_pricing_event,
4099: p_param1 => p_x_Line_Price_Att_rec.line_id,
4100: p_param2 => l_pricing_event,
4101: p_request_type => OE_GLOBALS.G_PRICE_LINE,
4102: x_return_status => l_return_status);
4103:
4104: ELSE
4105: OE_delayed_requests_Pvt.log_request(
4102: x_return_status => l_return_status);
4103:
4104: ELSE
4105: OE_delayed_requests_Pvt.log_request(
4106: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4107: p_entity_id => p_x_Line_Price_Att_rec.Header_Id,
4108: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4109: p_requesting_entity_id => p_x_Line_Price_Att_rec.Header_Id,
4110: p_request_unique_key1 => l_pricing_event,
4104: ELSE
4105: OE_delayed_requests_Pvt.log_request(
4106: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4107: p_entity_id => p_x_Line_Price_Att_rec.Header_Id,
4108: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4109: p_requesting_entity_id => p_x_Line_Price_Att_rec.Header_Id,
4110: p_request_unique_key1 => l_pricing_event,
4111: p_param1 => p_x_Line_Price_Att_rec.header_id,
4112: p_param2 => l_pricing_event,
4109: p_requesting_entity_id => p_x_Line_Price_Att_rec.Header_Id,
4110: p_request_unique_key1 => l_pricing_event,
4111: p_param1 => p_x_Line_Price_Att_rec.header_id,
4112: p_param2 => l_pricing_event,
4113: p_request_type => OE_GLOBALS.G_PRICE_ORDER,
4114: x_return_status => l_return_status);
4115: END IF;
4116: end if; ---for bug 2456108 end
4117:
4125: End;
4126:
4127: If l_booked_flag='Y' Then
4128: OE_delayed_requests_Pvt.log_request(
4129: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4130: p_entity_id => p_x_Line_Price_Att_rec.Header_Id,
4131: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4132: p_requesting_entity_id => p_x_Line_Price_Att_rec.Header_Id,
4133: p_request_unique_key1 => 'BOOK',
4127: If l_booked_flag='Y' Then
4128: OE_delayed_requests_Pvt.log_request(
4129: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4130: p_entity_id => p_x_Line_Price_Att_rec.Header_Id,
4131: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4132: p_requesting_entity_id => p_x_Line_Price_Att_rec.Header_Id,
4133: p_request_unique_key1 => 'BOOK',
4134: p_param1 => p_x_Line_Price_Att_rec.header_id,
4135: p_param2 => 'BOOK',
4132: p_requesting_entity_id => p_x_Line_Price_Att_rec.Header_Id,
4133: p_request_unique_key1 => 'BOOK',
4134: p_param1 => p_x_Line_Price_Att_rec.header_id,
4135: p_param2 => 'BOOK',
4136: p_request_type => OE_GLOBALS.G_PRICE_ORDER,
4137: x_return_status => l_return_status);
4138: End If;
4139:
4140: If l_shipping_quantity > 0 Then
4138: End If;
4139:
4140: If l_shipping_quantity > 0 Then
4141: OE_delayed_requests_Pvt.log_request(
4142: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4143: p_entity_id => p_x_Line_Price_Att_rec.Line_Id,
4144: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4145: p_requesting_entity_id => p_x_Line_Price_Att_rec.Line_Id,
4146: p_request_unique_key1 => 'SHIP',
4140: If l_shipping_quantity > 0 Then
4141: OE_delayed_requests_Pvt.log_request(
4142: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4143: p_entity_id => p_x_Line_Price_Att_rec.Line_Id,
4144: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4145: p_requesting_entity_id => p_x_Line_Price_Att_rec.Line_Id,
4146: p_request_unique_key1 => 'SHIP',
4147: p_param1 => p_x_Line_Price_Att_rec.header_id,
4148: p_param2 => 'SHIP',
4145: p_requesting_entity_id => p_x_Line_Price_Att_rec.Line_Id,
4146: p_request_unique_key1 => 'SHIP',
4147: p_param1 => p_x_Line_Price_Att_rec.header_id,
4148: p_param2 => 'SHIP',
4149: p_request_type => OE_GLOBALS.G_PRICE_LINE,
4150: x_return_status => l_return_status);
4151: End If;
4152: */--2442012
4153: l_Price_Flag := FALSE;
4217: -- Compare lock_control.
4218:
4219: oe_debug_pub.add('compare ', 1);
4220:
4221: IF OE_GLOBALS.Equal(p_x_line_Price_Att_rec.lock_control,
4222: l_lock_control)
4223: THEN
4224:
4225: -- Row has not changed. Set out parameter.
4416: ) IS
4417:
4418: l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;
4419: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
4420: l_control_rec Oe_Globals.Control_rec_type;
4421: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4422: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4423: l_header_rec OE_Order_PUB.Header_Rec_Type;
4424: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4467:
4468: IF l_df_error_code = 0 THEN
4469: -- copy it if the pricing context is valid, don't copy if it is invalid
4470:
4471: l_line_price_att_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
4472: l_line_price_att_tbl(i).line_id := p_to_line_id;
4473: l_line_price_att_tbl(i).header_id := p_to_header_id;
4474: l_line_price_att_tbl(i).order_price_attrib_id := FND_API.G_MISS_NUM;
4475:
4502: -- Call OE_Order_PVT.Process_order
4503:
4504: oe_debug_pub.add('Before OE_Order_PVT.Process_order',1);
4505:
4506: -- OE_Globals.G_RECURSION_MODE := 'Y';
4507:
4508:
4509: OE_Order_PVT.Process_order
4510: ( p_api_version_number => 1.0
4536: , p_x_Line_Payment_tbl => l_x_Line_Payment_tbl
4537: --serla end
4538: , p_x_Lot_Serial_tbl => l_x_Lot_Serial_Tbl
4539: , p_x_action_request_tbl => l_x_Action_Request_tbl
4540: , p_validation_level => OE_GLOBALS.G_VALID_LEVEL_PARTIAL
4541: );
4542:
4543: -- OE_Globals.G_RECURSION_MODE := 'N';
4544:
4539: , p_x_action_request_tbl => l_x_Action_Request_tbl
4540: , p_validation_level => OE_GLOBALS.G_VALID_LEVEL_PARTIAL
4541: );
4542:
4543: -- OE_Globals.G_RECURSION_MODE := 'N';
4544:
4545: End IF;
4546:
4547: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4581: IS
4582: SELECT header_id, line_id
4583: FROM oe_order_lines
4584: WHERE top_model_line_id = p_model_line_id
4585: AND (item_type_code = OE_GLOBALS.G_ITEM_OPTION
4586: OR item_type_code = OE_GLOBALS.G_ITEM_CLASS
4587: OR item_type_code = OE_GLOBALS.G_ITEM_KIT);
4588: */
4589:
4582: SELECT header_id, line_id
4583: FROM oe_order_lines
4584: WHERE top_model_line_id = p_model_line_id
4585: AND (item_type_code = OE_GLOBALS.G_ITEM_OPTION
4586: OR item_type_code = OE_GLOBALS.G_ITEM_CLASS
4587: OR item_type_code = OE_GLOBALS.G_ITEM_KIT);
4588: */
4589:
4590:
4583: FROM oe_order_lines
4584: WHERE top_model_line_id = p_model_line_id
4585: AND (item_type_code = OE_GLOBALS.G_ITEM_OPTION
4586: OR item_type_code = OE_GLOBALS.G_ITEM_CLASS
4587: OR item_type_code = OE_GLOBALS.G_ITEM_KIT);
4588: */
4589:
4590:
4591: l_from_header_id NUMBER;