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_action_pvt.mr_action_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_mr_action_pvt.mr_action_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_NUMBER_TABLE
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_mr_action_pvt.mr_action_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_VARCHAR2_TABLE_100
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_2000
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_200
34: , a21 JTF_VARCHAR2_TABLE_200
35: , a22 JTF_VARCHAR2_TABLE_200
36: , a23 JTF_VARCHAR2_TABLE_200
37: , a24 JTF_DATE_TABLE
38: , a25 JTF_NUMBER_TABLE
39: , a26 JTF_DATE_TABLE
40: , a27 JTF_NUMBER_TABLE
41: , a28 JTF_NUMBER_TABLE
42: , a29 JTF_VARCHAR2_TABLE_100
36: , a23 JTF_VARCHAR2_TABLE_200
37: , a24 JTF_DATE_TABLE
38: , a25 JTF_NUMBER_TABLE
39: , a26 JTF_DATE_TABLE
40: , a27 JTF_NUMBER_TABLE
41: , a28 JTF_NUMBER_TABLE
42: , a29 JTF_VARCHAR2_TABLE_100
43: ) as
44: ddindx binary_integer; indx binary_integer;
37: , a24 JTF_DATE_TABLE
38: , a25 JTF_NUMBER_TABLE
39: , a26 JTF_DATE_TABLE
40: , a27 JTF_NUMBER_TABLE
41: , a28 JTF_NUMBER_TABLE
42: , a29 JTF_VARCHAR2_TABLE_100
43: ) as
44: ddindx binary_integer; indx binary_integer;
45: begin
86: end loop;
87: end if;
88: end if;
89: end rosetta_table_copy_in_p1;
90: procedure rosetta_table_copy_out_p1(t ahl_fmp_mr_action_pvt.mr_action_tbl, a0 out nocopy JTF_NUMBER_TABLE
91: , a1 out nocopy JTF_NUMBER_TABLE
92: , a2 out nocopy JTF_NUMBER_TABLE
93: , a3 out nocopy JTF_VARCHAR2_TABLE_100
94: , a4 out nocopy JTF_VARCHAR2_TABLE_100
87: end if;
88: end if;
89: end rosetta_table_copy_in_p1;
90: procedure rosetta_table_copy_out_p1(t ahl_fmp_mr_action_pvt.mr_action_tbl, a0 out nocopy JTF_NUMBER_TABLE
91: , a1 out nocopy JTF_NUMBER_TABLE
92: , a2 out nocopy JTF_NUMBER_TABLE
93: , a3 out nocopy JTF_VARCHAR2_TABLE_100
94: , a4 out nocopy JTF_VARCHAR2_TABLE_100
95: , a5 out nocopy JTF_NUMBER_TABLE
88: end if;
89: end rosetta_table_copy_in_p1;
90: procedure rosetta_table_copy_out_p1(t ahl_fmp_mr_action_pvt.mr_action_tbl, a0 out nocopy JTF_NUMBER_TABLE
91: , a1 out nocopy JTF_NUMBER_TABLE
92: , a2 out nocopy JTF_NUMBER_TABLE
93: , a3 out nocopy JTF_VARCHAR2_TABLE_100
94: , a4 out nocopy JTF_VARCHAR2_TABLE_100
95: , a5 out nocopy JTF_NUMBER_TABLE
96: , a6 out nocopy JTF_VARCHAR2_TABLE_100
91: , a1 out nocopy JTF_NUMBER_TABLE
92: , a2 out nocopy JTF_NUMBER_TABLE
93: , a3 out nocopy JTF_VARCHAR2_TABLE_100
94: , a4 out nocopy JTF_VARCHAR2_TABLE_100
95: , a5 out nocopy JTF_NUMBER_TABLE
96: , a6 out nocopy JTF_VARCHAR2_TABLE_100
97: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
98: , a8 out nocopy JTF_VARCHAR2_TABLE_100
99: , a9 out nocopy JTF_VARCHAR2_TABLE_200
111: , a21 out nocopy JTF_VARCHAR2_TABLE_200
112: , a22 out nocopy JTF_VARCHAR2_TABLE_200
113: , a23 out nocopy JTF_VARCHAR2_TABLE_200
114: , a24 out nocopy JTF_DATE_TABLE
115: , a25 out nocopy JTF_NUMBER_TABLE
116: , a26 out nocopy JTF_DATE_TABLE
117: , a27 out nocopy JTF_NUMBER_TABLE
118: , a28 out nocopy JTF_NUMBER_TABLE
119: , a29 out nocopy JTF_VARCHAR2_TABLE_100
113: , a23 out nocopy JTF_VARCHAR2_TABLE_200
114: , a24 out nocopy JTF_DATE_TABLE
115: , a25 out nocopy JTF_NUMBER_TABLE
116: , a26 out nocopy JTF_DATE_TABLE
117: , a27 out nocopy JTF_NUMBER_TABLE
118: , a28 out nocopy JTF_NUMBER_TABLE
119: , a29 out nocopy JTF_VARCHAR2_TABLE_100
120: ) as
121: ddindx binary_integer; indx binary_integer;
114: , a24 out nocopy JTF_DATE_TABLE
115: , a25 out nocopy JTF_NUMBER_TABLE
116: , a26 out nocopy JTF_DATE_TABLE
117: , a27 out nocopy JTF_NUMBER_TABLE
118: , a28 out nocopy JTF_NUMBER_TABLE
119: , a29 out nocopy JTF_VARCHAR2_TABLE_100
120: ) as
121: ddindx binary_integer; indx binary_integer;
122: begin
120: ) as
121: ddindx binary_integer; indx binary_integer;
122: begin
123: if t is null or t.count = 0 then
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_VARCHAR2_TABLE_100();
128: a4 := JTF_VARCHAR2_TABLE_100();
121: ddindx binary_integer; indx binary_integer;
122: begin
123: if t is null or t.count = 0 then
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_VARCHAR2_TABLE_100();
128: a4 := JTF_VARCHAR2_TABLE_100();
129: a5 := JTF_NUMBER_TABLE();
122: begin
123: if t is null or t.count = 0 then
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_VARCHAR2_TABLE_100();
128: a4 := JTF_VARCHAR2_TABLE_100();
129: a5 := JTF_NUMBER_TABLE();
130: a6 := JTF_VARCHAR2_TABLE_100();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_VARCHAR2_TABLE_100();
128: a4 := JTF_VARCHAR2_TABLE_100();
129: a5 := JTF_NUMBER_TABLE();
130: a6 := JTF_VARCHAR2_TABLE_100();
131: a7 := JTF_VARCHAR2_TABLE_2000();
132: a8 := JTF_VARCHAR2_TABLE_100();
133: a9 := JTF_VARCHAR2_TABLE_200();
145: a21 := JTF_VARCHAR2_TABLE_200();
146: a22 := JTF_VARCHAR2_TABLE_200();
147: a23 := JTF_VARCHAR2_TABLE_200();
148: a24 := JTF_DATE_TABLE();
149: a25 := JTF_NUMBER_TABLE();
150: a26 := JTF_DATE_TABLE();
151: a27 := JTF_NUMBER_TABLE();
152: a28 := JTF_NUMBER_TABLE();
153: a29 := JTF_VARCHAR2_TABLE_100();
147: a23 := JTF_VARCHAR2_TABLE_200();
148: a24 := JTF_DATE_TABLE();
149: a25 := JTF_NUMBER_TABLE();
150: a26 := JTF_DATE_TABLE();
151: a27 := JTF_NUMBER_TABLE();
152: a28 := JTF_NUMBER_TABLE();
153: a29 := JTF_VARCHAR2_TABLE_100();
154: else
155: a0 := JTF_NUMBER_TABLE();
148: a24 := JTF_DATE_TABLE();
149: a25 := JTF_NUMBER_TABLE();
150: a26 := JTF_DATE_TABLE();
151: a27 := JTF_NUMBER_TABLE();
152: a28 := JTF_NUMBER_TABLE();
153: a29 := JTF_VARCHAR2_TABLE_100();
154: else
155: a0 := JTF_NUMBER_TABLE();
156: a1 := JTF_NUMBER_TABLE();
151: a27 := JTF_NUMBER_TABLE();
152: a28 := JTF_NUMBER_TABLE();
153: a29 := JTF_VARCHAR2_TABLE_100();
154: else
155: a0 := JTF_NUMBER_TABLE();
156: a1 := JTF_NUMBER_TABLE();
157: a2 := JTF_NUMBER_TABLE();
158: a3 := JTF_VARCHAR2_TABLE_100();
159: a4 := JTF_VARCHAR2_TABLE_100();
152: a28 := JTF_NUMBER_TABLE();
153: a29 := JTF_VARCHAR2_TABLE_100();
154: else
155: a0 := JTF_NUMBER_TABLE();
156: a1 := JTF_NUMBER_TABLE();
157: a2 := JTF_NUMBER_TABLE();
158: a3 := JTF_VARCHAR2_TABLE_100();
159: a4 := JTF_VARCHAR2_TABLE_100();
160: a5 := JTF_NUMBER_TABLE();
153: a29 := JTF_VARCHAR2_TABLE_100();
154: else
155: a0 := JTF_NUMBER_TABLE();
156: a1 := JTF_NUMBER_TABLE();
157: a2 := JTF_NUMBER_TABLE();
158: a3 := JTF_VARCHAR2_TABLE_100();
159: a4 := JTF_VARCHAR2_TABLE_100();
160: a5 := JTF_NUMBER_TABLE();
161: a6 := JTF_VARCHAR2_TABLE_100();
156: a1 := JTF_NUMBER_TABLE();
157: a2 := JTF_NUMBER_TABLE();
158: a3 := JTF_VARCHAR2_TABLE_100();
159: a4 := JTF_VARCHAR2_TABLE_100();
160: a5 := JTF_NUMBER_TABLE();
161: a6 := JTF_VARCHAR2_TABLE_100();
162: a7 := JTF_VARCHAR2_TABLE_2000();
163: a8 := JTF_VARCHAR2_TABLE_100();
164: a9 := JTF_VARCHAR2_TABLE_200();
176: a21 := JTF_VARCHAR2_TABLE_200();
177: a22 := JTF_VARCHAR2_TABLE_200();
178: a23 := JTF_VARCHAR2_TABLE_200();
179: a24 := JTF_DATE_TABLE();
180: a25 := JTF_NUMBER_TABLE();
181: a26 := JTF_DATE_TABLE();
182: a27 := JTF_NUMBER_TABLE();
183: a28 := JTF_NUMBER_TABLE();
184: a29 := JTF_VARCHAR2_TABLE_100();
178: a23 := JTF_VARCHAR2_TABLE_200();
179: a24 := JTF_DATE_TABLE();
180: a25 := JTF_NUMBER_TABLE();
181: a26 := JTF_DATE_TABLE();
182: a27 := JTF_NUMBER_TABLE();
183: a28 := JTF_NUMBER_TABLE();
184: a29 := JTF_VARCHAR2_TABLE_100();
185: if t.count > 0 then
186: a0.extend(t.count);
179: a24 := JTF_DATE_TABLE();
180: a25 := JTF_NUMBER_TABLE();
181: a26 := JTF_DATE_TABLE();
182: a27 := JTF_NUMBER_TABLE();
183: a28 := JTF_NUMBER_TABLE();
184: a29 := JTF_VARCHAR2_TABLE_100();
185: if t.count > 0 then
186: a0.extend(t.count);
187: a1.extend(t.count);
264: , p_module_type VARCHAR2
265: , x_return_status out nocopy VARCHAR2
266: , x_msg_count out nocopy NUMBER
267: , x_msg_data out nocopy VARCHAR2
268: , p9_a0 in out nocopy JTF_NUMBER_TABLE
269: , p9_a1 in out nocopy JTF_NUMBER_TABLE
270: , p9_a2 in out nocopy JTF_NUMBER_TABLE
271: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
272: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
265: , x_return_status out nocopy VARCHAR2
266: , x_msg_count out nocopy NUMBER
267: , x_msg_data out nocopy VARCHAR2
268: , p9_a0 in out nocopy JTF_NUMBER_TABLE
269: , p9_a1 in out nocopy JTF_NUMBER_TABLE
270: , p9_a2 in out nocopy JTF_NUMBER_TABLE
271: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
272: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
273: , p9_a5 in out nocopy JTF_NUMBER_TABLE
266: , x_msg_count out nocopy NUMBER
267: , x_msg_data out nocopy VARCHAR2
268: , p9_a0 in out nocopy JTF_NUMBER_TABLE
269: , p9_a1 in out nocopy JTF_NUMBER_TABLE
270: , p9_a2 in out nocopy JTF_NUMBER_TABLE
271: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
272: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
273: , p9_a5 in out nocopy JTF_NUMBER_TABLE
274: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
269: , p9_a1 in out nocopy JTF_NUMBER_TABLE
270: , p9_a2 in out nocopy JTF_NUMBER_TABLE
271: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
272: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
273: , p9_a5 in out nocopy JTF_NUMBER_TABLE
274: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
275: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
276: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
277: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_200
289: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_200
290: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_200
291: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_200
292: , p9_a24 in out nocopy JTF_DATE_TABLE
293: , p9_a25 in out nocopy JTF_NUMBER_TABLE
294: , p9_a26 in out nocopy JTF_DATE_TABLE
295: , p9_a27 in out nocopy JTF_NUMBER_TABLE
296: , p9_a28 in out nocopy JTF_NUMBER_TABLE
297: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
291: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_200
292: , p9_a24 in out nocopy JTF_DATE_TABLE
293: , p9_a25 in out nocopy JTF_NUMBER_TABLE
294: , p9_a26 in out nocopy JTF_DATE_TABLE
295: , p9_a27 in out nocopy JTF_NUMBER_TABLE
296: , p9_a28 in out nocopy JTF_NUMBER_TABLE
297: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
298: )
299:
292: , p9_a24 in out nocopy JTF_DATE_TABLE
293: , p9_a25 in out nocopy JTF_NUMBER_TABLE
294: , p9_a26 in out nocopy JTF_DATE_TABLE
295: , p9_a27 in out nocopy JTF_NUMBER_TABLE
296: , p9_a28 in out nocopy JTF_NUMBER_TABLE
297: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
298: )
299:
300: as