[Home] [Help]
PACKAGE: APPS.OKL_DEAL_ASSET_PVT_W
Source
1 package okl_deal_asset_pvt_w as
2 /* $Header: OKLEDASS.pls 120.1 2007/04/26 14:23:02 gboomina noship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy okl_deal_asset_pvt.addon_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_VARCHAR2_TABLE_100
12 , a9 JTF_VARCHAR2_TABLE_300
13 , a10 JTF_VARCHAR2_TABLE_300
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_VARCHAR2_TABLE_100
16 , a13 JTF_VARCHAR2_TABLE_200
17 , a14 JTF_VARCHAR2_TABLE_100
18 , a15 JTF_VARCHAR2_TABLE_2000
19 );
20 procedure rosetta_table_copy_out_p2(t okl_deal_asset_pvt.addon_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
21 , a1 out nocopy JTF_NUMBER_TABLE
22 , a2 out nocopy JTF_NUMBER_TABLE
23 , a3 out nocopy JTF_NUMBER_TABLE
24 , a4 out nocopy JTF_NUMBER_TABLE
25 , a5 out nocopy JTF_VARCHAR2_TABLE_100
26 , a6 out nocopy JTF_NUMBER_TABLE
27 , a7 out nocopy JTF_VARCHAR2_TABLE_100
28 , a8 out nocopy JTF_VARCHAR2_TABLE_100
29 , a9 out nocopy JTF_VARCHAR2_TABLE_300
30 , a10 out nocopy JTF_VARCHAR2_TABLE_300
31 , a11 out nocopy JTF_NUMBER_TABLE
32 , a12 out nocopy JTF_VARCHAR2_TABLE_100
33 , a13 out nocopy JTF_VARCHAR2_TABLE_200
34 , a14 out nocopy JTF_VARCHAR2_TABLE_100
35 , a15 out nocopy JTF_VARCHAR2_TABLE_2000
36 );
37
38 procedure rosetta_table_copy_in_p4(t out nocopy okl_deal_asset_pvt.down_payment_tbl_type, a0 JTF_NUMBER_TABLE
39 , a1 JTF_NUMBER_TABLE
40 , a2 JTF_VARCHAR2_TABLE_200
41 , a3 JTF_NUMBER_TABLE
42 , a4 JTF_VARCHAR2_TABLE_2000
43 , a5 JTF_VARCHAR2_TABLE_100
44 , a6 JTF_NUMBER_TABLE
45 , a7 JTF_VARCHAR2_TABLE_100
46 , a8 JTF_VARCHAR2_TABLE_100
47 );
48 procedure rosetta_table_copy_out_p4(t okl_deal_asset_pvt.down_payment_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49 , a1 out nocopy JTF_NUMBER_TABLE
50 , a2 out nocopy JTF_VARCHAR2_TABLE_200
51 , a3 out nocopy JTF_NUMBER_TABLE
52 , a4 out nocopy JTF_VARCHAR2_TABLE_2000
53 , a5 out nocopy JTF_VARCHAR2_TABLE_100
54 , a6 out nocopy JTF_NUMBER_TABLE
55 , a7 out nocopy JTF_VARCHAR2_TABLE_100
56 , a8 out nocopy JTF_VARCHAR2_TABLE_100
57 );
58
59 procedure rosetta_table_copy_in_p6(t out nocopy okl_deal_asset_pvt.tradein_tbl_type, a0 JTF_NUMBER_TABLE
60 , a1 JTF_NUMBER_TABLE
61 , a2 JTF_VARCHAR2_TABLE_200
62 , a3 JTF_NUMBER_TABLE
63 , a4 JTF_VARCHAR2_TABLE_2000
64 , a5 JTF_NUMBER_TABLE
65 );
66 procedure rosetta_table_copy_out_p6(t okl_deal_asset_pvt.tradein_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
67 , a1 out nocopy JTF_NUMBER_TABLE
68 , a2 out nocopy JTF_VARCHAR2_TABLE_200
69 , a3 out nocopy JTF_NUMBER_TABLE
70 , a4 out nocopy JTF_VARCHAR2_TABLE_2000
71 , a5 out nocopy JTF_NUMBER_TABLE
72 );
73
74 procedure process_line_billing_setup(p_api_version NUMBER
75 , p_init_msg_list VARCHAR2
76 , x_return_status out nocopy VARCHAR2
77 , x_msg_count out nocopy NUMBER
78 , x_msg_data out nocopy VARCHAR2
79 , p5_a0 NUMBER
80 , p5_a1 NUMBER
81 , p5_a2 VARCHAR2
82 , p5_a3 VARCHAR2
83 , p5_a4 NUMBER
84 , p5_a5 NUMBER
85 , p5_a6 VARCHAR2
86 , p5_a7 NUMBER
87 , p5_a8 NUMBER
88 , p5_a9 NUMBER
89 , p5_a10 NUMBER
90 , p5_a11 NUMBER
91 , p5_a12 NUMBER
92 , p5_a13 NUMBER
93 , p5_a14 NUMBER
94 , p5_a15 VARCHAR2
95 , p5_a16 VARCHAR2
96 , p5_a17 VARCHAR2
97 , p5_a18 VARCHAR2
98 , p5_a19 VARCHAR2
99 , p5_a20 VARCHAR2
100 , p5_a21 VARCHAR2
101 , p5_a22 VARCHAR2
102 , p5_a23 VARCHAR2
103 , p5_a24 VARCHAR2
104 , p5_a25 VARCHAR2
105 , p5_a26 VARCHAR2
106 , p5_a27 VARCHAR2
107 , p5_a28 VARCHAR2
108 , p5_a29 VARCHAR2
109 , p5_a30 VARCHAR2
110 , p6_a0 out nocopy NUMBER
111 , p6_a1 out nocopy NUMBER
112 , p6_a2 out nocopy VARCHAR2
113 , p6_a3 out nocopy VARCHAR2
114 , p6_a4 out nocopy NUMBER
115 , p6_a5 out nocopy NUMBER
116 , p6_a6 out nocopy VARCHAR2
117 , p6_a7 out nocopy NUMBER
118 , p6_a8 out nocopy NUMBER
119 , p6_a9 out nocopy NUMBER
120 , p6_a10 out nocopy NUMBER
121 , p6_a11 out nocopy NUMBER
122 , p6_a12 out nocopy NUMBER
123 , p6_a13 out nocopy NUMBER
124 , p6_a14 out nocopy NUMBER
125 , p6_a15 out nocopy VARCHAR2
126 , p6_a16 out nocopy VARCHAR2
127 , p6_a17 out nocopy VARCHAR2
128 , p6_a18 out nocopy VARCHAR2
129 , p6_a19 out nocopy VARCHAR2
130 , p6_a20 out nocopy VARCHAR2
131 , p6_a21 out nocopy VARCHAR2
132 , p6_a22 out nocopy VARCHAR2
133 , p6_a23 out nocopy VARCHAR2
134 , p6_a24 out nocopy VARCHAR2
135 , p6_a25 out nocopy VARCHAR2
136 , p6_a26 out nocopy VARCHAR2
137 , p6_a27 out nocopy VARCHAR2
138 , p6_a28 out nocopy VARCHAR2
139 , p6_a29 out nocopy VARCHAR2
140 , p6_a30 out nocopy VARCHAR2
141 );
142 procedure load_line_billing_setup(p_api_version NUMBER
143 , p_init_msg_list VARCHAR2
144 , x_return_status out nocopy VARCHAR2
145 , x_msg_count out nocopy NUMBER
146 , x_msg_data out nocopy VARCHAR2
147 , p_dnz_chr_id NUMBER
148 , p_cle_id NUMBER
149 , p7_a0 out nocopy NUMBER
150 , p7_a1 out nocopy NUMBER
151 , p7_a2 out nocopy VARCHAR2
152 , p7_a3 out nocopy VARCHAR2
153 , p7_a4 out nocopy NUMBER
154 , p7_a5 out nocopy NUMBER
155 , p7_a6 out nocopy VARCHAR2
156 , p7_a7 out nocopy NUMBER
157 , p7_a8 out nocopy NUMBER
158 , p7_a9 out nocopy NUMBER
159 , p7_a10 out nocopy NUMBER
160 , p7_a11 out nocopy NUMBER
161 , p7_a12 out nocopy NUMBER
162 , p7_a13 out nocopy NUMBER
163 , p7_a14 out nocopy NUMBER
164 , p7_a15 out nocopy VARCHAR2
165 , p7_a16 out nocopy VARCHAR2
166 , p7_a17 out nocopy VARCHAR2
167 , p7_a18 out nocopy VARCHAR2
168 , p7_a19 out nocopy VARCHAR2
169 , p7_a20 out nocopy VARCHAR2
170 , p7_a21 out nocopy VARCHAR2
171 , p7_a22 out nocopy VARCHAR2
172 , p7_a23 out nocopy VARCHAR2
173 , p7_a24 out nocopy VARCHAR2
174 , p7_a25 out nocopy VARCHAR2
175 , p7_a26 out nocopy VARCHAR2
176 , p7_a27 out nocopy VARCHAR2
177 , p7_a28 out nocopy VARCHAR2
178 , p7_a29 out nocopy VARCHAR2
179 , p7_a30 out nocopy VARCHAR2
180 );
181 procedure create_assetaddon_line(p_api_version NUMBER
182 , p_init_msg_list VARCHAR2
183 , x_return_status out nocopy VARCHAR2
184 , x_msg_count out nocopy NUMBER
185 , x_msg_data out nocopy VARCHAR2
186 , p5_a0 NUMBER
187 , p5_a1 NUMBER
188 , p5_a2 NUMBER
189 , p5_a3 NUMBER
190 , p5_a4 NUMBER
191 , p5_a5 VARCHAR2
192 , p5_a6 NUMBER
193 , p5_a7 VARCHAR2
194 , p5_a8 VARCHAR2
195 , p5_a9 VARCHAR2
196 , p5_a10 VARCHAR2
197 , p5_a11 NUMBER
198 , p5_a12 VARCHAR2
199 , p5_a13 VARCHAR2
200 , p5_a14 VARCHAR2
201 , p5_a15 VARCHAR2
202 , p6_a0 out nocopy NUMBER
203 , p6_a1 out nocopy NUMBER
204 , p6_a2 out nocopy NUMBER
205 , p6_a3 out nocopy NUMBER
206 , p6_a4 out nocopy NUMBER
207 , p6_a5 out nocopy VARCHAR2
208 , p6_a6 out nocopy NUMBER
209 , p6_a7 out nocopy VARCHAR2
210 , p6_a8 out nocopy VARCHAR2
211 , p6_a9 out nocopy VARCHAR2
212 , p6_a10 out nocopy VARCHAR2
213 , p6_a11 out nocopy NUMBER
214 , p6_a12 out nocopy VARCHAR2
215 , p6_a13 out nocopy VARCHAR2
216 , p6_a14 out nocopy VARCHAR2
217 , p6_a15 out nocopy VARCHAR2
218 );
219 procedure create_assetaddon_line(p_api_version NUMBER
220 , p_init_msg_list VARCHAR2
221 , x_return_status out nocopy VARCHAR2
222 , x_msg_count out nocopy NUMBER
223 , x_msg_data out nocopy VARCHAR2
224 , p5_a0 JTF_NUMBER_TABLE
225 , p5_a1 JTF_NUMBER_TABLE
226 , p5_a2 JTF_NUMBER_TABLE
227 , p5_a3 JTF_NUMBER_TABLE
228 , p5_a4 JTF_NUMBER_TABLE
229 , p5_a5 JTF_VARCHAR2_TABLE_100
230 , p5_a6 JTF_NUMBER_TABLE
231 , p5_a7 JTF_VARCHAR2_TABLE_100
232 , p5_a8 JTF_VARCHAR2_TABLE_100
233 , p5_a9 JTF_VARCHAR2_TABLE_300
234 , p5_a10 JTF_VARCHAR2_TABLE_300
235 , p5_a11 JTF_NUMBER_TABLE
236 , p5_a12 JTF_VARCHAR2_TABLE_100
237 , p5_a13 JTF_VARCHAR2_TABLE_200
238 , p5_a14 JTF_VARCHAR2_TABLE_100
239 , p5_a15 JTF_VARCHAR2_TABLE_2000
240 , p6_a0 out nocopy JTF_NUMBER_TABLE
241 , p6_a1 out nocopy JTF_NUMBER_TABLE
242 , p6_a2 out nocopy JTF_NUMBER_TABLE
243 , p6_a3 out nocopy JTF_NUMBER_TABLE
244 , p6_a4 out nocopy JTF_NUMBER_TABLE
245 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
246 , p6_a6 out nocopy JTF_NUMBER_TABLE
247 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
248 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
249 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
250 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
251 , p6_a11 out nocopy JTF_NUMBER_TABLE
252 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
253 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
254 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
255 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_2000
256 );
257 procedure update_assetaddon_line(p_api_version NUMBER
258 , p_init_msg_list VARCHAR2
259 , x_return_status out nocopy VARCHAR2
260 , x_msg_count out nocopy NUMBER
261 , x_msg_data out nocopy VARCHAR2
262 , p5_a0 NUMBER
263 , p5_a1 NUMBER
264 , p5_a2 NUMBER
265 , p5_a3 NUMBER
266 , p5_a4 NUMBER
267 , p5_a5 VARCHAR2
268 , p5_a6 NUMBER
269 , p5_a7 VARCHAR2
270 , p5_a8 VARCHAR2
271 , p5_a9 VARCHAR2
272 , p5_a10 VARCHAR2
273 , p5_a11 NUMBER
274 , p5_a12 VARCHAR2
275 , p5_a13 VARCHAR2
276 , p5_a14 VARCHAR2
277 , p5_a15 VARCHAR2
278 , p6_a0 out nocopy NUMBER
279 , p6_a1 out nocopy NUMBER
280 , p6_a2 out nocopy NUMBER
281 , p6_a3 out nocopy NUMBER
282 , p6_a4 out nocopy NUMBER
283 , p6_a5 out nocopy VARCHAR2
284 , p6_a6 out nocopy NUMBER
285 , p6_a7 out nocopy VARCHAR2
286 , p6_a8 out nocopy VARCHAR2
287 , p6_a9 out nocopy VARCHAR2
288 , p6_a10 out nocopy VARCHAR2
289 , p6_a11 out nocopy NUMBER
290 , p6_a12 out nocopy VARCHAR2
291 , p6_a13 out nocopy VARCHAR2
292 , p6_a14 out nocopy VARCHAR2
293 , p6_a15 out nocopy VARCHAR2
294 );
295 procedure update_assetaddon_line(p_api_version NUMBER
296 , p_init_msg_list VARCHAR2
297 , x_return_status out nocopy VARCHAR2
298 , x_msg_count out nocopy NUMBER
299 , x_msg_data out nocopy VARCHAR2
300 , p5_a0 JTF_NUMBER_TABLE
301 , p5_a1 JTF_NUMBER_TABLE
302 , p5_a2 JTF_NUMBER_TABLE
303 , p5_a3 JTF_NUMBER_TABLE
304 , p5_a4 JTF_NUMBER_TABLE
305 , p5_a5 JTF_VARCHAR2_TABLE_100
306 , p5_a6 JTF_NUMBER_TABLE
307 , p5_a7 JTF_VARCHAR2_TABLE_100
308 , p5_a8 JTF_VARCHAR2_TABLE_100
309 , p5_a9 JTF_VARCHAR2_TABLE_300
310 , p5_a10 JTF_VARCHAR2_TABLE_300
311 , p5_a11 JTF_NUMBER_TABLE
312 , p5_a12 JTF_VARCHAR2_TABLE_100
313 , p5_a13 JTF_VARCHAR2_TABLE_200
314 , p5_a14 JTF_VARCHAR2_TABLE_100
315 , p5_a15 JTF_VARCHAR2_TABLE_2000
316 , p6_a0 out nocopy JTF_NUMBER_TABLE
317 , p6_a1 out nocopy JTF_NUMBER_TABLE
318 , p6_a2 out nocopy JTF_NUMBER_TABLE
319 , p6_a3 out nocopy JTF_NUMBER_TABLE
320 , p6_a4 out nocopy JTF_NUMBER_TABLE
321 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
322 , p6_a6 out nocopy JTF_NUMBER_TABLE
323 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
324 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
325 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
326 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
327 , p6_a11 out nocopy JTF_NUMBER_TABLE
328 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
329 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
330 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
331 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_2000
332 );
333 procedure create_all_line(p_api_version NUMBER
334 , p_init_msg_list VARCHAR2
335 , x_return_status out nocopy VARCHAR2
336 , x_msg_count out nocopy NUMBER
337 , x_msg_data out nocopy VARCHAR2
338 , p5_a0 VARCHAR2
339 , p5_a1 NUMBER
340 , p5_a2 NUMBER
341 , p5_a3 VARCHAR2
342 , p5_a4 NUMBER
343 , p5_a5 NUMBER
344 , p5_a6 VARCHAR2
345 , p5_a7 VARCHAR2
346 , p5_a8 NUMBER
347 , p5_a9 NUMBER
348 , p5_a10 NUMBER
349 , p5_a11 VARCHAR2
350 , p5_a12 VARCHAR2
351 , p5_a13 NUMBER
352 , p5_a14 NUMBER
353 , p5_a15 VARCHAR2
354 , p5_a16 NUMBER
355 , p5_a17 VARCHAR2
356 , p5_a18 NUMBER
357 , p5_a19 VARCHAR2
358 , p5_a20 VARCHAR2
359 , p5_a21 DATE
360 , p5_a22 DATE
361 , p5_a23 NUMBER
362 , p5_a24 NUMBER
363 , p5_a25 VARCHAR2
364 , p5_a26 NUMBER
365 , p5_a27 NUMBER
366 , p5_a28 VARCHAR2
367 , p5_a29 NUMBER
368 , p5_a30 NUMBER
369 , p5_a31 NUMBER
370 , p5_a32 NUMBER
371 , p5_a33 NUMBER
372 , p5_a34 NUMBER
373 , p5_a35 VARCHAR2
374 , p5_a36 VARCHAR2
375 , p5_a37 VARCHAR2
376 , p5_a38 VARCHAR2
377 , p5_a39 VARCHAR2
378 , p5_a40 VARCHAR2
379 , p5_a41 VARCHAR2
380 , p5_a42 VARCHAR2
381 , p5_a43 VARCHAR2
382 , p5_a44 VARCHAR2
383 , p5_a45 VARCHAR2
384 , p5_a46 VARCHAR2
385 , p5_a47 VARCHAR2
386 , p5_a48 VARCHAR2
387 , p5_a49 VARCHAR2
388 , p5_a50 VARCHAR2
389 , p6_a0 out nocopy VARCHAR2
390 , p6_a1 out nocopy NUMBER
391 , p6_a2 out nocopy NUMBER
392 , p6_a3 out nocopy VARCHAR2
393 , p6_a4 out nocopy NUMBER
394 , p6_a5 out nocopy NUMBER
395 , p6_a6 out nocopy VARCHAR2
396 , p6_a7 out nocopy VARCHAR2
397 , p6_a8 out nocopy NUMBER
398 , p6_a9 out nocopy NUMBER
399 , p6_a10 out nocopy NUMBER
400 , p6_a11 out nocopy VARCHAR2
401 , p6_a12 out nocopy VARCHAR2
402 , p6_a13 out nocopy NUMBER
403 , p6_a14 out nocopy NUMBER
404 , p6_a15 out nocopy VARCHAR2
405 , p6_a16 out nocopy NUMBER
406 , p6_a17 out nocopy VARCHAR2
407 , p6_a18 out nocopy NUMBER
408 , p6_a19 out nocopy VARCHAR2
409 , p6_a20 out nocopy VARCHAR2
410 , p6_a21 out nocopy DATE
411 , p6_a22 out nocopy DATE
412 , p6_a23 out nocopy NUMBER
413 , p6_a24 out nocopy NUMBER
414 , p6_a25 out nocopy VARCHAR2
415 , p6_a26 out nocopy NUMBER
416 , p6_a27 out nocopy NUMBER
417 , p6_a28 out nocopy VARCHAR2
418 , p6_a29 out nocopy NUMBER
419 , p6_a30 out nocopy NUMBER
420 , p6_a31 out nocopy NUMBER
421 , p6_a32 out nocopy NUMBER
422 , p6_a33 out nocopy NUMBER
423 , p6_a34 out nocopy NUMBER
424 , p6_a35 out nocopy VARCHAR2
425 , p6_a36 out nocopy VARCHAR2
426 , p6_a37 out nocopy VARCHAR2
427 , p6_a38 out nocopy VARCHAR2
428 , p6_a39 out nocopy VARCHAR2
429 , p6_a40 out nocopy VARCHAR2
430 , p6_a41 out nocopy VARCHAR2
431 , p6_a42 out nocopy VARCHAR2
432 , p6_a43 out nocopy VARCHAR2
433 , p6_a44 out nocopy VARCHAR2
434 , p6_a45 out nocopy VARCHAR2
435 , p6_a46 out nocopy VARCHAR2
436 , p6_a47 out nocopy VARCHAR2
437 , p6_a48 out nocopy VARCHAR2
438 , p6_a49 out nocopy VARCHAR2
439 , p6_a50 out nocopy VARCHAR2
440 );
441 procedure update_all_line(p_api_version NUMBER
442 , p_init_msg_list VARCHAR2
443 , x_return_status out nocopy VARCHAR2
444 , x_msg_count out nocopy NUMBER
445 , x_msg_data out nocopy VARCHAR2
446 , p5_a0 VARCHAR2
447 , p5_a1 NUMBER
448 , p5_a2 NUMBER
449 , p5_a3 VARCHAR2
450 , p5_a4 NUMBER
451 , p5_a5 NUMBER
452 , p5_a6 VARCHAR2
453 , p5_a7 VARCHAR2
454 , p5_a8 NUMBER
455 , p5_a9 NUMBER
456 , p5_a10 NUMBER
457 , p5_a11 VARCHAR2
458 , p5_a12 VARCHAR2
459 , p5_a13 NUMBER
460 , p5_a14 NUMBER
461 , p5_a15 VARCHAR2
462 , p5_a16 NUMBER
463 , p5_a17 VARCHAR2
464 , p5_a18 NUMBER
465 , p5_a19 VARCHAR2
466 , p5_a20 VARCHAR2
467 , p5_a21 DATE
468 , p5_a22 DATE
469 , p5_a23 NUMBER
470 , p5_a24 NUMBER
471 , p5_a25 VARCHAR2
472 , p5_a26 NUMBER
473 , p5_a27 NUMBER
474 , p5_a28 VARCHAR2
475 , p5_a29 NUMBER
476 , p5_a30 NUMBER
477 , p5_a31 NUMBER
478 , p5_a32 NUMBER
479 , p5_a33 NUMBER
480 , p5_a34 NUMBER
481 , p5_a35 VARCHAR2
482 , p5_a36 VARCHAR2
483 , p5_a37 VARCHAR2
484 , p5_a38 VARCHAR2
485 , p5_a39 VARCHAR2
486 , p5_a40 VARCHAR2
487 , p5_a41 VARCHAR2
488 , p5_a42 VARCHAR2
489 , p5_a43 VARCHAR2
490 , p5_a44 VARCHAR2
491 , p5_a45 VARCHAR2
492 , p5_a46 VARCHAR2
493 , p5_a47 VARCHAR2
494 , p5_a48 VARCHAR2
495 , p5_a49 VARCHAR2
496 , p5_a50 VARCHAR2
497 , p6_a0 out nocopy VARCHAR2
498 , p6_a1 out nocopy NUMBER
499 , p6_a2 out nocopy NUMBER
500 , p6_a3 out nocopy VARCHAR2
501 , p6_a4 out nocopy NUMBER
502 , p6_a5 out nocopy NUMBER
503 , p6_a6 out nocopy VARCHAR2
504 , p6_a7 out nocopy VARCHAR2
505 , p6_a8 out nocopy NUMBER
506 , p6_a9 out nocopy NUMBER
507 , p6_a10 out nocopy NUMBER
508 , p6_a11 out nocopy VARCHAR2
509 , p6_a12 out nocopy VARCHAR2
510 , p6_a13 out nocopy NUMBER
511 , p6_a14 out nocopy NUMBER
512 , p6_a15 out nocopy VARCHAR2
513 , p6_a16 out nocopy NUMBER
514 , p6_a17 out nocopy VARCHAR2
515 , p6_a18 out nocopy NUMBER
516 , p6_a19 out nocopy VARCHAR2
517 , p6_a20 out nocopy VARCHAR2
518 , p6_a21 out nocopy DATE
519 , p6_a22 out nocopy DATE
520 , p6_a23 out nocopy NUMBER
521 , p6_a24 out nocopy NUMBER
522 , p6_a25 out nocopy VARCHAR2
523 , p6_a26 out nocopy NUMBER
524 , p6_a27 out nocopy NUMBER
525 , p6_a28 out nocopy VARCHAR2
526 , p6_a29 out nocopy NUMBER
527 , p6_a30 out nocopy NUMBER
528 , p6_a31 out nocopy NUMBER
529 , p6_a32 out nocopy NUMBER
530 , p6_a33 out nocopy NUMBER
531 , p6_a34 out nocopy NUMBER
532 , p6_a35 out nocopy VARCHAR2
533 , p6_a36 out nocopy VARCHAR2
534 , p6_a37 out nocopy VARCHAR2
535 , p6_a38 out nocopy VARCHAR2
536 , p6_a39 out nocopy VARCHAR2
537 , p6_a40 out nocopy VARCHAR2
538 , p6_a41 out nocopy VARCHAR2
539 , p6_a42 out nocopy VARCHAR2
540 , p6_a43 out nocopy VARCHAR2
541 , p6_a44 out nocopy VARCHAR2
542 , p6_a45 out nocopy VARCHAR2
543 , p6_a46 out nocopy VARCHAR2
544 , p6_a47 out nocopy VARCHAR2
545 , p6_a48 out nocopy VARCHAR2
546 , p6_a49 out nocopy VARCHAR2
547 , p6_a50 out nocopy VARCHAR2
548 );
549 procedure load_all_line(p_api_version NUMBER
550 , p_init_msg_list VARCHAR2
551 , x_return_status out nocopy VARCHAR2
552 , x_msg_count out nocopy NUMBER
553 , x_msg_data out nocopy VARCHAR2
554 , p_chr_id NUMBER
555 , p_clev_fin_id NUMBER
556 , p7_a0 out nocopy VARCHAR2
557 , p7_a1 out nocopy NUMBER
558 , p7_a2 out nocopy NUMBER
559 , p7_a3 out nocopy VARCHAR2
560 , p7_a4 out nocopy NUMBER
561 , p7_a5 out nocopy NUMBER
562 , p7_a6 out nocopy VARCHAR2
563 , p7_a7 out nocopy VARCHAR2
564 , p7_a8 out nocopy NUMBER
565 , p7_a9 out nocopy NUMBER
566 , p7_a10 out nocopy NUMBER
567 , p7_a11 out nocopy VARCHAR2
568 , p7_a12 out nocopy VARCHAR2
569 , p7_a13 out nocopy NUMBER
570 , p7_a14 out nocopy NUMBER
571 , p7_a15 out nocopy VARCHAR2
572 , p7_a16 out nocopy NUMBER
573 , p7_a17 out nocopy VARCHAR2
574 , p7_a18 out nocopy NUMBER
575 , p7_a19 out nocopy VARCHAR2
576 , p7_a20 out nocopy VARCHAR2
577 , p7_a21 out nocopy DATE
578 , p7_a22 out nocopy DATE
579 , p7_a23 out nocopy NUMBER
580 , p7_a24 out nocopy NUMBER
581 , p7_a25 out nocopy VARCHAR2
582 , p7_a26 out nocopy NUMBER
583 , p7_a27 out nocopy NUMBER
584 , p7_a28 out nocopy VARCHAR2
585 , p7_a29 out nocopy NUMBER
586 , p7_a30 out nocopy NUMBER
587 , p7_a31 out nocopy NUMBER
588 , p7_a32 out nocopy NUMBER
589 , p7_a33 out nocopy NUMBER
590 , p7_a34 out nocopy NUMBER
591 , p7_a35 out nocopy VARCHAR2
592 , p7_a36 out nocopy VARCHAR2
593 , p7_a37 out nocopy VARCHAR2
594 , p7_a38 out nocopy VARCHAR2
595 , p7_a39 out nocopy VARCHAR2
596 , p7_a40 out nocopy VARCHAR2
597 , p7_a41 out nocopy VARCHAR2
598 , p7_a42 out nocopy VARCHAR2
599 , p7_a43 out nocopy VARCHAR2
600 , p7_a44 out nocopy VARCHAR2
601 , p7_a45 out nocopy VARCHAR2
602 , p7_a46 out nocopy VARCHAR2
603 , p7_a47 out nocopy VARCHAR2
604 , p7_a48 out nocopy VARCHAR2
605 , p7_a49 out nocopy VARCHAR2
606 , p7_a50 out nocopy VARCHAR2
607 );
608 procedure allocate_amount_tradein(p_api_version NUMBER
609 , p_init_msg_list VARCHAR2
610 , x_return_status out nocopy VARCHAR2
611 , x_msg_count out nocopy NUMBER
612 , x_msg_data out nocopy VARCHAR2
613 , p_chr_id NUMBER
614 , p_tradein_amount NUMBER
615 , p_mode VARCHAR2
616 , p8_a0 out nocopy JTF_NUMBER_TABLE
617 , p8_a1 out nocopy JTF_NUMBER_TABLE
618 , p8_a2 out nocopy JTF_VARCHAR2_TABLE_200
619 , p8_a3 out nocopy JTF_NUMBER_TABLE
620 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
621 , p8_a5 out nocopy JTF_NUMBER_TABLE
622 );
623 procedure allocate_amount_down_payment(p_api_version NUMBER
624 , p_init_msg_list VARCHAR2
625 , x_return_status out nocopy VARCHAR2
626 , x_msg_count out nocopy NUMBER
627 , x_msg_data out nocopy VARCHAR2
628 , p_chr_id NUMBER
629 , p_down_payment NUMBER
630 , p_basis VARCHAR2
631 , p_mode VARCHAR2
632 , p9_a0 out nocopy JTF_NUMBER_TABLE
633 , p9_a1 out nocopy JTF_NUMBER_TABLE
634 , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
635 , p9_a3 out nocopy JTF_NUMBER_TABLE
636 , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
637 , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
638 , p9_a6 out nocopy JTF_NUMBER_TABLE
639 , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
640 , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
641 );
642 end okl_deal_asset_pvt_w;