[Home] [Help]
PACKAGE BODY: APPS.OKL_AVL_PVT_W
Source
1 package body okl_avl_pvt_w as
2 /* $Header: OKLIAVLB.pls 115.6 2003/03/26 19:48:07 hkpatel 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_avl_pvt.avl_tbl_type, a0 JTF_NUMBER_TABLE
23 , a1 JTF_VARCHAR2_TABLE_200
24 , a2 JTF_NUMBER_TABLE
25 , a3 JTF_NUMBER_TABLE
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_VARCHAR2_TABLE_100
32 , a10 JTF_VARCHAR2_TABLE_100
33 , a11 JTF_VARCHAR2_TABLE_100
34 , a12 JTF_DATE_TABLE
35 , a13 JTF_NUMBER_TABLE
36 , a14 JTF_VARCHAR2_TABLE_100
37 , a15 JTF_VARCHAR2_TABLE_100
38 , a16 JTF_VARCHAR2_TABLE_2000
39 , a17 JTF_VARCHAR2_TABLE_100
40 , a18 JTF_DATE_TABLE
41 , a19 JTF_VARCHAR2_TABLE_100
42 , a20 JTF_NUMBER_TABLE
43 , a21 JTF_VARCHAR2_TABLE_100
44 , a22 JTF_VARCHAR2_TABLE_500
45 , a23 JTF_VARCHAR2_TABLE_500
46 , a24 JTF_VARCHAR2_TABLE_500
47 , a25 JTF_VARCHAR2_TABLE_500
48 , a26 JTF_VARCHAR2_TABLE_500
49 , a27 JTF_VARCHAR2_TABLE_500
50 , a28 JTF_VARCHAR2_TABLE_500
51 , a29 JTF_VARCHAR2_TABLE_500
52 , a30 JTF_VARCHAR2_TABLE_500
53 , a31 JTF_VARCHAR2_TABLE_500
54 , a32 JTF_VARCHAR2_TABLE_500
55 , a33 JTF_VARCHAR2_TABLE_500
56 , a34 JTF_VARCHAR2_TABLE_500
57 , a35 JTF_VARCHAR2_TABLE_500
58 , a36 JTF_VARCHAR2_TABLE_500
59 , a37 JTF_NUMBER_TABLE
60 , a38 JTF_DATE_TABLE
61 , a39 JTF_NUMBER_TABLE
62 , a40 JTF_DATE_TABLE
63 , a41 JTF_NUMBER_TABLE
64 , a42 JTF_VARCHAR2_TABLE_100
65 ) as
66 ddindx binary_integer; indx binary_integer;
67 begin
68 if a0 is not null and a0.count > 0 then
69 if a0.count > 0 then
70 indx := a0.first;
71 ddindx := 1;
72 while true loop
73 t(ddindx).id := rosetta_g_miss_num_map(a0(indx));
74 t(ddindx).name := a1(indx);
75 t(ddindx).set_of_books_id := rosetta_g_miss_num_map(a2(indx));
76 t(ddindx).sty_id := rosetta_g_miss_num_map(a3(indx));
77 t(ddindx).try_id := rosetta_g_miss_num_map(a4(indx));
78 t(ddindx).aes_id := rosetta_g_miss_num_map(a5(indx));
79 t(ddindx).syt_code := a6(indx);
80 t(ddindx).fac_code := a7(indx);
81 t(ddindx).fma_id := rosetta_g_miss_num_map(a8(indx));
82 t(ddindx).advance_arrears := a9(indx);
83 t(ddindx).post_to_gl := a10(indx);
84 t(ddindx).version := a11(indx);
85 t(ddindx).start_date := rosetta_g_miss_date_in_map(a12(indx));
86 t(ddindx).object_version_number := rosetta_g_miss_num_map(a13(indx));
87 t(ddindx).memo_yn := a14(indx);
88 t(ddindx).prior_year_yn := a15(indx);
89 t(ddindx).description := a16(indx);
90 t(ddindx).factoring_synd_flag := a17(indx);
91 t(ddindx).end_date := rosetta_g_miss_date_in_map(a18(indx));
92 t(ddindx).accrual_yn := a19(indx);
93 t(ddindx).org_id := rosetta_g_miss_num_map(a20(indx));
94 t(ddindx).attribute_category := a21(indx);
95 t(ddindx).attribute1 := a22(indx);
96 t(ddindx).attribute2 := a23(indx);
97 t(ddindx).attribute3 := a24(indx);
98 t(ddindx).attribute4 := a25(indx);
99 t(ddindx).attribute5 := a26(indx);
100 t(ddindx).attribute6 := a27(indx);
101 t(ddindx).attribute7 := a28(indx);
102 t(ddindx).attribute8 := a29(indx);
103 t(ddindx).attribute9 := a30(indx);
104 t(ddindx).attribute10 := a31(indx);
105 t(ddindx).attribute11 := a32(indx);
106 t(ddindx).attribute12 := a33(indx);
107 t(ddindx).attribute13 := a34(indx);
108 t(ddindx).attribute14 := a35(indx);
109 t(ddindx).attribute15 := a36(indx);
110 t(ddindx).created_by := rosetta_g_miss_num_map(a37(indx));
111 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a38(indx));
112 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a39(indx));
113 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a40(indx));
114 t(ddindx).last_update_login := rosetta_g_miss_num_map(a41(indx));
115 t(ddindx).inv_code := a42(indx);
116 ddindx := ddindx+1;
117 if a0.last =indx
118 then exit;
119 end if;
120 indx := a0.next(indx);
121 end loop;
122 end if;
123 end if;
124 end rosetta_table_copy_in_p2;
125 procedure rosetta_table_copy_out_p2(t okl_avl_pvt.avl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126 , a1 out nocopy JTF_VARCHAR2_TABLE_200
127 , a2 out nocopy JTF_NUMBER_TABLE
128 , a3 out nocopy JTF_NUMBER_TABLE
129 , a4 out nocopy JTF_NUMBER_TABLE
130 , a5 out nocopy JTF_NUMBER_TABLE
131 , a6 out nocopy JTF_VARCHAR2_TABLE_100
132 , a7 out nocopy JTF_VARCHAR2_TABLE_100
133 , a8 out nocopy JTF_NUMBER_TABLE
134 , a9 out nocopy JTF_VARCHAR2_TABLE_100
135 , a10 out nocopy JTF_VARCHAR2_TABLE_100
136 , a11 out nocopy JTF_VARCHAR2_TABLE_100
137 , a12 out nocopy JTF_DATE_TABLE
138 , a13 out nocopy JTF_NUMBER_TABLE
139 , a14 out nocopy JTF_VARCHAR2_TABLE_100
140 , a15 out nocopy JTF_VARCHAR2_TABLE_100
141 , a16 out nocopy JTF_VARCHAR2_TABLE_2000
142 , a17 out nocopy JTF_VARCHAR2_TABLE_100
143 , a18 out nocopy JTF_DATE_TABLE
144 , a19 out nocopy JTF_VARCHAR2_TABLE_100
145 , a20 out nocopy JTF_NUMBER_TABLE
146 , a21 out nocopy JTF_VARCHAR2_TABLE_100
147 , a22 out nocopy JTF_VARCHAR2_TABLE_500
148 , a23 out nocopy JTF_VARCHAR2_TABLE_500
149 , a24 out nocopy JTF_VARCHAR2_TABLE_500
150 , a25 out nocopy JTF_VARCHAR2_TABLE_500
151 , a26 out nocopy JTF_VARCHAR2_TABLE_500
152 , a27 out nocopy JTF_VARCHAR2_TABLE_500
153 , a28 out nocopy JTF_VARCHAR2_TABLE_500
154 , a29 out nocopy JTF_VARCHAR2_TABLE_500
155 , a30 out nocopy JTF_VARCHAR2_TABLE_500
156 , a31 out nocopy JTF_VARCHAR2_TABLE_500
157 , a32 out nocopy JTF_VARCHAR2_TABLE_500
158 , a33 out nocopy JTF_VARCHAR2_TABLE_500
159 , a34 out nocopy JTF_VARCHAR2_TABLE_500
160 , a35 out nocopy JTF_VARCHAR2_TABLE_500
161 , a36 out nocopy JTF_VARCHAR2_TABLE_500
162 , a37 out nocopy JTF_NUMBER_TABLE
163 , a38 out nocopy JTF_DATE_TABLE
164 , a39 out nocopy JTF_NUMBER_TABLE
165 , a40 out nocopy JTF_DATE_TABLE
166 , a41 out nocopy JTF_NUMBER_TABLE
167 , a42 out nocopy JTF_VARCHAR2_TABLE_100
168 ) as
169 ddindx binary_integer; indx binary_integer;
170 begin
171 if t is null or t.count = 0 then
172 a0 := JTF_NUMBER_TABLE();
173 a1 := JTF_VARCHAR2_TABLE_200();
174 a2 := JTF_NUMBER_TABLE();
175 a3 := JTF_NUMBER_TABLE();
176 a4 := JTF_NUMBER_TABLE();
177 a5 := JTF_NUMBER_TABLE();
178 a6 := JTF_VARCHAR2_TABLE_100();
179 a7 := JTF_VARCHAR2_TABLE_100();
180 a8 := JTF_NUMBER_TABLE();
181 a9 := JTF_VARCHAR2_TABLE_100();
182 a10 := JTF_VARCHAR2_TABLE_100();
183 a11 := JTF_VARCHAR2_TABLE_100();
184 a12 := JTF_DATE_TABLE();
185 a13 := JTF_NUMBER_TABLE();
186 a14 := JTF_VARCHAR2_TABLE_100();
187 a15 := JTF_VARCHAR2_TABLE_100();
188 a16 := JTF_VARCHAR2_TABLE_2000();
189 a17 := JTF_VARCHAR2_TABLE_100();
190 a18 := JTF_DATE_TABLE();
191 a19 := JTF_VARCHAR2_TABLE_100();
192 a20 := JTF_NUMBER_TABLE();
193 a21 := JTF_VARCHAR2_TABLE_100();
194 a22 := JTF_VARCHAR2_TABLE_500();
195 a23 := JTF_VARCHAR2_TABLE_500();
196 a24 := JTF_VARCHAR2_TABLE_500();
197 a25 := JTF_VARCHAR2_TABLE_500();
198 a26 := JTF_VARCHAR2_TABLE_500();
199 a27 := JTF_VARCHAR2_TABLE_500();
200 a28 := JTF_VARCHAR2_TABLE_500();
201 a29 := JTF_VARCHAR2_TABLE_500();
202 a30 := JTF_VARCHAR2_TABLE_500();
203 a31 := JTF_VARCHAR2_TABLE_500();
204 a32 := JTF_VARCHAR2_TABLE_500();
205 a33 := JTF_VARCHAR2_TABLE_500();
206 a34 := JTF_VARCHAR2_TABLE_500();
207 a35 := JTF_VARCHAR2_TABLE_500();
208 a36 := JTF_VARCHAR2_TABLE_500();
209 a37 := JTF_NUMBER_TABLE();
210 a38 := JTF_DATE_TABLE();
211 a39 := JTF_NUMBER_TABLE();
212 a40 := JTF_DATE_TABLE();
213 a41 := JTF_NUMBER_TABLE();
214 a42 := JTF_VARCHAR2_TABLE_100();
215 else
216 a0 := JTF_NUMBER_TABLE();
217 a1 := JTF_VARCHAR2_TABLE_200();
218 a2 := JTF_NUMBER_TABLE();
219 a3 := JTF_NUMBER_TABLE();
220 a4 := JTF_NUMBER_TABLE();
221 a5 := JTF_NUMBER_TABLE();
222 a6 := JTF_VARCHAR2_TABLE_100();
223 a7 := JTF_VARCHAR2_TABLE_100();
224 a8 := JTF_NUMBER_TABLE();
225 a9 := JTF_VARCHAR2_TABLE_100();
226 a10 := JTF_VARCHAR2_TABLE_100();
227 a11 := JTF_VARCHAR2_TABLE_100();
228 a12 := JTF_DATE_TABLE();
229 a13 := JTF_NUMBER_TABLE();
230 a14 := JTF_VARCHAR2_TABLE_100();
231 a15 := JTF_VARCHAR2_TABLE_100();
232 a16 := JTF_VARCHAR2_TABLE_2000();
233 a17 := JTF_VARCHAR2_TABLE_100();
234 a18 := JTF_DATE_TABLE();
235 a19 := JTF_VARCHAR2_TABLE_100();
236 a20 := JTF_NUMBER_TABLE();
237 a21 := JTF_VARCHAR2_TABLE_100();
238 a22 := JTF_VARCHAR2_TABLE_500();
239 a23 := JTF_VARCHAR2_TABLE_500();
240 a24 := JTF_VARCHAR2_TABLE_500();
241 a25 := JTF_VARCHAR2_TABLE_500();
242 a26 := JTF_VARCHAR2_TABLE_500();
243 a27 := JTF_VARCHAR2_TABLE_500();
244 a28 := JTF_VARCHAR2_TABLE_500();
245 a29 := JTF_VARCHAR2_TABLE_500();
246 a30 := JTF_VARCHAR2_TABLE_500();
247 a31 := JTF_VARCHAR2_TABLE_500();
248 a32 := JTF_VARCHAR2_TABLE_500();
249 a33 := JTF_VARCHAR2_TABLE_500();
250 a34 := JTF_VARCHAR2_TABLE_500();
251 a35 := JTF_VARCHAR2_TABLE_500();
252 a36 := JTF_VARCHAR2_TABLE_500();
253 a37 := JTF_NUMBER_TABLE();
254 a38 := JTF_DATE_TABLE();
255 a39 := JTF_NUMBER_TABLE();
256 a40 := JTF_DATE_TABLE();
257 a41 := JTF_NUMBER_TABLE();
258 a42 := JTF_VARCHAR2_TABLE_100();
259 if t.count > 0 then
260 a0.extend(t.count);
261 a1.extend(t.count);
262 a2.extend(t.count);
263 a3.extend(t.count);
264 a4.extend(t.count);
265 a5.extend(t.count);
266 a6.extend(t.count);
267 a7.extend(t.count);
268 a8.extend(t.count);
269 a9.extend(t.count);
270 a10.extend(t.count);
271 a11.extend(t.count);
272 a12.extend(t.count);
273 a13.extend(t.count);
274 a14.extend(t.count);
275 a15.extend(t.count);
276 a16.extend(t.count);
277 a17.extend(t.count);
278 a18.extend(t.count);
279 a19.extend(t.count);
280 a20.extend(t.count);
281 a21.extend(t.count);
282 a22.extend(t.count);
283 a23.extend(t.count);
284 a24.extend(t.count);
285 a25.extend(t.count);
286 a26.extend(t.count);
287 a27.extend(t.count);
288 a28.extend(t.count);
289 a29.extend(t.count);
290 a30.extend(t.count);
291 a31.extend(t.count);
292 a32.extend(t.count);
293 a33.extend(t.count);
294 a34.extend(t.count);
295 a35.extend(t.count);
296 a36.extend(t.count);
297 a37.extend(t.count);
298 a38.extend(t.count);
299 a39.extend(t.count);
300 a40.extend(t.count);
301 a41.extend(t.count);
302 a42.extend(t.count);
303 ddindx := t.first;
304 indx := 1;
305 while true loop
306 a0(indx) := rosetta_g_miss_num_map(t(ddindx).id);
307 a1(indx) := t(ddindx).name;
308 a2(indx) := rosetta_g_miss_num_map(t(ddindx).set_of_books_id);
309 a3(indx) := rosetta_g_miss_num_map(t(ddindx).sty_id);
310 a4(indx) := rosetta_g_miss_num_map(t(ddindx).try_id);
311 a5(indx) := rosetta_g_miss_num_map(t(ddindx).aes_id);
312 a6(indx) := t(ddindx).syt_code;
313 a7(indx) := t(ddindx).fac_code;
314 a8(indx) := rosetta_g_miss_num_map(t(ddindx).fma_id);
315 a9(indx) := t(ddindx).advance_arrears;
316 a10(indx) := t(ddindx).post_to_gl;
317 a11(indx) := t(ddindx).version;
318 a12(indx) := t(ddindx).start_date;
319 a13(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
320 a14(indx) := t(ddindx).memo_yn;
321 a15(indx) := t(ddindx).prior_year_yn;
322 a16(indx) := t(ddindx).description;
323 a17(indx) := t(ddindx).factoring_synd_flag;
324 a18(indx) := t(ddindx).end_date;
325 a19(indx) := t(ddindx).accrual_yn;
326 a20(indx) := rosetta_g_miss_num_map(t(ddindx).org_id);
327 a21(indx) := t(ddindx).attribute_category;
328 a22(indx) := t(ddindx).attribute1;
329 a23(indx) := t(ddindx).attribute2;
330 a24(indx) := t(ddindx).attribute3;
331 a25(indx) := t(ddindx).attribute4;
332 a26(indx) := t(ddindx).attribute5;
333 a27(indx) := t(ddindx).attribute6;
334 a28(indx) := t(ddindx).attribute7;
335 a29(indx) := t(ddindx).attribute8;
336 a30(indx) := t(ddindx).attribute9;
337 a31(indx) := t(ddindx).attribute10;
338 a32(indx) := t(ddindx).attribute11;
339 a33(indx) := t(ddindx).attribute12;
340 a34(indx) := t(ddindx).attribute13;
341 a35(indx) := t(ddindx).attribute14;
342 a36(indx) := t(ddindx).attribute15;
343 a37(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
344 a38(indx) := t(ddindx).creation_date;
345 a39(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
346 a40(indx) := t(ddindx).last_update_date;
347 a41(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
348 a42(indx) := t(ddindx).inv_code;
349 indx := indx+1;
350 if t.last =ddindx
351 then exit;
352 end if;
353 ddindx := t.next(ddindx);
354 end loop;
355 end if;
356 end if;
357 end rosetta_table_copy_out_p2;
358
359 procedure rosetta_table_copy_in_p5(t out nocopy okl_avl_pvt.avlv_tbl_type, a0 JTF_NUMBER_TABLE
360 , a1 JTF_NUMBER_TABLE
361 , a2 JTF_NUMBER_TABLE
362 , a3 JTF_NUMBER_TABLE
363 , a4 JTF_NUMBER_TABLE
364 , a5 JTF_NUMBER_TABLE
365 , a6 JTF_NUMBER_TABLE
366 , a7 JTF_VARCHAR2_TABLE_100
367 , a8 JTF_VARCHAR2_TABLE_100
368 , a9 JTF_VARCHAR2_TABLE_100
369 , a10 JTF_VARCHAR2_TABLE_100
370 , a11 JTF_VARCHAR2_TABLE_100
371 , a12 JTF_VARCHAR2_TABLE_100
372 , a13 JTF_VARCHAR2_TABLE_200
373 , a14 JTF_VARCHAR2_TABLE_2000
374 , a15 JTF_VARCHAR2_TABLE_100
375 , a16 JTF_VARCHAR2_TABLE_100
376 , a17 JTF_DATE_TABLE
377 , a18 JTF_DATE_TABLE
378 , a19 JTF_VARCHAR2_TABLE_100
379 , a20 JTF_VARCHAR2_TABLE_100
380 , a21 JTF_VARCHAR2_TABLE_500
381 , a22 JTF_VARCHAR2_TABLE_500
382 , a23 JTF_VARCHAR2_TABLE_500
383 , a24 JTF_VARCHAR2_TABLE_500
384 , a25 JTF_VARCHAR2_TABLE_500
385 , a26 JTF_VARCHAR2_TABLE_500
386 , a27 JTF_VARCHAR2_TABLE_500
387 , a28 JTF_VARCHAR2_TABLE_500
388 , a29 JTF_VARCHAR2_TABLE_500
389 , a30 JTF_VARCHAR2_TABLE_500
390 , a31 JTF_VARCHAR2_TABLE_500
391 , a32 JTF_VARCHAR2_TABLE_500
392 , a33 JTF_VARCHAR2_TABLE_500
393 , a34 JTF_VARCHAR2_TABLE_500
394 , a35 JTF_VARCHAR2_TABLE_500
395 , a36 JTF_NUMBER_TABLE
396 , a37 JTF_NUMBER_TABLE
397 , a38 JTF_DATE_TABLE
398 , a39 JTF_NUMBER_TABLE
399 , a40 JTF_DATE_TABLE
400 , a41 JTF_NUMBER_TABLE
401 , a42 JTF_VARCHAR2_TABLE_100
402 ) as
403 ddindx binary_integer; indx binary_integer;
404 begin
405 if a0 is not null and a0.count > 0 then
406 if a0.count > 0 then
407 indx := a0.first;
408 ddindx := 1;
409 while true loop
410 t(ddindx).id := rosetta_g_miss_num_map(a0(indx));
411 t(ddindx).object_version_number := rosetta_g_miss_num_map(a1(indx));
412 t(ddindx).try_id := rosetta_g_miss_num_map(a2(indx));
413 t(ddindx).aes_id := rosetta_g_miss_num_map(a3(indx));
414 t(ddindx).sty_id := rosetta_g_miss_num_map(a4(indx));
415 t(ddindx).fma_id := rosetta_g_miss_num_map(a5(indx));
416 t(ddindx).set_of_books_id := rosetta_g_miss_num_map(a6(indx));
417 t(ddindx).fac_code := a7(indx);
418 t(ddindx).syt_code := a8(indx);
419 t(ddindx).post_to_gl := a9(indx);
420 t(ddindx).advance_arrears := a10(indx);
421 t(ddindx).memo_yn := a11(indx);
422 t(ddindx).prior_year_yn := a12(indx);
423 t(ddindx).name := a13(indx);
424 t(ddindx).description := a14(indx);
425 t(ddindx).version := a15(indx);
426 t(ddindx).factoring_synd_flag := a16(indx);
427 t(ddindx).start_date := rosetta_g_miss_date_in_map(a17(indx));
428 t(ddindx).end_date := rosetta_g_miss_date_in_map(a18(indx));
429 t(ddindx).accrual_yn := a19(indx);
430 t(ddindx).attribute_category := a20(indx);
431 t(ddindx).attribute1 := a21(indx);
432 t(ddindx).attribute2 := a22(indx);
433 t(ddindx).attribute3 := a23(indx);
434 t(ddindx).attribute4 := a24(indx);
435 t(ddindx).attribute5 := a25(indx);
436 t(ddindx).attribute6 := a26(indx);
437 t(ddindx).attribute7 := a27(indx);
438 t(ddindx).attribute8 := a28(indx);
439 t(ddindx).attribute9 := a29(indx);
440 t(ddindx).attribute10 := a30(indx);
441 t(ddindx).attribute11 := a31(indx);
442 t(ddindx).attribute12 := a32(indx);
443 t(ddindx).attribute13 := a33(indx);
444 t(ddindx).attribute14 := a34(indx);
445 t(ddindx).attribute15 := a35(indx);
446 t(ddindx).org_id := rosetta_g_miss_num_map(a36(indx));
447 t(ddindx).created_by := rosetta_g_miss_num_map(a37(indx));
448 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a38(indx));
449 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a39(indx));
450 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a40(indx));
451 t(ddindx).last_update_login := rosetta_g_miss_num_map(a41(indx));
452 t(ddindx).inv_code := a42(indx);
453 ddindx := ddindx+1;
454 if a0.last =indx
455 then exit;
456 end if;
457 indx := a0.next(indx);
458 end loop;
459 end if;
460 end if;
461 end rosetta_table_copy_in_p5;
462 procedure rosetta_table_copy_out_p5(t okl_avl_pvt.avlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
463 , a1 out nocopy JTF_NUMBER_TABLE
464 , a2 out nocopy JTF_NUMBER_TABLE
465 , a3 out nocopy JTF_NUMBER_TABLE
466 , a4 out nocopy JTF_NUMBER_TABLE
467 , a5 out nocopy JTF_NUMBER_TABLE
468 , a6 out nocopy JTF_NUMBER_TABLE
469 , a7 out nocopy JTF_VARCHAR2_TABLE_100
470 , a8 out nocopy JTF_VARCHAR2_TABLE_100
471 , a9 out nocopy JTF_VARCHAR2_TABLE_100
472 , a10 out nocopy JTF_VARCHAR2_TABLE_100
473 , a11 out nocopy JTF_VARCHAR2_TABLE_100
474 , a12 out nocopy JTF_VARCHAR2_TABLE_100
475 , a13 out nocopy JTF_VARCHAR2_TABLE_200
476 , a14 out nocopy JTF_VARCHAR2_TABLE_2000
477 , a15 out nocopy JTF_VARCHAR2_TABLE_100
478 , a16 out nocopy JTF_VARCHAR2_TABLE_100
479 , a17 out nocopy JTF_DATE_TABLE
480 , a18 out nocopy JTF_DATE_TABLE
481 , a19 out nocopy JTF_VARCHAR2_TABLE_100
482 , a20 out nocopy JTF_VARCHAR2_TABLE_100
483 , a21 out nocopy JTF_VARCHAR2_TABLE_500
484 , a22 out nocopy JTF_VARCHAR2_TABLE_500
485 , a23 out nocopy JTF_VARCHAR2_TABLE_500
486 , a24 out nocopy JTF_VARCHAR2_TABLE_500
487 , a25 out nocopy JTF_VARCHAR2_TABLE_500
488 , a26 out nocopy JTF_VARCHAR2_TABLE_500
489 , a27 out nocopy JTF_VARCHAR2_TABLE_500
490 , a28 out nocopy JTF_VARCHAR2_TABLE_500
491 , a29 out nocopy JTF_VARCHAR2_TABLE_500
492 , a30 out nocopy JTF_VARCHAR2_TABLE_500
493 , a31 out nocopy JTF_VARCHAR2_TABLE_500
494 , a32 out nocopy JTF_VARCHAR2_TABLE_500
495 , a33 out nocopy JTF_VARCHAR2_TABLE_500
496 , a34 out nocopy JTF_VARCHAR2_TABLE_500
497 , a35 out nocopy JTF_VARCHAR2_TABLE_500
498 , a36 out nocopy JTF_NUMBER_TABLE
499 , a37 out nocopy JTF_NUMBER_TABLE
500 , a38 out nocopy JTF_DATE_TABLE
501 , a39 out nocopy JTF_NUMBER_TABLE
502 , a40 out nocopy JTF_DATE_TABLE
503 , a41 out nocopy JTF_NUMBER_TABLE
504 , a42 out nocopy JTF_VARCHAR2_TABLE_100
505 ) as
506 ddindx binary_integer; indx binary_integer;
507 begin
508 if t is null or t.count = 0 then
509 a0 := JTF_NUMBER_TABLE();
510 a1 := JTF_NUMBER_TABLE();
511 a2 := JTF_NUMBER_TABLE();
512 a3 := JTF_NUMBER_TABLE();
513 a4 := JTF_NUMBER_TABLE();
514 a5 := JTF_NUMBER_TABLE();
515 a6 := JTF_NUMBER_TABLE();
516 a7 := JTF_VARCHAR2_TABLE_100();
517 a8 := JTF_VARCHAR2_TABLE_100();
518 a9 := JTF_VARCHAR2_TABLE_100();
519 a10 := JTF_VARCHAR2_TABLE_100();
520 a11 := JTF_VARCHAR2_TABLE_100();
521 a12 := JTF_VARCHAR2_TABLE_100();
522 a13 := JTF_VARCHAR2_TABLE_200();
523 a14 := JTF_VARCHAR2_TABLE_2000();
524 a15 := JTF_VARCHAR2_TABLE_100();
525 a16 := JTF_VARCHAR2_TABLE_100();
526 a17 := JTF_DATE_TABLE();
527 a18 := JTF_DATE_TABLE();
528 a19 := JTF_VARCHAR2_TABLE_100();
529 a20 := JTF_VARCHAR2_TABLE_100();
530 a21 := JTF_VARCHAR2_TABLE_500();
531 a22 := JTF_VARCHAR2_TABLE_500();
532 a23 := JTF_VARCHAR2_TABLE_500();
533 a24 := JTF_VARCHAR2_TABLE_500();
534 a25 := JTF_VARCHAR2_TABLE_500();
535 a26 := JTF_VARCHAR2_TABLE_500();
536 a27 := JTF_VARCHAR2_TABLE_500();
537 a28 := JTF_VARCHAR2_TABLE_500();
538 a29 := JTF_VARCHAR2_TABLE_500();
539 a30 := JTF_VARCHAR2_TABLE_500();
540 a31 := JTF_VARCHAR2_TABLE_500();
541 a32 := JTF_VARCHAR2_TABLE_500();
542 a33 := JTF_VARCHAR2_TABLE_500();
543 a34 := JTF_VARCHAR2_TABLE_500();
544 a35 := JTF_VARCHAR2_TABLE_500();
545 a36 := JTF_NUMBER_TABLE();
546 a37 := JTF_NUMBER_TABLE();
547 a38 := JTF_DATE_TABLE();
548 a39 := JTF_NUMBER_TABLE();
549 a40 := JTF_DATE_TABLE();
550 a41 := JTF_NUMBER_TABLE();
551 a42 := JTF_VARCHAR2_TABLE_100();
552 else
553 a0 := JTF_NUMBER_TABLE();
554 a1 := JTF_NUMBER_TABLE();
555 a2 := JTF_NUMBER_TABLE();
556 a3 := JTF_NUMBER_TABLE();
557 a4 := JTF_NUMBER_TABLE();
558 a5 := JTF_NUMBER_TABLE();
559 a6 := JTF_NUMBER_TABLE();
560 a7 := JTF_VARCHAR2_TABLE_100();
561 a8 := JTF_VARCHAR2_TABLE_100();
562 a9 := JTF_VARCHAR2_TABLE_100();
563 a10 := JTF_VARCHAR2_TABLE_100();
564 a11 := JTF_VARCHAR2_TABLE_100();
565 a12 := JTF_VARCHAR2_TABLE_100();
566 a13 := JTF_VARCHAR2_TABLE_200();
567 a14 := JTF_VARCHAR2_TABLE_2000();
568 a15 := JTF_VARCHAR2_TABLE_100();
569 a16 := JTF_VARCHAR2_TABLE_100();
570 a17 := JTF_DATE_TABLE();
571 a18 := JTF_DATE_TABLE();
572 a19 := JTF_VARCHAR2_TABLE_100();
573 a20 := JTF_VARCHAR2_TABLE_100();
574 a21 := JTF_VARCHAR2_TABLE_500();
575 a22 := JTF_VARCHAR2_TABLE_500();
576 a23 := JTF_VARCHAR2_TABLE_500();
577 a24 := JTF_VARCHAR2_TABLE_500();
578 a25 := JTF_VARCHAR2_TABLE_500();
579 a26 := JTF_VARCHAR2_TABLE_500();
580 a27 := JTF_VARCHAR2_TABLE_500();
581 a28 := JTF_VARCHAR2_TABLE_500();
582 a29 := JTF_VARCHAR2_TABLE_500();
583 a30 := JTF_VARCHAR2_TABLE_500();
584 a31 := JTF_VARCHAR2_TABLE_500();
585 a32 := JTF_VARCHAR2_TABLE_500();
586 a33 := JTF_VARCHAR2_TABLE_500();
587 a34 := JTF_VARCHAR2_TABLE_500();
588 a35 := JTF_VARCHAR2_TABLE_500();
589 a36 := JTF_NUMBER_TABLE();
590 a37 := JTF_NUMBER_TABLE();
591 a38 := JTF_DATE_TABLE();
592 a39 := JTF_NUMBER_TABLE();
593 a40 := JTF_DATE_TABLE();
594 a41 := JTF_NUMBER_TABLE();
595 a42 := JTF_VARCHAR2_TABLE_100();
596 if t.count > 0 then
597 a0.extend(t.count);
598 a1.extend(t.count);
599 a2.extend(t.count);
600 a3.extend(t.count);
601 a4.extend(t.count);
602 a5.extend(t.count);
603 a6.extend(t.count);
604 a7.extend(t.count);
605 a8.extend(t.count);
606 a9.extend(t.count);
607 a10.extend(t.count);
608 a11.extend(t.count);
609 a12.extend(t.count);
610 a13.extend(t.count);
611 a14.extend(t.count);
612 a15.extend(t.count);
613 a16.extend(t.count);
614 a17.extend(t.count);
615 a18.extend(t.count);
616 a19.extend(t.count);
617 a20.extend(t.count);
618 a21.extend(t.count);
619 a22.extend(t.count);
620 a23.extend(t.count);
621 a24.extend(t.count);
622 a25.extend(t.count);
623 a26.extend(t.count);
624 a27.extend(t.count);
625 a28.extend(t.count);
626 a29.extend(t.count);
627 a30.extend(t.count);
628 a31.extend(t.count);
629 a32.extend(t.count);
630 a33.extend(t.count);
631 a34.extend(t.count);
632 a35.extend(t.count);
633 a36.extend(t.count);
634 a37.extend(t.count);
635 a38.extend(t.count);
636 a39.extend(t.count);
637 a40.extend(t.count);
638 a41.extend(t.count);
639 a42.extend(t.count);
640 ddindx := t.first;
641 indx := 1;
642 while true loop
643 a0(indx) := rosetta_g_miss_num_map(t(ddindx).id);
644 a1(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
645 a2(indx) := rosetta_g_miss_num_map(t(ddindx).try_id);
646 a3(indx) := rosetta_g_miss_num_map(t(ddindx).aes_id);
647 a4(indx) := rosetta_g_miss_num_map(t(ddindx).sty_id);
648 a5(indx) := rosetta_g_miss_num_map(t(ddindx).fma_id);
649 a6(indx) := rosetta_g_miss_num_map(t(ddindx).set_of_books_id);
650 a7(indx) := t(ddindx).fac_code;
651 a8(indx) := t(ddindx).syt_code;
652 a9(indx) := t(ddindx).post_to_gl;
653 a10(indx) := t(ddindx).advance_arrears;
654 a11(indx) := t(ddindx).memo_yn;
655 a12(indx) := t(ddindx).prior_year_yn;
656 a13(indx) := t(ddindx).name;
657 a14(indx) := t(ddindx).description;
658 a15(indx) := t(ddindx).version;
659 a16(indx) := t(ddindx).factoring_synd_flag;
660 a17(indx) := t(ddindx).start_date;
661 a18(indx) := t(ddindx).end_date;
662 a19(indx) := t(ddindx).accrual_yn;
663 a20(indx) := t(ddindx).attribute_category;
664 a21(indx) := t(ddindx).attribute1;
665 a22(indx) := t(ddindx).attribute2;
666 a23(indx) := t(ddindx).attribute3;
667 a24(indx) := t(ddindx).attribute4;
668 a25(indx) := t(ddindx).attribute5;
669 a26(indx) := t(ddindx).attribute6;
670 a27(indx) := t(ddindx).attribute7;
671 a28(indx) := t(ddindx).attribute8;
672 a29(indx) := t(ddindx).attribute9;
673 a30(indx) := t(ddindx).attribute10;
674 a31(indx) := t(ddindx).attribute11;
675 a32(indx) := t(ddindx).attribute12;
676 a33(indx) := t(ddindx).attribute13;
677 a34(indx) := t(ddindx).attribute14;
678 a35(indx) := t(ddindx).attribute15;
679 a36(indx) := rosetta_g_miss_num_map(t(ddindx).org_id);
680 a37(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
681 a38(indx) := t(ddindx).creation_date;
682 a39(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
683 a40(indx) := t(ddindx).last_update_date;
684 a41(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
685 a42(indx) := t(ddindx).inv_code;
686 indx := indx+1;
687 if t.last =ddindx
688 then exit;
689 end if;
690 ddindx := t.next(ddindx);
691 end loop;
692 end if;
693 end if;
694 end rosetta_table_copy_out_p5;
695
696 procedure insert_row(p_api_version NUMBER
697 , p_init_msg_list VARCHAR2
698 , x_return_status out nocopy VARCHAR2
699 , x_msg_count out nocopy NUMBER
700 , x_msg_data out nocopy VARCHAR2
701 , p6_a0 out nocopy NUMBER
702 , p6_a1 out nocopy NUMBER
703 , p6_a2 out nocopy NUMBER
704 , p6_a3 out nocopy NUMBER
705 , p6_a4 out nocopy NUMBER
706 , p6_a5 out nocopy NUMBER
707 , p6_a6 out nocopy NUMBER
708 , p6_a7 out nocopy VARCHAR2
709 , p6_a8 out nocopy VARCHAR2
710 , p6_a9 out nocopy VARCHAR2
711 , p6_a10 out nocopy VARCHAR2
712 , p6_a11 out nocopy VARCHAR2
713 , p6_a12 out nocopy VARCHAR2
714 , p6_a13 out nocopy VARCHAR2
715 , p6_a14 out nocopy VARCHAR2
716 , p6_a15 out nocopy VARCHAR2
717 , p6_a16 out nocopy VARCHAR2
718 , p6_a17 out nocopy DATE
719 , p6_a18 out nocopy DATE
720 , p6_a19 out nocopy VARCHAR2
721 , p6_a20 out nocopy VARCHAR2
722 , p6_a21 out nocopy VARCHAR2
723 , p6_a22 out nocopy VARCHAR2
724 , p6_a23 out nocopy VARCHAR2
725 , p6_a24 out nocopy VARCHAR2
726 , p6_a25 out nocopy VARCHAR2
727 , p6_a26 out nocopy VARCHAR2
728 , p6_a27 out nocopy VARCHAR2
729 , p6_a28 out nocopy VARCHAR2
730 , p6_a29 out nocopy VARCHAR2
731 , p6_a30 out nocopy VARCHAR2
732 , p6_a31 out nocopy VARCHAR2
733 , p6_a32 out nocopy VARCHAR2
734 , p6_a33 out nocopy VARCHAR2
735 , p6_a34 out nocopy VARCHAR2
736 , p6_a35 out nocopy VARCHAR2
737 , p6_a36 out nocopy NUMBER
738 , p6_a37 out nocopy NUMBER
739 , p6_a38 out nocopy DATE
740 , p6_a39 out nocopy NUMBER
741 , p6_a40 out nocopy DATE
742 , p6_a41 out nocopy NUMBER
743 , p6_a42 out nocopy VARCHAR2
744 , p5_a0 NUMBER := 0-1962.0724
745 , p5_a1 NUMBER := 0-1962.0724
746 , p5_a2 NUMBER := 0-1962.0724
747 , p5_a3 NUMBER := 0-1962.0724
748 , p5_a4 NUMBER := 0-1962.0724
749 , p5_a5 NUMBER := 0-1962.0724
750 , p5_a6 NUMBER := 0-1962.0724
751 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
752 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
753 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
754 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
755 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
756 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
757 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
758 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
759 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
760 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
761 , p5_a17 DATE := fnd_api.g_miss_date
762 , p5_a18 DATE := fnd_api.g_miss_date
763 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
764 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
765 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
766 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
767 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
768 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
769 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
770 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
771 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
772 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
773 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
774 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
775 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
776 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
777 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
778 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
779 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
780 , p5_a36 NUMBER := 0-1962.0724
781 , p5_a37 NUMBER := 0-1962.0724
782 , p5_a38 DATE := fnd_api.g_miss_date
783 , p5_a39 NUMBER := 0-1962.0724
784 , p5_a40 DATE := fnd_api.g_miss_date
785 , p5_a41 NUMBER := 0-1962.0724
786 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
787 )
788
789 as
790 ddp_avlv_rec okl_avl_pvt.avlv_rec_type;
791 ddx_avlv_rec okl_avl_pvt.avlv_rec_type;
792 ddindx binary_integer; indx binary_integer;
793 begin
794
795 -- copy data to the local IN or IN-OUT args, if any
796
797
798
799
800
801 ddp_avlv_rec.id := rosetta_g_miss_num_map(p5_a0);
802 ddp_avlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
803 ddp_avlv_rec.try_id := rosetta_g_miss_num_map(p5_a2);
804 ddp_avlv_rec.aes_id := rosetta_g_miss_num_map(p5_a3);
805 ddp_avlv_rec.sty_id := rosetta_g_miss_num_map(p5_a4);
806 ddp_avlv_rec.fma_id := rosetta_g_miss_num_map(p5_a5);
807 ddp_avlv_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a6);
808 ddp_avlv_rec.fac_code := p5_a7;
809 ddp_avlv_rec.syt_code := p5_a8;
810 ddp_avlv_rec.post_to_gl := p5_a9;
811 ddp_avlv_rec.advance_arrears := p5_a10;
812 ddp_avlv_rec.memo_yn := p5_a11;
813 ddp_avlv_rec.prior_year_yn := p5_a12;
814 ddp_avlv_rec.name := p5_a13;
815 ddp_avlv_rec.description := p5_a14;
816 ddp_avlv_rec.version := p5_a15;
817 ddp_avlv_rec.factoring_synd_flag := p5_a16;
818 ddp_avlv_rec.start_date := rosetta_g_miss_date_in_map(p5_a17);
819 ddp_avlv_rec.end_date := rosetta_g_miss_date_in_map(p5_a18);
820 ddp_avlv_rec.accrual_yn := p5_a19;
821 ddp_avlv_rec.attribute_category := p5_a20;
822 ddp_avlv_rec.attribute1 := p5_a21;
823 ddp_avlv_rec.attribute2 := p5_a22;
824 ddp_avlv_rec.attribute3 := p5_a23;
825 ddp_avlv_rec.attribute4 := p5_a24;
826 ddp_avlv_rec.attribute5 := p5_a25;
827 ddp_avlv_rec.attribute6 := p5_a26;
828 ddp_avlv_rec.attribute7 := p5_a27;
829 ddp_avlv_rec.attribute8 := p5_a28;
830 ddp_avlv_rec.attribute9 := p5_a29;
831 ddp_avlv_rec.attribute10 := p5_a30;
832 ddp_avlv_rec.attribute11 := p5_a31;
833 ddp_avlv_rec.attribute12 := p5_a32;
834 ddp_avlv_rec.attribute13 := p5_a33;
835 ddp_avlv_rec.attribute14 := p5_a34;
836 ddp_avlv_rec.attribute15 := p5_a35;
837 ddp_avlv_rec.org_id := rosetta_g_miss_num_map(p5_a36);
838 ddp_avlv_rec.created_by := rosetta_g_miss_num_map(p5_a37);
839 ddp_avlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a38);
840 ddp_avlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a39);
841 ddp_avlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a40);
842 ddp_avlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a41);
843 ddp_avlv_rec.inv_code := p5_a42;
844
845
846 -- here's the delegated call to the old PL/SQL routine
847 okl_avl_pvt.insert_row(p_api_version,
848 p_init_msg_list,
849 x_return_status,
850 x_msg_count,
851 x_msg_data,
852 ddp_avlv_rec,
853 ddx_avlv_rec);
854
855 -- copy data back from the local variables to OUT or IN-OUT args, if any
856
857
858
859
860
861
862 p6_a0 := rosetta_g_miss_num_map(ddx_avlv_rec.id);
863 p6_a1 := rosetta_g_miss_num_map(ddx_avlv_rec.object_version_number);
864 p6_a2 := rosetta_g_miss_num_map(ddx_avlv_rec.try_id);
865 p6_a3 := rosetta_g_miss_num_map(ddx_avlv_rec.aes_id);
866 p6_a4 := rosetta_g_miss_num_map(ddx_avlv_rec.sty_id);
867 p6_a5 := rosetta_g_miss_num_map(ddx_avlv_rec.fma_id);
868 p6_a6 := rosetta_g_miss_num_map(ddx_avlv_rec.set_of_books_id);
869 p6_a7 := ddx_avlv_rec.fac_code;
870 p6_a8 := ddx_avlv_rec.syt_code;
871 p6_a9 := ddx_avlv_rec.post_to_gl;
872 p6_a10 := ddx_avlv_rec.advance_arrears;
873 p6_a11 := ddx_avlv_rec.memo_yn;
874 p6_a12 := ddx_avlv_rec.prior_year_yn;
875 p6_a13 := ddx_avlv_rec.name;
876 p6_a14 := ddx_avlv_rec.description;
877 p6_a15 := ddx_avlv_rec.version;
878 p6_a16 := ddx_avlv_rec.factoring_synd_flag;
879 p6_a17 := ddx_avlv_rec.start_date;
880 p6_a18 := ddx_avlv_rec.end_date;
881 p6_a19 := ddx_avlv_rec.accrual_yn;
882 p6_a20 := ddx_avlv_rec.attribute_category;
883 p6_a21 := ddx_avlv_rec.attribute1;
884 p6_a22 := ddx_avlv_rec.attribute2;
885 p6_a23 := ddx_avlv_rec.attribute3;
886 p6_a24 := ddx_avlv_rec.attribute4;
887 p6_a25 := ddx_avlv_rec.attribute5;
888 p6_a26 := ddx_avlv_rec.attribute6;
889 p6_a27 := ddx_avlv_rec.attribute7;
890 p6_a28 := ddx_avlv_rec.attribute8;
891 p6_a29 := ddx_avlv_rec.attribute9;
892 p6_a30 := ddx_avlv_rec.attribute10;
893 p6_a31 := ddx_avlv_rec.attribute11;
894 p6_a32 := ddx_avlv_rec.attribute12;
895 p6_a33 := ddx_avlv_rec.attribute13;
896 p6_a34 := ddx_avlv_rec.attribute14;
897 p6_a35 := ddx_avlv_rec.attribute15;
898 p6_a36 := rosetta_g_miss_num_map(ddx_avlv_rec.org_id);
899 p6_a37 := rosetta_g_miss_num_map(ddx_avlv_rec.created_by);
900 p6_a38 := ddx_avlv_rec.creation_date;
901 p6_a39 := rosetta_g_miss_num_map(ddx_avlv_rec.last_updated_by);
902 p6_a40 := ddx_avlv_rec.last_update_date;
903 p6_a41 := rosetta_g_miss_num_map(ddx_avlv_rec.last_update_login);
904 p6_a42 := ddx_avlv_rec.inv_code;
905 end;
906
907 procedure insert_row(p_api_version NUMBER
908 , p_init_msg_list VARCHAR2
909 , x_return_status out nocopy VARCHAR2
910 , x_msg_count out nocopy NUMBER
911 , x_msg_data out nocopy VARCHAR2
912 , p5_a0 JTF_NUMBER_TABLE
913 , p5_a1 JTF_NUMBER_TABLE
914 , p5_a2 JTF_NUMBER_TABLE
915 , p5_a3 JTF_NUMBER_TABLE
916 , p5_a4 JTF_NUMBER_TABLE
917 , p5_a5 JTF_NUMBER_TABLE
918 , p5_a6 JTF_NUMBER_TABLE
919 , p5_a7 JTF_VARCHAR2_TABLE_100
920 , p5_a8 JTF_VARCHAR2_TABLE_100
921 , p5_a9 JTF_VARCHAR2_TABLE_100
922 , p5_a10 JTF_VARCHAR2_TABLE_100
923 , p5_a11 JTF_VARCHAR2_TABLE_100
924 , p5_a12 JTF_VARCHAR2_TABLE_100
925 , p5_a13 JTF_VARCHAR2_TABLE_200
926 , p5_a14 JTF_VARCHAR2_TABLE_2000
927 , p5_a15 JTF_VARCHAR2_TABLE_100
928 , p5_a16 JTF_VARCHAR2_TABLE_100
929 , p5_a17 JTF_DATE_TABLE
930 , p5_a18 JTF_DATE_TABLE
931 , p5_a19 JTF_VARCHAR2_TABLE_100
932 , p5_a20 JTF_VARCHAR2_TABLE_100
933 , p5_a21 JTF_VARCHAR2_TABLE_500
934 , p5_a22 JTF_VARCHAR2_TABLE_500
935 , p5_a23 JTF_VARCHAR2_TABLE_500
936 , p5_a24 JTF_VARCHAR2_TABLE_500
937 , p5_a25 JTF_VARCHAR2_TABLE_500
938 , p5_a26 JTF_VARCHAR2_TABLE_500
939 , p5_a27 JTF_VARCHAR2_TABLE_500
940 , p5_a28 JTF_VARCHAR2_TABLE_500
941 , p5_a29 JTF_VARCHAR2_TABLE_500
942 , p5_a30 JTF_VARCHAR2_TABLE_500
943 , p5_a31 JTF_VARCHAR2_TABLE_500
944 , p5_a32 JTF_VARCHAR2_TABLE_500
945 , p5_a33 JTF_VARCHAR2_TABLE_500
946 , p5_a34 JTF_VARCHAR2_TABLE_500
947 , p5_a35 JTF_VARCHAR2_TABLE_500
948 , p5_a36 JTF_NUMBER_TABLE
949 , p5_a37 JTF_NUMBER_TABLE
950 , p5_a38 JTF_DATE_TABLE
951 , p5_a39 JTF_NUMBER_TABLE
952 , p5_a40 JTF_DATE_TABLE
953 , p5_a41 JTF_NUMBER_TABLE
954 , p5_a42 JTF_VARCHAR2_TABLE_100
955 , p6_a0 out nocopy JTF_NUMBER_TABLE
956 , p6_a1 out nocopy JTF_NUMBER_TABLE
957 , p6_a2 out nocopy JTF_NUMBER_TABLE
958 , p6_a3 out nocopy JTF_NUMBER_TABLE
959 , p6_a4 out nocopy JTF_NUMBER_TABLE
960 , p6_a5 out nocopy JTF_NUMBER_TABLE
961 , p6_a6 out nocopy JTF_NUMBER_TABLE
962 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
963 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
964 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
965 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
966 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
967 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
968 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
969 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_2000
970 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
971 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
972 , p6_a17 out nocopy JTF_DATE_TABLE
973 , p6_a18 out nocopy JTF_DATE_TABLE
974 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
975 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
976 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
977 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
978 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
979 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
980 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
981 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
982 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
983 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
984 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
985 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
986 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
987 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
988 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
989 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
990 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
991 , p6_a36 out nocopy JTF_NUMBER_TABLE
992 , p6_a37 out nocopy JTF_NUMBER_TABLE
993 , p6_a38 out nocopy JTF_DATE_TABLE
994 , p6_a39 out nocopy JTF_NUMBER_TABLE
995 , p6_a40 out nocopy JTF_DATE_TABLE
996 , p6_a41 out nocopy JTF_NUMBER_TABLE
997 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
998 )
999
1000 as
1001 ddp_avlv_tbl okl_avl_pvt.avlv_tbl_type;
1002 ddx_avlv_tbl okl_avl_pvt.avlv_tbl_type;
1003 ddindx binary_integer; indx binary_integer;
1004 begin
1005
1006 -- copy data to the local IN or IN-OUT args, if any
1007
1008
1009
1010
1011
1012 okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p5_a0
1013 , p5_a1
1014 , p5_a2
1015 , p5_a3
1016 , p5_a4
1017 , p5_a5
1018 , p5_a6
1019 , p5_a7
1020 , p5_a8
1021 , p5_a9
1022 , p5_a10
1023 , p5_a11
1024 , p5_a12
1025 , p5_a13
1026 , p5_a14
1027 , p5_a15
1028 , p5_a16
1029 , p5_a17
1030 , p5_a18
1031 , p5_a19
1032 , p5_a20
1033 , p5_a21
1034 , p5_a22
1035 , p5_a23
1036 , p5_a24
1037 , p5_a25
1038 , p5_a26
1039 , p5_a27
1040 , p5_a28
1041 , p5_a29
1042 , p5_a30
1043 , p5_a31
1044 , p5_a32
1045 , p5_a33
1046 , p5_a34
1047 , p5_a35
1048 , p5_a36
1049 , p5_a37
1050 , p5_a38
1051 , p5_a39
1052 , p5_a40
1053 , p5_a41
1054 , p5_a42
1055 );
1056
1057
1058 -- here's the delegated call to the old PL/SQL routine
1059 okl_avl_pvt.insert_row(p_api_version,
1060 p_init_msg_list,
1061 x_return_status,
1062 x_msg_count,
1063 x_msg_data,
1064 ddp_avlv_tbl,
1065 ddx_avlv_tbl);
1066
1067 -- copy data back from the local variables to OUT or IN-OUT args, if any
1068
1069
1070
1071
1072
1073
1074 okl_avl_pvt_w.rosetta_table_copy_out_p5(ddx_avlv_tbl, p6_a0
1075 , p6_a1
1076 , p6_a2
1077 , p6_a3
1078 , p6_a4
1079 , p6_a5
1080 , p6_a6
1081 , p6_a7
1082 , p6_a8
1083 , p6_a9
1084 , p6_a10
1085 , p6_a11
1086 , p6_a12
1087 , p6_a13
1088 , p6_a14
1089 , p6_a15
1090 , p6_a16
1091 , p6_a17
1092 , p6_a18
1093 , p6_a19
1094 , p6_a20
1095 , p6_a21
1096 , p6_a22
1097 , p6_a23
1098 , p6_a24
1099 , p6_a25
1100 , p6_a26
1101 , p6_a27
1102 , p6_a28
1103 , p6_a29
1104 , p6_a30
1105 , p6_a31
1106 , p6_a32
1107 , p6_a33
1108 , p6_a34
1109 , p6_a35
1110 , p6_a36
1111 , p6_a37
1112 , p6_a38
1113 , p6_a39
1114 , p6_a40
1115 , p6_a41
1116 , p6_a42
1117 );
1118 end;
1119
1120 procedure lock_row(p_api_version NUMBER
1121 , p_init_msg_list VARCHAR2
1122 , x_return_status out nocopy VARCHAR2
1123 , x_msg_count out nocopy NUMBER
1124 , x_msg_data out nocopy VARCHAR2
1125 , p5_a0 NUMBER := 0-1962.0724
1126 , p5_a1 NUMBER := 0-1962.0724
1127 , p5_a2 NUMBER := 0-1962.0724
1128 , p5_a3 NUMBER := 0-1962.0724
1129 , p5_a4 NUMBER := 0-1962.0724
1130 , p5_a5 NUMBER := 0-1962.0724
1131 , p5_a6 NUMBER := 0-1962.0724
1132 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1133 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1134 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1135 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1136 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1137 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1138 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1139 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1140 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1141 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1142 , p5_a17 DATE := fnd_api.g_miss_date
1143 , p5_a18 DATE := fnd_api.g_miss_date
1144 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1145 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1146 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1147 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1148 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1149 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1150 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1151 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1152 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1153 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1154 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1155 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1156 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1157 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1158 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1159 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1160 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1161 , p5_a36 NUMBER := 0-1962.0724
1162 , p5_a37 NUMBER := 0-1962.0724
1163 , p5_a38 DATE := fnd_api.g_miss_date
1164 , p5_a39 NUMBER := 0-1962.0724
1165 , p5_a40 DATE := fnd_api.g_miss_date
1166 , p5_a41 NUMBER := 0-1962.0724
1167 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1168 )
1169
1170 as
1171 ddp_avlv_rec okl_avl_pvt.avlv_rec_type;
1172 ddindx binary_integer; indx binary_integer;
1173 begin
1174
1175 -- copy data to the local IN or IN-OUT args, if any
1176
1177
1178
1179
1180
1181 ddp_avlv_rec.id := rosetta_g_miss_num_map(p5_a0);
1182 ddp_avlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1183 ddp_avlv_rec.try_id := rosetta_g_miss_num_map(p5_a2);
1184 ddp_avlv_rec.aes_id := rosetta_g_miss_num_map(p5_a3);
1185 ddp_avlv_rec.sty_id := rosetta_g_miss_num_map(p5_a4);
1186 ddp_avlv_rec.fma_id := rosetta_g_miss_num_map(p5_a5);
1187 ddp_avlv_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a6);
1188 ddp_avlv_rec.fac_code := p5_a7;
1189 ddp_avlv_rec.syt_code := p5_a8;
1190 ddp_avlv_rec.post_to_gl := p5_a9;
1191 ddp_avlv_rec.advance_arrears := p5_a10;
1192 ddp_avlv_rec.memo_yn := p5_a11;
1193 ddp_avlv_rec.prior_year_yn := p5_a12;
1194 ddp_avlv_rec.name := p5_a13;
1195 ddp_avlv_rec.description := p5_a14;
1196 ddp_avlv_rec.version := p5_a15;
1197 ddp_avlv_rec.factoring_synd_flag := p5_a16;
1198 ddp_avlv_rec.start_date := rosetta_g_miss_date_in_map(p5_a17);
1199 ddp_avlv_rec.end_date := rosetta_g_miss_date_in_map(p5_a18);
1200 ddp_avlv_rec.accrual_yn := p5_a19;
1201 ddp_avlv_rec.attribute_category := p5_a20;
1202 ddp_avlv_rec.attribute1 := p5_a21;
1203 ddp_avlv_rec.attribute2 := p5_a22;
1204 ddp_avlv_rec.attribute3 := p5_a23;
1205 ddp_avlv_rec.attribute4 := p5_a24;
1206 ddp_avlv_rec.attribute5 := p5_a25;
1207 ddp_avlv_rec.attribute6 := p5_a26;
1208 ddp_avlv_rec.attribute7 := p5_a27;
1209 ddp_avlv_rec.attribute8 := p5_a28;
1210 ddp_avlv_rec.attribute9 := p5_a29;
1211 ddp_avlv_rec.attribute10 := p5_a30;
1212 ddp_avlv_rec.attribute11 := p5_a31;
1213 ddp_avlv_rec.attribute12 := p5_a32;
1214 ddp_avlv_rec.attribute13 := p5_a33;
1215 ddp_avlv_rec.attribute14 := p5_a34;
1216 ddp_avlv_rec.attribute15 := p5_a35;
1217 ddp_avlv_rec.org_id := rosetta_g_miss_num_map(p5_a36);
1218 ddp_avlv_rec.created_by := rosetta_g_miss_num_map(p5_a37);
1219 ddp_avlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a38);
1220 ddp_avlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a39);
1221 ddp_avlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a40);
1222 ddp_avlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a41);
1223 ddp_avlv_rec.inv_code := p5_a42;
1224
1225 -- here's the delegated call to the old PL/SQL routine
1226 okl_avl_pvt.lock_row(p_api_version,
1227 p_init_msg_list,
1228 x_return_status,
1229 x_msg_count,
1230 x_msg_data,
1231 ddp_avlv_rec);
1232
1233 -- copy data back from the local variables to OUT or IN-OUT args, if any
1234
1235
1236
1237
1238
1239 end;
1240
1241 procedure lock_row(p_api_version NUMBER
1242 , p_init_msg_list VARCHAR2
1243 , x_return_status out nocopy VARCHAR2
1244 , x_msg_count out nocopy NUMBER
1245 , x_msg_data out nocopy VARCHAR2
1246 , p5_a0 JTF_NUMBER_TABLE
1247 , p5_a1 JTF_NUMBER_TABLE
1248 , p5_a2 JTF_NUMBER_TABLE
1249 , p5_a3 JTF_NUMBER_TABLE
1250 , p5_a4 JTF_NUMBER_TABLE
1251 , p5_a5 JTF_NUMBER_TABLE
1252 , p5_a6 JTF_NUMBER_TABLE
1253 , p5_a7 JTF_VARCHAR2_TABLE_100
1254 , p5_a8 JTF_VARCHAR2_TABLE_100
1255 , p5_a9 JTF_VARCHAR2_TABLE_100
1256 , p5_a10 JTF_VARCHAR2_TABLE_100
1257 , p5_a11 JTF_VARCHAR2_TABLE_100
1258 , p5_a12 JTF_VARCHAR2_TABLE_100
1259 , p5_a13 JTF_VARCHAR2_TABLE_200
1260 , p5_a14 JTF_VARCHAR2_TABLE_2000
1261 , p5_a15 JTF_VARCHAR2_TABLE_100
1262 , p5_a16 JTF_VARCHAR2_TABLE_100
1263 , p5_a17 JTF_DATE_TABLE
1264 , p5_a18 JTF_DATE_TABLE
1265 , p5_a19 JTF_VARCHAR2_TABLE_100
1266 , p5_a20 JTF_VARCHAR2_TABLE_100
1267 , p5_a21 JTF_VARCHAR2_TABLE_500
1268 , p5_a22 JTF_VARCHAR2_TABLE_500
1269 , p5_a23 JTF_VARCHAR2_TABLE_500
1270 , p5_a24 JTF_VARCHAR2_TABLE_500
1271 , p5_a25 JTF_VARCHAR2_TABLE_500
1272 , p5_a26 JTF_VARCHAR2_TABLE_500
1273 , p5_a27 JTF_VARCHAR2_TABLE_500
1274 , p5_a28 JTF_VARCHAR2_TABLE_500
1275 , p5_a29 JTF_VARCHAR2_TABLE_500
1276 , p5_a30 JTF_VARCHAR2_TABLE_500
1277 , p5_a31 JTF_VARCHAR2_TABLE_500
1278 , p5_a32 JTF_VARCHAR2_TABLE_500
1279 , p5_a33 JTF_VARCHAR2_TABLE_500
1280 , p5_a34 JTF_VARCHAR2_TABLE_500
1281 , p5_a35 JTF_VARCHAR2_TABLE_500
1282 , p5_a36 JTF_NUMBER_TABLE
1283 , p5_a37 JTF_NUMBER_TABLE
1284 , p5_a38 JTF_DATE_TABLE
1285 , p5_a39 JTF_NUMBER_TABLE
1286 , p5_a40 JTF_DATE_TABLE
1287 , p5_a41 JTF_NUMBER_TABLE
1288 , p5_a42 JTF_VARCHAR2_TABLE_100
1289 )
1290
1291 as
1292 ddp_avlv_tbl okl_avl_pvt.avlv_tbl_type;
1293 ddindx binary_integer; indx binary_integer;
1294 begin
1295
1296 -- copy data to the local IN or IN-OUT args, if any
1297
1298
1299
1300
1301
1302 okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p5_a0
1303 , p5_a1
1304 , p5_a2
1305 , p5_a3
1306 , p5_a4
1307 , p5_a5
1308 , p5_a6
1309 , p5_a7
1310 , p5_a8
1311 , p5_a9
1312 , p5_a10
1313 , p5_a11
1314 , p5_a12
1315 , p5_a13
1316 , p5_a14
1317 , p5_a15
1318 , p5_a16
1319 , p5_a17
1320 , p5_a18
1321 , p5_a19
1322 , p5_a20
1323 , p5_a21
1324 , p5_a22
1325 , p5_a23
1326 , p5_a24
1327 , p5_a25
1328 , p5_a26
1329 , p5_a27
1330 , p5_a28
1331 , p5_a29
1332 , p5_a30
1333 , p5_a31
1334 , p5_a32
1335 , p5_a33
1336 , p5_a34
1337 , p5_a35
1338 , p5_a36
1339 , p5_a37
1340 , p5_a38
1341 , p5_a39
1342 , p5_a40
1343 , p5_a41
1344 , p5_a42
1345 );
1346
1347 -- here's the delegated call to the old PL/SQL routine
1348 okl_avl_pvt.lock_row(p_api_version,
1349 p_init_msg_list,
1350 x_return_status,
1351 x_msg_count,
1352 x_msg_data,
1353 ddp_avlv_tbl);
1354
1355 -- copy data back from the local variables to OUT or IN-OUT args, if any
1356
1357
1358
1359
1360
1361 end;
1362
1363 procedure update_row(p_api_version NUMBER
1364 , p_init_msg_list VARCHAR2
1365 , x_return_status out nocopy VARCHAR2
1366 , x_msg_count out nocopy NUMBER
1367 , x_msg_data out nocopy VARCHAR2
1368 , p6_a0 out nocopy NUMBER
1369 , p6_a1 out nocopy NUMBER
1370 , p6_a2 out nocopy NUMBER
1371 , p6_a3 out nocopy NUMBER
1372 , p6_a4 out nocopy NUMBER
1373 , p6_a5 out nocopy NUMBER
1374 , p6_a6 out nocopy NUMBER
1375 , p6_a7 out nocopy VARCHAR2
1376 , p6_a8 out nocopy VARCHAR2
1377 , p6_a9 out nocopy VARCHAR2
1378 , p6_a10 out nocopy VARCHAR2
1379 , p6_a11 out nocopy VARCHAR2
1380 , p6_a12 out nocopy VARCHAR2
1381 , p6_a13 out nocopy VARCHAR2
1382 , p6_a14 out nocopy VARCHAR2
1383 , p6_a15 out nocopy VARCHAR2
1384 , p6_a16 out nocopy VARCHAR2
1385 , p6_a17 out nocopy DATE
1386 , p6_a18 out nocopy DATE
1387 , p6_a19 out nocopy VARCHAR2
1388 , p6_a20 out nocopy VARCHAR2
1389 , p6_a21 out nocopy VARCHAR2
1390 , p6_a22 out nocopy VARCHAR2
1391 , p6_a23 out nocopy VARCHAR2
1392 , p6_a24 out nocopy VARCHAR2
1393 , p6_a25 out nocopy VARCHAR2
1394 , p6_a26 out nocopy VARCHAR2
1395 , p6_a27 out nocopy VARCHAR2
1396 , p6_a28 out nocopy VARCHAR2
1397 , p6_a29 out nocopy VARCHAR2
1398 , p6_a30 out nocopy VARCHAR2
1399 , p6_a31 out nocopy VARCHAR2
1400 , p6_a32 out nocopy VARCHAR2
1401 , p6_a33 out nocopy VARCHAR2
1402 , p6_a34 out nocopy VARCHAR2
1403 , p6_a35 out nocopy VARCHAR2
1404 , p6_a36 out nocopy NUMBER
1405 , p6_a37 out nocopy NUMBER
1406 , p6_a38 out nocopy DATE
1407 , p6_a39 out nocopy NUMBER
1408 , p6_a40 out nocopy DATE
1409 , p6_a41 out nocopy NUMBER
1410 , p6_a42 out nocopy VARCHAR2
1411 , p5_a0 NUMBER := 0-1962.0724
1412 , p5_a1 NUMBER := 0-1962.0724
1413 , p5_a2 NUMBER := 0-1962.0724
1414 , p5_a3 NUMBER := 0-1962.0724
1415 , p5_a4 NUMBER := 0-1962.0724
1416 , p5_a5 NUMBER := 0-1962.0724
1417 , p5_a6 NUMBER := 0-1962.0724
1418 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1419 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1420 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1421 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1422 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1423 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1424 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1425 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1426 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1427 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1428 , p5_a17 DATE := fnd_api.g_miss_date
1429 , p5_a18 DATE := fnd_api.g_miss_date
1430 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1431 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1432 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1433 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1434 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1435 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1436 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1437 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1438 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1439 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1440 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1441 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1442 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1443 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1444 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1445 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1446 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1447 , p5_a36 NUMBER := 0-1962.0724
1448 , p5_a37 NUMBER := 0-1962.0724
1449 , p5_a38 DATE := fnd_api.g_miss_date
1450 , p5_a39 NUMBER := 0-1962.0724
1451 , p5_a40 DATE := fnd_api.g_miss_date
1452 , p5_a41 NUMBER := 0-1962.0724
1453 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1454 )
1455
1456 as
1457 ddp_avlv_rec okl_avl_pvt.avlv_rec_type;
1458 ddx_avlv_rec okl_avl_pvt.avlv_rec_type;
1459 ddindx binary_integer; indx binary_integer;
1460 begin
1461
1462 -- copy data to the local IN or IN-OUT args, if any
1463
1464
1465
1466
1467
1468 ddp_avlv_rec.id := rosetta_g_miss_num_map(p5_a0);
1469 ddp_avlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1470 ddp_avlv_rec.try_id := rosetta_g_miss_num_map(p5_a2);
1471 ddp_avlv_rec.aes_id := rosetta_g_miss_num_map(p5_a3);
1472 ddp_avlv_rec.sty_id := rosetta_g_miss_num_map(p5_a4);
1473 ddp_avlv_rec.fma_id := rosetta_g_miss_num_map(p5_a5);
1474 ddp_avlv_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a6);
1475 ddp_avlv_rec.fac_code := p5_a7;
1476 ddp_avlv_rec.syt_code := p5_a8;
1477 ddp_avlv_rec.post_to_gl := p5_a9;
1478 ddp_avlv_rec.advance_arrears := p5_a10;
1479 ddp_avlv_rec.memo_yn := p5_a11;
1480 ddp_avlv_rec.prior_year_yn := p5_a12;
1481 ddp_avlv_rec.name := p5_a13;
1482 ddp_avlv_rec.description := p5_a14;
1483 ddp_avlv_rec.version := p5_a15;
1484 ddp_avlv_rec.factoring_synd_flag := p5_a16;
1485 ddp_avlv_rec.start_date := rosetta_g_miss_date_in_map(p5_a17);
1486 ddp_avlv_rec.end_date := rosetta_g_miss_date_in_map(p5_a18);
1487 ddp_avlv_rec.accrual_yn := p5_a19;
1488 ddp_avlv_rec.attribute_category := p5_a20;
1489 ddp_avlv_rec.attribute1 := p5_a21;
1490 ddp_avlv_rec.attribute2 := p5_a22;
1491 ddp_avlv_rec.attribute3 := p5_a23;
1492 ddp_avlv_rec.attribute4 := p5_a24;
1493 ddp_avlv_rec.attribute5 := p5_a25;
1494 ddp_avlv_rec.attribute6 := p5_a26;
1495 ddp_avlv_rec.attribute7 := p5_a27;
1496 ddp_avlv_rec.attribute8 := p5_a28;
1497 ddp_avlv_rec.attribute9 := p5_a29;
1498 ddp_avlv_rec.attribute10 := p5_a30;
1499 ddp_avlv_rec.attribute11 := p5_a31;
1500 ddp_avlv_rec.attribute12 := p5_a32;
1501 ddp_avlv_rec.attribute13 := p5_a33;
1502 ddp_avlv_rec.attribute14 := p5_a34;
1503 ddp_avlv_rec.attribute15 := p5_a35;
1504 ddp_avlv_rec.org_id := rosetta_g_miss_num_map(p5_a36);
1505 ddp_avlv_rec.created_by := rosetta_g_miss_num_map(p5_a37);
1506 ddp_avlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a38);
1507 ddp_avlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a39);
1508 ddp_avlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a40);
1509 ddp_avlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a41);
1510 ddp_avlv_rec.inv_code := p5_a42;
1511
1512
1513 -- here's the delegated call to the old PL/SQL routine
1514 okl_avl_pvt.update_row(p_api_version,
1515 p_init_msg_list,
1516 x_return_status,
1517 x_msg_count,
1518 x_msg_data,
1519 ddp_avlv_rec,
1520 ddx_avlv_rec);
1521
1522 -- copy data back from the local variables to OUT or IN-OUT args, if any
1523
1524
1525
1526
1527
1528
1529 p6_a0 := rosetta_g_miss_num_map(ddx_avlv_rec.id);
1530 p6_a1 := rosetta_g_miss_num_map(ddx_avlv_rec.object_version_number);
1531 p6_a2 := rosetta_g_miss_num_map(ddx_avlv_rec.try_id);
1532 p6_a3 := rosetta_g_miss_num_map(ddx_avlv_rec.aes_id);
1533 p6_a4 := rosetta_g_miss_num_map(ddx_avlv_rec.sty_id);
1534 p6_a5 := rosetta_g_miss_num_map(ddx_avlv_rec.fma_id);
1535 p6_a6 := rosetta_g_miss_num_map(ddx_avlv_rec.set_of_books_id);
1536 p6_a7 := ddx_avlv_rec.fac_code;
1537 p6_a8 := ddx_avlv_rec.syt_code;
1538 p6_a9 := ddx_avlv_rec.post_to_gl;
1539 p6_a10 := ddx_avlv_rec.advance_arrears;
1540 p6_a11 := ddx_avlv_rec.memo_yn;
1541 p6_a12 := ddx_avlv_rec.prior_year_yn;
1542 p6_a13 := ddx_avlv_rec.name;
1543 p6_a14 := ddx_avlv_rec.description;
1544 p6_a15 := ddx_avlv_rec.version;
1545 p6_a16 := ddx_avlv_rec.factoring_synd_flag;
1546 p6_a17 := ddx_avlv_rec.start_date;
1547 p6_a18 := ddx_avlv_rec.end_date;
1548 p6_a19 := ddx_avlv_rec.accrual_yn;
1549 p6_a20 := ddx_avlv_rec.attribute_category;
1550 p6_a21 := ddx_avlv_rec.attribute1;
1551 p6_a22 := ddx_avlv_rec.attribute2;
1552 p6_a23 := ddx_avlv_rec.attribute3;
1553 p6_a24 := ddx_avlv_rec.attribute4;
1554 p6_a25 := ddx_avlv_rec.attribute5;
1555 p6_a26 := ddx_avlv_rec.attribute6;
1556 p6_a27 := ddx_avlv_rec.attribute7;
1557 p6_a28 := ddx_avlv_rec.attribute8;
1558 p6_a29 := ddx_avlv_rec.attribute9;
1559 p6_a30 := ddx_avlv_rec.attribute10;
1560 p6_a31 := ddx_avlv_rec.attribute11;
1561 p6_a32 := ddx_avlv_rec.attribute12;
1562 p6_a33 := ddx_avlv_rec.attribute13;
1563 p6_a34 := ddx_avlv_rec.attribute14;
1564 p6_a35 := ddx_avlv_rec.attribute15;
1565 p6_a36 := rosetta_g_miss_num_map(ddx_avlv_rec.org_id);
1566 p6_a37 := rosetta_g_miss_num_map(ddx_avlv_rec.created_by);
1567 p6_a38 := ddx_avlv_rec.creation_date;
1568 p6_a39 := rosetta_g_miss_num_map(ddx_avlv_rec.last_updated_by);
1569 p6_a40 := ddx_avlv_rec.last_update_date;
1570 p6_a41 := rosetta_g_miss_num_map(ddx_avlv_rec.last_update_login);
1571 p6_a42 := ddx_avlv_rec.inv_code;
1572 end;
1573
1574 procedure update_row(p_api_version NUMBER
1575 , p_init_msg_list VARCHAR2
1576 , x_return_status out nocopy VARCHAR2
1577 , x_msg_count out nocopy NUMBER
1578 , x_msg_data out nocopy VARCHAR2
1579 , p5_a0 JTF_NUMBER_TABLE
1580 , p5_a1 JTF_NUMBER_TABLE
1581 , p5_a2 JTF_NUMBER_TABLE
1582 , p5_a3 JTF_NUMBER_TABLE
1583 , p5_a4 JTF_NUMBER_TABLE
1584 , p5_a5 JTF_NUMBER_TABLE
1585 , p5_a6 JTF_NUMBER_TABLE
1586 , p5_a7 JTF_VARCHAR2_TABLE_100
1587 , p5_a8 JTF_VARCHAR2_TABLE_100
1588 , p5_a9 JTF_VARCHAR2_TABLE_100
1589 , p5_a10 JTF_VARCHAR2_TABLE_100
1590 , p5_a11 JTF_VARCHAR2_TABLE_100
1591 , p5_a12 JTF_VARCHAR2_TABLE_100
1592 , p5_a13 JTF_VARCHAR2_TABLE_200
1593 , p5_a14 JTF_VARCHAR2_TABLE_2000
1594 , p5_a15 JTF_VARCHAR2_TABLE_100
1595 , p5_a16 JTF_VARCHAR2_TABLE_100
1596 , p5_a17 JTF_DATE_TABLE
1597 , p5_a18 JTF_DATE_TABLE
1598 , p5_a19 JTF_VARCHAR2_TABLE_100
1599 , p5_a20 JTF_VARCHAR2_TABLE_100
1600 , p5_a21 JTF_VARCHAR2_TABLE_500
1601 , p5_a22 JTF_VARCHAR2_TABLE_500
1602 , p5_a23 JTF_VARCHAR2_TABLE_500
1603 , p5_a24 JTF_VARCHAR2_TABLE_500
1604 , p5_a25 JTF_VARCHAR2_TABLE_500
1605 , p5_a26 JTF_VARCHAR2_TABLE_500
1606 , p5_a27 JTF_VARCHAR2_TABLE_500
1607 , p5_a28 JTF_VARCHAR2_TABLE_500
1608 , p5_a29 JTF_VARCHAR2_TABLE_500
1609 , p5_a30 JTF_VARCHAR2_TABLE_500
1610 , p5_a31 JTF_VARCHAR2_TABLE_500
1611 , p5_a32 JTF_VARCHAR2_TABLE_500
1612 , p5_a33 JTF_VARCHAR2_TABLE_500
1613 , p5_a34 JTF_VARCHAR2_TABLE_500
1614 , p5_a35 JTF_VARCHAR2_TABLE_500
1615 , p5_a36 JTF_NUMBER_TABLE
1616 , p5_a37 JTF_NUMBER_TABLE
1617 , p5_a38 JTF_DATE_TABLE
1618 , p5_a39 JTF_NUMBER_TABLE
1619 , p5_a40 JTF_DATE_TABLE
1620 , p5_a41 JTF_NUMBER_TABLE
1621 , p5_a42 JTF_VARCHAR2_TABLE_100
1622 , p6_a0 out nocopy JTF_NUMBER_TABLE
1623 , p6_a1 out nocopy JTF_NUMBER_TABLE
1624 , p6_a2 out nocopy JTF_NUMBER_TABLE
1625 , p6_a3 out nocopy JTF_NUMBER_TABLE
1626 , p6_a4 out nocopy JTF_NUMBER_TABLE
1627 , p6_a5 out nocopy JTF_NUMBER_TABLE
1628 , p6_a6 out nocopy JTF_NUMBER_TABLE
1629 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1630 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1631 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1632 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1633 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1634 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1635 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
1636 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_2000
1637 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1638 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
1639 , p6_a17 out nocopy JTF_DATE_TABLE
1640 , p6_a18 out nocopy JTF_DATE_TABLE
1641 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
1642 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1643 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1644 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1645 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1646 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1647 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1648 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1649 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1650 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1651 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
1652 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
1653 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
1654 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1655 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1656 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
1657 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
1658 , p6_a36 out nocopy JTF_NUMBER_TABLE
1659 , p6_a37 out nocopy JTF_NUMBER_TABLE
1660 , p6_a38 out nocopy JTF_DATE_TABLE
1661 , p6_a39 out nocopy JTF_NUMBER_TABLE
1662 , p6_a40 out nocopy JTF_DATE_TABLE
1663 , p6_a41 out nocopy JTF_NUMBER_TABLE
1664 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
1665 )
1666
1667 as
1668 ddp_avlv_tbl okl_avl_pvt.avlv_tbl_type;
1669 ddx_avlv_tbl okl_avl_pvt.avlv_tbl_type;
1670 ddindx binary_integer; indx binary_integer;
1671 begin
1672
1673 -- copy data to the local IN or IN-OUT args, if any
1674
1675
1676
1677
1678
1679 okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p5_a0
1680 , p5_a1
1681 , p5_a2
1682 , p5_a3
1683 , p5_a4
1684 , p5_a5
1685 , p5_a6
1686 , p5_a7
1687 , p5_a8
1688 , p5_a9
1689 , p5_a10
1690 , p5_a11
1691 , p5_a12
1692 , p5_a13
1693 , p5_a14
1694 , p5_a15
1695 , p5_a16
1696 , p5_a17
1697 , p5_a18
1698 , p5_a19
1699 , p5_a20
1700 , p5_a21
1701 , p5_a22
1702 , p5_a23
1703 , p5_a24
1704 , p5_a25
1705 , p5_a26
1706 , p5_a27
1707 , p5_a28
1708 , p5_a29
1709 , p5_a30
1710 , p5_a31
1711 , p5_a32
1712 , p5_a33
1713 , p5_a34
1714 , p5_a35
1715 , p5_a36
1716 , p5_a37
1717 , p5_a38
1718 , p5_a39
1719 , p5_a40
1720 , p5_a41
1721 , p5_a42
1722 );
1723
1724
1725 -- here's the delegated call to the old PL/SQL routine
1726 okl_avl_pvt.update_row(p_api_version,
1727 p_init_msg_list,
1728 x_return_status,
1729 x_msg_count,
1730 x_msg_data,
1731 ddp_avlv_tbl,
1732 ddx_avlv_tbl);
1733
1734 -- copy data back from the local variables to OUT or IN-OUT args, if any
1735
1736
1737
1738
1739
1740
1741 okl_avl_pvt_w.rosetta_table_copy_out_p5(ddx_avlv_tbl, p6_a0
1742 , p6_a1
1743 , p6_a2
1744 , p6_a3
1745 , p6_a4
1746 , p6_a5
1747 , p6_a6
1748 , p6_a7
1749 , p6_a8
1750 , p6_a9
1751 , p6_a10
1752 , p6_a11
1753 , p6_a12
1754 , p6_a13
1755 , p6_a14
1756 , p6_a15
1757 , p6_a16
1758 , p6_a17
1759 , p6_a18
1760 , p6_a19
1761 , p6_a20
1762 , p6_a21
1763 , p6_a22
1764 , p6_a23
1765 , p6_a24
1766 , p6_a25
1767 , p6_a26
1768 , p6_a27
1769 , p6_a28
1770 , p6_a29
1771 , p6_a30
1772 , p6_a31
1773 , p6_a32
1774 , p6_a33
1775 , p6_a34
1776 , p6_a35
1777 , p6_a36
1778 , p6_a37
1779 , p6_a38
1780 , p6_a39
1781 , p6_a40
1782 , p6_a41
1783 , p6_a42
1784 );
1785 end;
1786
1787 procedure delete_row(p_api_version NUMBER
1788 , p_init_msg_list VARCHAR2
1789 , x_return_status out nocopy VARCHAR2
1790 , x_msg_count out nocopy NUMBER
1791 , x_msg_data out nocopy VARCHAR2
1792 , p5_a0 NUMBER := 0-1962.0724
1793 , p5_a1 NUMBER := 0-1962.0724
1794 , p5_a2 NUMBER := 0-1962.0724
1795 , p5_a3 NUMBER := 0-1962.0724
1796 , p5_a4 NUMBER := 0-1962.0724
1797 , p5_a5 NUMBER := 0-1962.0724
1798 , p5_a6 NUMBER := 0-1962.0724
1799 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1800 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1801 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1802 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1803 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1804 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1805 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1806 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1807 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1808 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1809 , p5_a17 DATE := fnd_api.g_miss_date
1810 , p5_a18 DATE := fnd_api.g_miss_date
1811 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1812 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1813 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1814 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1815 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1816 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1817 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1818 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1819 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1820 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1821 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1822 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1823 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1824 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1825 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1826 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1827 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1828 , p5_a36 NUMBER := 0-1962.0724
1829 , p5_a37 NUMBER := 0-1962.0724
1830 , p5_a38 DATE := fnd_api.g_miss_date
1831 , p5_a39 NUMBER := 0-1962.0724
1832 , p5_a40 DATE := fnd_api.g_miss_date
1833 , p5_a41 NUMBER := 0-1962.0724
1834 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1835 )
1836
1837 as
1838 ddp_avlv_rec okl_avl_pvt.avlv_rec_type;
1839 ddindx binary_integer; indx binary_integer;
1840 begin
1841
1842 -- copy data to the local IN or IN-OUT args, if any
1843
1844
1845
1846
1847
1848 ddp_avlv_rec.id := rosetta_g_miss_num_map(p5_a0);
1849 ddp_avlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1850 ddp_avlv_rec.try_id := rosetta_g_miss_num_map(p5_a2);
1851 ddp_avlv_rec.aes_id := rosetta_g_miss_num_map(p5_a3);
1852 ddp_avlv_rec.sty_id := rosetta_g_miss_num_map(p5_a4);
1853 ddp_avlv_rec.fma_id := rosetta_g_miss_num_map(p5_a5);
1854 ddp_avlv_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a6);
1855 ddp_avlv_rec.fac_code := p5_a7;
1856 ddp_avlv_rec.syt_code := p5_a8;
1857 ddp_avlv_rec.post_to_gl := p5_a9;
1858 ddp_avlv_rec.advance_arrears := p5_a10;
1859 ddp_avlv_rec.memo_yn := p5_a11;
1860 ddp_avlv_rec.prior_year_yn := p5_a12;
1861 ddp_avlv_rec.name := p5_a13;
1862 ddp_avlv_rec.description := p5_a14;
1863 ddp_avlv_rec.version := p5_a15;
1864 ddp_avlv_rec.factoring_synd_flag := p5_a16;
1865 ddp_avlv_rec.start_date := rosetta_g_miss_date_in_map(p5_a17);
1866 ddp_avlv_rec.end_date := rosetta_g_miss_date_in_map(p5_a18);
1867 ddp_avlv_rec.accrual_yn := p5_a19;
1868 ddp_avlv_rec.attribute_category := p5_a20;
1869 ddp_avlv_rec.attribute1 := p5_a21;
1870 ddp_avlv_rec.attribute2 := p5_a22;
1871 ddp_avlv_rec.attribute3 := p5_a23;
1872 ddp_avlv_rec.attribute4 := p5_a24;
1873 ddp_avlv_rec.attribute5 := p5_a25;
1874 ddp_avlv_rec.attribute6 := p5_a26;
1875 ddp_avlv_rec.attribute7 := p5_a27;
1876 ddp_avlv_rec.attribute8 := p5_a28;
1877 ddp_avlv_rec.attribute9 := p5_a29;
1878 ddp_avlv_rec.attribute10 := p5_a30;
1879 ddp_avlv_rec.attribute11 := p5_a31;
1880 ddp_avlv_rec.attribute12 := p5_a32;
1881 ddp_avlv_rec.attribute13 := p5_a33;
1882 ddp_avlv_rec.attribute14 := p5_a34;
1883 ddp_avlv_rec.attribute15 := p5_a35;
1884 ddp_avlv_rec.org_id := rosetta_g_miss_num_map(p5_a36);
1885 ddp_avlv_rec.created_by := rosetta_g_miss_num_map(p5_a37);
1886 ddp_avlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a38);
1887 ddp_avlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a39);
1888 ddp_avlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a40);
1889 ddp_avlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a41);
1890 ddp_avlv_rec.inv_code := p5_a42;
1891
1892 -- here's the delegated call to the old PL/SQL routine
1893 okl_avl_pvt.delete_row(p_api_version,
1894 p_init_msg_list,
1895 x_return_status,
1896 x_msg_count,
1897 x_msg_data,
1898 ddp_avlv_rec);
1899
1900 -- copy data back from the local variables to OUT or IN-OUT args, if any
1901
1902
1903
1904
1905
1906 end;
1907
1908 procedure delete_row(p_api_version NUMBER
1909 , p_init_msg_list VARCHAR2
1910 , x_return_status out nocopy VARCHAR2
1911 , x_msg_count out nocopy NUMBER
1912 , x_msg_data out nocopy VARCHAR2
1913 , p5_a0 JTF_NUMBER_TABLE
1914 , p5_a1 JTF_NUMBER_TABLE
1915 , p5_a2 JTF_NUMBER_TABLE
1916 , p5_a3 JTF_NUMBER_TABLE
1917 , p5_a4 JTF_NUMBER_TABLE
1918 , p5_a5 JTF_NUMBER_TABLE
1919 , p5_a6 JTF_NUMBER_TABLE
1920 , p5_a7 JTF_VARCHAR2_TABLE_100
1921 , p5_a8 JTF_VARCHAR2_TABLE_100
1922 , p5_a9 JTF_VARCHAR2_TABLE_100
1923 , p5_a10 JTF_VARCHAR2_TABLE_100
1924 , p5_a11 JTF_VARCHAR2_TABLE_100
1925 , p5_a12 JTF_VARCHAR2_TABLE_100
1926 , p5_a13 JTF_VARCHAR2_TABLE_200
1927 , p5_a14 JTF_VARCHAR2_TABLE_2000
1928 , p5_a15 JTF_VARCHAR2_TABLE_100
1929 , p5_a16 JTF_VARCHAR2_TABLE_100
1930 , p5_a17 JTF_DATE_TABLE
1931 , p5_a18 JTF_DATE_TABLE
1932 , p5_a19 JTF_VARCHAR2_TABLE_100
1933 , p5_a20 JTF_VARCHAR2_TABLE_100
1934 , p5_a21 JTF_VARCHAR2_TABLE_500
1935 , p5_a22 JTF_VARCHAR2_TABLE_500
1936 , p5_a23 JTF_VARCHAR2_TABLE_500
1937 , p5_a24 JTF_VARCHAR2_TABLE_500
1938 , p5_a25 JTF_VARCHAR2_TABLE_500
1939 , p5_a26 JTF_VARCHAR2_TABLE_500
1940 , p5_a27 JTF_VARCHAR2_TABLE_500
1941 , p5_a28 JTF_VARCHAR2_TABLE_500
1942 , p5_a29 JTF_VARCHAR2_TABLE_500
1943 , p5_a30 JTF_VARCHAR2_TABLE_500
1944 , p5_a31 JTF_VARCHAR2_TABLE_500
1945 , p5_a32 JTF_VARCHAR2_TABLE_500
1946 , p5_a33 JTF_VARCHAR2_TABLE_500
1947 , p5_a34 JTF_VARCHAR2_TABLE_500
1948 , p5_a35 JTF_VARCHAR2_TABLE_500
1949 , p5_a36 JTF_NUMBER_TABLE
1950 , p5_a37 JTF_NUMBER_TABLE
1951 , p5_a38 JTF_DATE_TABLE
1952 , p5_a39 JTF_NUMBER_TABLE
1953 , p5_a40 JTF_DATE_TABLE
1954 , p5_a41 JTF_NUMBER_TABLE
1955 , p5_a42 JTF_VARCHAR2_TABLE_100
1956 )
1957
1958 as
1959 ddp_avlv_tbl okl_avl_pvt.avlv_tbl_type;
1960 ddindx binary_integer; indx binary_integer;
1961 begin
1962
1963 -- copy data to the local IN or IN-OUT args, if any
1964
1965
1966
1967
1968
1969 okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p5_a0
1970 , p5_a1
1971 , p5_a2
1972 , p5_a3
1973 , p5_a4
1974 , p5_a5
1975 , p5_a6
1976 , p5_a7
1977 , p5_a8
1978 , p5_a9
1979 , p5_a10
1980 , p5_a11
1981 , p5_a12
1982 , p5_a13
1983 , p5_a14
1984 , p5_a15
1985 , p5_a16
1986 , p5_a17
1987 , p5_a18
1988 , p5_a19
1989 , p5_a20
1990 , p5_a21
1991 , p5_a22
1992 , p5_a23
1993 , p5_a24
1994 , p5_a25
1995 , p5_a26
1996 , p5_a27
1997 , p5_a28
1998 , p5_a29
1999 , p5_a30
2000 , p5_a31
2001 , p5_a32
2002 , p5_a33
2003 , p5_a34
2004 , p5_a35
2005 , p5_a36
2006 , p5_a37
2007 , p5_a38
2008 , p5_a39
2009 , p5_a40
2010 , p5_a41
2011 , p5_a42
2012 );
2013
2014 -- here's the delegated call to the old PL/SQL routine
2015 okl_avl_pvt.delete_row(p_api_version,
2016 p_init_msg_list,
2017 x_return_status,
2018 x_msg_count,
2019 x_msg_data,
2020 ddp_avlv_tbl);
2021
2022 -- copy data back from the local variables to OUT or IN-OUT args, if any
2023
2024
2025
2026
2027
2028 end;
2029
2030 procedure validate_row(p_api_version NUMBER
2031 , p_init_msg_list VARCHAR2
2032 , x_return_status out nocopy VARCHAR2
2033 , x_msg_count out nocopy NUMBER
2034 , x_msg_data out nocopy VARCHAR2
2035 , p5_a0 NUMBER := 0-1962.0724
2036 , p5_a1 NUMBER := 0-1962.0724
2037 , p5_a2 NUMBER := 0-1962.0724
2038 , p5_a3 NUMBER := 0-1962.0724
2039 , p5_a4 NUMBER := 0-1962.0724
2040 , p5_a5 NUMBER := 0-1962.0724
2041 , p5_a6 NUMBER := 0-1962.0724
2042 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2043 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2044 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2045 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2046 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2047 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2048 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2049 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2050 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2051 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2052 , p5_a17 DATE := fnd_api.g_miss_date
2053 , p5_a18 DATE := fnd_api.g_miss_date
2054 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2055 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2056 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2057 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2058 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2059 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2060 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2061 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2062 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2063 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2064 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2065 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2066 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2067 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2068 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2069 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2070 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2071 , p5_a36 NUMBER := 0-1962.0724
2072 , p5_a37 NUMBER := 0-1962.0724
2073 , p5_a38 DATE := fnd_api.g_miss_date
2074 , p5_a39 NUMBER := 0-1962.0724
2075 , p5_a40 DATE := fnd_api.g_miss_date
2076 , p5_a41 NUMBER := 0-1962.0724
2077 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2078 )
2079
2080 as
2081 ddp_avlv_rec okl_avl_pvt.avlv_rec_type;
2082 ddindx binary_integer; indx binary_integer;
2083 begin
2084
2085 -- copy data to the local IN or IN-OUT args, if any
2086
2087
2088
2089
2090
2091 ddp_avlv_rec.id := rosetta_g_miss_num_map(p5_a0);
2092 ddp_avlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
2093 ddp_avlv_rec.try_id := rosetta_g_miss_num_map(p5_a2);
2094 ddp_avlv_rec.aes_id := rosetta_g_miss_num_map(p5_a3);
2095 ddp_avlv_rec.sty_id := rosetta_g_miss_num_map(p5_a4);
2096 ddp_avlv_rec.fma_id := rosetta_g_miss_num_map(p5_a5);
2097 ddp_avlv_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a6);
2098 ddp_avlv_rec.fac_code := p5_a7;
2099 ddp_avlv_rec.syt_code := p5_a8;
2100 ddp_avlv_rec.post_to_gl := p5_a9;
2101 ddp_avlv_rec.advance_arrears := p5_a10;
2102 ddp_avlv_rec.memo_yn := p5_a11;
2103 ddp_avlv_rec.prior_year_yn := p5_a12;
2104 ddp_avlv_rec.name := p5_a13;
2105 ddp_avlv_rec.description := p5_a14;
2106 ddp_avlv_rec.version := p5_a15;
2107 ddp_avlv_rec.factoring_synd_flag := p5_a16;
2108 ddp_avlv_rec.start_date := rosetta_g_miss_date_in_map(p5_a17);
2109 ddp_avlv_rec.end_date := rosetta_g_miss_date_in_map(p5_a18);
2110 ddp_avlv_rec.accrual_yn := p5_a19;
2111 ddp_avlv_rec.attribute_category := p5_a20;
2112 ddp_avlv_rec.attribute1 := p5_a21;
2113 ddp_avlv_rec.attribute2 := p5_a22;
2114 ddp_avlv_rec.attribute3 := p5_a23;
2115 ddp_avlv_rec.attribute4 := p5_a24;
2116 ddp_avlv_rec.attribute5 := p5_a25;
2117 ddp_avlv_rec.attribute6 := p5_a26;
2118 ddp_avlv_rec.attribute7 := p5_a27;
2119 ddp_avlv_rec.attribute8 := p5_a28;
2120 ddp_avlv_rec.attribute9 := p5_a29;
2121 ddp_avlv_rec.attribute10 := p5_a30;
2122 ddp_avlv_rec.attribute11 := p5_a31;
2123 ddp_avlv_rec.attribute12 := p5_a32;
2124 ddp_avlv_rec.attribute13 := p5_a33;
2125 ddp_avlv_rec.attribute14 := p5_a34;
2126 ddp_avlv_rec.attribute15 := p5_a35;
2127 ddp_avlv_rec.org_id := rosetta_g_miss_num_map(p5_a36);
2128 ddp_avlv_rec.created_by := rosetta_g_miss_num_map(p5_a37);
2129 ddp_avlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a38);
2130 ddp_avlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a39);
2131 ddp_avlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a40);
2132 ddp_avlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a41);
2133 ddp_avlv_rec.inv_code := p5_a42;
2134
2135 -- here's the delegated call to the old PL/SQL routine
2136 okl_avl_pvt.validate_row(p_api_version,
2137 p_init_msg_list,
2138 x_return_status,
2139 x_msg_count,
2140 x_msg_data,
2141 ddp_avlv_rec);
2142
2143 -- copy data back from the local variables to OUT or IN-OUT args, if any
2144
2145
2146
2147
2148
2149 end;
2150
2151 procedure validate_row(p_api_version NUMBER
2152 , p_init_msg_list VARCHAR2
2153 , x_return_status out nocopy VARCHAR2
2154 , x_msg_count out nocopy NUMBER
2155 , x_msg_data out nocopy VARCHAR2
2156 , p5_a0 JTF_NUMBER_TABLE
2157 , p5_a1 JTF_NUMBER_TABLE
2158 , p5_a2 JTF_NUMBER_TABLE
2159 , p5_a3 JTF_NUMBER_TABLE
2160 , p5_a4 JTF_NUMBER_TABLE
2161 , p5_a5 JTF_NUMBER_TABLE
2162 , p5_a6 JTF_NUMBER_TABLE
2163 , p5_a7 JTF_VARCHAR2_TABLE_100
2164 , p5_a8 JTF_VARCHAR2_TABLE_100
2165 , p5_a9 JTF_VARCHAR2_TABLE_100
2166 , p5_a10 JTF_VARCHAR2_TABLE_100
2167 , p5_a11 JTF_VARCHAR2_TABLE_100
2168 , p5_a12 JTF_VARCHAR2_TABLE_100
2169 , p5_a13 JTF_VARCHAR2_TABLE_200
2170 , p5_a14 JTF_VARCHAR2_TABLE_2000
2171 , p5_a15 JTF_VARCHAR2_TABLE_100
2172 , p5_a16 JTF_VARCHAR2_TABLE_100
2173 , p5_a17 JTF_DATE_TABLE
2174 , p5_a18 JTF_DATE_TABLE
2175 , p5_a19 JTF_VARCHAR2_TABLE_100
2176 , p5_a20 JTF_VARCHAR2_TABLE_100
2177 , p5_a21 JTF_VARCHAR2_TABLE_500
2178 , p5_a22 JTF_VARCHAR2_TABLE_500
2179 , p5_a23 JTF_VARCHAR2_TABLE_500
2180 , p5_a24 JTF_VARCHAR2_TABLE_500
2181 , p5_a25 JTF_VARCHAR2_TABLE_500
2182 , p5_a26 JTF_VARCHAR2_TABLE_500
2183 , p5_a27 JTF_VARCHAR2_TABLE_500
2184 , p5_a28 JTF_VARCHAR2_TABLE_500
2185 , p5_a29 JTF_VARCHAR2_TABLE_500
2186 , p5_a30 JTF_VARCHAR2_TABLE_500
2187 , p5_a31 JTF_VARCHAR2_TABLE_500
2188 , p5_a32 JTF_VARCHAR2_TABLE_500
2189 , p5_a33 JTF_VARCHAR2_TABLE_500
2190 , p5_a34 JTF_VARCHAR2_TABLE_500
2191 , p5_a35 JTF_VARCHAR2_TABLE_500
2192 , p5_a36 JTF_NUMBER_TABLE
2193 , p5_a37 JTF_NUMBER_TABLE
2194 , p5_a38 JTF_DATE_TABLE
2195 , p5_a39 JTF_NUMBER_TABLE
2196 , p5_a40 JTF_DATE_TABLE
2197 , p5_a41 JTF_NUMBER_TABLE
2198 , p5_a42 JTF_VARCHAR2_TABLE_100
2199 )
2200
2201 as
2202 ddp_avlv_tbl okl_avl_pvt.avlv_tbl_type;
2203 ddindx binary_integer; indx binary_integer;
2204 begin
2205
2206 -- copy data to the local IN or IN-OUT args, if any
2207
2208
2209
2210
2211
2212 okl_avl_pvt_w.rosetta_table_copy_in_p5(ddp_avlv_tbl, p5_a0
2213 , p5_a1
2214 , p5_a2
2215 , p5_a3
2216 , p5_a4
2217 , p5_a5
2218 , p5_a6
2219 , p5_a7
2220 , p5_a8
2221 , p5_a9
2222 , p5_a10
2223 , p5_a11
2224 , p5_a12
2225 , p5_a13
2226 , p5_a14
2227 , p5_a15
2228 , p5_a16
2229 , p5_a17
2230 , p5_a18
2231 , p5_a19
2232 , p5_a20
2233 , p5_a21
2234 , p5_a22
2235 , p5_a23
2236 , p5_a24
2237 , p5_a25
2238 , p5_a26
2239 , p5_a27
2240 , p5_a28
2241 , p5_a29
2242 , p5_a30
2243 , p5_a31
2244 , p5_a32
2245 , p5_a33
2246 , p5_a34
2247 , p5_a35
2248 , p5_a36
2249 , p5_a37
2250 , p5_a38
2251 , p5_a39
2252 , p5_a40
2253 , p5_a41
2254 , p5_a42
2255 );
2256
2257 -- here's the delegated call to the old PL/SQL routine
2258 okl_avl_pvt.validate_row(p_api_version,
2259 p_init_msg_list,
2260 x_return_status,
2261 x_msg_count,
2262 x_msg_data,
2263 ddp_avlv_tbl);
2264
2265 -- copy data back from the local variables to OUT or IN-OUT args, if any
2266
2267
2268
2269
2270
2271 end;
2272
2273 end okl_avl_pvt_w;