68: end if;
69: end if;
70: end rosetta_table_copy_out_p3;
71:
72: procedure rosetta_table_copy_in_p8(t OUT NOCOPY ams_ps_rule_pvt.ps_rules_tbl_type, a0 JTF_NUMBER_TABLE
73: , a1 JTF_DATE_TABLE
74: , a2 JTF_NUMBER_TABLE
75: , a3 JTF_DATE_TABLE
76: , a4 JTF_NUMBER_TABLE
70: end rosetta_table_copy_out_p3;
71:
72: procedure rosetta_table_copy_in_p8(t OUT NOCOPY ams_ps_rule_pvt.ps_rules_tbl_type, a0 JTF_NUMBER_TABLE
73: , a1 JTF_DATE_TABLE
74: , a2 JTF_NUMBER_TABLE
75: , a3 JTF_DATE_TABLE
76: , a4 JTF_NUMBER_TABLE
77: , a5 JTF_NUMBER_TABLE
78: , a6 JTF_NUMBER_TABLE
72: procedure rosetta_table_copy_in_p8(t OUT NOCOPY ams_ps_rule_pvt.ps_rules_tbl_type, a0 JTF_NUMBER_TABLE
73: , a1 JTF_DATE_TABLE
74: , a2 JTF_NUMBER_TABLE
75: , a3 JTF_DATE_TABLE
76: , a4 JTF_NUMBER_TABLE
77: , a5 JTF_NUMBER_TABLE
78: , a6 JTF_NUMBER_TABLE
79: , a7 JTF_NUMBER_TABLE
80: , a8 JTF_NUMBER_TABLE
73: , a1 JTF_DATE_TABLE
74: , a2 JTF_NUMBER_TABLE
75: , a3 JTF_DATE_TABLE
76: , a4 JTF_NUMBER_TABLE
77: , a5 JTF_NUMBER_TABLE
78: , a6 JTF_NUMBER_TABLE
79: , a7 JTF_NUMBER_TABLE
80: , a8 JTF_NUMBER_TABLE
81: , a9 JTF_NUMBER_TABLE
74: , a2 JTF_NUMBER_TABLE
75: , a3 JTF_DATE_TABLE
76: , a4 JTF_NUMBER_TABLE
77: , a5 JTF_NUMBER_TABLE
78: , a6 JTF_NUMBER_TABLE
79: , a7 JTF_NUMBER_TABLE
80: , a8 JTF_NUMBER_TABLE
81: , a9 JTF_NUMBER_TABLE
82: , a10 JTF_NUMBER_TABLE
75: , a3 JTF_DATE_TABLE
76: , a4 JTF_NUMBER_TABLE
77: , a5 JTF_NUMBER_TABLE
78: , a6 JTF_NUMBER_TABLE
79: , a7 JTF_NUMBER_TABLE
80: , a8 JTF_NUMBER_TABLE
81: , a9 JTF_NUMBER_TABLE
82: , a10 JTF_NUMBER_TABLE
83: , a11 JTF_VARCHAR2_TABLE_100
76: , a4 JTF_NUMBER_TABLE
77: , a5 JTF_NUMBER_TABLE
78: , a6 JTF_NUMBER_TABLE
79: , a7 JTF_NUMBER_TABLE
80: , a8 JTF_NUMBER_TABLE
81: , a9 JTF_NUMBER_TABLE
82: , a10 JTF_NUMBER_TABLE
83: , a11 JTF_VARCHAR2_TABLE_100
84: , a12 JTF_VARCHAR2_TABLE_100
77: , a5 JTF_NUMBER_TABLE
78: , a6 JTF_NUMBER_TABLE
79: , a7 JTF_NUMBER_TABLE
80: , a8 JTF_NUMBER_TABLE
81: , a9 JTF_NUMBER_TABLE
82: , a10 JTF_NUMBER_TABLE
83: , a11 JTF_VARCHAR2_TABLE_100
84: , a12 JTF_VARCHAR2_TABLE_100
85: , a13 JTF_VARCHAR2_TABLE_100
78: , a6 JTF_NUMBER_TABLE
79: , a7 JTF_NUMBER_TABLE
80: , a8 JTF_NUMBER_TABLE
81: , a9 JTF_NUMBER_TABLE
82: , a10 JTF_NUMBER_TABLE
83: , a11 JTF_VARCHAR2_TABLE_100
84: , a12 JTF_VARCHAR2_TABLE_100
85: , a13 JTF_VARCHAR2_TABLE_100
86: , a14 JTF_NUMBER_TABLE
82: , a10 JTF_NUMBER_TABLE
83: , a11 JTF_VARCHAR2_TABLE_100
84: , a12 JTF_VARCHAR2_TABLE_100
85: , a13 JTF_VARCHAR2_TABLE_100
86: , a14 JTF_NUMBER_TABLE
87: , a15 JTF_VARCHAR2_TABLE_100
88: , a16 JTF_VARCHAR2_TABLE_100
89: , a17 JTF_NUMBER_TABLE
90: , a18 JTF_VARCHAR2_TABLE_100
85: , a13 JTF_VARCHAR2_TABLE_100
86: , a14 JTF_NUMBER_TABLE
87: , a15 JTF_VARCHAR2_TABLE_100
88: , a16 JTF_VARCHAR2_TABLE_100
89: , a17 JTF_NUMBER_TABLE
90: , a18 JTF_VARCHAR2_TABLE_100
91: , a19 JTF_VARCHAR2_TABLE_100
92: , a20 JTF_VARCHAR2_TABLE_100
93: , a21 JTF_VARCHAR2_TABLE_100
141: end loop;
142: end if;
143: end if;
144: end rosetta_table_copy_in_p8;
145: procedure rosetta_table_copy_out_p8(t ams_ps_rule_pvt.ps_rules_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
146: , a1 OUT NOCOPY JTF_DATE_TABLE
147: , a2 OUT NOCOPY JTF_NUMBER_TABLE
148: , a3 OUT NOCOPY JTF_DATE_TABLE
149: , a4 OUT NOCOPY JTF_NUMBER_TABLE
143: end if;
144: end rosetta_table_copy_in_p8;
145: procedure rosetta_table_copy_out_p8(t ams_ps_rule_pvt.ps_rules_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
146: , a1 OUT NOCOPY JTF_DATE_TABLE
147: , a2 OUT NOCOPY JTF_NUMBER_TABLE
148: , a3 OUT NOCOPY JTF_DATE_TABLE
149: , a4 OUT NOCOPY JTF_NUMBER_TABLE
150: , a5 OUT NOCOPY JTF_NUMBER_TABLE
151: , a6 OUT NOCOPY JTF_NUMBER_TABLE
145: procedure rosetta_table_copy_out_p8(t ams_ps_rule_pvt.ps_rules_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
146: , a1 OUT NOCOPY JTF_DATE_TABLE
147: , a2 OUT NOCOPY JTF_NUMBER_TABLE
148: , a3 OUT NOCOPY JTF_DATE_TABLE
149: , a4 OUT NOCOPY JTF_NUMBER_TABLE
150: , a5 OUT NOCOPY JTF_NUMBER_TABLE
151: , a6 OUT NOCOPY JTF_NUMBER_TABLE
152: , a7 OUT NOCOPY JTF_NUMBER_TABLE
153: , a8 OUT NOCOPY JTF_NUMBER_TABLE
146: , a1 OUT NOCOPY JTF_DATE_TABLE
147: , a2 OUT NOCOPY JTF_NUMBER_TABLE
148: , a3 OUT NOCOPY JTF_DATE_TABLE
149: , a4 OUT NOCOPY JTF_NUMBER_TABLE
150: , a5 OUT NOCOPY JTF_NUMBER_TABLE
151: , a6 OUT NOCOPY JTF_NUMBER_TABLE
152: , a7 OUT NOCOPY JTF_NUMBER_TABLE
153: , a8 OUT NOCOPY JTF_NUMBER_TABLE
154: , a9 OUT NOCOPY JTF_NUMBER_TABLE
147: , a2 OUT NOCOPY JTF_NUMBER_TABLE
148: , a3 OUT NOCOPY JTF_DATE_TABLE
149: , a4 OUT NOCOPY JTF_NUMBER_TABLE
150: , a5 OUT NOCOPY JTF_NUMBER_TABLE
151: , a6 OUT NOCOPY JTF_NUMBER_TABLE
152: , a7 OUT NOCOPY JTF_NUMBER_TABLE
153: , a8 OUT NOCOPY JTF_NUMBER_TABLE
154: , a9 OUT NOCOPY JTF_NUMBER_TABLE
155: , a10 OUT NOCOPY JTF_NUMBER_TABLE
148: , a3 OUT NOCOPY JTF_DATE_TABLE
149: , a4 OUT NOCOPY JTF_NUMBER_TABLE
150: , a5 OUT NOCOPY JTF_NUMBER_TABLE
151: , a6 OUT NOCOPY JTF_NUMBER_TABLE
152: , a7 OUT NOCOPY JTF_NUMBER_TABLE
153: , a8 OUT NOCOPY JTF_NUMBER_TABLE
154: , a9 OUT NOCOPY JTF_NUMBER_TABLE
155: , a10 OUT NOCOPY JTF_NUMBER_TABLE
156: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
149: , a4 OUT NOCOPY JTF_NUMBER_TABLE
150: , a5 OUT NOCOPY JTF_NUMBER_TABLE
151: , a6 OUT NOCOPY JTF_NUMBER_TABLE
152: , a7 OUT NOCOPY JTF_NUMBER_TABLE
153: , a8 OUT NOCOPY JTF_NUMBER_TABLE
154: , a9 OUT NOCOPY JTF_NUMBER_TABLE
155: , a10 OUT NOCOPY JTF_NUMBER_TABLE
156: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
157: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
150: , a5 OUT NOCOPY JTF_NUMBER_TABLE
151: , a6 OUT NOCOPY JTF_NUMBER_TABLE
152: , a7 OUT NOCOPY JTF_NUMBER_TABLE
153: , a8 OUT NOCOPY JTF_NUMBER_TABLE
154: , a9 OUT NOCOPY JTF_NUMBER_TABLE
155: , a10 OUT NOCOPY JTF_NUMBER_TABLE
156: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
157: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
158: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
151: , a6 OUT NOCOPY JTF_NUMBER_TABLE
152: , a7 OUT NOCOPY JTF_NUMBER_TABLE
153: , a8 OUT NOCOPY JTF_NUMBER_TABLE
154: , a9 OUT NOCOPY JTF_NUMBER_TABLE
155: , a10 OUT NOCOPY JTF_NUMBER_TABLE
156: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
157: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
158: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
159: , a14 OUT NOCOPY JTF_NUMBER_TABLE
155: , a10 OUT NOCOPY JTF_NUMBER_TABLE
156: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
157: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
158: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
159: , a14 OUT NOCOPY JTF_NUMBER_TABLE
160: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
161: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
162: , a17 OUT NOCOPY JTF_NUMBER_TABLE
163: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
158: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
159: , a14 OUT NOCOPY JTF_NUMBER_TABLE
160: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
161: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
162: , a17 OUT NOCOPY JTF_NUMBER_TABLE
163: , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_100
164: , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
165: , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_100
166: , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_100
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_DATE_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_DATE_TABLE();
181: a4 := JTF_NUMBER_TABLE();
175: begin
176: if t is null or t.count = 0 then
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_DATE_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_DATE_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_NUMBER_TABLE();
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_DATE_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_DATE_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
178: a1 := JTF_DATE_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_DATE_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_NUMBER_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_DATE_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_NUMBER_TABLE();
187: a10 := JTF_NUMBER_TABLE();
180: a3 := JTF_DATE_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_NUMBER_TABLE();
187: a10 := JTF_NUMBER_TABLE();
188: a11 := JTF_VARCHAR2_TABLE_100();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_NUMBER_TABLE();
187: a10 := JTF_NUMBER_TABLE();
188: a11 := JTF_VARCHAR2_TABLE_100();
189: a12 := JTF_VARCHAR2_TABLE_100();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_NUMBER_TABLE();
187: a10 := JTF_NUMBER_TABLE();
188: a11 := JTF_VARCHAR2_TABLE_100();
189: a12 := JTF_VARCHAR2_TABLE_100();
190: a13 := JTF_VARCHAR2_TABLE_100();
183: a6 := JTF_NUMBER_TABLE();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: a9 := JTF_NUMBER_TABLE();
187: a10 := JTF_NUMBER_TABLE();
188: a11 := JTF_VARCHAR2_TABLE_100();
189: a12 := JTF_VARCHAR2_TABLE_100();
190: a13 := JTF_VARCHAR2_TABLE_100();
191: a14 := JTF_NUMBER_TABLE();
187: a10 := JTF_NUMBER_TABLE();
188: a11 := JTF_VARCHAR2_TABLE_100();
189: a12 := JTF_VARCHAR2_TABLE_100();
190: a13 := JTF_VARCHAR2_TABLE_100();
191: a14 := JTF_NUMBER_TABLE();
192: a15 := JTF_VARCHAR2_TABLE_100();
193: a16 := JTF_VARCHAR2_TABLE_100();
194: a17 := JTF_NUMBER_TABLE();
195: a18 := JTF_VARCHAR2_TABLE_100();
190: a13 := JTF_VARCHAR2_TABLE_100();
191: a14 := JTF_NUMBER_TABLE();
192: a15 := JTF_VARCHAR2_TABLE_100();
193: a16 := JTF_VARCHAR2_TABLE_100();
194: a17 := JTF_NUMBER_TABLE();
195: a18 := JTF_VARCHAR2_TABLE_100();
196: a19 := JTF_VARCHAR2_TABLE_100();
197: a20 := JTF_VARCHAR2_TABLE_100();
198: a21 := JTF_VARCHAR2_TABLE_100();
202: a25 := JTF_VARCHAR2_TABLE_100();
203: a26 := JTF_VARCHAR2_TABLE_100();
204: a27 := JTF_VARCHAR2_TABLE_100();
205: else
206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_DATE_TABLE();
208: a2 := JTF_NUMBER_TABLE();
209: a3 := JTF_DATE_TABLE();
210: a4 := JTF_NUMBER_TABLE();
204: a27 := JTF_VARCHAR2_TABLE_100();
205: else
206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_DATE_TABLE();
208: a2 := JTF_NUMBER_TABLE();
209: a3 := JTF_DATE_TABLE();
210: a4 := JTF_NUMBER_TABLE();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_NUMBER_TABLE();
206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_DATE_TABLE();
208: a2 := JTF_NUMBER_TABLE();
209: a3 := JTF_DATE_TABLE();
210: a4 := JTF_NUMBER_TABLE();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_NUMBER_TABLE();
213: a7 := JTF_NUMBER_TABLE();
214: a8 := JTF_NUMBER_TABLE();
207: a1 := JTF_DATE_TABLE();
208: a2 := JTF_NUMBER_TABLE();
209: a3 := JTF_DATE_TABLE();
210: a4 := JTF_NUMBER_TABLE();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_NUMBER_TABLE();
213: a7 := JTF_NUMBER_TABLE();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_NUMBER_TABLE();
208: a2 := JTF_NUMBER_TABLE();
209: a3 := JTF_DATE_TABLE();
210: a4 := JTF_NUMBER_TABLE();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_NUMBER_TABLE();
213: a7 := JTF_NUMBER_TABLE();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_NUMBER_TABLE();
216: a10 := JTF_NUMBER_TABLE();
209: a3 := JTF_DATE_TABLE();
210: a4 := JTF_NUMBER_TABLE();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_NUMBER_TABLE();
213: a7 := JTF_NUMBER_TABLE();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_NUMBER_TABLE();
216: a10 := JTF_NUMBER_TABLE();
217: a11 := JTF_VARCHAR2_TABLE_100();
210: a4 := JTF_NUMBER_TABLE();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_NUMBER_TABLE();
213: a7 := JTF_NUMBER_TABLE();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_NUMBER_TABLE();
216: a10 := JTF_NUMBER_TABLE();
217: a11 := JTF_VARCHAR2_TABLE_100();
218: a12 := JTF_VARCHAR2_TABLE_100();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_NUMBER_TABLE();
213: a7 := JTF_NUMBER_TABLE();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_NUMBER_TABLE();
216: a10 := JTF_NUMBER_TABLE();
217: a11 := JTF_VARCHAR2_TABLE_100();
218: a12 := JTF_VARCHAR2_TABLE_100();
219: a13 := JTF_VARCHAR2_TABLE_100();
212: a6 := JTF_NUMBER_TABLE();
213: a7 := JTF_NUMBER_TABLE();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_NUMBER_TABLE();
216: a10 := JTF_NUMBER_TABLE();
217: a11 := JTF_VARCHAR2_TABLE_100();
218: a12 := JTF_VARCHAR2_TABLE_100();
219: a13 := JTF_VARCHAR2_TABLE_100();
220: a14 := JTF_NUMBER_TABLE();
216: a10 := JTF_NUMBER_TABLE();
217: a11 := JTF_VARCHAR2_TABLE_100();
218: a12 := JTF_VARCHAR2_TABLE_100();
219: a13 := JTF_VARCHAR2_TABLE_100();
220: a14 := JTF_NUMBER_TABLE();
221: a15 := JTF_VARCHAR2_TABLE_100();
222: a16 := JTF_VARCHAR2_TABLE_100();
223: a17 := JTF_NUMBER_TABLE();
224: a18 := JTF_VARCHAR2_TABLE_100();
219: a13 := JTF_VARCHAR2_TABLE_100();
220: a14 := JTF_NUMBER_TABLE();
221: a15 := JTF_VARCHAR2_TABLE_100();
222: a16 := JTF_VARCHAR2_TABLE_100();
223: a17 := JTF_NUMBER_TABLE();
224: a18 := JTF_VARCHAR2_TABLE_100();
225: a19 := JTF_VARCHAR2_TABLE_100();
226: a20 := JTF_VARCHAR2_TABLE_100();
227: a21 := JTF_VARCHAR2_TABLE_100();