1: package body lns_billing_batch_pub_w as
2: /* $Header: LNS_BILL_PUBJ_B.pls 120.2 2005/07/13 13:47 scherkas noship $ */
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.2 2005/07/13 13:47 scherkas noship $ */
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: ) as
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: ) as
34: ddindx binary_integer; indx binary_integer;
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: ) as
34: ddindx binary_integer; indx binary_integer;
35: begin
76: end loop;
77: end if;
78: end if;
79: end rosetta_table_copy_in_p1;
80: procedure rosetta_table_copy_out_p1(t lns_billing_batch_pub.loans_to_bill_tbl, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_VARCHAR2_TABLE_100
83: , a3 out nocopy JTF_VARCHAR2_TABLE_300
84: , a4 out nocopy JTF_NUMBER_TABLE
77: end if;
78: end if;
79: end rosetta_table_copy_in_p1;
80: procedure rosetta_table_copy_out_p1(t lns_billing_batch_pub.loans_to_bill_tbl, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_VARCHAR2_TABLE_100
83: , a3 out nocopy JTF_VARCHAR2_TABLE_300
84: , a4 out nocopy JTF_NUMBER_TABLE
85: , a5 out nocopy JTF_DATE_TABLE
80: procedure rosetta_table_copy_out_p1(t lns_billing_batch_pub.loans_to_bill_tbl, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_VARCHAR2_TABLE_100
83: , a3 out nocopy JTF_VARCHAR2_TABLE_300
84: , a4 out nocopy JTF_NUMBER_TABLE
85: , a5 out nocopy JTF_DATE_TABLE
86: , a6 out nocopy JTF_DATE_TABLE
87: , a7 out nocopy JTF_DATE_TABLE
88: , a8 out nocopy JTF_VARCHAR2_TABLE_100
86: , a6 out nocopy JTF_DATE_TABLE
87: , a7 out nocopy JTF_DATE_TABLE
88: , a8 out nocopy JTF_VARCHAR2_TABLE_100
89: , a9 out nocopy JTF_VARCHAR2_TABLE_100
90: , a10 out nocopy JTF_NUMBER_TABLE
91: , a11 out nocopy JTF_NUMBER_TABLE
92: , a12 out nocopy JTF_VARCHAR2_TABLE_100
93: , a13 out nocopy JTF_NUMBER_TABLE
94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
87: , a7 out nocopy JTF_DATE_TABLE
88: , a8 out nocopy JTF_VARCHAR2_TABLE_100
89: , a9 out nocopy JTF_VARCHAR2_TABLE_100
90: , a10 out nocopy JTF_NUMBER_TABLE
91: , a11 out nocopy JTF_NUMBER_TABLE
92: , a12 out nocopy JTF_VARCHAR2_TABLE_100
93: , a13 out nocopy JTF_NUMBER_TABLE
94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
89: , a9 out nocopy JTF_VARCHAR2_TABLE_100
90: , a10 out nocopy JTF_NUMBER_TABLE
91: , a11 out nocopy JTF_NUMBER_TABLE
92: , a12 out nocopy JTF_VARCHAR2_TABLE_100
93: , a13 out nocopy JTF_NUMBER_TABLE
94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
96: , a16 out nocopy JTF_NUMBER_TABLE
97: , a17 out nocopy JTF_NUMBER_TABLE
92: , a12 out nocopy JTF_VARCHAR2_TABLE_100
93: , a13 out nocopy JTF_NUMBER_TABLE
94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
96: , a16 out nocopy JTF_NUMBER_TABLE
97: , a17 out nocopy JTF_NUMBER_TABLE
98: , a18 out nocopy JTF_NUMBER_TABLE
99: , a19 out nocopy JTF_NUMBER_TABLE
100: , a20 out nocopy JTF_NUMBER_TABLE
93: , a13 out nocopy JTF_NUMBER_TABLE
94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
96: , a16 out nocopy JTF_NUMBER_TABLE
97: , a17 out nocopy JTF_NUMBER_TABLE
98: , a18 out nocopy JTF_NUMBER_TABLE
99: , a19 out nocopy JTF_NUMBER_TABLE
100: , a20 out nocopy JTF_NUMBER_TABLE
101: , a21 out nocopy JTF_NUMBER_TABLE
94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
96: , a16 out nocopy JTF_NUMBER_TABLE
97: , a17 out nocopy JTF_NUMBER_TABLE
98: , a18 out nocopy JTF_NUMBER_TABLE
99: , a19 out nocopy JTF_NUMBER_TABLE
100: , a20 out nocopy JTF_NUMBER_TABLE
101: , a21 out nocopy JTF_NUMBER_TABLE
102: , a22 out nocopy JTF_NUMBER_TABLE
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
96: , a16 out nocopy JTF_NUMBER_TABLE
97: , a17 out nocopy JTF_NUMBER_TABLE
98: , a18 out nocopy JTF_NUMBER_TABLE
99: , a19 out nocopy JTF_NUMBER_TABLE
100: , a20 out nocopy JTF_NUMBER_TABLE
101: , a21 out nocopy JTF_NUMBER_TABLE
102: , a22 out nocopy JTF_NUMBER_TABLE
103: , a23 out nocopy JTF_NUMBER_TABLE
96: , a16 out nocopy JTF_NUMBER_TABLE
97: , a17 out nocopy JTF_NUMBER_TABLE
98: , a18 out nocopy JTF_NUMBER_TABLE
99: , a19 out nocopy JTF_NUMBER_TABLE
100: , a20 out nocopy JTF_NUMBER_TABLE
101: , a21 out nocopy JTF_NUMBER_TABLE
102: , a22 out nocopy JTF_NUMBER_TABLE
103: , a23 out nocopy JTF_NUMBER_TABLE
104: , a24 out nocopy JTF_VARCHAR2_TABLE_100
97: , a17 out nocopy JTF_NUMBER_TABLE
98: , a18 out nocopy JTF_NUMBER_TABLE
99: , a19 out nocopy JTF_NUMBER_TABLE
100: , a20 out nocopy JTF_NUMBER_TABLE
101: , a21 out nocopy JTF_NUMBER_TABLE
102: , a22 out nocopy JTF_NUMBER_TABLE
103: , a23 out nocopy JTF_NUMBER_TABLE
104: , a24 out nocopy JTF_VARCHAR2_TABLE_100
105: , a25 out nocopy JTF_DATE_TABLE
98: , a18 out nocopy JTF_NUMBER_TABLE
99: , a19 out nocopy JTF_NUMBER_TABLE
100: , a20 out nocopy JTF_NUMBER_TABLE
101: , a21 out nocopy JTF_NUMBER_TABLE
102: , a22 out nocopy JTF_NUMBER_TABLE
103: , a23 out nocopy JTF_NUMBER_TABLE
104: , a24 out nocopy JTF_VARCHAR2_TABLE_100
105: , a25 out nocopy JTF_DATE_TABLE
106: , a26 out nocopy JTF_NUMBER_TABLE
99: , a19 out nocopy JTF_NUMBER_TABLE
100: , a20 out nocopy JTF_NUMBER_TABLE
101: , a21 out nocopy JTF_NUMBER_TABLE
102: , a22 out nocopy JTF_NUMBER_TABLE
103: , a23 out nocopy JTF_NUMBER_TABLE
104: , a24 out nocopy JTF_VARCHAR2_TABLE_100
105: , a25 out nocopy JTF_DATE_TABLE
106: , a26 out nocopy JTF_NUMBER_TABLE
107: , a27 out nocopy JTF_NUMBER_TABLE
102: , a22 out nocopy JTF_NUMBER_TABLE
103: , a23 out nocopy JTF_NUMBER_TABLE
104: , a24 out nocopy JTF_VARCHAR2_TABLE_100
105: , a25 out nocopy JTF_DATE_TABLE
106: , a26 out nocopy JTF_NUMBER_TABLE
107: , a27 out nocopy JTF_NUMBER_TABLE
108: , a28 out nocopy JTF_NUMBER_TABLE
109: , a29 out nocopy JTF_VARCHAR2_TABLE_100
110: ) as
103: , a23 out nocopy JTF_NUMBER_TABLE
104: , a24 out nocopy JTF_VARCHAR2_TABLE_100
105: , a25 out nocopy JTF_DATE_TABLE
106: , a26 out nocopy JTF_NUMBER_TABLE
107: , a27 out nocopy JTF_NUMBER_TABLE
108: , a28 out nocopy JTF_NUMBER_TABLE
109: , a29 out nocopy JTF_VARCHAR2_TABLE_100
110: ) as
111: ddindx binary_integer; indx binary_integer;
104: , a24 out nocopy JTF_VARCHAR2_TABLE_100
105: , a25 out nocopy JTF_DATE_TABLE
106: , a26 out nocopy JTF_NUMBER_TABLE
107: , a27 out nocopy JTF_NUMBER_TABLE
108: , a28 out nocopy JTF_NUMBER_TABLE
109: , a29 out nocopy JTF_VARCHAR2_TABLE_100
110: ) as
111: ddindx binary_integer; indx binary_integer;
112: begin
110: ) as
111: ddindx binary_integer; indx binary_integer;
112: begin
113: if t is null or t.count = 0 then
114: a0 := JTF_NUMBER_TABLE();
115: a1 := JTF_NUMBER_TABLE();
116: a2 := JTF_VARCHAR2_TABLE_100();
117: a3 := JTF_VARCHAR2_TABLE_300();
118: a4 := JTF_NUMBER_TABLE();
111: ddindx binary_integer; indx binary_integer;
112: begin
113: if t is null or t.count = 0 then
114: a0 := JTF_NUMBER_TABLE();
115: a1 := JTF_NUMBER_TABLE();
116: a2 := JTF_VARCHAR2_TABLE_100();
117: a3 := JTF_VARCHAR2_TABLE_300();
118: a4 := JTF_NUMBER_TABLE();
119: a5 := JTF_DATE_TABLE();
114: a0 := JTF_NUMBER_TABLE();
115: a1 := JTF_NUMBER_TABLE();
116: a2 := JTF_VARCHAR2_TABLE_100();
117: a3 := JTF_VARCHAR2_TABLE_300();
118: a4 := JTF_NUMBER_TABLE();
119: a5 := JTF_DATE_TABLE();
120: a6 := JTF_DATE_TABLE();
121: a7 := JTF_DATE_TABLE();
122: a8 := JTF_VARCHAR2_TABLE_100();
120: a6 := JTF_DATE_TABLE();
121: a7 := JTF_DATE_TABLE();
122: a8 := JTF_VARCHAR2_TABLE_100();
123: a9 := JTF_VARCHAR2_TABLE_100();
124: a10 := JTF_NUMBER_TABLE();
125: a11 := JTF_NUMBER_TABLE();
126: a12 := JTF_VARCHAR2_TABLE_100();
127: a13 := JTF_NUMBER_TABLE();
128: a14 := JTF_VARCHAR2_TABLE_100();
121: a7 := JTF_DATE_TABLE();
122: a8 := JTF_VARCHAR2_TABLE_100();
123: a9 := JTF_VARCHAR2_TABLE_100();
124: a10 := JTF_NUMBER_TABLE();
125: a11 := JTF_NUMBER_TABLE();
126: a12 := JTF_VARCHAR2_TABLE_100();
127: a13 := JTF_NUMBER_TABLE();
128: a14 := JTF_VARCHAR2_TABLE_100();
129: a15 := JTF_VARCHAR2_TABLE_100();
123: a9 := JTF_VARCHAR2_TABLE_100();
124: a10 := JTF_NUMBER_TABLE();
125: a11 := JTF_NUMBER_TABLE();
126: a12 := JTF_VARCHAR2_TABLE_100();
127: a13 := JTF_NUMBER_TABLE();
128: a14 := JTF_VARCHAR2_TABLE_100();
129: a15 := JTF_VARCHAR2_TABLE_100();
130: a16 := JTF_NUMBER_TABLE();
131: a17 := JTF_NUMBER_TABLE();
126: a12 := JTF_VARCHAR2_TABLE_100();
127: a13 := JTF_NUMBER_TABLE();
128: a14 := JTF_VARCHAR2_TABLE_100();
129: a15 := JTF_VARCHAR2_TABLE_100();
130: a16 := JTF_NUMBER_TABLE();
131: a17 := JTF_NUMBER_TABLE();
132: a18 := JTF_NUMBER_TABLE();
133: a19 := JTF_NUMBER_TABLE();
134: a20 := JTF_NUMBER_TABLE();
127: a13 := JTF_NUMBER_TABLE();
128: a14 := JTF_VARCHAR2_TABLE_100();
129: a15 := JTF_VARCHAR2_TABLE_100();
130: a16 := JTF_NUMBER_TABLE();
131: a17 := JTF_NUMBER_TABLE();
132: a18 := JTF_NUMBER_TABLE();
133: a19 := JTF_NUMBER_TABLE();
134: a20 := JTF_NUMBER_TABLE();
135: a21 := JTF_NUMBER_TABLE();
128: a14 := JTF_VARCHAR2_TABLE_100();
129: a15 := JTF_VARCHAR2_TABLE_100();
130: a16 := JTF_NUMBER_TABLE();
131: a17 := JTF_NUMBER_TABLE();
132: a18 := JTF_NUMBER_TABLE();
133: a19 := JTF_NUMBER_TABLE();
134: a20 := JTF_NUMBER_TABLE();
135: a21 := JTF_NUMBER_TABLE();
136: a22 := JTF_NUMBER_TABLE();
129: a15 := JTF_VARCHAR2_TABLE_100();
130: a16 := JTF_NUMBER_TABLE();
131: a17 := JTF_NUMBER_TABLE();
132: a18 := JTF_NUMBER_TABLE();
133: a19 := JTF_NUMBER_TABLE();
134: a20 := JTF_NUMBER_TABLE();
135: a21 := JTF_NUMBER_TABLE();
136: a22 := JTF_NUMBER_TABLE();
137: a23 := JTF_NUMBER_TABLE();
130: a16 := JTF_NUMBER_TABLE();
131: a17 := JTF_NUMBER_TABLE();
132: a18 := JTF_NUMBER_TABLE();
133: a19 := JTF_NUMBER_TABLE();
134: a20 := JTF_NUMBER_TABLE();
135: a21 := JTF_NUMBER_TABLE();
136: a22 := JTF_NUMBER_TABLE();
137: a23 := JTF_NUMBER_TABLE();
138: a24 := JTF_VARCHAR2_TABLE_100();
131: a17 := JTF_NUMBER_TABLE();
132: a18 := JTF_NUMBER_TABLE();
133: a19 := JTF_NUMBER_TABLE();
134: a20 := JTF_NUMBER_TABLE();
135: a21 := JTF_NUMBER_TABLE();
136: a22 := JTF_NUMBER_TABLE();
137: a23 := JTF_NUMBER_TABLE();
138: a24 := JTF_VARCHAR2_TABLE_100();
139: a25 := JTF_DATE_TABLE();
132: a18 := JTF_NUMBER_TABLE();
133: a19 := JTF_NUMBER_TABLE();
134: a20 := JTF_NUMBER_TABLE();
135: a21 := JTF_NUMBER_TABLE();
136: a22 := JTF_NUMBER_TABLE();
137: a23 := JTF_NUMBER_TABLE();
138: a24 := JTF_VARCHAR2_TABLE_100();
139: a25 := JTF_DATE_TABLE();
140: a26 := JTF_NUMBER_TABLE();
133: a19 := JTF_NUMBER_TABLE();
134: a20 := JTF_NUMBER_TABLE();
135: a21 := JTF_NUMBER_TABLE();
136: a22 := JTF_NUMBER_TABLE();
137: a23 := JTF_NUMBER_TABLE();
138: a24 := JTF_VARCHAR2_TABLE_100();
139: a25 := JTF_DATE_TABLE();
140: a26 := JTF_NUMBER_TABLE();
141: a27 := JTF_NUMBER_TABLE();
136: a22 := JTF_NUMBER_TABLE();
137: a23 := JTF_NUMBER_TABLE();
138: a24 := JTF_VARCHAR2_TABLE_100();
139: a25 := JTF_DATE_TABLE();
140: a26 := JTF_NUMBER_TABLE();
141: a27 := JTF_NUMBER_TABLE();
142: a28 := JTF_NUMBER_TABLE();
143: a29 := JTF_VARCHAR2_TABLE_100();
144: else
137: a23 := JTF_NUMBER_TABLE();
138: a24 := JTF_VARCHAR2_TABLE_100();
139: a25 := JTF_DATE_TABLE();
140: a26 := JTF_NUMBER_TABLE();
141: a27 := JTF_NUMBER_TABLE();
142: a28 := JTF_NUMBER_TABLE();
143: a29 := JTF_VARCHAR2_TABLE_100();
144: else
145: a0 := JTF_NUMBER_TABLE();
138: a24 := JTF_VARCHAR2_TABLE_100();
139: a25 := JTF_DATE_TABLE();
140: a26 := JTF_NUMBER_TABLE();
141: a27 := JTF_NUMBER_TABLE();
142: a28 := JTF_NUMBER_TABLE();
143: a29 := JTF_VARCHAR2_TABLE_100();
144: else
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
141: a27 := JTF_NUMBER_TABLE();
142: a28 := JTF_NUMBER_TABLE();
143: a29 := JTF_VARCHAR2_TABLE_100();
144: else
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_VARCHAR2_TABLE_100();
148: a3 := JTF_VARCHAR2_TABLE_300();
149: a4 := JTF_NUMBER_TABLE();
142: a28 := JTF_NUMBER_TABLE();
143: a29 := JTF_VARCHAR2_TABLE_100();
144: else
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_VARCHAR2_TABLE_100();
148: a3 := JTF_VARCHAR2_TABLE_300();
149: a4 := JTF_NUMBER_TABLE();
150: a5 := JTF_DATE_TABLE();
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_VARCHAR2_TABLE_100();
148: a3 := JTF_VARCHAR2_TABLE_300();
149: a4 := JTF_NUMBER_TABLE();
150: a5 := JTF_DATE_TABLE();
151: a6 := JTF_DATE_TABLE();
152: a7 := JTF_DATE_TABLE();
153: a8 := JTF_VARCHAR2_TABLE_100();
151: a6 := JTF_DATE_TABLE();
152: a7 := JTF_DATE_TABLE();
153: a8 := JTF_VARCHAR2_TABLE_100();
154: a9 := JTF_VARCHAR2_TABLE_100();
155: a10 := JTF_NUMBER_TABLE();
156: a11 := JTF_NUMBER_TABLE();
157: a12 := JTF_VARCHAR2_TABLE_100();
158: a13 := JTF_NUMBER_TABLE();
159: a14 := JTF_VARCHAR2_TABLE_100();
152: a7 := JTF_DATE_TABLE();
153: a8 := JTF_VARCHAR2_TABLE_100();
154: a9 := JTF_VARCHAR2_TABLE_100();
155: a10 := JTF_NUMBER_TABLE();
156: a11 := JTF_NUMBER_TABLE();
157: a12 := JTF_VARCHAR2_TABLE_100();
158: a13 := JTF_NUMBER_TABLE();
159: a14 := JTF_VARCHAR2_TABLE_100();
160: a15 := JTF_VARCHAR2_TABLE_100();
154: a9 := JTF_VARCHAR2_TABLE_100();
155: a10 := JTF_NUMBER_TABLE();
156: a11 := JTF_NUMBER_TABLE();
157: a12 := JTF_VARCHAR2_TABLE_100();
158: a13 := JTF_NUMBER_TABLE();
159: a14 := JTF_VARCHAR2_TABLE_100();
160: a15 := JTF_VARCHAR2_TABLE_100();
161: a16 := JTF_NUMBER_TABLE();
162: a17 := JTF_NUMBER_TABLE();
157: a12 := JTF_VARCHAR2_TABLE_100();
158: a13 := JTF_NUMBER_TABLE();
159: a14 := JTF_VARCHAR2_TABLE_100();
160: a15 := JTF_VARCHAR2_TABLE_100();
161: a16 := JTF_NUMBER_TABLE();
162: a17 := JTF_NUMBER_TABLE();
163: a18 := JTF_NUMBER_TABLE();
164: a19 := JTF_NUMBER_TABLE();
165: a20 := JTF_NUMBER_TABLE();
158: a13 := JTF_NUMBER_TABLE();
159: a14 := JTF_VARCHAR2_TABLE_100();
160: a15 := JTF_VARCHAR2_TABLE_100();
161: a16 := JTF_NUMBER_TABLE();
162: a17 := JTF_NUMBER_TABLE();
163: a18 := JTF_NUMBER_TABLE();
164: a19 := JTF_NUMBER_TABLE();
165: a20 := JTF_NUMBER_TABLE();
166: a21 := JTF_NUMBER_TABLE();
159: a14 := JTF_VARCHAR2_TABLE_100();
160: a15 := JTF_VARCHAR2_TABLE_100();
161: a16 := JTF_NUMBER_TABLE();
162: a17 := JTF_NUMBER_TABLE();
163: a18 := JTF_NUMBER_TABLE();
164: a19 := JTF_NUMBER_TABLE();
165: a20 := JTF_NUMBER_TABLE();
166: a21 := JTF_NUMBER_TABLE();
167: a22 := JTF_NUMBER_TABLE();
160: a15 := JTF_VARCHAR2_TABLE_100();
161: a16 := JTF_NUMBER_TABLE();
162: a17 := JTF_NUMBER_TABLE();
163: a18 := JTF_NUMBER_TABLE();
164: a19 := JTF_NUMBER_TABLE();
165: a20 := JTF_NUMBER_TABLE();
166: a21 := JTF_NUMBER_TABLE();
167: a22 := JTF_NUMBER_TABLE();
168: a23 := JTF_NUMBER_TABLE();
161: a16 := JTF_NUMBER_TABLE();
162: a17 := JTF_NUMBER_TABLE();
163: a18 := JTF_NUMBER_TABLE();
164: a19 := JTF_NUMBER_TABLE();
165: a20 := JTF_NUMBER_TABLE();
166: a21 := JTF_NUMBER_TABLE();
167: a22 := JTF_NUMBER_TABLE();
168: a23 := JTF_NUMBER_TABLE();
169: a24 := JTF_VARCHAR2_TABLE_100();
162: a17 := JTF_NUMBER_TABLE();
163: a18 := JTF_NUMBER_TABLE();
164: a19 := JTF_NUMBER_TABLE();
165: a20 := JTF_NUMBER_TABLE();
166: a21 := JTF_NUMBER_TABLE();
167: a22 := JTF_NUMBER_TABLE();
168: a23 := JTF_NUMBER_TABLE();
169: a24 := JTF_VARCHAR2_TABLE_100();
170: a25 := JTF_DATE_TABLE();
163: a18 := JTF_NUMBER_TABLE();
164: a19 := JTF_NUMBER_TABLE();
165: a20 := JTF_NUMBER_TABLE();
166: a21 := JTF_NUMBER_TABLE();
167: a22 := JTF_NUMBER_TABLE();
168: a23 := JTF_NUMBER_TABLE();
169: a24 := JTF_VARCHAR2_TABLE_100();
170: a25 := JTF_DATE_TABLE();
171: a26 := JTF_NUMBER_TABLE();
164: a19 := JTF_NUMBER_TABLE();
165: a20 := JTF_NUMBER_TABLE();
166: a21 := JTF_NUMBER_TABLE();
167: a22 := JTF_NUMBER_TABLE();
168: a23 := JTF_NUMBER_TABLE();
169: a24 := JTF_VARCHAR2_TABLE_100();
170: a25 := JTF_DATE_TABLE();
171: a26 := JTF_NUMBER_TABLE();
172: a27 := JTF_NUMBER_TABLE();
167: a22 := JTF_NUMBER_TABLE();
168: a23 := JTF_NUMBER_TABLE();
169: a24 := JTF_VARCHAR2_TABLE_100();
170: a25 := JTF_DATE_TABLE();
171: a26 := JTF_NUMBER_TABLE();
172: a27 := JTF_NUMBER_TABLE();
173: a28 := JTF_NUMBER_TABLE();
174: a29 := JTF_VARCHAR2_TABLE_100();
175: if t.count > 0 then
168: a23 := JTF_NUMBER_TABLE();
169: a24 := JTF_VARCHAR2_TABLE_100();
170: a25 := JTF_DATE_TABLE();
171: a26 := JTF_NUMBER_TABLE();
172: a27 := JTF_NUMBER_TABLE();
173: a28 := JTF_NUMBER_TABLE();
174: a29 := JTF_VARCHAR2_TABLE_100();
175: if t.count > 0 then
176: a0.extend(t.count);
169: a24 := JTF_VARCHAR2_TABLE_100();
170: a25 := JTF_DATE_TABLE();
171: a26 := JTF_NUMBER_TABLE();
172: a27 := JTF_NUMBER_TABLE();
173: a28 := JTF_NUMBER_TABLE();
174: a29 := JTF_VARCHAR2_TABLE_100();
175: if t.count > 0 then
176: a0.extend(t.count);
177: a1.extend(t.count);
246: end if;
247: end rosetta_table_copy_out_p1;
248:
249: procedure rosetta_table_copy_in_p4(t out nocopy lns_billing_batch_pub.reverse_tbl, a0 JTF_VARCHAR2_TABLE_100
250: , a1 JTF_NUMBER_TABLE
251: , a2 JTF_NUMBER_TABLE
252: , a3 JTF_NUMBER_TABLE
253: , a4 JTF_VARCHAR2_TABLE_100
254: , a5 JTF_NUMBER_TABLE
247: end rosetta_table_copy_out_p1;
248:
249: procedure rosetta_table_copy_in_p4(t out nocopy lns_billing_batch_pub.reverse_tbl, a0 JTF_VARCHAR2_TABLE_100
250: , a1 JTF_NUMBER_TABLE
251: , a2 JTF_NUMBER_TABLE
252: , a3 JTF_NUMBER_TABLE
253: , a4 JTF_VARCHAR2_TABLE_100
254: , a5 JTF_NUMBER_TABLE
255: , a6 JTF_NUMBER_TABLE
248:
249: procedure rosetta_table_copy_in_p4(t out nocopy lns_billing_batch_pub.reverse_tbl, a0 JTF_VARCHAR2_TABLE_100
250: , a1 JTF_NUMBER_TABLE
251: , a2 JTF_NUMBER_TABLE
252: , a3 JTF_NUMBER_TABLE
253: , a4 JTF_VARCHAR2_TABLE_100
254: , a5 JTF_NUMBER_TABLE
255: , a6 JTF_NUMBER_TABLE
256: , a7 JTF_NUMBER_TABLE
250: , a1 JTF_NUMBER_TABLE
251: , a2 JTF_NUMBER_TABLE
252: , a3 JTF_NUMBER_TABLE
253: , a4 JTF_VARCHAR2_TABLE_100
254: , a5 JTF_NUMBER_TABLE
255: , a6 JTF_NUMBER_TABLE
256: , a7 JTF_NUMBER_TABLE
257: ) as
258: ddindx binary_integer; indx binary_integer;
251: , a2 JTF_NUMBER_TABLE
252: , a3 JTF_NUMBER_TABLE
253: , a4 JTF_VARCHAR2_TABLE_100
254: , a5 JTF_NUMBER_TABLE
255: , a6 JTF_NUMBER_TABLE
256: , a7 JTF_NUMBER_TABLE
257: ) as
258: ddindx binary_integer; indx binary_integer;
259: begin
252: , a3 JTF_NUMBER_TABLE
253: , a4 JTF_VARCHAR2_TABLE_100
254: , a5 JTF_NUMBER_TABLE
255: , a6 JTF_NUMBER_TABLE
256: , a7 JTF_NUMBER_TABLE
257: ) as
258: ddindx binary_integer; indx binary_integer;
259: begin
260: if a0 is not null and a0.count > 0 then
279: end if;
280: end if;
281: end rosetta_table_copy_in_p4;
282: procedure rosetta_table_copy_out_p4(t lns_billing_batch_pub.reverse_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
283: , a1 out nocopy JTF_NUMBER_TABLE
284: , a2 out nocopy JTF_NUMBER_TABLE
285: , a3 out nocopy JTF_NUMBER_TABLE
286: , a4 out nocopy JTF_VARCHAR2_TABLE_100
287: , a5 out nocopy JTF_NUMBER_TABLE
280: end if;
281: end rosetta_table_copy_in_p4;
282: procedure rosetta_table_copy_out_p4(t lns_billing_batch_pub.reverse_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
283: , a1 out nocopy JTF_NUMBER_TABLE
284: , a2 out nocopy JTF_NUMBER_TABLE
285: , a3 out nocopy JTF_NUMBER_TABLE
286: , a4 out nocopy JTF_VARCHAR2_TABLE_100
287: , a5 out nocopy JTF_NUMBER_TABLE
288: , a6 out nocopy JTF_NUMBER_TABLE
281: end rosetta_table_copy_in_p4;
282: procedure rosetta_table_copy_out_p4(t lns_billing_batch_pub.reverse_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
283: , a1 out nocopy JTF_NUMBER_TABLE
284: , a2 out nocopy JTF_NUMBER_TABLE
285: , a3 out nocopy JTF_NUMBER_TABLE
286: , a4 out nocopy JTF_VARCHAR2_TABLE_100
287: , a5 out nocopy JTF_NUMBER_TABLE
288: , a6 out nocopy JTF_NUMBER_TABLE
289: , a7 out nocopy JTF_NUMBER_TABLE
283: , a1 out nocopy JTF_NUMBER_TABLE
284: , a2 out nocopy JTF_NUMBER_TABLE
285: , a3 out nocopy JTF_NUMBER_TABLE
286: , a4 out nocopy JTF_VARCHAR2_TABLE_100
287: , a5 out nocopy JTF_NUMBER_TABLE
288: , a6 out nocopy JTF_NUMBER_TABLE
289: , a7 out nocopy JTF_NUMBER_TABLE
290: ) as
291: ddindx binary_integer; indx binary_integer;
284: , a2 out nocopy JTF_NUMBER_TABLE
285: , a3 out nocopy JTF_NUMBER_TABLE
286: , a4 out nocopy JTF_VARCHAR2_TABLE_100
287: , a5 out nocopy JTF_NUMBER_TABLE
288: , a6 out nocopy JTF_NUMBER_TABLE
289: , a7 out nocopy JTF_NUMBER_TABLE
290: ) as
291: ddindx binary_integer; indx binary_integer;
292: begin
285: , a3 out nocopy JTF_NUMBER_TABLE
286: , a4 out nocopy JTF_VARCHAR2_TABLE_100
287: , a5 out nocopy JTF_NUMBER_TABLE
288: , a6 out nocopy JTF_NUMBER_TABLE
289: , a7 out nocopy JTF_NUMBER_TABLE
290: ) as
291: ddindx binary_integer; indx binary_integer;
292: begin
293: if t is null or t.count = 0 then
291: ddindx binary_integer; indx binary_integer;
292: begin
293: if t is null or t.count = 0 then
294: a0 := JTF_VARCHAR2_TABLE_100();
295: a1 := JTF_NUMBER_TABLE();
296: a2 := JTF_NUMBER_TABLE();
297: a3 := JTF_NUMBER_TABLE();
298: a4 := JTF_VARCHAR2_TABLE_100();
299: a5 := JTF_NUMBER_TABLE();
292: begin
293: if t is null or t.count = 0 then
294: a0 := JTF_VARCHAR2_TABLE_100();
295: a1 := JTF_NUMBER_TABLE();
296: a2 := JTF_NUMBER_TABLE();
297: a3 := JTF_NUMBER_TABLE();
298: a4 := JTF_VARCHAR2_TABLE_100();
299: a5 := JTF_NUMBER_TABLE();
300: a6 := JTF_NUMBER_TABLE();
293: if t is null or t.count = 0 then
294: a0 := JTF_VARCHAR2_TABLE_100();
295: a1 := JTF_NUMBER_TABLE();
296: a2 := JTF_NUMBER_TABLE();
297: a3 := JTF_NUMBER_TABLE();
298: a4 := JTF_VARCHAR2_TABLE_100();
299: a5 := JTF_NUMBER_TABLE();
300: a6 := JTF_NUMBER_TABLE();
301: a7 := JTF_NUMBER_TABLE();
295: a1 := JTF_NUMBER_TABLE();
296: a2 := JTF_NUMBER_TABLE();
297: a3 := JTF_NUMBER_TABLE();
298: a4 := JTF_VARCHAR2_TABLE_100();
299: a5 := JTF_NUMBER_TABLE();
300: a6 := JTF_NUMBER_TABLE();
301: a7 := JTF_NUMBER_TABLE();
302: else
303: a0 := JTF_VARCHAR2_TABLE_100();
296: a2 := JTF_NUMBER_TABLE();
297: a3 := JTF_NUMBER_TABLE();
298: a4 := JTF_VARCHAR2_TABLE_100();
299: a5 := JTF_NUMBER_TABLE();
300: a6 := JTF_NUMBER_TABLE();
301: a7 := JTF_NUMBER_TABLE();
302: else
303: a0 := JTF_VARCHAR2_TABLE_100();
304: a1 := JTF_NUMBER_TABLE();
297: a3 := JTF_NUMBER_TABLE();
298: a4 := JTF_VARCHAR2_TABLE_100();
299: a5 := JTF_NUMBER_TABLE();
300: a6 := JTF_NUMBER_TABLE();
301: a7 := JTF_NUMBER_TABLE();
302: else
303: a0 := JTF_VARCHAR2_TABLE_100();
304: a1 := JTF_NUMBER_TABLE();
305: a2 := JTF_NUMBER_TABLE();
300: a6 := JTF_NUMBER_TABLE();
301: a7 := JTF_NUMBER_TABLE();
302: else
303: a0 := JTF_VARCHAR2_TABLE_100();
304: a1 := JTF_NUMBER_TABLE();
305: a2 := JTF_NUMBER_TABLE();
306: a3 := JTF_NUMBER_TABLE();
307: a4 := JTF_VARCHAR2_TABLE_100();
308: a5 := JTF_NUMBER_TABLE();
301: a7 := JTF_NUMBER_TABLE();
302: else
303: a0 := JTF_VARCHAR2_TABLE_100();
304: a1 := JTF_NUMBER_TABLE();
305: a2 := JTF_NUMBER_TABLE();
306: a3 := JTF_NUMBER_TABLE();
307: a4 := JTF_VARCHAR2_TABLE_100();
308: a5 := JTF_NUMBER_TABLE();
309: a6 := JTF_NUMBER_TABLE();
302: else
303: a0 := JTF_VARCHAR2_TABLE_100();
304: a1 := JTF_NUMBER_TABLE();
305: a2 := JTF_NUMBER_TABLE();
306: a3 := JTF_NUMBER_TABLE();
307: a4 := JTF_VARCHAR2_TABLE_100();
308: a5 := JTF_NUMBER_TABLE();
309: a6 := JTF_NUMBER_TABLE();
310: a7 := JTF_NUMBER_TABLE();
304: a1 := JTF_NUMBER_TABLE();
305: a2 := JTF_NUMBER_TABLE();
306: a3 := JTF_NUMBER_TABLE();
307: a4 := JTF_VARCHAR2_TABLE_100();
308: a5 := JTF_NUMBER_TABLE();
309: a6 := JTF_NUMBER_TABLE();
310: a7 := JTF_NUMBER_TABLE();
311: if t.count > 0 then
312: a0.extend(t.count);
305: a2 := JTF_NUMBER_TABLE();
306: a3 := JTF_NUMBER_TABLE();
307: a4 := JTF_VARCHAR2_TABLE_100();
308: a5 := JTF_NUMBER_TABLE();
309: a6 := JTF_NUMBER_TABLE();
310: a7 := JTF_NUMBER_TABLE();
311: if t.count > 0 then
312: a0.extend(t.count);
313: a1.extend(t.count);
306: a3 := JTF_NUMBER_TABLE();
307: a4 := JTF_VARCHAR2_TABLE_100();
308: a5 := JTF_NUMBER_TABLE();
309: a6 := JTF_NUMBER_TABLE();
310: a7 := JTF_NUMBER_TABLE();
311: if t.count > 0 then
312: a0.extend(t.count);
313: a1.extend(t.count);
314: a2.extend(t.count);
337: end if;
338: end if;
339: end rosetta_table_copy_out_p4;
340:
341: procedure rosetta_table_copy_in_p6(t out nocopy lns_billing_batch_pub.bill_headers_tbl, a0 JTF_NUMBER_TABLE
342: , a1 JTF_NUMBER_TABLE
343: , a2 JTF_NUMBER_TABLE
344: , a3 JTF_DATE_TABLE
345: ) as
338: end if;
339: end rosetta_table_copy_out_p4;
340:
341: procedure rosetta_table_copy_in_p6(t out nocopy lns_billing_batch_pub.bill_headers_tbl, a0 JTF_NUMBER_TABLE
342: , a1 JTF_NUMBER_TABLE
343: , a2 JTF_NUMBER_TABLE
344: , a3 JTF_DATE_TABLE
345: ) as
346: ddindx binary_integer; indx binary_integer;
339: end rosetta_table_copy_out_p4;
340:
341: procedure rosetta_table_copy_in_p6(t out nocopy lns_billing_batch_pub.bill_headers_tbl, a0 JTF_NUMBER_TABLE
342: , a1 JTF_NUMBER_TABLE
343: , a2 JTF_NUMBER_TABLE
344: , a3 JTF_DATE_TABLE
345: ) as
346: ddindx binary_integer; indx binary_integer;
347: begin
362: end loop;
363: end if;
364: end if;
365: end rosetta_table_copy_in_p6;
366: procedure rosetta_table_copy_out_p6(t lns_billing_batch_pub.bill_headers_tbl, a0 out nocopy JTF_NUMBER_TABLE
367: , a1 out nocopy JTF_NUMBER_TABLE
368: , a2 out nocopy JTF_NUMBER_TABLE
369: , a3 out nocopy JTF_DATE_TABLE
370: ) as
363: end if;
364: end if;
365: end rosetta_table_copy_in_p6;
366: procedure rosetta_table_copy_out_p6(t lns_billing_batch_pub.bill_headers_tbl, a0 out nocopy JTF_NUMBER_TABLE
367: , a1 out nocopy JTF_NUMBER_TABLE
368: , a2 out nocopy JTF_NUMBER_TABLE
369: , a3 out nocopy JTF_DATE_TABLE
370: ) as
371: ddindx binary_integer; indx binary_integer;
364: end if;
365: end rosetta_table_copy_in_p6;
366: procedure rosetta_table_copy_out_p6(t lns_billing_batch_pub.bill_headers_tbl, a0 out nocopy JTF_NUMBER_TABLE
367: , a1 out nocopy JTF_NUMBER_TABLE
368: , a2 out nocopy JTF_NUMBER_TABLE
369: , a3 out nocopy JTF_DATE_TABLE
370: ) as
371: ddindx binary_integer; indx binary_integer;
372: begin
370: ) as
371: ddindx binary_integer; indx binary_integer;
372: begin
373: if t is null or t.count = 0 then
374: a0 := JTF_NUMBER_TABLE();
375: a1 := JTF_NUMBER_TABLE();
376: a2 := JTF_NUMBER_TABLE();
377: a3 := JTF_DATE_TABLE();
378: else
371: ddindx binary_integer; indx binary_integer;
372: begin
373: if t is null or t.count = 0 then
374: a0 := JTF_NUMBER_TABLE();
375: a1 := JTF_NUMBER_TABLE();
376: a2 := JTF_NUMBER_TABLE();
377: a3 := JTF_DATE_TABLE();
378: else
379: a0 := JTF_NUMBER_TABLE();
372: begin
373: if t is null or t.count = 0 then
374: a0 := JTF_NUMBER_TABLE();
375: a1 := JTF_NUMBER_TABLE();
376: a2 := JTF_NUMBER_TABLE();
377: a3 := JTF_DATE_TABLE();
378: else
379: a0 := JTF_NUMBER_TABLE();
380: a1 := JTF_NUMBER_TABLE();
375: a1 := JTF_NUMBER_TABLE();
376: a2 := JTF_NUMBER_TABLE();
377: a3 := JTF_DATE_TABLE();
378: else
379: a0 := JTF_NUMBER_TABLE();
380: a1 := JTF_NUMBER_TABLE();
381: a2 := JTF_NUMBER_TABLE();
382: a3 := JTF_DATE_TABLE();
383: if t.count > 0 then
376: a2 := JTF_NUMBER_TABLE();
377: a3 := JTF_DATE_TABLE();
378: else
379: a0 := JTF_NUMBER_TABLE();
380: a1 := JTF_NUMBER_TABLE();
381: a2 := JTF_NUMBER_TABLE();
382: a3 := JTF_DATE_TABLE();
383: if t.count > 0 then
384: a0.extend(t.count);
377: a3 := JTF_DATE_TABLE();
378: else
379: a0 := JTF_NUMBER_TABLE();
380: a1 := JTF_NUMBER_TABLE();
381: a2 := JTF_NUMBER_TABLE();
382: a3 := JTF_DATE_TABLE();
383: if t.count > 0 then
384: a0.extend(t.count);
385: a1.extend(t.count);
401: end if;
402: end if;
403: end rosetta_table_copy_out_p6;
404:
405: procedure rosetta_table_copy_in_p8(t out nocopy lns_billing_batch_pub.bill_lines_tbl, a0 JTF_NUMBER_TABLE
406: , a1 JTF_NUMBER_TABLE
407: , a2 JTF_NUMBER_TABLE
408: , a3 JTF_NUMBER_TABLE
409: , a4 JTF_NUMBER_TABLE
402: end if;
403: end rosetta_table_copy_out_p6;
404:
405: procedure rosetta_table_copy_in_p8(t out nocopy lns_billing_batch_pub.bill_lines_tbl, a0 JTF_NUMBER_TABLE
406: , a1 JTF_NUMBER_TABLE
407: , a2 JTF_NUMBER_TABLE
408: , a3 JTF_NUMBER_TABLE
409: , a4 JTF_NUMBER_TABLE
410: , a5 JTF_NUMBER_TABLE
403: end rosetta_table_copy_out_p6;
404:
405: procedure rosetta_table_copy_in_p8(t out nocopy lns_billing_batch_pub.bill_lines_tbl, a0 JTF_NUMBER_TABLE
406: , a1 JTF_NUMBER_TABLE
407: , a2 JTF_NUMBER_TABLE
408: , a3 JTF_NUMBER_TABLE
409: , a4 JTF_NUMBER_TABLE
410: , a5 JTF_NUMBER_TABLE
411: , a6 JTF_NUMBER_TABLE
404:
405: procedure rosetta_table_copy_in_p8(t out nocopy lns_billing_batch_pub.bill_lines_tbl, a0 JTF_NUMBER_TABLE
406: , a1 JTF_NUMBER_TABLE
407: , a2 JTF_NUMBER_TABLE
408: , a3 JTF_NUMBER_TABLE
409: , a4 JTF_NUMBER_TABLE
410: , a5 JTF_NUMBER_TABLE
411: , a6 JTF_NUMBER_TABLE
412: , a7 JTF_VARCHAR2_TABLE_100
405: procedure rosetta_table_copy_in_p8(t out nocopy lns_billing_batch_pub.bill_lines_tbl, a0 JTF_NUMBER_TABLE
406: , a1 JTF_NUMBER_TABLE
407: , a2 JTF_NUMBER_TABLE
408: , a3 JTF_NUMBER_TABLE
409: , a4 JTF_NUMBER_TABLE
410: , a5 JTF_NUMBER_TABLE
411: , a6 JTF_NUMBER_TABLE
412: , a7 JTF_VARCHAR2_TABLE_100
413: , a8 JTF_VARCHAR2_TABLE_300
406: , a1 JTF_NUMBER_TABLE
407: , a2 JTF_NUMBER_TABLE
408: , a3 JTF_NUMBER_TABLE
409: , a4 JTF_NUMBER_TABLE
410: , a5 JTF_NUMBER_TABLE
411: , a6 JTF_NUMBER_TABLE
412: , a7 JTF_VARCHAR2_TABLE_100
413: , a8 JTF_VARCHAR2_TABLE_300
414: , a9 JTF_NUMBER_TABLE
407: , a2 JTF_NUMBER_TABLE
408: , a3 JTF_NUMBER_TABLE
409: , a4 JTF_NUMBER_TABLE
410: , a5 JTF_NUMBER_TABLE
411: , a6 JTF_NUMBER_TABLE
412: , a7 JTF_VARCHAR2_TABLE_100
413: , a8 JTF_VARCHAR2_TABLE_300
414: , a9 JTF_NUMBER_TABLE
415: , a10 JTF_NUMBER_TABLE
410: , a5 JTF_NUMBER_TABLE
411: , a6 JTF_NUMBER_TABLE
412: , a7 JTF_VARCHAR2_TABLE_100
413: , a8 JTF_VARCHAR2_TABLE_300
414: , a9 JTF_NUMBER_TABLE
415: , a10 JTF_NUMBER_TABLE
416: , a11 JTF_NUMBER_TABLE
417: , a12 JTF_NUMBER_TABLE
418: ) as
411: , a6 JTF_NUMBER_TABLE
412: , a7 JTF_VARCHAR2_TABLE_100
413: , a8 JTF_VARCHAR2_TABLE_300
414: , a9 JTF_NUMBER_TABLE
415: , a10 JTF_NUMBER_TABLE
416: , a11 JTF_NUMBER_TABLE
417: , a12 JTF_NUMBER_TABLE
418: ) as
419: ddindx binary_integer; indx binary_integer;
412: , a7 JTF_VARCHAR2_TABLE_100
413: , a8 JTF_VARCHAR2_TABLE_300
414: , a9 JTF_NUMBER_TABLE
415: , a10 JTF_NUMBER_TABLE
416: , a11 JTF_NUMBER_TABLE
417: , a12 JTF_NUMBER_TABLE
418: ) as
419: ddindx binary_integer; indx binary_integer;
420: begin
413: , a8 JTF_VARCHAR2_TABLE_300
414: , a9 JTF_NUMBER_TABLE
415: , a10 JTF_NUMBER_TABLE
416: , a11 JTF_NUMBER_TABLE
417: , a12 JTF_NUMBER_TABLE
418: ) as
419: ddindx binary_integer; indx binary_integer;
420: begin
421: if a0 is not null and a0.count > 0 then
444: end loop;
445: end if;
446: end if;
447: end rosetta_table_copy_in_p8;
448: procedure rosetta_table_copy_out_p8(t lns_billing_batch_pub.bill_lines_tbl, a0 out nocopy JTF_NUMBER_TABLE
449: , a1 out nocopy JTF_NUMBER_TABLE
450: , a2 out nocopy JTF_NUMBER_TABLE
451: , a3 out nocopy JTF_NUMBER_TABLE
452: , a4 out nocopy JTF_NUMBER_TABLE
445: end if;
446: end if;
447: end rosetta_table_copy_in_p8;
448: procedure rosetta_table_copy_out_p8(t lns_billing_batch_pub.bill_lines_tbl, a0 out nocopy JTF_NUMBER_TABLE
449: , a1 out nocopy JTF_NUMBER_TABLE
450: , a2 out nocopy JTF_NUMBER_TABLE
451: , a3 out nocopy JTF_NUMBER_TABLE
452: , a4 out nocopy JTF_NUMBER_TABLE
453: , a5 out nocopy JTF_NUMBER_TABLE
446: end if;
447: end rosetta_table_copy_in_p8;
448: procedure rosetta_table_copy_out_p8(t lns_billing_batch_pub.bill_lines_tbl, a0 out nocopy JTF_NUMBER_TABLE
449: , a1 out nocopy JTF_NUMBER_TABLE
450: , a2 out nocopy JTF_NUMBER_TABLE
451: , a3 out nocopy JTF_NUMBER_TABLE
452: , a4 out nocopy JTF_NUMBER_TABLE
453: , a5 out nocopy JTF_NUMBER_TABLE
454: , a6 out nocopy JTF_NUMBER_TABLE
447: end rosetta_table_copy_in_p8;
448: procedure rosetta_table_copy_out_p8(t lns_billing_batch_pub.bill_lines_tbl, a0 out nocopy JTF_NUMBER_TABLE
449: , a1 out nocopy JTF_NUMBER_TABLE
450: , a2 out nocopy JTF_NUMBER_TABLE
451: , a3 out nocopy JTF_NUMBER_TABLE
452: , a4 out nocopy JTF_NUMBER_TABLE
453: , a5 out nocopy JTF_NUMBER_TABLE
454: , a6 out nocopy JTF_NUMBER_TABLE
455: , a7 out nocopy JTF_VARCHAR2_TABLE_100
448: procedure rosetta_table_copy_out_p8(t lns_billing_batch_pub.bill_lines_tbl, a0 out nocopy JTF_NUMBER_TABLE
449: , a1 out nocopy JTF_NUMBER_TABLE
450: , a2 out nocopy JTF_NUMBER_TABLE
451: , a3 out nocopy JTF_NUMBER_TABLE
452: , a4 out nocopy JTF_NUMBER_TABLE
453: , a5 out nocopy JTF_NUMBER_TABLE
454: , a6 out nocopy JTF_NUMBER_TABLE
455: , a7 out nocopy JTF_VARCHAR2_TABLE_100
456: , a8 out nocopy JTF_VARCHAR2_TABLE_300
449: , a1 out nocopy JTF_NUMBER_TABLE
450: , a2 out nocopy JTF_NUMBER_TABLE
451: , a3 out nocopy JTF_NUMBER_TABLE
452: , a4 out nocopy JTF_NUMBER_TABLE
453: , a5 out nocopy JTF_NUMBER_TABLE
454: , a6 out nocopy JTF_NUMBER_TABLE
455: , a7 out nocopy JTF_VARCHAR2_TABLE_100
456: , a8 out nocopy JTF_VARCHAR2_TABLE_300
457: , a9 out nocopy JTF_NUMBER_TABLE
450: , a2 out nocopy JTF_NUMBER_TABLE
451: , a3 out nocopy JTF_NUMBER_TABLE
452: , a4 out nocopy JTF_NUMBER_TABLE
453: , a5 out nocopy JTF_NUMBER_TABLE
454: , a6 out nocopy JTF_NUMBER_TABLE
455: , a7 out nocopy JTF_VARCHAR2_TABLE_100
456: , a8 out nocopy JTF_VARCHAR2_TABLE_300
457: , a9 out nocopy JTF_NUMBER_TABLE
458: , a10 out nocopy JTF_NUMBER_TABLE
453: , a5 out nocopy JTF_NUMBER_TABLE
454: , a6 out nocopy JTF_NUMBER_TABLE
455: , a7 out nocopy JTF_VARCHAR2_TABLE_100
456: , a8 out nocopy JTF_VARCHAR2_TABLE_300
457: , a9 out nocopy JTF_NUMBER_TABLE
458: , a10 out nocopy JTF_NUMBER_TABLE
459: , a11 out nocopy JTF_NUMBER_TABLE
460: , a12 out nocopy JTF_NUMBER_TABLE
461: ) as
454: , a6 out nocopy JTF_NUMBER_TABLE
455: , a7 out nocopy JTF_VARCHAR2_TABLE_100
456: , a8 out nocopy JTF_VARCHAR2_TABLE_300
457: , a9 out nocopy JTF_NUMBER_TABLE
458: , a10 out nocopy JTF_NUMBER_TABLE
459: , a11 out nocopy JTF_NUMBER_TABLE
460: , a12 out nocopy JTF_NUMBER_TABLE
461: ) as
462: ddindx binary_integer; indx binary_integer;
455: , a7 out nocopy JTF_VARCHAR2_TABLE_100
456: , a8 out nocopy JTF_VARCHAR2_TABLE_300
457: , a9 out nocopy JTF_NUMBER_TABLE
458: , a10 out nocopy JTF_NUMBER_TABLE
459: , a11 out nocopy JTF_NUMBER_TABLE
460: , a12 out nocopy JTF_NUMBER_TABLE
461: ) as
462: ddindx binary_integer; indx binary_integer;
463: begin
456: , a8 out nocopy JTF_VARCHAR2_TABLE_300
457: , a9 out nocopy JTF_NUMBER_TABLE
458: , a10 out nocopy JTF_NUMBER_TABLE
459: , a11 out nocopy JTF_NUMBER_TABLE
460: , a12 out nocopy JTF_NUMBER_TABLE
461: ) as
462: ddindx binary_integer; indx binary_integer;
463: begin
464: if t is null or t.count = 0 then
461: ) as
462: ddindx binary_integer; indx binary_integer;
463: begin
464: if t is null or t.count = 0 then
465: a0 := JTF_NUMBER_TABLE();
466: a1 := JTF_NUMBER_TABLE();
467: a2 := JTF_NUMBER_TABLE();
468: a3 := JTF_NUMBER_TABLE();
469: a4 := JTF_NUMBER_TABLE();
462: ddindx binary_integer; indx binary_integer;
463: begin
464: if t is null or t.count = 0 then
465: a0 := JTF_NUMBER_TABLE();
466: a1 := JTF_NUMBER_TABLE();
467: a2 := JTF_NUMBER_TABLE();
468: a3 := JTF_NUMBER_TABLE();
469: a4 := JTF_NUMBER_TABLE();
470: a5 := JTF_NUMBER_TABLE();
463: begin
464: if t is null or t.count = 0 then
465: a0 := JTF_NUMBER_TABLE();
466: a1 := JTF_NUMBER_TABLE();
467: a2 := JTF_NUMBER_TABLE();
468: a3 := JTF_NUMBER_TABLE();
469: a4 := JTF_NUMBER_TABLE();
470: a5 := JTF_NUMBER_TABLE();
471: a6 := JTF_NUMBER_TABLE();
464: if t is null or t.count = 0 then
465: a0 := JTF_NUMBER_TABLE();
466: a1 := JTF_NUMBER_TABLE();
467: a2 := JTF_NUMBER_TABLE();
468: a3 := JTF_NUMBER_TABLE();
469: a4 := JTF_NUMBER_TABLE();
470: a5 := JTF_NUMBER_TABLE();
471: a6 := JTF_NUMBER_TABLE();
472: a7 := JTF_VARCHAR2_TABLE_100();
465: a0 := JTF_NUMBER_TABLE();
466: a1 := JTF_NUMBER_TABLE();
467: a2 := JTF_NUMBER_TABLE();
468: a3 := JTF_NUMBER_TABLE();
469: a4 := JTF_NUMBER_TABLE();
470: a5 := JTF_NUMBER_TABLE();
471: a6 := JTF_NUMBER_TABLE();
472: a7 := JTF_VARCHAR2_TABLE_100();
473: a8 := JTF_VARCHAR2_TABLE_300();
466: a1 := JTF_NUMBER_TABLE();
467: a2 := JTF_NUMBER_TABLE();
468: a3 := JTF_NUMBER_TABLE();
469: a4 := JTF_NUMBER_TABLE();
470: a5 := JTF_NUMBER_TABLE();
471: a6 := JTF_NUMBER_TABLE();
472: a7 := JTF_VARCHAR2_TABLE_100();
473: a8 := JTF_VARCHAR2_TABLE_300();
474: a9 := JTF_NUMBER_TABLE();
467: a2 := JTF_NUMBER_TABLE();
468: a3 := JTF_NUMBER_TABLE();
469: a4 := JTF_NUMBER_TABLE();
470: a5 := JTF_NUMBER_TABLE();
471: a6 := JTF_NUMBER_TABLE();
472: a7 := JTF_VARCHAR2_TABLE_100();
473: a8 := JTF_VARCHAR2_TABLE_300();
474: a9 := JTF_NUMBER_TABLE();
475: a10 := JTF_NUMBER_TABLE();
470: a5 := JTF_NUMBER_TABLE();
471: a6 := JTF_NUMBER_TABLE();
472: a7 := JTF_VARCHAR2_TABLE_100();
473: a8 := JTF_VARCHAR2_TABLE_300();
474: a9 := JTF_NUMBER_TABLE();
475: a10 := JTF_NUMBER_TABLE();
476: a11 := JTF_NUMBER_TABLE();
477: a12 := JTF_NUMBER_TABLE();
478: else
471: a6 := JTF_NUMBER_TABLE();
472: a7 := JTF_VARCHAR2_TABLE_100();
473: a8 := JTF_VARCHAR2_TABLE_300();
474: a9 := JTF_NUMBER_TABLE();
475: a10 := JTF_NUMBER_TABLE();
476: a11 := JTF_NUMBER_TABLE();
477: a12 := JTF_NUMBER_TABLE();
478: else
479: a0 := JTF_NUMBER_TABLE();
472: a7 := JTF_VARCHAR2_TABLE_100();
473: a8 := JTF_VARCHAR2_TABLE_300();
474: a9 := JTF_NUMBER_TABLE();
475: a10 := JTF_NUMBER_TABLE();
476: a11 := JTF_NUMBER_TABLE();
477: a12 := JTF_NUMBER_TABLE();
478: else
479: a0 := JTF_NUMBER_TABLE();
480: a1 := JTF_NUMBER_TABLE();
473: a8 := JTF_VARCHAR2_TABLE_300();
474: a9 := JTF_NUMBER_TABLE();
475: a10 := JTF_NUMBER_TABLE();
476: a11 := JTF_NUMBER_TABLE();
477: a12 := JTF_NUMBER_TABLE();
478: else
479: a0 := JTF_NUMBER_TABLE();
480: a1 := JTF_NUMBER_TABLE();
481: a2 := JTF_NUMBER_TABLE();
475: a10 := JTF_NUMBER_TABLE();
476: a11 := JTF_NUMBER_TABLE();
477: a12 := JTF_NUMBER_TABLE();
478: else
479: a0 := JTF_NUMBER_TABLE();
480: a1 := JTF_NUMBER_TABLE();
481: a2 := JTF_NUMBER_TABLE();
482: a3 := JTF_NUMBER_TABLE();
483: a4 := JTF_NUMBER_TABLE();
476: a11 := JTF_NUMBER_TABLE();
477: a12 := JTF_NUMBER_TABLE();
478: else
479: a0 := JTF_NUMBER_TABLE();
480: a1 := JTF_NUMBER_TABLE();
481: a2 := JTF_NUMBER_TABLE();
482: a3 := JTF_NUMBER_TABLE();
483: a4 := JTF_NUMBER_TABLE();
484: a5 := JTF_NUMBER_TABLE();
477: a12 := JTF_NUMBER_TABLE();
478: else
479: a0 := JTF_NUMBER_TABLE();
480: a1 := JTF_NUMBER_TABLE();
481: a2 := JTF_NUMBER_TABLE();
482: a3 := JTF_NUMBER_TABLE();
483: a4 := JTF_NUMBER_TABLE();
484: a5 := JTF_NUMBER_TABLE();
485: a6 := JTF_NUMBER_TABLE();
478: else
479: a0 := JTF_NUMBER_TABLE();
480: a1 := JTF_NUMBER_TABLE();
481: a2 := JTF_NUMBER_TABLE();
482: a3 := JTF_NUMBER_TABLE();
483: a4 := JTF_NUMBER_TABLE();
484: a5 := JTF_NUMBER_TABLE();
485: a6 := JTF_NUMBER_TABLE();
486: a7 := JTF_VARCHAR2_TABLE_100();
479: a0 := JTF_NUMBER_TABLE();
480: a1 := JTF_NUMBER_TABLE();
481: a2 := JTF_NUMBER_TABLE();
482: a3 := JTF_NUMBER_TABLE();
483: a4 := JTF_NUMBER_TABLE();
484: a5 := JTF_NUMBER_TABLE();
485: a6 := JTF_NUMBER_TABLE();
486: a7 := JTF_VARCHAR2_TABLE_100();
487: a8 := JTF_VARCHAR2_TABLE_300();
480: a1 := JTF_NUMBER_TABLE();
481: a2 := JTF_NUMBER_TABLE();
482: a3 := JTF_NUMBER_TABLE();
483: a4 := JTF_NUMBER_TABLE();
484: a5 := JTF_NUMBER_TABLE();
485: a6 := JTF_NUMBER_TABLE();
486: a7 := JTF_VARCHAR2_TABLE_100();
487: a8 := JTF_VARCHAR2_TABLE_300();
488: a9 := JTF_NUMBER_TABLE();
481: a2 := JTF_NUMBER_TABLE();
482: a3 := JTF_NUMBER_TABLE();
483: a4 := JTF_NUMBER_TABLE();
484: a5 := JTF_NUMBER_TABLE();
485: a6 := JTF_NUMBER_TABLE();
486: a7 := JTF_VARCHAR2_TABLE_100();
487: a8 := JTF_VARCHAR2_TABLE_300();
488: a9 := JTF_NUMBER_TABLE();
489: a10 := JTF_NUMBER_TABLE();
484: a5 := JTF_NUMBER_TABLE();
485: a6 := JTF_NUMBER_TABLE();
486: a7 := JTF_VARCHAR2_TABLE_100();
487: a8 := JTF_VARCHAR2_TABLE_300();
488: a9 := JTF_NUMBER_TABLE();
489: a10 := JTF_NUMBER_TABLE();
490: a11 := JTF_NUMBER_TABLE();
491: a12 := JTF_NUMBER_TABLE();
492: if t.count > 0 then
485: a6 := JTF_NUMBER_TABLE();
486: a7 := JTF_VARCHAR2_TABLE_100();
487: a8 := JTF_VARCHAR2_TABLE_300();
488: a9 := JTF_NUMBER_TABLE();
489: a10 := JTF_NUMBER_TABLE();
490: a11 := JTF_NUMBER_TABLE();
491: a12 := JTF_NUMBER_TABLE();
492: if t.count > 0 then
493: a0.extend(t.count);
486: a7 := JTF_VARCHAR2_TABLE_100();
487: a8 := JTF_VARCHAR2_TABLE_300();
488: a9 := JTF_NUMBER_TABLE();
489: a10 := JTF_NUMBER_TABLE();
490: a11 := JTF_NUMBER_TABLE();
491: a12 := JTF_NUMBER_TABLE();
492: if t.count > 0 then
493: a0.extend(t.count);
494: a1.extend(t.count);
487: a8 := JTF_VARCHAR2_TABLE_300();
488: a9 := JTF_NUMBER_TABLE();
489: a10 := JTF_NUMBER_TABLE();
490: a11 := JTF_NUMBER_TABLE();
491: a12 := JTF_NUMBER_TABLE();
492: if t.count > 0 then
493: a0.extend(t.count);
494: a1.extend(t.count);
495: a2.extend(t.count);
536: , p4_a0 NUMBER
537: , p4_a1 NUMBER
538: , p4_a2 NUMBER
539: , p4_a3 DATE
540: , p5_a0 JTF_NUMBER_TABLE
541: , p5_a1 JTF_NUMBER_TABLE
542: , p5_a2 JTF_NUMBER_TABLE
543: , p5_a3 JTF_NUMBER_TABLE
544: , p5_a4 JTF_NUMBER_TABLE
537: , p4_a1 NUMBER
538: , p4_a2 NUMBER
539: , p4_a3 DATE
540: , p5_a0 JTF_NUMBER_TABLE
541: , p5_a1 JTF_NUMBER_TABLE
542: , p5_a2 JTF_NUMBER_TABLE
543: , p5_a3 JTF_NUMBER_TABLE
544: , p5_a4 JTF_NUMBER_TABLE
545: , p5_a5 JTF_NUMBER_TABLE
538: , p4_a2 NUMBER
539: , p4_a3 DATE
540: , p5_a0 JTF_NUMBER_TABLE
541: , p5_a1 JTF_NUMBER_TABLE
542: , p5_a2 JTF_NUMBER_TABLE
543: , p5_a3 JTF_NUMBER_TABLE
544: , p5_a4 JTF_NUMBER_TABLE
545: , p5_a5 JTF_NUMBER_TABLE
546: , p5_a6 JTF_NUMBER_TABLE
539: , p4_a3 DATE
540: , p5_a0 JTF_NUMBER_TABLE
541: , p5_a1 JTF_NUMBER_TABLE
542: , p5_a2 JTF_NUMBER_TABLE
543: , p5_a3 JTF_NUMBER_TABLE
544: , p5_a4 JTF_NUMBER_TABLE
545: , p5_a5 JTF_NUMBER_TABLE
546: , p5_a6 JTF_NUMBER_TABLE
547: , p5_a7 JTF_VARCHAR2_TABLE_100
540: , p5_a0 JTF_NUMBER_TABLE
541: , p5_a1 JTF_NUMBER_TABLE
542: , p5_a2 JTF_NUMBER_TABLE
543: , p5_a3 JTF_NUMBER_TABLE
544: , p5_a4 JTF_NUMBER_TABLE
545: , p5_a5 JTF_NUMBER_TABLE
546: , p5_a6 JTF_NUMBER_TABLE
547: , p5_a7 JTF_VARCHAR2_TABLE_100
548: , p5_a8 JTF_VARCHAR2_TABLE_300
541: , p5_a1 JTF_NUMBER_TABLE
542: , p5_a2 JTF_NUMBER_TABLE
543: , p5_a3 JTF_NUMBER_TABLE
544: , p5_a4 JTF_NUMBER_TABLE
545: , p5_a5 JTF_NUMBER_TABLE
546: , p5_a6 JTF_NUMBER_TABLE
547: , p5_a7 JTF_VARCHAR2_TABLE_100
548: , p5_a8 JTF_VARCHAR2_TABLE_300
549: , p5_a9 JTF_NUMBER_TABLE
542: , p5_a2 JTF_NUMBER_TABLE
543: , p5_a3 JTF_NUMBER_TABLE
544: , p5_a4 JTF_NUMBER_TABLE
545: , p5_a5 JTF_NUMBER_TABLE
546: , p5_a6 JTF_NUMBER_TABLE
547: , p5_a7 JTF_VARCHAR2_TABLE_100
548: , p5_a8 JTF_VARCHAR2_TABLE_300
549: , p5_a9 JTF_NUMBER_TABLE
550: , p5_a10 JTF_NUMBER_TABLE
545: , p5_a5 JTF_NUMBER_TABLE
546: , p5_a6 JTF_NUMBER_TABLE
547: , p5_a7 JTF_VARCHAR2_TABLE_100
548: , p5_a8 JTF_VARCHAR2_TABLE_300
549: , p5_a9 JTF_NUMBER_TABLE
550: , p5_a10 JTF_NUMBER_TABLE
551: , p5_a11 JTF_NUMBER_TABLE
552: , p5_a12 JTF_NUMBER_TABLE
553: , x_return_status out nocopy VARCHAR2
546: , p5_a6 JTF_NUMBER_TABLE
547: , p5_a7 JTF_VARCHAR2_TABLE_100
548: , p5_a8 JTF_VARCHAR2_TABLE_300
549: , p5_a9 JTF_NUMBER_TABLE
550: , p5_a10 JTF_NUMBER_TABLE
551: , p5_a11 JTF_NUMBER_TABLE
552: , p5_a12 JTF_NUMBER_TABLE
553: , x_return_status out nocopy VARCHAR2
554: , x_msg_count out nocopy NUMBER
547: , p5_a7 JTF_VARCHAR2_TABLE_100
548: , p5_a8 JTF_VARCHAR2_TABLE_300
549: , p5_a9 JTF_NUMBER_TABLE
550: , p5_a10 JTF_NUMBER_TABLE
551: , p5_a11 JTF_NUMBER_TABLE
552: , p5_a12 JTF_NUMBER_TABLE
553: , x_return_status out nocopy VARCHAR2
554: , x_msg_count out nocopy NUMBER
555: , x_msg_data out nocopy VARCHAR2
548: , p5_a8 JTF_VARCHAR2_TABLE_300
549: , p5_a9 JTF_NUMBER_TABLE
550: , p5_a10 JTF_NUMBER_TABLE
551: , p5_a11 JTF_NUMBER_TABLE
552: , p5_a12 JTF_NUMBER_TABLE
553: , x_return_status out nocopy VARCHAR2
554: , x_msg_count out nocopy NUMBER
555: , x_msg_data out nocopy VARCHAR2
556: )
614: procedure create_offcycle_bills(p_api_version NUMBER
615: , p_init_msg_list VARCHAR2
616: , p_commit VARCHAR2
617: , p_validation_level NUMBER
618: , p4_a0 JTF_NUMBER_TABLE
619: , p4_a1 JTF_NUMBER_TABLE
620: , p4_a2 JTF_NUMBER_TABLE
621: , p4_a3 JTF_DATE_TABLE
622: , p5_a0 JTF_NUMBER_TABLE
615: , p_init_msg_list VARCHAR2
616: , p_commit VARCHAR2
617: , p_validation_level NUMBER
618: , p4_a0 JTF_NUMBER_TABLE
619: , p4_a1 JTF_NUMBER_TABLE
620: , p4_a2 JTF_NUMBER_TABLE
621: , p4_a3 JTF_DATE_TABLE
622: , p5_a0 JTF_NUMBER_TABLE
623: , p5_a1 JTF_NUMBER_TABLE
616: , p_commit VARCHAR2
617: , p_validation_level NUMBER
618: , p4_a0 JTF_NUMBER_TABLE
619: , p4_a1 JTF_NUMBER_TABLE
620: , p4_a2 JTF_NUMBER_TABLE
621: , p4_a3 JTF_DATE_TABLE
622: , p5_a0 JTF_NUMBER_TABLE
623: , p5_a1 JTF_NUMBER_TABLE
624: , p5_a2 JTF_NUMBER_TABLE
618: , p4_a0 JTF_NUMBER_TABLE
619: , p4_a1 JTF_NUMBER_TABLE
620: , p4_a2 JTF_NUMBER_TABLE
621: , p4_a3 JTF_DATE_TABLE
622: , p5_a0 JTF_NUMBER_TABLE
623: , p5_a1 JTF_NUMBER_TABLE
624: , p5_a2 JTF_NUMBER_TABLE
625: , p5_a3 JTF_NUMBER_TABLE
626: , p5_a4 JTF_NUMBER_TABLE
619: , p4_a1 JTF_NUMBER_TABLE
620: , p4_a2 JTF_NUMBER_TABLE
621: , p4_a3 JTF_DATE_TABLE
622: , p5_a0 JTF_NUMBER_TABLE
623: , p5_a1 JTF_NUMBER_TABLE
624: , p5_a2 JTF_NUMBER_TABLE
625: , p5_a3 JTF_NUMBER_TABLE
626: , p5_a4 JTF_NUMBER_TABLE
627: , p5_a5 JTF_NUMBER_TABLE
620: , p4_a2 JTF_NUMBER_TABLE
621: , p4_a3 JTF_DATE_TABLE
622: , p5_a0 JTF_NUMBER_TABLE
623: , p5_a1 JTF_NUMBER_TABLE
624: , p5_a2 JTF_NUMBER_TABLE
625: , p5_a3 JTF_NUMBER_TABLE
626: , p5_a4 JTF_NUMBER_TABLE
627: , p5_a5 JTF_NUMBER_TABLE
628: , p5_a6 JTF_NUMBER_TABLE
621: , p4_a3 JTF_DATE_TABLE
622: , p5_a0 JTF_NUMBER_TABLE
623: , p5_a1 JTF_NUMBER_TABLE
624: , p5_a2 JTF_NUMBER_TABLE
625: , p5_a3 JTF_NUMBER_TABLE
626: , p5_a4 JTF_NUMBER_TABLE
627: , p5_a5 JTF_NUMBER_TABLE
628: , p5_a6 JTF_NUMBER_TABLE
629: , p5_a7 JTF_VARCHAR2_TABLE_100
622: , p5_a0 JTF_NUMBER_TABLE
623: , p5_a1 JTF_NUMBER_TABLE
624: , p5_a2 JTF_NUMBER_TABLE
625: , p5_a3 JTF_NUMBER_TABLE
626: , p5_a4 JTF_NUMBER_TABLE
627: , p5_a5 JTF_NUMBER_TABLE
628: , p5_a6 JTF_NUMBER_TABLE
629: , p5_a7 JTF_VARCHAR2_TABLE_100
630: , p5_a8 JTF_VARCHAR2_TABLE_300
623: , p5_a1 JTF_NUMBER_TABLE
624: , p5_a2 JTF_NUMBER_TABLE
625: , p5_a3 JTF_NUMBER_TABLE
626: , p5_a4 JTF_NUMBER_TABLE
627: , p5_a5 JTF_NUMBER_TABLE
628: , p5_a6 JTF_NUMBER_TABLE
629: , p5_a7 JTF_VARCHAR2_TABLE_100
630: , p5_a8 JTF_VARCHAR2_TABLE_300
631: , p5_a9 JTF_NUMBER_TABLE
624: , p5_a2 JTF_NUMBER_TABLE
625: , p5_a3 JTF_NUMBER_TABLE
626: , p5_a4 JTF_NUMBER_TABLE
627: , p5_a5 JTF_NUMBER_TABLE
628: , p5_a6 JTF_NUMBER_TABLE
629: , p5_a7 JTF_VARCHAR2_TABLE_100
630: , p5_a8 JTF_VARCHAR2_TABLE_300
631: , p5_a9 JTF_NUMBER_TABLE
632: , p5_a10 JTF_NUMBER_TABLE
627: , p5_a5 JTF_NUMBER_TABLE
628: , p5_a6 JTF_NUMBER_TABLE
629: , p5_a7 JTF_VARCHAR2_TABLE_100
630: , p5_a8 JTF_VARCHAR2_TABLE_300
631: , p5_a9 JTF_NUMBER_TABLE
632: , p5_a10 JTF_NUMBER_TABLE
633: , p5_a11 JTF_NUMBER_TABLE
634: , p5_a12 JTF_NUMBER_TABLE
635: , x_return_status out nocopy VARCHAR2
628: , p5_a6 JTF_NUMBER_TABLE
629: , p5_a7 JTF_VARCHAR2_TABLE_100
630: , p5_a8 JTF_VARCHAR2_TABLE_300
631: , p5_a9 JTF_NUMBER_TABLE
632: , p5_a10 JTF_NUMBER_TABLE
633: , p5_a11 JTF_NUMBER_TABLE
634: , p5_a12 JTF_NUMBER_TABLE
635: , x_return_status out nocopy VARCHAR2
636: , x_msg_count out nocopy NUMBER
629: , p5_a7 JTF_VARCHAR2_TABLE_100
630: , p5_a8 JTF_VARCHAR2_TABLE_300
631: , p5_a9 JTF_NUMBER_TABLE
632: , p5_a10 JTF_NUMBER_TABLE
633: , p5_a11 JTF_NUMBER_TABLE
634: , p5_a12 JTF_NUMBER_TABLE
635: , x_return_status out nocopy VARCHAR2
636: , x_msg_count out nocopy NUMBER
637: , x_msg_data out nocopy VARCHAR2
630: , p5_a8 JTF_VARCHAR2_TABLE_300
631: , p5_a9 JTF_NUMBER_TABLE
632: , p5_a10 JTF_NUMBER_TABLE
633: , p5_a11 JTF_NUMBER_TABLE
634: , p5_a12 JTF_NUMBER_TABLE
635: , x_return_status out nocopy VARCHAR2
636: , x_msg_count out nocopy NUMBER
637: , x_msg_data out nocopy VARCHAR2
638: )