1: package body ahl_ump_smrinstance_pvt_w as
2: /* $Header: AHLSMRWB.pls 120.4.12020000.2 2012/12/10 16:42:47 prakkum ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ump_smrinstance_pvt.results_mrinstance_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
1: package body ahl_ump_smrinstance_pvt_w as
2: /* $Header: AHLSMRWB.pls 120.4.12020000.2 2012/12/10 16:42:47 prakkum ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ump_smrinstance_pvt.results_mrinstance_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
1: package body ahl_ump_smrinstance_pvt_w as
2: /* $Header: AHLSMRWB.pls 120.4.12020000.2 2012/12/10 16:42:47 prakkum ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ump_smrinstance_pvt.results_mrinstance_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
2: /* $Header: AHLSMRWB.pls 120.4.12020000.2 2012/12/10 16:42:47 prakkum ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ump_smrinstance_pvt.results_mrinstance_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_DATE_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_4000
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_200
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_4000
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_200
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_200
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_200
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_NUMBER_TABLE
42: ) as
43: ddindx binary_integer; indx binary_integer;
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_NUMBER_TABLE
42: ) as
43: ddindx binary_integer; indx binary_integer;
44: begin
94: end loop;
95: end if;
96: end if;
97: end rosetta_table_copy_in_p3;
98: procedure rosetta_table_copy_out_p3(t ahl_ump_smrinstance_pvt.results_mrinstance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
99: , a1 out nocopy JTF_VARCHAR2_TABLE_100
100: , a2 out nocopy JTF_VARCHAR2_TABLE_100
101: , a3 out nocopy JTF_VARCHAR2_TABLE_100
102: , a4 out nocopy JTF_NUMBER_TABLE
95: end if;
96: end if;
97: end rosetta_table_copy_in_p3;
98: procedure rosetta_table_copy_out_p3(t ahl_ump_smrinstance_pvt.results_mrinstance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
99: , a1 out nocopy JTF_VARCHAR2_TABLE_100
100: , a2 out nocopy JTF_VARCHAR2_TABLE_100
101: , a3 out nocopy JTF_VARCHAR2_TABLE_100
102: , a4 out nocopy JTF_NUMBER_TABLE
103: , a5 out nocopy JTF_VARCHAR2_TABLE_100
96: end if;
97: end rosetta_table_copy_in_p3;
98: procedure rosetta_table_copy_out_p3(t ahl_ump_smrinstance_pvt.results_mrinstance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
99: , a1 out nocopy JTF_VARCHAR2_TABLE_100
100: , a2 out nocopy JTF_VARCHAR2_TABLE_100
101: , a3 out nocopy JTF_VARCHAR2_TABLE_100
102: , a4 out nocopy JTF_NUMBER_TABLE
103: , a5 out nocopy JTF_VARCHAR2_TABLE_100
104: , a6 out nocopy JTF_DATE_TABLE
97: end rosetta_table_copy_in_p3;
98: procedure rosetta_table_copy_out_p3(t ahl_ump_smrinstance_pvt.results_mrinstance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
99: , a1 out nocopy JTF_VARCHAR2_TABLE_100
100: , a2 out nocopy JTF_VARCHAR2_TABLE_100
101: , a3 out nocopy JTF_VARCHAR2_TABLE_100
102: , a4 out nocopy JTF_NUMBER_TABLE
103: , a5 out nocopy JTF_VARCHAR2_TABLE_100
104: , a6 out nocopy JTF_DATE_TABLE
105: , a7 out nocopy JTF_DATE_TABLE
99: , a1 out nocopy JTF_VARCHAR2_TABLE_100
100: , a2 out nocopy JTF_VARCHAR2_TABLE_100
101: , a3 out nocopy JTF_VARCHAR2_TABLE_100
102: , a4 out nocopy JTF_NUMBER_TABLE
103: , a5 out nocopy JTF_VARCHAR2_TABLE_100
104: , a6 out nocopy JTF_DATE_TABLE
105: , a7 out nocopy JTF_DATE_TABLE
106: , a8 out nocopy JTF_DATE_TABLE
107: , a9 out nocopy JTF_VARCHAR2_TABLE_100
103: , a5 out nocopy JTF_VARCHAR2_TABLE_100
104: , a6 out nocopy JTF_DATE_TABLE
105: , a7 out nocopy JTF_DATE_TABLE
106: , a8 out nocopy JTF_DATE_TABLE
107: , a9 out nocopy JTF_VARCHAR2_TABLE_100
108: , a10 out nocopy JTF_VARCHAR2_TABLE_100
109: , a11 out nocopy JTF_VARCHAR2_TABLE_100
110: , a12 out nocopy JTF_DATE_TABLE
111: , a13 out nocopy JTF_VARCHAR2_TABLE_100
104: , a6 out nocopy JTF_DATE_TABLE
105: , a7 out nocopy JTF_DATE_TABLE
106: , a8 out nocopy JTF_DATE_TABLE
107: , a9 out nocopy JTF_VARCHAR2_TABLE_100
108: , a10 out nocopy JTF_VARCHAR2_TABLE_100
109: , a11 out nocopy JTF_VARCHAR2_TABLE_100
110: , a12 out nocopy JTF_DATE_TABLE
111: , a13 out nocopy JTF_VARCHAR2_TABLE_100
112: , a14 out nocopy JTF_VARCHAR2_TABLE_100
105: , a7 out nocopy JTF_DATE_TABLE
106: , a8 out nocopy JTF_DATE_TABLE
107: , a9 out nocopy JTF_VARCHAR2_TABLE_100
108: , a10 out nocopy JTF_VARCHAR2_TABLE_100
109: , a11 out nocopy JTF_VARCHAR2_TABLE_100
110: , a12 out nocopy JTF_DATE_TABLE
111: , a13 out nocopy JTF_VARCHAR2_TABLE_100
112: , a14 out nocopy JTF_VARCHAR2_TABLE_100
113: , a15 out nocopy JTF_VARCHAR2_TABLE_100
107: , a9 out nocopy JTF_VARCHAR2_TABLE_100
108: , a10 out nocopy JTF_VARCHAR2_TABLE_100
109: , a11 out nocopy JTF_VARCHAR2_TABLE_100
110: , a12 out nocopy JTF_DATE_TABLE
111: , a13 out nocopy JTF_VARCHAR2_TABLE_100
112: , a14 out nocopy JTF_VARCHAR2_TABLE_100
113: , a15 out nocopy JTF_VARCHAR2_TABLE_100
114: , a16 out nocopy JTF_NUMBER_TABLE
115: , a17 out nocopy JTF_VARCHAR2_TABLE_100
108: , a10 out nocopy JTF_VARCHAR2_TABLE_100
109: , a11 out nocopy JTF_VARCHAR2_TABLE_100
110: , a12 out nocopy JTF_DATE_TABLE
111: , a13 out nocopy JTF_VARCHAR2_TABLE_100
112: , a14 out nocopy JTF_VARCHAR2_TABLE_100
113: , a15 out nocopy JTF_VARCHAR2_TABLE_100
114: , a16 out nocopy JTF_NUMBER_TABLE
115: , a17 out nocopy JTF_VARCHAR2_TABLE_100
116: , a18 out nocopy JTF_DATE_TABLE
109: , a11 out nocopy JTF_VARCHAR2_TABLE_100
110: , a12 out nocopy JTF_DATE_TABLE
111: , a13 out nocopy JTF_VARCHAR2_TABLE_100
112: , a14 out nocopy JTF_VARCHAR2_TABLE_100
113: , a15 out nocopy JTF_VARCHAR2_TABLE_100
114: , a16 out nocopy JTF_NUMBER_TABLE
115: , a17 out nocopy JTF_VARCHAR2_TABLE_100
116: , a18 out nocopy JTF_DATE_TABLE
117: , a19 out nocopy JTF_VARCHAR2_TABLE_100
111: , a13 out nocopy JTF_VARCHAR2_TABLE_100
112: , a14 out nocopy JTF_VARCHAR2_TABLE_100
113: , a15 out nocopy JTF_VARCHAR2_TABLE_100
114: , a16 out nocopy JTF_NUMBER_TABLE
115: , a17 out nocopy JTF_VARCHAR2_TABLE_100
116: , a18 out nocopy JTF_DATE_TABLE
117: , a19 out nocopy JTF_VARCHAR2_TABLE_100
118: , a20 out nocopy JTF_VARCHAR2_TABLE_100
119: , a21 out nocopy JTF_NUMBER_TABLE
113: , a15 out nocopy JTF_VARCHAR2_TABLE_100
114: , a16 out nocopy JTF_NUMBER_TABLE
115: , a17 out nocopy JTF_VARCHAR2_TABLE_100
116: , a18 out nocopy JTF_DATE_TABLE
117: , a19 out nocopy JTF_VARCHAR2_TABLE_100
118: , a20 out nocopy JTF_VARCHAR2_TABLE_100
119: , a21 out nocopy JTF_NUMBER_TABLE
120: , a22 out nocopy JTF_NUMBER_TABLE
121: , a23 out nocopy JTF_NUMBER_TABLE
114: , a16 out nocopy JTF_NUMBER_TABLE
115: , a17 out nocopy JTF_VARCHAR2_TABLE_100
116: , a18 out nocopy JTF_DATE_TABLE
117: , a19 out nocopy JTF_VARCHAR2_TABLE_100
118: , a20 out nocopy JTF_VARCHAR2_TABLE_100
119: , a21 out nocopy JTF_NUMBER_TABLE
120: , a22 out nocopy JTF_NUMBER_TABLE
121: , a23 out nocopy JTF_NUMBER_TABLE
122: , a24 out nocopy JTF_VARCHAR2_TABLE_100
118: , a20 out nocopy JTF_VARCHAR2_TABLE_100
119: , a21 out nocopy JTF_NUMBER_TABLE
120: , a22 out nocopy JTF_NUMBER_TABLE
121: , a23 out nocopy JTF_NUMBER_TABLE
122: , a24 out nocopy JTF_VARCHAR2_TABLE_100
123: , a25 out nocopy JTF_NUMBER_TABLE
124: , a26 out nocopy JTF_VARCHAR2_TABLE_4000
125: , a27 out nocopy JTF_VARCHAR2_TABLE_100
126: , a28 out nocopy JTF_VARCHAR2_TABLE_200
121: , a23 out nocopy JTF_NUMBER_TABLE
122: , a24 out nocopy JTF_VARCHAR2_TABLE_100
123: , a25 out nocopy JTF_NUMBER_TABLE
124: , a26 out nocopy JTF_VARCHAR2_TABLE_4000
125: , a27 out nocopy JTF_VARCHAR2_TABLE_100
126: , a28 out nocopy JTF_VARCHAR2_TABLE_200
127: , a29 out nocopy JTF_NUMBER_TABLE
128: , a30 out nocopy JTF_NUMBER_TABLE
129: , a31 out nocopy JTF_VARCHAR2_TABLE_100
125: , a27 out nocopy JTF_VARCHAR2_TABLE_100
126: , a28 out nocopy JTF_VARCHAR2_TABLE_200
127: , a29 out nocopy JTF_NUMBER_TABLE
128: , a30 out nocopy JTF_NUMBER_TABLE
129: , a31 out nocopy JTF_VARCHAR2_TABLE_100
130: , a32 out nocopy JTF_VARCHAR2_TABLE_100
131: , a33 out nocopy JTF_VARCHAR2_TABLE_100
132: , a34 out nocopy JTF_VARCHAR2_TABLE_100
133: , a35 out nocopy JTF_NUMBER_TABLE
126: , a28 out nocopy JTF_VARCHAR2_TABLE_200
127: , a29 out nocopy JTF_NUMBER_TABLE
128: , a30 out nocopy JTF_NUMBER_TABLE
129: , a31 out nocopy JTF_VARCHAR2_TABLE_100
130: , a32 out nocopy JTF_VARCHAR2_TABLE_100
131: , a33 out nocopy JTF_VARCHAR2_TABLE_100
132: , a34 out nocopy JTF_VARCHAR2_TABLE_100
133: , a35 out nocopy JTF_NUMBER_TABLE
134: , a36 out nocopy JTF_VARCHAR2_TABLE_100
127: , a29 out nocopy JTF_NUMBER_TABLE
128: , a30 out nocopy JTF_NUMBER_TABLE
129: , a31 out nocopy JTF_VARCHAR2_TABLE_100
130: , a32 out nocopy JTF_VARCHAR2_TABLE_100
131: , a33 out nocopy JTF_VARCHAR2_TABLE_100
132: , a34 out nocopy JTF_VARCHAR2_TABLE_100
133: , a35 out nocopy JTF_NUMBER_TABLE
134: , a36 out nocopy JTF_VARCHAR2_TABLE_100
135: , a37 out nocopy JTF_VARCHAR2_TABLE_100
128: , a30 out nocopy JTF_NUMBER_TABLE
129: , a31 out nocopy JTF_VARCHAR2_TABLE_100
130: , a32 out nocopy JTF_VARCHAR2_TABLE_100
131: , a33 out nocopy JTF_VARCHAR2_TABLE_100
132: , a34 out nocopy JTF_VARCHAR2_TABLE_100
133: , a35 out nocopy JTF_NUMBER_TABLE
134: , a36 out nocopy JTF_VARCHAR2_TABLE_100
135: , a37 out nocopy JTF_VARCHAR2_TABLE_100
136: , a38 out nocopy JTF_NUMBER_TABLE
130: , a32 out nocopy JTF_VARCHAR2_TABLE_100
131: , a33 out nocopy JTF_VARCHAR2_TABLE_100
132: , a34 out nocopy JTF_VARCHAR2_TABLE_100
133: , a35 out nocopy JTF_NUMBER_TABLE
134: , a36 out nocopy JTF_VARCHAR2_TABLE_100
135: , a37 out nocopy JTF_VARCHAR2_TABLE_100
136: , a38 out nocopy JTF_NUMBER_TABLE
137: ) as
138: ddindx binary_integer; indx binary_integer;
131: , a33 out nocopy JTF_VARCHAR2_TABLE_100
132: , a34 out nocopy JTF_VARCHAR2_TABLE_100
133: , a35 out nocopy JTF_NUMBER_TABLE
134: , a36 out nocopy JTF_VARCHAR2_TABLE_100
135: , a37 out nocopy JTF_VARCHAR2_TABLE_100
136: , a38 out nocopy JTF_NUMBER_TABLE
137: ) as
138: ddindx binary_integer; indx binary_integer;
139: begin
137: ) as
138: ddindx binary_integer; indx binary_integer;
139: begin
140: if t is null or t.count = 0 then
141: a0 := JTF_VARCHAR2_TABLE_100();
142: a1 := JTF_VARCHAR2_TABLE_100();
143: a2 := JTF_VARCHAR2_TABLE_100();
144: a3 := JTF_VARCHAR2_TABLE_100();
145: a4 := JTF_NUMBER_TABLE();
138: ddindx binary_integer; indx binary_integer;
139: begin
140: if t is null or t.count = 0 then
141: a0 := JTF_VARCHAR2_TABLE_100();
142: a1 := JTF_VARCHAR2_TABLE_100();
143: a2 := JTF_VARCHAR2_TABLE_100();
144: a3 := JTF_VARCHAR2_TABLE_100();
145: a4 := JTF_NUMBER_TABLE();
146: a5 := JTF_VARCHAR2_TABLE_100();
139: begin
140: if t is null or t.count = 0 then
141: a0 := JTF_VARCHAR2_TABLE_100();
142: a1 := JTF_VARCHAR2_TABLE_100();
143: a2 := JTF_VARCHAR2_TABLE_100();
144: a3 := JTF_VARCHAR2_TABLE_100();
145: a4 := JTF_NUMBER_TABLE();
146: a5 := JTF_VARCHAR2_TABLE_100();
147: a6 := JTF_DATE_TABLE();
140: if t is null or t.count = 0 then
141: a0 := JTF_VARCHAR2_TABLE_100();
142: a1 := JTF_VARCHAR2_TABLE_100();
143: a2 := JTF_VARCHAR2_TABLE_100();
144: a3 := JTF_VARCHAR2_TABLE_100();
145: a4 := JTF_NUMBER_TABLE();
146: a5 := JTF_VARCHAR2_TABLE_100();
147: a6 := JTF_DATE_TABLE();
148: a7 := JTF_DATE_TABLE();
142: a1 := JTF_VARCHAR2_TABLE_100();
143: a2 := JTF_VARCHAR2_TABLE_100();
144: a3 := JTF_VARCHAR2_TABLE_100();
145: a4 := JTF_NUMBER_TABLE();
146: a5 := JTF_VARCHAR2_TABLE_100();
147: a6 := JTF_DATE_TABLE();
148: a7 := JTF_DATE_TABLE();
149: a8 := JTF_DATE_TABLE();
150: a9 := JTF_VARCHAR2_TABLE_100();
146: a5 := JTF_VARCHAR2_TABLE_100();
147: a6 := JTF_DATE_TABLE();
148: a7 := JTF_DATE_TABLE();
149: a8 := JTF_DATE_TABLE();
150: a9 := JTF_VARCHAR2_TABLE_100();
151: a10 := JTF_VARCHAR2_TABLE_100();
152: a11 := JTF_VARCHAR2_TABLE_100();
153: a12 := JTF_DATE_TABLE();
154: a13 := JTF_VARCHAR2_TABLE_100();
147: a6 := JTF_DATE_TABLE();
148: a7 := JTF_DATE_TABLE();
149: a8 := JTF_DATE_TABLE();
150: a9 := JTF_VARCHAR2_TABLE_100();
151: a10 := JTF_VARCHAR2_TABLE_100();
152: a11 := JTF_VARCHAR2_TABLE_100();
153: a12 := JTF_DATE_TABLE();
154: a13 := JTF_VARCHAR2_TABLE_100();
155: a14 := JTF_VARCHAR2_TABLE_100();
148: a7 := JTF_DATE_TABLE();
149: a8 := JTF_DATE_TABLE();
150: a9 := JTF_VARCHAR2_TABLE_100();
151: a10 := JTF_VARCHAR2_TABLE_100();
152: a11 := JTF_VARCHAR2_TABLE_100();
153: a12 := JTF_DATE_TABLE();
154: a13 := JTF_VARCHAR2_TABLE_100();
155: a14 := JTF_VARCHAR2_TABLE_100();
156: a15 := JTF_VARCHAR2_TABLE_100();
150: a9 := JTF_VARCHAR2_TABLE_100();
151: a10 := JTF_VARCHAR2_TABLE_100();
152: a11 := JTF_VARCHAR2_TABLE_100();
153: a12 := JTF_DATE_TABLE();
154: a13 := JTF_VARCHAR2_TABLE_100();
155: a14 := JTF_VARCHAR2_TABLE_100();
156: a15 := JTF_VARCHAR2_TABLE_100();
157: a16 := JTF_NUMBER_TABLE();
158: a17 := JTF_VARCHAR2_TABLE_100();
151: a10 := JTF_VARCHAR2_TABLE_100();
152: a11 := JTF_VARCHAR2_TABLE_100();
153: a12 := JTF_DATE_TABLE();
154: a13 := JTF_VARCHAR2_TABLE_100();
155: a14 := JTF_VARCHAR2_TABLE_100();
156: a15 := JTF_VARCHAR2_TABLE_100();
157: a16 := JTF_NUMBER_TABLE();
158: a17 := JTF_VARCHAR2_TABLE_100();
159: a18 := JTF_DATE_TABLE();
152: a11 := JTF_VARCHAR2_TABLE_100();
153: a12 := JTF_DATE_TABLE();
154: a13 := JTF_VARCHAR2_TABLE_100();
155: a14 := JTF_VARCHAR2_TABLE_100();
156: a15 := JTF_VARCHAR2_TABLE_100();
157: a16 := JTF_NUMBER_TABLE();
158: a17 := JTF_VARCHAR2_TABLE_100();
159: a18 := JTF_DATE_TABLE();
160: a19 := JTF_VARCHAR2_TABLE_100();
154: a13 := JTF_VARCHAR2_TABLE_100();
155: a14 := JTF_VARCHAR2_TABLE_100();
156: a15 := JTF_VARCHAR2_TABLE_100();
157: a16 := JTF_NUMBER_TABLE();
158: a17 := JTF_VARCHAR2_TABLE_100();
159: a18 := JTF_DATE_TABLE();
160: a19 := JTF_VARCHAR2_TABLE_100();
161: a20 := JTF_VARCHAR2_TABLE_100();
162: a21 := JTF_NUMBER_TABLE();
156: a15 := JTF_VARCHAR2_TABLE_100();
157: a16 := JTF_NUMBER_TABLE();
158: a17 := JTF_VARCHAR2_TABLE_100();
159: a18 := JTF_DATE_TABLE();
160: a19 := JTF_VARCHAR2_TABLE_100();
161: a20 := JTF_VARCHAR2_TABLE_100();
162: a21 := JTF_NUMBER_TABLE();
163: a22 := JTF_NUMBER_TABLE();
164: a23 := JTF_NUMBER_TABLE();
157: a16 := JTF_NUMBER_TABLE();
158: a17 := JTF_VARCHAR2_TABLE_100();
159: a18 := JTF_DATE_TABLE();
160: a19 := JTF_VARCHAR2_TABLE_100();
161: a20 := JTF_VARCHAR2_TABLE_100();
162: a21 := JTF_NUMBER_TABLE();
163: a22 := JTF_NUMBER_TABLE();
164: a23 := JTF_NUMBER_TABLE();
165: a24 := JTF_VARCHAR2_TABLE_100();
161: a20 := JTF_VARCHAR2_TABLE_100();
162: a21 := JTF_NUMBER_TABLE();
163: a22 := JTF_NUMBER_TABLE();
164: a23 := JTF_NUMBER_TABLE();
165: a24 := JTF_VARCHAR2_TABLE_100();
166: a25 := JTF_NUMBER_TABLE();
167: a26 := JTF_VARCHAR2_TABLE_4000();
168: a27 := JTF_VARCHAR2_TABLE_100();
169: a28 := JTF_VARCHAR2_TABLE_200();
164: a23 := JTF_NUMBER_TABLE();
165: a24 := JTF_VARCHAR2_TABLE_100();
166: a25 := JTF_NUMBER_TABLE();
167: a26 := JTF_VARCHAR2_TABLE_4000();
168: a27 := JTF_VARCHAR2_TABLE_100();
169: a28 := JTF_VARCHAR2_TABLE_200();
170: a29 := JTF_NUMBER_TABLE();
171: a30 := JTF_NUMBER_TABLE();
172: a31 := JTF_VARCHAR2_TABLE_100();
168: a27 := JTF_VARCHAR2_TABLE_100();
169: a28 := JTF_VARCHAR2_TABLE_200();
170: a29 := JTF_NUMBER_TABLE();
171: a30 := JTF_NUMBER_TABLE();
172: a31 := JTF_VARCHAR2_TABLE_100();
173: a32 := JTF_VARCHAR2_TABLE_100();
174: a33 := JTF_VARCHAR2_TABLE_100();
175: a34 := JTF_VARCHAR2_TABLE_100();
176: a35 := JTF_NUMBER_TABLE();
169: a28 := JTF_VARCHAR2_TABLE_200();
170: a29 := JTF_NUMBER_TABLE();
171: a30 := JTF_NUMBER_TABLE();
172: a31 := JTF_VARCHAR2_TABLE_100();
173: a32 := JTF_VARCHAR2_TABLE_100();
174: a33 := JTF_VARCHAR2_TABLE_100();
175: a34 := JTF_VARCHAR2_TABLE_100();
176: a35 := JTF_NUMBER_TABLE();
177: a36 := JTF_VARCHAR2_TABLE_100();
170: a29 := JTF_NUMBER_TABLE();
171: a30 := JTF_NUMBER_TABLE();
172: a31 := JTF_VARCHAR2_TABLE_100();
173: a32 := JTF_VARCHAR2_TABLE_100();
174: a33 := JTF_VARCHAR2_TABLE_100();
175: a34 := JTF_VARCHAR2_TABLE_100();
176: a35 := JTF_NUMBER_TABLE();
177: a36 := JTF_VARCHAR2_TABLE_100();
178: a37 := JTF_VARCHAR2_TABLE_100();
171: a30 := JTF_NUMBER_TABLE();
172: a31 := JTF_VARCHAR2_TABLE_100();
173: a32 := JTF_VARCHAR2_TABLE_100();
174: a33 := JTF_VARCHAR2_TABLE_100();
175: a34 := JTF_VARCHAR2_TABLE_100();
176: a35 := JTF_NUMBER_TABLE();
177: a36 := JTF_VARCHAR2_TABLE_100();
178: a37 := JTF_VARCHAR2_TABLE_100();
179: a38 := JTF_NUMBER_TABLE();
173: a32 := JTF_VARCHAR2_TABLE_100();
174: a33 := JTF_VARCHAR2_TABLE_100();
175: a34 := JTF_VARCHAR2_TABLE_100();
176: a35 := JTF_NUMBER_TABLE();
177: a36 := JTF_VARCHAR2_TABLE_100();
178: a37 := JTF_VARCHAR2_TABLE_100();
179: a38 := JTF_NUMBER_TABLE();
180: else
181: a0 := JTF_VARCHAR2_TABLE_100();
174: a33 := JTF_VARCHAR2_TABLE_100();
175: a34 := JTF_VARCHAR2_TABLE_100();
176: a35 := JTF_NUMBER_TABLE();
177: a36 := JTF_VARCHAR2_TABLE_100();
178: a37 := JTF_VARCHAR2_TABLE_100();
179: a38 := JTF_NUMBER_TABLE();
180: else
181: a0 := JTF_VARCHAR2_TABLE_100();
182: a1 := JTF_VARCHAR2_TABLE_100();
177: a36 := JTF_VARCHAR2_TABLE_100();
178: a37 := JTF_VARCHAR2_TABLE_100();
179: a38 := JTF_NUMBER_TABLE();
180: else
181: a0 := JTF_VARCHAR2_TABLE_100();
182: a1 := JTF_VARCHAR2_TABLE_100();
183: a2 := JTF_VARCHAR2_TABLE_100();
184: a3 := JTF_VARCHAR2_TABLE_100();
185: a4 := JTF_NUMBER_TABLE();
178: a37 := JTF_VARCHAR2_TABLE_100();
179: a38 := JTF_NUMBER_TABLE();
180: else
181: a0 := JTF_VARCHAR2_TABLE_100();
182: a1 := JTF_VARCHAR2_TABLE_100();
183: a2 := JTF_VARCHAR2_TABLE_100();
184: a3 := JTF_VARCHAR2_TABLE_100();
185: a4 := JTF_NUMBER_TABLE();
186: a5 := JTF_VARCHAR2_TABLE_100();
179: a38 := JTF_NUMBER_TABLE();
180: else
181: a0 := JTF_VARCHAR2_TABLE_100();
182: a1 := JTF_VARCHAR2_TABLE_100();
183: a2 := JTF_VARCHAR2_TABLE_100();
184: a3 := JTF_VARCHAR2_TABLE_100();
185: a4 := JTF_NUMBER_TABLE();
186: a5 := JTF_VARCHAR2_TABLE_100();
187: a6 := JTF_DATE_TABLE();
180: else
181: a0 := JTF_VARCHAR2_TABLE_100();
182: a1 := JTF_VARCHAR2_TABLE_100();
183: a2 := JTF_VARCHAR2_TABLE_100();
184: a3 := JTF_VARCHAR2_TABLE_100();
185: a4 := JTF_NUMBER_TABLE();
186: a5 := JTF_VARCHAR2_TABLE_100();
187: a6 := JTF_DATE_TABLE();
188: a7 := JTF_DATE_TABLE();
182: a1 := JTF_VARCHAR2_TABLE_100();
183: a2 := JTF_VARCHAR2_TABLE_100();
184: a3 := JTF_VARCHAR2_TABLE_100();
185: a4 := JTF_NUMBER_TABLE();
186: a5 := JTF_VARCHAR2_TABLE_100();
187: a6 := JTF_DATE_TABLE();
188: a7 := JTF_DATE_TABLE();
189: a8 := JTF_DATE_TABLE();
190: a9 := JTF_VARCHAR2_TABLE_100();
186: a5 := JTF_VARCHAR2_TABLE_100();
187: a6 := JTF_DATE_TABLE();
188: a7 := JTF_DATE_TABLE();
189: a8 := JTF_DATE_TABLE();
190: a9 := JTF_VARCHAR2_TABLE_100();
191: a10 := JTF_VARCHAR2_TABLE_100();
192: a11 := JTF_VARCHAR2_TABLE_100();
193: a12 := JTF_DATE_TABLE();
194: a13 := JTF_VARCHAR2_TABLE_100();
187: a6 := JTF_DATE_TABLE();
188: a7 := JTF_DATE_TABLE();
189: a8 := JTF_DATE_TABLE();
190: a9 := JTF_VARCHAR2_TABLE_100();
191: a10 := JTF_VARCHAR2_TABLE_100();
192: a11 := JTF_VARCHAR2_TABLE_100();
193: a12 := JTF_DATE_TABLE();
194: a13 := JTF_VARCHAR2_TABLE_100();
195: a14 := JTF_VARCHAR2_TABLE_100();
188: a7 := JTF_DATE_TABLE();
189: a8 := JTF_DATE_TABLE();
190: a9 := JTF_VARCHAR2_TABLE_100();
191: a10 := JTF_VARCHAR2_TABLE_100();
192: a11 := JTF_VARCHAR2_TABLE_100();
193: a12 := JTF_DATE_TABLE();
194: a13 := JTF_VARCHAR2_TABLE_100();
195: a14 := JTF_VARCHAR2_TABLE_100();
196: a15 := JTF_VARCHAR2_TABLE_100();
190: a9 := JTF_VARCHAR2_TABLE_100();
191: a10 := JTF_VARCHAR2_TABLE_100();
192: a11 := JTF_VARCHAR2_TABLE_100();
193: a12 := JTF_DATE_TABLE();
194: a13 := JTF_VARCHAR2_TABLE_100();
195: a14 := JTF_VARCHAR2_TABLE_100();
196: a15 := JTF_VARCHAR2_TABLE_100();
197: a16 := JTF_NUMBER_TABLE();
198: a17 := JTF_VARCHAR2_TABLE_100();
191: a10 := JTF_VARCHAR2_TABLE_100();
192: a11 := JTF_VARCHAR2_TABLE_100();
193: a12 := JTF_DATE_TABLE();
194: a13 := JTF_VARCHAR2_TABLE_100();
195: a14 := JTF_VARCHAR2_TABLE_100();
196: a15 := JTF_VARCHAR2_TABLE_100();
197: a16 := JTF_NUMBER_TABLE();
198: a17 := JTF_VARCHAR2_TABLE_100();
199: a18 := JTF_DATE_TABLE();
192: a11 := JTF_VARCHAR2_TABLE_100();
193: a12 := JTF_DATE_TABLE();
194: a13 := JTF_VARCHAR2_TABLE_100();
195: a14 := JTF_VARCHAR2_TABLE_100();
196: a15 := JTF_VARCHAR2_TABLE_100();
197: a16 := JTF_NUMBER_TABLE();
198: a17 := JTF_VARCHAR2_TABLE_100();
199: a18 := JTF_DATE_TABLE();
200: a19 := JTF_VARCHAR2_TABLE_100();
194: a13 := JTF_VARCHAR2_TABLE_100();
195: a14 := JTF_VARCHAR2_TABLE_100();
196: a15 := JTF_VARCHAR2_TABLE_100();
197: a16 := JTF_NUMBER_TABLE();
198: a17 := JTF_VARCHAR2_TABLE_100();
199: a18 := JTF_DATE_TABLE();
200: a19 := JTF_VARCHAR2_TABLE_100();
201: a20 := JTF_VARCHAR2_TABLE_100();
202: a21 := JTF_NUMBER_TABLE();
196: a15 := JTF_VARCHAR2_TABLE_100();
197: a16 := JTF_NUMBER_TABLE();
198: a17 := JTF_VARCHAR2_TABLE_100();
199: a18 := JTF_DATE_TABLE();
200: a19 := JTF_VARCHAR2_TABLE_100();
201: a20 := JTF_VARCHAR2_TABLE_100();
202: a21 := JTF_NUMBER_TABLE();
203: a22 := JTF_NUMBER_TABLE();
204: a23 := JTF_NUMBER_TABLE();
197: a16 := JTF_NUMBER_TABLE();
198: a17 := JTF_VARCHAR2_TABLE_100();
199: a18 := JTF_DATE_TABLE();
200: a19 := JTF_VARCHAR2_TABLE_100();
201: a20 := JTF_VARCHAR2_TABLE_100();
202: a21 := JTF_NUMBER_TABLE();
203: a22 := JTF_NUMBER_TABLE();
204: a23 := JTF_NUMBER_TABLE();
205: a24 := JTF_VARCHAR2_TABLE_100();
201: a20 := JTF_VARCHAR2_TABLE_100();
202: a21 := JTF_NUMBER_TABLE();
203: a22 := JTF_NUMBER_TABLE();
204: a23 := JTF_NUMBER_TABLE();
205: a24 := JTF_VARCHAR2_TABLE_100();
206: a25 := JTF_NUMBER_TABLE();
207: a26 := JTF_VARCHAR2_TABLE_4000();
208: a27 := JTF_VARCHAR2_TABLE_100();
209: a28 := JTF_VARCHAR2_TABLE_200();
204: a23 := JTF_NUMBER_TABLE();
205: a24 := JTF_VARCHAR2_TABLE_100();
206: a25 := JTF_NUMBER_TABLE();
207: a26 := JTF_VARCHAR2_TABLE_4000();
208: a27 := JTF_VARCHAR2_TABLE_100();
209: a28 := JTF_VARCHAR2_TABLE_200();
210: a29 := JTF_NUMBER_TABLE();
211: a30 := JTF_NUMBER_TABLE();
212: a31 := JTF_VARCHAR2_TABLE_100();
208: a27 := JTF_VARCHAR2_TABLE_100();
209: a28 := JTF_VARCHAR2_TABLE_200();
210: a29 := JTF_NUMBER_TABLE();
211: a30 := JTF_NUMBER_TABLE();
212: a31 := JTF_VARCHAR2_TABLE_100();
213: a32 := JTF_VARCHAR2_TABLE_100();
214: a33 := JTF_VARCHAR2_TABLE_100();
215: a34 := JTF_VARCHAR2_TABLE_100();
216: a35 := JTF_NUMBER_TABLE();
209: a28 := JTF_VARCHAR2_TABLE_200();
210: a29 := JTF_NUMBER_TABLE();
211: a30 := JTF_NUMBER_TABLE();
212: a31 := JTF_VARCHAR2_TABLE_100();
213: a32 := JTF_VARCHAR2_TABLE_100();
214: a33 := JTF_VARCHAR2_TABLE_100();
215: a34 := JTF_VARCHAR2_TABLE_100();
216: a35 := JTF_NUMBER_TABLE();
217: a36 := JTF_VARCHAR2_TABLE_100();
210: a29 := JTF_NUMBER_TABLE();
211: a30 := JTF_NUMBER_TABLE();
212: a31 := JTF_VARCHAR2_TABLE_100();
213: a32 := JTF_VARCHAR2_TABLE_100();
214: a33 := JTF_VARCHAR2_TABLE_100();
215: a34 := JTF_VARCHAR2_TABLE_100();
216: a35 := JTF_NUMBER_TABLE();
217: a36 := JTF_VARCHAR2_TABLE_100();
218: a37 := JTF_VARCHAR2_TABLE_100();
211: a30 := JTF_NUMBER_TABLE();
212: a31 := JTF_VARCHAR2_TABLE_100();
213: a32 := JTF_VARCHAR2_TABLE_100();
214: a33 := JTF_VARCHAR2_TABLE_100();
215: a34 := JTF_VARCHAR2_TABLE_100();
216: a35 := JTF_NUMBER_TABLE();
217: a36 := JTF_VARCHAR2_TABLE_100();
218: a37 := JTF_VARCHAR2_TABLE_100();
219: a38 := JTF_NUMBER_TABLE();
213: a32 := JTF_VARCHAR2_TABLE_100();
214: a33 := JTF_VARCHAR2_TABLE_100();
215: a34 := JTF_VARCHAR2_TABLE_100();
216: a35 := JTF_NUMBER_TABLE();
217: a36 := JTF_VARCHAR2_TABLE_100();
218: a37 := JTF_VARCHAR2_TABLE_100();
219: a38 := JTF_NUMBER_TABLE();
220: if t.count > 0 then
221: a0.extend(t.count);
214: a33 := JTF_VARCHAR2_TABLE_100();
215: a34 := JTF_VARCHAR2_TABLE_100();
216: a35 := JTF_NUMBER_TABLE();
217: a36 := JTF_VARCHAR2_TABLE_100();
218: a37 := JTF_VARCHAR2_TABLE_100();
219: a38 := JTF_NUMBER_TABLE();
220: if t.count > 0 then
221: a0.extend(t.count);
222: a1.extend(t.count);
391: , p8_a28 VARCHAR2
392: , p8_a29 VARCHAR2
393: , p8_a30 VARCHAR2
394: , p8_a31 NUMBER
395: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
396: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
397: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
398: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
399: , p9_a4 out nocopy JTF_NUMBER_TABLE
392: , p8_a29 VARCHAR2
393: , p8_a30 VARCHAR2
394: , p8_a31 NUMBER
395: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
396: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
397: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
398: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
399: , p9_a4 out nocopy JTF_NUMBER_TABLE
400: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
393: , p8_a30 VARCHAR2
394: , p8_a31 NUMBER
395: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
396: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
397: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
398: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
399: , p9_a4 out nocopy JTF_NUMBER_TABLE
400: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
401: , p9_a6 out nocopy JTF_DATE_TABLE
394: , p8_a31 NUMBER
395: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
396: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
397: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
398: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
399: , p9_a4 out nocopy JTF_NUMBER_TABLE
400: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
401: , p9_a6 out nocopy JTF_DATE_TABLE
402: , p9_a7 out nocopy JTF_DATE_TABLE
396: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
397: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
398: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
399: , p9_a4 out nocopy JTF_NUMBER_TABLE
400: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
401: , p9_a6 out nocopy JTF_DATE_TABLE
402: , p9_a7 out nocopy JTF_DATE_TABLE
403: , p9_a8 out nocopy JTF_DATE_TABLE
404: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_100
400: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
401: , p9_a6 out nocopy JTF_DATE_TABLE
402: , p9_a7 out nocopy JTF_DATE_TABLE
403: , p9_a8 out nocopy JTF_DATE_TABLE
404: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_100
405: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
406: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
407: , p9_a12 out nocopy JTF_DATE_TABLE
408: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_100
401: , p9_a6 out nocopy JTF_DATE_TABLE
402: , p9_a7 out nocopy JTF_DATE_TABLE
403: , p9_a8 out nocopy JTF_DATE_TABLE
404: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_100
405: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
406: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
407: , p9_a12 out nocopy JTF_DATE_TABLE
408: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_100
409: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_100
402: , p9_a7 out nocopy JTF_DATE_TABLE
403: , p9_a8 out nocopy JTF_DATE_TABLE
404: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_100
405: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
406: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
407: , p9_a12 out nocopy JTF_DATE_TABLE
408: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_100
409: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_100
410: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
404: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_100
405: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
406: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
407: , p9_a12 out nocopy JTF_DATE_TABLE
408: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_100
409: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_100
410: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
411: , p9_a16 out nocopy JTF_NUMBER_TABLE
412: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
405: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
406: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
407: , p9_a12 out nocopy JTF_DATE_TABLE
408: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_100
409: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_100
410: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
411: , p9_a16 out nocopy JTF_NUMBER_TABLE
412: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
413: , p9_a18 out nocopy JTF_DATE_TABLE
406: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
407: , p9_a12 out nocopy JTF_DATE_TABLE
408: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_100
409: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_100
410: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
411: , p9_a16 out nocopy JTF_NUMBER_TABLE
412: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
413: , p9_a18 out nocopy JTF_DATE_TABLE
414: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
408: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_100
409: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_100
410: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
411: , p9_a16 out nocopy JTF_NUMBER_TABLE
412: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
413: , p9_a18 out nocopy JTF_DATE_TABLE
414: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
415: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
416: , p9_a21 out nocopy JTF_NUMBER_TABLE
410: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
411: , p9_a16 out nocopy JTF_NUMBER_TABLE
412: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
413: , p9_a18 out nocopy JTF_DATE_TABLE
414: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
415: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
416: , p9_a21 out nocopy JTF_NUMBER_TABLE
417: , p9_a22 out nocopy JTF_NUMBER_TABLE
418: , p9_a23 out nocopy JTF_NUMBER_TABLE
411: , p9_a16 out nocopy JTF_NUMBER_TABLE
412: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
413: , p9_a18 out nocopy JTF_DATE_TABLE
414: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
415: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
416: , p9_a21 out nocopy JTF_NUMBER_TABLE
417: , p9_a22 out nocopy JTF_NUMBER_TABLE
418: , p9_a23 out nocopy JTF_NUMBER_TABLE
419: , p9_a24 out nocopy JTF_VARCHAR2_TABLE_100
415: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
416: , p9_a21 out nocopy JTF_NUMBER_TABLE
417: , p9_a22 out nocopy JTF_NUMBER_TABLE
418: , p9_a23 out nocopy JTF_NUMBER_TABLE
419: , p9_a24 out nocopy JTF_VARCHAR2_TABLE_100
420: , p9_a25 out nocopy JTF_NUMBER_TABLE
421: , p9_a26 out nocopy JTF_VARCHAR2_TABLE_4000
422: , p9_a27 out nocopy JTF_VARCHAR2_TABLE_100
423: , p9_a28 out nocopy JTF_VARCHAR2_TABLE_200
418: , p9_a23 out nocopy JTF_NUMBER_TABLE
419: , p9_a24 out nocopy JTF_VARCHAR2_TABLE_100
420: , p9_a25 out nocopy JTF_NUMBER_TABLE
421: , p9_a26 out nocopy JTF_VARCHAR2_TABLE_4000
422: , p9_a27 out nocopy JTF_VARCHAR2_TABLE_100
423: , p9_a28 out nocopy JTF_VARCHAR2_TABLE_200
424: , p9_a29 out nocopy JTF_NUMBER_TABLE
425: , p9_a30 out nocopy JTF_NUMBER_TABLE
426: , p9_a31 out nocopy JTF_VARCHAR2_TABLE_100
422: , p9_a27 out nocopy JTF_VARCHAR2_TABLE_100
423: , p9_a28 out nocopy JTF_VARCHAR2_TABLE_200
424: , p9_a29 out nocopy JTF_NUMBER_TABLE
425: , p9_a30 out nocopy JTF_NUMBER_TABLE
426: , p9_a31 out nocopy JTF_VARCHAR2_TABLE_100
427: , p9_a32 out nocopy JTF_VARCHAR2_TABLE_100
428: , p9_a33 out nocopy JTF_VARCHAR2_TABLE_100
429: , p9_a34 out nocopy JTF_VARCHAR2_TABLE_100
430: , p9_a35 out nocopy JTF_NUMBER_TABLE
423: , p9_a28 out nocopy JTF_VARCHAR2_TABLE_200
424: , p9_a29 out nocopy JTF_NUMBER_TABLE
425: , p9_a30 out nocopy JTF_NUMBER_TABLE
426: , p9_a31 out nocopy JTF_VARCHAR2_TABLE_100
427: , p9_a32 out nocopy JTF_VARCHAR2_TABLE_100
428: , p9_a33 out nocopy JTF_VARCHAR2_TABLE_100
429: , p9_a34 out nocopy JTF_VARCHAR2_TABLE_100
430: , p9_a35 out nocopy JTF_NUMBER_TABLE
431: , p9_a36 out nocopy JTF_VARCHAR2_TABLE_100
424: , p9_a29 out nocopy JTF_NUMBER_TABLE
425: , p9_a30 out nocopy JTF_NUMBER_TABLE
426: , p9_a31 out nocopy JTF_VARCHAR2_TABLE_100
427: , p9_a32 out nocopy JTF_VARCHAR2_TABLE_100
428: , p9_a33 out nocopy JTF_VARCHAR2_TABLE_100
429: , p9_a34 out nocopy JTF_VARCHAR2_TABLE_100
430: , p9_a35 out nocopy JTF_NUMBER_TABLE
431: , p9_a36 out nocopy JTF_VARCHAR2_TABLE_100
432: , p9_a37 out nocopy JTF_VARCHAR2_TABLE_100
425: , p9_a30 out nocopy JTF_NUMBER_TABLE
426: , p9_a31 out nocopy JTF_VARCHAR2_TABLE_100
427: , p9_a32 out nocopy JTF_VARCHAR2_TABLE_100
428: , p9_a33 out nocopy JTF_VARCHAR2_TABLE_100
429: , p9_a34 out nocopy JTF_VARCHAR2_TABLE_100
430: , p9_a35 out nocopy JTF_NUMBER_TABLE
431: , p9_a36 out nocopy JTF_VARCHAR2_TABLE_100
432: , p9_a37 out nocopy JTF_VARCHAR2_TABLE_100
433: , p9_a38 out nocopy JTF_NUMBER_TABLE
427: , p9_a32 out nocopy JTF_VARCHAR2_TABLE_100
428: , p9_a33 out nocopy JTF_VARCHAR2_TABLE_100
429: , p9_a34 out nocopy JTF_VARCHAR2_TABLE_100
430: , p9_a35 out nocopy JTF_NUMBER_TABLE
431: , p9_a36 out nocopy JTF_VARCHAR2_TABLE_100
432: , p9_a37 out nocopy JTF_VARCHAR2_TABLE_100
433: , p9_a38 out nocopy JTF_NUMBER_TABLE
434: , x_results_count out nocopy NUMBER
435: , x_return_status out nocopy VARCHAR2
428: , p9_a33 out nocopy JTF_VARCHAR2_TABLE_100
429: , p9_a34 out nocopy JTF_VARCHAR2_TABLE_100
430: , p9_a35 out nocopy JTF_NUMBER_TABLE
431: , p9_a36 out nocopy JTF_VARCHAR2_TABLE_100
432: , p9_a37 out nocopy JTF_VARCHAR2_TABLE_100
433: , p9_a38 out nocopy JTF_NUMBER_TABLE
434: , x_results_count out nocopy NUMBER
435: , x_return_status out nocopy VARCHAR2
436: , x_msg_count out nocopy NUMBER