1: package body eam_process_permit_pub_w as
2: /* $Header: EAMVWPRB.pls 120.0.12010000.2 2010/03/23 00:35:21 mashah noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy eam_process_permit_pub.eam_wp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package body eam_process_permit_pub_w as
2: /* $Header: EAMVWPRB.pls 120.0.12010000.2 2010/03/23 00:35:21 mashah noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy eam_process_permit_pub.eam_wp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_300
1: package body eam_process_permit_pub_w as
2: /* $Header: EAMVWPRB.pls 120.0.12010000.2 2010/03/23 00:35:21 mashah noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy eam_process_permit_pub.eam_wp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_NUMBER_TABLE
2: /* $Header: EAMVWPRB.pls 120.0.12010000.2 2010/03/23 00:35:21 mashah noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy eam_process_permit_pub.eam_wp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_300
3: procedure rosetta_table_copy_in_p2(t out nocopy eam_process_permit_pub.eam_wp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_300
20: , a17 JTF_VARCHAR2_TABLE_300
21: , a18 JTF_VARCHAR2_TABLE_300
45: , a42 JTF_VARCHAR2_TABLE_300
46: , a43 JTF_VARCHAR2_TABLE_300
47: , a44 JTF_VARCHAR2_TABLE_300
48: , a45 JTF_VARCHAR2_TABLE_300
49: , a46 JTF_NUMBER_TABLE
50: , a47 JTF_NUMBER_TABLE
51: , a48 JTF_DATE_TABLE
52: , a49 JTF_NUMBER_TABLE
53: , a50 JTF_NUMBER_TABLE
46: , a43 JTF_VARCHAR2_TABLE_300
47: , a44 JTF_VARCHAR2_TABLE_300
48: , a45 JTF_VARCHAR2_TABLE_300
49: , a46 JTF_NUMBER_TABLE
50: , a47 JTF_NUMBER_TABLE
51: , a48 JTF_DATE_TABLE
52: , a49 JTF_NUMBER_TABLE
53: , a50 JTF_NUMBER_TABLE
54: ) as
48: , a45 JTF_VARCHAR2_TABLE_300
49: , a46 JTF_NUMBER_TABLE
50: , a47 JTF_NUMBER_TABLE
51: , a48 JTF_DATE_TABLE
52: , a49 JTF_NUMBER_TABLE
53: , a50 JTF_NUMBER_TABLE
54: ) as
55: ddindx binary_integer; indx binary_integer;
56: begin
49: , a46 JTF_NUMBER_TABLE
50: , a47 JTF_NUMBER_TABLE
51: , a48 JTF_DATE_TABLE
52: , a49 JTF_NUMBER_TABLE
53: , a50 JTF_NUMBER_TABLE
54: ) as
55: ddindx binary_integer; indx binary_integer;
56: begin
57: if a0 is not null and a0.count > 0 then
118: end loop;
119: end if;
120: end if;
121: end rosetta_table_copy_in_p2;
122: procedure rosetta_table_copy_out_p2(t eam_process_permit_pub.eam_wp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
123: , a1 out nocopy JTF_NUMBER_TABLE
124: , a2 out nocopy JTF_NUMBER_TABLE
125: , a3 out nocopy JTF_NUMBER_TABLE
126: , a4 out nocopy JTF_NUMBER_TABLE
119: end if;
120: end if;
121: end rosetta_table_copy_in_p2;
122: procedure rosetta_table_copy_out_p2(t eam_process_permit_pub.eam_wp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
123: , a1 out nocopy JTF_NUMBER_TABLE
124: , a2 out nocopy JTF_NUMBER_TABLE
125: , a3 out nocopy JTF_NUMBER_TABLE
126: , a4 out nocopy JTF_NUMBER_TABLE
127: , a5 out nocopy JTF_VARCHAR2_TABLE_300
120: end if;
121: end rosetta_table_copy_in_p2;
122: procedure rosetta_table_copy_out_p2(t eam_process_permit_pub.eam_wp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
123: , a1 out nocopy JTF_NUMBER_TABLE
124: , a2 out nocopy JTF_NUMBER_TABLE
125: , a3 out nocopy JTF_NUMBER_TABLE
126: , a4 out nocopy JTF_NUMBER_TABLE
127: , a5 out nocopy JTF_VARCHAR2_TABLE_300
128: , a6 out nocopy JTF_NUMBER_TABLE
121: end rosetta_table_copy_in_p2;
122: procedure rosetta_table_copy_out_p2(t eam_process_permit_pub.eam_wp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
123: , a1 out nocopy JTF_NUMBER_TABLE
124: , a2 out nocopy JTF_NUMBER_TABLE
125: , a3 out nocopy JTF_NUMBER_TABLE
126: , a4 out nocopy JTF_NUMBER_TABLE
127: , a5 out nocopy JTF_VARCHAR2_TABLE_300
128: , a6 out nocopy JTF_NUMBER_TABLE
129: , a7 out nocopy JTF_VARCHAR2_TABLE_300
122: procedure rosetta_table_copy_out_p2(t eam_process_permit_pub.eam_wp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
123: , a1 out nocopy JTF_NUMBER_TABLE
124: , a2 out nocopy JTF_NUMBER_TABLE
125: , a3 out nocopy JTF_NUMBER_TABLE
126: , a4 out nocopy JTF_NUMBER_TABLE
127: , a5 out nocopy JTF_VARCHAR2_TABLE_300
128: , a6 out nocopy JTF_NUMBER_TABLE
129: , a7 out nocopy JTF_VARCHAR2_TABLE_300
130: , a8 out nocopy JTF_NUMBER_TABLE
124: , a2 out nocopy JTF_NUMBER_TABLE
125: , a3 out nocopy JTF_NUMBER_TABLE
126: , a4 out nocopy JTF_NUMBER_TABLE
127: , a5 out nocopy JTF_VARCHAR2_TABLE_300
128: , a6 out nocopy JTF_NUMBER_TABLE
129: , a7 out nocopy JTF_VARCHAR2_TABLE_300
130: , a8 out nocopy JTF_NUMBER_TABLE
131: , a9 out nocopy JTF_NUMBER_TABLE
132: , a10 out nocopy JTF_DATE_TABLE
126: , a4 out nocopy JTF_NUMBER_TABLE
127: , a5 out nocopy JTF_VARCHAR2_TABLE_300
128: , a6 out nocopy JTF_NUMBER_TABLE
129: , a7 out nocopy JTF_VARCHAR2_TABLE_300
130: , a8 out nocopy JTF_NUMBER_TABLE
131: , a9 out nocopy JTF_NUMBER_TABLE
132: , a10 out nocopy JTF_DATE_TABLE
133: , a11 out nocopy JTF_DATE_TABLE
134: , a12 out nocopy JTF_VARCHAR2_TABLE_100
127: , a5 out nocopy JTF_VARCHAR2_TABLE_300
128: , a6 out nocopy JTF_NUMBER_TABLE
129: , a7 out nocopy JTF_VARCHAR2_TABLE_300
130: , a8 out nocopy JTF_NUMBER_TABLE
131: , a9 out nocopy JTF_NUMBER_TABLE
132: , a10 out nocopy JTF_DATE_TABLE
133: , a11 out nocopy JTF_DATE_TABLE
134: , a12 out nocopy JTF_VARCHAR2_TABLE_100
135: , a13 out nocopy JTF_DATE_TABLE
132: , a10 out nocopy JTF_DATE_TABLE
133: , a11 out nocopy JTF_DATE_TABLE
134: , a12 out nocopy JTF_VARCHAR2_TABLE_100
135: , a13 out nocopy JTF_DATE_TABLE
136: , a14 out nocopy JTF_NUMBER_TABLE
137: , a15 out nocopy JTF_VARCHAR2_TABLE_100
138: , a16 out nocopy JTF_VARCHAR2_TABLE_300
139: , a17 out nocopy JTF_VARCHAR2_TABLE_300
140: , a18 out nocopy JTF_VARCHAR2_TABLE_300
164: , a42 out nocopy JTF_VARCHAR2_TABLE_300
165: , a43 out nocopy JTF_VARCHAR2_TABLE_300
166: , a44 out nocopy JTF_VARCHAR2_TABLE_300
167: , a45 out nocopy JTF_VARCHAR2_TABLE_300
168: , a46 out nocopy JTF_NUMBER_TABLE
169: , a47 out nocopy JTF_NUMBER_TABLE
170: , a48 out nocopy JTF_DATE_TABLE
171: , a49 out nocopy JTF_NUMBER_TABLE
172: , a50 out nocopy JTF_NUMBER_TABLE
165: , a43 out nocopy JTF_VARCHAR2_TABLE_300
166: , a44 out nocopy JTF_VARCHAR2_TABLE_300
167: , a45 out nocopy JTF_VARCHAR2_TABLE_300
168: , a46 out nocopy JTF_NUMBER_TABLE
169: , a47 out nocopy JTF_NUMBER_TABLE
170: , a48 out nocopy JTF_DATE_TABLE
171: , a49 out nocopy JTF_NUMBER_TABLE
172: , a50 out nocopy JTF_NUMBER_TABLE
173: ) as
167: , a45 out nocopy JTF_VARCHAR2_TABLE_300
168: , a46 out nocopy JTF_NUMBER_TABLE
169: , a47 out nocopy JTF_NUMBER_TABLE
170: , a48 out nocopy JTF_DATE_TABLE
171: , a49 out nocopy JTF_NUMBER_TABLE
172: , a50 out nocopy JTF_NUMBER_TABLE
173: ) as
174: ddindx binary_integer; indx binary_integer;
175: begin
168: , a46 out nocopy JTF_NUMBER_TABLE
169: , a47 out nocopy JTF_NUMBER_TABLE
170: , a48 out nocopy JTF_DATE_TABLE
171: , a49 out nocopy JTF_NUMBER_TABLE
172: , a50 out nocopy JTF_NUMBER_TABLE
173: ) as
174: ddindx binary_integer; indx binary_integer;
175: begin
176: if t is null or t.count = 0 then
173: ) as
174: ddindx binary_integer; indx binary_integer;
175: begin
176: if t is null or t.count = 0 then
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_NUMBER_TABLE();
181: a4 := JTF_NUMBER_TABLE();
174: ddindx binary_integer; indx binary_integer;
175: begin
176: if t is null or t.count = 0 then
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_NUMBER_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_VARCHAR2_TABLE_300();
175: begin
176: if t is null or t.count = 0 then
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_NUMBER_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_VARCHAR2_TABLE_300();
183: a6 := JTF_NUMBER_TABLE();
176: if t is null or t.count = 0 then
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_NUMBER_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_VARCHAR2_TABLE_300();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_VARCHAR2_TABLE_300();
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_NUMBER_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_VARCHAR2_TABLE_300();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_VARCHAR2_TABLE_300();
185: a8 := JTF_NUMBER_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_NUMBER_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_VARCHAR2_TABLE_300();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_VARCHAR2_TABLE_300();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_NUMBER_TABLE();
187: a10 := JTF_DATE_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_VARCHAR2_TABLE_300();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_VARCHAR2_TABLE_300();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_NUMBER_TABLE();
187: a10 := JTF_DATE_TABLE();
188: a11 := JTF_DATE_TABLE();
189: a12 := JTF_VARCHAR2_TABLE_100();
182: a5 := JTF_VARCHAR2_TABLE_300();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_VARCHAR2_TABLE_300();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_NUMBER_TABLE();
187: a10 := JTF_DATE_TABLE();
188: a11 := JTF_DATE_TABLE();
189: a12 := JTF_VARCHAR2_TABLE_100();
190: a13 := JTF_DATE_TABLE();
187: a10 := JTF_DATE_TABLE();
188: a11 := JTF_DATE_TABLE();
189: a12 := JTF_VARCHAR2_TABLE_100();
190: a13 := JTF_DATE_TABLE();
191: a14 := JTF_NUMBER_TABLE();
192: a15 := JTF_VARCHAR2_TABLE_100();
193: a16 := JTF_VARCHAR2_TABLE_300();
194: a17 := JTF_VARCHAR2_TABLE_300();
195: a18 := JTF_VARCHAR2_TABLE_300();
219: a42 := JTF_VARCHAR2_TABLE_300();
220: a43 := JTF_VARCHAR2_TABLE_300();
221: a44 := JTF_VARCHAR2_TABLE_300();
222: a45 := JTF_VARCHAR2_TABLE_300();
223: a46 := JTF_NUMBER_TABLE();
224: a47 := JTF_NUMBER_TABLE();
225: a48 := JTF_DATE_TABLE();
226: a49 := JTF_NUMBER_TABLE();
227: a50 := JTF_NUMBER_TABLE();
220: a43 := JTF_VARCHAR2_TABLE_300();
221: a44 := JTF_VARCHAR2_TABLE_300();
222: a45 := JTF_VARCHAR2_TABLE_300();
223: a46 := JTF_NUMBER_TABLE();
224: a47 := JTF_NUMBER_TABLE();
225: a48 := JTF_DATE_TABLE();
226: a49 := JTF_NUMBER_TABLE();
227: a50 := JTF_NUMBER_TABLE();
228: else
222: a45 := JTF_VARCHAR2_TABLE_300();
223: a46 := JTF_NUMBER_TABLE();
224: a47 := JTF_NUMBER_TABLE();
225: a48 := JTF_DATE_TABLE();
226: a49 := JTF_NUMBER_TABLE();
227: a50 := JTF_NUMBER_TABLE();
228: else
229: a0 := JTF_NUMBER_TABLE();
230: a1 := JTF_NUMBER_TABLE();
223: a46 := JTF_NUMBER_TABLE();
224: a47 := JTF_NUMBER_TABLE();
225: a48 := JTF_DATE_TABLE();
226: a49 := JTF_NUMBER_TABLE();
227: a50 := JTF_NUMBER_TABLE();
228: else
229: a0 := JTF_NUMBER_TABLE();
230: a1 := JTF_NUMBER_TABLE();
231: a2 := JTF_NUMBER_TABLE();
225: a48 := JTF_DATE_TABLE();
226: a49 := JTF_NUMBER_TABLE();
227: a50 := JTF_NUMBER_TABLE();
228: else
229: a0 := JTF_NUMBER_TABLE();
230: a1 := JTF_NUMBER_TABLE();
231: a2 := JTF_NUMBER_TABLE();
232: a3 := JTF_NUMBER_TABLE();
233: a4 := JTF_NUMBER_TABLE();
226: a49 := JTF_NUMBER_TABLE();
227: a50 := JTF_NUMBER_TABLE();
228: else
229: a0 := JTF_NUMBER_TABLE();
230: a1 := JTF_NUMBER_TABLE();
231: a2 := JTF_NUMBER_TABLE();
232: a3 := JTF_NUMBER_TABLE();
233: a4 := JTF_NUMBER_TABLE();
234: a5 := JTF_VARCHAR2_TABLE_300();
227: a50 := JTF_NUMBER_TABLE();
228: else
229: a0 := JTF_NUMBER_TABLE();
230: a1 := JTF_NUMBER_TABLE();
231: a2 := JTF_NUMBER_TABLE();
232: a3 := JTF_NUMBER_TABLE();
233: a4 := JTF_NUMBER_TABLE();
234: a5 := JTF_VARCHAR2_TABLE_300();
235: a6 := JTF_NUMBER_TABLE();
228: else
229: a0 := JTF_NUMBER_TABLE();
230: a1 := JTF_NUMBER_TABLE();
231: a2 := JTF_NUMBER_TABLE();
232: a3 := JTF_NUMBER_TABLE();
233: a4 := JTF_NUMBER_TABLE();
234: a5 := JTF_VARCHAR2_TABLE_300();
235: a6 := JTF_NUMBER_TABLE();
236: a7 := JTF_VARCHAR2_TABLE_300();
229: a0 := JTF_NUMBER_TABLE();
230: a1 := JTF_NUMBER_TABLE();
231: a2 := JTF_NUMBER_TABLE();
232: a3 := JTF_NUMBER_TABLE();
233: a4 := JTF_NUMBER_TABLE();
234: a5 := JTF_VARCHAR2_TABLE_300();
235: a6 := JTF_NUMBER_TABLE();
236: a7 := JTF_VARCHAR2_TABLE_300();
237: a8 := JTF_NUMBER_TABLE();
231: a2 := JTF_NUMBER_TABLE();
232: a3 := JTF_NUMBER_TABLE();
233: a4 := JTF_NUMBER_TABLE();
234: a5 := JTF_VARCHAR2_TABLE_300();
235: a6 := JTF_NUMBER_TABLE();
236: a7 := JTF_VARCHAR2_TABLE_300();
237: a8 := JTF_NUMBER_TABLE();
238: a9 := JTF_NUMBER_TABLE();
239: a10 := JTF_DATE_TABLE();
233: a4 := JTF_NUMBER_TABLE();
234: a5 := JTF_VARCHAR2_TABLE_300();
235: a6 := JTF_NUMBER_TABLE();
236: a7 := JTF_VARCHAR2_TABLE_300();
237: a8 := JTF_NUMBER_TABLE();
238: a9 := JTF_NUMBER_TABLE();
239: a10 := JTF_DATE_TABLE();
240: a11 := JTF_DATE_TABLE();
241: a12 := JTF_VARCHAR2_TABLE_100();
234: a5 := JTF_VARCHAR2_TABLE_300();
235: a6 := JTF_NUMBER_TABLE();
236: a7 := JTF_VARCHAR2_TABLE_300();
237: a8 := JTF_NUMBER_TABLE();
238: a9 := JTF_NUMBER_TABLE();
239: a10 := JTF_DATE_TABLE();
240: a11 := JTF_DATE_TABLE();
241: a12 := JTF_VARCHAR2_TABLE_100();
242: a13 := JTF_DATE_TABLE();
239: a10 := JTF_DATE_TABLE();
240: a11 := JTF_DATE_TABLE();
241: a12 := JTF_VARCHAR2_TABLE_100();
242: a13 := JTF_DATE_TABLE();
243: a14 := JTF_NUMBER_TABLE();
244: a15 := JTF_VARCHAR2_TABLE_100();
245: a16 := JTF_VARCHAR2_TABLE_300();
246: a17 := JTF_VARCHAR2_TABLE_300();
247: a18 := JTF_VARCHAR2_TABLE_300();
271: a42 := JTF_VARCHAR2_TABLE_300();
272: a43 := JTF_VARCHAR2_TABLE_300();
273: a44 := JTF_VARCHAR2_TABLE_300();
274: a45 := JTF_VARCHAR2_TABLE_300();
275: a46 := JTF_NUMBER_TABLE();
276: a47 := JTF_NUMBER_TABLE();
277: a48 := JTF_DATE_TABLE();
278: a49 := JTF_NUMBER_TABLE();
279: a50 := JTF_NUMBER_TABLE();
272: a43 := JTF_VARCHAR2_TABLE_300();
273: a44 := JTF_VARCHAR2_TABLE_300();
274: a45 := JTF_VARCHAR2_TABLE_300();
275: a46 := JTF_NUMBER_TABLE();
276: a47 := JTF_NUMBER_TABLE();
277: a48 := JTF_DATE_TABLE();
278: a49 := JTF_NUMBER_TABLE();
279: a50 := JTF_NUMBER_TABLE();
280: if t.count > 0 then
274: a45 := JTF_VARCHAR2_TABLE_300();
275: a46 := JTF_NUMBER_TABLE();
276: a47 := JTF_NUMBER_TABLE();
277: a48 := JTF_DATE_TABLE();
278: a49 := JTF_NUMBER_TABLE();
279: a50 := JTF_NUMBER_TABLE();
280: if t.count > 0 then
281: a0.extend(t.count);
282: a1.extend(t.count);
275: a46 := JTF_NUMBER_TABLE();
276: a47 := JTF_NUMBER_TABLE();
277: a48 := JTF_DATE_TABLE();
278: a49 := JTF_NUMBER_TABLE();
279: a50 := JTF_NUMBER_TABLE();
280: if t.count > 0 then
281: a0.extend(t.count);
282: a1.extend(t.count);
283: a2.extend(t.count);
392: end if;
393: end if;
394: end rosetta_table_copy_out_p2;
395:
396: procedure rosetta_table_copy_in_p3(t out nocopy eam_process_permit_pub.eam_wp_association_tbl_type, a0 JTF_NUMBER_TABLE
397: , a1 JTF_NUMBER_TABLE
398: , a2 JTF_NUMBER_TABLE
399: , a3 JTF_NUMBER_TABLE
400: , a4 JTF_NUMBER_TABLE
393: end if;
394: end rosetta_table_copy_out_p2;
395:
396: procedure rosetta_table_copy_in_p3(t out nocopy eam_process_permit_pub.eam_wp_association_tbl_type, a0 JTF_NUMBER_TABLE
397: , a1 JTF_NUMBER_TABLE
398: , a2 JTF_NUMBER_TABLE
399: , a3 JTF_NUMBER_TABLE
400: , a4 JTF_NUMBER_TABLE
401: , a5 JTF_NUMBER_TABLE
394: end rosetta_table_copy_out_p2;
395:
396: procedure rosetta_table_copy_in_p3(t out nocopy eam_process_permit_pub.eam_wp_association_tbl_type, a0 JTF_NUMBER_TABLE
397: , a1 JTF_NUMBER_TABLE
398: , a2 JTF_NUMBER_TABLE
399: , a3 JTF_NUMBER_TABLE
400: , a4 JTF_NUMBER_TABLE
401: , a5 JTF_NUMBER_TABLE
402: , a6 JTF_NUMBER_TABLE
395:
396: procedure rosetta_table_copy_in_p3(t out nocopy eam_process_permit_pub.eam_wp_association_tbl_type, a0 JTF_NUMBER_TABLE
397: , a1 JTF_NUMBER_TABLE
398: , a2 JTF_NUMBER_TABLE
399: , a3 JTF_NUMBER_TABLE
400: , a4 JTF_NUMBER_TABLE
401: , a5 JTF_NUMBER_TABLE
402: , a6 JTF_NUMBER_TABLE
403: , a7 JTF_NUMBER_TABLE
396: procedure rosetta_table_copy_in_p3(t out nocopy eam_process_permit_pub.eam_wp_association_tbl_type, a0 JTF_NUMBER_TABLE
397: , a1 JTF_NUMBER_TABLE
398: , a2 JTF_NUMBER_TABLE
399: , a3 JTF_NUMBER_TABLE
400: , a4 JTF_NUMBER_TABLE
401: , a5 JTF_NUMBER_TABLE
402: , a6 JTF_NUMBER_TABLE
403: , a7 JTF_NUMBER_TABLE
404: , a8 JTF_VARCHAR2_TABLE_100
397: , a1 JTF_NUMBER_TABLE
398: , a2 JTF_NUMBER_TABLE
399: , a3 JTF_NUMBER_TABLE
400: , a4 JTF_NUMBER_TABLE
401: , a5 JTF_NUMBER_TABLE
402: , a6 JTF_NUMBER_TABLE
403: , a7 JTF_NUMBER_TABLE
404: , a8 JTF_VARCHAR2_TABLE_100
405: , a9 JTF_VARCHAR2_TABLE_300
398: , a2 JTF_NUMBER_TABLE
399: , a3 JTF_NUMBER_TABLE
400: , a4 JTF_NUMBER_TABLE
401: , a5 JTF_NUMBER_TABLE
402: , a6 JTF_NUMBER_TABLE
403: , a7 JTF_NUMBER_TABLE
404: , a8 JTF_VARCHAR2_TABLE_100
405: , a9 JTF_VARCHAR2_TABLE_300
406: , a10 JTF_VARCHAR2_TABLE_300
399: , a3 JTF_NUMBER_TABLE
400: , a4 JTF_NUMBER_TABLE
401: , a5 JTF_NUMBER_TABLE
402: , a6 JTF_NUMBER_TABLE
403: , a7 JTF_NUMBER_TABLE
404: , a8 JTF_VARCHAR2_TABLE_100
405: , a9 JTF_VARCHAR2_TABLE_300
406: , a10 JTF_VARCHAR2_TABLE_300
407: , a11 JTF_VARCHAR2_TABLE_300
431: , a35 JTF_VARCHAR2_TABLE_300
432: , a36 JTF_VARCHAR2_TABLE_300
433: , a37 JTF_VARCHAR2_TABLE_300
434: , a38 JTF_VARCHAR2_TABLE_300
435: , a39 JTF_NUMBER_TABLE
436: , a40 JTF_DATE_TABLE
437: ) as
438: ddindx binary_integer; indx binary_integer;
439: begin
491: end loop;
492: end if;
493: end if;
494: end rosetta_table_copy_in_p3;
495: procedure rosetta_table_copy_out_p3(t eam_process_permit_pub.eam_wp_association_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
496: , a1 out nocopy JTF_NUMBER_TABLE
497: , a2 out nocopy JTF_NUMBER_TABLE
498: , a3 out nocopy JTF_NUMBER_TABLE
499: , a4 out nocopy JTF_NUMBER_TABLE
492: end if;
493: end if;
494: end rosetta_table_copy_in_p3;
495: procedure rosetta_table_copy_out_p3(t eam_process_permit_pub.eam_wp_association_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
496: , a1 out nocopy JTF_NUMBER_TABLE
497: , a2 out nocopy JTF_NUMBER_TABLE
498: , a3 out nocopy JTF_NUMBER_TABLE
499: , a4 out nocopy JTF_NUMBER_TABLE
500: , a5 out nocopy JTF_NUMBER_TABLE
493: end if;
494: end rosetta_table_copy_in_p3;
495: procedure rosetta_table_copy_out_p3(t eam_process_permit_pub.eam_wp_association_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
496: , a1 out nocopy JTF_NUMBER_TABLE
497: , a2 out nocopy JTF_NUMBER_TABLE
498: , a3 out nocopy JTF_NUMBER_TABLE
499: , a4 out nocopy JTF_NUMBER_TABLE
500: , a5 out nocopy JTF_NUMBER_TABLE
501: , a6 out nocopy JTF_NUMBER_TABLE
494: end rosetta_table_copy_in_p3;
495: procedure rosetta_table_copy_out_p3(t eam_process_permit_pub.eam_wp_association_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
496: , a1 out nocopy JTF_NUMBER_TABLE
497: , a2 out nocopy JTF_NUMBER_TABLE
498: , a3 out nocopy JTF_NUMBER_TABLE
499: , a4 out nocopy JTF_NUMBER_TABLE
500: , a5 out nocopy JTF_NUMBER_TABLE
501: , a6 out nocopy JTF_NUMBER_TABLE
502: , a7 out nocopy JTF_NUMBER_TABLE
495: procedure rosetta_table_copy_out_p3(t eam_process_permit_pub.eam_wp_association_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
496: , a1 out nocopy JTF_NUMBER_TABLE
497: , a2 out nocopy JTF_NUMBER_TABLE
498: , a3 out nocopy JTF_NUMBER_TABLE
499: , a4 out nocopy JTF_NUMBER_TABLE
500: , a5 out nocopy JTF_NUMBER_TABLE
501: , a6 out nocopy JTF_NUMBER_TABLE
502: , a7 out nocopy JTF_NUMBER_TABLE
503: , a8 out nocopy JTF_VARCHAR2_TABLE_100
496: , a1 out nocopy JTF_NUMBER_TABLE
497: , a2 out nocopy JTF_NUMBER_TABLE
498: , a3 out nocopy JTF_NUMBER_TABLE
499: , a4 out nocopy JTF_NUMBER_TABLE
500: , a5 out nocopy JTF_NUMBER_TABLE
501: , a6 out nocopy JTF_NUMBER_TABLE
502: , a7 out nocopy JTF_NUMBER_TABLE
503: , a8 out nocopy JTF_VARCHAR2_TABLE_100
504: , a9 out nocopy JTF_VARCHAR2_TABLE_300
497: , a2 out nocopy JTF_NUMBER_TABLE
498: , a3 out nocopy JTF_NUMBER_TABLE
499: , a4 out nocopy JTF_NUMBER_TABLE
500: , a5 out nocopy JTF_NUMBER_TABLE
501: , a6 out nocopy JTF_NUMBER_TABLE
502: , a7 out nocopy JTF_NUMBER_TABLE
503: , a8 out nocopy JTF_VARCHAR2_TABLE_100
504: , a9 out nocopy JTF_VARCHAR2_TABLE_300
505: , a10 out nocopy JTF_VARCHAR2_TABLE_300
498: , a3 out nocopy JTF_NUMBER_TABLE
499: , a4 out nocopy JTF_NUMBER_TABLE
500: , a5 out nocopy JTF_NUMBER_TABLE
501: , a6 out nocopy JTF_NUMBER_TABLE
502: , a7 out nocopy JTF_NUMBER_TABLE
503: , a8 out nocopy JTF_VARCHAR2_TABLE_100
504: , a9 out nocopy JTF_VARCHAR2_TABLE_300
505: , a10 out nocopy JTF_VARCHAR2_TABLE_300
506: , a11 out nocopy JTF_VARCHAR2_TABLE_300
530: , a35 out nocopy JTF_VARCHAR2_TABLE_300
531: , a36 out nocopy JTF_VARCHAR2_TABLE_300
532: , a37 out nocopy JTF_VARCHAR2_TABLE_300
533: , a38 out nocopy JTF_VARCHAR2_TABLE_300
534: , a39 out nocopy JTF_NUMBER_TABLE
535: , a40 out nocopy JTF_DATE_TABLE
536: ) as
537: ddindx binary_integer; indx binary_integer;
538: begin
536: ) as
537: ddindx binary_integer; indx binary_integer;
538: begin
539: if t is null or t.count = 0 then
540: a0 := JTF_NUMBER_TABLE();
541: a1 := JTF_NUMBER_TABLE();
542: a2 := JTF_NUMBER_TABLE();
543: a3 := JTF_NUMBER_TABLE();
544: a4 := JTF_NUMBER_TABLE();
537: ddindx binary_integer; indx binary_integer;
538: begin
539: if t is null or t.count = 0 then
540: a0 := JTF_NUMBER_TABLE();
541: a1 := JTF_NUMBER_TABLE();
542: a2 := JTF_NUMBER_TABLE();
543: a3 := JTF_NUMBER_TABLE();
544: a4 := JTF_NUMBER_TABLE();
545: a5 := JTF_NUMBER_TABLE();
538: begin
539: if t is null or t.count = 0 then
540: a0 := JTF_NUMBER_TABLE();
541: a1 := JTF_NUMBER_TABLE();
542: a2 := JTF_NUMBER_TABLE();
543: a3 := JTF_NUMBER_TABLE();
544: a4 := JTF_NUMBER_TABLE();
545: a5 := JTF_NUMBER_TABLE();
546: a6 := JTF_NUMBER_TABLE();
539: if t is null or t.count = 0 then
540: a0 := JTF_NUMBER_TABLE();
541: a1 := JTF_NUMBER_TABLE();
542: a2 := JTF_NUMBER_TABLE();
543: a3 := JTF_NUMBER_TABLE();
544: a4 := JTF_NUMBER_TABLE();
545: a5 := JTF_NUMBER_TABLE();
546: a6 := JTF_NUMBER_TABLE();
547: a7 := JTF_NUMBER_TABLE();
540: a0 := JTF_NUMBER_TABLE();
541: a1 := JTF_NUMBER_TABLE();
542: a2 := JTF_NUMBER_TABLE();
543: a3 := JTF_NUMBER_TABLE();
544: a4 := JTF_NUMBER_TABLE();
545: a5 := JTF_NUMBER_TABLE();
546: a6 := JTF_NUMBER_TABLE();
547: a7 := JTF_NUMBER_TABLE();
548: a8 := JTF_VARCHAR2_TABLE_100();
541: a1 := JTF_NUMBER_TABLE();
542: a2 := JTF_NUMBER_TABLE();
543: a3 := JTF_NUMBER_TABLE();
544: a4 := JTF_NUMBER_TABLE();
545: a5 := JTF_NUMBER_TABLE();
546: a6 := JTF_NUMBER_TABLE();
547: a7 := JTF_NUMBER_TABLE();
548: a8 := JTF_VARCHAR2_TABLE_100();
549: a9 := JTF_VARCHAR2_TABLE_300();
542: a2 := JTF_NUMBER_TABLE();
543: a3 := JTF_NUMBER_TABLE();
544: a4 := JTF_NUMBER_TABLE();
545: a5 := JTF_NUMBER_TABLE();
546: a6 := JTF_NUMBER_TABLE();
547: a7 := JTF_NUMBER_TABLE();
548: a8 := JTF_VARCHAR2_TABLE_100();
549: a9 := JTF_VARCHAR2_TABLE_300();
550: a10 := JTF_VARCHAR2_TABLE_300();
543: a3 := JTF_NUMBER_TABLE();
544: a4 := JTF_NUMBER_TABLE();
545: a5 := JTF_NUMBER_TABLE();
546: a6 := JTF_NUMBER_TABLE();
547: a7 := JTF_NUMBER_TABLE();
548: a8 := JTF_VARCHAR2_TABLE_100();
549: a9 := JTF_VARCHAR2_TABLE_300();
550: a10 := JTF_VARCHAR2_TABLE_300();
551: a11 := JTF_VARCHAR2_TABLE_300();
575: a35 := JTF_VARCHAR2_TABLE_300();
576: a36 := JTF_VARCHAR2_TABLE_300();
577: a37 := JTF_VARCHAR2_TABLE_300();
578: a38 := JTF_VARCHAR2_TABLE_300();
579: a39 := JTF_NUMBER_TABLE();
580: a40 := JTF_DATE_TABLE();
581: else
582: a0 := JTF_NUMBER_TABLE();
583: a1 := JTF_NUMBER_TABLE();
578: a38 := JTF_VARCHAR2_TABLE_300();
579: a39 := JTF_NUMBER_TABLE();
580: a40 := JTF_DATE_TABLE();
581: else
582: a0 := JTF_NUMBER_TABLE();
583: a1 := JTF_NUMBER_TABLE();
584: a2 := JTF_NUMBER_TABLE();
585: a3 := JTF_NUMBER_TABLE();
586: a4 := JTF_NUMBER_TABLE();
579: a39 := JTF_NUMBER_TABLE();
580: a40 := JTF_DATE_TABLE();
581: else
582: a0 := JTF_NUMBER_TABLE();
583: a1 := JTF_NUMBER_TABLE();
584: a2 := JTF_NUMBER_TABLE();
585: a3 := JTF_NUMBER_TABLE();
586: a4 := JTF_NUMBER_TABLE();
587: a5 := JTF_NUMBER_TABLE();
580: a40 := JTF_DATE_TABLE();
581: else
582: a0 := JTF_NUMBER_TABLE();
583: a1 := JTF_NUMBER_TABLE();
584: a2 := JTF_NUMBER_TABLE();
585: a3 := JTF_NUMBER_TABLE();
586: a4 := JTF_NUMBER_TABLE();
587: a5 := JTF_NUMBER_TABLE();
588: a6 := JTF_NUMBER_TABLE();
581: else
582: a0 := JTF_NUMBER_TABLE();
583: a1 := JTF_NUMBER_TABLE();
584: a2 := JTF_NUMBER_TABLE();
585: a3 := JTF_NUMBER_TABLE();
586: a4 := JTF_NUMBER_TABLE();
587: a5 := JTF_NUMBER_TABLE();
588: a6 := JTF_NUMBER_TABLE();
589: a7 := JTF_NUMBER_TABLE();
582: a0 := JTF_NUMBER_TABLE();
583: a1 := JTF_NUMBER_TABLE();
584: a2 := JTF_NUMBER_TABLE();
585: a3 := JTF_NUMBER_TABLE();
586: a4 := JTF_NUMBER_TABLE();
587: a5 := JTF_NUMBER_TABLE();
588: a6 := JTF_NUMBER_TABLE();
589: a7 := JTF_NUMBER_TABLE();
590: a8 := JTF_VARCHAR2_TABLE_100();
583: a1 := JTF_NUMBER_TABLE();
584: a2 := JTF_NUMBER_TABLE();
585: a3 := JTF_NUMBER_TABLE();
586: a4 := JTF_NUMBER_TABLE();
587: a5 := JTF_NUMBER_TABLE();
588: a6 := JTF_NUMBER_TABLE();
589: a7 := JTF_NUMBER_TABLE();
590: a8 := JTF_VARCHAR2_TABLE_100();
591: a9 := JTF_VARCHAR2_TABLE_300();
584: a2 := JTF_NUMBER_TABLE();
585: a3 := JTF_NUMBER_TABLE();
586: a4 := JTF_NUMBER_TABLE();
587: a5 := JTF_NUMBER_TABLE();
588: a6 := JTF_NUMBER_TABLE();
589: a7 := JTF_NUMBER_TABLE();
590: a8 := JTF_VARCHAR2_TABLE_100();
591: a9 := JTF_VARCHAR2_TABLE_300();
592: a10 := JTF_VARCHAR2_TABLE_300();
585: a3 := JTF_NUMBER_TABLE();
586: a4 := JTF_NUMBER_TABLE();
587: a5 := JTF_NUMBER_TABLE();
588: a6 := JTF_NUMBER_TABLE();
589: a7 := JTF_NUMBER_TABLE();
590: a8 := JTF_VARCHAR2_TABLE_100();
591: a9 := JTF_VARCHAR2_TABLE_300();
592: a10 := JTF_VARCHAR2_TABLE_300();
593: a11 := JTF_VARCHAR2_TABLE_300();
617: a35 := JTF_VARCHAR2_TABLE_300();
618: a36 := JTF_VARCHAR2_TABLE_300();
619: a37 := JTF_VARCHAR2_TABLE_300();
620: a38 := JTF_VARCHAR2_TABLE_300();
621: a39 := JTF_NUMBER_TABLE();
622: a40 := JTF_DATE_TABLE();
623: if t.count > 0 then
624: a0.extend(t.count);
625: a1.extend(t.count);