1: package body okl_rca_pvt_w as
2: /* $Header: OKLIRCAB.pls 120.0 2007/11/19 10:31:58 rviriyal noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rca_pvt.rca_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package body okl_rca_pvt_w as
2: /* $Header: OKLIRCAB.pls 120.0 2007/11/19 10:31:58 rviriyal noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rca_pvt.rca_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
1: package body okl_rca_pvt_w as
2: /* $Header: OKLIRCAB.pls 120.0 2007/11/19 10:31:58 rviriyal noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rca_pvt.rca_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
2: /* $Header: OKLIRCAB.pls 120.0 2007/11/19 10:31:58 rviriyal noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rca_pvt.rca_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rca_pvt.rca_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_500
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_500
20: , a17 JTF_VARCHAR2_TABLE_500
21: , a18 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_VARCHAR2_TABLE_500
33: , a30 JTF_VARCHAR2_TABLE_500
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_500
33: , a30 JTF_VARCHAR2_TABLE_500
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_NUMBER_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_NUMBER_TABLE
41: ) as
42: ddindx binary_integer; indx binary_integer;
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_NUMBER_TABLE
41: ) as
42: ddindx binary_integer; indx binary_integer;
43: begin
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_NUMBER_TABLE
41: ) as
42: ddindx binary_integer; indx binary_integer;
43: begin
44: if a0 is not null and a0.count > 0 then
92: end loop;
93: end if;
94: end if;
95: end rosetta_table_copy_in_p2;
96: procedure rosetta_table_copy_out_p2(t okl_rca_pvt.rca_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_NUMBER_TABLE
98: , a2 out nocopy JTF_NUMBER_TABLE
99: , a3 out nocopy JTF_NUMBER_TABLE
100: , a4 out nocopy JTF_NUMBER_TABLE
93: end if;
94: end if;
95: end rosetta_table_copy_in_p2;
96: procedure rosetta_table_copy_out_p2(t okl_rca_pvt.rca_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_NUMBER_TABLE
98: , a2 out nocopy JTF_NUMBER_TABLE
99: , a3 out nocopy JTF_NUMBER_TABLE
100: , a4 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_NUMBER_TABLE
94: end if;
95: end rosetta_table_copy_in_p2;
96: procedure rosetta_table_copy_out_p2(t okl_rca_pvt.rca_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_NUMBER_TABLE
98: , a2 out nocopy JTF_NUMBER_TABLE
99: , a3 out nocopy JTF_NUMBER_TABLE
100: , a4 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_NUMBER_TABLE
102: , a6 out nocopy JTF_NUMBER_TABLE
95: end rosetta_table_copy_in_p2;
96: procedure rosetta_table_copy_out_p2(t okl_rca_pvt.rca_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_NUMBER_TABLE
98: , a2 out nocopy JTF_NUMBER_TABLE
99: , a3 out nocopy JTF_NUMBER_TABLE
100: , a4 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_NUMBER_TABLE
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
96: procedure rosetta_table_copy_out_p2(t okl_rca_pvt.rca_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_NUMBER_TABLE
98: , a2 out nocopy JTF_NUMBER_TABLE
99: , a3 out nocopy JTF_NUMBER_TABLE
100: , a4 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_NUMBER_TABLE
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_NUMBER_TABLE
98: , a2 out nocopy JTF_NUMBER_TABLE
99: , a3 out nocopy JTF_NUMBER_TABLE
100: , a4 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_NUMBER_TABLE
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_NUMBER_TABLE
98: , a2 out nocopy JTF_NUMBER_TABLE
99: , a3 out nocopy JTF_NUMBER_TABLE
100: , a4 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_NUMBER_TABLE
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_NUMBER_TABLE
106: , a10 out nocopy JTF_NUMBER_TABLE
99: , a3 out nocopy JTF_NUMBER_TABLE
100: , a4 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_NUMBER_TABLE
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_NUMBER_TABLE
106: , a10 out nocopy JTF_NUMBER_TABLE
107: , a11 out nocopy JTF_NUMBER_TABLE
100: , a4 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_NUMBER_TABLE
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_NUMBER_TABLE
106: , a10 out nocopy JTF_NUMBER_TABLE
107: , a11 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_NUMBER_TABLE
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_NUMBER_TABLE
106: , a10 out nocopy JTF_NUMBER_TABLE
107: , a11 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_NUMBER_TABLE
109: , a13 out nocopy JTF_DATE_TABLE
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_NUMBER_TABLE
106: , a10 out nocopy JTF_NUMBER_TABLE
107: , a11 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_NUMBER_TABLE
109: , a13 out nocopy JTF_DATE_TABLE
110: , a14 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_NUMBER_TABLE
106: , a10 out nocopy JTF_NUMBER_TABLE
107: , a11 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_NUMBER_TABLE
109: , a13 out nocopy JTF_DATE_TABLE
110: , a14 out nocopy JTF_NUMBER_TABLE
111: , a15 out nocopy JTF_VARCHAR2_TABLE_100
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_NUMBER_TABLE
106: , a10 out nocopy JTF_NUMBER_TABLE
107: , a11 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_NUMBER_TABLE
109: , a13 out nocopy JTF_DATE_TABLE
110: , a14 out nocopy JTF_NUMBER_TABLE
111: , a15 out nocopy JTF_VARCHAR2_TABLE_100
112: , a16 out nocopy JTF_VARCHAR2_TABLE_500
106: , a10 out nocopy JTF_NUMBER_TABLE
107: , a11 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_NUMBER_TABLE
109: , a13 out nocopy JTF_DATE_TABLE
110: , a14 out nocopy JTF_NUMBER_TABLE
111: , a15 out nocopy JTF_VARCHAR2_TABLE_100
112: , a16 out nocopy JTF_VARCHAR2_TABLE_500
113: , a17 out nocopy JTF_VARCHAR2_TABLE_500
114: , a18 out nocopy JTF_VARCHAR2_TABLE_500
123: , a27 out nocopy JTF_VARCHAR2_TABLE_500
124: , a28 out nocopy JTF_VARCHAR2_TABLE_500
125: , a29 out nocopy JTF_VARCHAR2_TABLE_500
126: , a30 out nocopy JTF_VARCHAR2_TABLE_500
127: , a31 out nocopy JTF_NUMBER_TABLE
128: , a32 out nocopy JTF_DATE_TABLE
129: , a33 out nocopy JTF_NUMBER_TABLE
130: , a34 out nocopy JTF_DATE_TABLE
131: , a35 out nocopy JTF_NUMBER_TABLE
125: , a29 out nocopy JTF_VARCHAR2_TABLE_500
126: , a30 out nocopy JTF_VARCHAR2_TABLE_500
127: , a31 out nocopy JTF_NUMBER_TABLE
128: , a32 out nocopy JTF_DATE_TABLE
129: , a33 out nocopy JTF_NUMBER_TABLE
130: , a34 out nocopy JTF_DATE_TABLE
131: , a35 out nocopy JTF_NUMBER_TABLE
132: , a36 out nocopy JTF_NUMBER_TABLE
133: , a37 out nocopy JTF_NUMBER_TABLE
127: , a31 out nocopy JTF_NUMBER_TABLE
128: , a32 out nocopy JTF_DATE_TABLE
129: , a33 out nocopy JTF_NUMBER_TABLE
130: , a34 out nocopy JTF_DATE_TABLE
131: , a35 out nocopy JTF_NUMBER_TABLE
132: , a36 out nocopy JTF_NUMBER_TABLE
133: , a37 out nocopy JTF_NUMBER_TABLE
134: ) as
135: ddindx binary_integer; indx binary_integer;
128: , a32 out nocopy JTF_DATE_TABLE
129: , a33 out nocopy JTF_NUMBER_TABLE
130: , a34 out nocopy JTF_DATE_TABLE
131: , a35 out nocopy JTF_NUMBER_TABLE
132: , a36 out nocopy JTF_NUMBER_TABLE
133: , a37 out nocopy JTF_NUMBER_TABLE
134: ) as
135: ddindx binary_integer; indx binary_integer;
136: begin
129: , a33 out nocopy JTF_NUMBER_TABLE
130: , a34 out nocopy JTF_DATE_TABLE
131: , a35 out nocopy JTF_NUMBER_TABLE
132: , a36 out nocopy JTF_NUMBER_TABLE
133: , a37 out nocopy JTF_NUMBER_TABLE
134: ) as
135: ddindx binary_integer; indx binary_integer;
136: begin
137: if t is null or t.count = 0 then
134: ) as
135: ddindx binary_integer; indx binary_integer;
136: begin
137: if t is null or t.count = 0 then
138: a0 := JTF_NUMBER_TABLE();
139: a1 := JTF_NUMBER_TABLE();
140: a2 := JTF_NUMBER_TABLE();
141: a3 := JTF_NUMBER_TABLE();
142: a4 := JTF_NUMBER_TABLE();
135: ddindx binary_integer; indx binary_integer;
136: begin
137: if t is null or t.count = 0 then
138: a0 := JTF_NUMBER_TABLE();
139: a1 := JTF_NUMBER_TABLE();
140: a2 := JTF_NUMBER_TABLE();
141: a3 := JTF_NUMBER_TABLE();
142: a4 := JTF_NUMBER_TABLE();
143: a5 := JTF_NUMBER_TABLE();
136: begin
137: if t is null or t.count = 0 then
138: a0 := JTF_NUMBER_TABLE();
139: a1 := JTF_NUMBER_TABLE();
140: a2 := JTF_NUMBER_TABLE();
141: a3 := JTF_NUMBER_TABLE();
142: a4 := JTF_NUMBER_TABLE();
143: a5 := JTF_NUMBER_TABLE();
144: a6 := JTF_NUMBER_TABLE();
137: if t is null or t.count = 0 then
138: a0 := JTF_NUMBER_TABLE();
139: a1 := JTF_NUMBER_TABLE();
140: a2 := JTF_NUMBER_TABLE();
141: a3 := JTF_NUMBER_TABLE();
142: a4 := JTF_NUMBER_TABLE();
143: a5 := JTF_NUMBER_TABLE();
144: a6 := JTF_NUMBER_TABLE();
145: a7 := JTF_NUMBER_TABLE();
138: a0 := JTF_NUMBER_TABLE();
139: a1 := JTF_NUMBER_TABLE();
140: a2 := JTF_NUMBER_TABLE();
141: a3 := JTF_NUMBER_TABLE();
142: a4 := JTF_NUMBER_TABLE();
143: a5 := JTF_NUMBER_TABLE();
144: a6 := JTF_NUMBER_TABLE();
145: a7 := JTF_NUMBER_TABLE();
146: a8 := JTF_NUMBER_TABLE();
139: a1 := JTF_NUMBER_TABLE();
140: a2 := JTF_NUMBER_TABLE();
141: a3 := JTF_NUMBER_TABLE();
142: a4 := JTF_NUMBER_TABLE();
143: a5 := JTF_NUMBER_TABLE();
144: a6 := JTF_NUMBER_TABLE();
145: a7 := JTF_NUMBER_TABLE();
146: a8 := JTF_NUMBER_TABLE();
147: a9 := JTF_NUMBER_TABLE();
140: a2 := JTF_NUMBER_TABLE();
141: a3 := JTF_NUMBER_TABLE();
142: a4 := JTF_NUMBER_TABLE();
143: a5 := JTF_NUMBER_TABLE();
144: a6 := JTF_NUMBER_TABLE();
145: a7 := JTF_NUMBER_TABLE();
146: a8 := JTF_NUMBER_TABLE();
147: a9 := JTF_NUMBER_TABLE();
148: a10 := JTF_NUMBER_TABLE();
141: a3 := JTF_NUMBER_TABLE();
142: a4 := JTF_NUMBER_TABLE();
143: a5 := JTF_NUMBER_TABLE();
144: a6 := JTF_NUMBER_TABLE();
145: a7 := JTF_NUMBER_TABLE();
146: a8 := JTF_NUMBER_TABLE();
147: a9 := JTF_NUMBER_TABLE();
148: a10 := JTF_NUMBER_TABLE();
149: a11 := JTF_NUMBER_TABLE();
142: a4 := JTF_NUMBER_TABLE();
143: a5 := JTF_NUMBER_TABLE();
144: a6 := JTF_NUMBER_TABLE();
145: a7 := JTF_NUMBER_TABLE();
146: a8 := JTF_NUMBER_TABLE();
147: a9 := JTF_NUMBER_TABLE();
148: a10 := JTF_NUMBER_TABLE();
149: a11 := JTF_NUMBER_TABLE();
150: a12 := JTF_NUMBER_TABLE();
143: a5 := JTF_NUMBER_TABLE();
144: a6 := JTF_NUMBER_TABLE();
145: a7 := JTF_NUMBER_TABLE();
146: a8 := JTF_NUMBER_TABLE();
147: a9 := JTF_NUMBER_TABLE();
148: a10 := JTF_NUMBER_TABLE();
149: a11 := JTF_NUMBER_TABLE();
150: a12 := JTF_NUMBER_TABLE();
151: a13 := JTF_DATE_TABLE();
144: a6 := JTF_NUMBER_TABLE();
145: a7 := JTF_NUMBER_TABLE();
146: a8 := JTF_NUMBER_TABLE();
147: a9 := JTF_NUMBER_TABLE();
148: a10 := JTF_NUMBER_TABLE();
149: a11 := JTF_NUMBER_TABLE();
150: a12 := JTF_NUMBER_TABLE();
151: a13 := JTF_DATE_TABLE();
152: a14 := JTF_NUMBER_TABLE();
145: a7 := JTF_NUMBER_TABLE();
146: a8 := JTF_NUMBER_TABLE();
147: a9 := JTF_NUMBER_TABLE();
148: a10 := JTF_NUMBER_TABLE();
149: a11 := JTF_NUMBER_TABLE();
150: a12 := JTF_NUMBER_TABLE();
151: a13 := JTF_DATE_TABLE();
152: a14 := JTF_NUMBER_TABLE();
153: a15 := JTF_VARCHAR2_TABLE_100();
146: a8 := JTF_NUMBER_TABLE();
147: a9 := JTF_NUMBER_TABLE();
148: a10 := JTF_NUMBER_TABLE();
149: a11 := JTF_NUMBER_TABLE();
150: a12 := JTF_NUMBER_TABLE();
151: a13 := JTF_DATE_TABLE();
152: a14 := JTF_NUMBER_TABLE();
153: a15 := JTF_VARCHAR2_TABLE_100();
154: a16 := JTF_VARCHAR2_TABLE_500();
148: a10 := JTF_NUMBER_TABLE();
149: a11 := JTF_NUMBER_TABLE();
150: a12 := JTF_NUMBER_TABLE();
151: a13 := JTF_DATE_TABLE();
152: a14 := JTF_NUMBER_TABLE();
153: a15 := JTF_VARCHAR2_TABLE_100();
154: a16 := JTF_VARCHAR2_TABLE_500();
155: a17 := JTF_VARCHAR2_TABLE_500();
156: a18 := JTF_VARCHAR2_TABLE_500();
165: a27 := JTF_VARCHAR2_TABLE_500();
166: a28 := JTF_VARCHAR2_TABLE_500();
167: a29 := JTF_VARCHAR2_TABLE_500();
168: a30 := JTF_VARCHAR2_TABLE_500();
169: a31 := JTF_NUMBER_TABLE();
170: a32 := JTF_DATE_TABLE();
171: a33 := JTF_NUMBER_TABLE();
172: a34 := JTF_DATE_TABLE();
173: a35 := JTF_NUMBER_TABLE();
167: a29 := JTF_VARCHAR2_TABLE_500();
168: a30 := JTF_VARCHAR2_TABLE_500();
169: a31 := JTF_NUMBER_TABLE();
170: a32 := JTF_DATE_TABLE();
171: a33 := JTF_NUMBER_TABLE();
172: a34 := JTF_DATE_TABLE();
173: a35 := JTF_NUMBER_TABLE();
174: a36 := JTF_NUMBER_TABLE();
175: a37 := JTF_NUMBER_TABLE();
169: a31 := JTF_NUMBER_TABLE();
170: a32 := JTF_DATE_TABLE();
171: a33 := JTF_NUMBER_TABLE();
172: a34 := JTF_DATE_TABLE();
173: a35 := JTF_NUMBER_TABLE();
174: a36 := JTF_NUMBER_TABLE();
175: a37 := JTF_NUMBER_TABLE();
176: else
177: a0 := JTF_NUMBER_TABLE();
170: a32 := JTF_DATE_TABLE();
171: a33 := JTF_NUMBER_TABLE();
172: a34 := JTF_DATE_TABLE();
173: a35 := JTF_NUMBER_TABLE();
174: a36 := JTF_NUMBER_TABLE();
175: a37 := JTF_NUMBER_TABLE();
176: else
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
171: a33 := JTF_NUMBER_TABLE();
172: a34 := JTF_DATE_TABLE();
173: a35 := JTF_NUMBER_TABLE();
174: a36 := JTF_NUMBER_TABLE();
175: a37 := JTF_NUMBER_TABLE();
176: else
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_NUMBER_TABLE();
173: a35 := JTF_NUMBER_TABLE();
174: a36 := JTF_NUMBER_TABLE();
175: a37 := JTF_NUMBER_TABLE();
176: else
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_NUMBER_TABLE();
181: a4 := JTF_NUMBER_TABLE();
174: a36 := JTF_NUMBER_TABLE();
175: a37 := JTF_NUMBER_TABLE();
176: else
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_NUMBER_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_NUMBER_TABLE();
175: a37 := JTF_NUMBER_TABLE();
176: else
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_NUMBER_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_NUMBER_TABLE();
176: else
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_NUMBER_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_NUMBER_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_NUMBER_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_NUMBER_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_NUMBER_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_NUMBER_TABLE();
187: a10 := JTF_NUMBER_TABLE();
180: a3 := JTF_NUMBER_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_NUMBER_TABLE();
187: a10 := JTF_NUMBER_TABLE();
188: a11 := JTF_NUMBER_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_NUMBER_TABLE();
187: a10 := JTF_NUMBER_TABLE();
188: a11 := JTF_NUMBER_TABLE();
189: a12 := JTF_NUMBER_TABLE();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_NUMBER_TABLE();
187: a10 := JTF_NUMBER_TABLE();
188: a11 := JTF_NUMBER_TABLE();
189: a12 := JTF_NUMBER_TABLE();
190: a13 := JTF_DATE_TABLE();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_NUMBER_TABLE();
187: a10 := JTF_NUMBER_TABLE();
188: a11 := JTF_NUMBER_TABLE();
189: a12 := JTF_NUMBER_TABLE();
190: a13 := JTF_DATE_TABLE();
191: a14 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_NUMBER_TABLE();
187: a10 := JTF_NUMBER_TABLE();
188: a11 := JTF_NUMBER_TABLE();
189: a12 := JTF_NUMBER_TABLE();
190: a13 := JTF_DATE_TABLE();
191: a14 := JTF_NUMBER_TABLE();
192: a15 := JTF_VARCHAR2_TABLE_100();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_NUMBER_TABLE();
187: a10 := JTF_NUMBER_TABLE();
188: a11 := JTF_NUMBER_TABLE();
189: a12 := JTF_NUMBER_TABLE();
190: a13 := JTF_DATE_TABLE();
191: a14 := JTF_NUMBER_TABLE();
192: a15 := JTF_VARCHAR2_TABLE_100();
193: a16 := JTF_VARCHAR2_TABLE_500();
187: a10 := JTF_NUMBER_TABLE();
188: a11 := JTF_NUMBER_TABLE();
189: a12 := JTF_NUMBER_TABLE();
190: a13 := JTF_DATE_TABLE();
191: a14 := JTF_NUMBER_TABLE();
192: a15 := JTF_VARCHAR2_TABLE_100();
193: a16 := JTF_VARCHAR2_TABLE_500();
194: a17 := JTF_VARCHAR2_TABLE_500();
195: a18 := JTF_VARCHAR2_TABLE_500();
204: a27 := JTF_VARCHAR2_TABLE_500();
205: a28 := JTF_VARCHAR2_TABLE_500();
206: a29 := JTF_VARCHAR2_TABLE_500();
207: a30 := JTF_VARCHAR2_TABLE_500();
208: a31 := JTF_NUMBER_TABLE();
209: a32 := JTF_DATE_TABLE();
210: a33 := JTF_NUMBER_TABLE();
211: a34 := JTF_DATE_TABLE();
212: a35 := JTF_NUMBER_TABLE();
206: a29 := JTF_VARCHAR2_TABLE_500();
207: a30 := JTF_VARCHAR2_TABLE_500();
208: a31 := JTF_NUMBER_TABLE();
209: a32 := JTF_DATE_TABLE();
210: a33 := JTF_NUMBER_TABLE();
211: a34 := JTF_DATE_TABLE();
212: a35 := JTF_NUMBER_TABLE();
213: a36 := JTF_NUMBER_TABLE();
214: a37 := JTF_NUMBER_TABLE();
208: a31 := JTF_NUMBER_TABLE();
209: a32 := JTF_DATE_TABLE();
210: a33 := JTF_NUMBER_TABLE();
211: a34 := JTF_DATE_TABLE();
212: a35 := JTF_NUMBER_TABLE();
213: a36 := JTF_NUMBER_TABLE();
214: a37 := JTF_NUMBER_TABLE();
215: if t.count > 0 then
216: a0.extend(t.count);
209: a32 := JTF_DATE_TABLE();
210: a33 := JTF_NUMBER_TABLE();
211: a34 := JTF_DATE_TABLE();
212: a35 := JTF_NUMBER_TABLE();
213: a36 := JTF_NUMBER_TABLE();
214: a37 := JTF_NUMBER_TABLE();
215: if t.count > 0 then
216: a0.extend(t.count);
217: a1.extend(t.count);
210: a33 := JTF_NUMBER_TABLE();
211: a34 := JTF_DATE_TABLE();
212: a35 := JTF_NUMBER_TABLE();
213: a36 := JTF_NUMBER_TABLE();
214: a37 := JTF_NUMBER_TABLE();
215: if t.count > 0 then
216: a0.extend(t.count);
217: a1.extend(t.count);
218: a2.extend(t.count);
301: end if;
302: end if;
303: end rosetta_table_copy_out_p2;
304:
305: procedure rosetta_table_copy_in_p5(t out nocopy okl_rca_pvt.okl_txl_rcpt_apps_tl_tbl_type, a0 JTF_NUMBER_TABLE
306: , a1 JTF_VARCHAR2_TABLE_100
307: , a2 JTF_VARCHAR2_TABLE_100
308: , a3 JTF_VARCHAR2_TABLE_100
309: , a4 JTF_VARCHAR2_TABLE_2000
306: , a1 JTF_VARCHAR2_TABLE_100
307: , a2 JTF_VARCHAR2_TABLE_100
308: , a3 JTF_VARCHAR2_TABLE_100
309: , a4 JTF_VARCHAR2_TABLE_2000
310: , a5 JTF_NUMBER_TABLE
311: , a6 JTF_DATE_TABLE
312: , a7 JTF_NUMBER_TABLE
313: , a8 JTF_DATE_TABLE
314: , a9 JTF_NUMBER_TABLE
308: , a3 JTF_VARCHAR2_TABLE_100
309: , a4 JTF_VARCHAR2_TABLE_2000
310: , a5 JTF_NUMBER_TABLE
311: , a6 JTF_DATE_TABLE
312: , a7 JTF_NUMBER_TABLE
313: , a8 JTF_DATE_TABLE
314: , a9 JTF_NUMBER_TABLE
315: ) as
316: ddindx binary_integer; indx binary_integer;
310: , a5 JTF_NUMBER_TABLE
311: , a6 JTF_DATE_TABLE
312: , a7 JTF_NUMBER_TABLE
313: , a8 JTF_DATE_TABLE
314: , a9 JTF_NUMBER_TABLE
315: ) as
316: ddindx binary_integer; indx binary_integer;
317: begin
318: if a0 is not null and a0.count > 0 then
338: end loop;
339: end if;
340: end if;
341: end rosetta_table_copy_in_p5;
342: procedure rosetta_table_copy_out_p5(t okl_rca_pvt.okl_txl_rcpt_apps_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
343: , a1 out nocopy JTF_VARCHAR2_TABLE_100
344: , a2 out nocopy JTF_VARCHAR2_TABLE_100
345: , a3 out nocopy JTF_VARCHAR2_TABLE_100
346: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
343: , a1 out nocopy JTF_VARCHAR2_TABLE_100
344: , a2 out nocopy JTF_VARCHAR2_TABLE_100
345: , a3 out nocopy JTF_VARCHAR2_TABLE_100
346: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
347: , a5 out nocopy JTF_NUMBER_TABLE
348: , a6 out nocopy JTF_DATE_TABLE
349: , a7 out nocopy JTF_NUMBER_TABLE
350: , a8 out nocopy JTF_DATE_TABLE
351: , a9 out nocopy JTF_NUMBER_TABLE
345: , a3 out nocopy JTF_VARCHAR2_TABLE_100
346: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
347: , a5 out nocopy JTF_NUMBER_TABLE
348: , a6 out nocopy JTF_DATE_TABLE
349: , a7 out nocopy JTF_NUMBER_TABLE
350: , a8 out nocopy JTF_DATE_TABLE
351: , a9 out nocopy JTF_NUMBER_TABLE
352: ) as
353: ddindx binary_integer; indx binary_integer;
347: , a5 out nocopy JTF_NUMBER_TABLE
348: , a6 out nocopy JTF_DATE_TABLE
349: , a7 out nocopy JTF_NUMBER_TABLE
350: , a8 out nocopy JTF_DATE_TABLE
351: , a9 out nocopy JTF_NUMBER_TABLE
352: ) as
353: ddindx binary_integer; indx binary_integer;
354: begin
355: if t is null or t.count = 0 then
352: ) as
353: ddindx binary_integer; indx binary_integer;
354: begin
355: if t is null or t.count = 0 then
356: a0 := JTF_NUMBER_TABLE();
357: a1 := JTF_VARCHAR2_TABLE_100();
358: a2 := JTF_VARCHAR2_TABLE_100();
359: a3 := JTF_VARCHAR2_TABLE_100();
360: a4 := JTF_VARCHAR2_TABLE_2000();
357: a1 := JTF_VARCHAR2_TABLE_100();
358: a2 := JTF_VARCHAR2_TABLE_100();
359: a3 := JTF_VARCHAR2_TABLE_100();
360: a4 := JTF_VARCHAR2_TABLE_2000();
361: a5 := JTF_NUMBER_TABLE();
362: a6 := JTF_DATE_TABLE();
363: a7 := JTF_NUMBER_TABLE();
364: a8 := JTF_DATE_TABLE();
365: a9 := JTF_NUMBER_TABLE();
359: a3 := JTF_VARCHAR2_TABLE_100();
360: a4 := JTF_VARCHAR2_TABLE_2000();
361: a5 := JTF_NUMBER_TABLE();
362: a6 := JTF_DATE_TABLE();
363: a7 := JTF_NUMBER_TABLE();
364: a8 := JTF_DATE_TABLE();
365: a9 := JTF_NUMBER_TABLE();
366: else
367: a0 := JTF_NUMBER_TABLE();
361: a5 := JTF_NUMBER_TABLE();
362: a6 := JTF_DATE_TABLE();
363: a7 := JTF_NUMBER_TABLE();
364: a8 := JTF_DATE_TABLE();
365: a9 := JTF_NUMBER_TABLE();
366: else
367: a0 := JTF_NUMBER_TABLE();
368: a1 := JTF_VARCHAR2_TABLE_100();
369: a2 := JTF_VARCHAR2_TABLE_100();
363: a7 := JTF_NUMBER_TABLE();
364: a8 := JTF_DATE_TABLE();
365: a9 := JTF_NUMBER_TABLE();
366: else
367: a0 := JTF_NUMBER_TABLE();
368: a1 := JTF_VARCHAR2_TABLE_100();
369: a2 := JTF_VARCHAR2_TABLE_100();
370: a3 := JTF_VARCHAR2_TABLE_100();
371: a4 := JTF_VARCHAR2_TABLE_2000();
368: a1 := JTF_VARCHAR2_TABLE_100();
369: a2 := JTF_VARCHAR2_TABLE_100();
370: a3 := JTF_VARCHAR2_TABLE_100();
371: a4 := JTF_VARCHAR2_TABLE_2000();
372: a5 := JTF_NUMBER_TABLE();
373: a6 := JTF_DATE_TABLE();
374: a7 := JTF_NUMBER_TABLE();
375: a8 := JTF_DATE_TABLE();
376: a9 := JTF_NUMBER_TABLE();
370: a3 := JTF_VARCHAR2_TABLE_100();
371: a4 := JTF_VARCHAR2_TABLE_2000();
372: a5 := JTF_NUMBER_TABLE();
373: a6 := JTF_DATE_TABLE();
374: a7 := JTF_NUMBER_TABLE();
375: a8 := JTF_DATE_TABLE();
376: a9 := JTF_NUMBER_TABLE();
377: if t.count > 0 then
378: a0.extend(t.count);
372: a5 := JTF_NUMBER_TABLE();
373: a6 := JTF_DATE_TABLE();
374: a7 := JTF_NUMBER_TABLE();
375: a8 := JTF_DATE_TABLE();
376: a9 := JTF_NUMBER_TABLE();
377: if t.count > 0 then
378: a0.extend(t.count);
379: a1.extend(t.count);
380: a2.extend(t.count);
407: end if;
408: end if;
409: end rosetta_table_copy_out_p5;
410:
411: procedure rosetta_table_copy_in_p8(t out nocopy okl_rca_pvt.rcav_tbl_type, a0 JTF_NUMBER_TABLE
412: , a1 JTF_NUMBER_TABLE
413: , a2 JTF_VARCHAR2_TABLE_100
414: , a3 JTF_NUMBER_TABLE
415: , a4 JTF_NUMBER_TABLE
408: end if;
409: end rosetta_table_copy_out_p5;
410:
411: procedure rosetta_table_copy_in_p8(t out nocopy okl_rca_pvt.rcav_tbl_type, a0 JTF_NUMBER_TABLE
412: , a1 JTF_NUMBER_TABLE
413: , a2 JTF_VARCHAR2_TABLE_100
414: , a3 JTF_NUMBER_TABLE
415: , a4 JTF_NUMBER_TABLE
416: , a5 JTF_NUMBER_TABLE
410:
411: procedure rosetta_table_copy_in_p8(t out nocopy okl_rca_pvt.rcav_tbl_type, a0 JTF_NUMBER_TABLE
412: , a1 JTF_NUMBER_TABLE
413: , a2 JTF_VARCHAR2_TABLE_100
414: , a3 JTF_NUMBER_TABLE
415: , a4 JTF_NUMBER_TABLE
416: , a5 JTF_NUMBER_TABLE
417: , a6 JTF_NUMBER_TABLE
418: , a7 JTF_NUMBER_TABLE
411: procedure rosetta_table_copy_in_p8(t out nocopy okl_rca_pvt.rcav_tbl_type, a0 JTF_NUMBER_TABLE
412: , a1 JTF_NUMBER_TABLE
413: , a2 JTF_VARCHAR2_TABLE_100
414: , a3 JTF_NUMBER_TABLE
415: , a4 JTF_NUMBER_TABLE
416: , a5 JTF_NUMBER_TABLE
417: , a6 JTF_NUMBER_TABLE
418: , a7 JTF_NUMBER_TABLE
419: , a8 JTF_NUMBER_TABLE
412: , a1 JTF_NUMBER_TABLE
413: , a2 JTF_VARCHAR2_TABLE_100
414: , a3 JTF_NUMBER_TABLE
415: , a4 JTF_NUMBER_TABLE
416: , a5 JTF_NUMBER_TABLE
417: , a6 JTF_NUMBER_TABLE
418: , a7 JTF_NUMBER_TABLE
419: , a8 JTF_NUMBER_TABLE
420: , a9 JTF_NUMBER_TABLE
413: , a2 JTF_VARCHAR2_TABLE_100
414: , a3 JTF_NUMBER_TABLE
415: , a4 JTF_NUMBER_TABLE
416: , a5 JTF_NUMBER_TABLE
417: , a6 JTF_NUMBER_TABLE
418: , a7 JTF_NUMBER_TABLE
419: , a8 JTF_NUMBER_TABLE
420: , a9 JTF_NUMBER_TABLE
421: , a10 JTF_VARCHAR2_TABLE_2000
414: , a3 JTF_NUMBER_TABLE
415: , a4 JTF_NUMBER_TABLE
416: , a5 JTF_NUMBER_TABLE
417: , a6 JTF_NUMBER_TABLE
418: , a7 JTF_NUMBER_TABLE
419: , a8 JTF_NUMBER_TABLE
420: , a9 JTF_NUMBER_TABLE
421: , a10 JTF_VARCHAR2_TABLE_2000
422: , a11 JTF_NUMBER_TABLE
415: , a4 JTF_NUMBER_TABLE
416: , a5 JTF_NUMBER_TABLE
417: , a6 JTF_NUMBER_TABLE
418: , a7 JTF_NUMBER_TABLE
419: , a8 JTF_NUMBER_TABLE
420: , a9 JTF_NUMBER_TABLE
421: , a10 JTF_VARCHAR2_TABLE_2000
422: , a11 JTF_NUMBER_TABLE
423: , a12 JTF_VARCHAR2_TABLE_100
416: , a5 JTF_NUMBER_TABLE
417: , a6 JTF_NUMBER_TABLE
418: , a7 JTF_NUMBER_TABLE
419: , a8 JTF_NUMBER_TABLE
420: , a9 JTF_NUMBER_TABLE
421: , a10 JTF_VARCHAR2_TABLE_2000
422: , a11 JTF_NUMBER_TABLE
423: , a12 JTF_VARCHAR2_TABLE_100
424: , a13 JTF_VARCHAR2_TABLE_500
418: , a7 JTF_NUMBER_TABLE
419: , a8 JTF_NUMBER_TABLE
420: , a9 JTF_NUMBER_TABLE
421: , a10 JTF_VARCHAR2_TABLE_2000
422: , a11 JTF_NUMBER_TABLE
423: , a12 JTF_VARCHAR2_TABLE_100
424: , a13 JTF_VARCHAR2_TABLE_500
425: , a14 JTF_VARCHAR2_TABLE_500
426: , a15 JTF_VARCHAR2_TABLE_500
435: , a24 JTF_VARCHAR2_TABLE_500
436: , a25 JTF_VARCHAR2_TABLE_500
437: , a26 JTF_VARCHAR2_TABLE_500
438: , a27 JTF_VARCHAR2_TABLE_500
439: , a28 JTF_NUMBER_TABLE
440: , a29 JTF_NUMBER_TABLE
441: , a30 JTF_NUMBER_TABLE
442: , a31 JTF_DATE_TABLE
443: , a32 JTF_NUMBER_TABLE
436: , a25 JTF_VARCHAR2_TABLE_500
437: , a26 JTF_VARCHAR2_TABLE_500
438: , a27 JTF_VARCHAR2_TABLE_500
439: , a28 JTF_NUMBER_TABLE
440: , a29 JTF_NUMBER_TABLE
441: , a30 JTF_NUMBER_TABLE
442: , a31 JTF_DATE_TABLE
443: , a32 JTF_NUMBER_TABLE
444: , a33 JTF_NUMBER_TABLE
437: , a26 JTF_VARCHAR2_TABLE_500
438: , a27 JTF_VARCHAR2_TABLE_500
439: , a28 JTF_NUMBER_TABLE
440: , a29 JTF_NUMBER_TABLE
441: , a30 JTF_NUMBER_TABLE
442: , a31 JTF_DATE_TABLE
443: , a32 JTF_NUMBER_TABLE
444: , a33 JTF_NUMBER_TABLE
445: , a34 JTF_DATE_TABLE
439: , a28 JTF_NUMBER_TABLE
440: , a29 JTF_NUMBER_TABLE
441: , a30 JTF_NUMBER_TABLE
442: , a31 JTF_DATE_TABLE
443: , a32 JTF_NUMBER_TABLE
444: , a33 JTF_NUMBER_TABLE
445: , a34 JTF_DATE_TABLE
446: , a35 JTF_NUMBER_TABLE
447: , a36 JTF_DATE_TABLE
440: , a29 JTF_NUMBER_TABLE
441: , a30 JTF_NUMBER_TABLE
442: , a31 JTF_DATE_TABLE
443: , a32 JTF_NUMBER_TABLE
444: , a33 JTF_NUMBER_TABLE
445: , a34 JTF_DATE_TABLE
446: , a35 JTF_NUMBER_TABLE
447: , a36 JTF_DATE_TABLE
448: , a37 JTF_NUMBER_TABLE
442: , a31 JTF_DATE_TABLE
443: , a32 JTF_NUMBER_TABLE
444: , a33 JTF_NUMBER_TABLE
445: , a34 JTF_DATE_TABLE
446: , a35 JTF_NUMBER_TABLE
447: , a36 JTF_DATE_TABLE
448: , a37 JTF_NUMBER_TABLE
449: , a38 JTF_NUMBER_TABLE
450: , a39 JTF_NUMBER_TABLE
444: , a33 JTF_NUMBER_TABLE
445: , a34 JTF_DATE_TABLE
446: , a35 JTF_NUMBER_TABLE
447: , a36 JTF_DATE_TABLE
448: , a37 JTF_NUMBER_TABLE
449: , a38 JTF_NUMBER_TABLE
450: , a39 JTF_NUMBER_TABLE
451: ) as
452: ddindx binary_integer; indx binary_integer;
445: , a34 JTF_DATE_TABLE
446: , a35 JTF_NUMBER_TABLE
447: , a36 JTF_DATE_TABLE
448: , a37 JTF_NUMBER_TABLE
449: , a38 JTF_NUMBER_TABLE
450: , a39 JTF_NUMBER_TABLE
451: ) as
452: ddindx binary_integer; indx binary_integer;
453: begin
446: , a35 JTF_NUMBER_TABLE
447: , a36 JTF_DATE_TABLE
448: , a37 JTF_NUMBER_TABLE
449: , a38 JTF_NUMBER_TABLE
450: , a39 JTF_NUMBER_TABLE
451: ) as
452: ddindx binary_integer; indx binary_integer;
453: begin
454: if a0 is not null and a0.count > 0 then
504: end loop;
505: end if;
506: end if;
507: end rosetta_table_copy_in_p8;
508: procedure rosetta_table_copy_out_p8(t okl_rca_pvt.rcav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
509: , a1 out nocopy JTF_NUMBER_TABLE
510: , a2 out nocopy JTF_VARCHAR2_TABLE_100
511: , a3 out nocopy JTF_NUMBER_TABLE
512: , a4 out nocopy JTF_NUMBER_TABLE
505: end if;
506: end if;
507: end rosetta_table_copy_in_p8;
508: procedure rosetta_table_copy_out_p8(t okl_rca_pvt.rcav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
509: , a1 out nocopy JTF_NUMBER_TABLE
510: , a2 out nocopy JTF_VARCHAR2_TABLE_100
511: , a3 out nocopy JTF_NUMBER_TABLE
512: , a4 out nocopy JTF_NUMBER_TABLE
513: , a5 out nocopy JTF_NUMBER_TABLE
507: end rosetta_table_copy_in_p8;
508: procedure rosetta_table_copy_out_p8(t okl_rca_pvt.rcav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
509: , a1 out nocopy JTF_NUMBER_TABLE
510: , a2 out nocopy JTF_VARCHAR2_TABLE_100
511: , a3 out nocopy JTF_NUMBER_TABLE
512: , a4 out nocopy JTF_NUMBER_TABLE
513: , a5 out nocopy JTF_NUMBER_TABLE
514: , a6 out nocopy JTF_NUMBER_TABLE
515: , a7 out nocopy JTF_NUMBER_TABLE
508: procedure rosetta_table_copy_out_p8(t okl_rca_pvt.rcav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
509: , a1 out nocopy JTF_NUMBER_TABLE
510: , a2 out nocopy JTF_VARCHAR2_TABLE_100
511: , a3 out nocopy JTF_NUMBER_TABLE
512: , a4 out nocopy JTF_NUMBER_TABLE
513: , a5 out nocopy JTF_NUMBER_TABLE
514: , a6 out nocopy JTF_NUMBER_TABLE
515: , a7 out nocopy JTF_NUMBER_TABLE
516: , a8 out nocopy JTF_NUMBER_TABLE
509: , a1 out nocopy JTF_NUMBER_TABLE
510: , a2 out nocopy JTF_VARCHAR2_TABLE_100
511: , a3 out nocopy JTF_NUMBER_TABLE
512: , a4 out nocopy JTF_NUMBER_TABLE
513: , a5 out nocopy JTF_NUMBER_TABLE
514: , a6 out nocopy JTF_NUMBER_TABLE
515: , a7 out nocopy JTF_NUMBER_TABLE
516: , a8 out nocopy JTF_NUMBER_TABLE
517: , a9 out nocopy JTF_NUMBER_TABLE
510: , a2 out nocopy JTF_VARCHAR2_TABLE_100
511: , a3 out nocopy JTF_NUMBER_TABLE
512: , a4 out nocopy JTF_NUMBER_TABLE
513: , a5 out nocopy JTF_NUMBER_TABLE
514: , a6 out nocopy JTF_NUMBER_TABLE
515: , a7 out nocopy JTF_NUMBER_TABLE
516: , a8 out nocopy JTF_NUMBER_TABLE
517: , a9 out nocopy JTF_NUMBER_TABLE
518: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
511: , a3 out nocopy JTF_NUMBER_TABLE
512: , a4 out nocopy JTF_NUMBER_TABLE
513: , a5 out nocopy JTF_NUMBER_TABLE
514: , a6 out nocopy JTF_NUMBER_TABLE
515: , a7 out nocopy JTF_NUMBER_TABLE
516: , a8 out nocopy JTF_NUMBER_TABLE
517: , a9 out nocopy JTF_NUMBER_TABLE
518: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
519: , a11 out nocopy JTF_NUMBER_TABLE
512: , a4 out nocopy JTF_NUMBER_TABLE
513: , a5 out nocopy JTF_NUMBER_TABLE
514: , a6 out nocopy JTF_NUMBER_TABLE
515: , a7 out nocopy JTF_NUMBER_TABLE
516: , a8 out nocopy JTF_NUMBER_TABLE
517: , a9 out nocopy JTF_NUMBER_TABLE
518: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
519: , a11 out nocopy JTF_NUMBER_TABLE
520: , a12 out nocopy JTF_VARCHAR2_TABLE_100
513: , a5 out nocopy JTF_NUMBER_TABLE
514: , a6 out nocopy JTF_NUMBER_TABLE
515: , a7 out nocopy JTF_NUMBER_TABLE
516: , a8 out nocopy JTF_NUMBER_TABLE
517: , a9 out nocopy JTF_NUMBER_TABLE
518: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
519: , a11 out nocopy JTF_NUMBER_TABLE
520: , a12 out nocopy JTF_VARCHAR2_TABLE_100
521: , a13 out nocopy JTF_VARCHAR2_TABLE_500
515: , a7 out nocopy JTF_NUMBER_TABLE
516: , a8 out nocopy JTF_NUMBER_TABLE
517: , a9 out nocopy JTF_NUMBER_TABLE
518: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
519: , a11 out nocopy JTF_NUMBER_TABLE
520: , a12 out nocopy JTF_VARCHAR2_TABLE_100
521: , a13 out nocopy JTF_VARCHAR2_TABLE_500
522: , a14 out nocopy JTF_VARCHAR2_TABLE_500
523: , a15 out nocopy JTF_VARCHAR2_TABLE_500
532: , a24 out nocopy JTF_VARCHAR2_TABLE_500
533: , a25 out nocopy JTF_VARCHAR2_TABLE_500
534: , a26 out nocopy JTF_VARCHAR2_TABLE_500
535: , a27 out nocopy JTF_VARCHAR2_TABLE_500
536: , a28 out nocopy JTF_NUMBER_TABLE
537: , a29 out nocopy JTF_NUMBER_TABLE
538: , a30 out nocopy JTF_NUMBER_TABLE
539: , a31 out nocopy JTF_DATE_TABLE
540: , a32 out nocopy JTF_NUMBER_TABLE
533: , a25 out nocopy JTF_VARCHAR2_TABLE_500
534: , a26 out nocopy JTF_VARCHAR2_TABLE_500
535: , a27 out nocopy JTF_VARCHAR2_TABLE_500
536: , a28 out nocopy JTF_NUMBER_TABLE
537: , a29 out nocopy JTF_NUMBER_TABLE
538: , a30 out nocopy JTF_NUMBER_TABLE
539: , a31 out nocopy JTF_DATE_TABLE
540: , a32 out nocopy JTF_NUMBER_TABLE
541: , a33 out nocopy JTF_NUMBER_TABLE
534: , a26 out nocopy JTF_VARCHAR2_TABLE_500
535: , a27 out nocopy JTF_VARCHAR2_TABLE_500
536: , a28 out nocopy JTF_NUMBER_TABLE
537: , a29 out nocopy JTF_NUMBER_TABLE
538: , a30 out nocopy JTF_NUMBER_TABLE
539: , a31 out nocopy JTF_DATE_TABLE
540: , a32 out nocopy JTF_NUMBER_TABLE
541: , a33 out nocopy JTF_NUMBER_TABLE
542: , a34 out nocopy JTF_DATE_TABLE
536: , a28 out nocopy JTF_NUMBER_TABLE
537: , a29 out nocopy JTF_NUMBER_TABLE
538: , a30 out nocopy JTF_NUMBER_TABLE
539: , a31 out nocopy JTF_DATE_TABLE
540: , a32 out nocopy JTF_NUMBER_TABLE
541: , a33 out nocopy JTF_NUMBER_TABLE
542: , a34 out nocopy JTF_DATE_TABLE
543: , a35 out nocopy JTF_NUMBER_TABLE
544: , a36 out nocopy JTF_DATE_TABLE
537: , a29 out nocopy JTF_NUMBER_TABLE
538: , a30 out nocopy JTF_NUMBER_TABLE
539: , a31 out nocopy JTF_DATE_TABLE
540: , a32 out nocopy JTF_NUMBER_TABLE
541: , a33 out nocopy JTF_NUMBER_TABLE
542: , a34 out nocopy JTF_DATE_TABLE
543: , a35 out nocopy JTF_NUMBER_TABLE
544: , a36 out nocopy JTF_DATE_TABLE
545: , a37 out nocopy JTF_NUMBER_TABLE
539: , a31 out nocopy JTF_DATE_TABLE
540: , a32 out nocopy JTF_NUMBER_TABLE
541: , a33 out nocopy JTF_NUMBER_TABLE
542: , a34 out nocopy JTF_DATE_TABLE
543: , a35 out nocopy JTF_NUMBER_TABLE
544: , a36 out nocopy JTF_DATE_TABLE
545: , a37 out nocopy JTF_NUMBER_TABLE
546: , a38 out nocopy JTF_NUMBER_TABLE
547: , a39 out nocopy JTF_NUMBER_TABLE
541: , a33 out nocopy JTF_NUMBER_TABLE
542: , a34 out nocopy JTF_DATE_TABLE
543: , a35 out nocopy JTF_NUMBER_TABLE
544: , a36 out nocopy JTF_DATE_TABLE
545: , a37 out nocopy JTF_NUMBER_TABLE
546: , a38 out nocopy JTF_NUMBER_TABLE
547: , a39 out nocopy JTF_NUMBER_TABLE
548: ) as
549: ddindx binary_integer; indx binary_integer;
542: , a34 out nocopy JTF_DATE_TABLE
543: , a35 out nocopy JTF_NUMBER_TABLE
544: , a36 out nocopy JTF_DATE_TABLE
545: , a37 out nocopy JTF_NUMBER_TABLE
546: , a38 out nocopy JTF_NUMBER_TABLE
547: , a39 out nocopy JTF_NUMBER_TABLE
548: ) as
549: ddindx binary_integer; indx binary_integer;
550: begin
543: , a35 out nocopy JTF_NUMBER_TABLE
544: , a36 out nocopy JTF_DATE_TABLE
545: , a37 out nocopy JTF_NUMBER_TABLE
546: , a38 out nocopy JTF_NUMBER_TABLE
547: , a39 out nocopy JTF_NUMBER_TABLE
548: ) as
549: ddindx binary_integer; indx binary_integer;
550: begin
551: if t is null or t.count = 0 then
548: ) as
549: ddindx binary_integer; indx binary_integer;
550: begin
551: if t is null or t.count = 0 then
552: a0 := JTF_NUMBER_TABLE();
553: a1 := JTF_NUMBER_TABLE();
554: a2 := JTF_VARCHAR2_TABLE_100();
555: a3 := JTF_NUMBER_TABLE();
556: a4 := JTF_NUMBER_TABLE();
549: ddindx binary_integer; indx binary_integer;
550: begin
551: if t is null or t.count = 0 then
552: a0 := JTF_NUMBER_TABLE();
553: a1 := JTF_NUMBER_TABLE();
554: a2 := JTF_VARCHAR2_TABLE_100();
555: a3 := JTF_NUMBER_TABLE();
556: a4 := JTF_NUMBER_TABLE();
557: a5 := JTF_NUMBER_TABLE();
551: if t is null or t.count = 0 then
552: a0 := JTF_NUMBER_TABLE();
553: a1 := JTF_NUMBER_TABLE();
554: a2 := JTF_VARCHAR2_TABLE_100();
555: a3 := JTF_NUMBER_TABLE();
556: a4 := JTF_NUMBER_TABLE();
557: a5 := JTF_NUMBER_TABLE();
558: a6 := JTF_NUMBER_TABLE();
559: a7 := JTF_NUMBER_TABLE();
552: a0 := JTF_NUMBER_TABLE();
553: a1 := JTF_NUMBER_TABLE();
554: a2 := JTF_VARCHAR2_TABLE_100();
555: a3 := JTF_NUMBER_TABLE();
556: a4 := JTF_NUMBER_TABLE();
557: a5 := JTF_NUMBER_TABLE();
558: a6 := JTF_NUMBER_TABLE();
559: a7 := JTF_NUMBER_TABLE();
560: a8 := JTF_NUMBER_TABLE();
553: a1 := JTF_NUMBER_TABLE();
554: a2 := JTF_VARCHAR2_TABLE_100();
555: a3 := JTF_NUMBER_TABLE();
556: a4 := JTF_NUMBER_TABLE();
557: a5 := JTF_NUMBER_TABLE();
558: a6 := JTF_NUMBER_TABLE();
559: a7 := JTF_NUMBER_TABLE();
560: a8 := JTF_NUMBER_TABLE();
561: a9 := JTF_NUMBER_TABLE();
554: a2 := JTF_VARCHAR2_TABLE_100();
555: a3 := JTF_NUMBER_TABLE();
556: a4 := JTF_NUMBER_TABLE();
557: a5 := JTF_NUMBER_TABLE();
558: a6 := JTF_NUMBER_TABLE();
559: a7 := JTF_NUMBER_TABLE();
560: a8 := JTF_NUMBER_TABLE();
561: a9 := JTF_NUMBER_TABLE();
562: a10 := JTF_VARCHAR2_TABLE_2000();
555: a3 := JTF_NUMBER_TABLE();
556: a4 := JTF_NUMBER_TABLE();
557: a5 := JTF_NUMBER_TABLE();
558: a6 := JTF_NUMBER_TABLE();
559: a7 := JTF_NUMBER_TABLE();
560: a8 := JTF_NUMBER_TABLE();
561: a9 := JTF_NUMBER_TABLE();
562: a10 := JTF_VARCHAR2_TABLE_2000();
563: a11 := JTF_NUMBER_TABLE();
556: a4 := JTF_NUMBER_TABLE();
557: a5 := JTF_NUMBER_TABLE();
558: a6 := JTF_NUMBER_TABLE();
559: a7 := JTF_NUMBER_TABLE();
560: a8 := JTF_NUMBER_TABLE();
561: a9 := JTF_NUMBER_TABLE();
562: a10 := JTF_VARCHAR2_TABLE_2000();
563: a11 := JTF_NUMBER_TABLE();
564: a12 := JTF_VARCHAR2_TABLE_100();
557: a5 := JTF_NUMBER_TABLE();
558: a6 := JTF_NUMBER_TABLE();
559: a7 := JTF_NUMBER_TABLE();
560: a8 := JTF_NUMBER_TABLE();
561: a9 := JTF_NUMBER_TABLE();
562: a10 := JTF_VARCHAR2_TABLE_2000();
563: a11 := JTF_NUMBER_TABLE();
564: a12 := JTF_VARCHAR2_TABLE_100();
565: a13 := JTF_VARCHAR2_TABLE_500();
559: a7 := JTF_NUMBER_TABLE();
560: a8 := JTF_NUMBER_TABLE();
561: a9 := JTF_NUMBER_TABLE();
562: a10 := JTF_VARCHAR2_TABLE_2000();
563: a11 := JTF_NUMBER_TABLE();
564: a12 := JTF_VARCHAR2_TABLE_100();
565: a13 := JTF_VARCHAR2_TABLE_500();
566: a14 := JTF_VARCHAR2_TABLE_500();
567: a15 := JTF_VARCHAR2_TABLE_500();
576: a24 := JTF_VARCHAR2_TABLE_500();
577: a25 := JTF_VARCHAR2_TABLE_500();
578: a26 := JTF_VARCHAR2_TABLE_500();
579: a27 := JTF_VARCHAR2_TABLE_500();
580: a28 := JTF_NUMBER_TABLE();
581: a29 := JTF_NUMBER_TABLE();
582: a30 := JTF_NUMBER_TABLE();
583: a31 := JTF_DATE_TABLE();
584: a32 := JTF_NUMBER_TABLE();
577: a25 := JTF_VARCHAR2_TABLE_500();
578: a26 := JTF_VARCHAR2_TABLE_500();
579: a27 := JTF_VARCHAR2_TABLE_500();
580: a28 := JTF_NUMBER_TABLE();
581: a29 := JTF_NUMBER_TABLE();
582: a30 := JTF_NUMBER_TABLE();
583: a31 := JTF_DATE_TABLE();
584: a32 := JTF_NUMBER_TABLE();
585: a33 := JTF_NUMBER_TABLE();
578: a26 := JTF_VARCHAR2_TABLE_500();
579: a27 := JTF_VARCHAR2_TABLE_500();
580: a28 := JTF_NUMBER_TABLE();
581: a29 := JTF_NUMBER_TABLE();
582: a30 := JTF_NUMBER_TABLE();
583: a31 := JTF_DATE_TABLE();
584: a32 := JTF_NUMBER_TABLE();
585: a33 := JTF_NUMBER_TABLE();
586: a34 := JTF_DATE_TABLE();
580: a28 := JTF_NUMBER_TABLE();
581: a29 := JTF_NUMBER_TABLE();
582: a30 := JTF_NUMBER_TABLE();
583: a31 := JTF_DATE_TABLE();
584: a32 := JTF_NUMBER_TABLE();
585: a33 := JTF_NUMBER_TABLE();
586: a34 := JTF_DATE_TABLE();
587: a35 := JTF_NUMBER_TABLE();
588: a36 := JTF_DATE_TABLE();
581: a29 := JTF_NUMBER_TABLE();
582: a30 := JTF_NUMBER_TABLE();
583: a31 := JTF_DATE_TABLE();
584: a32 := JTF_NUMBER_TABLE();
585: a33 := JTF_NUMBER_TABLE();
586: a34 := JTF_DATE_TABLE();
587: a35 := JTF_NUMBER_TABLE();
588: a36 := JTF_DATE_TABLE();
589: a37 := JTF_NUMBER_TABLE();
583: a31 := JTF_DATE_TABLE();
584: a32 := JTF_NUMBER_TABLE();
585: a33 := JTF_NUMBER_TABLE();
586: a34 := JTF_DATE_TABLE();
587: a35 := JTF_NUMBER_TABLE();
588: a36 := JTF_DATE_TABLE();
589: a37 := JTF_NUMBER_TABLE();
590: a38 := JTF_NUMBER_TABLE();
591: a39 := JTF_NUMBER_TABLE();
585: a33 := JTF_NUMBER_TABLE();
586: a34 := JTF_DATE_TABLE();
587: a35 := JTF_NUMBER_TABLE();
588: a36 := JTF_DATE_TABLE();
589: a37 := JTF_NUMBER_TABLE();
590: a38 := JTF_NUMBER_TABLE();
591: a39 := JTF_NUMBER_TABLE();
592: else
593: a0 := JTF_NUMBER_TABLE();
586: a34 := JTF_DATE_TABLE();
587: a35 := JTF_NUMBER_TABLE();
588: a36 := JTF_DATE_TABLE();
589: a37 := JTF_NUMBER_TABLE();
590: a38 := JTF_NUMBER_TABLE();
591: a39 := JTF_NUMBER_TABLE();
592: else
593: a0 := JTF_NUMBER_TABLE();
594: a1 := JTF_NUMBER_TABLE();
587: a35 := JTF_NUMBER_TABLE();
588: a36 := JTF_DATE_TABLE();
589: a37 := JTF_NUMBER_TABLE();
590: a38 := JTF_NUMBER_TABLE();
591: a39 := JTF_NUMBER_TABLE();
592: else
593: a0 := JTF_NUMBER_TABLE();
594: a1 := JTF_NUMBER_TABLE();
595: a2 := JTF_VARCHAR2_TABLE_100();
589: a37 := JTF_NUMBER_TABLE();
590: a38 := JTF_NUMBER_TABLE();
591: a39 := JTF_NUMBER_TABLE();
592: else
593: a0 := JTF_NUMBER_TABLE();
594: a1 := JTF_NUMBER_TABLE();
595: a2 := JTF_VARCHAR2_TABLE_100();
596: a3 := JTF_NUMBER_TABLE();
597: a4 := JTF_NUMBER_TABLE();
590: a38 := JTF_NUMBER_TABLE();
591: a39 := JTF_NUMBER_TABLE();
592: else
593: a0 := JTF_NUMBER_TABLE();
594: a1 := JTF_NUMBER_TABLE();
595: a2 := JTF_VARCHAR2_TABLE_100();
596: a3 := JTF_NUMBER_TABLE();
597: a4 := JTF_NUMBER_TABLE();
598: a5 := JTF_NUMBER_TABLE();
592: else
593: a0 := JTF_NUMBER_TABLE();
594: a1 := JTF_NUMBER_TABLE();
595: a2 := JTF_VARCHAR2_TABLE_100();
596: a3 := JTF_NUMBER_TABLE();
597: a4 := JTF_NUMBER_TABLE();
598: a5 := JTF_NUMBER_TABLE();
599: a6 := JTF_NUMBER_TABLE();
600: a7 := JTF_NUMBER_TABLE();
593: a0 := JTF_NUMBER_TABLE();
594: a1 := JTF_NUMBER_TABLE();
595: a2 := JTF_VARCHAR2_TABLE_100();
596: a3 := JTF_NUMBER_TABLE();
597: a4 := JTF_NUMBER_TABLE();
598: a5 := JTF_NUMBER_TABLE();
599: a6 := JTF_NUMBER_TABLE();
600: a7 := JTF_NUMBER_TABLE();
601: a8 := JTF_NUMBER_TABLE();
594: a1 := JTF_NUMBER_TABLE();
595: a2 := JTF_VARCHAR2_TABLE_100();
596: a3 := JTF_NUMBER_TABLE();
597: a4 := JTF_NUMBER_TABLE();
598: a5 := JTF_NUMBER_TABLE();
599: a6 := JTF_NUMBER_TABLE();
600: a7 := JTF_NUMBER_TABLE();
601: a8 := JTF_NUMBER_TABLE();
602: a9 := JTF_NUMBER_TABLE();
595: a2 := JTF_VARCHAR2_TABLE_100();
596: a3 := JTF_NUMBER_TABLE();
597: a4 := JTF_NUMBER_TABLE();
598: a5 := JTF_NUMBER_TABLE();
599: a6 := JTF_NUMBER_TABLE();
600: a7 := JTF_NUMBER_TABLE();
601: a8 := JTF_NUMBER_TABLE();
602: a9 := JTF_NUMBER_TABLE();
603: a10 := JTF_VARCHAR2_TABLE_2000();
596: a3 := JTF_NUMBER_TABLE();
597: a4 := JTF_NUMBER_TABLE();
598: a5 := JTF_NUMBER_TABLE();
599: a6 := JTF_NUMBER_TABLE();
600: a7 := JTF_NUMBER_TABLE();
601: a8 := JTF_NUMBER_TABLE();
602: a9 := JTF_NUMBER_TABLE();
603: a10 := JTF_VARCHAR2_TABLE_2000();
604: a11 := JTF_NUMBER_TABLE();
597: a4 := JTF_NUMBER_TABLE();
598: a5 := JTF_NUMBER_TABLE();
599: a6 := JTF_NUMBER_TABLE();
600: a7 := JTF_NUMBER_TABLE();
601: a8 := JTF_NUMBER_TABLE();
602: a9 := JTF_NUMBER_TABLE();
603: a10 := JTF_VARCHAR2_TABLE_2000();
604: a11 := JTF_NUMBER_TABLE();
605: a12 := JTF_VARCHAR2_TABLE_100();
598: a5 := JTF_NUMBER_TABLE();
599: a6 := JTF_NUMBER_TABLE();
600: a7 := JTF_NUMBER_TABLE();
601: a8 := JTF_NUMBER_TABLE();
602: a9 := JTF_NUMBER_TABLE();
603: a10 := JTF_VARCHAR2_TABLE_2000();
604: a11 := JTF_NUMBER_TABLE();
605: a12 := JTF_VARCHAR2_TABLE_100();
606: a13 := JTF_VARCHAR2_TABLE_500();
600: a7 := JTF_NUMBER_TABLE();
601: a8 := JTF_NUMBER_TABLE();
602: a9 := JTF_NUMBER_TABLE();
603: a10 := JTF_VARCHAR2_TABLE_2000();
604: a11 := JTF_NUMBER_TABLE();
605: a12 := JTF_VARCHAR2_TABLE_100();
606: a13 := JTF_VARCHAR2_TABLE_500();
607: a14 := JTF_VARCHAR2_TABLE_500();
608: a15 := JTF_VARCHAR2_TABLE_500();
617: a24 := JTF_VARCHAR2_TABLE_500();
618: a25 := JTF_VARCHAR2_TABLE_500();
619: a26 := JTF_VARCHAR2_TABLE_500();
620: a27 := JTF_VARCHAR2_TABLE_500();
621: a28 := JTF_NUMBER_TABLE();
622: a29 := JTF_NUMBER_TABLE();
623: a30 := JTF_NUMBER_TABLE();
624: a31 := JTF_DATE_TABLE();
625: a32 := JTF_NUMBER_TABLE();
618: a25 := JTF_VARCHAR2_TABLE_500();
619: a26 := JTF_VARCHAR2_TABLE_500();
620: a27 := JTF_VARCHAR2_TABLE_500();
621: a28 := JTF_NUMBER_TABLE();
622: a29 := JTF_NUMBER_TABLE();
623: a30 := JTF_NUMBER_TABLE();
624: a31 := JTF_DATE_TABLE();
625: a32 := JTF_NUMBER_TABLE();
626: a33 := JTF_NUMBER_TABLE();
619: a26 := JTF_VARCHAR2_TABLE_500();
620: a27 := JTF_VARCHAR2_TABLE_500();
621: a28 := JTF_NUMBER_TABLE();
622: a29 := JTF_NUMBER_TABLE();
623: a30 := JTF_NUMBER_TABLE();
624: a31 := JTF_DATE_TABLE();
625: a32 := JTF_NUMBER_TABLE();
626: a33 := JTF_NUMBER_TABLE();
627: a34 := JTF_DATE_TABLE();
621: a28 := JTF_NUMBER_TABLE();
622: a29 := JTF_NUMBER_TABLE();
623: a30 := JTF_NUMBER_TABLE();
624: a31 := JTF_DATE_TABLE();
625: a32 := JTF_NUMBER_TABLE();
626: a33 := JTF_NUMBER_TABLE();
627: a34 := JTF_DATE_TABLE();
628: a35 := JTF_NUMBER_TABLE();
629: a36 := JTF_DATE_TABLE();
622: a29 := JTF_NUMBER_TABLE();
623: a30 := JTF_NUMBER_TABLE();
624: a31 := JTF_DATE_TABLE();
625: a32 := JTF_NUMBER_TABLE();
626: a33 := JTF_NUMBER_TABLE();
627: a34 := JTF_DATE_TABLE();
628: a35 := JTF_NUMBER_TABLE();
629: a36 := JTF_DATE_TABLE();
630: a37 := JTF_NUMBER_TABLE();
624: a31 := JTF_DATE_TABLE();
625: a32 := JTF_NUMBER_TABLE();
626: a33 := JTF_NUMBER_TABLE();
627: a34 := JTF_DATE_TABLE();
628: a35 := JTF_NUMBER_TABLE();
629: a36 := JTF_DATE_TABLE();
630: a37 := JTF_NUMBER_TABLE();
631: a38 := JTF_NUMBER_TABLE();
632: a39 := JTF_NUMBER_TABLE();
626: a33 := JTF_NUMBER_TABLE();
627: a34 := JTF_DATE_TABLE();
628: a35 := JTF_NUMBER_TABLE();
629: a36 := JTF_DATE_TABLE();
630: a37 := JTF_NUMBER_TABLE();
631: a38 := JTF_NUMBER_TABLE();
632: a39 := JTF_NUMBER_TABLE();
633: if t.count > 0 then
634: a0.extend(t.count);
627: a34 := JTF_DATE_TABLE();
628: a35 := JTF_NUMBER_TABLE();
629: a36 := JTF_DATE_TABLE();
630: a37 := JTF_NUMBER_TABLE();
631: a38 := JTF_NUMBER_TABLE();
632: a39 := JTF_NUMBER_TABLE();
633: if t.count > 0 then
634: a0.extend(t.count);
635: a1.extend(t.count);
628: a35 := JTF_NUMBER_TABLE();
629: a36 := JTF_DATE_TABLE();
630: a37 := JTF_NUMBER_TABLE();
631: a38 := JTF_NUMBER_TABLE();
632: a39 := JTF_NUMBER_TABLE();
633: if t.count > 0 then
634: a0.extend(t.count);
635: a1.extend(t.count);
636: a2.extend(t.count);
927: , p_init_msg_list VARCHAR2
928: , x_return_status out nocopy VARCHAR2
929: , x_msg_count out nocopy NUMBER
930: , x_msg_data out nocopy VARCHAR2
931: , p5_a0 JTF_NUMBER_TABLE
932: , p5_a1 JTF_NUMBER_TABLE
933: , p5_a2 JTF_VARCHAR2_TABLE_100
934: , p5_a3 JTF_NUMBER_TABLE
935: , p5_a4 JTF_NUMBER_TABLE
928: , x_return_status out nocopy VARCHAR2
929: , x_msg_count out nocopy NUMBER
930: , x_msg_data out nocopy VARCHAR2
931: , p5_a0 JTF_NUMBER_TABLE
932: , p5_a1 JTF_NUMBER_TABLE
933: , p5_a2 JTF_VARCHAR2_TABLE_100
934: , p5_a3 JTF_NUMBER_TABLE
935: , p5_a4 JTF_NUMBER_TABLE
936: , p5_a5 JTF_NUMBER_TABLE
930: , x_msg_data out nocopy VARCHAR2
931: , p5_a0 JTF_NUMBER_TABLE
932: , p5_a1 JTF_NUMBER_TABLE
933: , p5_a2 JTF_VARCHAR2_TABLE_100
934: , p5_a3 JTF_NUMBER_TABLE
935: , p5_a4 JTF_NUMBER_TABLE
936: , p5_a5 JTF_NUMBER_TABLE
937: , p5_a6 JTF_NUMBER_TABLE
938: , p5_a7 JTF_NUMBER_TABLE
931: , p5_a0 JTF_NUMBER_TABLE
932: , p5_a1 JTF_NUMBER_TABLE
933: , p5_a2 JTF_VARCHAR2_TABLE_100
934: , p5_a3 JTF_NUMBER_TABLE
935: , p5_a4 JTF_NUMBER_TABLE
936: , p5_a5 JTF_NUMBER_TABLE
937: , p5_a6 JTF_NUMBER_TABLE
938: , p5_a7 JTF_NUMBER_TABLE
939: , p5_a8 JTF_NUMBER_TABLE
932: , p5_a1 JTF_NUMBER_TABLE
933: , p5_a2 JTF_VARCHAR2_TABLE_100
934: , p5_a3 JTF_NUMBER_TABLE
935: , p5_a4 JTF_NUMBER_TABLE
936: , p5_a5 JTF_NUMBER_TABLE
937: , p5_a6 JTF_NUMBER_TABLE
938: , p5_a7 JTF_NUMBER_TABLE
939: , p5_a8 JTF_NUMBER_TABLE
940: , p5_a9 JTF_NUMBER_TABLE
933: , p5_a2 JTF_VARCHAR2_TABLE_100
934: , p5_a3 JTF_NUMBER_TABLE
935: , p5_a4 JTF_NUMBER_TABLE
936: , p5_a5 JTF_NUMBER_TABLE
937: , p5_a6 JTF_NUMBER_TABLE
938: , p5_a7 JTF_NUMBER_TABLE
939: , p5_a8 JTF_NUMBER_TABLE
940: , p5_a9 JTF_NUMBER_TABLE
941: , p5_a10 JTF_VARCHAR2_TABLE_2000
934: , p5_a3 JTF_NUMBER_TABLE
935: , p5_a4 JTF_NUMBER_TABLE
936: , p5_a5 JTF_NUMBER_TABLE
937: , p5_a6 JTF_NUMBER_TABLE
938: , p5_a7 JTF_NUMBER_TABLE
939: , p5_a8 JTF_NUMBER_TABLE
940: , p5_a9 JTF_NUMBER_TABLE
941: , p5_a10 JTF_VARCHAR2_TABLE_2000
942: , p5_a11 JTF_NUMBER_TABLE
935: , p5_a4 JTF_NUMBER_TABLE
936: , p5_a5 JTF_NUMBER_TABLE
937: , p5_a6 JTF_NUMBER_TABLE
938: , p5_a7 JTF_NUMBER_TABLE
939: , p5_a8 JTF_NUMBER_TABLE
940: , p5_a9 JTF_NUMBER_TABLE
941: , p5_a10 JTF_VARCHAR2_TABLE_2000
942: , p5_a11 JTF_NUMBER_TABLE
943: , p5_a12 JTF_VARCHAR2_TABLE_100
936: , p5_a5 JTF_NUMBER_TABLE
937: , p5_a6 JTF_NUMBER_TABLE
938: , p5_a7 JTF_NUMBER_TABLE
939: , p5_a8 JTF_NUMBER_TABLE
940: , p5_a9 JTF_NUMBER_TABLE
941: , p5_a10 JTF_VARCHAR2_TABLE_2000
942: , p5_a11 JTF_NUMBER_TABLE
943: , p5_a12 JTF_VARCHAR2_TABLE_100
944: , p5_a13 JTF_VARCHAR2_TABLE_500
938: , p5_a7 JTF_NUMBER_TABLE
939: , p5_a8 JTF_NUMBER_TABLE
940: , p5_a9 JTF_NUMBER_TABLE
941: , p5_a10 JTF_VARCHAR2_TABLE_2000
942: , p5_a11 JTF_NUMBER_TABLE
943: , p5_a12 JTF_VARCHAR2_TABLE_100
944: , p5_a13 JTF_VARCHAR2_TABLE_500
945: , p5_a14 JTF_VARCHAR2_TABLE_500
946: , p5_a15 JTF_VARCHAR2_TABLE_500
955: , p5_a24 JTF_VARCHAR2_TABLE_500
956: , p5_a25 JTF_VARCHAR2_TABLE_500
957: , p5_a26 JTF_VARCHAR2_TABLE_500
958: , p5_a27 JTF_VARCHAR2_TABLE_500
959: , p5_a28 JTF_NUMBER_TABLE
960: , p5_a29 JTF_NUMBER_TABLE
961: , p5_a30 JTF_NUMBER_TABLE
962: , p5_a31 JTF_DATE_TABLE
963: , p5_a32 JTF_NUMBER_TABLE
956: , p5_a25 JTF_VARCHAR2_TABLE_500
957: , p5_a26 JTF_VARCHAR2_TABLE_500
958: , p5_a27 JTF_VARCHAR2_TABLE_500
959: , p5_a28 JTF_NUMBER_TABLE
960: , p5_a29 JTF_NUMBER_TABLE
961: , p5_a30 JTF_NUMBER_TABLE
962: , p5_a31 JTF_DATE_TABLE
963: , p5_a32 JTF_NUMBER_TABLE
964: , p5_a33 JTF_NUMBER_TABLE
957: , p5_a26 JTF_VARCHAR2_TABLE_500
958: , p5_a27 JTF_VARCHAR2_TABLE_500
959: , p5_a28 JTF_NUMBER_TABLE
960: , p5_a29 JTF_NUMBER_TABLE
961: , p5_a30 JTF_NUMBER_TABLE
962: , p5_a31 JTF_DATE_TABLE
963: , p5_a32 JTF_NUMBER_TABLE
964: , p5_a33 JTF_NUMBER_TABLE
965: , p5_a34 JTF_DATE_TABLE
959: , p5_a28 JTF_NUMBER_TABLE
960: , p5_a29 JTF_NUMBER_TABLE
961: , p5_a30 JTF_NUMBER_TABLE
962: , p5_a31 JTF_DATE_TABLE
963: , p5_a32 JTF_NUMBER_TABLE
964: , p5_a33 JTF_NUMBER_TABLE
965: , p5_a34 JTF_DATE_TABLE
966: , p5_a35 JTF_NUMBER_TABLE
967: , p5_a36 JTF_DATE_TABLE
960: , p5_a29 JTF_NUMBER_TABLE
961: , p5_a30 JTF_NUMBER_TABLE
962: , p5_a31 JTF_DATE_TABLE
963: , p5_a32 JTF_NUMBER_TABLE
964: , p5_a33 JTF_NUMBER_TABLE
965: , p5_a34 JTF_DATE_TABLE
966: , p5_a35 JTF_NUMBER_TABLE
967: , p5_a36 JTF_DATE_TABLE
968: , p5_a37 JTF_NUMBER_TABLE
962: , p5_a31 JTF_DATE_TABLE
963: , p5_a32 JTF_NUMBER_TABLE
964: , p5_a33 JTF_NUMBER_TABLE
965: , p5_a34 JTF_DATE_TABLE
966: , p5_a35 JTF_NUMBER_TABLE
967: , p5_a36 JTF_DATE_TABLE
968: , p5_a37 JTF_NUMBER_TABLE
969: , p5_a38 JTF_NUMBER_TABLE
970: , p5_a39 JTF_NUMBER_TABLE
964: , p5_a33 JTF_NUMBER_TABLE
965: , p5_a34 JTF_DATE_TABLE
966: , p5_a35 JTF_NUMBER_TABLE
967: , p5_a36 JTF_DATE_TABLE
968: , p5_a37 JTF_NUMBER_TABLE
969: , p5_a38 JTF_NUMBER_TABLE
970: , p5_a39 JTF_NUMBER_TABLE
971: , p6_a0 out nocopy JTF_NUMBER_TABLE
972: , p6_a1 out nocopy JTF_NUMBER_TABLE
965: , p5_a34 JTF_DATE_TABLE
966: , p5_a35 JTF_NUMBER_TABLE
967: , p5_a36 JTF_DATE_TABLE
968: , p5_a37 JTF_NUMBER_TABLE
969: , p5_a38 JTF_NUMBER_TABLE
970: , p5_a39 JTF_NUMBER_TABLE
971: , p6_a0 out nocopy JTF_NUMBER_TABLE
972: , p6_a1 out nocopy JTF_NUMBER_TABLE
973: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
966: , p5_a35 JTF_NUMBER_TABLE
967: , p5_a36 JTF_DATE_TABLE
968: , p5_a37 JTF_NUMBER_TABLE
969: , p5_a38 JTF_NUMBER_TABLE
970: , p5_a39 JTF_NUMBER_TABLE
971: , p6_a0 out nocopy JTF_NUMBER_TABLE
972: , p6_a1 out nocopy JTF_NUMBER_TABLE
973: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
974: , p6_a3 out nocopy JTF_NUMBER_TABLE
967: , p5_a36 JTF_DATE_TABLE
968: , p5_a37 JTF_NUMBER_TABLE
969: , p5_a38 JTF_NUMBER_TABLE
970: , p5_a39 JTF_NUMBER_TABLE
971: , p6_a0 out nocopy JTF_NUMBER_TABLE
972: , p6_a1 out nocopy JTF_NUMBER_TABLE
973: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
974: , p6_a3 out nocopy JTF_NUMBER_TABLE
975: , p6_a4 out nocopy JTF_NUMBER_TABLE
968: , p5_a37 JTF_NUMBER_TABLE
969: , p5_a38 JTF_NUMBER_TABLE
970: , p5_a39 JTF_NUMBER_TABLE
971: , p6_a0 out nocopy JTF_NUMBER_TABLE
972: , p6_a1 out nocopy JTF_NUMBER_TABLE
973: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
974: , p6_a3 out nocopy JTF_NUMBER_TABLE
975: , p6_a4 out nocopy JTF_NUMBER_TABLE
976: , p6_a5 out nocopy JTF_NUMBER_TABLE
970: , p5_a39 JTF_NUMBER_TABLE
971: , p6_a0 out nocopy JTF_NUMBER_TABLE
972: , p6_a1 out nocopy JTF_NUMBER_TABLE
973: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
974: , p6_a3 out nocopy JTF_NUMBER_TABLE
975: , p6_a4 out nocopy JTF_NUMBER_TABLE
976: , p6_a5 out nocopy JTF_NUMBER_TABLE
977: , p6_a6 out nocopy JTF_NUMBER_TABLE
978: , p6_a7 out nocopy JTF_NUMBER_TABLE
971: , p6_a0 out nocopy JTF_NUMBER_TABLE
972: , p6_a1 out nocopy JTF_NUMBER_TABLE
973: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
974: , p6_a3 out nocopy JTF_NUMBER_TABLE
975: , p6_a4 out nocopy JTF_NUMBER_TABLE
976: , p6_a5 out nocopy JTF_NUMBER_TABLE
977: , p6_a6 out nocopy JTF_NUMBER_TABLE
978: , p6_a7 out nocopy JTF_NUMBER_TABLE
979: , p6_a8 out nocopy JTF_NUMBER_TABLE
972: , p6_a1 out nocopy JTF_NUMBER_TABLE
973: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
974: , p6_a3 out nocopy JTF_NUMBER_TABLE
975: , p6_a4 out nocopy JTF_NUMBER_TABLE
976: , p6_a5 out nocopy JTF_NUMBER_TABLE
977: , p6_a6 out nocopy JTF_NUMBER_TABLE
978: , p6_a7 out nocopy JTF_NUMBER_TABLE
979: , p6_a8 out nocopy JTF_NUMBER_TABLE
980: , p6_a9 out nocopy JTF_NUMBER_TABLE
973: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
974: , p6_a3 out nocopy JTF_NUMBER_TABLE
975: , p6_a4 out nocopy JTF_NUMBER_TABLE
976: , p6_a5 out nocopy JTF_NUMBER_TABLE
977: , p6_a6 out nocopy JTF_NUMBER_TABLE
978: , p6_a7 out nocopy JTF_NUMBER_TABLE
979: , p6_a8 out nocopy JTF_NUMBER_TABLE
980: , p6_a9 out nocopy JTF_NUMBER_TABLE
981: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
974: , p6_a3 out nocopy JTF_NUMBER_TABLE
975: , p6_a4 out nocopy JTF_NUMBER_TABLE
976: , p6_a5 out nocopy JTF_NUMBER_TABLE
977: , p6_a6 out nocopy JTF_NUMBER_TABLE
978: , p6_a7 out nocopy JTF_NUMBER_TABLE
979: , p6_a8 out nocopy JTF_NUMBER_TABLE
980: , p6_a9 out nocopy JTF_NUMBER_TABLE
981: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
982: , p6_a11 out nocopy JTF_NUMBER_TABLE
975: , p6_a4 out nocopy JTF_NUMBER_TABLE
976: , p6_a5 out nocopy JTF_NUMBER_TABLE
977: , p6_a6 out nocopy JTF_NUMBER_TABLE
978: , p6_a7 out nocopy JTF_NUMBER_TABLE
979: , p6_a8 out nocopy JTF_NUMBER_TABLE
980: , p6_a9 out nocopy JTF_NUMBER_TABLE
981: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
982: , p6_a11 out nocopy JTF_NUMBER_TABLE
983: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
976: , p6_a5 out nocopy JTF_NUMBER_TABLE
977: , p6_a6 out nocopy JTF_NUMBER_TABLE
978: , p6_a7 out nocopy JTF_NUMBER_TABLE
979: , p6_a8 out nocopy JTF_NUMBER_TABLE
980: , p6_a9 out nocopy JTF_NUMBER_TABLE
981: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
982: , p6_a11 out nocopy JTF_NUMBER_TABLE
983: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
984: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
978: , p6_a7 out nocopy JTF_NUMBER_TABLE
979: , p6_a8 out nocopy JTF_NUMBER_TABLE
980: , p6_a9 out nocopy JTF_NUMBER_TABLE
981: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
982: , p6_a11 out nocopy JTF_NUMBER_TABLE
983: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
984: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
985: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
986: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
995: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
996: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
997: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
998: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
999: , p6_a28 out nocopy JTF_NUMBER_TABLE
1000: , p6_a29 out nocopy JTF_NUMBER_TABLE
1001: , p6_a30 out nocopy JTF_NUMBER_TABLE
1002: , p6_a31 out nocopy JTF_DATE_TABLE
1003: , p6_a32 out nocopy JTF_NUMBER_TABLE
996: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
997: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
998: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
999: , p6_a28 out nocopy JTF_NUMBER_TABLE
1000: , p6_a29 out nocopy JTF_NUMBER_TABLE
1001: , p6_a30 out nocopy JTF_NUMBER_TABLE
1002: , p6_a31 out nocopy JTF_DATE_TABLE
1003: , p6_a32 out nocopy JTF_NUMBER_TABLE
1004: , p6_a33 out nocopy JTF_NUMBER_TABLE
997: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
998: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
999: , p6_a28 out nocopy JTF_NUMBER_TABLE
1000: , p6_a29 out nocopy JTF_NUMBER_TABLE
1001: , p6_a30 out nocopy JTF_NUMBER_TABLE
1002: , p6_a31 out nocopy JTF_DATE_TABLE
1003: , p6_a32 out nocopy JTF_NUMBER_TABLE
1004: , p6_a33 out nocopy JTF_NUMBER_TABLE
1005: , p6_a34 out nocopy JTF_DATE_TABLE
999: , p6_a28 out nocopy JTF_NUMBER_TABLE
1000: , p6_a29 out nocopy JTF_NUMBER_TABLE
1001: , p6_a30 out nocopy JTF_NUMBER_TABLE
1002: , p6_a31 out nocopy JTF_DATE_TABLE
1003: , p6_a32 out nocopy JTF_NUMBER_TABLE
1004: , p6_a33 out nocopy JTF_NUMBER_TABLE
1005: , p6_a34 out nocopy JTF_DATE_TABLE
1006: , p6_a35 out nocopy JTF_NUMBER_TABLE
1007: , p6_a36 out nocopy JTF_DATE_TABLE
1000: , p6_a29 out nocopy JTF_NUMBER_TABLE
1001: , p6_a30 out nocopy JTF_NUMBER_TABLE
1002: , p6_a31 out nocopy JTF_DATE_TABLE
1003: , p6_a32 out nocopy JTF_NUMBER_TABLE
1004: , p6_a33 out nocopy JTF_NUMBER_TABLE
1005: , p6_a34 out nocopy JTF_DATE_TABLE
1006: , p6_a35 out nocopy JTF_NUMBER_TABLE
1007: , p6_a36 out nocopy JTF_DATE_TABLE
1008: , p6_a37 out nocopy JTF_NUMBER_TABLE
1002: , p6_a31 out nocopy JTF_DATE_TABLE
1003: , p6_a32 out nocopy JTF_NUMBER_TABLE
1004: , p6_a33 out nocopy JTF_NUMBER_TABLE
1005: , p6_a34 out nocopy JTF_DATE_TABLE
1006: , p6_a35 out nocopy JTF_NUMBER_TABLE
1007: , p6_a36 out nocopy JTF_DATE_TABLE
1008: , p6_a37 out nocopy JTF_NUMBER_TABLE
1009: , p6_a38 out nocopy JTF_NUMBER_TABLE
1010: , p6_a39 out nocopy JTF_NUMBER_TABLE
1004: , p6_a33 out nocopy JTF_NUMBER_TABLE
1005: , p6_a34 out nocopy JTF_DATE_TABLE
1006: , p6_a35 out nocopy JTF_NUMBER_TABLE
1007: , p6_a36 out nocopy JTF_DATE_TABLE
1008: , p6_a37 out nocopy JTF_NUMBER_TABLE
1009: , p6_a38 out nocopy JTF_NUMBER_TABLE
1010: , p6_a39 out nocopy JTF_NUMBER_TABLE
1011: )
1012:
1005: , p6_a34 out nocopy JTF_DATE_TABLE
1006: , p6_a35 out nocopy JTF_NUMBER_TABLE
1007: , p6_a36 out nocopy JTF_DATE_TABLE
1008: , p6_a37 out nocopy JTF_NUMBER_TABLE
1009: , p6_a38 out nocopy JTF_NUMBER_TABLE
1010: , p6_a39 out nocopy JTF_NUMBER_TABLE
1011: )
1012:
1013: as
1006: , p6_a35 out nocopy JTF_NUMBER_TABLE
1007: , p6_a36 out nocopy JTF_DATE_TABLE
1008: , p6_a37 out nocopy JTF_NUMBER_TABLE
1009: , p6_a38 out nocopy JTF_NUMBER_TABLE
1010: , p6_a39 out nocopy JTF_NUMBER_TABLE
1011: )
1012:
1013: as
1014: ddp_rcav_tbl okl_rca_pvt.rcav_tbl_type;
1243: , p_init_msg_list VARCHAR2
1244: , x_return_status out nocopy VARCHAR2
1245: , x_msg_count out nocopy NUMBER
1246: , x_msg_data out nocopy VARCHAR2
1247: , p5_a0 JTF_NUMBER_TABLE
1248: , p5_a1 JTF_NUMBER_TABLE
1249: , p5_a2 JTF_VARCHAR2_TABLE_100
1250: , p5_a3 JTF_NUMBER_TABLE
1251: , p5_a4 JTF_NUMBER_TABLE
1244: , x_return_status out nocopy VARCHAR2
1245: , x_msg_count out nocopy NUMBER
1246: , x_msg_data out nocopy VARCHAR2
1247: , p5_a0 JTF_NUMBER_TABLE
1248: , p5_a1 JTF_NUMBER_TABLE
1249: , p5_a2 JTF_VARCHAR2_TABLE_100
1250: , p5_a3 JTF_NUMBER_TABLE
1251: , p5_a4 JTF_NUMBER_TABLE
1252: , p5_a5 JTF_NUMBER_TABLE
1246: , x_msg_data out nocopy VARCHAR2
1247: , p5_a0 JTF_NUMBER_TABLE
1248: , p5_a1 JTF_NUMBER_TABLE
1249: , p5_a2 JTF_VARCHAR2_TABLE_100
1250: , p5_a3 JTF_NUMBER_TABLE
1251: , p5_a4 JTF_NUMBER_TABLE
1252: , p5_a5 JTF_NUMBER_TABLE
1253: , p5_a6 JTF_NUMBER_TABLE
1254: , p5_a7 JTF_NUMBER_TABLE
1247: , p5_a0 JTF_NUMBER_TABLE
1248: , p5_a1 JTF_NUMBER_TABLE
1249: , p5_a2 JTF_VARCHAR2_TABLE_100
1250: , p5_a3 JTF_NUMBER_TABLE
1251: , p5_a4 JTF_NUMBER_TABLE
1252: , p5_a5 JTF_NUMBER_TABLE
1253: , p5_a6 JTF_NUMBER_TABLE
1254: , p5_a7 JTF_NUMBER_TABLE
1255: , p5_a8 JTF_NUMBER_TABLE
1248: , p5_a1 JTF_NUMBER_TABLE
1249: , p5_a2 JTF_VARCHAR2_TABLE_100
1250: , p5_a3 JTF_NUMBER_TABLE
1251: , p5_a4 JTF_NUMBER_TABLE
1252: , p5_a5 JTF_NUMBER_TABLE
1253: , p5_a6 JTF_NUMBER_TABLE
1254: , p5_a7 JTF_NUMBER_TABLE
1255: , p5_a8 JTF_NUMBER_TABLE
1256: , p5_a9 JTF_NUMBER_TABLE
1249: , p5_a2 JTF_VARCHAR2_TABLE_100
1250: , p5_a3 JTF_NUMBER_TABLE
1251: , p5_a4 JTF_NUMBER_TABLE
1252: , p5_a5 JTF_NUMBER_TABLE
1253: , p5_a6 JTF_NUMBER_TABLE
1254: , p5_a7 JTF_NUMBER_TABLE
1255: , p5_a8 JTF_NUMBER_TABLE
1256: , p5_a9 JTF_NUMBER_TABLE
1257: , p5_a10 JTF_VARCHAR2_TABLE_2000
1250: , p5_a3 JTF_NUMBER_TABLE
1251: , p5_a4 JTF_NUMBER_TABLE
1252: , p5_a5 JTF_NUMBER_TABLE
1253: , p5_a6 JTF_NUMBER_TABLE
1254: , p5_a7 JTF_NUMBER_TABLE
1255: , p5_a8 JTF_NUMBER_TABLE
1256: , p5_a9 JTF_NUMBER_TABLE
1257: , p5_a10 JTF_VARCHAR2_TABLE_2000
1258: , p5_a11 JTF_NUMBER_TABLE
1251: , p5_a4 JTF_NUMBER_TABLE
1252: , p5_a5 JTF_NUMBER_TABLE
1253: , p5_a6 JTF_NUMBER_TABLE
1254: , p5_a7 JTF_NUMBER_TABLE
1255: , p5_a8 JTF_NUMBER_TABLE
1256: , p5_a9 JTF_NUMBER_TABLE
1257: , p5_a10 JTF_VARCHAR2_TABLE_2000
1258: , p5_a11 JTF_NUMBER_TABLE
1259: , p5_a12 JTF_VARCHAR2_TABLE_100
1252: , p5_a5 JTF_NUMBER_TABLE
1253: , p5_a6 JTF_NUMBER_TABLE
1254: , p5_a7 JTF_NUMBER_TABLE
1255: , p5_a8 JTF_NUMBER_TABLE
1256: , p5_a9 JTF_NUMBER_TABLE
1257: , p5_a10 JTF_VARCHAR2_TABLE_2000
1258: , p5_a11 JTF_NUMBER_TABLE
1259: , p5_a12 JTF_VARCHAR2_TABLE_100
1260: , p5_a13 JTF_VARCHAR2_TABLE_500
1254: , p5_a7 JTF_NUMBER_TABLE
1255: , p5_a8 JTF_NUMBER_TABLE
1256: , p5_a9 JTF_NUMBER_TABLE
1257: , p5_a10 JTF_VARCHAR2_TABLE_2000
1258: , p5_a11 JTF_NUMBER_TABLE
1259: , p5_a12 JTF_VARCHAR2_TABLE_100
1260: , p5_a13 JTF_VARCHAR2_TABLE_500
1261: , p5_a14 JTF_VARCHAR2_TABLE_500
1262: , p5_a15 JTF_VARCHAR2_TABLE_500
1271: , p5_a24 JTF_VARCHAR2_TABLE_500
1272: , p5_a25 JTF_VARCHAR2_TABLE_500
1273: , p5_a26 JTF_VARCHAR2_TABLE_500
1274: , p5_a27 JTF_VARCHAR2_TABLE_500
1275: , p5_a28 JTF_NUMBER_TABLE
1276: , p5_a29 JTF_NUMBER_TABLE
1277: , p5_a30 JTF_NUMBER_TABLE
1278: , p5_a31 JTF_DATE_TABLE
1279: , p5_a32 JTF_NUMBER_TABLE
1272: , p5_a25 JTF_VARCHAR2_TABLE_500
1273: , p5_a26 JTF_VARCHAR2_TABLE_500
1274: , p5_a27 JTF_VARCHAR2_TABLE_500
1275: , p5_a28 JTF_NUMBER_TABLE
1276: , p5_a29 JTF_NUMBER_TABLE
1277: , p5_a30 JTF_NUMBER_TABLE
1278: , p5_a31 JTF_DATE_TABLE
1279: , p5_a32 JTF_NUMBER_TABLE
1280: , p5_a33 JTF_NUMBER_TABLE
1273: , p5_a26 JTF_VARCHAR2_TABLE_500
1274: , p5_a27 JTF_VARCHAR2_TABLE_500
1275: , p5_a28 JTF_NUMBER_TABLE
1276: , p5_a29 JTF_NUMBER_TABLE
1277: , p5_a30 JTF_NUMBER_TABLE
1278: , p5_a31 JTF_DATE_TABLE
1279: , p5_a32 JTF_NUMBER_TABLE
1280: , p5_a33 JTF_NUMBER_TABLE
1281: , p5_a34 JTF_DATE_TABLE
1275: , p5_a28 JTF_NUMBER_TABLE
1276: , p5_a29 JTF_NUMBER_TABLE
1277: , p5_a30 JTF_NUMBER_TABLE
1278: , p5_a31 JTF_DATE_TABLE
1279: , p5_a32 JTF_NUMBER_TABLE
1280: , p5_a33 JTF_NUMBER_TABLE
1281: , p5_a34 JTF_DATE_TABLE
1282: , p5_a35 JTF_NUMBER_TABLE
1283: , p5_a36 JTF_DATE_TABLE
1276: , p5_a29 JTF_NUMBER_TABLE
1277: , p5_a30 JTF_NUMBER_TABLE
1278: , p5_a31 JTF_DATE_TABLE
1279: , p5_a32 JTF_NUMBER_TABLE
1280: , p5_a33 JTF_NUMBER_TABLE
1281: , p5_a34 JTF_DATE_TABLE
1282: , p5_a35 JTF_NUMBER_TABLE
1283: , p5_a36 JTF_DATE_TABLE
1284: , p5_a37 JTF_NUMBER_TABLE
1278: , p5_a31 JTF_DATE_TABLE
1279: , p5_a32 JTF_NUMBER_TABLE
1280: , p5_a33 JTF_NUMBER_TABLE
1281: , p5_a34 JTF_DATE_TABLE
1282: , p5_a35 JTF_NUMBER_TABLE
1283: , p5_a36 JTF_DATE_TABLE
1284: , p5_a37 JTF_NUMBER_TABLE
1285: , p5_a38 JTF_NUMBER_TABLE
1286: , p5_a39 JTF_NUMBER_TABLE
1280: , p5_a33 JTF_NUMBER_TABLE
1281: , p5_a34 JTF_DATE_TABLE
1282: , p5_a35 JTF_NUMBER_TABLE
1283: , p5_a36 JTF_DATE_TABLE
1284: , p5_a37 JTF_NUMBER_TABLE
1285: , p5_a38 JTF_NUMBER_TABLE
1286: , p5_a39 JTF_NUMBER_TABLE
1287: )
1288:
1281: , p5_a34 JTF_DATE_TABLE
1282: , p5_a35 JTF_NUMBER_TABLE
1283: , p5_a36 JTF_DATE_TABLE
1284: , p5_a37 JTF_NUMBER_TABLE
1285: , p5_a38 JTF_NUMBER_TABLE
1286: , p5_a39 JTF_NUMBER_TABLE
1287: )
1288:
1289: as
1282: , p5_a35 JTF_NUMBER_TABLE
1283: , p5_a36 JTF_DATE_TABLE
1284: , p5_a37 JTF_NUMBER_TABLE
1285: , p5_a38 JTF_NUMBER_TABLE
1286: , p5_a39 JTF_NUMBER_TABLE
1287: )
1288:
1289: as
1290: ddp_rcav_tbl okl_rca_pvt.rcav_tbl_type;
1558: , p_init_msg_list VARCHAR2
1559: , x_return_status out nocopy VARCHAR2
1560: , x_msg_count out nocopy NUMBER
1561: , x_msg_data out nocopy VARCHAR2
1562: , p5_a0 JTF_NUMBER_TABLE
1563: , p5_a1 JTF_NUMBER_TABLE
1564: , p5_a2 JTF_VARCHAR2_TABLE_100
1565: , p5_a3 JTF_NUMBER_TABLE
1566: , p5_a4 JTF_NUMBER_TABLE
1559: , x_return_status out nocopy VARCHAR2
1560: , x_msg_count out nocopy NUMBER
1561: , x_msg_data out nocopy VARCHAR2
1562: , p5_a0 JTF_NUMBER_TABLE
1563: , p5_a1 JTF_NUMBER_TABLE
1564: , p5_a2 JTF_VARCHAR2_TABLE_100
1565: , p5_a3 JTF_NUMBER_TABLE
1566: , p5_a4 JTF_NUMBER_TABLE
1567: , p5_a5 JTF_NUMBER_TABLE
1561: , x_msg_data out nocopy VARCHAR2
1562: , p5_a0 JTF_NUMBER_TABLE
1563: , p5_a1 JTF_NUMBER_TABLE
1564: , p5_a2 JTF_VARCHAR2_TABLE_100
1565: , p5_a3 JTF_NUMBER_TABLE
1566: , p5_a4 JTF_NUMBER_TABLE
1567: , p5_a5 JTF_NUMBER_TABLE
1568: , p5_a6 JTF_NUMBER_TABLE
1569: , p5_a7 JTF_NUMBER_TABLE
1562: , p5_a0 JTF_NUMBER_TABLE
1563: , p5_a1 JTF_NUMBER_TABLE
1564: , p5_a2 JTF_VARCHAR2_TABLE_100
1565: , p5_a3 JTF_NUMBER_TABLE
1566: , p5_a4 JTF_NUMBER_TABLE
1567: , p5_a5 JTF_NUMBER_TABLE
1568: , p5_a6 JTF_NUMBER_TABLE
1569: , p5_a7 JTF_NUMBER_TABLE
1570: , p5_a8 JTF_NUMBER_TABLE
1563: , p5_a1 JTF_NUMBER_TABLE
1564: , p5_a2 JTF_VARCHAR2_TABLE_100
1565: , p5_a3 JTF_NUMBER_TABLE
1566: , p5_a4 JTF_NUMBER_TABLE
1567: , p5_a5 JTF_NUMBER_TABLE
1568: , p5_a6 JTF_NUMBER_TABLE
1569: , p5_a7 JTF_NUMBER_TABLE
1570: , p5_a8 JTF_NUMBER_TABLE
1571: , p5_a9 JTF_NUMBER_TABLE
1564: , p5_a2 JTF_VARCHAR2_TABLE_100
1565: , p5_a3 JTF_NUMBER_TABLE
1566: , p5_a4 JTF_NUMBER_TABLE
1567: , p5_a5 JTF_NUMBER_TABLE
1568: , p5_a6 JTF_NUMBER_TABLE
1569: , p5_a7 JTF_NUMBER_TABLE
1570: , p5_a8 JTF_NUMBER_TABLE
1571: , p5_a9 JTF_NUMBER_TABLE
1572: , p5_a10 JTF_VARCHAR2_TABLE_2000
1565: , p5_a3 JTF_NUMBER_TABLE
1566: , p5_a4 JTF_NUMBER_TABLE
1567: , p5_a5 JTF_NUMBER_TABLE
1568: , p5_a6 JTF_NUMBER_TABLE
1569: , p5_a7 JTF_NUMBER_TABLE
1570: , p5_a8 JTF_NUMBER_TABLE
1571: , p5_a9 JTF_NUMBER_TABLE
1572: , p5_a10 JTF_VARCHAR2_TABLE_2000
1573: , p5_a11 JTF_NUMBER_TABLE
1566: , p5_a4 JTF_NUMBER_TABLE
1567: , p5_a5 JTF_NUMBER_TABLE
1568: , p5_a6 JTF_NUMBER_TABLE
1569: , p5_a7 JTF_NUMBER_TABLE
1570: , p5_a8 JTF_NUMBER_TABLE
1571: , p5_a9 JTF_NUMBER_TABLE
1572: , p5_a10 JTF_VARCHAR2_TABLE_2000
1573: , p5_a11 JTF_NUMBER_TABLE
1574: , p5_a12 JTF_VARCHAR2_TABLE_100
1567: , p5_a5 JTF_NUMBER_TABLE
1568: , p5_a6 JTF_NUMBER_TABLE
1569: , p5_a7 JTF_NUMBER_TABLE
1570: , p5_a8 JTF_NUMBER_TABLE
1571: , p5_a9 JTF_NUMBER_TABLE
1572: , p5_a10 JTF_VARCHAR2_TABLE_2000
1573: , p5_a11 JTF_NUMBER_TABLE
1574: , p5_a12 JTF_VARCHAR2_TABLE_100
1575: , p5_a13 JTF_VARCHAR2_TABLE_500
1569: , p5_a7 JTF_NUMBER_TABLE
1570: , p5_a8 JTF_NUMBER_TABLE
1571: , p5_a9 JTF_NUMBER_TABLE
1572: , p5_a10 JTF_VARCHAR2_TABLE_2000
1573: , p5_a11 JTF_NUMBER_TABLE
1574: , p5_a12 JTF_VARCHAR2_TABLE_100
1575: , p5_a13 JTF_VARCHAR2_TABLE_500
1576: , p5_a14 JTF_VARCHAR2_TABLE_500
1577: , p5_a15 JTF_VARCHAR2_TABLE_500
1586: , p5_a24 JTF_VARCHAR2_TABLE_500
1587: , p5_a25 JTF_VARCHAR2_TABLE_500
1588: , p5_a26 JTF_VARCHAR2_TABLE_500
1589: , p5_a27 JTF_VARCHAR2_TABLE_500
1590: , p5_a28 JTF_NUMBER_TABLE
1591: , p5_a29 JTF_NUMBER_TABLE
1592: , p5_a30 JTF_NUMBER_TABLE
1593: , p5_a31 JTF_DATE_TABLE
1594: , p5_a32 JTF_NUMBER_TABLE
1587: , p5_a25 JTF_VARCHAR2_TABLE_500
1588: , p5_a26 JTF_VARCHAR2_TABLE_500
1589: , p5_a27 JTF_VARCHAR2_TABLE_500
1590: , p5_a28 JTF_NUMBER_TABLE
1591: , p5_a29 JTF_NUMBER_TABLE
1592: , p5_a30 JTF_NUMBER_TABLE
1593: , p5_a31 JTF_DATE_TABLE
1594: , p5_a32 JTF_NUMBER_TABLE
1595: , p5_a33 JTF_NUMBER_TABLE
1588: , p5_a26 JTF_VARCHAR2_TABLE_500
1589: , p5_a27 JTF_VARCHAR2_TABLE_500
1590: , p5_a28 JTF_NUMBER_TABLE
1591: , p5_a29 JTF_NUMBER_TABLE
1592: , p5_a30 JTF_NUMBER_TABLE
1593: , p5_a31 JTF_DATE_TABLE
1594: , p5_a32 JTF_NUMBER_TABLE
1595: , p5_a33 JTF_NUMBER_TABLE
1596: , p5_a34 JTF_DATE_TABLE
1590: , p5_a28 JTF_NUMBER_TABLE
1591: , p5_a29 JTF_NUMBER_TABLE
1592: , p5_a30 JTF_NUMBER_TABLE
1593: , p5_a31 JTF_DATE_TABLE
1594: , p5_a32 JTF_NUMBER_TABLE
1595: , p5_a33 JTF_NUMBER_TABLE
1596: , p5_a34 JTF_DATE_TABLE
1597: , p5_a35 JTF_NUMBER_TABLE
1598: , p5_a36 JTF_DATE_TABLE
1591: , p5_a29 JTF_NUMBER_TABLE
1592: , p5_a30 JTF_NUMBER_TABLE
1593: , p5_a31 JTF_DATE_TABLE
1594: , p5_a32 JTF_NUMBER_TABLE
1595: , p5_a33 JTF_NUMBER_TABLE
1596: , p5_a34 JTF_DATE_TABLE
1597: , p5_a35 JTF_NUMBER_TABLE
1598: , p5_a36 JTF_DATE_TABLE
1599: , p5_a37 JTF_NUMBER_TABLE
1593: , p5_a31 JTF_DATE_TABLE
1594: , p5_a32 JTF_NUMBER_TABLE
1595: , p5_a33 JTF_NUMBER_TABLE
1596: , p5_a34 JTF_DATE_TABLE
1597: , p5_a35 JTF_NUMBER_TABLE
1598: , p5_a36 JTF_DATE_TABLE
1599: , p5_a37 JTF_NUMBER_TABLE
1600: , p5_a38 JTF_NUMBER_TABLE
1601: , p5_a39 JTF_NUMBER_TABLE
1595: , p5_a33 JTF_NUMBER_TABLE
1596: , p5_a34 JTF_DATE_TABLE
1597: , p5_a35 JTF_NUMBER_TABLE
1598: , p5_a36 JTF_DATE_TABLE
1599: , p5_a37 JTF_NUMBER_TABLE
1600: , p5_a38 JTF_NUMBER_TABLE
1601: , p5_a39 JTF_NUMBER_TABLE
1602: , p6_a0 out nocopy JTF_NUMBER_TABLE
1603: , p6_a1 out nocopy JTF_NUMBER_TABLE
1596: , p5_a34 JTF_DATE_TABLE
1597: , p5_a35 JTF_NUMBER_TABLE
1598: , p5_a36 JTF_DATE_TABLE
1599: , p5_a37 JTF_NUMBER_TABLE
1600: , p5_a38 JTF_NUMBER_TABLE
1601: , p5_a39 JTF_NUMBER_TABLE
1602: , p6_a0 out nocopy JTF_NUMBER_TABLE
1603: , p6_a1 out nocopy JTF_NUMBER_TABLE
1604: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1597: , p5_a35 JTF_NUMBER_TABLE
1598: , p5_a36 JTF_DATE_TABLE
1599: , p5_a37 JTF_NUMBER_TABLE
1600: , p5_a38 JTF_NUMBER_TABLE
1601: , p5_a39 JTF_NUMBER_TABLE
1602: , p6_a0 out nocopy JTF_NUMBER_TABLE
1603: , p6_a1 out nocopy JTF_NUMBER_TABLE
1604: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1605: , p6_a3 out nocopy JTF_NUMBER_TABLE
1598: , p5_a36 JTF_DATE_TABLE
1599: , p5_a37 JTF_NUMBER_TABLE
1600: , p5_a38 JTF_NUMBER_TABLE
1601: , p5_a39 JTF_NUMBER_TABLE
1602: , p6_a0 out nocopy JTF_NUMBER_TABLE
1603: , p6_a1 out nocopy JTF_NUMBER_TABLE
1604: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1605: , p6_a3 out nocopy JTF_NUMBER_TABLE
1606: , p6_a4 out nocopy JTF_NUMBER_TABLE
1599: , p5_a37 JTF_NUMBER_TABLE
1600: , p5_a38 JTF_NUMBER_TABLE
1601: , p5_a39 JTF_NUMBER_TABLE
1602: , p6_a0 out nocopy JTF_NUMBER_TABLE
1603: , p6_a1 out nocopy JTF_NUMBER_TABLE
1604: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1605: , p6_a3 out nocopy JTF_NUMBER_TABLE
1606: , p6_a4 out nocopy JTF_NUMBER_TABLE
1607: , p6_a5 out nocopy JTF_NUMBER_TABLE
1601: , p5_a39 JTF_NUMBER_TABLE
1602: , p6_a0 out nocopy JTF_NUMBER_TABLE
1603: , p6_a1 out nocopy JTF_NUMBER_TABLE
1604: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1605: , p6_a3 out nocopy JTF_NUMBER_TABLE
1606: , p6_a4 out nocopy JTF_NUMBER_TABLE
1607: , p6_a5 out nocopy JTF_NUMBER_TABLE
1608: , p6_a6 out nocopy JTF_NUMBER_TABLE
1609: , p6_a7 out nocopy JTF_NUMBER_TABLE
1602: , p6_a0 out nocopy JTF_NUMBER_TABLE
1603: , p6_a1 out nocopy JTF_NUMBER_TABLE
1604: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1605: , p6_a3 out nocopy JTF_NUMBER_TABLE
1606: , p6_a4 out nocopy JTF_NUMBER_TABLE
1607: , p6_a5 out nocopy JTF_NUMBER_TABLE
1608: , p6_a6 out nocopy JTF_NUMBER_TABLE
1609: , p6_a7 out nocopy JTF_NUMBER_TABLE
1610: , p6_a8 out nocopy JTF_NUMBER_TABLE
1603: , p6_a1 out nocopy JTF_NUMBER_TABLE
1604: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1605: , p6_a3 out nocopy JTF_NUMBER_TABLE
1606: , p6_a4 out nocopy JTF_NUMBER_TABLE
1607: , p6_a5 out nocopy JTF_NUMBER_TABLE
1608: , p6_a6 out nocopy JTF_NUMBER_TABLE
1609: , p6_a7 out nocopy JTF_NUMBER_TABLE
1610: , p6_a8 out nocopy JTF_NUMBER_TABLE
1611: , p6_a9 out nocopy JTF_NUMBER_TABLE
1604: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1605: , p6_a3 out nocopy JTF_NUMBER_TABLE
1606: , p6_a4 out nocopy JTF_NUMBER_TABLE
1607: , p6_a5 out nocopy JTF_NUMBER_TABLE
1608: , p6_a6 out nocopy JTF_NUMBER_TABLE
1609: , p6_a7 out nocopy JTF_NUMBER_TABLE
1610: , p6_a8 out nocopy JTF_NUMBER_TABLE
1611: , p6_a9 out nocopy JTF_NUMBER_TABLE
1612: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
1605: , p6_a3 out nocopy JTF_NUMBER_TABLE
1606: , p6_a4 out nocopy JTF_NUMBER_TABLE
1607: , p6_a5 out nocopy JTF_NUMBER_TABLE
1608: , p6_a6 out nocopy JTF_NUMBER_TABLE
1609: , p6_a7 out nocopy JTF_NUMBER_TABLE
1610: , p6_a8 out nocopy JTF_NUMBER_TABLE
1611: , p6_a9 out nocopy JTF_NUMBER_TABLE
1612: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
1613: , p6_a11 out nocopy JTF_NUMBER_TABLE
1606: , p6_a4 out nocopy JTF_NUMBER_TABLE
1607: , p6_a5 out nocopy JTF_NUMBER_TABLE
1608: , p6_a6 out nocopy JTF_NUMBER_TABLE
1609: , p6_a7 out nocopy JTF_NUMBER_TABLE
1610: , p6_a8 out nocopy JTF_NUMBER_TABLE
1611: , p6_a9 out nocopy JTF_NUMBER_TABLE
1612: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
1613: , p6_a11 out nocopy JTF_NUMBER_TABLE
1614: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1607: , p6_a5 out nocopy JTF_NUMBER_TABLE
1608: , p6_a6 out nocopy JTF_NUMBER_TABLE
1609: , p6_a7 out nocopy JTF_NUMBER_TABLE
1610: , p6_a8 out nocopy JTF_NUMBER_TABLE
1611: , p6_a9 out nocopy JTF_NUMBER_TABLE
1612: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
1613: , p6_a11 out nocopy JTF_NUMBER_TABLE
1614: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1615: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
1609: , p6_a7 out nocopy JTF_NUMBER_TABLE
1610: , p6_a8 out nocopy JTF_NUMBER_TABLE
1611: , p6_a9 out nocopy JTF_NUMBER_TABLE
1612: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
1613: , p6_a11 out nocopy JTF_NUMBER_TABLE
1614: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1615: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
1616: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
1617: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
1626: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1627: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1628: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1629: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1630: , p6_a28 out nocopy JTF_NUMBER_TABLE
1631: , p6_a29 out nocopy JTF_NUMBER_TABLE
1632: , p6_a30 out nocopy JTF_NUMBER_TABLE
1633: , p6_a31 out nocopy JTF_DATE_TABLE
1634: , p6_a32 out nocopy JTF_NUMBER_TABLE
1627: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1628: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1629: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1630: , p6_a28 out nocopy JTF_NUMBER_TABLE
1631: , p6_a29 out nocopy JTF_NUMBER_TABLE
1632: , p6_a30 out nocopy JTF_NUMBER_TABLE
1633: , p6_a31 out nocopy JTF_DATE_TABLE
1634: , p6_a32 out nocopy JTF_NUMBER_TABLE
1635: , p6_a33 out nocopy JTF_NUMBER_TABLE
1628: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1629: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1630: , p6_a28 out nocopy JTF_NUMBER_TABLE
1631: , p6_a29 out nocopy JTF_NUMBER_TABLE
1632: , p6_a30 out nocopy JTF_NUMBER_TABLE
1633: , p6_a31 out nocopy JTF_DATE_TABLE
1634: , p6_a32 out nocopy JTF_NUMBER_TABLE
1635: , p6_a33 out nocopy JTF_NUMBER_TABLE
1636: , p6_a34 out nocopy JTF_DATE_TABLE
1630: , p6_a28 out nocopy JTF_NUMBER_TABLE
1631: , p6_a29 out nocopy JTF_NUMBER_TABLE
1632: , p6_a30 out nocopy JTF_NUMBER_TABLE
1633: , p6_a31 out nocopy JTF_DATE_TABLE
1634: , p6_a32 out nocopy JTF_NUMBER_TABLE
1635: , p6_a33 out nocopy JTF_NUMBER_TABLE
1636: , p6_a34 out nocopy JTF_DATE_TABLE
1637: , p6_a35 out nocopy JTF_NUMBER_TABLE
1638: , p6_a36 out nocopy JTF_DATE_TABLE
1631: , p6_a29 out nocopy JTF_NUMBER_TABLE
1632: , p6_a30 out nocopy JTF_NUMBER_TABLE
1633: , p6_a31 out nocopy JTF_DATE_TABLE
1634: , p6_a32 out nocopy JTF_NUMBER_TABLE
1635: , p6_a33 out nocopy JTF_NUMBER_TABLE
1636: , p6_a34 out nocopy JTF_DATE_TABLE
1637: , p6_a35 out nocopy JTF_NUMBER_TABLE
1638: , p6_a36 out nocopy JTF_DATE_TABLE
1639: , p6_a37 out nocopy JTF_NUMBER_TABLE
1633: , p6_a31 out nocopy JTF_DATE_TABLE
1634: , p6_a32 out nocopy JTF_NUMBER_TABLE
1635: , p6_a33 out nocopy JTF_NUMBER_TABLE
1636: , p6_a34 out nocopy JTF_DATE_TABLE
1637: , p6_a35 out nocopy JTF_NUMBER_TABLE
1638: , p6_a36 out nocopy JTF_DATE_TABLE
1639: , p6_a37 out nocopy JTF_NUMBER_TABLE
1640: , p6_a38 out nocopy JTF_NUMBER_TABLE
1641: , p6_a39 out nocopy JTF_NUMBER_TABLE
1635: , p6_a33 out nocopy JTF_NUMBER_TABLE
1636: , p6_a34 out nocopy JTF_DATE_TABLE
1637: , p6_a35 out nocopy JTF_NUMBER_TABLE
1638: , p6_a36 out nocopy JTF_DATE_TABLE
1639: , p6_a37 out nocopy JTF_NUMBER_TABLE
1640: , p6_a38 out nocopy JTF_NUMBER_TABLE
1641: , p6_a39 out nocopy JTF_NUMBER_TABLE
1642: )
1643:
1636: , p6_a34 out nocopy JTF_DATE_TABLE
1637: , p6_a35 out nocopy JTF_NUMBER_TABLE
1638: , p6_a36 out nocopy JTF_DATE_TABLE
1639: , p6_a37 out nocopy JTF_NUMBER_TABLE
1640: , p6_a38 out nocopy JTF_NUMBER_TABLE
1641: , p6_a39 out nocopy JTF_NUMBER_TABLE
1642: )
1643:
1644: as
1637: , p6_a35 out nocopy JTF_NUMBER_TABLE
1638: , p6_a36 out nocopy JTF_DATE_TABLE
1639: , p6_a37 out nocopy JTF_NUMBER_TABLE
1640: , p6_a38 out nocopy JTF_NUMBER_TABLE
1641: , p6_a39 out nocopy JTF_NUMBER_TABLE
1642: )
1643:
1644: as
1645: ddp_rcav_tbl okl_rca_pvt.rcav_tbl_type;
1874: , p_init_msg_list VARCHAR2
1875: , x_return_status out nocopy VARCHAR2
1876: , x_msg_count out nocopy NUMBER
1877: , x_msg_data out nocopy VARCHAR2
1878: , p5_a0 JTF_NUMBER_TABLE
1879: , p5_a1 JTF_NUMBER_TABLE
1880: , p5_a2 JTF_VARCHAR2_TABLE_100
1881: , p5_a3 JTF_NUMBER_TABLE
1882: , p5_a4 JTF_NUMBER_TABLE
1875: , x_return_status out nocopy VARCHAR2
1876: , x_msg_count out nocopy NUMBER
1877: , x_msg_data out nocopy VARCHAR2
1878: , p5_a0 JTF_NUMBER_TABLE
1879: , p5_a1 JTF_NUMBER_TABLE
1880: , p5_a2 JTF_VARCHAR2_TABLE_100
1881: , p5_a3 JTF_NUMBER_TABLE
1882: , p5_a4 JTF_NUMBER_TABLE
1883: , p5_a5 JTF_NUMBER_TABLE
1877: , x_msg_data out nocopy VARCHAR2
1878: , p5_a0 JTF_NUMBER_TABLE
1879: , p5_a1 JTF_NUMBER_TABLE
1880: , p5_a2 JTF_VARCHAR2_TABLE_100
1881: , p5_a3 JTF_NUMBER_TABLE
1882: , p5_a4 JTF_NUMBER_TABLE
1883: , p5_a5 JTF_NUMBER_TABLE
1884: , p5_a6 JTF_NUMBER_TABLE
1885: , p5_a7 JTF_NUMBER_TABLE
1878: , p5_a0 JTF_NUMBER_TABLE
1879: , p5_a1 JTF_NUMBER_TABLE
1880: , p5_a2 JTF_VARCHAR2_TABLE_100
1881: , p5_a3 JTF_NUMBER_TABLE
1882: , p5_a4 JTF_NUMBER_TABLE
1883: , p5_a5 JTF_NUMBER_TABLE
1884: , p5_a6 JTF_NUMBER_TABLE
1885: , p5_a7 JTF_NUMBER_TABLE
1886: , p5_a8 JTF_NUMBER_TABLE
1879: , p5_a1 JTF_NUMBER_TABLE
1880: , p5_a2 JTF_VARCHAR2_TABLE_100
1881: , p5_a3 JTF_NUMBER_TABLE
1882: , p5_a4 JTF_NUMBER_TABLE
1883: , p5_a5 JTF_NUMBER_TABLE
1884: , p5_a6 JTF_NUMBER_TABLE
1885: , p5_a7 JTF_NUMBER_TABLE
1886: , p5_a8 JTF_NUMBER_TABLE
1887: , p5_a9 JTF_NUMBER_TABLE
1880: , p5_a2 JTF_VARCHAR2_TABLE_100
1881: , p5_a3 JTF_NUMBER_TABLE
1882: , p5_a4 JTF_NUMBER_TABLE
1883: , p5_a5 JTF_NUMBER_TABLE
1884: , p5_a6 JTF_NUMBER_TABLE
1885: , p5_a7 JTF_NUMBER_TABLE
1886: , p5_a8 JTF_NUMBER_TABLE
1887: , p5_a9 JTF_NUMBER_TABLE
1888: , p5_a10 JTF_VARCHAR2_TABLE_2000
1881: , p5_a3 JTF_NUMBER_TABLE
1882: , p5_a4 JTF_NUMBER_TABLE
1883: , p5_a5 JTF_NUMBER_TABLE
1884: , p5_a6 JTF_NUMBER_TABLE
1885: , p5_a7 JTF_NUMBER_TABLE
1886: , p5_a8 JTF_NUMBER_TABLE
1887: , p5_a9 JTF_NUMBER_TABLE
1888: , p5_a10 JTF_VARCHAR2_TABLE_2000
1889: , p5_a11 JTF_NUMBER_TABLE
1882: , p5_a4 JTF_NUMBER_TABLE
1883: , p5_a5 JTF_NUMBER_TABLE
1884: , p5_a6 JTF_NUMBER_TABLE
1885: , p5_a7 JTF_NUMBER_TABLE
1886: , p5_a8 JTF_NUMBER_TABLE
1887: , p5_a9 JTF_NUMBER_TABLE
1888: , p5_a10 JTF_VARCHAR2_TABLE_2000
1889: , p5_a11 JTF_NUMBER_TABLE
1890: , p5_a12 JTF_VARCHAR2_TABLE_100
1883: , p5_a5 JTF_NUMBER_TABLE
1884: , p5_a6 JTF_NUMBER_TABLE
1885: , p5_a7 JTF_NUMBER_TABLE
1886: , p5_a8 JTF_NUMBER_TABLE
1887: , p5_a9 JTF_NUMBER_TABLE
1888: , p5_a10 JTF_VARCHAR2_TABLE_2000
1889: , p5_a11 JTF_NUMBER_TABLE
1890: , p5_a12 JTF_VARCHAR2_TABLE_100
1891: , p5_a13 JTF_VARCHAR2_TABLE_500
1885: , p5_a7 JTF_NUMBER_TABLE
1886: , p5_a8 JTF_NUMBER_TABLE
1887: , p5_a9 JTF_NUMBER_TABLE
1888: , p5_a10 JTF_VARCHAR2_TABLE_2000
1889: , p5_a11 JTF_NUMBER_TABLE
1890: , p5_a12 JTF_VARCHAR2_TABLE_100
1891: , p5_a13 JTF_VARCHAR2_TABLE_500
1892: , p5_a14 JTF_VARCHAR2_TABLE_500
1893: , p5_a15 JTF_VARCHAR2_TABLE_500
1902: , p5_a24 JTF_VARCHAR2_TABLE_500
1903: , p5_a25 JTF_VARCHAR2_TABLE_500
1904: , p5_a26 JTF_VARCHAR2_TABLE_500
1905: , p5_a27 JTF_VARCHAR2_TABLE_500
1906: , p5_a28 JTF_NUMBER_TABLE
1907: , p5_a29 JTF_NUMBER_TABLE
1908: , p5_a30 JTF_NUMBER_TABLE
1909: , p5_a31 JTF_DATE_TABLE
1910: , p5_a32 JTF_NUMBER_TABLE
1903: , p5_a25 JTF_VARCHAR2_TABLE_500
1904: , p5_a26 JTF_VARCHAR2_TABLE_500
1905: , p5_a27 JTF_VARCHAR2_TABLE_500
1906: , p5_a28 JTF_NUMBER_TABLE
1907: , p5_a29 JTF_NUMBER_TABLE
1908: , p5_a30 JTF_NUMBER_TABLE
1909: , p5_a31 JTF_DATE_TABLE
1910: , p5_a32 JTF_NUMBER_TABLE
1911: , p5_a33 JTF_NUMBER_TABLE
1904: , p5_a26 JTF_VARCHAR2_TABLE_500
1905: , p5_a27 JTF_VARCHAR2_TABLE_500
1906: , p5_a28 JTF_NUMBER_TABLE
1907: , p5_a29 JTF_NUMBER_TABLE
1908: , p5_a30 JTF_NUMBER_TABLE
1909: , p5_a31 JTF_DATE_TABLE
1910: , p5_a32 JTF_NUMBER_TABLE
1911: , p5_a33 JTF_NUMBER_TABLE
1912: , p5_a34 JTF_DATE_TABLE
1906: , p5_a28 JTF_NUMBER_TABLE
1907: , p5_a29 JTF_NUMBER_TABLE
1908: , p5_a30 JTF_NUMBER_TABLE
1909: , p5_a31 JTF_DATE_TABLE
1910: , p5_a32 JTF_NUMBER_TABLE
1911: , p5_a33 JTF_NUMBER_TABLE
1912: , p5_a34 JTF_DATE_TABLE
1913: , p5_a35 JTF_NUMBER_TABLE
1914: , p5_a36 JTF_DATE_TABLE
1907: , p5_a29 JTF_NUMBER_TABLE
1908: , p5_a30 JTF_NUMBER_TABLE
1909: , p5_a31 JTF_DATE_TABLE
1910: , p5_a32 JTF_NUMBER_TABLE
1911: , p5_a33 JTF_NUMBER_TABLE
1912: , p5_a34 JTF_DATE_TABLE
1913: , p5_a35 JTF_NUMBER_TABLE
1914: , p5_a36 JTF_DATE_TABLE
1915: , p5_a37 JTF_NUMBER_TABLE
1909: , p5_a31 JTF_DATE_TABLE
1910: , p5_a32 JTF_NUMBER_TABLE
1911: , p5_a33 JTF_NUMBER_TABLE
1912: , p5_a34 JTF_DATE_TABLE
1913: , p5_a35 JTF_NUMBER_TABLE
1914: , p5_a36 JTF_DATE_TABLE
1915: , p5_a37 JTF_NUMBER_TABLE
1916: , p5_a38 JTF_NUMBER_TABLE
1917: , p5_a39 JTF_NUMBER_TABLE
1911: , p5_a33 JTF_NUMBER_TABLE
1912: , p5_a34 JTF_DATE_TABLE
1913: , p5_a35 JTF_NUMBER_TABLE
1914: , p5_a36 JTF_DATE_TABLE
1915: , p5_a37 JTF_NUMBER_TABLE
1916: , p5_a38 JTF_NUMBER_TABLE
1917: , p5_a39 JTF_NUMBER_TABLE
1918: )
1919:
1912: , p5_a34 JTF_DATE_TABLE
1913: , p5_a35 JTF_NUMBER_TABLE
1914: , p5_a36 JTF_DATE_TABLE
1915: , p5_a37 JTF_NUMBER_TABLE
1916: , p5_a38 JTF_NUMBER_TABLE
1917: , p5_a39 JTF_NUMBER_TABLE
1918: )
1919:
1920: as
1913: , p5_a35 JTF_NUMBER_TABLE
1914: , p5_a36 JTF_DATE_TABLE
1915: , p5_a37 JTF_NUMBER_TABLE
1916: , p5_a38 JTF_NUMBER_TABLE
1917: , p5_a39 JTF_NUMBER_TABLE
1918: )
1919:
1920: as
1921: ddp_rcav_tbl okl_rca_pvt.rcav_tbl_type;
2105: , p_init_msg_list VARCHAR2
2106: , x_return_status out nocopy VARCHAR2
2107: , x_msg_count out nocopy NUMBER
2108: , x_msg_data out nocopy VARCHAR2
2109: , p5_a0 JTF_NUMBER_TABLE
2110: , p5_a1 JTF_NUMBER_TABLE
2111: , p5_a2 JTF_VARCHAR2_TABLE_100
2112: , p5_a3 JTF_NUMBER_TABLE
2113: , p5_a4 JTF_NUMBER_TABLE
2106: , x_return_status out nocopy VARCHAR2
2107: , x_msg_count out nocopy NUMBER
2108: , x_msg_data out nocopy VARCHAR2
2109: , p5_a0 JTF_NUMBER_TABLE
2110: , p5_a1 JTF_NUMBER_TABLE
2111: , p5_a2 JTF_VARCHAR2_TABLE_100
2112: , p5_a3 JTF_NUMBER_TABLE
2113: , p5_a4 JTF_NUMBER_TABLE
2114: , p5_a5 JTF_NUMBER_TABLE
2108: , x_msg_data out nocopy VARCHAR2
2109: , p5_a0 JTF_NUMBER_TABLE
2110: , p5_a1 JTF_NUMBER_TABLE
2111: , p5_a2 JTF_VARCHAR2_TABLE_100
2112: , p5_a3 JTF_NUMBER_TABLE
2113: , p5_a4 JTF_NUMBER_TABLE
2114: , p5_a5 JTF_NUMBER_TABLE
2115: , p5_a6 JTF_NUMBER_TABLE
2116: , p5_a7 JTF_NUMBER_TABLE
2109: , p5_a0 JTF_NUMBER_TABLE
2110: , p5_a1 JTF_NUMBER_TABLE
2111: , p5_a2 JTF_VARCHAR2_TABLE_100
2112: , p5_a3 JTF_NUMBER_TABLE
2113: , p5_a4 JTF_NUMBER_TABLE
2114: , p5_a5 JTF_NUMBER_TABLE
2115: , p5_a6 JTF_NUMBER_TABLE
2116: , p5_a7 JTF_NUMBER_TABLE
2117: , p5_a8 JTF_NUMBER_TABLE
2110: , p5_a1 JTF_NUMBER_TABLE
2111: , p5_a2 JTF_VARCHAR2_TABLE_100
2112: , p5_a3 JTF_NUMBER_TABLE
2113: , p5_a4 JTF_NUMBER_TABLE
2114: , p5_a5 JTF_NUMBER_TABLE
2115: , p5_a6 JTF_NUMBER_TABLE
2116: , p5_a7 JTF_NUMBER_TABLE
2117: , p5_a8 JTF_NUMBER_TABLE
2118: , p5_a9 JTF_NUMBER_TABLE
2111: , p5_a2 JTF_VARCHAR2_TABLE_100
2112: , p5_a3 JTF_NUMBER_TABLE
2113: , p5_a4 JTF_NUMBER_TABLE
2114: , p5_a5 JTF_NUMBER_TABLE
2115: , p5_a6 JTF_NUMBER_TABLE
2116: , p5_a7 JTF_NUMBER_TABLE
2117: , p5_a8 JTF_NUMBER_TABLE
2118: , p5_a9 JTF_NUMBER_TABLE
2119: , p5_a10 JTF_VARCHAR2_TABLE_2000
2112: , p5_a3 JTF_NUMBER_TABLE
2113: , p5_a4 JTF_NUMBER_TABLE
2114: , p5_a5 JTF_NUMBER_TABLE
2115: , p5_a6 JTF_NUMBER_TABLE
2116: , p5_a7 JTF_NUMBER_TABLE
2117: , p5_a8 JTF_NUMBER_TABLE
2118: , p5_a9 JTF_NUMBER_TABLE
2119: , p5_a10 JTF_VARCHAR2_TABLE_2000
2120: , p5_a11 JTF_NUMBER_TABLE
2113: , p5_a4 JTF_NUMBER_TABLE
2114: , p5_a5 JTF_NUMBER_TABLE
2115: , p5_a6 JTF_NUMBER_TABLE
2116: , p5_a7 JTF_NUMBER_TABLE
2117: , p5_a8 JTF_NUMBER_TABLE
2118: , p5_a9 JTF_NUMBER_TABLE
2119: , p5_a10 JTF_VARCHAR2_TABLE_2000
2120: , p5_a11 JTF_NUMBER_TABLE
2121: , p5_a12 JTF_VARCHAR2_TABLE_100
2114: , p5_a5 JTF_NUMBER_TABLE
2115: , p5_a6 JTF_NUMBER_TABLE
2116: , p5_a7 JTF_NUMBER_TABLE
2117: , p5_a8 JTF_NUMBER_TABLE
2118: , p5_a9 JTF_NUMBER_TABLE
2119: , p5_a10 JTF_VARCHAR2_TABLE_2000
2120: , p5_a11 JTF_NUMBER_TABLE
2121: , p5_a12 JTF_VARCHAR2_TABLE_100
2122: , p5_a13 JTF_VARCHAR2_TABLE_500
2116: , p5_a7 JTF_NUMBER_TABLE
2117: , p5_a8 JTF_NUMBER_TABLE
2118: , p5_a9 JTF_NUMBER_TABLE
2119: , p5_a10 JTF_VARCHAR2_TABLE_2000
2120: , p5_a11 JTF_NUMBER_TABLE
2121: , p5_a12 JTF_VARCHAR2_TABLE_100
2122: , p5_a13 JTF_VARCHAR2_TABLE_500
2123: , p5_a14 JTF_VARCHAR2_TABLE_500
2124: , p5_a15 JTF_VARCHAR2_TABLE_500
2133: , p5_a24 JTF_VARCHAR2_TABLE_500
2134: , p5_a25 JTF_VARCHAR2_TABLE_500
2135: , p5_a26 JTF_VARCHAR2_TABLE_500
2136: , p5_a27 JTF_VARCHAR2_TABLE_500
2137: , p5_a28 JTF_NUMBER_TABLE
2138: , p5_a29 JTF_NUMBER_TABLE
2139: , p5_a30 JTF_NUMBER_TABLE
2140: , p5_a31 JTF_DATE_TABLE
2141: , p5_a32 JTF_NUMBER_TABLE
2134: , p5_a25 JTF_VARCHAR2_TABLE_500
2135: , p5_a26 JTF_VARCHAR2_TABLE_500
2136: , p5_a27 JTF_VARCHAR2_TABLE_500
2137: , p5_a28 JTF_NUMBER_TABLE
2138: , p5_a29 JTF_NUMBER_TABLE
2139: , p5_a30 JTF_NUMBER_TABLE
2140: , p5_a31 JTF_DATE_TABLE
2141: , p5_a32 JTF_NUMBER_TABLE
2142: , p5_a33 JTF_NUMBER_TABLE
2135: , p5_a26 JTF_VARCHAR2_TABLE_500
2136: , p5_a27 JTF_VARCHAR2_TABLE_500
2137: , p5_a28 JTF_NUMBER_TABLE
2138: , p5_a29 JTF_NUMBER_TABLE
2139: , p5_a30 JTF_NUMBER_TABLE
2140: , p5_a31 JTF_DATE_TABLE
2141: , p5_a32 JTF_NUMBER_TABLE
2142: , p5_a33 JTF_NUMBER_TABLE
2143: , p5_a34 JTF_DATE_TABLE
2137: , p5_a28 JTF_NUMBER_TABLE
2138: , p5_a29 JTF_NUMBER_TABLE
2139: , p5_a30 JTF_NUMBER_TABLE
2140: , p5_a31 JTF_DATE_TABLE
2141: , p5_a32 JTF_NUMBER_TABLE
2142: , p5_a33 JTF_NUMBER_TABLE
2143: , p5_a34 JTF_DATE_TABLE
2144: , p5_a35 JTF_NUMBER_TABLE
2145: , p5_a36 JTF_DATE_TABLE
2138: , p5_a29 JTF_NUMBER_TABLE
2139: , p5_a30 JTF_NUMBER_TABLE
2140: , p5_a31 JTF_DATE_TABLE
2141: , p5_a32 JTF_NUMBER_TABLE
2142: , p5_a33 JTF_NUMBER_TABLE
2143: , p5_a34 JTF_DATE_TABLE
2144: , p5_a35 JTF_NUMBER_TABLE
2145: , p5_a36 JTF_DATE_TABLE
2146: , p5_a37 JTF_NUMBER_TABLE
2140: , p5_a31 JTF_DATE_TABLE
2141: , p5_a32 JTF_NUMBER_TABLE
2142: , p5_a33 JTF_NUMBER_TABLE
2143: , p5_a34 JTF_DATE_TABLE
2144: , p5_a35 JTF_NUMBER_TABLE
2145: , p5_a36 JTF_DATE_TABLE
2146: , p5_a37 JTF_NUMBER_TABLE
2147: , p5_a38 JTF_NUMBER_TABLE
2148: , p5_a39 JTF_NUMBER_TABLE
2142: , p5_a33 JTF_NUMBER_TABLE
2143: , p5_a34 JTF_DATE_TABLE
2144: , p5_a35 JTF_NUMBER_TABLE
2145: , p5_a36 JTF_DATE_TABLE
2146: , p5_a37 JTF_NUMBER_TABLE
2147: , p5_a38 JTF_NUMBER_TABLE
2148: , p5_a39 JTF_NUMBER_TABLE
2149: )
2150:
2143: , p5_a34 JTF_DATE_TABLE
2144: , p5_a35 JTF_NUMBER_TABLE
2145: , p5_a36 JTF_DATE_TABLE
2146: , p5_a37 JTF_NUMBER_TABLE
2147: , p5_a38 JTF_NUMBER_TABLE
2148: , p5_a39 JTF_NUMBER_TABLE
2149: )
2150:
2151: as
2144: , p5_a35 JTF_NUMBER_TABLE
2145: , p5_a36 JTF_DATE_TABLE
2146: , p5_a37 JTF_NUMBER_TABLE
2147: , p5_a38 JTF_NUMBER_TABLE
2148: , p5_a39 JTF_NUMBER_TABLE
2149: )
2150:
2151: as
2152: ddp_rcav_tbl okl_rca_pvt.rcav_tbl_type;