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