[Home] [Help]
PACKAGE BODY: APPS.OKL_TAI_PVT_W
Source
1 package body okl_tai_pvt_w as
2 /* $Header: OKLITAIB.pls 120.8 2007/11/06 14:13:41 veramach ship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5 rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');
6 rosetta_g_mistake_date_low date := to_date('01/01/-4710', 'MM/DD/SYYYY');
7
8 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9 function rosetta_g_miss_date_in_map(d date) return date as
10 begin
11 if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12 if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13 return d;
14 end;
15
16 function rosetta_g_miss_num_map(n number) return number as
17 a number := fnd_api.g_miss_num;
18 b number := 0-1962.0724;
19 begin
20 if n=a then return b; end if;
21 if n=b then return a; end if;
22 return n;
23 end;
24
25 procedure rosetta_table_copy_in_p2(t out nocopy okl_tai_pvt.tai_tbl_type, a0 JTF_NUMBER_TABLE
26 , a1 JTF_VARCHAR2_TABLE_100
27 , a2 JTF_VARCHAR2_TABLE_100
28 , a3 JTF_NUMBER_TABLE
29 , a4 JTF_DATE_TABLE
30 , a5 JTF_NUMBER_TABLE
31 , a6 JTF_NUMBER_TABLE
32 , a7 JTF_NUMBER_TABLE
33 , a8 JTF_NUMBER_TABLE
34 , a9 JTF_NUMBER_TABLE
35 , a10 JTF_NUMBER_TABLE
36 , a11 JTF_NUMBER_TABLE
37 , a12 JTF_NUMBER_TABLE
38 , a13 JTF_NUMBER_TABLE
39 , a14 JTF_NUMBER_TABLE
40 , a15 JTF_NUMBER_TABLE
41 , a16 JTF_NUMBER_TABLE
42 , a17 JTF_VARCHAR2_TABLE_100
43 , a18 JTF_NUMBER_TABLE
44 , a19 JTF_NUMBER_TABLE
45 , a20 JTF_DATE_TABLE
46 , a21 JTF_DATE_TABLE
47 , a22 JTF_NUMBER_TABLE
48 , a23 JTF_NUMBER_TABLE
49 , a24 JTF_NUMBER_TABLE
50 , a25 JTF_NUMBER_TABLE
51 , a26 JTF_NUMBER_TABLE
52 , a27 JTF_NUMBER_TABLE
53 , a28 JTF_DATE_TABLE
54 , a29 JTF_NUMBER_TABLE
55 , a30 JTF_VARCHAR2_TABLE_300
56 , a31 JTF_NUMBER_TABLE
57 , a32 JTF_NUMBER_TABLE
58 , a33 JTF_NUMBER_TABLE
59 , a34 JTF_VARCHAR2_TABLE_100
60 , a35 JTF_VARCHAR2_TABLE_500
61 , a36 JTF_VARCHAR2_TABLE_500
62 , a37 JTF_VARCHAR2_TABLE_500
63 , a38 JTF_VARCHAR2_TABLE_500
64 , a39 JTF_VARCHAR2_TABLE_500
65 , a40 JTF_VARCHAR2_TABLE_500
66 , a41 JTF_VARCHAR2_TABLE_500
67 , a42 JTF_VARCHAR2_TABLE_500
68 , a43 JTF_VARCHAR2_TABLE_500
69 , a44 JTF_VARCHAR2_TABLE_500
70 , a45 JTF_VARCHAR2_TABLE_500
71 , a46 JTF_VARCHAR2_TABLE_500
72 , a47 JTF_VARCHAR2_TABLE_500
73 , a48 JTF_VARCHAR2_TABLE_500
74 , a49 JTF_VARCHAR2_TABLE_500
75 , a50 JTF_NUMBER_TABLE
76 , a51 JTF_DATE_TABLE
77 , a52 JTF_NUMBER_TABLE
78 , a53 JTF_DATE_TABLE
79 , a54 JTF_NUMBER_TABLE
80 , a55 JTF_NUMBER_TABLE
81 , a56 JTF_VARCHAR2_TABLE_200
82 , a57 JTF_VARCHAR2_TABLE_400
83 , a58 JTF_VARCHAR2_TABLE_100
84 , a59 JTF_NUMBER_TABLE
85 , a60 JTF_VARCHAR2_TABLE_100
86 , a61 JTF_VARCHAR2_TABLE_100
87 , a62 JTF_DATE_TABLE
88 , a63 JTF_NUMBER_TABLE
89 , a64 JTF_NUMBER_TABLE
90 , a65 JTF_NUMBER_TABLE
91 , a66 JTF_NUMBER_TABLE
92 , a67 JTF_VARCHAR2_TABLE_100
93 , a68 JTF_VARCHAR2_TABLE_100
94 , a69 JTF_NUMBER_TABLE
95 , a70 JTF_VARCHAR2_TABLE_4000
96 , a71 JTF_DATE_TABLE
97 ) as
98 ddindx binary_integer; indx binary_integer;
99 begin
100 if a0 is not null and a0.count > 0 then
101 if a0.count > 0 then
102 indx := a0.first;
103 ddindx := 1;
104 while true loop
105 t(ddindx).id := rosetta_g_miss_num_map(a0(indx));
106 t(ddindx).currency_code := a1(indx);
107 t(ddindx).currency_conversion_type := a2(indx);
108 t(ddindx).currency_conversion_rate := rosetta_g_miss_num_map(a3(indx));
109 t(ddindx).currency_conversion_date := rosetta_g_miss_date_in_map(a4(indx));
110 t(ddindx).ibt_id := rosetta_g_miss_num_map(a5(indx));
111 t(ddindx).ixx_id := rosetta_g_miss_num_map(a6(indx));
112 t(ddindx).khr_id := rosetta_g_miss_num_map(a7(indx));
113 t(ddindx).irm_id := rosetta_g_miss_num_map(a8(indx));
114 t(ddindx).irt_id := rosetta_g_miss_num_map(a9(indx));
115 t(ddindx).cra_id := rosetta_g_miss_num_map(a10(indx));
116 t(ddindx).svf_id := rosetta_g_miss_num_map(a11(indx));
117 t(ddindx).tap_id := rosetta_g_miss_num_map(a12(indx));
118 t(ddindx).qte_id := rosetta_g_miss_num_map(a13(indx));
119 t(ddindx).tcn_id := rosetta_g_miss_num_map(a14(indx));
120 t(ddindx).tai_id_reverses := rosetta_g_miss_num_map(a15(indx));
121 t(ddindx).ipy_id := rosetta_g_miss_num_map(a16(indx));
122 t(ddindx).trx_status_code := a17(indx);
123 t(ddindx).set_of_books_id := rosetta_g_miss_num_map(a18(indx));
124 t(ddindx).try_id := rosetta_g_miss_num_map(a19(indx));
125 t(ddindx).date_entered := rosetta_g_miss_date_in_map(a20(indx));
126 t(ddindx).date_invoiced := rosetta_g_miss_date_in_map(a21(indx));
127 t(ddindx).amount := rosetta_g_miss_num_map(a22(indx));
128 t(ddindx).object_version_number := rosetta_g_miss_num_map(a23(indx));
129 t(ddindx).amount_applied := rosetta_g_miss_num_map(a24(indx));
130 t(ddindx).request_id := rosetta_g_miss_num_map(a25(indx));
131 t(ddindx).program_application_id := rosetta_g_miss_num_map(a26(indx));
132 t(ddindx).program_id := rosetta_g_miss_num_map(a27(indx));
133 t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a28(indx));
134 t(ddindx).org_id := rosetta_g_miss_num_map(a29(indx));
135 t(ddindx).trx_number := a30(indx);
136 t(ddindx).clg_id := rosetta_g_miss_num_map(a31(indx));
137 t(ddindx).pox_id := rosetta_g_miss_num_map(a32(indx));
138 t(ddindx).cpy_id := rosetta_g_miss_num_map(a33(indx));
139 t(ddindx).attribute_category := a34(indx);
140 t(ddindx).attribute1 := a35(indx);
141 t(ddindx).attribute2 := a36(indx);
142 t(ddindx).attribute3 := a37(indx);
143 t(ddindx).attribute4 := a38(indx);
144 t(ddindx).attribute5 := a39(indx);
145 t(ddindx).attribute6 := a40(indx);
146 t(ddindx).attribute7 := a41(indx);
147 t(ddindx).attribute8 := a42(indx);
148 t(ddindx).attribute9 := a43(indx);
149 t(ddindx).attribute10 := a44(indx);
150 t(ddindx).attribute11 := a45(indx);
151 t(ddindx).attribute12 := a46(indx);
152 t(ddindx).attribute13 := a47(indx);
153 t(ddindx).attribute14 := a48(indx);
154 t(ddindx).attribute15 := a49(indx);
155 t(ddindx).created_by := rosetta_g_miss_num_map(a50(indx));
156 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a51(indx));
157 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a52(indx));
158 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a53(indx));
159 t(ddindx).last_update_login := rosetta_g_miss_num_map(a54(indx));
160 t(ddindx).legal_entity_id := rosetta_g_miss_num_map(a55(indx));
161 t(ddindx).investor_agreement_number := a56(indx);
162 t(ddindx).investor_name := a57(indx);
163 t(ddindx).okl_source_billing_trx := a58(indx);
164 t(ddindx).inf_id := rosetta_g_miss_num_map(a59(indx));
165 t(ddindx).invoice_pull_yn := a60(indx);
166 t(ddindx).consolidated_invoice_number := a61(indx);
167 t(ddindx).due_date := rosetta_g_miss_date_in_map(a62(indx));
168 t(ddindx).isi_id := rosetta_g_miss_num_map(a63(indx));
169 t(ddindx).receivables_invoice_id := rosetta_g_miss_num_map(a64(indx));
170 t(ddindx).cust_trx_type_id := rosetta_g_miss_num_map(a65(indx));
171 t(ddindx).customer_bank_account_id := rosetta_g_miss_num_map(a66(indx));
172 t(ddindx).tax_exempt_flag := a67(indx);
173 t(ddindx).tax_exempt_reason_code := a68(indx);
174 t(ddindx).reference_line_id := rosetta_g_miss_num_map(a69(indx));
175 t(ddindx).private_label := a70(indx);
176 t(ddindx).transaction_date := rosetta_g_miss_date_in_map(a71(indx));
177 ddindx := ddindx+1;
178 if a0.last =indx
179 then exit;
180 end if;
181 indx := a0.next(indx);
182 end loop;
183 end if;
184 end if;
185 end rosetta_table_copy_in_p2;
186 procedure rosetta_table_copy_out_p2(t okl_tai_pvt.tai_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
187 , a1 out nocopy JTF_VARCHAR2_TABLE_100
188 , a2 out nocopy JTF_VARCHAR2_TABLE_100
189 , a3 out nocopy JTF_NUMBER_TABLE
190 , a4 out nocopy JTF_DATE_TABLE
191 , a5 out nocopy JTF_NUMBER_TABLE
192 , a6 out nocopy JTF_NUMBER_TABLE
193 , a7 out nocopy JTF_NUMBER_TABLE
194 , a8 out nocopy JTF_NUMBER_TABLE
195 , a9 out nocopy JTF_NUMBER_TABLE
196 , a10 out nocopy JTF_NUMBER_TABLE
197 , a11 out nocopy JTF_NUMBER_TABLE
198 , a12 out nocopy JTF_NUMBER_TABLE
199 , a13 out nocopy JTF_NUMBER_TABLE
200 , a14 out nocopy JTF_NUMBER_TABLE
201 , a15 out nocopy JTF_NUMBER_TABLE
202 , a16 out nocopy JTF_NUMBER_TABLE
203 , a17 out nocopy JTF_VARCHAR2_TABLE_100
204 , a18 out nocopy JTF_NUMBER_TABLE
205 , a19 out nocopy JTF_NUMBER_TABLE
206 , a20 out nocopy JTF_DATE_TABLE
207 , a21 out nocopy JTF_DATE_TABLE
208 , a22 out nocopy JTF_NUMBER_TABLE
209 , a23 out nocopy JTF_NUMBER_TABLE
210 , a24 out nocopy JTF_NUMBER_TABLE
211 , a25 out nocopy JTF_NUMBER_TABLE
212 , a26 out nocopy JTF_NUMBER_TABLE
213 , a27 out nocopy JTF_NUMBER_TABLE
214 , a28 out nocopy JTF_DATE_TABLE
215 , a29 out nocopy JTF_NUMBER_TABLE
216 , a30 out nocopy JTF_VARCHAR2_TABLE_300
217 , a31 out nocopy JTF_NUMBER_TABLE
218 , a32 out nocopy JTF_NUMBER_TABLE
219 , a33 out nocopy JTF_NUMBER_TABLE
220 , a34 out nocopy JTF_VARCHAR2_TABLE_100
221 , a35 out nocopy JTF_VARCHAR2_TABLE_500
222 , a36 out nocopy JTF_VARCHAR2_TABLE_500
223 , a37 out nocopy JTF_VARCHAR2_TABLE_500
224 , a38 out nocopy JTF_VARCHAR2_TABLE_500
225 , a39 out nocopy JTF_VARCHAR2_TABLE_500
226 , a40 out nocopy JTF_VARCHAR2_TABLE_500
227 , a41 out nocopy JTF_VARCHAR2_TABLE_500
228 , a42 out nocopy JTF_VARCHAR2_TABLE_500
229 , a43 out nocopy JTF_VARCHAR2_TABLE_500
230 , a44 out nocopy JTF_VARCHAR2_TABLE_500
231 , a45 out nocopy JTF_VARCHAR2_TABLE_500
232 , a46 out nocopy JTF_VARCHAR2_TABLE_500
233 , a47 out nocopy JTF_VARCHAR2_TABLE_500
234 , a48 out nocopy JTF_VARCHAR2_TABLE_500
235 , a49 out nocopy JTF_VARCHAR2_TABLE_500
236 , a50 out nocopy JTF_NUMBER_TABLE
237 , a51 out nocopy JTF_DATE_TABLE
238 , a52 out nocopy JTF_NUMBER_TABLE
239 , a53 out nocopy JTF_DATE_TABLE
240 , a54 out nocopy JTF_NUMBER_TABLE
241 , a55 out nocopy JTF_NUMBER_TABLE
242 , a56 out nocopy JTF_VARCHAR2_TABLE_200
243 , a57 out nocopy JTF_VARCHAR2_TABLE_400
244 , a58 out nocopy JTF_VARCHAR2_TABLE_100
245 , a59 out nocopy JTF_NUMBER_TABLE
246 , a60 out nocopy JTF_VARCHAR2_TABLE_100
247 , a61 out nocopy JTF_VARCHAR2_TABLE_100
248 , a62 out nocopy JTF_DATE_TABLE
249 , a63 out nocopy JTF_NUMBER_TABLE
250 , a64 out nocopy JTF_NUMBER_TABLE
251 , a65 out nocopy JTF_NUMBER_TABLE
252 , a66 out nocopy JTF_NUMBER_TABLE
253 , a67 out nocopy JTF_VARCHAR2_TABLE_100
254 , a68 out nocopy JTF_VARCHAR2_TABLE_100
255 , a69 out nocopy JTF_NUMBER_TABLE
256 , a70 out nocopy JTF_VARCHAR2_TABLE_4000
257 , a71 out nocopy JTF_DATE_TABLE
258 ) as
259 ddindx binary_integer; indx binary_integer;
260 begin
261 if t is null or t.count = 0 then
262 a0 := JTF_NUMBER_TABLE();
263 a1 := JTF_VARCHAR2_TABLE_100();
264 a2 := JTF_VARCHAR2_TABLE_100();
265 a3 := JTF_NUMBER_TABLE();
266 a4 := JTF_DATE_TABLE();
267 a5 := JTF_NUMBER_TABLE();
268 a6 := JTF_NUMBER_TABLE();
269 a7 := JTF_NUMBER_TABLE();
270 a8 := JTF_NUMBER_TABLE();
271 a9 := JTF_NUMBER_TABLE();
272 a10 := JTF_NUMBER_TABLE();
273 a11 := JTF_NUMBER_TABLE();
274 a12 := JTF_NUMBER_TABLE();
275 a13 := JTF_NUMBER_TABLE();
276 a14 := JTF_NUMBER_TABLE();
277 a15 := JTF_NUMBER_TABLE();
278 a16 := JTF_NUMBER_TABLE();
279 a17 := JTF_VARCHAR2_TABLE_100();
280 a18 := JTF_NUMBER_TABLE();
281 a19 := JTF_NUMBER_TABLE();
282 a20 := JTF_DATE_TABLE();
283 a21 := JTF_DATE_TABLE();
284 a22 := JTF_NUMBER_TABLE();
285 a23 := JTF_NUMBER_TABLE();
286 a24 := JTF_NUMBER_TABLE();
287 a25 := JTF_NUMBER_TABLE();
288 a26 := JTF_NUMBER_TABLE();
289 a27 := JTF_NUMBER_TABLE();
290 a28 := JTF_DATE_TABLE();
291 a29 := JTF_NUMBER_TABLE();
292 a30 := JTF_VARCHAR2_TABLE_300();
293 a31 := JTF_NUMBER_TABLE();
294 a32 := JTF_NUMBER_TABLE();
295 a33 := JTF_NUMBER_TABLE();
296 a34 := JTF_VARCHAR2_TABLE_100();
297 a35 := JTF_VARCHAR2_TABLE_500();
298 a36 := JTF_VARCHAR2_TABLE_500();
299 a37 := JTF_VARCHAR2_TABLE_500();
300 a38 := JTF_VARCHAR2_TABLE_500();
301 a39 := JTF_VARCHAR2_TABLE_500();
302 a40 := JTF_VARCHAR2_TABLE_500();
303 a41 := JTF_VARCHAR2_TABLE_500();
304 a42 := JTF_VARCHAR2_TABLE_500();
305 a43 := JTF_VARCHAR2_TABLE_500();
306 a44 := JTF_VARCHAR2_TABLE_500();
307 a45 := JTF_VARCHAR2_TABLE_500();
308 a46 := JTF_VARCHAR2_TABLE_500();
309 a47 := JTF_VARCHAR2_TABLE_500();
310 a48 := JTF_VARCHAR2_TABLE_500();
311 a49 := JTF_VARCHAR2_TABLE_500();
312 a50 := JTF_NUMBER_TABLE();
313 a51 := JTF_DATE_TABLE();
314 a52 := JTF_NUMBER_TABLE();
315 a53 := JTF_DATE_TABLE();
316 a54 := JTF_NUMBER_TABLE();
317 a55 := JTF_NUMBER_TABLE();
318 a56 := JTF_VARCHAR2_TABLE_200();
319 a57 := JTF_VARCHAR2_TABLE_400();
320 a58 := JTF_VARCHAR2_TABLE_100();
321 a59 := JTF_NUMBER_TABLE();
322 a60 := JTF_VARCHAR2_TABLE_100();
323 a61 := JTF_VARCHAR2_TABLE_100();
324 a62 := JTF_DATE_TABLE();
325 a63 := JTF_NUMBER_TABLE();
326 a64 := JTF_NUMBER_TABLE();
327 a65 := JTF_NUMBER_TABLE();
328 a66 := JTF_NUMBER_TABLE();
329 a67 := JTF_VARCHAR2_TABLE_100();
330 a68 := JTF_VARCHAR2_TABLE_100();
331 a69 := JTF_NUMBER_TABLE();
332 a70 := JTF_VARCHAR2_TABLE_4000();
333 a71 := JTF_DATE_TABLE();
334 else
335 a0 := JTF_NUMBER_TABLE();
336 a1 := JTF_VARCHAR2_TABLE_100();
337 a2 := JTF_VARCHAR2_TABLE_100();
338 a3 := JTF_NUMBER_TABLE();
339 a4 := JTF_DATE_TABLE();
340 a5 := JTF_NUMBER_TABLE();
341 a6 := JTF_NUMBER_TABLE();
342 a7 := JTF_NUMBER_TABLE();
343 a8 := JTF_NUMBER_TABLE();
344 a9 := JTF_NUMBER_TABLE();
345 a10 := JTF_NUMBER_TABLE();
346 a11 := JTF_NUMBER_TABLE();
347 a12 := JTF_NUMBER_TABLE();
348 a13 := JTF_NUMBER_TABLE();
349 a14 := JTF_NUMBER_TABLE();
350 a15 := JTF_NUMBER_TABLE();
351 a16 := JTF_NUMBER_TABLE();
352 a17 := JTF_VARCHAR2_TABLE_100();
353 a18 := JTF_NUMBER_TABLE();
354 a19 := JTF_NUMBER_TABLE();
355 a20 := JTF_DATE_TABLE();
356 a21 := JTF_DATE_TABLE();
357 a22 := JTF_NUMBER_TABLE();
358 a23 := JTF_NUMBER_TABLE();
359 a24 := JTF_NUMBER_TABLE();
360 a25 := JTF_NUMBER_TABLE();
361 a26 := JTF_NUMBER_TABLE();
362 a27 := JTF_NUMBER_TABLE();
363 a28 := JTF_DATE_TABLE();
364 a29 := JTF_NUMBER_TABLE();
365 a30 := JTF_VARCHAR2_TABLE_300();
366 a31 := JTF_NUMBER_TABLE();
367 a32 := JTF_NUMBER_TABLE();
368 a33 := JTF_NUMBER_TABLE();
369 a34 := JTF_VARCHAR2_TABLE_100();
370 a35 := JTF_VARCHAR2_TABLE_500();
371 a36 := JTF_VARCHAR2_TABLE_500();
372 a37 := JTF_VARCHAR2_TABLE_500();
373 a38 := JTF_VARCHAR2_TABLE_500();
374 a39 := JTF_VARCHAR2_TABLE_500();
375 a40 := JTF_VARCHAR2_TABLE_500();
376 a41 := JTF_VARCHAR2_TABLE_500();
377 a42 := JTF_VARCHAR2_TABLE_500();
378 a43 := JTF_VARCHAR2_TABLE_500();
379 a44 := JTF_VARCHAR2_TABLE_500();
380 a45 := JTF_VARCHAR2_TABLE_500();
381 a46 := JTF_VARCHAR2_TABLE_500();
382 a47 := JTF_VARCHAR2_TABLE_500();
383 a48 := JTF_VARCHAR2_TABLE_500();
384 a49 := JTF_VARCHAR2_TABLE_500();
385 a50 := JTF_NUMBER_TABLE();
386 a51 := JTF_DATE_TABLE();
387 a52 := JTF_NUMBER_TABLE();
388 a53 := JTF_DATE_TABLE();
389 a54 := JTF_NUMBER_TABLE();
390 a55 := JTF_NUMBER_TABLE();
391 a56 := JTF_VARCHAR2_TABLE_200();
392 a57 := JTF_VARCHAR2_TABLE_400();
393 a58 := JTF_VARCHAR2_TABLE_100();
394 a59 := JTF_NUMBER_TABLE();
395 a60 := JTF_VARCHAR2_TABLE_100();
396 a61 := JTF_VARCHAR2_TABLE_100();
397 a62 := JTF_DATE_TABLE();
398 a63 := JTF_NUMBER_TABLE();
399 a64 := JTF_NUMBER_TABLE();
400 a65 := JTF_NUMBER_TABLE();
401 a66 := JTF_NUMBER_TABLE();
402 a67 := JTF_VARCHAR2_TABLE_100();
403 a68 := JTF_VARCHAR2_TABLE_100();
404 a69 := JTF_NUMBER_TABLE();
405 a70 := JTF_VARCHAR2_TABLE_4000();
406 a71 := JTF_DATE_TABLE();
407 if t.count > 0 then
408 a0.extend(t.count);
409 a1.extend(t.count);
410 a2.extend(t.count);
411 a3.extend(t.count);
412 a4.extend(t.count);
413 a5.extend(t.count);
414 a6.extend(t.count);
415 a7.extend(t.count);
416 a8.extend(t.count);
417 a9.extend(t.count);
418 a10.extend(t.count);
419 a11.extend(t.count);
420 a12.extend(t.count);
421 a13.extend(t.count);
422 a14.extend(t.count);
423 a15.extend(t.count);
424 a16.extend(t.count);
425 a17.extend(t.count);
426 a18.extend(t.count);
427 a19.extend(t.count);
428 a20.extend(t.count);
429 a21.extend(t.count);
430 a22.extend(t.count);
431 a23.extend(t.count);
432 a24.extend(t.count);
433 a25.extend(t.count);
434 a26.extend(t.count);
435 a27.extend(t.count);
436 a28.extend(t.count);
437 a29.extend(t.count);
438 a30.extend(t.count);
439 a31.extend(t.count);
440 a32.extend(t.count);
441 a33.extend(t.count);
442 a34.extend(t.count);
443 a35.extend(t.count);
444 a36.extend(t.count);
445 a37.extend(t.count);
446 a38.extend(t.count);
447 a39.extend(t.count);
448 a40.extend(t.count);
449 a41.extend(t.count);
450 a42.extend(t.count);
451 a43.extend(t.count);
452 a44.extend(t.count);
453 a45.extend(t.count);
454 a46.extend(t.count);
455 a47.extend(t.count);
456 a48.extend(t.count);
457 a49.extend(t.count);
458 a50.extend(t.count);
459 a51.extend(t.count);
460 a52.extend(t.count);
461 a53.extend(t.count);
462 a54.extend(t.count);
463 a55.extend(t.count);
464 a56.extend(t.count);
465 a57.extend(t.count);
466 a58.extend(t.count);
467 a59.extend(t.count);
468 a60.extend(t.count);
469 a61.extend(t.count);
470 a62.extend(t.count);
471 a63.extend(t.count);
472 a64.extend(t.count);
473 a65.extend(t.count);
474 a66.extend(t.count);
475 a67.extend(t.count);
476 a68.extend(t.count);
477 a69.extend(t.count);
478 a70.extend(t.count);
479 a71.extend(t.count);
480 ddindx := t.first;
481 indx := 1;
482 while true loop
483 a0(indx) := rosetta_g_miss_num_map(t(ddindx).id);
484 a1(indx) := t(ddindx).currency_code;
485 a2(indx) := t(ddindx).currency_conversion_type;
486 a3(indx) := rosetta_g_miss_num_map(t(ddindx).currency_conversion_rate);
487 a4(indx) := t(ddindx).currency_conversion_date;
488 a5(indx) := rosetta_g_miss_num_map(t(ddindx).ibt_id);
489 a6(indx) := rosetta_g_miss_num_map(t(ddindx).ixx_id);
490 a7(indx) := rosetta_g_miss_num_map(t(ddindx).khr_id);
491 a8(indx) := rosetta_g_miss_num_map(t(ddindx).irm_id);
492 a9(indx) := rosetta_g_miss_num_map(t(ddindx).irt_id);
493 a10(indx) := rosetta_g_miss_num_map(t(ddindx).cra_id);
494 a11(indx) := rosetta_g_miss_num_map(t(ddindx).svf_id);
495 a12(indx) := rosetta_g_miss_num_map(t(ddindx).tap_id);
496 a13(indx) := rosetta_g_miss_num_map(t(ddindx).qte_id);
497 a14(indx) := rosetta_g_miss_num_map(t(ddindx).tcn_id);
498 a15(indx) := rosetta_g_miss_num_map(t(ddindx).tai_id_reverses);
499 a16(indx) := rosetta_g_miss_num_map(t(ddindx).ipy_id);
500 a17(indx) := t(ddindx).trx_status_code;
501 a18(indx) := rosetta_g_miss_num_map(t(ddindx).set_of_books_id);
502 a19(indx) := rosetta_g_miss_num_map(t(ddindx).try_id);
503 a20(indx) := t(ddindx).date_entered;
504 a21(indx) := t(ddindx).date_invoiced;
505 a22(indx) := rosetta_g_miss_num_map(t(ddindx).amount);
506 a23(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
507 a24(indx) := rosetta_g_miss_num_map(t(ddindx).amount_applied);
508 a25(indx) := rosetta_g_miss_num_map(t(ddindx).request_id);
509 a26(indx) := rosetta_g_miss_num_map(t(ddindx).program_application_id);
510 a27(indx) := rosetta_g_miss_num_map(t(ddindx).program_id);
511 a28(indx) := t(ddindx).program_update_date;
512 a29(indx) := rosetta_g_miss_num_map(t(ddindx).org_id);
513 a30(indx) := t(ddindx).trx_number;
514 a31(indx) := rosetta_g_miss_num_map(t(ddindx).clg_id);
515 a32(indx) := rosetta_g_miss_num_map(t(ddindx).pox_id);
516 a33(indx) := rosetta_g_miss_num_map(t(ddindx).cpy_id);
517 a34(indx) := t(ddindx).attribute_category;
518 a35(indx) := t(ddindx).attribute1;
519 a36(indx) := t(ddindx).attribute2;
520 a37(indx) := t(ddindx).attribute3;
521 a38(indx) := t(ddindx).attribute4;
522 a39(indx) := t(ddindx).attribute5;
523 a40(indx) := t(ddindx).attribute6;
524 a41(indx) := t(ddindx).attribute7;
525 a42(indx) := t(ddindx).attribute8;
526 a43(indx) := t(ddindx).attribute9;
527 a44(indx) := t(ddindx).attribute10;
528 a45(indx) := t(ddindx).attribute11;
529 a46(indx) := t(ddindx).attribute12;
530 a47(indx) := t(ddindx).attribute13;
531 a48(indx) := t(ddindx).attribute14;
532 a49(indx) := t(ddindx).attribute15;
533 a50(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
534 a51(indx) := t(ddindx).creation_date;
535 a52(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
536 a53(indx) := t(ddindx).last_update_date;
537 a54(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
538 a55(indx) := rosetta_g_miss_num_map(t(ddindx).legal_entity_id);
539 a56(indx) := t(ddindx).investor_agreement_number;
540 a57(indx) := t(ddindx).investor_name;
541 a58(indx) := t(ddindx).okl_source_billing_trx;
542 a59(indx) := rosetta_g_miss_num_map(t(ddindx).inf_id);
543 a60(indx) := t(ddindx).invoice_pull_yn;
544 a61(indx) := t(ddindx).consolidated_invoice_number;
545 a62(indx) := t(ddindx).due_date;
546 a63(indx) := rosetta_g_miss_num_map(t(ddindx).isi_id);
547 a64(indx) := rosetta_g_miss_num_map(t(ddindx).receivables_invoice_id);
548 a65(indx) := rosetta_g_miss_num_map(t(ddindx).cust_trx_type_id);
549 a66(indx) := rosetta_g_miss_num_map(t(ddindx).customer_bank_account_id);
550 a67(indx) := t(ddindx).tax_exempt_flag;
551 a68(indx) := t(ddindx).tax_exempt_reason_code;
552 a69(indx) := rosetta_g_miss_num_map(t(ddindx).reference_line_id);
553 a70(indx) := t(ddindx).private_label;
554 a71(indx) := t(ddindx).transaction_date;
555 indx := indx+1;
556 if t.last =ddindx
557 then exit;
558 end if;
559 ddindx := t.next(ddindx);
560 end loop;
561 end if;
562 end if;
563 end rosetta_table_copy_out_p2;
564
565 procedure rosetta_table_copy_in_p5(t out nocopy okl_tai_pvt.okltrxarinvoicestltbltype, a0 JTF_NUMBER_TABLE
566 , a1 JTF_VARCHAR2_TABLE_100
567 , a2 JTF_VARCHAR2_TABLE_100
568 , a3 JTF_VARCHAR2_TABLE_100
569 , a4 JTF_VARCHAR2_TABLE_2000
570 , a5 JTF_NUMBER_TABLE
571 , a6 JTF_DATE_TABLE
572 , a7 JTF_NUMBER_TABLE
573 , a8 JTF_DATE_TABLE
574 , a9 JTF_NUMBER_TABLE
575 ) as
576 ddindx binary_integer; indx binary_integer;
577 begin
578 if a0 is not null and a0.count > 0 then
579 if a0.count > 0 then
580 indx := a0.first;
581 ddindx := 1;
582 while true loop
583 t(ddindx).id := rosetta_g_miss_num_map(a0(indx));
584 t(ddindx).language := a1(indx);
585 t(ddindx).source_lang := a2(indx);
586 t(ddindx).sfwt_flag := a3(indx);
587 t(ddindx).description := a4(indx);
588 t(ddindx).created_by := rosetta_g_miss_num_map(a5(indx));
589 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a6(indx));
590 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a7(indx));
591 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a8(indx));
592 t(ddindx).last_update_login := rosetta_g_miss_num_map(a9(indx));
593 ddindx := ddindx+1;
594 if a0.last =indx
595 then exit;
596 end if;
597 indx := a0.next(indx);
598 end loop;
599 end if;
600 end if;
601 end rosetta_table_copy_in_p5;
602 procedure rosetta_table_copy_out_p5(t okl_tai_pvt.okltrxarinvoicestltbltype, a0 out nocopy JTF_NUMBER_TABLE
603 , a1 out nocopy JTF_VARCHAR2_TABLE_100
604 , a2 out nocopy JTF_VARCHAR2_TABLE_100
605 , a3 out nocopy JTF_VARCHAR2_TABLE_100
606 , a4 out nocopy JTF_VARCHAR2_TABLE_2000
607 , a5 out nocopy JTF_NUMBER_TABLE
608 , a6 out nocopy JTF_DATE_TABLE
609 , a7 out nocopy JTF_NUMBER_TABLE
610 , a8 out nocopy JTF_DATE_TABLE
611 , a9 out nocopy JTF_NUMBER_TABLE
612 ) as
613 ddindx binary_integer; indx binary_integer;
614 begin
615 if t is null or t.count = 0 then
616 a0 := JTF_NUMBER_TABLE();
617 a1 := JTF_VARCHAR2_TABLE_100();
618 a2 := JTF_VARCHAR2_TABLE_100();
619 a3 := JTF_VARCHAR2_TABLE_100();
620 a4 := JTF_VARCHAR2_TABLE_2000();
621 a5 := JTF_NUMBER_TABLE();
622 a6 := JTF_DATE_TABLE();
623 a7 := JTF_NUMBER_TABLE();
624 a8 := JTF_DATE_TABLE();
625 a9 := JTF_NUMBER_TABLE();
626 else
627 a0 := JTF_NUMBER_TABLE();
628 a1 := JTF_VARCHAR2_TABLE_100();
629 a2 := JTF_VARCHAR2_TABLE_100();
630 a3 := JTF_VARCHAR2_TABLE_100();
631 a4 := JTF_VARCHAR2_TABLE_2000();
632 a5 := JTF_NUMBER_TABLE();
633 a6 := JTF_DATE_TABLE();
634 a7 := JTF_NUMBER_TABLE();
635 a8 := JTF_DATE_TABLE();
636 a9 := JTF_NUMBER_TABLE();
637 if t.count > 0 then
638 a0.extend(t.count);
639 a1.extend(t.count);
640 a2.extend(t.count);
641 a3.extend(t.count);
642 a4.extend(t.count);
643 a5.extend(t.count);
644 a6.extend(t.count);
645 a7.extend(t.count);
646 a8.extend(t.count);
647 a9.extend(t.count);
648 ddindx := t.first;
649 indx := 1;
650 while true loop
651 a0(indx) := rosetta_g_miss_num_map(t(ddindx).id);
652 a1(indx) := t(ddindx).language;
653 a2(indx) := t(ddindx).source_lang;
654 a3(indx) := t(ddindx).sfwt_flag;
655 a4(indx) := t(ddindx).description;
656 a5(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
657 a6(indx) := t(ddindx).creation_date;
658 a7(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
659 a8(indx) := t(ddindx).last_update_date;
660 a9(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
661 indx := indx+1;
662 if t.last =ddindx
663 then exit;
664 end if;
665 ddindx := t.next(ddindx);
666 end loop;
667 end if;
668 end if;
669 end rosetta_table_copy_out_p5;
670
671 procedure rosetta_table_copy_in_p8(t out nocopy okl_tai_pvt.taiv_tbl_type, a0 JTF_NUMBER_TABLE
672 , a1 JTF_NUMBER_TABLE
673 , a2 JTF_VARCHAR2_TABLE_100
674 , a3 JTF_VARCHAR2_TABLE_100
675 , a4 JTF_VARCHAR2_TABLE_100
676 , a5 JTF_NUMBER_TABLE
677 , a6 JTF_DATE_TABLE
678 , a7 JTF_NUMBER_TABLE
679 , a8 JTF_NUMBER_TABLE
680 , a9 JTF_NUMBER_TABLE
681 , a10 JTF_NUMBER_TABLE
682 , a11 JTF_NUMBER_TABLE
683 , a12 JTF_NUMBER_TABLE
684 , a13 JTF_NUMBER_TABLE
685 , a14 JTF_VARCHAR2_TABLE_100
686 , a15 JTF_NUMBER_TABLE
687 , a16 JTF_NUMBER_TABLE
688 , a17 JTF_NUMBER_TABLE
689 , a18 JTF_NUMBER_TABLE
690 , a19 JTF_NUMBER_TABLE
691 , a20 JTF_NUMBER_TABLE
692 , a21 JTF_NUMBER_TABLE
693 , a22 JTF_NUMBER_TABLE
694 , a23 JTF_DATE_TABLE
695 , a24 JTF_NUMBER_TABLE
696 , a25 JTF_VARCHAR2_TABLE_2000
697 , a26 JTF_VARCHAR2_TABLE_300
698 , a27 JTF_NUMBER_TABLE
699 , a28 JTF_NUMBER_TABLE
700 , a29 JTF_NUMBER_TABLE
701 , a30 JTF_VARCHAR2_TABLE_100
702 , a31 JTF_VARCHAR2_TABLE_500
703 , a32 JTF_VARCHAR2_TABLE_500
704 , a33 JTF_VARCHAR2_TABLE_500
705 , a34 JTF_VARCHAR2_TABLE_500
706 , a35 JTF_VARCHAR2_TABLE_500
707 , a36 JTF_VARCHAR2_TABLE_500
708 , a37 JTF_VARCHAR2_TABLE_500
709 , a38 JTF_VARCHAR2_TABLE_500
710 , a39 JTF_VARCHAR2_TABLE_500
711 , a40 JTF_VARCHAR2_TABLE_500
712 , a41 JTF_VARCHAR2_TABLE_500
713 , a42 JTF_VARCHAR2_TABLE_500
714 , a43 JTF_VARCHAR2_TABLE_500
715 , a44 JTF_VARCHAR2_TABLE_500
716 , a45 JTF_VARCHAR2_TABLE_500
717 , a46 JTF_DATE_TABLE
718 , a47 JTF_NUMBER_TABLE
719 , a48 JTF_NUMBER_TABLE
720 , a49 JTF_NUMBER_TABLE
721 , a50 JTF_DATE_TABLE
722 , a51 JTF_NUMBER_TABLE
723 , a52 JTF_NUMBER_TABLE
724 , a53 JTF_DATE_TABLE
725 , a54 JTF_NUMBER_TABLE
726 , a55 JTF_DATE_TABLE
727 , a56 JTF_NUMBER_TABLE
728 , a57 JTF_NUMBER_TABLE
729 , a58 JTF_VARCHAR2_TABLE_200
730 , a59 JTF_VARCHAR2_TABLE_400
731 , a60 JTF_VARCHAR2_TABLE_100
732 , a61 JTF_NUMBER_TABLE
733 , a62 JTF_VARCHAR2_TABLE_100
734 , a63 JTF_DATE_TABLE
735 , a64 JTF_VARCHAR2_TABLE_100
736 , a65 JTF_NUMBER_TABLE
737 , a66 JTF_NUMBER_TABLE
738 , a67 JTF_NUMBER_TABLE
739 , a68 JTF_NUMBER_TABLE
740 , a69 JTF_VARCHAR2_TABLE_100
741 , a70 JTF_VARCHAR2_TABLE_100
742 , a71 JTF_NUMBER_TABLE
743 , a72 JTF_VARCHAR2_TABLE_4000
744 , a73 JTF_DATE_TABLE
745 ) as
746 ddindx binary_integer; indx binary_integer;
747 begin
748 if a0 is not null and a0.count > 0 then
749 if a0.count > 0 then
750 indx := a0.first;
751 ddindx := 1;
752 while true loop
753 t(ddindx).id := rosetta_g_miss_num_map(a0(indx));
754 t(ddindx).object_version_number := rosetta_g_miss_num_map(a1(indx));
755 t(ddindx).sfwt_flag := a2(indx);
756 t(ddindx).currency_code := a3(indx);
757 t(ddindx).currency_conversion_type := a4(indx);
758 t(ddindx).currency_conversion_rate := rosetta_g_miss_num_map(a5(indx));
759 t(ddindx).currency_conversion_date := rosetta_g_miss_date_in_map(a6(indx));
760 t(ddindx).khr_id := rosetta_g_miss_num_map(a7(indx));
761 t(ddindx).cra_id := rosetta_g_miss_num_map(a8(indx));
762 t(ddindx).tap_id := rosetta_g_miss_num_map(a9(indx));
763 t(ddindx).qte_id := rosetta_g_miss_num_map(a10(indx));
764 t(ddindx).tcn_id := rosetta_g_miss_num_map(a11(indx));
765 t(ddindx).tai_id_reverses := rosetta_g_miss_num_map(a12(indx));
766 t(ddindx).ipy_id := rosetta_g_miss_num_map(a13(indx));
767 t(ddindx).trx_status_code := a14(indx);
768 t(ddindx).set_of_books_id := rosetta_g_miss_num_map(a15(indx));
769 t(ddindx).try_id := rosetta_g_miss_num_map(a16(indx));
770 t(ddindx).ibt_id := rosetta_g_miss_num_map(a17(indx));
771 t(ddindx).ixx_id := rosetta_g_miss_num_map(a18(indx));
772 t(ddindx).irm_id := rosetta_g_miss_num_map(a19(indx));
773 t(ddindx).irt_id := rosetta_g_miss_num_map(a20(indx));
774 t(ddindx).svf_id := rosetta_g_miss_num_map(a21(indx));
775 t(ddindx).amount := rosetta_g_miss_num_map(a22(indx));
776 t(ddindx).date_invoiced := rosetta_g_miss_date_in_map(a23(indx));
777 t(ddindx).amount_applied := rosetta_g_miss_num_map(a24(indx));
778 t(ddindx).description := a25(indx);
779 t(ddindx).trx_number := a26(indx);
780 t(ddindx).clg_id := rosetta_g_miss_num_map(a27(indx));
781 t(ddindx).pox_id := rosetta_g_miss_num_map(a28(indx));
782 t(ddindx).cpy_id := rosetta_g_miss_num_map(a29(indx));
783 t(ddindx).attribute_category := a30(indx);
784 t(ddindx).attribute1 := a31(indx);
785 t(ddindx).attribute2 := a32(indx);
786 t(ddindx).attribute3 := a33(indx);
787 t(ddindx).attribute4 := a34(indx);
788 t(ddindx).attribute5 := a35(indx);
789 t(ddindx).attribute6 := a36(indx);
790 t(ddindx).attribute7 := a37(indx);
791 t(ddindx).attribute8 := a38(indx);
792 t(ddindx).attribute9 := a39(indx);
793 t(ddindx).attribute10 := a40(indx);
794 t(ddindx).attribute11 := a41(indx);
795 t(ddindx).attribute12 := a42(indx);
796 t(ddindx).attribute13 := a43(indx);
797 t(ddindx).attribute14 := a44(indx);
798 t(ddindx).attribute15 := a45(indx);
799 t(ddindx).date_entered := rosetta_g_miss_date_in_map(a46(indx));
800 t(ddindx).request_id := rosetta_g_miss_num_map(a47(indx));
801 t(ddindx).program_application_id := rosetta_g_miss_num_map(a48(indx));
802 t(ddindx).program_id := rosetta_g_miss_num_map(a49(indx));
803 t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a50(indx));
804 t(ddindx).org_id := rosetta_g_miss_num_map(a51(indx));
805 t(ddindx).created_by := rosetta_g_miss_num_map(a52(indx));
806 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a53(indx));
807 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a54(indx));
808 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a55(indx));
809 t(ddindx).last_update_login := rosetta_g_miss_num_map(a56(indx));
810 t(ddindx).legal_entity_id := rosetta_g_miss_num_map(a57(indx));
811 t(ddindx).investor_agreement_number := a58(indx);
812 t(ddindx).investor_name := a59(indx);
813 t(ddindx).okl_source_billing_trx := a60(indx);
814 t(ddindx).inf_id := rosetta_g_miss_num_map(a61(indx));
815 t(ddindx).invoice_pull_yn := a62(indx);
816 t(ddindx).due_date := rosetta_g_miss_date_in_map(a63(indx));
817 t(ddindx).consolidated_invoice_number := a64(indx);
818 t(ddindx).isi_id := rosetta_g_miss_num_map(a65(indx));
819 t(ddindx).receivables_invoice_id := rosetta_g_miss_num_map(a66(indx));
820 t(ddindx).cust_trx_type_id := rosetta_g_miss_num_map(a67(indx));
821 t(ddindx).customer_bank_account_id := rosetta_g_miss_num_map(a68(indx));
822 t(ddindx).tax_exempt_flag := a69(indx);
823 t(ddindx).tax_exempt_reason_code := a70(indx);
824 t(ddindx).reference_line_id := rosetta_g_miss_num_map(a71(indx));
825 t(ddindx).private_label := a72(indx);
826 t(ddindx).transaction_date := rosetta_g_miss_date_in_map(a73(indx));
827 ddindx := ddindx+1;
828 if a0.last =indx
829 then exit;
830 end if;
831 indx := a0.next(indx);
832 end loop;
833 end if;
834 end if;
835 end rosetta_table_copy_in_p8;
836 procedure rosetta_table_copy_out_p8(t okl_tai_pvt.taiv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
837 , a1 out nocopy JTF_NUMBER_TABLE
838 , a2 out nocopy JTF_VARCHAR2_TABLE_100
839 , a3 out nocopy JTF_VARCHAR2_TABLE_100
840 , a4 out nocopy JTF_VARCHAR2_TABLE_100
841 , a5 out nocopy JTF_NUMBER_TABLE
842 , a6 out nocopy JTF_DATE_TABLE
843 , a7 out nocopy JTF_NUMBER_TABLE
844 , a8 out nocopy JTF_NUMBER_TABLE
845 , a9 out nocopy JTF_NUMBER_TABLE
846 , a10 out nocopy JTF_NUMBER_TABLE
847 , a11 out nocopy JTF_NUMBER_TABLE
848 , a12 out nocopy JTF_NUMBER_TABLE
849 , a13 out nocopy JTF_NUMBER_TABLE
850 , a14 out nocopy JTF_VARCHAR2_TABLE_100
851 , a15 out nocopy JTF_NUMBER_TABLE
852 , a16 out nocopy JTF_NUMBER_TABLE
853 , a17 out nocopy JTF_NUMBER_TABLE
854 , a18 out nocopy JTF_NUMBER_TABLE
855 , a19 out nocopy JTF_NUMBER_TABLE
856 , a20 out nocopy JTF_NUMBER_TABLE
857 , a21 out nocopy JTF_NUMBER_TABLE
858 , a22 out nocopy JTF_NUMBER_TABLE
859 , a23 out nocopy JTF_DATE_TABLE
860 , a24 out nocopy JTF_NUMBER_TABLE
861 , a25 out nocopy JTF_VARCHAR2_TABLE_2000
862 , a26 out nocopy JTF_VARCHAR2_TABLE_300
863 , a27 out nocopy JTF_NUMBER_TABLE
864 , a28 out nocopy JTF_NUMBER_TABLE
865 , a29 out nocopy JTF_NUMBER_TABLE
866 , a30 out nocopy JTF_VARCHAR2_TABLE_100
867 , a31 out nocopy JTF_VARCHAR2_TABLE_500
868 , a32 out nocopy JTF_VARCHAR2_TABLE_500
869 , a33 out nocopy JTF_VARCHAR2_TABLE_500
870 , a34 out nocopy JTF_VARCHAR2_TABLE_500
871 , a35 out nocopy JTF_VARCHAR2_TABLE_500
872 , a36 out nocopy JTF_VARCHAR2_TABLE_500
873 , a37 out nocopy JTF_VARCHAR2_TABLE_500
874 , a38 out nocopy JTF_VARCHAR2_TABLE_500
875 , a39 out nocopy JTF_VARCHAR2_TABLE_500
876 , a40 out nocopy JTF_VARCHAR2_TABLE_500
877 , a41 out nocopy JTF_VARCHAR2_TABLE_500
878 , a42 out nocopy JTF_VARCHAR2_TABLE_500
879 , a43 out nocopy JTF_VARCHAR2_TABLE_500
880 , a44 out nocopy JTF_VARCHAR2_TABLE_500
881 , a45 out nocopy JTF_VARCHAR2_TABLE_500
882 , a46 out nocopy JTF_DATE_TABLE
883 , a47 out nocopy JTF_NUMBER_TABLE
884 , a48 out nocopy JTF_NUMBER_TABLE
885 , a49 out nocopy JTF_NUMBER_TABLE
886 , a50 out nocopy JTF_DATE_TABLE
887 , a51 out nocopy JTF_NUMBER_TABLE
888 , a52 out nocopy JTF_NUMBER_TABLE
889 , a53 out nocopy JTF_DATE_TABLE
890 , a54 out nocopy JTF_NUMBER_TABLE
891 , a55 out nocopy JTF_DATE_TABLE
892 , a56 out nocopy JTF_NUMBER_TABLE
893 , a57 out nocopy JTF_NUMBER_TABLE
894 , a58 out nocopy JTF_VARCHAR2_TABLE_200
895 , a59 out nocopy JTF_VARCHAR2_TABLE_400
896 , a60 out nocopy JTF_VARCHAR2_TABLE_100
897 , a61 out nocopy JTF_NUMBER_TABLE
898 , a62 out nocopy JTF_VARCHAR2_TABLE_100
899 , a63 out nocopy JTF_DATE_TABLE
900 , a64 out nocopy JTF_VARCHAR2_TABLE_100
901 , a65 out nocopy JTF_NUMBER_TABLE
902 , a66 out nocopy JTF_NUMBER_TABLE
903 , a67 out nocopy JTF_NUMBER_TABLE
904 , a68 out nocopy JTF_NUMBER_TABLE
905 , a69 out nocopy JTF_VARCHAR2_TABLE_100
906 , a70 out nocopy JTF_VARCHAR2_TABLE_100
907 , a71 out nocopy JTF_NUMBER_TABLE
908 , a72 out nocopy JTF_VARCHAR2_TABLE_4000
909 , a73 out nocopy JTF_DATE_TABLE
910 ) as
911 ddindx binary_integer; indx binary_integer;
912 begin
913 if t is null or t.count = 0 then
914 a0 := JTF_NUMBER_TABLE();
915 a1 := JTF_NUMBER_TABLE();
916 a2 := JTF_VARCHAR2_TABLE_100();
917 a3 := JTF_VARCHAR2_TABLE_100();
918 a4 := JTF_VARCHAR2_TABLE_100();
919 a5 := JTF_NUMBER_TABLE();
920 a6 := JTF_DATE_TABLE();
921 a7 := JTF_NUMBER_TABLE();
922 a8 := JTF_NUMBER_TABLE();
923 a9 := JTF_NUMBER_TABLE();
924 a10 := JTF_NUMBER_TABLE();
925 a11 := JTF_NUMBER_TABLE();
926 a12 := JTF_NUMBER_TABLE();
927 a13 := JTF_NUMBER_TABLE();
928 a14 := JTF_VARCHAR2_TABLE_100();
929 a15 := JTF_NUMBER_TABLE();
930 a16 := JTF_NUMBER_TABLE();
931 a17 := JTF_NUMBER_TABLE();
932 a18 := JTF_NUMBER_TABLE();
933 a19 := JTF_NUMBER_TABLE();
934 a20 := JTF_NUMBER_TABLE();
935 a21 := JTF_NUMBER_TABLE();
936 a22 := JTF_NUMBER_TABLE();
937 a23 := JTF_DATE_TABLE();
938 a24 := JTF_NUMBER_TABLE();
939 a25 := JTF_VARCHAR2_TABLE_2000();
940 a26 := JTF_VARCHAR2_TABLE_300();
941 a27 := JTF_NUMBER_TABLE();
942 a28 := JTF_NUMBER_TABLE();
943 a29 := JTF_NUMBER_TABLE();
944 a30 := JTF_VARCHAR2_TABLE_100();
945 a31 := JTF_VARCHAR2_TABLE_500();
946 a32 := JTF_VARCHAR2_TABLE_500();
947 a33 := JTF_VARCHAR2_TABLE_500();
948 a34 := JTF_VARCHAR2_TABLE_500();
949 a35 := JTF_VARCHAR2_TABLE_500();
950 a36 := JTF_VARCHAR2_TABLE_500();
951 a37 := JTF_VARCHAR2_TABLE_500();
955 a41 := JTF_VARCHAR2_TABLE_500();
952 a38 := JTF_VARCHAR2_TABLE_500();
953 a39 := JTF_VARCHAR2_TABLE_500();
954 a40 := JTF_VARCHAR2_TABLE_500();
956 a42 := JTF_VARCHAR2_TABLE_500();
957 a43 := JTF_VARCHAR2_TABLE_500();
958 a44 := JTF_VARCHAR2_TABLE_500();
959 a45 := JTF_VARCHAR2_TABLE_500();
960 a46 := JTF_DATE_TABLE();
961 a47 := JTF_NUMBER_TABLE();
962 a48 := JTF_NUMBER_TABLE();
963 a49 := JTF_NUMBER_TABLE();
964 a50 := JTF_DATE_TABLE();
965 a51 := JTF_NUMBER_TABLE();
966 a52 := JTF_NUMBER_TABLE();
967 a53 := JTF_DATE_TABLE();
968 a54 := JTF_NUMBER_TABLE();
969 a55 := JTF_DATE_TABLE();
970 a56 := JTF_NUMBER_TABLE();
971 a57 := JTF_NUMBER_TABLE();
972 a58 := JTF_VARCHAR2_TABLE_200();
973 a59 := JTF_VARCHAR2_TABLE_400();
974 a60 := JTF_VARCHAR2_TABLE_100();
975 a61 := JTF_NUMBER_TABLE();
976 a62 := JTF_VARCHAR2_TABLE_100();
977 a63 := JTF_DATE_TABLE();
978 a64 := JTF_VARCHAR2_TABLE_100();
979 a65 := JTF_NUMBER_TABLE();
980 a66 := JTF_NUMBER_TABLE();
981 a67 := JTF_NUMBER_TABLE();
982 a68 := JTF_NUMBER_TABLE();
983 a69 := JTF_VARCHAR2_TABLE_100();
984 a70 := JTF_VARCHAR2_TABLE_100();
985 a71 := JTF_NUMBER_TABLE();
986 a72 := JTF_VARCHAR2_TABLE_4000();
987 a73 := JTF_DATE_TABLE();
988 else
989 a0 := JTF_NUMBER_TABLE();
990 a1 := JTF_NUMBER_TABLE();
991 a2 := JTF_VARCHAR2_TABLE_100();
992 a3 := JTF_VARCHAR2_TABLE_100();
993 a4 := JTF_VARCHAR2_TABLE_100();
994 a5 := JTF_NUMBER_TABLE();
995 a6 := JTF_DATE_TABLE();
996 a7 := JTF_NUMBER_TABLE();
997 a8 := JTF_NUMBER_TABLE();
998 a9 := JTF_NUMBER_TABLE();
999 a10 := JTF_NUMBER_TABLE();
1000 a11 := JTF_NUMBER_TABLE();
1001 a12 := JTF_NUMBER_TABLE();
1002 a13 := JTF_NUMBER_TABLE();
1003 a14 := JTF_VARCHAR2_TABLE_100();
1004 a15 := JTF_NUMBER_TABLE();
1005 a16 := JTF_NUMBER_TABLE();
1006 a17 := JTF_NUMBER_TABLE();
1007 a18 := JTF_NUMBER_TABLE();
1008 a19 := JTF_NUMBER_TABLE();
1009 a20 := JTF_NUMBER_TABLE();
1010 a21 := JTF_NUMBER_TABLE();
1011 a22 := JTF_NUMBER_TABLE();
1012 a23 := JTF_DATE_TABLE();
1013 a24 := JTF_NUMBER_TABLE();
1014 a25 := JTF_VARCHAR2_TABLE_2000();
1015 a26 := JTF_VARCHAR2_TABLE_300();
1016 a27 := JTF_NUMBER_TABLE();
1017 a28 := JTF_NUMBER_TABLE();
1018 a29 := JTF_NUMBER_TABLE();
1019 a30 := JTF_VARCHAR2_TABLE_100();
1020 a31 := JTF_VARCHAR2_TABLE_500();
1021 a32 := JTF_VARCHAR2_TABLE_500();
1022 a33 := JTF_VARCHAR2_TABLE_500();
1023 a34 := JTF_VARCHAR2_TABLE_500();
1024 a35 := JTF_VARCHAR2_TABLE_500();
1025 a36 := JTF_VARCHAR2_TABLE_500();
1026 a37 := JTF_VARCHAR2_TABLE_500();
1027 a38 := JTF_VARCHAR2_TABLE_500();
1028 a39 := JTF_VARCHAR2_TABLE_500();
1029 a40 := JTF_VARCHAR2_TABLE_500();
1030 a41 := JTF_VARCHAR2_TABLE_500();
1031 a42 := JTF_VARCHAR2_TABLE_500();
1032 a43 := JTF_VARCHAR2_TABLE_500();
1033 a44 := JTF_VARCHAR2_TABLE_500();
1034 a45 := JTF_VARCHAR2_TABLE_500();
1035 a46 := JTF_DATE_TABLE();
1036 a47 := JTF_NUMBER_TABLE();
1037 a48 := JTF_NUMBER_TABLE();
1038 a49 := JTF_NUMBER_TABLE();
1039 a50 := JTF_DATE_TABLE();
1040 a51 := JTF_NUMBER_TABLE();
1041 a52 := JTF_NUMBER_TABLE();
1042 a53 := JTF_DATE_TABLE();
1043 a54 := JTF_NUMBER_TABLE();
1044 a55 := JTF_DATE_TABLE();
1045 a56 := JTF_NUMBER_TABLE();
1046 a57 := JTF_NUMBER_TABLE();
1047 a58 := JTF_VARCHAR2_TABLE_200();
1048 a59 := JTF_VARCHAR2_TABLE_400();
1049 a60 := JTF_VARCHAR2_TABLE_100();
1050 a61 := JTF_NUMBER_TABLE();
1051 a62 := JTF_VARCHAR2_TABLE_100();
1052 a63 := JTF_DATE_TABLE();
1053 a64 := JTF_VARCHAR2_TABLE_100();
1054 a65 := JTF_NUMBER_TABLE();
1055 a66 := JTF_NUMBER_TABLE();
1056 a67 := JTF_NUMBER_TABLE();
1057 a68 := JTF_NUMBER_TABLE();
1058 a69 := JTF_VARCHAR2_TABLE_100();
1059 a70 := JTF_VARCHAR2_TABLE_100();
1060 a71 := JTF_NUMBER_TABLE();
1061 a72 := JTF_VARCHAR2_TABLE_4000();
1062 a73 := JTF_DATE_TABLE();
1063 if t.count > 0 then
1064 a0.extend(t.count);
1065 a1.extend(t.count);
1066 a2.extend(t.count);
1067 a3.extend(t.count);
1068 a4.extend(t.count);
1069 a5.extend(t.count);
1070 a6.extend(t.count);
1071 a7.extend(t.count);
1072 a8.extend(t.count);
1073 a9.extend(t.count);
1074 a10.extend(t.count);
1075 a11.extend(t.count);
1076 a12.extend(t.count);
1077 a13.extend(t.count);
1078 a14.extend(t.count);
1079 a15.extend(t.count);
1080 a16.extend(t.count);
1081 a17.extend(t.count);
1082 a18.extend(t.count);
1083 a19.extend(t.count);
1084 a20.extend(t.count);
1085 a21.extend(t.count);
1086 a22.extend(t.count);
1087 a23.extend(t.count);
1088 a24.extend(t.count);
1089 a25.extend(t.count);
1090 a26.extend(t.count);
1091 a27.extend(t.count);
1092 a28.extend(t.count);
1096 a32.extend(t.count);
1093 a29.extend(t.count);
1094 a30.extend(t.count);
1095 a31.extend(t.count);
1097 a33.extend(t.count);
1098 a34.extend(t.count);
1099 a35.extend(t.count);
1100 a36.extend(t.count);
1101 a37.extend(t.count);
1102 a38.extend(t.count);
1103 a39.extend(t.count);
1104 a40.extend(t.count);
1105 a41.extend(t.count);
1106 a42.extend(t.count);
1107 a43.extend(t.count);
1108 a44.extend(t.count);
1109 a45.extend(t.count);
1110 a46.extend(t.count);
1111 a47.extend(t.count);
1112 a48.extend(t.count);
1113 a49.extend(t.count);
1114 a50.extend(t.count);
1115 a51.extend(t.count);
1116 a52.extend(t.count);
1117 a53.extend(t.count);
1118 a54.extend(t.count);
1119 a55.extend(t.count);
1120 a56.extend(t.count);
1121 a57.extend(t.count);
1122 a58.extend(t.count);
1123 a59.extend(t.count);
1124 a60.extend(t.count);
1125 a61.extend(t.count);
1126 a62.extend(t.count);
1127 a63.extend(t.count);
1128 a64.extend(t.count);
1129 a65.extend(t.count);
1130 a66.extend(t.count);
1131 a67.extend(t.count);
1132 a68.extend(t.count);
1133 a69.extend(t.count);
1134 a70.extend(t.count);
1135 a71.extend(t.count);
1136 a72.extend(t.count);
1137 a73.extend(t.count);
1138 ddindx := t.first;
1139 indx := 1;
1140 while true loop
1141 a0(indx) := rosetta_g_miss_num_map(t(ddindx).id);
1142 a1(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
1143 a2(indx) := t(ddindx).sfwt_flag;
1144 a3(indx) := t(ddindx).currency_code;
1145 a4(indx) := t(ddindx).currency_conversion_type;
1146 a5(indx) := rosetta_g_miss_num_map(t(ddindx).currency_conversion_rate);
1147 a6(indx) := t(ddindx).currency_conversion_date;
1148 a7(indx) := rosetta_g_miss_num_map(t(ddindx).khr_id);
1149 a8(indx) := rosetta_g_miss_num_map(t(ddindx).cra_id);
1150 a9(indx) := rosetta_g_miss_num_map(t(ddindx).tap_id);
1151 a10(indx) := rosetta_g_miss_num_map(t(ddindx).qte_id);
1152 a11(indx) := rosetta_g_miss_num_map(t(ddindx).tcn_id);
1153 a12(indx) := rosetta_g_miss_num_map(t(ddindx).tai_id_reverses);
1154 a13(indx) := rosetta_g_miss_num_map(t(ddindx).ipy_id);
1155 a14(indx) := t(ddindx).trx_status_code;
1156 a15(indx) := rosetta_g_miss_num_map(t(ddindx).set_of_books_id);
1157 a16(indx) := rosetta_g_miss_num_map(t(ddindx).try_id);
1158 a17(indx) := rosetta_g_miss_num_map(t(ddindx).ibt_id);
1159 a18(indx) := rosetta_g_miss_num_map(t(ddindx).ixx_id);
1160 a19(indx) := rosetta_g_miss_num_map(t(ddindx).irm_id);
1161 a20(indx) := rosetta_g_miss_num_map(t(ddindx).irt_id);
1162 a21(indx) := rosetta_g_miss_num_map(t(ddindx).svf_id);
1163 a22(indx) := rosetta_g_miss_num_map(t(ddindx).amount);
1164 a23(indx) := t(ddindx).date_invoiced;
1165 a24(indx) := rosetta_g_miss_num_map(t(ddindx).amount_applied);
1166 a25(indx) := t(ddindx).description;
1167 a26(indx) := t(ddindx).trx_number;
1168 a27(indx) := rosetta_g_miss_num_map(t(ddindx).clg_id);
1169 a28(indx) := rosetta_g_miss_num_map(t(ddindx).pox_id);
1170 a29(indx) := rosetta_g_miss_num_map(t(ddindx).cpy_id);
1171 a30(indx) := t(ddindx).attribute_category;
1172 a31(indx) := t(ddindx).attribute1;
1173 a32(indx) := t(ddindx).attribute2;
1174 a33(indx) := t(ddindx).attribute3;
1175 a34(indx) := t(ddindx).attribute4;
1176 a35(indx) := t(ddindx).attribute5;
1177 a36(indx) := t(ddindx).attribute6;
1178 a37(indx) := t(ddindx).attribute7;
1179 a38(indx) := t(ddindx).attribute8;
1180 a39(indx) := t(ddindx).attribute9;
1181 a40(indx) := t(ddindx).attribute10;
1182 a41(indx) := t(ddindx).attribute11;
1183 a42(indx) := t(ddindx).attribute12;
1184 a43(indx) := t(ddindx).attribute13;
1185 a44(indx) := t(ddindx).attribute14;
1186 a45(indx) := t(ddindx).attribute15;
1187 a46(indx) := t(ddindx).date_entered;
1188 a47(indx) := rosetta_g_miss_num_map(t(ddindx).request_id);
1189 a48(indx) := rosetta_g_miss_num_map(t(ddindx).program_application_id);
1190 a49(indx) := rosetta_g_miss_num_map(t(ddindx).program_id);
1191 a50(indx) := t(ddindx).program_update_date;
1192 a51(indx) := rosetta_g_miss_num_map(t(ddindx).org_id);
1193 a52(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
1194 a53(indx) := t(ddindx).creation_date;
1195 a54(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
1196 a55(indx) := t(ddindx).last_update_date;
1197 a56(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
1198 a57(indx) := rosetta_g_miss_num_map(t(ddindx).legal_entity_id);
1199 a58(indx) := t(ddindx).investor_agreement_number;
1200 a59(indx) := t(ddindx).investor_name;
1201 a60(indx) := t(ddindx).okl_source_billing_trx;
1202 a61(indx) := rosetta_g_miss_num_map(t(ddindx).inf_id);
1203 a62(indx) := t(ddindx).invoice_pull_yn;
1207 a66(indx) := rosetta_g_miss_num_map(t(ddindx).receivables_invoice_id);
1204 a63(indx) := t(ddindx).due_date;
1205 a64(indx) := t(ddindx).consolidated_invoice_number;
1206 a65(indx) := rosetta_g_miss_num_map(t(ddindx).isi_id);
1208 a67(indx) := rosetta_g_miss_num_map(t(ddindx).cust_trx_type_id);
1209 a68(indx) := rosetta_g_miss_num_map(t(ddindx).customer_bank_account_id);
1210 a69(indx) := t(ddindx).tax_exempt_flag;
1211 a70(indx) := t(ddindx).tax_exempt_reason_code;
1212 a71(indx) := rosetta_g_miss_num_map(t(ddindx).reference_line_id);
1213 a72(indx) := t(ddindx).private_label;
1214 a73(indx) := t(ddindx).transaction_date;
1215 indx := indx+1;
1216 if t.last =ddindx
1217 then exit;
1218 end if;
1219 ddindx := t.next(ddindx);
1220 end loop;
1221 end if;
1222 end if;
1223 end rosetta_table_copy_out_p8;
1224
1225 procedure insert_row(p_api_version NUMBER
1226 , p_init_msg_list VARCHAR2
1227 , x_return_status out nocopy VARCHAR2
1228 , x_msg_count out nocopy NUMBER
1229 , x_msg_data out nocopy VARCHAR2
1230 , p6_a0 out nocopy NUMBER
1231 , p6_a1 out nocopy NUMBER
1232 , p6_a2 out nocopy VARCHAR2
1233 , p6_a3 out nocopy VARCHAR2
1234 , p6_a4 out nocopy VARCHAR2
1235 , p6_a5 out nocopy NUMBER
1236 , p6_a6 out nocopy DATE
1237 , p6_a7 out nocopy NUMBER
1238 , p6_a8 out nocopy NUMBER
1239 , p6_a9 out nocopy NUMBER
1240 , p6_a10 out nocopy NUMBER
1241 , p6_a11 out nocopy NUMBER
1242 , p6_a12 out nocopy NUMBER
1243 , p6_a13 out nocopy NUMBER
1244 , p6_a14 out nocopy VARCHAR2
1245 , p6_a15 out nocopy NUMBER
1246 , p6_a16 out nocopy NUMBER
1247 , p6_a17 out nocopy NUMBER
1248 , p6_a18 out nocopy NUMBER
1249 , p6_a19 out nocopy NUMBER
1250 , p6_a20 out nocopy NUMBER
1251 , p6_a21 out nocopy NUMBER
1252 , p6_a22 out nocopy NUMBER
1253 , p6_a23 out nocopy DATE
1254 , p6_a24 out nocopy NUMBER
1255 , p6_a25 out nocopy VARCHAR2
1256 , p6_a26 out nocopy VARCHAR2
1257 , p6_a27 out nocopy NUMBER
1258 , p6_a28 out nocopy NUMBER
1259 , p6_a29 out nocopy NUMBER
1260 , p6_a30 out nocopy VARCHAR2
1261 , p6_a31 out nocopy VARCHAR2
1262 , p6_a32 out nocopy VARCHAR2
1263 , p6_a33 out nocopy VARCHAR2
1264 , p6_a34 out nocopy VARCHAR2
1265 , p6_a35 out nocopy VARCHAR2
1266 , p6_a36 out nocopy VARCHAR2
1267 , p6_a37 out nocopy VARCHAR2
1268 , p6_a38 out nocopy VARCHAR2
1269 , p6_a39 out nocopy VARCHAR2
1270 , p6_a40 out nocopy VARCHAR2
1271 , p6_a41 out nocopy VARCHAR2
1272 , p6_a42 out nocopy VARCHAR2
1273 , p6_a43 out nocopy VARCHAR2
1274 , p6_a44 out nocopy VARCHAR2
1275 , p6_a45 out nocopy VARCHAR2
1276 , p6_a46 out nocopy DATE
1277 , p6_a47 out nocopy NUMBER
1278 , p6_a48 out nocopy NUMBER
1279 , p6_a49 out nocopy NUMBER
1280 , p6_a50 out nocopy DATE
1281 , p6_a51 out nocopy NUMBER
1282 , p6_a52 out nocopy NUMBER
1283 , p6_a53 out nocopy DATE
1284 , p6_a54 out nocopy NUMBER
1285 , p6_a55 out nocopy DATE
1286 , p6_a56 out nocopy NUMBER
1287 , p6_a57 out nocopy NUMBER
1288 , p6_a58 out nocopy VARCHAR2
1289 , p6_a59 out nocopy VARCHAR2
1290 , p6_a60 out nocopy VARCHAR2
1291 , p6_a61 out nocopy NUMBER
1292 , p6_a62 out nocopy VARCHAR2
1293 , p6_a63 out nocopy DATE
1294 , p6_a64 out nocopy VARCHAR2
1295 , p6_a65 out nocopy NUMBER
1296 , p6_a66 out nocopy NUMBER
1297 , p6_a67 out nocopy NUMBER
1298 , p6_a68 out nocopy NUMBER
1299 , p6_a69 out nocopy VARCHAR2
1300 , p6_a70 out nocopy VARCHAR2
1301 , p6_a71 out nocopy NUMBER
1302 , p6_a72 out nocopy VARCHAR2
1303 , p6_a73 out nocopy DATE
1304 , p5_a0 NUMBER := 0-1962.0724
1305 , p5_a1 NUMBER := 0-1962.0724
1306 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1307 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1308 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1309 , p5_a5 NUMBER := 0-1962.0724
1310 , p5_a6 DATE := fnd_api.g_miss_date
1311 , p5_a7 NUMBER := 0-1962.0724
1312 , p5_a8 NUMBER := 0-1962.0724
1313 , p5_a9 NUMBER := 0-1962.0724
1314 , p5_a10 NUMBER := 0-1962.0724
1315 , p5_a11 NUMBER := 0-1962.0724
1316 , p5_a12 NUMBER := 0-1962.0724
1317 , p5_a13 NUMBER := 0-1962.0724
1318 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1319 , p5_a15 NUMBER := 0-1962.0724
1320 , p5_a16 NUMBER := 0-1962.0724
1321 , p5_a17 NUMBER := 0-1962.0724
1322 , p5_a18 NUMBER := 0-1962.0724
1323 , p5_a19 NUMBER := 0-1962.0724
1324 , p5_a20 NUMBER := 0-1962.0724
1325 , p5_a21 NUMBER := 0-1962.0724
1326 , p5_a22 NUMBER := 0-1962.0724
1327 , p5_a23 DATE := fnd_api.g_miss_date
1328 , p5_a24 NUMBER := 0-1962.0724
1329 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1330 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1331 , p5_a27 NUMBER := 0-1962.0724
1332 , p5_a28 NUMBER := 0-1962.0724
1333 , p5_a29 NUMBER := 0-1962.0724
1334 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1338 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1335 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1336 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1337 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1339 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1340 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1341 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1342 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1343 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1344 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1345 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1346 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1347 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1348 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1349 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1350 , p5_a46 DATE := fnd_api.g_miss_date
1351 , p5_a47 NUMBER := 0-1962.0724
1352 , p5_a48 NUMBER := 0-1962.0724
1353 , p5_a49 NUMBER := 0-1962.0724
1354 , p5_a50 DATE := fnd_api.g_miss_date
1355 , p5_a51 NUMBER := 0-1962.0724
1356 , p5_a52 NUMBER := 0-1962.0724
1357 , p5_a53 DATE := fnd_api.g_miss_date
1358 , p5_a54 NUMBER := 0-1962.0724
1359 , p5_a55 DATE := fnd_api.g_miss_date
1360 , p5_a56 NUMBER := 0-1962.0724
1361 , p5_a57 NUMBER := 0-1962.0724
1362 , p5_a58 VARCHAR2 := fnd_api.g_miss_char
1363 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1364 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
1365 , p5_a61 NUMBER := 0-1962.0724
1366 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1367 , p5_a63 DATE := fnd_api.g_miss_date
1368 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
1369 , p5_a65 NUMBER := 0-1962.0724
1370 , p5_a66 NUMBER := 0-1962.0724
1371 , p5_a67 NUMBER := 0-1962.0724
1372 , p5_a68 NUMBER := 0-1962.0724
1373 , p5_a69 VARCHAR2 := fnd_api.g_miss_char
1374 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
1375 , p5_a71 NUMBER := 0-1962.0724
1376 , p5_a72 VARCHAR2 := fnd_api.g_miss_char
1377 , p5_a73 DATE := fnd_api.g_miss_date
1378 )
1379
1380 as
1381 ddp_taiv_rec okl_tai_pvt.taiv_rec_type;
1382 ddx_taiv_rec okl_tai_pvt.taiv_rec_type;
1383 ddindx binary_integer; indx binary_integer;
1384 begin
1385
1386 -- copy data to the local IN or IN-OUT args, if any
1387
1388
1389
1390
1391
1392 ddp_taiv_rec.id := rosetta_g_miss_num_map(p5_a0);
1393 ddp_taiv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1394 ddp_taiv_rec.sfwt_flag := p5_a2;
1395 ddp_taiv_rec.currency_code := p5_a3;
1396 ddp_taiv_rec.currency_conversion_type := p5_a4;
1397 ddp_taiv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a5);
1398 ddp_taiv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a6);
1399 ddp_taiv_rec.khr_id := rosetta_g_miss_num_map(p5_a7);
1400 ddp_taiv_rec.cra_id := rosetta_g_miss_num_map(p5_a8);
1401 ddp_taiv_rec.tap_id := rosetta_g_miss_num_map(p5_a9);
1402 ddp_taiv_rec.qte_id := rosetta_g_miss_num_map(p5_a10);
1403 ddp_taiv_rec.tcn_id := rosetta_g_miss_num_map(p5_a11);
1404 ddp_taiv_rec.tai_id_reverses := rosetta_g_miss_num_map(p5_a12);
1405 ddp_taiv_rec.ipy_id := rosetta_g_miss_num_map(p5_a13);
1406 ddp_taiv_rec.trx_status_code := p5_a14;
1407 ddp_taiv_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a15);
1408 ddp_taiv_rec.try_id := rosetta_g_miss_num_map(p5_a16);
1409 ddp_taiv_rec.ibt_id := rosetta_g_miss_num_map(p5_a17);
1410 ddp_taiv_rec.ixx_id := rosetta_g_miss_num_map(p5_a18);
1411 ddp_taiv_rec.irm_id := rosetta_g_miss_num_map(p5_a19);
1412 ddp_taiv_rec.irt_id := rosetta_g_miss_num_map(p5_a20);
1413 ddp_taiv_rec.svf_id := rosetta_g_miss_num_map(p5_a21);
1414 ddp_taiv_rec.amount := rosetta_g_miss_num_map(p5_a22);
1415 ddp_taiv_rec.date_invoiced := rosetta_g_miss_date_in_map(p5_a23);
1416 ddp_taiv_rec.amount_applied := rosetta_g_miss_num_map(p5_a24);
1417 ddp_taiv_rec.description := p5_a25;
1418 ddp_taiv_rec.trx_number := p5_a26;
1419 ddp_taiv_rec.clg_id := rosetta_g_miss_num_map(p5_a27);
1420 ddp_taiv_rec.pox_id := rosetta_g_miss_num_map(p5_a28);
1421 ddp_taiv_rec.cpy_id := rosetta_g_miss_num_map(p5_a29);
1422 ddp_taiv_rec.attribute_category := p5_a30;
1423 ddp_taiv_rec.attribute1 := p5_a31;
1424 ddp_taiv_rec.attribute2 := p5_a32;
1425 ddp_taiv_rec.attribute3 := p5_a33;
1426 ddp_taiv_rec.attribute4 := p5_a34;
1427 ddp_taiv_rec.attribute5 := p5_a35;
1428 ddp_taiv_rec.attribute6 := p5_a36;
1429 ddp_taiv_rec.attribute7 := p5_a37;
1430 ddp_taiv_rec.attribute8 := p5_a38;
1431 ddp_taiv_rec.attribute9 := p5_a39;
1432 ddp_taiv_rec.attribute10 := p5_a40;
1433 ddp_taiv_rec.attribute11 := p5_a41;
1434 ddp_taiv_rec.attribute12 := p5_a42;
1435 ddp_taiv_rec.attribute13 := p5_a43;
1436 ddp_taiv_rec.attribute14 := p5_a44;
1437 ddp_taiv_rec.attribute15 := p5_a45;
1438 ddp_taiv_rec.date_entered := rosetta_g_miss_date_in_map(p5_a46);
1439 ddp_taiv_rec.request_id := rosetta_g_miss_num_map(p5_a47);
1440 ddp_taiv_rec.program_application_id := rosetta_g_miss_num_map(p5_a48);
1441 ddp_taiv_rec.program_id := rosetta_g_miss_num_map(p5_a49);
1442 ddp_taiv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a50);
1443 ddp_taiv_rec.org_id := rosetta_g_miss_num_map(p5_a51);
1444 ddp_taiv_rec.created_by := rosetta_g_miss_num_map(p5_a52);
1445 ddp_taiv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a53);
1446 ddp_taiv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a54);
1447 ddp_taiv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a55);
1448 ddp_taiv_rec.last_update_login := rosetta_g_miss_num_map(p5_a56);
1452 ddp_taiv_rec.okl_source_billing_trx := p5_a60;
1449 ddp_taiv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a57);
1450 ddp_taiv_rec.investor_agreement_number := p5_a58;
1451 ddp_taiv_rec.investor_name := p5_a59;
1453 ddp_taiv_rec.inf_id := rosetta_g_miss_num_map(p5_a61);
1454 ddp_taiv_rec.invoice_pull_yn := p5_a62;
1455 ddp_taiv_rec.due_date := rosetta_g_miss_date_in_map(p5_a63);
1456 ddp_taiv_rec.consolidated_invoice_number := p5_a64;
1457 ddp_taiv_rec.isi_id := rosetta_g_miss_num_map(p5_a65);
1458 ddp_taiv_rec.receivables_invoice_id := rosetta_g_miss_num_map(p5_a66);
1459 ddp_taiv_rec.cust_trx_type_id := rosetta_g_miss_num_map(p5_a67);
1460 ddp_taiv_rec.customer_bank_account_id := rosetta_g_miss_num_map(p5_a68);
1461 ddp_taiv_rec.tax_exempt_flag := p5_a69;
1462 ddp_taiv_rec.tax_exempt_reason_code := p5_a70;
1463 ddp_taiv_rec.reference_line_id := rosetta_g_miss_num_map(p5_a71);
1464 ddp_taiv_rec.private_label := p5_a72;
1465 ddp_taiv_rec.transaction_date := rosetta_g_miss_date_in_map(p5_a73);
1466
1467
1468 -- here's the delegated call to the old PL/SQL routine
1469 okl_tai_pvt.insert_row(p_api_version,
1470 p_init_msg_list,
1471 x_return_status,
1472 x_msg_count,
1473 x_msg_data,
1474 ddp_taiv_rec,
1475 ddx_taiv_rec);
1476
1477 -- copy data back from the local variables to OUT or IN-OUT args, if any
1478
1479
1480
1481
1482
1483
1484 p6_a0 := rosetta_g_miss_num_map(ddx_taiv_rec.id);
1485 p6_a1 := rosetta_g_miss_num_map(ddx_taiv_rec.object_version_number);
1486 p6_a2 := ddx_taiv_rec.sfwt_flag;
1487 p6_a3 := ddx_taiv_rec.currency_code;
1488 p6_a4 := ddx_taiv_rec.currency_conversion_type;
1489 p6_a5 := rosetta_g_miss_num_map(ddx_taiv_rec.currency_conversion_rate);
1490 p6_a6 := ddx_taiv_rec.currency_conversion_date;
1491 p6_a7 := rosetta_g_miss_num_map(ddx_taiv_rec.khr_id);
1492 p6_a8 := rosetta_g_miss_num_map(ddx_taiv_rec.cra_id);
1493 p6_a9 := rosetta_g_miss_num_map(ddx_taiv_rec.tap_id);
1494 p6_a10 := rosetta_g_miss_num_map(ddx_taiv_rec.qte_id);
1495 p6_a11 := rosetta_g_miss_num_map(ddx_taiv_rec.tcn_id);
1496 p6_a12 := rosetta_g_miss_num_map(ddx_taiv_rec.tai_id_reverses);
1497 p6_a13 := rosetta_g_miss_num_map(ddx_taiv_rec.ipy_id);
1498 p6_a14 := ddx_taiv_rec.trx_status_code;
1499 p6_a15 := rosetta_g_miss_num_map(ddx_taiv_rec.set_of_books_id);
1500 p6_a16 := rosetta_g_miss_num_map(ddx_taiv_rec.try_id);
1501 p6_a17 := rosetta_g_miss_num_map(ddx_taiv_rec.ibt_id);
1502 p6_a18 := rosetta_g_miss_num_map(ddx_taiv_rec.ixx_id);
1503 p6_a19 := rosetta_g_miss_num_map(ddx_taiv_rec.irm_id);
1504 p6_a20 := rosetta_g_miss_num_map(ddx_taiv_rec.irt_id);
1505 p6_a21 := rosetta_g_miss_num_map(ddx_taiv_rec.svf_id);
1506 p6_a22 := rosetta_g_miss_num_map(ddx_taiv_rec.amount);
1507 p6_a23 := ddx_taiv_rec.date_invoiced;
1508 p6_a24 := rosetta_g_miss_num_map(ddx_taiv_rec.amount_applied);
1509 p6_a25 := ddx_taiv_rec.description;
1510 p6_a26 := ddx_taiv_rec.trx_number;
1511 p6_a27 := rosetta_g_miss_num_map(ddx_taiv_rec.clg_id);
1512 p6_a28 := rosetta_g_miss_num_map(ddx_taiv_rec.pox_id);
1513 p6_a29 := rosetta_g_miss_num_map(ddx_taiv_rec.cpy_id);
1514 p6_a30 := ddx_taiv_rec.attribute_category;
1515 p6_a31 := ddx_taiv_rec.attribute1;
1516 p6_a32 := ddx_taiv_rec.attribute2;
1517 p6_a33 := ddx_taiv_rec.attribute3;
1518 p6_a34 := ddx_taiv_rec.attribute4;
1519 p6_a35 := ddx_taiv_rec.attribute5;
1520 p6_a36 := ddx_taiv_rec.attribute6;
1521 p6_a37 := ddx_taiv_rec.attribute7;
1522 p6_a38 := ddx_taiv_rec.attribute8;
1523 p6_a39 := ddx_taiv_rec.attribute9;
1524 p6_a40 := ddx_taiv_rec.attribute10;
1525 p6_a41 := ddx_taiv_rec.attribute11;
1526 p6_a42 := ddx_taiv_rec.attribute12;
1527 p6_a43 := ddx_taiv_rec.attribute13;
1528 p6_a44 := ddx_taiv_rec.attribute14;
1529 p6_a45 := ddx_taiv_rec.attribute15;
1530 p6_a46 := ddx_taiv_rec.date_entered;
1531 p6_a47 := rosetta_g_miss_num_map(ddx_taiv_rec.request_id);
1532 p6_a48 := rosetta_g_miss_num_map(ddx_taiv_rec.program_application_id);
1533 p6_a49 := rosetta_g_miss_num_map(ddx_taiv_rec.program_id);
1534 p6_a50 := ddx_taiv_rec.program_update_date;
1535 p6_a51 := rosetta_g_miss_num_map(ddx_taiv_rec.org_id);
1536 p6_a52 := rosetta_g_miss_num_map(ddx_taiv_rec.created_by);
1537 p6_a53 := ddx_taiv_rec.creation_date;
1538 p6_a54 := rosetta_g_miss_num_map(ddx_taiv_rec.last_updated_by);
1539 p6_a55 := ddx_taiv_rec.last_update_date;
1540 p6_a56 := rosetta_g_miss_num_map(ddx_taiv_rec.last_update_login);
1541 p6_a57 := rosetta_g_miss_num_map(ddx_taiv_rec.legal_entity_id);
1542 p6_a58 := ddx_taiv_rec.investor_agreement_number;
1543 p6_a59 := ddx_taiv_rec.investor_name;
1544 p6_a60 := ddx_taiv_rec.okl_source_billing_trx;
1545 p6_a61 := rosetta_g_miss_num_map(ddx_taiv_rec.inf_id);
1546 p6_a62 := ddx_taiv_rec.invoice_pull_yn;
1547 p6_a63 := ddx_taiv_rec.due_date;
1548 p6_a64 := ddx_taiv_rec.consolidated_invoice_number;
1549 p6_a65 := rosetta_g_miss_num_map(ddx_taiv_rec.isi_id);
1550 p6_a66 := rosetta_g_miss_num_map(ddx_taiv_rec.receivables_invoice_id);
1551 p6_a67 := rosetta_g_miss_num_map(ddx_taiv_rec.cust_trx_type_id);
1552 p6_a68 := rosetta_g_miss_num_map(ddx_taiv_rec.customer_bank_account_id);
1553 p6_a69 := ddx_taiv_rec.tax_exempt_flag;
1554 p6_a70 := ddx_taiv_rec.tax_exempt_reason_code;
1555 p6_a71 := rosetta_g_miss_num_map(ddx_taiv_rec.reference_line_id);
1556 p6_a72 := ddx_taiv_rec.private_label;
1557 p6_a73 := ddx_taiv_rec.transaction_date;
1558 end;
1559
1563 , x_msg_count out nocopy NUMBER
1560 procedure insert_row(p_api_version NUMBER
1561 , p_init_msg_list VARCHAR2
1562 , x_return_status out nocopy VARCHAR2
1564 , x_msg_data out nocopy VARCHAR2
1565 , p5_a0 JTF_NUMBER_TABLE
1566 , p5_a1 JTF_NUMBER_TABLE
1567 , p5_a2 JTF_VARCHAR2_TABLE_100
1568 , p5_a3 JTF_VARCHAR2_TABLE_100
1569 , p5_a4 JTF_VARCHAR2_TABLE_100
1570 , p5_a5 JTF_NUMBER_TABLE
1571 , p5_a6 JTF_DATE_TABLE
1572 , p5_a7 JTF_NUMBER_TABLE
1573 , p5_a8 JTF_NUMBER_TABLE
1574 , p5_a9 JTF_NUMBER_TABLE
1575 , p5_a10 JTF_NUMBER_TABLE
1576 , p5_a11 JTF_NUMBER_TABLE
1577 , p5_a12 JTF_NUMBER_TABLE
1578 , p5_a13 JTF_NUMBER_TABLE
1579 , p5_a14 JTF_VARCHAR2_TABLE_100
1580 , p5_a15 JTF_NUMBER_TABLE
1581 , p5_a16 JTF_NUMBER_TABLE
1582 , p5_a17 JTF_NUMBER_TABLE
1583 , p5_a18 JTF_NUMBER_TABLE
1584 , p5_a19 JTF_NUMBER_TABLE
1585 , p5_a20 JTF_NUMBER_TABLE
1586 , p5_a21 JTF_NUMBER_TABLE
1587 , p5_a22 JTF_NUMBER_TABLE
1588 , p5_a23 JTF_DATE_TABLE
1589 , p5_a24 JTF_NUMBER_TABLE
1590 , p5_a25 JTF_VARCHAR2_TABLE_2000
1591 , p5_a26 JTF_VARCHAR2_TABLE_300
1592 , p5_a27 JTF_NUMBER_TABLE
1593 , p5_a28 JTF_NUMBER_TABLE
1594 , p5_a29 JTF_NUMBER_TABLE
1595 , p5_a30 JTF_VARCHAR2_TABLE_100
1596 , p5_a31 JTF_VARCHAR2_TABLE_500
1597 , p5_a32 JTF_VARCHAR2_TABLE_500
1598 , p5_a33 JTF_VARCHAR2_TABLE_500
1599 , p5_a34 JTF_VARCHAR2_TABLE_500
1600 , p5_a35 JTF_VARCHAR2_TABLE_500
1601 , p5_a36 JTF_VARCHAR2_TABLE_500
1602 , p5_a37 JTF_VARCHAR2_TABLE_500
1603 , p5_a38 JTF_VARCHAR2_TABLE_500
1604 , p5_a39 JTF_VARCHAR2_TABLE_500
1605 , p5_a40 JTF_VARCHAR2_TABLE_500
1606 , p5_a41 JTF_VARCHAR2_TABLE_500
1607 , p5_a42 JTF_VARCHAR2_TABLE_500
1608 , p5_a43 JTF_VARCHAR2_TABLE_500
1609 , p5_a44 JTF_VARCHAR2_TABLE_500
1610 , p5_a45 JTF_VARCHAR2_TABLE_500
1611 , p5_a46 JTF_DATE_TABLE
1612 , p5_a47 JTF_NUMBER_TABLE
1613 , p5_a48 JTF_NUMBER_TABLE
1614 , p5_a49 JTF_NUMBER_TABLE
1615 , p5_a50 JTF_DATE_TABLE
1616 , p5_a51 JTF_NUMBER_TABLE
1617 , p5_a52 JTF_NUMBER_TABLE
1618 , p5_a53 JTF_DATE_TABLE
1619 , p5_a54 JTF_NUMBER_TABLE
1620 , p5_a55 JTF_DATE_TABLE
1621 , p5_a56 JTF_NUMBER_TABLE
1622 , p5_a57 JTF_NUMBER_TABLE
1623 , p5_a58 JTF_VARCHAR2_TABLE_200
1624 , p5_a59 JTF_VARCHAR2_TABLE_400
1625 , p5_a60 JTF_VARCHAR2_TABLE_100
1626 , p5_a61 JTF_NUMBER_TABLE
1627 , p5_a62 JTF_VARCHAR2_TABLE_100
1628 , p5_a63 JTF_DATE_TABLE
1629 , p5_a64 JTF_VARCHAR2_TABLE_100
1630 , p5_a65 JTF_NUMBER_TABLE
1631 , p5_a66 JTF_NUMBER_TABLE
1632 , p5_a67 JTF_NUMBER_TABLE
1633 , p5_a68 JTF_NUMBER_TABLE
1634 , p5_a69 JTF_VARCHAR2_TABLE_100
1635 , p5_a70 JTF_VARCHAR2_TABLE_100
1636 , p5_a71 JTF_NUMBER_TABLE
1637 , p5_a72 JTF_VARCHAR2_TABLE_4000
1638 , p5_a73 JTF_DATE_TABLE
1639 , p6_a0 out nocopy JTF_NUMBER_TABLE
1640 , p6_a1 out nocopy JTF_NUMBER_TABLE
1641 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1642 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1643 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1644 , p6_a5 out nocopy JTF_NUMBER_TABLE
1645 , p6_a6 out nocopy JTF_DATE_TABLE
1646 , p6_a7 out nocopy JTF_NUMBER_TABLE
1647 , p6_a8 out nocopy JTF_NUMBER_TABLE
1648 , p6_a9 out nocopy JTF_NUMBER_TABLE
1649 , p6_a10 out nocopy JTF_NUMBER_TABLE
1650 , p6_a11 out nocopy JTF_NUMBER_TABLE
1651 , p6_a12 out nocopy JTF_NUMBER_TABLE
1652 , p6_a13 out nocopy JTF_NUMBER_TABLE
1653 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1654 , p6_a15 out nocopy JTF_NUMBER_TABLE
1655 , p6_a16 out nocopy JTF_NUMBER_TABLE
1656 , p6_a17 out nocopy JTF_NUMBER_TABLE
1657 , p6_a18 out nocopy JTF_NUMBER_TABLE
1658 , p6_a19 out nocopy JTF_NUMBER_TABLE
1659 , p6_a20 out nocopy JTF_NUMBER_TABLE
1660 , p6_a21 out nocopy JTF_NUMBER_TABLE
1661 , p6_a22 out nocopy JTF_NUMBER_TABLE
1662 , p6_a23 out nocopy JTF_DATE_TABLE
1663 , p6_a24 out nocopy JTF_NUMBER_TABLE
1664 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000
1665 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
1666 , p6_a27 out nocopy JTF_NUMBER_TABLE
1667 , p6_a28 out nocopy JTF_NUMBER_TABLE
1668 , p6_a29 out nocopy JTF_NUMBER_TABLE
1669 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
1670 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
1671 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1672 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1673 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
1674 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
1675 , p6_a36 out nocopy JTF_VARCHAR2_TABLE_500
1676 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_500
1677 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_500
1678 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_500
1679 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_500
1680 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
1681 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
1682 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500
1683 , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
1684 , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
1685 , p6_a46 out nocopy JTF_DATE_TABLE
1686 , p6_a47 out nocopy JTF_NUMBER_TABLE
1687 , p6_a48 out nocopy JTF_NUMBER_TABLE
1688 , p6_a49 out nocopy JTF_NUMBER_TABLE
1689 , p6_a50 out nocopy JTF_DATE_TABLE
1690 , p6_a51 out nocopy JTF_NUMBER_TABLE
1691 , p6_a52 out nocopy JTF_NUMBER_TABLE
1692 , p6_a53 out nocopy JTF_DATE_TABLE
1693 , p6_a54 out nocopy JTF_NUMBER_TABLE
1697 , p6_a58 out nocopy JTF_VARCHAR2_TABLE_200
1694 , p6_a55 out nocopy JTF_DATE_TABLE
1695 , p6_a56 out nocopy JTF_NUMBER_TABLE
1696 , p6_a57 out nocopy JTF_NUMBER_TABLE
1698 , p6_a59 out nocopy JTF_VARCHAR2_TABLE_400
1699 , p6_a60 out nocopy JTF_VARCHAR2_TABLE_100
1700 , p6_a61 out nocopy JTF_NUMBER_TABLE
1701 , p6_a62 out nocopy JTF_VARCHAR2_TABLE_100
1702 , p6_a63 out nocopy JTF_DATE_TABLE
1703 , p6_a64 out nocopy JTF_VARCHAR2_TABLE_100
1704 , p6_a65 out nocopy JTF_NUMBER_TABLE
1705 , p6_a66 out nocopy JTF_NUMBER_TABLE
1706 , p6_a67 out nocopy JTF_NUMBER_TABLE
1707 , p6_a68 out nocopy JTF_NUMBER_TABLE
1708 , p6_a69 out nocopy JTF_VARCHAR2_TABLE_100
1709 , p6_a70 out nocopy JTF_VARCHAR2_TABLE_100
1710 , p6_a71 out nocopy JTF_NUMBER_TABLE
1711 , p6_a72 out nocopy JTF_VARCHAR2_TABLE_4000
1712 , p6_a73 out nocopy JTF_DATE_TABLE
1713 )
1714
1715 as
1716 ddp_taiv_tbl okl_tai_pvt.taiv_tbl_type;
1717 ddx_taiv_tbl okl_tai_pvt.taiv_tbl_type;
1718 ddindx binary_integer; indx binary_integer;
1719 begin
1720
1721 -- copy data to the local IN or IN-OUT args, if any
1722
1723
1724
1725
1726
1727 okl_tai_pvt_w.rosetta_table_copy_in_p8(ddp_taiv_tbl, p5_a0
1728 , p5_a1
1729 , p5_a2
1730 , p5_a3
1731 , p5_a4
1732 , p5_a5
1733 , p5_a6
1734 , p5_a7
1735 , p5_a8
1736 , p5_a9
1737 , p5_a10
1738 , p5_a11
1739 , p5_a12
1740 , p5_a13
1741 , p5_a14
1742 , p5_a15
1743 , p5_a16
1744 , p5_a17
1745 , p5_a18
1746 , p5_a19
1747 , p5_a20
1748 , p5_a21
1749 , p5_a22
1750 , p5_a23
1751 , p5_a24
1752 , p5_a25
1753 , p5_a26
1754 , p5_a27
1755 , p5_a28
1756 , p5_a29
1757 , p5_a30
1758 , p5_a31
1759 , p5_a32
1760 , p5_a33
1761 , p5_a34
1762 , p5_a35
1763 , p5_a36
1764 , p5_a37
1765 , p5_a38
1766 , p5_a39
1767 , p5_a40
1768 , p5_a41
1769 , p5_a42
1770 , p5_a43
1771 , p5_a44
1772 , p5_a45
1773 , p5_a46
1774 , p5_a47
1775 , p5_a48
1776 , p5_a49
1777 , p5_a50
1778 , p5_a51
1779 , p5_a52
1780 , p5_a53
1781 , p5_a54
1782 , p5_a55
1783 , p5_a56
1784 , p5_a57
1785 , p5_a58
1786 , p5_a59
1787 , p5_a60
1788 , p5_a61
1789 , p5_a62
1790 , p5_a63
1791 , p5_a64
1792 , p5_a65
1793 , p5_a66
1794 , p5_a67
1795 , p5_a68
1796 , p5_a69
1797 , p5_a70
1798 , p5_a71
1799 , p5_a72
1800 , p5_a73
1801 );
1802
1803
1804 -- here's the delegated call to the old PL/SQL routine
1805 okl_tai_pvt.insert_row(p_api_version,
1806 p_init_msg_list,
1807 x_return_status,
1808 x_msg_count,
1809 x_msg_data,
1810 ddp_taiv_tbl,
1811 ddx_taiv_tbl);
1812
1813 -- copy data back from the local variables to OUT or IN-OUT args, if any
1814
1815
1816
1817
1818
1819
1820 okl_tai_pvt_w.rosetta_table_copy_out_p8(ddx_taiv_tbl, p6_a0
1821 , p6_a1
1822 , p6_a2
1823 , p6_a3
1824 , p6_a4
1825 , p6_a5
1826 , p6_a6
1827 , p6_a7
1828 , p6_a8
1829 , p6_a9
1830 , p6_a10
1831 , p6_a11
1832 , p6_a12
1833 , p6_a13
1834 , p6_a14
1835 , p6_a15
1836 , p6_a16
1837 , p6_a17
1838 , p6_a18
1839 , p6_a19
1840 , p6_a20
1841 , p6_a21
1842 , p6_a22
1843 , p6_a23
1844 , p6_a24
1845 , p6_a25
1846 , p6_a26
1847 , p6_a27
1848 , p6_a28
1849 , p6_a29
1850 , p6_a30
1851 , p6_a31
1852 , p6_a32
1853 , p6_a33
1854 , p6_a34
1855 , p6_a35
1856 , p6_a36
1857 , p6_a37
1858 , p6_a38
1859 , p6_a39
1860 , p6_a40
1861 , p6_a41
1862 , p6_a42
1863 , p6_a43
1864 , p6_a44
1865 , p6_a45
1866 , p6_a46
1867 , p6_a47
1868 , p6_a48
1869 , p6_a49
1870 , p6_a50
1871 , p6_a51
1872 , p6_a52
1873 , p6_a53
1874 , p6_a54
1875 , p6_a55
1876 , p6_a56
1877 , p6_a57
1878 , p6_a58
1879 , p6_a59
1880 , p6_a60
1881 , p6_a61
1882 , p6_a62
1883 , p6_a63
1884 , p6_a64
1885 , p6_a65
1886 , p6_a66
1887 , p6_a67
1888 , p6_a68
1889 , p6_a69
1890 , p6_a70
1891 , p6_a71
1892 , p6_a72
1893 , p6_a73
1894 );
1895 end;
1896
1897 procedure lock_row(p_api_version NUMBER
1898 , p_init_msg_list VARCHAR2
1899 , x_return_status out nocopy VARCHAR2
1900 , x_msg_count out nocopy NUMBER
1904 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1901 , x_msg_data out nocopy VARCHAR2
1902 , p5_a0 NUMBER := 0-1962.0724
1903 , p5_a1 NUMBER := 0-1962.0724
1905 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1906 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1907 , p5_a5 NUMBER := 0-1962.0724
1908 , p5_a6 DATE := fnd_api.g_miss_date
1909 , p5_a7 NUMBER := 0-1962.0724
1910 , p5_a8 NUMBER := 0-1962.0724
1911 , p5_a9 NUMBER := 0-1962.0724
1912 , p5_a10 NUMBER := 0-1962.0724
1913 , p5_a11 NUMBER := 0-1962.0724
1914 , p5_a12 NUMBER := 0-1962.0724
1915 , p5_a13 NUMBER := 0-1962.0724
1916 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1917 , p5_a15 NUMBER := 0-1962.0724
1918 , p5_a16 NUMBER := 0-1962.0724
1919 , p5_a17 NUMBER := 0-1962.0724
1920 , p5_a18 NUMBER := 0-1962.0724
1921 , p5_a19 NUMBER := 0-1962.0724
1922 , p5_a20 NUMBER := 0-1962.0724
1923 , p5_a21 NUMBER := 0-1962.0724
1924 , p5_a22 NUMBER := 0-1962.0724
1925 , p5_a23 DATE := fnd_api.g_miss_date
1926 , p5_a24 NUMBER := 0-1962.0724
1927 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1928 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1929 , p5_a27 NUMBER := 0-1962.0724
1930 , p5_a28 NUMBER := 0-1962.0724
1931 , p5_a29 NUMBER := 0-1962.0724
1932 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1933 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1934 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1935 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1936 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1937 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1938 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1939 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1940 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1941 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1942 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1943 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1944 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1945 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1946 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1947 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1948 , p5_a46 DATE := fnd_api.g_miss_date
1949 , p5_a47 NUMBER := 0-1962.0724
1950 , p5_a48 NUMBER := 0-1962.0724
1951 , p5_a49 NUMBER := 0-1962.0724
1952 , p5_a50 DATE := fnd_api.g_miss_date
1953 , p5_a51 NUMBER := 0-1962.0724
1954 , p5_a52 NUMBER := 0-1962.0724
1955 , p5_a53 DATE := fnd_api.g_miss_date
1956 , p5_a54 NUMBER := 0-1962.0724
1957 , p5_a55 DATE := fnd_api.g_miss_date
1958 , p5_a56 NUMBER := 0-1962.0724
1959 , p5_a57 NUMBER := 0-1962.0724
1960 , p5_a58 VARCHAR2 := fnd_api.g_miss_char
1961 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1962 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
1963 , p5_a61 NUMBER := 0-1962.0724
1964 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1965 , p5_a63 DATE := fnd_api.g_miss_date
1966 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
1967 , p5_a65 NUMBER := 0-1962.0724
1968 , p5_a66 NUMBER := 0-1962.0724
1969 , p5_a67 NUMBER := 0-1962.0724
1970 , p5_a68 NUMBER := 0-1962.0724
1971 , p5_a69 VARCHAR2 := fnd_api.g_miss_char
1972 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
1973 , p5_a71 NUMBER := 0-1962.0724
1974 , p5_a72 VARCHAR2 := fnd_api.g_miss_char
1975 , p5_a73 DATE := fnd_api.g_miss_date
1976 )
1977
1978 as
1979 ddp_taiv_rec okl_tai_pvt.taiv_rec_type;
1980 ddindx binary_integer; indx binary_integer;
1981 begin
1982
1983 -- copy data to the local IN or IN-OUT args, if any
1984
1985
1986
1987
1988
1989 ddp_taiv_rec.id := rosetta_g_miss_num_map(p5_a0);
1990 ddp_taiv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1991 ddp_taiv_rec.sfwt_flag := p5_a2;
1992 ddp_taiv_rec.currency_code := p5_a3;
1993 ddp_taiv_rec.currency_conversion_type := p5_a4;
1994 ddp_taiv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a5);
1995 ddp_taiv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a6);
1996 ddp_taiv_rec.khr_id := rosetta_g_miss_num_map(p5_a7);
1997 ddp_taiv_rec.cra_id := rosetta_g_miss_num_map(p5_a8);
1998 ddp_taiv_rec.tap_id := rosetta_g_miss_num_map(p5_a9);
1999 ddp_taiv_rec.qte_id := rosetta_g_miss_num_map(p5_a10);
2000 ddp_taiv_rec.tcn_id := rosetta_g_miss_num_map(p5_a11);
2001 ddp_taiv_rec.tai_id_reverses := rosetta_g_miss_num_map(p5_a12);
2002 ddp_taiv_rec.ipy_id := rosetta_g_miss_num_map(p5_a13);
2003 ddp_taiv_rec.trx_status_code := p5_a14;
2004 ddp_taiv_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a15);
2005 ddp_taiv_rec.try_id := rosetta_g_miss_num_map(p5_a16);
2006 ddp_taiv_rec.ibt_id := rosetta_g_miss_num_map(p5_a17);
2007 ddp_taiv_rec.ixx_id := rosetta_g_miss_num_map(p5_a18);
2008 ddp_taiv_rec.irm_id := rosetta_g_miss_num_map(p5_a19);
2009 ddp_taiv_rec.irt_id := rosetta_g_miss_num_map(p5_a20);
2010 ddp_taiv_rec.svf_id := rosetta_g_miss_num_map(p5_a21);
2011 ddp_taiv_rec.amount := rosetta_g_miss_num_map(p5_a22);
2012 ddp_taiv_rec.date_invoiced := rosetta_g_miss_date_in_map(p5_a23);
2013 ddp_taiv_rec.amount_applied := rosetta_g_miss_num_map(p5_a24);
2014 ddp_taiv_rec.description := p5_a25;
2015 ddp_taiv_rec.trx_number := p5_a26;
2016 ddp_taiv_rec.clg_id := rosetta_g_miss_num_map(p5_a27);
2017 ddp_taiv_rec.pox_id := rosetta_g_miss_num_map(p5_a28);
2018 ddp_taiv_rec.cpy_id := rosetta_g_miss_num_map(p5_a29);
2022 ddp_taiv_rec.attribute3 := p5_a33;
2019 ddp_taiv_rec.attribute_category := p5_a30;
2020 ddp_taiv_rec.attribute1 := p5_a31;
2021 ddp_taiv_rec.attribute2 := p5_a32;
2023 ddp_taiv_rec.attribute4 := p5_a34;
2024 ddp_taiv_rec.attribute5 := p5_a35;
2025 ddp_taiv_rec.attribute6 := p5_a36;
2026 ddp_taiv_rec.attribute7 := p5_a37;
2027 ddp_taiv_rec.attribute8 := p5_a38;
2028 ddp_taiv_rec.attribute9 := p5_a39;
2029 ddp_taiv_rec.attribute10 := p5_a40;
2030 ddp_taiv_rec.attribute11 := p5_a41;
2031 ddp_taiv_rec.attribute12 := p5_a42;
2032 ddp_taiv_rec.attribute13 := p5_a43;
2033 ddp_taiv_rec.attribute14 := p5_a44;
2034 ddp_taiv_rec.attribute15 := p5_a45;
2035 ddp_taiv_rec.date_entered := rosetta_g_miss_date_in_map(p5_a46);
2036 ddp_taiv_rec.request_id := rosetta_g_miss_num_map(p5_a47);
2037 ddp_taiv_rec.program_application_id := rosetta_g_miss_num_map(p5_a48);
2038 ddp_taiv_rec.program_id := rosetta_g_miss_num_map(p5_a49);
2039 ddp_taiv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a50);
2040 ddp_taiv_rec.org_id := rosetta_g_miss_num_map(p5_a51);
2041 ddp_taiv_rec.created_by := rosetta_g_miss_num_map(p5_a52);
2042 ddp_taiv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a53);
2043 ddp_taiv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a54);
2044 ddp_taiv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a55);
2045 ddp_taiv_rec.last_update_login := rosetta_g_miss_num_map(p5_a56);
2046 ddp_taiv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a57);
2047 ddp_taiv_rec.investor_agreement_number := p5_a58;
2048 ddp_taiv_rec.investor_name := p5_a59;
2049 ddp_taiv_rec.okl_source_billing_trx := p5_a60;
2050 ddp_taiv_rec.inf_id := rosetta_g_miss_num_map(p5_a61);
2051 ddp_taiv_rec.invoice_pull_yn := p5_a62;
2052 ddp_taiv_rec.due_date := rosetta_g_miss_date_in_map(p5_a63);
2053 ddp_taiv_rec.consolidated_invoice_number := p5_a64;
2054 ddp_taiv_rec.isi_id := rosetta_g_miss_num_map(p5_a65);
2055 ddp_taiv_rec.receivables_invoice_id := rosetta_g_miss_num_map(p5_a66);
2056 ddp_taiv_rec.cust_trx_type_id := rosetta_g_miss_num_map(p5_a67);
2057 ddp_taiv_rec.customer_bank_account_id := rosetta_g_miss_num_map(p5_a68);
2058 ddp_taiv_rec.tax_exempt_flag := p5_a69;
2059 ddp_taiv_rec.tax_exempt_reason_code := p5_a70;
2060 ddp_taiv_rec.reference_line_id := rosetta_g_miss_num_map(p5_a71);
2061 ddp_taiv_rec.private_label := p5_a72;
2062 ddp_taiv_rec.transaction_date := rosetta_g_miss_date_in_map(p5_a73);
2063
2064 -- here's the delegated call to the old PL/SQL routine
2065 okl_tai_pvt.lock_row(p_api_version,
2066 p_init_msg_list,
2067 x_return_status,
2068 x_msg_count,
2069 x_msg_data,
2070 ddp_taiv_rec);
2071
2072 -- copy data back from the local variables to OUT or IN-OUT args, if any
2073
2074
2075
2076
2077
2078 end;
2079
2080 procedure lock_row(p_api_version NUMBER
2081 , p_init_msg_list VARCHAR2
2082 , x_return_status out nocopy VARCHAR2
2083 , x_msg_count out nocopy NUMBER
2084 , x_msg_data out nocopy VARCHAR2
2085 , p5_a0 JTF_NUMBER_TABLE
2086 , p5_a1 JTF_NUMBER_TABLE
2087 , p5_a2 JTF_VARCHAR2_TABLE_100
2088 , p5_a3 JTF_VARCHAR2_TABLE_100
2089 , p5_a4 JTF_VARCHAR2_TABLE_100
2090 , p5_a5 JTF_NUMBER_TABLE
2091 , p5_a6 JTF_DATE_TABLE
2092 , p5_a7 JTF_NUMBER_TABLE
2093 , p5_a8 JTF_NUMBER_TABLE
2094 , p5_a9 JTF_NUMBER_TABLE
2095 , p5_a10 JTF_NUMBER_TABLE
2096 , p5_a11 JTF_NUMBER_TABLE
2097 , p5_a12 JTF_NUMBER_TABLE
2098 , p5_a13 JTF_NUMBER_TABLE
2099 , p5_a14 JTF_VARCHAR2_TABLE_100
2100 , p5_a15 JTF_NUMBER_TABLE
2101 , p5_a16 JTF_NUMBER_TABLE
2102 , p5_a17 JTF_NUMBER_TABLE
2103 , p5_a18 JTF_NUMBER_TABLE
2104 , p5_a19 JTF_NUMBER_TABLE
2105 , p5_a20 JTF_NUMBER_TABLE
2106 , p5_a21 JTF_NUMBER_TABLE
2107 , p5_a22 JTF_NUMBER_TABLE
2108 , p5_a23 JTF_DATE_TABLE
2109 , p5_a24 JTF_NUMBER_TABLE
2110 , p5_a25 JTF_VARCHAR2_TABLE_2000
2111 , p5_a26 JTF_VARCHAR2_TABLE_300
2112 , p5_a27 JTF_NUMBER_TABLE
2113 , p5_a28 JTF_NUMBER_TABLE
2114 , p5_a29 JTF_NUMBER_TABLE
2115 , p5_a30 JTF_VARCHAR2_TABLE_100
2116 , p5_a31 JTF_VARCHAR2_TABLE_500
2117 , p5_a32 JTF_VARCHAR2_TABLE_500
2118 , p5_a33 JTF_VARCHAR2_TABLE_500
2119 , p5_a34 JTF_VARCHAR2_TABLE_500
2120 , p5_a35 JTF_VARCHAR2_TABLE_500
2121 , p5_a36 JTF_VARCHAR2_TABLE_500
2122 , p5_a37 JTF_VARCHAR2_TABLE_500
2123 , p5_a38 JTF_VARCHAR2_TABLE_500
2124 , p5_a39 JTF_VARCHAR2_TABLE_500
2125 , p5_a40 JTF_VARCHAR2_TABLE_500
2126 , p5_a41 JTF_VARCHAR2_TABLE_500
2127 , p5_a42 JTF_VARCHAR2_TABLE_500
2128 , p5_a43 JTF_VARCHAR2_TABLE_500
2129 , p5_a44 JTF_VARCHAR2_TABLE_500
2130 , p5_a45 JTF_VARCHAR2_TABLE_500
2131 , p5_a46 JTF_DATE_TABLE
2132 , p5_a47 JTF_NUMBER_TABLE
2133 , p5_a48 JTF_NUMBER_TABLE
2134 , p5_a49 JTF_NUMBER_TABLE
2135 , p5_a50 JTF_DATE_TABLE
2136 , p5_a51 JTF_NUMBER_TABLE
2137 , p5_a52 JTF_NUMBER_TABLE
2138 , p5_a53 JTF_DATE_TABLE
2139 , p5_a54 JTF_NUMBER_TABLE
2140 , p5_a55 JTF_DATE_TABLE
2141 , p5_a56 JTF_NUMBER_TABLE
2145 , p5_a60 JTF_VARCHAR2_TABLE_100
2142 , p5_a57 JTF_NUMBER_TABLE
2143 , p5_a58 JTF_VARCHAR2_TABLE_200
2144 , p5_a59 JTF_VARCHAR2_TABLE_400
2146 , p5_a61 JTF_NUMBER_TABLE
2147 , p5_a62 JTF_VARCHAR2_TABLE_100
2148 , p5_a63 JTF_DATE_TABLE
2149 , p5_a64 JTF_VARCHAR2_TABLE_100
2150 , p5_a65 JTF_NUMBER_TABLE
2151 , p5_a66 JTF_NUMBER_TABLE
2152 , p5_a67 JTF_NUMBER_TABLE
2153 , p5_a68 JTF_NUMBER_TABLE
2154 , p5_a69 JTF_VARCHAR2_TABLE_100
2155 , p5_a70 JTF_VARCHAR2_TABLE_100
2156 , p5_a71 JTF_NUMBER_TABLE
2157 , p5_a72 JTF_VARCHAR2_TABLE_4000
2158 , p5_a73 JTF_DATE_TABLE
2159 )
2160
2161 as
2162 ddp_taiv_tbl okl_tai_pvt.taiv_tbl_type;
2163 ddindx binary_integer; indx binary_integer;
2164 begin
2165
2166 -- copy data to the local IN or IN-OUT args, if any
2167
2168
2169
2170
2171
2172 okl_tai_pvt_w.rosetta_table_copy_in_p8(ddp_taiv_tbl, p5_a0
2173 , p5_a1
2174 , p5_a2
2175 , p5_a3
2176 , p5_a4
2177 , p5_a5
2178 , p5_a6
2179 , p5_a7
2180 , p5_a8
2181 , p5_a9
2182 , p5_a10
2183 , p5_a11
2184 , p5_a12
2185 , p5_a13
2186 , p5_a14
2187 , p5_a15
2188 , p5_a16
2189 , p5_a17
2190 , p5_a18
2191 , p5_a19
2192 , p5_a20
2193 , p5_a21
2194 , p5_a22
2195 , p5_a23
2196 , p5_a24
2197 , p5_a25
2198 , p5_a26
2199 , p5_a27
2200 , p5_a28
2201 , p5_a29
2202 , p5_a30
2203 , p5_a31
2204 , p5_a32
2205 , p5_a33
2206 , p5_a34
2207 , p5_a35
2208 , p5_a36
2209 , p5_a37
2210 , p5_a38
2211 , p5_a39
2212 , p5_a40
2213 , p5_a41
2214 , p5_a42
2215 , p5_a43
2216 , p5_a44
2217 , p5_a45
2218 , p5_a46
2219 , p5_a47
2220 , p5_a48
2221 , p5_a49
2222 , p5_a50
2223 , p5_a51
2224 , p5_a52
2225 , p5_a53
2226 , p5_a54
2227 , p5_a55
2228 , p5_a56
2229 , p5_a57
2230 , p5_a58
2231 , p5_a59
2232 , p5_a60
2233 , p5_a61
2234 , p5_a62
2235 , p5_a63
2236 , p5_a64
2237 , p5_a65
2238 , p5_a66
2239 , p5_a67
2240 , p5_a68
2241 , p5_a69
2242 , p5_a70
2243 , p5_a71
2244 , p5_a72
2245 , p5_a73
2246 );
2247
2248 -- here's the delegated call to the old PL/SQL routine
2249 okl_tai_pvt.lock_row(p_api_version,
2250 p_init_msg_list,
2251 x_return_status,
2252 x_msg_count,
2253 x_msg_data,
2254 ddp_taiv_tbl);
2255
2256 -- copy data back from the local variables to OUT or IN-OUT args, if any
2257
2258
2259
2260
2261
2262 end;
2263
2264 procedure update_row(p_api_version NUMBER
2265 , p_init_msg_list VARCHAR2
2266 , x_return_status out nocopy VARCHAR2
2267 , x_msg_count out nocopy NUMBER
2268 , x_msg_data out nocopy VARCHAR2
2269 , p6_a0 out nocopy NUMBER
2270 , p6_a1 out nocopy NUMBER
2271 , p6_a2 out nocopy VARCHAR2
2272 , p6_a3 out nocopy VARCHAR2
2273 , p6_a4 out nocopy VARCHAR2
2274 , p6_a5 out nocopy NUMBER
2275 , p6_a6 out nocopy DATE
2276 , p6_a7 out nocopy NUMBER
2277 , p6_a8 out nocopy NUMBER
2278 , p6_a9 out nocopy NUMBER
2279 , p6_a10 out nocopy NUMBER
2280 , p6_a11 out nocopy NUMBER
2281 , p6_a12 out nocopy NUMBER
2282 , p6_a13 out nocopy NUMBER
2283 , p6_a14 out nocopy VARCHAR2
2284 , p6_a15 out nocopy NUMBER
2285 , p6_a16 out nocopy NUMBER
2286 , p6_a17 out nocopy NUMBER
2287 , p6_a18 out nocopy NUMBER
2288 , p6_a19 out nocopy NUMBER
2289 , p6_a20 out nocopy NUMBER
2290 , p6_a21 out nocopy NUMBER
2291 , p6_a22 out nocopy NUMBER
2292 , p6_a23 out nocopy DATE
2293 , p6_a24 out nocopy NUMBER
2294 , p6_a25 out nocopy VARCHAR2
2295 , p6_a26 out nocopy VARCHAR2
2296 , p6_a27 out nocopy NUMBER
2297 , p6_a28 out nocopy NUMBER
2298 , p6_a29 out nocopy NUMBER
2299 , p6_a30 out nocopy VARCHAR2
2300 , p6_a31 out nocopy VARCHAR2
2301 , p6_a32 out nocopy VARCHAR2
2302 , p6_a33 out nocopy VARCHAR2
2303 , p6_a34 out nocopy VARCHAR2
2304 , p6_a35 out nocopy VARCHAR2
2305 , p6_a36 out nocopy VARCHAR2
2306 , p6_a37 out nocopy VARCHAR2
2307 , p6_a38 out nocopy VARCHAR2
2308 , p6_a39 out nocopy VARCHAR2
2309 , p6_a40 out nocopy VARCHAR2
2310 , p6_a41 out nocopy VARCHAR2
2311 , p6_a42 out nocopy VARCHAR2
2312 , p6_a43 out nocopy VARCHAR2
2313 , p6_a44 out nocopy VARCHAR2
2314 , p6_a45 out nocopy VARCHAR2
2315 , p6_a46 out nocopy DATE
2316 , p6_a47 out nocopy NUMBER
2317 , p6_a48 out nocopy NUMBER
2318 , p6_a49 out nocopy NUMBER
2319 , p6_a50 out nocopy DATE
2320 , p6_a51 out nocopy NUMBER
2324 , p6_a55 out nocopy DATE
2321 , p6_a52 out nocopy NUMBER
2322 , p6_a53 out nocopy DATE
2323 , p6_a54 out nocopy NUMBER
2325 , p6_a56 out nocopy NUMBER
2326 , p6_a57 out nocopy NUMBER
2327 , p6_a58 out nocopy VARCHAR2
2328 , p6_a59 out nocopy VARCHAR2
2329 , p6_a60 out nocopy VARCHAR2
2330 , p6_a61 out nocopy NUMBER
2331 , p6_a62 out nocopy VARCHAR2
2332 , p6_a63 out nocopy DATE
2333 , p6_a64 out nocopy VARCHAR2
2334 , p6_a65 out nocopy NUMBER
2335 , p6_a66 out nocopy NUMBER
2336 , p6_a67 out nocopy NUMBER
2337 , p6_a68 out nocopy NUMBER
2338 , p6_a69 out nocopy VARCHAR2
2339 , p6_a70 out nocopy VARCHAR2
2340 , p6_a71 out nocopy NUMBER
2341 , p6_a72 out nocopy VARCHAR2
2342 , p6_a73 out nocopy DATE
2343 , p5_a0 NUMBER := 0-1962.0724
2344 , p5_a1 NUMBER := 0-1962.0724
2345 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2346 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2347 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2348 , p5_a5 NUMBER := 0-1962.0724
2349 , p5_a6 DATE := fnd_api.g_miss_date
2350 , p5_a7 NUMBER := 0-1962.0724
2351 , p5_a8 NUMBER := 0-1962.0724
2352 , p5_a9 NUMBER := 0-1962.0724
2353 , p5_a10 NUMBER := 0-1962.0724
2354 , p5_a11 NUMBER := 0-1962.0724
2355 , p5_a12 NUMBER := 0-1962.0724
2356 , p5_a13 NUMBER := 0-1962.0724
2357 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2358 , p5_a15 NUMBER := 0-1962.0724
2359 , p5_a16 NUMBER := 0-1962.0724
2360 , p5_a17 NUMBER := 0-1962.0724
2361 , p5_a18 NUMBER := 0-1962.0724
2362 , p5_a19 NUMBER := 0-1962.0724
2363 , p5_a20 NUMBER := 0-1962.0724
2364 , p5_a21 NUMBER := 0-1962.0724
2365 , p5_a22 NUMBER := 0-1962.0724
2366 , p5_a23 DATE := fnd_api.g_miss_date
2367 , p5_a24 NUMBER := 0-1962.0724
2368 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2369 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2370 , p5_a27 NUMBER := 0-1962.0724
2371 , p5_a28 NUMBER := 0-1962.0724
2372 , p5_a29 NUMBER := 0-1962.0724
2373 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2374 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2375 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2376 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2377 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2378 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2379 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2380 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2381 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2382 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2383 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
2384 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
2385 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2386 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
2387 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
2388 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
2389 , p5_a46 DATE := fnd_api.g_miss_date
2390 , p5_a47 NUMBER := 0-1962.0724
2391 , p5_a48 NUMBER := 0-1962.0724
2392 , p5_a49 NUMBER := 0-1962.0724
2393 , p5_a50 DATE := fnd_api.g_miss_date
2394 , p5_a51 NUMBER := 0-1962.0724
2395 , p5_a52 NUMBER := 0-1962.0724
2396 , p5_a53 DATE := fnd_api.g_miss_date
2397 , p5_a54 NUMBER := 0-1962.0724
2398 , p5_a55 DATE := fnd_api.g_miss_date
2399 , p5_a56 NUMBER := 0-1962.0724
2400 , p5_a57 NUMBER := 0-1962.0724
2401 , p5_a58 VARCHAR2 := fnd_api.g_miss_char
2402 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
2403 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
2404 , p5_a61 NUMBER := 0-1962.0724
2405 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
2406 , p5_a63 DATE := fnd_api.g_miss_date
2407 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
2408 , p5_a65 NUMBER := 0-1962.0724
2409 , p5_a66 NUMBER := 0-1962.0724
2410 , p5_a67 NUMBER := 0-1962.0724
2411 , p5_a68 NUMBER := 0-1962.0724
2412 , p5_a69 VARCHAR2 := fnd_api.g_miss_char
2413 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
2414 , p5_a71 NUMBER := 0-1962.0724
2415 , p5_a72 VARCHAR2 := fnd_api.g_miss_char
2416 , p5_a73 DATE := fnd_api.g_miss_date
2417 )
2418
2419 as
2420 ddp_taiv_rec okl_tai_pvt.taiv_rec_type;
2421 ddx_taiv_rec okl_tai_pvt.taiv_rec_type;
2422 ddindx binary_integer; indx binary_integer;
2423 begin
2424
2425 -- copy data to the local IN or IN-OUT args, if any
2426
2427
2428
2429
2430
2431 ddp_taiv_rec.id := rosetta_g_miss_num_map(p5_a0);
2432 ddp_taiv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
2433 ddp_taiv_rec.sfwt_flag := p5_a2;
2434 ddp_taiv_rec.currency_code := p5_a3;
2435 ddp_taiv_rec.currency_conversion_type := p5_a4;
2436 ddp_taiv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a5);
2437 ddp_taiv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a6);
2438 ddp_taiv_rec.khr_id := rosetta_g_miss_num_map(p5_a7);
2439 ddp_taiv_rec.cra_id := rosetta_g_miss_num_map(p5_a8);
2440 ddp_taiv_rec.tap_id := rosetta_g_miss_num_map(p5_a9);
2441 ddp_taiv_rec.qte_id := rosetta_g_miss_num_map(p5_a10);
2442 ddp_taiv_rec.tcn_id := rosetta_g_miss_num_map(p5_a11);
2443 ddp_taiv_rec.tai_id_reverses := rosetta_g_miss_num_map(p5_a12);
2444 ddp_taiv_rec.ipy_id := rosetta_g_miss_num_map(p5_a13);
2445 ddp_taiv_rec.trx_status_code := p5_a14;
2449 ddp_taiv_rec.ixx_id := rosetta_g_miss_num_map(p5_a18);
2446 ddp_taiv_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a15);
2447 ddp_taiv_rec.try_id := rosetta_g_miss_num_map(p5_a16);
2448 ddp_taiv_rec.ibt_id := rosetta_g_miss_num_map(p5_a17);
2450 ddp_taiv_rec.irm_id := rosetta_g_miss_num_map(p5_a19);
2451 ddp_taiv_rec.irt_id := rosetta_g_miss_num_map(p5_a20);
2452 ddp_taiv_rec.svf_id := rosetta_g_miss_num_map(p5_a21);
2453 ddp_taiv_rec.amount := rosetta_g_miss_num_map(p5_a22);
2454 ddp_taiv_rec.date_invoiced := rosetta_g_miss_date_in_map(p5_a23);
2455 ddp_taiv_rec.amount_applied := rosetta_g_miss_num_map(p5_a24);
2456 ddp_taiv_rec.description := p5_a25;
2457 ddp_taiv_rec.trx_number := p5_a26;
2458 ddp_taiv_rec.clg_id := rosetta_g_miss_num_map(p5_a27);
2459 ddp_taiv_rec.pox_id := rosetta_g_miss_num_map(p5_a28);
2460 ddp_taiv_rec.cpy_id := rosetta_g_miss_num_map(p5_a29);
2461 ddp_taiv_rec.attribute_category := p5_a30;
2462 ddp_taiv_rec.attribute1 := p5_a31;
2463 ddp_taiv_rec.attribute2 := p5_a32;
2464 ddp_taiv_rec.attribute3 := p5_a33;
2465 ddp_taiv_rec.attribute4 := p5_a34;
2466 ddp_taiv_rec.attribute5 := p5_a35;
2467 ddp_taiv_rec.attribute6 := p5_a36;
2468 ddp_taiv_rec.attribute7 := p5_a37;
2469 ddp_taiv_rec.attribute8 := p5_a38;
2470 ddp_taiv_rec.attribute9 := p5_a39;
2471 ddp_taiv_rec.attribute10 := p5_a40;
2472 ddp_taiv_rec.attribute11 := p5_a41;
2473 ddp_taiv_rec.attribute12 := p5_a42;
2474 ddp_taiv_rec.attribute13 := p5_a43;
2475 ddp_taiv_rec.attribute14 := p5_a44;
2476 ddp_taiv_rec.attribute15 := p5_a45;
2477 ddp_taiv_rec.date_entered := rosetta_g_miss_date_in_map(p5_a46);
2478 ddp_taiv_rec.request_id := rosetta_g_miss_num_map(p5_a47);
2479 ddp_taiv_rec.program_application_id := rosetta_g_miss_num_map(p5_a48);
2480 ddp_taiv_rec.program_id := rosetta_g_miss_num_map(p5_a49);
2481 ddp_taiv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a50);
2482 ddp_taiv_rec.org_id := rosetta_g_miss_num_map(p5_a51);
2483 ddp_taiv_rec.created_by := rosetta_g_miss_num_map(p5_a52);
2484 ddp_taiv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a53);
2485 ddp_taiv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a54);
2486 ddp_taiv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a55);
2487 ddp_taiv_rec.last_update_login := rosetta_g_miss_num_map(p5_a56);
2488 ddp_taiv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a57);
2489 ddp_taiv_rec.investor_agreement_number := p5_a58;
2490 ddp_taiv_rec.investor_name := p5_a59;
2491 ddp_taiv_rec.okl_source_billing_trx := p5_a60;
2492 ddp_taiv_rec.inf_id := rosetta_g_miss_num_map(p5_a61);
2493 ddp_taiv_rec.invoice_pull_yn := p5_a62;
2494 ddp_taiv_rec.due_date := rosetta_g_miss_date_in_map(p5_a63);
2495 ddp_taiv_rec.consolidated_invoice_number := p5_a64;
2496 ddp_taiv_rec.isi_id := rosetta_g_miss_num_map(p5_a65);
2497 ddp_taiv_rec.receivables_invoice_id := rosetta_g_miss_num_map(p5_a66);
2498 ddp_taiv_rec.cust_trx_type_id := rosetta_g_miss_num_map(p5_a67);
2499 ddp_taiv_rec.customer_bank_account_id := rosetta_g_miss_num_map(p5_a68);
2500 ddp_taiv_rec.tax_exempt_flag := p5_a69;
2501 ddp_taiv_rec.tax_exempt_reason_code := p5_a70;
2502 ddp_taiv_rec.reference_line_id := rosetta_g_miss_num_map(p5_a71);
2503 ddp_taiv_rec.private_label := p5_a72;
2504 ddp_taiv_rec.transaction_date := rosetta_g_miss_date_in_map(p5_a73);
2505
2506
2507 -- here's the delegated call to the old PL/SQL routine
2508 okl_tai_pvt.update_row(p_api_version,
2509 p_init_msg_list,
2510 x_return_status,
2511 x_msg_count,
2512 x_msg_data,
2513 ddp_taiv_rec,
2514 ddx_taiv_rec);
2515
2516 -- copy data back from the local variables to OUT or IN-OUT args, if any
2517
2518
2519
2520
2521
2522
2523 p6_a0 := rosetta_g_miss_num_map(ddx_taiv_rec.id);
2524 p6_a1 := rosetta_g_miss_num_map(ddx_taiv_rec.object_version_number);
2525 p6_a2 := ddx_taiv_rec.sfwt_flag;
2526 p6_a3 := ddx_taiv_rec.currency_code;
2527 p6_a4 := ddx_taiv_rec.currency_conversion_type;
2528 p6_a5 := rosetta_g_miss_num_map(ddx_taiv_rec.currency_conversion_rate);
2529 p6_a6 := ddx_taiv_rec.currency_conversion_date;
2530 p6_a7 := rosetta_g_miss_num_map(ddx_taiv_rec.khr_id);
2531 p6_a8 := rosetta_g_miss_num_map(ddx_taiv_rec.cra_id);
2532 p6_a9 := rosetta_g_miss_num_map(ddx_taiv_rec.tap_id);
2533 p6_a10 := rosetta_g_miss_num_map(ddx_taiv_rec.qte_id);
2534 p6_a11 := rosetta_g_miss_num_map(ddx_taiv_rec.tcn_id);
2535 p6_a12 := rosetta_g_miss_num_map(ddx_taiv_rec.tai_id_reverses);
2536 p6_a13 := rosetta_g_miss_num_map(ddx_taiv_rec.ipy_id);
2537 p6_a14 := ddx_taiv_rec.trx_status_code;
2538 p6_a15 := rosetta_g_miss_num_map(ddx_taiv_rec.set_of_books_id);
2539 p6_a16 := rosetta_g_miss_num_map(ddx_taiv_rec.try_id);
2540 p6_a17 := rosetta_g_miss_num_map(ddx_taiv_rec.ibt_id);
2541 p6_a18 := rosetta_g_miss_num_map(ddx_taiv_rec.ixx_id);
2542 p6_a19 := rosetta_g_miss_num_map(ddx_taiv_rec.irm_id);
2543 p6_a20 := rosetta_g_miss_num_map(ddx_taiv_rec.irt_id);
2544 p6_a21 := rosetta_g_miss_num_map(ddx_taiv_rec.svf_id);
2545 p6_a22 := rosetta_g_miss_num_map(ddx_taiv_rec.amount);
2546 p6_a23 := ddx_taiv_rec.date_invoiced;
2547 p6_a24 := rosetta_g_miss_num_map(ddx_taiv_rec.amount_applied);
2548 p6_a25 := ddx_taiv_rec.description;
2549 p6_a26 := ddx_taiv_rec.trx_number;
2550 p6_a27 := rosetta_g_miss_num_map(ddx_taiv_rec.clg_id);
2554 p6_a31 := ddx_taiv_rec.attribute1;
2551 p6_a28 := rosetta_g_miss_num_map(ddx_taiv_rec.pox_id);
2552 p6_a29 := rosetta_g_miss_num_map(ddx_taiv_rec.cpy_id);
2553 p6_a30 := ddx_taiv_rec.attribute_category;
2555 p6_a32 := ddx_taiv_rec.attribute2;
2556 p6_a33 := ddx_taiv_rec.attribute3;
2557 p6_a34 := ddx_taiv_rec.attribute4;
2558 p6_a35 := ddx_taiv_rec.attribute5;
2559 p6_a36 := ddx_taiv_rec.attribute6;
2560 p6_a37 := ddx_taiv_rec.attribute7;
2561 p6_a38 := ddx_taiv_rec.attribute8;
2562 p6_a39 := ddx_taiv_rec.attribute9;
2563 p6_a40 := ddx_taiv_rec.attribute10;
2564 p6_a41 := ddx_taiv_rec.attribute11;
2565 p6_a42 := ddx_taiv_rec.attribute12;
2566 p6_a43 := ddx_taiv_rec.attribute13;
2567 p6_a44 := ddx_taiv_rec.attribute14;
2568 p6_a45 := ddx_taiv_rec.attribute15;
2569 p6_a46 := ddx_taiv_rec.date_entered;
2570 p6_a47 := rosetta_g_miss_num_map(ddx_taiv_rec.request_id);
2571 p6_a48 := rosetta_g_miss_num_map(ddx_taiv_rec.program_application_id);
2572 p6_a49 := rosetta_g_miss_num_map(ddx_taiv_rec.program_id);
2573 p6_a50 := ddx_taiv_rec.program_update_date;
2574 p6_a51 := rosetta_g_miss_num_map(ddx_taiv_rec.org_id);
2575 p6_a52 := rosetta_g_miss_num_map(ddx_taiv_rec.created_by);
2576 p6_a53 := ddx_taiv_rec.creation_date;
2577 p6_a54 := rosetta_g_miss_num_map(ddx_taiv_rec.last_updated_by);
2578 p6_a55 := ddx_taiv_rec.last_update_date;
2579 p6_a56 := rosetta_g_miss_num_map(ddx_taiv_rec.last_update_login);
2580 p6_a57 := rosetta_g_miss_num_map(ddx_taiv_rec.legal_entity_id);
2581 p6_a58 := ddx_taiv_rec.investor_agreement_number;
2582 p6_a59 := ddx_taiv_rec.investor_name;
2583 p6_a60 := ddx_taiv_rec.okl_source_billing_trx;
2584 p6_a61 := rosetta_g_miss_num_map(ddx_taiv_rec.inf_id);
2585 p6_a62 := ddx_taiv_rec.invoice_pull_yn;
2586 p6_a63 := ddx_taiv_rec.due_date;
2587 p6_a64 := ddx_taiv_rec.consolidated_invoice_number;
2588 p6_a65 := rosetta_g_miss_num_map(ddx_taiv_rec.isi_id);
2589 p6_a66 := rosetta_g_miss_num_map(ddx_taiv_rec.receivables_invoice_id);
2590 p6_a67 := rosetta_g_miss_num_map(ddx_taiv_rec.cust_trx_type_id);
2591 p6_a68 := rosetta_g_miss_num_map(ddx_taiv_rec.customer_bank_account_id);
2592 p6_a69 := ddx_taiv_rec.tax_exempt_flag;
2593 p6_a70 := ddx_taiv_rec.tax_exempt_reason_code;
2594 p6_a71 := rosetta_g_miss_num_map(ddx_taiv_rec.reference_line_id);
2595 p6_a72 := ddx_taiv_rec.private_label;
2596 p6_a73 := ddx_taiv_rec.transaction_date;
2597 end;
2598
2599 procedure update_row(p_api_version NUMBER
2600 , p_init_msg_list VARCHAR2
2601 , x_return_status out nocopy VARCHAR2
2602 , x_msg_count out nocopy NUMBER
2603 , x_msg_data out nocopy VARCHAR2
2604 , p5_a0 JTF_NUMBER_TABLE
2605 , p5_a1 JTF_NUMBER_TABLE
2606 , p5_a2 JTF_VARCHAR2_TABLE_100
2607 , p5_a3 JTF_VARCHAR2_TABLE_100
2608 , p5_a4 JTF_VARCHAR2_TABLE_100
2609 , p5_a5 JTF_NUMBER_TABLE
2610 , p5_a6 JTF_DATE_TABLE
2611 , p5_a7 JTF_NUMBER_TABLE
2612 , p5_a8 JTF_NUMBER_TABLE
2613 , p5_a9 JTF_NUMBER_TABLE
2614 , p5_a10 JTF_NUMBER_TABLE
2615 , p5_a11 JTF_NUMBER_TABLE
2616 , p5_a12 JTF_NUMBER_TABLE
2617 , p5_a13 JTF_NUMBER_TABLE
2618 , p5_a14 JTF_VARCHAR2_TABLE_100
2619 , p5_a15 JTF_NUMBER_TABLE
2620 , p5_a16 JTF_NUMBER_TABLE
2621 , p5_a17 JTF_NUMBER_TABLE
2622 , p5_a18 JTF_NUMBER_TABLE
2623 , p5_a19 JTF_NUMBER_TABLE
2624 , p5_a20 JTF_NUMBER_TABLE
2625 , p5_a21 JTF_NUMBER_TABLE
2626 , p5_a22 JTF_NUMBER_TABLE
2627 , p5_a23 JTF_DATE_TABLE
2628 , p5_a24 JTF_NUMBER_TABLE
2629 , p5_a25 JTF_VARCHAR2_TABLE_2000
2630 , p5_a26 JTF_VARCHAR2_TABLE_300
2631 , p5_a27 JTF_NUMBER_TABLE
2632 , p5_a28 JTF_NUMBER_TABLE
2633 , p5_a29 JTF_NUMBER_TABLE
2634 , p5_a30 JTF_VARCHAR2_TABLE_100
2635 , p5_a31 JTF_VARCHAR2_TABLE_500
2636 , p5_a32 JTF_VARCHAR2_TABLE_500
2637 , p5_a33 JTF_VARCHAR2_TABLE_500
2638 , p5_a34 JTF_VARCHAR2_TABLE_500
2639 , p5_a35 JTF_VARCHAR2_TABLE_500
2640 , p5_a36 JTF_VARCHAR2_TABLE_500
2641 , p5_a37 JTF_VARCHAR2_TABLE_500
2642 , p5_a38 JTF_VARCHAR2_TABLE_500
2643 , p5_a39 JTF_VARCHAR2_TABLE_500
2644 , p5_a40 JTF_VARCHAR2_TABLE_500
2645 , p5_a41 JTF_VARCHAR2_TABLE_500
2646 , p5_a42 JTF_VARCHAR2_TABLE_500
2647 , p5_a43 JTF_VARCHAR2_TABLE_500
2648 , p5_a44 JTF_VARCHAR2_TABLE_500
2649 , p5_a45 JTF_VARCHAR2_TABLE_500
2650 , p5_a46 JTF_DATE_TABLE
2651 , p5_a47 JTF_NUMBER_TABLE
2652 , p5_a48 JTF_NUMBER_TABLE
2653 , p5_a49 JTF_NUMBER_TABLE
2654 , p5_a50 JTF_DATE_TABLE
2655 , p5_a51 JTF_NUMBER_TABLE
2656 , p5_a52 JTF_NUMBER_TABLE
2657 , p5_a53 JTF_DATE_TABLE
2658 , p5_a54 JTF_NUMBER_TABLE
2659 , p5_a55 JTF_DATE_TABLE
2660 , p5_a56 JTF_NUMBER_TABLE
2661 , p5_a57 JTF_NUMBER_TABLE
2662 , p5_a58 JTF_VARCHAR2_TABLE_200
2663 , p5_a59 JTF_VARCHAR2_TABLE_400
2664 , p5_a60 JTF_VARCHAR2_TABLE_100
2665 , p5_a61 JTF_NUMBER_TABLE
2666 , p5_a62 JTF_VARCHAR2_TABLE_100
2667 , p5_a63 JTF_DATE_TABLE
2668 , p5_a64 JTF_VARCHAR2_TABLE_100
2669 , p5_a65 JTF_NUMBER_TABLE
2670 , p5_a66 JTF_NUMBER_TABLE
2671 , p5_a67 JTF_NUMBER_TABLE
2672 , p5_a68 JTF_NUMBER_TABLE
2673 , p5_a69 JTF_VARCHAR2_TABLE_100
2674 , p5_a70 JTF_VARCHAR2_TABLE_100
2675 , p5_a71 JTF_NUMBER_TABLE
2679 , p6_a1 out nocopy JTF_NUMBER_TABLE
2676 , p5_a72 JTF_VARCHAR2_TABLE_4000
2677 , p5_a73 JTF_DATE_TABLE
2678 , p6_a0 out nocopy JTF_NUMBER_TABLE
2680 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
2681 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2682 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
2683 , p6_a5 out nocopy JTF_NUMBER_TABLE
2684 , p6_a6 out nocopy JTF_DATE_TABLE
2685 , p6_a7 out nocopy JTF_NUMBER_TABLE
2686 , p6_a8 out nocopy JTF_NUMBER_TABLE
2687 , p6_a9 out nocopy JTF_NUMBER_TABLE
2688 , p6_a10 out nocopy JTF_NUMBER_TABLE
2689 , p6_a11 out nocopy JTF_NUMBER_TABLE
2690 , p6_a12 out nocopy JTF_NUMBER_TABLE
2691 , p6_a13 out nocopy JTF_NUMBER_TABLE
2692 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
2693 , p6_a15 out nocopy JTF_NUMBER_TABLE
2694 , p6_a16 out nocopy JTF_NUMBER_TABLE
2695 , p6_a17 out nocopy JTF_NUMBER_TABLE
2696 , p6_a18 out nocopy JTF_NUMBER_TABLE
2697 , p6_a19 out nocopy JTF_NUMBER_TABLE
2698 , p6_a20 out nocopy JTF_NUMBER_TABLE
2699 , p6_a21 out nocopy JTF_NUMBER_TABLE
2700 , p6_a22 out nocopy JTF_NUMBER_TABLE
2701 , p6_a23 out nocopy JTF_DATE_TABLE
2702 , p6_a24 out nocopy JTF_NUMBER_TABLE
2703 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000
2704 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
2705 , p6_a27 out nocopy JTF_NUMBER_TABLE
2706 , p6_a28 out nocopy JTF_NUMBER_TABLE
2707 , p6_a29 out nocopy JTF_NUMBER_TABLE
2708 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
2709 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
2710 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
2711 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
2712 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
2713 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
2714 , p6_a36 out nocopy JTF_VARCHAR2_TABLE_500
2715 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_500
2716 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_500
2717 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_500
2718 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_500
2719 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
2720 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
2721 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500
2722 , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
2723 , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
2724 , p6_a46 out nocopy JTF_DATE_TABLE
2725 , p6_a47 out nocopy JTF_NUMBER_TABLE
2726 , p6_a48 out nocopy JTF_NUMBER_TABLE
2727 , p6_a49 out nocopy JTF_NUMBER_TABLE
2728 , p6_a50 out nocopy JTF_DATE_TABLE
2729 , p6_a51 out nocopy JTF_NUMBER_TABLE
2730 , p6_a52 out nocopy JTF_NUMBER_TABLE
2731 , p6_a53 out nocopy JTF_DATE_TABLE
2732 , p6_a54 out nocopy JTF_NUMBER_TABLE
2733 , p6_a55 out nocopy JTF_DATE_TABLE
2734 , p6_a56 out nocopy JTF_NUMBER_TABLE
2735 , p6_a57 out nocopy JTF_NUMBER_TABLE
2736 , p6_a58 out nocopy JTF_VARCHAR2_TABLE_200
2737 , p6_a59 out nocopy JTF_VARCHAR2_TABLE_400
2738 , p6_a60 out nocopy JTF_VARCHAR2_TABLE_100
2739 , p6_a61 out nocopy JTF_NUMBER_TABLE
2740 , p6_a62 out nocopy JTF_VARCHAR2_TABLE_100
2741 , p6_a63 out nocopy JTF_DATE_TABLE
2742 , p6_a64 out nocopy JTF_VARCHAR2_TABLE_100
2743 , p6_a65 out nocopy JTF_NUMBER_TABLE
2744 , p6_a66 out nocopy JTF_NUMBER_TABLE
2745 , p6_a67 out nocopy JTF_NUMBER_TABLE
2746 , p6_a68 out nocopy JTF_NUMBER_TABLE
2747 , p6_a69 out nocopy JTF_VARCHAR2_TABLE_100
2748 , p6_a70 out nocopy JTF_VARCHAR2_TABLE_100
2749 , p6_a71 out nocopy JTF_NUMBER_TABLE
2750 , p6_a72 out nocopy JTF_VARCHAR2_TABLE_4000
2751 , p6_a73 out nocopy JTF_DATE_TABLE
2752 )
2753
2754 as
2755 ddp_taiv_tbl okl_tai_pvt.taiv_tbl_type;
2756 ddx_taiv_tbl okl_tai_pvt.taiv_tbl_type;
2757 ddindx binary_integer; indx binary_integer;
2758 begin
2759
2760 -- copy data to the local IN or IN-OUT args, if any
2761
2762
2763
2764
2765
2766 okl_tai_pvt_w.rosetta_table_copy_in_p8(ddp_taiv_tbl, p5_a0
2767 , p5_a1
2768 , p5_a2
2769 , p5_a3
2770 , p5_a4
2771 , p5_a5
2772 , p5_a6
2773 , p5_a7
2774 , p5_a8
2775 , p5_a9
2776 , p5_a10
2777 , p5_a11
2778 , p5_a12
2779 , p5_a13
2780 , p5_a14
2781 , p5_a15
2782 , p5_a16
2783 , p5_a17
2784 , p5_a18
2785 , p5_a19
2786 , p5_a20
2787 , p5_a21
2788 , p5_a22
2789 , p5_a23
2790 , p5_a24
2791 , p5_a25
2792 , p5_a26
2793 , p5_a27
2794 , p5_a28
2795 , p5_a29
2796 , p5_a30
2797 , p5_a31
2798 , p5_a32
2799 , p5_a33
2800 , p5_a34
2801 , p5_a35
2802 , p5_a36
2803 , p5_a37
2804 , p5_a38
2805 , p5_a39
2806 , p5_a40
2807 , p5_a41
2808 , p5_a42
2809 , p5_a43
2810 , p5_a44
2811 , p5_a45
2812 , p5_a46
2813 , p5_a47
2814 , p5_a48
2815 , p5_a49
2816 , p5_a50
2817 , p5_a51
2818 , p5_a52
2819 , p5_a53
2820 , p5_a54
2821 , p5_a55
2822 , p5_a56
2823 , p5_a57
2824 , p5_a58
2825 , p5_a59
2829 , p5_a63
2826 , p5_a60
2827 , p5_a61
2828 , p5_a62
2830 , p5_a64
2831 , p5_a65
2832 , p5_a66
2833 , p5_a67
2834 , p5_a68
2835 , p5_a69
2836 , p5_a70
2837 , p5_a71
2838 , p5_a72
2839 , p5_a73
2840 );
2841
2842
2843 -- here's the delegated call to the old PL/SQL routine
2844 okl_tai_pvt.update_row(p_api_version,
2845 p_init_msg_list,
2846 x_return_status,
2847 x_msg_count,
2848 x_msg_data,
2849 ddp_taiv_tbl,
2850 ddx_taiv_tbl);
2851
2852 -- copy data back from the local variables to OUT or IN-OUT args, if any
2853
2854
2855
2856
2857
2858
2859 okl_tai_pvt_w.rosetta_table_copy_out_p8(ddx_taiv_tbl, p6_a0
2860 , p6_a1
2861 , p6_a2
2862 , p6_a3
2863 , p6_a4
2864 , p6_a5
2865 , p6_a6
2866 , p6_a7
2867 , p6_a8
2868 , p6_a9
2869 , p6_a10
2870 , p6_a11
2871 , p6_a12
2872 , p6_a13
2873 , p6_a14
2874 , p6_a15
2875 , p6_a16
2876 , p6_a17
2877 , p6_a18
2878 , p6_a19
2879 , p6_a20
2880 , p6_a21
2881 , p6_a22
2882 , p6_a23
2883 , p6_a24
2884 , p6_a25
2885 , p6_a26
2886 , p6_a27
2887 , p6_a28
2888 , p6_a29
2889 , p6_a30
2890 , p6_a31
2891 , p6_a32
2892 , p6_a33
2893 , p6_a34
2894 , p6_a35
2895 , p6_a36
2896 , p6_a37
2897 , p6_a38
2898 , p6_a39
2899 , p6_a40
2900 , p6_a41
2901 , p6_a42
2902 , p6_a43
2903 , p6_a44
2904 , p6_a45
2905 , p6_a46
2906 , p6_a47
2907 , p6_a48
2908 , p6_a49
2909 , p6_a50
2910 , p6_a51
2911 , p6_a52
2912 , p6_a53
2913 , p6_a54
2914 , p6_a55
2915 , p6_a56
2916 , p6_a57
2917 , p6_a58
2918 , p6_a59
2919 , p6_a60
2920 , p6_a61
2921 , p6_a62
2922 , p6_a63
2923 , p6_a64
2924 , p6_a65
2925 , p6_a66
2926 , p6_a67
2927 , p6_a68
2928 , p6_a69
2929 , p6_a70
2930 , p6_a71
2931 , p6_a72
2932 , p6_a73
2933 );
2934 end;
2935
2936 procedure delete_row(p_api_version NUMBER
2937 , p_init_msg_list VARCHAR2
2938 , x_return_status out nocopy VARCHAR2
2939 , x_msg_count out nocopy NUMBER
2940 , x_msg_data out nocopy VARCHAR2
2941 , p5_a0 NUMBER := 0-1962.0724
2942 , p5_a1 NUMBER := 0-1962.0724
2943 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2944 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2945 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2946 , p5_a5 NUMBER := 0-1962.0724
2947 , p5_a6 DATE := fnd_api.g_miss_date
2948 , p5_a7 NUMBER := 0-1962.0724
2949 , p5_a8 NUMBER := 0-1962.0724
2950 , p5_a9 NUMBER := 0-1962.0724
2951 , p5_a10 NUMBER := 0-1962.0724
2952 , p5_a11 NUMBER := 0-1962.0724
2953 , p5_a12 NUMBER := 0-1962.0724
2954 , p5_a13 NUMBER := 0-1962.0724
2955 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2956 , p5_a15 NUMBER := 0-1962.0724
2957 , p5_a16 NUMBER := 0-1962.0724
2958 , p5_a17 NUMBER := 0-1962.0724
2959 , p5_a18 NUMBER := 0-1962.0724
2960 , p5_a19 NUMBER := 0-1962.0724
2961 , p5_a20 NUMBER := 0-1962.0724
2962 , p5_a21 NUMBER := 0-1962.0724
2963 , p5_a22 NUMBER := 0-1962.0724
2964 , p5_a23 DATE := fnd_api.g_miss_date
2965 , p5_a24 NUMBER := 0-1962.0724
2966 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2967 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2968 , p5_a27 NUMBER := 0-1962.0724
2969 , p5_a28 NUMBER := 0-1962.0724
2970 , p5_a29 NUMBER := 0-1962.0724
2971 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2972 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2973 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2974 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2975 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2976 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2977 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2978 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2979 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2980 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2981 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
2982 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
2983 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2984 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
2985 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
2986 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
2987 , p5_a46 DATE := fnd_api.g_miss_date
2988 , p5_a47 NUMBER := 0-1962.0724
2989 , p5_a48 NUMBER := 0-1962.0724
2990 , p5_a49 NUMBER := 0-1962.0724
2991 , p5_a50 DATE := fnd_api.g_miss_date
2992 , p5_a51 NUMBER := 0-1962.0724
2993 , p5_a52 NUMBER := 0-1962.0724
2994 , p5_a53 DATE := fnd_api.g_miss_date
2995 , p5_a54 NUMBER := 0-1962.0724
2996 , p5_a55 DATE := fnd_api.g_miss_date
2997 , p5_a56 NUMBER := 0-1962.0724
2998 , p5_a57 NUMBER := 0-1962.0724
2999 , p5_a58 VARCHAR2 := fnd_api.g_miss_char
3000 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
3001 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
3002 , p5_a61 NUMBER := 0-1962.0724
3006 , p5_a65 NUMBER := 0-1962.0724
3003 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
3004 , p5_a63 DATE := fnd_api.g_miss_date
3005 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
3007 , p5_a66 NUMBER := 0-1962.0724
3008 , p5_a67 NUMBER := 0-1962.0724
3009 , p5_a68 NUMBER := 0-1962.0724
3010 , p5_a69 VARCHAR2 := fnd_api.g_miss_char
3011 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
3012 , p5_a71 NUMBER := 0-1962.0724
3013 , p5_a72 VARCHAR2 := fnd_api.g_miss_char
3014 , p5_a73 DATE := fnd_api.g_miss_date
3015 )
3016
3017 as
3018 ddp_taiv_rec okl_tai_pvt.taiv_rec_type;
3019 ddindx binary_integer; indx binary_integer;
3020 begin
3021
3022 -- copy data to the local IN or IN-OUT args, if any
3023
3024
3025
3026
3027
3028 ddp_taiv_rec.id := rosetta_g_miss_num_map(p5_a0);
3029 ddp_taiv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
3030 ddp_taiv_rec.sfwt_flag := p5_a2;
3031 ddp_taiv_rec.currency_code := p5_a3;
3032 ddp_taiv_rec.currency_conversion_type := p5_a4;
3033 ddp_taiv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a5);
3034 ddp_taiv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a6);
3035 ddp_taiv_rec.khr_id := rosetta_g_miss_num_map(p5_a7);
3036 ddp_taiv_rec.cra_id := rosetta_g_miss_num_map(p5_a8);
3037 ddp_taiv_rec.tap_id := rosetta_g_miss_num_map(p5_a9);
3038 ddp_taiv_rec.qte_id := rosetta_g_miss_num_map(p5_a10);
3039 ddp_taiv_rec.tcn_id := rosetta_g_miss_num_map(p5_a11);
3040 ddp_taiv_rec.tai_id_reverses := rosetta_g_miss_num_map(p5_a12);
3041 ddp_taiv_rec.ipy_id := rosetta_g_miss_num_map(p5_a13);
3042 ddp_taiv_rec.trx_status_code := p5_a14;
3043 ddp_taiv_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a15);
3044 ddp_taiv_rec.try_id := rosetta_g_miss_num_map(p5_a16);
3045 ddp_taiv_rec.ibt_id := rosetta_g_miss_num_map(p5_a17);
3046 ddp_taiv_rec.ixx_id := rosetta_g_miss_num_map(p5_a18);
3047 ddp_taiv_rec.irm_id := rosetta_g_miss_num_map(p5_a19);
3048 ddp_taiv_rec.irt_id := rosetta_g_miss_num_map(p5_a20);
3049 ddp_taiv_rec.svf_id := rosetta_g_miss_num_map(p5_a21);
3050 ddp_taiv_rec.amount := rosetta_g_miss_num_map(p5_a22);
3051 ddp_taiv_rec.date_invoiced := rosetta_g_miss_date_in_map(p5_a23);
3052 ddp_taiv_rec.amount_applied := rosetta_g_miss_num_map(p5_a24);
3053 ddp_taiv_rec.description := p5_a25;
3054 ddp_taiv_rec.trx_number := p5_a26;
3055 ddp_taiv_rec.clg_id := rosetta_g_miss_num_map(p5_a27);
3056 ddp_taiv_rec.pox_id := rosetta_g_miss_num_map(p5_a28);
3057 ddp_taiv_rec.cpy_id := rosetta_g_miss_num_map(p5_a29);
3058 ddp_taiv_rec.attribute_category := p5_a30;
3059 ddp_taiv_rec.attribute1 := p5_a31;
3060 ddp_taiv_rec.attribute2 := p5_a32;
3061 ddp_taiv_rec.attribute3 := p5_a33;
3062 ddp_taiv_rec.attribute4 := p5_a34;
3063 ddp_taiv_rec.attribute5 := p5_a35;
3064 ddp_taiv_rec.attribute6 := p5_a36;
3065 ddp_taiv_rec.attribute7 := p5_a37;
3066 ddp_taiv_rec.attribute8 := p5_a38;
3067 ddp_taiv_rec.attribute9 := p5_a39;
3068 ddp_taiv_rec.attribute10 := p5_a40;
3069 ddp_taiv_rec.attribute11 := p5_a41;
3070 ddp_taiv_rec.attribute12 := p5_a42;
3071 ddp_taiv_rec.attribute13 := p5_a43;
3072 ddp_taiv_rec.attribute14 := p5_a44;
3073 ddp_taiv_rec.attribute15 := p5_a45;
3074 ddp_taiv_rec.date_entered := rosetta_g_miss_date_in_map(p5_a46);
3075 ddp_taiv_rec.request_id := rosetta_g_miss_num_map(p5_a47);
3076 ddp_taiv_rec.program_application_id := rosetta_g_miss_num_map(p5_a48);
3077 ddp_taiv_rec.program_id := rosetta_g_miss_num_map(p5_a49);
3078 ddp_taiv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a50);
3079 ddp_taiv_rec.org_id := rosetta_g_miss_num_map(p5_a51);
3080 ddp_taiv_rec.created_by := rosetta_g_miss_num_map(p5_a52);
3081 ddp_taiv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a53);
3082 ddp_taiv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a54);
3083 ddp_taiv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a55);
3084 ddp_taiv_rec.last_update_login := rosetta_g_miss_num_map(p5_a56);
3085 ddp_taiv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a57);
3086 ddp_taiv_rec.investor_agreement_number := p5_a58;
3087 ddp_taiv_rec.investor_name := p5_a59;
3088 ddp_taiv_rec.okl_source_billing_trx := p5_a60;
3092 ddp_taiv_rec.consolidated_invoice_number := p5_a64;
3089 ddp_taiv_rec.inf_id := rosetta_g_miss_num_map(p5_a61);
3090 ddp_taiv_rec.invoice_pull_yn := p5_a62;
3091 ddp_taiv_rec.due_date := rosetta_g_miss_date_in_map(p5_a63);
3093 ddp_taiv_rec.isi_id := rosetta_g_miss_num_map(p5_a65);
3094 ddp_taiv_rec.receivables_invoice_id := rosetta_g_miss_num_map(p5_a66);
3095 ddp_taiv_rec.cust_trx_type_id := rosetta_g_miss_num_map(p5_a67);
3096 ddp_taiv_rec.customer_bank_account_id := rosetta_g_miss_num_map(p5_a68);
3097 ddp_taiv_rec.tax_exempt_flag := p5_a69;
3098 ddp_taiv_rec.tax_exempt_reason_code := p5_a70;
3099 ddp_taiv_rec.reference_line_id := rosetta_g_miss_num_map(p5_a71);
3100 ddp_taiv_rec.private_label := p5_a72;
3101 ddp_taiv_rec.transaction_date := rosetta_g_miss_date_in_map(p5_a73);
3102
3103 -- here's the delegated call to the old PL/SQL routine
3104 okl_tai_pvt.delete_row(p_api_version,
3105 p_init_msg_list,
3106 x_return_status,
3107 x_msg_count,
3108 x_msg_data,
3109 ddp_taiv_rec);
3110
3111 -- copy data back from the local variables to OUT or IN-OUT args, if any
3112
3113
3114
3115
3116
3117 end;
3118
3119 procedure delete_row(p_api_version NUMBER
3120 , p_init_msg_list VARCHAR2
3121 , x_return_status out nocopy VARCHAR2
3122 , x_msg_count out nocopy NUMBER
3123 , x_msg_data out nocopy VARCHAR2
3124 , p5_a0 JTF_NUMBER_TABLE
3125 , p5_a1 JTF_NUMBER_TABLE
3126 , p5_a2 JTF_VARCHAR2_TABLE_100
3127 , p5_a3 JTF_VARCHAR2_TABLE_100
3128 , p5_a4 JTF_VARCHAR2_TABLE_100
3129 , p5_a5 JTF_NUMBER_TABLE
3130 , p5_a6 JTF_DATE_TABLE
3131 , p5_a7 JTF_NUMBER_TABLE
3132 , p5_a8 JTF_NUMBER_TABLE
3133 , p5_a9 JTF_NUMBER_TABLE
3134 , p5_a10 JTF_NUMBER_TABLE
3135 , p5_a11 JTF_NUMBER_TABLE
3136 , p5_a12 JTF_NUMBER_TABLE
3137 , p5_a13 JTF_NUMBER_TABLE
3138 , p5_a14 JTF_VARCHAR2_TABLE_100
3139 , p5_a15 JTF_NUMBER_TABLE
3140 , p5_a16 JTF_NUMBER_TABLE
3141 , p5_a17 JTF_NUMBER_TABLE
3142 , p5_a18 JTF_NUMBER_TABLE
3143 , p5_a19 JTF_NUMBER_TABLE
3144 , p5_a20 JTF_NUMBER_TABLE
3145 , p5_a21 JTF_NUMBER_TABLE
3146 , p5_a22 JTF_NUMBER_TABLE
3147 , p5_a23 JTF_DATE_TABLE
3148 , p5_a24 JTF_NUMBER_TABLE
3149 , p5_a25 JTF_VARCHAR2_TABLE_2000
3150 , p5_a26 JTF_VARCHAR2_TABLE_300
3151 , p5_a27 JTF_NUMBER_TABLE
3152 , p5_a28 JTF_NUMBER_TABLE
3153 , p5_a29 JTF_NUMBER_TABLE
3154 , p5_a30 JTF_VARCHAR2_TABLE_100
3155 , p5_a31 JTF_VARCHAR2_TABLE_500
3156 , p5_a32 JTF_VARCHAR2_TABLE_500
3157 , p5_a33 JTF_VARCHAR2_TABLE_500
3158 , p5_a34 JTF_VARCHAR2_TABLE_500
3159 , p5_a35 JTF_VARCHAR2_TABLE_500
3160 , p5_a36 JTF_VARCHAR2_TABLE_500
3161 , p5_a37 JTF_VARCHAR2_TABLE_500
3162 , p5_a38 JTF_VARCHAR2_TABLE_500
3163 , p5_a39 JTF_VARCHAR2_TABLE_500
3164 , p5_a40 JTF_VARCHAR2_TABLE_500
3165 , p5_a41 JTF_VARCHAR2_TABLE_500
3166 , p5_a42 JTF_VARCHAR2_TABLE_500
3167 , p5_a43 JTF_VARCHAR2_TABLE_500
3168 , p5_a44 JTF_VARCHAR2_TABLE_500
3169 , p5_a45 JTF_VARCHAR2_TABLE_500
3170 , p5_a46 JTF_DATE_TABLE
3171 , p5_a47 JTF_NUMBER_TABLE
3172 , p5_a48 JTF_NUMBER_TABLE
3173 , p5_a49 JTF_NUMBER_TABLE
3174 , p5_a50 JTF_DATE_TABLE
3175 , p5_a51 JTF_NUMBER_TABLE
3176 , p5_a52 JTF_NUMBER_TABLE
3177 , p5_a53 JTF_DATE_TABLE
3178 , p5_a54 JTF_NUMBER_TABLE
3179 , p5_a55 JTF_DATE_TABLE
3180 , p5_a56 JTF_NUMBER_TABLE
3181 , p5_a57 JTF_NUMBER_TABLE
3182 , p5_a58 JTF_VARCHAR2_TABLE_200
3183 , p5_a59 JTF_VARCHAR2_TABLE_400
3184 , p5_a60 JTF_VARCHAR2_TABLE_100
3185 , p5_a61 JTF_NUMBER_TABLE
3186 , p5_a62 JTF_VARCHAR2_TABLE_100
3187 , p5_a63 JTF_DATE_TABLE
3188 , p5_a64 JTF_VARCHAR2_TABLE_100
3189 , p5_a65 JTF_NUMBER_TABLE
3190 , p5_a66 JTF_NUMBER_TABLE
3191 , p5_a67 JTF_NUMBER_TABLE
3192 , p5_a68 JTF_NUMBER_TABLE
3193 , p5_a69 JTF_VARCHAR2_TABLE_100
3194 , p5_a70 JTF_VARCHAR2_TABLE_100
3195 , p5_a71 JTF_NUMBER_TABLE
3196 , p5_a72 JTF_VARCHAR2_TABLE_4000
3197 , p5_a73 JTF_DATE_TABLE
3198 )
3199
3200 as
3201 ddp_taiv_tbl okl_tai_pvt.taiv_tbl_type;
3202 ddindx binary_integer; indx binary_integer;
3203 begin
3204
3205 -- copy data to the local IN or IN-OUT args, if any
3206
3207
3208
3209
3210
3211 okl_tai_pvt_w.rosetta_table_copy_in_p8(ddp_taiv_tbl, p5_a0
3212 , p5_a1
3213 , p5_a2
3214 , p5_a3
3215 , p5_a4
3216 , p5_a5
3217 , p5_a6
3218 , p5_a7
3219 , p5_a8
3220 , p5_a9
3221 , p5_a10
3222 , p5_a11
3223 , p5_a12
3224 , p5_a13
3225 , p5_a14
3226 , p5_a15
3227 , p5_a16
3228 , p5_a17
3229 , p5_a18
3230 , p5_a19
3231 , p5_a20
3232 , p5_a21
3233 , p5_a22
3234 , p5_a23
3235 , p5_a24
3236 , p5_a25
3237 , p5_a26
3238 , p5_a27
3239 , p5_a28
3240 , p5_a29
3241 , p5_a30
3242 , p5_a31
3243 , p5_a32
3244 , p5_a33
3245 , p5_a34
3246 , p5_a35
3247 , p5_a36
3248 , p5_a37
3249 , p5_a38
3250 , p5_a39
3251 , p5_a40
3252 , p5_a41
3253 , p5_a42
3254 , p5_a43
3255 , p5_a44
3256 , p5_a45
3257 , p5_a46
3258 , p5_a47
3259 , p5_a48
3260 , p5_a49
3261 , p5_a50
3262 , p5_a51
3263 , p5_a52
3267 , p5_a56
3264 , p5_a53
3265 , p5_a54
3266 , p5_a55
3268 , p5_a57
3269 , p5_a58
3270 , p5_a59
3271 , p5_a60
3272 , p5_a61
3273 , p5_a62
3274 , p5_a63
3275 , p5_a64
3276 , p5_a65
3277 , p5_a66
3278 , p5_a67
3279 , p5_a68
3280 , p5_a69
3281 , p5_a70
3282 , p5_a71
3283 , p5_a72
3284 , p5_a73
3285 );
3286
3287 -- here's the delegated call to the old PL/SQL routine
3288 okl_tai_pvt.delete_row(p_api_version,
3289 p_init_msg_list,
3290 x_return_status,
3291 x_msg_count,
3292 x_msg_data,
3293 ddp_taiv_tbl);
3294
3295 -- copy data back from the local variables to OUT or IN-OUT args, if any
3296
3297
3298
3299
3300
3301 end;
3302
3303 procedure validate_row(p_api_version NUMBER
3304 , p_init_msg_list VARCHAR2
3305 , x_return_status out nocopy VARCHAR2
3306 , x_msg_count out nocopy NUMBER
3307 , x_msg_data out nocopy VARCHAR2
3308 , p5_a0 NUMBER := 0-1962.0724
3309 , p5_a1 NUMBER := 0-1962.0724
3310 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
3311 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
3312 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
3313 , p5_a5 NUMBER := 0-1962.0724
3314 , p5_a6 DATE := fnd_api.g_miss_date
3315 , p5_a7 NUMBER := 0-1962.0724
3316 , p5_a8 NUMBER := 0-1962.0724
3317 , p5_a9 NUMBER := 0-1962.0724
3318 , p5_a10 NUMBER := 0-1962.0724
3319 , p5_a11 NUMBER := 0-1962.0724
3320 , p5_a12 NUMBER := 0-1962.0724
3321 , p5_a13 NUMBER := 0-1962.0724
3322 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
3323 , p5_a15 NUMBER := 0-1962.0724
3324 , p5_a16 NUMBER := 0-1962.0724
3325 , p5_a17 NUMBER := 0-1962.0724
3326 , p5_a18 NUMBER := 0-1962.0724
3327 , p5_a19 NUMBER := 0-1962.0724
3328 , p5_a20 NUMBER := 0-1962.0724
3329 , p5_a21 NUMBER := 0-1962.0724
3330 , p5_a22 NUMBER := 0-1962.0724
3331 , p5_a23 DATE := fnd_api.g_miss_date
3332 , p5_a24 NUMBER := 0-1962.0724
3333 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
3334 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
3335 , p5_a27 NUMBER := 0-1962.0724
3336 , p5_a28 NUMBER := 0-1962.0724
3337 , p5_a29 NUMBER := 0-1962.0724
3338 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
3339 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
3340 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
3341 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
3342 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
3343 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
3344 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
3345 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
3346 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
3347 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
3348 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
3349 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
3350 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
3351 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
3352 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
3353 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
3354 , p5_a46 DATE := fnd_api.g_miss_date
3355 , p5_a47 NUMBER := 0-1962.0724
3356 , p5_a48 NUMBER := 0-1962.0724
3357 , p5_a49 NUMBER := 0-1962.0724
3358 , p5_a50 DATE := fnd_api.g_miss_date
3359 , p5_a51 NUMBER := 0-1962.0724
3360 , p5_a52 NUMBER := 0-1962.0724
3361 , p5_a53 DATE := fnd_api.g_miss_date
3362 , p5_a54 NUMBER := 0-1962.0724
3363 , p5_a55 DATE := fnd_api.g_miss_date
3364 , p5_a56 NUMBER := 0-1962.0724
3365 , p5_a57 NUMBER := 0-1962.0724
3366 , p5_a58 VARCHAR2 := fnd_api.g_miss_char
3367 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
3368 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
3369 , p5_a61 NUMBER := 0-1962.0724
3370 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
3371 , p5_a63 DATE := fnd_api.g_miss_date
3372 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
3373 , p5_a65 NUMBER := 0-1962.0724
3374 , p5_a66 NUMBER := 0-1962.0724
3375 , p5_a67 NUMBER := 0-1962.0724
3376 , p5_a68 NUMBER := 0-1962.0724
3377 , p5_a69 VARCHAR2 := fnd_api.g_miss_char
3378 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
3379 , p5_a71 NUMBER := 0-1962.0724
3380 , p5_a72 VARCHAR2 := fnd_api.g_miss_char
3381 , p5_a73 DATE := fnd_api.g_miss_date
3382 )
3383
3384 as
3385 ddp_taiv_rec okl_tai_pvt.taiv_rec_type;
3386 ddindx binary_integer; indx binary_integer;
3387 begin
3388
3389 -- copy data to the local IN or IN-OUT args, if any
3390
3391
3392
3393
3394
3395 ddp_taiv_rec.id := rosetta_g_miss_num_map(p5_a0);
3396 ddp_taiv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
3397 ddp_taiv_rec.sfwt_flag := p5_a2;
3398 ddp_taiv_rec.currency_code := p5_a3;
3399 ddp_taiv_rec.currency_conversion_type := p5_a4;
3400 ddp_taiv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a5);
3401 ddp_taiv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a6);
3402 ddp_taiv_rec.khr_id := rosetta_g_miss_num_map(p5_a7);
3403 ddp_taiv_rec.cra_id := rosetta_g_miss_num_map(p5_a8);
3404 ddp_taiv_rec.tap_id := rosetta_g_miss_num_map(p5_a9);
3405 ddp_taiv_rec.qte_id := rosetta_g_miss_num_map(p5_a10);
3406 ddp_taiv_rec.tcn_id := rosetta_g_miss_num_map(p5_a11);
3407 ddp_taiv_rec.tai_id_reverses := rosetta_g_miss_num_map(p5_a12);
3408 ddp_taiv_rec.ipy_id := rosetta_g_miss_num_map(p5_a13);
3409 ddp_taiv_rec.trx_status_code := p5_a14;
3410 ddp_taiv_rec.set_of_books_id := rosetta_g_miss_num_map(p5_a15);
3411 ddp_taiv_rec.try_id := rosetta_g_miss_num_map(p5_a16);
3412 ddp_taiv_rec.ibt_id := rosetta_g_miss_num_map(p5_a17);
3416 ddp_taiv_rec.svf_id := rosetta_g_miss_num_map(p5_a21);
3413 ddp_taiv_rec.ixx_id := rosetta_g_miss_num_map(p5_a18);
3414 ddp_taiv_rec.irm_id := rosetta_g_miss_num_map(p5_a19);
3415 ddp_taiv_rec.irt_id := rosetta_g_miss_num_map(p5_a20);
3417 ddp_taiv_rec.amount := rosetta_g_miss_num_map(p5_a22);
3418 ddp_taiv_rec.date_invoiced := rosetta_g_miss_date_in_map(p5_a23);
3419 ddp_taiv_rec.amount_applied := rosetta_g_miss_num_map(p5_a24);
3420 ddp_taiv_rec.description := p5_a25;
3421 ddp_taiv_rec.trx_number := p5_a26;
3422 ddp_taiv_rec.clg_id := rosetta_g_miss_num_map(p5_a27);
3423 ddp_taiv_rec.pox_id := rosetta_g_miss_num_map(p5_a28);
3424 ddp_taiv_rec.cpy_id := rosetta_g_miss_num_map(p5_a29);
3425 ddp_taiv_rec.attribute_category := p5_a30;
3426 ddp_taiv_rec.attribute1 := p5_a31;
3427 ddp_taiv_rec.attribute2 := p5_a32;
3428 ddp_taiv_rec.attribute3 := p5_a33;
3429 ddp_taiv_rec.attribute4 := p5_a34;
3430 ddp_taiv_rec.attribute5 := p5_a35;
3431 ddp_taiv_rec.attribute6 := p5_a36;
3432 ddp_taiv_rec.attribute7 := p5_a37;
3433 ddp_taiv_rec.attribute8 := p5_a38;
3434 ddp_taiv_rec.attribute9 := p5_a39;
3435 ddp_taiv_rec.attribute10 := p5_a40;
3436 ddp_taiv_rec.attribute11 := p5_a41;
3437 ddp_taiv_rec.attribute12 := p5_a42;
3438 ddp_taiv_rec.attribute13 := p5_a43;
3439 ddp_taiv_rec.attribute14 := p5_a44;
3440 ddp_taiv_rec.attribute15 := p5_a45;
3441 ddp_taiv_rec.date_entered := rosetta_g_miss_date_in_map(p5_a46);
3442 ddp_taiv_rec.request_id := rosetta_g_miss_num_map(p5_a47);
3443 ddp_taiv_rec.program_application_id := rosetta_g_miss_num_map(p5_a48);
3444 ddp_taiv_rec.program_id := rosetta_g_miss_num_map(p5_a49);
3445 ddp_taiv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a50);
3446 ddp_taiv_rec.org_id := rosetta_g_miss_num_map(p5_a51);
3447 ddp_taiv_rec.created_by := rosetta_g_miss_num_map(p5_a52);
3448 ddp_taiv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a53);
3449 ddp_taiv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a54);
3450 ddp_taiv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a55);
3451 ddp_taiv_rec.last_update_login := rosetta_g_miss_num_map(p5_a56);
3452 ddp_taiv_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a57);
3453 ddp_taiv_rec.investor_agreement_number := p5_a58;
3454 ddp_taiv_rec.investor_name := p5_a59;
3455 ddp_taiv_rec.okl_source_billing_trx := p5_a60;
3456 ddp_taiv_rec.inf_id := rosetta_g_miss_num_map(p5_a61);
3457 ddp_taiv_rec.invoice_pull_yn := p5_a62;
3458 ddp_taiv_rec.due_date := rosetta_g_miss_date_in_map(p5_a63);
3459 ddp_taiv_rec.consolidated_invoice_number := p5_a64;
3460 ddp_taiv_rec.isi_id := rosetta_g_miss_num_map(p5_a65);
3461 ddp_taiv_rec.receivables_invoice_id := rosetta_g_miss_num_map(p5_a66);
3462 ddp_taiv_rec.cust_trx_type_id := rosetta_g_miss_num_map(p5_a67);
3463 ddp_taiv_rec.customer_bank_account_id := rosetta_g_miss_num_map(p5_a68);
3464 ddp_taiv_rec.tax_exempt_flag := p5_a69;
3465 ddp_taiv_rec.tax_exempt_reason_code := p5_a70;
3466 ddp_taiv_rec.reference_line_id := rosetta_g_miss_num_map(p5_a71);
3467 ddp_taiv_rec.private_label := p5_a72;
3468 ddp_taiv_rec.transaction_date := rosetta_g_miss_date_in_map(p5_a73);
3469
3470 -- here's the delegated call to the old PL/SQL routine
3471 okl_tai_pvt.validate_row(p_api_version,
3472 p_init_msg_list,
3473 x_return_status,
3474 x_msg_count,
3475 x_msg_data,
3476 ddp_taiv_rec);
3477
3478 -- copy data back from the local variables to OUT or IN-OUT args, if any
3479
3480
3481
3482
3483
3484 end;
3485
3486 procedure validate_row(p_api_version NUMBER
3487 , p_init_msg_list VARCHAR2
3488 , x_return_status out nocopy VARCHAR2
3489 , x_msg_count out nocopy NUMBER
3490 , x_msg_data out nocopy VARCHAR2
3491 , p5_a0 JTF_NUMBER_TABLE
3492 , p5_a1 JTF_NUMBER_TABLE
3493 , p5_a2 JTF_VARCHAR2_TABLE_100
3494 , p5_a3 JTF_VARCHAR2_TABLE_100
3495 , p5_a4 JTF_VARCHAR2_TABLE_100
3496 , p5_a5 JTF_NUMBER_TABLE
3497 , p5_a6 JTF_DATE_TABLE
3498 , p5_a7 JTF_NUMBER_TABLE
3499 , p5_a8 JTF_NUMBER_TABLE
3500 , p5_a9 JTF_NUMBER_TABLE
3501 , p5_a10 JTF_NUMBER_TABLE
3502 , p5_a11 JTF_NUMBER_TABLE
3503 , p5_a12 JTF_NUMBER_TABLE
3504 , p5_a13 JTF_NUMBER_TABLE
3505 , p5_a14 JTF_VARCHAR2_TABLE_100
3506 , p5_a15 JTF_NUMBER_TABLE
3507 , p5_a16 JTF_NUMBER_TABLE
3508 , p5_a17 JTF_NUMBER_TABLE
3509 , p5_a18 JTF_NUMBER_TABLE
3510 , p5_a19 JTF_NUMBER_TABLE
3511 , p5_a20 JTF_NUMBER_TABLE
3512 , p5_a21 JTF_NUMBER_TABLE
3513 , p5_a22 JTF_NUMBER_TABLE
3514 , p5_a23 JTF_DATE_TABLE
3515 , p5_a24 JTF_NUMBER_TABLE
3516 , p5_a25 JTF_VARCHAR2_TABLE_2000
3517 , p5_a26 JTF_VARCHAR2_TABLE_300
3518 , p5_a27 JTF_NUMBER_TABLE
3519 , p5_a28 JTF_NUMBER_TABLE
3520 , p5_a29 JTF_NUMBER_TABLE
3521 , p5_a30 JTF_VARCHAR2_TABLE_100
3522 , p5_a31 JTF_VARCHAR2_TABLE_500
3523 , p5_a32 JTF_VARCHAR2_TABLE_500
3524 , p5_a33 JTF_VARCHAR2_TABLE_500
3525 , p5_a34 JTF_VARCHAR2_TABLE_500
3526 , p5_a35 JTF_VARCHAR2_TABLE_500
3527 , p5_a36 JTF_VARCHAR2_TABLE_500
3528 , p5_a37 JTF_VARCHAR2_TABLE_500
3529 , p5_a38 JTF_VARCHAR2_TABLE_500
3530 , p5_a39 JTF_VARCHAR2_TABLE_500
3531 , p5_a40 JTF_VARCHAR2_TABLE_500
3532 , p5_a41 JTF_VARCHAR2_TABLE_500
3533 , p5_a42 JTF_VARCHAR2_TABLE_500
3534 , p5_a43 JTF_VARCHAR2_TABLE_500
3535 , p5_a44 JTF_VARCHAR2_TABLE_500
3536 , p5_a45 JTF_VARCHAR2_TABLE_500
3537 , p5_a46 JTF_DATE_TABLE
3538 , p5_a47 JTF_NUMBER_TABLE
3539 , p5_a48 JTF_NUMBER_TABLE
3540 , p5_a49 JTF_NUMBER_TABLE
3541 , p5_a50 JTF_DATE_TABLE
3542 , p5_a51 JTF_NUMBER_TABLE
3543 , p5_a52 JTF_NUMBER_TABLE
3544 , p5_a53 JTF_DATE_TABLE
3548 , p5_a57 JTF_NUMBER_TABLE
3545 , p5_a54 JTF_NUMBER_TABLE
3546 , p5_a55 JTF_DATE_TABLE
3547 , p5_a56 JTF_NUMBER_TABLE
3549 , p5_a58 JTF_VARCHAR2_TABLE_200
3550 , p5_a59 JTF_VARCHAR2_TABLE_400
3551 , p5_a60 JTF_VARCHAR2_TABLE_100
3552 , p5_a61 JTF_NUMBER_TABLE
3553 , p5_a62 JTF_VARCHAR2_TABLE_100
3554 , p5_a63 JTF_DATE_TABLE
3555 , p5_a64 JTF_VARCHAR2_TABLE_100
3556 , p5_a65 JTF_NUMBER_TABLE
3557 , p5_a66 JTF_NUMBER_TABLE
3558 , p5_a67 JTF_NUMBER_TABLE
3559 , p5_a68 JTF_NUMBER_TABLE
3560 , p5_a69 JTF_VARCHAR2_TABLE_100
3561 , p5_a70 JTF_VARCHAR2_TABLE_100
3562 , p5_a71 JTF_NUMBER_TABLE
3563 , p5_a72 JTF_VARCHAR2_TABLE_4000
3564 , p5_a73 JTF_DATE_TABLE
3565 )
3566
3567 as
3568 ddp_taiv_tbl okl_tai_pvt.taiv_tbl_type;
3569 ddindx binary_integer; indx binary_integer;
3570 begin
3571
3572 -- copy data to the local IN or IN-OUT args, if any
3573
3574
3575
3576
3577
3578 okl_tai_pvt_w.rosetta_table_copy_in_p8(ddp_taiv_tbl, p5_a0
3579 , p5_a1
3580 , p5_a2
3581 , p5_a3
3582 , p5_a4
3583 , p5_a5
3584 , p5_a6
3585 , p5_a7
3586 , p5_a8
3587 , p5_a9
3588 , p5_a10
3589 , p5_a11
3590 , p5_a12
3591 , p5_a13
3592 , p5_a14
3593 , p5_a15
3594 , p5_a16
3595 , p5_a17
3596 , p5_a18
3597 , p5_a19
3598 , p5_a20
3599 , p5_a21
3600 , p5_a22
3601 , p5_a23
3602 , p5_a24
3603 , p5_a25
3604 , p5_a26
3605 , p5_a27
3606 , p5_a28
3607 , p5_a29
3608 , p5_a30
3609 , p5_a31
3610 , p5_a32
3611 , p5_a33
3612 , p5_a34
3613 , p5_a35
3614 , p5_a36
3615 , p5_a37
3616 , p5_a38
3617 , p5_a39
3618 , p5_a40
3619 , p5_a41
3620 , p5_a42
3621 , p5_a43
3622 , p5_a44
3623 , p5_a45
3624 , p5_a46
3625 , p5_a47
3626 , p5_a48
3627 , p5_a49
3628 , p5_a50
3629 , p5_a51
3630 , p5_a52
3631 , p5_a53
3632 , p5_a54
3633 , p5_a55
3634 , p5_a56
3635 , p5_a57
3636 , p5_a58
3637 , p5_a59
3638 , p5_a60
3639 , p5_a61
3640 , p5_a62
3641 , p5_a63
3642 , p5_a64
3643 , p5_a65
3644 , p5_a66
3645 , p5_a67
3646 , p5_a68
3647 , p5_a69
3648 , p5_a70
3649 , p5_a71
3650 , p5_a72
3651 , p5_a73
3652 );
3653
3654 -- here's the delegated call to the old PL/SQL routine
3655 okl_tai_pvt.validate_row(p_api_version,
3656 p_init_msg_list,
3657 x_return_status,
3658 x_msg_count,
3659 x_msg_data,
3660 ddp_taiv_tbl);
3661
3662 -- copy data back from the local variables to OUT or IN-OUT args, if any
3663
3664
3665
3666
3667
3668 end;
3669
3670 end okl_tai_pvt_w;