[Home] [Help]
PACKAGE BODY: APPS.OKC_SPLIT2_PAV_PVT
Source
1 PACKAGE BODY OKC_SPLIT2_PAV_PVT AS
2 /* $Header: OKCSPAVSPTB.pls 120.2 2010/12/16 10:49:33 nvvaidya noship $ */
3 -- PROCEDURE Migrate
4 ---------------------------------------------------------------------------
5 PROCEDURE migrate (
6 p_from IN OKC_PAV_PVT.pavv_rec_type,
7 p_to IN OUT NOCOPY OKC_PAV_PVT.pav_rec_type
8 ) IS
9 BEGIN
10 p_to.id := p_from.id;
11 p_to.flex_title := p_from.flex_title;
12 p_to.pricing_context := p_from.pricing_context;
13 p_to.pricing_attribute1 := p_from.pricing_attribute1;
14 p_to.chr_id := p_from.chr_id;
15 p_to.pricing_attribute2 := p_from.pricing_attribute2;
16 p_to.cle_id := p_from.cle_id;
17 p_to.pricing_attribute3 := p_from.pricing_attribute3;
18 p_to.pricing_attribute4 := p_from.pricing_attribute4;
19 p_to.pricing_attribute5 := p_from.pricing_attribute5;
20 p_to.pricing_attribute6 := p_from.pricing_attribute6;
21 p_to.pricing_attribute7 := p_from.pricing_attribute7;
22 p_to.pricing_attribute8 := p_from.pricing_attribute8;
23 p_to.pricing_attribute9 := p_from.pricing_attribute9;
24 p_to.pricing_attribute10 := p_from.pricing_attribute10;
25 p_to.pricing_attribute11 := p_from.pricing_attribute11;
26 p_to.pricing_attribute12 := p_from.pricing_attribute12;
27 p_to.pricing_attribute13 := p_from.pricing_attribute13;
28 p_to.pricing_attribute14 := p_from.pricing_attribute14;
29 p_to.pricing_attribute15 := p_from.pricing_attribute15;
30 p_to.pricing_attribute16 := p_from.pricing_attribute16;
31 p_to.pricing_attribute17 := p_from.pricing_attribute17;
32 p_to.pricing_attribute18 := p_from.pricing_attribute18;
33 p_to.pricing_attribute19 := p_from.pricing_attribute19;
34 p_to.pricing_attribute20 := p_from.pricing_attribute20;
35 p_to.pricing_attribute21 := p_from.pricing_attribute21;
36 p_to.pricing_attribute22 := p_from.pricing_attribute22;
37 p_to.pricing_attribute23 := p_from.pricing_attribute23;
38 p_to.pricing_attribute24 := p_from.pricing_attribute24;
39 p_to.pricing_attribute25 := p_from.pricing_attribute25;
40 p_to.pricing_attribute26 := p_from.pricing_attribute26;
41 p_to.pricing_attribute27 := p_from.pricing_attribute27;
42 p_to.pricing_attribute28 := p_from.pricing_attribute28;
43 p_to.pricing_attribute29 := p_from.pricing_attribute29;
44 p_to.pricing_attribute30 := p_from.pricing_attribute30;
45 p_to.pricing_attribute31 := p_from.pricing_attribute31;
46 p_to.pricing_attribute32 := p_from.pricing_attribute32;
47 p_to.pricing_attribute33 := p_from.pricing_attribute33;
48 p_to.pricing_attribute34 := p_from.pricing_attribute34;
49 p_to.pricing_attribute35 := p_from.pricing_attribute35;
50 p_to.pricing_attribute36 := p_from.pricing_attribute36;
51 p_to.pricing_attribute37 := p_from.pricing_attribute37;
52 p_to.pricing_attribute38 := p_from.pricing_attribute38;
53 p_to.pricing_attribute39 := p_from.pricing_attribute39;
54 p_to.pricing_attribute40 := p_from.pricing_attribute40;
55 p_to.pricing_attribute41 := p_from.pricing_attribute41;
56 p_to.pricing_attribute42 := p_from.pricing_attribute42;
57 p_to.pricing_attribute43 := p_from.pricing_attribute43;
58 p_to.pricing_attribute44 := p_from.pricing_attribute44;
59 p_to.pricing_attribute45 := p_from.pricing_attribute45;
60 p_to.pricing_attribute46 := p_from.pricing_attribute46;
61 p_to.pricing_attribute47 := p_from.pricing_attribute47;
62 p_to.pricing_attribute48 := p_from.pricing_attribute48;
63 p_to.pricing_attribute49 := p_from.pricing_attribute49;
64 p_to.pricing_attribute50 := p_from.pricing_attribute50;
65 p_to.pricing_attribute51 := p_from.pricing_attribute51;
66 p_to.pricing_attribute52 := p_from.pricing_attribute52;
67 p_to.pricing_attribute53 := p_from.pricing_attribute53;
68 p_to.pricing_attribute54 := p_from.pricing_attribute54;
69 p_to.pricing_attribute55 := p_from.pricing_attribute55;
70 p_to.pricing_attribute56 := p_from.pricing_attribute56;
71 p_to.pricing_attribute57 := p_from.pricing_attribute57;
72 p_to.pricing_attribute58 := p_from.pricing_attribute58;
73 p_to.pricing_attribute59 := p_from.pricing_attribute59;
74 p_to.pricing_attribute60 := p_from.pricing_attribute60;
75 p_to.pricing_attribute61 := p_from.pricing_attribute61;
76 p_to.pricing_attribute62 := p_from.pricing_attribute62;
77 p_to.pricing_attribute63 := p_from.pricing_attribute63;
78 p_to.pricing_attribute64 := p_from.pricing_attribute64;
79 p_to.pricing_attribute65 := p_from.pricing_attribute65;
80 p_to.pricing_attribute66 := p_from.pricing_attribute66;
81 p_to.pricing_attribute67 := p_from.pricing_attribute67;
82 p_to.pricing_attribute68 := p_from.pricing_attribute68;
83 p_to.pricing_attribute69 := p_from.pricing_attribute69;
84 p_to.pricing_attribute70 := p_from.pricing_attribute70;
85 p_to.pricing_attribute71 := p_from.pricing_attribute71;
86 p_to.pricing_attribute72 := p_from.pricing_attribute72;
87 p_to.pricing_attribute73 := p_from.pricing_attribute73;
88 p_to.pricing_attribute74 := p_from.pricing_attribute74;
89 p_to.pricing_attribute75 := p_from.pricing_attribute75;
90 p_to.pricing_attribute76 := p_from.pricing_attribute76;
91 p_to.pricing_attribute77 := p_from.pricing_attribute77;
92 p_to.pricing_attribute78 := p_from.pricing_attribute78;
93 p_to.pricing_attribute79 := p_from.pricing_attribute79;
94 p_to.pricing_attribute80 := p_from.pricing_attribute80;
95 p_to.pricing_attribute81 := p_from.pricing_attribute81;
96 p_to.pricing_attribute82 := p_from.pricing_attribute82;
97 p_to.pricing_attribute83 := p_from.pricing_attribute83;
98 p_to.pricing_attribute84 := p_from.pricing_attribute84;
99 p_to.pricing_attribute85 := p_from.pricing_attribute85;
100 p_to.pricing_attribute86 := p_from.pricing_attribute86;
101 p_to.pricing_attribute87 := p_from.pricing_attribute87;
102 p_to.pricing_attribute88 := p_from.pricing_attribute88;
103 p_to.pricing_attribute89 := p_from.pricing_attribute89;
104 p_to.pricing_attribute90 := p_from.pricing_attribute90;
105 p_to.pricing_attribute91 := p_from.pricing_attribute91;
106 p_to.pricing_attribute92 := p_from.pricing_attribute92;
107 p_to.pricing_attribute93 := p_from.pricing_attribute93;
108 p_to.pricing_attribute94 := p_from.pricing_attribute94;
109 p_to.pricing_attribute95 := p_from.pricing_attribute95;
110 p_to.pricing_attribute96 := p_from.pricing_attribute96;
111 p_to.pricing_attribute97 := p_from.pricing_attribute97;
112 p_to.pricing_attribute98 := p_from.pricing_attribute98;
113 p_to.pricing_attribute99 := p_from.pricing_attribute99;
114 p_to.pricing_attribute100 := p_from.pricing_attribute100;
115 p_to.qualifier_context := p_from.qualifier_context;
116 p_to.qualifier_attribute1 := p_from.qualifier_attribute1;
117 p_to.qualifier_attribute2 := p_from.qualifier_attribute2;
118 p_to.created_by := p_from.created_by;
119 p_to.qualifier_attribute3 := p_from.qualifier_attribute3;
120 p_to.creation_date := p_from.creation_date;
121 p_to.qualifier_attribute4 := p_from.qualifier_attribute4;
122 p_to.qualifier_attribute5 := p_from.qualifier_attribute5;
123 p_to.last_updated_by := p_from.last_updated_by;
124 p_to.qualifier_attribute6 := p_from.qualifier_attribute6;
125 p_to.last_update_date := p_from.last_update_date;
126 p_to.qualifier_attribute7 := p_from.qualifier_attribute7;
127 p_to.qualifier_attribute8 := p_from.qualifier_attribute8;
128 p_to.qualifier_attribute9 := p_from.qualifier_attribute9;
129 p_to.qualifier_attribute10 := p_from.qualifier_attribute10;
130 p_to.qualifier_attribute11 := p_from.qualifier_attribute11;
131 p_to.qualifier_attribute12 := p_from.qualifier_attribute12;
132 p_to.qualifier_attribute13 := p_from.qualifier_attribute13;
133 p_to.qualifier_attribute14 := p_from.qualifier_attribute14;
134 p_to.qualifier_attribute15 := p_from.qualifier_attribute15;
135 p_to.qualifier_attribute16 := p_from.qualifier_attribute16;
136 p_to.qualifier_attribute17 := p_from.qualifier_attribute17;
137 p_to.qualifier_attribute18 := p_from.qualifier_attribute18;
138 p_to.qualifier_attribute19 := p_from.qualifier_attribute19;
139 p_to.qualifier_attribute20 := p_from.qualifier_attribute20;
140 p_to.qualifier_attribute21 := p_from.qualifier_attribute21;
141 p_to.qualifier_attribute22 := p_from.qualifier_attribute22;
142 p_to.qualifier_attribute23 := p_from.qualifier_attribute23;
143 p_to.qualifier_attribute24 := p_from.qualifier_attribute24;
144 p_to.qualifier_attribute25 := p_from.qualifier_attribute25;
145 p_to.qualifier_attribute26 := p_from.qualifier_attribute26;
146 p_to.qualifier_attribute27 := p_from.qualifier_attribute27;
147 p_to.qualifier_attribute28 := p_from.qualifier_attribute28;
148 p_to.qualifier_attribute29 := p_from.qualifier_attribute29;
149 p_to.qualifier_attribute30 := p_from.qualifier_attribute30;
150 p_to.qualifier_attribute31 := p_from.qualifier_attribute31;
151 p_to.qualifier_attribute32 := p_from.qualifier_attribute32;
152 p_to.qualifier_attribute33 := p_from.qualifier_attribute33;
153 p_to.qualifier_attribute34 := p_from.qualifier_attribute34;
154 p_to.qualifier_attribute35 := p_from.qualifier_attribute35;
155 p_to.qualifier_attribute36 := p_from.qualifier_attribute36;
156 p_to.qualifier_attribute37 := p_from.qualifier_attribute37;
157 p_to.qualifier_attribute38 := p_from.qualifier_attribute38;
158 p_to.qualifier_attribute39 := p_from.qualifier_attribute39;
159 p_to.qualifier_attribute40 := p_from.qualifier_attribute40;
160 p_to.qualifier_attribute41 := p_from.qualifier_attribute41;
161 p_to.qualifier_attribute42 := p_from.qualifier_attribute42;
162 p_to.qualifier_attribute43 := p_from.qualifier_attribute43;
163 p_to.qualifier_attribute44 := p_from.qualifier_attribute44;
164 p_to.qualifier_attribute45 := p_from.qualifier_attribute45;
165 p_to.qualifier_attribute46 := p_from.qualifier_attribute46;
166 p_to.qualifier_attribute47 := p_from.qualifier_attribute47;
167 p_to.qualifier_attribute48 := p_from.qualifier_attribute48;
168 p_to.qualifier_attribute49 := p_from.qualifier_attribute49;
169 p_to.qualifier_attribute50 := p_from.qualifier_attribute50;
170 p_to.qualifier_attribute51 := p_from.qualifier_attribute51;
171 p_to.qualifier_attribute52 := p_from.qualifier_attribute52;
172 p_to.qualifier_attribute53 := p_from.qualifier_attribute53;
173 p_to.qualifier_attribute54 := p_from.qualifier_attribute54;
174 p_to.qualifier_attribute55 := p_from.qualifier_attribute55;
175 p_to.qualifier_attribute56 := p_from.qualifier_attribute56;
176 p_to.qualifier_attribute57 := p_from.qualifier_attribute57;
177 p_to.qualifier_attribute58 := p_from.qualifier_attribute58;
178 p_to.qualifier_attribute59 := p_from.qualifier_attribute59;
179 p_to.qualifier_attribute60 := p_from.qualifier_attribute60;
180 p_to.qualifier_attribute61 := p_from.qualifier_attribute61;
181 p_to.qualifier_attribute62 := p_from.qualifier_attribute62;
182 p_to.qualifier_attribute63 := p_from.qualifier_attribute63;
183 p_to.qualifier_attribute64 := p_from.qualifier_attribute64;
184 p_to.qualifier_attribute65 := p_from.qualifier_attribute65;
185 p_to.qualifier_attribute66 := p_from.qualifier_attribute66;
186 p_to.qualifier_attribute67 := p_from.qualifier_attribute67;
187 p_to.qualifier_attribute68 := p_from.qualifier_attribute68;
188 p_to.qualifier_attribute69 := p_from.qualifier_attribute69;
189 p_to.qualifier_attribute70 := p_from.qualifier_attribute70;
190 p_to.qualifier_attribute71 := p_from.qualifier_attribute71;
191 p_to.qualifier_attribute72 := p_from.qualifier_attribute72;
192 p_to.qualifier_attribute73 := p_from.qualifier_attribute73;
193 p_to.qualifier_attribute74 := p_from.qualifier_attribute74;
194 p_to.qualifier_attribute75 := p_from.qualifier_attribute75;
195 p_to.qualifier_attribute76 := p_from.qualifier_attribute76;
196 p_to.qualifier_attribute77 := p_from.qualifier_attribute77;
197 p_to.qualifier_attribute78 := p_from.qualifier_attribute78;
198 p_to.qualifier_attribute79 := p_from.qualifier_attribute79;
199 p_to.qualifier_attribute80 := p_from.qualifier_attribute80;
200 p_to.qualifier_attribute81 := p_from.qualifier_attribute81;
201 p_to.qualifier_attribute82 := p_from.qualifier_attribute82;
202 p_to.qualifier_attribute83 := p_from.qualifier_attribute83;
203 p_to.qualifier_attribute84 := p_from.qualifier_attribute84;
204 p_to.qualifier_attribute85 := p_from.qualifier_attribute85;
205 p_to.qualifier_attribute86 := p_from.qualifier_attribute86;
206 p_to.qualifier_attribute87 := p_from.qualifier_attribute87;
207 p_to.qualifier_attribute88 := p_from.qualifier_attribute88;
208 p_to.qualifier_attribute89 := p_from.qualifier_attribute89;
209 p_to.qualifier_attribute90 := p_from.qualifier_attribute90;
210 p_to.qualifier_attribute91 := p_from.qualifier_attribute91;
211 p_to.qualifier_attribute92 := p_from.qualifier_attribute92;
212 p_to.qualifier_attribute93 := p_from.qualifier_attribute93;
213 p_to.qualifier_attribute94 := p_from.qualifier_attribute94;
214 p_to.qualifier_attribute95 := p_from.qualifier_attribute95;
215 p_to.qualifier_attribute96 := p_from.qualifier_attribute96;
216 p_to.qualifier_attribute97 := p_from.qualifier_attribute97;
217 p_to.qualifier_attribute98 := p_from.qualifier_attribute98;
218 p_to.qualifier_attribute99 := p_from.qualifier_attribute99;
219 p_to.qualifier_attribute100 := p_from.qualifier_attribute100;
220 p_to.last_update_login := p_from.last_update_login;
221 p_to.program_application_id := p_from.program_application_id;
222 p_to.program_id := p_from.program_id;
223 p_to.program_update_date:= p_from.program_update_date;
224 p_to.request_id := p_from.request_id;
225 p_to.object_version_number := p_from.object_version_number;
226 END migrate;
227
228 FUNCTION restore_version(
229 p_chr_id IN NUMBER,
230 p_major_version IN NUMBER
231 ) RETURN VARCHAR2 IS
232
233 l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
234
235 BEGIN
236 INSERT INTO okc_price_att_values
237 (
238
239 id,
240 flex_title,
241 pricing_context,
242 pricing_attribute1,
243 chr_id,
244 pricing_attribute2,
245 cle_id,
246 pricing_attribute3,
247 pricing_attribute4,
248 pricing_attribute5,
249 pricing_attribute6,
250 pricing_attribute7,
251 pricing_attribute8,
252 pricing_attribute9,
253 pricing_attribute10,
254 pricing_attribute11,
255 pricing_attribute12,
256 pricing_attribute13,
257 pricing_attribute14,
258 pricing_attribute15,
259 pricing_attribute16,
260 pricing_attribute17,
261 pricing_attribute18,
262 pricing_attribute19,
263 pricing_attribute20,
264 pricing_attribute21,
265 pricing_attribute22,
266 pricing_attribute23,
267 pricing_attribute24,
268 pricing_attribute25,
269 pricing_attribute26,
270 pricing_attribute27,
271 pricing_attribute28,
272 pricing_attribute29,
273 pricing_attribute30,
274 pricing_attribute31,
275 pricing_attribute32,
276 pricing_attribute33,
277 pricing_attribute34,
278 pricing_attribute35,
279 pricing_attribute36,
280 pricing_attribute37,
281 pricing_attribute38,
282 pricing_attribute39,
283 pricing_attribute40,
284 pricing_attribute41,
285 pricing_attribute42,
286 pricing_attribute43,
287 pricing_attribute44,
288 pricing_attribute45,
289 pricing_attribute46,
290 pricing_attribute47,
291 pricing_attribute48,
292 pricing_attribute49,
293 pricing_attribute50,
294 pricing_attribute51,
295 pricing_attribute52,
296 pricing_attribute53,
297 pricing_attribute54,
298 pricing_attribute55,
299 pricing_attribute56,
300 pricing_attribute57,
301 pricing_attribute58,
302 pricing_attribute59,
303 pricing_attribute60,
304 pricing_attribute61,
305 pricing_attribute62,
306 pricing_attribute63,
307 pricing_attribute64,
308 pricing_attribute65,
309 pricing_attribute66,
310 pricing_attribute67,
311 pricing_attribute68,
312 pricing_attribute69,
313 pricing_attribute70,
314 pricing_attribute71,
315 pricing_attribute72,
316 pricing_attribute73,
317 pricing_attribute74,
318 pricing_attribute75,
319 pricing_attribute76,
320 pricing_attribute77,
321 pricing_attribute78,
322 pricing_attribute79,
323 pricing_attribute80,
324 pricing_attribute81,
325 pricing_attribute82,
326 pricing_attribute83,
327 pricing_attribute84,
328 pricing_attribute85,
329 pricing_attribute86,
330 pricing_attribute87,
331 pricing_attribute88,
332 pricing_attribute89,
333 pricing_attribute90,
334 pricing_attribute91,
335 pricing_attribute92,
336 pricing_attribute93,
337 pricing_attribute94,
338 pricing_attribute95,
339 pricing_attribute96,
340 pricing_attribute97,
341 pricing_attribute98,
342 pricing_attribute99,
343 pricing_attribute100,
344 qualifier_context,
345 qualifier_attribute1,
346 qualifier_attribute2,
347 created_by,
348 qualifier_attribute3,
349 creation_date,
350 qualifier_attribute4,
351 qualifier_attribute5,
352 last_updated_by,
353 qualifier_attribute6,
354 last_update_date,
355 qualifier_attribute7,
356 qualifier_attribute8,
357 qualifier_attribute9,
358 qualifier_attribute10,
359 qualifier_attribute11,
360 qualifier_attribute12,
361 qualifier_attribute13,
362 qualifier_attribute14,
363 qualifier_attribute15,
364 qualifier_attribute16,
365 qualifier_attribute17,
366 qualifier_attribute18,
367 qualifier_attribute19,
368 qualifier_attribute20,
369 qualifier_attribute21,
370 qualifier_attribute22,
371 qualifier_attribute23,
372 qualifier_attribute24,
373 qualifier_attribute25,
374 qualifier_attribute26,
375 qualifier_attribute27,
376 qualifier_attribute28,
377 qualifier_attribute29,
378 qualifier_attribute30,
379 qualifier_attribute31,
380 qualifier_attribute32,
381 qualifier_attribute33,
382 qualifier_attribute34,
383 qualifier_attribute35,
384 qualifier_attribute36,
385 qualifier_attribute37,
386 qualifier_attribute38,
387 qualifier_attribute39,
388 qualifier_attribute40,
389 qualifier_attribute41,
390 qualifier_attribute42,
391 qualifier_attribute43,
392 qualifier_attribute44,
393 qualifier_attribute45,
394 qualifier_attribute46,
395 qualifier_attribute47,
396 qualifier_attribute48,
397 qualifier_attribute49,
398 qualifier_attribute50,
399 qualifier_attribute51,
400 qualifier_attribute52,
401 qualifier_attribute53,
402 qualifier_attribute54,
403 qualifier_attribute55,
404 qualifier_attribute56,
405 qualifier_attribute57,
406 qualifier_attribute58,
407 qualifier_attribute59,
408 qualifier_attribute60,
409 qualifier_attribute61,
410 qualifier_attribute62,
411 qualifier_attribute63,
412 qualifier_attribute64,
413 qualifier_attribute65,
414 qualifier_attribute66,
415 qualifier_attribute67,
416 qualifier_attribute68,
417 qualifier_attribute69,
418 qualifier_attribute70,
419 qualifier_attribute71,
420 qualifier_attribute72,
421 qualifier_attribute73,
422 qualifier_attribute74,
423 qualifier_attribute75,
424 qualifier_attribute76,
425 qualifier_attribute77,
426 qualifier_attribute78,
427 qualifier_attribute79,
428 qualifier_attribute80,
429 qualifier_attribute81,
430 qualifier_attribute82,
431 qualifier_attribute83,
432 qualifier_attribute84,
433 qualifier_attribute85,
434 qualifier_attribute86,
435 qualifier_attribute87,
436 qualifier_attribute88,
437 qualifier_attribute89,
438 qualifier_attribute90,
439 qualifier_attribute91,
440 qualifier_attribute92,
441 qualifier_attribute93,
442 qualifier_attribute94,
443 qualifier_attribute95,
444 qualifier_attribute96,
445 qualifier_attribute97,
446 qualifier_attribute98,
447 qualifier_attribute99,
448 qualifier_attribute100,
449 last_update_login,
450 program_application_id,
451 program_id,
452 program_update_date,
453 request_id,
454 object_version_number
455 )
456 SELECT
457
458 id,
459 flex_title,
460 pricing_context,
461 pricing_attribute1,
462 chr_id,
463 pricing_attribute2,
464 cle_id,
465 pricing_attribute3,
466 pricing_attribute4,
467 pricing_attribute5,
468 pricing_attribute6,
469 pricing_attribute7,
470 pricing_attribute8,
471 pricing_attribute9,
472 pricing_attribute10,
473 pricing_attribute11,
474 pricing_attribute12,
475 pricing_attribute13,
476 pricing_attribute14,
477 pricing_attribute15,
478 pricing_attribute16,
479 pricing_attribute17,
480 pricing_attribute18,
481 pricing_attribute19,
482 pricing_attribute20,
483 pricing_attribute21,
484 pricing_attribute22,
485 pricing_attribute23,
486 pricing_attribute24,
487 pricing_attribute25,
488 pricing_attribute26,
489 pricing_attribute27,
490 pricing_attribute28,
491 pricing_attribute29,
492 pricing_attribute30,
493 pricing_attribute31,
494 pricing_attribute32,
495 pricing_attribute33,
496 pricing_attribute34,
497 pricing_attribute35,
498 pricing_attribute36,
499 pricing_attribute37,
500 pricing_attribute38,
501 pricing_attribute39,
502 pricing_attribute40,
503 pricing_attribute41,
504 pricing_attribute42,
505 pricing_attribute43,
506 pricing_attribute44,
507 pricing_attribute45,
508 pricing_attribute46,
509 pricing_attribute47,
510 pricing_attribute48,
511 pricing_attribute49,
512 pricing_attribute50,
513 pricing_attribute51,
514 pricing_attribute52,
515 pricing_attribute53,
516 pricing_attribute54,
517 pricing_attribute55,
518 pricing_attribute56,
519 pricing_attribute57,
520 pricing_attribute58,
521 pricing_attribute59,
522 pricing_attribute60,
523 pricing_attribute61,
524 pricing_attribute62,
525 pricing_attribute63,
526 pricing_attribute64,
527 pricing_attribute65,
528 pricing_attribute66,
529 pricing_attribute67,
530 pricing_attribute68,
531 pricing_attribute69,
532 pricing_attribute70,
533 pricing_attribute71,
534 pricing_attribute72,
535 pricing_attribute73,
536 pricing_attribute74,
537 pricing_attribute75,
538 pricing_attribute76,
539 pricing_attribute77,
540 pricing_attribute78,
541 pricing_attribute79,
542 pricing_attribute80,
543 pricing_attribute81,
544 pricing_attribute82,
545 pricing_attribute83,
546 pricing_attribute84,
547 pricing_attribute85,
548 pricing_attribute86,
549 pricing_attribute87,
550 pricing_attribute88,
551 pricing_attribute89,
552 pricing_attribute90,
553 pricing_attribute91,
554 pricing_attribute92,
555 pricing_attribute93,
556 pricing_attribute94,
557 pricing_attribute95,
558 pricing_attribute96,
559 pricing_attribute97,
560 pricing_attribute98,
561 pricing_attribute99,
562 pricing_attribute100,
563 qualifier_context,
564 qualifier_attribute1,
565 qualifier_attribute2,
566 created_by,
567 qualifier_attribute3,
568 creation_date,
569 qualifier_attribute4,
570 qualifier_attribute5,
571 last_updated_by,
572 qualifier_attribute6,
573 last_update_date,
574 qualifier_attribute7,
575 qualifier_attribute8,
576 qualifier_attribute9,
577 qualifier_attribute10,
578 qualifier_attribute11,
579 qualifier_attribute12,
580 qualifier_attribute13,
581 qualifier_attribute14,
582 qualifier_attribute15,
583 qualifier_attribute16,
584 qualifier_attribute17,
585 qualifier_attribute18,
586 qualifier_attribute19,
587 qualifier_attribute20,
588 qualifier_attribute21,
589 qualifier_attribute22,
590 qualifier_attribute23,
591 qualifier_attribute24,
592 qualifier_attribute25,
593 qualifier_attribute26,
594 qualifier_attribute27,
595 qualifier_attribute28,
596 qualifier_attribute29,
597 qualifier_attribute30,
598 qualifier_attribute31,
599 qualifier_attribute32,
600 qualifier_attribute33,
601 qualifier_attribute34,
602 qualifier_attribute35,
603 qualifier_attribute36,
604 qualifier_attribute37,
605 qualifier_attribute38,
606 qualifier_attribute39,
607 qualifier_attribute40,
608 qualifier_attribute41,
609 qualifier_attribute42,
610 qualifier_attribute43,
611 qualifier_attribute44,
612 qualifier_attribute45,
613 qualifier_attribute46,
614 qualifier_attribute47,
615 qualifier_attribute48,
616 qualifier_attribute49,
617 qualifier_attribute50,
618 qualifier_attribute51,
619 qualifier_attribute52,
620 qualifier_attribute53,
621 qualifier_attribute54,
622 qualifier_attribute55,
623 qualifier_attribute56,
624 qualifier_attribute57,
625 qualifier_attribute58,
626 qualifier_attribute59,
627 qualifier_attribute60,
628 qualifier_attribute61,
629 qualifier_attribute62,
630 qualifier_attribute63,
631 qualifier_attribute64,
632 qualifier_attribute65,
633 qualifier_attribute66,
634 qualifier_attribute67,
635 qualifier_attribute68,
636 qualifier_attribute69,
637 qualifier_attribute70,
638 qualifier_attribute71,
639 qualifier_attribute72,
640 qualifier_attribute73,
641 qualifier_attribute74,
642 qualifier_attribute75,
643 qualifier_attribute76,
644 qualifier_attribute77,
645 qualifier_attribute78,
646 qualifier_attribute79,
647 qualifier_attribute80,
648 qualifier_attribute81,
649 qualifier_attribute82,
650 qualifier_attribute83,
651 qualifier_attribute84,
652 qualifier_attribute85,
653 qualifier_attribute86,
654 qualifier_attribute87,
655 qualifier_attribute88,
656 qualifier_attribute89,
657 qualifier_attribute90,
658 qualifier_attribute91,
659 qualifier_attribute92,
660 qualifier_attribute93,
661 qualifier_attribute94,
662 qualifier_attribute95,
663 qualifier_attribute96,
664 qualifier_attribute97,
665 qualifier_attribute98,
666 qualifier_attribute99,
667 qualifier_attribute100,
668 last_update_login,
669 program_application_id,
670 program_id,
671 program_update_date,
672 request_id,
673 object_version_number
674 FROM okc_price_att_values_h
675 WHERE chr_id = p_chr_id
676 AND major_version = p_major_version
677 UNION /* bugfix 2138898 - OR is replaced by UNION */
678 SELECT
679 id,
680 flex_title,
681 pricing_context,
682 pricing_attribute1,
683 chr_id,
684 pricing_attribute2,
685 cle_id,
686 pricing_attribute3,
687 pricing_attribute4,
688 pricing_attribute5,
689 pricing_attribute6,
690 pricing_attribute7,
691 pricing_attribute8,
692 pricing_attribute9,
693 pricing_attribute10,
694 pricing_attribute11,
695 pricing_attribute12,
696 pricing_attribute13,
697 pricing_attribute14,
698 pricing_attribute15,
699 pricing_attribute16,
700 pricing_attribute17,
701 pricing_attribute18,
702 pricing_attribute19,
703 pricing_attribute20,
704 pricing_attribute21,
705 pricing_attribute22,
706 pricing_attribute23,
707 pricing_attribute24,
708 pricing_attribute25,
709 pricing_attribute26,
710 pricing_attribute27,
711 pricing_attribute28,
712 pricing_attribute29,
713 pricing_attribute30,
714 pricing_attribute31,
715 pricing_attribute32,
716 pricing_attribute33,
717 pricing_attribute34,
718 pricing_attribute35,
719 pricing_attribute36,
720 pricing_attribute37,
721 pricing_attribute38,
722 pricing_attribute39,
723 pricing_attribute40,
724 pricing_attribute41,
725 pricing_attribute42,
726 pricing_attribute43,
727 pricing_attribute44,
728 pricing_attribute45,
729 pricing_attribute46,
730 pricing_attribute47,
731 pricing_attribute48,
732 pricing_attribute49,
733 pricing_attribute50,
734 pricing_attribute51,
735 pricing_attribute52,
736 pricing_attribute53,
737 pricing_attribute54,
738 pricing_attribute55,
739 pricing_attribute56,
740 pricing_attribute57,
741 pricing_attribute58,
742 pricing_attribute59,
743 pricing_attribute60,
744 pricing_attribute61,
745 pricing_attribute62,
746 pricing_attribute63,
747 pricing_attribute64,
748 pricing_attribute65,
749 pricing_attribute66,
750 pricing_attribute67,
751 pricing_attribute68,
752 pricing_attribute69,
753 pricing_attribute70,
754 pricing_attribute71,
755 pricing_attribute72,
756 pricing_attribute73,
757 pricing_attribute74,
758 pricing_attribute75,
759 pricing_attribute76,
760 pricing_attribute77,
761 pricing_attribute78,
762 pricing_attribute79,
763 pricing_attribute80,
764 pricing_attribute81,
765 pricing_attribute82,
766 pricing_attribute83,
767 pricing_attribute84,
768 pricing_attribute85,
769 pricing_attribute86,
770 pricing_attribute87,
771 pricing_attribute88,
772 pricing_attribute89,
773 pricing_attribute90,
774 pricing_attribute91,
775 pricing_attribute92,
776 pricing_attribute93,
777 pricing_attribute94,
778 pricing_attribute95,
779 pricing_attribute96,
780 pricing_attribute97,
781 pricing_attribute98,
782 pricing_attribute99,
783 pricing_attribute100,
784 qualifier_context,
785 qualifier_attribute1,
786 qualifier_attribute2,
787 created_by,
788 qualifier_attribute3,
789 creation_date,
790 qualifier_attribute4,
791 qualifier_attribute5,
792 last_updated_by,
793 qualifier_attribute6,
794 last_update_date,
795 qualifier_attribute7,
796 qualifier_attribute8,
797 qualifier_attribute9,
798 qualifier_attribute10,
799 qualifier_attribute11,
800 qualifier_attribute12,
801 qualifier_attribute13,
802 qualifier_attribute14,
803 qualifier_attribute15,
804 qualifier_attribute16,
805 qualifier_attribute17,
806 qualifier_attribute18,
807 qualifier_attribute19,
808 qualifier_attribute20,
809 qualifier_attribute21,
810 qualifier_attribute22,
811 qualifier_attribute23,
812 qualifier_attribute24,
813 qualifier_attribute25,
814 qualifier_attribute26,
815 qualifier_attribute27,
816 qualifier_attribute28,
817 qualifier_attribute29,
818 qualifier_attribute30,
819 qualifier_attribute31,
820 qualifier_attribute32,
821 qualifier_attribute33,
822 qualifier_attribute34,
823 qualifier_attribute35,
824 qualifier_attribute36,
825 qualifier_attribute37,
826 qualifier_attribute38,
827 qualifier_attribute39,
828 qualifier_attribute40,
829 qualifier_attribute41,
830 qualifier_attribute42,
831 qualifier_attribute43,
832 qualifier_attribute44,
833 qualifier_attribute45,
834 qualifier_attribute46,
835 qualifier_attribute47,
836 qualifier_attribute48,
837 qualifier_attribute49,
838 qualifier_attribute50,
839 qualifier_attribute51,
840 qualifier_attribute52,
841 qualifier_attribute53,
842 qualifier_attribute54,
843 qualifier_attribute55,
844 qualifier_attribute56,
845 qualifier_attribute57,
846 qualifier_attribute58,
847 qualifier_attribute59,
848 qualifier_attribute60,
849 qualifier_attribute61,
850 qualifier_attribute62,
851 qualifier_attribute63,
852 qualifier_attribute64,
853 qualifier_attribute65,
854 qualifier_attribute66,
855 qualifier_attribute67,
856 qualifier_attribute68,
857 qualifier_attribute69,
858 qualifier_attribute70,
859 qualifier_attribute71,
860 qualifier_attribute72,
861 qualifier_attribute73,
862 qualifier_attribute74,
863 qualifier_attribute75,
864 qualifier_attribute76,
865 qualifier_attribute77,
866 qualifier_attribute78,
867 qualifier_attribute79,
868 qualifier_attribute80,
869 qualifier_attribute81,
870 qualifier_attribute82,
871 qualifier_attribute83,
872 qualifier_attribute84,
873 qualifier_attribute85,
874 qualifier_attribute86,
875 qualifier_attribute87,
876 qualifier_attribute88,
877 qualifier_attribute89,
878 qualifier_attribute90,
879 qualifier_attribute91,
880 qualifier_attribute92,
881 qualifier_attribute93,
882 qualifier_attribute94,
883 qualifier_attribute95,
884 qualifier_attribute96,
885 qualifier_attribute97,
886 qualifier_attribute98,
887 qualifier_attribute99,
888 qualifier_attribute100,
889 last_update_login,
890 program_application_id,
891 program_id,
892 program_update_date,
893 request_id,
894 object_version_number
895 FROM okc_price_att_values_h
896 WHERE cle_id IN
897 (SELECT id
898 FROM OKC_K_LINES_B
899 WHERE dnz_chr_id = p_chr_id
900 )
901 AND major_version = p_major_version;
902
903 RETURN l_return_status;
904 EXCEPTION
905 -- other appropriate handlers
906 WHEN OTHERS THEN
907 -- store SQL error message on message stack
908 OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
909 p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
910 p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
911 p_token1_value => sqlcode,
912 p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
913 p_token2_value => sqlerrm);
914
915 -- notify UNEXPECTED error
916 l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
917 return l_return_status;
918 END restore_version;
919 ---------------------------------------------------------------
920 -- Procedure for mass insert in OKC_PRICE_ATT_VALUES _B and TL tables
921 ---------------------------------------------------------------
922 PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_pavv_tbl OKC_PAV_PVT.pavv_tbl_type) IS
923 l_tabsize NUMBER := p_pavv_tbl.COUNT;
924 l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;
925
926 in_id OKC_DATATYPES.NumberTabTyp;
927 in_chr_id OKC_DATATYPES.NumberTabTyp;
928 in_cle_id OKC_DATATYPES.NumberTabTyp;
929 in_flex_title OKC_DATATYPES.Var200TabTyp;
930 in_pricing_context OKC_DATATYPES.Var90TabTyp;
931 in_pricing_attribute1 OKC_DATATYPES.Var1995TabTyp;
932 in_pricing_attribute2 OKC_DATATYPES.Var1995TabTyp;
933 in_pricing_attribute3 OKC_DATATYPES.Var1995TabTyp;
934 in_pricing_attribute4 OKC_DATATYPES.Var1995TabTyp;
935 in_pricing_attribute5 OKC_DATATYPES.Var1995TabTyp;
936 in_pricing_attribute6 OKC_DATATYPES.Var1995TabTyp;
937 in_pricing_attribute7 OKC_DATATYPES.Var1995TabTyp;
938 in_pricing_attribute8 OKC_DATATYPES.Var1995TabTyp;
939 in_pricing_attribute9 OKC_DATATYPES.Var1995TabTyp;
940 in_pricing_attribute10 OKC_DATATYPES.Var1995TabTyp;
941 in_pricing_attribute11 OKC_DATATYPES.Var1995TabTyp;
942 in_pricing_attribute12 OKC_DATATYPES.Var1995TabTyp;
943 in_pricing_attribute13 OKC_DATATYPES.Var1995TabTyp;
944 in_pricing_attribute14 OKC_DATATYPES.Var1995TabTyp;
945 in_pricing_attribute15 OKC_DATATYPES.Var1995TabTyp;
946 in_pricing_attribute16 OKC_DATATYPES.Var1995TabTyp;
947 in_pricing_attribute17 OKC_DATATYPES.Var1995TabTyp;
948 in_pricing_attribute18 OKC_DATATYPES.Var1995TabTyp;
949 in_pricing_attribute19 OKC_DATATYPES.Var1995TabTyp;
950 in_pricing_attribute20 OKC_DATATYPES.Var1995TabTyp;
951 in_pricing_attribute21 OKC_DATATYPES.Var1995TabTyp;
952 in_pricing_attribute22 OKC_DATATYPES.Var1995TabTyp;
953 in_pricing_attribute23 OKC_DATATYPES.Var1995TabTyp;
954 in_pricing_attribute24 OKC_DATATYPES.Var1995TabTyp;
955 in_pricing_attribute25 OKC_DATATYPES.Var1995TabTyp;
956 in_pricing_attribute26 OKC_DATATYPES.Var1995TabTyp;
957 in_pricing_attribute27 OKC_DATATYPES.Var1995TabTyp;
958 in_pricing_attribute28 OKC_DATATYPES.Var1995TabTyp;
959 in_pricing_attribute29 OKC_DATATYPES.Var1995TabTyp;
960 in_pricing_attribute30 OKC_DATATYPES.Var1995TabTyp;
961 in_pricing_attribute31 OKC_DATATYPES.Var1995TabTyp;
962 in_pricing_attribute32 OKC_DATATYPES.Var1995TabTyp;
963 in_pricing_attribute33 OKC_DATATYPES.Var1995TabTyp;
964 in_pricing_attribute34 OKC_DATATYPES.Var1995TabTyp;
965 in_pricing_attribute35 OKC_DATATYPES.Var1995TabTyp;
966 in_pricing_attribute36 OKC_DATATYPES.Var1995TabTyp;
967 in_pricing_attribute37 OKC_DATATYPES.Var1995TabTyp;
968 in_pricing_attribute38 OKC_DATATYPES.Var1995TabTyp;
969 in_pricing_attribute39 OKC_DATATYPES.Var1995TabTyp;
970 in_pricing_attribute40 OKC_DATATYPES.Var1995TabTyp;
971 in_pricing_attribute41 OKC_DATATYPES.Var1995TabTyp;
972 in_pricing_attribute42 OKC_DATATYPES.Var1995TabTyp;
973 in_pricing_attribute43 OKC_DATATYPES.Var1995TabTyp;
974 in_pricing_attribute44 OKC_DATATYPES.Var1995TabTyp;
975 in_pricing_attribute45 OKC_DATATYPES.Var1995TabTyp;
976 in_pricing_attribute46 OKC_DATATYPES.Var1995TabTyp;
977 in_pricing_attribute47 OKC_DATATYPES.Var1995TabTyp;
978 in_pricing_attribute48 OKC_DATATYPES.Var1995TabTyp;
979 in_pricing_attribute49 OKC_DATATYPES.Var1995TabTyp;
980 in_pricing_attribute50 OKC_DATATYPES.Var1995TabTyp;
981 in_pricing_attribute51 OKC_DATATYPES.Var1995TabTyp;
982 in_pricing_attribute52 OKC_DATATYPES.Var1995TabTyp;
983 in_pricing_attribute53 OKC_DATATYPES.Var1995TabTyp;
984 in_pricing_attribute54 OKC_DATATYPES.Var1995TabTyp;
985 in_pricing_attribute55 OKC_DATATYPES.Var1995TabTyp;
986 in_pricing_attribute56 OKC_DATATYPES.Var1995TabTyp;
987 in_pricing_attribute57 OKC_DATATYPES.Var1995TabTyp;
988 in_pricing_attribute58 OKC_DATATYPES.Var1995TabTyp;
989 in_pricing_attribute59 OKC_DATATYPES.Var1995TabTyp;
990 in_pricing_attribute60 OKC_DATATYPES.Var1995TabTyp;
991 in_pricing_attribute61 OKC_DATATYPES.Var1995TabTyp;
992 in_pricing_attribute62 OKC_DATATYPES.Var1995TabTyp;
993 in_pricing_attribute63 OKC_DATATYPES.Var1995TabTyp;
994 in_pricing_attribute64 OKC_DATATYPES.Var1995TabTyp;
995 in_pricing_attribute65 OKC_DATATYPES.Var1995TabTyp;
996 in_pricing_attribute66 OKC_DATATYPES.Var1995TabTyp;
997 in_pricing_attribute67 OKC_DATATYPES.Var1995TabTyp;
998 in_pricing_attribute68 OKC_DATATYPES.Var1995TabTyp;
999 in_pricing_attribute69 OKC_DATATYPES.Var1995TabTyp;
1000 in_pricing_attribute70 OKC_DATATYPES.Var1995TabTyp;
1001 in_pricing_attribute71 OKC_DATATYPES.Var1995TabTyp;
1002 in_pricing_attribute72 OKC_DATATYPES.Var1995TabTyp;
1003 in_pricing_attribute73 OKC_DATATYPES.Var1995TabTyp;
1004 in_pricing_attribute74 OKC_DATATYPES.Var1995TabTyp;
1005 in_pricing_attribute75 OKC_DATATYPES.Var1995TabTyp;
1006 in_pricing_attribute76 OKC_DATATYPES.Var1995TabTyp;
1007 in_pricing_attribute77 OKC_DATATYPES.Var1995TabTyp;
1008 in_pricing_attribute78 OKC_DATATYPES.Var1995TabTyp;
1009 in_pricing_attribute79 OKC_DATATYPES.Var1995TabTyp;
1010 in_pricing_attribute80 OKC_DATATYPES.Var1995TabTyp;
1011 in_pricing_attribute81 OKC_DATATYPES.Var1995TabTyp;
1012 in_pricing_attribute82 OKC_DATATYPES.Var1995TabTyp;
1013 in_pricing_attribute83 OKC_DATATYPES.Var1995TabTyp;
1014 in_pricing_attribute84 OKC_DATATYPES.Var1995TabTyp;
1015 in_pricing_attribute85 OKC_DATATYPES.Var1995TabTyp;
1016 in_pricing_attribute86 OKC_DATATYPES.Var1995TabTyp;
1017 in_pricing_attribute87 OKC_DATATYPES.Var1995TabTyp;
1018 in_pricing_attribute88 OKC_DATATYPES.Var1995TabTyp;
1019 in_pricing_attribute89 OKC_DATATYPES.Var1995TabTyp;
1020 in_pricing_attribute90 OKC_DATATYPES.Var1995TabTyp;
1021 in_pricing_attribute91 OKC_DATATYPES.Var1995TabTyp;
1022 in_pricing_attribute92 OKC_DATATYPES.Var1995TabTyp;
1023 in_pricing_attribute93 OKC_DATATYPES.Var1995TabTyp;
1024 in_pricing_attribute94 OKC_DATATYPES.Var1995TabTyp;
1025 in_pricing_attribute95 OKC_DATATYPES.Var1995TabTyp;
1026 in_pricing_attribute96 OKC_DATATYPES.Var1995TabTyp;
1027 in_pricing_attribute97 OKC_DATATYPES.Var1995TabTyp;
1028 in_pricing_attribute98 OKC_DATATYPES.Var1995TabTyp;
1029 in_pricing_attribute99 OKC_DATATYPES.Var1995TabTyp;
1030 in_pricing_attribute100 OKC_DATATYPES.Var1995TabTyp;
1031 in_qualifier_context OKC_DATATYPES.Var90TabTyp;
1032 in_qualifier_attribute1 OKC_DATATYPES.Var1995TabTyp;
1033 in_qualifier_attribute2 OKC_DATATYPES.Var1995TabTyp;
1034 in_qualifier_attribute3 OKC_DATATYPES.Var1995TabTyp;
1035 in_qualifier_attribute4 OKC_DATATYPES.Var1995TabTyp;
1036 in_qualifier_attribute5 OKC_DATATYPES.Var1995TabTyp;
1037 in_qualifier_attribute6 OKC_DATATYPES.Var1995TabTyp;
1038 in_qualifier_attribute7 OKC_DATATYPES.Var1995TabTyp;
1039 in_qualifier_attribute8 OKC_DATATYPES.Var1995TabTyp;
1040 in_qualifier_attribute9 OKC_DATATYPES.Var1995TabTyp;
1041 in_qualifier_attribute10 OKC_DATATYPES.Var1995TabTyp;
1042 in_qualifier_attribute11 OKC_DATATYPES.Var1995TabTyp;
1043 in_qualifier_attribute12 OKC_DATATYPES.Var1995TabTyp;
1044 in_qualifier_attribute13 OKC_DATATYPES.Var1995TabTyp;
1045 in_qualifier_attribute14 OKC_DATATYPES.Var1995TabTyp;
1046 in_qualifier_attribute15 OKC_DATATYPES.Var1995TabTyp;
1047 in_qualifier_attribute16 OKC_DATATYPES.Var1995TabTyp;
1048 in_qualifier_attribute17 OKC_DATATYPES.Var1995TabTyp;
1049 in_qualifier_attribute18 OKC_DATATYPES.Var1995TabTyp;
1050 in_qualifier_attribute19 OKC_DATATYPES.Var1995TabTyp;
1051 in_qualifier_attribute20 OKC_DATATYPES.Var1995TabTyp;
1052 in_qualifier_attribute21 OKC_DATATYPES.Var1995TabTyp;
1053 in_qualifier_attribute22 OKC_DATATYPES.Var1995TabTyp;
1054 in_qualifier_attribute23 OKC_DATATYPES.Var1995TabTyp;
1055 in_qualifier_attribute24 OKC_DATATYPES.Var1995TabTyp;
1056 in_qualifier_attribute25 OKC_DATATYPES.Var1995TabTyp;
1057 in_qualifier_attribute26 OKC_DATATYPES.Var1995TabTyp;
1058 in_qualifier_attribute27 OKC_DATATYPES.Var1995TabTyp;
1059 in_qualifier_attribute28 OKC_DATATYPES.Var1995TabTyp;
1060 in_qualifier_attribute29 OKC_DATATYPES.Var1995TabTyp;
1061 in_qualifier_attribute30 OKC_DATATYPES.Var1995TabTyp;
1062 in_qualifier_attribute31 OKC_DATATYPES.Var1995TabTyp;
1063 in_qualifier_attribute32 OKC_DATATYPES.Var1995TabTyp;
1064 in_qualifier_attribute33 OKC_DATATYPES.Var1995TabTyp;
1065 in_qualifier_attribute34 OKC_DATATYPES.Var1995TabTyp;
1066 in_qualifier_attribute35 OKC_DATATYPES.Var1995TabTyp;
1067 in_qualifier_attribute36 OKC_DATATYPES.Var1995TabTyp;
1068 in_qualifier_attribute37 OKC_DATATYPES.Var1995TabTyp;
1069 in_qualifier_attribute38 OKC_DATATYPES.Var1995TabTyp;
1070 in_qualifier_attribute39 OKC_DATATYPES.Var1995TabTyp;
1071 in_qualifier_attribute40 OKC_DATATYPES.Var1995TabTyp;
1072 in_qualifier_attribute41 OKC_DATATYPES.Var1995TabTyp;
1073 in_qualifier_attribute42 OKC_DATATYPES.Var1995TabTyp;
1074 in_qualifier_attribute43 OKC_DATATYPES.Var1995TabTyp;
1075 in_qualifier_attribute44 OKC_DATATYPES.Var1995TabTyp;
1076 in_qualifier_attribute45 OKC_DATATYPES.Var1995TabTyp;
1077 in_qualifier_attribute46 OKC_DATATYPES.Var1995TabTyp;
1078 in_qualifier_attribute47 OKC_DATATYPES.Var1995TabTyp;
1079 in_qualifier_attribute48 OKC_DATATYPES.Var1995TabTyp;
1080 in_qualifier_attribute49 OKC_DATATYPES.Var1995TabTyp;
1081 in_qualifier_attribute50 OKC_DATATYPES.Var1995TabTyp;
1082 in_qualifier_attribute51 OKC_DATATYPES.Var1995TabTyp;
1083 in_qualifier_attribute52 OKC_DATATYPES.Var1995TabTyp;
1084 in_qualifier_attribute53 OKC_DATATYPES.Var1995TabTyp;
1085 in_qualifier_attribute54 OKC_DATATYPES.Var1995TabTyp;
1086 in_qualifier_attribute55 OKC_DATATYPES.Var1995TabTyp;
1087 in_qualifier_attribute56 OKC_DATATYPES.Var1995TabTyp;
1088 in_qualifier_attribute57 OKC_DATATYPES.Var1995TabTyp;
1089 in_qualifier_attribute58 OKC_DATATYPES.Var1995TabTyp;
1090 in_qualifier_attribute59 OKC_DATATYPES.Var1995TabTyp;
1091 in_qualifier_attribute60 OKC_DATATYPES.Var1995TabTyp;
1092 in_qualifier_attribute61 OKC_DATATYPES.Var1995TabTyp;
1093 in_qualifier_attribute62 OKC_DATATYPES.Var1995TabTyp;
1094 in_qualifier_attribute63 OKC_DATATYPES.Var1995TabTyp;
1095 in_qualifier_attribute64 OKC_DATATYPES.Var1995TabTyp;
1096 in_qualifier_attribute65 OKC_DATATYPES.Var1995TabTyp;
1097 in_qualifier_attribute66 OKC_DATATYPES.Var1995TabTyp;
1098 in_qualifier_attribute67 OKC_DATATYPES.Var1995TabTyp;
1099 in_qualifier_attribute68 OKC_DATATYPES.Var1995TabTyp;
1100 in_qualifier_attribute69 OKC_DATATYPES.Var1995TabTyp;
1101 in_qualifier_attribute70 OKC_DATATYPES.Var1995TabTyp;
1102 in_qualifier_attribute71 OKC_DATATYPES.Var1995TabTyp;
1103 in_qualifier_attribute72 OKC_DATATYPES.Var1995TabTyp;
1104 in_qualifier_attribute73 OKC_DATATYPES.Var1995TabTyp;
1105 in_qualifier_attribute74 OKC_DATATYPES.Var1995TabTyp;
1106 in_qualifier_attribute75 OKC_DATATYPES.Var1995TabTyp;
1107 in_qualifier_attribute76 OKC_DATATYPES.Var1995TabTyp;
1108 in_qualifier_attribute77 OKC_DATATYPES.Var1995TabTyp;
1109 in_qualifier_attribute78 OKC_DATATYPES.Var1995TabTyp;
1110 in_qualifier_attribute79 OKC_DATATYPES.Var1995TabTyp;
1111 in_qualifier_attribute80 OKC_DATATYPES.Var1995TabTyp;
1112 in_qualifier_attribute81 OKC_DATATYPES.Var1995TabTyp;
1113 in_qualifier_attribute82 OKC_DATATYPES.Var1995TabTyp;
1114 in_qualifier_attribute83 OKC_DATATYPES.Var1995TabTyp;
1115 in_qualifier_attribute84 OKC_DATATYPES.Var1995TabTyp;
1116 in_qualifier_attribute85 OKC_DATATYPES.Var1995TabTyp;
1117 in_qualifier_attribute86 OKC_DATATYPES.Var1995TabTyp;
1118 in_qualifier_attribute87 OKC_DATATYPES.Var1995TabTyp;
1119 in_qualifier_attribute88 OKC_DATATYPES.Var1995TabTyp;
1120 in_qualifier_attribute89 OKC_DATATYPES.Var1995TabTyp;
1121 in_qualifier_attribute90 OKC_DATATYPES.Var1995TabTyp;
1122 in_qualifier_attribute91 OKC_DATATYPES.Var1995TabTyp;
1123 in_qualifier_attribute92 OKC_DATATYPES.Var1995TabTyp;
1124 in_qualifier_attribute93 OKC_DATATYPES.Var1995TabTyp;
1125 in_qualifier_attribute94 OKC_DATATYPES.Var1995TabTyp;
1126 in_qualifier_attribute95 OKC_DATATYPES.Var1995TabTyp;
1127 in_qualifier_attribute96 OKC_DATATYPES.Var1995TabTyp;
1128 in_qualifier_attribute97 OKC_DATATYPES.Var1995TabTyp;
1129 in_qualifier_attribute98 OKC_DATATYPES.Var1995TabTyp;
1130 in_qualifier_attribute99 OKC_DATATYPES.Var1995TabTyp;
1131 in_qualifier_attribute100 OKC_DATATYPES.Var1995TabTyp;
1132 in_created_by OKC_DATATYPES.NumberTabTyp;
1133 in_creation_date OKC_DATATYPES.DateTabTyp;
1134 in_last_updated_by OKC_DATATYPES.NumberTabTyp;
1135 in_last_update_date OKC_DATATYPES.DateTabTyp;
1136 in_last_update_login OKC_DATATYPES.NumberTabTyp;
1137 in_program_application_id OKC_DATATYPES.NumberTabTyp;
1138 in_program_id OKC_DATATYPES.NumberTabTyp;
1139 in_program_update_date OKC_DATATYPES.DateTabTyp;
1140 in_request_id OKC_DATATYPES.NumberTabTyp;
1141 in_object_version_number OKC_DATATYPES.NumberTabTyp;
1142 i number;
1143 j number;
1144 BEGIN
1145 --Initialize return status
1146 x_return_status :=OKC_API.G_RET_STS_SUCCESS;
1147 i := p_pavv_tbl.FIRST; j:=0;
1148 while i is not null
1149 LOOP
1150 j:=j+1;
1151 in_id (j) := p_pavv_tbl(i).id;
1152 in_chr_id (j) := p_pavv_tbl(i).chr_id;
1153 in_cle_id (j) := p_pavv_tbl(i).cle_id;
1154 in_flex_title (j) := p_pavv_tbl(i).flex_title;
1155 in_pricing_context (j) := p_pavv_tbl(i).pricing_context;
1156 in_pricing_attribute1 (j) := p_pavv_tbl(i).pricing_attribute1;
1157 in_pricing_attribute2 (j) := p_pavv_tbl(i).pricing_attribute2;
1158 in_pricing_attribute3 (j) := p_pavv_tbl(i).pricing_attribute3;
1159 in_pricing_attribute4 (j) := p_pavv_tbl(i).pricing_attribute4;
1160 in_pricing_attribute5 (j) := p_pavv_tbl(i).pricing_attribute5;
1161 in_pricing_attribute6 (j) := p_pavv_tbl(i).pricing_attribute6;
1162 in_pricing_attribute7 (j) := p_pavv_tbl(i).pricing_attribute7;
1163 in_pricing_attribute8 (j) := p_pavv_tbl(i).pricing_attribute8;
1164 in_pricing_attribute9 (j) := p_pavv_tbl(i).pricing_attribute9;
1165 in_pricing_attribute10 (j) := p_pavv_tbl(i).pricing_attribute10;
1166 in_pricing_attribute11 (j) := p_pavv_tbl(i).pricing_attribute11;
1167 in_pricing_attribute12 (j) := p_pavv_tbl(i).pricing_attribute12;
1168 in_pricing_attribute13 (j) := p_pavv_tbl(i).pricing_attribute13;
1169 in_pricing_attribute14 (j) := p_pavv_tbl(i).pricing_attribute14;
1170 in_pricing_attribute15 (j) := p_pavv_tbl(i).pricing_attribute15;
1171 in_pricing_attribute16 (j) := p_pavv_tbl(i).pricing_attribute16;
1172 in_pricing_attribute17 (j) := p_pavv_tbl(i).pricing_attribute17;
1173 in_pricing_attribute18 (j) := p_pavv_tbl(i).pricing_attribute18;
1174 in_pricing_attribute19 (j) := p_pavv_tbl(i).pricing_attribute19;
1175 in_pricing_attribute20 (j) := p_pavv_tbl(i).pricing_attribute20;
1176 in_pricing_attribute21 (j) := p_pavv_tbl(i).pricing_attribute21;
1177 in_pricing_attribute22 (j) := p_pavv_tbl(i).pricing_attribute22;
1178 in_pricing_attribute23 (j) := p_pavv_tbl(i).pricing_attribute23;
1179 in_pricing_attribute24 (j) := p_pavv_tbl(i).pricing_attribute24;
1180 in_pricing_attribute25 (j) := p_pavv_tbl(i).pricing_attribute25;
1181 in_pricing_attribute26 (j) := p_pavv_tbl(i).pricing_attribute26;
1182 in_pricing_attribute27 (j) := p_pavv_tbl(i).pricing_attribute27;
1183 in_pricing_attribute28 (j) := p_pavv_tbl(i).pricing_attribute28;
1184 in_pricing_attribute29 (j) := p_pavv_tbl(i).pricing_attribute29;
1185 in_pricing_attribute30 (j) := p_pavv_tbl(i).pricing_attribute30;
1186 in_pricing_attribute31 (j) := p_pavv_tbl(i).pricing_attribute31;
1187 in_pricing_attribute32 (j) := p_pavv_tbl(i).pricing_attribute32;
1188 in_pricing_attribute33 (j) := p_pavv_tbl(i).pricing_attribute33;
1189 in_pricing_attribute34 (j) := p_pavv_tbl(i).pricing_attribute34;
1190 in_pricing_attribute35 (j) := p_pavv_tbl(i).pricing_attribute35;
1191 in_pricing_attribute36 (j) := p_pavv_tbl(i).pricing_attribute36;
1192 in_pricing_attribute37 (j) := p_pavv_tbl(i).pricing_attribute37;
1193 in_pricing_attribute38 (j) := p_pavv_tbl(i).pricing_attribute38;
1194 in_pricing_attribute39 (j) := p_pavv_tbl(i).pricing_attribute39;
1195 in_pricing_attribute40 (j) := p_pavv_tbl(i).pricing_attribute40;
1196 in_pricing_attribute41 (j) := p_pavv_tbl(i).pricing_attribute41;
1197 in_pricing_attribute42 (j) := p_pavv_tbl(i).pricing_attribute42;
1198 in_pricing_attribute43 (j) := p_pavv_tbl(i).pricing_attribute43;
1199 in_pricing_attribute44 (j) := p_pavv_tbl(i).pricing_attribute44;
1200 in_pricing_attribute45 (j) := p_pavv_tbl(i).pricing_attribute45;
1201 in_pricing_attribute46 (j) := p_pavv_tbl(i).pricing_attribute46;
1202 in_pricing_attribute47 (j) := p_pavv_tbl(i).pricing_attribute47;
1203 in_pricing_attribute48 (j) := p_pavv_tbl(i).pricing_attribute48;
1204 in_pricing_attribute49 (j) := p_pavv_tbl(i).pricing_attribute49;
1205 in_pricing_attribute50 (j) := p_pavv_tbl(i).pricing_attribute50;
1206 in_pricing_attribute51 (j) := p_pavv_tbl(i).pricing_attribute51;
1207 in_pricing_attribute52 (j) := p_pavv_tbl(i).pricing_attribute52;
1208 in_pricing_attribute53 (j) := p_pavv_tbl(i).pricing_attribute53;
1209 in_pricing_attribute54 (j) := p_pavv_tbl(i).pricing_attribute54;
1210 in_pricing_attribute55 (j) := p_pavv_tbl(i).pricing_attribute55;
1211 in_pricing_attribute56 (j) := p_pavv_tbl(i).pricing_attribute56;
1212 in_pricing_attribute57 (j) := p_pavv_tbl(i).pricing_attribute57;
1213 in_pricing_attribute58 (j) := p_pavv_tbl(i).pricing_attribute58;
1214 in_pricing_attribute59 (j) := p_pavv_tbl(i).pricing_attribute59;
1215 in_pricing_attribute60 (j) := p_pavv_tbl(i).pricing_attribute60;
1216 in_pricing_attribute61 (j) := p_pavv_tbl(i).pricing_attribute61;
1217 in_pricing_attribute62 (j) := p_pavv_tbl(i).pricing_attribute62;
1218 in_pricing_attribute63 (j) := p_pavv_tbl(i).pricing_attribute63;
1219 in_pricing_attribute64 (j) := p_pavv_tbl(i).pricing_attribute64;
1220 in_pricing_attribute65 (j) := p_pavv_tbl(i).pricing_attribute65;
1221 in_pricing_attribute66 (j) := p_pavv_tbl(i).pricing_attribute66;
1222 in_pricing_attribute67 (j) := p_pavv_tbl(i).pricing_attribute67;
1223 in_pricing_attribute68 (j) := p_pavv_tbl(i).pricing_attribute68;
1224 in_pricing_attribute69 (j) := p_pavv_tbl(i).pricing_attribute69;
1225 in_pricing_attribute70 (j) := p_pavv_tbl(i).pricing_attribute70;
1226 in_pricing_attribute71 (j) := p_pavv_tbl(i).pricing_attribute71;
1227 in_pricing_attribute72 (j) := p_pavv_tbl(i).pricing_attribute72;
1228 in_pricing_attribute73 (j) := p_pavv_tbl(i).pricing_attribute73;
1229 in_pricing_attribute74 (j) := p_pavv_tbl(i).pricing_attribute74;
1230 in_pricing_attribute75 (j) := p_pavv_tbl(i).pricing_attribute75;
1231 in_pricing_attribute76 (j) := p_pavv_tbl(i).pricing_attribute76;
1232 in_pricing_attribute77 (j) := p_pavv_tbl(i).pricing_attribute77;
1233 in_pricing_attribute78 (j) := p_pavv_tbl(i).pricing_attribute78;
1234 in_pricing_attribute79 (j) := p_pavv_tbl(i).pricing_attribute79;
1235 in_pricing_attribute80 (j) := p_pavv_tbl(i).pricing_attribute80;
1236 in_pricing_attribute81 (j) := p_pavv_tbl(i).pricing_attribute81;
1237 in_pricing_attribute82 (j) := p_pavv_tbl(i).pricing_attribute82;
1238 in_pricing_attribute83 (j) := p_pavv_tbl(i).pricing_attribute83;
1239 in_pricing_attribute84 (j) := p_pavv_tbl(i).pricing_attribute84;
1240 in_pricing_attribute85 (j) := p_pavv_tbl(i).pricing_attribute85;
1241 in_pricing_attribute86 (j) := p_pavv_tbl(i).pricing_attribute86;
1242 in_pricing_attribute87 (j) := p_pavv_tbl(i).pricing_attribute87;
1243 in_pricing_attribute88 (j) := p_pavv_tbl(i).pricing_attribute88;
1244 in_pricing_attribute89 (j) := p_pavv_tbl(i).pricing_attribute89;
1245 in_pricing_attribute90 (j) := p_pavv_tbl(i).pricing_attribute90;
1246 in_pricing_attribute91 (j) := p_pavv_tbl(i).pricing_attribute91;
1247 in_pricing_attribute92 (j) := p_pavv_tbl(i).pricing_attribute92;
1248 in_pricing_attribute93 (j) := p_pavv_tbl(i).pricing_attribute93;
1249 in_pricing_attribute94 (j) := p_pavv_tbl(i).pricing_attribute94;
1250 in_pricing_attribute95 (j) := p_pavv_tbl(i).pricing_attribute95;
1251 in_pricing_attribute96 (j) := p_pavv_tbl(i).pricing_attribute96;
1252 in_pricing_attribute97 (j) := p_pavv_tbl(i).pricing_attribute97;
1253 in_pricing_attribute98 (j) := p_pavv_tbl(i).pricing_attribute98;
1254 in_pricing_attribute99 (j) := p_pavv_tbl(i).pricing_attribute99;
1255 in_pricing_attribute100 (j) := p_pavv_tbl(i).pricing_attribute100;
1256 in_qualifier_context (j) := p_pavv_tbl(i).qualifier_context;
1257 in_qualifier_attribute1 (j) := p_pavv_tbl(i).qualifier_attribute1;
1258 in_qualifier_attribute2 (j) := p_pavv_tbl(i).qualifier_attribute2;
1259 in_qualifier_attribute3 (j) := p_pavv_tbl(i).qualifier_attribute3;
1260 in_qualifier_attribute4 (j) := p_pavv_tbl(i).qualifier_attribute4;
1261 in_qualifier_attribute5 (j) := p_pavv_tbl(i).qualifier_attribute5;
1262 in_qualifier_attribute6 (j) := p_pavv_tbl(i).qualifier_attribute6;
1263 in_qualifier_attribute7 (j) := p_pavv_tbl(i).qualifier_attribute7;
1264 in_qualifier_attribute8 (j) := p_pavv_tbl(i).qualifier_attribute8;
1265 in_qualifier_attribute9 (j) := p_pavv_tbl(i).qualifier_attribute9;
1266 in_qualifier_attribute10 (j) := p_pavv_tbl(i).qualifier_attribute10;
1267 in_qualifier_attribute11 (j) := p_pavv_tbl(i).qualifier_attribute11;
1268 in_qualifier_attribute12 (j) := p_pavv_tbl(i).qualifier_attribute12;
1269 in_qualifier_attribute13 (j) := p_pavv_tbl(i).qualifier_attribute13;
1270 in_qualifier_attribute14 (j) := p_pavv_tbl(i).qualifier_attribute14;
1271 in_qualifier_attribute15 (j) := p_pavv_tbl(i).qualifier_attribute15;
1272 in_qualifier_attribute16 (j) := p_pavv_tbl(i).qualifier_attribute16;
1273 in_qualifier_attribute17 (j) := p_pavv_tbl(i).qualifier_attribute17;
1274 in_qualifier_attribute18 (j) := p_pavv_tbl(i).qualifier_attribute18;
1275 in_qualifier_attribute19 (j) := p_pavv_tbl(i).qualifier_attribute19;
1276 in_qualifier_attribute20 (j) := p_pavv_tbl(i).qualifier_attribute20;
1277 in_qualifier_attribute21 (j) := p_pavv_tbl(i).qualifier_attribute21;
1278 in_qualifier_attribute22 (j) := p_pavv_tbl(i).qualifier_attribute22;
1279 in_qualifier_attribute23 (j) := p_pavv_tbl(i).qualifier_attribute23;
1280 in_qualifier_attribute24 (j) := p_pavv_tbl(i).qualifier_attribute24;
1281 in_qualifier_attribute25 (j) := p_pavv_tbl(i).qualifier_attribute25;
1282 in_qualifier_attribute26 (j) := p_pavv_tbl(i).qualifier_attribute26;
1283 in_qualifier_attribute27 (j) := p_pavv_tbl(i).qualifier_attribute27;
1284 in_qualifier_attribute28 (j) := p_pavv_tbl(i).qualifier_attribute28;
1285 in_qualifier_attribute29 (j) := p_pavv_tbl(i).qualifier_attribute29;
1286 in_qualifier_attribute30 (j) := p_pavv_tbl(i).qualifier_attribute30;
1287 in_qualifier_attribute31 (j) := p_pavv_tbl(i).qualifier_attribute31;
1288 in_qualifier_attribute32 (j) := p_pavv_tbl(i).qualifier_attribute32;
1289 in_qualifier_attribute33 (j) := p_pavv_tbl(i).qualifier_attribute33;
1290 in_qualifier_attribute34 (j) := p_pavv_tbl(i).qualifier_attribute34;
1291 in_qualifier_attribute35 (j) := p_pavv_tbl(i).qualifier_attribute35;
1292 in_qualifier_attribute36 (j) := p_pavv_tbl(i).qualifier_attribute36;
1293 in_qualifier_attribute37 (j) := p_pavv_tbl(i).qualifier_attribute37;
1294 in_qualifier_attribute38 (j) := p_pavv_tbl(i).qualifier_attribute38;
1295 in_qualifier_attribute39 (j) := p_pavv_tbl(i).qualifier_attribute39;
1296 in_qualifier_attribute40 (j) := p_pavv_tbl(i).qualifier_attribute40;
1297 in_qualifier_attribute41 (j) := p_pavv_tbl(i).qualifier_attribute41;
1298 in_qualifier_attribute42 (j) := p_pavv_tbl(i).qualifier_attribute42;
1299 in_qualifier_attribute43 (j) := p_pavv_tbl(i).qualifier_attribute43;
1300 in_qualifier_attribute44 (j) := p_pavv_tbl(i).qualifier_attribute44;
1301 in_qualifier_attribute45 (j) := p_pavv_tbl(i).qualifier_attribute45;
1302 in_qualifier_attribute46 (j) := p_pavv_tbl(i).qualifier_attribute46;
1303 in_qualifier_attribute47 (j) := p_pavv_tbl(i).qualifier_attribute47;
1304 in_qualifier_attribute48 (j) := p_pavv_tbl(i).qualifier_attribute48;
1305 in_qualifier_attribute49 (j) := p_pavv_tbl(i).qualifier_attribute49;
1306 in_qualifier_attribute50 (j) := p_pavv_tbl(i).qualifier_attribute50;
1307 in_qualifier_attribute51 (j) := p_pavv_tbl(i).qualifier_attribute51;
1308 in_qualifier_attribute52 (j) := p_pavv_tbl(i).qualifier_attribute52;
1309 in_qualifier_attribute53 (j) := p_pavv_tbl(i).qualifier_attribute53;
1310 in_qualifier_attribute54 (j) := p_pavv_tbl(i).qualifier_attribute54;
1311 in_qualifier_attribute55 (j) := p_pavv_tbl(i).qualifier_attribute55;
1312 in_qualifier_attribute56 (j) := p_pavv_tbl(i).qualifier_attribute56;
1313 in_qualifier_attribute57 (j) := p_pavv_tbl(i).qualifier_attribute57;
1314 in_qualifier_attribute58 (j) := p_pavv_tbl(i).qualifier_attribute58;
1315 in_qualifier_attribute59 (j) := p_pavv_tbl(i).qualifier_attribute59;
1316 in_qualifier_attribute60 (j) := p_pavv_tbl(i).qualifier_attribute60;
1317 in_qualifier_attribute61 (j) := p_pavv_tbl(i).qualifier_attribute61;
1318 in_qualifier_attribute62 (j) := p_pavv_tbl(i).qualifier_attribute62;
1319 in_qualifier_attribute63 (j) := p_pavv_tbl(i).qualifier_attribute63;
1320 in_qualifier_attribute64 (j) := p_pavv_tbl(i).qualifier_attribute64;
1321 in_qualifier_attribute65 (j) := p_pavv_tbl(i).qualifier_attribute65;
1322 in_qualifier_attribute66 (j) := p_pavv_tbl(i).qualifier_attribute66;
1323 in_qualifier_attribute67 (j) := p_pavv_tbl(i).qualifier_attribute67;
1324 in_qualifier_attribute68 (j) := p_pavv_tbl(i).qualifier_attribute68;
1325 in_qualifier_attribute69 (j) := p_pavv_tbl(i).qualifier_attribute69;
1326 in_qualifier_attribute70 (j) := p_pavv_tbl(i).qualifier_attribute70;
1327 in_qualifier_attribute71 (j) := p_pavv_tbl(i).qualifier_attribute71;
1328 in_qualifier_attribute72 (j) := p_pavv_tbl(i).qualifier_attribute72;
1329 in_qualifier_attribute73 (j) := p_pavv_tbl(i).qualifier_attribute73;
1330 in_qualifier_attribute74 (j) := p_pavv_tbl(i).qualifier_attribute74;
1331 in_qualifier_attribute75 (j) := p_pavv_tbl(i).qualifier_attribute75;
1332 in_qualifier_attribute76 (j) := p_pavv_tbl(i).qualifier_attribute76;
1333 in_qualifier_attribute77 (j) := p_pavv_tbl(i).qualifier_attribute77;
1334 in_qualifier_attribute78 (j) := p_pavv_tbl(i).qualifier_attribute78;
1335 in_qualifier_attribute79 (j) := p_pavv_tbl(i).qualifier_attribute79;
1336 in_qualifier_attribute80 (j) := p_pavv_tbl(i).qualifier_attribute80;
1337 in_qualifier_attribute81 (j) := p_pavv_tbl(i).qualifier_attribute81;
1338 in_qualifier_attribute82 (j) := p_pavv_tbl(i).qualifier_attribute82;
1339 in_qualifier_attribute83 (j) := p_pavv_tbl(i).qualifier_attribute83;
1340 in_qualifier_attribute84 (j) := p_pavv_tbl(i).qualifier_attribute84;
1341 in_qualifier_attribute85 (j) := p_pavv_tbl(i).qualifier_attribute85;
1342 in_qualifier_attribute86 (j) := p_pavv_tbl(i).qualifier_attribute86;
1343 in_qualifier_attribute87 (j) := p_pavv_tbl(i).qualifier_attribute87;
1344 in_qualifier_attribute88 (j) := p_pavv_tbl(i).qualifier_attribute88;
1345 in_qualifier_attribute89 (j) := p_pavv_tbl(i).qualifier_attribute89;
1346 in_qualifier_attribute90 (j) := p_pavv_tbl(i).qualifier_attribute90;
1347 in_qualifier_attribute91 (j) := p_pavv_tbl(i).qualifier_attribute91;
1348 in_qualifier_attribute92 (j) := p_pavv_tbl(i).qualifier_attribute92;
1349 in_qualifier_attribute93 (j) := p_pavv_tbl(i).qualifier_attribute93;
1350 in_qualifier_attribute94 (j) := p_pavv_tbl(i).qualifier_attribute94;
1351 in_qualifier_attribute95 (j) := p_pavv_tbl(i).qualifier_attribute95;
1352 in_qualifier_attribute96 (j) := p_pavv_tbl(i).qualifier_attribute96;
1353 in_qualifier_attribute97 (j) := p_pavv_tbl(i).qualifier_attribute97;
1354 in_qualifier_attribute98 (j) := p_pavv_tbl(i).qualifier_attribute98;
1355 in_qualifier_attribute99 (j) := p_pavv_tbl(i).qualifier_attribute99;
1356 in_qualifier_attribute100 (j) := p_pavv_tbl(i).qualifier_attribute100;
1357 in_created_by (j) := p_pavv_tbl(i).created_by;
1358 in_creation_date (j) := p_pavv_tbl(i).creation_date;
1359 in_last_updated_by (j) := p_pavv_tbl(i).last_updated_by;
1360 in_last_update_date (j) := p_pavv_tbl(i).last_update_date;
1361 in_last_update_login (j) := p_pavv_tbl(i).last_update_login;
1362 in_program_application_id (j) := p_pavv_tbl(i).program_application_id;
1363 in_program_id (j) := p_pavv_tbl(i).program_id;
1364 in_program_update_date (j) := p_pavv_tbl(i).program_update_date;
1365 in_request_id (j) := p_pavv_tbl(i).request_id;
1366 in_object_version_number (j) := p_pavv_tbl(i).object_version_number;
1367 i:=p_pavv_tbl.next(i);
1368 END LOOP;
1369
1370 FORALL i in 1..l_tabsize
1371 INSERT
1372 INTO OKC_PRICE_ATT_VALUES
1373 (
1374 id,
1375 flex_title,
1376 pricing_context,
1377 pricing_attribute1,
1378 chr_id,
1379 pricing_attribute2,
1380 cle_id,
1381 pricing_attribute3,
1382 pricing_attribute4,
1383 pricing_attribute5,
1384 pricing_attribute6,
1385 pricing_attribute7,
1386 pricing_attribute8,
1387 pricing_attribute9,
1388 pricing_attribute10,
1389 pricing_attribute11,
1390 pricing_attribute12,
1391 pricing_attribute13,
1392 pricing_attribute14,
1393 pricing_attribute15,
1394 pricing_attribute16,
1395 pricing_attribute17,
1396 pricing_attribute18,
1397 pricing_attribute19,
1398 pricing_attribute20,
1399 pricing_attribute21,
1400 pricing_attribute22,
1401 pricing_attribute23,
1402 pricing_attribute24,
1403 pricing_attribute25,
1404 pricing_attribute26,
1405 pricing_attribute27,
1406 pricing_attribute28,
1407 pricing_attribute29,
1408 pricing_attribute30,
1409 pricing_attribute31,
1410 pricing_attribute32,
1411 pricing_attribute33,
1412 pricing_attribute34,
1413 pricing_attribute35,
1414 pricing_attribute36,
1415 pricing_attribute37,
1416 pricing_attribute38,
1417 pricing_attribute39,
1418 pricing_attribute40,
1419 pricing_attribute41,
1420 pricing_attribute42,
1421 pricing_attribute43,
1422 pricing_attribute44,
1423 pricing_attribute45,
1424 pricing_attribute46,
1425 pricing_attribute47,
1426 pricing_attribute48,
1427 pricing_attribute49,
1428 pricing_attribute50,
1429 pricing_attribute51,
1430 pricing_attribute52,
1431 pricing_attribute53,
1432 pricing_attribute54,
1433 pricing_attribute55,
1434 pricing_attribute56,
1435 pricing_attribute57,
1436 pricing_attribute58,
1437 pricing_attribute59,
1438 pricing_attribute60,
1439 pricing_attribute61,
1440 pricing_attribute62,
1441 pricing_attribute63,
1442 pricing_attribute64,
1443 pricing_attribute65,
1444 pricing_attribute66,
1445 pricing_attribute67,
1446 pricing_attribute68,
1447 pricing_attribute69,
1448 pricing_attribute70,
1449 pricing_attribute71,
1450 pricing_attribute72,
1451 pricing_attribute73,
1452 pricing_attribute74,
1453 pricing_attribute75,
1454 pricing_attribute76,
1455 pricing_attribute77,
1456 pricing_attribute78,
1457 pricing_attribute79,
1458 pricing_attribute80,
1459 pricing_attribute81,
1460 pricing_attribute82,
1461 pricing_attribute83,
1462 pricing_attribute84,
1463 pricing_attribute85,
1464 pricing_attribute86,
1465 pricing_attribute87,
1466 pricing_attribute88,
1467 pricing_attribute89,
1468 pricing_attribute90,
1469 pricing_attribute91,
1470 pricing_attribute92,
1471 pricing_attribute93,
1472 pricing_attribute94,
1473 pricing_attribute95,
1474 pricing_attribute96,
1475 pricing_attribute97,
1476 pricing_attribute98,
1477 pricing_attribute99,
1478 pricing_attribute100,
1479 qualifier_context,
1480 qualifier_attribute1,
1481 qualifier_attribute2,
1482 created_by,
1483 qualifier_attribute3,
1484 creation_date,
1485 qualifier_attribute4,
1486 qualifier_attribute5,
1487 last_updated_by,
1488 qualifier_attribute6,
1489 last_update_date,
1490 qualifier_attribute7,
1491 qualifier_attribute8,
1492 qualifier_attribute9,
1493 qualifier_attribute10,
1494 qualifier_attribute11,
1495 qualifier_attribute12,
1496 qualifier_attribute13,
1497 qualifier_attribute14,
1498 qualifier_attribute15,
1499 qualifier_attribute16,
1500 qualifier_attribute17,
1501 qualifier_attribute18,
1502 qualifier_attribute19,
1503 qualifier_attribute20,
1504 qualifier_attribute21,
1505 qualifier_attribute22,
1506 qualifier_attribute23,
1507 qualifier_attribute24,
1508 qualifier_attribute25,
1509 qualifier_attribute26,
1510 qualifier_attribute27,
1511 qualifier_attribute28,
1512 qualifier_attribute29,
1513 qualifier_attribute30,
1514 qualifier_attribute31,
1515 qualifier_attribute32,
1516 qualifier_attribute33,
1517 qualifier_attribute34,
1518 qualifier_attribute35,
1519 qualifier_attribute36,
1520 qualifier_attribute37,
1521 qualifier_attribute38,
1522 qualifier_attribute39,
1523 qualifier_attribute40,
1524 qualifier_attribute41,
1525 qualifier_attribute42,
1526 qualifier_attribute43,
1527 qualifier_attribute44,
1528 qualifier_attribute45,
1529 qualifier_attribute46,
1530 qualifier_attribute47,
1531 qualifier_attribute48,
1532 qualifier_attribute49,
1533 qualifier_attribute50,
1534 qualifier_attribute51,
1535 qualifier_attribute52,
1536 qualifier_attribute53,
1537 qualifier_attribute54,
1538 qualifier_attribute55,
1539 qualifier_attribute56,
1540 qualifier_attribute57,
1541 qualifier_attribute58,
1542 qualifier_attribute59,
1543 qualifier_attribute60,
1544 qualifier_attribute61,
1545 qualifier_attribute62,
1546 qualifier_attribute63,
1547 qualifier_attribute64,
1548 qualifier_attribute65,
1549 qualifier_attribute66,
1550 qualifier_attribute67,
1551 qualifier_attribute68,
1552 qualifier_attribute69,
1553 qualifier_attribute70,
1554 qualifier_attribute71,
1555 qualifier_attribute72,
1556 qualifier_attribute73,
1557 qualifier_attribute74,
1558 qualifier_attribute75,
1559 qualifier_attribute76,
1560 qualifier_attribute77,
1561 qualifier_attribute78,
1562 qualifier_attribute79,
1563 qualifier_attribute80,
1564 qualifier_attribute81,
1565 qualifier_attribute82,
1566 qualifier_attribute83,
1567 qualifier_attribute84,
1568 qualifier_attribute85,
1569 qualifier_attribute86,
1570 qualifier_attribute87,
1571 qualifier_attribute88,
1572 qualifier_attribute89,
1573 qualifier_attribute90,
1574 qualifier_attribute91,
1575 qualifier_attribute92,
1576 qualifier_attribute93,
1577 qualifier_attribute94,
1578 qualifier_attribute95,
1579 qualifier_attribute96,
1580 qualifier_attribute97,
1581 qualifier_attribute98,
1582 qualifier_attribute99,
1583 qualifier_attribute100,
1584 last_update_login,
1585 program_application_id,
1586 program_id,
1587 program_update_date,
1588 request_id,
1589 object_version_number)
1590 VALUES (
1591 in_id(i),
1592 in_flex_title(i),
1593 in_pricing_context(i),
1594 in_pricing_attribute1(i),
1595 in_chr_id(i),
1596 in_pricing_attribute2(i),
1597 in_cle_id(i),
1598 in_pricing_attribute3(i),
1599 in_pricing_attribute4(i),
1600 in_pricing_attribute5(i),
1601 in_pricing_attribute6(i),
1602 in_pricing_attribute7(i),
1603 in_pricing_attribute8(i),
1604 in_pricing_attribute9(i),
1605 in_pricing_attribute10(i),
1606 in_pricing_attribute11(i),
1607 in_pricing_attribute12(i),
1608 in_pricing_attribute13(i),
1609 in_pricing_attribute14(i),
1610 in_pricing_attribute15(i),
1611 in_pricing_attribute16(i),
1612 in_pricing_attribute17(i),
1613 in_pricing_attribute18(i),
1614 in_pricing_attribute19(i),
1615 in_pricing_attribute20(i),
1616 in_pricing_attribute21(i),
1617 in_pricing_attribute22(i),
1618 in_pricing_attribute23(i),
1619 in_pricing_attribute24(i),
1620 in_pricing_attribute25(i),
1621 in_pricing_attribute26(i),
1622 in_pricing_attribute27(i),
1623 in_pricing_attribute28(i),
1624 in_pricing_attribute29(i),
1625 in_pricing_attribute30(i),
1626 in_pricing_attribute31(i),
1627 in_pricing_attribute32(i),
1628 in_pricing_attribute33(i),
1629 in_pricing_attribute34(i),
1630 in_pricing_attribute35(i),
1631 in_pricing_attribute36(i),
1632 in_pricing_attribute37(i),
1633 in_pricing_attribute38(i),
1634 in_pricing_attribute39(i),
1635 in_pricing_attribute40(i),
1636 in_pricing_attribute41(i),
1637 in_pricing_attribute42(i),
1638 in_pricing_attribute43(i),
1639 in_pricing_attribute44(i),
1640 in_pricing_attribute45(i),
1641 in_pricing_attribute46(i),
1642 in_pricing_attribute47(i),
1643 in_pricing_attribute48(i),
1644 in_pricing_attribute49(i),
1645 in_pricing_attribute50(i),
1646 in_pricing_attribute51(i),
1647 in_pricing_attribute52(i),
1648 in_pricing_attribute53(i),
1649 in_pricing_attribute54(i),
1650 in_pricing_attribute55(i),
1651 in_pricing_attribute56(i),
1652 in_pricing_attribute57(i),
1653 in_pricing_attribute58(i),
1654 in_pricing_attribute59(i),
1655 in_pricing_attribute60(i),
1656 in_pricing_attribute61(i),
1657 in_pricing_attribute62(i),
1658 in_pricing_attribute63(i),
1659 in_pricing_attribute64(i),
1660 in_pricing_attribute65(i),
1661 in_pricing_attribute66(i),
1662 in_pricing_attribute67(i),
1663 in_pricing_attribute68(i),
1664 in_pricing_attribute69(i),
1665 in_pricing_attribute70(i),
1666 in_pricing_attribute71(i),
1667 in_pricing_attribute72(i),
1668 in_pricing_attribute73(i),
1669 in_pricing_attribute74(i),
1670 in_pricing_attribute75(i),
1671 in_pricing_attribute76(i),
1672 in_pricing_attribute77(i),
1673 in_pricing_attribute78(i),
1674 in_pricing_attribute79(i),
1675 in_pricing_attribute80(i),
1676 in_pricing_attribute81(i),
1677 in_pricing_attribute82(i),
1678 in_pricing_attribute83(i),
1679 in_pricing_attribute84(i),
1680 in_pricing_attribute85(i),
1681 in_pricing_attribute86(i),
1682 in_pricing_attribute87(i),
1683 in_pricing_attribute88(i),
1684 in_pricing_attribute89(i),
1685 in_pricing_attribute90(i),
1686 in_pricing_attribute91(i),
1687 in_pricing_attribute92(i),
1688 in_pricing_attribute93(i),
1689 in_pricing_attribute94(i),
1690 in_pricing_attribute95(i),
1691 in_pricing_attribute96(i),
1692 in_pricing_attribute97(i),
1693 in_pricing_attribute98(i),
1694 in_pricing_attribute99(i),
1695 in_pricing_attribute100(i),
1696 in_qualifier_context(i),
1697 in_qualifier_attribute1(i),
1698 in_qualifier_attribute2(i),
1699 in_created_by(i),
1700 in_qualifier_attribute3(i),
1701 in_creation_date(i),
1702 in_qualifier_attribute4(i),
1703 in_qualifier_attribute5(i),
1704 in_last_updated_by(i),
1705 in_qualifier_attribute6(i),
1706 in_last_update_date(i),
1707 in_qualifier_attribute7(i),
1708 in_qualifier_attribute8(i),
1709 in_qualifier_attribute9(i),
1710 in_qualifier_attribute10(i),
1711 in_qualifier_attribute11(i),
1712 in_qualifier_attribute12(i),
1713 in_qualifier_attribute13(i),
1714 in_qualifier_attribute14(i),
1715 in_qualifier_attribute15(i),
1716 in_qualifier_attribute16(i),
1717 in_qualifier_attribute17(i),
1718 in_qualifier_attribute18(i),
1719 in_qualifier_attribute19(i),
1720 in_qualifier_attribute20(i),
1721 in_qualifier_attribute21(i),
1722 in_qualifier_attribute22(i),
1723 in_qualifier_attribute23(i),
1724 in_qualifier_attribute24(i),
1725 in_qualifier_attribute25(i),
1726 in_qualifier_attribute26(i),
1727 in_qualifier_attribute27(i),
1728 in_qualifier_attribute28(i),
1729 in_qualifier_attribute29(i),
1730 in_qualifier_attribute30(i),
1731 in_qualifier_attribute31(i),
1732 in_qualifier_attribute32(i),
1733 in_qualifier_attribute33(i),
1734 in_qualifier_attribute34(i),
1735 in_qualifier_attribute35(i),
1736 in_qualifier_attribute36(i),
1737 in_qualifier_attribute37(i),
1738 in_qualifier_attribute38(i),
1739 in_qualifier_attribute39(i),
1740 in_qualifier_attribute40(i),
1741 in_qualifier_attribute41(i),
1742 in_qualifier_attribute42(i),
1743 in_qualifier_attribute43(i),
1744 in_qualifier_attribute44(i),
1745 in_qualifier_attribute45(i),
1746 in_qualifier_attribute46(i),
1747 in_qualifier_attribute47(i),
1748 in_qualifier_attribute48(i),
1749 in_qualifier_attribute49(i),
1750 in_qualifier_attribute50(i),
1751 in_qualifier_attribute51(i),
1752 in_qualifier_attribute52(i),
1753 in_qualifier_attribute53(i),
1754 in_qualifier_attribute54(i),
1755 in_qualifier_attribute55(i),
1756 in_qualifier_attribute56(i),
1757 in_qualifier_attribute57(i),
1758 in_qualifier_attribute58(i),
1759 in_qualifier_attribute59(i),
1760 in_qualifier_attribute60(i),
1761 in_qualifier_attribute61(i),
1762 in_qualifier_attribute62(i),
1763 in_qualifier_attribute63(i),
1764 in_qualifier_attribute64(i),
1765 in_qualifier_attribute65(i),
1766 in_qualifier_attribute66(i),
1767 in_qualifier_attribute67(i),
1768 in_qualifier_attribute68(i),
1769 in_qualifier_attribute69(i),
1770 in_qualifier_attribute70(i),
1771 in_qualifier_attribute71(i),
1772 in_qualifier_attribute72(i),
1773 in_qualifier_attribute73(i),
1774 in_qualifier_attribute74(i),
1775 in_qualifier_attribute75(i),
1776 in_qualifier_attribute76(i),
1777 in_qualifier_attribute77(i),
1778 in_qualifier_attribute78(i),
1779 in_qualifier_attribute79(i),
1780 in_qualifier_attribute80(i),
1781 in_qualifier_attribute81(i),
1782 in_qualifier_attribute82(i),
1783 in_qualifier_attribute83(i),
1784 in_qualifier_attribute84(i),
1785 in_qualifier_attribute85(i),
1786 in_qualifier_attribute86(i),
1787 in_qualifier_attribute87(i),
1788 in_qualifier_attribute88(i),
1789 in_qualifier_attribute89(i),
1790 in_qualifier_attribute90(i),
1791 in_qualifier_attribute91(i),
1792 in_qualifier_attribute92(i),
1793 in_qualifier_attribute93(i),
1794 in_qualifier_attribute94(i),
1795 in_qualifier_attribute95(i),
1796 in_qualifier_attribute96(i),
1797 in_qualifier_attribute97(i),
1798 in_qualifier_attribute98(i),
1799 in_qualifier_attribute99(i),
1800 in_qualifier_attribute100(i),
1801 in_last_update_login(i),
1802 in_program_application_id(i),
1803 in_program_id(i),
1804 in_program_update_date(i),
1805 in_request_id(i),
1806 in_object_version_number(i)
1807 );
1808
1809 EXCEPTION
1810 WHEN OTHERS THEN
1811 -- store SQL error message on message stack
1812 OKC_API.SET_MESSAGE(
1813 p_app_name => G_APP_NAME,
1814 p_msg_name => G_UNEXPECTED_ERROR,
1815 p_token1 => G_SQLCODE_TOKEN,
1816 p_token1_value => SQLCODE,
1817 p_token2 => G_SQLERRM_TOKEN,
1818 p_token2_value => SQLERRM);
1819 -- notify caller of an error as UNEXPECTED error
1820 x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1821
1822 RAISE;
1823 END INSERT_ROW_UPG;
1824
1825 END OKC_SPLIT2_PAV_PVT;