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_fmp_mr_effectivity_pvt.effectivity_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_NUMBER_TABLE
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_mr_effectivity_pvt.effectivity_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_mr_effectivity_pvt.effectivity_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_300
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_300
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_200
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_300
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_200
26: , a13 JTF_VARCHAR2_TABLE_200
37: , a24 JTF_VARCHAR2_TABLE_200
38: , a25 JTF_VARCHAR2_TABLE_200
39: , a26 JTF_VARCHAR2_TABLE_200
40: , a27 JTF_DATE_TABLE
41: , a28 JTF_NUMBER_TABLE
42: , a29 JTF_DATE_TABLE
43: , a30 JTF_NUMBER_TABLE
44: , a31 JTF_NUMBER_TABLE
45: , a32 JTF_VARCHAR2_TABLE_100
39: , a26 JTF_VARCHAR2_TABLE_200
40: , a27 JTF_DATE_TABLE
41: , a28 JTF_NUMBER_TABLE
42: , a29 JTF_DATE_TABLE
43: , a30 JTF_NUMBER_TABLE
44: , a31 JTF_NUMBER_TABLE
45: , a32 JTF_VARCHAR2_TABLE_100
46: ) as
47: ddindx binary_integer; indx binary_integer;
40: , a27 JTF_DATE_TABLE
41: , a28 JTF_NUMBER_TABLE
42: , a29 JTF_DATE_TABLE
43: , a30 JTF_NUMBER_TABLE
44: , a31 JTF_NUMBER_TABLE
45: , a32 JTF_VARCHAR2_TABLE_100
46: ) as
47: ddindx binary_integer; indx binary_integer;
48: begin
92: end loop;
93: end if;
94: end if;
95: end rosetta_table_copy_in_p1;
96: procedure rosetta_table_copy_out_p1(t ahl_fmp_mr_effectivity_pvt.effectivity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_VARCHAR2_TABLE_100
98: , a2 out nocopy JTF_NUMBER_TABLE
99: , a3 out nocopy JTF_VARCHAR2_TABLE_100
100: , a4 out nocopy JTF_NUMBER_TABLE
94: end if;
95: end rosetta_table_copy_in_p1;
96: procedure rosetta_table_copy_out_p1(t ahl_fmp_mr_effectivity_pvt.effectivity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_VARCHAR2_TABLE_100
98: , a2 out nocopy JTF_NUMBER_TABLE
99: , a3 out nocopy JTF_VARCHAR2_TABLE_100
100: , a4 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_VARCHAR2_TABLE_100
102: , a6 out nocopy JTF_NUMBER_TABLE
96: procedure rosetta_table_copy_out_p1(t ahl_fmp_mr_effectivity_pvt.effectivity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_VARCHAR2_TABLE_100
98: , a2 out nocopy JTF_NUMBER_TABLE
99: , a3 out nocopy JTF_VARCHAR2_TABLE_100
100: , a4 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_VARCHAR2_TABLE_100
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_VARCHAR2_TABLE_100
104: , a8 out nocopy JTF_NUMBER_TABLE
98: , a2 out nocopy JTF_NUMBER_TABLE
99: , a3 out nocopy JTF_VARCHAR2_TABLE_100
100: , a4 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_VARCHAR2_TABLE_100
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_VARCHAR2_TABLE_100
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_NUMBER_TABLE
106: , a10 out nocopy JTF_VARCHAR2_TABLE_300
100: , a4 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_VARCHAR2_TABLE_100
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_VARCHAR2_TABLE_100
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_NUMBER_TABLE
106: , a10 out nocopy JTF_VARCHAR2_TABLE_300
107: , a11 out nocopy JTF_VARCHAR2_TABLE_100
108: , a12 out nocopy JTF_VARCHAR2_TABLE_200
101: , a5 out nocopy JTF_VARCHAR2_TABLE_100
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_VARCHAR2_TABLE_100
104: , a8 out nocopy JTF_NUMBER_TABLE
105: , a9 out nocopy JTF_NUMBER_TABLE
106: , a10 out nocopy JTF_VARCHAR2_TABLE_300
107: , a11 out nocopy JTF_VARCHAR2_TABLE_100
108: , a12 out nocopy JTF_VARCHAR2_TABLE_200
109: , a13 out nocopy JTF_VARCHAR2_TABLE_200
120: , a24 out nocopy JTF_VARCHAR2_TABLE_200
121: , a25 out nocopy JTF_VARCHAR2_TABLE_200
122: , a26 out nocopy JTF_VARCHAR2_TABLE_200
123: , a27 out nocopy JTF_DATE_TABLE
124: , a28 out nocopy JTF_NUMBER_TABLE
125: , a29 out nocopy JTF_DATE_TABLE
126: , a30 out nocopy JTF_NUMBER_TABLE
127: , a31 out nocopy JTF_NUMBER_TABLE
128: , a32 out nocopy JTF_VARCHAR2_TABLE_100
122: , a26 out nocopy JTF_VARCHAR2_TABLE_200
123: , a27 out nocopy JTF_DATE_TABLE
124: , a28 out nocopy JTF_NUMBER_TABLE
125: , a29 out nocopy JTF_DATE_TABLE
126: , a30 out nocopy JTF_NUMBER_TABLE
127: , a31 out nocopy JTF_NUMBER_TABLE
128: , a32 out nocopy JTF_VARCHAR2_TABLE_100
129: ) as
130: ddindx binary_integer; indx binary_integer;
123: , a27 out nocopy JTF_DATE_TABLE
124: , a28 out nocopy JTF_NUMBER_TABLE
125: , a29 out nocopy JTF_DATE_TABLE
126: , a30 out nocopy JTF_NUMBER_TABLE
127: , a31 out nocopy JTF_NUMBER_TABLE
128: , a32 out nocopy JTF_VARCHAR2_TABLE_100
129: ) as
130: ddindx binary_integer; indx binary_integer;
131: begin
129: ) as
130: ddindx binary_integer; indx binary_integer;
131: begin
132: if t is null or t.count = 0 then
133: a0 := JTF_NUMBER_TABLE();
134: a1 := JTF_VARCHAR2_TABLE_100();
135: a2 := JTF_NUMBER_TABLE();
136: a3 := JTF_VARCHAR2_TABLE_100();
137: a4 := JTF_NUMBER_TABLE();
131: begin
132: if t is null or t.count = 0 then
133: a0 := JTF_NUMBER_TABLE();
134: a1 := JTF_VARCHAR2_TABLE_100();
135: a2 := JTF_NUMBER_TABLE();
136: a3 := JTF_VARCHAR2_TABLE_100();
137: a4 := JTF_NUMBER_TABLE();
138: a5 := JTF_VARCHAR2_TABLE_100();
139: a6 := JTF_NUMBER_TABLE();
133: a0 := JTF_NUMBER_TABLE();
134: a1 := JTF_VARCHAR2_TABLE_100();
135: a2 := JTF_NUMBER_TABLE();
136: a3 := JTF_VARCHAR2_TABLE_100();
137: a4 := JTF_NUMBER_TABLE();
138: a5 := JTF_VARCHAR2_TABLE_100();
139: a6 := JTF_NUMBER_TABLE();
140: a7 := JTF_VARCHAR2_TABLE_100();
141: a8 := JTF_NUMBER_TABLE();
135: a2 := JTF_NUMBER_TABLE();
136: a3 := JTF_VARCHAR2_TABLE_100();
137: a4 := JTF_NUMBER_TABLE();
138: a5 := JTF_VARCHAR2_TABLE_100();
139: a6 := JTF_NUMBER_TABLE();
140: a7 := JTF_VARCHAR2_TABLE_100();
141: a8 := JTF_NUMBER_TABLE();
142: a9 := JTF_NUMBER_TABLE();
143: a10 := JTF_VARCHAR2_TABLE_300();
137: a4 := JTF_NUMBER_TABLE();
138: a5 := JTF_VARCHAR2_TABLE_100();
139: a6 := JTF_NUMBER_TABLE();
140: a7 := JTF_VARCHAR2_TABLE_100();
141: a8 := JTF_NUMBER_TABLE();
142: a9 := JTF_NUMBER_TABLE();
143: a10 := JTF_VARCHAR2_TABLE_300();
144: a11 := JTF_VARCHAR2_TABLE_100();
145: a12 := JTF_VARCHAR2_TABLE_200();
138: a5 := JTF_VARCHAR2_TABLE_100();
139: a6 := JTF_NUMBER_TABLE();
140: a7 := JTF_VARCHAR2_TABLE_100();
141: a8 := JTF_NUMBER_TABLE();
142: a9 := JTF_NUMBER_TABLE();
143: a10 := JTF_VARCHAR2_TABLE_300();
144: a11 := JTF_VARCHAR2_TABLE_100();
145: a12 := JTF_VARCHAR2_TABLE_200();
146: a13 := JTF_VARCHAR2_TABLE_200();
157: a24 := JTF_VARCHAR2_TABLE_200();
158: a25 := JTF_VARCHAR2_TABLE_200();
159: a26 := JTF_VARCHAR2_TABLE_200();
160: a27 := JTF_DATE_TABLE();
161: a28 := JTF_NUMBER_TABLE();
162: a29 := JTF_DATE_TABLE();
163: a30 := JTF_NUMBER_TABLE();
164: a31 := JTF_NUMBER_TABLE();
165: a32 := JTF_VARCHAR2_TABLE_100();
159: a26 := JTF_VARCHAR2_TABLE_200();
160: a27 := JTF_DATE_TABLE();
161: a28 := JTF_NUMBER_TABLE();
162: a29 := JTF_DATE_TABLE();
163: a30 := JTF_NUMBER_TABLE();
164: a31 := JTF_NUMBER_TABLE();
165: a32 := JTF_VARCHAR2_TABLE_100();
166: else
167: a0 := JTF_NUMBER_TABLE();
160: a27 := JTF_DATE_TABLE();
161: a28 := JTF_NUMBER_TABLE();
162: a29 := JTF_DATE_TABLE();
163: a30 := JTF_NUMBER_TABLE();
164: a31 := JTF_NUMBER_TABLE();
165: a32 := JTF_VARCHAR2_TABLE_100();
166: else
167: a0 := JTF_NUMBER_TABLE();
168: a1 := JTF_VARCHAR2_TABLE_100();
163: a30 := JTF_NUMBER_TABLE();
164: a31 := JTF_NUMBER_TABLE();
165: a32 := JTF_VARCHAR2_TABLE_100();
166: else
167: a0 := JTF_NUMBER_TABLE();
168: a1 := JTF_VARCHAR2_TABLE_100();
169: a2 := JTF_NUMBER_TABLE();
170: a3 := JTF_VARCHAR2_TABLE_100();
171: a4 := JTF_NUMBER_TABLE();
165: a32 := JTF_VARCHAR2_TABLE_100();
166: else
167: a0 := JTF_NUMBER_TABLE();
168: a1 := JTF_VARCHAR2_TABLE_100();
169: a2 := JTF_NUMBER_TABLE();
170: a3 := JTF_VARCHAR2_TABLE_100();
171: a4 := JTF_NUMBER_TABLE();
172: a5 := JTF_VARCHAR2_TABLE_100();
173: a6 := JTF_NUMBER_TABLE();
167: a0 := JTF_NUMBER_TABLE();
168: a1 := JTF_VARCHAR2_TABLE_100();
169: a2 := JTF_NUMBER_TABLE();
170: a3 := JTF_VARCHAR2_TABLE_100();
171: a4 := JTF_NUMBER_TABLE();
172: a5 := JTF_VARCHAR2_TABLE_100();
173: a6 := JTF_NUMBER_TABLE();
174: a7 := JTF_VARCHAR2_TABLE_100();
175: a8 := JTF_NUMBER_TABLE();
169: a2 := JTF_NUMBER_TABLE();
170: a3 := JTF_VARCHAR2_TABLE_100();
171: a4 := JTF_NUMBER_TABLE();
172: a5 := JTF_VARCHAR2_TABLE_100();
173: a6 := JTF_NUMBER_TABLE();
174: a7 := JTF_VARCHAR2_TABLE_100();
175: a8 := JTF_NUMBER_TABLE();
176: a9 := JTF_NUMBER_TABLE();
177: a10 := JTF_VARCHAR2_TABLE_300();
171: a4 := JTF_NUMBER_TABLE();
172: a5 := JTF_VARCHAR2_TABLE_100();
173: a6 := JTF_NUMBER_TABLE();
174: a7 := JTF_VARCHAR2_TABLE_100();
175: a8 := JTF_NUMBER_TABLE();
176: a9 := JTF_NUMBER_TABLE();
177: a10 := JTF_VARCHAR2_TABLE_300();
178: a11 := JTF_VARCHAR2_TABLE_100();
179: a12 := JTF_VARCHAR2_TABLE_200();
172: a5 := JTF_VARCHAR2_TABLE_100();
173: a6 := JTF_NUMBER_TABLE();
174: a7 := JTF_VARCHAR2_TABLE_100();
175: a8 := JTF_NUMBER_TABLE();
176: a9 := JTF_NUMBER_TABLE();
177: a10 := JTF_VARCHAR2_TABLE_300();
178: a11 := JTF_VARCHAR2_TABLE_100();
179: a12 := JTF_VARCHAR2_TABLE_200();
180: a13 := JTF_VARCHAR2_TABLE_200();
191: a24 := JTF_VARCHAR2_TABLE_200();
192: a25 := JTF_VARCHAR2_TABLE_200();
193: a26 := JTF_VARCHAR2_TABLE_200();
194: a27 := JTF_DATE_TABLE();
195: a28 := JTF_NUMBER_TABLE();
196: a29 := JTF_DATE_TABLE();
197: a30 := JTF_NUMBER_TABLE();
198: a31 := JTF_NUMBER_TABLE();
199: a32 := JTF_VARCHAR2_TABLE_100();
193: a26 := JTF_VARCHAR2_TABLE_200();
194: a27 := JTF_DATE_TABLE();
195: a28 := JTF_NUMBER_TABLE();
196: a29 := JTF_DATE_TABLE();
197: a30 := JTF_NUMBER_TABLE();
198: a31 := JTF_NUMBER_TABLE();
199: a32 := JTF_VARCHAR2_TABLE_100();
200: if t.count > 0 then
201: a0.extend(t.count);
194: a27 := JTF_DATE_TABLE();
195: a28 := JTF_NUMBER_TABLE();
196: a29 := JTF_DATE_TABLE();
197: a30 := JTF_NUMBER_TABLE();
198: a31 := JTF_NUMBER_TABLE();
199: a32 := JTF_VARCHAR2_TABLE_100();
200: if t.count > 0 then
201: a0.extend(t.count);
202: a1.extend(t.count);
285: , p_module_type VARCHAR2
286: , x_return_status out nocopy VARCHAR2
287: , x_msg_count out nocopy NUMBER
288: , x_msg_data out nocopy VARCHAR2
289: , p9_a0 in out nocopy JTF_NUMBER_TABLE
290: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
291: , p9_a2 in out nocopy JTF_NUMBER_TABLE
292: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
293: , p9_a4 in out nocopy JTF_NUMBER_TABLE
287: , x_msg_count out nocopy NUMBER
288: , x_msg_data out nocopy VARCHAR2
289: , p9_a0 in out nocopy JTF_NUMBER_TABLE
290: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
291: , p9_a2 in out nocopy JTF_NUMBER_TABLE
292: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
293: , p9_a4 in out nocopy JTF_NUMBER_TABLE
294: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
295: , p9_a6 in out nocopy JTF_NUMBER_TABLE
289: , p9_a0 in out nocopy JTF_NUMBER_TABLE
290: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
291: , p9_a2 in out nocopy JTF_NUMBER_TABLE
292: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
293: , p9_a4 in out nocopy JTF_NUMBER_TABLE
294: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
295: , p9_a6 in out nocopy JTF_NUMBER_TABLE
296: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_100
297: , p9_a8 in out nocopy JTF_NUMBER_TABLE
291: , p9_a2 in out nocopy JTF_NUMBER_TABLE
292: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
293: , p9_a4 in out nocopy JTF_NUMBER_TABLE
294: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
295: , p9_a6 in out nocopy JTF_NUMBER_TABLE
296: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_100
297: , p9_a8 in out nocopy JTF_NUMBER_TABLE
298: , p9_a9 in out nocopy JTF_NUMBER_TABLE
299: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_300
293: , p9_a4 in out nocopy JTF_NUMBER_TABLE
294: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
295: , p9_a6 in out nocopy JTF_NUMBER_TABLE
296: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_100
297: , p9_a8 in out nocopy JTF_NUMBER_TABLE
298: , p9_a9 in out nocopy JTF_NUMBER_TABLE
299: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_300
300: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
301: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_200
294: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
295: , p9_a6 in out nocopy JTF_NUMBER_TABLE
296: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_100
297: , p9_a8 in out nocopy JTF_NUMBER_TABLE
298: , p9_a9 in out nocopy JTF_NUMBER_TABLE
299: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_300
300: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
301: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_200
302: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_200
313: , p9_a24 in out nocopy JTF_VARCHAR2_TABLE_200
314: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_200
315: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_200
316: , p9_a27 in out nocopy JTF_DATE_TABLE
317: , p9_a28 in out nocopy JTF_NUMBER_TABLE
318: , p9_a29 in out nocopy JTF_DATE_TABLE
319: , p9_a30 in out nocopy JTF_NUMBER_TABLE
320: , p9_a31 in out nocopy JTF_NUMBER_TABLE
321: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100
315: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_200
316: , p9_a27 in out nocopy JTF_DATE_TABLE
317: , p9_a28 in out nocopy JTF_NUMBER_TABLE
318: , p9_a29 in out nocopy JTF_DATE_TABLE
319: , p9_a30 in out nocopy JTF_NUMBER_TABLE
320: , p9_a31 in out nocopy JTF_NUMBER_TABLE
321: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100
322: , p_mr_header_id NUMBER
323: , p_super_user VARCHAR2
316: , p9_a27 in out nocopy JTF_DATE_TABLE
317: , p9_a28 in out nocopy JTF_NUMBER_TABLE
318: , p9_a29 in out nocopy JTF_DATE_TABLE
319: , p9_a30 in out nocopy JTF_NUMBER_TABLE
320: , p9_a31 in out nocopy JTF_NUMBER_TABLE
321: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100
322: , p_mr_header_id NUMBER
323: , p_super_user VARCHAR2
324: )