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