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