[Home] [Help]
PACKAGE BODY: APPS.OKL_SIL_PVT_W
Source
1 package body okl_sil_pvt_w as
2 /* $Header: OKLISILB.pls 120.2 2005/10/11 06:38:16 rgooty 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_sil_pvt.sil_tbl_type, a0 JTF_NUMBER_TABLE
23 , a1 JTF_NUMBER_TABLE
24 , a2 JTF_NUMBER_TABLE
25 , a3 JTF_VARCHAR2_TABLE_100
26 , a4 JTF_DATE_TABLE
27 , a5 JTF_NUMBER_TABLE
28 , a6 JTF_NUMBER_TABLE
29 , a7 JTF_VARCHAR2_TABLE_100
30 , a8 JTF_NUMBER_TABLE
31 , a9 JTF_VARCHAR2_TABLE_100
32 , a10 JTF_VARCHAR2_TABLE_100
33 , a11 JTF_NUMBER_TABLE
34 , a12 JTF_NUMBER_TABLE
35 , a13 JTF_NUMBER_TABLE
36 , a14 JTF_VARCHAR2_TABLE_100
37 , a15 JTF_VARCHAR2_TABLE_100
38 , a16 JTF_NUMBER_TABLE
39 , a17 JTF_NUMBER_TABLE
40 , a18 JTF_DATE_TABLE
41 , a19 JTF_NUMBER_TABLE
42 , a20 JTF_VARCHAR2_TABLE_100
43 , a21 JTF_NUMBER_TABLE
44 , a22 JTF_NUMBER_TABLE
45 , a23 JTF_NUMBER_TABLE
46 , a24 JTF_DATE_TABLE
47 , a25 JTF_NUMBER_TABLE
48 , a26 JTF_NUMBER_TABLE
49 , a27 JTF_DATE_TABLE
50 , a28 JTF_DATE_TABLE
51 , a29 JTF_DATE_TABLE
52 , a30 JTF_VARCHAR2_TABLE_100
53 , a31 JTF_VARCHAR2_TABLE_500
54 , a32 JTF_VARCHAR2_TABLE_500
55 , a33 JTF_VARCHAR2_TABLE_500
56 , a34 JTF_NUMBER_TABLE
57 , a35 JTF_VARCHAR2_TABLE_500
58 , a36 JTF_VARCHAR2_TABLE_2000
59 , a37 JTF_VARCHAR2_TABLE_500
60 , a38 JTF_VARCHAR2_TABLE_500
61 , a39 JTF_VARCHAR2_TABLE_500
62 , a40 JTF_VARCHAR2_TABLE_500
63 , a41 JTF_VARCHAR2_TABLE_500
64 , a42 JTF_VARCHAR2_TABLE_500
65 , a43 JTF_VARCHAR2_TABLE_500
66 , a44 JTF_VARCHAR2_TABLE_500
67 , a45 JTF_VARCHAR2_TABLE_500
68 , a46 JTF_VARCHAR2_TABLE_500
69 , a47 JTF_VARCHAR2_TABLE_500
70 , a48 JTF_DATE_TABLE
71 , a49 JTF_DATE_TABLE
72 , a50 JTF_NUMBER_TABLE
73 , a51 JTF_NUMBER_TABLE
74 , a52 JTF_NUMBER_TABLE
75 , a53 JTF_VARCHAR2_TABLE_100
76 , a54 JTF_NUMBER_TABLE
77 , a55 JTF_NUMBER_TABLE
78 , a56 JTF_DATE_TABLE
79 , a57 JTF_DATE_TABLE
80 , a58 JTF_NUMBER_TABLE
81 , a59 JTF_VARCHAR2_TABLE_200
82 , a60 JTF_NUMBER_TABLE
83 , a61 JTF_VARCHAR2_TABLE_100
84 ) as
85 ddindx binary_integer; indx binary_integer;
86 begin
87 if a0 is not null and a0.count > 0 then
88 if a0.count > 0 then
89 indx := a0.first;
90 ddindx := 1;
91 while true loop
92 t(ddindx).id := rosetta_g_miss_num_map(a0(indx));
93 t(ddindx).state_depre_dmnshing_value_rt := rosetta_g_miss_num_map(a1(indx));
94 t(ddindx).book_depre_dmnshing_value_rt := rosetta_g_miss_num_map(a2(indx));
95 t(ddindx).residual_guarantee_method := a3(indx);
96 t(ddindx).residual_date := rosetta_g_miss_date_in_map(a4(indx));
97 t(ddindx).fed_depre_term := rosetta_g_miss_num_map(a5(indx));
98 t(ddindx).fed_depre_dmnshing_value_rate := rosetta_g_miss_num_map(a6(indx));
99 t(ddindx).fed_depre_adr_conve := a7(indx);
100 t(ddindx).state_depre_basis_percent := rosetta_g_miss_num_map(a8(indx));
101 t(ddindx).state_depre_method := a9(indx);
102 t(ddindx).purchase_option := a10(indx);
103 t(ddindx).purchase_option_amount := rosetta_g_miss_num_map(a11(indx));
104 t(ddindx).asset_cost := rosetta_g_miss_num_map(a12(indx));
105 t(ddindx).state_depre_term := rosetta_g_miss_num_map(a13(indx));
106 t(ddindx).state_depre_adr_convent := a14(indx);
107 t(ddindx).fed_depre_method := a15(indx);
108 t(ddindx).residual_amount := rosetta_g_miss_num_map(a16(indx));
109 t(ddindx).fed_depre_salvage := rosetta_g_miss_num_map(a17(indx));
110 t(ddindx).date_fed_depre := rosetta_g_miss_date_in_map(a18(indx));
111 t(ddindx).book_salvage := rosetta_g_miss_num_map(a19(indx));
112 t(ddindx).book_adr_convention := a20(indx);
113 t(ddindx).state_depre_salvage := rosetta_g_miss_num_map(a21(indx));
114 t(ddindx).fed_depre_basis_percent := rosetta_g_miss_num_map(a22(indx));
115 t(ddindx).book_basis_percent := rosetta_g_miss_num_map(a23(indx));
116 t(ddindx).date_delivery := rosetta_g_miss_date_in_map(a24(indx));
117 t(ddindx).book_term := rosetta_g_miss_num_map(a25(indx));
118 t(ddindx).residual_guarantee_amount := rosetta_g_miss_num_map(a26(indx));
119 t(ddindx).date_funding := rosetta_g_miss_date_in_map(a27(indx));
120 t(ddindx).date_book := rosetta_g_miss_date_in_map(a28(indx));
121 t(ddindx).date_state_depre := rosetta_g_miss_date_in_map(a29(indx));
122 t(ddindx).book_method := a30(indx);
123 t(ddindx).stream_interface_attribute08 := a31(indx);
124 t(ddindx).stream_interface_attribute03 := a32(indx);
125 t(ddindx).stream_interface_attribute01 := a33(indx);
126 t(ddindx).index_number := rosetta_g_miss_num_map(a34(indx));
127 t(ddindx).stream_interface_attribute05 := a35(indx);
128 t(ddindx).description := a36(indx);
129 t(ddindx).stream_interface_attribute10 := a37(indx);
130 t(ddindx).stream_interface_attribute06 := a38(indx);
131 t(ddindx).stream_interface_attribute09 := a39(indx);
132 t(ddindx).stream_interface_attribute07 := a40(indx);
133 t(ddindx).stream_interface_attribute14 := a41(indx);
134 t(ddindx).stream_interface_attribute12 := a42(indx);
135 t(ddindx).stream_interface_attribute15 := a43(indx);
136 t(ddindx).stream_interface_attribute02 := a44(indx);
137 t(ddindx).stream_interface_attribute11 := a45(indx);
138 t(ddindx).stream_interface_attribute04 := a46(indx);
139 t(ddindx).stream_interface_attribute13 := a47(indx);
140 t(ddindx).date_start := rosetta_g_miss_date_in_map(a48(indx));
141 t(ddindx).date_lending := rosetta_g_miss_date_in_map(a49(indx));
142 t(ddindx).sif_id := rosetta_g_miss_num_map(a50(indx));
143 t(ddindx).object_version_number := rosetta_g_miss_num_map(a51(indx));
144 t(ddindx).kle_id := rosetta_g_miss_num_map(a52(indx));
145 t(ddindx).sil_type := a53(indx);
146 t(ddindx).created_by := rosetta_g_miss_num_map(a54(indx));
147 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a55(indx));
148 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a56(indx));
149 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a57(indx));
150 t(ddindx).last_update_login := rosetta_g_miss_num_map(a58(indx));
151 t(ddindx).residual_guarantee_type := a59(indx);
152 t(ddindx).down_payment_amount := rosetta_g_miss_num_map(a60(indx));
153 t(ddindx).capitalize_down_payment_yn := a61(indx);
154 ddindx := ddindx+1;
155 if a0.last =indx
156 then exit;
157 end if;
158 indx := a0.next(indx);
159 end loop;
160 end if;
161 end if;
162 end rosetta_table_copy_in_p2;
163 procedure rosetta_table_copy_out_p2(t okl_sil_pvt.sil_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
164 , a1 out nocopy JTF_NUMBER_TABLE
165 , a2 out nocopy JTF_NUMBER_TABLE
166 , a3 out nocopy JTF_VARCHAR2_TABLE_100
167 , a4 out nocopy JTF_DATE_TABLE
168 , a5 out nocopy JTF_NUMBER_TABLE
169 , a6 out nocopy JTF_NUMBER_TABLE
170 , a7 out nocopy JTF_VARCHAR2_TABLE_100
171 , a8 out nocopy JTF_NUMBER_TABLE
172 , a9 out nocopy JTF_VARCHAR2_TABLE_100
173 , a10 out nocopy JTF_VARCHAR2_TABLE_100
174 , a11 out nocopy JTF_NUMBER_TABLE
175 , a12 out nocopy JTF_NUMBER_TABLE
176 , a13 out nocopy JTF_NUMBER_TABLE
177 , a14 out nocopy JTF_VARCHAR2_TABLE_100
178 , a15 out nocopy JTF_VARCHAR2_TABLE_100
179 , a16 out nocopy JTF_NUMBER_TABLE
180 , a17 out nocopy JTF_NUMBER_TABLE
181 , a18 out nocopy JTF_DATE_TABLE
182 , a19 out nocopy JTF_NUMBER_TABLE
183 , a20 out nocopy JTF_VARCHAR2_TABLE_100
184 , a21 out nocopy JTF_NUMBER_TABLE
185 , a22 out nocopy JTF_NUMBER_TABLE
186 , a23 out nocopy JTF_NUMBER_TABLE
187 , a24 out nocopy JTF_DATE_TABLE
188 , a25 out nocopy JTF_NUMBER_TABLE
189 , a26 out nocopy JTF_NUMBER_TABLE
190 , a27 out nocopy JTF_DATE_TABLE
191 , a28 out nocopy JTF_DATE_TABLE
192 , a29 out nocopy JTF_DATE_TABLE
193 , a30 out nocopy JTF_VARCHAR2_TABLE_100
194 , a31 out nocopy JTF_VARCHAR2_TABLE_500
195 , a32 out nocopy JTF_VARCHAR2_TABLE_500
196 , a33 out nocopy JTF_VARCHAR2_TABLE_500
197 , a34 out nocopy JTF_NUMBER_TABLE
198 , a35 out nocopy JTF_VARCHAR2_TABLE_500
199 , a36 out nocopy JTF_VARCHAR2_TABLE_2000
200 , a37 out nocopy JTF_VARCHAR2_TABLE_500
201 , a38 out nocopy JTF_VARCHAR2_TABLE_500
202 , a39 out nocopy JTF_VARCHAR2_TABLE_500
203 , a40 out nocopy JTF_VARCHAR2_TABLE_500
204 , a41 out nocopy JTF_VARCHAR2_TABLE_500
205 , a42 out nocopy JTF_VARCHAR2_TABLE_500
206 , a43 out nocopy JTF_VARCHAR2_TABLE_500
207 , a44 out nocopy JTF_VARCHAR2_TABLE_500
208 , a45 out nocopy JTF_VARCHAR2_TABLE_500
209 , a46 out nocopy JTF_VARCHAR2_TABLE_500
210 , a47 out nocopy JTF_VARCHAR2_TABLE_500
211 , a48 out nocopy JTF_DATE_TABLE
212 , a49 out nocopy JTF_DATE_TABLE
213 , a50 out nocopy JTF_NUMBER_TABLE
214 , a51 out nocopy JTF_NUMBER_TABLE
215 , a52 out nocopy JTF_NUMBER_TABLE
216 , a53 out nocopy JTF_VARCHAR2_TABLE_100
217 , a54 out nocopy JTF_NUMBER_TABLE
218 , a55 out nocopy JTF_NUMBER_TABLE
219 , a56 out nocopy JTF_DATE_TABLE
220 , a57 out nocopy JTF_DATE_TABLE
221 , a58 out nocopy JTF_NUMBER_TABLE
222 , a59 out nocopy JTF_VARCHAR2_TABLE_200
223 , a60 out nocopy JTF_NUMBER_TABLE
224 , a61 out nocopy JTF_VARCHAR2_TABLE_100
225 ) as
226 ddindx binary_integer; indx binary_integer;
227 begin
228 if t is null or t.count = 0 then
229 a0 := JTF_NUMBER_TABLE();
230 a1 := JTF_NUMBER_TABLE();
231 a2 := JTF_NUMBER_TABLE();
232 a3 := JTF_VARCHAR2_TABLE_100();
233 a4 := JTF_DATE_TABLE();
234 a5 := JTF_NUMBER_TABLE();
235 a6 := JTF_NUMBER_TABLE();
236 a7 := JTF_VARCHAR2_TABLE_100();
237 a8 := JTF_NUMBER_TABLE();
238 a9 := JTF_VARCHAR2_TABLE_100();
239 a10 := JTF_VARCHAR2_TABLE_100();
240 a11 := JTF_NUMBER_TABLE();
241 a12 := JTF_NUMBER_TABLE();
242 a13 := JTF_NUMBER_TABLE();
243 a14 := JTF_VARCHAR2_TABLE_100();
244 a15 := JTF_VARCHAR2_TABLE_100();
245 a16 := JTF_NUMBER_TABLE();
246 a17 := JTF_NUMBER_TABLE();
247 a18 := JTF_DATE_TABLE();
248 a19 := JTF_NUMBER_TABLE();
249 a20 := JTF_VARCHAR2_TABLE_100();
250 a21 := JTF_NUMBER_TABLE();
251 a22 := JTF_NUMBER_TABLE();
252 a23 := JTF_NUMBER_TABLE();
253 a24 := JTF_DATE_TABLE();
254 a25 := JTF_NUMBER_TABLE();
255 a26 := JTF_NUMBER_TABLE();
256 a27 := JTF_DATE_TABLE();
257 a28 := JTF_DATE_TABLE();
258 a29 := JTF_DATE_TABLE();
259 a30 := JTF_VARCHAR2_TABLE_100();
260 a31 := JTF_VARCHAR2_TABLE_500();
261 a32 := JTF_VARCHAR2_TABLE_500();
262 a33 := JTF_VARCHAR2_TABLE_500();
263 a34 := JTF_NUMBER_TABLE();
264 a35 := JTF_VARCHAR2_TABLE_500();
265 a36 := JTF_VARCHAR2_TABLE_2000();
266 a37 := JTF_VARCHAR2_TABLE_500();
267 a38 := JTF_VARCHAR2_TABLE_500();
268 a39 := JTF_VARCHAR2_TABLE_500();
269 a40 := JTF_VARCHAR2_TABLE_500();
270 a41 := JTF_VARCHAR2_TABLE_500();
271 a42 := JTF_VARCHAR2_TABLE_500();
272 a43 := JTF_VARCHAR2_TABLE_500();
273 a44 := JTF_VARCHAR2_TABLE_500();
274 a45 := JTF_VARCHAR2_TABLE_500();
275 a46 := JTF_VARCHAR2_TABLE_500();
276 a47 := JTF_VARCHAR2_TABLE_500();
277 a48 := JTF_DATE_TABLE();
278 a49 := JTF_DATE_TABLE();
279 a50 := JTF_NUMBER_TABLE();
280 a51 := JTF_NUMBER_TABLE();
281 a52 := JTF_NUMBER_TABLE();
282 a53 := JTF_VARCHAR2_TABLE_100();
283 a54 := JTF_NUMBER_TABLE();
284 a55 := JTF_NUMBER_TABLE();
285 a56 := JTF_DATE_TABLE();
286 a57 := JTF_DATE_TABLE();
287 a58 := JTF_NUMBER_TABLE();
288 a59 := JTF_VARCHAR2_TABLE_200();
289 a60 := JTF_NUMBER_TABLE();
290 a61 := JTF_VARCHAR2_TABLE_100();
291 else
292 a0 := JTF_NUMBER_TABLE();
293 a1 := JTF_NUMBER_TABLE();
294 a2 := JTF_NUMBER_TABLE();
295 a3 := JTF_VARCHAR2_TABLE_100();
296 a4 := JTF_DATE_TABLE();
297 a5 := JTF_NUMBER_TABLE();
298 a6 := JTF_NUMBER_TABLE();
299 a7 := JTF_VARCHAR2_TABLE_100();
300 a8 := JTF_NUMBER_TABLE();
301 a9 := JTF_VARCHAR2_TABLE_100();
302 a10 := JTF_VARCHAR2_TABLE_100();
303 a11 := JTF_NUMBER_TABLE();
304 a12 := JTF_NUMBER_TABLE();
305 a13 := JTF_NUMBER_TABLE();
306 a14 := JTF_VARCHAR2_TABLE_100();
307 a15 := JTF_VARCHAR2_TABLE_100();
308 a16 := JTF_NUMBER_TABLE();
309 a17 := JTF_NUMBER_TABLE();
310 a18 := JTF_DATE_TABLE();
311 a19 := JTF_NUMBER_TABLE();
312 a20 := JTF_VARCHAR2_TABLE_100();
313 a21 := JTF_NUMBER_TABLE();
314 a22 := JTF_NUMBER_TABLE();
315 a23 := JTF_NUMBER_TABLE();
316 a24 := JTF_DATE_TABLE();
317 a25 := JTF_NUMBER_TABLE();
318 a26 := JTF_NUMBER_TABLE();
319 a27 := JTF_DATE_TABLE();
320 a28 := JTF_DATE_TABLE();
321 a29 := JTF_DATE_TABLE();
322 a30 := JTF_VARCHAR2_TABLE_100();
323 a31 := JTF_VARCHAR2_TABLE_500();
324 a32 := JTF_VARCHAR2_TABLE_500();
325 a33 := JTF_VARCHAR2_TABLE_500();
326 a34 := JTF_NUMBER_TABLE();
327 a35 := JTF_VARCHAR2_TABLE_500();
328 a36 := JTF_VARCHAR2_TABLE_2000();
329 a37 := JTF_VARCHAR2_TABLE_500();
330 a38 := JTF_VARCHAR2_TABLE_500();
331 a39 := JTF_VARCHAR2_TABLE_500();
332 a40 := JTF_VARCHAR2_TABLE_500();
333 a41 := JTF_VARCHAR2_TABLE_500();
334 a42 := JTF_VARCHAR2_TABLE_500();
335 a43 := JTF_VARCHAR2_TABLE_500();
336 a44 := JTF_VARCHAR2_TABLE_500();
337 a45 := JTF_VARCHAR2_TABLE_500();
338 a46 := JTF_VARCHAR2_TABLE_500();
339 a47 := JTF_VARCHAR2_TABLE_500();
340 a48 := JTF_DATE_TABLE();
341 a49 := JTF_DATE_TABLE();
342 a50 := JTF_NUMBER_TABLE();
343 a51 := JTF_NUMBER_TABLE();
344 a52 := JTF_NUMBER_TABLE();
345 a53 := JTF_VARCHAR2_TABLE_100();
346 a54 := JTF_NUMBER_TABLE();
347 a55 := JTF_NUMBER_TABLE();
348 a56 := JTF_DATE_TABLE();
349 a57 := JTF_DATE_TABLE();
350 a58 := JTF_NUMBER_TABLE();
351 a59 := JTF_VARCHAR2_TABLE_200();
352 a60 := JTF_NUMBER_TABLE();
353 a61 := JTF_VARCHAR2_TABLE_100();
354 if t.count > 0 then
355 a0.extend(t.count);
356 a1.extend(t.count);
357 a2.extend(t.count);
358 a3.extend(t.count);
359 a4.extend(t.count);
360 a5.extend(t.count);
361 a6.extend(t.count);
362 a7.extend(t.count);
363 a8.extend(t.count);
364 a9.extend(t.count);
365 a10.extend(t.count);
366 a11.extend(t.count);
367 a12.extend(t.count);
368 a13.extend(t.count);
369 a14.extend(t.count);
370 a15.extend(t.count);
371 a16.extend(t.count);
372 a17.extend(t.count);
373 a18.extend(t.count);
374 a19.extend(t.count);
375 a20.extend(t.count);
376 a21.extend(t.count);
377 a22.extend(t.count);
378 a23.extend(t.count);
379 a24.extend(t.count);
380 a25.extend(t.count);
381 a26.extend(t.count);
382 a27.extend(t.count);
383 a28.extend(t.count);
384 a29.extend(t.count);
385 a30.extend(t.count);
386 a31.extend(t.count);
387 a32.extend(t.count);
388 a33.extend(t.count);
389 a34.extend(t.count);
390 a35.extend(t.count);
391 a36.extend(t.count);
392 a37.extend(t.count);
393 a38.extend(t.count);
394 a39.extend(t.count);
395 a40.extend(t.count);
396 a41.extend(t.count);
397 a42.extend(t.count);
398 a43.extend(t.count);
399 a44.extend(t.count);
400 a45.extend(t.count);
401 a46.extend(t.count);
402 a47.extend(t.count);
403 a48.extend(t.count);
404 a49.extend(t.count);
405 a50.extend(t.count);
406 a51.extend(t.count);
407 a52.extend(t.count);
408 a53.extend(t.count);
409 a54.extend(t.count);
410 a55.extend(t.count);
411 a56.extend(t.count);
412 a57.extend(t.count);
413 a58.extend(t.count);
414 a59.extend(t.count);
415 a60.extend(t.count);
416 a61.extend(t.count);
417 ddindx := t.first;
418 indx := 1;
419 while true loop
420 a0(indx) := rosetta_g_miss_num_map(t(ddindx).id);
421 a1(indx) := rosetta_g_miss_num_map(t(ddindx).state_depre_dmnshing_value_rt);
422 a2(indx) := rosetta_g_miss_num_map(t(ddindx).book_depre_dmnshing_value_rt);
423 a3(indx) := t(ddindx).residual_guarantee_method;
424 a4(indx) := t(ddindx).residual_date;
425 a5(indx) := rosetta_g_miss_num_map(t(ddindx).fed_depre_term);
426 a6(indx) := rosetta_g_miss_num_map(t(ddindx).fed_depre_dmnshing_value_rate);
427 a7(indx) := t(ddindx).fed_depre_adr_conve;
428 a8(indx) := rosetta_g_miss_num_map(t(ddindx).state_depre_basis_percent);
429 a9(indx) := t(ddindx).state_depre_method;
430 a10(indx) := t(ddindx).purchase_option;
431 a11(indx) := rosetta_g_miss_num_map(t(ddindx).purchase_option_amount);
432 a12(indx) := rosetta_g_miss_num_map(t(ddindx).asset_cost);
433 a13(indx) := rosetta_g_miss_num_map(t(ddindx).state_depre_term);
434 a14(indx) := t(ddindx).state_depre_adr_convent;
435 a15(indx) := t(ddindx).fed_depre_method;
436 a16(indx) := rosetta_g_miss_num_map(t(ddindx).residual_amount);
437 a17(indx) := rosetta_g_miss_num_map(t(ddindx).fed_depre_salvage);
438 a18(indx) := t(ddindx).date_fed_depre;
439 a19(indx) := rosetta_g_miss_num_map(t(ddindx).book_salvage);
440 a20(indx) := t(ddindx).book_adr_convention;
441 a21(indx) := rosetta_g_miss_num_map(t(ddindx).state_depre_salvage);
442 a22(indx) := rosetta_g_miss_num_map(t(ddindx).fed_depre_basis_percent);
443 a23(indx) := rosetta_g_miss_num_map(t(ddindx).book_basis_percent);
444 a24(indx) := t(ddindx).date_delivery;
445 a25(indx) := rosetta_g_miss_num_map(t(ddindx).book_term);
446 a26(indx) := rosetta_g_miss_num_map(t(ddindx).residual_guarantee_amount);
447 a27(indx) := t(ddindx).date_funding;
448 a28(indx) := t(ddindx).date_book;
449 a29(indx) := t(ddindx).date_state_depre;
450 a30(indx) := t(ddindx).book_method;
451 a31(indx) := t(ddindx).stream_interface_attribute08;
452 a32(indx) := t(ddindx).stream_interface_attribute03;
453 a33(indx) := t(ddindx).stream_interface_attribute01;
454 a34(indx) := rosetta_g_miss_num_map(t(ddindx).index_number);
455 a35(indx) := t(ddindx).stream_interface_attribute05;
456 a36(indx) := t(ddindx).description;
457 a37(indx) := t(ddindx).stream_interface_attribute10;
458 a38(indx) := t(ddindx).stream_interface_attribute06;
459 a39(indx) := t(ddindx).stream_interface_attribute09;
460 a40(indx) := t(ddindx).stream_interface_attribute07;
461 a41(indx) := t(ddindx).stream_interface_attribute14;
462 a42(indx) := t(ddindx).stream_interface_attribute12;
463 a43(indx) := t(ddindx).stream_interface_attribute15;
464 a44(indx) := t(ddindx).stream_interface_attribute02;
465 a45(indx) := t(ddindx).stream_interface_attribute11;
466 a46(indx) := t(ddindx).stream_interface_attribute04;
467 a47(indx) := t(ddindx).stream_interface_attribute13;
468 a48(indx) := t(ddindx).date_start;
469 a49(indx) := t(ddindx).date_lending;
470 a50(indx) := rosetta_g_miss_num_map(t(ddindx).sif_id);
471 a51(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
472 a52(indx) := rosetta_g_miss_num_map(t(ddindx).kle_id);
473 a53(indx) := t(ddindx).sil_type;
474 a54(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
475 a55(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
476 a56(indx) := t(ddindx).creation_date;
477 a57(indx) := t(ddindx).last_update_date;
478 a58(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
479 a59(indx) := t(ddindx).residual_guarantee_type;
480 a60(indx) := rosetta_g_miss_num_map(t(ddindx).down_payment_amount);
481 a61(indx) := t(ddindx).capitalize_down_payment_yn;
482 indx := indx+1;
483 if t.last =ddindx
484 then exit;
485 end if;
486 ddindx := t.next(ddindx);
487 end loop;
488 end if;
489 end if;
490 end rosetta_table_copy_out_p2;
491
492 procedure rosetta_table_copy_in_p5(t out nocopy okl_sil_pvt.silv_tbl_type, a0 JTF_NUMBER_TABLE
493 , a1 JTF_NUMBER_TABLE
494 , a2 JTF_NUMBER_TABLE
495 , a3 JTF_VARCHAR2_TABLE_100
496 , a4 JTF_DATE_TABLE
497 , a5 JTF_NUMBER_TABLE
498 , a6 JTF_NUMBER_TABLE
499 , a7 JTF_VARCHAR2_TABLE_100
500 , a8 JTF_NUMBER_TABLE
501 , a9 JTF_VARCHAR2_TABLE_100
502 , a10 JTF_VARCHAR2_TABLE_100
503 , a11 JTF_NUMBER_TABLE
504 , a12 JTF_NUMBER_TABLE
505 , a13 JTF_NUMBER_TABLE
506 , a14 JTF_VARCHAR2_TABLE_100
507 , a15 JTF_VARCHAR2_TABLE_100
508 , a16 JTF_NUMBER_TABLE
509 , a17 JTF_NUMBER_TABLE
510 , a18 JTF_DATE_TABLE
511 , a19 JTF_NUMBER_TABLE
512 , a20 JTF_VARCHAR2_TABLE_100
513 , a21 JTF_NUMBER_TABLE
514 , a22 JTF_NUMBER_TABLE
515 , a23 JTF_NUMBER_TABLE
516 , a24 JTF_DATE_TABLE
517 , a25 JTF_NUMBER_TABLE
518 , a26 JTF_NUMBER_TABLE
519 , a27 JTF_DATE_TABLE
520 , a28 JTF_DATE_TABLE
521 , a29 JTF_DATE_TABLE
522 , a30 JTF_VARCHAR2_TABLE_100
523 , a31 JTF_VARCHAR2_TABLE_500
524 , a32 JTF_VARCHAR2_TABLE_500
525 , a33 JTF_VARCHAR2_TABLE_500
526 , a34 JTF_NUMBER_TABLE
527 , a35 JTF_VARCHAR2_TABLE_500
528 , a36 JTF_VARCHAR2_TABLE_2000
529 , a37 JTF_VARCHAR2_TABLE_500
530 , a38 JTF_VARCHAR2_TABLE_500
531 , a39 JTF_VARCHAR2_TABLE_500
532 , a40 JTF_VARCHAR2_TABLE_500
533 , a41 JTF_VARCHAR2_TABLE_500
534 , a42 JTF_VARCHAR2_TABLE_500
535 , a43 JTF_VARCHAR2_TABLE_500
536 , a44 JTF_VARCHAR2_TABLE_500
537 , a45 JTF_VARCHAR2_TABLE_500
538 , a46 JTF_VARCHAR2_TABLE_500
539 , a47 JTF_VARCHAR2_TABLE_500
540 , a48 JTF_DATE_TABLE
541 , a49 JTF_DATE_TABLE
542 , a50 JTF_NUMBER_TABLE
543 , a51 JTF_NUMBER_TABLE
544 , a52 JTF_NUMBER_TABLE
545 , a53 JTF_VARCHAR2_TABLE_100
546 , a54 JTF_NUMBER_TABLE
547 , a55 JTF_NUMBER_TABLE
548 , a56 JTF_DATE_TABLE
549 , a57 JTF_DATE_TABLE
550 , a58 JTF_NUMBER_TABLE
551 , a59 JTF_VARCHAR2_TABLE_200
552 , a60 JTF_NUMBER_TABLE
553 , a61 JTF_VARCHAR2_TABLE_100
554 ) as
555 ddindx binary_integer; indx binary_integer;
556 begin
557 if a0 is not null and a0.count > 0 then
558 if a0.count > 0 then
559 indx := a0.first;
560 ddindx := 1;
561 while true loop
562 t(ddindx).id := rosetta_g_miss_num_map(a0(indx));
563 t(ddindx).state_depre_dmnshing_value_rt := rosetta_g_miss_num_map(a1(indx));
564 t(ddindx).book_depre_dmnshing_value_rt := rosetta_g_miss_num_map(a2(indx));
565 t(ddindx).residual_guarantee_method := a3(indx);
566 t(ddindx).residual_date := rosetta_g_miss_date_in_map(a4(indx));
567 t(ddindx).fed_depre_term := rosetta_g_miss_num_map(a5(indx));
568 t(ddindx).fed_depre_dmnshing_value_rate := rosetta_g_miss_num_map(a6(indx));
569 t(ddindx).fed_depre_adr_conve := a7(indx);
570 t(ddindx).state_depre_basis_percent := rosetta_g_miss_num_map(a8(indx));
571 t(ddindx).state_depre_method := a9(indx);
572 t(ddindx).purchase_option := a10(indx);
573 t(ddindx).purchase_option_amount := rosetta_g_miss_num_map(a11(indx));
574 t(ddindx).asset_cost := rosetta_g_miss_num_map(a12(indx));
575 t(ddindx).state_depre_term := rosetta_g_miss_num_map(a13(indx));
576 t(ddindx).state_depre_adr_convent := a14(indx);
577 t(ddindx).fed_depre_method := a15(indx);
578 t(ddindx).residual_amount := rosetta_g_miss_num_map(a16(indx));
579 t(ddindx).fed_depre_salvage := rosetta_g_miss_num_map(a17(indx));
580 t(ddindx).date_fed_depre := rosetta_g_miss_date_in_map(a18(indx));
581 t(ddindx).book_salvage := rosetta_g_miss_num_map(a19(indx));
582 t(ddindx).book_adr_convention := a20(indx);
583 t(ddindx).state_depre_salvage := rosetta_g_miss_num_map(a21(indx));
584 t(ddindx).fed_depre_basis_percent := rosetta_g_miss_num_map(a22(indx));
585 t(ddindx).book_basis_percent := rosetta_g_miss_num_map(a23(indx));
586 t(ddindx).date_delivery := rosetta_g_miss_date_in_map(a24(indx));
587 t(ddindx).book_term := rosetta_g_miss_num_map(a25(indx));
588 t(ddindx).residual_guarantee_amount := rosetta_g_miss_num_map(a26(indx));
589 t(ddindx).date_funding := rosetta_g_miss_date_in_map(a27(indx));
590 t(ddindx).date_book := rosetta_g_miss_date_in_map(a28(indx));
591 t(ddindx).date_state_depre := rosetta_g_miss_date_in_map(a29(indx));
592 t(ddindx).book_method := a30(indx);
593 t(ddindx).stream_interface_attribute08 := a31(indx);
594 t(ddindx).stream_interface_attribute03 := a32(indx);
595 t(ddindx).stream_interface_attribute01 := a33(indx);
596 t(ddindx).index_number := rosetta_g_miss_num_map(a34(indx));
597 t(ddindx).stream_interface_attribute05 := a35(indx);
598 t(ddindx).description := a36(indx);
599 t(ddindx).stream_interface_attribute10 := a37(indx);
600 t(ddindx).stream_interface_attribute06 := a38(indx);
601 t(ddindx).stream_interface_attribute09 := a39(indx);
602 t(ddindx).stream_interface_attribute07 := a40(indx);
603 t(ddindx).stream_interface_attribute14 := a41(indx);
604 t(ddindx).stream_interface_attribute12 := a42(indx);
605 t(ddindx).stream_interface_attribute15 := a43(indx);
606 t(ddindx).stream_interface_attribute02 := a44(indx);
607 t(ddindx).stream_interface_attribute11 := a45(indx);
608 t(ddindx).stream_interface_attribute04 := a46(indx);
609 t(ddindx).stream_interface_attribute13 := a47(indx);
610 t(ddindx).date_start := rosetta_g_miss_date_in_map(a48(indx));
611 t(ddindx).date_lending := rosetta_g_miss_date_in_map(a49(indx));
612 t(ddindx).sif_id := rosetta_g_miss_num_map(a50(indx));
613 t(ddindx).object_version_number := rosetta_g_miss_num_map(a51(indx));
614 t(ddindx).kle_id := rosetta_g_miss_num_map(a52(indx));
615 t(ddindx).sil_type := a53(indx);
616 t(ddindx).created_by := rosetta_g_miss_num_map(a54(indx));
617 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a55(indx));
618 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a56(indx));
619 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a57(indx));
620 t(ddindx).last_update_login := rosetta_g_miss_num_map(a58(indx));
621 t(ddindx).residual_guarantee_type := a59(indx);
622 t(ddindx).down_payment_amount := rosetta_g_miss_num_map(a60(indx));
623 t(ddindx).capitalize_down_payment_yn := a61(indx);
624 ddindx := ddindx+1;
625 if a0.last =indx
626 then exit;
627 end if;
628 indx := a0.next(indx);
629 end loop;
630 end if;
631 end if;
632 end rosetta_table_copy_in_p5;
633 procedure rosetta_table_copy_out_p5(t okl_sil_pvt.silv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
634 , a1 out nocopy JTF_NUMBER_TABLE
635 , a2 out nocopy JTF_NUMBER_TABLE
636 , a3 out nocopy JTF_VARCHAR2_TABLE_100
637 , a4 out nocopy JTF_DATE_TABLE
638 , a5 out nocopy JTF_NUMBER_TABLE
639 , a6 out nocopy JTF_NUMBER_TABLE
640 , a7 out nocopy JTF_VARCHAR2_TABLE_100
641 , a8 out nocopy JTF_NUMBER_TABLE
642 , a9 out nocopy JTF_VARCHAR2_TABLE_100
643 , a10 out nocopy JTF_VARCHAR2_TABLE_100
644 , a11 out nocopy JTF_NUMBER_TABLE
645 , a12 out nocopy JTF_NUMBER_TABLE
646 , a13 out nocopy JTF_NUMBER_TABLE
647 , a14 out nocopy JTF_VARCHAR2_TABLE_100
648 , a15 out nocopy JTF_VARCHAR2_TABLE_100
649 , a16 out nocopy JTF_NUMBER_TABLE
650 , a17 out nocopy JTF_NUMBER_TABLE
651 , a18 out nocopy JTF_DATE_TABLE
652 , a19 out nocopy JTF_NUMBER_TABLE
653 , a20 out nocopy JTF_VARCHAR2_TABLE_100
654 , a21 out nocopy JTF_NUMBER_TABLE
655 , a22 out nocopy JTF_NUMBER_TABLE
656 , a23 out nocopy JTF_NUMBER_TABLE
657 , a24 out nocopy JTF_DATE_TABLE
658 , a25 out nocopy JTF_NUMBER_TABLE
659 , a26 out nocopy JTF_NUMBER_TABLE
660 , a27 out nocopy JTF_DATE_TABLE
661 , a28 out nocopy JTF_DATE_TABLE
662 , a29 out nocopy JTF_DATE_TABLE
663 , a30 out nocopy JTF_VARCHAR2_TABLE_100
664 , a31 out nocopy JTF_VARCHAR2_TABLE_500
665 , a32 out nocopy JTF_VARCHAR2_TABLE_500
666 , a33 out nocopy JTF_VARCHAR2_TABLE_500
667 , a34 out nocopy JTF_NUMBER_TABLE
668 , a35 out nocopy JTF_VARCHAR2_TABLE_500
669 , a36 out nocopy JTF_VARCHAR2_TABLE_2000
670 , a37 out nocopy JTF_VARCHAR2_TABLE_500
671 , a38 out nocopy JTF_VARCHAR2_TABLE_500
672 , a39 out nocopy JTF_VARCHAR2_TABLE_500
673 , a40 out nocopy JTF_VARCHAR2_TABLE_500
674 , a41 out nocopy JTF_VARCHAR2_TABLE_500
675 , a42 out nocopy JTF_VARCHAR2_TABLE_500
676 , a43 out nocopy JTF_VARCHAR2_TABLE_500
677 , a44 out nocopy JTF_VARCHAR2_TABLE_500
678 , a45 out nocopy JTF_VARCHAR2_TABLE_500
679 , a46 out nocopy JTF_VARCHAR2_TABLE_500
680 , a47 out nocopy JTF_VARCHAR2_TABLE_500
681 , a48 out nocopy JTF_DATE_TABLE
682 , a49 out nocopy JTF_DATE_TABLE
683 , a50 out nocopy JTF_NUMBER_TABLE
684 , a51 out nocopy JTF_NUMBER_TABLE
685 , a52 out nocopy JTF_NUMBER_TABLE
686 , a53 out nocopy JTF_VARCHAR2_TABLE_100
687 , a54 out nocopy JTF_NUMBER_TABLE
688 , a55 out nocopy JTF_NUMBER_TABLE
689 , a56 out nocopy JTF_DATE_TABLE
690 , a57 out nocopy JTF_DATE_TABLE
691 , a58 out nocopy JTF_NUMBER_TABLE
692 , a59 out nocopy JTF_VARCHAR2_TABLE_200
693 , a60 out nocopy JTF_NUMBER_TABLE
694 , a61 out nocopy JTF_VARCHAR2_TABLE_100
695 ) as
696 ddindx binary_integer; indx binary_integer;
697 begin
698 if t is null or t.count = 0 then
699 a0 := JTF_NUMBER_TABLE();
700 a1 := JTF_NUMBER_TABLE();
701 a2 := JTF_NUMBER_TABLE();
702 a3 := JTF_VARCHAR2_TABLE_100();
703 a4 := JTF_DATE_TABLE();
704 a5 := JTF_NUMBER_TABLE();
705 a6 := JTF_NUMBER_TABLE();
706 a7 := JTF_VARCHAR2_TABLE_100();
707 a8 := JTF_NUMBER_TABLE();
708 a9 := JTF_VARCHAR2_TABLE_100();
709 a10 := JTF_VARCHAR2_TABLE_100();
710 a11 := JTF_NUMBER_TABLE();
711 a12 := JTF_NUMBER_TABLE();
712 a13 := JTF_NUMBER_TABLE();
713 a14 := JTF_VARCHAR2_TABLE_100();
714 a15 := JTF_VARCHAR2_TABLE_100();
715 a16 := JTF_NUMBER_TABLE();
716 a17 := JTF_NUMBER_TABLE();
717 a18 := JTF_DATE_TABLE();
718 a19 := JTF_NUMBER_TABLE();
719 a20 := JTF_VARCHAR2_TABLE_100();
720 a21 := JTF_NUMBER_TABLE();
721 a22 := JTF_NUMBER_TABLE();
722 a23 := JTF_NUMBER_TABLE();
723 a24 := JTF_DATE_TABLE();
724 a25 := JTF_NUMBER_TABLE();
725 a26 := JTF_NUMBER_TABLE();
726 a27 := JTF_DATE_TABLE();
727 a28 := JTF_DATE_TABLE();
728 a29 := JTF_DATE_TABLE();
729 a30 := JTF_VARCHAR2_TABLE_100();
730 a31 := JTF_VARCHAR2_TABLE_500();
731 a32 := JTF_VARCHAR2_TABLE_500();
732 a33 := JTF_VARCHAR2_TABLE_500();
733 a34 := JTF_NUMBER_TABLE();
734 a35 := JTF_VARCHAR2_TABLE_500();
735 a36 := JTF_VARCHAR2_TABLE_2000();
736 a37 := JTF_VARCHAR2_TABLE_500();
737 a38 := JTF_VARCHAR2_TABLE_500();
738 a39 := JTF_VARCHAR2_TABLE_500();
739 a40 := JTF_VARCHAR2_TABLE_500();
740 a41 := JTF_VARCHAR2_TABLE_500();
741 a42 := JTF_VARCHAR2_TABLE_500();
742 a43 := JTF_VARCHAR2_TABLE_500();
743 a44 := JTF_VARCHAR2_TABLE_500();
744 a45 := JTF_VARCHAR2_TABLE_500();
745 a46 := JTF_VARCHAR2_TABLE_500();
746 a47 := JTF_VARCHAR2_TABLE_500();
747 a48 := JTF_DATE_TABLE();
748 a49 := JTF_DATE_TABLE();
749 a50 := JTF_NUMBER_TABLE();
750 a51 := JTF_NUMBER_TABLE();
751 a52 := JTF_NUMBER_TABLE();
752 a53 := JTF_VARCHAR2_TABLE_100();
753 a54 := JTF_NUMBER_TABLE();
754 a55 := JTF_NUMBER_TABLE();
755 a56 := JTF_DATE_TABLE();
756 a57 := JTF_DATE_TABLE();
757 a58 := JTF_NUMBER_TABLE();
758 a59 := JTF_VARCHAR2_TABLE_200();
759 a60 := JTF_NUMBER_TABLE();
760 a61 := JTF_VARCHAR2_TABLE_100();
761 else
762 a0 := JTF_NUMBER_TABLE();
763 a1 := JTF_NUMBER_TABLE();
764 a2 := JTF_NUMBER_TABLE();
765 a3 := JTF_VARCHAR2_TABLE_100();
766 a4 := JTF_DATE_TABLE();
767 a5 := JTF_NUMBER_TABLE();
768 a6 := JTF_NUMBER_TABLE();
769 a7 := JTF_VARCHAR2_TABLE_100();
770 a8 := JTF_NUMBER_TABLE();
771 a9 := JTF_VARCHAR2_TABLE_100();
772 a10 := JTF_VARCHAR2_TABLE_100();
773 a11 := JTF_NUMBER_TABLE();
774 a12 := JTF_NUMBER_TABLE();
775 a13 := JTF_NUMBER_TABLE();
776 a14 := JTF_VARCHAR2_TABLE_100();
777 a15 := JTF_VARCHAR2_TABLE_100();
778 a16 := JTF_NUMBER_TABLE();
779 a17 := JTF_NUMBER_TABLE();
780 a18 := JTF_DATE_TABLE();
781 a19 := JTF_NUMBER_TABLE();
782 a20 := JTF_VARCHAR2_TABLE_100();
783 a21 := JTF_NUMBER_TABLE();
784 a22 := JTF_NUMBER_TABLE();
785 a23 := JTF_NUMBER_TABLE();
786 a24 := JTF_DATE_TABLE();
787 a25 := JTF_NUMBER_TABLE();
788 a26 := JTF_NUMBER_TABLE();
789 a27 := JTF_DATE_TABLE();
790 a28 := JTF_DATE_TABLE();
791 a29 := JTF_DATE_TABLE();
792 a30 := JTF_VARCHAR2_TABLE_100();
793 a31 := JTF_VARCHAR2_TABLE_500();
794 a32 := JTF_VARCHAR2_TABLE_500();
795 a33 := JTF_VARCHAR2_TABLE_500();
796 a34 := JTF_NUMBER_TABLE();
797 a35 := JTF_VARCHAR2_TABLE_500();
798 a36 := JTF_VARCHAR2_TABLE_2000();
799 a37 := JTF_VARCHAR2_TABLE_500();
800 a38 := JTF_VARCHAR2_TABLE_500();
801 a39 := JTF_VARCHAR2_TABLE_500();
802 a40 := JTF_VARCHAR2_TABLE_500();
803 a41 := JTF_VARCHAR2_TABLE_500();
804 a42 := JTF_VARCHAR2_TABLE_500();
805 a43 := JTF_VARCHAR2_TABLE_500();
806 a44 := JTF_VARCHAR2_TABLE_500();
807 a45 := JTF_VARCHAR2_TABLE_500();
808 a46 := JTF_VARCHAR2_TABLE_500();
809 a47 := JTF_VARCHAR2_TABLE_500();
810 a48 := JTF_DATE_TABLE();
811 a49 := JTF_DATE_TABLE();
812 a50 := JTF_NUMBER_TABLE();
813 a51 := JTF_NUMBER_TABLE();
814 a52 := JTF_NUMBER_TABLE();
815 a53 := JTF_VARCHAR2_TABLE_100();
816 a54 := JTF_NUMBER_TABLE();
817 a55 := JTF_NUMBER_TABLE();
818 a56 := JTF_DATE_TABLE();
819 a57 := JTF_DATE_TABLE();
820 a58 := JTF_NUMBER_TABLE();
821 a59 := JTF_VARCHAR2_TABLE_200();
822 a60 := JTF_NUMBER_TABLE();
823 a61 := JTF_VARCHAR2_TABLE_100();
824 if t.count > 0 then
825 a0.extend(t.count);
826 a1.extend(t.count);
827 a2.extend(t.count);
828 a3.extend(t.count);
829 a4.extend(t.count);
830 a5.extend(t.count);
831 a6.extend(t.count);
832 a7.extend(t.count);
833 a8.extend(t.count);
834 a9.extend(t.count);
835 a10.extend(t.count);
836 a11.extend(t.count);
837 a12.extend(t.count);
838 a13.extend(t.count);
839 a14.extend(t.count);
840 a15.extend(t.count);
841 a16.extend(t.count);
842 a17.extend(t.count);
843 a18.extend(t.count);
844 a19.extend(t.count);
845 a20.extend(t.count);
846 a21.extend(t.count);
847 a22.extend(t.count);
848 a23.extend(t.count);
849 a24.extend(t.count);
850 a25.extend(t.count);
851 a26.extend(t.count);
852 a27.extend(t.count);
853 a28.extend(t.count);
854 a29.extend(t.count);
855 a30.extend(t.count);
856 a31.extend(t.count);
857 a32.extend(t.count);
858 a33.extend(t.count);
859 a34.extend(t.count);
860 a35.extend(t.count);
861 a36.extend(t.count);
862 a37.extend(t.count);
863 a38.extend(t.count);
864 a39.extend(t.count);
865 a40.extend(t.count);
866 a41.extend(t.count);
867 a42.extend(t.count);
868 a43.extend(t.count);
869 a44.extend(t.count);
870 a45.extend(t.count);
871 a46.extend(t.count);
872 a47.extend(t.count);
873 a48.extend(t.count);
874 a49.extend(t.count);
875 a50.extend(t.count);
876 a51.extend(t.count);
877 a52.extend(t.count);
878 a53.extend(t.count);
879 a54.extend(t.count);
880 a55.extend(t.count);
881 a56.extend(t.count);
882 a57.extend(t.count);
883 a58.extend(t.count);
884 a59.extend(t.count);
885 a60.extend(t.count);
886 a61.extend(t.count);
887 ddindx := t.first;
888 indx := 1;
889 while true loop
890 a0(indx) := rosetta_g_miss_num_map(t(ddindx).id);
891 a1(indx) := rosetta_g_miss_num_map(t(ddindx).state_depre_dmnshing_value_rt);
892 a2(indx) := rosetta_g_miss_num_map(t(ddindx).book_depre_dmnshing_value_rt);
893 a3(indx) := t(ddindx).residual_guarantee_method;
894 a4(indx) := t(ddindx).residual_date;
895 a5(indx) := rosetta_g_miss_num_map(t(ddindx).fed_depre_term);
896 a6(indx) := rosetta_g_miss_num_map(t(ddindx).fed_depre_dmnshing_value_rate);
897 a7(indx) := t(ddindx).fed_depre_adr_conve;
898 a8(indx) := rosetta_g_miss_num_map(t(ddindx).state_depre_basis_percent);
899 a9(indx) := t(ddindx).state_depre_method;
900 a10(indx) := t(ddindx).purchase_option;
901 a11(indx) := rosetta_g_miss_num_map(t(ddindx).purchase_option_amount);
902 a12(indx) := rosetta_g_miss_num_map(t(ddindx).asset_cost);
903 a13(indx) := rosetta_g_miss_num_map(t(ddindx).state_depre_term);
904 a14(indx) := t(ddindx).state_depre_adr_convent;
905 a15(indx) := t(ddindx).fed_depre_method;
906 a16(indx) := rosetta_g_miss_num_map(t(ddindx).residual_amount);
907 a17(indx) := rosetta_g_miss_num_map(t(ddindx).fed_depre_salvage);
908 a18(indx) := t(ddindx).date_fed_depre;
909 a19(indx) := rosetta_g_miss_num_map(t(ddindx).book_salvage);
910 a20(indx) := t(ddindx).book_adr_convention;
911 a21(indx) := rosetta_g_miss_num_map(t(ddindx).state_depre_salvage);
912 a22(indx) := rosetta_g_miss_num_map(t(ddindx).fed_depre_basis_percent);
913 a23(indx) := rosetta_g_miss_num_map(t(ddindx).book_basis_percent);
914 a24(indx) := t(ddindx).date_delivery;
915 a25(indx) := rosetta_g_miss_num_map(t(ddindx).book_term);
916 a26(indx) := rosetta_g_miss_num_map(t(ddindx).residual_guarantee_amount);
917 a27(indx) := t(ddindx).date_funding;
918 a28(indx) := t(ddindx).date_book;
919 a29(indx) := t(ddindx).date_state_depre;
920 a30(indx) := t(ddindx).book_method;
921 a31(indx) := t(ddindx).stream_interface_attribute08;
922 a32(indx) := t(ddindx).stream_interface_attribute03;
923 a33(indx) := t(ddindx).stream_interface_attribute01;
924 a34(indx) := rosetta_g_miss_num_map(t(ddindx).index_number);
925 a35(indx) := t(ddindx).stream_interface_attribute05;
926 a36(indx) := t(ddindx).description;
927 a37(indx) := t(ddindx).stream_interface_attribute10;
928 a38(indx) := t(ddindx).stream_interface_attribute06;
929 a39(indx) := t(ddindx).stream_interface_attribute09;
930 a40(indx) := t(ddindx).stream_interface_attribute07;
931 a41(indx) := t(ddindx).stream_interface_attribute14;
932 a42(indx) := t(ddindx).stream_interface_attribute12;
933 a43(indx) := t(ddindx).stream_interface_attribute15;
934 a44(indx) := t(ddindx).stream_interface_attribute02;
935 a45(indx) := t(ddindx).stream_interface_attribute11;
936 a46(indx) := t(ddindx).stream_interface_attribute04;
937 a47(indx) := t(ddindx).stream_interface_attribute13;
938 a48(indx) := t(ddindx).date_start;
939 a49(indx) := t(ddindx).date_lending;
940 a50(indx) := rosetta_g_miss_num_map(t(ddindx).sif_id);
941 a51(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
942 a52(indx) := rosetta_g_miss_num_map(t(ddindx).kle_id);
943 a53(indx) := t(ddindx).sil_type;
944 a54(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
945 a55(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
946 a56(indx) := t(ddindx).creation_date;
947 a57(indx) := t(ddindx).last_update_date;
948 a58(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
949 a59(indx) := t(ddindx).residual_guarantee_type;
950 a60(indx) := rosetta_g_miss_num_map(t(ddindx).down_payment_amount);
951 a61(indx) := t(ddindx).capitalize_down_payment_yn;
952 indx := indx+1;
953 if t.last =ddindx
954 then exit;
955 end if;
956 ddindx := t.next(ddindx);
957 end loop;
958 end if;
959 end if;
960 end rosetta_table_copy_out_p5;
961
962 procedure insert_row(p_api_version NUMBER
963 , p_init_msg_list VARCHAR2
964 , x_return_status out nocopy VARCHAR2
965 , x_msg_count out nocopy NUMBER
966 , x_msg_data out nocopy VARCHAR2
967 , p6_a0 out nocopy NUMBER
968 , p6_a1 out nocopy NUMBER
969 , p6_a2 out nocopy NUMBER
970 , p6_a3 out nocopy VARCHAR2
971 , p6_a4 out nocopy DATE
972 , p6_a5 out nocopy NUMBER
973 , p6_a6 out nocopy NUMBER
974 , p6_a7 out nocopy VARCHAR2
975 , p6_a8 out nocopy NUMBER
976 , p6_a9 out nocopy VARCHAR2
977 , p6_a10 out nocopy VARCHAR2
978 , p6_a11 out nocopy NUMBER
979 , p6_a12 out nocopy NUMBER
980 , p6_a13 out nocopy NUMBER
981 , p6_a14 out nocopy VARCHAR2
982 , p6_a15 out nocopy VARCHAR2
983 , p6_a16 out nocopy NUMBER
984 , p6_a17 out nocopy NUMBER
985 , p6_a18 out nocopy DATE
986 , p6_a19 out nocopy NUMBER
987 , p6_a20 out nocopy VARCHAR2
988 , p6_a21 out nocopy NUMBER
989 , p6_a22 out nocopy NUMBER
990 , p6_a23 out nocopy NUMBER
991 , p6_a24 out nocopy DATE
992 , p6_a25 out nocopy NUMBER
993 , p6_a26 out nocopy NUMBER
994 , p6_a27 out nocopy DATE
995 , p6_a28 out nocopy DATE
996 , p6_a29 out nocopy DATE
997 , p6_a30 out nocopy VARCHAR2
998 , p6_a31 out nocopy VARCHAR2
999 , p6_a32 out nocopy VARCHAR2
1000 , p6_a33 out nocopy VARCHAR2
1001 , p6_a34 out nocopy NUMBER
1002 , p6_a35 out nocopy VARCHAR2
1003 , p6_a36 out nocopy VARCHAR2
1004 , p6_a37 out nocopy VARCHAR2
1005 , p6_a38 out nocopy VARCHAR2
1006 , p6_a39 out nocopy VARCHAR2
1007 , p6_a40 out nocopy VARCHAR2
1008 , p6_a41 out nocopy VARCHAR2
1009 , p6_a42 out nocopy VARCHAR2
1010 , p6_a43 out nocopy VARCHAR2
1011 , p6_a44 out nocopy VARCHAR2
1012 , p6_a45 out nocopy VARCHAR2
1013 , p6_a46 out nocopy VARCHAR2
1014 , p6_a47 out nocopy VARCHAR2
1015 , p6_a48 out nocopy DATE
1016 , p6_a49 out nocopy DATE
1017 , p6_a50 out nocopy NUMBER
1018 , p6_a51 out nocopy NUMBER
1019 , p6_a52 out nocopy NUMBER
1020 , p6_a53 out nocopy VARCHAR2
1021 , p6_a54 out nocopy NUMBER
1022 , p6_a55 out nocopy NUMBER
1023 , p6_a56 out nocopy DATE
1024 , p6_a57 out nocopy DATE
1025 , p6_a58 out nocopy NUMBER
1026 , p6_a59 out nocopy VARCHAR2
1027 , p6_a60 out nocopy NUMBER
1028 , p6_a61 out nocopy VARCHAR2
1029 , p5_a0 NUMBER := 0-1962.0724
1030 , p5_a1 NUMBER := 0-1962.0724
1031 , p5_a2 NUMBER := 0-1962.0724
1032 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1033 , p5_a4 DATE := fnd_api.g_miss_date
1034 , p5_a5 NUMBER := 0-1962.0724
1035 , p5_a6 NUMBER := 0-1962.0724
1036 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1037 , p5_a8 NUMBER := 0-1962.0724
1038 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1039 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1040 , p5_a11 NUMBER := 0-1962.0724
1041 , p5_a12 NUMBER := 0-1962.0724
1042 , p5_a13 NUMBER := 0-1962.0724
1043 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1044 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1045 , p5_a16 NUMBER := 0-1962.0724
1046 , p5_a17 NUMBER := 0-1962.0724
1047 , p5_a18 DATE := fnd_api.g_miss_date
1048 , p5_a19 NUMBER := 0-1962.0724
1049 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1050 , p5_a21 NUMBER := 0-1962.0724
1051 , p5_a22 NUMBER := 0-1962.0724
1052 , p5_a23 NUMBER := 0-1962.0724
1053 , p5_a24 DATE := fnd_api.g_miss_date
1054 , p5_a25 NUMBER := 0-1962.0724
1055 , p5_a26 NUMBER := 0-1962.0724
1056 , p5_a27 DATE := fnd_api.g_miss_date
1057 , p5_a28 DATE := fnd_api.g_miss_date
1058 , p5_a29 DATE := fnd_api.g_miss_date
1059 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1060 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1061 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1062 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1063 , p5_a34 NUMBER := 0-1962.0724
1064 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1065 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1066 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1067 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1068 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1069 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1070 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1071 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1072 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1073 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1074 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1075 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
1076 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
1077 , p5_a48 DATE := fnd_api.g_miss_date
1078 , p5_a49 DATE := fnd_api.g_miss_date
1079 , p5_a50 NUMBER := 0-1962.0724
1080 , p5_a51 NUMBER := 0-1962.0724
1081 , p5_a52 NUMBER := 0-1962.0724
1082 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1083 , p5_a54 NUMBER := 0-1962.0724
1084 , p5_a55 NUMBER := 0-1962.0724
1085 , p5_a56 DATE := fnd_api.g_miss_date
1086 , p5_a57 DATE := fnd_api.g_miss_date
1087 , p5_a58 NUMBER := 0-1962.0724
1088 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1089 , p5_a60 NUMBER := 0-1962.0724
1090 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
1091 )
1092
1093 as
1094 ddp_silv_rec okl_sil_pvt.silv_rec_type;
1095 ddx_silv_rec okl_sil_pvt.silv_rec_type;
1096 ddindx binary_integer; indx binary_integer;
1097 begin
1098
1099 -- copy data to the local IN or IN-OUT args, if any
1100
1101
1102
1103
1104
1105 ddp_silv_rec.id := rosetta_g_miss_num_map(p5_a0);
1106 ddp_silv_rec.state_depre_dmnshing_value_rt := rosetta_g_miss_num_map(p5_a1);
1107 ddp_silv_rec.book_depre_dmnshing_value_rt := rosetta_g_miss_num_map(p5_a2);
1108 ddp_silv_rec.residual_guarantee_method := p5_a3;
1109 ddp_silv_rec.residual_date := rosetta_g_miss_date_in_map(p5_a4);
1110 ddp_silv_rec.fed_depre_term := rosetta_g_miss_num_map(p5_a5);
1111 ddp_silv_rec.fed_depre_dmnshing_value_rate := rosetta_g_miss_num_map(p5_a6);
1112 ddp_silv_rec.fed_depre_adr_conve := p5_a7;
1113 ddp_silv_rec.state_depre_basis_percent := rosetta_g_miss_num_map(p5_a8);
1114 ddp_silv_rec.state_depre_method := p5_a9;
1115 ddp_silv_rec.purchase_option := p5_a10;
1116 ddp_silv_rec.purchase_option_amount := rosetta_g_miss_num_map(p5_a11);
1117 ddp_silv_rec.asset_cost := rosetta_g_miss_num_map(p5_a12);
1118 ddp_silv_rec.state_depre_term := rosetta_g_miss_num_map(p5_a13);
1119 ddp_silv_rec.state_depre_adr_convent := p5_a14;
1120 ddp_silv_rec.fed_depre_method := p5_a15;
1121 ddp_silv_rec.residual_amount := rosetta_g_miss_num_map(p5_a16);
1122 ddp_silv_rec.fed_depre_salvage := rosetta_g_miss_num_map(p5_a17);
1123 ddp_silv_rec.date_fed_depre := rosetta_g_miss_date_in_map(p5_a18);
1124 ddp_silv_rec.book_salvage := rosetta_g_miss_num_map(p5_a19);
1125 ddp_silv_rec.book_adr_convention := p5_a20;
1126 ddp_silv_rec.state_depre_salvage := rosetta_g_miss_num_map(p5_a21);
1127 ddp_silv_rec.fed_depre_basis_percent := rosetta_g_miss_num_map(p5_a22);
1128 ddp_silv_rec.book_basis_percent := rosetta_g_miss_num_map(p5_a23);
1129 ddp_silv_rec.date_delivery := rosetta_g_miss_date_in_map(p5_a24);
1130 ddp_silv_rec.book_term := rosetta_g_miss_num_map(p5_a25);
1131 ddp_silv_rec.residual_guarantee_amount := rosetta_g_miss_num_map(p5_a26);
1132 ddp_silv_rec.date_funding := rosetta_g_miss_date_in_map(p5_a27);
1133 ddp_silv_rec.date_book := rosetta_g_miss_date_in_map(p5_a28);
1134 ddp_silv_rec.date_state_depre := rosetta_g_miss_date_in_map(p5_a29);
1135 ddp_silv_rec.book_method := p5_a30;
1136 ddp_silv_rec.stream_interface_attribute08 := p5_a31;
1137 ddp_silv_rec.stream_interface_attribute03 := p5_a32;
1138 ddp_silv_rec.stream_interface_attribute01 := p5_a33;
1139 ddp_silv_rec.index_number := rosetta_g_miss_num_map(p5_a34);
1140 ddp_silv_rec.stream_interface_attribute05 := p5_a35;
1141 ddp_silv_rec.description := p5_a36;
1142 ddp_silv_rec.stream_interface_attribute10 := p5_a37;
1143 ddp_silv_rec.stream_interface_attribute06 := p5_a38;
1144 ddp_silv_rec.stream_interface_attribute09 := p5_a39;
1145 ddp_silv_rec.stream_interface_attribute07 := p5_a40;
1146 ddp_silv_rec.stream_interface_attribute14 := p5_a41;
1147 ddp_silv_rec.stream_interface_attribute12 := p5_a42;
1148 ddp_silv_rec.stream_interface_attribute15 := p5_a43;
1149 ddp_silv_rec.stream_interface_attribute02 := p5_a44;
1150 ddp_silv_rec.stream_interface_attribute11 := p5_a45;
1151 ddp_silv_rec.stream_interface_attribute04 := p5_a46;
1152 ddp_silv_rec.stream_interface_attribute13 := p5_a47;
1153 ddp_silv_rec.date_start := rosetta_g_miss_date_in_map(p5_a48);
1154 ddp_silv_rec.date_lending := rosetta_g_miss_date_in_map(p5_a49);
1155 ddp_silv_rec.sif_id := rosetta_g_miss_num_map(p5_a50);
1156 ddp_silv_rec.object_version_number := rosetta_g_miss_num_map(p5_a51);
1157 ddp_silv_rec.kle_id := rosetta_g_miss_num_map(p5_a52);
1158 ddp_silv_rec.sil_type := p5_a53;
1159 ddp_silv_rec.created_by := rosetta_g_miss_num_map(p5_a54);
1160 ddp_silv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a55);
1161 ddp_silv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a56);
1162 ddp_silv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
1163 ddp_silv_rec.last_update_login := rosetta_g_miss_num_map(p5_a58);
1164 ddp_silv_rec.residual_guarantee_type := p5_a59;
1165 ddp_silv_rec.down_payment_amount := rosetta_g_miss_num_map(p5_a60);
1166 ddp_silv_rec.capitalize_down_payment_yn := p5_a61;
1167
1168
1169 -- here's the delegated call to the old PL/SQL routine
1170 okl_sil_pvt.insert_row(p_api_version,
1171 p_init_msg_list,
1172 x_return_status,
1173 x_msg_count,
1174 x_msg_data,
1175 ddp_silv_rec,
1176 ddx_silv_rec);
1177
1178 -- copy data back from the local variables to OUT or IN-OUT args, if any
1179
1180
1181
1182
1183
1184
1185 p6_a0 := rosetta_g_miss_num_map(ddx_silv_rec.id);
1186 p6_a1 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_dmnshing_value_rt);
1187 p6_a2 := rosetta_g_miss_num_map(ddx_silv_rec.book_depre_dmnshing_value_rt);
1188 p6_a3 := ddx_silv_rec.residual_guarantee_method;
1189 p6_a4 := ddx_silv_rec.residual_date;
1190 p6_a5 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_term);
1191 p6_a6 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_dmnshing_value_rate);
1192 p6_a7 := ddx_silv_rec.fed_depre_adr_conve;
1193 p6_a8 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_basis_percent);
1194 p6_a9 := ddx_silv_rec.state_depre_method;
1195 p6_a10 := ddx_silv_rec.purchase_option;
1196 p6_a11 := rosetta_g_miss_num_map(ddx_silv_rec.purchase_option_amount);
1197 p6_a12 := rosetta_g_miss_num_map(ddx_silv_rec.asset_cost);
1198 p6_a13 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_term);
1199 p6_a14 := ddx_silv_rec.state_depre_adr_convent;
1200 p6_a15 := ddx_silv_rec.fed_depre_method;
1201 p6_a16 := rosetta_g_miss_num_map(ddx_silv_rec.residual_amount);
1202 p6_a17 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_salvage);
1203 p6_a18 := ddx_silv_rec.date_fed_depre;
1204 p6_a19 := rosetta_g_miss_num_map(ddx_silv_rec.book_salvage);
1205 p6_a20 := ddx_silv_rec.book_adr_convention;
1206 p6_a21 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_salvage);
1207 p6_a22 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_basis_percent);
1208 p6_a23 := rosetta_g_miss_num_map(ddx_silv_rec.book_basis_percent);
1209 p6_a24 := ddx_silv_rec.date_delivery;
1210 p6_a25 := rosetta_g_miss_num_map(ddx_silv_rec.book_term);
1211 p6_a26 := rosetta_g_miss_num_map(ddx_silv_rec.residual_guarantee_amount);
1212 p6_a27 := ddx_silv_rec.date_funding;
1213 p6_a28 := ddx_silv_rec.date_book;
1214 p6_a29 := ddx_silv_rec.date_state_depre;
1215 p6_a30 := ddx_silv_rec.book_method;
1216 p6_a31 := ddx_silv_rec.stream_interface_attribute08;
1217 p6_a32 := ddx_silv_rec.stream_interface_attribute03;
1218 p6_a33 := ddx_silv_rec.stream_interface_attribute01;
1219 p6_a34 := rosetta_g_miss_num_map(ddx_silv_rec.index_number);
1220 p6_a35 := ddx_silv_rec.stream_interface_attribute05;
1221 p6_a36 := ddx_silv_rec.description;
1222 p6_a37 := ddx_silv_rec.stream_interface_attribute10;
1223 p6_a38 := ddx_silv_rec.stream_interface_attribute06;
1224 p6_a39 := ddx_silv_rec.stream_interface_attribute09;
1225 p6_a40 := ddx_silv_rec.stream_interface_attribute07;
1226 p6_a41 := ddx_silv_rec.stream_interface_attribute14;
1227 p6_a42 := ddx_silv_rec.stream_interface_attribute12;
1228 p6_a43 := ddx_silv_rec.stream_interface_attribute15;
1229 p6_a44 := ddx_silv_rec.stream_interface_attribute02;
1230 p6_a45 := ddx_silv_rec.stream_interface_attribute11;
1231 p6_a46 := ddx_silv_rec.stream_interface_attribute04;
1232 p6_a47 := ddx_silv_rec.stream_interface_attribute13;
1233 p6_a48 := ddx_silv_rec.date_start;
1234 p6_a49 := ddx_silv_rec.date_lending;
1235 p6_a50 := rosetta_g_miss_num_map(ddx_silv_rec.sif_id);
1236 p6_a51 := rosetta_g_miss_num_map(ddx_silv_rec.object_version_number);
1237 p6_a52 := rosetta_g_miss_num_map(ddx_silv_rec.kle_id);
1238 p6_a53 := ddx_silv_rec.sil_type;
1239 p6_a54 := rosetta_g_miss_num_map(ddx_silv_rec.created_by);
1240 p6_a55 := rosetta_g_miss_num_map(ddx_silv_rec.last_updated_by);
1241 p6_a56 := ddx_silv_rec.creation_date;
1242 p6_a57 := ddx_silv_rec.last_update_date;
1243 p6_a58 := rosetta_g_miss_num_map(ddx_silv_rec.last_update_login);
1244 p6_a59 := ddx_silv_rec.residual_guarantee_type;
1245 p6_a60 := rosetta_g_miss_num_map(ddx_silv_rec.down_payment_amount);
1246 p6_a61 := ddx_silv_rec.capitalize_down_payment_yn;
1247 end;
1248
1249 procedure insert_row(p_api_version NUMBER
1250 , p_init_msg_list VARCHAR2
1251 , x_return_status out nocopy VARCHAR2
1252 , x_msg_count out nocopy NUMBER
1253 , x_msg_data out nocopy VARCHAR2
1254 , p5_a0 JTF_NUMBER_TABLE
1255 , p5_a1 JTF_NUMBER_TABLE
1256 , p5_a2 JTF_NUMBER_TABLE
1257 , p5_a3 JTF_VARCHAR2_TABLE_100
1258 , p5_a4 JTF_DATE_TABLE
1259 , p5_a5 JTF_NUMBER_TABLE
1260 , p5_a6 JTF_NUMBER_TABLE
1261 , p5_a7 JTF_VARCHAR2_TABLE_100
1262 , p5_a8 JTF_NUMBER_TABLE
1263 , p5_a9 JTF_VARCHAR2_TABLE_100
1264 , p5_a10 JTF_VARCHAR2_TABLE_100
1265 , p5_a11 JTF_NUMBER_TABLE
1266 , p5_a12 JTF_NUMBER_TABLE
1267 , p5_a13 JTF_NUMBER_TABLE
1268 , p5_a14 JTF_VARCHAR2_TABLE_100
1269 , p5_a15 JTF_VARCHAR2_TABLE_100
1270 , p5_a16 JTF_NUMBER_TABLE
1271 , p5_a17 JTF_NUMBER_TABLE
1272 , p5_a18 JTF_DATE_TABLE
1273 , p5_a19 JTF_NUMBER_TABLE
1274 , p5_a20 JTF_VARCHAR2_TABLE_100
1275 , p5_a21 JTF_NUMBER_TABLE
1276 , p5_a22 JTF_NUMBER_TABLE
1277 , p5_a23 JTF_NUMBER_TABLE
1278 , p5_a24 JTF_DATE_TABLE
1279 , p5_a25 JTF_NUMBER_TABLE
1280 , p5_a26 JTF_NUMBER_TABLE
1281 , p5_a27 JTF_DATE_TABLE
1282 , p5_a28 JTF_DATE_TABLE
1283 , p5_a29 JTF_DATE_TABLE
1284 , p5_a30 JTF_VARCHAR2_TABLE_100
1285 , p5_a31 JTF_VARCHAR2_TABLE_500
1286 , p5_a32 JTF_VARCHAR2_TABLE_500
1287 , p5_a33 JTF_VARCHAR2_TABLE_500
1288 , p5_a34 JTF_NUMBER_TABLE
1289 , p5_a35 JTF_VARCHAR2_TABLE_500
1290 , p5_a36 JTF_VARCHAR2_TABLE_2000
1291 , p5_a37 JTF_VARCHAR2_TABLE_500
1292 , p5_a38 JTF_VARCHAR2_TABLE_500
1293 , p5_a39 JTF_VARCHAR2_TABLE_500
1294 , p5_a40 JTF_VARCHAR2_TABLE_500
1295 , p5_a41 JTF_VARCHAR2_TABLE_500
1296 , p5_a42 JTF_VARCHAR2_TABLE_500
1297 , p5_a43 JTF_VARCHAR2_TABLE_500
1298 , p5_a44 JTF_VARCHAR2_TABLE_500
1299 , p5_a45 JTF_VARCHAR2_TABLE_500
1300 , p5_a46 JTF_VARCHAR2_TABLE_500
1301 , p5_a47 JTF_VARCHAR2_TABLE_500
1302 , p5_a48 JTF_DATE_TABLE
1303 , p5_a49 JTF_DATE_TABLE
1304 , p5_a50 JTF_NUMBER_TABLE
1305 , p5_a51 JTF_NUMBER_TABLE
1306 , p5_a52 JTF_NUMBER_TABLE
1307 , p5_a53 JTF_VARCHAR2_TABLE_100
1308 , p5_a54 JTF_NUMBER_TABLE
1309 , p5_a55 JTF_NUMBER_TABLE
1310 , p5_a56 JTF_DATE_TABLE
1311 , p5_a57 JTF_DATE_TABLE
1312 , p5_a58 JTF_NUMBER_TABLE
1313 , p5_a59 JTF_VARCHAR2_TABLE_200
1314 , p5_a60 JTF_NUMBER_TABLE
1315 , p5_a61 JTF_VARCHAR2_TABLE_100
1316 , p6_a0 out nocopy JTF_NUMBER_TABLE
1317 , p6_a1 out nocopy JTF_NUMBER_TABLE
1318 , p6_a2 out nocopy JTF_NUMBER_TABLE
1319 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1320 , p6_a4 out nocopy JTF_DATE_TABLE
1321 , p6_a5 out nocopy JTF_NUMBER_TABLE
1322 , p6_a6 out nocopy JTF_NUMBER_TABLE
1323 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1324 , p6_a8 out nocopy JTF_NUMBER_TABLE
1325 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1326 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1327 , p6_a11 out nocopy JTF_NUMBER_TABLE
1328 , p6_a12 out nocopy JTF_NUMBER_TABLE
1329 , p6_a13 out nocopy JTF_NUMBER_TABLE
1330 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1331 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1332 , p6_a16 out nocopy JTF_NUMBER_TABLE
1333 , p6_a17 out nocopy JTF_NUMBER_TABLE
1334 , p6_a18 out nocopy JTF_DATE_TABLE
1335 , p6_a19 out nocopy JTF_NUMBER_TABLE
1336 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1337 , p6_a21 out nocopy JTF_NUMBER_TABLE
1338 , p6_a22 out nocopy JTF_NUMBER_TABLE
1339 , p6_a23 out nocopy JTF_NUMBER_TABLE
1340 , p6_a24 out nocopy JTF_DATE_TABLE
1341 , p6_a25 out nocopy JTF_NUMBER_TABLE
1342 , p6_a26 out nocopy JTF_NUMBER_TABLE
1343 , p6_a27 out nocopy JTF_DATE_TABLE
1344 , p6_a28 out nocopy JTF_DATE_TABLE
1345 , p6_a29 out nocopy JTF_DATE_TABLE
1346 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
1347 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
1348 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1349 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1350 , p6_a34 out nocopy JTF_NUMBER_TABLE
1351 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
1352 , p6_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1353 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_500
1354 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_500
1355 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_500
1356 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_500
1357 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
1358 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
1359 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500
1360 , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
1361 , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
1362 , p6_a46 out nocopy JTF_VARCHAR2_TABLE_500
1363 , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
1364 , p6_a48 out nocopy JTF_DATE_TABLE
1365 , p6_a49 out nocopy JTF_DATE_TABLE
1366 , p6_a50 out nocopy JTF_NUMBER_TABLE
1367 , p6_a51 out nocopy JTF_NUMBER_TABLE
1368 , p6_a52 out nocopy JTF_NUMBER_TABLE
1369 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
1370 , p6_a54 out nocopy JTF_NUMBER_TABLE
1371 , p6_a55 out nocopy JTF_NUMBER_TABLE
1372 , p6_a56 out nocopy JTF_DATE_TABLE
1373 , p6_a57 out nocopy JTF_DATE_TABLE
1374 , p6_a58 out nocopy JTF_NUMBER_TABLE
1375 , p6_a59 out nocopy JTF_VARCHAR2_TABLE_200
1376 , p6_a60 out nocopy JTF_NUMBER_TABLE
1377 , p6_a61 out nocopy JTF_VARCHAR2_TABLE_100
1378 )
1379
1380 as
1381 ddp_silv_tbl okl_sil_pvt.silv_tbl_type;
1382 ddx_silv_tbl okl_sil_pvt.silv_tbl_type;
1383 ddindx binary_integer; indx binary_integer;
1384 begin
1385
1386 -- copy data to the local IN or IN-OUT args, if any
1387
1388
1389
1390
1391
1392 okl_sil_pvt_w.rosetta_table_copy_in_p5(ddp_silv_tbl, p5_a0
1393 , p5_a1
1394 , p5_a2
1395 , p5_a3
1396 , p5_a4
1397 , p5_a5
1398 , p5_a6
1399 , p5_a7
1400 , p5_a8
1401 , p5_a9
1402 , p5_a10
1403 , p5_a11
1404 , p5_a12
1405 , p5_a13
1406 , p5_a14
1407 , p5_a15
1408 , p5_a16
1409 , p5_a17
1410 , p5_a18
1411 , p5_a19
1412 , p5_a20
1413 , p5_a21
1414 , p5_a22
1415 , p5_a23
1416 , p5_a24
1417 , p5_a25
1418 , p5_a26
1419 , p5_a27
1420 , p5_a28
1421 , p5_a29
1422 , p5_a30
1423 , p5_a31
1424 , p5_a32
1425 , p5_a33
1426 , p5_a34
1427 , p5_a35
1428 , p5_a36
1429 , p5_a37
1430 , p5_a38
1431 , p5_a39
1432 , p5_a40
1433 , p5_a41
1434 , p5_a42
1435 , p5_a43
1436 , p5_a44
1437 , p5_a45
1438 , p5_a46
1439 , p5_a47
1440 , p5_a48
1441 , p5_a49
1442 , p5_a50
1443 , p5_a51
1444 , p5_a52
1445 , p5_a53
1446 , p5_a54
1447 , p5_a55
1448 , p5_a56
1449 , p5_a57
1450 , p5_a58
1451 , p5_a59
1452 , p5_a60
1453 , p5_a61
1454 );
1455
1456
1457 -- here's the delegated call to the old PL/SQL routine
1458 okl_sil_pvt.insert_row(p_api_version,
1459 p_init_msg_list,
1460 x_return_status,
1461 x_msg_count,
1462 x_msg_data,
1463 ddp_silv_tbl,
1464 ddx_silv_tbl);
1465
1466 -- copy data back from the local variables to OUT or IN-OUT args, if any
1467
1468
1469
1470
1471
1472
1473 okl_sil_pvt_w.rosetta_table_copy_out_p5(ddx_silv_tbl, p6_a0
1474 , p6_a1
1475 , p6_a2
1476 , p6_a3
1477 , p6_a4
1478 , p6_a5
1479 , p6_a6
1480 , p6_a7
1481 , p6_a8
1482 , p6_a9
1483 , p6_a10
1484 , p6_a11
1485 , p6_a12
1486 , p6_a13
1487 , p6_a14
1488 , p6_a15
1489 , p6_a16
1490 , p6_a17
1491 , p6_a18
1492 , p6_a19
1493 , p6_a20
1494 , p6_a21
1495 , p6_a22
1496 , p6_a23
1497 , p6_a24
1498 , p6_a25
1499 , p6_a26
1500 , p6_a27
1501 , p6_a28
1502 , p6_a29
1503 , p6_a30
1504 , p6_a31
1505 , p6_a32
1506 , p6_a33
1507 , p6_a34
1508 , p6_a35
1509 , p6_a36
1510 , p6_a37
1511 , p6_a38
1512 , p6_a39
1513 , p6_a40
1514 , p6_a41
1515 , p6_a42
1516 , p6_a43
1517 , p6_a44
1518 , p6_a45
1519 , p6_a46
1520 , p6_a47
1521 , p6_a48
1522 , p6_a49
1523 , p6_a50
1524 , p6_a51
1525 , p6_a52
1526 , p6_a53
1527 , p6_a54
1528 , p6_a55
1529 , p6_a56
1530 , p6_a57
1531 , p6_a58
1532 , p6_a59
1533 , p6_a60
1534 , p6_a61
1535 );
1536 end;
1537
1538 procedure lock_row(p_api_version NUMBER
1539 , p_init_msg_list VARCHAR2
1540 , x_return_status out nocopy VARCHAR2
1541 , x_msg_count out nocopy NUMBER
1542 , x_msg_data out nocopy VARCHAR2
1543 , p5_a0 NUMBER := 0-1962.0724
1544 , p5_a1 NUMBER := 0-1962.0724
1545 , p5_a2 NUMBER := 0-1962.0724
1546 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1547 , p5_a4 DATE := fnd_api.g_miss_date
1548 , p5_a5 NUMBER := 0-1962.0724
1549 , p5_a6 NUMBER := 0-1962.0724
1550 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1551 , p5_a8 NUMBER := 0-1962.0724
1552 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1553 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1554 , p5_a11 NUMBER := 0-1962.0724
1555 , p5_a12 NUMBER := 0-1962.0724
1556 , p5_a13 NUMBER := 0-1962.0724
1557 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1558 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1559 , p5_a16 NUMBER := 0-1962.0724
1560 , p5_a17 NUMBER := 0-1962.0724
1561 , p5_a18 DATE := fnd_api.g_miss_date
1562 , p5_a19 NUMBER := 0-1962.0724
1563 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1564 , p5_a21 NUMBER := 0-1962.0724
1565 , p5_a22 NUMBER := 0-1962.0724
1566 , p5_a23 NUMBER := 0-1962.0724
1567 , p5_a24 DATE := fnd_api.g_miss_date
1568 , p5_a25 NUMBER := 0-1962.0724
1569 , p5_a26 NUMBER := 0-1962.0724
1570 , p5_a27 DATE := fnd_api.g_miss_date
1571 , p5_a28 DATE := fnd_api.g_miss_date
1572 , p5_a29 DATE := fnd_api.g_miss_date
1573 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1574 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1575 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1576 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1577 , p5_a34 NUMBER := 0-1962.0724
1578 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1579 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1580 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1581 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1582 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1583 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1584 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1585 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1586 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1587 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1588 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1589 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
1590 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
1591 , p5_a48 DATE := fnd_api.g_miss_date
1592 , p5_a49 DATE := fnd_api.g_miss_date
1593 , p5_a50 NUMBER := 0-1962.0724
1594 , p5_a51 NUMBER := 0-1962.0724
1595 , p5_a52 NUMBER := 0-1962.0724
1596 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1597 , p5_a54 NUMBER := 0-1962.0724
1598 , p5_a55 NUMBER := 0-1962.0724
1599 , p5_a56 DATE := fnd_api.g_miss_date
1600 , p5_a57 DATE := fnd_api.g_miss_date
1601 , p5_a58 NUMBER := 0-1962.0724
1602 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1603 , p5_a60 NUMBER := 0-1962.0724
1604 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
1605 )
1606
1607 as
1608 ddp_silv_rec okl_sil_pvt.silv_rec_type;
1609 ddindx binary_integer; indx binary_integer;
1610 begin
1611
1612 -- copy data to the local IN or IN-OUT args, if any
1613
1614
1615
1616
1617
1618 ddp_silv_rec.id := rosetta_g_miss_num_map(p5_a0);
1619 ddp_silv_rec.state_depre_dmnshing_value_rt := rosetta_g_miss_num_map(p5_a1);
1620 ddp_silv_rec.book_depre_dmnshing_value_rt := rosetta_g_miss_num_map(p5_a2);
1621 ddp_silv_rec.residual_guarantee_method := p5_a3;
1622 ddp_silv_rec.residual_date := rosetta_g_miss_date_in_map(p5_a4);
1623 ddp_silv_rec.fed_depre_term := rosetta_g_miss_num_map(p5_a5);
1624 ddp_silv_rec.fed_depre_dmnshing_value_rate := rosetta_g_miss_num_map(p5_a6);
1625 ddp_silv_rec.fed_depre_adr_conve := p5_a7;
1626 ddp_silv_rec.state_depre_basis_percent := rosetta_g_miss_num_map(p5_a8);
1627 ddp_silv_rec.state_depre_method := p5_a9;
1628 ddp_silv_rec.purchase_option := p5_a10;
1629 ddp_silv_rec.purchase_option_amount := rosetta_g_miss_num_map(p5_a11);
1630 ddp_silv_rec.asset_cost := rosetta_g_miss_num_map(p5_a12);
1631 ddp_silv_rec.state_depre_term := rosetta_g_miss_num_map(p5_a13);
1632 ddp_silv_rec.state_depre_adr_convent := p5_a14;
1633 ddp_silv_rec.fed_depre_method := p5_a15;
1634 ddp_silv_rec.residual_amount := rosetta_g_miss_num_map(p5_a16);
1635 ddp_silv_rec.fed_depre_salvage := rosetta_g_miss_num_map(p5_a17);
1636 ddp_silv_rec.date_fed_depre := rosetta_g_miss_date_in_map(p5_a18);
1637 ddp_silv_rec.book_salvage := rosetta_g_miss_num_map(p5_a19);
1638 ddp_silv_rec.book_adr_convention := p5_a20;
1639 ddp_silv_rec.state_depre_salvage := rosetta_g_miss_num_map(p5_a21);
1640 ddp_silv_rec.fed_depre_basis_percent := rosetta_g_miss_num_map(p5_a22);
1641 ddp_silv_rec.book_basis_percent := rosetta_g_miss_num_map(p5_a23);
1642 ddp_silv_rec.date_delivery := rosetta_g_miss_date_in_map(p5_a24);
1643 ddp_silv_rec.book_term := rosetta_g_miss_num_map(p5_a25);
1644 ddp_silv_rec.residual_guarantee_amount := rosetta_g_miss_num_map(p5_a26);
1645 ddp_silv_rec.date_funding := rosetta_g_miss_date_in_map(p5_a27);
1646 ddp_silv_rec.date_book := rosetta_g_miss_date_in_map(p5_a28);
1647 ddp_silv_rec.date_state_depre := rosetta_g_miss_date_in_map(p5_a29);
1648 ddp_silv_rec.book_method := p5_a30;
1649 ddp_silv_rec.stream_interface_attribute08 := p5_a31;
1650 ddp_silv_rec.stream_interface_attribute03 := p5_a32;
1651 ddp_silv_rec.stream_interface_attribute01 := p5_a33;
1652 ddp_silv_rec.index_number := rosetta_g_miss_num_map(p5_a34);
1653 ddp_silv_rec.stream_interface_attribute05 := p5_a35;
1654 ddp_silv_rec.description := p5_a36;
1655 ddp_silv_rec.stream_interface_attribute10 := p5_a37;
1656 ddp_silv_rec.stream_interface_attribute06 := p5_a38;
1657 ddp_silv_rec.stream_interface_attribute09 := p5_a39;
1658 ddp_silv_rec.stream_interface_attribute07 := p5_a40;
1659 ddp_silv_rec.stream_interface_attribute14 := p5_a41;
1660 ddp_silv_rec.stream_interface_attribute12 := p5_a42;
1661 ddp_silv_rec.stream_interface_attribute15 := p5_a43;
1662 ddp_silv_rec.stream_interface_attribute02 := p5_a44;
1663 ddp_silv_rec.stream_interface_attribute11 := p5_a45;
1664 ddp_silv_rec.stream_interface_attribute04 := p5_a46;
1665 ddp_silv_rec.stream_interface_attribute13 := p5_a47;
1666 ddp_silv_rec.date_start := rosetta_g_miss_date_in_map(p5_a48);
1667 ddp_silv_rec.date_lending := rosetta_g_miss_date_in_map(p5_a49);
1668 ddp_silv_rec.sif_id := rosetta_g_miss_num_map(p5_a50);
1669 ddp_silv_rec.object_version_number := rosetta_g_miss_num_map(p5_a51);
1670 ddp_silv_rec.kle_id := rosetta_g_miss_num_map(p5_a52);
1671 ddp_silv_rec.sil_type := p5_a53;
1672 ddp_silv_rec.created_by := rosetta_g_miss_num_map(p5_a54);
1673 ddp_silv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a55);
1674 ddp_silv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a56);
1675 ddp_silv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
1676 ddp_silv_rec.last_update_login := rosetta_g_miss_num_map(p5_a58);
1677 ddp_silv_rec.residual_guarantee_type := p5_a59;
1678 ddp_silv_rec.down_payment_amount := rosetta_g_miss_num_map(p5_a60);
1679 ddp_silv_rec.capitalize_down_payment_yn := p5_a61;
1680
1681 -- here's the delegated call to the old PL/SQL routine
1682 okl_sil_pvt.lock_row(p_api_version,
1683 p_init_msg_list,
1684 x_return_status,
1685 x_msg_count,
1686 x_msg_data,
1687 ddp_silv_rec);
1688
1689 -- copy data back from the local variables to OUT or IN-OUT args, if any
1690
1691
1692
1693
1694
1695 end;
1696
1697 procedure lock_row(p_api_version NUMBER
1698 , p_init_msg_list VARCHAR2
1699 , x_return_status out nocopy VARCHAR2
1700 , x_msg_count out nocopy NUMBER
1701 , x_msg_data out nocopy VARCHAR2
1702 , p5_a0 JTF_NUMBER_TABLE
1703 , p5_a1 JTF_NUMBER_TABLE
1704 , p5_a2 JTF_NUMBER_TABLE
1705 , p5_a3 JTF_VARCHAR2_TABLE_100
1706 , p5_a4 JTF_DATE_TABLE
1707 , p5_a5 JTF_NUMBER_TABLE
1708 , p5_a6 JTF_NUMBER_TABLE
1709 , p5_a7 JTF_VARCHAR2_TABLE_100
1710 , p5_a8 JTF_NUMBER_TABLE
1711 , p5_a9 JTF_VARCHAR2_TABLE_100
1712 , p5_a10 JTF_VARCHAR2_TABLE_100
1713 , p5_a11 JTF_NUMBER_TABLE
1714 , p5_a12 JTF_NUMBER_TABLE
1715 , p5_a13 JTF_NUMBER_TABLE
1716 , p5_a14 JTF_VARCHAR2_TABLE_100
1717 , p5_a15 JTF_VARCHAR2_TABLE_100
1718 , p5_a16 JTF_NUMBER_TABLE
1719 , p5_a17 JTF_NUMBER_TABLE
1720 , p5_a18 JTF_DATE_TABLE
1721 , p5_a19 JTF_NUMBER_TABLE
1722 , p5_a20 JTF_VARCHAR2_TABLE_100
1723 , p5_a21 JTF_NUMBER_TABLE
1724 , p5_a22 JTF_NUMBER_TABLE
1725 , p5_a23 JTF_NUMBER_TABLE
1726 , p5_a24 JTF_DATE_TABLE
1727 , p5_a25 JTF_NUMBER_TABLE
1728 , p5_a26 JTF_NUMBER_TABLE
1729 , p5_a27 JTF_DATE_TABLE
1730 , p5_a28 JTF_DATE_TABLE
1731 , p5_a29 JTF_DATE_TABLE
1732 , p5_a30 JTF_VARCHAR2_TABLE_100
1733 , p5_a31 JTF_VARCHAR2_TABLE_500
1734 , p5_a32 JTF_VARCHAR2_TABLE_500
1735 , p5_a33 JTF_VARCHAR2_TABLE_500
1736 , p5_a34 JTF_NUMBER_TABLE
1737 , p5_a35 JTF_VARCHAR2_TABLE_500
1738 , p5_a36 JTF_VARCHAR2_TABLE_2000
1739 , p5_a37 JTF_VARCHAR2_TABLE_500
1740 , p5_a38 JTF_VARCHAR2_TABLE_500
1741 , p5_a39 JTF_VARCHAR2_TABLE_500
1742 , p5_a40 JTF_VARCHAR2_TABLE_500
1743 , p5_a41 JTF_VARCHAR2_TABLE_500
1744 , p5_a42 JTF_VARCHAR2_TABLE_500
1745 , p5_a43 JTF_VARCHAR2_TABLE_500
1746 , p5_a44 JTF_VARCHAR2_TABLE_500
1747 , p5_a45 JTF_VARCHAR2_TABLE_500
1748 , p5_a46 JTF_VARCHAR2_TABLE_500
1749 , p5_a47 JTF_VARCHAR2_TABLE_500
1750 , p5_a48 JTF_DATE_TABLE
1751 , p5_a49 JTF_DATE_TABLE
1752 , p5_a50 JTF_NUMBER_TABLE
1753 , p5_a51 JTF_NUMBER_TABLE
1754 , p5_a52 JTF_NUMBER_TABLE
1755 , p5_a53 JTF_VARCHAR2_TABLE_100
1756 , p5_a54 JTF_NUMBER_TABLE
1757 , p5_a55 JTF_NUMBER_TABLE
1758 , p5_a56 JTF_DATE_TABLE
1759 , p5_a57 JTF_DATE_TABLE
1760 , p5_a58 JTF_NUMBER_TABLE
1761 , p5_a59 JTF_VARCHAR2_TABLE_200
1762 , p5_a60 JTF_NUMBER_TABLE
1763 , p5_a61 JTF_VARCHAR2_TABLE_100
1764 )
1765
1766 as
1767 ddp_silv_tbl okl_sil_pvt.silv_tbl_type;
1768 ddindx binary_integer; indx binary_integer;
1769 begin
1770
1771 -- copy data to the local IN or IN-OUT args, if any
1772
1773
1774
1775
1776
1777 okl_sil_pvt_w.rosetta_table_copy_in_p5(ddp_silv_tbl, p5_a0
1778 , p5_a1
1779 , p5_a2
1780 , p5_a3
1781 , p5_a4
1782 , p5_a5
1783 , p5_a6
1784 , p5_a7
1785 , p5_a8
1786 , p5_a9
1787 , p5_a10
1788 , p5_a11
1789 , p5_a12
1790 , p5_a13
1791 , p5_a14
1792 , p5_a15
1793 , p5_a16
1794 , p5_a17
1795 , p5_a18
1796 , p5_a19
1797 , p5_a20
1798 , p5_a21
1799 , p5_a22
1800 , p5_a23
1801 , p5_a24
1802 , p5_a25
1803 , p5_a26
1804 , p5_a27
1805 , p5_a28
1806 , p5_a29
1807 , p5_a30
1808 , p5_a31
1809 , p5_a32
1810 , p5_a33
1811 , p5_a34
1812 , p5_a35
1813 , p5_a36
1814 , p5_a37
1815 , p5_a38
1816 , p5_a39
1817 , p5_a40
1818 , p5_a41
1819 , p5_a42
1820 , p5_a43
1821 , p5_a44
1822 , p5_a45
1823 , p5_a46
1824 , p5_a47
1825 , p5_a48
1826 , p5_a49
1827 , p5_a50
1828 , p5_a51
1829 , p5_a52
1830 , p5_a53
1831 , p5_a54
1832 , p5_a55
1833 , p5_a56
1834 , p5_a57
1835 , p5_a58
1836 , p5_a59
1837 , p5_a60
1838 , p5_a61
1839 );
1840
1841 -- here's the delegated call to the old PL/SQL routine
1842 okl_sil_pvt.lock_row(p_api_version,
1843 p_init_msg_list,
1844 x_return_status,
1845 x_msg_count,
1846 x_msg_data,
1847 ddp_silv_tbl);
1848
1849 -- copy data back from the local variables to OUT or IN-OUT args, if any
1850
1851
1852
1853
1854
1855 end;
1856
1857 procedure update_row(p_api_version NUMBER
1858 , p_init_msg_list VARCHAR2
1859 , x_return_status out nocopy VARCHAR2
1860 , x_msg_count out nocopy NUMBER
1861 , x_msg_data out nocopy VARCHAR2
1862 , p6_a0 out nocopy NUMBER
1863 , p6_a1 out nocopy NUMBER
1864 , p6_a2 out nocopy NUMBER
1865 , p6_a3 out nocopy VARCHAR2
1866 , p6_a4 out nocopy DATE
1867 , p6_a5 out nocopy NUMBER
1868 , p6_a6 out nocopy NUMBER
1869 , p6_a7 out nocopy VARCHAR2
1870 , p6_a8 out nocopy NUMBER
1871 , p6_a9 out nocopy VARCHAR2
1872 , p6_a10 out nocopy VARCHAR2
1873 , p6_a11 out nocopy NUMBER
1874 , p6_a12 out nocopy NUMBER
1875 , p6_a13 out nocopy NUMBER
1876 , p6_a14 out nocopy VARCHAR2
1877 , p6_a15 out nocopy VARCHAR2
1878 , p6_a16 out nocopy NUMBER
1879 , p6_a17 out nocopy NUMBER
1880 , p6_a18 out nocopy DATE
1881 , p6_a19 out nocopy NUMBER
1882 , p6_a20 out nocopy VARCHAR2
1883 , p6_a21 out nocopy NUMBER
1884 , p6_a22 out nocopy NUMBER
1885 , p6_a23 out nocopy NUMBER
1886 , p6_a24 out nocopy DATE
1887 , p6_a25 out nocopy NUMBER
1888 , p6_a26 out nocopy NUMBER
1889 , p6_a27 out nocopy DATE
1890 , p6_a28 out nocopy DATE
1891 , p6_a29 out nocopy DATE
1892 , p6_a30 out nocopy VARCHAR2
1893 , p6_a31 out nocopy VARCHAR2
1894 , p6_a32 out nocopy VARCHAR2
1895 , p6_a33 out nocopy VARCHAR2
1896 , p6_a34 out nocopy NUMBER
1897 , p6_a35 out nocopy VARCHAR2
1898 , p6_a36 out nocopy VARCHAR2
1899 , p6_a37 out nocopy VARCHAR2
1900 , p6_a38 out nocopy VARCHAR2
1901 , p6_a39 out nocopy VARCHAR2
1902 , p6_a40 out nocopy VARCHAR2
1903 , p6_a41 out nocopy VARCHAR2
1904 , p6_a42 out nocopy VARCHAR2
1905 , p6_a43 out nocopy VARCHAR2
1906 , p6_a44 out nocopy VARCHAR2
1907 , p6_a45 out nocopy VARCHAR2
1908 , p6_a46 out nocopy VARCHAR2
1909 , p6_a47 out nocopy VARCHAR2
1910 , p6_a48 out nocopy DATE
1911 , p6_a49 out nocopy DATE
1912 , p6_a50 out nocopy NUMBER
1913 , p6_a51 out nocopy NUMBER
1914 , p6_a52 out nocopy NUMBER
1915 , p6_a53 out nocopy VARCHAR2
1916 , p6_a54 out nocopy NUMBER
1917 , p6_a55 out nocopy NUMBER
1918 , p6_a56 out nocopy DATE
1919 , p6_a57 out nocopy DATE
1920 , p6_a58 out nocopy NUMBER
1921 , p6_a59 out nocopy VARCHAR2
1922 , p6_a60 out nocopy NUMBER
1923 , p6_a61 out nocopy VARCHAR2
1924 , p5_a0 NUMBER := 0-1962.0724
1925 , p5_a1 NUMBER := 0-1962.0724
1926 , p5_a2 NUMBER := 0-1962.0724
1927 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1928 , p5_a4 DATE := fnd_api.g_miss_date
1929 , p5_a5 NUMBER := 0-1962.0724
1930 , p5_a6 NUMBER := 0-1962.0724
1931 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1932 , p5_a8 NUMBER := 0-1962.0724
1933 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1934 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1935 , p5_a11 NUMBER := 0-1962.0724
1936 , p5_a12 NUMBER := 0-1962.0724
1937 , p5_a13 NUMBER := 0-1962.0724
1938 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1939 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1940 , p5_a16 NUMBER := 0-1962.0724
1941 , p5_a17 NUMBER := 0-1962.0724
1942 , p5_a18 DATE := fnd_api.g_miss_date
1943 , p5_a19 NUMBER := 0-1962.0724
1944 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1945 , p5_a21 NUMBER := 0-1962.0724
1946 , p5_a22 NUMBER := 0-1962.0724
1947 , p5_a23 NUMBER := 0-1962.0724
1948 , p5_a24 DATE := fnd_api.g_miss_date
1949 , p5_a25 NUMBER := 0-1962.0724
1950 , p5_a26 NUMBER := 0-1962.0724
1951 , p5_a27 DATE := fnd_api.g_miss_date
1952 , p5_a28 DATE := fnd_api.g_miss_date
1953 , p5_a29 DATE := fnd_api.g_miss_date
1954 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1955 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1956 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1957 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1958 , p5_a34 NUMBER := 0-1962.0724
1959 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1960 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1961 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1962 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1963 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1964 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1965 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1966 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1967 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1968 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1969 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1970 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
1971 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
1972 , p5_a48 DATE := fnd_api.g_miss_date
1973 , p5_a49 DATE := fnd_api.g_miss_date
1974 , p5_a50 NUMBER := 0-1962.0724
1975 , p5_a51 NUMBER := 0-1962.0724
1976 , p5_a52 NUMBER := 0-1962.0724
1977 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1978 , p5_a54 NUMBER := 0-1962.0724
1979 , p5_a55 NUMBER := 0-1962.0724
1980 , p5_a56 DATE := fnd_api.g_miss_date
1981 , p5_a57 DATE := fnd_api.g_miss_date
1982 , p5_a58 NUMBER := 0-1962.0724
1983 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1984 , p5_a60 NUMBER := 0-1962.0724
1985 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
1986 )
1987
1988 as
1989 ddp_silv_rec okl_sil_pvt.silv_rec_type;
1990 ddx_silv_rec okl_sil_pvt.silv_rec_type;
1991 ddindx binary_integer; indx binary_integer;
1992 begin
1993
1994 -- copy data to the local IN or IN-OUT args, if any
1995
1996
1997
1998
1999
2000 ddp_silv_rec.id := rosetta_g_miss_num_map(p5_a0);
2001 ddp_silv_rec.state_depre_dmnshing_value_rt := rosetta_g_miss_num_map(p5_a1);
2002 ddp_silv_rec.book_depre_dmnshing_value_rt := rosetta_g_miss_num_map(p5_a2);
2003 ddp_silv_rec.residual_guarantee_method := p5_a3;
2004 ddp_silv_rec.residual_date := rosetta_g_miss_date_in_map(p5_a4);
2005 ddp_silv_rec.fed_depre_term := rosetta_g_miss_num_map(p5_a5);
2006 ddp_silv_rec.fed_depre_dmnshing_value_rate := rosetta_g_miss_num_map(p5_a6);
2007 ddp_silv_rec.fed_depre_adr_conve := p5_a7;
2008 ddp_silv_rec.state_depre_basis_percent := rosetta_g_miss_num_map(p5_a8);
2009 ddp_silv_rec.state_depre_method := p5_a9;
2010 ddp_silv_rec.purchase_option := p5_a10;
2011 ddp_silv_rec.purchase_option_amount := rosetta_g_miss_num_map(p5_a11);
2012 ddp_silv_rec.asset_cost := rosetta_g_miss_num_map(p5_a12);
2013 ddp_silv_rec.state_depre_term := rosetta_g_miss_num_map(p5_a13);
2014 ddp_silv_rec.state_depre_adr_convent := p5_a14;
2015 ddp_silv_rec.fed_depre_method := p5_a15;
2016 ddp_silv_rec.residual_amount := rosetta_g_miss_num_map(p5_a16);
2017 ddp_silv_rec.fed_depre_salvage := rosetta_g_miss_num_map(p5_a17);
2018 ddp_silv_rec.date_fed_depre := rosetta_g_miss_date_in_map(p5_a18);
2019 ddp_silv_rec.book_salvage := rosetta_g_miss_num_map(p5_a19);
2020 ddp_silv_rec.book_adr_convention := p5_a20;
2021 ddp_silv_rec.state_depre_salvage := rosetta_g_miss_num_map(p5_a21);
2022 ddp_silv_rec.fed_depre_basis_percent := rosetta_g_miss_num_map(p5_a22);
2023 ddp_silv_rec.book_basis_percent := rosetta_g_miss_num_map(p5_a23);
2024 ddp_silv_rec.date_delivery := rosetta_g_miss_date_in_map(p5_a24);
2025 ddp_silv_rec.book_term := rosetta_g_miss_num_map(p5_a25);
2026 ddp_silv_rec.residual_guarantee_amount := rosetta_g_miss_num_map(p5_a26);
2027 ddp_silv_rec.date_funding := rosetta_g_miss_date_in_map(p5_a27);
2028 ddp_silv_rec.date_book := rosetta_g_miss_date_in_map(p5_a28);
2029 ddp_silv_rec.date_state_depre := rosetta_g_miss_date_in_map(p5_a29);
2030 ddp_silv_rec.book_method := p5_a30;
2031 ddp_silv_rec.stream_interface_attribute08 := p5_a31;
2032 ddp_silv_rec.stream_interface_attribute03 := p5_a32;
2033 ddp_silv_rec.stream_interface_attribute01 := p5_a33;
2034 ddp_silv_rec.index_number := rosetta_g_miss_num_map(p5_a34);
2035 ddp_silv_rec.stream_interface_attribute05 := p5_a35;
2036 ddp_silv_rec.description := p5_a36;
2037 ddp_silv_rec.stream_interface_attribute10 := p5_a37;
2038 ddp_silv_rec.stream_interface_attribute06 := p5_a38;
2039 ddp_silv_rec.stream_interface_attribute09 := p5_a39;
2040 ddp_silv_rec.stream_interface_attribute07 := p5_a40;
2041 ddp_silv_rec.stream_interface_attribute14 := p5_a41;
2042 ddp_silv_rec.stream_interface_attribute12 := p5_a42;
2043 ddp_silv_rec.stream_interface_attribute15 := p5_a43;
2044 ddp_silv_rec.stream_interface_attribute02 := p5_a44;
2045 ddp_silv_rec.stream_interface_attribute11 := p5_a45;
2046 ddp_silv_rec.stream_interface_attribute04 := p5_a46;
2047 ddp_silv_rec.stream_interface_attribute13 := p5_a47;
2048 ddp_silv_rec.date_start := rosetta_g_miss_date_in_map(p5_a48);
2049 ddp_silv_rec.date_lending := rosetta_g_miss_date_in_map(p5_a49);
2050 ddp_silv_rec.sif_id := rosetta_g_miss_num_map(p5_a50);
2051 ddp_silv_rec.object_version_number := rosetta_g_miss_num_map(p5_a51);
2052 ddp_silv_rec.kle_id := rosetta_g_miss_num_map(p5_a52);
2053 ddp_silv_rec.sil_type := p5_a53;
2054 ddp_silv_rec.created_by := rosetta_g_miss_num_map(p5_a54);
2055 ddp_silv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a55);
2056 ddp_silv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a56);
2057 ddp_silv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
2058 ddp_silv_rec.last_update_login := rosetta_g_miss_num_map(p5_a58);
2059 ddp_silv_rec.residual_guarantee_type := p5_a59;
2060 ddp_silv_rec.down_payment_amount := rosetta_g_miss_num_map(p5_a60);
2061 ddp_silv_rec.capitalize_down_payment_yn := p5_a61;
2062
2063
2064 -- here's the delegated call to the old PL/SQL routine
2065 okl_sil_pvt.update_row(p_api_version,
2066 p_init_msg_list,
2067 x_return_status,
2068 x_msg_count,
2069 x_msg_data,
2070 ddp_silv_rec,
2071 ddx_silv_rec);
2072
2073 -- copy data back from the local variables to OUT or IN-OUT args, if any
2074
2075
2076
2077
2078
2079
2080 p6_a0 := rosetta_g_miss_num_map(ddx_silv_rec.id);
2081 p6_a1 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_dmnshing_value_rt);
2082 p6_a2 := rosetta_g_miss_num_map(ddx_silv_rec.book_depre_dmnshing_value_rt);
2083 p6_a3 := ddx_silv_rec.residual_guarantee_method;
2084 p6_a4 := ddx_silv_rec.residual_date;
2085 p6_a5 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_term);
2086 p6_a6 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_dmnshing_value_rate);
2087 p6_a7 := ddx_silv_rec.fed_depre_adr_conve;
2088 p6_a8 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_basis_percent);
2089 p6_a9 := ddx_silv_rec.state_depre_method;
2090 p6_a10 := ddx_silv_rec.purchase_option;
2091 p6_a11 := rosetta_g_miss_num_map(ddx_silv_rec.purchase_option_amount);
2092 p6_a12 := rosetta_g_miss_num_map(ddx_silv_rec.asset_cost);
2093 p6_a13 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_term);
2094 p6_a14 := ddx_silv_rec.state_depre_adr_convent;
2095 p6_a15 := ddx_silv_rec.fed_depre_method;
2096 p6_a16 := rosetta_g_miss_num_map(ddx_silv_rec.residual_amount);
2097 p6_a17 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_salvage);
2098 p6_a18 := ddx_silv_rec.date_fed_depre;
2099 p6_a19 := rosetta_g_miss_num_map(ddx_silv_rec.book_salvage);
2100 p6_a20 := ddx_silv_rec.book_adr_convention;
2101 p6_a21 := rosetta_g_miss_num_map(ddx_silv_rec.state_depre_salvage);
2102 p6_a22 := rosetta_g_miss_num_map(ddx_silv_rec.fed_depre_basis_percent);
2103 p6_a23 := rosetta_g_miss_num_map(ddx_silv_rec.book_basis_percent);
2104 p6_a24 := ddx_silv_rec.date_delivery;
2105 p6_a25 := rosetta_g_miss_num_map(ddx_silv_rec.book_term);
2106 p6_a26 := rosetta_g_miss_num_map(ddx_silv_rec.residual_guarantee_amount);
2107 p6_a27 := ddx_silv_rec.date_funding;
2108 p6_a28 := ddx_silv_rec.date_book;
2109 p6_a29 := ddx_silv_rec.date_state_depre;
2110 p6_a30 := ddx_silv_rec.book_method;
2111 p6_a31 := ddx_silv_rec.stream_interface_attribute08;
2112 p6_a32 := ddx_silv_rec.stream_interface_attribute03;
2113 p6_a33 := ddx_silv_rec.stream_interface_attribute01;
2114 p6_a34 := rosetta_g_miss_num_map(ddx_silv_rec.index_number);
2115 p6_a35 := ddx_silv_rec.stream_interface_attribute05;
2116 p6_a36 := ddx_silv_rec.description;
2117 p6_a37 := ddx_silv_rec.stream_interface_attribute10;
2118 p6_a38 := ddx_silv_rec.stream_interface_attribute06;
2119 p6_a39 := ddx_silv_rec.stream_interface_attribute09;
2120 p6_a40 := ddx_silv_rec.stream_interface_attribute07;
2121 p6_a41 := ddx_silv_rec.stream_interface_attribute14;
2122 p6_a42 := ddx_silv_rec.stream_interface_attribute12;
2123 p6_a43 := ddx_silv_rec.stream_interface_attribute15;
2124 p6_a44 := ddx_silv_rec.stream_interface_attribute02;
2125 p6_a45 := ddx_silv_rec.stream_interface_attribute11;
2126 p6_a46 := ddx_silv_rec.stream_interface_attribute04;
2127 p6_a47 := ddx_silv_rec.stream_interface_attribute13;
2128 p6_a48 := ddx_silv_rec.date_start;
2129 p6_a49 := ddx_silv_rec.date_lending;
2130 p6_a50 := rosetta_g_miss_num_map(ddx_silv_rec.sif_id);
2131 p6_a51 := rosetta_g_miss_num_map(ddx_silv_rec.object_version_number);
2132 p6_a52 := rosetta_g_miss_num_map(ddx_silv_rec.kle_id);
2133 p6_a53 := ddx_silv_rec.sil_type;
2134 p6_a54 := rosetta_g_miss_num_map(ddx_silv_rec.created_by);
2135 p6_a55 := rosetta_g_miss_num_map(ddx_silv_rec.last_updated_by);
2136 p6_a56 := ddx_silv_rec.creation_date;
2137 p6_a57 := ddx_silv_rec.last_update_date;
2138 p6_a58 := rosetta_g_miss_num_map(ddx_silv_rec.last_update_login);
2139 p6_a59 := ddx_silv_rec.residual_guarantee_type;
2140 p6_a60 := rosetta_g_miss_num_map(ddx_silv_rec.down_payment_amount);
2141 p6_a61 := ddx_silv_rec.capitalize_down_payment_yn;
2142 end;
2143
2144 procedure update_row(p_api_version NUMBER
2145 , p_init_msg_list VARCHAR2
2146 , x_return_status out nocopy VARCHAR2
2147 , x_msg_count out nocopy NUMBER
2148 , x_msg_data out nocopy VARCHAR2
2149 , p5_a0 JTF_NUMBER_TABLE
2150 , p5_a1 JTF_NUMBER_TABLE
2151 , p5_a2 JTF_NUMBER_TABLE
2152 , p5_a3 JTF_VARCHAR2_TABLE_100
2153 , p5_a4 JTF_DATE_TABLE
2154 , p5_a5 JTF_NUMBER_TABLE
2155 , p5_a6 JTF_NUMBER_TABLE
2156 , p5_a7 JTF_VARCHAR2_TABLE_100
2157 , p5_a8 JTF_NUMBER_TABLE
2158 , p5_a9 JTF_VARCHAR2_TABLE_100
2159 , p5_a10 JTF_VARCHAR2_TABLE_100
2160 , p5_a11 JTF_NUMBER_TABLE
2161 , p5_a12 JTF_NUMBER_TABLE
2162 , p5_a13 JTF_NUMBER_TABLE
2163 , p5_a14 JTF_VARCHAR2_TABLE_100
2164 , p5_a15 JTF_VARCHAR2_TABLE_100
2165 , p5_a16 JTF_NUMBER_TABLE
2166 , p5_a17 JTF_NUMBER_TABLE
2167 , p5_a18 JTF_DATE_TABLE
2168 , p5_a19 JTF_NUMBER_TABLE
2169 , p5_a20 JTF_VARCHAR2_TABLE_100
2170 , p5_a21 JTF_NUMBER_TABLE
2171 , p5_a22 JTF_NUMBER_TABLE
2172 , p5_a23 JTF_NUMBER_TABLE
2173 , p5_a24 JTF_DATE_TABLE
2174 , p5_a25 JTF_NUMBER_TABLE
2175 , p5_a26 JTF_NUMBER_TABLE
2176 , p5_a27 JTF_DATE_TABLE
2177 , p5_a28 JTF_DATE_TABLE
2178 , p5_a29 JTF_DATE_TABLE
2179 , p5_a30 JTF_VARCHAR2_TABLE_100
2180 , p5_a31 JTF_VARCHAR2_TABLE_500
2181 , p5_a32 JTF_VARCHAR2_TABLE_500
2182 , p5_a33 JTF_VARCHAR2_TABLE_500
2183 , p5_a34 JTF_NUMBER_TABLE
2184 , p5_a35 JTF_VARCHAR2_TABLE_500
2185 , p5_a36 JTF_VARCHAR2_TABLE_2000
2186 , p5_a37 JTF_VARCHAR2_TABLE_500
2187 , p5_a38 JTF_VARCHAR2_TABLE_500
2188 , p5_a39 JTF_VARCHAR2_TABLE_500
2189 , p5_a40 JTF_VARCHAR2_TABLE_500
2190 , p5_a41 JTF_VARCHAR2_TABLE_500
2191 , p5_a42 JTF_VARCHAR2_TABLE_500
2192 , p5_a43 JTF_VARCHAR2_TABLE_500
2193 , p5_a44 JTF_VARCHAR2_TABLE_500
2194 , p5_a45 JTF_VARCHAR2_TABLE_500
2195 , p5_a46 JTF_VARCHAR2_TABLE_500
2196 , p5_a47 JTF_VARCHAR2_TABLE_500
2197 , p5_a48 JTF_DATE_TABLE
2198 , p5_a49 JTF_DATE_TABLE
2199 , p5_a50 JTF_NUMBER_TABLE
2200 , p5_a51 JTF_NUMBER_TABLE
2201 , p5_a52 JTF_NUMBER_TABLE
2202 , p5_a53 JTF_VARCHAR2_TABLE_100
2203 , p5_a54 JTF_NUMBER_TABLE
2204 , p5_a55 JTF_NUMBER_TABLE
2205 , p5_a56 JTF_DATE_TABLE
2206 , p5_a57 JTF_DATE_TABLE
2207 , p5_a58 JTF_NUMBER_TABLE
2208 , p5_a59 JTF_VARCHAR2_TABLE_200
2209 , p5_a60 JTF_NUMBER_TABLE
2210 , p5_a61 JTF_VARCHAR2_TABLE_100
2211 , p6_a0 out nocopy JTF_NUMBER_TABLE
2212 , p6_a1 out nocopy JTF_NUMBER_TABLE
2213 , p6_a2 out nocopy JTF_NUMBER_TABLE
2214 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2215 , p6_a4 out nocopy JTF_DATE_TABLE
2216 , p6_a5 out nocopy JTF_NUMBER_TABLE
2217 , p6_a6 out nocopy JTF_NUMBER_TABLE
2218 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2219 , p6_a8 out nocopy JTF_NUMBER_TABLE
2220 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2221 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2222 , p6_a11 out nocopy JTF_NUMBER_TABLE
2223 , p6_a12 out nocopy JTF_NUMBER_TABLE
2224 , p6_a13 out nocopy JTF_NUMBER_TABLE
2225 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
2226 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
2227 , p6_a16 out nocopy JTF_NUMBER_TABLE
2228 , p6_a17 out nocopy JTF_NUMBER_TABLE
2229 , p6_a18 out nocopy JTF_DATE_TABLE
2230 , p6_a19 out nocopy JTF_NUMBER_TABLE
2231 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2232 , p6_a21 out nocopy JTF_NUMBER_TABLE
2233 , p6_a22 out nocopy JTF_NUMBER_TABLE
2234 , p6_a23 out nocopy JTF_NUMBER_TABLE
2235 , p6_a24 out nocopy JTF_DATE_TABLE
2236 , p6_a25 out nocopy JTF_NUMBER_TABLE
2237 , p6_a26 out nocopy JTF_NUMBER_TABLE
2238 , p6_a27 out nocopy JTF_DATE_TABLE
2239 , p6_a28 out nocopy JTF_DATE_TABLE
2240 , p6_a29 out nocopy JTF_DATE_TABLE
2241 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
2242 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
2243 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
2244 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
2245 , p6_a34 out nocopy JTF_NUMBER_TABLE
2246 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
2247 , p6_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2248 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_500
2249 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_500
2250 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_500
2251 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_500
2252 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
2253 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
2254 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500
2255 , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
2256 , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
2257 , p6_a46 out nocopy JTF_VARCHAR2_TABLE_500
2258 , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
2259 , p6_a48 out nocopy JTF_DATE_TABLE
2260 , p6_a49 out nocopy JTF_DATE_TABLE
2261 , p6_a50 out nocopy JTF_NUMBER_TABLE
2262 , p6_a51 out nocopy JTF_NUMBER_TABLE
2263 , p6_a52 out nocopy JTF_NUMBER_TABLE
2264 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
2265 , p6_a54 out nocopy JTF_NUMBER_TABLE
2266 , p6_a55 out nocopy JTF_NUMBER_TABLE
2267 , p6_a56 out nocopy JTF_DATE_TABLE
2268 , p6_a57 out nocopy JTF_DATE_TABLE
2269 , p6_a58 out nocopy JTF_NUMBER_TABLE
2270 , p6_a59 out nocopy JTF_VARCHAR2_TABLE_200
2271 , p6_a60 out nocopy JTF_NUMBER_TABLE
2272 , p6_a61 out nocopy JTF_VARCHAR2_TABLE_100
2273 )
2274
2275 as
2276 ddp_silv_tbl okl_sil_pvt.silv_tbl_type;
2277 ddx_silv_tbl okl_sil_pvt.silv_tbl_type;
2278 ddindx binary_integer; indx binary_integer;
2279 begin
2280
2281 -- copy data to the local IN or IN-OUT args, if any
2282
2283
2284
2285
2286
2287 okl_sil_pvt_w.rosetta_table_copy_in_p5(ddp_silv_tbl, p5_a0
2288 , p5_a1
2289 , p5_a2
2290 , p5_a3
2291 , p5_a4
2292 , p5_a5
2293 , p5_a6
2294 , p5_a7
2295 , p5_a8
2296 , p5_a9
2297 , p5_a10
2298 , p5_a11
2299 , p5_a12
2300 , p5_a13
2301 , p5_a14
2302 , p5_a15
2303 , p5_a16
2304 , p5_a17
2305 , p5_a18
2306 , p5_a19
2307 , p5_a20
2308 , p5_a21
2309 , p5_a22
2310 , p5_a23
2311 , p5_a24
2312 , p5_a25
2313 , p5_a26
2314 , p5_a27
2315 , p5_a28
2316 , p5_a29
2317 , p5_a30
2318 , p5_a31
2319 , p5_a32
2320 , p5_a33
2321 , p5_a34
2322 , p5_a35
2323 , p5_a36
2324 , p5_a37
2325 , p5_a38
2326 , p5_a39
2327 , p5_a40
2328 , p5_a41
2329 , p5_a42
2330 , p5_a43
2331 , p5_a44
2332 , p5_a45
2333 , p5_a46
2334 , p5_a47
2335 , p5_a48
2336 , p5_a49
2337 , p5_a50
2338 , p5_a51
2339 , p5_a52
2340 , p5_a53
2341 , p5_a54
2342 , p5_a55
2343 , p5_a56
2344 , p5_a57
2345 , p5_a58
2346 , p5_a59
2347 , p5_a60
2348 , p5_a61
2349 );
2350
2351
2352 -- here's the delegated call to the old PL/SQL routine
2353 okl_sil_pvt.update_row(p_api_version,
2354 p_init_msg_list,
2355 x_return_status,
2356 x_msg_count,
2357 x_msg_data,
2358 ddp_silv_tbl,
2359 ddx_silv_tbl);
2360
2361 -- copy data back from the local variables to OUT or IN-OUT args, if any
2362
2363
2364
2365
2366
2367
2368 okl_sil_pvt_w.rosetta_table_copy_out_p5(ddx_silv_tbl, p6_a0
2369 , p6_a1
2370 , p6_a2
2371 , p6_a3
2372 , p6_a4
2373 , p6_a5
2374 , p6_a6
2375 , p6_a7
2376 , p6_a8
2377 , p6_a9
2378 , p6_a10
2379 , p6_a11
2380 , p6_a12
2381 , p6_a13
2382 , p6_a14
2383 , p6_a15
2384 , p6_a16
2385 , p6_a17
2386 , p6_a18
2387 , p6_a19
2388 , p6_a20
2389 , p6_a21
2390 , p6_a22
2391 , p6_a23
2392 , p6_a24
2393 , p6_a25
2394 , p6_a26
2395 , p6_a27
2396 , p6_a28
2397 , p6_a29
2398 , p6_a30
2399 , p6_a31
2400 , p6_a32
2401 , p6_a33
2402 , p6_a34
2403 , p6_a35
2404 , p6_a36
2405 , p6_a37
2406 , p6_a38
2407 , p6_a39
2408 , p6_a40
2409 , p6_a41
2410 , p6_a42
2411 , p6_a43
2412 , p6_a44
2413 , p6_a45
2414 , p6_a46
2415 , p6_a47
2416 , p6_a48
2417 , p6_a49
2418 , p6_a50
2419 , p6_a51
2420 , p6_a52
2421 , p6_a53
2422 , p6_a54
2423 , p6_a55
2424 , p6_a56
2425 , p6_a57
2426 , p6_a58
2427 , p6_a59
2428 , p6_a60
2429 , p6_a61
2430 );
2431 end;
2432
2433 procedure delete_row(p_api_version NUMBER
2434 , p_init_msg_list VARCHAR2
2435 , x_return_status out nocopy VARCHAR2
2436 , x_msg_count out nocopy NUMBER
2437 , x_msg_data out nocopy VARCHAR2
2438 , p5_a0 NUMBER := 0-1962.0724
2439 , p5_a1 NUMBER := 0-1962.0724
2440 , p5_a2 NUMBER := 0-1962.0724
2441 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2442 , p5_a4 DATE := fnd_api.g_miss_date
2443 , p5_a5 NUMBER := 0-1962.0724
2444 , p5_a6 NUMBER := 0-1962.0724
2445 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2446 , p5_a8 NUMBER := 0-1962.0724
2447 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2448 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2449 , p5_a11 NUMBER := 0-1962.0724
2450 , p5_a12 NUMBER := 0-1962.0724
2451 , p5_a13 NUMBER := 0-1962.0724
2452 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2453 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2454 , p5_a16 NUMBER := 0-1962.0724
2455 , p5_a17 NUMBER := 0-1962.0724
2456 , p5_a18 DATE := fnd_api.g_miss_date
2457 , p5_a19 NUMBER := 0-1962.0724
2458 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2459 , p5_a21 NUMBER := 0-1962.0724
2460 , p5_a22 NUMBER := 0-1962.0724
2461 , p5_a23 NUMBER := 0-1962.0724
2462 , p5_a24 DATE := fnd_api.g_miss_date
2463 , p5_a25 NUMBER := 0-1962.0724
2464 , p5_a26 NUMBER := 0-1962.0724
2465 , p5_a27 DATE := fnd_api.g_miss_date
2466 , p5_a28 DATE := fnd_api.g_miss_date
2467 , p5_a29 DATE := fnd_api.g_miss_date
2468 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2469 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2470 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2471 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2472 , p5_a34 NUMBER := 0-1962.0724
2473 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2474 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2475 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2476 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2477 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2478 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
2479 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
2480 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2481 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
2482 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
2483 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
2484 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
2485 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
2486 , p5_a48 DATE := fnd_api.g_miss_date
2487 , p5_a49 DATE := fnd_api.g_miss_date
2488 , p5_a50 NUMBER := 0-1962.0724
2489 , p5_a51 NUMBER := 0-1962.0724
2490 , p5_a52 NUMBER := 0-1962.0724
2491 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
2492 , p5_a54 NUMBER := 0-1962.0724
2493 , p5_a55 NUMBER := 0-1962.0724
2494 , p5_a56 DATE := fnd_api.g_miss_date
2495 , p5_a57 DATE := fnd_api.g_miss_date
2496 , p5_a58 NUMBER := 0-1962.0724
2497 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
2498 , p5_a60 NUMBER := 0-1962.0724
2499 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
2500 )
2501
2502 as
2503 ddp_silv_rec okl_sil_pvt.silv_rec_type;
2504 ddindx binary_integer; indx binary_integer;
2505 begin
2506
2507 -- copy data to the local IN or IN-OUT args, if any
2508
2509
2510
2511
2512
2513 ddp_silv_rec.id := rosetta_g_miss_num_map(p5_a0);
2514 ddp_silv_rec.state_depre_dmnshing_value_rt := rosetta_g_miss_num_map(p5_a1);
2515 ddp_silv_rec.book_depre_dmnshing_value_rt := rosetta_g_miss_num_map(p5_a2);
2516 ddp_silv_rec.residual_guarantee_method := p5_a3;
2517 ddp_silv_rec.residual_date := rosetta_g_miss_date_in_map(p5_a4);
2518 ddp_silv_rec.fed_depre_term := rosetta_g_miss_num_map(p5_a5);
2519 ddp_silv_rec.fed_depre_dmnshing_value_rate := rosetta_g_miss_num_map(p5_a6);
2520 ddp_silv_rec.fed_depre_adr_conve := p5_a7;
2521 ddp_silv_rec.state_depre_basis_percent := rosetta_g_miss_num_map(p5_a8);
2522 ddp_silv_rec.state_depre_method := p5_a9;
2523 ddp_silv_rec.purchase_option := p5_a10;
2524 ddp_silv_rec.purchase_option_amount := rosetta_g_miss_num_map(p5_a11);
2525 ddp_silv_rec.asset_cost := rosetta_g_miss_num_map(p5_a12);
2526 ddp_silv_rec.state_depre_term := rosetta_g_miss_num_map(p5_a13);
2527 ddp_silv_rec.state_depre_adr_convent := p5_a14;
2528 ddp_silv_rec.fed_depre_method := p5_a15;
2529 ddp_silv_rec.residual_amount := rosetta_g_miss_num_map(p5_a16);
2530 ddp_silv_rec.fed_depre_salvage := rosetta_g_miss_num_map(p5_a17);
2531 ddp_silv_rec.date_fed_depre := rosetta_g_miss_date_in_map(p5_a18);
2532 ddp_silv_rec.book_salvage := rosetta_g_miss_num_map(p5_a19);
2533 ddp_silv_rec.book_adr_convention := p5_a20;
2534 ddp_silv_rec.state_depre_salvage := rosetta_g_miss_num_map(p5_a21);
2535 ddp_silv_rec.fed_depre_basis_percent := rosetta_g_miss_num_map(p5_a22);
2536 ddp_silv_rec.book_basis_percent := rosetta_g_miss_num_map(p5_a23);
2537 ddp_silv_rec.date_delivery := rosetta_g_miss_date_in_map(p5_a24);
2538 ddp_silv_rec.book_term := rosetta_g_miss_num_map(p5_a25);
2539 ddp_silv_rec.residual_guarantee_amount := rosetta_g_miss_num_map(p5_a26);
2540 ddp_silv_rec.date_funding := rosetta_g_miss_date_in_map(p5_a27);
2541 ddp_silv_rec.date_book := rosetta_g_miss_date_in_map(p5_a28);
2542 ddp_silv_rec.date_state_depre := rosetta_g_miss_date_in_map(p5_a29);
2543 ddp_silv_rec.book_method := p5_a30;
2544 ddp_silv_rec.stream_interface_attribute08 := p5_a31;
2545 ddp_silv_rec.stream_interface_attribute03 := p5_a32;
2546 ddp_silv_rec.stream_interface_attribute01 := p5_a33;
2547 ddp_silv_rec.index_number := rosetta_g_miss_num_map(p5_a34);
2548 ddp_silv_rec.stream_interface_attribute05 := p5_a35;
2549 ddp_silv_rec.description := p5_a36;
2550 ddp_silv_rec.stream_interface_attribute10 := p5_a37;
2551 ddp_silv_rec.stream_interface_attribute06 := p5_a38;
2552 ddp_silv_rec.stream_interface_attribute09 := p5_a39;
2553 ddp_silv_rec.stream_interface_attribute07 := p5_a40;
2554 ddp_silv_rec.stream_interface_attribute14 := p5_a41;
2555 ddp_silv_rec.stream_interface_attribute12 := p5_a42;
2556 ddp_silv_rec.stream_interface_attribute15 := p5_a43;
2557 ddp_silv_rec.stream_interface_attribute02 := p5_a44;
2558 ddp_silv_rec.stream_interface_attribute11 := p5_a45;
2559 ddp_silv_rec.stream_interface_attribute04 := p5_a46;
2560 ddp_silv_rec.stream_interface_attribute13 := p5_a47;
2561 ddp_silv_rec.date_start := rosetta_g_miss_date_in_map(p5_a48);
2562 ddp_silv_rec.date_lending := rosetta_g_miss_date_in_map(p5_a49);
2563 ddp_silv_rec.sif_id := rosetta_g_miss_num_map(p5_a50);
2564 ddp_silv_rec.object_version_number := rosetta_g_miss_num_map(p5_a51);
2565 ddp_silv_rec.kle_id := rosetta_g_miss_num_map(p5_a52);
2566 ddp_silv_rec.sil_type := p5_a53;
2567 ddp_silv_rec.created_by := rosetta_g_miss_num_map(p5_a54);
2568 ddp_silv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a55);
2569 ddp_silv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a56);
2570 ddp_silv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
2571 ddp_silv_rec.last_update_login := rosetta_g_miss_num_map(p5_a58);
2572 ddp_silv_rec.residual_guarantee_type := p5_a59;
2573 ddp_silv_rec.down_payment_amount := rosetta_g_miss_num_map(p5_a60);
2574 ddp_silv_rec.capitalize_down_payment_yn := p5_a61;
2575
2576 -- here's the delegated call to the old PL/SQL routine
2577 okl_sil_pvt.delete_row(p_api_version,
2578 p_init_msg_list,
2579 x_return_status,
2580 x_msg_count,
2581 x_msg_data,
2582 ddp_silv_rec);
2583
2584 -- copy data back from the local variables to OUT or IN-OUT args, if any
2585
2586
2587
2588
2589
2590 end;
2591
2592 procedure delete_row(p_api_version NUMBER
2593 , p_init_msg_list VARCHAR2
2594 , x_return_status out nocopy VARCHAR2
2595 , x_msg_count out nocopy NUMBER
2596 , x_msg_data out nocopy VARCHAR2
2597 , p5_a0 JTF_NUMBER_TABLE
2598 , p5_a1 JTF_NUMBER_TABLE
2599 , p5_a2 JTF_NUMBER_TABLE
2600 , p5_a3 JTF_VARCHAR2_TABLE_100
2601 , p5_a4 JTF_DATE_TABLE
2602 , p5_a5 JTF_NUMBER_TABLE
2603 , p5_a6 JTF_NUMBER_TABLE
2604 , p5_a7 JTF_VARCHAR2_TABLE_100
2605 , p5_a8 JTF_NUMBER_TABLE
2606 , p5_a9 JTF_VARCHAR2_TABLE_100
2607 , p5_a10 JTF_VARCHAR2_TABLE_100
2608 , p5_a11 JTF_NUMBER_TABLE
2609 , p5_a12 JTF_NUMBER_TABLE
2610 , p5_a13 JTF_NUMBER_TABLE
2611 , p5_a14 JTF_VARCHAR2_TABLE_100
2612 , p5_a15 JTF_VARCHAR2_TABLE_100
2613 , p5_a16 JTF_NUMBER_TABLE
2614 , p5_a17 JTF_NUMBER_TABLE
2615 , p5_a18 JTF_DATE_TABLE
2616 , p5_a19 JTF_NUMBER_TABLE
2617 , p5_a20 JTF_VARCHAR2_TABLE_100
2618 , p5_a21 JTF_NUMBER_TABLE
2619 , p5_a22 JTF_NUMBER_TABLE
2620 , p5_a23 JTF_NUMBER_TABLE
2621 , p5_a24 JTF_DATE_TABLE
2622 , p5_a25 JTF_NUMBER_TABLE
2623 , p5_a26 JTF_NUMBER_TABLE
2624 , p5_a27 JTF_DATE_TABLE
2625 , p5_a28 JTF_DATE_TABLE
2626 , p5_a29 JTF_DATE_TABLE
2627 , p5_a30 JTF_VARCHAR2_TABLE_100
2628 , p5_a31 JTF_VARCHAR2_TABLE_500
2629 , p5_a32 JTF_VARCHAR2_TABLE_500
2630 , p5_a33 JTF_VARCHAR2_TABLE_500
2631 , p5_a34 JTF_NUMBER_TABLE
2632 , p5_a35 JTF_VARCHAR2_TABLE_500
2633 , p5_a36 JTF_VARCHAR2_TABLE_2000
2634 , p5_a37 JTF_VARCHAR2_TABLE_500
2635 , p5_a38 JTF_VARCHAR2_TABLE_500
2636 , p5_a39 JTF_VARCHAR2_TABLE_500
2637 , p5_a40 JTF_VARCHAR2_TABLE_500
2638 , p5_a41 JTF_VARCHAR2_TABLE_500
2639 , p5_a42 JTF_VARCHAR2_TABLE_500
2640 , p5_a43 JTF_VARCHAR2_TABLE_500
2641 , p5_a44 JTF_VARCHAR2_TABLE_500
2642 , p5_a45 JTF_VARCHAR2_TABLE_500
2643 , p5_a46 JTF_VARCHAR2_TABLE_500
2644 , p5_a47 JTF_VARCHAR2_TABLE_500
2645 , p5_a48 JTF_DATE_TABLE
2646 , p5_a49 JTF_DATE_TABLE
2647 , p5_a50 JTF_NUMBER_TABLE
2648 , p5_a51 JTF_NUMBER_TABLE
2649 , p5_a52 JTF_NUMBER_TABLE
2650 , p5_a53 JTF_VARCHAR2_TABLE_100
2651 , p5_a54 JTF_NUMBER_TABLE
2652 , p5_a55 JTF_NUMBER_TABLE
2653 , p5_a56 JTF_DATE_TABLE
2654 , p5_a57 JTF_DATE_TABLE
2655 , p5_a58 JTF_NUMBER_TABLE
2656 , p5_a59 JTF_VARCHAR2_TABLE_200
2657 , p5_a60 JTF_NUMBER_TABLE
2658 , p5_a61 JTF_VARCHAR2_TABLE_100
2659 )
2660
2661 as
2662 ddp_silv_tbl okl_sil_pvt.silv_tbl_type;
2663 ddindx binary_integer; indx binary_integer;
2664 begin
2665
2666 -- copy data to the local IN or IN-OUT args, if any
2667
2668
2669
2670
2671
2672 okl_sil_pvt_w.rosetta_table_copy_in_p5(ddp_silv_tbl, p5_a0
2673 , p5_a1
2674 , p5_a2
2675 , p5_a3
2676 , p5_a4
2677 , p5_a5
2678 , p5_a6
2679 , p5_a7
2680 , p5_a8
2681 , p5_a9
2682 , p5_a10
2683 , p5_a11
2684 , p5_a12
2685 , p5_a13
2686 , p5_a14
2687 , p5_a15
2688 , p5_a16
2689 , p5_a17
2690 , p5_a18
2691 , p5_a19
2692 , p5_a20
2693 , p5_a21
2694 , p5_a22
2695 , p5_a23
2696 , p5_a24
2697 , p5_a25
2698 , p5_a26
2699 , p5_a27
2700 , p5_a28
2701 , p5_a29
2702 , p5_a30
2703 , p5_a31
2704 , p5_a32
2705 , p5_a33
2706 , p5_a34
2707 , p5_a35
2708 , p5_a36
2709 , p5_a37
2710 , p5_a38
2711 , p5_a39
2712 , p5_a40
2713 , p5_a41
2714 , p5_a42
2715 , p5_a43
2716 , p5_a44
2717 , p5_a45
2718 , p5_a46
2719 , p5_a47
2720 , p5_a48
2721 , p5_a49
2722 , p5_a50
2723 , p5_a51
2724 , p5_a52
2725 , p5_a53
2726 , p5_a54
2727 , p5_a55
2728 , p5_a56
2729 , p5_a57
2730 , p5_a58
2731 , p5_a59
2732 , p5_a60
2733 , p5_a61
2734 );
2735
2736 -- here's the delegated call to the old PL/SQL routine
2737 okl_sil_pvt.delete_row(p_api_version,
2738 p_init_msg_list,
2739 x_return_status,
2740 x_msg_count,
2741 x_msg_data,
2742 ddp_silv_tbl);
2743
2744 -- copy data back from the local variables to OUT or IN-OUT args, if any
2745
2746
2747
2748
2749
2750 end;
2751
2752 procedure validate_row(p_api_version NUMBER
2753 , p_init_msg_list VARCHAR2
2754 , x_return_status out nocopy VARCHAR2
2755 , x_msg_count out nocopy NUMBER
2756 , x_msg_data out nocopy VARCHAR2
2757 , p5_a0 NUMBER := 0-1962.0724
2758 , p5_a1 NUMBER := 0-1962.0724
2759 , p5_a2 NUMBER := 0-1962.0724
2760 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2761 , p5_a4 DATE := fnd_api.g_miss_date
2762 , p5_a5 NUMBER := 0-1962.0724
2763 , p5_a6 NUMBER := 0-1962.0724
2764 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2765 , p5_a8 NUMBER := 0-1962.0724
2766 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2767 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2768 , p5_a11 NUMBER := 0-1962.0724
2769 , p5_a12 NUMBER := 0-1962.0724
2770 , p5_a13 NUMBER := 0-1962.0724
2771 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2772 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2773 , p5_a16 NUMBER := 0-1962.0724
2774 , p5_a17 NUMBER := 0-1962.0724
2775 , p5_a18 DATE := fnd_api.g_miss_date
2776 , p5_a19 NUMBER := 0-1962.0724
2777 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2778 , p5_a21 NUMBER := 0-1962.0724
2779 , p5_a22 NUMBER := 0-1962.0724
2780 , p5_a23 NUMBER := 0-1962.0724
2781 , p5_a24 DATE := fnd_api.g_miss_date
2782 , p5_a25 NUMBER := 0-1962.0724
2783 , p5_a26 NUMBER := 0-1962.0724
2784 , p5_a27 DATE := fnd_api.g_miss_date
2785 , p5_a28 DATE := fnd_api.g_miss_date
2786 , p5_a29 DATE := fnd_api.g_miss_date
2787 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2788 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2789 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2790 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2791 , p5_a34 NUMBER := 0-1962.0724
2792 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2793 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2794 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2795 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2796 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2797 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
2798 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
2799 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2800 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
2801 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
2802 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
2803 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
2804 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
2805 , p5_a48 DATE := fnd_api.g_miss_date
2806 , p5_a49 DATE := fnd_api.g_miss_date
2807 , p5_a50 NUMBER := 0-1962.0724
2808 , p5_a51 NUMBER := 0-1962.0724
2809 , p5_a52 NUMBER := 0-1962.0724
2810 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
2811 , p5_a54 NUMBER := 0-1962.0724
2812 , p5_a55 NUMBER := 0-1962.0724
2813 , p5_a56 DATE := fnd_api.g_miss_date
2814 , p5_a57 DATE := fnd_api.g_miss_date
2815 , p5_a58 NUMBER := 0-1962.0724
2816 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
2817 , p5_a60 NUMBER := 0-1962.0724
2818 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
2819 )
2820
2821 as
2822 ddp_silv_rec okl_sil_pvt.silv_rec_type;
2823 ddindx binary_integer; indx binary_integer;
2824 begin
2825
2826 -- copy data to the local IN or IN-OUT args, if any
2827
2828
2829
2830
2831
2832 ddp_silv_rec.id := rosetta_g_miss_num_map(p5_a0);
2833 ddp_silv_rec.state_depre_dmnshing_value_rt := rosetta_g_miss_num_map(p5_a1);
2834 ddp_silv_rec.book_depre_dmnshing_value_rt := rosetta_g_miss_num_map(p5_a2);
2835 ddp_silv_rec.residual_guarantee_method := p5_a3;
2836 ddp_silv_rec.residual_date := rosetta_g_miss_date_in_map(p5_a4);
2837 ddp_silv_rec.fed_depre_term := rosetta_g_miss_num_map(p5_a5);
2838 ddp_silv_rec.fed_depre_dmnshing_value_rate := rosetta_g_miss_num_map(p5_a6);
2839 ddp_silv_rec.fed_depre_adr_conve := p5_a7;
2840 ddp_silv_rec.state_depre_basis_percent := rosetta_g_miss_num_map(p5_a8);
2841 ddp_silv_rec.state_depre_method := p5_a9;
2842 ddp_silv_rec.purchase_option := p5_a10;
2843 ddp_silv_rec.purchase_option_amount := rosetta_g_miss_num_map(p5_a11);
2844 ddp_silv_rec.asset_cost := rosetta_g_miss_num_map(p5_a12);
2845 ddp_silv_rec.state_depre_term := rosetta_g_miss_num_map(p5_a13);
2846 ddp_silv_rec.state_depre_adr_convent := p5_a14;
2847 ddp_silv_rec.fed_depre_method := p5_a15;
2848 ddp_silv_rec.residual_amount := rosetta_g_miss_num_map(p5_a16);
2849 ddp_silv_rec.fed_depre_salvage := rosetta_g_miss_num_map(p5_a17);
2850 ddp_silv_rec.date_fed_depre := rosetta_g_miss_date_in_map(p5_a18);
2851 ddp_silv_rec.book_salvage := rosetta_g_miss_num_map(p5_a19);
2852 ddp_silv_rec.book_adr_convention := p5_a20;
2853 ddp_silv_rec.state_depre_salvage := rosetta_g_miss_num_map(p5_a21);
2854 ddp_silv_rec.fed_depre_basis_percent := rosetta_g_miss_num_map(p5_a22);
2855 ddp_silv_rec.book_basis_percent := rosetta_g_miss_num_map(p5_a23);
2856 ddp_silv_rec.date_delivery := rosetta_g_miss_date_in_map(p5_a24);
2857 ddp_silv_rec.book_term := rosetta_g_miss_num_map(p5_a25);
2858 ddp_silv_rec.residual_guarantee_amount := rosetta_g_miss_num_map(p5_a26);
2859 ddp_silv_rec.date_funding := rosetta_g_miss_date_in_map(p5_a27);
2860 ddp_silv_rec.date_book := rosetta_g_miss_date_in_map(p5_a28);
2861 ddp_silv_rec.date_state_depre := rosetta_g_miss_date_in_map(p5_a29);
2862 ddp_silv_rec.book_method := p5_a30;
2863 ddp_silv_rec.stream_interface_attribute08 := p5_a31;
2864 ddp_silv_rec.stream_interface_attribute03 := p5_a32;
2865 ddp_silv_rec.stream_interface_attribute01 := p5_a33;
2866 ddp_silv_rec.index_number := rosetta_g_miss_num_map(p5_a34);
2867 ddp_silv_rec.stream_interface_attribute05 := p5_a35;
2868 ddp_silv_rec.description := p5_a36;
2869 ddp_silv_rec.stream_interface_attribute10 := p5_a37;
2870 ddp_silv_rec.stream_interface_attribute06 := p5_a38;
2871 ddp_silv_rec.stream_interface_attribute09 := p5_a39;
2872 ddp_silv_rec.stream_interface_attribute07 := p5_a40;
2873 ddp_silv_rec.stream_interface_attribute14 := p5_a41;
2874 ddp_silv_rec.stream_interface_attribute12 := p5_a42;
2875 ddp_silv_rec.stream_interface_attribute15 := p5_a43;
2876 ddp_silv_rec.stream_interface_attribute02 := p5_a44;
2877 ddp_silv_rec.stream_interface_attribute11 := p5_a45;
2878 ddp_silv_rec.stream_interface_attribute04 := p5_a46;
2879 ddp_silv_rec.stream_interface_attribute13 := p5_a47;
2880 ddp_silv_rec.date_start := rosetta_g_miss_date_in_map(p5_a48);
2881 ddp_silv_rec.date_lending := rosetta_g_miss_date_in_map(p5_a49);
2882 ddp_silv_rec.sif_id := rosetta_g_miss_num_map(p5_a50);
2883 ddp_silv_rec.object_version_number := rosetta_g_miss_num_map(p5_a51);
2884 ddp_silv_rec.kle_id := rosetta_g_miss_num_map(p5_a52);
2885 ddp_silv_rec.sil_type := p5_a53;
2886 ddp_silv_rec.created_by := rosetta_g_miss_num_map(p5_a54);
2887 ddp_silv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a55);
2888 ddp_silv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a56);
2889 ddp_silv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a57);
2890 ddp_silv_rec.last_update_login := rosetta_g_miss_num_map(p5_a58);
2891 ddp_silv_rec.residual_guarantee_type := p5_a59;
2892 ddp_silv_rec.down_payment_amount := rosetta_g_miss_num_map(p5_a60);
2893 ddp_silv_rec.capitalize_down_payment_yn := p5_a61;
2894
2895 -- here's the delegated call to the old PL/SQL routine
2896 okl_sil_pvt.validate_row(p_api_version,
2897 p_init_msg_list,
2898 x_return_status,
2899 x_msg_count,
2900 x_msg_data,
2901 ddp_silv_rec);
2902
2903 -- copy data back from the local variables to OUT or IN-OUT args, if any
2904
2905
2906
2907
2908
2909 end;
2910
2911 procedure validate_row(p_api_version NUMBER
2912 , p_init_msg_list VARCHAR2
2913 , x_return_status out nocopy VARCHAR2
2914 , x_msg_count out nocopy NUMBER
2915 , x_msg_data out nocopy VARCHAR2
2916 , p5_a0 JTF_NUMBER_TABLE
2917 , p5_a1 JTF_NUMBER_TABLE
2918 , p5_a2 JTF_NUMBER_TABLE
2919 , p5_a3 JTF_VARCHAR2_TABLE_100
2920 , p5_a4 JTF_DATE_TABLE
2921 , p5_a5 JTF_NUMBER_TABLE
2922 , p5_a6 JTF_NUMBER_TABLE
2923 , p5_a7 JTF_VARCHAR2_TABLE_100
2924 , p5_a8 JTF_NUMBER_TABLE
2925 , p5_a9 JTF_VARCHAR2_TABLE_100
2926 , p5_a10 JTF_VARCHAR2_TABLE_100
2927 , p5_a11 JTF_NUMBER_TABLE
2928 , p5_a12 JTF_NUMBER_TABLE
2929 , p5_a13 JTF_NUMBER_TABLE
2930 , p5_a14 JTF_VARCHAR2_TABLE_100
2931 , p5_a15 JTF_VARCHAR2_TABLE_100
2932 , p5_a16 JTF_NUMBER_TABLE
2933 , p5_a17 JTF_NUMBER_TABLE
2934 , p5_a18 JTF_DATE_TABLE
2935 , p5_a19 JTF_NUMBER_TABLE
2936 , p5_a20 JTF_VARCHAR2_TABLE_100
2937 , p5_a21 JTF_NUMBER_TABLE
2938 , p5_a22 JTF_NUMBER_TABLE
2939 , p5_a23 JTF_NUMBER_TABLE
2940 , p5_a24 JTF_DATE_TABLE
2941 , p5_a25 JTF_NUMBER_TABLE
2942 , p5_a26 JTF_NUMBER_TABLE
2943 , p5_a27 JTF_DATE_TABLE
2944 , p5_a28 JTF_DATE_TABLE
2945 , p5_a29 JTF_DATE_TABLE
2946 , p5_a30 JTF_VARCHAR2_TABLE_100
2947 , p5_a31 JTF_VARCHAR2_TABLE_500
2948 , p5_a32 JTF_VARCHAR2_TABLE_500
2949 , p5_a33 JTF_VARCHAR2_TABLE_500
2950 , p5_a34 JTF_NUMBER_TABLE
2951 , p5_a35 JTF_VARCHAR2_TABLE_500
2952 , p5_a36 JTF_VARCHAR2_TABLE_2000
2953 , p5_a37 JTF_VARCHAR2_TABLE_500
2954 , p5_a38 JTF_VARCHAR2_TABLE_500
2955 , p5_a39 JTF_VARCHAR2_TABLE_500
2956 , p5_a40 JTF_VARCHAR2_TABLE_500
2957 , p5_a41 JTF_VARCHAR2_TABLE_500
2958 , p5_a42 JTF_VARCHAR2_TABLE_500
2959 , p5_a43 JTF_VARCHAR2_TABLE_500
2960 , p5_a44 JTF_VARCHAR2_TABLE_500
2961 , p5_a45 JTF_VARCHAR2_TABLE_500
2962 , p5_a46 JTF_VARCHAR2_TABLE_500
2963 , p5_a47 JTF_VARCHAR2_TABLE_500
2964 , p5_a48 JTF_DATE_TABLE
2965 , p5_a49 JTF_DATE_TABLE
2966 , p5_a50 JTF_NUMBER_TABLE
2967 , p5_a51 JTF_NUMBER_TABLE
2968 , p5_a52 JTF_NUMBER_TABLE
2969 , p5_a53 JTF_VARCHAR2_TABLE_100
2970 , p5_a54 JTF_NUMBER_TABLE
2971 , p5_a55 JTF_NUMBER_TABLE
2972 , p5_a56 JTF_DATE_TABLE
2973 , p5_a57 JTF_DATE_TABLE
2974 , p5_a58 JTF_NUMBER_TABLE
2975 , p5_a59 JTF_VARCHAR2_TABLE_200
2976 , p5_a60 JTF_NUMBER_TABLE
2977 , p5_a61 JTF_VARCHAR2_TABLE_100
2978 )
2979
2980 as
2981 ddp_silv_tbl okl_sil_pvt.silv_tbl_type;
2982 ddindx binary_integer; indx binary_integer;
2983 begin
2984
2985 -- copy data to the local IN or IN-OUT args, if any
2986
2987
2988
2989
2990
2991 okl_sil_pvt_w.rosetta_table_copy_in_p5(ddp_silv_tbl, p5_a0
2992 , p5_a1
2993 , p5_a2
2994 , p5_a3
2995 , p5_a4
2996 , p5_a5
2997 , p5_a6
2998 , p5_a7
2999 , p5_a8
3000 , p5_a9
3001 , p5_a10
3002 , p5_a11
3003 , p5_a12
3004 , p5_a13
3005 , p5_a14
3006 , p5_a15
3007 , p5_a16
3008 , p5_a17
3009 , p5_a18
3010 , p5_a19
3011 , p5_a20
3012 , p5_a21
3013 , p5_a22
3014 , p5_a23
3015 , p5_a24
3016 , p5_a25
3017 , p5_a26
3018 , p5_a27
3019 , p5_a28
3020 , p5_a29
3021 , p5_a30
3022 , p5_a31
3023 , p5_a32
3024 , p5_a33
3025 , p5_a34
3026 , p5_a35
3027 , p5_a36
3028 , p5_a37
3029 , p5_a38
3030 , p5_a39
3031 , p5_a40
3032 , p5_a41
3033 , p5_a42
3034 , p5_a43
3035 , p5_a44
3036 , p5_a45
3037 , p5_a46
3038 , p5_a47
3039 , p5_a48
3040 , p5_a49
3041 , p5_a50
3042 , p5_a51
3043 , p5_a52
3044 , p5_a53
3045 , p5_a54
3046 , p5_a55
3047 , p5_a56
3048 , p5_a57
3049 , p5_a58
3050 , p5_a59
3051 , p5_a60
3052 , p5_a61
3053 );
3054
3055 -- here's the delegated call to the old PL/SQL routine
3056 okl_sil_pvt.validate_row(p_api_version,
3057 p_init_msg_list,
3058 x_return_status,
3059 x_msg_count,
3060 x_msg_data,
3061 ddp_silv_tbl);
3062
3063 -- copy data back from the local variables to OUT or IN-OUT args, if any
3064
3065
3066
3067
3068
3069 end;
3070
3071 end okl_sil_pvt_w;