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