1: package body lns_billing_batch_pub_w as
2: /* $Header: LNS_BILL_PUBJ_B.pls 120.5.12020000.2 2012/07/19 20:52:53 scherkas ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_billing_batch_pub.loans_to_bill_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE
1: package body lns_billing_batch_pub_w as
2: /* $Header: LNS_BILL_PUBJ_B.pls 120.5.12020000.2 2012/07/19 20:52:53 scherkas ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_billing_batch_pub.loans_to_bill_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_billing_batch_pub.loans_to_bill_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_DATE_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
40: ) as
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
40: ) as
41: ddindx binary_integer; indx binary_integer;
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
40: ) as
41: ddindx binary_integer; indx binary_integer;
42: begin
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
40: ) as
41: ddindx binary_integer; indx binary_integer;
42: begin
43: if a0 is not null and a0.count > 0 then
90: end loop;
91: end if;
92: end if;
93: end rosetta_table_copy_in_p1;
94: procedure rosetta_table_copy_out_p1(t lns_billing_batch_pub.loans_to_bill_tbl, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_NUMBER_TABLE
96: , a2 out nocopy JTF_VARCHAR2_TABLE_100
97: , a3 out nocopy JTF_VARCHAR2_TABLE_300
98: , a4 out nocopy JTF_NUMBER_TABLE
91: end if;
92: end if;
93: end rosetta_table_copy_in_p1;
94: procedure rosetta_table_copy_out_p1(t lns_billing_batch_pub.loans_to_bill_tbl, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_NUMBER_TABLE
96: , a2 out nocopy JTF_VARCHAR2_TABLE_100
97: , a3 out nocopy JTF_VARCHAR2_TABLE_300
98: , a4 out nocopy JTF_NUMBER_TABLE
99: , a5 out nocopy JTF_DATE_TABLE
94: procedure rosetta_table_copy_out_p1(t lns_billing_batch_pub.loans_to_bill_tbl, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_NUMBER_TABLE
96: , a2 out nocopy JTF_VARCHAR2_TABLE_100
97: , a3 out nocopy JTF_VARCHAR2_TABLE_300
98: , a4 out nocopy JTF_NUMBER_TABLE
99: , a5 out nocopy JTF_DATE_TABLE
100: , a6 out nocopy JTF_DATE_TABLE
101: , a7 out nocopy JTF_DATE_TABLE
102: , a8 out nocopy JTF_VARCHAR2_TABLE_100
100: , a6 out nocopy JTF_DATE_TABLE
101: , a7 out nocopy JTF_DATE_TABLE
102: , a8 out nocopy JTF_VARCHAR2_TABLE_100
103: , a9 out nocopy JTF_VARCHAR2_TABLE_100
104: , a10 out nocopy JTF_NUMBER_TABLE
105: , a11 out nocopy JTF_NUMBER_TABLE
106: , a12 out nocopy JTF_VARCHAR2_TABLE_100
107: , a13 out nocopy JTF_NUMBER_TABLE
108: , a14 out nocopy JTF_VARCHAR2_TABLE_100
101: , a7 out nocopy JTF_DATE_TABLE
102: , a8 out nocopy JTF_VARCHAR2_TABLE_100
103: , a9 out nocopy JTF_VARCHAR2_TABLE_100
104: , a10 out nocopy JTF_NUMBER_TABLE
105: , a11 out nocopy JTF_NUMBER_TABLE
106: , a12 out nocopy JTF_VARCHAR2_TABLE_100
107: , a13 out nocopy JTF_NUMBER_TABLE
108: , a14 out nocopy JTF_VARCHAR2_TABLE_100
109: , a15 out nocopy JTF_VARCHAR2_TABLE_100
103: , a9 out nocopy JTF_VARCHAR2_TABLE_100
104: , a10 out nocopy JTF_NUMBER_TABLE
105: , a11 out nocopy JTF_NUMBER_TABLE
106: , a12 out nocopy JTF_VARCHAR2_TABLE_100
107: , a13 out nocopy JTF_NUMBER_TABLE
108: , a14 out nocopy JTF_VARCHAR2_TABLE_100
109: , a15 out nocopy JTF_VARCHAR2_TABLE_100
110: , a16 out nocopy JTF_NUMBER_TABLE
111: , a17 out nocopy JTF_NUMBER_TABLE
106: , a12 out nocopy JTF_VARCHAR2_TABLE_100
107: , a13 out nocopy JTF_NUMBER_TABLE
108: , a14 out nocopy JTF_VARCHAR2_TABLE_100
109: , a15 out nocopy JTF_VARCHAR2_TABLE_100
110: , a16 out nocopy JTF_NUMBER_TABLE
111: , a17 out nocopy JTF_NUMBER_TABLE
112: , a18 out nocopy JTF_NUMBER_TABLE
113: , a19 out nocopy JTF_NUMBER_TABLE
114: , a20 out nocopy JTF_NUMBER_TABLE
107: , a13 out nocopy JTF_NUMBER_TABLE
108: , a14 out nocopy JTF_VARCHAR2_TABLE_100
109: , a15 out nocopy JTF_VARCHAR2_TABLE_100
110: , a16 out nocopy JTF_NUMBER_TABLE
111: , a17 out nocopy JTF_NUMBER_TABLE
112: , a18 out nocopy JTF_NUMBER_TABLE
113: , a19 out nocopy JTF_NUMBER_TABLE
114: , a20 out nocopy JTF_NUMBER_TABLE
115: , a21 out nocopy JTF_NUMBER_TABLE
108: , a14 out nocopy JTF_VARCHAR2_TABLE_100
109: , a15 out nocopy JTF_VARCHAR2_TABLE_100
110: , a16 out nocopy JTF_NUMBER_TABLE
111: , a17 out nocopy JTF_NUMBER_TABLE
112: , a18 out nocopy JTF_NUMBER_TABLE
113: , a19 out nocopy JTF_NUMBER_TABLE
114: , a20 out nocopy JTF_NUMBER_TABLE
115: , a21 out nocopy JTF_NUMBER_TABLE
116: , a22 out nocopy JTF_NUMBER_TABLE
109: , a15 out nocopy JTF_VARCHAR2_TABLE_100
110: , a16 out nocopy JTF_NUMBER_TABLE
111: , a17 out nocopy JTF_NUMBER_TABLE
112: , a18 out nocopy JTF_NUMBER_TABLE
113: , a19 out nocopy JTF_NUMBER_TABLE
114: , a20 out nocopy JTF_NUMBER_TABLE
115: , a21 out nocopy JTF_NUMBER_TABLE
116: , a22 out nocopy JTF_NUMBER_TABLE
117: , a23 out nocopy JTF_NUMBER_TABLE
110: , a16 out nocopy JTF_NUMBER_TABLE
111: , a17 out nocopy JTF_NUMBER_TABLE
112: , a18 out nocopy JTF_NUMBER_TABLE
113: , a19 out nocopy JTF_NUMBER_TABLE
114: , a20 out nocopy JTF_NUMBER_TABLE
115: , a21 out nocopy JTF_NUMBER_TABLE
116: , a22 out nocopy JTF_NUMBER_TABLE
117: , a23 out nocopy JTF_NUMBER_TABLE
118: , a24 out nocopy JTF_VARCHAR2_TABLE_100
111: , a17 out nocopy JTF_NUMBER_TABLE
112: , a18 out nocopy JTF_NUMBER_TABLE
113: , a19 out nocopy JTF_NUMBER_TABLE
114: , a20 out nocopy JTF_NUMBER_TABLE
115: , a21 out nocopy JTF_NUMBER_TABLE
116: , a22 out nocopy JTF_NUMBER_TABLE
117: , a23 out nocopy JTF_NUMBER_TABLE
118: , a24 out nocopy JTF_VARCHAR2_TABLE_100
119: , a25 out nocopy JTF_DATE_TABLE
112: , a18 out nocopy JTF_NUMBER_TABLE
113: , a19 out nocopy JTF_NUMBER_TABLE
114: , a20 out nocopy JTF_NUMBER_TABLE
115: , a21 out nocopy JTF_NUMBER_TABLE
116: , a22 out nocopy JTF_NUMBER_TABLE
117: , a23 out nocopy JTF_NUMBER_TABLE
118: , a24 out nocopy JTF_VARCHAR2_TABLE_100
119: , a25 out nocopy JTF_DATE_TABLE
120: , a26 out nocopy JTF_NUMBER_TABLE
113: , a19 out nocopy JTF_NUMBER_TABLE
114: , a20 out nocopy JTF_NUMBER_TABLE
115: , a21 out nocopy JTF_NUMBER_TABLE
116: , a22 out nocopy JTF_NUMBER_TABLE
117: , a23 out nocopy JTF_NUMBER_TABLE
118: , a24 out nocopy JTF_VARCHAR2_TABLE_100
119: , a25 out nocopy JTF_DATE_TABLE
120: , a26 out nocopy JTF_NUMBER_TABLE
121: , a27 out nocopy JTF_NUMBER_TABLE
116: , a22 out nocopy JTF_NUMBER_TABLE
117: , a23 out nocopy JTF_NUMBER_TABLE
118: , a24 out nocopy JTF_VARCHAR2_TABLE_100
119: , a25 out nocopy JTF_DATE_TABLE
120: , a26 out nocopy JTF_NUMBER_TABLE
121: , a27 out nocopy JTF_NUMBER_TABLE
122: , a28 out nocopy JTF_NUMBER_TABLE
123: , a29 out nocopy JTF_VARCHAR2_TABLE_100
124: , a30 out nocopy JTF_VARCHAR2_TABLE_100
117: , a23 out nocopy JTF_NUMBER_TABLE
118: , a24 out nocopy JTF_VARCHAR2_TABLE_100
119: , a25 out nocopy JTF_DATE_TABLE
120: , a26 out nocopy JTF_NUMBER_TABLE
121: , a27 out nocopy JTF_NUMBER_TABLE
122: , a28 out nocopy JTF_NUMBER_TABLE
123: , a29 out nocopy JTF_VARCHAR2_TABLE_100
124: , a30 out nocopy JTF_VARCHAR2_TABLE_100
125: , a31 out nocopy JTF_NUMBER_TABLE
118: , a24 out nocopy JTF_VARCHAR2_TABLE_100
119: , a25 out nocopy JTF_DATE_TABLE
120: , a26 out nocopy JTF_NUMBER_TABLE
121: , a27 out nocopy JTF_NUMBER_TABLE
122: , a28 out nocopy JTF_NUMBER_TABLE
123: , a29 out nocopy JTF_VARCHAR2_TABLE_100
124: , a30 out nocopy JTF_VARCHAR2_TABLE_100
125: , a31 out nocopy JTF_NUMBER_TABLE
126: , a32 out nocopy JTF_VARCHAR2_TABLE_100
121: , a27 out nocopy JTF_NUMBER_TABLE
122: , a28 out nocopy JTF_NUMBER_TABLE
123: , a29 out nocopy JTF_VARCHAR2_TABLE_100
124: , a30 out nocopy JTF_VARCHAR2_TABLE_100
125: , a31 out nocopy JTF_NUMBER_TABLE
126: , a32 out nocopy JTF_VARCHAR2_TABLE_100
127: , a33 out nocopy JTF_NUMBER_TABLE
128: , a34 out nocopy JTF_NUMBER_TABLE
129: , a35 out nocopy JTF_NUMBER_TABLE
123: , a29 out nocopy JTF_VARCHAR2_TABLE_100
124: , a30 out nocopy JTF_VARCHAR2_TABLE_100
125: , a31 out nocopy JTF_NUMBER_TABLE
126: , a32 out nocopy JTF_VARCHAR2_TABLE_100
127: , a33 out nocopy JTF_NUMBER_TABLE
128: , a34 out nocopy JTF_NUMBER_TABLE
129: , a35 out nocopy JTF_NUMBER_TABLE
130: , a36 out nocopy JTF_NUMBER_TABLE
131: ) as
124: , a30 out nocopy JTF_VARCHAR2_TABLE_100
125: , a31 out nocopy JTF_NUMBER_TABLE
126: , a32 out nocopy JTF_VARCHAR2_TABLE_100
127: , a33 out nocopy JTF_NUMBER_TABLE
128: , a34 out nocopy JTF_NUMBER_TABLE
129: , a35 out nocopy JTF_NUMBER_TABLE
130: , a36 out nocopy JTF_NUMBER_TABLE
131: ) as
132: ddindx binary_integer; indx binary_integer;
125: , a31 out nocopy JTF_NUMBER_TABLE
126: , a32 out nocopy JTF_VARCHAR2_TABLE_100
127: , a33 out nocopy JTF_NUMBER_TABLE
128: , a34 out nocopy JTF_NUMBER_TABLE
129: , a35 out nocopy JTF_NUMBER_TABLE
130: , a36 out nocopy JTF_NUMBER_TABLE
131: ) as
132: ddindx binary_integer; indx binary_integer;
133: begin
126: , a32 out nocopy JTF_VARCHAR2_TABLE_100
127: , a33 out nocopy JTF_NUMBER_TABLE
128: , a34 out nocopy JTF_NUMBER_TABLE
129: , a35 out nocopy JTF_NUMBER_TABLE
130: , a36 out nocopy JTF_NUMBER_TABLE
131: ) as
132: ddindx binary_integer; indx binary_integer;
133: begin
134: if t is null or t.count = 0 then
131: ) as
132: ddindx binary_integer; indx binary_integer;
133: begin
134: if t is null or t.count = 0 then
135: a0 := JTF_NUMBER_TABLE();
136: a1 := JTF_NUMBER_TABLE();
137: a2 := JTF_VARCHAR2_TABLE_100();
138: a3 := JTF_VARCHAR2_TABLE_300();
139: a4 := JTF_NUMBER_TABLE();
132: ddindx binary_integer; indx binary_integer;
133: begin
134: if t is null or t.count = 0 then
135: a0 := JTF_NUMBER_TABLE();
136: a1 := JTF_NUMBER_TABLE();
137: a2 := JTF_VARCHAR2_TABLE_100();
138: a3 := JTF_VARCHAR2_TABLE_300();
139: a4 := JTF_NUMBER_TABLE();
140: a5 := JTF_DATE_TABLE();
135: a0 := JTF_NUMBER_TABLE();
136: a1 := JTF_NUMBER_TABLE();
137: a2 := JTF_VARCHAR2_TABLE_100();
138: a3 := JTF_VARCHAR2_TABLE_300();
139: a4 := JTF_NUMBER_TABLE();
140: a5 := JTF_DATE_TABLE();
141: a6 := JTF_DATE_TABLE();
142: a7 := JTF_DATE_TABLE();
143: a8 := JTF_VARCHAR2_TABLE_100();
141: a6 := JTF_DATE_TABLE();
142: a7 := JTF_DATE_TABLE();
143: a8 := JTF_VARCHAR2_TABLE_100();
144: a9 := JTF_VARCHAR2_TABLE_100();
145: a10 := JTF_NUMBER_TABLE();
146: a11 := JTF_NUMBER_TABLE();
147: a12 := JTF_VARCHAR2_TABLE_100();
148: a13 := JTF_NUMBER_TABLE();
149: a14 := JTF_VARCHAR2_TABLE_100();
142: a7 := JTF_DATE_TABLE();
143: a8 := JTF_VARCHAR2_TABLE_100();
144: a9 := JTF_VARCHAR2_TABLE_100();
145: a10 := JTF_NUMBER_TABLE();
146: a11 := JTF_NUMBER_TABLE();
147: a12 := JTF_VARCHAR2_TABLE_100();
148: a13 := JTF_NUMBER_TABLE();
149: a14 := JTF_VARCHAR2_TABLE_100();
150: a15 := JTF_VARCHAR2_TABLE_100();
144: a9 := JTF_VARCHAR2_TABLE_100();
145: a10 := JTF_NUMBER_TABLE();
146: a11 := JTF_NUMBER_TABLE();
147: a12 := JTF_VARCHAR2_TABLE_100();
148: a13 := JTF_NUMBER_TABLE();
149: a14 := JTF_VARCHAR2_TABLE_100();
150: a15 := JTF_VARCHAR2_TABLE_100();
151: a16 := JTF_NUMBER_TABLE();
152: a17 := JTF_NUMBER_TABLE();
147: a12 := JTF_VARCHAR2_TABLE_100();
148: a13 := JTF_NUMBER_TABLE();
149: a14 := JTF_VARCHAR2_TABLE_100();
150: a15 := JTF_VARCHAR2_TABLE_100();
151: a16 := JTF_NUMBER_TABLE();
152: a17 := JTF_NUMBER_TABLE();
153: a18 := JTF_NUMBER_TABLE();
154: a19 := JTF_NUMBER_TABLE();
155: a20 := JTF_NUMBER_TABLE();
148: a13 := JTF_NUMBER_TABLE();
149: a14 := JTF_VARCHAR2_TABLE_100();
150: a15 := JTF_VARCHAR2_TABLE_100();
151: a16 := JTF_NUMBER_TABLE();
152: a17 := JTF_NUMBER_TABLE();
153: a18 := JTF_NUMBER_TABLE();
154: a19 := JTF_NUMBER_TABLE();
155: a20 := JTF_NUMBER_TABLE();
156: a21 := JTF_NUMBER_TABLE();
149: a14 := JTF_VARCHAR2_TABLE_100();
150: a15 := JTF_VARCHAR2_TABLE_100();
151: a16 := JTF_NUMBER_TABLE();
152: a17 := JTF_NUMBER_TABLE();
153: a18 := JTF_NUMBER_TABLE();
154: a19 := JTF_NUMBER_TABLE();
155: a20 := JTF_NUMBER_TABLE();
156: a21 := JTF_NUMBER_TABLE();
157: a22 := JTF_NUMBER_TABLE();
150: a15 := JTF_VARCHAR2_TABLE_100();
151: a16 := JTF_NUMBER_TABLE();
152: a17 := JTF_NUMBER_TABLE();
153: a18 := JTF_NUMBER_TABLE();
154: a19 := JTF_NUMBER_TABLE();
155: a20 := JTF_NUMBER_TABLE();
156: a21 := JTF_NUMBER_TABLE();
157: a22 := JTF_NUMBER_TABLE();
158: a23 := JTF_NUMBER_TABLE();
151: a16 := JTF_NUMBER_TABLE();
152: a17 := JTF_NUMBER_TABLE();
153: a18 := JTF_NUMBER_TABLE();
154: a19 := JTF_NUMBER_TABLE();
155: a20 := JTF_NUMBER_TABLE();
156: a21 := JTF_NUMBER_TABLE();
157: a22 := JTF_NUMBER_TABLE();
158: a23 := JTF_NUMBER_TABLE();
159: a24 := JTF_VARCHAR2_TABLE_100();
152: a17 := JTF_NUMBER_TABLE();
153: a18 := JTF_NUMBER_TABLE();
154: a19 := JTF_NUMBER_TABLE();
155: a20 := JTF_NUMBER_TABLE();
156: a21 := JTF_NUMBER_TABLE();
157: a22 := JTF_NUMBER_TABLE();
158: a23 := JTF_NUMBER_TABLE();
159: a24 := JTF_VARCHAR2_TABLE_100();
160: a25 := JTF_DATE_TABLE();
153: a18 := JTF_NUMBER_TABLE();
154: a19 := JTF_NUMBER_TABLE();
155: a20 := JTF_NUMBER_TABLE();
156: a21 := JTF_NUMBER_TABLE();
157: a22 := JTF_NUMBER_TABLE();
158: a23 := JTF_NUMBER_TABLE();
159: a24 := JTF_VARCHAR2_TABLE_100();
160: a25 := JTF_DATE_TABLE();
161: a26 := JTF_NUMBER_TABLE();
154: a19 := JTF_NUMBER_TABLE();
155: a20 := JTF_NUMBER_TABLE();
156: a21 := JTF_NUMBER_TABLE();
157: a22 := JTF_NUMBER_TABLE();
158: a23 := JTF_NUMBER_TABLE();
159: a24 := JTF_VARCHAR2_TABLE_100();
160: a25 := JTF_DATE_TABLE();
161: a26 := JTF_NUMBER_TABLE();
162: a27 := JTF_NUMBER_TABLE();
157: a22 := JTF_NUMBER_TABLE();
158: a23 := JTF_NUMBER_TABLE();
159: a24 := JTF_VARCHAR2_TABLE_100();
160: a25 := JTF_DATE_TABLE();
161: a26 := JTF_NUMBER_TABLE();
162: a27 := JTF_NUMBER_TABLE();
163: a28 := JTF_NUMBER_TABLE();
164: a29 := JTF_VARCHAR2_TABLE_100();
165: a30 := JTF_VARCHAR2_TABLE_100();
158: a23 := JTF_NUMBER_TABLE();
159: a24 := JTF_VARCHAR2_TABLE_100();
160: a25 := JTF_DATE_TABLE();
161: a26 := JTF_NUMBER_TABLE();
162: a27 := JTF_NUMBER_TABLE();
163: a28 := JTF_NUMBER_TABLE();
164: a29 := JTF_VARCHAR2_TABLE_100();
165: a30 := JTF_VARCHAR2_TABLE_100();
166: a31 := JTF_NUMBER_TABLE();
159: a24 := JTF_VARCHAR2_TABLE_100();
160: a25 := JTF_DATE_TABLE();
161: a26 := JTF_NUMBER_TABLE();
162: a27 := JTF_NUMBER_TABLE();
163: a28 := JTF_NUMBER_TABLE();
164: a29 := JTF_VARCHAR2_TABLE_100();
165: a30 := JTF_VARCHAR2_TABLE_100();
166: a31 := JTF_NUMBER_TABLE();
167: a32 := JTF_VARCHAR2_TABLE_100();
162: a27 := JTF_NUMBER_TABLE();
163: a28 := JTF_NUMBER_TABLE();
164: a29 := JTF_VARCHAR2_TABLE_100();
165: a30 := JTF_VARCHAR2_TABLE_100();
166: a31 := JTF_NUMBER_TABLE();
167: a32 := JTF_VARCHAR2_TABLE_100();
168: a33 := JTF_NUMBER_TABLE();
169: a34 := JTF_NUMBER_TABLE();
170: a35 := JTF_NUMBER_TABLE();
164: a29 := JTF_VARCHAR2_TABLE_100();
165: a30 := JTF_VARCHAR2_TABLE_100();
166: a31 := JTF_NUMBER_TABLE();
167: a32 := JTF_VARCHAR2_TABLE_100();
168: a33 := JTF_NUMBER_TABLE();
169: a34 := JTF_NUMBER_TABLE();
170: a35 := JTF_NUMBER_TABLE();
171: a36 := JTF_NUMBER_TABLE();
172: else
165: a30 := JTF_VARCHAR2_TABLE_100();
166: a31 := JTF_NUMBER_TABLE();
167: a32 := JTF_VARCHAR2_TABLE_100();
168: a33 := JTF_NUMBER_TABLE();
169: a34 := JTF_NUMBER_TABLE();
170: a35 := JTF_NUMBER_TABLE();
171: a36 := JTF_NUMBER_TABLE();
172: else
173: a0 := JTF_NUMBER_TABLE();
166: a31 := JTF_NUMBER_TABLE();
167: a32 := JTF_VARCHAR2_TABLE_100();
168: a33 := JTF_NUMBER_TABLE();
169: a34 := JTF_NUMBER_TABLE();
170: a35 := JTF_NUMBER_TABLE();
171: a36 := JTF_NUMBER_TABLE();
172: else
173: a0 := JTF_NUMBER_TABLE();
174: a1 := JTF_NUMBER_TABLE();
167: a32 := JTF_VARCHAR2_TABLE_100();
168: a33 := JTF_NUMBER_TABLE();
169: a34 := JTF_NUMBER_TABLE();
170: a35 := JTF_NUMBER_TABLE();
171: a36 := JTF_NUMBER_TABLE();
172: else
173: a0 := JTF_NUMBER_TABLE();
174: a1 := JTF_NUMBER_TABLE();
175: a2 := JTF_VARCHAR2_TABLE_100();
169: a34 := JTF_NUMBER_TABLE();
170: a35 := JTF_NUMBER_TABLE();
171: a36 := JTF_NUMBER_TABLE();
172: else
173: a0 := JTF_NUMBER_TABLE();
174: a1 := JTF_NUMBER_TABLE();
175: a2 := JTF_VARCHAR2_TABLE_100();
176: a3 := JTF_VARCHAR2_TABLE_300();
177: a4 := JTF_NUMBER_TABLE();
170: a35 := JTF_NUMBER_TABLE();
171: a36 := JTF_NUMBER_TABLE();
172: else
173: a0 := JTF_NUMBER_TABLE();
174: a1 := JTF_NUMBER_TABLE();
175: a2 := JTF_VARCHAR2_TABLE_100();
176: a3 := JTF_VARCHAR2_TABLE_300();
177: a4 := JTF_NUMBER_TABLE();
178: a5 := JTF_DATE_TABLE();
173: a0 := JTF_NUMBER_TABLE();
174: a1 := JTF_NUMBER_TABLE();
175: a2 := JTF_VARCHAR2_TABLE_100();
176: a3 := JTF_VARCHAR2_TABLE_300();
177: a4 := JTF_NUMBER_TABLE();
178: a5 := JTF_DATE_TABLE();
179: a6 := JTF_DATE_TABLE();
180: a7 := JTF_DATE_TABLE();
181: a8 := JTF_VARCHAR2_TABLE_100();
179: a6 := JTF_DATE_TABLE();
180: a7 := JTF_DATE_TABLE();
181: a8 := JTF_VARCHAR2_TABLE_100();
182: a9 := JTF_VARCHAR2_TABLE_100();
183: a10 := JTF_NUMBER_TABLE();
184: a11 := JTF_NUMBER_TABLE();
185: a12 := JTF_VARCHAR2_TABLE_100();
186: a13 := JTF_NUMBER_TABLE();
187: a14 := JTF_VARCHAR2_TABLE_100();
180: a7 := JTF_DATE_TABLE();
181: a8 := JTF_VARCHAR2_TABLE_100();
182: a9 := JTF_VARCHAR2_TABLE_100();
183: a10 := JTF_NUMBER_TABLE();
184: a11 := JTF_NUMBER_TABLE();
185: a12 := JTF_VARCHAR2_TABLE_100();
186: a13 := JTF_NUMBER_TABLE();
187: a14 := JTF_VARCHAR2_TABLE_100();
188: a15 := JTF_VARCHAR2_TABLE_100();
182: a9 := JTF_VARCHAR2_TABLE_100();
183: a10 := JTF_NUMBER_TABLE();
184: a11 := JTF_NUMBER_TABLE();
185: a12 := JTF_VARCHAR2_TABLE_100();
186: a13 := JTF_NUMBER_TABLE();
187: a14 := JTF_VARCHAR2_TABLE_100();
188: a15 := JTF_VARCHAR2_TABLE_100();
189: a16 := JTF_NUMBER_TABLE();
190: a17 := JTF_NUMBER_TABLE();
185: a12 := JTF_VARCHAR2_TABLE_100();
186: a13 := JTF_NUMBER_TABLE();
187: a14 := JTF_VARCHAR2_TABLE_100();
188: a15 := JTF_VARCHAR2_TABLE_100();
189: a16 := JTF_NUMBER_TABLE();
190: a17 := JTF_NUMBER_TABLE();
191: a18 := JTF_NUMBER_TABLE();
192: a19 := JTF_NUMBER_TABLE();
193: a20 := JTF_NUMBER_TABLE();
186: a13 := JTF_NUMBER_TABLE();
187: a14 := JTF_VARCHAR2_TABLE_100();
188: a15 := JTF_VARCHAR2_TABLE_100();
189: a16 := JTF_NUMBER_TABLE();
190: a17 := JTF_NUMBER_TABLE();
191: a18 := JTF_NUMBER_TABLE();
192: a19 := JTF_NUMBER_TABLE();
193: a20 := JTF_NUMBER_TABLE();
194: a21 := JTF_NUMBER_TABLE();
187: a14 := JTF_VARCHAR2_TABLE_100();
188: a15 := JTF_VARCHAR2_TABLE_100();
189: a16 := JTF_NUMBER_TABLE();
190: a17 := JTF_NUMBER_TABLE();
191: a18 := JTF_NUMBER_TABLE();
192: a19 := JTF_NUMBER_TABLE();
193: a20 := JTF_NUMBER_TABLE();
194: a21 := JTF_NUMBER_TABLE();
195: a22 := JTF_NUMBER_TABLE();
188: a15 := JTF_VARCHAR2_TABLE_100();
189: a16 := JTF_NUMBER_TABLE();
190: a17 := JTF_NUMBER_TABLE();
191: a18 := JTF_NUMBER_TABLE();
192: a19 := JTF_NUMBER_TABLE();
193: a20 := JTF_NUMBER_TABLE();
194: a21 := JTF_NUMBER_TABLE();
195: a22 := JTF_NUMBER_TABLE();
196: a23 := JTF_NUMBER_TABLE();
189: a16 := JTF_NUMBER_TABLE();
190: a17 := JTF_NUMBER_TABLE();
191: a18 := JTF_NUMBER_TABLE();
192: a19 := JTF_NUMBER_TABLE();
193: a20 := JTF_NUMBER_TABLE();
194: a21 := JTF_NUMBER_TABLE();
195: a22 := JTF_NUMBER_TABLE();
196: a23 := JTF_NUMBER_TABLE();
197: a24 := JTF_VARCHAR2_TABLE_100();
190: a17 := JTF_NUMBER_TABLE();
191: a18 := JTF_NUMBER_TABLE();
192: a19 := JTF_NUMBER_TABLE();
193: a20 := JTF_NUMBER_TABLE();
194: a21 := JTF_NUMBER_TABLE();
195: a22 := JTF_NUMBER_TABLE();
196: a23 := JTF_NUMBER_TABLE();
197: a24 := JTF_VARCHAR2_TABLE_100();
198: a25 := JTF_DATE_TABLE();
191: a18 := JTF_NUMBER_TABLE();
192: a19 := JTF_NUMBER_TABLE();
193: a20 := JTF_NUMBER_TABLE();
194: a21 := JTF_NUMBER_TABLE();
195: a22 := JTF_NUMBER_TABLE();
196: a23 := JTF_NUMBER_TABLE();
197: a24 := JTF_VARCHAR2_TABLE_100();
198: a25 := JTF_DATE_TABLE();
199: a26 := JTF_NUMBER_TABLE();
192: a19 := JTF_NUMBER_TABLE();
193: a20 := JTF_NUMBER_TABLE();
194: a21 := JTF_NUMBER_TABLE();
195: a22 := JTF_NUMBER_TABLE();
196: a23 := JTF_NUMBER_TABLE();
197: a24 := JTF_VARCHAR2_TABLE_100();
198: a25 := JTF_DATE_TABLE();
199: a26 := JTF_NUMBER_TABLE();
200: a27 := JTF_NUMBER_TABLE();
195: a22 := JTF_NUMBER_TABLE();
196: a23 := JTF_NUMBER_TABLE();
197: a24 := JTF_VARCHAR2_TABLE_100();
198: a25 := JTF_DATE_TABLE();
199: a26 := JTF_NUMBER_TABLE();
200: a27 := JTF_NUMBER_TABLE();
201: a28 := JTF_NUMBER_TABLE();
202: a29 := JTF_VARCHAR2_TABLE_100();
203: a30 := JTF_VARCHAR2_TABLE_100();
196: a23 := JTF_NUMBER_TABLE();
197: a24 := JTF_VARCHAR2_TABLE_100();
198: a25 := JTF_DATE_TABLE();
199: a26 := JTF_NUMBER_TABLE();
200: a27 := JTF_NUMBER_TABLE();
201: a28 := JTF_NUMBER_TABLE();
202: a29 := JTF_VARCHAR2_TABLE_100();
203: a30 := JTF_VARCHAR2_TABLE_100();
204: a31 := JTF_NUMBER_TABLE();
197: a24 := JTF_VARCHAR2_TABLE_100();
198: a25 := JTF_DATE_TABLE();
199: a26 := JTF_NUMBER_TABLE();
200: a27 := JTF_NUMBER_TABLE();
201: a28 := JTF_NUMBER_TABLE();
202: a29 := JTF_VARCHAR2_TABLE_100();
203: a30 := JTF_VARCHAR2_TABLE_100();
204: a31 := JTF_NUMBER_TABLE();
205: a32 := JTF_VARCHAR2_TABLE_100();
200: a27 := JTF_NUMBER_TABLE();
201: a28 := JTF_NUMBER_TABLE();
202: a29 := JTF_VARCHAR2_TABLE_100();
203: a30 := JTF_VARCHAR2_TABLE_100();
204: a31 := JTF_NUMBER_TABLE();
205: a32 := JTF_VARCHAR2_TABLE_100();
206: a33 := JTF_NUMBER_TABLE();
207: a34 := JTF_NUMBER_TABLE();
208: a35 := JTF_NUMBER_TABLE();
202: a29 := JTF_VARCHAR2_TABLE_100();
203: a30 := JTF_VARCHAR2_TABLE_100();
204: a31 := JTF_NUMBER_TABLE();
205: a32 := JTF_VARCHAR2_TABLE_100();
206: a33 := JTF_NUMBER_TABLE();
207: a34 := JTF_NUMBER_TABLE();
208: a35 := JTF_NUMBER_TABLE();
209: a36 := JTF_NUMBER_TABLE();
210: if t.count > 0 then
203: a30 := JTF_VARCHAR2_TABLE_100();
204: a31 := JTF_NUMBER_TABLE();
205: a32 := JTF_VARCHAR2_TABLE_100();
206: a33 := JTF_NUMBER_TABLE();
207: a34 := JTF_NUMBER_TABLE();
208: a35 := JTF_NUMBER_TABLE();
209: a36 := JTF_NUMBER_TABLE();
210: if t.count > 0 then
211: a0.extend(t.count);
204: a31 := JTF_NUMBER_TABLE();
205: a32 := JTF_VARCHAR2_TABLE_100();
206: a33 := JTF_NUMBER_TABLE();
207: a34 := JTF_NUMBER_TABLE();
208: a35 := JTF_NUMBER_TABLE();
209: a36 := JTF_NUMBER_TABLE();
210: if t.count > 0 then
211: a0.extend(t.count);
212: a1.extend(t.count);
205: a32 := JTF_VARCHAR2_TABLE_100();
206: a33 := JTF_NUMBER_TABLE();
207: a34 := JTF_NUMBER_TABLE();
208: a35 := JTF_NUMBER_TABLE();
209: a36 := JTF_NUMBER_TABLE();
210: if t.count > 0 then
211: a0.extend(t.count);
212: a1.extend(t.count);
213: a2.extend(t.count);
295: end if;
296: end rosetta_table_copy_out_p1;
297:
298: procedure rosetta_table_copy_in_p4(t out nocopy lns_billing_batch_pub.reverse_tbl, a0 JTF_VARCHAR2_TABLE_100
299: , a1 JTF_NUMBER_TABLE
300: , a2 JTF_NUMBER_TABLE
301: , a3 JTF_NUMBER_TABLE
302: , a4 JTF_VARCHAR2_TABLE_100
303: , a5 JTF_NUMBER_TABLE
296: end rosetta_table_copy_out_p1;
297:
298: procedure rosetta_table_copy_in_p4(t out nocopy lns_billing_batch_pub.reverse_tbl, a0 JTF_VARCHAR2_TABLE_100
299: , a1 JTF_NUMBER_TABLE
300: , a2 JTF_NUMBER_TABLE
301: , a3 JTF_NUMBER_TABLE
302: , a4 JTF_VARCHAR2_TABLE_100
303: , a5 JTF_NUMBER_TABLE
304: , a6 JTF_NUMBER_TABLE
297:
298: procedure rosetta_table_copy_in_p4(t out nocopy lns_billing_batch_pub.reverse_tbl, a0 JTF_VARCHAR2_TABLE_100
299: , a1 JTF_NUMBER_TABLE
300: , a2 JTF_NUMBER_TABLE
301: , a3 JTF_NUMBER_TABLE
302: , a4 JTF_VARCHAR2_TABLE_100
303: , a5 JTF_NUMBER_TABLE
304: , a6 JTF_NUMBER_TABLE
305: , a7 JTF_NUMBER_TABLE
299: , a1 JTF_NUMBER_TABLE
300: , a2 JTF_NUMBER_TABLE
301: , a3 JTF_NUMBER_TABLE
302: , a4 JTF_VARCHAR2_TABLE_100
303: , a5 JTF_NUMBER_TABLE
304: , a6 JTF_NUMBER_TABLE
305: , a7 JTF_NUMBER_TABLE
306: ) as
307: ddindx binary_integer; indx binary_integer;
300: , a2 JTF_NUMBER_TABLE
301: , a3 JTF_NUMBER_TABLE
302: , a4 JTF_VARCHAR2_TABLE_100
303: , a5 JTF_NUMBER_TABLE
304: , a6 JTF_NUMBER_TABLE
305: , a7 JTF_NUMBER_TABLE
306: ) as
307: ddindx binary_integer; indx binary_integer;
308: begin
301: , a3 JTF_NUMBER_TABLE
302: , a4 JTF_VARCHAR2_TABLE_100
303: , a5 JTF_NUMBER_TABLE
304: , a6 JTF_NUMBER_TABLE
305: , a7 JTF_NUMBER_TABLE
306: ) as
307: ddindx binary_integer; indx binary_integer;
308: begin
309: if a0 is not null and a0.count > 0 then
328: end if;
329: end if;
330: end rosetta_table_copy_in_p4;
331: procedure rosetta_table_copy_out_p4(t lns_billing_batch_pub.reverse_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
332: , a1 out nocopy JTF_NUMBER_TABLE
333: , a2 out nocopy JTF_NUMBER_TABLE
334: , a3 out nocopy JTF_NUMBER_TABLE
335: , a4 out nocopy JTF_VARCHAR2_TABLE_100
336: , a5 out nocopy JTF_NUMBER_TABLE
329: end if;
330: end rosetta_table_copy_in_p4;
331: procedure rosetta_table_copy_out_p4(t lns_billing_batch_pub.reverse_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
332: , a1 out nocopy JTF_NUMBER_TABLE
333: , a2 out nocopy JTF_NUMBER_TABLE
334: , a3 out nocopy JTF_NUMBER_TABLE
335: , a4 out nocopy JTF_VARCHAR2_TABLE_100
336: , a5 out nocopy JTF_NUMBER_TABLE
337: , a6 out nocopy JTF_NUMBER_TABLE
330: end rosetta_table_copy_in_p4;
331: procedure rosetta_table_copy_out_p4(t lns_billing_batch_pub.reverse_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
332: , a1 out nocopy JTF_NUMBER_TABLE
333: , a2 out nocopy JTF_NUMBER_TABLE
334: , a3 out nocopy JTF_NUMBER_TABLE
335: , a4 out nocopy JTF_VARCHAR2_TABLE_100
336: , a5 out nocopy JTF_NUMBER_TABLE
337: , a6 out nocopy JTF_NUMBER_TABLE
338: , a7 out nocopy JTF_NUMBER_TABLE
332: , a1 out nocopy JTF_NUMBER_TABLE
333: , a2 out nocopy JTF_NUMBER_TABLE
334: , a3 out nocopy JTF_NUMBER_TABLE
335: , a4 out nocopy JTF_VARCHAR2_TABLE_100
336: , a5 out nocopy JTF_NUMBER_TABLE
337: , a6 out nocopy JTF_NUMBER_TABLE
338: , a7 out nocopy JTF_NUMBER_TABLE
339: ) as
340: ddindx binary_integer; indx binary_integer;
333: , a2 out nocopy JTF_NUMBER_TABLE
334: , a3 out nocopy JTF_NUMBER_TABLE
335: , a4 out nocopy JTF_VARCHAR2_TABLE_100
336: , a5 out nocopy JTF_NUMBER_TABLE
337: , a6 out nocopy JTF_NUMBER_TABLE
338: , a7 out nocopy JTF_NUMBER_TABLE
339: ) as
340: ddindx binary_integer; indx binary_integer;
341: begin
334: , a3 out nocopy JTF_NUMBER_TABLE
335: , a4 out nocopy JTF_VARCHAR2_TABLE_100
336: , a5 out nocopy JTF_NUMBER_TABLE
337: , a6 out nocopy JTF_NUMBER_TABLE
338: , a7 out nocopy JTF_NUMBER_TABLE
339: ) as
340: ddindx binary_integer; indx binary_integer;
341: begin
342: if t is null or t.count = 0 then
340: ddindx binary_integer; indx binary_integer;
341: begin
342: if t is null or t.count = 0 then
343: a0 := JTF_VARCHAR2_TABLE_100();
344: a1 := JTF_NUMBER_TABLE();
345: a2 := JTF_NUMBER_TABLE();
346: a3 := JTF_NUMBER_TABLE();
347: a4 := JTF_VARCHAR2_TABLE_100();
348: a5 := JTF_NUMBER_TABLE();
341: begin
342: if t is null or t.count = 0 then
343: a0 := JTF_VARCHAR2_TABLE_100();
344: a1 := JTF_NUMBER_TABLE();
345: a2 := JTF_NUMBER_TABLE();
346: a3 := JTF_NUMBER_TABLE();
347: a4 := JTF_VARCHAR2_TABLE_100();
348: a5 := JTF_NUMBER_TABLE();
349: a6 := JTF_NUMBER_TABLE();
342: if t is null or t.count = 0 then
343: a0 := JTF_VARCHAR2_TABLE_100();
344: a1 := JTF_NUMBER_TABLE();
345: a2 := JTF_NUMBER_TABLE();
346: a3 := JTF_NUMBER_TABLE();
347: a4 := JTF_VARCHAR2_TABLE_100();
348: a5 := JTF_NUMBER_TABLE();
349: a6 := JTF_NUMBER_TABLE();
350: a7 := JTF_NUMBER_TABLE();
344: a1 := JTF_NUMBER_TABLE();
345: a2 := JTF_NUMBER_TABLE();
346: a3 := JTF_NUMBER_TABLE();
347: a4 := JTF_VARCHAR2_TABLE_100();
348: a5 := JTF_NUMBER_TABLE();
349: a6 := JTF_NUMBER_TABLE();
350: a7 := JTF_NUMBER_TABLE();
351: else
352: a0 := JTF_VARCHAR2_TABLE_100();
345: a2 := JTF_NUMBER_TABLE();
346: a3 := JTF_NUMBER_TABLE();
347: a4 := JTF_VARCHAR2_TABLE_100();
348: a5 := JTF_NUMBER_TABLE();
349: a6 := JTF_NUMBER_TABLE();
350: a7 := JTF_NUMBER_TABLE();
351: else
352: a0 := JTF_VARCHAR2_TABLE_100();
353: a1 := JTF_NUMBER_TABLE();
346: a3 := JTF_NUMBER_TABLE();
347: a4 := JTF_VARCHAR2_TABLE_100();
348: a5 := JTF_NUMBER_TABLE();
349: a6 := JTF_NUMBER_TABLE();
350: a7 := JTF_NUMBER_TABLE();
351: else
352: a0 := JTF_VARCHAR2_TABLE_100();
353: a1 := JTF_NUMBER_TABLE();
354: a2 := JTF_NUMBER_TABLE();
349: a6 := JTF_NUMBER_TABLE();
350: a7 := JTF_NUMBER_TABLE();
351: else
352: a0 := JTF_VARCHAR2_TABLE_100();
353: a1 := JTF_NUMBER_TABLE();
354: a2 := JTF_NUMBER_TABLE();
355: a3 := JTF_NUMBER_TABLE();
356: a4 := JTF_VARCHAR2_TABLE_100();
357: a5 := JTF_NUMBER_TABLE();
350: a7 := JTF_NUMBER_TABLE();
351: else
352: a0 := JTF_VARCHAR2_TABLE_100();
353: a1 := JTF_NUMBER_TABLE();
354: a2 := JTF_NUMBER_TABLE();
355: a3 := JTF_NUMBER_TABLE();
356: a4 := JTF_VARCHAR2_TABLE_100();
357: a5 := JTF_NUMBER_TABLE();
358: a6 := JTF_NUMBER_TABLE();
351: else
352: a0 := JTF_VARCHAR2_TABLE_100();
353: a1 := JTF_NUMBER_TABLE();
354: a2 := JTF_NUMBER_TABLE();
355: a3 := JTF_NUMBER_TABLE();
356: a4 := JTF_VARCHAR2_TABLE_100();
357: a5 := JTF_NUMBER_TABLE();
358: a6 := JTF_NUMBER_TABLE();
359: a7 := JTF_NUMBER_TABLE();
353: a1 := JTF_NUMBER_TABLE();
354: a2 := JTF_NUMBER_TABLE();
355: a3 := JTF_NUMBER_TABLE();
356: a4 := JTF_VARCHAR2_TABLE_100();
357: a5 := JTF_NUMBER_TABLE();
358: a6 := JTF_NUMBER_TABLE();
359: a7 := JTF_NUMBER_TABLE();
360: if t.count > 0 then
361: a0.extend(t.count);
354: a2 := JTF_NUMBER_TABLE();
355: a3 := JTF_NUMBER_TABLE();
356: a4 := JTF_VARCHAR2_TABLE_100();
357: a5 := JTF_NUMBER_TABLE();
358: a6 := JTF_NUMBER_TABLE();
359: a7 := JTF_NUMBER_TABLE();
360: if t.count > 0 then
361: a0.extend(t.count);
362: a1.extend(t.count);
355: a3 := JTF_NUMBER_TABLE();
356: a4 := JTF_VARCHAR2_TABLE_100();
357: a5 := JTF_NUMBER_TABLE();
358: a6 := JTF_NUMBER_TABLE();
359: a7 := JTF_NUMBER_TABLE();
360: if t.count > 0 then
361: a0.extend(t.count);
362: a1.extend(t.count);
363: a2.extend(t.count);
386: end if;
387: end if;
388: end rosetta_table_copy_out_p4;
389:
390: procedure rosetta_table_copy_in_p6(t out nocopy lns_billing_batch_pub.bill_headers_tbl, a0 JTF_NUMBER_TABLE
391: , a1 JTF_NUMBER_TABLE
392: , a2 JTF_NUMBER_TABLE
393: , a3 JTF_DATE_TABLE
394: , a4 JTF_NUMBER_TABLE
387: end if;
388: end rosetta_table_copy_out_p4;
389:
390: procedure rosetta_table_copy_in_p6(t out nocopy lns_billing_batch_pub.bill_headers_tbl, a0 JTF_NUMBER_TABLE
391: , a1 JTF_NUMBER_TABLE
392: , a2 JTF_NUMBER_TABLE
393: , a3 JTF_DATE_TABLE
394: , a4 JTF_NUMBER_TABLE
395: , a5 JTF_NUMBER_TABLE
388: end rosetta_table_copy_out_p4;
389:
390: procedure rosetta_table_copy_in_p6(t out nocopy lns_billing_batch_pub.bill_headers_tbl, a0 JTF_NUMBER_TABLE
391: , a1 JTF_NUMBER_TABLE
392: , a2 JTF_NUMBER_TABLE
393: , a3 JTF_DATE_TABLE
394: , a4 JTF_NUMBER_TABLE
395: , a5 JTF_NUMBER_TABLE
396: ) as
390: procedure rosetta_table_copy_in_p6(t out nocopy lns_billing_batch_pub.bill_headers_tbl, a0 JTF_NUMBER_TABLE
391: , a1 JTF_NUMBER_TABLE
392: , a2 JTF_NUMBER_TABLE
393: , a3 JTF_DATE_TABLE
394: , a4 JTF_NUMBER_TABLE
395: , a5 JTF_NUMBER_TABLE
396: ) as
397: ddindx binary_integer; indx binary_integer;
398: begin
391: , a1 JTF_NUMBER_TABLE
392: , a2 JTF_NUMBER_TABLE
393: , a3 JTF_DATE_TABLE
394: , a4 JTF_NUMBER_TABLE
395: , a5 JTF_NUMBER_TABLE
396: ) as
397: ddindx binary_integer; indx binary_integer;
398: begin
399: if a0 is not null and a0.count > 0 then
415: end loop;
416: end if;
417: end if;
418: end rosetta_table_copy_in_p6;
419: procedure rosetta_table_copy_out_p6(t lns_billing_batch_pub.bill_headers_tbl, a0 out nocopy JTF_NUMBER_TABLE
420: , a1 out nocopy JTF_NUMBER_TABLE
421: , a2 out nocopy JTF_NUMBER_TABLE
422: , a3 out nocopy JTF_DATE_TABLE
423: , a4 out nocopy JTF_NUMBER_TABLE
416: end if;
417: end if;
418: end rosetta_table_copy_in_p6;
419: procedure rosetta_table_copy_out_p6(t lns_billing_batch_pub.bill_headers_tbl, a0 out nocopy JTF_NUMBER_TABLE
420: , a1 out nocopy JTF_NUMBER_TABLE
421: , a2 out nocopy JTF_NUMBER_TABLE
422: , a3 out nocopy JTF_DATE_TABLE
423: , a4 out nocopy JTF_NUMBER_TABLE
424: , a5 out nocopy JTF_NUMBER_TABLE
417: end if;
418: end rosetta_table_copy_in_p6;
419: procedure rosetta_table_copy_out_p6(t lns_billing_batch_pub.bill_headers_tbl, a0 out nocopy JTF_NUMBER_TABLE
420: , a1 out nocopy JTF_NUMBER_TABLE
421: , a2 out nocopy JTF_NUMBER_TABLE
422: , a3 out nocopy JTF_DATE_TABLE
423: , a4 out nocopy JTF_NUMBER_TABLE
424: , a5 out nocopy JTF_NUMBER_TABLE
425: ) as
419: procedure rosetta_table_copy_out_p6(t lns_billing_batch_pub.bill_headers_tbl, a0 out nocopy JTF_NUMBER_TABLE
420: , a1 out nocopy JTF_NUMBER_TABLE
421: , a2 out nocopy JTF_NUMBER_TABLE
422: , a3 out nocopy JTF_DATE_TABLE
423: , a4 out nocopy JTF_NUMBER_TABLE
424: , a5 out nocopy JTF_NUMBER_TABLE
425: ) as
426: ddindx binary_integer; indx binary_integer;
427: begin
420: , a1 out nocopy JTF_NUMBER_TABLE
421: , a2 out nocopy JTF_NUMBER_TABLE
422: , a3 out nocopy JTF_DATE_TABLE
423: , a4 out nocopy JTF_NUMBER_TABLE
424: , a5 out nocopy JTF_NUMBER_TABLE
425: ) as
426: ddindx binary_integer; indx binary_integer;
427: begin
428: if t is null or t.count = 0 then
425: ) as
426: ddindx binary_integer; indx binary_integer;
427: begin
428: if t is null or t.count = 0 then
429: a0 := JTF_NUMBER_TABLE();
430: a1 := JTF_NUMBER_TABLE();
431: a2 := JTF_NUMBER_TABLE();
432: a3 := JTF_DATE_TABLE();
433: a4 := JTF_NUMBER_TABLE();
426: ddindx binary_integer; indx binary_integer;
427: begin
428: if t is null or t.count = 0 then
429: a0 := JTF_NUMBER_TABLE();
430: a1 := JTF_NUMBER_TABLE();
431: a2 := JTF_NUMBER_TABLE();
432: a3 := JTF_DATE_TABLE();
433: a4 := JTF_NUMBER_TABLE();
434: a5 := JTF_NUMBER_TABLE();
427: begin
428: if t is null or t.count = 0 then
429: a0 := JTF_NUMBER_TABLE();
430: a1 := JTF_NUMBER_TABLE();
431: a2 := JTF_NUMBER_TABLE();
432: a3 := JTF_DATE_TABLE();
433: a4 := JTF_NUMBER_TABLE();
434: a5 := JTF_NUMBER_TABLE();
435: else
429: a0 := JTF_NUMBER_TABLE();
430: a1 := JTF_NUMBER_TABLE();
431: a2 := JTF_NUMBER_TABLE();
432: a3 := JTF_DATE_TABLE();
433: a4 := JTF_NUMBER_TABLE();
434: a5 := JTF_NUMBER_TABLE();
435: else
436: a0 := JTF_NUMBER_TABLE();
437: a1 := JTF_NUMBER_TABLE();
430: a1 := JTF_NUMBER_TABLE();
431: a2 := JTF_NUMBER_TABLE();
432: a3 := JTF_DATE_TABLE();
433: a4 := JTF_NUMBER_TABLE();
434: a5 := JTF_NUMBER_TABLE();
435: else
436: a0 := JTF_NUMBER_TABLE();
437: a1 := JTF_NUMBER_TABLE();
438: a2 := JTF_NUMBER_TABLE();
432: a3 := JTF_DATE_TABLE();
433: a4 := JTF_NUMBER_TABLE();
434: a5 := JTF_NUMBER_TABLE();
435: else
436: a0 := JTF_NUMBER_TABLE();
437: a1 := JTF_NUMBER_TABLE();
438: a2 := JTF_NUMBER_TABLE();
439: a3 := JTF_DATE_TABLE();
440: a4 := JTF_NUMBER_TABLE();
433: a4 := JTF_NUMBER_TABLE();
434: a5 := JTF_NUMBER_TABLE();
435: else
436: a0 := JTF_NUMBER_TABLE();
437: a1 := JTF_NUMBER_TABLE();
438: a2 := JTF_NUMBER_TABLE();
439: a3 := JTF_DATE_TABLE();
440: a4 := JTF_NUMBER_TABLE();
441: a5 := JTF_NUMBER_TABLE();
434: a5 := JTF_NUMBER_TABLE();
435: else
436: a0 := JTF_NUMBER_TABLE();
437: a1 := JTF_NUMBER_TABLE();
438: a2 := JTF_NUMBER_TABLE();
439: a3 := JTF_DATE_TABLE();
440: a4 := JTF_NUMBER_TABLE();
441: a5 := JTF_NUMBER_TABLE();
442: if t.count > 0 then
436: a0 := JTF_NUMBER_TABLE();
437: a1 := JTF_NUMBER_TABLE();
438: a2 := JTF_NUMBER_TABLE();
439: a3 := JTF_DATE_TABLE();
440: a4 := JTF_NUMBER_TABLE();
441: a5 := JTF_NUMBER_TABLE();
442: if t.count > 0 then
443: a0.extend(t.count);
444: a1.extend(t.count);
437: a1 := JTF_NUMBER_TABLE();
438: a2 := JTF_NUMBER_TABLE();
439: a3 := JTF_DATE_TABLE();
440: a4 := JTF_NUMBER_TABLE();
441: a5 := JTF_NUMBER_TABLE();
442: if t.count > 0 then
443: a0.extend(t.count);
444: a1.extend(t.count);
445: a2.extend(t.count);
464: end if;
465: end if;
466: end rosetta_table_copy_out_p6;
467:
468: procedure rosetta_table_copy_in_p8(t out nocopy lns_billing_batch_pub.bill_lines_tbl, a0 JTF_NUMBER_TABLE
469: , a1 JTF_NUMBER_TABLE
470: , a2 JTF_NUMBER_TABLE
471: , a3 JTF_NUMBER_TABLE
472: , a4 JTF_NUMBER_TABLE
465: end if;
466: end rosetta_table_copy_out_p6;
467:
468: procedure rosetta_table_copy_in_p8(t out nocopy lns_billing_batch_pub.bill_lines_tbl, a0 JTF_NUMBER_TABLE
469: , a1 JTF_NUMBER_TABLE
470: , a2 JTF_NUMBER_TABLE
471: , a3 JTF_NUMBER_TABLE
472: , a4 JTF_NUMBER_TABLE
473: , a5 JTF_NUMBER_TABLE
466: end rosetta_table_copy_out_p6;
467:
468: procedure rosetta_table_copy_in_p8(t out nocopy lns_billing_batch_pub.bill_lines_tbl, a0 JTF_NUMBER_TABLE
469: , a1 JTF_NUMBER_TABLE
470: , a2 JTF_NUMBER_TABLE
471: , a3 JTF_NUMBER_TABLE
472: , a4 JTF_NUMBER_TABLE
473: , a5 JTF_NUMBER_TABLE
474: , a6 JTF_NUMBER_TABLE
467:
468: procedure rosetta_table_copy_in_p8(t out nocopy lns_billing_batch_pub.bill_lines_tbl, a0 JTF_NUMBER_TABLE
469: , a1 JTF_NUMBER_TABLE
470: , a2 JTF_NUMBER_TABLE
471: , a3 JTF_NUMBER_TABLE
472: , a4 JTF_NUMBER_TABLE
473: , a5 JTF_NUMBER_TABLE
474: , a6 JTF_NUMBER_TABLE
475: , a7 JTF_VARCHAR2_TABLE_100
468: procedure rosetta_table_copy_in_p8(t out nocopy lns_billing_batch_pub.bill_lines_tbl, a0 JTF_NUMBER_TABLE
469: , a1 JTF_NUMBER_TABLE
470: , a2 JTF_NUMBER_TABLE
471: , a3 JTF_NUMBER_TABLE
472: , a4 JTF_NUMBER_TABLE
473: , a5 JTF_NUMBER_TABLE
474: , a6 JTF_NUMBER_TABLE
475: , a7 JTF_VARCHAR2_TABLE_100
476: , a8 JTF_VARCHAR2_TABLE_300
469: , a1 JTF_NUMBER_TABLE
470: , a2 JTF_NUMBER_TABLE
471: , a3 JTF_NUMBER_TABLE
472: , a4 JTF_NUMBER_TABLE
473: , a5 JTF_NUMBER_TABLE
474: , a6 JTF_NUMBER_TABLE
475: , a7 JTF_VARCHAR2_TABLE_100
476: , a8 JTF_VARCHAR2_TABLE_300
477: , a9 JTF_NUMBER_TABLE
470: , a2 JTF_NUMBER_TABLE
471: , a3 JTF_NUMBER_TABLE
472: , a4 JTF_NUMBER_TABLE
473: , a5 JTF_NUMBER_TABLE
474: , a6 JTF_NUMBER_TABLE
475: , a7 JTF_VARCHAR2_TABLE_100
476: , a8 JTF_VARCHAR2_TABLE_300
477: , a9 JTF_NUMBER_TABLE
478: , a10 JTF_NUMBER_TABLE
473: , a5 JTF_NUMBER_TABLE
474: , a6 JTF_NUMBER_TABLE
475: , a7 JTF_VARCHAR2_TABLE_100
476: , a8 JTF_VARCHAR2_TABLE_300
477: , a9 JTF_NUMBER_TABLE
478: , a10 JTF_NUMBER_TABLE
479: , a11 JTF_NUMBER_TABLE
480: , a12 JTF_NUMBER_TABLE
481: , a13 JTF_VARCHAR2_TABLE_2000
474: , a6 JTF_NUMBER_TABLE
475: , a7 JTF_VARCHAR2_TABLE_100
476: , a8 JTF_VARCHAR2_TABLE_300
477: , a9 JTF_NUMBER_TABLE
478: , a10 JTF_NUMBER_TABLE
479: , a11 JTF_NUMBER_TABLE
480: , a12 JTF_NUMBER_TABLE
481: , a13 JTF_VARCHAR2_TABLE_2000
482: ) as
475: , a7 JTF_VARCHAR2_TABLE_100
476: , a8 JTF_VARCHAR2_TABLE_300
477: , a9 JTF_NUMBER_TABLE
478: , a10 JTF_NUMBER_TABLE
479: , a11 JTF_NUMBER_TABLE
480: , a12 JTF_NUMBER_TABLE
481: , a13 JTF_VARCHAR2_TABLE_2000
482: ) as
483: ddindx binary_integer; indx binary_integer;
476: , a8 JTF_VARCHAR2_TABLE_300
477: , a9 JTF_NUMBER_TABLE
478: , a10 JTF_NUMBER_TABLE
479: , a11 JTF_NUMBER_TABLE
480: , a12 JTF_NUMBER_TABLE
481: , a13 JTF_VARCHAR2_TABLE_2000
482: ) as
483: ddindx binary_integer; indx binary_integer;
484: begin
509: end loop;
510: end if;
511: end if;
512: end rosetta_table_copy_in_p8;
513: procedure rosetta_table_copy_out_p8(t lns_billing_batch_pub.bill_lines_tbl, a0 out nocopy JTF_NUMBER_TABLE
514: , a1 out nocopy JTF_NUMBER_TABLE
515: , a2 out nocopy JTF_NUMBER_TABLE
516: , a3 out nocopy JTF_NUMBER_TABLE
517: , a4 out nocopy JTF_NUMBER_TABLE
510: end if;
511: end if;
512: end rosetta_table_copy_in_p8;
513: procedure rosetta_table_copy_out_p8(t lns_billing_batch_pub.bill_lines_tbl, a0 out nocopy JTF_NUMBER_TABLE
514: , a1 out nocopy JTF_NUMBER_TABLE
515: , a2 out nocopy JTF_NUMBER_TABLE
516: , a3 out nocopy JTF_NUMBER_TABLE
517: , a4 out nocopy JTF_NUMBER_TABLE
518: , a5 out nocopy JTF_NUMBER_TABLE
511: end if;
512: end rosetta_table_copy_in_p8;
513: procedure rosetta_table_copy_out_p8(t lns_billing_batch_pub.bill_lines_tbl, a0 out nocopy JTF_NUMBER_TABLE
514: , a1 out nocopy JTF_NUMBER_TABLE
515: , a2 out nocopy JTF_NUMBER_TABLE
516: , a3 out nocopy JTF_NUMBER_TABLE
517: , a4 out nocopy JTF_NUMBER_TABLE
518: , a5 out nocopy JTF_NUMBER_TABLE
519: , a6 out nocopy JTF_NUMBER_TABLE
512: end rosetta_table_copy_in_p8;
513: procedure rosetta_table_copy_out_p8(t lns_billing_batch_pub.bill_lines_tbl, a0 out nocopy JTF_NUMBER_TABLE
514: , a1 out nocopy JTF_NUMBER_TABLE
515: , a2 out nocopy JTF_NUMBER_TABLE
516: , a3 out nocopy JTF_NUMBER_TABLE
517: , a4 out nocopy JTF_NUMBER_TABLE
518: , a5 out nocopy JTF_NUMBER_TABLE
519: , a6 out nocopy JTF_NUMBER_TABLE
520: , a7 out nocopy JTF_VARCHAR2_TABLE_100
513: procedure rosetta_table_copy_out_p8(t lns_billing_batch_pub.bill_lines_tbl, a0 out nocopy JTF_NUMBER_TABLE
514: , a1 out nocopy JTF_NUMBER_TABLE
515: , a2 out nocopy JTF_NUMBER_TABLE
516: , a3 out nocopy JTF_NUMBER_TABLE
517: , a4 out nocopy JTF_NUMBER_TABLE
518: , a5 out nocopy JTF_NUMBER_TABLE
519: , a6 out nocopy JTF_NUMBER_TABLE
520: , a7 out nocopy JTF_VARCHAR2_TABLE_100
521: , a8 out nocopy JTF_VARCHAR2_TABLE_300
514: , a1 out nocopy JTF_NUMBER_TABLE
515: , a2 out nocopy JTF_NUMBER_TABLE
516: , a3 out nocopy JTF_NUMBER_TABLE
517: , a4 out nocopy JTF_NUMBER_TABLE
518: , a5 out nocopy JTF_NUMBER_TABLE
519: , a6 out nocopy JTF_NUMBER_TABLE
520: , a7 out nocopy JTF_VARCHAR2_TABLE_100
521: , a8 out nocopy JTF_VARCHAR2_TABLE_300
522: , a9 out nocopy JTF_NUMBER_TABLE
515: , a2 out nocopy JTF_NUMBER_TABLE
516: , a3 out nocopy JTF_NUMBER_TABLE
517: , a4 out nocopy JTF_NUMBER_TABLE
518: , a5 out nocopy JTF_NUMBER_TABLE
519: , a6 out nocopy JTF_NUMBER_TABLE
520: , a7 out nocopy JTF_VARCHAR2_TABLE_100
521: , a8 out nocopy JTF_VARCHAR2_TABLE_300
522: , a9 out nocopy JTF_NUMBER_TABLE
523: , a10 out nocopy JTF_NUMBER_TABLE
518: , a5 out nocopy JTF_NUMBER_TABLE
519: , a6 out nocopy JTF_NUMBER_TABLE
520: , a7 out nocopy JTF_VARCHAR2_TABLE_100
521: , a8 out nocopy JTF_VARCHAR2_TABLE_300
522: , a9 out nocopy JTF_NUMBER_TABLE
523: , a10 out nocopy JTF_NUMBER_TABLE
524: , a11 out nocopy JTF_NUMBER_TABLE
525: , a12 out nocopy JTF_NUMBER_TABLE
526: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
519: , a6 out nocopy JTF_NUMBER_TABLE
520: , a7 out nocopy JTF_VARCHAR2_TABLE_100
521: , a8 out nocopy JTF_VARCHAR2_TABLE_300
522: , a9 out nocopy JTF_NUMBER_TABLE
523: , a10 out nocopy JTF_NUMBER_TABLE
524: , a11 out nocopy JTF_NUMBER_TABLE
525: , a12 out nocopy JTF_NUMBER_TABLE
526: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
527: ) as
520: , a7 out nocopy JTF_VARCHAR2_TABLE_100
521: , a8 out nocopy JTF_VARCHAR2_TABLE_300
522: , a9 out nocopy JTF_NUMBER_TABLE
523: , a10 out nocopy JTF_NUMBER_TABLE
524: , a11 out nocopy JTF_NUMBER_TABLE
525: , a12 out nocopy JTF_NUMBER_TABLE
526: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
527: ) as
528: ddindx binary_integer; indx binary_integer;
521: , a8 out nocopy JTF_VARCHAR2_TABLE_300
522: , a9 out nocopy JTF_NUMBER_TABLE
523: , a10 out nocopy JTF_NUMBER_TABLE
524: , a11 out nocopy JTF_NUMBER_TABLE
525: , a12 out nocopy JTF_NUMBER_TABLE
526: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
527: ) as
528: ddindx binary_integer; indx binary_integer;
529: begin
527: ) as
528: ddindx binary_integer; indx binary_integer;
529: begin
530: if t is null or t.count = 0 then
531: a0 := JTF_NUMBER_TABLE();
532: a1 := JTF_NUMBER_TABLE();
533: a2 := JTF_NUMBER_TABLE();
534: a3 := JTF_NUMBER_TABLE();
535: a4 := JTF_NUMBER_TABLE();
528: ddindx binary_integer; indx binary_integer;
529: begin
530: if t is null or t.count = 0 then
531: a0 := JTF_NUMBER_TABLE();
532: a1 := JTF_NUMBER_TABLE();
533: a2 := JTF_NUMBER_TABLE();
534: a3 := JTF_NUMBER_TABLE();
535: a4 := JTF_NUMBER_TABLE();
536: a5 := JTF_NUMBER_TABLE();
529: begin
530: if t is null or t.count = 0 then
531: a0 := JTF_NUMBER_TABLE();
532: a1 := JTF_NUMBER_TABLE();
533: a2 := JTF_NUMBER_TABLE();
534: a3 := JTF_NUMBER_TABLE();
535: a4 := JTF_NUMBER_TABLE();
536: a5 := JTF_NUMBER_TABLE();
537: a6 := JTF_NUMBER_TABLE();
530: if t is null or t.count = 0 then
531: a0 := JTF_NUMBER_TABLE();
532: a1 := JTF_NUMBER_TABLE();
533: a2 := JTF_NUMBER_TABLE();
534: a3 := JTF_NUMBER_TABLE();
535: a4 := JTF_NUMBER_TABLE();
536: a5 := JTF_NUMBER_TABLE();
537: a6 := JTF_NUMBER_TABLE();
538: a7 := JTF_VARCHAR2_TABLE_100();
531: a0 := JTF_NUMBER_TABLE();
532: a1 := JTF_NUMBER_TABLE();
533: a2 := JTF_NUMBER_TABLE();
534: a3 := JTF_NUMBER_TABLE();
535: a4 := JTF_NUMBER_TABLE();
536: a5 := JTF_NUMBER_TABLE();
537: a6 := JTF_NUMBER_TABLE();
538: a7 := JTF_VARCHAR2_TABLE_100();
539: a8 := JTF_VARCHAR2_TABLE_300();
532: a1 := JTF_NUMBER_TABLE();
533: a2 := JTF_NUMBER_TABLE();
534: a3 := JTF_NUMBER_TABLE();
535: a4 := JTF_NUMBER_TABLE();
536: a5 := JTF_NUMBER_TABLE();
537: a6 := JTF_NUMBER_TABLE();
538: a7 := JTF_VARCHAR2_TABLE_100();
539: a8 := JTF_VARCHAR2_TABLE_300();
540: a9 := JTF_NUMBER_TABLE();
533: a2 := JTF_NUMBER_TABLE();
534: a3 := JTF_NUMBER_TABLE();
535: a4 := JTF_NUMBER_TABLE();
536: a5 := JTF_NUMBER_TABLE();
537: a6 := JTF_NUMBER_TABLE();
538: a7 := JTF_VARCHAR2_TABLE_100();
539: a8 := JTF_VARCHAR2_TABLE_300();
540: a9 := JTF_NUMBER_TABLE();
541: a10 := JTF_NUMBER_TABLE();
536: a5 := JTF_NUMBER_TABLE();
537: a6 := JTF_NUMBER_TABLE();
538: a7 := JTF_VARCHAR2_TABLE_100();
539: a8 := JTF_VARCHAR2_TABLE_300();
540: a9 := JTF_NUMBER_TABLE();
541: a10 := JTF_NUMBER_TABLE();
542: a11 := JTF_NUMBER_TABLE();
543: a12 := JTF_NUMBER_TABLE();
544: a13 := JTF_VARCHAR2_TABLE_2000();
537: a6 := JTF_NUMBER_TABLE();
538: a7 := JTF_VARCHAR2_TABLE_100();
539: a8 := JTF_VARCHAR2_TABLE_300();
540: a9 := JTF_NUMBER_TABLE();
541: a10 := JTF_NUMBER_TABLE();
542: a11 := JTF_NUMBER_TABLE();
543: a12 := JTF_NUMBER_TABLE();
544: a13 := JTF_VARCHAR2_TABLE_2000();
545: else
538: a7 := JTF_VARCHAR2_TABLE_100();
539: a8 := JTF_VARCHAR2_TABLE_300();
540: a9 := JTF_NUMBER_TABLE();
541: a10 := JTF_NUMBER_TABLE();
542: a11 := JTF_NUMBER_TABLE();
543: a12 := JTF_NUMBER_TABLE();
544: a13 := JTF_VARCHAR2_TABLE_2000();
545: else
546: a0 := JTF_NUMBER_TABLE();
539: a8 := JTF_VARCHAR2_TABLE_300();
540: a9 := JTF_NUMBER_TABLE();
541: a10 := JTF_NUMBER_TABLE();
542: a11 := JTF_NUMBER_TABLE();
543: a12 := JTF_NUMBER_TABLE();
544: a13 := JTF_VARCHAR2_TABLE_2000();
545: else
546: a0 := JTF_NUMBER_TABLE();
547: a1 := JTF_NUMBER_TABLE();
542: a11 := JTF_NUMBER_TABLE();
543: a12 := JTF_NUMBER_TABLE();
544: a13 := JTF_VARCHAR2_TABLE_2000();
545: else
546: a0 := JTF_NUMBER_TABLE();
547: a1 := JTF_NUMBER_TABLE();
548: a2 := JTF_NUMBER_TABLE();
549: a3 := JTF_NUMBER_TABLE();
550: a4 := JTF_NUMBER_TABLE();
543: a12 := JTF_NUMBER_TABLE();
544: a13 := JTF_VARCHAR2_TABLE_2000();
545: else
546: a0 := JTF_NUMBER_TABLE();
547: a1 := JTF_NUMBER_TABLE();
548: a2 := JTF_NUMBER_TABLE();
549: a3 := JTF_NUMBER_TABLE();
550: a4 := JTF_NUMBER_TABLE();
551: a5 := JTF_NUMBER_TABLE();
544: a13 := JTF_VARCHAR2_TABLE_2000();
545: else
546: a0 := JTF_NUMBER_TABLE();
547: a1 := JTF_NUMBER_TABLE();
548: a2 := JTF_NUMBER_TABLE();
549: a3 := JTF_NUMBER_TABLE();
550: a4 := JTF_NUMBER_TABLE();
551: a5 := JTF_NUMBER_TABLE();
552: a6 := JTF_NUMBER_TABLE();
545: else
546: a0 := JTF_NUMBER_TABLE();
547: a1 := JTF_NUMBER_TABLE();
548: a2 := JTF_NUMBER_TABLE();
549: a3 := JTF_NUMBER_TABLE();
550: a4 := JTF_NUMBER_TABLE();
551: a5 := JTF_NUMBER_TABLE();
552: a6 := JTF_NUMBER_TABLE();
553: a7 := JTF_VARCHAR2_TABLE_100();
546: a0 := JTF_NUMBER_TABLE();
547: a1 := JTF_NUMBER_TABLE();
548: a2 := JTF_NUMBER_TABLE();
549: a3 := JTF_NUMBER_TABLE();
550: a4 := JTF_NUMBER_TABLE();
551: a5 := JTF_NUMBER_TABLE();
552: a6 := JTF_NUMBER_TABLE();
553: a7 := JTF_VARCHAR2_TABLE_100();
554: a8 := JTF_VARCHAR2_TABLE_300();
547: a1 := JTF_NUMBER_TABLE();
548: a2 := JTF_NUMBER_TABLE();
549: a3 := JTF_NUMBER_TABLE();
550: a4 := JTF_NUMBER_TABLE();
551: a5 := JTF_NUMBER_TABLE();
552: a6 := JTF_NUMBER_TABLE();
553: a7 := JTF_VARCHAR2_TABLE_100();
554: a8 := JTF_VARCHAR2_TABLE_300();
555: a9 := JTF_NUMBER_TABLE();
548: a2 := JTF_NUMBER_TABLE();
549: a3 := JTF_NUMBER_TABLE();
550: a4 := JTF_NUMBER_TABLE();
551: a5 := JTF_NUMBER_TABLE();
552: a6 := JTF_NUMBER_TABLE();
553: a7 := JTF_VARCHAR2_TABLE_100();
554: a8 := JTF_VARCHAR2_TABLE_300();
555: a9 := JTF_NUMBER_TABLE();
556: a10 := JTF_NUMBER_TABLE();
551: a5 := JTF_NUMBER_TABLE();
552: a6 := JTF_NUMBER_TABLE();
553: a7 := JTF_VARCHAR2_TABLE_100();
554: a8 := JTF_VARCHAR2_TABLE_300();
555: a9 := JTF_NUMBER_TABLE();
556: a10 := JTF_NUMBER_TABLE();
557: a11 := JTF_NUMBER_TABLE();
558: a12 := JTF_NUMBER_TABLE();
559: a13 := JTF_VARCHAR2_TABLE_2000();
552: a6 := JTF_NUMBER_TABLE();
553: a7 := JTF_VARCHAR2_TABLE_100();
554: a8 := JTF_VARCHAR2_TABLE_300();
555: a9 := JTF_NUMBER_TABLE();
556: a10 := JTF_NUMBER_TABLE();
557: a11 := JTF_NUMBER_TABLE();
558: a12 := JTF_NUMBER_TABLE();
559: a13 := JTF_VARCHAR2_TABLE_2000();
560: if t.count > 0 then
553: a7 := JTF_VARCHAR2_TABLE_100();
554: a8 := JTF_VARCHAR2_TABLE_300();
555: a9 := JTF_NUMBER_TABLE();
556: a10 := JTF_NUMBER_TABLE();
557: a11 := JTF_NUMBER_TABLE();
558: a12 := JTF_NUMBER_TABLE();
559: a13 := JTF_VARCHAR2_TABLE_2000();
560: if t.count > 0 then
561: a0.extend(t.count);
554: a8 := JTF_VARCHAR2_TABLE_300();
555: a9 := JTF_NUMBER_TABLE();
556: a10 := JTF_NUMBER_TABLE();
557: a11 := JTF_NUMBER_TABLE();
558: a12 := JTF_NUMBER_TABLE();
559: a13 := JTF_VARCHAR2_TABLE_2000();
560: if t.count > 0 then
561: a0.extend(t.count);
562: a1.extend(t.count);
598: end if;
599: end if;
600: end rosetta_table_copy_out_p8;
601:
602: procedure rosetta_table_copy_in_p10(t out nocopy lns_billing_batch_pub.invoice_details_tbl, a0 JTF_NUMBER_TABLE
603: , a1 JTF_NUMBER_TABLE
604: , a2 JTF_VARCHAR2_TABLE_100
605: , a3 JTF_NUMBER_TABLE
606: , a4 JTF_VARCHAR2_TABLE_100
599: end if;
600: end rosetta_table_copy_out_p8;
601:
602: procedure rosetta_table_copy_in_p10(t out nocopy lns_billing_batch_pub.invoice_details_tbl, a0 JTF_NUMBER_TABLE
603: , a1 JTF_NUMBER_TABLE
604: , a2 JTF_VARCHAR2_TABLE_100
605: , a3 JTF_NUMBER_TABLE
606: , a4 JTF_VARCHAR2_TABLE_100
607: , a5 JTF_NUMBER_TABLE
601:
602: procedure rosetta_table_copy_in_p10(t out nocopy lns_billing_batch_pub.invoice_details_tbl, a0 JTF_NUMBER_TABLE
603: , a1 JTF_NUMBER_TABLE
604: , a2 JTF_VARCHAR2_TABLE_100
605: , a3 JTF_NUMBER_TABLE
606: , a4 JTF_VARCHAR2_TABLE_100
607: , a5 JTF_NUMBER_TABLE
608: , a6 JTF_NUMBER_TABLE
609: , a7 JTF_NUMBER_TABLE
603: , a1 JTF_NUMBER_TABLE
604: , a2 JTF_VARCHAR2_TABLE_100
605: , a3 JTF_NUMBER_TABLE
606: , a4 JTF_VARCHAR2_TABLE_100
607: , a5 JTF_NUMBER_TABLE
608: , a6 JTF_NUMBER_TABLE
609: , a7 JTF_NUMBER_TABLE
610: , a8 JTF_DATE_TABLE
611: , a9 JTF_DATE_TABLE
604: , a2 JTF_VARCHAR2_TABLE_100
605: , a3 JTF_NUMBER_TABLE
606: , a4 JTF_VARCHAR2_TABLE_100
607: , a5 JTF_NUMBER_TABLE
608: , a6 JTF_NUMBER_TABLE
609: , a7 JTF_NUMBER_TABLE
610: , a8 JTF_DATE_TABLE
611: , a9 JTF_DATE_TABLE
612: , a10 JTF_DATE_TABLE
605: , a3 JTF_NUMBER_TABLE
606: , a4 JTF_VARCHAR2_TABLE_100
607: , a5 JTF_NUMBER_TABLE
608: , a6 JTF_NUMBER_TABLE
609: , a7 JTF_NUMBER_TABLE
610: , a8 JTF_DATE_TABLE
611: , a9 JTF_DATE_TABLE
612: , a10 JTF_DATE_TABLE
613: , a11 JTF_VARCHAR2_TABLE_100
612: , a10 JTF_DATE_TABLE
613: , a11 JTF_VARCHAR2_TABLE_100
614: , a12 JTF_VARCHAR2_TABLE_100
615: , a13 JTF_VARCHAR2_TABLE_100
616: , a14 JTF_NUMBER_TABLE
617: ) as
618: ddindx binary_integer; indx binary_integer;
619: begin
620: if a0 is not null and a0.count > 0 then
645: end loop;
646: end if;
647: end if;
648: end rosetta_table_copy_in_p10;
649: procedure rosetta_table_copy_out_p10(t lns_billing_batch_pub.invoice_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
650: , a1 out nocopy JTF_NUMBER_TABLE
651: , a2 out nocopy JTF_VARCHAR2_TABLE_100
652: , a3 out nocopy JTF_NUMBER_TABLE
653: , a4 out nocopy JTF_VARCHAR2_TABLE_100
646: end if;
647: end if;
648: end rosetta_table_copy_in_p10;
649: procedure rosetta_table_copy_out_p10(t lns_billing_batch_pub.invoice_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
650: , a1 out nocopy JTF_NUMBER_TABLE
651: , a2 out nocopy JTF_VARCHAR2_TABLE_100
652: , a3 out nocopy JTF_NUMBER_TABLE
653: , a4 out nocopy JTF_VARCHAR2_TABLE_100
654: , a5 out nocopy JTF_NUMBER_TABLE
648: end rosetta_table_copy_in_p10;
649: procedure rosetta_table_copy_out_p10(t lns_billing_batch_pub.invoice_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
650: , a1 out nocopy JTF_NUMBER_TABLE
651: , a2 out nocopy JTF_VARCHAR2_TABLE_100
652: , a3 out nocopy JTF_NUMBER_TABLE
653: , a4 out nocopy JTF_VARCHAR2_TABLE_100
654: , a5 out nocopy JTF_NUMBER_TABLE
655: , a6 out nocopy JTF_NUMBER_TABLE
656: , a7 out nocopy JTF_NUMBER_TABLE
650: , a1 out nocopy JTF_NUMBER_TABLE
651: , a2 out nocopy JTF_VARCHAR2_TABLE_100
652: , a3 out nocopy JTF_NUMBER_TABLE
653: , a4 out nocopy JTF_VARCHAR2_TABLE_100
654: , a5 out nocopy JTF_NUMBER_TABLE
655: , a6 out nocopy JTF_NUMBER_TABLE
656: , a7 out nocopy JTF_NUMBER_TABLE
657: , a8 out nocopy JTF_DATE_TABLE
658: , a9 out nocopy JTF_DATE_TABLE
651: , a2 out nocopy JTF_VARCHAR2_TABLE_100
652: , a3 out nocopy JTF_NUMBER_TABLE
653: , a4 out nocopy JTF_VARCHAR2_TABLE_100
654: , a5 out nocopy JTF_NUMBER_TABLE
655: , a6 out nocopy JTF_NUMBER_TABLE
656: , a7 out nocopy JTF_NUMBER_TABLE
657: , a8 out nocopy JTF_DATE_TABLE
658: , a9 out nocopy JTF_DATE_TABLE
659: , a10 out nocopy JTF_DATE_TABLE
652: , a3 out nocopy JTF_NUMBER_TABLE
653: , a4 out nocopy JTF_VARCHAR2_TABLE_100
654: , a5 out nocopy JTF_NUMBER_TABLE
655: , a6 out nocopy JTF_NUMBER_TABLE
656: , a7 out nocopy JTF_NUMBER_TABLE
657: , a8 out nocopy JTF_DATE_TABLE
658: , a9 out nocopy JTF_DATE_TABLE
659: , a10 out nocopy JTF_DATE_TABLE
660: , a11 out nocopy JTF_VARCHAR2_TABLE_100
659: , a10 out nocopy JTF_DATE_TABLE
660: , a11 out nocopy JTF_VARCHAR2_TABLE_100
661: , a12 out nocopy JTF_VARCHAR2_TABLE_100
662: , a13 out nocopy JTF_VARCHAR2_TABLE_100
663: , a14 out nocopy JTF_NUMBER_TABLE
664: ) as
665: ddindx binary_integer; indx binary_integer;
666: begin
667: if t is null or t.count = 0 then
664: ) as
665: ddindx binary_integer; indx binary_integer;
666: begin
667: if t is null or t.count = 0 then
668: a0 := JTF_NUMBER_TABLE();
669: a1 := JTF_NUMBER_TABLE();
670: a2 := JTF_VARCHAR2_TABLE_100();
671: a3 := JTF_NUMBER_TABLE();
672: a4 := JTF_VARCHAR2_TABLE_100();
665: ddindx binary_integer; indx binary_integer;
666: begin
667: if t is null or t.count = 0 then
668: a0 := JTF_NUMBER_TABLE();
669: a1 := JTF_NUMBER_TABLE();
670: a2 := JTF_VARCHAR2_TABLE_100();
671: a3 := JTF_NUMBER_TABLE();
672: a4 := JTF_VARCHAR2_TABLE_100();
673: a5 := JTF_NUMBER_TABLE();
667: if t is null or t.count = 0 then
668: a0 := JTF_NUMBER_TABLE();
669: a1 := JTF_NUMBER_TABLE();
670: a2 := JTF_VARCHAR2_TABLE_100();
671: a3 := JTF_NUMBER_TABLE();
672: a4 := JTF_VARCHAR2_TABLE_100();
673: a5 := JTF_NUMBER_TABLE();
674: a6 := JTF_NUMBER_TABLE();
675: a7 := JTF_NUMBER_TABLE();
669: a1 := JTF_NUMBER_TABLE();
670: a2 := JTF_VARCHAR2_TABLE_100();
671: a3 := JTF_NUMBER_TABLE();
672: a4 := JTF_VARCHAR2_TABLE_100();
673: a5 := JTF_NUMBER_TABLE();
674: a6 := JTF_NUMBER_TABLE();
675: a7 := JTF_NUMBER_TABLE();
676: a8 := JTF_DATE_TABLE();
677: a9 := JTF_DATE_TABLE();
670: a2 := JTF_VARCHAR2_TABLE_100();
671: a3 := JTF_NUMBER_TABLE();
672: a4 := JTF_VARCHAR2_TABLE_100();
673: a5 := JTF_NUMBER_TABLE();
674: a6 := JTF_NUMBER_TABLE();
675: a7 := JTF_NUMBER_TABLE();
676: a8 := JTF_DATE_TABLE();
677: a9 := JTF_DATE_TABLE();
678: a10 := JTF_DATE_TABLE();
671: a3 := JTF_NUMBER_TABLE();
672: a4 := JTF_VARCHAR2_TABLE_100();
673: a5 := JTF_NUMBER_TABLE();
674: a6 := JTF_NUMBER_TABLE();
675: a7 := JTF_NUMBER_TABLE();
676: a8 := JTF_DATE_TABLE();
677: a9 := JTF_DATE_TABLE();
678: a10 := JTF_DATE_TABLE();
679: a11 := JTF_VARCHAR2_TABLE_100();
678: a10 := JTF_DATE_TABLE();
679: a11 := JTF_VARCHAR2_TABLE_100();
680: a12 := JTF_VARCHAR2_TABLE_100();
681: a13 := JTF_VARCHAR2_TABLE_100();
682: a14 := JTF_NUMBER_TABLE();
683: else
684: a0 := JTF_NUMBER_TABLE();
685: a1 := JTF_NUMBER_TABLE();
686: a2 := JTF_VARCHAR2_TABLE_100();
680: a12 := JTF_VARCHAR2_TABLE_100();
681: a13 := JTF_VARCHAR2_TABLE_100();
682: a14 := JTF_NUMBER_TABLE();
683: else
684: a0 := JTF_NUMBER_TABLE();
685: a1 := JTF_NUMBER_TABLE();
686: a2 := JTF_VARCHAR2_TABLE_100();
687: a3 := JTF_NUMBER_TABLE();
688: a4 := JTF_VARCHAR2_TABLE_100();
681: a13 := JTF_VARCHAR2_TABLE_100();
682: a14 := JTF_NUMBER_TABLE();
683: else
684: a0 := JTF_NUMBER_TABLE();
685: a1 := JTF_NUMBER_TABLE();
686: a2 := JTF_VARCHAR2_TABLE_100();
687: a3 := JTF_NUMBER_TABLE();
688: a4 := JTF_VARCHAR2_TABLE_100();
689: a5 := JTF_NUMBER_TABLE();
683: else
684: a0 := JTF_NUMBER_TABLE();
685: a1 := JTF_NUMBER_TABLE();
686: a2 := JTF_VARCHAR2_TABLE_100();
687: a3 := JTF_NUMBER_TABLE();
688: a4 := JTF_VARCHAR2_TABLE_100();
689: a5 := JTF_NUMBER_TABLE();
690: a6 := JTF_NUMBER_TABLE();
691: a7 := JTF_NUMBER_TABLE();
685: a1 := JTF_NUMBER_TABLE();
686: a2 := JTF_VARCHAR2_TABLE_100();
687: a3 := JTF_NUMBER_TABLE();
688: a4 := JTF_VARCHAR2_TABLE_100();
689: a5 := JTF_NUMBER_TABLE();
690: a6 := JTF_NUMBER_TABLE();
691: a7 := JTF_NUMBER_TABLE();
692: a8 := JTF_DATE_TABLE();
693: a9 := JTF_DATE_TABLE();
686: a2 := JTF_VARCHAR2_TABLE_100();
687: a3 := JTF_NUMBER_TABLE();
688: a4 := JTF_VARCHAR2_TABLE_100();
689: a5 := JTF_NUMBER_TABLE();
690: a6 := JTF_NUMBER_TABLE();
691: a7 := JTF_NUMBER_TABLE();
692: a8 := JTF_DATE_TABLE();
693: a9 := JTF_DATE_TABLE();
694: a10 := JTF_DATE_TABLE();
687: a3 := JTF_NUMBER_TABLE();
688: a4 := JTF_VARCHAR2_TABLE_100();
689: a5 := JTF_NUMBER_TABLE();
690: a6 := JTF_NUMBER_TABLE();
691: a7 := JTF_NUMBER_TABLE();
692: a8 := JTF_DATE_TABLE();
693: a9 := JTF_DATE_TABLE();
694: a10 := JTF_DATE_TABLE();
695: a11 := JTF_VARCHAR2_TABLE_100();
694: a10 := JTF_DATE_TABLE();
695: a11 := JTF_VARCHAR2_TABLE_100();
696: a12 := JTF_VARCHAR2_TABLE_100();
697: a13 := JTF_VARCHAR2_TABLE_100();
698: a14 := JTF_NUMBER_TABLE();
699: if t.count > 0 then
700: a0.extend(t.count);
701: a1.extend(t.count);
702: a2.extend(t.count);
739: end if;
740: end if;
741: end rosetta_table_copy_out_p10;
742:
743: procedure rosetta_table_copy_in_p12(t out nocopy lns_billing_batch_pub.cash_receipt_tbl, a0 JTF_NUMBER_TABLE
744: , a1 JTF_NUMBER_TABLE
745: , a2 JTF_VARCHAR2_TABLE_100
746: , a3 JTF_NUMBER_TABLE
747: , a4 JTF_DATE_TABLE
740: end if;
741: end rosetta_table_copy_out_p10;
742:
743: procedure rosetta_table_copy_in_p12(t out nocopy lns_billing_batch_pub.cash_receipt_tbl, a0 JTF_NUMBER_TABLE
744: , a1 JTF_NUMBER_TABLE
745: , a2 JTF_VARCHAR2_TABLE_100
746: , a3 JTF_NUMBER_TABLE
747: , a4 JTF_DATE_TABLE
748: , a5 JTF_VARCHAR2_TABLE_100
742:
743: procedure rosetta_table_copy_in_p12(t out nocopy lns_billing_batch_pub.cash_receipt_tbl, a0 JTF_NUMBER_TABLE
744: , a1 JTF_NUMBER_TABLE
745: , a2 JTF_VARCHAR2_TABLE_100
746: , a3 JTF_NUMBER_TABLE
747: , a4 JTF_DATE_TABLE
748: , a5 JTF_VARCHAR2_TABLE_100
749: , a6 JTF_VARCHAR2_TABLE_100
750: , a7 JTF_VARCHAR2_TABLE_100
776: end loop;
777: end if;
778: end if;
779: end rosetta_table_copy_in_p12;
780: procedure rosetta_table_copy_out_p12(t lns_billing_batch_pub.cash_receipt_tbl, a0 out nocopy JTF_NUMBER_TABLE
781: , a1 out nocopy JTF_NUMBER_TABLE
782: , a2 out nocopy JTF_VARCHAR2_TABLE_100
783: , a3 out nocopy JTF_NUMBER_TABLE
784: , a4 out nocopy JTF_DATE_TABLE
777: end if;
778: end if;
779: end rosetta_table_copy_in_p12;
780: procedure rosetta_table_copy_out_p12(t lns_billing_batch_pub.cash_receipt_tbl, a0 out nocopy JTF_NUMBER_TABLE
781: , a1 out nocopy JTF_NUMBER_TABLE
782: , a2 out nocopy JTF_VARCHAR2_TABLE_100
783: , a3 out nocopy JTF_NUMBER_TABLE
784: , a4 out nocopy JTF_DATE_TABLE
785: , a5 out nocopy JTF_VARCHAR2_TABLE_100
779: end rosetta_table_copy_in_p12;
780: procedure rosetta_table_copy_out_p12(t lns_billing_batch_pub.cash_receipt_tbl, a0 out nocopy JTF_NUMBER_TABLE
781: , a1 out nocopy JTF_NUMBER_TABLE
782: , a2 out nocopy JTF_VARCHAR2_TABLE_100
783: , a3 out nocopy JTF_NUMBER_TABLE
784: , a4 out nocopy JTF_DATE_TABLE
785: , a5 out nocopy JTF_VARCHAR2_TABLE_100
786: , a6 out nocopy JTF_VARCHAR2_TABLE_100
787: , a7 out nocopy JTF_VARCHAR2_TABLE_100
790: ) as
791: ddindx binary_integer; indx binary_integer;
792: begin
793: if t is null or t.count = 0 then
794: a0 := JTF_NUMBER_TABLE();
795: a1 := JTF_NUMBER_TABLE();
796: a2 := JTF_VARCHAR2_TABLE_100();
797: a3 := JTF_NUMBER_TABLE();
798: a4 := JTF_DATE_TABLE();
791: ddindx binary_integer; indx binary_integer;
792: begin
793: if t is null or t.count = 0 then
794: a0 := JTF_NUMBER_TABLE();
795: a1 := JTF_NUMBER_TABLE();
796: a2 := JTF_VARCHAR2_TABLE_100();
797: a3 := JTF_NUMBER_TABLE();
798: a4 := JTF_DATE_TABLE();
799: a5 := JTF_VARCHAR2_TABLE_100();
793: if t is null or t.count = 0 then
794: a0 := JTF_NUMBER_TABLE();
795: a1 := JTF_NUMBER_TABLE();
796: a2 := JTF_VARCHAR2_TABLE_100();
797: a3 := JTF_NUMBER_TABLE();
798: a4 := JTF_DATE_TABLE();
799: a5 := JTF_VARCHAR2_TABLE_100();
800: a6 := JTF_VARCHAR2_TABLE_100();
801: a7 := JTF_VARCHAR2_TABLE_100();
801: a7 := JTF_VARCHAR2_TABLE_100();
802: a8 := JTF_DATE_TABLE();
803: a9 := JTF_DATE_TABLE();
804: else
805: a0 := JTF_NUMBER_TABLE();
806: a1 := JTF_NUMBER_TABLE();
807: a2 := JTF_VARCHAR2_TABLE_100();
808: a3 := JTF_NUMBER_TABLE();
809: a4 := JTF_DATE_TABLE();
802: a8 := JTF_DATE_TABLE();
803: a9 := JTF_DATE_TABLE();
804: else
805: a0 := JTF_NUMBER_TABLE();
806: a1 := JTF_NUMBER_TABLE();
807: a2 := JTF_VARCHAR2_TABLE_100();
808: a3 := JTF_NUMBER_TABLE();
809: a4 := JTF_DATE_TABLE();
810: a5 := JTF_VARCHAR2_TABLE_100();
804: else
805: a0 := JTF_NUMBER_TABLE();
806: a1 := JTF_NUMBER_TABLE();
807: a2 := JTF_VARCHAR2_TABLE_100();
808: a3 := JTF_NUMBER_TABLE();
809: a4 := JTF_DATE_TABLE();
810: a5 := JTF_VARCHAR2_TABLE_100();
811: a6 := JTF_VARCHAR2_TABLE_100();
812: a7 := JTF_VARCHAR2_TABLE_100();
845: end if;
846: end if;
847: end rosetta_table_copy_out_p12;
848:
849: procedure rosetta_table_copy_in_p13(t out nocopy lns_billing_batch_pub.amortization_sched_tbl, a0 JTF_NUMBER_TABLE) as
850: ddindx binary_integer; indx binary_integer;
851: begin
852: if a0 is not null and a0.count > 0 then
853: if a0.count > 0 then
863: end loop;
864: end if;
865: end if;
866: end rosetta_table_copy_in_p13;
867: procedure rosetta_table_copy_out_p13(t lns_billing_batch_pub.amortization_sched_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
868: ddindx binary_integer; indx binary_integer;
869: begin
870: if t is null or t.count = 0 then
871: a0 := JTF_NUMBER_TABLE();
867: procedure rosetta_table_copy_out_p13(t lns_billing_batch_pub.amortization_sched_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
868: ddindx binary_integer; indx binary_integer;
869: begin
870: if t is null or t.count = 0 then
871: a0 := JTF_NUMBER_TABLE();
872: else
873: a0 := JTF_NUMBER_TABLE();
874: if t.count > 0 then
875: a0.extend(t.count);
869: begin
870: if t is null or t.count = 0 then
871: a0 := JTF_NUMBER_TABLE();
872: else
873: a0 := JTF_NUMBER_TABLE();
874: if t.count > 0 then
875: a0.extend(t.count);
876: ddindx := t.first;
877: indx := 1;
896: , p4_a2 NUMBER
897: , p4_a3 DATE
898: , p4_a4 NUMBER
899: , p4_a5 NUMBER
900: , p5_a0 JTF_NUMBER_TABLE
901: , p5_a1 JTF_NUMBER_TABLE
902: , p5_a2 JTF_NUMBER_TABLE
903: , p5_a3 JTF_NUMBER_TABLE
904: , p5_a4 JTF_NUMBER_TABLE
897: , p4_a3 DATE
898: , p4_a4 NUMBER
899: , p4_a5 NUMBER
900: , p5_a0 JTF_NUMBER_TABLE
901: , p5_a1 JTF_NUMBER_TABLE
902: , p5_a2 JTF_NUMBER_TABLE
903: , p5_a3 JTF_NUMBER_TABLE
904: , p5_a4 JTF_NUMBER_TABLE
905: , p5_a5 JTF_NUMBER_TABLE
898: , p4_a4 NUMBER
899: , p4_a5 NUMBER
900: , p5_a0 JTF_NUMBER_TABLE
901: , p5_a1 JTF_NUMBER_TABLE
902: , p5_a2 JTF_NUMBER_TABLE
903: , p5_a3 JTF_NUMBER_TABLE
904: , p5_a4 JTF_NUMBER_TABLE
905: , p5_a5 JTF_NUMBER_TABLE
906: , p5_a6 JTF_NUMBER_TABLE
899: , p4_a5 NUMBER
900: , p5_a0 JTF_NUMBER_TABLE
901: , p5_a1 JTF_NUMBER_TABLE
902: , p5_a2 JTF_NUMBER_TABLE
903: , p5_a3 JTF_NUMBER_TABLE
904: , p5_a4 JTF_NUMBER_TABLE
905: , p5_a5 JTF_NUMBER_TABLE
906: , p5_a6 JTF_NUMBER_TABLE
907: , p5_a7 JTF_VARCHAR2_TABLE_100
900: , p5_a0 JTF_NUMBER_TABLE
901: , p5_a1 JTF_NUMBER_TABLE
902: , p5_a2 JTF_NUMBER_TABLE
903: , p5_a3 JTF_NUMBER_TABLE
904: , p5_a4 JTF_NUMBER_TABLE
905: , p5_a5 JTF_NUMBER_TABLE
906: , p5_a6 JTF_NUMBER_TABLE
907: , p5_a7 JTF_VARCHAR2_TABLE_100
908: , p5_a8 JTF_VARCHAR2_TABLE_300
901: , p5_a1 JTF_NUMBER_TABLE
902: , p5_a2 JTF_NUMBER_TABLE
903: , p5_a3 JTF_NUMBER_TABLE
904: , p5_a4 JTF_NUMBER_TABLE
905: , p5_a5 JTF_NUMBER_TABLE
906: , p5_a6 JTF_NUMBER_TABLE
907: , p5_a7 JTF_VARCHAR2_TABLE_100
908: , p5_a8 JTF_VARCHAR2_TABLE_300
909: , p5_a9 JTF_NUMBER_TABLE
902: , p5_a2 JTF_NUMBER_TABLE
903: , p5_a3 JTF_NUMBER_TABLE
904: , p5_a4 JTF_NUMBER_TABLE
905: , p5_a5 JTF_NUMBER_TABLE
906: , p5_a6 JTF_NUMBER_TABLE
907: , p5_a7 JTF_VARCHAR2_TABLE_100
908: , p5_a8 JTF_VARCHAR2_TABLE_300
909: , p5_a9 JTF_NUMBER_TABLE
910: , p5_a10 JTF_NUMBER_TABLE
905: , p5_a5 JTF_NUMBER_TABLE
906: , p5_a6 JTF_NUMBER_TABLE
907: , p5_a7 JTF_VARCHAR2_TABLE_100
908: , p5_a8 JTF_VARCHAR2_TABLE_300
909: , p5_a9 JTF_NUMBER_TABLE
910: , p5_a10 JTF_NUMBER_TABLE
911: , p5_a11 JTF_NUMBER_TABLE
912: , p5_a12 JTF_NUMBER_TABLE
913: , p5_a13 JTF_VARCHAR2_TABLE_2000
906: , p5_a6 JTF_NUMBER_TABLE
907: , p5_a7 JTF_VARCHAR2_TABLE_100
908: , p5_a8 JTF_VARCHAR2_TABLE_300
909: , p5_a9 JTF_NUMBER_TABLE
910: , p5_a10 JTF_NUMBER_TABLE
911: , p5_a11 JTF_NUMBER_TABLE
912: , p5_a12 JTF_NUMBER_TABLE
913: , p5_a13 JTF_VARCHAR2_TABLE_2000
914: , x_return_status out nocopy VARCHAR2
907: , p5_a7 JTF_VARCHAR2_TABLE_100
908: , p5_a8 JTF_VARCHAR2_TABLE_300
909: , p5_a9 JTF_NUMBER_TABLE
910: , p5_a10 JTF_NUMBER_TABLE
911: , p5_a11 JTF_NUMBER_TABLE
912: , p5_a12 JTF_NUMBER_TABLE
913: , p5_a13 JTF_VARCHAR2_TABLE_2000
914: , x_return_status out nocopy VARCHAR2
915: , x_msg_count out nocopy NUMBER
908: , p5_a8 JTF_VARCHAR2_TABLE_300
909: , p5_a9 JTF_NUMBER_TABLE
910: , p5_a10 JTF_NUMBER_TABLE
911: , p5_a11 JTF_NUMBER_TABLE
912: , p5_a12 JTF_NUMBER_TABLE
913: , p5_a13 JTF_VARCHAR2_TABLE_2000
914: , x_return_status out nocopy VARCHAR2
915: , x_msg_count out nocopy NUMBER
916: , x_msg_data out nocopy VARCHAR2
978: procedure create_offcycle_bills(p_api_version NUMBER
979: , p_init_msg_list VARCHAR2
980: , p_commit VARCHAR2
981: , p_validation_level NUMBER
982: , p4_a0 JTF_NUMBER_TABLE
983: , p4_a1 JTF_NUMBER_TABLE
984: , p4_a2 JTF_NUMBER_TABLE
985: , p4_a3 JTF_DATE_TABLE
986: , p4_a4 JTF_NUMBER_TABLE
979: , p_init_msg_list VARCHAR2
980: , p_commit VARCHAR2
981: , p_validation_level NUMBER
982: , p4_a0 JTF_NUMBER_TABLE
983: , p4_a1 JTF_NUMBER_TABLE
984: , p4_a2 JTF_NUMBER_TABLE
985: , p4_a3 JTF_DATE_TABLE
986: , p4_a4 JTF_NUMBER_TABLE
987: , p4_a5 JTF_NUMBER_TABLE
980: , p_commit VARCHAR2
981: , p_validation_level NUMBER
982: , p4_a0 JTF_NUMBER_TABLE
983: , p4_a1 JTF_NUMBER_TABLE
984: , p4_a2 JTF_NUMBER_TABLE
985: , p4_a3 JTF_DATE_TABLE
986: , p4_a4 JTF_NUMBER_TABLE
987: , p4_a5 JTF_NUMBER_TABLE
988: , p5_a0 JTF_NUMBER_TABLE
982: , p4_a0 JTF_NUMBER_TABLE
983: , p4_a1 JTF_NUMBER_TABLE
984: , p4_a2 JTF_NUMBER_TABLE
985: , p4_a3 JTF_DATE_TABLE
986: , p4_a4 JTF_NUMBER_TABLE
987: , p4_a5 JTF_NUMBER_TABLE
988: , p5_a0 JTF_NUMBER_TABLE
989: , p5_a1 JTF_NUMBER_TABLE
990: , p5_a2 JTF_NUMBER_TABLE
983: , p4_a1 JTF_NUMBER_TABLE
984: , p4_a2 JTF_NUMBER_TABLE
985: , p4_a3 JTF_DATE_TABLE
986: , p4_a4 JTF_NUMBER_TABLE
987: , p4_a5 JTF_NUMBER_TABLE
988: , p5_a0 JTF_NUMBER_TABLE
989: , p5_a1 JTF_NUMBER_TABLE
990: , p5_a2 JTF_NUMBER_TABLE
991: , p5_a3 JTF_NUMBER_TABLE
984: , p4_a2 JTF_NUMBER_TABLE
985: , p4_a3 JTF_DATE_TABLE
986: , p4_a4 JTF_NUMBER_TABLE
987: , p4_a5 JTF_NUMBER_TABLE
988: , p5_a0 JTF_NUMBER_TABLE
989: , p5_a1 JTF_NUMBER_TABLE
990: , p5_a2 JTF_NUMBER_TABLE
991: , p5_a3 JTF_NUMBER_TABLE
992: , p5_a4 JTF_NUMBER_TABLE
985: , p4_a3 JTF_DATE_TABLE
986: , p4_a4 JTF_NUMBER_TABLE
987: , p4_a5 JTF_NUMBER_TABLE
988: , p5_a0 JTF_NUMBER_TABLE
989: , p5_a1 JTF_NUMBER_TABLE
990: , p5_a2 JTF_NUMBER_TABLE
991: , p5_a3 JTF_NUMBER_TABLE
992: , p5_a4 JTF_NUMBER_TABLE
993: , p5_a5 JTF_NUMBER_TABLE
986: , p4_a4 JTF_NUMBER_TABLE
987: , p4_a5 JTF_NUMBER_TABLE
988: , p5_a0 JTF_NUMBER_TABLE
989: , p5_a1 JTF_NUMBER_TABLE
990: , p5_a2 JTF_NUMBER_TABLE
991: , p5_a3 JTF_NUMBER_TABLE
992: , p5_a4 JTF_NUMBER_TABLE
993: , p5_a5 JTF_NUMBER_TABLE
994: , p5_a6 JTF_NUMBER_TABLE
987: , p4_a5 JTF_NUMBER_TABLE
988: , p5_a0 JTF_NUMBER_TABLE
989: , p5_a1 JTF_NUMBER_TABLE
990: , p5_a2 JTF_NUMBER_TABLE
991: , p5_a3 JTF_NUMBER_TABLE
992: , p5_a4 JTF_NUMBER_TABLE
993: , p5_a5 JTF_NUMBER_TABLE
994: , p5_a6 JTF_NUMBER_TABLE
995: , p5_a7 JTF_VARCHAR2_TABLE_100
988: , p5_a0 JTF_NUMBER_TABLE
989: , p5_a1 JTF_NUMBER_TABLE
990: , p5_a2 JTF_NUMBER_TABLE
991: , p5_a3 JTF_NUMBER_TABLE
992: , p5_a4 JTF_NUMBER_TABLE
993: , p5_a5 JTF_NUMBER_TABLE
994: , p5_a6 JTF_NUMBER_TABLE
995: , p5_a7 JTF_VARCHAR2_TABLE_100
996: , p5_a8 JTF_VARCHAR2_TABLE_300
989: , p5_a1 JTF_NUMBER_TABLE
990: , p5_a2 JTF_NUMBER_TABLE
991: , p5_a3 JTF_NUMBER_TABLE
992: , p5_a4 JTF_NUMBER_TABLE
993: , p5_a5 JTF_NUMBER_TABLE
994: , p5_a6 JTF_NUMBER_TABLE
995: , p5_a7 JTF_VARCHAR2_TABLE_100
996: , p5_a8 JTF_VARCHAR2_TABLE_300
997: , p5_a9 JTF_NUMBER_TABLE
990: , p5_a2 JTF_NUMBER_TABLE
991: , p5_a3 JTF_NUMBER_TABLE
992: , p5_a4 JTF_NUMBER_TABLE
993: , p5_a5 JTF_NUMBER_TABLE
994: , p5_a6 JTF_NUMBER_TABLE
995: , p5_a7 JTF_VARCHAR2_TABLE_100
996: , p5_a8 JTF_VARCHAR2_TABLE_300
997: , p5_a9 JTF_NUMBER_TABLE
998: , p5_a10 JTF_NUMBER_TABLE
993: , p5_a5 JTF_NUMBER_TABLE
994: , p5_a6 JTF_NUMBER_TABLE
995: , p5_a7 JTF_VARCHAR2_TABLE_100
996: , p5_a8 JTF_VARCHAR2_TABLE_300
997: , p5_a9 JTF_NUMBER_TABLE
998: , p5_a10 JTF_NUMBER_TABLE
999: , p5_a11 JTF_NUMBER_TABLE
1000: , p5_a12 JTF_NUMBER_TABLE
1001: , p5_a13 JTF_VARCHAR2_TABLE_2000
994: , p5_a6 JTF_NUMBER_TABLE
995: , p5_a7 JTF_VARCHAR2_TABLE_100
996: , p5_a8 JTF_VARCHAR2_TABLE_300
997: , p5_a9 JTF_NUMBER_TABLE
998: , p5_a10 JTF_NUMBER_TABLE
999: , p5_a11 JTF_NUMBER_TABLE
1000: , p5_a12 JTF_NUMBER_TABLE
1001: , p5_a13 JTF_VARCHAR2_TABLE_2000
1002: , x_return_status out nocopy VARCHAR2
995: , p5_a7 JTF_VARCHAR2_TABLE_100
996: , p5_a8 JTF_VARCHAR2_TABLE_300
997: , p5_a9 JTF_NUMBER_TABLE
998: , p5_a10 JTF_NUMBER_TABLE
999: , p5_a11 JTF_NUMBER_TABLE
1000: , p5_a12 JTF_NUMBER_TABLE
1001: , p5_a13 JTF_VARCHAR2_TABLE_2000
1002: , x_return_status out nocopy VARCHAR2
1003: , x_msg_count out nocopy NUMBER
996: , p5_a8 JTF_VARCHAR2_TABLE_300
997: , p5_a9 JTF_NUMBER_TABLE
998: , p5_a10 JTF_NUMBER_TABLE
999: , p5_a11 JTF_NUMBER_TABLE
1000: , p5_a12 JTF_NUMBER_TABLE
1001: , p5_a13 JTF_VARCHAR2_TABLE_2000
1002: , x_return_status out nocopy VARCHAR2
1003: , x_msg_count out nocopy NUMBER
1004: , x_msg_data out nocopy VARCHAR2
1068: , p_init_msg_list VARCHAR2
1069: , p_commit VARCHAR2
1070: , p_validation_level NUMBER
1071: , p_loan_id NUMBER
1072: , p5_a0 out nocopy JTF_NUMBER_TABLE
1073: , p5_a1 out nocopy JTF_NUMBER_TABLE
1074: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
1075: , p5_a3 out nocopy JTF_NUMBER_TABLE
1076: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
1069: , p_commit VARCHAR2
1070: , p_validation_level NUMBER
1071: , p_loan_id NUMBER
1072: , p5_a0 out nocopy JTF_NUMBER_TABLE
1073: , p5_a1 out nocopy JTF_NUMBER_TABLE
1074: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
1075: , p5_a3 out nocopy JTF_NUMBER_TABLE
1076: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
1077: , p5_a5 out nocopy JTF_NUMBER_TABLE
1071: , p_loan_id NUMBER
1072: , p5_a0 out nocopy JTF_NUMBER_TABLE
1073: , p5_a1 out nocopy JTF_NUMBER_TABLE
1074: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
1075: , p5_a3 out nocopy JTF_NUMBER_TABLE
1076: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
1077: , p5_a5 out nocopy JTF_NUMBER_TABLE
1078: , p5_a6 out nocopy JTF_NUMBER_TABLE
1079: , p5_a7 out nocopy JTF_NUMBER_TABLE
1073: , p5_a1 out nocopy JTF_NUMBER_TABLE
1074: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
1075: , p5_a3 out nocopy JTF_NUMBER_TABLE
1076: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
1077: , p5_a5 out nocopy JTF_NUMBER_TABLE
1078: , p5_a6 out nocopy JTF_NUMBER_TABLE
1079: , p5_a7 out nocopy JTF_NUMBER_TABLE
1080: , p5_a8 out nocopy JTF_DATE_TABLE
1081: , p5_a9 out nocopy JTF_DATE_TABLE
1074: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
1075: , p5_a3 out nocopy JTF_NUMBER_TABLE
1076: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
1077: , p5_a5 out nocopy JTF_NUMBER_TABLE
1078: , p5_a6 out nocopy JTF_NUMBER_TABLE
1079: , p5_a7 out nocopy JTF_NUMBER_TABLE
1080: , p5_a8 out nocopy JTF_DATE_TABLE
1081: , p5_a9 out nocopy JTF_DATE_TABLE
1082: , p5_a10 out nocopy JTF_DATE_TABLE
1075: , p5_a3 out nocopy JTF_NUMBER_TABLE
1076: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
1077: , p5_a5 out nocopy JTF_NUMBER_TABLE
1078: , p5_a6 out nocopy JTF_NUMBER_TABLE
1079: , p5_a7 out nocopy JTF_NUMBER_TABLE
1080: , p5_a8 out nocopy JTF_DATE_TABLE
1081: , p5_a9 out nocopy JTF_DATE_TABLE
1082: , p5_a10 out nocopy JTF_DATE_TABLE
1083: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
1082: , p5_a10 out nocopy JTF_DATE_TABLE
1083: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
1084: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
1085: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_100
1086: , p5_a14 out nocopy JTF_NUMBER_TABLE
1087: , x_return_status out nocopy VARCHAR2
1088: , x_msg_count out nocopy NUMBER
1089: , x_msg_data out nocopy VARCHAR2
1090: )
1146: , p_init_msg_list VARCHAR2
1147: , p_commit VARCHAR2
1148: , p_validation_level NUMBER
1149: , p_loan_id NUMBER
1150: , p5_a0 JTF_NUMBER_TABLE
1151: , p5_a1 JTF_NUMBER_TABLE
1152: , p5_a2 JTF_VARCHAR2_TABLE_100
1153: , p5_a3 JTF_NUMBER_TABLE
1154: , p5_a4 JTF_DATE_TABLE
1147: , p_commit VARCHAR2
1148: , p_validation_level NUMBER
1149: , p_loan_id NUMBER
1150: , p5_a0 JTF_NUMBER_TABLE
1151: , p5_a1 JTF_NUMBER_TABLE
1152: , p5_a2 JTF_VARCHAR2_TABLE_100
1153: , p5_a3 JTF_NUMBER_TABLE
1154: , p5_a4 JTF_DATE_TABLE
1155: , p5_a5 JTF_VARCHAR2_TABLE_100
1149: , p_loan_id NUMBER
1150: , p5_a0 JTF_NUMBER_TABLE
1151: , p5_a1 JTF_NUMBER_TABLE
1152: , p5_a2 JTF_VARCHAR2_TABLE_100
1153: , p5_a3 JTF_NUMBER_TABLE
1154: , p5_a4 JTF_DATE_TABLE
1155: , p5_a5 JTF_VARCHAR2_TABLE_100
1156: , p5_a6 JTF_VARCHAR2_TABLE_100
1157: , p5_a7 JTF_VARCHAR2_TABLE_100
1214: , p_init_msg_list VARCHAR2
1215: , p_commit VARCHAR2
1216: , p_validation_level NUMBER
1217: , p_loan_id NUMBER
1218: , p_am_sched_tbl JTF_NUMBER_TABLE
1219: , p6_a0 JTF_NUMBER_TABLE
1220: , p6_a1 JTF_NUMBER_TABLE
1221: , p6_a2 JTF_VARCHAR2_TABLE_100
1222: , p6_a3 JTF_NUMBER_TABLE
1215: , p_commit VARCHAR2
1216: , p_validation_level NUMBER
1217: , p_loan_id NUMBER
1218: , p_am_sched_tbl JTF_NUMBER_TABLE
1219: , p6_a0 JTF_NUMBER_TABLE
1220: , p6_a1 JTF_NUMBER_TABLE
1221: , p6_a2 JTF_VARCHAR2_TABLE_100
1222: , p6_a3 JTF_NUMBER_TABLE
1223: , p6_a4 JTF_DATE_TABLE
1216: , p_validation_level NUMBER
1217: , p_loan_id NUMBER
1218: , p_am_sched_tbl JTF_NUMBER_TABLE
1219: , p6_a0 JTF_NUMBER_TABLE
1220: , p6_a1 JTF_NUMBER_TABLE
1221: , p6_a2 JTF_VARCHAR2_TABLE_100
1222: , p6_a3 JTF_NUMBER_TABLE
1223: , p6_a4 JTF_DATE_TABLE
1224: , p6_a5 JTF_VARCHAR2_TABLE_100
1218: , p_am_sched_tbl JTF_NUMBER_TABLE
1219: , p6_a0 JTF_NUMBER_TABLE
1220: , p6_a1 JTF_NUMBER_TABLE
1221: , p6_a2 JTF_VARCHAR2_TABLE_100
1222: , p6_a3 JTF_NUMBER_TABLE
1223: , p6_a4 JTF_DATE_TABLE
1224: , p6_a5 JTF_VARCHAR2_TABLE_100
1225: , p6_a6 JTF_VARCHAR2_TABLE_100
1226: , p6_a7 JTF_VARCHAR2_TABLE_100
1312: , p_commit VARCHAR2
1313: , p_validation_level NUMBER
1314: , p_loan_id NUMBER
1315: , p_am_sched_id NUMBER
1316: , p6_a0 out nocopy JTF_NUMBER_TABLE
1317: , p6_a1 out nocopy JTF_NUMBER_TABLE
1318: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1319: , p6_a3 out nocopy JTF_NUMBER_TABLE
1320: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1313: , p_validation_level NUMBER
1314: , p_loan_id NUMBER
1315: , p_am_sched_id NUMBER
1316: , p6_a0 out nocopy JTF_NUMBER_TABLE
1317: , p6_a1 out nocopy JTF_NUMBER_TABLE
1318: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1319: , p6_a3 out nocopy JTF_NUMBER_TABLE
1320: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1321: , p6_a5 out nocopy JTF_NUMBER_TABLE
1315: , p_am_sched_id NUMBER
1316: , p6_a0 out nocopy JTF_NUMBER_TABLE
1317: , p6_a1 out nocopy JTF_NUMBER_TABLE
1318: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1319: , p6_a3 out nocopy JTF_NUMBER_TABLE
1320: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1321: , p6_a5 out nocopy JTF_NUMBER_TABLE
1322: , p6_a6 out nocopy JTF_NUMBER_TABLE
1323: , p6_a7 out nocopy JTF_NUMBER_TABLE
1317: , p6_a1 out nocopy JTF_NUMBER_TABLE
1318: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1319: , p6_a3 out nocopy JTF_NUMBER_TABLE
1320: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1321: , p6_a5 out nocopy JTF_NUMBER_TABLE
1322: , p6_a6 out nocopy JTF_NUMBER_TABLE
1323: , p6_a7 out nocopy JTF_NUMBER_TABLE
1324: , p6_a8 out nocopy JTF_DATE_TABLE
1325: , p6_a9 out nocopy JTF_DATE_TABLE
1318: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1319: , p6_a3 out nocopy JTF_NUMBER_TABLE
1320: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1321: , p6_a5 out nocopy JTF_NUMBER_TABLE
1322: , p6_a6 out nocopy JTF_NUMBER_TABLE
1323: , p6_a7 out nocopy JTF_NUMBER_TABLE
1324: , p6_a8 out nocopy JTF_DATE_TABLE
1325: , p6_a9 out nocopy JTF_DATE_TABLE
1326: , p6_a10 out nocopy JTF_DATE_TABLE
1319: , p6_a3 out nocopy JTF_NUMBER_TABLE
1320: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1321: , p6_a5 out nocopy JTF_NUMBER_TABLE
1322: , p6_a6 out nocopy JTF_NUMBER_TABLE
1323: , p6_a7 out nocopy JTF_NUMBER_TABLE
1324: , p6_a8 out nocopy JTF_DATE_TABLE
1325: , p6_a9 out nocopy JTF_DATE_TABLE
1326: , p6_a10 out nocopy JTF_DATE_TABLE
1327: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1326: , p6_a10 out nocopy JTF_DATE_TABLE
1327: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1328: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1329: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1330: , p6_a14 out nocopy JTF_NUMBER_TABLE
1331: , x_return_status out nocopy VARCHAR2
1332: , x_msg_count out nocopy NUMBER
1333: , x_msg_data out nocopy VARCHAR2
1334: )
1393: , p_init_msg_list VARCHAR2
1394: , p_commit VARCHAR2
1395: , p_validation_level NUMBER
1396: , p_loan_id NUMBER
1397: , p5_a0 JTF_NUMBER_TABLE
1398: , p5_a1 JTF_NUMBER_TABLE
1399: , p5_a2 JTF_NUMBER_TABLE
1400: , p5_a3 JTF_DATE_TABLE
1401: , p5_a4 JTF_NUMBER_TABLE
1394: , p_commit VARCHAR2
1395: , p_validation_level NUMBER
1396: , p_loan_id NUMBER
1397: , p5_a0 JTF_NUMBER_TABLE
1398: , p5_a1 JTF_NUMBER_TABLE
1399: , p5_a2 JTF_NUMBER_TABLE
1400: , p5_a3 JTF_DATE_TABLE
1401: , p5_a4 JTF_NUMBER_TABLE
1402: , p5_a5 JTF_NUMBER_TABLE
1395: , p_validation_level NUMBER
1396: , p_loan_id NUMBER
1397: , p5_a0 JTF_NUMBER_TABLE
1398: , p5_a1 JTF_NUMBER_TABLE
1399: , p5_a2 JTF_NUMBER_TABLE
1400: , p5_a3 JTF_DATE_TABLE
1401: , p5_a4 JTF_NUMBER_TABLE
1402: , p5_a5 JTF_NUMBER_TABLE
1403: , p6_a0 JTF_NUMBER_TABLE
1397: , p5_a0 JTF_NUMBER_TABLE
1398: , p5_a1 JTF_NUMBER_TABLE
1399: , p5_a2 JTF_NUMBER_TABLE
1400: , p5_a3 JTF_DATE_TABLE
1401: , p5_a4 JTF_NUMBER_TABLE
1402: , p5_a5 JTF_NUMBER_TABLE
1403: , p6_a0 JTF_NUMBER_TABLE
1404: , p6_a1 JTF_NUMBER_TABLE
1405: , p6_a2 JTF_NUMBER_TABLE
1398: , p5_a1 JTF_NUMBER_TABLE
1399: , p5_a2 JTF_NUMBER_TABLE
1400: , p5_a3 JTF_DATE_TABLE
1401: , p5_a4 JTF_NUMBER_TABLE
1402: , p5_a5 JTF_NUMBER_TABLE
1403: , p6_a0 JTF_NUMBER_TABLE
1404: , p6_a1 JTF_NUMBER_TABLE
1405: , p6_a2 JTF_NUMBER_TABLE
1406: , p6_a3 JTF_NUMBER_TABLE
1399: , p5_a2 JTF_NUMBER_TABLE
1400: , p5_a3 JTF_DATE_TABLE
1401: , p5_a4 JTF_NUMBER_TABLE
1402: , p5_a5 JTF_NUMBER_TABLE
1403: , p6_a0 JTF_NUMBER_TABLE
1404: , p6_a1 JTF_NUMBER_TABLE
1405: , p6_a2 JTF_NUMBER_TABLE
1406: , p6_a3 JTF_NUMBER_TABLE
1407: , p6_a4 JTF_NUMBER_TABLE
1400: , p5_a3 JTF_DATE_TABLE
1401: , p5_a4 JTF_NUMBER_TABLE
1402: , p5_a5 JTF_NUMBER_TABLE
1403: , p6_a0 JTF_NUMBER_TABLE
1404: , p6_a1 JTF_NUMBER_TABLE
1405: , p6_a2 JTF_NUMBER_TABLE
1406: , p6_a3 JTF_NUMBER_TABLE
1407: , p6_a4 JTF_NUMBER_TABLE
1408: , p6_a5 JTF_NUMBER_TABLE
1401: , p5_a4 JTF_NUMBER_TABLE
1402: , p5_a5 JTF_NUMBER_TABLE
1403: , p6_a0 JTF_NUMBER_TABLE
1404: , p6_a1 JTF_NUMBER_TABLE
1405: , p6_a2 JTF_NUMBER_TABLE
1406: , p6_a3 JTF_NUMBER_TABLE
1407: , p6_a4 JTF_NUMBER_TABLE
1408: , p6_a5 JTF_NUMBER_TABLE
1409: , p6_a6 JTF_NUMBER_TABLE
1402: , p5_a5 JTF_NUMBER_TABLE
1403: , p6_a0 JTF_NUMBER_TABLE
1404: , p6_a1 JTF_NUMBER_TABLE
1405: , p6_a2 JTF_NUMBER_TABLE
1406: , p6_a3 JTF_NUMBER_TABLE
1407: , p6_a4 JTF_NUMBER_TABLE
1408: , p6_a5 JTF_NUMBER_TABLE
1409: , p6_a6 JTF_NUMBER_TABLE
1410: , p6_a7 JTF_VARCHAR2_TABLE_100
1403: , p6_a0 JTF_NUMBER_TABLE
1404: , p6_a1 JTF_NUMBER_TABLE
1405: , p6_a2 JTF_NUMBER_TABLE
1406: , p6_a3 JTF_NUMBER_TABLE
1407: , p6_a4 JTF_NUMBER_TABLE
1408: , p6_a5 JTF_NUMBER_TABLE
1409: , p6_a6 JTF_NUMBER_TABLE
1410: , p6_a7 JTF_VARCHAR2_TABLE_100
1411: , p6_a8 JTF_VARCHAR2_TABLE_300
1404: , p6_a1 JTF_NUMBER_TABLE
1405: , p6_a2 JTF_NUMBER_TABLE
1406: , p6_a3 JTF_NUMBER_TABLE
1407: , p6_a4 JTF_NUMBER_TABLE
1408: , p6_a5 JTF_NUMBER_TABLE
1409: , p6_a6 JTF_NUMBER_TABLE
1410: , p6_a7 JTF_VARCHAR2_TABLE_100
1411: , p6_a8 JTF_VARCHAR2_TABLE_300
1412: , p6_a9 JTF_NUMBER_TABLE
1405: , p6_a2 JTF_NUMBER_TABLE
1406: , p6_a3 JTF_NUMBER_TABLE
1407: , p6_a4 JTF_NUMBER_TABLE
1408: , p6_a5 JTF_NUMBER_TABLE
1409: , p6_a6 JTF_NUMBER_TABLE
1410: , p6_a7 JTF_VARCHAR2_TABLE_100
1411: , p6_a8 JTF_VARCHAR2_TABLE_300
1412: , p6_a9 JTF_NUMBER_TABLE
1413: , p6_a10 JTF_NUMBER_TABLE
1408: , p6_a5 JTF_NUMBER_TABLE
1409: , p6_a6 JTF_NUMBER_TABLE
1410: , p6_a7 JTF_VARCHAR2_TABLE_100
1411: , p6_a8 JTF_VARCHAR2_TABLE_300
1412: , p6_a9 JTF_NUMBER_TABLE
1413: , p6_a10 JTF_NUMBER_TABLE
1414: , p6_a11 JTF_NUMBER_TABLE
1415: , p6_a12 JTF_NUMBER_TABLE
1416: , p6_a13 JTF_VARCHAR2_TABLE_2000
1409: , p6_a6 JTF_NUMBER_TABLE
1410: , p6_a7 JTF_VARCHAR2_TABLE_100
1411: , p6_a8 JTF_VARCHAR2_TABLE_300
1412: , p6_a9 JTF_NUMBER_TABLE
1413: , p6_a10 JTF_NUMBER_TABLE
1414: , p6_a11 JTF_NUMBER_TABLE
1415: , p6_a12 JTF_NUMBER_TABLE
1416: , p6_a13 JTF_VARCHAR2_TABLE_2000
1417: , p7_a0 JTF_NUMBER_TABLE
1410: , p6_a7 JTF_VARCHAR2_TABLE_100
1411: , p6_a8 JTF_VARCHAR2_TABLE_300
1412: , p6_a9 JTF_NUMBER_TABLE
1413: , p6_a10 JTF_NUMBER_TABLE
1414: , p6_a11 JTF_NUMBER_TABLE
1415: , p6_a12 JTF_NUMBER_TABLE
1416: , p6_a13 JTF_VARCHAR2_TABLE_2000
1417: , p7_a0 JTF_NUMBER_TABLE
1418: , p7_a1 JTF_NUMBER_TABLE
1411: , p6_a8 JTF_VARCHAR2_TABLE_300
1412: , p6_a9 JTF_NUMBER_TABLE
1413: , p6_a10 JTF_NUMBER_TABLE
1414: , p6_a11 JTF_NUMBER_TABLE
1415: , p6_a12 JTF_NUMBER_TABLE
1416: , p6_a13 JTF_VARCHAR2_TABLE_2000
1417: , p7_a0 JTF_NUMBER_TABLE
1418: , p7_a1 JTF_NUMBER_TABLE
1419: , p7_a2 JTF_VARCHAR2_TABLE_100
1413: , p6_a10 JTF_NUMBER_TABLE
1414: , p6_a11 JTF_NUMBER_TABLE
1415: , p6_a12 JTF_NUMBER_TABLE
1416: , p6_a13 JTF_VARCHAR2_TABLE_2000
1417: , p7_a0 JTF_NUMBER_TABLE
1418: , p7_a1 JTF_NUMBER_TABLE
1419: , p7_a2 JTF_VARCHAR2_TABLE_100
1420: , p7_a3 JTF_NUMBER_TABLE
1421: , p7_a4 JTF_DATE_TABLE
1414: , p6_a11 JTF_NUMBER_TABLE
1415: , p6_a12 JTF_NUMBER_TABLE
1416: , p6_a13 JTF_VARCHAR2_TABLE_2000
1417: , p7_a0 JTF_NUMBER_TABLE
1418: , p7_a1 JTF_NUMBER_TABLE
1419: , p7_a2 JTF_VARCHAR2_TABLE_100
1420: , p7_a3 JTF_NUMBER_TABLE
1421: , p7_a4 JTF_DATE_TABLE
1422: , p7_a5 JTF_VARCHAR2_TABLE_100
1416: , p6_a13 JTF_VARCHAR2_TABLE_2000
1417: , p7_a0 JTF_NUMBER_TABLE
1418: , p7_a1 JTF_NUMBER_TABLE
1419: , p7_a2 JTF_VARCHAR2_TABLE_100
1420: , p7_a3 JTF_NUMBER_TABLE
1421: , p7_a4 JTF_DATE_TABLE
1422: , p7_a5 JTF_VARCHAR2_TABLE_100
1423: , p7_a6 JTF_VARCHAR2_TABLE_100
1424: , p7_a7 JTF_VARCHAR2_TABLE_100