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