22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p13(t out nocopy okl_am_lease_loan_trmnt_pvt.term_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_200
27: , a2 JTF_VARCHAR2_TABLE_200
28: , a3 JTF_DATE_TABLE
29: , a4 JTF_VARCHAR2_TABLE_200
30: , a5 JTF_DATE_TABLE
23: end;
24:
25: procedure rosetta_table_copy_in_p13(t out nocopy okl_am_lease_loan_trmnt_pvt.term_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_200
27: , a2 JTF_VARCHAR2_TABLE_200
28: , a3 JTF_DATE_TABLE
29: , a4 JTF_VARCHAR2_TABLE_200
30: , a5 JTF_DATE_TABLE
31: , a6 JTF_VARCHAR2_TABLE_200
25: procedure rosetta_table_copy_in_p13(t out nocopy okl_am_lease_loan_trmnt_pvt.term_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_200
27: , a2 JTF_VARCHAR2_TABLE_200
28: , a3 JTF_DATE_TABLE
29: , a4 JTF_VARCHAR2_TABLE_200
30: , a5 JTF_DATE_TABLE
31: , a6 JTF_VARCHAR2_TABLE_200
32: , a7 JTF_NUMBER_TABLE
33: , a8 JTF_VARCHAR2_TABLE_2000
27: , a2 JTF_VARCHAR2_TABLE_200
28: , a3 JTF_DATE_TABLE
29: , a4 JTF_VARCHAR2_TABLE_200
30: , a5 JTF_DATE_TABLE
31: , a6 JTF_VARCHAR2_TABLE_200
32: , a7 JTF_NUMBER_TABLE
33: , a8 JTF_VARCHAR2_TABLE_2000
34: , a9 JTF_VARCHAR2_TABLE_2000
35: , a10 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_VARCHAR2_TABLE_200
30: , a5 JTF_DATE_TABLE
31: , a6 JTF_VARCHAR2_TABLE_200
32: , a7 JTF_NUMBER_TABLE
33: , a8 JTF_VARCHAR2_TABLE_2000
34: , a9 JTF_VARCHAR2_TABLE_2000
35: , a10 JTF_VARCHAR2_TABLE_100
36: , a11 JTF_VARCHAR2_TABLE_200
37: , a12 JTF_VARCHAR2_TABLE_100
30: , a5 JTF_DATE_TABLE
31: , a6 JTF_VARCHAR2_TABLE_200
32: , a7 JTF_NUMBER_TABLE
33: , a8 JTF_VARCHAR2_TABLE_2000
34: , a9 JTF_VARCHAR2_TABLE_2000
35: , a10 JTF_VARCHAR2_TABLE_100
36: , a11 JTF_VARCHAR2_TABLE_200
37: , a12 JTF_VARCHAR2_TABLE_100
38: ) as
32: , a7 JTF_NUMBER_TABLE
33: , a8 JTF_VARCHAR2_TABLE_2000
34: , a9 JTF_VARCHAR2_TABLE_2000
35: , a10 JTF_VARCHAR2_TABLE_100
36: , a11 JTF_VARCHAR2_TABLE_200
37: , a12 JTF_VARCHAR2_TABLE_100
38: ) as
39: ddindx binary_integer; indx binary_integer;
40: begin
65: end if;
66: end if;
67: end rosetta_table_copy_in_p13;
68: procedure rosetta_table_copy_out_p13(t okl_am_lease_loan_trmnt_pvt.term_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_VARCHAR2_TABLE_200
70: , a2 out nocopy JTF_VARCHAR2_TABLE_200
71: , a3 out nocopy JTF_DATE_TABLE
72: , a4 out nocopy JTF_VARCHAR2_TABLE_200
73: , a5 out nocopy JTF_DATE_TABLE
66: end if;
67: end rosetta_table_copy_in_p13;
68: procedure rosetta_table_copy_out_p13(t okl_am_lease_loan_trmnt_pvt.term_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_VARCHAR2_TABLE_200
70: , a2 out nocopy JTF_VARCHAR2_TABLE_200
71: , a3 out nocopy JTF_DATE_TABLE
72: , a4 out nocopy JTF_VARCHAR2_TABLE_200
73: , a5 out nocopy JTF_DATE_TABLE
74: , a6 out nocopy JTF_VARCHAR2_TABLE_200
68: procedure rosetta_table_copy_out_p13(t okl_am_lease_loan_trmnt_pvt.term_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_VARCHAR2_TABLE_200
70: , a2 out nocopy JTF_VARCHAR2_TABLE_200
71: , a3 out nocopy JTF_DATE_TABLE
72: , a4 out nocopy JTF_VARCHAR2_TABLE_200
73: , a5 out nocopy JTF_DATE_TABLE
74: , a6 out nocopy JTF_VARCHAR2_TABLE_200
75: , a7 out nocopy JTF_NUMBER_TABLE
76: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
70: , a2 out nocopy JTF_VARCHAR2_TABLE_200
71: , a3 out nocopy JTF_DATE_TABLE
72: , a4 out nocopy JTF_VARCHAR2_TABLE_200
73: , a5 out nocopy JTF_DATE_TABLE
74: , a6 out nocopy JTF_VARCHAR2_TABLE_200
75: , a7 out nocopy JTF_NUMBER_TABLE
76: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
77: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
78: , a10 out nocopy JTF_VARCHAR2_TABLE_100
72: , a4 out nocopy JTF_VARCHAR2_TABLE_200
73: , a5 out nocopy JTF_DATE_TABLE
74: , a6 out nocopy JTF_VARCHAR2_TABLE_200
75: , a7 out nocopy JTF_NUMBER_TABLE
76: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
77: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
78: , a10 out nocopy JTF_VARCHAR2_TABLE_100
79: , a11 out nocopy JTF_VARCHAR2_TABLE_200
80: , a12 out nocopy JTF_VARCHAR2_TABLE_100
73: , a5 out nocopy JTF_DATE_TABLE
74: , a6 out nocopy JTF_VARCHAR2_TABLE_200
75: , a7 out nocopy JTF_NUMBER_TABLE
76: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
77: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
78: , a10 out nocopy JTF_VARCHAR2_TABLE_100
79: , a11 out nocopy JTF_VARCHAR2_TABLE_200
80: , a12 out nocopy JTF_VARCHAR2_TABLE_100
81: ) as
75: , a7 out nocopy JTF_NUMBER_TABLE
76: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
77: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
78: , a10 out nocopy JTF_VARCHAR2_TABLE_100
79: , a11 out nocopy JTF_VARCHAR2_TABLE_200
80: , a12 out nocopy JTF_VARCHAR2_TABLE_100
81: ) as
82: ddindx binary_integer; indx binary_integer;
83: begin
82: ddindx binary_integer; indx binary_integer;
83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_NUMBER_TABLE();
86: a1 := JTF_VARCHAR2_TABLE_200();
87: a2 := JTF_VARCHAR2_TABLE_200();
88: a3 := JTF_DATE_TABLE();
89: a4 := JTF_VARCHAR2_TABLE_200();
90: a5 := JTF_DATE_TABLE();
83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_NUMBER_TABLE();
86: a1 := JTF_VARCHAR2_TABLE_200();
87: a2 := JTF_VARCHAR2_TABLE_200();
88: a3 := JTF_DATE_TABLE();
89: a4 := JTF_VARCHAR2_TABLE_200();
90: a5 := JTF_DATE_TABLE();
91: a6 := JTF_VARCHAR2_TABLE_200();
85: a0 := JTF_NUMBER_TABLE();
86: a1 := JTF_VARCHAR2_TABLE_200();
87: a2 := JTF_VARCHAR2_TABLE_200();
88: a3 := JTF_DATE_TABLE();
89: a4 := JTF_VARCHAR2_TABLE_200();
90: a5 := JTF_DATE_TABLE();
91: a6 := JTF_VARCHAR2_TABLE_200();
92: a7 := JTF_NUMBER_TABLE();
93: a8 := JTF_VARCHAR2_TABLE_2000();
87: a2 := JTF_VARCHAR2_TABLE_200();
88: a3 := JTF_DATE_TABLE();
89: a4 := JTF_VARCHAR2_TABLE_200();
90: a5 := JTF_DATE_TABLE();
91: a6 := JTF_VARCHAR2_TABLE_200();
92: a7 := JTF_NUMBER_TABLE();
93: a8 := JTF_VARCHAR2_TABLE_2000();
94: a9 := JTF_VARCHAR2_TABLE_2000();
95: a10 := JTF_VARCHAR2_TABLE_100();
89: a4 := JTF_VARCHAR2_TABLE_200();
90: a5 := JTF_DATE_TABLE();
91: a6 := JTF_VARCHAR2_TABLE_200();
92: a7 := JTF_NUMBER_TABLE();
93: a8 := JTF_VARCHAR2_TABLE_2000();
94: a9 := JTF_VARCHAR2_TABLE_2000();
95: a10 := JTF_VARCHAR2_TABLE_100();
96: a11 := JTF_VARCHAR2_TABLE_200();
97: a12 := JTF_VARCHAR2_TABLE_100();
90: a5 := JTF_DATE_TABLE();
91: a6 := JTF_VARCHAR2_TABLE_200();
92: a7 := JTF_NUMBER_TABLE();
93: a8 := JTF_VARCHAR2_TABLE_2000();
94: a9 := JTF_VARCHAR2_TABLE_2000();
95: a10 := JTF_VARCHAR2_TABLE_100();
96: a11 := JTF_VARCHAR2_TABLE_200();
97: a12 := JTF_VARCHAR2_TABLE_100();
98: else
92: a7 := JTF_NUMBER_TABLE();
93: a8 := JTF_VARCHAR2_TABLE_2000();
94: a9 := JTF_VARCHAR2_TABLE_2000();
95: a10 := JTF_VARCHAR2_TABLE_100();
96: a11 := JTF_VARCHAR2_TABLE_200();
97: a12 := JTF_VARCHAR2_TABLE_100();
98: else
99: a0 := JTF_NUMBER_TABLE();
100: a1 := JTF_VARCHAR2_TABLE_200();
96: a11 := JTF_VARCHAR2_TABLE_200();
97: a12 := JTF_VARCHAR2_TABLE_100();
98: else
99: a0 := JTF_NUMBER_TABLE();
100: a1 := JTF_VARCHAR2_TABLE_200();
101: a2 := JTF_VARCHAR2_TABLE_200();
102: a3 := JTF_DATE_TABLE();
103: a4 := JTF_VARCHAR2_TABLE_200();
104: a5 := JTF_DATE_TABLE();
97: a12 := JTF_VARCHAR2_TABLE_100();
98: else
99: a0 := JTF_NUMBER_TABLE();
100: a1 := JTF_VARCHAR2_TABLE_200();
101: a2 := JTF_VARCHAR2_TABLE_200();
102: a3 := JTF_DATE_TABLE();
103: a4 := JTF_VARCHAR2_TABLE_200();
104: a5 := JTF_DATE_TABLE();
105: a6 := JTF_VARCHAR2_TABLE_200();
99: a0 := JTF_NUMBER_TABLE();
100: a1 := JTF_VARCHAR2_TABLE_200();
101: a2 := JTF_VARCHAR2_TABLE_200();
102: a3 := JTF_DATE_TABLE();
103: a4 := JTF_VARCHAR2_TABLE_200();
104: a5 := JTF_DATE_TABLE();
105: a6 := JTF_VARCHAR2_TABLE_200();
106: a7 := JTF_NUMBER_TABLE();
107: a8 := JTF_VARCHAR2_TABLE_2000();
101: a2 := JTF_VARCHAR2_TABLE_200();
102: a3 := JTF_DATE_TABLE();
103: a4 := JTF_VARCHAR2_TABLE_200();
104: a5 := JTF_DATE_TABLE();
105: a6 := JTF_VARCHAR2_TABLE_200();
106: a7 := JTF_NUMBER_TABLE();
107: a8 := JTF_VARCHAR2_TABLE_2000();
108: a9 := JTF_VARCHAR2_TABLE_2000();
109: a10 := JTF_VARCHAR2_TABLE_100();
103: a4 := JTF_VARCHAR2_TABLE_200();
104: a5 := JTF_DATE_TABLE();
105: a6 := JTF_VARCHAR2_TABLE_200();
106: a7 := JTF_NUMBER_TABLE();
107: a8 := JTF_VARCHAR2_TABLE_2000();
108: a9 := JTF_VARCHAR2_TABLE_2000();
109: a10 := JTF_VARCHAR2_TABLE_100();
110: a11 := JTF_VARCHAR2_TABLE_200();
111: a12 := JTF_VARCHAR2_TABLE_100();
104: a5 := JTF_DATE_TABLE();
105: a6 := JTF_VARCHAR2_TABLE_200();
106: a7 := JTF_NUMBER_TABLE();
107: a8 := JTF_VARCHAR2_TABLE_2000();
108: a9 := JTF_VARCHAR2_TABLE_2000();
109: a10 := JTF_VARCHAR2_TABLE_100();
110: a11 := JTF_VARCHAR2_TABLE_200();
111: a12 := JTF_VARCHAR2_TABLE_100();
112: if t.count > 0 then
106: a7 := JTF_NUMBER_TABLE();
107: a8 := JTF_VARCHAR2_TABLE_2000();
108: a9 := JTF_VARCHAR2_TABLE_2000();
109: a10 := JTF_VARCHAR2_TABLE_100();
110: a11 := JTF_VARCHAR2_TABLE_200();
111: a12 := JTF_VARCHAR2_TABLE_100();
112: if t.count > 0 then
113: a0.extend(t.count);
114: a1.extend(t.count);
407: , x_return_status out nocopy VARCHAR2
408: , x_msg_count out nocopy NUMBER
409: , x_msg_data out nocopy VARCHAR2
410: , p5_a0 JTF_NUMBER_TABLE
411: , p5_a1 JTF_VARCHAR2_TABLE_200
412: , p5_a2 JTF_VARCHAR2_TABLE_200
413: , p5_a3 JTF_DATE_TABLE
414: , p5_a4 JTF_VARCHAR2_TABLE_200
415: , p5_a5 JTF_DATE_TABLE
408: , x_msg_count out nocopy NUMBER
409: , x_msg_data out nocopy VARCHAR2
410: , p5_a0 JTF_NUMBER_TABLE
411: , p5_a1 JTF_VARCHAR2_TABLE_200
412: , p5_a2 JTF_VARCHAR2_TABLE_200
413: , p5_a3 JTF_DATE_TABLE
414: , p5_a4 JTF_VARCHAR2_TABLE_200
415: , p5_a5 JTF_DATE_TABLE
416: , p5_a6 JTF_VARCHAR2_TABLE_200
410: , p5_a0 JTF_NUMBER_TABLE
411: , p5_a1 JTF_VARCHAR2_TABLE_200
412: , p5_a2 JTF_VARCHAR2_TABLE_200
413: , p5_a3 JTF_DATE_TABLE
414: , p5_a4 JTF_VARCHAR2_TABLE_200
415: , p5_a5 JTF_DATE_TABLE
416: , p5_a6 JTF_VARCHAR2_TABLE_200
417: , p5_a7 JTF_NUMBER_TABLE
418: , p5_a8 JTF_VARCHAR2_TABLE_2000
412: , p5_a2 JTF_VARCHAR2_TABLE_200
413: , p5_a3 JTF_DATE_TABLE
414: , p5_a4 JTF_VARCHAR2_TABLE_200
415: , p5_a5 JTF_DATE_TABLE
416: , p5_a6 JTF_VARCHAR2_TABLE_200
417: , p5_a7 JTF_NUMBER_TABLE
418: , p5_a8 JTF_VARCHAR2_TABLE_2000
419: , p5_a9 JTF_VARCHAR2_TABLE_2000
420: , p5_a10 JTF_VARCHAR2_TABLE_100
414: , p5_a4 JTF_VARCHAR2_TABLE_200
415: , p5_a5 JTF_DATE_TABLE
416: , p5_a6 JTF_VARCHAR2_TABLE_200
417: , p5_a7 JTF_NUMBER_TABLE
418: , p5_a8 JTF_VARCHAR2_TABLE_2000
419: , p5_a9 JTF_VARCHAR2_TABLE_2000
420: , p5_a10 JTF_VARCHAR2_TABLE_100
421: , p5_a11 JTF_VARCHAR2_TABLE_200
422: , p5_a12 JTF_VARCHAR2_TABLE_100
415: , p5_a5 JTF_DATE_TABLE
416: , p5_a6 JTF_VARCHAR2_TABLE_200
417: , p5_a7 JTF_NUMBER_TABLE
418: , p5_a8 JTF_VARCHAR2_TABLE_2000
419: , p5_a9 JTF_VARCHAR2_TABLE_2000
420: , p5_a10 JTF_VARCHAR2_TABLE_100
421: , p5_a11 JTF_VARCHAR2_TABLE_200
422: , p5_a12 JTF_VARCHAR2_TABLE_100
423: , p6_a0 JTF_NUMBER_TABLE
417: , p5_a7 JTF_NUMBER_TABLE
418: , p5_a8 JTF_VARCHAR2_TABLE_2000
419: , p5_a9 JTF_VARCHAR2_TABLE_2000
420: , p5_a10 JTF_VARCHAR2_TABLE_100
421: , p5_a11 JTF_VARCHAR2_TABLE_200
422: , p5_a12 JTF_VARCHAR2_TABLE_100
423: , p6_a0 JTF_NUMBER_TABLE
424: , p6_a1 JTF_NUMBER_TABLE
425: , p6_a2 JTF_VARCHAR2_TABLE_100
437: , p6_a14 JTF_DATE_TABLE
438: , p6_a15 JTF_VARCHAR2_TABLE_100
439: , p6_a16 JTF_VARCHAR2_TABLE_100
440: , p6_a17 JTF_NUMBER_TABLE
441: , p6_a18 JTF_VARCHAR2_TABLE_200
442: , p6_a19 JTF_VARCHAR2_TABLE_100
443: , p6_a20 JTF_VARCHAR2_TABLE_500
444: , p6_a21 JTF_VARCHAR2_TABLE_500
445: , p6_a22 JTF_VARCHAR2_TABLE_500
476: , p6_a53 JTF_NUMBER_TABLE
477: , p6_a54 JTF_NUMBER_TABLE
478: , p6_a55 JTF_VARCHAR2_TABLE_100
479: , p6_a56 JTF_NUMBER_TABLE
480: , p6_a57 JTF_VARCHAR2_TABLE_2000
481: , p6_a58 JTF_DATE_TABLE
482: , p6_a59 JTF_VARCHAR2_TABLE_100
483: , p6_a60 JTF_VARCHAR2_TABLE_100
484: , p6_a61 JTF_VARCHAR2_TABLE_100
505: , p6_a82 JTF_DATE_TABLE
506: , p6_a83 JTF_NUMBER_TABLE
507: , p6_a84 JTF_DATE_TABLE
508: , p6_a85 JTF_VARCHAR2_TABLE_100
509: , p6_a86 JTF_VARCHAR2_TABLE_200
510: , p6_a87 JTF_VARCHAR2_TABLE_100
511: , p6_a88 JTF_VARCHAR2_TABLE_200
512: , p6_a89 JTF_VARCHAR2_TABLE_100
513: , p6_a90 JTF_VARCHAR2_TABLE_100
507: , p6_a84 JTF_DATE_TABLE
508: , p6_a85 JTF_VARCHAR2_TABLE_100
509: , p6_a86 JTF_VARCHAR2_TABLE_200
510: , p6_a87 JTF_VARCHAR2_TABLE_100
511: , p6_a88 JTF_VARCHAR2_TABLE_200
512: , p6_a89 JTF_VARCHAR2_TABLE_100
513: , p6_a90 JTF_VARCHAR2_TABLE_100
514: , p6_a91 JTF_VARCHAR2_TABLE_100
515: , p6_a92 JTF_VARCHAR2_TABLE_100