[Home] [Help]
PACKAGE: APPS.OKL_ASSET_RETURNS_PUB_W
Source
1 package okl_asset_returns_pub_w as
2 /* $Header: OKLUARTS.pls 120.3 2008/01/14 18:26:45 rmunjulu ship $ */
3 procedure insert_asset_returns(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 , p5_a0 JTF_NUMBER_TABLE
9 , p5_a1 JTF_NUMBER_TABLE
10 , p5_a2 JTF_VARCHAR2_TABLE_100
11 , p5_a3 JTF_NUMBER_TABLE
12 , p5_a4 JTF_NUMBER_TABLE
13 , p5_a5 JTF_NUMBER_TABLE
14 , p5_a6 JTF_NUMBER_TABLE
15 , p5_a7 JTF_NUMBER_TABLE
16 , p5_a8 JTF_NUMBER_TABLE
17 , p5_a9 JTF_VARCHAR2_TABLE_100
18 , p5_a10 JTF_VARCHAR2_TABLE_100
19 , p5_a11 JTF_DATE_TABLE
20 , p5_a12 JTF_DATE_TABLE
21 , p5_a13 JTF_DATE_TABLE
22 , p5_a14 JTF_DATE_TABLE
23 , p5_a15 JTF_VARCHAR2_TABLE_100
24 , p5_a16 JTF_VARCHAR2_TABLE_100
25 , p5_a17 JTF_DATE_TABLE
26 , p5_a18 JTF_DATE_TABLE
27 , p5_a19 JTF_DATE_TABLE
28 , p5_a20 JTF_VARCHAR2_TABLE_100
29 , p5_a21 JTF_VARCHAR2_TABLE_2000
30 , p5_a22 JTF_VARCHAR2_TABLE_100
31 , p5_a23 JTF_VARCHAR2_TABLE_500
32 , p5_a24 JTF_VARCHAR2_TABLE_500
33 , p5_a25 JTF_VARCHAR2_TABLE_500
34 , p5_a26 JTF_VARCHAR2_TABLE_500
35 , p5_a27 JTF_VARCHAR2_TABLE_500
36 , p5_a28 JTF_VARCHAR2_TABLE_500
37 , p5_a29 JTF_VARCHAR2_TABLE_500
38 , p5_a30 JTF_VARCHAR2_TABLE_500
39 , p5_a31 JTF_VARCHAR2_TABLE_500
40 , p5_a32 JTF_VARCHAR2_TABLE_500
41 , p5_a33 JTF_VARCHAR2_TABLE_500
42 , p5_a34 JTF_VARCHAR2_TABLE_500
43 , p5_a35 JTF_VARCHAR2_TABLE_500
44 , p5_a36 JTF_VARCHAR2_TABLE_500
45 , p5_a37 JTF_VARCHAR2_TABLE_500
46 , p5_a38 JTF_NUMBER_TABLE
47 , p5_a39 JTF_NUMBER_TABLE
48 , p5_a40 JTF_NUMBER_TABLE
49 , p5_a41 JTF_NUMBER_TABLE
50 , p5_a42 JTF_DATE_TABLE
51 , p5_a43 JTF_NUMBER_TABLE
52 , p5_a44 JTF_DATE_TABLE
53 , p5_a45 JTF_NUMBER_TABLE
54 , p5_a46 JTF_DATE_TABLE
55 , p5_a47 JTF_NUMBER_TABLE
56 , p5_a48 JTF_NUMBER_TABLE
57 , p5_a49 JTF_VARCHAR2_TABLE_100
58 , p5_a50 JTF_NUMBER_TABLE
59 , p5_a51 JTF_VARCHAR2_TABLE_100
60 , p5_a52 JTF_VARCHAR2_TABLE_2000
61 , p5_a53 JTF_VARCHAR2_TABLE_100
62 , p5_a54 JTF_VARCHAR2_TABLE_100
63 , p5_a55 JTF_VARCHAR2_TABLE_100
64 , p5_a56 JTF_VARCHAR2_TABLE_100
65 , p5_a57 JTF_VARCHAR2_TABLE_100
66 , p5_a58 JTF_NUMBER_TABLE
67 , p5_a59 JTF_DATE_TABLE
68 , p5_a60 JTF_NUMBER_TABLE
69 , p5_a61 JTF_NUMBER_TABLE
70 , p6_a0 out nocopy JTF_NUMBER_TABLE
71 , p6_a1 out nocopy JTF_NUMBER_TABLE
72 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
73 , p6_a3 out nocopy JTF_NUMBER_TABLE
74 , p6_a4 out nocopy JTF_NUMBER_TABLE
75 , p6_a5 out nocopy JTF_NUMBER_TABLE
76 , p6_a6 out nocopy JTF_NUMBER_TABLE
77 , p6_a7 out nocopy JTF_NUMBER_TABLE
78 , p6_a8 out nocopy JTF_NUMBER_TABLE
79 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
80 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
81 , p6_a11 out nocopy JTF_DATE_TABLE
82 , p6_a12 out nocopy JTF_DATE_TABLE
83 , p6_a13 out nocopy JTF_DATE_TABLE
84 , p6_a14 out nocopy JTF_DATE_TABLE
85 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
86 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
87 , p6_a17 out nocopy JTF_DATE_TABLE
88 , p6_a18 out nocopy JTF_DATE_TABLE
89 , p6_a19 out nocopy JTF_DATE_TABLE
90 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
91 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_2000
92 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
93 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
94 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
95 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
96 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
97 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
98 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
99 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
100 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
101 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
102 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
103 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
104 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
105 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
106 , p6_a36 out nocopy JTF_VARCHAR2_TABLE_500
107 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_500
108 , p6_a38 out nocopy JTF_NUMBER_TABLE
109 , p6_a39 out nocopy JTF_NUMBER_TABLE
110 , p6_a40 out nocopy JTF_NUMBER_TABLE
111 , p6_a41 out nocopy JTF_NUMBER_TABLE
112 , p6_a42 out nocopy JTF_DATE_TABLE
113 , p6_a43 out nocopy JTF_NUMBER_TABLE
114 , p6_a44 out nocopy JTF_DATE_TABLE
115 , p6_a45 out nocopy JTF_NUMBER_TABLE
116 , p6_a46 out nocopy JTF_DATE_TABLE
117 , p6_a47 out nocopy JTF_NUMBER_TABLE
118 , p6_a48 out nocopy JTF_NUMBER_TABLE
119 , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100
120 , p6_a50 out nocopy JTF_NUMBER_TABLE
121 , p6_a51 out nocopy JTF_VARCHAR2_TABLE_100
122 , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000
123 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
124 , p6_a54 out nocopy JTF_VARCHAR2_TABLE_100
125 , p6_a55 out nocopy JTF_VARCHAR2_TABLE_100
126 , p6_a56 out nocopy JTF_VARCHAR2_TABLE_100
127 , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100
128 , p6_a58 out nocopy JTF_NUMBER_TABLE
129 , p6_a59 out nocopy JTF_DATE_TABLE
130 , p6_a60 out nocopy JTF_NUMBER_TABLE
131 , p6_a61 out nocopy JTF_NUMBER_TABLE
132 );
133 procedure insert_asset_returns(p_api_version NUMBER
134 , p_init_msg_list VARCHAR2
135 , x_return_status out nocopy VARCHAR2
136 , x_msg_count out nocopy NUMBER
137 , x_msg_data out nocopy VARCHAR2
138 , p6_a0 out nocopy NUMBER
139 , p6_a1 out nocopy NUMBER
140 , p6_a2 out nocopy VARCHAR2
141 , p6_a3 out nocopy NUMBER
142 , p6_a4 out nocopy NUMBER
143 , p6_a5 out nocopy NUMBER
144 , p6_a6 out nocopy NUMBER
145 , p6_a7 out nocopy NUMBER
146 , p6_a8 out nocopy NUMBER
147 , p6_a9 out nocopy VARCHAR2
148 , p6_a10 out nocopy VARCHAR2
149 , p6_a11 out nocopy DATE
150 , p6_a12 out nocopy DATE
151 , p6_a13 out nocopy DATE
152 , p6_a14 out nocopy DATE
153 , p6_a15 out nocopy VARCHAR2
154 , p6_a16 out nocopy VARCHAR2
155 , p6_a17 out nocopy DATE
156 , p6_a18 out nocopy DATE
157 , p6_a19 out nocopy DATE
158 , p6_a20 out nocopy VARCHAR2
159 , p6_a21 out nocopy VARCHAR2
160 , p6_a22 out nocopy VARCHAR2
161 , p6_a23 out nocopy VARCHAR2
162 , p6_a24 out nocopy VARCHAR2
163 , p6_a25 out nocopy VARCHAR2
164 , p6_a26 out nocopy VARCHAR2
165 , p6_a27 out nocopy VARCHAR2
166 , p6_a28 out nocopy VARCHAR2
167 , p6_a29 out nocopy VARCHAR2
168 , p6_a30 out nocopy VARCHAR2
169 , p6_a31 out nocopy VARCHAR2
170 , p6_a32 out nocopy VARCHAR2
171 , p6_a33 out nocopy VARCHAR2
172 , p6_a34 out nocopy VARCHAR2
173 , p6_a35 out nocopy VARCHAR2
174 , p6_a36 out nocopy VARCHAR2
175 , p6_a37 out nocopy VARCHAR2
176 , p6_a38 out nocopy NUMBER
177 , p6_a39 out nocopy NUMBER
178 , p6_a40 out nocopy NUMBER
179 , p6_a41 out nocopy NUMBER
180 , p6_a42 out nocopy DATE
181 , p6_a43 out nocopy NUMBER
182 , p6_a44 out nocopy DATE
183 , p6_a45 out nocopy NUMBER
184 , p6_a46 out nocopy DATE
185 , p6_a47 out nocopy NUMBER
186 , p6_a48 out nocopy NUMBER
187 , p6_a49 out nocopy VARCHAR2
188 , p6_a50 out nocopy NUMBER
189 , p6_a51 out nocopy VARCHAR2
190 , p6_a52 out nocopy VARCHAR2
191 , p6_a53 out nocopy VARCHAR2
192 , p6_a54 out nocopy VARCHAR2
193 , p6_a55 out nocopy VARCHAR2
194 , p6_a56 out nocopy VARCHAR2
195 , p6_a57 out nocopy VARCHAR2
196 , p6_a58 out nocopy NUMBER
197 , p6_a59 out nocopy DATE
198 , p6_a60 out nocopy NUMBER
199 , p6_a61 out nocopy NUMBER
200 , p5_a0 NUMBER := 0-1962.0724
201 , p5_a1 NUMBER := 0-1962.0724
202 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
203 , p5_a3 NUMBER := 0-1962.0724
204 , p5_a4 NUMBER := 0-1962.0724
205 , p5_a5 NUMBER := 0-1962.0724
206 , p5_a6 NUMBER := 0-1962.0724
207 , p5_a7 NUMBER := 0-1962.0724
208 , p5_a8 NUMBER := 0-1962.0724
209 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
210 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
211 , p5_a11 DATE := fnd_api.g_miss_date
212 , p5_a12 DATE := fnd_api.g_miss_date
213 , p5_a13 DATE := fnd_api.g_miss_date
214 , p5_a14 DATE := fnd_api.g_miss_date
215 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
216 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
217 , p5_a17 DATE := fnd_api.g_miss_date
218 , p5_a18 DATE := fnd_api.g_miss_date
219 , p5_a19 DATE := fnd_api.g_miss_date
220 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
221 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
222 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
223 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
224 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
225 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
226 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
227 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
228 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
229 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
230 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
231 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
232 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
233 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
234 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
235 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
236 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
237 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
238 , p5_a38 NUMBER := 0-1962.0724
239 , p5_a39 NUMBER := 0-1962.0724
240 , p5_a40 NUMBER := 0-1962.0724
241 , p5_a41 NUMBER := 0-1962.0724
242 , p5_a42 DATE := fnd_api.g_miss_date
243 , p5_a43 NUMBER := 0-1962.0724
244 , p5_a44 DATE := fnd_api.g_miss_date
245 , p5_a45 NUMBER := 0-1962.0724
246 , p5_a46 DATE := fnd_api.g_miss_date
247 , p5_a47 NUMBER := 0-1962.0724
248 , p5_a48 NUMBER := 0-1962.0724
249 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
250 , p5_a50 NUMBER := 0-1962.0724
251 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
252 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
253 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
254 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
255 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
256 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
257 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
258 , p5_a58 NUMBER := 0-1962.0724
259 , p5_a59 DATE := fnd_api.g_miss_date
260 , p5_a60 NUMBER := 0-1962.0724
261 , p5_a61 NUMBER := 0-1962.0724
262 );
263 procedure lock_asset_returns(p_api_version NUMBER
264 , p_init_msg_list VARCHAR2
265 , x_return_status out nocopy VARCHAR2
266 , x_msg_count out nocopy NUMBER
267 , x_msg_data out nocopy VARCHAR2
268 , p5_a0 JTF_NUMBER_TABLE
269 , p5_a1 JTF_NUMBER_TABLE
270 , p5_a2 JTF_VARCHAR2_TABLE_100
271 , p5_a3 JTF_NUMBER_TABLE
272 , p5_a4 JTF_NUMBER_TABLE
273 , p5_a5 JTF_NUMBER_TABLE
274 , p5_a6 JTF_NUMBER_TABLE
275 , p5_a7 JTF_NUMBER_TABLE
276 , p5_a8 JTF_NUMBER_TABLE
277 , p5_a9 JTF_VARCHAR2_TABLE_100
278 , p5_a10 JTF_VARCHAR2_TABLE_100
279 , p5_a11 JTF_DATE_TABLE
280 , p5_a12 JTF_DATE_TABLE
281 , p5_a13 JTF_DATE_TABLE
282 , p5_a14 JTF_DATE_TABLE
283 , p5_a15 JTF_VARCHAR2_TABLE_100
284 , p5_a16 JTF_VARCHAR2_TABLE_100
285 , p5_a17 JTF_DATE_TABLE
286 , p5_a18 JTF_DATE_TABLE
287 , p5_a19 JTF_DATE_TABLE
288 , p5_a20 JTF_VARCHAR2_TABLE_100
289 , p5_a21 JTF_VARCHAR2_TABLE_2000
290 , p5_a22 JTF_VARCHAR2_TABLE_100
291 , p5_a23 JTF_VARCHAR2_TABLE_500
292 , p5_a24 JTF_VARCHAR2_TABLE_500
293 , p5_a25 JTF_VARCHAR2_TABLE_500
294 , p5_a26 JTF_VARCHAR2_TABLE_500
295 , p5_a27 JTF_VARCHAR2_TABLE_500
296 , p5_a28 JTF_VARCHAR2_TABLE_500
297 , p5_a29 JTF_VARCHAR2_TABLE_500
298 , p5_a30 JTF_VARCHAR2_TABLE_500
299 , p5_a31 JTF_VARCHAR2_TABLE_500
300 , p5_a32 JTF_VARCHAR2_TABLE_500
301 , p5_a33 JTF_VARCHAR2_TABLE_500
302 , p5_a34 JTF_VARCHAR2_TABLE_500
303 , p5_a35 JTF_VARCHAR2_TABLE_500
304 , p5_a36 JTF_VARCHAR2_TABLE_500
305 , p5_a37 JTF_VARCHAR2_TABLE_500
306 , p5_a38 JTF_NUMBER_TABLE
307 , p5_a39 JTF_NUMBER_TABLE
308 , p5_a40 JTF_NUMBER_TABLE
309 , p5_a41 JTF_NUMBER_TABLE
310 , p5_a42 JTF_DATE_TABLE
311 , p5_a43 JTF_NUMBER_TABLE
312 , p5_a44 JTF_DATE_TABLE
313 , p5_a45 JTF_NUMBER_TABLE
314 , p5_a46 JTF_DATE_TABLE
315 , p5_a47 JTF_NUMBER_TABLE
316 , p5_a48 JTF_NUMBER_TABLE
317 , p5_a49 JTF_VARCHAR2_TABLE_100
318 , p5_a50 JTF_NUMBER_TABLE
319 , p5_a51 JTF_VARCHAR2_TABLE_100
320 , p5_a52 JTF_VARCHAR2_TABLE_2000
321 , p5_a53 JTF_VARCHAR2_TABLE_100
322 , p5_a54 JTF_VARCHAR2_TABLE_100
323 , p5_a55 JTF_VARCHAR2_TABLE_100
324 , p5_a56 JTF_VARCHAR2_TABLE_100
325 , p5_a57 JTF_VARCHAR2_TABLE_100
326 , p5_a58 JTF_NUMBER_TABLE
327 , p5_a59 JTF_DATE_TABLE
328 , p5_a60 JTF_NUMBER_TABLE
329 , p5_a61 JTF_NUMBER_TABLE
330 );
331 procedure lock_asset_returns(p_api_version NUMBER
332 , p_init_msg_list VARCHAR2
333 , x_return_status out nocopy VARCHAR2
334 , x_msg_count out nocopy NUMBER
335 , x_msg_data out nocopy VARCHAR2
336 , p5_a0 NUMBER := 0-1962.0724
337 , p5_a1 NUMBER := 0-1962.0724
338 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
339 , p5_a3 NUMBER := 0-1962.0724
340 , p5_a4 NUMBER := 0-1962.0724
341 , p5_a5 NUMBER := 0-1962.0724
342 , p5_a6 NUMBER := 0-1962.0724
343 , p5_a7 NUMBER := 0-1962.0724
344 , p5_a8 NUMBER := 0-1962.0724
345 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
346 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
347 , p5_a11 DATE := fnd_api.g_miss_date
348 , p5_a12 DATE := fnd_api.g_miss_date
349 , p5_a13 DATE := fnd_api.g_miss_date
350 , p5_a14 DATE := fnd_api.g_miss_date
351 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
352 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
353 , p5_a17 DATE := fnd_api.g_miss_date
354 , p5_a18 DATE := fnd_api.g_miss_date
355 , p5_a19 DATE := fnd_api.g_miss_date
356 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
357 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
358 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
359 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
360 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
361 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
362 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
363 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
364 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
365 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
366 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
367 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
368 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
369 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
370 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
371 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
372 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
373 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
374 , p5_a38 NUMBER := 0-1962.0724
375 , p5_a39 NUMBER := 0-1962.0724
376 , p5_a40 NUMBER := 0-1962.0724
377 , p5_a41 NUMBER := 0-1962.0724
378 , p5_a42 DATE := fnd_api.g_miss_date
379 , p5_a43 NUMBER := 0-1962.0724
380 , p5_a44 DATE := fnd_api.g_miss_date
381 , p5_a45 NUMBER := 0-1962.0724
382 , p5_a46 DATE := fnd_api.g_miss_date
383 , p5_a47 NUMBER := 0-1962.0724
384 , p5_a48 NUMBER := 0-1962.0724
385 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
386 , p5_a50 NUMBER := 0-1962.0724
387 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
388 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
389 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
390 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
391 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
392 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
393 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
394 , p5_a58 NUMBER := 0-1962.0724
395 , p5_a59 DATE := fnd_api.g_miss_date
396 , p5_a60 NUMBER := 0-1962.0724
397 , p5_a61 NUMBER := 0-1962.0724
398 );
399 procedure update_asset_returns(p_api_version NUMBER
400 , p_init_msg_list VARCHAR2
401 , x_return_status out nocopy VARCHAR2
402 , x_msg_count out nocopy NUMBER
403 , x_msg_data out nocopy VARCHAR2
404 , p5_a0 JTF_NUMBER_TABLE
405 , p5_a1 JTF_NUMBER_TABLE
406 , p5_a2 JTF_VARCHAR2_TABLE_100
407 , p5_a3 JTF_NUMBER_TABLE
408 , p5_a4 JTF_NUMBER_TABLE
409 , p5_a5 JTF_NUMBER_TABLE
410 , p5_a6 JTF_NUMBER_TABLE
411 , p5_a7 JTF_NUMBER_TABLE
412 , p5_a8 JTF_NUMBER_TABLE
413 , p5_a9 JTF_VARCHAR2_TABLE_100
414 , p5_a10 JTF_VARCHAR2_TABLE_100
415 , p5_a11 JTF_DATE_TABLE
416 , p5_a12 JTF_DATE_TABLE
417 , p5_a13 JTF_DATE_TABLE
418 , p5_a14 JTF_DATE_TABLE
419 , p5_a15 JTF_VARCHAR2_TABLE_100
420 , p5_a16 JTF_VARCHAR2_TABLE_100
421 , p5_a17 JTF_DATE_TABLE
422 , p5_a18 JTF_DATE_TABLE
423 , p5_a19 JTF_DATE_TABLE
424 , p5_a20 JTF_VARCHAR2_TABLE_100
425 , p5_a21 JTF_VARCHAR2_TABLE_2000
426 , p5_a22 JTF_VARCHAR2_TABLE_100
427 , p5_a23 JTF_VARCHAR2_TABLE_500
428 , p5_a24 JTF_VARCHAR2_TABLE_500
429 , p5_a25 JTF_VARCHAR2_TABLE_500
430 , p5_a26 JTF_VARCHAR2_TABLE_500
431 , p5_a27 JTF_VARCHAR2_TABLE_500
432 , p5_a28 JTF_VARCHAR2_TABLE_500
433 , p5_a29 JTF_VARCHAR2_TABLE_500
434 , p5_a30 JTF_VARCHAR2_TABLE_500
435 , p5_a31 JTF_VARCHAR2_TABLE_500
436 , p5_a32 JTF_VARCHAR2_TABLE_500
437 , p5_a33 JTF_VARCHAR2_TABLE_500
438 , p5_a34 JTF_VARCHAR2_TABLE_500
439 , p5_a35 JTF_VARCHAR2_TABLE_500
440 , p5_a36 JTF_VARCHAR2_TABLE_500
441 , p5_a37 JTF_VARCHAR2_TABLE_500
442 , p5_a38 JTF_NUMBER_TABLE
443 , p5_a39 JTF_NUMBER_TABLE
444 , p5_a40 JTF_NUMBER_TABLE
445 , p5_a41 JTF_NUMBER_TABLE
446 , p5_a42 JTF_DATE_TABLE
447 , p5_a43 JTF_NUMBER_TABLE
448 , p5_a44 JTF_DATE_TABLE
449 , p5_a45 JTF_NUMBER_TABLE
450 , p5_a46 JTF_DATE_TABLE
451 , p5_a47 JTF_NUMBER_TABLE
452 , p5_a48 JTF_NUMBER_TABLE
453 , p5_a49 JTF_VARCHAR2_TABLE_100
454 , p5_a50 JTF_NUMBER_TABLE
455 , p5_a51 JTF_VARCHAR2_TABLE_100
456 , p5_a52 JTF_VARCHAR2_TABLE_2000
457 , p5_a53 JTF_VARCHAR2_TABLE_100
458 , p5_a54 JTF_VARCHAR2_TABLE_100
459 , p5_a55 JTF_VARCHAR2_TABLE_100
460 , p5_a56 JTF_VARCHAR2_TABLE_100
461 , p5_a57 JTF_VARCHAR2_TABLE_100
462 , p5_a58 JTF_NUMBER_TABLE
463 , p5_a59 JTF_DATE_TABLE
464 , p5_a60 JTF_NUMBER_TABLE
465 , p5_a61 JTF_NUMBER_TABLE
466 , p6_a0 out nocopy JTF_NUMBER_TABLE
467 , p6_a1 out nocopy JTF_NUMBER_TABLE
468 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
469 , p6_a3 out nocopy JTF_NUMBER_TABLE
470 , p6_a4 out nocopy JTF_NUMBER_TABLE
471 , p6_a5 out nocopy JTF_NUMBER_TABLE
472 , p6_a6 out nocopy JTF_NUMBER_TABLE
473 , p6_a7 out nocopy JTF_NUMBER_TABLE
474 , p6_a8 out nocopy JTF_NUMBER_TABLE
475 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
476 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
477 , p6_a11 out nocopy JTF_DATE_TABLE
478 , p6_a12 out nocopy JTF_DATE_TABLE
479 , p6_a13 out nocopy JTF_DATE_TABLE
480 , p6_a14 out nocopy JTF_DATE_TABLE
481 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
482 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
483 , p6_a17 out nocopy JTF_DATE_TABLE
484 , p6_a18 out nocopy JTF_DATE_TABLE
485 , p6_a19 out nocopy JTF_DATE_TABLE
486 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
487 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_2000
488 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
489 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
490 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
491 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
492 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
493 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
494 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
495 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
496 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
497 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
498 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
499 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
500 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
501 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
502 , p6_a36 out nocopy JTF_VARCHAR2_TABLE_500
503 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_500
504 , p6_a38 out nocopy JTF_NUMBER_TABLE
505 , p6_a39 out nocopy JTF_NUMBER_TABLE
506 , p6_a40 out nocopy JTF_NUMBER_TABLE
507 , p6_a41 out nocopy JTF_NUMBER_TABLE
508 , p6_a42 out nocopy JTF_DATE_TABLE
509 , p6_a43 out nocopy JTF_NUMBER_TABLE
510 , p6_a44 out nocopy JTF_DATE_TABLE
511 , p6_a45 out nocopy JTF_NUMBER_TABLE
512 , p6_a46 out nocopy JTF_DATE_TABLE
513 , p6_a47 out nocopy JTF_NUMBER_TABLE
514 , p6_a48 out nocopy JTF_NUMBER_TABLE
515 , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100
516 , p6_a50 out nocopy JTF_NUMBER_TABLE
517 , p6_a51 out nocopy JTF_VARCHAR2_TABLE_100
518 , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000
519 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
520 , p6_a54 out nocopy JTF_VARCHAR2_TABLE_100
521 , p6_a55 out nocopy JTF_VARCHAR2_TABLE_100
522 , p6_a56 out nocopy JTF_VARCHAR2_TABLE_100
523 , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100
524 , p6_a58 out nocopy JTF_NUMBER_TABLE
525 , p6_a59 out nocopy JTF_DATE_TABLE
526 , p6_a60 out nocopy JTF_NUMBER_TABLE
527 , p6_a61 out nocopy JTF_NUMBER_TABLE
528 );
529 procedure update_asset_returns(p_api_version NUMBER
530 , p_init_msg_list VARCHAR2
531 , x_return_status out nocopy VARCHAR2
532 , x_msg_count out nocopy NUMBER
533 , x_msg_data out nocopy VARCHAR2
534 , p6_a0 out nocopy NUMBER
535 , p6_a1 out nocopy NUMBER
536 , p6_a2 out nocopy VARCHAR2
537 , p6_a3 out nocopy NUMBER
538 , p6_a4 out nocopy NUMBER
539 , p6_a5 out nocopy NUMBER
540 , p6_a6 out nocopy NUMBER
541 , p6_a7 out nocopy NUMBER
542 , p6_a8 out nocopy NUMBER
543 , p6_a9 out nocopy VARCHAR2
544 , p6_a10 out nocopy VARCHAR2
545 , p6_a11 out nocopy DATE
546 , p6_a12 out nocopy DATE
547 , p6_a13 out nocopy DATE
548 , p6_a14 out nocopy DATE
549 , p6_a15 out nocopy VARCHAR2
550 , p6_a16 out nocopy VARCHAR2
551 , p6_a17 out nocopy DATE
552 , p6_a18 out nocopy DATE
553 , p6_a19 out nocopy DATE
554 , p6_a20 out nocopy VARCHAR2
555 , p6_a21 out nocopy VARCHAR2
556 , p6_a22 out nocopy VARCHAR2
557 , p6_a23 out nocopy VARCHAR2
558 , p6_a24 out nocopy VARCHAR2
559 , p6_a25 out nocopy VARCHAR2
560 , p6_a26 out nocopy VARCHAR2
561 , p6_a27 out nocopy VARCHAR2
562 , p6_a28 out nocopy VARCHAR2
563 , p6_a29 out nocopy VARCHAR2
564 , p6_a30 out nocopy VARCHAR2
565 , p6_a31 out nocopy VARCHAR2
566 , p6_a32 out nocopy VARCHAR2
567 , p6_a33 out nocopy VARCHAR2
568 , p6_a34 out nocopy VARCHAR2
569 , p6_a35 out nocopy VARCHAR2
570 , p6_a36 out nocopy VARCHAR2
571 , p6_a37 out nocopy VARCHAR2
572 , p6_a38 out nocopy NUMBER
573 , p6_a39 out nocopy NUMBER
574 , p6_a40 out nocopy NUMBER
575 , p6_a41 out nocopy NUMBER
576 , p6_a42 out nocopy DATE
577 , p6_a43 out nocopy NUMBER
578 , p6_a44 out nocopy DATE
579 , p6_a45 out nocopy NUMBER
580 , p6_a46 out nocopy DATE
581 , p6_a47 out nocopy NUMBER
582 , p6_a48 out nocopy NUMBER
583 , p6_a49 out nocopy VARCHAR2
584 , p6_a50 out nocopy NUMBER
585 , p6_a51 out nocopy VARCHAR2
586 , p6_a52 out nocopy VARCHAR2
587 , p6_a53 out nocopy VARCHAR2
588 , p6_a54 out nocopy VARCHAR2
589 , p6_a55 out nocopy VARCHAR2
590 , p6_a56 out nocopy VARCHAR2
591 , p6_a57 out nocopy VARCHAR2
592 , p6_a58 out nocopy NUMBER
593 , p6_a59 out nocopy DATE
594 , p6_a60 out nocopy NUMBER
595 , p6_a61 out nocopy NUMBER
596 , p5_a0 NUMBER := 0-1962.0724
597 , p5_a1 NUMBER := 0-1962.0724
598 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
599 , p5_a3 NUMBER := 0-1962.0724
600 , p5_a4 NUMBER := 0-1962.0724
601 , p5_a5 NUMBER := 0-1962.0724
602 , p5_a6 NUMBER := 0-1962.0724
603 , p5_a7 NUMBER := 0-1962.0724
604 , p5_a8 NUMBER := 0-1962.0724
605 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
606 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
607 , p5_a11 DATE := fnd_api.g_miss_date
608 , p5_a12 DATE := fnd_api.g_miss_date
609 , p5_a13 DATE := fnd_api.g_miss_date
610 , p5_a14 DATE := fnd_api.g_miss_date
611 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
612 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
613 , p5_a17 DATE := fnd_api.g_miss_date
614 , p5_a18 DATE := fnd_api.g_miss_date
615 , p5_a19 DATE := fnd_api.g_miss_date
616 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
617 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
618 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
619 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
620 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
621 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
622 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
623 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
624 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
625 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
626 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
627 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
628 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
629 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
630 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
631 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
632 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
633 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
634 , p5_a38 NUMBER := 0-1962.0724
635 , p5_a39 NUMBER := 0-1962.0724
636 , p5_a40 NUMBER := 0-1962.0724
637 , p5_a41 NUMBER := 0-1962.0724
638 , p5_a42 DATE := fnd_api.g_miss_date
639 , p5_a43 NUMBER := 0-1962.0724
640 , p5_a44 DATE := fnd_api.g_miss_date
641 , p5_a45 NUMBER := 0-1962.0724
642 , p5_a46 DATE := fnd_api.g_miss_date
643 , p5_a47 NUMBER := 0-1962.0724
644 , p5_a48 NUMBER := 0-1962.0724
645 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
646 , p5_a50 NUMBER := 0-1962.0724
647 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
648 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
649 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
650 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
651 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
652 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
653 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
654 , p5_a58 NUMBER := 0-1962.0724
655 , p5_a59 DATE := fnd_api.g_miss_date
656 , p5_a60 NUMBER := 0-1962.0724
657 , p5_a61 NUMBER := 0-1962.0724
658 );
659 procedure delete_asset_returns(p_api_version NUMBER
660 , p_init_msg_list VARCHAR2
661 , x_return_status out nocopy VARCHAR2
662 , x_msg_count out nocopy NUMBER
663 , x_msg_data out nocopy VARCHAR2
664 , p5_a0 JTF_NUMBER_TABLE
665 , p5_a1 JTF_NUMBER_TABLE
666 , p5_a2 JTF_VARCHAR2_TABLE_100
667 , p5_a3 JTF_NUMBER_TABLE
668 , p5_a4 JTF_NUMBER_TABLE
669 , p5_a5 JTF_NUMBER_TABLE
670 , p5_a6 JTF_NUMBER_TABLE
671 , p5_a7 JTF_NUMBER_TABLE
672 , p5_a8 JTF_NUMBER_TABLE
673 , p5_a9 JTF_VARCHAR2_TABLE_100
674 , p5_a10 JTF_VARCHAR2_TABLE_100
675 , p5_a11 JTF_DATE_TABLE
676 , p5_a12 JTF_DATE_TABLE
677 , p5_a13 JTF_DATE_TABLE
678 , p5_a14 JTF_DATE_TABLE
679 , p5_a15 JTF_VARCHAR2_TABLE_100
680 , p5_a16 JTF_VARCHAR2_TABLE_100
681 , p5_a17 JTF_DATE_TABLE
682 , p5_a18 JTF_DATE_TABLE
683 , p5_a19 JTF_DATE_TABLE
684 , p5_a20 JTF_VARCHAR2_TABLE_100
685 , p5_a21 JTF_VARCHAR2_TABLE_2000
686 , p5_a22 JTF_VARCHAR2_TABLE_100
687 , p5_a23 JTF_VARCHAR2_TABLE_500
688 , p5_a24 JTF_VARCHAR2_TABLE_500
689 , p5_a25 JTF_VARCHAR2_TABLE_500
690 , p5_a26 JTF_VARCHAR2_TABLE_500
691 , p5_a27 JTF_VARCHAR2_TABLE_500
692 , p5_a28 JTF_VARCHAR2_TABLE_500
693 , p5_a29 JTF_VARCHAR2_TABLE_500
694 , p5_a30 JTF_VARCHAR2_TABLE_500
695 , p5_a31 JTF_VARCHAR2_TABLE_500
696 , p5_a32 JTF_VARCHAR2_TABLE_500
697 , p5_a33 JTF_VARCHAR2_TABLE_500
698 , p5_a34 JTF_VARCHAR2_TABLE_500
699 , p5_a35 JTF_VARCHAR2_TABLE_500
700 , p5_a36 JTF_VARCHAR2_TABLE_500
701 , p5_a37 JTF_VARCHAR2_TABLE_500
702 , p5_a38 JTF_NUMBER_TABLE
703 , p5_a39 JTF_NUMBER_TABLE
704 , p5_a40 JTF_NUMBER_TABLE
705 , p5_a41 JTF_NUMBER_TABLE
706 , p5_a42 JTF_DATE_TABLE
707 , p5_a43 JTF_NUMBER_TABLE
708 , p5_a44 JTF_DATE_TABLE
709 , p5_a45 JTF_NUMBER_TABLE
710 , p5_a46 JTF_DATE_TABLE
711 , p5_a47 JTF_NUMBER_TABLE
712 , p5_a48 JTF_NUMBER_TABLE
713 , p5_a49 JTF_VARCHAR2_TABLE_100
714 , p5_a50 JTF_NUMBER_TABLE
715 , p5_a51 JTF_VARCHAR2_TABLE_100
716 , p5_a52 JTF_VARCHAR2_TABLE_2000
717 , p5_a53 JTF_VARCHAR2_TABLE_100
718 , p5_a54 JTF_VARCHAR2_TABLE_100
719 , p5_a55 JTF_VARCHAR2_TABLE_100
720 , p5_a56 JTF_VARCHAR2_TABLE_100
721 , p5_a57 JTF_VARCHAR2_TABLE_100
722 , p5_a58 JTF_NUMBER_TABLE
723 , p5_a59 JTF_DATE_TABLE
724 , p5_a60 JTF_NUMBER_TABLE
725 , p5_a61 JTF_NUMBER_TABLE
726 );
727 procedure delete_asset_returns(p_api_version NUMBER
728 , p_init_msg_list VARCHAR2
729 , x_return_status out nocopy VARCHAR2
730 , x_msg_count out nocopy NUMBER
731 , x_msg_data out nocopy VARCHAR2
732 , p5_a0 NUMBER := 0-1962.0724
733 , p5_a1 NUMBER := 0-1962.0724
734 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
735 , p5_a3 NUMBER := 0-1962.0724
736 , p5_a4 NUMBER := 0-1962.0724
737 , p5_a5 NUMBER := 0-1962.0724
738 , p5_a6 NUMBER := 0-1962.0724
739 , p5_a7 NUMBER := 0-1962.0724
740 , p5_a8 NUMBER := 0-1962.0724
741 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
742 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
743 , p5_a11 DATE := fnd_api.g_miss_date
744 , p5_a12 DATE := fnd_api.g_miss_date
745 , p5_a13 DATE := fnd_api.g_miss_date
746 , p5_a14 DATE := fnd_api.g_miss_date
747 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
748 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
749 , p5_a17 DATE := fnd_api.g_miss_date
750 , p5_a18 DATE := fnd_api.g_miss_date
751 , p5_a19 DATE := fnd_api.g_miss_date
752 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
753 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
754 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
755 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
756 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
757 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
758 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
759 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
760 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
761 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
762 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
763 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
764 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
765 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
766 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
767 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
768 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
769 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
770 , p5_a38 NUMBER := 0-1962.0724
771 , p5_a39 NUMBER := 0-1962.0724
772 , p5_a40 NUMBER := 0-1962.0724
773 , p5_a41 NUMBER := 0-1962.0724
774 , p5_a42 DATE := fnd_api.g_miss_date
775 , p5_a43 NUMBER := 0-1962.0724
776 , p5_a44 DATE := fnd_api.g_miss_date
777 , p5_a45 NUMBER := 0-1962.0724
778 , p5_a46 DATE := fnd_api.g_miss_date
779 , p5_a47 NUMBER := 0-1962.0724
780 , p5_a48 NUMBER := 0-1962.0724
781 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
782 , p5_a50 NUMBER := 0-1962.0724
783 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
784 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
785 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
786 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
787 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
788 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
789 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
790 , p5_a58 NUMBER := 0-1962.0724
791 , p5_a59 DATE := fnd_api.g_miss_date
792 , p5_a60 NUMBER := 0-1962.0724
793 , p5_a61 NUMBER := 0-1962.0724
794 );
795 procedure validate_asset_returns(p_api_version NUMBER
796 , p_init_msg_list VARCHAR2
797 , x_return_status out nocopy VARCHAR2
798 , x_msg_count out nocopy NUMBER
799 , x_msg_data out nocopy VARCHAR2
800 , p5_a0 JTF_NUMBER_TABLE
801 , p5_a1 JTF_NUMBER_TABLE
802 , p5_a2 JTF_VARCHAR2_TABLE_100
803 , p5_a3 JTF_NUMBER_TABLE
804 , p5_a4 JTF_NUMBER_TABLE
805 , p5_a5 JTF_NUMBER_TABLE
806 , p5_a6 JTF_NUMBER_TABLE
807 , p5_a7 JTF_NUMBER_TABLE
808 , p5_a8 JTF_NUMBER_TABLE
809 , p5_a9 JTF_VARCHAR2_TABLE_100
810 , p5_a10 JTF_VARCHAR2_TABLE_100
811 , p5_a11 JTF_DATE_TABLE
812 , p5_a12 JTF_DATE_TABLE
813 , p5_a13 JTF_DATE_TABLE
814 , p5_a14 JTF_DATE_TABLE
815 , p5_a15 JTF_VARCHAR2_TABLE_100
816 , p5_a16 JTF_VARCHAR2_TABLE_100
817 , p5_a17 JTF_DATE_TABLE
818 , p5_a18 JTF_DATE_TABLE
819 , p5_a19 JTF_DATE_TABLE
820 , p5_a20 JTF_VARCHAR2_TABLE_100
821 , p5_a21 JTF_VARCHAR2_TABLE_2000
822 , p5_a22 JTF_VARCHAR2_TABLE_100
823 , p5_a23 JTF_VARCHAR2_TABLE_500
824 , p5_a24 JTF_VARCHAR2_TABLE_500
825 , p5_a25 JTF_VARCHAR2_TABLE_500
826 , p5_a26 JTF_VARCHAR2_TABLE_500
827 , p5_a27 JTF_VARCHAR2_TABLE_500
828 , p5_a28 JTF_VARCHAR2_TABLE_500
829 , p5_a29 JTF_VARCHAR2_TABLE_500
830 , p5_a30 JTF_VARCHAR2_TABLE_500
831 , p5_a31 JTF_VARCHAR2_TABLE_500
832 , p5_a32 JTF_VARCHAR2_TABLE_500
833 , p5_a33 JTF_VARCHAR2_TABLE_500
834 , p5_a34 JTF_VARCHAR2_TABLE_500
835 , p5_a35 JTF_VARCHAR2_TABLE_500
836 , p5_a36 JTF_VARCHAR2_TABLE_500
837 , p5_a37 JTF_VARCHAR2_TABLE_500
838 , p5_a38 JTF_NUMBER_TABLE
839 , p5_a39 JTF_NUMBER_TABLE
840 , p5_a40 JTF_NUMBER_TABLE
841 , p5_a41 JTF_NUMBER_TABLE
842 , p5_a42 JTF_DATE_TABLE
843 , p5_a43 JTF_NUMBER_TABLE
844 , p5_a44 JTF_DATE_TABLE
845 , p5_a45 JTF_NUMBER_TABLE
846 , p5_a46 JTF_DATE_TABLE
847 , p5_a47 JTF_NUMBER_TABLE
848 , p5_a48 JTF_NUMBER_TABLE
849 , p5_a49 JTF_VARCHAR2_TABLE_100
850 , p5_a50 JTF_NUMBER_TABLE
851 , p5_a51 JTF_VARCHAR2_TABLE_100
852 , p5_a52 JTF_VARCHAR2_TABLE_2000
853 , p5_a53 JTF_VARCHAR2_TABLE_100
854 , p5_a54 JTF_VARCHAR2_TABLE_100
855 , p5_a55 JTF_VARCHAR2_TABLE_100
856 , p5_a56 JTF_VARCHAR2_TABLE_100
857 , p5_a57 JTF_VARCHAR2_TABLE_100
858 , p5_a58 JTF_NUMBER_TABLE
859 , p5_a59 JTF_DATE_TABLE
860 , p5_a60 JTF_NUMBER_TABLE
861 , p5_a61 JTF_NUMBER_TABLE
862 );
863 procedure validate_asset_returns(p_api_version NUMBER
864 , p_init_msg_list VARCHAR2
865 , x_return_status out nocopy VARCHAR2
866 , x_msg_count out nocopy NUMBER
867 , x_msg_data out nocopy VARCHAR2
868 , p5_a0 NUMBER := 0-1962.0724
869 , p5_a1 NUMBER := 0-1962.0724
870 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
871 , p5_a3 NUMBER := 0-1962.0724
872 , p5_a4 NUMBER := 0-1962.0724
873 , p5_a5 NUMBER := 0-1962.0724
874 , p5_a6 NUMBER := 0-1962.0724
875 , p5_a7 NUMBER := 0-1962.0724
876 , p5_a8 NUMBER := 0-1962.0724
877 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
878 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
879 , p5_a11 DATE := fnd_api.g_miss_date
880 , p5_a12 DATE := fnd_api.g_miss_date
881 , p5_a13 DATE := fnd_api.g_miss_date
882 , p5_a14 DATE := fnd_api.g_miss_date
883 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
884 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
885 , p5_a17 DATE := fnd_api.g_miss_date
886 , p5_a18 DATE := fnd_api.g_miss_date
887 , p5_a19 DATE := fnd_api.g_miss_date
888 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
889 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
890 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
891 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
892 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
893 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
894 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
895 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
896 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
897 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
898 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
899 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
900 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
901 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
902 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
903 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
904 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
905 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
906 , p5_a38 NUMBER := 0-1962.0724
907 , p5_a39 NUMBER := 0-1962.0724
908 , p5_a40 NUMBER := 0-1962.0724
909 , p5_a41 NUMBER := 0-1962.0724
910 , p5_a42 DATE := fnd_api.g_miss_date
911 , p5_a43 NUMBER := 0-1962.0724
912 , p5_a44 DATE := fnd_api.g_miss_date
913 , p5_a45 NUMBER := 0-1962.0724
914 , p5_a46 DATE := fnd_api.g_miss_date
915 , p5_a47 NUMBER := 0-1962.0724
916 , p5_a48 NUMBER := 0-1962.0724
917 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
918 , p5_a50 NUMBER := 0-1962.0724
919 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
920 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
921 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
922 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
923 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
924 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
925 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
926 , p5_a58 NUMBER := 0-1962.0724
927 , p5_a59 DATE := fnd_api.g_miss_date
928 , p5_a60 NUMBER := 0-1962.0724
929 , p5_a61 NUMBER := 0-1962.0724
930 );
931 end okl_asset_returns_pub_w;