[Home] [Help]
PACKAGE BODY: APPS.OKC_SPLIT1_PAV_PVT
Source
1 PACKAGE BODY OKC_SPLIT1_PAV_PVT AS
2 /* $Header: OKCSPAVSPOB.pls 120.0 2010/06/22 10:09:31 nvvaidya noship $ */
3 ---------------------------------------------------------------------------
4 -- FUNCTION get_rec for: OKC_PRICE_ATT_VALUES
5 ---------------------------------------------------------------------------
6 FUNCTION get_rec (
7 p_pav_rec IN OKC_PAV_PVT.pav_rec_type,
8 x_no_data_found OUT NOCOPY BOOLEAN
9 ) RETURN OKC_PAV_PVT.pav_rec_type IS
10 CURSOR pav_pk_csr (p_id IN NUMBER) IS
11 SELECT
12 ID,
13 FLEX_TITLE,
14 PRICING_CONTEXT,
15 PRICING_ATTRIBUTE1,
16 CHR_ID,
17 PRICING_ATTRIBUTE2,
18 CLE_ID,
19 PRICING_ATTRIBUTE3,
20 PRICING_ATTRIBUTE4,
21 PRICING_ATTRIBUTE5,
22 PRICING_ATTRIBUTE6,
23 PRICING_ATTRIBUTE7,
24 PRICING_ATTRIBUTE8,
25 PRICING_ATTRIBUTE9,
26 PRICING_ATTRIBUTE10,
27 PRICING_ATTRIBUTE11,
28 PRICING_ATTRIBUTE12,
29 PRICING_ATTRIBUTE13,
30 PRICING_ATTRIBUTE14,
31 PRICING_ATTRIBUTE15,
32 PRICING_ATTRIBUTE16,
33 PRICING_ATTRIBUTE17,
34 PRICING_ATTRIBUTE18,
35 PRICING_ATTRIBUTE19,
36 PRICING_ATTRIBUTE20,
37 PRICING_ATTRIBUTE21,
38 PRICING_ATTRIBUTE22,
39 PRICING_ATTRIBUTE23,
40 PRICING_ATTRIBUTE24,
41 PRICING_ATTRIBUTE25,
42 PRICING_ATTRIBUTE26,
43 PRICING_ATTRIBUTE27,
44 PRICING_ATTRIBUTE28,
45 PRICING_ATTRIBUTE29,
46 PRICING_ATTRIBUTE30,
47 PRICING_ATTRIBUTE31,
48 PRICING_ATTRIBUTE32,
49 PRICING_ATTRIBUTE33,
50 PRICING_ATTRIBUTE34,
51 PRICING_ATTRIBUTE35,
52 PRICING_ATTRIBUTE36,
53 PRICING_ATTRIBUTE37,
54 PRICING_ATTRIBUTE38,
55 PRICING_ATTRIBUTE39,
56 PRICING_ATTRIBUTE40,
57 PRICING_ATTRIBUTE41,
58 PRICING_ATTRIBUTE42,
59 PRICING_ATTRIBUTE43,
60 PRICING_ATTRIBUTE44,
61 PRICING_ATTRIBUTE45,
62 PRICING_ATTRIBUTE46,
63 PRICING_ATTRIBUTE47,
64 PRICING_ATTRIBUTE48,
65 PRICING_ATTRIBUTE49,
66 PRICING_ATTRIBUTE50,
67 PRICING_ATTRIBUTE51,
68 PRICING_ATTRIBUTE52,
69 PRICING_ATTRIBUTE53,
70 PRICING_ATTRIBUTE54,
71 PRICING_ATTRIBUTE55,
72 PRICING_ATTRIBUTE56,
73 PRICING_ATTRIBUTE57,
74 PRICING_ATTRIBUTE58,
75 PRICING_ATTRIBUTE59,
76 PRICING_ATTRIBUTE60,
77 PRICING_ATTRIBUTE61,
78 PRICING_ATTRIBUTE62,
79 PRICING_ATTRIBUTE63,
80 PRICING_ATTRIBUTE64,
81 PRICING_ATTRIBUTE65,
82 PRICING_ATTRIBUTE66,
83 PRICING_ATTRIBUTE67,
84 PRICING_ATTRIBUTE68,
85 PRICING_ATTRIBUTE69,
86 PRICING_ATTRIBUTE70,
87 PRICING_ATTRIBUTE71,
88 PRICING_ATTRIBUTE72,
89 PRICING_ATTRIBUTE73,
90 PRICING_ATTRIBUTE74,
91 PRICING_ATTRIBUTE75,
92 PRICING_ATTRIBUTE76,
93 PRICING_ATTRIBUTE77,
94 PRICING_ATTRIBUTE78,
95 PRICING_ATTRIBUTE79,
96 PRICING_ATTRIBUTE80,
97 PRICING_ATTRIBUTE81,
98 PRICING_ATTRIBUTE82,
99 PRICING_ATTRIBUTE83,
100 PRICING_ATTRIBUTE84,
101 PRICING_ATTRIBUTE85,
102 PRICING_ATTRIBUTE86,
103 PRICING_ATTRIBUTE87,
104 PRICING_ATTRIBUTE88,
105 PRICING_ATTRIBUTE89,
106 PRICING_ATTRIBUTE90,
107 PRICING_ATTRIBUTE91,
108 PRICING_ATTRIBUTE92,
109 PRICING_ATTRIBUTE93,
110 PRICING_ATTRIBUTE94,
111 PRICING_ATTRIBUTE95,
112 PRICING_ATTRIBUTE96,
113 PRICING_ATTRIBUTE97,
114 PRICING_ATTRIBUTE98,
115 PRICING_ATTRIBUTE99,
116 PRICING_ATTRIBUTE100,
117 QUALIFIER_CONTEXT,
118 QUALIFIER_ATTRIBUTE1,
119 QUALIFIER_ATTRIBUTE2,
120 CREATED_BY,
121 QUALIFIER_ATTRIBUTE3,
122 CREATION_DATE,
123 QUALIFIER_ATTRIBUTE4,
124 QUALIFIER_ATTRIBUTE5,
125 LAST_UPDATED_BY,
126 QUALIFIER_ATTRIBUTE6,
127 LAST_UPDATE_DATE,
128 QUALIFIER_ATTRIBUTE7,
129 QUALIFIER_ATTRIBUTE8,
130 QUALIFIER_ATTRIBUTE9,
131 QUALIFIER_ATTRIBUTE10,
132 QUALIFIER_ATTRIBUTE11,
133 QUALIFIER_ATTRIBUTE12,
134 QUALIFIER_ATTRIBUTE13,
135 QUALIFIER_ATTRIBUTE14,
136 QUALIFIER_ATTRIBUTE15,
137 QUALIFIER_ATTRIBUTE16,
138 QUALIFIER_ATTRIBUTE17,
139 QUALIFIER_ATTRIBUTE18,
140 QUALIFIER_ATTRIBUTE19,
141 QUALIFIER_ATTRIBUTE20,
142 QUALIFIER_ATTRIBUTE21,
143 QUALIFIER_ATTRIBUTE22,
144 QUALIFIER_ATTRIBUTE23,
145 QUALIFIER_ATTRIBUTE24,
146 QUALIFIER_ATTRIBUTE25,
147 QUALIFIER_ATTRIBUTE26,
148 QUALIFIER_ATTRIBUTE27,
149 QUALIFIER_ATTRIBUTE28,
150 QUALIFIER_ATTRIBUTE29,
151 QUALIFIER_ATTRIBUTE30,
152 QUALIFIER_ATTRIBUTE31,
153 QUALIFIER_ATTRIBUTE32,
154 QUALIFIER_ATTRIBUTE33,
155 QUALIFIER_ATTRIBUTE34,
156 QUALIFIER_ATTRIBUTE35,
157 QUALIFIER_ATTRIBUTE36,
158 QUALIFIER_ATTRIBUTE37,
159 QUALIFIER_ATTRIBUTE38,
160 QUALIFIER_ATTRIBUTE39,
161 QUALIFIER_ATTRIBUTE40,
162 QUALIFIER_ATTRIBUTE41,
163 QUALIFIER_ATTRIBUTE42,
164 QUALIFIER_ATTRIBUTE43,
165 QUALIFIER_ATTRIBUTE44,
166 QUALIFIER_ATTRIBUTE45,
167 QUALIFIER_ATTRIBUTE46,
168 QUALIFIER_ATTRIBUTE47,
169 QUALIFIER_ATTRIBUTE48,
170 QUALIFIER_ATTRIBUTE49,
171 QUALIFIER_ATTRIBUTE50,
172 QUALIFIER_ATTRIBUTE51,
173 QUALIFIER_ATTRIBUTE52,
174 QUALIFIER_ATTRIBUTE53,
175 QUALIFIER_ATTRIBUTE54,
176 QUALIFIER_ATTRIBUTE55,
177 QUALIFIER_ATTRIBUTE56,
178 QUALIFIER_ATTRIBUTE57,
179 QUALIFIER_ATTRIBUTE58,
180 QUALIFIER_ATTRIBUTE59,
181 QUALIFIER_ATTRIBUTE60,
182 QUALIFIER_ATTRIBUTE61,
183 QUALIFIER_ATTRIBUTE62,
184 QUALIFIER_ATTRIBUTE63,
185 QUALIFIER_ATTRIBUTE64,
186 QUALIFIER_ATTRIBUTE65,
187 QUALIFIER_ATTRIBUTE66,
188 QUALIFIER_ATTRIBUTE67,
189 QUALIFIER_ATTRIBUTE68,
190 QUALIFIER_ATTRIBUTE69,
191 QUALIFIER_ATTRIBUTE70,
192 QUALIFIER_ATTRIBUTE71,
193 QUALIFIER_ATTRIBUTE72,
194 QUALIFIER_ATTRIBUTE73,
195 QUALIFIER_ATTRIBUTE74,
196 QUALIFIER_ATTRIBUTE75,
197 QUALIFIER_ATTRIBUTE76,
198 QUALIFIER_ATTRIBUTE77,
199 QUALIFIER_ATTRIBUTE78,
200 QUALIFIER_ATTRIBUTE79,
201 QUALIFIER_ATTRIBUTE80,
202 QUALIFIER_ATTRIBUTE81,
203 QUALIFIER_ATTRIBUTE82,
204 QUALIFIER_ATTRIBUTE83,
205 QUALIFIER_ATTRIBUTE84,
206 QUALIFIER_ATTRIBUTE85,
207 QUALIFIER_ATTRIBUTE86,
208 QUALIFIER_ATTRIBUTE87,
209 QUALIFIER_ATTRIBUTE88,
210 QUALIFIER_ATTRIBUTE89,
211 QUALIFIER_ATTRIBUTE90,
212 QUALIFIER_ATTRIBUTE91,
213 QUALIFIER_ATTRIBUTE92,
214 QUALIFIER_ATTRIBUTE93,
215 QUALIFIER_ATTRIBUTE94,
216 QUALIFIER_ATTRIBUTE95,
217 QUALIFIER_ATTRIBUTE96,
218 QUALIFIER_ATTRIBUTE97,
219 QUALIFIER_ATTRIBUTE98,
220 QUALIFIER_ATTRIBUTE99,
221 QUALIFIER_ATTRIBUTE100,
222 LAST_UPDATE_LOGIN,
223 PROGRAM_APPLICATION_ID,
224 PROGRAM_ID,
225 PROGRAM_UPDATE_DATE,
226 REQUEST_ID,
227 OBJECT_VERSION_NUMBER
228 FROM Okc_Price_Att_Values
229 WHERE okc_price_att_values.id = p_id;
230 l_pav_pk pav_pk_csr%ROWTYPE;
231 l_pav_rec OKC_PAV_PVT.pav_rec_type;
232 BEGIN
233 x_no_data_found := TRUE;
234 -- Get current database values
235 OPEN pav_pk_csr (p_pav_rec.id);
236 FETCH pav_pk_csr INTO
237 l_pav_rec.ID,
238 l_pav_rec.FLEX_TITLE,
239 l_pav_rec.PRICING_CONTEXT,
240 l_pav_rec.PRICING_ATTRIBUTE1,
241 l_pav_rec.CHR_ID,
242 l_pav_rec.PRICING_ATTRIBUTE2,
243 l_pav_rec.CLE_ID,
244 l_pav_rec.PRICING_ATTRIBUTE3,
245 l_pav_rec.PRICING_ATTRIBUTE4,
246 l_pav_rec.PRICING_ATTRIBUTE5,
247 l_pav_rec.PRICING_ATTRIBUTE6,
248 l_pav_rec.PRICING_ATTRIBUTE7,
249 l_pav_rec.PRICING_ATTRIBUTE8,
250 l_pav_rec.PRICING_ATTRIBUTE9,
251 l_pav_rec.PRICING_ATTRIBUTE10,
252 l_pav_rec.PRICING_ATTRIBUTE11,
253 l_pav_rec.PRICING_ATTRIBUTE12,
254 l_pav_rec.PRICING_ATTRIBUTE13,
255 l_pav_rec.PRICING_ATTRIBUTE14,
256 l_pav_rec.PRICING_ATTRIBUTE15,
257 l_pav_rec.PRICING_ATTRIBUTE16,
258 l_pav_rec.PRICING_ATTRIBUTE17,
259 l_pav_rec.PRICING_ATTRIBUTE18,
260 l_pav_rec.PRICING_ATTRIBUTE19,
261 l_pav_rec.PRICING_ATTRIBUTE20,
262 l_pav_rec.PRICING_ATTRIBUTE21,
263 l_pav_rec.PRICING_ATTRIBUTE22,
264 l_pav_rec.PRICING_ATTRIBUTE23,
265 l_pav_rec.PRICING_ATTRIBUTE24,
266 l_pav_rec.PRICING_ATTRIBUTE25,
267 l_pav_rec.PRICING_ATTRIBUTE26,
268 l_pav_rec.PRICING_ATTRIBUTE27,
269 l_pav_rec.PRICING_ATTRIBUTE28,
270 l_pav_rec.PRICING_ATTRIBUTE29,
271 l_pav_rec.PRICING_ATTRIBUTE30,
272 l_pav_rec.PRICING_ATTRIBUTE31,
273 l_pav_rec.PRICING_ATTRIBUTE32,
274 l_pav_rec.PRICING_ATTRIBUTE33,
275 l_pav_rec.PRICING_ATTRIBUTE34,
276 l_pav_rec.PRICING_ATTRIBUTE35,
277 l_pav_rec.PRICING_ATTRIBUTE36,
278 l_pav_rec.PRICING_ATTRIBUTE37,
279 l_pav_rec.PRICING_ATTRIBUTE38,
280 l_pav_rec.PRICING_ATTRIBUTE39,
281 l_pav_rec.PRICING_ATTRIBUTE40,
282 l_pav_rec.PRICING_ATTRIBUTE41,
283 l_pav_rec.PRICING_ATTRIBUTE42,
284 l_pav_rec.PRICING_ATTRIBUTE43,
285 l_pav_rec.PRICING_ATTRIBUTE44,
286 l_pav_rec.PRICING_ATTRIBUTE45,
287 l_pav_rec.PRICING_ATTRIBUTE46,
288 l_pav_rec.PRICING_ATTRIBUTE47,
289 l_pav_rec.PRICING_ATTRIBUTE48,
290 l_pav_rec.PRICING_ATTRIBUTE49,
291 l_pav_rec.PRICING_ATTRIBUTE50,
292 l_pav_rec.PRICING_ATTRIBUTE51,
293 l_pav_rec.PRICING_ATTRIBUTE52,
294 l_pav_rec.PRICING_ATTRIBUTE53,
295 l_pav_rec.PRICING_ATTRIBUTE54,
296 l_pav_rec.PRICING_ATTRIBUTE55,
297 l_pav_rec.PRICING_ATTRIBUTE56,
298 l_pav_rec.PRICING_ATTRIBUTE57,
299 l_pav_rec.PRICING_ATTRIBUTE58,
300 l_pav_rec.PRICING_ATTRIBUTE59,
301 l_pav_rec.PRICING_ATTRIBUTE60,
302 l_pav_rec.PRICING_ATTRIBUTE61,
303 l_pav_rec.PRICING_ATTRIBUTE62,
304 l_pav_rec.PRICING_ATTRIBUTE63,
305 l_pav_rec.PRICING_ATTRIBUTE64,
306 l_pav_rec.PRICING_ATTRIBUTE65,
307 l_pav_rec.PRICING_ATTRIBUTE66,
308 l_pav_rec.PRICING_ATTRIBUTE67,
309 l_pav_rec.PRICING_ATTRIBUTE68,
310 l_pav_rec.PRICING_ATTRIBUTE69,
311 l_pav_rec.PRICING_ATTRIBUTE70,
312 l_pav_rec.PRICING_ATTRIBUTE71,
313 l_pav_rec.PRICING_ATTRIBUTE72,
314 l_pav_rec.PRICING_ATTRIBUTE73,
315 l_pav_rec.PRICING_ATTRIBUTE74,
316 l_pav_rec.PRICING_ATTRIBUTE75,
317 l_pav_rec.PRICING_ATTRIBUTE76,
318 l_pav_rec.PRICING_ATTRIBUTE77,
319 l_pav_rec.PRICING_ATTRIBUTE78,
320 l_pav_rec.PRICING_ATTRIBUTE79,
321 l_pav_rec.PRICING_ATTRIBUTE80,
322 l_pav_rec.PRICING_ATTRIBUTE81,
323 l_pav_rec.PRICING_ATTRIBUTE82,
324 l_pav_rec.PRICING_ATTRIBUTE83,
325 l_pav_rec.PRICING_ATTRIBUTE84,
326 l_pav_rec.PRICING_ATTRIBUTE85,
327 l_pav_rec.PRICING_ATTRIBUTE86,
328 l_pav_rec.PRICING_ATTRIBUTE87,
329 l_pav_rec.PRICING_ATTRIBUTE88,
330 l_pav_rec.PRICING_ATTRIBUTE89,
331 l_pav_rec.PRICING_ATTRIBUTE90,
332 l_pav_rec.PRICING_ATTRIBUTE91,
333 l_pav_rec.PRICING_ATTRIBUTE92,
334 l_pav_rec.PRICING_ATTRIBUTE93,
335 l_pav_rec.PRICING_ATTRIBUTE94,
336 l_pav_rec.PRICING_ATTRIBUTE95,
337 l_pav_rec.PRICING_ATTRIBUTE96,
338 l_pav_rec.PRICING_ATTRIBUTE97,
339 l_pav_rec.PRICING_ATTRIBUTE98,
340 l_pav_rec.PRICING_ATTRIBUTE99,
341 l_pav_rec.PRICING_ATTRIBUTE100,
342 l_pav_rec.QUALIFIER_CONTEXT,
343 l_pav_rec.QUALIFIER_ATTRIBUTE1,
344 l_pav_rec.QUALIFIER_ATTRIBUTE2,
345 l_pav_rec.CREATED_BY,
346 l_pav_rec.QUALIFIER_ATTRIBUTE3,
347 l_pav_rec.CREATION_DATE,
348 l_pav_rec.QUALIFIER_ATTRIBUTE4,
349 l_pav_rec.QUALIFIER_ATTRIBUTE5,
350 l_pav_rec.LAST_UPDATED_BY,
351 l_pav_rec.QUALIFIER_ATTRIBUTE6,
352 l_pav_rec.LAST_UPDATE_DATE,
353 l_pav_rec.QUALIFIER_ATTRIBUTE7,
354 l_pav_rec.QUALIFIER_ATTRIBUTE8,
355 l_pav_rec.QUALIFIER_ATTRIBUTE9,
356 l_pav_rec.QUALIFIER_ATTRIBUTE10,
357 l_pav_rec.QUALIFIER_ATTRIBUTE11,
358 l_pav_rec.QUALIFIER_ATTRIBUTE12,
359 l_pav_rec.QUALIFIER_ATTRIBUTE13,
360 l_pav_rec.QUALIFIER_ATTRIBUTE14,
361 l_pav_rec.QUALIFIER_ATTRIBUTE15,
362 l_pav_rec.QUALIFIER_ATTRIBUTE16,
363 l_pav_rec.QUALIFIER_ATTRIBUTE17,
364 l_pav_rec.QUALIFIER_ATTRIBUTE18,
365 l_pav_rec.QUALIFIER_ATTRIBUTE19,
366 l_pav_rec.QUALIFIER_ATTRIBUTE20,
367 l_pav_rec.QUALIFIER_ATTRIBUTE21,
368 l_pav_rec.QUALIFIER_ATTRIBUTE22,
369 l_pav_rec.QUALIFIER_ATTRIBUTE23,
370 l_pav_rec.QUALIFIER_ATTRIBUTE24,
371 l_pav_rec.QUALIFIER_ATTRIBUTE25,
372 l_pav_rec.QUALIFIER_ATTRIBUTE26,
373 l_pav_rec.QUALIFIER_ATTRIBUTE27,
374 l_pav_rec.QUALIFIER_ATTRIBUTE28,
375 l_pav_rec.QUALIFIER_ATTRIBUTE29,
376 l_pav_rec.QUALIFIER_ATTRIBUTE30,
377 l_pav_rec.QUALIFIER_ATTRIBUTE31,
378 l_pav_rec.QUALIFIER_ATTRIBUTE32,
379 l_pav_rec.QUALIFIER_ATTRIBUTE33,
380 l_pav_rec.QUALIFIER_ATTRIBUTE34,
381 l_pav_rec.QUALIFIER_ATTRIBUTE35,
382 l_pav_rec.QUALIFIER_ATTRIBUTE36,
383 l_pav_rec.QUALIFIER_ATTRIBUTE37,
384 l_pav_rec.QUALIFIER_ATTRIBUTE38,
385 l_pav_rec.QUALIFIER_ATTRIBUTE39,
386 l_pav_rec.QUALIFIER_ATTRIBUTE40,
387 l_pav_rec.QUALIFIER_ATTRIBUTE41,
388 l_pav_rec.QUALIFIER_ATTRIBUTE42,
389 l_pav_rec.QUALIFIER_ATTRIBUTE43,
390 l_pav_rec.QUALIFIER_ATTRIBUTE44,
391 l_pav_rec.QUALIFIER_ATTRIBUTE45,
392 l_pav_rec.QUALIFIER_ATTRIBUTE46,
393 l_pav_rec.QUALIFIER_ATTRIBUTE47,
394 l_pav_rec.QUALIFIER_ATTRIBUTE48,
395 l_pav_rec.QUALIFIER_ATTRIBUTE49,
396 l_pav_rec.QUALIFIER_ATTRIBUTE50,
397 l_pav_rec.QUALIFIER_ATTRIBUTE51,
398 l_pav_rec.QUALIFIER_ATTRIBUTE52,
399 l_pav_rec.QUALIFIER_ATTRIBUTE53,
400 l_pav_rec.QUALIFIER_ATTRIBUTE54,
401 l_pav_rec.QUALIFIER_ATTRIBUTE55,
402 l_pav_rec.QUALIFIER_ATTRIBUTE56,
403 l_pav_rec.QUALIFIER_ATTRIBUTE57,
404 l_pav_rec.QUALIFIER_ATTRIBUTE58,
405 l_pav_rec.QUALIFIER_ATTRIBUTE59,
406 l_pav_rec.QUALIFIER_ATTRIBUTE60,
407 l_pav_rec.QUALIFIER_ATTRIBUTE61,
408 l_pav_rec.QUALIFIER_ATTRIBUTE62,
409 l_pav_rec.QUALIFIER_ATTRIBUTE63,
410 l_pav_rec.QUALIFIER_ATTRIBUTE64,
411 l_pav_rec.QUALIFIER_ATTRIBUTE65,
412 l_pav_rec.QUALIFIER_ATTRIBUTE66,
413 l_pav_rec.QUALIFIER_ATTRIBUTE67,
414 l_pav_rec.QUALIFIER_ATTRIBUTE68,
415 l_pav_rec.QUALIFIER_ATTRIBUTE69,
416 l_pav_rec.QUALIFIER_ATTRIBUTE70,
417 l_pav_rec.QUALIFIER_ATTRIBUTE71,
418 l_pav_rec.QUALIFIER_ATTRIBUTE72,
419 l_pav_rec.QUALIFIER_ATTRIBUTE73,
420 l_pav_rec.QUALIFIER_ATTRIBUTE74,
421 l_pav_rec.QUALIFIER_ATTRIBUTE75,
422 l_pav_rec.QUALIFIER_ATTRIBUTE76,
423 l_pav_rec.QUALIFIER_ATTRIBUTE77,
424 l_pav_rec.QUALIFIER_ATTRIBUTE78,
425 l_pav_rec.QUALIFIER_ATTRIBUTE79,
426 l_pav_rec.QUALIFIER_ATTRIBUTE80,
427 l_pav_rec.QUALIFIER_ATTRIBUTE81,
428 l_pav_rec.QUALIFIER_ATTRIBUTE82,
429 l_pav_rec.QUALIFIER_ATTRIBUTE83,
430 l_pav_rec.QUALIFIER_ATTRIBUTE84,
431 l_pav_rec.QUALIFIER_ATTRIBUTE85,
432 l_pav_rec.QUALIFIER_ATTRIBUTE86,
433 l_pav_rec.QUALIFIER_ATTRIBUTE87,
434 l_pav_rec.QUALIFIER_ATTRIBUTE88,
435 l_pav_rec.QUALIFIER_ATTRIBUTE89,
436 l_pav_rec.QUALIFIER_ATTRIBUTE90,
437 l_pav_rec.QUALIFIER_ATTRIBUTE91,
438 l_pav_rec.QUALIFIER_ATTRIBUTE92,
439 l_pav_rec.QUALIFIER_ATTRIBUTE93,
440 l_pav_rec.QUALIFIER_ATTRIBUTE94,
441 l_pav_rec.QUALIFIER_ATTRIBUTE95,
442 l_pav_rec.QUALIFIER_ATTRIBUTE96,
443 l_pav_rec.QUALIFIER_ATTRIBUTE97,
444 l_pav_rec.QUALIFIER_ATTRIBUTE98,
445 l_pav_rec.QUALIFIER_ATTRIBUTE99,
446 l_pav_rec.QUALIFIER_ATTRIBUTE100,
447 l_pav_rec.LAST_UPDATE_LOGIN,
448 l_pav_rec.PROGRAM_APPLICATION_ID,
449 l_pav_rec.PROGRAM_ID,
450 l_pav_rec.PROGRAM_UPDATE_DATE,
451 l_pav_rec.REQUEST_ID,
452 l_pav_rec.OBJECT_VERSION_NUMBER;
453 x_no_data_found := pav_pk_csr%NOTFOUND;
454 CLOSE pav_pk_csr;
455 RETURN(l_pav_rec);
456 END get_rec;
457 ---------------------------------------------------------------------------
458 -- FUNCTION get_rec for: OKC_PRICE_ATT_VALUES_V
459 ---------------------------------------------------------------------------
460 FUNCTION get_rec (
461 p_pavv_rec IN OKC_PAV_PVT.pavv_rec_type,
462 x_no_data_found OUT NOCOPY BOOLEAN
463 ) RETURN OKC_PAV_PVT.pavv_rec_type IS
464 CURSOR okc_pavv_pk_csr (p_id IN NUMBER) IS
465 SELECT
466 ID,
467 CHR_ID,
468 CLE_ID,
469 FLEX_TITLE,
470 PRICING_CONTEXT,
471 PRICING_ATTRIBUTE1,
472 PRICING_ATTRIBUTE2,
473 PRICING_ATTRIBUTE3,
474 PRICING_ATTRIBUTE4,
475 PRICING_ATTRIBUTE5,
476 PRICING_ATTRIBUTE6,
477 PRICING_ATTRIBUTE7,
478 PRICING_ATTRIBUTE8,
479 PRICING_ATTRIBUTE9,
480 PRICING_ATTRIBUTE10,
481 PRICING_ATTRIBUTE11,
482 PRICING_ATTRIBUTE12,
483 PRICING_ATTRIBUTE13,
484 PRICING_ATTRIBUTE14,
485 PRICING_ATTRIBUTE15,
486 PRICING_ATTRIBUTE16,
487 PRICING_ATTRIBUTE17,
488 PRICING_ATTRIBUTE18,
489 PRICING_ATTRIBUTE19,
490 PRICING_ATTRIBUTE20,
491 PRICING_ATTRIBUTE21,
492 PRICING_ATTRIBUTE22,
493 PRICING_ATTRIBUTE23,
494 PRICING_ATTRIBUTE24,
495 PRICING_ATTRIBUTE25,
496 PRICING_ATTRIBUTE26,
497 PRICING_ATTRIBUTE27,
498 PRICING_ATTRIBUTE28,
499 PRICING_ATTRIBUTE29,
500 PRICING_ATTRIBUTE30,
501 PRICING_ATTRIBUTE31,
502 PRICING_ATTRIBUTE32,
503 PRICING_ATTRIBUTE33,
504 PRICING_ATTRIBUTE34,
505 PRICING_ATTRIBUTE35,
506 PRICING_ATTRIBUTE36,
507 PRICING_ATTRIBUTE37,
508 PRICING_ATTRIBUTE38,
509 PRICING_ATTRIBUTE39,
510 PRICING_ATTRIBUTE40,
511 PRICING_ATTRIBUTE41,
512 PRICING_ATTRIBUTE42,
513 PRICING_ATTRIBUTE43,
514 PRICING_ATTRIBUTE44,
515 PRICING_ATTRIBUTE45,
516 PRICING_ATTRIBUTE46,
517 PRICING_ATTRIBUTE47,
518 PRICING_ATTRIBUTE48,
519 PRICING_ATTRIBUTE49,
520 PRICING_ATTRIBUTE50,
521 PRICING_ATTRIBUTE51,
522 PRICING_ATTRIBUTE52,
523 PRICING_ATTRIBUTE53,
524 PRICING_ATTRIBUTE54,
525 PRICING_ATTRIBUTE55,
526 PRICING_ATTRIBUTE56,
527 PRICING_ATTRIBUTE57,
528 PRICING_ATTRIBUTE58,
529 PRICING_ATTRIBUTE59,
530 PRICING_ATTRIBUTE60,
531 PRICING_ATTRIBUTE61,
532 PRICING_ATTRIBUTE62,
533 PRICING_ATTRIBUTE63,
534 PRICING_ATTRIBUTE64,
535 PRICING_ATTRIBUTE65,
536 PRICING_ATTRIBUTE66,
537 PRICING_ATTRIBUTE67,
538 PRICING_ATTRIBUTE68,
539 PRICING_ATTRIBUTE69,
540 PRICING_ATTRIBUTE70,
541 PRICING_ATTRIBUTE71,
542 PRICING_ATTRIBUTE72,
543 PRICING_ATTRIBUTE73,
544 PRICING_ATTRIBUTE74,
545 PRICING_ATTRIBUTE75,
546 PRICING_ATTRIBUTE76,
547 PRICING_ATTRIBUTE77,
548 PRICING_ATTRIBUTE78,
549 PRICING_ATTRIBUTE79,
550 PRICING_ATTRIBUTE80,
551 PRICING_ATTRIBUTE81,
552 PRICING_ATTRIBUTE82,
553 PRICING_ATTRIBUTE83,
554 PRICING_ATTRIBUTE84,
555 PRICING_ATTRIBUTE85,
556 PRICING_ATTRIBUTE86,
557 PRICING_ATTRIBUTE87,
558 PRICING_ATTRIBUTE88,
559 PRICING_ATTRIBUTE89,
560 PRICING_ATTRIBUTE90,
561 PRICING_ATTRIBUTE91,
562 PRICING_ATTRIBUTE92,
563 PRICING_ATTRIBUTE93,
564 PRICING_ATTRIBUTE94,
565 PRICING_ATTRIBUTE95,
566 PRICING_ATTRIBUTE96,
567 PRICING_ATTRIBUTE97,
568 PRICING_ATTRIBUTE98,
569 PRICING_ATTRIBUTE99,
570 PRICING_ATTRIBUTE100,
571 QUALIFIER_CONTEXT,
572 QUALIFIER_ATTRIBUTE1,
573 QUALIFIER_ATTRIBUTE2,
574 QUALIFIER_ATTRIBUTE3,
575 QUALIFIER_ATTRIBUTE4,
576 QUALIFIER_ATTRIBUTE5,
577 QUALIFIER_ATTRIBUTE6,
578 QUALIFIER_ATTRIBUTE7,
579 QUALIFIER_ATTRIBUTE8,
580 QUALIFIER_ATTRIBUTE9,
581 QUALIFIER_ATTRIBUTE10,
582 QUALIFIER_ATTRIBUTE11,
583 QUALIFIER_ATTRIBUTE12,
584 QUALIFIER_ATTRIBUTE13,
585 QUALIFIER_ATTRIBUTE14,
586 QUALIFIER_ATTRIBUTE15,
587 QUALIFIER_ATTRIBUTE16,
588 QUALIFIER_ATTRIBUTE17,
589 QUALIFIER_ATTRIBUTE18,
590 QUALIFIER_ATTRIBUTE19,
591 QUALIFIER_ATTRIBUTE20,
592 QUALIFIER_ATTRIBUTE21,
593 QUALIFIER_ATTRIBUTE22,
594 QUALIFIER_ATTRIBUTE23,
595 QUALIFIER_ATTRIBUTE24,
596 QUALIFIER_ATTRIBUTE25,
597 QUALIFIER_ATTRIBUTE26,
598 QUALIFIER_ATTRIBUTE27,
599 QUALIFIER_ATTRIBUTE28,
600 QUALIFIER_ATTRIBUTE29,
601 QUALIFIER_ATTRIBUTE30,
602 QUALIFIER_ATTRIBUTE31,
603 QUALIFIER_ATTRIBUTE32,
604 QUALIFIER_ATTRIBUTE33,
605 QUALIFIER_ATTRIBUTE34,
606 QUALIFIER_ATTRIBUTE35,
607 QUALIFIER_ATTRIBUTE36,
608 QUALIFIER_ATTRIBUTE37,
609 QUALIFIER_ATTRIBUTE38,
610 QUALIFIER_ATTRIBUTE39,
611 QUALIFIER_ATTRIBUTE40,
612 QUALIFIER_ATTRIBUTE41,
613 QUALIFIER_ATTRIBUTE42,
614 QUALIFIER_ATTRIBUTE43,
615 QUALIFIER_ATTRIBUTE44,
616 QUALIFIER_ATTRIBUTE45,
617 QUALIFIER_ATTRIBUTE46,
618 QUALIFIER_ATTRIBUTE47,
619 QUALIFIER_ATTRIBUTE48,
620 QUALIFIER_ATTRIBUTE49,
621 QUALIFIER_ATTRIBUTE50,
622 QUALIFIER_ATTRIBUTE51,
623 QUALIFIER_ATTRIBUTE52,
624 QUALIFIER_ATTRIBUTE53,
625 QUALIFIER_ATTRIBUTE54,
626 QUALIFIER_ATTRIBUTE55,
627 QUALIFIER_ATTRIBUTE56,
628 QUALIFIER_ATTRIBUTE57,
629 QUALIFIER_ATTRIBUTE58,
630 QUALIFIER_ATTRIBUTE59,
631 QUALIFIER_ATTRIBUTE60,
632 QUALIFIER_ATTRIBUTE61,
633 QUALIFIER_ATTRIBUTE62,
634 QUALIFIER_ATTRIBUTE63,
635 QUALIFIER_ATTRIBUTE64,
636 QUALIFIER_ATTRIBUTE65,
637 QUALIFIER_ATTRIBUTE66,
638 QUALIFIER_ATTRIBUTE67,
639 QUALIFIER_ATTRIBUTE68,
640 QUALIFIER_ATTRIBUTE69,
641 QUALIFIER_ATTRIBUTE70,
642 QUALIFIER_ATTRIBUTE71,
643 QUALIFIER_ATTRIBUTE72,
644 QUALIFIER_ATTRIBUTE73,
645 QUALIFIER_ATTRIBUTE74,
646 QUALIFIER_ATTRIBUTE75,
647 QUALIFIER_ATTRIBUTE76,
648 QUALIFIER_ATTRIBUTE77,
649 QUALIFIER_ATTRIBUTE78,
650 QUALIFIER_ATTRIBUTE79,
651 QUALIFIER_ATTRIBUTE80,
652 QUALIFIER_ATTRIBUTE81,
653 QUALIFIER_ATTRIBUTE82,
654 QUALIFIER_ATTRIBUTE83,
655 QUALIFIER_ATTRIBUTE84,
656 QUALIFIER_ATTRIBUTE85,
657 QUALIFIER_ATTRIBUTE86,
658 QUALIFIER_ATTRIBUTE87,
659 QUALIFIER_ATTRIBUTE88,
660 QUALIFIER_ATTRIBUTE89,
661 QUALIFIER_ATTRIBUTE90,
662 QUALIFIER_ATTRIBUTE91,
663 QUALIFIER_ATTRIBUTE92,
664 QUALIFIER_ATTRIBUTE93,
665 QUALIFIER_ATTRIBUTE94,
666 QUALIFIER_ATTRIBUTE95,
667 QUALIFIER_ATTRIBUTE96,
668 QUALIFIER_ATTRIBUTE97,
669 QUALIFIER_ATTRIBUTE98,
670 QUALIFIER_ATTRIBUTE99,
671 QUALIFIER_ATTRIBUTE100,
672 CREATED_BY,
673 CREATION_DATE,
674 LAST_UPDATED_BY,
675 LAST_UPDATE_DATE,
676 LAST_UPDATE_LOGIN,
677 PROGRAM_APPLICATION_ID,
678 PROGRAM_ID,
679 PROGRAM_UPDATE_DATE,
680 REQUEST_ID,
681 OBJECT_VERSION_NUMBER
682 FROM Okc_Price_Att_Values_V
683 WHERE okc_price_att_values_v.id = p_id;
684 l_okc_pavv_pk okc_pavv_pk_csr%ROWTYPE;
685 l_pavv_rec OKC_PAV_PVT.pavv_rec_type;
686 BEGIN
687 x_no_data_found := TRUE;
688 -- Get current database values
689 OPEN okc_pavv_pk_csr (p_pavv_rec.id);
690 FETCH okc_pavv_pk_csr INTO
691 l_pavv_rec.ID,
692 l_pavv_rec.CHR_ID,
693 l_pavv_rec.CLE_ID,
694 l_pavv_rec.FLEX_TITLE,
695 l_pavv_rec.PRICING_CONTEXT,
696 l_pavv_rec.PRICING_ATTRIBUTE1,
697 l_pavv_rec.PRICING_ATTRIBUTE2,
698 l_pavv_rec.PRICING_ATTRIBUTE3,
699 l_pavv_rec.PRICING_ATTRIBUTE4,
700 l_pavv_rec.PRICING_ATTRIBUTE5,
701 l_pavv_rec.PRICING_ATTRIBUTE6,
702 l_pavv_rec.PRICING_ATTRIBUTE7,
703 l_pavv_rec.PRICING_ATTRIBUTE8,
704 l_pavv_rec.PRICING_ATTRIBUTE9,
705 l_pavv_rec.PRICING_ATTRIBUTE10,
706 l_pavv_rec.PRICING_ATTRIBUTE11,
707 l_pavv_rec.PRICING_ATTRIBUTE12,
708 l_pavv_rec.PRICING_ATTRIBUTE13,
709 l_pavv_rec.PRICING_ATTRIBUTE14,
710 l_pavv_rec.PRICING_ATTRIBUTE15,
711 l_pavv_rec.PRICING_ATTRIBUTE16,
712 l_pavv_rec.PRICING_ATTRIBUTE17,
713 l_pavv_rec.PRICING_ATTRIBUTE18,
714 l_pavv_rec.PRICING_ATTRIBUTE19,
715 l_pavv_rec.PRICING_ATTRIBUTE20,
716 l_pavv_rec.PRICING_ATTRIBUTE21,
717 l_pavv_rec.PRICING_ATTRIBUTE22,
718 l_pavv_rec.PRICING_ATTRIBUTE23,
719 l_pavv_rec.PRICING_ATTRIBUTE24,
720 l_pavv_rec.PRICING_ATTRIBUTE25,
721 l_pavv_rec.PRICING_ATTRIBUTE26,
722 l_pavv_rec.PRICING_ATTRIBUTE27,
723 l_pavv_rec.PRICING_ATTRIBUTE28,
724 l_pavv_rec.PRICING_ATTRIBUTE29,
725 l_pavv_rec.PRICING_ATTRIBUTE30,
726 l_pavv_rec.PRICING_ATTRIBUTE31,
727 l_pavv_rec.PRICING_ATTRIBUTE32,
728 l_pavv_rec.PRICING_ATTRIBUTE33,
729 l_pavv_rec.PRICING_ATTRIBUTE34,
730 l_pavv_rec.PRICING_ATTRIBUTE35,
731 l_pavv_rec.PRICING_ATTRIBUTE36,
732 l_pavv_rec.PRICING_ATTRIBUTE37,
733 l_pavv_rec.PRICING_ATTRIBUTE38,
734 l_pavv_rec.PRICING_ATTRIBUTE39,
735 l_pavv_rec.PRICING_ATTRIBUTE40,
736 l_pavv_rec.PRICING_ATTRIBUTE41,
737 l_pavv_rec.PRICING_ATTRIBUTE42,
738 l_pavv_rec.PRICING_ATTRIBUTE43,
739 l_pavv_rec.PRICING_ATTRIBUTE44,
740 l_pavv_rec.PRICING_ATTRIBUTE45,
741 l_pavv_rec.PRICING_ATTRIBUTE46,
742 l_pavv_rec.PRICING_ATTRIBUTE47,
743 l_pavv_rec.PRICING_ATTRIBUTE48,
744 l_pavv_rec.PRICING_ATTRIBUTE49,
745 l_pavv_rec.PRICING_ATTRIBUTE50,
746 l_pavv_rec.PRICING_ATTRIBUTE51,
747 l_pavv_rec.PRICING_ATTRIBUTE52,
748 l_pavv_rec.PRICING_ATTRIBUTE53,
749 l_pavv_rec.PRICING_ATTRIBUTE54,
750 l_pavv_rec.PRICING_ATTRIBUTE55,
751 l_pavv_rec.PRICING_ATTRIBUTE56,
752 l_pavv_rec.PRICING_ATTRIBUTE57,
753 l_pavv_rec.PRICING_ATTRIBUTE58,
754 l_pavv_rec.PRICING_ATTRIBUTE59,
755 l_pavv_rec.PRICING_ATTRIBUTE60,
756 l_pavv_rec.PRICING_ATTRIBUTE61,
757 l_pavv_rec.PRICING_ATTRIBUTE62,
758 l_pavv_rec.PRICING_ATTRIBUTE63,
759 l_pavv_rec.PRICING_ATTRIBUTE64,
760 l_pavv_rec.PRICING_ATTRIBUTE65,
761 l_pavv_rec.PRICING_ATTRIBUTE66,
762 l_pavv_rec.PRICING_ATTRIBUTE67,
763 l_pavv_rec.PRICING_ATTRIBUTE68,
764 l_pavv_rec.PRICING_ATTRIBUTE69,
765 l_pavv_rec.PRICING_ATTRIBUTE70,
766 l_pavv_rec.PRICING_ATTRIBUTE71,
767 l_pavv_rec.PRICING_ATTRIBUTE72,
768 l_pavv_rec.PRICING_ATTRIBUTE73,
769 l_pavv_rec.PRICING_ATTRIBUTE74,
770 l_pavv_rec.PRICING_ATTRIBUTE75,
771 l_pavv_rec.PRICING_ATTRIBUTE76,
772 l_pavv_rec.PRICING_ATTRIBUTE77,
773 l_pavv_rec.PRICING_ATTRIBUTE78,
774 l_pavv_rec.PRICING_ATTRIBUTE79,
775 l_pavv_rec.PRICING_ATTRIBUTE80,
776 l_pavv_rec.PRICING_ATTRIBUTE81,
777 l_pavv_rec.PRICING_ATTRIBUTE82,
778 l_pavv_rec.PRICING_ATTRIBUTE83,
779 l_pavv_rec.PRICING_ATTRIBUTE84,
780 l_pavv_rec.PRICING_ATTRIBUTE85,
781 l_pavv_rec.PRICING_ATTRIBUTE86,
782 l_pavv_rec.PRICING_ATTRIBUTE87,
783 l_pavv_rec.PRICING_ATTRIBUTE88,
784 l_pavv_rec.PRICING_ATTRIBUTE89,
785 l_pavv_rec.PRICING_ATTRIBUTE90,
786 l_pavv_rec.PRICING_ATTRIBUTE91,
787 l_pavv_rec.PRICING_ATTRIBUTE92,
788 l_pavv_rec.PRICING_ATTRIBUTE93,
789 l_pavv_rec.PRICING_ATTRIBUTE94,
790 l_pavv_rec.PRICING_ATTRIBUTE95,
791 l_pavv_rec.PRICING_ATTRIBUTE96,
792 l_pavv_rec.PRICING_ATTRIBUTE97,
793 l_pavv_rec.PRICING_ATTRIBUTE98,
794 l_pavv_rec.PRICING_ATTRIBUTE99,
795 l_pavv_rec.PRICING_ATTRIBUTE100,
796 l_pavv_rec.QUALIFIER_CONTEXT,
797 l_pavv_rec.QUALIFIER_ATTRIBUTE1,
798 l_pavv_rec.QUALIFIER_ATTRIBUTE2,
799 l_pavv_rec.QUALIFIER_ATTRIBUTE3,
800 l_pavv_rec.QUALIFIER_ATTRIBUTE4,
801 l_pavv_rec.QUALIFIER_ATTRIBUTE5,
802 l_pavv_rec.QUALIFIER_ATTRIBUTE6,
803 l_pavv_rec.QUALIFIER_ATTRIBUTE7,
804 l_pavv_rec.QUALIFIER_ATTRIBUTE8,
805 l_pavv_rec.QUALIFIER_ATTRIBUTE9,
806 l_pavv_rec.QUALIFIER_ATTRIBUTE10,
807 l_pavv_rec.QUALIFIER_ATTRIBUTE11,
808 l_pavv_rec.QUALIFIER_ATTRIBUTE12,
809 l_pavv_rec.QUALIFIER_ATTRIBUTE13,
810 l_pavv_rec.QUALIFIER_ATTRIBUTE14,
811 l_pavv_rec.QUALIFIER_ATTRIBUTE15,
812 l_pavv_rec.QUALIFIER_ATTRIBUTE16,
813 l_pavv_rec.QUALIFIER_ATTRIBUTE17,
814 l_pavv_rec.QUALIFIER_ATTRIBUTE18,
815 l_pavv_rec.QUALIFIER_ATTRIBUTE19,
816 l_pavv_rec.QUALIFIER_ATTRIBUTE20,
817 l_pavv_rec.QUALIFIER_ATTRIBUTE21,
818 l_pavv_rec.QUALIFIER_ATTRIBUTE22,
819 l_pavv_rec.QUALIFIER_ATTRIBUTE23,
820 l_pavv_rec.QUALIFIER_ATTRIBUTE24,
821 l_pavv_rec.QUALIFIER_ATTRIBUTE25,
822 l_pavv_rec.QUALIFIER_ATTRIBUTE26,
823 l_pavv_rec.QUALIFIER_ATTRIBUTE27,
824 l_pavv_rec.QUALIFIER_ATTRIBUTE28,
825 l_pavv_rec.QUALIFIER_ATTRIBUTE29,
826 l_pavv_rec.QUALIFIER_ATTRIBUTE30,
827 l_pavv_rec.QUALIFIER_ATTRIBUTE31,
828 l_pavv_rec.QUALIFIER_ATTRIBUTE32,
829 l_pavv_rec.QUALIFIER_ATTRIBUTE33,
830 l_pavv_rec.QUALIFIER_ATTRIBUTE34,
831 l_pavv_rec.QUALIFIER_ATTRIBUTE35,
832 l_pavv_rec.QUALIFIER_ATTRIBUTE36,
833 l_pavv_rec.QUALIFIER_ATTRIBUTE37,
834 l_pavv_rec.QUALIFIER_ATTRIBUTE38,
835 l_pavv_rec.QUALIFIER_ATTRIBUTE39,
836 l_pavv_rec.QUALIFIER_ATTRIBUTE40,
837 l_pavv_rec.QUALIFIER_ATTRIBUTE41,
838 l_pavv_rec.QUALIFIER_ATTRIBUTE42,
839 l_pavv_rec.QUALIFIER_ATTRIBUTE43,
840 l_pavv_rec.QUALIFIER_ATTRIBUTE44,
841 l_pavv_rec.QUALIFIER_ATTRIBUTE45,
842 l_pavv_rec.QUALIFIER_ATTRIBUTE46,
843 l_pavv_rec.QUALIFIER_ATTRIBUTE47,
844 l_pavv_rec.QUALIFIER_ATTRIBUTE48,
845 l_pavv_rec.QUALIFIER_ATTRIBUTE49,
846 l_pavv_rec.QUALIFIER_ATTRIBUTE50,
847 l_pavv_rec.QUALIFIER_ATTRIBUTE51,
848 l_pavv_rec.QUALIFIER_ATTRIBUTE52,
849 l_pavv_rec.QUALIFIER_ATTRIBUTE53,
850 l_pavv_rec.QUALIFIER_ATTRIBUTE54,
851 l_pavv_rec.QUALIFIER_ATTRIBUTE55,
852 l_pavv_rec.QUALIFIER_ATTRIBUTE56,
853 l_pavv_rec.QUALIFIER_ATTRIBUTE57,
854 l_pavv_rec.QUALIFIER_ATTRIBUTE58,
855 l_pavv_rec.QUALIFIER_ATTRIBUTE59,
856 l_pavv_rec.QUALIFIER_ATTRIBUTE60,
857 l_pavv_rec.QUALIFIER_ATTRIBUTE61,
858 l_pavv_rec.QUALIFIER_ATTRIBUTE62,
859 l_pavv_rec.QUALIFIER_ATTRIBUTE63,
860 l_pavv_rec.QUALIFIER_ATTRIBUTE64,
861 l_pavv_rec.QUALIFIER_ATTRIBUTE65,
862 l_pavv_rec.QUALIFIER_ATTRIBUTE66,
863 l_pavv_rec.QUALIFIER_ATTRIBUTE67,
864 l_pavv_rec.QUALIFIER_ATTRIBUTE68,
865 l_pavv_rec.QUALIFIER_ATTRIBUTE69,
866 l_pavv_rec.QUALIFIER_ATTRIBUTE70,
867 l_pavv_rec.QUALIFIER_ATTRIBUTE71,
868 l_pavv_rec.QUALIFIER_ATTRIBUTE72,
869 l_pavv_rec.QUALIFIER_ATTRIBUTE73,
870 l_pavv_rec.QUALIFIER_ATTRIBUTE74,
871 l_pavv_rec.QUALIFIER_ATTRIBUTE75,
872 l_pavv_rec.QUALIFIER_ATTRIBUTE76,
873 l_pavv_rec.QUALIFIER_ATTRIBUTE77,
874 l_pavv_rec.QUALIFIER_ATTRIBUTE78,
875 l_pavv_rec.QUALIFIER_ATTRIBUTE79,
876 l_pavv_rec.QUALIFIER_ATTRIBUTE80,
877 l_pavv_rec.QUALIFIER_ATTRIBUTE81,
878 l_pavv_rec.QUALIFIER_ATTRIBUTE82,
879 l_pavv_rec.QUALIFIER_ATTRIBUTE83,
880 l_pavv_rec.QUALIFIER_ATTRIBUTE84,
881 l_pavv_rec.QUALIFIER_ATTRIBUTE85,
882 l_pavv_rec.QUALIFIER_ATTRIBUTE86,
883 l_pavv_rec.QUALIFIER_ATTRIBUTE87,
884 l_pavv_rec.QUALIFIER_ATTRIBUTE88,
885 l_pavv_rec.QUALIFIER_ATTRIBUTE89,
886 l_pavv_rec.QUALIFIER_ATTRIBUTE90,
887 l_pavv_rec.QUALIFIER_ATTRIBUTE91,
888 l_pavv_rec.QUALIFIER_ATTRIBUTE92,
889 l_pavv_rec.QUALIFIER_ATTRIBUTE93,
890 l_pavv_rec.QUALIFIER_ATTRIBUTE94,
891 l_pavv_rec.QUALIFIER_ATTRIBUTE95,
892 l_pavv_rec.QUALIFIER_ATTRIBUTE96,
893 l_pavv_rec.QUALIFIER_ATTRIBUTE97,
894 l_pavv_rec.QUALIFIER_ATTRIBUTE98,
895 l_pavv_rec.QUALIFIER_ATTRIBUTE99,
896 l_pavv_rec.QUALIFIER_ATTRIBUTE100,
897 l_pavv_rec.CREATED_BY,
898 l_pavv_rec.CREATION_DATE,
899 l_pavv_rec.LAST_UPDATED_BY,
900 l_pavv_rec.LAST_UPDATE_DATE,
901 l_pavv_rec.LAST_UPDATE_LOGIN,
902 l_pavv_rec.PROGRAM_APPLICATION_ID,
903 l_pavv_rec.PROGRAM_ID,
904 l_pavv_rec.PROGRAM_UPDATE_DATE,
905 l_pavv_rec.REQUEST_ID,
906 l_pavv_rec.OBJECT_VERSION_NUMBER;
907 x_no_data_found := okc_pavv_pk_csr%NOTFOUND;
908 CLOSE okc_pavv_pk_csr;
909 RETURN(l_pavv_rec);
910 END get_rec;
911
912 ------------------------------------------------------------
913 -- FUNCTION null_out_defaults for: OKC_PRICE_ATT_VALUES_V --
914 ------------------------------------------------------------
915 FUNCTION null_out_defaults (
916 p_pavv_rec IN OKC_PAV_PVT.pavv_rec_type
917 ) RETURN OKC_PAV_PVT.pavv_rec_type IS
918 l_pavv_rec OKC_PAV_PVT.pavv_rec_type := p_pavv_rec;
919 BEGIN
920 IF (l_pavv_rec.chr_id = OKC_API.G_MISS_NUM) THEN
921 l_pavv_rec.chr_id := NULL;
922 END IF;
923 IF (l_pavv_rec.cle_id = OKC_API.G_MISS_NUM) THEN
924 l_pavv_rec.cle_id := NULL;
925 END IF;
926 IF (l_pavv_rec.flex_title = OKC_API.G_MISS_CHAR) THEN
927 l_pavv_rec.flex_title := NULL;
928 END IF;
929 IF (l_pavv_rec.pricing_context = OKC_API.G_MISS_CHAR) THEN
930 l_pavv_rec.pricing_context := NULL;
931 END IF;
932 IF (l_pavv_rec.pricing_attribute1 = OKC_API.G_MISS_CHAR) THEN
933 l_pavv_rec.pricing_attribute1 := NULL;
934 END IF;
935 IF (l_pavv_rec.pricing_attribute2 = OKC_API.G_MISS_CHAR) THEN
936 l_pavv_rec.pricing_attribute2 := NULL;
937 END IF;
938 IF (l_pavv_rec.pricing_attribute3 = OKC_API.G_MISS_CHAR) THEN
939 l_pavv_rec.pricing_attribute3 := NULL;
940 END IF;
941 IF (l_pavv_rec.pricing_attribute4 = OKC_API.G_MISS_CHAR) THEN
942 l_pavv_rec.pricing_attribute4 := NULL;
943 END IF;
944 IF (l_pavv_rec.pricing_attribute5 = OKC_API.G_MISS_CHAR) THEN
945 l_pavv_rec.pricing_attribute5 := NULL;
946 END IF;
947 IF (l_pavv_rec.pricing_attribute6 = OKC_API.G_MISS_CHAR) THEN
948 l_pavv_rec.pricing_attribute6 := NULL;
949 END IF;
950 IF (l_pavv_rec.pricing_attribute7 = OKC_API.G_MISS_CHAR) THEN
951 l_pavv_rec.pricing_attribute7 := NULL;
952 END IF;
953 IF (l_pavv_rec.pricing_attribute8 = OKC_API.G_MISS_CHAR) THEN
954 l_pavv_rec.pricing_attribute8 := NULL;
955 END IF;
956 IF (l_pavv_rec.pricing_attribute9 = OKC_API.G_MISS_CHAR) THEN
957 l_pavv_rec.pricing_attribute9 := NULL;
958 END IF;
959 IF (l_pavv_rec.pricing_attribute10 = OKC_API.G_MISS_CHAR) THEN
960 l_pavv_rec.pricing_attribute10 := NULL;
961 END IF;
962 IF (l_pavv_rec.pricing_attribute11 = OKC_API.G_MISS_CHAR) THEN
963 l_pavv_rec.pricing_attribute11 := NULL;
964 END IF;
965 IF (l_pavv_rec.pricing_attribute12 = OKC_API.G_MISS_CHAR) THEN
966 l_pavv_rec.pricing_attribute12 := NULL;
967 END IF;
968 IF (l_pavv_rec.pricing_attribute13 = OKC_API.G_MISS_CHAR) THEN
969 l_pavv_rec.pricing_attribute13 := NULL;
970 END IF;
971 IF (l_pavv_rec.pricing_attribute14 = OKC_API.G_MISS_CHAR) THEN
972 l_pavv_rec.pricing_attribute14 := NULL;
973 END IF;
974 IF (l_pavv_rec.pricing_attribute15 = OKC_API.G_MISS_CHAR) THEN
975 l_pavv_rec.pricing_attribute15 := NULL;
976 END IF;
977 IF (l_pavv_rec.pricing_attribute16 = OKC_API.G_MISS_CHAR) THEN
978 l_pavv_rec.pricing_attribute16 := NULL;
979 END IF;
980 IF (l_pavv_rec.pricing_attribute17 = OKC_API.G_MISS_CHAR) THEN
981 l_pavv_rec.pricing_attribute17 := NULL;
982 END IF;
983 IF (l_pavv_rec.pricing_attribute18 = OKC_API.G_MISS_CHAR) THEN
984 l_pavv_rec.pricing_attribute18 := NULL;
985 END IF;
986 IF (l_pavv_rec.pricing_attribute19 = OKC_API.G_MISS_CHAR) THEN
987 l_pavv_rec.pricing_attribute19 := NULL;
988 END IF;
989 IF (l_pavv_rec.pricing_attribute20 = OKC_API.G_MISS_CHAR) THEN
990 l_pavv_rec.pricing_attribute20 := NULL;
991 END IF;
992 IF (l_pavv_rec.pricing_attribute21 = OKC_API.G_MISS_CHAR) THEN
993 l_pavv_rec.pricing_attribute21 := NULL;
994 END IF;
995 IF (l_pavv_rec.pricing_attribute22 = OKC_API.G_MISS_CHAR) THEN
996 l_pavv_rec.pricing_attribute22 := NULL;
997 END IF;
998 IF (l_pavv_rec.pricing_attribute23 = OKC_API.G_MISS_CHAR) THEN
999 l_pavv_rec.pricing_attribute23 := NULL;
1000 END IF;
1001 IF (l_pavv_rec.pricing_attribute24 = OKC_API.G_MISS_CHAR) THEN
1002 l_pavv_rec.pricing_attribute24 := NULL;
1003 END IF;
1004 IF (l_pavv_rec.pricing_attribute25 = OKC_API.G_MISS_CHAR) THEN
1005 l_pavv_rec.pricing_attribute25 := NULL;
1006 END IF;
1007 IF (l_pavv_rec.pricing_attribute26 = OKC_API.G_MISS_CHAR) THEN
1008 l_pavv_rec.pricing_attribute26 := NULL;
1009 END IF;
1010 IF (l_pavv_rec.pricing_attribute27 = OKC_API.G_MISS_CHAR) THEN
1011 l_pavv_rec.pricing_attribute27 := NULL;
1012 END IF;
1013 IF (l_pavv_rec.pricing_attribute28 = OKC_API.G_MISS_CHAR) THEN
1014 l_pavv_rec.pricing_attribute28 := NULL;
1015 END IF;
1016 IF (l_pavv_rec.pricing_attribute29 = OKC_API.G_MISS_CHAR) THEN
1017 l_pavv_rec.pricing_attribute29 := NULL;
1018 END IF;
1019 IF (l_pavv_rec.pricing_attribute30 = OKC_API.G_MISS_CHAR) THEN
1020 l_pavv_rec.pricing_attribute30 := NULL;
1021 END IF;
1022 IF (l_pavv_rec.pricing_attribute31 = OKC_API.G_MISS_CHAR) THEN
1023 l_pavv_rec.pricing_attribute31 := NULL;
1024 END IF;
1025 IF (l_pavv_rec.pricing_attribute32 = OKC_API.G_MISS_CHAR) THEN
1026 l_pavv_rec.pricing_attribute32 := NULL;
1027 END IF;
1028 IF (l_pavv_rec.pricing_attribute33 = OKC_API.G_MISS_CHAR) THEN
1029 l_pavv_rec.pricing_attribute33 := NULL;
1030 END IF;
1031 IF (l_pavv_rec.pricing_attribute34 = OKC_API.G_MISS_CHAR) THEN
1032 l_pavv_rec.pricing_attribute34 := NULL;
1033 END IF;
1034 IF (l_pavv_rec.pricing_attribute35 = OKC_API.G_MISS_CHAR) THEN
1035 l_pavv_rec.pricing_attribute35 := NULL;
1036 END IF;
1037 IF (l_pavv_rec.pricing_attribute36 = OKC_API.G_MISS_CHAR) THEN
1038 l_pavv_rec.pricing_attribute36 := NULL;
1039 END IF;
1040 IF (l_pavv_rec.pricing_attribute37 = OKC_API.G_MISS_CHAR) THEN
1041 l_pavv_rec.pricing_attribute37 := NULL;
1042 END IF;
1043 IF (l_pavv_rec.pricing_attribute38 = OKC_API.G_MISS_CHAR) THEN
1044 l_pavv_rec.pricing_attribute38 := NULL;
1045 END IF;
1046 IF (l_pavv_rec.pricing_attribute39 = OKC_API.G_MISS_CHAR) THEN
1047 l_pavv_rec.pricing_attribute39 := NULL;
1048 END IF;
1049 IF (l_pavv_rec.pricing_attribute40 = OKC_API.G_MISS_CHAR) THEN
1050 l_pavv_rec.pricing_attribute40 := NULL;
1051 END IF;
1052 IF (l_pavv_rec.pricing_attribute41 = OKC_API.G_MISS_CHAR) THEN
1053 l_pavv_rec.pricing_attribute41 := NULL;
1054 END IF;
1055 IF (l_pavv_rec.pricing_attribute42 = OKC_API.G_MISS_CHAR) THEN
1056 l_pavv_rec.pricing_attribute42 := NULL;
1057 END IF;
1058 IF (l_pavv_rec.pricing_attribute43 = OKC_API.G_MISS_CHAR) THEN
1059 l_pavv_rec.pricing_attribute43 := NULL;
1060 END IF;
1061 IF (l_pavv_rec.pricing_attribute44 = OKC_API.G_MISS_CHAR) THEN
1062 l_pavv_rec.pricing_attribute44 := NULL;
1063 END IF;
1064 IF (l_pavv_rec.pricing_attribute45 = OKC_API.G_MISS_CHAR) THEN
1065 l_pavv_rec.pricing_attribute45 := NULL;
1066 END IF;
1067 IF (l_pavv_rec.pricing_attribute46 = OKC_API.G_MISS_CHAR) THEN
1068 l_pavv_rec.pricing_attribute46 := NULL;
1069 END IF;
1070 IF (l_pavv_rec.pricing_attribute47 = OKC_API.G_MISS_CHAR) THEN
1071 l_pavv_rec.pricing_attribute47 := NULL;
1072 END IF;
1073 IF (l_pavv_rec.pricing_attribute48 = OKC_API.G_MISS_CHAR) THEN
1074 l_pavv_rec.pricing_attribute48 := NULL;
1075 END IF;
1076 IF (l_pavv_rec.pricing_attribute49 = OKC_API.G_MISS_CHAR) THEN
1077 l_pavv_rec.pricing_attribute49 := NULL;
1078 END IF;
1079 IF (l_pavv_rec.pricing_attribute50 = OKC_API.G_MISS_CHAR) THEN
1080 l_pavv_rec.pricing_attribute50 := NULL;
1081 END IF;
1082 IF (l_pavv_rec.pricing_attribute51 = OKC_API.G_MISS_CHAR) THEN
1083 l_pavv_rec.pricing_attribute51 := NULL;
1084 END IF;
1085 IF (l_pavv_rec.pricing_attribute52 = OKC_API.G_MISS_CHAR) THEN
1086 l_pavv_rec.pricing_attribute52 := NULL;
1087 END IF;
1088 IF (l_pavv_rec.pricing_attribute53 = OKC_API.G_MISS_CHAR) THEN
1089 l_pavv_rec.pricing_attribute53 := NULL;
1090 END IF;
1091 IF (l_pavv_rec.pricing_attribute54 = OKC_API.G_MISS_CHAR) THEN
1092 l_pavv_rec.pricing_attribute54 := NULL;
1093 END IF;
1094 IF (l_pavv_rec.pricing_attribute55 = OKC_API.G_MISS_CHAR) THEN
1095 l_pavv_rec.pricing_attribute55 := NULL;
1096 END IF;
1097 IF (l_pavv_rec.pricing_attribute56 = OKC_API.G_MISS_CHAR) THEN
1098 l_pavv_rec.pricing_attribute56 := NULL;
1099 END IF;
1100 IF (l_pavv_rec.pricing_attribute57 = OKC_API.G_MISS_CHAR) THEN
1101 l_pavv_rec.pricing_attribute57 := NULL;
1102 END IF;
1103 IF (l_pavv_rec.pricing_attribute58 = OKC_API.G_MISS_CHAR) THEN
1104 l_pavv_rec.pricing_attribute58 := NULL;
1105 END IF;
1106 IF (l_pavv_rec.pricing_attribute59 = OKC_API.G_MISS_CHAR) THEN
1107 l_pavv_rec.pricing_attribute59 := NULL;
1108 END IF;
1109 IF (l_pavv_rec.pricing_attribute60 = OKC_API.G_MISS_CHAR) THEN
1110 l_pavv_rec.pricing_attribute60 := NULL;
1111 END IF;
1112 IF (l_pavv_rec.pricing_attribute61 = OKC_API.G_MISS_CHAR) THEN
1113 l_pavv_rec.pricing_attribute61 := NULL;
1114 END IF;
1115 IF (l_pavv_rec.pricing_attribute62 = OKC_API.G_MISS_CHAR) THEN
1116 l_pavv_rec.pricing_attribute62 := NULL;
1117 END IF;
1118 IF (l_pavv_rec.pricing_attribute63 = OKC_API.G_MISS_CHAR) THEN
1119 l_pavv_rec.pricing_attribute63 := NULL;
1120 END IF;
1121 IF (l_pavv_rec.pricing_attribute64 = OKC_API.G_MISS_CHAR) THEN
1122 l_pavv_rec.pricing_attribute64 := NULL;
1123 END IF;
1124 IF (l_pavv_rec.pricing_attribute65 = OKC_API.G_MISS_CHAR) THEN
1125 l_pavv_rec.pricing_attribute65 := NULL;
1126 END IF;
1127 IF (l_pavv_rec.pricing_attribute66 = OKC_API.G_MISS_CHAR) THEN
1128 l_pavv_rec.pricing_attribute66 := NULL;
1129 END IF;
1130 IF (l_pavv_rec.pricing_attribute67 = OKC_API.G_MISS_CHAR) THEN
1131 l_pavv_rec.pricing_attribute67 := NULL;
1132 END IF;
1133 IF (l_pavv_rec.pricing_attribute68 = OKC_API.G_MISS_CHAR) THEN
1134 l_pavv_rec.pricing_attribute68 := NULL;
1135 END IF;
1136 IF (l_pavv_rec.pricing_attribute69 = OKC_API.G_MISS_CHAR) THEN
1137 l_pavv_rec.pricing_attribute69 := NULL;
1138 END IF;
1139 IF (l_pavv_rec.pricing_attribute70 = OKC_API.G_MISS_CHAR) THEN
1140 l_pavv_rec.pricing_attribute70 := NULL;
1141 END IF;
1142 IF (l_pavv_rec.pricing_attribute71 = OKC_API.G_MISS_CHAR) THEN
1143 l_pavv_rec.pricing_attribute71 := NULL;
1144 END IF;
1145 IF (l_pavv_rec.pricing_attribute72 = OKC_API.G_MISS_CHAR) THEN
1146 l_pavv_rec.pricing_attribute72 := NULL;
1147 END IF;
1148 IF (l_pavv_rec.pricing_attribute73 = OKC_API.G_MISS_CHAR) THEN
1149 l_pavv_rec.pricing_attribute73 := NULL;
1150 END IF;
1151 IF (l_pavv_rec.pricing_attribute74 = OKC_API.G_MISS_CHAR) THEN
1152 l_pavv_rec.pricing_attribute74 := NULL;
1153 END IF;
1154 IF (l_pavv_rec.pricing_attribute75 = OKC_API.G_MISS_CHAR) THEN
1155 l_pavv_rec.pricing_attribute75 := NULL;
1156 END IF;
1157 IF (l_pavv_rec.pricing_attribute76 = OKC_API.G_MISS_CHAR) THEN
1158 l_pavv_rec.pricing_attribute76 := NULL;
1159 END IF;
1160 IF (l_pavv_rec.pricing_attribute77 = OKC_API.G_MISS_CHAR) THEN
1161 l_pavv_rec.pricing_attribute77 := NULL;
1162 END IF;
1163 IF (l_pavv_rec.pricing_attribute78 = OKC_API.G_MISS_CHAR) THEN
1164 l_pavv_rec.pricing_attribute78 := NULL;
1165 END IF;
1166 IF (l_pavv_rec.pricing_attribute79 = OKC_API.G_MISS_CHAR) THEN
1167 l_pavv_rec.pricing_attribute79 := NULL;
1168 END IF;
1169 IF (l_pavv_rec.pricing_attribute80 = OKC_API.G_MISS_CHAR) THEN
1170 l_pavv_rec.pricing_attribute80 := NULL;
1171 END IF;
1172 IF (l_pavv_rec.pricing_attribute81 = OKC_API.G_MISS_CHAR) THEN
1173 l_pavv_rec.pricing_attribute81 := NULL;
1174 END IF;
1175 IF (l_pavv_rec.pricing_attribute82 = OKC_API.G_MISS_CHAR) THEN
1176 l_pavv_rec.pricing_attribute82 := NULL;
1177 END IF;
1178 IF (l_pavv_rec.pricing_attribute83 = OKC_API.G_MISS_CHAR) THEN
1179 l_pavv_rec.pricing_attribute83 := NULL;
1180 END IF;
1181 IF (l_pavv_rec.pricing_attribute84 = OKC_API.G_MISS_CHAR) THEN
1182 l_pavv_rec.pricing_attribute84 := NULL;
1183 END IF;
1184 IF (l_pavv_rec.pricing_attribute85 = OKC_API.G_MISS_CHAR) THEN
1185 l_pavv_rec.pricing_attribute85 := NULL;
1186 END IF;
1187 IF (l_pavv_rec.pricing_attribute86 = OKC_API.G_MISS_CHAR) THEN
1188 l_pavv_rec.pricing_attribute86 := NULL;
1189 END IF;
1190 IF (l_pavv_rec.pricing_attribute87 = OKC_API.G_MISS_CHAR) THEN
1191 l_pavv_rec.pricing_attribute87 := NULL;
1192 END IF;
1193 IF (l_pavv_rec.pricing_attribute88 = OKC_API.G_MISS_CHAR) THEN
1194 l_pavv_rec.pricing_attribute88 := NULL;
1195 END IF;
1196 IF (l_pavv_rec.pricing_attribute89 = OKC_API.G_MISS_CHAR) THEN
1197 l_pavv_rec.pricing_attribute89 := NULL;
1198 END IF;
1199 IF (l_pavv_rec.pricing_attribute90 = OKC_API.G_MISS_CHAR) THEN
1200 l_pavv_rec.pricing_attribute90 := NULL;
1201 END IF;
1202 IF (l_pavv_rec.pricing_attribute91 = OKC_API.G_MISS_CHAR) THEN
1203 l_pavv_rec.pricing_attribute91 := NULL;
1204 END IF;
1205 IF (l_pavv_rec.pricing_attribute92 = OKC_API.G_MISS_CHAR) THEN
1206 l_pavv_rec.pricing_attribute92 := NULL;
1207 END IF;
1208 IF (l_pavv_rec.pricing_attribute93 = OKC_API.G_MISS_CHAR) THEN
1209 l_pavv_rec.pricing_attribute93 := NULL;
1210 END IF;
1211 IF (l_pavv_rec.pricing_attribute94 = OKC_API.G_MISS_CHAR) THEN
1212 l_pavv_rec.pricing_attribute94 := NULL;
1213 END IF;
1214 IF (l_pavv_rec.pricing_attribute95 = OKC_API.G_MISS_CHAR) THEN
1215 l_pavv_rec.pricing_attribute95 := NULL;
1216 END IF;
1217 IF (l_pavv_rec.pricing_attribute96 = OKC_API.G_MISS_CHAR) THEN
1218 l_pavv_rec.pricing_attribute96 := NULL;
1219 END IF;
1220 IF (l_pavv_rec.pricing_attribute97 = OKC_API.G_MISS_CHAR) THEN
1221 l_pavv_rec.pricing_attribute97 := NULL;
1222 END IF;
1223 IF (l_pavv_rec.pricing_attribute98 = OKC_API.G_MISS_CHAR) THEN
1224 l_pavv_rec.pricing_attribute98 := NULL;
1225 END IF;
1226 IF (l_pavv_rec.pricing_attribute99 = OKC_API.G_MISS_CHAR) THEN
1227 l_pavv_rec.pricing_attribute99 := NULL;
1228 END IF;
1229 IF (l_pavv_rec.pricing_attribute100 = OKC_API.G_MISS_CHAR) THEN
1230 l_pavv_rec.pricing_attribute100 := NULL;
1231 END IF;
1232 IF (l_pavv_rec.qualifier_context = OKC_API.G_MISS_CHAR) THEN
1233 l_pavv_rec.qualifier_context := NULL;
1234 END IF;
1235 IF (l_pavv_rec.qualifier_attribute1 = OKC_API.G_MISS_CHAR) THEN
1236 l_pavv_rec.qualifier_attribute1 := NULL;
1237 END IF;
1238 IF (l_pavv_rec.qualifier_attribute2 = OKC_API.G_MISS_CHAR) THEN
1239 l_pavv_rec.qualifier_attribute2 := NULL;
1240 END IF;
1241 IF (l_pavv_rec.qualifier_attribute3 = OKC_API.G_MISS_CHAR) THEN
1242 l_pavv_rec.qualifier_attribute3 := NULL;
1243 END IF;
1244 IF (l_pavv_rec.qualifier_attribute4 = OKC_API.G_MISS_CHAR) THEN
1245 l_pavv_rec.qualifier_attribute4 := NULL;
1246 END IF;
1247 IF (l_pavv_rec.qualifier_attribute5 = OKC_API.G_MISS_CHAR) THEN
1248 l_pavv_rec.qualifier_attribute5 := NULL;
1249 END IF;
1250 IF (l_pavv_rec.qualifier_attribute6 = OKC_API.G_MISS_CHAR) THEN
1251 l_pavv_rec.qualifier_attribute6 := NULL;
1252 END IF;
1253 IF (l_pavv_rec.qualifier_attribute7 = OKC_API.G_MISS_CHAR) THEN
1254 l_pavv_rec.qualifier_attribute7 := NULL;
1255 END IF;
1256 IF (l_pavv_rec.qualifier_attribute8 = OKC_API.G_MISS_CHAR) THEN
1257 l_pavv_rec.qualifier_attribute8 := NULL;
1258 END IF;
1259 IF (l_pavv_rec.qualifier_attribute9 = OKC_API.G_MISS_CHAR) THEN
1260 l_pavv_rec.qualifier_attribute9 := NULL;
1261 END IF;
1262 IF (l_pavv_rec.qualifier_attribute10 = OKC_API.G_MISS_CHAR) THEN
1263 l_pavv_rec.qualifier_attribute10 := NULL;
1264 END IF;
1265 IF (l_pavv_rec.qualifier_attribute11 = OKC_API.G_MISS_CHAR) THEN
1266 l_pavv_rec.qualifier_attribute11 := NULL;
1267 END IF;
1268 IF (l_pavv_rec.qualifier_attribute12 = OKC_API.G_MISS_CHAR) THEN
1269 l_pavv_rec.qualifier_attribute12 := NULL;
1270 END IF;
1271 IF (l_pavv_rec.qualifier_attribute13 = OKC_API.G_MISS_CHAR) THEN
1272 l_pavv_rec.qualifier_attribute13 := NULL;
1273 END IF;
1274 IF (l_pavv_rec.qualifier_attribute14 = OKC_API.G_MISS_CHAR) THEN
1275 l_pavv_rec.qualifier_attribute14 := NULL;
1276 END IF;
1277 IF (l_pavv_rec.qualifier_attribute15 = OKC_API.G_MISS_CHAR) THEN
1278 l_pavv_rec.qualifier_attribute15 := NULL;
1279 END IF;
1280 IF (l_pavv_rec.qualifier_attribute16 = OKC_API.G_MISS_CHAR) THEN
1281 l_pavv_rec.qualifier_attribute16 := NULL;
1282 END IF;
1283 IF (l_pavv_rec.qualifier_attribute17 = OKC_API.G_MISS_CHAR) THEN
1284 l_pavv_rec.qualifier_attribute17 := NULL;
1285 END IF;
1286 IF (l_pavv_rec.qualifier_attribute18 = OKC_API.G_MISS_CHAR) THEN
1287 l_pavv_rec.qualifier_attribute18 := NULL;
1288 END IF;
1289 IF (l_pavv_rec.qualifier_attribute19 = OKC_API.G_MISS_CHAR) THEN
1290 l_pavv_rec.qualifier_attribute19 := NULL;
1291 END IF;
1292 IF (l_pavv_rec.qualifier_attribute20 = OKC_API.G_MISS_CHAR) THEN
1293 l_pavv_rec.qualifier_attribute20 := NULL;
1294 END IF;
1295 IF (l_pavv_rec.qualifier_attribute21 = OKC_API.G_MISS_CHAR) THEN
1296 l_pavv_rec.qualifier_attribute21 := NULL;
1297 END IF;
1298 IF (l_pavv_rec.qualifier_attribute22 = OKC_API.G_MISS_CHAR) THEN
1299 l_pavv_rec.qualifier_attribute22 := NULL;
1300 END IF;
1301 IF (l_pavv_rec.qualifier_attribute23 = OKC_API.G_MISS_CHAR) THEN
1302 l_pavv_rec.qualifier_attribute23 := NULL;
1303 END IF;
1304 IF (l_pavv_rec.qualifier_attribute24 = OKC_API.G_MISS_CHAR) THEN
1305 l_pavv_rec.qualifier_attribute24 := NULL;
1306 END IF;
1307 IF (l_pavv_rec.qualifier_attribute25 = OKC_API.G_MISS_CHAR) THEN
1308 l_pavv_rec.qualifier_attribute25 := NULL;
1309 END IF;
1310 IF (l_pavv_rec.qualifier_attribute26 = OKC_API.G_MISS_CHAR) THEN
1311 l_pavv_rec.qualifier_attribute26 := NULL;
1312 END IF;
1313 IF (l_pavv_rec.qualifier_attribute27 = OKC_API.G_MISS_CHAR) THEN
1314 l_pavv_rec.qualifier_attribute27 := NULL;
1315 END IF;
1316 IF (l_pavv_rec.qualifier_attribute28 = OKC_API.G_MISS_CHAR) THEN
1317 l_pavv_rec.qualifier_attribute28 := NULL;
1318 END IF;
1319 IF (l_pavv_rec.qualifier_attribute29 = OKC_API.G_MISS_CHAR) THEN
1320 l_pavv_rec.qualifier_attribute29 := NULL;
1321 END IF;
1322 IF (l_pavv_rec.qualifier_attribute30 = OKC_API.G_MISS_CHAR) THEN
1323 l_pavv_rec.qualifier_attribute30 := NULL;
1324 END IF;
1325 IF (l_pavv_rec.qualifier_attribute31 = OKC_API.G_MISS_CHAR) THEN
1326 l_pavv_rec.qualifier_attribute31 := NULL;
1327 END IF;
1328 IF (l_pavv_rec.qualifier_attribute32 = OKC_API.G_MISS_CHAR) THEN
1329 l_pavv_rec.qualifier_attribute32 := NULL;
1330 END IF;
1331 IF (l_pavv_rec.qualifier_attribute33 = OKC_API.G_MISS_CHAR) THEN
1332 l_pavv_rec.qualifier_attribute33 := NULL;
1333 END IF;
1334 IF (l_pavv_rec.qualifier_attribute34 = OKC_API.G_MISS_CHAR) THEN
1335 l_pavv_rec.qualifier_attribute34 := NULL;
1336 END IF;
1337 IF (l_pavv_rec.qualifier_attribute35 = OKC_API.G_MISS_CHAR) THEN
1338 l_pavv_rec.qualifier_attribute35 := NULL;
1339 END IF;
1340 IF (l_pavv_rec.qualifier_attribute36 = OKC_API.G_MISS_CHAR) THEN
1341 l_pavv_rec.qualifier_attribute36 := NULL;
1342 END IF;
1343 IF (l_pavv_rec.qualifier_attribute37 = OKC_API.G_MISS_CHAR) THEN
1344 l_pavv_rec.qualifier_attribute37 := NULL;
1345 END IF;
1346 IF (l_pavv_rec.qualifier_attribute38 = OKC_API.G_MISS_CHAR) THEN
1347 l_pavv_rec.qualifier_attribute38 := NULL;
1348 END IF;
1349 IF (l_pavv_rec.qualifier_attribute39 = OKC_API.G_MISS_CHAR) THEN
1350 l_pavv_rec.qualifier_attribute39 := NULL;
1351 END IF;
1352 IF (l_pavv_rec.qualifier_attribute40 = OKC_API.G_MISS_CHAR) THEN
1353 l_pavv_rec.qualifier_attribute40 := NULL;
1354 END IF;
1355 IF (l_pavv_rec.qualifier_attribute41 = OKC_API.G_MISS_CHAR) THEN
1356 l_pavv_rec.qualifier_attribute41 := NULL;
1357 END IF;
1358 IF (l_pavv_rec.qualifier_attribute42 = OKC_API.G_MISS_CHAR) THEN
1359 l_pavv_rec.qualifier_attribute42 := NULL;
1360 END IF;
1361 IF (l_pavv_rec.qualifier_attribute43 = OKC_API.G_MISS_CHAR) THEN
1362 l_pavv_rec.qualifier_attribute43 := NULL;
1363 END IF;
1364 IF (l_pavv_rec.qualifier_attribute44 = OKC_API.G_MISS_CHAR) THEN
1365 l_pavv_rec.qualifier_attribute44 := NULL;
1366 END IF;
1367 IF (l_pavv_rec.qualifier_attribute45 = OKC_API.G_MISS_CHAR) THEN
1368 l_pavv_rec.qualifier_attribute45 := NULL;
1369 END IF;
1370 IF (l_pavv_rec.qualifier_attribute46 = OKC_API.G_MISS_CHAR) THEN
1371 l_pavv_rec.qualifier_attribute46 := NULL;
1372 END IF;
1373 IF (l_pavv_rec.qualifier_attribute47 = OKC_API.G_MISS_CHAR) THEN
1374 l_pavv_rec.qualifier_attribute47 := NULL;
1375 END IF;
1376 IF (l_pavv_rec.qualifier_attribute48 = OKC_API.G_MISS_CHAR) THEN
1377 l_pavv_rec.qualifier_attribute48 := NULL;
1378 END IF;
1379 IF (l_pavv_rec.qualifier_attribute49 = OKC_API.G_MISS_CHAR) THEN
1380 l_pavv_rec.qualifier_attribute49 := NULL;
1381 END IF;
1382 IF (l_pavv_rec.qualifier_attribute50 = OKC_API.G_MISS_CHAR) THEN
1383 l_pavv_rec.qualifier_attribute50 := NULL;
1384 END IF;
1385 IF (l_pavv_rec.qualifier_attribute51 = OKC_API.G_MISS_CHAR) THEN
1386 l_pavv_rec.qualifier_attribute51 := NULL;
1387 END IF;
1388 IF (l_pavv_rec.qualifier_attribute52 = OKC_API.G_MISS_CHAR) THEN
1389 l_pavv_rec.qualifier_attribute52 := NULL;
1390 END IF;
1391 IF (l_pavv_rec.qualifier_attribute53 = OKC_API.G_MISS_CHAR) THEN
1392 l_pavv_rec.qualifier_attribute53 := NULL;
1393 END IF;
1394 IF (l_pavv_rec.qualifier_attribute54 = OKC_API.G_MISS_CHAR) THEN
1395 l_pavv_rec.qualifier_attribute54 := NULL;
1396 END IF;
1397 IF (l_pavv_rec.qualifier_attribute55 = OKC_API.G_MISS_CHAR) THEN
1398 l_pavv_rec.qualifier_attribute55 := NULL;
1399 END IF;
1400 IF (l_pavv_rec.qualifier_attribute56 = OKC_API.G_MISS_CHAR) THEN
1401 l_pavv_rec.qualifier_attribute56 := NULL;
1402 END IF;
1403 IF (l_pavv_rec.qualifier_attribute57 = OKC_API.G_MISS_CHAR) THEN
1404 l_pavv_rec.qualifier_attribute57 := NULL;
1405 END IF;
1406 IF (l_pavv_rec.qualifier_attribute58 = OKC_API.G_MISS_CHAR) THEN
1407 l_pavv_rec.qualifier_attribute58 := NULL;
1408 END IF;
1409 IF (l_pavv_rec.qualifier_attribute59 = OKC_API.G_MISS_CHAR) THEN
1410 l_pavv_rec.qualifier_attribute59 := NULL;
1411 END IF;
1412 IF (l_pavv_rec.qualifier_attribute60 = OKC_API.G_MISS_CHAR) THEN
1413 l_pavv_rec.qualifier_attribute60 := NULL;
1414 END IF;
1415 IF (l_pavv_rec.qualifier_attribute61 = OKC_API.G_MISS_CHAR) THEN
1416 l_pavv_rec.qualifier_attribute61 := NULL;
1417 END IF;
1418 IF (l_pavv_rec.qualifier_attribute62 = OKC_API.G_MISS_CHAR) THEN
1419 l_pavv_rec.qualifier_attribute62 := NULL;
1420 END IF;
1421 IF (l_pavv_rec.qualifier_attribute63 = OKC_API.G_MISS_CHAR) THEN
1422 l_pavv_rec.qualifier_attribute63 := NULL;
1423 END IF;
1424 IF (l_pavv_rec.qualifier_attribute64 = OKC_API.G_MISS_CHAR) THEN
1425 l_pavv_rec.qualifier_attribute64 := NULL;
1426 END IF;
1427 IF (l_pavv_rec.qualifier_attribute65 = OKC_API.G_MISS_CHAR) THEN
1428 l_pavv_rec.qualifier_attribute65 := NULL;
1429 END IF;
1430 IF (l_pavv_rec.qualifier_attribute66 = OKC_API.G_MISS_CHAR) THEN
1431 l_pavv_rec.qualifier_attribute66 := NULL;
1432 END IF;
1433 IF (l_pavv_rec.qualifier_attribute67 = OKC_API.G_MISS_CHAR) THEN
1434 l_pavv_rec.qualifier_attribute67 := NULL;
1435 END IF;
1436 IF (l_pavv_rec.qualifier_attribute68 = OKC_API.G_MISS_CHAR) THEN
1437 l_pavv_rec.qualifier_attribute68 := NULL;
1438 END IF;
1439 IF (l_pavv_rec.qualifier_attribute69 = OKC_API.G_MISS_CHAR) THEN
1440 l_pavv_rec.qualifier_attribute69 := NULL;
1441 END IF;
1442 IF (l_pavv_rec.qualifier_attribute70 = OKC_API.G_MISS_CHAR) THEN
1443 l_pavv_rec.qualifier_attribute70 := NULL;
1444 END IF;
1445 IF (l_pavv_rec.qualifier_attribute71 = OKC_API.G_MISS_CHAR) THEN
1446 l_pavv_rec.qualifier_attribute71 := NULL;
1447 END IF;
1448 IF (l_pavv_rec.qualifier_attribute72 = OKC_API.G_MISS_CHAR) THEN
1449 l_pavv_rec.qualifier_attribute72 := NULL;
1450 END IF;
1451 IF (l_pavv_rec.qualifier_attribute73 = OKC_API.G_MISS_CHAR) THEN
1452 l_pavv_rec.qualifier_attribute73 := NULL;
1453 END IF;
1454 IF (l_pavv_rec.qualifier_attribute74 = OKC_API.G_MISS_CHAR) THEN
1455 l_pavv_rec.qualifier_attribute74 := NULL;
1456 END IF;
1457 IF (l_pavv_rec.qualifier_attribute75 = OKC_API.G_MISS_CHAR) THEN
1458 l_pavv_rec.qualifier_attribute75 := NULL;
1459 END IF;
1460 IF (l_pavv_rec.qualifier_attribute76 = OKC_API.G_MISS_CHAR) THEN
1461 l_pavv_rec.qualifier_attribute76 := NULL;
1462 END IF;
1463 IF (l_pavv_rec.qualifier_attribute77 = OKC_API.G_MISS_CHAR) THEN
1464 l_pavv_rec.qualifier_attribute77 := NULL;
1465 END IF;
1466 IF (l_pavv_rec.qualifier_attribute78 = OKC_API.G_MISS_CHAR) THEN
1467 l_pavv_rec.qualifier_attribute78 := NULL;
1468 END IF;
1469 IF (l_pavv_rec.qualifier_attribute79 = OKC_API.G_MISS_CHAR) THEN
1470 l_pavv_rec.qualifier_attribute79 := NULL;
1471 END IF;
1472 IF (l_pavv_rec.qualifier_attribute80 = OKC_API.G_MISS_CHAR) THEN
1473 l_pavv_rec.qualifier_attribute80 := NULL;
1474 END IF;
1475 IF (l_pavv_rec.qualifier_attribute81 = OKC_API.G_MISS_CHAR) THEN
1476 l_pavv_rec.qualifier_attribute81 := NULL;
1477 END IF;
1478 IF (l_pavv_rec.qualifier_attribute82 = OKC_API.G_MISS_CHAR) THEN
1479 l_pavv_rec.qualifier_attribute82 := NULL;
1480 END IF;
1481 IF (l_pavv_rec.qualifier_attribute83 = OKC_API.G_MISS_CHAR) THEN
1482 l_pavv_rec.qualifier_attribute83 := NULL;
1483 END IF;
1484 IF (l_pavv_rec.qualifier_attribute84 = OKC_API.G_MISS_CHAR) THEN
1485 l_pavv_rec.qualifier_attribute84 := NULL;
1486 END IF;
1487 IF (l_pavv_rec.qualifier_attribute85 = OKC_API.G_MISS_CHAR) THEN
1488 l_pavv_rec.qualifier_attribute85 := NULL;
1489 END IF;
1490 IF (l_pavv_rec.qualifier_attribute86 = OKC_API.G_MISS_CHAR) THEN
1491 l_pavv_rec.qualifier_attribute86 := NULL;
1492 END IF;
1493 IF (l_pavv_rec.qualifier_attribute87 = OKC_API.G_MISS_CHAR) THEN
1494 l_pavv_rec.qualifier_attribute87 := NULL;
1495 END IF;
1496 IF (l_pavv_rec.qualifier_attribute88 = OKC_API.G_MISS_CHAR) THEN
1497 l_pavv_rec.qualifier_attribute88 := NULL;
1498 END IF;
1499 IF (l_pavv_rec.qualifier_attribute89 = OKC_API.G_MISS_CHAR) THEN
1500 l_pavv_rec.qualifier_attribute89 := NULL;
1501 END IF;
1502 IF (l_pavv_rec.qualifier_attribute90 = OKC_API.G_MISS_CHAR) THEN
1503 l_pavv_rec.qualifier_attribute90 := NULL;
1504 END IF;
1505 IF (l_pavv_rec.qualifier_attribute91 = OKC_API.G_MISS_CHAR) THEN
1506 l_pavv_rec.qualifier_attribute91 := NULL;
1507 END IF;
1508 IF (l_pavv_rec.qualifier_attribute92 = OKC_API.G_MISS_CHAR) THEN
1509 l_pavv_rec.qualifier_attribute92 := NULL;
1510 END IF;
1511 IF (l_pavv_rec.qualifier_attribute93 = OKC_API.G_MISS_CHAR) THEN
1512 l_pavv_rec.qualifier_attribute93 := NULL;
1513 END IF;
1514 IF (l_pavv_rec.qualifier_attribute94 = OKC_API.G_MISS_CHAR) THEN
1515 l_pavv_rec.qualifier_attribute94 := NULL;
1516 END IF;
1517 IF (l_pavv_rec.qualifier_attribute95 = OKC_API.G_MISS_CHAR) THEN
1518 l_pavv_rec.qualifier_attribute95 := NULL;
1519 END IF;
1520 IF (l_pavv_rec.qualifier_attribute96 = OKC_API.G_MISS_CHAR) THEN
1521 l_pavv_rec.qualifier_attribute96 := NULL;
1522 END IF;
1523 IF (l_pavv_rec.qualifier_attribute97 = OKC_API.G_MISS_CHAR) THEN
1524 l_pavv_rec.qualifier_attribute97 := NULL;
1525 END IF;
1526 IF (l_pavv_rec.qualifier_attribute98 = OKC_API.G_MISS_CHAR) THEN
1527 l_pavv_rec.qualifier_attribute98 := NULL;
1528 END IF;
1529 IF (l_pavv_rec.qualifier_attribute99 = OKC_API.G_MISS_CHAR) THEN
1530 l_pavv_rec.qualifier_attribute99 := NULL;
1531 END IF;
1532 IF (l_pavv_rec.qualifier_attribute100 = OKC_API.G_MISS_CHAR) THEN
1533 l_pavv_rec.qualifier_attribute100 := NULL;
1534 END IF;
1535 IF (l_pavv_rec.created_by = OKC_API.G_MISS_NUM) THEN
1536 l_pavv_rec.created_by := NULL;
1537 END IF;
1538 IF (l_pavv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
1539 l_pavv_rec.creation_date := NULL;
1540 END IF;
1541 IF (l_pavv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
1542 l_pavv_rec.last_updated_by := NULL;
1543 END IF;
1544 IF (l_pavv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
1545 l_pavv_rec.last_update_date := NULL;
1546 END IF;
1547 IF (l_pavv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
1548 l_pavv_rec.last_update_login := NULL;
1549 END IF;
1550 IF (l_pavv_rec.program_application_id = OKC_API.G_MISS_NUM) THEN
1551 l_pavv_rec.program_application_id := NULL;
1552 END IF;
1553 IF (l_pavv_rec.program_id = OKC_API.G_MISS_NUM) THEN
1554 l_pavv_rec.program_id := NULL;
1555 END IF;
1556 IF (l_pavv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN
1557 l_pavv_rec.program_update_date := NULL;
1558 END IF;
1559 IF (l_pavv_rec.request_id= OKC_API.G_MISS_NUM) THEN
1560 l_pavv_rec.request_id := NULL;
1561 END IF;
1562 IF (l_pavv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
1563 l_pavv_rec.object_version_number := NULL;
1564 END IF;
1565
1566 RETURN(l_pavv_rec);
1567 END null_out_defaults;
1568
1569 END OKC_SPLIT1_PAV_PVT;