eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.OKL_AM_ASSET_RETURN_PVT_W

Source


1 package okl_am_asset_return_pvt_w as
2   /* $Header: OKLEARRS.pls 120.4 2007/11/14 19:36:48 rmunjulu ship $ */
3   procedure create_asset_return(p_api_version  NUMBER
4     , p_init_msg_list  VARCHAR2
5     , x_return_status out nocopy  VARCHAR2
6     , x_msg_count out nocopy  NUMBER
7     , x_msg_data out nocopy  VARCHAR2
8     , p6_a0 out nocopy  NUMBER
9     , p6_a1 out nocopy  NUMBER
10     , p6_a2 out nocopy  VARCHAR2
11     , p6_a3 out nocopy  NUMBER
12     , p6_a4 out nocopy  NUMBER
13     , p6_a5 out nocopy  NUMBER
14     , p6_a6 out nocopy  NUMBER
15     , p6_a7 out nocopy  NUMBER
16     , p6_a8 out nocopy  NUMBER
17     , p6_a9 out nocopy  VARCHAR2
18     , p6_a10 out nocopy  VARCHAR2
19     , p6_a11 out nocopy  DATE
20     , p6_a12 out nocopy  DATE
21     , p6_a13 out nocopy  DATE
22     , p6_a14 out nocopy  DATE
23     , p6_a15 out nocopy  VARCHAR2
24     , p6_a16 out nocopy  VARCHAR2
25     , p6_a17 out nocopy  DATE
26     , p6_a18 out nocopy  DATE
27     , p6_a19 out nocopy  DATE
28     , p6_a20 out nocopy  VARCHAR2
29     , p6_a21 out nocopy  VARCHAR2
30     , p6_a22 out nocopy  VARCHAR2
31     , p6_a23 out nocopy  VARCHAR2
32     , p6_a24 out nocopy  VARCHAR2
33     , p6_a25 out nocopy  VARCHAR2
34     , p6_a26 out nocopy  VARCHAR2
35     , p6_a27 out nocopy  VARCHAR2
36     , p6_a28 out nocopy  VARCHAR2
37     , p6_a29 out nocopy  VARCHAR2
38     , p6_a30 out nocopy  VARCHAR2
39     , p6_a31 out nocopy  VARCHAR2
40     , p6_a32 out nocopy  VARCHAR2
41     , p6_a33 out nocopy  VARCHAR2
42     , p6_a34 out nocopy  VARCHAR2
43     , p6_a35 out nocopy  VARCHAR2
44     , p6_a36 out nocopy  VARCHAR2
45     , p6_a37 out nocopy  VARCHAR2
46     , p6_a38 out nocopy  NUMBER
47     , p6_a39 out nocopy  NUMBER
48     , p6_a40 out nocopy  NUMBER
49     , p6_a41 out nocopy  NUMBER
50     , p6_a42 out nocopy  DATE
51     , p6_a43 out nocopy  NUMBER
52     , p6_a44 out nocopy  DATE
53     , p6_a45 out nocopy  NUMBER
54     , p6_a46 out nocopy  DATE
55     , p6_a47 out nocopy  NUMBER
56     , p6_a48 out nocopy  NUMBER
57     , p6_a49 out nocopy  VARCHAR2
58     , p6_a50 out nocopy  NUMBER
59     , p6_a51 out nocopy  VARCHAR2
60     , p6_a52 out nocopy  VARCHAR2
61     , p6_a53 out nocopy  VARCHAR2
62     , p6_a54 out nocopy  VARCHAR2
63     , p6_a55 out nocopy  VARCHAR2
64     , p6_a56 out nocopy  VARCHAR2
65     , p6_a57 out nocopy  VARCHAR2
66     , p6_a58 out nocopy  NUMBER
67     , p6_a59 out nocopy  DATE
68     , p6_a60 out nocopy  NUMBER
69     , p6_a61 out nocopy  NUMBER
70     , p_quote_id  NUMBER
71     , p5_a0  NUMBER := 0-1962.0724
72     , p5_a1  NUMBER := 0-1962.0724
73     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
74     , p5_a3  NUMBER := 0-1962.0724
75     , p5_a4  NUMBER := 0-1962.0724
76     , p5_a5  NUMBER := 0-1962.0724
77     , p5_a6  NUMBER := 0-1962.0724
78     , p5_a7  NUMBER := 0-1962.0724
79     , p5_a8  NUMBER := 0-1962.0724
80     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
81     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
82     , p5_a11  DATE := fnd_api.g_miss_date
83     , p5_a12  DATE := fnd_api.g_miss_date
84     , p5_a13  DATE := fnd_api.g_miss_date
85     , p5_a14  DATE := fnd_api.g_miss_date
86     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
87     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
88     , p5_a17  DATE := fnd_api.g_miss_date
89     , p5_a18  DATE := fnd_api.g_miss_date
90     , p5_a19  DATE := fnd_api.g_miss_date
91     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
92     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
93     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
94     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
95     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
96     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
97     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
98     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
99     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
100     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
101     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
102     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
103     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
104     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
105     , p5_a34  VARCHAR2 := fnd_api.g_miss_char
106     , p5_a35  VARCHAR2 := fnd_api.g_miss_char
107     , p5_a36  VARCHAR2 := fnd_api.g_miss_char
108     , p5_a37  VARCHAR2 := fnd_api.g_miss_char
109     , p5_a38  NUMBER := 0-1962.0724
110     , p5_a39  NUMBER := 0-1962.0724
111     , p5_a40  NUMBER := 0-1962.0724
112     , p5_a41  NUMBER := 0-1962.0724
113     , p5_a42  DATE := fnd_api.g_miss_date
114     , p5_a43  NUMBER := 0-1962.0724
115     , p5_a44  DATE := fnd_api.g_miss_date
116     , p5_a45  NUMBER := 0-1962.0724
117     , p5_a46  DATE := fnd_api.g_miss_date
118     , p5_a47  NUMBER := 0-1962.0724
119     , p5_a48  NUMBER := 0-1962.0724
120     , p5_a49  VARCHAR2 := fnd_api.g_miss_char
121     , p5_a50  NUMBER := 0-1962.0724
122     , p5_a51  VARCHAR2 := fnd_api.g_miss_char
123     , p5_a52  VARCHAR2 := fnd_api.g_miss_char
124     , p5_a53  VARCHAR2 := fnd_api.g_miss_char
125     , p5_a54  VARCHAR2 := fnd_api.g_miss_char
126     , p5_a55  VARCHAR2 := fnd_api.g_miss_char
127     , p5_a56  VARCHAR2 := fnd_api.g_miss_char
128     , p5_a57  VARCHAR2 := fnd_api.g_miss_char
129     , p5_a58  NUMBER := 0-1962.0724
130     , p5_a59  DATE := fnd_api.g_miss_date
131     , p5_a60  NUMBER := 0-1962.0724
132     , p5_a61  NUMBER := 0-1962.0724
133   );
134   procedure update_asset_return(p_api_version  NUMBER
135     , p_init_msg_list  VARCHAR2
136     , x_return_status out nocopy  VARCHAR2
137     , x_msg_count out nocopy  NUMBER
138     , x_msg_data out nocopy  VARCHAR2
139     , p6_a0 out nocopy  NUMBER
140     , p6_a1 out nocopy  NUMBER
141     , p6_a2 out nocopy  VARCHAR2
142     , p6_a3 out nocopy  NUMBER
143     , p6_a4 out nocopy  NUMBER
144     , p6_a5 out nocopy  NUMBER
145     , p6_a6 out nocopy  NUMBER
146     , p6_a7 out nocopy  NUMBER
147     , p6_a8 out nocopy  NUMBER
148     , p6_a9 out nocopy  VARCHAR2
149     , p6_a10 out nocopy  VARCHAR2
150     , p6_a11 out nocopy  DATE
151     , p6_a12 out nocopy  DATE
152     , p6_a13 out nocopy  DATE
153     , p6_a14 out nocopy  DATE
154     , p6_a15 out nocopy  VARCHAR2
155     , p6_a16 out nocopy  VARCHAR2
156     , p6_a17 out nocopy  DATE
157     , p6_a18 out nocopy  DATE
158     , p6_a19 out nocopy  DATE
159     , p6_a20 out nocopy  VARCHAR2
160     , p6_a21 out nocopy  VARCHAR2
161     , p6_a22 out nocopy  VARCHAR2
162     , p6_a23 out nocopy  VARCHAR2
163     , p6_a24 out nocopy  VARCHAR2
164     , p6_a25 out nocopy  VARCHAR2
165     , p6_a26 out nocopy  VARCHAR2
166     , p6_a27 out nocopy  VARCHAR2
167     , p6_a28 out nocopy  VARCHAR2
168     , p6_a29 out nocopy  VARCHAR2
169     , p6_a30 out nocopy  VARCHAR2
170     , p6_a31 out nocopy  VARCHAR2
171     , p6_a32 out nocopy  VARCHAR2
172     , p6_a33 out nocopy  VARCHAR2
173     , p6_a34 out nocopy  VARCHAR2
174     , p6_a35 out nocopy  VARCHAR2
175     , p6_a36 out nocopy  VARCHAR2
176     , p6_a37 out nocopy  VARCHAR2
177     , p6_a38 out nocopy  NUMBER
178     , p6_a39 out nocopy  NUMBER
179     , p6_a40 out nocopy  NUMBER
180     , p6_a41 out nocopy  NUMBER
181     , p6_a42 out nocopy  DATE
182     , p6_a43 out nocopy  NUMBER
183     , p6_a44 out nocopy  DATE
184     , p6_a45 out nocopy  NUMBER
185     , p6_a46 out nocopy  DATE
186     , p6_a47 out nocopy  NUMBER
187     , p6_a48 out nocopy  NUMBER
188     , p6_a49 out nocopy  VARCHAR2
189     , p6_a50 out nocopy  NUMBER
190     , p6_a51 out nocopy  VARCHAR2
191     , p6_a52 out nocopy  VARCHAR2
192     , p6_a53 out nocopy  VARCHAR2
193     , p6_a54 out nocopy  VARCHAR2
194     , p6_a55 out nocopy  VARCHAR2
195     , p6_a56 out nocopy  VARCHAR2
196     , p6_a57 out nocopy  VARCHAR2
197     , p6_a58 out nocopy  NUMBER
198     , p6_a59 out nocopy  DATE
199     , p6_a60 out nocopy  NUMBER
200     , p6_a61 out nocopy  NUMBER
201     , p5_a0  NUMBER := 0-1962.0724
202     , p5_a1  NUMBER := 0-1962.0724
203     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
204     , p5_a3  NUMBER := 0-1962.0724
205     , p5_a4  NUMBER := 0-1962.0724
206     , p5_a5  NUMBER := 0-1962.0724
207     , p5_a6  NUMBER := 0-1962.0724
208     , p5_a7  NUMBER := 0-1962.0724
209     , p5_a8  NUMBER := 0-1962.0724
210     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
211     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
212     , p5_a11  DATE := fnd_api.g_miss_date
213     , p5_a12  DATE := fnd_api.g_miss_date
214     , p5_a13  DATE := fnd_api.g_miss_date
215     , p5_a14  DATE := fnd_api.g_miss_date
216     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
217     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
218     , p5_a17  DATE := fnd_api.g_miss_date
219     , p5_a18  DATE := fnd_api.g_miss_date
220     , p5_a19  DATE := fnd_api.g_miss_date
221     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
222     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
223     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
224     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
225     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
226     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
227     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
228     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
229     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
230     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
231     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
232     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
233     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
234     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
235     , p5_a34  VARCHAR2 := fnd_api.g_miss_char
236     , p5_a35  VARCHAR2 := fnd_api.g_miss_char
237     , p5_a36  VARCHAR2 := fnd_api.g_miss_char
238     , p5_a37  VARCHAR2 := fnd_api.g_miss_char
239     , p5_a38  NUMBER := 0-1962.0724
240     , p5_a39  NUMBER := 0-1962.0724
241     , p5_a40  NUMBER := 0-1962.0724
242     , p5_a41  NUMBER := 0-1962.0724
243     , p5_a42  DATE := fnd_api.g_miss_date
244     , p5_a43  NUMBER := 0-1962.0724
245     , p5_a44  DATE := fnd_api.g_miss_date
246     , p5_a45  NUMBER := 0-1962.0724
247     , p5_a46  DATE := fnd_api.g_miss_date
248     , p5_a47  NUMBER := 0-1962.0724
249     , p5_a48  NUMBER := 0-1962.0724
250     , p5_a49  VARCHAR2 := fnd_api.g_miss_char
251     , p5_a50  NUMBER := 0-1962.0724
252     , p5_a51  VARCHAR2 := fnd_api.g_miss_char
253     , p5_a52  VARCHAR2 := fnd_api.g_miss_char
254     , p5_a53  VARCHAR2 := fnd_api.g_miss_char
255     , p5_a54  VARCHAR2 := fnd_api.g_miss_char
256     , p5_a55  VARCHAR2 := fnd_api.g_miss_char
257     , p5_a56  VARCHAR2 := fnd_api.g_miss_char
258     , p5_a57  VARCHAR2 := fnd_api.g_miss_char
259     , p5_a58  NUMBER := 0-1962.0724
260     , p5_a59  DATE := fnd_api.g_miss_date
261     , p5_a60  NUMBER := 0-1962.0724
262     , p5_a61  NUMBER := 0-1962.0724
263   );
264   procedure create_asset_return(p_api_version  NUMBER
265     , p_init_msg_list  VARCHAR2
266     , x_return_status out nocopy  VARCHAR2
267     , x_msg_count out nocopy  NUMBER
268     , x_msg_data out nocopy  VARCHAR2
269     , p5_a0 JTF_NUMBER_TABLE
270     , p5_a1 JTF_NUMBER_TABLE
271     , p5_a2 JTF_VARCHAR2_TABLE_100
272     , p5_a3 JTF_NUMBER_TABLE
273     , p5_a4 JTF_NUMBER_TABLE
274     , p5_a5 JTF_NUMBER_TABLE
275     , p5_a6 JTF_NUMBER_TABLE
276     , p5_a7 JTF_NUMBER_TABLE
277     , p5_a8 JTF_NUMBER_TABLE
278     , p5_a9 JTF_VARCHAR2_TABLE_100
279     , p5_a10 JTF_VARCHAR2_TABLE_100
280     , p5_a11 JTF_DATE_TABLE
281     , p5_a12 JTF_DATE_TABLE
282     , p5_a13 JTF_DATE_TABLE
283     , p5_a14 JTF_DATE_TABLE
284     , p5_a15 JTF_VARCHAR2_TABLE_100
285     , p5_a16 JTF_VARCHAR2_TABLE_100
286     , p5_a17 JTF_DATE_TABLE
287     , p5_a18 JTF_DATE_TABLE
288     , p5_a19 JTF_DATE_TABLE
289     , p5_a20 JTF_VARCHAR2_TABLE_100
290     , p5_a21 JTF_VARCHAR2_TABLE_2000
291     , p5_a22 JTF_VARCHAR2_TABLE_100
292     , p5_a23 JTF_VARCHAR2_TABLE_500
293     , p5_a24 JTF_VARCHAR2_TABLE_500
294     , p5_a25 JTF_VARCHAR2_TABLE_500
295     , p5_a26 JTF_VARCHAR2_TABLE_500
296     , p5_a27 JTF_VARCHAR2_TABLE_500
297     , p5_a28 JTF_VARCHAR2_TABLE_500
298     , p5_a29 JTF_VARCHAR2_TABLE_500
299     , p5_a30 JTF_VARCHAR2_TABLE_500
300     , p5_a31 JTF_VARCHAR2_TABLE_500
301     , p5_a32 JTF_VARCHAR2_TABLE_500
302     , p5_a33 JTF_VARCHAR2_TABLE_500
303     , p5_a34 JTF_VARCHAR2_TABLE_500
304     , p5_a35 JTF_VARCHAR2_TABLE_500
305     , p5_a36 JTF_VARCHAR2_TABLE_500
306     , p5_a37 JTF_VARCHAR2_TABLE_500
307     , p5_a38 JTF_NUMBER_TABLE
308     , p5_a39 JTF_NUMBER_TABLE
309     , p5_a40 JTF_NUMBER_TABLE
310     , p5_a41 JTF_NUMBER_TABLE
311     , p5_a42 JTF_DATE_TABLE
312     , p5_a43 JTF_NUMBER_TABLE
313     , p5_a44 JTF_DATE_TABLE
314     , p5_a45 JTF_NUMBER_TABLE
315     , p5_a46 JTF_DATE_TABLE
316     , p5_a47 JTF_NUMBER_TABLE
317     , p5_a48 JTF_NUMBER_TABLE
318     , p5_a49 JTF_VARCHAR2_TABLE_100
319     , p5_a50 JTF_NUMBER_TABLE
320     , p5_a51 JTF_VARCHAR2_TABLE_100
321     , p5_a52 JTF_VARCHAR2_TABLE_2000
322     , p5_a53 JTF_VARCHAR2_TABLE_100
323     , p5_a54 JTF_VARCHAR2_TABLE_100
324     , p5_a55 JTF_VARCHAR2_TABLE_100
325     , p5_a56 JTF_VARCHAR2_TABLE_100
326     , p5_a57 JTF_VARCHAR2_TABLE_100
327     , p5_a58 JTF_NUMBER_TABLE
328     , p5_a59 JTF_DATE_TABLE
329     , p5_a60 JTF_NUMBER_TABLE
330     , p5_a61 JTF_NUMBER_TABLE
331     , p6_a0 out nocopy JTF_NUMBER_TABLE
332     , p6_a1 out nocopy JTF_NUMBER_TABLE
333     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
334     , p6_a3 out nocopy JTF_NUMBER_TABLE
335     , p6_a4 out nocopy JTF_NUMBER_TABLE
336     , p6_a5 out nocopy JTF_NUMBER_TABLE
337     , p6_a6 out nocopy JTF_NUMBER_TABLE
338     , p6_a7 out nocopy JTF_NUMBER_TABLE
339     , p6_a8 out nocopy JTF_NUMBER_TABLE
340     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
341     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
342     , p6_a11 out nocopy JTF_DATE_TABLE
343     , p6_a12 out nocopy JTF_DATE_TABLE
344     , p6_a13 out nocopy JTF_DATE_TABLE
345     , p6_a14 out nocopy JTF_DATE_TABLE
346     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
347     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
348     , p6_a17 out nocopy JTF_DATE_TABLE
349     , p6_a18 out nocopy JTF_DATE_TABLE
350     , p6_a19 out nocopy JTF_DATE_TABLE
351     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
352     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_2000
353     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
354     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
355     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
356     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
357     , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
358     , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
359     , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
360     , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
361     , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
362     , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
363     , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
364     , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
365     , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
366     , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
367     , p6_a36 out nocopy JTF_VARCHAR2_TABLE_500
368     , p6_a37 out nocopy JTF_VARCHAR2_TABLE_500
369     , p6_a38 out nocopy JTF_NUMBER_TABLE
370     , p6_a39 out nocopy JTF_NUMBER_TABLE
371     , p6_a40 out nocopy JTF_NUMBER_TABLE
372     , p6_a41 out nocopy JTF_NUMBER_TABLE
373     , p6_a42 out nocopy JTF_DATE_TABLE
374     , p6_a43 out nocopy JTF_NUMBER_TABLE
375     , p6_a44 out nocopy JTF_DATE_TABLE
376     , p6_a45 out nocopy JTF_NUMBER_TABLE
377     , p6_a46 out nocopy JTF_DATE_TABLE
378     , p6_a47 out nocopy JTF_NUMBER_TABLE
379     , p6_a48 out nocopy JTF_NUMBER_TABLE
380     , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100
381     , p6_a50 out nocopy JTF_NUMBER_TABLE
382     , p6_a51 out nocopy JTF_VARCHAR2_TABLE_100
383     , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000
384     , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
385     , p6_a54 out nocopy JTF_VARCHAR2_TABLE_100
386     , p6_a55 out nocopy JTF_VARCHAR2_TABLE_100
387     , p6_a56 out nocopy JTF_VARCHAR2_TABLE_100
388     , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100
389     , p6_a58 out nocopy JTF_NUMBER_TABLE
390     , p6_a59 out nocopy JTF_DATE_TABLE
391     , p6_a60 out nocopy JTF_NUMBER_TABLE
392     , p6_a61 out nocopy JTF_NUMBER_TABLE
393     , p_quote_id  NUMBER
394   );
395   procedure update_asset_return(p_api_version  NUMBER
396     , p_init_msg_list  VARCHAR2
397     , x_return_status out nocopy  VARCHAR2
398     , x_msg_count out nocopy  NUMBER
399     , x_msg_data out nocopy  VARCHAR2
400     , p5_a0 JTF_NUMBER_TABLE
401     , p5_a1 JTF_NUMBER_TABLE
402     , p5_a2 JTF_VARCHAR2_TABLE_100
403     , p5_a3 JTF_NUMBER_TABLE
404     , p5_a4 JTF_NUMBER_TABLE
405     , p5_a5 JTF_NUMBER_TABLE
406     , p5_a6 JTF_NUMBER_TABLE
407     , p5_a7 JTF_NUMBER_TABLE
408     , p5_a8 JTF_NUMBER_TABLE
409     , p5_a9 JTF_VARCHAR2_TABLE_100
410     , p5_a10 JTF_VARCHAR2_TABLE_100
411     , p5_a11 JTF_DATE_TABLE
412     , p5_a12 JTF_DATE_TABLE
413     , p5_a13 JTF_DATE_TABLE
414     , p5_a14 JTF_DATE_TABLE
415     , p5_a15 JTF_VARCHAR2_TABLE_100
416     , p5_a16 JTF_VARCHAR2_TABLE_100
417     , p5_a17 JTF_DATE_TABLE
418     , p5_a18 JTF_DATE_TABLE
419     , p5_a19 JTF_DATE_TABLE
420     , p5_a20 JTF_VARCHAR2_TABLE_100
421     , p5_a21 JTF_VARCHAR2_TABLE_2000
422     , p5_a22 JTF_VARCHAR2_TABLE_100
423     , p5_a23 JTF_VARCHAR2_TABLE_500
424     , p5_a24 JTF_VARCHAR2_TABLE_500
425     , p5_a25 JTF_VARCHAR2_TABLE_500
426     , p5_a26 JTF_VARCHAR2_TABLE_500
427     , p5_a27 JTF_VARCHAR2_TABLE_500
428     , p5_a28 JTF_VARCHAR2_TABLE_500
429     , p5_a29 JTF_VARCHAR2_TABLE_500
430     , p5_a30 JTF_VARCHAR2_TABLE_500
431     , p5_a31 JTF_VARCHAR2_TABLE_500
432     , p5_a32 JTF_VARCHAR2_TABLE_500
433     , p5_a33 JTF_VARCHAR2_TABLE_500
434     , p5_a34 JTF_VARCHAR2_TABLE_500
435     , p5_a35 JTF_VARCHAR2_TABLE_500
436     , p5_a36 JTF_VARCHAR2_TABLE_500
437     , p5_a37 JTF_VARCHAR2_TABLE_500
438     , p5_a38 JTF_NUMBER_TABLE
439     , p5_a39 JTF_NUMBER_TABLE
440     , p5_a40 JTF_NUMBER_TABLE
441     , p5_a41 JTF_NUMBER_TABLE
442     , p5_a42 JTF_DATE_TABLE
443     , p5_a43 JTF_NUMBER_TABLE
444     , p5_a44 JTF_DATE_TABLE
445     , p5_a45 JTF_NUMBER_TABLE
446     , p5_a46 JTF_DATE_TABLE
447     , p5_a47 JTF_NUMBER_TABLE
448     , p5_a48 JTF_NUMBER_TABLE
449     , p5_a49 JTF_VARCHAR2_TABLE_100
450     , p5_a50 JTF_NUMBER_TABLE
451     , p5_a51 JTF_VARCHAR2_TABLE_100
452     , p5_a52 JTF_VARCHAR2_TABLE_2000
453     , p5_a53 JTF_VARCHAR2_TABLE_100
454     , p5_a54 JTF_VARCHAR2_TABLE_100
455     , p5_a55 JTF_VARCHAR2_TABLE_100
456     , p5_a56 JTF_VARCHAR2_TABLE_100
457     , p5_a57 JTF_VARCHAR2_TABLE_100
458     , p5_a58 JTF_NUMBER_TABLE
459     , p5_a59 JTF_DATE_TABLE
460     , p5_a60 JTF_NUMBER_TABLE
461     , p5_a61 JTF_NUMBER_TABLE
462     , p6_a0 out nocopy JTF_NUMBER_TABLE
463     , p6_a1 out nocopy JTF_NUMBER_TABLE
464     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
465     , p6_a3 out nocopy JTF_NUMBER_TABLE
466     , p6_a4 out nocopy JTF_NUMBER_TABLE
467     , p6_a5 out nocopy JTF_NUMBER_TABLE
468     , p6_a6 out nocopy JTF_NUMBER_TABLE
469     , p6_a7 out nocopy JTF_NUMBER_TABLE
470     , p6_a8 out nocopy JTF_NUMBER_TABLE
471     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
472     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
473     , p6_a11 out nocopy JTF_DATE_TABLE
474     , p6_a12 out nocopy JTF_DATE_TABLE
475     , p6_a13 out nocopy JTF_DATE_TABLE
476     , p6_a14 out nocopy JTF_DATE_TABLE
477     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
478     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
479     , p6_a17 out nocopy JTF_DATE_TABLE
480     , p6_a18 out nocopy JTF_DATE_TABLE
481     , p6_a19 out nocopy JTF_DATE_TABLE
482     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
483     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_2000
484     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
485     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
486     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
487     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
488     , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
489     , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
490     , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
491     , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
492     , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
493     , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
494     , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
495     , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
496     , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
497     , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
498     , p6_a36 out nocopy JTF_VARCHAR2_TABLE_500
499     , p6_a37 out nocopy JTF_VARCHAR2_TABLE_500
500     , p6_a38 out nocopy JTF_NUMBER_TABLE
501     , p6_a39 out nocopy JTF_NUMBER_TABLE
502     , p6_a40 out nocopy JTF_NUMBER_TABLE
503     , p6_a41 out nocopy JTF_NUMBER_TABLE
504     , p6_a42 out nocopy JTF_DATE_TABLE
505     , p6_a43 out nocopy JTF_NUMBER_TABLE
506     , p6_a44 out nocopy JTF_DATE_TABLE
507     , p6_a45 out nocopy JTF_NUMBER_TABLE
508     , p6_a46 out nocopy JTF_DATE_TABLE
509     , p6_a47 out nocopy JTF_NUMBER_TABLE
510     , p6_a48 out nocopy JTF_NUMBER_TABLE
511     , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100
512     , p6_a50 out nocopy JTF_NUMBER_TABLE
513     , p6_a51 out nocopy JTF_VARCHAR2_TABLE_100
514     , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000
515     , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
516     , p6_a54 out nocopy JTF_VARCHAR2_TABLE_100
517     , p6_a55 out nocopy JTF_VARCHAR2_TABLE_100
518     , p6_a56 out nocopy JTF_VARCHAR2_TABLE_100
519     , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100
520     , p6_a58 out nocopy JTF_NUMBER_TABLE
521     , p6_a59 out nocopy JTF_DATE_TABLE
522     , p6_a60 out nocopy JTF_NUMBER_TABLE
523     , p6_a61 out nocopy JTF_NUMBER_TABLE
524   );
525 end okl_am_asset_return_pvt_w;