[Home] [Help]
PACKAGE BODY: APPS.OKL_KHR_PVT_W
Source
1 package body okl_khr_pvt_w as
2 /* $Header: OKLIKHRB.pls 115.7 2002/12/20 19:17:39 avsingh 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_p2(t out nocopy okl_khr_pvt.khr_tbl_type, a0 JTF_NUMBER_TABLE
23 , a1 JTF_NUMBER_TABLE
24 , a2 JTF_NUMBER_TABLE
25 , a3 JTF_NUMBER_TABLE
26 , a4 JTF_NUMBER_TABLE
27 , a5 JTF_DATE_TABLE
28 , a6 JTF_VARCHAR2_TABLE_100
29 , a7 JTF_VARCHAR2_TABLE_100
30 , a8 JTF_DATE_TABLE
31 , a9 JTF_DATE_TABLE
32 , a10 JTF_DATE_TABLE
33 , a11 JTF_NUMBER_TABLE
34 , a12 JTF_DATE_TABLE
35 , a13 JTF_DATE_TABLE
36 , a14 JTF_DATE_TABLE
37 , a15 JTF_VARCHAR2_TABLE_100
38 , a16 JTF_VARCHAR2_TABLE_500
39 , a17 JTF_VARCHAR2_TABLE_500
40 , a18 JTF_VARCHAR2_TABLE_500
41 , a19 JTF_VARCHAR2_TABLE_500
42 , a20 JTF_VARCHAR2_TABLE_500
43 , a21 JTF_VARCHAR2_TABLE_500
44 , a22 JTF_VARCHAR2_TABLE_500
45 , a23 JTF_VARCHAR2_TABLE_500
46 , a24 JTF_VARCHAR2_TABLE_500
47 , a25 JTF_VARCHAR2_TABLE_500
48 , a26 JTF_VARCHAR2_TABLE_500
49 , a27 JTF_VARCHAR2_TABLE_500
50 , a28 JTF_VARCHAR2_TABLE_500
51 , a29 JTF_VARCHAR2_TABLE_500
52 , a30 JTF_VARCHAR2_TABLE_500
53 , a31 JTF_NUMBER_TABLE
54 , a32 JTF_DATE_TABLE
55 , a33 JTF_NUMBER_TABLE
56 , a34 JTF_DATE_TABLE
57 , a35 JTF_NUMBER_TABLE
58 , a36 JTF_VARCHAR2_TABLE_100
59 , a37 JTF_VARCHAR2_TABLE_100
60 , a38 JTF_VARCHAR2_TABLE_100
61 , a39 JTF_VARCHAR2_TABLE_100
62 , a40 JTF_VARCHAR2_TABLE_100
63 , a41 JTF_NUMBER_TABLE
64 , a42 JTF_NUMBER_TABLE
65 , a43 JTF_NUMBER_TABLE
66 , a44 JTF_NUMBER_TABLE
67 , a45 JTF_NUMBER_TABLE
68 , a46 JTF_NUMBER_TABLE
69 , a47 JTF_NUMBER_TABLE
70 , a48 JTF_NUMBER_TABLE
71 , a49 JTF_DATE_TABLE
72 , a50 JTF_VARCHAR2_TABLE_100
73 , a51 JTF_NUMBER_TABLE
74 , a52 JTF_NUMBER_TABLE
75 , a53 JTF_DATE_TABLE
76 , a54 JTF_DATE_TABLE
77 , a55 JTF_VARCHAR2_TABLE_100
78 , a56 JTF_VARCHAR2_TABLE_100
79 , a57 JTF_VARCHAR2_TABLE_100
80 , a58 JTF_NUMBER_TABLE
81 , a59 JTF_DATE_TABLE
82 , a60 JTF_VARCHAR2_TABLE_100
83 , a61 JTF_VARCHAR2_TABLE_100
84 , a62 JTF_VARCHAR2_TABLE_100
85 , a63 JTF_VARCHAR2_TABLE_100
86 , a64 JTF_VARCHAR2_TABLE_100
87 , a65 JTF_VARCHAR2_TABLE_100
88 ) as
89 ddindx binary_integer; indx binary_integer;
90 begin
91 if a0 is not null and a0.count > 0 then
92 if a0.count > 0 then
93 indx := a0.first;
94 ddindx := 1;
95 while true loop
96 t(ddindx).id := rosetta_g_miss_num_map(a0(indx));
97 t(ddindx).isg_id := rosetta_g_miss_num_map(a1(indx));
98 t(ddindx).khr_id := rosetta_g_miss_num_map(a2(indx));
99 t(ddindx).pdt_id := rosetta_g_miss_num_map(a3(indx));
100 t(ddindx).object_version_number := rosetta_g_miss_num_map(a4(indx));
101 t(ddindx).date_first_activity := rosetta_g_miss_date_in_map(a5(indx));
102 t(ddindx).syndicatable_yn := a6(indx);
103 t(ddindx).salestype_yn := a7(indx);
104 t(ddindx).date_refinanced := rosetta_g_miss_date_in_map(a8(indx));
105 t(ddindx).date_conversion_effective := rosetta_g_miss_date_in_map(a9(indx));
106 t(ddindx).date_deal_transferred := rosetta_g_miss_date_in_map(a10(indx));
107 t(ddindx).term_duration := rosetta_g_miss_num_map(a11(indx));
108 t(ddindx).datetime_proposal_effective := rosetta_g_miss_date_in_map(a12(indx));
109 t(ddindx).datetime_proposal_ineffective := rosetta_g_miss_date_in_map(a13(indx));
110 t(ddindx).date_proposal_accepted := rosetta_g_miss_date_in_map(a14(indx));
111 t(ddindx).attribute_category := a15(indx);
112 t(ddindx).attribute1 := a16(indx);
113 t(ddindx).attribute2 := a17(indx);
114 t(ddindx).attribute3 := a18(indx);
115 t(ddindx).attribute4 := a19(indx);
116 t(ddindx).attribute5 := a20(indx);
117 t(ddindx).attribute6 := a21(indx);
118 t(ddindx).attribute7 := a22(indx);
119 t(ddindx).attribute8 := a23(indx);
120 t(ddindx).attribute9 := a24(indx);
121 t(ddindx).attribute10 := a25(indx);
122 t(ddindx).attribute11 := a26(indx);
123 t(ddindx).attribute12 := a27(indx);
124 t(ddindx).attribute13 := a28(indx);
125 t(ddindx).attribute14 := a29(indx);
126 t(ddindx).attribute15 := a30(indx);
127 t(ddindx).created_by := rosetta_g_miss_num_map(a31(indx));
128 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a32(indx));
129 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a33(indx));
130 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a34(indx));
131 t(ddindx).last_update_login := rosetta_g_miss_num_map(a35(indx));
132 t(ddindx).amd_code := a36(indx);
133 t(ddindx).generate_accrual_yn := a37(indx);
134 t(ddindx).generate_accrual_override_yn := a38(indx);
135 t(ddindx).credit_act_yn := a39(indx);
136 t(ddindx).converted_account_yn := a40(indx);
137 t(ddindx).pre_tax_yield := rosetta_g_miss_num_map(a41(indx));
138 t(ddindx).after_tax_yield := rosetta_g_miss_num_map(a42(indx));
139 t(ddindx).implicit_interest_rate := rosetta_g_miss_num_map(a43(indx));
140 t(ddindx).implicit_non_idc_interest_rate := rosetta_g_miss_num_map(a44(indx));
141 t(ddindx).target_pre_tax_yield := rosetta_g_miss_num_map(a45(indx));
142 t(ddindx).target_after_tax_yield := rosetta_g_miss_num_map(a46(indx));
143 t(ddindx).target_implicit_interest_rate := rosetta_g_miss_num_map(a47(indx));
144 t(ddindx).target_implicit_nonidc_intrate := rosetta_g_miss_num_map(a48(indx));
145 t(ddindx).date_last_interim_interest_cal := rosetta_g_miss_date_in_map(a49(indx));
146 t(ddindx).deal_type := a50(indx);
147 t(ddindx).pre_tax_irr := rosetta_g_miss_num_map(a51(indx));
148 t(ddindx).after_tax_irr := rosetta_g_miss_num_map(a52(indx));
149 t(ddindx).expected_delivery_date := rosetta_g_miss_date_in_map(a53(indx));
150 t(ddindx).accepted_date := rosetta_g_miss_date_in_map(a54(indx));
151 t(ddindx).prefunding_eligible_yn := a55(indx);
152 t(ddindx).revolving_credit_yn := a56(indx);
153 t(ddindx).currency_conversion_type := a57(indx);
154 t(ddindx).currency_conversion_rate := rosetta_g_miss_num_map(a58(indx));
155 t(ddindx).currency_conversion_date := rosetta_g_miss_date_in_map(a59(indx));
156 t(ddindx).multi_gaap_yn := a60(indx);
157 t(ddindx).recourse_code := a61(indx);
158 t(ddindx).lessor_serv_org_code := a62(indx);
159 t(ddindx).assignable_yn := a63(indx);
160 t(ddindx).securitized_code := a64(indx);
161 t(ddindx).securitization_type := a65(indx);
162 ddindx := ddindx+1;
163 if a0.last =indx
164 then exit;
165 end if;
166 indx := a0.next(indx);
167 end loop;
168 end if;
169 end if;
170 end rosetta_table_copy_in_p2;
171 procedure rosetta_table_copy_out_p2(t okl_khr_pvt.khr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
172 , a1 out nocopy JTF_NUMBER_TABLE
173 , a2 out nocopy JTF_NUMBER_TABLE
174 , a3 out nocopy JTF_NUMBER_TABLE
175 , a4 out nocopy JTF_NUMBER_TABLE
176 , a5 out nocopy JTF_DATE_TABLE
177 , a6 out nocopy JTF_VARCHAR2_TABLE_100
178 , a7 out nocopy JTF_VARCHAR2_TABLE_100
179 , a8 out nocopy JTF_DATE_TABLE
180 , a9 out nocopy JTF_DATE_TABLE
181 , a10 out nocopy JTF_DATE_TABLE
182 , a11 out nocopy JTF_NUMBER_TABLE
183 , a12 out nocopy JTF_DATE_TABLE
184 , a13 out nocopy JTF_DATE_TABLE
185 , a14 out nocopy JTF_DATE_TABLE
186 , a15 out nocopy JTF_VARCHAR2_TABLE_100
187 , a16 out nocopy JTF_VARCHAR2_TABLE_500
188 , a17 out nocopy JTF_VARCHAR2_TABLE_500
189 , a18 out nocopy JTF_VARCHAR2_TABLE_500
190 , a19 out nocopy JTF_VARCHAR2_TABLE_500
191 , a20 out nocopy JTF_VARCHAR2_TABLE_500
192 , a21 out nocopy JTF_VARCHAR2_TABLE_500
193 , a22 out nocopy JTF_VARCHAR2_TABLE_500
194 , a23 out nocopy JTF_VARCHAR2_TABLE_500
195 , a24 out nocopy JTF_VARCHAR2_TABLE_500
196 , a25 out nocopy JTF_VARCHAR2_TABLE_500
197 , a26 out nocopy JTF_VARCHAR2_TABLE_500
198 , a27 out nocopy JTF_VARCHAR2_TABLE_500
199 , a28 out nocopy JTF_VARCHAR2_TABLE_500
200 , a29 out nocopy JTF_VARCHAR2_TABLE_500
201 , a30 out nocopy JTF_VARCHAR2_TABLE_500
202 , a31 out nocopy JTF_NUMBER_TABLE
203 , a32 out nocopy JTF_DATE_TABLE
204 , a33 out nocopy JTF_NUMBER_TABLE
205 , a34 out nocopy JTF_DATE_TABLE
206 , a35 out nocopy JTF_NUMBER_TABLE
207 , a36 out nocopy JTF_VARCHAR2_TABLE_100
208 , a37 out nocopy JTF_VARCHAR2_TABLE_100
209 , a38 out nocopy JTF_VARCHAR2_TABLE_100
210 , a39 out nocopy JTF_VARCHAR2_TABLE_100
211 , a40 out nocopy JTF_VARCHAR2_TABLE_100
212 , a41 out nocopy JTF_NUMBER_TABLE
213 , a42 out nocopy JTF_NUMBER_TABLE
214 , a43 out nocopy JTF_NUMBER_TABLE
215 , a44 out nocopy JTF_NUMBER_TABLE
216 , a45 out nocopy JTF_NUMBER_TABLE
217 , a46 out nocopy JTF_NUMBER_TABLE
218 , a47 out nocopy JTF_NUMBER_TABLE
219 , a48 out nocopy JTF_NUMBER_TABLE
220 , a49 out nocopy JTF_DATE_TABLE
221 , a50 out nocopy JTF_VARCHAR2_TABLE_100
222 , a51 out nocopy JTF_NUMBER_TABLE
223 , a52 out nocopy JTF_NUMBER_TABLE
224 , a53 out nocopy JTF_DATE_TABLE
225 , a54 out nocopy JTF_DATE_TABLE
226 , a55 out nocopy JTF_VARCHAR2_TABLE_100
227 , a56 out nocopy JTF_VARCHAR2_TABLE_100
228 , a57 out nocopy JTF_VARCHAR2_TABLE_100
229 , a58 out nocopy JTF_NUMBER_TABLE
230 , a59 out nocopy JTF_DATE_TABLE
231 , a60 out nocopy JTF_VARCHAR2_TABLE_100
232 , a61 out nocopy JTF_VARCHAR2_TABLE_100
233 , a62 out nocopy JTF_VARCHAR2_TABLE_100
234 , a63 out nocopy JTF_VARCHAR2_TABLE_100
235 , a64 out nocopy JTF_VARCHAR2_TABLE_100
236 , a65 out nocopy JTF_VARCHAR2_TABLE_100
237 ) as
238 ddindx binary_integer; indx binary_integer;
239 begin
240 if t is null or t.count = 0 then
241 a0 := JTF_NUMBER_TABLE();
242 a1 := JTF_NUMBER_TABLE();
243 a2 := JTF_NUMBER_TABLE();
244 a3 := JTF_NUMBER_TABLE();
245 a4 := JTF_NUMBER_TABLE();
246 a5 := JTF_DATE_TABLE();
247 a6 := JTF_VARCHAR2_TABLE_100();
248 a7 := JTF_VARCHAR2_TABLE_100();
249 a8 := JTF_DATE_TABLE();
250 a9 := JTF_DATE_TABLE();
251 a10 := JTF_DATE_TABLE();
252 a11 := JTF_NUMBER_TABLE();
253 a12 := JTF_DATE_TABLE();
254 a13 := JTF_DATE_TABLE();
255 a14 := JTF_DATE_TABLE();
256 a15 := JTF_VARCHAR2_TABLE_100();
257 a16 := JTF_VARCHAR2_TABLE_500();
258 a17 := JTF_VARCHAR2_TABLE_500();
259 a18 := JTF_VARCHAR2_TABLE_500();
260 a19 := JTF_VARCHAR2_TABLE_500();
261 a20 := JTF_VARCHAR2_TABLE_500();
262 a21 := JTF_VARCHAR2_TABLE_500();
263 a22 := JTF_VARCHAR2_TABLE_500();
264 a23 := JTF_VARCHAR2_TABLE_500();
265 a24 := JTF_VARCHAR2_TABLE_500();
266 a25 := JTF_VARCHAR2_TABLE_500();
267 a26 := JTF_VARCHAR2_TABLE_500();
268 a27 := JTF_VARCHAR2_TABLE_500();
269 a28 := JTF_VARCHAR2_TABLE_500();
270 a29 := JTF_VARCHAR2_TABLE_500();
271 a30 := JTF_VARCHAR2_TABLE_500();
272 a31 := JTF_NUMBER_TABLE();
273 a32 := JTF_DATE_TABLE();
274 a33 := JTF_NUMBER_TABLE();
275 a34 := JTF_DATE_TABLE();
276 a35 := JTF_NUMBER_TABLE();
277 a36 := JTF_VARCHAR2_TABLE_100();
278 a37 := JTF_VARCHAR2_TABLE_100();
279 a38 := JTF_VARCHAR2_TABLE_100();
280 a39 := JTF_VARCHAR2_TABLE_100();
281 a40 := JTF_VARCHAR2_TABLE_100();
282 a41 := JTF_NUMBER_TABLE();
283 a42 := JTF_NUMBER_TABLE();
284 a43 := JTF_NUMBER_TABLE();
285 a44 := JTF_NUMBER_TABLE();
286 a45 := JTF_NUMBER_TABLE();
287 a46 := JTF_NUMBER_TABLE();
288 a47 := JTF_NUMBER_TABLE();
289 a48 := JTF_NUMBER_TABLE();
290 a49 := JTF_DATE_TABLE();
291 a50 := JTF_VARCHAR2_TABLE_100();
292 a51 := JTF_NUMBER_TABLE();
293 a52 := JTF_NUMBER_TABLE();
294 a53 := JTF_DATE_TABLE();
295 a54 := JTF_DATE_TABLE();
296 a55 := JTF_VARCHAR2_TABLE_100();
297 a56 := JTF_VARCHAR2_TABLE_100();
298 a57 := JTF_VARCHAR2_TABLE_100();
299 a58 := JTF_NUMBER_TABLE();
300 a59 := JTF_DATE_TABLE();
301 a60 := JTF_VARCHAR2_TABLE_100();
302 a61 := JTF_VARCHAR2_TABLE_100();
303 a62 := JTF_VARCHAR2_TABLE_100();
304 a63 := JTF_VARCHAR2_TABLE_100();
305 a64 := JTF_VARCHAR2_TABLE_100();
306 a65 := JTF_VARCHAR2_TABLE_100();
307 else
308 a0 := JTF_NUMBER_TABLE();
309 a1 := JTF_NUMBER_TABLE();
310 a2 := JTF_NUMBER_TABLE();
311 a3 := JTF_NUMBER_TABLE();
312 a4 := JTF_NUMBER_TABLE();
313 a5 := JTF_DATE_TABLE();
314 a6 := JTF_VARCHAR2_TABLE_100();
315 a7 := JTF_VARCHAR2_TABLE_100();
316 a8 := JTF_DATE_TABLE();
317 a9 := JTF_DATE_TABLE();
318 a10 := JTF_DATE_TABLE();
319 a11 := JTF_NUMBER_TABLE();
320 a12 := JTF_DATE_TABLE();
321 a13 := JTF_DATE_TABLE();
322 a14 := JTF_DATE_TABLE();
323 a15 := JTF_VARCHAR2_TABLE_100();
324 a16 := JTF_VARCHAR2_TABLE_500();
325 a17 := JTF_VARCHAR2_TABLE_500();
326 a18 := JTF_VARCHAR2_TABLE_500();
327 a19 := JTF_VARCHAR2_TABLE_500();
328 a20 := JTF_VARCHAR2_TABLE_500();
329 a21 := JTF_VARCHAR2_TABLE_500();
330 a22 := JTF_VARCHAR2_TABLE_500();
331 a23 := JTF_VARCHAR2_TABLE_500();
332 a24 := JTF_VARCHAR2_TABLE_500();
333 a25 := JTF_VARCHAR2_TABLE_500();
334 a26 := JTF_VARCHAR2_TABLE_500();
335 a27 := JTF_VARCHAR2_TABLE_500();
336 a28 := JTF_VARCHAR2_TABLE_500();
337 a29 := JTF_VARCHAR2_TABLE_500();
338 a30 := JTF_VARCHAR2_TABLE_500();
339 a31 := JTF_NUMBER_TABLE();
340 a32 := JTF_DATE_TABLE();
341 a33 := JTF_NUMBER_TABLE();
342 a34 := JTF_DATE_TABLE();
343 a35 := JTF_NUMBER_TABLE();
344 a36 := JTF_VARCHAR2_TABLE_100();
345 a37 := JTF_VARCHAR2_TABLE_100();
346 a38 := JTF_VARCHAR2_TABLE_100();
347 a39 := JTF_VARCHAR2_TABLE_100();
348 a40 := JTF_VARCHAR2_TABLE_100();
349 a41 := JTF_NUMBER_TABLE();
350 a42 := JTF_NUMBER_TABLE();
351 a43 := JTF_NUMBER_TABLE();
352 a44 := JTF_NUMBER_TABLE();
353 a45 := JTF_NUMBER_TABLE();
354 a46 := JTF_NUMBER_TABLE();
355 a47 := JTF_NUMBER_TABLE();
356 a48 := JTF_NUMBER_TABLE();
357 a49 := JTF_DATE_TABLE();
358 a50 := JTF_VARCHAR2_TABLE_100();
359 a51 := JTF_NUMBER_TABLE();
360 a52 := JTF_NUMBER_TABLE();
361 a53 := JTF_DATE_TABLE();
362 a54 := JTF_DATE_TABLE();
363 a55 := JTF_VARCHAR2_TABLE_100();
364 a56 := JTF_VARCHAR2_TABLE_100();
365 a57 := JTF_VARCHAR2_TABLE_100();
366 a58 := JTF_NUMBER_TABLE();
367 a59 := JTF_DATE_TABLE();
368 a60 := JTF_VARCHAR2_TABLE_100();
369 a61 := JTF_VARCHAR2_TABLE_100();
370 a62 := JTF_VARCHAR2_TABLE_100();
371 a63 := JTF_VARCHAR2_TABLE_100();
372 a64 := JTF_VARCHAR2_TABLE_100();
373 a65 := JTF_VARCHAR2_TABLE_100();
374 if t.count > 0 then
375 a0.extend(t.count);
376 a1.extend(t.count);
377 a2.extend(t.count);
378 a3.extend(t.count);
379 a4.extend(t.count);
380 a5.extend(t.count);
381 a6.extend(t.count);
382 a7.extend(t.count);
383 a8.extend(t.count);
384 a9.extend(t.count);
385 a10.extend(t.count);
386 a11.extend(t.count);
387 a12.extend(t.count);
388 a13.extend(t.count);
389 a14.extend(t.count);
390 a15.extend(t.count);
391 a16.extend(t.count);
392 a17.extend(t.count);
393 a18.extend(t.count);
394 a19.extend(t.count);
395 a20.extend(t.count);
396 a21.extend(t.count);
397 a22.extend(t.count);
398 a23.extend(t.count);
399 a24.extend(t.count);
400 a25.extend(t.count);
401 a26.extend(t.count);
402 a27.extend(t.count);
403 a28.extend(t.count);
404 a29.extend(t.count);
405 a30.extend(t.count);
406 a31.extend(t.count);
407 a32.extend(t.count);
408 a33.extend(t.count);
409 a34.extend(t.count);
410 a35.extend(t.count);
411 a36.extend(t.count);
412 a37.extend(t.count);
413 a38.extend(t.count);
414 a39.extend(t.count);
415 a40.extend(t.count);
416 a41.extend(t.count);
417 a42.extend(t.count);
418 a43.extend(t.count);
419 a44.extend(t.count);
420 a45.extend(t.count);
421 a46.extend(t.count);
422 a47.extend(t.count);
423 a48.extend(t.count);
424 a49.extend(t.count);
425 a50.extend(t.count);
426 a51.extend(t.count);
427 a52.extend(t.count);
428 a53.extend(t.count);
429 a54.extend(t.count);
430 a55.extend(t.count);
431 a56.extend(t.count);
432 a57.extend(t.count);
433 a58.extend(t.count);
434 a59.extend(t.count);
435 a60.extend(t.count);
436 a61.extend(t.count);
437 a62.extend(t.count);
438 a63.extend(t.count);
439 a64.extend(t.count);
440 a65.extend(t.count);
441 ddindx := t.first;
442 indx := 1;
443 while true loop
444 a0(indx) := rosetta_g_miss_num_map(t(ddindx).id);
445 a1(indx) := rosetta_g_miss_num_map(t(ddindx).isg_id);
446 a2(indx) := rosetta_g_miss_num_map(t(ddindx).khr_id);
447 a3(indx) := rosetta_g_miss_num_map(t(ddindx).pdt_id);
448 a4(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
449 a5(indx) := t(ddindx).date_first_activity;
450 a6(indx) := t(ddindx).syndicatable_yn;
451 a7(indx) := t(ddindx).salestype_yn;
452 a8(indx) := t(ddindx).date_refinanced;
453 a9(indx) := t(ddindx).date_conversion_effective;
454 a10(indx) := t(ddindx).date_deal_transferred;
455 a11(indx) := rosetta_g_miss_num_map(t(ddindx).term_duration);
456 a12(indx) := t(ddindx).datetime_proposal_effective;
457 a13(indx) := t(ddindx).datetime_proposal_ineffective;
458 a14(indx) := t(ddindx).date_proposal_accepted;
459 a15(indx) := t(ddindx).attribute_category;
460 a16(indx) := t(ddindx).attribute1;
461 a17(indx) := t(ddindx).attribute2;
462 a18(indx) := t(ddindx).attribute3;
463 a19(indx) := t(ddindx).attribute4;
464 a20(indx) := t(ddindx).attribute5;
465 a21(indx) := t(ddindx).attribute6;
466 a22(indx) := t(ddindx).attribute7;
467 a23(indx) := t(ddindx).attribute8;
468 a24(indx) := t(ddindx).attribute9;
469 a25(indx) := t(ddindx).attribute10;
470 a26(indx) := t(ddindx).attribute11;
471 a27(indx) := t(ddindx).attribute12;
472 a28(indx) := t(ddindx).attribute13;
473 a29(indx) := t(ddindx).attribute14;
474 a30(indx) := t(ddindx).attribute15;
475 a31(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
476 a32(indx) := t(ddindx).creation_date;
477 a33(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
478 a34(indx) := t(ddindx).last_update_date;
479 a35(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
480 a36(indx) := t(ddindx).amd_code;
481 a37(indx) := t(ddindx).generate_accrual_yn;
482 a38(indx) := t(ddindx).generate_accrual_override_yn;
483 a39(indx) := t(ddindx).credit_act_yn;
484 a40(indx) := t(ddindx).converted_account_yn;
485 a41(indx) := rosetta_g_miss_num_map(t(ddindx).pre_tax_yield);
486 a42(indx) := rosetta_g_miss_num_map(t(ddindx).after_tax_yield);
487 a43(indx) := rosetta_g_miss_num_map(t(ddindx).implicit_interest_rate);
488 a44(indx) := rosetta_g_miss_num_map(t(ddindx).implicit_non_idc_interest_rate);
489 a45(indx) := rosetta_g_miss_num_map(t(ddindx).target_pre_tax_yield);
490 a46(indx) := rosetta_g_miss_num_map(t(ddindx).target_after_tax_yield);
491 a47(indx) := rosetta_g_miss_num_map(t(ddindx).target_implicit_interest_rate);
492 a48(indx) := rosetta_g_miss_num_map(t(ddindx).target_implicit_nonidc_intrate);
493 a49(indx) := t(ddindx).date_last_interim_interest_cal;
494 a50(indx) := t(ddindx).deal_type;
495 a51(indx) := rosetta_g_miss_num_map(t(ddindx).pre_tax_irr);
496 a52(indx) := rosetta_g_miss_num_map(t(ddindx).after_tax_irr);
497 a53(indx) := t(ddindx).expected_delivery_date;
498 a54(indx) := t(ddindx).accepted_date;
499 a55(indx) := t(ddindx).prefunding_eligible_yn;
500 a56(indx) := t(ddindx).revolving_credit_yn;
501 a57(indx) := t(ddindx).currency_conversion_type;
502 a58(indx) := rosetta_g_miss_num_map(t(ddindx).currency_conversion_rate);
503 a59(indx) := t(ddindx).currency_conversion_date;
504 a60(indx) := t(ddindx).multi_gaap_yn;
505 a61(indx) := t(ddindx).recourse_code;
506 a62(indx) := t(ddindx).lessor_serv_org_code;
507 a63(indx) := t(ddindx).assignable_yn;
508 a64(indx) := t(ddindx).securitized_code;
509 a65(indx) := t(ddindx).securitization_type;
510 indx := indx+1;
511 if t.last =ddindx
512 then exit;
513 end if;
514 ddindx := t.next(ddindx);
515 end loop;
516 end if;
517 end if;
518 end rosetta_table_copy_out_p2;
519
520 procedure rosetta_table_copy_in_p5(t out nocopy okl_khr_pvt.okl_k_headers_h_tbl_type, a0 JTF_NUMBER_TABLE
521 , a1 JTF_NUMBER_TABLE
522 , a2 JTF_NUMBER_TABLE
523 , a3 JTF_NUMBER_TABLE
524 , a4 JTF_NUMBER_TABLE
525 , a5 JTF_NUMBER_TABLE
526 , a6 JTF_DATE_TABLE
527 , a7 JTF_VARCHAR2_TABLE_100
528 , a8 JTF_VARCHAR2_TABLE_100
529 , a9 JTF_DATE_TABLE
530 , a10 JTF_DATE_TABLE
531 , a11 JTF_DATE_TABLE
532 , a12 JTF_NUMBER_TABLE
533 , a13 JTF_DATE_TABLE
534 , a14 JTF_DATE_TABLE
535 , a15 JTF_DATE_TABLE
536 , a16 JTF_VARCHAR2_TABLE_100
537 , a17 JTF_VARCHAR2_TABLE_500
538 , a18 JTF_VARCHAR2_TABLE_500
539 , a19 JTF_VARCHAR2_TABLE_500
540 , a20 JTF_VARCHAR2_TABLE_500
541 , a21 JTF_VARCHAR2_TABLE_500
542 , a22 JTF_VARCHAR2_TABLE_500
543 , a23 JTF_VARCHAR2_TABLE_500
544 , a24 JTF_VARCHAR2_TABLE_500
545 , a25 JTF_VARCHAR2_TABLE_500
546 , a26 JTF_VARCHAR2_TABLE_500
547 , a27 JTF_VARCHAR2_TABLE_500
548 , a28 JTF_VARCHAR2_TABLE_500
549 , a29 JTF_VARCHAR2_TABLE_500
550 , a30 JTF_VARCHAR2_TABLE_500
551 , a31 JTF_VARCHAR2_TABLE_500
552 , a32 JTF_NUMBER_TABLE
553 , a33 JTF_DATE_TABLE
554 , a34 JTF_NUMBER_TABLE
555 , a35 JTF_DATE_TABLE
556 , a36 JTF_NUMBER_TABLE
557 , a37 JTF_VARCHAR2_TABLE_100
558 , a38 JTF_VARCHAR2_TABLE_100
559 , a39 JTF_VARCHAR2_TABLE_100
560 , a40 JTF_VARCHAR2_TABLE_100
561 , a41 JTF_VARCHAR2_TABLE_100
562 , a42 JTF_NUMBER_TABLE
563 , a43 JTF_NUMBER_TABLE
564 , a44 JTF_NUMBER_TABLE
565 , a45 JTF_NUMBER_TABLE
566 , a46 JTF_NUMBER_TABLE
567 , a47 JTF_NUMBER_TABLE
568 , a48 JTF_NUMBER_TABLE
569 , a49 JTF_NUMBER_TABLE
570 , a50 JTF_DATE_TABLE
571 , a51 JTF_VARCHAR2_TABLE_100
572 , a52 JTF_NUMBER_TABLE
573 , a53 JTF_NUMBER_TABLE
574 , a54 JTF_DATE_TABLE
575 , a55 JTF_DATE_TABLE
576 , a56 JTF_VARCHAR2_TABLE_100
577 , a57 JTF_VARCHAR2_TABLE_100
578 , a58 JTF_VARCHAR2_TABLE_100
579 , a59 JTF_NUMBER_TABLE
580 , a60 JTF_DATE_TABLE
581 , a61 JTF_VARCHAR2_TABLE_100
582 , a62 JTF_VARCHAR2_TABLE_100
583 , a63 JTF_VARCHAR2_TABLE_100
584 , a64 JTF_VARCHAR2_TABLE_100
585 , a65 JTF_VARCHAR2_TABLE_100
586 , a66 JTF_VARCHAR2_TABLE_100
587 ) as
588 ddindx binary_integer; indx binary_integer;
589 begin
590 if a0 is not null and a0.count > 0 then
591 if a0.count > 0 then
592 indx := a0.first;
593 ddindx := 1;
594 while true loop
595 t(ddindx).id := rosetta_g_miss_num_map(a0(indx));
596 t(ddindx).major_version := rosetta_g_miss_num_map(a1(indx));
597 t(ddindx).isg_id := rosetta_g_miss_num_map(a2(indx));
598 t(ddindx).khr_id := rosetta_g_miss_num_map(a3(indx));
599 t(ddindx).pdt_id := rosetta_g_miss_num_map(a4(indx));
600 t(ddindx).object_version_number := rosetta_g_miss_num_map(a5(indx));
601 t(ddindx).date_first_activity := rosetta_g_miss_date_in_map(a6(indx));
602 t(ddindx).syndicatable_yn := a7(indx);
603 t(ddindx).salestype_yn := a8(indx);
604 t(ddindx).date_refinanced := rosetta_g_miss_date_in_map(a9(indx));
605 t(ddindx).date_conversion_effective := rosetta_g_miss_date_in_map(a10(indx));
606 t(ddindx).date_deal_transferred := rosetta_g_miss_date_in_map(a11(indx));
607 t(ddindx).term_duration := rosetta_g_miss_num_map(a12(indx));
608 t(ddindx).datetime_proposal_effective := rosetta_g_miss_date_in_map(a13(indx));
609 t(ddindx).datetime_proposal_ineffective := rosetta_g_miss_date_in_map(a14(indx));
610 t(ddindx).date_proposal_accepted := rosetta_g_miss_date_in_map(a15(indx));
611 t(ddindx).attribute_category := a16(indx);
612 t(ddindx).attribute1 := a17(indx);
613 t(ddindx).attribute2 := a18(indx);
614 t(ddindx).attribute3 := a19(indx);
615 t(ddindx).attribute4 := a20(indx);
616 t(ddindx).attribute5 := a21(indx);
617 t(ddindx).attribute6 := a22(indx);
618 t(ddindx).attribute7 := a23(indx);
619 t(ddindx).attribute8 := a24(indx);
620 t(ddindx).attribute9 := a25(indx);
621 t(ddindx).attribute10 := a26(indx);
622 t(ddindx).attribute11 := a27(indx);
623 t(ddindx).attribute12 := a28(indx);
624 t(ddindx).attribute13 := a29(indx);
625 t(ddindx).attribute14 := a30(indx);
626 t(ddindx).attribute15 := a31(indx);
627 t(ddindx).created_by := rosetta_g_miss_num_map(a32(indx));
628 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a33(indx));
629 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a34(indx));
630 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a35(indx));
631 t(ddindx).last_update_login := rosetta_g_miss_num_map(a36(indx));
632 t(ddindx).amd_code := a37(indx);
633 t(ddindx).generate_accrual_yn := a38(indx);
634 t(ddindx).generate_accrual_override_yn := a39(indx);
635 t(ddindx).credit_act_yn := a40(indx);
636 t(ddindx).converted_account_yn := a41(indx);
637 t(ddindx).pre_tax_yield := rosetta_g_miss_num_map(a42(indx));
638 t(ddindx).after_tax_yield := rosetta_g_miss_num_map(a43(indx));
639 t(ddindx).implicit_interest_rate := rosetta_g_miss_num_map(a44(indx));
640 t(ddindx).implicit_non_idc_interest_rate := rosetta_g_miss_num_map(a45(indx));
641 t(ddindx).target_pre_tax_yield := rosetta_g_miss_num_map(a46(indx));
642 t(ddindx).target_after_tax_yield := rosetta_g_miss_num_map(a47(indx));
643 t(ddindx).target_implicit_interest_rate := rosetta_g_miss_num_map(a48(indx));
644 t(ddindx).target_implicit_nonidc_intrate := rosetta_g_miss_num_map(a49(indx));
645 t(ddindx).date_last_interim_interest_cal := rosetta_g_miss_date_in_map(a50(indx));
646 t(ddindx).deal_type := a51(indx);
647 t(ddindx).pre_tax_irr := rosetta_g_miss_num_map(a52(indx));
648 t(ddindx).after_tax_irr := rosetta_g_miss_num_map(a53(indx));
649 t(ddindx).expected_delivery_date := rosetta_g_miss_date_in_map(a54(indx));
650 t(ddindx).accepted_date := rosetta_g_miss_date_in_map(a55(indx));
651 t(ddindx).prefunding_eligible_yn := a56(indx);
652 t(ddindx).revolving_credit_yn := a57(indx);
653 t(ddindx).currency_conversion_type := a58(indx);
654 t(ddindx).currency_conversion_rate := rosetta_g_miss_num_map(a59(indx));
655 t(ddindx).currency_conversion_date := rosetta_g_miss_date_in_map(a60(indx));
656 t(ddindx).multi_gaap_yn := a61(indx);
657 t(ddindx).recourse_code := a62(indx);
658 t(ddindx).lessor_serv_org_code := a63(indx);
659 t(ddindx).assignable_yn := a64(indx);
660 t(ddindx).securitized_code := a65(indx);
661 t(ddindx).securitization_type := a66(indx);
662 ddindx := ddindx+1;
663 if a0.last =indx
664 then exit;
665 end if;
666 indx := a0.next(indx);
667 end loop;
668 end if;
669 end if;
670 end rosetta_table_copy_in_p5;
671 procedure rosetta_table_copy_out_p5(t okl_khr_pvt.okl_k_headers_h_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
672 , a1 out nocopy JTF_NUMBER_TABLE
673 , a2 out nocopy JTF_NUMBER_TABLE
674 , a3 out nocopy JTF_NUMBER_TABLE
675 , a4 out nocopy JTF_NUMBER_TABLE
676 , a5 out nocopy JTF_NUMBER_TABLE
677 , a6 out nocopy JTF_DATE_TABLE
678 , a7 out nocopy JTF_VARCHAR2_TABLE_100
679 , a8 out nocopy JTF_VARCHAR2_TABLE_100
680 , a9 out nocopy JTF_DATE_TABLE
681 , a10 out nocopy JTF_DATE_TABLE
682 , a11 out nocopy JTF_DATE_TABLE
683 , a12 out nocopy JTF_NUMBER_TABLE
684 , a13 out nocopy JTF_DATE_TABLE
685 , a14 out nocopy JTF_DATE_TABLE
686 , a15 out nocopy JTF_DATE_TABLE
687 , a16 out nocopy JTF_VARCHAR2_TABLE_100
688 , a17 out nocopy JTF_VARCHAR2_TABLE_500
689 , a18 out nocopy JTF_VARCHAR2_TABLE_500
690 , a19 out nocopy JTF_VARCHAR2_TABLE_500
691 , a20 out nocopy JTF_VARCHAR2_TABLE_500
692 , a21 out nocopy JTF_VARCHAR2_TABLE_500
693 , a22 out nocopy JTF_VARCHAR2_TABLE_500
694 , a23 out nocopy JTF_VARCHAR2_TABLE_500
695 , a24 out nocopy JTF_VARCHAR2_TABLE_500
696 , a25 out nocopy JTF_VARCHAR2_TABLE_500
697 , a26 out nocopy JTF_VARCHAR2_TABLE_500
698 , a27 out nocopy JTF_VARCHAR2_TABLE_500
699 , a28 out nocopy JTF_VARCHAR2_TABLE_500
700 , a29 out nocopy JTF_VARCHAR2_TABLE_500
701 , a30 out nocopy JTF_VARCHAR2_TABLE_500
702 , a31 out nocopy JTF_VARCHAR2_TABLE_500
703 , a32 out nocopy JTF_NUMBER_TABLE
704 , a33 out nocopy JTF_DATE_TABLE
705 , a34 out nocopy JTF_NUMBER_TABLE
706 , a35 out nocopy JTF_DATE_TABLE
707 , a36 out nocopy JTF_NUMBER_TABLE
708 , a37 out nocopy JTF_VARCHAR2_TABLE_100
709 , a38 out nocopy JTF_VARCHAR2_TABLE_100
710 , a39 out nocopy JTF_VARCHAR2_TABLE_100
711 , a40 out nocopy JTF_VARCHAR2_TABLE_100
712 , a41 out nocopy JTF_VARCHAR2_TABLE_100
713 , a42 out nocopy JTF_NUMBER_TABLE
714 , a43 out nocopy JTF_NUMBER_TABLE
715 , a44 out nocopy JTF_NUMBER_TABLE
716 , a45 out nocopy JTF_NUMBER_TABLE
717 , a46 out nocopy JTF_NUMBER_TABLE
718 , a47 out nocopy JTF_NUMBER_TABLE
719 , a48 out nocopy JTF_NUMBER_TABLE
720 , a49 out nocopy JTF_NUMBER_TABLE
721 , a50 out nocopy JTF_DATE_TABLE
722 , a51 out nocopy JTF_VARCHAR2_TABLE_100
723 , a52 out nocopy JTF_NUMBER_TABLE
724 , a53 out nocopy JTF_NUMBER_TABLE
725 , a54 out nocopy JTF_DATE_TABLE
726 , a55 out nocopy JTF_DATE_TABLE
727 , a56 out nocopy JTF_VARCHAR2_TABLE_100
728 , a57 out nocopy JTF_VARCHAR2_TABLE_100
729 , a58 out nocopy JTF_VARCHAR2_TABLE_100
730 , a59 out nocopy JTF_NUMBER_TABLE
731 , a60 out nocopy JTF_DATE_TABLE
732 , a61 out nocopy JTF_VARCHAR2_TABLE_100
733 , a62 out nocopy JTF_VARCHAR2_TABLE_100
734 , a63 out nocopy JTF_VARCHAR2_TABLE_100
735 , a64 out nocopy JTF_VARCHAR2_TABLE_100
736 , a65 out nocopy JTF_VARCHAR2_TABLE_100
737 , a66 out nocopy JTF_VARCHAR2_TABLE_100
738 ) as
739 ddindx binary_integer; indx binary_integer;
740 begin
741 if t is null or t.count = 0 then
742 a0 := JTF_NUMBER_TABLE();
743 a1 := JTF_NUMBER_TABLE();
744 a2 := JTF_NUMBER_TABLE();
745 a3 := JTF_NUMBER_TABLE();
746 a4 := JTF_NUMBER_TABLE();
747 a5 := JTF_NUMBER_TABLE();
748 a6 := JTF_DATE_TABLE();
749 a7 := JTF_VARCHAR2_TABLE_100();
750 a8 := JTF_VARCHAR2_TABLE_100();
751 a9 := JTF_DATE_TABLE();
752 a10 := JTF_DATE_TABLE();
753 a11 := JTF_DATE_TABLE();
754 a12 := JTF_NUMBER_TABLE();
755 a13 := JTF_DATE_TABLE();
756 a14 := JTF_DATE_TABLE();
757 a15 := JTF_DATE_TABLE();
758 a16 := JTF_VARCHAR2_TABLE_100();
759 a17 := JTF_VARCHAR2_TABLE_500();
760 a18 := JTF_VARCHAR2_TABLE_500();
761 a19 := JTF_VARCHAR2_TABLE_500();
762 a20 := JTF_VARCHAR2_TABLE_500();
763 a21 := JTF_VARCHAR2_TABLE_500();
764 a22 := JTF_VARCHAR2_TABLE_500();
765 a23 := JTF_VARCHAR2_TABLE_500();
766 a24 := JTF_VARCHAR2_TABLE_500();
767 a25 := JTF_VARCHAR2_TABLE_500();
768 a26 := JTF_VARCHAR2_TABLE_500();
769 a27 := JTF_VARCHAR2_TABLE_500();
770 a28 := JTF_VARCHAR2_TABLE_500();
771 a29 := JTF_VARCHAR2_TABLE_500();
772 a30 := JTF_VARCHAR2_TABLE_500();
773 a31 := JTF_VARCHAR2_TABLE_500();
774 a32 := JTF_NUMBER_TABLE();
775 a33 := JTF_DATE_TABLE();
776 a34 := JTF_NUMBER_TABLE();
777 a35 := JTF_DATE_TABLE();
778 a36 := JTF_NUMBER_TABLE();
779 a37 := JTF_VARCHAR2_TABLE_100();
780 a38 := JTF_VARCHAR2_TABLE_100();
781 a39 := JTF_VARCHAR2_TABLE_100();
782 a40 := JTF_VARCHAR2_TABLE_100();
783 a41 := JTF_VARCHAR2_TABLE_100();
784 a42 := JTF_NUMBER_TABLE();
785 a43 := JTF_NUMBER_TABLE();
786 a44 := JTF_NUMBER_TABLE();
787 a45 := JTF_NUMBER_TABLE();
788 a46 := JTF_NUMBER_TABLE();
789 a47 := JTF_NUMBER_TABLE();
790 a48 := JTF_NUMBER_TABLE();
791 a49 := JTF_NUMBER_TABLE();
792 a50 := JTF_DATE_TABLE();
793 a51 := JTF_VARCHAR2_TABLE_100();
794 a52 := JTF_NUMBER_TABLE();
795 a53 := JTF_NUMBER_TABLE();
796 a54 := JTF_DATE_TABLE();
797 a55 := JTF_DATE_TABLE();
798 a56 := JTF_VARCHAR2_TABLE_100();
799 a57 := JTF_VARCHAR2_TABLE_100();
800 a58 := JTF_VARCHAR2_TABLE_100();
801 a59 := JTF_NUMBER_TABLE();
802 a60 := JTF_DATE_TABLE();
803 a61 := JTF_VARCHAR2_TABLE_100();
804 a62 := JTF_VARCHAR2_TABLE_100();
805 a63 := JTF_VARCHAR2_TABLE_100();
806 a64 := JTF_VARCHAR2_TABLE_100();
807 a65 := JTF_VARCHAR2_TABLE_100();
808 a66 := JTF_VARCHAR2_TABLE_100();
809 else
810 a0 := JTF_NUMBER_TABLE();
811 a1 := JTF_NUMBER_TABLE();
812 a2 := JTF_NUMBER_TABLE();
813 a3 := JTF_NUMBER_TABLE();
814 a4 := JTF_NUMBER_TABLE();
815 a5 := JTF_NUMBER_TABLE();
816 a6 := JTF_DATE_TABLE();
817 a7 := JTF_VARCHAR2_TABLE_100();
818 a8 := JTF_VARCHAR2_TABLE_100();
819 a9 := JTF_DATE_TABLE();
820 a10 := JTF_DATE_TABLE();
821 a11 := JTF_DATE_TABLE();
822 a12 := JTF_NUMBER_TABLE();
823 a13 := JTF_DATE_TABLE();
824 a14 := JTF_DATE_TABLE();
825 a15 := JTF_DATE_TABLE();
826 a16 := JTF_VARCHAR2_TABLE_100();
827 a17 := JTF_VARCHAR2_TABLE_500();
828 a18 := JTF_VARCHAR2_TABLE_500();
829 a19 := JTF_VARCHAR2_TABLE_500();
830 a20 := JTF_VARCHAR2_TABLE_500();
831 a21 := JTF_VARCHAR2_TABLE_500();
832 a22 := JTF_VARCHAR2_TABLE_500();
833 a23 := JTF_VARCHAR2_TABLE_500();
834 a24 := JTF_VARCHAR2_TABLE_500();
835 a25 := JTF_VARCHAR2_TABLE_500();
836 a26 := JTF_VARCHAR2_TABLE_500();
837 a27 := JTF_VARCHAR2_TABLE_500();
838 a28 := JTF_VARCHAR2_TABLE_500();
839 a29 := JTF_VARCHAR2_TABLE_500();
840 a30 := JTF_VARCHAR2_TABLE_500();
841 a31 := JTF_VARCHAR2_TABLE_500();
842 a32 := JTF_NUMBER_TABLE();
843 a33 := JTF_DATE_TABLE();
844 a34 := JTF_NUMBER_TABLE();
845 a35 := JTF_DATE_TABLE();
846 a36 := JTF_NUMBER_TABLE();
847 a37 := JTF_VARCHAR2_TABLE_100();
848 a38 := JTF_VARCHAR2_TABLE_100();
849 a39 := JTF_VARCHAR2_TABLE_100();
850 a40 := JTF_VARCHAR2_TABLE_100();
851 a41 := JTF_VARCHAR2_TABLE_100();
852 a42 := JTF_NUMBER_TABLE();
853 a43 := JTF_NUMBER_TABLE();
854 a44 := JTF_NUMBER_TABLE();
855 a45 := JTF_NUMBER_TABLE();
856 a46 := JTF_NUMBER_TABLE();
857 a47 := JTF_NUMBER_TABLE();
858 a48 := JTF_NUMBER_TABLE();
859 a49 := JTF_NUMBER_TABLE();
860 a50 := JTF_DATE_TABLE();
861 a51 := JTF_VARCHAR2_TABLE_100();
862 a52 := JTF_NUMBER_TABLE();
863 a53 := JTF_NUMBER_TABLE();
864 a54 := JTF_DATE_TABLE();
865 a55 := JTF_DATE_TABLE();
866 a56 := JTF_VARCHAR2_TABLE_100();
867 a57 := JTF_VARCHAR2_TABLE_100();
868 a58 := JTF_VARCHAR2_TABLE_100();
869 a59 := JTF_NUMBER_TABLE();
870 a60 := JTF_DATE_TABLE();
871 a61 := JTF_VARCHAR2_TABLE_100();
872 a62 := JTF_VARCHAR2_TABLE_100();
873 a63 := JTF_VARCHAR2_TABLE_100();
874 a64 := JTF_VARCHAR2_TABLE_100();
875 a65 := JTF_VARCHAR2_TABLE_100();
876 a66 := JTF_VARCHAR2_TABLE_100();
877 if t.count > 0 then
878 a0.extend(t.count);
879 a1.extend(t.count);
880 a2.extend(t.count);
881 a3.extend(t.count);
882 a4.extend(t.count);
883 a5.extend(t.count);
884 a6.extend(t.count);
885 a7.extend(t.count);
886 a8.extend(t.count);
887 a9.extend(t.count);
888 a10.extend(t.count);
889 a11.extend(t.count);
890 a12.extend(t.count);
891 a13.extend(t.count);
892 a14.extend(t.count);
893 a15.extend(t.count);
894 a16.extend(t.count);
895 a17.extend(t.count);
896 a18.extend(t.count);
897 a19.extend(t.count);
898 a20.extend(t.count);
899 a21.extend(t.count);
900 a22.extend(t.count);
901 a23.extend(t.count);
902 a24.extend(t.count);
903 a25.extend(t.count);
904 a26.extend(t.count);
905 a27.extend(t.count);
906 a28.extend(t.count);
907 a29.extend(t.count);
908 a30.extend(t.count);
909 a31.extend(t.count);
910 a32.extend(t.count);
911 a33.extend(t.count);
912 a34.extend(t.count);
913 a35.extend(t.count);
914 a36.extend(t.count);
915 a37.extend(t.count);
916 a38.extend(t.count);
917 a39.extend(t.count);
918 a40.extend(t.count);
919 a41.extend(t.count);
920 a42.extend(t.count);
921 a43.extend(t.count);
922 a44.extend(t.count);
923 a45.extend(t.count);
924 a46.extend(t.count);
925 a47.extend(t.count);
926 a48.extend(t.count);
927 a49.extend(t.count);
928 a50.extend(t.count);
929 a51.extend(t.count);
930 a52.extend(t.count);
931 a53.extend(t.count);
932 a54.extend(t.count);
933 a55.extend(t.count);
934 a56.extend(t.count);
935 a57.extend(t.count);
936 a58.extend(t.count);
937 a59.extend(t.count);
938 a60.extend(t.count);
939 a61.extend(t.count);
940 a62.extend(t.count);
941 a63.extend(t.count);
942 a64.extend(t.count);
943 a65.extend(t.count);
944 a66.extend(t.count);
945 ddindx := t.first;
946 indx := 1;
947 while true loop
948 a0(indx) := rosetta_g_miss_num_map(t(ddindx).id);
949 a1(indx) := rosetta_g_miss_num_map(t(ddindx).major_version);
950 a2(indx) := rosetta_g_miss_num_map(t(ddindx).isg_id);
951 a3(indx) := rosetta_g_miss_num_map(t(ddindx).khr_id);
952 a4(indx) := rosetta_g_miss_num_map(t(ddindx).pdt_id);
953 a5(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
954 a6(indx) := t(ddindx).date_first_activity;
955 a7(indx) := t(ddindx).syndicatable_yn;
956 a8(indx) := t(ddindx).salestype_yn;
957 a9(indx) := t(ddindx).date_refinanced;
958 a10(indx) := t(ddindx).date_conversion_effective;
959 a11(indx) := t(ddindx).date_deal_transferred;
960 a12(indx) := rosetta_g_miss_num_map(t(ddindx).term_duration);
961 a13(indx) := t(ddindx).datetime_proposal_effective;
962 a14(indx) := t(ddindx).datetime_proposal_ineffective;
963 a15(indx) := t(ddindx).date_proposal_accepted;
964 a16(indx) := t(ddindx).attribute_category;
965 a17(indx) := t(ddindx).attribute1;
966 a18(indx) := t(ddindx).attribute2;
967 a19(indx) := t(ddindx).attribute3;
968 a20(indx) := t(ddindx).attribute4;
969 a21(indx) := t(ddindx).attribute5;
970 a22(indx) := t(ddindx).attribute6;
971 a23(indx) := t(ddindx).attribute7;
972 a24(indx) := t(ddindx).attribute8;
973 a25(indx) := t(ddindx).attribute9;
974 a26(indx) := t(ddindx).attribute10;
975 a27(indx) := t(ddindx).attribute11;
976 a28(indx) := t(ddindx).attribute12;
977 a29(indx) := t(ddindx).attribute13;
978 a30(indx) := t(ddindx).attribute14;
979 a31(indx) := t(ddindx).attribute15;
980 a32(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
981 a33(indx) := t(ddindx).creation_date;
982 a34(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
983 a35(indx) := t(ddindx).last_update_date;
984 a36(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
985 a37(indx) := t(ddindx).amd_code;
986 a38(indx) := t(ddindx).generate_accrual_yn;
987 a39(indx) := t(ddindx).generate_accrual_override_yn;
988 a40(indx) := t(ddindx).credit_act_yn;
989 a41(indx) := t(ddindx).converted_account_yn;
990 a42(indx) := rosetta_g_miss_num_map(t(ddindx).pre_tax_yield);
991 a43(indx) := rosetta_g_miss_num_map(t(ddindx).after_tax_yield);
992 a44(indx) := rosetta_g_miss_num_map(t(ddindx).implicit_interest_rate);
993 a45(indx) := rosetta_g_miss_num_map(t(ddindx).implicit_non_idc_interest_rate);
994 a46(indx) := rosetta_g_miss_num_map(t(ddindx).target_pre_tax_yield);
995 a47(indx) := rosetta_g_miss_num_map(t(ddindx).target_after_tax_yield);
996 a48(indx) := rosetta_g_miss_num_map(t(ddindx).target_implicit_interest_rate);
997 a49(indx) := rosetta_g_miss_num_map(t(ddindx).target_implicit_nonidc_intrate);
998 a50(indx) := t(ddindx).date_last_interim_interest_cal;
999 a51(indx) := t(ddindx).deal_type;
1000 a52(indx) := rosetta_g_miss_num_map(t(ddindx).pre_tax_irr);
1001 a53(indx) := rosetta_g_miss_num_map(t(ddindx).after_tax_irr);
1002 a54(indx) := t(ddindx).expected_delivery_date;
1003 a55(indx) := t(ddindx).accepted_date;
1004 a56(indx) := t(ddindx).prefunding_eligible_yn;
1005 a57(indx) := t(ddindx).revolving_credit_yn;
1006 a58(indx) := t(ddindx).currency_conversion_type;
1007 a59(indx) := rosetta_g_miss_num_map(t(ddindx).currency_conversion_rate);
1008 a60(indx) := t(ddindx).currency_conversion_date;
1009 a61(indx) := t(ddindx).multi_gaap_yn;
1010 a62(indx) := t(ddindx).recourse_code;
1011 a63(indx) := t(ddindx).lessor_serv_org_code;
1012 a64(indx) := t(ddindx).assignable_yn;
1013 a65(indx) := t(ddindx).securitized_code;
1014 a66(indx) := t(ddindx).securitization_type;
1015 indx := indx+1;
1016 if t.last =ddindx
1017 then exit;
1018 end if;
1019 ddindx := t.next(ddindx);
1020 end loop;
1021 end if;
1022 end if;
1023 end rosetta_table_copy_out_p5;
1024
1025 procedure rosetta_table_copy_in_p8(t out nocopy okl_khr_pvt.khrv_tbl_type, a0 JTF_NUMBER_TABLE
1026 , a1 JTF_NUMBER_TABLE
1027 , a2 JTF_NUMBER_TABLE
1028 , a3 JTF_NUMBER_TABLE
1029 , a4 JTF_NUMBER_TABLE
1030 , a5 JTF_VARCHAR2_TABLE_100
1031 , a6 JTF_DATE_TABLE
1032 , a7 JTF_VARCHAR2_TABLE_100
1033 , a8 JTF_VARCHAR2_TABLE_100
1034 , a9 JTF_DATE_TABLE
1035 , a10 JTF_VARCHAR2_TABLE_100
1036 , a11 JTF_NUMBER_TABLE
1037 , a12 JTF_VARCHAR2_TABLE_100
1038 , a13 JTF_DATE_TABLE
1039 , a14 JTF_VARCHAR2_TABLE_100
1040 , a15 JTF_VARCHAR2_TABLE_100
1041 , a16 JTF_DATE_TABLE
1042 , a17 JTF_DATE_TABLE
1043 , a18 JTF_DATE_TABLE
1044 , a19 JTF_DATE_TABLE
1045 , a20 JTF_VARCHAR2_TABLE_100
1046 , a21 JTF_VARCHAR2_TABLE_500
1047 , a22 JTF_VARCHAR2_TABLE_500
1048 , a23 JTF_VARCHAR2_TABLE_500
1049 , a24 JTF_VARCHAR2_TABLE_500
1050 , a25 JTF_VARCHAR2_TABLE_500
1051 , a26 JTF_VARCHAR2_TABLE_500
1052 , a27 JTF_VARCHAR2_TABLE_500
1053 , a28 JTF_VARCHAR2_TABLE_500
1054 , a29 JTF_VARCHAR2_TABLE_500
1055 , a30 JTF_VARCHAR2_TABLE_500
1056 , a31 JTF_VARCHAR2_TABLE_500
1057 , a32 JTF_VARCHAR2_TABLE_500
1058 , a33 JTF_VARCHAR2_TABLE_500
1059 , a34 JTF_VARCHAR2_TABLE_500
1060 , a35 JTF_VARCHAR2_TABLE_500
1061 , a36 JTF_NUMBER_TABLE
1062 , a37 JTF_DATE_TABLE
1063 , a38 JTF_NUMBER_TABLE
1064 , a39 JTF_DATE_TABLE
1065 , a40 JTF_NUMBER_TABLE
1066 , a41 JTF_NUMBER_TABLE
1067 , a42 JTF_NUMBER_TABLE
1068 , a43 JTF_NUMBER_TABLE
1069 , a44 JTF_NUMBER_TABLE
1070 , a45 JTF_NUMBER_TABLE
1071 , a46 JTF_NUMBER_TABLE
1072 , a47 JTF_NUMBER_TABLE
1073 , a48 JTF_NUMBER_TABLE
1074 , a49 JTF_DATE_TABLE
1075 , a50 JTF_VARCHAR2_TABLE_100
1076 , a51 JTF_NUMBER_TABLE
1077 , a52 JTF_NUMBER_TABLE
1078 , a53 JTF_DATE_TABLE
1079 , a54 JTF_DATE_TABLE
1080 , a55 JTF_VARCHAR2_TABLE_100
1081 , a56 JTF_VARCHAR2_TABLE_100
1082 , a57 JTF_VARCHAR2_TABLE_100
1083 , a58 JTF_NUMBER_TABLE
1084 , a59 JTF_DATE_TABLE
1085 , a60 JTF_VARCHAR2_TABLE_100
1086 , a61 JTF_VARCHAR2_TABLE_100
1087 , a62 JTF_VARCHAR2_TABLE_100
1088 , a63 JTF_VARCHAR2_TABLE_100
1089 , a64 JTF_VARCHAR2_TABLE_100
1090 , a65 JTF_VARCHAR2_TABLE_100
1091 ) as
1092 ddindx binary_integer; indx binary_integer;
1093 begin
1094 if a0 is not null and a0.count > 0 then
1095 if a0.count > 0 then
1096 indx := a0.first;
1097 ddindx := 1;
1098 while true loop
1099 t(ddindx).id := rosetta_g_miss_num_map(a0(indx));
1100 t(ddindx).object_version_number := rosetta_g_miss_num_map(a1(indx));
1101 t(ddindx).isg_id := rosetta_g_miss_num_map(a2(indx));
1102 t(ddindx).khr_id := rosetta_g_miss_num_map(a3(indx));
1103 t(ddindx).pdt_id := rosetta_g_miss_num_map(a4(indx));
1104 t(ddindx).amd_code := a5(indx);
1105 t(ddindx).date_first_activity := rosetta_g_miss_date_in_map(a6(indx));
1106 t(ddindx).generate_accrual_yn := a7(indx);
1107 t(ddindx).generate_accrual_override_yn := a8(indx);
1108 t(ddindx).date_refinanced := rosetta_g_miss_date_in_map(a9(indx));
1109 t(ddindx).credit_act_yn := a10(indx);
1110 t(ddindx).term_duration := rosetta_g_miss_num_map(a11(indx));
1111 t(ddindx).converted_account_yn := a12(indx);
1112 t(ddindx).date_conversion_effective := rosetta_g_miss_date_in_map(a13(indx));
1113 t(ddindx).syndicatable_yn := a14(indx);
1114 t(ddindx).salestype_yn := a15(indx);
1115 t(ddindx).date_deal_transferred := rosetta_g_miss_date_in_map(a16(indx));
1116 t(ddindx).datetime_proposal_effective := rosetta_g_miss_date_in_map(a17(indx));
1117 t(ddindx).datetime_proposal_ineffective := rosetta_g_miss_date_in_map(a18(indx));
1118 t(ddindx).date_proposal_accepted := rosetta_g_miss_date_in_map(a19(indx));
1119 t(ddindx).attribute_category := a20(indx);
1120 t(ddindx).attribute1 := a21(indx);
1121 t(ddindx).attribute2 := a22(indx);
1122 t(ddindx).attribute3 := a23(indx);
1123 t(ddindx).attribute4 := a24(indx);
1124 t(ddindx).attribute5 := a25(indx);
1125 t(ddindx).attribute6 := a26(indx);
1126 t(ddindx).attribute7 := a27(indx);
1127 t(ddindx).attribute8 := a28(indx);
1128 t(ddindx).attribute9 := a29(indx);
1129 t(ddindx).attribute10 := a30(indx);
1130 t(ddindx).attribute11 := a31(indx);
1131 t(ddindx).attribute12 := a32(indx);
1132 t(ddindx).attribute13 := a33(indx);
1133 t(ddindx).attribute14 := a34(indx);
1134 t(ddindx).attribute15 := a35(indx);
1135 t(ddindx).created_by := rosetta_g_miss_num_map(a36(indx));
1136 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a37(indx));
1137 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a38(indx));
1138 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a39(indx));
1139 t(ddindx).last_update_login := rosetta_g_miss_num_map(a40(indx));
1140 t(ddindx).pre_tax_yield := rosetta_g_miss_num_map(a41(indx));
1141 t(ddindx).after_tax_yield := rosetta_g_miss_num_map(a42(indx));
1142 t(ddindx).implicit_interest_rate := rosetta_g_miss_num_map(a43(indx));
1143 t(ddindx).implicit_non_idc_interest_rate := rosetta_g_miss_num_map(a44(indx));
1144 t(ddindx).target_pre_tax_yield := rosetta_g_miss_num_map(a45(indx));
1145 t(ddindx).target_after_tax_yield := rosetta_g_miss_num_map(a46(indx));
1146 t(ddindx).target_implicit_interest_rate := rosetta_g_miss_num_map(a47(indx));
1147 t(ddindx).target_implicit_nonidc_intrate := rosetta_g_miss_num_map(a48(indx));
1148 t(ddindx).date_last_interim_interest_cal := rosetta_g_miss_date_in_map(a49(indx));
1149 t(ddindx).deal_type := a50(indx);
1150 t(ddindx).pre_tax_irr := rosetta_g_miss_num_map(a51(indx));
1151 t(ddindx).after_tax_irr := rosetta_g_miss_num_map(a52(indx));
1152 t(ddindx).expected_delivery_date := rosetta_g_miss_date_in_map(a53(indx));
1153 t(ddindx).accepted_date := rosetta_g_miss_date_in_map(a54(indx));
1154 t(ddindx).prefunding_eligible_yn := a55(indx);
1155 t(ddindx).revolving_credit_yn := a56(indx);
1156 t(ddindx).currency_conversion_type := a57(indx);
1157 t(ddindx).currency_conversion_rate := rosetta_g_miss_num_map(a58(indx));
1158 t(ddindx).currency_conversion_date := rosetta_g_miss_date_in_map(a59(indx));
1159 t(ddindx).multi_gaap_yn := a60(indx);
1160 t(ddindx).recourse_code := a61(indx);
1161 t(ddindx).lessor_serv_org_code := a62(indx);
1162 t(ddindx).assignable_yn := a63(indx);
1163 t(ddindx).securitized_code := a64(indx);
1164 t(ddindx).securitization_type := a65(indx);
1165 ddindx := ddindx+1;
1166 if a0.last =indx
1167 then exit;
1168 end if;
1169 indx := a0.next(indx);
1170 end loop;
1171 end if;
1172 end if;
1173 end rosetta_table_copy_in_p8;
1174 procedure rosetta_table_copy_out_p8(t okl_khr_pvt.khrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1175 , a1 out nocopy JTF_NUMBER_TABLE
1176 , a2 out nocopy JTF_NUMBER_TABLE
1177 , a3 out nocopy JTF_NUMBER_TABLE
1178 , a4 out nocopy JTF_NUMBER_TABLE
1179 , a5 out nocopy JTF_VARCHAR2_TABLE_100
1180 , a6 out nocopy JTF_DATE_TABLE
1181 , a7 out nocopy JTF_VARCHAR2_TABLE_100
1182 , a8 out nocopy JTF_VARCHAR2_TABLE_100
1183 , a9 out nocopy JTF_DATE_TABLE
1184 , a10 out nocopy JTF_VARCHAR2_TABLE_100
1185 , a11 out nocopy JTF_NUMBER_TABLE
1186 , a12 out nocopy JTF_VARCHAR2_TABLE_100
1187 , a13 out nocopy JTF_DATE_TABLE
1188 , a14 out nocopy JTF_VARCHAR2_TABLE_100
1189 , a15 out nocopy JTF_VARCHAR2_TABLE_100
1190 , a16 out nocopy JTF_DATE_TABLE
1191 , a17 out nocopy JTF_DATE_TABLE
1192 , a18 out nocopy JTF_DATE_TABLE
1193 , a19 out nocopy JTF_DATE_TABLE
1194 , a20 out nocopy JTF_VARCHAR2_TABLE_100
1195 , a21 out nocopy JTF_VARCHAR2_TABLE_500
1196 , a22 out nocopy JTF_VARCHAR2_TABLE_500
1197 , a23 out nocopy JTF_VARCHAR2_TABLE_500
1198 , a24 out nocopy JTF_VARCHAR2_TABLE_500
1199 , a25 out nocopy JTF_VARCHAR2_TABLE_500
1200 , a26 out nocopy JTF_VARCHAR2_TABLE_500
1201 , a27 out nocopy JTF_VARCHAR2_TABLE_500
1202 , a28 out nocopy JTF_VARCHAR2_TABLE_500
1203 , a29 out nocopy JTF_VARCHAR2_TABLE_500
1204 , a30 out nocopy JTF_VARCHAR2_TABLE_500
1205 , a31 out nocopy JTF_VARCHAR2_TABLE_500
1206 , a32 out nocopy JTF_VARCHAR2_TABLE_500
1207 , a33 out nocopy JTF_VARCHAR2_TABLE_500
1208 , a34 out nocopy JTF_VARCHAR2_TABLE_500
1209 , a35 out nocopy JTF_VARCHAR2_TABLE_500
1210 , a36 out nocopy JTF_NUMBER_TABLE
1211 , a37 out nocopy JTF_DATE_TABLE
1212 , a38 out nocopy JTF_NUMBER_TABLE
1213 , a39 out nocopy JTF_DATE_TABLE
1214 , a40 out nocopy JTF_NUMBER_TABLE
1215 , a41 out nocopy JTF_NUMBER_TABLE
1216 , a42 out nocopy JTF_NUMBER_TABLE
1217 , a43 out nocopy JTF_NUMBER_TABLE
1218 , a44 out nocopy JTF_NUMBER_TABLE
1219 , a45 out nocopy JTF_NUMBER_TABLE
1220 , a46 out nocopy JTF_NUMBER_TABLE
1221 , a47 out nocopy JTF_NUMBER_TABLE
1222 , a48 out nocopy JTF_NUMBER_TABLE
1223 , a49 out nocopy JTF_DATE_TABLE
1224 , a50 out nocopy JTF_VARCHAR2_TABLE_100
1225 , a51 out nocopy JTF_NUMBER_TABLE
1226 , a52 out nocopy JTF_NUMBER_TABLE
1227 , a53 out nocopy JTF_DATE_TABLE
1228 , a54 out nocopy JTF_DATE_TABLE
1229 , a55 out nocopy JTF_VARCHAR2_TABLE_100
1230 , a56 out nocopy JTF_VARCHAR2_TABLE_100
1231 , a57 out nocopy JTF_VARCHAR2_TABLE_100
1232 , a58 out nocopy JTF_NUMBER_TABLE
1233 , a59 out nocopy JTF_DATE_TABLE
1234 , a60 out nocopy JTF_VARCHAR2_TABLE_100
1235 , a61 out nocopy JTF_VARCHAR2_TABLE_100
1236 , a62 out nocopy JTF_VARCHAR2_TABLE_100
1237 , a63 out nocopy JTF_VARCHAR2_TABLE_100
1238 , a64 out nocopy JTF_VARCHAR2_TABLE_100
1239 , a65 out nocopy JTF_VARCHAR2_TABLE_100
1240 ) as
1241 ddindx binary_integer; indx binary_integer;
1242 begin
1243 if t is null or t.count = 0 then
1244 a0 := JTF_NUMBER_TABLE();
1245 a1 := JTF_NUMBER_TABLE();
1246 a2 := JTF_NUMBER_TABLE();
1247 a3 := JTF_NUMBER_TABLE();
1248 a4 := JTF_NUMBER_TABLE();
1249 a5 := JTF_VARCHAR2_TABLE_100();
1250 a6 := JTF_DATE_TABLE();
1251 a7 := JTF_VARCHAR2_TABLE_100();
1252 a8 := JTF_VARCHAR2_TABLE_100();
1253 a9 := JTF_DATE_TABLE();
1254 a10 := JTF_VARCHAR2_TABLE_100();
1255 a11 := JTF_NUMBER_TABLE();
1256 a12 := JTF_VARCHAR2_TABLE_100();
1257 a13 := JTF_DATE_TABLE();
1258 a14 := JTF_VARCHAR2_TABLE_100();
1259 a15 := JTF_VARCHAR2_TABLE_100();
1260 a16 := JTF_DATE_TABLE();
1261 a17 := JTF_DATE_TABLE();
1262 a18 := JTF_DATE_TABLE();
1263 a19 := JTF_DATE_TABLE();
1264 a20 := JTF_VARCHAR2_TABLE_100();
1265 a21 := JTF_VARCHAR2_TABLE_500();
1266 a22 := JTF_VARCHAR2_TABLE_500();
1267 a23 := JTF_VARCHAR2_TABLE_500();
1268 a24 := JTF_VARCHAR2_TABLE_500();
1269 a25 := JTF_VARCHAR2_TABLE_500();
1270 a26 := JTF_VARCHAR2_TABLE_500();
1271 a27 := JTF_VARCHAR2_TABLE_500();
1272 a28 := JTF_VARCHAR2_TABLE_500();
1273 a29 := JTF_VARCHAR2_TABLE_500();
1274 a30 := JTF_VARCHAR2_TABLE_500();
1275 a31 := JTF_VARCHAR2_TABLE_500();
1276 a32 := JTF_VARCHAR2_TABLE_500();
1277 a33 := JTF_VARCHAR2_TABLE_500();
1278 a34 := JTF_VARCHAR2_TABLE_500();
1279 a35 := JTF_VARCHAR2_TABLE_500();
1280 a36 := JTF_NUMBER_TABLE();
1281 a37 := JTF_DATE_TABLE();
1282 a38 := JTF_NUMBER_TABLE();
1283 a39 := JTF_DATE_TABLE();
1284 a40 := JTF_NUMBER_TABLE();
1285 a41 := JTF_NUMBER_TABLE();
1286 a42 := JTF_NUMBER_TABLE();
1287 a43 := JTF_NUMBER_TABLE();
1288 a44 := JTF_NUMBER_TABLE();
1289 a45 := JTF_NUMBER_TABLE();
1290 a46 := JTF_NUMBER_TABLE();
1291 a47 := JTF_NUMBER_TABLE();
1292 a48 := JTF_NUMBER_TABLE();
1293 a49 := JTF_DATE_TABLE();
1294 a50 := JTF_VARCHAR2_TABLE_100();
1295 a51 := JTF_NUMBER_TABLE();
1296 a52 := JTF_NUMBER_TABLE();
1297 a53 := JTF_DATE_TABLE();
1298 a54 := JTF_DATE_TABLE();
1299 a55 := JTF_VARCHAR2_TABLE_100();
1300 a56 := JTF_VARCHAR2_TABLE_100();
1301 a57 := JTF_VARCHAR2_TABLE_100();
1302 a58 := JTF_NUMBER_TABLE();
1303 a59 := JTF_DATE_TABLE();
1304 a60 := JTF_VARCHAR2_TABLE_100();
1305 a61 := JTF_VARCHAR2_TABLE_100();
1306 a62 := JTF_VARCHAR2_TABLE_100();
1307 a63 := JTF_VARCHAR2_TABLE_100();
1308 a64 := JTF_VARCHAR2_TABLE_100();
1309 a65 := JTF_VARCHAR2_TABLE_100();
1310 else
1311 a0 := JTF_NUMBER_TABLE();
1312 a1 := JTF_NUMBER_TABLE();
1313 a2 := JTF_NUMBER_TABLE();
1314 a3 := JTF_NUMBER_TABLE();
1315 a4 := JTF_NUMBER_TABLE();
1316 a5 := JTF_VARCHAR2_TABLE_100();
1317 a6 := JTF_DATE_TABLE();
1318 a7 := JTF_VARCHAR2_TABLE_100();
1319 a8 := JTF_VARCHAR2_TABLE_100();
1320 a9 := JTF_DATE_TABLE();
1321 a10 := JTF_VARCHAR2_TABLE_100();
1322 a11 := JTF_NUMBER_TABLE();
1323 a12 := JTF_VARCHAR2_TABLE_100();
1324 a13 := JTF_DATE_TABLE();
1325 a14 := JTF_VARCHAR2_TABLE_100();
1326 a15 := JTF_VARCHAR2_TABLE_100();
1327 a16 := JTF_DATE_TABLE();
1328 a17 := JTF_DATE_TABLE();
1329 a18 := JTF_DATE_TABLE();
1330 a19 := JTF_DATE_TABLE();
1331 a20 := JTF_VARCHAR2_TABLE_100();
1332 a21 := JTF_VARCHAR2_TABLE_500();
1333 a22 := JTF_VARCHAR2_TABLE_500();
1334 a23 := JTF_VARCHAR2_TABLE_500();
1335 a24 := JTF_VARCHAR2_TABLE_500();
1336 a25 := JTF_VARCHAR2_TABLE_500();
1337 a26 := JTF_VARCHAR2_TABLE_500();
1338 a27 := JTF_VARCHAR2_TABLE_500();
1339 a28 := JTF_VARCHAR2_TABLE_500();
1340 a29 := JTF_VARCHAR2_TABLE_500();
1341 a30 := JTF_VARCHAR2_TABLE_500();
1342 a31 := JTF_VARCHAR2_TABLE_500();
1343 a32 := JTF_VARCHAR2_TABLE_500();
1344 a33 := JTF_VARCHAR2_TABLE_500();
1345 a34 := JTF_VARCHAR2_TABLE_500();
1346 a35 := JTF_VARCHAR2_TABLE_500();
1347 a36 := JTF_NUMBER_TABLE();
1348 a37 := JTF_DATE_TABLE();
1349 a38 := JTF_NUMBER_TABLE();
1350 a39 := JTF_DATE_TABLE();
1351 a40 := JTF_NUMBER_TABLE();
1352 a41 := JTF_NUMBER_TABLE();
1353 a42 := JTF_NUMBER_TABLE();
1354 a43 := JTF_NUMBER_TABLE();
1355 a44 := JTF_NUMBER_TABLE();
1356 a45 := JTF_NUMBER_TABLE();
1357 a46 := JTF_NUMBER_TABLE();
1358 a47 := JTF_NUMBER_TABLE();
1359 a48 := JTF_NUMBER_TABLE();
1360 a49 := JTF_DATE_TABLE();
1361 a50 := JTF_VARCHAR2_TABLE_100();
1362 a51 := JTF_NUMBER_TABLE();
1363 a52 := JTF_NUMBER_TABLE();
1364 a53 := JTF_DATE_TABLE();
1365 a54 := JTF_DATE_TABLE();
1366 a55 := JTF_VARCHAR2_TABLE_100();
1367 a56 := JTF_VARCHAR2_TABLE_100();
1368 a57 := JTF_VARCHAR2_TABLE_100();
1369 a58 := JTF_NUMBER_TABLE();
1370 a59 := JTF_DATE_TABLE();
1371 a60 := JTF_VARCHAR2_TABLE_100();
1372 a61 := JTF_VARCHAR2_TABLE_100();
1373 a62 := JTF_VARCHAR2_TABLE_100();
1374 a63 := JTF_VARCHAR2_TABLE_100();
1375 a64 := JTF_VARCHAR2_TABLE_100();
1376 a65 := JTF_VARCHAR2_TABLE_100();
1377 if t.count > 0 then
1378 a0.extend(t.count);
1379 a1.extend(t.count);
1380 a2.extend(t.count);
1381 a3.extend(t.count);
1382 a4.extend(t.count);
1383 a5.extend(t.count);
1384 a6.extend(t.count);
1385 a7.extend(t.count);
1386 a8.extend(t.count);
1387 a9.extend(t.count);
1388 a10.extend(t.count);
1389 a11.extend(t.count);
1390 a12.extend(t.count);
1391 a13.extend(t.count);
1392 a14.extend(t.count);
1393 a15.extend(t.count);
1394 a16.extend(t.count);
1395 a17.extend(t.count);
1396 a18.extend(t.count);
1397 a19.extend(t.count);
1398 a20.extend(t.count);
1399 a21.extend(t.count);
1400 a22.extend(t.count);
1401 a23.extend(t.count);
1402 a24.extend(t.count);
1403 a25.extend(t.count);
1404 a26.extend(t.count);
1405 a27.extend(t.count);
1406 a28.extend(t.count);
1407 a29.extend(t.count);
1408 a30.extend(t.count);
1409 a31.extend(t.count);
1410 a32.extend(t.count);
1411 a33.extend(t.count);
1412 a34.extend(t.count);
1413 a35.extend(t.count);
1414 a36.extend(t.count);
1415 a37.extend(t.count);
1416 a38.extend(t.count);
1417 a39.extend(t.count);
1418 a40.extend(t.count);
1419 a41.extend(t.count);
1420 a42.extend(t.count);
1421 a43.extend(t.count);
1422 a44.extend(t.count);
1423 a45.extend(t.count);
1424 a46.extend(t.count);
1425 a47.extend(t.count);
1426 a48.extend(t.count);
1427 a49.extend(t.count);
1428 a50.extend(t.count);
1429 a51.extend(t.count);
1430 a52.extend(t.count);
1431 a53.extend(t.count);
1432 a54.extend(t.count);
1433 a55.extend(t.count);
1434 a56.extend(t.count);
1435 a57.extend(t.count);
1436 a58.extend(t.count);
1437 a59.extend(t.count);
1438 a60.extend(t.count);
1439 a61.extend(t.count);
1440 a62.extend(t.count);
1441 a63.extend(t.count);
1442 a64.extend(t.count);
1443 a65.extend(t.count);
1444 ddindx := t.first;
1445 indx := 1;
1446 while true loop
1447 a0(indx) := rosetta_g_miss_num_map(t(ddindx).id);
1448 a1(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
1449 a2(indx) := rosetta_g_miss_num_map(t(ddindx).isg_id);
1450 a3(indx) := rosetta_g_miss_num_map(t(ddindx).khr_id);
1451 a4(indx) := rosetta_g_miss_num_map(t(ddindx).pdt_id);
1452 a5(indx) := t(ddindx).amd_code;
1453 a6(indx) := t(ddindx).date_first_activity;
1454 a7(indx) := t(ddindx).generate_accrual_yn;
1455 a8(indx) := t(ddindx).generate_accrual_override_yn;
1456 a9(indx) := t(ddindx).date_refinanced;
1457 a10(indx) := t(ddindx).credit_act_yn;
1458 a11(indx) := rosetta_g_miss_num_map(t(ddindx).term_duration);
1459 a12(indx) := t(ddindx).converted_account_yn;
1460 a13(indx) := t(ddindx).date_conversion_effective;
1461 a14(indx) := t(ddindx).syndicatable_yn;
1462 a15(indx) := t(ddindx).salestype_yn;
1463 a16(indx) := t(ddindx).date_deal_transferred;
1464 a17(indx) := t(ddindx).datetime_proposal_effective;
1465 a18(indx) := t(ddindx).datetime_proposal_ineffective;
1466 a19(indx) := t(ddindx).date_proposal_accepted;
1467 a20(indx) := t(ddindx).attribute_category;
1468 a21(indx) := t(ddindx).attribute1;
1469 a22(indx) := t(ddindx).attribute2;
1470 a23(indx) := t(ddindx).attribute3;
1471 a24(indx) := t(ddindx).attribute4;
1472 a25(indx) := t(ddindx).attribute5;
1473 a26(indx) := t(ddindx).attribute6;
1474 a27(indx) := t(ddindx).attribute7;
1475 a28(indx) := t(ddindx).attribute8;
1476 a29(indx) := t(ddindx).attribute9;
1477 a30(indx) := t(ddindx).attribute10;
1478 a31(indx) := t(ddindx).attribute11;
1479 a32(indx) := t(ddindx).attribute12;
1480 a33(indx) := t(ddindx).attribute13;
1481 a34(indx) := t(ddindx).attribute14;
1482 a35(indx) := t(ddindx).attribute15;
1483 a36(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
1484 a37(indx) := t(ddindx).creation_date;
1485 a38(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
1486 a39(indx) := t(ddindx).last_update_date;
1487 a40(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
1488 a41(indx) := rosetta_g_miss_num_map(t(ddindx).pre_tax_yield);
1489 a42(indx) := rosetta_g_miss_num_map(t(ddindx).after_tax_yield);
1490 a43(indx) := rosetta_g_miss_num_map(t(ddindx).implicit_interest_rate);
1491 a44(indx) := rosetta_g_miss_num_map(t(ddindx).implicit_non_idc_interest_rate);
1492 a45(indx) := rosetta_g_miss_num_map(t(ddindx).target_pre_tax_yield);
1493 a46(indx) := rosetta_g_miss_num_map(t(ddindx).target_after_tax_yield);
1494 a47(indx) := rosetta_g_miss_num_map(t(ddindx).target_implicit_interest_rate);
1495 a48(indx) := rosetta_g_miss_num_map(t(ddindx).target_implicit_nonidc_intrate);
1496 a49(indx) := t(ddindx).date_last_interim_interest_cal;
1497 a50(indx) := t(ddindx).deal_type;
1498 a51(indx) := rosetta_g_miss_num_map(t(ddindx).pre_tax_irr);
1499 a52(indx) := rosetta_g_miss_num_map(t(ddindx).after_tax_irr);
1500 a53(indx) := t(ddindx).expected_delivery_date;
1501 a54(indx) := t(ddindx).accepted_date;
1502 a55(indx) := t(ddindx).prefunding_eligible_yn;
1503 a56(indx) := t(ddindx).revolving_credit_yn;
1504 a57(indx) := t(ddindx).currency_conversion_type;
1505 a58(indx) := rosetta_g_miss_num_map(t(ddindx).currency_conversion_rate);
1506 a59(indx) := t(ddindx).currency_conversion_date;
1507 a60(indx) := t(ddindx).multi_gaap_yn;
1508 a61(indx) := t(ddindx).recourse_code;
1509 a62(indx) := t(ddindx).lessor_serv_org_code;
1510 a63(indx) := t(ddindx).assignable_yn;
1511 a64(indx) := t(ddindx).securitized_code;
1512 a65(indx) := t(ddindx).securitization_type;
1513 indx := indx+1;
1514 if t.last =ddindx
1515 then exit;
1516 end if;
1517 ddindx := t.next(ddindx);
1518 end loop;
1519 end if;
1520 end if;
1521 end rosetta_table_copy_out_p8;
1522
1523 procedure insert_row(p_api_version NUMBER
1524 , p_init_msg_list VARCHAR2
1525 , x_return_status out nocopy VARCHAR2
1526 , x_msg_count out nocopy NUMBER
1527 , x_msg_data out nocopy VARCHAR2
1528 , p6_a0 out nocopy NUMBER
1529 , p6_a1 out nocopy NUMBER
1530 , p6_a2 out nocopy NUMBER
1531 , p6_a3 out nocopy NUMBER
1532 , p6_a4 out nocopy NUMBER
1533 , p6_a5 out nocopy VARCHAR2
1534 , p6_a6 out nocopy DATE
1535 , p6_a7 out nocopy VARCHAR2
1536 , p6_a8 out nocopy VARCHAR2
1537 , p6_a9 out nocopy DATE
1538 , p6_a10 out nocopy VARCHAR2
1539 , p6_a11 out nocopy NUMBER
1540 , p6_a12 out nocopy VARCHAR2
1541 , p6_a13 out nocopy DATE
1542 , p6_a14 out nocopy VARCHAR2
1543 , p6_a15 out nocopy VARCHAR2
1544 , p6_a16 out nocopy DATE
1545 , p6_a17 out nocopy DATE
1546 , p6_a18 out nocopy DATE
1547 , p6_a19 out nocopy DATE
1548 , p6_a20 out nocopy VARCHAR2
1549 , p6_a21 out nocopy VARCHAR2
1550 , p6_a22 out nocopy VARCHAR2
1551 , p6_a23 out nocopy VARCHAR2
1552 , p6_a24 out nocopy VARCHAR2
1553 , p6_a25 out nocopy VARCHAR2
1554 , p6_a26 out nocopy VARCHAR2
1555 , p6_a27 out nocopy VARCHAR2
1556 , p6_a28 out nocopy VARCHAR2
1557 , p6_a29 out nocopy VARCHAR2
1558 , p6_a30 out nocopy VARCHAR2
1559 , p6_a31 out nocopy VARCHAR2
1560 , p6_a32 out nocopy VARCHAR2
1561 , p6_a33 out nocopy VARCHAR2
1562 , p6_a34 out nocopy VARCHAR2
1563 , p6_a35 out nocopy VARCHAR2
1564 , p6_a36 out nocopy NUMBER
1565 , p6_a37 out nocopy DATE
1566 , p6_a38 out nocopy NUMBER
1567 , p6_a39 out nocopy DATE
1568 , p6_a40 out nocopy NUMBER
1569 , p6_a41 out nocopy NUMBER
1570 , p6_a42 out nocopy NUMBER
1571 , p6_a43 out nocopy NUMBER
1572 , p6_a44 out nocopy NUMBER
1573 , p6_a45 out nocopy NUMBER
1574 , p6_a46 out nocopy NUMBER
1575 , p6_a47 out nocopy NUMBER
1576 , p6_a48 out nocopy NUMBER
1577 , p6_a49 out nocopy DATE
1578 , p6_a50 out nocopy VARCHAR2
1579 , p6_a51 out nocopy NUMBER
1580 , p6_a52 out nocopy NUMBER
1581 , p6_a53 out nocopy DATE
1582 , p6_a54 out nocopy DATE
1583 , p6_a55 out nocopy VARCHAR2
1584 , p6_a56 out nocopy VARCHAR2
1585 , p6_a57 out nocopy VARCHAR2
1586 , p6_a58 out nocopy NUMBER
1587 , p6_a59 out nocopy DATE
1588 , p6_a60 out nocopy VARCHAR2
1589 , p6_a61 out nocopy VARCHAR2
1590 , p6_a62 out nocopy VARCHAR2
1591 , p6_a63 out nocopy VARCHAR2
1592 , p6_a64 out nocopy VARCHAR2
1593 , p6_a65 out nocopy VARCHAR2
1594 , p5_a0 NUMBER := 0-1962.0724
1595 , p5_a1 NUMBER := 0-1962.0724
1596 , p5_a2 NUMBER := 0-1962.0724
1597 , p5_a3 NUMBER := 0-1962.0724
1598 , p5_a4 NUMBER := 0-1962.0724
1599 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1600 , p5_a6 DATE := fnd_api.g_miss_date
1601 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1602 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1603 , p5_a9 DATE := fnd_api.g_miss_date
1604 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1605 , p5_a11 NUMBER := 0-1962.0724
1606 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1607 , p5_a13 DATE := fnd_api.g_miss_date
1608 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1609 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1610 , p5_a16 DATE := fnd_api.g_miss_date
1611 , p5_a17 DATE := fnd_api.g_miss_date
1612 , p5_a18 DATE := fnd_api.g_miss_date
1613 , p5_a19 DATE := fnd_api.g_miss_date
1614 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1615 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1616 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1617 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1618 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1619 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1620 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1621 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1622 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1623 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1624 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1625 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1626 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1627 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1628 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1629 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1630 , p5_a36 NUMBER := 0-1962.0724
1631 , p5_a37 DATE := fnd_api.g_miss_date
1632 , p5_a38 NUMBER := 0-1962.0724
1633 , p5_a39 DATE := fnd_api.g_miss_date
1634 , p5_a40 NUMBER := 0-1962.0724
1635 , p5_a41 NUMBER := 0-1962.0724
1636 , p5_a42 NUMBER := 0-1962.0724
1637 , p5_a43 NUMBER := 0-1962.0724
1638 , p5_a44 NUMBER := 0-1962.0724
1639 , p5_a45 NUMBER := 0-1962.0724
1640 , p5_a46 NUMBER := 0-1962.0724
1641 , p5_a47 NUMBER := 0-1962.0724
1642 , p5_a48 NUMBER := 0-1962.0724
1643 , p5_a49 DATE := fnd_api.g_miss_date
1644 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
1645 , p5_a51 NUMBER := 0-1962.0724
1646 , p5_a52 NUMBER := 0-1962.0724
1647 , p5_a53 DATE := fnd_api.g_miss_date
1648 , p5_a54 DATE := fnd_api.g_miss_date
1649 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
1650 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
1651 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
1652 , p5_a58 NUMBER := 0-1962.0724
1653 , p5_a59 DATE := fnd_api.g_miss_date
1654 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
1655 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
1656 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1657 , p5_a63 VARCHAR2 := fnd_api.g_miss_char
1658 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
1659 , p5_a65 VARCHAR2 := fnd_api.g_miss_char
1660 )
1661
1662 as
1663 ddp_khrv_rec okl_khr_pvt.khrv_rec_type;
1664 ddx_khrv_rec okl_khr_pvt.khrv_rec_type;
1665 ddindx binary_integer; indx binary_integer;
1666 begin
1667
1668 -- copy data to the local IN or IN-OUT args, if any
1669
1670
1671
1672
1673
1674 ddp_khrv_rec.id := rosetta_g_miss_num_map(p5_a0);
1675 ddp_khrv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1676 ddp_khrv_rec.isg_id := rosetta_g_miss_num_map(p5_a2);
1677 ddp_khrv_rec.khr_id := rosetta_g_miss_num_map(p5_a3);
1678 ddp_khrv_rec.pdt_id := rosetta_g_miss_num_map(p5_a4);
1679 ddp_khrv_rec.amd_code := p5_a5;
1680 ddp_khrv_rec.date_first_activity := rosetta_g_miss_date_in_map(p5_a6);
1681 ddp_khrv_rec.generate_accrual_yn := p5_a7;
1682 ddp_khrv_rec.generate_accrual_override_yn := p5_a8;
1683 ddp_khrv_rec.date_refinanced := rosetta_g_miss_date_in_map(p5_a9);
1684 ddp_khrv_rec.credit_act_yn := p5_a10;
1685 ddp_khrv_rec.term_duration := rosetta_g_miss_num_map(p5_a11);
1686 ddp_khrv_rec.converted_account_yn := p5_a12;
1687 ddp_khrv_rec.date_conversion_effective := rosetta_g_miss_date_in_map(p5_a13);
1688 ddp_khrv_rec.syndicatable_yn := p5_a14;
1689 ddp_khrv_rec.salestype_yn := p5_a15;
1690 ddp_khrv_rec.date_deal_transferred := rosetta_g_miss_date_in_map(p5_a16);
1691 ddp_khrv_rec.datetime_proposal_effective := rosetta_g_miss_date_in_map(p5_a17);
1692 ddp_khrv_rec.datetime_proposal_ineffective := rosetta_g_miss_date_in_map(p5_a18);
1693 ddp_khrv_rec.date_proposal_accepted := rosetta_g_miss_date_in_map(p5_a19);
1694 ddp_khrv_rec.attribute_category := p5_a20;
1695 ddp_khrv_rec.attribute1 := p5_a21;
1696 ddp_khrv_rec.attribute2 := p5_a22;
1697 ddp_khrv_rec.attribute3 := p5_a23;
1698 ddp_khrv_rec.attribute4 := p5_a24;
1699 ddp_khrv_rec.attribute5 := p5_a25;
1700 ddp_khrv_rec.attribute6 := p5_a26;
1701 ddp_khrv_rec.attribute7 := p5_a27;
1702 ddp_khrv_rec.attribute8 := p5_a28;
1703 ddp_khrv_rec.attribute9 := p5_a29;
1704 ddp_khrv_rec.attribute10 := p5_a30;
1705 ddp_khrv_rec.attribute11 := p5_a31;
1706 ddp_khrv_rec.attribute12 := p5_a32;
1707 ddp_khrv_rec.attribute13 := p5_a33;
1708 ddp_khrv_rec.attribute14 := p5_a34;
1709 ddp_khrv_rec.attribute15 := p5_a35;
1710 ddp_khrv_rec.created_by := rosetta_g_miss_num_map(p5_a36);
1711 ddp_khrv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a37);
1712 ddp_khrv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a38);
1713 ddp_khrv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a39);
1714 ddp_khrv_rec.last_update_login := rosetta_g_miss_num_map(p5_a40);
1715 ddp_khrv_rec.pre_tax_yield := rosetta_g_miss_num_map(p5_a41);
1716 ddp_khrv_rec.after_tax_yield := rosetta_g_miss_num_map(p5_a42);
1717 ddp_khrv_rec.implicit_interest_rate := rosetta_g_miss_num_map(p5_a43);
1718 ddp_khrv_rec.implicit_non_idc_interest_rate := rosetta_g_miss_num_map(p5_a44);
1719 ddp_khrv_rec.target_pre_tax_yield := rosetta_g_miss_num_map(p5_a45);
1720 ddp_khrv_rec.target_after_tax_yield := rosetta_g_miss_num_map(p5_a46);
1721 ddp_khrv_rec.target_implicit_interest_rate := rosetta_g_miss_num_map(p5_a47);
1722 ddp_khrv_rec.target_implicit_nonidc_intrate := rosetta_g_miss_num_map(p5_a48);
1723 ddp_khrv_rec.date_last_interim_interest_cal := rosetta_g_miss_date_in_map(p5_a49);
1724 ddp_khrv_rec.deal_type := p5_a50;
1725 ddp_khrv_rec.pre_tax_irr := rosetta_g_miss_num_map(p5_a51);
1726 ddp_khrv_rec.after_tax_irr := rosetta_g_miss_num_map(p5_a52);
1727 ddp_khrv_rec.expected_delivery_date := rosetta_g_miss_date_in_map(p5_a53);
1728 ddp_khrv_rec.accepted_date := rosetta_g_miss_date_in_map(p5_a54);
1729 ddp_khrv_rec.prefunding_eligible_yn := p5_a55;
1730 ddp_khrv_rec.revolving_credit_yn := p5_a56;
1731 ddp_khrv_rec.currency_conversion_type := p5_a57;
1732 ddp_khrv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a58);
1733 ddp_khrv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a59);
1734 ddp_khrv_rec.multi_gaap_yn := p5_a60;
1735 ddp_khrv_rec.recourse_code := p5_a61;
1736 ddp_khrv_rec.lessor_serv_org_code := p5_a62;
1737 ddp_khrv_rec.assignable_yn := p5_a63;
1738 ddp_khrv_rec.securitized_code := p5_a64;
1739 ddp_khrv_rec.securitization_type := p5_a65;
1740
1741
1742 -- here's the delegated call to the old PL/SQL routine
1743 okl_khr_pvt.insert_row(p_api_version,
1744 p_init_msg_list,
1745 x_return_status,
1746 x_msg_count,
1747 x_msg_data,
1748 ddp_khrv_rec,
1749 ddx_khrv_rec);
1750
1751 -- copy data back from the local variables to OUT or IN-OUT args, if any
1752
1753
1754
1755
1756
1757
1758 p6_a0 := rosetta_g_miss_num_map(ddx_khrv_rec.id);
1759 p6_a1 := rosetta_g_miss_num_map(ddx_khrv_rec.object_version_number);
1760 p6_a2 := rosetta_g_miss_num_map(ddx_khrv_rec.isg_id);
1761 p6_a3 := rosetta_g_miss_num_map(ddx_khrv_rec.khr_id);
1762 p6_a4 := rosetta_g_miss_num_map(ddx_khrv_rec.pdt_id);
1763 p6_a5 := ddx_khrv_rec.amd_code;
1764 p6_a6 := ddx_khrv_rec.date_first_activity;
1765 p6_a7 := ddx_khrv_rec.generate_accrual_yn;
1766 p6_a8 := ddx_khrv_rec.generate_accrual_override_yn;
1767 p6_a9 := ddx_khrv_rec.date_refinanced;
1768 p6_a10 := ddx_khrv_rec.credit_act_yn;
1769 p6_a11 := rosetta_g_miss_num_map(ddx_khrv_rec.term_duration);
1770 p6_a12 := ddx_khrv_rec.converted_account_yn;
1771 p6_a13 := ddx_khrv_rec.date_conversion_effective;
1772 p6_a14 := ddx_khrv_rec.syndicatable_yn;
1773 p6_a15 := ddx_khrv_rec.salestype_yn;
1774 p6_a16 := ddx_khrv_rec.date_deal_transferred;
1775 p6_a17 := ddx_khrv_rec.datetime_proposal_effective;
1776 p6_a18 := ddx_khrv_rec.datetime_proposal_ineffective;
1777 p6_a19 := ddx_khrv_rec.date_proposal_accepted;
1778 p6_a20 := ddx_khrv_rec.attribute_category;
1779 p6_a21 := ddx_khrv_rec.attribute1;
1780 p6_a22 := ddx_khrv_rec.attribute2;
1781 p6_a23 := ddx_khrv_rec.attribute3;
1782 p6_a24 := ddx_khrv_rec.attribute4;
1783 p6_a25 := ddx_khrv_rec.attribute5;
1784 p6_a26 := ddx_khrv_rec.attribute6;
1785 p6_a27 := ddx_khrv_rec.attribute7;
1786 p6_a28 := ddx_khrv_rec.attribute8;
1787 p6_a29 := ddx_khrv_rec.attribute9;
1788 p6_a30 := ddx_khrv_rec.attribute10;
1789 p6_a31 := ddx_khrv_rec.attribute11;
1790 p6_a32 := ddx_khrv_rec.attribute12;
1791 p6_a33 := ddx_khrv_rec.attribute13;
1792 p6_a34 := ddx_khrv_rec.attribute14;
1793 p6_a35 := ddx_khrv_rec.attribute15;
1794 p6_a36 := rosetta_g_miss_num_map(ddx_khrv_rec.created_by);
1795 p6_a37 := ddx_khrv_rec.creation_date;
1796 p6_a38 := rosetta_g_miss_num_map(ddx_khrv_rec.last_updated_by);
1797 p6_a39 := ddx_khrv_rec.last_update_date;
1798 p6_a40 := rosetta_g_miss_num_map(ddx_khrv_rec.last_update_login);
1799 p6_a41 := rosetta_g_miss_num_map(ddx_khrv_rec.pre_tax_yield);
1800 p6_a42 := rosetta_g_miss_num_map(ddx_khrv_rec.after_tax_yield);
1801 p6_a43 := rosetta_g_miss_num_map(ddx_khrv_rec.implicit_interest_rate);
1802 p6_a44 := rosetta_g_miss_num_map(ddx_khrv_rec.implicit_non_idc_interest_rate);
1803 p6_a45 := rosetta_g_miss_num_map(ddx_khrv_rec.target_pre_tax_yield);
1804 p6_a46 := rosetta_g_miss_num_map(ddx_khrv_rec.target_after_tax_yield);
1805 p6_a47 := rosetta_g_miss_num_map(ddx_khrv_rec.target_implicit_interest_rate);
1806 p6_a48 := rosetta_g_miss_num_map(ddx_khrv_rec.target_implicit_nonidc_intrate);
1807 p6_a49 := ddx_khrv_rec.date_last_interim_interest_cal;
1808 p6_a50 := ddx_khrv_rec.deal_type;
1809 p6_a51 := rosetta_g_miss_num_map(ddx_khrv_rec.pre_tax_irr);
1810 p6_a52 := rosetta_g_miss_num_map(ddx_khrv_rec.after_tax_irr);
1811 p6_a53 := ddx_khrv_rec.expected_delivery_date;
1812 p6_a54 := ddx_khrv_rec.accepted_date;
1813 p6_a55 := ddx_khrv_rec.prefunding_eligible_yn;
1814 p6_a56 := ddx_khrv_rec.revolving_credit_yn;
1815 p6_a57 := ddx_khrv_rec.currency_conversion_type;
1816 p6_a58 := rosetta_g_miss_num_map(ddx_khrv_rec.currency_conversion_rate);
1817 p6_a59 := ddx_khrv_rec.currency_conversion_date;
1818 p6_a60 := ddx_khrv_rec.multi_gaap_yn;
1819 p6_a61 := ddx_khrv_rec.recourse_code;
1820 p6_a62 := ddx_khrv_rec.lessor_serv_org_code;
1821 p6_a63 := ddx_khrv_rec.assignable_yn;
1822 p6_a64 := ddx_khrv_rec.securitized_code;
1823 p6_a65 := ddx_khrv_rec.securitization_type;
1824 end;
1825
1826 procedure insert_row(p_api_version NUMBER
1827 , p_init_msg_list VARCHAR2
1828 , x_return_status out nocopy VARCHAR2
1829 , x_msg_count out nocopy NUMBER
1830 , x_msg_data out nocopy VARCHAR2
1831 , p5_a0 JTF_NUMBER_TABLE
1832 , p5_a1 JTF_NUMBER_TABLE
1833 , p5_a2 JTF_NUMBER_TABLE
1834 , p5_a3 JTF_NUMBER_TABLE
1835 , p5_a4 JTF_NUMBER_TABLE
1836 , p5_a5 JTF_VARCHAR2_TABLE_100
1837 , p5_a6 JTF_DATE_TABLE
1838 , p5_a7 JTF_VARCHAR2_TABLE_100
1839 , p5_a8 JTF_VARCHAR2_TABLE_100
1840 , p5_a9 JTF_DATE_TABLE
1841 , p5_a10 JTF_VARCHAR2_TABLE_100
1842 , p5_a11 JTF_NUMBER_TABLE
1843 , p5_a12 JTF_VARCHAR2_TABLE_100
1844 , p5_a13 JTF_DATE_TABLE
1845 , p5_a14 JTF_VARCHAR2_TABLE_100
1846 , p5_a15 JTF_VARCHAR2_TABLE_100
1847 , p5_a16 JTF_DATE_TABLE
1848 , p5_a17 JTF_DATE_TABLE
1849 , p5_a18 JTF_DATE_TABLE
1850 , p5_a19 JTF_DATE_TABLE
1851 , p5_a20 JTF_VARCHAR2_TABLE_100
1852 , p5_a21 JTF_VARCHAR2_TABLE_500
1853 , p5_a22 JTF_VARCHAR2_TABLE_500
1854 , p5_a23 JTF_VARCHAR2_TABLE_500
1855 , p5_a24 JTF_VARCHAR2_TABLE_500
1856 , p5_a25 JTF_VARCHAR2_TABLE_500
1857 , p5_a26 JTF_VARCHAR2_TABLE_500
1858 , p5_a27 JTF_VARCHAR2_TABLE_500
1859 , p5_a28 JTF_VARCHAR2_TABLE_500
1860 , p5_a29 JTF_VARCHAR2_TABLE_500
1861 , p5_a30 JTF_VARCHAR2_TABLE_500
1862 , p5_a31 JTF_VARCHAR2_TABLE_500
1863 , p5_a32 JTF_VARCHAR2_TABLE_500
1864 , p5_a33 JTF_VARCHAR2_TABLE_500
1865 , p5_a34 JTF_VARCHAR2_TABLE_500
1866 , p5_a35 JTF_VARCHAR2_TABLE_500
1867 , p5_a36 JTF_NUMBER_TABLE
1868 , p5_a37 JTF_DATE_TABLE
1869 , p5_a38 JTF_NUMBER_TABLE
1870 , p5_a39 JTF_DATE_TABLE
1871 , p5_a40 JTF_NUMBER_TABLE
1872 , p5_a41 JTF_NUMBER_TABLE
1873 , p5_a42 JTF_NUMBER_TABLE
1874 , p5_a43 JTF_NUMBER_TABLE
1875 , p5_a44 JTF_NUMBER_TABLE
1876 , p5_a45 JTF_NUMBER_TABLE
1877 , p5_a46 JTF_NUMBER_TABLE
1878 , p5_a47 JTF_NUMBER_TABLE
1879 , p5_a48 JTF_NUMBER_TABLE
1880 , p5_a49 JTF_DATE_TABLE
1881 , p5_a50 JTF_VARCHAR2_TABLE_100
1882 , p5_a51 JTF_NUMBER_TABLE
1883 , p5_a52 JTF_NUMBER_TABLE
1884 , p5_a53 JTF_DATE_TABLE
1885 , p5_a54 JTF_DATE_TABLE
1886 , p5_a55 JTF_VARCHAR2_TABLE_100
1887 , p5_a56 JTF_VARCHAR2_TABLE_100
1888 , p5_a57 JTF_VARCHAR2_TABLE_100
1889 , p5_a58 JTF_NUMBER_TABLE
1890 , p5_a59 JTF_DATE_TABLE
1891 , p5_a60 JTF_VARCHAR2_TABLE_100
1892 , p5_a61 JTF_VARCHAR2_TABLE_100
1893 , p5_a62 JTF_VARCHAR2_TABLE_100
1894 , p5_a63 JTF_VARCHAR2_TABLE_100
1895 , p5_a64 JTF_VARCHAR2_TABLE_100
1896 , p5_a65 JTF_VARCHAR2_TABLE_100
1897 , p6_a0 out nocopy JTF_NUMBER_TABLE
1898 , p6_a1 out nocopy JTF_NUMBER_TABLE
1899 , p6_a2 out nocopy JTF_NUMBER_TABLE
1900 , p6_a3 out nocopy JTF_NUMBER_TABLE
1901 , p6_a4 out nocopy JTF_NUMBER_TABLE
1902 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1903 , p6_a6 out nocopy JTF_DATE_TABLE
1904 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1905 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1906 , p6_a9 out nocopy JTF_DATE_TABLE
1907 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1908 , p6_a11 out nocopy JTF_NUMBER_TABLE
1909 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1910 , p6_a13 out nocopy JTF_DATE_TABLE
1911 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1912 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1913 , p6_a16 out nocopy JTF_DATE_TABLE
1914 , p6_a17 out nocopy JTF_DATE_TABLE
1915 , p6_a18 out nocopy JTF_DATE_TABLE
1916 , p6_a19 out nocopy JTF_DATE_TABLE
1917 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1918 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1919 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1920 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1921 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1922 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1923 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1924 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1925 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1926 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
1927 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
1928 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
1929 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1930 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1931 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
1932 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
1933 , p6_a36 out nocopy JTF_NUMBER_TABLE
1934 , p6_a37 out nocopy JTF_DATE_TABLE
1935 , p6_a38 out nocopy JTF_NUMBER_TABLE
1936 , p6_a39 out nocopy JTF_DATE_TABLE
1937 , p6_a40 out nocopy JTF_NUMBER_TABLE
1938 , p6_a41 out nocopy JTF_NUMBER_TABLE
1939 , p6_a42 out nocopy JTF_NUMBER_TABLE
1940 , p6_a43 out nocopy JTF_NUMBER_TABLE
1941 , p6_a44 out nocopy JTF_NUMBER_TABLE
1942 , p6_a45 out nocopy JTF_NUMBER_TABLE
1943 , p6_a46 out nocopy JTF_NUMBER_TABLE
1944 , p6_a47 out nocopy JTF_NUMBER_TABLE
1945 , p6_a48 out nocopy JTF_NUMBER_TABLE
1946 , p6_a49 out nocopy JTF_DATE_TABLE
1947 , p6_a50 out nocopy JTF_VARCHAR2_TABLE_100
1948 , p6_a51 out nocopy JTF_NUMBER_TABLE
1949 , p6_a52 out nocopy JTF_NUMBER_TABLE
1950 , p6_a53 out nocopy JTF_DATE_TABLE
1951 , p6_a54 out nocopy JTF_DATE_TABLE
1952 , p6_a55 out nocopy JTF_VARCHAR2_TABLE_100
1953 , p6_a56 out nocopy JTF_VARCHAR2_TABLE_100
1954 , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100
1955 , p6_a58 out nocopy JTF_NUMBER_TABLE
1956 , p6_a59 out nocopy JTF_DATE_TABLE
1957 , p6_a60 out nocopy JTF_VARCHAR2_TABLE_100
1958 , p6_a61 out nocopy JTF_VARCHAR2_TABLE_100
1959 , p6_a62 out nocopy JTF_VARCHAR2_TABLE_100
1960 , p6_a63 out nocopy JTF_VARCHAR2_TABLE_100
1961 , p6_a64 out nocopy JTF_VARCHAR2_TABLE_100
1962 , p6_a65 out nocopy JTF_VARCHAR2_TABLE_100
1963 )
1964
1965 as
1966 ddp_khrv_tbl okl_khr_pvt.khrv_tbl_type;
1967 ddx_khrv_tbl okl_khr_pvt.khrv_tbl_type;
1968 ddindx binary_integer; indx binary_integer;
1969 begin
1970
1971 -- copy data to the local IN or IN-OUT args, if any
1972
1973
1974
1975
1976
1977 okl_khr_pvt_w.rosetta_table_copy_in_p8(ddp_khrv_tbl, p5_a0
1978 , p5_a1
1979 , p5_a2
1980 , p5_a3
1981 , p5_a4
1982 , p5_a5
1983 , p5_a6
1984 , p5_a7
1985 , p5_a8
1986 , p5_a9
1987 , p5_a10
1988 , p5_a11
1989 , p5_a12
1990 , p5_a13
1991 , p5_a14
1992 , p5_a15
1993 , p5_a16
1994 , p5_a17
1995 , p5_a18
1996 , p5_a19
1997 , p5_a20
1998 , p5_a21
1999 , p5_a22
2000 , p5_a23
2001 , p5_a24
2002 , p5_a25
2003 , p5_a26
2004 , p5_a27
2005 , p5_a28
2006 , p5_a29
2007 , p5_a30
2008 , p5_a31
2009 , p5_a32
2010 , p5_a33
2011 , p5_a34
2012 , p5_a35
2013 , p5_a36
2014 , p5_a37
2015 , p5_a38
2016 , p5_a39
2017 , p5_a40
2018 , p5_a41
2019 , p5_a42
2020 , p5_a43
2021 , p5_a44
2022 , p5_a45
2023 , p5_a46
2024 , p5_a47
2025 , p5_a48
2026 , p5_a49
2027 , p5_a50
2028 , p5_a51
2029 , p5_a52
2030 , p5_a53
2031 , p5_a54
2032 , p5_a55
2033 , p5_a56
2034 , p5_a57
2035 , p5_a58
2036 , p5_a59
2037 , p5_a60
2038 , p5_a61
2039 , p5_a62
2040 , p5_a63
2041 , p5_a64
2042 , p5_a65
2043 );
2044
2045
2046 -- here's the delegated call to the old PL/SQL routine
2047 okl_khr_pvt.insert_row(p_api_version,
2048 p_init_msg_list,
2049 x_return_status,
2050 x_msg_count,
2051 x_msg_data,
2052 ddp_khrv_tbl,
2053 ddx_khrv_tbl);
2054
2055 -- copy data back from the local variables to OUT or IN-OUT args, if any
2056
2057
2058
2059
2060
2061
2062 okl_khr_pvt_w.rosetta_table_copy_out_p8(ddx_khrv_tbl, p6_a0
2063 , p6_a1
2064 , p6_a2
2065 , p6_a3
2066 , p6_a4
2067 , p6_a5
2068 , p6_a6
2069 , p6_a7
2070 , p6_a8
2071 , p6_a9
2072 , p6_a10
2073 , p6_a11
2074 , p6_a12
2075 , p6_a13
2076 , p6_a14
2077 , p6_a15
2078 , p6_a16
2079 , p6_a17
2080 , p6_a18
2081 , p6_a19
2082 , p6_a20
2083 , p6_a21
2084 , p6_a22
2085 , p6_a23
2086 , p6_a24
2087 , p6_a25
2088 , p6_a26
2089 , p6_a27
2090 , p6_a28
2091 , p6_a29
2092 , p6_a30
2093 , p6_a31
2094 , p6_a32
2095 , p6_a33
2096 , p6_a34
2097 , p6_a35
2098 , p6_a36
2099 , p6_a37
2100 , p6_a38
2101 , p6_a39
2102 , p6_a40
2103 , p6_a41
2104 , p6_a42
2105 , p6_a43
2106 , p6_a44
2107 , p6_a45
2108 , p6_a46
2109 , p6_a47
2110 , p6_a48
2111 , p6_a49
2112 , p6_a50
2113 , p6_a51
2114 , p6_a52
2115 , p6_a53
2116 , p6_a54
2117 , p6_a55
2118 , p6_a56
2119 , p6_a57
2120 , p6_a58
2121 , p6_a59
2122 , p6_a60
2123 , p6_a61
2124 , p6_a62
2125 , p6_a63
2126 , p6_a64
2127 , p6_a65
2128 );
2129 end;
2130
2131 procedure update_row(p_api_version NUMBER
2132 , p_init_msg_list VARCHAR2
2133 , x_return_status out nocopy VARCHAR2
2134 , x_msg_count out nocopy NUMBER
2135 , x_msg_data out nocopy VARCHAR2
2136 , p6_a0 out nocopy NUMBER
2137 , p6_a1 out nocopy NUMBER
2138 , p6_a2 out nocopy NUMBER
2139 , p6_a3 out nocopy NUMBER
2140 , p6_a4 out nocopy NUMBER
2141 , p6_a5 out nocopy VARCHAR2
2142 , p6_a6 out nocopy DATE
2143 , p6_a7 out nocopy VARCHAR2
2144 , p6_a8 out nocopy VARCHAR2
2145 , p6_a9 out nocopy DATE
2146 , p6_a10 out nocopy VARCHAR2
2147 , p6_a11 out nocopy NUMBER
2148 , p6_a12 out nocopy VARCHAR2
2149 , p6_a13 out nocopy DATE
2150 , p6_a14 out nocopy VARCHAR2
2151 , p6_a15 out nocopy VARCHAR2
2152 , p6_a16 out nocopy DATE
2153 , p6_a17 out nocopy DATE
2154 , p6_a18 out nocopy DATE
2155 , p6_a19 out nocopy DATE
2156 , p6_a20 out nocopy VARCHAR2
2157 , p6_a21 out nocopy VARCHAR2
2158 , p6_a22 out nocopy VARCHAR2
2159 , p6_a23 out nocopy VARCHAR2
2160 , p6_a24 out nocopy VARCHAR2
2161 , p6_a25 out nocopy VARCHAR2
2162 , p6_a26 out nocopy VARCHAR2
2163 , p6_a27 out nocopy VARCHAR2
2164 , p6_a28 out nocopy VARCHAR2
2165 , p6_a29 out nocopy VARCHAR2
2166 , p6_a30 out nocopy VARCHAR2
2167 , p6_a31 out nocopy VARCHAR2
2168 , p6_a32 out nocopy VARCHAR2
2169 , p6_a33 out nocopy VARCHAR2
2170 , p6_a34 out nocopy VARCHAR2
2171 , p6_a35 out nocopy VARCHAR2
2172 , p6_a36 out nocopy NUMBER
2173 , p6_a37 out nocopy DATE
2174 , p6_a38 out nocopy NUMBER
2175 , p6_a39 out nocopy DATE
2176 , p6_a40 out nocopy NUMBER
2177 , p6_a41 out nocopy NUMBER
2178 , p6_a42 out nocopy NUMBER
2179 , p6_a43 out nocopy NUMBER
2180 , p6_a44 out nocopy NUMBER
2181 , p6_a45 out nocopy NUMBER
2182 , p6_a46 out nocopy NUMBER
2183 , p6_a47 out nocopy NUMBER
2184 , p6_a48 out nocopy NUMBER
2185 , p6_a49 out nocopy DATE
2186 , p6_a50 out nocopy VARCHAR2
2187 , p6_a51 out nocopy NUMBER
2188 , p6_a52 out nocopy NUMBER
2189 , p6_a53 out nocopy DATE
2190 , p6_a54 out nocopy DATE
2191 , p6_a55 out nocopy VARCHAR2
2192 , p6_a56 out nocopy VARCHAR2
2193 , p6_a57 out nocopy VARCHAR2
2194 , p6_a58 out nocopy NUMBER
2195 , p6_a59 out nocopy DATE
2196 , p6_a60 out nocopy VARCHAR2
2197 , p6_a61 out nocopy VARCHAR2
2198 , p6_a62 out nocopy VARCHAR2
2199 , p6_a63 out nocopy VARCHAR2
2200 , p6_a64 out nocopy VARCHAR2
2201 , p6_a65 out nocopy VARCHAR2
2202 , p5_a0 NUMBER := 0-1962.0724
2203 , p5_a1 NUMBER := 0-1962.0724
2204 , p5_a2 NUMBER := 0-1962.0724
2205 , p5_a3 NUMBER := 0-1962.0724
2206 , p5_a4 NUMBER := 0-1962.0724
2207 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2208 , p5_a6 DATE := fnd_api.g_miss_date
2209 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2210 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2211 , p5_a9 DATE := fnd_api.g_miss_date
2212 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2213 , p5_a11 NUMBER := 0-1962.0724
2214 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2215 , p5_a13 DATE := fnd_api.g_miss_date
2216 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2217 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2218 , p5_a16 DATE := fnd_api.g_miss_date
2219 , p5_a17 DATE := fnd_api.g_miss_date
2220 , p5_a18 DATE := fnd_api.g_miss_date
2221 , p5_a19 DATE := fnd_api.g_miss_date
2222 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2223 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2224 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2225 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2226 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2227 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2228 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2229 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2230 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2231 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2232 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2233 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2234 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2235 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2236 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2237 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2238 , p5_a36 NUMBER := 0-1962.0724
2239 , p5_a37 DATE := fnd_api.g_miss_date
2240 , p5_a38 NUMBER := 0-1962.0724
2241 , p5_a39 DATE := fnd_api.g_miss_date
2242 , p5_a40 NUMBER := 0-1962.0724
2243 , p5_a41 NUMBER := 0-1962.0724
2244 , p5_a42 NUMBER := 0-1962.0724
2245 , p5_a43 NUMBER := 0-1962.0724
2246 , p5_a44 NUMBER := 0-1962.0724
2247 , p5_a45 NUMBER := 0-1962.0724
2248 , p5_a46 NUMBER := 0-1962.0724
2249 , p5_a47 NUMBER := 0-1962.0724
2250 , p5_a48 NUMBER := 0-1962.0724
2251 , p5_a49 DATE := fnd_api.g_miss_date
2252 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
2253 , p5_a51 NUMBER := 0-1962.0724
2254 , p5_a52 NUMBER := 0-1962.0724
2255 , p5_a53 DATE := fnd_api.g_miss_date
2256 , p5_a54 DATE := fnd_api.g_miss_date
2257 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
2258 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
2259 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
2260 , p5_a58 NUMBER := 0-1962.0724
2261 , p5_a59 DATE := fnd_api.g_miss_date
2262 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
2263 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
2264 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
2265 , p5_a63 VARCHAR2 := fnd_api.g_miss_char
2266 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
2267 , p5_a65 VARCHAR2 := fnd_api.g_miss_char
2268 )
2269
2270 as
2271 ddp_khrv_rec okl_khr_pvt.khrv_rec_type;
2272 ddx_khrv_rec okl_khr_pvt.khrv_rec_type;
2273 ddindx binary_integer; indx binary_integer;
2274 begin
2275
2276 -- copy data to the local IN or IN-OUT args, if any
2277
2278
2279
2280
2281
2282 ddp_khrv_rec.id := rosetta_g_miss_num_map(p5_a0);
2283 ddp_khrv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
2284 ddp_khrv_rec.isg_id := rosetta_g_miss_num_map(p5_a2);
2285 ddp_khrv_rec.khr_id := rosetta_g_miss_num_map(p5_a3);
2286 ddp_khrv_rec.pdt_id := rosetta_g_miss_num_map(p5_a4);
2287 ddp_khrv_rec.amd_code := p5_a5;
2288 ddp_khrv_rec.date_first_activity := rosetta_g_miss_date_in_map(p5_a6);
2289 ddp_khrv_rec.generate_accrual_yn := p5_a7;
2290 ddp_khrv_rec.generate_accrual_override_yn := p5_a8;
2291 ddp_khrv_rec.date_refinanced := rosetta_g_miss_date_in_map(p5_a9);
2292 ddp_khrv_rec.credit_act_yn := p5_a10;
2293 ddp_khrv_rec.term_duration := rosetta_g_miss_num_map(p5_a11);
2294 ddp_khrv_rec.converted_account_yn := p5_a12;
2295 ddp_khrv_rec.date_conversion_effective := rosetta_g_miss_date_in_map(p5_a13);
2296 ddp_khrv_rec.syndicatable_yn := p5_a14;
2297 ddp_khrv_rec.salestype_yn := p5_a15;
2298 ddp_khrv_rec.date_deal_transferred := rosetta_g_miss_date_in_map(p5_a16);
2299 ddp_khrv_rec.datetime_proposal_effective := rosetta_g_miss_date_in_map(p5_a17);
2300 ddp_khrv_rec.datetime_proposal_ineffective := rosetta_g_miss_date_in_map(p5_a18);
2301 ddp_khrv_rec.date_proposal_accepted := rosetta_g_miss_date_in_map(p5_a19);
2302 ddp_khrv_rec.attribute_category := p5_a20;
2303 ddp_khrv_rec.attribute1 := p5_a21;
2304 ddp_khrv_rec.attribute2 := p5_a22;
2305 ddp_khrv_rec.attribute3 := p5_a23;
2306 ddp_khrv_rec.attribute4 := p5_a24;
2307 ddp_khrv_rec.attribute5 := p5_a25;
2308 ddp_khrv_rec.attribute6 := p5_a26;
2309 ddp_khrv_rec.attribute7 := p5_a27;
2310 ddp_khrv_rec.attribute8 := p5_a28;
2311 ddp_khrv_rec.attribute9 := p5_a29;
2312 ddp_khrv_rec.attribute10 := p5_a30;
2313 ddp_khrv_rec.attribute11 := p5_a31;
2314 ddp_khrv_rec.attribute12 := p5_a32;
2315 ddp_khrv_rec.attribute13 := p5_a33;
2316 ddp_khrv_rec.attribute14 := p5_a34;
2317 ddp_khrv_rec.attribute15 := p5_a35;
2318 ddp_khrv_rec.created_by := rosetta_g_miss_num_map(p5_a36);
2319 ddp_khrv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a37);
2320 ddp_khrv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a38);
2321 ddp_khrv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a39);
2322 ddp_khrv_rec.last_update_login := rosetta_g_miss_num_map(p5_a40);
2323 ddp_khrv_rec.pre_tax_yield := rosetta_g_miss_num_map(p5_a41);
2324 ddp_khrv_rec.after_tax_yield := rosetta_g_miss_num_map(p5_a42);
2325 ddp_khrv_rec.implicit_interest_rate := rosetta_g_miss_num_map(p5_a43);
2326 ddp_khrv_rec.implicit_non_idc_interest_rate := rosetta_g_miss_num_map(p5_a44);
2327 ddp_khrv_rec.target_pre_tax_yield := rosetta_g_miss_num_map(p5_a45);
2328 ddp_khrv_rec.target_after_tax_yield := rosetta_g_miss_num_map(p5_a46);
2329 ddp_khrv_rec.target_implicit_interest_rate := rosetta_g_miss_num_map(p5_a47);
2330 ddp_khrv_rec.target_implicit_nonidc_intrate := rosetta_g_miss_num_map(p5_a48);
2331 ddp_khrv_rec.date_last_interim_interest_cal := rosetta_g_miss_date_in_map(p5_a49);
2332 ddp_khrv_rec.deal_type := p5_a50;
2333 ddp_khrv_rec.pre_tax_irr := rosetta_g_miss_num_map(p5_a51);
2334 ddp_khrv_rec.after_tax_irr := rosetta_g_miss_num_map(p5_a52);
2335 ddp_khrv_rec.expected_delivery_date := rosetta_g_miss_date_in_map(p5_a53);
2336 ddp_khrv_rec.accepted_date := rosetta_g_miss_date_in_map(p5_a54);
2337 ddp_khrv_rec.prefunding_eligible_yn := p5_a55;
2338 ddp_khrv_rec.revolving_credit_yn := p5_a56;
2339 ddp_khrv_rec.currency_conversion_type := p5_a57;
2340 ddp_khrv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a58);
2341 ddp_khrv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a59);
2342 ddp_khrv_rec.multi_gaap_yn := p5_a60;
2343 ddp_khrv_rec.recourse_code := p5_a61;
2344 ddp_khrv_rec.lessor_serv_org_code := p5_a62;
2345 ddp_khrv_rec.assignable_yn := p5_a63;
2346 ddp_khrv_rec.securitized_code := p5_a64;
2347 ddp_khrv_rec.securitization_type := p5_a65;
2348
2349
2350 -- here's the delegated call to the old PL/SQL routine
2351 okl_khr_pvt.update_row(p_api_version,
2352 p_init_msg_list,
2353 x_return_status,
2354 x_msg_count,
2355 x_msg_data,
2356 ddp_khrv_rec,
2357 ddx_khrv_rec);
2358
2359 -- copy data back from the local variables to OUT or IN-OUT args, if any
2360
2361
2362
2363
2364
2365
2366 p6_a0 := rosetta_g_miss_num_map(ddx_khrv_rec.id);
2367 p6_a1 := rosetta_g_miss_num_map(ddx_khrv_rec.object_version_number);
2368 p6_a2 := rosetta_g_miss_num_map(ddx_khrv_rec.isg_id);
2369 p6_a3 := rosetta_g_miss_num_map(ddx_khrv_rec.khr_id);
2370 p6_a4 := rosetta_g_miss_num_map(ddx_khrv_rec.pdt_id);
2371 p6_a5 := ddx_khrv_rec.amd_code;
2372 p6_a6 := ddx_khrv_rec.date_first_activity;
2373 p6_a7 := ddx_khrv_rec.generate_accrual_yn;
2374 p6_a8 := ddx_khrv_rec.generate_accrual_override_yn;
2375 p6_a9 := ddx_khrv_rec.date_refinanced;
2376 p6_a10 := ddx_khrv_rec.credit_act_yn;
2377 p6_a11 := rosetta_g_miss_num_map(ddx_khrv_rec.term_duration);
2378 p6_a12 := ddx_khrv_rec.converted_account_yn;
2379 p6_a13 := ddx_khrv_rec.date_conversion_effective;
2380 p6_a14 := ddx_khrv_rec.syndicatable_yn;
2381 p6_a15 := ddx_khrv_rec.salestype_yn;
2382 p6_a16 := ddx_khrv_rec.date_deal_transferred;
2383 p6_a17 := ddx_khrv_rec.datetime_proposal_effective;
2384 p6_a18 := ddx_khrv_rec.datetime_proposal_ineffective;
2385 p6_a19 := ddx_khrv_rec.date_proposal_accepted;
2386 p6_a20 := ddx_khrv_rec.attribute_category;
2387 p6_a21 := ddx_khrv_rec.attribute1;
2388 p6_a22 := ddx_khrv_rec.attribute2;
2389 p6_a23 := ddx_khrv_rec.attribute3;
2390 p6_a24 := ddx_khrv_rec.attribute4;
2391 p6_a25 := ddx_khrv_rec.attribute5;
2392 p6_a26 := ddx_khrv_rec.attribute6;
2393 p6_a27 := ddx_khrv_rec.attribute7;
2394 p6_a28 := ddx_khrv_rec.attribute8;
2395 p6_a29 := ddx_khrv_rec.attribute9;
2396 p6_a30 := ddx_khrv_rec.attribute10;
2397 p6_a31 := ddx_khrv_rec.attribute11;
2398 p6_a32 := ddx_khrv_rec.attribute12;
2399 p6_a33 := ddx_khrv_rec.attribute13;
2400 p6_a34 := ddx_khrv_rec.attribute14;
2401 p6_a35 := ddx_khrv_rec.attribute15;
2402 p6_a36 := rosetta_g_miss_num_map(ddx_khrv_rec.created_by);
2403 p6_a37 := ddx_khrv_rec.creation_date;
2404 p6_a38 := rosetta_g_miss_num_map(ddx_khrv_rec.last_updated_by);
2405 p6_a39 := ddx_khrv_rec.last_update_date;
2406 p6_a40 := rosetta_g_miss_num_map(ddx_khrv_rec.last_update_login);
2407 p6_a41 := rosetta_g_miss_num_map(ddx_khrv_rec.pre_tax_yield);
2408 p6_a42 := rosetta_g_miss_num_map(ddx_khrv_rec.after_tax_yield);
2409 p6_a43 := rosetta_g_miss_num_map(ddx_khrv_rec.implicit_interest_rate);
2410 p6_a44 := rosetta_g_miss_num_map(ddx_khrv_rec.implicit_non_idc_interest_rate);
2411 p6_a45 := rosetta_g_miss_num_map(ddx_khrv_rec.target_pre_tax_yield);
2412 p6_a46 := rosetta_g_miss_num_map(ddx_khrv_rec.target_after_tax_yield);
2413 p6_a47 := rosetta_g_miss_num_map(ddx_khrv_rec.target_implicit_interest_rate);
2414 p6_a48 := rosetta_g_miss_num_map(ddx_khrv_rec.target_implicit_nonidc_intrate);
2415 p6_a49 := ddx_khrv_rec.date_last_interim_interest_cal;
2416 p6_a50 := ddx_khrv_rec.deal_type;
2417 p6_a51 := rosetta_g_miss_num_map(ddx_khrv_rec.pre_tax_irr);
2418 p6_a52 := rosetta_g_miss_num_map(ddx_khrv_rec.after_tax_irr);
2419 p6_a53 := ddx_khrv_rec.expected_delivery_date;
2420 p6_a54 := ddx_khrv_rec.accepted_date;
2421 p6_a55 := ddx_khrv_rec.prefunding_eligible_yn;
2422 p6_a56 := ddx_khrv_rec.revolving_credit_yn;
2423 p6_a57 := ddx_khrv_rec.currency_conversion_type;
2424 p6_a58 := rosetta_g_miss_num_map(ddx_khrv_rec.currency_conversion_rate);
2425 p6_a59 := ddx_khrv_rec.currency_conversion_date;
2426 p6_a60 := ddx_khrv_rec.multi_gaap_yn;
2427 p6_a61 := ddx_khrv_rec.recourse_code;
2428 p6_a62 := ddx_khrv_rec.lessor_serv_org_code;
2429 p6_a63 := ddx_khrv_rec.assignable_yn;
2430 p6_a64 := ddx_khrv_rec.securitized_code;
2431 p6_a65 := ddx_khrv_rec.securitization_type;
2432 end;
2433
2434 procedure update_row(p_api_version NUMBER
2435 , p_init_msg_list VARCHAR2
2436 , x_return_status out nocopy VARCHAR2
2437 , x_msg_count out nocopy NUMBER
2438 , x_msg_data out nocopy VARCHAR2
2439 , p5_a0 JTF_NUMBER_TABLE
2440 , p5_a1 JTF_NUMBER_TABLE
2441 , p5_a2 JTF_NUMBER_TABLE
2442 , p5_a3 JTF_NUMBER_TABLE
2443 , p5_a4 JTF_NUMBER_TABLE
2444 , p5_a5 JTF_VARCHAR2_TABLE_100
2445 , p5_a6 JTF_DATE_TABLE
2446 , p5_a7 JTF_VARCHAR2_TABLE_100
2447 , p5_a8 JTF_VARCHAR2_TABLE_100
2448 , p5_a9 JTF_DATE_TABLE
2449 , p5_a10 JTF_VARCHAR2_TABLE_100
2450 , p5_a11 JTF_NUMBER_TABLE
2451 , p5_a12 JTF_VARCHAR2_TABLE_100
2452 , p5_a13 JTF_DATE_TABLE
2453 , p5_a14 JTF_VARCHAR2_TABLE_100
2454 , p5_a15 JTF_VARCHAR2_TABLE_100
2455 , p5_a16 JTF_DATE_TABLE
2456 , p5_a17 JTF_DATE_TABLE
2457 , p5_a18 JTF_DATE_TABLE
2458 , p5_a19 JTF_DATE_TABLE
2459 , p5_a20 JTF_VARCHAR2_TABLE_100
2460 , p5_a21 JTF_VARCHAR2_TABLE_500
2461 , p5_a22 JTF_VARCHAR2_TABLE_500
2462 , p5_a23 JTF_VARCHAR2_TABLE_500
2463 , p5_a24 JTF_VARCHAR2_TABLE_500
2464 , p5_a25 JTF_VARCHAR2_TABLE_500
2465 , p5_a26 JTF_VARCHAR2_TABLE_500
2466 , p5_a27 JTF_VARCHAR2_TABLE_500
2467 , p5_a28 JTF_VARCHAR2_TABLE_500
2468 , p5_a29 JTF_VARCHAR2_TABLE_500
2469 , p5_a30 JTF_VARCHAR2_TABLE_500
2470 , p5_a31 JTF_VARCHAR2_TABLE_500
2471 , p5_a32 JTF_VARCHAR2_TABLE_500
2472 , p5_a33 JTF_VARCHAR2_TABLE_500
2473 , p5_a34 JTF_VARCHAR2_TABLE_500
2474 , p5_a35 JTF_VARCHAR2_TABLE_500
2475 , p5_a36 JTF_NUMBER_TABLE
2476 , p5_a37 JTF_DATE_TABLE
2477 , p5_a38 JTF_NUMBER_TABLE
2478 , p5_a39 JTF_DATE_TABLE
2479 , p5_a40 JTF_NUMBER_TABLE
2480 , p5_a41 JTF_NUMBER_TABLE
2481 , p5_a42 JTF_NUMBER_TABLE
2482 , p5_a43 JTF_NUMBER_TABLE
2483 , p5_a44 JTF_NUMBER_TABLE
2484 , p5_a45 JTF_NUMBER_TABLE
2485 , p5_a46 JTF_NUMBER_TABLE
2486 , p5_a47 JTF_NUMBER_TABLE
2487 , p5_a48 JTF_NUMBER_TABLE
2488 , p5_a49 JTF_DATE_TABLE
2489 , p5_a50 JTF_VARCHAR2_TABLE_100
2490 , p5_a51 JTF_NUMBER_TABLE
2491 , p5_a52 JTF_NUMBER_TABLE
2492 , p5_a53 JTF_DATE_TABLE
2493 , p5_a54 JTF_DATE_TABLE
2494 , p5_a55 JTF_VARCHAR2_TABLE_100
2495 , p5_a56 JTF_VARCHAR2_TABLE_100
2496 , p5_a57 JTF_VARCHAR2_TABLE_100
2497 , p5_a58 JTF_NUMBER_TABLE
2498 , p5_a59 JTF_DATE_TABLE
2499 , p5_a60 JTF_VARCHAR2_TABLE_100
2500 , p5_a61 JTF_VARCHAR2_TABLE_100
2501 , p5_a62 JTF_VARCHAR2_TABLE_100
2502 , p5_a63 JTF_VARCHAR2_TABLE_100
2503 , p5_a64 JTF_VARCHAR2_TABLE_100
2504 , p5_a65 JTF_VARCHAR2_TABLE_100
2505 , p6_a0 out nocopy JTF_NUMBER_TABLE
2506 , p6_a1 out nocopy JTF_NUMBER_TABLE
2507 , p6_a2 out nocopy JTF_NUMBER_TABLE
2508 , p6_a3 out nocopy JTF_NUMBER_TABLE
2509 , p6_a4 out nocopy JTF_NUMBER_TABLE
2510 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2511 , p6_a6 out nocopy JTF_DATE_TABLE
2512 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2513 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2514 , p6_a9 out nocopy JTF_DATE_TABLE
2515 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2516 , p6_a11 out nocopy JTF_NUMBER_TABLE
2517 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
2518 , p6_a13 out nocopy JTF_DATE_TABLE
2519 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
2520 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
2521 , p6_a16 out nocopy JTF_DATE_TABLE
2522 , p6_a17 out nocopy JTF_DATE_TABLE
2523 , p6_a18 out nocopy JTF_DATE_TABLE
2524 , p6_a19 out nocopy JTF_DATE_TABLE
2525 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2526 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
2527 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
2528 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
2529 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
2530 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
2531 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
2532 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
2533 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
2534 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
2535 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
2536 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
2537 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
2538 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
2539 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
2540 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
2541 , p6_a36 out nocopy JTF_NUMBER_TABLE
2542 , p6_a37 out nocopy JTF_DATE_TABLE
2543 , p6_a38 out nocopy JTF_NUMBER_TABLE
2544 , p6_a39 out nocopy JTF_DATE_TABLE
2545 , p6_a40 out nocopy JTF_NUMBER_TABLE
2546 , p6_a41 out nocopy JTF_NUMBER_TABLE
2547 , p6_a42 out nocopy JTF_NUMBER_TABLE
2548 , p6_a43 out nocopy JTF_NUMBER_TABLE
2549 , p6_a44 out nocopy JTF_NUMBER_TABLE
2550 , p6_a45 out nocopy JTF_NUMBER_TABLE
2551 , p6_a46 out nocopy JTF_NUMBER_TABLE
2552 , p6_a47 out nocopy JTF_NUMBER_TABLE
2553 , p6_a48 out nocopy JTF_NUMBER_TABLE
2554 , p6_a49 out nocopy JTF_DATE_TABLE
2555 , p6_a50 out nocopy JTF_VARCHAR2_TABLE_100
2556 , p6_a51 out nocopy JTF_NUMBER_TABLE
2557 , p6_a52 out nocopy JTF_NUMBER_TABLE
2558 , p6_a53 out nocopy JTF_DATE_TABLE
2559 , p6_a54 out nocopy JTF_DATE_TABLE
2560 , p6_a55 out nocopy JTF_VARCHAR2_TABLE_100
2561 , p6_a56 out nocopy JTF_VARCHAR2_TABLE_100
2562 , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100
2563 , p6_a58 out nocopy JTF_NUMBER_TABLE
2564 , p6_a59 out nocopy JTF_DATE_TABLE
2565 , p6_a60 out nocopy JTF_VARCHAR2_TABLE_100
2566 , p6_a61 out nocopy JTF_VARCHAR2_TABLE_100
2567 , p6_a62 out nocopy JTF_VARCHAR2_TABLE_100
2568 , p6_a63 out nocopy JTF_VARCHAR2_TABLE_100
2569 , p6_a64 out nocopy JTF_VARCHAR2_TABLE_100
2570 , p6_a65 out nocopy JTF_VARCHAR2_TABLE_100
2571 )
2572
2573 as
2574 ddp_khrv_tbl okl_khr_pvt.khrv_tbl_type;
2575 ddx_khrv_tbl okl_khr_pvt.khrv_tbl_type;
2576 ddindx binary_integer; indx binary_integer;
2577 begin
2578
2579 -- copy data to the local IN or IN-OUT args, if any
2580
2581
2582
2583
2584
2585 okl_khr_pvt_w.rosetta_table_copy_in_p8(ddp_khrv_tbl, p5_a0
2586 , p5_a1
2587 , p5_a2
2588 , p5_a3
2589 , p5_a4
2590 , p5_a5
2591 , p5_a6
2592 , p5_a7
2593 , p5_a8
2594 , p5_a9
2595 , p5_a10
2596 , p5_a11
2597 , p5_a12
2598 , p5_a13
2599 , p5_a14
2600 , p5_a15
2601 , p5_a16
2602 , p5_a17
2603 , p5_a18
2604 , p5_a19
2605 , p5_a20
2606 , p5_a21
2607 , p5_a22
2608 , p5_a23
2609 , p5_a24
2610 , p5_a25
2611 , p5_a26
2612 , p5_a27
2613 , p5_a28
2614 , p5_a29
2615 , p5_a30
2616 , p5_a31
2617 , p5_a32
2618 , p5_a33
2619 , p5_a34
2620 , p5_a35
2621 , p5_a36
2622 , p5_a37
2623 , p5_a38
2624 , p5_a39
2625 , p5_a40
2626 , p5_a41
2627 , p5_a42
2628 , p5_a43
2629 , p5_a44
2630 , p5_a45
2631 , p5_a46
2632 , p5_a47
2633 , p5_a48
2634 , p5_a49
2635 , p5_a50
2636 , p5_a51
2637 , p5_a52
2638 , p5_a53
2639 , p5_a54
2640 , p5_a55
2641 , p5_a56
2642 , p5_a57
2643 , p5_a58
2644 , p5_a59
2645 , p5_a60
2646 , p5_a61
2647 , p5_a62
2648 , p5_a63
2649 , p5_a64
2650 , p5_a65
2651 );
2652
2653
2654 -- here's the delegated call to the old PL/SQL routine
2655 okl_khr_pvt.update_row(p_api_version,
2656 p_init_msg_list,
2657 x_return_status,
2658 x_msg_count,
2659 x_msg_data,
2660 ddp_khrv_tbl,
2661 ddx_khrv_tbl);
2662
2663 -- copy data back from the local variables to OUT or IN-OUT args, if any
2664
2665
2666
2667
2668
2669
2670 okl_khr_pvt_w.rosetta_table_copy_out_p8(ddx_khrv_tbl, p6_a0
2671 , p6_a1
2672 , p6_a2
2673 , p6_a3
2674 , p6_a4
2675 , p6_a5
2676 , p6_a6
2677 , p6_a7
2678 , p6_a8
2679 , p6_a9
2680 , p6_a10
2681 , p6_a11
2682 , p6_a12
2683 , p6_a13
2684 , p6_a14
2685 , p6_a15
2686 , p6_a16
2687 , p6_a17
2688 , p6_a18
2689 , p6_a19
2690 , p6_a20
2691 , p6_a21
2692 , p6_a22
2693 , p6_a23
2694 , p6_a24
2695 , p6_a25
2696 , p6_a26
2697 , p6_a27
2698 , p6_a28
2699 , p6_a29
2700 , p6_a30
2701 , p6_a31
2702 , p6_a32
2703 , p6_a33
2704 , p6_a34
2705 , p6_a35
2706 , p6_a36
2707 , p6_a37
2708 , p6_a38
2709 , p6_a39
2710 , p6_a40
2711 , p6_a41
2712 , p6_a42
2713 , p6_a43
2714 , p6_a44
2715 , p6_a45
2716 , p6_a46
2717 , p6_a47
2718 , p6_a48
2719 , p6_a49
2720 , p6_a50
2721 , p6_a51
2722 , p6_a52
2723 , p6_a53
2724 , p6_a54
2725 , p6_a55
2726 , p6_a56
2727 , p6_a57
2728 , p6_a58
2729 , p6_a59
2730 , p6_a60
2731 , p6_a61
2732 , p6_a62
2733 , p6_a63
2734 , p6_a64
2735 , p6_a65
2736 );
2737 end;
2738
2739 procedure delete_row(p_api_version NUMBER
2740 , p_init_msg_list VARCHAR2
2741 , x_return_status out nocopy VARCHAR2
2742 , x_msg_count out nocopy NUMBER
2743 , x_msg_data out nocopy VARCHAR2
2744 , p5_a0 NUMBER := 0-1962.0724
2745 , p5_a1 NUMBER := 0-1962.0724
2746 , p5_a2 NUMBER := 0-1962.0724
2747 , p5_a3 NUMBER := 0-1962.0724
2748 , p5_a4 NUMBER := 0-1962.0724
2749 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2750 , p5_a6 DATE := fnd_api.g_miss_date
2751 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2752 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2753 , p5_a9 DATE := fnd_api.g_miss_date
2754 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2755 , p5_a11 NUMBER := 0-1962.0724
2756 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2757 , p5_a13 DATE := fnd_api.g_miss_date
2758 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2759 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2760 , p5_a16 DATE := fnd_api.g_miss_date
2761 , p5_a17 DATE := fnd_api.g_miss_date
2762 , p5_a18 DATE := fnd_api.g_miss_date
2763 , p5_a19 DATE := fnd_api.g_miss_date
2764 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2765 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2766 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2767 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2768 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2769 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2770 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2771 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2772 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2773 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2774 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2775 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2776 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2777 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2778 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2779 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2780 , p5_a36 NUMBER := 0-1962.0724
2781 , p5_a37 DATE := fnd_api.g_miss_date
2782 , p5_a38 NUMBER := 0-1962.0724
2783 , p5_a39 DATE := fnd_api.g_miss_date
2784 , p5_a40 NUMBER := 0-1962.0724
2785 , p5_a41 NUMBER := 0-1962.0724
2786 , p5_a42 NUMBER := 0-1962.0724
2787 , p5_a43 NUMBER := 0-1962.0724
2788 , p5_a44 NUMBER := 0-1962.0724
2789 , p5_a45 NUMBER := 0-1962.0724
2790 , p5_a46 NUMBER := 0-1962.0724
2791 , p5_a47 NUMBER := 0-1962.0724
2792 , p5_a48 NUMBER := 0-1962.0724
2793 , p5_a49 DATE := fnd_api.g_miss_date
2794 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
2795 , p5_a51 NUMBER := 0-1962.0724
2796 , p5_a52 NUMBER := 0-1962.0724
2797 , p5_a53 DATE := fnd_api.g_miss_date
2798 , p5_a54 DATE := fnd_api.g_miss_date
2799 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
2800 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
2801 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
2802 , p5_a58 NUMBER := 0-1962.0724
2803 , p5_a59 DATE := fnd_api.g_miss_date
2804 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
2805 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
2806 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
2807 , p5_a63 VARCHAR2 := fnd_api.g_miss_char
2808 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
2809 , p5_a65 VARCHAR2 := fnd_api.g_miss_char
2810 )
2811
2812 as
2813 ddp_khrv_rec okl_khr_pvt.khrv_rec_type;
2814 ddindx binary_integer; indx binary_integer;
2815 begin
2816
2817 -- copy data to the local IN or IN-OUT args, if any
2818
2819
2820
2821
2822
2823 ddp_khrv_rec.id := rosetta_g_miss_num_map(p5_a0);
2824 ddp_khrv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
2825 ddp_khrv_rec.isg_id := rosetta_g_miss_num_map(p5_a2);
2826 ddp_khrv_rec.khr_id := rosetta_g_miss_num_map(p5_a3);
2827 ddp_khrv_rec.pdt_id := rosetta_g_miss_num_map(p5_a4);
2828 ddp_khrv_rec.amd_code := p5_a5;
2829 ddp_khrv_rec.date_first_activity := rosetta_g_miss_date_in_map(p5_a6);
2830 ddp_khrv_rec.generate_accrual_yn := p5_a7;
2831 ddp_khrv_rec.generate_accrual_override_yn := p5_a8;
2832 ddp_khrv_rec.date_refinanced := rosetta_g_miss_date_in_map(p5_a9);
2833 ddp_khrv_rec.credit_act_yn := p5_a10;
2834 ddp_khrv_rec.term_duration := rosetta_g_miss_num_map(p5_a11);
2835 ddp_khrv_rec.converted_account_yn := p5_a12;
2836 ddp_khrv_rec.date_conversion_effective := rosetta_g_miss_date_in_map(p5_a13);
2837 ddp_khrv_rec.syndicatable_yn := p5_a14;
2838 ddp_khrv_rec.salestype_yn := p5_a15;
2839 ddp_khrv_rec.date_deal_transferred := rosetta_g_miss_date_in_map(p5_a16);
2840 ddp_khrv_rec.datetime_proposal_effective := rosetta_g_miss_date_in_map(p5_a17);
2841 ddp_khrv_rec.datetime_proposal_ineffective := rosetta_g_miss_date_in_map(p5_a18);
2842 ddp_khrv_rec.date_proposal_accepted := rosetta_g_miss_date_in_map(p5_a19);
2843 ddp_khrv_rec.attribute_category := p5_a20;
2844 ddp_khrv_rec.attribute1 := p5_a21;
2845 ddp_khrv_rec.attribute2 := p5_a22;
2846 ddp_khrv_rec.attribute3 := p5_a23;
2847 ddp_khrv_rec.attribute4 := p5_a24;
2848 ddp_khrv_rec.attribute5 := p5_a25;
2849 ddp_khrv_rec.attribute6 := p5_a26;
2850 ddp_khrv_rec.attribute7 := p5_a27;
2851 ddp_khrv_rec.attribute8 := p5_a28;
2852 ddp_khrv_rec.attribute9 := p5_a29;
2853 ddp_khrv_rec.attribute10 := p5_a30;
2854 ddp_khrv_rec.attribute11 := p5_a31;
2855 ddp_khrv_rec.attribute12 := p5_a32;
2856 ddp_khrv_rec.attribute13 := p5_a33;
2857 ddp_khrv_rec.attribute14 := p5_a34;
2858 ddp_khrv_rec.attribute15 := p5_a35;
2859 ddp_khrv_rec.created_by := rosetta_g_miss_num_map(p5_a36);
2860 ddp_khrv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a37);
2861 ddp_khrv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a38);
2862 ddp_khrv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a39);
2863 ddp_khrv_rec.last_update_login := rosetta_g_miss_num_map(p5_a40);
2864 ddp_khrv_rec.pre_tax_yield := rosetta_g_miss_num_map(p5_a41);
2865 ddp_khrv_rec.after_tax_yield := rosetta_g_miss_num_map(p5_a42);
2866 ddp_khrv_rec.implicit_interest_rate := rosetta_g_miss_num_map(p5_a43);
2867 ddp_khrv_rec.implicit_non_idc_interest_rate := rosetta_g_miss_num_map(p5_a44);
2868 ddp_khrv_rec.target_pre_tax_yield := rosetta_g_miss_num_map(p5_a45);
2869 ddp_khrv_rec.target_after_tax_yield := rosetta_g_miss_num_map(p5_a46);
2870 ddp_khrv_rec.target_implicit_interest_rate := rosetta_g_miss_num_map(p5_a47);
2871 ddp_khrv_rec.target_implicit_nonidc_intrate := rosetta_g_miss_num_map(p5_a48);
2872 ddp_khrv_rec.date_last_interim_interest_cal := rosetta_g_miss_date_in_map(p5_a49);
2873 ddp_khrv_rec.deal_type := p5_a50;
2874 ddp_khrv_rec.pre_tax_irr := rosetta_g_miss_num_map(p5_a51);
2875 ddp_khrv_rec.after_tax_irr := rosetta_g_miss_num_map(p5_a52);
2876 ddp_khrv_rec.expected_delivery_date := rosetta_g_miss_date_in_map(p5_a53);
2877 ddp_khrv_rec.accepted_date := rosetta_g_miss_date_in_map(p5_a54);
2878 ddp_khrv_rec.prefunding_eligible_yn := p5_a55;
2879 ddp_khrv_rec.revolving_credit_yn := p5_a56;
2880 ddp_khrv_rec.currency_conversion_type := p5_a57;
2881 ddp_khrv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a58);
2882 ddp_khrv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a59);
2883 ddp_khrv_rec.multi_gaap_yn := p5_a60;
2884 ddp_khrv_rec.recourse_code := p5_a61;
2885 ddp_khrv_rec.lessor_serv_org_code := p5_a62;
2886 ddp_khrv_rec.assignable_yn := p5_a63;
2887 ddp_khrv_rec.securitized_code := p5_a64;
2888 ddp_khrv_rec.securitization_type := p5_a65;
2889
2890 -- here's the delegated call to the old PL/SQL routine
2891 okl_khr_pvt.delete_row(p_api_version,
2892 p_init_msg_list,
2893 x_return_status,
2894 x_msg_count,
2895 x_msg_data,
2896 ddp_khrv_rec);
2897
2898 -- copy data back from the local variables to OUT or IN-OUT args, if any
2899
2900
2901
2902
2903
2904 end;
2905
2906 procedure delete_row(p_api_version NUMBER
2907 , p_init_msg_list VARCHAR2
2908 , x_return_status out nocopy VARCHAR2
2909 , x_msg_count out nocopy NUMBER
2910 , x_msg_data out nocopy VARCHAR2
2911 , p5_a0 JTF_NUMBER_TABLE
2912 , p5_a1 JTF_NUMBER_TABLE
2913 , p5_a2 JTF_NUMBER_TABLE
2914 , p5_a3 JTF_NUMBER_TABLE
2915 , p5_a4 JTF_NUMBER_TABLE
2916 , p5_a5 JTF_VARCHAR2_TABLE_100
2917 , p5_a6 JTF_DATE_TABLE
2918 , p5_a7 JTF_VARCHAR2_TABLE_100
2919 , p5_a8 JTF_VARCHAR2_TABLE_100
2920 , p5_a9 JTF_DATE_TABLE
2921 , p5_a10 JTF_VARCHAR2_TABLE_100
2922 , p5_a11 JTF_NUMBER_TABLE
2923 , p5_a12 JTF_VARCHAR2_TABLE_100
2924 , p5_a13 JTF_DATE_TABLE
2925 , p5_a14 JTF_VARCHAR2_TABLE_100
2926 , p5_a15 JTF_VARCHAR2_TABLE_100
2927 , p5_a16 JTF_DATE_TABLE
2928 , p5_a17 JTF_DATE_TABLE
2929 , p5_a18 JTF_DATE_TABLE
2930 , p5_a19 JTF_DATE_TABLE
2931 , p5_a20 JTF_VARCHAR2_TABLE_100
2932 , p5_a21 JTF_VARCHAR2_TABLE_500
2933 , p5_a22 JTF_VARCHAR2_TABLE_500
2934 , p5_a23 JTF_VARCHAR2_TABLE_500
2935 , p5_a24 JTF_VARCHAR2_TABLE_500
2936 , p5_a25 JTF_VARCHAR2_TABLE_500
2937 , p5_a26 JTF_VARCHAR2_TABLE_500
2938 , p5_a27 JTF_VARCHAR2_TABLE_500
2939 , p5_a28 JTF_VARCHAR2_TABLE_500
2940 , p5_a29 JTF_VARCHAR2_TABLE_500
2941 , p5_a30 JTF_VARCHAR2_TABLE_500
2942 , p5_a31 JTF_VARCHAR2_TABLE_500
2943 , p5_a32 JTF_VARCHAR2_TABLE_500
2944 , p5_a33 JTF_VARCHAR2_TABLE_500
2945 , p5_a34 JTF_VARCHAR2_TABLE_500
2946 , p5_a35 JTF_VARCHAR2_TABLE_500
2947 , p5_a36 JTF_NUMBER_TABLE
2948 , p5_a37 JTF_DATE_TABLE
2949 , p5_a38 JTF_NUMBER_TABLE
2950 , p5_a39 JTF_DATE_TABLE
2951 , p5_a40 JTF_NUMBER_TABLE
2952 , p5_a41 JTF_NUMBER_TABLE
2953 , p5_a42 JTF_NUMBER_TABLE
2954 , p5_a43 JTF_NUMBER_TABLE
2955 , p5_a44 JTF_NUMBER_TABLE
2956 , p5_a45 JTF_NUMBER_TABLE
2957 , p5_a46 JTF_NUMBER_TABLE
2958 , p5_a47 JTF_NUMBER_TABLE
2959 , p5_a48 JTF_NUMBER_TABLE
2960 , p5_a49 JTF_DATE_TABLE
2961 , p5_a50 JTF_VARCHAR2_TABLE_100
2962 , p5_a51 JTF_NUMBER_TABLE
2963 , p5_a52 JTF_NUMBER_TABLE
2964 , p5_a53 JTF_DATE_TABLE
2965 , p5_a54 JTF_DATE_TABLE
2966 , p5_a55 JTF_VARCHAR2_TABLE_100
2967 , p5_a56 JTF_VARCHAR2_TABLE_100
2968 , p5_a57 JTF_VARCHAR2_TABLE_100
2969 , p5_a58 JTF_NUMBER_TABLE
2970 , p5_a59 JTF_DATE_TABLE
2971 , p5_a60 JTF_VARCHAR2_TABLE_100
2972 , p5_a61 JTF_VARCHAR2_TABLE_100
2973 , p5_a62 JTF_VARCHAR2_TABLE_100
2974 , p5_a63 JTF_VARCHAR2_TABLE_100
2975 , p5_a64 JTF_VARCHAR2_TABLE_100
2976 , p5_a65 JTF_VARCHAR2_TABLE_100
2977 )
2978
2979 as
2980 ddp_khrv_tbl okl_khr_pvt.khrv_tbl_type;
2981 ddindx binary_integer; indx binary_integer;
2982 begin
2983
2984 -- copy data to the local IN or IN-OUT args, if any
2985
2986
2987
2988
2989
2990 okl_khr_pvt_w.rosetta_table_copy_in_p8(ddp_khrv_tbl, p5_a0
2991 , p5_a1
2992 , p5_a2
2993 , p5_a3
2994 , p5_a4
2995 , p5_a5
2996 , p5_a6
2997 , p5_a7
2998 , p5_a8
2999 , p5_a9
3000 , p5_a10
3001 , p5_a11
3002 , p5_a12
3003 , p5_a13
3004 , p5_a14
3005 , p5_a15
3006 , p5_a16
3007 , p5_a17
3008 , p5_a18
3009 , p5_a19
3010 , p5_a20
3011 , p5_a21
3012 , p5_a22
3013 , p5_a23
3014 , p5_a24
3015 , p5_a25
3016 , p5_a26
3017 , p5_a27
3018 , p5_a28
3019 , p5_a29
3020 , p5_a30
3021 , p5_a31
3022 , p5_a32
3023 , p5_a33
3024 , p5_a34
3025 , p5_a35
3026 , p5_a36
3027 , p5_a37
3028 , p5_a38
3029 , p5_a39
3030 , p5_a40
3031 , p5_a41
3032 , p5_a42
3033 , p5_a43
3034 , p5_a44
3035 , p5_a45
3036 , p5_a46
3037 , p5_a47
3038 , p5_a48
3039 , p5_a49
3040 , p5_a50
3041 , p5_a51
3042 , p5_a52
3043 , p5_a53
3044 , p5_a54
3045 , p5_a55
3046 , p5_a56
3047 , p5_a57
3048 , p5_a58
3049 , p5_a59
3050 , p5_a60
3051 , p5_a61
3052 , p5_a62
3053 , p5_a63
3054 , p5_a64
3055 , p5_a65
3056 );
3057
3058 -- here's the delegated call to the old PL/SQL routine
3059 okl_khr_pvt.delete_row(p_api_version,
3060 p_init_msg_list,
3061 x_return_status,
3062 x_msg_count,
3063 x_msg_data,
3064 ddp_khrv_tbl);
3065
3066 -- copy data back from the local variables to OUT or IN-OUT args, if any
3067
3068
3069
3070
3071
3072 end;
3073
3074 procedure validate_row(p_api_version NUMBER
3075 , p_init_msg_list VARCHAR2
3076 , x_return_status out nocopy VARCHAR2
3077 , x_msg_count out nocopy NUMBER
3078 , x_msg_data out nocopy VARCHAR2
3079 , p5_a0 NUMBER := 0-1962.0724
3080 , p5_a1 NUMBER := 0-1962.0724
3081 , p5_a2 NUMBER := 0-1962.0724
3082 , p5_a3 NUMBER := 0-1962.0724
3083 , p5_a4 NUMBER := 0-1962.0724
3084 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
3085 , p5_a6 DATE := fnd_api.g_miss_date
3086 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
3087 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
3088 , p5_a9 DATE := fnd_api.g_miss_date
3089 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
3090 , p5_a11 NUMBER := 0-1962.0724
3091 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
3092 , p5_a13 DATE := fnd_api.g_miss_date
3093 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
3094 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
3095 , p5_a16 DATE := fnd_api.g_miss_date
3096 , p5_a17 DATE := fnd_api.g_miss_date
3097 , p5_a18 DATE := fnd_api.g_miss_date
3098 , p5_a19 DATE := fnd_api.g_miss_date
3099 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
3100 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
3101 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
3102 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
3103 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
3104 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
3105 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
3106 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
3107 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
3108 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
3109 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
3110 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
3111 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
3112 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
3113 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
3114 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
3115 , p5_a36 NUMBER := 0-1962.0724
3116 , p5_a37 DATE := fnd_api.g_miss_date
3117 , p5_a38 NUMBER := 0-1962.0724
3118 , p5_a39 DATE := fnd_api.g_miss_date
3119 , p5_a40 NUMBER := 0-1962.0724
3120 , p5_a41 NUMBER := 0-1962.0724
3121 , p5_a42 NUMBER := 0-1962.0724
3122 , p5_a43 NUMBER := 0-1962.0724
3123 , p5_a44 NUMBER := 0-1962.0724
3124 , p5_a45 NUMBER := 0-1962.0724
3125 , p5_a46 NUMBER := 0-1962.0724
3126 , p5_a47 NUMBER := 0-1962.0724
3127 , p5_a48 NUMBER := 0-1962.0724
3128 , p5_a49 DATE := fnd_api.g_miss_date
3129 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
3130 , p5_a51 NUMBER := 0-1962.0724
3131 , p5_a52 NUMBER := 0-1962.0724
3132 , p5_a53 DATE := fnd_api.g_miss_date
3133 , p5_a54 DATE := fnd_api.g_miss_date
3134 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
3135 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
3136 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
3137 , p5_a58 NUMBER := 0-1962.0724
3138 , p5_a59 DATE := fnd_api.g_miss_date
3139 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
3140 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
3141 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
3142 , p5_a63 VARCHAR2 := fnd_api.g_miss_char
3143 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
3144 , p5_a65 VARCHAR2 := fnd_api.g_miss_char
3145 )
3146
3147 as
3148 ddp_khrv_rec okl_khr_pvt.khrv_rec_type;
3149 ddindx binary_integer; indx binary_integer;
3150 begin
3151
3152 -- copy data to the local IN or IN-OUT args, if any
3153
3154
3155
3156
3157
3158 ddp_khrv_rec.id := rosetta_g_miss_num_map(p5_a0);
3159 ddp_khrv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
3160 ddp_khrv_rec.isg_id := rosetta_g_miss_num_map(p5_a2);
3161 ddp_khrv_rec.khr_id := rosetta_g_miss_num_map(p5_a3);
3162 ddp_khrv_rec.pdt_id := rosetta_g_miss_num_map(p5_a4);
3163 ddp_khrv_rec.amd_code := p5_a5;
3164 ddp_khrv_rec.date_first_activity := rosetta_g_miss_date_in_map(p5_a6);
3165 ddp_khrv_rec.generate_accrual_yn := p5_a7;
3166 ddp_khrv_rec.generate_accrual_override_yn := p5_a8;
3167 ddp_khrv_rec.date_refinanced := rosetta_g_miss_date_in_map(p5_a9);
3168 ddp_khrv_rec.credit_act_yn := p5_a10;
3169 ddp_khrv_rec.term_duration := rosetta_g_miss_num_map(p5_a11);
3170 ddp_khrv_rec.converted_account_yn := p5_a12;
3171 ddp_khrv_rec.date_conversion_effective := rosetta_g_miss_date_in_map(p5_a13);
3172 ddp_khrv_rec.syndicatable_yn := p5_a14;
3173 ddp_khrv_rec.salestype_yn := p5_a15;
3174 ddp_khrv_rec.date_deal_transferred := rosetta_g_miss_date_in_map(p5_a16);
3175 ddp_khrv_rec.datetime_proposal_effective := rosetta_g_miss_date_in_map(p5_a17);
3176 ddp_khrv_rec.datetime_proposal_ineffective := rosetta_g_miss_date_in_map(p5_a18);
3177 ddp_khrv_rec.date_proposal_accepted := rosetta_g_miss_date_in_map(p5_a19);
3178 ddp_khrv_rec.attribute_category := p5_a20;
3179 ddp_khrv_rec.attribute1 := p5_a21;
3180 ddp_khrv_rec.attribute2 := p5_a22;
3181 ddp_khrv_rec.attribute3 := p5_a23;
3182 ddp_khrv_rec.attribute4 := p5_a24;
3183 ddp_khrv_rec.attribute5 := p5_a25;
3184 ddp_khrv_rec.attribute6 := p5_a26;
3185 ddp_khrv_rec.attribute7 := p5_a27;
3186 ddp_khrv_rec.attribute8 := p5_a28;
3187 ddp_khrv_rec.attribute9 := p5_a29;
3188 ddp_khrv_rec.attribute10 := p5_a30;
3189 ddp_khrv_rec.attribute11 := p5_a31;
3190 ddp_khrv_rec.attribute12 := p5_a32;
3191 ddp_khrv_rec.attribute13 := p5_a33;
3192 ddp_khrv_rec.attribute14 := p5_a34;
3193 ddp_khrv_rec.attribute15 := p5_a35;
3194 ddp_khrv_rec.created_by := rosetta_g_miss_num_map(p5_a36);
3195 ddp_khrv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a37);
3196 ddp_khrv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a38);
3197 ddp_khrv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a39);
3198 ddp_khrv_rec.last_update_login := rosetta_g_miss_num_map(p5_a40);
3199 ddp_khrv_rec.pre_tax_yield := rosetta_g_miss_num_map(p5_a41);
3200 ddp_khrv_rec.after_tax_yield := rosetta_g_miss_num_map(p5_a42);
3201 ddp_khrv_rec.implicit_interest_rate := rosetta_g_miss_num_map(p5_a43);
3202 ddp_khrv_rec.implicit_non_idc_interest_rate := rosetta_g_miss_num_map(p5_a44);
3203 ddp_khrv_rec.target_pre_tax_yield := rosetta_g_miss_num_map(p5_a45);
3204 ddp_khrv_rec.target_after_tax_yield := rosetta_g_miss_num_map(p5_a46);
3205 ddp_khrv_rec.target_implicit_interest_rate := rosetta_g_miss_num_map(p5_a47);
3206 ddp_khrv_rec.target_implicit_nonidc_intrate := rosetta_g_miss_num_map(p5_a48);
3207 ddp_khrv_rec.date_last_interim_interest_cal := rosetta_g_miss_date_in_map(p5_a49);
3208 ddp_khrv_rec.deal_type := p5_a50;
3209 ddp_khrv_rec.pre_tax_irr := rosetta_g_miss_num_map(p5_a51);
3210 ddp_khrv_rec.after_tax_irr := rosetta_g_miss_num_map(p5_a52);
3211 ddp_khrv_rec.expected_delivery_date := rosetta_g_miss_date_in_map(p5_a53);
3212 ddp_khrv_rec.accepted_date := rosetta_g_miss_date_in_map(p5_a54);
3213 ddp_khrv_rec.prefunding_eligible_yn := p5_a55;
3214 ddp_khrv_rec.revolving_credit_yn := p5_a56;
3215 ddp_khrv_rec.currency_conversion_type := p5_a57;
3216 ddp_khrv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a58);
3217 ddp_khrv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a59);
3218 ddp_khrv_rec.multi_gaap_yn := p5_a60;
3219 ddp_khrv_rec.recourse_code := p5_a61;
3220 ddp_khrv_rec.lessor_serv_org_code := p5_a62;
3221 ddp_khrv_rec.assignable_yn := p5_a63;
3222 ddp_khrv_rec.securitized_code := p5_a64;
3223 ddp_khrv_rec.securitization_type := p5_a65;
3224
3225 -- here's the delegated call to the old PL/SQL routine
3226 okl_khr_pvt.validate_row(p_api_version,
3227 p_init_msg_list,
3228 x_return_status,
3229 x_msg_count,
3230 x_msg_data,
3231 ddp_khrv_rec);
3232
3233 -- copy data back from the local variables to OUT or IN-OUT args, if any
3234
3235
3236
3237
3238
3239 end;
3240
3241 procedure validate_row(p_api_version NUMBER
3242 , p_init_msg_list VARCHAR2
3243 , x_return_status out nocopy VARCHAR2
3244 , x_msg_count out nocopy NUMBER
3245 , x_msg_data out nocopy VARCHAR2
3246 , p5_a0 JTF_NUMBER_TABLE
3247 , p5_a1 JTF_NUMBER_TABLE
3248 , p5_a2 JTF_NUMBER_TABLE
3249 , p5_a3 JTF_NUMBER_TABLE
3250 , p5_a4 JTF_NUMBER_TABLE
3251 , p5_a5 JTF_VARCHAR2_TABLE_100
3252 , p5_a6 JTF_DATE_TABLE
3253 , p5_a7 JTF_VARCHAR2_TABLE_100
3254 , p5_a8 JTF_VARCHAR2_TABLE_100
3255 , p5_a9 JTF_DATE_TABLE
3256 , p5_a10 JTF_VARCHAR2_TABLE_100
3257 , p5_a11 JTF_NUMBER_TABLE
3258 , p5_a12 JTF_VARCHAR2_TABLE_100
3259 , p5_a13 JTF_DATE_TABLE
3260 , p5_a14 JTF_VARCHAR2_TABLE_100
3261 , p5_a15 JTF_VARCHAR2_TABLE_100
3262 , p5_a16 JTF_DATE_TABLE
3263 , p5_a17 JTF_DATE_TABLE
3264 , p5_a18 JTF_DATE_TABLE
3265 , p5_a19 JTF_DATE_TABLE
3266 , p5_a20 JTF_VARCHAR2_TABLE_100
3267 , p5_a21 JTF_VARCHAR2_TABLE_500
3268 , p5_a22 JTF_VARCHAR2_TABLE_500
3269 , p5_a23 JTF_VARCHAR2_TABLE_500
3270 , p5_a24 JTF_VARCHAR2_TABLE_500
3271 , p5_a25 JTF_VARCHAR2_TABLE_500
3272 , p5_a26 JTF_VARCHAR2_TABLE_500
3273 , p5_a27 JTF_VARCHAR2_TABLE_500
3274 , p5_a28 JTF_VARCHAR2_TABLE_500
3275 , p5_a29 JTF_VARCHAR2_TABLE_500
3276 , p5_a30 JTF_VARCHAR2_TABLE_500
3277 , p5_a31 JTF_VARCHAR2_TABLE_500
3278 , p5_a32 JTF_VARCHAR2_TABLE_500
3279 , p5_a33 JTF_VARCHAR2_TABLE_500
3280 , p5_a34 JTF_VARCHAR2_TABLE_500
3281 , p5_a35 JTF_VARCHAR2_TABLE_500
3282 , p5_a36 JTF_NUMBER_TABLE
3283 , p5_a37 JTF_DATE_TABLE
3284 , p5_a38 JTF_NUMBER_TABLE
3285 , p5_a39 JTF_DATE_TABLE
3286 , p5_a40 JTF_NUMBER_TABLE
3287 , p5_a41 JTF_NUMBER_TABLE
3288 , p5_a42 JTF_NUMBER_TABLE
3289 , p5_a43 JTF_NUMBER_TABLE
3290 , p5_a44 JTF_NUMBER_TABLE
3291 , p5_a45 JTF_NUMBER_TABLE
3292 , p5_a46 JTF_NUMBER_TABLE
3293 , p5_a47 JTF_NUMBER_TABLE
3294 , p5_a48 JTF_NUMBER_TABLE
3295 , p5_a49 JTF_DATE_TABLE
3296 , p5_a50 JTF_VARCHAR2_TABLE_100
3297 , p5_a51 JTF_NUMBER_TABLE
3298 , p5_a52 JTF_NUMBER_TABLE
3299 , p5_a53 JTF_DATE_TABLE
3300 , p5_a54 JTF_DATE_TABLE
3301 , p5_a55 JTF_VARCHAR2_TABLE_100
3302 , p5_a56 JTF_VARCHAR2_TABLE_100
3303 , p5_a57 JTF_VARCHAR2_TABLE_100
3304 , p5_a58 JTF_NUMBER_TABLE
3305 , p5_a59 JTF_DATE_TABLE
3306 , p5_a60 JTF_VARCHAR2_TABLE_100
3307 , p5_a61 JTF_VARCHAR2_TABLE_100
3308 , p5_a62 JTF_VARCHAR2_TABLE_100
3309 , p5_a63 JTF_VARCHAR2_TABLE_100
3310 , p5_a64 JTF_VARCHAR2_TABLE_100
3311 , p5_a65 JTF_VARCHAR2_TABLE_100
3312 )
3313
3314 as
3315 ddp_khrv_tbl okl_khr_pvt.khrv_tbl_type;
3316 ddindx binary_integer; indx binary_integer;
3317 begin
3318
3319 -- copy data to the local IN or IN-OUT args, if any
3320
3321
3322
3323
3324
3325 okl_khr_pvt_w.rosetta_table_copy_in_p8(ddp_khrv_tbl, p5_a0
3326 , p5_a1
3327 , p5_a2
3328 , p5_a3
3329 , p5_a4
3330 , p5_a5
3331 , p5_a6
3332 , p5_a7
3333 , p5_a8
3334 , p5_a9
3335 , p5_a10
3336 , p5_a11
3337 , p5_a12
3338 , p5_a13
3339 , p5_a14
3340 , p5_a15
3341 , p5_a16
3342 , p5_a17
3343 , p5_a18
3344 , p5_a19
3345 , p5_a20
3346 , p5_a21
3347 , p5_a22
3348 , p5_a23
3349 , p5_a24
3350 , p5_a25
3351 , p5_a26
3352 , p5_a27
3353 , p5_a28
3354 , p5_a29
3355 , p5_a30
3356 , p5_a31
3357 , p5_a32
3358 , p5_a33
3359 , p5_a34
3360 , p5_a35
3361 , p5_a36
3362 , p5_a37
3363 , p5_a38
3364 , p5_a39
3365 , p5_a40
3366 , p5_a41
3367 , p5_a42
3368 , p5_a43
3369 , p5_a44
3370 , p5_a45
3371 , p5_a46
3372 , p5_a47
3373 , p5_a48
3374 , p5_a49
3375 , p5_a50
3376 , p5_a51
3377 , p5_a52
3378 , p5_a53
3379 , p5_a54
3380 , p5_a55
3381 , p5_a56
3382 , p5_a57
3383 , p5_a58
3384 , p5_a59
3385 , p5_a60
3386 , p5_a61
3387 , p5_a62
3388 , p5_a63
3389 , p5_a64
3390 , p5_a65
3391 );
3392
3393 -- here's the delegated call to the old PL/SQL routine
3394 okl_khr_pvt.validate_row(p_api_version,
3395 p_init_msg_list,
3396 x_return_status,
3397 x_msg_count,
3398 x_msg_data,
3399 ddp_khrv_tbl);
3400
3401 -- copy data back from the local variables to OUT or IN-OUT args, if any
3402
3403
3404
3405
3406
3407 end;
3408
3409 procedure lock_row(p_api_version NUMBER
3410 , p_init_msg_list VARCHAR2
3411 , x_return_status out nocopy VARCHAR2
3412 , x_msg_count out nocopy NUMBER
3413 , x_msg_data out nocopy VARCHAR2
3414 , p5_a0 NUMBER := 0-1962.0724
3415 , p5_a1 NUMBER := 0-1962.0724
3416 , p5_a2 NUMBER := 0-1962.0724
3417 , p5_a3 NUMBER := 0-1962.0724
3418 , p5_a4 NUMBER := 0-1962.0724
3419 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
3420 , p5_a6 DATE := fnd_api.g_miss_date
3421 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
3422 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
3423 , p5_a9 DATE := fnd_api.g_miss_date
3424 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
3425 , p5_a11 NUMBER := 0-1962.0724
3426 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
3427 , p5_a13 DATE := fnd_api.g_miss_date
3428 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
3429 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
3430 , p5_a16 DATE := fnd_api.g_miss_date
3431 , p5_a17 DATE := fnd_api.g_miss_date
3432 , p5_a18 DATE := fnd_api.g_miss_date
3433 , p5_a19 DATE := fnd_api.g_miss_date
3434 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
3435 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
3436 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
3437 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
3438 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
3439 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
3440 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
3441 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
3442 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
3443 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
3444 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
3445 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
3446 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
3447 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
3448 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
3449 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
3450 , p5_a36 NUMBER := 0-1962.0724
3451 , p5_a37 DATE := fnd_api.g_miss_date
3452 , p5_a38 NUMBER := 0-1962.0724
3453 , p5_a39 DATE := fnd_api.g_miss_date
3454 , p5_a40 NUMBER := 0-1962.0724
3455 , p5_a41 NUMBER := 0-1962.0724
3456 , p5_a42 NUMBER := 0-1962.0724
3457 , p5_a43 NUMBER := 0-1962.0724
3458 , p5_a44 NUMBER := 0-1962.0724
3459 , p5_a45 NUMBER := 0-1962.0724
3460 , p5_a46 NUMBER := 0-1962.0724
3461 , p5_a47 NUMBER := 0-1962.0724
3462 , p5_a48 NUMBER := 0-1962.0724
3463 , p5_a49 DATE := fnd_api.g_miss_date
3464 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
3465 , p5_a51 NUMBER := 0-1962.0724
3466 , p5_a52 NUMBER := 0-1962.0724
3467 , p5_a53 DATE := fnd_api.g_miss_date
3468 , p5_a54 DATE := fnd_api.g_miss_date
3469 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
3470 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
3471 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
3472 , p5_a58 NUMBER := 0-1962.0724
3473 , p5_a59 DATE := fnd_api.g_miss_date
3474 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
3475 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
3476 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
3477 , p5_a63 VARCHAR2 := fnd_api.g_miss_char
3478 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
3479 , p5_a65 VARCHAR2 := fnd_api.g_miss_char
3480 )
3481
3482 as
3483 ddp_khrv_rec okl_khr_pvt.khrv_rec_type;
3484 ddindx binary_integer; indx binary_integer;
3485 begin
3486
3487 -- copy data to the local IN or IN-OUT args, if any
3488
3489
3490
3491
3492
3493 ddp_khrv_rec.id := rosetta_g_miss_num_map(p5_a0);
3494 ddp_khrv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
3495 ddp_khrv_rec.isg_id := rosetta_g_miss_num_map(p5_a2);
3496 ddp_khrv_rec.khr_id := rosetta_g_miss_num_map(p5_a3);
3497 ddp_khrv_rec.pdt_id := rosetta_g_miss_num_map(p5_a4);
3498 ddp_khrv_rec.amd_code := p5_a5;
3499 ddp_khrv_rec.date_first_activity := rosetta_g_miss_date_in_map(p5_a6);
3500 ddp_khrv_rec.generate_accrual_yn := p5_a7;
3501 ddp_khrv_rec.generate_accrual_override_yn := p5_a8;
3502 ddp_khrv_rec.date_refinanced := rosetta_g_miss_date_in_map(p5_a9);
3503 ddp_khrv_rec.credit_act_yn := p5_a10;
3504 ddp_khrv_rec.term_duration := rosetta_g_miss_num_map(p5_a11);
3505 ddp_khrv_rec.converted_account_yn := p5_a12;
3506 ddp_khrv_rec.date_conversion_effective := rosetta_g_miss_date_in_map(p5_a13);
3507 ddp_khrv_rec.syndicatable_yn := p5_a14;
3508 ddp_khrv_rec.salestype_yn := p5_a15;
3509 ddp_khrv_rec.date_deal_transferred := rosetta_g_miss_date_in_map(p5_a16);
3510 ddp_khrv_rec.datetime_proposal_effective := rosetta_g_miss_date_in_map(p5_a17);
3511 ddp_khrv_rec.datetime_proposal_ineffective := rosetta_g_miss_date_in_map(p5_a18);
3512 ddp_khrv_rec.date_proposal_accepted := rosetta_g_miss_date_in_map(p5_a19);
3513 ddp_khrv_rec.attribute_category := p5_a20;
3514 ddp_khrv_rec.attribute1 := p5_a21;
3515 ddp_khrv_rec.attribute2 := p5_a22;
3516 ddp_khrv_rec.attribute3 := p5_a23;
3517 ddp_khrv_rec.attribute4 := p5_a24;
3518 ddp_khrv_rec.attribute5 := p5_a25;
3519 ddp_khrv_rec.attribute6 := p5_a26;
3520 ddp_khrv_rec.attribute7 := p5_a27;
3521 ddp_khrv_rec.attribute8 := p5_a28;
3522 ddp_khrv_rec.attribute9 := p5_a29;
3523 ddp_khrv_rec.attribute10 := p5_a30;
3524 ddp_khrv_rec.attribute11 := p5_a31;
3525 ddp_khrv_rec.attribute12 := p5_a32;
3526 ddp_khrv_rec.attribute13 := p5_a33;
3527 ddp_khrv_rec.attribute14 := p5_a34;
3528 ddp_khrv_rec.attribute15 := p5_a35;
3529 ddp_khrv_rec.created_by := rosetta_g_miss_num_map(p5_a36);
3530 ddp_khrv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a37);
3531 ddp_khrv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a38);
3532 ddp_khrv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a39);
3533 ddp_khrv_rec.last_update_login := rosetta_g_miss_num_map(p5_a40);
3534 ddp_khrv_rec.pre_tax_yield := rosetta_g_miss_num_map(p5_a41);
3535 ddp_khrv_rec.after_tax_yield := rosetta_g_miss_num_map(p5_a42);
3536 ddp_khrv_rec.implicit_interest_rate := rosetta_g_miss_num_map(p5_a43);
3537 ddp_khrv_rec.implicit_non_idc_interest_rate := rosetta_g_miss_num_map(p5_a44);
3538 ddp_khrv_rec.target_pre_tax_yield := rosetta_g_miss_num_map(p5_a45);
3539 ddp_khrv_rec.target_after_tax_yield := rosetta_g_miss_num_map(p5_a46);
3540 ddp_khrv_rec.target_implicit_interest_rate := rosetta_g_miss_num_map(p5_a47);
3541 ddp_khrv_rec.target_implicit_nonidc_intrate := rosetta_g_miss_num_map(p5_a48);
3542 ddp_khrv_rec.date_last_interim_interest_cal := rosetta_g_miss_date_in_map(p5_a49);
3543 ddp_khrv_rec.deal_type := p5_a50;
3544 ddp_khrv_rec.pre_tax_irr := rosetta_g_miss_num_map(p5_a51);
3545 ddp_khrv_rec.after_tax_irr := rosetta_g_miss_num_map(p5_a52);
3546 ddp_khrv_rec.expected_delivery_date := rosetta_g_miss_date_in_map(p5_a53);
3547 ddp_khrv_rec.accepted_date := rosetta_g_miss_date_in_map(p5_a54);
3548 ddp_khrv_rec.prefunding_eligible_yn := p5_a55;
3549 ddp_khrv_rec.revolving_credit_yn := p5_a56;
3550 ddp_khrv_rec.currency_conversion_type := p5_a57;
3551 ddp_khrv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a58);
3552 ddp_khrv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a59);
3553 ddp_khrv_rec.multi_gaap_yn := p5_a60;
3554 ddp_khrv_rec.recourse_code := p5_a61;
3555 ddp_khrv_rec.lessor_serv_org_code := p5_a62;
3556 ddp_khrv_rec.assignable_yn := p5_a63;
3557 ddp_khrv_rec.securitized_code := p5_a64;
3558 ddp_khrv_rec.securitization_type := p5_a65;
3559
3560 -- here's the delegated call to the old PL/SQL routine
3561 okl_khr_pvt.lock_row(p_api_version,
3562 p_init_msg_list,
3563 x_return_status,
3564 x_msg_count,
3565 x_msg_data,
3566 ddp_khrv_rec);
3567
3568 -- copy data back from the local variables to OUT or IN-OUT args, if any
3569
3570
3571
3572
3573
3574 end;
3575
3576 procedure lock_row(p_api_version NUMBER
3577 , p_init_msg_list VARCHAR2
3578 , x_return_status out nocopy VARCHAR2
3579 , x_msg_count out nocopy NUMBER
3580 , x_msg_data out nocopy VARCHAR2
3581 , p5_a0 JTF_NUMBER_TABLE
3582 , p5_a1 JTF_NUMBER_TABLE
3583 , p5_a2 JTF_NUMBER_TABLE
3584 , p5_a3 JTF_NUMBER_TABLE
3585 , p5_a4 JTF_NUMBER_TABLE
3586 , p5_a5 JTF_VARCHAR2_TABLE_100
3587 , p5_a6 JTF_DATE_TABLE
3588 , p5_a7 JTF_VARCHAR2_TABLE_100
3589 , p5_a8 JTF_VARCHAR2_TABLE_100
3590 , p5_a9 JTF_DATE_TABLE
3591 , p5_a10 JTF_VARCHAR2_TABLE_100
3592 , p5_a11 JTF_NUMBER_TABLE
3593 , p5_a12 JTF_VARCHAR2_TABLE_100
3594 , p5_a13 JTF_DATE_TABLE
3595 , p5_a14 JTF_VARCHAR2_TABLE_100
3596 , p5_a15 JTF_VARCHAR2_TABLE_100
3597 , p5_a16 JTF_DATE_TABLE
3598 , p5_a17 JTF_DATE_TABLE
3599 , p5_a18 JTF_DATE_TABLE
3600 , p5_a19 JTF_DATE_TABLE
3601 , p5_a20 JTF_VARCHAR2_TABLE_100
3602 , p5_a21 JTF_VARCHAR2_TABLE_500
3603 , p5_a22 JTF_VARCHAR2_TABLE_500
3604 , p5_a23 JTF_VARCHAR2_TABLE_500
3605 , p5_a24 JTF_VARCHAR2_TABLE_500
3606 , p5_a25 JTF_VARCHAR2_TABLE_500
3607 , p5_a26 JTF_VARCHAR2_TABLE_500
3608 , p5_a27 JTF_VARCHAR2_TABLE_500
3609 , p5_a28 JTF_VARCHAR2_TABLE_500
3610 , p5_a29 JTF_VARCHAR2_TABLE_500
3611 , p5_a30 JTF_VARCHAR2_TABLE_500
3612 , p5_a31 JTF_VARCHAR2_TABLE_500
3613 , p5_a32 JTF_VARCHAR2_TABLE_500
3614 , p5_a33 JTF_VARCHAR2_TABLE_500
3615 , p5_a34 JTF_VARCHAR2_TABLE_500
3616 , p5_a35 JTF_VARCHAR2_TABLE_500
3617 , p5_a36 JTF_NUMBER_TABLE
3618 , p5_a37 JTF_DATE_TABLE
3619 , p5_a38 JTF_NUMBER_TABLE
3620 , p5_a39 JTF_DATE_TABLE
3621 , p5_a40 JTF_NUMBER_TABLE
3622 , p5_a41 JTF_NUMBER_TABLE
3623 , p5_a42 JTF_NUMBER_TABLE
3624 , p5_a43 JTF_NUMBER_TABLE
3625 , p5_a44 JTF_NUMBER_TABLE
3626 , p5_a45 JTF_NUMBER_TABLE
3627 , p5_a46 JTF_NUMBER_TABLE
3628 , p5_a47 JTF_NUMBER_TABLE
3629 , p5_a48 JTF_NUMBER_TABLE
3630 , p5_a49 JTF_DATE_TABLE
3631 , p5_a50 JTF_VARCHAR2_TABLE_100
3632 , p5_a51 JTF_NUMBER_TABLE
3633 , p5_a52 JTF_NUMBER_TABLE
3634 , p5_a53 JTF_DATE_TABLE
3635 , p5_a54 JTF_DATE_TABLE
3636 , p5_a55 JTF_VARCHAR2_TABLE_100
3637 , p5_a56 JTF_VARCHAR2_TABLE_100
3638 , p5_a57 JTF_VARCHAR2_TABLE_100
3639 , p5_a58 JTF_NUMBER_TABLE
3640 , p5_a59 JTF_DATE_TABLE
3641 , p5_a60 JTF_VARCHAR2_TABLE_100
3642 , p5_a61 JTF_VARCHAR2_TABLE_100
3643 , p5_a62 JTF_VARCHAR2_TABLE_100
3644 , p5_a63 JTF_VARCHAR2_TABLE_100
3645 , p5_a64 JTF_VARCHAR2_TABLE_100
3646 , p5_a65 JTF_VARCHAR2_TABLE_100
3647 )
3648
3649 as
3650 ddp_khrv_tbl okl_khr_pvt.khrv_tbl_type;
3651 ddindx binary_integer; indx binary_integer;
3652 begin
3653
3654 -- copy data to the local IN or IN-OUT args, if any
3655
3656
3657
3658
3659
3660 okl_khr_pvt_w.rosetta_table_copy_in_p8(ddp_khrv_tbl, p5_a0
3661 , p5_a1
3662 , p5_a2
3663 , p5_a3
3664 , p5_a4
3665 , p5_a5
3666 , p5_a6
3667 , p5_a7
3668 , p5_a8
3669 , p5_a9
3670 , p5_a10
3671 , p5_a11
3672 , p5_a12
3673 , p5_a13
3674 , p5_a14
3675 , p5_a15
3676 , p5_a16
3677 , p5_a17
3678 , p5_a18
3679 , p5_a19
3680 , p5_a20
3681 , p5_a21
3682 , p5_a22
3683 , p5_a23
3684 , p5_a24
3685 , p5_a25
3686 , p5_a26
3687 , p5_a27
3688 , p5_a28
3689 , p5_a29
3690 , p5_a30
3691 , p5_a31
3692 , p5_a32
3693 , p5_a33
3694 , p5_a34
3695 , p5_a35
3696 , p5_a36
3697 , p5_a37
3698 , p5_a38
3699 , p5_a39
3700 , p5_a40
3701 , p5_a41
3702 , p5_a42
3703 , p5_a43
3704 , p5_a44
3705 , p5_a45
3706 , p5_a46
3707 , p5_a47
3708 , p5_a48
3709 , p5_a49
3710 , p5_a50
3711 , p5_a51
3712 , p5_a52
3713 , p5_a53
3714 , p5_a54
3715 , p5_a55
3716 , p5_a56
3717 , p5_a57
3718 , p5_a58
3719 , p5_a59
3720 , p5_a60
3721 , p5_a61
3722 , p5_a62
3723 , p5_a63
3724 , p5_a64
3725 , p5_a65
3726 );
3727
3728 -- here's the delegated call to the old PL/SQL routine
3729 okl_khr_pvt.lock_row(p_api_version,
3730 p_init_msg_list,
3731 x_return_status,
3732 x_msg_count,
3733 x_msg_data,
3734 ddp_khrv_tbl);
3735
3736 -- copy data back from the local variables to OUT or IN-OUT args, if any
3737
3738
3739
3740
3741
3742 end;
3743
3744 end okl_khr_pvt_w;