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_vwp_tasks_links_pvt.task_link_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_DATE_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_vwp_tasks_links_pvt.task_link_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_DATE_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_vwp_tasks_links_pvt.task_link_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_DATE_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_DATE_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_NUMBER_TABLE
15: , a2 JTF_DATE_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_100
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_vwp_tasks_links_pvt.task_link_tbl, a0 out nocopy JTF_NUMBER_TABLE
91: , a1 out nocopy JTF_NUMBER_TABLE
92: , a2 out nocopy JTF_DATE_TABLE
93: , a3 out nocopy JTF_NUMBER_TABLE
94: , a4 out nocopy JTF_DATE_TABLE
87: end if;
88: end if;
89: end rosetta_table_copy_in_p1;
90: procedure rosetta_table_copy_out_p1(t ahl_vwp_tasks_links_pvt.task_link_tbl, a0 out nocopy JTF_NUMBER_TABLE
91: , a1 out nocopy JTF_NUMBER_TABLE
92: , a2 out nocopy JTF_DATE_TABLE
93: , a3 out nocopy JTF_NUMBER_TABLE
94: , a4 out nocopy JTF_DATE_TABLE
95: , a5 out nocopy JTF_NUMBER_TABLE
89: end rosetta_table_copy_in_p1;
90: procedure rosetta_table_copy_out_p1(t ahl_vwp_tasks_links_pvt.task_link_tbl, a0 out nocopy JTF_NUMBER_TABLE
91: , a1 out nocopy JTF_NUMBER_TABLE
92: , a2 out nocopy JTF_DATE_TABLE
93: , a3 out nocopy JTF_NUMBER_TABLE
94: , a4 out nocopy JTF_DATE_TABLE
95: , a5 out nocopy JTF_NUMBER_TABLE
96: , a6 out nocopy JTF_NUMBER_TABLE
97: , a7 out nocopy JTF_NUMBER_TABLE
91: , a1 out nocopy JTF_NUMBER_TABLE
92: , a2 out nocopy JTF_DATE_TABLE
93: , a3 out nocopy JTF_NUMBER_TABLE
94: , a4 out nocopy JTF_DATE_TABLE
95: , a5 out nocopy JTF_NUMBER_TABLE
96: , a6 out nocopy JTF_NUMBER_TABLE
97: , a7 out nocopy JTF_NUMBER_TABLE
98: , a8 out nocopy JTF_NUMBER_TABLE
99: , a9 out nocopy JTF_NUMBER_TABLE
92: , a2 out nocopy JTF_DATE_TABLE
93: , a3 out nocopy JTF_NUMBER_TABLE
94: , a4 out nocopy JTF_DATE_TABLE
95: , a5 out nocopy JTF_NUMBER_TABLE
96: , a6 out nocopy JTF_NUMBER_TABLE
97: , a7 out nocopy JTF_NUMBER_TABLE
98: , a8 out nocopy JTF_NUMBER_TABLE
99: , a9 out nocopy JTF_NUMBER_TABLE
100: , a10 out nocopy JTF_VARCHAR2_TABLE_100
93: , a3 out nocopy JTF_NUMBER_TABLE
94: , a4 out nocopy JTF_DATE_TABLE
95: , a5 out nocopy JTF_NUMBER_TABLE
96: , a6 out nocopy JTF_NUMBER_TABLE
97: , a7 out nocopy JTF_NUMBER_TABLE
98: , a8 out nocopy JTF_NUMBER_TABLE
99: , a9 out nocopy JTF_NUMBER_TABLE
100: , a10 out nocopy JTF_VARCHAR2_TABLE_100
101: , a11 out nocopy JTF_VARCHAR2_TABLE_100
94: , a4 out nocopy JTF_DATE_TABLE
95: , a5 out nocopy JTF_NUMBER_TABLE
96: , a6 out nocopy JTF_NUMBER_TABLE
97: , a7 out nocopy JTF_NUMBER_TABLE
98: , a8 out nocopy JTF_NUMBER_TABLE
99: , a9 out nocopy JTF_NUMBER_TABLE
100: , a10 out nocopy JTF_VARCHAR2_TABLE_100
101: , a11 out nocopy JTF_VARCHAR2_TABLE_100
102: , a12 out nocopy JTF_VARCHAR2_TABLE_100
95: , a5 out nocopy JTF_NUMBER_TABLE
96: , a6 out nocopy JTF_NUMBER_TABLE
97: , a7 out nocopy JTF_NUMBER_TABLE
98: , a8 out nocopy JTF_NUMBER_TABLE
99: , a9 out nocopy JTF_NUMBER_TABLE
100: , a10 out nocopy JTF_VARCHAR2_TABLE_100
101: , a11 out nocopy JTF_VARCHAR2_TABLE_100
102: , a12 out nocopy JTF_VARCHAR2_TABLE_100
103: , a13 out nocopy JTF_VARCHAR2_TABLE_100
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_DATE_TABLE();
127: a3 := JTF_NUMBER_TABLE();
128: a4 := JTF_DATE_TABLE();
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_DATE_TABLE();
127: a3 := JTF_NUMBER_TABLE();
128: a4 := JTF_DATE_TABLE();
129: a5 := JTF_NUMBER_TABLE();
123: if t is null or t.count = 0 then
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_DATE_TABLE();
127: a3 := JTF_NUMBER_TABLE();
128: a4 := JTF_DATE_TABLE();
129: a5 := JTF_NUMBER_TABLE();
130: a6 := JTF_NUMBER_TABLE();
131: a7 := JTF_NUMBER_TABLE();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_DATE_TABLE();
127: a3 := JTF_NUMBER_TABLE();
128: a4 := JTF_DATE_TABLE();
129: a5 := JTF_NUMBER_TABLE();
130: a6 := JTF_NUMBER_TABLE();
131: a7 := JTF_NUMBER_TABLE();
132: a8 := JTF_NUMBER_TABLE();
133: a9 := JTF_NUMBER_TABLE();
126: a2 := JTF_DATE_TABLE();
127: a3 := JTF_NUMBER_TABLE();
128: a4 := JTF_DATE_TABLE();
129: a5 := JTF_NUMBER_TABLE();
130: a6 := JTF_NUMBER_TABLE();
131: a7 := JTF_NUMBER_TABLE();
132: a8 := JTF_NUMBER_TABLE();
133: a9 := JTF_NUMBER_TABLE();
134: a10 := JTF_VARCHAR2_TABLE_100();
127: a3 := JTF_NUMBER_TABLE();
128: a4 := JTF_DATE_TABLE();
129: a5 := JTF_NUMBER_TABLE();
130: a6 := JTF_NUMBER_TABLE();
131: a7 := JTF_NUMBER_TABLE();
132: a8 := JTF_NUMBER_TABLE();
133: a9 := JTF_NUMBER_TABLE();
134: a10 := JTF_VARCHAR2_TABLE_100();
135: a11 := JTF_VARCHAR2_TABLE_100();
128: a4 := JTF_DATE_TABLE();
129: a5 := JTF_NUMBER_TABLE();
130: a6 := JTF_NUMBER_TABLE();
131: a7 := JTF_NUMBER_TABLE();
132: a8 := JTF_NUMBER_TABLE();
133: a9 := JTF_NUMBER_TABLE();
134: a10 := JTF_VARCHAR2_TABLE_100();
135: a11 := JTF_VARCHAR2_TABLE_100();
136: a12 := JTF_VARCHAR2_TABLE_100();
129: a5 := JTF_NUMBER_TABLE();
130: a6 := JTF_NUMBER_TABLE();
131: a7 := JTF_NUMBER_TABLE();
132: a8 := JTF_NUMBER_TABLE();
133: a9 := JTF_NUMBER_TABLE();
134: a10 := JTF_VARCHAR2_TABLE_100();
135: a11 := JTF_VARCHAR2_TABLE_100();
136: a12 := JTF_VARCHAR2_TABLE_100();
137: a13 := JTF_VARCHAR2_TABLE_100();
151: a27 := JTF_VARCHAR2_TABLE_200();
152: a28 := JTF_VARCHAR2_TABLE_200();
153: a29 := JTF_VARCHAR2_TABLE_100();
154: else
155: a0 := JTF_NUMBER_TABLE();
156: a1 := JTF_NUMBER_TABLE();
157: a2 := JTF_DATE_TABLE();
158: a3 := JTF_NUMBER_TABLE();
159: a4 := JTF_DATE_TABLE();
152: a28 := JTF_VARCHAR2_TABLE_200();
153: a29 := JTF_VARCHAR2_TABLE_100();
154: else
155: a0 := JTF_NUMBER_TABLE();
156: a1 := JTF_NUMBER_TABLE();
157: a2 := JTF_DATE_TABLE();
158: a3 := JTF_NUMBER_TABLE();
159: a4 := JTF_DATE_TABLE();
160: a5 := JTF_NUMBER_TABLE();
154: else
155: a0 := JTF_NUMBER_TABLE();
156: a1 := JTF_NUMBER_TABLE();
157: a2 := JTF_DATE_TABLE();
158: a3 := JTF_NUMBER_TABLE();
159: a4 := JTF_DATE_TABLE();
160: a5 := JTF_NUMBER_TABLE();
161: a6 := JTF_NUMBER_TABLE();
162: a7 := JTF_NUMBER_TABLE();
156: a1 := JTF_NUMBER_TABLE();
157: a2 := JTF_DATE_TABLE();
158: a3 := JTF_NUMBER_TABLE();
159: a4 := JTF_DATE_TABLE();
160: a5 := JTF_NUMBER_TABLE();
161: a6 := JTF_NUMBER_TABLE();
162: a7 := JTF_NUMBER_TABLE();
163: a8 := JTF_NUMBER_TABLE();
164: a9 := JTF_NUMBER_TABLE();
157: a2 := JTF_DATE_TABLE();
158: a3 := JTF_NUMBER_TABLE();
159: a4 := JTF_DATE_TABLE();
160: a5 := JTF_NUMBER_TABLE();
161: a6 := JTF_NUMBER_TABLE();
162: a7 := JTF_NUMBER_TABLE();
163: a8 := JTF_NUMBER_TABLE();
164: a9 := JTF_NUMBER_TABLE();
165: a10 := JTF_VARCHAR2_TABLE_100();
158: a3 := JTF_NUMBER_TABLE();
159: a4 := JTF_DATE_TABLE();
160: a5 := JTF_NUMBER_TABLE();
161: a6 := JTF_NUMBER_TABLE();
162: a7 := JTF_NUMBER_TABLE();
163: a8 := JTF_NUMBER_TABLE();
164: a9 := JTF_NUMBER_TABLE();
165: a10 := JTF_VARCHAR2_TABLE_100();
166: a11 := JTF_VARCHAR2_TABLE_100();
159: a4 := JTF_DATE_TABLE();
160: a5 := JTF_NUMBER_TABLE();
161: a6 := JTF_NUMBER_TABLE();
162: a7 := JTF_NUMBER_TABLE();
163: a8 := JTF_NUMBER_TABLE();
164: a9 := JTF_NUMBER_TABLE();
165: a10 := JTF_VARCHAR2_TABLE_100();
166: a11 := JTF_VARCHAR2_TABLE_100();
167: a12 := JTF_VARCHAR2_TABLE_100();
160: a5 := JTF_NUMBER_TABLE();
161: a6 := JTF_NUMBER_TABLE();
162: a7 := JTF_NUMBER_TABLE();
163: a8 := JTF_NUMBER_TABLE();
164: a9 := JTF_NUMBER_TABLE();
165: a10 := JTF_VARCHAR2_TABLE_100();
166: a11 := JTF_VARCHAR2_TABLE_100();
167: a12 := JTF_VARCHAR2_TABLE_100();
168: a13 := JTF_VARCHAR2_TABLE_100();
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_DATE_TABLE
271: , p9_a3 in out nocopy JTF_NUMBER_TABLE
272: , p9_a4 in out nocopy JTF_DATE_TABLE
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_DATE_TABLE
271: , p9_a3 in out nocopy JTF_NUMBER_TABLE
272: , p9_a4 in out nocopy JTF_DATE_TABLE
273: , p9_a5 in out nocopy JTF_NUMBER_TABLE
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_DATE_TABLE
271: , p9_a3 in out nocopy JTF_NUMBER_TABLE
272: , p9_a4 in out nocopy JTF_DATE_TABLE
273: , p9_a5 in out nocopy JTF_NUMBER_TABLE
274: , p9_a6 in out nocopy JTF_NUMBER_TABLE
275: , p9_a7 in out nocopy JTF_NUMBER_TABLE
269: , p9_a1 in out nocopy JTF_NUMBER_TABLE
270: , p9_a2 in out nocopy JTF_DATE_TABLE
271: , p9_a3 in out nocopy JTF_NUMBER_TABLE
272: , p9_a4 in out nocopy JTF_DATE_TABLE
273: , p9_a5 in out nocopy JTF_NUMBER_TABLE
274: , p9_a6 in out nocopy JTF_NUMBER_TABLE
275: , p9_a7 in out nocopy JTF_NUMBER_TABLE
276: , p9_a8 in out nocopy JTF_NUMBER_TABLE
277: , p9_a9 in out nocopy JTF_NUMBER_TABLE
270: , p9_a2 in out nocopy JTF_DATE_TABLE
271: , p9_a3 in out nocopy JTF_NUMBER_TABLE
272: , p9_a4 in out nocopy JTF_DATE_TABLE
273: , p9_a5 in out nocopy JTF_NUMBER_TABLE
274: , p9_a6 in out nocopy JTF_NUMBER_TABLE
275: , p9_a7 in out nocopy JTF_NUMBER_TABLE
276: , p9_a8 in out nocopy JTF_NUMBER_TABLE
277: , p9_a9 in out nocopy JTF_NUMBER_TABLE
278: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
271: , p9_a3 in out nocopy JTF_NUMBER_TABLE
272: , p9_a4 in out nocopy JTF_DATE_TABLE
273: , p9_a5 in out nocopy JTF_NUMBER_TABLE
274: , p9_a6 in out nocopy JTF_NUMBER_TABLE
275: , p9_a7 in out nocopy JTF_NUMBER_TABLE
276: , p9_a8 in out nocopy JTF_NUMBER_TABLE
277: , p9_a9 in out nocopy JTF_NUMBER_TABLE
278: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
279: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
272: , p9_a4 in out nocopy JTF_DATE_TABLE
273: , p9_a5 in out nocopy JTF_NUMBER_TABLE
274: , p9_a6 in out nocopy JTF_NUMBER_TABLE
275: , p9_a7 in out nocopy JTF_NUMBER_TABLE
276: , p9_a8 in out nocopy JTF_NUMBER_TABLE
277: , p9_a9 in out nocopy JTF_NUMBER_TABLE
278: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
279: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
273: , p9_a5 in out nocopy JTF_NUMBER_TABLE
274: , p9_a6 in out nocopy JTF_NUMBER_TABLE
275: , p9_a7 in out nocopy JTF_NUMBER_TABLE
276: , p9_a8 in out nocopy JTF_NUMBER_TABLE
277: , p9_a9 in out nocopy JTF_NUMBER_TABLE
278: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
279: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
281: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100