[Home] [Help]
PACKAGE BODY: APPS.CSI_I_PRICING_ATTRIBS_H_PKG
Source
1 PACKAGE BODY CSI_I_PRICING_ATTRIBS_H_PKG as
2 /* $Header: csitpahb.pls 115.16 2003/09/04 00:21:55 sguthiva ship $ */
3
4
5 g_pkg_name CONSTANT VARCHAR2(30):= 'CSI_I_PRICING_ATTRIBS_H_PKG';
6
7 PROCEDURE Insert_Row(
8 px_PRICE_ATTRIB_HISTORY_ID IN OUT NOCOPY NUMBER,
9 p_PRICING_ATTRIBUTE_ID NUMBER,
10 p_TRANSACTION_ID NUMBER,
11 p_OLD_PRICING_CONTEXT VARCHAR2,
12 p_NEW_PRICING_CONTEXT VARCHAR2,
13 p_OLD_PRICING_ATTRIBUTE1 VARCHAR2,
14 p_NEW_PRICING_ATTRIBUTE1 VARCHAR2,
15 p_OLD_PRICING_ATTRIBUTE2 VARCHAR2,
16 p_NEW_PRICING_ATTRIBUTE2 VARCHAR2,
17 p_OLD_PRICING_ATTRIBUTE3 VARCHAR2,
18 p_NEW_PRICING_ATTRIBUTE3 VARCHAR2,
19 p_OLD_PRICING_ATTRIBUTE4 VARCHAR2,
20 p_NEW_PRICING_ATTRIBUTE4 VARCHAR2,
21 p_OLD_PRICING_ATTRIBUTE5 VARCHAR2,
22 p_NEW_PRICING_ATTRIBUTE5 VARCHAR2,
23 p_OLD_PRICING_ATTRIBUTE6 VARCHAR2,
24 p_NEW_PRICING_ATTRIBUTE6 VARCHAR2,
25 p_OLD_PRICING_ATTRIBUTE7 VARCHAR2,
26 p_NEW_PRICING_ATTRIBUTE7 VARCHAR2,
27 p_OLD_PRICING_ATTRIBUTE8 VARCHAR2,
28 p_NEW_PRICING_ATTRIBUTE8 VARCHAR2,
29 p_OLD_PRICING_ATTRIBUTE9 VARCHAR2,
30 p_NEW_PRICING_ATTRIBUTE9 VARCHAR2,
31 p_OLD_PRICING_ATTRIBUTE10 VARCHAR2,
32 p_NEW_PRICING_ATTRIBUTE10 VARCHAR2,
33 p_OLD_PRICING_ATTRIBUTE11 VARCHAR2,
34 p_NEW_PRICING_ATTRIBUTE11 VARCHAR2,
35 p_OLD_PRICING_ATTRIBUTE12 VARCHAR2,
36 p_NEW_PRICING_ATTRIBUTE12 VARCHAR2,
37 p_OLD_PRICING_ATTRIBUTE13 VARCHAR2,
38 p_NEW_PRICING_ATTRIBUTE13 VARCHAR2,
39 p_OLD_PRICING_ATTRIBUTE14 VARCHAR2,
40 p_NEW_PRICING_ATTRIBUTE14 VARCHAR2,
41 p_OLD_PRICING_ATTRIBUTE15 VARCHAR2,
42 p_NEW_PRICING_ATTRIBUTE15 VARCHAR2,
43 p_OLD_PRICING_ATTRIBUTE16 VARCHAR2,
44 p_NEW_PRICING_ATTRIBUTE16 VARCHAR2,
45 p_OLD_PRICING_ATTRIBUTE17 VARCHAR2,
46 p_NEW_PRICING_ATTRIBUTE17 VARCHAR2,
47 p_OLD_PRICING_ATTRIBUTE18 VARCHAR2,
48 p_NEW_PRICING_ATTRIBUTE18 VARCHAR2,
49 p_OLD_PRICING_ATTRIBUTE19 VARCHAR2,
50 p_NEW_PRICING_ATTRIBUTE19 VARCHAR2,
51 p_OLD_PRICING_ATTRIBUTE20 VARCHAR2,
52 p_NEW_PRICING_ATTRIBUTE20 VARCHAR2,
53 p_OLD_PRICING_ATTRIBUTE21 VARCHAR2,
54 p_NEW_PRICING_ATTRIBUTE21 VARCHAR2,
55 p_OLD_PRICING_ATTRIBUTE22 VARCHAR2,
56 p_NEW_PRICING_ATTRIBUTE22 VARCHAR2,
57 p_OLD_PRICING_ATTRIBUTE23 VARCHAR2,
58 p_NEW_PRICING_ATTRIBUTE23 VARCHAR2,
59 p_OLD_PRICING_ATTRIBUTE24 VARCHAR2,
60 p_NEW_PRICING_ATTRIBUTE24 VARCHAR2,
61 p_NEW_PRICING_ATTRIBUTE25 VARCHAR2,
62 p_OLD_PRICING_ATTRIBUTE25 VARCHAR2,
63 p_OLD_PRICING_ATTRIBUTE26 VARCHAR2,
64 p_NEW_PRICING_ATTRIBUTE26 VARCHAR2,
65 p_OLD_PRICING_ATTRIBUTE27 VARCHAR2,
66 p_NEW_PRICING_ATTRIBUTE27 VARCHAR2,
67 p_OLD_PRICING_ATTRIBUTE28 VARCHAR2,
68 p_NEW_PRICING_ATTRIBUTE28 VARCHAR2,
69 p_OLD_PRICING_ATTRIBUTE29 VARCHAR2,
70 p_NEW_PRICING_ATTRIBUTE29 VARCHAR2,
71 p_OLD_PRICING_ATTRIBUTE30 VARCHAR2,
72 p_NEW_PRICING_ATTRIBUTE30 VARCHAR2,
73 p_OLD_PRICING_ATTRIBUTE31 VARCHAR2,
74 p_NEW_PRICING_ATTRIBUTE31 VARCHAR2,
75 p_OLD_PRICING_ATTRIBUTE32 VARCHAR2,
76 p_NEW_PRICING_ATTRIBUTE32 VARCHAR2,
77 p_OLD_PRICING_ATTRIBUTE33 VARCHAR2,
78 p_NEW_PRICING_ATTRIBUTE33 VARCHAR2,
79 p_OLD_PRICING_ATTRIBUTE34 VARCHAR2,
80 p_NEW_PRICING_ATTRIBUTE34 VARCHAR2,
81 p_OLD_PRICING_ATTRIBUTE35 VARCHAR2,
82 p_NEW_PRICING_ATTRIBUTE35 VARCHAR2,
83 p_OLD_PRICING_ATTRIBUTE36 VARCHAR2,
84 p_NEW_PRICING_ATTRIBUTE36 VARCHAR2,
85 p_OLD_PRICING_ATTRIBUTE37 VARCHAR2,
86 p_NEW_PRICING_ATTRIBUTE37 VARCHAR2,
87 p_OLD_PRICING_ATTRIBUTE38 VARCHAR2,
88 p_NEW_PRICING_ATTRIBUTE38 VARCHAR2,
89 p_OLD_PRICING_ATTRIBUTE39 VARCHAR2,
90 p_NEW_PRICING_ATTRIBUTE39 VARCHAR2,
91 p_OLD_PRICING_ATTRIBUTE40 VARCHAR2,
92 p_NEW_PRICING_ATTRIBUTE40 VARCHAR2,
93 p_OLD_PRICING_ATTRIBUTE41 VARCHAR2,
94 p_NEW_PRICING_ATTRIBUTE41 VARCHAR2,
95 p_OLD_PRICING_ATTRIBUTE42 VARCHAR2,
96 p_NEW_PRICING_ATTRIBUTE42 VARCHAR2,
97 p_OLD_PRICING_ATTRIBUTE43 VARCHAR2,
98 p_NEW_PRICING_ATTRIBUTE43 VARCHAR2,
99 p_OLD_PRICING_ATTRIBUTE44 VARCHAR2,
100 p_NEW_PRICING_ATTRIBUTE44 VARCHAR2,
101 p_OLD_PRICING_ATTRIBUTE45 VARCHAR2,
102 p_NEW_PRICING_ATTRIBUTE45 VARCHAR2,
103 p_OLD_PRICING_ATTRIBUTE46 VARCHAR2,
104 p_NEW_PRICING_ATTRIBUTE46 VARCHAR2,
105 p_OLD_PRICING_ATTRIBUTE47 VARCHAR2,
106 p_NEW_PRICING_ATTRIBUTE47 VARCHAR2,
107 p_OLD_PRICING_ATTRIBUTE48 VARCHAR2,
108 p_NEW_PRICING_ATTRIBUTE48 VARCHAR2,
109 p_OLD_PRICING_ATTRIBUTE49 VARCHAR2,
110 p_NEW_PRICING_ATTRIBUTE49 VARCHAR2,
111 p_OLD_PRICING_ATTRIBUTE50 VARCHAR2,
112 p_NEW_PRICING_ATTRIBUTE50 VARCHAR2,
113 p_OLD_PRICING_ATTRIBUTE51 VARCHAR2,
114 p_NEW_PRICING_ATTRIBUTE51 VARCHAR2,
115 p_OLD_PRICING_ATTRIBUTE52 VARCHAR2,
116 p_NEW_PRICING_ATTRIBUTE52 VARCHAR2,
117 p_OLD_PRICING_ATTRIBUTE53 VARCHAR2,
118 p_NEW_PRICING_ATTRIBUTE53 VARCHAR2,
119 p_OLD_PRICING_ATTRIBUTE54 VARCHAR2,
120 p_NEW_PRICING_ATTRIBUTE54 VARCHAR2,
121 p_OLD_PRICING_ATTRIBUTE55 VARCHAR2,
122 p_NEW_PRICING_ATTRIBUTE55 VARCHAR2,
123 p_OLD_PRICING_ATTRIBUTE56 VARCHAR2,
124 p_NEW_PRICING_ATTRIBUTE56 VARCHAR2,
125 p_OLD_PRICING_ATTRIBUTE57 VARCHAR2,
126 p_NEW_PRICING_ATTRIBUTE57 VARCHAR2,
127 p_OLD_PRICING_ATTRIBUTE58 VARCHAR2,
128 p_NEW_PRICING_ATTRIBUTE58 VARCHAR2,
129 p_OLD_PRICING_ATTRIBUTE59 VARCHAR2,
130 p_NEW_PRICING_ATTRIBUTE59 VARCHAR2,
131 p_OLD_PRICING_ATTRIBUTE60 VARCHAR2,
132 p_NEW_PRICING_ATTRIBUTE60 VARCHAR2,
133 p_OLD_PRICING_ATTRIBUTE61 VARCHAR2,
134 p_NEW_PRICING_ATTRIBUTE61 VARCHAR2,
135 p_OLD_PRICING_ATTRIBUTE62 VARCHAR2,
136 p_NEW_PRICING_ATTRIBUTE62 VARCHAR2,
137 p_OLD_PRICING_ATTRIBUTE63 VARCHAR2,
138 p_NEW_PRICING_ATTRIBUTE63 VARCHAR2,
139 p_OLD_PRICING_ATTRIBUTE64 VARCHAR2,
140 p_NEW_PRICING_ATTRIBUTE64 VARCHAR2,
141 p_OLD_PRICING_ATTRIBUTE65 VARCHAR2,
142 p_NEW_PRICING_ATTRIBUTE65 VARCHAR2,
143 p_OLD_PRICING_ATTRIBUTE66 VARCHAR2,
144 p_NEW_PRICING_ATTRIBUTE66 VARCHAR2,
145 p_OLD_PRICING_ATTRIBUTE67 VARCHAR2,
146 p_NEW_PRICING_ATTRIBUTE67 VARCHAR2,
147 p_OLD_PRICING_ATTRIBUTE68 VARCHAR2,
148 p_NEW_PRICING_ATTRIBUTE68 VARCHAR2,
149 p_OLD_PRICING_ATTRIBUTE69 VARCHAR2,
150 p_NEW_PRICING_ATTRIBUTE69 VARCHAR2,
151 p_OLD_PRICING_ATTRIBUTE70 VARCHAR2,
152 p_NEW_PRICING_ATTRIBUTE70 VARCHAR2,
153 p_OLD_PRICING_ATTRIBUTE71 VARCHAR2,
154 p_NEW_PRICING_ATTRIBUTE71 VARCHAR2,
155 p_OLD_PRICING_ATTRIBUTE72 VARCHAR2,
156 p_NEW_PRICING_ATTRIBUTE72 VARCHAR2,
157 p_OLD_PRICING_ATTRIBUTE73 VARCHAR2,
158 p_NEW_PRICING_ATTRIBUTE73 VARCHAR2,
159 p_OLD_PRICING_ATTRIBUTE74 VARCHAR2,
160 p_NEW_PRICING_ATTRIBUTE74 VARCHAR2,
161 p_OLD_PRICING_ATTRIBUTE75 VARCHAR2,
162 p_NEW_PRICING_ATTRIBUTE75 VARCHAR2,
163 p_OLD_PRICING_ATTRIBUTE76 VARCHAR2,
164 p_NEW_PRICING_ATTRIBUTE76 VARCHAR2,
165 p_OLD_PRICING_ATTRIBUTE77 VARCHAR2,
166 p_NEW_PRICING_ATTRIBUTE77 VARCHAR2,
167 p_OLD_PRICING_ATTRIBUTE78 VARCHAR2,
168 p_NEW_PRICING_ATTRIBUTE78 VARCHAR2,
169 p_OLD_PRICING_ATTRIBUTE79 VARCHAR2,
170 p_NEW_PRICING_ATTRIBUTE79 VARCHAR2,
171 p_OLD_PRICING_ATTRIBUTE80 VARCHAR2,
172 p_NEW_PRICING_ATTRIBUTE80 VARCHAR2,
173 p_OLD_PRICING_ATTRIBUTE81 VARCHAR2,
174 p_NEW_PRICING_ATTRIBUTE81 VARCHAR2,
175 p_OLD_PRICING_ATTRIBUTE82 VARCHAR2,
176 p_NEW_PRICING_ATTRIBUTE82 VARCHAR2,
177 p_OLD_PRICING_ATTRIBUTE83 VARCHAR2,
178 p_NEW_PRICING_ATTRIBUTE83 VARCHAR2,
179 p_OLD_PRICING_ATTRIBUTE84 VARCHAR2,
180 p_NEW_PRICING_ATTRIBUTE84 VARCHAR2,
181 p_OLD_PRICING_ATTRIBUTE85 VARCHAR2,
182 p_NEW_PRICING_ATTRIBUTE85 VARCHAR2,
183 p_OLD_PRICING_ATTRIBUTE86 VARCHAR2,
184 p_NEW_PRICING_ATTRIBUTE86 VARCHAR2,
185 p_OLD_PRICING_ATTRIBUTE87 VARCHAR2,
186 p_NEW_PRICING_ATTRIBUTE87 VARCHAR2,
187 p_OLD_PRICING_ATTRIBUTE88 VARCHAR2,
188 p_NEW_PRICING_ATTRIBUTE88 VARCHAR2,
189 p_OLD_PRICING_ATTRIBUTE89 VARCHAR2,
190 p_NEW_PRICING_ATTRIBUTE89 VARCHAR2,
191 p_OLD_PRICING_ATTRIBUTE90 VARCHAR2,
192 p_NEW_PRICING_ATTRIBUTE90 VARCHAR2,
193 p_OLD_PRICING_ATTRIBUTE91 VARCHAR2,
194 p_NEW_PRICING_ATTRIBUTE91 VARCHAR2,
195 p_OLD_PRICING_ATTRIBUTE92 VARCHAR2,
196 p_NEW_PRICING_ATTRIBUTE92 VARCHAR2,
197 p_OLD_PRICING_ATTRIBUTE93 VARCHAR2,
198 p_NEW_PRICING_ATTRIBUTE93 VARCHAR2,
199 p_OLD_PRICING_ATTRIBUTE94 VARCHAR2,
200 p_NEW_PRICING_ATTRIBUTE94 VARCHAR2,
201 p_OLD_PRICING_ATTRIBUTE95 VARCHAR2,
202 p_NEW_PRICING_ATTRIBUTE95 VARCHAR2,
203 p_OLD_PRICING_ATTRIBUTE96 VARCHAR2,
204 p_NEW_PRICING_ATTRIBUTE96 VARCHAR2,
205 p_OLD_PRICING_ATTRIBUTE97 VARCHAR2,
206 p_NEW_PRICING_ATTRIBUTE97 VARCHAR2,
207 p_OLD_PRICING_ATTRIBUTE98 VARCHAR2,
208 p_NEW_PRICING_ATTRIBUTE98 VARCHAR2,
209 p_OLD_PRICING_ATTRIBUTE99 VARCHAR2,
210 p_NEW_PRICING_ATTRIBUTE99 VARCHAR2,
211 p_OLD_PRICING_ATTRIBUTE100 VARCHAR2,
212 p_NEW_PRICING_ATTRIBUTE100 VARCHAR2,
213 p_OLD_ACTIVE_START_DATE DATE,
214 p_NEW_ACTIVE_START_DATE DATE,
215 p_OLD_ACTIVE_END_DATE DATE,
216 p_NEW_ACTIVE_END_DATE DATE,
217 p_OLD_CONTEXT VARCHAR2,
218 p_NEW_CONTEXT VARCHAR2,
219 p_OLD_ATTRIBUTE1 VARCHAR2,
220 p_NEW_ATTRIBUTE1 VARCHAR2,
221 p_OLD_ATTRIBUTE2 VARCHAR2,
222 p_NEW_ATTRIBUTE2 VARCHAR2,
223 p_OLD_ATTRIBUTE3 VARCHAR2,
224 p_NEW_ATTRIBUTE3 VARCHAR2,
225 p_OLD_ATTRIBUTE4 VARCHAR2,
226 p_NEW_ATTRIBUTE4 VARCHAR2,
227 p_OLD_ATTRIBUTE5 VARCHAR2,
228 p_NEW_ATTRIBUTE5 VARCHAR2,
229 p_OLD_ATTRIBUTE6 VARCHAR2,
230 p_NEW_ATTRIBUTE6 VARCHAR2,
231 p_OLD_ATTRIBUTE7 VARCHAR2,
232 p_NEW_ATTRIBUTE7 VARCHAR2,
233 p_OLD_ATTRIBUTE8 VARCHAR2,
234 p_NEW_ATTRIBUTE8 VARCHAR2,
235 p_OLD_ATTRIBUTE9 VARCHAR2,
236 p_NEW_ATTRIBUTE9 VARCHAR2,
237 p_OLD_ATTRIBUTE10 VARCHAR2,
238 p_NEW_ATTRIBUTE10 VARCHAR2,
239 p_OLD_ATTRIBUTE11 VARCHAR2,
240 p_NEW_ATTRIBUTE11 VARCHAR2,
241 p_OLD_ATTRIBUTE12 VARCHAR2,
242 p_NEW_ATTRIBUTE12 VARCHAR2,
243 p_OLD_ATTRIBUTE13 VARCHAR2,
244 p_NEW_ATTRIBUTE13 VARCHAR2,
245 p_OLD_ATTRIBUTE14 VARCHAR2,
246 p_NEW_ATTRIBUTE14 VARCHAR2,
247 p_OLD_ATTRIBUTE15 VARCHAR2,
248 p_NEW_ATTRIBUTE15 VARCHAR2,
249 p_FULL_DUMP_FLAG VARCHAR2,
250 p_CREATED_BY NUMBER,
251 p_CREATION_DATE DATE,
252 p_LAST_UPDATED_BY NUMBER,
253 p_LAST_UPDATE_DATE DATE,
254 p_LAST_UPDATE_LOGIN NUMBER,
255 p_OBJECT_VERSION_NUMBER NUMBER)
256 IS
257 CURSOR C2 IS SELECT CSI_I_PRICING_ATTRIBS_H_S.nextval FROM sys.dual;
258 BEGIN
259 If (px_PRICE_ATTRIB_HISTORY_ID IS NULL) OR (px_PRICE_ATTRIB_HISTORY_ID = FND_API.G_MISS_NUM) then
260 OPEN C2;
261 FETCH C2 INTO px_PRICE_ATTRIB_HISTORY_ID;
262 CLOSE C2;
263 End If;
264 INSERT INTO CSI_I_PRICING_ATTRIBS_H(
265 PRICE_ATTRIB_HISTORY_ID,
266 PRICING_ATTRIBUTE_ID,
267 TRANSACTION_ID,
268 OLD_PRICING_CONTEXT,
269 NEW_PRICING_CONTEXT,
270 OLD_PRICING_ATTRIBUTE1,
271 NEW_PRICING_ATTRIBUTE1,
272 OLD_PRICING_ATTRIBUTE2,
273 NEW_PRICING_ATTRIBUTE2,
274 OLD_PRICING_ATTRIBUTE3,
275 NEW_PRICING_ATTRIBUTE3,
276 OLD_PRICING_ATTRIBUTE4,
277 NEW_PRICING_ATTRIBUTE4,
278 OLD_PRICING_ATTRIBUTE5,
279 NEW_PRICING_ATTRIBUTE5,
280 OLD_PRICING_ATTRIBUTE6,
281 NEW_PRICING_ATTRIBUTE6,
282 OLD_PRICING_ATTRIBUTE7,
283 NEW_PRICING_ATTRIBUTE7,
284 OLD_PRICING_ATTRIBUTE8,
285 NEW_PRICING_ATTRIBUTE8,
286 OLD_PRICING_ATTRIBUTE9,
287 NEW_PRICING_ATTRIBUTE9,
288 OLD_PRICING_ATTRIBUTE10,
289 NEW_PRICING_ATTRIBUTE10,
290 OLD_PRICING_ATTRIBUTE11,
291 NEW_PRICING_ATTRIBUTE11,
292 OLD_PRICING_ATTRIBUTE12,
293 NEW_PRICING_ATTRIBUTE12,
294 OLD_PRICING_ATTRIBUTE13,
295 NEW_PRICING_ATTRIBUTE13,
296 OLD_PRICING_ATTRIBUTE14,
297 NEW_PRICING_ATTRIBUTE14,
298 OLD_PRICING_ATTRIBUTE15,
299 NEW_PRICING_ATTRIBUTE15,
300 OLD_PRICING_ATTRIBUTE16,
301 NEW_PRICING_ATTRIBUTE16,
302 OLD_PRICING_ATTRIBUTE17,
303 NEW_PRICING_ATTRIBUTE17,
304 OLD_PRICING_ATTRIBUTE18,
305 NEW_PRICING_ATTRIBUTE18,
306 OLD_PRICING_ATTRIBUTE19,
307 NEW_PRICING_ATTRIBUTE19,
308 OLD_PRICING_ATTRIBUTE20,
309 NEW_PRICING_ATTRIBUTE20,
310 OLD_PRICING_ATTRIBUTE21,
311 NEW_PRICING_ATTRIBUTE21,
312 OLD_PRICING_ATTRIBUTE22,
313 NEW_PRICING_ATTRIBUTE22,
314 OLD_PRICING_ATTRIBUTE23,
318 NEW_PRICING_ATTRIBUTE25,
315 NEW_PRICING_ATTRIBUTE23,
316 OLD_PRICING_ATTRIBUTE24,
317 NEW_PRICING_ATTRIBUTE24,
319 OLD_PRICING_ATTRIBUTE25,
320 OLD_PRICING_ATTRIBUTE26,
321 NEW_PRICING_ATTRIBUTE26,
322 OLD_PRICING_ATTRIBUTE27,
323 NEW_PRICING_ATTRIBUTE27,
324 OLD_PRICING_ATTRIBUTE28,
325 NEW_PRICING_ATTRIBUTE28,
326 OLD_PRICING_ATTRIBUTE29,
327 NEW_PRICING_ATTRIBUTE29,
328 OLD_PRICING_ATTRIBUTE30,
329 NEW_PRICING_ATTRIBUTE30,
330 OLD_PRICING_ATTRIBUTE31,
331 NEW_PRICING_ATTRIBUTE31,
332 OLD_PRICING_ATTRIBUTE32,
333 NEW_PRICING_ATTRIBUTE32,
334 OLD_PRICING_ATTRIBUTE33,
335 NEW_PRICING_ATTRIBUTE33,
336 OLD_PRICING_ATTRIBUTE34,
337 NEW_PRICING_ATTRIBUTE34,
338 OLD_PRICING_ATTRIBUTE35,
339 NEW_PRICING_ATTRIBUTE35,
340 OLD_PRICING_ATTRIBUTE36,
341 NEW_PRICING_ATTRIBUTE36,
342 OLD_PRICING_ATTRIBUTE37,
343 NEW_PRICING_ATTRIBUTE37,
344 OLD_PRICING_ATTRIBUTE38,
345 NEW_PRICING_ATTRIBUTE38,
346 OLD_PRICING_ATTRIBUTE39,
347 NEW_PRICING_ATTRIBUTE39,
348 OLD_PRICING_ATTRIBUTE40,
349 NEW_PRICING_ATTRIBUTE40,
350 OLD_PRICING_ATTRIBUTE41,
351 NEW_PRICING_ATTRIBUTE41,
352 OLD_PRICING_ATTRIBUTE42,
353 NEW_PRICING_ATTRIBUTE42,
354 OLD_PRICING_ATTRIBUTE43,
355 NEW_PRICING_ATTRIBUTE43,
356 OLD_PRICING_ATTRIBUTE44,
357 NEW_PRICING_ATTRIBUTE44,
358 OLD_PRICING_ATTRIBUTE45,
359 NEW_PRICING_ATTRIBUTE45,
360 OLD_PRICING_ATTRIBUTE46,
361 NEW_PRICING_ATTRIBUTE46,
362 OLD_PRICING_ATTRIBUTE47,
363 NEW_PRICING_ATTRIBUTE47,
364 OLD_PRICING_ATTRIBUTE48,
365 NEW_PRICING_ATTRIBUTE48,
366 OLD_PRICING_ATTRIBUTE49,
367 NEW_PRICING_ATTRIBUTE49,
368 OLD_PRICING_ATTRIBUTE50,
369 NEW_PRICING_ATTRIBUTE50,
370 OLD_PRICING_ATTRIBUTE51,
371 NEW_PRICING_ATTRIBUTE51,
372 OLD_PRICING_ATTRIBUTE52,
373 NEW_PRICING_ATTRIBUTE52,
374 OLD_PRICING_ATTRIBUTE53,
375 NEW_PRICING_ATTRIBUTE53,
376 OLD_PRICING_ATTRIBUTE54,
377 NEW_PRICING_ATTRIBUTE54,
378 OLD_PRICING_ATTRIBUTE55,
379 NEW_PRICING_ATTRIBUTE55,
380 OLD_PRICING_ATTRIBUTE56,
381 NEW_PRICING_ATTRIBUTE56,
382 OLD_PRICING_ATTRIBUTE57,
383 NEW_PRICING_ATTRIBUTE57,
384 OLD_PRICING_ATTRIBUTE58,
385 NEW_PRICING_ATTRIBUTE58,
386 OLD_PRICING_ATTRIBUTE59,
387 NEW_PRICING_ATTRIBUTE59,
388 OLD_PRICING_ATTRIBUTE60,
389 NEW_PRICING_ATTRIBUTE60,
390 OLD_PRICING_ATTRIBUTE61,
391 NEW_PRICING_ATTRIBUTE61,
392 OLD_PRICING_ATTRIBUTE62,
393 NEW_PRICING_ATTRIBUTE62,
394 OLD_PRICING_ATTRIBUTE63,
395 NEW_PRICING_ATTRIBUTE63,
396 OLD_PRICING_ATTRIBUTE64,
397 NEW_PRICING_ATTRIBUTE64,
398 OLD_PRICING_ATTRIBUTE65,
399 NEW_PRICING_ATTRIBUTE65,
400 OLD_PRICING_ATTRIBUTE66,
401 NEW_PRICING_ATTRIBUTE66,
402 OLD_PRICING_ATTRIBUTE67,
403 NEW_PRICING_ATTRIBUTE67,
404 OLD_PRICING_ATTRIBUTE68,
405 NEW_PRICING_ATTRIBUTE68,
406 OLD_PRICING_ATTRIBUTE69,
407 NEW_PRICING_ATTRIBUTE69,
408 OLD_PRICING_ATTRIBUTE70,
409 NEW_PRICING_ATTRIBUTE70,
410 OLD_PRICING_ATTRIBUTE71,
411 NEW_PRICING_ATTRIBUTE71,
412 OLD_PRICING_ATTRIBUTE72,
413 NEW_PRICING_ATTRIBUTE72,
414 OLD_PRICING_ATTRIBUTE73,
415 NEW_PRICING_ATTRIBUTE73,
416 OLD_PRICING_ATTRIBUTE74,
417 NEW_PRICING_ATTRIBUTE74,
418 OLD_PRICING_ATTRIBUTE75,
419 NEW_PRICING_ATTRIBUTE75,
420 OLD_PRICING_ATTRIBUTE76,
421 NEW_PRICING_ATTRIBUTE76,
422 OLD_PRICING_ATTRIBUTE77,
423 NEW_PRICING_ATTRIBUTE77,
424 OLD_PRICING_ATTRIBUTE78,
425 NEW_PRICING_ATTRIBUTE78,
426 OLD_PRICING_ATTRIBUTE79,
427 NEW_PRICING_ATTRIBUTE79,
428 OLD_PRICING_ATTRIBUTE80,
429 NEW_PRICING_ATTRIBUTE80,
430 OLD_PRICING_ATTRIBUTE81,
431 NEW_PRICING_ATTRIBUTE81,
432 OLD_PRICING_ATTRIBUTE82,
433 NEW_PRICING_ATTRIBUTE82,
434 OLD_PRICING_ATTRIBUTE83,
435 NEW_PRICING_ATTRIBUTE83,
436 OLD_PRICING_ATTRIBUTE84,
437 NEW_PRICING_ATTRIBUTE84,
438 OLD_PRICING_ATTRIBUTE85,
439 NEW_PRICING_ATTRIBUTE85,
440 OLD_PRICING_ATTRIBUTE86,
441 NEW_PRICING_ATTRIBUTE86,
442 OLD_PRICING_ATTRIBUTE87,
443 NEW_PRICING_ATTRIBUTE87,
444 OLD_PRICING_ATTRIBUTE88,
445 NEW_PRICING_ATTRIBUTE88,
446 OLD_PRICING_ATTRIBUTE89,
447 NEW_PRICING_ATTRIBUTE89,
448 OLD_PRICING_ATTRIBUTE90,
449 NEW_PRICING_ATTRIBUTE90,
450 OLD_PRICING_ATTRIBUTE91,
451 NEW_PRICING_ATTRIBUTE91,
452 OLD_PRICING_ATTRIBUTE92,
453 NEW_PRICING_ATTRIBUTE92,
454 OLD_PRICING_ATTRIBUTE93,
455 NEW_PRICING_ATTRIBUTE93,
456 OLD_PRICING_ATTRIBUTE94,
457 NEW_PRICING_ATTRIBUTE94,
461 NEW_PRICING_ATTRIBUTE96,
458 OLD_PRICING_ATTRIBUTE95,
459 NEW_PRICING_ATTRIBUTE95,
460 OLD_PRICING_ATTRIBUTE96,
462 OLD_PRICING_ATTRIBUTE97,
463 NEW_PRICING_ATTRIBUTE97,
464 OLD_PRICING_ATTRIBUTE98,
465 NEW_PRICING_ATTRIBUTE98,
466 OLD_PRICING_ATTRIBUTE99,
467 NEW_PRICING_ATTRIBUTE99,
468 OLD_PRICING_ATTRIBUTE100,
469 NEW_PRICING_ATTRIBUTE100,
470 OLD_ACTIVE_START_DATE,
471 NEW_ACTIVE_START_DATE,
472 OLD_ACTIVE_END_DATE,
473 NEW_ACTIVE_END_DATE,
474 OLD_CONTEXT,
475 NEW_CONTEXT,
476 OLD_ATTRIBUTE1,
477 NEW_ATTRIBUTE1,
478 OLD_ATTRIBUTE2,
479 NEW_ATTRIBUTE2,
480 OLD_ATTRIBUTE3,
481 NEW_ATTRIBUTE3,
482 OLD_ATTRIBUTE4,
483 NEW_ATTRIBUTE4,
484 OLD_ATTRIBUTE5,
485 NEW_ATTRIBUTE5,
486 OLD_ATTRIBUTE6,
487 NEW_ATTRIBUTE6,
488 OLD_ATTRIBUTE7,
489 NEW_ATTRIBUTE7,
490 OLD_ATTRIBUTE8,
491 NEW_ATTRIBUTE8,
492 OLD_ATTRIBUTE9,
493 NEW_ATTRIBUTE9,
494 OLD_ATTRIBUTE10,
495 NEW_ATTRIBUTE10,
496 OLD_ATTRIBUTE11,
497 NEW_ATTRIBUTE11,
498 OLD_ATTRIBUTE12,
499 NEW_ATTRIBUTE12,
500 OLD_ATTRIBUTE13,
501 NEW_ATTRIBUTE13,
502 OLD_ATTRIBUTE14,
503 NEW_ATTRIBUTE14,
504 OLD_ATTRIBUTE15,
505 NEW_ATTRIBUTE15,
506 FULL_DUMP_FLAG,
507 CREATED_BY,
508 CREATION_DATE,
509 LAST_UPDATED_BY,
510 LAST_UPDATE_DATE,
511 LAST_UPDATE_LOGIN,
512 OBJECT_VERSION_NUMBER
513 ) VALUES (
514 px_PRICE_ATTRIB_HISTORY_ID,
515 decode( p_PRICING_ATTRIBUTE_ID, FND_API.G_MISS_NUM, NULL, p_PRICING_ATTRIBUTE_ID),
516 decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_ID),
517 decode( p_OLD_PRICING_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_CONTEXT),
518 decode( p_NEW_PRICING_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_CONTEXT),
519 decode( p_OLD_PRICING_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE1),
520 decode( p_NEW_PRICING_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE1),
521 decode( p_OLD_PRICING_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE2),
522 decode( p_NEW_PRICING_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE2),
523 decode( p_OLD_PRICING_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE3),
524 decode( p_NEW_PRICING_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE3),
525 decode( p_OLD_PRICING_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE4),
526 decode( p_NEW_PRICING_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE4),
527 decode( p_OLD_PRICING_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE5),
528 decode( p_NEW_PRICING_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE5),
529 decode( p_OLD_PRICING_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE6),
530 decode( p_NEW_PRICING_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE6),
531 decode( p_OLD_PRICING_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE7),
532 decode( p_NEW_PRICING_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE7),
533 decode( p_OLD_PRICING_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE8),
534 decode( p_NEW_PRICING_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE8),
535 decode( p_OLD_PRICING_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE9),
536 decode( p_NEW_PRICING_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE9),
537 decode( p_OLD_PRICING_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE10),
538 decode( p_NEW_PRICING_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE10),
539 decode( p_OLD_PRICING_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE11),
540 decode( p_NEW_PRICING_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE11),
541 decode( p_OLD_PRICING_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE12),
542 decode( p_NEW_PRICING_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE12),
543 decode( p_OLD_PRICING_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE13),
544 decode( p_NEW_PRICING_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE13),
545 decode( p_OLD_PRICING_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE14),
546 decode( p_NEW_PRICING_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE14),
547 decode( p_OLD_PRICING_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE15),
548 decode( p_NEW_PRICING_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE15),
549 decode( p_OLD_PRICING_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE16),
550 decode( p_NEW_PRICING_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE16),
551 decode( p_OLD_PRICING_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE17),
552 decode( p_NEW_PRICING_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE17),
553 decode( p_OLD_PRICING_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE18),
554 decode( p_NEW_PRICING_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE18),
555 decode( p_OLD_PRICING_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE19),
559 decode( p_OLD_PRICING_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE21),
556 decode( p_NEW_PRICING_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE19),
557 decode( p_OLD_PRICING_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE20),
558 decode( p_NEW_PRICING_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE20),
560 decode( p_NEW_PRICING_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE21),
561 decode( p_OLD_PRICING_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE22),
562 decode( p_NEW_PRICING_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE22),
563 decode( p_OLD_PRICING_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE23),
564 decode( p_NEW_PRICING_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE23),
565 decode( p_OLD_PRICING_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE24),
566 decode( p_NEW_PRICING_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE24),
567 decode( p_NEW_PRICING_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE25),
568 decode( p_OLD_PRICING_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE25),
569 decode( p_OLD_PRICING_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE26),
570 decode( p_NEW_PRICING_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE26),
571 decode( p_OLD_PRICING_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE27),
572 decode( p_NEW_PRICING_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE27),
573 decode( p_OLD_PRICING_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE28),
574 decode( p_NEW_PRICING_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE28),
575 decode( p_OLD_PRICING_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE29),
576 decode( p_NEW_PRICING_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE29),
577 decode( p_OLD_PRICING_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE30),
578 decode( p_NEW_PRICING_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE30),
579 decode( p_OLD_PRICING_ATTRIBUTE31, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE31),
580 decode( p_NEW_PRICING_ATTRIBUTE31, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE31),
581 decode( p_OLD_PRICING_ATTRIBUTE32, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE32),
582 decode( p_NEW_PRICING_ATTRIBUTE32, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE32),
583 decode( p_OLD_PRICING_ATTRIBUTE33, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE33),
584 decode( p_NEW_PRICING_ATTRIBUTE33, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE33),
585 decode( p_OLD_PRICING_ATTRIBUTE34, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE34),
586 decode( p_NEW_PRICING_ATTRIBUTE34, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE34),
587 decode( p_OLD_PRICING_ATTRIBUTE35, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE35),
588 decode( p_NEW_PRICING_ATTRIBUTE35, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE35),
589 decode( p_OLD_PRICING_ATTRIBUTE36, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE36),
590 decode( p_NEW_PRICING_ATTRIBUTE36, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE36),
591 decode( p_OLD_PRICING_ATTRIBUTE37, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE37),
592 decode( p_NEW_PRICING_ATTRIBUTE37, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE37),
593 decode( p_OLD_PRICING_ATTRIBUTE38, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE38),
594 decode( p_NEW_PRICING_ATTRIBUTE38, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE38),
595 decode( p_OLD_PRICING_ATTRIBUTE39, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE39),
596 decode( p_NEW_PRICING_ATTRIBUTE39, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE39),
597 decode( p_OLD_PRICING_ATTRIBUTE40, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE40),
598 decode( p_NEW_PRICING_ATTRIBUTE40, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE40),
599 decode( p_OLD_PRICING_ATTRIBUTE41, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE41),
600 decode( p_NEW_PRICING_ATTRIBUTE41, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE41),
601 decode( p_OLD_PRICING_ATTRIBUTE42, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE42),
602 decode( p_NEW_PRICING_ATTRIBUTE42, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE42),
603 decode( p_OLD_PRICING_ATTRIBUTE43, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE43),
604 decode( p_NEW_PRICING_ATTRIBUTE43, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE43),
605 decode( p_OLD_PRICING_ATTRIBUTE44, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE44),
606 decode( p_NEW_PRICING_ATTRIBUTE44, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE44),
607 decode( p_OLD_PRICING_ATTRIBUTE45, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE45),
608 decode( p_NEW_PRICING_ATTRIBUTE45, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE45),
609 decode( p_OLD_PRICING_ATTRIBUTE46, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE46),
610 decode( p_NEW_PRICING_ATTRIBUTE46, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE46),
611 decode( p_OLD_PRICING_ATTRIBUTE47, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE47),
612 decode( p_NEW_PRICING_ATTRIBUTE47, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE47),
613 decode( p_OLD_PRICING_ATTRIBUTE48, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE48),
614 decode( p_NEW_PRICING_ATTRIBUTE48, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE48),
615 decode( p_OLD_PRICING_ATTRIBUTE49, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE49),
616 decode( p_NEW_PRICING_ATTRIBUTE49, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE49),
617 decode( p_OLD_PRICING_ATTRIBUTE50, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE50),
621 decode( p_OLD_PRICING_ATTRIBUTE52, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE52),
618 decode( p_NEW_PRICING_ATTRIBUTE50, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE50),
619 decode( p_OLD_PRICING_ATTRIBUTE51, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE51),
620 decode( p_NEW_PRICING_ATTRIBUTE51, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE51),
622 decode( p_NEW_PRICING_ATTRIBUTE52, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE52),
623 decode( p_OLD_PRICING_ATTRIBUTE53, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE53),
624 decode( p_NEW_PRICING_ATTRIBUTE53, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE53),
625 decode( p_OLD_PRICING_ATTRIBUTE54, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE54),
626 decode( p_NEW_PRICING_ATTRIBUTE54, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE54),
627 decode( p_OLD_PRICING_ATTRIBUTE55, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE55),
628 decode( p_NEW_PRICING_ATTRIBUTE55, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE55),
629 decode( p_OLD_PRICING_ATTRIBUTE56, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE56),
630 decode( p_NEW_PRICING_ATTRIBUTE56, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE56),
631 decode( p_OLD_PRICING_ATTRIBUTE57, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE57),
632 decode( p_NEW_PRICING_ATTRIBUTE57, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE57),
633 decode( p_OLD_PRICING_ATTRIBUTE58, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE58),
634 decode( p_NEW_PRICING_ATTRIBUTE58, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE58),
635 decode( p_OLD_PRICING_ATTRIBUTE59, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE59),
636 decode( p_NEW_PRICING_ATTRIBUTE59, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE59),
637 decode( p_OLD_PRICING_ATTRIBUTE60, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE60),
638 decode( p_NEW_PRICING_ATTRIBUTE60, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE60),
639 decode( p_OLD_PRICING_ATTRIBUTE61, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE61),
640 decode( p_NEW_PRICING_ATTRIBUTE61, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE61),
641 decode( p_OLD_PRICING_ATTRIBUTE62, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE62),
642 decode( p_NEW_PRICING_ATTRIBUTE62, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE62),
643 decode( p_OLD_PRICING_ATTRIBUTE63, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE63),
644 decode( p_NEW_PRICING_ATTRIBUTE63, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE63),
645 decode( p_OLD_PRICING_ATTRIBUTE64, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE64),
646 decode( p_NEW_PRICING_ATTRIBUTE64, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE64),
647 decode( p_OLD_PRICING_ATTRIBUTE65, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE65),
648 decode( p_NEW_PRICING_ATTRIBUTE65, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE65),
649 decode( p_OLD_PRICING_ATTRIBUTE66, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE66),
650 decode( p_NEW_PRICING_ATTRIBUTE66, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE66),
651 decode( p_OLD_PRICING_ATTRIBUTE67, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE67),
652 decode( p_NEW_PRICING_ATTRIBUTE67, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE67),
653 decode( p_OLD_PRICING_ATTRIBUTE68, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE68),
654 decode( p_NEW_PRICING_ATTRIBUTE68, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE68),
655 decode( p_OLD_PRICING_ATTRIBUTE69, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE69),
656 decode( p_NEW_PRICING_ATTRIBUTE69, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE69),
657 decode( p_OLD_PRICING_ATTRIBUTE70, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE70),
658 decode( p_NEW_PRICING_ATTRIBUTE70, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE70),
659 decode( p_OLD_PRICING_ATTRIBUTE71, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE71),
660 decode( p_NEW_PRICING_ATTRIBUTE71, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE71),
661 decode( p_OLD_PRICING_ATTRIBUTE72, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE72),
662 decode( p_NEW_PRICING_ATTRIBUTE72, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE72),
663 decode( p_OLD_PRICING_ATTRIBUTE73, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE73),
664 decode( p_NEW_PRICING_ATTRIBUTE73, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE73),
665 decode( p_OLD_PRICING_ATTRIBUTE74, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE74),
666 decode( p_NEW_PRICING_ATTRIBUTE74, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE74),
667 decode( p_OLD_PRICING_ATTRIBUTE75, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE75),
668 decode( p_NEW_PRICING_ATTRIBUTE75, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE75),
669 decode( p_OLD_PRICING_ATTRIBUTE76, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE76),
670 decode( p_NEW_PRICING_ATTRIBUTE76, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE76),
671 decode( p_OLD_PRICING_ATTRIBUTE77, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE77),
672 decode( p_NEW_PRICING_ATTRIBUTE77, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE77),
673 decode( p_OLD_PRICING_ATTRIBUTE78, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE78),
674 decode( p_NEW_PRICING_ATTRIBUTE78, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE78),
675 decode( p_OLD_PRICING_ATTRIBUTE79, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE79),
676 decode( p_NEW_PRICING_ATTRIBUTE79, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE79),
677 decode( p_OLD_PRICING_ATTRIBUTE80, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE80),
678 decode( p_NEW_PRICING_ATTRIBUTE80, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE80),
679 decode( p_OLD_PRICING_ATTRIBUTE81, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE81),
683 decode( p_OLD_PRICING_ATTRIBUTE83, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE83),
680 decode( p_NEW_PRICING_ATTRIBUTE81, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE81),
681 decode( p_OLD_PRICING_ATTRIBUTE82, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE82),
682 decode( p_NEW_PRICING_ATTRIBUTE82, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE82),
684 decode( p_NEW_PRICING_ATTRIBUTE83, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE83),
685 decode( p_OLD_PRICING_ATTRIBUTE84, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE84),
686 decode( p_NEW_PRICING_ATTRIBUTE84, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE84),
687 decode( p_OLD_PRICING_ATTRIBUTE85, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE85),
688 decode( p_NEW_PRICING_ATTRIBUTE85, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE85),
689 decode( p_OLD_PRICING_ATTRIBUTE86, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE86),
690 decode( p_NEW_PRICING_ATTRIBUTE86, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE86),
691 decode( p_OLD_PRICING_ATTRIBUTE87, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE87),
692 decode( p_NEW_PRICING_ATTRIBUTE87, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE87),
693 decode( p_OLD_PRICING_ATTRIBUTE88, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE88),
694 decode( p_NEW_PRICING_ATTRIBUTE88, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE88),
695 decode( p_OLD_PRICING_ATTRIBUTE89, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE89),
696 decode( p_NEW_PRICING_ATTRIBUTE89, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE89),
697 decode( p_OLD_PRICING_ATTRIBUTE90, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE90),
698 decode( p_NEW_PRICING_ATTRIBUTE90, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE90),
699 decode( p_OLD_PRICING_ATTRIBUTE91, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE91),
700 decode( p_NEW_PRICING_ATTRIBUTE91, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE91),
701 decode( p_OLD_PRICING_ATTRIBUTE92, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE92),
702 decode( p_NEW_PRICING_ATTRIBUTE92, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE92),
703 decode( p_OLD_PRICING_ATTRIBUTE93, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE93),
704 decode( p_NEW_PRICING_ATTRIBUTE93, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE93),
705 decode( p_OLD_PRICING_ATTRIBUTE94, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE94),
706 decode( p_NEW_PRICING_ATTRIBUTE94, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE94),
707 decode( p_OLD_PRICING_ATTRIBUTE95, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE95),
708 decode( p_NEW_PRICING_ATTRIBUTE95, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE95),
709 decode( p_OLD_PRICING_ATTRIBUTE96, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE96),
710 decode( p_NEW_PRICING_ATTRIBUTE96, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE96),
711 decode( p_OLD_PRICING_ATTRIBUTE97, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE97),
712 decode( p_NEW_PRICING_ATTRIBUTE97, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE97),
713 decode( p_OLD_PRICING_ATTRIBUTE98, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE98),
714 decode( p_NEW_PRICING_ATTRIBUTE98, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE98),
715 decode( p_OLD_PRICING_ATTRIBUTE99, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE99),
716 decode( p_NEW_PRICING_ATTRIBUTE99, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE99),
717 decode( p_OLD_PRICING_ATTRIBUTE100, FND_API.G_MISS_CHAR, NULL, p_OLD_PRICING_ATTRIBUTE100),
718 decode( p_NEW_PRICING_ATTRIBUTE100, FND_API.G_MISS_CHAR, NULL, p_NEW_PRICING_ATTRIBUTE100),
719 decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_START_DATE),
720 decode( p_NEW_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_START_DATE),
721 decode( p_OLD_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_END_DATE),
722 decode( p_NEW_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_END_DATE),
723 decode( p_OLD_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_OLD_CONTEXT),
724 decode( p_NEW_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_NEW_CONTEXT),
725 decode( p_OLD_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE1),
726 decode( p_NEW_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE1),
727 decode( p_OLD_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE2),
728 decode( p_NEW_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE2),
729 decode( p_OLD_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE3),
730 decode( p_NEW_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE3),
731 decode( p_OLD_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE4),
732 decode( p_NEW_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE4),
733 decode( p_OLD_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE5),
734 decode( p_NEW_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE5),
735 decode( p_OLD_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE6),
736 decode( p_NEW_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE6),
737 decode( p_OLD_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE7),
738 decode( p_NEW_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE7),
739 decode( p_OLD_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE8),
740 decode( p_NEW_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE8),
741 decode( p_OLD_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE9),
742 decode( p_NEW_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE9),
743 decode( p_OLD_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE10),
744 decode( p_NEW_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE10),
745 decode( p_OLD_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE11),
749 decode( p_OLD_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE13),
746 decode( p_NEW_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE11),
747 decode( p_OLD_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE12),
748 decode( p_NEW_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE12),
750 decode( p_NEW_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE13),
751 decode( p_OLD_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE14),
752 decode( p_NEW_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE14),
753 decode( p_OLD_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE15),
754 decode( p_NEW_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE15),
755 decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, NULL, p_FULL_DUMP_FLAG),
756 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
757 decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
758 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
759 decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
760 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
761 decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
762 );
763 End Insert_Row;
764
765 PROCEDURE Update_Row(
766 p_PRICE_ATTRIB_HISTORY_ID NUMBER,
767 p_PRICING_ATTRIBUTE_ID NUMBER,
768 p_TRANSACTION_ID NUMBER,
769 p_OLD_PRICING_CONTEXT VARCHAR2,
770 p_NEW_PRICING_CONTEXT VARCHAR2,
771 p_OLD_PRICING_ATTRIBUTE1 VARCHAR2,
772 p_NEW_PRICING_ATTRIBUTE1 VARCHAR2,
773 p_OLD_PRICING_ATTRIBUTE2 VARCHAR2,
774 p_NEW_PRICING_ATTRIBUTE2 VARCHAR2,
775 p_OLD_PRICING_ATTRIBUTE3 VARCHAR2,
776 p_NEW_PRICING_ATTRIBUTE3 VARCHAR2,
777 p_OLD_PRICING_ATTRIBUTE4 VARCHAR2,
778 p_NEW_PRICING_ATTRIBUTE4 VARCHAR2,
779 p_OLD_PRICING_ATTRIBUTE5 VARCHAR2,
780 p_NEW_PRICING_ATTRIBUTE5 VARCHAR2,
781 p_OLD_PRICING_ATTRIBUTE6 VARCHAR2,
782 p_NEW_PRICING_ATTRIBUTE6 VARCHAR2,
783 p_OLD_PRICING_ATTRIBUTE7 VARCHAR2,
784 p_NEW_PRICING_ATTRIBUTE7 VARCHAR2,
785 p_OLD_PRICING_ATTRIBUTE8 VARCHAR2,
786 p_NEW_PRICING_ATTRIBUTE8 VARCHAR2,
787 p_OLD_PRICING_ATTRIBUTE9 VARCHAR2,
788 p_NEW_PRICING_ATTRIBUTE9 VARCHAR2,
789 p_OLD_PRICING_ATTRIBUTE10 VARCHAR2,
790 p_NEW_PRICING_ATTRIBUTE10 VARCHAR2,
791 p_OLD_PRICING_ATTRIBUTE11 VARCHAR2,
792 p_NEW_PRICING_ATTRIBUTE11 VARCHAR2,
793 p_OLD_PRICING_ATTRIBUTE12 VARCHAR2,
794 p_NEW_PRICING_ATTRIBUTE12 VARCHAR2,
795 p_OLD_PRICING_ATTRIBUTE13 VARCHAR2,
796 p_NEW_PRICING_ATTRIBUTE13 VARCHAR2,
797 p_OLD_PRICING_ATTRIBUTE14 VARCHAR2,
798 p_NEW_PRICING_ATTRIBUTE14 VARCHAR2,
799 p_OLD_PRICING_ATTRIBUTE15 VARCHAR2,
800 p_NEW_PRICING_ATTRIBUTE15 VARCHAR2,
801 p_OLD_PRICING_ATTRIBUTE16 VARCHAR2,
802 p_NEW_PRICING_ATTRIBUTE16 VARCHAR2,
803 p_OLD_PRICING_ATTRIBUTE17 VARCHAR2,
804 p_NEW_PRICING_ATTRIBUTE17 VARCHAR2,
805 p_OLD_PRICING_ATTRIBUTE18 VARCHAR2,
806 p_NEW_PRICING_ATTRIBUTE18 VARCHAR2,
807 p_OLD_PRICING_ATTRIBUTE19 VARCHAR2,
808 p_NEW_PRICING_ATTRIBUTE19 VARCHAR2,
809 p_OLD_PRICING_ATTRIBUTE20 VARCHAR2,
810 p_NEW_PRICING_ATTRIBUTE20 VARCHAR2,
811 p_OLD_PRICING_ATTRIBUTE21 VARCHAR2,
812 p_NEW_PRICING_ATTRIBUTE21 VARCHAR2,
813 p_OLD_PRICING_ATTRIBUTE22 VARCHAR2,
814 p_NEW_PRICING_ATTRIBUTE22 VARCHAR2,
815 p_OLD_PRICING_ATTRIBUTE23 VARCHAR2,
816 p_NEW_PRICING_ATTRIBUTE23 VARCHAR2,
817 p_OLD_PRICING_ATTRIBUTE24 VARCHAR2,
818 p_NEW_PRICING_ATTRIBUTE24 VARCHAR2,
819 p_NEW_PRICING_ATTRIBUTE25 VARCHAR2,
820 p_OLD_PRICING_ATTRIBUTE25 VARCHAR2,
821 p_OLD_PRICING_ATTRIBUTE26 VARCHAR2,
822 p_NEW_PRICING_ATTRIBUTE26 VARCHAR2,
823 p_OLD_PRICING_ATTRIBUTE27 VARCHAR2,
824 p_NEW_PRICING_ATTRIBUTE27 VARCHAR2,
825 p_OLD_PRICING_ATTRIBUTE28 VARCHAR2,
826 p_NEW_PRICING_ATTRIBUTE28 VARCHAR2,
827 p_OLD_PRICING_ATTRIBUTE29 VARCHAR2,
828 p_NEW_PRICING_ATTRIBUTE29 VARCHAR2,
829 p_OLD_PRICING_ATTRIBUTE30 VARCHAR2,
830 p_NEW_PRICING_ATTRIBUTE30 VARCHAR2,
831 p_OLD_PRICING_ATTRIBUTE31 VARCHAR2,
832 p_NEW_PRICING_ATTRIBUTE31 VARCHAR2,
833 p_OLD_PRICING_ATTRIBUTE32 VARCHAR2,
834 p_NEW_PRICING_ATTRIBUTE32 VARCHAR2,
835 p_OLD_PRICING_ATTRIBUTE33 VARCHAR2,
836 p_NEW_PRICING_ATTRIBUTE33 VARCHAR2,
837 p_OLD_PRICING_ATTRIBUTE34 VARCHAR2,
838 p_NEW_PRICING_ATTRIBUTE34 VARCHAR2,
839 p_OLD_PRICING_ATTRIBUTE35 VARCHAR2,
840 p_NEW_PRICING_ATTRIBUTE35 VARCHAR2,
841 p_OLD_PRICING_ATTRIBUTE36 VARCHAR2,
842 p_NEW_PRICING_ATTRIBUTE36 VARCHAR2,
843 p_OLD_PRICING_ATTRIBUTE37 VARCHAR2,
844 p_NEW_PRICING_ATTRIBUTE37 VARCHAR2,
845 p_OLD_PRICING_ATTRIBUTE38 VARCHAR2,
846 p_NEW_PRICING_ATTRIBUTE38 VARCHAR2,
847 p_OLD_PRICING_ATTRIBUTE39 VARCHAR2,
848 p_NEW_PRICING_ATTRIBUTE39 VARCHAR2,
849 p_OLD_PRICING_ATTRIBUTE40 VARCHAR2,
850 p_NEW_PRICING_ATTRIBUTE40 VARCHAR2,
851 p_OLD_PRICING_ATTRIBUTE41 VARCHAR2,
852 p_NEW_PRICING_ATTRIBUTE41 VARCHAR2,
856 p_NEW_PRICING_ATTRIBUTE43 VARCHAR2,
853 p_OLD_PRICING_ATTRIBUTE42 VARCHAR2,
854 p_NEW_PRICING_ATTRIBUTE42 VARCHAR2,
855 p_OLD_PRICING_ATTRIBUTE43 VARCHAR2,
857 p_OLD_PRICING_ATTRIBUTE44 VARCHAR2,
858 p_NEW_PRICING_ATTRIBUTE44 VARCHAR2,
859 p_OLD_PRICING_ATTRIBUTE45 VARCHAR2,
860 p_NEW_PRICING_ATTRIBUTE45 VARCHAR2,
861 p_OLD_PRICING_ATTRIBUTE46 VARCHAR2,
862 p_NEW_PRICING_ATTRIBUTE46 VARCHAR2,
863 p_OLD_PRICING_ATTRIBUTE47 VARCHAR2,
864 p_NEW_PRICING_ATTRIBUTE47 VARCHAR2,
865 p_OLD_PRICING_ATTRIBUTE48 VARCHAR2,
866 p_NEW_PRICING_ATTRIBUTE48 VARCHAR2,
867 p_OLD_PRICING_ATTRIBUTE49 VARCHAR2,
868 p_NEW_PRICING_ATTRIBUTE49 VARCHAR2,
869 p_OLD_PRICING_ATTRIBUTE50 VARCHAR2,
870 p_NEW_PRICING_ATTRIBUTE50 VARCHAR2,
871 p_OLD_PRICING_ATTRIBUTE51 VARCHAR2,
872 p_NEW_PRICING_ATTRIBUTE51 VARCHAR2,
873 p_OLD_PRICING_ATTRIBUTE52 VARCHAR2,
874 p_NEW_PRICING_ATTRIBUTE52 VARCHAR2,
875 p_OLD_PRICING_ATTRIBUTE53 VARCHAR2,
876 p_NEW_PRICING_ATTRIBUTE53 VARCHAR2,
877 p_OLD_PRICING_ATTRIBUTE54 VARCHAR2,
878 p_NEW_PRICING_ATTRIBUTE54 VARCHAR2,
879 p_OLD_PRICING_ATTRIBUTE55 VARCHAR2,
880 p_NEW_PRICING_ATTRIBUTE55 VARCHAR2,
881 p_OLD_PRICING_ATTRIBUTE56 VARCHAR2,
882 p_NEW_PRICING_ATTRIBUTE56 VARCHAR2,
883 p_OLD_PRICING_ATTRIBUTE57 VARCHAR2,
884 p_NEW_PRICING_ATTRIBUTE57 VARCHAR2,
885 p_OLD_PRICING_ATTRIBUTE58 VARCHAR2,
886 p_NEW_PRICING_ATTRIBUTE58 VARCHAR2,
887 p_OLD_PRICING_ATTRIBUTE59 VARCHAR2,
888 p_NEW_PRICING_ATTRIBUTE59 VARCHAR2,
889 p_OLD_PRICING_ATTRIBUTE60 VARCHAR2,
890 p_NEW_PRICING_ATTRIBUTE60 VARCHAR2,
891 p_OLD_PRICING_ATTRIBUTE61 VARCHAR2,
892 p_NEW_PRICING_ATTRIBUTE61 VARCHAR2,
893 p_OLD_PRICING_ATTRIBUTE62 VARCHAR2,
894 p_NEW_PRICING_ATTRIBUTE62 VARCHAR2,
895 p_OLD_PRICING_ATTRIBUTE63 VARCHAR2,
896 p_NEW_PRICING_ATTRIBUTE63 VARCHAR2,
897 p_OLD_PRICING_ATTRIBUTE64 VARCHAR2,
898 p_NEW_PRICING_ATTRIBUTE64 VARCHAR2,
899 p_OLD_PRICING_ATTRIBUTE65 VARCHAR2,
900 p_NEW_PRICING_ATTRIBUTE65 VARCHAR2,
901 p_OLD_PRICING_ATTRIBUTE66 VARCHAR2,
902 p_NEW_PRICING_ATTRIBUTE66 VARCHAR2,
903 p_OLD_PRICING_ATTRIBUTE67 VARCHAR2,
904 p_NEW_PRICING_ATTRIBUTE67 VARCHAR2,
905 p_OLD_PRICING_ATTRIBUTE68 VARCHAR2,
906 p_NEW_PRICING_ATTRIBUTE68 VARCHAR2,
907 p_OLD_PRICING_ATTRIBUTE69 VARCHAR2,
908 p_NEW_PRICING_ATTRIBUTE69 VARCHAR2,
909 p_OLD_PRICING_ATTRIBUTE70 VARCHAR2,
910 p_NEW_PRICING_ATTRIBUTE70 VARCHAR2,
911 p_OLD_PRICING_ATTRIBUTE71 VARCHAR2,
912 p_NEW_PRICING_ATTRIBUTE71 VARCHAR2,
913 p_OLD_PRICING_ATTRIBUTE72 VARCHAR2,
914 p_NEW_PRICING_ATTRIBUTE72 VARCHAR2,
915 p_OLD_PRICING_ATTRIBUTE73 VARCHAR2,
916 p_NEW_PRICING_ATTRIBUTE73 VARCHAR2,
917 p_OLD_PRICING_ATTRIBUTE74 VARCHAR2,
918 p_NEW_PRICING_ATTRIBUTE74 VARCHAR2,
919 p_OLD_PRICING_ATTRIBUTE75 VARCHAR2,
920 p_NEW_PRICING_ATTRIBUTE75 VARCHAR2,
921 p_OLD_PRICING_ATTRIBUTE76 VARCHAR2,
922 p_NEW_PRICING_ATTRIBUTE76 VARCHAR2,
923 p_OLD_PRICING_ATTRIBUTE77 VARCHAR2,
924 p_NEW_PRICING_ATTRIBUTE77 VARCHAR2,
925 p_OLD_PRICING_ATTRIBUTE78 VARCHAR2,
926 p_NEW_PRICING_ATTRIBUTE78 VARCHAR2,
927 p_OLD_PRICING_ATTRIBUTE79 VARCHAR2,
928 p_NEW_PRICING_ATTRIBUTE79 VARCHAR2,
929 p_OLD_PRICING_ATTRIBUTE80 VARCHAR2,
930 p_NEW_PRICING_ATTRIBUTE80 VARCHAR2,
931 p_OLD_PRICING_ATTRIBUTE81 VARCHAR2,
932 p_NEW_PRICING_ATTRIBUTE81 VARCHAR2,
933 p_OLD_PRICING_ATTRIBUTE82 VARCHAR2,
934 p_NEW_PRICING_ATTRIBUTE82 VARCHAR2,
935 p_OLD_PRICING_ATTRIBUTE83 VARCHAR2,
936 p_NEW_PRICING_ATTRIBUTE83 VARCHAR2,
937 p_OLD_PRICING_ATTRIBUTE84 VARCHAR2,
938 p_NEW_PRICING_ATTRIBUTE84 VARCHAR2,
939 p_OLD_PRICING_ATTRIBUTE85 VARCHAR2,
940 p_NEW_PRICING_ATTRIBUTE85 VARCHAR2,
941 p_OLD_PRICING_ATTRIBUTE86 VARCHAR2,
942 p_NEW_PRICING_ATTRIBUTE86 VARCHAR2,
943 p_OLD_PRICING_ATTRIBUTE87 VARCHAR2,
944 p_NEW_PRICING_ATTRIBUTE87 VARCHAR2,
945 p_OLD_PRICING_ATTRIBUTE88 VARCHAR2,
946 p_NEW_PRICING_ATTRIBUTE88 VARCHAR2,
947 p_OLD_PRICING_ATTRIBUTE89 VARCHAR2,
948 p_NEW_PRICING_ATTRIBUTE89 VARCHAR2,
949 p_OLD_PRICING_ATTRIBUTE90 VARCHAR2,
950 p_NEW_PRICING_ATTRIBUTE90 VARCHAR2,
951 p_OLD_PRICING_ATTRIBUTE91 VARCHAR2,
952 p_NEW_PRICING_ATTRIBUTE91 VARCHAR2,
953 p_OLD_PRICING_ATTRIBUTE92 VARCHAR2,
954 p_NEW_PRICING_ATTRIBUTE92 VARCHAR2,
955 p_OLD_PRICING_ATTRIBUTE93 VARCHAR2,
956 p_NEW_PRICING_ATTRIBUTE93 VARCHAR2,
957 p_OLD_PRICING_ATTRIBUTE94 VARCHAR2,
958 p_NEW_PRICING_ATTRIBUTE94 VARCHAR2,
959 p_OLD_PRICING_ATTRIBUTE95 VARCHAR2,
960 p_NEW_PRICING_ATTRIBUTE95 VARCHAR2,
961 p_OLD_PRICING_ATTRIBUTE96 VARCHAR2,
962 p_NEW_PRICING_ATTRIBUTE96 VARCHAR2,
963 p_OLD_PRICING_ATTRIBUTE97 VARCHAR2,
964 p_NEW_PRICING_ATTRIBUTE97 VARCHAR2,
965 p_OLD_PRICING_ATTRIBUTE98 VARCHAR2,
969 p_OLD_PRICING_ATTRIBUTE100 VARCHAR2,
966 p_NEW_PRICING_ATTRIBUTE98 VARCHAR2,
967 p_OLD_PRICING_ATTRIBUTE99 VARCHAR2,
968 p_NEW_PRICING_ATTRIBUTE99 VARCHAR2,
970 p_NEW_PRICING_ATTRIBUTE100 VARCHAR2,
971 p_OLD_ACTIVE_START_DATE DATE,
972 p_NEW_ACTIVE_START_DATE DATE,
973 p_OLD_ACTIVE_END_DATE DATE,
974 p_NEW_ACTIVE_END_DATE DATE,
975 p_OLD_CONTEXT VARCHAR2,
976 p_NEW_CONTEXT VARCHAR2,
977 p_OLD_ATTRIBUTE1 VARCHAR2,
978 p_NEW_ATTRIBUTE1 VARCHAR2,
979 p_OLD_ATTRIBUTE2 VARCHAR2,
980 p_NEW_ATTRIBUTE2 VARCHAR2,
981 p_OLD_ATTRIBUTE3 VARCHAR2,
982 p_NEW_ATTRIBUTE3 VARCHAR2,
983 p_OLD_ATTRIBUTE4 VARCHAR2,
984 p_NEW_ATTRIBUTE4 VARCHAR2,
985 p_OLD_ATTRIBUTE5 VARCHAR2,
986 p_NEW_ATTRIBUTE5 VARCHAR2,
987 p_OLD_ATTRIBUTE6 VARCHAR2,
988 p_NEW_ATTRIBUTE6 VARCHAR2,
989 p_OLD_ATTRIBUTE7 VARCHAR2,
990 p_NEW_ATTRIBUTE7 VARCHAR2,
991 p_OLD_ATTRIBUTE8 VARCHAR2,
992 p_NEW_ATTRIBUTE8 VARCHAR2,
993 p_OLD_ATTRIBUTE9 VARCHAR2,
994 p_NEW_ATTRIBUTE9 VARCHAR2,
995 p_OLD_ATTRIBUTE10 VARCHAR2,
996 p_NEW_ATTRIBUTE10 VARCHAR2,
997 p_OLD_ATTRIBUTE11 VARCHAR2,
998 p_NEW_ATTRIBUTE11 VARCHAR2,
999 p_OLD_ATTRIBUTE12 VARCHAR2,
1000 p_NEW_ATTRIBUTE12 VARCHAR2,
1001 p_OLD_ATTRIBUTE13 VARCHAR2,
1002 p_NEW_ATTRIBUTE13 VARCHAR2,
1003 p_OLD_ATTRIBUTE14 VARCHAR2,
1004 p_NEW_ATTRIBUTE14 VARCHAR2,
1005 p_OLD_ATTRIBUTE15 VARCHAR2,
1006 p_NEW_ATTRIBUTE15 VARCHAR2,
1007 p_FULL_DUMP_FLAG VARCHAR2,
1008 p_CREATED_BY NUMBER,
1009 p_CREATION_DATE DATE,
1010 p_LAST_UPDATED_BY NUMBER,
1011 p_LAST_UPDATE_DATE DATE,
1012 p_LAST_UPDATE_LOGIN NUMBER,
1013 p_OBJECT_VERSION_NUMBER NUMBER)
1014 IS
1015 BEGIN
1016 NULL;
1017 Update CSI_I_PRICING_ATTRIBS_H
1018 SET
1019 PRICING_ATTRIBUTE_ID = decode( p_PRICING_ATTRIBUTE_ID, FND_API.G_MISS_NUM, PRICING_ATTRIBUTE_ID, p_PRICING_ATTRIBUTE_ID),
1020 TRANSACTION_ID = decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, TRANSACTION_ID, p_TRANSACTION_ID),
1021 OLD_PRICING_CONTEXT = decode( p_OLD_PRICING_CONTEXT, FND_API.G_MISS_CHAR, OLD_PRICING_CONTEXT, p_OLD_PRICING_CONTEXT),
1022 NEW_PRICING_CONTEXT = decode( p_NEW_PRICING_CONTEXT, FND_API.G_MISS_CHAR, NEW_PRICING_CONTEXT, p_NEW_PRICING_CONTEXT),
1023 OLD_PRICING_ATTRIBUTE1 = decode( p_OLD_PRICING_ATTRIBUTE1, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE1, p_OLD_PRICING_ATTRIBUTE1),
1024 NEW_PRICING_ATTRIBUTE1 = decode( p_NEW_PRICING_ATTRIBUTE1, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE1, p_NEW_PRICING_ATTRIBUTE1),
1025 OLD_PRICING_ATTRIBUTE2 = decode( p_OLD_PRICING_ATTRIBUTE2, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE2, p_OLD_PRICING_ATTRIBUTE2),
1026 NEW_PRICING_ATTRIBUTE2 = decode( p_NEW_PRICING_ATTRIBUTE2, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE2, p_NEW_PRICING_ATTRIBUTE2),
1027 OLD_PRICING_ATTRIBUTE3 = decode( p_OLD_PRICING_ATTRIBUTE3, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE3, p_OLD_PRICING_ATTRIBUTE3),
1028 NEW_PRICING_ATTRIBUTE3 = decode( p_NEW_PRICING_ATTRIBUTE3, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE3, p_NEW_PRICING_ATTRIBUTE3),
1029 OLD_PRICING_ATTRIBUTE4 = decode( p_OLD_PRICING_ATTRIBUTE4, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE4, p_OLD_PRICING_ATTRIBUTE4),
1030 NEW_PRICING_ATTRIBUTE4 = decode( p_NEW_PRICING_ATTRIBUTE4, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE4, p_NEW_PRICING_ATTRIBUTE4),
1031 OLD_PRICING_ATTRIBUTE5 = decode( p_OLD_PRICING_ATTRIBUTE5, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE5, p_OLD_PRICING_ATTRIBUTE5),
1032 NEW_PRICING_ATTRIBUTE5 = decode( p_NEW_PRICING_ATTRIBUTE5, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE5, p_NEW_PRICING_ATTRIBUTE5),
1033 OLD_PRICING_ATTRIBUTE6 = decode( p_OLD_PRICING_ATTRIBUTE6, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE6, p_OLD_PRICING_ATTRIBUTE6),
1034 NEW_PRICING_ATTRIBUTE6 = decode( p_NEW_PRICING_ATTRIBUTE6, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE6, p_NEW_PRICING_ATTRIBUTE6),
1035 OLD_PRICING_ATTRIBUTE7 = decode( p_OLD_PRICING_ATTRIBUTE7, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE7, p_OLD_PRICING_ATTRIBUTE7),
1036 NEW_PRICING_ATTRIBUTE7 = decode( p_NEW_PRICING_ATTRIBUTE7, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE7, p_NEW_PRICING_ATTRIBUTE7),
1037 OLD_PRICING_ATTRIBUTE8 = decode( p_OLD_PRICING_ATTRIBUTE8, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE8, p_OLD_PRICING_ATTRIBUTE8),
1038 NEW_PRICING_ATTRIBUTE8 = decode( p_NEW_PRICING_ATTRIBUTE8, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE8, p_NEW_PRICING_ATTRIBUTE8),
1039 OLD_PRICING_ATTRIBUTE9 = decode( p_OLD_PRICING_ATTRIBUTE9, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE9, p_OLD_PRICING_ATTRIBUTE9),
1040 NEW_PRICING_ATTRIBUTE9 = decode( p_NEW_PRICING_ATTRIBUTE9, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE9, p_NEW_PRICING_ATTRIBUTE9),
1041 OLD_PRICING_ATTRIBUTE10 = decode( p_OLD_PRICING_ATTRIBUTE10, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE10, p_OLD_PRICING_ATTRIBUTE10),
1042 NEW_PRICING_ATTRIBUTE10 = decode( p_NEW_PRICING_ATTRIBUTE10, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE10, p_NEW_PRICING_ATTRIBUTE10),
1043 OLD_PRICING_ATTRIBUTE11 = decode( p_OLD_PRICING_ATTRIBUTE11, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE11, p_OLD_PRICING_ATTRIBUTE11),
1044 NEW_PRICING_ATTRIBUTE11 = decode( p_NEW_PRICING_ATTRIBUTE11, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE11, p_NEW_PRICING_ATTRIBUTE11),
1045 OLD_PRICING_ATTRIBUTE12 = decode( p_OLD_PRICING_ATTRIBUTE12, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE12, p_OLD_PRICING_ATTRIBUTE12),
1046 NEW_PRICING_ATTRIBUTE12 = decode( p_NEW_PRICING_ATTRIBUTE12, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE12, p_NEW_PRICING_ATTRIBUTE12),
1050 NEW_PRICING_ATTRIBUTE14 = decode( p_NEW_PRICING_ATTRIBUTE14, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE14, p_NEW_PRICING_ATTRIBUTE14),
1047 OLD_PRICING_ATTRIBUTE13 = decode( p_OLD_PRICING_ATTRIBUTE13, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE13, p_OLD_PRICING_ATTRIBUTE13),
1048 NEW_PRICING_ATTRIBUTE13 = decode( p_NEW_PRICING_ATTRIBUTE13, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE13, p_NEW_PRICING_ATTRIBUTE13),
1049 OLD_PRICING_ATTRIBUTE14 = decode( p_OLD_PRICING_ATTRIBUTE14, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE14, p_OLD_PRICING_ATTRIBUTE14),
1051 OLD_PRICING_ATTRIBUTE15 = decode( p_OLD_PRICING_ATTRIBUTE15, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE15, p_OLD_PRICING_ATTRIBUTE15),
1052 NEW_PRICING_ATTRIBUTE15 = decode( p_NEW_PRICING_ATTRIBUTE15, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE15, p_NEW_PRICING_ATTRIBUTE15),
1053 OLD_PRICING_ATTRIBUTE16 = decode( p_OLD_PRICING_ATTRIBUTE16, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE16, p_OLD_PRICING_ATTRIBUTE16),
1054 NEW_PRICING_ATTRIBUTE16 = decode( p_NEW_PRICING_ATTRIBUTE16, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE16, p_NEW_PRICING_ATTRIBUTE16),
1055 OLD_PRICING_ATTRIBUTE17 = decode( p_OLD_PRICING_ATTRIBUTE17, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE17, p_OLD_PRICING_ATTRIBUTE17),
1056 NEW_PRICING_ATTRIBUTE17 = decode( p_NEW_PRICING_ATTRIBUTE17, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE17, p_NEW_PRICING_ATTRIBUTE17),
1057 OLD_PRICING_ATTRIBUTE18 = decode( p_OLD_PRICING_ATTRIBUTE18, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE18, p_OLD_PRICING_ATTRIBUTE18),
1058 NEW_PRICING_ATTRIBUTE18 = decode( p_NEW_PRICING_ATTRIBUTE18, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE18, p_NEW_PRICING_ATTRIBUTE18),
1059 OLD_PRICING_ATTRIBUTE19 = decode( p_OLD_PRICING_ATTRIBUTE19, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE19, p_OLD_PRICING_ATTRIBUTE19),
1060 NEW_PRICING_ATTRIBUTE19 = decode( p_NEW_PRICING_ATTRIBUTE19, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE19, p_NEW_PRICING_ATTRIBUTE19),
1061 OLD_PRICING_ATTRIBUTE20 = decode( p_OLD_PRICING_ATTRIBUTE20, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE20, p_OLD_PRICING_ATTRIBUTE20),
1062 NEW_PRICING_ATTRIBUTE20 = decode( p_NEW_PRICING_ATTRIBUTE20, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE20, p_NEW_PRICING_ATTRIBUTE20),
1063 OLD_PRICING_ATTRIBUTE21 = decode( p_OLD_PRICING_ATTRIBUTE21, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE21, p_OLD_PRICING_ATTRIBUTE21),
1064 NEW_PRICING_ATTRIBUTE21 = decode( p_NEW_PRICING_ATTRIBUTE21, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE21, p_NEW_PRICING_ATTRIBUTE21),
1065 OLD_PRICING_ATTRIBUTE22 = decode( p_OLD_PRICING_ATTRIBUTE22, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE22, p_OLD_PRICING_ATTRIBUTE22),
1066 NEW_PRICING_ATTRIBUTE22 = decode( p_NEW_PRICING_ATTRIBUTE22, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE22, p_NEW_PRICING_ATTRIBUTE22),
1067 OLD_PRICING_ATTRIBUTE23 = decode( p_OLD_PRICING_ATTRIBUTE23, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE23, p_OLD_PRICING_ATTRIBUTE23),
1068 NEW_PRICING_ATTRIBUTE23 = decode( p_NEW_PRICING_ATTRIBUTE23, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE23, p_NEW_PRICING_ATTRIBUTE23),
1069 OLD_PRICING_ATTRIBUTE24 = decode( p_OLD_PRICING_ATTRIBUTE24, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE24, p_OLD_PRICING_ATTRIBUTE24),
1070 NEW_PRICING_ATTRIBUTE24 = decode( p_NEW_PRICING_ATTRIBUTE24, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE24, p_NEW_PRICING_ATTRIBUTE24),
1071 NEW_PRICING_ATTRIBUTE25 = decode( p_NEW_PRICING_ATTRIBUTE25, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE25, p_NEW_PRICING_ATTRIBUTE25),
1072 OLD_PRICING_ATTRIBUTE25 = decode( p_OLD_PRICING_ATTRIBUTE25, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE25, p_OLD_PRICING_ATTRIBUTE25),
1073 OLD_PRICING_ATTRIBUTE26 = decode( p_OLD_PRICING_ATTRIBUTE26, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE26, p_OLD_PRICING_ATTRIBUTE26),
1074 NEW_PRICING_ATTRIBUTE26 = decode( p_NEW_PRICING_ATTRIBUTE26, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE26, p_NEW_PRICING_ATTRIBUTE26),
1075 OLD_PRICING_ATTRIBUTE27 = decode( p_OLD_PRICING_ATTRIBUTE27, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE27, p_OLD_PRICING_ATTRIBUTE27),
1076 NEW_PRICING_ATTRIBUTE27 = decode( p_NEW_PRICING_ATTRIBUTE27, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE27, p_NEW_PRICING_ATTRIBUTE27),
1077 OLD_PRICING_ATTRIBUTE28 = decode( p_OLD_PRICING_ATTRIBUTE28, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE28, p_OLD_PRICING_ATTRIBUTE28),
1078 NEW_PRICING_ATTRIBUTE28 = decode( p_NEW_PRICING_ATTRIBUTE28, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE28, p_NEW_PRICING_ATTRIBUTE28),
1079 OLD_PRICING_ATTRIBUTE29 = decode( p_OLD_PRICING_ATTRIBUTE29, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE29, p_OLD_PRICING_ATTRIBUTE29),
1080 NEW_PRICING_ATTRIBUTE29 = decode( p_NEW_PRICING_ATTRIBUTE29, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE29, p_NEW_PRICING_ATTRIBUTE29),
1081 OLD_PRICING_ATTRIBUTE30 = decode( p_OLD_PRICING_ATTRIBUTE30, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE30, p_OLD_PRICING_ATTRIBUTE30),
1082 NEW_PRICING_ATTRIBUTE30 = decode( p_NEW_PRICING_ATTRIBUTE30, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE30, p_NEW_PRICING_ATTRIBUTE30),
1083 OLD_PRICING_ATTRIBUTE31 = decode( p_OLD_PRICING_ATTRIBUTE31, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE31, p_OLD_PRICING_ATTRIBUTE31),
1084 NEW_PRICING_ATTRIBUTE31 = decode( p_NEW_PRICING_ATTRIBUTE31, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE31, p_NEW_PRICING_ATTRIBUTE31),
1085 OLD_PRICING_ATTRIBUTE32 = decode( p_OLD_PRICING_ATTRIBUTE32, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE32, p_OLD_PRICING_ATTRIBUTE32),
1086 NEW_PRICING_ATTRIBUTE32 = decode( p_NEW_PRICING_ATTRIBUTE32, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE32, p_NEW_PRICING_ATTRIBUTE32),
1087 OLD_PRICING_ATTRIBUTE33 = decode( p_OLD_PRICING_ATTRIBUTE33, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE33, p_OLD_PRICING_ATTRIBUTE33),
1088 NEW_PRICING_ATTRIBUTE33 = decode( p_NEW_PRICING_ATTRIBUTE33, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE33, p_NEW_PRICING_ATTRIBUTE33),
1089 OLD_PRICING_ATTRIBUTE34 = decode( p_OLD_PRICING_ATTRIBUTE34, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE34, p_OLD_PRICING_ATTRIBUTE34),
1090 NEW_PRICING_ATTRIBUTE34 = decode( p_NEW_PRICING_ATTRIBUTE34, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE34, p_NEW_PRICING_ATTRIBUTE34),
1094 NEW_PRICING_ATTRIBUTE36 = decode( p_NEW_PRICING_ATTRIBUTE36, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE36, p_NEW_PRICING_ATTRIBUTE36),
1091 OLD_PRICING_ATTRIBUTE35 = decode( p_OLD_PRICING_ATTRIBUTE35, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE35, p_OLD_PRICING_ATTRIBUTE35),
1092 NEW_PRICING_ATTRIBUTE35 = decode( p_NEW_PRICING_ATTRIBUTE35, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE35, p_NEW_PRICING_ATTRIBUTE35),
1093 OLD_PRICING_ATTRIBUTE36 = decode( p_OLD_PRICING_ATTRIBUTE36, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE36, p_OLD_PRICING_ATTRIBUTE36),
1095 OLD_PRICING_ATTRIBUTE37 = decode( p_OLD_PRICING_ATTRIBUTE37, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE37, p_OLD_PRICING_ATTRIBUTE37),
1096 NEW_PRICING_ATTRIBUTE37 = decode( p_NEW_PRICING_ATTRIBUTE37, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE37, p_NEW_PRICING_ATTRIBUTE37),
1097 OLD_PRICING_ATTRIBUTE38 = decode( p_OLD_PRICING_ATTRIBUTE38, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE38, p_OLD_PRICING_ATTRIBUTE38),
1098 NEW_PRICING_ATTRIBUTE38 = decode( p_NEW_PRICING_ATTRIBUTE38, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE38, p_NEW_PRICING_ATTRIBUTE38),
1099 OLD_PRICING_ATTRIBUTE39 = decode( p_OLD_PRICING_ATTRIBUTE39, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE39, p_OLD_PRICING_ATTRIBUTE39),
1100 NEW_PRICING_ATTRIBUTE39 = decode( p_NEW_PRICING_ATTRIBUTE39, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE39, p_NEW_PRICING_ATTRIBUTE39),
1101 OLD_PRICING_ATTRIBUTE40 = decode( p_OLD_PRICING_ATTRIBUTE40, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE40, p_OLD_PRICING_ATTRIBUTE40),
1102 NEW_PRICING_ATTRIBUTE40 = decode( p_NEW_PRICING_ATTRIBUTE40, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE40, p_NEW_PRICING_ATTRIBUTE40),
1103 OLD_PRICING_ATTRIBUTE41 = decode( p_OLD_PRICING_ATTRIBUTE41, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE41, p_OLD_PRICING_ATTRIBUTE41),
1104 NEW_PRICING_ATTRIBUTE41 = decode( p_NEW_PRICING_ATTRIBUTE41, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE41, p_NEW_PRICING_ATTRIBUTE41),
1105 OLD_PRICING_ATTRIBUTE42 = decode( p_OLD_PRICING_ATTRIBUTE42, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE42, p_OLD_PRICING_ATTRIBUTE42),
1106 NEW_PRICING_ATTRIBUTE42 = decode( p_NEW_PRICING_ATTRIBUTE42, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE42, p_NEW_PRICING_ATTRIBUTE42),
1107 OLD_PRICING_ATTRIBUTE43 = decode( p_OLD_PRICING_ATTRIBUTE43, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE43, p_OLD_PRICING_ATTRIBUTE43),
1108 NEW_PRICING_ATTRIBUTE43 = decode( p_NEW_PRICING_ATTRIBUTE43, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE43, p_NEW_PRICING_ATTRIBUTE43),
1109 OLD_PRICING_ATTRIBUTE44 = decode( p_OLD_PRICING_ATTRIBUTE44, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE44, p_OLD_PRICING_ATTRIBUTE44),
1110 NEW_PRICING_ATTRIBUTE44 = decode( p_NEW_PRICING_ATTRIBUTE44, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE44, p_NEW_PRICING_ATTRIBUTE44),
1111 OLD_PRICING_ATTRIBUTE45 = decode( p_OLD_PRICING_ATTRIBUTE45, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE45, p_OLD_PRICING_ATTRIBUTE45),
1112 NEW_PRICING_ATTRIBUTE45 = decode( p_NEW_PRICING_ATTRIBUTE45, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE45, p_NEW_PRICING_ATTRIBUTE45),
1113 OLD_PRICING_ATTRIBUTE46 = decode( p_OLD_PRICING_ATTRIBUTE46, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE46, p_OLD_PRICING_ATTRIBUTE46),
1114 NEW_PRICING_ATTRIBUTE46 = decode( p_NEW_PRICING_ATTRIBUTE46, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE46, p_NEW_PRICING_ATTRIBUTE46),
1115 OLD_PRICING_ATTRIBUTE47 = decode( p_OLD_PRICING_ATTRIBUTE47, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE47, p_OLD_PRICING_ATTRIBUTE47),
1116 NEW_PRICING_ATTRIBUTE47 = decode( p_NEW_PRICING_ATTRIBUTE47, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE47, p_NEW_PRICING_ATTRIBUTE47),
1117 OLD_PRICING_ATTRIBUTE48 = decode( p_OLD_PRICING_ATTRIBUTE48, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE48, p_OLD_PRICING_ATTRIBUTE48),
1118 NEW_PRICING_ATTRIBUTE48 = decode( p_NEW_PRICING_ATTRIBUTE48, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE48, p_NEW_PRICING_ATTRIBUTE48),
1119 OLD_PRICING_ATTRIBUTE49 = decode( p_OLD_PRICING_ATTRIBUTE49, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE49, p_OLD_PRICING_ATTRIBUTE49),
1120 NEW_PRICING_ATTRIBUTE49 = decode( p_NEW_PRICING_ATTRIBUTE49, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE49, p_NEW_PRICING_ATTRIBUTE49),
1121 OLD_PRICING_ATTRIBUTE50 = decode( p_OLD_PRICING_ATTRIBUTE50, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE50, p_OLD_PRICING_ATTRIBUTE50),
1122 NEW_PRICING_ATTRIBUTE50 = decode( p_NEW_PRICING_ATTRIBUTE50, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE50, p_NEW_PRICING_ATTRIBUTE50),
1123 OLD_PRICING_ATTRIBUTE51 = decode( p_OLD_PRICING_ATTRIBUTE51, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE51, p_OLD_PRICING_ATTRIBUTE51),
1124 NEW_PRICING_ATTRIBUTE51 = decode( p_NEW_PRICING_ATTRIBUTE51, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE51, p_NEW_PRICING_ATTRIBUTE51),
1125 OLD_PRICING_ATTRIBUTE52 = decode( p_OLD_PRICING_ATTRIBUTE52, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE52, p_OLD_PRICING_ATTRIBUTE52),
1126 NEW_PRICING_ATTRIBUTE52 = decode( p_NEW_PRICING_ATTRIBUTE52, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE52, p_NEW_PRICING_ATTRIBUTE52),
1127 OLD_PRICING_ATTRIBUTE53 = decode( p_OLD_PRICING_ATTRIBUTE53, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE53, p_OLD_PRICING_ATTRIBUTE53),
1128 NEW_PRICING_ATTRIBUTE53 = decode( p_NEW_PRICING_ATTRIBUTE53, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE53, p_NEW_PRICING_ATTRIBUTE53),
1129 OLD_PRICING_ATTRIBUTE54 = decode( p_OLD_PRICING_ATTRIBUTE54, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE54, p_OLD_PRICING_ATTRIBUTE54),
1130 NEW_PRICING_ATTRIBUTE54 = decode( p_NEW_PRICING_ATTRIBUTE54, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE54, p_NEW_PRICING_ATTRIBUTE54),
1131 OLD_PRICING_ATTRIBUTE55 = decode( p_OLD_PRICING_ATTRIBUTE55, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE55, p_OLD_PRICING_ATTRIBUTE55),
1132 NEW_PRICING_ATTRIBUTE55 = decode( p_NEW_PRICING_ATTRIBUTE55, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE55, p_NEW_PRICING_ATTRIBUTE55),
1133 OLD_PRICING_ATTRIBUTE56 = decode( p_OLD_PRICING_ATTRIBUTE56, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE56, p_OLD_PRICING_ATTRIBUTE56),
1134 NEW_PRICING_ATTRIBUTE56 = decode( p_NEW_PRICING_ATTRIBUTE56, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE56, p_NEW_PRICING_ATTRIBUTE56),
1138 NEW_PRICING_ATTRIBUTE58 = decode( p_NEW_PRICING_ATTRIBUTE58, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE58, p_NEW_PRICING_ATTRIBUTE58),
1135 OLD_PRICING_ATTRIBUTE57 = decode( p_OLD_PRICING_ATTRIBUTE57, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE57, p_OLD_PRICING_ATTRIBUTE57),
1136 NEW_PRICING_ATTRIBUTE57 = decode( p_NEW_PRICING_ATTRIBUTE57, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE57, p_NEW_PRICING_ATTRIBUTE57),
1137 OLD_PRICING_ATTRIBUTE58 = decode( p_OLD_PRICING_ATTRIBUTE58, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE58, p_OLD_PRICING_ATTRIBUTE58),
1139 OLD_PRICING_ATTRIBUTE59 = decode( p_OLD_PRICING_ATTRIBUTE59, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE59, p_OLD_PRICING_ATTRIBUTE59),
1140 NEW_PRICING_ATTRIBUTE59 = decode( p_NEW_PRICING_ATTRIBUTE59, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE59, p_NEW_PRICING_ATTRIBUTE59),
1141 OLD_PRICING_ATTRIBUTE60 = decode( p_OLD_PRICING_ATTRIBUTE60, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE60, p_OLD_PRICING_ATTRIBUTE60),
1142 NEW_PRICING_ATTRIBUTE60 = decode( p_NEW_PRICING_ATTRIBUTE60, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE60, p_NEW_PRICING_ATTRIBUTE60),
1143 OLD_PRICING_ATTRIBUTE61 = decode( p_OLD_PRICING_ATTRIBUTE61, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE61, p_OLD_PRICING_ATTRIBUTE61),
1144 NEW_PRICING_ATTRIBUTE61 = decode( p_NEW_PRICING_ATTRIBUTE61, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE61, p_NEW_PRICING_ATTRIBUTE61),
1145 OLD_PRICING_ATTRIBUTE62 = decode( p_OLD_PRICING_ATTRIBUTE62, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE62, p_OLD_PRICING_ATTRIBUTE62),
1146 NEW_PRICING_ATTRIBUTE62 = decode( p_NEW_PRICING_ATTRIBUTE62, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE62, p_NEW_PRICING_ATTRIBUTE62),
1147 OLD_PRICING_ATTRIBUTE63 = decode( p_OLD_PRICING_ATTRIBUTE63, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE63, p_OLD_PRICING_ATTRIBUTE63),
1148 NEW_PRICING_ATTRIBUTE63 = decode( p_NEW_PRICING_ATTRIBUTE63, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE63, p_NEW_PRICING_ATTRIBUTE63),
1149 OLD_PRICING_ATTRIBUTE64 = decode( p_OLD_PRICING_ATTRIBUTE64, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE64, p_OLD_PRICING_ATTRIBUTE64),
1150 NEW_PRICING_ATTRIBUTE64 = decode( p_NEW_PRICING_ATTRIBUTE64, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE64, p_NEW_PRICING_ATTRIBUTE64),
1151 OLD_PRICING_ATTRIBUTE65 = decode( p_OLD_PRICING_ATTRIBUTE65, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE65, p_OLD_PRICING_ATTRIBUTE65),
1152 NEW_PRICING_ATTRIBUTE65 = decode( p_NEW_PRICING_ATTRIBUTE65, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE65, p_NEW_PRICING_ATTRIBUTE65),
1153 OLD_PRICING_ATTRIBUTE66 = decode( p_OLD_PRICING_ATTRIBUTE66, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE66, p_OLD_PRICING_ATTRIBUTE66),
1154 NEW_PRICING_ATTRIBUTE66 = decode( p_NEW_PRICING_ATTRIBUTE66, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE66, p_NEW_PRICING_ATTRIBUTE66),
1155 OLD_PRICING_ATTRIBUTE67 = decode( p_OLD_PRICING_ATTRIBUTE67, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE67, p_OLD_PRICING_ATTRIBUTE67),
1156 NEW_PRICING_ATTRIBUTE67 = decode( p_NEW_PRICING_ATTRIBUTE67, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE67, p_NEW_PRICING_ATTRIBUTE67),
1157 OLD_PRICING_ATTRIBUTE68 = decode( p_OLD_PRICING_ATTRIBUTE68, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE68, p_OLD_PRICING_ATTRIBUTE68),
1158 NEW_PRICING_ATTRIBUTE68 = decode( p_NEW_PRICING_ATTRIBUTE68, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE68, p_NEW_PRICING_ATTRIBUTE68),
1159 OLD_PRICING_ATTRIBUTE69 = decode( p_OLD_PRICING_ATTRIBUTE69, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE69, p_OLD_PRICING_ATTRIBUTE69),
1160 NEW_PRICING_ATTRIBUTE69 = decode( p_NEW_PRICING_ATTRIBUTE69, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE69, p_NEW_PRICING_ATTRIBUTE69),
1161 OLD_PRICING_ATTRIBUTE70 = decode( p_OLD_PRICING_ATTRIBUTE70, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE70, p_OLD_PRICING_ATTRIBUTE70),
1162 NEW_PRICING_ATTRIBUTE70 = decode( p_NEW_PRICING_ATTRIBUTE70, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE70, p_NEW_PRICING_ATTRIBUTE70),
1163 OLD_PRICING_ATTRIBUTE71 = decode( p_OLD_PRICING_ATTRIBUTE71, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE71, p_OLD_PRICING_ATTRIBUTE71),
1164 NEW_PRICING_ATTRIBUTE71 = decode( p_NEW_PRICING_ATTRIBUTE71, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE71, p_NEW_PRICING_ATTRIBUTE71),
1165 OLD_PRICING_ATTRIBUTE72 = decode( p_OLD_PRICING_ATTRIBUTE72, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE72, p_OLD_PRICING_ATTRIBUTE72),
1166 NEW_PRICING_ATTRIBUTE72 = decode( p_NEW_PRICING_ATTRIBUTE72, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE72, p_NEW_PRICING_ATTRIBUTE72),
1167 OLD_PRICING_ATTRIBUTE73 = decode( p_OLD_PRICING_ATTRIBUTE73, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE73, p_OLD_PRICING_ATTRIBUTE73),
1168 NEW_PRICING_ATTRIBUTE73 = decode( p_NEW_PRICING_ATTRIBUTE73, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE73, p_NEW_PRICING_ATTRIBUTE73),
1169 OLD_PRICING_ATTRIBUTE74 = decode( p_OLD_PRICING_ATTRIBUTE74, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE74, p_OLD_PRICING_ATTRIBUTE74),
1170 NEW_PRICING_ATTRIBUTE74 = decode( p_NEW_PRICING_ATTRIBUTE74, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE74, p_NEW_PRICING_ATTRIBUTE74),
1171 OLD_PRICING_ATTRIBUTE75 = decode( p_OLD_PRICING_ATTRIBUTE75, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE75, p_OLD_PRICING_ATTRIBUTE75),
1172 NEW_PRICING_ATTRIBUTE75 = decode( p_NEW_PRICING_ATTRIBUTE75, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE75, p_NEW_PRICING_ATTRIBUTE75),
1173 OLD_PRICING_ATTRIBUTE76 = decode( p_OLD_PRICING_ATTRIBUTE76, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE76, p_OLD_PRICING_ATTRIBUTE76),
1174 NEW_PRICING_ATTRIBUTE76 = decode( p_NEW_PRICING_ATTRIBUTE76, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE76, p_NEW_PRICING_ATTRIBUTE76),
1175 OLD_PRICING_ATTRIBUTE77 = decode( p_OLD_PRICING_ATTRIBUTE77, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE77, p_OLD_PRICING_ATTRIBUTE77),
1176 NEW_PRICING_ATTRIBUTE77 = decode( p_NEW_PRICING_ATTRIBUTE77, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE77, p_NEW_PRICING_ATTRIBUTE77),
1177 OLD_PRICING_ATTRIBUTE78 = decode( p_OLD_PRICING_ATTRIBUTE78, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE78, p_OLD_PRICING_ATTRIBUTE78),
1178 NEW_PRICING_ATTRIBUTE78 = decode( p_NEW_PRICING_ATTRIBUTE78, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE78, p_NEW_PRICING_ATTRIBUTE78),
1182 NEW_PRICING_ATTRIBUTE80 = decode( p_NEW_PRICING_ATTRIBUTE80, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE80, p_NEW_PRICING_ATTRIBUTE80),
1179 OLD_PRICING_ATTRIBUTE79 = decode( p_OLD_PRICING_ATTRIBUTE79, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE79, p_OLD_PRICING_ATTRIBUTE79),
1180 NEW_PRICING_ATTRIBUTE79 = decode( p_NEW_PRICING_ATTRIBUTE79, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE79, p_NEW_PRICING_ATTRIBUTE79),
1181 OLD_PRICING_ATTRIBUTE80 = decode( p_OLD_PRICING_ATTRIBUTE80, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE80, p_OLD_PRICING_ATTRIBUTE80),
1183 OLD_PRICING_ATTRIBUTE81 = decode( p_OLD_PRICING_ATTRIBUTE81, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE81, p_OLD_PRICING_ATTRIBUTE81),
1184 NEW_PRICING_ATTRIBUTE81 = decode( p_NEW_PRICING_ATTRIBUTE81, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE81, p_NEW_PRICING_ATTRIBUTE81),
1185 OLD_PRICING_ATTRIBUTE82 = decode( p_OLD_PRICING_ATTRIBUTE82, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE82, p_OLD_PRICING_ATTRIBUTE82),
1186 NEW_PRICING_ATTRIBUTE82 = decode( p_NEW_PRICING_ATTRIBUTE82, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE82, p_NEW_PRICING_ATTRIBUTE82),
1187 OLD_PRICING_ATTRIBUTE83 = decode( p_OLD_PRICING_ATTRIBUTE83, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE83, p_OLD_PRICING_ATTRIBUTE83),
1188 NEW_PRICING_ATTRIBUTE83 = decode( p_NEW_PRICING_ATTRIBUTE83, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE83, p_NEW_PRICING_ATTRIBUTE83),
1189 OLD_PRICING_ATTRIBUTE84 = decode( p_OLD_PRICING_ATTRIBUTE84, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE84, p_OLD_PRICING_ATTRIBUTE84),
1190 NEW_PRICING_ATTRIBUTE84 = decode( p_NEW_PRICING_ATTRIBUTE84, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE84, p_NEW_PRICING_ATTRIBUTE84),
1191 OLD_PRICING_ATTRIBUTE85 = decode( p_OLD_PRICING_ATTRIBUTE85, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE85, p_OLD_PRICING_ATTRIBUTE85),
1192 NEW_PRICING_ATTRIBUTE85 = decode( p_NEW_PRICING_ATTRIBUTE85, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE85, p_NEW_PRICING_ATTRIBUTE85),
1193 OLD_PRICING_ATTRIBUTE86 = decode( p_OLD_PRICING_ATTRIBUTE86, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE86, p_OLD_PRICING_ATTRIBUTE86),
1194 NEW_PRICING_ATTRIBUTE86 = decode( p_NEW_PRICING_ATTRIBUTE86, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE86, p_NEW_PRICING_ATTRIBUTE86),
1195 OLD_PRICING_ATTRIBUTE87 = decode( p_OLD_PRICING_ATTRIBUTE87, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE87, p_OLD_PRICING_ATTRIBUTE87),
1196 NEW_PRICING_ATTRIBUTE87 = decode( p_NEW_PRICING_ATTRIBUTE87, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE87, p_NEW_PRICING_ATTRIBUTE87),
1197 OLD_PRICING_ATTRIBUTE88 = decode( p_OLD_PRICING_ATTRIBUTE88, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE88, p_OLD_PRICING_ATTRIBUTE88),
1198 NEW_PRICING_ATTRIBUTE88 = decode( p_NEW_PRICING_ATTRIBUTE88, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE88, p_NEW_PRICING_ATTRIBUTE88),
1199 OLD_PRICING_ATTRIBUTE89 = decode( p_OLD_PRICING_ATTRIBUTE89, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE89, p_OLD_PRICING_ATTRIBUTE89),
1200 NEW_PRICING_ATTRIBUTE89 = decode( p_NEW_PRICING_ATTRIBUTE89, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE89, p_NEW_PRICING_ATTRIBUTE89),
1201 OLD_PRICING_ATTRIBUTE90 = decode( p_OLD_PRICING_ATTRIBUTE90, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE90, p_OLD_PRICING_ATTRIBUTE90),
1202 NEW_PRICING_ATTRIBUTE90 = decode( p_NEW_PRICING_ATTRIBUTE90, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE90, p_NEW_PRICING_ATTRIBUTE90),
1203 OLD_PRICING_ATTRIBUTE91 = decode( p_OLD_PRICING_ATTRIBUTE91, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE91, p_OLD_PRICING_ATTRIBUTE91),
1204 NEW_PRICING_ATTRIBUTE91 = decode( p_NEW_PRICING_ATTRIBUTE91, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE91, p_NEW_PRICING_ATTRIBUTE91),
1205 OLD_PRICING_ATTRIBUTE92 = decode( p_OLD_PRICING_ATTRIBUTE92, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE92, p_OLD_PRICING_ATTRIBUTE92),
1206 NEW_PRICING_ATTRIBUTE92 = decode( p_NEW_PRICING_ATTRIBUTE92, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE92, p_NEW_PRICING_ATTRIBUTE92),
1207 OLD_PRICING_ATTRIBUTE93 = decode( p_OLD_PRICING_ATTRIBUTE93, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE93, p_OLD_PRICING_ATTRIBUTE93),
1208 NEW_PRICING_ATTRIBUTE93 = decode( p_NEW_PRICING_ATTRIBUTE93, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE93, p_NEW_PRICING_ATTRIBUTE93),
1209 OLD_PRICING_ATTRIBUTE94 = decode( p_OLD_PRICING_ATTRIBUTE94, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE94, p_OLD_PRICING_ATTRIBUTE94),
1210 NEW_PRICING_ATTRIBUTE94 = decode( p_NEW_PRICING_ATTRIBUTE94, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE94, p_NEW_PRICING_ATTRIBUTE94),
1211 OLD_PRICING_ATTRIBUTE95 = decode( p_OLD_PRICING_ATTRIBUTE95, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE95, p_OLD_PRICING_ATTRIBUTE95),
1212 NEW_PRICING_ATTRIBUTE95 = decode( p_NEW_PRICING_ATTRIBUTE95, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE95, p_NEW_PRICING_ATTRIBUTE95),
1213 OLD_PRICING_ATTRIBUTE96 = decode( p_OLD_PRICING_ATTRIBUTE96, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE96, p_OLD_PRICING_ATTRIBUTE96),
1214 NEW_PRICING_ATTRIBUTE96 = decode( p_NEW_PRICING_ATTRIBUTE96, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE96, p_NEW_PRICING_ATTRIBUTE96),
1215 OLD_PRICING_ATTRIBUTE97 = decode( p_OLD_PRICING_ATTRIBUTE97, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE97, p_OLD_PRICING_ATTRIBUTE97),
1216 NEW_PRICING_ATTRIBUTE97 = decode( p_NEW_PRICING_ATTRIBUTE97, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE97, p_NEW_PRICING_ATTRIBUTE97),
1217 OLD_PRICING_ATTRIBUTE98 = decode( p_OLD_PRICING_ATTRIBUTE98, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE98, p_OLD_PRICING_ATTRIBUTE98),
1218 NEW_PRICING_ATTRIBUTE98 = decode( p_NEW_PRICING_ATTRIBUTE98, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE98, p_NEW_PRICING_ATTRIBUTE98),
1219 OLD_PRICING_ATTRIBUTE99 = decode( p_OLD_PRICING_ATTRIBUTE99, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE99, p_OLD_PRICING_ATTRIBUTE99),
1220 NEW_PRICING_ATTRIBUTE99 = decode( p_NEW_PRICING_ATTRIBUTE99, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE99, p_NEW_PRICING_ATTRIBUTE99),
1221 OLD_PRICING_ATTRIBUTE100 = decode( p_OLD_PRICING_ATTRIBUTE100, FND_API.G_MISS_CHAR, OLD_PRICING_ATTRIBUTE100, p_OLD_PRICING_ATTRIBUTE100),
1222 NEW_PRICING_ATTRIBUTE100 = decode( p_NEW_PRICING_ATTRIBUTE100, FND_API.G_MISS_CHAR, NEW_PRICING_ATTRIBUTE100, p_NEW_PRICING_ATTRIBUTE100),
1226 NEW_ACTIVE_END_DATE = decode( p_NEW_ACTIVE_END_DATE, FND_API.G_MISS_DATE, NEW_ACTIVE_END_DATE, p_NEW_ACTIVE_END_DATE),
1223 OLD_ACTIVE_START_DATE = decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, OLD_ACTIVE_START_DATE, p_OLD_ACTIVE_START_DATE),
1224 NEW_ACTIVE_START_DATE = decode( p_NEW_ACTIVE_START_DATE, FND_API.G_MISS_DATE, NEW_ACTIVE_START_DATE, p_NEW_ACTIVE_START_DATE),
1225 OLD_ACTIVE_END_DATE = decode( p_OLD_ACTIVE_END_DATE, FND_API.G_MISS_DATE, OLD_ACTIVE_END_DATE, p_OLD_ACTIVE_END_DATE),
1227 OLD_CONTEXT = decode( p_OLD_CONTEXT, FND_API.G_MISS_CHAR, OLD_CONTEXT, p_OLD_CONTEXT),
1228 NEW_CONTEXT = decode( p_NEW_CONTEXT, FND_API.G_MISS_CHAR, NEW_CONTEXT, p_NEW_CONTEXT),
1229 OLD_ATTRIBUTE1 = decode( p_OLD_ATTRIBUTE1, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE1, p_OLD_ATTRIBUTE1),
1230 NEW_ATTRIBUTE1 = decode( p_NEW_ATTRIBUTE1, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE1, p_NEW_ATTRIBUTE1),
1231 OLD_ATTRIBUTE2 = decode( p_OLD_ATTRIBUTE2, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE2, p_OLD_ATTRIBUTE2),
1232 NEW_ATTRIBUTE2 = decode( p_NEW_ATTRIBUTE2, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE2, p_NEW_ATTRIBUTE2),
1233 OLD_ATTRIBUTE3 = decode( p_OLD_ATTRIBUTE3, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE3, p_OLD_ATTRIBUTE3),
1234 NEW_ATTRIBUTE3 = decode( p_NEW_ATTRIBUTE3, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE3, p_NEW_ATTRIBUTE3),
1235 OLD_ATTRIBUTE4 = decode( p_OLD_ATTRIBUTE4, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE4, p_OLD_ATTRIBUTE4),
1236 NEW_ATTRIBUTE4 = decode( p_NEW_ATTRIBUTE4, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE4, p_NEW_ATTRIBUTE4),
1237 OLD_ATTRIBUTE5 = decode( p_OLD_ATTRIBUTE5, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE5, p_OLD_ATTRIBUTE5),
1238 NEW_ATTRIBUTE5 = decode( p_NEW_ATTRIBUTE5, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE5, p_NEW_ATTRIBUTE5),
1239 OLD_ATTRIBUTE6 = decode( p_OLD_ATTRIBUTE6, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE6, p_OLD_ATTRIBUTE6),
1240 NEW_ATTRIBUTE6 = decode( p_NEW_ATTRIBUTE6, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE6, p_NEW_ATTRIBUTE6),
1241 OLD_ATTRIBUTE7 = decode( p_OLD_ATTRIBUTE7, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE7, p_OLD_ATTRIBUTE7),
1242 NEW_ATTRIBUTE7 = decode( p_NEW_ATTRIBUTE7, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE7, p_NEW_ATTRIBUTE7),
1243 OLD_ATTRIBUTE8 = decode( p_OLD_ATTRIBUTE8, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE8, p_OLD_ATTRIBUTE8),
1244 NEW_ATTRIBUTE8 = decode( p_NEW_ATTRIBUTE8, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE8, p_NEW_ATTRIBUTE8),
1245 OLD_ATTRIBUTE9 = decode( p_OLD_ATTRIBUTE9, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE9, p_OLD_ATTRIBUTE9),
1246 NEW_ATTRIBUTE9 = decode( p_NEW_ATTRIBUTE9, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE9, p_NEW_ATTRIBUTE9),
1247 OLD_ATTRIBUTE10 = decode( p_OLD_ATTRIBUTE10, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE10, p_OLD_ATTRIBUTE10),
1248 NEW_ATTRIBUTE10 = decode( p_NEW_ATTRIBUTE10, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE10, p_NEW_ATTRIBUTE10),
1249 OLD_ATTRIBUTE11 = decode( p_OLD_ATTRIBUTE11, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE11, p_OLD_ATTRIBUTE11),
1250 NEW_ATTRIBUTE11 = decode( p_NEW_ATTRIBUTE11, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE11, p_NEW_ATTRIBUTE11),
1251 OLD_ATTRIBUTE12 = decode( p_OLD_ATTRIBUTE12, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE12, p_OLD_ATTRIBUTE12),
1252 NEW_ATTRIBUTE12 = decode( p_NEW_ATTRIBUTE12, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE12, p_NEW_ATTRIBUTE12),
1253 OLD_ATTRIBUTE13 = decode( p_OLD_ATTRIBUTE13, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE13, p_OLD_ATTRIBUTE13),
1254 NEW_ATTRIBUTE13 = decode( p_NEW_ATTRIBUTE13, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE13, p_NEW_ATTRIBUTE13),
1255 OLD_ATTRIBUTE14 = decode( p_OLD_ATTRIBUTE14, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE14, p_OLD_ATTRIBUTE14),
1256 NEW_ATTRIBUTE14 = decode( p_NEW_ATTRIBUTE14, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE14, p_NEW_ATTRIBUTE14),
1257 OLD_ATTRIBUTE15 = decode( p_OLD_ATTRIBUTE15, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE15, p_OLD_ATTRIBUTE15),
1258 NEW_ATTRIBUTE15 = decode( p_NEW_ATTRIBUTE15, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE15, p_NEW_ATTRIBUTE15), FULL_DUMP_FLAG = decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, FULL_DUMP_FLAG, p_FULL_DUMP_FLAG),
1259 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
1260 CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
1261 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
1262 LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
1263 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
1264 -- OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
1265 OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
1266 where PRICE_ATTRIB_HISTORY_ID = p_PRICE_ATTRIB_HISTORY_ID;
1267
1268 If (SQL%NOTFOUND) then
1269 RAISE NO_DATA_FOUND;
1270 End If;
1271 END Update_Row;
1272
1273 PROCEDURE Delete_Row(
1274 p_PRICE_ATTRIB_HISTORY_ID NUMBER)
1275 IS
1276 BEGIN
1277 DELETE FROM CSI_I_PRICING_ATTRIBS_H
1278 WHERE PRICE_ATTRIB_HISTORY_ID = p_PRICE_ATTRIB_HISTORY_ID;
1279 If (SQL%NOTFOUND) then
1280 RAISE NO_DATA_FOUND;
1281 End If;
1282 END Delete_Row;
1283
1284 PROCEDURE Lock_Row(
1285 p_PRICE_ATTRIB_HISTORY_ID NUMBER,
1286 p_PRICING_ATTRIBUTE_ID NUMBER,
1287 p_TRANSACTION_ID NUMBER,
1288 p_OLD_PRICING_CONTEXT VARCHAR2,
1289 p_NEW_PRICING_CONTEXT VARCHAR2,
1290 p_OLD_PRICING_ATTRIBUTE1 VARCHAR2,
1291 p_NEW_PRICING_ATTRIBUTE1 VARCHAR2,
1292 p_OLD_PRICING_ATTRIBUTE2 VARCHAR2,
1293 p_NEW_PRICING_ATTRIBUTE2 VARCHAR2,
1294 p_OLD_PRICING_ATTRIBUTE3 VARCHAR2,
1295 p_NEW_PRICING_ATTRIBUTE3 VARCHAR2,
1296 p_OLD_PRICING_ATTRIBUTE4 VARCHAR2,
1297 p_NEW_PRICING_ATTRIBUTE4 VARCHAR2,
1301 p_NEW_PRICING_ATTRIBUTE6 VARCHAR2,
1298 p_OLD_PRICING_ATTRIBUTE5 VARCHAR2,
1299 p_NEW_PRICING_ATTRIBUTE5 VARCHAR2,
1300 p_OLD_PRICING_ATTRIBUTE6 VARCHAR2,
1302 p_OLD_PRICING_ATTRIBUTE7 VARCHAR2,
1303 p_NEW_PRICING_ATTRIBUTE7 VARCHAR2,
1304 p_OLD_PRICING_ATTRIBUTE8 VARCHAR2,
1305 p_NEW_PRICING_ATTRIBUTE8 VARCHAR2,
1306 p_OLD_PRICING_ATTRIBUTE9 VARCHAR2,
1307 p_NEW_PRICING_ATTRIBUTE9 VARCHAR2,
1308 p_OLD_PRICING_ATTRIBUTE10 VARCHAR2,
1309 p_NEW_PRICING_ATTRIBUTE10 VARCHAR2,
1310 p_OLD_PRICING_ATTRIBUTE11 VARCHAR2,
1311 p_NEW_PRICING_ATTRIBUTE11 VARCHAR2,
1312 p_OLD_PRICING_ATTRIBUTE12 VARCHAR2,
1313 p_NEW_PRICING_ATTRIBUTE12 VARCHAR2,
1314 p_OLD_PRICING_ATTRIBUTE13 VARCHAR2,
1315 p_NEW_PRICING_ATTRIBUTE13 VARCHAR2,
1316 p_OLD_PRICING_ATTRIBUTE14 VARCHAR2,
1317 p_NEW_PRICING_ATTRIBUTE14 VARCHAR2,
1318 p_OLD_PRICING_ATTRIBUTE15 VARCHAR2,
1319 p_NEW_PRICING_ATTRIBUTE15 VARCHAR2,
1320 p_OLD_PRICING_ATTRIBUTE16 VARCHAR2,
1321 p_NEW_PRICING_ATTRIBUTE16 VARCHAR2,
1322 p_OLD_PRICING_ATTRIBUTE17 VARCHAR2,
1323 p_NEW_PRICING_ATTRIBUTE17 VARCHAR2,
1324 p_OLD_PRICING_ATTRIBUTE18 VARCHAR2,
1325 p_NEW_PRICING_ATTRIBUTE18 VARCHAR2,
1326 p_OLD_PRICING_ATTRIBUTE19 VARCHAR2,
1327 p_NEW_PRICING_ATTRIBUTE19 VARCHAR2,
1328 p_OLD_PRICING_ATTRIBUTE20 VARCHAR2,
1329 p_NEW_PRICING_ATTRIBUTE20 VARCHAR2,
1330 p_OLD_PRICING_ATTRIBUTE21 VARCHAR2,
1331 p_NEW_PRICING_ATTRIBUTE21 VARCHAR2,
1332 p_OLD_PRICING_ATTRIBUTE22 VARCHAR2,
1333 p_NEW_PRICING_ATTRIBUTE22 VARCHAR2,
1334 p_OLD_PRICING_ATTRIBUTE23 VARCHAR2,
1335 p_NEW_PRICING_ATTRIBUTE23 VARCHAR2,
1336 p_OLD_PRICING_ATTRIBUTE24 VARCHAR2,
1337 p_NEW_PRICING_ATTRIBUTE24 VARCHAR2,
1338 p_NEW_PRICING_ATTRIBUTE25 VARCHAR2,
1339 p_OLD_PRICING_ATTRIBUTE25 VARCHAR2,
1340 p_OLD_PRICING_ATTRIBUTE26 VARCHAR2,
1341 p_NEW_PRICING_ATTRIBUTE26 VARCHAR2,
1342 p_OLD_PRICING_ATTRIBUTE27 VARCHAR2,
1343 p_NEW_PRICING_ATTRIBUTE27 VARCHAR2,
1344 p_OLD_PRICING_ATTRIBUTE28 VARCHAR2,
1345 p_NEW_PRICING_ATTRIBUTE28 VARCHAR2,
1346 p_OLD_PRICING_ATTRIBUTE29 VARCHAR2,
1347 p_NEW_PRICING_ATTRIBUTE29 VARCHAR2,
1348 p_OLD_PRICING_ATTRIBUTE30 VARCHAR2,
1349 p_NEW_PRICING_ATTRIBUTE30 VARCHAR2,
1350 p_OLD_PRICING_ATTRIBUTE31 VARCHAR2,
1351 p_NEW_PRICING_ATTRIBUTE31 VARCHAR2,
1352 p_OLD_PRICING_ATTRIBUTE32 VARCHAR2,
1353 p_NEW_PRICING_ATTRIBUTE32 VARCHAR2,
1354 p_OLD_PRICING_ATTRIBUTE33 VARCHAR2,
1355 p_NEW_PRICING_ATTRIBUTE33 VARCHAR2,
1356 p_OLD_PRICING_ATTRIBUTE34 VARCHAR2,
1357 p_NEW_PRICING_ATTRIBUTE34 VARCHAR2,
1358 p_OLD_PRICING_ATTRIBUTE35 VARCHAR2,
1359 p_NEW_PRICING_ATTRIBUTE35 VARCHAR2,
1360 p_OLD_PRICING_ATTRIBUTE36 VARCHAR2,
1361 p_NEW_PRICING_ATTRIBUTE36 VARCHAR2,
1362 p_OLD_PRICING_ATTRIBUTE37 VARCHAR2,
1363 p_NEW_PRICING_ATTRIBUTE37 VARCHAR2,
1364 p_OLD_PRICING_ATTRIBUTE38 VARCHAR2,
1365 p_NEW_PRICING_ATTRIBUTE38 VARCHAR2,
1366 p_OLD_PRICING_ATTRIBUTE39 VARCHAR2,
1367 p_NEW_PRICING_ATTRIBUTE39 VARCHAR2,
1368 p_OLD_PRICING_ATTRIBUTE40 VARCHAR2,
1369 p_NEW_PRICING_ATTRIBUTE40 VARCHAR2,
1370 p_OLD_PRICING_ATTRIBUTE41 VARCHAR2,
1371 p_NEW_PRICING_ATTRIBUTE41 VARCHAR2,
1372 p_OLD_PRICING_ATTRIBUTE42 VARCHAR2,
1373 p_NEW_PRICING_ATTRIBUTE42 VARCHAR2,
1374 p_OLD_PRICING_ATTRIBUTE43 VARCHAR2,
1375 p_NEW_PRICING_ATTRIBUTE43 VARCHAR2,
1376 p_OLD_PRICING_ATTRIBUTE44 VARCHAR2,
1377 p_NEW_PRICING_ATTRIBUTE44 VARCHAR2,
1378 p_OLD_PRICING_ATTRIBUTE45 VARCHAR2,
1379 p_NEW_PRICING_ATTRIBUTE45 VARCHAR2,
1380 p_OLD_PRICING_ATTRIBUTE46 VARCHAR2,
1381 p_NEW_PRICING_ATTRIBUTE46 VARCHAR2,
1382 p_OLD_PRICING_ATTRIBUTE47 VARCHAR2,
1383 p_NEW_PRICING_ATTRIBUTE47 VARCHAR2,
1384 p_OLD_PRICING_ATTRIBUTE48 VARCHAR2,
1385 p_NEW_PRICING_ATTRIBUTE48 VARCHAR2,
1386 p_OLD_PRICING_ATTRIBUTE49 VARCHAR2,
1387 p_NEW_PRICING_ATTRIBUTE49 VARCHAR2,
1388 p_OLD_PRICING_ATTRIBUTE50 VARCHAR2,
1389 p_NEW_PRICING_ATTRIBUTE50 VARCHAR2,
1390 p_OLD_PRICING_ATTRIBUTE51 VARCHAR2,
1391 p_NEW_PRICING_ATTRIBUTE51 VARCHAR2,
1392 p_OLD_PRICING_ATTRIBUTE52 VARCHAR2,
1393 p_NEW_PRICING_ATTRIBUTE52 VARCHAR2,
1394 p_OLD_PRICING_ATTRIBUTE53 VARCHAR2,
1395 p_NEW_PRICING_ATTRIBUTE53 VARCHAR2,
1396 p_OLD_PRICING_ATTRIBUTE54 VARCHAR2,
1397 p_NEW_PRICING_ATTRIBUTE54 VARCHAR2,
1398 p_OLD_PRICING_ATTRIBUTE55 VARCHAR2,
1399 p_NEW_PRICING_ATTRIBUTE55 VARCHAR2,
1400 p_OLD_PRICING_ATTRIBUTE56 VARCHAR2,
1401 p_NEW_PRICING_ATTRIBUTE56 VARCHAR2,
1402 p_OLD_PRICING_ATTRIBUTE57 VARCHAR2,
1403 p_NEW_PRICING_ATTRIBUTE57 VARCHAR2,
1404 p_OLD_PRICING_ATTRIBUTE58 VARCHAR2,
1405 p_NEW_PRICING_ATTRIBUTE58 VARCHAR2,
1406 p_OLD_PRICING_ATTRIBUTE59 VARCHAR2,
1407 p_NEW_PRICING_ATTRIBUTE59 VARCHAR2,
1408 p_OLD_PRICING_ATTRIBUTE60 VARCHAR2,
1409 p_NEW_PRICING_ATTRIBUTE60 VARCHAR2,
1410 p_OLD_PRICING_ATTRIBUTE61 VARCHAR2,
1411 p_NEW_PRICING_ATTRIBUTE61 VARCHAR2,
1415 p_NEW_PRICING_ATTRIBUTE63 VARCHAR2,
1412 p_OLD_PRICING_ATTRIBUTE62 VARCHAR2,
1413 p_NEW_PRICING_ATTRIBUTE62 VARCHAR2,
1414 p_OLD_PRICING_ATTRIBUTE63 VARCHAR2,
1416 p_OLD_PRICING_ATTRIBUTE64 VARCHAR2,
1417 p_NEW_PRICING_ATTRIBUTE64 VARCHAR2,
1418 p_OLD_PRICING_ATTRIBUTE65 VARCHAR2,
1419 p_NEW_PRICING_ATTRIBUTE65 VARCHAR2,
1420 p_OLD_PRICING_ATTRIBUTE66 VARCHAR2,
1421 p_NEW_PRICING_ATTRIBUTE66 VARCHAR2,
1422 p_OLD_PRICING_ATTRIBUTE67 VARCHAR2,
1423 p_NEW_PRICING_ATTRIBUTE67 VARCHAR2,
1424 p_OLD_PRICING_ATTRIBUTE68 VARCHAR2,
1425 p_NEW_PRICING_ATTRIBUTE68 VARCHAR2,
1426 p_OLD_PRICING_ATTRIBUTE69 VARCHAR2,
1427 p_NEW_PRICING_ATTRIBUTE69 VARCHAR2,
1428 p_OLD_PRICING_ATTRIBUTE70 VARCHAR2,
1429 p_NEW_PRICING_ATTRIBUTE70 VARCHAR2,
1430 p_OLD_PRICING_ATTRIBUTE71 VARCHAR2,
1431 p_NEW_PRICING_ATTRIBUTE71 VARCHAR2,
1432 p_OLD_PRICING_ATTRIBUTE72 VARCHAR2,
1433 p_NEW_PRICING_ATTRIBUTE72 VARCHAR2,
1434 p_OLD_PRICING_ATTRIBUTE73 VARCHAR2,
1435 p_NEW_PRICING_ATTRIBUTE73 VARCHAR2,
1436 p_OLD_PRICING_ATTRIBUTE74 VARCHAR2,
1437 p_NEW_PRICING_ATTRIBUTE74 VARCHAR2,
1438 p_OLD_PRICING_ATTRIBUTE75 VARCHAR2,
1439 p_NEW_PRICING_ATTRIBUTE75 VARCHAR2,
1440 p_OLD_PRICING_ATTRIBUTE76 VARCHAR2,
1441 p_NEW_PRICING_ATTRIBUTE76 VARCHAR2,
1442 p_OLD_PRICING_ATTRIBUTE77 VARCHAR2,
1443 p_NEW_PRICING_ATTRIBUTE77 VARCHAR2,
1444 p_OLD_PRICING_ATTRIBUTE78 VARCHAR2,
1445 p_NEW_PRICING_ATTRIBUTE78 VARCHAR2,
1446 p_OLD_PRICING_ATTRIBUTE79 VARCHAR2,
1447 p_NEW_PRICING_ATTRIBUTE79 VARCHAR2,
1448 p_OLD_PRICING_ATTRIBUTE80 VARCHAR2,
1449 p_NEW_PRICING_ATTRIBUTE80 VARCHAR2,
1450 p_OLD_PRICING_ATTRIBUTE81 VARCHAR2,
1451 p_NEW_PRICING_ATTRIBUTE81 VARCHAR2,
1452 p_OLD_PRICING_ATTRIBUTE82 VARCHAR2,
1453 p_NEW_PRICING_ATTRIBUTE82 VARCHAR2,
1454 p_OLD_PRICING_ATTRIBUTE83 VARCHAR2,
1455 p_NEW_PRICING_ATTRIBUTE83 VARCHAR2,
1456 p_OLD_PRICING_ATTRIBUTE84 VARCHAR2,
1457 p_NEW_PRICING_ATTRIBUTE84 VARCHAR2,
1458 p_OLD_PRICING_ATTRIBUTE85 VARCHAR2,
1459 p_NEW_PRICING_ATTRIBUTE85 VARCHAR2,
1460 p_OLD_PRICING_ATTRIBUTE86 VARCHAR2,
1461 p_NEW_PRICING_ATTRIBUTE86 VARCHAR2,
1462 p_OLD_PRICING_ATTRIBUTE87 VARCHAR2,
1463 p_NEW_PRICING_ATTRIBUTE87 VARCHAR2,
1464 p_OLD_PRICING_ATTRIBUTE88 VARCHAR2,
1465 p_NEW_PRICING_ATTRIBUTE88 VARCHAR2,
1466 p_OLD_PRICING_ATTRIBUTE89 VARCHAR2,
1467 p_NEW_PRICING_ATTRIBUTE89 VARCHAR2,
1468 p_OLD_PRICING_ATTRIBUTE90 VARCHAR2,
1469 p_NEW_PRICING_ATTRIBUTE90 VARCHAR2,
1470 p_OLD_PRICING_ATTRIBUTE91 VARCHAR2,
1471 p_NEW_PRICING_ATTRIBUTE91 VARCHAR2,
1472 p_OLD_PRICING_ATTRIBUTE92 VARCHAR2,
1473 p_NEW_PRICING_ATTRIBUTE92 VARCHAR2,
1474 p_OLD_PRICING_ATTRIBUTE93 VARCHAR2,
1475 p_NEW_PRICING_ATTRIBUTE93 VARCHAR2,
1476 p_OLD_PRICING_ATTRIBUTE94 VARCHAR2,
1477 p_NEW_PRICING_ATTRIBUTE94 VARCHAR2,
1478 p_OLD_PRICING_ATTRIBUTE95 VARCHAR2,
1479 p_NEW_PRICING_ATTRIBUTE95 VARCHAR2,
1480 p_OLD_PRICING_ATTRIBUTE96 VARCHAR2,
1481 p_NEW_PRICING_ATTRIBUTE96 VARCHAR2,
1482 p_OLD_PRICING_ATTRIBUTE97 VARCHAR2,
1483 p_NEW_PRICING_ATTRIBUTE97 VARCHAR2,
1484 p_OLD_PRICING_ATTRIBUTE98 VARCHAR2,
1485 p_NEW_PRICING_ATTRIBUTE98 VARCHAR2,
1486 p_OLD_PRICING_ATTRIBUTE99 VARCHAR2,
1487 p_NEW_PRICING_ATTRIBUTE99 VARCHAR2,
1488 p_OLD_PRICING_ATTRIBUTE100 VARCHAR2,
1489 p_NEW_PRICING_ATTRIBUTE100 VARCHAR2,
1490 p_OLD_ACTIVE_START_DATE DATE,
1491 p_NEW_ACTIVE_START_DATE DATE,
1492 p_OLD_ACTIVE_END_DATE DATE,
1493 p_NEW_ACTIVE_END_DATE DATE,
1494 p_OLD_CONTEXT VARCHAR2,
1495 p_NEW_CONTEXT VARCHAR2,
1496 p_OLD_ATTRIBUTE1 VARCHAR2,
1497 p_NEW_ATTRIBUTE1 VARCHAR2,
1498 p_OLD_ATTRIBUTE2 VARCHAR2,
1499 p_NEW_ATTRIBUTE2 VARCHAR2,
1500 p_OLD_ATTRIBUTE3 VARCHAR2,
1501 p_NEW_ATTRIBUTE3 VARCHAR2,
1502 p_OLD_ATTRIBUTE4 VARCHAR2,
1503 p_NEW_ATTRIBUTE4 VARCHAR2,
1504 p_OLD_ATTRIBUTE5 VARCHAR2,
1505 p_NEW_ATTRIBUTE5 VARCHAR2,
1506 p_OLD_ATTRIBUTE6 VARCHAR2,
1507 p_NEW_ATTRIBUTE6 VARCHAR2,
1508 p_OLD_ATTRIBUTE7 VARCHAR2,
1509 p_NEW_ATTRIBUTE7 VARCHAR2,
1510 p_OLD_ATTRIBUTE8 VARCHAR2,
1511 p_NEW_ATTRIBUTE8 VARCHAR2,
1512 p_OLD_ATTRIBUTE9 VARCHAR2,
1513 p_NEW_ATTRIBUTE9 VARCHAR2,
1514 p_OLD_ATTRIBUTE10 VARCHAR2,
1515 p_NEW_ATTRIBUTE10 VARCHAR2,
1516 p_OLD_ATTRIBUTE11 VARCHAR2,
1517 p_NEW_ATTRIBUTE11 VARCHAR2,
1518 p_OLD_ATTRIBUTE12 VARCHAR2,
1519 p_NEW_ATTRIBUTE12 VARCHAR2,
1520 p_OLD_ATTRIBUTE13 VARCHAR2,
1521 p_NEW_ATTRIBUTE13 VARCHAR2,
1522 p_OLD_ATTRIBUTE14 VARCHAR2,
1523 p_NEW_ATTRIBUTE14 VARCHAR2,
1524 p_OLD_ATTRIBUTE15 VARCHAR2,
1525 p_NEW_ATTRIBUTE15 VARCHAR2,
1526 p_FULL_DUMP_FLAG VARCHAR2,
1527 p_CREATED_BY NUMBER,
1528 p_CREATION_DATE DATE,
1529 p_LAST_UPDATED_BY NUMBER,
1530 p_LAST_UPDATE_DATE DATE,
1534 CURSOR C IS
1531 p_LAST_UPDATE_LOGIN NUMBER,
1532 p_OBJECT_VERSION_NUMBER NUMBER)
1533 IS
1535 SELECT *
1536 FROM CSI_I_PRICING_ATTRIBS_H
1537 WHERE PRICE_ATTRIB_HISTORY_ID = p_PRICE_ATTRIB_HISTORY_ID
1538 FOR UPDATE of PRICE_ATTRIB_HISTORY_ID NOWAIT;
1539 Recinfo C%ROWTYPE;
1540 BEGIN
1541 OPEN C;
1542 FETCH C INTO Recinfo;
1543 If (C%NOTFOUND) then
1544 CLOSE C;
1545 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1546 APP_EXCEPTION.RAISE_EXCEPTION;
1547 End If;
1548 CLOSE C;
1549 if (
1550 ( Recinfo.PRICE_ATTRIB_HISTORY_ID = p_PRICE_ATTRIB_HISTORY_ID)
1551 AND ( ( Recinfo.PRICING_ATTRIBUTE_ID = p_PRICING_ATTRIBUTE_ID)
1552 OR ( ( Recinfo.PRICING_ATTRIBUTE_ID IS NULL )
1553 AND ( p_PRICING_ATTRIBUTE_ID IS NULL )))
1554 AND ( ( Recinfo.TRANSACTION_ID = p_TRANSACTION_ID)
1555 OR ( ( Recinfo.TRANSACTION_ID IS NULL )
1556 AND ( p_TRANSACTION_ID IS NULL )))
1557 AND ( ( Recinfo.OLD_PRICING_CONTEXT = p_OLD_PRICING_CONTEXT)
1558 OR ( ( Recinfo.OLD_PRICING_CONTEXT IS NULL )
1559 AND ( p_OLD_PRICING_CONTEXT IS NULL )))
1560 AND ( ( Recinfo.NEW_PRICING_CONTEXT = p_NEW_PRICING_CONTEXT)
1561 OR ( ( Recinfo.NEW_PRICING_CONTEXT IS NULL )
1562 AND ( p_NEW_PRICING_CONTEXT IS NULL )))
1563 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE1 = p_OLD_PRICING_ATTRIBUTE1)
1564 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE1 IS NULL )
1565 AND ( p_OLD_PRICING_ATTRIBUTE1 IS NULL )))
1566 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE1 = p_NEW_PRICING_ATTRIBUTE1)
1567 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE1 IS NULL )
1568 AND ( p_NEW_PRICING_ATTRIBUTE1 IS NULL )))
1569 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE2 = p_OLD_PRICING_ATTRIBUTE2)
1570 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE2 IS NULL )
1571 AND ( p_OLD_PRICING_ATTRIBUTE2 IS NULL )))
1572 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE2 = p_NEW_PRICING_ATTRIBUTE2)
1573 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE2 IS NULL )
1574 AND ( p_NEW_PRICING_ATTRIBUTE2 IS NULL )))
1575 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE3 = p_OLD_PRICING_ATTRIBUTE3)
1576 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE3 IS NULL )
1577 AND ( p_OLD_PRICING_ATTRIBUTE3 IS NULL )))
1578 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE3 = p_NEW_PRICING_ATTRIBUTE3)
1579 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE3 IS NULL )
1580 AND ( p_NEW_PRICING_ATTRIBUTE3 IS NULL )))
1581 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE4 = p_OLD_PRICING_ATTRIBUTE4)
1582 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE4 IS NULL )
1583 AND ( p_OLD_PRICING_ATTRIBUTE4 IS NULL )))
1584 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE4 = p_NEW_PRICING_ATTRIBUTE4)
1585 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE4 IS NULL )
1586 AND ( p_NEW_PRICING_ATTRIBUTE4 IS NULL )))
1587 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE5 = p_OLD_PRICING_ATTRIBUTE5)
1588 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE5 IS NULL )
1589 AND ( p_OLD_PRICING_ATTRIBUTE5 IS NULL )))
1590 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE5 = p_NEW_PRICING_ATTRIBUTE5)
1591 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE5 IS NULL )
1592 AND ( p_NEW_PRICING_ATTRIBUTE5 IS NULL )))
1593 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE6 = p_OLD_PRICING_ATTRIBUTE6)
1594 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE6 IS NULL )
1595 AND ( p_OLD_PRICING_ATTRIBUTE6 IS NULL )))
1596 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE6 = p_NEW_PRICING_ATTRIBUTE6)
1597 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE6 IS NULL )
1598 AND ( p_NEW_PRICING_ATTRIBUTE6 IS NULL )))
1599 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE7 = p_OLD_PRICING_ATTRIBUTE7)
1600 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE7 IS NULL )
1601 AND ( p_OLD_PRICING_ATTRIBUTE7 IS NULL )))
1602 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE7 = p_NEW_PRICING_ATTRIBUTE7)
1603 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE7 IS NULL )
1604 AND ( p_NEW_PRICING_ATTRIBUTE7 IS NULL )))
1605 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE8 = p_OLD_PRICING_ATTRIBUTE8)
1606 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE8 IS NULL )
1607 AND ( p_OLD_PRICING_ATTRIBUTE8 IS NULL )))
1608 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE8 = p_NEW_PRICING_ATTRIBUTE8)
1609 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE8 IS NULL )
1610 AND ( p_NEW_PRICING_ATTRIBUTE8 IS NULL )))
1611 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE9 = p_OLD_PRICING_ATTRIBUTE9)
1612 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE9 IS NULL )
1613 AND ( p_OLD_PRICING_ATTRIBUTE9 IS NULL )))
1614 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE9 = p_NEW_PRICING_ATTRIBUTE9)
1615 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE9 IS NULL )
1616 AND ( p_NEW_PRICING_ATTRIBUTE9 IS NULL )))
1617 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE10 = p_OLD_PRICING_ATTRIBUTE10)
1618 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE10 IS NULL )
1619 AND ( p_OLD_PRICING_ATTRIBUTE10 IS NULL )))
1620 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE10 = p_NEW_PRICING_ATTRIBUTE10)
1621 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE10 IS NULL )
1622 AND ( p_NEW_PRICING_ATTRIBUTE10 IS NULL )))
1623 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE11 = p_OLD_PRICING_ATTRIBUTE11)
1624 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE11 IS NULL )
1625 AND ( p_OLD_PRICING_ATTRIBUTE11 IS NULL )))
1626 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE11 = p_NEW_PRICING_ATTRIBUTE11)
1627 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE11 IS NULL )
1628 AND ( p_NEW_PRICING_ATTRIBUTE11 IS NULL )))
1632 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE12 = p_NEW_PRICING_ATTRIBUTE12)
1629 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE12 = p_OLD_PRICING_ATTRIBUTE12)
1630 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE12 IS NULL )
1631 AND ( p_OLD_PRICING_ATTRIBUTE12 IS NULL )))
1633 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE12 IS NULL )
1634 AND ( p_NEW_PRICING_ATTRIBUTE12 IS NULL )))
1635 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE13 = p_OLD_PRICING_ATTRIBUTE13)
1636 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE13 IS NULL )
1637 AND ( p_OLD_PRICING_ATTRIBUTE13 IS NULL )))
1638 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE13 = p_NEW_PRICING_ATTRIBUTE13)
1639 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE13 IS NULL )
1640 AND ( p_NEW_PRICING_ATTRIBUTE13 IS NULL )))
1641 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE14 = p_OLD_PRICING_ATTRIBUTE14)
1642 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE14 IS NULL )
1643 AND ( p_OLD_PRICING_ATTRIBUTE14 IS NULL )))
1644 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE14 = p_NEW_PRICING_ATTRIBUTE14)
1645 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE14 IS NULL )
1646 AND ( p_NEW_PRICING_ATTRIBUTE14 IS NULL )))
1647 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE15 = p_OLD_PRICING_ATTRIBUTE15)
1648 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE15 IS NULL )
1649 AND ( p_OLD_PRICING_ATTRIBUTE15 IS NULL )))
1650 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE15 = p_NEW_PRICING_ATTRIBUTE15)
1651 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE15 IS NULL )
1652 AND ( p_NEW_PRICING_ATTRIBUTE15 IS NULL )))
1653 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE16 = p_OLD_PRICING_ATTRIBUTE16)
1654 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE16 IS NULL )
1655 AND ( p_OLD_PRICING_ATTRIBUTE16 IS NULL )))
1656 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE16 = p_NEW_PRICING_ATTRIBUTE16)
1657 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE16 IS NULL )
1658 AND ( p_NEW_PRICING_ATTRIBUTE16 IS NULL )))
1659 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE17 = p_OLD_PRICING_ATTRIBUTE17)
1660 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE17 IS NULL )
1661 AND ( p_OLD_PRICING_ATTRIBUTE17 IS NULL )))
1662 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE17 = p_NEW_PRICING_ATTRIBUTE17)
1663 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE17 IS NULL )
1664 AND ( p_NEW_PRICING_ATTRIBUTE17 IS NULL )))
1665 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE18 = p_OLD_PRICING_ATTRIBUTE18)
1666 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE18 IS NULL )
1667 AND ( p_OLD_PRICING_ATTRIBUTE18 IS NULL )))
1668 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE18 = p_NEW_PRICING_ATTRIBUTE18)
1669 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE18 IS NULL )
1670 AND ( p_NEW_PRICING_ATTRIBUTE18 IS NULL )))
1671 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE19 = p_OLD_PRICING_ATTRIBUTE19)
1672 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE19 IS NULL )
1673 AND ( p_OLD_PRICING_ATTRIBUTE19 IS NULL )))
1674 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE19 = p_NEW_PRICING_ATTRIBUTE19)
1675 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE19 IS NULL )
1676 AND ( p_NEW_PRICING_ATTRIBUTE19 IS NULL )))
1677 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE20 = p_OLD_PRICING_ATTRIBUTE20)
1678 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE20 IS NULL )
1679 AND ( p_OLD_PRICING_ATTRIBUTE20 IS NULL )))
1680 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE20 = p_NEW_PRICING_ATTRIBUTE20)
1681 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE20 IS NULL )
1682 AND ( p_NEW_PRICING_ATTRIBUTE20 IS NULL )))
1683 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE21 = p_OLD_PRICING_ATTRIBUTE21)
1684 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE21 IS NULL )
1685 AND ( p_OLD_PRICING_ATTRIBUTE21 IS NULL )))
1686 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE21 = p_NEW_PRICING_ATTRIBUTE21)
1687 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE21 IS NULL )
1688 AND ( p_NEW_PRICING_ATTRIBUTE21 IS NULL )))
1689 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE22 = p_OLD_PRICING_ATTRIBUTE22)
1690 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE22 IS NULL )
1691 AND ( p_OLD_PRICING_ATTRIBUTE22 IS NULL )))
1692 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE22 = p_NEW_PRICING_ATTRIBUTE22)
1693 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE22 IS NULL )
1694 AND ( p_NEW_PRICING_ATTRIBUTE22 IS NULL )))
1695 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE23 = p_OLD_PRICING_ATTRIBUTE23)
1696 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE23 IS NULL )
1697 AND ( p_OLD_PRICING_ATTRIBUTE23 IS NULL )))
1698 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE23 = p_NEW_PRICING_ATTRIBUTE23)
1699 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE23 IS NULL )
1700 AND ( p_NEW_PRICING_ATTRIBUTE23 IS NULL )))
1701 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE24 = p_OLD_PRICING_ATTRIBUTE24)
1702 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE24 IS NULL )
1703 AND ( p_OLD_PRICING_ATTRIBUTE24 IS NULL )))
1704 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE24 = p_NEW_PRICING_ATTRIBUTE24)
1705 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE24 IS NULL )
1706 AND ( p_NEW_PRICING_ATTRIBUTE24 IS NULL )))
1707 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE25 = p_NEW_PRICING_ATTRIBUTE25)
1708 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE25 IS NULL )
1709 AND ( p_NEW_PRICING_ATTRIBUTE25 IS NULL )))
1710 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE25 = p_OLD_PRICING_ATTRIBUTE25)
1711 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE25 IS NULL )
1712 AND ( p_OLD_PRICING_ATTRIBUTE25 IS NULL )))
1713 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE26 = p_OLD_PRICING_ATTRIBUTE26)
1714 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE26 IS NULL )
1715 AND ( p_OLD_PRICING_ATTRIBUTE26 IS NULL )))
1719 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE27 = p_OLD_PRICING_ATTRIBUTE27)
1716 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE26 = p_NEW_PRICING_ATTRIBUTE26)
1717 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE26 IS NULL )
1718 AND ( p_NEW_PRICING_ATTRIBUTE26 IS NULL )))
1720 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE27 IS NULL )
1721 AND ( p_OLD_PRICING_ATTRIBUTE27 IS NULL )))
1722 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE27 = p_NEW_PRICING_ATTRIBUTE27)
1723 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE27 IS NULL )
1724 AND ( p_NEW_PRICING_ATTRIBUTE27 IS NULL )))
1725 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE28 = p_OLD_PRICING_ATTRIBUTE28)
1726 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE28 IS NULL )
1727 AND ( p_OLD_PRICING_ATTRIBUTE28 IS NULL )))
1728 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE28 = p_NEW_PRICING_ATTRIBUTE28)
1729 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE28 IS NULL )
1730 AND ( p_NEW_PRICING_ATTRIBUTE28 IS NULL )))
1731 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE29 = p_OLD_PRICING_ATTRIBUTE29)
1732 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE29 IS NULL )
1733 AND ( p_OLD_PRICING_ATTRIBUTE29 IS NULL )))
1734 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE29 = p_NEW_PRICING_ATTRIBUTE29)
1735 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE29 IS NULL )
1736 AND ( p_NEW_PRICING_ATTRIBUTE29 IS NULL )))
1737 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE30 = p_OLD_PRICING_ATTRIBUTE30)
1738 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE30 IS NULL )
1739 AND ( p_OLD_PRICING_ATTRIBUTE30 IS NULL )))
1740 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE30 = p_NEW_PRICING_ATTRIBUTE30)
1741 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE30 IS NULL )
1742 AND ( p_NEW_PRICING_ATTRIBUTE30 IS NULL )))
1743 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE31 = p_OLD_PRICING_ATTRIBUTE31)
1744 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE31 IS NULL )
1745 AND ( p_OLD_PRICING_ATTRIBUTE31 IS NULL )))
1746 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE31 = p_NEW_PRICING_ATTRIBUTE31)
1747 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE31 IS NULL )
1748 AND ( p_NEW_PRICING_ATTRIBUTE31 IS NULL )))
1749 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE32 = p_OLD_PRICING_ATTRIBUTE32)
1750 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE32 IS NULL )
1751 AND ( p_OLD_PRICING_ATTRIBUTE32 IS NULL )))
1752 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE32 = p_NEW_PRICING_ATTRIBUTE32)
1753 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE32 IS NULL )
1754 AND ( p_NEW_PRICING_ATTRIBUTE32 IS NULL )))
1755 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE33 = p_OLD_PRICING_ATTRIBUTE33)
1756 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE33 IS NULL )
1757 AND ( p_OLD_PRICING_ATTRIBUTE33 IS NULL )))
1758 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE33 = p_NEW_PRICING_ATTRIBUTE33)
1759 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE33 IS NULL )
1760 AND ( p_NEW_PRICING_ATTRIBUTE33 IS NULL )))
1761 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE34 = p_OLD_PRICING_ATTRIBUTE34)
1762 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE34 IS NULL )
1763 AND ( p_OLD_PRICING_ATTRIBUTE34 IS NULL )))
1764 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE34 = p_NEW_PRICING_ATTRIBUTE34)
1765 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE34 IS NULL )
1766 AND ( p_NEW_PRICING_ATTRIBUTE34 IS NULL )))
1767 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE35 = p_OLD_PRICING_ATTRIBUTE35)
1768 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE35 IS NULL )
1769 AND ( p_OLD_PRICING_ATTRIBUTE35 IS NULL )))
1770 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE35 = p_NEW_PRICING_ATTRIBUTE35)
1771 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE35 IS NULL )
1772 AND ( p_NEW_PRICING_ATTRIBUTE35 IS NULL )))
1773 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE36 = p_OLD_PRICING_ATTRIBUTE36)
1774 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE36 IS NULL )
1775 AND ( p_OLD_PRICING_ATTRIBUTE36 IS NULL )))
1776 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE36 = p_NEW_PRICING_ATTRIBUTE36)
1777 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE36 IS NULL )
1778 AND ( p_NEW_PRICING_ATTRIBUTE36 IS NULL )))
1779 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE37 = p_OLD_PRICING_ATTRIBUTE37)
1780 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE37 IS NULL )
1781 AND ( p_OLD_PRICING_ATTRIBUTE37 IS NULL )))
1782 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE37 = p_NEW_PRICING_ATTRIBUTE37)
1783 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE37 IS NULL )
1784 AND ( p_NEW_PRICING_ATTRIBUTE37 IS NULL )))
1785 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE38 = p_OLD_PRICING_ATTRIBUTE38)
1786 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE38 IS NULL )
1787 AND ( p_OLD_PRICING_ATTRIBUTE38 IS NULL )))
1788 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE38 = p_NEW_PRICING_ATTRIBUTE38)
1789 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE38 IS NULL )
1790 AND ( p_NEW_PRICING_ATTRIBUTE38 IS NULL )))
1791 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE39 = p_OLD_PRICING_ATTRIBUTE39)
1792 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE39 IS NULL )
1793 AND ( p_OLD_PRICING_ATTRIBUTE39 IS NULL )))
1794 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE39 = p_NEW_PRICING_ATTRIBUTE39)
1795 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE39 IS NULL )
1796 AND ( p_NEW_PRICING_ATTRIBUTE39 IS NULL )))
1797 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE40 = p_OLD_PRICING_ATTRIBUTE40)
1798 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE40 IS NULL )
1799 AND ( p_OLD_PRICING_ATTRIBUTE40 IS NULL )))
1800 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE40 = p_NEW_PRICING_ATTRIBUTE40)
1801 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE40 IS NULL )
1802 AND ( p_NEW_PRICING_ATTRIBUTE40 IS NULL )))
1806 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE41 = p_NEW_PRICING_ATTRIBUTE41)
1803 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE41 = p_OLD_PRICING_ATTRIBUTE41)
1804 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE41 IS NULL )
1805 AND ( p_OLD_PRICING_ATTRIBUTE41 IS NULL )))
1807 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE41 IS NULL )
1808 AND ( p_NEW_PRICING_ATTRIBUTE41 IS NULL )))
1809 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE42 = p_OLD_PRICING_ATTRIBUTE42)
1810 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE42 IS NULL )
1811 AND ( p_OLD_PRICING_ATTRIBUTE42 IS NULL )))
1812 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE42 = p_NEW_PRICING_ATTRIBUTE42)
1813 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE42 IS NULL )
1814 AND ( p_NEW_PRICING_ATTRIBUTE42 IS NULL )))
1815 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE43 = p_OLD_PRICING_ATTRIBUTE43)
1816 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE43 IS NULL )
1817 AND ( p_OLD_PRICING_ATTRIBUTE43 IS NULL )))
1818 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE43 = p_NEW_PRICING_ATTRIBUTE43)
1819 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE43 IS NULL )
1820 AND ( p_NEW_PRICING_ATTRIBUTE43 IS NULL )))
1821 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE44 = p_OLD_PRICING_ATTRIBUTE44)
1822 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE44 IS NULL )
1823 AND ( p_OLD_PRICING_ATTRIBUTE44 IS NULL )))
1824 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE44 = p_NEW_PRICING_ATTRIBUTE44)
1825 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE44 IS NULL )
1826 AND ( p_NEW_PRICING_ATTRIBUTE44 IS NULL )))
1827 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE45 = p_OLD_PRICING_ATTRIBUTE45)
1828 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE45 IS NULL )
1829 AND ( p_OLD_PRICING_ATTRIBUTE45 IS NULL )))
1830 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE45 = p_NEW_PRICING_ATTRIBUTE45)
1831 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE45 IS NULL )
1832 AND ( p_NEW_PRICING_ATTRIBUTE45 IS NULL )))
1833 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE46 = p_OLD_PRICING_ATTRIBUTE46)
1834 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE46 IS NULL )
1835 AND ( p_OLD_PRICING_ATTRIBUTE46 IS NULL )))
1836 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE46 = p_NEW_PRICING_ATTRIBUTE46)
1837 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE46 IS NULL )
1838 AND ( p_NEW_PRICING_ATTRIBUTE46 IS NULL )))
1839 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE47 = p_OLD_PRICING_ATTRIBUTE47)
1840 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE47 IS NULL )
1841 AND ( p_OLD_PRICING_ATTRIBUTE47 IS NULL )))
1842 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE47 = p_NEW_PRICING_ATTRIBUTE47)
1843 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE47 IS NULL )
1844 AND ( p_NEW_PRICING_ATTRIBUTE47 IS NULL )))
1845 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE48 = p_OLD_PRICING_ATTRIBUTE48)
1846 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE48 IS NULL )
1847 AND ( p_OLD_PRICING_ATTRIBUTE48 IS NULL )))
1848 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE48 = p_NEW_PRICING_ATTRIBUTE48)
1849 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE48 IS NULL )
1850 AND ( p_NEW_PRICING_ATTRIBUTE48 IS NULL )))
1851 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE49 = p_OLD_PRICING_ATTRIBUTE49)
1852 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE49 IS NULL )
1853 AND ( p_OLD_PRICING_ATTRIBUTE49 IS NULL )))
1854 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE49 = p_NEW_PRICING_ATTRIBUTE49)
1855 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE49 IS NULL )
1856 AND ( p_NEW_PRICING_ATTRIBUTE49 IS NULL )))
1857 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE50 = p_OLD_PRICING_ATTRIBUTE50)
1858 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE50 IS NULL )
1859 AND ( p_OLD_PRICING_ATTRIBUTE50 IS NULL )))
1860 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE50 = p_NEW_PRICING_ATTRIBUTE50)
1861 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE50 IS NULL )
1862 AND ( p_NEW_PRICING_ATTRIBUTE50 IS NULL )))
1863 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE51 = p_OLD_PRICING_ATTRIBUTE51)
1864 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE51 IS NULL )
1865 AND ( p_OLD_PRICING_ATTRIBUTE51 IS NULL )))
1866 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE51 = p_NEW_PRICING_ATTRIBUTE51)
1867 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE51 IS NULL )
1868 AND ( p_NEW_PRICING_ATTRIBUTE51 IS NULL )))
1869 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE52 = p_OLD_PRICING_ATTRIBUTE52)
1870 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE52 IS NULL )
1871 AND ( p_OLD_PRICING_ATTRIBUTE52 IS NULL )))
1872 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE52 = p_NEW_PRICING_ATTRIBUTE52)
1873 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE52 IS NULL )
1874 AND ( p_NEW_PRICING_ATTRIBUTE52 IS NULL )))
1875 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE53 = p_OLD_PRICING_ATTRIBUTE53)
1876 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE53 IS NULL )
1877 AND ( p_OLD_PRICING_ATTRIBUTE53 IS NULL )))
1878 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE53 = p_NEW_PRICING_ATTRIBUTE53)
1879 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE53 IS NULL )
1880 AND ( p_NEW_PRICING_ATTRIBUTE53 IS NULL )))
1881 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE54 = p_OLD_PRICING_ATTRIBUTE54)
1882 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE54 IS NULL )
1883 AND ( p_OLD_PRICING_ATTRIBUTE54 IS NULL )))
1884 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE54 = p_NEW_PRICING_ATTRIBUTE54)
1885 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE54 IS NULL )
1886 AND ( p_NEW_PRICING_ATTRIBUTE54 IS NULL )))
1887 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE55 = p_OLD_PRICING_ATTRIBUTE55)
1888 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE55 IS NULL )
1889 AND ( p_OLD_PRICING_ATTRIBUTE55 IS NULL )))
1893 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE56 = p_OLD_PRICING_ATTRIBUTE56)
1890 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE55 = p_NEW_PRICING_ATTRIBUTE55)
1891 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE55 IS NULL )
1892 AND ( p_NEW_PRICING_ATTRIBUTE55 IS NULL )))
1894 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE56 IS NULL )
1895 AND ( p_OLD_PRICING_ATTRIBUTE56 IS NULL )))
1896 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE56 = p_NEW_PRICING_ATTRIBUTE56)
1897 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE56 IS NULL )
1898 AND ( p_NEW_PRICING_ATTRIBUTE56 IS NULL )))
1899 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE57 = p_OLD_PRICING_ATTRIBUTE57)
1900 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE57 IS NULL )
1901 AND ( p_OLD_PRICING_ATTRIBUTE57 IS NULL )))
1902 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE57 = p_NEW_PRICING_ATTRIBUTE57)
1903 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE57 IS NULL )
1904 AND ( p_NEW_PRICING_ATTRIBUTE57 IS NULL )))
1905 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE58 = p_OLD_PRICING_ATTRIBUTE58)
1906 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE58 IS NULL )
1907 AND ( p_OLD_PRICING_ATTRIBUTE58 IS NULL )))
1908 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE58 = p_NEW_PRICING_ATTRIBUTE58)
1909 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE58 IS NULL )
1910 AND ( p_NEW_PRICING_ATTRIBUTE58 IS NULL )))
1911 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE59 = p_OLD_PRICING_ATTRIBUTE59)
1912 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE59 IS NULL )
1913 AND ( p_OLD_PRICING_ATTRIBUTE59 IS NULL )))
1914 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE59 = p_NEW_PRICING_ATTRIBUTE59)
1915 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE59 IS NULL )
1916 AND ( p_NEW_PRICING_ATTRIBUTE59 IS NULL )))
1917 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE60 = p_OLD_PRICING_ATTRIBUTE60)
1918 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE60 IS NULL )
1919 AND ( p_OLD_PRICING_ATTRIBUTE60 IS NULL )))
1920 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE60 = p_NEW_PRICING_ATTRIBUTE60)
1921 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE60 IS NULL )
1922 AND ( p_NEW_PRICING_ATTRIBUTE60 IS NULL )))
1923 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE61 = p_OLD_PRICING_ATTRIBUTE61)
1924 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE61 IS NULL )
1925 AND ( p_OLD_PRICING_ATTRIBUTE61 IS NULL )))
1926 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE61 = p_NEW_PRICING_ATTRIBUTE61)
1927 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE61 IS NULL )
1928 AND ( p_NEW_PRICING_ATTRIBUTE61 IS NULL )))
1929 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE62 = p_OLD_PRICING_ATTRIBUTE62)
1930 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE62 IS NULL )
1931 AND ( p_OLD_PRICING_ATTRIBUTE62 IS NULL )))
1932 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE62 = p_NEW_PRICING_ATTRIBUTE62)
1933 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE62 IS NULL )
1934 AND ( p_NEW_PRICING_ATTRIBUTE62 IS NULL )))
1935 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE63 = p_OLD_PRICING_ATTRIBUTE63)
1936 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE63 IS NULL )
1937 AND ( p_OLD_PRICING_ATTRIBUTE63 IS NULL )))
1938 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE63 = p_NEW_PRICING_ATTRIBUTE63)
1939 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE63 IS NULL )
1940 AND ( p_NEW_PRICING_ATTRIBUTE63 IS NULL )))
1941 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE64 = p_OLD_PRICING_ATTRIBUTE64)
1942 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE64 IS NULL )
1943 AND ( p_OLD_PRICING_ATTRIBUTE64 IS NULL )))
1944 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE64 = p_NEW_PRICING_ATTRIBUTE64)
1945 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE64 IS NULL )
1946 AND ( p_NEW_PRICING_ATTRIBUTE64 IS NULL )))
1947 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE65 = p_OLD_PRICING_ATTRIBUTE65)
1948 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE65 IS NULL )
1949 AND ( p_OLD_PRICING_ATTRIBUTE65 IS NULL )))
1950 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE65 = p_NEW_PRICING_ATTRIBUTE65)
1951 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE65 IS NULL )
1952 AND ( p_NEW_PRICING_ATTRIBUTE65 IS NULL )))
1953 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE66 = p_OLD_PRICING_ATTRIBUTE66)
1954 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE66 IS NULL )
1955 AND ( p_OLD_PRICING_ATTRIBUTE66 IS NULL )))
1956 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE66 = p_NEW_PRICING_ATTRIBUTE66)
1957 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE66 IS NULL )
1958 AND ( p_NEW_PRICING_ATTRIBUTE66 IS NULL )))
1959 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE67 = p_OLD_PRICING_ATTRIBUTE67)
1960 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE67 IS NULL )
1961 AND ( p_OLD_PRICING_ATTRIBUTE67 IS NULL )))
1962 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE67 = p_NEW_PRICING_ATTRIBUTE67)
1963 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE67 IS NULL )
1964 AND ( p_NEW_PRICING_ATTRIBUTE67 IS NULL )))
1965 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE68 = p_OLD_PRICING_ATTRIBUTE68)
1966 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE68 IS NULL )
1967 AND ( p_OLD_PRICING_ATTRIBUTE68 IS NULL )))
1968 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE68 = p_NEW_PRICING_ATTRIBUTE68)
1969 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE68 IS NULL )
1970 AND ( p_NEW_PRICING_ATTRIBUTE68 IS NULL )))
1971 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE69 = p_OLD_PRICING_ATTRIBUTE69)
1972 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE69 IS NULL )
1973 AND ( p_OLD_PRICING_ATTRIBUTE69 IS NULL )))
1974 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE69 = p_NEW_PRICING_ATTRIBUTE69)
1975 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE69 IS NULL )
1976 AND ( p_NEW_PRICING_ATTRIBUTE69 IS NULL )))
1980 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE70 = p_NEW_PRICING_ATTRIBUTE70)
1977 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE70 = p_OLD_PRICING_ATTRIBUTE70)
1978 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE70 IS NULL )
1979 AND ( p_OLD_PRICING_ATTRIBUTE70 IS NULL )))
1981 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE70 IS NULL )
1982 AND ( p_NEW_PRICING_ATTRIBUTE70 IS NULL )))
1983 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE71 = p_OLD_PRICING_ATTRIBUTE71)
1984 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE71 IS NULL )
1985 AND ( p_OLD_PRICING_ATTRIBUTE71 IS NULL )))
1986 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE71 = p_NEW_PRICING_ATTRIBUTE71)
1987 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE71 IS NULL )
1988 AND ( p_NEW_PRICING_ATTRIBUTE71 IS NULL )))
1989 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE72 = p_OLD_PRICING_ATTRIBUTE72)
1990 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE72 IS NULL )
1991 AND ( p_OLD_PRICING_ATTRIBUTE72 IS NULL )))
1992 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE72 = p_NEW_PRICING_ATTRIBUTE72)
1993 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE72 IS NULL )
1994 AND ( p_NEW_PRICING_ATTRIBUTE72 IS NULL )))
1995 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE73 = p_OLD_PRICING_ATTRIBUTE73)
1996 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE73 IS NULL )
1997 AND ( p_OLD_PRICING_ATTRIBUTE73 IS NULL )))
1998 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE73 = p_NEW_PRICING_ATTRIBUTE73)
1999 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE73 IS NULL )
2000 AND ( p_NEW_PRICING_ATTRIBUTE73 IS NULL )))
2001 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE74 = p_OLD_PRICING_ATTRIBUTE74)
2002 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE74 IS NULL )
2003 AND ( p_OLD_PRICING_ATTRIBUTE74 IS NULL )))
2004 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE74 = p_NEW_PRICING_ATTRIBUTE74)
2005 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE74 IS NULL )
2006 AND ( p_NEW_PRICING_ATTRIBUTE74 IS NULL )))
2007 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE75 = p_OLD_PRICING_ATTRIBUTE75)
2008 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE75 IS NULL )
2009 AND ( p_OLD_PRICING_ATTRIBUTE75 IS NULL )))
2010 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE75 = p_NEW_PRICING_ATTRIBUTE75)
2011 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE75 IS NULL )
2012 AND ( p_NEW_PRICING_ATTRIBUTE75 IS NULL )))
2013 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE76 = p_OLD_PRICING_ATTRIBUTE76)
2014 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE76 IS NULL )
2015 AND ( p_OLD_PRICING_ATTRIBUTE76 IS NULL )))
2016 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE76 = p_NEW_PRICING_ATTRIBUTE76)
2017 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE76 IS NULL )
2018 AND ( p_NEW_PRICING_ATTRIBUTE76 IS NULL )))
2019 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE77 = p_OLD_PRICING_ATTRIBUTE77)
2020 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE77 IS NULL )
2021 AND ( p_OLD_PRICING_ATTRIBUTE77 IS NULL )))
2022 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE77 = p_NEW_PRICING_ATTRIBUTE77)
2023 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE77 IS NULL )
2024 AND ( p_NEW_PRICING_ATTRIBUTE77 IS NULL )))
2025 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE78 = p_OLD_PRICING_ATTRIBUTE78)
2026 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE78 IS NULL )
2027 AND ( p_OLD_PRICING_ATTRIBUTE78 IS NULL )))
2028 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE78 = p_NEW_PRICING_ATTRIBUTE78)
2029 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE78 IS NULL )
2030 AND ( p_NEW_PRICING_ATTRIBUTE78 IS NULL )))
2031 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE79 = p_OLD_PRICING_ATTRIBUTE79)
2032 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE79 IS NULL )
2033 AND ( p_OLD_PRICING_ATTRIBUTE79 IS NULL )))
2034 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE79 = p_NEW_PRICING_ATTRIBUTE79)
2035 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE79 IS NULL )
2036 AND ( p_NEW_PRICING_ATTRIBUTE79 IS NULL )))
2037 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE80 = p_OLD_PRICING_ATTRIBUTE80)
2038 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE80 IS NULL )
2039 AND ( p_OLD_PRICING_ATTRIBUTE80 IS NULL )))
2040 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE80 = p_NEW_PRICING_ATTRIBUTE80)
2041 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE80 IS NULL )
2042 AND ( p_NEW_PRICING_ATTRIBUTE80 IS NULL )))
2043 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE81 = p_OLD_PRICING_ATTRIBUTE81)
2044 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE81 IS NULL )
2045 AND ( p_OLD_PRICING_ATTRIBUTE81 IS NULL )))
2046 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE81 = p_NEW_PRICING_ATTRIBUTE81)
2047 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE81 IS NULL )
2048 AND ( p_NEW_PRICING_ATTRIBUTE81 IS NULL )))
2049 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE82 = p_OLD_PRICING_ATTRIBUTE82)
2050 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE82 IS NULL )
2051 AND ( p_OLD_PRICING_ATTRIBUTE82 IS NULL )))
2052 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE82 = p_NEW_PRICING_ATTRIBUTE82)
2053 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE82 IS NULL )
2054 AND ( p_NEW_PRICING_ATTRIBUTE82 IS NULL )))
2055 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE83 = p_OLD_PRICING_ATTRIBUTE83)
2056 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE83 IS NULL )
2057 AND ( p_OLD_PRICING_ATTRIBUTE83 IS NULL )))
2058 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE83 = p_NEW_PRICING_ATTRIBUTE83)
2059 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE83 IS NULL )
2060 AND ( p_NEW_PRICING_ATTRIBUTE83 IS NULL )))
2061 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE84 = p_OLD_PRICING_ATTRIBUTE84)
2062 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE84 IS NULL )
2063 AND ( p_OLD_PRICING_ATTRIBUTE84 IS NULL )))
2067 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE85 = p_OLD_PRICING_ATTRIBUTE85)
2064 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE84 = p_NEW_PRICING_ATTRIBUTE84)
2065 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE84 IS NULL )
2066 AND ( p_NEW_PRICING_ATTRIBUTE84 IS NULL )))
2068 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE85 IS NULL )
2069 AND ( p_OLD_PRICING_ATTRIBUTE85 IS NULL )))
2070 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE85 = p_NEW_PRICING_ATTRIBUTE85)
2071 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE85 IS NULL )
2072 AND ( p_NEW_PRICING_ATTRIBUTE85 IS NULL )))
2073 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE86 = p_OLD_PRICING_ATTRIBUTE86)
2074 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE86 IS NULL )
2075 AND ( p_OLD_PRICING_ATTRIBUTE86 IS NULL )))
2076 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE86 = p_NEW_PRICING_ATTRIBUTE86)
2077 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE86 IS NULL )
2078 AND ( p_NEW_PRICING_ATTRIBUTE86 IS NULL )))
2079 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE87 = p_OLD_PRICING_ATTRIBUTE87)
2080 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE87 IS NULL )
2081 AND ( p_OLD_PRICING_ATTRIBUTE87 IS NULL )))
2082 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE87 = p_NEW_PRICING_ATTRIBUTE87)
2083 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE87 IS NULL )
2084 AND ( p_NEW_PRICING_ATTRIBUTE87 IS NULL )))
2085 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE88 = p_OLD_PRICING_ATTRIBUTE88)
2086 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE88 IS NULL )
2087 AND ( p_OLD_PRICING_ATTRIBUTE88 IS NULL )))
2088 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE88 = p_NEW_PRICING_ATTRIBUTE88)
2089 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE88 IS NULL )
2090 AND ( p_NEW_PRICING_ATTRIBUTE88 IS NULL )))
2091 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE89 = p_OLD_PRICING_ATTRIBUTE89)
2092 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE89 IS NULL )
2093 AND ( p_OLD_PRICING_ATTRIBUTE89 IS NULL )))
2094 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE89 = p_NEW_PRICING_ATTRIBUTE89)
2095 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE89 IS NULL )
2096 AND ( p_NEW_PRICING_ATTRIBUTE89 IS NULL )))
2097 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE90 = p_OLD_PRICING_ATTRIBUTE90)
2098 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE90 IS NULL )
2099 AND ( p_OLD_PRICING_ATTRIBUTE90 IS NULL )))
2100 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE90 = p_NEW_PRICING_ATTRIBUTE90)
2101 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE90 IS NULL )
2102 AND ( p_NEW_PRICING_ATTRIBUTE90 IS NULL )))
2103 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE91 = p_OLD_PRICING_ATTRIBUTE91)
2104 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE91 IS NULL )
2105 AND ( p_OLD_PRICING_ATTRIBUTE91 IS NULL )))
2106 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE91 = p_NEW_PRICING_ATTRIBUTE91)
2107 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE91 IS NULL )
2108 AND ( p_NEW_PRICING_ATTRIBUTE91 IS NULL )))
2109 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE92 = p_OLD_PRICING_ATTRIBUTE92)
2110 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE92 IS NULL )
2111 AND ( p_OLD_PRICING_ATTRIBUTE92 IS NULL )))
2112 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE92 = p_NEW_PRICING_ATTRIBUTE92)
2113 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE92 IS NULL )
2114 AND ( p_NEW_PRICING_ATTRIBUTE92 IS NULL )))
2115 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE93 = p_OLD_PRICING_ATTRIBUTE93)
2116 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE93 IS NULL )
2117 AND ( p_OLD_PRICING_ATTRIBUTE93 IS NULL )))
2118 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE93 = p_NEW_PRICING_ATTRIBUTE93)
2119 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE93 IS NULL )
2120 AND ( p_NEW_PRICING_ATTRIBUTE93 IS NULL )))
2121 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE94 = p_OLD_PRICING_ATTRIBUTE94)
2122 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE94 IS NULL )
2123 AND ( p_OLD_PRICING_ATTRIBUTE94 IS NULL )))
2124 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE94 = p_NEW_PRICING_ATTRIBUTE94)
2125 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE94 IS NULL )
2126 AND ( p_NEW_PRICING_ATTRIBUTE94 IS NULL )))
2127 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE95 = p_OLD_PRICING_ATTRIBUTE95)
2128 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE95 IS NULL )
2129 AND ( p_OLD_PRICING_ATTRIBUTE95 IS NULL )))
2130 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE95 = p_NEW_PRICING_ATTRIBUTE95)
2131 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE95 IS NULL )
2132 AND ( p_NEW_PRICING_ATTRIBUTE95 IS NULL )))
2133 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE96 = p_OLD_PRICING_ATTRIBUTE96)
2134 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE96 IS NULL )
2135 AND ( p_OLD_PRICING_ATTRIBUTE96 IS NULL )))
2136 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE96 = p_NEW_PRICING_ATTRIBUTE96)
2137 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE96 IS NULL )
2138 AND ( p_NEW_PRICING_ATTRIBUTE96 IS NULL )))
2139 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE97 = p_OLD_PRICING_ATTRIBUTE97)
2140 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE97 IS NULL )
2141 AND ( p_OLD_PRICING_ATTRIBUTE97 IS NULL )))
2142 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE97 = p_NEW_PRICING_ATTRIBUTE97)
2143 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE97 IS NULL )
2144 AND ( p_NEW_PRICING_ATTRIBUTE97 IS NULL )))
2145 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE98 = p_OLD_PRICING_ATTRIBUTE98)
2146 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE98 IS NULL )
2147 AND ( p_OLD_PRICING_ATTRIBUTE98 IS NULL )))
2148 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE98 = p_NEW_PRICING_ATTRIBUTE98)
2149 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE98 IS NULL )
2150 AND ( p_NEW_PRICING_ATTRIBUTE98 IS NULL )))
2154 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE99 = p_NEW_PRICING_ATTRIBUTE99)
2151 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE99 = p_OLD_PRICING_ATTRIBUTE99)
2152 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE99 IS NULL )
2153 AND ( p_OLD_PRICING_ATTRIBUTE99 IS NULL )))
2155 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE99 IS NULL )
2156 AND ( p_NEW_PRICING_ATTRIBUTE99 IS NULL )))
2157 AND ( ( Recinfo.OLD_PRICING_ATTRIBUTE100 = p_OLD_PRICING_ATTRIBUTE100)
2158 OR ( ( Recinfo.OLD_PRICING_ATTRIBUTE100 IS NULL )
2159 AND ( p_OLD_PRICING_ATTRIBUTE100 IS NULL )))
2160 AND ( ( Recinfo.NEW_PRICING_ATTRIBUTE100 = p_NEW_PRICING_ATTRIBUTE100)
2161 OR ( ( Recinfo.NEW_PRICING_ATTRIBUTE100 IS NULL )
2162 AND ( p_NEW_PRICING_ATTRIBUTE100 IS NULL )))
2163 AND ( ( Recinfo.OLD_ACTIVE_START_DATE = p_OLD_ACTIVE_START_DATE)
2164 OR ( ( Recinfo.OLD_ACTIVE_START_DATE IS NULL )
2165 AND ( p_OLD_ACTIVE_START_DATE IS NULL )))
2166 AND ( ( Recinfo.NEW_ACTIVE_START_DATE = p_NEW_ACTIVE_START_DATE)
2167 OR ( ( Recinfo.NEW_ACTIVE_START_DATE IS NULL )
2168 AND ( p_NEW_ACTIVE_START_DATE IS NULL )))
2169 AND ( ( Recinfo.OLD_ACTIVE_END_DATE = p_OLD_ACTIVE_END_DATE)
2170 OR ( ( Recinfo.OLD_ACTIVE_END_DATE IS NULL )
2171 AND ( p_OLD_ACTIVE_END_DATE IS NULL )))
2172 AND ( ( Recinfo.NEW_ACTIVE_END_DATE = p_NEW_ACTIVE_END_DATE)
2173 OR ( ( Recinfo.NEW_ACTIVE_END_DATE IS NULL )
2174 AND ( p_NEW_ACTIVE_END_DATE IS NULL )))
2175
2176 AND ( ( Recinfo.OLD_CONTEXT = p_OLD_CONTEXT)
2177 OR ( ( Recinfo.OLD_CONTEXT IS NULL )
2178 AND ( p_OLD_CONTEXT IS NULL )))
2179 AND ( ( Recinfo.NEW_CONTEXT = p_NEW_CONTEXT)
2180 OR ( ( Recinfo.NEW_CONTEXT IS NULL )
2181 AND ( p_NEW_CONTEXT IS NULL )))
2182
2183 AND ( ( Recinfo.OLD_ATTRIBUTE1 = p_OLD_ATTRIBUTE1)
2184 OR ( ( Recinfo.OLD_ATTRIBUTE1 IS NULL )
2185 AND ( p_OLD_ATTRIBUTE1 IS NULL )))
2186 AND ( ( Recinfo.NEW_ATTRIBUTE1 = p_NEW_ATTRIBUTE1)
2187 OR ( ( Recinfo.NEW_ATTRIBUTE1 IS NULL )
2188 AND ( p_NEW_ATTRIBUTE1 IS NULL )))
2189
2190 AND ( ( Recinfo.OLD_ATTRIBUTE2 = p_OLD_ATTRIBUTE2)
2191 OR ( ( Recinfo.OLD_ATTRIBUTE2 IS NULL )
2192 AND ( p_OLD_ATTRIBUTE2 IS NULL )))
2193 AND ( ( Recinfo.NEW_ATTRIBUTE2 = p_NEW_ATTRIBUTE2)
2194 OR ( ( Recinfo.NEW_ATTRIBUTE2 IS NULL )
2195 AND ( p_NEW_ATTRIBUTE2 IS NULL )))
2196
2197 AND ( ( Recinfo.OLD_ATTRIBUTE3 = p_OLD_ATTRIBUTE3)
2198 OR ( ( Recinfo.OLD_ATTRIBUTE3 IS NULL )
2199 AND ( p_OLD_ATTRIBUTE3 IS NULL )))
2200 AND ( ( Recinfo.NEW_ATTRIBUTE3 = p_NEW_ATTRIBUTE3)
2201 OR ( ( Recinfo.NEW_ATTRIBUTE3 IS NULL )
2202 AND ( p_NEW_ATTRIBUTE3 IS NULL )))
2203
2204 AND ( ( Recinfo.OLD_ATTRIBUTE4 = p_OLD_ATTRIBUTE4)
2205 OR ( ( Recinfo.OLD_ATTRIBUTE4 IS NULL )
2206 AND ( p_OLD_ATTRIBUTE4 IS NULL )))
2207 AND ( ( Recinfo.NEW_ATTRIBUTE4 = p_NEW_ATTRIBUTE4)
2208 OR ( ( Recinfo.NEW_ATTRIBUTE4 IS NULL )
2209 AND ( p_NEW_ATTRIBUTE4 IS NULL )))
2210
2211 AND ( ( Recinfo.OLD_ATTRIBUTE5 = p_OLD_ATTRIBUTE5)
2212 OR ( ( Recinfo.OLD_ATTRIBUTE5 IS NULL )
2213 AND ( p_OLD_ATTRIBUTE5 IS NULL )))
2214 AND ( ( Recinfo.NEW_ATTRIBUTE5 = p_NEW_ATTRIBUTE5)
2215 OR ( ( Recinfo.NEW_ATTRIBUTE5 IS NULL )
2216 AND ( p_NEW_ATTRIBUTE5 IS NULL )))
2217
2218 AND ( ( Recinfo.OLD_ATTRIBUTE6 = p_OLD_ATTRIBUTE6)
2219 OR ( ( Recinfo.OLD_ATTRIBUTE6 IS NULL )
2220 AND ( p_OLD_ATTRIBUTE6 IS NULL )))
2221 AND ( ( Recinfo.NEW_ATTRIBUTE6 = p_NEW_ATTRIBUTE6)
2222 OR ( ( Recinfo.NEW_ATTRIBUTE6 IS NULL )
2223 AND ( p_NEW_ATTRIBUTE6 IS NULL )))
2224
2225 AND ( ( Recinfo.OLD_ATTRIBUTE7 = p_OLD_ATTRIBUTE7)
2226 OR ( ( Recinfo.OLD_ATTRIBUTE7 IS NULL )
2227 AND ( p_OLD_ATTRIBUTE7 IS NULL )))
2228 AND ( ( Recinfo.NEW_ATTRIBUTE7 = p_NEW_ATTRIBUTE7)
2229 OR ( ( Recinfo.NEW_ATTRIBUTE7 IS NULL )
2230 AND ( p_NEW_ATTRIBUTE7 IS NULL )))
2231
2232 AND ( ( Recinfo.OLD_ATTRIBUTE8 = p_OLD_ATTRIBUTE8)
2233 OR ( ( Recinfo.OLD_ATTRIBUTE8 IS NULL )
2234 AND ( p_OLD_ATTRIBUTE8 IS NULL )))
2235 AND ( ( Recinfo.NEW_ATTRIBUTE8 = p_NEW_ATTRIBUTE8)
2236 OR ( ( Recinfo.NEW_ATTRIBUTE8 IS NULL )
2237 AND ( p_NEW_ATTRIBUTE8 IS NULL )))
2238
2239 AND ( ( Recinfo.OLD_ATTRIBUTE9 = p_OLD_ATTRIBUTE9)
2240 OR ( ( Recinfo.OLD_ATTRIBUTE9 IS NULL )
2241 AND ( p_OLD_ATTRIBUTE9 IS NULL )))
2242 AND ( ( Recinfo.NEW_ATTRIBUTE9 = p_NEW_ATTRIBUTE9)
2243 OR ( ( Recinfo.NEW_ATTRIBUTE9 IS NULL )
2244 AND ( p_NEW_ATTRIBUTE9 IS NULL )))
2245
2246 AND ( ( Recinfo.OLD_ATTRIBUTE10 = p_OLD_ATTRIBUTE10)
2247 OR ( ( Recinfo.OLD_ATTRIBUTE10 IS NULL )
2248 AND ( p_OLD_ATTRIBUTE10 IS NULL )))
2249 AND ( ( Recinfo.NEW_ATTRIBUTE10 = p_NEW_ATTRIBUTE10)
2250 OR ( ( Recinfo.NEW_ATTRIBUTE10 IS NULL )
2251 AND ( p_NEW_ATTRIBUTE10 IS NULL )))
2252
2253 AND ( ( Recinfo.OLD_ATTRIBUTE11 = p_OLD_ATTRIBUTE11)
2254 OR ( ( Recinfo.OLD_ATTRIBUTE11 IS NULL )
2258 AND ( p_NEW_ATTRIBUTE12 IS NULL )))
2255 AND ( p_OLD_ATTRIBUTE11 IS NULL )))
2256 AND ( ( Recinfo.NEW_ATTRIBUTE11 = p_NEW_ATTRIBUTE11)
2257 OR ( ( Recinfo.NEW_ATTRIBUTE12 IS NULL )
2259
2260 AND ( ( Recinfo.OLD_ATTRIBUTE12 = p_OLD_ATTRIBUTE12)
2261 OR ( ( Recinfo.OLD_ATTRIBUTE12 IS NULL )
2262 AND ( p_OLD_ATTRIBUTE12 IS NULL )))
2263 AND ( ( Recinfo.NEW_ATTRIBUTE12 = p_NEW_ATTRIBUTE12)
2264 OR ( ( Recinfo.NEW_ATTRIBUTE12 IS NULL )
2265 AND ( p_NEW_ATTRIBUTE12 IS NULL )))
2266
2267 AND ( ( Recinfo.OLD_ATTRIBUTE13 = p_OLD_ATTRIBUTE13)
2268 OR ( ( Recinfo.OLD_ATTRIBUTE13 IS NULL )
2269 AND ( p_OLD_ATTRIBUTE13 IS NULL )))
2270 AND ( ( Recinfo.NEW_ATTRIBUTE13 = p_NEW_ATTRIBUTE13)
2271 OR ( ( Recinfo.NEW_ATTRIBUTE13 IS NULL )
2272 AND ( p_NEW_ATTRIBUTE13 IS NULL )))
2273
2274 AND ( ( Recinfo.OLD_ATTRIBUTE14 = p_OLD_ATTRIBUTE14)
2275 OR ( ( Recinfo.OLD_ATTRIBUTE14 IS NULL )
2276 AND ( p_OLD_ATTRIBUTE14 IS NULL )))
2277 AND ( ( Recinfo.NEW_ATTRIBUTE14 = p_NEW_ATTRIBUTE14)
2278 OR ( ( Recinfo.NEW_ATTRIBUTE14 IS NULL )
2279 AND ( p_NEW_ATTRIBUTE14 IS NULL )))
2280
2281 AND ( ( Recinfo.OLD_ATTRIBUTE15 = p_OLD_ATTRIBUTE15)
2282 OR ( ( Recinfo.OLD_ATTRIBUTE15 IS NULL )
2283 AND ( p_OLD_ATTRIBUTE15 IS NULL )))
2284 AND ( ( Recinfo.NEW_ATTRIBUTE15 = p_NEW_ATTRIBUTE15)
2285 OR ( ( Recinfo.NEW_ATTRIBUTE15 IS NULL )
2286 AND ( p_NEW_ATTRIBUTE15 IS NULL )))
2287
2288 AND ( ( Recinfo.FULL_DUMP_FLAG = p_FULL_DUMP_FLAG )
2289 OR ( ( Recinfo.FULL_DUMP_FLAG IS NULL )
2290 AND ( p_FULL_DUMP_FLAG IS NULL )))
2291
2292 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
2293 OR ( ( Recinfo.CREATED_BY IS NULL )
2294 AND ( p_CREATED_BY IS NULL )))
2295 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
2296 OR ( ( Recinfo.CREATION_DATE IS NULL )
2297 AND ( p_CREATION_DATE IS NULL )))
2298 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
2299 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
2300 AND ( p_LAST_UPDATED_BY IS NULL )))
2301 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
2302 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
2303 AND ( p_LAST_UPDATE_DATE IS NULL )))
2304 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
2305 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
2306 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
2307 AND ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
2308 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
2309 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
2310 ) then
2311 return;
2312 else
2313 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
2314 APP_EXCEPTION.RAISE_EXCEPTION;
2315 End If;
2316 NULL;
2317 END Lock_Row;
2318
2319 End CSI_I_PRICING_ATTRIBS_H_PKG;