19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_400
21: , a5 JTF_VARCHAR2_TABLE_300
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: ) as
20: , a4 JTF_VARCHAR2_TABLE_400
21: , a5 JTF_VARCHAR2_TABLE_300
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: ) as
28: ddindx binary_integer; indx binary_integer;
21: , a5 JTF_VARCHAR2_TABLE_300
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: ) as
28: ddindx binary_integer; indx binary_integer;
29: begin
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: ) as
28: ddindx binary_integer; indx binary_integer;
29: begin
30: if a0 is not null and a0.count > 0 then
58: , a3 out nocopy JTF_VARCHAR2_TABLE_100
59: , a4 out nocopy JTF_VARCHAR2_TABLE_400
60: , a5 out nocopy JTF_VARCHAR2_TABLE_300
61: , a6 out nocopy JTF_VARCHAR2_TABLE_100
62: , a7 out nocopy JTF_NUMBER_TABLE
63: , a8 out nocopy JTF_NUMBER_TABLE
64: , a9 out nocopy JTF_NUMBER_TABLE
65: , a10 out nocopy JTF_NUMBER_TABLE
66: ) as
59: , a4 out nocopy JTF_VARCHAR2_TABLE_400
60: , a5 out nocopy JTF_VARCHAR2_TABLE_300
61: , a6 out nocopy JTF_VARCHAR2_TABLE_100
62: , a7 out nocopy JTF_NUMBER_TABLE
63: , a8 out nocopy JTF_NUMBER_TABLE
64: , a9 out nocopy JTF_NUMBER_TABLE
65: , a10 out nocopy JTF_NUMBER_TABLE
66: ) as
67: ddindx binary_integer; indx binary_integer;
60: , a5 out nocopy JTF_VARCHAR2_TABLE_300
61: , a6 out nocopy JTF_VARCHAR2_TABLE_100
62: , a7 out nocopy JTF_NUMBER_TABLE
63: , a8 out nocopy JTF_NUMBER_TABLE
64: , a9 out nocopy JTF_NUMBER_TABLE
65: , a10 out nocopy JTF_NUMBER_TABLE
66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin
61: , a6 out nocopy JTF_VARCHAR2_TABLE_100
62: , a7 out nocopy JTF_NUMBER_TABLE
63: , a8 out nocopy JTF_NUMBER_TABLE
64: , a9 out nocopy JTF_NUMBER_TABLE
65: , a10 out nocopy JTF_NUMBER_TABLE
66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then
73: a3 := JTF_VARCHAR2_TABLE_100();
74: a4 := JTF_VARCHAR2_TABLE_400();
75: a5 := JTF_VARCHAR2_TABLE_300();
76: a6 := JTF_VARCHAR2_TABLE_100();
77: a7 := JTF_NUMBER_TABLE();
78: a8 := JTF_NUMBER_TABLE();
79: a9 := JTF_NUMBER_TABLE();
80: a10 := JTF_NUMBER_TABLE();
81: else
74: a4 := JTF_VARCHAR2_TABLE_400();
75: a5 := JTF_VARCHAR2_TABLE_300();
76: a6 := JTF_VARCHAR2_TABLE_100();
77: a7 := JTF_NUMBER_TABLE();
78: a8 := JTF_NUMBER_TABLE();
79: a9 := JTF_NUMBER_TABLE();
80: a10 := JTF_NUMBER_TABLE();
81: else
82: a0 := JTF_VARCHAR2_TABLE_100();
75: a5 := JTF_VARCHAR2_TABLE_300();
76: a6 := JTF_VARCHAR2_TABLE_100();
77: a7 := JTF_NUMBER_TABLE();
78: a8 := JTF_NUMBER_TABLE();
79: a9 := JTF_NUMBER_TABLE();
80: a10 := JTF_NUMBER_TABLE();
81: else
82: a0 := JTF_VARCHAR2_TABLE_100();
83: a1 := JTF_VARCHAR2_TABLE_100();
76: a6 := JTF_VARCHAR2_TABLE_100();
77: a7 := JTF_NUMBER_TABLE();
78: a8 := JTF_NUMBER_TABLE();
79: a9 := JTF_NUMBER_TABLE();
80: a10 := JTF_NUMBER_TABLE();
81: else
82: a0 := JTF_VARCHAR2_TABLE_100();
83: a1 := JTF_VARCHAR2_TABLE_100();
84: a2 := JTF_VARCHAR2_TABLE_4000();
85: a3 := JTF_VARCHAR2_TABLE_100();
86: a4 := JTF_VARCHAR2_TABLE_400();
87: a5 := JTF_VARCHAR2_TABLE_300();
88: a6 := JTF_VARCHAR2_TABLE_100();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_NUMBER_TABLE();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_NUMBER_TABLE();
93: if t.count > 0 then
86: a4 := JTF_VARCHAR2_TABLE_400();
87: a5 := JTF_VARCHAR2_TABLE_300();
88: a6 := JTF_VARCHAR2_TABLE_100();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_NUMBER_TABLE();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_NUMBER_TABLE();
93: if t.count > 0 then
94: a0.extend(t.count);
87: a5 := JTF_VARCHAR2_TABLE_300();
88: a6 := JTF_VARCHAR2_TABLE_100();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_NUMBER_TABLE();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_NUMBER_TABLE();
93: if t.count > 0 then
94: a0.extend(t.count);
95: a1.extend(t.count);
88: a6 := JTF_VARCHAR2_TABLE_100();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_NUMBER_TABLE();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_NUMBER_TABLE();
93: if t.count > 0 then
94: a0.extend(t.count);
95: a1.extend(t.count);
96: a2.extend(t.count);
125: end if;
126: end if;
127: end rosetta_table_copy_out_p1;
128:
129: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE
130: , a1 JTF_NUMBER_TABLE
131: , a2 JTF_NUMBER_TABLE
132: , a3 JTF_VARCHAR2_TABLE_100
133: , a4 JTF_VARCHAR2_TABLE_100
126: end if;
127: end rosetta_table_copy_out_p1;
128:
129: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE
130: , a1 JTF_NUMBER_TABLE
131: , a2 JTF_NUMBER_TABLE
132: , a3 JTF_VARCHAR2_TABLE_100
133: , a4 JTF_VARCHAR2_TABLE_100
134: , a5 JTF_NUMBER_TABLE
127: end rosetta_table_copy_out_p1;
128:
129: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE
130: , a1 JTF_NUMBER_TABLE
131: , a2 JTF_NUMBER_TABLE
132: , a3 JTF_VARCHAR2_TABLE_100
133: , a4 JTF_VARCHAR2_TABLE_100
134: , a5 JTF_NUMBER_TABLE
135: , a6 JTF_VARCHAR2_TABLE_100
130: , a1 JTF_NUMBER_TABLE
131: , a2 JTF_NUMBER_TABLE
132: , a3 JTF_VARCHAR2_TABLE_100
133: , a4 JTF_VARCHAR2_TABLE_100
134: , a5 JTF_NUMBER_TABLE
135: , a6 JTF_VARCHAR2_TABLE_100
136: , a7 JTF_VARCHAR2_TABLE_100
137: , a8 JTF_NUMBER_TABLE
138: ) as
133: , a4 JTF_VARCHAR2_TABLE_100
134: , a5 JTF_NUMBER_TABLE
135: , a6 JTF_VARCHAR2_TABLE_100
136: , a7 JTF_VARCHAR2_TABLE_100
137: , a8 JTF_NUMBER_TABLE
138: ) as
139: ddindx binary_integer; indx binary_integer;
140: begin
141: if a0 is not null and a0.count > 0 then
160: end loop;
161: end if;
162: end if;
163: end rosetta_table_copy_in_p3;
164: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
165: , a1 out nocopy JTF_NUMBER_TABLE
166: , a2 out nocopy JTF_NUMBER_TABLE
167: , a3 out nocopy JTF_VARCHAR2_TABLE_100
168: , a4 out nocopy JTF_VARCHAR2_TABLE_100
161: end if;
162: end if;
163: end rosetta_table_copy_in_p3;
164: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
165: , a1 out nocopy JTF_NUMBER_TABLE
166: , a2 out nocopy JTF_NUMBER_TABLE
167: , a3 out nocopy JTF_VARCHAR2_TABLE_100
168: , a4 out nocopy JTF_VARCHAR2_TABLE_100
169: , a5 out nocopy JTF_NUMBER_TABLE
162: end if;
163: end rosetta_table_copy_in_p3;
164: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
165: , a1 out nocopy JTF_NUMBER_TABLE
166: , a2 out nocopy JTF_NUMBER_TABLE
167: , a3 out nocopy JTF_VARCHAR2_TABLE_100
168: , a4 out nocopy JTF_VARCHAR2_TABLE_100
169: , a5 out nocopy JTF_NUMBER_TABLE
170: , a6 out nocopy JTF_VARCHAR2_TABLE_100
165: , a1 out nocopy JTF_NUMBER_TABLE
166: , a2 out nocopy JTF_NUMBER_TABLE
167: , a3 out nocopy JTF_VARCHAR2_TABLE_100
168: , a4 out nocopy JTF_VARCHAR2_TABLE_100
169: , a5 out nocopy JTF_NUMBER_TABLE
170: , a6 out nocopy JTF_VARCHAR2_TABLE_100
171: , a7 out nocopy JTF_VARCHAR2_TABLE_100
172: , a8 out nocopy JTF_NUMBER_TABLE
173: ) as
168: , a4 out nocopy JTF_VARCHAR2_TABLE_100
169: , a5 out nocopy JTF_NUMBER_TABLE
170: , a6 out nocopy JTF_VARCHAR2_TABLE_100
171: , a7 out nocopy JTF_VARCHAR2_TABLE_100
172: , a8 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_VARCHAR2_TABLE_100();
181: a4 := JTF_VARCHAR2_TABLE_100();
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_VARCHAR2_TABLE_100();
181: a4 := JTF_VARCHAR2_TABLE_100();
182: a5 := JTF_NUMBER_TABLE();
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_VARCHAR2_TABLE_100();
181: a4 := JTF_VARCHAR2_TABLE_100();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_VARCHAR2_TABLE_100();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_NUMBER_TABLE();
180: a3 := JTF_VARCHAR2_TABLE_100();
181: a4 := JTF_VARCHAR2_TABLE_100();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_VARCHAR2_TABLE_100();
184: a7 := JTF_VARCHAR2_TABLE_100();
185: a8 := JTF_NUMBER_TABLE();
186: else
181: a4 := JTF_VARCHAR2_TABLE_100();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_VARCHAR2_TABLE_100();
184: a7 := JTF_VARCHAR2_TABLE_100();
185: a8 := JTF_NUMBER_TABLE();
186: else
187: a0 := JTF_NUMBER_TABLE();
188: a1 := JTF_NUMBER_TABLE();
189: a2 := JTF_NUMBER_TABLE();
183: a6 := JTF_VARCHAR2_TABLE_100();
184: a7 := JTF_VARCHAR2_TABLE_100();
185: a8 := JTF_NUMBER_TABLE();
186: else
187: a0 := JTF_NUMBER_TABLE();
188: a1 := JTF_NUMBER_TABLE();
189: a2 := JTF_NUMBER_TABLE();
190: a3 := JTF_VARCHAR2_TABLE_100();
191: a4 := JTF_VARCHAR2_TABLE_100();
184: a7 := JTF_VARCHAR2_TABLE_100();
185: a8 := JTF_NUMBER_TABLE();
186: else
187: a0 := JTF_NUMBER_TABLE();
188: a1 := JTF_NUMBER_TABLE();
189: a2 := JTF_NUMBER_TABLE();
190: a3 := JTF_VARCHAR2_TABLE_100();
191: a4 := JTF_VARCHAR2_TABLE_100();
192: a5 := JTF_NUMBER_TABLE();
185: a8 := JTF_NUMBER_TABLE();
186: else
187: a0 := JTF_NUMBER_TABLE();
188: a1 := JTF_NUMBER_TABLE();
189: a2 := JTF_NUMBER_TABLE();
190: a3 := JTF_VARCHAR2_TABLE_100();
191: a4 := JTF_VARCHAR2_TABLE_100();
192: a5 := JTF_NUMBER_TABLE();
193: a6 := JTF_VARCHAR2_TABLE_100();
188: a1 := JTF_NUMBER_TABLE();
189: a2 := JTF_NUMBER_TABLE();
190: a3 := JTF_VARCHAR2_TABLE_100();
191: a4 := JTF_VARCHAR2_TABLE_100();
192: a5 := JTF_NUMBER_TABLE();
193: a6 := JTF_VARCHAR2_TABLE_100();
194: a7 := JTF_VARCHAR2_TABLE_100();
195: a8 := JTF_NUMBER_TABLE();
196: if t.count > 0 then
191: a4 := JTF_VARCHAR2_TABLE_100();
192: a5 := JTF_NUMBER_TABLE();
193: a6 := JTF_VARCHAR2_TABLE_100();
194: a7 := JTF_VARCHAR2_TABLE_100();
195: a8 := JTF_NUMBER_TABLE();
196: if t.count > 0 then
197: a0.extend(t.count);
198: a1.extend(t.count);
199: a2.extend(t.count);
224: end if;
225: end if;
226: end rosetta_table_copy_out_p3;
227:
228: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
229: , a1 JTF_NUMBER_TABLE
230: , a2 JTF_NUMBER_TABLE
231: , a3 JTF_NUMBER_TABLE
232: , a4 JTF_NUMBER_TABLE
225: end if;
226: end rosetta_table_copy_out_p3;
227:
228: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
229: , a1 JTF_NUMBER_TABLE
230: , a2 JTF_NUMBER_TABLE
231: , a3 JTF_NUMBER_TABLE
232: , a4 JTF_NUMBER_TABLE
233: , a5 JTF_VARCHAR2_TABLE_100
226: end rosetta_table_copy_out_p3;
227:
228: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
229: , a1 JTF_NUMBER_TABLE
230: , a2 JTF_NUMBER_TABLE
231: , a3 JTF_NUMBER_TABLE
232: , a4 JTF_NUMBER_TABLE
233: , a5 JTF_VARCHAR2_TABLE_100
234: , a6 JTF_VARCHAR2_TABLE_100
227:
228: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
229: , a1 JTF_NUMBER_TABLE
230: , a2 JTF_NUMBER_TABLE
231: , a3 JTF_NUMBER_TABLE
232: , a4 JTF_NUMBER_TABLE
233: , a5 JTF_VARCHAR2_TABLE_100
234: , a6 JTF_VARCHAR2_TABLE_100
235: , a7 JTF_VARCHAR2_TABLE_100
228: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
229: , a1 JTF_NUMBER_TABLE
230: , a2 JTF_NUMBER_TABLE
231: , a3 JTF_NUMBER_TABLE
232: , a4 JTF_NUMBER_TABLE
233: , a5 JTF_VARCHAR2_TABLE_100
234: , a6 JTF_VARCHAR2_TABLE_100
235: , a7 JTF_VARCHAR2_TABLE_100
236: , a8 JTF_VARCHAR2_TABLE_100
261: end loop;
262: end if;
263: end if;
264: end rosetta_table_copy_in_p5;
265: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
266: , a1 out nocopy JTF_NUMBER_TABLE
267: , a2 out nocopy JTF_NUMBER_TABLE
268: , a3 out nocopy JTF_NUMBER_TABLE
269: , a4 out nocopy JTF_NUMBER_TABLE
262: end if;
263: end if;
264: end rosetta_table_copy_in_p5;
265: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
266: , a1 out nocopy JTF_NUMBER_TABLE
267: , a2 out nocopy JTF_NUMBER_TABLE
268: , a3 out nocopy JTF_NUMBER_TABLE
269: , a4 out nocopy JTF_NUMBER_TABLE
270: , a5 out nocopy JTF_VARCHAR2_TABLE_100
263: end if;
264: end rosetta_table_copy_in_p5;
265: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
266: , a1 out nocopy JTF_NUMBER_TABLE
267: , a2 out nocopy JTF_NUMBER_TABLE
268: , a3 out nocopy JTF_NUMBER_TABLE
269: , a4 out nocopy JTF_NUMBER_TABLE
270: , a5 out nocopy JTF_VARCHAR2_TABLE_100
271: , a6 out nocopy JTF_VARCHAR2_TABLE_100
264: end rosetta_table_copy_in_p5;
265: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
266: , a1 out nocopy JTF_NUMBER_TABLE
267: , a2 out nocopy JTF_NUMBER_TABLE
268: , a3 out nocopy JTF_NUMBER_TABLE
269: , a4 out nocopy JTF_NUMBER_TABLE
270: , a5 out nocopy JTF_VARCHAR2_TABLE_100
271: , a6 out nocopy JTF_VARCHAR2_TABLE_100
272: , a7 out nocopy JTF_VARCHAR2_TABLE_100
265: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
266: , a1 out nocopy JTF_NUMBER_TABLE
267: , a2 out nocopy JTF_NUMBER_TABLE
268: , a3 out nocopy JTF_NUMBER_TABLE
269: , a4 out nocopy JTF_NUMBER_TABLE
270: , a5 out nocopy JTF_VARCHAR2_TABLE_100
271: , a6 out nocopy JTF_VARCHAR2_TABLE_100
272: , a7 out nocopy JTF_VARCHAR2_TABLE_100
273: , a8 out nocopy JTF_VARCHAR2_TABLE_100
275: ) as
276: ddindx binary_integer; indx binary_integer;
277: begin
278: if t is null or t.count = 0 then
279: a0 := JTF_NUMBER_TABLE();
280: a1 := JTF_NUMBER_TABLE();
281: a2 := JTF_NUMBER_TABLE();
282: a3 := JTF_NUMBER_TABLE();
283: a4 := JTF_NUMBER_TABLE();
276: ddindx binary_integer; indx binary_integer;
277: begin
278: if t is null or t.count = 0 then
279: a0 := JTF_NUMBER_TABLE();
280: a1 := JTF_NUMBER_TABLE();
281: a2 := JTF_NUMBER_TABLE();
282: a3 := JTF_NUMBER_TABLE();
283: a4 := JTF_NUMBER_TABLE();
284: a5 := JTF_VARCHAR2_TABLE_100();
277: begin
278: if t is null or t.count = 0 then
279: a0 := JTF_NUMBER_TABLE();
280: a1 := JTF_NUMBER_TABLE();
281: a2 := JTF_NUMBER_TABLE();
282: a3 := JTF_NUMBER_TABLE();
283: a4 := JTF_NUMBER_TABLE();
284: a5 := JTF_VARCHAR2_TABLE_100();
285: a6 := JTF_VARCHAR2_TABLE_100();
278: if t is null or t.count = 0 then
279: a0 := JTF_NUMBER_TABLE();
280: a1 := JTF_NUMBER_TABLE();
281: a2 := JTF_NUMBER_TABLE();
282: a3 := JTF_NUMBER_TABLE();
283: a4 := JTF_NUMBER_TABLE();
284: a5 := JTF_VARCHAR2_TABLE_100();
285: a6 := JTF_VARCHAR2_TABLE_100();
286: a7 := JTF_VARCHAR2_TABLE_100();
279: a0 := JTF_NUMBER_TABLE();
280: a1 := JTF_NUMBER_TABLE();
281: a2 := JTF_NUMBER_TABLE();
282: a3 := JTF_NUMBER_TABLE();
283: a4 := JTF_NUMBER_TABLE();
284: a5 := JTF_VARCHAR2_TABLE_100();
285: a6 := JTF_VARCHAR2_TABLE_100();
286: a7 := JTF_VARCHAR2_TABLE_100();
287: a8 := JTF_VARCHAR2_TABLE_100();
286: a7 := JTF_VARCHAR2_TABLE_100();
287: a8 := JTF_VARCHAR2_TABLE_100();
288: a9 := JTF_VARCHAR2_TABLE_100();
289: else
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_NUMBER_TABLE();
293: a3 := JTF_NUMBER_TABLE();
294: a4 := JTF_NUMBER_TABLE();
287: a8 := JTF_VARCHAR2_TABLE_100();
288: a9 := JTF_VARCHAR2_TABLE_100();
289: else
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_NUMBER_TABLE();
293: a3 := JTF_NUMBER_TABLE();
294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_VARCHAR2_TABLE_100();
288: a9 := JTF_VARCHAR2_TABLE_100();
289: else
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_NUMBER_TABLE();
293: a3 := JTF_NUMBER_TABLE();
294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_VARCHAR2_TABLE_100();
296: a6 := JTF_VARCHAR2_TABLE_100();
289: else
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_NUMBER_TABLE();
293: a3 := JTF_NUMBER_TABLE();
294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_VARCHAR2_TABLE_100();
296: a6 := JTF_VARCHAR2_TABLE_100();
297: a7 := JTF_VARCHAR2_TABLE_100();
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_NUMBER_TABLE();
293: a3 := JTF_NUMBER_TABLE();
294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_VARCHAR2_TABLE_100();
296: a6 := JTF_VARCHAR2_TABLE_100();
297: a7 := JTF_VARCHAR2_TABLE_100();
298: a8 := JTF_VARCHAR2_TABLE_100();
330: end if;
331: end if;
332: end rosetta_table_copy_out_p5;
333:
334: procedure rosetta_table_copy_in_p7(t out nocopy ahl_fmp_pvt.applicable_programs_tbl_type, a0 JTF_NUMBER_TABLE
335: , a1 JTF_VARCHAR2_TABLE_200
336: , a2 JTF_VARCHAR2_TABLE_200
337: , a3 JTF_VARCHAR2_TABLE_100
338: , a4 JTF_NUMBER_TABLE
334: procedure rosetta_table_copy_in_p7(t out nocopy ahl_fmp_pvt.applicable_programs_tbl_type, a0 JTF_NUMBER_TABLE
335: , a1 JTF_VARCHAR2_TABLE_200
336: , a2 JTF_VARCHAR2_TABLE_200
337: , a3 JTF_VARCHAR2_TABLE_100
338: , a4 JTF_NUMBER_TABLE
339: , a5 JTF_VARCHAR2_TABLE_300
340: , a6 JTF_VARCHAR2_TABLE_300
341: , a7 JTF_NUMBER_TABLE
342: , a8 JTF_VARCHAR2_TABLE_200
337: , a3 JTF_VARCHAR2_TABLE_100
338: , a4 JTF_NUMBER_TABLE
339: , a5 JTF_VARCHAR2_TABLE_300
340: , a6 JTF_VARCHAR2_TABLE_300
341: , a7 JTF_NUMBER_TABLE
342: , a8 JTF_VARCHAR2_TABLE_200
343: , a9 JTF_VARCHAR2_TABLE_2000
344: , a10 JTF_VARCHAR2_TABLE_100
345: , a11 JTF_VARCHAR2_TABLE_100
342: , a8 JTF_VARCHAR2_TABLE_200
343: , a9 JTF_VARCHAR2_TABLE_2000
344: , a10 JTF_VARCHAR2_TABLE_100
345: , a11 JTF_VARCHAR2_TABLE_100
346: , a12 JTF_NUMBER_TABLE
347: , a13 JTF_DATE_TABLE
348: , a14 JTF_DATE_TABLE
349: , a15 JTF_VARCHAR2_TABLE_100
350: , a16 JTF_VARCHAR2_TABLE_100
354: , a20 JTF_VARCHAR2_TABLE_2000
355: , a21 JTF_DATE_TABLE
356: , a22 JTF_VARCHAR2_TABLE_100
357: , a23 JTF_VARCHAR2_TABLE_500
358: , a24 JTF_NUMBER_TABLE
359: ) as
360: ddindx binary_integer; indx binary_integer;
361: begin
362: if a0 is not null and a0.count > 0 then
397: end loop;
398: end if;
399: end if;
400: end rosetta_table_copy_in_p7;
401: procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
402: , a1 out nocopy JTF_VARCHAR2_TABLE_200
403: , a2 out nocopy JTF_VARCHAR2_TABLE_200
404: , a3 out nocopy JTF_VARCHAR2_TABLE_100
405: , a4 out nocopy JTF_NUMBER_TABLE
401: procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
402: , a1 out nocopy JTF_VARCHAR2_TABLE_200
403: , a2 out nocopy JTF_VARCHAR2_TABLE_200
404: , a3 out nocopy JTF_VARCHAR2_TABLE_100
405: , a4 out nocopy JTF_NUMBER_TABLE
406: , a5 out nocopy JTF_VARCHAR2_TABLE_300
407: , a6 out nocopy JTF_VARCHAR2_TABLE_300
408: , a7 out nocopy JTF_NUMBER_TABLE
409: , a8 out nocopy JTF_VARCHAR2_TABLE_200
404: , a3 out nocopy JTF_VARCHAR2_TABLE_100
405: , a4 out nocopy JTF_NUMBER_TABLE
406: , a5 out nocopy JTF_VARCHAR2_TABLE_300
407: , a6 out nocopy JTF_VARCHAR2_TABLE_300
408: , a7 out nocopy JTF_NUMBER_TABLE
409: , a8 out nocopy JTF_VARCHAR2_TABLE_200
410: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
411: , a10 out nocopy JTF_VARCHAR2_TABLE_100
412: , a11 out nocopy JTF_VARCHAR2_TABLE_100
409: , a8 out nocopy JTF_VARCHAR2_TABLE_200
410: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
411: , a10 out nocopy JTF_VARCHAR2_TABLE_100
412: , a11 out nocopy JTF_VARCHAR2_TABLE_100
413: , a12 out nocopy JTF_NUMBER_TABLE
414: , a13 out nocopy JTF_DATE_TABLE
415: , a14 out nocopy JTF_DATE_TABLE
416: , a15 out nocopy JTF_VARCHAR2_TABLE_100
417: , a16 out nocopy JTF_VARCHAR2_TABLE_100
421: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
422: , a21 out nocopy JTF_DATE_TABLE
423: , a22 out nocopy JTF_VARCHAR2_TABLE_100
424: , a23 out nocopy JTF_VARCHAR2_TABLE_500
425: , a24 out nocopy JTF_NUMBER_TABLE
426: ) as
427: ddindx binary_integer; indx binary_integer;
428: begin
429: if t is null or t.count = 0 then
426: ) as
427: ddindx binary_integer; indx binary_integer;
428: begin
429: if t is null or t.count = 0 then
430: a0 := JTF_NUMBER_TABLE();
431: a1 := JTF_VARCHAR2_TABLE_200();
432: a2 := JTF_VARCHAR2_TABLE_200();
433: a3 := JTF_VARCHAR2_TABLE_100();
434: a4 := JTF_NUMBER_TABLE();
430: a0 := JTF_NUMBER_TABLE();
431: a1 := JTF_VARCHAR2_TABLE_200();
432: a2 := JTF_VARCHAR2_TABLE_200();
433: a3 := JTF_VARCHAR2_TABLE_100();
434: a4 := JTF_NUMBER_TABLE();
435: a5 := JTF_VARCHAR2_TABLE_300();
436: a6 := JTF_VARCHAR2_TABLE_300();
437: a7 := JTF_NUMBER_TABLE();
438: a8 := JTF_VARCHAR2_TABLE_200();
433: a3 := JTF_VARCHAR2_TABLE_100();
434: a4 := JTF_NUMBER_TABLE();
435: a5 := JTF_VARCHAR2_TABLE_300();
436: a6 := JTF_VARCHAR2_TABLE_300();
437: a7 := JTF_NUMBER_TABLE();
438: a8 := JTF_VARCHAR2_TABLE_200();
439: a9 := JTF_VARCHAR2_TABLE_2000();
440: a10 := JTF_VARCHAR2_TABLE_100();
441: a11 := JTF_VARCHAR2_TABLE_100();
438: a8 := JTF_VARCHAR2_TABLE_200();
439: a9 := JTF_VARCHAR2_TABLE_2000();
440: a10 := JTF_VARCHAR2_TABLE_100();
441: a11 := JTF_VARCHAR2_TABLE_100();
442: a12 := JTF_NUMBER_TABLE();
443: a13 := JTF_DATE_TABLE();
444: a14 := JTF_DATE_TABLE();
445: a15 := JTF_VARCHAR2_TABLE_100();
446: a16 := JTF_VARCHAR2_TABLE_100();
450: a20 := JTF_VARCHAR2_TABLE_2000();
451: a21 := JTF_DATE_TABLE();
452: a22 := JTF_VARCHAR2_TABLE_100();
453: a23 := JTF_VARCHAR2_TABLE_500();
454: a24 := JTF_NUMBER_TABLE();
455: else
456: a0 := JTF_NUMBER_TABLE();
457: a1 := JTF_VARCHAR2_TABLE_200();
458: a2 := JTF_VARCHAR2_TABLE_200();
452: a22 := JTF_VARCHAR2_TABLE_100();
453: a23 := JTF_VARCHAR2_TABLE_500();
454: a24 := JTF_NUMBER_TABLE();
455: else
456: a0 := JTF_NUMBER_TABLE();
457: a1 := JTF_VARCHAR2_TABLE_200();
458: a2 := JTF_VARCHAR2_TABLE_200();
459: a3 := JTF_VARCHAR2_TABLE_100();
460: a4 := JTF_NUMBER_TABLE();
456: a0 := JTF_NUMBER_TABLE();
457: a1 := JTF_VARCHAR2_TABLE_200();
458: a2 := JTF_VARCHAR2_TABLE_200();
459: a3 := JTF_VARCHAR2_TABLE_100();
460: a4 := JTF_NUMBER_TABLE();
461: a5 := JTF_VARCHAR2_TABLE_300();
462: a6 := JTF_VARCHAR2_TABLE_300();
463: a7 := JTF_NUMBER_TABLE();
464: a8 := JTF_VARCHAR2_TABLE_200();
459: a3 := JTF_VARCHAR2_TABLE_100();
460: a4 := JTF_NUMBER_TABLE();
461: a5 := JTF_VARCHAR2_TABLE_300();
462: a6 := JTF_VARCHAR2_TABLE_300();
463: a7 := JTF_NUMBER_TABLE();
464: a8 := JTF_VARCHAR2_TABLE_200();
465: a9 := JTF_VARCHAR2_TABLE_2000();
466: a10 := JTF_VARCHAR2_TABLE_100();
467: a11 := JTF_VARCHAR2_TABLE_100();
464: a8 := JTF_VARCHAR2_TABLE_200();
465: a9 := JTF_VARCHAR2_TABLE_2000();
466: a10 := JTF_VARCHAR2_TABLE_100();
467: a11 := JTF_VARCHAR2_TABLE_100();
468: a12 := JTF_NUMBER_TABLE();
469: a13 := JTF_DATE_TABLE();
470: a14 := JTF_DATE_TABLE();
471: a15 := JTF_VARCHAR2_TABLE_100();
472: a16 := JTF_VARCHAR2_TABLE_100();
476: a20 := JTF_VARCHAR2_TABLE_2000();
477: a21 := JTF_DATE_TABLE();
478: a22 := JTF_VARCHAR2_TABLE_100();
479: a23 := JTF_VARCHAR2_TABLE_500();
480: a24 := JTF_NUMBER_TABLE();
481: if t.count > 0 then
482: a0.extend(t.count);
483: a1.extend(t.count);
484: a2.extend(t.count);
560: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
561: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_400
562: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_300
563: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
564: , p12_a7 out nocopy JTF_NUMBER_TABLE
565: , p12_a8 out nocopy JTF_NUMBER_TABLE
566: , p12_a9 out nocopy JTF_NUMBER_TABLE
567: , p12_a10 out nocopy JTF_NUMBER_TABLE
568: )
561: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_400
562: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_300
563: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
564: , p12_a7 out nocopy JTF_NUMBER_TABLE
565: , p12_a8 out nocopy JTF_NUMBER_TABLE
566: , p12_a9 out nocopy JTF_NUMBER_TABLE
567: , p12_a10 out nocopy JTF_NUMBER_TABLE
568: )
569:
562: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_300
563: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
564: , p12_a7 out nocopy JTF_NUMBER_TABLE
565: , p12_a8 out nocopy JTF_NUMBER_TABLE
566: , p12_a9 out nocopy JTF_NUMBER_TABLE
567: , p12_a10 out nocopy JTF_NUMBER_TABLE
568: )
569:
570: as
563: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
564: , p12_a7 out nocopy JTF_NUMBER_TABLE
565: , p12_a8 out nocopy JTF_NUMBER_TABLE
566: , p12_a9 out nocopy JTF_NUMBER_TABLE
567: , p12_a10 out nocopy JTF_NUMBER_TABLE
568: )
569:
570: as
571: ddx_mr_item_inst_tbl ahl_fmp_pvt.mr_item_instance_tbl_type;
639: , p_mr_header_id NUMBER
640: , p_components_flag VARCHAR2
641: , p_include_donotimplmt VARCHAR2
642: , p_visit_type_code VARCHAR2
643: , p12_a0 out nocopy JTF_NUMBER_TABLE
644: , p12_a1 out nocopy JTF_NUMBER_TABLE
645: , p12_a2 out nocopy JTF_NUMBER_TABLE
646: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
647: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
640: , p_components_flag VARCHAR2
641: , p_include_donotimplmt VARCHAR2
642: , p_visit_type_code VARCHAR2
643: , p12_a0 out nocopy JTF_NUMBER_TABLE
644: , p12_a1 out nocopy JTF_NUMBER_TABLE
645: , p12_a2 out nocopy JTF_NUMBER_TABLE
646: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
647: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
648: , p12_a5 out nocopy JTF_NUMBER_TABLE
641: , p_include_donotimplmt VARCHAR2
642: , p_visit_type_code VARCHAR2
643: , p12_a0 out nocopy JTF_NUMBER_TABLE
644: , p12_a1 out nocopy JTF_NUMBER_TABLE
645: , p12_a2 out nocopy JTF_NUMBER_TABLE
646: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
647: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
648: , p12_a5 out nocopy JTF_NUMBER_TABLE
649: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
644: , p12_a1 out nocopy JTF_NUMBER_TABLE
645: , p12_a2 out nocopy JTF_NUMBER_TABLE
646: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
647: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
648: , p12_a5 out nocopy JTF_NUMBER_TABLE
649: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
650: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
651: , p12_a8 out nocopy JTF_NUMBER_TABLE
652: )
647: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
648: , p12_a5 out nocopy JTF_NUMBER_TABLE
649: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
650: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
651: , p12_a8 out nocopy JTF_NUMBER_TABLE
652: )
653:
654: as
655: ddx_applicable_mr_tbl ahl_fmp_pvt.applicable_mr_tbl_type;
717: , x_return_status out nocopy VARCHAR2
718: , x_msg_count out nocopy NUMBER
719: , x_msg_data out nocopy VARCHAR2
720: , p_item_instance_id NUMBER
721: , p8_a0 out nocopy JTF_NUMBER_TABLE
722: , p8_a1 out nocopy JTF_NUMBER_TABLE
723: , p8_a2 out nocopy JTF_NUMBER_TABLE
724: , p8_a3 out nocopy JTF_NUMBER_TABLE
725: , p8_a4 out nocopy JTF_NUMBER_TABLE
718: , x_msg_count out nocopy NUMBER
719: , x_msg_data out nocopy VARCHAR2
720: , p_item_instance_id NUMBER
721: , p8_a0 out nocopy JTF_NUMBER_TABLE
722: , p8_a1 out nocopy JTF_NUMBER_TABLE
723: , p8_a2 out nocopy JTF_NUMBER_TABLE
724: , p8_a3 out nocopy JTF_NUMBER_TABLE
725: , p8_a4 out nocopy JTF_NUMBER_TABLE
726: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
719: , x_msg_data out nocopy VARCHAR2
720: , p_item_instance_id NUMBER
721: , p8_a0 out nocopy JTF_NUMBER_TABLE
722: , p8_a1 out nocopy JTF_NUMBER_TABLE
723: , p8_a2 out nocopy JTF_NUMBER_TABLE
724: , p8_a3 out nocopy JTF_NUMBER_TABLE
725: , p8_a4 out nocopy JTF_NUMBER_TABLE
726: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
727: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
720: , p_item_instance_id NUMBER
721: , p8_a0 out nocopy JTF_NUMBER_TABLE
722: , p8_a1 out nocopy JTF_NUMBER_TABLE
723: , p8_a2 out nocopy JTF_NUMBER_TABLE
724: , p8_a3 out nocopy JTF_NUMBER_TABLE
725: , p8_a4 out nocopy JTF_NUMBER_TABLE
726: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
727: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
728: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
721: , p8_a0 out nocopy JTF_NUMBER_TABLE
722: , p8_a1 out nocopy JTF_NUMBER_TABLE
723: , p8_a2 out nocopy JTF_NUMBER_TABLE
724: , p8_a3 out nocopy JTF_NUMBER_TABLE
725: , p8_a4 out nocopy JTF_NUMBER_TABLE
726: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
727: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
728: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
729: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
727: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
728: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
729: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
730: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
731: , p9_a0 out nocopy JTF_NUMBER_TABLE
732: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
733: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
734: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
735: , p9_a4 out nocopy JTF_NUMBER_TABLE
731: , p9_a0 out nocopy JTF_NUMBER_TABLE
732: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
733: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
734: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
735: , p9_a4 out nocopy JTF_NUMBER_TABLE
736: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
737: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_300
738: , p9_a7 out nocopy JTF_NUMBER_TABLE
739: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
734: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
735: , p9_a4 out nocopy JTF_NUMBER_TABLE
736: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
737: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_300
738: , p9_a7 out nocopy JTF_NUMBER_TABLE
739: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
740: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000
741: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
742: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
739: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
740: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000
741: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
742: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
743: , p9_a12 out nocopy JTF_NUMBER_TABLE
744: , p9_a13 out nocopy JTF_DATE_TABLE
745: , p9_a14 out nocopy JTF_DATE_TABLE
746: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
747: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
751: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_2000
752: , p9_a21 out nocopy JTF_DATE_TABLE
753: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_100
754: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
755: , p9_a24 out nocopy JTF_NUMBER_TABLE
756: )
757:
758: as
759: ddx_applicable_activities_tbl ahl_fmp_pvt.applicable_activities_tbl_type;