12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_approvals_pvt.approvers_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_approvals_pvt.approvers_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_approvals_pvt.approvers_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_approvals_pvt.approvers_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_DATE_TABLE
24: , a8 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_DATE_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_DATE_TABLE
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_DATE_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_DATE_TABLE
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_DATE_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_DATE_TABLE
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_200
30: , a14 JTF_VARCHAR2_TABLE_200
23: , a7 JTF_DATE_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_DATE_TABLE
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_200
30: , a14 JTF_VARCHAR2_TABLE_200
31: , a15 JTF_VARCHAR2_TABLE_200
87: end loop;
88: end if;
89: end if;
90: end rosetta_table_copy_in_p2;
91: procedure rosetta_table_copy_out_p2(t ahl_approvals_pvt.approvers_tbl, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_NUMBER_TABLE
94: , a3 out nocopy JTF_VARCHAR2_TABLE_100
95: , a4 out nocopy JTF_NUMBER_TABLE
88: end if;
89: end if;
90: end rosetta_table_copy_in_p2;
91: procedure rosetta_table_copy_out_p2(t ahl_approvals_pvt.approvers_tbl, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_NUMBER_TABLE
94: , a3 out nocopy JTF_VARCHAR2_TABLE_100
95: , a4 out nocopy JTF_NUMBER_TABLE
96: , a5 out nocopy JTF_NUMBER_TABLE
89: end if;
90: end rosetta_table_copy_in_p2;
91: procedure rosetta_table_copy_out_p2(t ahl_approvals_pvt.approvers_tbl, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_NUMBER_TABLE
94: , a3 out nocopy JTF_VARCHAR2_TABLE_100
95: , a4 out nocopy JTF_NUMBER_TABLE
96: , a5 out nocopy JTF_NUMBER_TABLE
97: , a6 out nocopy JTF_VARCHAR2_TABLE_100
91: procedure rosetta_table_copy_out_p2(t ahl_approvals_pvt.approvers_tbl, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_NUMBER_TABLE
94: , a3 out nocopy JTF_VARCHAR2_TABLE_100
95: , a4 out nocopy JTF_NUMBER_TABLE
96: , a5 out nocopy JTF_NUMBER_TABLE
97: , a6 out nocopy JTF_VARCHAR2_TABLE_100
98: , a7 out nocopy JTF_DATE_TABLE
99: , a8 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_NUMBER_TABLE
94: , a3 out nocopy JTF_VARCHAR2_TABLE_100
95: , a4 out nocopy JTF_NUMBER_TABLE
96: , a5 out nocopy JTF_NUMBER_TABLE
97: , a6 out nocopy JTF_VARCHAR2_TABLE_100
98: , a7 out nocopy JTF_DATE_TABLE
99: , a8 out nocopy JTF_NUMBER_TABLE
100: , a9 out nocopy JTF_DATE_TABLE
95: , a4 out nocopy JTF_NUMBER_TABLE
96: , a5 out nocopy JTF_NUMBER_TABLE
97: , a6 out nocopy JTF_VARCHAR2_TABLE_100
98: , a7 out nocopy JTF_DATE_TABLE
99: , a8 out nocopy JTF_NUMBER_TABLE
100: , a9 out nocopy JTF_DATE_TABLE
101: , a10 out nocopy JTF_NUMBER_TABLE
102: , a11 out nocopy JTF_NUMBER_TABLE
103: , a12 out nocopy JTF_VARCHAR2_TABLE_100
97: , a6 out nocopy JTF_VARCHAR2_TABLE_100
98: , a7 out nocopy JTF_DATE_TABLE
99: , a8 out nocopy JTF_NUMBER_TABLE
100: , a9 out nocopy JTF_DATE_TABLE
101: , a10 out nocopy JTF_NUMBER_TABLE
102: , a11 out nocopy JTF_NUMBER_TABLE
103: , a12 out nocopy JTF_VARCHAR2_TABLE_100
104: , a13 out nocopy JTF_VARCHAR2_TABLE_200
105: , a14 out nocopy JTF_VARCHAR2_TABLE_200
98: , a7 out nocopy JTF_DATE_TABLE
99: , a8 out nocopy JTF_NUMBER_TABLE
100: , a9 out nocopy JTF_DATE_TABLE
101: , a10 out nocopy JTF_NUMBER_TABLE
102: , a11 out nocopy JTF_NUMBER_TABLE
103: , a12 out nocopy JTF_VARCHAR2_TABLE_100
104: , a13 out nocopy JTF_VARCHAR2_TABLE_200
105: , a14 out nocopy JTF_VARCHAR2_TABLE_200
106: , a15 out nocopy JTF_VARCHAR2_TABLE_200
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_NUMBER_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_NUMBER_TABLE();
127: a3 := JTF_VARCHAR2_TABLE_100();
128: a4 := JTF_NUMBER_TABLE();
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_NUMBER_TABLE();
129: a5 := JTF_NUMBER_TABLE();
130: a6 := JTF_VARCHAR2_TABLE_100();
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_VARCHAR2_TABLE_100();
128: a4 := JTF_NUMBER_TABLE();
129: a5 := JTF_NUMBER_TABLE();
130: a6 := JTF_VARCHAR2_TABLE_100();
131: a7 := JTF_DATE_TABLE();
132: a8 := JTF_NUMBER_TABLE();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_VARCHAR2_TABLE_100();
128: a4 := JTF_NUMBER_TABLE();
129: a5 := JTF_NUMBER_TABLE();
130: a6 := JTF_VARCHAR2_TABLE_100();
131: a7 := JTF_DATE_TABLE();
132: a8 := JTF_NUMBER_TABLE();
133: a9 := JTF_DATE_TABLE();
128: a4 := JTF_NUMBER_TABLE();
129: a5 := JTF_NUMBER_TABLE();
130: a6 := JTF_VARCHAR2_TABLE_100();
131: a7 := JTF_DATE_TABLE();
132: a8 := JTF_NUMBER_TABLE();
133: a9 := JTF_DATE_TABLE();
134: a10 := JTF_NUMBER_TABLE();
135: a11 := JTF_NUMBER_TABLE();
136: a12 := JTF_VARCHAR2_TABLE_100();
130: a6 := JTF_VARCHAR2_TABLE_100();
131: a7 := JTF_DATE_TABLE();
132: a8 := JTF_NUMBER_TABLE();
133: a9 := JTF_DATE_TABLE();
134: a10 := JTF_NUMBER_TABLE();
135: a11 := JTF_NUMBER_TABLE();
136: a12 := JTF_VARCHAR2_TABLE_100();
137: a13 := JTF_VARCHAR2_TABLE_200();
138: a14 := JTF_VARCHAR2_TABLE_200();
131: a7 := JTF_DATE_TABLE();
132: a8 := JTF_NUMBER_TABLE();
133: a9 := JTF_DATE_TABLE();
134: a10 := JTF_NUMBER_TABLE();
135: a11 := JTF_NUMBER_TABLE();
136: a12 := JTF_VARCHAR2_TABLE_100();
137: a13 := JTF_VARCHAR2_TABLE_200();
138: a14 := JTF_VARCHAR2_TABLE_200();
139: a15 := JTF_VARCHAR2_TABLE_200();
150: a26 := JTF_VARCHAR2_TABLE_200();
151: a27 := JTF_VARCHAR2_TABLE_200();
152: a28 := JTF_VARCHAR2_TABLE_100();
153: else
154: a0 := JTF_NUMBER_TABLE();
155: a1 := JTF_NUMBER_TABLE();
156: a2 := JTF_NUMBER_TABLE();
157: a3 := JTF_VARCHAR2_TABLE_100();
158: a4 := JTF_NUMBER_TABLE();
151: a27 := JTF_VARCHAR2_TABLE_200();
152: a28 := JTF_VARCHAR2_TABLE_100();
153: else
154: a0 := JTF_NUMBER_TABLE();
155: a1 := JTF_NUMBER_TABLE();
156: a2 := JTF_NUMBER_TABLE();
157: a3 := JTF_VARCHAR2_TABLE_100();
158: a4 := JTF_NUMBER_TABLE();
159: a5 := JTF_NUMBER_TABLE();
152: a28 := JTF_VARCHAR2_TABLE_100();
153: else
154: a0 := JTF_NUMBER_TABLE();
155: a1 := JTF_NUMBER_TABLE();
156: a2 := JTF_NUMBER_TABLE();
157: a3 := JTF_VARCHAR2_TABLE_100();
158: a4 := JTF_NUMBER_TABLE();
159: a5 := JTF_NUMBER_TABLE();
160: a6 := JTF_VARCHAR2_TABLE_100();
154: a0 := JTF_NUMBER_TABLE();
155: a1 := JTF_NUMBER_TABLE();
156: a2 := JTF_NUMBER_TABLE();
157: a3 := JTF_VARCHAR2_TABLE_100();
158: a4 := JTF_NUMBER_TABLE();
159: a5 := JTF_NUMBER_TABLE();
160: a6 := JTF_VARCHAR2_TABLE_100();
161: a7 := JTF_DATE_TABLE();
162: a8 := JTF_NUMBER_TABLE();
155: a1 := JTF_NUMBER_TABLE();
156: a2 := JTF_NUMBER_TABLE();
157: a3 := JTF_VARCHAR2_TABLE_100();
158: a4 := JTF_NUMBER_TABLE();
159: a5 := JTF_NUMBER_TABLE();
160: a6 := JTF_VARCHAR2_TABLE_100();
161: a7 := JTF_DATE_TABLE();
162: a8 := JTF_NUMBER_TABLE();
163: a9 := JTF_DATE_TABLE();
158: a4 := JTF_NUMBER_TABLE();
159: a5 := JTF_NUMBER_TABLE();
160: a6 := JTF_VARCHAR2_TABLE_100();
161: a7 := JTF_DATE_TABLE();
162: a8 := JTF_NUMBER_TABLE();
163: a9 := JTF_DATE_TABLE();
164: a10 := JTF_NUMBER_TABLE();
165: a11 := JTF_NUMBER_TABLE();
166: a12 := JTF_VARCHAR2_TABLE_100();
160: a6 := JTF_VARCHAR2_TABLE_100();
161: a7 := JTF_DATE_TABLE();
162: a8 := JTF_NUMBER_TABLE();
163: a9 := JTF_DATE_TABLE();
164: a10 := JTF_NUMBER_TABLE();
165: a11 := JTF_NUMBER_TABLE();
166: a12 := JTF_VARCHAR2_TABLE_100();
167: a13 := JTF_VARCHAR2_TABLE_200();
168: a14 := JTF_VARCHAR2_TABLE_200();
161: a7 := JTF_DATE_TABLE();
162: a8 := JTF_NUMBER_TABLE();
163: a9 := JTF_DATE_TABLE();
164: a10 := JTF_NUMBER_TABLE();
165: a11 := JTF_NUMBER_TABLE();
166: a12 := JTF_VARCHAR2_TABLE_100();
167: a13 := JTF_VARCHAR2_TABLE_200();
168: a14 := JTF_VARCHAR2_TABLE_200();
169: a15 := JTF_VARCHAR2_TABLE_200();
292: , p4_a33 in out nocopy DATE
293: , p4_a34 in out nocopy NUMBER
294: , p4_a35 in out nocopy NUMBER
295: , p4_a36 in out nocopy VARCHAR2
296: , p5_a0 in out nocopy JTF_NUMBER_TABLE
297: , p5_a1 in out nocopy JTF_NUMBER_TABLE
298: , p5_a2 in out nocopy JTF_NUMBER_TABLE
299: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
300: , p5_a4 in out nocopy JTF_NUMBER_TABLE
293: , p4_a34 in out nocopy NUMBER
294: , p4_a35 in out nocopy NUMBER
295: , p4_a36 in out nocopy VARCHAR2
296: , p5_a0 in out nocopy JTF_NUMBER_TABLE
297: , p5_a1 in out nocopy JTF_NUMBER_TABLE
298: , p5_a2 in out nocopy JTF_NUMBER_TABLE
299: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
300: , p5_a4 in out nocopy JTF_NUMBER_TABLE
301: , p5_a5 in out nocopy JTF_NUMBER_TABLE
294: , p4_a35 in out nocopy NUMBER
295: , p4_a36 in out nocopy VARCHAR2
296: , p5_a0 in out nocopy JTF_NUMBER_TABLE
297: , p5_a1 in out nocopy JTF_NUMBER_TABLE
298: , p5_a2 in out nocopy JTF_NUMBER_TABLE
299: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
300: , p5_a4 in out nocopy JTF_NUMBER_TABLE
301: , p5_a5 in out nocopy JTF_NUMBER_TABLE
302: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
296: , p5_a0 in out nocopy JTF_NUMBER_TABLE
297: , p5_a1 in out nocopy JTF_NUMBER_TABLE
298: , p5_a2 in out nocopy JTF_NUMBER_TABLE
299: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
300: , p5_a4 in out nocopy JTF_NUMBER_TABLE
301: , p5_a5 in out nocopy JTF_NUMBER_TABLE
302: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
303: , p5_a7 in out nocopy JTF_DATE_TABLE
304: , p5_a8 in out nocopy JTF_NUMBER_TABLE
297: , p5_a1 in out nocopy JTF_NUMBER_TABLE
298: , p5_a2 in out nocopy JTF_NUMBER_TABLE
299: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
300: , p5_a4 in out nocopy JTF_NUMBER_TABLE
301: , p5_a5 in out nocopy JTF_NUMBER_TABLE
302: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
303: , p5_a7 in out nocopy JTF_DATE_TABLE
304: , p5_a8 in out nocopy JTF_NUMBER_TABLE
305: , p5_a9 in out nocopy JTF_DATE_TABLE
300: , p5_a4 in out nocopy JTF_NUMBER_TABLE
301: , p5_a5 in out nocopy JTF_NUMBER_TABLE
302: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
303: , p5_a7 in out nocopy JTF_DATE_TABLE
304: , p5_a8 in out nocopy JTF_NUMBER_TABLE
305: , p5_a9 in out nocopy JTF_DATE_TABLE
306: , p5_a10 in out nocopy JTF_NUMBER_TABLE
307: , p5_a11 in out nocopy JTF_NUMBER_TABLE
308: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
302: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
303: , p5_a7 in out nocopy JTF_DATE_TABLE
304: , p5_a8 in out nocopy JTF_NUMBER_TABLE
305: , p5_a9 in out nocopy JTF_DATE_TABLE
306: , p5_a10 in out nocopy JTF_NUMBER_TABLE
307: , p5_a11 in out nocopy JTF_NUMBER_TABLE
308: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
309: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_200
310: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_200
303: , p5_a7 in out nocopy JTF_DATE_TABLE
304: , p5_a8 in out nocopy JTF_NUMBER_TABLE
305: , p5_a9 in out nocopy JTF_DATE_TABLE
306: , p5_a10 in out nocopy JTF_NUMBER_TABLE
307: , p5_a11 in out nocopy JTF_NUMBER_TABLE
308: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
309: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_200
310: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_200
311: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_200