10: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
11: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
12: return d;
13: end;
14: procedure rosetta_table_copy_in_p1(t out nocopy ahl_rm_material_as_pvt.material_req_tbl_type, a0 JTF_NUMBER_TABLE
15: , a1 JTF_NUMBER_TABLE
16: , a2 JTF_NUMBER_TABLE
17: , a3 JTF_VARCHAR2_TABLE_100
18: , a4 JTF_VARCHAR2_TABLE_100
11: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
12: return d;
13: end;
14: procedure rosetta_table_copy_in_p1(t out nocopy ahl_rm_material_as_pvt.material_req_tbl_type, a0 JTF_NUMBER_TABLE
15: , a1 JTF_NUMBER_TABLE
16: , a2 JTF_NUMBER_TABLE
17: , a3 JTF_VARCHAR2_TABLE_100
18: , a4 JTF_VARCHAR2_TABLE_100
19: , a5 JTF_NUMBER_TABLE
12: return d;
13: end;
14: procedure rosetta_table_copy_in_p1(t out nocopy ahl_rm_material_as_pvt.material_req_tbl_type, a0 JTF_NUMBER_TABLE
15: , a1 JTF_NUMBER_TABLE
16: , a2 JTF_NUMBER_TABLE
17: , a3 JTF_VARCHAR2_TABLE_100
18: , a4 JTF_VARCHAR2_TABLE_100
19: , a5 JTF_NUMBER_TABLE
20: , a6 JTF_NUMBER_TABLE
15: , a1 JTF_NUMBER_TABLE
16: , a2 JTF_NUMBER_TABLE
17: , a3 JTF_VARCHAR2_TABLE_100
18: , a4 JTF_VARCHAR2_TABLE_100
19: , a5 JTF_NUMBER_TABLE
20: , a6 JTF_NUMBER_TABLE
21: , a7 JTF_VARCHAR2_TABLE_100
22: , a8 JTF_VARCHAR2_TABLE_100
23: , a9 JTF_NUMBER_TABLE
16: , a2 JTF_NUMBER_TABLE
17: , a3 JTF_VARCHAR2_TABLE_100
18: , a4 JTF_VARCHAR2_TABLE_100
19: , a5 JTF_NUMBER_TABLE
20: , a6 JTF_NUMBER_TABLE
21: , a7 JTF_VARCHAR2_TABLE_100
22: , a8 JTF_VARCHAR2_TABLE_100
23: , a9 JTF_NUMBER_TABLE
24: , a10 JTF_VARCHAR2_TABLE_100
19: , a5 JTF_NUMBER_TABLE
20: , a6 JTF_NUMBER_TABLE
21: , a7 JTF_VARCHAR2_TABLE_100
22: , a8 JTF_VARCHAR2_TABLE_100
23: , a9 JTF_NUMBER_TABLE
24: , a10 JTF_VARCHAR2_TABLE_100
25: , a11 JTF_VARCHAR2_TABLE_200
26: , a12 JTF_VARCHAR2_TABLE_200
27: , a13 JTF_VARCHAR2_TABLE_200
37: , a23 JTF_VARCHAR2_TABLE_200
38: , a24 JTF_VARCHAR2_TABLE_200
39: , a25 JTF_VARCHAR2_TABLE_200
40: , a26 JTF_DATE_TABLE
41: , a27 JTF_NUMBER_TABLE
42: , a28 JTF_DATE_TABLE
43: , a29 JTF_NUMBER_TABLE
44: , a30 JTF_NUMBER_TABLE
45: , a31 JTF_VARCHAR2_TABLE_100
39: , a25 JTF_VARCHAR2_TABLE_200
40: , a26 JTF_DATE_TABLE
41: , a27 JTF_NUMBER_TABLE
42: , a28 JTF_DATE_TABLE
43: , a29 JTF_NUMBER_TABLE
44: , a30 JTF_NUMBER_TABLE
45: , a31 JTF_VARCHAR2_TABLE_100
46: , a32 JTF_VARCHAR2_TABLE_4000
47: , a33 JTF_NUMBER_TABLE
40: , a26 JTF_DATE_TABLE
41: , a27 JTF_NUMBER_TABLE
42: , a28 JTF_DATE_TABLE
43: , a29 JTF_NUMBER_TABLE
44: , a30 JTF_NUMBER_TABLE
45: , a31 JTF_VARCHAR2_TABLE_100
46: , a32 JTF_VARCHAR2_TABLE_4000
47: , a33 JTF_NUMBER_TABLE
48: , a34 JTF_NUMBER_TABLE
43: , a29 JTF_NUMBER_TABLE
44: , a30 JTF_NUMBER_TABLE
45: , a31 JTF_VARCHAR2_TABLE_100
46: , a32 JTF_VARCHAR2_TABLE_4000
47: , a33 JTF_NUMBER_TABLE
48: , a34 JTF_NUMBER_TABLE
49: , a35 JTF_VARCHAR2_TABLE_100
50: , a36 JTF_NUMBER_TABLE
51: , a37 JTF_NUMBER_TABLE
44: , a30 JTF_NUMBER_TABLE
45: , a31 JTF_VARCHAR2_TABLE_100
46: , a32 JTF_VARCHAR2_TABLE_4000
47: , a33 JTF_NUMBER_TABLE
48: , a34 JTF_NUMBER_TABLE
49: , a35 JTF_VARCHAR2_TABLE_100
50: , a36 JTF_NUMBER_TABLE
51: , a37 JTF_NUMBER_TABLE
52: , a38 JTF_VARCHAR2_TABLE_100
46: , a32 JTF_VARCHAR2_TABLE_4000
47: , a33 JTF_NUMBER_TABLE
48: , a34 JTF_NUMBER_TABLE
49: , a35 JTF_VARCHAR2_TABLE_100
50: , a36 JTF_NUMBER_TABLE
51: , a37 JTF_NUMBER_TABLE
52: , a38 JTF_VARCHAR2_TABLE_100
53: , a39 JTF_VARCHAR2_TABLE_100
54: , a40 JTF_VARCHAR2_TABLE_100
47: , a33 JTF_NUMBER_TABLE
48: , a34 JTF_NUMBER_TABLE
49: , a35 JTF_VARCHAR2_TABLE_100
50: , a36 JTF_NUMBER_TABLE
51: , a37 JTF_NUMBER_TABLE
52: , a38 JTF_VARCHAR2_TABLE_100
53: , a39 JTF_VARCHAR2_TABLE_100
54: , a40 JTF_VARCHAR2_TABLE_100
55: , a41 JTF_NUMBER_TABLE
51: , a37 JTF_NUMBER_TABLE
52: , a38 JTF_VARCHAR2_TABLE_100
53: , a39 JTF_VARCHAR2_TABLE_100
54: , a40 JTF_VARCHAR2_TABLE_100
55: , a41 JTF_NUMBER_TABLE
56: , a42 JTF_VARCHAR2_TABLE_100
57: , a43 JTF_NUMBER_TABLE
58: ) as
59: ddindx binary_integer; indx binary_integer;
53: , a39 JTF_VARCHAR2_TABLE_100
54: , a40 JTF_VARCHAR2_TABLE_100
55: , a41 JTF_NUMBER_TABLE
56: , a42 JTF_VARCHAR2_TABLE_100
57: , a43 JTF_NUMBER_TABLE
58: ) as
59: ddindx binary_integer; indx binary_integer;
60: begin
61: if a0 is not null and a0.count > 0 then
115: end loop;
116: end if;
117: end if;
118: end rosetta_table_copy_in_p1;
119: procedure rosetta_table_copy_out_p1(t ahl_rm_material_as_pvt.material_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_NUMBER_TABLE
122: , a3 out nocopy JTF_VARCHAR2_TABLE_100
123: , a4 out nocopy JTF_VARCHAR2_TABLE_100
116: end if;
117: end if;
118: end rosetta_table_copy_in_p1;
119: procedure rosetta_table_copy_out_p1(t ahl_rm_material_as_pvt.material_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_NUMBER_TABLE
122: , a3 out nocopy JTF_VARCHAR2_TABLE_100
123: , a4 out nocopy JTF_VARCHAR2_TABLE_100
124: , a5 out nocopy JTF_NUMBER_TABLE
117: end if;
118: end rosetta_table_copy_in_p1;
119: procedure rosetta_table_copy_out_p1(t ahl_rm_material_as_pvt.material_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_NUMBER_TABLE
122: , a3 out nocopy JTF_VARCHAR2_TABLE_100
123: , a4 out nocopy JTF_VARCHAR2_TABLE_100
124: , a5 out nocopy JTF_NUMBER_TABLE
125: , a6 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_NUMBER_TABLE
122: , a3 out nocopy JTF_VARCHAR2_TABLE_100
123: , a4 out nocopy JTF_VARCHAR2_TABLE_100
124: , a5 out nocopy JTF_NUMBER_TABLE
125: , a6 out nocopy JTF_NUMBER_TABLE
126: , a7 out nocopy JTF_VARCHAR2_TABLE_100
127: , a8 out nocopy JTF_VARCHAR2_TABLE_100
128: , a9 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_NUMBER_TABLE
122: , a3 out nocopy JTF_VARCHAR2_TABLE_100
123: , a4 out nocopy JTF_VARCHAR2_TABLE_100
124: , a5 out nocopy JTF_NUMBER_TABLE
125: , a6 out nocopy JTF_NUMBER_TABLE
126: , a7 out nocopy JTF_VARCHAR2_TABLE_100
127: , a8 out nocopy JTF_VARCHAR2_TABLE_100
128: , a9 out nocopy JTF_NUMBER_TABLE
129: , a10 out nocopy JTF_VARCHAR2_TABLE_100
124: , a5 out nocopy JTF_NUMBER_TABLE
125: , a6 out nocopy JTF_NUMBER_TABLE
126: , a7 out nocopy JTF_VARCHAR2_TABLE_100
127: , a8 out nocopy JTF_VARCHAR2_TABLE_100
128: , a9 out nocopy JTF_NUMBER_TABLE
129: , a10 out nocopy JTF_VARCHAR2_TABLE_100
130: , a11 out nocopy JTF_VARCHAR2_TABLE_200
131: , a12 out nocopy JTF_VARCHAR2_TABLE_200
132: , a13 out nocopy JTF_VARCHAR2_TABLE_200
142: , a23 out nocopy JTF_VARCHAR2_TABLE_200
143: , a24 out nocopy JTF_VARCHAR2_TABLE_200
144: , a25 out nocopy JTF_VARCHAR2_TABLE_200
145: , a26 out nocopy JTF_DATE_TABLE
146: , a27 out nocopy JTF_NUMBER_TABLE
147: , a28 out nocopy JTF_DATE_TABLE
148: , a29 out nocopy JTF_NUMBER_TABLE
149: , a30 out nocopy JTF_NUMBER_TABLE
150: , a31 out nocopy JTF_VARCHAR2_TABLE_100
144: , a25 out nocopy JTF_VARCHAR2_TABLE_200
145: , a26 out nocopy JTF_DATE_TABLE
146: , a27 out nocopy JTF_NUMBER_TABLE
147: , a28 out nocopy JTF_DATE_TABLE
148: , a29 out nocopy JTF_NUMBER_TABLE
149: , a30 out nocopy JTF_NUMBER_TABLE
150: , a31 out nocopy JTF_VARCHAR2_TABLE_100
151: , a32 out nocopy JTF_VARCHAR2_TABLE_4000
152: , a33 out nocopy JTF_NUMBER_TABLE
145: , a26 out nocopy JTF_DATE_TABLE
146: , a27 out nocopy JTF_NUMBER_TABLE
147: , a28 out nocopy JTF_DATE_TABLE
148: , a29 out nocopy JTF_NUMBER_TABLE
149: , a30 out nocopy JTF_NUMBER_TABLE
150: , a31 out nocopy JTF_VARCHAR2_TABLE_100
151: , a32 out nocopy JTF_VARCHAR2_TABLE_4000
152: , a33 out nocopy JTF_NUMBER_TABLE
153: , a34 out nocopy JTF_NUMBER_TABLE
148: , a29 out nocopy JTF_NUMBER_TABLE
149: , a30 out nocopy JTF_NUMBER_TABLE
150: , a31 out nocopy JTF_VARCHAR2_TABLE_100
151: , a32 out nocopy JTF_VARCHAR2_TABLE_4000
152: , a33 out nocopy JTF_NUMBER_TABLE
153: , a34 out nocopy JTF_NUMBER_TABLE
154: , a35 out nocopy JTF_VARCHAR2_TABLE_100
155: , a36 out nocopy JTF_NUMBER_TABLE
156: , a37 out nocopy JTF_NUMBER_TABLE
149: , a30 out nocopy JTF_NUMBER_TABLE
150: , a31 out nocopy JTF_VARCHAR2_TABLE_100
151: , a32 out nocopy JTF_VARCHAR2_TABLE_4000
152: , a33 out nocopy JTF_NUMBER_TABLE
153: , a34 out nocopy JTF_NUMBER_TABLE
154: , a35 out nocopy JTF_VARCHAR2_TABLE_100
155: , a36 out nocopy JTF_NUMBER_TABLE
156: , a37 out nocopy JTF_NUMBER_TABLE
157: , a38 out nocopy JTF_VARCHAR2_TABLE_100
151: , a32 out nocopy JTF_VARCHAR2_TABLE_4000
152: , a33 out nocopy JTF_NUMBER_TABLE
153: , a34 out nocopy JTF_NUMBER_TABLE
154: , a35 out nocopy JTF_VARCHAR2_TABLE_100
155: , a36 out nocopy JTF_NUMBER_TABLE
156: , a37 out nocopy JTF_NUMBER_TABLE
157: , a38 out nocopy JTF_VARCHAR2_TABLE_100
158: , a39 out nocopy JTF_VARCHAR2_TABLE_100
159: , a40 out nocopy JTF_VARCHAR2_TABLE_100
152: , a33 out nocopy JTF_NUMBER_TABLE
153: , a34 out nocopy JTF_NUMBER_TABLE
154: , a35 out nocopy JTF_VARCHAR2_TABLE_100
155: , a36 out nocopy JTF_NUMBER_TABLE
156: , a37 out nocopy JTF_NUMBER_TABLE
157: , a38 out nocopy JTF_VARCHAR2_TABLE_100
158: , a39 out nocopy JTF_VARCHAR2_TABLE_100
159: , a40 out nocopy JTF_VARCHAR2_TABLE_100
160: , a41 out nocopy JTF_NUMBER_TABLE
156: , a37 out nocopy JTF_NUMBER_TABLE
157: , a38 out nocopy JTF_VARCHAR2_TABLE_100
158: , a39 out nocopy JTF_VARCHAR2_TABLE_100
159: , a40 out nocopy JTF_VARCHAR2_TABLE_100
160: , a41 out nocopy JTF_NUMBER_TABLE
161: , a42 out nocopy JTF_VARCHAR2_TABLE_100
162: , a43 out nocopy JTF_NUMBER_TABLE
163: ) as
164: ddindx binary_integer; indx binary_integer;
158: , a39 out nocopy JTF_VARCHAR2_TABLE_100
159: , a40 out nocopy JTF_VARCHAR2_TABLE_100
160: , a41 out nocopy JTF_NUMBER_TABLE
161: , a42 out nocopy JTF_VARCHAR2_TABLE_100
162: , a43 out nocopy JTF_NUMBER_TABLE
163: ) as
164: ddindx binary_integer; indx binary_integer;
165: begin
166: if t is null or t.count = 0 then
163: ) as
164: ddindx binary_integer; indx binary_integer;
165: begin
166: if t is null or t.count = 0 then
167: a0 := JTF_NUMBER_TABLE();
168: a1 := JTF_NUMBER_TABLE();
169: a2 := JTF_NUMBER_TABLE();
170: a3 := JTF_VARCHAR2_TABLE_100();
171: a4 := JTF_VARCHAR2_TABLE_100();
164: ddindx binary_integer; indx binary_integer;
165: begin
166: if t is null or t.count = 0 then
167: a0 := JTF_NUMBER_TABLE();
168: a1 := JTF_NUMBER_TABLE();
169: a2 := JTF_NUMBER_TABLE();
170: a3 := JTF_VARCHAR2_TABLE_100();
171: a4 := JTF_VARCHAR2_TABLE_100();
172: a5 := JTF_NUMBER_TABLE();
165: begin
166: if t is null or t.count = 0 then
167: a0 := JTF_NUMBER_TABLE();
168: a1 := JTF_NUMBER_TABLE();
169: a2 := JTF_NUMBER_TABLE();
170: a3 := JTF_VARCHAR2_TABLE_100();
171: a4 := JTF_VARCHAR2_TABLE_100();
172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_NUMBER_TABLE();
168: a1 := JTF_NUMBER_TABLE();
169: a2 := JTF_NUMBER_TABLE();
170: a3 := JTF_VARCHAR2_TABLE_100();
171: a4 := JTF_VARCHAR2_TABLE_100();
172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_NUMBER_TABLE();
174: a7 := JTF_VARCHAR2_TABLE_100();
175: a8 := JTF_VARCHAR2_TABLE_100();
176: a9 := JTF_NUMBER_TABLE();
169: a2 := JTF_NUMBER_TABLE();
170: a3 := JTF_VARCHAR2_TABLE_100();
171: a4 := JTF_VARCHAR2_TABLE_100();
172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_NUMBER_TABLE();
174: a7 := JTF_VARCHAR2_TABLE_100();
175: a8 := JTF_VARCHAR2_TABLE_100();
176: a9 := JTF_NUMBER_TABLE();
177: a10 := JTF_VARCHAR2_TABLE_100();
172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_NUMBER_TABLE();
174: a7 := JTF_VARCHAR2_TABLE_100();
175: a8 := JTF_VARCHAR2_TABLE_100();
176: a9 := JTF_NUMBER_TABLE();
177: a10 := JTF_VARCHAR2_TABLE_100();
178: a11 := JTF_VARCHAR2_TABLE_200();
179: a12 := JTF_VARCHAR2_TABLE_200();
180: a13 := JTF_VARCHAR2_TABLE_200();
190: a23 := JTF_VARCHAR2_TABLE_200();
191: a24 := JTF_VARCHAR2_TABLE_200();
192: a25 := JTF_VARCHAR2_TABLE_200();
193: a26 := JTF_DATE_TABLE();
194: a27 := JTF_NUMBER_TABLE();
195: a28 := JTF_DATE_TABLE();
196: a29 := JTF_NUMBER_TABLE();
197: a30 := JTF_NUMBER_TABLE();
198: a31 := JTF_VARCHAR2_TABLE_100();
192: a25 := JTF_VARCHAR2_TABLE_200();
193: a26 := JTF_DATE_TABLE();
194: a27 := JTF_NUMBER_TABLE();
195: a28 := JTF_DATE_TABLE();
196: a29 := JTF_NUMBER_TABLE();
197: a30 := JTF_NUMBER_TABLE();
198: a31 := JTF_VARCHAR2_TABLE_100();
199: a32 := JTF_VARCHAR2_TABLE_4000();
200: a33 := JTF_NUMBER_TABLE();
193: a26 := JTF_DATE_TABLE();
194: a27 := JTF_NUMBER_TABLE();
195: a28 := JTF_DATE_TABLE();
196: a29 := JTF_NUMBER_TABLE();
197: a30 := JTF_NUMBER_TABLE();
198: a31 := JTF_VARCHAR2_TABLE_100();
199: a32 := JTF_VARCHAR2_TABLE_4000();
200: a33 := JTF_NUMBER_TABLE();
201: a34 := JTF_NUMBER_TABLE();
196: a29 := JTF_NUMBER_TABLE();
197: a30 := JTF_NUMBER_TABLE();
198: a31 := JTF_VARCHAR2_TABLE_100();
199: a32 := JTF_VARCHAR2_TABLE_4000();
200: a33 := JTF_NUMBER_TABLE();
201: a34 := JTF_NUMBER_TABLE();
202: a35 := JTF_VARCHAR2_TABLE_100();
203: a36 := JTF_NUMBER_TABLE();
204: a37 := JTF_NUMBER_TABLE();
197: a30 := JTF_NUMBER_TABLE();
198: a31 := JTF_VARCHAR2_TABLE_100();
199: a32 := JTF_VARCHAR2_TABLE_4000();
200: a33 := JTF_NUMBER_TABLE();
201: a34 := JTF_NUMBER_TABLE();
202: a35 := JTF_VARCHAR2_TABLE_100();
203: a36 := JTF_NUMBER_TABLE();
204: a37 := JTF_NUMBER_TABLE();
205: a38 := JTF_VARCHAR2_TABLE_100();
199: a32 := JTF_VARCHAR2_TABLE_4000();
200: a33 := JTF_NUMBER_TABLE();
201: a34 := JTF_NUMBER_TABLE();
202: a35 := JTF_VARCHAR2_TABLE_100();
203: a36 := JTF_NUMBER_TABLE();
204: a37 := JTF_NUMBER_TABLE();
205: a38 := JTF_VARCHAR2_TABLE_100();
206: a39 := JTF_VARCHAR2_TABLE_100();
207: a40 := JTF_VARCHAR2_TABLE_100();
200: a33 := JTF_NUMBER_TABLE();
201: a34 := JTF_NUMBER_TABLE();
202: a35 := JTF_VARCHAR2_TABLE_100();
203: a36 := JTF_NUMBER_TABLE();
204: a37 := JTF_NUMBER_TABLE();
205: a38 := JTF_VARCHAR2_TABLE_100();
206: a39 := JTF_VARCHAR2_TABLE_100();
207: a40 := JTF_VARCHAR2_TABLE_100();
208: a41 := JTF_NUMBER_TABLE();
204: a37 := JTF_NUMBER_TABLE();
205: a38 := JTF_VARCHAR2_TABLE_100();
206: a39 := JTF_VARCHAR2_TABLE_100();
207: a40 := JTF_VARCHAR2_TABLE_100();
208: a41 := JTF_NUMBER_TABLE();
209: a42 := JTF_VARCHAR2_TABLE_100();
210: a43 := JTF_NUMBER_TABLE();
211: else
212: a0 := JTF_NUMBER_TABLE();
206: a39 := JTF_VARCHAR2_TABLE_100();
207: a40 := JTF_VARCHAR2_TABLE_100();
208: a41 := JTF_NUMBER_TABLE();
209: a42 := JTF_VARCHAR2_TABLE_100();
210: a43 := JTF_NUMBER_TABLE();
211: else
212: a0 := JTF_NUMBER_TABLE();
213: a1 := JTF_NUMBER_TABLE();
214: a2 := JTF_NUMBER_TABLE();
208: a41 := JTF_NUMBER_TABLE();
209: a42 := JTF_VARCHAR2_TABLE_100();
210: a43 := JTF_NUMBER_TABLE();
211: else
212: a0 := JTF_NUMBER_TABLE();
213: a1 := JTF_NUMBER_TABLE();
214: a2 := JTF_NUMBER_TABLE();
215: a3 := JTF_VARCHAR2_TABLE_100();
216: a4 := JTF_VARCHAR2_TABLE_100();
209: a42 := JTF_VARCHAR2_TABLE_100();
210: a43 := JTF_NUMBER_TABLE();
211: else
212: a0 := JTF_NUMBER_TABLE();
213: a1 := JTF_NUMBER_TABLE();
214: a2 := JTF_NUMBER_TABLE();
215: a3 := JTF_VARCHAR2_TABLE_100();
216: a4 := JTF_VARCHAR2_TABLE_100();
217: a5 := JTF_NUMBER_TABLE();
210: a43 := JTF_NUMBER_TABLE();
211: else
212: a0 := JTF_NUMBER_TABLE();
213: a1 := JTF_NUMBER_TABLE();
214: a2 := JTF_NUMBER_TABLE();
215: a3 := JTF_VARCHAR2_TABLE_100();
216: a4 := JTF_VARCHAR2_TABLE_100();
217: a5 := JTF_NUMBER_TABLE();
218: a6 := JTF_NUMBER_TABLE();
213: a1 := JTF_NUMBER_TABLE();
214: a2 := JTF_NUMBER_TABLE();
215: a3 := JTF_VARCHAR2_TABLE_100();
216: a4 := JTF_VARCHAR2_TABLE_100();
217: a5 := JTF_NUMBER_TABLE();
218: a6 := JTF_NUMBER_TABLE();
219: a7 := JTF_VARCHAR2_TABLE_100();
220: a8 := JTF_VARCHAR2_TABLE_100();
221: a9 := JTF_NUMBER_TABLE();
214: a2 := JTF_NUMBER_TABLE();
215: a3 := JTF_VARCHAR2_TABLE_100();
216: a4 := JTF_VARCHAR2_TABLE_100();
217: a5 := JTF_NUMBER_TABLE();
218: a6 := JTF_NUMBER_TABLE();
219: a7 := JTF_VARCHAR2_TABLE_100();
220: a8 := JTF_VARCHAR2_TABLE_100();
221: a9 := JTF_NUMBER_TABLE();
222: a10 := JTF_VARCHAR2_TABLE_100();
217: a5 := JTF_NUMBER_TABLE();
218: a6 := JTF_NUMBER_TABLE();
219: a7 := JTF_VARCHAR2_TABLE_100();
220: a8 := JTF_VARCHAR2_TABLE_100();
221: a9 := JTF_NUMBER_TABLE();
222: a10 := JTF_VARCHAR2_TABLE_100();
223: a11 := JTF_VARCHAR2_TABLE_200();
224: a12 := JTF_VARCHAR2_TABLE_200();
225: a13 := JTF_VARCHAR2_TABLE_200();
235: a23 := JTF_VARCHAR2_TABLE_200();
236: a24 := JTF_VARCHAR2_TABLE_200();
237: a25 := JTF_VARCHAR2_TABLE_200();
238: a26 := JTF_DATE_TABLE();
239: a27 := JTF_NUMBER_TABLE();
240: a28 := JTF_DATE_TABLE();
241: a29 := JTF_NUMBER_TABLE();
242: a30 := JTF_NUMBER_TABLE();
243: a31 := JTF_VARCHAR2_TABLE_100();
237: a25 := JTF_VARCHAR2_TABLE_200();
238: a26 := JTF_DATE_TABLE();
239: a27 := JTF_NUMBER_TABLE();
240: a28 := JTF_DATE_TABLE();
241: a29 := JTF_NUMBER_TABLE();
242: a30 := JTF_NUMBER_TABLE();
243: a31 := JTF_VARCHAR2_TABLE_100();
244: a32 := JTF_VARCHAR2_TABLE_4000();
245: a33 := JTF_NUMBER_TABLE();
238: a26 := JTF_DATE_TABLE();
239: a27 := JTF_NUMBER_TABLE();
240: a28 := JTF_DATE_TABLE();
241: a29 := JTF_NUMBER_TABLE();
242: a30 := JTF_NUMBER_TABLE();
243: a31 := JTF_VARCHAR2_TABLE_100();
244: a32 := JTF_VARCHAR2_TABLE_4000();
245: a33 := JTF_NUMBER_TABLE();
246: a34 := JTF_NUMBER_TABLE();
241: a29 := JTF_NUMBER_TABLE();
242: a30 := JTF_NUMBER_TABLE();
243: a31 := JTF_VARCHAR2_TABLE_100();
244: a32 := JTF_VARCHAR2_TABLE_4000();
245: a33 := JTF_NUMBER_TABLE();
246: a34 := JTF_NUMBER_TABLE();
247: a35 := JTF_VARCHAR2_TABLE_100();
248: a36 := JTF_NUMBER_TABLE();
249: a37 := JTF_NUMBER_TABLE();
242: a30 := JTF_NUMBER_TABLE();
243: a31 := JTF_VARCHAR2_TABLE_100();
244: a32 := JTF_VARCHAR2_TABLE_4000();
245: a33 := JTF_NUMBER_TABLE();
246: a34 := JTF_NUMBER_TABLE();
247: a35 := JTF_VARCHAR2_TABLE_100();
248: a36 := JTF_NUMBER_TABLE();
249: a37 := JTF_NUMBER_TABLE();
250: a38 := JTF_VARCHAR2_TABLE_100();
244: a32 := JTF_VARCHAR2_TABLE_4000();
245: a33 := JTF_NUMBER_TABLE();
246: a34 := JTF_NUMBER_TABLE();
247: a35 := JTF_VARCHAR2_TABLE_100();
248: a36 := JTF_NUMBER_TABLE();
249: a37 := JTF_NUMBER_TABLE();
250: a38 := JTF_VARCHAR2_TABLE_100();
251: a39 := JTF_VARCHAR2_TABLE_100();
252: a40 := JTF_VARCHAR2_TABLE_100();
245: a33 := JTF_NUMBER_TABLE();
246: a34 := JTF_NUMBER_TABLE();
247: a35 := JTF_VARCHAR2_TABLE_100();
248: a36 := JTF_NUMBER_TABLE();
249: a37 := JTF_NUMBER_TABLE();
250: a38 := JTF_VARCHAR2_TABLE_100();
251: a39 := JTF_VARCHAR2_TABLE_100();
252: a40 := JTF_VARCHAR2_TABLE_100();
253: a41 := JTF_NUMBER_TABLE();
249: a37 := JTF_NUMBER_TABLE();
250: a38 := JTF_VARCHAR2_TABLE_100();
251: a39 := JTF_VARCHAR2_TABLE_100();
252: a40 := JTF_VARCHAR2_TABLE_100();
253: a41 := JTF_NUMBER_TABLE();
254: a42 := JTF_VARCHAR2_TABLE_100();
255: a43 := JTF_NUMBER_TABLE();
256: if t.count > 0 then
257: a0.extend(t.count);
251: a39 := JTF_VARCHAR2_TABLE_100();
252: a40 := JTF_VARCHAR2_TABLE_100();
253: a41 := JTF_NUMBER_TABLE();
254: a42 := JTF_VARCHAR2_TABLE_100();
255: a43 := JTF_NUMBER_TABLE();
256: if t.count > 0 then
257: a0.extend(t.count);
258: a1.extend(t.count);
259: a2.extend(t.count);
353: end loop;
354: end if;
355: end if;
356: end rosetta_table_copy_out_p1;
357: procedure rosetta_table_copy_in_p3(t out nocopy ahl_rm_material_as_pvt.route_efct_tbl_type, a0 JTF_NUMBER_TABLE
358: , a1 JTF_VARCHAR2_TABLE_100
359: , a2 JTF_NUMBER_TABLE
360: , a3 JTF_NUMBER_TABLE
361: , a4 JTF_VARCHAR2_TABLE_100
355: end if;
356: end rosetta_table_copy_out_p1;
357: procedure rosetta_table_copy_in_p3(t out nocopy ahl_rm_material_as_pvt.route_efct_tbl_type, a0 JTF_NUMBER_TABLE
358: , a1 JTF_VARCHAR2_TABLE_100
359: , a2 JTF_NUMBER_TABLE
360: , a3 JTF_NUMBER_TABLE
361: , a4 JTF_VARCHAR2_TABLE_100
362: , a5 JTF_VARCHAR2_TABLE_300
363: , a6 JTF_VARCHAR2_TABLE_100
356: end rosetta_table_copy_out_p1;
357: procedure rosetta_table_copy_in_p3(t out nocopy ahl_rm_material_as_pvt.route_efct_tbl_type, a0 JTF_NUMBER_TABLE
358: , a1 JTF_VARCHAR2_TABLE_100
359: , a2 JTF_NUMBER_TABLE
360: , a3 JTF_NUMBER_TABLE
361: , a4 JTF_VARCHAR2_TABLE_100
362: , a5 JTF_VARCHAR2_TABLE_300
363: , a6 JTF_VARCHAR2_TABLE_100
364: , a7 JTF_NUMBER_TABLE
360: , a3 JTF_NUMBER_TABLE
361: , a4 JTF_VARCHAR2_TABLE_100
362: , a5 JTF_VARCHAR2_TABLE_300
363: , a6 JTF_VARCHAR2_TABLE_100
364: , a7 JTF_NUMBER_TABLE
365: , a8 JTF_VARCHAR2_TABLE_100
366: , a9 JTF_NUMBER_TABLE
367: , a10 JTF_VARCHAR2_TABLE_100
368: , a11 JTF_VARCHAR2_TABLE_300
362: , a5 JTF_VARCHAR2_TABLE_300
363: , a6 JTF_VARCHAR2_TABLE_100
364: , a7 JTF_NUMBER_TABLE
365: , a8 JTF_VARCHAR2_TABLE_100
366: , a9 JTF_NUMBER_TABLE
367: , a10 JTF_VARCHAR2_TABLE_100
368: , a11 JTF_VARCHAR2_TABLE_300
369: , a12 JTF_NUMBER_TABLE
370: , a13 JTF_DATE_TABLE
365: , a8 JTF_VARCHAR2_TABLE_100
366: , a9 JTF_NUMBER_TABLE
367: , a10 JTF_VARCHAR2_TABLE_100
368: , a11 JTF_VARCHAR2_TABLE_300
369: , a12 JTF_NUMBER_TABLE
370: , a13 JTF_DATE_TABLE
371: , a14 JTF_NUMBER_TABLE
372: , a15 JTF_DATE_TABLE
373: , a16 JTF_NUMBER_TABLE
367: , a10 JTF_VARCHAR2_TABLE_100
368: , a11 JTF_VARCHAR2_TABLE_300
369: , a12 JTF_NUMBER_TABLE
370: , a13 JTF_DATE_TABLE
371: , a14 JTF_NUMBER_TABLE
372: , a15 JTF_DATE_TABLE
373: , a16 JTF_NUMBER_TABLE
374: , a17 JTF_NUMBER_TABLE
375: , a18 JTF_NUMBER_TABLE
369: , a12 JTF_NUMBER_TABLE
370: , a13 JTF_DATE_TABLE
371: , a14 JTF_NUMBER_TABLE
372: , a15 JTF_DATE_TABLE
373: , a16 JTF_NUMBER_TABLE
374: , a17 JTF_NUMBER_TABLE
375: , a18 JTF_NUMBER_TABLE
376: , a19 JTF_NUMBER_TABLE
377: , a20 JTF_VARCHAR2_TABLE_100
370: , a13 JTF_DATE_TABLE
371: , a14 JTF_NUMBER_TABLE
372: , a15 JTF_DATE_TABLE
373: , a16 JTF_NUMBER_TABLE
374: , a17 JTF_NUMBER_TABLE
375: , a18 JTF_NUMBER_TABLE
376: , a19 JTF_NUMBER_TABLE
377: , a20 JTF_VARCHAR2_TABLE_100
378: , a21 JTF_VARCHAR2_TABLE_200
371: , a14 JTF_NUMBER_TABLE
372: , a15 JTF_DATE_TABLE
373: , a16 JTF_NUMBER_TABLE
374: , a17 JTF_NUMBER_TABLE
375: , a18 JTF_NUMBER_TABLE
376: , a19 JTF_NUMBER_TABLE
377: , a20 JTF_VARCHAR2_TABLE_100
378: , a21 JTF_VARCHAR2_TABLE_200
379: , a22 JTF_VARCHAR2_TABLE_200
372: , a15 JTF_DATE_TABLE
373: , a16 JTF_NUMBER_TABLE
374: , a17 JTF_NUMBER_TABLE
375: , a18 JTF_NUMBER_TABLE
376: , a19 JTF_NUMBER_TABLE
377: , a20 JTF_VARCHAR2_TABLE_100
378: , a21 JTF_VARCHAR2_TABLE_200
379: , a22 JTF_VARCHAR2_TABLE_200
380: , a23 JTF_VARCHAR2_TABLE_200
444: end loop;
445: end if;
446: end if;
447: end rosetta_table_copy_in_p3;
448: procedure rosetta_table_copy_out_p3(t ahl_rm_material_as_pvt.route_efct_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
449: , a1 out nocopy JTF_VARCHAR2_TABLE_100
450: , a2 out nocopy JTF_NUMBER_TABLE
451: , a3 out nocopy JTF_NUMBER_TABLE
452: , a4 out nocopy JTF_VARCHAR2_TABLE_100
446: end if;
447: end rosetta_table_copy_in_p3;
448: procedure rosetta_table_copy_out_p3(t ahl_rm_material_as_pvt.route_efct_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
449: , a1 out nocopy JTF_VARCHAR2_TABLE_100
450: , a2 out nocopy JTF_NUMBER_TABLE
451: , a3 out nocopy JTF_NUMBER_TABLE
452: , a4 out nocopy JTF_VARCHAR2_TABLE_100
453: , a5 out nocopy JTF_VARCHAR2_TABLE_300
454: , a6 out nocopy JTF_VARCHAR2_TABLE_100
447: end rosetta_table_copy_in_p3;
448: procedure rosetta_table_copy_out_p3(t ahl_rm_material_as_pvt.route_efct_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
449: , a1 out nocopy JTF_VARCHAR2_TABLE_100
450: , a2 out nocopy JTF_NUMBER_TABLE
451: , a3 out nocopy JTF_NUMBER_TABLE
452: , a4 out nocopy JTF_VARCHAR2_TABLE_100
453: , a5 out nocopy JTF_VARCHAR2_TABLE_300
454: , a6 out nocopy JTF_VARCHAR2_TABLE_100
455: , a7 out nocopy JTF_NUMBER_TABLE
451: , a3 out nocopy JTF_NUMBER_TABLE
452: , a4 out nocopy JTF_VARCHAR2_TABLE_100
453: , a5 out nocopy JTF_VARCHAR2_TABLE_300
454: , a6 out nocopy JTF_VARCHAR2_TABLE_100
455: , a7 out nocopy JTF_NUMBER_TABLE
456: , a8 out nocopy JTF_VARCHAR2_TABLE_100
457: , a9 out nocopy JTF_NUMBER_TABLE
458: , a10 out nocopy JTF_VARCHAR2_TABLE_100
459: , a11 out nocopy JTF_VARCHAR2_TABLE_300
453: , a5 out nocopy JTF_VARCHAR2_TABLE_300
454: , a6 out nocopy JTF_VARCHAR2_TABLE_100
455: , a7 out nocopy JTF_NUMBER_TABLE
456: , a8 out nocopy JTF_VARCHAR2_TABLE_100
457: , a9 out nocopy JTF_NUMBER_TABLE
458: , a10 out nocopy JTF_VARCHAR2_TABLE_100
459: , a11 out nocopy JTF_VARCHAR2_TABLE_300
460: , a12 out nocopy JTF_NUMBER_TABLE
461: , a13 out nocopy JTF_DATE_TABLE
456: , a8 out nocopy JTF_VARCHAR2_TABLE_100
457: , a9 out nocopy JTF_NUMBER_TABLE
458: , a10 out nocopy JTF_VARCHAR2_TABLE_100
459: , a11 out nocopy JTF_VARCHAR2_TABLE_300
460: , a12 out nocopy JTF_NUMBER_TABLE
461: , a13 out nocopy JTF_DATE_TABLE
462: , a14 out nocopy JTF_NUMBER_TABLE
463: , a15 out nocopy JTF_DATE_TABLE
464: , a16 out nocopy JTF_NUMBER_TABLE
458: , a10 out nocopy JTF_VARCHAR2_TABLE_100
459: , a11 out nocopy JTF_VARCHAR2_TABLE_300
460: , a12 out nocopy JTF_NUMBER_TABLE
461: , a13 out nocopy JTF_DATE_TABLE
462: , a14 out nocopy JTF_NUMBER_TABLE
463: , a15 out nocopy JTF_DATE_TABLE
464: , a16 out nocopy JTF_NUMBER_TABLE
465: , a17 out nocopy JTF_NUMBER_TABLE
466: , a18 out nocopy JTF_NUMBER_TABLE
460: , a12 out nocopy JTF_NUMBER_TABLE
461: , a13 out nocopy JTF_DATE_TABLE
462: , a14 out nocopy JTF_NUMBER_TABLE
463: , a15 out nocopy JTF_DATE_TABLE
464: , a16 out nocopy JTF_NUMBER_TABLE
465: , a17 out nocopy JTF_NUMBER_TABLE
466: , a18 out nocopy JTF_NUMBER_TABLE
467: , a19 out nocopy JTF_NUMBER_TABLE
468: , a20 out nocopy JTF_VARCHAR2_TABLE_100
461: , a13 out nocopy JTF_DATE_TABLE
462: , a14 out nocopy JTF_NUMBER_TABLE
463: , a15 out nocopy JTF_DATE_TABLE
464: , a16 out nocopy JTF_NUMBER_TABLE
465: , a17 out nocopy JTF_NUMBER_TABLE
466: , a18 out nocopy JTF_NUMBER_TABLE
467: , a19 out nocopy JTF_NUMBER_TABLE
468: , a20 out nocopy JTF_VARCHAR2_TABLE_100
469: , a21 out nocopy JTF_VARCHAR2_TABLE_200
462: , a14 out nocopy JTF_NUMBER_TABLE
463: , a15 out nocopy JTF_DATE_TABLE
464: , a16 out nocopy JTF_NUMBER_TABLE
465: , a17 out nocopy JTF_NUMBER_TABLE
466: , a18 out nocopy JTF_NUMBER_TABLE
467: , a19 out nocopy JTF_NUMBER_TABLE
468: , a20 out nocopy JTF_VARCHAR2_TABLE_100
469: , a21 out nocopy JTF_VARCHAR2_TABLE_200
470: , a22 out nocopy JTF_VARCHAR2_TABLE_200
463: , a15 out nocopy JTF_DATE_TABLE
464: , a16 out nocopy JTF_NUMBER_TABLE
465: , a17 out nocopy JTF_NUMBER_TABLE
466: , a18 out nocopy JTF_NUMBER_TABLE
467: , a19 out nocopy JTF_NUMBER_TABLE
468: , a20 out nocopy JTF_VARCHAR2_TABLE_100
469: , a21 out nocopy JTF_VARCHAR2_TABLE_200
470: , a22 out nocopy JTF_VARCHAR2_TABLE_200
471: , a23 out nocopy JTF_VARCHAR2_TABLE_200
485: ) as
486: ddindx binary_integer; indx binary_integer;
487: begin
488: if t is null or t.count = 0 then
489: a0 := JTF_NUMBER_TABLE();
490: a1 := JTF_VARCHAR2_TABLE_100();
491: a2 := JTF_NUMBER_TABLE();
492: a3 := JTF_NUMBER_TABLE();
493: a4 := JTF_VARCHAR2_TABLE_100();
487: begin
488: if t is null or t.count = 0 then
489: a0 := JTF_NUMBER_TABLE();
490: a1 := JTF_VARCHAR2_TABLE_100();
491: a2 := JTF_NUMBER_TABLE();
492: a3 := JTF_NUMBER_TABLE();
493: a4 := JTF_VARCHAR2_TABLE_100();
494: a5 := JTF_VARCHAR2_TABLE_300();
495: a6 := JTF_VARCHAR2_TABLE_100();
488: if t is null or t.count = 0 then
489: a0 := JTF_NUMBER_TABLE();
490: a1 := JTF_VARCHAR2_TABLE_100();
491: a2 := JTF_NUMBER_TABLE();
492: a3 := JTF_NUMBER_TABLE();
493: a4 := JTF_VARCHAR2_TABLE_100();
494: a5 := JTF_VARCHAR2_TABLE_300();
495: a6 := JTF_VARCHAR2_TABLE_100();
496: a7 := JTF_NUMBER_TABLE();
492: a3 := JTF_NUMBER_TABLE();
493: a4 := JTF_VARCHAR2_TABLE_100();
494: a5 := JTF_VARCHAR2_TABLE_300();
495: a6 := JTF_VARCHAR2_TABLE_100();
496: a7 := JTF_NUMBER_TABLE();
497: a8 := JTF_VARCHAR2_TABLE_100();
498: a9 := JTF_NUMBER_TABLE();
499: a10 := JTF_VARCHAR2_TABLE_100();
500: a11 := JTF_VARCHAR2_TABLE_300();
494: a5 := JTF_VARCHAR2_TABLE_300();
495: a6 := JTF_VARCHAR2_TABLE_100();
496: a7 := JTF_NUMBER_TABLE();
497: a8 := JTF_VARCHAR2_TABLE_100();
498: a9 := JTF_NUMBER_TABLE();
499: a10 := JTF_VARCHAR2_TABLE_100();
500: a11 := JTF_VARCHAR2_TABLE_300();
501: a12 := JTF_NUMBER_TABLE();
502: a13 := JTF_DATE_TABLE();
497: a8 := JTF_VARCHAR2_TABLE_100();
498: a9 := JTF_NUMBER_TABLE();
499: a10 := JTF_VARCHAR2_TABLE_100();
500: a11 := JTF_VARCHAR2_TABLE_300();
501: a12 := JTF_NUMBER_TABLE();
502: a13 := JTF_DATE_TABLE();
503: a14 := JTF_NUMBER_TABLE();
504: a15 := JTF_DATE_TABLE();
505: a16 := JTF_NUMBER_TABLE();
499: a10 := JTF_VARCHAR2_TABLE_100();
500: a11 := JTF_VARCHAR2_TABLE_300();
501: a12 := JTF_NUMBER_TABLE();
502: a13 := JTF_DATE_TABLE();
503: a14 := JTF_NUMBER_TABLE();
504: a15 := JTF_DATE_TABLE();
505: a16 := JTF_NUMBER_TABLE();
506: a17 := JTF_NUMBER_TABLE();
507: a18 := JTF_NUMBER_TABLE();
501: a12 := JTF_NUMBER_TABLE();
502: a13 := JTF_DATE_TABLE();
503: a14 := JTF_NUMBER_TABLE();
504: a15 := JTF_DATE_TABLE();
505: a16 := JTF_NUMBER_TABLE();
506: a17 := JTF_NUMBER_TABLE();
507: a18 := JTF_NUMBER_TABLE();
508: a19 := JTF_NUMBER_TABLE();
509: a20 := JTF_VARCHAR2_TABLE_100();
502: a13 := JTF_DATE_TABLE();
503: a14 := JTF_NUMBER_TABLE();
504: a15 := JTF_DATE_TABLE();
505: a16 := JTF_NUMBER_TABLE();
506: a17 := JTF_NUMBER_TABLE();
507: a18 := JTF_NUMBER_TABLE();
508: a19 := JTF_NUMBER_TABLE();
509: a20 := JTF_VARCHAR2_TABLE_100();
510: a21 := JTF_VARCHAR2_TABLE_200();
503: a14 := JTF_NUMBER_TABLE();
504: a15 := JTF_DATE_TABLE();
505: a16 := JTF_NUMBER_TABLE();
506: a17 := JTF_NUMBER_TABLE();
507: a18 := JTF_NUMBER_TABLE();
508: a19 := JTF_NUMBER_TABLE();
509: a20 := JTF_VARCHAR2_TABLE_100();
510: a21 := JTF_VARCHAR2_TABLE_200();
511: a22 := JTF_VARCHAR2_TABLE_200();
504: a15 := JTF_DATE_TABLE();
505: a16 := JTF_NUMBER_TABLE();
506: a17 := JTF_NUMBER_TABLE();
507: a18 := JTF_NUMBER_TABLE();
508: a19 := JTF_NUMBER_TABLE();
509: a20 := JTF_VARCHAR2_TABLE_100();
510: a21 := JTF_VARCHAR2_TABLE_200();
511: a22 := JTF_VARCHAR2_TABLE_200();
512: a23 := JTF_VARCHAR2_TABLE_200();
523: a34 := JTF_VARCHAR2_TABLE_200();
524: a35 := JTF_VARCHAR2_TABLE_200();
525: a36 := JTF_VARCHAR2_TABLE_100();
526: else
527: a0 := JTF_NUMBER_TABLE();
528: a1 := JTF_VARCHAR2_TABLE_100();
529: a2 := JTF_NUMBER_TABLE();
530: a3 := JTF_NUMBER_TABLE();
531: a4 := JTF_VARCHAR2_TABLE_100();
525: a36 := JTF_VARCHAR2_TABLE_100();
526: else
527: a0 := JTF_NUMBER_TABLE();
528: a1 := JTF_VARCHAR2_TABLE_100();
529: a2 := JTF_NUMBER_TABLE();
530: a3 := JTF_NUMBER_TABLE();
531: a4 := JTF_VARCHAR2_TABLE_100();
532: a5 := JTF_VARCHAR2_TABLE_300();
533: a6 := JTF_VARCHAR2_TABLE_100();
526: else
527: a0 := JTF_NUMBER_TABLE();
528: a1 := JTF_VARCHAR2_TABLE_100();
529: a2 := JTF_NUMBER_TABLE();
530: a3 := JTF_NUMBER_TABLE();
531: a4 := JTF_VARCHAR2_TABLE_100();
532: a5 := JTF_VARCHAR2_TABLE_300();
533: a6 := JTF_VARCHAR2_TABLE_100();
534: a7 := JTF_NUMBER_TABLE();
530: a3 := JTF_NUMBER_TABLE();
531: a4 := JTF_VARCHAR2_TABLE_100();
532: a5 := JTF_VARCHAR2_TABLE_300();
533: a6 := JTF_VARCHAR2_TABLE_100();
534: a7 := JTF_NUMBER_TABLE();
535: a8 := JTF_VARCHAR2_TABLE_100();
536: a9 := JTF_NUMBER_TABLE();
537: a10 := JTF_VARCHAR2_TABLE_100();
538: a11 := JTF_VARCHAR2_TABLE_300();
532: a5 := JTF_VARCHAR2_TABLE_300();
533: a6 := JTF_VARCHAR2_TABLE_100();
534: a7 := JTF_NUMBER_TABLE();
535: a8 := JTF_VARCHAR2_TABLE_100();
536: a9 := JTF_NUMBER_TABLE();
537: a10 := JTF_VARCHAR2_TABLE_100();
538: a11 := JTF_VARCHAR2_TABLE_300();
539: a12 := JTF_NUMBER_TABLE();
540: a13 := JTF_DATE_TABLE();
535: a8 := JTF_VARCHAR2_TABLE_100();
536: a9 := JTF_NUMBER_TABLE();
537: a10 := JTF_VARCHAR2_TABLE_100();
538: a11 := JTF_VARCHAR2_TABLE_300();
539: a12 := JTF_NUMBER_TABLE();
540: a13 := JTF_DATE_TABLE();
541: a14 := JTF_NUMBER_TABLE();
542: a15 := JTF_DATE_TABLE();
543: a16 := JTF_NUMBER_TABLE();
537: a10 := JTF_VARCHAR2_TABLE_100();
538: a11 := JTF_VARCHAR2_TABLE_300();
539: a12 := JTF_NUMBER_TABLE();
540: a13 := JTF_DATE_TABLE();
541: a14 := JTF_NUMBER_TABLE();
542: a15 := JTF_DATE_TABLE();
543: a16 := JTF_NUMBER_TABLE();
544: a17 := JTF_NUMBER_TABLE();
545: a18 := JTF_NUMBER_TABLE();
539: a12 := JTF_NUMBER_TABLE();
540: a13 := JTF_DATE_TABLE();
541: a14 := JTF_NUMBER_TABLE();
542: a15 := JTF_DATE_TABLE();
543: a16 := JTF_NUMBER_TABLE();
544: a17 := JTF_NUMBER_TABLE();
545: a18 := JTF_NUMBER_TABLE();
546: a19 := JTF_NUMBER_TABLE();
547: a20 := JTF_VARCHAR2_TABLE_100();
540: a13 := JTF_DATE_TABLE();
541: a14 := JTF_NUMBER_TABLE();
542: a15 := JTF_DATE_TABLE();
543: a16 := JTF_NUMBER_TABLE();
544: a17 := JTF_NUMBER_TABLE();
545: a18 := JTF_NUMBER_TABLE();
546: a19 := JTF_NUMBER_TABLE();
547: a20 := JTF_VARCHAR2_TABLE_100();
548: a21 := JTF_VARCHAR2_TABLE_200();
541: a14 := JTF_NUMBER_TABLE();
542: a15 := JTF_DATE_TABLE();
543: a16 := JTF_NUMBER_TABLE();
544: a17 := JTF_NUMBER_TABLE();
545: a18 := JTF_NUMBER_TABLE();
546: a19 := JTF_NUMBER_TABLE();
547: a20 := JTF_VARCHAR2_TABLE_100();
548: a21 := JTF_VARCHAR2_TABLE_200();
549: a22 := JTF_VARCHAR2_TABLE_200();
542: a15 := JTF_DATE_TABLE();
543: a16 := JTF_NUMBER_TABLE();
544: a17 := JTF_NUMBER_TABLE();
545: a18 := JTF_NUMBER_TABLE();
546: a19 := JTF_NUMBER_TABLE();
547: a20 := JTF_VARCHAR2_TABLE_100();
548: a21 := JTF_VARCHAR2_TABLE_200();
549: a22 := JTF_VARCHAR2_TABLE_200();
550: a23 := JTF_VARCHAR2_TABLE_200();
656: , p_module_type VARCHAR2
657: , x_return_status out nocopy VARCHAR2
658: , x_msg_count out nocopy NUMBER
659: , x_msg_data out nocopy VARCHAR2
660: , p9_a0 in out nocopy JTF_NUMBER_TABLE
661: , p9_a1 in out nocopy JTF_NUMBER_TABLE
662: , p9_a2 in out nocopy JTF_NUMBER_TABLE
663: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
664: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
657: , x_return_status out nocopy VARCHAR2
658: , x_msg_count out nocopy NUMBER
659: , x_msg_data out nocopy VARCHAR2
660: , p9_a0 in out nocopy JTF_NUMBER_TABLE
661: , p9_a1 in out nocopy JTF_NUMBER_TABLE
662: , p9_a2 in out nocopy JTF_NUMBER_TABLE
663: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
664: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
665: , p9_a5 in out nocopy JTF_NUMBER_TABLE
658: , x_msg_count out nocopy NUMBER
659: , x_msg_data out nocopy VARCHAR2
660: , p9_a0 in out nocopy JTF_NUMBER_TABLE
661: , p9_a1 in out nocopy JTF_NUMBER_TABLE
662: , p9_a2 in out nocopy JTF_NUMBER_TABLE
663: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
664: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
665: , p9_a5 in out nocopy JTF_NUMBER_TABLE
666: , p9_a6 in out nocopy JTF_NUMBER_TABLE
661: , p9_a1 in out nocopy JTF_NUMBER_TABLE
662: , p9_a2 in out nocopy JTF_NUMBER_TABLE
663: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
664: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
665: , p9_a5 in out nocopy JTF_NUMBER_TABLE
666: , p9_a6 in out nocopy JTF_NUMBER_TABLE
667: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_100
668: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
669: , p9_a9 in out nocopy JTF_NUMBER_TABLE
662: , p9_a2 in out nocopy JTF_NUMBER_TABLE
663: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
664: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
665: , p9_a5 in out nocopy JTF_NUMBER_TABLE
666: , p9_a6 in out nocopy JTF_NUMBER_TABLE
667: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_100
668: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
669: , p9_a9 in out nocopy JTF_NUMBER_TABLE
670: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
665: , p9_a5 in out nocopy JTF_NUMBER_TABLE
666: , p9_a6 in out nocopy JTF_NUMBER_TABLE
667: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_100
668: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
669: , p9_a9 in out nocopy JTF_NUMBER_TABLE
670: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
671: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_200
672: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_200
673: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_200
683: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_200
684: , p9_a24 in out nocopy JTF_VARCHAR2_TABLE_200
685: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_200
686: , p9_a26 in out nocopy JTF_DATE_TABLE
687: , p9_a27 in out nocopy JTF_NUMBER_TABLE
688: , p9_a28 in out nocopy JTF_DATE_TABLE
689: , p9_a29 in out nocopy JTF_NUMBER_TABLE
690: , p9_a30 in out nocopy JTF_NUMBER_TABLE
691: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
685: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_200
686: , p9_a26 in out nocopy JTF_DATE_TABLE
687: , p9_a27 in out nocopy JTF_NUMBER_TABLE
688: , p9_a28 in out nocopy JTF_DATE_TABLE
689: , p9_a29 in out nocopy JTF_NUMBER_TABLE
690: , p9_a30 in out nocopy JTF_NUMBER_TABLE
691: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
692: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_4000
693: , p9_a33 in out nocopy JTF_NUMBER_TABLE
686: , p9_a26 in out nocopy JTF_DATE_TABLE
687: , p9_a27 in out nocopy JTF_NUMBER_TABLE
688: , p9_a28 in out nocopy JTF_DATE_TABLE
689: , p9_a29 in out nocopy JTF_NUMBER_TABLE
690: , p9_a30 in out nocopy JTF_NUMBER_TABLE
691: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
692: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_4000
693: , p9_a33 in out nocopy JTF_NUMBER_TABLE
694: , p9_a34 in out nocopy JTF_NUMBER_TABLE
689: , p9_a29 in out nocopy JTF_NUMBER_TABLE
690: , p9_a30 in out nocopy JTF_NUMBER_TABLE
691: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
692: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_4000
693: , p9_a33 in out nocopy JTF_NUMBER_TABLE
694: , p9_a34 in out nocopy JTF_NUMBER_TABLE
695: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
696: , p9_a36 in out nocopy JTF_NUMBER_TABLE
697: , p9_a37 in out nocopy JTF_NUMBER_TABLE
690: , p9_a30 in out nocopy JTF_NUMBER_TABLE
691: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
692: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_4000
693: , p9_a33 in out nocopy JTF_NUMBER_TABLE
694: , p9_a34 in out nocopy JTF_NUMBER_TABLE
695: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
696: , p9_a36 in out nocopy JTF_NUMBER_TABLE
697: , p9_a37 in out nocopy JTF_NUMBER_TABLE
698: , p9_a38 in out nocopy JTF_VARCHAR2_TABLE_100
692: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_4000
693: , p9_a33 in out nocopy JTF_NUMBER_TABLE
694: , p9_a34 in out nocopy JTF_NUMBER_TABLE
695: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
696: , p9_a36 in out nocopy JTF_NUMBER_TABLE
697: , p9_a37 in out nocopy JTF_NUMBER_TABLE
698: , p9_a38 in out nocopy JTF_VARCHAR2_TABLE_100
699: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100
700: , p9_a40 in out nocopy JTF_VARCHAR2_TABLE_100
693: , p9_a33 in out nocopy JTF_NUMBER_TABLE
694: , p9_a34 in out nocopy JTF_NUMBER_TABLE
695: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
696: , p9_a36 in out nocopy JTF_NUMBER_TABLE
697: , p9_a37 in out nocopy JTF_NUMBER_TABLE
698: , p9_a38 in out nocopy JTF_VARCHAR2_TABLE_100
699: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100
700: , p9_a40 in out nocopy JTF_VARCHAR2_TABLE_100
701: , p9_a41 in out nocopy JTF_NUMBER_TABLE
697: , p9_a37 in out nocopy JTF_NUMBER_TABLE
698: , p9_a38 in out nocopy JTF_VARCHAR2_TABLE_100
699: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100
700: , p9_a40 in out nocopy JTF_VARCHAR2_TABLE_100
701: , p9_a41 in out nocopy JTF_NUMBER_TABLE
702: , p9_a42 in out nocopy JTF_VARCHAR2_TABLE_100
703: , p9_a43 in out nocopy JTF_NUMBER_TABLE
704: , p_object_id NUMBER
705: , p_association_type VARCHAR2
699: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100
700: , p9_a40 in out nocopy JTF_VARCHAR2_TABLE_100
701: , p9_a41 in out nocopy JTF_NUMBER_TABLE
702: , p9_a42 in out nocopy JTF_VARCHAR2_TABLE_100
703: , p9_a43 in out nocopy JTF_NUMBER_TABLE
704: , p_object_id NUMBER
705: , p_association_type VARCHAR2
706: )
707: as
823: , p_object_id NUMBER
824: , x_return_status out nocopy VARCHAR2
825: , x_msg_count out nocopy NUMBER
826: , x_msg_data out nocopy VARCHAR2
827: , p10_a0 in out nocopy JTF_NUMBER_TABLE
828: , p10_a1 in out nocopy JTF_VARCHAR2_TABLE_100
829: , p10_a2 in out nocopy JTF_NUMBER_TABLE
830: , p10_a3 in out nocopy JTF_NUMBER_TABLE
831: , p10_a4 in out nocopy JTF_VARCHAR2_TABLE_100
825: , x_msg_count out nocopy NUMBER
826: , x_msg_data out nocopy VARCHAR2
827: , p10_a0 in out nocopy JTF_NUMBER_TABLE
828: , p10_a1 in out nocopy JTF_VARCHAR2_TABLE_100
829: , p10_a2 in out nocopy JTF_NUMBER_TABLE
830: , p10_a3 in out nocopy JTF_NUMBER_TABLE
831: , p10_a4 in out nocopy JTF_VARCHAR2_TABLE_100
832: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_300
833: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
826: , x_msg_data out nocopy VARCHAR2
827: , p10_a0 in out nocopy JTF_NUMBER_TABLE
828: , p10_a1 in out nocopy JTF_VARCHAR2_TABLE_100
829: , p10_a2 in out nocopy JTF_NUMBER_TABLE
830: , p10_a3 in out nocopy JTF_NUMBER_TABLE
831: , p10_a4 in out nocopy JTF_VARCHAR2_TABLE_100
832: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_300
833: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
834: , p10_a7 in out nocopy JTF_NUMBER_TABLE
830: , p10_a3 in out nocopy JTF_NUMBER_TABLE
831: , p10_a4 in out nocopy JTF_VARCHAR2_TABLE_100
832: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_300
833: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
834: , p10_a7 in out nocopy JTF_NUMBER_TABLE
835: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
836: , p10_a9 in out nocopy JTF_NUMBER_TABLE
837: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
838: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_300
832: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_300
833: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
834: , p10_a7 in out nocopy JTF_NUMBER_TABLE
835: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
836: , p10_a9 in out nocopy JTF_NUMBER_TABLE
837: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
838: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_300
839: , p10_a12 in out nocopy JTF_NUMBER_TABLE
840: , p10_a13 in out nocopy JTF_DATE_TABLE
835: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
836: , p10_a9 in out nocopy JTF_NUMBER_TABLE
837: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
838: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_300
839: , p10_a12 in out nocopy JTF_NUMBER_TABLE
840: , p10_a13 in out nocopy JTF_DATE_TABLE
841: , p10_a14 in out nocopy JTF_NUMBER_TABLE
842: , p10_a15 in out nocopy JTF_DATE_TABLE
843: , p10_a16 in out nocopy JTF_NUMBER_TABLE
837: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
838: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_300
839: , p10_a12 in out nocopy JTF_NUMBER_TABLE
840: , p10_a13 in out nocopy JTF_DATE_TABLE
841: , p10_a14 in out nocopy JTF_NUMBER_TABLE
842: , p10_a15 in out nocopy JTF_DATE_TABLE
843: , p10_a16 in out nocopy JTF_NUMBER_TABLE
844: , p10_a17 in out nocopy JTF_NUMBER_TABLE
845: , p10_a18 in out nocopy JTF_NUMBER_TABLE
839: , p10_a12 in out nocopy JTF_NUMBER_TABLE
840: , p10_a13 in out nocopy JTF_DATE_TABLE
841: , p10_a14 in out nocopy JTF_NUMBER_TABLE
842: , p10_a15 in out nocopy JTF_DATE_TABLE
843: , p10_a16 in out nocopy JTF_NUMBER_TABLE
844: , p10_a17 in out nocopy JTF_NUMBER_TABLE
845: , p10_a18 in out nocopy JTF_NUMBER_TABLE
846: , p10_a19 in out nocopy JTF_NUMBER_TABLE
847: , p10_a20 in out nocopy JTF_VARCHAR2_TABLE_100
840: , p10_a13 in out nocopy JTF_DATE_TABLE
841: , p10_a14 in out nocopy JTF_NUMBER_TABLE
842: , p10_a15 in out nocopy JTF_DATE_TABLE
843: , p10_a16 in out nocopy JTF_NUMBER_TABLE
844: , p10_a17 in out nocopy JTF_NUMBER_TABLE
845: , p10_a18 in out nocopy JTF_NUMBER_TABLE
846: , p10_a19 in out nocopy JTF_NUMBER_TABLE
847: , p10_a20 in out nocopy JTF_VARCHAR2_TABLE_100
848: , p10_a21 in out nocopy JTF_VARCHAR2_TABLE_200
841: , p10_a14 in out nocopy JTF_NUMBER_TABLE
842: , p10_a15 in out nocopy JTF_DATE_TABLE
843: , p10_a16 in out nocopy JTF_NUMBER_TABLE
844: , p10_a17 in out nocopy JTF_NUMBER_TABLE
845: , p10_a18 in out nocopy JTF_NUMBER_TABLE
846: , p10_a19 in out nocopy JTF_NUMBER_TABLE
847: , p10_a20 in out nocopy JTF_VARCHAR2_TABLE_100
848: , p10_a21 in out nocopy JTF_VARCHAR2_TABLE_200
849: , p10_a22 in out nocopy JTF_VARCHAR2_TABLE_200
842: , p10_a15 in out nocopy JTF_DATE_TABLE
843: , p10_a16 in out nocopy JTF_NUMBER_TABLE
844: , p10_a17 in out nocopy JTF_NUMBER_TABLE
845: , p10_a18 in out nocopy JTF_NUMBER_TABLE
846: , p10_a19 in out nocopy JTF_NUMBER_TABLE
847: , p10_a20 in out nocopy JTF_VARCHAR2_TABLE_100
848: , p10_a21 in out nocopy JTF_VARCHAR2_TABLE_200
849: , p10_a22 in out nocopy JTF_VARCHAR2_TABLE_200
850: , p10_a23 in out nocopy JTF_VARCHAR2_TABLE_200