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