1: package lns_financials_w AUTHID CURRENT_USER as
2: /* $Header: LNS_FINANCIALJ_S.pls 120.13.12020000.2 2012/07/19 20:56:23 scherkas ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_financials.rate_schedule_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
2: /* $Header: LNS_FINANCIALJ_S.pls 120.13.12020000.2 2012/07/19 20:56:23 scherkas ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_financials.rate_schedule_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_financials.rate_schedule_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: );
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p1(t lns_financials.rate_schedule_tbl, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_DATE_TABLE
16: , a2 out nocopy JTF_DATE_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p1(t lns_financials.rate_schedule_tbl, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_DATE_TABLE
16: , a2 out nocopy JTF_DATE_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_VARCHAR2_TABLE_100
14: procedure rosetta_table_copy_out_p1(t lns_financials.rate_schedule_tbl, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_DATE_TABLE
16: , a2 out nocopy JTF_DATE_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_VARCHAR2_TABLE_100
22: , a8 out nocopy JTF_VARCHAR2_TABLE_100
15: , a1 out nocopy JTF_DATE_TABLE
16: , a2 out nocopy JTF_DATE_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_VARCHAR2_TABLE_100
22: , a8 out nocopy JTF_VARCHAR2_TABLE_100
23: , a9 out nocopy JTF_VARCHAR2_TABLE_100
16: , a2 out nocopy JTF_DATE_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_VARCHAR2_TABLE_100
22: , a8 out nocopy JTF_VARCHAR2_TABLE_100
23: , a9 out nocopy JTF_VARCHAR2_TABLE_100
24: );
22: , a8 out nocopy JTF_VARCHAR2_TABLE_100
23: , a9 out nocopy JTF_VARCHAR2_TABLE_100
24: );
25:
26: procedure rosetta_table_copy_in_p3(t out nocopy lns_financials.amortization_tbl, a0 JTF_NUMBER_TABLE
27: , a1 JTF_DATE_TABLE
28: , a2 JTF_DATE_TABLE
29: , a3 JTF_DATE_TABLE
30: , a4 JTF_NUMBER_TABLE
26: procedure rosetta_table_copy_in_p3(t out nocopy lns_financials.amortization_tbl, a0 JTF_NUMBER_TABLE
27: , a1 JTF_DATE_TABLE
28: , a2 JTF_DATE_TABLE
29: , a3 JTF_DATE_TABLE
30: , a4 JTF_NUMBER_TABLE
31: , a5 JTF_NUMBER_TABLE
32: , a6 JTF_NUMBER_TABLE
33: , a7 JTF_NUMBER_TABLE
34: , a8 JTF_NUMBER_TABLE
27: , a1 JTF_DATE_TABLE
28: , a2 JTF_DATE_TABLE
29: , a3 JTF_DATE_TABLE
30: , a4 JTF_NUMBER_TABLE
31: , a5 JTF_NUMBER_TABLE
32: , a6 JTF_NUMBER_TABLE
33: , a7 JTF_NUMBER_TABLE
34: , a8 JTF_NUMBER_TABLE
35: , a9 JTF_NUMBER_TABLE
28: , a2 JTF_DATE_TABLE
29: , a3 JTF_DATE_TABLE
30: , a4 JTF_NUMBER_TABLE
31: , a5 JTF_NUMBER_TABLE
32: , a6 JTF_NUMBER_TABLE
33: , a7 JTF_NUMBER_TABLE
34: , a8 JTF_NUMBER_TABLE
35: , a9 JTF_NUMBER_TABLE
36: , a10 JTF_NUMBER_TABLE
29: , a3 JTF_DATE_TABLE
30: , a4 JTF_NUMBER_TABLE
31: , a5 JTF_NUMBER_TABLE
32: , a6 JTF_NUMBER_TABLE
33: , a7 JTF_NUMBER_TABLE
34: , a8 JTF_NUMBER_TABLE
35: , a9 JTF_NUMBER_TABLE
36: , a10 JTF_NUMBER_TABLE
37: , a11 JTF_NUMBER_TABLE
30: , a4 JTF_NUMBER_TABLE
31: , a5 JTF_NUMBER_TABLE
32: , a6 JTF_NUMBER_TABLE
33: , a7 JTF_NUMBER_TABLE
34: , a8 JTF_NUMBER_TABLE
35: , a9 JTF_NUMBER_TABLE
36: , a10 JTF_NUMBER_TABLE
37: , a11 JTF_NUMBER_TABLE
38: , a12 JTF_NUMBER_TABLE
31: , a5 JTF_NUMBER_TABLE
32: , a6 JTF_NUMBER_TABLE
33: , a7 JTF_NUMBER_TABLE
34: , a8 JTF_NUMBER_TABLE
35: , a9 JTF_NUMBER_TABLE
36: , a10 JTF_NUMBER_TABLE
37: , a11 JTF_NUMBER_TABLE
38: , a12 JTF_NUMBER_TABLE
39: , a13 JTF_NUMBER_TABLE
32: , a6 JTF_NUMBER_TABLE
33: , a7 JTF_NUMBER_TABLE
34: , a8 JTF_NUMBER_TABLE
35: , a9 JTF_NUMBER_TABLE
36: , a10 JTF_NUMBER_TABLE
37: , a11 JTF_NUMBER_TABLE
38: , a12 JTF_NUMBER_TABLE
39: , a13 JTF_NUMBER_TABLE
40: , a14 JTF_NUMBER_TABLE
33: , a7 JTF_NUMBER_TABLE
34: , a8 JTF_NUMBER_TABLE
35: , a9 JTF_NUMBER_TABLE
36: , a10 JTF_NUMBER_TABLE
37: , a11 JTF_NUMBER_TABLE
38: , a12 JTF_NUMBER_TABLE
39: , a13 JTF_NUMBER_TABLE
40: , a14 JTF_NUMBER_TABLE
41: , a15 JTF_NUMBER_TABLE
34: , a8 JTF_NUMBER_TABLE
35: , a9 JTF_NUMBER_TABLE
36: , a10 JTF_NUMBER_TABLE
37: , a11 JTF_NUMBER_TABLE
38: , a12 JTF_NUMBER_TABLE
39: , a13 JTF_NUMBER_TABLE
40: , a14 JTF_NUMBER_TABLE
41: , a15 JTF_NUMBER_TABLE
42: , a16 JTF_NUMBER_TABLE
35: , a9 JTF_NUMBER_TABLE
36: , a10 JTF_NUMBER_TABLE
37: , a11 JTF_NUMBER_TABLE
38: , a12 JTF_NUMBER_TABLE
39: , a13 JTF_NUMBER_TABLE
40: , a14 JTF_NUMBER_TABLE
41: , a15 JTF_NUMBER_TABLE
42: , a16 JTF_NUMBER_TABLE
43: , a17 JTF_NUMBER_TABLE
36: , a10 JTF_NUMBER_TABLE
37: , a11 JTF_NUMBER_TABLE
38: , a12 JTF_NUMBER_TABLE
39: , a13 JTF_NUMBER_TABLE
40: , a14 JTF_NUMBER_TABLE
41: , a15 JTF_NUMBER_TABLE
42: , a16 JTF_NUMBER_TABLE
43: , a17 JTF_NUMBER_TABLE
44: , a18 JTF_NUMBER_TABLE
37: , a11 JTF_NUMBER_TABLE
38: , a12 JTF_NUMBER_TABLE
39: , a13 JTF_NUMBER_TABLE
40: , a14 JTF_NUMBER_TABLE
41: , a15 JTF_NUMBER_TABLE
42: , a16 JTF_NUMBER_TABLE
43: , a17 JTF_NUMBER_TABLE
44: , a18 JTF_NUMBER_TABLE
45: , a19 JTF_NUMBER_TABLE
38: , a12 JTF_NUMBER_TABLE
39: , a13 JTF_NUMBER_TABLE
40: , a14 JTF_NUMBER_TABLE
41: , a15 JTF_NUMBER_TABLE
42: , a16 JTF_NUMBER_TABLE
43: , a17 JTF_NUMBER_TABLE
44: , a18 JTF_NUMBER_TABLE
45: , a19 JTF_NUMBER_TABLE
46: , a20 JTF_NUMBER_TABLE
39: , a13 JTF_NUMBER_TABLE
40: , a14 JTF_NUMBER_TABLE
41: , a15 JTF_NUMBER_TABLE
42: , a16 JTF_NUMBER_TABLE
43: , a17 JTF_NUMBER_TABLE
44: , a18 JTF_NUMBER_TABLE
45: , a19 JTF_NUMBER_TABLE
46: , a20 JTF_NUMBER_TABLE
47: , a21 JTF_VARCHAR2_TABLE_100
40: , a14 JTF_NUMBER_TABLE
41: , a15 JTF_NUMBER_TABLE
42: , a16 JTF_NUMBER_TABLE
43: , a17 JTF_NUMBER_TABLE
44: , a18 JTF_NUMBER_TABLE
45: , a19 JTF_NUMBER_TABLE
46: , a20 JTF_NUMBER_TABLE
47: , a21 JTF_VARCHAR2_TABLE_100
48: , a22 JTF_VARCHAR2_TABLE_100
41: , a15 JTF_NUMBER_TABLE
42: , a16 JTF_NUMBER_TABLE
43: , a17 JTF_NUMBER_TABLE
44: , a18 JTF_NUMBER_TABLE
45: , a19 JTF_NUMBER_TABLE
46: , a20 JTF_NUMBER_TABLE
47: , a21 JTF_VARCHAR2_TABLE_100
48: , a22 JTF_VARCHAR2_TABLE_100
49: , a23 JTF_VARCHAR2_TABLE_100
42: , a16 JTF_NUMBER_TABLE
43: , a17 JTF_NUMBER_TABLE
44: , a18 JTF_NUMBER_TABLE
45: , a19 JTF_NUMBER_TABLE
46: , a20 JTF_NUMBER_TABLE
47: , a21 JTF_VARCHAR2_TABLE_100
48: , a22 JTF_VARCHAR2_TABLE_100
49: , a23 JTF_VARCHAR2_TABLE_100
50: , a24 JTF_NUMBER_TABLE
46: , a20 JTF_NUMBER_TABLE
47: , a21 JTF_VARCHAR2_TABLE_100
48: , a22 JTF_VARCHAR2_TABLE_100
49: , a23 JTF_VARCHAR2_TABLE_100
50: , a24 JTF_NUMBER_TABLE
51: , a25 JTF_NUMBER_TABLE
52: , a26 JTF_NUMBER_TABLE
53: , a27 JTF_NUMBER_TABLE
54: , a28 JTF_VARCHAR2_TABLE_2000
47: , a21 JTF_VARCHAR2_TABLE_100
48: , a22 JTF_VARCHAR2_TABLE_100
49: , a23 JTF_VARCHAR2_TABLE_100
50: , a24 JTF_NUMBER_TABLE
51: , a25 JTF_NUMBER_TABLE
52: , a26 JTF_NUMBER_TABLE
53: , a27 JTF_NUMBER_TABLE
54: , a28 JTF_VARCHAR2_TABLE_2000
55: , a29 JTF_VARCHAR2_TABLE_2000
48: , a22 JTF_VARCHAR2_TABLE_100
49: , a23 JTF_VARCHAR2_TABLE_100
50: , a24 JTF_NUMBER_TABLE
51: , a25 JTF_NUMBER_TABLE
52: , a26 JTF_NUMBER_TABLE
53: , a27 JTF_NUMBER_TABLE
54: , a28 JTF_VARCHAR2_TABLE_2000
55: , a29 JTF_VARCHAR2_TABLE_2000
56: , a30 JTF_VARCHAR2_TABLE_2000
49: , a23 JTF_VARCHAR2_TABLE_100
50: , a24 JTF_NUMBER_TABLE
51: , a25 JTF_NUMBER_TABLE
52: , a26 JTF_NUMBER_TABLE
53: , a27 JTF_NUMBER_TABLE
54: , a28 JTF_VARCHAR2_TABLE_2000
55: , a29 JTF_VARCHAR2_TABLE_2000
56: , a30 JTF_VARCHAR2_TABLE_2000
57: , a31 JTF_VARCHAR2_TABLE_2000
54: , a28 JTF_VARCHAR2_TABLE_2000
55: , a29 JTF_VARCHAR2_TABLE_2000
56: , a30 JTF_VARCHAR2_TABLE_2000
57: , a31 JTF_VARCHAR2_TABLE_2000
58: , a32 JTF_NUMBER_TABLE
59: , a33 JTF_VARCHAR2_TABLE_200
60: , a34 JTF_NUMBER_TABLE
61: , a35 JTF_NUMBER_TABLE
62: , a36 JTF_VARCHAR2_TABLE_2000
56: , a30 JTF_VARCHAR2_TABLE_2000
57: , a31 JTF_VARCHAR2_TABLE_2000
58: , a32 JTF_NUMBER_TABLE
59: , a33 JTF_VARCHAR2_TABLE_200
60: , a34 JTF_NUMBER_TABLE
61: , a35 JTF_NUMBER_TABLE
62: , a36 JTF_VARCHAR2_TABLE_2000
63: , a37 JTF_NUMBER_TABLE
64: , a38 JTF_NUMBER_TABLE
57: , a31 JTF_VARCHAR2_TABLE_2000
58: , a32 JTF_NUMBER_TABLE
59: , a33 JTF_VARCHAR2_TABLE_200
60: , a34 JTF_NUMBER_TABLE
61: , a35 JTF_NUMBER_TABLE
62: , a36 JTF_VARCHAR2_TABLE_2000
63: , a37 JTF_NUMBER_TABLE
64: , a38 JTF_NUMBER_TABLE
65: , a39 JTF_NUMBER_TABLE
59: , a33 JTF_VARCHAR2_TABLE_200
60: , a34 JTF_NUMBER_TABLE
61: , a35 JTF_NUMBER_TABLE
62: , a36 JTF_VARCHAR2_TABLE_2000
63: , a37 JTF_NUMBER_TABLE
64: , a38 JTF_NUMBER_TABLE
65: , a39 JTF_NUMBER_TABLE
66: , a40 JTF_VARCHAR2_TABLE_2000
67: , a41 JTF_NUMBER_TABLE
60: , a34 JTF_NUMBER_TABLE
61: , a35 JTF_NUMBER_TABLE
62: , a36 JTF_VARCHAR2_TABLE_2000
63: , a37 JTF_NUMBER_TABLE
64: , a38 JTF_NUMBER_TABLE
65: , a39 JTF_NUMBER_TABLE
66: , a40 JTF_VARCHAR2_TABLE_2000
67: , a41 JTF_NUMBER_TABLE
68: , a42 JTF_VARCHAR2_TABLE_2000
61: , a35 JTF_NUMBER_TABLE
62: , a36 JTF_VARCHAR2_TABLE_2000
63: , a37 JTF_NUMBER_TABLE
64: , a38 JTF_NUMBER_TABLE
65: , a39 JTF_NUMBER_TABLE
66: , a40 JTF_VARCHAR2_TABLE_2000
67: , a41 JTF_NUMBER_TABLE
68: , a42 JTF_VARCHAR2_TABLE_2000
69: );
63: , a37 JTF_NUMBER_TABLE
64: , a38 JTF_NUMBER_TABLE
65: , a39 JTF_NUMBER_TABLE
66: , a40 JTF_VARCHAR2_TABLE_2000
67: , a41 JTF_NUMBER_TABLE
68: , a42 JTF_VARCHAR2_TABLE_2000
69: );
70: procedure rosetta_table_copy_out_p3(t lns_financials.amortization_tbl, a0 out nocopy JTF_NUMBER_TABLE
71: , a1 out nocopy JTF_DATE_TABLE
66: , a40 JTF_VARCHAR2_TABLE_2000
67: , a41 JTF_NUMBER_TABLE
68: , a42 JTF_VARCHAR2_TABLE_2000
69: );
70: procedure rosetta_table_copy_out_p3(t lns_financials.amortization_tbl, a0 out nocopy JTF_NUMBER_TABLE
71: , a1 out nocopy JTF_DATE_TABLE
72: , a2 out nocopy JTF_DATE_TABLE
73: , a3 out nocopy JTF_DATE_TABLE
74: , a4 out nocopy JTF_NUMBER_TABLE
70: procedure rosetta_table_copy_out_p3(t lns_financials.amortization_tbl, a0 out nocopy JTF_NUMBER_TABLE
71: , a1 out nocopy JTF_DATE_TABLE
72: , a2 out nocopy JTF_DATE_TABLE
73: , a3 out nocopy JTF_DATE_TABLE
74: , a4 out nocopy JTF_NUMBER_TABLE
75: , a5 out nocopy JTF_NUMBER_TABLE
76: , a6 out nocopy JTF_NUMBER_TABLE
77: , a7 out nocopy JTF_NUMBER_TABLE
78: , a8 out nocopy JTF_NUMBER_TABLE
71: , a1 out nocopy JTF_DATE_TABLE
72: , a2 out nocopy JTF_DATE_TABLE
73: , a3 out nocopy JTF_DATE_TABLE
74: , a4 out nocopy JTF_NUMBER_TABLE
75: , a5 out nocopy JTF_NUMBER_TABLE
76: , a6 out nocopy JTF_NUMBER_TABLE
77: , a7 out nocopy JTF_NUMBER_TABLE
78: , a8 out nocopy JTF_NUMBER_TABLE
79: , a9 out nocopy JTF_NUMBER_TABLE
72: , a2 out nocopy JTF_DATE_TABLE
73: , a3 out nocopy JTF_DATE_TABLE
74: , a4 out nocopy JTF_NUMBER_TABLE
75: , a5 out nocopy JTF_NUMBER_TABLE
76: , a6 out nocopy JTF_NUMBER_TABLE
77: , a7 out nocopy JTF_NUMBER_TABLE
78: , a8 out nocopy JTF_NUMBER_TABLE
79: , a9 out nocopy JTF_NUMBER_TABLE
80: , a10 out nocopy JTF_NUMBER_TABLE
73: , a3 out nocopy JTF_DATE_TABLE
74: , a4 out nocopy JTF_NUMBER_TABLE
75: , a5 out nocopy JTF_NUMBER_TABLE
76: , a6 out nocopy JTF_NUMBER_TABLE
77: , a7 out nocopy JTF_NUMBER_TABLE
78: , a8 out nocopy JTF_NUMBER_TABLE
79: , a9 out nocopy JTF_NUMBER_TABLE
80: , a10 out nocopy JTF_NUMBER_TABLE
81: , a11 out nocopy JTF_NUMBER_TABLE
74: , a4 out nocopy JTF_NUMBER_TABLE
75: , a5 out nocopy JTF_NUMBER_TABLE
76: , a6 out nocopy JTF_NUMBER_TABLE
77: , a7 out nocopy JTF_NUMBER_TABLE
78: , a8 out nocopy JTF_NUMBER_TABLE
79: , a9 out nocopy JTF_NUMBER_TABLE
80: , a10 out nocopy JTF_NUMBER_TABLE
81: , a11 out nocopy JTF_NUMBER_TABLE
82: , a12 out nocopy JTF_NUMBER_TABLE
75: , a5 out nocopy JTF_NUMBER_TABLE
76: , a6 out nocopy JTF_NUMBER_TABLE
77: , a7 out nocopy JTF_NUMBER_TABLE
78: , a8 out nocopy JTF_NUMBER_TABLE
79: , a9 out nocopy JTF_NUMBER_TABLE
80: , a10 out nocopy JTF_NUMBER_TABLE
81: , a11 out nocopy JTF_NUMBER_TABLE
82: , a12 out nocopy JTF_NUMBER_TABLE
83: , a13 out nocopy JTF_NUMBER_TABLE
76: , a6 out nocopy JTF_NUMBER_TABLE
77: , a7 out nocopy JTF_NUMBER_TABLE
78: , a8 out nocopy JTF_NUMBER_TABLE
79: , a9 out nocopy JTF_NUMBER_TABLE
80: , a10 out nocopy JTF_NUMBER_TABLE
81: , a11 out nocopy JTF_NUMBER_TABLE
82: , a12 out nocopy JTF_NUMBER_TABLE
83: , a13 out nocopy JTF_NUMBER_TABLE
84: , a14 out nocopy JTF_NUMBER_TABLE
77: , a7 out nocopy JTF_NUMBER_TABLE
78: , a8 out nocopy JTF_NUMBER_TABLE
79: , a9 out nocopy JTF_NUMBER_TABLE
80: , a10 out nocopy JTF_NUMBER_TABLE
81: , a11 out nocopy JTF_NUMBER_TABLE
82: , a12 out nocopy JTF_NUMBER_TABLE
83: , a13 out nocopy JTF_NUMBER_TABLE
84: , a14 out nocopy JTF_NUMBER_TABLE
85: , a15 out nocopy JTF_NUMBER_TABLE
78: , a8 out nocopy JTF_NUMBER_TABLE
79: , a9 out nocopy JTF_NUMBER_TABLE
80: , a10 out nocopy JTF_NUMBER_TABLE
81: , a11 out nocopy JTF_NUMBER_TABLE
82: , a12 out nocopy JTF_NUMBER_TABLE
83: , a13 out nocopy JTF_NUMBER_TABLE
84: , a14 out nocopy JTF_NUMBER_TABLE
85: , a15 out nocopy JTF_NUMBER_TABLE
86: , a16 out nocopy JTF_NUMBER_TABLE
79: , a9 out nocopy JTF_NUMBER_TABLE
80: , a10 out nocopy JTF_NUMBER_TABLE
81: , a11 out nocopy JTF_NUMBER_TABLE
82: , a12 out nocopy JTF_NUMBER_TABLE
83: , a13 out nocopy JTF_NUMBER_TABLE
84: , a14 out nocopy JTF_NUMBER_TABLE
85: , a15 out nocopy JTF_NUMBER_TABLE
86: , a16 out nocopy JTF_NUMBER_TABLE
87: , a17 out nocopy JTF_NUMBER_TABLE
80: , a10 out nocopy JTF_NUMBER_TABLE
81: , a11 out nocopy JTF_NUMBER_TABLE
82: , a12 out nocopy JTF_NUMBER_TABLE
83: , a13 out nocopy JTF_NUMBER_TABLE
84: , a14 out nocopy JTF_NUMBER_TABLE
85: , a15 out nocopy JTF_NUMBER_TABLE
86: , a16 out nocopy JTF_NUMBER_TABLE
87: , a17 out nocopy JTF_NUMBER_TABLE
88: , a18 out nocopy JTF_NUMBER_TABLE
81: , a11 out nocopy JTF_NUMBER_TABLE
82: , a12 out nocopy JTF_NUMBER_TABLE
83: , a13 out nocopy JTF_NUMBER_TABLE
84: , a14 out nocopy JTF_NUMBER_TABLE
85: , a15 out nocopy JTF_NUMBER_TABLE
86: , a16 out nocopy JTF_NUMBER_TABLE
87: , a17 out nocopy JTF_NUMBER_TABLE
88: , a18 out nocopy JTF_NUMBER_TABLE
89: , a19 out nocopy JTF_NUMBER_TABLE
82: , a12 out nocopy JTF_NUMBER_TABLE
83: , a13 out nocopy JTF_NUMBER_TABLE
84: , a14 out nocopy JTF_NUMBER_TABLE
85: , a15 out nocopy JTF_NUMBER_TABLE
86: , a16 out nocopy JTF_NUMBER_TABLE
87: , a17 out nocopy JTF_NUMBER_TABLE
88: , a18 out nocopy JTF_NUMBER_TABLE
89: , a19 out nocopy JTF_NUMBER_TABLE
90: , a20 out nocopy JTF_NUMBER_TABLE
83: , a13 out nocopy JTF_NUMBER_TABLE
84: , a14 out nocopy JTF_NUMBER_TABLE
85: , a15 out nocopy JTF_NUMBER_TABLE
86: , a16 out nocopy JTF_NUMBER_TABLE
87: , a17 out nocopy JTF_NUMBER_TABLE
88: , a18 out nocopy JTF_NUMBER_TABLE
89: , a19 out nocopy JTF_NUMBER_TABLE
90: , a20 out nocopy JTF_NUMBER_TABLE
91: , a21 out nocopy JTF_VARCHAR2_TABLE_100
84: , a14 out nocopy JTF_NUMBER_TABLE
85: , a15 out nocopy JTF_NUMBER_TABLE
86: , a16 out nocopy JTF_NUMBER_TABLE
87: , a17 out nocopy JTF_NUMBER_TABLE
88: , a18 out nocopy JTF_NUMBER_TABLE
89: , a19 out nocopy JTF_NUMBER_TABLE
90: , a20 out nocopy JTF_NUMBER_TABLE
91: , a21 out nocopy JTF_VARCHAR2_TABLE_100
92: , a22 out nocopy JTF_VARCHAR2_TABLE_100
85: , a15 out nocopy JTF_NUMBER_TABLE
86: , a16 out nocopy JTF_NUMBER_TABLE
87: , a17 out nocopy JTF_NUMBER_TABLE
88: , a18 out nocopy JTF_NUMBER_TABLE
89: , a19 out nocopy JTF_NUMBER_TABLE
90: , a20 out nocopy JTF_NUMBER_TABLE
91: , a21 out nocopy JTF_VARCHAR2_TABLE_100
92: , a22 out nocopy JTF_VARCHAR2_TABLE_100
93: , a23 out nocopy JTF_VARCHAR2_TABLE_100
86: , a16 out nocopy JTF_NUMBER_TABLE
87: , a17 out nocopy JTF_NUMBER_TABLE
88: , a18 out nocopy JTF_NUMBER_TABLE
89: , a19 out nocopy JTF_NUMBER_TABLE
90: , a20 out nocopy JTF_NUMBER_TABLE
91: , a21 out nocopy JTF_VARCHAR2_TABLE_100
92: , a22 out nocopy JTF_VARCHAR2_TABLE_100
93: , a23 out nocopy JTF_VARCHAR2_TABLE_100
94: , a24 out nocopy JTF_NUMBER_TABLE
90: , a20 out nocopy JTF_NUMBER_TABLE
91: , a21 out nocopy JTF_VARCHAR2_TABLE_100
92: , a22 out nocopy JTF_VARCHAR2_TABLE_100
93: , a23 out nocopy JTF_VARCHAR2_TABLE_100
94: , a24 out nocopy JTF_NUMBER_TABLE
95: , a25 out nocopy JTF_NUMBER_TABLE
96: , a26 out nocopy JTF_NUMBER_TABLE
97: , a27 out nocopy JTF_NUMBER_TABLE
98: , a28 out nocopy JTF_VARCHAR2_TABLE_2000
91: , a21 out nocopy JTF_VARCHAR2_TABLE_100
92: , a22 out nocopy JTF_VARCHAR2_TABLE_100
93: , a23 out nocopy JTF_VARCHAR2_TABLE_100
94: , a24 out nocopy JTF_NUMBER_TABLE
95: , a25 out nocopy JTF_NUMBER_TABLE
96: , a26 out nocopy JTF_NUMBER_TABLE
97: , a27 out nocopy JTF_NUMBER_TABLE
98: , a28 out nocopy JTF_VARCHAR2_TABLE_2000
99: , a29 out nocopy JTF_VARCHAR2_TABLE_2000
92: , a22 out nocopy JTF_VARCHAR2_TABLE_100
93: , a23 out nocopy JTF_VARCHAR2_TABLE_100
94: , a24 out nocopy JTF_NUMBER_TABLE
95: , a25 out nocopy JTF_NUMBER_TABLE
96: , a26 out nocopy JTF_NUMBER_TABLE
97: , a27 out nocopy JTF_NUMBER_TABLE
98: , a28 out nocopy JTF_VARCHAR2_TABLE_2000
99: , a29 out nocopy JTF_VARCHAR2_TABLE_2000
100: , a30 out nocopy JTF_VARCHAR2_TABLE_2000
93: , a23 out nocopy JTF_VARCHAR2_TABLE_100
94: , a24 out nocopy JTF_NUMBER_TABLE
95: , a25 out nocopy JTF_NUMBER_TABLE
96: , a26 out nocopy JTF_NUMBER_TABLE
97: , a27 out nocopy JTF_NUMBER_TABLE
98: , a28 out nocopy JTF_VARCHAR2_TABLE_2000
99: , a29 out nocopy JTF_VARCHAR2_TABLE_2000
100: , a30 out nocopy JTF_VARCHAR2_TABLE_2000
101: , a31 out nocopy JTF_VARCHAR2_TABLE_2000
98: , a28 out nocopy JTF_VARCHAR2_TABLE_2000
99: , a29 out nocopy JTF_VARCHAR2_TABLE_2000
100: , a30 out nocopy JTF_VARCHAR2_TABLE_2000
101: , a31 out nocopy JTF_VARCHAR2_TABLE_2000
102: , a32 out nocopy JTF_NUMBER_TABLE
103: , a33 out nocopy JTF_VARCHAR2_TABLE_200
104: , a34 out nocopy JTF_NUMBER_TABLE
105: , a35 out nocopy JTF_NUMBER_TABLE
106: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
100: , a30 out nocopy JTF_VARCHAR2_TABLE_2000
101: , a31 out nocopy JTF_VARCHAR2_TABLE_2000
102: , a32 out nocopy JTF_NUMBER_TABLE
103: , a33 out nocopy JTF_VARCHAR2_TABLE_200
104: , a34 out nocopy JTF_NUMBER_TABLE
105: , a35 out nocopy JTF_NUMBER_TABLE
106: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
107: , a37 out nocopy JTF_NUMBER_TABLE
108: , a38 out nocopy JTF_NUMBER_TABLE
101: , a31 out nocopy JTF_VARCHAR2_TABLE_2000
102: , a32 out nocopy JTF_NUMBER_TABLE
103: , a33 out nocopy JTF_VARCHAR2_TABLE_200
104: , a34 out nocopy JTF_NUMBER_TABLE
105: , a35 out nocopy JTF_NUMBER_TABLE
106: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
107: , a37 out nocopy JTF_NUMBER_TABLE
108: , a38 out nocopy JTF_NUMBER_TABLE
109: , a39 out nocopy JTF_NUMBER_TABLE
103: , a33 out nocopy JTF_VARCHAR2_TABLE_200
104: , a34 out nocopy JTF_NUMBER_TABLE
105: , a35 out nocopy JTF_NUMBER_TABLE
106: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
107: , a37 out nocopy JTF_NUMBER_TABLE
108: , a38 out nocopy JTF_NUMBER_TABLE
109: , a39 out nocopy JTF_NUMBER_TABLE
110: , a40 out nocopy JTF_VARCHAR2_TABLE_2000
111: , a41 out nocopy JTF_NUMBER_TABLE
104: , a34 out nocopy JTF_NUMBER_TABLE
105: , a35 out nocopy JTF_NUMBER_TABLE
106: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
107: , a37 out nocopy JTF_NUMBER_TABLE
108: , a38 out nocopy JTF_NUMBER_TABLE
109: , a39 out nocopy JTF_NUMBER_TABLE
110: , a40 out nocopy JTF_VARCHAR2_TABLE_2000
111: , a41 out nocopy JTF_NUMBER_TABLE
112: , a42 out nocopy JTF_VARCHAR2_TABLE_2000
105: , a35 out nocopy JTF_NUMBER_TABLE
106: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
107: , a37 out nocopy JTF_NUMBER_TABLE
108: , a38 out nocopy JTF_NUMBER_TABLE
109: , a39 out nocopy JTF_NUMBER_TABLE
110: , a40 out nocopy JTF_VARCHAR2_TABLE_2000
111: , a41 out nocopy JTF_NUMBER_TABLE
112: , a42 out nocopy JTF_VARCHAR2_TABLE_2000
113: );
107: , a37 out nocopy JTF_NUMBER_TABLE
108: , a38 out nocopy JTF_NUMBER_TABLE
109: , a39 out nocopy JTF_NUMBER_TABLE
110: , a40 out nocopy JTF_VARCHAR2_TABLE_2000
111: , a41 out nocopy JTF_NUMBER_TABLE
112: , a42 out nocopy JTF_VARCHAR2_TABLE_2000
113: );
114:
115: procedure rosetta_table_copy_in_p6(t out nocopy lns_financials.payoff_tbl, a0 JTF_NUMBER_TABLE
111: , a41 out nocopy JTF_NUMBER_TABLE
112: , a42 out nocopy JTF_VARCHAR2_TABLE_2000
113: );
114:
115: procedure rosetta_table_copy_in_p6(t out nocopy lns_financials.payoff_tbl, a0 JTF_NUMBER_TABLE
116: , a1 JTF_NUMBER_TABLE
117: , a2 JTF_NUMBER_TABLE
118: , a3 JTF_NUMBER_TABLE
119: , a4 JTF_NUMBER_TABLE
112: , a42 out nocopy JTF_VARCHAR2_TABLE_2000
113: );
114:
115: procedure rosetta_table_copy_in_p6(t out nocopy lns_financials.payoff_tbl, a0 JTF_NUMBER_TABLE
116: , a1 JTF_NUMBER_TABLE
117: , a2 JTF_NUMBER_TABLE
118: , a3 JTF_NUMBER_TABLE
119: , a4 JTF_NUMBER_TABLE
120: , a5 JTF_NUMBER_TABLE
113: );
114:
115: procedure rosetta_table_copy_in_p6(t out nocopy lns_financials.payoff_tbl, a0 JTF_NUMBER_TABLE
116: , a1 JTF_NUMBER_TABLE
117: , a2 JTF_NUMBER_TABLE
118: , a3 JTF_NUMBER_TABLE
119: , a4 JTF_NUMBER_TABLE
120: , a5 JTF_NUMBER_TABLE
121: , a6 JTF_NUMBER_TABLE
114:
115: procedure rosetta_table_copy_in_p6(t out nocopy lns_financials.payoff_tbl, a0 JTF_NUMBER_TABLE
116: , a1 JTF_NUMBER_TABLE
117: , a2 JTF_NUMBER_TABLE
118: , a3 JTF_NUMBER_TABLE
119: , a4 JTF_NUMBER_TABLE
120: , a5 JTF_NUMBER_TABLE
121: , a6 JTF_NUMBER_TABLE
122: , a7 JTF_NUMBER_TABLE
115: procedure rosetta_table_copy_in_p6(t out nocopy lns_financials.payoff_tbl, a0 JTF_NUMBER_TABLE
116: , a1 JTF_NUMBER_TABLE
117: , a2 JTF_NUMBER_TABLE
118: , a3 JTF_NUMBER_TABLE
119: , a4 JTF_NUMBER_TABLE
120: , a5 JTF_NUMBER_TABLE
121: , a6 JTF_NUMBER_TABLE
122: , a7 JTF_NUMBER_TABLE
123: , a8 JTF_NUMBER_TABLE
116: , a1 JTF_NUMBER_TABLE
117: , a2 JTF_NUMBER_TABLE
118: , a3 JTF_NUMBER_TABLE
119: , a4 JTF_NUMBER_TABLE
120: , a5 JTF_NUMBER_TABLE
121: , a6 JTF_NUMBER_TABLE
122: , a7 JTF_NUMBER_TABLE
123: , a8 JTF_NUMBER_TABLE
124: , a9 JTF_DATE_TABLE
117: , a2 JTF_NUMBER_TABLE
118: , a3 JTF_NUMBER_TABLE
119: , a4 JTF_NUMBER_TABLE
120: , a5 JTF_NUMBER_TABLE
121: , a6 JTF_NUMBER_TABLE
122: , a7 JTF_NUMBER_TABLE
123: , a8 JTF_NUMBER_TABLE
124: , a9 JTF_DATE_TABLE
125: );
118: , a3 JTF_NUMBER_TABLE
119: , a4 JTF_NUMBER_TABLE
120: , a5 JTF_NUMBER_TABLE
121: , a6 JTF_NUMBER_TABLE
122: , a7 JTF_NUMBER_TABLE
123: , a8 JTF_NUMBER_TABLE
124: , a9 JTF_DATE_TABLE
125: );
126: procedure rosetta_table_copy_out_p6(t lns_financials.payoff_tbl, a0 out nocopy JTF_NUMBER_TABLE
119: , a4 JTF_NUMBER_TABLE
120: , a5 JTF_NUMBER_TABLE
121: , a6 JTF_NUMBER_TABLE
122: , a7 JTF_NUMBER_TABLE
123: , a8 JTF_NUMBER_TABLE
124: , a9 JTF_DATE_TABLE
125: );
126: procedure rosetta_table_copy_out_p6(t lns_financials.payoff_tbl, a0 out nocopy JTF_NUMBER_TABLE
127: , a1 out nocopy JTF_NUMBER_TABLE
122: , a7 JTF_NUMBER_TABLE
123: , a8 JTF_NUMBER_TABLE
124: , a9 JTF_DATE_TABLE
125: );
126: procedure rosetta_table_copy_out_p6(t lns_financials.payoff_tbl, a0 out nocopy JTF_NUMBER_TABLE
127: , a1 out nocopy JTF_NUMBER_TABLE
128: , a2 out nocopy JTF_NUMBER_TABLE
129: , a3 out nocopy JTF_NUMBER_TABLE
130: , a4 out nocopy JTF_NUMBER_TABLE
123: , a8 JTF_NUMBER_TABLE
124: , a9 JTF_DATE_TABLE
125: );
126: procedure rosetta_table_copy_out_p6(t lns_financials.payoff_tbl, a0 out nocopy JTF_NUMBER_TABLE
127: , a1 out nocopy JTF_NUMBER_TABLE
128: , a2 out nocopy JTF_NUMBER_TABLE
129: , a3 out nocopy JTF_NUMBER_TABLE
130: , a4 out nocopy JTF_NUMBER_TABLE
131: , a5 out nocopy JTF_NUMBER_TABLE
124: , a9 JTF_DATE_TABLE
125: );
126: procedure rosetta_table_copy_out_p6(t lns_financials.payoff_tbl, a0 out nocopy JTF_NUMBER_TABLE
127: , a1 out nocopy JTF_NUMBER_TABLE
128: , a2 out nocopy JTF_NUMBER_TABLE
129: , a3 out nocopy JTF_NUMBER_TABLE
130: , a4 out nocopy JTF_NUMBER_TABLE
131: , a5 out nocopy JTF_NUMBER_TABLE
132: , a6 out nocopy JTF_NUMBER_TABLE
125: );
126: procedure rosetta_table_copy_out_p6(t lns_financials.payoff_tbl, a0 out nocopy JTF_NUMBER_TABLE
127: , a1 out nocopy JTF_NUMBER_TABLE
128: , a2 out nocopy JTF_NUMBER_TABLE
129: , a3 out nocopy JTF_NUMBER_TABLE
130: , a4 out nocopy JTF_NUMBER_TABLE
131: , a5 out nocopy JTF_NUMBER_TABLE
132: , a6 out nocopy JTF_NUMBER_TABLE
133: , a7 out nocopy JTF_NUMBER_TABLE
126: procedure rosetta_table_copy_out_p6(t lns_financials.payoff_tbl, a0 out nocopy JTF_NUMBER_TABLE
127: , a1 out nocopy JTF_NUMBER_TABLE
128: , a2 out nocopy JTF_NUMBER_TABLE
129: , a3 out nocopy JTF_NUMBER_TABLE
130: , a4 out nocopy JTF_NUMBER_TABLE
131: , a5 out nocopy JTF_NUMBER_TABLE
132: , a6 out nocopy JTF_NUMBER_TABLE
133: , a7 out nocopy JTF_NUMBER_TABLE
134: , a8 out nocopy JTF_NUMBER_TABLE
127: , a1 out nocopy JTF_NUMBER_TABLE
128: , a2 out nocopy JTF_NUMBER_TABLE
129: , a3 out nocopy JTF_NUMBER_TABLE
130: , a4 out nocopy JTF_NUMBER_TABLE
131: , a5 out nocopy JTF_NUMBER_TABLE
132: , a6 out nocopy JTF_NUMBER_TABLE
133: , a7 out nocopy JTF_NUMBER_TABLE
134: , a8 out nocopy JTF_NUMBER_TABLE
135: , a9 out nocopy JTF_DATE_TABLE
128: , a2 out nocopy JTF_NUMBER_TABLE
129: , a3 out nocopy JTF_NUMBER_TABLE
130: , a4 out nocopy JTF_NUMBER_TABLE
131: , a5 out nocopy JTF_NUMBER_TABLE
132: , a6 out nocopy JTF_NUMBER_TABLE
133: , a7 out nocopy JTF_NUMBER_TABLE
134: , a8 out nocopy JTF_NUMBER_TABLE
135: , a9 out nocopy JTF_DATE_TABLE
136: );
129: , a3 out nocopy JTF_NUMBER_TABLE
130: , a4 out nocopy JTF_NUMBER_TABLE
131: , a5 out nocopy JTF_NUMBER_TABLE
132: , a6 out nocopy JTF_NUMBER_TABLE
133: , a7 out nocopy JTF_NUMBER_TABLE
134: , a8 out nocopy JTF_NUMBER_TABLE
135: , a9 out nocopy JTF_DATE_TABLE
136: );
137:
130: , a4 out nocopy JTF_NUMBER_TABLE
131: , a5 out nocopy JTF_NUMBER_TABLE
132: , a6 out nocopy JTF_NUMBER_TABLE
133: , a7 out nocopy JTF_NUMBER_TABLE
134: , a8 out nocopy JTF_NUMBER_TABLE
135: , a9 out nocopy JTF_DATE_TABLE
136: );
137:
138: procedure rosetta_table_copy_in_p8(t out nocopy lns_financials.payoff_tbl2, a0 JTF_VARCHAR2_TABLE_100
135: , a9 out nocopy JTF_DATE_TABLE
136: );
137:
138: procedure rosetta_table_copy_in_p8(t out nocopy lns_financials.payoff_tbl2, a0 JTF_VARCHAR2_TABLE_100
139: , a1 JTF_NUMBER_TABLE
140: , a2 JTF_NUMBER_TABLE
141: , a3 JTF_NUMBER_TABLE
142: );
143: procedure rosetta_table_copy_out_p8(t lns_financials.payoff_tbl2, a0 out nocopy JTF_VARCHAR2_TABLE_100
136: );
137:
138: procedure rosetta_table_copy_in_p8(t out nocopy lns_financials.payoff_tbl2, a0 JTF_VARCHAR2_TABLE_100
139: , a1 JTF_NUMBER_TABLE
140: , a2 JTF_NUMBER_TABLE
141: , a3 JTF_NUMBER_TABLE
142: );
143: procedure rosetta_table_copy_out_p8(t lns_financials.payoff_tbl2, a0 out nocopy JTF_VARCHAR2_TABLE_100
144: , a1 out nocopy JTF_NUMBER_TABLE
137:
138: procedure rosetta_table_copy_in_p8(t out nocopy lns_financials.payoff_tbl2, a0 JTF_VARCHAR2_TABLE_100
139: , a1 JTF_NUMBER_TABLE
140: , a2 JTF_NUMBER_TABLE
141: , a3 JTF_NUMBER_TABLE
142: );
143: procedure rosetta_table_copy_out_p8(t lns_financials.payoff_tbl2, a0 out nocopy JTF_VARCHAR2_TABLE_100
144: , a1 out nocopy JTF_NUMBER_TABLE
145: , a2 out nocopy JTF_NUMBER_TABLE
140: , a2 JTF_NUMBER_TABLE
141: , a3 JTF_NUMBER_TABLE
142: );
143: procedure rosetta_table_copy_out_p8(t lns_financials.payoff_tbl2, a0 out nocopy JTF_VARCHAR2_TABLE_100
144: , a1 out nocopy JTF_NUMBER_TABLE
145: , a2 out nocopy JTF_NUMBER_TABLE
146: , a3 out nocopy JTF_NUMBER_TABLE
147: );
148:
141: , a3 JTF_NUMBER_TABLE
142: );
143: procedure rosetta_table_copy_out_p8(t lns_financials.payoff_tbl2, a0 out nocopy JTF_VARCHAR2_TABLE_100
144: , a1 out nocopy JTF_NUMBER_TABLE
145: , a2 out nocopy JTF_NUMBER_TABLE
146: , a3 out nocopy JTF_NUMBER_TABLE
147: );
148:
149: procedure rosetta_table_copy_in_p10(t out nocopy lns_financials.loan_activity_tbl, a0 JTF_DATE_TABLE
142: );
143: procedure rosetta_table_copy_out_p8(t lns_financials.payoff_tbl2, a0 out nocopy JTF_VARCHAR2_TABLE_100
144: , a1 out nocopy JTF_NUMBER_TABLE
145: , a2 out nocopy JTF_NUMBER_TABLE
146: , a3 out nocopy JTF_NUMBER_TABLE
147: );
148:
149: procedure rosetta_table_copy_in_p10(t out nocopy lns_financials.loan_activity_tbl, a0 JTF_DATE_TABLE
150: , a1 JTF_NUMBER_TABLE
146: , a3 out nocopy JTF_NUMBER_TABLE
147: );
148:
149: procedure rosetta_table_copy_in_p10(t out nocopy lns_financials.loan_activity_tbl, a0 JTF_DATE_TABLE
150: , a1 JTF_NUMBER_TABLE
151: , a2 JTF_NUMBER_TABLE
152: , a3 JTF_NUMBER_TABLE
153: );
154: procedure rosetta_table_copy_out_p10(t lns_financials.loan_activity_tbl, a0 out nocopy JTF_DATE_TABLE
147: );
148:
149: procedure rosetta_table_copy_in_p10(t out nocopy lns_financials.loan_activity_tbl, a0 JTF_DATE_TABLE
150: , a1 JTF_NUMBER_TABLE
151: , a2 JTF_NUMBER_TABLE
152: , a3 JTF_NUMBER_TABLE
153: );
154: procedure rosetta_table_copy_out_p10(t lns_financials.loan_activity_tbl, a0 out nocopy JTF_DATE_TABLE
155: , a1 out nocopy JTF_NUMBER_TABLE
148:
149: procedure rosetta_table_copy_in_p10(t out nocopy lns_financials.loan_activity_tbl, a0 JTF_DATE_TABLE
150: , a1 JTF_NUMBER_TABLE
151: , a2 JTF_NUMBER_TABLE
152: , a3 JTF_NUMBER_TABLE
153: );
154: procedure rosetta_table_copy_out_p10(t lns_financials.loan_activity_tbl, a0 out nocopy JTF_DATE_TABLE
155: , a1 out nocopy JTF_NUMBER_TABLE
156: , a2 out nocopy JTF_NUMBER_TABLE
151: , a2 JTF_NUMBER_TABLE
152: , a3 JTF_NUMBER_TABLE
153: );
154: procedure rosetta_table_copy_out_p10(t lns_financials.loan_activity_tbl, a0 out nocopy JTF_DATE_TABLE
155: , a1 out nocopy JTF_NUMBER_TABLE
156: , a2 out nocopy JTF_NUMBER_TABLE
157: , a3 out nocopy JTF_NUMBER_TABLE
158: );
159:
152: , a3 JTF_NUMBER_TABLE
153: );
154: procedure rosetta_table_copy_out_p10(t lns_financials.loan_activity_tbl, a0 out nocopy JTF_DATE_TABLE
155: , a1 out nocopy JTF_NUMBER_TABLE
156: , a2 out nocopy JTF_NUMBER_TABLE
157: , a3 out nocopy JTF_NUMBER_TABLE
158: );
159:
160: procedure rosetta_table_copy_in_p12(t out nocopy lns_financials.payment_schedule_tbl, a0 JTF_DATE_TABLE
153: );
154: procedure rosetta_table_copy_out_p10(t lns_financials.loan_activity_tbl, a0 out nocopy JTF_DATE_TABLE
155: , a1 out nocopy JTF_NUMBER_TABLE
156: , a2 out nocopy JTF_NUMBER_TABLE
157: , a3 out nocopy JTF_NUMBER_TABLE
158: );
159:
160: procedure rosetta_table_copy_in_p12(t out nocopy lns_financials.payment_schedule_tbl, a0 JTF_DATE_TABLE
161: , a1 JTF_DATE_TABLE
166:
167: procedure rosetta_table_copy_in_p13(t out nocopy lns_financials.date_tbl, a0 JTF_DATE_TABLE);
168: procedure rosetta_table_copy_out_p13(t lns_financials.date_tbl, a0 out nocopy JTF_DATE_TABLE);
169:
170: procedure rosetta_table_copy_in_p14(t out nocopy lns_financials.amount_tbl, a0 JTF_NUMBER_TABLE);
171: procedure rosetta_table_copy_out_p14(t lns_financials.amount_tbl, a0 out nocopy JTF_NUMBER_TABLE);
172:
173: procedure rosetta_table_copy_in_p15(t out nocopy lns_financials.vchar_tbl, a0 JTF_VARCHAR2_TABLE_100);
174: procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);
167: procedure rosetta_table_copy_in_p13(t out nocopy lns_financials.date_tbl, a0 JTF_DATE_TABLE);
168: procedure rosetta_table_copy_out_p13(t lns_financials.date_tbl, a0 out nocopy JTF_DATE_TABLE);
169:
170: procedure rosetta_table_copy_in_p14(t out nocopy lns_financials.amount_tbl, a0 JTF_NUMBER_TABLE);
171: procedure rosetta_table_copy_out_p14(t lns_financials.amount_tbl, a0 out nocopy JTF_NUMBER_TABLE);
172:
173: procedure rosetta_table_copy_in_p15(t out nocopy lns_financials.vchar_tbl, a0 JTF_VARCHAR2_TABLE_100);
174: procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);
175:
172:
173: procedure rosetta_table_copy_in_p15(t out nocopy lns_financials.vchar_tbl, a0 JTF_VARCHAR2_TABLE_100);
174: procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);
175:
176: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
177: , a1 JTF_VARCHAR2_TABLE_100
178: , a2 JTF_NUMBER_TABLE
179: , a3 JTF_NUMBER_TABLE
180: , a4 JTF_VARCHAR2_TABLE_300
174: procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);
175:
176: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
177: , a1 JTF_VARCHAR2_TABLE_100
178: , a2 JTF_NUMBER_TABLE
179: , a3 JTF_NUMBER_TABLE
180: , a4 JTF_VARCHAR2_TABLE_300
181: , a5 JTF_NUMBER_TABLE
182: , a6 JTF_VARCHAR2_TABLE_100
175:
176: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
177: , a1 JTF_VARCHAR2_TABLE_100
178: , a2 JTF_NUMBER_TABLE
179: , a3 JTF_NUMBER_TABLE
180: , a4 JTF_VARCHAR2_TABLE_300
181: , a5 JTF_NUMBER_TABLE
182: , a6 JTF_VARCHAR2_TABLE_100
183: , a7 JTF_NUMBER_TABLE
177: , a1 JTF_VARCHAR2_TABLE_100
178: , a2 JTF_NUMBER_TABLE
179: , a3 JTF_NUMBER_TABLE
180: , a4 JTF_VARCHAR2_TABLE_300
181: , a5 JTF_NUMBER_TABLE
182: , a6 JTF_VARCHAR2_TABLE_100
183: , a7 JTF_NUMBER_TABLE
184: , a8 JTF_VARCHAR2_TABLE_100
185: , a9 JTF_VARCHAR2_TABLE_100
179: , a3 JTF_NUMBER_TABLE
180: , a4 JTF_VARCHAR2_TABLE_300
181: , a5 JTF_NUMBER_TABLE
182: , a6 JTF_VARCHAR2_TABLE_100
183: , a7 JTF_NUMBER_TABLE
184: , a8 JTF_VARCHAR2_TABLE_100
185: , a9 JTF_VARCHAR2_TABLE_100
186: );
187: procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE
183: , a7 JTF_NUMBER_TABLE
184: , a8 JTF_VARCHAR2_TABLE_100
185: , a9 JTF_VARCHAR2_TABLE_100
186: );
187: procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE
188: , a1 out nocopy JTF_VARCHAR2_TABLE_100
189: , a2 out nocopy JTF_NUMBER_TABLE
190: , a3 out nocopy JTF_NUMBER_TABLE
191: , a4 out nocopy JTF_VARCHAR2_TABLE_300
185: , a9 JTF_VARCHAR2_TABLE_100
186: );
187: procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE
188: , a1 out nocopy JTF_VARCHAR2_TABLE_100
189: , a2 out nocopy JTF_NUMBER_TABLE
190: , a3 out nocopy JTF_NUMBER_TABLE
191: , a4 out nocopy JTF_VARCHAR2_TABLE_300
192: , a5 out nocopy JTF_NUMBER_TABLE
193: , a6 out nocopy JTF_VARCHAR2_TABLE_100
186: );
187: procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE
188: , a1 out nocopy JTF_VARCHAR2_TABLE_100
189: , a2 out nocopy JTF_NUMBER_TABLE
190: , a3 out nocopy JTF_NUMBER_TABLE
191: , a4 out nocopy JTF_VARCHAR2_TABLE_300
192: , a5 out nocopy JTF_NUMBER_TABLE
193: , a6 out nocopy JTF_VARCHAR2_TABLE_100
194: , a7 out nocopy JTF_NUMBER_TABLE
188: , a1 out nocopy JTF_VARCHAR2_TABLE_100
189: , a2 out nocopy JTF_NUMBER_TABLE
190: , a3 out nocopy JTF_NUMBER_TABLE
191: , a4 out nocopy JTF_VARCHAR2_TABLE_300
192: , a5 out nocopy JTF_NUMBER_TABLE
193: , a6 out nocopy JTF_VARCHAR2_TABLE_100
194: , a7 out nocopy JTF_NUMBER_TABLE
195: , a8 out nocopy JTF_VARCHAR2_TABLE_100
196: , a9 out nocopy JTF_VARCHAR2_TABLE_100
190: , a3 out nocopy JTF_NUMBER_TABLE
191: , a4 out nocopy JTF_VARCHAR2_TABLE_300
192: , a5 out nocopy JTF_NUMBER_TABLE
193: , a6 out nocopy JTF_VARCHAR2_TABLE_100
194: , a7 out nocopy JTF_NUMBER_TABLE
195: , a8 out nocopy JTF_VARCHAR2_TABLE_100
196: , a9 out nocopy JTF_VARCHAR2_TABLE_100
197: );
198:
405: , p_init_msg_list VARCHAR2
406: , p_loan_id NUMBER
407: , p_payoff_date DATE
408: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
409: , p4_a1 out nocopy JTF_NUMBER_TABLE
410: , p4_a2 out nocopy JTF_NUMBER_TABLE
411: , p4_a3 out nocopy JTF_NUMBER_TABLE
412: , x_return_status out nocopy VARCHAR2
413: , x_msg_count out nocopy NUMBER
406: , p_loan_id NUMBER
407: , p_payoff_date DATE
408: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
409: , p4_a1 out nocopy JTF_NUMBER_TABLE
410: , p4_a2 out nocopy JTF_NUMBER_TABLE
411: , p4_a3 out nocopy JTF_NUMBER_TABLE
412: , x_return_status out nocopy VARCHAR2
413: , x_msg_count out nocopy NUMBER
414: , x_msg_data out nocopy VARCHAR2
407: , p_payoff_date DATE
408: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
409: , p4_a1 out nocopy JTF_NUMBER_TABLE
410: , p4_a2 out nocopy JTF_NUMBER_TABLE
411: , p4_a3 out nocopy JTF_NUMBER_TABLE
412: , x_return_status out nocopy VARCHAR2
413: , x_msg_count out nocopy NUMBER
414: , x_msg_data out nocopy VARCHAR2
415: );
510: , p0_a94 VARCHAR2
511: , p0_a95 VARCHAR2
512: , p_start_date DATE
513: , p_end_date DATE
514: , p3_a0 JTF_NUMBER_TABLE
515: , p3_a1 JTF_DATE_TABLE
516: , p3_a2 JTF_DATE_TABLE
517: , p3_a3 JTF_NUMBER_TABLE
518: , p3_a4 JTF_NUMBER_TABLE
513: , p_end_date DATE
514: , p3_a0 JTF_NUMBER_TABLE
515: , p3_a1 JTF_DATE_TABLE
516: , p3_a2 JTF_DATE_TABLE
517: , p3_a3 JTF_NUMBER_TABLE
518: , p3_a4 JTF_NUMBER_TABLE
519: , p3_a5 JTF_NUMBER_TABLE
520: , p3_a6 JTF_NUMBER_TABLE
521: , p3_a7 JTF_VARCHAR2_TABLE_100
514: , p3_a0 JTF_NUMBER_TABLE
515: , p3_a1 JTF_DATE_TABLE
516: , p3_a2 JTF_DATE_TABLE
517: , p3_a3 JTF_NUMBER_TABLE
518: , p3_a4 JTF_NUMBER_TABLE
519: , p3_a5 JTF_NUMBER_TABLE
520: , p3_a6 JTF_NUMBER_TABLE
521: , p3_a7 JTF_VARCHAR2_TABLE_100
522: , p3_a8 JTF_VARCHAR2_TABLE_100
515: , p3_a1 JTF_DATE_TABLE
516: , p3_a2 JTF_DATE_TABLE
517: , p3_a3 JTF_NUMBER_TABLE
518: , p3_a4 JTF_NUMBER_TABLE
519: , p3_a5 JTF_NUMBER_TABLE
520: , p3_a6 JTF_NUMBER_TABLE
521: , p3_a7 JTF_VARCHAR2_TABLE_100
522: , p3_a8 JTF_VARCHAR2_TABLE_100
523: , p3_a9 JTF_VARCHAR2_TABLE_100
516: , p3_a2 JTF_DATE_TABLE
517: , p3_a3 JTF_NUMBER_TABLE
518: , p3_a4 JTF_NUMBER_TABLE
519: , p3_a5 JTF_NUMBER_TABLE
520: , p3_a6 JTF_NUMBER_TABLE
521: , p3_a7 JTF_VARCHAR2_TABLE_100
522: , p3_a8 JTF_VARCHAR2_TABLE_100
523: , p3_a9 JTF_VARCHAR2_TABLE_100
524: ) return number;
617: , p0_a92 VARCHAR2
618: , p0_a93 VARCHAR2
619: , p0_a94 VARCHAR2
620: , p0_a95 VARCHAR2
621: , p1_a0 JTF_NUMBER_TABLE
622: , p1_a1 JTF_DATE_TABLE
623: , p1_a2 JTF_DATE_TABLE
624: , p1_a3 JTF_NUMBER_TABLE
625: , p1_a4 JTF_NUMBER_TABLE
620: , p0_a95 VARCHAR2
621: , p1_a0 JTF_NUMBER_TABLE
622: , p1_a1 JTF_DATE_TABLE
623: , p1_a2 JTF_DATE_TABLE
624: , p1_a3 JTF_NUMBER_TABLE
625: , p1_a4 JTF_NUMBER_TABLE
626: , p1_a5 JTF_NUMBER_TABLE
627: , p1_a6 JTF_NUMBER_TABLE
628: , p1_a7 JTF_VARCHAR2_TABLE_100
621: , p1_a0 JTF_NUMBER_TABLE
622: , p1_a1 JTF_DATE_TABLE
623: , p1_a2 JTF_DATE_TABLE
624: , p1_a3 JTF_NUMBER_TABLE
625: , p1_a4 JTF_NUMBER_TABLE
626: , p1_a5 JTF_NUMBER_TABLE
627: , p1_a6 JTF_NUMBER_TABLE
628: , p1_a7 JTF_VARCHAR2_TABLE_100
629: , p1_a8 JTF_VARCHAR2_TABLE_100
622: , p1_a1 JTF_DATE_TABLE
623: , p1_a2 JTF_DATE_TABLE
624: , p1_a3 JTF_NUMBER_TABLE
625: , p1_a4 JTF_NUMBER_TABLE
626: , p1_a5 JTF_NUMBER_TABLE
627: , p1_a6 JTF_NUMBER_TABLE
628: , p1_a7 JTF_VARCHAR2_TABLE_100
629: , p1_a8 JTF_VARCHAR2_TABLE_100
630: , p1_a9 JTF_VARCHAR2_TABLE_100
623: , p1_a2 JTF_DATE_TABLE
624: , p1_a3 JTF_NUMBER_TABLE
625: , p1_a4 JTF_NUMBER_TABLE
626: , p1_a5 JTF_NUMBER_TABLE
627: , p1_a6 JTF_NUMBER_TABLE
628: , p1_a7 JTF_VARCHAR2_TABLE_100
629: , p1_a8 JTF_VARCHAR2_TABLE_100
630: , p1_a9 JTF_VARCHAR2_TABLE_100
631: , p_based_on_terms VARCHAR2
629: , p1_a8 JTF_VARCHAR2_TABLE_100
630: , p1_a9 JTF_VARCHAR2_TABLE_100
631: , p_based_on_terms VARCHAR2
632: , p_installment_number NUMBER
633: , p4_a0 out nocopy JTF_NUMBER_TABLE
634: , p4_a1 out nocopy JTF_DATE_TABLE
635: , p4_a2 out nocopy JTF_DATE_TABLE
636: , p4_a3 out nocopy JTF_DATE_TABLE
637: , p4_a4 out nocopy JTF_NUMBER_TABLE
633: , p4_a0 out nocopy JTF_NUMBER_TABLE
634: , p4_a1 out nocopy JTF_DATE_TABLE
635: , p4_a2 out nocopy JTF_DATE_TABLE
636: , p4_a3 out nocopy JTF_DATE_TABLE
637: , p4_a4 out nocopy JTF_NUMBER_TABLE
638: , p4_a5 out nocopy JTF_NUMBER_TABLE
639: , p4_a6 out nocopy JTF_NUMBER_TABLE
640: , p4_a7 out nocopy JTF_NUMBER_TABLE
641: , p4_a8 out nocopy JTF_NUMBER_TABLE
634: , p4_a1 out nocopy JTF_DATE_TABLE
635: , p4_a2 out nocopy JTF_DATE_TABLE
636: , p4_a3 out nocopy JTF_DATE_TABLE
637: , p4_a4 out nocopy JTF_NUMBER_TABLE
638: , p4_a5 out nocopy JTF_NUMBER_TABLE
639: , p4_a6 out nocopy JTF_NUMBER_TABLE
640: , p4_a7 out nocopy JTF_NUMBER_TABLE
641: , p4_a8 out nocopy JTF_NUMBER_TABLE
642: , p4_a9 out nocopy JTF_NUMBER_TABLE
635: , p4_a2 out nocopy JTF_DATE_TABLE
636: , p4_a3 out nocopy JTF_DATE_TABLE
637: , p4_a4 out nocopy JTF_NUMBER_TABLE
638: , p4_a5 out nocopy JTF_NUMBER_TABLE
639: , p4_a6 out nocopy JTF_NUMBER_TABLE
640: , p4_a7 out nocopy JTF_NUMBER_TABLE
641: , p4_a8 out nocopy JTF_NUMBER_TABLE
642: , p4_a9 out nocopy JTF_NUMBER_TABLE
643: , p4_a10 out nocopy JTF_NUMBER_TABLE
636: , p4_a3 out nocopy JTF_DATE_TABLE
637: , p4_a4 out nocopy JTF_NUMBER_TABLE
638: , p4_a5 out nocopy JTF_NUMBER_TABLE
639: , p4_a6 out nocopy JTF_NUMBER_TABLE
640: , p4_a7 out nocopy JTF_NUMBER_TABLE
641: , p4_a8 out nocopy JTF_NUMBER_TABLE
642: , p4_a9 out nocopy JTF_NUMBER_TABLE
643: , p4_a10 out nocopy JTF_NUMBER_TABLE
644: , p4_a11 out nocopy JTF_NUMBER_TABLE
637: , p4_a4 out nocopy JTF_NUMBER_TABLE
638: , p4_a5 out nocopy JTF_NUMBER_TABLE
639: , p4_a6 out nocopy JTF_NUMBER_TABLE
640: , p4_a7 out nocopy JTF_NUMBER_TABLE
641: , p4_a8 out nocopy JTF_NUMBER_TABLE
642: , p4_a9 out nocopy JTF_NUMBER_TABLE
643: , p4_a10 out nocopy JTF_NUMBER_TABLE
644: , p4_a11 out nocopy JTF_NUMBER_TABLE
645: , p4_a12 out nocopy JTF_NUMBER_TABLE
638: , p4_a5 out nocopy JTF_NUMBER_TABLE
639: , p4_a6 out nocopy JTF_NUMBER_TABLE
640: , p4_a7 out nocopy JTF_NUMBER_TABLE
641: , p4_a8 out nocopy JTF_NUMBER_TABLE
642: , p4_a9 out nocopy JTF_NUMBER_TABLE
643: , p4_a10 out nocopy JTF_NUMBER_TABLE
644: , p4_a11 out nocopy JTF_NUMBER_TABLE
645: , p4_a12 out nocopy JTF_NUMBER_TABLE
646: , p4_a13 out nocopy JTF_NUMBER_TABLE
639: , p4_a6 out nocopy JTF_NUMBER_TABLE
640: , p4_a7 out nocopy JTF_NUMBER_TABLE
641: , p4_a8 out nocopy JTF_NUMBER_TABLE
642: , p4_a9 out nocopy JTF_NUMBER_TABLE
643: , p4_a10 out nocopy JTF_NUMBER_TABLE
644: , p4_a11 out nocopy JTF_NUMBER_TABLE
645: , p4_a12 out nocopy JTF_NUMBER_TABLE
646: , p4_a13 out nocopy JTF_NUMBER_TABLE
647: , p4_a14 out nocopy JTF_NUMBER_TABLE
640: , p4_a7 out nocopy JTF_NUMBER_TABLE
641: , p4_a8 out nocopy JTF_NUMBER_TABLE
642: , p4_a9 out nocopy JTF_NUMBER_TABLE
643: , p4_a10 out nocopy JTF_NUMBER_TABLE
644: , p4_a11 out nocopy JTF_NUMBER_TABLE
645: , p4_a12 out nocopy JTF_NUMBER_TABLE
646: , p4_a13 out nocopy JTF_NUMBER_TABLE
647: , p4_a14 out nocopy JTF_NUMBER_TABLE
648: , p4_a15 out nocopy JTF_NUMBER_TABLE
641: , p4_a8 out nocopy JTF_NUMBER_TABLE
642: , p4_a9 out nocopy JTF_NUMBER_TABLE
643: , p4_a10 out nocopy JTF_NUMBER_TABLE
644: , p4_a11 out nocopy JTF_NUMBER_TABLE
645: , p4_a12 out nocopy JTF_NUMBER_TABLE
646: , p4_a13 out nocopy JTF_NUMBER_TABLE
647: , p4_a14 out nocopy JTF_NUMBER_TABLE
648: , p4_a15 out nocopy JTF_NUMBER_TABLE
649: , p4_a16 out nocopy JTF_NUMBER_TABLE
642: , p4_a9 out nocopy JTF_NUMBER_TABLE
643: , p4_a10 out nocopy JTF_NUMBER_TABLE
644: , p4_a11 out nocopy JTF_NUMBER_TABLE
645: , p4_a12 out nocopy JTF_NUMBER_TABLE
646: , p4_a13 out nocopy JTF_NUMBER_TABLE
647: , p4_a14 out nocopy JTF_NUMBER_TABLE
648: , p4_a15 out nocopy JTF_NUMBER_TABLE
649: , p4_a16 out nocopy JTF_NUMBER_TABLE
650: , p4_a17 out nocopy JTF_NUMBER_TABLE
643: , p4_a10 out nocopy JTF_NUMBER_TABLE
644: , p4_a11 out nocopy JTF_NUMBER_TABLE
645: , p4_a12 out nocopy JTF_NUMBER_TABLE
646: , p4_a13 out nocopy JTF_NUMBER_TABLE
647: , p4_a14 out nocopy JTF_NUMBER_TABLE
648: , p4_a15 out nocopy JTF_NUMBER_TABLE
649: , p4_a16 out nocopy JTF_NUMBER_TABLE
650: , p4_a17 out nocopy JTF_NUMBER_TABLE
651: , p4_a18 out nocopy JTF_NUMBER_TABLE
644: , p4_a11 out nocopy JTF_NUMBER_TABLE
645: , p4_a12 out nocopy JTF_NUMBER_TABLE
646: , p4_a13 out nocopy JTF_NUMBER_TABLE
647: , p4_a14 out nocopy JTF_NUMBER_TABLE
648: , p4_a15 out nocopy JTF_NUMBER_TABLE
649: , p4_a16 out nocopy JTF_NUMBER_TABLE
650: , p4_a17 out nocopy JTF_NUMBER_TABLE
651: , p4_a18 out nocopy JTF_NUMBER_TABLE
652: , p4_a19 out nocopy JTF_NUMBER_TABLE
645: , p4_a12 out nocopy JTF_NUMBER_TABLE
646: , p4_a13 out nocopy JTF_NUMBER_TABLE
647: , p4_a14 out nocopy JTF_NUMBER_TABLE
648: , p4_a15 out nocopy JTF_NUMBER_TABLE
649: , p4_a16 out nocopy JTF_NUMBER_TABLE
650: , p4_a17 out nocopy JTF_NUMBER_TABLE
651: , p4_a18 out nocopy JTF_NUMBER_TABLE
652: , p4_a19 out nocopy JTF_NUMBER_TABLE
653: , p4_a20 out nocopy JTF_NUMBER_TABLE
646: , p4_a13 out nocopy JTF_NUMBER_TABLE
647: , p4_a14 out nocopy JTF_NUMBER_TABLE
648: , p4_a15 out nocopy JTF_NUMBER_TABLE
649: , p4_a16 out nocopy JTF_NUMBER_TABLE
650: , p4_a17 out nocopy JTF_NUMBER_TABLE
651: , p4_a18 out nocopy JTF_NUMBER_TABLE
652: , p4_a19 out nocopy JTF_NUMBER_TABLE
653: , p4_a20 out nocopy JTF_NUMBER_TABLE
654: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
647: , p4_a14 out nocopy JTF_NUMBER_TABLE
648: , p4_a15 out nocopy JTF_NUMBER_TABLE
649: , p4_a16 out nocopy JTF_NUMBER_TABLE
650: , p4_a17 out nocopy JTF_NUMBER_TABLE
651: , p4_a18 out nocopy JTF_NUMBER_TABLE
652: , p4_a19 out nocopy JTF_NUMBER_TABLE
653: , p4_a20 out nocopy JTF_NUMBER_TABLE
654: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
655: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
648: , p4_a15 out nocopy JTF_NUMBER_TABLE
649: , p4_a16 out nocopy JTF_NUMBER_TABLE
650: , p4_a17 out nocopy JTF_NUMBER_TABLE
651: , p4_a18 out nocopy JTF_NUMBER_TABLE
652: , p4_a19 out nocopy JTF_NUMBER_TABLE
653: , p4_a20 out nocopy JTF_NUMBER_TABLE
654: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
655: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
656: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
649: , p4_a16 out nocopy JTF_NUMBER_TABLE
650: , p4_a17 out nocopy JTF_NUMBER_TABLE
651: , p4_a18 out nocopy JTF_NUMBER_TABLE
652: , p4_a19 out nocopy JTF_NUMBER_TABLE
653: , p4_a20 out nocopy JTF_NUMBER_TABLE
654: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
655: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
656: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
657: , p4_a24 out nocopy JTF_NUMBER_TABLE
653: , p4_a20 out nocopy JTF_NUMBER_TABLE
654: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
655: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
656: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
657: , p4_a24 out nocopy JTF_NUMBER_TABLE
658: , p4_a25 out nocopy JTF_NUMBER_TABLE
659: , p4_a26 out nocopy JTF_NUMBER_TABLE
660: , p4_a27 out nocopy JTF_NUMBER_TABLE
661: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
654: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
655: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
656: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
657: , p4_a24 out nocopy JTF_NUMBER_TABLE
658: , p4_a25 out nocopy JTF_NUMBER_TABLE
659: , p4_a26 out nocopy JTF_NUMBER_TABLE
660: , p4_a27 out nocopy JTF_NUMBER_TABLE
661: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
662: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
655: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
656: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
657: , p4_a24 out nocopy JTF_NUMBER_TABLE
658: , p4_a25 out nocopy JTF_NUMBER_TABLE
659: , p4_a26 out nocopy JTF_NUMBER_TABLE
660: , p4_a27 out nocopy JTF_NUMBER_TABLE
661: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
662: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
663: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
656: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
657: , p4_a24 out nocopy JTF_NUMBER_TABLE
658: , p4_a25 out nocopy JTF_NUMBER_TABLE
659: , p4_a26 out nocopy JTF_NUMBER_TABLE
660: , p4_a27 out nocopy JTF_NUMBER_TABLE
661: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
662: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
663: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
664: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
661: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
662: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
663: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
664: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
665: , p4_a32 out nocopy JTF_NUMBER_TABLE
666: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
667: , p4_a34 out nocopy JTF_NUMBER_TABLE
668: , p4_a35 out nocopy JTF_NUMBER_TABLE
669: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
663: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
664: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
665: , p4_a32 out nocopy JTF_NUMBER_TABLE
666: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
667: , p4_a34 out nocopy JTF_NUMBER_TABLE
668: , p4_a35 out nocopy JTF_NUMBER_TABLE
669: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
670: , p4_a37 out nocopy JTF_NUMBER_TABLE
671: , p4_a38 out nocopy JTF_NUMBER_TABLE
664: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
665: , p4_a32 out nocopy JTF_NUMBER_TABLE
666: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
667: , p4_a34 out nocopy JTF_NUMBER_TABLE
668: , p4_a35 out nocopy JTF_NUMBER_TABLE
669: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
670: , p4_a37 out nocopy JTF_NUMBER_TABLE
671: , p4_a38 out nocopy JTF_NUMBER_TABLE
672: , p4_a39 out nocopy JTF_NUMBER_TABLE
666: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
667: , p4_a34 out nocopy JTF_NUMBER_TABLE
668: , p4_a35 out nocopy JTF_NUMBER_TABLE
669: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
670: , p4_a37 out nocopy JTF_NUMBER_TABLE
671: , p4_a38 out nocopy JTF_NUMBER_TABLE
672: , p4_a39 out nocopy JTF_NUMBER_TABLE
673: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
674: , p4_a41 out nocopy JTF_NUMBER_TABLE
667: , p4_a34 out nocopy JTF_NUMBER_TABLE
668: , p4_a35 out nocopy JTF_NUMBER_TABLE
669: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
670: , p4_a37 out nocopy JTF_NUMBER_TABLE
671: , p4_a38 out nocopy JTF_NUMBER_TABLE
672: , p4_a39 out nocopy JTF_NUMBER_TABLE
673: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
674: , p4_a41 out nocopy JTF_NUMBER_TABLE
675: , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000
668: , p4_a35 out nocopy JTF_NUMBER_TABLE
669: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
670: , p4_a37 out nocopy JTF_NUMBER_TABLE
671: , p4_a38 out nocopy JTF_NUMBER_TABLE
672: , p4_a39 out nocopy JTF_NUMBER_TABLE
673: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
674: , p4_a41 out nocopy JTF_NUMBER_TABLE
675: , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000
676: );
670: , p4_a37 out nocopy JTF_NUMBER_TABLE
671: , p4_a38 out nocopy JTF_NUMBER_TABLE
672: , p4_a39 out nocopy JTF_NUMBER_TABLE
673: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
674: , p4_a41 out nocopy JTF_NUMBER_TABLE
675: , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000
676: );
677: procedure amortizeloan(p0_a0 NUMBER
678: , p0_a1 NUMBER
769: , p0_a92 VARCHAR2
770: , p0_a93 VARCHAR2
771: , p0_a94 VARCHAR2
772: , p0_a95 VARCHAR2
773: , p1_a0 JTF_NUMBER_TABLE
774: , p1_a1 JTF_DATE_TABLE
775: , p1_a2 JTF_DATE_TABLE
776: , p1_a3 JTF_NUMBER_TABLE
777: , p1_a4 JTF_NUMBER_TABLE
772: , p0_a95 VARCHAR2
773: , p1_a0 JTF_NUMBER_TABLE
774: , p1_a1 JTF_DATE_TABLE
775: , p1_a2 JTF_DATE_TABLE
776: , p1_a3 JTF_NUMBER_TABLE
777: , p1_a4 JTF_NUMBER_TABLE
778: , p1_a5 JTF_NUMBER_TABLE
779: , p1_a6 JTF_NUMBER_TABLE
780: , p1_a7 JTF_VARCHAR2_TABLE_100
773: , p1_a0 JTF_NUMBER_TABLE
774: , p1_a1 JTF_DATE_TABLE
775: , p1_a2 JTF_DATE_TABLE
776: , p1_a3 JTF_NUMBER_TABLE
777: , p1_a4 JTF_NUMBER_TABLE
778: , p1_a5 JTF_NUMBER_TABLE
779: , p1_a6 JTF_NUMBER_TABLE
780: , p1_a7 JTF_VARCHAR2_TABLE_100
781: , p1_a8 JTF_VARCHAR2_TABLE_100
774: , p1_a1 JTF_DATE_TABLE
775: , p1_a2 JTF_DATE_TABLE
776: , p1_a3 JTF_NUMBER_TABLE
777: , p1_a4 JTF_NUMBER_TABLE
778: , p1_a5 JTF_NUMBER_TABLE
779: , p1_a6 JTF_NUMBER_TABLE
780: , p1_a7 JTF_VARCHAR2_TABLE_100
781: , p1_a8 JTF_VARCHAR2_TABLE_100
782: , p1_a9 JTF_VARCHAR2_TABLE_100
775: , p1_a2 JTF_DATE_TABLE
776: , p1_a3 JTF_NUMBER_TABLE
777: , p1_a4 JTF_NUMBER_TABLE
778: , p1_a5 JTF_NUMBER_TABLE
779: , p1_a6 JTF_NUMBER_TABLE
780: , p1_a7 JTF_VARCHAR2_TABLE_100
781: , p1_a8 JTF_VARCHAR2_TABLE_100
782: , p1_a9 JTF_VARCHAR2_TABLE_100
783: , p_based_on_terms VARCHAR2
781: , p1_a8 JTF_VARCHAR2_TABLE_100
782: , p1_a9 JTF_VARCHAR2_TABLE_100
783: , p_based_on_terms VARCHAR2
784: , p_installment_number NUMBER
785: , p4_a0 out nocopy JTF_NUMBER_TABLE
786: , p4_a1 out nocopy JTF_DATE_TABLE
787: , p4_a2 out nocopy JTF_DATE_TABLE
788: , p4_a3 out nocopy JTF_DATE_TABLE
789: , p4_a4 out nocopy JTF_NUMBER_TABLE
785: , p4_a0 out nocopy JTF_NUMBER_TABLE
786: , p4_a1 out nocopy JTF_DATE_TABLE
787: , p4_a2 out nocopy JTF_DATE_TABLE
788: , p4_a3 out nocopy JTF_DATE_TABLE
789: , p4_a4 out nocopy JTF_NUMBER_TABLE
790: , p4_a5 out nocopy JTF_NUMBER_TABLE
791: , p4_a6 out nocopy JTF_NUMBER_TABLE
792: , p4_a7 out nocopy JTF_NUMBER_TABLE
793: , p4_a8 out nocopy JTF_NUMBER_TABLE
786: , p4_a1 out nocopy JTF_DATE_TABLE
787: , p4_a2 out nocopy JTF_DATE_TABLE
788: , p4_a3 out nocopy JTF_DATE_TABLE
789: , p4_a4 out nocopy JTF_NUMBER_TABLE
790: , p4_a5 out nocopy JTF_NUMBER_TABLE
791: , p4_a6 out nocopy JTF_NUMBER_TABLE
792: , p4_a7 out nocopy JTF_NUMBER_TABLE
793: , p4_a8 out nocopy JTF_NUMBER_TABLE
794: , p4_a9 out nocopy JTF_NUMBER_TABLE
787: , p4_a2 out nocopy JTF_DATE_TABLE
788: , p4_a3 out nocopy JTF_DATE_TABLE
789: , p4_a4 out nocopy JTF_NUMBER_TABLE
790: , p4_a5 out nocopy JTF_NUMBER_TABLE
791: , p4_a6 out nocopy JTF_NUMBER_TABLE
792: , p4_a7 out nocopy JTF_NUMBER_TABLE
793: , p4_a8 out nocopy JTF_NUMBER_TABLE
794: , p4_a9 out nocopy JTF_NUMBER_TABLE
795: , p4_a10 out nocopy JTF_NUMBER_TABLE
788: , p4_a3 out nocopy JTF_DATE_TABLE
789: , p4_a4 out nocopy JTF_NUMBER_TABLE
790: , p4_a5 out nocopy JTF_NUMBER_TABLE
791: , p4_a6 out nocopy JTF_NUMBER_TABLE
792: , p4_a7 out nocopy JTF_NUMBER_TABLE
793: , p4_a8 out nocopy JTF_NUMBER_TABLE
794: , p4_a9 out nocopy JTF_NUMBER_TABLE
795: , p4_a10 out nocopy JTF_NUMBER_TABLE
796: , p4_a11 out nocopy JTF_NUMBER_TABLE
789: , p4_a4 out nocopy JTF_NUMBER_TABLE
790: , p4_a5 out nocopy JTF_NUMBER_TABLE
791: , p4_a6 out nocopy JTF_NUMBER_TABLE
792: , p4_a7 out nocopy JTF_NUMBER_TABLE
793: , p4_a8 out nocopy JTF_NUMBER_TABLE
794: , p4_a9 out nocopy JTF_NUMBER_TABLE
795: , p4_a10 out nocopy JTF_NUMBER_TABLE
796: , p4_a11 out nocopy JTF_NUMBER_TABLE
797: , p4_a12 out nocopy JTF_NUMBER_TABLE
790: , p4_a5 out nocopy JTF_NUMBER_TABLE
791: , p4_a6 out nocopy JTF_NUMBER_TABLE
792: , p4_a7 out nocopy JTF_NUMBER_TABLE
793: , p4_a8 out nocopy JTF_NUMBER_TABLE
794: , p4_a9 out nocopy JTF_NUMBER_TABLE
795: , p4_a10 out nocopy JTF_NUMBER_TABLE
796: , p4_a11 out nocopy JTF_NUMBER_TABLE
797: , p4_a12 out nocopy JTF_NUMBER_TABLE
798: , p4_a13 out nocopy JTF_NUMBER_TABLE
791: , p4_a6 out nocopy JTF_NUMBER_TABLE
792: , p4_a7 out nocopy JTF_NUMBER_TABLE
793: , p4_a8 out nocopy JTF_NUMBER_TABLE
794: , p4_a9 out nocopy JTF_NUMBER_TABLE
795: , p4_a10 out nocopy JTF_NUMBER_TABLE
796: , p4_a11 out nocopy JTF_NUMBER_TABLE
797: , p4_a12 out nocopy JTF_NUMBER_TABLE
798: , p4_a13 out nocopy JTF_NUMBER_TABLE
799: , p4_a14 out nocopy JTF_NUMBER_TABLE
792: , p4_a7 out nocopy JTF_NUMBER_TABLE
793: , p4_a8 out nocopy JTF_NUMBER_TABLE
794: , p4_a9 out nocopy JTF_NUMBER_TABLE
795: , p4_a10 out nocopy JTF_NUMBER_TABLE
796: , p4_a11 out nocopy JTF_NUMBER_TABLE
797: , p4_a12 out nocopy JTF_NUMBER_TABLE
798: , p4_a13 out nocopy JTF_NUMBER_TABLE
799: , p4_a14 out nocopy JTF_NUMBER_TABLE
800: , p4_a15 out nocopy JTF_NUMBER_TABLE
793: , p4_a8 out nocopy JTF_NUMBER_TABLE
794: , p4_a9 out nocopy JTF_NUMBER_TABLE
795: , p4_a10 out nocopy JTF_NUMBER_TABLE
796: , p4_a11 out nocopy JTF_NUMBER_TABLE
797: , p4_a12 out nocopy JTF_NUMBER_TABLE
798: , p4_a13 out nocopy JTF_NUMBER_TABLE
799: , p4_a14 out nocopy JTF_NUMBER_TABLE
800: , p4_a15 out nocopy JTF_NUMBER_TABLE
801: , p4_a16 out nocopy JTF_NUMBER_TABLE
794: , p4_a9 out nocopy JTF_NUMBER_TABLE
795: , p4_a10 out nocopy JTF_NUMBER_TABLE
796: , p4_a11 out nocopy JTF_NUMBER_TABLE
797: , p4_a12 out nocopy JTF_NUMBER_TABLE
798: , p4_a13 out nocopy JTF_NUMBER_TABLE
799: , p4_a14 out nocopy JTF_NUMBER_TABLE
800: , p4_a15 out nocopy JTF_NUMBER_TABLE
801: , p4_a16 out nocopy JTF_NUMBER_TABLE
802: , p4_a17 out nocopy JTF_NUMBER_TABLE
795: , p4_a10 out nocopy JTF_NUMBER_TABLE
796: , p4_a11 out nocopy JTF_NUMBER_TABLE
797: , p4_a12 out nocopy JTF_NUMBER_TABLE
798: , p4_a13 out nocopy JTF_NUMBER_TABLE
799: , p4_a14 out nocopy JTF_NUMBER_TABLE
800: , p4_a15 out nocopy JTF_NUMBER_TABLE
801: , p4_a16 out nocopy JTF_NUMBER_TABLE
802: , p4_a17 out nocopy JTF_NUMBER_TABLE
803: , p4_a18 out nocopy JTF_NUMBER_TABLE
796: , p4_a11 out nocopy JTF_NUMBER_TABLE
797: , p4_a12 out nocopy JTF_NUMBER_TABLE
798: , p4_a13 out nocopy JTF_NUMBER_TABLE
799: , p4_a14 out nocopy JTF_NUMBER_TABLE
800: , p4_a15 out nocopy JTF_NUMBER_TABLE
801: , p4_a16 out nocopy JTF_NUMBER_TABLE
802: , p4_a17 out nocopy JTF_NUMBER_TABLE
803: , p4_a18 out nocopy JTF_NUMBER_TABLE
804: , p4_a19 out nocopy JTF_NUMBER_TABLE
797: , p4_a12 out nocopy JTF_NUMBER_TABLE
798: , p4_a13 out nocopy JTF_NUMBER_TABLE
799: , p4_a14 out nocopy JTF_NUMBER_TABLE
800: , p4_a15 out nocopy JTF_NUMBER_TABLE
801: , p4_a16 out nocopy JTF_NUMBER_TABLE
802: , p4_a17 out nocopy JTF_NUMBER_TABLE
803: , p4_a18 out nocopy JTF_NUMBER_TABLE
804: , p4_a19 out nocopy JTF_NUMBER_TABLE
805: , p4_a20 out nocopy JTF_NUMBER_TABLE
798: , p4_a13 out nocopy JTF_NUMBER_TABLE
799: , p4_a14 out nocopy JTF_NUMBER_TABLE
800: , p4_a15 out nocopy JTF_NUMBER_TABLE
801: , p4_a16 out nocopy JTF_NUMBER_TABLE
802: , p4_a17 out nocopy JTF_NUMBER_TABLE
803: , p4_a18 out nocopy JTF_NUMBER_TABLE
804: , p4_a19 out nocopy JTF_NUMBER_TABLE
805: , p4_a20 out nocopy JTF_NUMBER_TABLE
806: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
799: , p4_a14 out nocopy JTF_NUMBER_TABLE
800: , p4_a15 out nocopy JTF_NUMBER_TABLE
801: , p4_a16 out nocopy JTF_NUMBER_TABLE
802: , p4_a17 out nocopy JTF_NUMBER_TABLE
803: , p4_a18 out nocopy JTF_NUMBER_TABLE
804: , p4_a19 out nocopy JTF_NUMBER_TABLE
805: , p4_a20 out nocopy JTF_NUMBER_TABLE
806: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
807: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
800: , p4_a15 out nocopy JTF_NUMBER_TABLE
801: , p4_a16 out nocopy JTF_NUMBER_TABLE
802: , p4_a17 out nocopy JTF_NUMBER_TABLE
803: , p4_a18 out nocopy JTF_NUMBER_TABLE
804: , p4_a19 out nocopy JTF_NUMBER_TABLE
805: , p4_a20 out nocopy JTF_NUMBER_TABLE
806: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
807: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
808: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
801: , p4_a16 out nocopy JTF_NUMBER_TABLE
802: , p4_a17 out nocopy JTF_NUMBER_TABLE
803: , p4_a18 out nocopy JTF_NUMBER_TABLE
804: , p4_a19 out nocopy JTF_NUMBER_TABLE
805: , p4_a20 out nocopy JTF_NUMBER_TABLE
806: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
807: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
808: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
809: , p4_a24 out nocopy JTF_NUMBER_TABLE
805: , p4_a20 out nocopy JTF_NUMBER_TABLE
806: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
807: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
808: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
809: , p4_a24 out nocopy JTF_NUMBER_TABLE
810: , p4_a25 out nocopy JTF_NUMBER_TABLE
811: , p4_a26 out nocopy JTF_NUMBER_TABLE
812: , p4_a27 out nocopy JTF_NUMBER_TABLE
813: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
806: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
807: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
808: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
809: , p4_a24 out nocopy JTF_NUMBER_TABLE
810: , p4_a25 out nocopy JTF_NUMBER_TABLE
811: , p4_a26 out nocopy JTF_NUMBER_TABLE
812: , p4_a27 out nocopy JTF_NUMBER_TABLE
813: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
814: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
807: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
808: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
809: , p4_a24 out nocopy JTF_NUMBER_TABLE
810: , p4_a25 out nocopy JTF_NUMBER_TABLE
811: , p4_a26 out nocopy JTF_NUMBER_TABLE
812: , p4_a27 out nocopy JTF_NUMBER_TABLE
813: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
814: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
815: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
808: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
809: , p4_a24 out nocopy JTF_NUMBER_TABLE
810: , p4_a25 out nocopy JTF_NUMBER_TABLE
811: , p4_a26 out nocopy JTF_NUMBER_TABLE
812: , p4_a27 out nocopy JTF_NUMBER_TABLE
813: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
814: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
815: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
816: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
813: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
814: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
815: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
816: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
817: , p4_a32 out nocopy JTF_NUMBER_TABLE
818: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
819: , p4_a34 out nocopy JTF_NUMBER_TABLE
820: , p4_a35 out nocopy JTF_NUMBER_TABLE
821: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
815: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
816: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
817: , p4_a32 out nocopy JTF_NUMBER_TABLE
818: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
819: , p4_a34 out nocopy JTF_NUMBER_TABLE
820: , p4_a35 out nocopy JTF_NUMBER_TABLE
821: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
822: , p4_a37 out nocopy JTF_NUMBER_TABLE
823: , p4_a38 out nocopy JTF_NUMBER_TABLE
816: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
817: , p4_a32 out nocopy JTF_NUMBER_TABLE
818: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
819: , p4_a34 out nocopy JTF_NUMBER_TABLE
820: , p4_a35 out nocopy JTF_NUMBER_TABLE
821: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
822: , p4_a37 out nocopy JTF_NUMBER_TABLE
823: , p4_a38 out nocopy JTF_NUMBER_TABLE
824: , p4_a39 out nocopy JTF_NUMBER_TABLE
818: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
819: , p4_a34 out nocopy JTF_NUMBER_TABLE
820: , p4_a35 out nocopy JTF_NUMBER_TABLE
821: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
822: , p4_a37 out nocopy JTF_NUMBER_TABLE
823: , p4_a38 out nocopy JTF_NUMBER_TABLE
824: , p4_a39 out nocopy JTF_NUMBER_TABLE
825: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
826: , p4_a41 out nocopy JTF_NUMBER_TABLE
819: , p4_a34 out nocopy JTF_NUMBER_TABLE
820: , p4_a35 out nocopy JTF_NUMBER_TABLE
821: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
822: , p4_a37 out nocopy JTF_NUMBER_TABLE
823: , p4_a38 out nocopy JTF_NUMBER_TABLE
824: , p4_a39 out nocopy JTF_NUMBER_TABLE
825: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
826: , p4_a41 out nocopy JTF_NUMBER_TABLE
827: , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000
820: , p4_a35 out nocopy JTF_NUMBER_TABLE
821: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
822: , p4_a37 out nocopy JTF_NUMBER_TABLE
823: , p4_a38 out nocopy JTF_NUMBER_TABLE
824: , p4_a39 out nocopy JTF_NUMBER_TABLE
825: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
826: , p4_a41 out nocopy JTF_NUMBER_TABLE
827: , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000
828: );
822: , p4_a37 out nocopy JTF_NUMBER_TABLE
823: , p4_a38 out nocopy JTF_NUMBER_TABLE
824: , p4_a39 out nocopy JTF_NUMBER_TABLE
825: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
826: , p4_a41 out nocopy JTF_NUMBER_TABLE
827: , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000
828: );
829: procedure amortizeloan(p_loan_id NUMBER
830: , p_based_on_terms VARCHAR2
828: );
829: procedure amortizeloan(p_loan_id NUMBER
830: , p_based_on_terms VARCHAR2
831: , p_installment_number NUMBER
832: , p3_a0 out nocopy JTF_NUMBER_TABLE
833: , p3_a1 out nocopy JTF_DATE_TABLE
834: , p3_a2 out nocopy JTF_DATE_TABLE
835: , p3_a3 out nocopy JTF_DATE_TABLE
836: , p3_a4 out nocopy JTF_NUMBER_TABLE
832: , p3_a0 out nocopy JTF_NUMBER_TABLE
833: , p3_a1 out nocopy JTF_DATE_TABLE
834: , p3_a2 out nocopy JTF_DATE_TABLE
835: , p3_a3 out nocopy JTF_DATE_TABLE
836: , p3_a4 out nocopy JTF_NUMBER_TABLE
837: , p3_a5 out nocopy JTF_NUMBER_TABLE
838: , p3_a6 out nocopy JTF_NUMBER_TABLE
839: , p3_a7 out nocopy JTF_NUMBER_TABLE
840: , p3_a8 out nocopy JTF_NUMBER_TABLE
833: , p3_a1 out nocopy JTF_DATE_TABLE
834: , p3_a2 out nocopy JTF_DATE_TABLE
835: , p3_a3 out nocopy JTF_DATE_TABLE
836: , p3_a4 out nocopy JTF_NUMBER_TABLE
837: , p3_a5 out nocopy JTF_NUMBER_TABLE
838: , p3_a6 out nocopy JTF_NUMBER_TABLE
839: , p3_a7 out nocopy JTF_NUMBER_TABLE
840: , p3_a8 out nocopy JTF_NUMBER_TABLE
841: , p3_a9 out nocopy JTF_NUMBER_TABLE
834: , p3_a2 out nocopy JTF_DATE_TABLE
835: , p3_a3 out nocopy JTF_DATE_TABLE
836: , p3_a4 out nocopy JTF_NUMBER_TABLE
837: , p3_a5 out nocopy JTF_NUMBER_TABLE
838: , p3_a6 out nocopy JTF_NUMBER_TABLE
839: , p3_a7 out nocopy JTF_NUMBER_TABLE
840: , p3_a8 out nocopy JTF_NUMBER_TABLE
841: , p3_a9 out nocopy JTF_NUMBER_TABLE
842: , p3_a10 out nocopy JTF_NUMBER_TABLE
835: , p3_a3 out nocopy JTF_DATE_TABLE
836: , p3_a4 out nocopy JTF_NUMBER_TABLE
837: , p3_a5 out nocopy JTF_NUMBER_TABLE
838: , p3_a6 out nocopy JTF_NUMBER_TABLE
839: , p3_a7 out nocopy JTF_NUMBER_TABLE
840: , p3_a8 out nocopy JTF_NUMBER_TABLE
841: , p3_a9 out nocopy JTF_NUMBER_TABLE
842: , p3_a10 out nocopy JTF_NUMBER_TABLE
843: , p3_a11 out nocopy JTF_NUMBER_TABLE
836: , p3_a4 out nocopy JTF_NUMBER_TABLE
837: , p3_a5 out nocopy JTF_NUMBER_TABLE
838: , p3_a6 out nocopy JTF_NUMBER_TABLE
839: , p3_a7 out nocopy JTF_NUMBER_TABLE
840: , p3_a8 out nocopy JTF_NUMBER_TABLE
841: , p3_a9 out nocopy JTF_NUMBER_TABLE
842: , p3_a10 out nocopy JTF_NUMBER_TABLE
843: , p3_a11 out nocopy JTF_NUMBER_TABLE
844: , p3_a12 out nocopy JTF_NUMBER_TABLE
837: , p3_a5 out nocopy JTF_NUMBER_TABLE
838: , p3_a6 out nocopy JTF_NUMBER_TABLE
839: , p3_a7 out nocopy JTF_NUMBER_TABLE
840: , p3_a8 out nocopy JTF_NUMBER_TABLE
841: , p3_a9 out nocopy JTF_NUMBER_TABLE
842: , p3_a10 out nocopy JTF_NUMBER_TABLE
843: , p3_a11 out nocopy JTF_NUMBER_TABLE
844: , p3_a12 out nocopy JTF_NUMBER_TABLE
845: , p3_a13 out nocopy JTF_NUMBER_TABLE
838: , p3_a6 out nocopy JTF_NUMBER_TABLE
839: , p3_a7 out nocopy JTF_NUMBER_TABLE
840: , p3_a8 out nocopy JTF_NUMBER_TABLE
841: , p3_a9 out nocopy JTF_NUMBER_TABLE
842: , p3_a10 out nocopy JTF_NUMBER_TABLE
843: , p3_a11 out nocopy JTF_NUMBER_TABLE
844: , p3_a12 out nocopy JTF_NUMBER_TABLE
845: , p3_a13 out nocopy JTF_NUMBER_TABLE
846: , p3_a14 out nocopy JTF_NUMBER_TABLE
839: , p3_a7 out nocopy JTF_NUMBER_TABLE
840: , p3_a8 out nocopy JTF_NUMBER_TABLE
841: , p3_a9 out nocopy JTF_NUMBER_TABLE
842: , p3_a10 out nocopy JTF_NUMBER_TABLE
843: , p3_a11 out nocopy JTF_NUMBER_TABLE
844: , p3_a12 out nocopy JTF_NUMBER_TABLE
845: , p3_a13 out nocopy JTF_NUMBER_TABLE
846: , p3_a14 out nocopy JTF_NUMBER_TABLE
847: , p3_a15 out nocopy JTF_NUMBER_TABLE
840: , p3_a8 out nocopy JTF_NUMBER_TABLE
841: , p3_a9 out nocopy JTF_NUMBER_TABLE
842: , p3_a10 out nocopy JTF_NUMBER_TABLE
843: , p3_a11 out nocopy JTF_NUMBER_TABLE
844: , p3_a12 out nocopy JTF_NUMBER_TABLE
845: , p3_a13 out nocopy JTF_NUMBER_TABLE
846: , p3_a14 out nocopy JTF_NUMBER_TABLE
847: , p3_a15 out nocopy JTF_NUMBER_TABLE
848: , p3_a16 out nocopy JTF_NUMBER_TABLE
841: , p3_a9 out nocopy JTF_NUMBER_TABLE
842: , p3_a10 out nocopy JTF_NUMBER_TABLE
843: , p3_a11 out nocopy JTF_NUMBER_TABLE
844: , p3_a12 out nocopy JTF_NUMBER_TABLE
845: , p3_a13 out nocopy JTF_NUMBER_TABLE
846: , p3_a14 out nocopy JTF_NUMBER_TABLE
847: , p3_a15 out nocopy JTF_NUMBER_TABLE
848: , p3_a16 out nocopy JTF_NUMBER_TABLE
849: , p3_a17 out nocopy JTF_NUMBER_TABLE
842: , p3_a10 out nocopy JTF_NUMBER_TABLE
843: , p3_a11 out nocopy JTF_NUMBER_TABLE
844: , p3_a12 out nocopy JTF_NUMBER_TABLE
845: , p3_a13 out nocopy JTF_NUMBER_TABLE
846: , p3_a14 out nocopy JTF_NUMBER_TABLE
847: , p3_a15 out nocopy JTF_NUMBER_TABLE
848: , p3_a16 out nocopy JTF_NUMBER_TABLE
849: , p3_a17 out nocopy JTF_NUMBER_TABLE
850: , p3_a18 out nocopy JTF_NUMBER_TABLE
843: , p3_a11 out nocopy JTF_NUMBER_TABLE
844: , p3_a12 out nocopy JTF_NUMBER_TABLE
845: , p3_a13 out nocopy JTF_NUMBER_TABLE
846: , p3_a14 out nocopy JTF_NUMBER_TABLE
847: , p3_a15 out nocopy JTF_NUMBER_TABLE
848: , p3_a16 out nocopy JTF_NUMBER_TABLE
849: , p3_a17 out nocopy JTF_NUMBER_TABLE
850: , p3_a18 out nocopy JTF_NUMBER_TABLE
851: , p3_a19 out nocopy JTF_NUMBER_TABLE
844: , p3_a12 out nocopy JTF_NUMBER_TABLE
845: , p3_a13 out nocopy JTF_NUMBER_TABLE
846: , p3_a14 out nocopy JTF_NUMBER_TABLE
847: , p3_a15 out nocopy JTF_NUMBER_TABLE
848: , p3_a16 out nocopy JTF_NUMBER_TABLE
849: , p3_a17 out nocopy JTF_NUMBER_TABLE
850: , p3_a18 out nocopy JTF_NUMBER_TABLE
851: , p3_a19 out nocopy JTF_NUMBER_TABLE
852: , p3_a20 out nocopy JTF_NUMBER_TABLE
845: , p3_a13 out nocopy JTF_NUMBER_TABLE
846: , p3_a14 out nocopy JTF_NUMBER_TABLE
847: , p3_a15 out nocopy JTF_NUMBER_TABLE
848: , p3_a16 out nocopy JTF_NUMBER_TABLE
849: , p3_a17 out nocopy JTF_NUMBER_TABLE
850: , p3_a18 out nocopy JTF_NUMBER_TABLE
851: , p3_a19 out nocopy JTF_NUMBER_TABLE
852: , p3_a20 out nocopy JTF_NUMBER_TABLE
853: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
846: , p3_a14 out nocopy JTF_NUMBER_TABLE
847: , p3_a15 out nocopy JTF_NUMBER_TABLE
848: , p3_a16 out nocopy JTF_NUMBER_TABLE
849: , p3_a17 out nocopy JTF_NUMBER_TABLE
850: , p3_a18 out nocopy JTF_NUMBER_TABLE
851: , p3_a19 out nocopy JTF_NUMBER_TABLE
852: , p3_a20 out nocopy JTF_NUMBER_TABLE
853: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
854: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
847: , p3_a15 out nocopy JTF_NUMBER_TABLE
848: , p3_a16 out nocopy JTF_NUMBER_TABLE
849: , p3_a17 out nocopy JTF_NUMBER_TABLE
850: , p3_a18 out nocopy JTF_NUMBER_TABLE
851: , p3_a19 out nocopy JTF_NUMBER_TABLE
852: , p3_a20 out nocopy JTF_NUMBER_TABLE
853: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
854: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
855: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
848: , p3_a16 out nocopy JTF_NUMBER_TABLE
849: , p3_a17 out nocopy JTF_NUMBER_TABLE
850: , p3_a18 out nocopy JTF_NUMBER_TABLE
851: , p3_a19 out nocopy JTF_NUMBER_TABLE
852: , p3_a20 out nocopy JTF_NUMBER_TABLE
853: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
854: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
855: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
856: , p3_a24 out nocopy JTF_NUMBER_TABLE
852: , p3_a20 out nocopy JTF_NUMBER_TABLE
853: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
854: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
855: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
856: , p3_a24 out nocopy JTF_NUMBER_TABLE
857: , p3_a25 out nocopy JTF_NUMBER_TABLE
858: , p3_a26 out nocopy JTF_NUMBER_TABLE
859: , p3_a27 out nocopy JTF_NUMBER_TABLE
860: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
853: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
854: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
855: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
856: , p3_a24 out nocopy JTF_NUMBER_TABLE
857: , p3_a25 out nocopy JTF_NUMBER_TABLE
858: , p3_a26 out nocopy JTF_NUMBER_TABLE
859: , p3_a27 out nocopy JTF_NUMBER_TABLE
860: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
861: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
854: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
855: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
856: , p3_a24 out nocopy JTF_NUMBER_TABLE
857: , p3_a25 out nocopy JTF_NUMBER_TABLE
858: , p3_a26 out nocopy JTF_NUMBER_TABLE
859: , p3_a27 out nocopy JTF_NUMBER_TABLE
860: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
861: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
862: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
855: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
856: , p3_a24 out nocopy JTF_NUMBER_TABLE
857: , p3_a25 out nocopy JTF_NUMBER_TABLE
858: , p3_a26 out nocopy JTF_NUMBER_TABLE
859: , p3_a27 out nocopy JTF_NUMBER_TABLE
860: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
861: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
862: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
863: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
860: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
861: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
862: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
863: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
864: , p3_a32 out nocopy JTF_NUMBER_TABLE
865: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
866: , p3_a34 out nocopy JTF_NUMBER_TABLE
867: , p3_a35 out nocopy JTF_NUMBER_TABLE
868: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
862: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
863: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
864: , p3_a32 out nocopy JTF_NUMBER_TABLE
865: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
866: , p3_a34 out nocopy JTF_NUMBER_TABLE
867: , p3_a35 out nocopy JTF_NUMBER_TABLE
868: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
869: , p3_a37 out nocopy JTF_NUMBER_TABLE
870: , p3_a38 out nocopy JTF_NUMBER_TABLE
863: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
864: , p3_a32 out nocopy JTF_NUMBER_TABLE
865: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
866: , p3_a34 out nocopy JTF_NUMBER_TABLE
867: , p3_a35 out nocopy JTF_NUMBER_TABLE
868: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
869: , p3_a37 out nocopy JTF_NUMBER_TABLE
870: , p3_a38 out nocopy JTF_NUMBER_TABLE
871: , p3_a39 out nocopy JTF_NUMBER_TABLE
865: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
866: , p3_a34 out nocopy JTF_NUMBER_TABLE
867: , p3_a35 out nocopy JTF_NUMBER_TABLE
868: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
869: , p3_a37 out nocopy JTF_NUMBER_TABLE
870: , p3_a38 out nocopy JTF_NUMBER_TABLE
871: , p3_a39 out nocopy JTF_NUMBER_TABLE
872: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
873: , p3_a41 out nocopy JTF_NUMBER_TABLE
866: , p3_a34 out nocopy JTF_NUMBER_TABLE
867: , p3_a35 out nocopy JTF_NUMBER_TABLE
868: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
869: , p3_a37 out nocopy JTF_NUMBER_TABLE
870: , p3_a38 out nocopy JTF_NUMBER_TABLE
871: , p3_a39 out nocopy JTF_NUMBER_TABLE
872: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
873: , p3_a41 out nocopy JTF_NUMBER_TABLE
874: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
867: , p3_a35 out nocopy JTF_NUMBER_TABLE
868: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
869: , p3_a37 out nocopy JTF_NUMBER_TABLE
870: , p3_a38 out nocopy JTF_NUMBER_TABLE
871: , p3_a39 out nocopy JTF_NUMBER_TABLE
872: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
873: , p3_a41 out nocopy JTF_NUMBER_TABLE
874: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
875: );
869: , p3_a37 out nocopy JTF_NUMBER_TABLE
870: , p3_a38 out nocopy JTF_NUMBER_TABLE
871: , p3_a39 out nocopy JTF_NUMBER_TABLE
872: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
873: , p3_a41 out nocopy JTF_NUMBER_TABLE
874: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
875: );
876: procedure loanprojection(p0_a0 NUMBER
877: , p0_a1 NUMBER
969: , p0_a93 VARCHAR2
970: , p0_a94 VARCHAR2
971: , p0_a95 VARCHAR2
972: , p_based_on_terms VARCHAR2
973: , p2_a0 JTF_NUMBER_TABLE
974: , p2_a1 JTF_DATE_TABLE
975: , p2_a2 JTF_DATE_TABLE
976: , p2_a3 JTF_NUMBER_TABLE
977: , p2_a4 JTF_NUMBER_TABLE
972: , p_based_on_terms VARCHAR2
973: , p2_a0 JTF_NUMBER_TABLE
974: , p2_a1 JTF_DATE_TABLE
975: , p2_a2 JTF_DATE_TABLE
976: , p2_a3 JTF_NUMBER_TABLE
977: , p2_a4 JTF_NUMBER_TABLE
978: , p2_a5 JTF_NUMBER_TABLE
979: , p2_a6 JTF_NUMBER_TABLE
980: , p2_a7 JTF_VARCHAR2_TABLE_100
973: , p2_a0 JTF_NUMBER_TABLE
974: , p2_a1 JTF_DATE_TABLE
975: , p2_a2 JTF_DATE_TABLE
976: , p2_a3 JTF_NUMBER_TABLE
977: , p2_a4 JTF_NUMBER_TABLE
978: , p2_a5 JTF_NUMBER_TABLE
979: , p2_a6 JTF_NUMBER_TABLE
980: , p2_a7 JTF_VARCHAR2_TABLE_100
981: , p2_a8 JTF_VARCHAR2_TABLE_100
974: , p2_a1 JTF_DATE_TABLE
975: , p2_a2 JTF_DATE_TABLE
976: , p2_a3 JTF_NUMBER_TABLE
977: , p2_a4 JTF_NUMBER_TABLE
978: , p2_a5 JTF_NUMBER_TABLE
979: , p2_a6 JTF_NUMBER_TABLE
980: , p2_a7 JTF_VARCHAR2_TABLE_100
981: , p2_a8 JTF_VARCHAR2_TABLE_100
982: , p2_a9 JTF_VARCHAR2_TABLE_100
975: , p2_a2 JTF_DATE_TABLE
976: , p2_a3 JTF_NUMBER_TABLE
977: , p2_a4 JTF_NUMBER_TABLE
978: , p2_a5 JTF_NUMBER_TABLE
979: , p2_a6 JTF_NUMBER_TABLE
980: , p2_a7 JTF_VARCHAR2_TABLE_100
981: , p2_a8 JTF_VARCHAR2_TABLE_100
982: , p2_a9 JTF_VARCHAR2_TABLE_100
983: , p3_a0 out nocopy JTF_NUMBER_TABLE
979: , p2_a6 JTF_NUMBER_TABLE
980: , p2_a7 JTF_VARCHAR2_TABLE_100
981: , p2_a8 JTF_VARCHAR2_TABLE_100
982: , p2_a9 JTF_VARCHAR2_TABLE_100
983: , p3_a0 out nocopy JTF_NUMBER_TABLE
984: , p3_a1 out nocopy JTF_DATE_TABLE
985: , p3_a2 out nocopy JTF_DATE_TABLE
986: , p3_a3 out nocopy JTF_DATE_TABLE
987: , p3_a4 out nocopy JTF_NUMBER_TABLE
983: , p3_a0 out nocopy JTF_NUMBER_TABLE
984: , p3_a1 out nocopy JTF_DATE_TABLE
985: , p3_a2 out nocopy JTF_DATE_TABLE
986: , p3_a3 out nocopy JTF_DATE_TABLE
987: , p3_a4 out nocopy JTF_NUMBER_TABLE
988: , p3_a5 out nocopy JTF_NUMBER_TABLE
989: , p3_a6 out nocopy JTF_NUMBER_TABLE
990: , p3_a7 out nocopy JTF_NUMBER_TABLE
991: , p3_a8 out nocopy JTF_NUMBER_TABLE
984: , p3_a1 out nocopy JTF_DATE_TABLE
985: , p3_a2 out nocopy JTF_DATE_TABLE
986: , p3_a3 out nocopy JTF_DATE_TABLE
987: , p3_a4 out nocopy JTF_NUMBER_TABLE
988: , p3_a5 out nocopy JTF_NUMBER_TABLE
989: , p3_a6 out nocopy JTF_NUMBER_TABLE
990: , p3_a7 out nocopy JTF_NUMBER_TABLE
991: , p3_a8 out nocopy JTF_NUMBER_TABLE
992: , p3_a9 out nocopy JTF_NUMBER_TABLE
985: , p3_a2 out nocopy JTF_DATE_TABLE
986: , p3_a3 out nocopy JTF_DATE_TABLE
987: , p3_a4 out nocopy JTF_NUMBER_TABLE
988: , p3_a5 out nocopy JTF_NUMBER_TABLE
989: , p3_a6 out nocopy JTF_NUMBER_TABLE
990: , p3_a7 out nocopy JTF_NUMBER_TABLE
991: , p3_a8 out nocopy JTF_NUMBER_TABLE
992: , p3_a9 out nocopy JTF_NUMBER_TABLE
993: , p3_a10 out nocopy JTF_NUMBER_TABLE
986: , p3_a3 out nocopy JTF_DATE_TABLE
987: , p3_a4 out nocopy JTF_NUMBER_TABLE
988: , p3_a5 out nocopy JTF_NUMBER_TABLE
989: , p3_a6 out nocopy JTF_NUMBER_TABLE
990: , p3_a7 out nocopy JTF_NUMBER_TABLE
991: , p3_a8 out nocopy JTF_NUMBER_TABLE
992: , p3_a9 out nocopy JTF_NUMBER_TABLE
993: , p3_a10 out nocopy JTF_NUMBER_TABLE
994: , p3_a11 out nocopy JTF_NUMBER_TABLE
987: , p3_a4 out nocopy JTF_NUMBER_TABLE
988: , p3_a5 out nocopy JTF_NUMBER_TABLE
989: , p3_a6 out nocopy JTF_NUMBER_TABLE
990: , p3_a7 out nocopy JTF_NUMBER_TABLE
991: , p3_a8 out nocopy JTF_NUMBER_TABLE
992: , p3_a9 out nocopy JTF_NUMBER_TABLE
993: , p3_a10 out nocopy JTF_NUMBER_TABLE
994: , p3_a11 out nocopy JTF_NUMBER_TABLE
995: , p3_a12 out nocopy JTF_NUMBER_TABLE
988: , p3_a5 out nocopy JTF_NUMBER_TABLE
989: , p3_a6 out nocopy JTF_NUMBER_TABLE
990: , p3_a7 out nocopy JTF_NUMBER_TABLE
991: , p3_a8 out nocopy JTF_NUMBER_TABLE
992: , p3_a9 out nocopy JTF_NUMBER_TABLE
993: , p3_a10 out nocopy JTF_NUMBER_TABLE
994: , p3_a11 out nocopy JTF_NUMBER_TABLE
995: , p3_a12 out nocopy JTF_NUMBER_TABLE
996: , p3_a13 out nocopy JTF_NUMBER_TABLE
989: , p3_a6 out nocopy JTF_NUMBER_TABLE
990: , p3_a7 out nocopy JTF_NUMBER_TABLE
991: , p3_a8 out nocopy JTF_NUMBER_TABLE
992: , p3_a9 out nocopy JTF_NUMBER_TABLE
993: , p3_a10 out nocopy JTF_NUMBER_TABLE
994: , p3_a11 out nocopy JTF_NUMBER_TABLE
995: , p3_a12 out nocopy JTF_NUMBER_TABLE
996: , p3_a13 out nocopy JTF_NUMBER_TABLE
997: , p3_a14 out nocopy JTF_NUMBER_TABLE
990: , p3_a7 out nocopy JTF_NUMBER_TABLE
991: , p3_a8 out nocopy JTF_NUMBER_TABLE
992: , p3_a9 out nocopy JTF_NUMBER_TABLE
993: , p3_a10 out nocopy JTF_NUMBER_TABLE
994: , p3_a11 out nocopy JTF_NUMBER_TABLE
995: , p3_a12 out nocopy JTF_NUMBER_TABLE
996: , p3_a13 out nocopy JTF_NUMBER_TABLE
997: , p3_a14 out nocopy JTF_NUMBER_TABLE
998: , p3_a15 out nocopy JTF_NUMBER_TABLE
991: , p3_a8 out nocopy JTF_NUMBER_TABLE
992: , p3_a9 out nocopy JTF_NUMBER_TABLE
993: , p3_a10 out nocopy JTF_NUMBER_TABLE
994: , p3_a11 out nocopy JTF_NUMBER_TABLE
995: , p3_a12 out nocopy JTF_NUMBER_TABLE
996: , p3_a13 out nocopy JTF_NUMBER_TABLE
997: , p3_a14 out nocopy JTF_NUMBER_TABLE
998: , p3_a15 out nocopy JTF_NUMBER_TABLE
999: , p3_a16 out nocopy JTF_NUMBER_TABLE
992: , p3_a9 out nocopy JTF_NUMBER_TABLE
993: , p3_a10 out nocopy JTF_NUMBER_TABLE
994: , p3_a11 out nocopy JTF_NUMBER_TABLE
995: , p3_a12 out nocopy JTF_NUMBER_TABLE
996: , p3_a13 out nocopy JTF_NUMBER_TABLE
997: , p3_a14 out nocopy JTF_NUMBER_TABLE
998: , p3_a15 out nocopy JTF_NUMBER_TABLE
999: , p3_a16 out nocopy JTF_NUMBER_TABLE
1000: , p3_a17 out nocopy JTF_NUMBER_TABLE
993: , p3_a10 out nocopy JTF_NUMBER_TABLE
994: , p3_a11 out nocopy JTF_NUMBER_TABLE
995: , p3_a12 out nocopy JTF_NUMBER_TABLE
996: , p3_a13 out nocopy JTF_NUMBER_TABLE
997: , p3_a14 out nocopy JTF_NUMBER_TABLE
998: , p3_a15 out nocopy JTF_NUMBER_TABLE
999: , p3_a16 out nocopy JTF_NUMBER_TABLE
1000: , p3_a17 out nocopy JTF_NUMBER_TABLE
1001: , p3_a18 out nocopy JTF_NUMBER_TABLE
994: , p3_a11 out nocopy JTF_NUMBER_TABLE
995: , p3_a12 out nocopy JTF_NUMBER_TABLE
996: , p3_a13 out nocopy JTF_NUMBER_TABLE
997: , p3_a14 out nocopy JTF_NUMBER_TABLE
998: , p3_a15 out nocopy JTF_NUMBER_TABLE
999: , p3_a16 out nocopy JTF_NUMBER_TABLE
1000: , p3_a17 out nocopy JTF_NUMBER_TABLE
1001: , p3_a18 out nocopy JTF_NUMBER_TABLE
1002: , p3_a19 out nocopy JTF_NUMBER_TABLE
995: , p3_a12 out nocopy JTF_NUMBER_TABLE
996: , p3_a13 out nocopy JTF_NUMBER_TABLE
997: , p3_a14 out nocopy JTF_NUMBER_TABLE
998: , p3_a15 out nocopy JTF_NUMBER_TABLE
999: , p3_a16 out nocopy JTF_NUMBER_TABLE
1000: , p3_a17 out nocopy JTF_NUMBER_TABLE
1001: , p3_a18 out nocopy JTF_NUMBER_TABLE
1002: , p3_a19 out nocopy JTF_NUMBER_TABLE
1003: , p3_a20 out nocopy JTF_NUMBER_TABLE
996: , p3_a13 out nocopy JTF_NUMBER_TABLE
997: , p3_a14 out nocopy JTF_NUMBER_TABLE
998: , p3_a15 out nocopy JTF_NUMBER_TABLE
999: , p3_a16 out nocopy JTF_NUMBER_TABLE
1000: , p3_a17 out nocopy JTF_NUMBER_TABLE
1001: , p3_a18 out nocopy JTF_NUMBER_TABLE
1002: , p3_a19 out nocopy JTF_NUMBER_TABLE
1003: , p3_a20 out nocopy JTF_NUMBER_TABLE
1004: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
997: , p3_a14 out nocopy JTF_NUMBER_TABLE
998: , p3_a15 out nocopy JTF_NUMBER_TABLE
999: , p3_a16 out nocopy JTF_NUMBER_TABLE
1000: , p3_a17 out nocopy JTF_NUMBER_TABLE
1001: , p3_a18 out nocopy JTF_NUMBER_TABLE
1002: , p3_a19 out nocopy JTF_NUMBER_TABLE
1003: , p3_a20 out nocopy JTF_NUMBER_TABLE
1004: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1005: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
998: , p3_a15 out nocopy JTF_NUMBER_TABLE
999: , p3_a16 out nocopy JTF_NUMBER_TABLE
1000: , p3_a17 out nocopy JTF_NUMBER_TABLE
1001: , p3_a18 out nocopy JTF_NUMBER_TABLE
1002: , p3_a19 out nocopy JTF_NUMBER_TABLE
1003: , p3_a20 out nocopy JTF_NUMBER_TABLE
1004: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1005: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1006: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
999: , p3_a16 out nocopy JTF_NUMBER_TABLE
1000: , p3_a17 out nocopy JTF_NUMBER_TABLE
1001: , p3_a18 out nocopy JTF_NUMBER_TABLE
1002: , p3_a19 out nocopy JTF_NUMBER_TABLE
1003: , p3_a20 out nocopy JTF_NUMBER_TABLE
1004: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1005: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1006: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1007: , p3_a24 out nocopy JTF_NUMBER_TABLE
1003: , p3_a20 out nocopy JTF_NUMBER_TABLE
1004: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1005: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1006: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1007: , p3_a24 out nocopy JTF_NUMBER_TABLE
1008: , p3_a25 out nocopy JTF_NUMBER_TABLE
1009: , p3_a26 out nocopy JTF_NUMBER_TABLE
1010: , p3_a27 out nocopy JTF_NUMBER_TABLE
1011: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1004: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1005: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1006: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1007: , p3_a24 out nocopy JTF_NUMBER_TABLE
1008: , p3_a25 out nocopy JTF_NUMBER_TABLE
1009: , p3_a26 out nocopy JTF_NUMBER_TABLE
1010: , p3_a27 out nocopy JTF_NUMBER_TABLE
1011: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1012: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1005: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1006: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1007: , p3_a24 out nocopy JTF_NUMBER_TABLE
1008: , p3_a25 out nocopy JTF_NUMBER_TABLE
1009: , p3_a26 out nocopy JTF_NUMBER_TABLE
1010: , p3_a27 out nocopy JTF_NUMBER_TABLE
1011: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1012: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1013: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1006: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1007: , p3_a24 out nocopy JTF_NUMBER_TABLE
1008: , p3_a25 out nocopy JTF_NUMBER_TABLE
1009: , p3_a26 out nocopy JTF_NUMBER_TABLE
1010: , p3_a27 out nocopy JTF_NUMBER_TABLE
1011: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1012: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1013: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1014: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1011: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1012: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1013: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1014: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1015: , p3_a32 out nocopy JTF_NUMBER_TABLE
1016: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
1017: , p3_a34 out nocopy JTF_NUMBER_TABLE
1018: , p3_a35 out nocopy JTF_NUMBER_TABLE
1019: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1013: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1014: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1015: , p3_a32 out nocopy JTF_NUMBER_TABLE
1016: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
1017: , p3_a34 out nocopy JTF_NUMBER_TABLE
1018: , p3_a35 out nocopy JTF_NUMBER_TABLE
1019: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1020: , p3_a37 out nocopy JTF_NUMBER_TABLE
1021: , p3_a38 out nocopy JTF_NUMBER_TABLE
1014: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1015: , p3_a32 out nocopy JTF_NUMBER_TABLE
1016: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
1017: , p3_a34 out nocopy JTF_NUMBER_TABLE
1018: , p3_a35 out nocopy JTF_NUMBER_TABLE
1019: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1020: , p3_a37 out nocopy JTF_NUMBER_TABLE
1021: , p3_a38 out nocopy JTF_NUMBER_TABLE
1022: , p3_a39 out nocopy JTF_NUMBER_TABLE
1016: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
1017: , p3_a34 out nocopy JTF_NUMBER_TABLE
1018: , p3_a35 out nocopy JTF_NUMBER_TABLE
1019: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1020: , p3_a37 out nocopy JTF_NUMBER_TABLE
1021: , p3_a38 out nocopy JTF_NUMBER_TABLE
1022: , p3_a39 out nocopy JTF_NUMBER_TABLE
1023: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1024: , p3_a41 out nocopy JTF_NUMBER_TABLE
1017: , p3_a34 out nocopy JTF_NUMBER_TABLE
1018: , p3_a35 out nocopy JTF_NUMBER_TABLE
1019: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1020: , p3_a37 out nocopy JTF_NUMBER_TABLE
1021: , p3_a38 out nocopy JTF_NUMBER_TABLE
1022: , p3_a39 out nocopy JTF_NUMBER_TABLE
1023: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1024: , p3_a41 out nocopy JTF_NUMBER_TABLE
1025: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
1018: , p3_a35 out nocopy JTF_NUMBER_TABLE
1019: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1020: , p3_a37 out nocopy JTF_NUMBER_TABLE
1021: , p3_a38 out nocopy JTF_NUMBER_TABLE
1022: , p3_a39 out nocopy JTF_NUMBER_TABLE
1023: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1024: , p3_a41 out nocopy JTF_NUMBER_TABLE
1025: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
1026: );
1020: , p3_a37 out nocopy JTF_NUMBER_TABLE
1021: , p3_a38 out nocopy JTF_NUMBER_TABLE
1022: , p3_a39 out nocopy JTF_NUMBER_TABLE
1023: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1024: , p3_a41 out nocopy JTF_NUMBER_TABLE
1025: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
1026: );
1027: procedure runopenprojection(p_init_msg_list VARCHAR2
1028: , p_loan_id NUMBER
1026: );
1027: procedure runopenprojection(p_init_msg_list VARCHAR2
1028: , p_loan_id NUMBER
1029: , p_based_on_terms VARCHAR2
1030: , p3_a0 out nocopy JTF_NUMBER_TABLE
1031: , p3_a1 out nocopy JTF_DATE_TABLE
1032: , p3_a2 out nocopy JTF_DATE_TABLE
1033: , p3_a3 out nocopy JTF_DATE_TABLE
1034: , p3_a4 out nocopy JTF_NUMBER_TABLE
1030: , p3_a0 out nocopy JTF_NUMBER_TABLE
1031: , p3_a1 out nocopy JTF_DATE_TABLE
1032: , p3_a2 out nocopy JTF_DATE_TABLE
1033: , p3_a3 out nocopy JTF_DATE_TABLE
1034: , p3_a4 out nocopy JTF_NUMBER_TABLE
1035: , p3_a5 out nocopy JTF_NUMBER_TABLE
1036: , p3_a6 out nocopy JTF_NUMBER_TABLE
1037: , p3_a7 out nocopy JTF_NUMBER_TABLE
1038: , p3_a8 out nocopy JTF_NUMBER_TABLE
1031: , p3_a1 out nocopy JTF_DATE_TABLE
1032: , p3_a2 out nocopy JTF_DATE_TABLE
1033: , p3_a3 out nocopy JTF_DATE_TABLE
1034: , p3_a4 out nocopy JTF_NUMBER_TABLE
1035: , p3_a5 out nocopy JTF_NUMBER_TABLE
1036: , p3_a6 out nocopy JTF_NUMBER_TABLE
1037: , p3_a7 out nocopy JTF_NUMBER_TABLE
1038: , p3_a8 out nocopy JTF_NUMBER_TABLE
1039: , p3_a9 out nocopy JTF_NUMBER_TABLE
1032: , p3_a2 out nocopy JTF_DATE_TABLE
1033: , p3_a3 out nocopy JTF_DATE_TABLE
1034: , p3_a4 out nocopy JTF_NUMBER_TABLE
1035: , p3_a5 out nocopy JTF_NUMBER_TABLE
1036: , p3_a6 out nocopy JTF_NUMBER_TABLE
1037: , p3_a7 out nocopy JTF_NUMBER_TABLE
1038: , p3_a8 out nocopy JTF_NUMBER_TABLE
1039: , p3_a9 out nocopy JTF_NUMBER_TABLE
1040: , p3_a10 out nocopy JTF_NUMBER_TABLE
1033: , p3_a3 out nocopy JTF_DATE_TABLE
1034: , p3_a4 out nocopy JTF_NUMBER_TABLE
1035: , p3_a5 out nocopy JTF_NUMBER_TABLE
1036: , p3_a6 out nocopy JTF_NUMBER_TABLE
1037: , p3_a7 out nocopy JTF_NUMBER_TABLE
1038: , p3_a8 out nocopy JTF_NUMBER_TABLE
1039: , p3_a9 out nocopy JTF_NUMBER_TABLE
1040: , p3_a10 out nocopy JTF_NUMBER_TABLE
1041: , p3_a11 out nocopy JTF_NUMBER_TABLE
1034: , p3_a4 out nocopy JTF_NUMBER_TABLE
1035: , p3_a5 out nocopy JTF_NUMBER_TABLE
1036: , p3_a6 out nocopy JTF_NUMBER_TABLE
1037: , p3_a7 out nocopy JTF_NUMBER_TABLE
1038: , p3_a8 out nocopy JTF_NUMBER_TABLE
1039: , p3_a9 out nocopy JTF_NUMBER_TABLE
1040: , p3_a10 out nocopy JTF_NUMBER_TABLE
1041: , p3_a11 out nocopy JTF_NUMBER_TABLE
1042: , p3_a12 out nocopy JTF_NUMBER_TABLE
1035: , p3_a5 out nocopy JTF_NUMBER_TABLE
1036: , p3_a6 out nocopy JTF_NUMBER_TABLE
1037: , p3_a7 out nocopy JTF_NUMBER_TABLE
1038: , p3_a8 out nocopy JTF_NUMBER_TABLE
1039: , p3_a9 out nocopy JTF_NUMBER_TABLE
1040: , p3_a10 out nocopy JTF_NUMBER_TABLE
1041: , p3_a11 out nocopy JTF_NUMBER_TABLE
1042: , p3_a12 out nocopy JTF_NUMBER_TABLE
1043: , p3_a13 out nocopy JTF_NUMBER_TABLE
1036: , p3_a6 out nocopy JTF_NUMBER_TABLE
1037: , p3_a7 out nocopy JTF_NUMBER_TABLE
1038: , p3_a8 out nocopy JTF_NUMBER_TABLE
1039: , p3_a9 out nocopy JTF_NUMBER_TABLE
1040: , p3_a10 out nocopy JTF_NUMBER_TABLE
1041: , p3_a11 out nocopy JTF_NUMBER_TABLE
1042: , p3_a12 out nocopy JTF_NUMBER_TABLE
1043: , p3_a13 out nocopy JTF_NUMBER_TABLE
1044: , p3_a14 out nocopy JTF_NUMBER_TABLE
1037: , p3_a7 out nocopy JTF_NUMBER_TABLE
1038: , p3_a8 out nocopy JTF_NUMBER_TABLE
1039: , p3_a9 out nocopy JTF_NUMBER_TABLE
1040: , p3_a10 out nocopy JTF_NUMBER_TABLE
1041: , p3_a11 out nocopy JTF_NUMBER_TABLE
1042: , p3_a12 out nocopy JTF_NUMBER_TABLE
1043: , p3_a13 out nocopy JTF_NUMBER_TABLE
1044: , p3_a14 out nocopy JTF_NUMBER_TABLE
1045: , p3_a15 out nocopy JTF_NUMBER_TABLE
1038: , p3_a8 out nocopy JTF_NUMBER_TABLE
1039: , p3_a9 out nocopy JTF_NUMBER_TABLE
1040: , p3_a10 out nocopy JTF_NUMBER_TABLE
1041: , p3_a11 out nocopy JTF_NUMBER_TABLE
1042: , p3_a12 out nocopy JTF_NUMBER_TABLE
1043: , p3_a13 out nocopy JTF_NUMBER_TABLE
1044: , p3_a14 out nocopy JTF_NUMBER_TABLE
1045: , p3_a15 out nocopy JTF_NUMBER_TABLE
1046: , p3_a16 out nocopy JTF_NUMBER_TABLE
1039: , p3_a9 out nocopy JTF_NUMBER_TABLE
1040: , p3_a10 out nocopy JTF_NUMBER_TABLE
1041: , p3_a11 out nocopy JTF_NUMBER_TABLE
1042: , p3_a12 out nocopy JTF_NUMBER_TABLE
1043: , p3_a13 out nocopy JTF_NUMBER_TABLE
1044: , p3_a14 out nocopy JTF_NUMBER_TABLE
1045: , p3_a15 out nocopy JTF_NUMBER_TABLE
1046: , p3_a16 out nocopy JTF_NUMBER_TABLE
1047: , p3_a17 out nocopy JTF_NUMBER_TABLE
1040: , p3_a10 out nocopy JTF_NUMBER_TABLE
1041: , p3_a11 out nocopy JTF_NUMBER_TABLE
1042: , p3_a12 out nocopy JTF_NUMBER_TABLE
1043: , p3_a13 out nocopy JTF_NUMBER_TABLE
1044: , p3_a14 out nocopy JTF_NUMBER_TABLE
1045: , p3_a15 out nocopy JTF_NUMBER_TABLE
1046: , p3_a16 out nocopy JTF_NUMBER_TABLE
1047: , p3_a17 out nocopy JTF_NUMBER_TABLE
1048: , p3_a18 out nocopy JTF_NUMBER_TABLE
1041: , p3_a11 out nocopy JTF_NUMBER_TABLE
1042: , p3_a12 out nocopy JTF_NUMBER_TABLE
1043: , p3_a13 out nocopy JTF_NUMBER_TABLE
1044: , p3_a14 out nocopy JTF_NUMBER_TABLE
1045: , p3_a15 out nocopy JTF_NUMBER_TABLE
1046: , p3_a16 out nocopy JTF_NUMBER_TABLE
1047: , p3_a17 out nocopy JTF_NUMBER_TABLE
1048: , p3_a18 out nocopy JTF_NUMBER_TABLE
1049: , p3_a19 out nocopy JTF_NUMBER_TABLE
1042: , p3_a12 out nocopy JTF_NUMBER_TABLE
1043: , p3_a13 out nocopy JTF_NUMBER_TABLE
1044: , p3_a14 out nocopy JTF_NUMBER_TABLE
1045: , p3_a15 out nocopy JTF_NUMBER_TABLE
1046: , p3_a16 out nocopy JTF_NUMBER_TABLE
1047: , p3_a17 out nocopy JTF_NUMBER_TABLE
1048: , p3_a18 out nocopy JTF_NUMBER_TABLE
1049: , p3_a19 out nocopy JTF_NUMBER_TABLE
1050: , p3_a20 out nocopy JTF_NUMBER_TABLE
1043: , p3_a13 out nocopy JTF_NUMBER_TABLE
1044: , p3_a14 out nocopy JTF_NUMBER_TABLE
1045: , p3_a15 out nocopy JTF_NUMBER_TABLE
1046: , p3_a16 out nocopy JTF_NUMBER_TABLE
1047: , p3_a17 out nocopy JTF_NUMBER_TABLE
1048: , p3_a18 out nocopy JTF_NUMBER_TABLE
1049: , p3_a19 out nocopy JTF_NUMBER_TABLE
1050: , p3_a20 out nocopy JTF_NUMBER_TABLE
1051: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1044: , p3_a14 out nocopy JTF_NUMBER_TABLE
1045: , p3_a15 out nocopy JTF_NUMBER_TABLE
1046: , p3_a16 out nocopy JTF_NUMBER_TABLE
1047: , p3_a17 out nocopy JTF_NUMBER_TABLE
1048: , p3_a18 out nocopy JTF_NUMBER_TABLE
1049: , p3_a19 out nocopy JTF_NUMBER_TABLE
1050: , p3_a20 out nocopy JTF_NUMBER_TABLE
1051: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1052: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1045: , p3_a15 out nocopy JTF_NUMBER_TABLE
1046: , p3_a16 out nocopy JTF_NUMBER_TABLE
1047: , p3_a17 out nocopy JTF_NUMBER_TABLE
1048: , p3_a18 out nocopy JTF_NUMBER_TABLE
1049: , p3_a19 out nocopy JTF_NUMBER_TABLE
1050: , p3_a20 out nocopy JTF_NUMBER_TABLE
1051: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1052: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1053: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1046: , p3_a16 out nocopy JTF_NUMBER_TABLE
1047: , p3_a17 out nocopy JTF_NUMBER_TABLE
1048: , p3_a18 out nocopy JTF_NUMBER_TABLE
1049: , p3_a19 out nocopy JTF_NUMBER_TABLE
1050: , p3_a20 out nocopy JTF_NUMBER_TABLE
1051: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1052: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1053: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1054: , p3_a24 out nocopy JTF_NUMBER_TABLE
1050: , p3_a20 out nocopy JTF_NUMBER_TABLE
1051: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1052: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1053: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1054: , p3_a24 out nocopy JTF_NUMBER_TABLE
1055: , p3_a25 out nocopy JTF_NUMBER_TABLE
1056: , p3_a26 out nocopy JTF_NUMBER_TABLE
1057: , p3_a27 out nocopy JTF_NUMBER_TABLE
1058: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1051: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1052: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1053: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1054: , p3_a24 out nocopy JTF_NUMBER_TABLE
1055: , p3_a25 out nocopy JTF_NUMBER_TABLE
1056: , p3_a26 out nocopy JTF_NUMBER_TABLE
1057: , p3_a27 out nocopy JTF_NUMBER_TABLE
1058: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1059: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1052: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1053: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1054: , p3_a24 out nocopy JTF_NUMBER_TABLE
1055: , p3_a25 out nocopy JTF_NUMBER_TABLE
1056: , p3_a26 out nocopy JTF_NUMBER_TABLE
1057: , p3_a27 out nocopy JTF_NUMBER_TABLE
1058: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1059: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1060: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1053: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1054: , p3_a24 out nocopy JTF_NUMBER_TABLE
1055: , p3_a25 out nocopy JTF_NUMBER_TABLE
1056: , p3_a26 out nocopy JTF_NUMBER_TABLE
1057: , p3_a27 out nocopy JTF_NUMBER_TABLE
1058: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1059: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1060: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1061: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1058: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1059: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1060: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1061: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1062: , p3_a32 out nocopy JTF_NUMBER_TABLE
1063: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
1064: , p3_a34 out nocopy JTF_NUMBER_TABLE
1065: , p3_a35 out nocopy JTF_NUMBER_TABLE
1066: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1060: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1061: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1062: , p3_a32 out nocopy JTF_NUMBER_TABLE
1063: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
1064: , p3_a34 out nocopy JTF_NUMBER_TABLE
1065: , p3_a35 out nocopy JTF_NUMBER_TABLE
1066: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1067: , p3_a37 out nocopy JTF_NUMBER_TABLE
1068: , p3_a38 out nocopy JTF_NUMBER_TABLE
1061: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1062: , p3_a32 out nocopy JTF_NUMBER_TABLE
1063: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
1064: , p3_a34 out nocopy JTF_NUMBER_TABLE
1065: , p3_a35 out nocopy JTF_NUMBER_TABLE
1066: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1067: , p3_a37 out nocopy JTF_NUMBER_TABLE
1068: , p3_a38 out nocopy JTF_NUMBER_TABLE
1069: , p3_a39 out nocopy JTF_NUMBER_TABLE
1063: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
1064: , p3_a34 out nocopy JTF_NUMBER_TABLE
1065: , p3_a35 out nocopy JTF_NUMBER_TABLE
1066: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1067: , p3_a37 out nocopy JTF_NUMBER_TABLE
1068: , p3_a38 out nocopy JTF_NUMBER_TABLE
1069: , p3_a39 out nocopy JTF_NUMBER_TABLE
1070: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1071: , p3_a41 out nocopy JTF_NUMBER_TABLE
1064: , p3_a34 out nocopy JTF_NUMBER_TABLE
1065: , p3_a35 out nocopy JTF_NUMBER_TABLE
1066: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1067: , p3_a37 out nocopy JTF_NUMBER_TABLE
1068: , p3_a38 out nocopy JTF_NUMBER_TABLE
1069: , p3_a39 out nocopy JTF_NUMBER_TABLE
1070: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1071: , p3_a41 out nocopy JTF_NUMBER_TABLE
1072: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
1065: , p3_a35 out nocopy JTF_NUMBER_TABLE
1066: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1067: , p3_a37 out nocopy JTF_NUMBER_TABLE
1068: , p3_a38 out nocopy JTF_NUMBER_TABLE
1069: , p3_a39 out nocopy JTF_NUMBER_TABLE
1070: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1071: , p3_a41 out nocopy JTF_NUMBER_TABLE
1072: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
1073: , x_return_status out nocopy VARCHAR2
1067: , p3_a37 out nocopy JTF_NUMBER_TABLE
1068: , p3_a38 out nocopy JTF_NUMBER_TABLE
1069: , p3_a39 out nocopy JTF_NUMBER_TABLE
1070: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1071: , p3_a41 out nocopy JTF_NUMBER_TABLE
1072: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
1073: , x_return_status out nocopy VARCHAR2
1074: , x_msg_count out nocopy NUMBER
1075: , x_msg_data out nocopy VARCHAR2
1078: , p_init_msg_list VARCHAR2
1079: , p_commit VARCHAR2
1080: , p_loan_id NUMBER
1081: , p_based_on_terms VARCHAR2
1082: , p5_a0 out nocopy JTF_NUMBER_TABLE
1083: , p5_a1 out nocopy JTF_DATE_TABLE
1084: , p5_a2 out nocopy JTF_DATE_TABLE
1085: , p5_a3 out nocopy JTF_DATE_TABLE
1086: , p5_a4 out nocopy JTF_NUMBER_TABLE
1082: , p5_a0 out nocopy JTF_NUMBER_TABLE
1083: , p5_a1 out nocopy JTF_DATE_TABLE
1084: , p5_a2 out nocopy JTF_DATE_TABLE
1085: , p5_a3 out nocopy JTF_DATE_TABLE
1086: , p5_a4 out nocopy JTF_NUMBER_TABLE
1087: , p5_a5 out nocopy JTF_NUMBER_TABLE
1088: , p5_a6 out nocopy JTF_NUMBER_TABLE
1089: , p5_a7 out nocopy JTF_NUMBER_TABLE
1090: , p5_a8 out nocopy JTF_NUMBER_TABLE
1083: , p5_a1 out nocopy JTF_DATE_TABLE
1084: , p5_a2 out nocopy JTF_DATE_TABLE
1085: , p5_a3 out nocopy JTF_DATE_TABLE
1086: , p5_a4 out nocopy JTF_NUMBER_TABLE
1087: , p5_a5 out nocopy JTF_NUMBER_TABLE
1088: , p5_a6 out nocopy JTF_NUMBER_TABLE
1089: , p5_a7 out nocopy JTF_NUMBER_TABLE
1090: , p5_a8 out nocopy JTF_NUMBER_TABLE
1091: , p5_a9 out nocopy JTF_NUMBER_TABLE
1084: , p5_a2 out nocopy JTF_DATE_TABLE
1085: , p5_a3 out nocopy JTF_DATE_TABLE
1086: , p5_a4 out nocopy JTF_NUMBER_TABLE
1087: , p5_a5 out nocopy JTF_NUMBER_TABLE
1088: , p5_a6 out nocopy JTF_NUMBER_TABLE
1089: , p5_a7 out nocopy JTF_NUMBER_TABLE
1090: , p5_a8 out nocopy JTF_NUMBER_TABLE
1091: , p5_a9 out nocopy JTF_NUMBER_TABLE
1092: , p5_a10 out nocopy JTF_NUMBER_TABLE
1085: , p5_a3 out nocopy JTF_DATE_TABLE
1086: , p5_a4 out nocopy JTF_NUMBER_TABLE
1087: , p5_a5 out nocopy JTF_NUMBER_TABLE
1088: , p5_a6 out nocopy JTF_NUMBER_TABLE
1089: , p5_a7 out nocopy JTF_NUMBER_TABLE
1090: , p5_a8 out nocopy JTF_NUMBER_TABLE
1091: , p5_a9 out nocopy JTF_NUMBER_TABLE
1092: , p5_a10 out nocopy JTF_NUMBER_TABLE
1093: , p5_a11 out nocopy JTF_NUMBER_TABLE
1086: , p5_a4 out nocopy JTF_NUMBER_TABLE
1087: , p5_a5 out nocopy JTF_NUMBER_TABLE
1088: , p5_a6 out nocopy JTF_NUMBER_TABLE
1089: , p5_a7 out nocopy JTF_NUMBER_TABLE
1090: , p5_a8 out nocopy JTF_NUMBER_TABLE
1091: , p5_a9 out nocopy JTF_NUMBER_TABLE
1092: , p5_a10 out nocopy JTF_NUMBER_TABLE
1093: , p5_a11 out nocopy JTF_NUMBER_TABLE
1094: , p5_a12 out nocopy JTF_NUMBER_TABLE
1087: , p5_a5 out nocopy JTF_NUMBER_TABLE
1088: , p5_a6 out nocopy JTF_NUMBER_TABLE
1089: , p5_a7 out nocopy JTF_NUMBER_TABLE
1090: , p5_a8 out nocopy JTF_NUMBER_TABLE
1091: , p5_a9 out nocopy JTF_NUMBER_TABLE
1092: , p5_a10 out nocopy JTF_NUMBER_TABLE
1093: , p5_a11 out nocopy JTF_NUMBER_TABLE
1094: , p5_a12 out nocopy JTF_NUMBER_TABLE
1095: , p5_a13 out nocopy JTF_NUMBER_TABLE
1088: , p5_a6 out nocopy JTF_NUMBER_TABLE
1089: , p5_a7 out nocopy JTF_NUMBER_TABLE
1090: , p5_a8 out nocopy JTF_NUMBER_TABLE
1091: , p5_a9 out nocopy JTF_NUMBER_TABLE
1092: , p5_a10 out nocopy JTF_NUMBER_TABLE
1093: , p5_a11 out nocopy JTF_NUMBER_TABLE
1094: , p5_a12 out nocopy JTF_NUMBER_TABLE
1095: , p5_a13 out nocopy JTF_NUMBER_TABLE
1096: , p5_a14 out nocopy JTF_NUMBER_TABLE
1089: , p5_a7 out nocopy JTF_NUMBER_TABLE
1090: , p5_a8 out nocopy JTF_NUMBER_TABLE
1091: , p5_a9 out nocopy JTF_NUMBER_TABLE
1092: , p5_a10 out nocopy JTF_NUMBER_TABLE
1093: , p5_a11 out nocopy JTF_NUMBER_TABLE
1094: , p5_a12 out nocopy JTF_NUMBER_TABLE
1095: , p5_a13 out nocopy JTF_NUMBER_TABLE
1096: , p5_a14 out nocopy JTF_NUMBER_TABLE
1097: , p5_a15 out nocopy JTF_NUMBER_TABLE
1090: , p5_a8 out nocopy JTF_NUMBER_TABLE
1091: , p5_a9 out nocopy JTF_NUMBER_TABLE
1092: , p5_a10 out nocopy JTF_NUMBER_TABLE
1093: , p5_a11 out nocopy JTF_NUMBER_TABLE
1094: , p5_a12 out nocopy JTF_NUMBER_TABLE
1095: , p5_a13 out nocopy JTF_NUMBER_TABLE
1096: , p5_a14 out nocopy JTF_NUMBER_TABLE
1097: , p5_a15 out nocopy JTF_NUMBER_TABLE
1098: , p5_a16 out nocopy JTF_NUMBER_TABLE
1091: , p5_a9 out nocopy JTF_NUMBER_TABLE
1092: , p5_a10 out nocopy JTF_NUMBER_TABLE
1093: , p5_a11 out nocopy JTF_NUMBER_TABLE
1094: , p5_a12 out nocopy JTF_NUMBER_TABLE
1095: , p5_a13 out nocopy JTF_NUMBER_TABLE
1096: , p5_a14 out nocopy JTF_NUMBER_TABLE
1097: , p5_a15 out nocopy JTF_NUMBER_TABLE
1098: , p5_a16 out nocopy JTF_NUMBER_TABLE
1099: , p5_a17 out nocopy JTF_NUMBER_TABLE
1092: , p5_a10 out nocopy JTF_NUMBER_TABLE
1093: , p5_a11 out nocopy JTF_NUMBER_TABLE
1094: , p5_a12 out nocopy JTF_NUMBER_TABLE
1095: , p5_a13 out nocopy JTF_NUMBER_TABLE
1096: , p5_a14 out nocopy JTF_NUMBER_TABLE
1097: , p5_a15 out nocopy JTF_NUMBER_TABLE
1098: , p5_a16 out nocopy JTF_NUMBER_TABLE
1099: , p5_a17 out nocopy JTF_NUMBER_TABLE
1100: , p5_a18 out nocopy JTF_NUMBER_TABLE
1093: , p5_a11 out nocopy JTF_NUMBER_TABLE
1094: , p5_a12 out nocopy JTF_NUMBER_TABLE
1095: , p5_a13 out nocopy JTF_NUMBER_TABLE
1096: , p5_a14 out nocopy JTF_NUMBER_TABLE
1097: , p5_a15 out nocopy JTF_NUMBER_TABLE
1098: , p5_a16 out nocopy JTF_NUMBER_TABLE
1099: , p5_a17 out nocopy JTF_NUMBER_TABLE
1100: , p5_a18 out nocopy JTF_NUMBER_TABLE
1101: , p5_a19 out nocopy JTF_NUMBER_TABLE
1094: , p5_a12 out nocopy JTF_NUMBER_TABLE
1095: , p5_a13 out nocopy JTF_NUMBER_TABLE
1096: , p5_a14 out nocopy JTF_NUMBER_TABLE
1097: , p5_a15 out nocopy JTF_NUMBER_TABLE
1098: , p5_a16 out nocopy JTF_NUMBER_TABLE
1099: , p5_a17 out nocopy JTF_NUMBER_TABLE
1100: , p5_a18 out nocopy JTF_NUMBER_TABLE
1101: , p5_a19 out nocopy JTF_NUMBER_TABLE
1102: , p5_a20 out nocopy JTF_NUMBER_TABLE
1095: , p5_a13 out nocopy JTF_NUMBER_TABLE
1096: , p5_a14 out nocopy JTF_NUMBER_TABLE
1097: , p5_a15 out nocopy JTF_NUMBER_TABLE
1098: , p5_a16 out nocopy JTF_NUMBER_TABLE
1099: , p5_a17 out nocopy JTF_NUMBER_TABLE
1100: , p5_a18 out nocopy JTF_NUMBER_TABLE
1101: , p5_a19 out nocopy JTF_NUMBER_TABLE
1102: , p5_a20 out nocopy JTF_NUMBER_TABLE
1103: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
1096: , p5_a14 out nocopy JTF_NUMBER_TABLE
1097: , p5_a15 out nocopy JTF_NUMBER_TABLE
1098: , p5_a16 out nocopy JTF_NUMBER_TABLE
1099: , p5_a17 out nocopy JTF_NUMBER_TABLE
1100: , p5_a18 out nocopy JTF_NUMBER_TABLE
1101: , p5_a19 out nocopy JTF_NUMBER_TABLE
1102: , p5_a20 out nocopy JTF_NUMBER_TABLE
1103: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
1104: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
1097: , p5_a15 out nocopy JTF_NUMBER_TABLE
1098: , p5_a16 out nocopy JTF_NUMBER_TABLE
1099: , p5_a17 out nocopy JTF_NUMBER_TABLE
1100: , p5_a18 out nocopy JTF_NUMBER_TABLE
1101: , p5_a19 out nocopy JTF_NUMBER_TABLE
1102: , p5_a20 out nocopy JTF_NUMBER_TABLE
1103: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
1104: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
1105: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
1098: , p5_a16 out nocopy JTF_NUMBER_TABLE
1099: , p5_a17 out nocopy JTF_NUMBER_TABLE
1100: , p5_a18 out nocopy JTF_NUMBER_TABLE
1101: , p5_a19 out nocopy JTF_NUMBER_TABLE
1102: , p5_a20 out nocopy JTF_NUMBER_TABLE
1103: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
1104: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
1105: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
1106: , p5_a24 out nocopy JTF_NUMBER_TABLE
1102: , p5_a20 out nocopy JTF_NUMBER_TABLE
1103: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
1104: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
1105: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
1106: , p5_a24 out nocopy JTF_NUMBER_TABLE
1107: , p5_a25 out nocopy JTF_NUMBER_TABLE
1108: , p5_a26 out nocopy JTF_NUMBER_TABLE
1109: , p5_a27 out nocopy JTF_NUMBER_TABLE
1110: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1103: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
1104: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
1105: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
1106: , p5_a24 out nocopy JTF_NUMBER_TABLE
1107: , p5_a25 out nocopy JTF_NUMBER_TABLE
1108: , p5_a26 out nocopy JTF_NUMBER_TABLE
1109: , p5_a27 out nocopy JTF_NUMBER_TABLE
1110: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1111: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1104: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
1105: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
1106: , p5_a24 out nocopy JTF_NUMBER_TABLE
1107: , p5_a25 out nocopy JTF_NUMBER_TABLE
1108: , p5_a26 out nocopy JTF_NUMBER_TABLE
1109: , p5_a27 out nocopy JTF_NUMBER_TABLE
1110: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1111: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1112: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1105: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
1106: , p5_a24 out nocopy JTF_NUMBER_TABLE
1107: , p5_a25 out nocopy JTF_NUMBER_TABLE
1108: , p5_a26 out nocopy JTF_NUMBER_TABLE
1109: , p5_a27 out nocopy JTF_NUMBER_TABLE
1110: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1111: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1112: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1113: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1110: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1111: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1112: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1113: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1114: , p5_a32 out nocopy JTF_NUMBER_TABLE
1115: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_200
1116: , p5_a34 out nocopy JTF_NUMBER_TABLE
1117: , p5_a35 out nocopy JTF_NUMBER_TABLE
1118: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1112: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1113: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1114: , p5_a32 out nocopy JTF_NUMBER_TABLE
1115: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_200
1116: , p5_a34 out nocopy JTF_NUMBER_TABLE
1117: , p5_a35 out nocopy JTF_NUMBER_TABLE
1118: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1119: , p5_a37 out nocopy JTF_NUMBER_TABLE
1120: , p5_a38 out nocopy JTF_NUMBER_TABLE
1113: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1114: , p5_a32 out nocopy JTF_NUMBER_TABLE
1115: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_200
1116: , p5_a34 out nocopy JTF_NUMBER_TABLE
1117: , p5_a35 out nocopy JTF_NUMBER_TABLE
1118: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1119: , p5_a37 out nocopy JTF_NUMBER_TABLE
1120: , p5_a38 out nocopy JTF_NUMBER_TABLE
1121: , p5_a39 out nocopy JTF_NUMBER_TABLE
1115: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_200
1116: , p5_a34 out nocopy JTF_NUMBER_TABLE
1117: , p5_a35 out nocopy JTF_NUMBER_TABLE
1118: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1119: , p5_a37 out nocopy JTF_NUMBER_TABLE
1120: , p5_a38 out nocopy JTF_NUMBER_TABLE
1121: , p5_a39 out nocopy JTF_NUMBER_TABLE
1122: , p5_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1123: , p5_a41 out nocopy JTF_NUMBER_TABLE
1116: , p5_a34 out nocopy JTF_NUMBER_TABLE
1117: , p5_a35 out nocopy JTF_NUMBER_TABLE
1118: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1119: , p5_a37 out nocopy JTF_NUMBER_TABLE
1120: , p5_a38 out nocopy JTF_NUMBER_TABLE
1121: , p5_a39 out nocopy JTF_NUMBER_TABLE
1122: , p5_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1123: , p5_a41 out nocopy JTF_NUMBER_TABLE
1124: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_2000
1117: , p5_a35 out nocopy JTF_NUMBER_TABLE
1118: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1119: , p5_a37 out nocopy JTF_NUMBER_TABLE
1120: , p5_a38 out nocopy JTF_NUMBER_TABLE
1121: , p5_a39 out nocopy JTF_NUMBER_TABLE
1122: , p5_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1123: , p5_a41 out nocopy JTF_NUMBER_TABLE
1124: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_2000
1125: , x_return_status out nocopy VARCHAR2
1119: , p5_a37 out nocopy JTF_NUMBER_TABLE
1120: , p5_a38 out nocopy JTF_NUMBER_TABLE
1121: , p5_a39 out nocopy JTF_NUMBER_TABLE
1122: , p5_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1123: , p5_a41 out nocopy JTF_NUMBER_TABLE
1124: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_2000
1125: , x_return_status out nocopy VARCHAR2
1126: , x_msg_count out nocopy NUMBER
1127: , x_msg_data out nocopy VARCHAR2
1173: , p5_a39 out nocopy NUMBER
1174: , p5_a40 out nocopy VARCHAR2
1175: , p5_a41 out nocopy NUMBER
1176: , p5_a42 out nocopy VARCHAR2
1177: , p6_a0 out nocopy JTF_NUMBER_TABLE
1178: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1179: , p6_a2 out nocopy JTF_NUMBER_TABLE
1180: , p6_a3 out nocopy JTF_NUMBER_TABLE
1181: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
1175: , p5_a41 out nocopy NUMBER
1176: , p5_a42 out nocopy VARCHAR2
1177: , p6_a0 out nocopy JTF_NUMBER_TABLE
1178: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1179: , p6_a2 out nocopy JTF_NUMBER_TABLE
1180: , p6_a3 out nocopy JTF_NUMBER_TABLE
1181: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
1182: , p6_a5 out nocopy JTF_NUMBER_TABLE
1183: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1176: , p5_a42 out nocopy VARCHAR2
1177: , p6_a0 out nocopy JTF_NUMBER_TABLE
1178: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1179: , p6_a2 out nocopy JTF_NUMBER_TABLE
1180: , p6_a3 out nocopy JTF_NUMBER_TABLE
1181: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
1182: , p6_a5 out nocopy JTF_NUMBER_TABLE
1183: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1184: , p6_a7 out nocopy JTF_NUMBER_TABLE
1178: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1179: , p6_a2 out nocopy JTF_NUMBER_TABLE
1180: , p6_a3 out nocopy JTF_NUMBER_TABLE
1181: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
1182: , p6_a5 out nocopy JTF_NUMBER_TABLE
1183: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1184: , p6_a7 out nocopy JTF_NUMBER_TABLE
1185: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1186: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1180: , p6_a3 out nocopy JTF_NUMBER_TABLE
1181: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
1182: , p6_a5 out nocopy JTF_NUMBER_TABLE
1183: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1184: , p6_a7 out nocopy JTF_NUMBER_TABLE
1185: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1186: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1187: , x_return_status out nocopy VARCHAR2
1188: , x_msg_count out nocopy NUMBER
1233: , p3_a39 out nocopy NUMBER
1234: , p3_a40 out nocopy VARCHAR2
1235: , p3_a41 out nocopy NUMBER
1236: , p3_a42 out nocopy VARCHAR2
1237: , p4_a0 out nocopy JTF_NUMBER_TABLE
1238: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1239: , p4_a2 out nocopy JTF_NUMBER_TABLE
1240: , p4_a3 out nocopy JTF_NUMBER_TABLE
1241: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
1235: , p3_a41 out nocopy NUMBER
1236: , p3_a42 out nocopy VARCHAR2
1237: , p4_a0 out nocopy JTF_NUMBER_TABLE
1238: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1239: , p4_a2 out nocopy JTF_NUMBER_TABLE
1240: , p4_a3 out nocopy JTF_NUMBER_TABLE
1241: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
1242: , p4_a5 out nocopy JTF_NUMBER_TABLE
1243: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
1236: , p3_a42 out nocopy VARCHAR2
1237: , p4_a0 out nocopy JTF_NUMBER_TABLE
1238: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1239: , p4_a2 out nocopy JTF_NUMBER_TABLE
1240: , p4_a3 out nocopy JTF_NUMBER_TABLE
1241: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
1242: , p4_a5 out nocopy JTF_NUMBER_TABLE
1243: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
1244: , p4_a7 out nocopy JTF_NUMBER_TABLE
1238: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1239: , p4_a2 out nocopy JTF_NUMBER_TABLE
1240: , p4_a3 out nocopy JTF_NUMBER_TABLE
1241: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
1242: , p4_a5 out nocopy JTF_NUMBER_TABLE
1243: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
1244: , p4_a7 out nocopy JTF_NUMBER_TABLE
1245: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1246: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1240: , p4_a3 out nocopy JTF_NUMBER_TABLE
1241: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
1242: , p4_a5 out nocopy JTF_NUMBER_TABLE
1243: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
1244: , p4_a7 out nocopy JTF_NUMBER_TABLE
1245: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1246: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1247: , x_return_status out nocopy VARCHAR2
1248: , x_msg_count out nocopy NUMBER
1367: , p_loan_id NUMBER
1368: , p_date DATE
1369: , p_reason VARCHAR2
1370: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
1371: , p5_a1 out nocopy JTF_NUMBER_TABLE
1372: , p5_a2 out nocopy JTF_NUMBER_TABLE
1373: , p5_a3 out nocopy JTF_NUMBER_TABLE
1374: , x_return_status out nocopy VARCHAR2
1375: , x_msg_count out nocopy NUMBER
1368: , p_date DATE
1369: , p_reason VARCHAR2
1370: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
1371: , p5_a1 out nocopy JTF_NUMBER_TABLE
1372: , p5_a2 out nocopy JTF_NUMBER_TABLE
1373: , p5_a3 out nocopy JTF_NUMBER_TABLE
1374: , x_return_status out nocopy VARCHAR2
1375: , x_msg_count out nocopy NUMBER
1376: , x_msg_data out nocopy VARCHAR2
1369: , p_reason VARCHAR2
1370: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
1371: , p5_a1 out nocopy JTF_NUMBER_TABLE
1372: , p5_a2 out nocopy JTF_NUMBER_TABLE
1373: , p5_a3 out nocopy JTF_NUMBER_TABLE
1374: , x_return_status out nocopy VARCHAR2
1375: , x_msg_count out nocopy NUMBER
1376: , x_msg_data out nocopy VARCHAR2
1377: );