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_ltp_space_unavl_pub.space_restriction_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_DATE_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_DATE_TABLE
17: , a4 JTF_NUMBER_TABLE
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_ltp_space_unavl_pub.space_restriction_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_DATE_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_DATE_TABLE
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_ltp_space_unavl_pub.space_restriction_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_DATE_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_DATE_TABLE
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_VARCHAR2_TABLE_300
14: , a1 JTF_DATE_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_DATE_TABLE
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_VARCHAR2_TABLE_300
22: , a9 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_DATE_TABLE
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_VARCHAR2_TABLE_300
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_300
16: , a3 JTF_DATE_TABLE
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_VARCHAR2_TABLE_300
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_300
24: , a11 JTF_NUMBER_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_VARCHAR2_TABLE_300
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_300
24: , a11 JTF_NUMBER_TABLE
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_DATE_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_VARCHAR2_TABLE_300
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_300
24: , a11 JTF_NUMBER_TABLE
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_DATE_TABLE
27: , a14 JTF_DATE_TABLE
28: , a15 JTF_VARCHAR2_TABLE_2000
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_ltp_space_unavl_pub.space_restriction_tbl, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_DATE_TABLE
98: , a2 out nocopy JTF_NUMBER_TABLE
99: , a3 out nocopy JTF_DATE_TABLE
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_ltp_space_unavl_pub.space_restriction_tbl, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_DATE_TABLE
98: , a2 out nocopy JTF_NUMBER_TABLE
99: , a3 out nocopy JTF_DATE_TABLE
100: , a4 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_NUMBER_TABLE
102: , a6 out nocopy JTF_NUMBER_TABLE
96: procedure rosetta_table_copy_out_p1(t ahl_ltp_space_unavl_pub.space_restriction_tbl, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_DATE_TABLE
98: , a2 out nocopy JTF_NUMBER_TABLE
99: , a3 out nocopy JTF_DATE_TABLE
100: , a4 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_NUMBER_TABLE
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_VARCHAR2_TABLE_300
97: , a1 out nocopy JTF_DATE_TABLE
98: , a2 out nocopy JTF_NUMBER_TABLE
99: , a3 out nocopy JTF_DATE_TABLE
100: , a4 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_NUMBER_TABLE
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_VARCHAR2_TABLE_300
105: , a9 out nocopy JTF_NUMBER_TABLE
98: , a2 out nocopy JTF_NUMBER_TABLE
99: , a3 out nocopy JTF_DATE_TABLE
100: , a4 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_NUMBER_TABLE
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_VARCHAR2_TABLE_300
105: , a9 out nocopy JTF_NUMBER_TABLE
106: , a10 out nocopy JTF_VARCHAR2_TABLE_300
99: , a3 out nocopy JTF_DATE_TABLE
100: , a4 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_NUMBER_TABLE
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_VARCHAR2_TABLE_300
105: , a9 out nocopy JTF_NUMBER_TABLE
106: , a10 out nocopy JTF_VARCHAR2_TABLE_300
107: , a11 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_NUMBER_TABLE
102: , a6 out nocopy JTF_NUMBER_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_VARCHAR2_TABLE_300
105: , a9 out nocopy JTF_NUMBER_TABLE
106: , a10 out nocopy JTF_VARCHAR2_TABLE_300
107: , a11 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_VARCHAR2_TABLE_100
109: , a13 out nocopy JTF_DATE_TABLE
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_VARCHAR2_TABLE_300
105: , a9 out nocopy JTF_NUMBER_TABLE
106: , a10 out nocopy JTF_VARCHAR2_TABLE_300
107: , a11 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_VARCHAR2_TABLE_100
109: , a13 out nocopy JTF_DATE_TABLE
110: , a14 out nocopy JTF_DATE_TABLE
111: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
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_DATE_TABLE();
135: a2 := JTF_NUMBER_TABLE();
136: a3 := JTF_DATE_TABLE();
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_DATE_TABLE();
135: a2 := JTF_NUMBER_TABLE();
136: a3 := JTF_DATE_TABLE();
137: a4 := JTF_NUMBER_TABLE();
138: a5 := JTF_NUMBER_TABLE();
139: a6 := JTF_NUMBER_TABLE();
133: a0 := JTF_NUMBER_TABLE();
134: a1 := JTF_DATE_TABLE();
135: a2 := JTF_NUMBER_TABLE();
136: a3 := JTF_DATE_TABLE();
137: a4 := JTF_NUMBER_TABLE();
138: a5 := JTF_NUMBER_TABLE();
139: a6 := JTF_NUMBER_TABLE();
140: a7 := JTF_NUMBER_TABLE();
141: a8 := JTF_VARCHAR2_TABLE_300();
134: a1 := JTF_DATE_TABLE();
135: a2 := JTF_NUMBER_TABLE();
136: a3 := JTF_DATE_TABLE();
137: a4 := JTF_NUMBER_TABLE();
138: a5 := JTF_NUMBER_TABLE();
139: a6 := JTF_NUMBER_TABLE();
140: a7 := JTF_NUMBER_TABLE();
141: a8 := JTF_VARCHAR2_TABLE_300();
142: a9 := JTF_NUMBER_TABLE();
135: a2 := JTF_NUMBER_TABLE();
136: a3 := JTF_DATE_TABLE();
137: a4 := JTF_NUMBER_TABLE();
138: a5 := JTF_NUMBER_TABLE();
139: a6 := JTF_NUMBER_TABLE();
140: a7 := JTF_NUMBER_TABLE();
141: a8 := JTF_VARCHAR2_TABLE_300();
142: a9 := JTF_NUMBER_TABLE();
143: a10 := JTF_VARCHAR2_TABLE_300();
136: a3 := JTF_DATE_TABLE();
137: a4 := JTF_NUMBER_TABLE();
138: a5 := JTF_NUMBER_TABLE();
139: a6 := JTF_NUMBER_TABLE();
140: a7 := JTF_NUMBER_TABLE();
141: a8 := JTF_VARCHAR2_TABLE_300();
142: a9 := JTF_NUMBER_TABLE();
143: a10 := JTF_VARCHAR2_TABLE_300();
144: a11 := JTF_NUMBER_TABLE();
138: a5 := JTF_NUMBER_TABLE();
139: a6 := JTF_NUMBER_TABLE();
140: a7 := JTF_NUMBER_TABLE();
141: a8 := JTF_VARCHAR2_TABLE_300();
142: a9 := JTF_NUMBER_TABLE();
143: a10 := JTF_VARCHAR2_TABLE_300();
144: a11 := JTF_NUMBER_TABLE();
145: a12 := JTF_VARCHAR2_TABLE_100();
146: a13 := JTF_DATE_TABLE();
140: a7 := JTF_NUMBER_TABLE();
141: a8 := JTF_VARCHAR2_TABLE_300();
142: a9 := JTF_NUMBER_TABLE();
143: a10 := JTF_VARCHAR2_TABLE_300();
144: a11 := JTF_NUMBER_TABLE();
145: a12 := JTF_VARCHAR2_TABLE_100();
146: a13 := JTF_DATE_TABLE();
147: a14 := JTF_DATE_TABLE();
148: a15 := JTF_VARCHAR2_TABLE_2000();
163: a30 := JTF_VARCHAR2_TABLE_200();
164: a31 := JTF_VARCHAR2_TABLE_200();
165: a32 := JTF_VARCHAR2_TABLE_100();
166: else
167: a0 := JTF_NUMBER_TABLE();
168: a1 := JTF_DATE_TABLE();
169: a2 := JTF_NUMBER_TABLE();
170: a3 := JTF_DATE_TABLE();
171: a4 := JTF_NUMBER_TABLE();
165: a32 := JTF_VARCHAR2_TABLE_100();
166: else
167: a0 := JTF_NUMBER_TABLE();
168: a1 := JTF_DATE_TABLE();
169: a2 := JTF_NUMBER_TABLE();
170: a3 := JTF_DATE_TABLE();
171: a4 := JTF_NUMBER_TABLE();
172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_NUMBER_TABLE();
167: a0 := JTF_NUMBER_TABLE();
168: a1 := JTF_DATE_TABLE();
169: a2 := JTF_NUMBER_TABLE();
170: a3 := JTF_DATE_TABLE();
171: a4 := JTF_NUMBER_TABLE();
172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_NUMBER_TABLE();
174: a7 := JTF_NUMBER_TABLE();
175: a8 := JTF_VARCHAR2_TABLE_300();
168: a1 := JTF_DATE_TABLE();
169: a2 := JTF_NUMBER_TABLE();
170: a3 := JTF_DATE_TABLE();
171: a4 := JTF_NUMBER_TABLE();
172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_NUMBER_TABLE();
174: a7 := JTF_NUMBER_TABLE();
175: a8 := JTF_VARCHAR2_TABLE_300();
176: a9 := JTF_NUMBER_TABLE();
169: a2 := JTF_NUMBER_TABLE();
170: a3 := JTF_DATE_TABLE();
171: a4 := JTF_NUMBER_TABLE();
172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_NUMBER_TABLE();
174: a7 := JTF_NUMBER_TABLE();
175: a8 := JTF_VARCHAR2_TABLE_300();
176: a9 := JTF_NUMBER_TABLE();
177: a10 := JTF_VARCHAR2_TABLE_300();
170: a3 := JTF_DATE_TABLE();
171: a4 := JTF_NUMBER_TABLE();
172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_NUMBER_TABLE();
174: a7 := JTF_NUMBER_TABLE();
175: a8 := JTF_VARCHAR2_TABLE_300();
176: a9 := JTF_NUMBER_TABLE();
177: a10 := JTF_VARCHAR2_TABLE_300();
178: a11 := JTF_NUMBER_TABLE();
172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_NUMBER_TABLE();
174: a7 := JTF_NUMBER_TABLE();
175: a8 := JTF_VARCHAR2_TABLE_300();
176: a9 := JTF_NUMBER_TABLE();
177: a10 := JTF_VARCHAR2_TABLE_300();
178: a11 := JTF_NUMBER_TABLE();
179: a12 := JTF_VARCHAR2_TABLE_100();
180: a13 := JTF_DATE_TABLE();
174: a7 := JTF_NUMBER_TABLE();
175: a8 := JTF_VARCHAR2_TABLE_300();
176: a9 := JTF_NUMBER_TABLE();
177: a10 := JTF_VARCHAR2_TABLE_300();
178: a11 := JTF_NUMBER_TABLE();
179: a12 := JTF_VARCHAR2_TABLE_100();
180: a13 := JTF_DATE_TABLE();
181: a14 := JTF_DATE_TABLE();
182: a15 := JTF_VARCHAR2_TABLE_2000();
281: , p_init_msg_list VARCHAR2
282: , p_commit VARCHAR2
283: , p_validation_level NUMBER
284: , p_module_type VARCHAR2
285: , p5_a0 in out nocopy JTF_NUMBER_TABLE
286: , p5_a1 in out nocopy JTF_DATE_TABLE
287: , p5_a2 in out nocopy JTF_NUMBER_TABLE
288: , p5_a3 in out nocopy JTF_DATE_TABLE
289: , p5_a4 in out nocopy JTF_NUMBER_TABLE
283: , p_validation_level NUMBER
284: , p_module_type VARCHAR2
285: , p5_a0 in out nocopy JTF_NUMBER_TABLE
286: , p5_a1 in out nocopy JTF_DATE_TABLE
287: , p5_a2 in out nocopy JTF_NUMBER_TABLE
288: , p5_a3 in out nocopy JTF_DATE_TABLE
289: , p5_a4 in out nocopy JTF_NUMBER_TABLE
290: , p5_a5 in out nocopy JTF_NUMBER_TABLE
291: , p5_a6 in out nocopy JTF_NUMBER_TABLE
285: , p5_a0 in out nocopy JTF_NUMBER_TABLE
286: , p5_a1 in out nocopy JTF_DATE_TABLE
287: , p5_a2 in out nocopy JTF_NUMBER_TABLE
288: , p5_a3 in out nocopy JTF_DATE_TABLE
289: , p5_a4 in out nocopy JTF_NUMBER_TABLE
290: , p5_a5 in out nocopy JTF_NUMBER_TABLE
291: , p5_a6 in out nocopy JTF_NUMBER_TABLE
292: , p5_a7 in out nocopy JTF_NUMBER_TABLE
293: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_300
286: , p5_a1 in out nocopy JTF_DATE_TABLE
287: , p5_a2 in out nocopy JTF_NUMBER_TABLE
288: , p5_a3 in out nocopy JTF_DATE_TABLE
289: , p5_a4 in out nocopy JTF_NUMBER_TABLE
290: , p5_a5 in out nocopy JTF_NUMBER_TABLE
291: , p5_a6 in out nocopy JTF_NUMBER_TABLE
292: , p5_a7 in out nocopy JTF_NUMBER_TABLE
293: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_300
294: , p5_a9 in out nocopy JTF_NUMBER_TABLE
287: , p5_a2 in out nocopy JTF_NUMBER_TABLE
288: , p5_a3 in out nocopy JTF_DATE_TABLE
289: , p5_a4 in out nocopy JTF_NUMBER_TABLE
290: , p5_a5 in out nocopy JTF_NUMBER_TABLE
291: , p5_a6 in out nocopy JTF_NUMBER_TABLE
292: , p5_a7 in out nocopy JTF_NUMBER_TABLE
293: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_300
294: , p5_a9 in out nocopy JTF_NUMBER_TABLE
295: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300
288: , p5_a3 in out nocopy JTF_DATE_TABLE
289: , p5_a4 in out nocopy JTF_NUMBER_TABLE
290: , p5_a5 in out nocopy JTF_NUMBER_TABLE
291: , p5_a6 in out nocopy JTF_NUMBER_TABLE
292: , p5_a7 in out nocopy JTF_NUMBER_TABLE
293: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_300
294: , p5_a9 in out nocopy JTF_NUMBER_TABLE
295: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300
296: , p5_a11 in out nocopy JTF_NUMBER_TABLE
290: , p5_a5 in out nocopy JTF_NUMBER_TABLE
291: , p5_a6 in out nocopy JTF_NUMBER_TABLE
292: , p5_a7 in out nocopy JTF_NUMBER_TABLE
293: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_300
294: , p5_a9 in out nocopy JTF_NUMBER_TABLE
295: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300
296: , p5_a11 in out nocopy JTF_NUMBER_TABLE
297: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
298: , p5_a13 in out nocopy JTF_DATE_TABLE
292: , p5_a7 in out nocopy JTF_NUMBER_TABLE
293: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_300
294: , p5_a9 in out nocopy JTF_NUMBER_TABLE
295: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300
296: , p5_a11 in out nocopy JTF_NUMBER_TABLE
297: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
298: , p5_a13 in out nocopy JTF_DATE_TABLE
299: , p5_a14 in out nocopy JTF_DATE_TABLE
300: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_2000