12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_pp_materials_pvt.req_material_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_pp_materials_pvt.req_material_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_DATE_TABLE
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_pp_materials_pvt.req_material_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_DATE_TABLE
22: , a6 JTF_NUMBER_TABLE
16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_pp_materials_pvt.req_material_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_DATE_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_DATE_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_DATE_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_DATE_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_DATE_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_DATE_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_VARCHAR2_TABLE_200
21: , a5 JTF_DATE_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_DATE_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_VARCHAR2_TABLE_200
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_DATE_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_VARCHAR2_TABLE_200
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_300
24: , a8 JTF_DATE_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_VARCHAR2_TABLE_200
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_300
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
27: , a11 JTF_VARCHAR2_TABLE_200
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_300
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_DATE_TABLE
34: , a18 JTF_VARCHAR2_TABLE_100
35: , a19 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_300
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_DATE_TABLE
34: , a18 JTF_VARCHAR2_TABLE_100
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_DATE_TABLE
34: , a18 JTF_VARCHAR2_TABLE_100
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_NUMBER_TABLE
37: , a21 JTF_VARCHAR2_TABLE_100
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_NUMBER_TABLE
40: , a24 JTF_NUMBER_TABLE
34: , a18 JTF_VARCHAR2_TABLE_100
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_NUMBER_TABLE
37: , a21 JTF_VARCHAR2_TABLE_100
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_NUMBER_TABLE
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_NUMBER_TABLE
42: , a26 JTF_NUMBER_TABLE
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_NUMBER_TABLE
37: , a21 JTF_VARCHAR2_TABLE_100
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_NUMBER_TABLE
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_NUMBER_TABLE
42: , a26 JTF_NUMBER_TABLE
43: , a27 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_NUMBER_TABLE
37: , a21 JTF_VARCHAR2_TABLE_100
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_NUMBER_TABLE
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_NUMBER_TABLE
42: , a26 JTF_NUMBER_TABLE
43: , a27 JTF_VARCHAR2_TABLE_100
44: , a28 JTF_NUMBER_TABLE
37: , a21 JTF_VARCHAR2_TABLE_100
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_NUMBER_TABLE
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_NUMBER_TABLE
42: , a26 JTF_NUMBER_TABLE
43: , a27 JTF_VARCHAR2_TABLE_100
44: , a28 JTF_NUMBER_TABLE
45: , a29 JTF_NUMBER_TABLE
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_NUMBER_TABLE
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_NUMBER_TABLE
42: , a26 JTF_NUMBER_TABLE
43: , a27 JTF_VARCHAR2_TABLE_100
44: , a28 JTF_NUMBER_TABLE
45: , a29 JTF_NUMBER_TABLE
46: , a30 JTF_NUMBER_TABLE
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_NUMBER_TABLE
42: , a26 JTF_NUMBER_TABLE
43: , a27 JTF_VARCHAR2_TABLE_100
44: , a28 JTF_NUMBER_TABLE
45: , a29 JTF_NUMBER_TABLE
46: , a30 JTF_NUMBER_TABLE
47: , a31 JTF_NUMBER_TABLE
48: , a32 JTF_VARCHAR2_TABLE_100
41: , a25 JTF_NUMBER_TABLE
42: , a26 JTF_NUMBER_TABLE
43: , a27 JTF_VARCHAR2_TABLE_100
44: , a28 JTF_NUMBER_TABLE
45: , a29 JTF_NUMBER_TABLE
46: , a30 JTF_NUMBER_TABLE
47: , a31 JTF_NUMBER_TABLE
48: , a32 JTF_VARCHAR2_TABLE_100
49: , a33 JTF_NUMBER_TABLE
42: , a26 JTF_NUMBER_TABLE
43: , a27 JTF_VARCHAR2_TABLE_100
44: , a28 JTF_NUMBER_TABLE
45: , a29 JTF_NUMBER_TABLE
46: , a30 JTF_NUMBER_TABLE
47: , a31 JTF_NUMBER_TABLE
48: , a32 JTF_VARCHAR2_TABLE_100
49: , a33 JTF_NUMBER_TABLE
50: , a34 JTF_NUMBER_TABLE
43: , a27 JTF_VARCHAR2_TABLE_100
44: , a28 JTF_NUMBER_TABLE
45: , a29 JTF_NUMBER_TABLE
46: , a30 JTF_NUMBER_TABLE
47: , a31 JTF_NUMBER_TABLE
48: , a32 JTF_VARCHAR2_TABLE_100
49: , a33 JTF_NUMBER_TABLE
50: , a34 JTF_NUMBER_TABLE
51: , a35 JTF_DATE_TABLE
45: , a29 JTF_NUMBER_TABLE
46: , a30 JTF_NUMBER_TABLE
47: , a31 JTF_NUMBER_TABLE
48: , a32 JTF_VARCHAR2_TABLE_100
49: , a33 JTF_NUMBER_TABLE
50: , a34 JTF_NUMBER_TABLE
51: , a35 JTF_DATE_TABLE
52: , a36 JTF_DATE_TABLE
53: , a37 JTF_VARCHAR2_TABLE_100
46: , a30 JTF_NUMBER_TABLE
47: , a31 JTF_NUMBER_TABLE
48: , a32 JTF_VARCHAR2_TABLE_100
49: , a33 JTF_NUMBER_TABLE
50: , a34 JTF_NUMBER_TABLE
51: , a35 JTF_DATE_TABLE
52: , a36 JTF_DATE_TABLE
53: , a37 JTF_VARCHAR2_TABLE_100
54: , a38 JTF_NUMBER_TABLE
50: , a34 JTF_NUMBER_TABLE
51: , a35 JTF_DATE_TABLE
52: , a36 JTF_DATE_TABLE
53: , a37 JTF_VARCHAR2_TABLE_100
54: , a38 JTF_NUMBER_TABLE
55: , a39 JTF_NUMBER_TABLE
56: , a40 JTF_NUMBER_TABLE
57: , a41 JTF_NUMBER_TABLE
58: , a42 JTF_VARCHAR2_TABLE_100
51: , a35 JTF_DATE_TABLE
52: , a36 JTF_DATE_TABLE
53: , a37 JTF_VARCHAR2_TABLE_100
54: , a38 JTF_NUMBER_TABLE
55: , a39 JTF_NUMBER_TABLE
56: , a40 JTF_NUMBER_TABLE
57: , a41 JTF_NUMBER_TABLE
58: , a42 JTF_VARCHAR2_TABLE_100
59: , a43 JTF_VARCHAR2_TABLE_100
52: , a36 JTF_DATE_TABLE
53: , a37 JTF_VARCHAR2_TABLE_100
54: , a38 JTF_NUMBER_TABLE
55: , a39 JTF_NUMBER_TABLE
56: , a40 JTF_NUMBER_TABLE
57: , a41 JTF_NUMBER_TABLE
58: , a42 JTF_VARCHAR2_TABLE_100
59: , a43 JTF_VARCHAR2_TABLE_100
60: , a44 JTF_VARCHAR2_TABLE_200
53: , a37 JTF_VARCHAR2_TABLE_100
54: , a38 JTF_NUMBER_TABLE
55: , a39 JTF_NUMBER_TABLE
56: , a40 JTF_NUMBER_TABLE
57: , a41 JTF_NUMBER_TABLE
58: , a42 JTF_VARCHAR2_TABLE_100
59: , a43 JTF_VARCHAR2_TABLE_100
60: , a44 JTF_VARCHAR2_TABLE_200
61: , a45 JTF_VARCHAR2_TABLE_200
71: , a55 JTF_VARCHAR2_TABLE_200
72: , a56 JTF_VARCHAR2_TABLE_200
73: , a57 JTF_VARCHAR2_TABLE_200
74: , a58 JTF_VARCHAR2_TABLE_200
75: , a59 JTF_NUMBER_TABLE
76: , a60 JTF_VARCHAR2_TABLE_3000
77: , a61 JTF_VARCHAR2_TABLE_100
78: , a62 JTF_VARCHAR2_TABLE_100
79: ) as
155: end loop;
156: end if;
157: end if;
158: end rosetta_table_copy_in_p2;
159: procedure rosetta_table_copy_out_p2(t ahl_pp_materials_pvt.req_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
160: , a1 out nocopy JTF_NUMBER_TABLE
161: , a2 out nocopy JTF_NUMBER_TABLE
162: , a3 out nocopy JTF_VARCHAR2_TABLE_100
163: , a4 out nocopy JTF_NUMBER_TABLE
156: end if;
157: end if;
158: end rosetta_table_copy_in_p2;
159: procedure rosetta_table_copy_out_p2(t ahl_pp_materials_pvt.req_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
160: , a1 out nocopy JTF_NUMBER_TABLE
161: , a2 out nocopy JTF_NUMBER_TABLE
162: , a3 out nocopy JTF_VARCHAR2_TABLE_100
163: , a4 out nocopy JTF_NUMBER_TABLE
164: , a5 out nocopy JTF_DATE_TABLE
157: end if;
158: end rosetta_table_copy_in_p2;
159: procedure rosetta_table_copy_out_p2(t ahl_pp_materials_pvt.req_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
160: , a1 out nocopy JTF_NUMBER_TABLE
161: , a2 out nocopy JTF_NUMBER_TABLE
162: , a3 out nocopy JTF_VARCHAR2_TABLE_100
163: , a4 out nocopy JTF_NUMBER_TABLE
164: , a5 out nocopy JTF_DATE_TABLE
165: , a6 out nocopy JTF_NUMBER_TABLE
159: procedure rosetta_table_copy_out_p2(t ahl_pp_materials_pvt.req_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
160: , a1 out nocopy JTF_NUMBER_TABLE
161: , a2 out nocopy JTF_NUMBER_TABLE
162: , a3 out nocopy JTF_VARCHAR2_TABLE_100
163: , a4 out nocopy JTF_NUMBER_TABLE
164: , a5 out nocopy JTF_DATE_TABLE
165: , a6 out nocopy JTF_NUMBER_TABLE
166: , a7 out nocopy JTF_NUMBER_TABLE
167: , a8 out nocopy JTF_DATE_TABLE
161: , a2 out nocopy JTF_NUMBER_TABLE
162: , a3 out nocopy JTF_VARCHAR2_TABLE_100
163: , a4 out nocopy JTF_NUMBER_TABLE
164: , a5 out nocopy JTF_DATE_TABLE
165: , a6 out nocopy JTF_NUMBER_TABLE
166: , a7 out nocopy JTF_NUMBER_TABLE
167: , a8 out nocopy JTF_DATE_TABLE
168: , a9 out nocopy JTF_NUMBER_TABLE
169: , a10 out nocopy JTF_NUMBER_TABLE
162: , a3 out nocopy JTF_VARCHAR2_TABLE_100
163: , a4 out nocopy JTF_NUMBER_TABLE
164: , a5 out nocopy JTF_DATE_TABLE
165: , a6 out nocopy JTF_NUMBER_TABLE
166: , a7 out nocopy JTF_NUMBER_TABLE
167: , a8 out nocopy JTF_DATE_TABLE
168: , a9 out nocopy JTF_NUMBER_TABLE
169: , a10 out nocopy JTF_NUMBER_TABLE
170: , a11 out nocopy JTF_VARCHAR2_TABLE_200
164: , a5 out nocopy JTF_DATE_TABLE
165: , a6 out nocopy JTF_NUMBER_TABLE
166: , a7 out nocopy JTF_NUMBER_TABLE
167: , a8 out nocopy JTF_DATE_TABLE
168: , a9 out nocopy JTF_NUMBER_TABLE
169: , a10 out nocopy JTF_NUMBER_TABLE
170: , a11 out nocopy JTF_VARCHAR2_TABLE_200
171: , a12 out nocopy JTF_NUMBER_TABLE
172: , a13 out nocopy JTF_VARCHAR2_TABLE_100
165: , a6 out nocopy JTF_NUMBER_TABLE
166: , a7 out nocopy JTF_NUMBER_TABLE
167: , a8 out nocopy JTF_DATE_TABLE
168: , a9 out nocopy JTF_NUMBER_TABLE
169: , a10 out nocopy JTF_NUMBER_TABLE
170: , a11 out nocopy JTF_VARCHAR2_TABLE_200
171: , a12 out nocopy JTF_NUMBER_TABLE
172: , a13 out nocopy JTF_VARCHAR2_TABLE_100
173: , a14 out nocopy JTF_VARCHAR2_TABLE_300
167: , a8 out nocopy JTF_DATE_TABLE
168: , a9 out nocopy JTF_NUMBER_TABLE
169: , a10 out nocopy JTF_NUMBER_TABLE
170: , a11 out nocopy JTF_VARCHAR2_TABLE_200
171: , a12 out nocopy JTF_NUMBER_TABLE
172: , a13 out nocopy JTF_VARCHAR2_TABLE_100
173: , a14 out nocopy JTF_VARCHAR2_TABLE_300
174: , a15 out nocopy JTF_NUMBER_TABLE
175: , a16 out nocopy JTF_NUMBER_TABLE
170: , a11 out nocopy JTF_VARCHAR2_TABLE_200
171: , a12 out nocopy JTF_NUMBER_TABLE
172: , a13 out nocopy JTF_VARCHAR2_TABLE_100
173: , a14 out nocopy JTF_VARCHAR2_TABLE_300
174: , a15 out nocopy JTF_NUMBER_TABLE
175: , a16 out nocopy JTF_NUMBER_TABLE
176: , a17 out nocopy JTF_DATE_TABLE
177: , a18 out nocopy JTF_VARCHAR2_TABLE_100
178: , a19 out nocopy JTF_VARCHAR2_TABLE_100
171: , a12 out nocopy JTF_NUMBER_TABLE
172: , a13 out nocopy JTF_VARCHAR2_TABLE_100
173: , a14 out nocopy JTF_VARCHAR2_TABLE_300
174: , a15 out nocopy JTF_NUMBER_TABLE
175: , a16 out nocopy JTF_NUMBER_TABLE
176: , a17 out nocopy JTF_DATE_TABLE
177: , a18 out nocopy JTF_VARCHAR2_TABLE_100
178: , a19 out nocopy JTF_VARCHAR2_TABLE_100
179: , a20 out nocopy JTF_NUMBER_TABLE
175: , a16 out nocopy JTF_NUMBER_TABLE
176: , a17 out nocopy JTF_DATE_TABLE
177: , a18 out nocopy JTF_VARCHAR2_TABLE_100
178: , a19 out nocopy JTF_VARCHAR2_TABLE_100
179: , a20 out nocopy JTF_NUMBER_TABLE
180: , a21 out nocopy JTF_VARCHAR2_TABLE_100
181: , a22 out nocopy JTF_NUMBER_TABLE
182: , a23 out nocopy JTF_NUMBER_TABLE
183: , a24 out nocopy JTF_NUMBER_TABLE
177: , a18 out nocopy JTF_VARCHAR2_TABLE_100
178: , a19 out nocopy JTF_VARCHAR2_TABLE_100
179: , a20 out nocopy JTF_NUMBER_TABLE
180: , a21 out nocopy JTF_VARCHAR2_TABLE_100
181: , a22 out nocopy JTF_NUMBER_TABLE
182: , a23 out nocopy JTF_NUMBER_TABLE
183: , a24 out nocopy JTF_NUMBER_TABLE
184: , a25 out nocopy JTF_NUMBER_TABLE
185: , a26 out nocopy JTF_NUMBER_TABLE
178: , a19 out nocopy JTF_VARCHAR2_TABLE_100
179: , a20 out nocopy JTF_NUMBER_TABLE
180: , a21 out nocopy JTF_VARCHAR2_TABLE_100
181: , a22 out nocopy JTF_NUMBER_TABLE
182: , a23 out nocopy JTF_NUMBER_TABLE
183: , a24 out nocopy JTF_NUMBER_TABLE
184: , a25 out nocopy JTF_NUMBER_TABLE
185: , a26 out nocopy JTF_NUMBER_TABLE
186: , a27 out nocopy JTF_VARCHAR2_TABLE_100
179: , a20 out nocopy JTF_NUMBER_TABLE
180: , a21 out nocopy JTF_VARCHAR2_TABLE_100
181: , a22 out nocopy JTF_NUMBER_TABLE
182: , a23 out nocopy JTF_NUMBER_TABLE
183: , a24 out nocopy JTF_NUMBER_TABLE
184: , a25 out nocopy JTF_NUMBER_TABLE
185: , a26 out nocopy JTF_NUMBER_TABLE
186: , a27 out nocopy JTF_VARCHAR2_TABLE_100
187: , a28 out nocopy JTF_NUMBER_TABLE
180: , a21 out nocopy JTF_VARCHAR2_TABLE_100
181: , a22 out nocopy JTF_NUMBER_TABLE
182: , a23 out nocopy JTF_NUMBER_TABLE
183: , a24 out nocopy JTF_NUMBER_TABLE
184: , a25 out nocopy JTF_NUMBER_TABLE
185: , a26 out nocopy JTF_NUMBER_TABLE
186: , a27 out nocopy JTF_VARCHAR2_TABLE_100
187: , a28 out nocopy JTF_NUMBER_TABLE
188: , a29 out nocopy JTF_NUMBER_TABLE
181: , a22 out nocopy JTF_NUMBER_TABLE
182: , a23 out nocopy JTF_NUMBER_TABLE
183: , a24 out nocopy JTF_NUMBER_TABLE
184: , a25 out nocopy JTF_NUMBER_TABLE
185: , a26 out nocopy JTF_NUMBER_TABLE
186: , a27 out nocopy JTF_VARCHAR2_TABLE_100
187: , a28 out nocopy JTF_NUMBER_TABLE
188: , a29 out nocopy JTF_NUMBER_TABLE
189: , a30 out nocopy JTF_NUMBER_TABLE
183: , a24 out nocopy JTF_NUMBER_TABLE
184: , a25 out nocopy JTF_NUMBER_TABLE
185: , a26 out nocopy JTF_NUMBER_TABLE
186: , a27 out nocopy JTF_VARCHAR2_TABLE_100
187: , a28 out nocopy JTF_NUMBER_TABLE
188: , a29 out nocopy JTF_NUMBER_TABLE
189: , a30 out nocopy JTF_NUMBER_TABLE
190: , a31 out nocopy JTF_NUMBER_TABLE
191: , a32 out nocopy JTF_VARCHAR2_TABLE_100
184: , a25 out nocopy JTF_NUMBER_TABLE
185: , a26 out nocopy JTF_NUMBER_TABLE
186: , a27 out nocopy JTF_VARCHAR2_TABLE_100
187: , a28 out nocopy JTF_NUMBER_TABLE
188: , a29 out nocopy JTF_NUMBER_TABLE
189: , a30 out nocopy JTF_NUMBER_TABLE
190: , a31 out nocopy JTF_NUMBER_TABLE
191: , a32 out nocopy JTF_VARCHAR2_TABLE_100
192: , a33 out nocopy JTF_NUMBER_TABLE
185: , a26 out nocopy JTF_NUMBER_TABLE
186: , a27 out nocopy JTF_VARCHAR2_TABLE_100
187: , a28 out nocopy JTF_NUMBER_TABLE
188: , a29 out nocopy JTF_NUMBER_TABLE
189: , a30 out nocopy JTF_NUMBER_TABLE
190: , a31 out nocopy JTF_NUMBER_TABLE
191: , a32 out nocopy JTF_VARCHAR2_TABLE_100
192: , a33 out nocopy JTF_NUMBER_TABLE
193: , a34 out nocopy JTF_NUMBER_TABLE
186: , a27 out nocopy JTF_VARCHAR2_TABLE_100
187: , a28 out nocopy JTF_NUMBER_TABLE
188: , a29 out nocopy JTF_NUMBER_TABLE
189: , a30 out nocopy JTF_NUMBER_TABLE
190: , a31 out nocopy JTF_NUMBER_TABLE
191: , a32 out nocopy JTF_VARCHAR2_TABLE_100
192: , a33 out nocopy JTF_NUMBER_TABLE
193: , a34 out nocopy JTF_NUMBER_TABLE
194: , a35 out nocopy JTF_DATE_TABLE
188: , a29 out nocopy JTF_NUMBER_TABLE
189: , a30 out nocopy JTF_NUMBER_TABLE
190: , a31 out nocopy JTF_NUMBER_TABLE
191: , a32 out nocopy JTF_VARCHAR2_TABLE_100
192: , a33 out nocopy JTF_NUMBER_TABLE
193: , a34 out nocopy JTF_NUMBER_TABLE
194: , a35 out nocopy JTF_DATE_TABLE
195: , a36 out nocopy JTF_DATE_TABLE
196: , a37 out nocopy JTF_VARCHAR2_TABLE_100
189: , a30 out nocopy JTF_NUMBER_TABLE
190: , a31 out nocopy JTF_NUMBER_TABLE
191: , a32 out nocopy JTF_VARCHAR2_TABLE_100
192: , a33 out nocopy JTF_NUMBER_TABLE
193: , a34 out nocopy JTF_NUMBER_TABLE
194: , a35 out nocopy JTF_DATE_TABLE
195: , a36 out nocopy JTF_DATE_TABLE
196: , a37 out nocopy JTF_VARCHAR2_TABLE_100
197: , a38 out nocopy JTF_NUMBER_TABLE
193: , a34 out nocopy JTF_NUMBER_TABLE
194: , a35 out nocopy JTF_DATE_TABLE
195: , a36 out nocopy JTF_DATE_TABLE
196: , a37 out nocopy JTF_VARCHAR2_TABLE_100
197: , a38 out nocopy JTF_NUMBER_TABLE
198: , a39 out nocopy JTF_NUMBER_TABLE
199: , a40 out nocopy JTF_NUMBER_TABLE
200: , a41 out nocopy JTF_NUMBER_TABLE
201: , a42 out nocopy JTF_VARCHAR2_TABLE_100
194: , a35 out nocopy JTF_DATE_TABLE
195: , a36 out nocopy JTF_DATE_TABLE
196: , a37 out nocopy JTF_VARCHAR2_TABLE_100
197: , a38 out nocopy JTF_NUMBER_TABLE
198: , a39 out nocopy JTF_NUMBER_TABLE
199: , a40 out nocopy JTF_NUMBER_TABLE
200: , a41 out nocopy JTF_NUMBER_TABLE
201: , a42 out nocopy JTF_VARCHAR2_TABLE_100
202: , a43 out nocopy JTF_VARCHAR2_TABLE_100
195: , a36 out nocopy JTF_DATE_TABLE
196: , a37 out nocopy JTF_VARCHAR2_TABLE_100
197: , a38 out nocopy JTF_NUMBER_TABLE
198: , a39 out nocopy JTF_NUMBER_TABLE
199: , a40 out nocopy JTF_NUMBER_TABLE
200: , a41 out nocopy JTF_NUMBER_TABLE
201: , a42 out nocopy JTF_VARCHAR2_TABLE_100
202: , a43 out nocopy JTF_VARCHAR2_TABLE_100
203: , a44 out nocopy JTF_VARCHAR2_TABLE_200
196: , a37 out nocopy JTF_VARCHAR2_TABLE_100
197: , a38 out nocopy JTF_NUMBER_TABLE
198: , a39 out nocopy JTF_NUMBER_TABLE
199: , a40 out nocopy JTF_NUMBER_TABLE
200: , a41 out nocopy JTF_NUMBER_TABLE
201: , a42 out nocopy JTF_VARCHAR2_TABLE_100
202: , a43 out nocopy JTF_VARCHAR2_TABLE_100
203: , a44 out nocopy JTF_VARCHAR2_TABLE_200
204: , a45 out nocopy JTF_VARCHAR2_TABLE_200
214: , a55 out nocopy JTF_VARCHAR2_TABLE_200
215: , a56 out nocopy JTF_VARCHAR2_TABLE_200
216: , a57 out nocopy JTF_VARCHAR2_TABLE_200
217: , a58 out nocopy JTF_VARCHAR2_TABLE_200
218: , a59 out nocopy JTF_NUMBER_TABLE
219: , a60 out nocopy JTF_VARCHAR2_TABLE_3000
220: , a61 out nocopy JTF_VARCHAR2_TABLE_100
221: , a62 out nocopy JTF_VARCHAR2_TABLE_100
222: ) as
222: ) as
223: ddindx binary_integer; indx binary_integer;
224: begin
225: if t is null or t.count = 0 then
226: a0 := JTF_NUMBER_TABLE();
227: a1 := JTF_NUMBER_TABLE();
228: a2 := JTF_NUMBER_TABLE();
229: a3 := JTF_VARCHAR2_TABLE_100();
230: a4 := JTF_NUMBER_TABLE();
223: ddindx binary_integer; indx binary_integer;
224: begin
225: if t is null or t.count = 0 then
226: a0 := JTF_NUMBER_TABLE();
227: a1 := JTF_NUMBER_TABLE();
228: a2 := JTF_NUMBER_TABLE();
229: a3 := JTF_VARCHAR2_TABLE_100();
230: a4 := JTF_NUMBER_TABLE();
231: a5 := JTF_DATE_TABLE();
224: begin
225: if t is null or t.count = 0 then
226: a0 := JTF_NUMBER_TABLE();
227: a1 := JTF_NUMBER_TABLE();
228: a2 := JTF_NUMBER_TABLE();
229: a3 := JTF_VARCHAR2_TABLE_100();
230: a4 := JTF_NUMBER_TABLE();
231: a5 := JTF_DATE_TABLE();
232: a6 := JTF_NUMBER_TABLE();
226: a0 := JTF_NUMBER_TABLE();
227: a1 := JTF_NUMBER_TABLE();
228: a2 := JTF_NUMBER_TABLE();
229: a3 := JTF_VARCHAR2_TABLE_100();
230: a4 := JTF_NUMBER_TABLE();
231: a5 := JTF_DATE_TABLE();
232: a6 := JTF_NUMBER_TABLE();
233: a7 := JTF_NUMBER_TABLE();
234: a8 := JTF_DATE_TABLE();
228: a2 := JTF_NUMBER_TABLE();
229: a3 := JTF_VARCHAR2_TABLE_100();
230: a4 := JTF_NUMBER_TABLE();
231: a5 := JTF_DATE_TABLE();
232: a6 := JTF_NUMBER_TABLE();
233: a7 := JTF_NUMBER_TABLE();
234: a8 := JTF_DATE_TABLE();
235: a9 := JTF_NUMBER_TABLE();
236: a10 := JTF_NUMBER_TABLE();
229: a3 := JTF_VARCHAR2_TABLE_100();
230: a4 := JTF_NUMBER_TABLE();
231: a5 := JTF_DATE_TABLE();
232: a6 := JTF_NUMBER_TABLE();
233: a7 := JTF_NUMBER_TABLE();
234: a8 := JTF_DATE_TABLE();
235: a9 := JTF_NUMBER_TABLE();
236: a10 := JTF_NUMBER_TABLE();
237: a11 := JTF_VARCHAR2_TABLE_200();
231: a5 := JTF_DATE_TABLE();
232: a6 := JTF_NUMBER_TABLE();
233: a7 := JTF_NUMBER_TABLE();
234: a8 := JTF_DATE_TABLE();
235: a9 := JTF_NUMBER_TABLE();
236: a10 := JTF_NUMBER_TABLE();
237: a11 := JTF_VARCHAR2_TABLE_200();
238: a12 := JTF_NUMBER_TABLE();
239: a13 := JTF_VARCHAR2_TABLE_100();
232: a6 := JTF_NUMBER_TABLE();
233: a7 := JTF_NUMBER_TABLE();
234: a8 := JTF_DATE_TABLE();
235: a9 := JTF_NUMBER_TABLE();
236: a10 := JTF_NUMBER_TABLE();
237: a11 := JTF_VARCHAR2_TABLE_200();
238: a12 := JTF_NUMBER_TABLE();
239: a13 := JTF_VARCHAR2_TABLE_100();
240: a14 := JTF_VARCHAR2_TABLE_300();
234: a8 := JTF_DATE_TABLE();
235: a9 := JTF_NUMBER_TABLE();
236: a10 := JTF_NUMBER_TABLE();
237: a11 := JTF_VARCHAR2_TABLE_200();
238: a12 := JTF_NUMBER_TABLE();
239: a13 := JTF_VARCHAR2_TABLE_100();
240: a14 := JTF_VARCHAR2_TABLE_300();
241: a15 := JTF_NUMBER_TABLE();
242: a16 := JTF_NUMBER_TABLE();
237: a11 := JTF_VARCHAR2_TABLE_200();
238: a12 := JTF_NUMBER_TABLE();
239: a13 := JTF_VARCHAR2_TABLE_100();
240: a14 := JTF_VARCHAR2_TABLE_300();
241: a15 := JTF_NUMBER_TABLE();
242: a16 := JTF_NUMBER_TABLE();
243: a17 := JTF_DATE_TABLE();
244: a18 := JTF_VARCHAR2_TABLE_100();
245: a19 := JTF_VARCHAR2_TABLE_100();
238: a12 := JTF_NUMBER_TABLE();
239: a13 := JTF_VARCHAR2_TABLE_100();
240: a14 := JTF_VARCHAR2_TABLE_300();
241: a15 := JTF_NUMBER_TABLE();
242: a16 := JTF_NUMBER_TABLE();
243: a17 := JTF_DATE_TABLE();
244: a18 := JTF_VARCHAR2_TABLE_100();
245: a19 := JTF_VARCHAR2_TABLE_100();
246: a20 := JTF_NUMBER_TABLE();
242: a16 := JTF_NUMBER_TABLE();
243: a17 := JTF_DATE_TABLE();
244: a18 := JTF_VARCHAR2_TABLE_100();
245: a19 := JTF_VARCHAR2_TABLE_100();
246: a20 := JTF_NUMBER_TABLE();
247: a21 := JTF_VARCHAR2_TABLE_100();
248: a22 := JTF_NUMBER_TABLE();
249: a23 := JTF_NUMBER_TABLE();
250: a24 := JTF_NUMBER_TABLE();
244: a18 := JTF_VARCHAR2_TABLE_100();
245: a19 := JTF_VARCHAR2_TABLE_100();
246: a20 := JTF_NUMBER_TABLE();
247: a21 := JTF_VARCHAR2_TABLE_100();
248: a22 := JTF_NUMBER_TABLE();
249: a23 := JTF_NUMBER_TABLE();
250: a24 := JTF_NUMBER_TABLE();
251: a25 := JTF_NUMBER_TABLE();
252: a26 := JTF_NUMBER_TABLE();
245: a19 := JTF_VARCHAR2_TABLE_100();
246: a20 := JTF_NUMBER_TABLE();
247: a21 := JTF_VARCHAR2_TABLE_100();
248: a22 := JTF_NUMBER_TABLE();
249: a23 := JTF_NUMBER_TABLE();
250: a24 := JTF_NUMBER_TABLE();
251: a25 := JTF_NUMBER_TABLE();
252: a26 := JTF_NUMBER_TABLE();
253: a27 := JTF_VARCHAR2_TABLE_100();
246: a20 := JTF_NUMBER_TABLE();
247: a21 := JTF_VARCHAR2_TABLE_100();
248: a22 := JTF_NUMBER_TABLE();
249: a23 := JTF_NUMBER_TABLE();
250: a24 := JTF_NUMBER_TABLE();
251: a25 := JTF_NUMBER_TABLE();
252: a26 := JTF_NUMBER_TABLE();
253: a27 := JTF_VARCHAR2_TABLE_100();
254: a28 := JTF_NUMBER_TABLE();
247: a21 := JTF_VARCHAR2_TABLE_100();
248: a22 := JTF_NUMBER_TABLE();
249: a23 := JTF_NUMBER_TABLE();
250: a24 := JTF_NUMBER_TABLE();
251: a25 := JTF_NUMBER_TABLE();
252: a26 := JTF_NUMBER_TABLE();
253: a27 := JTF_VARCHAR2_TABLE_100();
254: a28 := JTF_NUMBER_TABLE();
255: a29 := JTF_NUMBER_TABLE();
248: a22 := JTF_NUMBER_TABLE();
249: a23 := JTF_NUMBER_TABLE();
250: a24 := JTF_NUMBER_TABLE();
251: a25 := JTF_NUMBER_TABLE();
252: a26 := JTF_NUMBER_TABLE();
253: a27 := JTF_VARCHAR2_TABLE_100();
254: a28 := JTF_NUMBER_TABLE();
255: a29 := JTF_NUMBER_TABLE();
256: a30 := JTF_NUMBER_TABLE();
250: a24 := JTF_NUMBER_TABLE();
251: a25 := JTF_NUMBER_TABLE();
252: a26 := JTF_NUMBER_TABLE();
253: a27 := JTF_VARCHAR2_TABLE_100();
254: a28 := JTF_NUMBER_TABLE();
255: a29 := JTF_NUMBER_TABLE();
256: a30 := JTF_NUMBER_TABLE();
257: a31 := JTF_NUMBER_TABLE();
258: a32 := JTF_VARCHAR2_TABLE_100();
251: a25 := JTF_NUMBER_TABLE();
252: a26 := JTF_NUMBER_TABLE();
253: a27 := JTF_VARCHAR2_TABLE_100();
254: a28 := JTF_NUMBER_TABLE();
255: a29 := JTF_NUMBER_TABLE();
256: a30 := JTF_NUMBER_TABLE();
257: a31 := JTF_NUMBER_TABLE();
258: a32 := JTF_VARCHAR2_TABLE_100();
259: a33 := JTF_NUMBER_TABLE();
252: a26 := JTF_NUMBER_TABLE();
253: a27 := JTF_VARCHAR2_TABLE_100();
254: a28 := JTF_NUMBER_TABLE();
255: a29 := JTF_NUMBER_TABLE();
256: a30 := JTF_NUMBER_TABLE();
257: a31 := JTF_NUMBER_TABLE();
258: a32 := JTF_VARCHAR2_TABLE_100();
259: a33 := JTF_NUMBER_TABLE();
260: a34 := JTF_NUMBER_TABLE();
253: a27 := JTF_VARCHAR2_TABLE_100();
254: a28 := JTF_NUMBER_TABLE();
255: a29 := JTF_NUMBER_TABLE();
256: a30 := JTF_NUMBER_TABLE();
257: a31 := JTF_NUMBER_TABLE();
258: a32 := JTF_VARCHAR2_TABLE_100();
259: a33 := JTF_NUMBER_TABLE();
260: a34 := JTF_NUMBER_TABLE();
261: a35 := JTF_DATE_TABLE();
255: a29 := JTF_NUMBER_TABLE();
256: a30 := JTF_NUMBER_TABLE();
257: a31 := JTF_NUMBER_TABLE();
258: a32 := JTF_VARCHAR2_TABLE_100();
259: a33 := JTF_NUMBER_TABLE();
260: a34 := JTF_NUMBER_TABLE();
261: a35 := JTF_DATE_TABLE();
262: a36 := JTF_DATE_TABLE();
263: a37 := JTF_VARCHAR2_TABLE_100();
256: a30 := JTF_NUMBER_TABLE();
257: a31 := JTF_NUMBER_TABLE();
258: a32 := JTF_VARCHAR2_TABLE_100();
259: a33 := JTF_NUMBER_TABLE();
260: a34 := JTF_NUMBER_TABLE();
261: a35 := JTF_DATE_TABLE();
262: a36 := JTF_DATE_TABLE();
263: a37 := JTF_VARCHAR2_TABLE_100();
264: a38 := JTF_NUMBER_TABLE();
260: a34 := JTF_NUMBER_TABLE();
261: a35 := JTF_DATE_TABLE();
262: a36 := JTF_DATE_TABLE();
263: a37 := JTF_VARCHAR2_TABLE_100();
264: a38 := JTF_NUMBER_TABLE();
265: a39 := JTF_NUMBER_TABLE();
266: a40 := JTF_NUMBER_TABLE();
267: a41 := JTF_NUMBER_TABLE();
268: a42 := JTF_VARCHAR2_TABLE_100();
261: a35 := JTF_DATE_TABLE();
262: a36 := JTF_DATE_TABLE();
263: a37 := JTF_VARCHAR2_TABLE_100();
264: a38 := JTF_NUMBER_TABLE();
265: a39 := JTF_NUMBER_TABLE();
266: a40 := JTF_NUMBER_TABLE();
267: a41 := JTF_NUMBER_TABLE();
268: a42 := JTF_VARCHAR2_TABLE_100();
269: a43 := JTF_VARCHAR2_TABLE_100();
262: a36 := JTF_DATE_TABLE();
263: a37 := JTF_VARCHAR2_TABLE_100();
264: a38 := JTF_NUMBER_TABLE();
265: a39 := JTF_NUMBER_TABLE();
266: a40 := JTF_NUMBER_TABLE();
267: a41 := JTF_NUMBER_TABLE();
268: a42 := JTF_VARCHAR2_TABLE_100();
269: a43 := JTF_VARCHAR2_TABLE_100();
270: a44 := JTF_VARCHAR2_TABLE_200();
263: a37 := JTF_VARCHAR2_TABLE_100();
264: a38 := JTF_NUMBER_TABLE();
265: a39 := JTF_NUMBER_TABLE();
266: a40 := JTF_NUMBER_TABLE();
267: a41 := JTF_NUMBER_TABLE();
268: a42 := JTF_VARCHAR2_TABLE_100();
269: a43 := JTF_VARCHAR2_TABLE_100();
270: a44 := JTF_VARCHAR2_TABLE_200();
271: a45 := JTF_VARCHAR2_TABLE_200();
281: a55 := JTF_VARCHAR2_TABLE_200();
282: a56 := JTF_VARCHAR2_TABLE_200();
283: a57 := JTF_VARCHAR2_TABLE_200();
284: a58 := JTF_VARCHAR2_TABLE_200();
285: a59 := JTF_NUMBER_TABLE();
286: a60 := JTF_VARCHAR2_TABLE_3000();
287: a61 := JTF_VARCHAR2_TABLE_100();
288: a62 := JTF_VARCHAR2_TABLE_100();
289: else
286: a60 := JTF_VARCHAR2_TABLE_3000();
287: a61 := JTF_VARCHAR2_TABLE_100();
288: a62 := JTF_VARCHAR2_TABLE_100();
289: else
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_NUMBER_TABLE();
293: a3 := JTF_VARCHAR2_TABLE_100();
294: a4 := JTF_NUMBER_TABLE();
287: a61 := JTF_VARCHAR2_TABLE_100();
288: a62 := JTF_VARCHAR2_TABLE_100();
289: else
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_NUMBER_TABLE();
293: a3 := JTF_VARCHAR2_TABLE_100();
294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_DATE_TABLE();
288: a62 := JTF_VARCHAR2_TABLE_100();
289: else
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_NUMBER_TABLE();
293: a3 := JTF_VARCHAR2_TABLE_100();
294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_DATE_TABLE();
296: a6 := JTF_NUMBER_TABLE();
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_NUMBER_TABLE();
293: a3 := JTF_VARCHAR2_TABLE_100();
294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_DATE_TABLE();
296: a6 := JTF_NUMBER_TABLE();
297: a7 := JTF_NUMBER_TABLE();
298: a8 := JTF_DATE_TABLE();
292: a2 := JTF_NUMBER_TABLE();
293: a3 := JTF_VARCHAR2_TABLE_100();
294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_DATE_TABLE();
296: a6 := JTF_NUMBER_TABLE();
297: a7 := JTF_NUMBER_TABLE();
298: a8 := JTF_DATE_TABLE();
299: a9 := JTF_NUMBER_TABLE();
300: a10 := JTF_NUMBER_TABLE();
293: a3 := JTF_VARCHAR2_TABLE_100();
294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_DATE_TABLE();
296: a6 := JTF_NUMBER_TABLE();
297: a7 := JTF_NUMBER_TABLE();
298: a8 := JTF_DATE_TABLE();
299: a9 := JTF_NUMBER_TABLE();
300: a10 := JTF_NUMBER_TABLE();
301: a11 := JTF_VARCHAR2_TABLE_200();
295: a5 := JTF_DATE_TABLE();
296: a6 := JTF_NUMBER_TABLE();
297: a7 := JTF_NUMBER_TABLE();
298: a8 := JTF_DATE_TABLE();
299: a9 := JTF_NUMBER_TABLE();
300: a10 := JTF_NUMBER_TABLE();
301: a11 := JTF_VARCHAR2_TABLE_200();
302: a12 := JTF_NUMBER_TABLE();
303: a13 := JTF_VARCHAR2_TABLE_100();
296: a6 := JTF_NUMBER_TABLE();
297: a7 := JTF_NUMBER_TABLE();
298: a8 := JTF_DATE_TABLE();
299: a9 := JTF_NUMBER_TABLE();
300: a10 := JTF_NUMBER_TABLE();
301: a11 := JTF_VARCHAR2_TABLE_200();
302: a12 := JTF_NUMBER_TABLE();
303: a13 := JTF_VARCHAR2_TABLE_100();
304: a14 := JTF_VARCHAR2_TABLE_300();
298: a8 := JTF_DATE_TABLE();
299: a9 := JTF_NUMBER_TABLE();
300: a10 := JTF_NUMBER_TABLE();
301: a11 := JTF_VARCHAR2_TABLE_200();
302: a12 := JTF_NUMBER_TABLE();
303: a13 := JTF_VARCHAR2_TABLE_100();
304: a14 := JTF_VARCHAR2_TABLE_300();
305: a15 := JTF_NUMBER_TABLE();
306: a16 := JTF_NUMBER_TABLE();
301: a11 := JTF_VARCHAR2_TABLE_200();
302: a12 := JTF_NUMBER_TABLE();
303: a13 := JTF_VARCHAR2_TABLE_100();
304: a14 := JTF_VARCHAR2_TABLE_300();
305: a15 := JTF_NUMBER_TABLE();
306: a16 := JTF_NUMBER_TABLE();
307: a17 := JTF_DATE_TABLE();
308: a18 := JTF_VARCHAR2_TABLE_100();
309: a19 := JTF_VARCHAR2_TABLE_100();
302: a12 := JTF_NUMBER_TABLE();
303: a13 := JTF_VARCHAR2_TABLE_100();
304: a14 := JTF_VARCHAR2_TABLE_300();
305: a15 := JTF_NUMBER_TABLE();
306: a16 := JTF_NUMBER_TABLE();
307: a17 := JTF_DATE_TABLE();
308: a18 := JTF_VARCHAR2_TABLE_100();
309: a19 := JTF_VARCHAR2_TABLE_100();
310: a20 := JTF_NUMBER_TABLE();
306: a16 := JTF_NUMBER_TABLE();
307: a17 := JTF_DATE_TABLE();
308: a18 := JTF_VARCHAR2_TABLE_100();
309: a19 := JTF_VARCHAR2_TABLE_100();
310: a20 := JTF_NUMBER_TABLE();
311: a21 := JTF_VARCHAR2_TABLE_100();
312: a22 := JTF_NUMBER_TABLE();
313: a23 := JTF_NUMBER_TABLE();
314: a24 := JTF_NUMBER_TABLE();
308: a18 := JTF_VARCHAR2_TABLE_100();
309: a19 := JTF_VARCHAR2_TABLE_100();
310: a20 := JTF_NUMBER_TABLE();
311: a21 := JTF_VARCHAR2_TABLE_100();
312: a22 := JTF_NUMBER_TABLE();
313: a23 := JTF_NUMBER_TABLE();
314: a24 := JTF_NUMBER_TABLE();
315: a25 := JTF_NUMBER_TABLE();
316: a26 := JTF_NUMBER_TABLE();
309: a19 := JTF_VARCHAR2_TABLE_100();
310: a20 := JTF_NUMBER_TABLE();
311: a21 := JTF_VARCHAR2_TABLE_100();
312: a22 := JTF_NUMBER_TABLE();
313: a23 := JTF_NUMBER_TABLE();
314: a24 := JTF_NUMBER_TABLE();
315: a25 := JTF_NUMBER_TABLE();
316: a26 := JTF_NUMBER_TABLE();
317: a27 := JTF_VARCHAR2_TABLE_100();
310: a20 := JTF_NUMBER_TABLE();
311: a21 := JTF_VARCHAR2_TABLE_100();
312: a22 := JTF_NUMBER_TABLE();
313: a23 := JTF_NUMBER_TABLE();
314: a24 := JTF_NUMBER_TABLE();
315: a25 := JTF_NUMBER_TABLE();
316: a26 := JTF_NUMBER_TABLE();
317: a27 := JTF_VARCHAR2_TABLE_100();
318: a28 := JTF_NUMBER_TABLE();
311: a21 := JTF_VARCHAR2_TABLE_100();
312: a22 := JTF_NUMBER_TABLE();
313: a23 := JTF_NUMBER_TABLE();
314: a24 := JTF_NUMBER_TABLE();
315: a25 := JTF_NUMBER_TABLE();
316: a26 := JTF_NUMBER_TABLE();
317: a27 := JTF_VARCHAR2_TABLE_100();
318: a28 := JTF_NUMBER_TABLE();
319: a29 := JTF_NUMBER_TABLE();
312: a22 := JTF_NUMBER_TABLE();
313: a23 := JTF_NUMBER_TABLE();
314: a24 := JTF_NUMBER_TABLE();
315: a25 := JTF_NUMBER_TABLE();
316: a26 := JTF_NUMBER_TABLE();
317: a27 := JTF_VARCHAR2_TABLE_100();
318: a28 := JTF_NUMBER_TABLE();
319: a29 := JTF_NUMBER_TABLE();
320: a30 := JTF_NUMBER_TABLE();
314: a24 := JTF_NUMBER_TABLE();
315: a25 := JTF_NUMBER_TABLE();
316: a26 := JTF_NUMBER_TABLE();
317: a27 := JTF_VARCHAR2_TABLE_100();
318: a28 := JTF_NUMBER_TABLE();
319: a29 := JTF_NUMBER_TABLE();
320: a30 := JTF_NUMBER_TABLE();
321: a31 := JTF_NUMBER_TABLE();
322: a32 := JTF_VARCHAR2_TABLE_100();
315: a25 := JTF_NUMBER_TABLE();
316: a26 := JTF_NUMBER_TABLE();
317: a27 := JTF_VARCHAR2_TABLE_100();
318: a28 := JTF_NUMBER_TABLE();
319: a29 := JTF_NUMBER_TABLE();
320: a30 := JTF_NUMBER_TABLE();
321: a31 := JTF_NUMBER_TABLE();
322: a32 := JTF_VARCHAR2_TABLE_100();
323: a33 := JTF_NUMBER_TABLE();
316: a26 := JTF_NUMBER_TABLE();
317: a27 := JTF_VARCHAR2_TABLE_100();
318: a28 := JTF_NUMBER_TABLE();
319: a29 := JTF_NUMBER_TABLE();
320: a30 := JTF_NUMBER_TABLE();
321: a31 := JTF_NUMBER_TABLE();
322: a32 := JTF_VARCHAR2_TABLE_100();
323: a33 := JTF_NUMBER_TABLE();
324: a34 := JTF_NUMBER_TABLE();
317: a27 := JTF_VARCHAR2_TABLE_100();
318: a28 := JTF_NUMBER_TABLE();
319: a29 := JTF_NUMBER_TABLE();
320: a30 := JTF_NUMBER_TABLE();
321: a31 := JTF_NUMBER_TABLE();
322: a32 := JTF_VARCHAR2_TABLE_100();
323: a33 := JTF_NUMBER_TABLE();
324: a34 := JTF_NUMBER_TABLE();
325: a35 := JTF_DATE_TABLE();
319: a29 := JTF_NUMBER_TABLE();
320: a30 := JTF_NUMBER_TABLE();
321: a31 := JTF_NUMBER_TABLE();
322: a32 := JTF_VARCHAR2_TABLE_100();
323: a33 := JTF_NUMBER_TABLE();
324: a34 := JTF_NUMBER_TABLE();
325: a35 := JTF_DATE_TABLE();
326: a36 := JTF_DATE_TABLE();
327: a37 := JTF_VARCHAR2_TABLE_100();
320: a30 := JTF_NUMBER_TABLE();
321: a31 := JTF_NUMBER_TABLE();
322: a32 := JTF_VARCHAR2_TABLE_100();
323: a33 := JTF_NUMBER_TABLE();
324: a34 := JTF_NUMBER_TABLE();
325: a35 := JTF_DATE_TABLE();
326: a36 := JTF_DATE_TABLE();
327: a37 := JTF_VARCHAR2_TABLE_100();
328: a38 := JTF_NUMBER_TABLE();
324: a34 := JTF_NUMBER_TABLE();
325: a35 := JTF_DATE_TABLE();
326: a36 := JTF_DATE_TABLE();
327: a37 := JTF_VARCHAR2_TABLE_100();
328: a38 := JTF_NUMBER_TABLE();
329: a39 := JTF_NUMBER_TABLE();
330: a40 := JTF_NUMBER_TABLE();
331: a41 := JTF_NUMBER_TABLE();
332: a42 := JTF_VARCHAR2_TABLE_100();
325: a35 := JTF_DATE_TABLE();
326: a36 := JTF_DATE_TABLE();
327: a37 := JTF_VARCHAR2_TABLE_100();
328: a38 := JTF_NUMBER_TABLE();
329: a39 := JTF_NUMBER_TABLE();
330: a40 := JTF_NUMBER_TABLE();
331: a41 := JTF_NUMBER_TABLE();
332: a42 := JTF_VARCHAR2_TABLE_100();
333: a43 := JTF_VARCHAR2_TABLE_100();
326: a36 := JTF_DATE_TABLE();
327: a37 := JTF_VARCHAR2_TABLE_100();
328: a38 := JTF_NUMBER_TABLE();
329: a39 := JTF_NUMBER_TABLE();
330: a40 := JTF_NUMBER_TABLE();
331: a41 := JTF_NUMBER_TABLE();
332: a42 := JTF_VARCHAR2_TABLE_100();
333: a43 := JTF_VARCHAR2_TABLE_100();
334: a44 := JTF_VARCHAR2_TABLE_200();
327: a37 := JTF_VARCHAR2_TABLE_100();
328: a38 := JTF_NUMBER_TABLE();
329: a39 := JTF_NUMBER_TABLE();
330: a40 := JTF_NUMBER_TABLE();
331: a41 := JTF_NUMBER_TABLE();
332: a42 := JTF_VARCHAR2_TABLE_100();
333: a43 := JTF_VARCHAR2_TABLE_100();
334: a44 := JTF_VARCHAR2_TABLE_200();
335: a45 := JTF_VARCHAR2_TABLE_200();
345: a55 := JTF_VARCHAR2_TABLE_200();
346: a56 := JTF_VARCHAR2_TABLE_200();
347: a57 := JTF_VARCHAR2_TABLE_200();
348: a58 := JTF_VARCHAR2_TABLE_200();
349: a59 := JTF_NUMBER_TABLE();
350: a60 := JTF_VARCHAR2_TABLE_3000();
351: a61 := JTF_VARCHAR2_TABLE_100();
352: a62 := JTF_VARCHAR2_TABLE_100();
353: if t.count > 0 then
489: end if;
490: end if;
491: end rosetta_table_copy_out_p2;
492:
493: procedure rosetta_table_copy_in_p3(t out nocopy ahl_pp_materials_pvt.sch_material_tbl_type, a0 JTF_NUMBER_TABLE
494: , a1 JTF_NUMBER_TABLE
495: , a2 JTF_NUMBER_TABLE
496: , a3 JTF_VARCHAR2_TABLE_100
497: , a4 JTF_VARCHAR2_TABLE_300
490: end if;
491: end rosetta_table_copy_out_p2;
492:
493: procedure rosetta_table_copy_in_p3(t out nocopy ahl_pp_materials_pvt.sch_material_tbl_type, a0 JTF_NUMBER_TABLE
494: , a1 JTF_NUMBER_TABLE
495: , a2 JTF_NUMBER_TABLE
496: , a3 JTF_VARCHAR2_TABLE_100
497: , a4 JTF_VARCHAR2_TABLE_300
498: , a5 JTF_NUMBER_TABLE
491: end rosetta_table_copy_out_p2;
492:
493: procedure rosetta_table_copy_in_p3(t out nocopy ahl_pp_materials_pvt.sch_material_tbl_type, a0 JTF_NUMBER_TABLE
494: , a1 JTF_NUMBER_TABLE
495: , a2 JTF_NUMBER_TABLE
496: , a3 JTF_VARCHAR2_TABLE_100
497: , a4 JTF_VARCHAR2_TABLE_300
498: , a5 JTF_NUMBER_TABLE
499: , a6 JTF_NUMBER_TABLE
494: , a1 JTF_NUMBER_TABLE
495: , a2 JTF_NUMBER_TABLE
496: , a3 JTF_VARCHAR2_TABLE_100
497: , a4 JTF_VARCHAR2_TABLE_300
498: , a5 JTF_NUMBER_TABLE
499: , a6 JTF_NUMBER_TABLE
500: , a7 JTF_NUMBER_TABLE
501: , a8 JTF_NUMBER_TABLE
502: , a9 JTF_NUMBER_TABLE
495: , a2 JTF_NUMBER_TABLE
496: , a3 JTF_VARCHAR2_TABLE_100
497: , a4 JTF_VARCHAR2_TABLE_300
498: , a5 JTF_NUMBER_TABLE
499: , a6 JTF_NUMBER_TABLE
500: , a7 JTF_NUMBER_TABLE
501: , a8 JTF_NUMBER_TABLE
502: , a9 JTF_NUMBER_TABLE
503: , a10 JTF_NUMBER_TABLE
496: , a3 JTF_VARCHAR2_TABLE_100
497: , a4 JTF_VARCHAR2_TABLE_300
498: , a5 JTF_NUMBER_TABLE
499: , a6 JTF_NUMBER_TABLE
500: , a7 JTF_NUMBER_TABLE
501: , a8 JTF_NUMBER_TABLE
502: , a9 JTF_NUMBER_TABLE
503: , a10 JTF_NUMBER_TABLE
504: , a11 JTF_DATE_TABLE
497: , a4 JTF_VARCHAR2_TABLE_300
498: , a5 JTF_NUMBER_TABLE
499: , a6 JTF_NUMBER_TABLE
500: , a7 JTF_NUMBER_TABLE
501: , a8 JTF_NUMBER_TABLE
502: , a9 JTF_NUMBER_TABLE
503: , a10 JTF_NUMBER_TABLE
504: , a11 JTF_DATE_TABLE
505: , a12 JTF_VARCHAR2_TABLE_100
498: , a5 JTF_NUMBER_TABLE
499: , a6 JTF_NUMBER_TABLE
500: , a7 JTF_NUMBER_TABLE
501: , a8 JTF_NUMBER_TABLE
502: , a9 JTF_NUMBER_TABLE
503: , a10 JTF_NUMBER_TABLE
504: , a11 JTF_DATE_TABLE
505: , a12 JTF_VARCHAR2_TABLE_100
506: , a13 JTF_NUMBER_TABLE
499: , a6 JTF_NUMBER_TABLE
500: , a7 JTF_NUMBER_TABLE
501: , a8 JTF_NUMBER_TABLE
502: , a9 JTF_NUMBER_TABLE
503: , a10 JTF_NUMBER_TABLE
504: , a11 JTF_DATE_TABLE
505: , a12 JTF_VARCHAR2_TABLE_100
506: , a13 JTF_NUMBER_TABLE
507: , a14 JTF_DATE_TABLE
502: , a9 JTF_NUMBER_TABLE
503: , a10 JTF_NUMBER_TABLE
504: , a11 JTF_DATE_TABLE
505: , a12 JTF_VARCHAR2_TABLE_100
506: , a13 JTF_NUMBER_TABLE
507: , a14 JTF_DATE_TABLE
508: , a15 JTF_NUMBER_TABLE
509: , a16 JTF_VARCHAR2_TABLE_100
510: , a17 JTF_NUMBER_TABLE
504: , a11 JTF_DATE_TABLE
505: , a12 JTF_VARCHAR2_TABLE_100
506: , a13 JTF_NUMBER_TABLE
507: , a14 JTF_DATE_TABLE
508: , a15 JTF_NUMBER_TABLE
509: , a16 JTF_VARCHAR2_TABLE_100
510: , a17 JTF_NUMBER_TABLE
511: , a18 JTF_NUMBER_TABLE
512: , a19 JTF_NUMBER_TABLE
506: , a13 JTF_NUMBER_TABLE
507: , a14 JTF_DATE_TABLE
508: , a15 JTF_NUMBER_TABLE
509: , a16 JTF_VARCHAR2_TABLE_100
510: , a17 JTF_NUMBER_TABLE
511: , a18 JTF_NUMBER_TABLE
512: , a19 JTF_NUMBER_TABLE
513: , a20 JTF_NUMBER_TABLE
514: , a21 JTF_VARCHAR2_TABLE_100
507: , a14 JTF_DATE_TABLE
508: , a15 JTF_NUMBER_TABLE
509: , a16 JTF_VARCHAR2_TABLE_100
510: , a17 JTF_NUMBER_TABLE
511: , a18 JTF_NUMBER_TABLE
512: , a19 JTF_NUMBER_TABLE
513: , a20 JTF_NUMBER_TABLE
514: , a21 JTF_VARCHAR2_TABLE_100
515: , a22 JTF_NUMBER_TABLE
508: , a15 JTF_NUMBER_TABLE
509: , a16 JTF_VARCHAR2_TABLE_100
510: , a17 JTF_NUMBER_TABLE
511: , a18 JTF_NUMBER_TABLE
512: , a19 JTF_NUMBER_TABLE
513: , a20 JTF_NUMBER_TABLE
514: , a21 JTF_VARCHAR2_TABLE_100
515: , a22 JTF_NUMBER_TABLE
516: , a23 JTF_VARCHAR2_TABLE_100
509: , a16 JTF_VARCHAR2_TABLE_100
510: , a17 JTF_NUMBER_TABLE
511: , a18 JTF_NUMBER_TABLE
512: , a19 JTF_NUMBER_TABLE
513: , a20 JTF_NUMBER_TABLE
514: , a21 JTF_VARCHAR2_TABLE_100
515: , a22 JTF_NUMBER_TABLE
516: , a23 JTF_VARCHAR2_TABLE_100
517: ) as
511: , a18 JTF_NUMBER_TABLE
512: , a19 JTF_NUMBER_TABLE
513: , a20 JTF_NUMBER_TABLE
514: , a21 JTF_VARCHAR2_TABLE_100
515: , a22 JTF_NUMBER_TABLE
516: , a23 JTF_VARCHAR2_TABLE_100
517: ) as
518: ddindx binary_integer; indx binary_integer;
519: begin
554: end loop;
555: end if;
556: end if;
557: end rosetta_table_copy_in_p3;
558: procedure rosetta_table_copy_out_p3(t ahl_pp_materials_pvt.sch_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
559: , a1 out nocopy JTF_NUMBER_TABLE
560: , a2 out nocopy JTF_NUMBER_TABLE
561: , a3 out nocopy JTF_VARCHAR2_TABLE_100
562: , a4 out nocopy JTF_VARCHAR2_TABLE_300
555: end if;
556: end if;
557: end rosetta_table_copy_in_p3;
558: procedure rosetta_table_copy_out_p3(t ahl_pp_materials_pvt.sch_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
559: , a1 out nocopy JTF_NUMBER_TABLE
560: , a2 out nocopy JTF_NUMBER_TABLE
561: , a3 out nocopy JTF_VARCHAR2_TABLE_100
562: , a4 out nocopy JTF_VARCHAR2_TABLE_300
563: , a5 out nocopy JTF_NUMBER_TABLE
556: end if;
557: end rosetta_table_copy_in_p3;
558: procedure rosetta_table_copy_out_p3(t ahl_pp_materials_pvt.sch_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
559: , a1 out nocopy JTF_NUMBER_TABLE
560: , a2 out nocopy JTF_NUMBER_TABLE
561: , a3 out nocopy JTF_VARCHAR2_TABLE_100
562: , a4 out nocopy JTF_VARCHAR2_TABLE_300
563: , a5 out nocopy JTF_NUMBER_TABLE
564: , a6 out nocopy JTF_NUMBER_TABLE
559: , a1 out nocopy JTF_NUMBER_TABLE
560: , a2 out nocopy JTF_NUMBER_TABLE
561: , a3 out nocopy JTF_VARCHAR2_TABLE_100
562: , a4 out nocopy JTF_VARCHAR2_TABLE_300
563: , a5 out nocopy JTF_NUMBER_TABLE
564: , a6 out nocopy JTF_NUMBER_TABLE
565: , a7 out nocopy JTF_NUMBER_TABLE
566: , a8 out nocopy JTF_NUMBER_TABLE
567: , a9 out nocopy JTF_NUMBER_TABLE
560: , a2 out nocopy JTF_NUMBER_TABLE
561: , a3 out nocopy JTF_VARCHAR2_TABLE_100
562: , a4 out nocopy JTF_VARCHAR2_TABLE_300
563: , a5 out nocopy JTF_NUMBER_TABLE
564: , a6 out nocopy JTF_NUMBER_TABLE
565: , a7 out nocopy JTF_NUMBER_TABLE
566: , a8 out nocopy JTF_NUMBER_TABLE
567: , a9 out nocopy JTF_NUMBER_TABLE
568: , a10 out nocopy JTF_NUMBER_TABLE
561: , a3 out nocopy JTF_VARCHAR2_TABLE_100
562: , a4 out nocopy JTF_VARCHAR2_TABLE_300
563: , a5 out nocopy JTF_NUMBER_TABLE
564: , a6 out nocopy JTF_NUMBER_TABLE
565: , a7 out nocopy JTF_NUMBER_TABLE
566: , a8 out nocopy JTF_NUMBER_TABLE
567: , a9 out nocopy JTF_NUMBER_TABLE
568: , a10 out nocopy JTF_NUMBER_TABLE
569: , a11 out nocopy JTF_DATE_TABLE
562: , a4 out nocopy JTF_VARCHAR2_TABLE_300
563: , a5 out nocopy JTF_NUMBER_TABLE
564: , a6 out nocopy JTF_NUMBER_TABLE
565: , a7 out nocopy JTF_NUMBER_TABLE
566: , a8 out nocopy JTF_NUMBER_TABLE
567: , a9 out nocopy JTF_NUMBER_TABLE
568: , a10 out nocopy JTF_NUMBER_TABLE
569: , a11 out nocopy JTF_DATE_TABLE
570: , a12 out nocopy JTF_VARCHAR2_TABLE_100
563: , a5 out nocopy JTF_NUMBER_TABLE
564: , a6 out nocopy JTF_NUMBER_TABLE
565: , a7 out nocopy JTF_NUMBER_TABLE
566: , a8 out nocopy JTF_NUMBER_TABLE
567: , a9 out nocopy JTF_NUMBER_TABLE
568: , a10 out nocopy JTF_NUMBER_TABLE
569: , a11 out nocopy JTF_DATE_TABLE
570: , a12 out nocopy JTF_VARCHAR2_TABLE_100
571: , a13 out nocopy JTF_NUMBER_TABLE
564: , a6 out nocopy JTF_NUMBER_TABLE
565: , a7 out nocopy JTF_NUMBER_TABLE
566: , a8 out nocopy JTF_NUMBER_TABLE
567: , a9 out nocopy JTF_NUMBER_TABLE
568: , a10 out nocopy JTF_NUMBER_TABLE
569: , a11 out nocopy JTF_DATE_TABLE
570: , a12 out nocopy JTF_VARCHAR2_TABLE_100
571: , a13 out nocopy JTF_NUMBER_TABLE
572: , a14 out nocopy JTF_DATE_TABLE
567: , a9 out nocopy JTF_NUMBER_TABLE
568: , a10 out nocopy JTF_NUMBER_TABLE
569: , a11 out nocopy JTF_DATE_TABLE
570: , a12 out nocopy JTF_VARCHAR2_TABLE_100
571: , a13 out nocopy JTF_NUMBER_TABLE
572: , a14 out nocopy JTF_DATE_TABLE
573: , a15 out nocopy JTF_NUMBER_TABLE
574: , a16 out nocopy JTF_VARCHAR2_TABLE_100
575: , a17 out nocopy JTF_NUMBER_TABLE
569: , a11 out nocopy JTF_DATE_TABLE
570: , a12 out nocopy JTF_VARCHAR2_TABLE_100
571: , a13 out nocopy JTF_NUMBER_TABLE
572: , a14 out nocopy JTF_DATE_TABLE
573: , a15 out nocopy JTF_NUMBER_TABLE
574: , a16 out nocopy JTF_VARCHAR2_TABLE_100
575: , a17 out nocopy JTF_NUMBER_TABLE
576: , a18 out nocopy JTF_NUMBER_TABLE
577: , a19 out nocopy JTF_NUMBER_TABLE
571: , a13 out nocopy JTF_NUMBER_TABLE
572: , a14 out nocopy JTF_DATE_TABLE
573: , a15 out nocopy JTF_NUMBER_TABLE
574: , a16 out nocopy JTF_VARCHAR2_TABLE_100
575: , a17 out nocopy JTF_NUMBER_TABLE
576: , a18 out nocopy JTF_NUMBER_TABLE
577: , a19 out nocopy JTF_NUMBER_TABLE
578: , a20 out nocopy JTF_NUMBER_TABLE
579: , a21 out nocopy JTF_VARCHAR2_TABLE_100
572: , a14 out nocopy JTF_DATE_TABLE
573: , a15 out nocopy JTF_NUMBER_TABLE
574: , a16 out nocopy JTF_VARCHAR2_TABLE_100
575: , a17 out nocopy JTF_NUMBER_TABLE
576: , a18 out nocopy JTF_NUMBER_TABLE
577: , a19 out nocopy JTF_NUMBER_TABLE
578: , a20 out nocopy JTF_NUMBER_TABLE
579: , a21 out nocopy JTF_VARCHAR2_TABLE_100
580: , a22 out nocopy JTF_NUMBER_TABLE
573: , a15 out nocopy JTF_NUMBER_TABLE
574: , a16 out nocopy JTF_VARCHAR2_TABLE_100
575: , a17 out nocopy JTF_NUMBER_TABLE
576: , a18 out nocopy JTF_NUMBER_TABLE
577: , a19 out nocopy JTF_NUMBER_TABLE
578: , a20 out nocopy JTF_NUMBER_TABLE
579: , a21 out nocopy JTF_VARCHAR2_TABLE_100
580: , a22 out nocopy JTF_NUMBER_TABLE
581: , a23 out nocopy JTF_VARCHAR2_TABLE_100
574: , a16 out nocopy JTF_VARCHAR2_TABLE_100
575: , a17 out nocopy JTF_NUMBER_TABLE
576: , a18 out nocopy JTF_NUMBER_TABLE
577: , a19 out nocopy JTF_NUMBER_TABLE
578: , a20 out nocopy JTF_NUMBER_TABLE
579: , a21 out nocopy JTF_VARCHAR2_TABLE_100
580: , a22 out nocopy JTF_NUMBER_TABLE
581: , a23 out nocopy JTF_VARCHAR2_TABLE_100
582: ) as
576: , a18 out nocopy JTF_NUMBER_TABLE
577: , a19 out nocopy JTF_NUMBER_TABLE
578: , a20 out nocopy JTF_NUMBER_TABLE
579: , a21 out nocopy JTF_VARCHAR2_TABLE_100
580: , a22 out nocopy JTF_NUMBER_TABLE
581: , a23 out nocopy JTF_VARCHAR2_TABLE_100
582: ) as
583: ddindx binary_integer; indx binary_integer;
584: begin
582: ) as
583: ddindx binary_integer; indx binary_integer;
584: begin
585: if t is null or t.count = 0 then
586: a0 := JTF_NUMBER_TABLE();
587: a1 := JTF_NUMBER_TABLE();
588: a2 := JTF_NUMBER_TABLE();
589: a3 := JTF_VARCHAR2_TABLE_100();
590: a4 := JTF_VARCHAR2_TABLE_300();
583: ddindx binary_integer; indx binary_integer;
584: begin
585: if t is null or t.count = 0 then
586: a0 := JTF_NUMBER_TABLE();
587: a1 := JTF_NUMBER_TABLE();
588: a2 := JTF_NUMBER_TABLE();
589: a3 := JTF_VARCHAR2_TABLE_100();
590: a4 := JTF_VARCHAR2_TABLE_300();
591: a5 := JTF_NUMBER_TABLE();
584: begin
585: if t is null or t.count = 0 then
586: a0 := JTF_NUMBER_TABLE();
587: a1 := JTF_NUMBER_TABLE();
588: a2 := JTF_NUMBER_TABLE();
589: a3 := JTF_VARCHAR2_TABLE_100();
590: a4 := JTF_VARCHAR2_TABLE_300();
591: a5 := JTF_NUMBER_TABLE();
592: a6 := JTF_NUMBER_TABLE();
587: a1 := JTF_NUMBER_TABLE();
588: a2 := JTF_NUMBER_TABLE();
589: a3 := JTF_VARCHAR2_TABLE_100();
590: a4 := JTF_VARCHAR2_TABLE_300();
591: a5 := JTF_NUMBER_TABLE();
592: a6 := JTF_NUMBER_TABLE();
593: a7 := JTF_NUMBER_TABLE();
594: a8 := JTF_NUMBER_TABLE();
595: a9 := JTF_NUMBER_TABLE();
588: a2 := JTF_NUMBER_TABLE();
589: a3 := JTF_VARCHAR2_TABLE_100();
590: a4 := JTF_VARCHAR2_TABLE_300();
591: a5 := JTF_NUMBER_TABLE();
592: a6 := JTF_NUMBER_TABLE();
593: a7 := JTF_NUMBER_TABLE();
594: a8 := JTF_NUMBER_TABLE();
595: a9 := JTF_NUMBER_TABLE();
596: a10 := JTF_NUMBER_TABLE();
589: a3 := JTF_VARCHAR2_TABLE_100();
590: a4 := JTF_VARCHAR2_TABLE_300();
591: a5 := JTF_NUMBER_TABLE();
592: a6 := JTF_NUMBER_TABLE();
593: a7 := JTF_NUMBER_TABLE();
594: a8 := JTF_NUMBER_TABLE();
595: a9 := JTF_NUMBER_TABLE();
596: a10 := JTF_NUMBER_TABLE();
597: a11 := JTF_DATE_TABLE();
590: a4 := JTF_VARCHAR2_TABLE_300();
591: a5 := JTF_NUMBER_TABLE();
592: a6 := JTF_NUMBER_TABLE();
593: a7 := JTF_NUMBER_TABLE();
594: a8 := JTF_NUMBER_TABLE();
595: a9 := JTF_NUMBER_TABLE();
596: a10 := JTF_NUMBER_TABLE();
597: a11 := JTF_DATE_TABLE();
598: a12 := JTF_VARCHAR2_TABLE_100();
591: a5 := JTF_NUMBER_TABLE();
592: a6 := JTF_NUMBER_TABLE();
593: a7 := JTF_NUMBER_TABLE();
594: a8 := JTF_NUMBER_TABLE();
595: a9 := JTF_NUMBER_TABLE();
596: a10 := JTF_NUMBER_TABLE();
597: a11 := JTF_DATE_TABLE();
598: a12 := JTF_VARCHAR2_TABLE_100();
599: a13 := JTF_NUMBER_TABLE();
592: a6 := JTF_NUMBER_TABLE();
593: a7 := JTF_NUMBER_TABLE();
594: a8 := JTF_NUMBER_TABLE();
595: a9 := JTF_NUMBER_TABLE();
596: a10 := JTF_NUMBER_TABLE();
597: a11 := JTF_DATE_TABLE();
598: a12 := JTF_VARCHAR2_TABLE_100();
599: a13 := JTF_NUMBER_TABLE();
600: a14 := JTF_DATE_TABLE();
595: a9 := JTF_NUMBER_TABLE();
596: a10 := JTF_NUMBER_TABLE();
597: a11 := JTF_DATE_TABLE();
598: a12 := JTF_VARCHAR2_TABLE_100();
599: a13 := JTF_NUMBER_TABLE();
600: a14 := JTF_DATE_TABLE();
601: a15 := JTF_NUMBER_TABLE();
602: a16 := JTF_VARCHAR2_TABLE_100();
603: a17 := JTF_NUMBER_TABLE();
597: a11 := JTF_DATE_TABLE();
598: a12 := JTF_VARCHAR2_TABLE_100();
599: a13 := JTF_NUMBER_TABLE();
600: a14 := JTF_DATE_TABLE();
601: a15 := JTF_NUMBER_TABLE();
602: a16 := JTF_VARCHAR2_TABLE_100();
603: a17 := JTF_NUMBER_TABLE();
604: a18 := JTF_NUMBER_TABLE();
605: a19 := JTF_NUMBER_TABLE();
599: a13 := JTF_NUMBER_TABLE();
600: a14 := JTF_DATE_TABLE();
601: a15 := JTF_NUMBER_TABLE();
602: a16 := JTF_VARCHAR2_TABLE_100();
603: a17 := JTF_NUMBER_TABLE();
604: a18 := JTF_NUMBER_TABLE();
605: a19 := JTF_NUMBER_TABLE();
606: a20 := JTF_NUMBER_TABLE();
607: a21 := JTF_VARCHAR2_TABLE_100();
600: a14 := JTF_DATE_TABLE();
601: a15 := JTF_NUMBER_TABLE();
602: a16 := JTF_VARCHAR2_TABLE_100();
603: a17 := JTF_NUMBER_TABLE();
604: a18 := JTF_NUMBER_TABLE();
605: a19 := JTF_NUMBER_TABLE();
606: a20 := JTF_NUMBER_TABLE();
607: a21 := JTF_VARCHAR2_TABLE_100();
608: a22 := JTF_NUMBER_TABLE();
601: a15 := JTF_NUMBER_TABLE();
602: a16 := JTF_VARCHAR2_TABLE_100();
603: a17 := JTF_NUMBER_TABLE();
604: a18 := JTF_NUMBER_TABLE();
605: a19 := JTF_NUMBER_TABLE();
606: a20 := JTF_NUMBER_TABLE();
607: a21 := JTF_VARCHAR2_TABLE_100();
608: a22 := JTF_NUMBER_TABLE();
609: a23 := JTF_VARCHAR2_TABLE_100();
602: a16 := JTF_VARCHAR2_TABLE_100();
603: a17 := JTF_NUMBER_TABLE();
604: a18 := JTF_NUMBER_TABLE();
605: a19 := JTF_NUMBER_TABLE();
606: a20 := JTF_NUMBER_TABLE();
607: a21 := JTF_VARCHAR2_TABLE_100();
608: a22 := JTF_NUMBER_TABLE();
609: a23 := JTF_VARCHAR2_TABLE_100();
610: else
604: a18 := JTF_NUMBER_TABLE();
605: a19 := JTF_NUMBER_TABLE();
606: a20 := JTF_NUMBER_TABLE();
607: a21 := JTF_VARCHAR2_TABLE_100();
608: a22 := JTF_NUMBER_TABLE();
609: a23 := JTF_VARCHAR2_TABLE_100();
610: else
611: a0 := JTF_NUMBER_TABLE();
612: a1 := JTF_NUMBER_TABLE();
607: a21 := JTF_VARCHAR2_TABLE_100();
608: a22 := JTF_NUMBER_TABLE();
609: a23 := JTF_VARCHAR2_TABLE_100();
610: else
611: a0 := JTF_NUMBER_TABLE();
612: a1 := JTF_NUMBER_TABLE();
613: a2 := JTF_NUMBER_TABLE();
614: a3 := JTF_VARCHAR2_TABLE_100();
615: a4 := JTF_VARCHAR2_TABLE_300();
608: a22 := JTF_NUMBER_TABLE();
609: a23 := JTF_VARCHAR2_TABLE_100();
610: else
611: a0 := JTF_NUMBER_TABLE();
612: a1 := JTF_NUMBER_TABLE();
613: a2 := JTF_NUMBER_TABLE();
614: a3 := JTF_VARCHAR2_TABLE_100();
615: a4 := JTF_VARCHAR2_TABLE_300();
616: a5 := JTF_NUMBER_TABLE();
609: a23 := JTF_VARCHAR2_TABLE_100();
610: else
611: a0 := JTF_NUMBER_TABLE();
612: a1 := JTF_NUMBER_TABLE();
613: a2 := JTF_NUMBER_TABLE();
614: a3 := JTF_VARCHAR2_TABLE_100();
615: a4 := JTF_VARCHAR2_TABLE_300();
616: a5 := JTF_NUMBER_TABLE();
617: a6 := JTF_NUMBER_TABLE();
612: a1 := JTF_NUMBER_TABLE();
613: a2 := JTF_NUMBER_TABLE();
614: a3 := JTF_VARCHAR2_TABLE_100();
615: a4 := JTF_VARCHAR2_TABLE_300();
616: a5 := JTF_NUMBER_TABLE();
617: a6 := JTF_NUMBER_TABLE();
618: a7 := JTF_NUMBER_TABLE();
619: a8 := JTF_NUMBER_TABLE();
620: a9 := JTF_NUMBER_TABLE();
613: a2 := JTF_NUMBER_TABLE();
614: a3 := JTF_VARCHAR2_TABLE_100();
615: a4 := JTF_VARCHAR2_TABLE_300();
616: a5 := JTF_NUMBER_TABLE();
617: a6 := JTF_NUMBER_TABLE();
618: a7 := JTF_NUMBER_TABLE();
619: a8 := JTF_NUMBER_TABLE();
620: a9 := JTF_NUMBER_TABLE();
621: a10 := JTF_NUMBER_TABLE();
614: a3 := JTF_VARCHAR2_TABLE_100();
615: a4 := JTF_VARCHAR2_TABLE_300();
616: a5 := JTF_NUMBER_TABLE();
617: a6 := JTF_NUMBER_TABLE();
618: a7 := JTF_NUMBER_TABLE();
619: a8 := JTF_NUMBER_TABLE();
620: a9 := JTF_NUMBER_TABLE();
621: a10 := JTF_NUMBER_TABLE();
622: a11 := JTF_DATE_TABLE();
615: a4 := JTF_VARCHAR2_TABLE_300();
616: a5 := JTF_NUMBER_TABLE();
617: a6 := JTF_NUMBER_TABLE();
618: a7 := JTF_NUMBER_TABLE();
619: a8 := JTF_NUMBER_TABLE();
620: a9 := JTF_NUMBER_TABLE();
621: a10 := JTF_NUMBER_TABLE();
622: a11 := JTF_DATE_TABLE();
623: a12 := JTF_VARCHAR2_TABLE_100();
616: a5 := JTF_NUMBER_TABLE();
617: a6 := JTF_NUMBER_TABLE();
618: a7 := JTF_NUMBER_TABLE();
619: a8 := JTF_NUMBER_TABLE();
620: a9 := JTF_NUMBER_TABLE();
621: a10 := JTF_NUMBER_TABLE();
622: a11 := JTF_DATE_TABLE();
623: a12 := JTF_VARCHAR2_TABLE_100();
624: a13 := JTF_NUMBER_TABLE();
617: a6 := JTF_NUMBER_TABLE();
618: a7 := JTF_NUMBER_TABLE();
619: a8 := JTF_NUMBER_TABLE();
620: a9 := JTF_NUMBER_TABLE();
621: a10 := JTF_NUMBER_TABLE();
622: a11 := JTF_DATE_TABLE();
623: a12 := JTF_VARCHAR2_TABLE_100();
624: a13 := JTF_NUMBER_TABLE();
625: a14 := JTF_DATE_TABLE();
620: a9 := JTF_NUMBER_TABLE();
621: a10 := JTF_NUMBER_TABLE();
622: a11 := JTF_DATE_TABLE();
623: a12 := JTF_VARCHAR2_TABLE_100();
624: a13 := JTF_NUMBER_TABLE();
625: a14 := JTF_DATE_TABLE();
626: a15 := JTF_NUMBER_TABLE();
627: a16 := JTF_VARCHAR2_TABLE_100();
628: a17 := JTF_NUMBER_TABLE();
622: a11 := JTF_DATE_TABLE();
623: a12 := JTF_VARCHAR2_TABLE_100();
624: a13 := JTF_NUMBER_TABLE();
625: a14 := JTF_DATE_TABLE();
626: a15 := JTF_NUMBER_TABLE();
627: a16 := JTF_VARCHAR2_TABLE_100();
628: a17 := JTF_NUMBER_TABLE();
629: a18 := JTF_NUMBER_TABLE();
630: a19 := JTF_NUMBER_TABLE();
624: a13 := JTF_NUMBER_TABLE();
625: a14 := JTF_DATE_TABLE();
626: a15 := JTF_NUMBER_TABLE();
627: a16 := JTF_VARCHAR2_TABLE_100();
628: a17 := JTF_NUMBER_TABLE();
629: a18 := JTF_NUMBER_TABLE();
630: a19 := JTF_NUMBER_TABLE();
631: a20 := JTF_NUMBER_TABLE();
632: a21 := JTF_VARCHAR2_TABLE_100();
625: a14 := JTF_DATE_TABLE();
626: a15 := JTF_NUMBER_TABLE();
627: a16 := JTF_VARCHAR2_TABLE_100();
628: a17 := JTF_NUMBER_TABLE();
629: a18 := JTF_NUMBER_TABLE();
630: a19 := JTF_NUMBER_TABLE();
631: a20 := JTF_NUMBER_TABLE();
632: a21 := JTF_VARCHAR2_TABLE_100();
633: a22 := JTF_NUMBER_TABLE();
626: a15 := JTF_NUMBER_TABLE();
627: a16 := JTF_VARCHAR2_TABLE_100();
628: a17 := JTF_NUMBER_TABLE();
629: a18 := JTF_NUMBER_TABLE();
630: a19 := JTF_NUMBER_TABLE();
631: a20 := JTF_NUMBER_TABLE();
632: a21 := JTF_VARCHAR2_TABLE_100();
633: a22 := JTF_NUMBER_TABLE();
634: a23 := JTF_VARCHAR2_TABLE_100();
627: a16 := JTF_VARCHAR2_TABLE_100();
628: a17 := JTF_NUMBER_TABLE();
629: a18 := JTF_NUMBER_TABLE();
630: a19 := JTF_NUMBER_TABLE();
631: a20 := JTF_NUMBER_TABLE();
632: a21 := JTF_VARCHAR2_TABLE_100();
633: a22 := JTF_NUMBER_TABLE();
634: a23 := JTF_VARCHAR2_TABLE_100();
635: if t.count > 0 then
629: a18 := JTF_NUMBER_TABLE();
630: a19 := JTF_NUMBER_TABLE();
631: a20 := JTF_NUMBER_TABLE();
632: a21 := JTF_VARCHAR2_TABLE_100();
633: a22 := JTF_NUMBER_TABLE();
634: a23 := JTF_VARCHAR2_TABLE_100();
635: if t.count > 0 then
636: a0.extend(t.count);
637: a1.extend(t.count);
698: , p_init_msg_list VARCHAR2
699: , p_commit VARCHAR2
700: , p_validation_level NUMBER
701: , p_interface_flag VARCHAR2
702: , p5_a0 in out nocopy JTF_NUMBER_TABLE
703: , p5_a1 in out nocopy JTF_NUMBER_TABLE
704: , p5_a2 in out nocopy JTF_NUMBER_TABLE
705: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
706: , p5_a4 in out nocopy JTF_NUMBER_TABLE
699: , p_commit VARCHAR2
700: , p_validation_level NUMBER
701: , p_interface_flag VARCHAR2
702: , p5_a0 in out nocopy JTF_NUMBER_TABLE
703: , p5_a1 in out nocopy JTF_NUMBER_TABLE
704: , p5_a2 in out nocopy JTF_NUMBER_TABLE
705: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
706: , p5_a4 in out nocopy JTF_NUMBER_TABLE
707: , p5_a5 in out nocopy JTF_DATE_TABLE
700: , p_validation_level NUMBER
701: , p_interface_flag VARCHAR2
702: , p5_a0 in out nocopy JTF_NUMBER_TABLE
703: , p5_a1 in out nocopy JTF_NUMBER_TABLE
704: , p5_a2 in out nocopy JTF_NUMBER_TABLE
705: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
706: , p5_a4 in out nocopy JTF_NUMBER_TABLE
707: , p5_a5 in out nocopy JTF_DATE_TABLE
708: , p5_a6 in out nocopy JTF_NUMBER_TABLE
702: , p5_a0 in out nocopy JTF_NUMBER_TABLE
703: , p5_a1 in out nocopy JTF_NUMBER_TABLE
704: , p5_a2 in out nocopy JTF_NUMBER_TABLE
705: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
706: , p5_a4 in out nocopy JTF_NUMBER_TABLE
707: , p5_a5 in out nocopy JTF_DATE_TABLE
708: , p5_a6 in out nocopy JTF_NUMBER_TABLE
709: , p5_a7 in out nocopy JTF_NUMBER_TABLE
710: , p5_a8 in out nocopy JTF_DATE_TABLE
704: , p5_a2 in out nocopy JTF_NUMBER_TABLE
705: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
706: , p5_a4 in out nocopy JTF_NUMBER_TABLE
707: , p5_a5 in out nocopy JTF_DATE_TABLE
708: , p5_a6 in out nocopy JTF_NUMBER_TABLE
709: , p5_a7 in out nocopy JTF_NUMBER_TABLE
710: , p5_a8 in out nocopy JTF_DATE_TABLE
711: , p5_a9 in out nocopy JTF_NUMBER_TABLE
712: , p5_a10 in out nocopy JTF_NUMBER_TABLE
705: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
706: , p5_a4 in out nocopy JTF_NUMBER_TABLE
707: , p5_a5 in out nocopy JTF_DATE_TABLE
708: , p5_a6 in out nocopy JTF_NUMBER_TABLE
709: , p5_a7 in out nocopy JTF_NUMBER_TABLE
710: , p5_a8 in out nocopy JTF_DATE_TABLE
711: , p5_a9 in out nocopy JTF_NUMBER_TABLE
712: , p5_a10 in out nocopy JTF_NUMBER_TABLE
713: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
707: , p5_a5 in out nocopy JTF_DATE_TABLE
708: , p5_a6 in out nocopy JTF_NUMBER_TABLE
709: , p5_a7 in out nocopy JTF_NUMBER_TABLE
710: , p5_a8 in out nocopy JTF_DATE_TABLE
711: , p5_a9 in out nocopy JTF_NUMBER_TABLE
712: , p5_a10 in out nocopy JTF_NUMBER_TABLE
713: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
714: , p5_a12 in out nocopy JTF_NUMBER_TABLE
715: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
708: , p5_a6 in out nocopy JTF_NUMBER_TABLE
709: , p5_a7 in out nocopy JTF_NUMBER_TABLE
710: , p5_a8 in out nocopy JTF_DATE_TABLE
711: , p5_a9 in out nocopy JTF_NUMBER_TABLE
712: , p5_a10 in out nocopy JTF_NUMBER_TABLE
713: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
714: , p5_a12 in out nocopy JTF_NUMBER_TABLE
715: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
716: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_300
710: , p5_a8 in out nocopy JTF_DATE_TABLE
711: , p5_a9 in out nocopy JTF_NUMBER_TABLE
712: , p5_a10 in out nocopy JTF_NUMBER_TABLE
713: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
714: , p5_a12 in out nocopy JTF_NUMBER_TABLE
715: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
716: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_300
717: , p5_a15 in out nocopy JTF_NUMBER_TABLE
718: , p5_a16 in out nocopy JTF_NUMBER_TABLE
713: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
714: , p5_a12 in out nocopy JTF_NUMBER_TABLE
715: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
716: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_300
717: , p5_a15 in out nocopy JTF_NUMBER_TABLE
718: , p5_a16 in out nocopy JTF_NUMBER_TABLE
719: , p5_a17 in out nocopy JTF_DATE_TABLE
720: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
721: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
714: , p5_a12 in out nocopy JTF_NUMBER_TABLE
715: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
716: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_300
717: , p5_a15 in out nocopy JTF_NUMBER_TABLE
718: , p5_a16 in out nocopy JTF_NUMBER_TABLE
719: , p5_a17 in out nocopy JTF_DATE_TABLE
720: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
721: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
722: , p5_a20 in out nocopy JTF_NUMBER_TABLE
718: , p5_a16 in out nocopy JTF_NUMBER_TABLE
719: , p5_a17 in out nocopy JTF_DATE_TABLE
720: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
721: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
722: , p5_a20 in out nocopy JTF_NUMBER_TABLE
723: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
724: , p5_a22 in out nocopy JTF_NUMBER_TABLE
725: , p5_a23 in out nocopy JTF_NUMBER_TABLE
726: , p5_a24 in out nocopy JTF_NUMBER_TABLE
720: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
721: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
722: , p5_a20 in out nocopy JTF_NUMBER_TABLE
723: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
724: , p5_a22 in out nocopy JTF_NUMBER_TABLE
725: , p5_a23 in out nocopy JTF_NUMBER_TABLE
726: , p5_a24 in out nocopy JTF_NUMBER_TABLE
727: , p5_a25 in out nocopy JTF_NUMBER_TABLE
728: , p5_a26 in out nocopy JTF_NUMBER_TABLE
721: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
722: , p5_a20 in out nocopy JTF_NUMBER_TABLE
723: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
724: , p5_a22 in out nocopy JTF_NUMBER_TABLE
725: , p5_a23 in out nocopy JTF_NUMBER_TABLE
726: , p5_a24 in out nocopy JTF_NUMBER_TABLE
727: , p5_a25 in out nocopy JTF_NUMBER_TABLE
728: , p5_a26 in out nocopy JTF_NUMBER_TABLE
729: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
722: , p5_a20 in out nocopy JTF_NUMBER_TABLE
723: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
724: , p5_a22 in out nocopy JTF_NUMBER_TABLE
725: , p5_a23 in out nocopy JTF_NUMBER_TABLE
726: , p5_a24 in out nocopy JTF_NUMBER_TABLE
727: , p5_a25 in out nocopy JTF_NUMBER_TABLE
728: , p5_a26 in out nocopy JTF_NUMBER_TABLE
729: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
730: , p5_a28 in out nocopy JTF_NUMBER_TABLE
723: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
724: , p5_a22 in out nocopy JTF_NUMBER_TABLE
725: , p5_a23 in out nocopy JTF_NUMBER_TABLE
726: , p5_a24 in out nocopy JTF_NUMBER_TABLE
727: , p5_a25 in out nocopy JTF_NUMBER_TABLE
728: , p5_a26 in out nocopy JTF_NUMBER_TABLE
729: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
730: , p5_a28 in out nocopy JTF_NUMBER_TABLE
731: , p5_a29 in out nocopy JTF_NUMBER_TABLE
724: , p5_a22 in out nocopy JTF_NUMBER_TABLE
725: , p5_a23 in out nocopy JTF_NUMBER_TABLE
726: , p5_a24 in out nocopy JTF_NUMBER_TABLE
727: , p5_a25 in out nocopy JTF_NUMBER_TABLE
728: , p5_a26 in out nocopy JTF_NUMBER_TABLE
729: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
730: , p5_a28 in out nocopy JTF_NUMBER_TABLE
731: , p5_a29 in out nocopy JTF_NUMBER_TABLE
732: , p5_a30 in out nocopy JTF_NUMBER_TABLE
726: , p5_a24 in out nocopy JTF_NUMBER_TABLE
727: , p5_a25 in out nocopy JTF_NUMBER_TABLE
728: , p5_a26 in out nocopy JTF_NUMBER_TABLE
729: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
730: , p5_a28 in out nocopy JTF_NUMBER_TABLE
731: , p5_a29 in out nocopy JTF_NUMBER_TABLE
732: , p5_a30 in out nocopy JTF_NUMBER_TABLE
733: , p5_a31 in out nocopy JTF_NUMBER_TABLE
734: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
727: , p5_a25 in out nocopy JTF_NUMBER_TABLE
728: , p5_a26 in out nocopy JTF_NUMBER_TABLE
729: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
730: , p5_a28 in out nocopy JTF_NUMBER_TABLE
731: , p5_a29 in out nocopy JTF_NUMBER_TABLE
732: , p5_a30 in out nocopy JTF_NUMBER_TABLE
733: , p5_a31 in out nocopy JTF_NUMBER_TABLE
734: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
735: , p5_a33 in out nocopy JTF_NUMBER_TABLE
728: , p5_a26 in out nocopy JTF_NUMBER_TABLE
729: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
730: , p5_a28 in out nocopy JTF_NUMBER_TABLE
731: , p5_a29 in out nocopy JTF_NUMBER_TABLE
732: , p5_a30 in out nocopy JTF_NUMBER_TABLE
733: , p5_a31 in out nocopy JTF_NUMBER_TABLE
734: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
735: , p5_a33 in out nocopy JTF_NUMBER_TABLE
736: , p5_a34 in out nocopy JTF_NUMBER_TABLE
729: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
730: , p5_a28 in out nocopy JTF_NUMBER_TABLE
731: , p5_a29 in out nocopy JTF_NUMBER_TABLE
732: , p5_a30 in out nocopy JTF_NUMBER_TABLE
733: , p5_a31 in out nocopy JTF_NUMBER_TABLE
734: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
735: , p5_a33 in out nocopy JTF_NUMBER_TABLE
736: , p5_a34 in out nocopy JTF_NUMBER_TABLE
737: , p5_a35 in out nocopy JTF_DATE_TABLE
731: , p5_a29 in out nocopy JTF_NUMBER_TABLE
732: , p5_a30 in out nocopy JTF_NUMBER_TABLE
733: , p5_a31 in out nocopy JTF_NUMBER_TABLE
734: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
735: , p5_a33 in out nocopy JTF_NUMBER_TABLE
736: , p5_a34 in out nocopy JTF_NUMBER_TABLE
737: , p5_a35 in out nocopy JTF_DATE_TABLE
738: , p5_a36 in out nocopy JTF_DATE_TABLE
739: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
732: , p5_a30 in out nocopy JTF_NUMBER_TABLE
733: , p5_a31 in out nocopy JTF_NUMBER_TABLE
734: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
735: , p5_a33 in out nocopy JTF_NUMBER_TABLE
736: , p5_a34 in out nocopy JTF_NUMBER_TABLE
737: , p5_a35 in out nocopy JTF_DATE_TABLE
738: , p5_a36 in out nocopy JTF_DATE_TABLE
739: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
740: , p5_a38 in out nocopy JTF_NUMBER_TABLE
736: , p5_a34 in out nocopy JTF_NUMBER_TABLE
737: , p5_a35 in out nocopy JTF_DATE_TABLE
738: , p5_a36 in out nocopy JTF_DATE_TABLE
739: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
740: , p5_a38 in out nocopy JTF_NUMBER_TABLE
741: , p5_a39 in out nocopy JTF_NUMBER_TABLE
742: , p5_a40 in out nocopy JTF_NUMBER_TABLE
743: , p5_a41 in out nocopy JTF_NUMBER_TABLE
744: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
737: , p5_a35 in out nocopy JTF_DATE_TABLE
738: , p5_a36 in out nocopy JTF_DATE_TABLE
739: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
740: , p5_a38 in out nocopy JTF_NUMBER_TABLE
741: , p5_a39 in out nocopy JTF_NUMBER_TABLE
742: , p5_a40 in out nocopy JTF_NUMBER_TABLE
743: , p5_a41 in out nocopy JTF_NUMBER_TABLE
744: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
745: , p5_a43 in out nocopy JTF_VARCHAR2_TABLE_100
738: , p5_a36 in out nocopy JTF_DATE_TABLE
739: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
740: , p5_a38 in out nocopy JTF_NUMBER_TABLE
741: , p5_a39 in out nocopy JTF_NUMBER_TABLE
742: , p5_a40 in out nocopy JTF_NUMBER_TABLE
743: , p5_a41 in out nocopy JTF_NUMBER_TABLE
744: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
745: , p5_a43 in out nocopy JTF_VARCHAR2_TABLE_100
746: , p5_a44 in out nocopy JTF_VARCHAR2_TABLE_200
739: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
740: , p5_a38 in out nocopy JTF_NUMBER_TABLE
741: , p5_a39 in out nocopy JTF_NUMBER_TABLE
742: , p5_a40 in out nocopy JTF_NUMBER_TABLE
743: , p5_a41 in out nocopy JTF_NUMBER_TABLE
744: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
745: , p5_a43 in out nocopy JTF_VARCHAR2_TABLE_100
746: , p5_a44 in out nocopy JTF_VARCHAR2_TABLE_200
747: , p5_a45 in out nocopy JTF_VARCHAR2_TABLE_200
757: , p5_a55 in out nocopy JTF_VARCHAR2_TABLE_200
758: , p5_a56 in out nocopy JTF_VARCHAR2_TABLE_200
759: , p5_a57 in out nocopy JTF_VARCHAR2_TABLE_200
760: , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_200
761: , p5_a59 in out nocopy JTF_NUMBER_TABLE
762: , p5_a60 in out nocopy JTF_VARCHAR2_TABLE_3000
763: , p5_a61 in out nocopy JTF_VARCHAR2_TABLE_100
764: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100
765: , x_job_return_status out nocopy VARCHAR2
940: , p_init_msg_list VARCHAR2
941: , p_commit VARCHAR2
942: , p_validation_level NUMBER
943: , p_module_type VARCHAR2
944: , p5_a0 in out nocopy JTF_NUMBER_TABLE
945: , p5_a1 in out nocopy JTF_NUMBER_TABLE
946: , p5_a2 in out nocopy JTF_NUMBER_TABLE
947: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
948: , p5_a4 in out nocopy JTF_NUMBER_TABLE
941: , p_commit VARCHAR2
942: , p_validation_level NUMBER
943: , p_module_type VARCHAR2
944: , p5_a0 in out nocopy JTF_NUMBER_TABLE
945: , p5_a1 in out nocopy JTF_NUMBER_TABLE
946: , p5_a2 in out nocopy JTF_NUMBER_TABLE
947: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
948: , p5_a4 in out nocopy JTF_NUMBER_TABLE
949: , p5_a5 in out nocopy JTF_DATE_TABLE
942: , p_validation_level NUMBER
943: , p_module_type VARCHAR2
944: , p5_a0 in out nocopy JTF_NUMBER_TABLE
945: , p5_a1 in out nocopy JTF_NUMBER_TABLE
946: , p5_a2 in out nocopy JTF_NUMBER_TABLE
947: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
948: , p5_a4 in out nocopy JTF_NUMBER_TABLE
949: , p5_a5 in out nocopy JTF_DATE_TABLE
950: , p5_a6 in out nocopy JTF_NUMBER_TABLE
944: , p5_a0 in out nocopy JTF_NUMBER_TABLE
945: , p5_a1 in out nocopy JTF_NUMBER_TABLE
946: , p5_a2 in out nocopy JTF_NUMBER_TABLE
947: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
948: , p5_a4 in out nocopy JTF_NUMBER_TABLE
949: , p5_a5 in out nocopy JTF_DATE_TABLE
950: , p5_a6 in out nocopy JTF_NUMBER_TABLE
951: , p5_a7 in out nocopy JTF_NUMBER_TABLE
952: , p5_a8 in out nocopy JTF_DATE_TABLE
946: , p5_a2 in out nocopy JTF_NUMBER_TABLE
947: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
948: , p5_a4 in out nocopy JTF_NUMBER_TABLE
949: , p5_a5 in out nocopy JTF_DATE_TABLE
950: , p5_a6 in out nocopy JTF_NUMBER_TABLE
951: , p5_a7 in out nocopy JTF_NUMBER_TABLE
952: , p5_a8 in out nocopy JTF_DATE_TABLE
953: , p5_a9 in out nocopy JTF_NUMBER_TABLE
954: , p5_a10 in out nocopy JTF_NUMBER_TABLE
947: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
948: , p5_a4 in out nocopy JTF_NUMBER_TABLE
949: , p5_a5 in out nocopy JTF_DATE_TABLE
950: , p5_a6 in out nocopy JTF_NUMBER_TABLE
951: , p5_a7 in out nocopy JTF_NUMBER_TABLE
952: , p5_a8 in out nocopy JTF_DATE_TABLE
953: , p5_a9 in out nocopy JTF_NUMBER_TABLE
954: , p5_a10 in out nocopy JTF_NUMBER_TABLE
955: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
949: , p5_a5 in out nocopy JTF_DATE_TABLE
950: , p5_a6 in out nocopy JTF_NUMBER_TABLE
951: , p5_a7 in out nocopy JTF_NUMBER_TABLE
952: , p5_a8 in out nocopy JTF_DATE_TABLE
953: , p5_a9 in out nocopy JTF_NUMBER_TABLE
954: , p5_a10 in out nocopy JTF_NUMBER_TABLE
955: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
956: , p5_a12 in out nocopy JTF_NUMBER_TABLE
957: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
950: , p5_a6 in out nocopy JTF_NUMBER_TABLE
951: , p5_a7 in out nocopy JTF_NUMBER_TABLE
952: , p5_a8 in out nocopy JTF_DATE_TABLE
953: , p5_a9 in out nocopy JTF_NUMBER_TABLE
954: , p5_a10 in out nocopy JTF_NUMBER_TABLE
955: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
956: , p5_a12 in out nocopy JTF_NUMBER_TABLE
957: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
958: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_300
952: , p5_a8 in out nocopy JTF_DATE_TABLE
953: , p5_a9 in out nocopy JTF_NUMBER_TABLE
954: , p5_a10 in out nocopy JTF_NUMBER_TABLE
955: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
956: , p5_a12 in out nocopy JTF_NUMBER_TABLE
957: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
958: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_300
959: , p5_a15 in out nocopy JTF_NUMBER_TABLE
960: , p5_a16 in out nocopy JTF_NUMBER_TABLE
955: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
956: , p5_a12 in out nocopy JTF_NUMBER_TABLE
957: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
958: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_300
959: , p5_a15 in out nocopy JTF_NUMBER_TABLE
960: , p5_a16 in out nocopy JTF_NUMBER_TABLE
961: , p5_a17 in out nocopy JTF_DATE_TABLE
962: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
963: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
956: , p5_a12 in out nocopy JTF_NUMBER_TABLE
957: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
958: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_300
959: , p5_a15 in out nocopy JTF_NUMBER_TABLE
960: , p5_a16 in out nocopy JTF_NUMBER_TABLE
961: , p5_a17 in out nocopy JTF_DATE_TABLE
962: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
963: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
964: , p5_a20 in out nocopy JTF_NUMBER_TABLE
960: , p5_a16 in out nocopy JTF_NUMBER_TABLE
961: , p5_a17 in out nocopy JTF_DATE_TABLE
962: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
963: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
964: , p5_a20 in out nocopy JTF_NUMBER_TABLE
965: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
966: , p5_a22 in out nocopy JTF_NUMBER_TABLE
967: , p5_a23 in out nocopy JTF_NUMBER_TABLE
968: , p5_a24 in out nocopy JTF_NUMBER_TABLE
962: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
963: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
964: , p5_a20 in out nocopy JTF_NUMBER_TABLE
965: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
966: , p5_a22 in out nocopy JTF_NUMBER_TABLE
967: , p5_a23 in out nocopy JTF_NUMBER_TABLE
968: , p5_a24 in out nocopy JTF_NUMBER_TABLE
969: , p5_a25 in out nocopy JTF_NUMBER_TABLE
970: , p5_a26 in out nocopy JTF_NUMBER_TABLE
963: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_100
964: , p5_a20 in out nocopy JTF_NUMBER_TABLE
965: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
966: , p5_a22 in out nocopy JTF_NUMBER_TABLE
967: , p5_a23 in out nocopy JTF_NUMBER_TABLE
968: , p5_a24 in out nocopy JTF_NUMBER_TABLE
969: , p5_a25 in out nocopy JTF_NUMBER_TABLE
970: , p5_a26 in out nocopy JTF_NUMBER_TABLE
971: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
964: , p5_a20 in out nocopy JTF_NUMBER_TABLE
965: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
966: , p5_a22 in out nocopy JTF_NUMBER_TABLE
967: , p5_a23 in out nocopy JTF_NUMBER_TABLE
968: , p5_a24 in out nocopy JTF_NUMBER_TABLE
969: , p5_a25 in out nocopy JTF_NUMBER_TABLE
970: , p5_a26 in out nocopy JTF_NUMBER_TABLE
971: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
972: , p5_a28 in out nocopy JTF_NUMBER_TABLE
965: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
966: , p5_a22 in out nocopy JTF_NUMBER_TABLE
967: , p5_a23 in out nocopy JTF_NUMBER_TABLE
968: , p5_a24 in out nocopy JTF_NUMBER_TABLE
969: , p5_a25 in out nocopy JTF_NUMBER_TABLE
970: , p5_a26 in out nocopy JTF_NUMBER_TABLE
971: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
972: , p5_a28 in out nocopy JTF_NUMBER_TABLE
973: , p5_a29 in out nocopy JTF_NUMBER_TABLE
966: , p5_a22 in out nocopy JTF_NUMBER_TABLE
967: , p5_a23 in out nocopy JTF_NUMBER_TABLE
968: , p5_a24 in out nocopy JTF_NUMBER_TABLE
969: , p5_a25 in out nocopy JTF_NUMBER_TABLE
970: , p5_a26 in out nocopy JTF_NUMBER_TABLE
971: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
972: , p5_a28 in out nocopy JTF_NUMBER_TABLE
973: , p5_a29 in out nocopy JTF_NUMBER_TABLE
974: , p5_a30 in out nocopy JTF_NUMBER_TABLE
968: , p5_a24 in out nocopy JTF_NUMBER_TABLE
969: , p5_a25 in out nocopy JTF_NUMBER_TABLE
970: , p5_a26 in out nocopy JTF_NUMBER_TABLE
971: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
972: , p5_a28 in out nocopy JTF_NUMBER_TABLE
973: , p5_a29 in out nocopy JTF_NUMBER_TABLE
974: , p5_a30 in out nocopy JTF_NUMBER_TABLE
975: , p5_a31 in out nocopy JTF_NUMBER_TABLE
976: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
969: , p5_a25 in out nocopy JTF_NUMBER_TABLE
970: , p5_a26 in out nocopy JTF_NUMBER_TABLE
971: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
972: , p5_a28 in out nocopy JTF_NUMBER_TABLE
973: , p5_a29 in out nocopy JTF_NUMBER_TABLE
974: , p5_a30 in out nocopy JTF_NUMBER_TABLE
975: , p5_a31 in out nocopy JTF_NUMBER_TABLE
976: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
977: , p5_a33 in out nocopy JTF_NUMBER_TABLE
970: , p5_a26 in out nocopy JTF_NUMBER_TABLE
971: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
972: , p5_a28 in out nocopy JTF_NUMBER_TABLE
973: , p5_a29 in out nocopy JTF_NUMBER_TABLE
974: , p5_a30 in out nocopy JTF_NUMBER_TABLE
975: , p5_a31 in out nocopy JTF_NUMBER_TABLE
976: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
977: , p5_a33 in out nocopy JTF_NUMBER_TABLE
978: , p5_a34 in out nocopy JTF_NUMBER_TABLE
971: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
972: , p5_a28 in out nocopy JTF_NUMBER_TABLE
973: , p5_a29 in out nocopy JTF_NUMBER_TABLE
974: , p5_a30 in out nocopy JTF_NUMBER_TABLE
975: , p5_a31 in out nocopy JTF_NUMBER_TABLE
976: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
977: , p5_a33 in out nocopy JTF_NUMBER_TABLE
978: , p5_a34 in out nocopy JTF_NUMBER_TABLE
979: , p5_a35 in out nocopy JTF_DATE_TABLE
973: , p5_a29 in out nocopy JTF_NUMBER_TABLE
974: , p5_a30 in out nocopy JTF_NUMBER_TABLE
975: , p5_a31 in out nocopy JTF_NUMBER_TABLE
976: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
977: , p5_a33 in out nocopy JTF_NUMBER_TABLE
978: , p5_a34 in out nocopy JTF_NUMBER_TABLE
979: , p5_a35 in out nocopy JTF_DATE_TABLE
980: , p5_a36 in out nocopy JTF_DATE_TABLE
981: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
974: , p5_a30 in out nocopy JTF_NUMBER_TABLE
975: , p5_a31 in out nocopy JTF_NUMBER_TABLE
976: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
977: , p5_a33 in out nocopy JTF_NUMBER_TABLE
978: , p5_a34 in out nocopy JTF_NUMBER_TABLE
979: , p5_a35 in out nocopy JTF_DATE_TABLE
980: , p5_a36 in out nocopy JTF_DATE_TABLE
981: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
982: , p5_a38 in out nocopy JTF_NUMBER_TABLE
978: , p5_a34 in out nocopy JTF_NUMBER_TABLE
979: , p5_a35 in out nocopy JTF_DATE_TABLE
980: , p5_a36 in out nocopy JTF_DATE_TABLE
981: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
982: , p5_a38 in out nocopy JTF_NUMBER_TABLE
983: , p5_a39 in out nocopy JTF_NUMBER_TABLE
984: , p5_a40 in out nocopy JTF_NUMBER_TABLE
985: , p5_a41 in out nocopy JTF_NUMBER_TABLE
986: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
979: , p5_a35 in out nocopy JTF_DATE_TABLE
980: , p5_a36 in out nocopy JTF_DATE_TABLE
981: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
982: , p5_a38 in out nocopy JTF_NUMBER_TABLE
983: , p5_a39 in out nocopy JTF_NUMBER_TABLE
984: , p5_a40 in out nocopy JTF_NUMBER_TABLE
985: , p5_a41 in out nocopy JTF_NUMBER_TABLE
986: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
987: , p5_a43 in out nocopy JTF_VARCHAR2_TABLE_100
980: , p5_a36 in out nocopy JTF_DATE_TABLE
981: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
982: , p5_a38 in out nocopy JTF_NUMBER_TABLE
983: , p5_a39 in out nocopy JTF_NUMBER_TABLE
984: , p5_a40 in out nocopy JTF_NUMBER_TABLE
985: , p5_a41 in out nocopy JTF_NUMBER_TABLE
986: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
987: , p5_a43 in out nocopy JTF_VARCHAR2_TABLE_100
988: , p5_a44 in out nocopy JTF_VARCHAR2_TABLE_200
981: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
982: , p5_a38 in out nocopy JTF_NUMBER_TABLE
983: , p5_a39 in out nocopy JTF_NUMBER_TABLE
984: , p5_a40 in out nocopy JTF_NUMBER_TABLE
985: , p5_a41 in out nocopy JTF_NUMBER_TABLE
986: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
987: , p5_a43 in out nocopy JTF_VARCHAR2_TABLE_100
988: , p5_a44 in out nocopy JTF_VARCHAR2_TABLE_200
989: , p5_a45 in out nocopy JTF_VARCHAR2_TABLE_200
999: , p5_a55 in out nocopy JTF_VARCHAR2_TABLE_200
1000: , p5_a56 in out nocopy JTF_VARCHAR2_TABLE_200
1001: , p5_a57 in out nocopy JTF_VARCHAR2_TABLE_200
1002: , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_200
1003: , p5_a59 in out nocopy JTF_NUMBER_TABLE
1004: , p5_a60 in out nocopy JTF_VARCHAR2_TABLE_3000
1005: , p5_a61 in out nocopy JTF_VARCHAR2_TABLE_100
1006: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100
1007: , x_return_status out nocopy VARCHAR2
1416: procedure material_notification(p_api_version NUMBER
1417: , p_init_msg_list VARCHAR2
1418: , p_commit VARCHAR2
1419: , p_validation_level NUMBER
1420: , p4_a0 JTF_NUMBER_TABLE
1421: , p4_a1 JTF_NUMBER_TABLE
1422: , p4_a2 JTF_NUMBER_TABLE
1423: , p4_a3 JTF_VARCHAR2_TABLE_100
1424: , p4_a4 JTF_NUMBER_TABLE
1417: , p_init_msg_list VARCHAR2
1418: , p_commit VARCHAR2
1419: , p_validation_level NUMBER
1420: , p4_a0 JTF_NUMBER_TABLE
1421: , p4_a1 JTF_NUMBER_TABLE
1422: , p4_a2 JTF_NUMBER_TABLE
1423: , p4_a3 JTF_VARCHAR2_TABLE_100
1424: , p4_a4 JTF_NUMBER_TABLE
1425: , p4_a5 JTF_DATE_TABLE
1418: , p_commit VARCHAR2
1419: , p_validation_level NUMBER
1420: , p4_a0 JTF_NUMBER_TABLE
1421: , p4_a1 JTF_NUMBER_TABLE
1422: , p4_a2 JTF_NUMBER_TABLE
1423: , p4_a3 JTF_VARCHAR2_TABLE_100
1424: , p4_a4 JTF_NUMBER_TABLE
1425: , p4_a5 JTF_DATE_TABLE
1426: , p4_a6 JTF_NUMBER_TABLE
1420: , p4_a0 JTF_NUMBER_TABLE
1421: , p4_a1 JTF_NUMBER_TABLE
1422: , p4_a2 JTF_NUMBER_TABLE
1423: , p4_a3 JTF_VARCHAR2_TABLE_100
1424: , p4_a4 JTF_NUMBER_TABLE
1425: , p4_a5 JTF_DATE_TABLE
1426: , p4_a6 JTF_NUMBER_TABLE
1427: , p4_a7 JTF_NUMBER_TABLE
1428: , p4_a8 JTF_DATE_TABLE
1422: , p4_a2 JTF_NUMBER_TABLE
1423: , p4_a3 JTF_VARCHAR2_TABLE_100
1424: , p4_a4 JTF_NUMBER_TABLE
1425: , p4_a5 JTF_DATE_TABLE
1426: , p4_a6 JTF_NUMBER_TABLE
1427: , p4_a7 JTF_NUMBER_TABLE
1428: , p4_a8 JTF_DATE_TABLE
1429: , p4_a9 JTF_NUMBER_TABLE
1430: , p4_a10 JTF_NUMBER_TABLE
1423: , p4_a3 JTF_VARCHAR2_TABLE_100
1424: , p4_a4 JTF_NUMBER_TABLE
1425: , p4_a5 JTF_DATE_TABLE
1426: , p4_a6 JTF_NUMBER_TABLE
1427: , p4_a7 JTF_NUMBER_TABLE
1428: , p4_a8 JTF_DATE_TABLE
1429: , p4_a9 JTF_NUMBER_TABLE
1430: , p4_a10 JTF_NUMBER_TABLE
1431: , p4_a11 JTF_VARCHAR2_TABLE_200
1425: , p4_a5 JTF_DATE_TABLE
1426: , p4_a6 JTF_NUMBER_TABLE
1427: , p4_a7 JTF_NUMBER_TABLE
1428: , p4_a8 JTF_DATE_TABLE
1429: , p4_a9 JTF_NUMBER_TABLE
1430: , p4_a10 JTF_NUMBER_TABLE
1431: , p4_a11 JTF_VARCHAR2_TABLE_200
1432: , p4_a12 JTF_NUMBER_TABLE
1433: , p4_a13 JTF_VARCHAR2_TABLE_100
1426: , p4_a6 JTF_NUMBER_TABLE
1427: , p4_a7 JTF_NUMBER_TABLE
1428: , p4_a8 JTF_DATE_TABLE
1429: , p4_a9 JTF_NUMBER_TABLE
1430: , p4_a10 JTF_NUMBER_TABLE
1431: , p4_a11 JTF_VARCHAR2_TABLE_200
1432: , p4_a12 JTF_NUMBER_TABLE
1433: , p4_a13 JTF_VARCHAR2_TABLE_100
1434: , p4_a14 JTF_VARCHAR2_TABLE_300
1428: , p4_a8 JTF_DATE_TABLE
1429: , p4_a9 JTF_NUMBER_TABLE
1430: , p4_a10 JTF_NUMBER_TABLE
1431: , p4_a11 JTF_VARCHAR2_TABLE_200
1432: , p4_a12 JTF_NUMBER_TABLE
1433: , p4_a13 JTF_VARCHAR2_TABLE_100
1434: , p4_a14 JTF_VARCHAR2_TABLE_300
1435: , p4_a15 JTF_NUMBER_TABLE
1436: , p4_a16 JTF_NUMBER_TABLE
1431: , p4_a11 JTF_VARCHAR2_TABLE_200
1432: , p4_a12 JTF_NUMBER_TABLE
1433: , p4_a13 JTF_VARCHAR2_TABLE_100
1434: , p4_a14 JTF_VARCHAR2_TABLE_300
1435: , p4_a15 JTF_NUMBER_TABLE
1436: , p4_a16 JTF_NUMBER_TABLE
1437: , p4_a17 JTF_DATE_TABLE
1438: , p4_a18 JTF_VARCHAR2_TABLE_100
1439: , p4_a19 JTF_VARCHAR2_TABLE_100
1432: , p4_a12 JTF_NUMBER_TABLE
1433: , p4_a13 JTF_VARCHAR2_TABLE_100
1434: , p4_a14 JTF_VARCHAR2_TABLE_300
1435: , p4_a15 JTF_NUMBER_TABLE
1436: , p4_a16 JTF_NUMBER_TABLE
1437: , p4_a17 JTF_DATE_TABLE
1438: , p4_a18 JTF_VARCHAR2_TABLE_100
1439: , p4_a19 JTF_VARCHAR2_TABLE_100
1440: , p4_a20 JTF_NUMBER_TABLE
1436: , p4_a16 JTF_NUMBER_TABLE
1437: , p4_a17 JTF_DATE_TABLE
1438: , p4_a18 JTF_VARCHAR2_TABLE_100
1439: , p4_a19 JTF_VARCHAR2_TABLE_100
1440: , p4_a20 JTF_NUMBER_TABLE
1441: , p4_a21 JTF_VARCHAR2_TABLE_100
1442: , p4_a22 JTF_NUMBER_TABLE
1443: , p4_a23 JTF_NUMBER_TABLE
1444: , p4_a24 JTF_NUMBER_TABLE
1438: , p4_a18 JTF_VARCHAR2_TABLE_100
1439: , p4_a19 JTF_VARCHAR2_TABLE_100
1440: , p4_a20 JTF_NUMBER_TABLE
1441: , p4_a21 JTF_VARCHAR2_TABLE_100
1442: , p4_a22 JTF_NUMBER_TABLE
1443: , p4_a23 JTF_NUMBER_TABLE
1444: , p4_a24 JTF_NUMBER_TABLE
1445: , p4_a25 JTF_NUMBER_TABLE
1446: , p4_a26 JTF_NUMBER_TABLE
1439: , p4_a19 JTF_VARCHAR2_TABLE_100
1440: , p4_a20 JTF_NUMBER_TABLE
1441: , p4_a21 JTF_VARCHAR2_TABLE_100
1442: , p4_a22 JTF_NUMBER_TABLE
1443: , p4_a23 JTF_NUMBER_TABLE
1444: , p4_a24 JTF_NUMBER_TABLE
1445: , p4_a25 JTF_NUMBER_TABLE
1446: , p4_a26 JTF_NUMBER_TABLE
1447: , p4_a27 JTF_VARCHAR2_TABLE_100
1440: , p4_a20 JTF_NUMBER_TABLE
1441: , p4_a21 JTF_VARCHAR2_TABLE_100
1442: , p4_a22 JTF_NUMBER_TABLE
1443: , p4_a23 JTF_NUMBER_TABLE
1444: , p4_a24 JTF_NUMBER_TABLE
1445: , p4_a25 JTF_NUMBER_TABLE
1446: , p4_a26 JTF_NUMBER_TABLE
1447: , p4_a27 JTF_VARCHAR2_TABLE_100
1448: , p4_a28 JTF_NUMBER_TABLE
1441: , p4_a21 JTF_VARCHAR2_TABLE_100
1442: , p4_a22 JTF_NUMBER_TABLE
1443: , p4_a23 JTF_NUMBER_TABLE
1444: , p4_a24 JTF_NUMBER_TABLE
1445: , p4_a25 JTF_NUMBER_TABLE
1446: , p4_a26 JTF_NUMBER_TABLE
1447: , p4_a27 JTF_VARCHAR2_TABLE_100
1448: , p4_a28 JTF_NUMBER_TABLE
1449: , p4_a29 JTF_NUMBER_TABLE
1442: , p4_a22 JTF_NUMBER_TABLE
1443: , p4_a23 JTF_NUMBER_TABLE
1444: , p4_a24 JTF_NUMBER_TABLE
1445: , p4_a25 JTF_NUMBER_TABLE
1446: , p4_a26 JTF_NUMBER_TABLE
1447: , p4_a27 JTF_VARCHAR2_TABLE_100
1448: , p4_a28 JTF_NUMBER_TABLE
1449: , p4_a29 JTF_NUMBER_TABLE
1450: , p4_a30 JTF_NUMBER_TABLE
1444: , p4_a24 JTF_NUMBER_TABLE
1445: , p4_a25 JTF_NUMBER_TABLE
1446: , p4_a26 JTF_NUMBER_TABLE
1447: , p4_a27 JTF_VARCHAR2_TABLE_100
1448: , p4_a28 JTF_NUMBER_TABLE
1449: , p4_a29 JTF_NUMBER_TABLE
1450: , p4_a30 JTF_NUMBER_TABLE
1451: , p4_a31 JTF_NUMBER_TABLE
1452: , p4_a32 JTF_VARCHAR2_TABLE_100
1445: , p4_a25 JTF_NUMBER_TABLE
1446: , p4_a26 JTF_NUMBER_TABLE
1447: , p4_a27 JTF_VARCHAR2_TABLE_100
1448: , p4_a28 JTF_NUMBER_TABLE
1449: , p4_a29 JTF_NUMBER_TABLE
1450: , p4_a30 JTF_NUMBER_TABLE
1451: , p4_a31 JTF_NUMBER_TABLE
1452: , p4_a32 JTF_VARCHAR2_TABLE_100
1453: , p4_a33 JTF_NUMBER_TABLE
1446: , p4_a26 JTF_NUMBER_TABLE
1447: , p4_a27 JTF_VARCHAR2_TABLE_100
1448: , p4_a28 JTF_NUMBER_TABLE
1449: , p4_a29 JTF_NUMBER_TABLE
1450: , p4_a30 JTF_NUMBER_TABLE
1451: , p4_a31 JTF_NUMBER_TABLE
1452: , p4_a32 JTF_VARCHAR2_TABLE_100
1453: , p4_a33 JTF_NUMBER_TABLE
1454: , p4_a34 JTF_NUMBER_TABLE
1447: , p4_a27 JTF_VARCHAR2_TABLE_100
1448: , p4_a28 JTF_NUMBER_TABLE
1449: , p4_a29 JTF_NUMBER_TABLE
1450: , p4_a30 JTF_NUMBER_TABLE
1451: , p4_a31 JTF_NUMBER_TABLE
1452: , p4_a32 JTF_VARCHAR2_TABLE_100
1453: , p4_a33 JTF_NUMBER_TABLE
1454: , p4_a34 JTF_NUMBER_TABLE
1455: , p4_a35 JTF_DATE_TABLE
1449: , p4_a29 JTF_NUMBER_TABLE
1450: , p4_a30 JTF_NUMBER_TABLE
1451: , p4_a31 JTF_NUMBER_TABLE
1452: , p4_a32 JTF_VARCHAR2_TABLE_100
1453: , p4_a33 JTF_NUMBER_TABLE
1454: , p4_a34 JTF_NUMBER_TABLE
1455: , p4_a35 JTF_DATE_TABLE
1456: , p4_a36 JTF_DATE_TABLE
1457: , p4_a37 JTF_VARCHAR2_TABLE_100
1450: , p4_a30 JTF_NUMBER_TABLE
1451: , p4_a31 JTF_NUMBER_TABLE
1452: , p4_a32 JTF_VARCHAR2_TABLE_100
1453: , p4_a33 JTF_NUMBER_TABLE
1454: , p4_a34 JTF_NUMBER_TABLE
1455: , p4_a35 JTF_DATE_TABLE
1456: , p4_a36 JTF_DATE_TABLE
1457: , p4_a37 JTF_VARCHAR2_TABLE_100
1458: , p4_a38 JTF_NUMBER_TABLE
1454: , p4_a34 JTF_NUMBER_TABLE
1455: , p4_a35 JTF_DATE_TABLE
1456: , p4_a36 JTF_DATE_TABLE
1457: , p4_a37 JTF_VARCHAR2_TABLE_100
1458: , p4_a38 JTF_NUMBER_TABLE
1459: , p4_a39 JTF_NUMBER_TABLE
1460: , p4_a40 JTF_NUMBER_TABLE
1461: , p4_a41 JTF_NUMBER_TABLE
1462: , p4_a42 JTF_VARCHAR2_TABLE_100
1455: , p4_a35 JTF_DATE_TABLE
1456: , p4_a36 JTF_DATE_TABLE
1457: , p4_a37 JTF_VARCHAR2_TABLE_100
1458: , p4_a38 JTF_NUMBER_TABLE
1459: , p4_a39 JTF_NUMBER_TABLE
1460: , p4_a40 JTF_NUMBER_TABLE
1461: , p4_a41 JTF_NUMBER_TABLE
1462: , p4_a42 JTF_VARCHAR2_TABLE_100
1463: , p4_a43 JTF_VARCHAR2_TABLE_100
1456: , p4_a36 JTF_DATE_TABLE
1457: , p4_a37 JTF_VARCHAR2_TABLE_100
1458: , p4_a38 JTF_NUMBER_TABLE
1459: , p4_a39 JTF_NUMBER_TABLE
1460: , p4_a40 JTF_NUMBER_TABLE
1461: , p4_a41 JTF_NUMBER_TABLE
1462: , p4_a42 JTF_VARCHAR2_TABLE_100
1463: , p4_a43 JTF_VARCHAR2_TABLE_100
1464: , p4_a44 JTF_VARCHAR2_TABLE_200
1457: , p4_a37 JTF_VARCHAR2_TABLE_100
1458: , p4_a38 JTF_NUMBER_TABLE
1459: , p4_a39 JTF_NUMBER_TABLE
1460: , p4_a40 JTF_NUMBER_TABLE
1461: , p4_a41 JTF_NUMBER_TABLE
1462: , p4_a42 JTF_VARCHAR2_TABLE_100
1463: , p4_a43 JTF_VARCHAR2_TABLE_100
1464: , p4_a44 JTF_VARCHAR2_TABLE_200
1465: , p4_a45 JTF_VARCHAR2_TABLE_200
1475: , p4_a55 JTF_VARCHAR2_TABLE_200
1476: , p4_a56 JTF_VARCHAR2_TABLE_200
1477: , p4_a57 JTF_VARCHAR2_TABLE_200
1478: , p4_a58 JTF_VARCHAR2_TABLE_200
1479: , p4_a59 JTF_NUMBER_TABLE
1480: , p4_a60 JTF_VARCHAR2_TABLE_3000
1481: , p4_a61 JTF_VARCHAR2_TABLE_100
1482: , p4_a62 JTF_VARCHAR2_TABLE_100
1483: , x_return_status out nocopy VARCHAR2