[Home] [Help]
9:
10: -- Procedure Clear_Dependent_Attr
11:
12: PROCEDURE Clear_Dependent_Attr
13: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
14: , p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
15: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
16: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
17: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
28:
29: -- If attr_id is missing compare old and new records and for
30: -- every changed attribute clear its dependent fields.
31:
32: IF p_attr_id = FND_API.G_MISS_NUM THEN
33:
34: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.accrual_qty,p_old_PRICE_LIST_LINE_rec.accrual_qty)
35: THEN
36: l_index := l_index + 1;
1074: IS
1075: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;
1076: BEGIN
1077:
1078: IF l_PRICE_LIST_LINE_rec.accrual_qty = FND_API.G_MISS_NUM THEN
1079: l_PRICE_LIST_LINE_rec.accrual_qty := p_old_PRICE_LIST_LINE_rec.accrual_qty;
1080: END IF;
1081:
1082:
1079: l_PRICE_LIST_LINE_rec.accrual_qty := p_old_PRICE_LIST_LINE_rec.accrual_qty;
1080: END IF;
1081:
1082:
1083: IF l_PRICE_LIST_LINE_rec.accrual_uom_code = FND_API.G_MISS_CHAR THEN
1084: l_PRICE_LIST_LINE_rec.accrual_uom_code := p_old_PRICE_LIST_LINE_rec.accrual_uom_code;
1085: END IF;
1086:
1087: IF l_PRICE_LIST_LINE_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN
1083: IF l_PRICE_LIST_LINE_rec.accrual_uom_code = FND_API.G_MISS_CHAR THEN
1084: l_PRICE_LIST_LINE_rec.accrual_uom_code := p_old_PRICE_LIST_LINE_rec.accrual_uom_code;
1085: END IF;
1086:
1087: IF l_PRICE_LIST_LINE_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN
1088: l_PRICE_LIST_LINE_rec.arithmetic_operator := p_old_PRICE_LIST_LINE_rec.arithmetic_operator;
1089: END IF;
1090:
1091: IF l_PRICE_LIST_LINE_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1087: IF l_PRICE_LIST_LINE_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN
1088: l_PRICE_LIST_LINE_rec.arithmetic_operator := p_old_PRICE_LIST_LINE_rec.arithmetic_operator;
1089: END IF;
1090:
1091: IF l_PRICE_LIST_LINE_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1092: l_PRICE_LIST_LINE_rec.attribute1 := p_old_PRICE_LIST_LINE_rec.attribute1;
1093: END IF;
1094:
1095: IF l_PRICE_LIST_LINE_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1091: IF l_PRICE_LIST_LINE_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1092: l_PRICE_LIST_LINE_rec.attribute1 := p_old_PRICE_LIST_LINE_rec.attribute1;
1093: END IF;
1094:
1095: IF l_PRICE_LIST_LINE_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1096: l_PRICE_LIST_LINE_rec.attribute10 := p_old_PRICE_LIST_LINE_rec.attribute10;
1097: END IF;
1098:
1099: IF l_PRICE_LIST_LINE_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1095: IF l_PRICE_LIST_LINE_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1096: l_PRICE_LIST_LINE_rec.attribute10 := p_old_PRICE_LIST_LINE_rec.attribute10;
1097: END IF;
1098:
1099: IF l_PRICE_LIST_LINE_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1100: l_PRICE_LIST_LINE_rec.attribute11 := p_old_PRICE_LIST_LINE_rec.attribute11;
1101: END IF;
1102:
1103: IF l_PRICE_LIST_LINE_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1099: IF l_PRICE_LIST_LINE_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1100: l_PRICE_LIST_LINE_rec.attribute11 := p_old_PRICE_LIST_LINE_rec.attribute11;
1101: END IF;
1102:
1103: IF l_PRICE_LIST_LINE_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1104: l_PRICE_LIST_LINE_rec.attribute12 := p_old_PRICE_LIST_LINE_rec.attribute12;
1105: END IF;
1106:
1107: IF l_PRICE_LIST_LINE_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1103: IF l_PRICE_LIST_LINE_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1104: l_PRICE_LIST_LINE_rec.attribute12 := p_old_PRICE_LIST_LINE_rec.attribute12;
1105: END IF;
1106:
1107: IF l_PRICE_LIST_LINE_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1108: l_PRICE_LIST_LINE_rec.attribute13 := p_old_PRICE_LIST_LINE_rec.attribute13;
1109: END IF;
1110:
1111: IF l_PRICE_LIST_LINE_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1107: IF l_PRICE_LIST_LINE_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1108: l_PRICE_LIST_LINE_rec.attribute13 := p_old_PRICE_LIST_LINE_rec.attribute13;
1109: END IF;
1110:
1111: IF l_PRICE_LIST_LINE_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1112: l_PRICE_LIST_LINE_rec.attribute14 := p_old_PRICE_LIST_LINE_rec.attribute14;
1113: END IF;
1114:
1115: IF l_PRICE_LIST_LINE_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1111: IF l_PRICE_LIST_LINE_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1112: l_PRICE_LIST_LINE_rec.attribute14 := p_old_PRICE_LIST_LINE_rec.attribute14;
1113: END IF;
1114:
1115: IF l_PRICE_LIST_LINE_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1116: l_PRICE_LIST_LINE_rec.attribute15 := p_old_PRICE_LIST_LINE_rec.attribute15;
1117: END IF;
1118:
1119: IF l_PRICE_LIST_LINE_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1115: IF l_PRICE_LIST_LINE_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1116: l_PRICE_LIST_LINE_rec.attribute15 := p_old_PRICE_LIST_LINE_rec.attribute15;
1117: END IF;
1118:
1119: IF l_PRICE_LIST_LINE_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1120: l_PRICE_LIST_LINE_rec.attribute2 := p_old_PRICE_LIST_LINE_rec.attribute2;
1121: END IF;
1122:
1123: IF l_PRICE_LIST_LINE_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1119: IF l_PRICE_LIST_LINE_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1120: l_PRICE_LIST_LINE_rec.attribute2 := p_old_PRICE_LIST_LINE_rec.attribute2;
1121: END IF;
1122:
1123: IF l_PRICE_LIST_LINE_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1124: l_PRICE_LIST_LINE_rec.attribute3 := p_old_PRICE_LIST_LINE_rec.attribute3;
1125: END IF;
1126:
1127: IF l_PRICE_LIST_LINE_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1123: IF l_PRICE_LIST_LINE_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1124: l_PRICE_LIST_LINE_rec.attribute3 := p_old_PRICE_LIST_LINE_rec.attribute3;
1125: END IF;
1126:
1127: IF l_PRICE_LIST_LINE_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1128: l_PRICE_LIST_LINE_rec.attribute4 := p_old_PRICE_LIST_LINE_rec.attribute4;
1129: END IF;
1130:
1131: IF l_PRICE_LIST_LINE_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1127: IF l_PRICE_LIST_LINE_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1128: l_PRICE_LIST_LINE_rec.attribute4 := p_old_PRICE_LIST_LINE_rec.attribute4;
1129: END IF;
1130:
1131: IF l_PRICE_LIST_LINE_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1132: l_PRICE_LIST_LINE_rec.attribute5 := p_old_PRICE_LIST_LINE_rec.attribute5;
1133: END IF;
1134:
1135: IF l_PRICE_LIST_LINE_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1131: IF l_PRICE_LIST_LINE_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1132: l_PRICE_LIST_LINE_rec.attribute5 := p_old_PRICE_LIST_LINE_rec.attribute5;
1133: END IF;
1134:
1135: IF l_PRICE_LIST_LINE_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1136: l_PRICE_LIST_LINE_rec.attribute6 := p_old_PRICE_LIST_LINE_rec.attribute6;
1137: END IF;
1138:
1139: IF l_PRICE_LIST_LINE_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1135: IF l_PRICE_LIST_LINE_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1136: l_PRICE_LIST_LINE_rec.attribute6 := p_old_PRICE_LIST_LINE_rec.attribute6;
1137: END IF;
1138:
1139: IF l_PRICE_LIST_LINE_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1140: l_PRICE_LIST_LINE_rec.attribute7 := p_old_PRICE_LIST_LINE_rec.attribute7;
1141: END IF;
1142:
1143: IF l_PRICE_LIST_LINE_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1139: IF l_PRICE_LIST_LINE_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1140: l_PRICE_LIST_LINE_rec.attribute7 := p_old_PRICE_LIST_LINE_rec.attribute7;
1141: END IF;
1142:
1143: IF l_PRICE_LIST_LINE_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1144: l_PRICE_LIST_LINE_rec.attribute8 := p_old_PRICE_LIST_LINE_rec.attribute8;
1145: END IF;
1146:
1147: IF l_PRICE_LIST_LINE_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1143: IF l_PRICE_LIST_LINE_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1144: l_PRICE_LIST_LINE_rec.attribute8 := p_old_PRICE_LIST_LINE_rec.attribute8;
1145: END IF;
1146:
1147: IF l_PRICE_LIST_LINE_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1148: l_PRICE_LIST_LINE_rec.attribute9 := p_old_PRICE_LIST_LINE_rec.attribute9;
1149: END IF;
1150:
1151: IF l_PRICE_LIST_LINE_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1147: IF l_PRICE_LIST_LINE_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1148: l_PRICE_LIST_LINE_rec.attribute9 := p_old_PRICE_LIST_LINE_rec.attribute9;
1149: END IF;
1150:
1151: IF l_PRICE_LIST_LINE_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1152: l_PRICE_LIST_LINE_rec.automatic_flag := p_old_PRICE_LIST_LINE_rec.automatic_flag;
1153: END IF;
1154:
1155: IF l_PRICE_LIST_LINE_rec.base_qty = FND_API.G_MISS_NUM THEN
1151: IF l_PRICE_LIST_LINE_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1152: l_PRICE_LIST_LINE_rec.automatic_flag := p_old_PRICE_LIST_LINE_rec.automatic_flag;
1153: END IF;
1154:
1155: IF l_PRICE_LIST_LINE_rec.base_qty = FND_API.G_MISS_NUM THEN
1156: l_PRICE_LIST_LINE_rec.base_qty := p_old_PRICE_LIST_LINE_rec.base_qty;
1157: END IF;
1158:
1159: IF l_PRICE_LIST_LINE_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
1155: IF l_PRICE_LIST_LINE_rec.base_qty = FND_API.G_MISS_NUM THEN
1156: l_PRICE_LIST_LINE_rec.base_qty := p_old_PRICE_LIST_LINE_rec.base_qty;
1157: END IF;
1158:
1159: IF l_PRICE_LIST_LINE_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
1160: l_PRICE_LIST_LINE_rec.base_uom_code := p_old_PRICE_LIST_LINE_rec.base_uom_code;
1161: END IF;
1162:
1163: IF l_PRICE_LIST_LINE_rec.comments = FND_API.G_MISS_CHAR THEN
1159: IF l_PRICE_LIST_LINE_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
1160: l_PRICE_LIST_LINE_rec.base_uom_code := p_old_PRICE_LIST_LINE_rec.base_uom_code;
1161: END IF;
1162:
1163: IF l_PRICE_LIST_LINE_rec.comments = FND_API.G_MISS_CHAR THEN
1164: l_PRICE_LIST_LINE_rec.comments := p_old_PRICE_LIST_LINE_rec.comments;
1165: END IF;
1166:
1167: IF l_PRICE_LIST_LINE_rec.context = FND_API.G_MISS_CHAR THEN
1163: IF l_PRICE_LIST_LINE_rec.comments = FND_API.G_MISS_CHAR THEN
1164: l_PRICE_LIST_LINE_rec.comments := p_old_PRICE_LIST_LINE_rec.comments;
1165: END IF;
1166:
1167: IF l_PRICE_LIST_LINE_rec.context = FND_API.G_MISS_CHAR THEN
1168: l_PRICE_LIST_LINE_rec.context := p_old_PRICE_LIST_LINE_rec.context;
1169: END IF;
1170:
1171: IF l_PRICE_LIST_LINE_rec.created_by = FND_API.G_MISS_NUM THEN
1167: IF l_PRICE_LIST_LINE_rec.context = FND_API.G_MISS_CHAR THEN
1168: l_PRICE_LIST_LINE_rec.context := p_old_PRICE_LIST_LINE_rec.context;
1169: END IF;
1170:
1171: IF l_PRICE_LIST_LINE_rec.created_by = FND_API.G_MISS_NUM THEN
1172: l_PRICE_LIST_LINE_rec.created_by := p_old_PRICE_LIST_LINE_rec.created_by;
1173: END IF;
1174:
1175: IF l_PRICE_LIST_LINE_rec.creation_date = FND_API.G_MISS_DATE THEN
1171: IF l_PRICE_LIST_LINE_rec.created_by = FND_API.G_MISS_NUM THEN
1172: l_PRICE_LIST_LINE_rec.created_by := p_old_PRICE_LIST_LINE_rec.created_by;
1173: END IF;
1174:
1175: IF l_PRICE_LIST_LINE_rec.creation_date = FND_API.G_MISS_DATE THEN
1176: l_PRICE_LIST_LINE_rec.creation_date := p_old_PRICE_LIST_LINE_rec.creation_date;
1177: END IF;
1178:
1179: IF l_PRICE_LIST_LINE_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN
1175: IF l_PRICE_LIST_LINE_rec.creation_date = FND_API.G_MISS_DATE THEN
1176: l_PRICE_LIST_LINE_rec.creation_date := p_old_PRICE_LIST_LINE_rec.creation_date;
1177: END IF;
1178:
1179: IF l_PRICE_LIST_LINE_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN
1180: l_PRICE_LIST_LINE_rec.effective_period_uom := p_old_PRICE_LIST_LINE_rec.effective_period_uom;
1181: END IF;
1182:
1183: IF l_PRICE_LIST_LINE_rec.end_date_active = FND_API.G_MISS_DATE THEN
1179: IF l_PRICE_LIST_LINE_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN
1180: l_PRICE_LIST_LINE_rec.effective_period_uom := p_old_PRICE_LIST_LINE_rec.effective_period_uom;
1181: END IF;
1182:
1183: IF l_PRICE_LIST_LINE_rec.end_date_active = FND_API.G_MISS_DATE THEN
1184: l_PRICE_LIST_LINE_rec.end_date_active := p_old_PRICE_LIST_LINE_rec.end_date_active;
1185: END IF;
1186:
1187: IF l_PRICE_LIST_LINE_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN
1183: IF l_PRICE_LIST_LINE_rec.end_date_active = FND_API.G_MISS_DATE THEN
1184: l_PRICE_LIST_LINE_rec.end_date_active := p_old_PRICE_LIST_LINE_rec.end_date_active;
1185: END IF;
1186:
1187: IF l_PRICE_LIST_LINE_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN
1188: l_PRICE_LIST_LINE_rec.estim_accrual_rate := p_old_PRICE_LIST_LINE_rec.estim_accrual_rate;
1189: END IF;
1190:
1191: IF l_PRICE_LIST_LINE_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
1187: IF l_PRICE_LIST_LINE_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN
1188: l_PRICE_LIST_LINE_rec.estim_accrual_rate := p_old_PRICE_LIST_LINE_rec.estim_accrual_rate;
1189: END IF;
1190:
1191: IF l_PRICE_LIST_LINE_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
1192: l_PRICE_LIST_LINE_rec.generate_using_formula_id := p_old_PRICE_LIST_LINE_rec.generate_using_formula_id;
1193: END IF;
1194:
1195:
1192: l_PRICE_LIST_LINE_rec.generate_using_formula_id := p_old_PRICE_LIST_LINE_rec.generate_using_formula_id;
1193: END IF;
1194:
1195:
1196: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1197: l_PRICE_LIST_LINE_rec.inventory_item_id := p_old_PRICE_LIST_LINE_rec.inventory_item_id;
1198: END IF;
1199:
1200: IF l_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1196: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1197: l_PRICE_LIST_LINE_rec.inventory_item_id := p_old_PRICE_LIST_LINE_rec.inventory_item_id;
1198: END IF;
1199:
1200: IF l_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1201: l_PRICE_LIST_LINE_rec.last_updated_by := p_old_PRICE_LIST_LINE_rec.last_updated_by;
1202: END IF;
1203:
1204: IF l_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN
1200: IF l_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1201: l_PRICE_LIST_LINE_rec.last_updated_by := p_old_PRICE_LIST_LINE_rec.last_updated_by;
1202: END IF;
1203:
1204: IF l_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN
1205: l_PRICE_LIST_LINE_rec.last_update_date := p_old_PRICE_LIST_LINE_rec.last_update_date;
1206: END IF;
1207:
1208: IF l_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN
1204: IF l_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN
1205: l_PRICE_LIST_LINE_rec.last_update_date := p_old_PRICE_LIST_LINE_rec.last_update_date;
1206: END IF;
1207:
1208: IF l_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN
1209: l_PRICE_LIST_LINE_rec.last_update_login := p_old_PRICE_LIST_LINE_rec.last_update_login;
1210: END IF;
1211:
1212: IF l_PRICE_LIST_LINE_rec.list_header_id = FND_API.G_MISS_NUM THEN
1208: IF l_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN
1209: l_PRICE_LIST_LINE_rec.last_update_login := p_old_PRICE_LIST_LINE_rec.last_update_login;
1210: END IF;
1211:
1212: IF l_PRICE_LIST_LINE_rec.list_header_id = FND_API.G_MISS_NUM THEN
1213: l_PRICE_LIST_LINE_rec.list_header_id := p_old_PRICE_LIST_LINE_rec.list_header_id;
1214: END IF;
1215:
1216: IF l_PRICE_LIST_LINE_rec.list_line_id = FND_API.G_MISS_NUM THEN
1212: IF l_PRICE_LIST_LINE_rec.list_header_id = FND_API.G_MISS_NUM THEN
1213: l_PRICE_LIST_LINE_rec.list_header_id := p_old_PRICE_LIST_LINE_rec.list_header_id;
1214: END IF;
1215:
1216: IF l_PRICE_LIST_LINE_rec.list_line_id = FND_API.G_MISS_NUM THEN
1217: l_PRICE_LIST_LINE_rec.list_line_id := p_old_PRICE_LIST_LINE_rec.list_line_id;
1218: END IF;
1219:
1220: IF l_PRICE_LIST_LINE_rec.list_line_no = FND_API.G_MISS_CHAR THEN -- bug 4751658, 4199398
1216: IF l_PRICE_LIST_LINE_rec.list_line_id = FND_API.G_MISS_NUM THEN
1217: l_PRICE_LIST_LINE_rec.list_line_id := p_old_PRICE_LIST_LINE_rec.list_line_id;
1218: END IF;
1219:
1220: IF l_PRICE_LIST_LINE_rec.list_line_no = FND_API.G_MISS_CHAR THEN -- bug 4751658, 4199398
1221: l_PRICE_LIST_LINE_rec.list_line_no := p_old_PRICE_LIST_LINE_rec.list_line_no;
1222: END IF;
1223:
1224: IF l_PRICE_LIST_LINE_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
1220: IF l_PRICE_LIST_LINE_rec.list_line_no = FND_API.G_MISS_CHAR THEN -- bug 4751658, 4199398
1221: l_PRICE_LIST_LINE_rec.list_line_no := p_old_PRICE_LIST_LINE_rec.list_line_no;
1222: END IF;
1223:
1224: IF l_PRICE_LIST_LINE_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
1225: l_PRICE_LIST_LINE_rec.list_line_type_code := p_old_PRICE_LIST_LINE_rec.list_line_type_code;
1226: END IF;
1227:
1228: IF l_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM THEN
1224: IF l_PRICE_LIST_LINE_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
1225: l_PRICE_LIST_LINE_rec.list_line_type_code := p_old_PRICE_LIST_LINE_rec.list_line_type_code;
1226: END IF;
1227:
1228: IF l_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM THEN
1229: l_PRICE_LIST_LINE_rec.list_price := p_old_PRICE_LIST_LINE_rec.list_price;
1230: END IF;
1231:
1232: IF l_PRICE_LIST_LINE_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
1228: IF l_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM THEN
1229: l_PRICE_LIST_LINE_rec.list_price := p_old_PRICE_LIST_LINE_rec.list_price;
1230: END IF;
1231:
1232: IF l_PRICE_LIST_LINE_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
1233: l_PRICE_LIST_LINE_rec.from_rltd_modifier_id := p_old_PRICE_LIST_LINE_rec.from_rltd_modifier_id;
1234: END IF;
1235:
1236: IF l_PRICE_LIST_LINE_rec.rltd_modifier_group_no = FND_API.G_MISS_NUM THEN
1232: IF l_PRICE_LIST_LINE_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
1233: l_PRICE_LIST_LINE_rec.from_rltd_modifier_id := p_old_PRICE_LIST_LINE_rec.from_rltd_modifier_id;
1234: END IF;
1235:
1236: IF l_PRICE_LIST_LINE_rec.rltd_modifier_group_no = FND_API.G_MISS_NUM THEN
1237: l_PRICE_LIST_LINE_rec.rltd_modifier_group_no := p_old_PRICE_LIST_LINE_rec.rltd_modifier_group_no;
1238: END IF;
1239:
1240: IF l_PRICE_LIST_LINE_rec.product_precedence = FND_API.G_MISS_NUM THEN
1236: IF l_PRICE_LIST_LINE_rec.rltd_modifier_group_no = FND_API.G_MISS_NUM THEN
1237: l_PRICE_LIST_LINE_rec.rltd_modifier_group_no := p_old_PRICE_LIST_LINE_rec.rltd_modifier_group_no;
1238: END IF;
1239:
1240: IF l_PRICE_LIST_LINE_rec.product_precedence = FND_API.G_MISS_NUM THEN
1241: l_PRICE_LIST_LINE_rec.product_precedence := p_old_PRICE_LIST_LINE_rec.product_precedence;
1242: END IF;
1243:
1244: IF l_PRICE_LIST_LINE_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
1240: IF l_PRICE_LIST_LINE_rec.product_precedence = FND_API.G_MISS_NUM THEN
1241: l_PRICE_LIST_LINE_rec.product_precedence := p_old_PRICE_LIST_LINE_rec.product_precedence;
1242: END IF;
1243:
1244: IF l_PRICE_LIST_LINE_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
1245: l_PRICE_LIST_LINE_rec.modifier_level_code := p_old_PRICE_LIST_LINE_rec.modifier_level_code;
1246: END IF;
1247:
1248: IF l_PRICE_LIST_LINE_rec.number_effective_periods = FND_API.G_MISS_NUM THEN
1244: IF l_PRICE_LIST_LINE_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
1245: l_PRICE_LIST_LINE_rec.modifier_level_code := p_old_PRICE_LIST_LINE_rec.modifier_level_code;
1246: END IF;
1247:
1248: IF l_PRICE_LIST_LINE_rec.number_effective_periods = FND_API.G_MISS_NUM THEN
1249: l_PRICE_LIST_LINE_rec.number_effective_periods := p_old_PRICE_LIST_LINE_rec.number_effective_periods;
1250: END IF;
1251:
1252: IF l_PRICE_LIST_LINE_rec.operand = FND_API.G_MISS_NUM THEN
1248: IF l_PRICE_LIST_LINE_rec.number_effective_periods = FND_API.G_MISS_NUM THEN
1249: l_PRICE_LIST_LINE_rec.number_effective_periods := p_old_PRICE_LIST_LINE_rec.number_effective_periods;
1250: END IF;
1251:
1252: IF l_PRICE_LIST_LINE_rec.operand = FND_API.G_MISS_NUM THEN
1253: l_PRICE_LIST_LINE_rec.operand := p_old_PRICE_LIST_LINE_rec.operand;
1254: END IF;
1255:
1256: IF l_PRICE_LIST_LINE_rec.organization_id = FND_API.G_MISS_NUM THEN
1252: IF l_PRICE_LIST_LINE_rec.operand = FND_API.G_MISS_NUM THEN
1253: l_PRICE_LIST_LINE_rec.operand := p_old_PRICE_LIST_LINE_rec.operand;
1254: END IF;
1255:
1256: IF l_PRICE_LIST_LINE_rec.organization_id = FND_API.G_MISS_NUM THEN
1257: l_PRICE_LIST_LINE_rec.organization_id := p_old_PRICE_LIST_LINE_rec.organization_id;
1258: END IF;
1259:
1260: IF l_PRICE_LIST_LINE_rec.override_flag = FND_API.G_MISS_CHAR THEN
1256: IF l_PRICE_LIST_LINE_rec.organization_id = FND_API.G_MISS_NUM THEN
1257: l_PRICE_LIST_LINE_rec.organization_id := p_old_PRICE_LIST_LINE_rec.organization_id;
1258: END IF;
1259:
1260: IF l_PRICE_LIST_LINE_rec.override_flag = FND_API.G_MISS_CHAR THEN
1261: l_PRICE_LIST_LINE_rec.override_flag := p_old_PRICE_LIST_LINE_rec.override_flag;
1262: END IF;
1263:
1264: IF l_PRICE_LIST_LINE_rec.percent_price = FND_API.G_MISS_NUM THEN
1260: IF l_PRICE_LIST_LINE_rec.override_flag = FND_API.G_MISS_CHAR THEN
1261: l_PRICE_LIST_LINE_rec.override_flag := p_old_PRICE_LIST_LINE_rec.override_flag;
1262: END IF;
1263:
1264: IF l_PRICE_LIST_LINE_rec.percent_price = FND_API.G_MISS_NUM THEN
1265: l_PRICE_LIST_LINE_rec.percent_price := p_old_PRICE_LIST_LINE_rec.percent_price;
1266: END IF;
1267:
1268: IF l_PRICE_LIST_LINE_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
1264: IF l_PRICE_LIST_LINE_rec.percent_price = FND_API.G_MISS_NUM THEN
1265: l_PRICE_LIST_LINE_rec.percent_price := p_old_PRICE_LIST_LINE_rec.percent_price;
1266: END IF;
1267:
1268: IF l_PRICE_LIST_LINE_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
1269: l_PRICE_LIST_LINE_rec.price_break_type_code := p_old_PRICE_LIST_LINE_rec.price_break_type_code;
1270: END IF;
1271:
1272: IF l_PRICE_LIST_LINE_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
1268: IF l_PRICE_LIST_LINE_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
1269: l_PRICE_LIST_LINE_rec.price_break_type_code := p_old_PRICE_LIST_LINE_rec.price_break_type_code;
1270: END IF;
1271:
1272: IF l_PRICE_LIST_LINE_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
1273: l_PRICE_LIST_LINE_rec.price_by_formula_id := p_old_PRICE_LIST_LINE_rec.price_by_formula_id;
1274: END IF;
1275:
1276: IF l_PRICE_LIST_LINE_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
1272: IF l_PRICE_LIST_LINE_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
1273: l_PRICE_LIST_LINE_rec.price_by_formula_id := p_old_PRICE_LIST_LINE_rec.price_by_formula_id;
1274: END IF;
1275:
1276: IF l_PRICE_LIST_LINE_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
1277: l_PRICE_LIST_LINE_rec.primary_uom_flag := p_old_PRICE_LIST_LINE_rec.primary_uom_flag;
1278: END IF;
1279:
1280: IF l_PRICE_LIST_LINE_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
1276: IF l_PRICE_LIST_LINE_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
1277: l_PRICE_LIST_LINE_rec.primary_uom_flag := p_old_PRICE_LIST_LINE_rec.primary_uom_flag;
1278: END IF;
1279:
1280: IF l_PRICE_LIST_LINE_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
1281: l_PRICE_LIST_LINE_rec.print_on_invoice_flag := p_old_PRICE_LIST_LINE_rec.print_on_invoice_flag;
1282: END IF;
1283:
1284: IF l_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM THEN
1280: IF l_PRICE_LIST_LINE_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
1281: l_PRICE_LIST_LINE_rec.print_on_invoice_flag := p_old_PRICE_LIST_LINE_rec.print_on_invoice_flag;
1282: END IF;
1283:
1284: IF l_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM THEN
1285: l_PRICE_LIST_LINE_rec.program_application_id := p_old_PRICE_LIST_LINE_rec.program_application_id;
1286: END IF;
1287:
1288: IF l_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM THEN
1284: IF l_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM THEN
1285: l_PRICE_LIST_LINE_rec.program_application_id := p_old_PRICE_LIST_LINE_rec.program_application_id;
1286: END IF;
1287:
1288: IF l_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM THEN
1289: l_PRICE_LIST_LINE_rec.program_id := p_old_PRICE_LIST_LINE_rec.program_id;
1290: END IF;
1291:
1292: IF l_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN
1288: IF l_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM THEN
1289: l_PRICE_LIST_LINE_rec.program_id := p_old_PRICE_LIST_LINE_rec.program_id;
1290: END IF;
1291:
1292: IF l_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN
1293: l_PRICE_LIST_LINE_rec.program_update_date := p_old_PRICE_LIST_LINE_rec.program_update_date;
1294: END IF;
1295:
1296: IF l_PRICE_LIST_LINE_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
1292: IF l_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN
1293: l_PRICE_LIST_LINE_rec.program_update_date := p_old_PRICE_LIST_LINE_rec.program_update_date;
1294: END IF;
1295:
1296: IF l_PRICE_LIST_LINE_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
1297: l_PRICE_LIST_LINE_rec.rebate_trxn_type_code := p_old_PRICE_LIST_LINE_rec.rebate_trxn_type_code;
1298: END IF;
1299:
1300: -- block pricing
1297: l_PRICE_LIST_LINE_rec.rebate_trxn_type_code := p_old_PRICE_LIST_LINE_rec.rebate_trxn_type_code;
1298: END IF;
1299:
1300: -- block pricing
1301: IF l_PRICE_LIST_LINE_rec.recurring_value = FND_API.G_MISS_NUM THEN
1302: l_PRICE_LIST_LINE_rec.recurring_value := p_old_PRICE_LIST_LINE_rec.recurring_value;
1303: END IF;
1304:
1305: IF l_PRICE_LIST_LINE_rec.related_item_id = FND_API.G_MISS_NUM THEN
1301: IF l_PRICE_LIST_LINE_rec.recurring_value = FND_API.G_MISS_NUM THEN
1302: l_PRICE_LIST_LINE_rec.recurring_value := p_old_PRICE_LIST_LINE_rec.recurring_value;
1303: END IF;
1304:
1305: IF l_PRICE_LIST_LINE_rec.related_item_id = FND_API.G_MISS_NUM THEN
1306: l_PRICE_LIST_LINE_rec.related_item_id := p_old_PRICE_LIST_LINE_rec.related_item_id;
1307: END IF;
1308:
1309: IF l_PRICE_LIST_LINE_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
1305: IF l_PRICE_LIST_LINE_rec.related_item_id = FND_API.G_MISS_NUM THEN
1306: l_PRICE_LIST_LINE_rec.related_item_id := p_old_PRICE_LIST_LINE_rec.related_item_id;
1307: END IF;
1308:
1309: IF l_PRICE_LIST_LINE_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
1310: l_PRICE_LIST_LINE_rec.relationship_type_id := p_old_PRICE_LIST_LINE_rec.relationship_type_id;
1311: END IF;
1312:
1313: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
1309: IF l_PRICE_LIST_LINE_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
1310: l_PRICE_LIST_LINE_rec.relationship_type_id := p_old_PRICE_LIST_LINE_rec.relationship_type_id;
1311: END IF;
1312:
1313: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
1314: l_PRICE_LIST_LINE_rec.reprice_flag := p_old_PRICE_LIST_LINE_rec.reprice_flag;
1315: END IF;
1316:
1317: IF l_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM THEN
1313: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
1314: l_PRICE_LIST_LINE_rec.reprice_flag := p_old_PRICE_LIST_LINE_rec.reprice_flag;
1315: END IF;
1316:
1317: IF l_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM THEN
1318: l_PRICE_LIST_LINE_rec.request_id := p_old_PRICE_LIST_LINE_rec.request_id;
1319: END IF;
1320:
1321: IF l_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR THEN
1317: IF l_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM THEN
1318: l_PRICE_LIST_LINE_rec.request_id := p_old_PRICE_LIST_LINE_rec.request_id;
1319: END IF;
1320:
1321: IF l_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR THEN
1322: l_PRICE_LIST_LINE_rec.revision := p_old_PRICE_LIST_LINE_rec.revision;
1323: END IF;
1324:
1325: IF l_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE THEN
1321: IF l_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR THEN
1322: l_PRICE_LIST_LINE_rec.revision := p_old_PRICE_LIST_LINE_rec.revision;
1323: END IF;
1324:
1325: IF l_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE THEN
1326: l_PRICE_LIST_LINE_rec.revision_date := p_old_PRICE_LIST_LINE_rec.revision_date;
1327: END IF;
1328:
1329: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1325: IF l_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE THEN
1326: l_PRICE_LIST_LINE_rec.revision_date := p_old_PRICE_LIST_LINE_rec.revision_date;
1327: END IF;
1328:
1329: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1330: l_PRICE_LIST_LINE_rec.revision_reason_code := p_old_PRICE_LIST_LINE_rec.revision_reason_code;
1331: END IF;
1332:
1333: IF l_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE THEN
1329: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1330: l_PRICE_LIST_LINE_rec.revision_reason_code := p_old_PRICE_LIST_LINE_rec.revision_reason_code;
1331: END IF;
1332:
1333: IF l_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE THEN
1334: l_PRICE_LIST_LINE_rec.start_date_active := p_old_PRICE_LIST_LINE_rec.start_date_active;
1335: END IF;
1336:
1337: IF l_PRICE_LIST_LINE_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
1333: IF l_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE THEN
1334: l_PRICE_LIST_LINE_rec.start_date_active := p_old_PRICE_LIST_LINE_rec.start_date_active;
1335: END IF;
1336:
1337: IF l_PRICE_LIST_LINE_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
1338: l_PRICE_LIST_LINE_rec.substitution_attribute := p_old_PRICE_LIST_LINE_rec.substitution_attribute;
1339: END IF;
1340:
1341: IF l_PRICE_LIST_LINE_rec.substitution_context = FND_API.G_MISS_CHAR THEN
1337: IF l_PRICE_LIST_LINE_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
1338: l_PRICE_LIST_LINE_rec.substitution_attribute := p_old_PRICE_LIST_LINE_rec.substitution_attribute;
1339: END IF;
1340:
1341: IF l_PRICE_LIST_LINE_rec.substitution_context = FND_API.G_MISS_CHAR THEN
1342: l_PRICE_LIST_LINE_rec.substitution_context := p_old_PRICE_LIST_LINE_rec.substitution_context;
1343: END IF;
1344:
1345: IF l_PRICE_LIST_LINE_rec.substitution_value = FND_API.G_MISS_CHAR THEN
1341: IF l_PRICE_LIST_LINE_rec.substitution_context = FND_API.G_MISS_CHAR THEN
1342: l_PRICE_LIST_LINE_rec.substitution_context := p_old_PRICE_LIST_LINE_rec.substitution_context;
1343: END IF;
1344:
1345: IF l_PRICE_LIST_LINE_rec.substitution_value = FND_API.G_MISS_CHAR THEN
1346: l_PRICE_LIST_LINE_rec.substitution_value := p_old_PRICE_LIST_LINE_rec.substitution_value;
1347: END IF;
1348:
1349: IF l_PRICE_LIST_LINE_rec.qualification_ind = FND_API.G_MISS_NUM THEN
1345: IF l_PRICE_LIST_LINE_rec.substitution_value = FND_API.G_MISS_CHAR THEN
1346: l_PRICE_LIST_LINE_rec.substitution_value := p_old_PRICE_LIST_LINE_rec.substitution_value;
1347: END IF;
1348:
1349: IF l_PRICE_LIST_LINE_rec.qualification_ind = FND_API.G_MISS_NUM THEN
1350: l_PRICE_LIST_LINE_rec.qualification_ind := p_old_PRICE_LIST_LINE_rec.qualification_ind;
1351: END IF;
1352:
1353: IF l_PRICE_LIST_LINE_rec.break_uom_code = FND_API.G_MISS_CHAR THEN
1349: IF l_PRICE_LIST_LINE_rec.qualification_ind = FND_API.G_MISS_NUM THEN
1350: l_PRICE_LIST_LINE_rec.qualification_ind := p_old_PRICE_LIST_LINE_rec.qualification_ind;
1351: END IF;
1352:
1353: IF l_PRICE_LIST_LINE_rec.break_uom_code = FND_API.G_MISS_CHAR THEN
1354: l_PRICE_LIST_LINE_rec.break_uom_code := p_old_PRICE_LIST_LINE_rec.break_uom_code;
1355: END IF;
1356:
1357: IF l_PRICE_LIST_LINE_rec.break_uom_context = FND_API.G_MISS_CHAR THEN
1353: IF l_PRICE_LIST_LINE_rec.break_uom_code = FND_API.G_MISS_CHAR THEN
1354: l_PRICE_LIST_LINE_rec.break_uom_code := p_old_PRICE_LIST_LINE_rec.break_uom_code;
1355: END IF;
1356:
1357: IF l_PRICE_LIST_LINE_rec.break_uom_context = FND_API.G_MISS_CHAR THEN
1358: l_PRICE_LIST_LINE_rec.break_uom_context := p_old_PRICE_LIST_LINE_rec.break_uom_context;
1359: END IF;
1360:
1361: IF l_PRICE_LIST_LINE_rec.break_uom_attribute = FND_API.G_MISS_CHAR THEN
1357: IF l_PRICE_LIST_LINE_rec.break_uom_context = FND_API.G_MISS_CHAR THEN
1358: l_PRICE_LIST_LINE_rec.break_uom_context := p_old_PRICE_LIST_LINE_rec.break_uom_context;
1359: END IF;
1360:
1361: IF l_PRICE_LIST_LINE_rec.break_uom_attribute = FND_API.G_MISS_CHAR THEN
1362: l_PRICE_LIST_LINE_rec.break_uom_attribute := p_old_PRICE_LIST_LINE_rec.break_uom_attribute;
1363: END IF;
1364:
1365: IF l_PRICE_LIST_LINE_rec.continuous_price_break_flag = FND_API.G_MISS_CHAR THEN
1361: IF l_PRICE_LIST_LINE_rec.break_uom_attribute = FND_API.G_MISS_CHAR THEN
1362: l_PRICE_LIST_LINE_rec.break_uom_attribute := p_old_PRICE_LIST_LINE_rec.break_uom_attribute;
1363: END IF;
1364:
1365: IF l_PRICE_LIST_LINE_rec.continuous_price_break_flag = FND_API.G_MISS_CHAR THEN
1366: l_PRICE_LIST_LINE_rec.continuous_price_break_flag := p_old_PRICE_LIST_LINE_rec.continuous_price_break_flag;
1367: END IF;
1368:
1369: --bug 9114132
1366: l_PRICE_LIST_LINE_rec.continuous_price_break_flag := p_old_PRICE_LIST_LINE_rec.continuous_price_break_flag;
1367: END IF;
1368:
1369: --bug 9114132
1370: IF l_PRICE_LIST_LINE_rec.customer_item_id = FND_API.G_MISS_NUM THEN
1371: l_PRICE_LIST_LINE_rec.customer_item_id := p_old_PRICE_LIST_LINE_rec.customer_item_id;
1372: END IF;
1373:
1374: RETURN l_PRICE_LIST_LINE_rec;
1383: IS
1384: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;
1385: BEGIN
1386:
1387: IF l_PRICE_LIST_LINE_rec.accrual_qty = FND_API.G_MISS_NUM THEN
1388: l_PRICE_LIST_LINE_rec.accrual_qty := NULL;
1389: END IF;
1390:
1391: IF l_PRICE_LIST_LINE_rec.accrual_uom_code = FND_API.G_MISS_CHAR THEN
1387: IF l_PRICE_LIST_LINE_rec.accrual_qty = FND_API.G_MISS_NUM THEN
1388: l_PRICE_LIST_LINE_rec.accrual_qty := NULL;
1389: END IF;
1390:
1391: IF l_PRICE_LIST_LINE_rec.accrual_uom_code = FND_API.G_MISS_CHAR THEN
1392: l_PRICE_LIST_LINE_rec.accrual_uom_code := NULL;
1393: END IF;
1394:
1395: IF l_PRICE_LIST_LINE_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN
1391: IF l_PRICE_LIST_LINE_rec.accrual_uom_code = FND_API.G_MISS_CHAR THEN
1392: l_PRICE_LIST_LINE_rec.accrual_uom_code := NULL;
1393: END IF;
1394:
1395: IF l_PRICE_LIST_LINE_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN
1396: l_PRICE_LIST_LINE_rec.arithmetic_operator := NULL;
1397: END IF;
1398:
1399: IF l_PRICE_LIST_LINE_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1395: IF l_PRICE_LIST_LINE_rec.arithmetic_operator = FND_API.G_MISS_CHAR THEN
1396: l_PRICE_LIST_LINE_rec.arithmetic_operator := NULL;
1397: END IF;
1398:
1399: IF l_PRICE_LIST_LINE_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1400: l_PRICE_LIST_LINE_rec.attribute1 := NULL;
1401: END IF;
1402:
1403: IF l_PRICE_LIST_LINE_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1399: IF l_PRICE_LIST_LINE_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1400: l_PRICE_LIST_LINE_rec.attribute1 := NULL;
1401: END IF;
1402:
1403: IF l_PRICE_LIST_LINE_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1404: l_PRICE_LIST_LINE_rec.attribute10 := NULL;
1405: END IF;
1406:
1407: IF l_PRICE_LIST_LINE_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1403: IF l_PRICE_LIST_LINE_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1404: l_PRICE_LIST_LINE_rec.attribute10 := NULL;
1405: END IF;
1406:
1407: IF l_PRICE_LIST_LINE_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1408: l_PRICE_LIST_LINE_rec.attribute11 := NULL;
1409: END IF;
1410:
1411: IF l_PRICE_LIST_LINE_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1407: IF l_PRICE_LIST_LINE_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1408: l_PRICE_LIST_LINE_rec.attribute11 := NULL;
1409: END IF;
1410:
1411: IF l_PRICE_LIST_LINE_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1412: l_PRICE_LIST_LINE_rec.attribute12 := NULL;
1413: END IF;
1414:
1415: IF l_PRICE_LIST_LINE_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1411: IF l_PRICE_LIST_LINE_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1412: l_PRICE_LIST_LINE_rec.attribute12 := NULL;
1413: END IF;
1414:
1415: IF l_PRICE_LIST_LINE_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1416: l_PRICE_LIST_LINE_rec.attribute13 := NULL;
1417: END IF;
1418:
1419: IF l_PRICE_LIST_LINE_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1415: IF l_PRICE_LIST_LINE_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1416: l_PRICE_LIST_LINE_rec.attribute13 := NULL;
1417: END IF;
1418:
1419: IF l_PRICE_LIST_LINE_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1420: l_PRICE_LIST_LINE_rec.attribute14 := NULL;
1421: END IF;
1422:
1423: IF l_PRICE_LIST_LINE_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1419: IF l_PRICE_LIST_LINE_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1420: l_PRICE_LIST_LINE_rec.attribute14 := NULL;
1421: END IF;
1422:
1423: IF l_PRICE_LIST_LINE_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1424: l_PRICE_LIST_LINE_rec.attribute15 := NULL;
1425: END IF;
1426:
1427: IF l_PRICE_LIST_LINE_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1423: IF l_PRICE_LIST_LINE_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1424: l_PRICE_LIST_LINE_rec.attribute15 := NULL;
1425: END IF;
1426:
1427: IF l_PRICE_LIST_LINE_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1428: l_PRICE_LIST_LINE_rec.attribute2 := NULL;
1429: END IF;
1430:
1431: IF l_PRICE_LIST_LINE_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1427: IF l_PRICE_LIST_LINE_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1428: l_PRICE_LIST_LINE_rec.attribute2 := NULL;
1429: END IF;
1430:
1431: IF l_PRICE_LIST_LINE_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1432: l_PRICE_LIST_LINE_rec.attribute3 := NULL;
1433: END IF;
1434:
1435: IF l_PRICE_LIST_LINE_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1431: IF l_PRICE_LIST_LINE_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1432: l_PRICE_LIST_LINE_rec.attribute3 := NULL;
1433: END IF;
1434:
1435: IF l_PRICE_LIST_LINE_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1436: l_PRICE_LIST_LINE_rec.attribute4 := NULL;
1437: END IF;
1438:
1439: IF l_PRICE_LIST_LINE_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1435: IF l_PRICE_LIST_LINE_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1436: l_PRICE_LIST_LINE_rec.attribute4 := NULL;
1437: END IF;
1438:
1439: IF l_PRICE_LIST_LINE_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1440: l_PRICE_LIST_LINE_rec.attribute5 := NULL;
1441: END IF;
1442:
1443: IF l_PRICE_LIST_LINE_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1439: IF l_PRICE_LIST_LINE_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1440: l_PRICE_LIST_LINE_rec.attribute5 := NULL;
1441: END IF;
1442:
1443: IF l_PRICE_LIST_LINE_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1444: l_PRICE_LIST_LINE_rec.attribute6 := NULL;
1445: END IF;
1446:
1447: IF l_PRICE_LIST_LINE_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1443: IF l_PRICE_LIST_LINE_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1444: l_PRICE_LIST_LINE_rec.attribute6 := NULL;
1445: END IF;
1446:
1447: IF l_PRICE_LIST_LINE_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1448: l_PRICE_LIST_LINE_rec.attribute7 := NULL;
1449: END IF;
1450:
1451: IF l_PRICE_LIST_LINE_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1447: IF l_PRICE_LIST_LINE_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1448: l_PRICE_LIST_LINE_rec.attribute7 := NULL;
1449: END IF;
1450:
1451: IF l_PRICE_LIST_LINE_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1452: l_PRICE_LIST_LINE_rec.attribute8 := NULL;
1453: END IF;
1454:
1455: IF l_PRICE_LIST_LINE_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1451: IF l_PRICE_LIST_LINE_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1452: l_PRICE_LIST_LINE_rec.attribute8 := NULL;
1453: END IF;
1454:
1455: IF l_PRICE_LIST_LINE_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1456: l_PRICE_LIST_LINE_rec.attribute9 := NULL;
1457: END IF;
1458:
1459: IF l_PRICE_LIST_LINE_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1455: IF l_PRICE_LIST_LINE_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1456: l_PRICE_LIST_LINE_rec.attribute9 := NULL;
1457: END IF;
1458:
1459: IF l_PRICE_LIST_LINE_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1460: l_PRICE_LIST_LINE_rec.automatic_flag := NULL;
1461: END IF;
1462:
1463: IF l_PRICE_LIST_LINE_rec.base_qty = FND_API.G_MISS_NUM THEN
1459: IF l_PRICE_LIST_LINE_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
1460: l_PRICE_LIST_LINE_rec.automatic_flag := NULL;
1461: END IF;
1462:
1463: IF l_PRICE_LIST_LINE_rec.base_qty = FND_API.G_MISS_NUM THEN
1464: l_PRICE_LIST_LINE_rec.base_qty := NULL;
1465: END IF;
1466:
1467: IF l_PRICE_LIST_LINE_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
1463: IF l_PRICE_LIST_LINE_rec.base_qty = FND_API.G_MISS_NUM THEN
1464: l_PRICE_LIST_LINE_rec.base_qty := NULL;
1465: END IF;
1466:
1467: IF l_PRICE_LIST_LINE_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
1468: l_PRICE_LIST_LINE_rec.base_uom_code := NULL;
1469: END IF;
1470:
1471: IF l_PRICE_LIST_LINE_rec.comments = FND_API.G_MISS_CHAR THEN
1467: IF l_PRICE_LIST_LINE_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
1468: l_PRICE_LIST_LINE_rec.base_uom_code := NULL;
1469: END IF;
1470:
1471: IF l_PRICE_LIST_LINE_rec.comments = FND_API.G_MISS_CHAR THEN
1472: l_PRICE_LIST_LINE_rec.comments := NULL;
1473: END IF;
1474:
1475: IF l_PRICE_LIST_LINE_rec.context = FND_API.G_MISS_CHAR THEN
1471: IF l_PRICE_LIST_LINE_rec.comments = FND_API.G_MISS_CHAR THEN
1472: l_PRICE_LIST_LINE_rec.comments := NULL;
1473: END IF;
1474:
1475: IF l_PRICE_LIST_LINE_rec.context = FND_API.G_MISS_CHAR THEN
1476: l_PRICE_LIST_LINE_rec.context := NULL;
1477: END IF;
1478:
1479: IF l_PRICE_LIST_LINE_rec.created_by = FND_API.G_MISS_NUM THEN
1475: IF l_PRICE_LIST_LINE_rec.context = FND_API.G_MISS_CHAR THEN
1476: l_PRICE_LIST_LINE_rec.context := NULL;
1477: END IF;
1478:
1479: IF l_PRICE_LIST_LINE_rec.created_by = FND_API.G_MISS_NUM THEN
1480: l_PRICE_LIST_LINE_rec.created_by := NULL;
1481: END IF;
1482:
1483: IF l_PRICE_LIST_LINE_rec.creation_date = FND_API.G_MISS_DATE THEN
1479: IF l_PRICE_LIST_LINE_rec.created_by = FND_API.G_MISS_NUM THEN
1480: l_PRICE_LIST_LINE_rec.created_by := NULL;
1481: END IF;
1482:
1483: IF l_PRICE_LIST_LINE_rec.creation_date = FND_API.G_MISS_DATE THEN
1484: l_PRICE_LIST_LINE_rec.creation_date := NULL;
1485: END IF;
1486:
1487: IF l_PRICE_LIST_LINE_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN
1483: IF l_PRICE_LIST_LINE_rec.creation_date = FND_API.G_MISS_DATE THEN
1484: l_PRICE_LIST_LINE_rec.creation_date := NULL;
1485: END IF;
1486:
1487: IF l_PRICE_LIST_LINE_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN
1488: l_PRICE_LIST_LINE_rec.effective_period_uom := NULL;
1489: END IF;
1490:
1491: IF l_PRICE_LIST_LINE_rec.end_date_active = FND_API.G_MISS_DATE THEN
1487: IF l_PRICE_LIST_LINE_rec.effective_period_uom = FND_API.G_MISS_CHAR THEN
1488: l_PRICE_LIST_LINE_rec.effective_period_uom := NULL;
1489: END IF;
1490:
1491: IF l_PRICE_LIST_LINE_rec.end_date_active = FND_API.G_MISS_DATE THEN
1492: l_PRICE_LIST_LINE_rec.end_date_active := NULL;
1493: END IF;
1494:
1495: IF l_PRICE_LIST_LINE_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN
1491: IF l_PRICE_LIST_LINE_rec.end_date_active = FND_API.G_MISS_DATE THEN
1492: l_PRICE_LIST_LINE_rec.end_date_active := NULL;
1493: END IF;
1494:
1495: IF l_PRICE_LIST_LINE_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN
1496: l_PRICE_LIST_LINE_rec.estim_accrual_rate := NULL;
1497: END IF;
1498:
1499: IF l_PRICE_LIST_LINE_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
1495: IF l_PRICE_LIST_LINE_rec.estim_accrual_rate = FND_API.G_MISS_NUM THEN
1496: l_PRICE_LIST_LINE_rec.estim_accrual_rate := NULL;
1497: END IF;
1498:
1499: IF l_PRICE_LIST_LINE_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
1500: l_PRICE_LIST_LINE_rec.generate_using_formula_id := NULL;
1501: END IF;
1502:
1503: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1499: IF l_PRICE_LIST_LINE_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
1500: l_PRICE_LIST_LINE_rec.generate_using_formula_id := NULL;
1501: END IF;
1502:
1503: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1504: l_PRICE_LIST_LINE_rec.inventory_item_id := NULL;
1505: END IF;
1506:
1507: IF l_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1503: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1504: l_PRICE_LIST_LINE_rec.inventory_item_id := NULL;
1505: END IF;
1506:
1507: IF l_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1508: l_PRICE_LIST_LINE_rec.last_updated_by := NULL;
1509: END IF;
1510:
1511: IF l_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN
1507: IF l_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1508: l_PRICE_LIST_LINE_rec.last_updated_by := NULL;
1509: END IF;
1510:
1511: IF l_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN
1512: l_PRICE_LIST_LINE_rec.last_update_date := NULL;
1513: END IF;
1514:
1515: IF l_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN
1511: IF l_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN
1512: l_PRICE_LIST_LINE_rec.last_update_date := NULL;
1513: END IF;
1514:
1515: IF l_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN
1516: l_PRICE_LIST_LINE_rec.last_update_login := NULL;
1517: END IF;
1518:
1519: IF l_PRICE_LIST_LINE_rec.list_header_id = FND_API.G_MISS_NUM THEN
1515: IF l_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN
1516: l_PRICE_LIST_LINE_rec.last_update_login := NULL;
1517: END IF;
1518:
1519: IF l_PRICE_LIST_LINE_rec.list_header_id = FND_API.G_MISS_NUM THEN
1520: l_PRICE_LIST_LINE_rec.list_header_id := NULL;
1521: END IF;
1522:
1523: IF l_PRICE_LIST_LINE_rec.list_line_id = FND_API.G_MISS_NUM THEN
1519: IF l_PRICE_LIST_LINE_rec.list_header_id = FND_API.G_MISS_NUM THEN
1520: l_PRICE_LIST_LINE_rec.list_header_id := NULL;
1521: END IF;
1522:
1523: IF l_PRICE_LIST_LINE_rec.list_line_id = FND_API.G_MISS_NUM THEN
1524: l_PRICE_LIST_LINE_rec.list_line_id := NULL;
1525: END IF;
1526:
1527: IF l_PRICE_LIST_LINE_rec.list_line_no = FND_API.G_MISS_CHAR THEN -- bug 4751658, 4199398
1523: IF l_PRICE_LIST_LINE_rec.list_line_id = FND_API.G_MISS_NUM THEN
1524: l_PRICE_LIST_LINE_rec.list_line_id := NULL;
1525: END IF;
1526:
1527: IF l_PRICE_LIST_LINE_rec.list_line_no = FND_API.G_MISS_CHAR THEN -- bug 4751658, 4199398
1528: l_PRICE_LIST_LINE_rec.list_line_no := NULL;
1529: END IF;
1530:
1531: IF l_PRICE_LIST_LINE_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
1527: IF l_PRICE_LIST_LINE_rec.list_line_no = FND_API.G_MISS_CHAR THEN -- bug 4751658, 4199398
1528: l_PRICE_LIST_LINE_rec.list_line_no := NULL;
1529: END IF;
1530:
1531: IF l_PRICE_LIST_LINE_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
1532: l_PRICE_LIST_LINE_rec.list_line_type_code := NULL;
1533: END IF;
1534:
1535: IF l_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM THEN
1531: IF l_PRICE_LIST_LINE_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
1532: l_PRICE_LIST_LINE_rec.list_line_type_code := NULL;
1533: END IF;
1534:
1535: IF l_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM THEN
1536: l_PRICE_LIST_LINE_rec.list_price := NULL;
1537: END IF;
1538:
1539: IF l_PRICE_LIST_LINE_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
1535: IF l_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM THEN
1536: l_PRICE_LIST_LINE_rec.list_price := NULL;
1537: END IF;
1538:
1539: IF l_PRICE_LIST_LINE_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
1540: l_PRICE_LIST_LINE_rec.from_rltd_modifier_id := NULL;
1541: END IF;
1542:
1543: IF l_PRICE_LIST_LINE_rec.rltd_modifier_group_no = FND_API.G_MISS_NUM THEN
1539: IF l_PRICE_LIST_LINE_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
1540: l_PRICE_LIST_LINE_rec.from_rltd_modifier_id := NULL;
1541: END IF;
1542:
1543: IF l_PRICE_LIST_LINE_rec.rltd_modifier_group_no = FND_API.G_MISS_NUM THEN
1544: l_PRICE_LIST_LINE_rec.rltd_modifier_group_no := NULL;
1545: END IF;
1546:
1547: IF l_PRICE_LIST_LINE_rec.product_precedence = FND_API.G_MISS_NUM THEN
1543: IF l_PRICE_LIST_LINE_rec.rltd_modifier_group_no = FND_API.G_MISS_NUM THEN
1544: l_PRICE_LIST_LINE_rec.rltd_modifier_group_no := NULL;
1545: END IF;
1546:
1547: IF l_PRICE_LIST_LINE_rec.product_precedence = FND_API.G_MISS_NUM THEN
1548: l_PRICE_LIST_LINE_rec.product_precedence := NULL;
1549: END IF;
1550:
1551: IF l_PRICE_LIST_LINE_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
1547: IF l_PRICE_LIST_LINE_rec.product_precedence = FND_API.G_MISS_NUM THEN
1548: l_PRICE_LIST_LINE_rec.product_precedence := NULL;
1549: END IF;
1550:
1551: IF l_PRICE_LIST_LINE_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
1552: l_PRICE_LIST_LINE_rec.modifier_level_code := NULL;
1553: END IF;
1554:
1555: IF l_PRICE_LIST_LINE_rec.number_effective_periods = FND_API.G_MISS_NUM THEN
1551: IF l_PRICE_LIST_LINE_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
1552: l_PRICE_LIST_LINE_rec.modifier_level_code := NULL;
1553: END IF;
1554:
1555: IF l_PRICE_LIST_LINE_rec.number_effective_periods = FND_API.G_MISS_NUM THEN
1556: l_PRICE_LIST_LINE_rec.number_effective_periods := NULL;
1557: END IF;
1558:
1559: IF l_PRICE_LIST_LINE_rec.operand = FND_API.G_MISS_NUM THEN
1555: IF l_PRICE_LIST_LINE_rec.number_effective_periods = FND_API.G_MISS_NUM THEN
1556: l_PRICE_LIST_LINE_rec.number_effective_periods := NULL;
1557: END IF;
1558:
1559: IF l_PRICE_LIST_LINE_rec.operand = FND_API.G_MISS_NUM THEN
1560: l_PRICE_LIST_LINE_rec.operand := NULL;
1561: END IF;
1562:
1563: IF l_PRICE_LIST_LINE_rec.organization_id = FND_API.G_MISS_NUM THEN
1559: IF l_PRICE_LIST_LINE_rec.operand = FND_API.G_MISS_NUM THEN
1560: l_PRICE_LIST_LINE_rec.operand := NULL;
1561: END IF;
1562:
1563: IF l_PRICE_LIST_LINE_rec.organization_id = FND_API.G_MISS_NUM THEN
1564: l_PRICE_LIST_LINE_rec.organization_id := NULL;
1565: END IF;
1566:
1567: IF l_PRICE_LIST_LINE_rec.override_flag = FND_API.G_MISS_CHAR THEN
1563: IF l_PRICE_LIST_LINE_rec.organization_id = FND_API.G_MISS_NUM THEN
1564: l_PRICE_LIST_LINE_rec.organization_id := NULL;
1565: END IF;
1566:
1567: IF l_PRICE_LIST_LINE_rec.override_flag = FND_API.G_MISS_CHAR THEN
1568: l_PRICE_LIST_LINE_rec.override_flag := NULL;
1569: END IF;
1570:
1571: IF l_PRICE_LIST_LINE_rec.percent_price = FND_API.G_MISS_NUM THEN
1567: IF l_PRICE_LIST_LINE_rec.override_flag = FND_API.G_MISS_CHAR THEN
1568: l_PRICE_LIST_LINE_rec.override_flag := NULL;
1569: END IF;
1570:
1571: IF l_PRICE_LIST_LINE_rec.percent_price = FND_API.G_MISS_NUM THEN
1572: l_PRICE_LIST_LINE_rec.percent_price := NULL;
1573: END IF;
1574:
1575: IF l_PRICE_LIST_LINE_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
1571: IF l_PRICE_LIST_LINE_rec.percent_price = FND_API.G_MISS_NUM THEN
1572: l_PRICE_LIST_LINE_rec.percent_price := NULL;
1573: END IF;
1574:
1575: IF l_PRICE_LIST_LINE_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
1576: l_PRICE_LIST_LINE_rec.price_break_type_code := NULL;
1577: END IF;
1578:
1579: IF l_PRICE_LIST_LINE_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
1575: IF l_PRICE_LIST_LINE_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
1576: l_PRICE_LIST_LINE_rec.price_break_type_code := NULL;
1577: END IF;
1578:
1579: IF l_PRICE_LIST_LINE_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
1580: l_PRICE_LIST_LINE_rec.price_by_formula_id := NULL;
1581: END IF;
1582:
1583: IF l_PRICE_LIST_LINE_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
1579: IF l_PRICE_LIST_LINE_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
1580: l_PRICE_LIST_LINE_rec.price_by_formula_id := NULL;
1581: END IF;
1582:
1583: IF l_PRICE_LIST_LINE_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
1584: l_PRICE_LIST_LINE_rec.primary_uom_flag := NULL;
1585: END IF;
1586:
1587: IF l_PRICE_LIST_LINE_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
1583: IF l_PRICE_LIST_LINE_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
1584: l_PRICE_LIST_LINE_rec.primary_uom_flag := NULL;
1585: END IF;
1586:
1587: IF l_PRICE_LIST_LINE_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
1588: l_PRICE_LIST_LINE_rec.print_on_invoice_flag := NULL;
1589: END IF;
1590:
1591: IF l_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM THEN
1587: IF l_PRICE_LIST_LINE_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
1588: l_PRICE_LIST_LINE_rec.print_on_invoice_flag := NULL;
1589: END IF;
1590:
1591: IF l_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM THEN
1592: l_PRICE_LIST_LINE_rec.program_application_id := NULL;
1593: END IF;
1594:
1595: IF l_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM THEN
1591: IF l_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM THEN
1592: l_PRICE_LIST_LINE_rec.program_application_id := NULL;
1593: END IF;
1594:
1595: IF l_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM THEN
1596: l_PRICE_LIST_LINE_rec.program_id := NULL;
1597: END IF;
1598:
1599: IF l_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN
1595: IF l_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM THEN
1596: l_PRICE_LIST_LINE_rec.program_id := NULL;
1597: END IF;
1598:
1599: IF l_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN
1600: l_PRICE_LIST_LINE_rec.program_update_date := NULL;
1601: END IF;
1602:
1603: IF l_PRICE_LIST_LINE_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
1599: IF l_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN
1600: l_PRICE_LIST_LINE_rec.program_update_date := NULL;
1601: END IF;
1602:
1603: IF l_PRICE_LIST_LINE_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
1604: l_PRICE_LIST_LINE_rec.rebate_trxn_type_code := NULL;
1605: END IF;
1606:
1607: -- block pricing
1604: l_PRICE_LIST_LINE_rec.rebate_trxn_type_code := NULL;
1605: END IF;
1606:
1607: -- block pricing
1608: IF l_PRICE_LIST_LINE_rec.recurring_value = FND_API.G_MISS_NUM THEN
1609: l_PRICE_LIST_LINE_rec.recurring_value := NULL;
1610: END IF;
1611:
1612: IF l_PRICE_LIST_LINE_rec.related_item_id = FND_API.G_MISS_NUM THEN
1608: IF l_PRICE_LIST_LINE_rec.recurring_value = FND_API.G_MISS_NUM THEN
1609: l_PRICE_LIST_LINE_rec.recurring_value := NULL;
1610: END IF;
1611:
1612: IF l_PRICE_LIST_LINE_rec.related_item_id = FND_API.G_MISS_NUM THEN
1613: l_PRICE_LIST_LINE_rec.related_item_id := NULL;
1614: END IF;
1615:
1616: IF l_PRICE_LIST_LINE_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
1612: IF l_PRICE_LIST_LINE_rec.related_item_id = FND_API.G_MISS_NUM THEN
1613: l_PRICE_LIST_LINE_rec.related_item_id := NULL;
1614: END IF;
1615:
1616: IF l_PRICE_LIST_LINE_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
1617: l_PRICE_LIST_LINE_rec.relationship_type_id := NULL;
1618: END IF;
1619:
1620: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
1616: IF l_PRICE_LIST_LINE_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
1617: l_PRICE_LIST_LINE_rec.relationship_type_id := NULL;
1618: END IF;
1619:
1620: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
1621: l_PRICE_LIST_LINE_rec.reprice_flag := NULL;
1622: END IF;
1623:
1624: IF l_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM THEN
1620: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
1621: l_PRICE_LIST_LINE_rec.reprice_flag := NULL;
1622: END IF;
1623:
1624: IF l_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM THEN
1625: l_PRICE_LIST_LINE_rec.request_id := NULL;
1626: END IF;
1627:
1628: IF l_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR THEN
1624: IF l_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM THEN
1625: l_PRICE_LIST_LINE_rec.request_id := NULL;
1626: END IF;
1627:
1628: IF l_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR THEN
1629: l_PRICE_LIST_LINE_rec.revision := NULL;
1630: END IF;
1631:
1632: IF l_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE THEN
1628: IF l_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR THEN
1629: l_PRICE_LIST_LINE_rec.revision := NULL;
1630: END IF;
1631:
1632: IF l_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE THEN
1633: l_PRICE_LIST_LINE_rec.revision_date := NULL;
1634: END IF;
1635:
1636: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1632: IF l_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE THEN
1633: l_PRICE_LIST_LINE_rec.revision_date := NULL;
1634: END IF;
1635:
1636: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1637: l_PRICE_LIST_LINE_rec.revision_reason_code := NULL;
1638: END IF;
1639:
1640: IF l_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE THEN
1636: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1637: l_PRICE_LIST_LINE_rec.revision_reason_code := NULL;
1638: END IF;
1639:
1640: IF l_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE THEN
1641: l_PRICE_LIST_LINE_rec.start_date_active := NULL;
1642: END IF;
1643:
1644: IF l_PRICE_LIST_LINE_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
1640: IF l_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE THEN
1641: l_PRICE_LIST_LINE_rec.start_date_active := NULL;
1642: END IF;
1643:
1644: IF l_PRICE_LIST_LINE_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
1645: l_PRICE_LIST_LINE_rec.substitution_attribute := NULL;
1646: END IF;
1647:
1648: IF l_PRICE_LIST_LINE_rec.substitution_context = FND_API.G_MISS_CHAR THEN
1644: IF l_PRICE_LIST_LINE_rec.substitution_attribute = FND_API.G_MISS_CHAR THEN
1645: l_PRICE_LIST_LINE_rec.substitution_attribute := NULL;
1646: END IF;
1647:
1648: IF l_PRICE_LIST_LINE_rec.substitution_context = FND_API.G_MISS_CHAR THEN
1649: l_PRICE_LIST_LINE_rec.substitution_context := NULL;
1650: END IF;
1651:
1652: IF l_PRICE_LIST_LINE_rec.substitution_value = FND_API.G_MISS_CHAR THEN
1648: IF l_PRICE_LIST_LINE_rec.substitution_context = FND_API.G_MISS_CHAR THEN
1649: l_PRICE_LIST_LINE_rec.substitution_context := NULL;
1650: END IF;
1651:
1652: IF l_PRICE_LIST_LINE_rec.substitution_value = FND_API.G_MISS_CHAR THEN
1653: l_PRICE_LIST_LINE_rec.substitution_value := NULL;
1654: END IF;
1655:
1656: IF l_PRICE_LIST_LINE_rec.qualification_ind = FND_API.G_MISS_NUM THEN
1652: IF l_PRICE_LIST_LINE_rec.substitution_value = FND_API.G_MISS_CHAR THEN
1653: l_PRICE_LIST_LINE_rec.substitution_value := NULL;
1654: END IF;
1655:
1656: IF l_PRICE_LIST_LINE_rec.qualification_ind = FND_API.G_MISS_NUM THEN
1657: l_PRICE_LIST_LINE_rec.qualification_ind := NULL;
1658: END IF;
1659:
1660: IF l_PRICE_LIST_LINE_rec.break_uom_code = FND_API.G_MISS_CHAR THEN
1656: IF l_PRICE_LIST_LINE_rec.qualification_ind = FND_API.G_MISS_NUM THEN
1657: l_PRICE_LIST_LINE_rec.qualification_ind := NULL;
1658: END IF;
1659:
1660: IF l_PRICE_LIST_LINE_rec.break_uom_code = FND_API.G_MISS_CHAR THEN
1661: l_PRICE_LIST_LINE_rec.break_uom_code := NULL;
1662: END IF;
1663:
1664: IF l_PRICE_LIST_LINE_rec.break_uom_context = FND_API.G_MISS_CHAR THEN
1660: IF l_PRICE_LIST_LINE_rec.break_uom_code = FND_API.G_MISS_CHAR THEN
1661: l_PRICE_LIST_LINE_rec.break_uom_code := NULL;
1662: END IF;
1663:
1664: IF l_PRICE_LIST_LINE_rec.break_uom_context = FND_API.G_MISS_CHAR THEN
1665: l_PRICE_LIST_LINE_rec.break_uom_context := NULL;
1666: END IF;
1667:
1668: IF l_PRICE_LIST_LINE_rec.break_uom_attribute = FND_API.G_MISS_CHAR THEN
1664: IF l_PRICE_LIST_LINE_rec.break_uom_context = FND_API.G_MISS_CHAR THEN
1665: l_PRICE_LIST_LINE_rec.break_uom_context := NULL;
1666: END IF;
1667:
1668: IF l_PRICE_LIST_LINE_rec.break_uom_attribute = FND_API.G_MISS_CHAR THEN
1669: l_PRICE_LIST_LINE_rec.break_uom_attribute := NULL;
1670: END IF;
1671:
1672: IF l_PRICE_LIST_LINE_rec.continuous_price_break_flag = FND_API.G_MISS_CHAR THEN
1668: IF l_PRICE_LIST_LINE_rec.break_uom_attribute = FND_API.G_MISS_CHAR THEN
1669: l_PRICE_LIST_LINE_rec.break_uom_attribute := NULL;
1670: END IF;
1671:
1672: IF l_PRICE_LIST_LINE_rec.continuous_price_break_flag = FND_API.G_MISS_CHAR THEN
1673: l_PRICE_LIST_LINE_rec.continuous_price_break_flag := NULL;
1674: END IF;
1675:
1676: RETURN l_PRICE_LIST_LINE_rec;
1836: , 'Update_Row'
1837: );
1838: END IF;
1839:
1840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1841:
1842: END Update_Row;
1843:
1844: -- Procedure Insert_Row
2075: , 'Insert_Row'
2076: );
2077: END IF;
2078:
2079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2080:
2081: END Insert_Row;
2082:
2083: -- Procedure delete_Row
2144: , 'Delete_Row'
2145: );
2146: END IF;
2147:
2148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2149:
2150: END Delete_Row;
2151:
2152: -- Function Query_Row
2168: --
2169:
2170: FUNCTION Query_Rows
2171: ( p_list_line_id IN NUMBER :=
2172: FND_API.G_MISS_NUM
2173: , p_list_header_id IN NUMBER :=
2174: FND_API.G_MISS_NUM
2175: ) RETURN QP_Price_List_PUB.Price_List_Line_Tbl_Type
2176: IS
2170: FUNCTION Query_Rows
2171: ( p_list_line_id IN NUMBER :=
2172: FND_API.G_MISS_NUM
2173: , p_list_header_id IN NUMBER :=
2174: FND_API.G_MISS_NUM
2175: ) RETURN QP_Price_List_PUB.Price_List_Line_Tbl_Type
2176: IS
2177: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
2178: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
2338:
2339: IF
2340: (p_list_line_id IS NOT NULL
2341: AND
2342: p_list_line_id <> FND_API.G_MISS_NUM)
2343: AND
2344: (p_list_header_id IS NOT NULL
2345: AND
2346: p_list_header_id <> FND_API.G_MISS_NUM)
2342: p_list_line_id <> FND_API.G_MISS_NUM)
2343: AND
2344: (p_list_header_id IS NOT NULL
2345: AND
2346: p_list_header_id <> FND_API.G_MISS_NUM)
2347: THEN
2348: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2349: THEN
2350: oe_msg_pub.Add_Exc_Msg
2353: , 'Keys are mutually exclusive: list_line_id = '|| p_list_line_id || ', list_header_id = '|| p_list_header_id
2354: );
2355: END IF;
2356:
2357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2358:
2359: END IF;
2360:
2361:
2359: END IF;
2360:
2361:
2362: -- Loop over fetched records
2363: IF (p_list_line_id IS NOT NULL) AND (p_list_line_id <> FND_API.G_MISS_NUM) THEN --Added for performance bug2422019
2364: FOR l_implicit_rec IN l_PRICE_LIST_LINE_csr LOOP
2365:
2366: l_PRICE_LIST_LINE_rec.accrual_qty := l_implicit_rec.ACCRUAL_QTY;
2367: l_PRICE_LIST_LINE_rec.accrual_uom_code := l_implicit_rec.ACCRUAL_UOM_CODE;
2463: END LOOP;
2464:
2465: /* Added for performance bug2422019 */
2466:
2467: ELSIF (p_list_header_id IS NOT NULL) AND (p_list_header_id <> FND_API.G_MISS_NUM) THEN
2468: FOR l_implicit_rec IN l_PRICE_LIST_LINE_hdr_csr LOOP
2469:
2470: l_PRICE_LIST_LINE_rec.accrual_qty := l_implicit_rec.ACCRUAL_QTY;
2471: l_PRICE_LIST_LINE_rec.accrual_uom_code := l_implicit_rec.ACCRUAL_UOM_CODE;
2572:
2573: IF
2574: (p_list_line_id IS NOT NULL
2575: AND
2576: p_list_line_id <> FND_API.G_MISS_NUM)
2577: AND
2578: (l_PRICE_LIST_LINE_tbl.COUNT = 0)
2579: THEN
2580: RAISE NO_DATA_FOUND;
2586: RETURN l_PRICE_LIST_LINE_tbl;
2587:
2588: EXCEPTION
2589:
2590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2591:
2592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2593:
2594: WHEN OTHERS THEN
2588: EXCEPTION
2589:
2590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2591:
2592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2593:
2594: WHEN OTHERS THEN
2595:
2596: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2600: , 'Query_Rows'
2601: );
2602: END IF;
2603:
2604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2605:
2606: END Query_Rows;
2607:
2608: -- Procedure lock_Row
2974: x_PRICE_LIST_LINE_rec := l_PRICE_LIST_LINE_rec;
2975:
2976: -- Set return status
2977:
2978: x_return_status := FND_API.G_RET_STS_SUCCESS;
2979: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2980:
2981: ELSE
2982: --8594682 - Add debug messages for OE_LOCK error
2975:
2976: -- Set return status
2977:
2978: x_return_status := FND_API.G_RET_STS_SUCCESS;
2979: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2980:
2981: ELSE
2982: --8594682 - Add debug messages for OE_LOCK error
2983: oe_debug_pub.ADD('-------------------Data compare in Price list line (database vs record)------------------');
3052: oe_debug_pub.ADD('-------------------Data compare in price list line end------------------');
3053: -- Row has changed by another user.
3054:
3055:
3056: x_return_status := FND_API.G_RET_STS_ERROR;
3057: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3058:
3059: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
3060: THEN
3053: -- Row has changed by another user.
3054:
3055:
3056: x_return_status := FND_API.G_RET_STS_ERROR;
3057: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3058:
3059: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
3060: THEN
3061:
3069: EXCEPTION
3070:
3071: WHEN NO_DATA_FOUND THEN
3072:
3073: x_return_status := FND_API.G_RET_STS_ERROR;
3074: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3075:
3076: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
3077: THEN
3070:
3071: WHEN NO_DATA_FOUND THEN
3072:
3073: x_return_status := FND_API.G_RET_STS_ERROR;
3074: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3075:
3076: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
3077: THEN
3078:
3081:
3082: END IF;
3083: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3084:
3085: x_return_status := FND_API.G_RET_STS_ERROR;
3086: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3087:
3088: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
3089: THEN
3082: END IF;
3083: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3084:
3085: x_return_status := FND_API.G_RET_STS_ERROR;
3086: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3087:
3088: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
3089: THEN
3090:
3093:
3094: END IF;
3095: WHEN OTHERS THEN
3096:
3097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3098: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3099:
3100: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3101: THEN
3094: END IF;
3095: WHEN OTHERS THEN
3096:
3097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3098: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3099:
3100: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3101: THEN
3102: oe_msg_pub.Add_Exc_Msg
3119: BEGIN
3120:
3121: /*
3122: IF p_PRICE_LIST_LINE_rec.accrual_uom_code IS NOT NULL AND
3123: p_PRICE_LIST_LINE_rec.accrual_uom_code <> FND_API.G_MISS_CHAR AND
3124: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.accrual_uom_code,
3125: p_old_PRICE_LIST_LINE_rec.accrual_uom_code)
3126: THEN
3127: l_PRICE_LIST_LINE_val_rec.accrual_uom := QP_Id_To_Value.Accrual_Uom
3131:
3132: */
3133:
3134: IF p_PRICE_LIST_LINE_rec.automatic_flag IS NOT NULL AND
3135: p_PRICE_LIST_LINE_rec.automatic_flag <> FND_API.G_MISS_CHAR AND
3136: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.automatic_flag,
3137: p_old_PRICE_LIST_LINE_rec.automatic_flag)
3138: THEN
3139: l_PRICE_LIST_LINE_val_rec.automatic := QP_Id_To_Value.Automatic
3141: );
3142: END IF;
3143:
3144: IF p_PRICE_LIST_LINE_rec.base_uom_code IS NOT NULL AND
3145: p_PRICE_LIST_LINE_rec.base_uom_code <> FND_API.G_MISS_CHAR AND
3146: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.base_uom_code,
3147: p_old_PRICE_LIST_LINE_rec.base_uom_code)
3148: THEN
3149: l_PRICE_LIST_LINE_val_rec.base_uom := QP_Id_To_Value.Base_Uom
3151: );
3152: END IF;
3153:
3154: IF p_PRICE_LIST_LINE_rec.generate_using_formula_id IS NOT NULL AND
3155: p_PRICE_LIST_LINE_rec.generate_using_formula_id <> FND_API.G_MISS_NUM AND
3156: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.generate_using_formula_id,
3157: p_old_PRICE_LIST_LINE_rec.generate_using_formula_id)
3158: THEN
3159: l_PRICE_LIST_LINE_val_rec.generate_using_formula := QP_Id_To_Value.Generate_Using_Formula
3162: END IF;
3163:
3164:
3165: IF p_PRICE_LIST_LINE_rec.inventory_item_id IS NOT NULL AND
3166: p_PRICE_LIST_LINE_rec.inventory_item_id <> FND_API.G_MISS_NUM AND
3167: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.inventory_item_id,
3168: p_old_PRICE_LIST_LINE_rec.inventory_item_id)
3169: THEN
3170: l_PRICE_LIST_LINE_val_rec.inventory_item := QP_Id_To_Value.Inventory_Item
3172: );
3173: END IF;
3174:
3175: IF p_PRICE_LIST_LINE_rec.list_header_id IS NOT NULL AND
3176: p_PRICE_LIST_LINE_rec.list_header_id <> FND_API.G_MISS_NUM AND
3177: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_header_id,
3178: p_old_PRICE_LIST_LINE_rec.list_header_id)
3179: THEN
3180: l_PRICE_LIST_LINE_val_rec.list_header := QP_Id_To_Value.List_Header
3182: );
3183: END IF;
3184:
3185: IF p_PRICE_LIST_LINE_rec.list_line_id IS NOT NULL AND
3186: p_PRICE_LIST_LINE_rec.list_line_id <> FND_API.G_MISS_NUM AND
3187: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_line_id,
3188: p_old_PRICE_LIST_LINE_rec.list_line_id)
3189: THEN
3190: l_PRICE_LIST_LINE_val_rec.list_line := QP_Id_To_Value.List_Line
3192: );
3193: END IF;
3194:
3195: IF p_PRICE_LIST_LINE_rec.list_line_type_code IS NOT NULL AND
3196: p_PRICE_LIST_LINE_rec.list_line_type_code <> FND_API.G_MISS_CHAR AND
3197: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_line_type_code,
3198: p_old_PRICE_LIST_LINE_rec.list_line_type_code)
3199: THEN
3200: l_PRICE_LIST_LINE_val_rec.list_line_type := QP_Id_To_Value.List_Line_Type
3202: );
3203: END IF;
3204:
3205: IF p_PRICE_LIST_LINE_rec.modifier_level_code IS NOT NULL AND
3206: p_PRICE_LIST_LINE_rec.modifier_level_code <> FND_API.G_MISS_CHAR AND
3207: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.modifier_level_code,
3208: p_old_PRICE_LIST_LINE_rec.modifier_level_code)
3209: THEN
3210: l_PRICE_LIST_LINE_val_rec.modifier_level := QP_Id_To_Value.Modifier_Level
3212: );
3213: END IF;
3214:
3215: IF p_PRICE_LIST_LINE_rec.organization_id IS NOT NULL AND
3216: p_PRICE_LIST_LINE_rec.organization_id <> FND_API.G_MISS_NUM AND
3217: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.organization_id,
3218: p_old_PRICE_LIST_LINE_rec.organization_id)
3219: THEN
3220: l_PRICE_LIST_LINE_val_rec.organization := QP_Id_To_Value.Organization
3222: );
3223: END IF;
3224:
3225: IF p_PRICE_LIST_LINE_rec.override_flag IS NOT NULL AND
3226: p_PRICE_LIST_LINE_rec.override_flag <> FND_API.G_MISS_CHAR AND
3227: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.override_flag,
3228: p_old_PRICE_LIST_LINE_rec.override_flag)
3229: THEN
3230: l_PRICE_LIST_LINE_val_rec.override := QP_Id_To_Value.Override
3232: );
3233: END IF;
3234:
3235: IF p_PRICE_LIST_LINE_rec.price_break_type_code IS NOT NULL AND
3236: p_PRICE_LIST_LINE_rec.price_break_type_code <> FND_API.G_MISS_CHAR AND
3237: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_break_type_code,
3238: p_old_PRICE_LIST_LINE_rec.price_break_type_code)
3239: THEN
3240: l_PRICE_LIST_LINE_val_rec.price_break_type := QP_Id_To_Value.Price_Break_Type
3242: );
3243: END IF;
3244:
3245: IF p_PRICE_LIST_LINE_rec.price_by_formula_id IS NOT NULL AND
3246: p_PRICE_LIST_LINE_rec.price_by_formula_id <> FND_API.G_MISS_NUM AND
3247: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_by_formula_id,
3248: p_old_PRICE_LIST_LINE_rec.price_by_formula_id)
3249: THEN
3250: l_PRICE_LIST_LINE_val_rec.price_by_formula := QP_Id_To_Value.Price_By_Formula
3252: );
3253: END IF;
3254:
3255: IF p_PRICE_LIST_LINE_rec.primary_uom_flag IS NOT NULL AND
3256: p_PRICE_LIST_LINE_rec.primary_uom_flag <> FND_API.G_MISS_CHAR AND
3257: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.primary_uom_flag,
3258: p_old_PRICE_LIST_LINE_rec.primary_uom_flag)
3259: THEN
3260: l_PRICE_LIST_LINE_val_rec.primary_uom := QP_Id_To_Value.Primary_Uom
3262: );
3263: END IF;
3264:
3265: IF p_PRICE_LIST_LINE_rec.print_on_invoice_flag IS NOT NULL AND
3266: p_PRICE_LIST_LINE_rec.print_on_invoice_flag <> FND_API.G_MISS_CHAR AND
3267: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.print_on_invoice_flag,
3268: p_old_PRICE_LIST_LINE_rec.print_on_invoice_flag)
3269: THEN
3270: l_PRICE_LIST_LINE_val_rec.print_on_invoice := QP_Id_To_Value.Print_On_Invoice
3272: );
3273: END IF;
3274:
3275: IF p_PRICE_LIST_LINE_rec.rebate_trxn_type_code IS NOT NULL AND
3276: p_PRICE_LIST_LINE_rec.rebate_trxn_type_code <> FND_API.G_MISS_CHAR AND
3277: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.rebate_trxn_type_code,
3278: p_old_PRICE_LIST_LINE_rec.rebate_trxn_type_code)
3279: THEN
3280: l_PRICE_LIST_LINE_val_rec.rebate_transaction_type := QP_Id_To_Value.Rebate_Transaction_Type
3282: );
3283: END IF;
3284:
3285: IF p_PRICE_LIST_LINE_rec.related_item_id IS NOT NULL AND
3286: p_PRICE_LIST_LINE_rec.related_item_id <> FND_API.G_MISS_NUM AND
3287: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.related_item_id,
3288: p_old_PRICE_LIST_LINE_rec.related_item_id)
3289: THEN
3290: l_PRICE_LIST_LINE_val_rec.related_item := QP_Id_To_Value.Related_Item
3292: );
3293: END IF;
3294:
3295: IF p_PRICE_LIST_LINE_rec.relationship_type_id IS NOT NULL AND
3296: p_PRICE_LIST_LINE_rec.relationship_type_id <> FND_API.G_MISS_NUM AND
3297: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.relationship_type_id,
3298: p_old_PRICE_LIST_LINE_rec.relationship_type_id)
3299: THEN
3300: l_PRICE_LIST_LINE_val_rec.relationship_type := QP_Id_To_Value.Relationship_Type
3302: );
3303: END IF;
3304:
3305: IF p_PRICE_LIST_LINE_rec.reprice_flag IS NOT NULL AND
3306: p_PRICE_LIST_LINE_rec.reprice_flag <> FND_API.G_MISS_CHAR AND
3307: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.reprice_flag,
3308: p_old_PRICE_LIST_LINE_rec.reprice_flag)
3309: THEN
3310: l_PRICE_LIST_LINE_val_rec.reprice := QP_Id_To_Value.Reprice
3312: );
3313: END IF;
3314:
3315: IF p_PRICE_LIST_LINE_rec.revision_reason_code IS NOT NULL AND
3316: p_PRICE_LIST_LINE_rec.revision_reason_code <> FND_API.G_MISS_CHAR AND
3317: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision_reason_code,
3318: p_old_PRICE_LIST_LINE_rec.revision_reason_code)
3319: THEN
3320: l_PRICE_LIST_LINE_val_rec.revision_reason := QP_Id_To_Value.Revision_Reason
3337: BEGIN
3338:
3339: -- initialize return_status.
3340:
3341: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3342:
3343: -- initialize l_PRICE_LIST_LINE_rec.
3344:
3345: l_PRICE_LIST_LINE_rec := p_PRICE_LIST_LINE_rec;
3343: -- initialize l_PRICE_LIST_LINE_rec.
3344:
3345: l_PRICE_LIST_LINE_rec := p_PRICE_LIST_LINE_rec;
3346:
3347: IF p_PRICE_LIST_LINE_val_rec.accrual_uom <> FND_API.G_MISS_CHAR
3348: THEN
3349:
3350: IF p_PRICE_LIST_LINE_rec.accrual_uom_code <> FND_API.G_MISS_CHAR THEN
3351:
3346:
3347: IF p_PRICE_LIST_LINE_val_rec.accrual_uom <> FND_API.G_MISS_CHAR
3348: THEN
3349:
3350: IF p_PRICE_LIST_LINE_rec.accrual_uom_code <> FND_API.G_MISS_CHAR THEN
3351:
3352: l_PRICE_LIST_LINE_rec.accrual_uom_code := p_PRICE_LIST_LINE_rec.accrual_uom_code;
3353:
3354: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3369: );
3370:
3371: */
3372:
3373: IF l_PRICE_LIST_LINE_rec.accrual_uom_code = FND_API.G_MISS_CHAR THEN
3374: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3375: END IF;
3376:
3377: END IF;
3370:
3371: */
3372:
3373: IF l_PRICE_LIST_LINE_rec.accrual_uom_code = FND_API.G_MISS_CHAR THEN
3374: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3375: END IF;
3376:
3377: END IF;
3378:
3377: END IF;
3378:
3379: END IF;
3380:
3381: IF p_PRICE_LIST_LINE_val_rec.automatic <> FND_API.G_MISS_CHAR
3382: THEN
3383:
3384: IF p_PRICE_LIST_LINE_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
3385:
3380:
3381: IF p_PRICE_LIST_LINE_val_rec.automatic <> FND_API.G_MISS_CHAR
3382: THEN
3383:
3384: IF p_PRICE_LIST_LINE_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
3385:
3386: l_PRICE_LIST_LINE_rec.automatic_flag := p_PRICE_LIST_LINE_rec.automatic_flag;
3387:
3388: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3399: l_PRICE_LIST_LINE_rec.automatic_flag := QP_Value_To_Id.automatic
3400: ( p_automatic => p_PRICE_LIST_LINE_val_rec.automatic
3401: );
3402:
3403: IF l_PRICE_LIST_LINE_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
3404: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3405: END IF;
3406:
3407: END IF;
3400: ( p_automatic => p_PRICE_LIST_LINE_val_rec.automatic
3401: );
3402:
3403: IF l_PRICE_LIST_LINE_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
3404: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3405: END IF;
3406:
3407: END IF;
3408:
3407: END IF;
3408:
3409: END IF;
3410:
3411: IF p_PRICE_LIST_LINE_val_rec.base_uom <> FND_API.G_MISS_CHAR
3412: THEN
3413:
3414: IF p_PRICE_LIST_LINE_rec.base_uom_code <> FND_API.G_MISS_CHAR THEN
3415:
3410:
3411: IF p_PRICE_LIST_LINE_val_rec.base_uom <> FND_API.G_MISS_CHAR
3412: THEN
3413:
3414: IF p_PRICE_LIST_LINE_rec.base_uom_code <> FND_API.G_MISS_CHAR THEN
3415:
3416: l_PRICE_LIST_LINE_rec.base_uom_code := p_PRICE_LIST_LINE_rec.base_uom_code;
3417:
3418: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3429: l_PRICE_LIST_LINE_rec.base_uom_code := QP_Value_To_Id.base_uom
3430: ( p_base_uom => p_PRICE_LIST_LINE_val_rec.base_uom
3431: );
3432:
3433: IF l_PRICE_LIST_LINE_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
3434: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3435: END IF;
3436:
3437: END IF;
3430: ( p_base_uom => p_PRICE_LIST_LINE_val_rec.base_uom
3431: );
3432:
3433: IF l_PRICE_LIST_LINE_rec.base_uom_code = FND_API.G_MISS_CHAR THEN
3434: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3435: END IF;
3436:
3437: END IF;
3438:
3437: END IF;
3438:
3439: END IF;
3440:
3441: IF p_PRICE_LIST_LINE_val_rec.generate_using_formula <> FND_API.G_MISS_CHAR
3442: THEN
3443:
3444: IF p_PRICE_LIST_LINE_rec.generate_using_formula_id <> FND_API.G_MISS_NUM THEN
3445:
3440:
3441: IF p_PRICE_LIST_LINE_val_rec.generate_using_formula <> FND_API.G_MISS_CHAR
3442: THEN
3443:
3444: IF p_PRICE_LIST_LINE_rec.generate_using_formula_id <> FND_API.G_MISS_NUM THEN
3445:
3446: l_PRICE_LIST_LINE_rec.generate_using_formula_id := p_PRICE_LIST_LINE_rec.generate_using_formula_id;
3447:
3448: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3459: l_PRICE_LIST_LINE_rec.generate_using_formula_id := QP_Value_To_Id.generate_using_formula
3460: ( p_generate_using_formula => p_PRICE_LIST_LINE_val_rec.generate_using_formula
3461: );
3462:
3463: IF l_PRICE_LIST_LINE_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
3464: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3465: END IF;
3466:
3467: END IF;
3460: ( p_generate_using_formula => p_PRICE_LIST_LINE_val_rec.generate_using_formula
3461: );
3462:
3463: IF l_PRICE_LIST_LINE_rec.generate_using_formula_id = FND_API.G_MISS_NUM THEN
3464: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3465: END IF;
3466:
3467: END IF;
3468:
3467: END IF;
3468:
3469: END IF;
3470:
3471: IF p_PRICE_LIST_LINE_val_rec.inventory_item <> FND_API.G_MISS_CHAR
3472: THEN
3473:
3474: IF p_PRICE_LIST_LINE_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
3475:
3470:
3471: IF p_PRICE_LIST_LINE_val_rec.inventory_item <> FND_API.G_MISS_CHAR
3472: THEN
3473:
3474: IF p_PRICE_LIST_LINE_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
3475:
3476: l_PRICE_LIST_LINE_rec.inventory_item_id := p_PRICE_LIST_LINE_rec.inventory_item_id;
3477:
3478: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3489: l_PRICE_LIST_LINE_rec.inventory_item_id := QP_Value_To_Id.inventory_item
3490: ( p_inventory_item => p_PRICE_LIST_LINE_val_rec.inventory_item
3491: );
3492:
3493: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
3494: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3495: END IF;
3496:
3497: END IF;
3490: ( p_inventory_item => p_PRICE_LIST_LINE_val_rec.inventory_item
3491: );
3492:
3493: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
3494: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3495: END IF;
3496:
3497: END IF;
3498:
3497: END IF;
3498:
3499: END IF;
3500:
3501: IF p_PRICE_LIST_LINE_val_rec.list_header <> FND_API.G_MISS_CHAR
3502: THEN
3503:
3504: IF p_PRICE_LIST_LINE_rec.list_header_id <> FND_API.G_MISS_NUM THEN
3505:
3500:
3501: IF p_PRICE_LIST_LINE_val_rec.list_header <> FND_API.G_MISS_CHAR
3502: THEN
3503:
3504: IF p_PRICE_LIST_LINE_rec.list_header_id <> FND_API.G_MISS_NUM THEN
3505:
3506: l_PRICE_LIST_LINE_rec.list_header_id := p_PRICE_LIST_LINE_rec.list_header_id;
3507:
3508: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3519: l_PRICE_LIST_LINE_rec.list_header_id := QP_Value_To_Id.list_header
3520: ( p_list_header => p_PRICE_LIST_LINE_val_rec.list_header
3521: );
3522:
3523: IF l_PRICE_LIST_LINE_rec.list_header_id = FND_API.G_MISS_NUM THEN
3524: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3525: END IF;
3526:
3527: END IF;
3520: ( p_list_header => p_PRICE_LIST_LINE_val_rec.list_header
3521: );
3522:
3523: IF l_PRICE_LIST_LINE_rec.list_header_id = FND_API.G_MISS_NUM THEN
3524: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3525: END IF;
3526:
3527: END IF;
3528:
3527: END IF;
3528:
3529: END IF;
3530:
3531: IF p_PRICE_LIST_LINE_val_rec.list_line <> FND_API.G_MISS_CHAR
3532: THEN
3533:
3534: IF p_PRICE_LIST_LINE_rec.list_line_id <> FND_API.G_MISS_NUM THEN
3535:
3530:
3531: IF p_PRICE_LIST_LINE_val_rec.list_line <> FND_API.G_MISS_CHAR
3532: THEN
3533:
3534: IF p_PRICE_LIST_LINE_rec.list_line_id <> FND_API.G_MISS_NUM THEN
3535:
3536: l_PRICE_LIST_LINE_rec.list_line_id := p_PRICE_LIST_LINE_rec.list_line_id;
3537:
3538: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3549: l_PRICE_LIST_LINE_rec.list_line_id := QP_Value_To_Id.list_line
3550: ( p_list_line => p_PRICE_LIST_LINE_val_rec.list_line
3551: );
3552:
3553: IF l_PRICE_LIST_LINE_rec.list_line_id = FND_API.G_MISS_NUM THEN
3554: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3555: END IF;
3556:
3557: END IF;
3550: ( p_list_line => p_PRICE_LIST_LINE_val_rec.list_line
3551: );
3552:
3553: IF l_PRICE_LIST_LINE_rec.list_line_id = FND_API.G_MISS_NUM THEN
3554: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3555: END IF;
3556:
3557: END IF;
3558:
3557: END IF;
3558:
3559: END IF;
3560:
3561: IF p_PRICE_LIST_LINE_val_rec.list_line_type <> FND_API.G_MISS_CHAR
3562: THEN
3563:
3564: IF p_PRICE_LIST_LINE_rec.list_line_type_code <> FND_API.G_MISS_CHAR THEN
3565:
3560:
3561: IF p_PRICE_LIST_LINE_val_rec.list_line_type <> FND_API.G_MISS_CHAR
3562: THEN
3563:
3564: IF p_PRICE_LIST_LINE_rec.list_line_type_code <> FND_API.G_MISS_CHAR THEN
3565:
3566: l_PRICE_LIST_LINE_rec.list_line_type_code := p_PRICE_LIST_LINE_rec.list_line_type_code;
3567:
3568: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3579: l_PRICE_LIST_LINE_rec.list_line_type_code := QP_Value_To_Id.list_line_type
3580: ( p_list_line_type => p_PRICE_LIST_LINE_val_rec.list_line_type
3581: );
3582:
3583: IF l_PRICE_LIST_LINE_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
3584: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3585: END IF;
3586:
3587: END IF;
3580: ( p_list_line_type => p_PRICE_LIST_LINE_val_rec.list_line_type
3581: );
3582:
3583: IF l_PRICE_LIST_LINE_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
3584: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3585: END IF;
3586:
3587: END IF;
3588:
3587: END IF;
3588:
3589: END IF;
3590:
3591: IF p_PRICE_LIST_LINE_val_rec.modifier_level <> FND_API.G_MISS_CHAR
3592: THEN
3593:
3594: IF p_PRICE_LIST_LINE_rec.modifier_level_code <> FND_API.G_MISS_CHAR THEN
3595:
3590:
3591: IF p_PRICE_LIST_LINE_val_rec.modifier_level <> FND_API.G_MISS_CHAR
3592: THEN
3593:
3594: IF p_PRICE_LIST_LINE_rec.modifier_level_code <> FND_API.G_MISS_CHAR THEN
3595:
3596: l_PRICE_LIST_LINE_rec.modifier_level_code := p_PRICE_LIST_LINE_rec.modifier_level_code;
3597:
3598: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3609: l_PRICE_LIST_LINE_rec.modifier_level_code := QP_Value_To_Id.modifier_level
3610: ( p_modifier_level => p_PRICE_LIST_LINE_val_rec.modifier_level
3611: );
3612:
3613: IF l_PRICE_LIST_LINE_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
3614: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3615: END IF;
3616:
3617: END IF;
3610: ( p_modifier_level => p_PRICE_LIST_LINE_val_rec.modifier_level
3611: );
3612:
3613: IF l_PRICE_LIST_LINE_rec.modifier_level_code = FND_API.G_MISS_CHAR THEN
3614: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3615: END IF;
3616:
3617: END IF;
3618:
3617: END IF;
3618:
3619: END IF;
3620:
3621: IF p_PRICE_LIST_LINE_val_rec.organization <> FND_API.G_MISS_CHAR
3622: THEN
3623:
3624: IF p_PRICE_LIST_LINE_rec.organization_id <> FND_API.G_MISS_NUM THEN
3625:
3620:
3621: IF p_PRICE_LIST_LINE_val_rec.organization <> FND_API.G_MISS_CHAR
3622: THEN
3623:
3624: IF p_PRICE_LIST_LINE_rec.organization_id <> FND_API.G_MISS_NUM THEN
3625:
3626: l_PRICE_LIST_LINE_rec.organization_id := p_PRICE_LIST_LINE_rec.organization_id;
3627:
3628: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3639: l_PRICE_LIST_LINE_rec.organization_id := QP_Value_To_Id.organization
3640: ( p_organization => p_PRICE_LIST_LINE_val_rec.organization
3641: );
3642:
3643: IF l_PRICE_LIST_LINE_rec.organization_id = FND_API.G_MISS_NUM THEN
3644: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3645: END IF;
3646:
3647: END IF;
3640: ( p_organization => p_PRICE_LIST_LINE_val_rec.organization
3641: );
3642:
3643: IF l_PRICE_LIST_LINE_rec.organization_id = FND_API.G_MISS_NUM THEN
3644: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3645: END IF;
3646:
3647: END IF;
3648:
3647: END IF;
3648:
3649: END IF;
3650:
3651: IF p_PRICE_LIST_LINE_val_rec.override <> FND_API.G_MISS_CHAR
3652: THEN
3653:
3654: IF p_PRICE_LIST_LINE_rec.override_flag <> FND_API.G_MISS_CHAR THEN
3655:
3650:
3651: IF p_PRICE_LIST_LINE_val_rec.override <> FND_API.G_MISS_CHAR
3652: THEN
3653:
3654: IF p_PRICE_LIST_LINE_rec.override_flag <> FND_API.G_MISS_CHAR THEN
3655:
3656: l_PRICE_LIST_LINE_rec.override_flag := p_PRICE_LIST_LINE_rec.override_flag;
3657:
3658: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3669: l_PRICE_LIST_LINE_rec.override_flag := QP_Value_To_Id.override
3670: ( p_override => p_PRICE_LIST_LINE_val_rec.override
3671: );
3672:
3673: IF l_PRICE_LIST_LINE_rec.override_flag = FND_API.G_MISS_CHAR THEN
3674: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3675: END IF;
3676:
3677: END IF;
3670: ( p_override => p_PRICE_LIST_LINE_val_rec.override
3671: );
3672:
3673: IF l_PRICE_LIST_LINE_rec.override_flag = FND_API.G_MISS_CHAR THEN
3674: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3675: END IF;
3676:
3677: END IF;
3678:
3677: END IF;
3678:
3679: END IF;
3680:
3681: IF p_PRICE_LIST_LINE_val_rec.price_break_type <> FND_API.G_MISS_CHAR
3682: THEN
3683:
3684: IF p_PRICE_LIST_LINE_rec.price_break_type_code <> FND_API.G_MISS_CHAR THEN
3685:
3680:
3681: IF p_PRICE_LIST_LINE_val_rec.price_break_type <> FND_API.G_MISS_CHAR
3682: THEN
3683:
3684: IF p_PRICE_LIST_LINE_rec.price_break_type_code <> FND_API.G_MISS_CHAR THEN
3685:
3686: l_PRICE_LIST_LINE_rec.price_break_type_code := p_PRICE_LIST_LINE_rec.price_break_type_code;
3687:
3688: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3699: l_PRICE_LIST_LINE_rec.price_break_type_code := QP_Value_To_Id.price_break_type
3700: ( p_price_break_type => p_PRICE_LIST_LINE_val_rec.price_break_type
3701: );
3702:
3703: IF l_PRICE_LIST_LINE_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
3704: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3705: END IF;
3706:
3707: END IF;
3700: ( p_price_break_type => p_PRICE_LIST_LINE_val_rec.price_break_type
3701: );
3702:
3703: IF l_PRICE_LIST_LINE_rec.price_break_type_code = FND_API.G_MISS_CHAR THEN
3704: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3705: END IF;
3706:
3707: END IF;
3708:
3707: END IF;
3708:
3709: END IF;
3710:
3711: IF p_PRICE_LIST_LINE_val_rec.price_by_formula <> FND_API.G_MISS_CHAR
3712: THEN
3713:
3714: IF p_PRICE_LIST_LINE_rec.price_by_formula_id <> FND_API.G_MISS_NUM THEN
3715:
3710:
3711: IF p_PRICE_LIST_LINE_val_rec.price_by_formula <> FND_API.G_MISS_CHAR
3712: THEN
3713:
3714: IF p_PRICE_LIST_LINE_rec.price_by_formula_id <> FND_API.G_MISS_NUM THEN
3715:
3716: l_PRICE_LIST_LINE_rec.price_by_formula_id := p_PRICE_LIST_LINE_rec.price_by_formula_id;
3717:
3718: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3729: l_PRICE_LIST_LINE_rec.price_by_formula_id := QP_Value_To_Id.price_by_formula
3730: ( p_price_by_formula => p_PRICE_LIST_LINE_val_rec.price_by_formula
3731: );
3732:
3733: IF l_PRICE_LIST_LINE_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
3734: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3735: END IF;
3736:
3737: END IF;
3730: ( p_price_by_formula => p_PRICE_LIST_LINE_val_rec.price_by_formula
3731: );
3732:
3733: IF l_PRICE_LIST_LINE_rec.price_by_formula_id = FND_API.G_MISS_NUM THEN
3734: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3735: END IF;
3736:
3737: END IF;
3738:
3737: END IF;
3738:
3739: END IF;
3740:
3741: IF p_PRICE_LIST_LINE_val_rec.primary_uom <> FND_API.G_MISS_CHAR
3742: THEN
3743:
3744: IF p_PRICE_LIST_LINE_rec.primary_uom_flag <> FND_API.G_MISS_CHAR THEN
3745:
3740:
3741: IF p_PRICE_LIST_LINE_val_rec.primary_uom <> FND_API.G_MISS_CHAR
3742: THEN
3743:
3744: IF p_PRICE_LIST_LINE_rec.primary_uom_flag <> FND_API.G_MISS_CHAR THEN
3745:
3746: l_PRICE_LIST_LINE_rec.primary_uom_flag := p_PRICE_LIST_LINE_rec.primary_uom_flag;
3747:
3748: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3759: l_PRICE_LIST_LINE_rec.primary_uom_flag := QP_Value_To_Id.primary_uom
3760: ( p_primary_uom => p_PRICE_LIST_LINE_val_rec.primary_uom
3761: );
3762:
3763: IF l_PRICE_LIST_LINE_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
3764: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3765: END IF;
3766:
3767: END IF;
3760: ( p_primary_uom => p_PRICE_LIST_LINE_val_rec.primary_uom
3761: );
3762:
3763: IF l_PRICE_LIST_LINE_rec.primary_uom_flag = FND_API.G_MISS_CHAR THEN
3764: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3765: END IF;
3766:
3767: END IF;
3768:
3767: END IF;
3768:
3769: END IF;
3770:
3771: IF p_PRICE_LIST_LINE_val_rec.print_on_invoice <> FND_API.G_MISS_CHAR
3772: THEN
3773:
3774: IF p_PRICE_LIST_LINE_rec.print_on_invoice_flag <> FND_API.G_MISS_CHAR THEN
3775:
3770:
3771: IF p_PRICE_LIST_LINE_val_rec.print_on_invoice <> FND_API.G_MISS_CHAR
3772: THEN
3773:
3774: IF p_PRICE_LIST_LINE_rec.print_on_invoice_flag <> FND_API.G_MISS_CHAR THEN
3775:
3776: l_PRICE_LIST_LINE_rec.print_on_invoice_flag := p_PRICE_LIST_LINE_rec.print_on_invoice_flag;
3777:
3778: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3789: l_PRICE_LIST_LINE_rec.print_on_invoice_flag := QP_Value_To_Id.print_on_invoice
3790: ( p_print_on_invoice => p_PRICE_LIST_LINE_val_rec.print_on_invoice
3791: );
3792:
3793: IF l_PRICE_LIST_LINE_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
3794: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3795: END IF;
3796:
3797: END IF;
3790: ( p_print_on_invoice => p_PRICE_LIST_LINE_val_rec.print_on_invoice
3791: );
3792:
3793: IF l_PRICE_LIST_LINE_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR THEN
3794: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3795: END IF;
3796:
3797: END IF;
3798:
3797: END IF;
3798:
3799: END IF;
3800:
3801: IF p_PRICE_LIST_LINE_val_rec.rebate_transaction_type <> FND_API.G_MISS_CHAR
3802: THEN
3803:
3804: IF p_PRICE_LIST_LINE_rec.rebate_trxn_type_code <> FND_API.G_MISS_CHAR THEN
3805:
3800:
3801: IF p_PRICE_LIST_LINE_val_rec.rebate_transaction_type <> FND_API.G_MISS_CHAR
3802: THEN
3803:
3804: IF p_PRICE_LIST_LINE_rec.rebate_trxn_type_code <> FND_API.G_MISS_CHAR THEN
3805:
3806: l_PRICE_LIST_LINE_rec.rebate_trxn_type_code := p_PRICE_LIST_LINE_rec.rebate_trxn_type_code;
3807:
3808: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3819: l_PRICE_LIST_LINE_rec.rebate_trxn_type_code := QP_Value_To_Id.rebate_transaction_type
3820: ( p_rebate_transaction_type => p_PRICE_LIST_LINE_val_rec.rebate_transaction_type
3821: );
3822:
3823: IF l_PRICE_LIST_LINE_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
3824: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3825: END IF;
3826:
3827: END IF;
3820: ( p_rebate_transaction_type => p_PRICE_LIST_LINE_val_rec.rebate_transaction_type
3821: );
3822:
3823: IF l_PRICE_LIST_LINE_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR THEN
3824: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3825: END IF;
3826:
3827: END IF;
3828:
3827: END IF;
3828:
3829: END IF;
3830:
3831: IF p_PRICE_LIST_LINE_val_rec.related_item <> FND_API.G_MISS_CHAR
3832: THEN
3833:
3834: IF p_PRICE_LIST_LINE_rec.related_item_id <> FND_API.G_MISS_NUM THEN
3835:
3830:
3831: IF p_PRICE_LIST_LINE_val_rec.related_item <> FND_API.G_MISS_CHAR
3832: THEN
3833:
3834: IF p_PRICE_LIST_LINE_rec.related_item_id <> FND_API.G_MISS_NUM THEN
3835:
3836: l_PRICE_LIST_LINE_rec.related_item_id := p_PRICE_LIST_LINE_rec.related_item_id;
3837:
3838: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3849: l_PRICE_LIST_LINE_rec.related_item_id := QP_Value_To_Id.related_item
3850: ( p_related_item => p_PRICE_LIST_LINE_val_rec.related_item
3851: );
3852:
3853: IF l_PRICE_LIST_LINE_rec.related_item_id = FND_API.G_MISS_NUM THEN
3854: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3855: END IF;
3856:
3857: END IF;
3850: ( p_related_item => p_PRICE_LIST_LINE_val_rec.related_item
3851: );
3852:
3853: IF l_PRICE_LIST_LINE_rec.related_item_id = FND_API.G_MISS_NUM THEN
3854: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3855: END IF;
3856:
3857: END IF;
3858:
3857: END IF;
3858:
3859: END IF;
3860:
3861: IF p_PRICE_LIST_LINE_val_rec.relationship_type <> FND_API.G_MISS_CHAR
3862: THEN
3863:
3864: IF p_PRICE_LIST_LINE_rec.relationship_type_id <> FND_API.G_MISS_NUM THEN
3865:
3860:
3861: IF p_PRICE_LIST_LINE_val_rec.relationship_type <> FND_API.G_MISS_CHAR
3862: THEN
3863:
3864: IF p_PRICE_LIST_LINE_rec.relationship_type_id <> FND_API.G_MISS_NUM THEN
3865:
3866: l_PRICE_LIST_LINE_rec.relationship_type_id := p_PRICE_LIST_LINE_rec.relationship_type_id;
3867:
3868: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3879: l_PRICE_LIST_LINE_rec.relationship_type_id := QP_Value_To_Id.relationship_type
3880: ( p_relationship_type => p_PRICE_LIST_LINE_val_rec.relationship_type
3881: );
3882:
3883: IF l_PRICE_LIST_LINE_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
3884: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3885: END IF;
3886:
3887: END IF;
3880: ( p_relationship_type => p_PRICE_LIST_LINE_val_rec.relationship_type
3881: );
3882:
3883: IF l_PRICE_LIST_LINE_rec.relationship_type_id = FND_API.G_MISS_NUM THEN
3884: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3885: END IF;
3886:
3887: END IF;
3888:
3887: END IF;
3888:
3889: END IF;
3890:
3891: IF p_PRICE_LIST_LINE_val_rec.reprice <> FND_API.G_MISS_CHAR
3892: THEN
3893:
3894: IF p_PRICE_LIST_LINE_rec.reprice_flag <> FND_API.G_MISS_CHAR THEN
3895:
3890:
3891: IF p_PRICE_LIST_LINE_val_rec.reprice <> FND_API.G_MISS_CHAR
3892: THEN
3893:
3894: IF p_PRICE_LIST_LINE_rec.reprice_flag <> FND_API.G_MISS_CHAR THEN
3895:
3896: l_PRICE_LIST_LINE_rec.reprice_flag := p_PRICE_LIST_LINE_rec.reprice_flag;
3897:
3898: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3909: l_PRICE_LIST_LINE_rec.reprice_flag := QP_Value_To_Id.reprice
3910: ( p_reprice => p_PRICE_LIST_LINE_val_rec.reprice
3911: );
3912:
3913: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
3914: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3915: END IF;
3916:
3917: END IF;
3910: ( p_reprice => p_PRICE_LIST_LINE_val_rec.reprice
3911: );
3912:
3913: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
3914: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3915: END IF;
3916:
3917: END IF;
3918:
3917: END IF;
3918:
3919: END IF;
3920:
3921: IF p_PRICE_LIST_LINE_val_rec.revision_reason <> FND_API.G_MISS_CHAR
3922: THEN
3923:
3924: IF p_PRICE_LIST_LINE_rec.revision_reason_code <> FND_API.G_MISS_CHAR THEN
3925:
3920:
3921: IF p_PRICE_LIST_LINE_val_rec.revision_reason <> FND_API.G_MISS_CHAR
3922: THEN
3923:
3924: IF p_PRICE_LIST_LINE_rec.revision_reason_code <> FND_API.G_MISS_CHAR THEN
3925:
3926: l_PRICE_LIST_LINE_rec.revision_reason_code := p_PRICE_LIST_LINE_rec.revision_reason_code;
3927:
3928: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3939: l_PRICE_LIST_LINE_rec.revision_reason_code := QP_Value_To_Id.revision_reason
3940: ( p_revision_reason => p_PRICE_LIST_LINE_val_rec.revision_reason
3941: );
3942:
3943: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
3944: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3945: END IF;
3946:
3947: END IF;
3940: ( p_revision_reason => p_PRICE_LIST_LINE_val_rec.revision_reason
3941: );
3942:
3943: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
3944: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
3945: END IF;
3946:
3947: END IF;
3948: