9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_rm_material_as_pvt.material_req_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_rm_material_as_pvt.material_req_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_NUMBER_TABLE
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_rm_material_as_pvt.material_req_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_200
25: , a12 JTF_VARCHAR2_TABLE_200
26: , a13 JTF_VARCHAR2_TABLE_200
36: , a23 JTF_VARCHAR2_TABLE_200
37: , a24 JTF_VARCHAR2_TABLE_200
38: , a25 JTF_VARCHAR2_TABLE_200
39: , a26 JTF_DATE_TABLE
40: , a27 JTF_NUMBER_TABLE
41: , a28 JTF_DATE_TABLE
42: , a29 JTF_NUMBER_TABLE
43: , a30 JTF_NUMBER_TABLE
44: , a31 JTF_VARCHAR2_TABLE_100
38: , a25 JTF_VARCHAR2_TABLE_200
39: , a26 JTF_DATE_TABLE
40: , a27 JTF_NUMBER_TABLE
41: , a28 JTF_DATE_TABLE
42: , a29 JTF_NUMBER_TABLE
43: , a30 JTF_NUMBER_TABLE
44: , a31 JTF_VARCHAR2_TABLE_100
45: , a32 JTF_VARCHAR2_TABLE_4000
46: , a33 JTF_NUMBER_TABLE
39: , a26 JTF_DATE_TABLE
40: , a27 JTF_NUMBER_TABLE
41: , a28 JTF_DATE_TABLE
42: , a29 JTF_NUMBER_TABLE
43: , a30 JTF_NUMBER_TABLE
44: , a31 JTF_VARCHAR2_TABLE_100
45: , a32 JTF_VARCHAR2_TABLE_4000
46: , a33 JTF_NUMBER_TABLE
47: , a34 JTF_NUMBER_TABLE
42: , a29 JTF_NUMBER_TABLE
43: , a30 JTF_NUMBER_TABLE
44: , a31 JTF_VARCHAR2_TABLE_100
45: , a32 JTF_VARCHAR2_TABLE_4000
46: , a33 JTF_NUMBER_TABLE
47: , a34 JTF_NUMBER_TABLE
48: , a35 JTF_VARCHAR2_TABLE_100
49: , a36 JTF_NUMBER_TABLE
50: , a37 JTF_NUMBER_TABLE
43: , a30 JTF_NUMBER_TABLE
44: , a31 JTF_VARCHAR2_TABLE_100
45: , a32 JTF_VARCHAR2_TABLE_4000
46: , a33 JTF_NUMBER_TABLE
47: , a34 JTF_NUMBER_TABLE
48: , a35 JTF_VARCHAR2_TABLE_100
49: , a36 JTF_NUMBER_TABLE
50: , a37 JTF_NUMBER_TABLE
51: , a38 JTF_VARCHAR2_TABLE_100
45: , a32 JTF_VARCHAR2_TABLE_4000
46: , a33 JTF_NUMBER_TABLE
47: , a34 JTF_NUMBER_TABLE
48: , a35 JTF_VARCHAR2_TABLE_100
49: , a36 JTF_NUMBER_TABLE
50: , a37 JTF_NUMBER_TABLE
51: , a38 JTF_VARCHAR2_TABLE_100
52: , a39 JTF_VARCHAR2_TABLE_100
53: ) as
46: , a33 JTF_NUMBER_TABLE
47: , a34 JTF_NUMBER_TABLE
48: , a35 JTF_VARCHAR2_TABLE_100
49: , a36 JTF_NUMBER_TABLE
50: , a37 JTF_NUMBER_TABLE
51: , a38 JTF_VARCHAR2_TABLE_100
52: , a39 JTF_VARCHAR2_TABLE_100
53: ) as
54: ddindx binary_integer; indx binary_integer;
106: end loop;
107: end if;
108: end if;
109: end rosetta_table_copy_in_p1;
110: procedure rosetta_table_copy_out_p1(t ahl_rm_material_as_pvt.material_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
111: , a1 out nocopy JTF_NUMBER_TABLE
112: , a2 out nocopy JTF_NUMBER_TABLE
113: , a3 out nocopy JTF_VARCHAR2_TABLE_100
114: , a4 out nocopy JTF_VARCHAR2_TABLE_100
107: end if;
108: end if;
109: end rosetta_table_copy_in_p1;
110: procedure rosetta_table_copy_out_p1(t ahl_rm_material_as_pvt.material_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
111: , a1 out nocopy JTF_NUMBER_TABLE
112: , a2 out nocopy JTF_NUMBER_TABLE
113: , a3 out nocopy JTF_VARCHAR2_TABLE_100
114: , a4 out nocopy JTF_VARCHAR2_TABLE_100
115: , a5 out nocopy JTF_NUMBER_TABLE
108: end if;
109: end rosetta_table_copy_in_p1;
110: procedure rosetta_table_copy_out_p1(t ahl_rm_material_as_pvt.material_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
111: , a1 out nocopy JTF_NUMBER_TABLE
112: , a2 out nocopy JTF_NUMBER_TABLE
113: , a3 out nocopy JTF_VARCHAR2_TABLE_100
114: , a4 out nocopy JTF_VARCHAR2_TABLE_100
115: , a5 out nocopy JTF_NUMBER_TABLE
116: , a6 out nocopy JTF_NUMBER_TABLE
111: , a1 out nocopy JTF_NUMBER_TABLE
112: , a2 out nocopy JTF_NUMBER_TABLE
113: , a3 out nocopy JTF_VARCHAR2_TABLE_100
114: , a4 out nocopy JTF_VARCHAR2_TABLE_100
115: , a5 out nocopy JTF_NUMBER_TABLE
116: , a6 out nocopy JTF_NUMBER_TABLE
117: , a7 out nocopy JTF_VARCHAR2_TABLE_100
118: , a8 out nocopy JTF_VARCHAR2_TABLE_100
119: , a9 out nocopy JTF_NUMBER_TABLE
112: , a2 out nocopy JTF_NUMBER_TABLE
113: , a3 out nocopy JTF_VARCHAR2_TABLE_100
114: , a4 out nocopy JTF_VARCHAR2_TABLE_100
115: , a5 out nocopy JTF_NUMBER_TABLE
116: , a6 out nocopy JTF_NUMBER_TABLE
117: , a7 out nocopy JTF_VARCHAR2_TABLE_100
118: , a8 out nocopy JTF_VARCHAR2_TABLE_100
119: , a9 out nocopy JTF_NUMBER_TABLE
120: , a10 out nocopy JTF_VARCHAR2_TABLE_100
115: , a5 out nocopy JTF_NUMBER_TABLE
116: , a6 out nocopy JTF_NUMBER_TABLE
117: , a7 out nocopy JTF_VARCHAR2_TABLE_100
118: , a8 out nocopy JTF_VARCHAR2_TABLE_100
119: , a9 out nocopy JTF_NUMBER_TABLE
120: , a10 out nocopy JTF_VARCHAR2_TABLE_100
121: , a11 out nocopy JTF_VARCHAR2_TABLE_200
122: , a12 out nocopy JTF_VARCHAR2_TABLE_200
123: , a13 out nocopy JTF_VARCHAR2_TABLE_200
133: , a23 out nocopy JTF_VARCHAR2_TABLE_200
134: , a24 out nocopy JTF_VARCHAR2_TABLE_200
135: , a25 out nocopy JTF_VARCHAR2_TABLE_200
136: , a26 out nocopy JTF_DATE_TABLE
137: , a27 out nocopy JTF_NUMBER_TABLE
138: , a28 out nocopy JTF_DATE_TABLE
139: , a29 out nocopy JTF_NUMBER_TABLE
140: , a30 out nocopy JTF_NUMBER_TABLE
141: , a31 out nocopy JTF_VARCHAR2_TABLE_100
135: , a25 out nocopy JTF_VARCHAR2_TABLE_200
136: , a26 out nocopy JTF_DATE_TABLE
137: , a27 out nocopy JTF_NUMBER_TABLE
138: , a28 out nocopy JTF_DATE_TABLE
139: , a29 out nocopy JTF_NUMBER_TABLE
140: , a30 out nocopy JTF_NUMBER_TABLE
141: , a31 out nocopy JTF_VARCHAR2_TABLE_100
142: , a32 out nocopy JTF_VARCHAR2_TABLE_4000
143: , a33 out nocopy JTF_NUMBER_TABLE
136: , a26 out nocopy JTF_DATE_TABLE
137: , a27 out nocopy JTF_NUMBER_TABLE
138: , a28 out nocopy JTF_DATE_TABLE
139: , a29 out nocopy JTF_NUMBER_TABLE
140: , a30 out nocopy JTF_NUMBER_TABLE
141: , a31 out nocopy JTF_VARCHAR2_TABLE_100
142: , a32 out nocopy JTF_VARCHAR2_TABLE_4000
143: , a33 out nocopy JTF_NUMBER_TABLE
144: , a34 out nocopy JTF_NUMBER_TABLE
139: , a29 out nocopy JTF_NUMBER_TABLE
140: , a30 out nocopy JTF_NUMBER_TABLE
141: , a31 out nocopy JTF_VARCHAR2_TABLE_100
142: , a32 out nocopy JTF_VARCHAR2_TABLE_4000
143: , a33 out nocopy JTF_NUMBER_TABLE
144: , a34 out nocopy JTF_NUMBER_TABLE
145: , a35 out nocopy JTF_VARCHAR2_TABLE_100
146: , a36 out nocopy JTF_NUMBER_TABLE
147: , a37 out nocopy JTF_NUMBER_TABLE
140: , a30 out nocopy JTF_NUMBER_TABLE
141: , a31 out nocopy JTF_VARCHAR2_TABLE_100
142: , a32 out nocopy JTF_VARCHAR2_TABLE_4000
143: , a33 out nocopy JTF_NUMBER_TABLE
144: , a34 out nocopy JTF_NUMBER_TABLE
145: , a35 out nocopy JTF_VARCHAR2_TABLE_100
146: , a36 out nocopy JTF_NUMBER_TABLE
147: , a37 out nocopy JTF_NUMBER_TABLE
148: , a38 out nocopy JTF_VARCHAR2_TABLE_100
142: , a32 out nocopy JTF_VARCHAR2_TABLE_4000
143: , a33 out nocopy JTF_NUMBER_TABLE
144: , a34 out nocopy JTF_NUMBER_TABLE
145: , a35 out nocopy JTF_VARCHAR2_TABLE_100
146: , a36 out nocopy JTF_NUMBER_TABLE
147: , a37 out nocopy JTF_NUMBER_TABLE
148: , a38 out nocopy JTF_VARCHAR2_TABLE_100
149: , a39 out nocopy JTF_VARCHAR2_TABLE_100
150: ) as
143: , a33 out nocopy JTF_NUMBER_TABLE
144: , a34 out nocopy JTF_NUMBER_TABLE
145: , a35 out nocopy JTF_VARCHAR2_TABLE_100
146: , a36 out nocopy JTF_NUMBER_TABLE
147: , a37 out nocopy JTF_NUMBER_TABLE
148: , a38 out nocopy JTF_VARCHAR2_TABLE_100
149: , a39 out nocopy JTF_VARCHAR2_TABLE_100
150: ) as
151: ddindx binary_integer; indx binary_integer;
150: ) as
151: ddindx binary_integer; indx binary_integer;
152: begin
153: if t is null or t.count = 0 then
154: a0 := JTF_NUMBER_TABLE();
155: a1 := JTF_NUMBER_TABLE();
156: a2 := JTF_NUMBER_TABLE();
157: a3 := JTF_VARCHAR2_TABLE_100();
158: a4 := JTF_VARCHAR2_TABLE_100();
151: ddindx binary_integer; indx binary_integer;
152: begin
153: if t is null or t.count = 0 then
154: a0 := JTF_NUMBER_TABLE();
155: a1 := JTF_NUMBER_TABLE();
156: a2 := JTF_NUMBER_TABLE();
157: a3 := JTF_VARCHAR2_TABLE_100();
158: a4 := JTF_VARCHAR2_TABLE_100();
159: a5 := JTF_NUMBER_TABLE();
152: begin
153: if t is null or t.count = 0 then
154: a0 := JTF_NUMBER_TABLE();
155: a1 := JTF_NUMBER_TABLE();
156: a2 := JTF_NUMBER_TABLE();
157: a3 := JTF_VARCHAR2_TABLE_100();
158: a4 := JTF_VARCHAR2_TABLE_100();
159: a5 := JTF_NUMBER_TABLE();
160: a6 := JTF_NUMBER_TABLE();
155: a1 := JTF_NUMBER_TABLE();
156: a2 := JTF_NUMBER_TABLE();
157: a3 := JTF_VARCHAR2_TABLE_100();
158: a4 := JTF_VARCHAR2_TABLE_100();
159: a5 := JTF_NUMBER_TABLE();
160: a6 := JTF_NUMBER_TABLE();
161: a7 := JTF_VARCHAR2_TABLE_100();
162: a8 := JTF_VARCHAR2_TABLE_100();
163: a9 := JTF_NUMBER_TABLE();
156: a2 := JTF_NUMBER_TABLE();
157: a3 := JTF_VARCHAR2_TABLE_100();
158: a4 := JTF_VARCHAR2_TABLE_100();
159: a5 := JTF_NUMBER_TABLE();
160: a6 := JTF_NUMBER_TABLE();
161: a7 := JTF_VARCHAR2_TABLE_100();
162: a8 := JTF_VARCHAR2_TABLE_100();
163: a9 := JTF_NUMBER_TABLE();
164: a10 := JTF_VARCHAR2_TABLE_100();
159: a5 := JTF_NUMBER_TABLE();
160: a6 := JTF_NUMBER_TABLE();
161: a7 := JTF_VARCHAR2_TABLE_100();
162: a8 := JTF_VARCHAR2_TABLE_100();
163: a9 := JTF_NUMBER_TABLE();
164: a10 := JTF_VARCHAR2_TABLE_100();
165: a11 := JTF_VARCHAR2_TABLE_200();
166: a12 := JTF_VARCHAR2_TABLE_200();
167: a13 := JTF_VARCHAR2_TABLE_200();
177: a23 := JTF_VARCHAR2_TABLE_200();
178: a24 := JTF_VARCHAR2_TABLE_200();
179: a25 := JTF_VARCHAR2_TABLE_200();
180: a26 := JTF_DATE_TABLE();
181: a27 := JTF_NUMBER_TABLE();
182: a28 := JTF_DATE_TABLE();
183: a29 := JTF_NUMBER_TABLE();
184: a30 := JTF_NUMBER_TABLE();
185: a31 := JTF_VARCHAR2_TABLE_100();
179: a25 := JTF_VARCHAR2_TABLE_200();
180: a26 := JTF_DATE_TABLE();
181: a27 := JTF_NUMBER_TABLE();
182: a28 := JTF_DATE_TABLE();
183: a29 := JTF_NUMBER_TABLE();
184: a30 := JTF_NUMBER_TABLE();
185: a31 := JTF_VARCHAR2_TABLE_100();
186: a32 := JTF_VARCHAR2_TABLE_4000();
187: a33 := JTF_NUMBER_TABLE();
180: a26 := JTF_DATE_TABLE();
181: a27 := JTF_NUMBER_TABLE();
182: a28 := JTF_DATE_TABLE();
183: a29 := JTF_NUMBER_TABLE();
184: a30 := JTF_NUMBER_TABLE();
185: a31 := JTF_VARCHAR2_TABLE_100();
186: a32 := JTF_VARCHAR2_TABLE_4000();
187: a33 := JTF_NUMBER_TABLE();
188: a34 := JTF_NUMBER_TABLE();
183: a29 := JTF_NUMBER_TABLE();
184: a30 := JTF_NUMBER_TABLE();
185: a31 := JTF_VARCHAR2_TABLE_100();
186: a32 := JTF_VARCHAR2_TABLE_4000();
187: a33 := JTF_NUMBER_TABLE();
188: a34 := JTF_NUMBER_TABLE();
189: a35 := JTF_VARCHAR2_TABLE_100();
190: a36 := JTF_NUMBER_TABLE();
191: a37 := JTF_NUMBER_TABLE();
184: a30 := JTF_NUMBER_TABLE();
185: a31 := JTF_VARCHAR2_TABLE_100();
186: a32 := JTF_VARCHAR2_TABLE_4000();
187: a33 := JTF_NUMBER_TABLE();
188: a34 := JTF_NUMBER_TABLE();
189: a35 := JTF_VARCHAR2_TABLE_100();
190: a36 := JTF_NUMBER_TABLE();
191: a37 := JTF_NUMBER_TABLE();
192: a38 := JTF_VARCHAR2_TABLE_100();
186: a32 := JTF_VARCHAR2_TABLE_4000();
187: a33 := JTF_NUMBER_TABLE();
188: a34 := JTF_NUMBER_TABLE();
189: a35 := JTF_VARCHAR2_TABLE_100();
190: a36 := JTF_NUMBER_TABLE();
191: a37 := JTF_NUMBER_TABLE();
192: a38 := JTF_VARCHAR2_TABLE_100();
193: a39 := JTF_VARCHAR2_TABLE_100();
194: else
187: a33 := JTF_NUMBER_TABLE();
188: a34 := JTF_NUMBER_TABLE();
189: a35 := JTF_VARCHAR2_TABLE_100();
190: a36 := JTF_NUMBER_TABLE();
191: a37 := JTF_NUMBER_TABLE();
192: a38 := JTF_VARCHAR2_TABLE_100();
193: a39 := JTF_VARCHAR2_TABLE_100();
194: else
195: a0 := JTF_NUMBER_TABLE();
191: a37 := JTF_NUMBER_TABLE();
192: a38 := JTF_VARCHAR2_TABLE_100();
193: a39 := JTF_VARCHAR2_TABLE_100();
194: else
195: a0 := JTF_NUMBER_TABLE();
196: a1 := JTF_NUMBER_TABLE();
197: a2 := JTF_NUMBER_TABLE();
198: a3 := JTF_VARCHAR2_TABLE_100();
199: a4 := JTF_VARCHAR2_TABLE_100();
192: a38 := JTF_VARCHAR2_TABLE_100();
193: a39 := JTF_VARCHAR2_TABLE_100();
194: else
195: a0 := JTF_NUMBER_TABLE();
196: a1 := JTF_NUMBER_TABLE();
197: a2 := JTF_NUMBER_TABLE();
198: a3 := JTF_VARCHAR2_TABLE_100();
199: a4 := JTF_VARCHAR2_TABLE_100();
200: a5 := JTF_NUMBER_TABLE();
193: a39 := JTF_VARCHAR2_TABLE_100();
194: else
195: a0 := JTF_NUMBER_TABLE();
196: a1 := JTF_NUMBER_TABLE();
197: a2 := JTF_NUMBER_TABLE();
198: a3 := JTF_VARCHAR2_TABLE_100();
199: a4 := JTF_VARCHAR2_TABLE_100();
200: a5 := JTF_NUMBER_TABLE();
201: a6 := JTF_NUMBER_TABLE();
196: a1 := JTF_NUMBER_TABLE();
197: a2 := JTF_NUMBER_TABLE();
198: a3 := JTF_VARCHAR2_TABLE_100();
199: a4 := JTF_VARCHAR2_TABLE_100();
200: a5 := JTF_NUMBER_TABLE();
201: a6 := JTF_NUMBER_TABLE();
202: a7 := JTF_VARCHAR2_TABLE_100();
203: a8 := JTF_VARCHAR2_TABLE_100();
204: a9 := JTF_NUMBER_TABLE();
197: a2 := JTF_NUMBER_TABLE();
198: a3 := JTF_VARCHAR2_TABLE_100();
199: a4 := JTF_VARCHAR2_TABLE_100();
200: a5 := JTF_NUMBER_TABLE();
201: a6 := JTF_NUMBER_TABLE();
202: a7 := JTF_VARCHAR2_TABLE_100();
203: a8 := JTF_VARCHAR2_TABLE_100();
204: a9 := JTF_NUMBER_TABLE();
205: a10 := JTF_VARCHAR2_TABLE_100();
200: a5 := JTF_NUMBER_TABLE();
201: a6 := JTF_NUMBER_TABLE();
202: a7 := JTF_VARCHAR2_TABLE_100();
203: a8 := JTF_VARCHAR2_TABLE_100();
204: a9 := JTF_NUMBER_TABLE();
205: a10 := JTF_VARCHAR2_TABLE_100();
206: a11 := JTF_VARCHAR2_TABLE_200();
207: a12 := JTF_VARCHAR2_TABLE_200();
208: a13 := JTF_VARCHAR2_TABLE_200();
218: a23 := JTF_VARCHAR2_TABLE_200();
219: a24 := JTF_VARCHAR2_TABLE_200();
220: a25 := JTF_VARCHAR2_TABLE_200();
221: a26 := JTF_DATE_TABLE();
222: a27 := JTF_NUMBER_TABLE();
223: a28 := JTF_DATE_TABLE();
224: a29 := JTF_NUMBER_TABLE();
225: a30 := JTF_NUMBER_TABLE();
226: a31 := JTF_VARCHAR2_TABLE_100();
220: a25 := JTF_VARCHAR2_TABLE_200();
221: a26 := JTF_DATE_TABLE();
222: a27 := JTF_NUMBER_TABLE();
223: a28 := JTF_DATE_TABLE();
224: a29 := JTF_NUMBER_TABLE();
225: a30 := JTF_NUMBER_TABLE();
226: a31 := JTF_VARCHAR2_TABLE_100();
227: a32 := JTF_VARCHAR2_TABLE_4000();
228: a33 := JTF_NUMBER_TABLE();
221: a26 := JTF_DATE_TABLE();
222: a27 := JTF_NUMBER_TABLE();
223: a28 := JTF_DATE_TABLE();
224: a29 := JTF_NUMBER_TABLE();
225: a30 := JTF_NUMBER_TABLE();
226: a31 := JTF_VARCHAR2_TABLE_100();
227: a32 := JTF_VARCHAR2_TABLE_4000();
228: a33 := JTF_NUMBER_TABLE();
229: a34 := JTF_NUMBER_TABLE();
224: a29 := JTF_NUMBER_TABLE();
225: a30 := JTF_NUMBER_TABLE();
226: a31 := JTF_VARCHAR2_TABLE_100();
227: a32 := JTF_VARCHAR2_TABLE_4000();
228: a33 := JTF_NUMBER_TABLE();
229: a34 := JTF_NUMBER_TABLE();
230: a35 := JTF_VARCHAR2_TABLE_100();
231: a36 := JTF_NUMBER_TABLE();
232: a37 := JTF_NUMBER_TABLE();
225: a30 := JTF_NUMBER_TABLE();
226: a31 := JTF_VARCHAR2_TABLE_100();
227: a32 := JTF_VARCHAR2_TABLE_4000();
228: a33 := JTF_NUMBER_TABLE();
229: a34 := JTF_NUMBER_TABLE();
230: a35 := JTF_VARCHAR2_TABLE_100();
231: a36 := JTF_NUMBER_TABLE();
232: a37 := JTF_NUMBER_TABLE();
233: a38 := JTF_VARCHAR2_TABLE_100();
227: a32 := JTF_VARCHAR2_TABLE_4000();
228: a33 := JTF_NUMBER_TABLE();
229: a34 := JTF_NUMBER_TABLE();
230: a35 := JTF_VARCHAR2_TABLE_100();
231: a36 := JTF_NUMBER_TABLE();
232: a37 := JTF_NUMBER_TABLE();
233: a38 := JTF_VARCHAR2_TABLE_100();
234: a39 := JTF_VARCHAR2_TABLE_100();
235: if t.count > 0 then
228: a33 := JTF_NUMBER_TABLE();
229: a34 := JTF_NUMBER_TABLE();
230: a35 := JTF_VARCHAR2_TABLE_100();
231: a36 := JTF_NUMBER_TABLE();
232: a37 := JTF_NUMBER_TABLE();
233: a38 := JTF_VARCHAR2_TABLE_100();
234: a39 := JTF_VARCHAR2_TABLE_100();
235: if t.count > 0 then
236: a0.extend(t.count);
325: end if;
326: end if;
327: end rosetta_table_copy_out_p1;
328:
329: procedure rosetta_table_copy_in_p3(t out nocopy ahl_rm_material_as_pvt.route_efct_tbl_type, a0 JTF_NUMBER_TABLE
330: , a1 JTF_VARCHAR2_TABLE_100
331: , a2 JTF_NUMBER_TABLE
332: , a3 JTF_NUMBER_TABLE
333: , a4 JTF_VARCHAR2_TABLE_100
327: end rosetta_table_copy_out_p1;
328:
329: procedure rosetta_table_copy_in_p3(t out nocopy ahl_rm_material_as_pvt.route_efct_tbl_type, a0 JTF_NUMBER_TABLE
330: , a1 JTF_VARCHAR2_TABLE_100
331: , a2 JTF_NUMBER_TABLE
332: , a3 JTF_NUMBER_TABLE
333: , a4 JTF_VARCHAR2_TABLE_100
334: , a5 JTF_VARCHAR2_TABLE_300
335: , a6 JTF_VARCHAR2_TABLE_100
328:
329: procedure rosetta_table_copy_in_p3(t out nocopy ahl_rm_material_as_pvt.route_efct_tbl_type, a0 JTF_NUMBER_TABLE
330: , a1 JTF_VARCHAR2_TABLE_100
331: , a2 JTF_NUMBER_TABLE
332: , a3 JTF_NUMBER_TABLE
333: , a4 JTF_VARCHAR2_TABLE_100
334: , a5 JTF_VARCHAR2_TABLE_300
335: , a6 JTF_VARCHAR2_TABLE_100
336: , a7 JTF_NUMBER_TABLE
332: , a3 JTF_NUMBER_TABLE
333: , a4 JTF_VARCHAR2_TABLE_100
334: , a5 JTF_VARCHAR2_TABLE_300
335: , a6 JTF_VARCHAR2_TABLE_100
336: , a7 JTF_NUMBER_TABLE
337: , a8 JTF_VARCHAR2_TABLE_100
338: , a9 JTF_NUMBER_TABLE
339: , a10 JTF_VARCHAR2_TABLE_100
340: , a11 JTF_VARCHAR2_TABLE_300
334: , a5 JTF_VARCHAR2_TABLE_300
335: , a6 JTF_VARCHAR2_TABLE_100
336: , a7 JTF_NUMBER_TABLE
337: , a8 JTF_VARCHAR2_TABLE_100
338: , a9 JTF_NUMBER_TABLE
339: , a10 JTF_VARCHAR2_TABLE_100
340: , a11 JTF_VARCHAR2_TABLE_300
341: , a12 JTF_NUMBER_TABLE
342: , a13 JTF_DATE_TABLE
337: , a8 JTF_VARCHAR2_TABLE_100
338: , a9 JTF_NUMBER_TABLE
339: , a10 JTF_VARCHAR2_TABLE_100
340: , a11 JTF_VARCHAR2_TABLE_300
341: , a12 JTF_NUMBER_TABLE
342: , a13 JTF_DATE_TABLE
343: , a14 JTF_NUMBER_TABLE
344: , a15 JTF_DATE_TABLE
345: , a16 JTF_NUMBER_TABLE
339: , a10 JTF_VARCHAR2_TABLE_100
340: , a11 JTF_VARCHAR2_TABLE_300
341: , a12 JTF_NUMBER_TABLE
342: , a13 JTF_DATE_TABLE
343: , a14 JTF_NUMBER_TABLE
344: , a15 JTF_DATE_TABLE
345: , a16 JTF_NUMBER_TABLE
346: , a17 JTF_NUMBER_TABLE
347: , a18 JTF_NUMBER_TABLE
341: , a12 JTF_NUMBER_TABLE
342: , a13 JTF_DATE_TABLE
343: , a14 JTF_NUMBER_TABLE
344: , a15 JTF_DATE_TABLE
345: , a16 JTF_NUMBER_TABLE
346: , a17 JTF_NUMBER_TABLE
347: , a18 JTF_NUMBER_TABLE
348: , a19 JTF_NUMBER_TABLE
349: , a20 JTF_VARCHAR2_TABLE_100
342: , a13 JTF_DATE_TABLE
343: , a14 JTF_NUMBER_TABLE
344: , a15 JTF_DATE_TABLE
345: , a16 JTF_NUMBER_TABLE
346: , a17 JTF_NUMBER_TABLE
347: , a18 JTF_NUMBER_TABLE
348: , a19 JTF_NUMBER_TABLE
349: , a20 JTF_VARCHAR2_TABLE_100
350: , a21 JTF_VARCHAR2_TABLE_200
343: , a14 JTF_NUMBER_TABLE
344: , a15 JTF_DATE_TABLE
345: , a16 JTF_NUMBER_TABLE
346: , a17 JTF_NUMBER_TABLE
347: , a18 JTF_NUMBER_TABLE
348: , a19 JTF_NUMBER_TABLE
349: , a20 JTF_VARCHAR2_TABLE_100
350: , a21 JTF_VARCHAR2_TABLE_200
351: , a22 JTF_VARCHAR2_TABLE_200
344: , a15 JTF_DATE_TABLE
345: , a16 JTF_NUMBER_TABLE
346: , a17 JTF_NUMBER_TABLE
347: , a18 JTF_NUMBER_TABLE
348: , a19 JTF_NUMBER_TABLE
349: , a20 JTF_VARCHAR2_TABLE_100
350: , a21 JTF_VARCHAR2_TABLE_200
351: , a22 JTF_VARCHAR2_TABLE_200
352: , a23 JTF_VARCHAR2_TABLE_200
416: end loop;
417: end if;
418: end if;
419: end rosetta_table_copy_in_p3;
420: procedure rosetta_table_copy_out_p3(t ahl_rm_material_as_pvt.route_efct_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
421: , a1 out nocopy JTF_VARCHAR2_TABLE_100
422: , a2 out nocopy JTF_NUMBER_TABLE
423: , a3 out nocopy JTF_NUMBER_TABLE
424: , a4 out nocopy JTF_VARCHAR2_TABLE_100
418: end if;
419: end rosetta_table_copy_in_p3;
420: procedure rosetta_table_copy_out_p3(t ahl_rm_material_as_pvt.route_efct_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
421: , a1 out nocopy JTF_VARCHAR2_TABLE_100
422: , a2 out nocopy JTF_NUMBER_TABLE
423: , a3 out nocopy JTF_NUMBER_TABLE
424: , a4 out nocopy JTF_VARCHAR2_TABLE_100
425: , a5 out nocopy JTF_VARCHAR2_TABLE_300
426: , a6 out nocopy JTF_VARCHAR2_TABLE_100
419: end rosetta_table_copy_in_p3;
420: procedure rosetta_table_copy_out_p3(t ahl_rm_material_as_pvt.route_efct_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
421: , a1 out nocopy JTF_VARCHAR2_TABLE_100
422: , a2 out nocopy JTF_NUMBER_TABLE
423: , a3 out nocopy JTF_NUMBER_TABLE
424: , a4 out nocopy JTF_VARCHAR2_TABLE_100
425: , a5 out nocopy JTF_VARCHAR2_TABLE_300
426: , a6 out nocopy JTF_VARCHAR2_TABLE_100
427: , a7 out nocopy JTF_NUMBER_TABLE
423: , a3 out nocopy JTF_NUMBER_TABLE
424: , a4 out nocopy JTF_VARCHAR2_TABLE_100
425: , a5 out nocopy JTF_VARCHAR2_TABLE_300
426: , a6 out nocopy JTF_VARCHAR2_TABLE_100
427: , a7 out nocopy JTF_NUMBER_TABLE
428: , a8 out nocopy JTF_VARCHAR2_TABLE_100
429: , a9 out nocopy JTF_NUMBER_TABLE
430: , a10 out nocopy JTF_VARCHAR2_TABLE_100
431: , a11 out nocopy JTF_VARCHAR2_TABLE_300
425: , a5 out nocopy JTF_VARCHAR2_TABLE_300
426: , a6 out nocopy JTF_VARCHAR2_TABLE_100
427: , a7 out nocopy JTF_NUMBER_TABLE
428: , a8 out nocopy JTF_VARCHAR2_TABLE_100
429: , a9 out nocopy JTF_NUMBER_TABLE
430: , a10 out nocopy JTF_VARCHAR2_TABLE_100
431: , a11 out nocopy JTF_VARCHAR2_TABLE_300
432: , a12 out nocopy JTF_NUMBER_TABLE
433: , a13 out nocopy JTF_DATE_TABLE
428: , a8 out nocopy JTF_VARCHAR2_TABLE_100
429: , a9 out nocopy JTF_NUMBER_TABLE
430: , a10 out nocopy JTF_VARCHAR2_TABLE_100
431: , a11 out nocopy JTF_VARCHAR2_TABLE_300
432: , a12 out nocopy JTF_NUMBER_TABLE
433: , a13 out nocopy JTF_DATE_TABLE
434: , a14 out nocopy JTF_NUMBER_TABLE
435: , a15 out nocopy JTF_DATE_TABLE
436: , a16 out nocopy JTF_NUMBER_TABLE
430: , a10 out nocopy JTF_VARCHAR2_TABLE_100
431: , a11 out nocopy JTF_VARCHAR2_TABLE_300
432: , a12 out nocopy JTF_NUMBER_TABLE
433: , a13 out nocopy JTF_DATE_TABLE
434: , a14 out nocopy JTF_NUMBER_TABLE
435: , a15 out nocopy JTF_DATE_TABLE
436: , a16 out nocopy JTF_NUMBER_TABLE
437: , a17 out nocopy JTF_NUMBER_TABLE
438: , a18 out nocopy JTF_NUMBER_TABLE
432: , a12 out nocopy JTF_NUMBER_TABLE
433: , a13 out nocopy JTF_DATE_TABLE
434: , a14 out nocopy JTF_NUMBER_TABLE
435: , a15 out nocopy JTF_DATE_TABLE
436: , a16 out nocopy JTF_NUMBER_TABLE
437: , a17 out nocopy JTF_NUMBER_TABLE
438: , a18 out nocopy JTF_NUMBER_TABLE
439: , a19 out nocopy JTF_NUMBER_TABLE
440: , a20 out nocopy JTF_VARCHAR2_TABLE_100
433: , a13 out nocopy JTF_DATE_TABLE
434: , a14 out nocopy JTF_NUMBER_TABLE
435: , a15 out nocopy JTF_DATE_TABLE
436: , a16 out nocopy JTF_NUMBER_TABLE
437: , a17 out nocopy JTF_NUMBER_TABLE
438: , a18 out nocopy JTF_NUMBER_TABLE
439: , a19 out nocopy JTF_NUMBER_TABLE
440: , a20 out nocopy JTF_VARCHAR2_TABLE_100
441: , a21 out nocopy JTF_VARCHAR2_TABLE_200
434: , a14 out nocopy JTF_NUMBER_TABLE
435: , a15 out nocopy JTF_DATE_TABLE
436: , a16 out nocopy JTF_NUMBER_TABLE
437: , a17 out nocopy JTF_NUMBER_TABLE
438: , a18 out nocopy JTF_NUMBER_TABLE
439: , a19 out nocopy JTF_NUMBER_TABLE
440: , a20 out nocopy JTF_VARCHAR2_TABLE_100
441: , a21 out nocopy JTF_VARCHAR2_TABLE_200
442: , a22 out nocopy JTF_VARCHAR2_TABLE_200
435: , a15 out nocopy JTF_DATE_TABLE
436: , a16 out nocopy JTF_NUMBER_TABLE
437: , a17 out nocopy JTF_NUMBER_TABLE
438: , a18 out nocopy JTF_NUMBER_TABLE
439: , a19 out nocopy JTF_NUMBER_TABLE
440: , a20 out nocopy JTF_VARCHAR2_TABLE_100
441: , a21 out nocopy JTF_VARCHAR2_TABLE_200
442: , a22 out nocopy JTF_VARCHAR2_TABLE_200
443: , a23 out nocopy JTF_VARCHAR2_TABLE_200
457: ) as
458: ddindx binary_integer; indx binary_integer;
459: begin
460: if t is null or t.count = 0 then
461: a0 := JTF_NUMBER_TABLE();
462: a1 := JTF_VARCHAR2_TABLE_100();
463: a2 := JTF_NUMBER_TABLE();
464: a3 := JTF_NUMBER_TABLE();
465: a4 := JTF_VARCHAR2_TABLE_100();
459: begin
460: if t is null or t.count = 0 then
461: a0 := JTF_NUMBER_TABLE();
462: a1 := JTF_VARCHAR2_TABLE_100();
463: a2 := JTF_NUMBER_TABLE();
464: a3 := JTF_NUMBER_TABLE();
465: a4 := JTF_VARCHAR2_TABLE_100();
466: a5 := JTF_VARCHAR2_TABLE_300();
467: a6 := JTF_VARCHAR2_TABLE_100();
460: if t is null or t.count = 0 then
461: a0 := JTF_NUMBER_TABLE();
462: a1 := JTF_VARCHAR2_TABLE_100();
463: a2 := JTF_NUMBER_TABLE();
464: a3 := JTF_NUMBER_TABLE();
465: a4 := JTF_VARCHAR2_TABLE_100();
466: a5 := JTF_VARCHAR2_TABLE_300();
467: a6 := JTF_VARCHAR2_TABLE_100();
468: a7 := JTF_NUMBER_TABLE();
464: a3 := JTF_NUMBER_TABLE();
465: a4 := JTF_VARCHAR2_TABLE_100();
466: a5 := JTF_VARCHAR2_TABLE_300();
467: a6 := JTF_VARCHAR2_TABLE_100();
468: a7 := JTF_NUMBER_TABLE();
469: a8 := JTF_VARCHAR2_TABLE_100();
470: a9 := JTF_NUMBER_TABLE();
471: a10 := JTF_VARCHAR2_TABLE_100();
472: a11 := JTF_VARCHAR2_TABLE_300();
466: a5 := JTF_VARCHAR2_TABLE_300();
467: a6 := JTF_VARCHAR2_TABLE_100();
468: a7 := JTF_NUMBER_TABLE();
469: a8 := JTF_VARCHAR2_TABLE_100();
470: a9 := JTF_NUMBER_TABLE();
471: a10 := JTF_VARCHAR2_TABLE_100();
472: a11 := JTF_VARCHAR2_TABLE_300();
473: a12 := JTF_NUMBER_TABLE();
474: a13 := JTF_DATE_TABLE();
469: a8 := JTF_VARCHAR2_TABLE_100();
470: a9 := JTF_NUMBER_TABLE();
471: a10 := JTF_VARCHAR2_TABLE_100();
472: a11 := JTF_VARCHAR2_TABLE_300();
473: a12 := JTF_NUMBER_TABLE();
474: a13 := JTF_DATE_TABLE();
475: a14 := JTF_NUMBER_TABLE();
476: a15 := JTF_DATE_TABLE();
477: a16 := JTF_NUMBER_TABLE();
471: a10 := JTF_VARCHAR2_TABLE_100();
472: a11 := JTF_VARCHAR2_TABLE_300();
473: a12 := JTF_NUMBER_TABLE();
474: a13 := JTF_DATE_TABLE();
475: a14 := JTF_NUMBER_TABLE();
476: a15 := JTF_DATE_TABLE();
477: a16 := JTF_NUMBER_TABLE();
478: a17 := JTF_NUMBER_TABLE();
479: a18 := JTF_NUMBER_TABLE();
473: a12 := JTF_NUMBER_TABLE();
474: a13 := JTF_DATE_TABLE();
475: a14 := JTF_NUMBER_TABLE();
476: a15 := JTF_DATE_TABLE();
477: a16 := JTF_NUMBER_TABLE();
478: a17 := JTF_NUMBER_TABLE();
479: a18 := JTF_NUMBER_TABLE();
480: a19 := JTF_NUMBER_TABLE();
481: a20 := JTF_VARCHAR2_TABLE_100();
474: a13 := JTF_DATE_TABLE();
475: a14 := JTF_NUMBER_TABLE();
476: a15 := JTF_DATE_TABLE();
477: a16 := JTF_NUMBER_TABLE();
478: a17 := JTF_NUMBER_TABLE();
479: a18 := JTF_NUMBER_TABLE();
480: a19 := JTF_NUMBER_TABLE();
481: a20 := JTF_VARCHAR2_TABLE_100();
482: a21 := JTF_VARCHAR2_TABLE_200();
475: a14 := JTF_NUMBER_TABLE();
476: a15 := JTF_DATE_TABLE();
477: a16 := JTF_NUMBER_TABLE();
478: a17 := JTF_NUMBER_TABLE();
479: a18 := JTF_NUMBER_TABLE();
480: a19 := JTF_NUMBER_TABLE();
481: a20 := JTF_VARCHAR2_TABLE_100();
482: a21 := JTF_VARCHAR2_TABLE_200();
483: a22 := JTF_VARCHAR2_TABLE_200();
476: a15 := JTF_DATE_TABLE();
477: a16 := JTF_NUMBER_TABLE();
478: a17 := JTF_NUMBER_TABLE();
479: a18 := JTF_NUMBER_TABLE();
480: a19 := JTF_NUMBER_TABLE();
481: a20 := JTF_VARCHAR2_TABLE_100();
482: a21 := JTF_VARCHAR2_TABLE_200();
483: a22 := JTF_VARCHAR2_TABLE_200();
484: a23 := JTF_VARCHAR2_TABLE_200();
495: a34 := JTF_VARCHAR2_TABLE_200();
496: a35 := JTF_VARCHAR2_TABLE_200();
497: a36 := JTF_VARCHAR2_TABLE_100();
498: else
499: a0 := JTF_NUMBER_TABLE();
500: a1 := JTF_VARCHAR2_TABLE_100();
501: a2 := JTF_NUMBER_TABLE();
502: a3 := JTF_NUMBER_TABLE();
503: a4 := JTF_VARCHAR2_TABLE_100();
497: a36 := JTF_VARCHAR2_TABLE_100();
498: else
499: a0 := JTF_NUMBER_TABLE();
500: a1 := JTF_VARCHAR2_TABLE_100();
501: a2 := JTF_NUMBER_TABLE();
502: a3 := JTF_NUMBER_TABLE();
503: a4 := JTF_VARCHAR2_TABLE_100();
504: a5 := JTF_VARCHAR2_TABLE_300();
505: a6 := JTF_VARCHAR2_TABLE_100();
498: else
499: a0 := JTF_NUMBER_TABLE();
500: a1 := JTF_VARCHAR2_TABLE_100();
501: a2 := JTF_NUMBER_TABLE();
502: a3 := JTF_NUMBER_TABLE();
503: a4 := JTF_VARCHAR2_TABLE_100();
504: a5 := JTF_VARCHAR2_TABLE_300();
505: a6 := JTF_VARCHAR2_TABLE_100();
506: a7 := JTF_NUMBER_TABLE();
502: a3 := JTF_NUMBER_TABLE();
503: a4 := JTF_VARCHAR2_TABLE_100();
504: a5 := JTF_VARCHAR2_TABLE_300();
505: a6 := JTF_VARCHAR2_TABLE_100();
506: a7 := JTF_NUMBER_TABLE();
507: a8 := JTF_VARCHAR2_TABLE_100();
508: a9 := JTF_NUMBER_TABLE();
509: a10 := JTF_VARCHAR2_TABLE_100();
510: a11 := JTF_VARCHAR2_TABLE_300();
504: a5 := JTF_VARCHAR2_TABLE_300();
505: a6 := JTF_VARCHAR2_TABLE_100();
506: a7 := JTF_NUMBER_TABLE();
507: a8 := JTF_VARCHAR2_TABLE_100();
508: a9 := JTF_NUMBER_TABLE();
509: a10 := JTF_VARCHAR2_TABLE_100();
510: a11 := JTF_VARCHAR2_TABLE_300();
511: a12 := JTF_NUMBER_TABLE();
512: a13 := JTF_DATE_TABLE();
507: a8 := JTF_VARCHAR2_TABLE_100();
508: a9 := JTF_NUMBER_TABLE();
509: a10 := JTF_VARCHAR2_TABLE_100();
510: a11 := JTF_VARCHAR2_TABLE_300();
511: a12 := JTF_NUMBER_TABLE();
512: a13 := JTF_DATE_TABLE();
513: a14 := JTF_NUMBER_TABLE();
514: a15 := JTF_DATE_TABLE();
515: a16 := JTF_NUMBER_TABLE();
509: a10 := JTF_VARCHAR2_TABLE_100();
510: a11 := JTF_VARCHAR2_TABLE_300();
511: a12 := JTF_NUMBER_TABLE();
512: a13 := JTF_DATE_TABLE();
513: a14 := JTF_NUMBER_TABLE();
514: a15 := JTF_DATE_TABLE();
515: a16 := JTF_NUMBER_TABLE();
516: a17 := JTF_NUMBER_TABLE();
517: a18 := JTF_NUMBER_TABLE();
511: a12 := JTF_NUMBER_TABLE();
512: a13 := JTF_DATE_TABLE();
513: a14 := JTF_NUMBER_TABLE();
514: a15 := JTF_DATE_TABLE();
515: a16 := JTF_NUMBER_TABLE();
516: a17 := JTF_NUMBER_TABLE();
517: a18 := JTF_NUMBER_TABLE();
518: a19 := JTF_NUMBER_TABLE();
519: a20 := JTF_VARCHAR2_TABLE_100();
512: a13 := JTF_DATE_TABLE();
513: a14 := JTF_NUMBER_TABLE();
514: a15 := JTF_DATE_TABLE();
515: a16 := JTF_NUMBER_TABLE();
516: a17 := JTF_NUMBER_TABLE();
517: a18 := JTF_NUMBER_TABLE();
518: a19 := JTF_NUMBER_TABLE();
519: a20 := JTF_VARCHAR2_TABLE_100();
520: a21 := JTF_VARCHAR2_TABLE_200();
513: a14 := JTF_NUMBER_TABLE();
514: a15 := JTF_DATE_TABLE();
515: a16 := JTF_NUMBER_TABLE();
516: a17 := JTF_NUMBER_TABLE();
517: a18 := JTF_NUMBER_TABLE();
518: a19 := JTF_NUMBER_TABLE();
519: a20 := JTF_VARCHAR2_TABLE_100();
520: a21 := JTF_VARCHAR2_TABLE_200();
521: a22 := JTF_VARCHAR2_TABLE_200();
514: a15 := JTF_DATE_TABLE();
515: a16 := JTF_NUMBER_TABLE();
516: a17 := JTF_NUMBER_TABLE();
517: a18 := JTF_NUMBER_TABLE();
518: a19 := JTF_NUMBER_TABLE();
519: a20 := JTF_VARCHAR2_TABLE_100();
520: a21 := JTF_VARCHAR2_TABLE_200();
521: a22 := JTF_VARCHAR2_TABLE_200();
522: a23 := JTF_VARCHAR2_TABLE_200();
629: , p_module_type VARCHAR2
630: , x_return_status out nocopy VARCHAR2
631: , x_msg_count out nocopy NUMBER
632: , x_msg_data out nocopy VARCHAR2
633: , p9_a0 in out nocopy JTF_NUMBER_TABLE
634: , p9_a1 in out nocopy JTF_NUMBER_TABLE
635: , p9_a2 in out nocopy JTF_NUMBER_TABLE
636: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
637: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
630: , x_return_status out nocopy VARCHAR2
631: , x_msg_count out nocopy NUMBER
632: , x_msg_data out nocopy VARCHAR2
633: , p9_a0 in out nocopy JTF_NUMBER_TABLE
634: , p9_a1 in out nocopy JTF_NUMBER_TABLE
635: , p9_a2 in out nocopy JTF_NUMBER_TABLE
636: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
637: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
638: , p9_a5 in out nocopy JTF_NUMBER_TABLE
631: , x_msg_count out nocopy NUMBER
632: , x_msg_data out nocopy VARCHAR2
633: , p9_a0 in out nocopy JTF_NUMBER_TABLE
634: , p9_a1 in out nocopy JTF_NUMBER_TABLE
635: , p9_a2 in out nocopy JTF_NUMBER_TABLE
636: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
637: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
638: , p9_a5 in out nocopy JTF_NUMBER_TABLE
639: , p9_a6 in out nocopy JTF_NUMBER_TABLE
634: , p9_a1 in out nocopy JTF_NUMBER_TABLE
635: , p9_a2 in out nocopy JTF_NUMBER_TABLE
636: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
637: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
638: , p9_a5 in out nocopy JTF_NUMBER_TABLE
639: , p9_a6 in out nocopy JTF_NUMBER_TABLE
640: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_100
641: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
642: , p9_a9 in out nocopy JTF_NUMBER_TABLE
635: , p9_a2 in out nocopy JTF_NUMBER_TABLE
636: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
637: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
638: , p9_a5 in out nocopy JTF_NUMBER_TABLE
639: , p9_a6 in out nocopy JTF_NUMBER_TABLE
640: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_100
641: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
642: , p9_a9 in out nocopy JTF_NUMBER_TABLE
643: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
638: , p9_a5 in out nocopy JTF_NUMBER_TABLE
639: , p9_a6 in out nocopy JTF_NUMBER_TABLE
640: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_100
641: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
642: , p9_a9 in out nocopy JTF_NUMBER_TABLE
643: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
644: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_200
645: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_200
646: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_200
656: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_200
657: , p9_a24 in out nocopy JTF_VARCHAR2_TABLE_200
658: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_200
659: , p9_a26 in out nocopy JTF_DATE_TABLE
660: , p9_a27 in out nocopy JTF_NUMBER_TABLE
661: , p9_a28 in out nocopy JTF_DATE_TABLE
662: , p9_a29 in out nocopy JTF_NUMBER_TABLE
663: , p9_a30 in out nocopy JTF_NUMBER_TABLE
664: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
658: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_200
659: , p9_a26 in out nocopy JTF_DATE_TABLE
660: , p9_a27 in out nocopy JTF_NUMBER_TABLE
661: , p9_a28 in out nocopy JTF_DATE_TABLE
662: , p9_a29 in out nocopy JTF_NUMBER_TABLE
663: , p9_a30 in out nocopy JTF_NUMBER_TABLE
664: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
665: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_4000
666: , p9_a33 in out nocopy JTF_NUMBER_TABLE
659: , p9_a26 in out nocopy JTF_DATE_TABLE
660: , p9_a27 in out nocopy JTF_NUMBER_TABLE
661: , p9_a28 in out nocopy JTF_DATE_TABLE
662: , p9_a29 in out nocopy JTF_NUMBER_TABLE
663: , p9_a30 in out nocopy JTF_NUMBER_TABLE
664: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
665: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_4000
666: , p9_a33 in out nocopy JTF_NUMBER_TABLE
667: , p9_a34 in out nocopy JTF_NUMBER_TABLE
662: , p9_a29 in out nocopy JTF_NUMBER_TABLE
663: , p9_a30 in out nocopy JTF_NUMBER_TABLE
664: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
665: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_4000
666: , p9_a33 in out nocopy JTF_NUMBER_TABLE
667: , p9_a34 in out nocopy JTF_NUMBER_TABLE
668: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
669: , p9_a36 in out nocopy JTF_NUMBER_TABLE
670: , p9_a37 in out nocopy JTF_NUMBER_TABLE
663: , p9_a30 in out nocopy JTF_NUMBER_TABLE
664: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
665: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_4000
666: , p9_a33 in out nocopy JTF_NUMBER_TABLE
667: , p9_a34 in out nocopy JTF_NUMBER_TABLE
668: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
669: , p9_a36 in out nocopy JTF_NUMBER_TABLE
670: , p9_a37 in out nocopy JTF_NUMBER_TABLE
671: , p9_a38 in out nocopy JTF_VARCHAR2_TABLE_100
665: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_4000
666: , p9_a33 in out nocopy JTF_NUMBER_TABLE
667: , p9_a34 in out nocopy JTF_NUMBER_TABLE
668: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
669: , p9_a36 in out nocopy JTF_NUMBER_TABLE
670: , p9_a37 in out nocopy JTF_NUMBER_TABLE
671: , p9_a38 in out nocopy JTF_VARCHAR2_TABLE_100
672: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100
673: , p_object_id NUMBER
666: , p9_a33 in out nocopy JTF_NUMBER_TABLE
667: , p9_a34 in out nocopy JTF_NUMBER_TABLE
668: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
669: , p9_a36 in out nocopy JTF_NUMBER_TABLE
670: , p9_a37 in out nocopy JTF_NUMBER_TABLE
671: , p9_a38 in out nocopy JTF_VARCHAR2_TABLE_100
672: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100
673: , p_object_id NUMBER
674: , p_association_type VARCHAR2
811: , p_object_id NUMBER
812: , x_return_status out nocopy VARCHAR2
813: , x_msg_count out nocopy NUMBER
814: , x_msg_data out nocopy VARCHAR2
815: , p10_a0 in out nocopy JTF_NUMBER_TABLE
816: , p10_a1 in out nocopy JTF_VARCHAR2_TABLE_100
817: , p10_a2 in out nocopy JTF_NUMBER_TABLE
818: , p10_a3 in out nocopy JTF_NUMBER_TABLE
819: , p10_a4 in out nocopy JTF_VARCHAR2_TABLE_100
813: , x_msg_count out nocopy NUMBER
814: , x_msg_data out nocopy VARCHAR2
815: , p10_a0 in out nocopy JTF_NUMBER_TABLE
816: , p10_a1 in out nocopy JTF_VARCHAR2_TABLE_100
817: , p10_a2 in out nocopy JTF_NUMBER_TABLE
818: , p10_a3 in out nocopy JTF_NUMBER_TABLE
819: , p10_a4 in out nocopy JTF_VARCHAR2_TABLE_100
820: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_300
821: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
814: , x_msg_data out nocopy VARCHAR2
815: , p10_a0 in out nocopy JTF_NUMBER_TABLE
816: , p10_a1 in out nocopy JTF_VARCHAR2_TABLE_100
817: , p10_a2 in out nocopy JTF_NUMBER_TABLE
818: , p10_a3 in out nocopy JTF_NUMBER_TABLE
819: , p10_a4 in out nocopy JTF_VARCHAR2_TABLE_100
820: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_300
821: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
822: , p10_a7 in out nocopy JTF_NUMBER_TABLE
818: , p10_a3 in out nocopy JTF_NUMBER_TABLE
819: , p10_a4 in out nocopy JTF_VARCHAR2_TABLE_100
820: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_300
821: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
822: , p10_a7 in out nocopy JTF_NUMBER_TABLE
823: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
824: , p10_a9 in out nocopy JTF_NUMBER_TABLE
825: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
826: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_300
820: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_300
821: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
822: , p10_a7 in out nocopy JTF_NUMBER_TABLE
823: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
824: , p10_a9 in out nocopy JTF_NUMBER_TABLE
825: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
826: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_300
827: , p10_a12 in out nocopy JTF_NUMBER_TABLE
828: , p10_a13 in out nocopy JTF_DATE_TABLE
823: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
824: , p10_a9 in out nocopy JTF_NUMBER_TABLE
825: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
826: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_300
827: , p10_a12 in out nocopy JTF_NUMBER_TABLE
828: , p10_a13 in out nocopy JTF_DATE_TABLE
829: , p10_a14 in out nocopy JTF_NUMBER_TABLE
830: , p10_a15 in out nocopy JTF_DATE_TABLE
831: , p10_a16 in out nocopy JTF_NUMBER_TABLE
825: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
826: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_300
827: , p10_a12 in out nocopy JTF_NUMBER_TABLE
828: , p10_a13 in out nocopy JTF_DATE_TABLE
829: , p10_a14 in out nocopy JTF_NUMBER_TABLE
830: , p10_a15 in out nocopy JTF_DATE_TABLE
831: , p10_a16 in out nocopy JTF_NUMBER_TABLE
832: , p10_a17 in out nocopy JTF_NUMBER_TABLE
833: , p10_a18 in out nocopy JTF_NUMBER_TABLE
827: , p10_a12 in out nocopy JTF_NUMBER_TABLE
828: , p10_a13 in out nocopy JTF_DATE_TABLE
829: , p10_a14 in out nocopy JTF_NUMBER_TABLE
830: , p10_a15 in out nocopy JTF_DATE_TABLE
831: , p10_a16 in out nocopy JTF_NUMBER_TABLE
832: , p10_a17 in out nocopy JTF_NUMBER_TABLE
833: , p10_a18 in out nocopy JTF_NUMBER_TABLE
834: , p10_a19 in out nocopy JTF_NUMBER_TABLE
835: , p10_a20 in out nocopy JTF_VARCHAR2_TABLE_100
828: , p10_a13 in out nocopy JTF_DATE_TABLE
829: , p10_a14 in out nocopy JTF_NUMBER_TABLE
830: , p10_a15 in out nocopy JTF_DATE_TABLE
831: , p10_a16 in out nocopy JTF_NUMBER_TABLE
832: , p10_a17 in out nocopy JTF_NUMBER_TABLE
833: , p10_a18 in out nocopy JTF_NUMBER_TABLE
834: , p10_a19 in out nocopy JTF_NUMBER_TABLE
835: , p10_a20 in out nocopy JTF_VARCHAR2_TABLE_100
836: , p10_a21 in out nocopy JTF_VARCHAR2_TABLE_200
829: , p10_a14 in out nocopy JTF_NUMBER_TABLE
830: , p10_a15 in out nocopy JTF_DATE_TABLE
831: , p10_a16 in out nocopy JTF_NUMBER_TABLE
832: , p10_a17 in out nocopy JTF_NUMBER_TABLE
833: , p10_a18 in out nocopy JTF_NUMBER_TABLE
834: , p10_a19 in out nocopy JTF_NUMBER_TABLE
835: , p10_a20 in out nocopy JTF_VARCHAR2_TABLE_100
836: , p10_a21 in out nocopy JTF_VARCHAR2_TABLE_200
837: , p10_a22 in out nocopy JTF_VARCHAR2_TABLE_200
830: , p10_a15 in out nocopy JTF_DATE_TABLE
831: , p10_a16 in out nocopy JTF_NUMBER_TABLE
832: , p10_a17 in out nocopy JTF_NUMBER_TABLE
833: , p10_a18 in out nocopy JTF_NUMBER_TABLE
834: , p10_a19 in out nocopy JTF_NUMBER_TABLE
835: , p10_a20 in out nocopy JTF_VARCHAR2_TABLE_100
836: , p10_a21 in out nocopy JTF_VARCHAR2_TABLE_200
837: , p10_a22 in out nocopy JTF_VARCHAR2_TABLE_200
838: , p10_a23 in out nocopy JTF_VARCHAR2_TABLE_200