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