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_p3(t out nocopy ahl_ltp_resrc_levl_pub.aval_resources_tbl, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_DATE_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_100
16: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_resrc_levl_pub.aval_resources_tbl, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_DATE_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_300
26: ) as
27: ddindx binary_integer; indx binary_integer;
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_300
26: ) as
27: ddindx binary_integer; indx binary_integer;
28: begin
49: end loop;
50: end if;
51: end if;
52: end rosetta_table_copy_in_p3;
53: procedure rosetta_table_copy_out_p3(t ahl_ltp_resrc_levl_pub.aval_resources_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
54: , a1 out nocopy JTF_DATE_TABLE
55: , a2 out nocopy JTF_DATE_TABLE
56: , a3 out nocopy JTF_NUMBER_TABLE
57: , a4 out nocopy JTF_VARCHAR2_TABLE_100
53: procedure rosetta_table_copy_out_p3(t ahl_ltp_resrc_levl_pub.aval_resources_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
54: , a1 out nocopy JTF_DATE_TABLE
55: , a2 out nocopy JTF_DATE_TABLE
56: , a3 out nocopy JTF_NUMBER_TABLE
57: , a4 out nocopy JTF_VARCHAR2_TABLE_100
58: , a5 out nocopy JTF_NUMBER_TABLE
59: , a6 out nocopy JTF_NUMBER_TABLE
60: , a7 out nocopy JTF_VARCHAR2_TABLE_100
61: , a8 out nocopy JTF_VARCHAR2_TABLE_100
56: , a3 out nocopy JTF_NUMBER_TABLE
57: , a4 out nocopy JTF_VARCHAR2_TABLE_100
58: , a5 out nocopy JTF_NUMBER_TABLE
59: , a6 out nocopy JTF_NUMBER_TABLE
60: , a7 out nocopy JTF_VARCHAR2_TABLE_100
61: , a8 out nocopy JTF_VARCHAR2_TABLE_100
62: , a9 out nocopy JTF_VARCHAR2_TABLE_300
63: ) as
64: ddindx binary_integer; indx binary_integer;
57: , a4 out nocopy JTF_VARCHAR2_TABLE_100
58: , a5 out nocopy JTF_NUMBER_TABLE
59: , a6 out nocopy JTF_NUMBER_TABLE
60: , a7 out nocopy JTF_VARCHAR2_TABLE_100
61: , a8 out nocopy JTF_VARCHAR2_TABLE_100
62: , a9 out nocopy JTF_VARCHAR2_TABLE_300
63: ) as
64: ddindx binary_integer; indx binary_integer;
65: begin
63: ) as
64: ddindx binary_integer; indx binary_integer;
65: begin
66: if t is null or t.count = 0 then
67: a0 := JTF_VARCHAR2_TABLE_100();
68: a1 := JTF_DATE_TABLE();
69: a2 := JTF_DATE_TABLE();
70: a3 := JTF_NUMBER_TABLE();
71: a4 := JTF_VARCHAR2_TABLE_100();
67: a0 := JTF_VARCHAR2_TABLE_100();
68: a1 := JTF_DATE_TABLE();
69: a2 := JTF_DATE_TABLE();
70: a3 := JTF_NUMBER_TABLE();
71: a4 := JTF_VARCHAR2_TABLE_100();
72: a5 := JTF_NUMBER_TABLE();
73: a6 := JTF_NUMBER_TABLE();
74: a7 := JTF_VARCHAR2_TABLE_100();
75: a8 := JTF_VARCHAR2_TABLE_100();
70: a3 := JTF_NUMBER_TABLE();
71: a4 := JTF_VARCHAR2_TABLE_100();
72: a5 := JTF_NUMBER_TABLE();
73: a6 := JTF_NUMBER_TABLE();
74: a7 := JTF_VARCHAR2_TABLE_100();
75: a8 := JTF_VARCHAR2_TABLE_100();
76: a9 := JTF_VARCHAR2_TABLE_300();
77: else
78: a0 := JTF_VARCHAR2_TABLE_100();
71: a4 := JTF_VARCHAR2_TABLE_100();
72: a5 := JTF_NUMBER_TABLE();
73: a6 := JTF_NUMBER_TABLE();
74: a7 := JTF_VARCHAR2_TABLE_100();
75: a8 := JTF_VARCHAR2_TABLE_100();
76: a9 := JTF_VARCHAR2_TABLE_300();
77: else
78: a0 := JTF_VARCHAR2_TABLE_100();
79: a1 := JTF_DATE_TABLE();
74: a7 := JTF_VARCHAR2_TABLE_100();
75: a8 := JTF_VARCHAR2_TABLE_100();
76: a9 := JTF_VARCHAR2_TABLE_300();
77: else
78: a0 := JTF_VARCHAR2_TABLE_100();
79: a1 := JTF_DATE_TABLE();
80: a2 := JTF_DATE_TABLE();
81: a3 := JTF_NUMBER_TABLE();
82: a4 := JTF_VARCHAR2_TABLE_100();
78: a0 := JTF_VARCHAR2_TABLE_100();
79: a1 := JTF_DATE_TABLE();
80: a2 := JTF_DATE_TABLE();
81: a3 := JTF_NUMBER_TABLE();
82: a4 := JTF_VARCHAR2_TABLE_100();
83: a5 := JTF_NUMBER_TABLE();
84: a6 := JTF_NUMBER_TABLE();
85: a7 := JTF_VARCHAR2_TABLE_100();
86: a8 := JTF_VARCHAR2_TABLE_100();
81: a3 := JTF_NUMBER_TABLE();
82: a4 := JTF_VARCHAR2_TABLE_100();
83: a5 := JTF_NUMBER_TABLE();
84: a6 := JTF_NUMBER_TABLE();
85: a7 := JTF_VARCHAR2_TABLE_100();
86: a8 := JTF_VARCHAR2_TABLE_100();
87: a9 := JTF_VARCHAR2_TABLE_300();
88: if t.count > 0 then
89: a0.extend(t.count);
82: a4 := JTF_VARCHAR2_TABLE_100();
83: a5 := JTF_NUMBER_TABLE();
84: a6 := JTF_NUMBER_TABLE();
85: a7 := JTF_VARCHAR2_TABLE_100();
86: a8 := JTF_VARCHAR2_TABLE_100();
87: a9 := JTF_VARCHAR2_TABLE_300();
88: if t.count > 0 then
89: a0.extend(t.count);
90: a1.extend(t.count);
120: end rosetta_table_copy_out_p3;
121:
122: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 JTF_NUMBER_TABLE
123: , a1 JTF_NUMBER_TABLE
124: , a2 JTF_VARCHAR2_TABLE_100
125: , a3 JTF_VARCHAR2_TABLE_100
126: , a4 JTF_VARCHAR2_TABLE_100
127: , a5 JTF_VARCHAR2_TABLE_100
128: , a6 JTF_NUMBER_TABLE
121:
122: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 JTF_NUMBER_TABLE
123: , a1 JTF_NUMBER_TABLE
124: , a2 JTF_VARCHAR2_TABLE_100
125: , a3 JTF_VARCHAR2_TABLE_100
126: , a4 JTF_VARCHAR2_TABLE_100
127: , a5 JTF_VARCHAR2_TABLE_100
128: , a6 JTF_NUMBER_TABLE
129: , a7 JTF_NUMBER_TABLE
122: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 JTF_NUMBER_TABLE
123: , a1 JTF_NUMBER_TABLE
124: , a2 JTF_VARCHAR2_TABLE_100
125: , a3 JTF_VARCHAR2_TABLE_100
126: , a4 JTF_VARCHAR2_TABLE_100
127: , a5 JTF_VARCHAR2_TABLE_100
128: , a6 JTF_NUMBER_TABLE
129: , a7 JTF_NUMBER_TABLE
130: , a8 JTF_NUMBER_TABLE
123: , a1 JTF_NUMBER_TABLE
124: , a2 JTF_VARCHAR2_TABLE_100
125: , a3 JTF_VARCHAR2_TABLE_100
126: , a4 JTF_VARCHAR2_TABLE_100
127: , a5 JTF_VARCHAR2_TABLE_100
128: , a6 JTF_NUMBER_TABLE
129: , a7 JTF_NUMBER_TABLE
130: , a8 JTF_NUMBER_TABLE
131: ) as
155: end if;
156: end rosetta_table_copy_in_p4;
157: procedure rosetta_table_copy_out_p4(t ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 out nocopy JTF_NUMBER_TABLE
158: , a1 out nocopy JTF_NUMBER_TABLE
159: , a2 out nocopy JTF_VARCHAR2_TABLE_100
160: , a3 out nocopy JTF_VARCHAR2_TABLE_100
161: , a4 out nocopy JTF_VARCHAR2_TABLE_100
162: , a5 out nocopy JTF_VARCHAR2_TABLE_100
163: , a6 out nocopy JTF_NUMBER_TABLE
156: end rosetta_table_copy_in_p4;
157: procedure rosetta_table_copy_out_p4(t ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 out nocopy JTF_NUMBER_TABLE
158: , a1 out nocopy JTF_NUMBER_TABLE
159: , a2 out nocopy JTF_VARCHAR2_TABLE_100
160: , a3 out nocopy JTF_VARCHAR2_TABLE_100
161: , a4 out nocopy JTF_VARCHAR2_TABLE_100
162: , a5 out nocopy JTF_VARCHAR2_TABLE_100
163: , a6 out nocopy JTF_NUMBER_TABLE
164: , a7 out nocopy JTF_NUMBER_TABLE
157: procedure rosetta_table_copy_out_p4(t ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 out nocopy JTF_NUMBER_TABLE
158: , a1 out nocopy JTF_NUMBER_TABLE
159: , a2 out nocopy JTF_VARCHAR2_TABLE_100
160: , a3 out nocopy JTF_VARCHAR2_TABLE_100
161: , a4 out nocopy JTF_VARCHAR2_TABLE_100
162: , a5 out nocopy JTF_VARCHAR2_TABLE_100
163: , a6 out nocopy JTF_NUMBER_TABLE
164: , a7 out nocopy JTF_NUMBER_TABLE
165: , a8 out nocopy JTF_NUMBER_TABLE
158: , a1 out nocopy JTF_NUMBER_TABLE
159: , a2 out nocopy JTF_VARCHAR2_TABLE_100
160: , a3 out nocopy JTF_VARCHAR2_TABLE_100
161: , a4 out nocopy JTF_VARCHAR2_TABLE_100
162: , a5 out nocopy JTF_VARCHAR2_TABLE_100
163: , a6 out nocopy JTF_NUMBER_TABLE
164: , a7 out nocopy JTF_NUMBER_TABLE
165: , a8 out nocopy JTF_NUMBER_TABLE
166: ) as
168: begin
169: if t is null or t.count = 0 then
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_VARCHAR2_TABLE_100();
173: a3 := JTF_VARCHAR2_TABLE_100();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_VARCHAR2_TABLE_100();
176: a6 := JTF_NUMBER_TABLE();
169: if t is null or t.count = 0 then
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_VARCHAR2_TABLE_100();
173: a3 := JTF_VARCHAR2_TABLE_100();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_VARCHAR2_TABLE_100();
176: a6 := JTF_NUMBER_TABLE();
177: a7 := JTF_NUMBER_TABLE();
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_VARCHAR2_TABLE_100();
173: a3 := JTF_VARCHAR2_TABLE_100();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_VARCHAR2_TABLE_100();
176: a6 := JTF_NUMBER_TABLE();
177: a7 := JTF_NUMBER_TABLE();
178: a8 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_VARCHAR2_TABLE_100();
173: a3 := JTF_VARCHAR2_TABLE_100();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_VARCHAR2_TABLE_100();
176: a6 := JTF_NUMBER_TABLE();
177: a7 := JTF_NUMBER_TABLE();
178: a8 := JTF_NUMBER_TABLE();
179: else
178: a8 := JTF_NUMBER_TABLE();
179: else
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();
183: a3 := JTF_VARCHAR2_TABLE_100();
184: a4 := JTF_VARCHAR2_TABLE_100();
185: a5 := JTF_VARCHAR2_TABLE_100();
186: a6 := JTF_NUMBER_TABLE();
179: else
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();
183: a3 := JTF_VARCHAR2_TABLE_100();
184: a4 := JTF_VARCHAR2_TABLE_100();
185: a5 := JTF_VARCHAR2_TABLE_100();
186: a6 := JTF_NUMBER_TABLE();
187: a7 := JTF_NUMBER_TABLE();
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();
183: a3 := JTF_VARCHAR2_TABLE_100();
184: a4 := JTF_VARCHAR2_TABLE_100();
185: a5 := JTF_VARCHAR2_TABLE_100();
186: a6 := JTF_NUMBER_TABLE();
187: a7 := JTF_NUMBER_TABLE();
188: a8 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();
183: a3 := JTF_VARCHAR2_TABLE_100();
184: a4 := JTF_VARCHAR2_TABLE_100();
185: a5 := JTF_VARCHAR2_TABLE_100();
186: a6 := JTF_NUMBER_TABLE();
187: a7 := JTF_NUMBER_TABLE();
188: a8 := JTF_NUMBER_TABLE();
189: if t.count > 0 then
236: , p5_a10 NUMBER
237: , p5_a11 NUMBER
238: , p5_a12 VARCHAR2
239: , p5_a13 VARCHAR2
240: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
241: , p6_a1 out nocopy JTF_DATE_TABLE
242: , p6_a2 out nocopy JTF_DATE_TABLE
243: , p6_a3 out nocopy JTF_NUMBER_TABLE
244: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
240: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
241: , p6_a1 out nocopy JTF_DATE_TABLE
242: , p6_a2 out nocopy JTF_DATE_TABLE
243: , p6_a3 out nocopy JTF_NUMBER_TABLE
244: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a5 out nocopy JTF_NUMBER_TABLE
246: , p6_a6 out nocopy JTF_NUMBER_TABLE
247: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
243: , p6_a3 out nocopy JTF_NUMBER_TABLE
244: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a5 out nocopy JTF_NUMBER_TABLE
246: , p6_a6 out nocopy JTF_NUMBER_TABLE
247: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
249: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
250: , x_return_status out nocopy VARCHAR2
251: , x_msg_count out nocopy NUMBER
244: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a5 out nocopy JTF_NUMBER_TABLE
246: , p6_a6 out nocopy JTF_NUMBER_TABLE
247: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
249: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
250: , x_return_status out nocopy VARCHAR2
251: , x_msg_count out nocopy NUMBER
252: , x_msg_data out nocopy VARCHAR2
338: , p5_a12 VARCHAR2
339: , p5_a13 VARCHAR2
340: , p6_a0 out nocopy JTF_NUMBER_TABLE
341: , p6_a1 out nocopy JTF_NUMBER_TABLE
342: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
343: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
344: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
345: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a6 out nocopy JTF_NUMBER_TABLE
339: , p5_a13 VARCHAR2
340: , p6_a0 out nocopy JTF_NUMBER_TABLE
341: , p6_a1 out nocopy JTF_NUMBER_TABLE
342: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
343: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
344: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
345: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a6 out nocopy JTF_NUMBER_TABLE
347: , p6_a7 out nocopy JTF_NUMBER_TABLE
340: , p6_a0 out nocopy JTF_NUMBER_TABLE
341: , p6_a1 out nocopy JTF_NUMBER_TABLE
342: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
343: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
344: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
345: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a6 out nocopy JTF_NUMBER_TABLE
347: , p6_a7 out nocopy JTF_NUMBER_TABLE
348: , p6_a8 out nocopy JTF_NUMBER_TABLE
341: , p6_a1 out nocopy JTF_NUMBER_TABLE
342: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
343: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
344: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
345: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a6 out nocopy JTF_NUMBER_TABLE
347: , p6_a7 out nocopy JTF_NUMBER_TABLE
348: , p6_a8 out nocopy JTF_NUMBER_TABLE
349: , x_return_status out nocopy VARCHAR2