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
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
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
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: );
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
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
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
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
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: );
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: );
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
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
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: );
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
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
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
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
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
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
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
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
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
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
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: );
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
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
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
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
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
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
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
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
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
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: );
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
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: );
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;
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;