[Home] [Help]
PACKAGE BODY: APPS.OE_VALIDATE_HEADER_PATTR
Source
1 PACKAGE BODY OE_Validate_Header_PAttr AS
2 /* $Header: OEXLHPAB.pls 120.1.12000000.3 2007/04/27 05:50:56 jisingh ship $ */
3
4 -- Global constant holding the package name
5
6 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Validate_Header_Pattr';
7
8 -- Procedure Entity
9
10 PROCEDURE Entity
11 ( x_return_status OUT NOCOPY VARCHAR2
12
13 , p_Header_Price_Attr_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
14 , p_old_Header_Price_Attr_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
15 := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
16 )
17 IS
18 l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
19 --
20 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
21 --
22 BEGIN
23
24 IF l_debug_level > 0 THEN
25 oe_debug_pub.add( 'ENTERING OE_VALIDATE_HEADER_PATTR.ENTITY' , 1 ) ;
26 END IF;
27
28 -- Check required attributes.
29
30 IF p_Header_Price_Attr_rec.order_price_attrib_id IS NULL
31 THEN
32
33 l_return_status := FND_API.G_RET_STS_ERROR;
34
35 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
36 THEN
37
38 FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
39 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','attribute1');
40 FND_MSG_PUB.Add;
41
42 END IF;
43
44 END IF;
45
46 --
47 -- Check rest of required attributes here.
48 --
49
50
51 -- Return Error if a required attribute is missing.
52
53 IF l_return_status = FND_API.G_RET_STS_ERROR THEN
54
55 RAISE FND_API.G_EXC_ERROR;
56
57 END IF;
58
59 --
60 -- Check conditionally required attributes here.
61 --
62
63
64 --
65 -- Validate attribute dependencies here.
66 --
67
68
69 -- Done validating entity
70
71 x_return_status := l_return_status;
72
73 IF l_debug_level > 0 THEN
74 oe_debug_pub.add( 'EXITING OE_VALIDATE_HEADER_PATTR.ENTITY' , 1 ) ;
75 END IF;
76 EXCEPTION
77
78 WHEN FND_API.G_EXC_ERROR THEN
79
80 x_return_status := FND_API.G_RET_STS_ERROR;
81
82 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
83
84 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
85
86 WHEN OTHERS THEN
87
88 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89
90 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
91 THEN
92 FND_MSG_PUB.Add_Exc_Msg
93 ( G_PKG_NAME
94 , 'Entity'
95 );
96 END IF;
97
98 END Entity;
99
100 -- Procedure Attributes
101
102 PROCEDURE Attributes
103 ( x_return_status OUT NOCOPY VARCHAR2
104
105 , p_Header_Price_Attr_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
106 , p_old_Header_Price_Attr_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
107 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
108 )
109 IS
110 l_column_prefix varchar2(20);
111 --
112 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
113 --
114 BEGIN
115
116 IF l_debug_level > 0 THEN
117 oe_debug_pub.add( 'ENTERING OE_VALIDATE_HEADER_PATTR.ATTRIBUTES' , 1 ) ;
118 END IF;
119 x_return_status := FND_API.G_RET_STS_SUCCESS;
120
121 -- Validate Line_Pricing_PAttr attributes
122
123 IF p_Header_Price_Attr_rec.created_by IS NOT NULL AND
124 ( p_Header_Price_Attr_rec.created_by <>
125 p_old_Header_Price_Attr_rec.created_by OR
126 p_old_Header_Price_Attr_rec.created_by IS NULL )
127 THEN
128 IF NOT OE_Validate_Adj.Created_By(p_Header_Price_Attr_rec.created_by) THEN
129 x_return_status := FND_API.G_RET_STS_ERROR;
130 END IF;
131 END IF;
132
133 IF p_Header_Price_Attr_rec.creation_date IS NOT NULL AND
134 ( p_Header_Price_Attr_rec.creation_date <>
135 p_old_Header_Price_Attr_rec.creation_date OR
136 p_old_Header_Price_Attr_rec.creation_date IS NULL )
137 THEN
138 IF NOT OE_Validate_Adj.Creation_Date
139 (p_Header_Price_Attr_rec.creation_date) THEN
140 x_return_status := FND_API.G_RET_STS_ERROR;
141 END IF;
142 END IF;
143
144 IF p_Header_Price_Attr_rec.flex_title IS NOT NULL AND
145 ( p_Header_Price_Attr_rec.flex_title <>
146 p_old_Header_Price_Attr_rec.flex_title OR
147 p_old_Header_Price_Attr_rec.flex_title IS NULL )
148 THEN
149 IF NOT OE_Validate_Adj.Flex_Title
150 (p_Header_Price_Attr_rec.flex_title) THEN
151 x_return_status := FND_API.G_RET_STS_ERROR;
152 END IF;
153 END IF;
154
155 IF p_Header_Price_Attr_rec.header_id IS NOT NULL AND
156 ( p_Header_Price_Attr_rec.header_id <>
157 p_old_Header_Price_Attr_rec.header_id OR
158 p_old_Header_Price_Attr_rec.header_id IS NULL )
159 THEN
160 IF NOT OE_Validate_Adj.Header(p_Header_Price_Attr_rec.header_id) THEN
161 x_return_status := FND_API.G_RET_STS_ERROR;
162 END IF;
163 END IF;
164
165 IF p_Header_Price_Attr_rec.last_updated_by IS NOT NULL AND
166 ( p_Header_Price_Attr_rec.last_updated_by <>
167 p_old_Header_Price_Attr_rec.last_updated_by OR
168 p_old_Header_Price_Attr_rec.last_updated_by IS NULL )
169 THEN
170 IF NOT OE_Validate_Adj.Last_Updated_By
171 (p_Header_Price_Attr_rec.last_updated_by) THEN
172 x_return_status := FND_API.G_RET_STS_ERROR;
173 END IF;
174 END IF;
175
176 IF p_Header_Price_Attr_rec.last_update_date IS NOT NULL AND
177 ( p_Header_Price_Attr_rec.last_update_date <>
178 p_old_Header_Price_Attr_rec.last_update_date OR
179 p_old_Header_Price_Attr_rec.last_update_date IS NULL )
180 THEN
181 IF NOT OE_Validate_Adj.Last_Update_Date
182 (p_Header_Price_Attr_rec.last_update_date) THEN
183 x_return_status := FND_API.G_RET_STS_ERROR;
184 END IF;
185 END IF;
186
187 IF p_Header_Price_Attr_rec.last_update_login IS NOT NULL AND
188 ( p_Header_Price_Attr_rec.last_update_login <>
189 p_old_Header_Price_Attr_rec.last_update_login OR
190 p_old_Header_Price_Attr_rec.last_update_login IS NULL )
191 THEN
192 IF NOT OE_Validate_Adj.Last_Update_Login
193 (p_Header_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_Header_Price_Attr_rec.override_flag IS NOT NULL AND
199 ( p_Header_Price_Attr_rec.override_flag <>
200 p_old_Header_Price_Attr_rec.override_flag OR
201 p_old_Header_Price_Attr_rec.override_flag IS NULL )
202 THEN
203 IF NOT OE_Validate_Adj.Override_Flag
204 (p_Header_Price_Attr_rec.override_flag) THEN
205 x_return_status := FND_API.G_RET_STS_ERROR;
206 END IF;
207 END IF;
208
209
210 IF p_Header_Price_Attr_rec.line_id IS NOT NULL AND
211 ( p_Header_Price_Attr_rec.line_id <>
212 p_old_Header_Price_Attr_rec.line_id OR
213 p_old_Header_Price_Attr_rec.line_id IS NULL )
214 THEN
215 IF NOT OE_Validate_Adj.Line(p_Header_Price_Attr_rec.line_id) THEN
216 x_return_status := FND_API.G_RET_STS_ERROR;
217 END IF;
218 END IF;
219
220 IF p_Header_Price_Attr_rec.order_price_attrib_id IS NOT NULL AND
221 ( p_Header_Price_Attr_rec.order_price_attrib_id <>
222 p_old_Header_Price_Attr_rec.order_price_attrib_id OR
223 p_old_Header_Price_Attr_rec.order_price_attrib_id IS NULL )
224 THEN
225 IF NOT OE_Validate_Adj.Order_Price_Attrib
226 (p_Header_Price_Attr_rec.order_price_attrib_id) THEN
227 x_return_status := FND_API.G_RET_STS_ERROR;
228 END IF;
229 END IF;
230
231 IF p_Header_Price_Attr_rec.program_application_id IS NOT NULL AND
232 ( p_Header_Price_Attr_rec.program_application_id <>
233 p_old_Header_Price_Attr_rec.program_application_id OR
234 p_old_Header_Price_Attr_rec.program_application_id IS NULL )
235 THEN
236 IF NOT OE_Validate_Adj.Program_Application
237 (p_Header_Price_Attr_rec.program_application_id) THEN
238 x_return_status := FND_API.G_RET_STS_ERROR;
239 END IF;
240 END IF;
241
242 IF p_Header_Price_Attr_rec.program_id IS NOT NULL AND
243 ( p_Header_Price_Attr_rec.program_id <>
244 p_old_Header_Price_Attr_rec.program_id OR
245 p_old_Header_Price_Attr_rec.program_id IS NULL )
246 THEN
247 IF NOT OE_Validate_Adj.Program
248 (p_Header_Price_Attr_rec.program_id) THEN
249 x_return_status := FND_API.G_RET_STS_ERROR;
250 END IF;
251 END IF;
252
253 IF p_Header_Price_Attr_rec.program_update_date IS NOT NULL AND
254 ( p_Header_Price_Attr_rec.program_update_date <>
255 p_old_Header_Price_Attr_rec.program_update_date OR
256 p_old_Header_Price_Attr_rec.program_update_date IS NULL )
257 THEN
258 IF NOT OE_Validate_Adj.Program_Update_Date
259 (p_Header_Price_Attr_rec.program_update_date) THEN
260 x_return_status := FND_API.G_RET_STS_ERROR;
261 END IF;
262 END IF;
263
264 IF p_Header_Price_Attr_rec.request_id IS NOT NULL AND
265 ( p_Header_Price_Attr_rec.request_id <>
266 p_old_Header_Price_Attr_rec.request_id OR
267 p_old_Header_Price_Attr_rec.request_id IS NULL )
268 THEN
269 IF NOT OE_Validate_Adj.Request
270 (p_Header_Price_Attr_rec.request_id) THEN
271 x_return_status := FND_API.G_RET_STS_ERROR;
272 END IF;
273 END IF;
274 if OE_GLOBALS.g_validate_desc_flex ='Y' then --4343612
275 oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Header_PAttr.attributes ',1);
276 IF (p_Header_Price_Attr_rec.attribute1 IS NOT NULL AND
277 ( p_Header_Price_Attr_rec.attribute1 <>
278 p_old_Header_Price_Attr_rec.attribute1 OR
279 p_old_Header_Price_Attr_rec.attribute1 IS NULL ))
280 OR (p_Header_Price_Attr_rec.attribute10 IS NOT NULL AND
281 ( p_Header_Price_Attr_rec.attribute10 <>
282 p_old_Header_Price_Attr_rec.attribute10 OR
283 p_old_Header_Price_Attr_rec.attribute10 IS NULL ))
284 OR (p_Header_Price_Attr_rec.attribute11 IS NOT NULL AND
285 ( p_Header_Price_Attr_rec.attribute11 <>
286 p_old_Header_Price_Attr_rec.attribute11 OR
287 p_old_Header_Price_Attr_rec.attribute11 IS NULL ))
288 OR (p_Header_Price_Attr_rec.attribute12 IS NOT NULL AND
289 ( p_Header_Price_Attr_rec.attribute12 <>
290 p_old_Header_Price_Attr_rec.attribute12 OR
291 p_old_Header_Price_Attr_rec.attribute12 IS NULL ))
292 OR (p_Header_Price_Attr_rec.attribute13 IS NOT NULL AND
293 ( p_Header_Price_Attr_rec.attribute13 <>
294 p_old_Header_Price_Attr_rec.attribute13 OR
295 p_old_Header_Price_Attr_rec.attribute13 IS NULL ))
296 OR (p_Header_Price_Attr_rec.attribute14 IS NOT NULL AND
297 ( p_Header_Price_Attr_rec.attribute14 <>
298 p_old_Header_Price_Attr_rec.attribute14 OR
299 p_old_Header_Price_Attr_rec.attribute14 IS NULL ))
300 OR (p_Header_Price_Attr_rec.attribute15 IS NOT NULL AND
301 ( p_Header_Price_Attr_rec.attribute15 <>
302 p_old_Header_Price_Attr_rec.attribute15 OR
303 p_old_Header_Price_Attr_rec.attribute15 IS NULL ))
304 OR (p_Header_Price_Attr_rec.attribute2 IS NOT NULL AND
305 ( p_Header_Price_Attr_rec.attribute2 <>
306 p_old_Header_Price_Attr_rec.attribute2 OR
307 p_old_Header_Price_Attr_rec.attribute2 IS NULL ))
308 OR (p_Header_Price_Attr_rec.attribute3 IS NOT NULL AND
309 ( p_Header_Price_Attr_rec.attribute3 <>
310 p_old_Header_Price_Attr_rec.attribute3 OR
311 p_old_Header_Price_Attr_rec.attribute3 IS NULL ))
312 OR (p_Header_Price_Attr_rec.attribute4 IS NOT NULL AND
313 ( p_Header_Price_Attr_rec.attribute4 <>
314 p_old_Header_Price_Attr_rec.attribute4 OR
315 p_old_Header_Price_Attr_rec.attribute4 IS NULL ))
316 OR (p_Header_Price_Attr_rec.attribute5 IS NOT NULL AND
317 ( p_Header_Price_Attr_rec.attribute5 <>
318 p_old_Header_Price_Attr_rec.attribute5 OR
319 p_old_Header_Price_Attr_rec.attribute5 IS NULL ))
320 OR (p_Header_Price_Attr_rec.attribute6 IS NOT NULL AND
321 ( p_Header_Price_Attr_rec.attribute6 <>
322 p_old_Header_Price_Attr_rec.attribute6 OR
323 p_old_Header_Price_Attr_rec.attribute6 IS NULL ))
324 OR (p_Header_Price_Attr_rec.attribute7 IS NOT NULL AND
325 ( p_Header_Price_Attr_rec.attribute7 <>
326 p_old_Header_Price_Attr_rec.attribute7 OR
327 p_old_Header_Price_Attr_rec.attribute7 IS NULL ))
328 OR (p_Header_Price_Attr_rec.attribute8 IS NOT NULL AND
329 ( p_Header_Price_Attr_rec.attribute8 <>
330 p_old_Header_Price_Attr_rec.attribute8 OR
331 p_old_Header_Price_Attr_rec.attribute8 IS NULL ))
332 OR (p_Header_Price_Attr_rec.attribute9 IS NOT NULL AND
333 ( p_Header_Price_Attr_rec.attribute9 <>
334 p_old_Header_Price_Attr_rec.attribute9 OR
335 p_old_Header_Price_Attr_rec.attribute9 IS NULL ))
336 OR (p_Header_Price_Attr_rec.context IS NOT NULL AND
337 ( p_Header_Price_Attr_rec.context <>
338 p_old_Header_Price_Attr_rec.context OR
339 p_old_Header_Price_Attr_rec.context IS NULL ))
340 THEN
341
342
343
344 FND_FLEX_DESCVAL.Set_Column_Value
345 ( column_name => 'ATTRIBUTE1'
346 , column_value => p_Header_Price_Attr_rec.attribute1
347 );
348 FND_FLEX_DESCVAL.Set_Column_Value
349 ( column_name => 'ATTRIBUTE10'
350 , column_value => p_Header_Price_Attr_rec.attribute10
351 );
352 FND_FLEX_DESCVAL.Set_Column_Value
353 ( column_name => 'ATTRIBUTE11'
354 , column_value => p_Header_Price_Attr_rec.attribute11
355 );
356 FND_FLEX_DESCVAL.Set_Column_Value
357 ( column_name => 'ATTRIBUTE12'
358 , column_value => p_Header_Price_Attr_rec.attribute12
359 );
360 FND_FLEX_DESCVAL.Set_Column_Value
361 ( column_name => 'ATTRIBUTE13'
362 , column_value => p_Header_Price_Attr_rec.attribute13
363 );
364 FND_FLEX_DESCVAL.Set_Column_Value
365 ( column_name => 'ATTRIBUTE14'
366 , column_value => p_Header_Price_Attr_rec.attribute14
367 );
368 FND_FLEX_DESCVAL.Set_Column_Value
369 ( column_name => 'ATTRIBUTE15'
370 , column_value => p_Header_Price_Attr_rec.attribute15
371 );
372 FND_FLEX_DESCVAL.Set_Column_Value
373 ( column_name => 'ATTRIBUTE2'
374 , column_value => p_Header_Price_Attr_rec.attribute2
375 );
376 FND_FLEX_DESCVAL.Set_Column_Value
377 ( column_name => 'ATTRIBUTE3'
378 , column_value => p_Header_Price_Attr_rec.attribute3
379 );
380 FND_FLEX_DESCVAL.Set_Column_Value
381 ( column_name => 'ATTRIBUTE4'
382 , column_value => p_Header_Price_Attr_rec.attribute4
383 );
384 FND_FLEX_DESCVAL.Set_Column_Value
385 ( column_name => 'ATTRIBUTE5'
386 , column_value => p_Header_Price_Attr_rec.attribute5
387 );
388 FND_FLEX_DESCVAL.Set_Column_Value
389 ( column_name => 'ATTRIBUTE6'
390 , column_value => p_Header_Price_Attr_rec.attribute6
391 );
392 FND_FLEX_DESCVAL.Set_Column_Value
393 ( column_name => 'ATTRIBUTE7'
394 , column_value => p_Header_Price_Attr_rec.attribute7
395 );
396 FND_FLEX_DESCVAL.Set_Column_Value
397 ( column_name => 'ATTRIBUTE8'
398 , column_value => p_Header_Price_Attr_rec.attribute8
399 );
400 FND_FLEX_DESCVAL.Set_Column_Value
401 ( column_name => 'ATTRIBUTE9'
402 , column_value => p_Header_Price_Attr_rec.attribute9
403 );
404 FND_FLEX_DESCVAL.Set_Column_Value
405 ( column_name => 'CONTEXT'
406 , column_value => p_Header_Price_Attr_rec.context
407 );
408
409
410 END IF;
411
412 IF (p_Header_Price_Attr_rec.pricing_attribute1 IS NOT NULL AND
413 ( p_Header_Price_Attr_rec.pricing_attribute1 <>
414 p_old_Header_Price_Attr_rec.pricing_attribute1 OR
415 p_old_Header_Price_Attr_rec.pricing_attribute1 IS NULL ))
416 OR (p_Header_Price_Attr_rec.pricing_attribute2 IS NOT NULL AND
417 ( p_Header_Price_Attr_rec.pricing_attribute2 <>
418 p_old_Header_Price_Attr_rec.pricing_attribute2 OR
419 p_old_Header_Price_Attr_rec.pricing_attribute2 IS NULL ))
420 OR (p_Header_Price_Attr_rec.pricing_attribute3 IS NOT NULL AND
421 ( p_Header_Price_Attr_rec.pricing_attribute3 <>
422 p_old_Header_Price_Attr_rec.pricing_attribute3 OR
423 p_old_Header_Price_Attr_rec.pricing_attribute3 IS NULL ))
424 OR (p_Header_Price_Attr_rec.pricing_attribute4 IS NOT NULL AND
425 ( p_Header_Price_Attr_rec.pricing_attribute4 <>
426 p_old_Header_Price_Attr_rec.pricing_attribute4 OR
427 p_old_Header_Price_Attr_rec.pricing_attribute4 IS NULL ))
428 OR (p_Header_Price_Attr_rec.pricing_attribute5 IS NOT NULL AND
429 ( p_Header_Price_Attr_rec.pricing_attribute5 <>
430 p_old_Header_Price_Attr_rec.pricing_attribute5 OR
431 p_old_Header_Price_Attr_rec.pricing_attribute5 IS NULL ))
432 OR (p_Header_Price_Attr_rec.pricing_attribute6 IS NOT NULL AND
433 ( p_Header_Price_Attr_rec.pricing_attribute6 <>
434 p_old_Header_Price_Attr_rec.pricing_attribute6 OR
435 p_old_Header_Price_Attr_rec.pricing_attribute6 IS NULL ))
436 OR (p_Header_Price_Attr_rec.pricing_attribute7 IS NOT NULL AND
437 ( p_Header_Price_Attr_rec.pricing_attribute7 <>
438 p_old_Header_Price_Attr_rec.pricing_attribute7 OR
439 p_old_Header_Price_Attr_rec.pricing_attribute7 IS NULL ))
440 OR (p_Header_Price_Attr_rec.pricing_attribute8 IS NOT NULL AND
441 ( p_Header_Price_Attr_rec.pricing_attribute8 <>
442 p_old_Header_Price_Attr_rec.pricing_attribute8 OR
443 p_old_Header_Price_Attr_rec.pricing_attribute8 IS NULL ))
444 OR (p_Header_Price_Attr_rec.pricing_attribute9 IS NOT NULL AND
445 ( p_Header_Price_Attr_rec.pricing_attribute9 <>
446 p_old_Header_Price_Attr_rec.pricing_attribute9 OR
447 p_old_Header_Price_Attr_rec.pricing_attribute9 IS NULL ))
448 OR (p_Header_Price_Attr_rec.pricing_context IS NOT NULL AND
449 ( p_Header_Price_Attr_rec.pricing_context <>
450 p_old_Header_Price_Attr_rec.pricing_context OR
451 p_old_Header_Price_Attr_rec.pricing_context IS NULL ))
452 OR (p_Header_Price_Attr_rec.pricing_attribute10 IS NOT NULL AND
453 ( p_Header_Price_Attr_rec.pricing_attribute10 <>
454 p_old_Header_Price_Attr_rec.pricing_attribute10 OR
455 p_old_Header_Price_Attr_rec.pricing_attribute10 IS NULL ))
456 OR (p_Header_Price_Attr_rec.pricing_attribute11 IS NOT NULL AND
457 ( p_Header_Price_Attr_rec.pricing_attribute11 <>
458 p_old_Header_Price_Attr_rec.pricing_attribute11 OR
459 p_old_Header_Price_Attr_rec.pricing_attribute11 IS NULL ))
460 OR (p_Header_Price_Attr_rec.pricing_attribute12 IS NOT NULL AND
461 ( p_Header_Price_Attr_rec.pricing_attribute12 <>
462 p_old_Header_Price_Attr_rec.pricing_attribute12 OR
463 p_old_Header_Price_Attr_rec.pricing_attribute12 IS NULL ))
464 OR (p_Header_Price_Attr_rec.pricing_attribute13 IS NOT NULL AND
465 ( p_Header_Price_Attr_rec.pricing_attribute13 <>
466 p_old_Header_Price_Attr_rec.pricing_attribute13 OR
467 p_old_Header_Price_Attr_rec.pricing_attribute13 IS NULL ))
468 OR (p_Header_Price_Attr_rec.pricing_attribute14 IS NOT NULL AND
469 ( p_Header_Price_Attr_rec.pricing_attribute14 <>
470 p_old_Header_Price_Attr_rec.pricing_attribute14 OR
471 p_old_Header_Price_Attr_rec.pricing_attribute14 IS NULL ))
472 OR (p_Header_Price_Attr_rec.pricing_attribute15 IS NOT NULL AND
473 ( p_Header_Price_Attr_rec.pricing_attribute15 <>
474 p_old_Header_Price_Attr_rec.pricing_attribute15 OR
475 p_old_Header_Price_Attr_rec.pricing_attribute15 IS NULL ))
476 OR (p_Header_Price_Attr_rec.pricing_attribute16 IS NOT NULL AND
477 ( p_Header_Price_Attr_rec.pricing_attribute16 <>
478 p_old_Header_Price_Attr_rec.pricing_attribute16 OR
479 p_old_Header_Price_Attr_rec.pricing_attribute16 IS NULL ))
480 OR (p_Header_Price_Attr_rec.pricing_attribute17 IS NOT NULL AND
481 ( p_Header_Price_Attr_rec.pricing_attribute17 <>
482 p_old_Header_Price_Attr_rec.pricing_attribute17 OR
483 p_old_Header_Price_Attr_rec.pricing_attribute17 IS NULL ))
484 OR (p_Header_Price_Attr_rec.pricing_attribute18 IS NOT NULL AND
485 ( p_Header_Price_Attr_rec.pricing_attribute18 <>
486 p_old_Header_Price_Attr_rec.pricing_attribute18 OR
487 p_old_Header_Price_Attr_rec.pricing_attribute18 IS NULL ))
488 OR (p_Header_Price_Attr_rec.pricing_attribute19 IS NOT NULL AND
489 ( p_Header_Price_Attr_rec.pricing_attribute19 <>
490 p_old_Header_Price_Attr_rec.pricing_attribute19 OR
491 p_old_Header_Price_Attr_rec.pricing_attribute19 IS NULL ))
492 OR (p_Header_Price_Attr_rec.pricing_attribute20 IS NOT NULL AND
493 ( p_Header_Price_Attr_rec.pricing_attribute20 <>
494 p_old_Header_Price_Attr_rec.pricing_attribute20 OR
495 p_old_Header_Price_Attr_rec.pricing_attribute20 IS NULL ))
496 OR (p_Header_Price_Attr_rec.pricing_attribute21 IS NOT NULL AND
497 ( p_Header_Price_Attr_rec.pricing_attribute21 <>
498 p_old_Header_Price_Attr_rec.pricing_attribute21 OR
499 p_old_Header_Price_Attr_rec.pricing_attribute21 IS NULL ))
500 OR (p_Header_Price_Attr_rec.pricing_attribute22 IS NOT NULL AND
501 ( p_Header_Price_Attr_rec.pricing_attribute22 <>
502 p_old_Header_Price_Attr_rec.pricing_attribute22 OR
503 p_old_Header_Price_Attr_rec.pricing_attribute22 IS NULL ))
504 OR (p_Header_Price_Attr_rec.pricing_attribute23 IS NOT NULL AND
505 ( p_Header_Price_Attr_rec.pricing_attribute23 <>
506 p_old_Header_Price_Attr_rec.pricing_attribute23 OR
507 p_old_Header_Price_Attr_rec.pricing_attribute23 IS NULL ))
508 OR (p_Header_Price_Attr_rec.pricing_attribute24 IS NOT NULL AND
509 ( p_Header_Price_Attr_rec.pricing_attribute24 <>
510 p_old_Header_Price_Attr_rec.pricing_attribute24 OR
511 p_old_Header_Price_Attr_rec.pricing_attribute24 IS NULL ))
512 OR (p_Header_Price_Attr_rec.pricing_attribute25 IS NOT NULL AND
513 ( p_Header_Price_Attr_rec.pricing_attribute25 <>
514 p_old_Header_Price_Attr_rec.pricing_attribute25 OR
515 p_old_Header_Price_Attr_rec.pricing_attribute25 IS NULL ))
516 OR (p_Header_Price_Attr_rec.pricing_attribute26 IS NOT NULL AND
517 ( p_Header_Price_Attr_rec.pricing_attribute26 <>
518 p_old_Header_Price_Attr_rec.pricing_attribute26 OR
519 p_old_Header_Price_Attr_rec.pricing_attribute26 IS NULL ))
520 OR (p_Header_Price_Attr_rec.pricing_attribute27 IS NOT NULL AND
521 ( p_Header_Price_Attr_rec.pricing_attribute27 <>
522 p_old_Header_Price_Attr_rec.pricing_attribute27 OR
523 p_old_Header_Price_Attr_rec.pricing_attribute27 IS NULL ))
524 OR (p_Header_Price_Attr_rec.pricing_attribute28 IS NOT NULL AND
525 ( p_Header_Price_Attr_rec.pricing_attribute28 <>
526 p_old_Header_Price_Attr_rec.pricing_attribute28 OR
527 p_old_Header_Price_Attr_rec.pricing_attribute28 IS NULL ))
528 OR (p_Header_Price_Attr_rec.pricing_attribute29 IS NOT NULL AND
529 ( p_Header_Price_Attr_rec.pricing_attribute29 <>
530 p_old_Header_Price_Attr_rec.pricing_attribute29 OR
531 p_old_Header_Price_Attr_rec.pricing_attribute29 IS NULL ))
532 OR (p_Header_Price_Attr_rec.pricing_attribute30 IS NOT NULL AND
533 ( p_Header_Price_Attr_rec.pricing_attribute30 <>
534 p_old_Header_Price_Attr_rec.pricing_attribute30 OR
535 p_old_Header_Price_Attr_rec.pricing_attribute30 IS NULL ))
536 OR (p_Header_Price_Attr_rec.pricing_attribute31 IS NOT NULL AND
537 ( p_Header_Price_Attr_rec.pricing_attribute31 <>
538 p_old_Header_Price_Attr_rec.pricing_attribute31 OR
539 p_old_Header_Price_Attr_rec.pricing_attribute31 IS NULL ))
540 OR (p_Header_Price_Attr_rec.pricing_attribute32 IS NOT NULL AND
541 ( p_Header_Price_Attr_rec.pricing_attribute32 <>
542 p_old_Header_Price_Attr_rec.pricing_attribute32 OR
543 p_old_Header_Price_Attr_rec.pricing_attribute32 IS NULL ))
544 OR (p_Header_Price_Attr_rec.pricing_attribute33 IS NOT NULL AND
545 ( p_Header_Price_Attr_rec.pricing_attribute33 <>
546 p_old_Header_Price_Attr_rec.pricing_attribute33 OR
547 p_old_Header_Price_Attr_rec.pricing_attribute33 IS NULL ))
548 OR (p_Header_Price_Attr_rec.pricing_attribute34 IS NOT NULL AND
549 ( p_Header_Price_Attr_rec.pricing_attribute34 <>
550 p_old_Header_Price_Attr_rec.pricing_attribute34 OR
551 p_old_Header_Price_Attr_rec.pricing_attribute34 IS NULL ))
552 OR (p_Header_Price_Attr_rec.pricing_attribute35 IS NOT NULL AND
553 ( p_Header_Price_Attr_rec.pricing_attribute35 <>
554 p_old_Header_Price_Attr_rec.pricing_attribute35 OR
555 p_old_Header_Price_Attr_rec.pricing_attribute35 IS NULL ))
556 OR (p_Header_Price_Attr_rec.pricing_attribute36 IS NOT NULL AND
557 ( p_Header_Price_Attr_rec.pricing_attribute36 <>
558 p_old_Header_Price_Attr_rec.pricing_attribute36 OR
559 p_old_Header_Price_Attr_rec.pricing_attribute36 IS NULL ))
560 OR (p_Header_Price_Attr_rec.pricing_attribute37 IS NOT NULL AND
561 ( p_Header_Price_Attr_rec.pricing_attribute37 <>
562 p_old_Header_Price_Attr_rec.pricing_attribute37 OR
563 p_old_Header_Price_Attr_rec.pricing_attribute37 IS NULL ))
564 OR (p_Header_Price_Attr_rec.pricing_attribute38 IS NOT NULL AND
565 ( p_Header_Price_Attr_rec.pricing_attribute38 <>
566 p_old_Header_Price_Attr_rec.pricing_attribute38 OR
567 p_old_Header_Price_Attr_rec.pricing_attribute38 IS NULL ))
568 OR (p_Header_Price_Attr_rec.pricing_attribute39 IS NOT NULL AND
569 ( p_Header_Price_Attr_rec.pricing_attribute39 <>
570 p_old_Header_Price_Attr_rec.pricing_attribute39 OR
571 p_old_Header_Price_Attr_rec.pricing_attribute39 IS NULL ))
572 OR (p_Header_Price_Attr_rec.pricing_attribute40 IS NOT NULL AND
573 ( p_Header_Price_Attr_rec.pricing_attribute40 <>
574 p_old_Header_Price_Attr_rec.pricing_attribute40 OR
575 p_old_Header_Price_Attr_rec.pricing_attribute40 IS NULL ))
576 OR (p_Header_Price_Attr_rec.pricing_attribute41 IS NOT NULL AND
577 ( p_Header_Price_Attr_rec.pricing_attribute41 <>
578 p_old_Header_Price_Attr_rec.pricing_attribute41 OR
579 p_old_Header_Price_Attr_rec.pricing_attribute41 IS NULL ))
580 OR (p_Header_Price_Attr_rec.pricing_attribute42 IS NOT NULL AND
581 ( p_Header_Price_Attr_rec.pricing_attribute42 <>
582 p_old_Header_Price_Attr_rec.pricing_attribute42 OR
583 p_old_Header_Price_Attr_rec.pricing_attribute42 IS NULL ))
584 OR (p_Header_Price_Attr_rec.pricing_attribute43 IS NOT NULL AND
585 ( p_Header_Price_Attr_rec.pricing_attribute43 <>
586 p_old_Header_Price_Attr_rec.pricing_attribute43 OR
587 p_old_Header_Price_Attr_rec.pricing_attribute43 IS NULL ))
588 OR (p_Header_Price_Attr_rec.pricing_attribute44 IS NOT NULL AND
589 ( p_Header_Price_Attr_rec.pricing_attribute44 <>
590 p_old_Header_Price_Attr_rec.pricing_attribute44 OR
591 p_old_Header_Price_Attr_rec.pricing_attribute44 IS NULL ))
592 OR (p_Header_Price_Attr_rec.pricing_attribute45 IS NOT NULL AND
593 ( p_Header_Price_Attr_rec.pricing_attribute45 <>
594 p_old_Header_Price_Attr_rec.pricing_attribute45 OR
595 p_old_Header_Price_Attr_rec.pricing_attribute45 IS NULL ))
596 OR (p_Header_Price_Attr_rec.pricing_attribute46 IS NOT NULL AND
597 ( p_Header_Price_Attr_rec.pricing_attribute46 <>
598 p_old_Header_Price_Attr_rec.pricing_attribute46 OR
599 p_old_Header_Price_Attr_rec.pricing_attribute46 IS NULL ))
600 OR (p_Header_Price_Attr_rec.pricing_attribute47 IS NOT NULL AND
601 ( p_Header_Price_Attr_rec.pricing_attribute47 <>
602 p_old_Header_Price_Attr_rec.pricing_attribute47 OR
603 p_old_Header_Price_Attr_rec.pricing_attribute47 IS NULL ))
604 OR (p_Header_Price_Attr_rec.pricing_attribute48 IS NOT NULL AND
605 ( p_Header_Price_Attr_rec.pricing_attribute48 <>
606 p_old_Header_Price_Attr_rec.pricing_attribute48 OR
607 p_old_Header_Price_Attr_rec.pricing_attribute48 IS NULL ))
608 OR (p_Header_Price_Attr_rec.pricing_attribute49 IS NOT NULL AND
609 ( p_Header_Price_Attr_rec.pricing_attribute49 <>
610 p_old_Header_Price_Attr_rec.pricing_attribute49 OR
611 p_old_Header_Price_Attr_rec.pricing_attribute49 IS NULL ))
612 OR (p_Header_Price_Attr_rec.pricing_attribute50 IS NOT NULL AND
613 ( p_Header_Price_Attr_rec.pricing_attribute50 <>
614 p_old_Header_Price_Attr_rec.pricing_attribute50 OR
615 p_old_Header_Price_Attr_rec.pricing_attribute50 IS NULL ))
616 OR (p_Header_Price_Attr_rec.pricing_attribute51 IS NOT NULL AND
617 ( p_Header_Price_Attr_rec.pricing_attribute51 <>
618 p_old_Header_Price_Attr_rec.pricing_attribute51 OR
619 p_old_Header_Price_Attr_rec.pricing_attribute51 IS NULL ))
620 OR (p_Header_Price_Attr_rec.pricing_attribute52 IS NOT NULL AND
621 ( p_Header_Price_Attr_rec.pricing_attribute52 <>
622 p_old_Header_Price_Attr_rec.pricing_attribute52 OR
623 p_old_Header_Price_Attr_rec.pricing_attribute52 IS NULL ))
624 OR (p_Header_Price_Attr_rec.pricing_attribute53 IS NOT NULL AND
625 ( p_Header_Price_Attr_rec.pricing_attribute53 <>
626 p_old_Header_Price_Attr_rec.pricing_attribute53 OR
627 p_old_Header_Price_Attr_rec.pricing_attribute53 IS NULL ))
628 OR (p_Header_Price_Attr_rec.pricing_attribute54 IS NOT NULL AND
629 ( p_Header_Price_Attr_rec.pricing_attribute54 <>
630 p_old_Header_Price_Attr_rec.pricing_attribute54 OR
631 p_old_Header_Price_Attr_rec.pricing_attribute54 IS NULL ))
632 OR (p_Header_Price_Attr_rec.pricing_attribute55 IS NOT NULL AND
633 ( p_Header_Price_Attr_rec.pricing_attribute55 <>
634 p_old_Header_Price_Attr_rec.pricing_attribute55 OR
635 p_old_Header_Price_Attr_rec.pricing_attribute55 IS NULL ))
636 OR (p_Header_Price_Attr_rec.pricing_attribute56 IS NOT NULL AND
637 ( p_Header_Price_Attr_rec.pricing_attribute56 <>
638 p_old_Header_Price_Attr_rec.pricing_attribute56 OR
639 p_old_Header_Price_Attr_rec.pricing_attribute56 IS NULL ))
640 OR (p_Header_Price_Attr_rec.pricing_attribute57 IS NOT NULL AND
641 ( p_Header_Price_Attr_rec.pricing_attribute57 <>
642 p_old_Header_Price_Attr_rec.pricing_attribute57 OR
643 p_old_Header_Price_Attr_rec.pricing_attribute57 IS NULL ))
644 OR (p_Header_Price_Attr_rec.pricing_attribute58 IS NOT NULL AND
645 ( p_Header_Price_Attr_rec.pricing_attribute58 <>
646 p_old_Header_Price_Attr_rec.pricing_attribute58 OR
647 p_old_Header_Price_Attr_rec.pricing_attribute58 IS NULL ))
648 OR (p_Header_Price_Attr_rec.pricing_attribute59 IS NOT NULL AND
649 ( p_Header_Price_Attr_rec.pricing_attribute59 <>
650 p_old_Header_Price_Attr_rec.pricing_attribute59 OR
651 p_old_Header_Price_Attr_rec.pricing_attribute59 IS NULL ))
652 OR (p_Header_Price_Attr_rec.pricing_attribute60 IS NOT NULL AND
653 ( p_Header_Price_Attr_rec.pricing_attribute60 <>
654 p_old_Header_Price_Attr_rec.pricing_attribute60 OR
655 p_old_Header_Price_Attr_rec.pricing_attribute60 IS NULL ))
656 OR (p_Header_Price_Attr_rec.pricing_attribute61 IS NOT NULL AND
657 ( p_Header_Price_Attr_rec.pricing_attribute61 <>
658 p_old_Header_Price_Attr_rec.pricing_attribute61 OR
659 p_old_Header_Price_Attr_rec.pricing_attribute61 IS NULL ))
660 OR (p_Header_Price_Attr_rec.pricing_attribute62 IS NOT NULL AND
661 ( p_Header_Price_Attr_rec.pricing_attribute62 <>
662 p_old_Header_Price_Attr_rec.pricing_attribute62 OR
663 p_old_Header_Price_Attr_rec.pricing_attribute62 IS NULL ))
664 OR (p_Header_Price_Attr_rec.pricing_attribute63 IS NOT NULL AND
665 ( p_Header_Price_Attr_rec.pricing_attribute63 <>
666 p_old_Header_Price_Attr_rec.pricing_attribute63 OR
667 p_old_Header_Price_Attr_rec.pricing_attribute63 IS NULL ))
668 OR (p_Header_Price_Attr_rec.pricing_attribute64 IS NOT NULL AND
669 ( p_Header_Price_Attr_rec.pricing_attribute64 <>
670 p_old_Header_Price_Attr_rec.pricing_attribute64 OR
671 p_old_Header_Price_Attr_rec.pricing_attribute64 IS NULL ))
672 OR (p_Header_Price_Attr_rec.pricing_attribute65 IS NOT NULL AND
673 ( p_Header_Price_Attr_rec.pricing_attribute65 <>
674 p_old_Header_Price_Attr_rec.pricing_attribute65 OR
675 p_old_Header_Price_Attr_rec.pricing_attribute65 IS NULL ))
676 OR (p_Header_Price_Attr_rec.pricing_attribute66 IS NOT NULL AND
677 ( p_Header_Price_Attr_rec.pricing_attribute66 <>
678 p_old_Header_Price_Attr_rec.pricing_attribute66 OR
679 p_old_Header_Price_Attr_rec.pricing_attribute66 IS NULL ))
680 OR (p_Header_Price_Attr_rec.pricing_attribute67 IS NOT NULL AND
681 ( p_Header_Price_Attr_rec.pricing_attribute67 <>
682 p_old_Header_Price_Attr_rec.pricing_attribute67 OR
683 p_old_Header_Price_Attr_rec.pricing_attribute67 IS NULL ))
684 OR (p_Header_Price_Attr_rec.pricing_attribute68 IS NOT NULL AND
685 ( p_Header_Price_Attr_rec.pricing_attribute68 <>
686 p_old_Header_Price_Attr_rec.pricing_attribute68 OR
687 p_old_Header_Price_Attr_rec.pricing_attribute68 IS NULL ))
688 OR (p_Header_Price_Attr_rec.pricing_attribute69 IS NOT NULL AND
689 ( p_Header_Price_Attr_rec.pricing_attribute69 <>
690 p_old_Header_Price_Attr_rec.pricing_attribute69 OR
691 p_old_Header_Price_Attr_rec.pricing_attribute69 IS NULL ))
692 OR (p_Header_Price_Attr_rec.pricing_attribute70 IS NOT NULL AND
693 ( p_Header_Price_Attr_rec.pricing_attribute70 <>
694 p_old_Header_Price_Attr_rec.pricing_attribute70 OR
695 p_old_Header_Price_Attr_rec.pricing_attribute70 IS NULL ))
696 OR (p_Header_Price_Attr_rec.pricing_attribute71 IS NOT NULL AND
697 ( p_Header_Price_Attr_rec.pricing_attribute71 <>
698 p_old_Header_Price_Attr_rec.pricing_attribute71 OR
699 p_old_Header_Price_Attr_rec.pricing_attribute71 IS NULL ))
700 OR (p_Header_Price_Attr_rec.pricing_attribute72 IS NOT NULL AND
701 ( p_Header_Price_Attr_rec.pricing_attribute72 <>
702 p_old_Header_Price_Attr_rec.pricing_attribute72 OR
703 p_old_Header_Price_Attr_rec.pricing_attribute72 IS NULL ))
704 OR (p_Header_Price_Attr_rec.pricing_attribute73 IS NOT NULL AND
705 ( p_Header_Price_Attr_rec.pricing_attribute73 <>
706 p_old_Header_Price_Attr_rec.pricing_attribute73 OR
707 p_old_Header_Price_Attr_rec.pricing_attribute73 IS NULL ))
708 OR (p_Header_Price_Attr_rec.pricing_attribute74 IS NOT NULL AND
709 ( p_Header_Price_Attr_rec.pricing_attribute74 <>
710 p_old_Header_Price_Attr_rec.pricing_attribute74 OR
711 p_old_Header_Price_Attr_rec.pricing_attribute74 IS NULL ))
712 OR (p_Header_Price_Attr_rec.pricing_attribute75 IS NOT NULL AND
713 ( p_Header_Price_Attr_rec.pricing_attribute75 <>
714 p_old_Header_Price_Attr_rec.pricing_attribute75 OR
715 p_old_Header_Price_Attr_rec.pricing_attribute75 IS NULL ))
716 OR (p_Header_Price_Attr_rec.pricing_attribute76 IS NOT NULL AND
717 ( p_Header_Price_Attr_rec.pricing_attribute76 <>
718 p_old_Header_Price_Attr_rec.pricing_attribute76 OR
719 p_old_Header_Price_Attr_rec.pricing_attribute76 IS NULL ))
720 OR (p_Header_Price_Attr_rec.pricing_attribute77 IS NOT NULL AND
721 ( p_Header_Price_Attr_rec.pricing_attribute77 <>
722 p_old_Header_Price_Attr_rec.pricing_attribute77 OR
723 p_old_Header_Price_Attr_rec.pricing_attribute77 IS NULL ))
724 OR (p_Header_Price_Attr_rec.pricing_attribute78 IS NOT NULL AND
725 ( p_Header_Price_Attr_rec.pricing_attribute78 <>
726 p_old_Header_Price_Attr_rec.pricing_attribute78 OR
727 p_old_Header_Price_Attr_rec.pricing_attribute78 IS NULL ))
728 OR (p_Header_Price_Attr_rec.pricing_attribute79 IS NOT NULL AND
729 ( p_Header_Price_Attr_rec.pricing_attribute79 <>
730 p_old_Header_Price_Attr_rec.pricing_attribute79 OR
731 p_old_Header_Price_Attr_rec.pricing_attribute79 IS NULL ))
732 OR (p_Header_Price_Attr_rec.pricing_attribute80 IS NOT NULL AND
733 ( p_Header_Price_Attr_rec.pricing_attribute80 <>
734 p_old_Header_Price_Attr_rec.pricing_attribute80 OR
735 p_old_Header_Price_Attr_rec.pricing_attribute80 IS NULL ))
736 OR (p_Header_Price_Attr_rec.pricing_attribute81 IS NOT NULL AND
737 ( p_Header_Price_Attr_rec.pricing_attribute81 <>
738 p_old_Header_Price_Attr_rec.pricing_attribute81 OR
739 p_old_Header_Price_Attr_rec.pricing_attribute81 IS NULL ))
740 OR (p_Header_Price_Attr_rec.pricing_attribute82 IS NOT NULL AND
741 ( p_Header_Price_Attr_rec.pricing_attribute82 <>
742 p_old_Header_Price_Attr_rec.pricing_attribute82 OR
743 p_old_Header_Price_Attr_rec.pricing_attribute82 IS NULL ))
744 OR (p_Header_Price_Attr_rec.pricing_attribute83 IS NOT NULL AND
745 ( p_Header_Price_Attr_rec.pricing_attribute83 <>
746 p_old_Header_Price_Attr_rec.pricing_attribute83 OR
747 p_old_Header_Price_Attr_rec.pricing_attribute83 IS NULL ))
748 OR (p_Header_Price_Attr_rec.pricing_attribute84 IS NOT NULL AND
749 ( p_Header_Price_Attr_rec.pricing_attribute84 <>
750 p_old_Header_Price_Attr_rec.pricing_attribute84 OR
751 p_old_Header_Price_Attr_rec.pricing_attribute84 IS NULL ))
752 OR (p_Header_Price_Attr_rec.pricing_attribute85 IS NOT NULL AND
753 ( p_Header_Price_Attr_rec.pricing_attribute85 <>
754 p_old_Header_Price_Attr_rec.pricing_attribute85 OR
755 p_old_Header_Price_Attr_rec.pricing_attribute85 IS NULL ))
756 OR (p_Header_Price_Attr_rec.pricing_attribute86 IS NOT NULL AND
757 ( p_Header_Price_Attr_rec.pricing_attribute86 <>
758 p_old_Header_Price_Attr_rec.pricing_attribute86 OR
759 p_old_Header_Price_Attr_rec.pricing_attribute86 IS NULL ))
760 OR (p_Header_Price_Attr_rec.pricing_attribute87 IS NOT NULL AND
761 ( p_Header_Price_Attr_rec.pricing_attribute87 <>
762 p_old_Header_Price_Attr_rec.pricing_attribute87 OR
763 p_old_Header_Price_Attr_rec.pricing_attribute87 IS NULL ))
764 OR (p_Header_Price_Attr_rec.pricing_attribute88 IS NOT NULL AND
765 ( p_Header_Price_Attr_rec.pricing_attribute88 <>
766 p_old_Header_Price_Attr_rec.pricing_attribute88 OR
767 p_old_Header_Price_Attr_rec.pricing_attribute88 IS NULL ))
768 OR (p_Header_Price_Attr_rec.pricing_attribute89 IS NOT NULL AND
769 ( p_Header_Price_Attr_rec.pricing_attribute89 <>
770 p_old_Header_Price_Attr_rec.pricing_attribute89 OR
771 p_old_Header_Price_Attr_rec.pricing_attribute89 IS NULL ))
772 OR (p_Header_Price_Attr_rec.pricing_attribute90 IS NOT NULL AND
773 ( p_Header_Price_Attr_rec.pricing_attribute90 <>
774 p_old_Header_Price_Attr_rec.pricing_attribute90 OR
775 p_old_Header_Price_Attr_rec.pricing_attribute90 IS NULL ))
776 OR (p_Header_Price_Attr_rec.pricing_attribute91 IS NOT NULL AND
777 ( p_Header_Price_Attr_rec.pricing_attribute91 <>
778 p_old_Header_Price_Attr_rec.pricing_attribute91 OR
779 p_old_Header_Price_Attr_rec.pricing_attribute91 IS NULL ))
780 OR (p_Header_Price_Attr_rec.pricing_attribute92 IS NOT NULL AND
781 ( p_Header_Price_Attr_rec.pricing_attribute92 <>
782 p_old_Header_Price_Attr_rec.pricing_attribute92 OR
783 p_old_Header_Price_Attr_rec.pricing_attribute92 IS NULL ))
784 OR (p_Header_Price_Attr_rec.pricing_attribute93 IS NOT NULL AND
785 ( p_Header_Price_Attr_rec.pricing_attribute93 <>
786 p_old_Header_Price_Attr_rec.pricing_attribute93 OR
787 p_old_Header_Price_Attr_rec.pricing_attribute93 IS NULL ))
788 OR (p_Header_Price_Attr_rec.pricing_attribute94 IS NOT NULL AND
789 ( p_Header_Price_Attr_rec.pricing_attribute94 <>
790 p_old_Header_Price_Attr_rec.pricing_attribute94 OR
791 p_old_Header_Price_Attr_rec.pricing_attribute94 IS NULL ))
792 OR (p_Header_Price_Attr_rec.pricing_attribute95 IS NOT NULL AND
793 ( p_Header_Price_Attr_rec.pricing_attribute95 <>
794 p_old_Header_Price_Attr_rec.pricing_attribute95 OR
795 p_old_Header_Price_Attr_rec.pricing_attribute95 IS NULL ))
796 OR (p_Header_Price_Attr_rec.pricing_attribute96 IS NOT NULL AND
797 ( p_Header_Price_Attr_rec.pricing_attribute96 <>
798 p_old_Header_Price_Attr_rec.pricing_attribute96 OR
799 p_old_Header_Price_Attr_rec.pricing_attribute96 IS NULL ))
800 OR (p_Header_Price_Attr_rec.pricing_attribute97 IS NOT NULL AND
801 ( p_Header_Price_Attr_rec.pricing_attribute97 <>
802 p_old_Header_Price_Attr_rec.pricing_attribute97 OR
803 p_old_Header_Price_Attr_rec.pricing_attribute97 IS NULL ))
804 OR (p_Header_Price_Attr_rec.pricing_attribute98 IS NOT NULL AND
805 ( p_Header_Price_Attr_rec.pricing_attribute98 <>
806 p_old_Header_Price_Attr_rec.pricing_attribute98 OR
807 p_old_Header_Price_Attr_rec.pricing_attribute98 IS NULL ))
808 OR (p_Header_Price_Attr_rec.pricing_attribute99 IS NOT NULL AND
809 ( p_Header_Price_Attr_rec.pricing_attribute99 <>
810 p_old_Header_Price_Attr_rec.pricing_attribute99 OR
811 p_old_Header_Price_Attr_rec.pricing_attribute99 IS NULL ))
812 OR (p_Header_Price_Attr_rec.pricing_attribute100 IS NOT NULL AND
813 ( p_Header_Price_Attr_rec.pricing_attribute100 <>
814 p_old_Header_Price_Attr_rec.pricing_attribute100 OR
815 p_old_Header_Price_Attr_rec.pricing_attribute100 IS NULL ))
816 THEN
817
818 -- These calls are temporarily commented out
819
820 if p_Header_Price_Attr_rec.flex_title='QP_ATTR_DEFNS_PRICING' then
821 l_column_prefix := 'PRICING';
822 else
823 l_column_prefix := 'QUALIFIER';
824 end if;
825
826
827 FND_FLEX_DESCVAL.Set_Column_Value
828 ( column_name => l_column_prefix||'_ATTRIBUTE1'
829 , column_value => p_Header_Price_Attr_rec.pricing_attribute1
830 );
831
832 FND_FLEX_DESCVAL.Set_Column_Value
833 ( column_name => l_column_prefix||'_ATTRIBUTE2'
834 , column_value => p_Header_Price_Attr_rec.pricing_attribute2
835 );
836 FND_FLEX_DESCVAL.Set_Column_Value
837 ( column_name => l_column_prefix||'_ATTRIBUTE3'
838 , column_value => p_Header_Price_Attr_rec.pricing_attribute3
839 );
840 FND_FLEX_DESCVAL.Set_Column_Value
841 ( column_name => l_column_prefix||'_ATTRIBUTE4'
842 , column_value => p_Header_Price_Attr_rec.pricing_attribute4
843 );
844 FND_FLEX_DESCVAL.Set_Column_Value
845 ( column_name => l_column_prefix||'_ATTRIBUTE5'
846 , column_value => p_Header_Price_Attr_rec.pricing_attribute5
847 );
848 FND_FLEX_DESCVAL.Set_Column_Value
849 ( column_name => l_column_prefix||'_ATTRIBUTE6'
850 , column_value => p_Header_Price_Attr_rec.pricing_attribute6
851 );
852 FND_FLEX_DESCVAL.Set_Column_Value
853 ( column_name => l_column_prefix||'_ATTRIBUTE7'
854 , column_value => p_Header_Price_Attr_rec.pricing_attribute7
855 );
856 FND_FLEX_DESCVAL.Set_Column_Value
857 ( column_name => l_column_prefix||'_ATTRIBUTE8'
858 , column_value => p_Header_Price_Attr_rec.pricing_attribute8
859 );
860 FND_FLEX_DESCVAL.Set_Column_Value
861 ( column_name => l_column_prefix||'_ATTRIBUTE9'
862 , column_value => p_Header_Price_Attr_rec.pricing_attribute9
863 );
864
865 -- fixed bug 1769612
866 /***
867 FND_FLEX_DESCVAL.Set_Column_Value
868 ( column_name => l_column_prefix||'_CONTEXT'
869 , column_value => p_Header_Price_Attr_rec.pricing_context
870 );
871 ***/
872
873 FND_FLEX_DESCVAL.Set_Column_Value
874 ( column_name => l_column_prefix||'_ATTRIBUTE10'
875 , column_value => p_Header_Price_Attr_rec.pricing_attribute10
876 );
877
878 FND_FLEX_DESCVAL.Set_Column_Value
879 ( column_name => l_column_prefix||'_ATTRIBUTE11'
880 , column_value => p_Header_Price_Attr_rec.pricing_attribute11
881 );
882 FND_FLEX_DESCVAL.Set_Column_Value
883 ( column_name => l_column_prefix||'_ATTRIBUTE12'
884 , column_value => p_Header_Price_Attr_rec.pricing_attribute12
885 );
886 FND_FLEX_DESCVAL.Set_Column_Value
887 ( column_name => l_column_prefix||'_ATTRIBUTE13'
888 , column_value => p_Header_Price_Attr_rec.pricing_attribute13
889 );
890 FND_FLEX_DESCVAL.Set_Column_Value
891 ( column_name => l_column_prefix||'_ATTRIBUTE14'
892 , column_value => p_Header_Price_Attr_rec.pricing_attribute14
893 );
894 FND_FLEX_DESCVAL.Set_Column_Value
895 ( column_name => l_column_prefix||'_ATTRIBUTE15'
896 , column_value => p_Header_Price_Attr_rec.pricing_attribute15
897 );
898 FND_FLEX_DESCVAL.Set_Column_Value
899 ( column_name => l_column_prefix||'_ATTRIBUTE16'
900 , column_value => p_Header_Price_Attr_rec.pricing_attribute16
901 );
902 FND_FLEX_DESCVAL.Set_Column_Value
903 ( column_name => l_column_prefix||'_ATTRIBUTE17'
904 , column_value => p_Header_Price_Attr_rec.pricing_attribute17
905 );
906 FND_FLEX_DESCVAL.Set_Column_Value
907 ( column_name => l_column_prefix||'_ATTRIBUTE18'
908 , column_value => p_Header_Price_Attr_rec.pricing_attribute18
909 );
910 FND_FLEX_DESCVAL.Set_Column_Value
911 ( column_name => l_column_prefix||'_ATTRIBUTE19'
912 , column_value => p_Header_Price_Attr_rec.pricing_attribute19
913 );
914 FND_FLEX_DESCVAL.Set_Column_Value
915 ( column_name => l_column_prefix||'_ATTRIBUTE20'
916 , column_value => p_Header_Price_Attr_rec.pricing_attribute20
917 );
918 FND_FLEX_DESCVAL.Set_Column_Value
919 ( column_name => l_column_prefix||'_ATTRIBUTE21'
920 , column_value => p_Header_Price_Attr_rec.pricing_attribute21
921 );
922 FND_FLEX_DESCVAL.Set_Column_Value
923 ( column_name => l_column_prefix||'_ATTRIBUTE22'
924 , column_value => p_Header_Price_Attr_rec.pricing_attribute22
925 );
926 FND_FLEX_DESCVAL.Set_Column_Value
927 ( column_name => l_column_prefix||'_ATTRIBUTE23'
928 , column_value => p_Header_Price_Attr_rec.pricing_attribute23
929 );
930 FND_FLEX_DESCVAL.Set_Column_Value
931 ( column_name => l_column_prefix||'_ATTRIBUTE24'
932 , column_value => p_Header_Price_Attr_rec.pricing_attribute24
933 );
934 FND_FLEX_DESCVAL.Set_Column_Value
935 ( column_name => l_column_prefix||'_ATTRIBUTE25'
936 , column_value => p_Header_Price_Attr_rec.pricing_attribute25
937 );
938 FND_FLEX_DESCVAL.Set_Column_Value
939 ( column_name => l_column_prefix||'_ATTRIBUTE26'
940 , column_value => p_Header_Price_Attr_rec.pricing_attribute26
941 );
942 FND_FLEX_DESCVAL.Set_Column_Value
943 ( column_name => l_column_prefix||'_ATTRIBUTE27'
944 , column_value => p_Header_Price_Attr_rec.pricing_attribute27
945 );
946 FND_FLEX_DESCVAL.Set_Column_Value
947 ( column_name => l_column_prefix||'_ATTRIBUTE28'
948 , column_value => p_Header_Price_Attr_rec.pricing_attribute28
949 );
950 FND_FLEX_DESCVAL.Set_Column_Value
951 ( column_name => l_column_prefix||'_ATTRIBUTE29'
952 , column_value => p_Header_Price_Attr_rec.pricing_attribute29
953 );
954 FND_FLEX_DESCVAL.Set_Column_Value
955 ( column_name => l_column_prefix||'_ATTRIBUTE30'
956 , column_value => p_Header_Price_Attr_rec.pricing_attribute30
957 );
958 FND_FLEX_DESCVAL.Set_Column_Value
959 ( column_name => l_column_prefix||'_ATTRIBUTE31'
960 , column_value => p_Header_Price_Attr_rec.pricing_attribute31
961 );
962 FND_FLEX_DESCVAL.Set_Column_Value
963 ( column_name => l_column_prefix||'_ATTRIBUTE32'
964 , column_value => p_Header_Price_Attr_rec.pricing_attribute32
965 );
966 FND_FLEX_DESCVAL.Set_Column_Value
967 ( column_name => l_column_prefix||'_ATTRIBUTE33'
968 , column_value => p_Header_Price_Attr_rec.pricing_attribute33
969 );
970 FND_FLEX_DESCVAL.Set_Column_Value
971 ( column_name => l_column_prefix||'_ATTRIBUTE34'
972 , column_value => p_Header_Price_Attr_rec.pricing_attribute34
973 );
974 FND_FLEX_DESCVAL.Set_Column_Value
975 ( column_name => l_column_prefix||'_ATTRIBUTE35'
976 , column_value => p_Header_Price_Attr_rec.pricing_attribute35
977 );
978 FND_FLEX_DESCVAL.Set_Column_Value
979 ( column_name => l_column_prefix||'_ATTRIBUTE36'
980 , column_value => p_Header_Price_Attr_rec.pricing_attribute36
981 );
982 FND_FLEX_DESCVAL.Set_Column_Value
983 ( column_name => l_column_prefix||'_ATTRIBUTE37'
984 , column_value => p_Header_Price_Attr_rec.pricing_attribute37
985 );
986 FND_FLEX_DESCVAL.Set_Column_Value
987 ( column_name => l_column_prefix||'_ATTRIBUTE38'
988 , column_value => p_Header_Price_Attr_rec.pricing_attribute38
989 );
990 FND_FLEX_DESCVAL.Set_Column_Value
991 ( column_name => l_column_prefix||'_ATTRIBUTE39'
992 , column_value => p_Header_Price_Attr_rec.pricing_attribute39
993 );
994 FND_FLEX_DESCVAL.Set_Column_Value
995 ( column_name => l_column_prefix||'_ATTRIBUTE40'
996 , column_value => p_Header_Price_Attr_rec.pricing_attribute40
997 );
998 FND_FLEX_DESCVAL.Set_Column_Value
999 ( column_name => l_column_prefix||'_ATTRIBUTE41'
1000 , column_value => p_Header_Price_Attr_rec.pricing_attribute41
1001 );
1002 FND_FLEX_DESCVAL.Set_Column_Value
1003 ( column_name => l_column_prefix||'_ATTRIBUTE42'
1004 , column_value => p_Header_Price_Attr_rec.pricing_attribute42
1005 );
1006 FND_FLEX_DESCVAL.Set_Column_Value
1007 ( column_name => l_column_prefix||'_ATTRIBUTE43'
1008 , column_value => p_Header_Price_Attr_rec.pricing_attribute43
1009 );
1010 FND_FLEX_DESCVAL.Set_Column_Value
1011 ( column_name => l_column_prefix||'_ATTRIBUTE44'
1012 , column_value => p_Header_Price_Attr_rec.pricing_attribute44
1013 );
1014 FND_FLEX_DESCVAL.Set_Column_Value
1015 ( column_name => l_column_prefix||'_ATTRIBUTE45'
1016 , column_value => p_Header_Price_Attr_rec.pricing_attribute45
1017 );
1018 FND_FLEX_DESCVAL.Set_Column_Value
1019 ( column_name => l_column_prefix||'_ATTRIBUTE46'
1020 , column_value => p_Header_Price_Attr_rec.pricing_attribute46
1021 );
1022 FND_FLEX_DESCVAL.Set_Column_Value
1023 ( column_name => l_column_prefix||'_ATTRIBUTE47'
1024 , column_value => p_Header_Price_Attr_rec.pricing_attribute47
1025 );
1026 FND_FLEX_DESCVAL.Set_Column_Value
1027 ( column_name => l_column_prefix||'_ATTRIBUTE48'
1028 , column_value => p_Header_Price_Attr_rec.pricing_attribute48
1029 );
1030 FND_FLEX_DESCVAL.Set_Column_Value
1031 ( column_name => l_column_prefix||'_ATTRIBUTE49'
1032 , column_value => p_Header_Price_Attr_rec.pricing_attribute49
1033 );
1034 FND_FLEX_DESCVAL.Set_Column_Value
1035 ( column_name => l_column_prefix||'_ATTRIBUTE50'
1036 , column_value => p_Header_Price_Attr_rec.pricing_attribute50
1037 );
1038 FND_FLEX_DESCVAL.Set_Column_Value
1039 ( column_name => l_column_prefix||'_ATTRIBUTE51'
1040 , column_value => p_Header_Price_Attr_rec.pricing_attribute51
1041 );
1042 FND_FLEX_DESCVAL.Set_Column_Value
1043 ( column_name => l_column_prefix||'_ATTRIBUTE52'
1044 , column_value => p_Header_Price_Attr_rec.pricing_attribute52
1045 );
1046 FND_FLEX_DESCVAL.Set_Column_Value
1047 ( column_name => l_column_prefix||'_ATTRIBUTE53'
1048 , column_value => p_Header_Price_Attr_rec.pricing_attribute53
1049 );
1050 FND_FLEX_DESCVAL.Set_Column_Value
1051 ( column_name => l_column_prefix||'_ATTRIBUTE54'
1052 , column_value => p_Header_Price_Attr_rec.pricing_attribute54
1053 );
1054 FND_FLEX_DESCVAL.Set_Column_Value
1055 ( column_name => l_column_prefix||'_ATTRIBUTE55'
1056 , column_value => p_Header_Price_Attr_rec.pricing_attribute55
1057 );
1058 FND_FLEX_DESCVAL.Set_Column_Value
1059 ( column_name => l_column_prefix||'_ATTRIBUTE56'
1060 , column_value => p_Header_Price_Attr_rec.pricing_attribute56
1061 );
1062 FND_FLEX_DESCVAL.Set_Column_Value
1063 ( column_name => l_column_prefix||'_ATTRIBUTE57'
1064 , column_value => p_Header_Price_Attr_rec.pricing_attribute57
1065 );
1066 FND_FLEX_DESCVAL.Set_Column_Value
1067 ( column_name => l_column_prefix||'_ATTRIBUTE58'
1068 , column_value => p_Header_Price_Attr_rec.pricing_attribute58
1069 );
1070 FND_FLEX_DESCVAL.Set_Column_Value
1071 ( column_name => l_column_prefix||'_ATTRIBUTE59'
1072 , column_value => p_Header_Price_Attr_rec.pricing_attribute59
1073 );
1074 FND_FLEX_DESCVAL.Set_Column_Value
1075 ( column_name => l_column_prefix||'_ATTRIBUTE60'
1076 , column_value => p_Header_Price_Attr_rec.pricing_attribute60
1077 );
1078 FND_FLEX_DESCVAL.Set_Column_Value
1079 ( column_name => l_column_prefix||'_ATTRIBUTE61'
1080 , column_value => p_Header_Price_Attr_rec.pricing_attribute61
1081 );
1082 FND_FLEX_DESCVAL.Set_Column_Value
1083 ( column_name => l_column_prefix||'_ATTRIBUTE62'
1084 , column_value => p_Header_Price_Attr_rec.pricing_attribute62
1085 );
1086 FND_FLEX_DESCVAL.Set_Column_Value
1087 ( column_name => l_column_prefix||'_ATTRIBUTE63'
1088 , column_value => p_Header_Price_Attr_rec.pricing_attribute63
1089 );
1090 FND_FLEX_DESCVAL.Set_Column_Value
1091 ( column_name => l_column_prefix||'_ATTRIBUTE64'
1092 , column_value => p_Header_Price_Attr_rec.pricing_attribute64
1093 );
1094 FND_FLEX_DESCVAL.Set_Column_Value
1095 ( column_name => l_column_prefix||'_ATTRIBUTE65'
1096 , column_value => p_Header_Price_Attr_rec.pricing_attribute65
1097 );
1098 FND_FLEX_DESCVAL.Set_Column_Value
1099 ( column_name => l_column_prefix||'_ATTRIBUTE66'
1100 , column_value => p_Header_Price_Attr_rec.pricing_attribute66
1101 );
1102 FND_FLEX_DESCVAL.Set_Column_Value
1103 ( column_name => l_column_prefix||'_ATTRIBUTE67'
1104 , column_value => p_Header_Price_Attr_rec.pricing_attribute67
1105 );
1106 FND_FLEX_DESCVAL.Set_Column_Value
1107 ( column_name => l_column_prefix||'_ATTRIBUTE68'
1108 , column_value => p_Header_Price_Attr_rec.pricing_attribute68
1109 );
1110 FND_FLEX_DESCVAL.Set_Column_Value
1111 ( column_name => l_column_prefix||'_ATTRIBUTE69'
1112 , column_value => p_Header_Price_Attr_rec.pricing_attribute69
1113 );
1114 FND_FLEX_DESCVAL.Set_Column_Value
1115 ( column_name => l_column_prefix||'_ATTRIBUTE70'
1116 , column_value => p_Header_Price_Attr_rec.pricing_attribute70
1117 );
1118 FND_FLEX_DESCVAL.Set_Column_Value
1119 ( column_name => l_column_prefix||'_ATTRIBUTE71'
1120 , column_value => p_Header_Price_Attr_rec.pricing_attribute71
1121 );
1122 FND_FLEX_DESCVAL.Set_Column_Value
1123 ( column_name => l_column_prefix||'_ATTRIBUTE72'
1124 , column_value => p_Header_Price_Attr_rec.pricing_attribute72
1125 );
1126 FND_FLEX_DESCVAL.Set_Column_Value
1127 ( column_name => l_column_prefix||'_ATTRIBUTE73'
1128 , column_value => p_Header_Price_Attr_rec.pricing_attribute73
1129 );
1130 FND_FLEX_DESCVAL.Set_Column_Value
1131 ( column_name => l_column_prefix||'_ATTRIBUTE74'
1132 , column_value => p_Header_Price_Attr_rec.pricing_attribute74
1133 );
1134 FND_FLEX_DESCVAL.Set_Column_Value
1135 ( column_name => l_column_prefix||'_ATTRIBUTE75'
1136 , column_value => p_Header_Price_Attr_rec.pricing_attribute75
1137 );
1138 FND_FLEX_DESCVAL.Set_Column_Value
1139 ( column_name => l_column_prefix||'_ATTRIBUTE76'
1140 , column_value => p_Header_Price_Attr_rec.pricing_attribute76
1141 );
1142 FND_FLEX_DESCVAL.Set_Column_Value
1143 ( column_name => l_column_prefix||'_ATTRIBUTE77'
1144 , column_value => p_Header_Price_Attr_rec.pricing_attribute77
1145 );
1146 FND_FLEX_DESCVAL.Set_Column_Value
1147 ( column_name => l_column_prefix||'_ATTRIBUTE78'
1148 , column_value => p_Header_Price_Attr_rec.pricing_attribute78
1149 );
1150 FND_FLEX_DESCVAL.Set_Column_Value
1151 ( column_name => l_column_prefix||'_ATTRIBUTE79'
1152 , column_value => p_Header_Price_Attr_rec.pricing_attribute79
1153 );
1154 FND_FLEX_DESCVAL.Set_Column_Value
1155 ( column_name => l_column_prefix||'_ATTRIBUTE80'
1156 , column_value => p_Header_Price_Attr_rec.pricing_attribute80
1157 );
1158 FND_FLEX_DESCVAL.Set_Column_Value
1159 ( column_name => l_column_prefix||'_ATTRIBUTE81'
1160 , column_value => p_Header_Price_Attr_rec.pricing_attribute81
1161 );
1162 FND_FLEX_DESCVAL.Set_Column_Value
1163 ( column_name => l_column_prefix||'_ATTRIBUTE82'
1164 , column_value => p_Header_Price_Attr_rec.pricing_attribute82
1165 );
1166 FND_FLEX_DESCVAL.Set_Column_Value
1167 ( column_name => l_column_prefix||'_ATTRIBUTE83'
1168 , column_value => p_Header_Price_Attr_rec.pricing_attribute83
1169 );
1170 FND_FLEX_DESCVAL.Set_Column_Value
1171 ( column_name => l_column_prefix||'_ATTRIBUTE84'
1172 , column_value => p_Header_Price_Attr_rec.pricing_attribute84
1173 );
1174 FND_FLEX_DESCVAL.Set_Column_Value
1175 ( column_name => l_column_prefix||'_ATTRIBUTE85'
1176 , column_value => p_Header_Price_Attr_rec.pricing_attribute85
1177 );
1178 FND_FLEX_DESCVAL.Set_Column_Value
1179 ( column_name => l_column_prefix||'_ATTRIBUTE86'
1180 , column_value => p_Header_Price_Attr_rec.pricing_attribute86
1181 );
1182 FND_FLEX_DESCVAL.Set_Column_Value
1183 ( column_name => l_column_prefix||'_ATTRIBUTE87'
1184 , column_value => p_Header_Price_Attr_rec.pricing_attribute87
1185 );
1186 FND_FLEX_DESCVAL.Set_Column_Value
1187 ( column_name => l_column_prefix||'_ATTRIBUTE88'
1188 , column_value => p_Header_Price_Attr_rec.pricing_attribute88
1189 );
1190 FND_FLEX_DESCVAL.Set_Column_Value
1191 ( column_name => l_column_prefix||'_ATTRIBUTE89'
1192 , column_value => p_Header_Price_Attr_rec.pricing_attribute89
1193 );
1194 FND_FLEX_DESCVAL.Set_Column_Value
1195 ( column_name => l_column_prefix||'_ATTRIBUTE90'
1196 , column_value => p_Header_Price_Attr_rec.pricing_attribute90
1197 );
1198 FND_FLEX_DESCVAL.Set_Column_Value
1199 ( column_name => l_column_prefix||'_ATTRIBUTE91'
1200 , column_value => p_Header_Price_Attr_rec.pricing_attribute91
1201 );
1202 FND_FLEX_DESCVAL.Set_Column_Value
1203 ( column_name => l_column_prefix||'_ATTRIBUTE92'
1204 , column_value => p_Header_Price_Attr_rec.pricing_attribute92
1205 );
1206 FND_FLEX_DESCVAL.Set_Column_Value
1207 ( column_name => l_column_prefix||'_ATTRIBUTE93'
1208 , column_value => p_Header_Price_Attr_rec.pricing_attribute93
1209 );
1210 FND_FLEX_DESCVAL.Set_Column_Value
1211 ( column_name => l_column_prefix||'_ATTRIBUTE94'
1212 , column_value => p_Header_Price_Attr_rec.pricing_attribute94
1213 );
1214 FND_FLEX_DESCVAL.Set_Column_Value
1215 ( column_name => l_column_prefix||'_ATTRIBUTE95'
1216 , column_value => p_Header_Price_Attr_rec.pricing_attribute95
1217 );
1218 FND_FLEX_DESCVAL.Set_Column_Value
1219 ( column_name => l_column_prefix||'_ATTRIBUTE96'
1220 , column_value => p_Header_Price_Attr_rec.pricing_attribute96
1221 );
1222 FND_FLEX_DESCVAL.Set_Column_Value
1223 ( column_name => l_column_prefix||'_ATTRIBUTE97'
1224 , column_value => p_Header_Price_Attr_rec.pricing_attribute97
1225 );
1226 FND_FLEX_DESCVAL.Set_Column_Value
1227 ( column_name => l_column_prefix||'_ATTRIBUTE98'
1228 , column_value => p_Header_Price_Attr_rec.pricing_attribute98
1229 );
1230 FND_FLEX_DESCVAL.Set_Column_Value
1231 ( column_name => l_column_prefix||'_ATTRIBUTE99'
1232 , column_value => p_Header_Price_Attr_rec.pricing_attribute99
1233 );
1234 FND_FLEX_DESCVAL.Set_Column_Value
1235 ( column_name => l_column_prefix||'_ATTRIBUTE100'
1236 , column_value => p_Header_Price_Attr_rec.pricing_attribute100
1237 );
1238
1239 -- bug 1769612
1240 FND_FLEX_DESCVAL.Set_Context_Value
1241 (
1242 context_value => p_Header_Price_Attr_rec.pricing_context
1243 );
1244
1245 -- Validate descriptive flexfield.
1246 /* commented for bug#5679839
1247 IF NOT OE_Validate_adj.Desc_Flex( 'QP', p_Header_Price_Attr_rec.Flex_Title )
1248 THEN
1249 x_return_status := FND_API.G_RET_STS_ERROR;
1250 END IF;
1251 */
1252 END IF;
1253 end if; -- bug4343612
1254 -- Done validating attributes
1255
1256 IF l_debug_level > 0 THEN
1257 oe_debug_pub.add( 'EXITING OE_VALIDATE_HEADER_PATTR.ATTRIBUTES' , 1 ) ;
1258 END IF;
1259 EXCEPTION
1260
1261 WHEN FND_API.G_EXC_ERROR THEN
1262
1263 x_return_status := FND_API.G_RET_STS_ERROR;
1264
1265 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1266
1267 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1268
1269 WHEN OTHERS THEN
1270
1271 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1272
1273 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1274 THEN
1275 FND_MSG_PUB.Add_Exc_Msg
1276 ( G_PKG_NAME
1277 , 'Attributes'
1278 );
1279 END IF;
1280
1281 END Attributes;
1282
1283 -- Procedure Entity_Delete
1284
1285 PROCEDURE Entity_Delete
1286 ( x_return_status OUT NOCOPY VARCHAR2
1287
1288 , p_Header_Price_Attr_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
1289 )
1290 IS
1291 l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1292 --
1293 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1294 --
1295 BEGIN
1296
1297 -- Validate entity delete.
1298
1299 NULL;
1300
1301 -- Done.
1302
1303 x_return_status := l_return_status;
1304
1305 EXCEPTION
1306
1307 WHEN FND_API.G_EXC_ERROR THEN
1308
1309 x_return_status := FND_API.G_RET_STS_ERROR;
1310
1311 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1312
1313 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1314
1315 WHEN OTHERS THEN
1316
1317 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1318
1319 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1320 THEN
1321 FND_MSG_PUB.Add_Exc_Msg
1322 ( G_PKG_NAME
1323 , 'Entity_Delete'
1324 );
1325 END IF;
1326
1327 END Entity_Delete;
1328
1329 END OE_Validate_Header_PAttr;