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