1: package body lns_financials_w as
2: /* $Header: LNS_FINANCIALJ_B.pls 120.7.12010000.3 2009/01/07 13:35:38 gparuchu 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.7.12010000.3 2009/01/07 13:35:38 gparuchu 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: ) as
137: ddindx binary_integer; indx binary_integer;
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: ) as
137: ddindx binary_integer; indx binary_integer;
138: begin
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: ) as
137: ddindx binary_integer; indx binary_integer;
138: begin
139: if a0 is not null and a0.count > 0 then
176: end loop;
177: end if;
178: end if;
179: end rosetta_table_copy_in_p3;
180: procedure rosetta_table_copy_out_p3(t lns_financials.amortization_tbl, a0 out nocopy JTF_NUMBER_TABLE
181: , a1 out nocopy JTF_DATE_TABLE
182: , a2 out nocopy JTF_DATE_TABLE
183: , a3 out nocopy JTF_DATE_TABLE
184: , a4 out nocopy JTF_NUMBER_TABLE
180: procedure rosetta_table_copy_out_p3(t lns_financials.amortization_tbl, a0 out nocopy JTF_NUMBER_TABLE
181: , a1 out nocopy JTF_DATE_TABLE
182: , a2 out nocopy JTF_DATE_TABLE
183: , a3 out nocopy JTF_DATE_TABLE
184: , a4 out nocopy JTF_NUMBER_TABLE
185: , a5 out nocopy JTF_NUMBER_TABLE
186: , a6 out nocopy JTF_NUMBER_TABLE
187: , a7 out nocopy JTF_NUMBER_TABLE
188: , a8 out nocopy JTF_NUMBER_TABLE
181: , a1 out nocopy JTF_DATE_TABLE
182: , a2 out nocopy JTF_DATE_TABLE
183: , a3 out nocopy JTF_DATE_TABLE
184: , a4 out nocopy JTF_NUMBER_TABLE
185: , a5 out nocopy JTF_NUMBER_TABLE
186: , a6 out nocopy JTF_NUMBER_TABLE
187: , a7 out nocopy JTF_NUMBER_TABLE
188: , a8 out nocopy JTF_NUMBER_TABLE
189: , a9 out nocopy JTF_NUMBER_TABLE
182: , a2 out nocopy JTF_DATE_TABLE
183: , a3 out nocopy JTF_DATE_TABLE
184: , a4 out nocopy JTF_NUMBER_TABLE
185: , a5 out nocopy JTF_NUMBER_TABLE
186: , a6 out nocopy JTF_NUMBER_TABLE
187: , a7 out nocopy JTF_NUMBER_TABLE
188: , a8 out nocopy JTF_NUMBER_TABLE
189: , a9 out nocopy JTF_NUMBER_TABLE
190: , a10 out nocopy JTF_NUMBER_TABLE
183: , a3 out nocopy JTF_DATE_TABLE
184: , a4 out nocopy JTF_NUMBER_TABLE
185: , a5 out nocopy JTF_NUMBER_TABLE
186: , a6 out nocopy JTF_NUMBER_TABLE
187: , a7 out nocopy JTF_NUMBER_TABLE
188: , a8 out nocopy JTF_NUMBER_TABLE
189: , a9 out nocopy JTF_NUMBER_TABLE
190: , a10 out nocopy JTF_NUMBER_TABLE
191: , a11 out nocopy JTF_NUMBER_TABLE
184: , a4 out nocopy JTF_NUMBER_TABLE
185: , a5 out nocopy JTF_NUMBER_TABLE
186: , a6 out nocopy JTF_NUMBER_TABLE
187: , a7 out nocopy JTF_NUMBER_TABLE
188: , a8 out nocopy JTF_NUMBER_TABLE
189: , a9 out nocopy JTF_NUMBER_TABLE
190: , a10 out nocopy JTF_NUMBER_TABLE
191: , a11 out nocopy JTF_NUMBER_TABLE
192: , a12 out nocopy JTF_NUMBER_TABLE
185: , a5 out nocopy JTF_NUMBER_TABLE
186: , a6 out nocopy JTF_NUMBER_TABLE
187: , a7 out nocopy JTF_NUMBER_TABLE
188: , a8 out nocopy JTF_NUMBER_TABLE
189: , a9 out nocopy JTF_NUMBER_TABLE
190: , a10 out nocopy JTF_NUMBER_TABLE
191: , a11 out nocopy JTF_NUMBER_TABLE
192: , a12 out nocopy JTF_NUMBER_TABLE
193: , a13 out nocopy JTF_NUMBER_TABLE
186: , a6 out nocopy JTF_NUMBER_TABLE
187: , a7 out nocopy JTF_NUMBER_TABLE
188: , a8 out nocopy JTF_NUMBER_TABLE
189: , a9 out nocopy JTF_NUMBER_TABLE
190: , a10 out nocopy JTF_NUMBER_TABLE
191: , a11 out nocopy JTF_NUMBER_TABLE
192: , a12 out nocopy JTF_NUMBER_TABLE
193: , a13 out nocopy JTF_NUMBER_TABLE
194: , a14 out nocopy JTF_NUMBER_TABLE
187: , a7 out nocopy JTF_NUMBER_TABLE
188: , a8 out nocopy JTF_NUMBER_TABLE
189: , a9 out nocopy JTF_NUMBER_TABLE
190: , a10 out nocopy JTF_NUMBER_TABLE
191: , a11 out nocopy JTF_NUMBER_TABLE
192: , a12 out nocopy JTF_NUMBER_TABLE
193: , a13 out nocopy JTF_NUMBER_TABLE
194: , a14 out nocopy JTF_NUMBER_TABLE
195: , a15 out nocopy JTF_NUMBER_TABLE
188: , a8 out nocopy JTF_NUMBER_TABLE
189: , a9 out nocopy JTF_NUMBER_TABLE
190: , a10 out nocopy JTF_NUMBER_TABLE
191: , a11 out nocopy JTF_NUMBER_TABLE
192: , a12 out nocopy JTF_NUMBER_TABLE
193: , a13 out nocopy JTF_NUMBER_TABLE
194: , a14 out nocopy JTF_NUMBER_TABLE
195: , a15 out nocopy JTF_NUMBER_TABLE
196: , a16 out nocopy JTF_NUMBER_TABLE
189: , a9 out nocopy JTF_NUMBER_TABLE
190: , a10 out nocopy JTF_NUMBER_TABLE
191: , a11 out nocopy JTF_NUMBER_TABLE
192: , a12 out nocopy JTF_NUMBER_TABLE
193: , a13 out nocopy JTF_NUMBER_TABLE
194: , a14 out nocopy JTF_NUMBER_TABLE
195: , a15 out nocopy JTF_NUMBER_TABLE
196: , a16 out nocopy JTF_NUMBER_TABLE
197: , a17 out nocopy JTF_NUMBER_TABLE
190: , a10 out nocopy JTF_NUMBER_TABLE
191: , a11 out nocopy JTF_NUMBER_TABLE
192: , a12 out nocopy JTF_NUMBER_TABLE
193: , a13 out nocopy JTF_NUMBER_TABLE
194: , a14 out nocopy JTF_NUMBER_TABLE
195: , a15 out nocopy JTF_NUMBER_TABLE
196: , a16 out nocopy JTF_NUMBER_TABLE
197: , a17 out nocopy JTF_NUMBER_TABLE
198: , a18 out nocopy JTF_NUMBER_TABLE
191: , a11 out nocopy JTF_NUMBER_TABLE
192: , a12 out nocopy JTF_NUMBER_TABLE
193: , a13 out nocopy JTF_NUMBER_TABLE
194: , a14 out nocopy JTF_NUMBER_TABLE
195: , a15 out nocopy JTF_NUMBER_TABLE
196: , a16 out nocopy JTF_NUMBER_TABLE
197: , a17 out nocopy JTF_NUMBER_TABLE
198: , a18 out nocopy JTF_NUMBER_TABLE
199: , a19 out nocopy JTF_NUMBER_TABLE
192: , a12 out nocopy JTF_NUMBER_TABLE
193: , a13 out nocopy JTF_NUMBER_TABLE
194: , a14 out nocopy JTF_NUMBER_TABLE
195: , a15 out nocopy JTF_NUMBER_TABLE
196: , a16 out nocopy JTF_NUMBER_TABLE
197: , a17 out nocopy JTF_NUMBER_TABLE
198: , a18 out nocopy JTF_NUMBER_TABLE
199: , a19 out nocopy JTF_NUMBER_TABLE
200: , a20 out nocopy JTF_NUMBER_TABLE
193: , a13 out nocopy JTF_NUMBER_TABLE
194: , a14 out nocopy JTF_NUMBER_TABLE
195: , a15 out nocopy JTF_NUMBER_TABLE
196: , a16 out nocopy JTF_NUMBER_TABLE
197: , a17 out nocopy JTF_NUMBER_TABLE
198: , a18 out nocopy JTF_NUMBER_TABLE
199: , a19 out nocopy JTF_NUMBER_TABLE
200: , a20 out nocopy JTF_NUMBER_TABLE
201: , a21 out nocopy JTF_VARCHAR2_TABLE_100
194: , a14 out nocopy JTF_NUMBER_TABLE
195: , a15 out nocopy JTF_NUMBER_TABLE
196: , a16 out nocopy JTF_NUMBER_TABLE
197: , a17 out nocopy JTF_NUMBER_TABLE
198: , a18 out nocopy JTF_NUMBER_TABLE
199: , a19 out nocopy JTF_NUMBER_TABLE
200: , a20 out nocopy JTF_NUMBER_TABLE
201: , a21 out nocopy JTF_VARCHAR2_TABLE_100
202: , a22 out nocopy JTF_VARCHAR2_TABLE_100
195: , a15 out nocopy JTF_NUMBER_TABLE
196: , a16 out nocopy JTF_NUMBER_TABLE
197: , a17 out nocopy JTF_NUMBER_TABLE
198: , a18 out nocopy JTF_NUMBER_TABLE
199: , a19 out nocopy JTF_NUMBER_TABLE
200: , a20 out nocopy JTF_NUMBER_TABLE
201: , a21 out nocopy JTF_VARCHAR2_TABLE_100
202: , a22 out nocopy JTF_VARCHAR2_TABLE_100
203: , a23 out nocopy JTF_VARCHAR2_TABLE_100
196: , a16 out nocopy JTF_NUMBER_TABLE
197: , a17 out nocopy JTF_NUMBER_TABLE
198: , a18 out nocopy JTF_NUMBER_TABLE
199: , a19 out nocopy JTF_NUMBER_TABLE
200: , a20 out nocopy JTF_NUMBER_TABLE
201: , a21 out nocopy JTF_VARCHAR2_TABLE_100
202: , a22 out nocopy JTF_VARCHAR2_TABLE_100
203: , a23 out nocopy JTF_VARCHAR2_TABLE_100
204: , a24 out nocopy JTF_NUMBER_TABLE
200: , a20 out nocopy JTF_NUMBER_TABLE
201: , a21 out nocopy JTF_VARCHAR2_TABLE_100
202: , a22 out nocopy JTF_VARCHAR2_TABLE_100
203: , a23 out nocopy JTF_VARCHAR2_TABLE_100
204: , a24 out nocopy JTF_NUMBER_TABLE
205: , a25 out nocopy JTF_NUMBER_TABLE
206: , a26 out nocopy JTF_NUMBER_TABLE
207: ) as
208: ddindx binary_integer; indx binary_integer;
201: , a21 out nocopy JTF_VARCHAR2_TABLE_100
202: , a22 out nocopy JTF_VARCHAR2_TABLE_100
203: , a23 out nocopy JTF_VARCHAR2_TABLE_100
204: , a24 out nocopy JTF_NUMBER_TABLE
205: , a25 out nocopy JTF_NUMBER_TABLE
206: , a26 out nocopy JTF_NUMBER_TABLE
207: ) as
208: ddindx binary_integer; indx binary_integer;
209: begin
202: , a22 out nocopy JTF_VARCHAR2_TABLE_100
203: , a23 out nocopy JTF_VARCHAR2_TABLE_100
204: , a24 out nocopy JTF_NUMBER_TABLE
205: , a25 out nocopy JTF_NUMBER_TABLE
206: , a26 out nocopy JTF_NUMBER_TABLE
207: ) as
208: ddindx binary_integer; indx binary_integer;
209: begin
210: if t is null or t.count = 0 then
207: ) as
208: ddindx binary_integer; indx binary_integer;
209: begin
210: if t is null or t.count = 0 then
211: a0 := JTF_NUMBER_TABLE();
212: a1 := JTF_DATE_TABLE();
213: a2 := JTF_DATE_TABLE();
214: a3 := JTF_DATE_TABLE();
215: a4 := JTF_NUMBER_TABLE();
211: a0 := JTF_NUMBER_TABLE();
212: a1 := JTF_DATE_TABLE();
213: a2 := JTF_DATE_TABLE();
214: a3 := JTF_DATE_TABLE();
215: a4 := JTF_NUMBER_TABLE();
216: a5 := JTF_NUMBER_TABLE();
217: a6 := JTF_NUMBER_TABLE();
218: a7 := JTF_NUMBER_TABLE();
219: a8 := JTF_NUMBER_TABLE();
212: a1 := JTF_DATE_TABLE();
213: a2 := JTF_DATE_TABLE();
214: a3 := JTF_DATE_TABLE();
215: a4 := JTF_NUMBER_TABLE();
216: a5 := JTF_NUMBER_TABLE();
217: a6 := JTF_NUMBER_TABLE();
218: a7 := JTF_NUMBER_TABLE();
219: a8 := JTF_NUMBER_TABLE();
220: a9 := JTF_NUMBER_TABLE();
213: a2 := JTF_DATE_TABLE();
214: a3 := JTF_DATE_TABLE();
215: a4 := JTF_NUMBER_TABLE();
216: a5 := JTF_NUMBER_TABLE();
217: a6 := JTF_NUMBER_TABLE();
218: a7 := JTF_NUMBER_TABLE();
219: a8 := JTF_NUMBER_TABLE();
220: a9 := JTF_NUMBER_TABLE();
221: a10 := JTF_NUMBER_TABLE();
214: a3 := JTF_DATE_TABLE();
215: a4 := JTF_NUMBER_TABLE();
216: a5 := JTF_NUMBER_TABLE();
217: a6 := JTF_NUMBER_TABLE();
218: a7 := JTF_NUMBER_TABLE();
219: a8 := JTF_NUMBER_TABLE();
220: a9 := JTF_NUMBER_TABLE();
221: a10 := JTF_NUMBER_TABLE();
222: a11 := JTF_NUMBER_TABLE();
215: a4 := JTF_NUMBER_TABLE();
216: a5 := JTF_NUMBER_TABLE();
217: a6 := JTF_NUMBER_TABLE();
218: a7 := JTF_NUMBER_TABLE();
219: a8 := JTF_NUMBER_TABLE();
220: a9 := JTF_NUMBER_TABLE();
221: a10 := JTF_NUMBER_TABLE();
222: a11 := JTF_NUMBER_TABLE();
223: a12 := JTF_NUMBER_TABLE();
216: a5 := JTF_NUMBER_TABLE();
217: a6 := JTF_NUMBER_TABLE();
218: a7 := JTF_NUMBER_TABLE();
219: a8 := JTF_NUMBER_TABLE();
220: a9 := JTF_NUMBER_TABLE();
221: a10 := JTF_NUMBER_TABLE();
222: a11 := JTF_NUMBER_TABLE();
223: a12 := JTF_NUMBER_TABLE();
224: a13 := JTF_NUMBER_TABLE();
217: a6 := JTF_NUMBER_TABLE();
218: a7 := JTF_NUMBER_TABLE();
219: a8 := JTF_NUMBER_TABLE();
220: a9 := JTF_NUMBER_TABLE();
221: a10 := JTF_NUMBER_TABLE();
222: a11 := JTF_NUMBER_TABLE();
223: a12 := JTF_NUMBER_TABLE();
224: a13 := JTF_NUMBER_TABLE();
225: a14 := JTF_NUMBER_TABLE();
218: a7 := JTF_NUMBER_TABLE();
219: a8 := JTF_NUMBER_TABLE();
220: a9 := JTF_NUMBER_TABLE();
221: a10 := JTF_NUMBER_TABLE();
222: a11 := JTF_NUMBER_TABLE();
223: a12 := JTF_NUMBER_TABLE();
224: a13 := JTF_NUMBER_TABLE();
225: a14 := JTF_NUMBER_TABLE();
226: a15 := JTF_NUMBER_TABLE();
219: a8 := JTF_NUMBER_TABLE();
220: a9 := JTF_NUMBER_TABLE();
221: a10 := JTF_NUMBER_TABLE();
222: a11 := JTF_NUMBER_TABLE();
223: a12 := JTF_NUMBER_TABLE();
224: a13 := JTF_NUMBER_TABLE();
225: a14 := JTF_NUMBER_TABLE();
226: a15 := JTF_NUMBER_TABLE();
227: a16 := JTF_NUMBER_TABLE();
220: a9 := JTF_NUMBER_TABLE();
221: a10 := JTF_NUMBER_TABLE();
222: a11 := JTF_NUMBER_TABLE();
223: a12 := JTF_NUMBER_TABLE();
224: a13 := JTF_NUMBER_TABLE();
225: a14 := JTF_NUMBER_TABLE();
226: a15 := JTF_NUMBER_TABLE();
227: a16 := JTF_NUMBER_TABLE();
228: a17 := JTF_NUMBER_TABLE();
221: a10 := JTF_NUMBER_TABLE();
222: a11 := JTF_NUMBER_TABLE();
223: a12 := JTF_NUMBER_TABLE();
224: a13 := JTF_NUMBER_TABLE();
225: a14 := JTF_NUMBER_TABLE();
226: a15 := JTF_NUMBER_TABLE();
227: a16 := JTF_NUMBER_TABLE();
228: a17 := JTF_NUMBER_TABLE();
229: a18 := JTF_NUMBER_TABLE();
222: a11 := JTF_NUMBER_TABLE();
223: a12 := JTF_NUMBER_TABLE();
224: a13 := JTF_NUMBER_TABLE();
225: a14 := JTF_NUMBER_TABLE();
226: a15 := JTF_NUMBER_TABLE();
227: a16 := JTF_NUMBER_TABLE();
228: a17 := JTF_NUMBER_TABLE();
229: a18 := JTF_NUMBER_TABLE();
230: a19 := JTF_NUMBER_TABLE();
223: a12 := JTF_NUMBER_TABLE();
224: a13 := JTF_NUMBER_TABLE();
225: a14 := JTF_NUMBER_TABLE();
226: a15 := JTF_NUMBER_TABLE();
227: a16 := JTF_NUMBER_TABLE();
228: a17 := JTF_NUMBER_TABLE();
229: a18 := JTF_NUMBER_TABLE();
230: a19 := JTF_NUMBER_TABLE();
231: a20 := JTF_NUMBER_TABLE();
224: a13 := JTF_NUMBER_TABLE();
225: a14 := JTF_NUMBER_TABLE();
226: a15 := JTF_NUMBER_TABLE();
227: a16 := JTF_NUMBER_TABLE();
228: a17 := JTF_NUMBER_TABLE();
229: a18 := JTF_NUMBER_TABLE();
230: a19 := JTF_NUMBER_TABLE();
231: a20 := JTF_NUMBER_TABLE();
232: a21 := JTF_VARCHAR2_TABLE_100();
225: a14 := JTF_NUMBER_TABLE();
226: a15 := JTF_NUMBER_TABLE();
227: a16 := JTF_NUMBER_TABLE();
228: a17 := JTF_NUMBER_TABLE();
229: a18 := JTF_NUMBER_TABLE();
230: a19 := JTF_NUMBER_TABLE();
231: a20 := JTF_NUMBER_TABLE();
232: a21 := JTF_VARCHAR2_TABLE_100();
233: a22 := JTF_VARCHAR2_TABLE_100();
226: a15 := JTF_NUMBER_TABLE();
227: a16 := JTF_NUMBER_TABLE();
228: a17 := JTF_NUMBER_TABLE();
229: a18 := JTF_NUMBER_TABLE();
230: a19 := JTF_NUMBER_TABLE();
231: a20 := JTF_NUMBER_TABLE();
232: a21 := JTF_VARCHAR2_TABLE_100();
233: a22 := JTF_VARCHAR2_TABLE_100();
234: a23 := JTF_VARCHAR2_TABLE_100();
227: a16 := JTF_NUMBER_TABLE();
228: a17 := JTF_NUMBER_TABLE();
229: a18 := JTF_NUMBER_TABLE();
230: a19 := JTF_NUMBER_TABLE();
231: a20 := JTF_NUMBER_TABLE();
232: a21 := JTF_VARCHAR2_TABLE_100();
233: a22 := JTF_VARCHAR2_TABLE_100();
234: a23 := JTF_VARCHAR2_TABLE_100();
235: a24 := JTF_NUMBER_TABLE();
231: a20 := JTF_NUMBER_TABLE();
232: a21 := JTF_VARCHAR2_TABLE_100();
233: a22 := JTF_VARCHAR2_TABLE_100();
234: a23 := JTF_VARCHAR2_TABLE_100();
235: a24 := JTF_NUMBER_TABLE();
236: a25 := JTF_NUMBER_TABLE();
237: a26 := JTF_NUMBER_TABLE();
238: else
239: a0 := JTF_NUMBER_TABLE();
232: a21 := JTF_VARCHAR2_TABLE_100();
233: a22 := JTF_VARCHAR2_TABLE_100();
234: a23 := JTF_VARCHAR2_TABLE_100();
235: a24 := JTF_NUMBER_TABLE();
236: a25 := JTF_NUMBER_TABLE();
237: a26 := JTF_NUMBER_TABLE();
238: else
239: a0 := JTF_NUMBER_TABLE();
240: a1 := JTF_DATE_TABLE();
233: a22 := JTF_VARCHAR2_TABLE_100();
234: a23 := JTF_VARCHAR2_TABLE_100();
235: a24 := JTF_NUMBER_TABLE();
236: a25 := JTF_NUMBER_TABLE();
237: a26 := JTF_NUMBER_TABLE();
238: else
239: a0 := JTF_NUMBER_TABLE();
240: a1 := JTF_DATE_TABLE();
241: a2 := JTF_DATE_TABLE();
235: a24 := JTF_NUMBER_TABLE();
236: a25 := JTF_NUMBER_TABLE();
237: a26 := JTF_NUMBER_TABLE();
238: else
239: a0 := JTF_NUMBER_TABLE();
240: a1 := JTF_DATE_TABLE();
241: a2 := JTF_DATE_TABLE();
242: a3 := JTF_DATE_TABLE();
243: a4 := JTF_NUMBER_TABLE();
239: a0 := JTF_NUMBER_TABLE();
240: a1 := JTF_DATE_TABLE();
241: a2 := JTF_DATE_TABLE();
242: a3 := JTF_DATE_TABLE();
243: a4 := JTF_NUMBER_TABLE();
244: a5 := JTF_NUMBER_TABLE();
245: a6 := JTF_NUMBER_TABLE();
246: a7 := JTF_NUMBER_TABLE();
247: a8 := JTF_NUMBER_TABLE();
240: a1 := JTF_DATE_TABLE();
241: a2 := JTF_DATE_TABLE();
242: a3 := JTF_DATE_TABLE();
243: a4 := JTF_NUMBER_TABLE();
244: a5 := JTF_NUMBER_TABLE();
245: a6 := JTF_NUMBER_TABLE();
246: a7 := JTF_NUMBER_TABLE();
247: a8 := JTF_NUMBER_TABLE();
248: a9 := JTF_NUMBER_TABLE();
241: a2 := JTF_DATE_TABLE();
242: a3 := JTF_DATE_TABLE();
243: a4 := JTF_NUMBER_TABLE();
244: a5 := JTF_NUMBER_TABLE();
245: a6 := JTF_NUMBER_TABLE();
246: a7 := JTF_NUMBER_TABLE();
247: a8 := JTF_NUMBER_TABLE();
248: a9 := JTF_NUMBER_TABLE();
249: a10 := JTF_NUMBER_TABLE();
242: a3 := JTF_DATE_TABLE();
243: a4 := JTF_NUMBER_TABLE();
244: a5 := JTF_NUMBER_TABLE();
245: a6 := JTF_NUMBER_TABLE();
246: a7 := JTF_NUMBER_TABLE();
247: a8 := JTF_NUMBER_TABLE();
248: a9 := JTF_NUMBER_TABLE();
249: a10 := JTF_NUMBER_TABLE();
250: a11 := JTF_NUMBER_TABLE();
243: a4 := JTF_NUMBER_TABLE();
244: a5 := JTF_NUMBER_TABLE();
245: a6 := JTF_NUMBER_TABLE();
246: a7 := JTF_NUMBER_TABLE();
247: a8 := JTF_NUMBER_TABLE();
248: a9 := JTF_NUMBER_TABLE();
249: a10 := JTF_NUMBER_TABLE();
250: a11 := JTF_NUMBER_TABLE();
251: a12 := JTF_NUMBER_TABLE();
244: a5 := JTF_NUMBER_TABLE();
245: a6 := JTF_NUMBER_TABLE();
246: a7 := JTF_NUMBER_TABLE();
247: a8 := JTF_NUMBER_TABLE();
248: a9 := JTF_NUMBER_TABLE();
249: a10 := JTF_NUMBER_TABLE();
250: a11 := JTF_NUMBER_TABLE();
251: a12 := JTF_NUMBER_TABLE();
252: a13 := JTF_NUMBER_TABLE();
245: a6 := JTF_NUMBER_TABLE();
246: a7 := JTF_NUMBER_TABLE();
247: a8 := JTF_NUMBER_TABLE();
248: a9 := JTF_NUMBER_TABLE();
249: a10 := JTF_NUMBER_TABLE();
250: a11 := JTF_NUMBER_TABLE();
251: a12 := JTF_NUMBER_TABLE();
252: a13 := JTF_NUMBER_TABLE();
253: a14 := JTF_NUMBER_TABLE();
246: a7 := JTF_NUMBER_TABLE();
247: a8 := JTF_NUMBER_TABLE();
248: a9 := JTF_NUMBER_TABLE();
249: a10 := JTF_NUMBER_TABLE();
250: a11 := JTF_NUMBER_TABLE();
251: a12 := JTF_NUMBER_TABLE();
252: a13 := JTF_NUMBER_TABLE();
253: a14 := JTF_NUMBER_TABLE();
254: a15 := JTF_NUMBER_TABLE();
247: a8 := JTF_NUMBER_TABLE();
248: a9 := JTF_NUMBER_TABLE();
249: a10 := JTF_NUMBER_TABLE();
250: a11 := JTF_NUMBER_TABLE();
251: a12 := JTF_NUMBER_TABLE();
252: a13 := JTF_NUMBER_TABLE();
253: a14 := JTF_NUMBER_TABLE();
254: a15 := JTF_NUMBER_TABLE();
255: a16 := JTF_NUMBER_TABLE();
248: a9 := JTF_NUMBER_TABLE();
249: a10 := JTF_NUMBER_TABLE();
250: a11 := JTF_NUMBER_TABLE();
251: a12 := JTF_NUMBER_TABLE();
252: a13 := JTF_NUMBER_TABLE();
253: a14 := JTF_NUMBER_TABLE();
254: a15 := JTF_NUMBER_TABLE();
255: a16 := JTF_NUMBER_TABLE();
256: a17 := JTF_NUMBER_TABLE();
249: a10 := JTF_NUMBER_TABLE();
250: a11 := JTF_NUMBER_TABLE();
251: a12 := JTF_NUMBER_TABLE();
252: a13 := JTF_NUMBER_TABLE();
253: a14 := JTF_NUMBER_TABLE();
254: a15 := JTF_NUMBER_TABLE();
255: a16 := JTF_NUMBER_TABLE();
256: a17 := JTF_NUMBER_TABLE();
257: a18 := JTF_NUMBER_TABLE();
250: a11 := JTF_NUMBER_TABLE();
251: a12 := JTF_NUMBER_TABLE();
252: a13 := JTF_NUMBER_TABLE();
253: a14 := JTF_NUMBER_TABLE();
254: a15 := JTF_NUMBER_TABLE();
255: a16 := JTF_NUMBER_TABLE();
256: a17 := JTF_NUMBER_TABLE();
257: a18 := JTF_NUMBER_TABLE();
258: a19 := JTF_NUMBER_TABLE();
251: a12 := JTF_NUMBER_TABLE();
252: a13 := JTF_NUMBER_TABLE();
253: a14 := JTF_NUMBER_TABLE();
254: a15 := JTF_NUMBER_TABLE();
255: a16 := JTF_NUMBER_TABLE();
256: a17 := JTF_NUMBER_TABLE();
257: a18 := JTF_NUMBER_TABLE();
258: a19 := JTF_NUMBER_TABLE();
259: a20 := JTF_NUMBER_TABLE();
252: a13 := JTF_NUMBER_TABLE();
253: a14 := JTF_NUMBER_TABLE();
254: a15 := JTF_NUMBER_TABLE();
255: a16 := JTF_NUMBER_TABLE();
256: a17 := JTF_NUMBER_TABLE();
257: a18 := JTF_NUMBER_TABLE();
258: a19 := JTF_NUMBER_TABLE();
259: a20 := JTF_NUMBER_TABLE();
260: a21 := JTF_VARCHAR2_TABLE_100();
253: a14 := JTF_NUMBER_TABLE();
254: a15 := JTF_NUMBER_TABLE();
255: a16 := JTF_NUMBER_TABLE();
256: a17 := JTF_NUMBER_TABLE();
257: a18 := JTF_NUMBER_TABLE();
258: a19 := JTF_NUMBER_TABLE();
259: a20 := JTF_NUMBER_TABLE();
260: a21 := JTF_VARCHAR2_TABLE_100();
261: a22 := JTF_VARCHAR2_TABLE_100();
254: a15 := JTF_NUMBER_TABLE();
255: a16 := JTF_NUMBER_TABLE();
256: a17 := JTF_NUMBER_TABLE();
257: a18 := JTF_NUMBER_TABLE();
258: a19 := JTF_NUMBER_TABLE();
259: a20 := JTF_NUMBER_TABLE();
260: a21 := JTF_VARCHAR2_TABLE_100();
261: a22 := JTF_VARCHAR2_TABLE_100();
262: a23 := JTF_VARCHAR2_TABLE_100();
255: a16 := JTF_NUMBER_TABLE();
256: a17 := JTF_NUMBER_TABLE();
257: a18 := JTF_NUMBER_TABLE();
258: a19 := JTF_NUMBER_TABLE();
259: a20 := JTF_NUMBER_TABLE();
260: a21 := JTF_VARCHAR2_TABLE_100();
261: a22 := JTF_VARCHAR2_TABLE_100();
262: a23 := JTF_VARCHAR2_TABLE_100();
263: a24 := JTF_NUMBER_TABLE();
259: a20 := JTF_NUMBER_TABLE();
260: a21 := JTF_VARCHAR2_TABLE_100();
261: a22 := JTF_VARCHAR2_TABLE_100();
262: a23 := JTF_VARCHAR2_TABLE_100();
263: a24 := JTF_NUMBER_TABLE();
264: a25 := JTF_NUMBER_TABLE();
265: a26 := JTF_NUMBER_TABLE();
266: if t.count > 0 then
267: a0.extend(t.count);
260: a21 := JTF_VARCHAR2_TABLE_100();
261: a22 := JTF_VARCHAR2_TABLE_100();
262: a23 := JTF_VARCHAR2_TABLE_100();
263: a24 := JTF_NUMBER_TABLE();
264: a25 := JTF_NUMBER_TABLE();
265: a26 := JTF_NUMBER_TABLE();
266: if t.count > 0 then
267: a0.extend(t.count);
268: a1.extend(t.count);
261: a22 := JTF_VARCHAR2_TABLE_100();
262: a23 := JTF_VARCHAR2_TABLE_100();
263: a24 := JTF_NUMBER_TABLE();
264: a25 := JTF_NUMBER_TABLE();
265: a26 := JTF_NUMBER_TABLE();
266: if t.count > 0 then
267: a0.extend(t.count);
268: a1.extend(t.count);
269: a2.extend(t.count);
330: end if;
331: end if;
332: end rosetta_table_copy_out_p3;
333:
334: procedure rosetta_table_copy_in_p6(t out nocopy lns_financials.payoff_tbl, a0 JTF_NUMBER_TABLE
335: , a1 JTF_NUMBER_TABLE
336: , a2 JTF_NUMBER_TABLE
337: , a3 JTF_NUMBER_TABLE
338: , a4 JTF_NUMBER_TABLE
331: end if;
332: end rosetta_table_copy_out_p3;
333:
334: procedure rosetta_table_copy_in_p6(t out nocopy lns_financials.payoff_tbl, a0 JTF_NUMBER_TABLE
335: , a1 JTF_NUMBER_TABLE
336: , a2 JTF_NUMBER_TABLE
337: , a3 JTF_NUMBER_TABLE
338: , a4 JTF_NUMBER_TABLE
339: , a5 JTF_NUMBER_TABLE
332: end rosetta_table_copy_out_p3;
333:
334: procedure rosetta_table_copy_in_p6(t out nocopy lns_financials.payoff_tbl, a0 JTF_NUMBER_TABLE
335: , a1 JTF_NUMBER_TABLE
336: , a2 JTF_NUMBER_TABLE
337: , a3 JTF_NUMBER_TABLE
338: , a4 JTF_NUMBER_TABLE
339: , a5 JTF_NUMBER_TABLE
340: , a6 JTF_NUMBER_TABLE
333:
334: procedure rosetta_table_copy_in_p6(t out nocopy lns_financials.payoff_tbl, a0 JTF_NUMBER_TABLE
335: , a1 JTF_NUMBER_TABLE
336: , a2 JTF_NUMBER_TABLE
337: , a3 JTF_NUMBER_TABLE
338: , a4 JTF_NUMBER_TABLE
339: , a5 JTF_NUMBER_TABLE
340: , a6 JTF_NUMBER_TABLE
341: , a7 JTF_NUMBER_TABLE
334: procedure rosetta_table_copy_in_p6(t out nocopy lns_financials.payoff_tbl, a0 JTF_NUMBER_TABLE
335: , a1 JTF_NUMBER_TABLE
336: , a2 JTF_NUMBER_TABLE
337: , a3 JTF_NUMBER_TABLE
338: , a4 JTF_NUMBER_TABLE
339: , a5 JTF_NUMBER_TABLE
340: , a6 JTF_NUMBER_TABLE
341: , a7 JTF_NUMBER_TABLE
342: , a8 JTF_NUMBER_TABLE
335: , a1 JTF_NUMBER_TABLE
336: , a2 JTF_NUMBER_TABLE
337: , a3 JTF_NUMBER_TABLE
338: , a4 JTF_NUMBER_TABLE
339: , a5 JTF_NUMBER_TABLE
340: , a6 JTF_NUMBER_TABLE
341: , a7 JTF_NUMBER_TABLE
342: , a8 JTF_NUMBER_TABLE
343: , a9 JTF_DATE_TABLE
336: , a2 JTF_NUMBER_TABLE
337: , a3 JTF_NUMBER_TABLE
338: , a4 JTF_NUMBER_TABLE
339: , a5 JTF_NUMBER_TABLE
340: , a6 JTF_NUMBER_TABLE
341: , a7 JTF_NUMBER_TABLE
342: , a8 JTF_NUMBER_TABLE
343: , a9 JTF_DATE_TABLE
344: ) as
337: , a3 JTF_NUMBER_TABLE
338: , a4 JTF_NUMBER_TABLE
339: , a5 JTF_NUMBER_TABLE
340: , a6 JTF_NUMBER_TABLE
341: , a7 JTF_NUMBER_TABLE
342: , a8 JTF_NUMBER_TABLE
343: , a9 JTF_DATE_TABLE
344: ) as
345: ddindx binary_integer; indx binary_integer;
338: , a4 JTF_NUMBER_TABLE
339: , a5 JTF_NUMBER_TABLE
340: , a6 JTF_NUMBER_TABLE
341: , a7 JTF_NUMBER_TABLE
342: , a8 JTF_NUMBER_TABLE
343: , a9 JTF_DATE_TABLE
344: ) as
345: ddindx binary_integer; indx binary_integer;
346: begin
367: end loop;
368: end if;
369: end if;
370: end rosetta_table_copy_in_p6;
371: procedure rosetta_table_copy_out_p6(t lns_financials.payoff_tbl, a0 out nocopy JTF_NUMBER_TABLE
372: , a1 out nocopy JTF_NUMBER_TABLE
373: , a2 out nocopy JTF_NUMBER_TABLE
374: , a3 out nocopy JTF_NUMBER_TABLE
375: , a4 out nocopy JTF_NUMBER_TABLE
368: end if;
369: end if;
370: end rosetta_table_copy_in_p6;
371: procedure rosetta_table_copy_out_p6(t lns_financials.payoff_tbl, a0 out nocopy JTF_NUMBER_TABLE
372: , a1 out nocopy JTF_NUMBER_TABLE
373: , a2 out nocopy JTF_NUMBER_TABLE
374: , a3 out nocopy JTF_NUMBER_TABLE
375: , a4 out nocopy JTF_NUMBER_TABLE
376: , a5 out nocopy JTF_NUMBER_TABLE
369: end if;
370: end rosetta_table_copy_in_p6;
371: procedure rosetta_table_copy_out_p6(t lns_financials.payoff_tbl, a0 out nocopy JTF_NUMBER_TABLE
372: , a1 out nocopy JTF_NUMBER_TABLE
373: , a2 out nocopy JTF_NUMBER_TABLE
374: , a3 out nocopy JTF_NUMBER_TABLE
375: , a4 out nocopy JTF_NUMBER_TABLE
376: , a5 out nocopy JTF_NUMBER_TABLE
377: , a6 out nocopy JTF_NUMBER_TABLE
370: end rosetta_table_copy_in_p6;
371: procedure rosetta_table_copy_out_p6(t lns_financials.payoff_tbl, a0 out nocopy JTF_NUMBER_TABLE
372: , a1 out nocopy JTF_NUMBER_TABLE
373: , a2 out nocopy JTF_NUMBER_TABLE
374: , a3 out nocopy JTF_NUMBER_TABLE
375: , a4 out nocopy JTF_NUMBER_TABLE
376: , a5 out nocopy JTF_NUMBER_TABLE
377: , a6 out nocopy JTF_NUMBER_TABLE
378: , a7 out nocopy JTF_NUMBER_TABLE
371: procedure rosetta_table_copy_out_p6(t lns_financials.payoff_tbl, a0 out nocopy JTF_NUMBER_TABLE
372: , a1 out nocopy JTF_NUMBER_TABLE
373: , a2 out nocopy JTF_NUMBER_TABLE
374: , a3 out nocopy JTF_NUMBER_TABLE
375: , a4 out nocopy JTF_NUMBER_TABLE
376: , a5 out nocopy JTF_NUMBER_TABLE
377: , a6 out nocopy JTF_NUMBER_TABLE
378: , a7 out nocopy JTF_NUMBER_TABLE
379: , a8 out nocopy JTF_NUMBER_TABLE
372: , a1 out nocopy JTF_NUMBER_TABLE
373: , a2 out nocopy JTF_NUMBER_TABLE
374: , a3 out nocopy JTF_NUMBER_TABLE
375: , a4 out nocopy JTF_NUMBER_TABLE
376: , a5 out nocopy JTF_NUMBER_TABLE
377: , a6 out nocopy JTF_NUMBER_TABLE
378: , a7 out nocopy JTF_NUMBER_TABLE
379: , a8 out nocopy JTF_NUMBER_TABLE
380: , a9 out nocopy JTF_DATE_TABLE
373: , a2 out nocopy JTF_NUMBER_TABLE
374: , a3 out nocopy JTF_NUMBER_TABLE
375: , a4 out nocopy JTF_NUMBER_TABLE
376: , a5 out nocopy JTF_NUMBER_TABLE
377: , a6 out nocopy JTF_NUMBER_TABLE
378: , a7 out nocopy JTF_NUMBER_TABLE
379: , a8 out nocopy JTF_NUMBER_TABLE
380: , a9 out nocopy JTF_DATE_TABLE
381: ) as
374: , a3 out nocopy JTF_NUMBER_TABLE
375: , a4 out nocopy JTF_NUMBER_TABLE
376: , a5 out nocopy JTF_NUMBER_TABLE
377: , a6 out nocopy JTF_NUMBER_TABLE
378: , a7 out nocopy JTF_NUMBER_TABLE
379: , a8 out nocopy JTF_NUMBER_TABLE
380: , a9 out nocopy JTF_DATE_TABLE
381: ) as
382: ddindx binary_integer; indx binary_integer;
375: , a4 out nocopy JTF_NUMBER_TABLE
376: , a5 out nocopy JTF_NUMBER_TABLE
377: , a6 out nocopy JTF_NUMBER_TABLE
378: , a7 out nocopy JTF_NUMBER_TABLE
379: , a8 out nocopy JTF_NUMBER_TABLE
380: , a9 out nocopy JTF_DATE_TABLE
381: ) as
382: ddindx binary_integer; indx binary_integer;
383: begin
381: ) as
382: ddindx binary_integer; indx binary_integer;
383: begin
384: if t is null or t.count = 0 then
385: a0 := JTF_NUMBER_TABLE();
386: a1 := JTF_NUMBER_TABLE();
387: a2 := JTF_NUMBER_TABLE();
388: a3 := JTF_NUMBER_TABLE();
389: a4 := JTF_NUMBER_TABLE();
382: ddindx binary_integer; indx binary_integer;
383: begin
384: if t is null or t.count = 0 then
385: a0 := JTF_NUMBER_TABLE();
386: a1 := JTF_NUMBER_TABLE();
387: a2 := JTF_NUMBER_TABLE();
388: a3 := JTF_NUMBER_TABLE();
389: a4 := JTF_NUMBER_TABLE();
390: a5 := JTF_NUMBER_TABLE();
383: begin
384: if t is null or t.count = 0 then
385: a0 := JTF_NUMBER_TABLE();
386: a1 := JTF_NUMBER_TABLE();
387: a2 := JTF_NUMBER_TABLE();
388: a3 := JTF_NUMBER_TABLE();
389: a4 := JTF_NUMBER_TABLE();
390: a5 := JTF_NUMBER_TABLE();
391: a6 := JTF_NUMBER_TABLE();
384: if t is null or t.count = 0 then
385: a0 := JTF_NUMBER_TABLE();
386: a1 := JTF_NUMBER_TABLE();
387: a2 := JTF_NUMBER_TABLE();
388: a3 := JTF_NUMBER_TABLE();
389: a4 := JTF_NUMBER_TABLE();
390: a5 := JTF_NUMBER_TABLE();
391: a6 := JTF_NUMBER_TABLE();
392: a7 := JTF_NUMBER_TABLE();
385: a0 := JTF_NUMBER_TABLE();
386: a1 := JTF_NUMBER_TABLE();
387: a2 := JTF_NUMBER_TABLE();
388: a3 := JTF_NUMBER_TABLE();
389: a4 := JTF_NUMBER_TABLE();
390: a5 := JTF_NUMBER_TABLE();
391: a6 := JTF_NUMBER_TABLE();
392: a7 := JTF_NUMBER_TABLE();
393: a8 := JTF_NUMBER_TABLE();
386: a1 := JTF_NUMBER_TABLE();
387: a2 := JTF_NUMBER_TABLE();
388: a3 := JTF_NUMBER_TABLE();
389: a4 := JTF_NUMBER_TABLE();
390: a5 := JTF_NUMBER_TABLE();
391: a6 := JTF_NUMBER_TABLE();
392: a7 := JTF_NUMBER_TABLE();
393: a8 := JTF_NUMBER_TABLE();
394: a9 := JTF_DATE_TABLE();
387: a2 := JTF_NUMBER_TABLE();
388: a3 := JTF_NUMBER_TABLE();
389: a4 := JTF_NUMBER_TABLE();
390: a5 := JTF_NUMBER_TABLE();
391: a6 := JTF_NUMBER_TABLE();
392: a7 := JTF_NUMBER_TABLE();
393: a8 := JTF_NUMBER_TABLE();
394: a9 := JTF_DATE_TABLE();
395: else
388: a3 := JTF_NUMBER_TABLE();
389: a4 := JTF_NUMBER_TABLE();
390: a5 := JTF_NUMBER_TABLE();
391: a6 := JTF_NUMBER_TABLE();
392: a7 := JTF_NUMBER_TABLE();
393: a8 := JTF_NUMBER_TABLE();
394: a9 := JTF_DATE_TABLE();
395: else
396: a0 := JTF_NUMBER_TABLE();
389: a4 := JTF_NUMBER_TABLE();
390: a5 := JTF_NUMBER_TABLE();
391: a6 := JTF_NUMBER_TABLE();
392: a7 := JTF_NUMBER_TABLE();
393: a8 := JTF_NUMBER_TABLE();
394: a9 := JTF_DATE_TABLE();
395: else
396: a0 := JTF_NUMBER_TABLE();
397: a1 := JTF_NUMBER_TABLE();
392: a7 := JTF_NUMBER_TABLE();
393: a8 := JTF_NUMBER_TABLE();
394: a9 := JTF_DATE_TABLE();
395: else
396: a0 := JTF_NUMBER_TABLE();
397: a1 := JTF_NUMBER_TABLE();
398: a2 := JTF_NUMBER_TABLE();
399: a3 := JTF_NUMBER_TABLE();
400: a4 := JTF_NUMBER_TABLE();
393: a8 := JTF_NUMBER_TABLE();
394: a9 := JTF_DATE_TABLE();
395: else
396: a0 := JTF_NUMBER_TABLE();
397: a1 := JTF_NUMBER_TABLE();
398: a2 := JTF_NUMBER_TABLE();
399: a3 := JTF_NUMBER_TABLE();
400: a4 := JTF_NUMBER_TABLE();
401: a5 := JTF_NUMBER_TABLE();
394: a9 := JTF_DATE_TABLE();
395: else
396: a0 := JTF_NUMBER_TABLE();
397: a1 := JTF_NUMBER_TABLE();
398: a2 := JTF_NUMBER_TABLE();
399: a3 := JTF_NUMBER_TABLE();
400: a4 := JTF_NUMBER_TABLE();
401: a5 := JTF_NUMBER_TABLE();
402: a6 := JTF_NUMBER_TABLE();
395: else
396: a0 := JTF_NUMBER_TABLE();
397: a1 := JTF_NUMBER_TABLE();
398: a2 := JTF_NUMBER_TABLE();
399: a3 := JTF_NUMBER_TABLE();
400: a4 := JTF_NUMBER_TABLE();
401: a5 := JTF_NUMBER_TABLE();
402: a6 := JTF_NUMBER_TABLE();
403: a7 := JTF_NUMBER_TABLE();
396: a0 := JTF_NUMBER_TABLE();
397: a1 := JTF_NUMBER_TABLE();
398: a2 := JTF_NUMBER_TABLE();
399: a3 := JTF_NUMBER_TABLE();
400: a4 := JTF_NUMBER_TABLE();
401: a5 := JTF_NUMBER_TABLE();
402: a6 := JTF_NUMBER_TABLE();
403: a7 := JTF_NUMBER_TABLE();
404: a8 := JTF_NUMBER_TABLE();
397: a1 := JTF_NUMBER_TABLE();
398: a2 := JTF_NUMBER_TABLE();
399: a3 := JTF_NUMBER_TABLE();
400: a4 := JTF_NUMBER_TABLE();
401: a5 := JTF_NUMBER_TABLE();
402: a6 := JTF_NUMBER_TABLE();
403: a7 := JTF_NUMBER_TABLE();
404: a8 := JTF_NUMBER_TABLE();
405: a9 := JTF_DATE_TABLE();
398: a2 := JTF_NUMBER_TABLE();
399: a3 := JTF_NUMBER_TABLE();
400: a4 := JTF_NUMBER_TABLE();
401: a5 := JTF_NUMBER_TABLE();
402: a6 := JTF_NUMBER_TABLE();
403: a7 := JTF_NUMBER_TABLE();
404: a8 := JTF_NUMBER_TABLE();
405: a9 := JTF_DATE_TABLE();
406: if t.count > 0 then
399: a3 := JTF_NUMBER_TABLE();
400: a4 := JTF_NUMBER_TABLE();
401: a5 := JTF_NUMBER_TABLE();
402: a6 := JTF_NUMBER_TABLE();
403: a7 := JTF_NUMBER_TABLE();
404: a8 := JTF_NUMBER_TABLE();
405: a9 := JTF_DATE_TABLE();
406: if t.count > 0 then
407: a0.extend(t.count);
400: a4 := JTF_NUMBER_TABLE();
401: a5 := JTF_NUMBER_TABLE();
402: a6 := JTF_NUMBER_TABLE();
403: a7 := JTF_NUMBER_TABLE();
404: a8 := JTF_NUMBER_TABLE();
405: a9 := JTF_DATE_TABLE();
406: if t.count > 0 then
407: a0.extend(t.count);
408: a1.extend(t.count);
437: end if;
438: end rosetta_table_copy_out_p6;
439:
440: procedure rosetta_table_copy_in_p8(t out nocopy lns_financials.payoff_tbl2, a0 JTF_VARCHAR2_TABLE_100
441: , a1 JTF_NUMBER_TABLE
442: , a2 JTF_NUMBER_TABLE
443: , a3 JTF_NUMBER_TABLE
444: ) as
445: ddindx binary_integer; indx binary_integer;
438: end rosetta_table_copy_out_p6;
439:
440: procedure rosetta_table_copy_in_p8(t out nocopy lns_financials.payoff_tbl2, a0 JTF_VARCHAR2_TABLE_100
441: , a1 JTF_NUMBER_TABLE
442: , a2 JTF_NUMBER_TABLE
443: , a3 JTF_NUMBER_TABLE
444: ) as
445: ddindx binary_integer; indx binary_integer;
446: begin
439:
440: procedure rosetta_table_copy_in_p8(t out nocopy lns_financials.payoff_tbl2, a0 JTF_VARCHAR2_TABLE_100
441: , a1 JTF_NUMBER_TABLE
442: , a2 JTF_NUMBER_TABLE
443: , a3 JTF_NUMBER_TABLE
444: ) as
445: ddindx binary_integer; indx binary_integer;
446: begin
447: if a0 is not null and a0.count > 0 then
462: end if;
463: end if;
464: end rosetta_table_copy_in_p8;
465: procedure rosetta_table_copy_out_p8(t lns_financials.payoff_tbl2, a0 out nocopy JTF_VARCHAR2_TABLE_100
466: , a1 out nocopy JTF_NUMBER_TABLE
467: , a2 out nocopy JTF_NUMBER_TABLE
468: , a3 out nocopy JTF_NUMBER_TABLE
469: ) as
470: ddindx binary_integer; indx binary_integer;
463: end if;
464: end rosetta_table_copy_in_p8;
465: procedure rosetta_table_copy_out_p8(t lns_financials.payoff_tbl2, a0 out nocopy JTF_VARCHAR2_TABLE_100
466: , a1 out nocopy JTF_NUMBER_TABLE
467: , a2 out nocopy JTF_NUMBER_TABLE
468: , a3 out nocopy JTF_NUMBER_TABLE
469: ) as
470: ddindx binary_integer; indx binary_integer;
471: begin
464: end rosetta_table_copy_in_p8;
465: procedure rosetta_table_copy_out_p8(t lns_financials.payoff_tbl2, a0 out nocopy JTF_VARCHAR2_TABLE_100
466: , a1 out nocopy JTF_NUMBER_TABLE
467: , a2 out nocopy JTF_NUMBER_TABLE
468: , a3 out nocopy JTF_NUMBER_TABLE
469: ) as
470: ddindx binary_integer; indx binary_integer;
471: begin
472: if t is null or t.count = 0 then
470: ddindx binary_integer; indx binary_integer;
471: begin
472: if t is null or t.count = 0 then
473: a0 := JTF_VARCHAR2_TABLE_100();
474: a1 := JTF_NUMBER_TABLE();
475: a2 := JTF_NUMBER_TABLE();
476: a3 := JTF_NUMBER_TABLE();
477: else
478: a0 := JTF_VARCHAR2_TABLE_100();
471: begin
472: if t is null or t.count = 0 then
473: a0 := JTF_VARCHAR2_TABLE_100();
474: a1 := JTF_NUMBER_TABLE();
475: a2 := JTF_NUMBER_TABLE();
476: a3 := JTF_NUMBER_TABLE();
477: else
478: a0 := JTF_VARCHAR2_TABLE_100();
479: a1 := JTF_NUMBER_TABLE();
472: if t is null or t.count = 0 then
473: a0 := JTF_VARCHAR2_TABLE_100();
474: a1 := JTF_NUMBER_TABLE();
475: a2 := JTF_NUMBER_TABLE();
476: a3 := JTF_NUMBER_TABLE();
477: else
478: a0 := JTF_VARCHAR2_TABLE_100();
479: a1 := JTF_NUMBER_TABLE();
480: a2 := JTF_NUMBER_TABLE();
475: a2 := JTF_NUMBER_TABLE();
476: a3 := JTF_NUMBER_TABLE();
477: else
478: a0 := JTF_VARCHAR2_TABLE_100();
479: a1 := JTF_NUMBER_TABLE();
480: a2 := JTF_NUMBER_TABLE();
481: a3 := JTF_NUMBER_TABLE();
482: if t.count > 0 then
483: a0.extend(t.count);
476: a3 := JTF_NUMBER_TABLE();
477: else
478: a0 := JTF_VARCHAR2_TABLE_100();
479: a1 := JTF_NUMBER_TABLE();
480: a2 := JTF_NUMBER_TABLE();
481: a3 := JTF_NUMBER_TABLE();
482: if t.count > 0 then
483: a0.extend(t.count);
484: a1.extend(t.count);
477: else
478: a0 := JTF_VARCHAR2_TABLE_100();
479: a1 := JTF_NUMBER_TABLE();
480: a2 := JTF_NUMBER_TABLE();
481: a3 := JTF_NUMBER_TABLE();
482: if t.count > 0 then
483: a0.extend(t.count);
484: a1.extend(t.count);
485: a2.extend(t.count);
501: end if;
502: end rosetta_table_copy_out_p8;
503:
504: procedure rosetta_table_copy_in_p10(t out nocopy lns_financials.loan_activity_tbl, a0 JTF_DATE_TABLE
505: , a1 JTF_NUMBER_TABLE
506: , a2 JTF_NUMBER_TABLE
507: , a3 JTF_NUMBER_TABLE
508: ) as
509: ddindx binary_integer; indx binary_integer;
502: end rosetta_table_copy_out_p8;
503:
504: procedure rosetta_table_copy_in_p10(t out nocopy lns_financials.loan_activity_tbl, a0 JTF_DATE_TABLE
505: , a1 JTF_NUMBER_TABLE
506: , a2 JTF_NUMBER_TABLE
507: , a3 JTF_NUMBER_TABLE
508: ) as
509: ddindx binary_integer; indx binary_integer;
510: begin
503:
504: procedure rosetta_table_copy_in_p10(t out nocopy lns_financials.loan_activity_tbl, a0 JTF_DATE_TABLE
505: , a1 JTF_NUMBER_TABLE
506: , a2 JTF_NUMBER_TABLE
507: , a3 JTF_NUMBER_TABLE
508: ) as
509: ddindx binary_integer; indx binary_integer;
510: begin
511: if a0 is not null and a0.count > 0 then
526: end if;
527: end if;
528: end rosetta_table_copy_in_p10;
529: procedure rosetta_table_copy_out_p10(t lns_financials.loan_activity_tbl, a0 out nocopy JTF_DATE_TABLE
530: , a1 out nocopy JTF_NUMBER_TABLE
531: , a2 out nocopy JTF_NUMBER_TABLE
532: , a3 out nocopy JTF_NUMBER_TABLE
533: ) as
534: ddindx binary_integer; indx binary_integer;
527: end if;
528: end rosetta_table_copy_in_p10;
529: procedure rosetta_table_copy_out_p10(t lns_financials.loan_activity_tbl, a0 out nocopy JTF_DATE_TABLE
530: , a1 out nocopy JTF_NUMBER_TABLE
531: , a2 out nocopy JTF_NUMBER_TABLE
532: , a3 out nocopy JTF_NUMBER_TABLE
533: ) as
534: ddindx binary_integer; indx binary_integer;
535: begin
528: end rosetta_table_copy_in_p10;
529: procedure rosetta_table_copy_out_p10(t lns_financials.loan_activity_tbl, a0 out nocopy JTF_DATE_TABLE
530: , a1 out nocopy JTF_NUMBER_TABLE
531: , a2 out nocopy JTF_NUMBER_TABLE
532: , a3 out nocopy JTF_NUMBER_TABLE
533: ) as
534: ddindx binary_integer; indx binary_integer;
535: begin
536: if t is null or t.count = 0 then
534: ddindx binary_integer; indx binary_integer;
535: begin
536: if t is null or t.count = 0 then
537: a0 := JTF_DATE_TABLE();
538: a1 := JTF_NUMBER_TABLE();
539: a2 := JTF_NUMBER_TABLE();
540: a3 := JTF_NUMBER_TABLE();
541: else
542: a0 := JTF_DATE_TABLE();
535: begin
536: if t is null or t.count = 0 then
537: a0 := JTF_DATE_TABLE();
538: a1 := JTF_NUMBER_TABLE();
539: a2 := JTF_NUMBER_TABLE();
540: a3 := JTF_NUMBER_TABLE();
541: else
542: a0 := JTF_DATE_TABLE();
543: a1 := JTF_NUMBER_TABLE();
536: if t is null or t.count = 0 then
537: a0 := JTF_DATE_TABLE();
538: a1 := JTF_NUMBER_TABLE();
539: a2 := JTF_NUMBER_TABLE();
540: a3 := JTF_NUMBER_TABLE();
541: else
542: a0 := JTF_DATE_TABLE();
543: a1 := JTF_NUMBER_TABLE();
544: a2 := JTF_NUMBER_TABLE();
539: a2 := JTF_NUMBER_TABLE();
540: a3 := JTF_NUMBER_TABLE();
541: else
542: a0 := JTF_DATE_TABLE();
543: a1 := JTF_NUMBER_TABLE();
544: a2 := JTF_NUMBER_TABLE();
545: a3 := JTF_NUMBER_TABLE();
546: if t.count > 0 then
547: a0.extend(t.count);
540: a3 := JTF_NUMBER_TABLE();
541: else
542: a0 := JTF_DATE_TABLE();
543: a1 := JTF_NUMBER_TABLE();
544: a2 := JTF_NUMBER_TABLE();
545: a3 := JTF_NUMBER_TABLE();
546: if t.count > 0 then
547: a0.extend(t.count);
548: a1.extend(t.count);
541: else
542: a0 := JTF_DATE_TABLE();
543: a1 := JTF_NUMBER_TABLE();
544: a2 := JTF_NUMBER_TABLE();
545: a3 := JTF_NUMBER_TABLE();
546: if t.count > 0 then
547: a0.extend(t.count);
548: a1.extend(t.count);
549: a2.extend(t.count);
655: end if;
656: end if;
657: end rosetta_table_copy_out_p13;
658:
659: procedure rosetta_table_copy_in_p14(t out nocopy lns_financials.amount_tbl, a0 JTF_NUMBER_TABLE) as
660: ddindx binary_integer; indx binary_integer;
661: begin
662: if a0 is not null and a0.count > 0 then
663: if a0.count > 0 then
673: end loop;
674: end if;
675: end if;
676: end rosetta_table_copy_in_p14;
677: procedure rosetta_table_copy_out_p14(t lns_financials.amount_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
678: ddindx binary_integer; indx binary_integer;
679: begin
680: if t is null or t.count = 0 then
681: a0 := JTF_NUMBER_TABLE();
677: procedure rosetta_table_copy_out_p14(t lns_financials.amount_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
678: ddindx binary_integer; indx binary_integer;
679: begin
680: if t is null or t.count = 0 then
681: a0 := JTF_NUMBER_TABLE();
682: else
683: a0 := JTF_NUMBER_TABLE();
684: if t.count > 0 then
685: a0.extend(t.count);
679: begin
680: if t is null or t.count = 0 then
681: a0 := JTF_NUMBER_TABLE();
682: else
683: a0 := JTF_NUMBER_TABLE();
684: if t.count > 0 then
685: a0.extend(t.count);
686: ddindx := t.first;
687: indx := 1;
737: end if;
738: end if;
739: end rosetta_table_copy_out_p15;
740:
741: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
742: , a1 JTF_VARCHAR2_TABLE_100
743: , a2 JTF_NUMBER_TABLE
744: , a3 JTF_NUMBER_TABLE
745: , a4 JTF_VARCHAR2_TABLE_300
739: end rosetta_table_copy_out_p15;
740:
741: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
742: , a1 JTF_VARCHAR2_TABLE_100
743: , a2 JTF_NUMBER_TABLE
744: , a3 JTF_NUMBER_TABLE
745: , a4 JTF_VARCHAR2_TABLE_300
746: , a5 JTF_NUMBER_TABLE
747: , a6 JTF_VARCHAR2_TABLE_100
740:
741: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
742: , a1 JTF_VARCHAR2_TABLE_100
743: , a2 JTF_NUMBER_TABLE
744: , a3 JTF_NUMBER_TABLE
745: , a4 JTF_VARCHAR2_TABLE_300
746: , a5 JTF_NUMBER_TABLE
747: , a6 JTF_VARCHAR2_TABLE_100
748: , a7 JTF_NUMBER_TABLE
742: , a1 JTF_VARCHAR2_TABLE_100
743: , a2 JTF_NUMBER_TABLE
744: , a3 JTF_NUMBER_TABLE
745: , a4 JTF_VARCHAR2_TABLE_300
746: , a5 JTF_NUMBER_TABLE
747: , a6 JTF_VARCHAR2_TABLE_100
748: , a7 JTF_NUMBER_TABLE
749: , a8 JTF_VARCHAR2_TABLE_100
750: , a9 JTF_VARCHAR2_TABLE_100
744: , a3 JTF_NUMBER_TABLE
745: , a4 JTF_VARCHAR2_TABLE_300
746: , a5 JTF_NUMBER_TABLE
747: , a6 JTF_VARCHAR2_TABLE_100
748: , a7 JTF_NUMBER_TABLE
749: , a8 JTF_VARCHAR2_TABLE_100
750: , a9 JTF_VARCHAR2_TABLE_100
751: ) as
752: ddindx binary_integer; indx binary_integer;
774: end loop;
775: end if;
776: end if;
777: end rosetta_table_copy_in_p17;
778: procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE
779: , a1 out nocopy JTF_VARCHAR2_TABLE_100
780: , a2 out nocopy JTF_NUMBER_TABLE
781: , a3 out nocopy JTF_NUMBER_TABLE
782: , a4 out nocopy JTF_VARCHAR2_TABLE_300
776: end if;
777: end rosetta_table_copy_in_p17;
778: procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE
779: , a1 out nocopy JTF_VARCHAR2_TABLE_100
780: , a2 out nocopy JTF_NUMBER_TABLE
781: , a3 out nocopy JTF_NUMBER_TABLE
782: , a4 out nocopy JTF_VARCHAR2_TABLE_300
783: , a5 out nocopy JTF_NUMBER_TABLE
784: , a6 out nocopy JTF_VARCHAR2_TABLE_100
777: end rosetta_table_copy_in_p17;
778: procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE
779: , a1 out nocopy JTF_VARCHAR2_TABLE_100
780: , a2 out nocopy JTF_NUMBER_TABLE
781: , a3 out nocopy JTF_NUMBER_TABLE
782: , a4 out nocopy JTF_VARCHAR2_TABLE_300
783: , a5 out nocopy JTF_NUMBER_TABLE
784: , a6 out nocopy JTF_VARCHAR2_TABLE_100
785: , a7 out nocopy JTF_NUMBER_TABLE
779: , a1 out nocopy JTF_VARCHAR2_TABLE_100
780: , a2 out nocopy JTF_NUMBER_TABLE
781: , a3 out nocopy JTF_NUMBER_TABLE
782: , a4 out nocopy JTF_VARCHAR2_TABLE_300
783: , a5 out nocopy JTF_NUMBER_TABLE
784: , a6 out nocopy JTF_VARCHAR2_TABLE_100
785: , a7 out nocopy JTF_NUMBER_TABLE
786: , a8 out nocopy JTF_VARCHAR2_TABLE_100
787: , a9 out nocopy JTF_VARCHAR2_TABLE_100
781: , a3 out nocopy JTF_NUMBER_TABLE
782: , a4 out nocopy JTF_VARCHAR2_TABLE_300
783: , a5 out nocopy JTF_NUMBER_TABLE
784: , a6 out nocopy JTF_VARCHAR2_TABLE_100
785: , a7 out nocopy JTF_NUMBER_TABLE
786: , a8 out nocopy JTF_VARCHAR2_TABLE_100
787: , a9 out nocopy JTF_VARCHAR2_TABLE_100
788: ) as
789: ddindx binary_integer; indx binary_integer;
788: ) as
789: ddindx binary_integer; indx binary_integer;
790: begin
791: if t is null or t.count = 0 then
792: a0 := JTF_NUMBER_TABLE();
793: a1 := JTF_VARCHAR2_TABLE_100();
794: a2 := JTF_NUMBER_TABLE();
795: a3 := JTF_NUMBER_TABLE();
796: a4 := JTF_VARCHAR2_TABLE_300();
790: begin
791: if t is null or t.count = 0 then
792: a0 := JTF_NUMBER_TABLE();
793: a1 := JTF_VARCHAR2_TABLE_100();
794: a2 := JTF_NUMBER_TABLE();
795: a3 := JTF_NUMBER_TABLE();
796: a4 := JTF_VARCHAR2_TABLE_300();
797: a5 := JTF_NUMBER_TABLE();
798: a6 := JTF_VARCHAR2_TABLE_100();
791: if t is null or t.count = 0 then
792: a0 := JTF_NUMBER_TABLE();
793: a1 := JTF_VARCHAR2_TABLE_100();
794: a2 := JTF_NUMBER_TABLE();
795: a3 := JTF_NUMBER_TABLE();
796: a4 := JTF_VARCHAR2_TABLE_300();
797: a5 := JTF_NUMBER_TABLE();
798: a6 := JTF_VARCHAR2_TABLE_100();
799: a7 := JTF_NUMBER_TABLE();
793: a1 := JTF_VARCHAR2_TABLE_100();
794: a2 := JTF_NUMBER_TABLE();
795: a3 := JTF_NUMBER_TABLE();
796: a4 := JTF_VARCHAR2_TABLE_300();
797: a5 := JTF_NUMBER_TABLE();
798: a6 := JTF_VARCHAR2_TABLE_100();
799: a7 := JTF_NUMBER_TABLE();
800: a8 := JTF_VARCHAR2_TABLE_100();
801: a9 := JTF_VARCHAR2_TABLE_100();
795: a3 := JTF_NUMBER_TABLE();
796: a4 := JTF_VARCHAR2_TABLE_300();
797: a5 := JTF_NUMBER_TABLE();
798: a6 := JTF_VARCHAR2_TABLE_100();
799: a7 := JTF_NUMBER_TABLE();
800: a8 := JTF_VARCHAR2_TABLE_100();
801: a9 := JTF_VARCHAR2_TABLE_100();
802: else
803: a0 := JTF_NUMBER_TABLE();
799: a7 := JTF_NUMBER_TABLE();
800: a8 := JTF_VARCHAR2_TABLE_100();
801: a9 := JTF_VARCHAR2_TABLE_100();
802: else
803: a0 := JTF_NUMBER_TABLE();
804: a1 := JTF_VARCHAR2_TABLE_100();
805: a2 := JTF_NUMBER_TABLE();
806: a3 := JTF_NUMBER_TABLE();
807: a4 := JTF_VARCHAR2_TABLE_300();
801: a9 := JTF_VARCHAR2_TABLE_100();
802: else
803: a0 := JTF_NUMBER_TABLE();
804: a1 := JTF_VARCHAR2_TABLE_100();
805: a2 := JTF_NUMBER_TABLE();
806: a3 := JTF_NUMBER_TABLE();
807: a4 := JTF_VARCHAR2_TABLE_300();
808: a5 := JTF_NUMBER_TABLE();
809: a6 := JTF_VARCHAR2_TABLE_100();
802: else
803: a0 := JTF_NUMBER_TABLE();
804: a1 := JTF_VARCHAR2_TABLE_100();
805: a2 := JTF_NUMBER_TABLE();
806: a3 := JTF_NUMBER_TABLE();
807: a4 := JTF_VARCHAR2_TABLE_300();
808: a5 := JTF_NUMBER_TABLE();
809: a6 := JTF_VARCHAR2_TABLE_100();
810: a7 := JTF_NUMBER_TABLE();
804: a1 := JTF_VARCHAR2_TABLE_100();
805: a2 := JTF_NUMBER_TABLE();
806: a3 := JTF_NUMBER_TABLE();
807: a4 := JTF_VARCHAR2_TABLE_300();
808: a5 := JTF_NUMBER_TABLE();
809: a6 := JTF_VARCHAR2_TABLE_100();
810: a7 := JTF_NUMBER_TABLE();
811: a8 := JTF_VARCHAR2_TABLE_100();
812: a9 := JTF_VARCHAR2_TABLE_100();
806: a3 := JTF_NUMBER_TABLE();
807: a4 := JTF_VARCHAR2_TABLE_300();
808: a5 := JTF_NUMBER_TABLE();
809: a6 := JTF_VARCHAR2_TABLE_100();
810: a7 := JTF_NUMBER_TABLE();
811: a8 := JTF_VARCHAR2_TABLE_100();
812: a9 := JTF_VARCHAR2_TABLE_100();
813: if t.count > 0 then
814: a0.extend(t.count);
1298: , p_init_msg_list VARCHAR2
1299: , p_loan_id NUMBER
1300: , p_payoff_date DATE
1301: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
1302: , p4_a1 out nocopy JTF_NUMBER_TABLE
1303: , p4_a2 out nocopy JTF_NUMBER_TABLE
1304: , p4_a3 out nocopy JTF_NUMBER_TABLE
1305: , x_return_status out nocopy VARCHAR2
1306: , x_msg_count out nocopy NUMBER
1299: , p_loan_id NUMBER
1300: , p_payoff_date DATE
1301: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
1302: , p4_a1 out nocopy JTF_NUMBER_TABLE
1303: , p4_a2 out nocopy JTF_NUMBER_TABLE
1304: , p4_a3 out nocopy JTF_NUMBER_TABLE
1305: , x_return_status out nocopy VARCHAR2
1306: , x_msg_count out nocopy NUMBER
1307: , x_msg_data out nocopy VARCHAR2
1300: , p_payoff_date DATE
1301: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
1302: , p4_a1 out nocopy JTF_NUMBER_TABLE
1303: , p4_a2 out nocopy JTF_NUMBER_TABLE
1304: , p4_a3 out nocopy JTF_NUMBER_TABLE
1305: , x_return_status out nocopy VARCHAR2
1306: , x_msg_count out nocopy NUMBER
1307: , x_msg_data out nocopy VARCHAR2
1308: )
1436: , p0_a87 NUMBER
1437: , p0_a88 NUMBER
1438: , p_start_date DATE
1439: , p_end_date DATE
1440: , p3_a0 JTF_NUMBER_TABLE
1441: , p3_a1 JTF_DATE_TABLE
1442: , p3_a2 JTF_DATE_TABLE
1443: , p3_a3 JTF_NUMBER_TABLE
1444: , p3_a4 JTF_NUMBER_TABLE
1439: , p_end_date DATE
1440: , p3_a0 JTF_NUMBER_TABLE
1441: , p3_a1 JTF_DATE_TABLE
1442: , p3_a2 JTF_DATE_TABLE
1443: , p3_a3 JTF_NUMBER_TABLE
1444: , p3_a4 JTF_NUMBER_TABLE
1445: , p3_a5 JTF_NUMBER_TABLE
1446: , p3_a6 JTF_NUMBER_TABLE
1447: , p3_a7 JTF_VARCHAR2_TABLE_100
1440: , p3_a0 JTF_NUMBER_TABLE
1441: , p3_a1 JTF_DATE_TABLE
1442: , p3_a2 JTF_DATE_TABLE
1443: , p3_a3 JTF_NUMBER_TABLE
1444: , p3_a4 JTF_NUMBER_TABLE
1445: , p3_a5 JTF_NUMBER_TABLE
1446: , p3_a6 JTF_NUMBER_TABLE
1447: , p3_a7 JTF_VARCHAR2_TABLE_100
1448: , p3_a8 JTF_VARCHAR2_TABLE_100
1441: , p3_a1 JTF_DATE_TABLE
1442: , p3_a2 JTF_DATE_TABLE
1443: , p3_a3 JTF_NUMBER_TABLE
1444: , p3_a4 JTF_NUMBER_TABLE
1445: , p3_a5 JTF_NUMBER_TABLE
1446: , p3_a6 JTF_NUMBER_TABLE
1447: , p3_a7 JTF_VARCHAR2_TABLE_100
1448: , p3_a8 JTF_VARCHAR2_TABLE_100
1449: , p3_a9 JTF_VARCHAR2_TABLE_100
1442: , p3_a2 JTF_DATE_TABLE
1443: , p3_a3 JTF_NUMBER_TABLE
1444: , p3_a4 JTF_NUMBER_TABLE
1445: , p3_a5 JTF_NUMBER_TABLE
1446: , p3_a6 JTF_NUMBER_TABLE
1447: , p3_a7 JTF_VARCHAR2_TABLE_100
1448: , p3_a8 JTF_VARCHAR2_TABLE_100
1449: , p3_a9 JTF_VARCHAR2_TABLE_100
1450: ) return number
1673: , p0_a85 NUMBER
1674: , p0_a86 NUMBER
1675: , p0_a87 NUMBER
1676: , p0_a88 NUMBER
1677: , p1_a0 JTF_NUMBER_TABLE
1678: , p1_a1 JTF_DATE_TABLE
1679: , p1_a2 JTF_DATE_TABLE
1680: , p1_a3 JTF_NUMBER_TABLE
1681: , p1_a4 JTF_NUMBER_TABLE
1676: , p0_a88 NUMBER
1677: , p1_a0 JTF_NUMBER_TABLE
1678: , p1_a1 JTF_DATE_TABLE
1679: , p1_a2 JTF_DATE_TABLE
1680: , p1_a3 JTF_NUMBER_TABLE
1681: , p1_a4 JTF_NUMBER_TABLE
1682: , p1_a5 JTF_NUMBER_TABLE
1683: , p1_a6 JTF_NUMBER_TABLE
1684: , p1_a7 JTF_VARCHAR2_TABLE_100
1677: , p1_a0 JTF_NUMBER_TABLE
1678: , p1_a1 JTF_DATE_TABLE
1679: , p1_a2 JTF_DATE_TABLE
1680: , p1_a3 JTF_NUMBER_TABLE
1681: , p1_a4 JTF_NUMBER_TABLE
1682: , p1_a5 JTF_NUMBER_TABLE
1683: , p1_a6 JTF_NUMBER_TABLE
1684: , p1_a7 JTF_VARCHAR2_TABLE_100
1685: , p1_a8 JTF_VARCHAR2_TABLE_100
1678: , p1_a1 JTF_DATE_TABLE
1679: , p1_a2 JTF_DATE_TABLE
1680: , p1_a3 JTF_NUMBER_TABLE
1681: , p1_a4 JTF_NUMBER_TABLE
1682: , p1_a5 JTF_NUMBER_TABLE
1683: , p1_a6 JTF_NUMBER_TABLE
1684: , p1_a7 JTF_VARCHAR2_TABLE_100
1685: , p1_a8 JTF_VARCHAR2_TABLE_100
1686: , p1_a9 JTF_VARCHAR2_TABLE_100
1679: , p1_a2 JTF_DATE_TABLE
1680: , p1_a3 JTF_NUMBER_TABLE
1681: , p1_a4 JTF_NUMBER_TABLE
1682: , p1_a5 JTF_NUMBER_TABLE
1683: , p1_a6 JTF_NUMBER_TABLE
1684: , p1_a7 JTF_VARCHAR2_TABLE_100
1685: , p1_a8 JTF_VARCHAR2_TABLE_100
1686: , p1_a9 JTF_VARCHAR2_TABLE_100
1687: , p_based_on_terms VARCHAR2
1685: , p1_a8 JTF_VARCHAR2_TABLE_100
1686: , p1_a9 JTF_VARCHAR2_TABLE_100
1687: , p_based_on_terms VARCHAR2
1688: , p_installment_number NUMBER
1689: , p4_a0 out nocopy JTF_NUMBER_TABLE
1690: , p4_a1 out nocopy JTF_DATE_TABLE
1691: , p4_a2 out nocopy JTF_DATE_TABLE
1692: , p4_a3 out nocopy JTF_DATE_TABLE
1693: , p4_a4 out nocopy JTF_NUMBER_TABLE
1689: , p4_a0 out nocopy JTF_NUMBER_TABLE
1690: , p4_a1 out nocopy JTF_DATE_TABLE
1691: , p4_a2 out nocopy JTF_DATE_TABLE
1692: , p4_a3 out nocopy JTF_DATE_TABLE
1693: , p4_a4 out nocopy JTF_NUMBER_TABLE
1694: , p4_a5 out nocopy JTF_NUMBER_TABLE
1695: , p4_a6 out nocopy JTF_NUMBER_TABLE
1696: , p4_a7 out nocopy JTF_NUMBER_TABLE
1697: , p4_a8 out nocopy JTF_NUMBER_TABLE
1690: , p4_a1 out nocopy JTF_DATE_TABLE
1691: , p4_a2 out nocopy JTF_DATE_TABLE
1692: , p4_a3 out nocopy JTF_DATE_TABLE
1693: , p4_a4 out nocopy JTF_NUMBER_TABLE
1694: , p4_a5 out nocopy JTF_NUMBER_TABLE
1695: , p4_a6 out nocopy JTF_NUMBER_TABLE
1696: , p4_a7 out nocopy JTF_NUMBER_TABLE
1697: , p4_a8 out nocopy JTF_NUMBER_TABLE
1698: , p4_a9 out nocopy JTF_NUMBER_TABLE
1691: , p4_a2 out nocopy JTF_DATE_TABLE
1692: , p4_a3 out nocopy JTF_DATE_TABLE
1693: , p4_a4 out nocopy JTF_NUMBER_TABLE
1694: , p4_a5 out nocopy JTF_NUMBER_TABLE
1695: , p4_a6 out nocopy JTF_NUMBER_TABLE
1696: , p4_a7 out nocopy JTF_NUMBER_TABLE
1697: , p4_a8 out nocopy JTF_NUMBER_TABLE
1698: , p4_a9 out nocopy JTF_NUMBER_TABLE
1699: , p4_a10 out nocopy JTF_NUMBER_TABLE
1692: , p4_a3 out nocopy JTF_DATE_TABLE
1693: , p4_a4 out nocopy JTF_NUMBER_TABLE
1694: , p4_a5 out nocopy JTF_NUMBER_TABLE
1695: , p4_a6 out nocopy JTF_NUMBER_TABLE
1696: , p4_a7 out nocopy JTF_NUMBER_TABLE
1697: , p4_a8 out nocopy JTF_NUMBER_TABLE
1698: , p4_a9 out nocopy JTF_NUMBER_TABLE
1699: , p4_a10 out nocopy JTF_NUMBER_TABLE
1700: , p4_a11 out nocopy JTF_NUMBER_TABLE
1693: , p4_a4 out nocopy JTF_NUMBER_TABLE
1694: , p4_a5 out nocopy JTF_NUMBER_TABLE
1695: , p4_a6 out nocopy JTF_NUMBER_TABLE
1696: , p4_a7 out nocopy JTF_NUMBER_TABLE
1697: , p4_a8 out nocopy JTF_NUMBER_TABLE
1698: , p4_a9 out nocopy JTF_NUMBER_TABLE
1699: , p4_a10 out nocopy JTF_NUMBER_TABLE
1700: , p4_a11 out nocopy JTF_NUMBER_TABLE
1701: , p4_a12 out nocopy JTF_NUMBER_TABLE
1694: , p4_a5 out nocopy JTF_NUMBER_TABLE
1695: , p4_a6 out nocopy JTF_NUMBER_TABLE
1696: , p4_a7 out nocopy JTF_NUMBER_TABLE
1697: , p4_a8 out nocopy JTF_NUMBER_TABLE
1698: , p4_a9 out nocopy JTF_NUMBER_TABLE
1699: , p4_a10 out nocopy JTF_NUMBER_TABLE
1700: , p4_a11 out nocopy JTF_NUMBER_TABLE
1701: , p4_a12 out nocopy JTF_NUMBER_TABLE
1702: , p4_a13 out nocopy JTF_NUMBER_TABLE
1695: , p4_a6 out nocopy JTF_NUMBER_TABLE
1696: , p4_a7 out nocopy JTF_NUMBER_TABLE
1697: , p4_a8 out nocopy JTF_NUMBER_TABLE
1698: , p4_a9 out nocopy JTF_NUMBER_TABLE
1699: , p4_a10 out nocopy JTF_NUMBER_TABLE
1700: , p4_a11 out nocopy JTF_NUMBER_TABLE
1701: , p4_a12 out nocopy JTF_NUMBER_TABLE
1702: , p4_a13 out nocopy JTF_NUMBER_TABLE
1703: , p4_a14 out nocopy JTF_NUMBER_TABLE
1696: , p4_a7 out nocopy JTF_NUMBER_TABLE
1697: , p4_a8 out nocopy JTF_NUMBER_TABLE
1698: , p4_a9 out nocopy JTF_NUMBER_TABLE
1699: , p4_a10 out nocopy JTF_NUMBER_TABLE
1700: , p4_a11 out nocopy JTF_NUMBER_TABLE
1701: , p4_a12 out nocopy JTF_NUMBER_TABLE
1702: , p4_a13 out nocopy JTF_NUMBER_TABLE
1703: , p4_a14 out nocopy JTF_NUMBER_TABLE
1704: , p4_a15 out nocopy JTF_NUMBER_TABLE
1697: , p4_a8 out nocopy JTF_NUMBER_TABLE
1698: , p4_a9 out nocopy JTF_NUMBER_TABLE
1699: , p4_a10 out nocopy JTF_NUMBER_TABLE
1700: , p4_a11 out nocopy JTF_NUMBER_TABLE
1701: , p4_a12 out nocopy JTF_NUMBER_TABLE
1702: , p4_a13 out nocopy JTF_NUMBER_TABLE
1703: , p4_a14 out nocopy JTF_NUMBER_TABLE
1704: , p4_a15 out nocopy JTF_NUMBER_TABLE
1705: , p4_a16 out nocopy JTF_NUMBER_TABLE
1698: , p4_a9 out nocopy JTF_NUMBER_TABLE
1699: , p4_a10 out nocopy JTF_NUMBER_TABLE
1700: , p4_a11 out nocopy JTF_NUMBER_TABLE
1701: , p4_a12 out nocopy JTF_NUMBER_TABLE
1702: , p4_a13 out nocopy JTF_NUMBER_TABLE
1703: , p4_a14 out nocopy JTF_NUMBER_TABLE
1704: , p4_a15 out nocopy JTF_NUMBER_TABLE
1705: , p4_a16 out nocopy JTF_NUMBER_TABLE
1706: , p4_a17 out nocopy JTF_NUMBER_TABLE
1699: , p4_a10 out nocopy JTF_NUMBER_TABLE
1700: , p4_a11 out nocopy JTF_NUMBER_TABLE
1701: , p4_a12 out nocopy JTF_NUMBER_TABLE
1702: , p4_a13 out nocopy JTF_NUMBER_TABLE
1703: , p4_a14 out nocopy JTF_NUMBER_TABLE
1704: , p4_a15 out nocopy JTF_NUMBER_TABLE
1705: , p4_a16 out nocopy JTF_NUMBER_TABLE
1706: , p4_a17 out nocopy JTF_NUMBER_TABLE
1707: , p4_a18 out nocopy JTF_NUMBER_TABLE
1700: , p4_a11 out nocopy JTF_NUMBER_TABLE
1701: , p4_a12 out nocopy JTF_NUMBER_TABLE
1702: , p4_a13 out nocopy JTF_NUMBER_TABLE
1703: , p4_a14 out nocopy JTF_NUMBER_TABLE
1704: , p4_a15 out nocopy JTF_NUMBER_TABLE
1705: , p4_a16 out nocopy JTF_NUMBER_TABLE
1706: , p4_a17 out nocopy JTF_NUMBER_TABLE
1707: , p4_a18 out nocopy JTF_NUMBER_TABLE
1708: , p4_a19 out nocopy JTF_NUMBER_TABLE
1701: , p4_a12 out nocopy JTF_NUMBER_TABLE
1702: , p4_a13 out nocopy JTF_NUMBER_TABLE
1703: , p4_a14 out nocopy JTF_NUMBER_TABLE
1704: , p4_a15 out nocopy JTF_NUMBER_TABLE
1705: , p4_a16 out nocopy JTF_NUMBER_TABLE
1706: , p4_a17 out nocopy JTF_NUMBER_TABLE
1707: , p4_a18 out nocopy JTF_NUMBER_TABLE
1708: , p4_a19 out nocopy JTF_NUMBER_TABLE
1709: , p4_a20 out nocopy JTF_NUMBER_TABLE
1702: , p4_a13 out nocopy JTF_NUMBER_TABLE
1703: , p4_a14 out nocopy JTF_NUMBER_TABLE
1704: , p4_a15 out nocopy JTF_NUMBER_TABLE
1705: , p4_a16 out nocopy JTF_NUMBER_TABLE
1706: , p4_a17 out nocopy JTF_NUMBER_TABLE
1707: , p4_a18 out nocopy JTF_NUMBER_TABLE
1708: , p4_a19 out nocopy JTF_NUMBER_TABLE
1709: , p4_a20 out nocopy JTF_NUMBER_TABLE
1710: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
1703: , p4_a14 out nocopy JTF_NUMBER_TABLE
1704: , p4_a15 out nocopy JTF_NUMBER_TABLE
1705: , p4_a16 out nocopy JTF_NUMBER_TABLE
1706: , p4_a17 out nocopy JTF_NUMBER_TABLE
1707: , p4_a18 out nocopy JTF_NUMBER_TABLE
1708: , p4_a19 out nocopy JTF_NUMBER_TABLE
1709: , p4_a20 out nocopy JTF_NUMBER_TABLE
1710: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
1711: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
1704: , p4_a15 out nocopy JTF_NUMBER_TABLE
1705: , p4_a16 out nocopy JTF_NUMBER_TABLE
1706: , p4_a17 out nocopy JTF_NUMBER_TABLE
1707: , p4_a18 out nocopy JTF_NUMBER_TABLE
1708: , p4_a19 out nocopy JTF_NUMBER_TABLE
1709: , p4_a20 out nocopy JTF_NUMBER_TABLE
1710: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
1711: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
1712: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
1705: , p4_a16 out nocopy JTF_NUMBER_TABLE
1706: , p4_a17 out nocopy JTF_NUMBER_TABLE
1707: , p4_a18 out nocopy JTF_NUMBER_TABLE
1708: , p4_a19 out nocopy JTF_NUMBER_TABLE
1709: , p4_a20 out nocopy JTF_NUMBER_TABLE
1710: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
1711: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
1712: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
1713: , p4_a24 out nocopy JTF_NUMBER_TABLE
1709: , p4_a20 out nocopy JTF_NUMBER_TABLE
1710: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
1711: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
1712: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
1713: , p4_a24 out nocopy JTF_NUMBER_TABLE
1714: , p4_a25 out nocopy JTF_NUMBER_TABLE
1715: , p4_a26 out nocopy JTF_NUMBER_TABLE
1716: )
1717:
1710: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
1711: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
1712: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
1713: , p4_a24 out nocopy JTF_NUMBER_TABLE
1714: , p4_a25 out nocopy JTF_NUMBER_TABLE
1715: , p4_a26 out nocopy JTF_NUMBER_TABLE
1716: )
1717:
1718: as
1711: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
1712: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
1713: , p4_a24 out nocopy JTF_NUMBER_TABLE
1714: , p4_a25 out nocopy JTF_NUMBER_TABLE
1715: , p4_a26 out nocopy JTF_NUMBER_TABLE
1716: )
1717:
1718: as
1719: ddp_loan_details lns_financials.loan_details_rec;
1968: , p0_a85 NUMBER
1969: , p0_a86 NUMBER
1970: , p0_a87 NUMBER
1971: , p0_a88 NUMBER
1972: , p1_a0 JTF_NUMBER_TABLE
1973: , p1_a1 JTF_DATE_TABLE
1974: , p1_a2 JTF_DATE_TABLE
1975: , p1_a3 JTF_NUMBER_TABLE
1976: , p1_a4 JTF_NUMBER_TABLE
1971: , p0_a88 NUMBER
1972: , p1_a0 JTF_NUMBER_TABLE
1973: , p1_a1 JTF_DATE_TABLE
1974: , p1_a2 JTF_DATE_TABLE
1975: , p1_a3 JTF_NUMBER_TABLE
1976: , p1_a4 JTF_NUMBER_TABLE
1977: , p1_a5 JTF_NUMBER_TABLE
1978: , p1_a6 JTF_NUMBER_TABLE
1979: , p1_a7 JTF_VARCHAR2_TABLE_100
1972: , p1_a0 JTF_NUMBER_TABLE
1973: , p1_a1 JTF_DATE_TABLE
1974: , p1_a2 JTF_DATE_TABLE
1975: , p1_a3 JTF_NUMBER_TABLE
1976: , p1_a4 JTF_NUMBER_TABLE
1977: , p1_a5 JTF_NUMBER_TABLE
1978: , p1_a6 JTF_NUMBER_TABLE
1979: , p1_a7 JTF_VARCHAR2_TABLE_100
1980: , p1_a8 JTF_VARCHAR2_TABLE_100
1973: , p1_a1 JTF_DATE_TABLE
1974: , p1_a2 JTF_DATE_TABLE
1975: , p1_a3 JTF_NUMBER_TABLE
1976: , p1_a4 JTF_NUMBER_TABLE
1977: , p1_a5 JTF_NUMBER_TABLE
1978: , p1_a6 JTF_NUMBER_TABLE
1979: , p1_a7 JTF_VARCHAR2_TABLE_100
1980: , p1_a8 JTF_VARCHAR2_TABLE_100
1981: , p1_a9 JTF_VARCHAR2_TABLE_100
1974: , p1_a2 JTF_DATE_TABLE
1975: , p1_a3 JTF_NUMBER_TABLE
1976: , p1_a4 JTF_NUMBER_TABLE
1977: , p1_a5 JTF_NUMBER_TABLE
1978: , p1_a6 JTF_NUMBER_TABLE
1979: , p1_a7 JTF_VARCHAR2_TABLE_100
1980: , p1_a8 JTF_VARCHAR2_TABLE_100
1981: , p1_a9 JTF_VARCHAR2_TABLE_100
1982: , p_based_on_terms VARCHAR2
1980: , p1_a8 JTF_VARCHAR2_TABLE_100
1981: , p1_a9 JTF_VARCHAR2_TABLE_100
1982: , p_based_on_terms VARCHAR2
1983: , p_installment_number NUMBER
1984: , p4_a0 out nocopy JTF_NUMBER_TABLE
1985: , p4_a1 out nocopy JTF_DATE_TABLE
1986: , p4_a2 out nocopy JTF_DATE_TABLE
1987: , p4_a3 out nocopy JTF_DATE_TABLE
1988: , p4_a4 out nocopy JTF_NUMBER_TABLE
1984: , p4_a0 out nocopy JTF_NUMBER_TABLE
1985: , p4_a1 out nocopy JTF_DATE_TABLE
1986: , p4_a2 out nocopy JTF_DATE_TABLE
1987: , p4_a3 out nocopy JTF_DATE_TABLE
1988: , p4_a4 out nocopy JTF_NUMBER_TABLE
1989: , p4_a5 out nocopy JTF_NUMBER_TABLE
1990: , p4_a6 out nocopy JTF_NUMBER_TABLE
1991: , p4_a7 out nocopy JTF_NUMBER_TABLE
1992: , p4_a8 out nocopy JTF_NUMBER_TABLE
1985: , p4_a1 out nocopy JTF_DATE_TABLE
1986: , p4_a2 out nocopy JTF_DATE_TABLE
1987: , p4_a3 out nocopy JTF_DATE_TABLE
1988: , p4_a4 out nocopy JTF_NUMBER_TABLE
1989: , p4_a5 out nocopy JTF_NUMBER_TABLE
1990: , p4_a6 out nocopy JTF_NUMBER_TABLE
1991: , p4_a7 out nocopy JTF_NUMBER_TABLE
1992: , p4_a8 out nocopy JTF_NUMBER_TABLE
1993: , p4_a9 out nocopy JTF_NUMBER_TABLE
1986: , p4_a2 out nocopy JTF_DATE_TABLE
1987: , p4_a3 out nocopy JTF_DATE_TABLE
1988: , p4_a4 out nocopy JTF_NUMBER_TABLE
1989: , p4_a5 out nocopy JTF_NUMBER_TABLE
1990: , p4_a6 out nocopy JTF_NUMBER_TABLE
1991: , p4_a7 out nocopy JTF_NUMBER_TABLE
1992: , p4_a8 out nocopy JTF_NUMBER_TABLE
1993: , p4_a9 out nocopy JTF_NUMBER_TABLE
1994: , p4_a10 out nocopy JTF_NUMBER_TABLE
1987: , p4_a3 out nocopy JTF_DATE_TABLE
1988: , p4_a4 out nocopy JTF_NUMBER_TABLE
1989: , p4_a5 out nocopy JTF_NUMBER_TABLE
1990: , p4_a6 out nocopy JTF_NUMBER_TABLE
1991: , p4_a7 out nocopy JTF_NUMBER_TABLE
1992: , p4_a8 out nocopy JTF_NUMBER_TABLE
1993: , p4_a9 out nocopy JTF_NUMBER_TABLE
1994: , p4_a10 out nocopy JTF_NUMBER_TABLE
1995: , p4_a11 out nocopy JTF_NUMBER_TABLE
1988: , p4_a4 out nocopy JTF_NUMBER_TABLE
1989: , p4_a5 out nocopy JTF_NUMBER_TABLE
1990: , p4_a6 out nocopy JTF_NUMBER_TABLE
1991: , p4_a7 out nocopy JTF_NUMBER_TABLE
1992: , p4_a8 out nocopy JTF_NUMBER_TABLE
1993: , p4_a9 out nocopy JTF_NUMBER_TABLE
1994: , p4_a10 out nocopy JTF_NUMBER_TABLE
1995: , p4_a11 out nocopy JTF_NUMBER_TABLE
1996: , p4_a12 out nocopy JTF_NUMBER_TABLE
1989: , p4_a5 out nocopy JTF_NUMBER_TABLE
1990: , p4_a6 out nocopy JTF_NUMBER_TABLE
1991: , p4_a7 out nocopy JTF_NUMBER_TABLE
1992: , p4_a8 out nocopy JTF_NUMBER_TABLE
1993: , p4_a9 out nocopy JTF_NUMBER_TABLE
1994: , p4_a10 out nocopy JTF_NUMBER_TABLE
1995: , p4_a11 out nocopy JTF_NUMBER_TABLE
1996: , p4_a12 out nocopy JTF_NUMBER_TABLE
1997: , p4_a13 out nocopy JTF_NUMBER_TABLE
1990: , p4_a6 out nocopy JTF_NUMBER_TABLE
1991: , p4_a7 out nocopy JTF_NUMBER_TABLE
1992: , p4_a8 out nocopy JTF_NUMBER_TABLE
1993: , p4_a9 out nocopy JTF_NUMBER_TABLE
1994: , p4_a10 out nocopy JTF_NUMBER_TABLE
1995: , p4_a11 out nocopy JTF_NUMBER_TABLE
1996: , p4_a12 out nocopy JTF_NUMBER_TABLE
1997: , p4_a13 out nocopy JTF_NUMBER_TABLE
1998: , p4_a14 out nocopy JTF_NUMBER_TABLE
1991: , p4_a7 out nocopy JTF_NUMBER_TABLE
1992: , p4_a8 out nocopy JTF_NUMBER_TABLE
1993: , p4_a9 out nocopy JTF_NUMBER_TABLE
1994: , p4_a10 out nocopy JTF_NUMBER_TABLE
1995: , p4_a11 out nocopy JTF_NUMBER_TABLE
1996: , p4_a12 out nocopy JTF_NUMBER_TABLE
1997: , p4_a13 out nocopy JTF_NUMBER_TABLE
1998: , p4_a14 out nocopy JTF_NUMBER_TABLE
1999: , p4_a15 out nocopy JTF_NUMBER_TABLE
1992: , p4_a8 out nocopy JTF_NUMBER_TABLE
1993: , p4_a9 out nocopy JTF_NUMBER_TABLE
1994: , p4_a10 out nocopy JTF_NUMBER_TABLE
1995: , p4_a11 out nocopy JTF_NUMBER_TABLE
1996: , p4_a12 out nocopy JTF_NUMBER_TABLE
1997: , p4_a13 out nocopy JTF_NUMBER_TABLE
1998: , p4_a14 out nocopy JTF_NUMBER_TABLE
1999: , p4_a15 out nocopy JTF_NUMBER_TABLE
2000: , p4_a16 out nocopy JTF_NUMBER_TABLE
1993: , p4_a9 out nocopy JTF_NUMBER_TABLE
1994: , p4_a10 out nocopy JTF_NUMBER_TABLE
1995: , p4_a11 out nocopy JTF_NUMBER_TABLE
1996: , p4_a12 out nocopy JTF_NUMBER_TABLE
1997: , p4_a13 out nocopy JTF_NUMBER_TABLE
1998: , p4_a14 out nocopy JTF_NUMBER_TABLE
1999: , p4_a15 out nocopy JTF_NUMBER_TABLE
2000: , p4_a16 out nocopy JTF_NUMBER_TABLE
2001: , p4_a17 out nocopy JTF_NUMBER_TABLE
1994: , p4_a10 out nocopy JTF_NUMBER_TABLE
1995: , p4_a11 out nocopy JTF_NUMBER_TABLE
1996: , p4_a12 out nocopy JTF_NUMBER_TABLE
1997: , p4_a13 out nocopy JTF_NUMBER_TABLE
1998: , p4_a14 out nocopy JTF_NUMBER_TABLE
1999: , p4_a15 out nocopy JTF_NUMBER_TABLE
2000: , p4_a16 out nocopy JTF_NUMBER_TABLE
2001: , p4_a17 out nocopy JTF_NUMBER_TABLE
2002: , p4_a18 out nocopy JTF_NUMBER_TABLE
1995: , p4_a11 out nocopy JTF_NUMBER_TABLE
1996: , p4_a12 out nocopy JTF_NUMBER_TABLE
1997: , p4_a13 out nocopy JTF_NUMBER_TABLE
1998: , p4_a14 out nocopy JTF_NUMBER_TABLE
1999: , p4_a15 out nocopy JTF_NUMBER_TABLE
2000: , p4_a16 out nocopy JTF_NUMBER_TABLE
2001: , p4_a17 out nocopy JTF_NUMBER_TABLE
2002: , p4_a18 out nocopy JTF_NUMBER_TABLE
2003: , p4_a19 out nocopy JTF_NUMBER_TABLE
1996: , p4_a12 out nocopy JTF_NUMBER_TABLE
1997: , p4_a13 out nocopy JTF_NUMBER_TABLE
1998: , p4_a14 out nocopy JTF_NUMBER_TABLE
1999: , p4_a15 out nocopy JTF_NUMBER_TABLE
2000: , p4_a16 out nocopy JTF_NUMBER_TABLE
2001: , p4_a17 out nocopy JTF_NUMBER_TABLE
2002: , p4_a18 out nocopy JTF_NUMBER_TABLE
2003: , p4_a19 out nocopy JTF_NUMBER_TABLE
2004: , p4_a20 out nocopy JTF_NUMBER_TABLE
1997: , p4_a13 out nocopy JTF_NUMBER_TABLE
1998: , p4_a14 out nocopy JTF_NUMBER_TABLE
1999: , p4_a15 out nocopy JTF_NUMBER_TABLE
2000: , p4_a16 out nocopy JTF_NUMBER_TABLE
2001: , p4_a17 out nocopy JTF_NUMBER_TABLE
2002: , p4_a18 out nocopy JTF_NUMBER_TABLE
2003: , p4_a19 out nocopy JTF_NUMBER_TABLE
2004: , p4_a20 out nocopy JTF_NUMBER_TABLE
2005: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
1998: , p4_a14 out nocopy JTF_NUMBER_TABLE
1999: , p4_a15 out nocopy JTF_NUMBER_TABLE
2000: , p4_a16 out nocopy JTF_NUMBER_TABLE
2001: , p4_a17 out nocopy JTF_NUMBER_TABLE
2002: , p4_a18 out nocopy JTF_NUMBER_TABLE
2003: , p4_a19 out nocopy JTF_NUMBER_TABLE
2004: , p4_a20 out nocopy JTF_NUMBER_TABLE
2005: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
2006: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
1999: , p4_a15 out nocopy JTF_NUMBER_TABLE
2000: , p4_a16 out nocopy JTF_NUMBER_TABLE
2001: , p4_a17 out nocopy JTF_NUMBER_TABLE
2002: , p4_a18 out nocopy JTF_NUMBER_TABLE
2003: , p4_a19 out nocopy JTF_NUMBER_TABLE
2004: , p4_a20 out nocopy JTF_NUMBER_TABLE
2005: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
2006: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
2007: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
2000: , p4_a16 out nocopy JTF_NUMBER_TABLE
2001: , p4_a17 out nocopy JTF_NUMBER_TABLE
2002: , p4_a18 out nocopy JTF_NUMBER_TABLE
2003: , p4_a19 out nocopy JTF_NUMBER_TABLE
2004: , p4_a20 out nocopy JTF_NUMBER_TABLE
2005: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
2006: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
2007: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
2008: , p4_a24 out nocopy JTF_NUMBER_TABLE
2004: , p4_a20 out nocopy JTF_NUMBER_TABLE
2005: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
2006: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
2007: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
2008: , p4_a24 out nocopy JTF_NUMBER_TABLE
2009: , p4_a25 out nocopy JTF_NUMBER_TABLE
2010: , p4_a26 out nocopy JTF_NUMBER_TABLE
2011: )
2012:
2005: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
2006: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
2007: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
2008: , p4_a24 out nocopy JTF_NUMBER_TABLE
2009: , p4_a25 out nocopy JTF_NUMBER_TABLE
2010: , p4_a26 out nocopy JTF_NUMBER_TABLE
2011: )
2012:
2013: as
2006: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
2007: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
2008: , p4_a24 out nocopy JTF_NUMBER_TABLE
2009: , p4_a25 out nocopy JTF_NUMBER_TABLE
2010: , p4_a26 out nocopy JTF_NUMBER_TABLE
2011: )
2012:
2013: as
2014: ddp_loan_details lns_financials.loan_details_rec;
2177:
2178: procedure amortizeloan(p_loan_id NUMBER
2179: , p_based_on_terms VARCHAR2
2180: , p_installment_number NUMBER
2181: , p3_a0 out nocopy JTF_NUMBER_TABLE
2182: , p3_a1 out nocopy JTF_DATE_TABLE
2183: , p3_a2 out nocopy JTF_DATE_TABLE
2184: , p3_a3 out nocopy JTF_DATE_TABLE
2185: , p3_a4 out nocopy JTF_NUMBER_TABLE
2181: , p3_a0 out nocopy JTF_NUMBER_TABLE
2182: , p3_a1 out nocopy JTF_DATE_TABLE
2183: , p3_a2 out nocopy JTF_DATE_TABLE
2184: , p3_a3 out nocopy JTF_DATE_TABLE
2185: , p3_a4 out nocopy JTF_NUMBER_TABLE
2186: , p3_a5 out nocopy JTF_NUMBER_TABLE
2187: , p3_a6 out nocopy JTF_NUMBER_TABLE
2188: , p3_a7 out nocopy JTF_NUMBER_TABLE
2189: , p3_a8 out nocopy JTF_NUMBER_TABLE
2182: , p3_a1 out nocopy JTF_DATE_TABLE
2183: , p3_a2 out nocopy JTF_DATE_TABLE
2184: , p3_a3 out nocopy JTF_DATE_TABLE
2185: , p3_a4 out nocopy JTF_NUMBER_TABLE
2186: , p3_a5 out nocopy JTF_NUMBER_TABLE
2187: , p3_a6 out nocopy JTF_NUMBER_TABLE
2188: , p3_a7 out nocopy JTF_NUMBER_TABLE
2189: , p3_a8 out nocopy JTF_NUMBER_TABLE
2190: , p3_a9 out nocopy JTF_NUMBER_TABLE
2183: , p3_a2 out nocopy JTF_DATE_TABLE
2184: , p3_a3 out nocopy JTF_DATE_TABLE
2185: , p3_a4 out nocopy JTF_NUMBER_TABLE
2186: , p3_a5 out nocopy JTF_NUMBER_TABLE
2187: , p3_a6 out nocopy JTF_NUMBER_TABLE
2188: , p3_a7 out nocopy JTF_NUMBER_TABLE
2189: , p3_a8 out nocopy JTF_NUMBER_TABLE
2190: , p3_a9 out nocopy JTF_NUMBER_TABLE
2191: , p3_a10 out nocopy JTF_NUMBER_TABLE
2184: , p3_a3 out nocopy JTF_DATE_TABLE
2185: , p3_a4 out nocopy JTF_NUMBER_TABLE
2186: , p3_a5 out nocopy JTF_NUMBER_TABLE
2187: , p3_a6 out nocopy JTF_NUMBER_TABLE
2188: , p3_a7 out nocopy JTF_NUMBER_TABLE
2189: , p3_a8 out nocopy JTF_NUMBER_TABLE
2190: , p3_a9 out nocopy JTF_NUMBER_TABLE
2191: , p3_a10 out nocopy JTF_NUMBER_TABLE
2192: , p3_a11 out nocopy JTF_NUMBER_TABLE
2185: , p3_a4 out nocopy JTF_NUMBER_TABLE
2186: , p3_a5 out nocopy JTF_NUMBER_TABLE
2187: , p3_a6 out nocopy JTF_NUMBER_TABLE
2188: , p3_a7 out nocopy JTF_NUMBER_TABLE
2189: , p3_a8 out nocopy JTF_NUMBER_TABLE
2190: , p3_a9 out nocopy JTF_NUMBER_TABLE
2191: , p3_a10 out nocopy JTF_NUMBER_TABLE
2192: , p3_a11 out nocopy JTF_NUMBER_TABLE
2193: , p3_a12 out nocopy JTF_NUMBER_TABLE
2186: , p3_a5 out nocopy JTF_NUMBER_TABLE
2187: , p3_a6 out nocopy JTF_NUMBER_TABLE
2188: , p3_a7 out nocopy JTF_NUMBER_TABLE
2189: , p3_a8 out nocopy JTF_NUMBER_TABLE
2190: , p3_a9 out nocopy JTF_NUMBER_TABLE
2191: , p3_a10 out nocopy JTF_NUMBER_TABLE
2192: , p3_a11 out nocopy JTF_NUMBER_TABLE
2193: , p3_a12 out nocopy JTF_NUMBER_TABLE
2194: , p3_a13 out nocopy JTF_NUMBER_TABLE
2187: , p3_a6 out nocopy JTF_NUMBER_TABLE
2188: , p3_a7 out nocopy JTF_NUMBER_TABLE
2189: , p3_a8 out nocopy JTF_NUMBER_TABLE
2190: , p3_a9 out nocopy JTF_NUMBER_TABLE
2191: , p3_a10 out nocopy JTF_NUMBER_TABLE
2192: , p3_a11 out nocopy JTF_NUMBER_TABLE
2193: , p3_a12 out nocopy JTF_NUMBER_TABLE
2194: , p3_a13 out nocopy JTF_NUMBER_TABLE
2195: , p3_a14 out nocopy JTF_NUMBER_TABLE
2188: , p3_a7 out nocopy JTF_NUMBER_TABLE
2189: , p3_a8 out nocopy JTF_NUMBER_TABLE
2190: , p3_a9 out nocopy JTF_NUMBER_TABLE
2191: , p3_a10 out nocopy JTF_NUMBER_TABLE
2192: , p3_a11 out nocopy JTF_NUMBER_TABLE
2193: , p3_a12 out nocopy JTF_NUMBER_TABLE
2194: , p3_a13 out nocopy JTF_NUMBER_TABLE
2195: , p3_a14 out nocopy JTF_NUMBER_TABLE
2196: , p3_a15 out nocopy JTF_NUMBER_TABLE
2189: , p3_a8 out nocopy JTF_NUMBER_TABLE
2190: , p3_a9 out nocopy JTF_NUMBER_TABLE
2191: , p3_a10 out nocopy JTF_NUMBER_TABLE
2192: , p3_a11 out nocopy JTF_NUMBER_TABLE
2193: , p3_a12 out nocopy JTF_NUMBER_TABLE
2194: , p3_a13 out nocopy JTF_NUMBER_TABLE
2195: , p3_a14 out nocopy JTF_NUMBER_TABLE
2196: , p3_a15 out nocopy JTF_NUMBER_TABLE
2197: , p3_a16 out nocopy JTF_NUMBER_TABLE
2190: , p3_a9 out nocopy JTF_NUMBER_TABLE
2191: , p3_a10 out nocopy JTF_NUMBER_TABLE
2192: , p3_a11 out nocopy JTF_NUMBER_TABLE
2193: , p3_a12 out nocopy JTF_NUMBER_TABLE
2194: , p3_a13 out nocopy JTF_NUMBER_TABLE
2195: , p3_a14 out nocopy JTF_NUMBER_TABLE
2196: , p3_a15 out nocopy JTF_NUMBER_TABLE
2197: , p3_a16 out nocopy JTF_NUMBER_TABLE
2198: , p3_a17 out nocopy JTF_NUMBER_TABLE
2191: , p3_a10 out nocopy JTF_NUMBER_TABLE
2192: , p3_a11 out nocopy JTF_NUMBER_TABLE
2193: , p3_a12 out nocopy JTF_NUMBER_TABLE
2194: , p3_a13 out nocopy JTF_NUMBER_TABLE
2195: , p3_a14 out nocopy JTF_NUMBER_TABLE
2196: , p3_a15 out nocopy JTF_NUMBER_TABLE
2197: , p3_a16 out nocopy JTF_NUMBER_TABLE
2198: , p3_a17 out nocopy JTF_NUMBER_TABLE
2199: , p3_a18 out nocopy JTF_NUMBER_TABLE
2192: , p3_a11 out nocopy JTF_NUMBER_TABLE
2193: , p3_a12 out nocopy JTF_NUMBER_TABLE
2194: , p3_a13 out nocopy JTF_NUMBER_TABLE
2195: , p3_a14 out nocopy JTF_NUMBER_TABLE
2196: , p3_a15 out nocopy JTF_NUMBER_TABLE
2197: , p3_a16 out nocopy JTF_NUMBER_TABLE
2198: , p3_a17 out nocopy JTF_NUMBER_TABLE
2199: , p3_a18 out nocopy JTF_NUMBER_TABLE
2200: , p3_a19 out nocopy JTF_NUMBER_TABLE
2193: , p3_a12 out nocopy JTF_NUMBER_TABLE
2194: , p3_a13 out nocopy JTF_NUMBER_TABLE
2195: , p3_a14 out nocopy JTF_NUMBER_TABLE
2196: , p3_a15 out nocopy JTF_NUMBER_TABLE
2197: , p3_a16 out nocopy JTF_NUMBER_TABLE
2198: , p3_a17 out nocopy JTF_NUMBER_TABLE
2199: , p3_a18 out nocopy JTF_NUMBER_TABLE
2200: , p3_a19 out nocopy JTF_NUMBER_TABLE
2201: , p3_a20 out nocopy JTF_NUMBER_TABLE
2194: , p3_a13 out nocopy JTF_NUMBER_TABLE
2195: , p3_a14 out nocopy JTF_NUMBER_TABLE
2196: , p3_a15 out nocopy JTF_NUMBER_TABLE
2197: , p3_a16 out nocopy JTF_NUMBER_TABLE
2198: , p3_a17 out nocopy JTF_NUMBER_TABLE
2199: , p3_a18 out nocopy JTF_NUMBER_TABLE
2200: , p3_a19 out nocopy JTF_NUMBER_TABLE
2201: , p3_a20 out nocopy JTF_NUMBER_TABLE
2202: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2195: , p3_a14 out nocopy JTF_NUMBER_TABLE
2196: , p3_a15 out nocopy JTF_NUMBER_TABLE
2197: , p3_a16 out nocopy JTF_NUMBER_TABLE
2198: , p3_a17 out nocopy JTF_NUMBER_TABLE
2199: , p3_a18 out nocopy JTF_NUMBER_TABLE
2200: , p3_a19 out nocopy JTF_NUMBER_TABLE
2201: , p3_a20 out nocopy JTF_NUMBER_TABLE
2202: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2203: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2196: , p3_a15 out nocopy JTF_NUMBER_TABLE
2197: , p3_a16 out nocopy JTF_NUMBER_TABLE
2198: , p3_a17 out nocopy JTF_NUMBER_TABLE
2199: , p3_a18 out nocopy JTF_NUMBER_TABLE
2200: , p3_a19 out nocopy JTF_NUMBER_TABLE
2201: , p3_a20 out nocopy JTF_NUMBER_TABLE
2202: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2203: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2204: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2197: , p3_a16 out nocopy JTF_NUMBER_TABLE
2198: , p3_a17 out nocopy JTF_NUMBER_TABLE
2199: , p3_a18 out nocopy JTF_NUMBER_TABLE
2200: , p3_a19 out nocopy JTF_NUMBER_TABLE
2201: , p3_a20 out nocopy JTF_NUMBER_TABLE
2202: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2203: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2204: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2205: , p3_a24 out nocopy JTF_NUMBER_TABLE
2201: , p3_a20 out nocopy JTF_NUMBER_TABLE
2202: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2203: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2204: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2205: , p3_a24 out nocopy JTF_NUMBER_TABLE
2206: , p3_a25 out nocopy JTF_NUMBER_TABLE
2207: , p3_a26 out nocopy JTF_NUMBER_TABLE
2208: )
2209:
2202: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2203: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2204: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2205: , p3_a24 out nocopy JTF_NUMBER_TABLE
2206: , p3_a25 out nocopy JTF_NUMBER_TABLE
2207: , p3_a26 out nocopy JTF_NUMBER_TABLE
2208: )
2209:
2210: as
2203: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2204: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2205: , p3_a24 out nocopy JTF_NUMBER_TABLE
2206: , p3_a25 out nocopy JTF_NUMBER_TABLE
2207: , p3_a26 out nocopy JTF_NUMBER_TABLE
2208: )
2209:
2210: as
2211: ddx_loan_amort_tbl lns_financials.amortization_tbl;
2345: , p0_a85 NUMBER
2346: , p0_a86 NUMBER
2347: , p0_a87 NUMBER
2348: , p0_a88 NUMBER
2349: , p1_a0 JTF_NUMBER_TABLE
2350: , p1_a1 JTF_DATE_TABLE
2351: , p1_a2 JTF_DATE_TABLE
2352: , p1_a3 JTF_NUMBER_TABLE
2353: , p1_a4 JTF_NUMBER_TABLE
2348: , p0_a88 NUMBER
2349: , p1_a0 JTF_NUMBER_TABLE
2350: , p1_a1 JTF_DATE_TABLE
2351: , p1_a2 JTF_DATE_TABLE
2352: , p1_a3 JTF_NUMBER_TABLE
2353: , p1_a4 JTF_NUMBER_TABLE
2354: , p1_a5 JTF_NUMBER_TABLE
2355: , p1_a6 JTF_NUMBER_TABLE
2356: , p1_a7 JTF_VARCHAR2_TABLE_100
2349: , p1_a0 JTF_NUMBER_TABLE
2350: , p1_a1 JTF_DATE_TABLE
2351: , p1_a2 JTF_DATE_TABLE
2352: , p1_a3 JTF_NUMBER_TABLE
2353: , p1_a4 JTF_NUMBER_TABLE
2354: , p1_a5 JTF_NUMBER_TABLE
2355: , p1_a6 JTF_NUMBER_TABLE
2356: , p1_a7 JTF_VARCHAR2_TABLE_100
2357: , p1_a8 JTF_VARCHAR2_TABLE_100
2350: , p1_a1 JTF_DATE_TABLE
2351: , p1_a2 JTF_DATE_TABLE
2352: , p1_a3 JTF_NUMBER_TABLE
2353: , p1_a4 JTF_NUMBER_TABLE
2354: , p1_a5 JTF_NUMBER_TABLE
2355: , p1_a6 JTF_NUMBER_TABLE
2356: , p1_a7 JTF_VARCHAR2_TABLE_100
2357: , p1_a8 JTF_VARCHAR2_TABLE_100
2358: , p1_a9 JTF_VARCHAR2_TABLE_100
2351: , p1_a2 JTF_DATE_TABLE
2352: , p1_a3 JTF_NUMBER_TABLE
2353: , p1_a4 JTF_NUMBER_TABLE
2354: , p1_a5 JTF_NUMBER_TABLE
2355: , p1_a6 JTF_NUMBER_TABLE
2356: , p1_a7 JTF_VARCHAR2_TABLE_100
2357: , p1_a8 JTF_VARCHAR2_TABLE_100
2358: , p1_a9 JTF_VARCHAR2_TABLE_100
2359: , p2_a0 out nocopy JTF_NUMBER_TABLE
2355: , p1_a6 JTF_NUMBER_TABLE
2356: , p1_a7 JTF_VARCHAR2_TABLE_100
2357: , p1_a8 JTF_VARCHAR2_TABLE_100
2358: , p1_a9 JTF_VARCHAR2_TABLE_100
2359: , p2_a0 out nocopy JTF_NUMBER_TABLE
2360: , p2_a1 out nocopy JTF_DATE_TABLE
2361: , p2_a2 out nocopy JTF_DATE_TABLE
2362: , p2_a3 out nocopy JTF_DATE_TABLE
2363: , p2_a4 out nocopy JTF_NUMBER_TABLE
2359: , p2_a0 out nocopy JTF_NUMBER_TABLE
2360: , p2_a1 out nocopy JTF_DATE_TABLE
2361: , p2_a2 out nocopy JTF_DATE_TABLE
2362: , p2_a3 out nocopy JTF_DATE_TABLE
2363: , p2_a4 out nocopy JTF_NUMBER_TABLE
2364: , p2_a5 out nocopy JTF_NUMBER_TABLE
2365: , p2_a6 out nocopy JTF_NUMBER_TABLE
2366: , p2_a7 out nocopy JTF_NUMBER_TABLE
2367: , p2_a8 out nocopy JTF_NUMBER_TABLE
2360: , p2_a1 out nocopy JTF_DATE_TABLE
2361: , p2_a2 out nocopy JTF_DATE_TABLE
2362: , p2_a3 out nocopy JTF_DATE_TABLE
2363: , p2_a4 out nocopy JTF_NUMBER_TABLE
2364: , p2_a5 out nocopy JTF_NUMBER_TABLE
2365: , p2_a6 out nocopy JTF_NUMBER_TABLE
2366: , p2_a7 out nocopy JTF_NUMBER_TABLE
2367: , p2_a8 out nocopy JTF_NUMBER_TABLE
2368: , p2_a9 out nocopy JTF_NUMBER_TABLE
2361: , p2_a2 out nocopy JTF_DATE_TABLE
2362: , p2_a3 out nocopy JTF_DATE_TABLE
2363: , p2_a4 out nocopy JTF_NUMBER_TABLE
2364: , p2_a5 out nocopy JTF_NUMBER_TABLE
2365: , p2_a6 out nocopy JTF_NUMBER_TABLE
2366: , p2_a7 out nocopy JTF_NUMBER_TABLE
2367: , p2_a8 out nocopy JTF_NUMBER_TABLE
2368: , p2_a9 out nocopy JTF_NUMBER_TABLE
2369: , p2_a10 out nocopy JTF_NUMBER_TABLE
2362: , p2_a3 out nocopy JTF_DATE_TABLE
2363: , p2_a4 out nocopy JTF_NUMBER_TABLE
2364: , p2_a5 out nocopy JTF_NUMBER_TABLE
2365: , p2_a6 out nocopy JTF_NUMBER_TABLE
2366: , p2_a7 out nocopy JTF_NUMBER_TABLE
2367: , p2_a8 out nocopy JTF_NUMBER_TABLE
2368: , p2_a9 out nocopy JTF_NUMBER_TABLE
2369: , p2_a10 out nocopy JTF_NUMBER_TABLE
2370: , p2_a11 out nocopy JTF_NUMBER_TABLE
2363: , p2_a4 out nocopy JTF_NUMBER_TABLE
2364: , p2_a5 out nocopy JTF_NUMBER_TABLE
2365: , p2_a6 out nocopy JTF_NUMBER_TABLE
2366: , p2_a7 out nocopy JTF_NUMBER_TABLE
2367: , p2_a8 out nocopy JTF_NUMBER_TABLE
2368: , p2_a9 out nocopy JTF_NUMBER_TABLE
2369: , p2_a10 out nocopy JTF_NUMBER_TABLE
2370: , p2_a11 out nocopy JTF_NUMBER_TABLE
2371: , p2_a12 out nocopy JTF_NUMBER_TABLE
2364: , p2_a5 out nocopy JTF_NUMBER_TABLE
2365: , p2_a6 out nocopy JTF_NUMBER_TABLE
2366: , p2_a7 out nocopy JTF_NUMBER_TABLE
2367: , p2_a8 out nocopy JTF_NUMBER_TABLE
2368: , p2_a9 out nocopy JTF_NUMBER_TABLE
2369: , p2_a10 out nocopy JTF_NUMBER_TABLE
2370: , p2_a11 out nocopy JTF_NUMBER_TABLE
2371: , p2_a12 out nocopy JTF_NUMBER_TABLE
2372: , p2_a13 out nocopy JTF_NUMBER_TABLE
2365: , p2_a6 out nocopy JTF_NUMBER_TABLE
2366: , p2_a7 out nocopy JTF_NUMBER_TABLE
2367: , p2_a8 out nocopy JTF_NUMBER_TABLE
2368: , p2_a9 out nocopy JTF_NUMBER_TABLE
2369: , p2_a10 out nocopy JTF_NUMBER_TABLE
2370: , p2_a11 out nocopy JTF_NUMBER_TABLE
2371: , p2_a12 out nocopy JTF_NUMBER_TABLE
2372: , p2_a13 out nocopy JTF_NUMBER_TABLE
2373: , p2_a14 out nocopy JTF_NUMBER_TABLE
2366: , p2_a7 out nocopy JTF_NUMBER_TABLE
2367: , p2_a8 out nocopy JTF_NUMBER_TABLE
2368: , p2_a9 out nocopy JTF_NUMBER_TABLE
2369: , p2_a10 out nocopy JTF_NUMBER_TABLE
2370: , p2_a11 out nocopy JTF_NUMBER_TABLE
2371: , p2_a12 out nocopy JTF_NUMBER_TABLE
2372: , p2_a13 out nocopy JTF_NUMBER_TABLE
2373: , p2_a14 out nocopy JTF_NUMBER_TABLE
2374: , p2_a15 out nocopy JTF_NUMBER_TABLE
2367: , p2_a8 out nocopy JTF_NUMBER_TABLE
2368: , p2_a9 out nocopy JTF_NUMBER_TABLE
2369: , p2_a10 out nocopy JTF_NUMBER_TABLE
2370: , p2_a11 out nocopy JTF_NUMBER_TABLE
2371: , p2_a12 out nocopy JTF_NUMBER_TABLE
2372: , p2_a13 out nocopy JTF_NUMBER_TABLE
2373: , p2_a14 out nocopy JTF_NUMBER_TABLE
2374: , p2_a15 out nocopy JTF_NUMBER_TABLE
2375: , p2_a16 out nocopy JTF_NUMBER_TABLE
2368: , p2_a9 out nocopy JTF_NUMBER_TABLE
2369: , p2_a10 out nocopy JTF_NUMBER_TABLE
2370: , p2_a11 out nocopy JTF_NUMBER_TABLE
2371: , p2_a12 out nocopy JTF_NUMBER_TABLE
2372: , p2_a13 out nocopy JTF_NUMBER_TABLE
2373: , p2_a14 out nocopy JTF_NUMBER_TABLE
2374: , p2_a15 out nocopy JTF_NUMBER_TABLE
2375: , p2_a16 out nocopy JTF_NUMBER_TABLE
2376: , p2_a17 out nocopy JTF_NUMBER_TABLE
2369: , p2_a10 out nocopy JTF_NUMBER_TABLE
2370: , p2_a11 out nocopy JTF_NUMBER_TABLE
2371: , p2_a12 out nocopy JTF_NUMBER_TABLE
2372: , p2_a13 out nocopy JTF_NUMBER_TABLE
2373: , p2_a14 out nocopy JTF_NUMBER_TABLE
2374: , p2_a15 out nocopy JTF_NUMBER_TABLE
2375: , p2_a16 out nocopy JTF_NUMBER_TABLE
2376: , p2_a17 out nocopy JTF_NUMBER_TABLE
2377: , p2_a18 out nocopy JTF_NUMBER_TABLE
2370: , p2_a11 out nocopy JTF_NUMBER_TABLE
2371: , p2_a12 out nocopy JTF_NUMBER_TABLE
2372: , p2_a13 out nocopy JTF_NUMBER_TABLE
2373: , p2_a14 out nocopy JTF_NUMBER_TABLE
2374: , p2_a15 out nocopy JTF_NUMBER_TABLE
2375: , p2_a16 out nocopy JTF_NUMBER_TABLE
2376: , p2_a17 out nocopy JTF_NUMBER_TABLE
2377: , p2_a18 out nocopy JTF_NUMBER_TABLE
2378: , p2_a19 out nocopy JTF_NUMBER_TABLE
2371: , p2_a12 out nocopy JTF_NUMBER_TABLE
2372: , p2_a13 out nocopy JTF_NUMBER_TABLE
2373: , p2_a14 out nocopy JTF_NUMBER_TABLE
2374: , p2_a15 out nocopy JTF_NUMBER_TABLE
2375: , p2_a16 out nocopy JTF_NUMBER_TABLE
2376: , p2_a17 out nocopy JTF_NUMBER_TABLE
2377: , p2_a18 out nocopy JTF_NUMBER_TABLE
2378: , p2_a19 out nocopy JTF_NUMBER_TABLE
2379: , p2_a20 out nocopy JTF_NUMBER_TABLE
2372: , p2_a13 out nocopy JTF_NUMBER_TABLE
2373: , p2_a14 out nocopy JTF_NUMBER_TABLE
2374: , p2_a15 out nocopy JTF_NUMBER_TABLE
2375: , p2_a16 out nocopy JTF_NUMBER_TABLE
2376: , p2_a17 out nocopy JTF_NUMBER_TABLE
2377: , p2_a18 out nocopy JTF_NUMBER_TABLE
2378: , p2_a19 out nocopy JTF_NUMBER_TABLE
2379: , p2_a20 out nocopy JTF_NUMBER_TABLE
2380: , p2_a21 out nocopy JTF_VARCHAR2_TABLE_100
2373: , p2_a14 out nocopy JTF_NUMBER_TABLE
2374: , p2_a15 out nocopy JTF_NUMBER_TABLE
2375: , p2_a16 out nocopy JTF_NUMBER_TABLE
2376: , p2_a17 out nocopy JTF_NUMBER_TABLE
2377: , p2_a18 out nocopy JTF_NUMBER_TABLE
2378: , p2_a19 out nocopy JTF_NUMBER_TABLE
2379: , p2_a20 out nocopy JTF_NUMBER_TABLE
2380: , p2_a21 out nocopy JTF_VARCHAR2_TABLE_100
2381: , p2_a22 out nocopy JTF_VARCHAR2_TABLE_100
2374: , p2_a15 out nocopy JTF_NUMBER_TABLE
2375: , p2_a16 out nocopy JTF_NUMBER_TABLE
2376: , p2_a17 out nocopy JTF_NUMBER_TABLE
2377: , p2_a18 out nocopy JTF_NUMBER_TABLE
2378: , p2_a19 out nocopy JTF_NUMBER_TABLE
2379: , p2_a20 out nocopy JTF_NUMBER_TABLE
2380: , p2_a21 out nocopy JTF_VARCHAR2_TABLE_100
2381: , p2_a22 out nocopy JTF_VARCHAR2_TABLE_100
2382: , p2_a23 out nocopy JTF_VARCHAR2_TABLE_100
2375: , p2_a16 out nocopy JTF_NUMBER_TABLE
2376: , p2_a17 out nocopy JTF_NUMBER_TABLE
2377: , p2_a18 out nocopy JTF_NUMBER_TABLE
2378: , p2_a19 out nocopy JTF_NUMBER_TABLE
2379: , p2_a20 out nocopy JTF_NUMBER_TABLE
2380: , p2_a21 out nocopy JTF_VARCHAR2_TABLE_100
2381: , p2_a22 out nocopy JTF_VARCHAR2_TABLE_100
2382: , p2_a23 out nocopy JTF_VARCHAR2_TABLE_100
2383: , p2_a24 out nocopy JTF_NUMBER_TABLE
2379: , p2_a20 out nocopy JTF_NUMBER_TABLE
2380: , p2_a21 out nocopy JTF_VARCHAR2_TABLE_100
2381: , p2_a22 out nocopy JTF_VARCHAR2_TABLE_100
2382: , p2_a23 out nocopy JTF_VARCHAR2_TABLE_100
2383: , p2_a24 out nocopy JTF_NUMBER_TABLE
2384: , p2_a25 out nocopy JTF_NUMBER_TABLE
2385: , p2_a26 out nocopy JTF_NUMBER_TABLE
2386: )
2387:
2380: , p2_a21 out nocopy JTF_VARCHAR2_TABLE_100
2381: , p2_a22 out nocopy JTF_VARCHAR2_TABLE_100
2382: , p2_a23 out nocopy JTF_VARCHAR2_TABLE_100
2383: , p2_a24 out nocopy JTF_NUMBER_TABLE
2384: , p2_a25 out nocopy JTF_NUMBER_TABLE
2385: , p2_a26 out nocopy JTF_NUMBER_TABLE
2386: )
2387:
2388: as
2381: , p2_a22 out nocopy JTF_VARCHAR2_TABLE_100
2382: , p2_a23 out nocopy JTF_VARCHAR2_TABLE_100
2383: , p2_a24 out nocopy JTF_NUMBER_TABLE
2384: , p2_a25 out nocopy JTF_NUMBER_TABLE
2385: , p2_a26 out nocopy JTF_NUMBER_TABLE
2386: )
2387:
2388: as
2389: ddp_loan_details lns_financials.loan_details_rec;
2546:
2547: procedure runopenprojection(p_init_msg_list VARCHAR2
2548: , p_loan_id NUMBER
2549: , p_based_on_terms VARCHAR2
2550: , p3_a0 out nocopy JTF_NUMBER_TABLE
2551: , p3_a1 out nocopy JTF_DATE_TABLE
2552: , p3_a2 out nocopy JTF_DATE_TABLE
2553: , p3_a3 out nocopy JTF_DATE_TABLE
2554: , p3_a4 out nocopy JTF_NUMBER_TABLE
2550: , p3_a0 out nocopy JTF_NUMBER_TABLE
2551: , p3_a1 out nocopy JTF_DATE_TABLE
2552: , p3_a2 out nocopy JTF_DATE_TABLE
2553: , p3_a3 out nocopy JTF_DATE_TABLE
2554: , p3_a4 out nocopy JTF_NUMBER_TABLE
2555: , p3_a5 out nocopy JTF_NUMBER_TABLE
2556: , p3_a6 out nocopy JTF_NUMBER_TABLE
2557: , p3_a7 out nocopy JTF_NUMBER_TABLE
2558: , p3_a8 out nocopy JTF_NUMBER_TABLE
2551: , p3_a1 out nocopy JTF_DATE_TABLE
2552: , p3_a2 out nocopy JTF_DATE_TABLE
2553: , p3_a3 out nocopy JTF_DATE_TABLE
2554: , p3_a4 out nocopy JTF_NUMBER_TABLE
2555: , p3_a5 out nocopy JTF_NUMBER_TABLE
2556: , p3_a6 out nocopy JTF_NUMBER_TABLE
2557: , p3_a7 out nocopy JTF_NUMBER_TABLE
2558: , p3_a8 out nocopy JTF_NUMBER_TABLE
2559: , p3_a9 out nocopy JTF_NUMBER_TABLE
2552: , p3_a2 out nocopy JTF_DATE_TABLE
2553: , p3_a3 out nocopy JTF_DATE_TABLE
2554: , p3_a4 out nocopy JTF_NUMBER_TABLE
2555: , p3_a5 out nocopy JTF_NUMBER_TABLE
2556: , p3_a6 out nocopy JTF_NUMBER_TABLE
2557: , p3_a7 out nocopy JTF_NUMBER_TABLE
2558: , p3_a8 out nocopy JTF_NUMBER_TABLE
2559: , p3_a9 out nocopy JTF_NUMBER_TABLE
2560: , p3_a10 out nocopy JTF_NUMBER_TABLE
2553: , p3_a3 out nocopy JTF_DATE_TABLE
2554: , p3_a4 out nocopy JTF_NUMBER_TABLE
2555: , p3_a5 out nocopy JTF_NUMBER_TABLE
2556: , p3_a6 out nocopy JTF_NUMBER_TABLE
2557: , p3_a7 out nocopy JTF_NUMBER_TABLE
2558: , p3_a8 out nocopy JTF_NUMBER_TABLE
2559: , p3_a9 out nocopy JTF_NUMBER_TABLE
2560: , p3_a10 out nocopy JTF_NUMBER_TABLE
2561: , p3_a11 out nocopy JTF_NUMBER_TABLE
2554: , p3_a4 out nocopy JTF_NUMBER_TABLE
2555: , p3_a5 out nocopy JTF_NUMBER_TABLE
2556: , p3_a6 out nocopy JTF_NUMBER_TABLE
2557: , p3_a7 out nocopy JTF_NUMBER_TABLE
2558: , p3_a8 out nocopy JTF_NUMBER_TABLE
2559: , p3_a9 out nocopy JTF_NUMBER_TABLE
2560: , p3_a10 out nocopy JTF_NUMBER_TABLE
2561: , p3_a11 out nocopy JTF_NUMBER_TABLE
2562: , p3_a12 out nocopy JTF_NUMBER_TABLE
2555: , p3_a5 out nocopy JTF_NUMBER_TABLE
2556: , p3_a6 out nocopy JTF_NUMBER_TABLE
2557: , p3_a7 out nocopy JTF_NUMBER_TABLE
2558: , p3_a8 out nocopy JTF_NUMBER_TABLE
2559: , p3_a9 out nocopy JTF_NUMBER_TABLE
2560: , p3_a10 out nocopy JTF_NUMBER_TABLE
2561: , p3_a11 out nocopy JTF_NUMBER_TABLE
2562: , p3_a12 out nocopy JTF_NUMBER_TABLE
2563: , p3_a13 out nocopy JTF_NUMBER_TABLE
2556: , p3_a6 out nocopy JTF_NUMBER_TABLE
2557: , p3_a7 out nocopy JTF_NUMBER_TABLE
2558: , p3_a8 out nocopy JTF_NUMBER_TABLE
2559: , p3_a9 out nocopy JTF_NUMBER_TABLE
2560: , p3_a10 out nocopy JTF_NUMBER_TABLE
2561: , p3_a11 out nocopy JTF_NUMBER_TABLE
2562: , p3_a12 out nocopy JTF_NUMBER_TABLE
2563: , p3_a13 out nocopy JTF_NUMBER_TABLE
2564: , p3_a14 out nocopy JTF_NUMBER_TABLE
2557: , p3_a7 out nocopy JTF_NUMBER_TABLE
2558: , p3_a8 out nocopy JTF_NUMBER_TABLE
2559: , p3_a9 out nocopy JTF_NUMBER_TABLE
2560: , p3_a10 out nocopy JTF_NUMBER_TABLE
2561: , p3_a11 out nocopy JTF_NUMBER_TABLE
2562: , p3_a12 out nocopy JTF_NUMBER_TABLE
2563: , p3_a13 out nocopy JTF_NUMBER_TABLE
2564: , p3_a14 out nocopy JTF_NUMBER_TABLE
2565: , p3_a15 out nocopy JTF_NUMBER_TABLE
2558: , p3_a8 out nocopy JTF_NUMBER_TABLE
2559: , p3_a9 out nocopy JTF_NUMBER_TABLE
2560: , p3_a10 out nocopy JTF_NUMBER_TABLE
2561: , p3_a11 out nocopy JTF_NUMBER_TABLE
2562: , p3_a12 out nocopy JTF_NUMBER_TABLE
2563: , p3_a13 out nocopy JTF_NUMBER_TABLE
2564: , p3_a14 out nocopy JTF_NUMBER_TABLE
2565: , p3_a15 out nocopy JTF_NUMBER_TABLE
2566: , p3_a16 out nocopy JTF_NUMBER_TABLE
2559: , p3_a9 out nocopy JTF_NUMBER_TABLE
2560: , p3_a10 out nocopy JTF_NUMBER_TABLE
2561: , p3_a11 out nocopy JTF_NUMBER_TABLE
2562: , p3_a12 out nocopy JTF_NUMBER_TABLE
2563: , p3_a13 out nocopy JTF_NUMBER_TABLE
2564: , p3_a14 out nocopy JTF_NUMBER_TABLE
2565: , p3_a15 out nocopy JTF_NUMBER_TABLE
2566: , p3_a16 out nocopy JTF_NUMBER_TABLE
2567: , p3_a17 out nocopy JTF_NUMBER_TABLE
2560: , p3_a10 out nocopy JTF_NUMBER_TABLE
2561: , p3_a11 out nocopy JTF_NUMBER_TABLE
2562: , p3_a12 out nocopy JTF_NUMBER_TABLE
2563: , p3_a13 out nocopy JTF_NUMBER_TABLE
2564: , p3_a14 out nocopy JTF_NUMBER_TABLE
2565: , p3_a15 out nocopy JTF_NUMBER_TABLE
2566: , p3_a16 out nocopy JTF_NUMBER_TABLE
2567: , p3_a17 out nocopy JTF_NUMBER_TABLE
2568: , p3_a18 out nocopy JTF_NUMBER_TABLE
2561: , p3_a11 out nocopy JTF_NUMBER_TABLE
2562: , p3_a12 out nocopy JTF_NUMBER_TABLE
2563: , p3_a13 out nocopy JTF_NUMBER_TABLE
2564: , p3_a14 out nocopy JTF_NUMBER_TABLE
2565: , p3_a15 out nocopy JTF_NUMBER_TABLE
2566: , p3_a16 out nocopy JTF_NUMBER_TABLE
2567: , p3_a17 out nocopy JTF_NUMBER_TABLE
2568: , p3_a18 out nocopy JTF_NUMBER_TABLE
2569: , p3_a19 out nocopy JTF_NUMBER_TABLE
2562: , p3_a12 out nocopy JTF_NUMBER_TABLE
2563: , p3_a13 out nocopy JTF_NUMBER_TABLE
2564: , p3_a14 out nocopy JTF_NUMBER_TABLE
2565: , p3_a15 out nocopy JTF_NUMBER_TABLE
2566: , p3_a16 out nocopy JTF_NUMBER_TABLE
2567: , p3_a17 out nocopy JTF_NUMBER_TABLE
2568: , p3_a18 out nocopy JTF_NUMBER_TABLE
2569: , p3_a19 out nocopy JTF_NUMBER_TABLE
2570: , p3_a20 out nocopy JTF_NUMBER_TABLE
2563: , p3_a13 out nocopy JTF_NUMBER_TABLE
2564: , p3_a14 out nocopy JTF_NUMBER_TABLE
2565: , p3_a15 out nocopy JTF_NUMBER_TABLE
2566: , p3_a16 out nocopy JTF_NUMBER_TABLE
2567: , p3_a17 out nocopy JTF_NUMBER_TABLE
2568: , p3_a18 out nocopy JTF_NUMBER_TABLE
2569: , p3_a19 out nocopy JTF_NUMBER_TABLE
2570: , p3_a20 out nocopy JTF_NUMBER_TABLE
2571: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2564: , p3_a14 out nocopy JTF_NUMBER_TABLE
2565: , p3_a15 out nocopy JTF_NUMBER_TABLE
2566: , p3_a16 out nocopy JTF_NUMBER_TABLE
2567: , p3_a17 out nocopy JTF_NUMBER_TABLE
2568: , p3_a18 out nocopy JTF_NUMBER_TABLE
2569: , p3_a19 out nocopy JTF_NUMBER_TABLE
2570: , p3_a20 out nocopy JTF_NUMBER_TABLE
2571: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2572: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2565: , p3_a15 out nocopy JTF_NUMBER_TABLE
2566: , p3_a16 out nocopy JTF_NUMBER_TABLE
2567: , p3_a17 out nocopy JTF_NUMBER_TABLE
2568: , p3_a18 out nocopy JTF_NUMBER_TABLE
2569: , p3_a19 out nocopy JTF_NUMBER_TABLE
2570: , p3_a20 out nocopy JTF_NUMBER_TABLE
2571: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2572: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2573: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2566: , p3_a16 out nocopy JTF_NUMBER_TABLE
2567: , p3_a17 out nocopy JTF_NUMBER_TABLE
2568: , p3_a18 out nocopy JTF_NUMBER_TABLE
2569: , p3_a19 out nocopy JTF_NUMBER_TABLE
2570: , p3_a20 out nocopy JTF_NUMBER_TABLE
2571: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2572: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2573: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2574: , p3_a24 out nocopy JTF_NUMBER_TABLE
2570: , p3_a20 out nocopy JTF_NUMBER_TABLE
2571: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2572: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2573: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2574: , p3_a24 out nocopy JTF_NUMBER_TABLE
2575: , p3_a25 out nocopy JTF_NUMBER_TABLE
2576: , p3_a26 out nocopy JTF_NUMBER_TABLE
2577: , x_return_status out nocopy VARCHAR2
2578: , x_msg_count out nocopy NUMBER
2571: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
2572: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2573: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2574: , p3_a24 out nocopy JTF_NUMBER_TABLE
2575: , p3_a25 out nocopy JTF_NUMBER_TABLE
2576: , p3_a26 out nocopy JTF_NUMBER_TABLE
2577: , x_return_status out nocopy VARCHAR2
2578: , x_msg_count out nocopy NUMBER
2579: , x_msg_data out nocopy VARCHAR2
2572: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
2573: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
2574: , p3_a24 out nocopy JTF_NUMBER_TABLE
2575: , p3_a25 out nocopy JTF_NUMBER_TABLE
2576: , p3_a26 out nocopy JTF_NUMBER_TABLE
2577: , x_return_status out nocopy VARCHAR2
2578: , x_msg_count out nocopy NUMBER
2579: , x_msg_data out nocopy VARCHAR2
2580: )
2642: , p_init_msg_list VARCHAR2
2643: , p_commit VARCHAR2
2644: , p_loan_id NUMBER
2645: , p_based_on_terms VARCHAR2
2646: , p5_a0 out nocopy JTF_NUMBER_TABLE
2647: , p5_a1 out nocopy JTF_DATE_TABLE
2648: , p5_a2 out nocopy JTF_DATE_TABLE
2649: , p5_a3 out nocopy JTF_DATE_TABLE
2650: , p5_a4 out nocopy JTF_NUMBER_TABLE
2646: , p5_a0 out nocopy JTF_NUMBER_TABLE
2647: , p5_a1 out nocopy JTF_DATE_TABLE
2648: , p5_a2 out nocopy JTF_DATE_TABLE
2649: , p5_a3 out nocopy JTF_DATE_TABLE
2650: , p5_a4 out nocopy JTF_NUMBER_TABLE
2651: , p5_a5 out nocopy JTF_NUMBER_TABLE
2652: , p5_a6 out nocopy JTF_NUMBER_TABLE
2653: , p5_a7 out nocopy JTF_NUMBER_TABLE
2654: , p5_a8 out nocopy JTF_NUMBER_TABLE
2647: , p5_a1 out nocopy JTF_DATE_TABLE
2648: , p5_a2 out nocopy JTF_DATE_TABLE
2649: , p5_a3 out nocopy JTF_DATE_TABLE
2650: , p5_a4 out nocopy JTF_NUMBER_TABLE
2651: , p5_a5 out nocopy JTF_NUMBER_TABLE
2652: , p5_a6 out nocopy JTF_NUMBER_TABLE
2653: , p5_a7 out nocopy JTF_NUMBER_TABLE
2654: , p5_a8 out nocopy JTF_NUMBER_TABLE
2655: , p5_a9 out nocopy JTF_NUMBER_TABLE
2648: , p5_a2 out nocopy JTF_DATE_TABLE
2649: , p5_a3 out nocopy JTF_DATE_TABLE
2650: , p5_a4 out nocopy JTF_NUMBER_TABLE
2651: , p5_a5 out nocopy JTF_NUMBER_TABLE
2652: , p5_a6 out nocopy JTF_NUMBER_TABLE
2653: , p5_a7 out nocopy JTF_NUMBER_TABLE
2654: , p5_a8 out nocopy JTF_NUMBER_TABLE
2655: , p5_a9 out nocopy JTF_NUMBER_TABLE
2656: , p5_a10 out nocopy JTF_NUMBER_TABLE
2649: , p5_a3 out nocopy JTF_DATE_TABLE
2650: , p5_a4 out nocopy JTF_NUMBER_TABLE
2651: , p5_a5 out nocopy JTF_NUMBER_TABLE
2652: , p5_a6 out nocopy JTF_NUMBER_TABLE
2653: , p5_a7 out nocopy JTF_NUMBER_TABLE
2654: , p5_a8 out nocopy JTF_NUMBER_TABLE
2655: , p5_a9 out nocopy JTF_NUMBER_TABLE
2656: , p5_a10 out nocopy JTF_NUMBER_TABLE
2657: , p5_a11 out nocopy JTF_NUMBER_TABLE
2650: , p5_a4 out nocopy JTF_NUMBER_TABLE
2651: , p5_a5 out nocopy JTF_NUMBER_TABLE
2652: , p5_a6 out nocopy JTF_NUMBER_TABLE
2653: , p5_a7 out nocopy JTF_NUMBER_TABLE
2654: , p5_a8 out nocopy JTF_NUMBER_TABLE
2655: , p5_a9 out nocopy JTF_NUMBER_TABLE
2656: , p5_a10 out nocopy JTF_NUMBER_TABLE
2657: , p5_a11 out nocopy JTF_NUMBER_TABLE
2658: , p5_a12 out nocopy JTF_NUMBER_TABLE
2651: , p5_a5 out nocopy JTF_NUMBER_TABLE
2652: , p5_a6 out nocopy JTF_NUMBER_TABLE
2653: , p5_a7 out nocopy JTF_NUMBER_TABLE
2654: , p5_a8 out nocopy JTF_NUMBER_TABLE
2655: , p5_a9 out nocopy JTF_NUMBER_TABLE
2656: , p5_a10 out nocopy JTF_NUMBER_TABLE
2657: , p5_a11 out nocopy JTF_NUMBER_TABLE
2658: , p5_a12 out nocopy JTF_NUMBER_TABLE
2659: , p5_a13 out nocopy JTF_NUMBER_TABLE
2652: , p5_a6 out nocopy JTF_NUMBER_TABLE
2653: , p5_a7 out nocopy JTF_NUMBER_TABLE
2654: , p5_a8 out nocopy JTF_NUMBER_TABLE
2655: , p5_a9 out nocopy JTF_NUMBER_TABLE
2656: , p5_a10 out nocopy JTF_NUMBER_TABLE
2657: , p5_a11 out nocopy JTF_NUMBER_TABLE
2658: , p5_a12 out nocopy JTF_NUMBER_TABLE
2659: , p5_a13 out nocopy JTF_NUMBER_TABLE
2660: , p5_a14 out nocopy JTF_NUMBER_TABLE
2653: , p5_a7 out nocopy JTF_NUMBER_TABLE
2654: , p5_a8 out nocopy JTF_NUMBER_TABLE
2655: , p5_a9 out nocopy JTF_NUMBER_TABLE
2656: , p5_a10 out nocopy JTF_NUMBER_TABLE
2657: , p5_a11 out nocopy JTF_NUMBER_TABLE
2658: , p5_a12 out nocopy JTF_NUMBER_TABLE
2659: , p5_a13 out nocopy JTF_NUMBER_TABLE
2660: , p5_a14 out nocopy JTF_NUMBER_TABLE
2661: , p5_a15 out nocopy JTF_NUMBER_TABLE
2654: , p5_a8 out nocopy JTF_NUMBER_TABLE
2655: , p5_a9 out nocopy JTF_NUMBER_TABLE
2656: , p5_a10 out nocopy JTF_NUMBER_TABLE
2657: , p5_a11 out nocopy JTF_NUMBER_TABLE
2658: , p5_a12 out nocopy JTF_NUMBER_TABLE
2659: , p5_a13 out nocopy JTF_NUMBER_TABLE
2660: , p5_a14 out nocopy JTF_NUMBER_TABLE
2661: , p5_a15 out nocopy JTF_NUMBER_TABLE
2662: , p5_a16 out nocopy JTF_NUMBER_TABLE
2655: , p5_a9 out nocopy JTF_NUMBER_TABLE
2656: , p5_a10 out nocopy JTF_NUMBER_TABLE
2657: , p5_a11 out nocopy JTF_NUMBER_TABLE
2658: , p5_a12 out nocopy JTF_NUMBER_TABLE
2659: , p5_a13 out nocopy JTF_NUMBER_TABLE
2660: , p5_a14 out nocopy JTF_NUMBER_TABLE
2661: , p5_a15 out nocopy JTF_NUMBER_TABLE
2662: , p5_a16 out nocopy JTF_NUMBER_TABLE
2663: , p5_a17 out nocopy JTF_NUMBER_TABLE
2656: , p5_a10 out nocopy JTF_NUMBER_TABLE
2657: , p5_a11 out nocopy JTF_NUMBER_TABLE
2658: , p5_a12 out nocopy JTF_NUMBER_TABLE
2659: , p5_a13 out nocopy JTF_NUMBER_TABLE
2660: , p5_a14 out nocopy JTF_NUMBER_TABLE
2661: , p5_a15 out nocopy JTF_NUMBER_TABLE
2662: , p5_a16 out nocopy JTF_NUMBER_TABLE
2663: , p5_a17 out nocopy JTF_NUMBER_TABLE
2664: , p5_a18 out nocopy JTF_NUMBER_TABLE
2657: , p5_a11 out nocopy JTF_NUMBER_TABLE
2658: , p5_a12 out nocopy JTF_NUMBER_TABLE
2659: , p5_a13 out nocopy JTF_NUMBER_TABLE
2660: , p5_a14 out nocopy JTF_NUMBER_TABLE
2661: , p5_a15 out nocopy JTF_NUMBER_TABLE
2662: , p5_a16 out nocopy JTF_NUMBER_TABLE
2663: , p5_a17 out nocopy JTF_NUMBER_TABLE
2664: , p5_a18 out nocopy JTF_NUMBER_TABLE
2665: , p5_a19 out nocopy JTF_NUMBER_TABLE
2658: , p5_a12 out nocopy JTF_NUMBER_TABLE
2659: , p5_a13 out nocopy JTF_NUMBER_TABLE
2660: , p5_a14 out nocopy JTF_NUMBER_TABLE
2661: , p5_a15 out nocopy JTF_NUMBER_TABLE
2662: , p5_a16 out nocopy JTF_NUMBER_TABLE
2663: , p5_a17 out nocopy JTF_NUMBER_TABLE
2664: , p5_a18 out nocopy JTF_NUMBER_TABLE
2665: , p5_a19 out nocopy JTF_NUMBER_TABLE
2666: , p5_a20 out nocopy JTF_NUMBER_TABLE
2659: , p5_a13 out nocopy JTF_NUMBER_TABLE
2660: , p5_a14 out nocopy JTF_NUMBER_TABLE
2661: , p5_a15 out nocopy JTF_NUMBER_TABLE
2662: , p5_a16 out nocopy JTF_NUMBER_TABLE
2663: , p5_a17 out nocopy JTF_NUMBER_TABLE
2664: , p5_a18 out nocopy JTF_NUMBER_TABLE
2665: , p5_a19 out nocopy JTF_NUMBER_TABLE
2666: , p5_a20 out nocopy JTF_NUMBER_TABLE
2667: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
2660: , p5_a14 out nocopy JTF_NUMBER_TABLE
2661: , p5_a15 out nocopy JTF_NUMBER_TABLE
2662: , p5_a16 out nocopy JTF_NUMBER_TABLE
2663: , p5_a17 out nocopy JTF_NUMBER_TABLE
2664: , p5_a18 out nocopy JTF_NUMBER_TABLE
2665: , p5_a19 out nocopy JTF_NUMBER_TABLE
2666: , p5_a20 out nocopy JTF_NUMBER_TABLE
2667: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
2668: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
2661: , p5_a15 out nocopy JTF_NUMBER_TABLE
2662: , p5_a16 out nocopy JTF_NUMBER_TABLE
2663: , p5_a17 out nocopy JTF_NUMBER_TABLE
2664: , p5_a18 out nocopy JTF_NUMBER_TABLE
2665: , p5_a19 out nocopy JTF_NUMBER_TABLE
2666: , p5_a20 out nocopy JTF_NUMBER_TABLE
2667: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
2668: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
2669: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
2662: , p5_a16 out nocopy JTF_NUMBER_TABLE
2663: , p5_a17 out nocopy JTF_NUMBER_TABLE
2664: , p5_a18 out nocopy JTF_NUMBER_TABLE
2665: , p5_a19 out nocopy JTF_NUMBER_TABLE
2666: , p5_a20 out nocopy JTF_NUMBER_TABLE
2667: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
2668: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
2669: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
2670: , p5_a24 out nocopy JTF_NUMBER_TABLE
2666: , p5_a20 out nocopy JTF_NUMBER_TABLE
2667: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
2668: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
2669: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
2670: , p5_a24 out nocopy JTF_NUMBER_TABLE
2671: , p5_a25 out nocopy JTF_NUMBER_TABLE
2672: , p5_a26 out nocopy JTF_NUMBER_TABLE
2673: , x_return_status out nocopy VARCHAR2
2674: , x_msg_count out nocopy NUMBER
2667: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
2668: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
2669: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
2670: , p5_a24 out nocopy JTF_NUMBER_TABLE
2671: , p5_a25 out nocopy JTF_NUMBER_TABLE
2672: , p5_a26 out nocopy JTF_NUMBER_TABLE
2673: , x_return_status out nocopy VARCHAR2
2674: , x_msg_count out nocopy NUMBER
2675: , x_msg_data out nocopy VARCHAR2
2668: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
2669: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
2670: , p5_a24 out nocopy JTF_NUMBER_TABLE
2671: , p5_a25 out nocopy JTF_NUMBER_TABLE
2672: , p5_a26 out nocopy JTF_NUMBER_TABLE
2673: , x_return_status out nocopy VARCHAR2
2674: , x_msg_count out nocopy NUMBER
2675: , x_msg_data out nocopy VARCHAR2
2676: )
2771: , p5_a23 out nocopy VARCHAR2
2772: , p5_a24 out nocopy NUMBER
2773: , p5_a25 out nocopy NUMBER
2774: , p5_a26 out nocopy NUMBER
2775: , p6_a0 out nocopy JTF_NUMBER_TABLE
2776: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
2777: , p6_a2 out nocopy JTF_NUMBER_TABLE
2778: , p6_a3 out nocopy JTF_NUMBER_TABLE
2779: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
2773: , p5_a25 out nocopy NUMBER
2774: , p5_a26 out nocopy NUMBER
2775: , p6_a0 out nocopy JTF_NUMBER_TABLE
2776: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
2777: , p6_a2 out nocopy JTF_NUMBER_TABLE
2778: , p6_a3 out nocopy JTF_NUMBER_TABLE
2779: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
2780: , p6_a5 out nocopy JTF_NUMBER_TABLE
2781: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2774: , p5_a26 out nocopy NUMBER
2775: , p6_a0 out nocopy JTF_NUMBER_TABLE
2776: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
2777: , p6_a2 out nocopy JTF_NUMBER_TABLE
2778: , p6_a3 out nocopy JTF_NUMBER_TABLE
2779: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
2780: , p6_a5 out nocopy JTF_NUMBER_TABLE
2781: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2782: , p6_a7 out nocopy JTF_NUMBER_TABLE
2776: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
2777: , p6_a2 out nocopy JTF_NUMBER_TABLE
2778: , p6_a3 out nocopy JTF_NUMBER_TABLE
2779: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
2780: , p6_a5 out nocopy JTF_NUMBER_TABLE
2781: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2782: , p6_a7 out nocopy JTF_NUMBER_TABLE
2783: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2784: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2778: , p6_a3 out nocopy JTF_NUMBER_TABLE
2779: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
2780: , p6_a5 out nocopy JTF_NUMBER_TABLE
2781: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2782: , p6_a7 out nocopy JTF_NUMBER_TABLE
2783: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2784: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2785: , x_return_status out nocopy VARCHAR2
2786: , x_msg_count out nocopy NUMBER
2895: , p3_a23 out nocopy VARCHAR2
2896: , p3_a24 out nocopy NUMBER
2897: , p3_a25 out nocopy NUMBER
2898: , p3_a26 out nocopy NUMBER
2899: , p4_a0 out nocopy JTF_NUMBER_TABLE
2900: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2901: , p4_a2 out nocopy JTF_NUMBER_TABLE
2902: , p4_a3 out nocopy JTF_NUMBER_TABLE
2903: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
2897: , p3_a25 out nocopy NUMBER
2898: , p3_a26 out nocopy NUMBER
2899: , p4_a0 out nocopy JTF_NUMBER_TABLE
2900: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2901: , p4_a2 out nocopy JTF_NUMBER_TABLE
2902: , p4_a3 out nocopy JTF_NUMBER_TABLE
2903: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
2904: , p4_a5 out nocopy JTF_NUMBER_TABLE
2905: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
2898: , p3_a26 out nocopy NUMBER
2899: , p4_a0 out nocopy JTF_NUMBER_TABLE
2900: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2901: , p4_a2 out nocopy JTF_NUMBER_TABLE
2902: , p4_a3 out nocopy JTF_NUMBER_TABLE
2903: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
2904: , p4_a5 out nocopy JTF_NUMBER_TABLE
2905: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
2906: , p4_a7 out nocopy JTF_NUMBER_TABLE
2900: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2901: , p4_a2 out nocopy JTF_NUMBER_TABLE
2902: , p4_a3 out nocopy JTF_NUMBER_TABLE
2903: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
2904: , p4_a5 out nocopy JTF_NUMBER_TABLE
2905: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
2906: , p4_a7 out nocopy JTF_NUMBER_TABLE
2907: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
2908: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
2902: , p4_a3 out nocopy JTF_NUMBER_TABLE
2903: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
2904: , p4_a5 out nocopy JTF_NUMBER_TABLE
2905: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
2906: , p4_a7 out nocopy JTF_NUMBER_TABLE
2907: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
2908: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
2909: , x_return_status out nocopy VARCHAR2
2910: , x_msg_count out nocopy NUMBER