[Home] [Help]
PACKAGE BODY: APPS.OE_LINE_PATTR_UTIL
Source
1 PACKAGE BODY OE_Line_PAttr_Util AS
2 /* $Header: OEXULPAB.pls 120.1.12020000.2 2013/01/07 10:24:28 sujithku ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_OE_Form_Order_Line_PAttr';
5
6 PROCEDURE Query_Row
7 ( p_order_price_attrib_id IN NUMBER
8 , x_Line_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
9 )
10 IS
11 l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
12 BEGIN
13 Query_Rows
14 ( p_order_price_attrib_id => p_order_price_attrib_id
15 , x_Line_Price_Att_Tbl => l_Line_Price_Att_Tbl
16 );
17
18 x_Line_Price_Att_Rec := l_Line_Price_Att_Tbl(1);
19
20 END Query_Row;
21
22
23 PROCEDURE Query_Rows
24 ( p_order_price_attrib_id IN NUMBER :=
25 FND_API.G_MISS_NUM
26 , p_Line_id IN NUMBER :=
27 FND_API.G_MISS_NUM
28 , x_Line_Price_Att_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
29 )
30 IS
31 l_count NUMBER;
32
33 CURSOR l_Line_price_att_csr IS
34 SELECT
35 HEADER_ID
36 ,LINE_ID
37 ,CREATION_DATE
38 ,CREATED_BY
39 ,LAST_UPDATE_DATE
40 ,LAST_UPDATED_BY
41 ,LAST_UPDATE_LOGIN
42 ,PROGRAM_APPLICATION_ID
43 ,PROGRAM_ID
44 ,PROGRAM_UPDATE_DATE
45 ,REQUEST_ID
46 ,PRICING_CONTEXT
47 ,PRICING_ATTRIBUTE1
48 ,PRICING_ATTRIBUTE2
49 ,PRICING_ATTRIBUTE3
50 ,PRICING_ATTRIBUTE4
51 ,PRICING_ATTRIBUTE5
52 ,PRICING_ATTRIBUTE6
53 ,PRICING_ATTRIBUTE7
54 ,PRICING_ATTRIBUTE8
55 ,PRICING_ATTRIBUTE9
56 ,PRICING_ATTRIBUTE10
57 ,PRICING_ATTRIBUTE11
58 ,PRICING_ATTRIBUTE12
59 ,PRICING_ATTRIBUTE13
60 ,PRICING_ATTRIBUTE14
61 ,PRICING_ATTRIBUTE15
62 ,PRICING_ATTRIBUTE16
63 ,PRICING_ATTRIBUTE17
64 ,PRICING_ATTRIBUTE18
65 ,PRICING_ATTRIBUTE19
66 ,PRICING_ATTRIBUTE20
67 ,PRICING_ATTRIBUTE21
68 ,PRICING_ATTRIBUTE22
69 ,PRICING_ATTRIBUTE23
70 ,PRICING_ATTRIBUTE24
71 ,PRICING_ATTRIBUTE25
72 ,PRICING_ATTRIBUTE26
73 ,PRICING_ATTRIBUTE27
74 ,PRICING_ATTRIBUTE28
75 ,PRICING_ATTRIBUTE29
76 ,PRICING_ATTRIBUTE30
77 ,PRICING_ATTRIBUTE31
78 ,PRICING_ATTRIBUTE32
79 ,PRICING_ATTRIBUTE33
80 ,PRICING_ATTRIBUTE34
81 ,PRICING_ATTRIBUTE35
82 ,PRICING_ATTRIBUTE36
83 ,PRICING_ATTRIBUTE37
84 ,PRICING_ATTRIBUTE38
85 ,PRICING_ATTRIBUTE39
86 ,PRICING_ATTRIBUTE40
87 ,PRICING_ATTRIBUTE41
88 ,PRICING_ATTRIBUTE42
89 ,PRICING_ATTRIBUTE43
90 ,PRICING_ATTRIBUTE44
91 ,PRICING_ATTRIBUTE45
92 ,PRICING_ATTRIBUTE46
93 ,PRICING_ATTRIBUTE47
94 ,PRICING_ATTRIBUTE48
95 ,PRICING_ATTRIBUTE49
96 ,PRICING_ATTRIBUTE50
97 ,PRICING_ATTRIBUTE51
98 ,PRICING_ATTRIBUTE52
99 ,PRICING_ATTRIBUTE53
100 ,PRICING_ATTRIBUTE54
101 ,PRICING_ATTRIBUTE55
102 ,PRICING_ATTRIBUTE56
103 ,PRICING_ATTRIBUTE57
104 ,PRICING_ATTRIBUTE58
105 ,PRICING_ATTRIBUTE59
106 ,PRICING_ATTRIBUTE60
107 ,PRICING_ATTRIBUTE61
108 ,PRICING_ATTRIBUTE62
109 ,PRICING_ATTRIBUTE63
110 ,PRICING_ATTRIBUTE64
111 ,PRICING_ATTRIBUTE65
112 ,PRICING_ATTRIBUTE66
113 ,PRICING_ATTRIBUTE67
114 ,PRICING_ATTRIBUTE68
115 ,PRICING_ATTRIBUTE69
116 ,PRICING_ATTRIBUTE70
117 ,PRICING_ATTRIBUTE71
118 ,PRICING_ATTRIBUTE72
119 ,PRICING_ATTRIBUTE73
120 ,PRICING_ATTRIBUTE74
121 ,PRICING_ATTRIBUTE75
122 ,PRICING_ATTRIBUTE76
123 ,PRICING_ATTRIBUTE77
124 ,PRICING_ATTRIBUTE78
125 ,PRICING_ATTRIBUTE79
126 ,PRICING_ATTRIBUTE80
127 ,PRICING_ATTRIBUTE81
128 ,PRICING_ATTRIBUTE82
129 ,PRICING_ATTRIBUTE83
130 ,PRICING_ATTRIBUTE84
131 ,PRICING_ATTRIBUTE85
132 ,PRICING_ATTRIBUTE86
133 ,PRICING_ATTRIBUTE87
134 ,PRICING_ATTRIBUTE88
135 ,PRICING_ATTRIBUTE89
136 ,PRICING_ATTRIBUTE90
137 ,PRICING_ATTRIBUTE91
138 ,PRICING_ATTRIBUTE92
139 ,PRICING_ATTRIBUTE93
140 ,PRICING_ATTRIBUTE94
141 ,PRICING_ATTRIBUTE95
142 ,PRICING_ATTRIBUTE96
143 ,PRICING_ATTRIBUTE97
144 ,PRICING_ATTRIBUTE98
145 ,PRICING_ATTRIBUTE99
146 ,PRICING_ATTRIBUTE100
147 ,CONTEXT
148 ,ATTRIBUTE1
149 ,ATTRIBUTE2
150 ,ATTRIBUTE3
151 ,ATTRIBUTE4
152 ,ATTRIBUTE5
153 ,ATTRIBUTE6
154 ,ATTRIBUTE7
155 ,ATTRIBUTE8
156 ,ATTRIBUTE9
157 ,ATTRIBUTE10
158 ,ATTRIBUTE11
159 ,ATTRIBUTE12
160 ,ATTRIBUTE13
161 ,ATTRIBUTE14
162 ,ATTRIBUTE15
163 ,FLEX_TITLE
164 ,ORDER_PRICE_ATTRIB_ID
165 ,OVERRIDE_FLAG
166 ,LOCK_CONTROL
167 ,ORIG_SYS_ATTS_REF
168 FROM OE_ORDER_PRICE_ATTRIBS
169 WHERE ( ORDER_PRICE_ATTRIB_ID = p_order_price_attrib_id
170 Or line_id = p_Line_Id );
171
172
173
174 BEGIN
175
176 IF
177 (p_order_price_attrib_id IS NOT NULL
178 AND
179 p_order_price_attrib_id <> FND_API.G_MISS_NUM)
180 AND
181 (p_line_id IS NOT NULL
182 AND
183 p_line_id <> FND_API.G_MISS_NUM)
184 THEN
185
186 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
187 THEN
188 OE_MSG_PUB.Add_Exc_Msg
189 ( G_PKG_NAME
190 , 'Query Rows'
191 , 'Keys are mutually exclusive'
192 );
193 END IF;
194 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
195 END IF;
196
197 l_count := 1;
198 FOR imp_rec IN l_Line_price_att_csr LOOP
199
200 x_line_price_att_tbl(l_count).attribute1 := imp_rec.attribute1;
201 x_line_price_att_tbl(l_count).attribute2 := imp_rec.attribute2;
202 x_line_price_att_tbl(l_count).attribute3 := imp_rec.attribute3;
203 x_line_price_att_tbl(l_count).attribute4 := imp_rec.attribute4;
204 x_line_price_att_tbl(l_count).attribute5 := imp_rec.attribute5;
205 x_line_price_att_tbl(l_count).attribute6 := imp_rec.attribute6;
206 x_line_price_att_tbl(l_count).attribute7 := imp_rec.attribute7;
207 x_line_price_att_tbl(l_count).attribute8 := imp_rec.attribute8;
208 x_line_price_att_tbl(l_count).attribute9 := imp_rec.attribute9;
209 x_line_price_att_tbl(l_count).attribute10 := imp_rec.attribute10;
210
211
212 x_line_price_att_tbl(l_count).pricing_attribute1 := imp_rec.pricing_attribute1;
213 x_line_price_att_tbl(l_count).pricing_attribute2 := imp_rec.pricing_attribute2;
214 x_line_price_att_tbl(l_count).pricing_attribute3 := imp_rec.pricing_attribute3;
215 x_line_price_att_tbl(l_count).pricing_attribute4 := imp_rec.pricing_attribute4;
216 x_line_price_att_tbl(l_count).pricing_attribute5 := imp_rec.pricing_attribute5;
217 x_line_price_att_tbl(l_count).pricing_attribute6 := imp_rec.pricing_attribute6;
218 x_line_price_att_tbl(l_count).pricing_attribute7 := imp_rec.pricing_attribute7;
219 x_line_price_att_tbl(l_count).pricing_attribute8 := imp_rec.pricing_attribute8;
220 x_line_price_att_tbl(l_count).pricing_attribute9 := imp_rec.pricing_attribute9;
221 x_line_price_att_tbl(l_count).pricing_attribute10 := imp_rec.pricing_attribute10;
222
223 x_line_price_att_tbl(l_count).pricing_attribute11 := imp_rec.pricing_attribute11;
224 x_line_price_att_tbl(l_count).pricing_attribute12 := imp_rec.pricing_attribute12;
225 x_line_price_att_tbl(l_count).pricing_attribute13 := imp_rec.pricing_attribute13;
226 x_line_price_att_tbl(l_count).pricing_attribute14 := imp_rec.pricing_attribute14;
227 x_line_price_att_tbl(l_count).pricing_attribute15 := imp_rec.pricing_attribute15;
228 x_line_price_att_tbl(l_count).pricing_attribute16 := imp_rec.pricing_attribute16;
229 x_line_price_att_tbl(l_count).pricing_attribute17 := imp_rec.pricing_attribute17;
230 x_line_price_att_tbl(l_count).pricing_attribute18 := imp_rec.pricing_attribute18;
231 x_line_price_att_tbl(l_count).pricing_attribute19 := imp_rec.pricing_attribute19;
232 x_line_price_att_tbl(l_count).pricing_attribute20 := imp_rec.pricing_attribute20;
233
234 x_line_price_att_tbl(l_count).pricing_attribute21 := imp_rec.pricing_attribute21;
235 x_line_price_att_tbl(l_count).pricing_attribute22 := imp_rec.pricing_attribute22;
236 x_line_price_att_tbl(l_count).pricing_attribute23 := imp_rec.pricing_attribute23;
237 x_line_price_att_tbl(l_count).pricing_attribute24 := imp_rec.pricing_attribute24;
238 x_line_price_att_tbl(l_count).pricing_attribute25 := imp_rec.pricing_attribute25;
239 x_line_price_att_tbl(l_count).pricing_attribute26 := imp_rec.pricing_attribute26;
240 x_line_price_att_tbl(l_count).pricing_attribute27 := imp_rec.pricing_attribute27;
241 x_line_price_att_tbl(l_count).pricing_attribute28 := imp_rec.pricing_attribute28;
242 x_line_price_att_tbl(l_count).pricing_attribute29 := imp_rec.pricing_attribute29;
243 x_line_price_att_tbl(l_count).pricing_attribute30 := imp_rec.pricing_attribute30;
244
245 x_line_price_att_tbl(l_count).pricing_attribute31 := imp_rec.pricing_attribute31;
246 x_line_price_att_tbl(l_count).pricing_attribute32 := imp_rec.pricing_attribute32;
247 x_line_price_att_tbl(l_count).pricing_attribute33 := imp_rec.pricing_attribute33;
248 x_line_price_att_tbl(l_count).pricing_attribute34 := imp_rec.pricing_attribute34;
249 x_line_price_att_tbl(l_count).pricing_attribute35 := imp_rec.pricing_attribute35;
250 x_line_price_att_tbl(l_count).pricing_attribute36 := imp_rec.pricing_attribute36;
251 x_line_price_att_tbl(l_count).pricing_attribute37 := imp_rec.pricing_attribute37;
252 x_line_price_att_tbl(l_count).pricing_attribute38 := imp_rec.pricing_attribute38;
253 x_line_price_att_tbl(l_count).pricing_attribute39 := imp_rec.pricing_attribute39;
254 x_line_price_att_tbl(l_count).pricing_attribute40 := imp_rec.pricing_attribute40;
255
256
257 x_line_price_att_tbl(l_count).pricing_attribute41 := imp_rec.pricing_attribute41;
258 x_line_price_att_tbl(l_count).pricing_attribute42 := imp_rec.pricing_attribute42;
259 x_line_price_att_tbl(l_count).pricing_attribute43 := imp_rec.pricing_attribute43;
260 x_line_price_att_tbl(l_count).pricing_attribute44 := imp_rec.pricing_attribute44;
261 x_line_price_att_tbl(l_count).pricing_attribute45 := imp_rec.pricing_attribute45;
262 x_line_price_att_tbl(l_count).pricing_attribute46 := imp_rec.pricing_attribute46;
263 x_line_price_att_tbl(l_count).pricing_attribute47 := imp_rec.pricing_attribute47;
264 x_line_price_att_tbl(l_count).pricing_attribute48 := imp_rec.pricing_attribute48;
265 x_line_price_att_tbl(l_count).pricing_attribute49 := imp_rec.pricing_attribute49;
266 x_line_price_att_tbl(l_count).pricing_attribute50 := imp_rec.pricing_attribute50;
267
268
269 x_line_price_att_tbl(l_count).pricing_attribute51 := imp_rec.pricing_attribute51;
270 x_line_price_att_tbl(l_count).pricing_attribute52 := imp_rec.pricing_attribute52;
271 x_line_price_att_tbl(l_count).pricing_attribute53 := imp_rec.pricing_attribute53;
272 x_line_price_att_tbl(l_count).pricing_attribute54 := imp_rec.pricing_attribute54;
273 x_line_price_att_tbl(l_count).pricing_attribute55 := imp_rec.pricing_attribute55;
274 x_line_price_att_tbl(l_count).pricing_attribute56 := imp_rec.pricing_attribute56;
275 x_line_price_att_tbl(l_count).pricing_attribute57 := imp_rec.pricing_attribute57;
276 x_line_price_att_tbl(l_count).pricing_attribute58 := imp_rec.pricing_attribute58;
277 x_line_price_att_tbl(l_count).pricing_attribute59 := imp_rec.pricing_attribute59;
278 x_line_price_att_tbl(l_count).pricing_attribute60 := imp_rec.pricing_attribute60;
279
280 x_line_price_att_tbl(l_count).pricing_attribute61 := imp_rec.pricing_attribute61;
281 x_line_price_att_tbl(l_count).pricing_attribute62 := imp_rec.pricing_attribute62;
282 x_line_price_att_tbl(l_count).pricing_attribute63 := imp_rec.pricing_attribute63;
283 x_line_price_att_tbl(l_count).pricing_attribute64 := imp_rec.pricing_attribute64;
284 x_line_price_att_tbl(l_count).pricing_attribute65 := imp_rec.pricing_attribute65;
285 x_line_price_att_tbl(l_count).pricing_attribute66 := imp_rec.pricing_attribute66;
286 x_line_price_att_tbl(l_count).pricing_attribute67 := imp_rec.pricing_attribute67;
287 x_line_price_att_tbl(l_count).pricing_attribute68 := imp_rec.pricing_attribute68;
288 x_line_price_att_tbl(l_count).pricing_attribute69 := imp_rec.pricing_attribute69;
289 x_line_price_att_tbl(l_count).pricing_attribute70 := imp_rec.pricing_attribute70;
290
291 x_line_price_att_tbl(l_count).pricing_attribute71 := imp_rec.pricing_attribute71;
292 x_line_price_att_tbl(l_count).pricing_attribute72 := imp_rec.pricing_attribute72;
293 x_line_price_att_tbl(l_count).pricing_attribute73 := imp_rec.pricing_attribute73;
294 x_line_price_att_tbl(l_count).pricing_attribute74 := imp_rec.pricing_attribute74;
295 x_line_price_att_tbl(l_count).pricing_attribute75 := imp_rec.pricing_attribute75;
296 x_line_price_att_tbl(l_count).pricing_attribute76 := imp_rec.pricing_attribute76;
297 x_line_price_att_tbl(l_count).pricing_attribute77 := imp_rec.pricing_attribute77;
298 x_line_price_att_tbl(l_count).pricing_attribute78 := imp_rec.pricing_attribute78;
299 x_line_price_att_tbl(l_count).pricing_attribute79 := imp_rec.pricing_attribute79;
300 x_line_price_att_tbl(l_count).pricing_attribute80 := imp_rec.pricing_attribute80;
301
302
303 x_line_price_att_tbl(l_count).pricing_attribute81 := imp_rec.pricing_attribute81;
304 x_line_price_att_tbl(l_count).pricing_attribute82 := imp_rec.pricing_attribute82;
305 x_line_price_att_tbl(l_count).pricing_attribute83 := imp_rec.pricing_attribute83;
306 x_line_price_att_tbl(l_count).pricing_attribute84 := imp_rec.pricing_attribute84;
307 x_line_price_att_tbl(l_count).pricing_attribute85 := imp_rec.pricing_attribute85;
308 x_line_price_att_tbl(l_count).pricing_attribute86 := imp_rec.pricing_attribute86;
309 x_line_price_att_tbl(l_count).pricing_attribute87 := imp_rec.pricing_attribute87;
310 x_line_price_att_tbl(l_count).pricing_attribute88 := imp_rec.pricing_attribute88;
311 x_line_price_att_tbl(l_count).pricing_attribute89 := imp_rec.pricing_attribute89;
312 x_line_price_att_tbl(l_count).pricing_attribute90 := imp_rec.pricing_attribute90;
313
314
315 x_line_price_att_tbl(l_count).pricing_attribute91 := imp_rec.pricing_attribute91;
316 x_line_price_att_tbl(l_count).pricing_attribute92 := imp_rec.pricing_attribute92;
317 x_line_price_att_tbl(l_count).pricing_attribute93 := imp_rec.pricing_attribute93;
318 x_line_price_att_tbl(l_count).pricing_attribute94 := imp_rec.pricing_attribute94;
319 x_line_price_att_tbl(l_count).pricing_attribute95 := imp_rec.pricing_attribute95;
320 x_line_price_att_tbl(l_count).pricing_attribute96 := imp_rec.pricing_attribute96;
321 x_line_price_att_tbl(l_count).pricing_attribute97 := imp_rec.pricing_attribute97;
322 x_line_price_att_tbl(l_count).pricing_attribute98 := imp_rec.pricing_attribute98;
323 x_line_price_att_tbl(l_count).pricing_attribute99 := imp_rec.pricing_attribute99;
324 x_line_price_att_tbl(l_count).pricing_attribute100 := imp_rec.pricing_attribute100;
325
326
327 x_line_price_att_tbl(l_count).pricing_context := imp_rec.pricing_context;
328 x_line_price_att_tbl(l_count).context := imp_rec.context;
329 x_line_price_att_tbl(l_count).header_id := imp_rec.header_id;
330 x_line_price_att_tbl(l_count).line_id := imp_rec.line_id;
331 x_line_price_att_tbl(l_count).order_price_attrib_id := imp_rec.order_price_attrib_id;
332 x_line_price_att_tbl(l_count).flex_title := imp_rec.flex_title;
333 x_line_price_att_tbl(l_count).created_by := imp_rec.created_by;
334 x_line_price_att_tbl(l_count).creation_date := imp_rec.creation_date;
335 x_line_price_att_tbl(l_count).last_updated_by := imp_rec.last_updated_by;
336 x_line_price_att_tbl(l_count).last_update_date := imp_rec.last_update_date;
337 x_line_price_att_tbl(l_count).program_id := imp_rec.program_id;
338 x_line_price_att_tbl(l_count).program_application_id := imp_rec.program_application_id;
339
340 x_line_price_att_tbl(l_count).override_flag := imp_rec.override_flag;
341 x_line_price_att_tbl(l_count).lock_control := imp_rec.lock_control;
342 x_line_price_att_tbl(l_count).orig_sys_atts_ref := imp_rec.orig_sys_atts_ref;
343 -- set values for non-DB fields
344 x_line_price_att_tbl(l_count).db_flag := FND_API.G_TRUE;
345 x_line_price_att_tbl(l_count).operation := FND_API.G_MISS_CHAR;
346 x_line_price_att_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
347
348 l_count := l_count + 1;
349 END LOOP;
350
351 IF ( p_order_price_attrib_id IS NOT NULL
352 and p_order_price_attrib_id <> FND_API.G_MISS_NUM )
353 AND
354 ( x_Line_price_att_tbl.COUNT = 0 )
355 THEN
356 RAISE NO_DATA_FOUND;
357 END IF;
358
359
360 EXCEPTION
361
362 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
363
364 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365
366 WHEN OTHERS THEN
367
368 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
369 THEN
370 OE_MSG_PUB.Add_Exc_Msg
371 ( G_PKG_NAME
372 , 'Query_Rows'
373 );
374 END IF;
375
376 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
377
378 END Query_Rows;
379
380
381 /* Insert Row */
382 PROCEDURE Insert_Row
383 ( p_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
384 )
385 IS
386 l_lock_control NUMBER := 1;
387
388 BEGIN
389
390 oe_debug_pub.add('Entering OE_Line_Patt_UTIL.INSERT_ROW', 1);
391
392 INSERT INTO OE_ORDER_PRICE_ATTRIBS
393 ( HEADER_ID
394 ,LINE_ID
395 ,CREATION_DATE
396 ,CREATED_BY
397 ,LAST_UPDATE_DATE
398 ,LAST_UPDATED_BY
399 ,LAST_UPDATE_LOGIN
400 ,PROGRAM_APPLICATION_ID
401 ,PROGRAM_ID
402 ,PROGRAM_UPDATE_DATE
403 ,REQUEST_ID
404 ,PRICING_CONTEXT
405 ,PRICING_ATTRIBUTE1
406 ,PRICING_ATTRIBUTE2
407 ,PRICING_ATTRIBUTE3
408 ,PRICING_ATTRIBUTE4
409 ,PRICING_ATTRIBUTE5
410 ,PRICING_ATTRIBUTE6
411 ,PRICING_ATTRIBUTE7
412 ,PRICING_ATTRIBUTE8
413 ,PRICING_ATTRIBUTE9
414 ,PRICING_ATTRIBUTE10
415 ,PRICING_ATTRIBUTE11
416 ,PRICING_ATTRIBUTE12
417 ,PRICING_ATTRIBUTE13
418 ,PRICING_ATTRIBUTE14
419 ,PRICING_ATTRIBUTE15
420 ,PRICING_ATTRIBUTE16
421 ,PRICING_ATTRIBUTE17
422 ,PRICING_ATTRIBUTE18
423 ,PRICING_ATTRIBUTE19
424 ,PRICING_ATTRIBUTE20
425 ,PRICING_ATTRIBUTE21
426 ,PRICING_ATTRIBUTE22
427 ,PRICING_ATTRIBUTE23
428 ,PRICING_ATTRIBUTE24
429 ,PRICING_ATTRIBUTE25
430 ,PRICING_ATTRIBUTE26
431 ,PRICING_ATTRIBUTE27
432 ,PRICING_ATTRIBUTE28
433 ,PRICING_ATTRIBUTE29
434 ,PRICING_ATTRIBUTE30
435 ,PRICING_ATTRIBUTE31
436 ,PRICING_ATTRIBUTE32
437 ,PRICING_ATTRIBUTE33
438 ,PRICING_ATTRIBUTE34
439 ,PRICING_ATTRIBUTE35
440 ,PRICING_ATTRIBUTE36
441 ,PRICING_ATTRIBUTE37
442 ,PRICING_ATTRIBUTE38
443 ,PRICING_ATTRIBUTE39
444 ,PRICING_ATTRIBUTE40
445 ,PRICING_ATTRIBUTE41
446 ,PRICING_ATTRIBUTE42
447 ,PRICING_ATTRIBUTE43
448 ,PRICING_ATTRIBUTE44
449 ,PRICING_ATTRIBUTE45
450 ,PRICING_ATTRIBUTE46
451 ,PRICING_ATTRIBUTE47
452 ,PRICING_ATTRIBUTE48
453 ,PRICING_ATTRIBUTE49
454 ,PRICING_ATTRIBUTE50
455 ,PRICING_ATTRIBUTE51
456 ,PRICING_ATTRIBUTE52
457 ,PRICING_ATTRIBUTE53
458 ,PRICING_ATTRIBUTE54
459 ,PRICING_ATTRIBUTE55
460 ,PRICING_ATTRIBUTE56
461 ,PRICING_ATTRIBUTE57
462 ,PRICING_ATTRIBUTE58
463 ,PRICING_ATTRIBUTE59
464 ,PRICING_ATTRIBUTE60
465 ,PRICING_ATTRIBUTE61
466 ,PRICING_ATTRIBUTE62
467 ,PRICING_ATTRIBUTE63
468 ,PRICING_ATTRIBUTE64
469 ,PRICING_ATTRIBUTE65
470 ,PRICING_ATTRIBUTE66
471 ,PRICING_ATTRIBUTE67
472 ,PRICING_ATTRIBUTE68
473 ,PRICING_ATTRIBUTE69
474 ,PRICING_ATTRIBUTE70
475 ,PRICING_ATTRIBUTE71
476 ,PRICING_ATTRIBUTE72
477 ,PRICING_ATTRIBUTE73
478 ,PRICING_ATTRIBUTE74
479 ,PRICING_ATTRIBUTE75
480 ,PRICING_ATTRIBUTE76
481 ,PRICING_ATTRIBUTE77
482 ,PRICING_ATTRIBUTE78
483 ,PRICING_ATTRIBUTE79
484 ,PRICING_ATTRIBUTE80
485 ,PRICING_ATTRIBUTE81
486 ,PRICING_ATTRIBUTE82
487 ,PRICING_ATTRIBUTE83
488 ,PRICING_ATTRIBUTE84
489 ,PRICING_ATTRIBUTE85
490 ,PRICING_ATTRIBUTE86
491 ,PRICING_ATTRIBUTE87
492 ,PRICING_ATTRIBUTE88
493 ,PRICING_ATTRIBUTE89
494 ,PRICING_ATTRIBUTE90
495 ,PRICING_ATTRIBUTE91
496 ,PRICING_ATTRIBUTE92
497 ,PRICING_ATTRIBUTE93
498 ,PRICING_ATTRIBUTE94
499 ,PRICING_ATTRIBUTE95
500 ,PRICING_ATTRIBUTE96
501 ,PRICING_ATTRIBUTE97
502 ,PRICING_ATTRIBUTE98
503 ,PRICING_ATTRIBUTE99
504 ,PRICING_ATTRIBUTE100
505 ,CONTEXT
506 ,ATTRIBUTE1
507 ,ATTRIBUTE2
508 ,ATTRIBUTE3
509 ,ATTRIBUTE4
510 ,ATTRIBUTE5
511 ,ATTRIBUTE6
512 ,ATTRIBUTE7
513 ,ATTRIBUTE8
514 ,ATTRIBUTE9
515 ,ATTRIBUTE10
516 ,ATTRIBUTE11
517 ,ATTRIBUTE12
518 ,ATTRIBUTE13
519 ,ATTRIBUTE14
520 ,ATTRIBUTE15
521 ,FLEX_TITLE
522 ,ORDER_PRICE_ATTRIB_ID
523 ,OVERRIDE_FLAG
524 ,LOCK_CONTROL
525 ,ORIG_SYS_ATTS_REF
526 )
527 VALUES
528 ( p_Line_Price_Att_rec.HEADER_ID
529 ,p_Line_Price_Att_rec.LINE_ID
530 ,p_Line_Price_Att_rec.CREATION_DATE
531 ,p_Line_Price_Att_rec.CREATED_BY
532 ,p_Line_Price_Att_rec.LAST_UPDATE_DATE
533 ,p_Line_Price_Att_rec.LAST_UPDATED_BY
534 ,p_Line_Price_Att_rec.LAST_UPDATE_LOGIN
535 ,p_Line_Price_Att_rec.PROGRAM_APPLICATION_ID
536 ,p_Line_Price_Att_rec.PROGRAM_ID
537 ,p_Line_Price_Att_rec.PROGRAM_UPDATE_DATE
538 ,p_Line_Price_Att_rec.REQUEST_ID
539 ,p_Line_Price_Att_rec.PRICING_CONTEXT
540 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE1
541 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE2
542 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE3
543 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE4
544 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE5
545 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE6
546 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE7
547 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE8
548 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE9
549 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE10
550 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE11
551 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE12
552 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE13
553 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE14
554 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE15
555 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE16
556 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE17
557 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE18
558 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE19
559 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE20
560 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE21
561 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE22
562 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE23
563 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE24
564 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE25
565 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE26
566 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE27
567 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE28
568 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE29
569 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE30
570 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE31
571 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE32
572 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE33
573 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE34
574 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE35
575 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE36
576 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE37
577 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE38
578 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE39
579 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE40
580 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE41
581 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE42
582 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE43
583 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE44
584 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE45
585 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE46
586 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE47
587 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE48
588 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE49
589 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE50
590 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE51
591 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE52
592 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE53
593 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE54
594 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE55
595 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE56
596 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE57
597 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE58
598 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE59
599 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE60
600 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE61
601 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE62
602 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE63
603 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE64
604 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE65
605 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE66
606 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE67
607 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE68
608 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE69
609 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE70
610 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE71
611 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE72
612 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE73
613 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE74
614 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE75
615 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE76
616 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE77
617 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE78
618 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE79
619 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE80
620 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE81
621 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE82
622 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE83
623 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE84
624 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE85
625 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE86
626 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE87
627 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE88
628 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE89
629 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE90
630 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE91
631 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE92
632 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE93
633 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE94
634 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE95
635 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE96
636 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE97
637 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE98
638 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE99
639 ,p_Line_Price_Att_rec.PRICING_ATTRIBUTE100
640 ,p_Line_Price_Att_rec.CONTEXT
641 ,p_Line_Price_Att_rec.ATTRIBUTE1
642 ,p_Line_Price_Att_rec.ATTRIBUTE2
643 ,p_Line_Price_Att_rec.ATTRIBUTE3
644 ,p_Line_Price_Att_rec.ATTRIBUTE4
645 ,p_Line_Price_Att_rec.ATTRIBUTE5
646 ,p_Line_Price_Att_rec.ATTRIBUTE6
647 ,p_Line_Price_Att_rec.ATTRIBUTE7
648 ,p_Line_Price_Att_rec.ATTRIBUTE8
649 ,p_Line_Price_Att_rec.ATTRIBUTE9
650 ,p_Line_Price_Att_rec.ATTRIBUTE10
651 ,p_Line_Price_Att_rec.ATTRIBUTE11
652 ,p_Line_Price_Att_rec.ATTRIBUTE12
653 ,p_Line_Price_Att_rec.ATTRIBUTE13
654 ,p_Line_Price_Att_rec.ATTRIBUTE14
655 ,p_Line_Price_Att_rec.ATTRIBUTE15
656 ,p_Line_Price_Att_rec.FLEX_TITLE
657 ,p_Line_Price_Att_rec.ORDER_PRICE_ATTRIB_ID
658 ,p_Line_Price_Att_rec.OVERRIDE_FLAG
659 ,l_lock_control
660 ,p_Line_Price_Att_rec.ORIG_SYS_ATTS_REF
661 );
662
663 p_Line_Price_Att_rec.lock_control := l_lock_control;
664
665 oe_debug_pub.add('Exiting OE_Line_Patt_UTIL.INSERT_ROW', 1);
666
667 EXCEPTION
668
669 WHEN OTHERS THEN
670
671 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
672 THEN
673 FND_MSG_PUB.Add_Exc_Msg
674 ( G_PKG_NAME
675 , 'Insert_Row'
676 );
677 END IF;
678 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
679
680
681 END Insert_Row;
682
683
684 PROCEDURE Delete_Row
685 ( p_order_price_attrib_id NUMBER :=
686 FND_API.G_MISS_NUM
687 , p_line_id NUMBER :=
688 FND_API.G_MISS_NUM
689 )
690 IS
691 BEGIN
692 IF p_line_id <> FND_API.G_MISS_NUM then
693
694 DELETE FROM OE_ORDER_PRICE_ATTRIBS
695 WHERE Line_Id = p_Line_id;
696 Else
697 DELETE FROM OE_ORDER_PRICE_ATTRIBS
698 WHERE ORDER_PRICE_ATTRIB_ID = p_order_price_attrib_id;
699
700 end if;
701 EXCEPTION
702
703 WHEN OTHERS THEN
704
705 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
706 THEN
707 FND_MSG_PUB.Add_Exc_Msg
708 ( G_PKG_NAME
709 , 'Delete_Row'
710 );
711 END IF;
712 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
713
714 END Delete_Row;
715
716
717
718
719 /* Update Row */
720 PROCEDURE Update_Row
721 ( p_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
722 )
723 IS
724 l_lock_control NUMBER;
725
726 BEGIN
727
728 oe_debug_pub.add('Entering OE_Line_PATT_UTIL.UPDATE_ROW', 1);
729
730 -- increment lock_control by 1 whenever the record is updated
731 SELECT lock_control
732 INTO l_lock_control
733 FROM OE_ORDER_PRICE_ATTRIBS
734 WHERE order_price_attrib_id = p_line_Price_Att_rec.order_price_attrib_id;
735
736 l_lock_control := l_lock_control + 1;
737
738
739 UPDATE OE_ORDER_PRICE_ATTRIBS
740 SET HEADER_ID = p_Line_Price_Att_rec.HEADER_ID
741 ,LINE_ID = p_Line_Price_Att_rec.LINE_ID
742 ,OVERRIDE_FLAG = p_Line_Price_Att_rec.OVERRIDE_FLAG
743 ,CREATION_DATE = p_Line_Price_Att_rec.CREATION_DATE
744 ,CREATED_BY = p_Line_Price_Att_rec.CREATED_BY
745 ,LAST_UPDATE_DATE = p_Line_Price_Att_rec.LAST_UPDATE_DATE
746 ,LAST_UPDATED_BY = p_Line_Price_Att_rec.LAST_UPDATED_BY
747 ,LAST_UPDATE_LOGIN = p_Line_Price_Att_rec.LAST_UPDATE_LOGIN
748 ,PROGRAM_APPLICATION_ID = p_Line_Price_Att_rec.PROGRAM_APPLICATION_ID
749 ,PROGRAM_ID = p_Line_Price_Att_rec.PROGRAM_ID
750 ,PROGRAM_UPDATE_DATE = p_Line_Price_Att_rec.PROGRAM_UPDATE_DATE
751 ,REQUEST_ID = p_Line_Price_Att_rec.REQUEST_ID
752 ,PRICING_CONTEXT = p_Line_Price_Att_rec.PRICING_CONTEXT
753 ,PRICING_ATTRIBUTE1 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE1
754 ,PRICING_ATTRIBUTE2 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE2
755 ,PRICING_ATTRIBUTE3 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE3 ,PRICING_ATTRIBUTE4 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE4
756 ,PRICING_ATTRIBUTE5 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE5
757 ,PRICING_ATTRIBUTE6 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE6
758 ,PRICING_ATTRIBUTE7 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE7
759 ,PRICING_ATTRIBUTE8 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE8
760 ,PRICING_ATTRIBUTE9 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE9
761 ,PRICING_ATTRIBUTE10 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE10
762 ,PRICING_ATTRIBUTE11 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE11
763 ,PRICING_ATTRIBUTE12 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE12
764 ,PRICING_ATTRIBUTE13 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE13
765 ,PRICING_ATTRIBUTE14 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE14
766 ,PRICING_ATTRIBUTE15 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE15
767 ,PRICING_ATTRIBUTE16 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE16
768 ,PRICING_ATTRIBUTE17 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE17
769 ,PRICING_ATTRIBUTE18 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE18
770 ,PRICING_ATTRIBUTE19 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE19
771 ,PRICING_ATTRIBUTE20 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE20
772 ,PRICING_ATTRIBUTE21 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE21
773 ,PRICING_ATTRIBUTE22 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE22
774 ,PRICING_ATTRIBUTE23 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE23
775 ,PRICING_ATTRIBUTE24 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE24
776 ,PRICING_ATTRIBUTE25 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE25
777 ,PRICING_ATTRIBUTE26 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE26
778 ,PRICING_ATTRIBUTE27 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE27
779 ,PRICING_ATTRIBUTE28 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE28
780 ,PRICING_ATTRIBUTE29 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE29
781 ,PRICING_ATTRIBUTE30 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE30
782 ,PRICING_ATTRIBUTE31 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE31
783 ,PRICING_ATTRIBUTE32 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE32
784 ,PRICING_ATTRIBUTE33 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE33
785 ,PRICING_ATTRIBUTE34 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE34
786 ,PRICING_ATTRIBUTE35 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE35
787 ,PRICING_ATTRIBUTE36 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE36
788 ,PRICING_ATTRIBUTE37 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE37
789 ,PRICING_ATTRIBUTE38 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE38
790 ,PRICING_ATTRIBUTE39 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE39
791 ,PRICING_ATTRIBUTE40 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE40
792 ,PRICING_ATTRIBUTE41 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE41
793 ,PRICING_ATTRIBUTE42 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE42
794 ,PRICING_ATTRIBUTE43 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE43
795 ,PRICING_ATTRIBUTE44 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE44
796 ,PRICING_ATTRIBUTE45 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE45
797 ,PRICING_ATTRIBUTE46 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE46
798 ,PRICING_ATTRIBUTE47 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE47
799 ,PRICING_ATTRIBUTE48 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE48
800 ,PRICING_ATTRIBUTE49 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE49
801 ,PRICING_ATTRIBUTE50 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE50
802 ,PRICING_ATTRIBUTE51 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE51
803 ,PRICING_ATTRIBUTE52 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE52
804 ,PRICING_ATTRIBUTE53 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE53
805 ,PRICING_ATTRIBUTE54 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE54
806 ,PRICING_ATTRIBUTE55 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE55
807 ,PRICING_ATTRIBUTE56 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE56
808 ,PRICING_ATTRIBUTE57 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE57
809 ,PRICING_ATTRIBUTE58 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE58
810 ,PRICING_ATTRIBUTE59 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE59
811 ,PRICING_ATTRIBUTE60 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE60
812 ,PRICING_ATTRIBUTE61 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE61
813 ,PRICING_ATTRIBUTE62 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE62
814 ,PRICING_ATTRIBUTE63 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE63
815 ,PRICING_ATTRIBUTE64 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE64
816 ,PRICING_ATTRIBUTE65 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE65
817 ,PRICING_ATTRIBUTE66 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE66
818 ,PRICING_ATTRIBUTE67 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE67
819 ,PRICING_ATTRIBUTE68 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE68
820 ,PRICING_ATTRIBUTE69 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE69
821 ,PRICING_ATTRIBUTE70 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE70
822 ,PRICING_ATTRIBUTE71 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE71
823 ,PRICING_ATTRIBUTE72 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE72
824 ,PRICING_ATTRIBUTE73 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE73
825 ,PRICING_ATTRIBUTE74 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE74
826 ,PRICING_ATTRIBUTE75 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE75
827 ,PRICING_ATTRIBUTE76 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE76
828 ,PRICING_ATTRIBUTE77 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE77
829 ,PRICING_ATTRIBUTE78 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE78
830 ,PRICING_ATTRIBUTE79 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE79
831 ,PRICING_ATTRIBUTE80 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE80
832 ,PRICING_ATTRIBUTE81 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE81
833 ,PRICING_ATTRIBUTE82 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE82
834 ,PRICING_ATTRIBUTE83 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE83
835 ,PRICING_ATTRIBUTE84 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE84
836 ,PRICING_ATTRIBUTE85 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE85
837 ,PRICING_ATTRIBUTE86 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE86
838 ,PRICING_ATTRIBUTE87 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE87
839 ,PRICING_ATTRIBUTE88 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE88
840 ,PRICING_ATTRIBUTE89 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE89
841 ,PRICING_ATTRIBUTE90 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE90
842 ,PRICING_ATTRIBUTE91 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE91
843 ,PRICING_ATTRIBUTE92 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE92
844 ,PRICING_ATTRIBUTE93 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE93
845 ,PRICING_ATTRIBUTE94 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE94
846 ,PRICING_ATTRIBUTE95 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE95
847 ,PRICING_ATTRIBUTE96 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE96
848 ,PRICING_ATTRIBUTE97 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE97
849 ,PRICING_ATTRIBUTE98 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE98
850 ,PRICING_ATTRIBUTE99 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE99
851 ,PRICING_ATTRIBUTE100 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE100
852 ,ATTRIBUTE1 = p_Line_Price_Att_rec.ATTRIBUTE1
853 ,ATTRIBUTE2 = p_Line_Price_Att_rec.ATTRIBUTE2
854 ,ATTRIBUTE3 = p_Line_Price_Att_rec.ATTRIBUTE3
855 ,ATTRIBUTE4 = p_Line_Price_Att_rec.ATTRIBUTE4
856 ,ATTRIBUTE5 = p_Line_Price_Att_rec.ATTRIBUTE5
857 ,ATTRIBUTE6 = p_Line_Price_Att_rec.ATTRIBUTE6
858 ,ATTRIBUTE7 = p_Line_Price_Att_rec.ATTRIBUTE7
859 ,ATTRIBUTE8 = p_Line_Price_Att_rec.ATTRIBUTE8
860 ,ATTRIBUTE9 = p_Line_Price_Att_rec.ATTRIBUTE9
861 ,ATTRIBUTE10 = p_Line_Price_Att_rec.ATTRIBUTE10
862 ,ATTRIBUTE11 = p_Line_Price_Att_rec.ATTRIBUTE11
863 ,ATTRIBUTE12 = p_Line_Price_Att_rec.ATTRIBUTE12
864 ,ATTRIBUTE13 = p_Line_Price_Att_rec.ATTRIBUTE13
865 ,ATTRIBUTE14 = p_Line_Price_Att_rec.ATTRIBUTE14
866 ,ATTRIBUTE15 = p_Line_Price_Att_rec.ATTRIBUTE15
867 ,FLEX_TITLE = p_Line_Price_Att_rec.FLEX_TITLE
868 ,ORDER_PRICE_ATTRIB_ID = p_Line_Price_Att_rec.ORDER_PRICE_ATTRIB_ID
869 ,LOCK_CONTROL = l_lock_control
870 ,ORIG_SYS_ATTS_REF = p_Line_Price_Att_rec.ORIG_SYS_ATTS_REF
871 WHERE ORDER_PRICE_ATTRIB_ID =
872 p_Line_Price_Att_rec.order_price_attrib_id;
873
874 p_Line_Price_Att_rec.lock_control := l_lock_control;
875
876 oe_debug_pub.add('Exiting OE_Line_Patt_UTIL.UPDATE_ROW', 1);
877
878 EXCEPTION
879
880 WHEN OTHERS THEN
881
882 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
883 THEN
884 OE_MSG_PUB.Add_Exc_Msg
885 ( G_PKG_NAME
886 , 'Update_Row'
887 );
888 END IF;
889 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
890
891 END Update_Row;
892
893
894
895 PROCEDURE Clear_Dependent_Attr
896 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
897 , p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
898 , p_old_Line_Price_Att_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type :=
899 OE_Order_PUB.G_MISS_LINE_PRICE_ATT_REC
900 -- , x_Line_Price_Att_rec OUT OE_Order_PUB.Line_Price_Att_Rec_Type
901 )
902 IS
903 l_index NUMBER := 0;
904 l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
905 l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
906 BEGIN
907
908 -- Load out record
909
910 -- x_Line_Price_Att_rec := p_Line_Price_Att_rec;
911
912 -- If attr_id is missing compare old and new records and for
913 -- every changed attribute clear its dependent fields.
914
915 IF p_attr_id = FND_API.G_MISS_NUM THEN
916
917 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute1,p_old_Line_price_att_rec.attribute1)
918 THEN
919 l_index := l_index + 1;
920 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE1;
921 END IF;
922
923 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute10,p_old_Line_price_att_rec.attribute10)
924 THEN
925 l_index := l_index + 1;
926 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE10;
927 END IF;
928
929 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute11,p_old_Line_price_att_rec.attribute11)
930 THEN
931 l_index := l_index + 1;
932 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE11;
933 END IF;
934
935 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute12,p_old_Line_price_att_rec.attribute12)
936 THEN
937 l_index := l_index + 1;
938 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE12;
939 END IF;
940
941 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute13,p_old_Line_price_att_rec.attribute13)
942 THEN
943 l_index := l_index + 1;
944 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE13;
945 END IF;
946
947 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute14,p_old_Line_price_att_rec.attribute14)
948 THEN
949 l_index := l_index + 1;
950 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE14;
951 END IF;
952
953 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute15,p_old_Line_price_att_rec.attribute15)
954 THEN
955 l_index := l_index + 1;
956 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE15;
957 END IF;
958
959 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute2,p_old_Line_price_att_rec.attribute2)
960 THEN
961 l_index := l_index + 1;
962 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE2;
963 END IF;
964
965 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute3,p_old_Line_price_att_rec.attribute3)
966 THEN
967 l_index := l_index + 1;
968 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE3;
969 END IF;
970
971 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute4,p_old_Line_price_att_rec.attribute4)
972 THEN
973 l_index := l_index + 1;
974 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE4;
975 END IF;
976
977 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute5,p_old_Line_price_att_rec.attribute5)
978 THEN
979 l_index := l_index + 1;
980 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE5;
981 END IF;
982
983 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute6,p_old_Line_price_att_rec.attribute6)
984 THEN
985 l_index := l_index + 1;
986 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE6;
987 END IF;
988
989 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute7,p_old_Line_price_att_rec.attribute7)
990 THEN
991 l_index := l_index + 1;
992 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE7;
993 END IF;
994
995 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute8,p_old_Line_price_att_rec.attribute8)
996 THEN
997 l_index := l_index + 1;
998 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE8;
999 END IF;
1000
1001 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.attribute9,p_old_Line_price_att_rec.attribute9)
1002 THEN
1003 l_index := l_index + 1;
1004 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE9;
1005 END IF;
1006
1007 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.context,p_old_Line_price_att_rec.context)
1008 THEN
1009 l_index := l_index + 1;
1010 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_CONTEXT;
1011 END IF;
1012
1013 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.created_by,p_old_Line_price_att_rec.created_by)
1014 THEN
1015 l_index := l_index + 1;
1016 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_CREATED_BY;
1017 END IF;
1018
1019 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.creation_date,p_old_Line_price_att_rec.creation_date)
1020 THEN
1021 l_index := l_index + 1;
1022 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_CREATION_DATE;
1023 END IF;
1024
1025 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.flex_title,p_old_Line_price_att_rec.flex_title)
1026 THEN
1027 l_index := l_index + 1;
1028 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_FLEX_TITLE;
1029 END IF;
1030
1031 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.header_id,p_old_Line_price_att_rec.header_id)
1032 THEN
1033 l_index := l_index + 1;
1034 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_HEADER;
1035 END IF;
1036
1037 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.last_updated_by,p_old_Line_price_att_rec.last_updated_by)
1038 THEN
1039 l_index := l_index + 1;
1040 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_LAST_UPDATED_BY;
1041 END IF;
1042
1043 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.last_update_date,p_old_Line_price_att_rec.last_update_date)
1044 THEN
1045 l_index := l_index + 1;
1046 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_LAST_UPDATE_DATE;
1047 END IF;
1048
1049 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.last_update_login,p_old_Line_price_att_rec.last_update_login)
1050 THEN
1051 l_index := l_index + 1;
1052 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_LAST_UPDATE_LOGIN;
1053 END IF;
1054
1055 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.line_id,p_old_Line_price_att_rec.line_id)
1056 THEN
1057 l_index := l_index + 1;
1058 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_LINE;
1059 END IF;
1060
1061 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.order_price_attrib_id,p_old_Line_price_att_rec.order_price_attrib_id)
1062 THEN
1063 l_index := l_index + 1;
1064 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ORDER_PRICE_ATTRIB;
1065 END IF;
1066
1067 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute1,p_old_Line_price_att_rec.pricing_attribute1)
1068 THEN
1069 l_index := l_index + 1;
1070 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE1;
1071 END IF;
1072
1073 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute10,p_old_Line_price_att_rec.pricing_attribute10)
1074 THEN
1075 l_index := l_index + 1;
1076 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE10;
1077 END IF;
1078
1079 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute100,p_old_Line_price_att_rec.pricing_attribute100)
1080 THEN
1081 l_index := l_index + 1;
1082 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE100;
1083 END IF;
1084
1085 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute11,p_old_Line_price_att_rec.pricing_attribute11)
1086 THEN
1087 l_index := l_index + 1;
1088 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE11;
1089 END IF;
1090
1091 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute12,p_old_Line_price_att_rec.pricing_attribute12)
1092 THEN
1093 l_index := l_index + 1;
1094 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE12;
1095 END IF;
1096
1097 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute13,p_old_Line_price_att_rec.pricing_attribute13)
1098 THEN
1099 l_index := l_index + 1;
1100 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE13;
1101 END IF;
1102
1103 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute14,p_old_Line_price_att_rec.pricing_attribute14)
1104 THEN
1105 l_index := l_index + 1;
1106 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE14;
1107 END IF;
1108
1109 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute15,p_old_Line_price_att_rec.pricing_attribute15)
1110 THEN
1111 l_index := l_index + 1;
1112 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE15;
1113 END IF;
1114
1115 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute16,p_old_Line_price_att_rec.pricing_attribute16)
1116 THEN
1117 l_index := l_index + 1;
1118 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE16;
1119 END IF;
1120
1121 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute17,p_old_Line_price_att_rec.pricing_attribute17)
1122 THEN
1123 l_index := l_index + 1;
1124 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE17;
1125 END IF;
1126
1127 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute18,p_old_Line_price_att_rec.pricing_attribute18)
1128 THEN
1129 l_index := l_index + 1;
1130 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE18;
1131 END IF;
1132
1133 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute19,p_old_Line_price_att_rec.pricing_attribute19)
1134 THEN
1135 l_index := l_index + 1;
1136 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE19;
1137 END IF;
1138
1139 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute2,p_old_Line_price_att_rec.pricing_attribute2)
1140 THEN
1141 l_index := l_index + 1;
1142 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE2;
1143 END IF;
1144
1145 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute20,p_old_Line_price_att_rec.pricing_attribute20)
1146 THEN
1147 l_index := l_index + 1;
1148 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE20;
1149 END IF;
1150
1151 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute21,p_old_Line_price_att_rec.pricing_attribute21)
1152 THEN
1153 l_index := l_index + 1;
1154 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE21;
1155 END IF;
1156
1157 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute22,p_old_Line_price_att_rec.pricing_attribute22)
1158 THEN
1159 l_index := l_index + 1;
1160 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE22;
1161 END IF;
1162
1163 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute23,p_old_Line_price_att_rec.pricing_attribute23)
1164 THEN
1165 l_index := l_index + 1;
1166 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE23;
1167 END IF;
1168
1169 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute24,p_old_Line_price_att_rec.pricing_attribute24)
1170 THEN
1171 l_index := l_index + 1;
1172 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE24;
1173 END IF;
1174
1175 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute25,p_old_Line_price_att_rec.pricing_attribute25)
1176 THEN
1177 l_index := l_index + 1;
1178 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE25;
1179 END IF;
1180
1181 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute26,p_old_Line_price_att_rec.pricing_attribute26)
1182 THEN
1183 l_index := l_index + 1;
1184 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE26;
1185 END IF;
1186
1187 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute27,p_old_Line_price_att_rec.pricing_attribute27)
1188 THEN
1189 l_index := l_index + 1;
1190 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE27;
1191 END IF;
1192
1193 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute28,p_old_Line_price_att_rec.pricing_attribute28)
1194 THEN
1195 l_index := l_index + 1;
1196 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE28;
1197 END IF;
1198
1199 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute29,p_old_Line_price_att_rec.pricing_attribute29)
1200 THEN
1201 l_index := l_index + 1;
1202 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE29;
1203 END IF;
1204
1205 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute3,p_old_Line_price_att_rec.pricing_attribute3)
1206 THEN
1207 l_index := l_index + 1;
1208 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE3;
1209 END IF;
1210
1211 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute30,p_old_Line_price_att_rec.pricing_attribute30)
1212 THEN
1213 l_index := l_index + 1;
1214 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE30;
1215 END IF;
1216
1217 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute31,p_old_Line_price_att_rec.pricing_attribute31)
1218 THEN
1219 l_index := l_index + 1;
1220 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE31;
1221 END IF;
1222
1223 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute32,p_old_Line_price_att_rec.pricing_attribute32)
1224 THEN
1225 l_index := l_index + 1;
1226 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE32;
1227 END IF;
1228
1229 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute33,p_old_Line_price_att_rec.pricing_attribute33)
1230 THEN
1231 l_index := l_index + 1;
1232 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE33;
1233 END IF;
1234
1235 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute34,p_old_Line_price_att_rec.pricing_attribute34)
1236 THEN
1237 l_index := l_index + 1;
1238 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE34;
1239 END IF;
1240
1241 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute35,p_old_Line_price_att_rec.pricing_attribute35)
1242 THEN
1243 l_index := l_index + 1;
1244 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE35;
1245 END IF;
1246
1247 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute36,p_old_Line_price_att_rec.pricing_attribute36)
1248 THEN
1249 l_index := l_index + 1;
1250 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE36;
1251 END IF;
1252
1253 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute37,p_old_Line_price_att_rec.pricing_attribute37)
1254 THEN
1255 l_index := l_index + 1;
1256 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE37;
1257 END IF;
1258
1259 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute38,p_old_Line_price_att_rec.pricing_attribute38)
1260 THEN
1261 l_index := l_index + 1;
1262 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE38;
1263 END IF;
1264
1265 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute39,p_old_Line_price_att_rec.pricing_attribute39)
1266 THEN
1267 l_index := l_index + 1;
1268 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE39;
1269 END IF;
1270
1271
1272 -- Stopped Here
1273
1274 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute4,p_old_Line_price_att_rec.pricing_attribute4)
1275 THEN
1276 l_index := l_index + 1;
1277 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE4;
1278 END IF;
1279
1280 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute40,p_old_Line_price_att_rec.pricing_attribute40)
1281 THEN
1282 l_index := l_index + 1;
1283 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE40;
1284 END IF;
1285
1286 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute41,p_old_Line_price_att_rec.pricing_attribute41)
1287 THEN
1288 l_index := l_index + 1;
1289 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE41;
1290 END IF;
1291
1292 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute42,p_old_Line_price_att_rec.pricing_attribute42)
1293 THEN
1294 l_index := l_index + 1;
1295 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE42;
1296 END IF;
1297
1298 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute43,p_old_Line_price_att_rec.pricing_attribute43)
1299 THEN
1300 l_index := l_index + 1;
1301 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE43;
1302 END IF;
1303
1304 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute44,p_old_Line_price_att_rec.pricing_attribute44)
1305 THEN
1306 l_index := l_index + 1;
1307 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE44;
1308 END IF;
1309
1310 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute45,p_old_Line_price_att_rec.pricing_attribute45)
1311 THEN
1312 l_index := l_index + 1;
1313 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE45;
1314 END IF;
1315
1316 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute46,p_old_Line_price_att_rec.pricing_attribute46)
1317 THEN
1318 l_index := l_index + 1;
1319 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE46;
1320 END IF;
1321
1322 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute47,p_old_Line_price_att_rec.pricing_attribute47)
1323 THEN
1324 l_index := l_index + 1;
1325 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE47;
1326 END IF;
1327
1328 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute48,p_old_Line_price_att_rec.pricing_attribute48)
1329 THEN
1330 l_index := l_index + 1;
1331 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE48;
1332 END IF;
1333
1334 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute49,p_old_Line_price_att_rec.pricing_attribute49)
1335 THEN
1336 l_index := l_index + 1;
1337 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE49;
1338 END IF;
1339
1340 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute5,p_old_Line_price_att_rec.pricing_attribute5)
1341 THEN
1342 l_index := l_index + 1;
1343 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE5;
1344 END IF;
1345
1346 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute50,p_old_Line_price_att_rec.pricing_attribute50)
1347 THEN
1348 l_index := l_index + 1;
1349 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE50;
1350 END IF;
1351
1352 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute51,p_old_Line_price_att_rec.pricing_attribute51)
1353 THEN
1354 l_index := l_index + 1;
1355 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE51;
1356 END IF;
1357
1358 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute52,p_old_Line_price_att_rec.pricing_attribute52)
1359 THEN
1360 l_index := l_index + 1;
1361 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE52;
1362 END IF;
1363
1364 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute53,p_old_Line_price_att_rec.pricing_attribute53)
1365 THEN
1366 l_index := l_index + 1;
1367 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE53;
1368 END IF;
1369
1370 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute54,p_old_Line_price_att_rec.pricing_attribute54)
1371 THEN
1372 l_index := l_index + 1;
1373 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE54;
1374 END IF;
1375
1376 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute55,p_old_Line_price_att_rec.pricing_attribute55)
1377 THEN
1378 l_index := l_index + 1;
1379 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE55;
1380 END IF;
1381
1382 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute56,p_old_Line_price_att_rec.pricing_attribute56)
1383 THEN
1384 l_index := l_index + 1;
1385 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE56;
1386 END IF;
1387
1388 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute57,p_old_Line_price_att_rec.pricing_attribute57)
1389 THEN
1390 l_index := l_index + 1;
1391 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE57;
1392 END IF;
1393
1394 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute58,p_old_Line_price_att_rec.pricing_attribute58)
1395 THEN
1396 l_index := l_index + 1;
1397 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE58;
1398 END IF;
1399
1400 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute59,p_old_Line_price_att_rec.pricing_attribute59)
1401 THEN
1402 l_index := l_index + 1;
1403 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE59;
1404 END IF;
1405
1406 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute6,p_old_Line_price_att_rec.pricing_attribute6)
1407 THEN
1408 l_index := l_index + 1;
1409 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE6;
1410 END IF;
1411
1412 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute60,p_old_Line_price_att_rec.pricing_attribute60)
1413 THEN
1414 l_index := l_index + 1;
1415 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE60;
1416 END IF;
1417
1418 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute61,p_old_Line_price_att_rec.pricing_attribute61)
1419 THEN
1420 l_index := l_index + 1;
1421 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE61;
1422 END IF;
1423
1424 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute62,p_old_Line_price_att_rec.pricing_attribute62)
1425 THEN
1426 l_index := l_index + 1;
1427 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE62;
1428 END IF;
1429
1430 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute63,p_old_Line_price_att_rec.pricing_attribute63)
1431 THEN
1432 l_index := l_index + 1;
1433 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE63;
1434 END IF;
1435
1436 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute64,p_old_Line_price_att_rec.pricing_attribute64)
1437 THEN
1438 l_index := l_index + 1;
1439 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE64;
1440 END IF;
1441
1442 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute65,p_old_Line_price_att_rec.pricing_attribute65)
1443 THEN
1444 l_index := l_index + 1;
1445 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE65;
1446 END IF;
1447
1448 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute66,p_old_Line_price_att_rec.pricing_attribute66)
1449 THEN
1450 l_index := l_index + 1;
1451 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE66;
1452 END IF;
1453
1454 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute67,p_old_Line_price_att_rec.pricing_attribute67)
1455 THEN
1456 l_index := l_index + 1;
1457 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE67;
1458 END IF;
1459
1460 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute68,p_old_Line_price_att_rec.pricing_attribute68)
1461 THEN
1462 l_index := l_index + 1;
1463 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE68;
1464 END IF;
1465
1466 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute69,p_old_Line_price_att_rec.pricing_attribute69)
1467 THEN
1468 l_index := l_index + 1;
1469 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE69;
1470 END IF;
1471
1472 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute7,p_old_Line_price_att_rec.pricing_attribute7)
1473 THEN
1474 l_index := l_index + 1;
1475 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE7;
1476 END IF;
1477
1478 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute70,p_old_Line_price_att_rec.pricing_attribute70)
1479 THEN
1480 l_index := l_index + 1;
1481 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE70;
1482 END IF;
1483
1484 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute71,p_old_Line_price_att_rec.pricing_attribute71)
1485 THEN
1486 l_index := l_index + 1;
1487 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE71;
1488 END IF;
1489
1490 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute72,p_old_Line_price_att_rec.pricing_attribute72)
1491 THEN
1492 l_index := l_index + 1;
1493 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE72;
1494 END IF;
1495
1496 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute73,p_old_Line_price_att_rec.pricing_attribute73)
1497 THEN
1498 l_index := l_index + 1;
1499 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE73;
1500 END IF;
1501
1502 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute74,p_old_Line_price_att_rec.pricing_attribute74)
1503 THEN
1504 l_index := l_index + 1;
1505 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE74;
1506 END IF;
1507
1508 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute75,p_old_Line_price_att_rec.pricing_attribute75)
1509 THEN
1510 l_index := l_index + 1;
1511 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE75;
1512 END IF;
1513
1514 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute76,p_old_Line_price_att_rec.pricing_attribute76)
1515 THEN
1516 l_index := l_index + 1;
1517 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE76;
1518 END IF;
1519
1520 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute77,p_old_Line_price_att_rec.pricing_attribute77)
1521 THEN
1522 l_index := l_index + 1;
1523 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE77;
1524 END IF;
1525
1526 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute78,p_old_Line_price_att_rec.pricing_attribute78)
1527 THEN
1528 l_index := l_index + 1;
1529 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE78;
1530 END IF;
1531
1532 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute79,p_old_Line_price_att_rec.pricing_attribute79)
1533 THEN
1534 l_index := l_index + 1;
1535 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE79;
1536 END IF;
1537
1538 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute8,p_old_Line_price_att_rec.pricing_attribute8)
1539 THEN
1540 l_index := l_index + 1;
1541 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE8;
1542 END IF;
1543
1544 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute80,p_old_Line_price_att_rec.pricing_attribute80)
1545 THEN
1546 l_index := l_index + 1;
1547 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE80;
1548 END IF;
1549
1550 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute81,p_old_Line_price_att_rec.pricing_attribute81)
1551 THEN
1552 l_index := l_index + 1;
1553 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE81;
1554 END IF;
1555
1556 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute82,p_old_Line_price_att_rec.pricing_attribute82)
1557 THEN
1558 l_index := l_index + 1;
1559 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE82;
1560 END IF;
1561
1562 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute83,p_old_Line_price_att_rec.pricing_attribute83)
1563 THEN
1564 l_index := l_index + 1;
1565 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE83;
1566 END IF;
1567
1568 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute84,p_old_Line_price_att_rec.pricing_attribute84)
1569 THEN
1570 l_index := l_index + 1;
1571 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE84;
1572 END IF;
1573
1574 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute85,p_old_Line_price_att_rec.pricing_attribute85)
1575 THEN
1576 l_index := l_index + 1;
1577 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE85;
1578 END IF;
1579
1580 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute86,p_old_Line_price_att_rec.pricing_attribute86)
1581 THEN
1582 l_index := l_index + 1;
1583 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE86;
1584 END IF;
1585
1586 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute87,p_old_Line_price_att_rec.pricing_attribute87)
1587 THEN
1588 l_index := l_index + 1;
1589 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE87;
1590 END IF;
1591
1592 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute88,p_old_Line_price_att_rec.pricing_attribute88)
1593 THEN
1594 l_index := l_index + 1;
1595 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE88;
1596 END IF;
1597
1598 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute89,p_old_Line_price_att_rec.pricing_attribute89)
1599 THEN
1600 l_index := l_index + 1;
1601 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE89;
1602 END IF;
1603
1604 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute9,p_old_Line_price_att_rec.pricing_attribute9)
1605 THEN
1606 l_index := l_index + 1;
1607 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE9;
1608 END IF;
1609
1610 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute90,p_old_Line_price_att_rec.pricing_attribute90)
1611 THEN
1612 l_index := l_index + 1;
1613 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE90;
1614 END IF;
1615
1616 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute91,p_old_Line_price_att_rec.pricing_attribute91)
1617 THEN
1618 l_index := l_index + 1;
1619 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE91;
1620 END IF;
1621
1622 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute92,p_old_Line_price_att_rec.pricing_attribute92)
1623 THEN
1624 l_index := l_index + 1;
1625 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE92;
1626 END IF;
1627
1628 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute93,p_old_Line_price_att_rec.pricing_attribute93)
1629 THEN
1630 l_index := l_index + 1;
1631 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE93;
1632 END IF;
1633
1634 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute94,p_old_Line_price_att_rec.pricing_attribute94)
1635 THEN
1636 l_index := l_index + 1;
1637 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE94;
1638 END IF;
1639
1640 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute95,p_old_Line_price_att_rec.pricing_attribute95)
1641 THEN
1642 l_index := l_index + 1;
1643 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE95;
1644 END IF;
1645
1646 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute96,p_old_Line_price_att_rec.pricing_attribute96)
1647 THEN
1648 l_index := l_index + 1;
1649 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE96;
1650 END IF;
1651
1652 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute97,p_old_Line_price_att_rec.pricing_attribute97)
1653 THEN
1654 l_index := l_index + 1;
1655 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE97;
1656 END IF;
1657
1658 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute98,p_old_Line_price_att_rec.pricing_attribute98)
1659 THEN
1660 l_index := l_index + 1;
1661 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE98;
1662 END IF;
1663
1664 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_attribute99,p_old_Line_price_att_rec.pricing_attribute99)
1665 THEN
1666 l_index := l_index + 1;
1667 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE99;
1668 END IF;
1669
1670 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.pricing_context,p_old_Line_price_att_rec.pricing_context)
1671 THEN
1672 l_index := l_index + 1;
1673 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_CONTEXT;
1674 END IF;
1675
1676 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.program_application_id,p_old_Line_price_att_rec.program_application_id)
1677 THEN
1678 l_index := l_index + 1;
1679 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PROGRAM_APPLICATION;
1680 END IF;
1681
1682 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.program_id,p_old_Line_price_att_rec.program_id)
1683 THEN
1684 l_index := l_index + 1;
1685 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PROGRAM;
1686 END IF;
1687
1688 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.program_update_date,p_old_Line_price_att_rec.program_update_date)
1689 THEN
1690 l_index := l_index + 1;
1691 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PROGRAM_UPDATE_DATE;
1692 END IF;
1693
1694 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.request_id,p_old_Line_price_att_rec.request_id)
1695 THEN
1696 l_index := l_index + 1;
1697 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_REQUEST;
1698 END IF;
1699
1700 IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.orig_sys_atts_ref,p_old_Line_price_att_rec.orig_sys_atts_ref)
1701 THEN
1702 l_index := l_index + 1;
1703 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ORIG_SYS_ATTS_REF;
1704 END IF;
1705
1706 ELSIF p_attr_id = G_OVERRIDE_FLAG THEN
1707 l_index := l_index + 1;
1708 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_OVERRIDE_FLAG;
1709
1710 ELSIF p_attr_id = G_ATTRIBUTE1 THEN
1711 l_index := l_index + 1;
1712 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE1;
1713 ELSIF p_attr_id = G_ATTRIBUTE10 THEN
1714 l_index := l_index + 1;
1715 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE10;
1716 ELSIF p_attr_id = G_ATTRIBUTE11 THEN
1717 l_index := l_index + 1;
1718 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE11;
1719 ELSIF p_attr_id = G_ATTRIBUTE12 THEN
1720 l_index := l_index + 1;
1721 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE12;
1722 ELSIF p_attr_id = G_ATTRIBUTE13 THEN
1723 l_index := l_index + 1;
1724 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE13;
1725 ELSIF p_attr_id = G_ATTRIBUTE14 THEN
1726 l_index := l_index + 1;
1727 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE14;
1728 ELSIF p_attr_id = G_ATTRIBUTE15 THEN
1729 l_index := l_index + 1;
1730 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE15;
1731 ELSIF p_attr_id = G_ATTRIBUTE2 THEN
1732 l_index := l_index + 1;
1733 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE2;
1734 ELSIF p_attr_id = G_ATTRIBUTE3 THEN
1735 l_index := l_index + 1;
1736 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE3;
1737 ELSIF p_attr_id = G_ATTRIBUTE4 THEN
1738 l_index := l_index + 1;
1739 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE4;
1740 ELSIF p_attr_id = G_ATTRIBUTE5 THEN
1741 l_index := l_index + 1;
1742 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE5;
1743 ELSIF p_attr_id = G_ATTRIBUTE6 THEN
1744 l_index := l_index + 1;
1745 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE6;
1746 ELSIF p_attr_id = G_ATTRIBUTE7 THEN
1747 l_index := l_index + 1;
1748 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE7;
1749 ELSIF p_attr_id = G_ATTRIBUTE8 THEN
1750 l_index := l_index + 1;
1751 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE8;
1752 ELSIF p_attr_id = G_ATTRIBUTE9 THEN
1753 l_index := l_index + 1;
1754 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ATTRIBUTE9;
1755 ELSIF p_attr_id = G_CONTEXT THEN
1756 l_index := l_index + 1;
1757 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_CONTEXT;
1758 ELSIF p_attr_id = G_CREATED_BY THEN
1759 l_index := l_index + 1;
1760 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_CREATED_BY;
1761 ELSIF p_attr_id = G_CREATION_DATE THEN
1762 l_index := l_index + 1;
1763 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_CREATION_DATE;
1764 ELSIF p_attr_id = G_FLEX_TITLE THEN
1765 l_index := l_index + 1;
1766 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_FLEX_TITLE;
1767 ELSIF p_attr_id = G_HEADER THEN
1768 l_index := l_index + 1;
1769 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_HEADER;
1770 ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
1771 l_index := l_index + 1;
1772 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_LAST_UPDATED_BY;
1773 ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
1774 l_index := l_index + 1;
1775 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_LAST_UPDATE_DATE;
1776 ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
1777 l_index := l_index + 1;
1778 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_LAST_UPDATE_LOGIN;
1779 ELSIF p_attr_id = G_LINE THEN
1780 l_index := l_index + 1;
1781 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_LINE;
1782 ELSIF p_attr_id = G_ORDER_PRICE_ATTRIB THEN
1783 l_index := l_index + 1;
1784 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ORDER_PRICE_ATTRIB;
1785 ELSIF p_attr_id = G_PRICING_ATTRIBUTE1 THEN
1786 l_index := l_index + 1;
1787 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE1;
1788 ELSIF p_attr_id = G_PRICING_ATTRIBUTE10 THEN
1789 l_index := l_index + 1;
1790 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE10;
1791 ELSIF p_attr_id = G_PRICING_ATTRIBUTE100 THEN
1792 l_index := l_index + 1;
1793 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE100;
1794 ELSIF p_attr_id = G_PRICING_ATTRIBUTE11 THEN
1795 l_index := l_index + 1;
1796 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE11;
1797 ELSIF p_attr_id = G_PRICING_ATTRIBUTE12 THEN
1798 l_index := l_index + 1;
1799 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE12;
1800 ELSIF p_attr_id = G_PRICING_ATTRIBUTE13 THEN
1801 l_index := l_index + 1;
1802 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE13;
1803 ELSIF p_attr_id = G_PRICING_ATTRIBUTE14 THEN
1804 l_index := l_index + 1;
1805 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE14;
1806 ELSIF p_attr_id = G_PRICING_ATTRIBUTE15 THEN
1807 l_index := l_index + 1;
1808 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE15;
1809 ELSIF p_attr_id = G_PRICING_ATTRIBUTE16 THEN
1810 l_index := l_index + 1;
1811 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE16;
1812 ELSIF p_attr_id = G_PRICING_ATTRIBUTE17 THEN
1813 l_index := l_index + 1;
1814 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE17;
1815 ELSIF p_attr_id = G_PRICING_ATTRIBUTE18 THEN
1816 l_index := l_index + 1;
1817 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE18;
1818 ELSIF p_attr_id = G_PRICING_ATTRIBUTE19 THEN
1819 l_index := l_index + 1;
1820 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE19;
1821 ELSIF p_attr_id = G_PRICING_ATTRIBUTE2 THEN
1822 l_index := l_index + 1;
1823 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE2;
1824 ELSIF p_attr_id = G_PRICING_ATTRIBUTE20 THEN
1825 l_index := l_index + 1;
1826 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE20;
1827 ELSIF p_attr_id = G_PRICING_ATTRIBUTE21 THEN
1828 l_index := l_index + 1;
1829 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE21;
1830 ELSIF p_attr_id = G_PRICING_ATTRIBUTE22 THEN
1831 l_index := l_index + 1;
1832 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE22;
1833 ELSIF p_attr_id = G_PRICING_ATTRIBUTE23 THEN
1834 l_index := l_index + 1;
1835 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE23;
1836 ELSIF p_attr_id = G_PRICING_ATTRIBUTE24 THEN
1837 l_index := l_index + 1;
1838 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE24;
1839 ELSIF p_attr_id = G_PRICING_ATTRIBUTE25 THEN
1840 l_index := l_index + 1;
1841 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE25;
1842 ELSIF p_attr_id = G_PRICING_ATTRIBUTE26 THEN
1843 l_index := l_index + 1;
1844 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE26;
1845 ELSIF p_attr_id = G_PRICING_ATTRIBUTE27 THEN
1846 l_index := l_index + 1;
1847 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE27;
1848 ELSIF p_attr_id = G_PRICING_ATTRIBUTE28 THEN
1849 l_index := l_index + 1;
1850 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE28;
1851 ELSIF p_attr_id = G_PRICING_ATTRIBUTE29 THEN
1852 l_index := l_index + 1;
1853 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE29;
1854 ELSIF p_attr_id = G_PRICING_ATTRIBUTE3 THEN
1855 l_index := l_index + 1;
1856 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE3;
1857 ELSIF p_attr_id = G_PRICING_ATTRIBUTE30 THEN
1858 l_index := l_index + 1;
1859 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE30;
1860 ELSIF p_attr_id = G_PRICING_ATTRIBUTE31 THEN
1861 l_index := l_index + 1;
1862 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE31;
1863 ELSIF p_attr_id = G_PRICING_ATTRIBUTE32 THEN
1864 l_index := l_index + 1;
1865 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE32;
1866 ELSIF p_attr_id = G_PRICING_ATTRIBUTE33 THEN
1867 l_index := l_index + 1;
1868 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE33;
1869 ELSIF p_attr_id = G_PRICING_ATTRIBUTE34 THEN
1870 l_index := l_index + 1;
1871 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE34;
1872 ELSIF p_attr_id = G_PRICING_ATTRIBUTE35 THEN
1873 l_index := l_index + 1;
1874 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE35;
1875 ELSIF p_attr_id = G_PRICING_ATTRIBUTE36 THEN
1876 l_index := l_index + 1;
1877 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE36;
1878 ELSIF p_attr_id = G_PRICING_ATTRIBUTE37 THEN
1879 l_index := l_index + 1;
1880 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE37;
1881 ELSIF p_attr_id = G_PRICING_ATTRIBUTE38 THEN
1882 l_index := l_index + 1;
1883 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE38;
1884 ELSIF p_attr_id = G_PRICING_ATTRIBUTE39 THEN
1885 l_index := l_index + 1;
1886 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE39;
1887 ELSIF p_attr_id = G_PRICING_ATTRIBUTE4 THEN
1888 l_index := l_index + 1;
1889 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE4;
1890 ELSIF p_attr_id = G_PRICING_ATTRIBUTE40 THEN
1891 l_index := l_index + 1;
1892 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE40;
1893 ELSIF p_attr_id = G_PRICING_ATTRIBUTE41 THEN
1894 l_index := l_index + 1;
1895 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE41;
1896 ELSIF p_attr_id = G_PRICING_ATTRIBUTE42 THEN
1897 l_index := l_index + 1;
1898 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE42;
1899 ELSIF p_attr_id = G_PRICING_ATTRIBUTE43 THEN
1900 l_index := l_index + 1;
1901 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE43;
1902 ELSIF p_attr_id = G_PRICING_ATTRIBUTE44 THEN
1903 l_index := l_index + 1;
1904 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE44;
1905 ELSIF p_attr_id = G_PRICING_ATTRIBUTE45 THEN
1906 l_index := l_index + 1;
1907 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE45;
1908 ELSIF p_attr_id = G_PRICING_ATTRIBUTE46 THEN
1909 l_index := l_index + 1;
1910 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE46;
1911 ELSIF p_attr_id = G_PRICING_ATTRIBUTE47 THEN
1912 l_index := l_index + 1;
1913 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE47;
1914 ELSIF p_attr_id = G_PRICING_ATTRIBUTE48 THEN
1915 l_index := l_index + 1;
1916 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE48;
1917 ELSIF p_attr_id = G_PRICING_ATTRIBUTE49 THEN
1918 l_index := l_index + 1;
1919 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE49;
1920 ELSIF p_attr_id = G_PRICING_ATTRIBUTE5 THEN
1921 l_index := l_index + 1;
1922 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE5;
1923 ELSIF p_attr_id = G_PRICING_ATTRIBUTE50 THEN
1924 l_index := l_index + 1;
1925 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE50;
1926 ELSIF p_attr_id = G_PRICING_ATTRIBUTE51 THEN
1927 l_index := l_index + 1;
1928 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE51;
1929 ELSIF p_attr_id = G_PRICING_ATTRIBUTE52 THEN
1930 l_index := l_index + 1;
1931 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE52;
1932 ELSIF p_attr_id = G_PRICING_ATTRIBUTE53 THEN
1933 l_index := l_index + 1;
1934 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE53;
1935 ELSIF p_attr_id = G_PRICING_ATTRIBUTE54 THEN
1936 l_index := l_index + 1;
1937 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE54;
1938 ELSIF p_attr_id = G_PRICING_ATTRIBUTE55 THEN
1939 l_index := l_index + 1;
1940 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE55;
1941 ELSIF p_attr_id = G_PRICING_ATTRIBUTE56 THEN
1942 l_index := l_index + 1;
1943 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE56;
1944 ELSIF p_attr_id = G_PRICING_ATTRIBUTE57 THEN
1945 l_index := l_index + 1;
1946 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE57;
1947 ELSIF p_attr_id = G_PRICING_ATTRIBUTE58 THEN
1948 l_index := l_index + 1;
1949 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE58;
1950 ELSIF p_attr_id = G_PRICING_ATTRIBUTE59 THEN
1951 l_index := l_index + 1;
1952 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE59;
1953 ELSIF p_attr_id = G_PRICING_ATTRIBUTE6 THEN
1954 l_index := l_index + 1;
1955 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE6;
1956 ELSIF p_attr_id = G_PRICING_ATTRIBUTE60 THEN
1957 l_index := l_index + 1;
1958 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE60;
1959 ELSIF p_attr_id = G_PRICING_ATTRIBUTE61 THEN
1960 l_index := l_index + 1;
1961 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE61;
1962 ELSIF p_attr_id = G_PRICING_ATTRIBUTE62 THEN
1963 l_index := l_index + 1;
1964 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE62;
1965 ELSIF p_attr_id = G_PRICING_ATTRIBUTE63 THEN
1966 l_index := l_index + 1;
1967 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE63;
1968 ELSIF p_attr_id = G_PRICING_ATTRIBUTE64 THEN
1969 l_index := l_index + 1;
1970 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE64;
1971 ELSIF p_attr_id = G_PRICING_ATTRIBUTE65 THEN
1972 l_index := l_index + 1;
1973 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE65;
1974 ELSIF p_attr_id = G_PRICING_ATTRIBUTE66 THEN
1975 l_index := l_index + 1;
1976 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE66;
1977 ELSIF p_attr_id = G_PRICING_ATTRIBUTE67 THEN
1978 l_index := l_index + 1;
1979 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE67;
1980 ELSIF p_attr_id = G_PRICING_ATTRIBUTE68 THEN
1981 l_index := l_index + 1;
1982 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE68;
1983 ELSIF p_attr_id = G_PRICING_ATTRIBUTE69 THEN
1984 l_index := l_index + 1;
1985 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE69;
1986 ELSIF p_attr_id = G_PRICING_ATTRIBUTE7 THEN
1987 l_index := l_index + 1;
1988 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE7;
1989 ELSIF p_attr_id = G_PRICING_ATTRIBUTE70 THEN
1990 l_index := l_index + 1;
1991 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE70;
1992 ELSIF p_attr_id = G_PRICING_ATTRIBUTE71 THEN
1993 l_index := l_index + 1;
1994 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE71;
1995 ELSIF p_attr_id = G_PRICING_ATTRIBUTE72 THEN
1996 l_index := l_index + 1;
1997 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE72;
1998 ELSIF p_attr_id = G_PRICING_ATTRIBUTE73 THEN
1999 l_index := l_index + 1;
2000 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE73;
2001 ELSIF p_attr_id = G_PRICING_ATTRIBUTE74 THEN
2002 l_index := l_index + 1;
2003 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE74;
2004 ELSIF p_attr_id = G_PRICING_ATTRIBUTE75 THEN
2005 l_index := l_index + 1;
2006 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE75;
2007 ELSIF p_attr_id = G_PRICING_ATTRIBUTE76 THEN
2008 l_index := l_index + 1;
2009 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE76;
2010 ELSIF p_attr_id = G_PRICING_ATTRIBUTE77 THEN
2011 l_index := l_index + 1;
2012 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE77;
2013 ELSIF p_attr_id = G_PRICING_ATTRIBUTE78 THEN
2014 l_index := l_index + 1;
2015 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE78;
2016 ELSIF p_attr_id = G_PRICING_ATTRIBUTE79 THEN
2017 l_index := l_index + 1;
2018 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE79;
2019 ELSIF p_attr_id = G_PRICING_ATTRIBUTE8 THEN
2020 l_index := l_index + 1;
2021 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE8;
2022 ELSIF p_attr_id = G_PRICING_ATTRIBUTE80 THEN
2023 l_index := l_index + 1;
2024 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE80;
2025 ELSIF p_attr_id = G_PRICING_ATTRIBUTE81 THEN
2026 l_index := l_index + 1;
2027 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE81;
2028 ELSIF p_attr_id = G_PRICING_ATTRIBUTE82 THEN
2029 l_index := l_index + 1;
2030 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE82;
2031 ELSIF p_attr_id = G_PRICING_ATTRIBUTE83 THEN
2032 l_index := l_index + 1;
2033 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE83;
2034 ELSIF p_attr_id = G_PRICING_ATTRIBUTE84 THEN
2035 l_index := l_index + 1;
2036 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE84;
2037 ELSIF p_attr_id = G_PRICING_ATTRIBUTE85 THEN
2038 l_index := l_index + 1;
2039 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE85;
2040 ELSIF p_attr_id = G_PRICING_ATTRIBUTE86 THEN
2041 l_index := l_index + 1;
2042 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE86;
2043 ELSIF p_attr_id = G_PRICING_ATTRIBUTE87 THEN
2044 l_index := l_index + 1;
2045 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE87;
2046 ELSIF p_attr_id = G_PRICING_ATTRIBUTE88 THEN
2047 l_index := l_index + 1;
2048 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE88;
2049 ELSIF p_attr_id = G_PRICING_ATTRIBUTE89 THEN
2050 l_index := l_index + 1;
2051 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE89;
2052 ELSIF p_attr_id = G_PRICING_ATTRIBUTE9 THEN
2053 l_index := l_index + 1;
2054 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE9;
2055 ELSIF p_attr_id = G_PRICING_ATTRIBUTE90 THEN
2056 l_index := l_index + 1;
2057 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE90;
2058 ELSIF p_attr_id = G_PRICING_ATTRIBUTE91 THEN
2059 l_index := l_index + 1;
2060 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE91;
2061 ELSIF p_attr_id = G_PRICING_ATTRIBUTE92 THEN
2062 l_index := l_index + 1;
2063 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE92;
2064 ELSIF p_attr_id = G_PRICING_ATTRIBUTE93 THEN
2065 l_index := l_index + 1;
2066 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE93;
2067 ELSIF p_attr_id = G_PRICING_ATTRIBUTE94 THEN
2068 l_index := l_index + 1;
2069 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE94;
2070 ELSIF p_attr_id = G_PRICING_ATTRIBUTE95 THEN
2071 l_index := l_index + 1;
2072 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE95;
2073 ELSIF p_attr_id = G_PRICING_ATTRIBUTE96 THEN
2074 l_index := l_index + 1;
2075 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE96;
2076 ELSIF p_attr_id = G_PRICING_ATTRIBUTE97 THEN
2077 l_index := l_index + 1;
2078 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE97;
2079 ELSIF p_attr_id = G_PRICING_ATTRIBUTE98 THEN
2080 l_index := l_index + 1;
2081 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE98;
2082 ELSIF p_attr_id = G_PRICING_ATTRIBUTE99 THEN
2083 l_index := l_index + 1;
2084 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_ATTRIBUTE99;
2085 ELSIF p_attr_id = G_PRICING_CONTEXT THEN
2086 l_index := l_index + 1;
2087 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PRICING_CONTEXT;
2088 ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
2089 l_index := l_index + 1;
2090 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PROGRAM_APPLICATION;
2091 ELSIF p_attr_id = G_PROGRAM THEN
2092 l_index := l_index + 1;
2093 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PROGRAM;
2094 ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
2095 l_index := l_index + 1;
2096 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PROGRAM_UPDATE_DATE;
2097 ELSIF p_attr_id = G_REQUEST THEN
2098 l_index := l_index + 1;
2099 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_REQUEST;
2100
2101 ELSIF p_attr_id = G_ORIG_SYS_ATTS_REF THEN
2102 l_index := l_index + 1;
2103 l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_ORIG_SYS_ATTS_REF;
2104 END IF;
2105 END Clear_Dependent_Attr;
2106
2107
2108 PROCEDURE Complete_Record
2109 ( p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
2110 , p_old_Line_price_att_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type
2111 )
2112 IS
2113
2114 l_Line_price_att_rec OE_Order_PUB.Line_Price_Att_Rec_Type := p_x_Line_Price_Att_rec;
2115 BEGIN
2116
2117 IF l_Line_price_att_rec.override_flag = FND_API.G_MISS_CHAR THEN
2118 l_Line_price_att_rec.override_flag := p_old_Line_price_att_rec.override_flag;
2119 END IF;
2120
2121 IF l_Line_price_att_rec.attribute1 = FND_API.G_MISS_CHAR THEN
2122 l_Line_price_att_rec.attribute1 := p_old_Line_price_att_rec.attribute1;
2123 END IF;
2124
2125 IF l_Line_price_att_rec.attribute10 = FND_API.G_MISS_CHAR THEN
2126 l_Line_price_att_rec.attribute10 := p_old_Line_price_att_rec.attribute10;
2127 END IF;
2128
2129 IF l_Line_price_att_rec.attribute11 = FND_API.G_MISS_CHAR THEN
2130 l_Line_price_att_rec.attribute11 := p_old_Line_price_att_rec.attribute11;
2131 END IF;
2132
2133 IF l_Line_price_att_rec.attribute12 = FND_API.G_MISS_CHAR THEN
2134 l_Line_price_att_rec.attribute12 := p_old_Line_price_att_rec.attribute12;
2135 END IF;
2136
2137 IF l_Line_price_att_rec.attribute13 = FND_API.G_MISS_CHAR THEN
2138 l_Line_price_att_rec.attribute13 := p_old_Line_price_att_rec.attribute13;
2139 END IF;
2140
2141 IF l_Line_price_att_rec.attribute14 = FND_API.G_MISS_CHAR THEN
2142 l_Line_price_att_rec.attribute14 := p_old_Line_price_att_rec.attribute14;
2143 END IF;
2144
2145 IF l_Line_price_att_rec.attribute15 = FND_API.G_MISS_CHAR THEN
2146 l_Line_price_att_rec.attribute15 := p_old_Line_price_att_rec.attribute15;
2147 END IF;
2148
2149 IF l_Line_price_att_rec.attribute2 = FND_API.G_MISS_CHAR THEN
2150 l_Line_price_att_rec.attribute2 := p_old_Line_price_att_rec.attribute2;
2151 END IF;
2152
2153 IF l_Line_price_att_rec.attribute3 = FND_API.G_MISS_CHAR THEN
2154 l_Line_price_att_rec.attribute3 := p_old_Line_price_att_rec.attribute3;
2155 END IF;
2156
2157 IF l_Line_price_att_rec.attribute4 = FND_API.G_MISS_CHAR THEN
2158 l_Line_price_att_rec.attribute4 := p_old_Line_price_att_rec.attribute4;
2159 END IF;
2160
2161 IF l_Line_price_att_rec.attribute5 = FND_API.G_MISS_CHAR THEN
2162 l_Line_price_att_rec.attribute5 := p_old_Line_price_att_rec.attribute5;
2163 END IF;
2164
2165 IF l_Line_price_att_rec.attribute6 = FND_API.G_MISS_CHAR THEN
2166 l_Line_price_att_rec.attribute6 := p_old_Line_price_att_rec.attribute6;
2167 END IF;
2168
2169 IF l_Line_price_att_rec.attribute7 = FND_API.G_MISS_CHAR THEN
2170 l_Line_price_att_rec.attribute7 := p_old_Line_price_att_rec.attribute7;
2171 END IF;
2172
2173 IF l_Line_price_att_rec.attribute8 = FND_API.G_MISS_CHAR THEN
2174 l_Line_price_att_rec.attribute8 := p_old_Line_price_att_rec.attribute8;
2175 END IF;
2176
2177 IF l_Line_price_att_rec.attribute9 = FND_API.G_MISS_CHAR THEN
2178 l_Line_price_att_rec.attribute9 := p_old_Line_price_att_rec.attribute9;
2179 END IF;
2180
2181 IF l_Line_price_att_rec.context = FND_API.G_MISS_CHAR THEN
2182 l_Line_price_att_rec.context := p_old_Line_price_att_rec.context;
2183 END IF;
2184
2185 IF l_Line_price_att_rec.created_by = FND_API.G_MISS_NUM THEN
2186 l_Line_price_att_rec.created_by := p_old_Line_price_att_rec.created_by;
2187 END IF;
2188
2189 IF l_Line_price_att_rec.creation_date = FND_API.G_MISS_DATE THEN
2190 l_Line_price_att_rec.creation_date := p_old_Line_price_att_rec.creation_date;
2191 END IF;
2192
2193 IF l_Line_price_att_rec.flex_title = FND_API.G_MISS_CHAR THEN
2194 l_Line_price_att_rec.flex_title := p_old_Line_price_att_rec.flex_title;
2195 END IF;
2196
2197 IF l_Line_price_att_rec.header_id = FND_API.G_MISS_NUM THEN
2198 l_Line_price_att_rec.header_id := p_old_Line_price_att_rec.header_id;
2199 END IF;
2200
2201 IF l_Line_price_att_rec.last_updated_by = FND_API.G_MISS_NUM THEN
2202 l_Line_price_att_rec.last_updated_by := p_old_Line_price_att_rec.last_updated_by;
2203 END IF;
2204
2205 IF l_Line_price_att_rec.last_update_date = FND_API.G_MISS_DATE THEN
2206 l_Line_price_att_rec.last_update_date := p_old_Line_price_att_rec.last_update_date;
2207 END IF;
2208
2209 IF l_Line_price_att_rec.last_update_login = FND_API.G_MISS_NUM THEN
2210 l_Line_price_att_rec.last_update_login := p_old_Line_price_att_rec.last_update_login;
2211 END IF;
2212
2213 IF l_Line_price_att_rec.line_id = FND_API.G_MISS_NUM THEN
2214 l_Line_price_att_rec.line_id := p_old_Line_price_att_rec.line_id;
2215 END IF;
2216
2217 IF l_Line_price_att_rec.order_price_attrib_id = FND_API.G_MISS_NUM THEN
2218 l_Line_price_att_rec.order_price_attrib_id := p_old_Line_price_att_rec.order_price_attrib_id;
2219 END IF;
2220
2221 IF l_Line_price_att_rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
2222 l_Line_price_att_rec.pricing_attribute1 := p_old_Line_price_att_rec.pricing_attribute1;
2223 END IF;
2224
2225 IF l_Line_price_att_rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
2226 l_Line_price_att_rec.pricing_attribute10 := p_old_Line_price_att_rec.pricing_attribute10;
2227 END IF;
2228
2229 IF l_Line_price_att_rec.pricing_attribute100 = FND_API.G_MISS_CHAR THEN
2230 l_Line_price_att_rec.pricing_attribute100 := p_old_Line_price_att_rec.pricing_attribute100;
2231 END IF;
2232
2233 IF l_Line_price_att_rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN
2234 l_Line_price_att_rec.pricing_attribute11 := p_old_Line_price_att_rec.pricing_attribute11;
2235 END IF;
2236
2237 IF l_Line_price_att_rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN
2238 l_Line_price_att_rec.pricing_attribute12 := p_old_Line_price_att_rec.pricing_attribute12;
2239 END IF;
2240
2241 IF l_Line_price_att_rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN
2242 l_Line_price_att_rec.pricing_attribute13 := p_old_Line_price_att_rec.pricing_attribute13;
2243 END IF;
2244
2245 IF l_Line_price_att_rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN
2246 l_Line_price_att_rec.pricing_attribute14 := p_old_Line_price_att_rec.pricing_attribute14;
2247 END IF;
2248
2249 IF l_Line_price_att_rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN
2250 l_Line_price_att_rec.pricing_attribute15 := p_old_Line_price_att_rec.pricing_attribute15;
2251 END IF;
2252
2253 IF l_Line_price_att_rec.pricing_attribute16 = FND_API.G_MISS_CHAR THEN
2254 l_Line_price_att_rec.pricing_attribute16 := p_old_Line_price_att_rec.pricing_attribute16;
2255 END IF;
2256
2257 IF l_Line_price_att_rec.pricing_attribute17 = FND_API.G_MISS_CHAR THEN
2258 l_Line_price_att_rec.pricing_attribute17 := p_old_Line_price_att_rec.pricing_attribute17;
2259 END IF;
2260
2261 IF l_Line_price_att_rec.pricing_attribute18 = FND_API.G_MISS_CHAR THEN
2262 l_Line_price_att_rec.pricing_attribute18 := p_old_Line_price_att_rec.pricing_attribute18;
2263 END IF;
2264
2265 IF l_Line_price_att_rec.pricing_attribute19 = FND_API.G_MISS_CHAR THEN
2266 l_Line_price_att_rec.pricing_attribute19 := p_old_Line_price_att_rec.pricing_attribute19;
2267 END IF;
2268
2269 IF l_Line_price_att_rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
2270 l_Line_price_att_rec.pricing_attribute2 := p_old_Line_price_att_rec.pricing_attribute2;
2271 END IF;
2272
2273 IF l_Line_price_att_rec.pricing_attribute20 = FND_API.G_MISS_CHAR THEN
2274 l_Line_price_att_rec.pricing_attribute20 := p_old_Line_price_att_rec.pricing_attribute20;
2275 END IF;
2276
2277 IF l_Line_price_att_rec.pricing_attribute21 = FND_API.G_MISS_CHAR THEN
2278 l_Line_price_att_rec.pricing_attribute21 := p_old_Line_price_att_rec.pricing_attribute21;
2279 END IF;
2280
2281 IF l_Line_price_att_rec.pricing_attribute22 = FND_API.G_MISS_CHAR THEN
2282 l_Line_price_att_rec.pricing_attribute22 := p_old_Line_price_att_rec.pricing_attribute22;
2283 END IF;
2284
2285 IF l_Line_price_att_rec.pricing_attribute23 = FND_API.G_MISS_CHAR THEN
2286 l_Line_price_att_rec.pricing_attribute23 := p_old_Line_price_att_rec.pricing_attribute23;
2287 END IF;
2288
2289 IF l_Line_price_att_rec.pricing_attribute24 = FND_API.G_MISS_CHAR THEN
2290 l_Line_price_att_rec.pricing_attribute24 := p_old_Line_price_att_rec.pricing_attribute24;
2291 END IF;
2292
2293 IF l_Line_price_att_rec.pricing_attribute25 = FND_API.G_MISS_CHAR THEN
2294 l_Line_price_att_rec.pricing_attribute25 := p_old_Line_price_att_rec.pricing_attribute25;
2295 END IF;
2296
2297 IF l_Line_price_att_rec.pricing_attribute26 = FND_API.G_MISS_CHAR THEN
2298 l_Line_price_att_rec.pricing_attribute26 := p_old_Line_price_att_rec.pricing_attribute26;
2299 END IF;
2300
2301 IF l_Line_price_att_rec.pricing_attribute27 = FND_API.G_MISS_CHAR THEN
2302 l_Line_price_att_rec.pricing_attribute27 := p_old_Line_price_att_rec.pricing_attribute27;
2303 END IF;
2304
2305 IF l_Line_price_att_rec.pricing_attribute28 = FND_API.G_MISS_CHAR THEN
2306 l_Line_price_att_rec.pricing_attribute28 := p_old_Line_price_att_rec.pricing_attribute28;
2307 END IF;
2308
2309 IF l_Line_price_att_rec.pricing_attribute29 = FND_API.G_MISS_CHAR THEN
2310 l_Line_price_att_rec.pricing_attribute29 := p_old_Line_price_att_rec.pricing_attribute29;
2311 END IF;
2312
2313 IF l_Line_price_att_rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
2314 l_Line_price_att_rec.pricing_attribute3 := p_old_Line_price_att_rec.pricing_attribute3;
2315 END IF;
2316
2317 IF l_Line_price_att_rec.pricing_attribute30 = FND_API.G_MISS_CHAR THEN
2318 l_Line_price_att_rec.pricing_attribute30 := p_old_Line_price_att_rec.pricing_attribute30;
2319 END IF;
2320
2321 IF l_Line_price_att_rec.pricing_attribute31 = FND_API.G_MISS_CHAR THEN
2322 l_Line_price_att_rec.pricing_attribute31 := p_old_Line_price_att_rec.pricing_attribute31;
2323 END IF;
2324
2325 IF l_Line_price_att_rec.pricing_attribute32 = FND_API.G_MISS_CHAR THEN
2326 l_Line_price_att_rec.pricing_attribute32 := p_old_Line_price_att_rec.pricing_attribute32;
2327 END IF;
2328
2329 IF l_Line_price_att_rec.pricing_attribute33 = FND_API.G_MISS_CHAR THEN
2330 l_Line_price_att_rec.pricing_attribute33 := p_old_Line_price_att_rec.pricing_attribute33;
2331 END IF;
2332
2333 IF l_Line_price_att_rec.pricing_attribute34 = FND_API.G_MISS_CHAR THEN
2334 l_Line_price_att_rec.pricing_attribute34 := p_old_Line_price_att_rec.pricing_attribute34;
2335 END IF;
2336
2337 IF l_Line_price_att_rec.pricing_attribute35 = FND_API.G_MISS_CHAR THEN
2338 l_Line_price_att_rec.pricing_attribute35 := p_old_Line_price_att_rec.pricing_attribute35;
2339 END IF;
2340
2341 IF l_Line_price_att_rec.pricing_attribute36 = FND_API.G_MISS_CHAR THEN
2342 l_Line_price_att_rec.pricing_attribute36 := p_old_Line_price_att_rec.pricing_attribute36;
2343 END IF;
2344
2345 IF l_Line_price_att_rec.pricing_attribute37 = FND_API.G_MISS_CHAR THEN
2346 l_Line_price_att_rec.pricing_attribute37 := p_old_Line_price_att_rec.pricing_attribute37;
2347 END IF;
2348
2349 IF l_Line_price_att_rec.pricing_attribute38 = FND_API.G_MISS_CHAR THEN
2350 l_Line_price_att_rec.pricing_attribute38 := p_old_Line_price_att_rec.pricing_attribute38;
2351 END IF;
2352
2353 IF l_Line_price_att_rec.pricing_attribute39 = FND_API.G_MISS_CHAR THEN
2354 l_Line_price_att_rec.pricing_attribute39 := p_old_Line_price_att_rec.pricing_attribute39;
2355 END IF;
2356
2357 IF l_Line_price_att_rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
2358 l_Line_price_att_rec.pricing_attribute4 := p_old_Line_price_att_rec.pricing_attribute4;
2359 END IF;
2360
2361 IF l_Line_price_att_rec.pricing_attribute40 = FND_API.G_MISS_CHAR THEN
2362 l_Line_price_att_rec.pricing_attribute40 := p_old_Line_price_att_rec.pricing_attribute40;
2363 END IF;
2364
2365 IF l_Line_price_att_rec.pricing_attribute41 = FND_API.G_MISS_CHAR THEN
2366 l_Line_price_att_rec.pricing_attribute41 := p_old_Line_price_att_rec.pricing_attribute41;
2367 END IF;
2368
2369 IF l_Line_price_att_rec.pricing_attribute42 = FND_API.G_MISS_CHAR THEN
2370 l_Line_price_att_rec.pricing_attribute42 := p_old_Line_price_att_rec.pricing_attribute42;
2371 END IF;
2372
2373 IF l_Line_price_att_rec.pricing_attribute43 = FND_API.G_MISS_CHAR THEN
2374 l_Line_price_att_rec.pricing_attribute43 := p_old_Line_price_att_rec.pricing_attribute43;
2375 END IF;
2376
2377 IF l_Line_price_att_rec.pricing_attribute44 = FND_API.G_MISS_CHAR THEN
2378 l_Line_price_att_rec.pricing_attribute44 := p_old_Line_price_att_rec.pricing_attribute44;
2379 END IF;
2380
2381 IF l_Line_price_att_rec.pricing_attribute45 = FND_API.G_MISS_CHAR THEN
2382 l_Line_price_att_rec.pricing_attribute45 := p_old_Line_price_att_rec.pricing_attribute45;
2383 END IF;
2384
2385 IF l_Line_price_att_rec.pricing_attribute46 = FND_API.G_MISS_CHAR THEN
2386 l_Line_price_att_rec.pricing_attribute46 := p_old_Line_price_att_rec.pricing_attribute46;
2387 END IF;
2388
2389 IF l_Line_price_att_rec.pricing_attribute47 = FND_API.G_MISS_CHAR THEN
2390 l_Line_price_att_rec.pricing_attribute47 := p_old_Line_price_att_rec.pricing_attribute47;
2391 END IF;
2392
2393 IF l_Line_price_att_rec.pricing_attribute48 = FND_API.G_MISS_CHAR THEN
2394 l_Line_price_att_rec.pricing_attribute48 := p_old_Line_price_att_rec.pricing_attribute48;
2395 END IF;
2396
2397 IF l_Line_price_att_rec.pricing_attribute49 = FND_API.G_MISS_CHAR THEN
2398 l_Line_price_att_rec.pricing_attribute49 := p_old_Line_price_att_rec.pricing_attribute49;
2399 END IF;
2400
2401 IF l_Line_price_att_rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
2402 l_Line_price_att_rec.pricing_attribute5 := p_old_Line_price_att_rec.pricing_attribute5;
2403 END IF;
2404
2405 IF l_Line_price_att_rec.pricing_attribute50 = FND_API.G_MISS_CHAR THEN
2406 l_Line_price_att_rec.pricing_attribute50 := p_old_Line_price_att_rec.pricing_attribute50;
2407 END IF;
2408
2409 IF l_Line_price_att_rec.pricing_attribute51 = FND_API.G_MISS_CHAR THEN
2410 l_Line_price_att_rec.pricing_attribute51 := p_old_Line_price_att_rec.pricing_attribute51;
2411 END IF;
2412
2413 IF l_Line_price_att_rec.pricing_attribute52 = FND_API.G_MISS_CHAR THEN
2414 l_Line_price_att_rec.pricing_attribute52 := p_old_Line_price_att_rec.pricing_attribute52;
2415 END IF;
2416
2417 IF l_Line_price_att_rec.pricing_attribute53 = FND_API.G_MISS_CHAR THEN
2418 l_Line_price_att_rec.pricing_attribute53 := p_old_Line_price_att_rec.pricing_attribute53;
2419 END IF;
2420
2421 IF l_Line_price_att_rec.pricing_attribute54 = FND_API.G_MISS_CHAR THEN
2422 l_Line_price_att_rec.pricing_attribute54 := p_old_Line_price_att_rec.pricing_attribute54;
2423 END IF;
2424
2425 IF l_Line_price_att_rec.pricing_attribute55 = FND_API.G_MISS_CHAR THEN
2426 l_Line_price_att_rec.pricing_attribute55 := p_old_Line_price_att_rec.pricing_attribute55;
2427 END IF;
2428
2429 IF l_Line_price_att_rec.pricing_attribute56 = FND_API.G_MISS_CHAR THEN
2430 l_Line_price_att_rec.pricing_attribute56 := p_old_Line_price_att_rec.pricing_attribute56;
2431 END IF;
2432
2433 IF l_Line_price_att_rec.pricing_attribute57 = FND_API.G_MISS_CHAR THEN
2434 l_Line_price_att_rec.pricing_attribute57 := p_old_Line_price_att_rec.pricing_attribute57;
2435 END IF;
2436
2437 IF l_Line_price_att_rec.pricing_attribute58 = FND_API.G_MISS_CHAR THEN
2438 l_Line_price_att_rec.pricing_attribute58 := p_old_Line_price_att_rec.pricing_attribute58;
2439 END IF;
2440
2441 IF l_Line_price_att_rec.pricing_attribute59 = FND_API.G_MISS_CHAR THEN
2442 l_Line_price_att_rec.pricing_attribute59 := p_old_Line_price_att_rec.pricing_attribute59;
2443 END IF;
2444
2445 IF l_Line_price_att_rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
2446 l_Line_price_att_rec.pricing_attribute6 := p_old_Line_price_att_rec.pricing_attribute6;
2447 END IF;
2448
2449 IF l_Line_price_att_rec.pricing_attribute60 = FND_API.G_MISS_CHAR THEN
2450 l_Line_price_att_rec.pricing_attribute60 := p_old_Line_price_att_rec.pricing_attribute60;
2451 END IF;
2452
2453 IF l_Line_price_att_rec.pricing_attribute61 = FND_API.G_MISS_CHAR THEN
2454 l_Line_price_att_rec.pricing_attribute61 := p_old_Line_price_att_rec.pricing_attribute61;
2455 END IF;
2456
2457 IF l_Line_price_att_rec.pricing_attribute62 = FND_API.G_MISS_CHAR THEN
2458 l_Line_price_att_rec.pricing_attribute62 := p_old_Line_price_att_rec.pricing_attribute62;
2459 END IF;
2460
2461 IF l_Line_price_att_rec.pricing_attribute63 = FND_API.G_MISS_CHAR THEN
2462 l_Line_price_att_rec.pricing_attribute63 := p_old_Line_price_att_rec.pricing_attribute63;
2463 END IF;
2464
2465 IF l_Line_price_att_rec.pricing_attribute64 = FND_API.G_MISS_CHAR THEN
2466 l_Line_price_att_rec.pricing_attribute64 := p_old_Line_price_att_rec.pricing_attribute64;
2467 END IF;
2468
2469 IF l_Line_price_att_rec.pricing_attribute65 = FND_API.G_MISS_CHAR THEN
2470 l_Line_price_att_rec.pricing_attribute65 := p_old_Line_price_att_rec.pricing_attribute65;
2471 END IF;
2472
2473 IF l_Line_price_att_rec.pricing_attribute66 = FND_API.G_MISS_CHAR THEN
2474 l_Line_price_att_rec.pricing_attribute66 := p_old_Line_price_att_rec.pricing_attribute66;
2475 END IF;
2476
2477 IF l_Line_price_att_rec.pricing_attribute67 = FND_API.G_MISS_CHAR THEN
2478 l_Line_price_att_rec.pricing_attribute67 := p_old_Line_price_att_rec.pricing_attribute67;
2479 END IF;
2480
2481 IF l_Line_price_att_rec.pricing_attribute68 = FND_API.G_MISS_CHAR THEN
2482 l_Line_price_att_rec.pricing_attribute68 := p_old_Line_price_att_rec.pricing_attribute68;
2483 END IF;
2484
2485 IF l_Line_price_att_rec.pricing_attribute69 = FND_API.G_MISS_CHAR THEN
2486 l_Line_price_att_rec.pricing_attribute69 := p_old_Line_price_att_rec.pricing_attribute69;
2487 END IF;
2488
2489 IF l_Line_price_att_rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
2490 l_Line_price_att_rec.pricing_attribute7 := p_old_Line_price_att_rec.pricing_attribute7;
2491 END IF;
2492
2493 IF l_Line_price_att_rec.pricing_attribute70 = FND_API.G_MISS_CHAR THEN
2494 l_Line_price_att_rec.pricing_attribute70 := p_old_Line_price_att_rec.pricing_attribute70;
2495 END IF;
2496
2497 IF l_Line_price_att_rec.pricing_attribute71 = FND_API.G_MISS_CHAR THEN
2498 l_Line_price_att_rec.pricing_attribute71 := p_old_Line_price_att_rec.pricing_attribute71;
2499 END IF;
2500
2501 IF l_Line_price_att_rec.pricing_attribute72 = FND_API.G_MISS_CHAR THEN
2502 l_Line_price_att_rec.pricing_attribute72 := p_old_Line_price_att_rec.pricing_attribute72;
2503 END IF;
2504
2505 IF l_Line_price_att_rec.pricing_attribute73 = FND_API.G_MISS_CHAR THEN
2506 l_Line_price_att_rec.pricing_attribute73 := p_old_Line_price_att_rec.pricing_attribute73;
2507 END IF;
2508
2509 IF l_Line_price_att_rec.pricing_attribute74 = FND_API.G_MISS_CHAR THEN
2510 l_Line_price_att_rec.pricing_attribute74 := p_old_Line_price_att_rec.pricing_attribute74;
2511 END IF;
2512
2513 IF l_Line_price_att_rec.pricing_attribute75 = FND_API.G_MISS_CHAR THEN
2514 l_Line_price_att_rec.pricing_attribute75 := p_old_Line_price_att_rec.pricing_attribute75;
2515 END IF;
2516
2517 IF l_Line_price_att_rec.pricing_attribute76 = FND_API.G_MISS_CHAR THEN
2518 l_Line_price_att_rec.pricing_attribute76 := p_old_Line_price_att_rec.pricing_attribute76;
2519 END IF;
2520
2521 IF l_Line_price_att_rec.pricing_attribute77 = FND_API.G_MISS_CHAR THEN
2522 l_Line_price_att_rec.pricing_attribute77 := p_old_Line_price_att_rec.pricing_attribute77;
2523 END IF;
2524
2525 IF l_Line_price_att_rec.pricing_attribute78 = FND_API.G_MISS_CHAR THEN
2526 l_Line_price_att_rec.pricing_attribute78 := p_old_Line_price_att_rec.pricing_attribute78;
2527 END IF;
2528
2529 IF l_Line_price_att_rec.pricing_attribute79 = FND_API.G_MISS_CHAR THEN
2530 l_Line_price_att_rec.pricing_attribute79 := p_old_Line_price_att_rec.pricing_attribute79;
2531 END IF;
2532
2533 IF l_Line_price_att_rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
2534 l_Line_price_att_rec.pricing_attribute8 := p_old_Line_price_att_rec.pricing_attribute8;
2535 END IF;
2536
2537 IF l_Line_price_att_rec.pricing_attribute80 = FND_API.G_MISS_CHAR THEN
2538 l_Line_price_att_rec.pricing_attribute80 := p_old_Line_price_att_rec.pricing_attribute80;
2539 END IF;
2540
2541 IF l_Line_price_att_rec.pricing_attribute81 = FND_API.G_MISS_CHAR THEN
2542 l_Line_price_att_rec.pricing_attribute81 := p_old_Line_price_att_rec.pricing_attribute81;
2543 END IF;
2544
2545 IF l_Line_price_att_rec.pricing_attribute82 = FND_API.G_MISS_CHAR THEN
2546 l_Line_price_att_rec.pricing_attribute82 := p_old_Line_price_att_rec.pricing_attribute82;
2547 END IF;
2548
2549 IF l_Line_price_att_rec.pricing_attribute83 = FND_API.G_MISS_CHAR THEN
2550 l_Line_price_att_rec.pricing_attribute83 := p_old_Line_price_att_rec.pricing_attribute83;
2551 END IF;
2552
2553 IF l_Line_price_att_rec.pricing_attribute84 = FND_API.G_MISS_CHAR THEN
2554 l_Line_price_att_rec.pricing_attribute84 := p_old_Line_price_att_rec.pricing_attribute84;
2555 END IF;
2556
2557 IF l_Line_price_att_rec.pricing_attribute85 = FND_API.G_MISS_CHAR THEN
2558 l_Line_price_att_rec.pricing_attribute85 := p_old_Line_price_att_rec.pricing_attribute85;
2559 END IF;
2560
2561 IF l_Line_price_att_rec.pricing_attribute86 = FND_API.G_MISS_CHAR THEN
2562 l_Line_price_att_rec.pricing_attribute86 := p_old_Line_price_att_rec.pricing_attribute86;
2563 END IF;
2564
2565 IF l_Line_price_att_rec.pricing_attribute87 = FND_API.G_MISS_CHAR THEN
2566 l_Line_price_att_rec.pricing_attribute87 := p_old_Line_price_att_rec.pricing_attribute87;
2567 END IF;
2568
2569 IF l_Line_price_att_rec.pricing_attribute88 = FND_API.G_MISS_CHAR THEN
2570 l_Line_price_att_rec.pricing_attribute88 := p_old_Line_price_att_rec.pricing_attribute88;
2571 END IF;
2572
2573 IF l_Line_price_att_rec.pricing_attribute89 = FND_API.G_MISS_CHAR THEN
2574 l_Line_price_att_rec.pricing_attribute89 := p_old_Line_price_att_rec.pricing_attribute89;
2575 END IF;
2576
2577 IF l_Line_price_att_rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
2578 l_Line_price_att_rec.pricing_attribute9 := p_old_Line_price_att_rec.pricing_attribute9;
2579 END IF;
2580
2581 IF l_Line_price_att_rec.pricing_attribute90 = FND_API.G_MISS_CHAR THEN
2582 l_Line_price_att_rec.pricing_attribute90 := p_old_Line_price_att_rec.pricing_attribute90;
2583 END IF;
2584
2585 IF l_Line_price_att_rec.pricing_attribute91 = FND_API.G_MISS_CHAR THEN
2586 l_Line_price_att_rec.pricing_attribute91 := p_old_Line_price_att_rec.pricing_attribute91;
2587 END IF;
2588
2589 IF l_Line_price_att_rec.pricing_attribute92 = FND_API.G_MISS_CHAR THEN
2590 l_Line_price_att_rec.pricing_attribute92 := p_old_Line_price_att_rec.pricing_attribute92;
2591 END IF;
2592
2593 IF l_Line_price_att_rec.pricing_attribute93 = FND_API.G_MISS_CHAR THEN
2594 l_Line_price_att_rec.pricing_attribute93 := p_old_Line_price_att_rec.pricing_attribute93;
2595 END IF;
2596
2597 IF l_Line_price_att_rec.pricing_attribute94 = FND_API.G_MISS_CHAR THEN
2598 l_Line_price_att_rec.pricing_attribute94 := p_old_Line_price_att_rec.pricing_attribute94;
2599 END IF;
2600
2601 IF l_Line_price_att_rec.pricing_attribute95 = FND_API.G_MISS_CHAR THEN
2602 l_Line_price_att_rec.pricing_attribute95 := p_old_Line_price_att_rec.pricing_attribute95;
2603 END IF;
2604
2605 IF l_Line_price_att_rec.pricing_attribute96 = FND_API.G_MISS_CHAR THEN
2606 l_Line_price_att_rec.pricing_attribute96 := p_old_Line_price_att_rec.pricing_attribute96;
2607 END IF;
2608
2609 IF l_Line_price_att_rec.pricing_attribute97 = FND_API.G_MISS_CHAR THEN
2610 l_Line_price_att_rec.pricing_attribute97 := p_old_Line_price_att_rec.pricing_attribute97;
2611 END IF;
2612
2613 IF l_Line_price_att_rec.pricing_attribute98 = FND_API.G_MISS_CHAR THEN
2614 l_Line_price_att_rec.pricing_attribute98 := p_old_Line_price_att_rec.pricing_attribute98;
2615 END IF;
2616
2617 IF l_Line_price_att_rec.pricing_attribute99 = FND_API.G_MISS_CHAR THEN
2618 l_Line_price_att_rec.pricing_attribute99 := p_old_Line_price_att_rec.pricing_attribute99;
2619 END IF;
2620
2621 IF l_Line_price_att_rec.pricing_context = FND_API.G_MISS_CHAR THEN
2622 l_Line_price_att_rec.pricing_context := p_old_Line_price_att_rec.pricing_context;
2623 END IF;
2624
2625 IF l_Line_price_att_rec.program_application_id = FND_API.G_MISS_NUM THEN
2626 l_Line_price_att_rec.program_application_id := p_old_Line_price_att_rec.program_application_id;
2627 END IF;
2628
2629 IF l_Line_price_att_rec.program_id = FND_API.G_MISS_NUM THEN
2630 l_Line_price_att_rec.program_id := p_old_Line_price_att_rec.program_id;
2631 END IF;
2632
2633 IF l_Line_price_att_rec.program_update_date = FND_API.G_MISS_DATE THEN
2634 l_Line_price_att_rec.program_update_date := p_old_Line_price_att_rec.program_update_date;
2635 END IF;
2636
2637 IF l_Line_price_att_rec.request_id = FND_API.G_MISS_NUM THEN
2638 l_Line_price_att_rec.request_id := p_old_Line_price_att_rec.request_id;
2639 END IF;
2640
2641 IF l_Line_price_att_rec.orig_sys_atts_ref = FND_API.G_MISS_CHAR THEN
2642 l_Line_price_att_rec.orig_sys_atts_ref := p_old_Line_price_att_rec.orig_sys_atts_ref;
2643 END IF;
2644 -- RETURN l_Line_price_att_rec;
2645 p_x_Line_price_att_rec := l_Line_price_att_rec;
2646
2647 END Complete_Record;
2648
2649 PROCEDURE Convert_Miss_To_Null
2650 ( p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
2651 )
2652 IS
2653 l_Line_price_att_rec OE_Order_PUB.Line_Price_Att_Rec_Type := p_x_Line_Price_Att_rec;
2654 BEGIN
2655
2656 IF l_Line_price_att_rec.override_flag = FND_API.G_MISS_CHAR THEN
2657 l_Line_price_att_rec.override_flag := NULL;
2658 END IF;
2659
2660 IF l_Line_price_att_rec.attribute1 = FND_API.G_MISS_CHAR THEN
2661 l_Line_price_att_rec.attribute1 := NULL;
2662 END IF;
2663
2664 IF l_Line_price_att_rec.attribute10 = FND_API.G_MISS_CHAR THEN
2665 l_Line_price_att_rec.attribute10 := NULL;
2666 END IF;
2667
2668 IF l_Line_price_att_rec.attribute11 = FND_API.G_MISS_CHAR THEN
2669 l_Line_price_att_rec.attribute11 := NULL;
2670 END IF;
2671
2672 IF l_Line_price_att_rec.attribute12 = FND_API.G_MISS_CHAR THEN
2673 l_Line_price_att_rec.attribute12 := NULL;
2674 END IF;
2675
2676 IF l_Line_price_att_rec.attribute13 = FND_API.G_MISS_CHAR THEN
2677 l_Line_price_att_rec.attribute13 := NULL;
2678 END IF;
2679
2680 IF l_Line_price_att_rec.attribute14 = FND_API.G_MISS_CHAR THEN
2681 l_Line_price_att_rec.attribute14 := NULL;
2682 END IF;
2683
2684 IF l_Line_price_att_rec.attribute15 = FND_API.G_MISS_CHAR THEN
2685 l_Line_price_att_rec.attribute15 := NULL;
2686 END IF;
2687
2688 IF l_Line_price_att_rec.attribute2 = FND_API.G_MISS_CHAR THEN
2689 l_Line_price_att_rec.attribute2 := NULL;
2690 END IF;
2691
2692 IF l_Line_price_att_rec.attribute3 = FND_API.G_MISS_CHAR THEN
2693 l_Line_price_att_rec.attribute3 := NULL;
2694 END IF;
2695
2696 IF l_Line_price_att_rec.attribute4 = FND_API.G_MISS_CHAR THEN
2697 l_Line_price_att_rec.attribute4 := NULL;
2698 END IF;
2699
2700 IF l_Line_price_att_rec.attribute5 = FND_API.G_MISS_CHAR THEN
2701 l_Line_price_att_rec.attribute5 := NULL;
2702 END IF;
2703
2704 IF l_Line_price_att_rec.attribute6 = FND_API.G_MISS_CHAR THEN
2705 l_Line_price_att_rec.attribute6 := NULL;
2706 END IF;
2707
2708 IF l_Line_price_att_rec.attribute7 = FND_API.G_MISS_CHAR THEN
2709 l_Line_price_att_rec.attribute7 := NULL;
2710 END IF;
2711
2712 IF l_Line_price_att_rec.attribute8 = FND_API.G_MISS_CHAR THEN
2713 l_Line_price_att_rec.attribute8 := NULL;
2714 END IF;
2715
2716 IF l_Line_price_att_rec.attribute9 = FND_API.G_MISS_CHAR THEN
2717 l_Line_price_att_rec.attribute9 := NULL;
2718 END IF;
2719
2720 IF l_Line_price_att_rec.context = FND_API.G_MISS_CHAR THEN
2721 l_Line_price_att_rec.context := NULL;
2722 END IF;
2723
2724 IF l_Line_price_att_rec.created_by = FND_API.G_MISS_NUM THEN
2725 l_Line_price_att_rec.created_by := NULL;
2726 END IF;
2727
2728 IF l_Line_price_att_rec.creation_date = FND_API.G_MISS_DATE THEN
2729 l_Line_price_att_rec.creation_date := NULL;
2730 END IF;
2731
2732 IF l_Line_price_att_rec.flex_title = FND_API.G_MISS_CHAR THEN
2733 l_Line_price_att_rec.flex_title := NULL;
2734 END IF;
2735
2736 IF l_Line_price_att_rec.header_id = FND_API.G_MISS_NUM THEN
2737 l_Line_price_att_rec.header_id := NULL;
2738 END IF;
2739
2740 IF l_Line_price_att_rec.last_updated_by = FND_API.G_MISS_NUM THEN
2741 l_Line_price_att_rec.last_updated_by := NULL;
2742 END IF;
2743
2744 IF l_Line_price_att_rec.last_update_date = FND_API.G_MISS_DATE THEN
2745 l_Line_price_att_rec.last_update_date := NULL;
2746 END IF;
2747
2748 IF l_Line_price_att_rec.last_update_login = FND_API.G_MISS_NUM THEN
2749 l_Line_price_att_rec.last_update_login := NULL;
2750 END IF;
2751
2752 IF l_Line_price_att_rec.line_id = FND_API.G_MISS_NUM THEN
2753 l_Line_price_att_rec.line_id := NULL;
2754 END IF;
2755
2756 IF l_Line_price_att_rec.order_price_attrib_id = FND_API.G_MISS_NUM THEN
2757 l_Line_price_att_rec.order_price_attrib_id := NULL;
2758 END IF;
2759
2760 IF l_Line_price_att_rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
2761 l_Line_price_att_rec.pricing_attribute1 := NULL;
2762 END IF;
2763
2764 IF l_Line_price_att_rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
2765 l_Line_price_att_rec.pricing_attribute10 := NULL;
2766 END IF;
2767
2768 IF l_Line_price_att_rec.pricing_attribute100 = FND_API.G_MISS_CHAR THEN
2769 l_Line_price_att_rec.pricing_attribute100 := NULL;
2770 END IF;
2771
2772 IF l_Line_price_att_rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN
2773 l_Line_price_att_rec.pricing_attribute11 := NULL;
2774 END IF;
2775
2776 IF l_Line_price_att_rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN
2777 l_Line_price_att_rec.pricing_attribute12 := NULL;
2778 END IF;
2779
2780 IF l_Line_price_att_rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN
2781 l_Line_price_att_rec.pricing_attribute13 := NULL;
2782 END IF;
2783
2784 IF l_Line_price_att_rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN
2785 l_Line_price_att_rec.pricing_attribute14 := NULL;
2786 END IF;
2787
2788 IF l_Line_price_att_rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN
2789 l_Line_price_att_rec.pricing_attribute15 := NULL;
2790 END IF;
2791
2792 IF l_Line_price_att_rec.pricing_attribute16 = FND_API.G_MISS_CHAR THEN
2793 l_Line_price_att_rec.pricing_attribute16 := NULL;
2794 END IF;
2795
2796 IF l_Line_price_att_rec.pricing_attribute17 = FND_API.G_MISS_CHAR THEN
2797 l_Line_price_att_rec.pricing_attribute17 := NULL;
2798 END IF;
2799
2800 IF l_Line_price_att_rec.pricing_attribute18 = FND_API.G_MISS_CHAR THEN
2801 l_Line_price_att_rec.pricing_attribute18 := NULL;
2802 END IF;
2803
2804 IF l_Line_price_att_rec.pricing_attribute19 = FND_API.G_MISS_CHAR THEN
2805 l_Line_price_att_rec.pricing_attribute19 := NULL;
2806 END IF;
2807
2808 IF l_Line_price_att_rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
2809 l_Line_price_att_rec.pricing_attribute2 := NULL;
2810 END IF;
2811
2812 IF l_Line_price_att_rec.pricing_attribute20 = FND_API.G_MISS_CHAR THEN
2813 l_Line_price_att_rec.pricing_attribute20 := NULL;
2814 END IF;
2815
2816 IF l_Line_price_att_rec.pricing_attribute21 = FND_API.G_MISS_CHAR THEN
2817 l_Line_price_att_rec.pricing_attribute21 := NULL;
2818 END IF;
2819
2820 IF l_Line_price_att_rec.pricing_attribute22 = FND_API.G_MISS_CHAR THEN
2821 l_Line_price_att_rec.pricing_attribute22 := NULL;
2822 END IF;
2823
2824 IF l_Line_price_att_rec.pricing_attribute23 = FND_API.G_MISS_CHAR THEN
2825 l_Line_price_att_rec.pricing_attribute23 := NULL;
2826 END IF;
2827
2828 IF l_Line_price_att_rec.pricing_attribute24 = FND_API.G_MISS_CHAR THEN
2829 l_Line_price_att_rec.pricing_attribute24 := NULL;
2830 END IF;
2831
2832 IF l_Line_price_att_rec.pricing_attribute25 = FND_API.G_MISS_CHAR THEN
2833 l_Line_price_att_rec.pricing_attribute25 := NULL;
2834 END IF;
2835
2836 IF l_Line_price_att_rec.pricing_attribute26 = FND_API.G_MISS_CHAR THEN
2837 l_Line_price_att_rec.pricing_attribute26 := NULL;
2838 END IF;
2839
2840 IF l_Line_price_att_rec.pricing_attribute27 = FND_API.G_MISS_CHAR THEN
2841 l_Line_price_att_rec.pricing_attribute27 := NULL;
2842 END IF;
2843
2844 IF l_Line_price_att_rec.pricing_attribute28 = FND_API.G_MISS_CHAR THEN
2845 l_Line_price_att_rec.pricing_attribute28 := NULL;
2846 END IF;
2847
2848 IF l_Line_price_att_rec.pricing_attribute29 = FND_API.G_MISS_CHAR THEN
2849 l_Line_price_att_rec.pricing_attribute29 := NULL;
2850 END IF;
2851
2852 IF l_Line_price_att_rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
2853 l_Line_price_att_rec.pricing_attribute3 := NULL;
2854 END IF;
2855
2856 IF l_Line_price_att_rec.pricing_attribute30 = FND_API.G_MISS_CHAR THEN
2857 l_Line_price_att_rec.pricing_attribute30 := NULL;
2858 END IF;
2859
2860 IF l_Line_price_att_rec.pricing_attribute31 = FND_API.G_MISS_CHAR THEN
2861 l_Line_price_att_rec.pricing_attribute31 := NULL;
2862 END IF;
2863
2864 IF l_Line_price_att_rec.pricing_attribute32 = FND_API.G_MISS_CHAR THEN
2865 l_Line_price_att_rec.pricing_attribute32 := NULL;
2866 END IF;
2867
2868 IF l_Line_price_att_rec.pricing_attribute33 = FND_API.G_MISS_CHAR THEN
2869 l_Line_price_att_rec.pricing_attribute33 := NULL;
2870 END IF;
2871
2872 IF l_Line_price_att_rec.pricing_attribute34 = FND_API.G_MISS_CHAR THEN
2873 l_Line_price_att_rec.pricing_attribute34 := NULL;
2874 END IF;
2875
2876 IF l_Line_price_att_rec.pricing_attribute35 = FND_API.G_MISS_CHAR THEN
2877 l_Line_price_att_rec.pricing_attribute35 := NULL;
2878 END IF;
2879
2880 IF l_Line_price_att_rec.pricing_attribute36 = FND_API.G_MISS_CHAR THEN
2881 l_Line_price_att_rec.pricing_attribute36 := NULL;
2882 END IF;
2883
2884 IF l_Line_price_att_rec.pricing_attribute37 = FND_API.G_MISS_CHAR THEN
2885 l_Line_price_att_rec.pricing_attribute37 := NULL;
2886 END IF;
2887
2888 IF l_Line_price_att_rec.pricing_attribute38 = FND_API.G_MISS_CHAR THEN
2889 l_Line_price_att_rec.pricing_attribute38 := NULL;
2890 END IF;
2891
2892 IF l_Line_price_att_rec.pricing_attribute39 = FND_API.G_MISS_CHAR THEN
2893 l_Line_price_att_rec.pricing_attribute39 := NULL;
2894 END IF;
2895
2896 IF l_Line_price_att_rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
2897 l_Line_price_att_rec.pricing_attribute4 := NULL;
2898 END IF;
2899
2900 IF l_Line_price_att_rec.pricing_attribute40 = FND_API.G_MISS_CHAR THEN
2901 l_Line_price_att_rec.pricing_attribute40 := NULL;
2902 END IF;
2903
2904 IF l_Line_price_att_rec.pricing_attribute41 = FND_API.G_MISS_CHAR THEN
2905 l_Line_price_att_rec.pricing_attribute41 := NULL;
2906 END IF;
2907
2908 IF l_Line_price_att_rec.pricing_attribute42 = FND_API.G_MISS_CHAR THEN
2909 l_Line_price_att_rec.pricing_attribute42 := NULL;
2910 END IF;
2911
2912 IF l_Line_price_att_rec.pricing_attribute43 = FND_API.G_MISS_CHAR THEN
2913 l_Line_price_att_rec.pricing_attribute43 := NULL;
2914 END IF;
2915
2916 IF l_Line_price_att_rec.pricing_attribute44 = FND_API.G_MISS_CHAR THEN
2917 l_Line_price_att_rec.pricing_attribute44 := NULL;
2918 END IF;
2919
2920 IF l_Line_price_att_rec.pricing_attribute45 = FND_API.G_MISS_CHAR THEN
2921 l_Line_price_att_rec.pricing_attribute45 := NULL;
2922 END IF;
2923
2924 IF l_Line_price_att_rec.pricing_attribute46 = FND_API.G_MISS_CHAR THEN
2925 l_Line_price_att_rec.pricing_attribute46 := NULL;
2926 END IF;
2927
2928 IF l_Line_price_att_rec.pricing_attribute47 = FND_API.G_MISS_CHAR THEN
2929 l_Line_price_att_rec.pricing_attribute47 := NULL;
2930 END IF;
2931
2932 IF l_Line_price_att_rec.pricing_attribute48 = FND_API.G_MISS_CHAR THEN
2933 l_Line_price_att_rec.pricing_attribute48 := NULL;
2934 END IF;
2935
2936 IF l_Line_price_att_rec.pricing_attribute49 = FND_API.G_MISS_CHAR THEN
2937 l_Line_price_att_rec.pricing_attribute49 := NULL;
2938 END IF;
2939
2940 IF l_Line_price_att_rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
2941 l_Line_price_att_rec.pricing_attribute5 := NULL;
2942 END IF;
2943
2944 IF l_Line_price_att_rec.pricing_attribute50 = FND_API.G_MISS_CHAR THEN
2945 l_Line_price_att_rec.pricing_attribute50 := NULL;
2946 END IF;
2947
2948 IF l_Line_price_att_rec.pricing_attribute51 = FND_API.G_MISS_CHAR THEN
2949 l_Line_price_att_rec.pricing_attribute51 := NULL;
2950 END IF;
2951
2952 IF l_Line_price_att_rec.pricing_attribute52 = FND_API.G_MISS_CHAR THEN
2953 l_Line_price_att_rec.pricing_attribute52 := NULL;
2954 END IF;
2955
2956 IF l_Line_price_att_rec.pricing_attribute53 = FND_API.G_MISS_CHAR THEN
2957 l_Line_price_att_rec.pricing_attribute53 := NULL;
2958 END IF;
2959
2960 IF l_Line_price_att_rec.pricing_attribute54 = FND_API.G_MISS_CHAR THEN
2961 l_Line_price_att_rec.pricing_attribute54 := NULL;
2962 END IF;
2963
2964 IF l_Line_price_att_rec.pricing_attribute55 = FND_API.G_MISS_CHAR THEN
2965 l_Line_price_att_rec.pricing_attribute55 := NULL;
2966 END IF;
2967
2968 IF l_Line_price_att_rec.pricing_attribute56 = FND_API.G_MISS_CHAR THEN
2969 l_Line_price_att_rec.pricing_attribute56 := NULL;
2970 END IF;
2971
2972 IF l_Line_price_att_rec.pricing_attribute57 = FND_API.G_MISS_CHAR THEN
2973 l_Line_price_att_rec.pricing_attribute57 := NULL;
2974 END IF;
2975
2976 IF l_Line_price_att_rec.pricing_attribute58 = FND_API.G_MISS_CHAR THEN
2977 l_Line_price_att_rec.pricing_attribute58 := NULL;
2978 END IF;
2979
2980 IF l_Line_price_att_rec.pricing_attribute59 = FND_API.G_MISS_CHAR THEN
2981 l_Line_price_att_rec.pricing_attribute59 := NULL;
2982 END IF;
2983
2984 IF l_Line_price_att_rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
2985 l_Line_price_att_rec.pricing_attribute6 := NULL;
2986 END IF;
2987
2988 IF l_Line_price_att_rec.pricing_attribute60 = FND_API.G_MISS_CHAR THEN
2989 l_Line_price_att_rec.pricing_attribute60 := NULL;
2990 END IF;
2991
2992 IF l_Line_price_att_rec.pricing_attribute61 = FND_API.G_MISS_CHAR THEN
2993 l_Line_price_att_rec.pricing_attribute61 := NULL;
2994 END IF;
2995
2996 IF l_Line_price_att_rec.pricing_attribute62 = FND_API.G_MISS_CHAR THEN
2997 l_Line_price_att_rec.pricing_attribute62 := NULL;
2998 END IF;
2999
3000 IF l_Line_price_att_rec.pricing_attribute63 = FND_API.G_MISS_CHAR THEN
3001 l_Line_price_att_rec.pricing_attribute63 := NULL;
3002 END IF;
3003
3004 IF l_Line_price_att_rec.pricing_attribute64 = FND_API.G_MISS_CHAR THEN
3005 l_Line_price_att_rec.pricing_attribute64 := NULL;
3006 END IF;
3007
3008 IF l_Line_price_att_rec.pricing_attribute65 = FND_API.G_MISS_CHAR THEN
3009 l_Line_price_att_rec.pricing_attribute65 := NULL;
3010 END IF;
3011
3012 IF l_Line_price_att_rec.pricing_attribute66 = FND_API.G_MISS_CHAR THEN
3013 l_Line_price_att_rec.pricing_attribute66 := NULL;
3014 END IF;
3015
3016 IF l_Line_price_att_rec.pricing_attribute67 = FND_API.G_MISS_CHAR THEN
3017 l_Line_price_att_rec.pricing_attribute67 := NULL;
3018 END IF;
3019
3020 IF l_Line_price_att_rec.pricing_attribute68 = FND_API.G_MISS_CHAR THEN
3021 l_Line_price_att_rec.pricing_attribute68 := NULL;
3022 END IF;
3023
3024 IF l_Line_price_att_rec.pricing_attribute69 = FND_API.G_MISS_CHAR THEN
3025 l_Line_price_att_rec.pricing_attribute69 := NULL;
3026 END IF;
3027
3028 IF l_Line_price_att_rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
3029 l_Line_price_att_rec.pricing_attribute7 := NULL;
3030 END IF;
3031
3032 IF l_Line_price_att_rec.pricing_attribute70 = FND_API.G_MISS_CHAR THEN
3033 l_Line_price_att_rec.pricing_attribute70 := NULL;
3034 END IF;
3035
3036 IF l_Line_price_att_rec.pricing_attribute71 = FND_API.G_MISS_CHAR THEN
3037 l_Line_price_att_rec.pricing_attribute71 := NULL;
3038 END IF;
3039
3040 IF l_Line_price_att_rec.pricing_attribute72 = FND_API.G_MISS_CHAR THEN
3041 l_Line_price_att_rec.pricing_attribute72 := NULL;
3042 END IF;
3043
3044 IF l_Line_price_att_rec.pricing_attribute73 = FND_API.G_MISS_CHAR THEN
3045 l_Line_price_att_rec.pricing_attribute73 := NULL;
3046 END IF;
3047
3048 IF l_Line_price_att_rec.pricing_attribute74 = FND_API.G_MISS_CHAR THEN
3049 l_Line_price_att_rec.pricing_attribute74 := NULL;
3050 END IF;
3051
3052 IF l_Line_price_att_rec.pricing_attribute75 = FND_API.G_MISS_CHAR THEN
3053 l_Line_price_att_rec.pricing_attribute75 := NULL;
3054 END IF;
3055
3056 IF l_Line_price_att_rec.pricing_attribute76 = FND_API.G_MISS_CHAR THEN
3057 l_Line_price_att_rec.pricing_attribute76 := NULL;
3058 END IF;
3059
3060 IF l_Line_price_att_rec.pricing_attribute77 = FND_API.G_MISS_CHAR THEN
3061 l_Line_price_att_rec.pricing_attribute77 := NULL;
3062 END IF;
3063
3064 IF l_Line_price_att_rec.pricing_attribute78 = FND_API.G_MISS_CHAR THEN
3065 l_Line_price_att_rec.pricing_attribute78 := NULL;
3066 END IF;
3067
3068 IF l_Line_price_att_rec.pricing_attribute79 = FND_API.G_MISS_CHAR THEN
3069 l_Line_price_att_rec.pricing_attribute79 := NULL;
3070 END IF;
3071
3072 IF l_Line_price_att_rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
3073 l_Line_price_att_rec.pricing_attribute8 := NULL;
3074 END IF;
3075
3076 IF l_Line_price_att_rec.pricing_attribute80 = FND_API.G_MISS_CHAR THEN
3077 l_Line_price_att_rec.pricing_attribute80 := NULL;
3078 END IF;
3079
3080 IF l_Line_price_att_rec.pricing_attribute81 = FND_API.G_MISS_CHAR THEN
3081 l_Line_price_att_rec.pricing_attribute81 := NULL;
3082 END IF;
3083
3084 IF l_Line_price_att_rec.pricing_attribute82 = FND_API.G_MISS_CHAR THEN
3085 l_Line_price_att_rec.pricing_attribute82 := NULL;
3086 END IF;
3087
3088 IF l_Line_price_att_rec.pricing_attribute83 = FND_API.G_MISS_CHAR THEN
3089 l_Line_price_att_rec.pricing_attribute83 := NULL;
3090 END IF;
3091
3092 IF l_Line_price_att_rec.pricing_attribute84 = FND_API.G_MISS_CHAR THEN
3093 l_Line_price_att_rec.pricing_attribute84 := NULL;
3094 END IF;
3095
3096 IF l_Line_price_att_rec.pricing_attribute85 = FND_API.G_MISS_CHAR THEN
3097 l_Line_price_att_rec.pricing_attribute85 := NULL;
3098 END IF;
3099
3100 IF l_Line_price_att_rec.pricing_attribute86 = FND_API.G_MISS_CHAR THEN
3101 l_Line_price_att_rec.pricing_attribute86 := NULL;
3102 END IF;
3103
3104 IF l_Line_price_att_rec.pricing_attribute87 = FND_API.G_MISS_CHAR THEN
3105 l_Line_price_att_rec.pricing_attribute87 := NULL;
3106 END IF;
3107
3108 IF l_Line_price_att_rec.pricing_attribute88 = FND_API.G_MISS_CHAR THEN
3109 l_Line_price_att_rec.pricing_attribute88 := NULL;
3110 END IF;
3111
3112 IF l_Line_price_att_rec.pricing_attribute89 = FND_API.G_MISS_CHAR THEN
3113 l_Line_price_att_rec.pricing_attribute89 := NULL;
3114 END IF;
3115
3116 IF l_Line_price_att_rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
3117 l_Line_price_att_rec.pricing_attribute9 := NULL;
3118 END IF;
3119
3120 IF l_Line_price_att_rec.pricing_attribute90 = FND_API.G_MISS_CHAR THEN
3121 l_Line_price_att_rec.pricing_attribute90 := NULL;
3122 END IF;
3123
3124 IF l_Line_price_att_rec.pricing_attribute91 = FND_API.G_MISS_CHAR THEN
3125 l_Line_price_att_rec.pricing_attribute91 := NULL;
3126 END IF;
3127
3128 IF l_Line_price_att_rec.pricing_attribute92 = FND_API.G_MISS_CHAR THEN
3129 l_Line_price_att_rec.pricing_attribute92 := NULL;
3130 END IF;
3131
3132 IF l_Line_price_att_rec.pricing_attribute93 = FND_API.G_MISS_CHAR THEN
3133 l_Line_price_att_rec.pricing_attribute93 := NULL;
3134 END IF;
3135
3136 IF l_Line_price_att_rec.pricing_attribute94 = FND_API.G_MISS_CHAR THEN
3137 l_Line_price_att_rec.pricing_attribute94 := NULL;
3138 END IF;
3139
3140 IF l_Line_price_att_rec.pricing_attribute95 = FND_API.G_MISS_CHAR THEN
3141 l_Line_price_att_rec.pricing_attribute95 := NULL;
3142 END IF;
3143
3144 IF l_Line_price_att_rec.pricing_attribute96 = FND_API.G_MISS_CHAR THEN
3145 l_Line_price_att_rec.pricing_attribute96 := NULL;
3146 END IF;
3147
3148 IF l_Line_price_att_rec.pricing_attribute97 = FND_API.G_MISS_CHAR THEN
3149 l_Line_price_att_rec.pricing_attribute97 := NULL;
3150 END IF;
3151
3152 IF l_Line_price_att_rec.pricing_attribute98 = FND_API.G_MISS_CHAR THEN
3153 l_Line_price_att_rec.pricing_attribute98 := NULL;
3154 END IF;
3155
3156 IF l_Line_price_att_rec.pricing_attribute99 = FND_API.G_MISS_CHAR THEN
3157 l_Line_price_att_rec.pricing_attribute99 := NULL;
3158 END IF;
3159
3160 IF l_Line_price_att_rec.pricing_context = FND_API.G_MISS_CHAR THEN
3161 l_Line_price_att_rec.pricing_context := NULL;
3162 END IF;
3163
3164 IF l_Line_price_att_rec.program_application_id = FND_API.G_MISS_NUM THEN
3165 l_Line_price_att_rec.program_application_id := NULL;
3166 END IF;
3167
3168 IF l_Line_price_att_rec.program_id = FND_API.G_MISS_NUM THEN
3169 l_Line_price_att_rec.program_id := NULL;
3170 END IF;
3171
3172 IF l_Line_price_att_rec.program_update_date = FND_API.G_MISS_DATE THEN
3173 l_Line_price_att_rec.program_update_date := NULL;
3174 END IF;
3175
3176 IF l_Line_price_att_rec.request_id = FND_API.G_MISS_NUM THEN
3177 l_Line_price_att_rec.request_id := NULL;
3178 END IF;
3179
3180 IF l_Line_price_att_rec.orig_sys_atts_ref = FND_API.G_MISS_CHAR THEN
3181 l_Line_price_att_rec.orig_sys_atts_ref := NULL;
3182 END IF;
3183 -- RETURN l_Line_price_att_rec;
3184 p_x_Line_price_att_rec := l_Line_price_att_rec;
3185
3186 END Convert_Miss_To_Null;
3187
3188 PROCEDURE Apply_Attribute_Changes
3189 ( p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
3190 , p_old_Line_price_att_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type := OE_Order_PUB.G_MISS_LINE_PRICE_ATT_REC
3191 )
3192 IS
3193 l_price_flag boolean := FALSE;
3194 l_booked_flag Varchar2(1) := 'N';
3195 l_shipping_quantity number;
3196 l_order_quantity_uom VARCHAR2(3);
3197 l_organization_id NUMBER := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
3198 l_ins_status VARCHAR2(1);
3199 l_industry VARCHAR2(1);
3200 l_dynamicSqlString VARCHAR2(2000);
3201 l_Return_Status Varchar2(1);
3202 l_msg_name VARCHAR2(200);
3203 l_pricing_event VARCHAR2(30);
3204 l_order_pricing_event VARCHAR2(30);
3205 l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
3206 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3207 --bug 2702382 begin
3208 l_price_adj_id1 number;
3209 l_tmp1 number;
3210 l_tmp_price_flag boolean := FALSE;
3211 l_lst_type_code varchar2(10);
3212 l_lineid1 number;
3213 CURSOR get_price_adj_ids(l_lineid1 IN NUMBER,l_list_hdr_id1 IN NUMBER)
3214 is select price_adjustment_id,list_line_type_code from
3215 oe_price_adjustments
3216 where line_id = l_lineid1 and list_header_id = l_list_hdr_id1;
3217
3218 FUNCTION delete_price_adj(l_prc_adj_id IN number,l_lst_code IN varchar2)
3219 RETURN BOOLEAN is
3220 begin
3221 if l_lst_code in ('PRG','IUE','OID') then
3222 null; --do not expect these cases to be overriden
3223 elsif l_lst_code = 'PBH' then
3224 delete from oe_price_adjustments where price_adjustment_id in
3225 (select rltd_price_adj_id from oe_price_adj_assocs where
3226 price_adjustment_id = l_prc_adj_id
3227 union
3228 select price_adjustment_id from oe_price_adj_assocs where
3229 price_adjustment_id = l_prc_adj_id
3230 );
3231 delete from oe_price_adj_assocs where
3232 price_adjustment_id = l_prc_adj_id;
3233 elsif l_lst_code in ('DIS','SUR') then
3234 begin
3235 --check if this is a freegoods lines adjustment if so, do not delete it
3236 select 1 into l_tmp1
3237 from oe_price_adj_assocs opaa,oe_price_adjustments opa
3238 where opaa.rltd_price_adj_id = l_prc_adj_id and
3239 opaa.price_adjustment_id = opa.price_adjustment_id and
3240 opa.list_line_type_code = 'PRG';
3241 exception
3242 when no_data_found then
3243 --indicates not a free goods adjustment, so delete it
3244 oe_debug_pub.add('in free goods line no data found');
3245 delete from oe_price_adjustments where
3246 price_adjustment_id = l_prc_adj_id;
3247 when others then
3248 null;
3249 end;
3250 end if;
3251 if SQL%ROWCOUNT > 0 then
3252 RETURN TRUE;
3253 else
3254 RETURN FALSE;
3255 end if;
3256 exception
3257 when others then
3258 RETURN FALSE;
3259 end;
3260
3261 --bug 2702382 end
3262
3263 BEGIN
3264
3265 -- x_Line_price_att_rec := p_Line_Price_Att_rec;
3266
3267 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.override_flag,p_old_Line_price_att_rec.override_flag)
3268 THEN
3269 l_price_flag := TRUE;
3270 END IF;
3271
3272
3273
3274 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute1,p_old_Line_price_att_rec.attribute1)
3275 THEN
3276 NULL;
3277 END IF;
3278
3279 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute10,p_old_Line_price_att_rec.attribute10)
3280 THEN
3281 NULL;
3282 END IF;
3283
3284 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute11,p_old_Line_price_att_rec.attribute11)
3285 THEN
3286 NULL;
3287 END IF;
3288
3289 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute12,p_old_Line_price_att_rec.attribute12)
3290 THEN
3291 NULL;
3292 END IF;
3293
3294 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute13,p_old_Line_price_att_rec.attribute13)
3295 THEN
3296 NULL;
3297 END IF;
3298
3299 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute14,p_old_Line_price_att_rec.attribute14)
3300 THEN
3301 NULL;
3302 END IF;
3303
3304 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute15,p_old_Line_price_att_rec.attribute15)
3305 THEN
3306 NULL;
3307 END IF;
3308
3309 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute2,p_old_Line_price_att_rec.attribute2)
3310 THEN
3311 NULL;
3312 END IF;
3313
3314 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute3,p_old_Line_price_att_rec.attribute3)
3315 THEN
3316 NULL;
3317 END IF;
3318
3319 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute4,p_old_Line_price_att_rec.attribute4)
3320 THEN
3321 NULL;
3322 END IF;
3323
3324 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute5,p_old_Line_price_att_rec.attribute5)
3325 THEN
3326 NULL;
3327 END IF;
3328
3329 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute6,p_old_Line_price_att_rec.attribute6)
3330 THEN
3331 NULL;
3332 END IF;
3333
3334 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute7,p_old_Line_price_att_rec.attribute7)
3335 THEN
3336 NULL;
3337 END IF;
3338
3339 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute8,p_old_Line_price_att_rec.attribute8)
3340 THEN
3341 NULL;
3342 END IF;
3343
3344 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.attribute9,p_old_Line_price_att_rec.attribute9)
3345 THEN
3346 NULL;
3347 END IF;
3348
3349 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.context,p_old_Line_price_att_rec.context)
3350 THEN
3351 NULL;
3352 END IF;
3353
3354 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.created_by,p_old_Line_price_att_rec.created_by)
3355 THEN
3356 NULL;
3357 END IF;
3358
3359 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.creation_date,p_old_Line_price_att_rec.creation_date)
3360 THEN
3361 NULL;
3362 END IF;
3363
3364 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.flex_title,p_old_Line_price_att_rec.flex_title)
3365 THEN
3366 l_price_flag := TRUE;
3367 END IF;
3368
3369 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.header_id,p_old_Line_price_att_rec.header_id)
3370 THEN
3371 l_price_flag := TRUE;
3372 END IF;
3373
3374 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.last_updated_by,p_old_Line_price_att_rec.last_updated_by)
3375 THEN
3376 NULL;
3377 END IF;
3378
3379 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.last_update_date,p_old_Line_price_att_rec.last_update_date)
3380 THEN
3381 NULL;
3382 END IF;
3383
3384 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.last_update_login,p_old_Line_price_att_rec.last_update_login)
3385 THEN
3386 NULL;
3387 END IF;
3388
3389 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.line_id,p_old_Line_price_att_rec.line_id)
3390 THEN
3391 l_price_flag := TRUE;
3392 END IF;
3393
3394 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.order_price_attrib_id,p_old_Line_price_att_rec.order_price_attrib_id)
3395 THEN
3396 NULL;
3397 END IF;
3398
3399 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute1,p_old_Line_price_att_rec.pricing_attribute1)
3400 THEN
3401 l_price_flag := TRUE;
3402 -- lkxu: added for OTA integration, call the OTA API dynamically if
3403 -- the pricing context is OTA_PRICING.
3404 IF oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_context, 'OTA') THEN
3405 -- application id for OTA is 810.
3406 --IF fnd_installation.get(810, 810, l_ins_status, l_industry) THEN
3407
3408 -- bug 1701377
3409 IF OE_GLOBALS.G_OTA_INSTALLED IS NULL THEN
3410 OE_GLOBALS.G_OTA_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(810);
3411 END IF;
3412
3413 IF OE_GLOBALS.G_OTA_INSTALLED = 'Y' THEN
3414 BEGIN
3415 SELECT order_quantity_uom
3416 INTO l_order_quantity_uom
3417 FROM oe_order_lines_all
3418 WHERE line_id = p_x_Line_Price_Att_rec.line_id;
3419
3420 EXCEPTION WHEN NO_DATA_FOUND THEN
3421 null;
3422 END;
3423
3424 l_dynamicSqlString := '
3425 Begin
3426 OTA_CANCEL_API.upd_max_attendee(
3427 :p_line_id,
3428 :p_org_id,
3429 :p_max_attendee,
3430 :p_upm,
3431 :p_operation,
3432 :x_return_status,
3433 :x_msg_data);
3434 END;';
3435
3436 EXECUTE IMMEDIATE l_dynamicSqlString
3437 USING IN p_x_Line_Price_Att_rec.line_id,
3438 IN l_organization_id,
3439 IN fnd_number.canonical_to_number(p_x_Line_Price_Att_rec.pricing_attribute1),
3440 IN l_order_quantity_uom,
3441 IN p_x_Line_Price_Att_rec.operation,
3442 OUT l_return_status,
3443 OUT l_msg_name;
3444
3445 oe_debug_pub.add('OTA call return status is: '||l_return_status,1);
3446 oe_debug_pub.add('OTA call return message is: '||l_msg_name,1);
3447
3448 IF l_return_status = 'E' THEN
3449 oe_debug_pub.add('OTA API - Error.', 1);
3450 FND_MESSAGE.SET_NAME('OTA',l_msg_name);
3451 OE_MSG_PUB.ADD;
3452 RAISE FND_API.G_EXC_ERROR;
3453 END IF;
3454
3455 ELSE
3456 oe_debug_pub.add('OTA module is not installed. ',1);
3457 END IF;
3458 END IF;
3459 END IF;
3460
3461 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute10,p_old_Line_price_att_rec.pricing_attribute10)
3462 THEN
3463 l_price_flag := TRUE;
3464 END IF;
3465
3466 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute100,p_old_Line_price_att_rec.pricing_attribute100)
3467 THEN
3468 l_price_flag := TRUE;
3469 END IF;
3470
3471 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute11,p_old_Line_price_att_rec.pricing_attribute11)
3472 THEN
3473 l_price_flag := TRUE;
3474 END IF;
3475
3476 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute12,p_old_Line_price_att_rec.pricing_attribute12)
3477 THEN
3478 l_price_flag := TRUE;
3479 END IF;
3480
3481 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute13,p_old_Line_price_att_rec.pricing_attribute13)
3482 THEN
3483 l_price_flag := TRUE;
3484 END IF;
3485
3486 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute14,p_old_Line_price_att_rec.pricing_attribute14)
3487 THEN
3488 l_price_flag := TRUE;
3489 END IF;
3490
3491 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute15,p_old_Line_price_att_rec.pricing_attribute15)
3492 THEN
3493 l_price_flag := TRUE;
3494 END IF;
3495
3496 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute16,p_old_Line_price_att_rec.pricing_attribute16)
3497 THEN
3498 l_price_flag := TRUE;
3499 END IF;
3500
3501 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute17,p_old_Line_price_att_rec.pricing_attribute17)
3502 THEN
3503 l_price_flag := TRUE;
3504 END IF;
3505
3506 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute18,p_old_Line_price_att_rec.pricing_attribute18)
3507 THEN
3508 l_price_flag := TRUE;
3509 END IF;
3510
3511 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute19,p_old_Line_price_att_rec.pricing_attribute19)
3512 THEN
3513 l_price_flag := TRUE;
3514 END IF;
3515
3516 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute2,p_old_Line_price_att_rec.pricing_attribute2)
3517 THEN
3518 l_price_flag := TRUE;
3519 END IF;
3520
3521 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute20,p_old_Line_price_att_rec.pricing_attribute20)
3522 THEN
3523 l_price_flag := TRUE;
3524 END IF;
3525
3526 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute21,p_old_Line_price_att_rec.pricing_attribute21)
3527 THEN
3528 l_price_flag := TRUE;
3529 END IF;
3530
3531 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute22,p_old_Line_price_att_rec.pricing_attribute22)
3532 THEN
3533 l_price_flag := TRUE;
3534 END IF;
3535
3536 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute23,p_old_Line_price_att_rec.pricing_attribute23)
3537 THEN
3538 l_price_flag := TRUE;
3539 END IF;
3540
3541 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute24,p_old_Line_price_att_rec.pricing_attribute24)
3542 THEN
3543 l_price_flag := TRUE;
3544 END IF;
3545
3546 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute25,p_old_Line_price_att_rec.pricing_attribute25)
3547 THEN
3548 l_price_flag := TRUE;
3549 END IF;
3550
3551 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute26,p_old_Line_price_att_rec.pricing_attribute26)
3552 THEN
3553 l_price_flag := TRUE;
3554 END IF;
3555
3556 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute27,p_old_Line_price_att_rec.pricing_attribute27)
3557 THEN
3558 l_price_flag := TRUE;
3559 END IF;
3560
3561 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute28,p_old_Line_price_att_rec.pricing_attribute28)
3562 THEN
3563 l_price_flag := TRUE;
3564 END IF;
3565
3566 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute29,p_old_Line_price_att_rec.pricing_attribute29)
3567 THEN
3568 l_price_flag := TRUE;
3569 END IF;
3570
3571 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute3,p_old_Line_price_att_rec.pricing_attribute3)
3572 THEN
3573 l_price_flag := TRUE;
3574 END IF;
3575
3576 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute30,p_old_Line_price_att_rec.pricing_attribute30)
3577 THEN
3578 l_price_flag := TRUE;
3579 END IF;
3580
3581 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute31,p_old_Line_price_att_rec.pricing_attribute31)
3582 THEN
3583 l_price_flag := TRUE;
3584 END IF;
3585
3586 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute32,p_old_Line_price_att_rec.pricing_attribute32)
3587 THEN
3588 l_price_flag := TRUE;
3589 END IF;
3590
3591 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute33,p_old_Line_price_att_rec.pricing_attribute33)
3592 THEN
3593 l_price_flag := TRUE;
3594 END IF;
3595
3596 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute34,p_old_Line_price_att_rec.pricing_attribute34)
3597 THEN
3598 l_price_flag := TRUE;
3599 END IF;
3600
3601 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute35,p_old_Line_price_att_rec.pricing_attribute35)
3602 THEN
3603 l_price_flag := TRUE;
3604 END IF;
3605
3606 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute36,p_old_Line_price_att_rec.pricing_attribute36)
3607 THEN
3608 l_price_flag := TRUE;
3609 END IF;
3610
3611 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute37,p_old_Line_price_att_rec.pricing_attribute37)
3612 THEN
3613 l_price_flag := TRUE;
3614 END IF;
3615
3616 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute38,p_old_Line_price_att_rec.pricing_attribute38)
3617 THEN
3618 l_price_flag := TRUE;
3619 END IF;
3620
3621 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute39,p_old_Line_price_att_rec.pricing_attribute39)
3622 THEN
3623 l_price_flag := TRUE;
3624 END IF;
3625
3626 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute4,p_old_Line_price_att_rec.pricing_attribute4)
3627 THEN
3628 l_price_flag := TRUE;
3629 END IF;
3630
3631 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute40,p_old_Line_price_att_rec.pricing_attribute40)
3632 THEN
3633 l_price_flag := TRUE;
3634 END IF;
3635
3636 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute41,p_old_Line_price_att_rec.pricing_attribute41)
3637 THEN
3638 l_price_flag := TRUE;
3639 END IF;
3640
3641 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute42,p_old_Line_price_att_rec.pricing_attribute42)
3642 THEN
3643 l_price_flag := TRUE;
3644 END IF;
3645
3646 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute43,p_old_Line_price_att_rec.pricing_attribute43)
3647 THEN
3648 l_price_flag := TRUE;
3649 END IF;
3650
3651 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute44,p_old_Line_price_att_rec.pricing_attribute44)
3652 THEN
3653 l_price_flag := TRUE;
3654 END IF;
3655
3656 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute45,p_old_Line_price_att_rec.pricing_attribute45)
3657 THEN
3658 l_price_flag := TRUE;
3659 END IF;
3660
3661 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute46,p_old_Line_price_att_rec.pricing_attribute46)
3662 THEN
3663 l_price_flag := TRUE;
3664 END IF;
3665
3666 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute47,p_old_Line_price_att_rec.pricing_attribute47)
3667 THEN
3668 l_price_flag := TRUE;
3669 END IF;
3670
3671 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute48,p_old_Line_price_att_rec.pricing_attribute48)
3672 THEN
3673 l_price_flag := TRUE;
3674 END IF;
3675
3676 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute49,p_old_Line_price_att_rec.pricing_attribute49)
3677 THEN
3678 l_price_flag := TRUE;
3679 END IF;
3680
3681 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute5,p_old_Line_price_att_rec.pricing_attribute5)
3682 THEN
3683 l_price_flag := TRUE;
3684 END IF;
3685
3686 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute50,p_old_Line_price_att_rec.pricing_attribute50)
3687 THEN
3688 l_price_flag := TRUE;
3689 END IF;
3690
3691 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute51,p_old_Line_price_att_rec.pricing_attribute51)
3692 THEN
3693 l_price_flag := TRUE;
3694 END IF;
3695
3696 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute52,p_old_Line_price_att_rec.pricing_attribute52)
3697 THEN
3698 l_price_flag := TRUE;
3699 END IF;
3700
3701 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute53,p_old_Line_price_att_rec.pricing_attribute53)
3702 THEN
3703 l_price_flag := TRUE;
3704 END IF;
3705
3706 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute54,p_old_Line_price_att_rec.pricing_attribute54)
3707 THEN
3708 l_price_flag := TRUE;
3709 END IF;
3710
3711 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute55,p_old_Line_price_att_rec.pricing_attribute55)
3712 THEN
3713 l_price_flag := TRUE;
3714 END IF;
3715
3716 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute56,p_old_Line_price_att_rec.pricing_attribute56)
3717 THEN
3718 l_price_flag := TRUE;
3719 END IF;
3720
3721 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute57,p_old_Line_price_att_rec.pricing_attribute57)
3722 THEN
3723 l_price_flag := TRUE;
3724 END IF;
3725
3726 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute58,p_old_Line_price_att_rec.pricing_attribute58)
3727 THEN
3728 l_price_flag := TRUE;
3729 END IF;
3730
3731 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute59,p_old_Line_price_att_rec.pricing_attribute59)
3732 THEN
3733 l_price_flag := TRUE;
3734 END IF;
3735
3736 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute6,p_old_Line_price_att_rec.pricing_attribute6)
3737 THEN
3738 l_price_flag := TRUE;
3739 END IF;
3740
3741 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute60,p_old_Line_price_att_rec.pricing_attribute60)
3742 THEN
3743 l_price_flag := TRUE;
3744 END IF;
3745
3746 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute61,p_old_Line_price_att_rec.pricing_attribute61)
3747 THEN
3748 l_price_flag := TRUE;
3749 END IF;
3750
3751 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute62,p_old_Line_price_att_rec.pricing_attribute62)
3752 THEN
3753 l_price_flag := TRUE;
3754 END IF;
3755
3756 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute63,p_old_Line_price_att_rec.pricing_attribute63)
3757 THEN
3758 l_price_flag := TRUE;
3759 END IF;
3760
3761 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute64,p_old_Line_price_att_rec.pricing_attribute64)
3762 THEN
3763 l_price_flag := TRUE;
3764 END IF;
3765
3766 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute65,p_old_Line_price_att_rec.pricing_attribute65)
3767 THEN
3768 l_price_flag := TRUE;
3769 END IF;
3770
3771 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute66,p_old_Line_price_att_rec.pricing_attribute66)
3772 THEN
3773 l_price_flag := TRUE;
3774 END IF;
3775
3776 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute67,p_old_Line_price_att_rec.pricing_attribute67)
3777 THEN
3778 l_price_flag := TRUE;
3779 END IF;
3780
3781 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute68,p_old_Line_price_att_rec.pricing_attribute68)
3782 THEN
3783 l_price_flag := TRUE;
3784 END IF;
3785
3786 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute69,p_old_Line_price_att_rec.pricing_attribute69)
3787 THEN
3788 l_price_flag := TRUE;
3789 END IF;
3790
3791 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute7,p_old_Line_price_att_rec.pricing_attribute7)
3792 THEN
3793 l_price_flag := TRUE;
3794 END IF;
3795
3796 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute70,p_old_Line_price_att_rec.pricing_attribute70)
3797 THEN
3798 l_price_flag := TRUE;
3799 END IF;
3800
3801 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute71,p_old_Line_price_att_rec.pricing_attribute71)
3802 THEN
3803 l_price_flag := TRUE;
3804 END IF;
3805
3806 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute72,p_old_Line_price_att_rec.pricing_attribute72)
3807 THEN
3808 l_price_flag := TRUE;
3809 END IF;
3810
3811 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute73,p_old_Line_price_att_rec.pricing_attribute73)
3812 THEN
3813 l_price_flag := TRUE;
3814 END IF;
3815
3816 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute74,p_old_Line_price_att_rec.pricing_attribute74)
3817 THEN
3818 l_price_flag := TRUE;
3819 END IF;
3820
3821 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute75,p_old_Line_price_att_rec.pricing_attribute75)
3822 THEN
3823 l_price_flag := TRUE;
3824 END IF;
3825
3826 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute76,p_old_Line_price_att_rec.pricing_attribute76)
3827 THEN
3828 l_price_flag := TRUE;
3829 END IF;
3830
3831 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute77,p_old_Line_price_att_rec.pricing_attribute77)
3832 THEN
3833 l_price_flag := TRUE;
3834 END IF;
3835
3836 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute78,p_old_Line_price_att_rec.pricing_attribute78)
3837 THEN
3838 l_price_flag := TRUE;
3839 END IF;
3840
3841 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute79,p_old_Line_price_att_rec.pricing_attribute79)
3842 THEN
3843 l_price_flag := TRUE;
3844 END IF;
3845
3846 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute8,p_old_Line_price_att_rec.pricing_attribute8)
3847 THEN
3848 l_price_flag := TRUE;
3849 END IF;
3850
3851 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute80,p_old_Line_price_att_rec.pricing_attribute80)
3852 THEN
3853 l_price_flag := TRUE;
3854 END IF;
3855
3856 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute81,p_old_Line_price_att_rec.pricing_attribute81)
3857 THEN
3858 l_price_flag := TRUE;
3859 END IF;
3860
3861 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute82,p_old_Line_price_att_rec.pricing_attribute82)
3862 THEN
3863 l_price_flag := TRUE;
3864 END IF;
3865
3866 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute83,p_old_Line_price_att_rec.pricing_attribute83)
3867 THEN
3868 l_price_flag := TRUE;
3869 END IF;
3870
3871 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute84,p_old_Line_price_att_rec.pricing_attribute84)
3872 THEN
3873 l_price_flag := TRUE;
3874 END IF;
3875
3876 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute85,p_old_Line_price_att_rec.pricing_attribute85)
3877 THEN
3878 l_price_flag := TRUE;
3879 END IF;
3880
3881 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute86,p_old_Line_price_att_rec.pricing_attribute86)
3882 THEN
3883 l_price_flag := TRUE;
3884 END IF;
3885
3886 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute87,p_old_Line_price_att_rec.pricing_attribute87)
3887 THEN
3888 l_price_flag := TRUE;
3889 END IF;
3890
3891 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute88,p_old_Line_price_att_rec.pricing_attribute88)
3892 THEN
3893 l_price_flag := TRUE;
3894 END IF;
3895
3896 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute89,p_old_Line_price_att_rec.pricing_attribute89)
3897 THEN
3898 l_price_flag := TRUE;
3899 END IF;
3900
3901 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute9,p_old_Line_price_att_rec.pricing_attribute9)
3902 THEN
3903 l_price_flag := TRUE;
3904 END IF;
3905
3906 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute90,p_old_Line_price_att_rec.pricing_attribute90)
3907 THEN
3908 l_price_flag := TRUE;
3909 END IF;
3910
3911 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute91,p_old_Line_price_att_rec.pricing_attribute91)
3912 THEN
3913 l_price_flag := TRUE;
3914 END IF;
3915
3916 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute92,p_old_Line_price_att_rec.pricing_attribute92)
3917 THEN
3918 l_price_flag := TRUE;
3919 END IF;
3920
3921 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute93,p_old_Line_price_att_rec.pricing_attribute93)
3922 THEN
3923 l_price_flag := TRUE;
3924 END IF;
3925
3926 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute94,p_old_Line_price_att_rec.pricing_attribute94)
3927 THEN
3928 l_price_flag := TRUE;
3929 END IF;
3930
3931 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute95,p_old_Line_price_att_rec.pricing_attribute95)
3932 THEN
3933 l_price_flag := TRUE;
3934 END IF;
3935
3936 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute96,p_old_Line_price_att_rec.pricing_attribute96)
3937 THEN
3938 l_price_flag := TRUE;
3939 END IF;
3940
3941 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute97,p_old_Line_price_att_rec.pricing_attribute97)
3942 THEN
3943 l_price_flag := TRUE;
3944 END IF;
3945
3946 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute98,p_old_Line_price_att_rec.pricing_attribute98)
3947 THEN
3948 l_price_flag := TRUE;
3949 END IF;
3950
3951 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_attribute99,p_old_Line_price_att_rec.pricing_attribute99)
3952 THEN
3953 l_price_flag := TRUE;
3954 END IF;
3955
3956 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.pricing_context,p_old_Line_price_att_rec.pricing_context)
3957 THEN
3958 l_price_flag := TRUE;
3959 END IF;
3960
3961 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.program_application_id,p_old_Line_price_att_rec.program_application_id)
3962 THEN
3963 NULL;
3964 END IF;
3965
3966 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.program_id,p_old_Line_price_att_rec.program_id)
3967 THEN
3968 NULL;
3969 END IF;
3970
3971 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.program_update_date,p_old_Line_price_att_rec.program_update_date)
3972 THEN
3973 NULL;
3974 END IF;
3975
3976 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.request_id,p_old_Line_price_att_rec.request_id)
3977 THEN
3978 NULL;
3979 END IF;
3980
3981 IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.orig_sys_atts_ref,p_old_Line_price_att_rec.orig_sys_atts_ref)
3982 THEN
3983 NULL;
3984 END IF;
3985 --for bug 2702382 begin
3986 if p_x_line_price_att_rec.operation = OE_GLOBALS.G_OPR_DELETE
3987 and p_x_line_price_att_rec.flex_title = 'QP_ATTR_DEFNS_QUALIFIER'
3988 and p_x_line_price_att_rec.pricing_context = 'MODLIST'
3989 and p_x_line_price_att_rec.pricing_attribute1 is not null
3990 then
3991 IF (p_x_line_price_att_rec.pricing_attribute2 is not null) THEN
3992 begin
3993 select price_adjustment_id,list_line_type_code
3994 into l_price_adj_id1,l_lst_type_code
3995 from oe_price_adjustments
3996 where line_id = p_x_line_price_att_rec.line_id
3997 and list_line_id = p_x_line_price_att_rec.pricing_attribute2
3998 and updated_flag = 'Y';
3999 l_price_flag := delete_price_adj(l_price_adj_id1,l_lst_type_code);
4000 exception
4001 when others then
4002 oe_debug_pub.add('in no data found - apply attribute change');
4003 null;
4004 end;
4005 elsif p_x_line_price_att_rec.pricing_attribute2 is null THEN
4006 begin
4007 select 1 into l_tmp1 from dual
4008 where exists
4009 (select 1 from oe_price_adjustments where
4010 list_header_id = p_x_line_price_att_rec.pricing_attribute1
4011 and updated_flag = 'Y');
4012 for l_prj_adj_cur in
4013 get_price_adj_ids(p_x_line_price_att_rec.line_id,
4014 p_x_line_price_att_rec.pricing_attribute1)
4015 loop
4016 l_tmp_price_flag :=
4017 delete_price_adj(l_prj_adj_cur.price_adjustment_id,
4018 l_prj_adj_cur.list_line_type_code);
4019 if l_tmp_price_flag then
4020 l_price_flag := l_tmp_price_flag;
4021 end if;
4022 end loop;
4023 exception
4024 when others then
4025 null;
4026 end;
4027 end if;
4028 end if;
4029 --for bug 2702382 end
4030
4031 If l_price_flag Then
4032
4033 oe_debug_pub.ADD('Logging delayed request for pricing from OE_Line_PAttr_Util.apply_attribute_changes ', 1);
4034 --2442012
4035 Begin
4036 Select booked_flag,shipping_quantity into
4037 l_booked_flag,l_shipping_quantity
4038 From OE_Order_lines where
4039 Line_id = p_x_Line_Price_Att_rec.Line_Id;
4040 Exception when no_data_found then
4041 Null;
4042 End;
4043
4044 If l_shipping_quantity > 0 Then
4045 l_pricing_event := 'BATCH,BOOK,SHIP';
4046 l_order_pricing_event := 'ORDER,BOOK';
4047 Elsif l_booked_flag='Y' Then
4048 l_pricing_event := 'BATCH,BOOK';
4049 l_order_pricing_event := 'ORDER,BOOK';
4050 Else
4051 l_pricing_event := 'BATCH';
4052 l_order_pricing_event := 'ORDER';
4053 End If;
4054
4055 --Need to register changed line so that repricing for this line will happen
4056 oe_debug_pub.add(' Before calling registered changed lines from ulpab');
4057 OE_LINE_ADJ_UTIL.Register_Changed_Lines(p_line_id=> p_x_Line_Price_Att_rec.line_id,
4058 p_header_id=>p_x_Line_Price_Att_rec.header_id,
4059 p_operation=>OE_GLOBALS.G_OPR_UPDATE);
4060 oe_debug_pub.add(' After calling registered changed line');
4061
4062 --for bug 2456108 begin
4063 if (p_x_line_price_att_rec.flex_title = 'QP_ATTR_DEFNS_QUALIFIER') then
4064 OE_delayed_requests_Pvt.log_request(
4065 p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4066 p_entity_id => p_x_Line_Price_Att_rec.line_id,
4067 p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4068 p_requesting_entity_id => p_x_Line_Price_Att_rec.line_id,
4069 p_request_unique_key1 => l_pricing_event,
4070 p_param1 => p_x_Line_Price_Att_rec.header_id,
4071 p_param2 => l_pricing_event,
4072 p_request_type => OE_GLOBALS.G_PRICE_LINE,
4073 x_return_status => l_return_status);
4074 -- sol_ord_er #16014165
4075 oe_delayed_requests_pvt.log_request(
4076 p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4077 p_entity_id => p_x_Line_Price_Att_rec.line_id,
4078 p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4079 p_requesting_entity_id => p_x_Line_Price_Att_rec.line_id,
4080 p_request_type => OE_GLOBALS.G_SERVICE_FIRST_PERIOD_BILL,
4081 p_request_unique_key1 => 'ORDER',
4082 p_param1 => p_x_Line_Price_Att_rec.header_id,
4083 x_return_status => l_return_status);
4084 -- sol_ord_er #16014165 end
4085 elsif (p_x_line_price_att_rec.flex_title = 'QP_ATTR_DEFNS_PRICING') then
4086
4087 -- for bug 3533776: Find out whether order event needs all lines to be sent
4088 -- bug 9728497 start
4089 -- modified below for p_x_new_line_rec.header_id and p_x_new_line_rec.line_id
4090 -- being passed on to call the overloaded function.
4091 -- QP_UTIL_PUB.Get_Order_Lines_Status(l_order_pricing_event,l_order_status_rec);
4092 QP_UTIL_PUB.Get_Order_Lines_Status(p_event_code => l_order_pricing_event,
4093 p_header_id => p_x_line_price_att_rec.header_id,
4094 p_line_id => p_x_line_price_att_rec.line_id,
4095 x_order_status_rec =>l_order_status_rec);
4096 -- bug 9728497 end
4097
4098 IF l_debug_level > 0 THEN
4099 oe_debug_pub.add('SummaryFlag:'||l_order_status_rec.SUMMARY_LINE_FLAG||'ALL_LINES_FLAG:'||
4100 l_order_status_rec.ALL_LINES_FLAG||' CHANGED_LINE_FLAG:'||l_order_status_rec.CHANGED_LINES_FLAG);
4101 oe_debug_pub.add('G_DEFER_PRICING'||OE_GLOBALS.G_DEFER_PRICING);
4102 if (OE_GLOBALS.G_UI_FLAG) then
4103 oe_debug_pub.add('ui mode');
4104 end if;
4105 END IF;
4106
4107 -- If 'ORDER' event doesn't require sending in all lines, let's just price the current line
4108 If l_order_status_rec.ALL_LINES_FLAG = 'N'
4109 AND l_order_status_rec.SUMMARY_LINE_FLAG = 'N'
4110 AND (OE_GLOBALS.G_UI_FLAG)
4111 AND (OE_GLOBALS.G_DEFER_PRICING = 'N') THEN
4112 OE_delayed_requests_Pvt.log_request(
4113 p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
4114 p_entity_id => p_x_Line_Price_Att_rec.line_id,
4115 p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
4116 p_requesting_entity_id => p_x_Line_Price_Att_rec.line_id,
4117 p_request_unique_key1 => l_pricing_event,
4118 p_param1 => p_x_Line_Price_Att_rec.line_id,
4119 p_param2 => l_pricing_event,
4120 p_request_type => OE_GLOBALS.G_PRICE_LINE,
4121 x_return_status => l_return_status);
4122
4123 -- sol_ord_er #16014165
4124 oe_delayed_requests_pvt.log_request(
4125 p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
4126 p_entity_id => p_x_Line_Price_Att_rec.line_id,
4127 p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
4128 p_requesting_entity_id => p_x_Line_Price_Att_rec.line_id,
4129 p_request_type => OE_GLOBALS.G_SERVICE_FIRST_PERIOD_BILL,
4130 p_request_unique_key1 => 'LINE',
4131 p_param1 => p_x_Line_Price_Att_rec.line_id,
4132 x_return_status => l_return_status);
4133 -- sol_ord_er #16014165 end
4134 ELSE
4135 OE_delayed_requests_Pvt.log_request(
4136 p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4137 p_entity_id => p_x_Line_Price_Att_rec.Header_Id,
4138 p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4139 p_requesting_entity_id => p_x_Line_Price_Att_rec.Header_Id,
4140 p_request_unique_key1 => l_pricing_event,
4141 p_param1 => p_x_Line_Price_Att_rec.header_id,
4142 p_param2 => l_pricing_event,
4143 p_request_type => OE_GLOBALS.G_PRICE_ORDER,
4144 x_return_status => l_return_status);
4145 -- sol_ord_er #16014165
4146 oe_delayed_requests_pvt.log_request(
4147 p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4148 p_entity_id => p_x_Line_Price_Att_rec.header_id,
4149 p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4150 p_requesting_entity_id => p_x_Line_Price_Att_rec.header_id,
4151 p_request_type => OE_GLOBALS.G_SERVICE_FIRST_PERIOD_BILL,
4152 p_request_unique_key1 => 'ORDER',
4153 p_param1 => p_x_Line_Price_Att_rec.header_id,
4154 x_return_status => l_return_status);
4155 -- sol_ord_er #16014165 end
4156 END IF;
4157 end if; ---for bug 2456108 end
4158
4159 /* Begin
4160 Select booked_flag,shipping_quantity into
4161 l_booked_flag,l_shipping_quantity
4162 From OE_Order_lines where
4163 Line_id = p_x_Line_Price_Att_rec.Line_Id;
4164 Exception when no_data_found then
4165 Null;
4166 End;
4167
4168 If l_booked_flag='Y' Then
4169 OE_delayed_requests_Pvt.log_request(
4170 p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4171 p_entity_id => p_x_Line_Price_Att_rec.Header_Id,
4172 p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4173 p_requesting_entity_id => p_x_Line_Price_Att_rec.Header_Id,
4174 p_request_unique_key1 => 'BOOK',
4175 p_param1 => p_x_Line_Price_Att_rec.header_id,
4176 p_param2 => 'BOOK',
4177 p_request_type => OE_GLOBALS.G_PRICE_ORDER,
4178 x_return_status => l_return_status);
4179 End If;
4180
4181 If l_shipping_quantity > 0 Then
4182 OE_delayed_requests_Pvt.log_request(
4183 p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4184 p_entity_id => p_x_Line_Price_Att_rec.Line_Id,
4185 p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4186 p_requesting_entity_id => p_x_Line_Price_Att_rec.Line_Id,
4187 p_request_unique_key1 => 'SHIP',
4188 p_param1 => p_x_Line_Price_Att_rec.header_id,
4189 p_param2 => 'SHIP',
4190 p_request_type => OE_GLOBALS.G_PRICE_LINE,
4191 x_return_status => l_return_status);
4192 End If;
4193 */--2442012
4194 l_Price_Flag := FALSE;
4195
4196 End If;
4197
4198 END Apply_Attribute_Changes;
4199
4200 -- Procedure lock_Row
4201 --
4202
4203 PROCEDURE Lock_Row
4204 ( x_return_status OUT NOCOPY VARCHAR2
4205 , p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
4206 , p_order_price_attrib_id IN NUMBER := FND_API.G_MISS_NUM
4207 )
4208 IS
4209 l_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4210 l_order_price_attrib_id NUMBER;
4211 l_lock_control NUMBER;
4212
4213 BEGIN
4214
4215 oe_debug_pub.add('Entering OE_Line_Adj_Util.Lock_Row.', 1);
4216 SAVEPOINT Lock_Row;
4217
4218 l_lock_control := NULL;
4219
4220 IF p_order_price_attrib_id <> FND_API.G_MISS_NUM THEN
4221 l_order_price_attrib_id := p_order_price_attrib_id;
4222 ELSE
4223 l_order_price_attrib_id := p_x_Line_Price_Att_rec.order_price_attrib_id;
4224 l_lock_control := p_x_Line_Price_Att_rec.lock_control;
4225 END IF;
4226
4227 SELECT order_price_attrib_id
4228 INTO l_order_price_attrib_id
4229 FROM oe_order_price_attribs
4230 WHERE order_price_attrib_id = l_order_price_attrib_id
4231 FOR UPDATE NOWAIT;
4232
4233 OE_Line_PAttr_Util.Query_Row
4234 (p_order_price_attrib_id => l_order_price_attrib_id
4235 ,x_Line_Price_Att_rec => p_x_Line_Price_Att_rec
4236 );
4237
4238
4239 oe_debug_pub.add('queried lock_control: '|| p_x_line_price_att_rec.lock_control, 1);
4240
4241 -- If lock_control is not passed(is null or missing), then return the locked record.
4242
4243
4244 IF l_lock_control is null OR
4245 l_lock_control = FND_API.G_MISS_NUM
4246 THEN
4247
4248 -- Set return status
4249 x_return_status := FND_API.G_RET_STS_SUCCESS;
4250 p_x_line_Price_Att_rec.return_status := FND_API.G_RET_STS_SUCCESS;
4251
4252 -- return for lock by ID.
4253 RETURN;
4254
4255 END IF;
4256
4257 -- Row locked. If the whole record is passed, then
4258 -- Compare lock_control.
4259
4260 oe_debug_pub.add('compare ', 1);
4261
4262 IF OE_GLOBALS.Equal(p_x_line_Price_Att_rec.lock_control,
4263 l_lock_control)
4264 THEN
4265
4266 -- Row has not changed. Set out parameter.
4267
4268 oe_debug_pub.add('locked row', 1);
4269
4270 -- Set return status
4271
4272 x_return_status := FND_API.G_RET_STS_SUCCESS;
4273 p_x_line_Price_Att_rec.return_status := FND_API.G_RET_STS_SUCCESS;
4274
4275 ELSE
4276
4277 -- Row has changed by another user.
4278 oe_debug_pub.add('row changed by other user', 1);
4279
4280 x_return_status := FND_API.G_RET_STS_ERROR;
4281 p_x_line_Price_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
4282
4283 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4284 THEN
4285
4286 -- Release the lock
4287 ROLLBACK TO Lock_Row;
4288
4289 fnd_message.set_name('ONT','OE_LOCK_ROW_CHANGED');
4290 OE_MSG_PUB.Add;
4291
4292 END IF;
4293
4294 END IF;
4295
4296 EXCEPTION
4297
4298 WHEN NO_DATA_FOUND THEN
4299
4300 x_return_status := FND_API.G_RET_STS_ERROR;
4301 p_x_Line_Price_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
4302
4303 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4304 THEN
4305
4306 FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_DELETED');
4307 FND_MSG_PUB.Add;
4308
4309 END IF;
4310 WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4311
4312 x_return_status := FND_API.G_RET_STS_ERROR;
4313 p_x_Line_Price_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
4314
4315 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4316 THEN
4317
4318 FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_ALREADY_LOCKED');
4319 FND_MSG_PUB.Add;
4320
4321 END IF;
4322 WHEN OTHERS THEN
4323
4324 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4325 p_x_Line_Price_Att_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4326
4327 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4328 THEN
4329 FND_MSG_PUB.Add_Exc_Msg
4330 ( G_PKG_NAME
4331 , 'Lock_Row'
4332 );
4333 END IF;
4334
4335 END Lock_Row;
4336
4337 -- procedure lock_rows
4338 PROCEDURE Lock_Rows
4339 ( p_order_price_attrib_id IN NUMBER
4340 := FND_API.G_MISS_NUM
4341 , p_line_id IN NUMBER
4342 := FND_API.G_MISS_NUM
4343 , x_Line_Price_Att_tbl OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
4344 , x_return_status OUT NOCOPY VARCHAR2
4345 )
4346 IS
4347
4348 CURSOR lock_pattr_lines(p_line_id IN NUMBER) IS
4349 SELECT order_price_attrib_id
4350 FROM oe_order_price_attribs
4351 WHERE line_id = p_line_id
4352 FOR UPDATE NOWAIT;
4353
4354 l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4355 l_order_price_attrib_id NUMBER;
4356 l_lock_control NUMBER;
4357
4358 BEGIN
4359
4360 oe_debug_pub.add('Entering OE_Line_PAttr_Util.Lock_Rows.', 1);
4361
4362 IF (p_order_price_attrib_id IS NOT NULL AND
4363 p_order_price_attrib_id <> FND_API.G_MISS_NUM) AND
4364 (p_line_id IS NOT NULL AND
4365 p_line_id <> FND_API.G_MISS_NUM)
4366 THEN
4367 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4368 OE_MSG_PUB.Add_Exc_Msg
4369 ( G_PKG_NAME
4370 , 'Lock_Rows'
4371 , 'Keys are mutually exclusive: order_price_attrib_id = ' ||
4372 p_order_price_attrib_id || ', line_id = ' || p_line_id );
4373 END IF;
4374
4375 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4376 END IF;
4377
4378 IF p_order_price_attrib_id <> FND_API.G_MISS_NUM THEN
4379
4380 SELECT order_price_attrib_id
4381 INTO l_order_price_attrib_id
4382 FROM oe_order_price_attribs
4383 WHERE order_price_attrib_id = p_order_price_attrib_id
4384 FOR UPDATE NOWAIT;
4385 END IF;
4386
4387 -- null line_id shouldn't be passed in unnecessarily if
4388 -- order_price_attrib_id is passed in already.
4389 BEGIN
4390 IF p_line_id <> FND_API.G_MISS_NUM THEN
4391 SAVEPOINT LOCK_ROWS;
4392 OPEN lock_pattr_lines(p_line_id);
4393
4394 LOOP
4395 FETCH lock_pattr_lines INTO l_order_price_attrib_id;
4396 EXIT WHEN lock_pattr_lines%NOTFOUND;
4397 END LOOP;
4398 CLOSE lock_pattr_lines;
4399 END IF;
4400 EXCEPTION
4401 WHEN OTHERS THEN
4402 ROLLBACK TO LOCK_ROWS;
4403
4404 IF lock_pattr_lines%ISOPEN THEN
4405 CLOSE lock_pattr_lines;
4406 END IF;
4407
4408 RAISE;
4409 END;
4410
4411
4412 OE_Line_PAttr_Util.Query_Rows
4413 ( p_order_price_attrib_id => p_order_price_attrib_id
4414 , p_line_id => p_line_id
4415 , x_Line_Price_Att_tbl => x_Line_Price_Att_tbl
4416 );
4417
4418 x_return_status := FND_API.G_RET_STS_SUCCESS;
4419
4420 EXCEPTION
4421 WHEN NO_DATA_FOUND THEN
4422 x_return_status := FND_API.G_RET_STS_ERROR;
4423 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4424 THEN
4425 fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
4426 OE_MSG_PUB.Add;
4427 END IF;
4428
4429 WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4430 x_return_status := FND_API.G_RET_STS_ERROR;
4431 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4432 THEN
4433 fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
4434 OE_MSG_PUB.Add;
4435 END IF;
4436
4437 WHEN OTHERS THEN
4438 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4439 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4440 THEN
4441 OE_MSG_PUB.Add_Exc_Msg
4442 ( G_PKG_NAME
4443 , 'Lock_Row'
4444 );
4445 END IF;
4446
4447 oe_debug_pub.add('Exiting OE_Line_PAttr_Util.Lock_Rows.', 1);
4448
4449
4450 END lock_rows;
4451
4452 PROCEDURE copy_pricing_attributes
4453 ( p_from_line_id NUMBER
4454 , p_to_line_id NUMBER
4455 , p_to_header_id NUMBER
4456 , x_return_status OUT NOCOPY VARCHAR2
4457 ) IS
4458
4459 l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;
4460 l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
4461 l_control_rec Oe_Globals.Control_rec_type;
4462 l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4463 l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4464 l_header_rec OE_Order_PUB.Header_Rec_Type;
4465 l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4466 l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4467 l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4468 l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4469 l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4470 l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4471 l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4472 l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4473 l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4474 l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
4475 l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4476 l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4477 l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4478 l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4479 l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4480 l_x_msg_count number;
4481 l_x_msg_data Varchar2(2000);
4482 l_df_error_code number := 0;
4483 --serla begin
4484 l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
4485 l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4486 --serla end
4487 i PLS_INTEGER;
4488
4489 BEGIN
4490 oe_debug_pub.add('Entering OE_Line_PAttr_Util.copy_pricing_attribtes.', 1);
4491
4492 OE_Line_PAttr_Util.Query_rows(p_line_id => p_from_line_id
4493 , x_Line_Price_att_tbl => l_Line_Price_Att_tbl);
4494
4495
4496 i := l_line_price_att_tbl.First;
4497 While i IS NOT NULL LOOP
4498
4499 oe_debug_pub.add('Entering the LOOP ... : ', 1);
4500
4501 -- calling Pricing API to check if the pricing context is valid.
4502 QP_UTIL.validate_context_code(
4503 p_flexfield_name => l_line_price_att_tbl(i).flex_title
4504 ,p_application_short_name => 'QP'
4505 ,p_context_name => l_line_price_att_tbl(i).pricing_context
4506 ,p_error_code => l_df_error_code);
4507
4508
4509 IF l_df_error_code = 0 THEN
4510 -- copy it if the pricing context is valid, don't copy if it is invalid
4511
4512 l_line_price_att_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
4513 l_line_price_att_tbl(i).line_id := p_to_line_id;
4514 l_line_price_att_tbl(i).header_id := p_to_header_id;
4515 l_line_price_att_tbl(i).order_price_attrib_id := FND_API.G_MISS_NUM;
4516
4517 l_x_line_price_att_tbl(l_x_line_price_att_tbl.count+1)
4518 := l_line_price_att_tbl(i);
4519
4520
4521 END IF;
4522
4523 i:= L_Line_Price_Att_Tbl.Next(i);
4524
4525 END LOOP;
4526
4527
4528 IF l_x_line_price_att_tbl.count > 0 THEN
4529
4530 -- set control record
4531 l_control_rec.controlled_operation := TRUE;
4532 l_control_rec.write_to_DB := TRUE;
4533 l_control_rec.change_attributes := TRUE;
4534 l_control_rec.default_attributes := TRUE;
4535 l_control_rec.validate_entity := TRUE;
4536 l_control_rec.clear_dependents := TRUE;
4537
4538 l_control_rec.process := FALSE;
4539 l_control_rec.clear_api_cache := FALSE;
4540 l_control_rec.clear_api_requests := FALSE;
4541
4542
4543 -- Call OE_Order_PVT.Process_order
4544
4545 oe_debug_pub.add('Before OE_Order_PVT.Process_order',1);
4546
4547 -- OE_Globals.G_RECURSION_MODE := 'Y';
4548
4549
4550 OE_Order_PVT.Process_order
4551 ( p_api_version_number => 1.0
4552 , x_return_status => x_return_status
4553 , x_msg_count => l_x_msg_count
4554 , x_msg_data => l_x_msg_data
4555 , p_control_rec => l_control_rec
4556 , p_x_Line_Adj_tbl => l_Line_Adj_tbl
4557 , p_x_Line_Adj_att_tbl => l_Line_Adj_att_tbl
4558 -- , x_header_rec => l_x_header_rec
4559 , p_x_header_rec => l_header_rec
4560 , p_x_Header_Adj_tbl => l_x_Header_Adj_tbl
4561 , p_x_header_price_att_tbl => l_x_header_price_att_tbl
4562 , p_x_Header_Adj_att_tbl => l_x_Header_Adj_att_tbl
4563 , p_x_Header_Adj_Assoc_tbl => l_x_Header_Adj_Assoc_tbl
4564 , p_x_Header_Scredit_tbl => l_x_Header_Scredit_tbl
4565 --serla begin
4566 , p_x_Header_Payment_tbl => l_x_Header_Payment_tbl
4567 --serla end
4568 -- , p_x_line_tbl => l_x_line_tbl
4569 , p_x_line_tbl => l_line_tbl
4570 -- , x_Line_Adj_tbl => l_x_Line_Adj_tbl
4571 , p_x_Line_Price_att_tbl => l_x_Line_Price_att_tbl
4572 -- , x_Line_Adj_att_tbl => l_x_Line_Adj_att_tbl
4573 -- , x_Line_Adj_Assoc_tbl => l_x_Line_Adj_Assoc_tbl
4574 , p_x_Line_Adj_Assoc_tbl => l_Line_Adj_Assoc_tbl
4575 , p_x_Line_Scredit_tbl => l_x_Line_Scredit_tbl
4576 --serla begin
4577 , p_x_Line_Payment_tbl => l_x_Line_Payment_tbl
4578 --serla end
4579 , p_x_Lot_Serial_tbl => l_x_Lot_Serial_Tbl
4580 , p_x_action_request_tbl => l_x_Action_Request_tbl
4581 , p_validation_level => OE_GLOBALS.G_VALID_LEVEL_PARTIAL
4582 );
4583
4584 -- OE_Globals.G_RECURSION_MODE := 'N';
4585
4586 End IF;
4587
4588 IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4589 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4590 ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
4591 RAISE FND_API.G_EXC_ERROR;
4592 END IF;
4593
4594 oe_debug_pub.add('Exiting OE_Line_PAttr_Util.copy_pricing_attribtes.', 1);
4595
4596 Exception
4597 WHEN FND_API.G_EXC_ERROR THEN
4598
4599 x_return_status := FND_API.G_RET_STS_ERROR;
4600
4601 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4602
4603 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4604
4605 END copy_pricing_attributes;
4606
4607 -- Fixed bug 1857538
4608 -- copy_model_pattr now takes only the line_id as parameter
4609 -- Get the model_line_id and use it to inherit the
4610 -- pricing attributes and pricing context
4611
4612 PROCEDURE copy_model_pattr
4613 (
4614 -- p_model_line_id NUMBER
4615 p_to_line_id NUMBER
4616 , x_return_status OUT NOCOPY VARCHAR2
4617 ) IS
4618
4619 /* not needed, as per bug1857538
4620
4621 CURSOR Get_Option_Lines(p_model_line_id IN NUMBER)
4622 IS
4623 SELECT header_id, line_id
4624 FROM oe_order_lines
4625 WHERE top_model_line_id = p_model_line_id
4626 AND (item_type_code = OE_GLOBALS.G_ITEM_OPTION
4627 OR item_type_code = OE_GLOBALS.G_ITEM_CLASS
4628 OR item_type_code = OE_GLOBALS.G_ITEM_KIT);
4629 */
4630
4631
4632 l_from_header_id NUMBER;
4633 l_top_model_line_id NUMBER;
4634
4635
4636 BEGIN
4637
4638 oe_debug_pub.add('Entering OE_Line_PAttr_Util.copy_model_pattr.', 1);
4639
4640 SELECT top_model_line_id, header_id
4641 INTO l_top_model_line_id, l_from_header_id
4642 FROM oe_order_lines
4643 WHERE line_id = p_to_line_id;
4644
4645 /* -- not needed, fixed bug 1857538
4646
4647 OPEN Get_Option_Lines(p_model_line_id);
4648 LOOP
4649 FETCH Get_Option_Lines INTO l_from_header_id, l_to_line_id;
4650 EXIT WHEN Get_Option_Lines%NOTFOUND;
4651 */
4652
4653 oe_debug_pub.add('Copying pricing attributes for line '||p_to_line_id);
4654
4655 copy_pricing_attributes
4656 ( p_from_line_id => l_top_model_line_id
4657 ,p_to_line_id => p_to_line_id
4658 ,p_to_header_id => l_from_header_id
4659 ,x_return_status => x_return_status
4660 );
4661
4662 /* --not needed, as per bug1857538
4663 END LOOP;
4664 CLOSE Get_Option_Lines;
4665 */
4666
4667
4668 IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4669 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4670 ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
4671 RAISE FND_API.G_EXC_ERROR;
4672 END IF;
4673
4674 oe_debug_pub.add('Exiting OE_Line_PAttr_Util.copy_model_pattr.', 1);
4675
4676 EXCEPTION
4677 WHEN FND_API.G_EXC_ERROR THEN
4678
4679 x_return_status := FND_API.G_RET_STS_ERROR;
4680
4681 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4682
4683 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4684
4685 END copy_model_pattr;
4686
4687 END OE_Line_PAttr_Util;