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