1: package body lns_financials_w as
2: /* $Header: LNS_FINANCIALJ_B.pls 120.13.12020000.2 2012/07/19 20:56:08 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_B.pls 120.13.12020000.2 2012/07/19 20:56:08 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: ) as
36: end loop;
37: end if;
38: end if;
39: end rosetta_table_copy_in_p1;
40: procedure rosetta_table_copy_out_p1(t lns_financials.rate_schedule_tbl, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_DATE_TABLE
42: , a2 out nocopy JTF_DATE_TABLE
43: , a3 out nocopy JTF_NUMBER_TABLE
44: , a4 out nocopy JTF_NUMBER_TABLE
39: end rosetta_table_copy_in_p1;
40: procedure rosetta_table_copy_out_p1(t lns_financials.rate_schedule_tbl, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_DATE_TABLE
42: , a2 out nocopy JTF_DATE_TABLE
43: , a3 out nocopy JTF_NUMBER_TABLE
44: , a4 out nocopy JTF_NUMBER_TABLE
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_VARCHAR2_TABLE_100
40: procedure rosetta_table_copy_out_p1(t lns_financials.rate_schedule_tbl, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_DATE_TABLE
42: , a2 out nocopy JTF_DATE_TABLE
43: , a3 out nocopy JTF_NUMBER_TABLE
44: , a4 out nocopy JTF_NUMBER_TABLE
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_VARCHAR2_TABLE_100
48: , a8 out nocopy JTF_VARCHAR2_TABLE_100
41: , a1 out nocopy JTF_DATE_TABLE
42: , a2 out nocopy JTF_DATE_TABLE
43: , a3 out nocopy JTF_NUMBER_TABLE
44: , a4 out nocopy JTF_NUMBER_TABLE
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_VARCHAR2_TABLE_100
48: , a8 out nocopy JTF_VARCHAR2_TABLE_100
49: , a9 out nocopy JTF_VARCHAR2_TABLE_100
42: , a2 out nocopy JTF_DATE_TABLE
43: , a3 out nocopy JTF_NUMBER_TABLE
44: , a4 out nocopy JTF_NUMBER_TABLE
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_VARCHAR2_TABLE_100
48: , a8 out nocopy JTF_VARCHAR2_TABLE_100
49: , a9 out nocopy JTF_VARCHAR2_TABLE_100
50: ) as
50: ) as
51: ddindx binary_integer; indx binary_integer;
52: begin
53: if t is null or t.count = 0 then
54: a0 := JTF_NUMBER_TABLE();
55: a1 := JTF_DATE_TABLE();
56: a2 := JTF_DATE_TABLE();
57: a3 := JTF_NUMBER_TABLE();
58: a4 := JTF_NUMBER_TABLE();
53: if t is null or t.count = 0 then
54: a0 := JTF_NUMBER_TABLE();
55: a1 := JTF_DATE_TABLE();
56: a2 := JTF_DATE_TABLE();
57: a3 := JTF_NUMBER_TABLE();
58: a4 := JTF_NUMBER_TABLE();
59: a5 := JTF_NUMBER_TABLE();
60: a6 := JTF_NUMBER_TABLE();
61: a7 := JTF_VARCHAR2_TABLE_100();
54: a0 := JTF_NUMBER_TABLE();
55: a1 := JTF_DATE_TABLE();
56: a2 := JTF_DATE_TABLE();
57: a3 := JTF_NUMBER_TABLE();
58: a4 := JTF_NUMBER_TABLE();
59: a5 := JTF_NUMBER_TABLE();
60: a6 := JTF_NUMBER_TABLE();
61: a7 := JTF_VARCHAR2_TABLE_100();
62: a8 := JTF_VARCHAR2_TABLE_100();
55: a1 := JTF_DATE_TABLE();
56: a2 := JTF_DATE_TABLE();
57: a3 := JTF_NUMBER_TABLE();
58: a4 := JTF_NUMBER_TABLE();
59: a5 := JTF_NUMBER_TABLE();
60: a6 := JTF_NUMBER_TABLE();
61: a7 := JTF_VARCHAR2_TABLE_100();
62: a8 := JTF_VARCHAR2_TABLE_100();
63: a9 := JTF_VARCHAR2_TABLE_100();
56: a2 := JTF_DATE_TABLE();
57: a3 := JTF_NUMBER_TABLE();
58: a4 := JTF_NUMBER_TABLE();
59: a5 := JTF_NUMBER_TABLE();
60: a6 := JTF_NUMBER_TABLE();
61: a7 := JTF_VARCHAR2_TABLE_100();
62: a8 := JTF_VARCHAR2_TABLE_100();
63: a9 := JTF_VARCHAR2_TABLE_100();
64: else
61: a7 := JTF_VARCHAR2_TABLE_100();
62: a8 := JTF_VARCHAR2_TABLE_100();
63: a9 := JTF_VARCHAR2_TABLE_100();
64: else
65: a0 := JTF_NUMBER_TABLE();
66: a1 := JTF_DATE_TABLE();
67: a2 := JTF_DATE_TABLE();
68: a3 := JTF_NUMBER_TABLE();
69: a4 := JTF_NUMBER_TABLE();
64: else
65: a0 := JTF_NUMBER_TABLE();
66: a1 := JTF_DATE_TABLE();
67: a2 := JTF_DATE_TABLE();
68: a3 := JTF_NUMBER_TABLE();
69: a4 := JTF_NUMBER_TABLE();
70: a5 := JTF_NUMBER_TABLE();
71: a6 := JTF_NUMBER_TABLE();
72: a7 := JTF_VARCHAR2_TABLE_100();
65: a0 := JTF_NUMBER_TABLE();
66: a1 := JTF_DATE_TABLE();
67: a2 := JTF_DATE_TABLE();
68: a3 := JTF_NUMBER_TABLE();
69: a4 := JTF_NUMBER_TABLE();
70: a5 := JTF_NUMBER_TABLE();
71: a6 := JTF_NUMBER_TABLE();
72: a7 := JTF_VARCHAR2_TABLE_100();
73: a8 := JTF_VARCHAR2_TABLE_100();
66: a1 := JTF_DATE_TABLE();
67: a2 := JTF_DATE_TABLE();
68: a3 := JTF_NUMBER_TABLE();
69: a4 := JTF_NUMBER_TABLE();
70: a5 := JTF_NUMBER_TABLE();
71: a6 := JTF_NUMBER_TABLE();
72: a7 := JTF_VARCHAR2_TABLE_100();
73: a8 := JTF_VARCHAR2_TABLE_100();
74: a9 := JTF_VARCHAR2_TABLE_100();
67: a2 := JTF_DATE_TABLE();
68: a3 := JTF_NUMBER_TABLE();
69: a4 := JTF_NUMBER_TABLE();
70: a5 := JTF_NUMBER_TABLE();
71: a6 := JTF_NUMBER_TABLE();
72: a7 := JTF_VARCHAR2_TABLE_100();
73: a8 := JTF_VARCHAR2_TABLE_100();
74: a9 := JTF_VARCHAR2_TABLE_100();
75: if t.count > 0 then
105: end if;
106: end if;
107: end rosetta_table_copy_out_p1;
108:
109: procedure rosetta_table_copy_in_p3(t out nocopy lns_financials.amortization_tbl, a0 JTF_NUMBER_TABLE
110: , a1 JTF_DATE_TABLE
111: , a2 JTF_DATE_TABLE
112: , a3 JTF_DATE_TABLE
113: , a4 JTF_NUMBER_TABLE
109: procedure rosetta_table_copy_in_p3(t out nocopy lns_financials.amortization_tbl, a0 JTF_NUMBER_TABLE
110: , a1 JTF_DATE_TABLE
111: , a2 JTF_DATE_TABLE
112: , a3 JTF_DATE_TABLE
113: , a4 JTF_NUMBER_TABLE
114: , a5 JTF_NUMBER_TABLE
115: , a6 JTF_NUMBER_TABLE
116: , a7 JTF_NUMBER_TABLE
117: , a8 JTF_NUMBER_TABLE
110: , a1 JTF_DATE_TABLE
111: , a2 JTF_DATE_TABLE
112: , a3 JTF_DATE_TABLE
113: , a4 JTF_NUMBER_TABLE
114: , a5 JTF_NUMBER_TABLE
115: , a6 JTF_NUMBER_TABLE
116: , a7 JTF_NUMBER_TABLE
117: , a8 JTF_NUMBER_TABLE
118: , a9 JTF_NUMBER_TABLE
111: , a2 JTF_DATE_TABLE
112: , a3 JTF_DATE_TABLE
113: , a4 JTF_NUMBER_TABLE
114: , a5 JTF_NUMBER_TABLE
115: , a6 JTF_NUMBER_TABLE
116: , a7 JTF_NUMBER_TABLE
117: , a8 JTF_NUMBER_TABLE
118: , a9 JTF_NUMBER_TABLE
119: , a10 JTF_NUMBER_TABLE
112: , a3 JTF_DATE_TABLE
113: , a4 JTF_NUMBER_TABLE
114: , a5 JTF_NUMBER_TABLE
115: , a6 JTF_NUMBER_TABLE
116: , a7 JTF_NUMBER_TABLE
117: , a8 JTF_NUMBER_TABLE
118: , a9 JTF_NUMBER_TABLE
119: , a10 JTF_NUMBER_TABLE
120: , a11 JTF_NUMBER_TABLE
113: , a4 JTF_NUMBER_TABLE
114: , a5 JTF_NUMBER_TABLE
115: , a6 JTF_NUMBER_TABLE
116: , a7 JTF_NUMBER_TABLE
117: , a8 JTF_NUMBER_TABLE
118: , a9 JTF_NUMBER_TABLE
119: , a10 JTF_NUMBER_TABLE
120: , a11 JTF_NUMBER_TABLE
121: , a12 JTF_NUMBER_TABLE
114: , a5 JTF_NUMBER_TABLE
115: , a6 JTF_NUMBER_TABLE
116: , a7 JTF_NUMBER_TABLE
117: , a8 JTF_NUMBER_TABLE
118: , a9 JTF_NUMBER_TABLE
119: , a10 JTF_NUMBER_TABLE
120: , a11 JTF_NUMBER_TABLE
121: , a12 JTF_NUMBER_TABLE
122: , a13 JTF_NUMBER_TABLE
115: , a6 JTF_NUMBER_TABLE
116: , a7 JTF_NUMBER_TABLE
117: , a8 JTF_NUMBER_TABLE
118: , a9 JTF_NUMBER_TABLE
119: , a10 JTF_NUMBER_TABLE
120: , a11 JTF_NUMBER_TABLE
121: , a12 JTF_NUMBER_TABLE
122: , a13 JTF_NUMBER_TABLE
123: , a14 JTF_NUMBER_TABLE
116: , a7 JTF_NUMBER_TABLE
117: , a8 JTF_NUMBER_TABLE
118: , a9 JTF_NUMBER_TABLE
119: , a10 JTF_NUMBER_TABLE
120: , a11 JTF_NUMBER_TABLE
121: , a12 JTF_NUMBER_TABLE
122: , a13 JTF_NUMBER_TABLE
123: , a14 JTF_NUMBER_TABLE
124: , a15 JTF_NUMBER_TABLE
117: , a8 JTF_NUMBER_TABLE
118: , a9 JTF_NUMBER_TABLE
119: , a10 JTF_NUMBER_TABLE
120: , a11 JTF_NUMBER_TABLE
121: , a12 JTF_NUMBER_TABLE
122: , a13 JTF_NUMBER_TABLE
123: , a14 JTF_NUMBER_TABLE
124: , a15 JTF_NUMBER_TABLE
125: , a16 JTF_NUMBER_TABLE
118: , a9 JTF_NUMBER_TABLE
119: , a10 JTF_NUMBER_TABLE
120: , a11 JTF_NUMBER_TABLE
121: , a12 JTF_NUMBER_TABLE
122: , a13 JTF_NUMBER_TABLE
123: , a14 JTF_NUMBER_TABLE
124: , a15 JTF_NUMBER_TABLE
125: , a16 JTF_NUMBER_TABLE
126: , a17 JTF_NUMBER_TABLE
119: , a10 JTF_NUMBER_TABLE
120: , a11 JTF_NUMBER_TABLE
121: , a12 JTF_NUMBER_TABLE
122: , a13 JTF_NUMBER_TABLE
123: , a14 JTF_NUMBER_TABLE
124: , a15 JTF_NUMBER_TABLE
125: , a16 JTF_NUMBER_TABLE
126: , a17 JTF_NUMBER_TABLE
127: , a18 JTF_NUMBER_TABLE
120: , a11 JTF_NUMBER_TABLE
121: , a12 JTF_NUMBER_TABLE
122: , a13 JTF_NUMBER_TABLE
123: , a14 JTF_NUMBER_TABLE
124: , a15 JTF_NUMBER_TABLE
125: , a16 JTF_NUMBER_TABLE
126: , a17 JTF_NUMBER_TABLE
127: , a18 JTF_NUMBER_TABLE
128: , a19 JTF_NUMBER_TABLE
121: , a12 JTF_NUMBER_TABLE
122: , a13 JTF_NUMBER_TABLE
123: , a14 JTF_NUMBER_TABLE
124: , a15 JTF_NUMBER_TABLE
125: , a16 JTF_NUMBER_TABLE
126: , a17 JTF_NUMBER_TABLE
127: , a18 JTF_NUMBER_TABLE
128: , a19 JTF_NUMBER_TABLE
129: , a20 JTF_NUMBER_TABLE
122: , a13 JTF_NUMBER_TABLE
123: , a14 JTF_NUMBER_TABLE
124: , a15 JTF_NUMBER_TABLE
125: , a16 JTF_NUMBER_TABLE
126: , a17 JTF_NUMBER_TABLE
127: , a18 JTF_NUMBER_TABLE
128: , a19 JTF_NUMBER_TABLE
129: , a20 JTF_NUMBER_TABLE
130: , a21 JTF_VARCHAR2_TABLE_100
123: , a14 JTF_NUMBER_TABLE
124: , a15 JTF_NUMBER_TABLE
125: , a16 JTF_NUMBER_TABLE
126: , a17 JTF_NUMBER_TABLE
127: , a18 JTF_NUMBER_TABLE
128: , a19 JTF_NUMBER_TABLE
129: , a20 JTF_NUMBER_TABLE
130: , a21 JTF_VARCHAR2_TABLE_100
131: , a22 JTF_VARCHAR2_TABLE_100
124: , a15 JTF_NUMBER_TABLE
125: , a16 JTF_NUMBER_TABLE
126: , a17 JTF_NUMBER_TABLE
127: , a18 JTF_NUMBER_TABLE
128: , a19 JTF_NUMBER_TABLE
129: , a20 JTF_NUMBER_TABLE
130: , a21 JTF_VARCHAR2_TABLE_100
131: , a22 JTF_VARCHAR2_TABLE_100
132: , a23 JTF_VARCHAR2_TABLE_100
125: , a16 JTF_NUMBER_TABLE
126: , a17 JTF_NUMBER_TABLE
127: , a18 JTF_NUMBER_TABLE
128: , a19 JTF_NUMBER_TABLE
129: , a20 JTF_NUMBER_TABLE
130: , a21 JTF_VARCHAR2_TABLE_100
131: , a22 JTF_VARCHAR2_TABLE_100
132: , a23 JTF_VARCHAR2_TABLE_100
133: , a24 JTF_NUMBER_TABLE
129: , a20 JTF_NUMBER_TABLE
130: , a21 JTF_VARCHAR2_TABLE_100
131: , a22 JTF_VARCHAR2_TABLE_100
132: , a23 JTF_VARCHAR2_TABLE_100
133: , a24 JTF_NUMBER_TABLE
134: , a25 JTF_NUMBER_TABLE
135: , a26 JTF_NUMBER_TABLE
136: , a27 JTF_NUMBER_TABLE
137: , a28 JTF_VARCHAR2_TABLE_2000
130: , a21 JTF_VARCHAR2_TABLE_100
131: , a22 JTF_VARCHAR2_TABLE_100
132: , a23 JTF_VARCHAR2_TABLE_100
133: , a24 JTF_NUMBER_TABLE
134: , a25 JTF_NUMBER_TABLE
135: , a26 JTF_NUMBER_TABLE
136: , a27 JTF_NUMBER_TABLE
137: , a28 JTF_VARCHAR2_TABLE_2000
138: , a29 JTF_VARCHAR2_TABLE_2000
131: , a22 JTF_VARCHAR2_TABLE_100
132: , a23 JTF_VARCHAR2_TABLE_100
133: , a24 JTF_NUMBER_TABLE
134: , a25 JTF_NUMBER_TABLE
135: , a26 JTF_NUMBER_TABLE
136: , a27 JTF_NUMBER_TABLE
137: , a28 JTF_VARCHAR2_TABLE_2000
138: , a29 JTF_VARCHAR2_TABLE_2000
139: , a30 JTF_VARCHAR2_TABLE_2000
132: , a23 JTF_VARCHAR2_TABLE_100
133: , a24 JTF_NUMBER_TABLE
134: , a25 JTF_NUMBER_TABLE
135: , a26 JTF_NUMBER_TABLE
136: , a27 JTF_NUMBER_TABLE
137: , a28 JTF_VARCHAR2_TABLE_2000
138: , a29 JTF_VARCHAR2_TABLE_2000
139: , a30 JTF_VARCHAR2_TABLE_2000
140: , a31 JTF_VARCHAR2_TABLE_2000
137: , a28 JTF_VARCHAR2_TABLE_2000
138: , a29 JTF_VARCHAR2_TABLE_2000
139: , a30 JTF_VARCHAR2_TABLE_2000
140: , a31 JTF_VARCHAR2_TABLE_2000
141: , a32 JTF_NUMBER_TABLE
142: , a33 JTF_VARCHAR2_TABLE_200
143: , a34 JTF_NUMBER_TABLE
144: , a35 JTF_NUMBER_TABLE
145: , a36 JTF_VARCHAR2_TABLE_2000
139: , a30 JTF_VARCHAR2_TABLE_2000
140: , a31 JTF_VARCHAR2_TABLE_2000
141: , a32 JTF_NUMBER_TABLE
142: , a33 JTF_VARCHAR2_TABLE_200
143: , a34 JTF_NUMBER_TABLE
144: , a35 JTF_NUMBER_TABLE
145: , a36 JTF_VARCHAR2_TABLE_2000
146: , a37 JTF_NUMBER_TABLE
147: , a38 JTF_NUMBER_TABLE
140: , a31 JTF_VARCHAR2_TABLE_2000
141: , a32 JTF_NUMBER_TABLE
142: , a33 JTF_VARCHAR2_TABLE_200
143: , a34 JTF_NUMBER_TABLE
144: , a35 JTF_NUMBER_TABLE
145: , a36 JTF_VARCHAR2_TABLE_2000
146: , a37 JTF_NUMBER_TABLE
147: , a38 JTF_NUMBER_TABLE
148: , a39 JTF_NUMBER_TABLE
142: , a33 JTF_VARCHAR2_TABLE_200
143: , a34 JTF_NUMBER_TABLE
144: , a35 JTF_NUMBER_TABLE
145: , a36 JTF_VARCHAR2_TABLE_2000
146: , a37 JTF_NUMBER_TABLE
147: , a38 JTF_NUMBER_TABLE
148: , a39 JTF_NUMBER_TABLE
149: , a40 JTF_VARCHAR2_TABLE_2000
150: , a41 JTF_NUMBER_TABLE
143: , a34 JTF_NUMBER_TABLE
144: , a35 JTF_NUMBER_TABLE
145: , a36 JTF_VARCHAR2_TABLE_2000
146: , a37 JTF_NUMBER_TABLE
147: , a38 JTF_NUMBER_TABLE
148: , a39 JTF_NUMBER_TABLE
149: , a40 JTF_VARCHAR2_TABLE_2000
150: , a41 JTF_NUMBER_TABLE
151: , a42 JTF_VARCHAR2_TABLE_2000
144: , a35 JTF_NUMBER_TABLE
145: , a36 JTF_VARCHAR2_TABLE_2000
146: , a37 JTF_NUMBER_TABLE
147: , a38 JTF_NUMBER_TABLE
148: , a39 JTF_NUMBER_TABLE
149: , a40 JTF_VARCHAR2_TABLE_2000
150: , a41 JTF_NUMBER_TABLE
151: , a42 JTF_VARCHAR2_TABLE_2000
152: ) as
146: , a37 JTF_NUMBER_TABLE
147: , a38 JTF_NUMBER_TABLE
148: , a39 JTF_NUMBER_TABLE
149: , a40 JTF_VARCHAR2_TABLE_2000
150: , a41 JTF_NUMBER_TABLE
151: , a42 JTF_VARCHAR2_TABLE_2000
152: ) as
153: ddindx binary_integer; indx binary_integer;
154: begin
208: end loop;
209: end if;
210: end if;
211: end rosetta_table_copy_in_p3;
212: procedure rosetta_table_copy_out_p3(t lns_financials.amortization_tbl, a0 out nocopy JTF_NUMBER_TABLE
213: , a1 out nocopy JTF_DATE_TABLE
214: , a2 out nocopy JTF_DATE_TABLE
215: , a3 out nocopy JTF_DATE_TABLE
216: , a4 out nocopy JTF_NUMBER_TABLE
212: procedure rosetta_table_copy_out_p3(t lns_financials.amortization_tbl, a0 out nocopy JTF_NUMBER_TABLE
213: , a1 out nocopy JTF_DATE_TABLE
214: , a2 out nocopy JTF_DATE_TABLE
215: , a3 out nocopy JTF_DATE_TABLE
216: , a4 out nocopy JTF_NUMBER_TABLE
217: , a5 out nocopy JTF_NUMBER_TABLE
218: , a6 out nocopy JTF_NUMBER_TABLE
219: , a7 out nocopy JTF_NUMBER_TABLE
220: , a8 out nocopy JTF_NUMBER_TABLE
213: , a1 out nocopy JTF_DATE_TABLE
214: , a2 out nocopy JTF_DATE_TABLE
215: , a3 out nocopy JTF_DATE_TABLE
216: , a4 out nocopy JTF_NUMBER_TABLE
217: , a5 out nocopy JTF_NUMBER_TABLE
218: , a6 out nocopy JTF_NUMBER_TABLE
219: , a7 out nocopy JTF_NUMBER_TABLE
220: , a8 out nocopy JTF_NUMBER_TABLE
221: , a9 out nocopy JTF_NUMBER_TABLE
214: , a2 out nocopy JTF_DATE_TABLE
215: , a3 out nocopy JTF_DATE_TABLE
216: , a4 out nocopy JTF_NUMBER_TABLE
217: , a5 out nocopy JTF_NUMBER_TABLE
218: , a6 out nocopy JTF_NUMBER_TABLE
219: , a7 out nocopy JTF_NUMBER_TABLE
220: , a8 out nocopy JTF_NUMBER_TABLE
221: , a9 out nocopy JTF_NUMBER_TABLE
222: , a10 out nocopy JTF_NUMBER_TABLE
215: , a3 out nocopy JTF_DATE_TABLE
216: , a4 out nocopy JTF_NUMBER_TABLE
217: , a5 out nocopy JTF_NUMBER_TABLE
218: , a6 out nocopy JTF_NUMBER_TABLE
219: , a7 out nocopy JTF_NUMBER_TABLE
220: , a8 out nocopy JTF_NUMBER_TABLE
221: , a9 out nocopy JTF_NUMBER_TABLE
222: , a10 out nocopy JTF_NUMBER_TABLE
223: , a11 out nocopy JTF_NUMBER_TABLE
216: , a4 out nocopy JTF_NUMBER_TABLE
217: , a5 out nocopy JTF_NUMBER_TABLE
218: , a6 out nocopy JTF_NUMBER_TABLE
219: , a7 out nocopy JTF_NUMBER_TABLE
220: , a8 out nocopy JTF_NUMBER_TABLE
221: , a9 out nocopy JTF_NUMBER_TABLE
222: , a10 out nocopy JTF_NUMBER_TABLE
223: , a11 out nocopy JTF_NUMBER_TABLE
224: , a12 out nocopy JTF_NUMBER_TABLE
217: , a5 out nocopy JTF_NUMBER_TABLE
218: , a6 out nocopy JTF_NUMBER_TABLE
219: , a7 out nocopy JTF_NUMBER_TABLE
220: , a8 out nocopy JTF_NUMBER_TABLE
221: , a9 out nocopy JTF_NUMBER_TABLE
222: , a10 out nocopy JTF_NUMBER_TABLE
223: , a11 out nocopy JTF_NUMBER_TABLE
224: , a12 out nocopy JTF_NUMBER_TABLE
225: , a13 out nocopy JTF_NUMBER_TABLE
218: , a6 out nocopy JTF_NUMBER_TABLE
219: , a7 out nocopy JTF_NUMBER_TABLE
220: , a8 out nocopy JTF_NUMBER_TABLE
221: , a9 out nocopy JTF_NUMBER_TABLE
222: , a10 out nocopy JTF_NUMBER_TABLE
223: , a11 out nocopy JTF_NUMBER_TABLE
224: , a12 out nocopy JTF_NUMBER_TABLE
225: , a13 out nocopy JTF_NUMBER_TABLE
226: , a14 out nocopy JTF_NUMBER_TABLE
219: , a7 out nocopy JTF_NUMBER_TABLE
220: , a8 out nocopy JTF_NUMBER_TABLE
221: , a9 out nocopy JTF_NUMBER_TABLE
222: , a10 out nocopy JTF_NUMBER_TABLE
223: , a11 out nocopy JTF_NUMBER_TABLE
224: , a12 out nocopy JTF_NUMBER_TABLE
225: , a13 out nocopy JTF_NUMBER_TABLE
226: , a14 out nocopy JTF_NUMBER_TABLE
227: , a15 out nocopy JTF_NUMBER_TABLE
220: , a8 out nocopy JTF_NUMBER_TABLE
221: , a9 out nocopy JTF_NUMBER_TABLE
222: , a10 out nocopy JTF_NUMBER_TABLE
223: , a11 out nocopy JTF_NUMBER_TABLE
224: , a12 out nocopy JTF_NUMBER_TABLE
225: , a13 out nocopy JTF_NUMBER_TABLE
226: , a14 out nocopy JTF_NUMBER_TABLE
227: , a15 out nocopy JTF_NUMBER_TABLE
228: , a16 out nocopy JTF_NUMBER_TABLE
221: , a9 out nocopy JTF_NUMBER_TABLE
222: , a10 out nocopy JTF_NUMBER_TABLE
223: , a11 out nocopy JTF_NUMBER_TABLE
224: , a12 out nocopy JTF_NUMBER_TABLE
225: , a13 out nocopy JTF_NUMBER_TABLE
226: , a14 out nocopy JTF_NUMBER_TABLE
227: , a15 out nocopy JTF_NUMBER_TABLE
228: , a16 out nocopy JTF_NUMBER_TABLE
229: , a17 out nocopy JTF_NUMBER_TABLE
222: , a10 out nocopy JTF_NUMBER_TABLE
223: , a11 out nocopy JTF_NUMBER_TABLE
224: , a12 out nocopy JTF_NUMBER_TABLE
225: , a13 out nocopy JTF_NUMBER_TABLE
226: , a14 out nocopy JTF_NUMBER_TABLE
227: , a15 out nocopy JTF_NUMBER_TABLE
228: , a16 out nocopy JTF_NUMBER_TABLE
229: , a17 out nocopy JTF_NUMBER_TABLE
230: , a18 out nocopy JTF_NUMBER_TABLE
223: , a11 out nocopy JTF_NUMBER_TABLE
224: , a12 out nocopy JTF_NUMBER_TABLE
225: , a13 out nocopy JTF_NUMBER_TABLE
226: , a14 out nocopy JTF_NUMBER_TABLE
227: , a15 out nocopy JTF_NUMBER_TABLE
228: , a16 out nocopy JTF_NUMBER_TABLE
229: , a17 out nocopy JTF_NUMBER_TABLE
230: , a18 out nocopy JTF_NUMBER_TABLE
231: , a19 out nocopy JTF_NUMBER_TABLE
224: , a12 out nocopy JTF_NUMBER_TABLE
225: , a13 out nocopy JTF_NUMBER_TABLE
226: , a14 out nocopy JTF_NUMBER_TABLE
227: , a15 out nocopy JTF_NUMBER_TABLE
228: , a16 out nocopy JTF_NUMBER_TABLE
229: , a17 out nocopy JTF_NUMBER_TABLE
230: , a18 out nocopy JTF_NUMBER_TABLE
231: , a19 out nocopy JTF_NUMBER_TABLE
232: , a20 out nocopy JTF_NUMBER_TABLE
225: , a13 out nocopy JTF_NUMBER_TABLE
226: , a14 out nocopy JTF_NUMBER_TABLE
227: , a15 out nocopy JTF_NUMBER_TABLE
228: , a16 out nocopy JTF_NUMBER_TABLE
229: , a17 out nocopy JTF_NUMBER_TABLE
230: , a18 out nocopy JTF_NUMBER_TABLE
231: , a19 out nocopy JTF_NUMBER_TABLE
232: , a20 out nocopy JTF_NUMBER_TABLE
233: , a21 out nocopy JTF_VARCHAR2_TABLE_100
226: , a14 out nocopy JTF_NUMBER_TABLE
227: , a15 out nocopy JTF_NUMBER_TABLE
228: , a16 out nocopy JTF_NUMBER_TABLE
229: , a17 out nocopy JTF_NUMBER_TABLE
230: , a18 out nocopy JTF_NUMBER_TABLE
231: , a19 out nocopy JTF_NUMBER_TABLE
232: , a20 out nocopy JTF_NUMBER_TABLE
233: , a21 out nocopy JTF_VARCHAR2_TABLE_100
234: , a22 out nocopy JTF_VARCHAR2_TABLE_100
227: , a15 out nocopy JTF_NUMBER_TABLE
228: , a16 out nocopy JTF_NUMBER_TABLE
229: , a17 out nocopy JTF_NUMBER_TABLE
230: , a18 out nocopy JTF_NUMBER_TABLE
231: , a19 out nocopy JTF_NUMBER_TABLE
232: , a20 out nocopy JTF_NUMBER_TABLE
233: , a21 out nocopy JTF_VARCHAR2_TABLE_100
234: , a22 out nocopy JTF_VARCHAR2_TABLE_100
235: , a23 out nocopy JTF_VARCHAR2_TABLE_100
228: , a16 out nocopy JTF_NUMBER_TABLE
229: , a17 out nocopy JTF_NUMBER_TABLE
230: , a18 out nocopy JTF_NUMBER_TABLE
231: , a19 out nocopy JTF_NUMBER_TABLE
232: , a20 out nocopy JTF_NUMBER_TABLE
233: , a21 out nocopy JTF_VARCHAR2_TABLE_100
234: , a22 out nocopy JTF_VARCHAR2_TABLE_100
235: , a23 out nocopy JTF_VARCHAR2_TABLE_100
236: , a24 out nocopy JTF_NUMBER_TABLE
232: , a20 out nocopy JTF_NUMBER_TABLE
233: , a21 out nocopy JTF_VARCHAR2_TABLE_100
234: , a22 out nocopy JTF_VARCHAR2_TABLE_100
235: , a23 out nocopy JTF_VARCHAR2_TABLE_100
236: , a24 out nocopy JTF_NUMBER_TABLE
237: , a25 out nocopy JTF_NUMBER_TABLE
238: , a26 out nocopy JTF_NUMBER_TABLE
239: , a27 out nocopy JTF_NUMBER_TABLE
240: , a28 out nocopy JTF_VARCHAR2_TABLE_2000
233: , a21 out nocopy JTF_VARCHAR2_TABLE_100
234: , a22 out nocopy JTF_VARCHAR2_TABLE_100
235: , a23 out nocopy JTF_VARCHAR2_TABLE_100
236: , a24 out nocopy JTF_NUMBER_TABLE
237: , a25 out nocopy JTF_NUMBER_TABLE
238: , a26 out nocopy JTF_NUMBER_TABLE
239: , a27 out nocopy JTF_NUMBER_TABLE
240: , a28 out nocopy JTF_VARCHAR2_TABLE_2000
241: , a29 out nocopy JTF_VARCHAR2_TABLE_2000
234: , a22 out nocopy JTF_VARCHAR2_TABLE_100
235: , a23 out nocopy JTF_VARCHAR2_TABLE_100
236: , a24 out nocopy JTF_NUMBER_TABLE
237: , a25 out nocopy JTF_NUMBER_TABLE
238: , a26 out nocopy JTF_NUMBER_TABLE
239: , a27 out nocopy JTF_NUMBER_TABLE
240: , a28 out nocopy JTF_VARCHAR2_TABLE_2000
241: , a29 out nocopy JTF_VARCHAR2_TABLE_2000
242: , a30 out nocopy JTF_VARCHAR2_TABLE_2000
235: , a23 out nocopy JTF_VARCHAR2_TABLE_100
236: , a24 out nocopy JTF_NUMBER_TABLE
237: , a25 out nocopy JTF_NUMBER_TABLE
238: , a26 out nocopy JTF_NUMBER_TABLE
239: , a27 out nocopy JTF_NUMBER_TABLE
240: , a28 out nocopy JTF_VARCHAR2_TABLE_2000
241: , a29 out nocopy JTF_VARCHAR2_TABLE_2000
242: , a30 out nocopy JTF_VARCHAR2_TABLE_2000
243: , a31 out nocopy JTF_VARCHAR2_TABLE_2000
240: , a28 out nocopy JTF_VARCHAR2_TABLE_2000
241: , a29 out nocopy JTF_VARCHAR2_TABLE_2000
242: , a30 out nocopy JTF_VARCHAR2_TABLE_2000
243: , a31 out nocopy JTF_VARCHAR2_TABLE_2000
244: , a32 out nocopy JTF_NUMBER_TABLE
245: , a33 out nocopy JTF_VARCHAR2_TABLE_200
246: , a34 out nocopy JTF_NUMBER_TABLE
247: , a35 out nocopy JTF_NUMBER_TABLE
248: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
242: , a30 out nocopy JTF_VARCHAR2_TABLE_2000
243: , a31 out nocopy JTF_VARCHAR2_TABLE_2000
244: , a32 out nocopy JTF_NUMBER_TABLE
245: , a33 out nocopy JTF_VARCHAR2_TABLE_200
246: , a34 out nocopy JTF_NUMBER_TABLE
247: , a35 out nocopy JTF_NUMBER_TABLE
248: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
249: , a37 out nocopy JTF_NUMBER_TABLE
250: , a38 out nocopy JTF_NUMBER_TABLE
243: , a31 out nocopy JTF_VARCHAR2_TABLE_2000
244: , a32 out nocopy JTF_NUMBER_TABLE
245: , a33 out nocopy JTF_VARCHAR2_TABLE_200
246: , a34 out nocopy JTF_NUMBER_TABLE
247: , a35 out nocopy JTF_NUMBER_TABLE
248: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
249: , a37 out nocopy JTF_NUMBER_TABLE
250: , a38 out nocopy JTF_NUMBER_TABLE
251: , a39 out nocopy JTF_NUMBER_TABLE
245: , a33 out nocopy JTF_VARCHAR2_TABLE_200
246: , a34 out nocopy JTF_NUMBER_TABLE
247: , a35 out nocopy JTF_NUMBER_TABLE
248: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
249: , a37 out nocopy JTF_NUMBER_TABLE
250: , a38 out nocopy JTF_NUMBER_TABLE
251: , a39 out nocopy JTF_NUMBER_TABLE
252: , a40 out nocopy JTF_VARCHAR2_TABLE_2000
253: , a41 out nocopy JTF_NUMBER_TABLE
246: , a34 out nocopy JTF_NUMBER_TABLE
247: , a35 out nocopy JTF_NUMBER_TABLE
248: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
249: , a37 out nocopy JTF_NUMBER_TABLE
250: , a38 out nocopy JTF_NUMBER_TABLE
251: , a39 out nocopy JTF_NUMBER_TABLE
252: , a40 out nocopy JTF_VARCHAR2_TABLE_2000
253: , a41 out nocopy JTF_NUMBER_TABLE
254: , a42 out nocopy JTF_VARCHAR2_TABLE_2000
247: , a35 out nocopy JTF_NUMBER_TABLE
248: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
249: , a37 out nocopy JTF_NUMBER_TABLE
250: , a38 out nocopy JTF_NUMBER_TABLE
251: , a39 out nocopy JTF_NUMBER_TABLE
252: , a40 out nocopy JTF_VARCHAR2_TABLE_2000
253: , a41 out nocopy JTF_NUMBER_TABLE
254: , a42 out nocopy JTF_VARCHAR2_TABLE_2000
255: ) as
249: , a37 out nocopy JTF_NUMBER_TABLE
250: , a38 out nocopy JTF_NUMBER_TABLE
251: , a39 out nocopy JTF_NUMBER_TABLE
252: , a40 out nocopy JTF_VARCHAR2_TABLE_2000
253: , a41 out nocopy JTF_NUMBER_TABLE
254: , a42 out nocopy JTF_VARCHAR2_TABLE_2000
255: ) as
256: ddindx binary_integer; indx binary_integer;
257: begin
255: ) as
256: ddindx binary_integer; indx binary_integer;
257: begin
258: if t is null or t.count = 0 then
259: a0 := JTF_NUMBER_TABLE();
260: a1 := JTF_DATE_TABLE();
261: a2 := JTF_DATE_TABLE();
262: a3 := JTF_DATE_TABLE();
263: a4 := JTF_NUMBER_TABLE();
259: a0 := JTF_NUMBER_TABLE();
260: a1 := JTF_DATE_TABLE();
261: a2 := JTF_DATE_TABLE();
262: a3 := JTF_DATE_TABLE();
263: a4 := JTF_NUMBER_TABLE();
264: a5 := JTF_NUMBER_TABLE();
265: a6 := JTF_NUMBER_TABLE();
266: a7 := JTF_NUMBER_TABLE();
267: a8 := JTF_NUMBER_TABLE();
260: a1 := JTF_DATE_TABLE();
261: a2 := JTF_DATE_TABLE();
262: a3 := JTF_DATE_TABLE();
263: a4 := JTF_NUMBER_TABLE();
264: a5 := JTF_NUMBER_TABLE();
265: a6 := JTF_NUMBER_TABLE();
266: a7 := JTF_NUMBER_TABLE();
267: a8 := JTF_NUMBER_TABLE();
268: a9 := JTF_NUMBER_TABLE();
261: a2 := JTF_DATE_TABLE();
262: a3 := JTF_DATE_TABLE();
263: a4 := JTF_NUMBER_TABLE();
264: a5 := JTF_NUMBER_TABLE();
265: a6 := JTF_NUMBER_TABLE();
266: a7 := JTF_NUMBER_TABLE();
267: a8 := JTF_NUMBER_TABLE();
268: a9 := JTF_NUMBER_TABLE();
269: a10 := JTF_NUMBER_TABLE();
262: a3 := JTF_DATE_TABLE();
263: a4 := JTF_NUMBER_TABLE();
264: a5 := JTF_NUMBER_TABLE();
265: a6 := JTF_NUMBER_TABLE();
266: a7 := JTF_NUMBER_TABLE();
267: a8 := JTF_NUMBER_TABLE();
268: a9 := JTF_NUMBER_TABLE();
269: a10 := JTF_NUMBER_TABLE();
270: a11 := JTF_NUMBER_TABLE();
263: a4 := JTF_NUMBER_TABLE();
264: a5 := JTF_NUMBER_TABLE();
265: a6 := JTF_NUMBER_TABLE();
266: a7 := JTF_NUMBER_TABLE();
267: a8 := JTF_NUMBER_TABLE();
268: a9 := JTF_NUMBER_TABLE();
269: a10 := JTF_NUMBER_TABLE();
270: a11 := JTF_NUMBER_TABLE();
271: a12 := JTF_NUMBER_TABLE();
264: a5 := JTF_NUMBER_TABLE();
265: a6 := JTF_NUMBER_TABLE();
266: a7 := JTF_NUMBER_TABLE();
267: a8 := JTF_NUMBER_TABLE();
268: a9 := JTF_NUMBER_TABLE();
269: a10 := JTF_NUMBER_TABLE();
270: a11 := JTF_NUMBER_TABLE();
271: a12 := JTF_NUMBER_TABLE();
272: a13 := JTF_NUMBER_TABLE();
265: a6 := JTF_NUMBER_TABLE();
266: a7 := JTF_NUMBER_TABLE();
267: a8 := JTF_NUMBER_TABLE();
268: a9 := JTF_NUMBER_TABLE();
269: a10 := JTF_NUMBER_TABLE();
270: a11 := JTF_NUMBER_TABLE();
271: a12 := JTF_NUMBER_TABLE();
272: a13 := JTF_NUMBER_TABLE();
273: a14 := JTF_NUMBER_TABLE();
266: a7 := JTF_NUMBER_TABLE();
267: a8 := JTF_NUMBER_TABLE();
268: a9 := JTF_NUMBER_TABLE();
269: a10 := JTF_NUMBER_TABLE();
270: a11 := JTF_NUMBER_TABLE();
271: a12 := JTF_NUMBER_TABLE();
272: a13 := JTF_NUMBER_TABLE();
273: a14 := JTF_NUMBER_TABLE();
274: a15 := JTF_NUMBER_TABLE();
267: a8 := JTF_NUMBER_TABLE();
268: a9 := JTF_NUMBER_TABLE();
269: a10 := JTF_NUMBER_TABLE();
270: a11 := JTF_NUMBER_TABLE();
271: a12 := JTF_NUMBER_TABLE();
272: a13 := JTF_NUMBER_TABLE();
273: a14 := JTF_NUMBER_TABLE();
274: a15 := JTF_NUMBER_TABLE();
275: a16 := JTF_NUMBER_TABLE();
268: a9 := JTF_NUMBER_TABLE();
269: a10 := JTF_NUMBER_TABLE();
270: a11 := JTF_NUMBER_TABLE();
271: a12 := JTF_NUMBER_TABLE();
272: a13 := JTF_NUMBER_TABLE();
273: a14 := JTF_NUMBER_TABLE();
274: a15 := JTF_NUMBER_TABLE();
275: a16 := JTF_NUMBER_TABLE();
276: a17 := JTF_NUMBER_TABLE();
269: a10 := JTF_NUMBER_TABLE();
270: a11 := JTF_NUMBER_TABLE();
271: a12 := JTF_NUMBER_TABLE();
272: a13 := JTF_NUMBER_TABLE();
273: a14 := JTF_NUMBER_TABLE();
274: a15 := JTF_NUMBER_TABLE();
275: a16 := JTF_NUMBER_TABLE();
276: a17 := JTF_NUMBER_TABLE();
277: a18 := JTF_NUMBER_TABLE();
270: a11 := JTF_NUMBER_TABLE();
271: a12 := JTF_NUMBER_TABLE();
272: a13 := JTF_NUMBER_TABLE();
273: a14 := JTF_NUMBER_TABLE();
274: a15 := JTF_NUMBER_TABLE();
275: a16 := JTF_NUMBER_TABLE();
276: a17 := JTF_NUMBER_TABLE();
277: a18 := JTF_NUMBER_TABLE();
278: a19 := JTF_NUMBER_TABLE();
271: a12 := JTF_NUMBER_TABLE();
272: a13 := JTF_NUMBER_TABLE();
273: a14 := JTF_NUMBER_TABLE();
274: a15 := JTF_NUMBER_TABLE();
275: a16 := JTF_NUMBER_TABLE();
276: a17 := JTF_NUMBER_TABLE();
277: a18 := JTF_NUMBER_TABLE();
278: a19 := JTF_NUMBER_TABLE();
279: a20 := JTF_NUMBER_TABLE();
272: a13 := JTF_NUMBER_TABLE();
273: a14 := JTF_NUMBER_TABLE();
274: a15 := JTF_NUMBER_TABLE();
275: a16 := JTF_NUMBER_TABLE();
276: a17 := JTF_NUMBER_TABLE();
277: a18 := JTF_NUMBER_TABLE();
278: a19 := JTF_NUMBER_TABLE();
279: a20 := JTF_NUMBER_TABLE();
280: a21 := JTF_VARCHAR2_TABLE_100();
273: a14 := JTF_NUMBER_TABLE();
274: a15 := JTF_NUMBER_TABLE();
275: a16 := JTF_NUMBER_TABLE();
276: a17 := JTF_NUMBER_TABLE();
277: a18 := JTF_NUMBER_TABLE();
278: a19 := JTF_NUMBER_TABLE();
279: a20 := JTF_NUMBER_TABLE();
280: a21 := JTF_VARCHAR2_TABLE_100();
281: a22 := JTF_VARCHAR2_TABLE_100();
274: a15 := JTF_NUMBER_TABLE();
275: a16 := JTF_NUMBER_TABLE();
276: a17 := JTF_NUMBER_TABLE();
277: a18 := JTF_NUMBER_TABLE();
278: a19 := JTF_NUMBER_TABLE();
279: a20 := JTF_NUMBER_TABLE();
280: a21 := JTF_VARCHAR2_TABLE_100();
281: a22 := JTF_VARCHAR2_TABLE_100();
282: a23 := JTF_VARCHAR2_TABLE_100();
275: a16 := JTF_NUMBER_TABLE();
276: a17 := JTF_NUMBER_TABLE();
277: a18 := JTF_NUMBER_TABLE();
278: a19 := JTF_NUMBER_TABLE();
279: a20 := JTF_NUMBER_TABLE();
280: a21 := JTF_VARCHAR2_TABLE_100();
281: a22 := JTF_VARCHAR2_TABLE_100();
282: a23 := JTF_VARCHAR2_TABLE_100();
283: a24 := JTF_NUMBER_TABLE();
279: a20 := JTF_NUMBER_TABLE();
280: a21 := JTF_VARCHAR2_TABLE_100();
281: a22 := JTF_VARCHAR2_TABLE_100();
282: a23 := JTF_VARCHAR2_TABLE_100();
283: a24 := JTF_NUMBER_TABLE();
284: a25 := JTF_NUMBER_TABLE();
285: a26 := JTF_NUMBER_TABLE();
286: a27 := JTF_NUMBER_TABLE();
287: a28 := JTF_VARCHAR2_TABLE_2000();
280: a21 := JTF_VARCHAR2_TABLE_100();
281: a22 := JTF_VARCHAR2_TABLE_100();
282: a23 := JTF_VARCHAR2_TABLE_100();
283: a24 := JTF_NUMBER_TABLE();
284: a25 := JTF_NUMBER_TABLE();
285: a26 := JTF_NUMBER_TABLE();
286: a27 := JTF_NUMBER_TABLE();
287: a28 := JTF_VARCHAR2_TABLE_2000();
288: a29 := JTF_VARCHAR2_TABLE_2000();
281: a22 := JTF_VARCHAR2_TABLE_100();
282: a23 := JTF_VARCHAR2_TABLE_100();
283: a24 := JTF_NUMBER_TABLE();
284: a25 := JTF_NUMBER_TABLE();
285: a26 := JTF_NUMBER_TABLE();
286: a27 := JTF_NUMBER_TABLE();
287: a28 := JTF_VARCHAR2_TABLE_2000();
288: a29 := JTF_VARCHAR2_TABLE_2000();
289: a30 := JTF_VARCHAR2_TABLE_2000();
282: a23 := JTF_VARCHAR2_TABLE_100();
283: a24 := JTF_NUMBER_TABLE();
284: a25 := JTF_NUMBER_TABLE();
285: a26 := JTF_NUMBER_TABLE();
286: a27 := JTF_NUMBER_TABLE();
287: a28 := JTF_VARCHAR2_TABLE_2000();
288: a29 := JTF_VARCHAR2_TABLE_2000();
289: a30 := JTF_VARCHAR2_TABLE_2000();
290: a31 := JTF_VARCHAR2_TABLE_2000();
287: a28 := JTF_VARCHAR2_TABLE_2000();
288: a29 := JTF_VARCHAR2_TABLE_2000();
289: a30 := JTF_VARCHAR2_TABLE_2000();
290: a31 := JTF_VARCHAR2_TABLE_2000();
291: a32 := JTF_NUMBER_TABLE();
292: a33 := JTF_VARCHAR2_TABLE_200();
293: a34 := JTF_NUMBER_TABLE();
294: a35 := JTF_NUMBER_TABLE();
295: a36 := JTF_VARCHAR2_TABLE_2000();
289: a30 := JTF_VARCHAR2_TABLE_2000();
290: a31 := JTF_VARCHAR2_TABLE_2000();
291: a32 := JTF_NUMBER_TABLE();
292: a33 := JTF_VARCHAR2_TABLE_200();
293: a34 := JTF_NUMBER_TABLE();
294: a35 := JTF_NUMBER_TABLE();
295: a36 := JTF_VARCHAR2_TABLE_2000();
296: a37 := JTF_NUMBER_TABLE();
297: a38 := JTF_NUMBER_TABLE();
290: a31 := JTF_VARCHAR2_TABLE_2000();
291: a32 := JTF_NUMBER_TABLE();
292: a33 := JTF_VARCHAR2_TABLE_200();
293: a34 := JTF_NUMBER_TABLE();
294: a35 := JTF_NUMBER_TABLE();
295: a36 := JTF_VARCHAR2_TABLE_2000();
296: a37 := JTF_NUMBER_TABLE();
297: a38 := JTF_NUMBER_TABLE();
298: a39 := JTF_NUMBER_TABLE();
292: a33 := JTF_VARCHAR2_TABLE_200();
293: a34 := JTF_NUMBER_TABLE();
294: a35 := JTF_NUMBER_TABLE();
295: a36 := JTF_VARCHAR2_TABLE_2000();
296: a37 := JTF_NUMBER_TABLE();
297: a38 := JTF_NUMBER_TABLE();
298: a39 := JTF_NUMBER_TABLE();
299: a40 := JTF_VARCHAR2_TABLE_2000();
300: a41 := JTF_NUMBER_TABLE();
293: a34 := JTF_NUMBER_TABLE();
294: a35 := JTF_NUMBER_TABLE();
295: a36 := JTF_VARCHAR2_TABLE_2000();
296: a37 := JTF_NUMBER_TABLE();
297: a38 := JTF_NUMBER_TABLE();
298: a39 := JTF_NUMBER_TABLE();
299: a40 := JTF_VARCHAR2_TABLE_2000();
300: a41 := JTF_NUMBER_TABLE();
301: a42 := JTF_VARCHAR2_TABLE_2000();
294: a35 := JTF_NUMBER_TABLE();
295: a36 := JTF_VARCHAR2_TABLE_2000();
296: a37 := JTF_NUMBER_TABLE();
297: a38 := JTF_NUMBER_TABLE();
298: a39 := JTF_NUMBER_TABLE();
299: a40 := JTF_VARCHAR2_TABLE_2000();
300: a41 := JTF_NUMBER_TABLE();
301: a42 := JTF_VARCHAR2_TABLE_2000();
302: else
296: a37 := JTF_NUMBER_TABLE();
297: a38 := JTF_NUMBER_TABLE();
298: a39 := JTF_NUMBER_TABLE();
299: a40 := JTF_VARCHAR2_TABLE_2000();
300: a41 := JTF_NUMBER_TABLE();
301: a42 := JTF_VARCHAR2_TABLE_2000();
302: else
303: a0 := JTF_NUMBER_TABLE();
304: a1 := JTF_DATE_TABLE();
299: a40 := JTF_VARCHAR2_TABLE_2000();
300: a41 := JTF_NUMBER_TABLE();
301: a42 := JTF_VARCHAR2_TABLE_2000();
302: else
303: a0 := JTF_NUMBER_TABLE();
304: a1 := JTF_DATE_TABLE();
305: a2 := JTF_DATE_TABLE();
306: a3 := JTF_DATE_TABLE();
307: a4 := JTF_NUMBER_TABLE();
303: a0 := JTF_NUMBER_TABLE();
304: a1 := JTF_DATE_TABLE();
305: a2 := JTF_DATE_TABLE();
306: a3 := JTF_DATE_TABLE();
307: a4 := JTF_NUMBER_TABLE();
308: a5 := JTF_NUMBER_TABLE();
309: a6 := JTF_NUMBER_TABLE();
310: a7 := JTF_NUMBER_TABLE();
311: a8 := JTF_NUMBER_TABLE();
304: a1 := JTF_DATE_TABLE();
305: a2 := JTF_DATE_TABLE();
306: a3 := JTF_DATE_TABLE();
307: a4 := JTF_NUMBER_TABLE();
308: a5 := JTF_NUMBER_TABLE();
309: a6 := JTF_NUMBER_TABLE();
310: a7 := JTF_NUMBER_TABLE();
311: a8 := JTF_NUMBER_TABLE();
312: a9 := JTF_NUMBER_TABLE();
305: a2 := JTF_DATE_TABLE();
306: a3 := JTF_DATE_TABLE();
307: a4 := JTF_NUMBER_TABLE();
308: a5 := JTF_NUMBER_TABLE();
309: a6 := JTF_NUMBER_TABLE();
310: a7 := JTF_NUMBER_TABLE();
311: a8 := JTF_NUMBER_TABLE();
312: a9 := JTF_NUMBER_TABLE();
313: a10 := JTF_NUMBER_TABLE();
306: a3 := JTF_DATE_TABLE();
307: a4 := JTF_NUMBER_TABLE();
308: a5 := JTF_NUMBER_TABLE();
309: a6 := JTF_NUMBER_TABLE();
310: a7 := JTF_NUMBER_TABLE();
311: a8 := JTF_NUMBER_TABLE();
312: a9 := JTF_NUMBER_TABLE();
313: a10 := JTF_NUMBER_TABLE();
314: a11 := JTF_NUMBER_TABLE();
307: a4 := JTF_NUMBER_TABLE();
308: a5 := JTF_NUMBER_TABLE();
309: a6 := JTF_NUMBER_TABLE();
310: a7 := JTF_NUMBER_TABLE();
311: a8 := JTF_NUMBER_TABLE();
312: a9 := JTF_NUMBER_TABLE();
313: a10 := JTF_NUMBER_TABLE();
314: a11 := JTF_NUMBER_TABLE();
315: a12 := JTF_NUMBER_TABLE();
308: a5 := JTF_NUMBER_TABLE();
309: a6 := JTF_NUMBER_TABLE();
310: a7 := JTF_NUMBER_TABLE();
311: a8 := JTF_NUMBER_TABLE();
312: a9 := JTF_NUMBER_TABLE();
313: a10 := JTF_NUMBER_TABLE();
314: a11 := JTF_NUMBER_TABLE();
315: a12 := JTF_NUMBER_TABLE();
316: a13 := JTF_NUMBER_TABLE();
309: a6 := JTF_NUMBER_TABLE();
310: a7 := JTF_NUMBER_TABLE();
311: a8 := JTF_NUMBER_TABLE();
312: a9 := JTF_NUMBER_TABLE();
313: a10 := JTF_NUMBER_TABLE();
314: a11 := JTF_NUMBER_TABLE();
315: a12 := JTF_NUMBER_TABLE();
316: a13 := JTF_NUMBER_TABLE();
317: a14 := JTF_NUMBER_TABLE();
310: a7 := JTF_NUMBER_TABLE();
311: a8 := JTF_NUMBER_TABLE();
312: a9 := JTF_NUMBER_TABLE();
313: a10 := JTF_NUMBER_TABLE();
314: a11 := JTF_NUMBER_TABLE();
315: a12 := JTF_NUMBER_TABLE();
316: a13 := JTF_NUMBER_TABLE();
317: a14 := JTF_NUMBER_TABLE();
318: a15 := JTF_NUMBER_TABLE();
311: a8 := JTF_NUMBER_TABLE();
312: a9 := JTF_NUMBER_TABLE();
313: a10 := JTF_NUMBER_TABLE();
314: a11 := JTF_NUMBER_TABLE();
315: a12 := JTF_NUMBER_TABLE();
316: a13 := JTF_NUMBER_TABLE();
317: a14 := JTF_NUMBER_TABLE();
318: a15 := JTF_NUMBER_TABLE();
319: a16 := JTF_NUMBER_TABLE();
312: a9 := JTF_NUMBER_TABLE();
313: a10 := JTF_NUMBER_TABLE();
314: a11 := JTF_NUMBER_TABLE();
315: a12 := JTF_NUMBER_TABLE();
316: a13 := JTF_NUMBER_TABLE();
317: a14 := JTF_NUMBER_TABLE();
318: a15 := JTF_NUMBER_TABLE();
319: a16 := JTF_NUMBER_TABLE();
320: a17 := JTF_NUMBER_TABLE();
313: a10 := JTF_NUMBER_TABLE();
314: a11 := JTF_NUMBER_TABLE();
315: a12 := JTF_NUMBER_TABLE();
316: a13 := JTF_NUMBER_TABLE();
317: a14 := JTF_NUMBER_TABLE();
318: a15 := JTF_NUMBER_TABLE();
319: a16 := JTF_NUMBER_TABLE();
320: a17 := JTF_NUMBER_TABLE();
321: a18 := JTF_NUMBER_TABLE();
314: a11 := JTF_NUMBER_TABLE();
315: a12 := JTF_NUMBER_TABLE();
316: a13 := JTF_NUMBER_TABLE();
317: a14 := JTF_NUMBER_TABLE();
318: a15 := JTF_NUMBER_TABLE();
319: a16 := JTF_NUMBER_TABLE();
320: a17 := JTF_NUMBER_TABLE();
321: a18 := JTF_NUMBER_TABLE();
322: a19 := JTF_NUMBER_TABLE();
315: a12 := JTF_NUMBER_TABLE();
316: a13 := JTF_NUMBER_TABLE();
317: a14 := JTF_NUMBER_TABLE();
318: a15 := JTF_NUMBER_TABLE();
319: a16 := JTF_NUMBER_TABLE();
320: a17 := JTF_NUMBER_TABLE();
321: a18 := JTF_NUMBER_TABLE();
322: a19 := JTF_NUMBER_TABLE();
323: a20 := JTF_NUMBER_TABLE();
316: a13 := JTF_NUMBER_TABLE();
317: a14 := JTF_NUMBER_TABLE();
318: a15 := JTF_NUMBER_TABLE();
319: a16 := JTF_NUMBER_TABLE();
320: a17 := JTF_NUMBER_TABLE();
321: a18 := JTF_NUMBER_TABLE();
322: a19 := JTF_NUMBER_TABLE();
323: a20 := JTF_NUMBER_TABLE();
324: a21 := JTF_VARCHAR2_TABLE_100();
317: a14 := JTF_NUMBER_TABLE();
318: a15 := JTF_NUMBER_TABLE();
319: a16 := JTF_NUMBER_TABLE();
320: a17 := JTF_NUMBER_TABLE();
321: a18 := JTF_NUMBER_TABLE();
322: a19 := JTF_NUMBER_TABLE();
323: a20 := JTF_NUMBER_TABLE();
324: a21 := JTF_VARCHAR2_TABLE_100();
325: a22 := JTF_VARCHAR2_TABLE_100();
318: a15 := JTF_NUMBER_TABLE();
319: a16 := JTF_NUMBER_TABLE();
320: a17 := JTF_NUMBER_TABLE();
321: a18 := JTF_NUMBER_TABLE();
322: a19 := JTF_NUMBER_TABLE();
323: a20 := JTF_NUMBER_TABLE();
324: a21 := JTF_VARCHAR2_TABLE_100();
325: a22 := JTF_VARCHAR2_TABLE_100();
326: a23 := JTF_VARCHAR2_TABLE_100();
319: a16 := JTF_NUMBER_TABLE();
320: a17 := JTF_NUMBER_TABLE();
321: a18 := JTF_NUMBER_TABLE();
322: a19 := JTF_NUMBER_TABLE();
323: a20 := JTF_NUMBER_TABLE();
324: a21 := JTF_VARCHAR2_TABLE_100();
325: a22 := JTF_VARCHAR2_TABLE_100();
326: a23 := JTF_VARCHAR2_TABLE_100();
327: a24 := JTF_NUMBER_TABLE();
323: a20 := JTF_NUMBER_TABLE();
324: a21 := JTF_VARCHAR2_TABLE_100();
325: a22 := JTF_VARCHAR2_TABLE_100();
326: a23 := JTF_VARCHAR2_TABLE_100();
327: a24 := JTF_NUMBER_TABLE();
328: a25 := JTF_NUMBER_TABLE();
329: a26 := JTF_NUMBER_TABLE();
330: a27 := JTF_NUMBER_TABLE();
331: a28 := JTF_VARCHAR2_TABLE_2000();
324: a21 := JTF_VARCHAR2_TABLE_100();
325: a22 := JTF_VARCHAR2_TABLE_100();
326: a23 := JTF_VARCHAR2_TABLE_100();
327: a24 := JTF_NUMBER_TABLE();
328: a25 := JTF_NUMBER_TABLE();
329: a26 := JTF_NUMBER_TABLE();
330: a27 := JTF_NUMBER_TABLE();
331: a28 := JTF_VARCHAR2_TABLE_2000();
332: a29 := JTF_VARCHAR2_TABLE_2000();
325: a22 := JTF_VARCHAR2_TABLE_100();
326: a23 := JTF_VARCHAR2_TABLE_100();
327: a24 := JTF_NUMBER_TABLE();
328: a25 := JTF_NUMBER_TABLE();
329: a26 := JTF_NUMBER_TABLE();
330: a27 := JTF_NUMBER_TABLE();
331: a28 := JTF_VARCHAR2_TABLE_2000();
332: a29 := JTF_VARCHAR2_TABLE_2000();
333: a30 := JTF_VARCHAR2_TABLE_2000();
326: a23 := JTF_VARCHAR2_TABLE_100();
327: a24 := JTF_NUMBER_TABLE();
328: a25 := JTF_NUMBER_TABLE();
329: a26 := JTF_NUMBER_TABLE();
330: a27 := JTF_NUMBER_TABLE();
331: a28 := JTF_VARCHAR2_TABLE_2000();
332: a29 := JTF_VARCHAR2_TABLE_2000();
333: a30 := JTF_VARCHAR2_TABLE_2000();
334: a31 := JTF_VARCHAR2_TABLE_2000();
331: a28 := JTF_VARCHAR2_TABLE_2000();
332: a29 := JTF_VARCHAR2_TABLE_2000();
333: a30 := JTF_VARCHAR2_TABLE_2000();
334: a31 := JTF_VARCHAR2_TABLE_2000();
335: a32 := JTF_NUMBER_TABLE();
336: a33 := JTF_VARCHAR2_TABLE_200();
337: a34 := JTF_NUMBER_TABLE();
338: a35 := JTF_NUMBER_TABLE();
339: a36 := JTF_VARCHAR2_TABLE_2000();
333: a30 := JTF_VARCHAR2_TABLE_2000();
334: a31 := JTF_VARCHAR2_TABLE_2000();
335: a32 := JTF_NUMBER_TABLE();
336: a33 := JTF_VARCHAR2_TABLE_200();
337: a34 := JTF_NUMBER_TABLE();
338: a35 := JTF_NUMBER_TABLE();
339: a36 := JTF_VARCHAR2_TABLE_2000();
340: a37 := JTF_NUMBER_TABLE();
341: a38 := JTF_NUMBER_TABLE();
334: a31 := JTF_VARCHAR2_TABLE_2000();
335: a32 := JTF_NUMBER_TABLE();
336: a33 := JTF_VARCHAR2_TABLE_200();
337: a34 := JTF_NUMBER_TABLE();
338: a35 := JTF_NUMBER_TABLE();
339: a36 := JTF_VARCHAR2_TABLE_2000();
340: a37 := JTF_NUMBER_TABLE();
341: a38 := JTF_NUMBER_TABLE();
342: a39 := JTF_NUMBER_TABLE();
336: a33 := JTF_VARCHAR2_TABLE_200();
337: a34 := JTF_NUMBER_TABLE();
338: a35 := JTF_NUMBER_TABLE();
339: a36 := JTF_VARCHAR2_TABLE_2000();
340: a37 := JTF_NUMBER_TABLE();
341: a38 := JTF_NUMBER_TABLE();
342: a39 := JTF_NUMBER_TABLE();
343: a40 := JTF_VARCHAR2_TABLE_2000();
344: a41 := JTF_NUMBER_TABLE();
337: a34 := JTF_NUMBER_TABLE();
338: a35 := JTF_NUMBER_TABLE();
339: a36 := JTF_VARCHAR2_TABLE_2000();
340: a37 := JTF_NUMBER_TABLE();
341: a38 := JTF_NUMBER_TABLE();
342: a39 := JTF_NUMBER_TABLE();
343: a40 := JTF_VARCHAR2_TABLE_2000();
344: a41 := JTF_NUMBER_TABLE();
345: a42 := JTF_VARCHAR2_TABLE_2000();
338: a35 := JTF_NUMBER_TABLE();
339: a36 := JTF_VARCHAR2_TABLE_2000();
340: a37 := JTF_NUMBER_TABLE();
341: a38 := JTF_NUMBER_TABLE();
342: a39 := JTF_NUMBER_TABLE();
343: a40 := JTF_VARCHAR2_TABLE_2000();
344: a41 := JTF_NUMBER_TABLE();
345: a42 := JTF_VARCHAR2_TABLE_2000();
346: if t.count > 0 then
340: a37 := JTF_NUMBER_TABLE();
341: a38 := JTF_NUMBER_TABLE();
342: a39 := JTF_NUMBER_TABLE();
343: a40 := JTF_VARCHAR2_TABLE_2000();
344: a41 := JTF_NUMBER_TABLE();
345: a42 := JTF_VARCHAR2_TABLE_2000();
346: if t.count > 0 then
347: a0.extend(t.count);
348: a1.extend(t.count);
442: end if;
443: end if;
444: end rosetta_table_copy_out_p3;
445:
446: procedure rosetta_table_copy_in_p6(t out nocopy lns_financials.payoff_tbl, a0 JTF_NUMBER_TABLE
447: , a1 JTF_NUMBER_TABLE
448: , a2 JTF_NUMBER_TABLE
449: , a3 JTF_NUMBER_TABLE
450: , a4 JTF_NUMBER_TABLE
443: end if;
444: end rosetta_table_copy_out_p3;
445:
446: procedure rosetta_table_copy_in_p6(t out nocopy lns_financials.payoff_tbl, a0 JTF_NUMBER_TABLE
447: , a1 JTF_NUMBER_TABLE
448: , a2 JTF_NUMBER_TABLE
449: , a3 JTF_NUMBER_TABLE
450: , a4 JTF_NUMBER_TABLE
451: , a5 JTF_NUMBER_TABLE
444: end rosetta_table_copy_out_p3;
445:
446: procedure rosetta_table_copy_in_p6(t out nocopy lns_financials.payoff_tbl, a0 JTF_NUMBER_TABLE
447: , a1 JTF_NUMBER_TABLE
448: , a2 JTF_NUMBER_TABLE
449: , a3 JTF_NUMBER_TABLE
450: , a4 JTF_NUMBER_TABLE
451: , a5 JTF_NUMBER_TABLE
452: , a6 JTF_NUMBER_TABLE
445:
446: procedure rosetta_table_copy_in_p6(t out nocopy lns_financials.payoff_tbl, a0 JTF_NUMBER_TABLE
447: , a1 JTF_NUMBER_TABLE
448: , a2 JTF_NUMBER_TABLE
449: , a3 JTF_NUMBER_TABLE
450: , a4 JTF_NUMBER_TABLE
451: , a5 JTF_NUMBER_TABLE
452: , a6 JTF_NUMBER_TABLE
453: , a7 JTF_NUMBER_TABLE
446: procedure rosetta_table_copy_in_p6(t out nocopy lns_financials.payoff_tbl, a0 JTF_NUMBER_TABLE
447: , a1 JTF_NUMBER_TABLE
448: , a2 JTF_NUMBER_TABLE
449: , a3 JTF_NUMBER_TABLE
450: , a4 JTF_NUMBER_TABLE
451: , a5 JTF_NUMBER_TABLE
452: , a6 JTF_NUMBER_TABLE
453: , a7 JTF_NUMBER_TABLE
454: , a8 JTF_NUMBER_TABLE
447: , a1 JTF_NUMBER_TABLE
448: , a2 JTF_NUMBER_TABLE
449: , a3 JTF_NUMBER_TABLE
450: , a4 JTF_NUMBER_TABLE
451: , a5 JTF_NUMBER_TABLE
452: , a6 JTF_NUMBER_TABLE
453: , a7 JTF_NUMBER_TABLE
454: , a8 JTF_NUMBER_TABLE
455: , a9 JTF_DATE_TABLE
448: , a2 JTF_NUMBER_TABLE
449: , a3 JTF_NUMBER_TABLE
450: , a4 JTF_NUMBER_TABLE
451: , a5 JTF_NUMBER_TABLE
452: , a6 JTF_NUMBER_TABLE
453: , a7 JTF_NUMBER_TABLE
454: , a8 JTF_NUMBER_TABLE
455: , a9 JTF_DATE_TABLE
456: ) as
449: , a3 JTF_NUMBER_TABLE
450: , a4 JTF_NUMBER_TABLE
451: , a5 JTF_NUMBER_TABLE
452: , a6 JTF_NUMBER_TABLE
453: , a7 JTF_NUMBER_TABLE
454: , a8 JTF_NUMBER_TABLE
455: , a9 JTF_DATE_TABLE
456: ) as
457: ddindx binary_integer; indx binary_integer;
450: , a4 JTF_NUMBER_TABLE
451: , a5 JTF_NUMBER_TABLE
452: , a6 JTF_NUMBER_TABLE
453: , a7 JTF_NUMBER_TABLE
454: , a8 JTF_NUMBER_TABLE
455: , a9 JTF_DATE_TABLE
456: ) as
457: ddindx binary_integer; indx binary_integer;
458: begin
479: end loop;
480: end if;
481: end if;
482: end rosetta_table_copy_in_p6;
483: procedure rosetta_table_copy_out_p6(t lns_financials.payoff_tbl, a0 out nocopy JTF_NUMBER_TABLE
484: , a1 out nocopy JTF_NUMBER_TABLE
485: , a2 out nocopy JTF_NUMBER_TABLE
486: , a3 out nocopy JTF_NUMBER_TABLE
487: , a4 out nocopy JTF_NUMBER_TABLE
480: end if;
481: end if;
482: end rosetta_table_copy_in_p6;
483: procedure rosetta_table_copy_out_p6(t lns_financials.payoff_tbl, a0 out nocopy JTF_NUMBER_TABLE
484: , a1 out nocopy JTF_NUMBER_TABLE
485: , a2 out nocopy JTF_NUMBER_TABLE
486: , a3 out nocopy JTF_NUMBER_TABLE
487: , a4 out nocopy JTF_NUMBER_TABLE
488: , a5 out nocopy JTF_NUMBER_TABLE
481: end if;
482: end rosetta_table_copy_in_p6;
483: procedure rosetta_table_copy_out_p6(t lns_financials.payoff_tbl, a0 out nocopy JTF_NUMBER_TABLE
484: , a1 out nocopy JTF_NUMBER_TABLE
485: , a2 out nocopy JTF_NUMBER_TABLE
486: , a3 out nocopy JTF_NUMBER_TABLE
487: , a4 out nocopy JTF_NUMBER_TABLE
488: , a5 out nocopy JTF_NUMBER_TABLE
489: , a6 out nocopy JTF_NUMBER_TABLE
482: end rosetta_table_copy_in_p6;
483: procedure rosetta_table_copy_out_p6(t lns_financials.payoff_tbl, a0 out nocopy JTF_NUMBER_TABLE
484: , a1 out nocopy JTF_NUMBER_TABLE
485: , a2 out nocopy JTF_NUMBER_TABLE
486: , a3 out nocopy JTF_NUMBER_TABLE
487: , a4 out nocopy JTF_NUMBER_TABLE
488: , a5 out nocopy JTF_NUMBER_TABLE
489: , a6 out nocopy JTF_NUMBER_TABLE
490: , a7 out nocopy JTF_NUMBER_TABLE
483: procedure rosetta_table_copy_out_p6(t lns_financials.payoff_tbl, a0 out nocopy JTF_NUMBER_TABLE
484: , a1 out nocopy JTF_NUMBER_TABLE
485: , a2 out nocopy JTF_NUMBER_TABLE
486: , a3 out nocopy JTF_NUMBER_TABLE
487: , a4 out nocopy JTF_NUMBER_TABLE
488: , a5 out nocopy JTF_NUMBER_TABLE
489: , a6 out nocopy JTF_NUMBER_TABLE
490: , a7 out nocopy JTF_NUMBER_TABLE
491: , a8 out nocopy JTF_NUMBER_TABLE
484: , a1 out nocopy JTF_NUMBER_TABLE
485: , a2 out nocopy JTF_NUMBER_TABLE
486: , a3 out nocopy JTF_NUMBER_TABLE
487: , a4 out nocopy JTF_NUMBER_TABLE
488: , a5 out nocopy JTF_NUMBER_TABLE
489: , a6 out nocopy JTF_NUMBER_TABLE
490: , a7 out nocopy JTF_NUMBER_TABLE
491: , a8 out nocopy JTF_NUMBER_TABLE
492: , a9 out nocopy JTF_DATE_TABLE
485: , a2 out nocopy JTF_NUMBER_TABLE
486: , a3 out nocopy JTF_NUMBER_TABLE
487: , a4 out nocopy JTF_NUMBER_TABLE
488: , a5 out nocopy JTF_NUMBER_TABLE
489: , a6 out nocopy JTF_NUMBER_TABLE
490: , a7 out nocopy JTF_NUMBER_TABLE
491: , a8 out nocopy JTF_NUMBER_TABLE
492: , a9 out nocopy JTF_DATE_TABLE
493: ) as
486: , a3 out nocopy JTF_NUMBER_TABLE
487: , a4 out nocopy JTF_NUMBER_TABLE
488: , a5 out nocopy JTF_NUMBER_TABLE
489: , a6 out nocopy JTF_NUMBER_TABLE
490: , a7 out nocopy JTF_NUMBER_TABLE
491: , a8 out nocopy JTF_NUMBER_TABLE
492: , a9 out nocopy JTF_DATE_TABLE
493: ) as
494: ddindx binary_integer; indx binary_integer;
487: , a4 out nocopy JTF_NUMBER_TABLE
488: , a5 out nocopy JTF_NUMBER_TABLE
489: , a6 out nocopy JTF_NUMBER_TABLE
490: , a7 out nocopy JTF_NUMBER_TABLE
491: , a8 out nocopy JTF_NUMBER_TABLE
492: , a9 out nocopy JTF_DATE_TABLE
493: ) as
494: ddindx binary_integer; indx binary_integer;
495: begin
493: ) as
494: ddindx binary_integer; indx binary_integer;
495: begin
496: if t is null or t.count = 0 then
497: a0 := JTF_NUMBER_TABLE();
498: a1 := JTF_NUMBER_TABLE();
499: a2 := JTF_NUMBER_TABLE();
500: a3 := JTF_NUMBER_TABLE();
501: a4 := JTF_NUMBER_TABLE();
494: ddindx binary_integer; indx binary_integer;
495: begin
496: if t is null or t.count = 0 then
497: a0 := JTF_NUMBER_TABLE();
498: a1 := JTF_NUMBER_TABLE();
499: a2 := JTF_NUMBER_TABLE();
500: a3 := JTF_NUMBER_TABLE();
501: a4 := JTF_NUMBER_TABLE();
502: a5 := JTF_NUMBER_TABLE();
495: begin
496: if t is null or t.count = 0 then
497: a0 := JTF_NUMBER_TABLE();
498: a1 := JTF_NUMBER_TABLE();
499: a2 := JTF_NUMBER_TABLE();
500: a3 := JTF_NUMBER_TABLE();
501: a4 := JTF_NUMBER_TABLE();
502: a5 := JTF_NUMBER_TABLE();
503: a6 := JTF_NUMBER_TABLE();
496: if t is null or t.count = 0 then
497: a0 := JTF_NUMBER_TABLE();
498: a1 := JTF_NUMBER_TABLE();
499: a2 := JTF_NUMBER_TABLE();
500: a3 := JTF_NUMBER_TABLE();
501: a4 := JTF_NUMBER_TABLE();
502: a5 := JTF_NUMBER_TABLE();
503: a6 := JTF_NUMBER_TABLE();
504: a7 := JTF_NUMBER_TABLE();
497: a0 := JTF_NUMBER_TABLE();
498: a1 := JTF_NUMBER_TABLE();
499: a2 := JTF_NUMBER_TABLE();
500: a3 := JTF_NUMBER_TABLE();
501: a4 := JTF_NUMBER_TABLE();
502: a5 := JTF_NUMBER_TABLE();
503: a6 := JTF_NUMBER_TABLE();
504: a7 := JTF_NUMBER_TABLE();
505: a8 := JTF_NUMBER_TABLE();
498: a1 := JTF_NUMBER_TABLE();
499: a2 := JTF_NUMBER_TABLE();
500: a3 := JTF_NUMBER_TABLE();
501: a4 := JTF_NUMBER_TABLE();
502: a5 := JTF_NUMBER_TABLE();
503: a6 := JTF_NUMBER_TABLE();
504: a7 := JTF_NUMBER_TABLE();
505: a8 := JTF_NUMBER_TABLE();
506: a9 := JTF_DATE_TABLE();
499: a2 := JTF_NUMBER_TABLE();
500: a3 := JTF_NUMBER_TABLE();
501: a4 := JTF_NUMBER_TABLE();
502: a5 := JTF_NUMBER_TABLE();
503: a6 := JTF_NUMBER_TABLE();
504: a7 := JTF_NUMBER_TABLE();
505: a8 := JTF_NUMBER_TABLE();
506: a9 := JTF_DATE_TABLE();
507: else
500: a3 := JTF_NUMBER_TABLE();
501: a4 := JTF_NUMBER_TABLE();
502: a5 := JTF_NUMBER_TABLE();
503: a6 := JTF_NUMBER_TABLE();
504: a7 := JTF_NUMBER_TABLE();
505: a8 := JTF_NUMBER_TABLE();
506: a9 := JTF_DATE_TABLE();
507: else
508: a0 := JTF_NUMBER_TABLE();
501: a4 := JTF_NUMBER_TABLE();
502: a5 := JTF_NUMBER_TABLE();
503: a6 := JTF_NUMBER_TABLE();
504: a7 := JTF_NUMBER_TABLE();
505: a8 := JTF_NUMBER_TABLE();
506: a9 := JTF_DATE_TABLE();
507: else
508: a0 := JTF_NUMBER_TABLE();
509: a1 := JTF_NUMBER_TABLE();
504: a7 := JTF_NUMBER_TABLE();
505: a8 := JTF_NUMBER_TABLE();
506: a9 := JTF_DATE_TABLE();
507: else
508: a0 := JTF_NUMBER_TABLE();
509: a1 := JTF_NUMBER_TABLE();
510: a2 := JTF_NUMBER_TABLE();
511: a3 := JTF_NUMBER_TABLE();
512: a4 := JTF_NUMBER_TABLE();
505: a8 := JTF_NUMBER_TABLE();
506: a9 := JTF_DATE_TABLE();
507: else
508: a0 := JTF_NUMBER_TABLE();
509: a1 := JTF_NUMBER_TABLE();
510: a2 := JTF_NUMBER_TABLE();
511: a3 := JTF_NUMBER_TABLE();
512: a4 := JTF_NUMBER_TABLE();
513: a5 := JTF_NUMBER_TABLE();
506: a9 := JTF_DATE_TABLE();
507: else
508: a0 := JTF_NUMBER_TABLE();
509: a1 := JTF_NUMBER_TABLE();
510: a2 := JTF_NUMBER_TABLE();
511: a3 := JTF_NUMBER_TABLE();
512: a4 := JTF_NUMBER_TABLE();
513: a5 := JTF_NUMBER_TABLE();
514: a6 := JTF_NUMBER_TABLE();
507: else
508: a0 := JTF_NUMBER_TABLE();
509: a1 := JTF_NUMBER_TABLE();
510: a2 := JTF_NUMBER_TABLE();
511: a3 := JTF_NUMBER_TABLE();
512: a4 := JTF_NUMBER_TABLE();
513: a5 := JTF_NUMBER_TABLE();
514: a6 := JTF_NUMBER_TABLE();
515: a7 := JTF_NUMBER_TABLE();
508: a0 := JTF_NUMBER_TABLE();
509: a1 := JTF_NUMBER_TABLE();
510: a2 := JTF_NUMBER_TABLE();
511: a3 := JTF_NUMBER_TABLE();
512: a4 := JTF_NUMBER_TABLE();
513: a5 := JTF_NUMBER_TABLE();
514: a6 := JTF_NUMBER_TABLE();
515: a7 := JTF_NUMBER_TABLE();
516: a8 := JTF_NUMBER_TABLE();
509: a1 := JTF_NUMBER_TABLE();
510: a2 := JTF_NUMBER_TABLE();
511: a3 := JTF_NUMBER_TABLE();
512: a4 := JTF_NUMBER_TABLE();
513: a5 := JTF_NUMBER_TABLE();
514: a6 := JTF_NUMBER_TABLE();
515: a7 := JTF_NUMBER_TABLE();
516: a8 := JTF_NUMBER_TABLE();
517: a9 := JTF_DATE_TABLE();
510: a2 := JTF_NUMBER_TABLE();
511: a3 := JTF_NUMBER_TABLE();
512: a4 := JTF_NUMBER_TABLE();
513: a5 := JTF_NUMBER_TABLE();
514: a6 := JTF_NUMBER_TABLE();
515: a7 := JTF_NUMBER_TABLE();
516: a8 := JTF_NUMBER_TABLE();
517: a9 := JTF_DATE_TABLE();
518: if t.count > 0 then
511: a3 := JTF_NUMBER_TABLE();
512: a4 := JTF_NUMBER_TABLE();
513: a5 := JTF_NUMBER_TABLE();
514: a6 := JTF_NUMBER_TABLE();
515: a7 := JTF_NUMBER_TABLE();
516: a8 := JTF_NUMBER_TABLE();
517: a9 := JTF_DATE_TABLE();
518: if t.count > 0 then
519: a0.extend(t.count);
512: a4 := JTF_NUMBER_TABLE();
513: a5 := JTF_NUMBER_TABLE();
514: a6 := JTF_NUMBER_TABLE();
515: a7 := JTF_NUMBER_TABLE();
516: a8 := JTF_NUMBER_TABLE();
517: a9 := JTF_DATE_TABLE();
518: if t.count > 0 then
519: a0.extend(t.count);
520: a1.extend(t.count);
549: end if;
550: end rosetta_table_copy_out_p6;
551:
552: procedure rosetta_table_copy_in_p8(t out nocopy lns_financials.payoff_tbl2, a0 JTF_VARCHAR2_TABLE_100
553: , a1 JTF_NUMBER_TABLE
554: , a2 JTF_NUMBER_TABLE
555: , a3 JTF_NUMBER_TABLE
556: ) as
557: ddindx binary_integer; indx binary_integer;
550: end rosetta_table_copy_out_p6;
551:
552: procedure rosetta_table_copy_in_p8(t out nocopy lns_financials.payoff_tbl2, a0 JTF_VARCHAR2_TABLE_100
553: , a1 JTF_NUMBER_TABLE
554: , a2 JTF_NUMBER_TABLE
555: , a3 JTF_NUMBER_TABLE
556: ) as
557: ddindx binary_integer; indx binary_integer;
558: begin
551:
552: procedure rosetta_table_copy_in_p8(t out nocopy lns_financials.payoff_tbl2, a0 JTF_VARCHAR2_TABLE_100
553: , a1 JTF_NUMBER_TABLE
554: , a2 JTF_NUMBER_TABLE
555: , a3 JTF_NUMBER_TABLE
556: ) as
557: ddindx binary_integer; indx binary_integer;
558: begin
559: if a0 is not null and a0.count > 0 then
574: end if;
575: end if;
576: end rosetta_table_copy_in_p8;
577: procedure rosetta_table_copy_out_p8(t lns_financials.payoff_tbl2, a0 out nocopy JTF_VARCHAR2_TABLE_100
578: , a1 out nocopy JTF_NUMBER_TABLE
579: , a2 out nocopy JTF_NUMBER_TABLE
580: , a3 out nocopy JTF_NUMBER_TABLE
581: ) as
582: ddindx binary_integer; indx binary_integer;
575: end if;
576: end rosetta_table_copy_in_p8;
577: procedure rosetta_table_copy_out_p8(t lns_financials.payoff_tbl2, a0 out nocopy JTF_VARCHAR2_TABLE_100
578: , a1 out nocopy JTF_NUMBER_TABLE
579: , a2 out nocopy JTF_NUMBER_TABLE
580: , a3 out nocopy JTF_NUMBER_TABLE
581: ) as
582: ddindx binary_integer; indx binary_integer;
583: begin
576: end rosetta_table_copy_in_p8;
577: procedure rosetta_table_copy_out_p8(t lns_financials.payoff_tbl2, a0 out nocopy JTF_VARCHAR2_TABLE_100
578: , a1 out nocopy JTF_NUMBER_TABLE
579: , a2 out nocopy JTF_NUMBER_TABLE
580: , a3 out nocopy JTF_NUMBER_TABLE
581: ) as
582: ddindx binary_integer; indx binary_integer;
583: begin
584: if t is null or t.count = 0 then
582: ddindx binary_integer; indx binary_integer;
583: begin
584: if t is null or t.count = 0 then
585: a0 := JTF_VARCHAR2_TABLE_100();
586: a1 := JTF_NUMBER_TABLE();
587: a2 := JTF_NUMBER_TABLE();
588: a3 := JTF_NUMBER_TABLE();
589: else
590: a0 := JTF_VARCHAR2_TABLE_100();
583: begin
584: if t is null or t.count = 0 then
585: a0 := JTF_VARCHAR2_TABLE_100();
586: a1 := JTF_NUMBER_TABLE();
587: a2 := JTF_NUMBER_TABLE();
588: a3 := JTF_NUMBER_TABLE();
589: else
590: a0 := JTF_VARCHAR2_TABLE_100();
591: a1 := JTF_NUMBER_TABLE();
584: if t is null or t.count = 0 then
585: a0 := JTF_VARCHAR2_TABLE_100();
586: a1 := JTF_NUMBER_TABLE();
587: a2 := JTF_NUMBER_TABLE();
588: a3 := JTF_NUMBER_TABLE();
589: else
590: a0 := JTF_VARCHAR2_TABLE_100();
591: a1 := JTF_NUMBER_TABLE();
592: a2 := JTF_NUMBER_TABLE();
587: a2 := JTF_NUMBER_TABLE();
588: a3 := JTF_NUMBER_TABLE();
589: else
590: a0 := JTF_VARCHAR2_TABLE_100();
591: a1 := JTF_NUMBER_TABLE();
592: a2 := JTF_NUMBER_TABLE();
593: a3 := JTF_NUMBER_TABLE();
594: if t.count > 0 then
595: a0.extend(t.count);
588: a3 := JTF_NUMBER_TABLE();
589: else
590: a0 := JTF_VARCHAR2_TABLE_100();
591: a1 := JTF_NUMBER_TABLE();
592: a2 := JTF_NUMBER_TABLE();
593: a3 := JTF_NUMBER_TABLE();
594: if t.count > 0 then
595: a0.extend(t.count);
596: a1.extend(t.count);
589: else
590: a0 := JTF_VARCHAR2_TABLE_100();
591: a1 := JTF_NUMBER_TABLE();
592: a2 := JTF_NUMBER_TABLE();
593: a3 := JTF_NUMBER_TABLE();
594: if t.count > 0 then
595: a0.extend(t.count);
596: a1.extend(t.count);
597: a2.extend(t.count);
613: end if;
614: end rosetta_table_copy_out_p8;
615:
616: procedure rosetta_table_copy_in_p10(t out nocopy lns_financials.loan_activity_tbl, a0 JTF_DATE_TABLE
617: , a1 JTF_NUMBER_TABLE
618: , a2 JTF_NUMBER_TABLE
619: , a3 JTF_NUMBER_TABLE
620: ) as
621: ddindx binary_integer; indx binary_integer;
614: end rosetta_table_copy_out_p8;
615:
616: procedure rosetta_table_copy_in_p10(t out nocopy lns_financials.loan_activity_tbl, a0 JTF_DATE_TABLE
617: , a1 JTF_NUMBER_TABLE
618: , a2 JTF_NUMBER_TABLE
619: , a3 JTF_NUMBER_TABLE
620: ) as
621: ddindx binary_integer; indx binary_integer;
622: begin
615:
616: procedure rosetta_table_copy_in_p10(t out nocopy lns_financials.loan_activity_tbl, a0 JTF_DATE_TABLE
617: , a1 JTF_NUMBER_TABLE
618: , a2 JTF_NUMBER_TABLE
619: , a3 JTF_NUMBER_TABLE
620: ) as
621: ddindx binary_integer; indx binary_integer;
622: begin
623: if a0 is not null and a0.count > 0 then
638: end if;
639: end if;
640: end rosetta_table_copy_in_p10;
641: procedure rosetta_table_copy_out_p10(t lns_financials.loan_activity_tbl, a0 out nocopy JTF_DATE_TABLE
642: , a1 out nocopy JTF_NUMBER_TABLE
643: , a2 out nocopy JTF_NUMBER_TABLE
644: , a3 out nocopy JTF_NUMBER_TABLE
645: ) as
646: ddindx binary_integer; indx binary_integer;
639: end if;
640: end rosetta_table_copy_in_p10;
641: procedure rosetta_table_copy_out_p10(t lns_financials.loan_activity_tbl, a0 out nocopy JTF_DATE_TABLE
642: , a1 out nocopy JTF_NUMBER_TABLE
643: , a2 out nocopy JTF_NUMBER_TABLE
644: , a3 out nocopy JTF_NUMBER_TABLE
645: ) as
646: ddindx binary_integer; indx binary_integer;
647: begin
640: end rosetta_table_copy_in_p10;
641: procedure rosetta_table_copy_out_p10(t lns_financials.loan_activity_tbl, a0 out nocopy JTF_DATE_TABLE
642: , a1 out nocopy JTF_NUMBER_TABLE
643: , a2 out nocopy JTF_NUMBER_TABLE
644: , a3 out nocopy JTF_NUMBER_TABLE
645: ) as
646: ddindx binary_integer; indx binary_integer;
647: begin
648: if t is null or t.count = 0 then
646: ddindx binary_integer; indx binary_integer;
647: begin
648: if t is null or t.count = 0 then
649: a0 := JTF_DATE_TABLE();
650: a1 := JTF_NUMBER_TABLE();
651: a2 := JTF_NUMBER_TABLE();
652: a3 := JTF_NUMBER_TABLE();
653: else
654: a0 := JTF_DATE_TABLE();
647: begin
648: if t is null or t.count = 0 then
649: a0 := JTF_DATE_TABLE();
650: a1 := JTF_NUMBER_TABLE();
651: a2 := JTF_NUMBER_TABLE();
652: a3 := JTF_NUMBER_TABLE();
653: else
654: a0 := JTF_DATE_TABLE();
655: a1 := JTF_NUMBER_TABLE();
648: if t is null or t.count = 0 then
649: a0 := JTF_DATE_TABLE();
650: a1 := JTF_NUMBER_TABLE();
651: a2 := JTF_NUMBER_TABLE();
652: a3 := JTF_NUMBER_TABLE();
653: else
654: a0 := JTF_DATE_TABLE();
655: a1 := JTF_NUMBER_TABLE();
656: a2 := JTF_NUMBER_TABLE();
651: a2 := JTF_NUMBER_TABLE();
652: a3 := JTF_NUMBER_TABLE();
653: else
654: a0 := JTF_DATE_TABLE();
655: a1 := JTF_NUMBER_TABLE();
656: a2 := JTF_NUMBER_TABLE();
657: a3 := JTF_NUMBER_TABLE();
658: if t.count > 0 then
659: a0.extend(t.count);
652: a3 := JTF_NUMBER_TABLE();
653: else
654: a0 := JTF_DATE_TABLE();
655: a1 := JTF_NUMBER_TABLE();
656: a2 := JTF_NUMBER_TABLE();
657: a3 := JTF_NUMBER_TABLE();
658: if t.count > 0 then
659: a0.extend(t.count);
660: a1.extend(t.count);
653: else
654: a0 := JTF_DATE_TABLE();
655: a1 := JTF_NUMBER_TABLE();
656: a2 := JTF_NUMBER_TABLE();
657: a3 := JTF_NUMBER_TABLE();
658: if t.count > 0 then
659: a0.extend(t.count);
660: a1.extend(t.count);
661: a2.extend(t.count);
767: end if;
768: end if;
769: end rosetta_table_copy_out_p13;
770:
771: procedure rosetta_table_copy_in_p14(t out nocopy lns_financials.amount_tbl, a0 JTF_NUMBER_TABLE) as
772: ddindx binary_integer; indx binary_integer;
773: begin
774: if a0 is not null and a0.count > 0 then
775: if a0.count > 0 then
785: end loop;
786: end if;
787: end if;
788: end rosetta_table_copy_in_p14;
789: procedure rosetta_table_copy_out_p14(t lns_financials.amount_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
790: ddindx binary_integer; indx binary_integer;
791: begin
792: if t is null or t.count = 0 then
793: a0 := JTF_NUMBER_TABLE();
789: procedure rosetta_table_copy_out_p14(t lns_financials.amount_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
790: ddindx binary_integer; indx binary_integer;
791: begin
792: if t is null or t.count = 0 then
793: a0 := JTF_NUMBER_TABLE();
794: else
795: a0 := JTF_NUMBER_TABLE();
796: if t.count > 0 then
797: a0.extend(t.count);
791: begin
792: if t is null or t.count = 0 then
793: a0 := JTF_NUMBER_TABLE();
794: else
795: a0 := JTF_NUMBER_TABLE();
796: if t.count > 0 then
797: a0.extend(t.count);
798: ddindx := t.first;
799: indx := 1;
849: end if;
850: end if;
851: end rosetta_table_copy_out_p15;
852:
853: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
854: , a1 JTF_VARCHAR2_TABLE_100
855: , a2 JTF_NUMBER_TABLE
856: , a3 JTF_NUMBER_TABLE
857: , a4 JTF_VARCHAR2_TABLE_300
851: end rosetta_table_copy_out_p15;
852:
853: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
854: , a1 JTF_VARCHAR2_TABLE_100
855: , a2 JTF_NUMBER_TABLE
856: , a3 JTF_NUMBER_TABLE
857: , a4 JTF_VARCHAR2_TABLE_300
858: , a5 JTF_NUMBER_TABLE
859: , a6 JTF_VARCHAR2_TABLE_100
852:
853: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
854: , a1 JTF_VARCHAR2_TABLE_100
855: , a2 JTF_NUMBER_TABLE
856: , a3 JTF_NUMBER_TABLE
857: , a4 JTF_VARCHAR2_TABLE_300
858: , a5 JTF_NUMBER_TABLE
859: , a6 JTF_VARCHAR2_TABLE_100
860: , a7 JTF_NUMBER_TABLE
854: , a1 JTF_VARCHAR2_TABLE_100
855: , a2 JTF_NUMBER_TABLE
856: , a3 JTF_NUMBER_TABLE
857: , a4 JTF_VARCHAR2_TABLE_300
858: , a5 JTF_NUMBER_TABLE
859: , a6 JTF_VARCHAR2_TABLE_100
860: , a7 JTF_NUMBER_TABLE
861: , a8 JTF_VARCHAR2_TABLE_100
862: , a9 JTF_VARCHAR2_TABLE_100
856: , a3 JTF_NUMBER_TABLE
857: , a4 JTF_VARCHAR2_TABLE_300
858: , a5 JTF_NUMBER_TABLE
859: , a6 JTF_VARCHAR2_TABLE_100
860: , a7 JTF_NUMBER_TABLE
861: , a8 JTF_VARCHAR2_TABLE_100
862: , a9 JTF_VARCHAR2_TABLE_100
863: ) as
864: ddindx binary_integer; indx binary_integer;
886: end loop;
887: end if;
888: end if;
889: end rosetta_table_copy_in_p17;
890: procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE
891: , a1 out nocopy JTF_VARCHAR2_TABLE_100
892: , a2 out nocopy JTF_NUMBER_TABLE
893: , a3 out nocopy JTF_NUMBER_TABLE
894: , a4 out nocopy JTF_VARCHAR2_TABLE_300
888: end if;
889: end rosetta_table_copy_in_p17;
890: procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE
891: , a1 out nocopy JTF_VARCHAR2_TABLE_100
892: , a2 out nocopy JTF_NUMBER_TABLE
893: , a3 out nocopy JTF_NUMBER_TABLE
894: , a4 out nocopy JTF_VARCHAR2_TABLE_300
895: , a5 out nocopy JTF_NUMBER_TABLE
896: , a6 out nocopy JTF_VARCHAR2_TABLE_100
889: end rosetta_table_copy_in_p17;
890: procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE
891: , a1 out nocopy JTF_VARCHAR2_TABLE_100
892: , a2 out nocopy JTF_NUMBER_TABLE
893: , a3 out nocopy JTF_NUMBER_TABLE
894: , a4 out nocopy JTF_VARCHAR2_TABLE_300
895: , a5 out nocopy JTF_NUMBER_TABLE
896: , a6 out nocopy JTF_VARCHAR2_TABLE_100
897: , a7 out nocopy JTF_NUMBER_TABLE
891: , a1 out nocopy JTF_VARCHAR2_TABLE_100
892: , a2 out nocopy JTF_NUMBER_TABLE
893: , a3 out nocopy JTF_NUMBER_TABLE
894: , a4 out nocopy JTF_VARCHAR2_TABLE_300
895: , a5 out nocopy JTF_NUMBER_TABLE
896: , a6 out nocopy JTF_VARCHAR2_TABLE_100
897: , a7 out nocopy JTF_NUMBER_TABLE
898: , a8 out nocopy JTF_VARCHAR2_TABLE_100
899: , a9 out nocopy JTF_VARCHAR2_TABLE_100
893: , a3 out nocopy JTF_NUMBER_TABLE
894: , a4 out nocopy JTF_VARCHAR2_TABLE_300
895: , a5 out nocopy JTF_NUMBER_TABLE
896: , a6 out nocopy JTF_VARCHAR2_TABLE_100
897: , a7 out nocopy JTF_NUMBER_TABLE
898: , a8 out nocopy JTF_VARCHAR2_TABLE_100
899: , a9 out nocopy JTF_VARCHAR2_TABLE_100
900: ) as
901: ddindx binary_integer; indx binary_integer;
900: ) as
901: ddindx binary_integer; indx binary_integer;
902: begin
903: if t is null or t.count = 0 then
904: a0 := JTF_NUMBER_TABLE();
905: a1 := JTF_VARCHAR2_TABLE_100();
906: a2 := JTF_NUMBER_TABLE();
907: a3 := JTF_NUMBER_TABLE();
908: a4 := JTF_VARCHAR2_TABLE_300();
902: begin
903: if t is null or t.count = 0 then
904: a0 := JTF_NUMBER_TABLE();
905: a1 := JTF_VARCHAR2_TABLE_100();
906: a2 := JTF_NUMBER_TABLE();
907: a3 := JTF_NUMBER_TABLE();
908: a4 := JTF_VARCHAR2_TABLE_300();
909: a5 := JTF_NUMBER_TABLE();
910: a6 := JTF_VARCHAR2_TABLE_100();
903: if t is null or t.count = 0 then
904: a0 := JTF_NUMBER_TABLE();
905: a1 := JTF_VARCHAR2_TABLE_100();
906: a2 := JTF_NUMBER_TABLE();
907: a3 := JTF_NUMBER_TABLE();
908: a4 := JTF_VARCHAR2_TABLE_300();
909: a5 := JTF_NUMBER_TABLE();
910: a6 := JTF_VARCHAR2_TABLE_100();
911: a7 := JTF_NUMBER_TABLE();
905: a1 := JTF_VARCHAR2_TABLE_100();
906: a2 := JTF_NUMBER_TABLE();
907: a3 := JTF_NUMBER_TABLE();
908: a4 := JTF_VARCHAR2_TABLE_300();
909: a5 := JTF_NUMBER_TABLE();
910: a6 := JTF_VARCHAR2_TABLE_100();
911: a7 := JTF_NUMBER_TABLE();
912: a8 := JTF_VARCHAR2_TABLE_100();
913: a9 := JTF_VARCHAR2_TABLE_100();
907: a3 := JTF_NUMBER_TABLE();
908: a4 := JTF_VARCHAR2_TABLE_300();
909: a5 := JTF_NUMBER_TABLE();
910: a6 := JTF_VARCHAR2_TABLE_100();
911: a7 := JTF_NUMBER_TABLE();
912: a8 := JTF_VARCHAR2_TABLE_100();
913: a9 := JTF_VARCHAR2_TABLE_100();
914: else
915: a0 := JTF_NUMBER_TABLE();
911: a7 := JTF_NUMBER_TABLE();
912: a8 := JTF_VARCHAR2_TABLE_100();
913: a9 := JTF_VARCHAR2_TABLE_100();
914: else
915: a0 := JTF_NUMBER_TABLE();
916: a1 := JTF_VARCHAR2_TABLE_100();
917: a2 := JTF_NUMBER_TABLE();
918: a3 := JTF_NUMBER_TABLE();
919: a4 := JTF_VARCHAR2_TABLE_300();
913: a9 := JTF_VARCHAR2_TABLE_100();
914: else
915: a0 := JTF_NUMBER_TABLE();
916: a1 := JTF_VARCHAR2_TABLE_100();
917: a2 := JTF_NUMBER_TABLE();
918: a3 := JTF_NUMBER_TABLE();
919: a4 := JTF_VARCHAR2_TABLE_300();
920: a5 := JTF_NUMBER_TABLE();
921: a6 := JTF_VARCHAR2_TABLE_100();
914: else
915: a0 := JTF_NUMBER_TABLE();
916: a1 := JTF_VARCHAR2_TABLE_100();
917: a2 := JTF_NUMBER_TABLE();
918: a3 := JTF_NUMBER_TABLE();
919: a4 := JTF_VARCHAR2_TABLE_300();
920: a5 := JTF_NUMBER_TABLE();
921: a6 := JTF_VARCHAR2_TABLE_100();
922: a7 := JTF_NUMBER_TABLE();
916: a1 := JTF_VARCHAR2_TABLE_100();
917: a2 := JTF_NUMBER_TABLE();
918: a3 := JTF_NUMBER_TABLE();
919: a4 := JTF_VARCHAR2_TABLE_300();
920: a5 := JTF_NUMBER_TABLE();
921: a6 := JTF_VARCHAR2_TABLE_100();
922: a7 := JTF_NUMBER_TABLE();
923: a8 := JTF_VARCHAR2_TABLE_100();
924: a9 := JTF_VARCHAR2_TABLE_100();
918: a3 := JTF_NUMBER_TABLE();
919: a4 := JTF_VARCHAR2_TABLE_300();
920: a5 := JTF_NUMBER_TABLE();
921: a6 := JTF_VARCHAR2_TABLE_100();
922: a7 := JTF_NUMBER_TABLE();
923: a8 := JTF_VARCHAR2_TABLE_100();
924: a9 := JTF_VARCHAR2_TABLE_100();
925: if t.count > 0 then
926: a0.extend(t.count);
1438: , p_init_msg_list VARCHAR2
1439: , p_loan_id NUMBER
1440: , p_payoff_date DATE
1441: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
1442: , p4_a1 out nocopy JTF_NUMBER_TABLE
1443: , p4_a2 out nocopy JTF_NUMBER_TABLE
1444: , p4_a3 out nocopy JTF_NUMBER_TABLE
1445: , x_return_status out nocopy VARCHAR2
1446: , x_msg_count out nocopy NUMBER
1439: , p_loan_id NUMBER
1440: , p_payoff_date DATE
1441: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
1442: , p4_a1 out nocopy JTF_NUMBER_TABLE
1443: , p4_a2 out nocopy JTF_NUMBER_TABLE
1444: , p4_a3 out nocopy JTF_NUMBER_TABLE
1445: , x_return_status out nocopy VARCHAR2
1446: , x_msg_count out nocopy NUMBER
1447: , x_msg_data out nocopy VARCHAR2
1440: , p_payoff_date DATE
1441: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
1442: , p4_a1 out nocopy JTF_NUMBER_TABLE
1443: , p4_a2 out nocopy JTF_NUMBER_TABLE
1444: , p4_a3 out nocopy JTF_NUMBER_TABLE
1445: , x_return_status out nocopy VARCHAR2
1446: , x_msg_count out nocopy NUMBER
1447: , x_msg_data out nocopy VARCHAR2
1448: )
1583: , p0_a94 VARCHAR2
1584: , p0_a95 VARCHAR2
1585: , p_start_date DATE
1586: , p_end_date DATE
1587: , p3_a0 JTF_NUMBER_TABLE
1588: , p3_a1 JTF_DATE_TABLE
1589: , p3_a2 JTF_DATE_TABLE
1590: , p3_a3 JTF_NUMBER_TABLE
1591: , p3_a4 JTF_NUMBER_TABLE
1586: , p_end_date DATE
1587: , p3_a0 JTF_NUMBER_TABLE
1588: , p3_a1 JTF_DATE_TABLE
1589: , p3_a2 JTF_DATE_TABLE
1590: , p3_a3 JTF_NUMBER_TABLE
1591: , p3_a4 JTF_NUMBER_TABLE
1592: , p3_a5 JTF_NUMBER_TABLE
1593: , p3_a6 JTF_NUMBER_TABLE
1594: , p3_a7 JTF_VARCHAR2_TABLE_100
1587: , p3_a0 JTF_NUMBER_TABLE
1588: , p3_a1 JTF_DATE_TABLE
1589: , p3_a2 JTF_DATE_TABLE
1590: , p3_a3 JTF_NUMBER_TABLE
1591: , p3_a4 JTF_NUMBER_TABLE
1592: , p3_a5 JTF_NUMBER_TABLE
1593: , p3_a6 JTF_NUMBER_TABLE
1594: , p3_a7 JTF_VARCHAR2_TABLE_100
1595: , p3_a8 JTF_VARCHAR2_TABLE_100
1588: , p3_a1 JTF_DATE_TABLE
1589: , p3_a2 JTF_DATE_TABLE
1590: , p3_a3 JTF_NUMBER_TABLE
1591: , p3_a4 JTF_NUMBER_TABLE
1592: , p3_a5 JTF_NUMBER_TABLE
1593: , p3_a6 JTF_NUMBER_TABLE
1594: , p3_a7 JTF_VARCHAR2_TABLE_100
1595: , p3_a8 JTF_VARCHAR2_TABLE_100
1596: , p3_a9 JTF_VARCHAR2_TABLE_100
1589: , p3_a2 JTF_DATE_TABLE
1590: , p3_a3 JTF_NUMBER_TABLE
1591: , p3_a4 JTF_NUMBER_TABLE
1592: , p3_a5 JTF_NUMBER_TABLE
1593: , p3_a6 JTF_NUMBER_TABLE
1594: , p3_a7 JTF_VARCHAR2_TABLE_100
1595: , p3_a8 JTF_VARCHAR2_TABLE_100
1596: , p3_a9 JTF_VARCHAR2_TABLE_100
1597: ) return number
1834: , p0_a92 VARCHAR2
1835: , p0_a93 VARCHAR2
1836: , p0_a94 VARCHAR2
1837: , p0_a95 VARCHAR2
1838: , p1_a0 JTF_NUMBER_TABLE
1839: , p1_a1 JTF_DATE_TABLE
1840: , p1_a2 JTF_DATE_TABLE
1841: , p1_a3 JTF_NUMBER_TABLE
1842: , p1_a4 JTF_NUMBER_TABLE
1837: , p0_a95 VARCHAR2
1838: , p1_a0 JTF_NUMBER_TABLE
1839: , p1_a1 JTF_DATE_TABLE
1840: , p1_a2 JTF_DATE_TABLE
1841: , p1_a3 JTF_NUMBER_TABLE
1842: , p1_a4 JTF_NUMBER_TABLE
1843: , p1_a5 JTF_NUMBER_TABLE
1844: , p1_a6 JTF_NUMBER_TABLE
1845: , p1_a7 JTF_VARCHAR2_TABLE_100
1838: , p1_a0 JTF_NUMBER_TABLE
1839: , p1_a1 JTF_DATE_TABLE
1840: , p1_a2 JTF_DATE_TABLE
1841: , p1_a3 JTF_NUMBER_TABLE
1842: , p1_a4 JTF_NUMBER_TABLE
1843: , p1_a5 JTF_NUMBER_TABLE
1844: , p1_a6 JTF_NUMBER_TABLE
1845: , p1_a7 JTF_VARCHAR2_TABLE_100
1846: , p1_a8 JTF_VARCHAR2_TABLE_100
1839: , p1_a1 JTF_DATE_TABLE
1840: , p1_a2 JTF_DATE_TABLE
1841: , p1_a3 JTF_NUMBER_TABLE
1842: , p1_a4 JTF_NUMBER_TABLE
1843: , p1_a5 JTF_NUMBER_TABLE
1844: , p1_a6 JTF_NUMBER_TABLE
1845: , p1_a7 JTF_VARCHAR2_TABLE_100
1846: , p1_a8 JTF_VARCHAR2_TABLE_100
1847: , p1_a9 JTF_VARCHAR2_TABLE_100
1840: , p1_a2 JTF_DATE_TABLE
1841: , p1_a3 JTF_NUMBER_TABLE
1842: , p1_a4 JTF_NUMBER_TABLE
1843: , p1_a5 JTF_NUMBER_TABLE
1844: , p1_a6 JTF_NUMBER_TABLE
1845: , p1_a7 JTF_VARCHAR2_TABLE_100
1846: , p1_a8 JTF_VARCHAR2_TABLE_100
1847: , p1_a9 JTF_VARCHAR2_TABLE_100
1848: , p_based_on_terms VARCHAR2
1846: , p1_a8 JTF_VARCHAR2_TABLE_100
1847: , p1_a9 JTF_VARCHAR2_TABLE_100
1848: , p_based_on_terms VARCHAR2
1849: , p_installment_number NUMBER
1850: , p4_a0 out nocopy JTF_NUMBER_TABLE
1851: , p4_a1 out nocopy JTF_DATE_TABLE
1852: , p4_a2 out nocopy JTF_DATE_TABLE
1853: , p4_a3 out nocopy JTF_DATE_TABLE
1854: , p4_a4 out nocopy JTF_NUMBER_TABLE
1850: , p4_a0 out nocopy JTF_NUMBER_TABLE
1851: , p4_a1 out nocopy JTF_DATE_TABLE
1852: , p4_a2 out nocopy JTF_DATE_TABLE
1853: , p4_a3 out nocopy JTF_DATE_TABLE
1854: , p4_a4 out nocopy JTF_NUMBER_TABLE
1855: , p4_a5 out nocopy JTF_NUMBER_TABLE
1856: , p4_a6 out nocopy JTF_NUMBER_TABLE
1857: , p4_a7 out nocopy JTF_NUMBER_TABLE
1858: , p4_a8 out nocopy JTF_NUMBER_TABLE
1851: , p4_a1 out nocopy JTF_DATE_TABLE
1852: , p4_a2 out nocopy JTF_DATE_TABLE
1853: , p4_a3 out nocopy JTF_DATE_TABLE
1854: , p4_a4 out nocopy JTF_NUMBER_TABLE
1855: , p4_a5 out nocopy JTF_NUMBER_TABLE
1856: , p4_a6 out nocopy JTF_NUMBER_TABLE
1857: , p4_a7 out nocopy JTF_NUMBER_TABLE
1858: , p4_a8 out nocopy JTF_NUMBER_TABLE
1859: , p4_a9 out nocopy JTF_NUMBER_TABLE
1852: , p4_a2 out nocopy JTF_DATE_TABLE
1853: , p4_a3 out nocopy JTF_DATE_TABLE
1854: , p4_a4 out nocopy JTF_NUMBER_TABLE
1855: , p4_a5 out nocopy JTF_NUMBER_TABLE
1856: , p4_a6 out nocopy JTF_NUMBER_TABLE
1857: , p4_a7 out nocopy JTF_NUMBER_TABLE
1858: , p4_a8 out nocopy JTF_NUMBER_TABLE
1859: , p4_a9 out nocopy JTF_NUMBER_TABLE
1860: , p4_a10 out nocopy JTF_NUMBER_TABLE
1853: , p4_a3 out nocopy JTF_DATE_TABLE
1854: , p4_a4 out nocopy JTF_NUMBER_TABLE
1855: , p4_a5 out nocopy JTF_NUMBER_TABLE
1856: , p4_a6 out nocopy JTF_NUMBER_TABLE
1857: , p4_a7 out nocopy JTF_NUMBER_TABLE
1858: , p4_a8 out nocopy JTF_NUMBER_TABLE
1859: , p4_a9 out nocopy JTF_NUMBER_TABLE
1860: , p4_a10 out nocopy JTF_NUMBER_TABLE
1861: , p4_a11 out nocopy JTF_NUMBER_TABLE
1854: , p4_a4 out nocopy JTF_NUMBER_TABLE
1855: , p4_a5 out nocopy JTF_NUMBER_TABLE
1856: , p4_a6 out nocopy JTF_NUMBER_TABLE
1857: , p4_a7 out nocopy JTF_NUMBER_TABLE
1858: , p4_a8 out nocopy JTF_NUMBER_TABLE
1859: , p4_a9 out nocopy JTF_NUMBER_TABLE
1860: , p4_a10 out nocopy JTF_NUMBER_TABLE
1861: , p4_a11 out nocopy JTF_NUMBER_TABLE
1862: , p4_a12 out nocopy JTF_NUMBER_TABLE
1855: , p4_a5 out nocopy JTF_NUMBER_TABLE
1856: , p4_a6 out nocopy JTF_NUMBER_TABLE
1857: , p4_a7 out nocopy JTF_NUMBER_TABLE
1858: , p4_a8 out nocopy JTF_NUMBER_TABLE
1859: , p4_a9 out nocopy JTF_NUMBER_TABLE
1860: , p4_a10 out nocopy JTF_NUMBER_TABLE
1861: , p4_a11 out nocopy JTF_NUMBER_TABLE
1862: , p4_a12 out nocopy JTF_NUMBER_TABLE
1863: , p4_a13 out nocopy JTF_NUMBER_TABLE
1856: , p4_a6 out nocopy JTF_NUMBER_TABLE
1857: , p4_a7 out nocopy JTF_NUMBER_TABLE
1858: , p4_a8 out nocopy JTF_NUMBER_TABLE
1859: , p4_a9 out nocopy JTF_NUMBER_TABLE
1860: , p4_a10 out nocopy JTF_NUMBER_TABLE
1861: , p4_a11 out nocopy JTF_NUMBER_TABLE
1862: , p4_a12 out nocopy JTF_NUMBER_TABLE
1863: , p4_a13 out nocopy JTF_NUMBER_TABLE
1864: , p4_a14 out nocopy JTF_NUMBER_TABLE
1857: , p4_a7 out nocopy JTF_NUMBER_TABLE
1858: , p4_a8 out nocopy JTF_NUMBER_TABLE
1859: , p4_a9 out nocopy JTF_NUMBER_TABLE
1860: , p4_a10 out nocopy JTF_NUMBER_TABLE
1861: , p4_a11 out nocopy JTF_NUMBER_TABLE
1862: , p4_a12 out nocopy JTF_NUMBER_TABLE
1863: , p4_a13 out nocopy JTF_NUMBER_TABLE
1864: , p4_a14 out nocopy JTF_NUMBER_TABLE
1865: , p4_a15 out nocopy JTF_NUMBER_TABLE
1858: , p4_a8 out nocopy JTF_NUMBER_TABLE
1859: , p4_a9 out nocopy JTF_NUMBER_TABLE
1860: , p4_a10 out nocopy JTF_NUMBER_TABLE
1861: , p4_a11 out nocopy JTF_NUMBER_TABLE
1862: , p4_a12 out nocopy JTF_NUMBER_TABLE
1863: , p4_a13 out nocopy JTF_NUMBER_TABLE
1864: , p4_a14 out nocopy JTF_NUMBER_TABLE
1865: , p4_a15 out nocopy JTF_NUMBER_TABLE
1866: , p4_a16 out nocopy JTF_NUMBER_TABLE
1859: , p4_a9 out nocopy JTF_NUMBER_TABLE
1860: , p4_a10 out nocopy JTF_NUMBER_TABLE
1861: , p4_a11 out nocopy JTF_NUMBER_TABLE
1862: , p4_a12 out nocopy JTF_NUMBER_TABLE
1863: , p4_a13 out nocopy JTF_NUMBER_TABLE
1864: , p4_a14 out nocopy JTF_NUMBER_TABLE
1865: , p4_a15 out nocopy JTF_NUMBER_TABLE
1866: , p4_a16 out nocopy JTF_NUMBER_TABLE
1867: , p4_a17 out nocopy JTF_NUMBER_TABLE
1860: , p4_a10 out nocopy JTF_NUMBER_TABLE
1861: , p4_a11 out nocopy JTF_NUMBER_TABLE
1862: , p4_a12 out nocopy JTF_NUMBER_TABLE
1863: , p4_a13 out nocopy JTF_NUMBER_TABLE
1864: , p4_a14 out nocopy JTF_NUMBER_TABLE
1865: , p4_a15 out nocopy JTF_NUMBER_TABLE
1866: , p4_a16 out nocopy JTF_NUMBER_TABLE
1867: , p4_a17 out nocopy JTF_NUMBER_TABLE
1868: , p4_a18 out nocopy JTF_NUMBER_TABLE
1861: , p4_a11 out nocopy JTF_NUMBER_TABLE
1862: , p4_a12 out nocopy JTF_NUMBER_TABLE
1863: , p4_a13 out nocopy JTF_NUMBER_TABLE
1864: , p4_a14 out nocopy JTF_NUMBER_TABLE
1865: , p4_a15 out nocopy JTF_NUMBER_TABLE
1866: , p4_a16 out nocopy JTF_NUMBER_TABLE
1867: , p4_a17 out nocopy JTF_NUMBER_TABLE
1868: , p4_a18 out nocopy JTF_NUMBER_TABLE
1869: , p4_a19 out nocopy JTF_NUMBER_TABLE
1862: , p4_a12 out nocopy JTF_NUMBER_TABLE
1863: , p4_a13 out nocopy JTF_NUMBER_TABLE
1864: , p4_a14 out nocopy JTF_NUMBER_TABLE
1865: , p4_a15 out nocopy JTF_NUMBER_TABLE
1866: , p4_a16 out nocopy JTF_NUMBER_TABLE
1867: , p4_a17 out nocopy JTF_NUMBER_TABLE
1868: , p4_a18 out nocopy JTF_NUMBER_TABLE
1869: , p4_a19 out nocopy JTF_NUMBER_TABLE
1870: , p4_a20 out nocopy JTF_NUMBER_TABLE
1863: , p4_a13 out nocopy JTF_NUMBER_TABLE
1864: , p4_a14 out nocopy JTF_NUMBER_TABLE
1865: , p4_a15 out nocopy JTF_NUMBER_TABLE
1866: , p4_a16 out nocopy JTF_NUMBER_TABLE
1867: , p4_a17 out nocopy JTF_NUMBER_TABLE
1868: , p4_a18 out nocopy JTF_NUMBER_TABLE
1869: , p4_a19 out nocopy JTF_NUMBER_TABLE
1870: , p4_a20 out nocopy JTF_NUMBER_TABLE
1871: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
1864: , p4_a14 out nocopy JTF_NUMBER_TABLE
1865: , p4_a15 out nocopy JTF_NUMBER_TABLE
1866: , p4_a16 out nocopy JTF_NUMBER_TABLE
1867: , p4_a17 out nocopy JTF_NUMBER_TABLE
1868: , p4_a18 out nocopy JTF_NUMBER_TABLE
1869: , p4_a19 out nocopy JTF_NUMBER_TABLE
1870: , p4_a20 out nocopy JTF_NUMBER_TABLE
1871: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
1872: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
1865: , p4_a15 out nocopy JTF_NUMBER_TABLE
1866: , p4_a16 out nocopy JTF_NUMBER_TABLE
1867: , p4_a17 out nocopy JTF_NUMBER_TABLE
1868: , p4_a18 out nocopy JTF_NUMBER_TABLE
1869: , p4_a19 out nocopy JTF_NUMBER_TABLE
1870: , p4_a20 out nocopy JTF_NUMBER_TABLE
1871: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
1872: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
1873: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
1866: , p4_a16 out nocopy JTF_NUMBER_TABLE
1867: , p4_a17 out nocopy JTF_NUMBER_TABLE
1868: , p4_a18 out nocopy JTF_NUMBER_TABLE
1869: , p4_a19 out nocopy JTF_NUMBER_TABLE
1870: , p4_a20 out nocopy JTF_NUMBER_TABLE
1871: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
1872: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
1873: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
1874: , p4_a24 out nocopy JTF_NUMBER_TABLE
1870: , p4_a20 out nocopy JTF_NUMBER_TABLE
1871: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
1872: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
1873: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
1874: , p4_a24 out nocopy JTF_NUMBER_TABLE
1875: , p4_a25 out nocopy JTF_NUMBER_TABLE
1876: , p4_a26 out nocopy JTF_NUMBER_TABLE
1877: , p4_a27 out nocopy JTF_NUMBER_TABLE
1878: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1871: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
1872: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
1873: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
1874: , p4_a24 out nocopy JTF_NUMBER_TABLE
1875: , p4_a25 out nocopy JTF_NUMBER_TABLE
1876: , p4_a26 out nocopy JTF_NUMBER_TABLE
1877: , p4_a27 out nocopy JTF_NUMBER_TABLE
1878: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1879: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1872: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
1873: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
1874: , p4_a24 out nocopy JTF_NUMBER_TABLE
1875: , p4_a25 out nocopy JTF_NUMBER_TABLE
1876: , p4_a26 out nocopy JTF_NUMBER_TABLE
1877: , p4_a27 out nocopy JTF_NUMBER_TABLE
1878: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1879: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1880: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1873: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
1874: , p4_a24 out nocopy JTF_NUMBER_TABLE
1875: , p4_a25 out nocopy JTF_NUMBER_TABLE
1876: , p4_a26 out nocopy JTF_NUMBER_TABLE
1877: , p4_a27 out nocopy JTF_NUMBER_TABLE
1878: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1879: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1880: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1881: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1878: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1879: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1880: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1881: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1882: , p4_a32 out nocopy JTF_NUMBER_TABLE
1883: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
1884: , p4_a34 out nocopy JTF_NUMBER_TABLE
1885: , p4_a35 out nocopy JTF_NUMBER_TABLE
1886: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1880: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1881: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1882: , p4_a32 out nocopy JTF_NUMBER_TABLE
1883: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
1884: , p4_a34 out nocopy JTF_NUMBER_TABLE
1885: , p4_a35 out nocopy JTF_NUMBER_TABLE
1886: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1887: , p4_a37 out nocopy JTF_NUMBER_TABLE
1888: , p4_a38 out nocopy JTF_NUMBER_TABLE
1881: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1882: , p4_a32 out nocopy JTF_NUMBER_TABLE
1883: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
1884: , p4_a34 out nocopy JTF_NUMBER_TABLE
1885: , p4_a35 out nocopy JTF_NUMBER_TABLE
1886: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1887: , p4_a37 out nocopy JTF_NUMBER_TABLE
1888: , p4_a38 out nocopy JTF_NUMBER_TABLE
1889: , p4_a39 out nocopy JTF_NUMBER_TABLE
1883: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
1884: , p4_a34 out nocopy JTF_NUMBER_TABLE
1885: , p4_a35 out nocopy JTF_NUMBER_TABLE
1886: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1887: , p4_a37 out nocopy JTF_NUMBER_TABLE
1888: , p4_a38 out nocopy JTF_NUMBER_TABLE
1889: , p4_a39 out nocopy JTF_NUMBER_TABLE
1890: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1891: , p4_a41 out nocopy JTF_NUMBER_TABLE
1884: , p4_a34 out nocopy JTF_NUMBER_TABLE
1885: , p4_a35 out nocopy JTF_NUMBER_TABLE
1886: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1887: , p4_a37 out nocopy JTF_NUMBER_TABLE
1888: , p4_a38 out nocopy JTF_NUMBER_TABLE
1889: , p4_a39 out nocopy JTF_NUMBER_TABLE
1890: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1891: , p4_a41 out nocopy JTF_NUMBER_TABLE
1892: , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000
1885: , p4_a35 out nocopy JTF_NUMBER_TABLE
1886: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1887: , p4_a37 out nocopy JTF_NUMBER_TABLE
1888: , p4_a38 out nocopy JTF_NUMBER_TABLE
1889: , p4_a39 out nocopy JTF_NUMBER_TABLE
1890: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1891: , p4_a41 out nocopy JTF_NUMBER_TABLE
1892: , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000
1893: )
1887: , p4_a37 out nocopy JTF_NUMBER_TABLE
1888: , p4_a38 out nocopy JTF_NUMBER_TABLE
1889: , p4_a39 out nocopy JTF_NUMBER_TABLE
1890: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1891: , p4_a41 out nocopy JTF_NUMBER_TABLE
1892: , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000
1893: )
1894:
1895: as
2175: , p0_a92 VARCHAR2
2176: , p0_a93 VARCHAR2
2177: , p0_a94 VARCHAR2
2178: , p0_a95 VARCHAR2
2179: , p1_a0 JTF_NUMBER_TABLE
2180: , p1_a1 JTF_DATE_TABLE
2181: , p1_a2 JTF_DATE_TABLE
2182: , p1_a3 JTF_NUMBER_TABLE
2183: , p1_a4 JTF_NUMBER_TABLE
2178: , p0_a95 VARCHAR2
2179: , p1_a0 JTF_NUMBER_TABLE
2180: , p1_a1 JTF_DATE_TABLE
2181: , p1_a2 JTF_DATE_TABLE
2182: , p1_a3 JTF_NUMBER_TABLE
2183: , p1_a4 JTF_NUMBER_TABLE
2184: , p1_a5 JTF_NUMBER_TABLE
2185: , p1_a6 JTF_NUMBER_TABLE
2186: , p1_a7 JTF_VARCHAR2_TABLE_100
2179: , p1_a0 JTF_NUMBER_TABLE
2180: , p1_a1 JTF_DATE_TABLE
2181: , p1_a2 JTF_DATE_TABLE
2182: , p1_a3 JTF_NUMBER_TABLE
2183: , p1_a4 JTF_NUMBER_TABLE
2184: , p1_a5 JTF_NUMBER_TABLE
2185: , p1_a6 JTF_NUMBER_TABLE
2186: , p1_a7 JTF_VARCHAR2_TABLE_100
2187: , p1_a8 JTF_VARCHAR2_TABLE_100
2180: , p1_a1 JTF_DATE_TABLE
2181: , p1_a2 JTF_DATE_TABLE
2182: , p1_a3 JTF_NUMBER_TABLE
2183: , p1_a4 JTF_NUMBER_TABLE
2184: , p1_a5 JTF_NUMBER_TABLE
2185: , p1_a6 JTF_NUMBER_TABLE
2186: , p1_a7 JTF_VARCHAR2_TABLE_100
2187: , p1_a8 JTF_VARCHAR2_TABLE_100
2188: , p1_a9 JTF_VARCHAR2_TABLE_100
2181: , p1_a2 JTF_DATE_TABLE
2182: , p1_a3 JTF_NUMBER_TABLE
2183: , p1_a4 JTF_NUMBER_TABLE
2184: , p1_a5 JTF_NUMBER_TABLE
2185: , p1_a6 JTF_NUMBER_TABLE
2186: , p1_a7 JTF_VARCHAR2_TABLE_100
2187: , p1_a8 JTF_VARCHAR2_TABLE_100
2188: , p1_a9 JTF_VARCHAR2_TABLE_100
2189: , p_based_on_terms VARCHAR2
2187: , p1_a8 JTF_VARCHAR2_TABLE_100
2188: , p1_a9 JTF_VARCHAR2_TABLE_100
2189: , p_based_on_terms VARCHAR2
2190: , p_installment_number NUMBER
2191: , p4_a0 out nocopy JTF_NUMBER_TABLE
2192: , p4_a1 out nocopy JTF_DATE_TABLE
2193: , p4_a2 out nocopy JTF_DATE_TABLE
2194: , p4_a3 out nocopy JTF_DATE_TABLE
2195: , p4_a4 out nocopy JTF_NUMBER_TABLE
2191: , p4_a0 out nocopy JTF_NUMBER_TABLE
2192: , p4_a1 out nocopy JTF_DATE_TABLE
2193: , p4_a2 out nocopy JTF_DATE_TABLE
2194: , p4_a3 out nocopy JTF_DATE_TABLE
2195: , p4_a4 out nocopy JTF_NUMBER_TABLE
2196: , p4_a5 out nocopy JTF_NUMBER_TABLE
2197: , p4_a6 out nocopy JTF_NUMBER_TABLE
2198: , p4_a7 out nocopy JTF_NUMBER_TABLE
2199: , p4_a8 out nocopy JTF_NUMBER_TABLE
2192: , p4_a1 out nocopy JTF_DATE_TABLE
2193: , p4_a2 out nocopy JTF_DATE_TABLE
2194: , p4_a3 out nocopy JTF_DATE_TABLE
2195: , p4_a4 out nocopy JTF_NUMBER_TABLE
2196: , p4_a5 out nocopy JTF_NUMBER_TABLE
2197: , p4_a6 out nocopy JTF_NUMBER_TABLE
2198: , p4_a7 out nocopy JTF_NUMBER_TABLE
2199: , p4_a8 out nocopy JTF_NUMBER_TABLE
2200: , p4_a9 out nocopy JTF_NUMBER_TABLE
2193: , p4_a2 out nocopy JTF_DATE_TABLE
2194: , p4_a3 out nocopy JTF_DATE_TABLE
2195: , p4_a4 out nocopy JTF_NUMBER_TABLE
2196: , p4_a5 out nocopy JTF_NUMBER_TABLE
2197: , p4_a6 out nocopy JTF_NUMBER_TABLE
2198: , p4_a7 out nocopy JTF_NUMBER_TABLE
2199: , p4_a8 out nocopy JTF_NUMBER_TABLE
2200: , p4_a9 out nocopy JTF_NUMBER_TABLE
2201: , p4_a10 out nocopy JTF_NUMBER_TABLE
2194: , p4_a3 out nocopy JTF_DATE_TABLE
2195: , p4_a4 out nocopy JTF_NUMBER_TABLE
2196: , p4_a5 out nocopy JTF_NUMBER_TABLE
2197: , p4_a6 out nocopy JTF_NUMBER_TABLE
2198: , p4_a7 out nocopy JTF_NUMBER_TABLE
2199: , p4_a8 out nocopy JTF_NUMBER_TABLE
2200: , p4_a9 out nocopy JTF_NUMBER_TABLE
2201: , p4_a10 out nocopy JTF_NUMBER_TABLE
2202: , p4_a11 out nocopy JTF_NUMBER_TABLE
2195: , p4_a4 out nocopy JTF_NUMBER_TABLE
2196: , p4_a5 out nocopy JTF_NUMBER_TABLE
2197: , p4_a6 out nocopy JTF_NUMBER_TABLE
2198: , p4_a7 out nocopy JTF_NUMBER_TABLE
2199: , p4_a8 out nocopy JTF_NUMBER_TABLE
2200: , p4_a9 out nocopy JTF_NUMBER_TABLE
2201: , p4_a10 out nocopy JTF_NUMBER_TABLE
2202: , p4_a11 out nocopy JTF_NUMBER_TABLE
2203: , p4_a12 out nocopy JTF_NUMBER_TABLE
2196: , p4_a5 out nocopy JTF_NUMBER_TABLE
2197: , p4_a6 out nocopy JTF_NUMBER_TABLE
2198: , p4_a7 out nocopy JTF_NUMBER_TABLE
2199: , p4_a8 out nocopy JTF_NUMBER_TABLE
2200: , p4_a9 out nocopy JTF_NUMBER_TABLE
2201: , p4_a10 out nocopy JTF_NUMBER_TABLE
2202: , p4_a11 out nocopy JTF_NUMBER_TABLE
2203: , p4_a12 out nocopy JTF_NUMBER_TABLE
2204: , p4_a13 out nocopy JTF_NUMBER_TABLE
2197: , p4_a6 out nocopy JTF_NUMBER_TABLE
2198: , p4_a7 out nocopy JTF_NUMBER_TABLE
2199: , p4_a8 out nocopy JTF_NUMBER_TABLE
2200: , p4_a9 out nocopy JTF_NUMBER_TABLE
2201: , p4_a10 out nocopy JTF_NUMBER_TABLE
2202: , p4_a11 out nocopy JTF_NUMBER_TABLE
2203: , p4_a12 out nocopy JTF_NUMBER_TABLE
2204: , p4_a13 out nocopy JTF_NUMBER_TABLE
2205: , p4_a14 out nocopy JTF_NUMBER_TABLE
2198: , p4_a7 out nocopy JTF_NUMBER_TABLE
2199: , p4_a8 out nocopy JTF_NUMBER_TABLE
2200: , p4_a9 out nocopy JTF_NUMBER_TABLE
2201: , p4_a10 out nocopy JTF_NUMBER_TABLE
2202: , p4_a11 out nocopy JTF_NUMBER_TABLE
2203: , p4_a12 out nocopy JTF_NUMBER_TABLE
2204: , p4_a13 out nocopy JTF_NUMBER_TABLE
2205: , p4_a14 out nocopy JTF_NUMBER_TABLE
2206: , p4_a15 out nocopy JTF_NUMBER_TABLE
2199: , p4_a8 out nocopy JTF_NUMBER_TABLE
2200: , p4_a9 out nocopy JTF_NUMBER_TABLE
2201: , p4_a10 out nocopy JTF_NUMBER_TABLE
2202: , p4_a11 out nocopy JTF_NUMBER_TABLE
2203: , p4_a12 out nocopy JTF_NUMBER_TABLE
2204: , p4_a13 out nocopy JTF_NUMBER_TABLE
2205: , p4_a14 out nocopy JTF_NUMBER_TABLE
2206: , p4_a15 out nocopy JTF_NUMBER_TABLE
2207: , p4_a16 out nocopy JTF_NUMBER_TABLE
2200: , p4_a9 out nocopy JTF_NUMBER_TABLE
2201: , p4_a10 out nocopy JTF_NUMBER_TABLE
2202: , p4_a11 out nocopy JTF_NUMBER_TABLE
2203: , p4_a12 out nocopy JTF_NUMBER_TABLE
2204: , p4_a13 out nocopy JTF_NUMBER_TABLE
2205: , p4_a14 out nocopy JTF_NUMBER_TABLE
2206: , p4_a15 out nocopy JTF_NUMBER_TABLE
2207: , p4_a16 out nocopy JTF_NUMBER_TABLE
2208: , p4_a17 out nocopy JTF_NUMBER_TABLE
2201: , p4_a10 out nocopy JTF_NUMBER_TABLE
2202: , p4_a11 out nocopy JTF_NUMBER_TABLE
2203: , p4_a12 out nocopy JTF_NUMBER_TABLE
2204: , p4_a13 out nocopy JTF_NUMBER_TABLE
2205: , p4_a14 out nocopy JTF_NUMBER_TABLE
2206: , p4_a15 out nocopy JTF_NUMBER_TABLE
2207: , p4_a16 out nocopy JTF_NUMBER_TABLE
2208: , p4_a17 out nocopy JTF_NUMBER_TABLE
2209: , p4_a18 out nocopy JTF_NUMBER_TABLE
2202: , p4_a11 out nocopy JTF_NUMBER_TABLE
2203: , p4_a12 out nocopy JTF_NUMBER_TABLE
2204: , p4_a13 out nocopy JTF_NUMBER_TABLE
2205: , p4_a14 out nocopy JTF_NUMBER_TABLE
2206: , p4_a15 out nocopy JTF_NUMBER_TABLE
2207: , p4_a16 out nocopy JTF_NUMBER_TABLE
2208: , p4_a17 out nocopy JTF_NUMBER_TABLE
2209: , p4_a18 out nocopy JTF_NUMBER_TABLE
2210: , p4_a19 out nocopy JTF_NUMBER_TABLE
2203: , p4_a12 out nocopy JTF_NUMBER_TABLE
2204: , p4_a13 out nocopy JTF_NUMBER_TABLE
2205: , p4_a14 out nocopy JTF_NUMBER_TABLE
2206: , p4_a15 out nocopy JTF_NUMBER_TABLE
2207: , p4_a16 out nocopy JTF_NUMBER_TABLE
2208: , p4_a17 out nocopy JTF_NUMBER_TABLE
2209: , p4_a18 out nocopy JTF_NUMBER_TABLE
2210: , p4_a19 out nocopy JTF_NUMBER_TABLE
2211: , p4_a20 out nocopy JTF_NUMBER_TABLE
2204: , p4_a13 out nocopy JTF_NUMBER_TABLE
2205: , p4_a14 out nocopy JTF_NUMBER_TABLE
2206: , p4_a15 out nocopy JTF_NUMBER_TABLE
2207: , p4_a16 out nocopy JTF_NUMBER_TABLE
2208: , p4_a17 out nocopy JTF_NUMBER_TABLE
2209: , p4_a18 out nocopy JTF_NUMBER_TABLE
2210: , p4_a19 out nocopy JTF_NUMBER_TABLE
2211: , p4_a20 out nocopy JTF_NUMBER_TABLE
2212: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
2205: , p4_a14 out nocopy JTF_NUMBER_TABLE
2206: , p4_a15 out nocopy JTF_NUMBER_TABLE
2207: , p4_a16 out nocopy JTF_NUMBER_TABLE
2208: , p4_a17 out nocopy JTF_NUMBER_TABLE
2209: , p4_a18 out nocopy JTF_NUMBER_TABLE
2210: , p4_a19 out nocopy JTF_NUMBER_TABLE
2211: , p4_a20 out nocopy JTF_NUMBER_TABLE
2212: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
2213: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
2206: , p4_a15 out nocopy JTF_NUMBER_TABLE
2207: , p4_a16 out nocopy JTF_NUMBER_TABLE
2208: , p4_a17 out nocopy JTF_NUMBER_TABLE
2209: , p4_a18 out nocopy JTF_NUMBER_TABLE
2210: , p4_a19 out nocopy JTF_NUMBER_TABLE
2211: , p4_a20 out nocopy JTF_NUMBER_TABLE
2212: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
2213: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
2214: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
2207: , p4_a16 out nocopy JTF_NUMBER_TABLE
2208: , p4_a17 out nocopy JTF_NUMBER_TABLE
2209: , p4_a18 out nocopy JTF_NUMBER_TABLE
2210: , p4_a19 out nocopy JTF_NUMBER_TABLE
2211: , p4_a20 out nocopy JTF_NUMBER_TABLE
2212: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
2213: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
2214: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
2215: , p4_a24 out nocopy JTF_NUMBER_TABLE
2211: , p4_a20 out nocopy JTF_NUMBER_TABLE
2212: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
2213: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
2214: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
2215: , p4_a24 out nocopy JTF_NUMBER_TABLE
2216: , p4_a25 out nocopy JTF_NUMBER_TABLE
2217: , p4_a26 out nocopy JTF_NUMBER_TABLE
2218: , p4_a27 out nocopy JTF_NUMBER_TABLE
2219: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2212: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
2213: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
2214: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
2215: , p4_a24 out nocopy JTF_NUMBER_TABLE
2216: , p4_a25 out nocopy JTF_NUMBER_TABLE
2217: , p4_a26 out nocopy JTF_NUMBER_TABLE
2218: , p4_a27 out nocopy JTF_NUMBER_TABLE
2219: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2220: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2213: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
2214: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
2215: , p4_a24 out nocopy JTF_NUMBER_TABLE
2216: , p4_a25 out nocopy JTF_NUMBER_TABLE
2217: , p4_a26 out nocopy JTF_NUMBER_TABLE
2218: , p4_a27 out nocopy JTF_NUMBER_TABLE
2219: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2220: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2221: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2214: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
2215: , p4_a24 out nocopy JTF_NUMBER_TABLE
2216: , p4_a25 out nocopy JTF_NUMBER_TABLE
2217: , p4_a26 out nocopy JTF_NUMBER_TABLE
2218: , p4_a27 out nocopy JTF_NUMBER_TABLE
2219: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2220: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2221: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2222: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2219: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2220: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2221: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2222: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2223: , p4_a32 out nocopy JTF_NUMBER_TABLE
2224: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
2225: , p4_a34 out nocopy JTF_NUMBER_TABLE
2226: , p4_a35 out nocopy JTF_NUMBER_TABLE
2227: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2221: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2222: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2223: , p4_a32 out nocopy JTF_NUMBER_TABLE
2224: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
2225: , p4_a34 out nocopy JTF_NUMBER_TABLE
2226: , p4_a35 out nocopy JTF_NUMBER_TABLE
2227: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2228: , p4_a37 out nocopy JTF_NUMBER_TABLE
2229: , p4_a38 out nocopy JTF_NUMBER_TABLE
2222: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2223: , p4_a32 out nocopy JTF_NUMBER_TABLE
2224: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
2225: , p4_a34 out nocopy JTF_NUMBER_TABLE
2226: , p4_a35 out nocopy JTF_NUMBER_TABLE
2227: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2228: , p4_a37 out nocopy JTF_NUMBER_TABLE
2229: , p4_a38 out nocopy JTF_NUMBER_TABLE
2230: , p4_a39 out nocopy JTF_NUMBER_TABLE
2224: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
2225: , p4_a34 out nocopy JTF_NUMBER_TABLE
2226: , p4_a35 out nocopy JTF_NUMBER_TABLE
2227: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2228: , p4_a37 out nocopy JTF_NUMBER_TABLE
2229: , p4_a38 out nocopy JTF_NUMBER_TABLE
2230: , p4_a39 out nocopy JTF_NUMBER_TABLE
2231: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2232: , p4_a41 out nocopy JTF_NUMBER_TABLE
2225: , p4_a34 out nocopy JTF_NUMBER_TABLE
2226: , p4_a35 out nocopy JTF_NUMBER_TABLE
2227: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2228: , p4_a37 out nocopy JTF_NUMBER_TABLE
2229: , p4_a38 out nocopy JTF_NUMBER_TABLE
2230: , p4_a39 out nocopy JTF_NUMBER_TABLE
2231: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2232: , p4_a41 out nocopy JTF_NUMBER_TABLE
2233: , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000
2226: , p4_a35 out nocopy JTF_NUMBER_TABLE
2227: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2228: , p4_a37 out nocopy JTF_NUMBER_TABLE
2229: , p4_a38 out nocopy JTF_NUMBER_TABLE
2230: , p4_a39 out nocopy JTF_NUMBER_TABLE
2231: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2232: , p4_a41 out nocopy JTF_NUMBER_TABLE
2233: , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000
2234: )
2228: , p4_a37 out nocopy JTF_NUMBER_TABLE
2229: , p4_a38 out nocopy JTF_NUMBER_TABLE
2230: , p4_a39 out nocopy JTF_NUMBER_TABLE
2231: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2232: , p4_a41 out nocopy JTF_NUMBER_TABLE
2233: , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000
2234: )
2235:
2236: as
2423:
2424: procedure amortizeloan(p_loan_id NUMBER
2425: , p_based_on_terms VARCHAR2
2426: , p_installment_number NUMBER
2427: , p3_a0 out nocopy JTF_NUMBER_TABLE
2428: , p3_a1 out nocopy JTF_DATE_TABLE
2429: , p3_a2 out nocopy JTF_DATE_TABLE
2430: , p3_a3 out nocopy JTF_DATE_TABLE
2431: , p3_a4 out nocopy JTF_NUMBER_TABLE
2427: , p3_a0 out nocopy JTF_NUMBER_TABLE
2428: , p3_a1 out nocopy JTF_DATE_TABLE
2429: , p3_a2 out nocopy JTF_DATE_TABLE
2430: , p3_a3 out nocopy JTF_DATE_TABLE
2431: , p3_a4 out nocopy JTF_NUMBER_TABLE
2432: , p3_a5 out nocopy JTF_NUMBER_TABLE
2433: , p3_a6 out nocopy JTF_NUMBER_TABLE
2434: , p3_a7 out nocopy JTF_NUMBER_TABLE
2435: , p3_a8 out nocopy JTF_NUMBER_TABLE
2428: , p3_a1 out nocopy JTF_DATE_TABLE
2429: , p3_a2 out nocopy JTF_DATE_TABLE
2430: , p3_a3 out nocopy JTF_DATE_TABLE
2431: , p3_a4 out nocopy JTF_NUMBER_TABLE
2432: , p3_a5 out nocopy JTF_NUMBER_TABLE
2433: , p3_a6 out nocopy JTF_NUMBER_TABLE
2434: , p3_a7 out nocopy JTF_NUMBER_TABLE
2435: , p3_a8 out nocopy JTF_NUMBER_TABLE
2436: , p3_a9 out nocopy JTF_NUMBER_TABLE
2429: , p3_a2 out nocopy JTF_DATE_TABLE
2430: , p3_a3 out nocopy JTF_DATE_TABLE
2431: , p3_a4 out nocopy JTF_NUMBER_TABLE
2432: , p3_a5 out nocopy JTF_NUMBER_TABLE
2433: , p3_a6 out nocopy JTF_NUMBER_TABLE
2434: , p3_a7 out nocopy JTF_NUMBER_TABLE
2435: , p3_a8 out nocopy JTF_NUMBER_TABLE
2436: , p3_a9 out nocopy JTF_NUMBER_TABLE
2437: , p3_a10 out nocopy JTF_NUMBER_TABLE
2430: , p3_a3 out nocopy JTF_DATE_TABLE
2431: , p3_a4 out nocopy JTF_NUMBER_TABLE
2432: , p3_a5 out nocopy JTF_NUMBER_TABLE
2433: , p3_a6 out nocopy JTF_NUMBER_TABLE
2434: , p3_a7 out nocopy JTF_NUMBER_TABLE
2435: , p3_a8 out nocopy JTF_NUMBER_TABLE
2436: , p3_a9 out nocopy JTF_NUMBER_TABLE
2437: , p3_a10 out nocopy JTF_NUMBER_TABLE
2438: , p3_a11 out nocopy JTF_NUMBER_TABLE
2431: , p3_a4 out nocopy JTF_NUMBER_TABLE
2432: , p3_a5 out nocopy JTF_NUMBER_TABLE
2433: , p3_a6 out nocopy JTF_NUMBER_TABLE
2434: , p3_a7 out nocopy JTF_NUMBER_TABLE
2435: , p3_a8 out nocopy JTF_NUMBER_TABLE
2436: , p3_a9 out nocopy JTF_NUMBER_TABLE
2437: , p3_a10 out nocopy JTF_NUMBER_TABLE
2438: , p3_a11 out nocopy JTF_NUMBER_TABLE
2439: , p3_a12 out nocopy JTF_NUMBER_TABLE
2432: , p3_a5 out nocopy JTF_NUMBER_TABLE
2433: , p3_a6 out nocopy JTF_NUMBER_TABLE
2434: , p3_a7 out nocopy JTF_NUMBER_TABLE
2435: , p3_a8 out nocopy JTF_NUMBER_TABLE
2436: , p3_a9 out nocopy JTF_NUMBER_TABLE
2437: , p3_a10 out nocopy JTF_NUMBER_TABLE
2438: , p3_a11 out nocopy JTF_NUMBER_TABLE
2439: , p3_a12 out nocopy JTF_NUMBER_TABLE
2440: , p3_a13 out nocopy JTF_NUMBER_TABLE
2433: , p3_a6 out nocopy JTF_NUMBER_TABLE
2434: , p3_a7 out nocopy JTF_NUMBER_TABLE
2435: , p3_a8 out nocopy JTF_NUMBER_TABLE
2436: , p3_a9 out nocopy JTF_NUMBER_TABLE
2437: , p3_a10 out nocopy JTF_NUMBER_TABLE
2438: , p3_a11 out nocopy JTF_NUMBER_TABLE
2439: , p3_a12 out nocopy JTF_NUMBER_TABLE
2440: , p3_a13 out nocopy JTF_NUMBER_TABLE
2441: , p3_a14 out nocopy JTF_NUMBER_TABLE
2434: , p3_a7 out nocopy JTF_NUMBER_TABLE
2435: , p3_a8 out nocopy JTF_NUMBER_TABLE
2436: , p3_a9 out nocopy JTF_NUMBER_TABLE
2437: , p3_a10 out nocopy JTF_NUMBER_TABLE
2438: , p3_a11 out nocopy JTF_NUMBER_TABLE
2439: , p3_a12 out nocopy JTF_NUMBER_TABLE
2440: , p3_a13 out nocopy JTF_NUMBER_TABLE
2441: , p3_a14 out nocopy JTF_NUMBER_TABLE
2442: , p3_a15 out nocopy JTF_NUMBER_TABLE
2435: , p3_a8 out nocopy JTF_NUMBER_TABLE
2436: , p3_a9 out nocopy JTF_NUMBER_TABLE
2437: , p3_a10 out nocopy JTF_NUMBER_TABLE
2438: , p3_a11 out nocopy JTF_NUMBER_TABLE
2439: , p3_a12 out nocopy JTF_NUMBER_TABLE
2440: , p3_a13 out nocopy JTF_NUMBER_TABLE
2441: , p3_a14 out nocopy JTF_NUMBER_TABLE
2442: , p3_a15 out nocopy JTF_NUMBER_TABLE
2443: , p3_a16 out nocopy JTF_NUMBER_TABLE
2436: , p3_a9 out nocopy JTF_NUMBER_TABLE
2437: , p3_a10 out nocopy JTF_NUMBER_TABLE
2438: , p3_a11 out nocopy JTF_NUMBER_TABLE
2439: , p3_a12 out nocopy JTF_NUMBER_TABLE
2440: , p3_a13 out nocopy JTF_NUMBER_TABLE
2441: , p3_a14 out nocopy JTF_NUMBER_TABLE
2442: , p3_a15 out nocopy JTF_NUMBER_TABLE
2443: , p3_a16 out nocopy JTF_NUMBER_TABLE
2444: , p3_a17 out nocopy JTF_NUMBER_TABLE
2437: , p3_a10 out nocopy JTF_NUMBER_TABLE
2438: , p3_a11 out nocopy JTF_NUMBER_TABLE
2439: , p3_a12 out nocopy JTF_NUMBER_TABLE
2440: , p3_a13 out nocopy JTF_NUMBER_TABLE
2441: , p3_a14 out nocopy JTF_NUMBER_TABLE
2442: , p3_a15 out nocopy JTF_NUMBER_TABLE
2443: , p3_a16 out nocopy JTF_NUMBER_TABLE
2444: , p3_a17 out nocopy JTF_NUMBER_TABLE
2445: , p3_a18 out nocopy JTF_NUMBER_TABLE
2438: , p3_a11 out nocopy JTF_NUMBER_TABLE
2439: , p3_a12 out nocopy JTF_NUMBER_TABLE
2440: , p3_a13 out nocopy JTF_NUMBER_TABLE
2441: , p3_a14 out nocopy JTF_NUMBER_TABLE
2442: , p3_a15 out nocopy JTF_NUMBER_TABLE
2443: , p3_a16 out nocopy JTF_NUMBER_TABLE
2444: , p3_a17 out nocopy JTF_NUMBER_TABLE
2445: , p3_a18 out nocopy JTF_NUMBER_TABLE
2446: , p3_a19 out nocopy JTF_NUMBER_TABLE
2439: , p3_a12 out nocopy JTF_NUMBER_TABLE
2440: , p3_a13 out nocopy JTF_NUMBER_TABLE
2441: , p3_a14 out nocopy JTF_NUMBER_TABLE
2442: , p3_a15 out nocopy JTF_NUMBER_TABLE
2443: , p3_a16 out nocopy JTF_NUMBER_TABLE
2444: , p3_a17 out nocopy JTF_NUMBER_TABLE
2445: , p3_a18 out nocopy JTF_NUMBER_TABLE
2446: , p3_a19 out nocopy JTF_NUMBER_TABLE
2447: , p3_a20 out nocopy JTF_NUMBER_TABLE
2440: , p3_a13 out nocopy JTF_NUMBER_TABLE
2441: , p3_a14 out nocopy JTF_NUMBER_TABLE
2442: , p3_a15 out nocopy JTF_NUMBER_TABLE
2443: , p3_a16 out nocopy JTF_NUMBER_TABLE
2444: , p3_a17 out nocopy JTF_NUMBER_TABLE
2445: , p3_a18 out nocopy JTF_NUMBER_TABLE
2446: , p3_a19 out nocopy JTF_NUMBER_TABLE
2447: , p3_a20 out nocopy JTF_NUMBER_TABLE
2448: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2441: , p3_a14 out nocopy JTF_NUMBER_TABLE
2442: , p3_a15 out nocopy JTF_NUMBER_TABLE
2443: , p3_a16 out nocopy JTF_NUMBER_TABLE
2444: , p3_a17 out nocopy JTF_NUMBER_TABLE
2445: , p3_a18 out nocopy JTF_NUMBER_TABLE
2446: , p3_a19 out nocopy JTF_NUMBER_TABLE
2447: , p3_a20 out nocopy JTF_NUMBER_TABLE
2448: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2449: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2442: , p3_a15 out nocopy JTF_NUMBER_TABLE
2443: , p3_a16 out nocopy JTF_NUMBER_TABLE
2444: , p3_a17 out nocopy JTF_NUMBER_TABLE
2445: , p3_a18 out nocopy JTF_NUMBER_TABLE
2446: , p3_a19 out nocopy JTF_NUMBER_TABLE
2447: , p3_a20 out nocopy JTF_NUMBER_TABLE
2448: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2449: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2450: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2443: , p3_a16 out nocopy JTF_NUMBER_TABLE
2444: , p3_a17 out nocopy JTF_NUMBER_TABLE
2445: , p3_a18 out nocopy JTF_NUMBER_TABLE
2446: , p3_a19 out nocopy JTF_NUMBER_TABLE
2447: , p3_a20 out nocopy JTF_NUMBER_TABLE
2448: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2449: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2450: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2451: , p3_a24 out nocopy JTF_NUMBER_TABLE
2447: , p3_a20 out nocopy JTF_NUMBER_TABLE
2448: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2449: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2450: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2451: , p3_a24 out nocopy JTF_NUMBER_TABLE
2452: , p3_a25 out nocopy JTF_NUMBER_TABLE
2453: , p3_a26 out nocopy JTF_NUMBER_TABLE
2454: , p3_a27 out nocopy JTF_NUMBER_TABLE
2455: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2448: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2449: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2450: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2451: , p3_a24 out nocopy JTF_NUMBER_TABLE
2452: , p3_a25 out nocopy JTF_NUMBER_TABLE
2453: , p3_a26 out nocopy JTF_NUMBER_TABLE
2454: , p3_a27 out nocopy JTF_NUMBER_TABLE
2455: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2456: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2449: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2450: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2451: , p3_a24 out nocopy JTF_NUMBER_TABLE
2452: , p3_a25 out nocopy JTF_NUMBER_TABLE
2453: , p3_a26 out nocopy JTF_NUMBER_TABLE
2454: , p3_a27 out nocopy JTF_NUMBER_TABLE
2455: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2456: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2457: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2450: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2451: , p3_a24 out nocopy JTF_NUMBER_TABLE
2452: , p3_a25 out nocopy JTF_NUMBER_TABLE
2453: , p3_a26 out nocopy JTF_NUMBER_TABLE
2454: , p3_a27 out nocopy JTF_NUMBER_TABLE
2455: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2456: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2457: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2458: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2455: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2456: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2457: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2458: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2459: , p3_a32 out nocopy JTF_NUMBER_TABLE
2460: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
2461: , p3_a34 out nocopy JTF_NUMBER_TABLE
2462: , p3_a35 out nocopy JTF_NUMBER_TABLE
2463: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2457: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2458: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2459: , p3_a32 out nocopy JTF_NUMBER_TABLE
2460: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
2461: , p3_a34 out nocopy JTF_NUMBER_TABLE
2462: , p3_a35 out nocopy JTF_NUMBER_TABLE
2463: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2464: , p3_a37 out nocopy JTF_NUMBER_TABLE
2465: , p3_a38 out nocopy JTF_NUMBER_TABLE
2458: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2459: , p3_a32 out nocopy JTF_NUMBER_TABLE
2460: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
2461: , p3_a34 out nocopy JTF_NUMBER_TABLE
2462: , p3_a35 out nocopy JTF_NUMBER_TABLE
2463: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2464: , p3_a37 out nocopy JTF_NUMBER_TABLE
2465: , p3_a38 out nocopy JTF_NUMBER_TABLE
2466: , p3_a39 out nocopy JTF_NUMBER_TABLE
2460: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
2461: , p3_a34 out nocopy JTF_NUMBER_TABLE
2462: , p3_a35 out nocopy JTF_NUMBER_TABLE
2463: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2464: , p3_a37 out nocopy JTF_NUMBER_TABLE
2465: , p3_a38 out nocopy JTF_NUMBER_TABLE
2466: , p3_a39 out nocopy JTF_NUMBER_TABLE
2467: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2468: , p3_a41 out nocopy JTF_NUMBER_TABLE
2461: , p3_a34 out nocopy JTF_NUMBER_TABLE
2462: , p3_a35 out nocopy JTF_NUMBER_TABLE
2463: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2464: , p3_a37 out nocopy JTF_NUMBER_TABLE
2465: , p3_a38 out nocopy JTF_NUMBER_TABLE
2466: , p3_a39 out nocopy JTF_NUMBER_TABLE
2467: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2468: , p3_a41 out nocopy JTF_NUMBER_TABLE
2469: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
2462: , p3_a35 out nocopy JTF_NUMBER_TABLE
2463: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2464: , p3_a37 out nocopy JTF_NUMBER_TABLE
2465: , p3_a38 out nocopy JTF_NUMBER_TABLE
2466: , p3_a39 out nocopy JTF_NUMBER_TABLE
2467: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2468: , p3_a41 out nocopy JTF_NUMBER_TABLE
2469: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
2470: )
2464: , p3_a37 out nocopy JTF_NUMBER_TABLE
2465: , p3_a38 out nocopy JTF_NUMBER_TABLE
2466: , p3_a39 out nocopy JTF_NUMBER_TABLE
2467: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2468: , p3_a41 out nocopy JTF_NUMBER_TABLE
2469: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
2470: )
2471:
2472: as
2631: , p0_a93 VARCHAR2
2632: , p0_a94 VARCHAR2
2633: , p0_a95 VARCHAR2
2634: , p_based_on_terms VARCHAR2
2635: , p2_a0 JTF_NUMBER_TABLE
2636: , p2_a1 JTF_DATE_TABLE
2637: , p2_a2 JTF_DATE_TABLE
2638: , p2_a3 JTF_NUMBER_TABLE
2639: , p2_a4 JTF_NUMBER_TABLE
2634: , p_based_on_terms VARCHAR2
2635: , p2_a0 JTF_NUMBER_TABLE
2636: , p2_a1 JTF_DATE_TABLE
2637: , p2_a2 JTF_DATE_TABLE
2638: , p2_a3 JTF_NUMBER_TABLE
2639: , p2_a4 JTF_NUMBER_TABLE
2640: , p2_a5 JTF_NUMBER_TABLE
2641: , p2_a6 JTF_NUMBER_TABLE
2642: , p2_a7 JTF_VARCHAR2_TABLE_100
2635: , p2_a0 JTF_NUMBER_TABLE
2636: , p2_a1 JTF_DATE_TABLE
2637: , p2_a2 JTF_DATE_TABLE
2638: , p2_a3 JTF_NUMBER_TABLE
2639: , p2_a4 JTF_NUMBER_TABLE
2640: , p2_a5 JTF_NUMBER_TABLE
2641: , p2_a6 JTF_NUMBER_TABLE
2642: , p2_a7 JTF_VARCHAR2_TABLE_100
2643: , p2_a8 JTF_VARCHAR2_TABLE_100
2636: , p2_a1 JTF_DATE_TABLE
2637: , p2_a2 JTF_DATE_TABLE
2638: , p2_a3 JTF_NUMBER_TABLE
2639: , p2_a4 JTF_NUMBER_TABLE
2640: , p2_a5 JTF_NUMBER_TABLE
2641: , p2_a6 JTF_NUMBER_TABLE
2642: , p2_a7 JTF_VARCHAR2_TABLE_100
2643: , p2_a8 JTF_VARCHAR2_TABLE_100
2644: , p2_a9 JTF_VARCHAR2_TABLE_100
2637: , p2_a2 JTF_DATE_TABLE
2638: , p2_a3 JTF_NUMBER_TABLE
2639: , p2_a4 JTF_NUMBER_TABLE
2640: , p2_a5 JTF_NUMBER_TABLE
2641: , p2_a6 JTF_NUMBER_TABLE
2642: , p2_a7 JTF_VARCHAR2_TABLE_100
2643: , p2_a8 JTF_VARCHAR2_TABLE_100
2644: , p2_a9 JTF_VARCHAR2_TABLE_100
2645: , p3_a0 out nocopy JTF_NUMBER_TABLE
2641: , p2_a6 JTF_NUMBER_TABLE
2642: , p2_a7 JTF_VARCHAR2_TABLE_100
2643: , p2_a8 JTF_VARCHAR2_TABLE_100
2644: , p2_a9 JTF_VARCHAR2_TABLE_100
2645: , p3_a0 out nocopy JTF_NUMBER_TABLE
2646: , p3_a1 out nocopy JTF_DATE_TABLE
2647: , p3_a2 out nocopy JTF_DATE_TABLE
2648: , p3_a3 out nocopy JTF_DATE_TABLE
2649: , p3_a4 out nocopy JTF_NUMBER_TABLE
2645: , p3_a0 out nocopy JTF_NUMBER_TABLE
2646: , p3_a1 out nocopy JTF_DATE_TABLE
2647: , p3_a2 out nocopy JTF_DATE_TABLE
2648: , p3_a3 out nocopy JTF_DATE_TABLE
2649: , p3_a4 out nocopy JTF_NUMBER_TABLE
2650: , p3_a5 out nocopy JTF_NUMBER_TABLE
2651: , p3_a6 out nocopy JTF_NUMBER_TABLE
2652: , p3_a7 out nocopy JTF_NUMBER_TABLE
2653: , p3_a8 out nocopy JTF_NUMBER_TABLE
2646: , p3_a1 out nocopy JTF_DATE_TABLE
2647: , p3_a2 out nocopy JTF_DATE_TABLE
2648: , p3_a3 out nocopy JTF_DATE_TABLE
2649: , p3_a4 out nocopy JTF_NUMBER_TABLE
2650: , p3_a5 out nocopy JTF_NUMBER_TABLE
2651: , p3_a6 out nocopy JTF_NUMBER_TABLE
2652: , p3_a7 out nocopy JTF_NUMBER_TABLE
2653: , p3_a8 out nocopy JTF_NUMBER_TABLE
2654: , p3_a9 out nocopy JTF_NUMBER_TABLE
2647: , p3_a2 out nocopy JTF_DATE_TABLE
2648: , p3_a3 out nocopy JTF_DATE_TABLE
2649: , p3_a4 out nocopy JTF_NUMBER_TABLE
2650: , p3_a5 out nocopy JTF_NUMBER_TABLE
2651: , p3_a6 out nocopy JTF_NUMBER_TABLE
2652: , p3_a7 out nocopy JTF_NUMBER_TABLE
2653: , p3_a8 out nocopy JTF_NUMBER_TABLE
2654: , p3_a9 out nocopy JTF_NUMBER_TABLE
2655: , p3_a10 out nocopy JTF_NUMBER_TABLE
2648: , p3_a3 out nocopy JTF_DATE_TABLE
2649: , p3_a4 out nocopy JTF_NUMBER_TABLE
2650: , p3_a5 out nocopy JTF_NUMBER_TABLE
2651: , p3_a6 out nocopy JTF_NUMBER_TABLE
2652: , p3_a7 out nocopy JTF_NUMBER_TABLE
2653: , p3_a8 out nocopy JTF_NUMBER_TABLE
2654: , p3_a9 out nocopy JTF_NUMBER_TABLE
2655: , p3_a10 out nocopy JTF_NUMBER_TABLE
2656: , p3_a11 out nocopy JTF_NUMBER_TABLE
2649: , p3_a4 out nocopy JTF_NUMBER_TABLE
2650: , p3_a5 out nocopy JTF_NUMBER_TABLE
2651: , p3_a6 out nocopy JTF_NUMBER_TABLE
2652: , p3_a7 out nocopy JTF_NUMBER_TABLE
2653: , p3_a8 out nocopy JTF_NUMBER_TABLE
2654: , p3_a9 out nocopy JTF_NUMBER_TABLE
2655: , p3_a10 out nocopy JTF_NUMBER_TABLE
2656: , p3_a11 out nocopy JTF_NUMBER_TABLE
2657: , p3_a12 out nocopy JTF_NUMBER_TABLE
2650: , p3_a5 out nocopy JTF_NUMBER_TABLE
2651: , p3_a6 out nocopy JTF_NUMBER_TABLE
2652: , p3_a7 out nocopy JTF_NUMBER_TABLE
2653: , p3_a8 out nocopy JTF_NUMBER_TABLE
2654: , p3_a9 out nocopy JTF_NUMBER_TABLE
2655: , p3_a10 out nocopy JTF_NUMBER_TABLE
2656: , p3_a11 out nocopy JTF_NUMBER_TABLE
2657: , p3_a12 out nocopy JTF_NUMBER_TABLE
2658: , p3_a13 out nocopy JTF_NUMBER_TABLE
2651: , p3_a6 out nocopy JTF_NUMBER_TABLE
2652: , p3_a7 out nocopy JTF_NUMBER_TABLE
2653: , p3_a8 out nocopy JTF_NUMBER_TABLE
2654: , p3_a9 out nocopy JTF_NUMBER_TABLE
2655: , p3_a10 out nocopy JTF_NUMBER_TABLE
2656: , p3_a11 out nocopy JTF_NUMBER_TABLE
2657: , p3_a12 out nocopy JTF_NUMBER_TABLE
2658: , p3_a13 out nocopy JTF_NUMBER_TABLE
2659: , p3_a14 out nocopy JTF_NUMBER_TABLE
2652: , p3_a7 out nocopy JTF_NUMBER_TABLE
2653: , p3_a8 out nocopy JTF_NUMBER_TABLE
2654: , p3_a9 out nocopy JTF_NUMBER_TABLE
2655: , p3_a10 out nocopy JTF_NUMBER_TABLE
2656: , p3_a11 out nocopy JTF_NUMBER_TABLE
2657: , p3_a12 out nocopy JTF_NUMBER_TABLE
2658: , p3_a13 out nocopy JTF_NUMBER_TABLE
2659: , p3_a14 out nocopy JTF_NUMBER_TABLE
2660: , p3_a15 out nocopy JTF_NUMBER_TABLE
2653: , p3_a8 out nocopy JTF_NUMBER_TABLE
2654: , p3_a9 out nocopy JTF_NUMBER_TABLE
2655: , p3_a10 out nocopy JTF_NUMBER_TABLE
2656: , p3_a11 out nocopy JTF_NUMBER_TABLE
2657: , p3_a12 out nocopy JTF_NUMBER_TABLE
2658: , p3_a13 out nocopy JTF_NUMBER_TABLE
2659: , p3_a14 out nocopy JTF_NUMBER_TABLE
2660: , p3_a15 out nocopy JTF_NUMBER_TABLE
2661: , p3_a16 out nocopy JTF_NUMBER_TABLE
2654: , p3_a9 out nocopy JTF_NUMBER_TABLE
2655: , p3_a10 out nocopy JTF_NUMBER_TABLE
2656: , p3_a11 out nocopy JTF_NUMBER_TABLE
2657: , p3_a12 out nocopy JTF_NUMBER_TABLE
2658: , p3_a13 out nocopy JTF_NUMBER_TABLE
2659: , p3_a14 out nocopy JTF_NUMBER_TABLE
2660: , p3_a15 out nocopy JTF_NUMBER_TABLE
2661: , p3_a16 out nocopy JTF_NUMBER_TABLE
2662: , p3_a17 out nocopy JTF_NUMBER_TABLE
2655: , p3_a10 out nocopy JTF_NUMBER_TABLE
2656: , p3_a11 out nocopy JTF_NUMBER_TABLE
2657: , p3_a12 out nocopy JTF_NUMBER_TABLE
2658: , p3_a13 out nocopy JTF_NUMBER_TABLE
2659: , p3_a14 out nocopy JTF_NUMBER_TABLE
2660: , p3_a15 out nocopy JTF_NUMBER_TABLE
2661: , p3_a16 out nocopy JTF_NUMBER_TABLE
2662: , p3_a17 out nocopy JTF_NUMBER_TABLE
2663: , p3_a18 out nocopy JTF_NUMBER_TABLE
2656: , p3_a11 out nocopy JTF_NUMBER_TABLE
2657: , p3_a12 out nocopy JTF_NUMBER_TABLE
2658: , p3_a13 out nocopy JTF_NUMBER_TABLE
2659: , p3_a14 out nocopy JTF_NUMBER_TABLE
2660: , p3_a15 out nocopy JTF_NUMBER_TABLE
2661: , p3_a16 out nocopy JTF_NUMBER_TABLE
2662: , p3_a17 out nocopy JTF_NUMBER_TABLE
2663: , p3_a18 out nocopy JTF_NUMBER_TABLE
2664: , p3_a19 out nocopy JTF_NUMBER_TABLE
2657: , p3_a12 out nocopy JTF_NUMBER_TABLE
2658: , p3_a13 out nocopy JTF_NUMBER_TABLE
2659: , p3_a14 out nocopy JTF_NUMBER_TABLE
2660: , p3_a15 out nocopy JTF_NUMBER_TABLE
2661: , p3_a16 out nocopy JTF_NUMBER_TABLE
2662: , p3_a17 out nocopy JTF_NUMBER_TABLE
2663: , p3_a18 out nocopy JTF_NUMBER_TABLE
2664: , p3_a19 out nocopy JTF_NUMBER_TABLE
2665: , p3_a20 out nocopy JTF_NUMBER_TABLE
2658: , p3_a13 out nocopy JTF_NUMBER_TABLE
2659: , p3_a14 out nocopy JTF_NUMBER_TABLE
2660: , p3_a15 out nocopy JTF_NUMBER_TABLE
2661: , p3_a16 out nocopy JTF_NUMBER_TABLE
2662: , p3_a17 out nocopy JTF_NUMBER_TABLE
2663: , p3_a18 out nocopy JTF_NUMBER_TABLE
2664: , p3_a19 out nocopy JTF_NUMBER_TABLE
2665: , p3_a20 out nocopy JTF_NUMBER_TABLE
2666: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2659: , p3_a14 out nocopy JTF_NUMBER_TABLE
2660: , p3_a15 out nocopy JTF_NUMBER_TABLE
2661: , p3_a16 out nocopy JTF_NUMBER_TABLE
2662: , p3_a17 out nocopy JTF_NUMBER_TABLE
2663: , p3_a18 out nocopy JTF_NUMBER_TABLE
2664: , p3_a19 out nocopy JTF_NUMBER_TABLE
2665: , p3_a20 out nocopy JTF_NUMBER_TABLE
2666: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2667: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2660: , p3_a15 out nocopy JTF_NUMBER_TABLE
2661: , p3_a16 out nocopy JTF_NUMBER_TABLE
2662: , p3_a17 out nocopy JTF_NUMBER_TABLE
2663: , p3_a18 out nocopy JTF_NUMBER_TABLE
2664: , p3_a19 out nocopy JTF_NUMBER_TABLE
2665: , p3_a20 out nocopy JTF_NUMBER_TABLE
2666: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2667: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2668: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2661: , p3_a16 out nocopy JTF_NUMBER_TABLE
2662: , p3_a17 out nocopy JTF_NUMBER_TABLE
2663: , p3_a18 out nocopy JTF_NUMBER_TABLE
2664: , p3_a19 out nocopy JTF_NUMBER_TABLE
2665: , p3_a20 out nocopy JTF_NUMBER_TABLE
2666: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2667: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2668: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2669: , p3_a24 out nocopy JTF_NUMBER_TABLE
2665: , p3_a20 out nocopy JTF_NUMBER_TABLE
2666: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2667: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2668: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2669: , p3_a24 out nocopy JTF_NUMBER_TABLE
2670: , p3_a25 out nocopy JTF_NUMBER_TABLE
2671: , p3_a26 out nocopy JTF_NUMBER_TABLE
2672: , p3_a27 out nocopy JTF_NUMBER_TABLE
2673: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2666: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2667: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2668: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2669: , p3_a24 out nocopy JTF_NUMBER_TABLE
2670: , p3_a25 out nocopy JTF_NUMBER_TABLE
2671: , p3_a26 out nocopy JTF_NUMBER_TABLE
2672: , p3_a27 out nocopy JTF_NUMBER_TABLE
2673: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2674: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2667: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2668: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2669: , p3_a24 out nocopy JTF_NUMBER_TABLE
2670: , p3_a25 out nocopy JTF_NUMBER_TABLE
2671: , p3_a26 out nocopy JTF_NUMBER_TABLE
2672: , p3_a27 out nocopy JTF_NUMBER_TABLE
2673: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2674: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2675: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2668: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2669: , p3_a24 out nocopy JTF_NUMBER_TABLE
2670: , p3_a25 out nocopy JTF_NUMBER_TABLE
2671: , p3_a26 out nocopy JTF_NUMBER_TABLE
2672: , p3_a27 out nocopy JTF_NUMBER_TABLE
2673: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2674: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2675: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2676: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2673: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2674: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2675: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2676: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2677: , p3_a32 out nocopy JTF_NUMBER_TABLE
2678: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
2679: , p3_a34 out nocopy JTF_NUMBER_TABLE
2680: , p3_a35 out nocopy JTF_NUMBER_TABLE
2681: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2675: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2676: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2677: , p3_a32 out nocopy JTF_NUMBER_TABLE
2678: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
2679: , p3_a34 out nocopy JTF_NUMBER_TABLE
2680: , p3_a35 out nocopy JTF_NUMBER_TABLE
2681: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2682: , p3_a37 out nocopy JTF_NUMBER_TABLE
2683: , p3_a38 out nocopy JTF_NUMBER_TABLE
2676: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2677: , p3_a32 out nocopy JTF_NUMBER_TABLE
2678: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
2679: , p3_a34 out nocopy JTF_NUMBER_TABLE
2680: , p3_a35 out nocopy JTF_NUMBER_TABLE
2681: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2682: , p3_a37 out nocopy JTF_NUMBER_TABLE
2683: , p3_a38 out nocopy JTF_NUMBER_TABLE
2684: , p3_a39 out nocopy JTF_NUMBER_TABLE
2678: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
2679: , p3_a34 out nocopy JTF_NUMBER_TABLE
2680: , p3_a35 out nocopy JTF_NUMBER_TABLE
2681: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2682: , p3_a37 out nocopy JTF_NUMBER_TABLE
2683: , p3_a38 out nocopy JTF_NUMBER_TABLE
2684: , p3_a39 out nocopy JTF_NUMBER_TABLE
2685: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2686: , p3_a41 out nocopy JTF_NUMBER_TABLE
2679: , p3_a34 out nocopy JTF_NUMBER_TABLE
2680: , p3_a35 out nocopy JTF_NUMBER_TABLE
2681: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2682: , p3_a37 out nocopy JTF_NUMBER_TABLE
2683: , p3_a38 out nocopy JTF_NUMBER_TABLE
2684: , p3_a39 out nocopy JTF_NUMBER_TABLE
2685: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2686: , p3_a41 out nocopy JTF_NUMBER_TABLE
2687: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
2680: , p3_a35 out nocopy JTF_NUMBER_TABLE
2681: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2682: , p3_a37 out nocopy JTF_NUMBER_TABLE
2683: , p3_a38 out nocopy JTF_NUMBER_TABLE
2684: , p3_a39 out nocopy JTF_NUMBER_TABLE
2685: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2686: , p3_a41 out nocopy JTF_NUMBER_TABLE
2687: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
2688: )
2682: , p3_a37 out nocopy JTF_NUMBER_TABLE
2683: , p3_a38 out nocopy JTF_NUMBER_TABLE
2684: , p3_a39 out nocopy JTF_NUMBER_TABLE
2685: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2686: , p3_a41 out nocopy JTF_NUMBER_TABLE
2687: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
2688: )
2689:
2690: as
2874:
2875: procedure runopenprojection(p_init_msg_list VARCHAR2
2876: , p_loan_id NUMBER
2877: , p_based_on_terms VARCHAR2
2878: , p3_a0 out nocopy JTF_NUMBER_TABLE
2879: , p3_a1 out nocopy JTF_DATE_TABLE
2880: , p3_a2 out nocopy JTF_DATE_TABLE
2881: , p3_a3 out nocopy JTF_DATE_TABLE
2882: , p3_a4 out nocopy JTF_NUMBER_TABLE
2878: , p3_a0 out nocopy JTF_NUMBER_TABLE
2879: , p3_a1 out nocopy JTF_DATE_TABLE
2880: , p3_a2 out nocopy JTF_DATE_TABLE
2881: , p3_a3 out nocopy JTF_DATE_TABLE
2882: , p3_a4 out nocopy JTF_NUMBER_TABLE
2883: , p3_a5 out nocopy JTF_NUMBER_TABLE
2884: , p3_a6 out nocopy JTF_NUMBER_TABLE
2885: , p3_a7 out nocopy JTF_NUMBER_TABLE
2886: , p3_a8 out nocopy JTF_NUMBER_TABLE
2879: , p3_a1 out nocopy JTF_DATE_TABLE
2880: , p3_a2 out nocopy JTF_DATE_TABLE
2881: , p3_a3 out nocopy JTF_DATE_TABLE
2882: , p3_a4 out nocopy JTF_NUMBER_TABLE
2883: , p3_a5 out nocopy JTF_NUMBER_TABLE
2884: , p3_a6 out nocopy JTF_NUMBER_TABLE
2885: , p3_a7 out nocopy JTF_NUMBER_TABLE
2886: , p3_a8 out nocopy JTF_NUMBER_TABLE
2887: , p3_a9 out nocopy JTF_NUMBER_TABLE
2880: , p3_a2 out nocopy JTF_DATE_TABLE
2881: , p3_a3 out nocopy JTF_DATE_TABLE
2882: , p3_a4 out nocopy JTF_NUMBER_TABLE
2883: , p3_a5 out nocopy JTF_NUMBER_TABLE
2884: , p3_a6 out nocopy JTF_NUMBER_TABLE
2885: , p3_a7 out nocopy JTF_NUMBER_TABLE
2886: , p3_a8 out nocopy JTF_NUMBER_TABLE
2887: , p3_a9 out nocopy JTF_NUMBER_TABLE
2888: , p3_a10 out nocopy JTF_NUMBER_TABLE
2881: , p3_a3 out nocopy JTF_DATE_TABLE
2882: , p3_a4 out nocopy JTF_NUMBER_TABLE
2883: , p3_a5 out nocopy JTF_NUMBER_TABLE
2884: , p3_a6 out nocopy JTF_NUMBER_TABLE
2885: , p3_a7 out nocopy JTF_NUMBER_TABLE
2886: , p3_a8 out nocopy JTF_NUMBER_TABLE
2887: , p3_a9 out nocopy JTF_NUMBER_TABLE
2888: , p3_a10 out nocopy JTF_NUMBER_TABLE
2889: , p3_a11 out nocopy JTF_NUMBER_TABLE
2882: , p3_a4 out nocopy JTF_NUMBER_TABLE
2883: , p3_a5 out nocopy JTF_NUMBER_TABLE
2884: , p3_a6 out nocopy JTF_NUMBER_TABLE
2885: , p3_a7 out nocopy JTF_NUMBER_TABLE
2886: , p3_a8 out nocopy JTF_NUMBER_TABLE
2887: , p3_a9 out nocopy JTF_NUMBER_TABLE
2888: , p3_a10 out nocopy JTF_NUMBER_TABLE
2889: , p3_a11 out nocopy JTF_NUMBER_TABLE
2890: , p3_a12 out nocopy JTF_NUMBER_TABLE
2883: , p3_a5 out nocopy JTF_NUMBER_TABLE
2884: , p3_a6 out nocopy JTF_NUMBER_TABLE
2885: , p3_a7 out nocopy JTF_NUMBER_TABLE
2886: , p3_a8 out nocopy JTF_NUMBER_TABLE
2887: , p3_a9 out nocopy JTF_NUMBER_TABLE
2888: , p3_a10 out nocopy JTF_NUMBER_TABLE
2889: , p3_a11 out nocopy JTF_NUMBER_TABLE
2890: , p3_a12 out nocopy JTF_NUMBER_TABLE
2891: , p3_a13 out nocopy JTF_NUMBER_TABLE
2884: , p3_a6 out nocopy JTF_NUMBER_TABLE
2885: , p3_a7 out nocopy JTF_NUMBER_TABLE
2886: , p3_a8 out nocopy JTF_NUMBER_TABLE
2887: , p3_a9 out nocopy JTF_NUMBER_TABLE
2888: , p3_a10 out nocopy JTF_NUMBER_TABLE
2889: , p3_a11 out nocopy JTF_NUMBER_TABLE
2890: , p3_a12 out nocopy JTF_NUMBER_TABLE
2891: , p3_a13 out nocopy JTF_NUMBER_TABLE
2892: , p3_a14 out nocopy JTF_NUMBER_TABLE
2885: , p3_a7 out nocopy JTF_NUMBER_TABLE
2886: , p3_a8 out nocopy JTF_NUMBER_TABLE
2887: , p3_a9 out nocopy JTF_NUMBER_TABLE
2888: , p3_a10 out nocopy JTF_NUMBER_TABLE
2889: , p3_a11 out nocopy JTF_NUMBER_TABLE
2890: , p3_a12 out nocopy JTF_NUMBER_TABLE
2891: , p3_a13 out nocopy JTF_NUMBER_TABLE
2892: , p3_a14 out nocopy JTF_NUMBER_TABLE
2893: , p3_a15 out nocopy JTF_NUMBER_TABLE
2886: , p3_a8 out nocopy JTF_NUMBER_TABLE
2887: , p3_a9 out nocopy JTF_NUMBER_TABLE
2888: , p3_a10 out nocopy JTF_NUMBER_TABLE
2889: , p3_a11 out nocopy JTF_NUMBER_TABLE
2890: , p3_a12 out nocopy JTF_NUMBER_TABLE
2891: , p3_a13 out nocopy JTF_NUMBER_TABLE
2892: , p3_a14 out nocopy JTF_NUMBER_TABLE
2893: , p3_a15 out nocopy JTF_NUMBER_TABLE
2894: , p3_a16 out nocopy JTF_NUMBER_TABLE
2887: , p3_a9 out nocopy JTF_NUMBER_TABLE
2888: , p3_a10 out nocopy JTF_NUMBER_TABLE
2889: , p3_a11 out nocopy JTF_NUMBER_TABLE
2890: , p3_a12 out nocopy JTF_NUMBER_TABLE
2891: , p3_a13 out nocopy JTF_NUMBER_TABLE
2892: , p3_a14 out nocopy JTF_NUMBER_TABLE
2893: , p3_a15 out nocopy JTF_NUMBER_TABLE
2894: , p3_a16 out nocopy JTF_NUMBER_TABLE
2895: , p3_a17 out nocopy JTF_NUMBER_TABLE
2888: , p3_a10 out nocopy JTF_NUMBER_TABLE
2889: , p3_a11 out nocopy JTF_NUMBER_TABLE
2890: , p3_a12 out nocopy JTF_NUMBER_TABLE
2891: , p3_a13 out nocopy JTF_NUMBER_TABLE
2892: , p3_a14 out nocopy JTF_NUMBER_TABLE
2893: , p3_a15 out nocopy JTF_NUMBER_TABLE
2894: , p3_a16 out nocopy JTF_NUMBER_TABLE
2895: , p3_a17 out nocopy JTF_NUMBER_TABLE
2896: , p3_a18 out nocopy JTF_NUMBER_TABLE
2889: , p3_a11 out nocopy JTF_NUMBER_TABLE
2890: , p3_a12 out nocopy JTF_NUMBER_TABLE
2891: , p3_a13 out nocopy JTF_NUMBER_TABLE
2892: , p3_a14 out nocopy JTF_NUMBER_TABLE
2893: , p3_a15 out nocopy JTF_NUMBER_TABLE
2894: , p3_a16 out nocopy JTF_NUMBER_TABLE
2895: , p3_a17 out nocopy JTF_NUMBER_TABLE
2896: , p3_a18 out nocopy JTF_NUMBER_TABLE
2897: , p3_a19 out nocopy JTF_NUMBER_TABLE
2890: , p3_a12 out nocopy JTF_NUMBER_TABLE
2891: , p3_a13 out nocopy JTF_NUMBER_TABLE
2892: , p3_a14 out nocopy JTF_NUMBER_TABLE
2893: , p3_a15 out nocopy JTF_NUMBER_TABLE
2894: , p3_a16 out nocopy JTF_NUMBER_TABLE
2895: , p3_a17 out nocopy JTF_NUMBER_TABLE
2896: , p3_a18 out nocopy JTF_NUMBER_TABLE
2897: , p3_a19 out nocopy JTF_NUMBER_TABLE
2898: , p3_a20 out nocopy JTF_NUMBER_TABLE
2891: , p3_a13 out nocopy JTF_NUMBER_TABLE
2892: , p3_a14 out nocopy JTF_NUMBER_TABLE
2893: , p3_a15 out nocopy JTF_NUMBER_TABLE
2894: , p3_a16 out nocopy JTF_NUMBER_TABLE
2895: , p3_a17 out nocopy JTF_NUMBER_TABLE
2896: , p3_a18 out nocopy JTF_NUMBER_TABLE
2897: , p3_a19 out nocopy JTF_NUMBER_TABLE
2898: , p3_a20 out nocopy JTF_NUMBER_TABLE
2899: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2892: , p3_a14 out nocopy JTF_NUMBER_TABLE
2893: , p3_a15 out nocopy JTF_NUMBER_TABLE
2894: , p3_a16 out nocopy JTF_NUMBER_TABLE
2895: , p3_a17 out nocopy JTF_NUMBER_TABLE
2896: , p3_a18 out nocopy JTF_NUMBER_TABLE
2897: , p3_a19 out nocopy JTF_NUMBER_TABLE
2898: , p3_a20 out nocopy JTF_NUMBER_TABLE
2899: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2900: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2893: , p3_a15 out nocopy JTF_NUMBER_TABLE
2894: , p3_a16 out nocopy JTF_NUMBER_TABLE
2895: , p3_a17 out nocopy JTF_NUMBER_TABLE
2896: , p3_a18 out nocopy JTF_NUMBER_TABLE
2897: , p3_a19 out nocopy JTF_NUMBER_TABLE
2898: , p3_a20 out nocopy JTF_NUMBER_TABLE
2899: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2900: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2901: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2894: , p3_a16 out nocopy JTF_NUMBER_TABLE
2895: , p3_a17 out nocopy JTF_NUMBER_TABLE
2896: , p3_a18 out nocopy JTF_NUMBER_TABLE
2897: , p3_a19 out nocopy JTF_NUMBER_TABLE
2898: , p3_a20 out nocopy JTF_NUMBER_TABLE
2899: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2900: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2901: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2902: , p3_a24 out nocopy JTF_NUMBER_TABLE
2898: , p3_a20 out nocopy JTF_NUMBER_TABLE
2899: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2900: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2901: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2902: , p3_a24 out nocopy JTF_NUMBER_TABLE
2903: , p3_a25 out nocopy JTF_NUMBER_TABLE
2904: , p3_a26 out nocopy JTF_NUMBER_TABLE
2905: , p3_a27 out nocopy JTF_NUMBER_TABLE
2906: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2899: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2900: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2901: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2902: , p3_a24 out nocopy JTF_NUMBER_TABLE
2903: , p3_a25 out nocopy JTF_NUMBER_TABLE
2904: , p3_a26 out nocopy JTF_NUMBER_TABLE
2905: , p3_a27 out nocopy JTF_NUMBER_TABLE
2906: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2907: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2900: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2901: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2902: , p3_a24 out nocopy JTF_NUMBER_TABLE
2903: , p3_a25 out nocopy JTF_NUMBER_TABLE
2904: , p3_a26 out nocopy JTF_NUMBER_TABLE
2905: , p3_a27 out nocopy JTF_NUMBER_TABLE
2906: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2907: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2908: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2901: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2902: , p3_a24 out nocopy JTF_NUMBER_TABLE
2903: , p3_a25 out nocopy JTF_NUMBER_TABLE
2904: , p3_a26 out nocopy JTF_NUMBER_TABLE
2905: , p3_a27 out nocopy JTF_NUMBER_TABLE
2906: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2907: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2908: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2909: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2906: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2907: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2908: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2909: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2910: , p3_a32 out nocopy JTF_NUMBER_TABLE
2911: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
2912: , p3_a34 out nocopy JTF_NUMBER_TABLE
2913: , p3_a35 out nocopy JTF_NUMBER_TABLE
2914: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2908: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2909: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2910: , p3_a32 out nocopy JTF_NUMBER_TABLE
2911: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
2912: , p3_a34 out nocopy JTF_NUMBER_TABLE
2913: , p3_a35 out nocopy JTF_NUMBER_TABLE
2914: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2915: , p3_a37 out nocopy JTF_NUMBER_TABLE
2916: , p3_a38 out nocopy JTF_NUMBER_TABLE
2909: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2910: , p3_a32 out nocopy JTF_NUMBER_TABLE
2911: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
2912: , p3_a34 out nocopy JTF_NUMBER_TABLE
2913: , p3_a35 out nocopy JTF_NUMBER_TABLE
2914: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2915: , p3_a37 out nocopy JTF_NUMBER_TABLE
2916: , p3_a38 out nocopy JTF_NUMBER_TABLE
2917: , p3_a39 out nocopy JTF_NUMBER_TABLE
2911: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
2912: , p3_a34 out nocopy JTF_NUMBER_TABLE
2913: , p3_a35 out nocopy JTF_NUMBER_TABLE
2914: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2915: , p3_a37 out nocopy JTF_NUMBER_TABLE
2916: , p3_a38 out nocopy JTF_NUMBER_TABLE
2917: , p3_a39 out nocopy JTF_NUMBER_TABLE
2918: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2919: , p3_a41 out nocopy JTF_NUMBER_TABLE
2912: , p3_a34 out nocopy JTF_NUMBER_TABLE
2913: , p3_a35 out nocopy JTF_NUMBER_TABLE
2914: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2915: , p3_a37 out nocopy JTF_NUMBER_TABLE
2916: , p3_a38 out nocopy JTF_NUMBER_TABLE
2917: , p3_a39 out nocopy JTF_NUMBER_TABLE
2918: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2919: , p3_a41 out nocopy JTF_NUMBER_TABLE
2920: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
2913: , p3_a35 out nocopy JTF_NUMBER_TABLE
2914: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2915: , p3_a37 out nocopy JTF_NUMBER_TABLE
2916: , p3_a38 out nocopy JTF_NUMBER_TABLE
2917: , p3_a39 out nocopy JTF_NUMBER_TABLE
2918: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2919: , p3_a41 out nocopy JTF_NUMBER_TABLE
2920: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
2921: , x_return_status out nocopy VARCHAR2
2915: , p3_a37 out nocopy JTF_NUMBER_TABLE
2916: , p3_a38 out nocopy JTF_NUMBER_TABLE
2917: , p3_a39 out nocopy JTF_NUMBER_TABLE
2918: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2919: , p3_a41 out nocopy JTF_NUMBER_TABLE
2920: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
2921: , x_return_status out nocopy VARCHAR2
2922: , x_msg_count out nocopy NUMBER
2923: , x_msg_data out nocopy VARCHAR2
3002: , p_init_msg_list VARCHAR2
3003: , p_commit VARCHAR2
3004: , p_loan_id NUMBER
3005: , p_based_on_terms VARCHAR2
3006: , p5_a0 out nocopy JTF_NUMBER_TABLE
3007: , p5_a1 out nocopy JTF_DATE_TABLE
3008: , p5_a2 out nocopy JTF_DATE_TABLE
3009: , p5_a3 out nocopy JTF_DATE_TABLE
3010: , p5_a4 out nocopy JTF_NUMBER_TABLE
3006: , p5_a0 out nocopy JTF_NUMBER_TABLE
3007: , p5_a1 out nocopy JTF_DATE_TABLE
3008: , p5_a2 out nocopy JTF_DATE_TABLE
3009: , p5_a3 out nocopy JTF_DATE_TABLE
3010: , p5_a4 out nocopy JTF_NUMBER_TABLE
3011: , p5_a5 out nocopy JTF_NUMBER_TABLE
3012: , p5_a6 out nocopy JTF_NUMBER_TABLE
3013: , p5_a7 out nocopy JTF_NUMBER_TABLE
3014: , p5_a8 out nocopy JTF_NUMBER_TABLE
3007: , p5_a1 out nocopy JTF_DATE_TABLE
3008: , p5_a2 out nocopy JTF_DATE_TABLE
3009: , p5_a3 out nocopy JTF_DATE_TABLE
3010: , p5_a4 out nocopy JTF_NUMBER_TABLE
3011: , p5_a5 out nocopy JTF_NUMBER_TABLE
3012: , p5_a6 out nocopy JTF_NUMBER_TABLE
3013: , p5_a7 out nocopy JTF_NUMBER_TABLE
3014: , p5_a8 out nocopy JTF_NUMBER_TABLE
3015: , p5_a9 out nocopy JTF_NUMBER_TABLE
3008: , p5_a2 out nocopy JTF_DATE_TABLE
3009: , p5_a3 out nocopy JTF_DATE_TABLE
3010: , p5_a4 out nocopy JTF_NUMBER_TABLE
3011: , p5_a5 out nocopy JTF_NUMBER_TABLE
3012: , p5_a6 out nocopy JTF_NUMBER_TABLE
3013: , p5_a7 out nocopy JTF_NUMBER_TABLE
3014: , p5_a8 out nocopy JTF_NUMBER_TABLE
3015: , p5_a9 out nocopy JTF_NUMBER_TABLE
3016: , p5_a10 out nocopy JTF_NUMBER_TABLE
3009: , p5_a3 out nocopy JTF_DATE_TABLE
3010: , p5_a4 out nocopy JTF_NUMBER_TABLE
3011: , p5_a5 out nocopy JTF_NUMBER_TABLE
3012: , p5_a6 out nocopy JTF_NUMBER_TABLE
3013: , p5_a7 out nocopy JTF_NUMBER_TABLE
3014: , p5_a8 out nocopy JTF_NUMBER_TABLE
3015: , p5_a9 out nocopy JTF_NUMBER_TABLE
3016: , p5_a10 out nocopy JTF_NUMBER_TABLE
3017: , p5_a11 out nocopy JTF_NUMBER_TABLE
3010: , p5_a4 out nocopy JTF_NUMBER_TABLE
3011: , p5_a5 out nocopy JTF_NUMBER_TABLE
3012: , p5_a6 out nocopy JTF_NUMBER_TABLE
3013: , p5_a7 out nocopy JTF_NUMBER_TABLE
3014: , p5_a8 out nocopy JTF_NUMBER_TABLE
3015: , p5_a9 out nocopy JTF_NUMBER_TABLE
3016: , p5_a10 out nocopy JTF_NUMBER_TABLE
3017: , p5_a11 out nocopy JTF_NUMBER_TABLE
3018: , p5_a12 out nocopy JTF_NUMBER_TABLE
3011: , p5_a5 out nocopy JTF_NUMBER_TABLE
3012: , p5_a6 out nocopy JTF_NUMBER_TABLE
3013: , p5_a7 out nocopy JTF_NUMBER_TABLE
3014: , p5_a8 out nocopy JTF_NUMBER_TABLE
3015: , p5_a9 out nocopy JTF_NUMBER_TABLE
3016: , p5_a10 out nocopy JTF_NUMBER_TABLE
3017: , p5_a11 out nocopy JTF_NUMBER_TABLE
3018: , p5_a12 out nocopy JTF_NUMBER_TABLE
3019: , p5_a13 out nocopy JTF_NUMBER_TABLE
3012: , p5_a6 out nocopy JTF_NUMBER_TABLE
3013: , p5_a7 out nocopy JTF_NUMBER_TABLE
3014: , p5_a8 out nocopy JTF_NUMBER_TABLE
3015: , p5_a9 out nocopy JTF_NUMBER_TABLE
3016: , p5_a10 out nocopy JTF_NUMBER_TABLE
3017: , p5_a11 out nocopy JTF_NUMBER_TABLE
3018: , p5_a12 out nocopy JTF_NUMBER_TABLE
3019: , p5_a13 out nocopy JTF_NUMBER_TABLE
3020: , p5_a14 out nocopy JTF_NUMBER_TABLE
3013: , p5_a7 out nocopy JTF_NUMBER_TABLE
3014: , p5_a8 out nocopy JTF_NUMBER_TABLE
3015: , p5_a9 out nocopy JTF_NUMBER_TABLE
3016: , p5_a10 out nocopy JTF_NUMBER_TABLE
3017: , p5_a11 out nocopy JTF_NUMBER_TABLE
3018: , p5_a12 out nocopy JTF_NUMBER_TABLE
3019: , p5_a13 out nocopy JTF_NUMBER_TABLE
3020: , p5_a14 out nocopy JTF_NUMBER_TABLE
3021: , p5_a15 out nocopy JTF_NUMBER_TABLE
3014: , p5_a8 out nocopy JTF_NUMBER_TABLE
3015: , p5_a9 out nocopy JTF_NUMBER_TABLE
3016: , p5_a10 out nocopy JTF_NUMBER_TABLE
3017: , p5_a11 out nocopy JTF_NUMBER_TABLE
3018: , p5_a12 out nocopy JTF_NUMBER_TABLE
3019: , p5_a13 out nocopy JTF_NUMBER_TABLE
3020: , p5_a14 out nocopy JTF_NUMBER_TABLE
3021: , p5_a15 out nocopy JTF_NUMBER_TABLE
3022: , p5_a16 out nocopy JTF_NUMBER_TABLE
3015: , p5_a9 out nocopy JTF_NUMBER_TABLE
3016: , p5_a10 out nocopy JTF_NUMBER_TABLE
3017: , p5_a11 out nocopy JTF_NUMBER_TABLE
3018: , p5_a12 out nocopy JTF_NUMBER_TABLE
3019: , p5_a13 out nocopy JTF_NUMBER_TABLE
3020: , p5_a14 out nocopy JTF_NUMBER_TABLE
3021: , p5_a15 out nocopy JTF_NUMBER_TABLE
3022: , p5_a16 out nocopy JTF_NUMBER_TABLE
3023: , p5_a17 out nocopy JTF_NUMBER_TABLE
3016: , p5_a10 out nocopy JTF_NUMBER_TABLE
3017: , p5_a11 out nocopy JTF_NUMBER_TABLE
3018: , p5_a12 out nocopy JTF_NUMBER_TABLE
3019: , p5_a13 out nocopy JTF_NUMBER_TABLE
3020: , p5_a14 out nocopy JTF_NUMBER_TABLE
3021: , p5_a15 out nocopy JTF_NUMBER_TABLE
3022: , p5_a16 out nocopy JTF_NUMBER_TABLE
3023: , p5_a17 out nocopy JTF_NUMBER_TABLE
3024: , p5_a18 out nocopy JTF_NUMBER_TABLE
3017: , p5_a11 out nocopy JTF_NUMBER_TABLE
3018: , p5_a12 out nocopy JTF_NUMBER_TABLE
3019: , p5_a13 out nocopy JTF_NUMBER_TABLE
3020: , p5_a14 out nocopy JTF_NUMBER_TABLE
3021: , p5_a15 out nocopy JTF_NUMBER_TABLE
3022: , p5_a16 out nocopy JTF_NUMBER_TABLE
3023: , p5_a17 out nocopy JTF_NUMBER_TABLE
3024: , p5_a18 out nocopy JTF_NUMBER_TABLE
3025: , p5_a19 out nocopy JTF_NUMBER_TABLE
3018: , p5_a12 out nocopy JTF_NUMBER_TABLE
3019: , p5_a13 out nocopy JTF_NUMBER_TABLE
3020: , p5_a14 out nocopy JTF_NUMBER_TABLE
3021: , p5_a15 out nocopy JTF_NUMBER_TABLE
3022: , p5_a16 out nocopy JTF_NUMBER_TABLE
3023: , p5_a17 out nocopy JTF_NUMBER_TABLE
3024: , p5_a18 out nocopy JTF_NUMBER_TABLE
3025: , p5_a19 out nocopy JTF_NUMBER_TABLE
3026: , p5_a20 out nocopy JTF_NUMBER_TABLE
3019: , p5_a13 out nocopy JTF_NUMBER_TABLE
3020: , p5_a14 out nocopy JTF_NUMBER_TABLE
3021: , p5_a15 out nocopy JTF_NUMBER_TABLE
3022: , p5_a16 out nocopy JTF_NUMBER_TABLE
3023: , p5_a17 out nocopy JTF_NUMBER_TABLE
3024: , p5_a18 out nocopy JTF_NUMBER_TABLE
3025: , p5_a19 out nocopy JTF_NUMBER_TABLE
3026: , p5_a20 out nocopy JTF_NUMBER_TABLE
3027: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
3020: , p5_a14 out nocopy JTF_NUMBER_TABLE
3021: , p5_a15 out nocopy JTF_NUMBER_TABLE
3022: , p5_a16 out nocopy JTF_NUMBER_TABLE
3023: , p5_a17 out nocopy JTF_NUMBER_TABLE
3024: , p5_a18 out nocopy JTF_NUMBER_TABLE
3025: , p5_a19 out nocopy JTF_NUMBER_TABLE
3026: , p5_a20 out nocopy JTF_NUMBER_TABLE
3027: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
3028: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
3021: , p5_a15 out nocopy JTF_NUMBER_TABLE
3022: , p5_a16 out nocopy JTF_NUMBER_TABLE
3023: , p5_a17 out nocopy JTF_NUMBER_TABLE
3024: , p5_a18 out nocopy JTF_NUMBER_TABLE
3025: , p5_a19 out nocopy JTF_NUMBER_TABLE
3026: , p5_a20 out nocopy JTF_NUMBER_TABLE
3027: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
3028: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
3029: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
3022: , p5_a16 out nocopy JTF_NUMBER_TABLE
3023: , p5_a17 out nocopy JTF_NUMBER_TABLE
3024: , p5_a18 out nocopy JTF_NUMBER_TABLE
3025: , p5_a19 out nocopy JTF_NUMBER_TABLE
3026: , p5_a20 out nocopy JTF_NUMBER_TABLE
3027: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
3028: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
3029: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
3030: , p5_a24 out nocopy JTF_NUMBER_TABLE
3026: , p5_a20 out nocopy JTF_NUMBER_TABLE
3027: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
3028: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
3029: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
3030: , p5_a24 out nocopy JTF_NUMBER_TABLE
3031: , p5_a25 out nocopy JTF_NUMBER_TABLE
3032: , p5_a26 out nocopy JTF_NUMBER_TABLE
3033: , p5_a27 out nocopy JTF_NUMBER_TABLE
3034: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_2000
3027: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
3028: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
3029: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
3030: , p5_a24 out nocopy JTF_NUMBER_TABLE
3031: , p5_a25 out nocopy JTF_NUMBER_TABLE
3032: , p5_a26 out nocopy JTF_NUMBER_TABLE
3033: , p5_a27 out nocopy JTF_NUMBER_TABLE
3034: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_2000
3035: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_2000
3028: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
3029: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
3030: , p5_a24 out nocopy JTF_NUMBER_TABLE
3031: , p5_a25 out nocopy JTF_NUMBER_TABLE
3032: , p5_a26 out nocopy JTF_NUMBER_TABLE
3033: , p5_a27 out nocopy JTF_NUMBER_TABLE
3034: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_2000
3035: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_2000
3036: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_2000
3029: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
3030: , p5_a24 out nocopy JTF_NUMBER_TABLE
3031: , p5_a25 out nocopy JTF_NUMBER_TABLE
3032: , p5_a26 out nocopy JTF_NUMBER_TABLE
3033: , p5_a27 out nocopy JTF_NUMBER_TABLE
3034: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_2000
3035: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_2000
3036: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_2000
3037: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_2000
3034: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_2000
3035: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_2000
3036: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_2000
3037: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_2000
3038: , p5_a32 out nocopy JTF_NUMBER_TABLE
3039: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_200
3040: , p5_a34 out nocopy JTF_NUMBER_TABLE
3041: , p5_a35 out nocopy JTF_NUMBER_TABLE
3042: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_2000
3036: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_2000
3037: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_2000
3038: , p5_a32 out nocopy JTF_NUMBER_TABLE
3039: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_200
3040: , p5_a34 out nocopy JTF_NUMBER_TABLE
3041: , p5_a35 out nocopy JTF_NUMBER_TABLE
3042: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_2000
3043: , p5_a37 out nocopy JTF_NUMBER_TABLE
3044: , p5_a38 out nocopy JTF_NUMBER_TABLE
3037: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_2000
3038: , p5_a32 out nocopy JTF_NUMBER_TABLE
3039: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_200
3040: , p5_a34 out nocopy JTF_NUMBER_TABLE
3041: , p5_a35 out nocopy JTF_NUMBER_TABLE
3042: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_2000
3043: , p5_a37 out nocopy JTF_NUMBER_TABLE
3044: , p5_a38 out nocopy JTF_NUMBER_TABLE
3045: , p5_a39 out nocopy JTF_NUMBER_TABLE
3039: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_200
3040: , p5_a34 out nocopy JTF_NUMBER_TABLE
3041: , p5_a35 out nocopy JTF_NUMBER_TABLE
3042: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_2000
3043: , p5_a37 out nocopy JTF_NUMBER_TABLE
3044: , p5_a38 out nocopy JTF_NUMBER_TABLE
3045: , p5_a39 out nocopy JTF_NUMBER_TABLE
3046: , p5_a40 out nocopy JTF_VARCHAR2_TABLE_2000
3047: , p5_a41 out nocopy JTF_NUMBER_TABLE
3040: , p5_a34 out nocopy JTF_NUMBER_TABLE
3041: , p5_a35 out nocopy JTF_NUMBER_TABLE
3042: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_2000
3043: , p5_a37 out nocopy JTF_NUMBER_TABLE
3044: , p5_a38 out nocopy JTF_NUMBER_TABLE
3045: , p5_a39 out nocopy JTF_NUMBER_TABLE
3046: , p5_a40 out nocopy JTF_VARCHAR2_TABLE_2000
3047: , p5_a41 out nocopy JTF_NUMBER_TABLE
3048: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_2000
3041: , p5_a35 out nocopy JTF_NUMBER_TABLE
3042: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_2000
3043: , p5_a37 out nocopy JTF_NUMBER_TABLE
3044: , p5_a38 out nocopy JTF_NUMBER_TABLE
3045: , p5_a39 out nocopy JTF_NUMBER_TABLE
3046: , p5_a40 out nocopy JTF_VARCHAR2_TABLE_2000
3047: , p5_a41 out nocopy JTF_NUMBER_TABLE
3048: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_2000
3049: , x_return_status out nocopy VARCHAR2
3043: , p5_a37 out nocopy JTF_NUMBER_TABLE
3044: , p5_a38 out nocopy JTF_NUMBER_TABLE
3045: , p5_a39 out nocopy JTF_NUMBER_TABLE
3046: , p5_a40 out nocopy JTF_VARCHAR2_TABLE_2000
3047: , p5_a41 out nocopy JTF_NUMBER_TABLE
3048: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_2000
3049: , x_return_status out nocopy VARCHAR2
3050: , x_msg_count out nocopy NUMBER
3051: , x_msg_data out nocopy VARCHAR2
3179: , p5_a39 out nocopy NUMBER
3180: , p5_a40 out nocopy VARCHAR2
3181: , p5_a41 out nocopy NUMBER
3182: , p5_a42 out nocopy VARCHAR2
3183: , p6_a0 out nocopy JTF_NUMBER_TABLE
3184: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
3185: , p6_a2 out nocopy JTF_NUMBER_TABLE
3186: , p6_a3 out nocopy JTF_NUMBER_TABLE
3187: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
3181: , p5_a41 out nocopy NUMBER
3182: , p5_a42 out nocopy VARCHAR2
3183: , p6_a0 out nocopy JTF_NUMBER_TABLE
3184: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
3185: , p6_a2 out nocopy JTF_NUMBER_TABLE
3186: , p6_a3 out nocopy JTF_NUMBER_TABLE
3187: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
3188: , p6_a5 out nocopy JTF_NUMBER_TABLE
3189: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
3182: , p5_a42 out nocopy VARCHAR2
3183: , p6_a0 out nocopy JTF_NUMBER_TABLE
3184: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
3185: , p6_a2 out nocopy JTF_NUMBER_TABLE
3186: , p6_a3 out nocopy JTF_NUMBER_TABLE
3187: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
3188: , p6_a5 out nocopy JTF_NUMBER_TABLE
3189: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
3190: , p6_a7 out nocopy JTF_NUMBER_TABLE
3184: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
3185: , p6_a2 out nocopy JTF_NUMBER_TABLE
3186: , p6_a3 out nocopy JTF_NUMBER_TABLE
3187: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
3188: , p6_a5 out nocopy JTF_NUMBER_TABLE
3189: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
3190: , p6_a7 out nocopy JTF_NUMBER_TABLE
3191: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
3192: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
3186: , p6_a3 out nocopy JTF_NUMBER_TABLE
3187: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
3188: , p6_a5 out nocopy JTF_NUMBER_TABLE
3189: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
3190: , p6_a7 out nocopy JTF_NUMBER_TABLE
3191: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
3192: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
3193: , x_return_status out nocopy VARCHAR2
3194: , x_msg_count out nocopy NUMBER
3335: , p3_a39 out nocopy NUMBER
3336: , p3_a40 out nocopy VARCHAR2
3337: , p3_a41 out nocopy NUMBER
3338: , p3_a42 out nocopy VARCHAR2
3339: , p4_a0 out nocopy JTF_NUMBER_TABLE
3340: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
3341: , p4_a2 out nocopy JTF_NUMBER_TABLE
3342: , p4_a3 out nocopy JTF_NUMBER_TABLE
3343: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
3337: , p3_a41 out nocopy NUMBER
3338: , p3_a42 out nocopy VARCHAR2
3339: , p4_a0 out nocopy JTF_NUMBER_TABLE
3340: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
3341: , p4_a2 out nocopy JTF_NUMBER_TABLE
3342: , p4_a3 out nocopy JTF_NUMBER_TABLE
3343: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
3344: , p4_a5 out nocopy JTF_NUMBER_TABLE
3345: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
3338: , p3_a42 out nocopy VARCHAR2
3339: , p4_a0 out nocopy JTF_NUMBER_TABLE
3340: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
3341: , p4_a2 out nocopy JTF_NUMBER_TABLE
3342: , p4_a3 out nocopy JTF_NUMBER_TABLE
3343: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
3344: , p4_a5 out nocopy JTF_NUMBER_TABLE
3345: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
3346: , p4_a7 out nocopy JTF_NUMBER_TABLE
3340: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
3341: , p4_a2 out nocopy JTF_NUMBER_TABLE
3342: , p4_a3 out nocopy JTF_NUMBER_TABLE
3343: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
3344: , p4_a5 out nocopy JTF_NUMBER_TABLE
3345: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
3346: , p4_a7 out nocopy JTF_NUMBER_TABLE
3347: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
3348: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
3342: , p4_a3 out nocopy JTF_NUMBER_TABLE
3343: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
3344: , p4_a5 out nocopy JTF_NUMBER_TABLE
3345: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
3346: , p4_a7 out nocopy JTF_NUMBER_TABLE
3347: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
3348: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
3349: , x_return_status out nocopy VARCHAR2
3350: , x_msg_count out nocopy NUMBER
3785: , p_loan_id NUMBER
3786: , p_date DATE
3787: , p_reason VARCHAR2
3788: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
3789: , p5_a1 out nocopy JTF_NUMBER_TABLE
3790: , p5_a2 out nocopy JTF_NUMBER_TABLE
3791: , p5_a3 out nocopy JTF_NUMBER_TABLE
3792: , x_return_status out nocopy VARCHAR2
3793: , x_msg_count out nocopy NUMBER
3786: , p_date DATE
3787: , p_reason VARCHAR2
3788: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
3789: , p5_a1 out nocopy JTF_NUMBER_TABLE
3790: , p5_a2 out nocopy JTF_NUMBER_TABLE
3791: , p5_a3 out nocopy JTF_NUMBER_TABLE
3792: , x_return_status out nocopy VARCHAR2
3793: , x_msg_count out nocopy NUMBER
3794: , x_msg_data out nocopy VARCHAR2
3787: , p_reason VARCHAR2
3788: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
3789: , p5_a1 out nocopy JTF_NUMBER_TABLE
3790: , p5_a2 out nocopy JTF_NUMBER_TABLE
3791: , p5_a3 out nocopy JTF_NUMBER_TABLE
3792: , x_return_status out nocopy VARCHAR2
3793: , x_msg_count out nocopy NUMBER
3794: , x_msg_data out nocopy VARCHAR2
3795: )