14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_DATE_TABLE
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_DATE_TABLE
24: , a8 JTF_DATE_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_DATE_TABLE
24: , a8 JTF_DATE_TABLE
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_DATE_TABLE
24: , a8 JTF_DATE_TABLE
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_200
29: , a13 JTF_VARCHAR2_TABLE_200
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_DATE_TABLE
24: , a8 JTF_DATE_TABLE
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_200
29: , a13 JTF_VARCHAR2_TABLE_200
30: , a14 JTF_VARCHAR2_TABLE_200
23: , a7 JTF_DATE_TABLE
24: , a8 JTF_DATE_TABLE
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_200
29: , a13 JTF_VARCHAR2_TABLE_200
30: , a14 JTF_VARCHAR2_TABLE_200
31: , a15 JTF_VARCHAR2_TABLE_200
44: , a28 JTF_NUMBER_TABLE
45: , a29 JTF_DATE_TABLE
46: , a30 JTF_NUMBER_TABLE
47: , a31 JTF_NUMBER_TABLE
48: , a32 JTF_VARCHAR2_TABLE_100
49: ) as
50: ddindx binary_integer; indx binary_integer;
51: begin
52: if a0 is not null and a0.count > 0 then
97: end if;
98: end rosetta_table_copy_in_p1;
99: procedure rosetta_table_copy_out_p1(t ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
100: , a1 out nocopy JTF_NUMBER_TABLE
101: , a2 out nocopy JTF_VARCHAR2_TABLE_100
102: , a3 out nocopy JTF_VARCHAR2_TABLE_100
103: , a4 out nocopy JTF_VARCHAR2_TABLE_100
104: , a5 out nocopy JTF_NUMBER_TABLE
105: , a6 out nocopy JTF_VARCHAR2_TABLE_100
98: end rosetta_table_copy_in_p1;
99: procedure rosetta_table_copy_out_p1(t ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
100: , a1 out nocopy JTF_NUMBER_TABLE
101: , a2 out nocopy JTF_VARCHAR2_TABLE_100
102: , a3 out nocopy JTF_VARCHAR2_TABLE_100
103: , a4 out nocopy JTF_VARCHAR2_TABLE_100
104: , a5 out nocopy JTF_NUMBER_TABLE
105: , a6 out nocopy JTF_VARCHAR2_TABLE_100
106: , a7 out nocopy JTF_DATE_TABLE
99: procedure rosetta_table_copy_out_p1(t ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
100: , a1 out nocopy JTF_NUMBER_TABLE
101: , a2 out nocopy JTF_VARCHAR2_TABLE_100
102: , a3 out nocopy JTF_VARCHAR2_TABLE_100
103: , a4 out nocopy JTF_VARCHAR2_TABLE_100
104: , a5 out nocopy JTF_NUMBER_TABLE
105: , a6 out nocopy JTF_VARCHAR2_TABLE_100
106: , a7 out nocopy JTF_DATE_TABLE
107: , a8 out nocopy JTF_DATE_TABLE
101: , a2 out nocopy JTF_VARCHAR2_TABLE_100
102: , a3 out nocopy JTF_VARCHAR2_TABLE_100
103: , a4 out nocopy JTF_VARCHAR2_TABLE_100
104: , a5 out nocopy JTF_NUMBER_TABLE
105: , a6 out nocopy JTF_VARCHAR2_TABLE_100
106: , a7 out nocopy JTF_DATE_TABLE
107: , a8 out nocopy JTF_DATE_TABLE
108: , a9 out nocopy JTF_VARCHAR2_TABLE_100
109: , a10 out nocopy JTF_VARCHAR2_TABLE_100
104: , a5 out nocopy JTF_NUMBER_TABLE
105: , a6 out nocopy JTF_VARCHAR2_TABLE_100
106: , a7 out nocopy JTF_DATE_TABLE
107: , a8 out nocopy JTF_DATE_TABLE
108: , a9 out nocopy JTF_VARCHAR2_TABLE_100
109: , a10 out nocopy JTF_VARCHAR2_TABLE_100
110: , a11 out nocopy JTF_VARCHAR2_TABLE_100
111: , a12 out nocopy JTF_VARCHAR2_TABLE_200
112: , a13 out nocopy JTF_VARCHAR2_TABLE_200
105: , a6 out nocopy JTF_VARCHAR2_TABLE_100
106: , a7 out nocopy JTF_DATE_TABLE
107: , a8 out nocopy JTF_DATE_TABLE
108: , a9 out nocopy JTF_VARCHAR2_TABLE_100
109: , a10 out nocopy JTF_VARCHAR2_TABLE_100
110: , a11 out nocopy JTF_VARCHAR2_TABLE_100
111: , a12 out nocopy JTF_VARCHAR2_TABLE_200
112: , a13 out nocopy JTF_VARCHAR2_TABLE_200
113: , a14 out nocopy JTF_VARCHAR2_TABLE_200
106: , a7 out nocopy JTF_DATE_TABLE
107: , a8 out nocopy JTF_DATE_TABLE
108: , a9 out nocopy JTF_VARCHAR2_TABLE_100
109: , a10 out nocopy JTF_VARCHAR2_TABLE_100
110: , a11 out nocopy JTF_VARCHAR2_TABLE_100
111: , a12 out nocopy JTF_VARCHAR2_TABLE_200
112: , a13 out nocopy JTF_VARCHAR2_TABLE_200
113: , a14 out nocopy JTF_VARCHAR2_TABLE_200
114: , a15 out nocopy JTF_VARCHAR2_TABLE_200
127: , a28 out nocopy JTF_NUMBER_TABLE
128: , a29 out nocopy JTF_DATE_TABLE
129: , a30 out nocopy JTF_NUMBER_TABLE
130: , a31 out nocopy JTF_NUMBER_TABLE
131: , a32 out nocopy JTF_VARCHAR2_TABLE_100
132: ) as
133: ddindx binary_integer; indx binary_integer;
134: begin
135: if t is null or t.count = 0 then
134: begin
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_VARCHAR2_TABLE_100();
139: a3 := JTF_VARCHAR2_TABLE_100();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_NUMBER_TABLE();
142: a6 := JTF_VARCHAR2_TABLE_100();
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_VARCHAR2_TABLE_100();
139: a3 := JTF_VARCHAR2_TABLE_100();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_NUMBER_TABLE();
142: a6 := JTF_VARCHAR2_TABLE_100();
143: a7 := JTF_DATE_TABLE();
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_VARCHAR2_TABLE_100();
139: a3 := JTF_VARCHAR2_TABLE_100();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_NUMBER_TABLE();
142: a6 := JTF_VARCHAR2_TABLE_100();
143: a7 := JTF_DATE_TABLE();
144: a8 := JTF_DATE_TABLE();
138: a2 := JTF_VARCHAR2_TABLE_100();
139: a3 := JTF_VARCHAR2_TABLE_100();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_NUMBER_TABLE();
142: a6 := JTF_VARCHAR2_TABLE_100();
143: a7 := JTF_DATE_TABLE();
144: a8 := JTF_DATE_TABLE();
145: a9 := JTF_VARCHAR2_TABLE_100();
146: a10 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_NUMBER_TABLE();
142: a6 := JTF_VARCHAR2_TABLE_100();
143: a7 := JTF_DATE_TABLE();
144: a8 := JTF_DATE_TABLE();
145: a9 := JTF_VARCHAR2_TABLE_100();
146: a10 := JTF_VARCHAR2_TABLE_100();
147: a11 := JTF_VARCHAR2_TABLE_100();
148: a12 := JTF_VARCHAR2_TABLE_200();
149: a13 := JTF_VARCHAR2_TABLE_200();
142: a6 := JTF_VARCHAR2_TABLE_100();
143: a7 := JTF_DATE_TABLE();
144: a8 := JTF_DATE_TABLE();
145: a9 := JTF_VARCHAR2_TABLE_100();
146: a10 := JTF_VARCHAR2_TABLE_100();
147: a11 := JTF_VARCHAR2_TABLE_100();
148: a12 := JTF_VARCHAR2_TABLE_200();
149: a13 := JTF_VARCHAR2_TABLE_200();
150: a14 := JTF_VARCHAR2_TABLE_200();
143: a7 := JTF_DATE_TABLE();
144: a8 := JTF_DATE_TABLE();
145: a9 := JTF_VARCHAR2_TABLE_100();
146: a10 := JTF_VARCHAR2_TABLE_100();
147: a11 := JTF_VARCHAR2_TABLE_100();
148: a12 := JTF_VARCHAR2_TABLE_200();
149: a13 := JTF_VARCHAR2_TABLE_200();
150: a14 := JTF_VARCHAR2_TABLE_200();
151: a15 := JTF_VARCHAR2_TABLE_200();
164: a28 := JTF_NUMBER_TABLE();
165: a29 := JTF_DATE_TABLE();
166: a30 := JTF_NUMBER_TABLE();
167: a31 := JTF_NUMBER_TABLE();
168: a32 := JTF_VARCHAR2_TABLE_100();
169: else
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_VARCHAR2_TABLE_100();
168: a32 := JTF_VARCHAR2_TABLE_100();
169: else
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_VARCHAR2_TABLE_100();
173: a3 := JTF_VARCHAR2_TABLE_100();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_NUMBER_TABLE();
176: a6 := JTF_VARCHAR2_TABLE_100();
169: else
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_VARCHAR2_TABLE_100();
173: a3 := JTF_VARCHAR2_TABLE_100();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_NUMBER_TABLE();
176: a6 := JTF_VARCHAR2_TABLE_100();
177: a7 := JTF_DATE_TABLE();
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_VARCHAR2_TABLE_100();
173: a3 := JTF_VARCHAR2_TABLE_100();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_NUMBER_TABLE();
176: a6 := JTF_VARCHAR2_TABLE_100();
177: a7 := JTF_DATE_TABLE();
178: a8 := JTF_DATE_TABLE();
172: a2 := JTF_VARCHAR2_TABLE_100();
173: a3 := JTF_VARCHAR2_TABLE_100();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_NUMBER_TABLE();
176: a6 := JTF_VARCHAR2_TABLE_100();
177: a7 := JTF_DATE_TABLE();
178: a8 := JTF_DATE_TABLE();
179: a9 := JTF_VARCHAR2_TABLE_100();
180: a10 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_NUMBER_TABLE();
176: a6 := JTF_VARCHAR2_TABLE_100();
177: a7 := JTF_DATE_TABLE();
178: a8 := JTF_DATE_TABLE();
179: a9 := JTF_VARCHAR2_TABLE_100();
180: a10 := JTF_VARCHAR2_TABLE_100();
181: a11 := JTF_VARCHAR2_TABLE_100();
182: a12 := JTF_VARCHAR2_TABLE_200();
183: a13 := JTF_VARCHAR2_TABLE_200();
176: a6 := JTF_VARCHAR2_TABLE_100();
177: a7 := JTF_DATE_TABLE();
178: a8 := JTF_DATE_TABLE();
179: a9 := JTF_VARCHAR2_TABLE_100();
180: a10 := JTF_VARCHAR2_TABLE_100();
181: a11 := JTF_VARCHAR2_TABLE_100();
182: a12 := JTF_VARCHAR2_TABLE_200();
183: a13 := JTF_VARCHAR2_TABLE_200();
184: a14 := JTF_VARCHAR2_TABLE_200();
177: a7 := JTF_DATE_TABLE();
178: a8 := JTF_DATE_TABLE();
179: a9 := JTF_VARCHAR2_TABLE_100();
180: a10 := JTF_VARCHAR2_TABLE_100();
181: a11 := JTF_VARCHAR2_TABLE_100();
182: a12 := JTF_VARCHAR2_TABLE_200();
183: a13 := JTF_VARCHAR2_TABLE_200();
184: a14 := JTF_VARCHAR2_TABLE_200();
185: a15 := JTF_VARCHAR2_TABLE_200();
198: a28 := JTF_NUMBER_TABLE();
199: a29 := JTF_DATE_TABLE();
200: a30 := JTF_NUMBER_TABLE();
201: a31 := JTF_NUMBER_TABLE();
202: a32 := JTF_VARCHAR2_TABLE_100();
203: if t.count > 0 then
204: a0.extend(t.count);
205: a1.extend(t.count);
206: a2.extend(t.count);
290: , x_msg_count out nocopy NUMBER
291: , x_msg_data out nocopy VARCHAR2
292: , p9_a0 in out nocopy JTF_NUMBER_TABLE
293: , p9_a1 in out nocopy JTF_NUMBER_TABLE
294: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
295: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
296: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
297: , p9_a5 in out nocopy JTF_NUMBER_TABLE
298: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
291: , x_msg_data out nocopy VARCHAR2
292: , p9_a0 in out nocopy JTF_NUMBER_TABLE
293: , p9_a1 in out nocopy JTF_NUMBER_TABLE
294: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
295: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
296: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
297: , p9_a5 in out nocopy JTF_NUMBER_TABLE
298: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
299: , p9_a7 in out nocopy JTF_DATE_TABLE
292: , p9_a0 in out nocopy JTF_NUMBER_TABLE
293: , p9_a1 in out nocopy JTF_NUMBER_TABLE
294: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
295: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
296: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
297: , p9_a5 in out nocopy JTF_NUMBER_TABLE
298: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
299: , p9_a7 in out nocopy JTF_DATE_TABLE
300: , p9_a8 in out nocopy JTF_DATE_TABLE
294: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
295: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
296: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
297: , p9_a5 in out nocopy JTF_NUMBER_TABLE
298: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
299: , p9_a7 in out nocopy JTF_DATE_TABLE
300: , p9_a8 in out nocopy JTF_DATE_TABLE
301: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
302: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
297: , p9_a5 in out nocopy JTF_NUMBER_TABLE
298: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
299: , p9_a7 in out nocopy JTF_DATE_TABLE
300: , p9_a8 in out nocopy JTF_DATE_TABLE
301: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
302: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
303: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
304: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_200
305: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_200
298: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
299: , p9_a7 in out nocopy JTF_DATE_TABLE
300: , p9_a8 in out nocopy JTF_DATE_TABLE
301: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
302: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
303: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
304: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_200
305: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_200
306: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_200
299: , p9_a7 in out nocopy JTF_DATE_TABLE
300: , p9_a8 in out nocopy JTF_DATE_TABLE
301: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
302: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
303: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
304: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_200
305: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_200
306: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_200
307: , p9_a15 in out nocopy JTF_VARCHAR2_TABLE_200
320: , p9_a28 in out nocopy JTF_NUMBER_TABLE
321: , p9_a29 in out nocopy JTF_DATE_TABLE
322: , p9_a30 in out nocopy JTF_NUMBER_TABLE
323: , p9_a31 in out nocopy JTF_NUMBER_TABLE
324: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100
325: , p_mr_header_id NUMBER
326: , p_mr_effectivity_id NUMBER
327: )
328: