[Home] [Help]
PACKAGE BODY: APPS.OKL_CONTRACT_LINE_ITEM_PVT_W
Source
1 package body okl_contract_line_item_pvt_w as
2 /* $Header: OKLECLIB.pls 115.2 2003/10/16 01:14:18 smereddy noship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 function rosetta_g_miss_num_map(n number) return number as
14 a number := fnd_api.g_miss_num;
15 b number := 0-1962.0724;
16 begin
17 if n=a then return b; end if;
18 if n=b then return a; end if;
19 return n;
20 end;
21
22 procedure rosetta_table_copy_in_p7(t out nocopy okl_contract_line_item_pvt.link_ast_tbl_type, a0 JTF_VARCHAR2_TABLE_100
23 , a1 JTF_VARCHAR2_TABLE_200
24 , a2 JTF_VARCHAR2_TABLE_300
25 , a3 JTF_VARCHAR2_TABLE_100
26 ) as
27 ddindx binary_integer; indx binary_integer;
28 begin
29 if a0 is not null and a0.count > 0 then
30 if a0.count > 0 then
31 indx := a0.first;
32 ddindx := 1;
33 while true loop
34 t(ddindx).id1 := a0(indx);
35 t(ddindx).id2 := a1(indx);
36 t(ddindx).name := a2(indx);
37 t(ddindx).object_code := a3(indx);
38 ddindx := ddindx+1;
39 if a0.last =indx
40 then exit;
41 end if;
42 indx := a0.next(indx);
43 end loop;
44 end if;
45 end if;
46 end rosetta_table_copy_in_p7;
47 procedure rosetta_table_copy_out_p7(t okl_contract_line_item_pvt.link_ast_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
48 , a1 out nocopy JTF_VARCHAR2_TABLE_200
49 , a2 out nocopy JTF_VARCHAR2_TABLE_300
50 , a3 out nocopy JTF_VARCHAR2_TABLE_100
51 ) as
52 ddindx binary_integer; indx binary_integer;
53 begin
54 if t is null or t.count = 0 then
55 a0 := JTF_VARCHAR2_TABLE_100();
56 a1 := JTF_VARCHAR2_TABLE_200();
57 a2 := JTF_VARCHAR2_TABLE_300();
58 a3 := JTF_VARCHAR2_TABLE_100();
59 else
60 a0 := JTF_VARCHAR2_TABLE_100();
61 a1 := JTF_VARCHAR2_TABLE_200();
62 a2 := JTF_VARCHAR2_TABLE_300();
63 a3 := JTF_VARCHAR2_TABLE_100();
64 if t.count > 0 then
65 a0.extend(t.count);
66 a1.extend(t.count);
67 a2.extend(t.count);
68 a3.extend(t.count);
69 ddindx := t.first;
70 indx := 1;
71 while true loop
72 a0(indx) := t(ddindx).id1;
73 a1(indx) := t(ddindx).id2;
74 a2(indx) := t(ddindx).name;
75 a3(indx) := t(ddindx).object_code;
76 indx := indx+1;
77 if t.last =ddindx
78 then exit;
79 end if;
80 ddindx := t.next(ddindx);
81 end loop;
82 end if;
83 end if;
84 end rosetta_table_copy_out_p7;
85
86 procedure rosetta_table_copy_in_p11(t out nocopy okl_contract_line_item_pvt.line_item_tbl_type, a0 JTF_NUMBER_TABLE
87 , a1 JTF_NUMBER_TABLE
88 , a2 JTF_NUMBER_TABLE
89 , a3 JTF_NUMBER_TABLE
90 , a4 JTF_VARCHAR2_TABLE_100
91 , a5 JTF_VARCHAR2_TABLE_200
92 , a6 JTF_VARCHAR2_TABLE_100
93 , a7 JTF_VARCHAR2_TABLE_2000
94 , a8 JTF_VARCHAR2_TABLE_200
95 , a9 JTF_NUMBER_TABLE
96 , a10 JTF_NUMBER_TABLE
97 ) as
98 ddindx binary_integer; indx binary_integer;
99 begin
100 if a0 is not null and a0.count > 0 then
101 if a0.count > 0 then
102 indx := a0.first;
103 ddindx := 1;
104 while true loop
105 t(ddindx).chr_id := rosetta_g_miss_num_map(a0(indx));
106 t(ddindx).parent_cle_id := rosetta_g_miss_num_map(a1(indx));
107 t(ddindx).cle_id := rosetta_g_miss_num_map(a2(indx));
108 t(ddindx).item_id := rosetta_g_miss_num_map(a3(indx));
109 t(ddindx).item_id1 := a4(indx);
110 t(ddindx).item_id2 := a5(indx);
111 t(ddindx).item_object1_code := a6(indx);
112 t(ddindx).item_description := a7(indx);
113 t(ddindx).name := a8(indx);
114 t(ddindx).capital_amount := rosetta_g_miss_num_map(a9(indx));
115 t(ddindx).serv_cov_prd_id := rosetta_g_miss_num_map(a10(indx));
116 ddindx := ddindx+1;
117 if a0.last =indx
118 then exit;
119 end if;
120 indx := a0.next(indx);
121 end loop;
122 end if;
123 end if;
124 end rosetta_table_copy_in_p11;
125 procedure rosetta_table_copy_out_p11(t okl_contract_line_item_pvt.line_item_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126 , a1 out nocopy JTF_NUMBER_TABLE
127 , a2 out nocopy JTF_NUMBER_TABLE
128 , a3 out nocopy JTF_NUMBER_TABLE
129 , a4 out nocopy JTF_VARCHAR2_TABLE_100
130 , a5 out nocopy JTF_VARCHAR2_TABLE_200
131 , a6 out nocopy JTF_VARCHAR2_TABLE_100
132 , a7 out nocopy JTF_VARCHAR2_TABLE_2000
133 , a8 out nocopy JTF_VARCHAR2_TABLE_200
134 , a9 out nocopy JTF_NUMBER_TABLE
135 , a10 out nocopy JTF_NUMBER_TABLE
136 ) as
137 ddindx binary_integer; indx binary_integer;
138 begin
139 if t is null or t.count = 0 then
140 a0 := JTF_NUMBER_TABLE();
141 a1 := JTF_NUMBER_TABLE();
142 a2 := JTF_NUMBER_TABLE();
143 a3 := JTF_NUMBER_TABLE();
144 a4 := JTF_VARCHAR2_TABLE_100();
145 a5 := JTF_VARCHAR2_TABLE_200();
146 a6 := JTF_VARCHAR2_TABLE_100();
147 a7 := JTF_VARCHAR2_TABLE_2000();
148 a8 := JTF_VARCHAR2_TABLE_200();
149 a9 := JTF_NUMBER_TABLE();
150 a10 := JTF_NUMBER_TABLE();
151 else
152 a0 := JTF_NUMBER_TABLE();
153 a1 := JTF_NUMBER_TABLE();
154 a2 := JTF_NUMBER_TABLE();
155 a3 := JTF_NUMBER_TABLE();
156 a4 := JTF_VARCHAR2_TABLE_100();
157 a5 := JTF_VARCHAR2_TABLE_200();
158 a6 := JTF_VARCHAR2_TABLE_100();
159 a7 := JTF_VARCHAR2_TABLE_2000();
160 a8 := JTF_VARCHAR2_TABLE_200();
161 a9 := JTF_NUMBER_TABLE();
162 a10 := JTF_NUMBER_TABLE();
163 if t.count > 0 then
164 a0.extend(t.count);
165 a1.extend(t.count);
166 a2.extend(t.count);
167 a3.extend(t.count);
168 a4.extend(t.count);
169 a5.extend(t.count);
170 a6.extend(t.count);
171 a7.extend(t.count);
172 a8.extend(t.count);
173 a9.extend(t.count);
174 a10.extend(t.count);
175 ddindx := t.first;
176 indx := 1;
177 while true loop
178 a0(indx) := rosetta_g_miss_num_map(t(ddindx).chr_id);
179 a1(indx) := rosetta_g_miss_num_map(t(ddindx).parent_cle_id);
180 a2(indx) := rosetta_g_miss_num_map(t(ddindx).cle_id);
181 a3(indx) := rosetta_g_miss_num_map(t(ddindx).item_id);
182 a4(indx) := t(ddindx).item_id1;
183 a5(indx) := t(ddindx).item_id2;
184 a6(indx) := t(ddindx).item_object1_code;
185 a7(indx) := t(ddindx).item_description;
186 a8(indx) := t(ddindx).name;
187 a9(indx) := rosetta_g_miss_num_map(t(ddindx).capital_amount);
188 a10(indx) := rosetta_g_miss_num_map(t(ddindx).serv_cov_prd_id);
189 indx := indx+1;
190 if t.last =ddindx
191 then exit;
192 end if;
193 ddindx := t.next(ddindx);
194 end loop;
195 end if;
196 end if;
197 end rosetta_table_copy_out_p11;
198
199 procedure create_contract_line_item(p_api_version NUMBER
200 , p_init_msg_list VARCHAR2
201 , x_return_status out nocopy VARCHAR2
202 , x_msg_count out nocopy NUMBER
203 , x_msg_data out nocopy VARCHAR2
204 , p5_a0 JTF_NUMBER_TABLE
205 , p5_a1 JTF_NUMBER_TABLE
206 , p5_a2 JTF_NUMBER_TABLE
207 , p5_a3 JTF_NUMBER_TABLE
208 , p5_a4 JTF_VARCHAR2_TABLE_100
209 , p5_a5 JTF_VARCHAR2_TABLE_200
210 , p5_a6 JTF_VARCHAR2_TABLE_100
211 , p5_a7 JTF_VARCHAR2_TABLE_2000
212 , p5_a8 JTF_VARCHAR2_TABLE_200
213 , p5_a9 JTF_NUMBER_TABLE
214 , p5_a10 JTF_NUMBER_TABLE
215 , p6_a0 out nocopy JTF_NUMBER_TABLE
216 , p6_a1 out nocopy JTF_NUMBER_TABLE
217 , p6_a2 out nocopy JTF_NUMBER_TABLE
218 , p6_a3 out nocopy JTF_NUMBER_TABLE
219 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
220 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
221 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
222 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
223 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
224 , p6_a9 out nocopy JTF_NUMBER_TABLE
225 , p6_a10 out nocopy JTF_NUMBER_TABLE
226 )
227
228 as
229 ddp_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
230 ddx_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
231 ddindx binary_integer; indx binary_integer;
232 begin
233
234 -- copy data to the local IN or IN-OUT args, if any
235
236
237
238
239
240 okl_contract_line_item_pvt_w.rosetta_table_copy_in_p11(ddp_line_item_tbl, p5_a0
241 , p5_a1
242 , p5_a2
243 , p5_a3
244 , p5_a4
245 , p5_a5
246 , p5_a6
247 , p5_a7
248 , p5_a8
249 , p5_a9
250 , p5_a10
251 );
252
253
254 -- here's the delegated call to the old PL/SQL routine
255 okl_contract_line_item_pvt.create_contract_line_item(p_api_version,
256 p_init_msg_list,
257 x_return_status,
258 x_msg_count,
259 x_msg_data,
260 ddp_line_item_tbl,
261 ddx_line_item_tbl);
262
263 -- copy data back from the local variables to OUT or IN-OUT args, if any
264
265
266
267
268
269
270 okl_contract_line_item_pvt_w.rosetta_table_copy_out_p11(ddx_line_item_tbl, p6_a0
271 , p6_a1
272 , p6_a2
273 , p6_a3
274 , p6_a4
275 , p6_a5
276 , p6_a6
277 , p6_a7
278 , p6_a8
279 , p6_a9
280 , p6_a10
281 );
282 end;
283
284 procedure update_contract_line_item(p_api_version NUMBER
285 , p_init_msg_list VARCHAR2
286 , x_return_status out nocopy VARCHAR2
287 , x_msg_count out nocopy NUMBER
288 , x_msg_data out nocopy VARCHAR2
289 , p5_a0 JTF_NUMBER_TABLE
290 , p5_a1 JTF_NUMBER_TABLE
291 , p5_a2 JTF_NUMBER_TABLE
292 , p5_a3 JTF_NUMBER_TABLE
293 , p5_a4 JTF_VARCHAR2_TABLE_100
294 , p5_a5 JTF_VARCHAR2_TABLE_200
295 , p5_a6 JTF_VARCHAR2_TABLE_100
296 , p5_a7 JTF_VARCHAR2_TABLE_2000
297 , p5_a8 JTF_VARCHAR2_TABLE_200
298 , p5_a9 JTF_NUMBER_TABLE
299 , p5_a10 JTF_NUMBER_TABLE
300 , p6_a0 out nocopy JTF_NUMBER_TABLE
301 , p6_a1 out nocopy JTF_NUMBER_TABLE
302 , p6_a2 out nocopy JTF_NUMBER_TABLE
303 , p6_a3 out nocopy JTF_NUMBER_TABLE
304 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
305 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
306 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
307 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
308 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
309 , p6_a9 out nocopy JTF_NUMBER_TABLE
310 , p6_a10 out nocopy JTF_NUMBER_TABLE
311 )
312
313 as
314 ddp_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
315 ddx_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
316 ddindx binary_integer; indx binary_integer;
317 begin
318
319 -- copy data to the local IN or IN-OUT args, if any
320
321
322
323
324
325 okl_contract_line_item_pvt_w.rosetta_table_copy_in_p11(ddp_line_item_tbl, p5_a0
326 , p5_a1
327 , p5_a2
328 , p5_a3
329 , p5_a4
330 , p5_a5
331 , p5_a6
332 , p5_a7
333 , p5_a8
334 , p5_a9
335 , p5_a10
336 );
337
338
339 -- here's the delegated call to the old PL/SQL routine
340 okl_contract_line_item_pvt.update_contract_line_item(p_api_version,
341 p_init_msg_list,
342 x_return_status,
343 x_msg_count,
344 x_msg_data,
345 ddp_line_item_tbl,
346 ddx_line_item_tbl);
347
348 -- copy data back from the local variables to OUT or IN-OUT args, if any
349
350
351
352
353
354
355 okl_contract_line_item_pvt_w.rosetta_table_copy_out_p11(ddx_line_item_tbl, p6_a0
356 , p6_a1
357 , p6_a2
358 , p6_a3
359 , p6_a4
360 , p6_a5
361 , p6_a6
362 , p6_a7
363 , p6_a8
364 , p6_a9
365 , p6_a10
366 );
367 end;
368
369 procedure delete_contract_line_item(p_api_version NUMBER
370 , p_init_msg_list VARCHAR2
371 , x_return_status out nocopy VARCHAR2
372 , x_msg_count out nocopy NUMBER
373 , x_msg_data out nocopy VARCHAR2
374 , p5_a0 JTF_NUMBER_TABLE
375 , p5_a1 JTF_NUMBER_TABLE
376 , p5_a2 JTF_NUMBER_TABLE
377 , p5_a3 JTF_NUMBER_TABLE
378 , p5_a4 JTF_VARCHAR2_TABLE_100
379 , p5_a5 JTF_VARCHAR2_TABLE_200
380 , p5_a6 JTF_VARCHAR2_TABLE_100
381 , p5_a7 JTF_VARCHAR2_TABLE_2000
382 , p5_a8 JTF_VARCHAR2_TABLE_200
383 , p5_a9 JTF_NUMBER_TABLE
384 , p5_a10 JTF_NUMBER_TABLE
385 )
386
387 as
388 ddp_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
389 ddindx binary_integer; indx binary_integer;
390 begin
391
392 -- copy data to the local IN or IN-OUT args, if any
393
394
395
396
397
398 okl_contract_line_item_pvt_w.rosetta_table_copy_in_p11(ddp_line_item_tbl, p5_a0
399 , p5_a1
400 , p5_a2
401 , p5_a3
402 , p5_a4
403 , p5_a5
404 , p5_a6
405 , p5_a7
406 , p5_a8
407 , p5_a9
408 , p5_a10
409 );
410
411 -- here's the delegated call to the old PL/SQL routine
412 okl_contract_line_item_pvt.delete_contract_line_item(p_api_version,
413 p_init_msg_list,
414 x_return_status,
415 x_msg_count,
416 x_msg_data,
417 ddp_line_item_tbl);
418
419 -- copy data back from the local variables to OUT or IN-OUT args, if any
420
421
422
423
424
425 end;
426
427 procedure create_contract_line_item(p_api_version NUMBER
428 , p_init_msg_list VARCHAR2
429 , x_return_status out nocopy VARCHAR2
430 , x_msg_count out nocopy NUMBER
431 , x_msg_data out nocopy VARCHAR2
432 , p8_a0 out nocopy NUMBER
433 , p8_a1 out nocopy NUMBER
434 , p8_a2 out nocopy VARCHAR2
435 , p8_a3 out nocopy NUMBER
436 , p8_a4 out nocopy NUMBER
437 , p8_a5 out nocopy NUMBER
438 , p8_a6 out nocopy NUMBER
439 , p8_a7 out nocopy NUMBER
440 , p8_a8 out nocopy VARCHAR2
441 , p8_a9 out nocopy VARCHAR2
442 , p8_a10 out nocopy NUMBER
443 , p8_a11 out nocopy VARCHAR2
444 , p8_a12 out nocopy NUMBER
445 , p8_a13 out nocopy VARCHAR2
446 , p8_a14 out nocopy VARCHAR2
447 , p8_a15 out nocopy VARCHAR2
448 , p8_a16 out nocopy VARCHAR2
449 , p8_a17 out nocopy VARCHAR2
450 , p8_a18 out nocopy NUMBER
451 , p8_a19 out nocopy NUMBER
452 , p8_a20 out nocopy NUMBER
453 , p8_a21 out nocopy NUMBER
454 , p8_a22 out nocopy VARCHAR2
455 , p8_a23 out nocopy VARCHAR2
456 , p8_a24 out nocopy VARCHAR2
457 , p8_a25 out nocopy VARCHAR2
458 , p8_a26 out nocopy VARCHAR2
459 , p8_a27 out nocopy VARCHAR2
460 , p8_a28 out nocopy DATE
461 , p8_a29 out nocopy VARCHAR2
462 , p8_a30 out nocopy DATE
463 , p8_a31 out nocopy DATE
464 , p8_a32 out nocopy DATE
465 , p8_a33 out nocopy VARCHAR2
466 , p8_a34 out nocopy NUMBER
467 , p8_a35 out nocopy VARCHAR2
468 , p8_a36 out nocopy NUMBER
469 , p8_a37 out nocopy VARCHAR2
470 , p8_a38 out nocopy VARCHAR2
471 , p8_a39 out nocopy VARCHAR2
472 , p8_a40 out nocopy VARCHAR2
473 , p8_a41 out nocopy VARCHAR2
474 , p8_a42 out nocopy VARCHAR2
475 , p8_a43 out nocopy VARCHAR2
476 , p8_a44 out nocopy VARCHAR2
477 , p8_a45 out nocopy VARCHAR2
478 , p8_a46 out nocopy VARCHAR2
479 , p8_a47 out nocopy VARCHAR2
480 , p8_a48 out nocopy VARCHAR2
481 , p8_a49 out nocopy VARCHAR2
482 , p8_a50 out nocopy VARCHAR2
483 , p8_a51 out nocopy VARCHAR2
484 , p8_a52 out nocopy VARCHAR2
485 , p8_a53 out nocopy VARCHAR2
486 , p8_a54 out nocopy NUMBER
487 , p8_a55 out nocopy DATE
488 , p8_a56 out nocopy NUMBER
489 , p8_a57 out nocopy DATE
490 , p8_a58 out nocopy VARCHAR2
491 , p8_a59 out nocopy VARCHAR2
492 , p8_a60 out nocopy VARCHAR2
493 , p8_a61 out nocopy NUMBER
494 , p8_a62 out nocopy VARCHAR2
495 , p8_a63 out nocopy VARCHAR2
496 , p8_a64 out nocopy VARCHAR2
497 , p8_a65 out nocopy VARCHAR2
498 , p8_a66 out nocopy VARCHAR2
499 , p8_a67 out nocopy NUMBER
500 , p8_a68 out nocopy NUMBER
501 , p8_a69 out nocopy NUMBER
502 , p8_a70 out nocopy DATE
503 , p8_a71 out nocopy NUMBER
504 , p8_a72 out nocopy DATE
505 , p8_a73 out nocopy NUMBER
506 , p8_a74 out nocopy NUMBER
507 , p8_a75 out nocopy VARCHAR2
508 , p8_a76 out nocopy VARCHAR2
509 , p8_a77 out nocopy NUMBER
510 , p8_a78 out nocopy NUMBER
511 , p8_a79 out nocopy VARCHAR2
512 , p8_a80 out nocopy VARCHAR2
513 , p8_a81 out nocopy NUMBER
514 , p8_a82 out nocopy VARCHAR2
515 , p8_a83 out nocopy NUMBER
516 , p8_a84 out nocopy NUMBER
517 , p8_a85 out nocopy NUMBER
518 , p8_a86 out nocopy NUMBER
519 , p8_a87 out nocopy VARCHAR2
520 , p8_a88 out nocopy NUMBER
521 , p8_a89 out nocopy NUMBER
522 , p9_a0 out nocopy NUMBER
523 , p9_a1 out nocopy NUMBER
524 , p9_a2 out nocopy NUMBER
525 , p9_a3 out nocopy NUMBER
526 , p9_a4 out nocopy VARCHAR2
527 , p9_a5 out nocopy VARCHAR2
528 , p9_a6 out nocopy VARCHAR2
529 , p9_a7 out nocopy NUMBER
530 , p9_a8 out nocopy NUMBER
531 , p9_a9 out nocopy DATE
532 , p9_a10 out nocopy NUMBER
533 , p9_a11 out nocopy NUMBER
534 , p9_a12 out nocopy NUMBER
535 , p9_a13 out nocopy NUMBER
536 , p9_a14 out nocopy NUMBER
537 , p9_a15 out nocopy NUMBER
538 , p9_a16 out nocopy NUMBER
539 , p9_a17 out nocopy NUMBER
540 , p9_a18 out nocopy NUMBER
541 , p9_a19 out nocopy NUMBER
542 , p9_a20 out nocopy DATE
543 , p9_a21 out nocopy DATE
544 , p9_a22 out nocopy NUMBER
545 , p9_a23 out nocopy NUMBER
546 , p9_a24 out nocopy DATE
547 , p9_a25 out nocopy DATE
548 , p9_a26 out nocopy DATE
549 , p9_a27 out nocopy NUMBER
550 , p9_a28 out nocopy NUMBER
551 , p9_a29 out nocopy NUMBER
552 , p9_a30 out nocopy NUMBER
553 , p9_a31 out nocopy NUMBER
554 , p9_a32 out nocopy NUMBER
555 , p9_a33 out nocopy NUMBER
556 , p9_a34 out nocopy DATE
557 , p9_a35 out nocopy VARCHAR2
558 , p9_a36 out nocopy DATE
559 , p9_a37 out nocopy VARCHAR2
560 , p9_a38 out nocopy NUMBER
561 , p9_a39 out nocopy NUMBER
562 , p9_a40 out nocopy NUMBER
563 , p9_a41 out nocopy VARCHAR2
564 , p9_a42 out nocopy DATE
565 , p9_a43 out nocopy NUMBER
566 , p9_a44 out nocopy NUMBER
567 , p9_a45 out nocopy DATE
568 , p9_a46 out nocopy NUMBER
569 , p9_a47 out nocopy DATE
570 , p9_a48 out nocopy DATE
571 , p9_a49 out nocopy DATE
572 , p9_a50 out nocopy NUMBER
573 , p9_a51 out nocopy NUMBER
574 , p9_a52 out nocopy VARCHAR2
575 , p9_a53 out nocopy NUMBER
576 , p9_a54 out nocopy NUMBER
577 , p9_a55 out nocopy VARCHAR2
578 , p9_a56 out nocopy VARCHAR2
579 , p9_a57 out nocopy NUMBER
580 , p9_a58 out nocopy DATE
581 , p9_a59 out nocopy NUMBER
582 , p9_a60 out nocopy VARCHAR2
583 , p9_a61 out nocopy VARCHAR2
584 , p9_a62 out nocopy VARCHAR2
585 , p9_a63 out nocopy VARCHAR2
586 , p9_a64 out nocopy VARCHAR2
587 , p9_a65 out nocopy VARCHAR2
588 , p9_a66 out nocopy VARCHAR2
589 , p9_a67 out nocopy VARCHAR2
590 , p9_a68 out nocopy VARCHAR2
591 , p9_a69 out nocopy VARCHAR2
592 , p9_a70 out nocopy VARCHAR2
593 , p9_a71 out nocopy VARCHAR2
594 , p9_a72 out nocopy VARCHAR2
595 , p9_a73 out nocopy VARCHAR2
596 , p9_a74 out nocopy VARCHAR2
597 , p9_a75 out nocopy VARCHAR2
598 , p9_a76 out nocopy NUMBER
599 , p9_a77 out nocopy NUMBER
600 , p9_a78 out nocopy NUMBER
601 , p9_a79 out nocopy DATE
602 , p9_a80 out nocopy NUMBER
603 , p9_a81 out nocopy DATE
604 , p9_a82 out nocopy NUMBER
605 , p9_a83 out nocopy DATE
606 , p9_a84 out nocopy DATE
607 , p9_a85 out nocopy DATE
608 , p9_a86 out nocopy DATE
609 , p9_a87 out nocopy NUMBER
610 , p9_a88 out nocopy NUMBER
611 , p9_a89 out nocopy NUMBER
612 , p9_a90 out nocopy VARCHAR2
613 , p9_a91 out nocopy NUMBER
614 , p9_a92 out nocopy VARCHAR2
615 , p9_a93 out nocopy NUMBER
616 , p9_a94 out nocopy NUMBER
617 , p9_a95 out nocopy DATE
618 , p9_a96 out nocopy VARCHAR2
619 , p9_a97 out nocopy VARCHAR2
620 , p9_a98 out nocopy NUMBER
621 , p10_a0 out nocopy NUMBER
622 , p10_a1 out nocopy NUMBER
623 , p10_a2 out nocopy NUMBER
624 , p10_a3 out nocopy NUMBER
625 , p10_a4 out nocopy NUMBER
626 , p10_a5 out nocopy NUMBER
627 , p10_a6 out nocopy VARCHAR2
628 , p10_a7 out nocopy VARCHAR2
629 , p10_a8 out nocopy VARCHAR2
630 , p10_a9 out nocopy VARCHAR2
631 , p10_a10 out nocopy VARCHAR2
632 , p10_a11 out nocopy NUMBER
633 , p10_a12 out nocopy VARCHAR2
634 , p10_a13 out nocopy NUMBER
635 , p10_a14 out nocopy VARCHAR2
636 , p10_a15 out nocopy NUMBER
637 , p10_a16 out nocopy DATE
638 , p10_a17 out nocopy NUMBER
639 , p10_a18 out nocopy DATE
640 , p10_a19 out nocopy NUMBER
641 , p5_a0 NUMBER := 0-1962.0724
642 , p5_a1 NUMBER := 0-1962.0724
643 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
644 , p5_a3 NUMBER := 0-1962.0724
645 , p5_a4 NUMBER := 0-1962.0724
646 , p5_a5 NUMBER := 0-1962.0724
647 , p5_a6 NUMBER := 0-1962.0724
648 , p5_a7 NUMBER := 0-1962.0724
649 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
650 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
651 , p5_a10 NUMBER := 0-1962.0724
652 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
653 , p5_a12 NUMBER := 0-1962.0724
654 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
655 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
656 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
657 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
658 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
659 , p5_a18 NUMBER := 0-1962.0724
660 , p5_a19 NUMBER := 0-1962.0724
661 , p5_a20 NUMBER := 0-1962.0724
662 , p5_a21 NUMBER := 0-1962.0724
663 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
664 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
665 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
666 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
667 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
668 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
669 , p5_a28 DATE := fnd_api.g_miss_date
670 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
671 , p5_a30 DATE := fnd_api.g_miss_date
672 , p5_a31 DATE := fnd_api.g_miss_date
673 , p5_a32 DATE := fnd_api.g_miss_date
674 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
675 , p5_a34 NUMBER := 0-1962.0724
676 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
677 , p5_a36 NUMBER := 0-1962.0724
678 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
679 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
680 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
681 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
682 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
683 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
684 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
685 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
686 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
687 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
688 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
689 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
690 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
691 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
692 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
693 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
694 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
695 , p5_a54 NUMBER := 0-1962.0724
696 , p5_a55 DATE := fnd_api.g_miss_date
697 , p5_a56 NUMBER := 0-1962.0724
698 , p5_a57 DATE := fnd_api.g_miss_date
699 , p5_a58 VARCHAR2 := fnd_api.g_miss_char
700 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
701 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
702 , p5_a61 NUMBER := 0-1962.0724
703 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
704 , p5_a63 VARCHAR2 := fnd_api.g_miss_char
705 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
706 , p5_a65 VARCHAR2 := fnd_api.g_miss_char
707 , p5_a66 VARCHAR2 := fnd_api.g_miss_char
708 , p5_a67 NUMBER := 0-1962.0724
709 , p5_a68 NUMBER := 0-1962.0724
710 , p5_a69 NUMBER := 0-1962.0724
711 , p5_a70 DATE := fnd_api.g_miss_date
712 , p5_a71 NUMBER := 0-1962.0724
713 , p5_a72 DATE := fnd_api.g_miss_date
714 , p5_a73 NUMBER := 0-1962.0724
715 , p5_a74 NUMBER := 0-1962.0724
716 , p5_a75 VARCHAR2 := fnd_api.g_miss_char
717 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
718 , p5_a77 NUMBER := 0-1962.0724
719 , p5_a78 NUMBER := 0-1962.0724
720 , p5_a79 VARCHAR2 := fnd_api.g_miss_char
721 , p5_a80 VARCHAR2 := fnd_api.g_miss_char
722 , p5_a81 NUMBER := 0-1962.0724
723 , p5_a82 VARCHAR2 := fnd_api.g_miss_char
724 , p5_a83 NUMBER := 0-1962.0724
725 , p5_a84 NUMBER := 0-1962.0724
726 , p5_a85 NUMBER := 0-1962.0724
727 , p5_a86 NUMBER := 0-1962.0724
728 , p5_a87 VARCHAR2 := fnd_api.g_miss_char
729 , p5_a88 NUMBER := 0-1962.0724
730 , p5_a89 NUMBER := 0-1962.0724
731 , p6_a0 NUMBER := 0-1962.0724
732 , p6_a1 NUMBER := 0-1962.0724
733 , p6_a2 NUMBER := 0-1962.0724
734 , p6_a3 NUMBER := 0-1962.0724
735 , p6_a4 VARCHAR2 := fnd_api.g_miss_char
736 , p6_a5 VARCHAR2 := fnd_api.g_miss_char
737 , p6_a6 VARCHAR2 := fnd_api.g_miss_char
738 , p6_a7 NUMBER := 0-1962.0724
739 , p6_a8 NUMBER := 0-1962.0724
740 , p6_a9 DATE := fnd_api.g_miss_date
741 , p6_a10 NUMBER := 0-1962.0724
742 , p6_a11 NUMBER := 0-1962.0724
743 , p6_a12 NUMBER := 0-1962.0724
744 , p6_a13 NUMBER := 0-1962.0724
745 , p6_a14 NUMBER := 0-1962.0724
746 , p6_a15 NUMBER := 0-1962.0724
747 , p6_a16 NUMBER := 0-1962.0724
748 , p6_a17 NUMBER := 0-1962.0724
749 , p6_a18 NUMBER := 0-1962.0724
750 , p6_a19 NUMBER := 0-1962.0724
751 , p6_a20 DATE := fnd_api.g_miss_date
752 , p6_a21 DATE := fnd_api.g_miss_date
753 , p6_a22 NUMBER := 0-1962.0724
754 , p6_a23 NUMBER := 0-1962.0724
755 , p6_a24 DATE := fnd_api.g_miss_date
756 , p6_a25 DATE := fnd_api.g_miss_date
757 , p6_a26 DATE := fnd_api.g_miss_date
758 , p6_a27 NUMBER := 0-1962.0724
759 , p6_a28 NUMBER := 0-1962.0724
760 , p6_a29 NUMBER := 0-1962.0724
761 , p6_a30 NUMBER := 0-1962.0724
762 , p6_a31 NUMBER := 0-1962.0724
763 , p6_a32 NUMBER := 0-1962.0724
764 , p6_a33 NUMBER := 0-1962.0724
765 , p6_a34 DATE := fnd_api.g_miss_date
766 , p6_a35 VARCHAR2 := fnd_api.g_miss_char
767 , p6_a36 DATE := fnd_api.g_miss_date
768 , p6_a37 VARCHAR2 := fnd_api.g_miss_char
769 , p6_a38 NUMBER := 0-1962.0724
770 , p6_a39 NUMBER := 0-1962.0724
771 , p6_a40 NUMBER := 0-1962.0724
772 , p6_a41 VARCHAR2 := fnd_api.g_miss_char
773 , p6_a42 DATE := fnd_api.g_miss_date
774 , p6_a43 NUMBER := 0-1962.0724
775 , p6_a44 NUMBER := 0-1962.0724
776 , p6_a45 DATE := fnd_api.g_miss_date
777 , p6_a46 NUMBER := 0-1962.0724
778 , p6_a47 DATE := fnd_api.g_miss_date
779 , p6_a48 DATE := fnd_api.g_miss_date
780 , p6_a49 DATE := fnd_api.g_miss_date
781 , p6_a50 NUMBER := 0-1962.0724
782 , p6_a51 NUMBER := 0-1962.0724
783 , p6_a52 VARCHAR2 := fnd_api.g_miss_char
784 , p6_a53 NUMBER := 0-1962.0724
785 , p6_a54 NUMBER := 0-1962.0724
786 , p6_a55 VARCHAR2 := fnd_api.g_miss_char
787 , p6_a56 VARCHAR2 := fnd_api.g_miss_char
788 , p6_a57 NUMBER := 0-1962.0724
789 , p6_a58 DATE := fnd_api.g_miss_date
790 , p6_a59 NUMBER := 0-1962.0724
791 , p6_a60 VARCHAR2 := fnd_api.g_miss_char
792 , p6_a61 VARCHAR2 := fnd_api.g_miss_char
793 , p6_a62 VARCHAR2 := fnd_api.g_miss_char
794 , p6_a63 VARCHAR2 := fnd_api.g_miss_char
795 , p6_a64 VARCHAR2 := fnd_api.g_miss_char
796 , p6_a65 VARCHAR2 := fnd_api.g_miss_char
797 , p6_a66 VARCHAR2 := fnd_api.g_miss_char
798 , p6_a67 VARCHAR2 := fnd_api.g_miss_char
799 , p6_a68 VARCHAR2 := fnd_api.g_miss_char
800 , p6_a69 VARCHAR2 := fnd_api.g_miss_char
801 , p6_a70 VARCHAR2 := fnd_api.g_miss_char
802 , p6_a71 VARCHAR2 := fnd_api.g_miss_char
803 , p6_a72 VARCHAR2 := fnd_api.g_miss_char
804 , p6_a73 VARCHAR2 := fnd_api.g_miss_char
805 , p6_a74 VARCHAR2 := fnd_api.g_miss_char
806 , p6_a75 VARCHAR2 := fnd_api.g_miss_char
807 , p6_a76 NUMBER := 0-1962.0724
808 , p6_a77 NUMBER := 0-1962.0724
809 , p6_a78 NUMBER := 0-1962.0724
810 , p6_a79 DATE := fnd_api.g_miss_date
811 , p6_a80 NUMBER := 0-1962.0724
812 , p6_a81 DATE := fnd_api.g_miss_date
813 , p6_a82 NUMBER := 0-1962.0724
814 , p6_a83 DATE := fnd_api.g_miss_date
815 , p6_a84 DATE := fnd_api.g_miss_date
816 , p6_a85 DATE := fnd_api.g_miss_date
817 , p6_a86 DATE := fnd_api.g_miss_date
818 , p6_a87 NUMBER := 0-1962.0724
819 , p6_a88 NUMBER := 0-1962.0724
820 , p6_a89 NUMBER := 0-1962.0724
821 , p6_a90 VARCHAR2 := fnd_api.g_miss_char
822 , p6_a91 NUMBER := 0-1962.0724
823 , p6_a92 VARCHAR2 := fnd_api.g_miss_char
824 , p6_a93 NUMBER := 0-1962.0724
825 , p6_a94 NUMBER := 0-1962.0724
826 , p6_a95 DATE := fnd_api.g_miss_date
827 , p6_a96 VARCHAR2 := fnd_api.g_miss_char
828 , p6_a97 VARCHAR2 := fnd_api.g_miss_char
829 , p6_a98 NUMBER := 0-1962.0724
830 , p7_a0 NUMBER := 0-1962.0724
831 , p7_a1 NUMBER := 0-1962.0724
832 , p7_a2 NUMBER := 0-1962.0724
833 , p7_a3 NUMBER := 0-1962.0724
834 , p7_a4 NUMBER := 0-1962.0724
835 , p7_a5 NUMBER := 0-1962.0724
836 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
837 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
838 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
839 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
840 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
841 , p7_a11 NUMBER := 0-1962.0724
842 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
843 , p7_a13 NUMBER := 0-1962.0724
844 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
845 , p7_a15 NUMBER := 0-1962.0724
846 , p7_a16 DATE := fnd_api.g_miss_date
847 , p7_a17 NUMBER := 0-1962.0724
848 , p7_a18 DATE := fnd_api.g_miss_date
849 , p7_a19 NUMBER := 0-1962.0724
850 )
851
852 as
853 ddp_clev_rec okl_contract_line_item_pvt.clev_rec_type;
854 ddp_klev_rec okl_contract_line_item_pvt.klev_rec_type;
855 ddp_cimv_rec okl_contract_line_item_pvt.cimv_rec_type;
856 ddx_clev_rec okl_contract_line_item_pvt.clev_rec_type;
857 ddx_klev_rec okl_contract_line_item_pvt.klev_rec_type;
858 ddx_cimv_rec okl_contract_line_item_pvt.cimv_rec_type;
859 ddindx binary_integer; indx binary_integer;
860 begin
861
862 -- copy data to the local IN or IN-OUT args, if any
863
864
865
866
867
868 ddp_clev_rec.id := rosetta_g_miss_num_map(p5_a0);
869 ddp_clev_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
870 ddp_clev_rec.sfwt_flag := p5_a2;
871 ddp_clev_rec.chr_id := rosetta_g_miss_num_map(p5_a3);
872 ddp_clev_rec.cle_id := rosetta_g_miss_num_map(p5_a4);
873 ddp_clev_rec.cle_id_renewed := rosetta_g_miss_num_map(p5_a5);
874 ddp_clev_rec.cle_id_renewed_to := rosetta_g_miss_num_map(p5_a6);
875 ddp_clev_rec.lse_id := rosetta_g_miss_num_map(p5_a7);
876 ddp_clev_rec.line_number := p5_a8;
877 ddp_clev_rec.sts_code := p5_a9;
878 ddp_clev_rec.display_sequence := rosetta_g_miss_num_map(p5_a10);
879 ddp_clev_rec.trn_code := p5_a11;
880 ddp_clev_rec.dnz_chr_id := rosetta_g_miss_num_map(p5_a12);
881 ddp_clev_rec.comments := p5_a13;
882 ddp_clev_rec.item_description := p5_a14;
883 ddp_clev_rec.oke_boe_description := p5_a15;
884 ddp_clev_rec.cognomen := p5_a16;
885 ddp_clev_rec.hidden_ind := p5_a17;
886 ddp_clev_rec.price_unit := rosetta_g_miss_num_map(p5_a18);
887 ddp_clev_rec.price_unit_percent := rosetta_g_miss_num_map(p5_a19);
888 ddp_clev_rec.price_negotiated := rosetta_g_miss_num_map(p5_a20);
889 ddp_clev_rec.price_negotiated_renewed := rosetta_g_miss_num_map(p5_a21);
890 ddp_clev_rec.price_level_ind := p5_a22;
891 ddp_clev_rec.invoice_line_level_ind := p5_a23;
892 ddp_clev_rec.dpas_rating := p5_a24;
893 ddp_clev_rec.block23text := p5_a25;
894 ddp_clev_rec.exception_yn := p5_a26;
895 ddp_clev_rec.template_used := p5_a27;
896 ddp_clev_rec.date_terminated := rosetta_g_miss_date_in_map(p5_a28);
897 ddp_clev_rec.name := p5_a29;
898 ddp_clev_rec.start_date := rosetta_g_miss_date_in_map(p5_a30);
899 ddp_clev_rec.end_date := rosetta_g_miss_date_in_map(p5_a31);
900 ddp_clev_rec.date_renewed := rosetta_g_miss_date_in_map(p5_a32);
901 ddp_clev_rec.upg_orig_system_ref := p5_a33;
902 ddp_clev_rec.upg_orig_system_ref_id := rosetta_g_miss_num_map(p5_a34);
903 ddp_clev_rec.orig_system_source_code := p5_a35;
904 ddp_clev_rec.orig_system_id1 := rosetta_g_miss_num_map(p5_a36);
905 ddp_clev_rec.orig_system_reference1 := p5_a37;
906 ddp_clev_rec.attribute_category := p5_a38;
907 ddp_clev_rec.attribute1 := p5_a39;
908 ddp_clev_rec.attribute2 := p5_a40;
909 ddp_clev_rec.attribute3 := p5_a41;
910 ddp_clev_rec.attribute4 := p5_a42;
911 ddp_clev_rec.attribute5 := p5_a43;
912 ddp_clev_rec.attribute6 := p5_a44;
913 ddp_clev_rec.attribute7 := p5_a45;
914 ddp_clev_rec.attribute8 := p5_a46;
915 ddp_clev_rec.attribute9 := p5_a47;
916 ddp_clev_rec.attribute10 := p5_a48;
917 ddp_clev_rec.attribute11 := p5_a49;
918 ddp_clev_rec.attribute12 := p5_a50;
919 ddp_clev_rec.attribute13 := p5_a51;
920 ddp_clev_rec.attribute14 := p5_a52;
921 ddp_clev_rec.attribute15 := p5_a53;
922 ddp_clev_rec.created_by := rosetta_g_miss_num_map(p5_a54);
923 ddp_clev_rec.creation_date := rosetta_g_miss_date_in_map(p5_a55);
924 ddp_clev_rec.last_updated_by := rosetta_g_miss_num_map(p5_a56);
925 ddp_clev_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
926 ddp_clev_rec.price_type := p5_a58;
927 ddp_clev_rec.currency_code := p5_a59;
928 ddp_clev_rec.currency_code_renewed := p5_a60;
929 ddp_clev_rec.last_update_login := rosetta_g_miss_num_map(p5_a61);
930 ddp_clev_rec.old_sts_code := p5_a62;
931 ddp_clev_rec.new_sts_code := p5_a63;
932 ddp_clev_rec.old_ste_code := p5_a64;
933 ddp_clev_rec.new_ste_code := p5_a65;
934 ddp_clev_rec.call_action_asmblr := p5_a66;
935 ddp_clev_rec.request_id := rosetta_g_miss_num_map(p5_a67);
936 ddp_clev_rec.program_application_id := rosetta_g_miss_num_map(p5_a68);
937 ddp_clev_rec.program_id := rosetta_g_miss_num_map(p5_a69);
938 ddp_clev_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a70);
939 ddp_clev_rec.price_list_id := rosetta_g_miss_num_map(p5_a71);
940 ddp_clev_rec.pricing_date := rosetta_g_miss_date_in_map(p5_a72);
941 ddp_clev_rec.price_list_line_id := rosetta_g_miss_num_map(p5_a73);
942 ddp_clev_rec.line_list_price := rosetta_g_miss_num_map(p5_a74);
943 ddp_clev_rec.item_to_price_yn := p5_a75;
944 ddp_clev_rec.price_basis_yn := p5_a76;
945 ddp_clev_rec.config_header_id := rosetta_g_miss_num_map(p5_a77);
946 ddp_clev_rec.config_revision_number := rosetta_g_miss_num_map(p5_a78);
947 ddp_clev_rec.config_complete_yn := p5_a79;
948 ddp_clev_rec.config_valid_yn := p5_a80;
949 ddp_clev_rec.config_top_model_line_id := rosetta_g_miss_num_map(p5_a81);
950 ddp_clev_rec.config_item_type := p5_a82;
951 ddp_clev_rec.config_item_id := rosetta_g_miss_num_map(p5_a83);
952 ddp_clev_rec.cust_acct_id := rosetta_g_miss_num_map(p5_a84);
953 ddp_clev_rec.bill_to_site_use_id := rosetta_g_miss_num_map(p5_a85);
954 ddp_clev_rec.inv_rule_id := rosetta_g_miss_num_map(p5_a86);
955 ddp_clev_rec.line_renewal_type_code := p5_a87;
956 ddp_clev_rec.ship_to_site_use_id := rosetta_g_miss_num_map(p5_a88);
957 ddp_clev_rec.payment_term_id := rosetta_g_miss_num_map(p5_a89);
958
959 ddp_klev_rec.id := rosetta_g_miss_num_map(p6_a0);
960 ddp_klev_rec.object_version_number := rosetta_g_miss_num_map(p6_a1);
961 ddp_klev_rec.kle_id := rosetta_g_miss_num_map(p6_a2);
962 ddp_klev_rec.sty_id := rosetta_g_miss_num_map(p6_a3);
963 ddp_klev_rec.prc_code := p6_a4;
964 ddp_klev_rec.fcg_code := p6_a5;
965 ddp_klev_rec.nty_code := p6_a6;
966 ddp_klev_rec.estimated_oec := rosetta_g_miss_num_map(p6_a7);
967 ddp_klev_rec.lao_amount := rosetta_g_miss_num_map(p6_a8);
968 ddp_klev_rec.title_date := rosetta_g_miss_date_in_map(p6_a9);
969 ddp_klev_rec.fee_charge := rosetta_g_miss_num_map(p6_a10);
970 ddp_klev_rec.lrs_percent := rosetta_g_miss_num_map(p6_a11);
971 ddp_klev_rec.initial_direct_cost := rosetta_g_miss_num_map(p6_a12);
972 ddp_klev_rec.percent_stake := rosetta_g_miss_num_map(p6_a13);
973 ddp_klev_rec.percent := rosetta_g_miss_num_map(p6_a14);
974 ddp_klev_rec.evergreen_percent := rosetta_g_miss_num_map(p6_a15);
975 ddp_klev_rec.amount_stake := rosetta_g_miss_num_map(p6_a16);
976 ddp_klev_rec.occupancy := rosetta_g_miss_num_map(p6_a17);
977 ddp_klev_rec.coverage := rosetta_g_miss_num_map(p6_a18);
978 ddp_klev_rec.residual_percentage := rosetta_g_miss_num_map(p6_a19);
979 ddp_klev_rec.date_last_inspection := rosetta_g_miss_date_in_map(p6_a20);
980 ddp_klev_rec.date_sold := rosetta_g_miss_date_in_map(p6_a21);
981 ddp_klev_rec.lrv_amount := rosetta_g_miss_num_map(p6_a22);
982 ddp_klev_rec.capital_reduction := rosetta_g_miss_num_map(p6_a23);
983 ddp_klev_rec.date_next_inspection_due := rosetta_g_miss_date_in_map(p6_a24);
984 ddp_klev_rec.date_residual_last_review := rosetta_g_miss_date_in_map(p6_a25);
985 ddp_klev_rec.date_last_reamortisation := rosetta_g_miss_date_in_map(p6_a26);
986 ddp_klev_rec.vendor_advance_paid := rosetta_g_miss_num_map(p6_a27);
987 ddp_klev_rec.weighted_average_life := rosetta_g_miss_num_map(p6_a28);
988 ddp_klev_rec.tradein_amount := rosetta_g_miss_num_map(p6_a29);
989 ddp_klev_rec.bond_equivalent_yield := rosetta_g_miss_num_map(p6_a30);
990 ddp_klev_rec.termination_purchase_amount := rosetta_g_miss_num_map(p6_a31);
991 ddp_klev_rec.refinance_amount := rosetta_g_miss_num_map(p6_a32);
992 ddp_klev_rec.year_built := rosetta_g_miss_num_map(p6_a33);
993 ddp_klev_rec.delivered_date := rosetta_g_miss_date_in_map(p6_a34);
994 ddp_klev_rec.credit_tenant_yn := p6_a35;
995 ddp_klev_rec.date_last_cleanup := rosetta_g_miss_date_in_map(p6_a36);
996 ddp_klev_rec.year_of_manufacture := p6_a37;
997 ddp_klev_rec.coverage_ratio := rosetta_g_miss_num_map(p6_a38);
998 ddp_klev_rec.remarketed_amount := rosetta_g_miss_num_map(p6_a39);
999 ddp_klev_rec.gross_square_footage := rosetta_g_miss_num_map(p6_a40);
1000 ddp_klev_rec.prescribed_asset_yn := p6_a41;
1001 ddp_klev_rec.date_remarketed := rosetta_g_miss_date_in_map(p6_a42);
1002 ddp_klev_rec.net_rentable := rosetta_g_miss_num_map(p6_a43);
1003 ddp_klev_rec.remarket_margin := rosetta_g_miss_num_map(p6_a44);
1004 ddp_klev_rec.date_letter_acceptance := rosetta_g_miss_date_in_map(p6_a45);
1005 ddp_klev_rec.repurchased_amount := rosetta_g_miss_num_map(p6_a46);
1006 ddp_klev_rec.date_commitment_expiration := rosetta_g_miss_date_in_map(p6_a47);
1007 ddp_klev_rec.date_repurchased := rosetta_g_miss_date_in_map(p6_a48);
1008 ddp_klev_rec.date_appraisal := rosetta_g_miss_date_in_map(p6_a49);
1009 ddp_klev_rec.residual_value := rosetta_g_miss_num_map(p6_a50);
1010 ddp_klev_rec.appraisal_value := rosetta_g_miss_num_map(p6_a51);
1011 ddp_klev_rec.secured_deal_yn := p6_a52;
1012 ddp_klev_rec.gain_loss := rosetta_g_miss_num_map(p6_a53);
1013 ddp_klev_rec.floor_amount := rosetta_g_miss_num_map(p6_a54);
1014 ddp_klev_rec.re_lease_yn := p6_a55;
1015 ddp_klev_rec.previous_contract := p6_a56;
1016 ddp_klev_rec.tracked_residual := rosetta_g_miss_num_map(p6_a57);
1017 ddp_klev_rec.date_title_received := rosetta_g_miss_date_in_map(p6_a58);
1018 ddp_klev_rec.amount := rosetta_g_miss_num_map(p6_a59);
1019 ddp_klev_rec.attribute_category := p6_a60;
1020 ddp_klev_rec.attribute1 := p6_a61;
1021 ddp_klev_rec.attribute2 := p6_a62;
1022 ddp_klev_rec.attribute3 := p6_a63;
1023 ddp_klev_rec.attribute4 := p6_a64;
1024 ddp_klev_rec.attribute5 := p6_a65;
1025 ddp_klev_rec.attribute6 := p6_a66;
1026 ddp_klev_rec.attribute7 := p6_a67;
1027 ddp_klev_rec.attribute8 := p6_a68;
1028 ddp_klev_rec.attribute9 := p6_a69;
1029 ddp_klev_rec.attribute10 := p6_a70;
1030 ddp_klev_rec.attribute11 := p6_a71;
1031 ddp_klev_rec.attribute12 := p6_a72;
1032 ddp_klev_rec.attribute13 := p6_a73;
1033 ddp_klev_rec.attribute14 := p6_a74;
1034 ddp_klev_rec.attribute15 := p6_a75;
1035 ddp_klev_rec.sty_id_for := rosetta_g_miss_num_map(p6_a76);
1036 ddp_klev_rec.clg_id := rosetta_g_miss_num_map(p6_a77);
1037 ddp_klev_rec.created_by := rosetta_g_miss_num_map(p6_a78);
1038 ddp_klev_rec.creation_date := rosetta_g_miss_date_in_map(p6_a79);
1039 ddp_klev_rec.last_updated_by := rosetta_g_miss_num_map(p6_a80);
1040 ddp_klev_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a81);
1041 ddp_klev_rec.last_update_login := rosetta_g_miss_num_map(p6_a82);
1042 ddp_klev_rec.date_funding := rosetta_g_miss_date_in_map(p6_a83);
1043 ddp_klev_rec.date_funding_required := rosetta_g_miss_date_in_map(p6_a84);
1044 ddp_klev_rec.date_accepted := rosetta_g_miss_date_in_map(p6_a85);
1045 ddp_klev_rec.date_delivery_expected := rosetta_g_miss_date_in_map(p6_a86);
1046 ddp_klev_rec.oec := rosetta_g_miss_num_map(p6_a87);
1047 ddp_klev_rec.capital_amount := rosetta_g_miss_num_map(p6_a88);
1048 ddp_klev_rec.residual_grnty_amount := rosetta_g_miss_num_map(p6_a89);
1049 ddp_klev_rec.residual_code := p6_a90;
1050 ddp_klev_rec.rvi_premium := rosetta_g_miss_num_map(p6_a91);
1051 ddp_klev_rec.credit_nature := p6_a92;
1052 ddp_klev_rec.capitalized_interest := rosetta_g_miss_num_map(p6_a93);
1053 ddp_klev_rec.capital_reduction_percent := rosetta_g_miss_num_map(p6_a94);
1054 ddp_klev_rec.date_pay_investor_start := rosetta_g_miss_date_in_map(p6_a95);
1055 ddp_klev_rec.pay_investor_frequency := p6_a96;
1056 ddp_klev_rec.pay_investor_event := p6_a97;
1057 ddp_klev_rec.pay_investor_remittance_days := rosetta_g_miss_num_map(p6_a98);
1058
1059 ddp_cimv_rec.id := rosetta_g_miss_num_map(p7_a0);
1060 ddp_cimv_rec.object_version_number := rosetta_g_miss_num_map(p7_a1);
1061 ddp_cimv_rec.cle_id := rosetta_g_miss_num_map(p7_a2);
1062 ddp_cimv_rec.chr_id := rosetta_g_miss_num_map(p7_a3);
1063 ddp_cimv_rec.cle_id_for := rosetta_g_miss_num_map(p7_a4);
1064 ddp_cimv_rec.dnz_chr_id := rosetta_g_miss_num_map(p7_a5);
1065 ddp_cimv_rec.object1_id1 := p7_a6;
1066 ddp_cimv_rec.object1_id2 := p7_a7;
1067 ddp_cimv_rec.jtot_object1_code := p7_a8;
1068 ddp_cimv_rec.uom_code := p7_a9;
1069 ddp_cimv_rec.exception_yn := p7_a10;
1070 ddp_cimv_rec.number_of_items := rosetta_g_miss_num_map(p7_a11);
1071 ddp_cimv_rec.upg_orig_system_ref := p7_a12;
1072 ddp_cimv_rec.upg_orig_system_ref_id := rosetta_g_miss_num_map(p7_a13);
1073 ddp_cimv_rec.priced_item_yn := p7_a14;
1074 ddp_cimv_rec.created_by := rosetta_g_miss_num_map(p7_a15);
1075 ddp_cimv_rec.creation_date := rosetta_g_miss_date_in_map(p7_a16);
1076 ddp_cimv_rec.last_updated_by := rosetta_g_miss_num_map(p7_a17);
1077 ddp_cimv_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a18);
1078 ddp_cimv_rec.last_update_login := rosetta_g_miss_num_map(p7_a19);
1079
1080
1081
1082
1083 -- here's the delegated call to the old PL/SQL routine
1084 okl_contract_line_item_pvt.create_contract_line_item(p_api_version,
1085 p_init_msg_list,
1086 x_return_status,
1087 x_msg_count,
1088 x_msg_data,
1089 ddp_clev_rec,
1090 ddp_klev_rec,
1091 ddp_cimv_rec,
1092 ddx_clev_rec,
1093 ddx_klev_rec,
1094 ddx_cimv_rec);
1095
1096 -- copy data back from the local variables to OUT or IN-OUT args, if any
1097
1098
1099
1100
1101
1102
1103
1104
1105 p8_a0 := rosetta_g_miss_num_map(ddx_clev_rec.id);
1106 p8_a1 := rosetta_g_miss_num_map(ddx_clev_rec.object_version_number);
1107 p8_a2 := ddx_clev_rec.sfwt_flag;
1108 p8_a3 := rosetta_g_miss_num_map(ddx_clev_rec.chr_id);
1109 p8_a4 := rosetta_g_miss_num_map(ddx_clev_rec.cle_id);
1110 p8_a5 := rosetta_g_miss_num_map(ddx_clev_rec.cle_id_renewed);
1111 p8_a6 := rosetta_g_miss_num_map(ddx_clev_rec.cle_id_renewed_to);
1112 p8_a7 := rosetta_g_miss_num_map(ddx_clev_rec.lse_id);
1113 p8_a8 := ddx_clev_rec.line_number;
1114 p8_a9 := ddx_clev_rec.sts_code;
1115 p8_a10 := rosetta_g_miss_num_map(ddx_clev_rec.display_sequence);
1116 p8_a11 := ddx_clev_rec.trn_code;
1117 p8_a12 := rosetta_g_miss_num_map(ddx_clev_rec.dnz_chr_id);
1118 p8_a13 := ddx_clev_rec.comments;
1119 p8_a14 := ddx_clev_rec.item_description;
1120 p8_a15 := ddx_clev_rec.oke_boe_description;
1121 p8_a16 := ddx_clev_rec.cognomen;
1122 p8_a17 := ddx_clev_rec.hidden_ind;
1123 p8_a18 := rosetta_g_miss_num_map(ddx_clev_rec.price_unit);
1124 p8_a19 := rosetta_g_miss_num_map(ddx_clev_rec.price_unit_percent);
1125 p8_a20 := rosetta_g_miss_num_map(ddx_clev_rec.price_negotiated);
1126 p8_a21 := rosetta_g_miss_num_map(ddx_clev_rec.price_negotiated_renewed);
1127 p8_a22 := ddx_clev_rec.price_level_ind;
1128 p8_a23 := ddx_clev_rec.invoice_line_level_ind;
1129 p8_a24 := ddx_clev_rec.dpas_rating;
1130 p8_a25 := ddx_clev_rec.block23text;
1131 p8_a26 := ddx_clev_rec.exception_yn;
1132 p8_a27 := ddx_clev_rec.template_used;
1133 p8_a28 := ddx_clev_rec.date_terminated;
1134 p8_a29 := ddx_clev_rec.name;
1135 p8_a30 := ddx_clev_rec.start_date;
1136 p8_a31 := ddx_clev_rec.end_date;
1137 p8_a32 := ddx_clev_rec.date_renewed;
1138 p8_a33 := ddx_clev_rec.upg_orig_system_ref;
1139 p8_a34 := rosetta_g_miss_num_map(ddx_clev_rec.upg_orig_system_ref_id);
1140 p8_a35 := ddx_clev_rec.orig_system_source_code;
1141 p8_a36 := rosetta_g_miss_num_map(ddx_clev_rec.orig_system_id1);
1142 p8_a37 := ddx_clev_rec.orig_system_reference1;
1143 p8_a38 := ddx_clev_rec.attribute_category;
1144 p8_a39 := ddx_clev_rec.attribute1;
1145 p8_a40 := ddx_clev_rec.attribute2;
1146 p8_a41 := ddx_clev_rec.attribute3;
1147 p8_a42 := ddx_clev_rec.attribute4;
1148 p8_a43 := ddx_clev_rec.attribute5;
1149 p8_a44 := ddx_clev_rec.attribute6;
1150 p8_a45 := ddx_clev_rec.attribute7;
1151 p8_a46 := ddx_clev_rec.attribute8;
1152 p8_a47 := ddx_clev_rec.attribute9;
1153 p8_a48 := ddx_clev_rec.attribute10;
1154 p8_a49 := ddx_clev_rec.attribute11;
1155 p8_a50 := ddx_clev_rec.attribute12;
1156 p8_a51 := ddx_clev_rec.attribute13;
1157 p8_a52 := ddx_clev_rec.attribute14;
1158 p8_a53 := ddx_clev_rec.attribute15;
1159 p8_a54 := rosetta_g_miss_num_map(ddx_clev_rec.created_by);
1160 p8_a55 := ddx_clev_rec.creation_date;
1161 p8_a56 := rosetta_g_miss_num_map(ddx_clev_rec.last_updated_by);
1162 p8_a57 := ddx_clev_rec.last_update_date;
1163 p8_a58 := ddx_clev_rec.price_type;
1164 p8_a59 := ddx_clev_rec.currency_code;
1165 p8_a60 := ddx_clev_rec.currency_code_renewed;
1166 p8_a61 := rosetta_g_miss_num_map(ddx_clev_rec.last_update_login);
1167 p8_a62 := ddx_clev_rec.old_sts_code;
1168 p8_a63 := ddx_clev_rec.new_sts_code;
1169 p8_a64 := ddx_clev_rec.old_ste_code;
1170 p8_a65 := ddx_clev_rec.new_ste_code;
1171 p8_a66 := ddx_clev_rec.call_action_asmblr;
1172 p8_a67 := rosetta_g_miss_num_map(ddx_clev_rec.request_id);
1173 p8_a68 := rosetta_g_miss_num_map(ddx_clev_rec.program_application_id);
1174 p8_a69 := rosetta_g_miss_num_map(ddx_clev_rec.program_id);
1175 p8_a70 := ddx_clev_rec.program_update_date;
1176 p8_a71 := rosetta_g_miss_num_map(ddx_clev_rec.price_list_id);
1177 p8_a72 := ddx_clev_rec.pricing_date;
1178 p8_a73 := rosetta_g_miss_num_map(ddx_clev_rec.price_list_line_id);
1179 p8_a74 := rosetta_g_miss_num_map(ddx_clev_rec.line_list_price);
1180 p8_a75 := ddx_clev_rec.item_to_price_yn;
1181 p8_a76 := ddx_clev_rec.price_basis_yn;
1182 p8_a77 := rosetta_g_miss_num_map(ddx_clev_rec.config_header_id);
1183 p8_a78 := rosetta_g_miss_num_map(ddx_clev_rec.config_revision_number);
1184 p8_a79 := ddx_clev_rec.config_complete_yn;
1185 p8_a80 := ddx_clev_rec.config_valid_yn;
1186 p8_a81 := rosetta_g_miss_num_map(ddx_clev_rec.config_top_model_line_id);
1187 p8_a82 := ddx_clev_rec.config_item_type;
1188 p8_a83 := rosetta_g_miss_num_map(ddx_clev_rec.config_item_id);
1189 p8_a84 := rosetta_g_miss_num_map(ddx_clev_rec.cust_acct_id);
1190 p8_a85 := rosetta_g_miss_num_map(ddx_clev_rec.bill_to_site_use_id);
1191 p8_a86 := rosetta_g_miss_num_map(ddx_clev_rec.inv_rule_id);
1192 p8_a87 := ddx_clev_rec.line_renewal_type_code;
1193 p8_a88 := rosetta_g_miss_num_map(ddx_clev_rec.ship_to_site_use_id);
1194 p8_a89 := rosetta_g_miss_num_map(ddx_clev_rec.payment_term_id);
1195
1196 p9_a0 := rosetta_g_miss_num_map(ddx_klev_rec.id);
1197 p9_a1 := rosetta_g_miss_num_map(ddx_klev_rec.object_version_number);
1198 p9_a2 := rosetta_g_miss_num_map(ddx_klev_rec.kle_id);
1199 p9_a3 := rosetta_g_miss_num_map(ddx_klev_rec.sty_id);
1200 p9_a4 := ddx_klev_rec.prc_code;
1201 p9_a5 := ddx_klev_rec.fcg_code;
1202 p9_a6 := ddx_klev_rec.nty_code;
1203 p9_a7 := rosetta_g_miss_num_map(ddx_klev_rec.estimated_oec);
1204 p9_a8 := rosetta_g_miss_num_map(ddx_klev_rec.lao_amount);
1205 p9_a9 := ddx_klev_rec.title_date;
1206 p9_a10 := rosetta_g_miss_num_map(ddx_klev_rec.fee_charge);
1207 p9_a11 := rosetta_g_miss_num_map(ddx_klev_rec.lrs_percent);
1208 p9_a12 := rosetta_g_miss_num_map(ddx_klev_rec.initial_direct_cost);
1209 p9_a13 := rosetta_g_miss_num_map(ddx_klev_rec.percent_stake);
1210 p9_a14 := rosetta_g_miss_num_map(ddx_klev_rec.percent);
1211 p9_a15 := rosetta_g_miss_num_map(ddx_klev_rec.evergreen_percent);
1212 p9_a16 := rosetta_g_miss_num_map(ddx_klev_rec.amount_stake);
1213 p9_a17 := rosetta_g_miss_num_map(ddx_klev_rec.occupancy);
1214 p9_a18 := rosetta_g_miss_num_map(ddx_klev_rec.coverage);
1215 p9_a19 := rosetta_g_miss_num_map(ddx_klev_rec.residual_percentage);
1216 p9_a20 := ddx_klev_rec.date_last_inspection;
1217 p9_a21 := ddx_klev_rec.date_sold;
1218 p9_a22 := rosetta_g_miss_num_map(ddx_klev_rec.lrv_amount);
1219 p9_a23 := rosetta_g_miss_num_map(ddx_klev_rec.capital_reduction);
1220 p9_a24 := ddx_klev_rec.date_next_inspection_due;
1221 p9_a25 := ddx_klev_rec.date_residual_last_review;
1222 p9_a26 := ddx_klev_rec.date_last_reamortisation;
1223 p9_a27 := rosetta_g_miss_num_map(ddx_klev_rec.vendor_advance_paid);
1224 p9_a28 := rosetta_g_miss_num_map(ddx_klev_rec.weighted_average_life);
1225 p9_a29 := rosetta_g_miss_num_map(ddx_klev_rec.tradein_amount);
1226 p9_a30 := rosetta_g_miss_num_map(ddx_klev_rec.bond_equivalent_yield);
1227 p9_a31 := rosetta_g_miss_num_map(ddx_klev_rec.termination_purchase_amount);
1228 p9_a32 := rosetta_g_miss_num_map(ddx_klev_rec.refinance_amount);
1229 p9_a33 := rosetta_g_miss_num_map(ddx_klev_rec.year_built);
1230 p9_a34 := ddx_klev_rec.delivered_date;
1231 p9_a35 := ddx_klev_rec.credit_tenant_yn;
1232 p9_a36 := ddx_klev_rec.date_last_cleanup;
1233 p9_a37 := ddx_klev_rec.year_of_manufacture;
1234 p9_a38 := rosetta_g_miss_num_map(ddx_klev_rec.coverage_ratio);
1235 p9_a39 := rosetta_g_miss_num_map(ddx_klev_rec.remarketed_amount);
1236 p9_a40 := rosetta_g_miss_num_map(ddx_klev_rec.gross_square_footage);
1237 p9_a41 := ddx_klev_rec.prescribed_asset_yn;
1238 p9_a42 := ddx_klev_rec.date_remarketed;
1239 p9_a43 := rosetta_g_miss_num_map(ddx_klev_rec.net_rentable);
1240 p9_a44 := rosetta_g_miss_num_map(ddx_klev_rec.remarket_margin);
1241 p9_a45 := ddx_klev_rec.date_letter_acceptance;
1242 p9_a46 := rosetta_g_miss_num_map(ddx_klev_rec.repurchased_amount);
1243 p9_a47 := ddx_klev_rec.date_commitment_expiration;
1244 p9_a48 := ddx_klev_rec.date_repurchased;
1245 p9_a49 := ddx_klev_rec.date_appraisal;
1246 p9_a50 := rosetta_g_miss_num_map(ddx_klev_rec.residual_value);
1247 p9_a51 := rosetta_g_miss_num_map(ddx_klev_rec.appraisal_value);
1248 p9_a52 := ddx_klev_rec.secured_deal_yn;
1249 p9_a53 := rosetta_g_miss_num_map(ddx_klev_rec.gain_loss);
1250 p9_a54 := rosetta_g_miss_num_map(ddx_klev_rec.floor_amount);
1251 p9_a55 := ddx_klev_rec.re_lease_yn;
1252 p9_a56 := ddx_klev_rec.previous_contract;
1253 p9_a57 := rosetta_g_miss_num_map(ddx_klev_rec.tracked_residual);
1254 p9_a58 := ddx_klev_rec.date_title_received;
1255 p9_a59 := rosetta_g_miss_num_map(ddx_klev_rec.amount);
1256 p9_a60 := ddx_klev_rec.attribute_category;
1257 p9_a61 := ddx_klev_rec.attribute1;
1258 p9_a62 := ddx_klev_rec.attribute2;
1259 p9_a63 := ddx_klev_rec.attribute3;
1260 p9_a64 := ddx_klev_rec.attribute4;
1261 p9_a65 := ddx_klev_rec.attribute5;
1262 p9_a66 := ddx_klev_rec.attribute6;
1263 p9_a67 := ddx_klev_rec.attribute7;
1264 p9_a68 := ddx_klev_rec.attribute8;
1265 p9_a69 := ddx_klev_rec.attribute9;
1266 p9_a70 := ddx_klev_rec.attribute10;
1267 p9_a71 := ddx_klev_rec.attribute11;
1268 p9_a72 := ddx_klev_rec.attribute12;
1269 p9_a73 := ddx_klev_rec.attribute13;
1270 p9_a74 := ddx_klev_rec.attribute14;
1271 p9_a75 := ddx_klev_rec.attribute15;
1272 p9_a76 := rosetta_g_miss_num_map(ddx_klev_rec.sty_id_for);
1273 p9_a77 := rosetta_g_miss_num_map(ddx_klev_rec.clg_id);
1274 p9_a78 := rosetta_g_miss_num_map(ddx_klev_rec.created_by);
1275 p9_a79 := ddx_klev_rec.creation_date;
1276 p9_a80 := rosetta_g_miss_num_map(ddx_klev_rec.last_updated_by);
1277 p9_a81 := ddx_klev_rec.last_update_date;
1278 p9_a82 := rosetta_g_miss_num_map(ddx_klev_rec.last_update_login);
1279 p9_a83 := ddx_klev_rec.date_funding;
1280 p9_a84 := ddx_klev_rec.date_funding_required;
1281 p9_a85 := ddx_klev_rec.date_accepted;
1282 p9_a86 := ddx_klev_rec.date_delivery_expected;
1283 p9_a87 := rosetta_g_miss_num_map(ddx_klev_rec.oec);
1284 p9_a88 := rosetta_g_miss_num_map(ddx_klev_rec.capital_amount);
1285 p9_a89 := rosetta_g_miss_num_map(ddx_klev_rec.residual_grnty_amount);
1286 p9_a90 := ddx_klev_rec.residual_code;
1287 p9_a91 := rosetta_g_miss_num_map(ddx_klev_rec.rvi_premium);
1288 p9_a92 := ddx_klev_rec.credit_nature;
1289 p9_a93 := rosetta_g_miss_num_map(ddx_klev_rec.capitalized_interest);
1290 p9_a94 := rosetta_g_miss_num_map(ddx_klev_rec.capital_reduction_percent);
1291 p9_a95 := ddx_klev_rec.date_pay_investor_start;
1292 p9_a96 := ddx_klev_rec.pay_investor_frequency;
1293 p9_a97 := ddx_klev_rec.pay_investor_event;
1294 p9_a98 := rosetta_g_miss_num_map(ddx_klev_rec.pay_investor_remittance_days);
1295
1296 p10_a0 := rosetta_g_miss_num_map(ddx_cimv_rec.id);
1297 p10_a1 := rosetta_g_miss_num_map(ddx_cimv_rec.object_version_number);
1298 p10_a2 := rosetta_g_miss_num_map(ddx_cimv_rec.cle_id);
1299 p10_a3 := rosetta_g_miss_num_map(ddx_cimv_rec.chr_id);
1300 p10_a4 := rosetta_g_miss_num_map(ddx_cimv_rec.cle_id_for);
1301 p10_a5 := rosetta_g_miss_num_map(ddx_cimv_rec.dnz_chr_id);
1302 p10_a6 := ddx_cimv_rec.object1_id1;
1303 p10_a7 := ddx_cimv_rec.object1_id2;
1304 p10_a8 := ddx_cimv_rec.jtot_object1_code;
1305 p10_a9 := ddx_cimv_rec.uom_code;
1306 p10_a10 := ddx_cimv_rec.exception_yn;
1307 p10_a11 := rosetta_g_miss_num_map(ddx_cimv_rec.number_of_items);
1308 p10_a12 := ddx_cimv_rec.upg_orig_system_ref;
1309 p10_a13 := rosetta_g_miss_num_map(ddx_cimv_rec.upg_orig_system_ref_id);
1310 p10_a14 := ddx_cimv_rec.priced_item_yn;
1311 p10_a15 := rosetta_g_miss_num_map(ddx_cimv_rec.created_by);
1312 p10_a16 := ddx_cimv_rec.creation_date;
1313 p10_a17 := rosetta_g_miss_num_map(ddx_cimv_rec.last_updated_by);
1314 p10_a18 := ddx_cimv_rec.last_update_date;
1315 p10_a19 := rosetta_g_miss_num_map(ddx_cimv_rec.last_update_login);
1316 end;
1317
1318 procedure update_contract_line_item(p_api_version NUMBER
1319 , p_init_msg_list VARCHAR2
1320 , x_return_status out nocopy VARCHAR2
1321 , x_msg_count out nocopy NUMBER
1322 , x_msg_data out nocopy VARCHAR2
1323 , p8_a0 out nocopy NUMBER
1324 , p8_a1 out nocopy NUMBER
1325 , p8_a2 out nocopy VARCHAR2
1326 , p8_a3 out nocopy NUMBER
1327 , p8_a4 out nocopy NUMBER
1328 , p8_a5 out nocopy NUMBER
1329 , p8_a6 out nocopy NUMBER
1330 , p8_a7 out nocopy NUMBER
1331 , p8_a8 out nocopy VARCHAR2
1332 , p8_a9 out nocopy VARCHAR2
1333 , p8_a10 out nocopy NUMBER
1334 , p8_a11 out nocopy VARCHAR2
1335 , p8_a12 out nocopy NUMBER
1336 , p8_a13 out nocopy VARCHAR2
1337 , p8_a14 out nocopy VARCHAR2
1338 , p8_a15 out nocopy VARCHAR2
1339 , p8_a16 out nocopy VARCHAR2
1340 , p8_a17 out nocopy VARCHAR2
1341 , p8_a18 out nocopy NUMBER
1342 , p8_a19 out nocopy NUMBER
1343 , p8_a20 out nocopy NUMBER
1344 , p8_a21 out nocopy NUMBER
1345 , p8_a22 out nocopy VARCHAR2
1346 , p8_a23 out nocopy VARCHAR2
1347 , p8_a24 out nocopy VARCHAR2
1348 , p8_a25 out nocopy VARCHAR2
1349 , p8_a26 out nocopy VARCHAR2
1350 , p8_a27 out nocopy VARCHAR2
1351 , p8_a28 out nocopy DATE
1352 , p8_a29 out nocopy VARCHAR2
1353 , p8_a30 out nocopy DATE
1354 , p8_a31 out nocopy DATE
1355 , p8_a32 out nocopy DATE
1356 , p8_a33 out nocopy VARCHAR2
1357 , p8_a34 out nocopy NUMBER
1358 , p8_a35 out nocopy VARCHAR2
1359 , p8_a36 out nocopy NUMBER
1360 , p8_a37 out nocopy VARCHAR2
1361 , p8_a38 out nocopy VARCHAR2
1362 , p8_a39 out nocopy VARCHAR2
1363 , p8_a40 out nocopy VARCHAR2
1364 , p8_a41 out nocopy VARCHAR2
1365 , p8_a42 out nocopy VARCHAR2
1366 , p8_a43 out nocopy VARCHAR2
1367 , p8_a44 out nocopy VARCHAR2
1368 , p8_a45 out nocopy VARCHAR2
1369 , p8_a46 out nocopy VARCHAR2
1370 , p8_a47 out nocopy VARCHAR2
1371 , p8_a48 out nocopy VARCHAR2
1372 , p8_a49 out nocopy VARCHAR2
1373 , p8_a50 out nocopy VARCHAR2
1374 , p8_a51 out nocopy VARCHAR2
1375 , p8_a52 out nocopy VARCHAR2
1376 , p8_a53 out nocopy VARCHAR2
1377 , p8_a54 out nocopy NUMBER
1378 , p8_a55 out nocopy DATE
1379 , p8_a56 out nocopy NUMBER
1380 , p8_a57 out nocopy DATE
1381 , p8_a58 out nocopy VARCHAR2
1382 , p8_a59 out nocopy VARCHAR2
1383 , p8_a60 out nocopy VARCHAR2
1384 , p8_a61 out nocopy NUMBER
1385 , p8_a62 out nocopy VARCHAR2
1386 , p8_a63 out nocopy VARCHAR2
1387 , p8_a64 out nocopy VARCHAR2
1388 , p8_a65 out nocopy VARCHAR2
1389 , p8_a66 out nocopy VARCHAR2
1390 , p8_a67 out nocopy NUMBER
1391 , p8_a68 out nocopy NUMBER
1392 , p8_a69 out nocopy NUMBER
1393 , p8_a70 out nocopy DATE
1394 , p8_a71 out nocopy NUMBER
1395 , p8_a72 out nocopy DATE
1396 , p8_a73 out nocopy NUMBER
1397 , p8_a74 out nocopy NUMBER
1398 , p8_a75 out nocopy VARCHAR2
1399 , p8_a76 out nocopy VARCHAR2
1400 , p8_a77 out nocopy NUMBER
1401 , p8_a78 out nocopy NUMBER
1402 , p8_a79 out nocopy VARCHAR2
1403 , p8_a80 out nocopy VARCHAR2
1404 , p8_a81 out nocopy NUMBER
1405 , p8_a82 out nocopy VARCHAR2
1406 , p8_a83 out nocopy NUMBER
1407 , p8_a84 out nocopy NUMBER
1408 , p8_a85 out nocopy NUMBER
1409 , p8_a86 out nocopy NUMBER
1410 , p8_a87 out nocopy VARCHAR2
1411 , p8_a88 out nocopy NUMBER
1412 , p8_a89 out nocopy NUMBER
1413 , p9_a0 out nocopy NUMBER
1414 , p9_a1 out nocopy NUMBER
1415 , p9_a2 out nocopy NUMBER
1416 , p9_a3 out nocopy NUMBER
1417 , p9_a4 out nocopy VARCHAR2
1418 , p9_a5 out nocopy VARCHAR2
1419 , p9_a6 out nocopy VARCHAR2
1420 , p9_a7 out nocopy NUMBER
1421 , p9_a8 out nocopy NUMBER
1422 , p9_a9 out nocopy DATE
1423 , p9_a10 out nocopy NUMBER
1424 , p9_a11 out nocopy NUMBER
1425 , p9_a12 out nocopy NUMBER
1426 , p9_a13 out nocopy NUMBER
1427 , p9_a14 out nocopy NUMBER
1428 , p9_a15 out nocopy NUMBER
1429 , p9_a16 out nocopy NUMBER
1430 , p9_a17 out nocopy NUMBER
1431 , p9_a18 out nocopy NUMBER
1432 , p9_a19 out nocopy NUMBER
1433 , p9_a20 out nocopy DATE
1434 , p9_a21 out nocopy DATE
1435 , p9_a22 out nocopy NUMBER
1436 , p9_a23 out nocopy NUMBER
1437 , p9_a24 out nocopy DATE
1438 , p9_a25 out nocopy DATE
1439 , p9_a26 out nocopy DATE
1440 , p9_a27 out nocopy NUMBER
1441 , p9_a28 out nocopy NUMBER
1442 , p9_a29 out nocopy NUMBER
1443 , p9_a30 out nocopy NUMBER
1444 , p9_a31 out nocopy NUMBER
1445 , p9_a32 out nocopy NUMBER
1446 , p9_a33 out nocopy NUMBER
1447 , p9_a34 out nocopy DATE
1448 , p9_a35 out nocopy VARCHAR2
1449 , p9_a36 out nocopy DATE
1450 , p9_a37 out nocopy VARCHAR2
1451 , p9_a38 out nocopy NUMBER
1452 , p9_a39 out nocopy NUMBER
1453 , p9_a40 out nocopy NUMBER
1454 , p9_a41 out nocopy VARCHAR2
1455 , p9_a42 out nocopy DATE
1456 , p9_a43 out nocopy NUMBER
1457 , p9_a44 out nocopy NUMBER
1458 , p9_a45 out nocopy DATE
1459 , p9_a46 out nocopy NUMBER
1460 , p9_a47 out nocopy DATE
1461 , p9_a48 out nocopy DATE
1462 , p9_a49 out nocopy DATE
1463 , p9_a50 out nocopy NUMBER
1464 , p9_a51 out nocopy NUMBER
1465 , p9_a52 out nocopy VARCHAR2
1466 , p9_a53 out nocopy NUMBER
1467 , p9_a54 out nocopy NUMBER
1468 , p9_a55 out nocopy VARCHAR2
1469 , p9_a56 out nocopy VARCHAR2
1470 , p9_a57 out nocopy NUMBER
1471 , p9_a58 out nocopy DATE
1472 , p9_a59 out nocopy NUMBER
1473 , p9_a60 out nocopy VARCHAR2
1474 , p9_a61 out nocopy VARCHAR2
1475 , p9_a62 out nocopy VARCHAR2
1476 , p9_a63 out nocopy VARCHAR2
1477 , p9_a64 out nocopy VARCHAR2
1478 , p9_a65 out nocopy VARCHAR2
1479 , p9_a66 out nocopy VARCHAR2
1480 , p9_a67 out nocopy VARCHAR2
1481 , p9_a68 out nocopy VARCHAR2
1482 , p9_a69 out nocopy VARCHAR2
1483 , p9_a70 out nocopy VARCHAR2
1484 , p9_a71 out nocopy VARCHAR2
1485 , p9_a72 out nocopy VARCHAR2
1486 , p9_a73 out nocopy VARCHAR2
1487 , p9_a74 out nocopy VARCHAR2
1488 , p9_a75 out nocopy VARCHAR2
1489 , p9_a76 out nocopy NUMBER
1490 , p9_a77 out nocopy NUMBER
1491 , p9_a78 out nocopy NUMBER
1492 , p9_a79 out nocopy DATE
1493 , p9_a80 out nocopy NUMBER
1494 , p9_a81 out nocopy DATE
1495 , p9_a82 out nocopy NUMBER
1496 , p9_a83 out nocopy DATE
1497 , p9_a84 out nocopy DATE
1498 , p9_a85 out nocopy DATE
1499 , p9_a86 out nocopy DATE
1500 , p9_a87 out nocopy NUMBER
1501 , p9_a88 out nocopy NUMBER
1502 , p9_a89 out nocopy NUMBER
1503 , p9_a90 out nocopy VARCHAR2
1504 , p9_a91 out nocopy NUMBER
1505 , p9_a92 out nocopy VARCHAR2
1506 , p9_a93 out nocopy NUMBER
1507 , p9_a94 out nocopy NUMBER
1508 , p9_a95 out nocopy DATE
1509 , p9_a96 out nocopy VARCHAR2
1510 , p9_a97 out nocopy VARCHAR2
1511 , p9_a98 out nocopy NUMBER
1512 , p10_a0 out nocopy NUMBER
1513 , p10_a1 out nocopy NUMBER
1514 , p10_a2 out nocopy NUMBER
1515 , p10_a3 out nocopy NUMBER
1516 , p10_a4 out nocopy NUMBER
1517 , p10_a5 out nocopy NUMBER
1518 , p10_a6 out nocopy VARCHAR2
1519 , p10_a7 out nocopy VARCHAR2
1520 , p10_a8 out nocopy VARCHAR2
1521 , p10_a9 out nocopy VARCHAR2
1522 , p10_a10 out nocopy VARCHAR2
1523 , p10_a11 out nocopy NUMBER
1524 , p10_a12 out nocopy VARCHAR2
1525 , p10_a13 out nocopy NUMBER
1526 , p10_a14 out nocopy VARCHAR2
1527 , p10_a15 out nocopy NUMBER
1528 , p10_a16 out nocopy DATE
1529 , p10_a17 out nocopy NUMBER
1530 , p10_a18 out nocopy DATE
1531 , p10_a19 out nocopy NUMBER
1532 , p5_a0 NUMBER := 0-1962.0724
1533 , p5_a1 NUMBER := 0-1962.0724
1534 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1535 , p5_a3 NUMBER := 0-1962.0724
1536 , p5_a4 NUMBER := 0-1962.0724
1537 , p5_a5 NUMBER := 0-1962.0724
1538 , p5_a6 NUMBER := 0-1962.0724
1539 , p5_a7 NUMBER := 0-1962.0724
1540 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1541 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1542 , p5_a10 NUMBER := 0-1962.0724
1543 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1544 , p5_a12 NUMBER := 0-1962.0724
1545 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1546 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1547 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1548 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1549 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1550 , p5_a18 NUMBER := 0-1962.0724
1551 , p5_a19 NUMBER := 0-1962.0724
1552 , p5_a20 NUMBER := 0-1962.0724
1553 , p5_a21 NUMBER := 0-1962.0724
1554 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1555 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1556 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1557 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1558 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1559 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1560 , p5_a28 DATE := fnd_api.g_miss_date
1561 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1562 , p5_a30 DATE := fnd_api.g_miss_date
1563 , p5_a31 DATE := fnd_api.g_miss_date
1564 , p5_a32 DATE := fnd_api.g_miss_date
1565 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1566 , p5_a34 NUMBER := 0-1962.0724
1567 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1568 , p5_a36 NUMBER := 0-1962.0724
1569 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1570 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1571 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1572 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1573 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1574 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1575 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1576 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1577 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1578 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
1579 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
1580 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1581 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
1582 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
1583 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
1584 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1585 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1586 , p5_a54 NUMBER := 0-1962.0724
1587 , p5_a55 DATE := fnd_api.g_miss_date
1588 , p5_a56 NUMBER := 0-1962.0724
1589 , p5_a57 DATE := fnd_api.g_miss_date
1590 , p5_a58 VARCHAR2 := fnd_api.g_miss_char
1591 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1592 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
1593 , p5_a61 NUMBER := 0-1962.0724
1594 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1595 , p5_a63 VARCHAR2 := fnd_api.g_miss_char
1596 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
1597 , p5_a65 VARCHAR2 := fnd_api.g_miss_char
1598 , p5_a66 VARCHAR2 := fnd_api.g_miss_char
1599 , p5_a67 NUMBER := 0-1962.0724
1600 , p5_a68 NUMBER := 0-1962.0724
1601 , p5_a69 NUMBER := 0-1962.0724
1602 , p5_a70 DATE := fnd_api.g_miss_date
1603 , p5_a71 NUMBER := 0-1962.0724
1604 , p5_a72 DATE := fnd_api.g_miss_date
1605 , p5_a73 NUMBER := 0-1962.0724
1606 , p5_a74 NUMBER := 0-1962.0724
1607 , p5_a75 VARCHAR2 := fnd_api.g_miss_char
1608 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
1609 , p5_a77 NUMBER := 0-1962.0724
1610 , p5_a78 NUMBER := 0-1962.0724
1611 , p5_a79 VARCHAR2 := fnd_api.g_miss_char
1612 , p5_a80 VARCHAR2 := fnd_api.g_miss_char
1613 , p5_a81 NUMBER := 0-1962.0724
1614 , p5_a82 VARCHAR2 := fnd_api.g_miss_char
1615 , p5_a83 NUMBER := 0-1962.0724
1616 , p5_a84 NUMBER := 0-1962.0724
1617 , p5_a85 NUMBER := 0-1962.0724
1618 , p5_a86 NUMBER := 0-1962.0724
1619 , p5_a87 VARCHAR2 := fnd_api.g_miss_char
1620 , p5_a88 NUMBER := 0-1962.0724
1621 , p5_a89 NUMBER := 0-1962.0724
1622 , p6_a0 NUMBER := 0-1962.0724
1623 , p6_a1 NUMBER := 0-1962.0724
1624 , p6_a2 NUMBER := 0-1962.0724
1625 , p6_a3 NUMBER := 0-1962.0724
1626 , p6_a4 VARCHAR2 := fnd_api.g_miss_char
1627 , p6_a5 VARCHAR2 := fnd_api.g_miss_char
1628 , p6_a6 VARCHAR2 := fnd_api.g_miss_char
1629 , p6_a7 NUMBER := 0-1962.0724
1630 , p6_a8 NUMBER := 0-1962.0724
1631 , p6_a9 DATE := fnd_api.g_miss_date
1632 , p6_a10 NUMBER := 0-1962.0724
1633 , p6_a11 NUMBER := 0-1962.0724
1634 , p6_a12 NUMBER := 0-1962.0724
1635 , p6_a13 NUMBER := 0-1962.0724
1636 , p6_a14 NUMBER := 0-1962.0724
1637 , p6_a15 NUMBER := 0-1962.0724
1638 , p6_a16 NUMBER := 0-1962.0724
1639 , p6_a17 NUMBER := 0-1962.0724
1640 , p6_a18 NUMBER := 0-1962.0724
1641 , p6_a19 NUMBER := 0-1962.0724
1642 , p6_a20 DATE := fnd_api.g_miss_date
1643 , p6_a21 DATE := fnd_api.g_miss_date
1644 , p6_a22 NUMBER := 0-1962.0724
1645 , p6_a23 NUMBER := 0-1962.0724
1646 , p6_a24 DATE := fnd_api.g_miss_date
1647 , p6_a25 DATE := fnd_api.g_miss_date
1648 , p6_a26 DATE := fnd_api.g_miss_date
1649 , p6_a27 NUMBER := 0-1962.0724
1650 , p6_a28 NUMBER := 0-1962.0724
1651 , p6_a29 NUMBER := 0-1962.0724
1652 , p6_a30 NUMBER := 0-1962.0724
1653 , p6_a31 NUMBER := 0-1962.0724
1654 , p6_a32 NUMBER := 0-1962.0724
1655 , p6_a33 NUMBER := 0-1962.0724
1656 , p6_a34 DATE := fnd_api.g_miss_date
1657 , p6_a35 VARCHAR2 := fnd_api.g_miss_char
1658 , p6_a36 DATE := fnd_api.g_miss_date
1659 , p6_a37 VARCHAR2 := fnd_api.g_miss_char
1660 , p6_a38 NUMBER := 0-1962.0724
1661 , p6_a39 NUMBER := 0-1962.0724
1662 , p6_a40 NUMBER := 0-1962.0724
1663 , p6_a41 VARCHAR2 := fnd_api.g_miss_char
1664 , p6_a42 DATE := fnd_api.g_miss_date
1665 , p6_a43 NUMBER := 0-1962.0724
1666 , p6_a44 NUMBER := 0-1962.0724
1667 , p6_a45 DATE := fnd_api.g_miss_date
1668 , p6_a46 NUMBER := 0-1962.0724
1669 , p6_a47 DATE := fnd_api.g_miss_date
1670 , p6_a48 DATE := fnd_api.g_miss_date
1671 , p6_a49 DATE := fnd_api.g_miss_date
1672 , p6_a50 NUMBER := 0-1962.0724
1673 , p6_a51 NUMBER := 0-1962.0724
1674 , p6_a52 VARCHAR2 := fnd_api.g_miss_char
1675 , p6_a53 NUMBER := 0-1962.0724
1676 , p6_a54 NUMBER := 0-1962.0724
1677 , p6_a55 VARCHAR2 := fnd_api.g_miss_char
1678 , p6_a56 VARCHAR2 := fnd_api.g_miss_char
1679 , p6_a57 NUMBER := 0-1962.0724
1680 , p6_a58 DATE := fnd_api.g_miss_date
1681 , p6_a59 NUMBER := 0-1962.0724
1682 , p6_a60 VARCHAR2 := fnd_api.g_miss_char
1683 , p6_a61 VARCHAR2 := fnd_api.g_miss_char
1684 , p6_a62 VARCHAR2 := fnd_api.g_miss_char
1685 , p6_a63 VARCHAR2 := fnd_api.g_miss_char
1686 , p6_a64 VARCHAR2 := fnd_api.g_miss_char
1687 , p6_a65 VARCHAR2 := fnd_api.g_miss_char
1688 , p6_a66 VARCHAR2 := fnd_api.g_miss_char
1689 , p6_a67 VARCHAR2 := fnd_api.g_miss_char
1690 , p6_a68 VARCHAR2 := fnd_api.g_miss_char
1691 , p6_a69 VARCHAR2 := fnd_api.g_miss_char
1692 , p6_a70 VARCHAR2 := fnd_api.g_miss_char
1693 , p6_a71 VARCHAR2 := fnd_api.g_miss_char
1694 , p6_a72 VARCHAR2 := fnd_api.g_miss_char
1695 , p6_a73 VARCHAR2 := fnd_api.g_miss_char
1696 , p6_a74 VARCHAR2 := fnd_api.g_miss_char
1697 , p6_a75 VARCHAR2 := fnd_api.g_miss_char
1698 , p6_a76 NUMBER := 0-1962.0724
1699 , p6_a77 NUMBER := 0-1962.0724
1700 , p6_a78 NUMBER := 0-1962.0724
1701 , p6_a79 DATE := fnd_api.g_miss_date
1702 , p6_a80 NUMBER := 0-1962.0724
1703 , p6_a81 DATE := fnd_api.g_miss_date
1704 , p6_a82 NUMBER := 0-1962.0724
1705 , p6_a83 DATE := fnd_api.g_miss_date
1706 , p6_a84 DATE := fnd_api.g_miss_date
1707 , p6_a85 DATE := fnd_api.g_miss_date
1708 , p6_a86 DATE := fnd_api.g_miss_date
1709 , p6_a87 NUMBER := 0-1962.0724
1710 , p6_a88 NUMBER := 0-1962.0724
1711 , p6_a89 NUMBER := 0-1962.0724
1712 , p6_a90 VARCHAR2 := fnd_api.g_miss_char
1713 , p6_a91 NUMBER := 0-1962.0724
1714 , p6_a92 VARCHAR2 := fnd_api.g_miss_char
1715 , p6_a93 NUMBER := 0-1962.0724
1716 , p6_a94 NUMBER := 0-1962.0724
1717 , p6_a95 DATE := fnd_api.g_miss_date
1718 , p6_a96 VARCHAR2 := fnd_api.g_miss_char
1719 , p6_a97 VARCHAR2 := fnd_api.g_miss_char
1720 , p6_a98 NUMBER := 0-1962.0724
1721 , p7_a0 NUMBER := 0-1962.0724
1722 , p7_a1 NUMBER := 0-1962.0724
1723 , p7_a2 NUMBER := 0-1962.0724
1724 , p7_a3 NUMBER := 0-1962.0724
1725 , p7_a4 NUMBER := 0-1962.0724
1726 , p7_a5 NUMBER := 0-1962.0724
1727 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
1728 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
1729 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
1730 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
1731 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
1732 , p7_a11 NUMBER := 0-1962.0724
1733 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
1734 , p7_a13 NUMBER := 0-1962.0724
1735 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
1736 , p7_a15 NUMBER := 0-1962.0724
1737 , p7_a16 DATE := fnd_api.g_miss_date
1738 , p7_a17 NUMBER := 0-1962.0724
1739 , p7_a18 DATE := fnd_api.g_miss_date
1740 , p7_a19 NUMBER := 0-1962.0724
1741 )
1742
1743 as
1744 ddp_clev_rec okl_contract_line_item_pvt.clev_rec_type;
1745 ddp_klev_rec okl_contract_line_item_pvt.klev_rec_type;
1746 ddp_cimv_rec okl_contract_line_item_pvt.cimv_rec_type;
1747 ddx_clev_rec okl_contract_line_item_pvt.clev_rec_type;
1748 ddx_klev_rec okl_contract_line_item_pvt.klev_rec_type;
1749 ddx_cimv_rec okl_contract_line_item_pvt.cimv_rec_type;
1750 ddindx binary_integer; indx binary_integer;
1751 begin
1752
1753 -- copy data to the local IN or IN-OUT args, if any
1754
1755
1756
1757
1758
1759 ddp_clev_rec.id := rosetta_g_miss_num_map(p5_a0);
1760 ddp_clev_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1761 ddp_clev_rec.sfwt_flag := p5_a2;
1762 ddp_clev_rec.chr_id := rosetta_g_miss_num_map(p5_a3);
1763 ddp_clev_rec.cle_id := rosetta_g_miss_num_map(p5_a4);
1764 ddp_clev_rec.cle_id_renewed := rosetta_g_miss_num_map(p5_a5);
1765 ddp_clev_rec.cle_id_renewed_to := rosetta_g_miss_num_map(p5_a6);
1766 ddp_clev_rec.lse_id := rosetta_g_miss_num_map(p5_a7);
1767 ddp_clev_rec.line_number := p5_a8;
1768 ddp_clev_rec.sts_code := p5_a9;
1769 ddp_clev_rec.display_sequence := rosetta_g_miss_num_map(p5_a10);
1770 ddp_clev_rec.trn_code := p5_a11;
1771 ddp_clev_rec.dnz_chr_id := rosetta_g_miss_num_map(p5_a12);
1772 ddp_clev_rec.comments := p5_a13;
1773 ddp_clev_rec.item_description := p5_a14;
1774 ddp_clev_rec.oke_boe_description := p5_a15;
1775 ddp_clev_rec.cognomen := p5_a16;
1776 ddp_clev_rec.hidden_ind := p5_a17;
1777 ddp_clev_rec.price_unit := rosetta_g_miss_num_map(p5_a18);
1778 ddp_clev_rec.price_unit_percent := rosetta_g_miss_num_map(p5_a19);
1779 ddp_clev_rec.price_negotiated := rosetta_g_miss_num_map(p5_a20);
1780 ddp_clev_rec.price_negotiated_renewed := rosetta_g_miss_num_map(p5_a21);
1781 ddp_clev_rec.price_level_ind := p5_a22;
1782 ddp_clev_rec.invoice_line_level_ind := p5_a23;
1783 ddp_clev_rec.dpas_rating := p5_a24;
1784 ddp_clev_rec.block23text := p5_a25;
1785 ddp_clev_rec.exception_yn := p5_a26;
1786 ddp_clev_rec.template_used := p5_a27;
1787 ddp_clev_rec.date_terminated := rosetta_g_miss_date_in_map(p5_a28);
1788 ddp_clev_rec.name := p5_a29;
1789 ddp_clev_rec.start_date := rosetta_g_miss_date_in_map(p5_a30);
1790 ddp_clev_rec.end_date := rosetta_g_miss_date_in_map(p5_a31);
1791 ddp_clev_rec.date_renewed := rosetta_g_miss_date_in_map(p5_a32);
1792 ddp_clev_rec.upg_orig_system_ref := p5_a33;
1793 ddp_clev_rec.upg_orig_system_ref_id := rosetta_g_miss_num_map(p5_a34);
1794 ddp_clev_rec.orig_system_source_code := p5_a35;
1795 ddp_clev_rec.orig_system_id1 := rosetta_g_miss_num_map(p5_a36);
1796 ddp_clev_rec.orig_system_reference1 := p5_a37;
1797 ddp_clev_rec.attribute_category := p5_a38;
1798 ddp_clev_rec.attribute1 := p5_a39;
1799 ddp_clev_rec.attribute2 := p5_a40;
1800 ddp_clev_rec.attribute3 := p5_a41;
1801 ddp_clev_rec.attribute4 := p5_a42;
1802 ddp_clev_rec.attribute5 := p5_a43;
1803 ddp_clev_rec.attribute6 := p5_a44;
1804 ddp_clev_rec.attribute7 := p5_a45;
1805 ddp_clev_rec.attribute8 := p5_a46;
1806 ddp_clev_rec.attribute9 := p5_a47;
1807 ddp_clev_rec.attribute10 := p5_a48;
1808 ddp_clev_rec.attribute11 := p5_a49;
1809 ddp_clev_rec.attribute12 := p5_a50;
1810 ddp_clev_rec.attribute13 := p5_a51;
1811 ddp_clev_rec.attribute14 := p5_a52;
1812 ddp_clev_rec.attribute15 := p5_a53;
1813 ddp_clev_rec.created_by := rosetta_g_miss_num_map(p5_a54);
1814 ddp_clev_rec.creation_date := rosetta_g_miss_date_in_map(p5_a55);
1815 ddp_clev_rec.last_updated_by := rosetta_g_miss_num_map(p5_a56);
1816 ddp_clev_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
1817 ddp_clev_rec.price_type := p5_a58;
1818 ddp_clev_rec.currency_code := p5_a59;
1819 ddp_clev_rec.currency_code_renewed := p5_a60;
1820 ddp_clev_rec.last_update_login := rosetta_g_miss_num_map(p5_a61);
1821 ddp_clev_rec.old_sts_code := p5_a62;
1822 ddp_clev_rec.new_sts_code := p5_a63;
1823 ddp_clev_rec.old_ste_code := p5_a64;
1824 ddp_clev_rec.new_ste_code := p5_a65;
1825 ddp_clev_rec.call_action_asmblr := p5_a66;
1826 ddp_clev_rec.request_id := rosetta_g_miss_num_map(p5_a67);
1827 ddp_clev_rec.program_application_id := rosetta_g_miss_num_map(p5_a68);
1828 ddp_clev_rec.program_id := rosetta_g_miss_num_map(p5_a69);
1829 ddp_clev_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a70);
1830 ddp_clev_rec.price_list_id := rosetta_g_miss_num_map(p5_a71);
1831 ddp_clev_rec.pricing_date := rosetta_g_miss_date_in_map(p5_a72);
1832 ddp_clev_rec.price_list_line_id := rosetta_g_miss_num_map(p5_a73);
1833 ddp_clev_rec.line_list_price := rosetta_g_miss_num_map(p5_a74);
1834 ddp_clev_rec.item_to_price_yn := p5_a75;
1835 ddp_clev_rec.price_basis_yn := p5_a76;
1836 ddp_clev_rec.config_header_id := rosetta_g_miss_num_map(p5_a77);
1837 ddp_clev_rec.config_revision_number := rosetta_g_miss_num_map(p5_a78);
1838 ddp_clev_rec.config_complete_yn := p5_a79;
1839 ddp_clev_rec.config_valid_yn := p5_a80;
1840 ddp_clev_rec.config_top_model_line_id := rosetta_g_miss_num_map(p5_a81);
1841 ddp_clev_rec.config_item_type := p5_a82;
1842 ddp_clev_rec.config_item_id := rosetta_g_miss_num_map(p5_a83);
1843 ddp_clev_rec.cust_acct_id := rosetta_g_miss_num_map(p5_a84);
1844 ddp_clev_rec.bill_to_site_use_id := rosetta_g_miss_num_map(p5_a85);
1845 ddp_clev_rec.inv_rule_id := rosetta_g_miss_num_map(p5_a86);
1846 ddp_clev_rec.line_renewal_type_code := p5_a87;
1847 ddp_clev_rec.ship_to_site_use_id := rosetta_g_miss_num_map(p5_a88);
1848 ddp_clev_rec.payment_term_id := rosetta_g_miss_num_map(p5_a89);
1849
1850 ddp_klev_rec.id := rosetta_g_miss_num_map(p6_a0);
1851 ddp_klev_rec.object_version_number := rosetta_g_miss_num_map(p6_a1);
1852 ddp_klev_rec.kle_id := rosetta_g_miss_num_map(p6_a2);
1853 ddp_klev_rec.sty_id := rosetta_g_miss_num_map(p6_a3);
1854 ddp_klev_rec.prc_code := p6_a4;
1855 ddp_klev_rec.fcg_code := p6_a5;
1856 ddp_klev_rec.nty_code := p6_a6;
1857 ddp_klev_rec.estimated_oec := rosetta_g_miss_num_map(p6_a7);
1858 ddp_klev_rec.lao_amount := rosetta_g_miss_num_map(p6_a8);
1859 ddp_klev_rec.title_date := rosetta_g_miss_date_in_map(p6_a9);
1860 ddp_klev_rec.fee_charge := rosetta_g_miss_num_map(p6_a10);
1861 ddp_klev_rec.lrs_percent := rosetta_g_miss_num_map(p6_a11);
1862 ddp_klev_rec.initial_direct_cost := rosetta_g_miss_num_map(p6_a12);
1863 ddp_klev_rec.percent_stake := rosetta_g_miss_num_map(p6_a13);
1864 ddp_klev_rec.percent := rosetta_g_miss_num_map(p6_a14);
1865 ddp_klev_rec.evergreen_percent := rosetta_g_miss_num_map(p6_a15);
1866 ddp_klev_rec.amount_stake := rosetta_g_miss_num_map(p6_a16);
1867 ddp_klev_rec.occupancy := rosetta_g_miss_num_map(p6_a17);
1868 ddp_klev_rec.coverage := rosetta_g_miss_num_map(p6_a18);
1869 ddp_klev_rec.residual_percentage := rosetta_g_miss_num_map(p6_a19);
1870 ddp_klev_rec.date_last_inspection := rosetta_g_miss_date_in_map(p6_a20);
1871 ddp_klev_rec.date_sold := rosetta_g_miss_date_in_map(p6_a21);
1872 ddp_klev_rec.lrv_amount := rosetta_g_miss_num_map(p6_a22);
1873 ddp_klev_rec.capital_reduction := rosetta_g_miss_num_map(p6_a23);
1874 ddp_klev_rec.date_next_inspection_due := rosetta_g_miss_date_in_map(p6_a24);
1875 ddp_klev_rec.date_residual_last_review := rosetta_g_miss_date_in_map(p6_a25);
1876 ddp_klev_rec.date_last_reamortisation := rosetta_g_miss_date_in_map(p6_a26);
1877 ddp_klev_rec.vendor_advance_paid := rosetta_g_miss_num_map(p6_a27);
1878 ddp_klev_rec.weighted_average_life := rosetta_g_miss_num_map(p6_a28);
1879 ddp_klev_rec.tradein_amount := rosetta_g_miss_num_map(p6_a29);
1880 ddp_klev_rec.bond_equivalent_yield := rosetta_g_miss_num_map(p6_a30);
1881 ddp_klev_rec.termination_purchase_amount := rosetta_g_miss_num_map(p6_a31);
1882 ddp_klev_rec.refinance_amount := rosetta_g_miss_num_map(p6_a32);
1883 ddp_klev_rec.year_built := rosetta_g_miss_num_map(p6_a33);
1884 ddp_klev_rec.delivered_date := rosetta_g_miss_date_in_map(p6_a34);
1885 ddp_klev_rec.credit_tenant_yn := p6_a35;
1886 ddp_klev_rec.date_last_cleanup := rosetta_g_miss_date_in_map(p6_a36);
1887 ddp_klev_rec.year_of_manufacture := p6_a37;
1888 ddp_klev_rec.coverage_ratio := rosetta_g_miss_num_map(p6_a38);
1889 ddp_klev_rec.remarketed_amount := rosetta_g_miss_num_map(p6_a39);
1890 ddp_klev_rec.gross_square_footage := rosetta_g_miss_num_map(p6_a40);
1891 ddp_klev_rec.prescribed_asset_yn := p6_a41;
1892 ddp_klev_rec.date_remarketed := rosetta_g_miss_date_in_map(p6_a42);
1893 ddp_klev_rec.net_rentable := rosetta_g_miss_num_map(p6_a43);
1894 ddp_klev_rec.remarket_margin := rosetta_g_miss_num_map(p6_a44);
1895 ddp_klev_rec.date_letter_acceptance := rosetta_g_miss_date_in_map(p6_a45);
1896 ddp_klev_rec.repurchased_amount := rosetta_g_miss_num_map(p6_a46);
1897 ddp_klev_rec.date_commitment_expiration := rosetta_g_miss_date_in_map(p6_a47);
1898 ddp_klev_rec.date_repurchased := rosetta_g_miss_date_in_map(p6_a48);
1899 ddp_klev_rec.date_appraisal := rosetta_g_miss_date_in_map(p6_a49);
1900 ddp_klev_rec.residual_value := rosetta_g_miss_num_map(p6_a50);
1901 ddp_klev_rec.appraisal_value := rosetta_g_miss_num_map(p6_a51);
1902 ddp_klev_rec.secured_deal_yn := p6_a52;
1903 ddp_klev_rec.gain_loss := rosetta_g_miss_num_map(p6_a53);
1904 ddp_klev_rec.floor_amount := rosetta_g_miss_num_map(p6_a54);
1905 ddp_klev_rec.re_lease_yn := p6_a55;
1906 ddp_klev_rec.previous_contract := p6_a56;
1907 ddp_klev_rec.tracked_residual := rosetta_g_miss_num_map(p6_a57);
1908 ddp_klev_rec.date_title_received := rosetta_g_miss_date_in_map(p6_a58);
1909 ddp_klev_rec.amount := rosetta_g_miss_num_map(p6_a59);
1910 ddp_klev_rec.attribute_category := p6_a60;
1911 ddp_klev_rec.attribute1 := p6_a61;
1912 ddp_klev_rec.attribute2 := p6_a62;
1913 ddp_klev_rec.attribute3 := p6_a63;
1914 ddp_klev_rec.attribute4 := p6_a64;
1915 ddp_klev_rec.attribute5 := p6_a65;
1916 ddp_klev_rec.attribute6 := p6_a66;
1917 ddp_klev_rec.attribute7 := p6_a67;
1918 ddp_klev_rec.attribute8 := p6_a68;
1919 ddp_klev_rec.attribute9 := p6_a69;
1920 ddp_klev_rec.attribute10 := p6_a70;
1921 ddp_klev_rec.attribute11 := p6_a71;
1922 ddp_klev_rec.attribute12 := p6_a72;
1923 ddp_klev_rec.attribute13 := p6_a73;
1924 ddp_klev_rec.attribute14 := p6_a74;
1925 ddp_klev_rec.attribute15 := p6_a75;
1926 ddp_klev_rec.sty_id_for := rosetta_g_miss_num_map(p6_a76);
1927 ddp_klev_rec.clg_id := rosetta_g_miss_num_map(p6_a77);
1928 ddp_klev_rec.created_by := rosetta_g_miss_num_map(p6_a78);
1929 ddp_klev_rec.creation_date := rosetta_g_miss_date_in_map(p6_a79);
1930 ddp_klev_rec.last_updated_by := rosetta_g_miss_num_map(p6_a80);
1931 ddp_klev_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a81);
1932 ddp_klev_rec.last_update_login := rosetta_g_miss_num_map(p6_a82);
1933 ddp_klev_rec.date_funding := rosetta_g_miss_date_in_map(p6_a83);
1934 ddp_klev_rec.date_funding_required := rosetta_g_miss_date_in_map(p6_a84);
1935 ddp_klev_rec.date_accepted := rosetta_g_miss_date_in_map(p6_a85);
1936 ddp_klev_rec.date_delivery_expected := rosetta_g_miss_date_in_map(p6_a86);
1937 ddp_klev_rec.oec := rosetta_g_miss_num_map(p6_a87);
1938 ddp_klev_rec.capital_amount := rosetta_g_miss_num_map(p6_a88);
1939 ddp_klev_rec.residual_grnty_amount := rosetta_g_miss_num_map(p6_a89);
1940 ddp_klev_rec.residual_code := p6_a90;
1941 ddp_klev_rec.rvi_premium := rosetta_g_miss_num_map(p6_a91);
1942 ddp_klev_rec.credit_nature := p6_a92;
1943 ddp_klev_rec.capitalized_interest := rosetta_g_miss_num_map(p6_a93);
1944 ddp_klev_rec.capital_reduction_percent := rosetta_g_miss_num_map(p6_a94);
1945 ddp_klev_rec.date_pay_investor_start := rosetta_g_miss_date_in_map(p6_a95);
1946 ddp_klev_rec.pay_investor_frequency := p6_a96;
1947 ddp_klev_rec.pay_investor_event := p6_a97;
1948 ddp_klev_rec.pay_investor_remittance_days := rosetta_g_miss_num_map(p6_a98);
1949
1950 ddp_cimv_rec.id := rosetta_g_miss_num_map(p7_a0);
1951 ddp_cimv_rec.object_version_number := rosetta_g_miss_num_map(p7_a1);
1952 ddp_cimv_rec.cle_id := rosetta_g_miss_num_map(p7_a2);
1953 ddp_cimv_rec.chr_id := rosetta_g_miss_num_map(p7_a3);
1954 ddp_cimv_rec.cle_id_for := rosetta_g_miss_num_map(p7_a4);
1955 ddp_cimv_rec.dnz_chr_id := rosetta_g_miss_num_map(p7_a5);
1956 ddp_cimv_rec.object1_id1 := p7_a6;
1957 ddp_cimv_rec.object1_id2 := p7_a7;
1958 ddp_cimv_rec.jtot_object1_code := p7_a8;
1959 ddp_cimv_rec.uom_code := p7_a9;
1960 ddp_cimv_rec.exception_yn := p7_a10;
1961 ddp_cimv_rec.number_of_items := rosetta_g_miss_num_map(p7_a11);
1962 ddp_cimv_rec.upg_orig_system_ref := p7_a12;
1963 ddp_cimv_rec.upg_orig_system_ref_id := rosetta_g_miss_num_map(p7_a13);
1964 ddp_cimv_rec.priced_item_yn := p7_a14;
1965 ddp_cimv_rec.created_by := rosetta_g_miss_num_map(p7_a15);
1966 ddp_cimv_rec.creation_date := rosetta_g_miss_date_in_map(p7_a16);
1967 ddp_cimv_rec.last_updated_by := rosetta_g_miss_num_map(p7_a17);
1968 ddp_cimv_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a18);
1969 ddp_cimv_rec.last_update_login := rosetta_g_miss_num_map(p7_a19);
1970
1971
1972
1973
1974 -- here's the delegated call to the old PL/SQL routine
1975 okl_contract_line_item_pvt.update_contract_line_item(p_api_version,
1976 p_init_msg_list,
1977 x_return_status,
1978 x_msg_count,
1979 x_msg_data,
1980 ddp_clev_rec,
1981 ddp_klev_rec,
1982 ddp_cimv_rec,
1983 ddx_clev_rec,
1984 ddx_klev_rec,
1985 ddx_cimv_rec);
1986
1987 -- copy data back from the local variables to OUT or IN-OUT args, if any
1988
1989
1990
1991
1992
1993
1994
1995
1996 p8_a0 := rosetta_g_miss_num_map(ddx_clev_rec.id);
1997 p8_a1 := rosetta_g_miss_num_map(ddx_clev_rec.object_version_number);
1998 p8_a2 := ddx_clev_rec.sfwt_flag;
1999 p8_a3 := rosetta_g_miss_num_map(ddx_clev_rec.chr_id);
2000 p8_a4 := rosetta_g_miss_num_map(ddx_clev_rec.cle_id);
2001 p8_a5 := rosetta_g_miss_num_map(ddx_clev_rec.cle_id_renewed);
2002 p8_a6 := rosetta_g_miss_num_map(ddx_clev_rec.cle_id_renewed_to);
2003 p8_a7 := rosetta_g_miss_num_map(ddx_clev_rec.lse_id);
2004 p8_a8 := ddx_clev_rec.line_number;
2005 p8_a9 := ddx_clev_rec.sts_code;
2006 p8_a10 := rosetta_g_miss_num_map(ddx_clev_rec.display_sequence);
2007 p8_a11 := ddx_clev_rec.trn_code;
2008 p8_a12 := rosetta_g_miss_num_map(ddx_clev_rec.dnz_chr_id);
2009 p8_a13 := ddx_clev_rec.comments;
2010 p8_a14 := ddx_clev_rec.item_description;
2011 p8_a15 := ddx_clev_rec.oke_boe_description;
2012 p8_a16 := ddx_clev_rec.cognomen;
2013 p8_a17 := ddx_clev_rec.hidden_ind;
2014 p8_a18 := rosetta_g_miss_num_map(ddx_clev_rec.price_unit);
2015 p8_a19 := rosetta_g_miss_num_map(ddx_clev_rec.price_unit_percent);
2016 p8_a20 := rosetta_g_miss_num_map(ddx_clev_rec.price_negotiated);
2017 p8_a21 := rosetta_g_miss_num_map(ddx_clev_rec.price_negotiated_renewed);
2018 p8_a22 := ddx_clev_rec.price_level_ind;
2019 p8_a23 := ddx_clev_rec.invoice_line_level_ind;
2020 p8_a24 := ddx_clev_rec.dpas_rating;
2021 p8_a25 := ddx_clev_rec.block23text;
2022 p8_a26 := ddx_clev_rec.exception_yn;
2023 p8_a27 := ddx_clev_rec.template_used;
2024 p8_a28 := ddx_clev_rec.date_terminated;
2025 p8_a29 := ddx_clev_rec.name;
2026 p8_a30 := ddx_clev_rec.start_date;
2027 p8_a31 := ddx_clev_rec.end_date;
2028 p8_a32 := ddx_clev_rec.date_renewed;
2029 p8_a33 := ddx_clev_rec.upg_orig_system_ref;
2030 p8_a34 := rosetta_g_miss_num_map(ddx_clev_rec.upg_orig_system_ref_id);
2031 p8_a35 := ddx_clev_rec.orig_system_source_code;
2032 p8_a36 := rosetta_g_miss_num_map(ddx_clev_rec.orig_system_id1);
2033 p8_a37 := ddx_clev_rec.orig_system_reference1;
2034 p8_a38 := ddx_clev_rec.attribute_category;
2035 p8_a39 := ddx_clev_rec.attribute1;
2036 p8_a40 := ddx_clev_rec.attribute2;
2037 p8_a41 := ddx_clev_rec.attribute3;
2038 p8_a42 := ddx_clev_rec.attribute4;
2039 p8_a43 := ddx_clev_rec.attribute5;
2040 p8_a44 := ddx_clev_rec.attribute6;
2041 p8_a45 := ddx_clev_rec.attribute7;
2042 p8_a46 := ddx_clev_rec.attribute8;
2043 p8_a47 := ddx_clev_rec.attribute9;
2044 p8_a48 := ddx_clev_rec.attribute10;
2045 p8_a49 := ddx_clev_rec.attribute11;
2046 p8_a50 := ddx_clev_rec.attribute12;
2047 p8_a51 := ddx_clev_rec.attribute13;
2048 p8_a52 := ddx_clev_rec.attribute14;
2049 p8_a53 := ddx_clev_rec.attribute15;
2050 p8_a54 := rosetta_g_miss_num_map(ddx_clev_rec.created_by);
2051 p8_a55 := ddx_clev_rec.creation_date;
2052 p8_a56 := rosetta_g_miss_num_map(ddx_clev_rec.last_updated_by);
2053 p8_a57 := ddx_clev_rec.last_update_date;
2054 p8_a58 := ddx_clev_rec.price_type;
2055 p8_a59 := ddx_clev_rec.currency_code;
2056 p8_a60 := ddx_clev_rec.currency_code_renewed;
2057 p8_a61 := rosetta_g_miss_num_map(ddx_clev_rec.last_update_login);
2058 p8_a62 := ddx_clev_rec.old_sts_code;
2059 p8_a63 := ddx_clev_rec.new_sts_code;
2060 p8_a64 := ddx_clev_rec.old_ste_code;
2061 p8_a65 := ddx_clev_rec.new_ste_code;
2062 p8_a66 := ddx_clev_rec.call_action_asmblr;
2063 p8_a67 := rosetta_g_miss_num_map(ddx_clev_rec.request_id);
2064 p8_a68 := rosetta_g_miss_num_map(ddx_clev_rec.program_application_id);
2065 p8_a69 := rosetta_g_miss_num_map(ddx_clev_rec.program_id);
2066 p8_a70 := ddx_clev_rec.program_update_date;
2067 p8_a71 := rosetta_g_miss_num_map(ddx_clev_rec.price_list_id);
2068 p8_a72 := ddx_clev_rec.pricing_date;
2069 p8_a73 := rosetta_g_miss_num_map(ddx_clev_rec.price_list_line_id);
2070 p8_a74 := rosetta_g_miss_num_map(ddx_clev_rec.line_list_price);
2071 p8_a75 := ddx_clev_rec.item_to_price_yn;
2072 p8_a76 := ddx_clev_rec.price_basis_yn;
2073 p8_a77 := rosetta_g_miss_num_map(ddx_clev_rec.config_header_id);
2074 p8_a78 := rosetta_g_miss_num_map(ddx_clev_rec.config_revision_number);
2075 p8_a79 := ddx_clev_rec.config_complete_yn;
2076 p8_a80 := ddx_clev_rec.config_valid_yn;
2077 p8_a81 := rosetta_g_miss_num_map(ddx_clev_rec.config_top_model_line_id);
2078 p8_a82 := ddx_clev_rec.config_item_type;
2079 p8_a83 := rosetta_g_miss_num_map(ddx_clev_rec.config_item_id);
2080 p8_a84 := rosetta_g_miss_num_map(ddx_clev_rec.cust_acct_id);
2081 p8_a85 := rosetta_g_miss_num_map(ddx_clev_rec.bill_to_site_use_id);
2082 p8_a86 := rosetta_g_miss_num_map(ddx_clev_rec.inv_rule_id);
2083 p8_a87 := ddx_clev_rec.line_renewal_type_code;
2084 p8_a88 := rosetta_g_miss_num_map(ddx_clev_rec.ship_to_site_use_id);
2085 p8_a89 := rosetta_g_miss_num_map(ddx_clev_rec.payment_term_id);
2086
2087 p9_a0 := rosetta_g_miss_num_map(ddx_klev_rec.id);
2088 p9_a1 := rosetta_g_miss_num_map(ddx_klev_rec.object_version_number);
2089 p9_a2 := rosetta_g_miss_num_map(ddx_klev_rec.kle_id);
2090 p9_a3 := rosetta_g_miss_num_map(ddx_klev_rec.sty_id);
2091 p9_a4 := ddx_klev_rec.prc_code;
2092 p9_a5 := ddx_klev_rec.fcg_code;
2093 p9_a6 := ddx_klev_rec.nty_code;
2094 p9_a7 := rosetta_g_miss_num_map(ddx_klev_rec.estimated_oec);
2095 p9_a8 := rosetta_g_miss_num_map(ddx_klev_rec.lao_amount);
2096 p9_a9 := ddx_klev_rec.title_date;
2097 p9_a10 := rosetta_g_miss_num_map(ddx_klev_rec.fee_charge);
2098 p9_a11 := rosetta_g_miss_num_map(ddx_klev_rec.lrs_percent);
2099 p9_a12 := rosetta_g_miss_num_map(ddx_klev_rec.initial_direct_cost);
2100 p9_a13 := rosetta_g_miss_num_map(ddx_klev_rec.percent_stake);
2101 p9_a14 := rosetta_g_miss_num_map(ddx_klev_rec.percent);
2102 p9_a15 := rosetta_g_miss_num_map(ddx_klev_rec.evergreen_percent);
2103 p9_a16 := rosetta_g_miss_num_map(ddx_klev_rec.amount_stake);
2104 p9_a17 := rosetta_g_miss_num_map(ddx_klev_rec.occupancy);
2105 p9_a18 := rosetta_g_miss_num_map(ddx_klev_rec.coverage);
2106 p9_a19 := rosetta_g_miss_num_map(ddx_klev_rec.residual_percentage);
2107 p9_a20 := ddx_klev_rec.date_last_inspection;
2108 p9_a21 := ddx_klev_rec.date_sold;
2109 p9_a22 := rosetta_g_miss_num_map(ddx_klev_rec.lrv_amount);
2110 p9_a23 := rosetta_g_miss_num_map(ddx_klev_rec.capital_reduction);
2111 p9_a24 := ddx_klev_rec.date_next_inspection_due;
2112 p9_a25 := ddx_klev_rec.date_residual_last_review;
2113 p9_a26 := ddx_klev_rec.date_last_reamortisation;
2114 p9_a27 := rosetta_g_miss_num_map(ddx_klev_rec.vendor_advance_paid);
2115 p9_a28 := rosetta_g_miss_num_map(ddx_klev_rec.weighted_average_life);
2116 p9_a29 := rosetta_g_miss_num_map(ddx_klev_rec.tradein_amount);
2117 p9_a30 := rosetta_g_miss_num_map(ddx_klev_rec.bond_equivalent_yield);
2118 p9_a31 := rosetta_g_miss_num_map(ddx_klev_rec.termination_purchase_amount);
2119 p9_a32 := rosetta_g_miss_num_map(ddx_klev_rec.refinance_amount);
2120 p9_a33 := rosetta_g_miss_num_map(ddx_klev_rec.year_built);
2121 p9_a34 := ddx_klev_rec.delivered_date;
2122 p9_a35 := ddx_klev_rec.credit_tenant_yn;
2123 p9_a36 := ddx_klev_rec.date_last_cleanup;
2124 p9_a37 := ddx_klev_rec.year_of_manufacture;
2125 p9_a38 := rosetta_g_miss_num_map(ddx_klev_rec.coverage_ratio);
2126 p9_a39 := rosetta_g_miss_num_map(ddx_klev_rec.remarketed_amount);
2127 p9_a40 := rosetta_g_miss_num_map(ddx_klev_rec.gross_square_footage);
2128 p9_a41 := ddx_klev_rec.prescribed_asset_yn;
2129 p9_a42 := ddx_klev_rec.date_remarketed;
2130 p9_a43 := rosetta_g_miss_num_map(ddx_klev_rec.net_rentable);
2131 p9_a44 := rosetta_g_miss_num_map(ddx_klev_rec.remarket_margin);
2132 p9_a45 := ddx_klev_rec.date_letter_acceptance;
2133 p9_a46 := rosetta_g_miss_num_map(ddx_klev_rec.repurchased_amount);
2134 p9_a47 := ddx_klev_rec.date_commitment_expiration;
2135 p9_a48 := ddx_klev_rec.date_repurchased;
2136 p9_a49 := ddx_klev_rec.date_appraisal;
2137 p9_a50 := rosetta_g_miss_num_map(ddx_klev_rec.residual_value);
2138 p9_a51 := rosetta_g_miss_num_map(ddx_klev_rec.appraisal_value);
2139 p9_a52 := ddx_klev_rec.secured_deal_yn;
2140 p9_a53 := rosetta_g_miss_num_map(ddx_klev_rec.gain_loss);
2141 p9_a54 := rosetta_g_miss_num_map(ddx_klev_rec.floor_amount);
2142 p9_a55 := ddx_klev_rec.re_lease_yn;
2143 p9_a56 := ddx_klev_rec.previous_contract;
2144 p9_a57 := rosetta_g_miss_num_map(ddx_klev_rec.tracked_residual);
2145 p9_a58 := ddx_klev_rec.date_title_received;
2146 p9_a59 := rosetta_g_miss_num_map(ddx_klev_rec.amount);
2147 p9_a60 := ddx_klev_rec.attribute_category;
2148 p9_a61 := ddx_klev_rec.attribute1;
2149 p9_a62 := ddx_klev_rec.attribute2;
2150 p9_a63 := ddx_klev_rec.attribute3;
2151 p9_a64 := ddx_klev_rec.attribute4;
2152 p9_a65 := ddx_klev_rec.attribute5;
2153 p9_a66 := ddx_klev_rec.attribute6;
2154 p9_a67 := ddx_klev_rec.attribute7;
2155 p9_a68 := ddx_klev_rec.attribute8;
2156 p9_a69 := ddx_klev_rec.attribute9;
2157 p9_a70 := ddx_klev_rec.attribute10;
2158 p9_a71 := ddx_klev_rec.attribute11;
2159 p9_a72 := ddx_klev_rec.attribute12;
2160 p9_a73 := ddx_klev_rec.attribute13;
2161 p9_a74 := ddx_klev_rec.attribute14;
2162 p9_a75 := ddx_klev_rec.attribute15;
2163 p9_a76 := rosetta_g_miss_num_map(ddx_klev_rec.sty_id_for);
2164 p9_a77 := rosetta_g_miss_num_map(ddx_klev_rec.clg_id);
2165 p9_a78 := rosetta_g_miss_num_map(ddx_klev_rec.created_by);
2166 p9_a79 := ddx_klev_rec.creation_date;
2167 p9_a80 := rosetta_g_miss_num_map(ddx_klev_rec.last_updated_by);
2168 p9_a81 := ddx_klev_rec.last_update_date;
2169 p9_a82 := rosetta_g_miss_num_map(ddx_klev_rec.last_update_login);
2170 p9_a83 := ddx_klev_rec.date_funding;
2171 p9_a84 := ddx_klev_rec.date_funding_required;
2172 p9_a85 := ddx_klev_rec.date_accepted;
2173 p9_a86 := ddx_klev_rec.date_delivery_expected;
2174 p9_a87 := rosetta_g_miss_num_map(ddx_klev_rec.oec);
2175 p9_a88 := rosetta_g_miss_num_map(ddx_klev_rec.capital_amount);
2176 p9_a89 := rosetta_g_miss_num_map(ddx_klev_rec.residual_grnty_amount);
2177 p9_a90 := ddx_klev_rec.residual_code;
2178 p9_a91 := rosetta_g_miss_num_map(ddx_klev_rec.rvi_premium);
2179 p9_a92 := ddx_klev_rec.credit_nature;
2180 p9_a93 := rosetta_g_miss_num_map(ddx_klev_rec.capitalized_interest);
2181 p9_a94 := rosetta_g_miss_num_map(ddx_klev_rec.capital_reduction_percent);
2182 p9_a95 := ddx_klev_rec.date_pay_investor_start;
2183 p9_a96 := ddx_klev_rec.pay_investor_frequency;
2184 p9_a97 := ddx_klev_rec.pay_investor_event;
2185 p9_a98 := rosetta_g_miss_num_map(ddx_klev_rec.pay_investor_remittance_days);
2186
2187 p10_a0 := rosetta_g_miss_num_map(ddx_cimv_rec.id);
2188 p10_a1 := rosetta_g_miss_num_map(ddx_cimv_rec.object_version_number);
2189 p10_a2 := rosetta_g_miss_num_map(ddx_cimv_rec.cle_id);
2190 p10_a3 := rosetta_g_miss_num_map(ddx_cimv_rec.chr_id);
2191 p10_a4 := rosetta_g_miss_num_map(ddx_cimv_rec.cle_id_for);
2192 p10_a5 := rosetta_g_miss_num_map(ddx_cimv_rec.dnz_chr_id);
2193 p10_a6 := ddx_cimv_rec.object1_id1;
2194 p10_a7 := ddx_cimv_rec.object1_id2;
2195 p10_a8 := ddx_cimv_rec.jtot_object1_code;
2196 p10_a9 := ddx_cimv_rec.uom_code;
2197 p10_a10 := ddx_cimv_rec.exception_yn;
2198 p10_a11 := rosetta_g_miss_num_map(ddx_cimv_rec.number_of_items);
2199 p10_a12 := ddx_cimv_rec.upg_orig_system_ref;
2200 p10_a13 := rosetta_g_miss_num_map(ddx_cimv_rec.upg_orig_system_ref_id);
2201 p10_a14 := ddx_cimv_rec.priced_item_yn;
2202 p10_a15 := rosetta_g_miss_num_map(ddx_cimv_rec.created_by);
2203 p10_a16 := ddx_cimv_rec.creation_date;
2204 p10_a17 := rosetta_g_miss_num_map(ddx_cimv_rec.last_updated_by);
2205 p10_a18 := ddx_cimv_rec.last_update_date;
2206 p10_a19 := rosetta_g_miss_num_map(ddx_cimv_rec.last_update_login);
2207 end;
2208
2209 procedure delete_contract_line_item(p_api_version NUMBER
2210 , p_init_msg_list VARCHAR2
2211 , x_return_status out nocopy VARCHAR2
2212 , x_msg_count out nocopy NUMBER
2213 , x_msg_data out nocopy VARCHAR2
2214 , p5_a0 NUMBER := 0-1962.0724
2215 , p5_a1 NUMBER := 0-1962.0724
2216 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2217 , p5_a3 NUMBER := 0-1962.0724
2218 , p5_a4 NUMBER := 0-1962.0724
2219 , p5_a5 NUMBER := 0-1962.0724
2220 , p5_a6 NUMBER := 0-1962.0724
2221 , p5_a7 NUMBER := 0-1962.0724
2222 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2223 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2224 , p5_a10 NUMBER := 0-1962.0724
2225 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2226 , p5_a12 NUMBER := 0-1962.0724
2227 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2228 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2229 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2230 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2231 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2232 , p5_a18 NUMBER := 0-1962.0724
2233 , p5_a19 NUMBER := 0-1962.0724
2234 , p5_a20 NUMBER := 0-1962.0724
2235 , p5_a21 NUMBER := 0-1962.0724
2236 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2237 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2238 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2239 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2240 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2241 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2242 , p5_a28 DATE := fnd_api.g_miss_date
2243 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2244 , p5_a30 DATE := fnd_api.g_miss_date
2245 , p5_a31 DATE := fnd_api.g_miss_date
2246 , p5_a32 DATE := fnd_api.g_miss_date
2247 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2248 , p5_a34 NUMBER := 0-1962.0724
2249 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2250 , p5_a36 NUMBER := 0-1962.0724
2251 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2252 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2253 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2254 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
2255 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
2256 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2257 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
2258 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
2259 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
2260 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
2261 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
2262 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
2263 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
2264 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
2265 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
2266 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
2267 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
2268 , p5_a54 NUMBER := 0-1962.0724
2269 , p5_a55 DATE := fnd_api.g_miss_date
2270 , p5_a56 NUMBER := 0-1962.0724
2271 , p5_a57 DATE := fnd_api.g_miss_date
2272 , p5_a58 VARCHAR2 := fnd_api.g_miss_char
2273 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
2274 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
2275 , p5_a61 NUMBER := 0-1962.0724
2276 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
2277 , p5_a63 VARCHAR2 := fnd_api.g_miss_char
2278 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
2279 , p5_a65 VARCHAR2 := fnd_api.g_miss_char
2280 , p5_a66 VARCHAR2 := fnd_api.g_miss_char
2281 , p5_a67 NUMBER := 0-1962.0724
2282 , p5_a68 NUMBER := 0-1962.0724
2283 , p5_a69 NUMBER := 0-1962.0724
2284 , p5_a70 DATE := fnd_api.g_miss_date
2285 , p5_a71 NUMBER := 0-1962.0724
2286 , p5_a72 DATE := fnd_api.g_miss_date
2287 , p5_a73 NUMBER := 0-1962.0724
2288 , p5_a74 NUMBER := 0-1962.0724
2289 , p5_a75 VARCHAR2 := fnd_api.g_miss_char
2290 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
2291 , p5_a77 NUMBER := 0-1962.0724
2292 , p5_a78 NUMBER := 0-1962.0724
2293 , p5_a79 VARCHAR2 := fnd_api.g_miss_char
2294 , p5_a80 VARCHAR2 := fnd_api.g_miss_char
2295 , p5_a81 NUMBER := 0-1962.0724
2296 , p5_a82 VARCHAR2 := fnd_api.g_miss_char
2297 , p5_a83 NUMBER := 0-1962.0724
2298 , p5_a84 NUMBER := 0-1962.0724
2299 , p5_a85 NUMBER := 0-1962.0724
2300 , p5_a86 NUMBER := 0-1962.0724
2301 , p5_a87 VARCHAR2 := fnd_api.g_miss_char
2302 , p5_a88 NUMBER := 0-1962.0724
2303 , p5_a89 NUMBER := 0-1962.0724
2304 , p6_a0 NUMBER := 0-1962.0724
2305 , p6_a1 NUMBER := 0-1962.0724
2306 , p6_a2 NUMBER := 0-1962.0724
2307 , p6_a3 NUMBER := 0-1962.0724
2308 , p6_a4 VARCHAR2 := fnd_api.g_miss_char
2309 , p6_a5 VARCHAR2 := fnd_api.g_miss_char
2310 , p6_a6 VARCHAR2 := fnd_api.g_miss_char
2311 , p6_a7 NUMBER := 0-1962.0724
2312 , p6_a8 NUMBER := 0-1962.0724
2313 , p6_a9 DATE := fnd_api.g_miss_date
2314 , p6_a10 NUMBER := 0-1962.0724
2315 , p6_a11 NUMBER := 0-1962.0724
2316 , p6_a12 NUMBER := 0-1962.0724
2317 , p6_a13 NUMBER := 0-1962.0724
2318 , p6_a14 NUMBER := 0-1962.0724
2319 , p6_a15 NUMBER := 0-1962.0724
2320 , p6_a16 NUMBER := 0-1962.0724
2321 , p6_a17 NUMBER := 0-1962.0724
2322 , p6_a18 NUMBER := 0-1962.0724
2323 , p6_a19 NUMBER := 0-1962.0724
2324 , p6_a20 DATE := fnd_api.g_miss_date
2325 , p6_a21 DATE := fnd_api.g_miss_date
2326 , p6_a22 NUMBER := 0-1962.0724
2327 , p6_a23 NUMBER := 0-1962.0724
2328 , p6_a24 DATE := fnd_api.g_miss_date
2329 , p6_a25 DATE := fnd_api.g_miss_date
2330 , p6_a26 DATE := fnd_api.g_miss_date
2331 , p6_a27 NUMBER := 0-1962.0724
2332 , p6_a28 NUMBER := 0-1962.0724
2333 , p6_a29 NUMBER := 0-1962.0724
2334 , p6_a30 NUMBER := 0-1962.0724
2335 , p6_a31 NUMBER := 0-1962.0724
2336 , p6_a32 NUMBER := 0-1962.0724
2337 , p6_a33 NUMBER := 0-1962.0724
2338 , p6_a34 DATE := fnd_api.g_miss_date
2339 , p6_a35 VARCHAR2 := fnd_api.g_miss_char
2340 , p6_a36 DATE := fnd_api.g_miss_date
2341 , p6_a37 VARCHAR2 := fnd_api.g_miss_char
2342 , p6_a38 NUMBER := 0-1962.0724
2343 , p6_a39 NUMBER := 0-1962.0724
2344 , p6_a40 NUMBER := 0-1962.0724
2345 , p6_a41 VARCHAR2 := fnd_api.g_miss_char
2346 , p6_a42 DATE := fnd_api.g_miss_date
2347 , p6_a43 NUMBER := 0-1962.0724
2348 , p6_a44 NUMBER := 0-1962.0724
2349 , p6_a45 DATE := fnd_api.g_miss_date
2350 , p6_a46 NUMBER := 0-1962.0724
2351 , p6_a47 DATE := fnd_api.g_miss_date
2352 , p6_a48 DATE := fnd_api.g_miss_date
2353 , p6_a49 DATE := fnd_api.g_miss_date
2354 , p6_a50 NUMBER := 0-1962.0724
2355 , p6_a51 NUMBER := 0-1962.0724
2356 , p6_a52 VARCHAR2 := fnd_api.g_miss_char
2357 , p6_a53 NUMBER := 0-1962.0724
2358 , p6_a54 NUMBER := 0-1962.0724
2359 , p6_a55 VARCHAR2 := fnd_api.g_miss_char
2360 , p6_a56 VARCHAR2 := fnd_api.g_miss_char
2361 , p6_a57 NUMBER := 0-1962.0724
2362 , p6_a58 DATE := fnd_api.g_miss_date
2363 , p6_a59 NUMBER := 0-1962.0724
2364 , p6_a60 VARCHAR2 := fnd_api.g_miss_char
2365 , p6_a61 VARCHAR2 := fnd_api.g_miss_char
2366 , p6_a62 VARCHAR2 := fnd_api.g_miss_char
2367 , p6_a63 VARCHAR2 := fnd_api.g_miss_char
2368 , p6_a64 VARCHAR2 := fnd_api.g_miss_char
2369 , p6_a65 VARCHAR2 := fnd_api.g_miss_char
2370 , p6_a66 VARCHAR2 := fnd_api.g_miss_char
2371 , p6_a67 VARCHAR2 := fnd_api.g_miss_char
2372 , p6_a68 VARCHAR2 := fnd_api.g_miss_char
2373 , p6_a69 VARCHAR2 := fnd_api.g_miss_char
2374 , p6_a70 VARCHAR2 := fnd_api.g_miss_char
2375 , p6_a71 VARCHAR2 := fnd_api.g_miss_char
2376 , p6_a72 VARCHAR2 := fnd_api.g_miss_char
2377 , p6_a73 VARCHAR2 := fnd_api.g_miss_char
2378 , p6_a74 VARCHAR2 := fnd_api.g_miss_char
2379 , p6_a75 VARCHAR2 := fnd_api.g_miss_char
2380 , p6_a76 NUMBER := 0-1962.0724
2381 , p6_a77 NUMBER := 0-1962.0724
2382 , p6_a78 NUMBER := 0-1962.0724
2383 , p6_a79 DATE := fnd_api.g_miss_date
2384 , p6_a80 NUMBER := 0-1962.0724
2385 , p6_a81 DATE := fnd_api.g_miss_date
2386 , p6_a82 NUMBER := 0-1962.0724
2387 , p6_a83 DATE := fnd_api.g_miss_date
2388 , p6_a84 DATE := fnd_api.g_miss_date
2389 , p6_a85 DATE := fnd_api.g_miss_date
2390 , p6_a86 DATE := fnd_api.g_miss_date
2391 , p6_a87 NUMBER := 0-1962.0724
2392 , p6_a88 NUMBER := 0-1962.0724
2393 , p6_a89 NUMBER := 0-1962.0724
2394 , p6_a90 VARCHAR2 := fnd_api.g_miss_char
2395 , p6_a91 NUMBER := 0-1962.0724
2396 , p6_a92 VARCHAR2 := fnd_api.g_miss_char
2397 , p6_a93 NUMBER := 0-1962.0724
2398 , p6_a94 NUMBER := 0-1962.0724
2399 , p6_a95 DATE := fnd_api.g_miss_date
2400 , p6_a96 VARCHAR2 := fnd_api.g_miss_char
2401 , p6_a97 VARCHAR2 := fnd_api.g_miss_char
2402 , p6_a98 NUMBER := 0-1962.0724
2403 , p7_a0 NUMBER := 0-1962.0724
2404 , p7_a1 NUMBER := 0-1962.0724
2405 , p7_a2 NUMBER := 0-1962.0724
2406 , p7_a3 NUMBER := 0-1962.0724
2407 , p7_a4 NUMBER := 0-1962.0724
2408 , p7_a5 NUMBER := 0-1962.0724
2409 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
2410 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
2411 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
2412 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
2413 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
2414 , p7_a11 NUMBER := 0-1962.0724
2415 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
2416 , p7_a13 NUMBER := 0-1962.0724
2417 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
2418 , p7_a15 NUMBER := 0-1962.0724
2419 , p7_a16 DATE := fnd_api.g_miss_date
2420 , p7_a17 NUMBER := 0-1962.0724
2421 , p7_a18 DATE := fnd_api.g_miss_date
2422 , p7_a19 NUMBER := 0-1962.0724
2423 )
2424
2425 as
2426 ddp_clev_rec okl_contract_line_item_pvt.clev_rec_type;
2427 ddp_klev_rec okl_contract_line_item_pvt.klev_rec_type;
2428 ddp_cimv_rec okl_contract_line_item_pvt.cimv_rec_type;
2429 ddindx binary_integer; indx binary_integer;
2430 begin
2431
2432 -- copy data to the local IN or IN-OUT args, if any
2433
2434
2435
2436
2437
2438 ddp_clev_rec.id := rosetta_g_miss_num_map(p5_a0);
2439 ddp_clev_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
2440 ddp_clev_rec.sfwt_flag := p5_a2;
2441 ddp_clev_rec.chr_id := rosetta_g_miss_num_map(p5_a3);
2442 ddp_clev_rec.cle_id := rosetta_g_miss_num_map(p5_a4);
2443 ddp_clev_rec.cle_id_renewed := rosetta_g_miss_num_map(p5_a5);
2444 ddp_clev_rec.cle_id_renewed_to := rosetta_g_miss_num_map(p5_a6);
2445 ddp_clev_rec.lse_id := rosetta_g_miss_num_map(p5_a7);
2446 ddp_clev_rec.line_number := p5_a8;
2447 ddp_clev_rec.sts_code := p5_a9;
2448 ddp_clev_rec.display_sequence := rosetta_g_miss_num_map(p5_a10);
2449 ddp_clev_rec.trn_code := p5_a11;
2450 ddp_clev_rec.dnz_chr_id := rosetta_g_miss_num_map(p5_a12);
2451 ddp_clev_rec.comments := p5_a13;
2452 ddp_clev_rec.item_description := p5_a14;
2453 ddp_clev_rec.oke_boe_description := p5_a15;
2454 ddp_clev_rec.cognomen := p5_a16;
2455 ddp_clev_rec.hidden_ind := p5_a17;
2456 ddp_clev_rec.price_unit := rosetta_g_miss_num_map(p5_a18);
2457 ddp_clev_rec.price_unit_percent := rosetta_g_miss_num_map(p5_a19);
2458 ddp_clev_rec.price_negotiated := rosetta_g_miss_num_map(p5_a20);
2459 ddp_clev_rec.price_negotiated_renewed := rosetta_g_miss_num_map(p5_a21);
2460 ddp_clev_rec.price_level_ind := p5_a22;
2461 ddp_clev_rec.invoice_line_level_ind := p5_a23;
2462 ddp_clev_rec.dpas_rating := p5_a24;
2463 ddp_clev_rec.block23text := p5_a25;
2464 ddp_clev_rec.exception_yn := p5_a26;
2465 ddp_clev_rec.template_used := p5_a27;
2466 ddp_clev_rec.date_terminated := rosetta_g_miss_date_in_map(p5_a28);
2467 ddp_clev_rec.name := p5_a29;
2468 ddp_clev_rec.start_date := rosetta_g_miss_date_in_map(p5_a30);
2469 ddp_clev_rec.end_date := rosetta_g_miss_date_in_map(p5_a31);
2470 ddp_clev_rec.date_renewed := rosetta_g_miss_date_in_map(p5_a32);
2471 ddp_clev_rec.upg_orig_system_ref := p5_a33;
2472 ddp_clev_rec.upg_orig_system_ref_id := rosetta_g_miss_num_map(p5_a34);
2473 ddp_clev_rec.orig_system_source_code := p5_a35;
2474 ddp_clev_rec.orig_system_id1 := rosetta_g_miss_num_map(p5_a36);
2475 ddp_clev_rec.orig_system_reference1 := p5_a37;
2476 ddp_clev_rec.attribute_category := p5_a38;
2477 ddp_clev_rec.attribute1 := p5_a39;
2478 ddp_clev_rec.attribute2 := p5_a40;
2479 ddp_clev_rec.attribute3 := p5_a41;
2480 ddp_clev_rec.attribute4 := p5_a42;
2481 ddp_clev_rec.attribute5 := p5_a43;
2482 ddp_clev_rec.attribute6 := p5_a44;
2483 ddp_clev_rec.attribute7 := p5_a45;
2484 ddp_clev_rec.attribute8 := p5_a46;
2485 ddp_clev_rec.attribute9 := p5_a47;
2486 ddp_clev_rec.attribute10 := p5_a48;
2487 ddp_clev_rec.attribute11 := p5_a49;
2488 ddp_clev_rec.attribute12 := p5_a50;
2489 ddp_clev_rec.attribute13 := p5_a51;
2490 ddp_clev_rec.attribute14 := p5_a52;
2491 ddp_clev_rec.attribute15 := p5_a53;
2492 ddp_clev_rec.created_by := rosetta_g_miss_num_map(p5_a54);
2493 ddp_clev_rec.creation_date := rosetta_g_miss_date_in_map(p5_a55);
2494 ddp_clev_rec.last_updated_by := rosetta_g_miss_num_map(p5_a56);
2495 ddp_clev_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
2496 ddp_clev_rec.price_type := p5_a58;
2497 ddp_clev_rec.currency_code := p5_a59;
2498 ddp_clev_rec.currency_code_renewed := p5_a60;
2499 ddp_clev_rec.last_update_login := rosetta_g_miss_num_map(p5_a61);
2500 ddp_clev_rec.old_sts_code := p5_a62;
2501 ddp_clev_rec.new_sts_code := p5_a63;
2502 ddp_clev_rec.old_ste_code := p5_a64;
2503 ddp_clev_rec.new_ste_code := p5_a65;
2504 ddp_clev_rec.call_action_asmblr := p5_a66;
2505 ddp_clev_rec.request_id := rosetta_g_miss_num_map(p5_a67);
2506 ddp_clev_rec.program_application_id := rosetta_g_miss_num_map(p5_a68);
2507 ddp_clev_rec.program_id := rosetta_g_miss_num_map(p5_a69);
2508 ddp_clev_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a70);
2509 ddp_clev_rec.price_list_id := rosetta_g_miss_num_map(p5_a71);
2510 ddp_clev_rec.pricing_date := rosetta_g_miss_date_in_map(p5_a72);
2511 ddp_clev_rec.price_list_line_id := rosetta_g_miss_num_map(p5_a73);
2512 ddp_clev_rec.line_list_price := rosetta_g_miss_num_map(p5_a74);
2513 ddp_clev_rec.item_to_price_yn := p5_a75;
2514 ddp_clev_rec.price_basis_yn := p5_a76;
2515 ddp_clev_rec.config_header_id := rosetta_g_miss_num_map(p5_a77);
2516 ddp_clev_rec.config_revision_number := rosetta_g_miss_num_map(p5_a78);
2517 ddp_clev_rec.config_complete_yn := p5_a79;
2518 ddp_clev_rec.config_valid_yn := p5_a80;
2519 ddp_clev_rec.config_top_model_line_id := rosetta_g_miss_num_map(p5_a81);
2520 ddp_clev_rec.config_item_type := p5_a82;
2521 ddp_clev_rec.config_item_id := rosetta_g_miss_num_map(p5_a83);
2522 ddp_clev_rec.cust_acct_id := rosetta_g_miss_num_map(p5_a84);
2523 ddp_clev_rec.bill_to_site_use_id := rosetta_g_miss_num_map(p5_a85);
2524 ddp_clev_rec.inv_rule_id := rosetta_g_miss_num_map(p5_a86);
2525 ddp_clev_rec.line_renewal_type_code := p5_a87;
2526 ddp_clev_rec.ship_to_site_use_id := rosetta_g_miss_num_map(p5_a88);
2527 ddp_clev_rec.payment_term_id := rosetta_g_miss_num_map(p5_a89);
2528
2529 ddp_klev_rec.id := rosetta_g_miss_num_map(p6_a0);
2530 ddp_klev_rec.object_version_number := rosetta_g_miss_num_map(p6_a1);
2531 ddp_klev_rec.kle_id := rosetta_g_miss_num_map(p6_a2);
2532 ddp_klev_rec.sty_id := rosetta_g_miss_num_map(p6_a3);
2533 ddp_klev_rec.prc_code := p6_a4;
2534 ddp_klev_rec.fcg_code := p6_a5;
2535 ddp_klev_rec.nty_code := p6_a6;
2536 ddp_klev_rec.estimated_oec := rosetta_g_miss_num_map(p6_a7);
2537 ddp_klev_rec.lao_amount := rosetta_g_miss_num_map(p6_a8);
2538 ddp_klev_rec.title_date := rosetta_g_miss_date_in_map(p6_a9);
2539 ddp_klev_rec.fee_charge := rosetta_g_miss_num_map(p6_a10);
2540 ddp_klev_rec.lrs_percent := rosetta_g_miss_num_map(p6_a11);
2541 ddp_klev_rec.initial_direct_cost := rosetta_g_miss_num_map(p6_a12);
2542 ddp_klev_rec.percent_stake := rosetta_g_miss_num_map(p6_a13);
2543 ddp_klev_rec.percent := rosetta_g_miss_num_map(p6_a14);
2544 ddp_klev_rec.evergreen_percent := rosetta_g_miss_num_map(p6_a15);
2545 ddp_klev_rec.amount_stake := rosetta_g_miss_num_map(p6_a16);
2546 ddp_klev_rec.occupancy := rosetta_g_miss_num_map(p6_a17);
2547 ddp_klev_rec.coverage := rosetta_g_miss_num_map(p6_a18);
2548 ddp_klev_rec.residual_percentage := rosetta_g_miss_num_map(p6_a19);
2549 ddp_klev_rec.date_last_inspection := rosetta_g_miss_date_in_map(p6_a20);
2550 ddp_klev_rec.date_sold := rosetta_g_miss_date_in_map(p6_a21);
2551 ddp_klev_rec.lrv_amount := rosetta_g_miss_num_map(p6_a22);
2552 ddp_klev_rec.capital_reduction := rosetta_g_miss_num_map(p6_a23);
2553 ddp_klev_rec.date_next_inspection_due := rosetta_g_miss_date_in_map(p6_a24);
2554 ddp_klev_rec.date_residual_last_review := rosetta_g_miss_date_in_map(p6_a25);
2555 ddp_klev_rec.date_last_reamortisation := rosetta_g_miss_date_in_map(p6_a26);
2556 ddp_klev_rec.vendor_advance_paid := rosetta_g_miss_num_map(p6_a27);
2557 ddp_klev_rec.weighted_average_life := rosetta_g_miss_num_map(p6_a28);
2558 ddp_klev_rec.tradein_amount := rosetta_g_miss_num_map(p6_a29);
2559 ddp_klev_rec.bond_equivalent_yield := rosetta_g_miss_num_map(p6_a30);
2560 ddp_klev_rec.termination_purchase_amount := rosetta_g_miss_num_map(p6_a31);
2561 ddp_klev_rec.refinance_amount := rosetta_g_miss_num_map(p6_a32);
2562 ddp_klev_rec.year_built := rosetta_g_miss_num_map(p6_a33);
2563 ddp_klev_rec.delivered_date := rosetta_g_miss_date_in_map(p6_a34);
2564 ddp_klev_rec.credit_tenant_yn := p6_a35;
2565 ddp_klev_rec.date_last_cleanup := rosetta_g_miss_date_in_map(p6_a36);
2566 ddp_klev_rec.year_of_manufacture := p6_a37;
2567 ddp_klev_rec.coverage_ratio := rosetta_g_miss_num_map(p6_a38);
2568 ddp_klev_rec.remarketed_amount := rosetta_g_miss_num_map(p6_a39);
2569 ddp_klev_rec.gross_square_footage := rosetta_g_miss_num_map(p6_a40);
2570 ddp_klev_rec.prescribed_asset_yn := p6_a41;
2571 ddp_klev_rec.date_remarketed := rosetta_g_miss_date_in_map(p6_a42);
2572 ddp_klev_rec.net_rentable := rosetta_g_miss_num_map(p6_a43);
2573 ddp_klev_rec.remarket_margin := rosetta_g_miss_num_map(p6_a44);
2574 ddp_klev_rec.date_letter_acceptance := rosetta_g_miss_date_in_map(p6_a45);
2575 ddp_klev_rec.repurchased_amount := rosetta_g_miss_num_map(p6_a46);
2576 ddp_klev_rec.date_commitment_expiration := rosetta_g_miss_date_in_map(p6_a47);
2577 ddp_klev_rec.date_repurchased := rosetta_g_miss_date_in_map(p6_a48);
2578 ddp_klev_rec.date_appraisal := rosetta_g_miss_date_in_map(p6_a49);
2579 ddp_klev_rec.residual_value := rosetta_g_miss_num_map(p6_a50);
2580 ddp_klev_rec.appraisal_value := rosetta_g_miss_num_map(p6_a51);
2581 ddp_klev_rec.secured_deal_yn := p6_a52;
2582 ddp_klev_rec.gain_loss := rosetta_g_miss_num_map(p6_a53);
2583 ddp_klev_rec.floor_amount := rosetta_g_miss_num_map(p6_a54);
2584 ddp_klev_rec.re_lease_yn := p6_a55;
2585 ddp_klev_rec.previous_contract := p6_a56;
2586 ddp_klev_rec.tracked_residual := rosetta_g_miss_num_map(p6_a57);
2587 ddp_klev_rec.date_title_received := rosetta_g_miss_date_in_map(p6_a58);
2588 ddp_klev_rec.amount := rosetta_g_miss_num_map(p6_a59);
2589 ddp_klev_rec.attribute_category := p6_a60;
2590 ddp_klev_rec.attribute1 := p6_a61;
2591 ddp_klev_rec.attribute2 := p6_a62;
2592 ddp_klev_rec.attribute3 := p6_a63;
2593 ddp_klev_rec.attribute4 := p6_a64;
2594 ddp_klev_rec.attribute5 := p6_a65;
2595 ddp_klev_rec.attribute6 := p6_a66;
2596 ddp_klev_rec.attribute7 := p6_a67;
2597 ddp_klev_rec.attribute8 := p6_a68;
2598 ddp_klev_rec.attribute9 := p6_a69;
2599 ddp_klev_rec.attribute10 := p6_a70;
2600 ddp_klev_rec.attribute11 := p6_a71;
2601 ddp_klev_rec.attribute12 := p6_a72;
2602 ddp_klev_rec.attribute13 := p6_a73;
2603 ddp_klev_rec.attribute14 := p6_a74;
2604 ddp_klev_rec.attribute15 := p6_a75;
2605 ddp_klev_rec.sty_id_for := rosetta_g_miss_num_map(p6_a76);
2606 ddp_klev_rec.clg_id := rosetta_g_miss_num_map(p6_a77);
2607 ddp_klev_rec.created_by := rosetta_g_miss_num_map(p6_a78);
2608 ddp_klev_rec.creation_date := rosetta_g_miss_date_in_map(p6_a79);
2609 ddp_klev_rec.last_updated_by := rosetta_g_miss_num_map(p6_a80);
2610 ddp_klev_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a81);
2611 ddp_klev_rec.last_update_login := rosetta_g_miss_num_map(p6_a82);
2612 ddp_klev_rec.date_funding := rosetta_g_miss_date_in_map(p6_a83);
2613 ddp_klev_rec.date_funding_required := rosetta_g_miss_date_in_map(p6_a84);
2614 ddp_klev_rec.date_accepted := rosetta_g_miss_date_in_map(p6_a85);
2615 ddp_klev_rec.date_delivery_expected := rosetta_g_miss_date_in_map(p6_a86);
2616 ddp_klev_rec.oec := rosetta_g_miss_num_map(p6_a87);
2617 ddp_klev_rec.capital_amount := rosetta_g_miss_num_map(p6_a88);
2618 ddp_klev_rec.residual_grnty_amount := rosetta_g_miss_num_map(p6_a89);
2619 ddp_klev_rec.residual_code := p6_a90;
2620 ddp_klev_rec.rvi_premium := rosetta_g_miss_num_map(p6_a91);
2621 ddp_klev_rec.credit_nature := p6_a92;
2622 ddp_klev_rec.capitalized_interest := rosetta_g_miss_num_map(p6_a93);
2623 ddp_klev_rec.capital_reduction_percent := rosetta_g_miss_num_map(p6_a94);
2624 ddp_klev_rec.date_pay_investor_start := rosetta_g_miss_date_in_map(p6_a95);
2625 ddp_klev_rec.pay_investor_frequency := p6_a96;
2626 ddp_klev_rec.pay_investor_event := p6_a97;
2627 ddp_klev_rec.pay_investor_remittance_days := rosetta_g_miss_num_map(p6_a98);
2628
2629 ddp_cimv_rec.id := rosetta_g_miss_num_map(p7_a0);
2630 ddp_cimv_rec.object_version_number := rosetta_g_miss_num_map(p7_a1);
2631 ddp_cimv_rec.cle_id := rosetta_g_miss_num_map(p7_a2);
2632 ddp_cimv_rec.chr_id := rosetta_g_miss_num_map(p7_a3);
2633 ddp_cimv_rec.cle_id_for := rosetta_g_miss_num_map(p7_a4);
2634 ddp_cimv_rec.dnz_chr_id := rosetta_g_miss_num_map(p7_a5);
2635 ddp_cimv_rec.object1_id1 := p7_a6;
2636 ddp_cimv_rec.object1_id2 := p7_a7;
2637 ddp_cimv_rec.jtot_object1_code := p7_a8;
2638 ddp_cimv_rec.uom_code := p7_a9;
2639 ddp_cimv_rec.exception_yn := p7_a10;
2640 ddp_cimv_rec.number_of_items := rosetta_g_miss_num_map(p7_a11);
2641 ddp_cimv_rec.upg_orig_system_ref := p7_a12;
2642 ddp_cimv_rec.upg_orig_system_ref_id := rosetta_g_miss_num_map(p7_a13);
2643 ddp_cimv_rec.priced_item_yn := p7_a14;
2644 ddp_cimv_rec.created_by := rosetta_g_miss_num_map(p7_a15);
2645 ddp_cimv_rec.creation_date := rosetta_g_miss_date_in_map(p7_a16);
2646 ddp_cimv_rec.last_updated_by := rosetta_g_miss_num_map(p7_a17);
2647 ddp_cimv_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a18);
2648 ddp_cimv_rec.last_update_login := rosetta_g_miss_num_map(p7_a19);
2649
2650 -- here's the delegated call to the old PL/SQL routine
2651 okl_contract_line_item_pvt.delete_contract_line_item(p_api_version,
2652 p_init_msg_list,
2653 x_return_status,
2654 x_msg_count,
2655 x_msg_data,
2656 ddp_clev_rec,
2657 ddp_klev_rec,
2658 ddp_cimv_rec);
2659
2660 -- copy data back from the local variables to OUT or IN-OUT args, if any
2661
2662
2663
2664
2665
2666
2667
2668 end;
2669
2670 procedure create_contract_line_item(p_api_version NUMBER
2671 , p_init_msg_list VARCHAR2
2672 , x_return_status out nocopy VARCHAR2
2673 , x_msg_count out nocopy NUMBER
2674 , x_msg_data out nocopy VARCHAR2
2675 , p5_a0 JTF_NUMBER_TABLE
2676 , p5_a1 JTF_NUMBER_TABLE
2677 , p5_a2 JTF_VARCHAR2_TABLE_100
2678 , p5_a3 JTF_NUMBER_TABLE
2679 , p5_a4 JTF_NUMBER_TABLE
2680 , p5_a5 JTF_NUMBER_TABLE
2681 , p5_a6 JTF_NUMBER_TABLE
2682 , p5_a7 JTF_NUMBER_TABLE
2683 , p5_a8 JTF_VARCHAR2_TABLE_200
2684 , p5_a9 JTF_VARCHAR2_TABLE_100
2685 , p5_a10 JTF_NUMBER_TABLE
2686 , p5_a11 JTF_VARCHAR2_TABLE_100
2687 , p5_a12 JTF_NUMBER_TABLE
2688 , p5_a13 JTF_VARCHAR2_TABLE_2000
2689 , p5_a14 JTF_VARCHAR2_TABLE_2000
2690 , p5_a15 JTF_VARCHAR2_TABLE_2000
2691 , p5_a16 JTF_VARCHAR2_TABLE_300
2692 , p5_a17 JTF_VARCHAR2_TABLE_100
2693 , p5_a18 JTF_NUMBER_TABLE
2694 , p5_a19 JTF_NUMBER_TABLE
2695 , p5_a20 JTF_NUMBER_TABLE
2696 , p5_a21 JTF_NUMBER_TABLE
2697 , p5_a22 JTF_VARCHAR2_TABLE_100
2698 , p5_a23 JTF_VARCHAR2_TABLE_100
2699 , p5_a24 JTF_VARCHAR2_TABLE_100
2700 , p5_a25 JTF_VARCHAR2_TABLE_2000
2701 , p5_a26 JTF_VARCHAR2_TABLE_100
2702 , p5_a27 JTF_VARCHAR2_TABLE_200
2703 , p5_a28 JTF_DATE_TABLE
2704 , p5_a29 JTF_VARCHAR2_TABLE_200
2705 , p5_a30 JTF_DATE_TABLE
2706 , p5_a31 JTF_DATE_TABLE
2707 , p5_a32 JTF_DATE_TABLE
2708 , p5_a33 JTF_VARCHAR2_TABLE_100
2709 , p5_a34 JTF_NUMBER_TABLE
2710 , p5_a35 JTF_VARCHAR2_TABLE_100
2711 , p5_a36 JTF_NUMBER_TABLE
2712 , p5_a37 JTF_VARCHAR2_TABLE_100
2713 , p5_a38 JTF_VARCHAR2_TABLE_100
2714 , p5_a39 JTF_VARCHAR2_TABLE_500
2715 , p5_a40 JTF_VARCHAR2_TABLE_500
2716 , p5_a41 JTF_VARCHAR2_TABLE_500
2717 , p5_a42 JTF_VARCHAR2_TABLE_500
2718 , p5_a43 JTF_VARCHAR2_TABLE_500
2719 , p5_a44 JTF_VARCHAR2_TABLE_500
2720 , p5_a45 JTF_VARCHAR2_TABLE_500
2721 , p5_a46 JTF_VARCHAR2_TABLE_500
2722 , p5_a47 JTF_VARCHAR2_TABLE_500
2723 , p5_a48 JTF_VARCHAR2_TABLE_500
2724 , p5_a49 JTF_VARCHAR2_TABLE_500
2725 , p5_a50 JTF_VARCHAR2_TABLE_500
2726 , p5_a51 JTF_VARCHAR2_TABLE_500
2727 , p5_a52 JTF_VARCHAR2_TABLE_500
2728 , p5_a53 JTF_VARCHAR2_TABLE_500
2729 , p5_a54 JTF_NUMBER_TABLE
2730 , p5_a55 JTF_DATE_TABLE
2731 , p5_a56 JTF_NUMBER_TABLE
2732 , p5_a57 JTF_DATE_TABLE
2733 , p5_a58 JTF_VARCHAR2_TABLE_100
2734 , p5_a59 JTF_VARCHAR2_TABLE_100
2735 , p5_a60 JTF_VARCHAR2_TABLE_100
2736 , p5_a61 JTF_NUMBER_TABLE
2737 , p5_a62 JTF_VARCHAR2_TABLE_100
2738 , p5_a63 JTF_VARCHAR2_TABLE_100
2739 , p5_a64 JTF_VARCHAR2_TABLE_100
2740 , p5_a65 JTF_VARCHAR2_TABLE_100
2741 , p5_a66 JTF_VARCHAR2_TABLE_100
2742 , p5_a67 JTF_NUMBER_TABLE
2743 , p5_a68 JTF_NUMBER_TABLE
2744 , p5_a69 JTF_NUMBER_TABLE
2745 , p5_a70 JTF_DATE_TABLE
2746 , p5_a71 JTF_NUMBER_TABLE
2747 , p5_a72 JTF_DATE_TABLE
2748 , p5_a73 JTF_NUMBER_TABLE
2749 , p5_a74 JTF_NUMBER_TABLE
2750 , p5_a75 JTF_VARCHAR2_TABLE_100
2751 , p5_a76 JTF_VARCHAR2_TABLE_100
2752 , p5_a77 JTF_NUMBER_TABLE
2753 , p5_a78 JTF_NUMBER_TABLE
2754 , p5_a79 JTF_VARCHAR2_TABLE_100
2755 , p5_a80 JTF_VARCHAR2_TABLE_100
2756 , p5_a81 JTF_NUMBER_TABLE
2757 , p5_a82 JTF_VARCHAR2_TABLE_100
2758 , p5_a83 JTF_NUMBER_TABLE
2759 , p5_a84 JTF_NUMBER_TABLE
2760 , p5_a85 JTF_NUMBER_TABLE
2761 , p5_a86 JTF_NUMBER_TABLE
2762 , p5_a87 JTF_VARCHAR2_TABLE_100
2763 , p5_a88 JTF_NUMBER_TABLE
2764 , p5_a89 JTF_NUMBER_TABLE
2765 , p6_a0 JTF_NUMBER_TABLE
2766 , p6_a1 JTF_NUMBER_TABLE
2767 , p6_a2 JTF_NUMBER_TABLE
2768 , p6_a3 JTF_NUMBER_TABLE
2769 , p6_a4 JTF_VARCHAR2_TABLE_100
2770 , p6_a5 JTF_VARCHAR2_TABLE_100
2771 , p6_a6 JTF_VARCHAR2_TABLE_100
2772 , p6_a7 JTF_NUMBER_TABLE
2773 , p6_a8 JTF_NUMBER_TABLE
2774 , p6_a9 JTF_DATE_TABLE
2775 , p6_a10 JTF_NUMBER_TABLE
2776 , p6_a11 JTF_NUMBER_TABLE
2777 , p6_a12 JTF_NUMBER_TABLE
2778 , p6_a13 JTF_NUMBER_TABLE
2779 , p6_a14 JTF_NUMBER_TABLE
2780 , p6_a15 JTF_NUMBER_TABLE
2781 , p6_a16 JTF_NUMBER_TABLE
2782 , p6_a17 JTF_NUMBER_TABLE
2783 , p6_a18 JTF_NUMBER_TABLE
2784 , p6_a19 JTF_NUMBER_TABLE
2785 , p6_a20 JTF_DATE_TABLE
2786 , p6_a21 JTF_DATE_TABLE
2787 , p6_a22 JTF_NUMBER_TABLE
2788 , p6_a23 JTF_NUMBER_TABLE
2789 , p6_a24 JTF_DATE_TABLE
2790 , p6_a25 JTF_DATE_TABLE
2791 , p6_a26 JTF_DATE_TABLE
2792 , p6_a27 JTF_NUMBER_TABLE
2793 , p6_a28 JTF_NUMBER_TABLE
2794 , p6_a29 JTF_NUMBER_TABLE
2795 , p6_a30 JTF_NUMBER_TABLE
2796 , p6_a31 JTF_NUMBER_TABLE
2797 , p6_a32 JTF_NUMBER_TABLE
2798 , p6_a33 JTF_NUMBER_TABLE
2799 , p6_a34 JTF_DATE_TABLE
2800 , p6_a35 JTF_VARCHAR2_TABLE_100
2801 , p6_a36 JTF_DATE_TABLE
2802 , p6_a37 JTF_VARCHAR2_TABLE_300
2803 , p6_a38 JTF_NUMBER_TABLE
2804 , p6_a39 JTF_NUMBER_TABLE
2805 , p6_a40 JTF_NUMBER_TABLE
2806 , p6_a41 JTF_VARCHAR2_TABLE_100
2807 , p6_a42 JTF_DATE_TABLE
2808 , p6_a43 JTF_NUMBER_TABLE
2809 , p6_a44 JTF_NUMBER_TABLE
2810 , p6_a45 JTF_DATE_TABLE
2811 , p6_a46 JTF_NUMBER_TABLE
2812 , p6_a47 JTF_DATE_TABLE
2813 , p6_a48 JTF_DATE_TABLE
2814 , p6_a49 JTF_DATE_TABLE
2815 , p6_a50 JTF_NUMBER_TABLE
2816 , p6_a51 JTF_NUMBER_TABLE
2817 , p6_a52 JTF_VARCHAR2_TABLE_100
2818 , p6_a53 JTF_NUMBER_TABLE
2819 , p6_a54 JTF_NUMBER_TABLE
2820 , p6_a55 JTF_VARCHAR2_TABLE_100
2821 , p6_a56 JTF_VARCHAR2_TABLE_100
2822 , p6_a57 JTF_NUMBER_TABLE
2823 , p6_a58 JTF_DATE_TABLE
2824 , p6_a59 JTF_NUMBER_TABLE
2825 , p6_a60 JTF_VARCHAR2_TABLE_100
2826 , p6_a61 JTF_VARCHAR2_TABLE_500
2827 , p6_a62 JTF_VARCHAR2_TABLE_500
2828 , p6_a63 JTF_VARCHAR2_TABLE_500
2829 , p6_a64 JTF_VARCHAR2_TABLE_500
2830 , p6_a65 JTF_VARCHAR2_TABLE_500
2831 , p6_a66 JTF_VARCHAR2_TABLE_500
2832 , p6_a67 JTF_VARCHAR2_TABLE_500
2833 , p6_a68 JTF_VARCHAR2_TABLE_500
2834 , p6_a69 JTF_VARCHAR2_TABLE_500
2835 , p6_a70 JTF_VARCHAR2_TABLE_500
2836 , p6_a71 JTF_VARCHAR2_TABLE_500
2837 , p6_a72 JTF_VARCHAR2_TABLE_500
2838 , p6_a73 JTF_VARCHAR2_TABLE_500
2839 , p6_a74 JTF_VARCHAR2_TABLE_500
2840 , p6_a75 JTF_VARCHAR2_TABLE_500
2841 , p6_a76 JTF_NUMBER_TABLE
2842 , p6_a77 JTF_NUMBER_TABLE
2843 , p6_a78 JTF_NUMBER_TABLE
2844 , p6_a79 JTF_DATE_TABLE
2845 , p6_a80 JTF_NUMBER_TABLE
2846 , p6_a81 JTF_DATE_TABLE
2847 , p6_a82 JTF_NUMBER_TABLE
2848 , p6_a83 JTF_DATE_TABLE
2849 , p6_a84 JTF_DATE_TABLE
2850 , p6_a85 JTF_DATE_TABLE
2851 , p6_a86 JTF_DATE_TABLE
2852 , p6_a87 JTF_NUMBER_TABLE
2853 , p6_a88 JTF_NUMBER_TABLE
2854 , p6_a89 JTF_NUMBER_TABLE
2855 , p6_a90 JTF_VARCHAR2_TABLE_100
2856 , p6_a91 JTF_NUMBER_TABLE
2857 , p6_a92 JTF_VARCHAR2_TABLE_100
2858 , p6_a93 JTF_NUMBER_TABLE
2859 , p6_a94 JTF_NUMBER_TABLE
2860 , p6_a95 JTF_DATE_TABLE
2861 , p6_a96 JTF_VARCHAR2_TABLE_100
2862 , p6_a97 JTF_VARCHAR2_TABLE_100
2863 , p6_a98 JTF_NUMBER_TABLE
2864 , p7_a0 JTF_NUMBER_TABLE
2865 , p7_a1 JTF_NUMBER_TABLE
2866 , p7_a2 JTF_NUMBER_TABLE
2867 , p7_a3 JTF_NUMBER_TABLE
2868 , p7_a4 JTF_NUMBER_TABLE
2869 , p7_a5 JTF_NUMBER_TABLE
2870 , p7_a6 JTF_VARCHAR2_TABLE_100
2871 , p7_a7 JTF_VARCHAR2_TABLE_200
2872 , p7_a8 JTF_VARCHAR2_TABLE_100
2873 , p7_a9 JTF_VARCHAR2_TABLE_100
2874 , p7_a10 JTF_VARCHAR2_TABLE_100
2875 , p7_a11 JTF_NUMBER_TABLE
2876 , p7_a12 JTF_VARCHAR2_TABLE_100
2877 , p7_a13 JTF_NUMBER_TABLE
2878 , p7_a14 JTF_VARCHAR2_TABLE_100
2879 , p7_a15 JTF_NUMBER_TABLE
2880 , p7_a16 JTF_DATE_TABLE
2881 , p7_a17 JTF_NUMBER_TABLE
2882 , p7_a18 JTF_DATE_TABLE
2883 , p7_a19 JTF_NUMBER_TABLE
2884 , p8_a0 out nocopy JTF_NUMBER_TABLE
2885 , p8_a1 out nocopy JTF_NUMBER_TABLE
2886 , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
2887 , p8_a3 out nocopy JTF_NUMBER_TABLE
2888 , p8_a4 out nocopy JTF_NUMBER_TABLE
2889 , p8_a5 out nocopy JTF_NUMBER_TABLE
2890 , p8_a6 out nocopy JTF_NUMBER_TABLE
2891 , p8_a7 out nocopy JTF_NUMBER_TABLE
2892 , p8_a8 out nocopy JTF_VARCHAR2_TABLE_200
2893 , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
2894 , p8_a10 out nocopy JTF_NUMBER_TABLE
2895 , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
2896 , p8_a12 out nocopy JTF_NUMBER_TABLE
2897 , p8_a13 out nocopy JTF_VARCHAR2_TABLE_2000
2898 , p8_a14 out nocopy JTF_VARCHAR2_TABLE_2000
2899 , p8_a15 out nocopy JTF_VARCHAR2_TABLE_2000
2900 , p8_a16 out nocopy JTF_VARCHAR2_TABLE_300
2901 , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
2902 , p8_a18 out nocopy JTF_NUMBER_TABLE
2903 , p8_a19 out nocopy JTF_NUMBER_TABLE
2904 , p8_a20 out nocopy JTF_NUMBER_TABLE
2905 , p8_a21 out nocopy JTF_NUMBER_TABLE
2906 , p8_a22 out nocopy JTF_VARCHAR2_TABLE_100
2907 , p8_a23 out nocopy JTF_VARCHAR2_TABLE_100
2908 , p8_a24 out nocopy JTF_VARCHAR2_TABLE_100
2909 , p8_a25 out nocopy JTF_VARCHAR2_TABLE_2000
2910 , p8_a26 out nocopy JTF_VARCHAR2_TABLE_100
2911 , p8_a27 out nocopy JTF_VARCHAR2_TABLE_200
2912 , p8_a28 out nocopy JTF_DATE_TABLE
2913 , p8_a29 out nocopy JTF_VARCHAR2_TABLE_200
2914 , p8_a30 out nocopy JTF_DATE_TABLE
2915 , p8_a31 out nocopy JTF_DATE_TABLE
2916 , p8_a32 out nocopy JTF_DATE_TABLE
2917 , p8_a33 out nocopy JTF_VARCHAR2_TABLE_100
2918 , p8_a34 out nocopy JTF_NUMBER_TABLE
2919 , p8_a35 out nocopy JTF_VARCHAR2_TABLE_100
2920 , p8_a36 out nocopy JTF_NUMBER_TABLE
2921 , p8_a37 out nocopy JTF_VARCHAR2_TABLE_100
2922 , p8_a38 out nocopy JTF_VARCHAR2_TABLE_100
2923 , p8_a39 out nocopy JTF_VARCHAR2_TABLE_500
2924 , p8_a40 out nocopy JTF_VARCHAR2_TABLE_500
2925 , p8_a41 out nocopy JTF_VARCHAR2_TABLE_500
2926 , p8_a42 out nocopy JTF_VARCHAR2_TABLE_500
2927 , p8_a43 out nocopy JTF_VARCHAR2_TABLE_500
2928 , p8_a44 out nocopy JTF_VARCHAR2_TABLE_500
2929 , p8_a45 out nocopy JTF_VARCHAR2_TABLE_500
2930 , p8_a46 out nocopy JTF_VARCHAR2_TABLE_500
2931 , p8_a47 out nocopy JTF_VARCHAR2_TABLE_500
2932 , p8_a48 out nocopy JTF_VARCHAR2_TABLE_500
2933 , p8_a49 out nocopy JTF_VARCHAR2_TABLE_500
2934 , p8_a50 out nocopy JTF_VARCHAR2_TABLE_500
2935 , p8_a51 out nocopy JTF_VARCHAR2_TABLE_500
2936 , p8_a52 out nocopy JTF_VARCHAR2_TABLE_500
2937 , p8_a53 out nocopy JTF_VARCHAR2_TABLE_500
2938 , p8_a54 out nocopy JTF_NUMBER_TABLE
2939 , p8_a55 out nocopy JTF_DATE_TABLE
2940 , p8_a56 out nocopy JTF_NUMBER_TABLE
2941 , p8_a57 out nocopy JTF_DATE_TABLE
2942 , p8_a58 out nocopy JTF_VARCHAR2_TABLE_100
2943 , p8_a59 out nocopy JTF_VARCHAR2_TABLE_100
2944 , p8_a60 out nocopy JTF_VARCHAR2_TABLE_100
2945 , p8_a61 out nocopy JTF_NUMBER_TABLE
2946 , p8_a62 out nocopy JTF_VARCHAR2_TABLE_100
2947 , p8_a63 out nocopy JTF_VARCHAR2_TABLE_100
2948 , p8_a64 out nocopy JTF_VARCHAR2_TABLE_100
2949 , p8_a65 out nocopy JTF_VARCHAR2_TABLE_100
2950 , p8_a66 out nocopy JTF_VARCHAR2_TABLE_100
2951 , p8_a67 out nocopy JTF_NUMBER_TABLE
2952 , p8_a68 out nocopy JTF_NUMBER_TABLE
2953 , p8_a69 out nocopy JTF_NUMBER_TABLE
2954 , p8_a70 out nocopy JTF_DATE_TABLE
2955 , p8_a71 out nocopy JTF_NUMBER_TABLE
2956 , p8_a72 out nocopy JTF_DATE_TABLE
2957 , p8_a73 out nocopy JTF_NUMBER_TABLE
2958 , p8_a74 out nocopy JTF_NUMBER_TABLE
2959 , p8_a75 out nocopy JTF_VARCHAR2_TABLE_100
2960 , p8_a76 out nocopy JTF_VARCHAR2_TABLE_100
2961 , p8_a77 out nocopy JTF_NUMBER_TABLE
2962 , p8_a78 out nocopy JTF_NUMBER_TABLE
2963 , p8_a79 out nocopy JTF_VARCHAR2_TABLE_100
2964 , p8_a80 out nocopy JTF_VARCHAR2_TABLE_100
2965 , p8_a81 out nocopy JTF_NUMBER_TABLE
2966 , p8_a82 out nocopy JTF_VARCHAR2_TABLE_100
2967 , p8_a83 out nocopy JTF_NUMBER_TABLE
2968 , p8_a84 out nocopy JTF_NUMBER_TABLE
2969 , p8_a85 out nocopy JTF_NUMBER_TABLE
2970 , p8_a86 out nocopy JTF_NUMBER_TABLE
2971 , p8_a87 out nocopy JTF_VARCHAR2_TABLE_100
2972 , p8_a88 out nocopy JTF_NUMBER_TABLE
2973 , p8_a89 out nocopy JTF_NUMBER_TABLE
2974 , p9_a0 out nocopy JTF_NUMBER_TABLE
2975 , p9_a1 out nocopy JTF_NUMBER_TABLE
2976 , p9_a2 out nocopy JTF_NUMBER_TABLE
2977 , p9_a3 out nocopy JTF_NUMBER_TABLE
2978 , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
2979 , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
2980 , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
2981 , p9_a7 out nocopy JTF_NUMBER_TABLE
2982 , p9_a8 out nocopy JTF_NUMBER_TABLE
2983 , p9_a9 out nocopy JTF_DATE_TABLE
2984 , p9_a10 out nocopy JTF_NUMBER_TABLE
2985 , p9_a11 out nocopy JTF_NUMBER_TABLE
2986 , p9_a12 out nocopy JTF_NUMBER_TABLE
2987 , p9_a13 out nocopy JTF_NUMBER_TABLE
2988 , p9_a14 out nocopy JTF_NUMBER_TABLE
2989 , p9_a15 out nocopy JTF_NUMBER_TABLE
2990 , p9_a16 out nocopy JTF_NUMBER_TABLE
2991 , p9_a17 out nocopy JTF_NUMBER_TABLE
2992 , p9_a18 out nocopy JTF_NUMBER_TABLE
2993 , p9_a19 out nocopy JTF_NUMBER_TABLE
2994 , p9_a20 out nocopy JTF_DATE_TABLE
2995 , p9_a21 out nocopy JTF_DATE_TABLE
2996 , p9_a22 out nocopy JTF_NUMBER_TABLE
2997 , p9_a23 out nocopy JTF_NUMBER_TABLE
2998 , p9_a24 out nocopy JTF_DATE_TABLE
2999 , p9_a25 out nocopy JTF_DATE_TABLE
3000 , p9_a26 out nocopy JTF_DATE_TABLE
3001 , p9_a27 out nocopy JTF_NUMBER_TABLE
3002 , p9_a28 out nocopy JTF_NUMBER_TABLE
3003 , p9_a29 out nocopy JTF_NUMBER_TABLE
3004 , p9_a30 out nocopy JTF_NUMBER_TABLE
3005 , p9_a31 out nocopy JTF_NUMBER_TABLE
3006 , p9_a32 out nocopy JTF_NUMBER_TABLE
3007 , p9_a33 out nocopy JTF_NUMBER_TABLE
3008 , p9_a34 out nocopy JTF_DATE_TABLE
3009 , p9_a35 out nocopy JTF_VARCHAR2_TABLE_100
3010 , p9_a36 out nocopy JTF_DATE_TABLE
3011 , p9_a37 out nocopy JTF_VARCHAR2_TABLE_300
3012 , p9_a38 out nocopy JTF_NUMBER_TABLE
3013 , p9_a39 out nocopy JTF_NUMBER_TABLE
3014 , p9_a40 out nocopy JTF_NUMBER_TABLE
3015 , p9_a41 out nocopy JTF_VARCHAR2_TABLE_100
3016 , p9_a42 out nocopy JTF_DATE_TABLE
3017 , p9_a43 out nocopy JTF_NUMBER_TABLE
3018 , p9_a44 out nocopy JTF_NUMBER_TABLE
3019 , p9_a45 out nocopy JTF_DATE_TABLE
3020 , p9_a46 out nocopy JTF_NUMBER_TABLE
3021 , p9_a47 out nocopy JTF_DATE_TABLE
3022 , p9_a48 out nocopy JTF_DATE_TABLE
3023 , p9_a49 out nocopy JTF_DATE_TABLE
3024 , p9_a50 out nocopy JTF_NUMBER_TABLE
3025 , p9_a51 out nocopy JTF_NUMBER_TABLE
3026 , p9_a52 out nocopy JTF_VARCHAR2_TABLE_100
3027 , p9_a53 out nocopy JTF_NUMBER_TABLE
3028 , p9_a54 out nocopy JTF_NUMBER_TABLE
3029 , p9_a55 out nocopy JTF_VARCHAR2_TABLE_100
3030 , p9_a56 out nocopy JTF_VARCHAR2_TABLE_100
3031 , p9_a57 out nocopy JTF_NUMBER_TABLE
3032 , p9_a58 out nocopy JTF_DATE_TABLE
3033 , p9_a59 out nocopy JTF_NUMBER_TABLE
3034 , p9_a60 out nocopy JTF_VARCHAR2_TABLE_100
3035 , p9_a61 out nocopy JTF_VARCHAR2_TABLE_500
3036 , p9_a62 out nocopy JTF_VARCHAR2_TABLE_500
3037 , p9_a63 out nocopy JTF_VARCHAR2_TABLE_500
3038 , p9_a64 out nocopy JTF_VARCHAR2_TABLE_500
3039 , p9_a65 out nocopy JTF_VARCHAR2_TABLE_500
3040 , p9_a66 out nocopy JTF_VARCHAR2_TABLE_500
3041 , p9_a67 out nocopy JTF_VARCHAR2_TABLE_500
3042 , p9_a68 out nocopy JTF_VARCHAR2_TABLE_500
3043 , p9_a69 out nocopy JTF_VARCHAR2_TABLE_500
3044 , p9_a70 out nocopy JTF_VARCHAR2_TABLE_500
3045 , p9_a71 out nocopy JTF_VARCHAR2_TABLE_500
3046 , p9_a72 out nocopy JTF_VARCHAR2_TABLE_500
3047 , p9_a73 out nocopy JTF_VARCHAR2_TABLE_500
3048 , p9_a74 out nocopy JTF_VARCHAR2_TABLE_500
3049 , p9_a75 out nocopy JTF_VARCHAR2_TABLE_500
3050 , p9_a76 out nocopy JTF_NUMBER_TABLE
3051 , p9_a77 out nocopy JTF_NUMBER_TABLE
3052 , p9_a78 out nocopy JTF_NUMBER_TABLE
3053 , p9_a79 out nocopy JTF_DATE_TABLE
3054 , p9_a80 out nocopy JTF_NUMBER_TABLE
3055 , p9_a81 out nocopy JTF_DATE_TABLE
3056 , p9_a82 out nocopy JTF_NUMBER_TABLE
3057 , p9_a83 out nocopy JTF_DATE_TABLE
3058 , p9_a84 out nocopy JTF_DATE_TABLE
3059 , p9_a85 out nocopy JTF_DATE_TABLE
3060 , p9_a86 out nocopy JTF_DATE_TABLE
3061 , p9_a87 out nocopy JTF_NUMBER_TABLE
3062 , p9_a88 out nocopy JTF_NUMBER_TABLE
3063 , p9_a89 out nocopy JTF_NUMBER_TABLE
3064 , p9_a90 out nocopy JTF_VARCHAR2_TABLE_100
3065 , p9_a91 out nocopy JTF_NUMBER_TABLE
3066 , p9_a92 out nocopy JTF_VARCHAR2_TABLE_100
3067 , p9_a93 out nocopy JTF_NUMBER_TABLE
3068 , p9_a94 out nocopy JTF_NUMBER_TABLE
3069 , p9_a95 out nocopy JTF_DATE_TABLE
3070 , p9_a96 out nocopy JTF_VARCHAR2_TABLE_100
3071 , p9_a97 out nocopy JTF_VARCHAR2_TABLE_100
3072 , p9_a98 out nocopy JTF_NUMBER_TABLE
3073 , p10_a0 out nocopy JTF_NUMBER_TABLE
3074 , p10_a1 out nocopy JTF_NUMBER_TABLE
3075 , p10_a2 out nocopy JTF_NUMBER_TABLE
3076 , p10_a3 out nocopy JTF_NUMBER_TABLE
3077 , p10_a4 out nocopy JTF_NUMBER_TABLE
3078 , p10_a5 out nocopy JTF_NUMBER_TABLE
3079 , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
3080 , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
3081 , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
3082 , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
3083 , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
3084 , p10_a11 out nocopy JTF_NUMBER_TABLE
3085 , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
3086 , p10_a13 out nocopy JTF_NUMBER_TABLE
3087 , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100
3088 , p10_a15 out nocopy JTF_NUMBER_TABLE
3089 , p10_a16 out nocopy JTF_DATE_TABLE
3090 , p10_a17 out nocopy JTF_NUMBER_TABLE
3091 , p10_a18 out nocopy JTF_DATE_TABLE
3092 , p10_a19 out nocopy JTF_NUMBER_TABLE
3093 )
3094
3095 as
3096 ddp_clev_tbl okl_contract_line_item_pvt.clev_tbl_type;
3097 ddp_klev_tbl okl_contract_line_item_pvt.klev_tbl_type;
3098 ddp_cimv_tbl okl_contract_line_item_pvt.cimv_tbl_type;
3099 ddx_clev_tbl okl_contract_line_item_pvt.clev_tbl_type;
3100 ddx_klev_tbl okl_contract_line_item_pvt.klev_tbl_type;
3101 ddx_cimv_tbl okl_contract_line_item_pvt.cimv_tbl_type;
3102 ddindx binary_integer; indx binary_integer;
3103 begin
3104
3105 -- copy data to the local IN or IN-OUT args, if any
3106
3107
3108
3109
3110
3111 okl_okc_migration_pvt_w.rosetta_table_copy_in_p5(ddp_clev_tbl, p5_a0
3112 , p5_a1
3113 , p5_a2
3114 , p5_a3
3115 , p5_a4
3116 , p5_a5
3117 , p5_a6
3118 , p5_a7
3119 , p5_a8
3120 , p5_a9
3121 , p5_a10
3122 , p5_a11
3123 , p5_a12
3124 , p5_a13
3125 , p5_a14
3126 , p5_a15
3127 , p5_a16
3128 , p5_a17
3129 , p5_a18
3130 , p5_a19
3131 , p5_a20
3132 , p5_a21
3133 , p5_a22
3134 , p5_a23
3135 , p5_a24
3136 , p5_a25
3137 , p5_a26
3138 , p5_a27
3139 , p5_a28
3140 , p5_a29
3141 , p5_a30
3142 , p5_a31
3143 , p5_a32
3144 , p5_a33
3145 , p5_a34
3146 , p5_a35
3147 , p5_a36
3148 , p5_a37
3149 , p5_a38
3150 , p5_a39
3151 , p5_a40
3152 , p5_a41
3153 , p5_a42
3154 , p5_a43
3155 , p5_a44
3156 , p5_a45
3157 , p5_a46
3158 , p5_a47
3159 , p5_a48
3160 , p5_a49
3161 , p5_a50
3162 , p5_a51
3163 , p5_a52
3164 , p5_a53
3165 , p5_a54
3166 , p5_a55
3167 , p5_a56
3168 , p5_a57
3169 , p5_a58
3170 , p5_a59
3171 , p5_a60
3172 , p5_a61
3173 , p5_a62
3174 , p5_a63
3175 , p5_a64
3176 , p5_a65
3177 , p5_a66
3178 , p5_a67
3179 , p5_a68
3180 , p5_a69
3181 , p5_a70
3182 , p5_a71
3183 , p5_a72
3184 , p5_a73
3185 , p5_a74
3186 , p5_a75
3187 , p5_a76
3188 , p5_a77
3189 , p5_a78
3190 , p5_a79
3191 , p5_a80
3192 , p5_a81
3193 , p5_a82
3194 , p5_a83
3195 , p5_a84
3196 , p5_a85
3197 , p5_a86
3198 , p5_a87
3199 , p5_a88
3200 , p5_a89
3201 );
3202
3203 okl_kle_pvt_w.rosetta_table_copy_in_p8(ddp_klev_tbl, p6_a0
3204 , p6_a1
3205 , p6_a2
3206 , p6_a3
3207 , p6_a4
3208 , p6_a5
3209 , p6_a6
3210 , p6_a7
3211 , p6_a8
3212 , p6_a9
3213 , p6_a10
3214 , p6_a11
3215 , p6_a12
3216 , p6_a13
3217 , p6_a14
3218 , p6_a15
3219 , p6_a16
3220 , p6_a17
3221 , p6_a18
3222 , p6_a19
3223 , p6_a20
3224 , p6_a21
3225 , p6_a22
3226 , p6_a23
3227 , p6_a24
3228 , p6_a25
3229 , p6_a26
3230 , p6_a27
3231 , p6_a28
3232 , p6_a29
3233 , p6_a30
3234 , p6_a31
3235 , p6_a32
3236 , p6_a33
3237 , p6_a34
3238 , p6_a35
3239 , p6_a36
3240 , p6_a37
3241 , p6_a38
3242 , p6_a39
3243 , p6_a40
3244 , p6_a41
3245 , p6_a42
3246 , p6_a43
3247 , p6_a44
3248 , p6_a45
3249 , p6_a46
3250 , p6_a47
3251 , p6_a48
3252 , p6_a49
3253 , p6_a50
3254 , p6_a51
3255 , p6_a52
3256 , p6_a53
3257 , p6_a54
3258 , p6_a55
3259 , p6_a56
3260 , p6_a57
3261 , p6_a58
3262 , p6_a59
3263 , p6_a60
3264 , p6_a61
3265 , p6_a62
3266 , p6_a63
3267 , p6_a64
3268 , p6_a65
3269 , p6_a66
3270 , p6_a67
3271 , p6_a68
3272 , p6_a69
3273 , p6_a70
3274 , p6_a71
3275 , p6_a72
3276 , p6_a73
3277 , p6_a74
3278 , p6_a75
3279 , p6_a76
3280 , p6_a77
3281 , p6_a78
3282 , p6_a79
3283 , p6_a80
3284 , p6_a81
3285 , p6_a82
3286 , p6_a83
3287 , p6_a84
3288 , p6_a85
3289 , p6_a86
3290 , p6_a87
3291 , p6_a88
3292 , p6_a89
3293 , p6_a90
3294 , p6_a91
3295 , p6_a92
3296 , p6_a93
3297 , p6_a94
3298 , p6_a95
3299 , p6_a96
3300 , p6_a97
3301 , p6_a98
3302 );
3303
3304 okl_okc_migration_pvt_w.rosetta_table_copy_in_p7(ddp_cimv_tbl, p7_a0
3305 , p7_a1
3306 , p7_a2
3307 , p7_a3
3308 , p7_a4
3309 , p7_a5
3310 , p7_a6
3311 , p7_a7
3312 , p7_a8
3313 , p7_a9
3314 , p7_a10
3315 , p7_a11
3316 , p7_a12
3317 , p7_a13
3318 , p7_a14
3319 , p7_a15
3320 , p7_a16
3321 , p7_a17
3322 , p7_a18
3323 , p7_a19
3324 );
3325
3326
3327
3328
3329 -- here's the delegated call to the old PL/SQL routine
3330 okl_contract_line_item_pvt.create_contract_line_item(p_api_version,
3331 p_init_msg_list,
3332 x_return_status,
3333 x_msg_count,
3334 x_msg_data,
3335 ddp_clev_tbl,
3336 ddp_klev_tbl,
3337 ddp_cimv_tbl,
3338 ddx_clev_tbl,
3339 ddx_klev_tbl,
3340 ddx_cimv_tbl);
3341
3342 -- copy data back from the local variables to OUT or IN-OUT args, if any
3343
3344
3345
3346
3347
3348
3349
3350
3351 okl_okc_migration_pvt_w.rosetta_table_copy_out_p5(ddx_clev_tbl, p8_a0
3352 , p8_a1
3353 , p8_a2
3354 , p8_a3
3355 , p8_a4
3356 , p8_a5
3357 , p8_a6
3358 , p8_a7
3359 , p8_a8
3360 , p8_a9
3361 , p8_a10
3362 , p8_a11
3363 , p8_a12
3364 , p8_a13
3365 , p8_a14
3366 , p8_a15
3367 , p8_a16
3368 , p8_a17
3369 , p8_a18
3370 , p8_a19
3371 , p8_a20
3372 , p8_a21
3373 , p8_a22
3374 , p8_a23
3375 , p8_a24
3376 , p8_a25
3377 , p8_a26
3378 , p8_a27
3379 , p8_a28
3380 , p8_a29
3381 , p8_a30
3382 , p8_a31
3383 , p8_a32
3384 , p8_a33
3385 , p8_a34
3386 , p8_a35
3387 , p8_a36
3388 , p8_a37
3389 , p8_a38
3390 , p8_a39
3391 , p8_a40
3392 , p8_a41
3393 , p8_a42
3394 , p8_a43
3395 , p8_a44
3396 , p8_a45
3397 , p8_a46
3398 , p8_a47
3399 , p8_a48
3400 , p8_a49
3401 , p8_a50
3402 , p8_a51
3403 , p8_a52
3404 , p8_a53
3405 , p8_a54
3406 , p8_a55
3407 , p8_a56
3408 , p8_a57
3409 , p8_a58
3410 , p8_a59
3411 , p8_a60
3412 , p8_a61
3413 , p8_a62
3414 , p8_a63
3415 , p8_a64
3416 , p8_a65
3417 , p8_a66
3418 , p8_a67
3419 , p8_a68
3420 , p8_a69
3421 , p8_a70
3422 , p8_a71
3423 , p8_a72
3424 , p8_a73
3425 , p8_a74
3426 , p8_a75
3427 , p8_a76
3428 , p8_a77
3429 , p8_a78
3430 , p8_a79
3431 , p8_a80
3432 , p8_a81
3433 , p8_a82
3434 , p8_a83
3435 , p8_a84
3436 , p8_a85
3437 , p8_a86
3438 , p8_a87
3439 , p8_a88
3440 , p8_a89
3441 );
3442
3443 okl_kle_pvt_w.rosetta_table_copy_out_p8(ddx_klev_tbl, p9_a0
3444 , p9_a1
3445 , p9_a2
3446 , p9_a3
3447 , p9_a4
3448 , p9_a5
3449 , p9_a6
3450 , p9_a7
3451 , p9_a8
3452 , p9_a9
3453 , p9_a10
3454 , p9_a11
3455 , p9_a12
3456 , p9_a13
3457 , p9_a14
3458 , p9_a15
3459 , p9_a16
3460 , p9_a17
3461 , p9_a18
3462 , p9_a19
3463 , p9_a20
3464 , p9_a21
3465 , p9_a22
3466 , p9_a23
3467 , p9_a24
3468 , p9_a25
3469 , p9_a26
3470 , p9_a27
3471 , p9_a28
3472 , p9_a29
3473 , p9_a30
3474 , p9_a31
3475 , p9_a32
3476 , p9_a33
3477 , p9_a34
3478 , p9_a35
3479 , p9_a36
3480 , p9_a37
3481 , p9_a38
3482 , p9_a39
3483 , p9_a40
3484 , p9_a41
3485 , p9_a42
3486 , p9_a43
3487 , p9_a44
3488 , p9_a45
3489 , p9_a46
3490 , p9_a47
3491 , p9_a48
3492 , p9_a49
3493 , p9_a50
3494 , p9_a51
3495 , p9_a52
3496 , p9_a53
3497 , p9_a54
3498 , p9_a55
3499 , p9_a56
3500 , p9_a57
3501 , p9_a58
3502 , p9_a59
3503 , p9_a60
3504 , p9_a61
3505 , p9_a62
3506 , p9_a63
3507 , p9_a64
3508 , p9_a65
3509 , p9_a66
3510 , p9_a67
3511 , p9_a68
3512 , p9_a69
3513 , p9_a70
3514 , p9_a71
3515 , p9_a72
3516 , p9_a73
3517 , p9_a74
3518 , p9_a75
3519 , p9_a76
3520 , p9_a77
3521 , p9_a78
3522 , p9_a79
3523 , p9_a80
3524 , p9_a81
3525 , p9_a82
3526 , p9_a83
3527 , p9_a84
3528 , p9_a85
3529 , p9_a86
3530 , p9_a87
3531 , p9_a88
3532 , p9_a89
3533 , p9_a90
3534 , p9_a91
3535 , p9_a92
3536 , p9_a93
3537 , p9_a94
3538 , p9_a95
3539 , p9_a96
3540 , p9_a97
3541 , p9_a98
3542 );
3543
3544 okl_okc_migration_pvt_w.rosetta_table_copy_out_p7(ddx_cimv_tbl, p10_a0
3545 , p10_a1
3546 , p10_a2
3547 , p10_a3
3548 , p10_a4
3549 , p10_a5
3550 , p10_a6
3551 , p10_a7
3552 , p10_a8
3553 , p10_a9
3554 , p10_a10
3555 , p10_a11
3556 , p10_a12
3557 , p10_a13
3558 , p10_a14
3559 , p10_a15
3560 , p10_a16
3561 , p10_a17
3562 , p10_a18
3563 , p10_a19
3564 );
3565 end;
3566
3567 procedure update_contract_line_item(p_api_version NUMBER
3568 , p_init_msg_list VARCHAR2
3569 , x_return_status out nocopy VARCHAR2
3570 , x_msg_count out nocopy NUMBER
3571 , x_msg_data out nocopy VARCHAR2
3572 , p5_a0 JTF_NUMBER_TABLE
3573 , p5_a1 JTF_NUMBER_TABLE
3574 , p5_a2 JTF_VARCHAR2_TABLE_100
3575 , p5_a3 JTF_NUMBER_TABLE
3576 , p5_a4 JTF_NUMBER_TABLE
3577 , p5_a5 JTF_NUMBER_TABLE
3578 , p5_a6 JTF_NUMBER_TABLE
3579 , p5_a7 JTF_NUMBER_TABLE
3580 , p5_a8 JTF_VARCHAR2_TABLE_200
3581 , p5_a9 JTF_VARCHAR2_TABLE_100
3582 , p5_a10 JTF_NUMBER_TABLE
3583 , p5_a11 JTF_VARCHAR2_TABLE_100
3584 , p5_a12 JTF_NUMBER_TABLE
3585 , p5_a13 JTF_VARCHAR2_TABLE_2000
3586 , p5_a14 JTF_VARCHAR2_TABLE_2000
3587 , p5_a15 JTF_VARCHAR2_TABLE_2000
3588 , p5_a16 JTF_VARCHAR2_TABLE_300
3589 , p5_a17 JTF_VARCHAR2_TABLE_100
3590 , p5_a18 JTF_NUMBER_TABLE
3591 , p5_a19 JTF_NUMBER_TABLE
3592 , p5_a20 JTF_NUMBER_TABLE
3593 , p5_a21 JTF_NUMBER_TABLE
3594 , p5_a22 JTF_VARCHAR2_TABLE_100
3595 , p5_a23 JTF_VARCHAR2_TABLE_100
3596 , p5_a24 JTF_VARCHAR2_TABLE_100
3597 , p5_a25 JTF_VARCHAR2_TABLE_2000
3598 , p5_a26 JTF_VARCHAR2_TABLE_100
3599 , p5_a27 JTF_VARCHAR2_TABLE_200
3600 , p5_a28 JTF_DATE_TABLE
3601 , p5_a29 JTF_VARCHAR2_TABLE_200
3602 , p5_a30 JTF_DATE_TABLE
3603 , p5_a31 JTF_DATE_TABLE
3604 , p5_a32 JTF_DATE_TABLE
3605 , p5_a33 JTF_VARCHAR2_TABLE_100
3606 , p5_a34 JTF_NUMBER_TABLE
3607 , p5_a35 JTF_VARCHAR2_TABLE_100
3608 , p5_a36 JTF_NUMBER_TABLE
3609 , p5_a37 JTF_VARCHAR2_TABLE_100
3610 , p5_a38 JTF_VARCHAR2_TABLE_100
3611 , p5_a39 JTF_VARCHAR2_TABLE_500
3612 , p5_a40 JTF_VARCHAR2_TABLE_500
3613 , p5_a41 JTF_VARCHAR2_TABLE_500
3614 , p5_a42 JTF_VARCHAR2_TABLE_500
3615 , p5_a43 JTF_VARCHAR2_TABLE_500
3616 , p5_a44 JTF_VARCHAR2_TABLE_500
3617 , p5_a45 JTF_VARCHAR2_TABLE_500
3618 , p5_a46 JTF_VARCHAR2_TABLE_500
3619 , p5_a47 JTF_VARCHAR2_TABLE_500
3620 , p5_a48 JTF_VARCHAR2_TABLE_500
3621 , p5_a49 JTF_VARCHAR2_TABLE_500
3622 , p5_a50 JTF_VARCHAR2_TABLE_500
3623 , p5_a51 JTF_VARCHAR2_TABLE_500
3624 , p5_a52 JTF_VARCHAR2_TABLE_500
3625 , p5_a53 JTF_VARCHAR2_TABLE_500
3626 , p5_a54 JTF_NUMBER_TABLE
3627 , p5_a55 JTF_DATE_TABLE
3628 , p5_a56 JTF_NUMBER_TABLE
3629 , p5_a57 JTF_DATE_TABLE
3630 , p5_a58 JTF_VARCHAR2_TABLE_100
3631 , p5_a59 JTF_VARCHAR2_TABLE_100
3632 , p5_a60 JTF_VARCHAR2_TABLE_100
3633 , p5_a61 JTF_NUMBER_TABLE
3634 , p5_a62 JTF_VARCHAR2_TABLE_100
3635 , p5_a63 JTF_VARCHAR2_TABLE_100
3636 , p5_a64 JTF_VARCHAR2_TABLE_100
3637 , p5_a65 JTF_VARCHAR2_TABLE_100
3638 , p5_a66 JTF_VARCHAR2_TABLE_100
3639 , p5_a67 JTF_NUMBER_TABLE
3640 , p5_a68 JTF_NUMBER_TABLE
3641 , p5_a69 JTF_NUMBER_TABLE
3642 , p5_a70 JTF_DATE_TABLE
3643 , p5_a71 JTF_NUMBER_TABLE
3644 , p5_a72 JTF_DATE_TABLE
3645 , p5_a73 JTF_NUMBER_TABLE
3646 , p5_a74 JTF_NUMBER_TABLE
3647 , p5_a75 JTF_VARCHAR2_TABLE_100
3648 , p5_a76 JTF_VARCHAR2_TABLE_100
3649 , p5_a77 JTF_NUMBER_TABLE
3650 , p5_a78 JTF_NUMBER_TABLE
3651 , p5_a79 JTF_VARCHAR2_TABLE_100
3652 , p5_a80 JTF_VARCHAR2_TABLE_100
3653 , p5_a81 JTF_NUMBER_TABLE
3654 , p5_a82 JTF_VARCHAR2_TABLE_100
3655 , p5_a83 JTF_NUMBER_TABLE
3656 , p5_a84 JTF_NUMBER_TABLE
3657 , p5_a85 JTF_NUMBER_TABLE
3658 , p5_a86 JTF_NUMBER_TABLE
3659 , p5_a87 JTF_VARCHAR2_TABLE_100
3660 , p5_a88 JTF_NUMBER_TABLE
3661 , p5_a89 JTF_NUMBER_TABLE
3662 , p6_a0 JTF_NUMBER_TABLE
3663 , p6_a1 JTF_NUMBER_TABLE
3664 , p6_a2 JTF_NUMBER_TABLE
3665 , p6_a3 JTF_NUMBER_TABLE
3666 , p6_a4 JTF_VARCHAR2_TABLE_100
3667 , p6_a5 JTF_VARCHAR2_TABLE_100
3668 , p6_a6 JTF_VARCHAR2_TABLE_100
3669 , p6_a7 JTF_NUMBER_TABLE
3670 , p6_a8 JTF_NUMBER_TABLE
3671 , p6_a9 JTF_DATE_TABLE
3672 , p6_a10 JTF_NUMBER_TABLE
3673 , p6_a11 JTF_NUMBER_TABLE
3674 , p6_a12 JTF_NUMBER_TABLE
3675 , p6_a13 JTF_NUMBER_TABLE
3676 , p6_a14 JTF_NUMBER_TABLE
3677 , p6_a15 JTF_NUMBER_TABLE
3678 , p6_a16 JTF_NUMBER_TABLE
3679 , p6_a17 JTF_NUMBER_TABLE
3680 , p6_a18 JTF_NUMBER_TABLE
3681 , p6_a19 JTF_NUMBER_TABLE
3682 , p6_a20 JTF_DATE_TABLE
3683 , p6_a21 JTF_DATE_TABLE
3684 , p6_a22 JTF_NUMBER_TABLE
3685 , p6_a23 JTF_NUMBER_TABLE
3686 , p6_a24 JTF_DATE_TABLE
3687 , p6_a25 JTF_DATE_TABLE
3688 , p6_a26 JTF_DATE_TABLE
3689 , p6_a27 JTF_NUMBER_TABLE
3690 , p6_a28 JTF_NUMBER_TABLE
3691 , p6_a29 JTF_NUMBER_TABLE
3692 , p6_a30 JTF_NUMBER_TABLE
3693 , p6_a31 JTF_NUMBER_TABLE
3694 , p6_a32 JTF_NUMBER_TABLE
3695 , p6_a33 JTF_NUMBER_TABLE
3696 , p6_a34 JTF_DATE_TABLE
3697 , p6_a35 JTF_VARCHAR2_TABLE_100
3698 , p6_a36 JTF_DATE_TABLE
3699 , p6_a37 JTF_VARCHAR2_TABLE_300
3700 , p6_a38 JTF_NUMBER_TABLE
3701 , p6_a39 JTF_NUMBER_TABLE
3702 , p6_a40 JTF_NUMBER_TABLE
3703 , p6_a41 JTF_VARCHAR2_TABLE_100
3704 , p6_a42 JTF_DATE_TABLE
3705 , p6_a43 JTF_NUMBER_TABLE
3706 , p6_a44 JTF_NUMBER_TABLE
3707 , p6_a45 JTF_DATE_TABLE
3708 , p6_a46 JTF_NUMBER_TABLE
3709 , p6_a47 JTF_DATE_TABLE
3710 , p6_a48 JTF_DATE_TABLE
3711 , p6_a49 JTF_DATE_TABLE
3712 , p6_a50 JTF_NUMBER_TABLE
3713 , p6_a51 JTF_NUMBER_TABLE
3714 , p6_a52 JTF_VARCHAR2_TABLE_100
3715 , p6_a53 JTF_NUMBER_TABLE
3716 , p6_a54 JTF_NUMBER_TABLE
3717 , p6_a55 JTF_VARCHAR2_TABLE_100
3718 , p6_a56 JTF_VARCHAR2_TABLE_100
3719 , p6_a57 JTF_NUMBER_TABLE
3720 , p6_a58 JTF_DATE_TABLE
3721 , p6_a59 JTF_NUMBER_TABLE
3722 , p6_a60 JTF_VARCHAR2_TABLE_100
3723 , p6_a61 JTF_VARCHAR2_TABLE_500
3724 , p6_a62 JTF_VARCHAR2_TABLE_500
3725 , p6_a63 JTF_VARCHAR2_TABLE_500
3726 , p6_a64 JTF_VARCHAR2_TABLE_500
3727 , p6_a65 JTF_VARCHAR2_TABLE_500
3728 , p6_a66 JTF_VARCHAR2_TABLE_500
3729 , p6_a67 JTF_VARCHAR2_TABLE_500
3730 , p6_a68 JTF_VARCHAR2_TABLE_500
3731 , p6_a69 JTF_VARCHAR2_TABLE_500
3732 , p6_a70 JTF_VARCHAR2_TABLE_500
3733 , p6_a71 JTF_VARCHAR2_TABLE_500
3734 , p6_a72 JTF_VARCHAR2_TABLE_500
3735 , p6_a73 JTF_VARCHAR2_TABLE_500
3736 , p6_a74 JTF_VARCHAR2_TABLE_500
3737 , p6_a75 JTF_VARCHAR2_TABLE_500
3738 , p6_a76 JTF_NUMBER_TABLE
3739 , p6_a77 JTF_NUMBER_TABLE
3740 , p6_a78 JTF_NUMBER_TABLE
3741 , p6_a79 JTF_DATE_TABLE
3742 , p6_a80 JTF_NUMBER_TABLE
3743 , p6_a81 JTF_DATE_TABLE
3744 , p6_a82 JTF_NUMBER_TABLE
3745 , p6_a83 JTF_DATE_TABLE
3746 , p6_a84 JTF_DATE_TABLE
3747 , p6_a85 JTF_DATE_TABLE
3748 , p6_a86 JTF_DATE_TABLE
3749 , p6_a87 JTF_NUMBER_TABLE
3750 , p6_a88 JTF_NUMBER_TABLE
3751 , p6_a89 JTF_NUMBER_TABLE
3752 , p6_a90 JTF_VARCHAR2_TABLE_100
3753 , p6_a91 JTF_NUMBER_TABLE
3754 , p6_a92 JTF_VARCHAR2_TABLE_100
3755 , p6_a93 JTF_NUMBER_TABLE
3756 , p6_a94 JTF_NUMBER_TABLE
3757 , p6_a95 JTF_DATE_TABLE
3758 , p6_a96 JTF_VARCHAR2_TABLE_100
3759 , p6_a97 JTF_VARCHAR2_TABLE_100
3760 , p6_a98 JTF_NUMBER_TABLE
3761 , p7_a0 JTF_NUMBER_TABLE
3762 , p7_a1 JTF_NUMBER_TABLE
3763 , p7_a2 JTF_NUMBER_TABLE
3764 , p7_a3 JTF_NUMBER_TABLE
3765 , p7_a4 JTF_NUMBER_TABLE
3766 , p7_a5 JTF_NUMBER_TABLE
3767 , p7_a6 JTF_VARCHAR2_TABLE_100
3768 , p7_a7 JTF_VARCHAR2_TABLE_200
3769 , p7_a8 JTF_VARCHAR2_TABLE_100
3770 , p7_a9 JTF_VARCHAR2_TABLE_100
3771 , p7_a10 JTF_VARCHAR2_TABLE_100
3772 , p7_a11 JTF_NUMBER_TABLE
3773 , p7_a12 JTF_VARCHAR2_TABLE_100
3774 , p7_a13 JTF_NUMBER_TABLE
3775 , p7_a14 JTF_VARCHAR2_TABLE_100
3776 , p7_a15 JTF_NUMBER_TABLE
3777 , p7_a16 JTF_DATE_TABLE
3778 , p7_a17 JTF_NUMBER_TABLE
3779 , p7_a18 JTF_DATE_TABLE
3780 , p7_a19 JTF_NUMBER_TABLE
3781 , p8_a0 out nocopy JTF_NUMBER_TABLE
3782 , p8_a1 out nocopy JTF_NUMBER_TABLE
3783 , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
3784 , p8_a3 out nocopy JTF_NUMBER_TABLE
3785 , p8_a4 out nocopy JTF_NUMBER_TABLE
3786 , p8_a5 out nocopy JTF_NUMBER_TABLE
3787 , p8_a6 out nocopy JTF_NUMBER_TABLE
3788 , p8_a7 out nocopy JTF_NUMBER_TABLE
3789 , p8_a8 out nocopy JTF_VARCHAR2_TABLE_200
3790 , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
3791 , p8_a10 out nocopy JTF_NUMBER_TABLE
3792 , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
3793 , p8_a12 out nocopy JTF_NUMBER_TABLE
3794 , p8_a13 out nocopy JTF_VARCHAR2_TABLE_2000
3795 , p8_a14 out nocopy JTF_VARCHAR2_TABLE_2000
3796 , p8_a15 out nocopy JTF_VARCHAR2_TABLE_2000
3797 , p8_a16 out nocopy JTF_VARCHAR2_TABLE_300
3798 , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
3799 , p8_a18 out nocopy JTF_NUMBER_TABLE
3800 , p8_a19 out nocopy JTF_NUMBER_TABLE
3801 , p8_a20 out nocopy JTF_NUMBER_TABLE
3802 , p8_a21 out nocopy JTF_NUMBER_TABLE
3803 , p8_a22 out nocopy JTF_VARCHAR2_TABLE_100
3804 , p8_a23 out nocopy JTF_VARCHAR2_TABLE_100
3805 , p8_a24 out nocopy JTF_VARCHAR2_TABLE_100
3806 , p8_a25 out nocopy JTF_VARCHAR2_TABLE_2000
3807 , p8_a26 out nocopy JTF_VARCHAR2_TABLE_100
3808 , p8_a27 out nocopy JTF_VARCHAR2_TABLE_200
3809 , p8_a28 out nocopy JTF_DATE_TABLE
3810 , p8_a29 out nocopy JTF_VARCHAR2_TABLE_200
3811 , p8_a30 out nocopy JTF_DATE_TABLE
3812 , p8_a31 out nocopy JTF_DATE_TABLE
3813 , p8_a32 out nocopy JTF_DATE_TABLE
3814 , p8_a33 out nocopy JTF_VARCHAR2_TABLE_100
3815 , p8_a34 out nocopy JTF_NUMBER_TABLE
3816 , p8_a35 out nocopy JTF_VARCHAR2_TABLE_100
3817 , p8_a36 out nocopy JTF_NUMBER_TABLE
3818 , p8_a37 out nocopy JTF_VARCHAR2_TABLE_100
3819 , p8_a38 out nocopy JTF_VARCHAR2_TABLE_100
3820 , p8_a39 out nocopy JTF_VARCHAR2_TABLE_500
3821 , p8_a40 out nocopy JTF_VARCHAR2_TABLE_500
3822 , p8_a41 out nocopy JTF_VARCHAR2_TABLE_500
3823 , p8_a42 out nocopy JTF_VARCHAR2_TABLE_500
3824 , p8_a43 out nocopy JTF_VARCHAR2_TABLE_500
3825 , p8_a44 out nocopy JTF_VARCHAR2_TABLE_500
3826 , p8_a45 out nocopy JTF_VARCHAR2_TABLE_500
3827 , p8_a46 out nocopy JTF_VARCHAR2_TABLE_500
3828 , p8_a47 out nocopy JTF_VARCHAR2_TABLE_500
3829 , p8_a48 out nocopy JTF_VARCHAR2_TABLE_500
3830 , p8_a49 out nocopy JTF_VARCHAR2_TABLE_500
3831 , p8_a50 out nocopy JTF_VARCHAR2_TABLE_500
3832 , p8_a51 out nocopy JTF_VARCHAR2_TABLE_500
3833 , p8_a52 out nocopy JTF_VARCHAR2_TABLE_500
3834 , p8_a53 out nocopy JTF_VARCHAR2_TABLE_500
3835 , p8_a54 out nocopy JTF_NUMBER_TABLE
3836 , p8_a55 out nocopy JTF_DATE_TABLE
3837 , p8_a56 out nocopy JTF_NUMBER_TABLE
3838 , p8_a57 out nocopy JTF_DATE_TABLE
3839 , p8_a58 out nocopy JTF_VARCHAR2_TABLE_100
3840 , p8_a59 out nocopy JTF_VARCHAR2_TABLE_100
3841 , p8_a60 out nocopy JTF_VARCHAR2_TABLE_100
3842 , p8_a61 out nocopy JTF_NUMBER_TABLE
3843 , p8_a62 out nocopy JTF_VARCHAR2_TABLE_100
3844 , p8_a63 out nocopy JTF_VARCHAR2_TABLE_100
3845 , p8_a64 out nocopy JTF_VARCHAR2_TABLE_100
3846 , p8_a65 out nocopy JTF_VARCHAR2_TABLE_100
3847 , p8_a66 out nocopy JTF_VARCHAR2_TABLE_100
3848 , p8_a67 out nocopy JTF_NUMBER_TABLE
3849 , p8_a68 out nocopy JTF_NUMBER_TABLE
3850 , p8_a69 out nocopy JTF_NUMBER_TABLE
3851 , p8_a70 out nocopy JTF_DATE_TABLE
3852 , p8_a71 out nocopy JTF_NUMBER_TABLE
3853 , p8_a72 out nocopy JTF_DATE_TABLE
3854 , p8_a73 out nocopy JTF_NUMBER_TABLE
3855 , p8_a74 out nocopy JTF_NUMBER_TABLE
3856 , p8_a75 out nocopy JTF_VARCHAR2_TABLE_100
3857 , p8_a76 out nocopy JTF_VARCHAR2_TABLE_100
3858 , p8_a77 out nocopy JTF_NUMBER_TABLE
3859 , p8_a78 out nocopy JTF_NUMBER_TABLE
3860 , p8_a79 out nocopy JTF_VARCHAR2_TABLE_100
3861 , p8_a80 out nocopy JTF_VARCHAR2_TABLE_100
3862 , p8_a81 out nocopy JTF_NUMBER_TABLE
3863 , p8_a82 out nocopy JTF_VARCHAR2_TABLE_100
3864 , p8_a83 out nocopy JTF_NUMBER_TABLE
3865 , p8_a84 out nocopy JTF_NUMBER_TABLE
3866 , p8_a85 out nocopy JTF_NUMBER_TABLE
3867 , p8_a86 out nocopy JTF_NUMBER_TABLE
3868 , p8_a87 out nocopy JTF_VARCHAR2_TABLE_100
3869 , p8_a88 out nocopy JTF_NUMBER_TABLE
3870 , p8_a89 out nocopy JTF_NUMBER_TABLE
3871 , p9_a0 out nocopy JTF_NUMBER_TABLE
3872 , p9_a1 out nocopy JTF_NUMBER_TABLE
3873 , p9_a2 out nocopy JTF_NUMBER_TABLE
3874 , p9_a3 out nocopy JTF_NUMBER_TABLE
3875 , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
3876 , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
3877 , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
3878 , p9_a7 out nocopy JTF_NUMBER_TABLE
3879 , p9_a8 out nocopy JTF_NUMBER_TABLE
3880 , p9_a9 out nocopy JTF_DATE_TABLE
3881 , p9_a10 out nocopy JTF_NUMBER_TABLE
3882 , p9_a11 out nocopy JTF_NUMBER_TABLE
3883 , p9_a12 out nocopy JTF_NUMBER_TABLE
3884 , p9_a13 out nocopy JTF_NUMBER_TABLE
3885 , p9_a14 out nocopy JTF_NUMBER_TABLE
3886 , p9_a15 out nocopy JTF_NUMBER_TABLE
3887 , p9_a16 out nocopy JTF_NUMBER_TABLE
3888 , p9_a17 out nocopy JTF_NUMBER_TABLE
3889 , p9_a18 out nocopy JTF_NUMBER_TABLE
3890 , p9_a19 out nocopy JTF_NUMBER_TABLE
3891 , p9_a20 out nocopy JTF_DATE_TABLE
3892 , p9_a21 out nocopy JTF_DATE_TABLE
3893 , p9_a22 out nocopy JTF_NUMBER_TABLE
3894 , p9_a23 out nocopy JTF_NUMBER_TABLE
3895 , p9_a24 out nocopy JTF_DATE_TABLE
3896 , p9_a25 out nocopy JTF_DATE_TABLE
3897 , p9_a26 out nocopy JTF_DATE_TABLE
3898 , p9_a27 out nocopy JTF_NUMBER_TABLE
3899 , p9_a28 out nocopy JTF_NUMBER_TABLE
3900 , p9_a29 out nocopy JTF_NUMBER_TABLE
3901 , p9_a30 out nocopy JTF_NUMBER_TABLE
3902 , p9_a31 out nocopy JTF_NUMBER_TABLE
3903 , p9_a32 out nocopy JTF_NUMBER_TABLE
3904 , p9_a33 out nocopy JTF_NUMBER_TABLE
3905 , p9_a34 out nocopy JTF_DATE_TABLE
3906 , p9_a35 out nocopy JTF_VARCHAR2_TABLE_100
3907 , p9_a36 out nocopy JTF_DATE_TABLE
3908 , p9_a37 out nocopy JTF_VARCHAR2_TABLE_300
3909 , p9_a38 out nocopy JTF_NUMBER_TABLE
3910 , p9_a39 out nocopy JTF_NUMBER_TABLE
3911 , p9_a40 out nocopy JTF_NUMBER_TABLE
3912 , p9_a41 out nocopy JTF_VARCHAR2_TABLE_100
3913 , p9_a42 out nocopy JTF_DATE_TABLE
3914 , p9_a43 out nocopy JTF_NUMBER_TABLE
3915 , p9_a44 out nocopy JTF_NUMBER_TABLE
3916 , p9_a45 out nocopy JTF_DATE_TABLE
3917 , p9_a46 out nocopy JTF_NUMBER_TABLE
3918 , p9_a47 out nocopy JTF_DATE_TABLE
3919 , p9_a48 out nocopy JTF_DATE_TABLE
3920 , p9_a49 out nocopy JTF_DATE_TABLE
3921 , p9_a50 out nocopy JTF_NUMBER_TABLE
3922 , p9_a51 out nocopy JTF_NUMBER_TABLE
3923 , p9_a52 out nocopy JTF_VARCHAR2_TABLE_100
3924 , p9_a53 out nocopy JTF_NUMBER_TABLE
3925 , p9_a54 out nocopy JTF_NUMBER_TABLE
3926 , p9_a55 out nocopy JTF_VARCHAR2_TABLE_100
3927 , p9_a56 out nocopy JTF_VARCHAR2_TABLE_100
3928 , p9_a57 out nocopy JTF_NUMBER_TABLE
3929 , p9_a58 out nocopy JTF_DATE_TABLE
3930 , p9_a59 out nocopy JTF_NUMBER_TABLE
3931 , p9_a60 out nocopy JTF_VARCHAR2_TABLE_100
3932 , p9_a61 out nocopy JTF_VARCHAR2_TABLE_500
3933 , p9_a62 out nocopy JTF_VARCHAR2_TABLE_500
3934 , p9_a63 out nocopy JTF_VARCHAR2_TABLE_500
3935 , p9_a64 out nocopy JTF_VARCHAR2_TABLE_500
3936 , p9_a65 out nocopy JTF_VARCHAR2_TABLE_500
3937 , p9_a66 out nocopy JTF_VARCHAR2_TABLE_500
3938 , p9_a67 out nocopy JTF_VARCHAR2_TABLE_500
3939 , p9_a68 out nocopy JTF_VARCHAR2_TABLE_500
3940 , p9_a69 out nocopy JTF_VARCHAR2_TABLE_500
3941 , p9_a70 out nocopy JTF_VARCHAR2_TABLE_500
3942 , p9_a71 out nocopy JTF_VARCHAR2_TABLE_500
3943 , p9_a72 out nocopy JTF_VARCHAR2_TABLE_500
3944 , p9_a73 out nocopy JTF_VARCHAR2_TABLE_500
3945 , p9_a74 out nocopy JTF_VARCHAR2_TABLE_500
3946 , p9_a75 out nocopy JTF_VARCHAR2_TABLE_500
3947 , p9_a76 out nocopy JTF_NUMBER_TABLE
3948 , p9_a77 out nocopy JTF_NUMBER_TABLE
3949 , p9_a78 out nocopy JTF_NUMBER_TABLE
3950 , p9_a79 out nocopy JTF_DATE_TABLE
3951 , p9_a80 out nocopy JTF_NUMBER_TABLE
3952 , p9_a81 out nocopy JTF_DATE_TABLE
3953 , p9_a82 out nocopy JTF_NUMBER_TABLE
3954 , p9_a83 out nocopy JTF_DATE_TABLE
3955 , p9_a84 out nocopy JTF_DATE_TABLE
3956 , p9_a85 out nocopy JTF_DATE_TABLE
3957 , p9_a86 out nocopy JTF_DATE_TABLE
3958 , p9_a87 out nocopy JTF_NUMBER_TABLE
3959 , p9_a88 out nocopy JTF_NUMBER_TABLE
3960 , p9_a89 out nocopy JTF_NUMBER_TABLE
3961 , p9_a90 out nocopy JTF_VARCHAR2_TABLE_100
3962 , p9_a91 out nocopy JTF_NUMBER_TABLE
3963 , p9_a92 out nocopy JTF_VARCHAR2_TABLE_100
3964 , p9_a93 out nocopy JTF_NUMBER_TABLE
3965 , p9_a94 out nocopy JTF_NUMBER_TABLE
3966 , p9_a95 out nocopy JTF_DATE_TABLE
3967 , p9_a96 out nocopy JTF_VARCHAR2_TABLE_100
3968 , p9_a97 out nocopy JTF_VARCHAR2_TABLE_100
3969 , p9_a98 out nocopy JTF_NUMBER_TABLE
3970 , p10_a0 out nocopy JTF_NUMBER_TABLE
3971 , p10_a1 out nocopy JTF_NUMBER_TABLE
3972 , p10_a2 out nocopy JTF_NUMBER_TABLE
3973 , p10_a3 out nocopy JTF_NUMBER_TABLE
3974 , p10_a4 out nocopy JTF_NUMBER_TABLE
3975 , p10_a5 out nocopy JTF_NUMBER_TABLE
3976 , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
3977 , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
3978 , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
3979 , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
3980 , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
3981 , p10_a11 out nocopy JTF_NUMBER_TABLE
3982 , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
3983 , p10_a13 out nocopy JTF_NUMBER_TABLE
3984 , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100
3985 , p10_a15 out nocopy JTF_NUMBER_TABLE
3986 , p10_a16 out nocopy JTF_DATE_TABLE
3987 , p10_a17 out nocopy JTF_NUMBER_TABLE
3988 , p10_a18 out nocopy JTF_DATE_TABLE
3989 , p10_a19 out nocopy JTF_NUMBER_TABLE
3990 )
3991
3992 as
3993 ddp_clev_tbl okl_contract_line_item_pvt.clev_tbl_type;
3994 ddp_klev_tbl okl_contract_line_item_pvt.klev_tbl_type;
3995 ddp_cimv_tbl okl_contract_line_item_pvt.cimv_tbl_type;
3996 ddx_clev_tbl okl_contract_line_item_pvt.clev_tbl_type;
3997 ddx_klev_tbl okl_contract_line_item_pvt.klev_tbl_type;
3998 ddx_cimv_tbl okl_contract_line_item_pvt.cimv_tbl_type;
3999 ddindx binary_integer; indx binary_integer;
4000 begin
4001
4002 -- copy data to the local IN or IN-OUT args, if any
4003
4004
4005
4006
4007
4008 okl_okc_migration_pvt_w.rosetta_table_copy_in_p5(ddp_clev_tbl, p5_a0
4009 , p5_a1
4010 , p5_a2
4011 , p5_a3
4012 , p5_a4
4013 , p5_a5
4014 , p5_a6
4015 , p5_a7
4016 , p5_a8
4017 , p5_a9
4018 , p5_a10
4019 , p5_a11
4020 , p5_a12
4021 , p5_a13
4022 , p5_a14
4023 , p5_a15
4024 , p5_a16
4025 , p5_a17
4026 , p5_a18
4027 , p5_a19
4028 , p5_a20
4029 , p5_a21
4030 , p5_a22
4031 , p5_a23
4032 , p5_a24
4033 , p5_a25
4034 , p5_a26
4035 , p5_a27
4036 , p5_a28
4037 , p5_a29
4038 , p5_a30
4039 , p5_a31
4040 , p5_a32
4041 , p5_a33
4042 , p5_a34
4043 , p5_a35
4044 , p5_a36
4045 , p5_a37
4046 , p5_a38
4047 , p5_a39
4048 , p5_a40
4049 , p5_a41
4050 , p5_a42
4051 , p5_a43
4052 , p5_a44
4053 , p5_a45
4054 , p5_a46
4055 , p5_a47
4056 , p5_a48
4057 , p5_a49
4058 , p5_a50
4059 , p5_a51
4060 , p5_a52
4061 , p5_a53
4062 , p5_a54
4063 , p5_a55
4064 , p5_a56
4065 , p5_a57
4066 , p5_a58
4067 , p5_a59
4068 , p5_a60
4069 , p5_a61
4070 , p5_a62
4071 , p5_a63
4072 , p5_a64
4073 , p5_a65
4074 , p5_a66
4075 , p5_a67
4076 , p5_a68
4077 , p5_a69
4078 , p5_a70
4079 , p5_a71
4080 , p5_a72
4081 , p5_a73
4082 , p5_a74
4083 , p5_a75
4084 , p5_a76
4085 , p5_a77
4086 , p5_a78
4087 , p5_a79
4088 , p5_a80
4089 , p5_a81
4090 , p5_a82
4091 , p5_a83
4092 , p5_a84
4093 , p5_a85
4094 , p5_a86
4095 , p5_a87
4096 , p5_a88
4097 , p5_a89
4098 );
4099
4100 okl_kle_pvt_w.rosetta_table_copy_in_p8(ddp_klev_tbl, p6_a0
4101 , p6_a1
4102 , p6_a2
4103 , p6_a3
4104 , p6_a4
4105 , p6_a5
4106 , p6_a6
4107 , p6_a7
4108 , p6_a8
4109 , p6_a9
4110 , p6_a10
4111 , p6_a11
4112 , p6_a12
4113 , p6_a13
4114 , p6_a14
4115 , p6_a15
4116 , p6_a16
4117 , p6_a17
4118 , p6_a18
4119 , p6_a19
4120 , p6_a20
4121 , p6_a21
4122 , p6_a22
4123 , p6_a23
4124 , p6_a24
4125 , p6_a25
4126 , p6_a26
4127 , p6_a27
4128 , p6_a28
4129 , p6_a29
4130 , p6_a30
4131 , p6_a31
4132 , p6_a32
4133 , p6_a33
4134 , p6_a34
4135 , p6_a35
4136 , p6_a36
4137 , p6_a37
4138 , p6_a38
4139 , p6_a39
4140 , p6_a40
4141 , p6_a41
4142 , p6_a42
4143 , p6_a43
4144 , p6_a44
4145 , p6_a45
4146 , p6_a46
4147 , p6_a47
4148 , p6_a48
4149 , p6_a49
4150 , p6_a50
4151 , p6_a51
4152 , p6_a52
4153 , p6_a53
4154 , p6_a54
4155 , p6_a55
4156 , p6_a56
4157 , p6_a57
4158 , p6_a58
4159 , p6_a59
4160 , p6_a60
4161 , p6_a61
4162 , p6_a62
4163 , p6_a63
4164 , p6_a64
4165 , p6_a65
4166 , p6_a66
4167 , p6_a67
4168 , p6_a68
4169 , p6_a69
4170 , p6_a70
4171 , p6_a71
4172 , p6_a72
4173 , p6_a73
4174 , p6_a74
4175 , p6_a75
4176 , p6_a76
4177 , p6_a77
4178 , p6_a78
4179 , p6_a79
4180 , p6_a80
4181 , p6_a81
4182 , p6_a82
4183 , p6_a83
4184 , p6_a84
4185 , p6_a85
4186 , p6_a86
4187 , p6_a87
4188 , p6_a88
4189 , p6_a89
4190 , p6_a90
4191 , p6_a91
4192 , p6_a92
4193 , p6_a93
4194 , p6_a94
4195 , p6_a95
4196 , p6_a96
4197 , p6_a97
4198 , p6_a98
4199 );
4200
4201 okl_okc_migration_pvt_w.rosetta_table_copy_in_p7(ddp_cimv_tbl, p7_a0
4202 , p7_a1
4203 , p7_a2
4204 , p7_a3
4205 , p7_a4
4206 , p7_a5
4207 , p7_a6
4208 , p7_a7
4209 , p7_a8
4210 , p7_a9
4211 , p7_a10
4212 , p7_a11
4213 , p7_a12
4214 , p7_a13
4215 , p7_a14
4216 , p7_a15
4217 , p7_a16
4218 , p7_a17
4219 , p7_a18
4220 , p7_a19
4221 );
4222
4223
4224
4225
4226 -- here's the delegated call to the old PL/SQL routine
4227 okl_contract_line_item_pvt.update_contract_line_item(p_api_version,
4228 p_init_msg_list,
4229 x_return_status,
4230 x_msg_count,
4231 x_msg_data,
4232 ddp_clev_tbl,
4233 ddp_klev_tbl,
4234 ddp_cimv_tbl,
4235 ddx_clev_tbl,
4236 ddx_klev_tbl,
4237 ddx_cimv_tbl);
4238
4239 -- copy data back from the local variables to OUT or IN-OUT args, if any
4240
4241
4242
4243
4244
4245
4246
4247
4248 okl_okc_migration_pvt_w.rosetta_table_copy_out_p5(ddx_clev_tbl, p8_a0
4249 , p8_a1
4250 , p8_a2
4251 , p8_a3
4252 , p8_a4
4253 , p8_a5
4254 , p8_a6
4255 , p8_a7
4256 , p8_a8
4257 , p8_a9
4258 , p8_a10
4259 , p8_a11
4260 , p8_a12
4261 , p8_a13
4262 , p8_a14
4263 , p8_a15
4264 , p8_a16
4265 , p8_a17
4266 , p8_a18
4267 , p8_a19
4268 , p8_a20
4269 , p8_a21
4270 , p8_a22
4271 , p8_a23
4272 , p8_a24
4273 , p8_a25
4274 , p8_a26
4275 , p8_a27
4276 , p8_a28
4277 , p8_a29
4278 , p8_a30
4279 , p8_a31
4280 , p8_a32
4281 , p8_a33
4282 , p8_a34
4283 , p8_a35
4284 , p8_a36
4285 , p8_a37
4286 , p8_a38
4287 , p8_a39
4288 , p8_a40
4289 , p8_a41
4290 , p8_a42
4291 , p8_a43
4292 , p8_a44
4293 , p8_a45
4294 , p8_a46
4295 , p8_a47
4296 , p8_a48
4297 , p8_a49
4298 , p8_a50
4299 , p8_a51
4300 , p8_a52
4301 , p8_a53
4302 , p8_a54
4303 , p8_a55
4304 , p8_a56
4305 , p8_a57
4306 , p8_a58
4307 , p8_a59
4308 , p8_a60
4309 , p8_a61
4310 , p8_a62
4311 , p8_a63
4312 , p8_a64
4313 , p8_a65
4314 , p8_a66
4315 , p8_a67
4316 , p8_a68
4317 , p8_a69
4318 , p8_a70
4319 , p8_a71
4320 , p8_a72
4321 , p8_a73
4322 , p8_a74
4323 , p8_a75
4324 , p8_a76
4325 , p8_a77
4326 , p8_a78
4327 , p8_a79
4328 , p8_a80
4329 , p8_a81
4330 , p8_a82
4331 , p8_a83
4332 , p8_a84
4333 , p8_a85
4334 , p8_a86
4335 , p8_a87
4336 , p8_a88
4337 , p8_a89
4338 );
4339
4340 okl_kle_pvt_w.rosetta_table_copy_out_p8(ddx_klev_tbl, p9_a0
4341 , p9_a1
4342 , p9_a2
4343 , p9_a3
4344 , p9_a4
4345 , p9_a5
4346 , p9_a6
4347 , p9_a7
4348 , p9_a8
4349 , p9_a9
4350 , p9_a10
4351 , p9_a11
4352 , p9_a12
4353 , p9_a13
4354 , p9_a14
4355 , p9_a15
4356 , p9_a16
4357 , p9_a17
4358 , p9_a18
4359 , p9_a19
4360 , p9_a20
4361 , p9_a21
4362 , p9_a22
4363 , p9_a23
4364 , p9_a24
4365 , p9_a25
4366 , p9_a26
4367 , p9_a27
4368 , p9_a28
4369 , p9_a29
4370 , p9_a30
4371 , p9_a31
4372 , p9_a32
4373 , p9_a33
4374 , p9_a34
4375 , p9_a35
4376 , p9_a36
4377 , p9_a37
4378 , p9_a38
4379 , p9_a39
4380 , p9_a40
4381 , p9_a41
4382 , p9_a42
4383 , p9_a43
4384 , p9_a44
4385 , p9_a45
4386 , p9_a46
4387 , p9_a47
4388 , p9_a48
4389 , p9_a49
4390 , p9_a50
4391 , p9_a51
4392 , p9_a52
4393 , p9_a53
4394 , p9_a54
4395 , p9_a55
4396 , p9_a56
4397 , p9_a57
4398 , p9_a58
4399 , p9_a59
4400 , p9_a60
4401 , p9_a61
4402 , p9_a62
4403 , p9_a63
4404 , p9_a64
4405 , p9_a65
4406 , p9_a66
4407 , p9_a67
4408 , p9_a68
4409 , p9_a69
4410 , p9_a70
4411 , p9_a71
4412 , p9_a72
4413 , p9_a73
4414 , p9_a74
4415 , p9_a75
4416 , p9_a76
4417 , p9_a77
4418 , p9_a78
4419 , p9_a79
4420 , p9_a80
4421 , p9_a81
4422 , p9_a82
4423 , p9_a83
4424 , p9_a84
4425 , p9_a85
4426 , p9_a86
4427 , p9_a87
4428 , p9_a88
4429 , p9_a89
4430 , p9_a90
4431 , p9_a91
4432 , p9_a92
4433 , p9_a93
4434 , p9_a94
4435 , p9_a95
4436 , p9_a96
4437 , p9_a97
4438 , p9_a98
4439 );
4440
4441 okl_okc_migration_pvt_w.rosetta_table_copy_out_p7(ddx_cimv_tbl, p10_a0
4442 , p10_a1
4443 , p10_a2
4444 , p10_a3
4445 , p10_a4
4446 , p10_a5
4447 , p10_a6
4448 , p10_a7
4449 , p10_a8
4450 , p10_a9
4451 , p10_a10
4452 , p10_a11
4453 , p10_a12
4454 , p10_a13
4455 , p10_a14
4456 , p10_a15
4457 , p10_a16
4458 , p10_a17
4459 , p10_a18
4460 , p10_a19
4461 );
4462 end;
4463
4464 procedure delete_contract_line_item(p_api_version NUMBER
4465 , p_init_msg_list VARCHAR2
4466 , x_return_status out nocopy VARCHAR2
4467 , x_msg_count out nocopy NUMBER
4468 , x_msg_data out nocopy VARCHAR2
4469 , p5_a0 JTF_NUMBER_TABLE
4470 , p5_a1 JTF_NUMBER_TABLE
4471 , p5_a2 JTF_VARCHAR2_TABLE_100
4472 , p5_a3 JTF_NUMBER_TABLE
4473 , p5_a4 JTF_NUMBER_TABLE
4474 , p5_a5 JTF_NUMBER_TABLE
4475 , p5_a6 JTF_NUMBER_TABLE
4476 , p5_a7 JTF_NUMBER_TABLE
4477 , p5_a8 JTF_VARCHAR2_TABLE_200
4478 , p5_a9 JTF_VARCHAR2_TABLE_100
4479 , p5_a10 JTF_NUMBER_TABLE
4480 , p5_a11 JTF_VARCHAR2_TABLE_100
4481 , p5_a12 JTF_NUMBER_TABLE
4482 , p5_a13 JTF_VARCHAR2_TABLE_2000
4483 , p5_a14 JTF_VARCHAR2_TABLE_2000
4484 , p5_a15 JTF_VARCHAR2_TABLE_2000
4485 , p5_a16 JTF_VARCHAR2_TABLE_300
4486 , p5_a17 JTF_VARCHAR2_TABLE_100
4487 , p5_a18 JTF_NUMBER_TABLE
4488 , p5_a19 JTF_NUMBER_TABLE
4489 , p5_a20 JTF_NUMBER_TABLE
4490 , p5_a21 JTF_NUMBER_TABLE
4491 , p5_a22 JTF_VARCHAR2_TABLE_100
4492 , p5_a23 JTF_VARCHAR2_TABLE_100
4493 , p5_a24 JTF_VARCHAR2_TABLE_100
4494 , p5_a25 JTF_VARCHAR2_TABLE_2000
4495 , p5_a26 JTF_VARCHAR2_TABLE_100
4496 , p5_a27 JTF_VARCHAR2_TABLE_200
4497 , p5_a28 JTF_DATE_TABLE
4498 , p5_a29 JTF_VARCHAR2_TABLE_200
4499 , p5_a30 JTF_DATE_TABLE
4500 , p5_a31 JTF_DATE_TABLE
4501 , p5_a32 JTF_DATE_TABLE
4502 , p5_a33 JTF_VARCHAR2_TABLE_100
4503 , p5_a34 JTF_NUMBER_TABLE
4504 , p5_a35 JTF_VARCHAR2_TABLE_100
4505 , p5_a36 JTF_NUMBER_TABLE
4506 , p5_a37 JTF_VARCHAR2_TABLE_100
4507 , p5_a38 JTF_VARCHAR2_TABLE_100
4508 , p5_a39 JTF_VARCHAR2_TABLE_500
4509 , p5_a40 JTF_VARCHAR2_TABLE_500
4510 , p5_a41 JTF_VARCHAR2_TABLE_500
4511 , p5_a42 JTF_VARCHAR2_TABLE_500
4512 , p5_a43 JTF_VARCHAR2_TABLE_500
4513 , p5_a44 JTF_VARCHAR2_TABLE_500
4514 , p5_a45 JTF_VARCHAR2_TABLE_500
4515 , p5_a46 JTF_VARCHAR2_TABLE_500
4516 , p5_a47 JTF_VARCHAR2_TABLE_500
4517 , p5_a48 JTF_VARCHAR2_TABLE_500
4518 , p5_a49 JTF_VARCHAR2_TABLE_500
4519 , p5_a50 JTF_VARCHAR2_TABLE_500
4520 , p5_a51 JTF_VARCHAR2_TABLE_500
4521 , p5_a52 JTF_VARCHAR2_TABLE_500
4522 , p5_a53 JTF_VARCHAR2_TABLE_500
4523 , p5_a54 JTF_NUMBER_TABLE
4524 , p5_a55 JTF_DATE_TABLE
4525 , p5_a56 JTF_NUMBER_TABLE
4526 , p5_a57 JTF_DATE_TABLE
4527 , p5_a58 JTF_VARCHAR2_TABLE_100
4528 , p5_a59 JTF_VARCHAR2_TABLE_100
4529 , p5_a60 JTF_VARCHAR2_TABLE_100
4530 , p5_a61 JTF_NUMBER_TABLE
4531 , p5_a62 JTF_VARCHAR2_TABLE_100
4532 , p5_a63 JTF_VARCHAR2_TABLE_100
4533 , p5_a64 JTF_VARCHAR2_TABLE_100
4534 , p5_a65 JTF_VARCHAR2_TABLE_100
4535 , p5_a66 JTF_VARCHAR2_TABLE_100
4536 , p5_a67 JTF_NUMBER_TABLE
4537 , p5_a68 JTF_NUMBER_TABLE
4538 , p5_a69 JTF_NUMBER_TABLE
4539 , p5_a70 JTF_DATE_TABLE
4540 , p5_a71 JTF_NUMBER_TABLE
4541 , p5_a72 JTF_DATE_TABLE
4542 , p5_a73 JTF_NUMBER_TABLE
4543 , p5_a74 JTF_NUMBER_TABLE
4544 , p5_a75 JTF_VARCHAR2_TABLE_100
4545 , p5_a76 JTF_VARCHAR2_TABLE_100
4546 , p5_a77 JTF_NUMBER_TABLE
4547 , p5_a78 JTF_NUMBER_TABLE
4548 , p5_a79 JTF_VARCHAR2_TABLE_100
4549 , p5_a80 JTF_VARCHAR2_TABLE_100
4550 , p5_a81 JTF_NUMBER_TABLE
4551 , p5_a82 JTF_VARCHAR2_TABLE_100
4552 , p5_a83 JTF_NUMBER_TABLE
4553 , p5_a84 JTF_NUMBER_TABLE
4554 , p5_a85 JTF_NUMBER_TABLE
4555 , p5_a86 JTF_NUMBER_TABLE
4556 , p5_a87 JTF_VARCHAR2_TABLE_100
4557 , p5_a88 JTF_NUMBER_TABLE
4558 , p5_a89 JTF_NUMBER_TABLE
4559 , p6_a0 JTF_NUMBER_TABLE
4560 , p6_a1 JTF_NUMBER_TABLE
4561 , p6_a2 JTF_NUMBER_TABLE
4562 , p6_a3 JTF_NUMBER_TABLE
4563 , p6_a4 JTF_VARCHAR2_TABLE_100
4564 , p6_a5 JTF_VARCHAR2_TABLE_100
4565 , p6_a6 JTF_VARCHAR2_TABLE_100
4566 , p6_a7 JTF_NUMBER_TABLE
4567 , p6_a8 JTF_NUMBER_TABLE
4568 , p6_a9 JTF_DATE_TABLE
4569 , p6_a10 JTF_NUMBER_TABLE
4570 , p6_a11 JTF_NUMBER_TABLE
4571 , p6_a12 JTF_NUMBER_TABLE
4572 , p6_a13 JTF_NUMBER_TABLE
4573 , p6_a14 JTF_NUMBER_TABLE
4574 , p6_a15 JTF_NUMBER_TABLE
4575 , p6_a16 JTF_NUMBER_TABLE
4576 , p6_a17 JTF_NUMBER_TABLE
4577 , p6_a18 JTF_NUMBER_TABLE
4578 , p6_a19 JTF_NUMBER_TABLE
4579 , p6_a20 JTF_DATE_TABLE
4580 , p6_a21 JTF_DATE_TABLE
4581 , p6_a22 JTF_NUMBER_TABLE
4582 , p6_a23 JTF_NUMBER_TABLE
4583 , p6_a24 JTF_DATE_TABLE
4584 , p6_a25 JTF_DATE_TABLE
4585 , p6_a26 JTF_DATE_TABLE
4586 , p6_a27 JTF_NUMBER_TABLE
4587 , p6_a28 JTF_NUMBER_TABLE
4588 , p6_a29 JTF_NUMBER_TABLE
4589 , p6_a30 JTF_NUMBER_TABLE
4590 , p6_a31 JTF_NUMBER_TABLE
4591 , p6_a32 JTF_NUMBER_TABLE
4592 , p6_a33 JTF_NUMBER_TABLE
4593 , p6_a34 JTF_DATE_TABLE
4594 , p6_a35 JTF_VARCHAR2_TABLE_100
4595 , p6_a36 JTF_DATE_TABLE
4596 , p6_a37 JTF_VARCHAR2_TABLE_300
4597 , p6_a38 JTF_NUMBER_TABLE
4598 , p6_a39 JTF_NUMBER_TABLE
4599 , p6_a40 JTF_NUMBER_TABLE
4600 , p6_a41 JTF_VARCHAR2_TABLE_100
4601 , p6_a42 JTF_DATE_TABLE
4602 , p6_a43 JTF_NUMBER_TABLE
4603 , p6_a44 JTF_NUMBER_TABLE
4604 , p6_a45 JTF_DATE_TABLE
4605 , p6_a46 JTF_NUMBER_TABLE
4606 , p6_a47 JTF_DATE_TABLE
4607 , p6_a48 JTF_DATE_TABLE
4608 , p6_a49 JTF_DATE_TABLE
4609 , p6_a50 JTF_NUMBER_TABLE
4610 , p6_a51 JTF_NUMBER_TABLE
4611 , p6_a52 JTF_VARCHAR2_TABLE_100
4612 , p6_a53 JTF_NUMBER_TABLE
4613 , p6_a54 JTF_NUMBER_TABLE
4614 , p6_a55 JTF_VARCHAR2_TABLE_100
4615 , p6_a56 JTF_VARCHAR2_TABLE_100
4616 , p6_a57 JTF_NUMBER_TABLE
4617 , p6_a58 JTF_DATE_TABLE
4618 , p6_a59 JTF_NUMBER_TABLE
4619 , p6_a60 JTF_VARCHAR2_TABLE_100
4620 , p6_a61 JTF_VARCHAR2_TABLE_500
4621 , p6_a62 JTF_VARCHAR2_TABLE_500
4622 , p6_a63 JTF_VARCHAR2_TABLE_500
4623 , p6_a64 JTF_VARCHAR2_TABLE_500
4624 , p6_a65 JTF_VARCHAR2_TABLE_500
4625 , p6_a66 JTF_VARCHAR2_TABLE_500
4626 , p6_a67 JTF_VARCHAR2_TABLE_500
4627 , p6_a68 JTF_VARCHAR2_TABLE_500
4628 , p6_a69 JTF_VARCHAR2_TABLE_500
4629 , p6_a70 JTF_VARCHAR2_TABLE_500
4630 , p6_a71 JTF_VARCHAR2_TABLE_500
4631 , p6_a72 JTF_VARCHAR2_TABLE_500
4632 , p6_a73 JTF_VARCHAR2_TABLE_500
4633 , p6_a74 JTF_VARCHAR2_TABLE_500
4634 , p6_a75 JTF_VARCHAR2_TABLE_500
4635 , p6_a76 JTF_NUMBER_TABLE
4636 , p6_a77 JTF_NUMBER_TABLE
4637 , p6_a78 JTF_NUMBER_TABLE
4638 , p6_a79 JTF_DATE_TABLE
4639 , p6_a80 JTF_NUMBER_TABLE
4640 , p6_a81 JTF_DATE_TABLE
4641 , p6_a82 JTF_NUMBER_TABLE
4642 , p6_a83 JTF_DATE_TABLE
4643 , p6_a84 JTF_DATE_TABLE
4644 , p6_a85 JTF_DATE_TABLE
4645 , p6_a86 JTF_DATE_TABLE
4646 , p6_a87 JTF_NUMBER_TABLE
4647 , p6_a88 JTF_NUMBER_TABLE
4648 , p6_a89 JTF_NUMBER_TABLE
4649 , p6_a90 JTF_VARCHAR2_TABLE_100
4650 , p6_a91 JTF_NUMBER_TABLE
4651 , p6_a92 JTF_VARCHAR2_TABLE_100
4652 , p6_a93 JTF_NUMBER_TABLE
4653 , p6_a94 JTF_NUMBER_TABLE
4654 , p6_a95 JTF_DATE_TABLE
4655 , p6_a96 JTF_VARCHAR2_TABLE_100
4656 , p6_a97 JTF_VARCHAR2_TABLE_100
4657 , p6_a98 JTF_NUMBER_TABLE
4658 , p7_a0 JTF_NUMBER_TABLE
4659 , p7_a1 JTF_NUMBER_TABLE
4660 , p7_a2 JTF_NUMBER_TABLE
4661 , p7_a3 JTF_NUMBER_TABLE
4662 , p7_a4 JTF_NUMBER_TABLE
4663 , p7_a5 JTF_NUMBER_TABLE
4664 , p7_a6 JTF_VARCHAR2_TABLE_100
4665 , p7_a7 JTF_VARCHAR2_TABLE_200
4666 , p7_a8 JTF_VARCHAR2_TABLE_100
4667 , p7_a9 JTF_VARCHAR2_TABLE_100
4668 , p7_a10 JTF_VARCHAR2_TABLE_100
4669 , p7_a11 JTF_NUMBER_TABLE
4670 , p7_a12 JTF_VARCHAR2_TABLE_100
4671 , p7_a13 JTF_NUMBER_TABLE
4672 , p7_a14 JTF_VARCHAR2_TABLE_100
4673 , p7_a15 JTF_NUMBER_TABLE
4674 , p7_a16 JTF_DATE_TABLE
4675 , p7_a17 JTF_NUMBER_TABLE
4676 , p7_a18 JTF_DATE_TABLE
4677 , p7_a19 JTF_NUMBER_TABLE
4678 )
4679
4680 as
4681 ddp_clev_tbl okl_contract_line_item_pvt.clev_tbl_type;
4682 ddp_klev_tbl okl_contract_line_item_pvt.klev_tbl_type;
4683 ddp_cimv_tbl okl_contract_line_item_pvt.cimv_tbl_type;
4684 ddindx binary_integer; indx binary_integer;
4685 begin
4686
4687 -- copy data to the local IN or IN-OUT args, if any
4688
4689
4690
4691
4692
4693 okl_okc_migration_pvt_w.rosetta_table_copy_in_p5(ddp_clev_tbl, p5_a0
4694 , p5_a1
4695 , p5_a2
4696 , p5_a3
4697 , p5_a4
4698 , p5_a5
4699 , p5_a6
4700 , p5_a7
4701 , p5_a8
4702 , p5_a9
4703 , p5_a10
4704 , p5_a11
4705 , p5_a12
4706 , p5_a13
4707 , p5_a14
4708 , p5_a15
4709 , p5_a16
4710 , p5_a17
4711 , p5_a18
4712 , p5_a19
4713 , p5_a20
4714 , p5_a21
4715 , p5_a22
4716 , p5_a23
4717 , p5_a24
4718 , p5_a25
4719 , p5_a26
4720 , p5_a27
4721 , p5_a28
4722 , p5_a29
4723 , p5_a30
4724 , p5_a31
4725 , p5_a32
4726 , p5_a33
4727 , p5_a34
4728 , p5_a35
4729 , p5_a36
4730 , p5_a37
4731 , p5_a38
4732 , p5_a39
4733 , p5_a40
4734 , p5_a41
4735 , p5_a42
4736 , p5_a43
4737 , p5_a44
4738 , p5_a45
4739 , p5_a46
4740 , p5_a47
4741 , p5_a48
4742 , p5_a49
4743 , p5_a50
4744 , p5_a51
4745 , p5_a52
4746 , p5_a53
4747 , p5_a54
4748 , p5_a55
4749 , p5_a56
4750 , p5_a57
4751 , p5_a58
4752 , p5_a59
4753 , p5_a60
4754 , p5_a61
4755 , p5_a62
4756 , p5_a63
4757 , p5_a64
4758 , p5_a65
4759 , p5_a66
4760 , p5_a67
4761 , p5_a68
4762 , p5_a69
4763 , p5_a70
4764 , p5_a71
4765 , p5_a72
4766 , p5_a73
4767 , p5_a74
4768 , p5_a75
4769 , p5_a76
4770 , p5_a77
4771 , p5_a78
4772 , p5_a79
4773 , p5_a80
4774 , p5_a81
4775 , p5_a82
4776 , p5_a83
4777 , p5_a84
4778 , p5_a85
4779 , p5_a86
4780 , p5_a87
4781 , p5_a88
4782 , p5_a89
4783 );
4784
4785 okl_kle_pvt_w.rosetta_table_copy_in_p8(ddp_klev_tbl, p6_a0
4786 , p6_a1
4787 , p6_a2
4788 , p6_a3
4789 , p6_a4
4790 , p6_a5
4791 , p6_a6
4792 , p6_a7
4793 , p6_a8
4794 , p6_a9
4795 , p6_a10
4796 , p6_a11
4797 , p6_a12
4798 , p6_a13
4799 , p6_a14
4800 , p6_a15
4801 , p6_a16
4802 , p6_a17
4803 , p6_a18
4804 , p6_a19
4805 , p6_a20
4806 , p6_a21
4807 , p6_a22
4808 , p6_a23
4809 , p6_a24
4810 , p6_a25
4811 , p6_a26
4812 , p6_a27
4813 , p6_a28
4814 , p6_a29
4815 , p6_a30
4816 , p6_a31
4817 , p6_a32
4818 , p6_a33
4819 , p6_a34
4820 , p6_a35
4821 , p6_a36
4822 , p6_a37
4823 , p6_a38
4824 , p6_a39
4825 , p6_a40
4826 , p6_a41
4827 , p6_a42
4828 , p6_a43
4829 , p6_a44
4830 , p6_a45
4831 , p6_a46
4832 , p6_a47
4833 , p6_a48
4834 , p6_a49
4835 , p6_a50
4836 , p6_a51
4837 , p6_a52
4838 , p6_a53
4839 , p6_a54
4840 , p6_a55
4841 , p6_a56
4842 , p6_a57
4843 , p6_a58
4844 , p6_a59
4845 , p6_a60
4846 , p6_a61
4847 , p6_a62
4848 , p6_a63
4849 , p6_a64
4850 , p6_a65
4851 , p6_a66
4852 , p6_a67
4853 , p6_a68
4854 , p6_a69
4855 , p6_a70
4856 , p6_a71
4857 , p6_a72
4858 , p6_a73
4859 , p6_a74
4860 , p6_a75
4861 , p6_a76
4862 , p6_a77
4863 , p6_a78
4864 , p6_a79
4865 , p6_a80
4866 , p6_a81
4867 , p6_a82
4868 , p6_a83
4869 , p6_a84
4870 , p6_a85
4871 , p6_a86
4872 , p6_a87
4873 , p6_a88
4874 , p6_a89
4875 , p6_a90
4876 , p6_a91
4877 , p6_a92
4878 , p6_a93
4879 , p6_a94
4880 , p6_a95
4881 , p6_a96
4882 , p6_a97
4883 , p6_a98
4884 );
4885
4886 okl_okc_migration_pvt_w.rosetta_table_copy_in_p7(ddp_cimv_tbl, p7_a0
4887 , p7_a1
4888 , p7_a2
4889 , p7_a3
4890 , p7_a4
4891 , p7_a5
4892 , p7_a6
4893 , p7_a7
4894 , p7_a8
4895 , p7_a9
4896 , p7_a10
4897 , p7_a11
4898 , p7_a12
4899 , p7_a13
4900 , p7_a14
4901 , p7_a15
4902 , p7_a16
4903 , p7_a17
4904 , p7_a18
4905 , p7_a19
4906 );
4907
4908 -- here's the delegated call to the old PL/SQL routine
4909 okl_contract_line_item_pvt.delete_contract_line_item(p_api_version,
4910 p_init_msg_list,
4911 x_return_status,
4912 x_msg_count,
4913 x_msg_data,
4914 ddp_clev_tbl,
4915 ddp_klev_tbl,
4916 ddp_cimv_tbl);
4917
4918 -- copy data back from the local variables to OUT or IN-OUT args, if any
4919
4920
4921
4922
4923
4924
4925
4926 end;
4927
4928 end okl_contract_line_item_pvt_w;