[Home] [Help]
PACKAGE BODY: APPS.OE_VALIDATE_LINE_PATTR
Source
1 PACKAGE BODY OE_Validate_Line_PAttr AS
2 /* $Header: OEXLLPAB.pls 120.1 2005/12/29 04:31:06 ppnair noship $ */
3
4 -- Global constant holding the package name
5
6 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Validate_Line_Price_PAttr';
7
8 -- Procedure Entity
9
10 PROCEDURE Entity
11 ( x_return_status OUT NOCOPY VARCHAR2
12
13 , p_Line_Price_Attr_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type
14 , p_old_Line_Price_Attr_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type := OE_Order_PUB.G_MISS_LINE_PRICE_ATT_REC
15 )
16 IS
17 l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18 --
19 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
20 --
21 BEGIN
22
23 -- Check required attributes.
24
25 IF p_Line_Price_Attr_rec.order_price_attrib_id IS NULL
26 THEN
27
28 l_return_status := FND_API.G_RET_STS_ERROR;
29
30 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
31 THEN
32
33 FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
34 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','attribute1');
35 FND_MSG_PUB.Add;
36
37 END IF;
38
39 END IF;
40
41 --
42 -- Check rest of required attributes here.
43 --
44
45
46 -- Return Error if a required attribute is missing.
47
48 IF l_return_status = FND_API.G_RET_STS_ERROR THEN
49
50 RAISE FND_API.G_EXC_ERROR;
51
52 END IF;
53
54 --
55 -- Check conditionally required attributes here.
56 --
57
58
59 --
60 -- Validate attribute dependencies here.
61 --
62
63
64 -- Done validating entity
65
66 x_return_status := l_return_status;
67
68 EXCEPTION
69
70 WHEN FND_API.G_EXC_ERROR THEN
71
72 x_return_status := FND_API.G_RET_STS_ERROR;
73
74 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
75
76 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77
78 WHEN OTHERS THEN
79
80 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
81
82 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
83 THEN
84 FND_MSG_PUB.Add_Exc_Msg
85 ( G_PKG_NAME
86 , 'Entity'
87 );
88 END IF;
89
90 END Entity;
91
92 -- Procedure Attributes
93
94 PROCEDURE Attributes
95 ( x_return_status OUT NOCOPY VARCHAR2
96
97 , p_Line_Price_Attr_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type
98 , p_old_Line_Price_Attr_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type := OE_Order_PUB.G_MISS_LINE_PRICE_ATT_REC
99 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
100 )
101 IS
102 l_column_prefix varchar2(20);
103 l_column_value varchar2(240); --Bug#2708343
104 --
105 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
106 --
107 BEGIN
108
109 x_return_status := FND_API.G_RET_STS_SUCCESS;
110
111 -- Validate Line_Pricing_PAttr attributes
112
113
114
115 IF p_Line_Price_Attr_rec.override_flag IS NOT NULL AND
116 ( p_Line_Price_Attr_rec.override_flag <>
117 p_old_Line_Price_Attr_rec.override_flag OR
118 p_old_Line_Price_Attr_rec.override_flag IS NULL )
119 THEN
120 IF NOT OE_Validate_adj.Override_Flag(p_Line_Price_Attr_rec.override_flag) THEN
121 x_return_status := FND_API.G_RET_STS_ERROR;
122 END IF;
123 END IF;
124
125
126
127
128 IF p_Line_Price_Attr_rec.created_by IS NOT NULL AND
129 ( p_Line_Price_Attr_rec.created_by <>
130 p_old_Line_Price_Attr_rec.created_by OR
131 p_old_Line_Price_Attr_rec.created_by IS NULL )
132 THEN
133 IF NOT OE_Validate_adj.Created_By(p_Line_Price_Attr_rec.created_by) THEN
134 x_return_status := FND_API.G_RET_STS_ERROR;
135 END IF;
136 END IF;
137
138 IF p_Line_Price_Attr_rec.creation_date IS NOT NULL AND
139 ( p_Line_Price_Attr_rec.creation_date <>
140 p_old_Line_Price_Attr_rec.creation_date OR
141 p_old_Line_Price_Attr_rec.creation_date IS NULL )
142 THEN
143 IF NOT OE_Validate_adj.Creation_Date(p_Line_Price_Attr_rec.creation_date) THEN
144 x_return_status := FND_API.G_RET_STS_ERROR;
145 END IF;
146 END IF;
147
148 IF p_Line_Price_Attr_rec.flex_title IS NOT NULL AND
149 ( p_Line_Price_Attr_rec.flex_title <>
150 p_old_Line_Price_Attr_rec.flex_title OR
151 p_old_Line_Price_Attr_rec.flex_title IS NULL )
152 THEN
153 IF NOT OE_Validate_adj.Flex_Title(p_Line_Price_Attr_rec.flex_title) THEN
154 x_return_status := FND_API.G_RET_STS_ERROR;
155 END IF;
156 END IF;
157
158 IF p_Line_Price_Attr_rec.header_id IS NOT NULL AND
159 ( p_Line_Price_Attr_rec.header_id <>
160 p_old_Line_Price_Attr_rec.header_id OR
161 p_old_Line_Price_Attr_rec.header_id IS NULL )
162 THEN
163 IF NOT OE_Validate_adj.Header(p_Line_Price_Attr_rec.header_id) THEN
164 x_return_status := FND_API.G_RET_STS_ERROR;
165 END IF;
166 END IF;
167
168 IF p_Line_Price_Attr_rec.last_updated_by IS NOT NULL AND
169 ( p_Line_Price_Attr_rec.last_updated_by <>
170 p_old_Line_Price_Attr_rec.last_updated_by OR
171 p_old_Line_Price_Attr_rec.last_updated_by IS NULL )
172 THEN
173 IF NOT OE_Validate_adj.Last_Updated_By(p_Line_Price_Attr_rec.last_updated_by) THEN
174 x_return_status := FND_API.G_RET_STS_ERROR;
175 END IF;
176 END IF;
177
178 IF p_Line_Price_Attr_rec.last_update_date IS NOT NULL AND
179 ( p_Line_Price_Attr_rec.last_update_date <>
180 p_old_Line_Price_Attr_rec.last_update_date OR
181 p_old_Line_Price_Attr_rec.last_update_date IS NULL )
182 THEN
183 IF NOT OE_Validate_adj.Last_Update_Date(p_Line_Price_Attr_rec.last_update_date) THEN
184 x_return_status := FND_API.G_RET_STS_ERROR;
185 END IF;
186 END IF;
187
188 IF p_Line_Price_Attr_rec.last_update_login IS NOT NULL AND
189 ( p_Line_Price_Attr_rec.last_update_login <>
190 p_old_Line_Price_Attr_rec.last_update_login OR
191 p_old_Line_Price_Attr_rec.last_update_login IS NULL )
192 THEN
193 IF NOT OE_Validate_adj.Last_Update_Login(p_Line_Price_Attr_rec.last_update_login) THEN
194 x_return_status := FND_API.G_RET_STS_ERROR;
195 END IF;
196 END IF;
197
198 IF p_Line_Price_Attr_rec.line_id IS NOT NULL AND
199 ( p_Line_Price_Attr_rec.line_id <>
200 p_old_Line_Price_Attr_rec.line_id OR
201 p_old_Line_Price_Attr_rec.line_id IS NULL )
202 THEN
203 IF NOT OE_Validate_adj.Line(p_Line_Price_Attr_rec.line_id) THEN
204 x_return_status := FND_API.G_RET_STS_ERROR;
205 END IF;
206 END IF;
207
208 IF p_Line_Price_Attr_rec.order_price_attrib_id IS NOT NULL AND
209 ( p_Line_Price_Attr_rec.order_price_attrib_id <>
210 p_old_Line_Price_Attr_rec.order_price_attrib_id OR
211 p_old_Line_Price_Attr_rec.order_price_attrib_id IS NULL )
212 THEN
213 IF NOT OE_Validate_adj.Order_Price_Attrib(p_Line_Price_Attr_rec.order_price_attrib_id) THEN
214 x_return_status := FND_API.G_RET_STS_ERROR;
215 END IF;
216 END IF;
217
218 IF p_Line_Price_Attr_rec.program_application_id IS NOT NULL AND
219 ( p_Line_Price_Attr_rec.program_application_id <>
220 p_old_Line_Price_Attr_rec.program_application_id OR
221 p_old_Line_Price_Attr_rec.program_application_id IS NULL )
222 THEN
223 IF NOT OE_Validate_adj.Program_Application(p_Line_Price_Attr_rec.program_application_id) THEN
224 x_return_status := FND_API.G_RET_STS_ERROR;
225 END IF;
226 END IF;
227
228 IF p_Line_Price_Attr_rec.program_id IS NOT NULL AND
229 ( p_Line_Price_Attr_rec.program_id <>
230 p_old_Line_Price_Attr_rec.program_id OR
231 p_old_Line_Price_Attr_rec.program_id IS NULL )
232 THEN
233 IF NOT OE_Validate_adj.Program(p_Line_Price_Attr_rec.program_id) THEN
234 x_return_status := FND_API.G_RET_STS_ERROR;
235 END IF;
236 END IF;
237
238 IF p_Line_Price_Attr_rec.program_update_date IS NOT NULL AND
239 ( p_Line_Price_Attr_rec.program_update_date <>
240 p_old_Line_Price_Attr_rec.program_update_date OR
241 p_old_Line_Price_Attr_rec.program_update_date IS NULL )
242 THEN
243 IF NOT OE_Validate_adj.Program_Update_Date(p_Line_Price_Attr_rec.program_update_date) THEN
244 x_return_status := FND_API.G_RET_STS_ERROR;
245 END IF;
246 END IF;
247
248 IF p_Line_Price_Attr_rec.request_id IS NOT NULL AND
249 ( p_Line_Price_Attr_rec.request_id <>
250 p_old_Line_Price_Attr_rec.request_id OR
251 p_old_Line_Price_Attr_rec.request_id IS NULL )
252 THEN
253 IF NOT OE_Validate_adj.Request(p_Line_Price_Attr_rec.request_id) THEN
254 x_return_status := FND_API.G_RET_STS_ERROR;
255 END IF;
256 END IF;
257 if OE_GLOBALS.g_validate_desc_flex ='Y' then --bug 4343612
258 oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Line_PAttr .attributes ',1);
259 IF (p_Line_Price_Attr_rec.attribute1 IS NOT NULL AND
260 ( p_Line_Price_Attr_rec.attribute1 <>
261 p_old_Line_Price_Attr_rec.attribute1 OR
262 p_old_Line_Price_Attr_rec.attribute1 IS NULL ))
263 OR (p_Line_Price_Attr_rec.attribute10 IS NOT NULL AND
264 ( p_Line_Price_Attr_rec.attribute10 <>
265 p_old_Line_Price_Attr_rec.attribute10 OR
266 p_old_Line_Price_Attr_rec.attribute10 IS NULL ))
267 OR (p_Line_Price_Attr_rec.attribute11 IS NOT NULL AND
268 ( p_Line_Price_Attr_rec.attribute11 <>
269 p_old_Line_Price_Attr_rec.attribute11 OR
270 p_old_Line_Price_Attr_rec.attribute11 IS NULL ))
271 OR (p_Line_Price_Attr_rec.attribute12 IS NOT NULL AND
272 ( p_Line_Price_Attr_rec.attribute12 <>
273 p_old_Line_Price_Attr_rec.attribute12 OR
274 p_old_Line_Price_Attr_rec.attribute12 IS NULL ))
275 OR (p_Line_Price_Attr_rec.attribute13 IS NOT NULL AND
276 ( p_Line_Price_Attr_rec.attribute13 <>
277 p_old_Line_Price_Attr_rec.attribute13 OR
278 p_old_Line_Price_Attr_rec.attribute13 IS NULL ))
279 OR (p_Line_Price_Attr_rec.attribute14 IS NOT NULL AND
280 ( p_Line_Price_Attr_rec.attribute14 <>
281 p_old_Line_Price_Attr_rec.attribute14 OR
282 p_old_Line_Price_Attr_rec.attribute14 IS NULL ))
283 OR (p_Line_Price_Attr_rec.attribute15 IS NOT NULL AND
284 ( p_Line_Price_Attr_rec.attribute15 <>
285 p_old_Line_Price_Attr_rec.attribute15 OR
286 p_old_Line_Price_Attr_rec.attribute15 IS NULL ))
287 OR (p_Line_Price_Attr_rec.attribute2 IS NOT NULL AND
288 ( p_Line_Price_Attr_rec.attribute2 <>
289 p_old_Line_Price_Attr_rec.attribute2 OR
290 p_old_Line_Price_Attr_rec.attribute2 IS NULL ))
291 OR (p_Line_Price_Attr_rec.attribute3 IS NOT NULL AND
292 ( p_Line_Price_Attr_rec.attribute3 <>
293 p_old_Line_Price_Attr_rec.attribute3 OR
294 p_old_Line_Price_Attr_rec.attribute3 IS NULL ))
295 OR (p_Line_Price_Attr_rec.attribute4 IS NOT NULL AND
296 ( p_Line_Price_Attr_rec.attribute4 <>
297 p_old_Line_Price_Attr_rec.attribute4 OR
298 p_old_Line_Price_Attr_rec.attribute4 IS NULL ))
299 OR (p_Line_Price_Attr_rec.attribute5 IS NOT NULL AND
300 ( p_Line_Price_Attr_rec.attribute5 <>
301 p_old_Line_Price_Attr_rec.attribute5 OR
302 p_old_Line_Price_Attr_rec.attribute5 IS NULL ))
303 OR (p_Line_Price_Attr_rec.attribute6 IS NOT NULL AND
304 ( p_Line_Price_Attr_rec.attribute6 <>
305 p_old_Line_Price_Attr_rec.attribute6 OR
306 p_old_Line_Price_Attr_rec.attribute6 IS NULL ))
307 OR (p_Line_Price_Attr_rec.attribute7 IS NOT NULL AND
308 ( p_Line_Price_Attr_rec.attribute7 <>
309 p_old_Line_Price_Attr_rec.attribute7 OR
310 p_old_Line_Price_Attr_rec.attribute7 IS NULL ))
311 OR (p_Line_Price_Attr_rec.attribute8 IS NOT NULL AND
312 ( p_Line_Price_Attr_rec.attribute8 <>
313 p_old_Line_Price_Attr_rec.attribute8 OR
314 p_old_Line_Price_Attr_rec.attribute8 IS NULL ))
315 OR (p_Line_Price_Attr_rec.attribute9 IS NOT NULL AND
316 ( p_Line_Price_Attr_rec.attribute9 <>
317 p_old_Line_Price_Attr_rec.attribute9 OR
318 p_old_Line_Price_Attr_rec.attribute9 IS NULL ))
319 OR (p_Line_Price_Attr_rec.context IS NOT NULL AND
320 ( p_Line_Price_Attr_rec.context <>
321 p_old_Line_Price_Attr_rec.context OR
322 p_old_Line_Price_Attr_rec.context IS NULL ))
323 THEN
324
325
326 FND_FLEX_DESCVAL.Set_Column_Value
327 ( column_name => 'ATTRIBUTE1'
328 , column_value => p_Line_Price_Attr_rec.attribute1
329 );
330 FND_FLEX_DESCVAL.Set_Column_Value
331 ( column_name => 'ATTRIBUTE10'
332 , column_value => p_Line_Price_Attr_rec.attribute10
333 );
334 FND_FLEX_DESCVAL.Set_Column_Value
335 ( column_name => 'ATTRIBUTE11'
336 , column_value => p_Line_Price_Attr_rec.attribute11
337 );
338 FND_FLEX_DESCVAL.Set_Column_Value
339 ( column_name => 'ATTRIBUTE12'
340 , column_value => p_Line_Price_Attr_rec.attribute12
341 );
342 FND_FLEX_DESCVAL.Set_Column_Value
343 ( column_name => 'ATTRIBUTE13'
344 , column_value => p_Line_Price_Attr_rec.attribute13
345 );
346 FND_FLEX_DESCVAL.Set_Column_Value
347 ( column_name => 'ATTRIBUTE14'
348 , column_value => p_Line_Price_Attr_rec.attribute14
349 );
350 FND_FLEX_DESCVAL.Set_Column_Value
351 ( column_name => 'ATTRIBUTE15'
352 , column_value => p_Line_Price_Attr_rec.attribute15
353 );
354 FND_FLEX_DESCVAL.Set_Column_Value
355 ( column_name => 'ATTRIBUTE2'
356 , column_value => p_Line_Price_Attr_rec.attribute2
357 );
358 FND_FLEX_DESCVAL.Set_Column_Value
359 ( column_name => 'ATTRIBUTE3'
360 , column_value => p_Line_Price_Attr_rec.attribute3
361 );
362 FND_FLEX_DESCVAL.Set_Column_Value
363 ( column_name => 'ATTRIBUTE4'
364 , column_value => p_Line_Price_Attr_rec.attribute4
365 );
366 FND_FLEX_DESCVAL.Set_Column_Value
367 ( column_name => 'ATTRIBUTE5'
368 , column_value => p_Line_Price_Attr_rec.attribute5
369 );
370 FND_FLEX_DESCVAL.Set_Column_Value
371 ( column_name => 'ATTRIBUTE6'
372 , column_value => p_Line_Price_Attr_rec.attribute6
373 );
374 FND_FLEX_DESCVAL.Set_Column_Value
375 ( column_name => 'ATTRIBUTE7'
376 , column_value => p_Line_Price_Attr_rec.attribute7
377 );
378 FND_FLEX_DESCVAL.Set_Column_Value
379 ( column_name => 'ATTRIBUTE8'
380 , column_value => p_Line_Price_Attr_rec.attribute8
381 );
382 FND_FLEX_DESCVAL.Set_Column_Value
383 ( column_name => 'ATTRIBUTE9'
384 , column_value => p_Line_Price_Attr_rec.attribute9
385 );
386
387 FND_FLEX_DESCVAL.Set_Column_Value
388 ( column_name => 'CONTEXT'
389 , column_value => p_Line_Price_Attr_rec.context
390 );
391
392 -- Validate descriptive flexfield.
393
394 /*IF NOT OE_Validate_adj.Desc_Flex('ONT', 'OE_ORDER_PRICE_ATTRIBS' ) THEN
395 IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
396 p_line_price_attr_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
397
398 null;
399 ELSE
400 x_return_status := FND_API.G_RET_STS_ERROR;
401 END IF;
402 END IF;*/
403
404 END IF;
405
406 IF (p_Line_Price_Attr_rec.pricing_attribute1 IS NOT NULL AND
407 ( p_Line_Price_Attr_rec.pricing_attribute1 <>
408 p_old_Line_Price_Attr_rec.pricing_attribute1 OR
409 p_old_Line_Price_Attr_rec.pricing_attribute1 IS NULL ))
410 OR (p_Line_Price_Attr_rec.pricing_attribute2 IS NOT NULL AND
411 ( p_Line_Price_Attr_rec.pricing_attribute2 <>
412 p_old_Line_Price_Attr_rec.pricing_attribute2 OR
413 p_old_Line_Price_Attr_rec.pricing_attribute2 IS NULL ))
414 OR (p_Line_Price_Attr_rec.pricing_attribute3 IS NOT NULL AND
415 ( p_Line_Price_Attr_rec.pricing_attribute3 <>
416 p_old_Line_Price_Attr_rec.pricing_attribute3 OR
417 p_old_Line_Price_Attr_rec.pricing_attribute3 IS NULL ))
418 OR (p_Line_Price_Attr_rec.pricing_attribute4 IS NOT NULL AND
419 ( p_Line_Price_Attr_rec.pricing_attribute4 <>
420 p_old_Line_Price_Attr_rec.pricing_attribute4 OR
421 p_old_Line_Price_Attr_rec.pricing_attribute4 IS NULL ))
422 OR (p_Line_Price_Attr_rec.pricing_attribute5 IS NOT NULL AND
423 ( p_Line_Price_Attr_rec.pricing_attribute5 <>
424 p_old_Line_Price_Attr_rec.pricing_attribute5 OR
425 p_old_Line_Price_Attr_rec.pricing_attribute5 IS NULL ))
426 OR (p_Line_Price_Attr_rec.pricing_attribute6 IS NOT NULL AND
427 ( p_Line_Price_Attr_rec.pricing_attribute6 <>
428 p_old_Line_Price_Attr_rec.pricing_attribute6 OR
429 p_old_Line_Price_Attr_rec.pricing_attribute6 IS NULL ))
430 OR (p_Line_Price_Attr_rec.pricing_attribute7 IS NOT NULL AND
431 ( p_Line_Price_Attr_rec.pricing_attribute7 <>
432 p_old_Line_Price_Attr_rec.pricing_attribute7 OR
433 p_old_Line_Price_Attr_rec.pricing_attribute7 IS NULL ))
434 OR (p_Line_Price_Attr_rec.pricing_attribute8 IS NOT NULL AND
435 ( p_Line_Price_Attr_rec.pricing_attribute8 <>
436 p_old_Line_Price_Attr_rec.pricing_attribute8 OR
437 p_old_Line_Price_Attr_rec.pricing_attribute8 IS NULL ))
438 OR (p_Line_Price_Attr_rec.pricing_attribute9 IS NOT NULL AND
439 ( p_Line_Price_Attr_rec.pricing_attribute9 <>
440 p_old_Line_Price_Attr_rec.pricing_attribute9 OR
441 p_old_Line_Price_Attr_rec.pricing_attribute9 IS NULL ))
442 OR (p_Line_Price_Attr_rec.pricing_context IS NOT NULL AND
443 ( p_Line_Price_Attr_rec.pricing_context <>
444 p_old_Line_Price_Attr_rec.pricing_context OR
445 p_old_Line_Price_Attr_rec.pricing_context IS NULL ))
446 OR (p_Line_Price_Attr_rec.pricing_attribute10 IS NOT NULL AND
447 ( p_Line_Price_Attr_rec.pricing_attribute10 <>
448 p_old_Line_Price_Attr_rec.pricing_attribute10 OR
449 p_old_Line_Price_Attr_rec.pricing_attribute10 IS NULL ))
450 OR (p_Line_Price_Attr_rec.pricing_attribute11 IS NOT NULL AND
451 ( p_Line_Price_Attr_rec.pricing_attribute11 <>
452 p_old_Line_Price_Attr_rec.pricing_attribute11 OR
453 p_old_Line_Price_Attr_rec.pricing_attribute11 IS NULL ))
454 OR (p_Line_Price_Attr_rec.pricing_attribute12 IS NOT NULL AND
455 ( p_Line_Price_Attr_rec.pricing_attribute12 <>
456 p_old_Line_Price_Attr_rec.pricing_attribute12 OR
457 p_old_Line_Price_Attr_rec.pricing_attribute12 IS NULL ))
458 OR (p_Line_Price_Attr_rec.pricing_attribute13 IS NOT NULL AND
459 ( p_Line_Price_Attr_rec.pricing_attribute13 <>
460 p_old_Line_Price_Attr_rec.pricing_attribute13 OR
461 p_old_Line_Price_Attr_rec.pricing_attribute13 IS NULL ))
462 OR (p_Line_Price_Attr_rec.pricing_attribute14 IS NOT NULL AND
463 ( p_Line_Price_Attr_rec.pricing_attribute14 <>
464 p_old_Line_Price_Attr_rec.pricing_attribute14 OR
465 p_old_Line_Price_Attr_rec.pricing_attribute14 IS NULL ))
466 OR (p_Line_Price_Attr_rec.pricing_attribute15 IS NOT NULL AND
467 ( p_Line_Price_Attr_rec.pricing_attribute15 <>
468 p_old_Line_Price_Attr_rec.pricing_attribute15 OR
469 p_old_Line_Price_Attr_rec.pricing_attribute15 IS NULL ))
470 OR (p_Line_Price_Attr_rec.pricing_attribute16 IS NOT NULL AND
471 ( p_Line_Price_Attr_rec.pricing_attribute16 <>
472 p_old_Line_Price_Attr_rec.pricing_attribute16 OR
473 p_old_Line_Price_Attr_rec.pricing_attribute16 IS NULL ))
474 OR (p_Line_Price_Attr_rec.pricing_attribute17 IS NOT NULL AND
475 ( p_Line_Price_Attr_rec.pricing_attribute17 <>
476 p_old_Line_Price_Attr_rec.pricing_attribute17 OR
477 p_old_Line_Price_Attr_rec.pricing_attribute17 IS NULL ))
478 OR (p_Line_Price_Attr_rec.pricing_attribute18 IS NOT NULL AND
479 ( p_Line_Price_Attr_rec.pricing_attribute18 <>
480 p_old_Line_Price_Attr_rec.pricing_attribute18 OR
481 p_old_Line_Price_Attr_rec.pricing_attribute18 IS NULL ))
482 OR (p_Line_Price_Attr_rec.pricing_attribute19 IS NOT NULL AND
483 ( p_Line_Price_Attr_rec.pricing_attribute19 <>
484 p_old_Line_Price_Attr_rec.pricing_attribute19 OR
485 p_old_Line_Price_Attr_rec.pricing_attribute19 IS NULL ))
486 OR (p_Line_Price_Attr_rec.pricing_attribute20 IS NOT NULL AND
487 ( p_Line_Price_Attr_rec.pricing_attribute20 <>
488 p_old_Line_Price_Attr_rec.pricing_attribute20 OR
489 p_old_Line_Price_Attr_rec.pricing_attribute20 IS NULL ))
490 OR (p_Line_Price_Attr_rec.pricing_attribute21 IS NOT NULL AND
491 ( p_Line_Price_Attr_rec.pricing_attribute21 <>
492 p_old_Line_Price_Attr_rec.pricing_attribute21 OR
493 p_old_Line_Price_Attr_rec.pricing_attribute21 IS NULL ))
494 OR (p_Line_Price_Attr_rec.pricing_attribute22 IS NOT NULL AND
495 ( p_Line_Price_Attr_rec.pricing_attribute22 <>
496 p_old_Line_Price_Attr_rec.pricing_attribute22 OR
497 p_old_Line_Price_Attr_rec.pricing_attribute22 IS NULL ))
498 OR (p_Line_Price_Attr_rec.pricing_attribute23 IS NOT NULL AND
499 ( p_Line_Price_Attr_rec.pricing_attribute23 <>
500 p_old_Line_Price_Attr_rec.pricing_attribute23 OR
501 p_old_Line_Price_Attr_rec.pricing_attribute23 IS NULL ))
502 OR (p_Line_Price_Attr_rec.pricing_attribute24 IS NOT NULL AND
503 ( p_Line_Price_Attr_rec.pricing_attribute24 <>
504 p_old_Line_Price_Attr_rec.pricing_attribute24 OR
505 p_old_Line_Price_Attr_rec.pricing_attribute24 IS NULL ))
506 OR (p_Line_Price_Attr_rec.pricing_attribute25 IS NOT NULL AND
507 ( p_Line_Price_Attr_rec.pricing_attribute25 <>
508 p_old_Line_Price_Attr_rec.pricing_attribute25 OR
509 p_old_Line_Price_Attr_rec.pricing_attribute25 IS NULL ))
510 OR (p_Line_Price_Attr_rec.pricing_attribute26 IS NOT NULL AND
511 ( p_Line_Price_Attr_rec.pricing_attribute26 <>
512 p_old_Line_Price_Attr_rec.pricing_attribute26 OR
513 p_old_Line_Price_Attr_rec.pricing_attribute26 IS NULL ))
514 OR (p_Line_Price_Attr_rec.pricing_attribute27 IS NOT NULL AND
515 ( p_Line_Price_Attr_rec.pricing_attribute27 <>
516 p_old_Line_Price_Attr_rec.pricing_attribute27 OR
517 p_old_Line_Price_Attr_rec.pricing_attribute27 IS NULL ))
518 OR (p_Line_Price_Attr_rec.pricing_attribute28 IS NOT NULL AND
519 ( p_Line_Price_Attr_rec.pricing_attribute28 <>
520 p_old_Line_Price_Attr_rec.pricing_attribute28 OR
521 p_old_Line_Price_Attr_rec.pricing_attribute28 IS NULL ))
522 OR (p_Line_Price_Attr_rec.pricing_attribute29 IS NOT NULL AND
523 ( p_Line_Price_Attr_rec.pricing_attribute29 <>
524 p_old_Line_Price_Attr_rec.pricing_attribute29 OR
525 p_old_Line_Price_Attr_rec.pricing_attribute29 IS NULL ))
526 OR (p_Line_Price_Attr_rec.pricing_attribute30 IS NOT NULL AND
527 ( p_Line_Price_Attr_rec.pricing_attribute30 <>
528 p_old_Line_Price_Attr_rec.pricing_attribute30 OR
529 p_old_Line_Price_Attr_rec.pricing_attribute30 IS NULL ))
530 OR (p_Line_Price_Attr_rec.pricing_attribute31 IS NOT NULL AND
531 ( p_Line_Price_Attr_rec.pricing_attribute31 <>
532 p_old_Line_Price_Attr_rec.pricing_attribute31 OR
533 p_old_Line_Price_Attr_rec.pricing_attribute31 IS NULL ))
534 OR (p_Line_Price_Attr_rec.pricing_attribute32 IS NOT NULL AND
535 ( p_Line_Price_Attr_rec.pricing_attribute32 <>
536 p_old_Line_Price_Attr_rec.pricing_attribute32 OR
537 p_old_Line_Price_Attr_rec.pricing_attribute32 IS NULL ))
538 OR (p_Line_Price_Attr_rec.pricing_attribute33 IS NOT NULL AND
539 ( p_Line_Price_Attr_rec.pricing_attribute33 <>
540 p_old_Line_Price_Attr_rec.pricing_attribute33 OR
541 p_old_Line_Price_Attr_rec.pricing_attribute33 IS NULL ))
542 OR (p_Line_Price_Attr_rec.pricing_attribute34 IS NOT NULL AND
543 ( p_Line_Price_Attr_rec.pricing_attribute34 <>
544 p_old_Line_Price_Attr_rec.pricing_attribute34 OR
545 p_old_Line_Price_Attr_rec.pricing_attribute34 IS NULL ))
546 OR (p_Line_Price_Attr_rec.pricing_attribute35 IS NOT NULL AND
547 ( p_Line_Price_Attr_rec.pricing_attribute35 <>
548 p_old_Line_Price_Attr_rec.pricing_attribute35 OR
549 p_old_Line_Price_Attr_rec.pricing_attribute35 IS NULL ))
550 OR (p_Line_Price_Attr_rec.pricing_attribute36 IS NOT NULL AND
551 ( p_Line_Price_Attr_rec.pricing_attribute36 <>
552 p_old_Line_Price_Attr_rec.pricing_attribute36 OR
553 p_old_Line_Price_Attr_rec.pricing_attribute36 IS NULL ))
554 OR (p_Line_Price_Attr_rec.pricing_attribute37 IS NOT NULL AND
555 ( p_Line_Price_Attr_rec.pricing_attribute37 <>
556 p_old_Line_Price_Attr_rec.pricing_attribute37 OR
557 p_old_Line_Price_Attr_rec.pricing_attribute37 IS NULL ))
558 OR (p_Line_Price_Attr_rec.pricing_attribute38 IS NOT NULL AND
559 ( p_Line_Price_Attr_rec.pricing_attribute38 <>
560 p_old_Line_Price_Attr_rec.pricing_attribute38 OR
561 p_old_Line_Price_Attr_rec.pricing_attribute38 IS NULL ))
562 OR (p_Line_Price_Attr_rec.pricing_attribute39 IS NOT NULL AND
563 ( p_Line_Price_Attr_rec.pricing_attribute39 <>
564 p_old_Line_Price_Attr_rec.pricing_attribute39 OR
565 p_old_Line_Price_Attr_rec.pricing_attribute39 IS NULL ))
566 OR (p_Line_Price_Attr_rec.pricing_attribute40 IS NOT NULL AND
567 ( p_Line_Price_Attr_rec.pricing_attribute40 <>
568 p_old_Line_Price_Attr_rec.pricing_attribute40 OR
569 p_old_Line_Price_Attr_rec.pricing_attribute40 IS NULL ))
570 OR (p_Line_Price_Attr_rec.pricing_attribute41 IS NOT NULL AND
571 ( p_Line_Price_Attr_rec.pricing_attribute41 <>
572 p_old_Line_Price_Attr_rec.pricing_attribute41 OR
573 p_old_Line_Price_Attr_rec.pricing_attribute41 IS NULL ))
574 OR (p_Line_Price_Attr_rec.pricing_attribute42 IS NOT NULL AND
575 ( p_Line_Price_Attr_rec.pricing_attribute42 <>
576 p_old_Line_Price_Attr_rec.pricing_attribute42 OR
577 p_old_Line_Price_Attr_rec.pricing_attribute42 IS NULL ))
578 OR (p_Line_Price_Attr_rec.pricing_attribute43 IS NOT NULL AND
579 ( p_Line_Price_Attr_rec.pricing_attribute43 <>
580 p_old_Line_Price_Attr_rec.pricing_attribute43 OR
581 p_old_Line_Price_Attr_rec.pricing_attribute43 IS NULL ))
582 OR (p_Line_Price_Attr_rec.pricing_attribute44 IS NOT NULL AND
583 ( p_Line_Price_Attr_rec.pricing_attribute44 <>
584 p_old_Line_Price_Attr_rec.pricing_attribute44 OR
585 p_old_Line_Price_Attr_rec.pricing_attribute44 IS NULL ))
586 OR (p_Line_Price_Attr_rec.pricing_attribute45 IS NOT NULL AND
587 ( p_Line_Price_Attr_rec.pricing_attribute45 <>
588 p_old_Line_Price_Attr_rec.pricing_attribute45 OR
589 p_old_Line_Price_Attr_rec.pricing_attribute45 IS NULL ))
590 OR (p_Line_Price_Attr_rec.pricing_attribute46 IS NOT NULL AND
591 ( p_Line_Price_Attr_rec.pricing_attribute46 <>
592 p_old_Line_Price_Attr_rec.pricing_attribute46 OR
593 p_old_Line_Price_Attr_rec.pricing_attribute46 IS NULL ))
594 OR (p_Line_Price_Attr_rec.pricing_attribute47 IS NOT NULL AND
595 ( p_Line_Price_Attr_rec.pricing_attribute47 <>
596 p_old_Line_Price_Attr_rec.pricing_attribute47 OR
597 p_old_Line_Price_Attr_rec.pricing_attribute47 IS NULL ))
598 OR (p_Line_Price_Attr_rec.pricing_attribute48 IS NOT NULL AND
599 ( p_Line_Price_Attr_rec.pricing_attribute48 <>
600 p_old_Line_Price_Attr_rec.pricing_attribute48 OR
601 p_old_Line_Price_Attr_rec.pricing_attribute48 IS NULL ))
602 OR (p_Line_Price_Attr_rec.pricing_attribute49 IS NOT NULL AND
603 ( p_Line_Price_Attr_rec.pricing_attribute49 <>
604 p_old_Line_Price_Attr_rec.pricing_attribute49 OR
605 p_old_Line_Price_Attr_rec.pricing_attribute49 IS NULL ))
606 OR (p_Line_Price_Attr_rec.pricing_attribute50 IS NOT NULL AND
607 ( p_Line_Price_Attr_rec.pricing_attribute50 <>
608 p_old_Line_Price_Attr_rec.pricing_attribute50 OR
609 p_old_Line_Price_Attr_rec.pricing_attribute50 IS NULL ))
610 OR (p_Line_Price_Attr_rec.pricing_attribute51 IS NOT NULL AND
611 ( p_Line_Price_Attr_rec.pricing_attribute51 <>
612 p_old_Line_Price_Attr_rec.pricing_attribute51 OR
613 p_old_Line_Price_Attr_rec.pricing_attribute51 IS NULL ))
614 OR (p_Line_Price_Attr_rec.pricing_attribute52 IS NOT NULL AND
615 ( p_Line_Price_Attr_rec.pricing_attribute52 <>
616 p_old_Line_Price_Attr_rec.pricing_attribute52 OR
617 p_old_Line_Price_Attr_rec.pricing_attribute52 IS NULL ))
618 OR (p_Line_Price_Attr_rec.pricing_attribute53 IS NOT NULL AND
619 ( p_Line_Price_Attr_rec.pricing_attribute53 <>
620 p_old_Line_Price_Attr_rec.pricing_attribute53 OR
621 p_old_Line_Price_Attr_rec.pricing_attribute53 IS NULL ))
622 OR (p_Line_Price_Attr_rec.pricing_attribute54 IS NOT NULL AND
623 ( p_Line_Price_Attr_rec.pricing_attribute54 <>
624 p_old_Line_Price_Attr_rec.pricing_attribute54 OR
625 p_old_Line_Price_Attr_rec.pricing_attribute54 IS NULL ))
626 OR (p_Line_Price_Attr_rec.pricing_attribute55 IS NOT NULL AND
627 ( p_Line_Price_Attr_rec.pricing_attribute55 <>
628 p_old_Line_Price_Attr_rec.pricing_attribute55 OR
629 p_old_Line_Price_Attr_rec.pricing_attribute55 IS NULL ))
630 OR (p_Line_Price_Attr_rec.pricing_attribute56 IS NOT NULL AND
631 ( p_Line_Price_Attr_rec.pricing_attribute56 <>
632 p_old_Line_Price_Attr_rec.pricing_attribute56 OR
633 p_old_Line_Price_Attr_rec.pricing_attribute56 IS NULL ))
634 OR (p_Line_Price_Attr_rec.pricing_attribute57 IS NOT NULL AND
635 ( p_Line_Price_Attr_rec.pricing_attribute57 <>
636 p_old_Line_Price_Attr_rec.pricing_attribute57 OR
637 p_old_Line_Price_Attr_rec.pricing_attribute57 IS NULL ))
638 OR (p_Line_Price_Attr_rec.pricing_attribute58 IS NOT NULL AND
639 ( p_Line_Price_Attr_rec.pricing_attribute58 <>
640 p_old_Line_Price_Attr_rec.pricing_attribute58 OR
641 p_old_Line_Price_Attr_rec.pricing_attribute58 IS NULL ))
642 OR (p_Line_Price_Attr_rec.pricing_attribute59 IS NOT NULL AND
643 ( p_Line_Price_Attr_rec.pricing_attribute59 <>
644 p_old_Line_Price_Attr_rec.pricing_attribute59 OR
645 p_old_Line_Price_Attr_rec.pricing_attribute59 IS NULL ))
646 OR (p_Line_Price_Attr_rec.pricing_attribute60 IS NOT NULL AND
647 ( p_Line_Price_Attr_rec.pricing_attribute60 <>
648 p_old_Line_Price_Attr_rec.pricing_attribute60 OR
649 p_old_Line_Price_Attr_rec.pricing_attribute60 IS NULL ))
650 OR (p_Line_Price_Attr_rec.pricing_attribute61 IS NOT NULL AND
651 ( p_Line_Price_Attr_rec.pricing_attribute61 <>
652 p_old_Line_Price_Attr_rec.pricing_attribute61 OR
653 p_old_Line_Price_Attr_rec.pricing_attribute61 IS NULL ))
654 OR (p_Line_Price_Attr_rec.pricing_attribute62 IS NOT NULL AND
655 ( p_Line_Price_Attr_rec.pricing_attribute62 <>
656 p_old_Line_Price_Attr_rec.pricing_attribute62 OR
657 p_old_Line_Price_Attr_rec.pricing_attribute62 IS NULL ))
658 OR (p_Line_Price_Attr_rec.pricing_attribute63 IS NOT NULL AND
659 ( p_Line_Price_Attr_rec.pricing_attribute63 <>
660 p_old_Line_Price_Attr_rec.pricing_attribute63 OR
661 p_old_Line_Price_Attr_rec.pricing_attribute63 IS NULL ))
662 OR (p_Line_Price_Attr_rec.pricing_attribute64 IS NOT NULL AND
663 ( p_Line_Price_Attr_rec.pricing_attribute64 <>
664 p_old_Line_Price_Attr_rec.pricing_attribute64 OR
665 p_old_Line_Price_Attr_rec.pricing_attribute64 IS NULL ))
666 OR (p_Line_Price_Attr_rec.pricing_attribute65 IS NOT NULL AND
667 ( p_Line_Price_Attr_rec.pricing_attribute65 <>
668 p_old_Line_Price_Attr_rec.pricing_attribute65 OR
669 p_old_Line_Price_Attr_rec.pricing_attribute65 IS NULL ))
670 OR (p_Line_Price_Attr_rec.pricing_attribute66 IS NOT NULL AND
671 ( p_Line_Price_Attr_rec.pricing_attribute66 <>
672 p_old_Line_Price_Attr_rec.pricing_attribute66 OR
673 p_old_Line_Price_Attr_rec.pricing_attribute66 IS NULL ))
674 OR (p_Line_Price_Attr_rec.pricing_attribute67 IS NOT NULL AND
675 ( p_Line_Price_Attr_rec.pricing_attribute67 <>
676 p_old_Line_Price_Attr_rec.pricing_attribute67 OR
677 p_old_Line_Price_Attr_rec.pricing_attribute67 IS NULL ))
678 OR (p_Line_Price_Attr_rec.pricing_attribute68 IS NOT NULL AND
679 ( p_Line_Price_Attr_rec.pricing_attribute68 <>
680 p_old_Line_Price_Attr_rec.pricing_attribute68 OR
681 p_old_Line_Price_Attr_rec.pricing_attribute68 IS NULL ))
682 OR (p_Line_Price_Attr_rec.pricing_attribute69 IS NOT NULL AND
683 ( p_Line_Price_Attr_rec.pricing_attribute69 <>
684 p_old_Line_Price_Attr_rec.pricing_attribute69 OR
685 p_old_Line_Price_Attr_rec.pricing_attribute69 IS NULL ))
686 OR (p_Line_Price_Attr_rec.pricing_attribute70 IS NOT NULL AND
687 ( p_Line_Price_Attr_rec.pricing_attribute70 <>
688 p_old_Line_Price_Attr_rec.pricing_attribute70 OR
689 p_old_Line_Price_Attr_rec.pricing_attribute70 IS NULL ))
690 OR (p_Line_Price_Attr_rec.pricing_attribute71 IS NOT NULL AND
691 ( p_Line_Price_Attr_rec.pricing_attribute71 <>
692 p_old_Line_Price_Attr_rec.pricing_attribute71 OR
693 p_old_Line_Price_Attr_rec.pricing_attribute71 IS NULL ))
694 OR (p_Line_Price_Attr_rec.pricing_attribute72 IS NOT NULL AND
695 ( p_Line_Price_Attr_rec.pricing_attribute72 <>
696 p_old_Line_Price_Attr_rec.pricing_attribute72 OR
697 p_old_Line_Price_Attr_rec.pricing_attribute72 IS NULL ))
698 OR (p_Line_Price_Attr_rec.pricing_attribute73 IS NOT NULL AND
699 ( p_Line_Price_Attr_rec.pricing_attribute73 <>
700 p_old_Line_Price_Attr_rec.pricing_attribute73 OR
701 p_old_Line_Price_Attr_rec.pricing_attribute73 IS NULL ))
702 OR (p_Line_Price_Attr_rec.pricing_attribute74 IS NOT NULL AND
703 ( p_Line_Price_Attr_rec.pricing_attribute74 <>
704 p_old_Line_Price_Attr_rec.pricing_attribute74 OR
705 p_old_Line_Price_Attr_rec.pricing_attribute74 IS NULL ))
706 OR (p_Line_Price_Attr_rec.pricing_attribute75 IS NOT NULL AND
707 ( p_Line_Price_Attr_rec.pricing_attribute75 <>
708 p_old_Line_Price_Attr_rec.pricing_attribute75 OR
709 p_old_Line_Price_Attr_rec.pricing_attribute75 IS NULL ))
710 OR (p_Line_Price_Attr_rec.pricing_attribute76 IS NOT NULL AND
711 ( p_Line_Price_Attr_rec.pricing_attribute76 <>
712 p_old_Line_Price_Attr_rec.pricing_attribute76 OR
713 p_old_Line_Price_Attr_rec.pricing_attribute76 IS NULL ))
714 OR (p_Line_Price_Attr_rec.pricing_attribute77 IS NOT NULL AND
715 ( p_Line_Price_Attr_rec.pricing_attribute77 <>
716 p_old_Line_Price_Attr_rec.pricing_attribute77 OR
717 p_old_Line_Price_Attr_rec.pricing_attribute77 IS NULL ))
718 OR (p_Line_Price_Attr_rec.pricing_attribute78 IS NOT NULL AND
719 ( p_Line_Price_Attr_rec.pricing_attribute78 <>
720 p_old_Line_Price_Attr_rec.pricing_attribute78 OR
721 p_old_Line_Price_Attr_rec.pricing_attribute78 IS NULL ))
722 OR (p_Line_Price_Attr_rec.pricing_attribute79 IS NOT NULL AND
723 ( p_Line_Price_Attr_rec.pricing_attribute79 <>
724 p_old_Line_Price_Attr_rec.pricing_attribute79 OR
725 p_old_Line_Price_Attr_rec.pricing_attribute79 IS NULL ))
726 OR (p_Line_Price_Attr_rec.pricing_attribute80 IS NOT NULL AND
727 ( p_Line_Price_Attr_rec.pricing_attribute80 <>
728 p_old_Line_Price_Attr_rec.pricing_attribute80 OR
729 p_old_Line_Price_Attr_rec.pricing_attribute80 IS NULL ))
730 OR (p_Line_Price_Attr_rec.pricing_attribute81 IS NOT NULL AND
731 ( p_Line_Price_Attr_rec.pricing_attribute81 <>
732 p_old_Line_Price_Attr_rec.pricing_attribute81 OR
733 p_old_Line_Price_Attr_rec.pricing_attribute81 IS NULL ))
734 OR (p_Line_Price_Attr_rec.pricing_attribute82 IS NOT NULL AND
735 ( p_Line_Price_Attr_rec.pricing_attribute82 <>
736 p_old_Line_Price_Attr_rec.pricing_attribute82 OR
737 p_old_Line_Price_Attr_rec.pricing_attribute82 IS NULL ))
738 OR (p_Line_Price_Attr_rec.pricing_attribute83 IS NOT NULL AND
739 ( p_Line_Price_Attr_rec.pricing_attribute83 <>
740 p_old_Line_Price_Attr_rec.pricing_attribute83 OR
741 p_old_Line_Price_Attr_rec.pricing_attribute83 IS NULL ))
742 OR (p_Line_Price_Attr_rec.pricing_attribute84 IS NOT NULL AND
743 ( p_Line_Price_Attr_rec.pricing_attribute84 <>
744 p_old_Line_Price_Attr_rec.pricing_attribute84 OR
745 p_old_Line_Price_Attr_rec.pricing_attribute84 IS NULL ))
746 OR (p_Line_Price_Attr_rec.pricing_attribute85 IS NOT NULL AND
747 ( p_Line_Price_Attr_rec.pricing_attribute85 <>
748 p_old_Line_Price_Attr_rec.pricing_attribute85 OR
749 p_old_Line_Price_Attr_rec.pricing_attribute85 IS NULL ))
750 OR (p_Line_Price_Attr_rec.pricing_attribute86 IS NOT NULL AND
751 ( p_Line_Price_Attr_rec.pricing_attribute86 <>
752 p_old_Line_Price_Attr_rec.pricing_attribute86 OR
753 p_old_Line_Price_Attr_rec.pricing_attribute86 IS NULL ))
754 OR (p_Line_Price_Attr_rec.pricing_attribute87 IS NOT NULL AND
755 ( p_Line_Price_Attr_rec.pricing_attribute87 <>
756 p_old_Line_Price_Attr_rec.pricing_attribute87 OR
757 p_old_Line_Price_Attr_rec.pricing_attribute87 IS NULL ))
758 OR (p_Line_Price_Attr_rec.pricing_attribute88 IS NOT NULL AND
759 ( p_Line_Price_Attr_rec.pricing_attribute88 <>
760 p_old_Line_Price_Attr_rec.pricing_attribute88 OR
761 p_old_Line_Price_Attr_rec.pricing_attribute88 IS NULL ))
762 OR (p_Line_Price_Attr_rec.pricing_attribute89 IS NOT NULL AND
763 ( p_Line_Price_Attr_rec.pricing_attribute89 <>
764 p_old_Line_Price_Attr_rec.pricing_attribute89 OR
765 p_old_Line_Price_Attr_rec.pricing_attribute89 IS NULL ))
766 OR (p_Line_Price_Attr_rec.pricing_attribute90 IS NOT NULL AND
767 ( p_Line_Price_Attr_rec.pricing_attribute90 <>
768 p_old_Line_Price_Attr_rec.pricing_attribute90 OR
769 p_old_Line_Price_Attr_rec.pricing_attribute90 IS NULL ))
770 OR (p_Line_Price_Attr_rec.pricing_attribute91 IS NOT NULL AND
771 ( p_Line_Price_Attr_rec.pricing_attribute91 <>
772 p_old_Line_Price_Attr_rec.pricing_attribute91 OR
773 p_old_Line_Price_Attr_rec.pricing_attribute91 IS NULL ))
774 OR (p_Line_Price_Attr_rec.pricing_attribute92 IS NOT NULL AND
775 ( p_Line_Price_Attr_rec.pricing_attribute92 <>
776 p_old_Line_Price_Attr_rec.pricing_attribute92 OR
777 p_old_Line_Price_Attr_rec.pricing_attribute92 IS NULL ))
778 OR (p_Line_Price_Attr_rec.pricing_attribute93 IS NOT NULL AND
779 ( p_Line_Price_Attr_rec.pricing_attribute93 <>
780 p_old_Line_Price_Attr_rec.pricing_attribute93 OR
781 p_old_Line_Price_Attr_rec.pricing_attribute93 IS NULL ))
782 OR (p_Line_Price_Attr_rec.pricing_attribute94 IS NOT NULL AND
783 ( p_Line_Price_Attr_rec.pricing_attribute94 <>
784 p_old_Line_Price_Attr_rec.pricing_attribute94 OR
785 p_old_Line_Price_Attr_rec.pricing_attribute94 IS NULL ))
786 OR (p_Line_Price_Attr_rec.pricing_attribute95 IS NOT NULL AND
787 ( p_Line_Price_Attr_rec.pricing_attribute95 <>
788 p_old_Line_Price_Attr_rec.pricing_attribute95 OR
789 p_old_Line_Price_Attr_rec.pricing_attribute95 IS NULL ))
790 OR (p_Line_Price_Attr_rec.pricing_attribute96 IS NOT NULL AND
791 ( p_Line_Price_Attr_rec.pricing_attribute96 <>
792 p_old_Line_Price_Attr_rec.pricing_attribute96 OR
793 p_old_Line_Price_Attr_rec.pricing_attribute96 IS NULL ))
794 OR (p_Line_Price_Attr_rec.pricing_attribute97 IS NOT NULL AND
795 ( p_Line_Price_Attr_rec.pricing_attribute97 <>
796 p_old_Line_Price_Attr_rec.pricing_attribute97 OR
797 p_old_Line_Price_Attr_rec.pricing_attribute97 IS NULL ))
798 OR (p_Line_Price_Attr_rec.pricing_attribute98 IS NOT NULL AND
799 ( p_Line_Price_Attr_rec.pricing_attribute98 <>
800 p_old_Line_Price_Attr_rec.pricing_attribute98 OR
801 p_old_Line_Price_Attr_rec.pricing_attribute98 IS NULL ))
802 OR (p_Line_Price_Attr_rec.pricing_attribute99 IS NOT NULL AND
803 ( p_Line_Price_Attr_rec.pricing_attribute99 <>
804 p_old_Line_Price_Attr_rec.pricing_attribute99 OR
805 p_old_Line_Price_Attr_rec.pricing_attribute99 IS NULL ))
806 OR (p_Line_Price_Attr_rec.pricing_attribute100 IS NOT NULL AND
807 ( p_Line_Price_Attr_rec.pricing_attribute100 <>
808 p_old_Line_Price_Attr_rec.pricing_attribute100 OR
809 p_old_Line_Price_Attr_rec.pricing_attribute100 IS NULL ))
810 THEN
811
812 -- lkxu: modified to prevent user from updating the OTA pricing context.
813 IF ( (p_old_Line_Price_Attr_rec.pricing_context = 'OTA'
814 OR p_Line_Price_Attr_rec.pricing_context = 'OTA')
815 AND
816 p_Line_Price_Attr_rec.pricing_context <>
817 p_old_Line_Price_Attr_rec.pricing_context
818 AND
819 p_old_Line_Price_Attr_rec.pricing_context <> FND_API.G_MISS_CHAR) THEN
820
821 FND_MESSAGE.SET_NAME('ONT','ONT_OTA_UPDATE_NOT_ALLOWED');
822 OE_MSG_PUB.ADD;
823 RAISE FND_API.G_EXC_ERROR;
824 END IF;
825
826 if p_Line_Price_Attr_rec.flex_title='QP_ATTR_DEFNS_PRICING' then
827 l_column_prefix := 'PRICING';
828 else
829 l_column_prefix := 'QUALIFIER';
830 end if;
831
832 -- Added the IF condition(s) for bug#2708343
833
834 IF p_Line_Price_Attr_rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
835 l_column_value := null;
836 ELSE
837 l_column_value := p_Line_Price_Attr_rec.pricing_attribute1;
838 END IF;
839
840 FND_FLEX_DESCVAL.Set_Column_Value
841 ( column_name => l_column_prefix||'_ATTRIBUTE1'
842 , column_value => l_column_value
843 );
844
845 IF p_Line_Price_Attr_rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
846 l_column_value := null;
847 ELSE
848 l_column_value := p_Line_Price_Attr_rec.pricing_attribute2;
849 END IF;
850
851 FND_FLEX_DESCVAL.Set_Column_Value
852 ( column_name => l_column_prefix||'_ATTRIBUTE2'
853 , column_value => l_column_value
854 );
855
856 IF p_Line_Price_Attr_rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
857 l_column_value := null;
858 ELSE
859 l_column_value := p_Line_Price_Attr_rec.pricing_attribute3;
860 END IF;
861
862 FND_FLEX_DESCVAL.Set_Column_Value
863 ( column_name => l_column_prefix||'_ATTRIBUTE3'
864 , column_value => l_column_value
865 );
866
867 IF p_Line_Price_Attr_rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
868 l_column_value := null;
869 ELSE
870 l_column_value := p_Line_Price_Attr_rec.pricing_attribute4;
871 END IF;
872
873 FND_FLEX_DESCVAL.Set_Column_Value
874 ( column_name => l_column_prefix||'_ATTRIBUTE4'
875 , column_value => l_column_value
876 );
877
878 IF p_Line_Price_Attr_rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
879 l_column_value := null;
880 ELSE
881 l_column_value := p_Line_Price_Attr_rec.pricing_attribute5;
882 END IF;
883
884 FND_FLEX_DESCVAL.Set_Column_Value
885 ( column_name => l_column_prefix||'_ATTRIBUTE5'
886 , column_value => l_column_value
887 );
888
889 IF p_Line_Price_Attr_rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
890 l_column_value := null;
891 ELSE
892 l_column_value := p_Line_Price_Attr_rec.pricing_attribute6;
893 END IF;
894
895 FND_FLEX_DESCVAL.Set_Column_Value
896 ( column_name => l_column_prefix||'_ATTRIBUTE6'
897 , column_value => l_column_value
898 );
899
900 IF p_Line_Price_Attr_rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
901 l_column_value := null;
902 ELSE
903 l_column_value := p_Line_Price_Attr_rec.pricing_attribute7;
904 END IF;
905
906 FND_FLEX_DESCVAL.Set_Column_Value
907 ( column_name => l_column_prefix||'_ATTRIBUTE7'
908 , column_value => l_column_value
909 );
910
911 IF p_Line_Price_Attr_rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
912 l_column_value := null;
913 ELSE
914 l_column_value := p_Line_Price_Attr_rec.pricing_attribute8;
915 END IF;
916
917 FND_FLEX_DESCVAL.Set_Column_Value
918 ( column_name => l_column_prefix||'_ATTRIBUTE8'
919 , column_value => l_column_value
920 );
921
922 IF p_Line_Price_Attr_rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
923 l_column_value := null;
924 ELSE
925 l_column_value := p_Line_Price_Attr_rec.pricing_attribute9;
926 END IF;
927
928 FND_FLEX_DESCVAL.Set_Column_Value
929 ( column_name => l_column_prefix||'_ATTRIBUTE9'
930 , column_value => l_column_value
931 );
932
933 -- commented out for bug 1769612
934 /***
935 FND_FLEX_DESCVAL.Set_Column_Value
936 ( column_name => l_column_prefix||'_CONTEXT'
937 , column_value => p_Line_Price_Attr_rec.pricing_context
938 );
939 ***/
940
941 IF p_Line_Price_Attr_rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
942 l_column_value := null;
943 ELSE
944 l_column_value := p_Line_Price_Attr_rec.pricing_attribute10;
945 END IF;
946
947 FND_FLEX_DESCVAL.Set_Column_Value
948 ( column_name => l_column_prefix||'_ATTRIBUTE10'
949 , column_value => l_column_value
950 );
951
952 IF p_Line_Price_Attr_rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN
953 l_column_value := null;
954 ELSE
955 l_column_value := p_Line_Price_Attr_rec.pricing_attribute11;
956 END IF;
957
958 FND_FLEX_DESCVAL.Set_Column_Value
959 ( column_name => l_column_prefix||'_ATTRIBUTE11'
960 , column_value => l_column_value
961 );
962
963 IF p_Line_Price_Attr_rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN
964 l_column_value := null;
965 ELSE
966 l_column_value := p_Line_Price_Attr_rec.pricing_attribute12;
967 END IF;
968
969 FND_FLEX_DESCVAL.Set_Column_Value
970 ( column_name => l_column_prefix||'_ATTRIBUTE12'
971 , column_value => l_column_value
972 );
973
974 IF p_Line_Price_Attr_rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN
975 l_column_value := null;
976 ELSE
977 l_column_value := p_Line_Price_Attr_rec.pricing_attribute13;
978 END IF;
979
980 FND_FLEX_DESCVAL.Set_Column_Value
981 ( column_name => l_column_prefix||'_ATTRIBUTE13'
982 , column_value => l_column_value
983 );
984
985 IF p_Line_Price_Attr_rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN
986 l_column_value := null;
987 ELSE
988 l_column_value := p_Line_Price_Attr_rec.pricing_attribute14;
989 END IF;
990
991 FND_FLEX_DESCVAL.Set_Column_Value
992 ( column_name => l_column_prefix||'_ATTRIBUTE14'
993 , column_value => l_column_value
994 );
995
996 IF p_Line_Price_Attr_rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN
997 l_column_value := null;
998 ELSE
999 l_column_value := p_Line_Price_Attr_rec.pricing_attribute15;
1000 END IF;
1001
1002 FND_FLEX_DESCVAL.Set_Column_Value
1003 ( column_name => l_column_prefix||'_ATTRIBUTE15'
1004 , column_value => l_column_value
1005 );
1006
1007 IF p_Line_Price_Attr_rec.pricing_attribute16 = FND_API.G_MISS_CHAR THEN
1008 l_column_value := null;
1009 ELSE
1010 l_column_value := p_Line_Price_Attr_rec.pricing_attribute16;
1011 END IF;
1012
1013 FND_FLEX_DESCVAL.Set_Column_Value
1014 ( column_name => l_column_prefix||'_ATTRIBUTE16'
1015 , column_value => l_column_value
1016 );
1017
1018 IF p_Line_Price_Attr_rec.pricing_attribute17 = FND_API.G_MISS_CHAR THEN
1019 l_column_value := null;
1020 ELSE
1021 l_column_value := p_Line_Price_Attr_rec.pricing_attribute17;
1022 END IF;
1023
1024 FND_FLEX_DESCVAL.Set_Column_Value
1025 ( column_name => l_column_prefix||'_ATTRIBUTE17'
1026 , column_value => l_column_value
1027 );
1028
1029 IF p_Line_Price_Attr_rec.pricing_attribute18 = FND_API.G_MISS_CHAR THEN
1030 l_column_value := null;
1031 ELSE
1032 l_column_value := p_Line_Price_Attr_rec.pricing_attribute18;
1033 END IF;
1034
1035 FND_FLEX_DESCVAL.Set_Column_Value
1036 ( column_name => l_column_prefix||'_ATTRIBUTE18'
1037 , column_value => l_column_value
1038 );
1039
1040 IF p_Line_Price_Attr_rec.pricing_attribute19 = FND_API.G_MISS_CHAR THEN
1041 l_column_value := null;
1042 ELSE
1043 l_column_value := p_Line_Price_Attr_rec.pricing_attribute19;
1044 END IF;
1045
1046 FND_FLEX_DESCVAL.Set_Column_Value
1047 ( column_name => l_column_prefix||'_ATTRIBUTE19'
1048 , column_value => l_column_value
1049 );
1050
1051 IF p_Line_Price_Attr_rec.pricing_attribute20 = FND_API.G_MISS_CHAR THEN
1052 l_column_value := null;
1053 ELSE
1054 l_column_value := p_Line_Price_Attr_rec.pricing_attribute20;
1055 END IF;
1056
1057 FND_FLEX_DESCVAL.Set_Column_Value
1058 ( column_name => l_column_prefix||'_ATTRIBUTE20'
1059 , column_value => l_column_value
1060 );
1061
1062 IF p_Line_Price_Attr_rec.pricing_attribute21 = FND_API.G_MISS_CHAR THEN
1063 l_column_value := null;
1064 ELSE
1065 l_column_value := p_Line_Price_Attr_rec.pricing_attribute21;
1066 END IF;
1067
1068 FND_FLEX_DESCVAL.Set_Column_Value
1069 ( column_name => l_column_prefix||'_ATTRIBUTE21'
1070 , column_value => l_column_value
1071 );
1072
1073 IF p_Line_Price_Attr_rec.pricing_attribute22 = FND_API.G_MISS_CHAR THEN
1074 l_column_value := null;
1075 ELSE
1076 l_column_value := p_Line_Price_Attr_rec.pricing_attribute22;
1077 END IF;
1078
1079 FND_FLEX_DESCVAL.Set_Column_Value
1080 ( column_name => l_column_prefix||'_ATTRIBUTE22'
1081 , column_value => l_column_value
1082 );
1083
1084 IF p_Line_Price_Attr_rec.pricing_attribute23 = FND_API.G_MISS_CHAR THEN
1085 l_column_value := null;
1086 ELSE
1087 l_column_value := p_Line_Price_Attr_rec.pricing_attribute23;
1088 END IF;
1089
1090 FND_FLEX_DESCVAL.Set_Column_Value
1091 ( column_name => l_column_prefix||'_ATTRIBUTE23'
1092 , column_value => l_column_value
1093 );
1094
1095 IF p_Line_Price_Attr_rec.pricing_attribute24 = FND_API.G_MISS_CHAR THEN
1096 l_column_value := null;
1097 ELSE
1098 l_column_value := p_Line_Price_Attr_rec.pricing_attribute24;
1099 END IF;
1100
1101 FND_FLEX_DESCVAL.Set_Column_Value
1102 ( column_name => l_column_prefix||'_ATTRIBUTE24'
1103 , column_value => l_column_value
1104 );
1105
1106 IF p_Line_Price_Attr_rec.pricing_attribute25 = FND_API.G_MISS_CHAR THEN
1107 l_column_value := null;
1108 ELSE
1109 l_column_value := p_Line_Price_Attr_rec.pricing_attribute25;
1110 END IF;
1111
1112 FND_FLEX_DESCVAL.Set_Column_Value
1113 ( column_name => l_column_prefix||'_ATTRIBUTE25'
1114 , column_value => l_column_value
1115 );
1116
1117 IF p_Line_Price_Attr_rec.pricing_attribute26 = FND_API.G_MISS_CHAR THEN
1118 l_column_value := null;
1119 ELSE
1120 l_column_value := p_Line_Price_Attr_rec.pricing_attribute26;
1121 END IF;
1122
1123 FND_FLEX_DESCVAL.Set_Column_Value
1124 ( column_name => l_column_prefix||'_ATTRIBUTE26'
1125 , column_value => l_column_value
1126 );
1127
1128 IF p_Line_Price_Attr_rec.pricing_attribute27 = FND_API.G_MISS_CHAR THEN
1129 l_column_value := null;
1130 ELSE
1131 l_column_value := p_Line_Price_Attr_rec.pricing_attribute27;
1132 END IF;
1133
1134 FND_FLEX_DESCVAL.Set_Column_Value
1135 ( column_name => l_column_prefix||'_ATTRIBUTE27'
1136 , column_value => l_column_value
1137 );
1138
1139 IF p_Line_Price_Attr_rec.pricing_attribute28 = FND_API.G_MISS_CHAR THEN
1140 l_column_value := null;
1141 ELSE
1142 l_column_value := p_Line_Price_Attr_rec.pricing_attribute28;
1143 END IF;
1144
1145 FND_FLEX_DESCVAL.Set_Column_Value
1146 ( column_name => l_column_prefix||'_ATTRIBUTE28'
1147 , column_value => l_column_value
1148 );
1149
1150 IF p_Line_Price_Attr_rec.pricing_attribute29 = FND_API.G_MISS_CHAR THEN
1151 l_column_value := null;
1152 ELSE
1153 l_column_value := p_Line_Price_Attr_rec.pricing_attribute29;
1154 END IF;
1155
1156 FND_FLEX_DESCVAL.Set_Column_Value
1157 ( column_name => l_column_prefix||'_ATTRIBUTE29'
1158 , column_value => l_column_value
1159 );
1160
1161 IF p_Line_Price_Attr_rec.pricing_attribute30 = FND_API.G_MISS_CHAR THEN
1162 l_column_value := null;
1163 ELSE
1164 l_column_value := p_Line_Price_Attr_rec.pricing_attribute30;
1165 END IF;
1166
1167 FND_FLEX_DESCVAL.Set_Column_Value
1168 ( column_name => l_column_prefix||'_ATTRIBUTE30'
1169 , column_value => l_column_value
1170 );
1171
1172 IF p_Line_Price_Attr_rec.pricing_attribute31 = FND_API.G_MISS_CHAR THEN
1173 l_column_value := null;
1174 ELSE
1175 l_column_value := p_Line_Price_Attr_rec.pricing_attribute31;
1176 END IF;
1177
1178 FND_FLEX_DESCVAL.Set_Column_Value
1179 ( column_name => l_column_prefix||'_ATTRIBUTE31'
1180 , column_value => l_column_value
1181 );
1182
1183 IF p_Line_Price_Attr_rec.pricing_attribute32 = FND_API.G_MISS_CHAR THEN
1184 l_column_value := null;
1185 ELSE
1186 l_column_value := p_Line_Price_Attr_rec.pricing_attribute32;
1187 END IF;
1188
1189 FND_FLEX_DESCVAL.Set_Column_Value
1190 ( column_name => l_column_prefix||'_ATTRIBUTE32'
1191 , column_value => l_column_value
1192 );
1193
1194 IF p_Line_Price_Attr_rec.pricing_attribute33 = FND_API.G_MISS_CHAR THEN
1195 l_column_value := null;
1196 ELSE
1197 l_column_value := p_Line_Price_Attr_rec.pricing_attribute33;
1198 END IF;
1199
1200 FND_FLEX_DESCVAL.Set_Column_Value
1201 ( column_name => l_column_prefix||'_ATTRIBUTE33'
1202 , column_value => l_column_value
1203 );
1204
1205 IF p_Line_Price_Attr_rec.pricing_attribute34 = FND_API.G_MISS_CHAR THEN
1206 l_column_value := null;
1207 ELSE
1208 l_column_value := p_Line_Price_Attr_rec.pricing_attribute34;
1209 END IF;
1210
1211 FND_FLEX_DESCVAL.Set_Column_Value
1212 ( column_name => l_column_prefix||'_ATTRIBUTE34'
1213 , column_value => l_column_value
1214 );
1215
1216 IF p_Line_Price_Attr_rec.pricing_attribute35 = FND_API.G_MISS_CHAR THEN
1217 l_column_value := null;
1218 ELSE
1219 l_column_value := p_Line_Price_Attr_rec.pricing_attribute35;
1220 END IF;
1221
1222 FND_FLEX_DESCVAL.Set_Column_Value
1223 ( column_name => l_column_prefix||'_ATTRIBUTE35'
1224 , column_value => l_column_value
1225 );
1226
1227 IF p_Line_Price_Attr_rec.pricing_attribute36 = FND_API.G_MISS_CHAR THEN
1228 l_column_value := null;
1229 ELSE
1230 l_column_value := p_Line_Price_Attr_rec.pricing_attribute36;
1231 END IF;
1232
1233 FND_FLEX_DESCVAL.Set_Column_Value
1234 ( column_name => l_column_prefix||'_ATTRIBUTE36'
1235 , column_value => l_column_value
1236 );
1237
1238 IF p_Line_Price_Attr_rec.pricing_attribute37 = FND_API.G_MISS_CHAR THEN
1239 l_column_value := null;
1240 ELSE
1241 l_column_value := p_Line_Price_Attr_rec.pricing_attribute37;
1242 END IF;
1243
1244 FND_FLEX_DESCVAL.Set_Column_Value
1245 ( column_name => l_column_prefix||'_ATTRIBUTE37'
1246 , column_value => l_column_value
1247 );
1248
1249 IF p_Line_Price_Attr_rec.pricing_attribute38 = FND_API.G_MISS_CHAR THEN
1250 l_column_value := null;
1251 ELSE
1252 l_column_value := p_Line_Price_Attr_rec.pricing_attribute38;
1253 END IF;
1254
1255 FND_FLEX_DESCVAL.Set_Column_Value
1256 ( column_name => l_column_prefix||'_ATTRIBUTE38'
1257 , column_value => l_column_value
1258 );
1259
1260 IF p_Line_Price_Attr_rec.pricing_attribute39 = FND_API.G_MISS_CHAR THEN
1261 l_column_value := null;
1262 ELSE
1263 l_column_value := p_Line_Price_Attr_rec.pricing_attribute39;
1264 END IF;
1265
1266 FND_FLEX_DESCVAL.Set_Column_Value
1267 ( column_name => l_column_prefix||'_ATTRIBUTE39'
1268 , column_value => l_column_value
1269 );
1270
1271 IF p_Line_Price_Attr_rec.pricing_attribute40 = FND_API.G_MISS_CHAR THEN
1272 l_column_value := null;
1273 ELSE
1274 l_column_value := p_Line_Price_Attr_rec.pricing_attribute40;
1275 END IF;
1276
1277 FND_FLEX_DESCVAL.Set_Column_Value
1278 ( column_name => l_column_prefix||'_ATTRIBUTE40'
1279 , column_value => l_column_value
1280 );
1281
1282 IF p_Line_Price_Attr_rec.pricing_attribute41 = FND_API.G_MISS_CHAR THEN
1283 l_column_value := null;
1284 ELSE
1285 l_column_value := p_Line_Price_Attr_rec.pricing_attribute41;
1286 END IF;
1287
1288 FND_FLEX_DESCVAL.Set_Column_Value
1289 ( column_name => l_column_prefix||'_ATTRIBUTE41'
1290 , column_value => l_column_value
1291 );
1292
1293 IF p_Line_Price_Attr_rec.pricing_attribute42 = FND_API.G_MISS_CHAR THEN
1294 l_column_value := null;
1295 ELSE
1296 l_column_value := p_Line_Price_Attr_rec.pricing_attribute42;
1297 END IF;
1298
1299 FND_FLEX_DESCVAL.Set_Column_Value
1300 ( column_name => l_column_prefix||'_ATTRIBUTE42'
1301 , column_value => l_column_value
1302 );
1303
1304 IF p_Line_Price_Attr_rec.pricing_attribute43 = FND_API.G_MISS_CHAR THEN
1305 l_column_value := null;
1306 ELSE
1307 l_column_value := p_Line_Price_Attr_rec.pricing_attribute43;
1308 END IF;
1309
1310 FND_FLEX_DESCVAL.Set_Column_Value
1311 ( column_name => l_column_prefix||'_ATTRIBUTE43'
1312 , column_value => l_column_value
1313 );
1314
1315 IF p_Line_Price_Attr_rec.pricing_attribute44 = FND_API.G_MISS_CHAR THEN
1316 l_column_value := null;
1317 ELSE
1318 l_column_value := p_Line_Price_Attr_rec.pricing_attribute44;
1319 END IF;
1320
1321 FND_FLEX_DESCVAL.Set_Column_Value
1322 ( column_name => l_column_prefix||'_ATTRIBUTE44'
1323 , column_value => l_column_value
1324 );
1325
1326 IF p_Line_Price_Attr_rec.pricing_attribute45 = FND_API.G_MISS_CHAR THEN
1327 l_column_value := null;
1328 ELSE
1329 l_column_value := p_Line_Price_Attr_rec.pricing_attribute45;
1330 END IF;
1331
1332 FND_FLEX_DESCVAL.Set_Column_Value
1333 ( column_name => l_column_prefix||'_ATTRIBUTE45'
1334 , column_value => l_column_value
1335 );
1336
1337 IF p_Line_Price_Attr_rec.pricing_attribute46 = FND_API.G_MISS_CHAR THEN
1338 l_column_value := null;
1339 ELSE
1340 l_column_value := p_Line_Price_Attr_rec.pricing_attribute46;
1341 END IF;
1342
1343 FND_FLEX_DESCVAL.Set_Column_Value
1344 ( column_name => l_column_prefix||'_ATTRIBUTE46'
1345 , column_value => l_column_value
1346 );
1347
1348 IF p_Line_Price_Attr_rec.pricing_attribute47 = FND_API.G_MISS_CHAR THEN
1349 l_column_value := null;
1350 ELSE
1351 l_column_value := p_Line_Price_Attr_rec.pricing_attribute47;
1352 END IF;
1353
1354 FND_FLEX_DESCVAL.Set_Column_Value
1355 ( column_name => l_column_prefix||'_ATTRIBUTE47'
1356 , column_value => l_column_value
1357 );
1358
1359 IF p_Line_Price_Attr_rec.pricing_attribute48 = FND_API.G_MISS_CHAR THEN
1360 l_column_value := null;
1361 ELSE
1362 l_column_value := p_Line_Price_Attr_rec.pricing_attribute48;
1363 END IF;
1364
1365 FND_FLEX_DESCVAL.Set_Column_Value
1366 ( column_name => l_column_prefix||'_ATTRIBUTE48'
1367 , column_value => l_column_value
1368 );
1369
1370 IF p_Line_Price_Attr_rec.pricing_attribute49 = FND_API.G_MISS_CHAR THEN
1371 l_column_value := null;
1372 ELSE
1373 l_column_value := p_Line_Price_Attr_rec.pricing_attribute49;
1374 END IF;
1375
1376 FND_FLEX_DESCVAL.Set_Column_Value
1377 ( column_name => l_column_prefix||'_ATTRIBUTE49'
1378 , column_value => l_column_value
1379 );
1380
1381 IF p_Line_Price_Attr_rec.pricing_attribute50 = FND_API.G_MISS_CHAR THEN
1382 l_column_value := null;
1383 ELSE
1384 l_column_value := p_Line_Price_Attr_rec.pricing_attribute50;
1385 END IF;
1386
1387 FND_FLEX_DESCVAL.Set_Column_Value
1388 ( column_name => l_column_prefix||'_ATTRIBUTE50'
1389 , column_value => l_column_value
1390 );
1391
1392 IF p_Line_Price_Attr_rec.pricing_attribute51 = FND_API.G_MISS_CHAR THEN
1393 l_column_value := null;
1394 ELSE
1395 l_column_value := p_Line_Price_Attr_rec.pricing_attribute51;
1396 END IF;
1397
1398 FND_FLEX_DESCVAL.Set_Column_Value
1399 ( column_name => l_column_prefix||'_ATTRIBUTE51'
1400 , column_value => l_column_value
1401 );
1402
1403 IF p_Line_Price_Attr_rec.pricing_attribute52 = FND_API.G_MISS_CHAR THEN
1404 l_column_value := null;
1405 ELSE
1406 l_column_value := p_Line_Price_Attr_rec.pricing_attribute52;
1407 END IF;
1408
1409 FND_FLEX_DESCVAL.Set_Column_Value
1410 ( column_name => l_column_prefix||'_ATTRIBUTE52'
1411 , column_value => l_column_value
1412 );
1413
1414 IF p_Line_Price_Attr_rec.pricing_attribute53 = FND_API.G_MISS_CHAR THEN
1415 l_column_value := null;
1416 ELSE
1417 l_column_value := p_Line_Price_Attr_rec.pricing_attribute53;
1418 END IF;
1419
1420 FND_FLEX_DESCVAL.Set_Column_Value
1421 ( column_name => l_column_prefix||'_ATTRIBUTE53'
1422 , column_value => l_column_value
1423 );
1424
1425 IF p_Line_Price_Attr_rec.pricing_attribute54 = FND_API.G_MISS_CHAR THEN
1426 l_column_value := null;
1427 ELSE
1428 l_column_value := p_Line_Price_Attr_rec.pricing_attribute54;
1429 END IF;
1430
1431 FND_FLEX_DESCVAL.Set_Column_Value
1432 ( column_name => l_column_prefix||'_ATTRIBUTE54'
1433 , column_value => l_column_value
1434 );
1435
1436 IF p_Line_Price_Attr_rec.pricing_attribute55 = FND_API.G_MISS_CHAR THEN
1437 l_column_value := null;
1438 ELSE
1439 l_column_value := p_Line_Price_Attr_rec.pricing_attribute55;
1440 END IF;
1441
1442 FND_FLEX_DESCVAL.Set_Column_Value
1443 ( column_name => l_column_prefix||'_ATTRIBUTE55'
1444 , column_value => l_column_value
1445 );
1446
1447 IF p_Line_Price_Attr_rec.pricing_attribute56 = FND_API.G_MISS_CHAR THEN
1448 l_column_value := null;
1449 ELSE
1450 l_column_value := p_Line_Price_Attr_rec.pricing_attribute56;
1451 END IF;
1452
1453 FND_FLEX_DESCVAL.Set_Column_Value
1454 ( column_name => l_column_prefix||'_ATTRIBUTE56'
1455 , column_value => l_column_value
1456 );
1457
1458 IF p_Line_Price_Attr_rec.pricing_attribute57 = FND_API.G_MISS_CHAR THEN
1459 l_column_value := null;
1460 ELSE
1461 l_column_value := p_Line_Price_Attr_rec.pricing_attribute57;
1462 END IF;
1463
1464 FND_FLEX_DESCVAL.Set_Column_Value
1465 ( column_name => l_column_prefix||'_ATTRIBUTE57'
1466 , column_value => l_column_value
1467 );
1468
1469 IF p_Line_Price_Attr_rec.pricing_attribute58 = FND_API.G_MISS_CHAR THEN
1470 l_column_value := null;
1471 ELSE
1472 l_column_value := p_Line_Price_Attr_rec.pricing_attribute58;
1473 END IF;
1474
1475 FND_FLEX_DESCVAL.Set_Column_Value
1476 ( column_name => l_column_prefix||'_ATTRIBUTE58'
1477 , column_value => l_column_value
1478 );
1479
1480 IF p_Line_Price_Attr_rec.pricing_attribute59 = FND_API.G_MISS_CHAR THEN
1481 l_column_value := null;
1482 ELSE
1483 l_column_value := p_Line_Price_Attr_rec.pricing_attribute59;
1484 END IF;
1485
1486 FND_FLEX_DESCVAL.Set_Column_Value
1487 ( column_name => l_column_prefix||'_ATTRIBUTE59'
1488 , column_value => l_column_value
1489 );
1490
1491 IF p_Line_Price_Attr_rec.pricing_attribute60 = FND_API.G_MISS_CHAR THEN
1492 l_column_value := null;
1493 ELSE
1494 l_column_value := p_Line_Price_Attr_rec.pricing_attribute60;
1495 END IF;
1496
1497 FND_FLEX_DESCVAL.Set_Column_Value
1498 ( column_name => l_column_prefix||'_ATTRIBUTE60'
1499 , column_value => l_column_value
1500 );
1501
1502 IF p_Line_Price_Attr_rec.pricing_attribute61 = FND_API.G_MISS_CHAR THEN
1503 l_column_value := null;
1504 ELSE
1505 l_column_value := p_Line_Price_Attr_rec.pricing_attribute61;
1506 END IF;
1507
1508 FND_FLEX_DESCVAL.Set_Column_Value
1509 ( column_name => l_column_prefix||'_ATTRIBUTE61'
1510 , column_value => l_column_value
1511 );
1512
1513 IF p_Line_Price_Attr_rec.pricing_attribute62 = FND_API.G_MISS_CHAR THEN
1514 l_column_value := null;
1515 ELSE
1516 l_column_value := p_Line_Price_Attr_rec.pricing_attribute62;
1517 END IF;
1518
1519 FND_FLEX_DESCVAL.Set_Column_Value
1520 ( column_name => l_column_prefix||'_ATTRIBUTE62'
1521 , column_value => l_column_value
1522 );
1523
1524 IF p_Line_Price_Attr_rec.pricing_attribute63 = FND_API.G_MISS_CHAR THEN
1525 l_column_value := null;
1526 ELSE
1527 l_column_value := p_Line_Price_Attr_rec.pricing_attribute63;
1528 END IF;
1529
1530 FND_FLEX_DESCVAL.Set_Column_Value
1531 ( column_name => l_column_prefix||'_ATTRIBUTE63'
1532 , column_value => l_column_value
1533 );
1534
1535 IF p_Line_Price_Attr_rec.pricing_attribute64 = FND_API.G_MISS_CHAR THEN
1536 l_column_value := null;
1537 ELSE
1538 l_column_value := p_Line_Price_Attr_rec.pricing_attribute64;
1539 END IF;
1540
1541 FND_FLEX_DESCVAL.Set_Column_Value
1542 ( column_name => l_column_prefix||'_ATTRIBUTE64'
1543 , column_value => l_column_value
1544 );
1545
1546 IF p_Line_Price_Attr_rec.pricing_attribute65 = FND_API.G_MISS_CHAR THEN
1547 l_column_value := null;
1548 ELSE
1549 l_column_value := p_Line_Price_Attr_rec.pricing_attribute65;
1550 END IF;
1551
1552 FND_FLEX_DESCVAL.Set_Column_Value
1553 ( column_name => l_column_prefix||'_ATTRIBUTE65'
1554 , column_value => l_column_value
1555 );
1556
1557 IF p_Line_Price_Attr_rec.pricing_attribute66 = FND_API.G_MISS_CHAR THEN
1558 l_column_value := null;
1559 ELSE
1560 l_column_value := p_Line_Price_Attr_rec.pricing_attribute66;
1561 END IF;
1562
1563 FND_FLEX_DESCVAL.Set_Column_Value
1564 ( column_name => l_column_prefix||'_ATTRIBUTE66'
1565 , column_value => l_column_value
1566 );
1567
1568 IF p_Line_Price_Attr_rec.pricing_attribute67 = FND_API.G_MISS_CHAR THEN
1569 l_column_value := null;
1570 ELSE
1571 l_column_value := p_Line_Price_Attr_rec.pricing_attribute67;
1572 END IF;
1573
1574 FND_FLEX_DESCVAL.Set_Column_Value
1575 ( column_name => l_column_prefix||'_ATTRIBUTE67'
1576 , column_value => l_column_value
1577 );
1578
1579 IF p_Line_Price_Attr_rec.pricing_attribute68 = FND_API.G_MISS_CHAR THEN
1580 l_column_value := null;
1581 ELSE
1582 l_column_value := p_Line_Price_Attr_rec.pricing_attribute68;
1583 END IF;
1584
1585 FND_FLEX_DESCVAL.Set_Column_Value
1586 ( column_name => l_column_prefix||'_ATTRIBUTE68'
1587 , column_value => l_column_value
1588 );
1589
1590 IF p_Line_Price_Attr_rec.pricing_attribute69 = FND_API.G_MISS_CHAR THEN
1591 l_column_value := null;
1592 ELSE
1593 l_column_value := p_Line_Price_Attr_rec.pricing_attribute69;
1594 END IF;
1595
1596 FND_FLEX_DESCVAL.Set_Column_Value
1597 ( column_name => l_column_prefix||'_ATTRIBUTE69'
1598 , column_value => l_column_value
1599 );
1600
1601 IF p_Line_Price_Attr_rec.pricing_attribute70 = FND_API.G_MISS_CHAR THEN
1602 l_column_value := null;
1603 ELSE
1604 l_column_value := p_Line_Price_Attr_rec.pricing_attribute70;
1605 END IF;
1606
1607 FND_FLEX_DESCVAL.Set_Column_Value
1608 ( column_name => l_column_prefix||'_ATTRIBUTE70'
1609 , column_value => l_column_value
1610 );
1611
1612 IF p_Line_Price_Attr_rec.pricing_attribute71 = FND_API.G_MISS_CHAR THEN
1613 l_column_value := null;
1614 ELSE
1615 l_column_value := p_Line_Price_Attr_rec.pricing_attribute71;
1616 END IF;
1617
1618 FND_FLEX_DESCVAL.Set_Column_Value
1619 ( column_name => l_column_prefix||'_ATTRIBUTE71'
1620 , column_value => l_column_value
1621 );
1622
1623 IF p_Line_Price_Attr_rec.pricing_attribute72 = FND_API.G_MISS_CHAR THEN
1624 l_column_value := null;
1625 ELSE
1626 l_column_value := p_Line_Price_Attr_rec.pricing_attribute72;
1627 END IF;
1628
1629 FND_FLEX_DESCVAL.Set_Column_Value
1630 ( column_name => l_column_prefix||'_ATTRIBUTE72'
1631 , column_value => l_column_value
1632 );
1633
1634 IF p_Line_Price_Attr_rec.pricing_attribute73 = FND_API.G_MISS_CHAR THEN
1635 l_column_value := null;
1636 ELSE
1637 l_column_value := p_Line_Price_Attr_rec.pricing_attribute73;
1638 END IF;
1639
1640 FND_FLEX_DESCVAL.Set_Column_Value
1641 ( column_name => l_column_prefix||'_ATTRIBUTE73'
1642 , column_value => l_column_value
1643 );
1644
1645 IF p_Line_Price_Attr_rec.pricing_attribute74 = FND_API.G_MISS_CHAR THEN
1646 l_column_value := null;
1647 ELSE
1648 l_column_value := p_Line_Price_Attr_rec.pricing_attribute74;
1649 END IF;
1650
1651 FND_FLEX_DESCVAL.Set_Column_Value
1652 ( column_name => l_column_prefix||'_ATTRIBUTE74'
1653 , column_value => l_column_value
1654 );
1655
1656 IF p_Line_Price_Attr_rec.pricing_attribute75 = FND_API.G_MISS_CHAR THEN
1657 l_column_value := null;
1658 ELSE
1659 l_column_value := p_Line_Price_Attr_rec.pricing_attribute75;
1660 END IF;
1661
1662 FND_FLEX_DESCVAL.Set_Column_Value
1663 ( column_name => l_column_prefix||'_ATTRIBUTE75'
1664 , column_value => l_column_value
1665 );
1666
1667 IF p_Line_Price_Attr_rec.pricing_attribute76 = FND_API.G_MISS_CHAR THEN
1668 l_column_value := null;
1669 ELSE
1670 l_column_value := p_Line_Price_Attr_rec.pricing_attribute76;
1671 END IF;
1672
1673 FND_FLEX_DESCVAL.Set_Column_Value
1674 ( column_name => l_column_prefix||'_ATTRIBUTE76'
1675 , column_value => l_column_value
1676 );
1677
1678 IF p_Line_Price_Attr_rec.pricing_attribute77 = FND_API.G_MISS_CHAR THEN
1679 l_column_value := null;
1680 ELSE
1681 l_column_value := p_Line_Price_Attr_rec.pricing_attribute77;
1682 END IF;
1683
1684 FND_FLEX_DESCVAL.Set_Column_Value
1685 ( column_name => l_column_prefix||'_ATTRIBUTE77'
1686 , column_value => l_column_value
1687 );
1688
1689 IF p_Line_Price_Attr_rec.pricing_attribute78 = FND_API.G_MISS_CHAR THEN
1690 l_column_value := null;
1691 ELSE
1692 l_column_value := p_Line_Price_Attr_rec.pricing_attribute78;
1693 END IF;
1694
1695 FND_FLEX_DESCVAL.Set_Column_Value
1696 ( column_name => l_column_prefix||'_ATTRIBUTE78'
1697 , column_value => l_column_value
1698 );
1699
1700 IF p_Line_Price_Attr_rec.pricing_attribute79 = FND_API.G_MISS_CHAR THEN
1701 l_column_value := null;
1702 ELSE
1703 l_column_value := p_Line_Price_Attr_rec.pricing_attribute79;
1704 END IF;
1705
1706 FND_FLEX_DESCVAL.Set_Column_Value
1707 ( column_name => l_column_prefix||'_ATTRIBUTE79'
1708 , column_value => l_column_value
1709 );
1710
1711 IF p_Line_Price_Attr_rec.pricing_attribute80 = FND_API.G_MISS_CHAR THEN
1712 l_column_value := null;
1713 ELSE
1714 l_column_value := p_Line_Price_Attr_rec.pricing_attribute80;
1715 END IF;
1716
1717 FND_FLEX_DESCVAL.Set_Column_Value
1718 ( column_name => l_column_prefix||'_ATTRIBUTE80'
1719 , column_value => l_column_value
1720 );
1721
1722 IF p_Line_Price_Attr_rec.pricing_attribute81 = FND_API.G_MISS_CHAR THEN
1723 l_column_value := null;
1724 ELSE
1725 l_column_value := p_Line_Price_Attr_rec.pricing_attribute81;
1726 END IF;
1727
1728 FND_FLEX_DESCVAL.Set_Column_Value
1729 ( column_name => l_column_prefix||'_ATTRIBUTE81'
1730 , column_value => l_column_value
1731 );
1732
1733 IF p_Line_Price_Attr_rec.pricing_attribute82 = FND_API.G_MISS_CHAR THEN
1734 l_column_value := null;
1735 ELSE
1736 l_column_value := p_Line_Price_Attr_rec.pricing_attribute82;
1737 END IF;
1738
1739 FND_FLEX_DESCVAL.Set_Column_Value
1740 ( column_name => l_column_prefix||'_ATTRIBUTE82'
1741 , column_value => l_column_value
1742 );
1743
1744 IF p_Line_Price_Attr_rec.pricing_attribute83 = FND_API.G_MISS_CHAR THEN
1745 l_column_value := null;
1746 ELSE
1747 l_column_value := p_Line_Price_Attr_rec.pricing_attribute83;
1748 END IF;
1749
1750 FND_FLEX_DESCVAL.Set_Column_Value
1751 ( column_name => l_column_prefix||'_ATTRIBUTE83'
1752 , column_value => l_column_value
1753 );
1754
1755 IF p_Line_Price_Attr_rec.pricing_attribute84 = FND_API.G_MISS_CHAR THEN
1756 l_column_value := null;
1757 ELSE
1758 l_column_value := p_Line_Price_Attr_rec.pricing_attribute84;
1759 END IF;
1760
1761 FND_FLEX_DESCVAL.Set_Column_Value
1762 ( column_name => l_column_prefix||'_ATTRIBUTE84'
1763 , column_value => l_column_value
1764 );
1765
1766 IF p_Line_Price_Attr_rec.pricing_attribute85 = FND_API.G_MISS_CHAR THEN
1767 l_column_value := null;
1768 ELSE
1769 l_column_value := p_Line_Price_Attr_rec.pricing_attribute85;
1770 END IF;
1771
1772 FND_FLEX_DESCVAL.Set_Column_Value
1773 ( column_name => l_column_prefix||'_ATTRIBUTE85'
1774 , column_value => l_column_value
1775 );
1776
1777 IF p_Line_Price_Attr_rec.pricing_attribute86 = FND_API.G_MISS_CHAR THEN
1778 l_column_value := null;
1779 ELSE
1780 l_column_value := p_Line_Price_Attr_rec.pricing_attribute86;
1781 END IF;
1782
1783 FND_FLEX_DESCVAL.Set_Column_Value
1784 ( column_name => l_column_prefix||'_ATTRIBUTE86'
1785 , column_value => l_column_value
1786 );
1787
1788 IF p_Line_Price_Attr_rec.pricing_attribute87 = FND_API.G_MISS_CHAR THEN
1789 l_column_value := null;
1790 ELSE
1791 l_column_value := p_Line_Price_Attr_rec.pricing_attribute87;
1792 END IF;
1793
1794 FND_FLEX_DESCVAL.Set_Column_Value
1795 ( column_name => l_column_prefix||'_ATTRIBUTE87'
1796 , column_value => l_column_value
1797 );
1798
1799 IF p_Line_Price_Attr_rec.pricing_attribute88 = FND_API.G_MISS_CHAR THEN
1800 l_column_value := null;
1801 ELSE
1802 l_column_value := p_Line_Price_Attr_rec.pricing_attribute88;
1803 END IF;
1804
1805 FND_FLEX_DESCVAL.Set_Column_Value
1806 ( column_name => l_column_prefix||'_ATTRIBUTE88'
1807 , column_value => l_column_value
1808 );
1809
1810 IF p_Line_Price_Attr_rec.pricing_attribute89 = FND_API.G_MISS_CHAR THEN
1811 l_column_value := null;
1812 ELSE
1813 l_column_value := p_Line_Price_Attr_rec.pricing_attribute89;
1814 END IF;
1815
1816 FND_FLEX_DESCVAL.Set_Column_Value
1817 ( column_name => l_column_prefix||'_ATTRIBUTE89'
1818 , column_value => l_column_value
1819 );
1820
1821 IF p_Line_Price_Attr_rec.pricing_attribute90 = FND_API.G_MISS_CHAR THEN
1822 l_column_value := null;
1823 ELSE
1824 l_column_value := p_Line_Price_Attr_rec.pricing_attribute90;
1825 END IF;
1826
1827 FND_FLEX_DESCVAL.Set_Column_Value
1828 ( column_name => l_column_prefix||'_ATTRIBUTE90'
1829 , column_value => l_column_value
1830 );
1831
1832 IF p_Line_Price_Attr_rec.pricing_attribute91 = FND_API.G_MISS_CHAR THEN
1833 l_column_value := null;
1834 ELSE
1835 l_column_value := p_Line_Price_Attr_rec.pricing_attribute91;
1836 END IF;
1837
1838 FND_FLEX_DESCVAL.Set_Column_Value
1839 ( column_name => l_column_prefix||'_ATTRIBUTE91'
1840 , column_value => l_column_value
1841 );
1842
1843 IF p_Line_Price_Attr_rec.pricing_attribute92 = FND_API.G_MISS_CHAR THEN
1844 l_column_value := null;
1845 ELSE
1846 l_column_value := p_Line_Price_Attr_rec.pricing_attribute92;
1847 END IF;
1848
1849 FND_FLEX_DESCVAL.Set_Column_Value
1850 ( column_name => l_column_prefix||'_ATTRIBUTE92'
1851 , column_value => l_column_value
1852 );
1853
1854 IF p_Line_Price_Attr_rec.pricing_attribute93 = FND_API.G_MISS_CHAR THEN
1855 l_column_value := null;
1856 ELSE
1857 l_column_value := p_Line_Price_Attr_rec.pricing_attribute93;
1858 END IF;
1859
1860 FND_FLEX_DESCVAL.Set_Column_Value
1861 ( column_name => l_column_prefix||'_ATTRIBUTE93'
1862 , column_value => l_column_value
1863 );
1864
1865 IF p_Line_Price_Attr_rec.pricing_attribute94 = FND_API.G_MISS_CHAR THEN
1866 l_column_value := null;
1867 ELSE
1868 l_column_value := p_Line_Price_Attr_rec.pricing_attribute94;
1869 END IF;
1870
1871 FND_FLEX_DESCVAL.Set_Column_Value
1872 ( column_name => l_column_prefix||'_ATTRIBUTE94'
1873 , column_value => l_column_value
1874 );
1875
1876 IF p_Line_Price_Attr_rec.pricing_attribute95 = FND_API.G_MISS_CHAR THEN
1877 l_column_value := null;
1878 ELSE
1879 l_column_value := p_Line_Price_Attr_rec.pricing_attribute95;
1880 END IF;
1881
1882 FND_FLEX_DESCVAL.Set_Column_Value
1883 ( column_name => l_column_prefix||'_ATTRIBUTE95'
1884 , column_value => l_column_value
1885 );
1886
1887 IF p_Line_Price_Attr_rec.pricing_attribute96 = FND_API.G_MISS_CHAR THEN
1888 l_column_value := null;
1889 ELSE
1890 l_column_value := p_Line_Price_Attr_rec.pricing_attribute96;
1891 END IF;
1892
1893 FND_FLEX_DESCVAL.Set_Column_Value
1894 ( column_name => l_column_prefix||'_ATTRIBUTE96'
1895 , column_value => l_column_value
1896 );
1897
1898 IF p_Line_Price_Attr_rec.pricing_attribute97 = FND_API.G_MISS_CHAR THEN
1899 l_column_value := null;
1900 ELSE
1901 l_column_value := p_Line_Price_Attr_rec.pricing_attribute97;
1902 END IF;
1903
1904 FND_FLEX_DESCVAL.Set_Column_Value
1905 ( column_name => l_column_prefix||'_ATTRIBUTE97'
1906 , column_value => l_column_value
1907 );
1908
1909 IF p_Line_Price_Attr_rec.pricing_attribute98 = FND_API.G_MISS_CHAR THEN
1910 l_column_value := null;
1911 ELSE
1912 l_column_value := p_Line_Price_Attr_rec.pricing_attribute98;
1913 END IF;
1914
1915 FND_FLEX_DESCVAL.Set_Column_Value
1916 ( column_name => l_column_prefix||'_ATTRIBUTE98'
1917 , column_value => l_column_value
1918 );
1919
1920 IF p_Line_Price_Attr_rec.pricing_attribute99 = FND_API.G_MISS_CHAR THEN
1921 l_column_value := null;
1922 ELSE
1923 l_column_value := p_Line_Price_Attr_rec.pricing_attribute99;
1924 END IF;
1925
1926 FND_FLEX_DESCVAL.Set_Column_Value
1927 ( column_name => l_column_prefix||'_ATTRIBUTE99'
1928 , column_value => l_column_value
1929 );
1930
1931 IF p_Line_Price_Attr_rec.pricing_attribute100 = FND_API.G_MISS_CHAR THEN
1932 l_column_value := null;
1933 ELSE
1934 l_column_value := p_Line_Price_Attr_rec.pricing_attribute100;
1935 END IF;
1936
1937 FND_FLEX_DESCVAL.Set_Column_Value
1938 ( column_name => l_column_prefix||'_ATTRIBUTE100'
1939 , column_value => l_column_value
1940 );
1941
1942 -- bug 1769612
1943 FND_FLEX_DESCVAL.Set_Context_Value
1944 (
1945 context_value => p_Line_Price_Attr_rec.pricing_context
1946 );
1947
1948 -- Validate descriptive flexfield.
1949 /*IF NOT OE_Validate_adj.Desc_Flex( 'QP', p_Line_Price_Attr_rec.Flex_Title )
1950 THEN
1951 IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
1952 p_line_price_attr_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1953 -- don't raise error.
1954 null;
1955 ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
1956 p_line_price_attr_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
1957 -- don't raise error.
1958 null;
1959 ELSE
1960 x_return_status := FND_API.G_RET_STS_ERROR;
1961 END IF;
1962 END IF;*/
1963 END IF;
1964 end if ; /* if OE_GLOBALS.g_validate_desc_flex ='Y' then --bug 4343612 */
1965 -- Done validating attributes
1966
1967 EXCEPTION
1968
1969 WHEN FND_API.G_EXC_ERROR THEN
1970
1971 x_return_status := FND_API.G_RET_STS_ERROR;
1972
1973 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1974
1975 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1976
1977 WHEN OTHERS THEN
1978
1979 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1980
1981 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1982 THEN
1983 FND_MSG_PUB.Add_Exc_Msg
1984 ( G_PKG_NAME
1985 , 'Attributes'
1986 );
1987 END IF;
1988
1989 END Attributes;
1990
1991 -- Procedure Entity_Delete
1992
1993 PROCEDURE Entity_Delete
1994 ( x_return_status OUT NOCOPY VARCHAR2
1995
1996 , p_Line_Price_Attr_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type
1997 )
1998 IS
1999 l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2000 --
2001 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2002 --
2003 BEGIN
2004
2005 -- Validate entity delete.
2006 -- NULL;
2007 -- Done.
2008
2009 -- lkxu: modified to prevent the user from deleting OTA pricing context.
2010 IF OE_GLOBALS.EQUAL(p_Line_Price_Attr_rec.pricing_context,'OTA') THEN
2011 FND_MESSAGE.SET_NAME('ONT','ONT_OTA_DELETE_NOT_ALLOWED');
2012 OE_MSG_PUB.ADD;
2013 RAISE FND_API.G_EXC_ERROR;
2014 END IF;
2015
2016 x_return_status := l_return_status;
2017
2018 EXCEPTION
2019
2020 WHEN FND_API.G_EXC_ERROR THEN
2021
2022 x_return_status := FND_API.G_RET_STS_ERROR;
2023
2024 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2025
2026 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2027
2028 WHEN OTHERS THEN
2029
2030 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2031
2032 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2033 THEN
2034 FND_MSG_PUB.Add_Exc_Msg
2035 ( G_PKG_NAME
2036 , 'Entity_Delete'
2037 );
2038 END IF;
2039
2040 END Entity_Delete;
2041
2042 END OE_Validate_Line_PAttr;