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_p1(t out nocopy ahl_rm_rt_oper_resource_pvt.rt_oper_resource_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_rm_rt_oper_resource_pvt.rt_oper_resource_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_rm_rt_oper_resource_pvt.rt_oper_resource_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_VARCHAR2_TABLE_100
33: , a17 JTF_NUMBER_TABLE
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_VARCHAR2_TABLE_100
33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_VARCHAR2_TABLE_100
35: , a19 JTF_NUMBER_TABLE
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_VARCHAR2_TABLE_100
33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_VARCHAR2_TABLE_100
35: , a19 JTF_NUMBER_TABLE
36: , a20 JTF_VARCHAR2_TABLE_100
37: , a21 JTF_NUMBER_TABLE
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_VARCHAR2_TABLE_100
33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_VARCHAR2_TABLE_100
35: , a19 JTF_NUMBER_TABLE
36: , a20 JTF_VARCHAR2_TABLE_100
37: , a21 JTF_NUMBER_TABLE
38: , a22 JTF_VARCHAR2_TABLE_100
39: , a23 JTF_VARCHAR2_TABLE_100
33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_VARCHAR2_TABLE_100
35: , a19 JTF_NUMBER_TABLE
36: , a20 JTF_VARCHAR2_TABLE_100
37: , a21 JTF_NUMBER_TABLE
38: , a22 JTF_VARCHAR2_TABLE_100
39: , a23 JTF_VARCHAR2_TABLE_100
40: , a24 JTF_VARCHAR2_TABLE_200
41: , a25 JTF_VARCHAR2_TABLE_200
52: , a36 JTF_VARCHAR2_TABLE_200
53: , a37 JTF_VARCHAR2_TABLE_200
54: , a38 JTF_VARCHAR2_TABLE_200
55: , a39 JTF_VARCHAR2_TABLE_100
56: , a40 JTF_NUMBER_TABLE
57: ) as
58: ddindx binary_integer; indx binary_integer;
59: begin
60: if a0 is not null and a0.count > 0 then
111: end loop;
112: end if;
113: end if;
114: end rosetta_table_copy_in_p1;
115: procedure rosetta_table_copy_out_p1(t ahl_rm_rt_oper_resource_pvt.rt_oper_resource_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_DATE_TABLE
118: , a3 out nocopy JTF_NUMBER_TABLE
119: , a4 out nocopy JTF_DATE_TABLE
112: end if;
113: end if;
114: end rosetta_table_copy_in_p1;
115: procedure rosetta_table_copy_out_p1(t ahl_rm_rt_oper_resource_pvt.rt_oper_resource_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_DATE_TABLE
118: , a3 out nocopy JTF_NUMBER_TABLE
119: , a4 out nocopy JTF_DATE_TABLE
120: , a5 out nocopy JTF_NUMBER_TABLE
114: end rosetta_table_copy_in_p1;
115: procedure rosetta_table_copy_out_p1(t ahl_rm_rt_oper_resource_pvt.rt_oper_resource_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_DATE_TABLE
118: , a3 out nocopy JTF_NUMBER_TABLE
119: , a4 out nocopy JTF_DATE_TABLE
120: , a5 out nocopy JTF_NUMBER_TABLE
121: , a6 out nocopy JTF_NUMBER_TABLE
122: , a7 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_DATE_TABLE
118: , a3 out nocopy JTF_NUMBER_TABLE
119: , a4 out nocopy JTF_DATE_TABLE
120: , a5 out nocopy JTF_NUMBER_TABLE
121: , a6 out nocopy JTF_NUMBER_TABLE
122: , a7 out nocopy JTF_NUMBER_TABLE
123: , a8 out nocopy JTF_VARCHAR2_TABLE_100
124: , a9 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_DATE_TABLE
118: , a3 out nocopy JTF_NUMBER_TABLE
119: , a4 out nocopy JTF_DATE_TABLE
120: , a5 out nocopy JTF_NUMBER_TABLE
121: , a6 out nocopy JTF_NUMBER_TABLE
122: , a7 out nocopy JTF_NUMBER_TABLE
123: , a8 out nocopy JTF_VARCHAR2_TABLE_100
124: , a9 out nocopy JTF_NUMBER_TABLE
125: , a10 out nocopy JTF_VARCHAR2_TABLE_100
118: , a3 out nocopy JTF_NUMBER_TABLE
119: , a4 out nocopy JTF_DATE_TABLE
120: , a5 out nocopy JTF_NUMBER_TABLE
121: , a6 out nocopy JTF_NUMBER_TABLE
122: , a7 out nocopy JTF_NUMBER_TABLE
123: , a8 out nocopy JTF_VARCHAR2_TABLE_100
124: , a9 out nocopy JTF_NUMBER_TABLE
125: , a10 out nocopy JTF_VARCHAR2_TABLE_100
126: , a11 out nocopy JTF_NUMBER_TABLE
120: , a5 out nocopy JTF_NUMBER_TABLE
121: , a6 out nocopy JTF_NUMBER_TABLE
122: , a7 out nocopy JTF_NUMBER_TABLE
123: , a8 out nocopy JTF_VARCHAR2_TABLE_100
124: , a9 out nocopy JTF_NUMBER_TABLE
125: , a10 out nocopy JTF_VARCHAR2_TABLE_100
126: , a11 out nocopy JTF_NUMBER_TABLE
127: , a12 out nocopy JTF_NUMBER_TABLE
128: , a13 out nocopy JTF_NUMBER_TABLE
122: , a7 out nocopy JTF_NUMBER_TABLE
123: , a8 out nocopy JTF_VARCHAR2_TABLE_100
124: , a9 out nocopy JTF_NUMBER_TABLE
125: , a10 out nocopy JTF_VARCHAR2_TABLE_100
126: , a11 out nocopy JTF_NUMBER_TABLE
127: , a12 out nocopy JTF_NUMBER_TABLE
128: , a13 out nocopy JTF_NUMBER_TABLE
129: , a14 out nocopy JTF_VARCHAR2_TABLE_100
130: , a15 out nocopy JTF_NUMBER_TABLE
123: , a8 out nocopy JTF_VARCHAR2_TABLE_100
124: , a9 out nocopy JTF_NUMBER_TABLE
125: , a10 out nocopy JTF_VARCHAR2_TABLE_100
126: , a11 out nocopy JTF_NUMBER_TABLE
127: , a12 out nocopy JTF_NUMBER_TABLE
128: , a13 out nocopy JTF_NUMBER_TABLE
129: , a14 out nocopy JTF_VARCHAR2_TABLE_100
130: , a15 out nocopy JTF_NUMBER_TABLE
131: , a16 out nocopy JTF_VARCHAR2_TABLE_100
124: , a9 out nocopy JTF_NUMBER_TABLE
125: , a10 out nocopy JTF_VARCHAR2_TABLE_100
126: , a11 out nocopy JTF_NUMBER_TABLE
127: , a12 out nocopy JTF_NUMBER_TABLE
128: , a13 out nocopy JTF_NUMBER_TABLE
129: , a14 out nocopy JTF_VARCHAR2_TABLE_100
130: , a15 out nocopy JTF_NUMBER_TABLE
131: , a16 out nocopy JTF_VARCHAR2_TABLE_100
132: , a17 out nocopy JTF_NUMBER_TABLE
126: , a11 out nocopy JTF_NUMBER_TABLE
127: , a12 out nocopy JTF_NUMBER_TABLE
128: , a13 out nocopy JTF_NUMBER_TABLE
129: , a14 out nocopy JTF_VARCHAR2_TABLE_100
130: , a15 out nocopy JTF_NUMBER_TABLE
131: , a16 out nocopy JTF_VARCHAR2_TABLE_100
132: , a17 out nocopy JTF_NUMBER_TABLE
133: , a18 out nocopy JTF_VARCHAR2_TABLE_100
134: , a19 out nocopy JTF_NUMBER_TABLE
128: , a13 out nocopy JTF_NUMBER_TABLE
129: , a14 out nocopy JTF_VARCHAR2_TABLE_100
130: , a15 out nocopy JTF_NUMBER_TABLE
131: , a16 out nocopy JTF_VARCHAR2_TABLE_100
132: , a17 out nocopy JTF_NUMBER_TABLE
133: , a18 out nocopy JTF_VARCHAR2_TABLE_100
134: , a19 out nocopy JTF_NUMBER_TABLE
135: , a20 out nocopy JTF_VARCHAR2_TABLE_100
136: , a21 out nocopy JTF_NUMBER_TABLE
130: , a15 out nocopy JTF_NUMBER_TABLE
131: , a16 out nocopy JTF_VARCHAR2_TABLE_100
132: , a17 out nocopy JTF_NUMBER_TABLE
133: , a18 out nocopy JTF_VARCHAR2_TABLE_100
134: , a19 out nocopy JTF_NUMBER_TABLE
135: , a20 out nocopy JTF_VARCHAR2_TABLE_100
136: , a21 out nocopy JTF_NUMBER_TABLE
137: , a22 out nocopy JTF_VARCHAR2_TABLE_100
138: , a23 out nocopy JTF_VARCHAR2_TABLE_100
132: , a17 out nocopy JTF_NUMBER_TABLE
133: , a18 out nocopy JTF_VARCHAR2_TABLE_100
134: , a19 out nocopy JTF_NUMBER_TABLE
135: , a20 out nocopy JTF_VARCHAR2_TABLE_100
136: , a21 out nocopy JTF_NUMBER_TABLE
137: , a22 out nocopy JTF_VARCHAR2_TABLE_100
138: , a23 out nocopy JTF_VARCHAR2_TABLE_100
139: , a24 out nocopy JTF_VARCHAR2_TABLE_200
140: , a25 out nocopy JTF_VARCHAR2_TABLE_200
151: , a36 out nocopy JTF_VARCHAR2_TABLE_200
152: , a37 out nocopy JTF_VARCHAR2_TABLE_200
153: , a38 out nocopy JTF_VARCHAR2_TABLE_200
154: , a39 out nocopy JTF_VARCHAR2_TABLE_100
155: , a40 out nocopy JTF_NUMBER_TABLE
156: ) as
157: ddindx binary_integer; indx binary_integer;
158: begin
159: if t is null or t.count = 0 then
156: ) as
157: ddindx binary_integer; indx binary_integer;
158: begin
159: if t is null or t.count = 0 then
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_NUMBER_TABLE();
162: a2 := JTF_DATE_TABLE();
163: a3 := JTF_NUMBER_TABLE();
164: a4 := JTF_DATE_TABLE();
157: ddindx binary_integer; indx binary_integer;
158: begin
159: if t is null or t.count = 0 then
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_NUMBER_TABLE();
162: a2 := JTF_DATE_TABLE();
163: a3 := JTF_NUMBER_TABLE();
164: a4 := JTF_DATE_TABLE();
165: a5 := JTF_NUMBER_TABLE();
159: if t is null or t.count = 0 then
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_NUMBER_TABLE();
162: a2 := JTF_DATE_TABLE();
163: a3 := JTF_NUMBER_TABLE();
164: a4 := JTF_DATE_TABLE();
165: a5 := JTF_NUMBER_TABLE();
166: a6 := JTF_NUMBER_TABLE();
167: a7 := JTF_NUMBER_TABLE();
161: a1 := JTF_NUMBER_TABLE();
162: a2 := JTF_DATE_TABLE();
163: a3 := JTF_NUMBER_TABLE();
164: a4 := JTF_DATE_TABLE();
165: a5 := JTF_NUMBER_TABLE();
166: a6 := JTF_NUMBER_TABLE();
167: a7 := JTF_NUMBER_TABLE();
168: a8 := JTF_VARCHAR2_TABLE_100();
169: a9 := JTF_NUMBER_TABLE();
162: a2 := JTF_DATE_TABLE();
163: a3 := JTF_NUMBER_TABLE();
164: a4 := JTF_DATE_TABLE();
165: a5 := JTF_NUMBER_TABLE();
166: a6 := JTF_NUMBER_TABLE();
167: a7 := JTF_NUMBER_TABLE();
168: a8 := JTF_VARCHAR2_TABLE_100();
169: a9 := JTF_NUMBER_TABLE();
170: a10 := JTF_VARCHAR2_TABLE_100();
163: a3 := JTF_NUMBER_TABLE();
164: a4 := JTF_DATE_TABLE();
165: a5 := JTF_NUMBER_TABLE();
166: a6 := JTF_NUMBER_TABLE();
167: a7 := JTF_NUMBER_TABLE();
168: a8 := JTF_VARCHAR2_TABLE_100();
169: a9 := JTF_NUMBER_TABLE();
170: a10 := JTF_VARCHAR2_TABLE_100();
171: a11 := JTF_NUMBER_TABLE();
165: a5 := JTF_NUMBER_TABLE();
166: a6 := JTF_NUMBER_TABLE();
167: a7 := JTF_NUMBER_TABLE();
168: a8 := JTF_VARCHAR2_TABLE_100();
169: a9 := JTF_NUMBER_TABLE();
170: a10 := JTF_VARCHAR2_TABLE_100();
171: a11 := JTF_NUMBER_TABLE();
172: a12 := JTF_NUMBER_TABLE();
173: a13 := JTF_NUMBER_TABLE();
167: a7 := JTF_NUMBER_TABLE();
168: a8 := JTF_VARCHAR2_TABLE_100();
169: a9 := JTF_NUMBER_TABLE();
170: a10 := JTF_VARCHAR2_TABLE_100();
171: a11 := JTF_NUMBER_TABLE();
172: a12 := JTF_NUMBER_TABLE();
173: a13 := JTF_NUMBER_TABLE();
174: a14 := JTF_VARCHAR2_TABLE_100();
175: a15 := JTF_NUMBER_TABLE();
168: a8 := JTF_VARCHAR2_TABLE_100();
169: a9 := JTF_NUMBER_TABLE();
170: a10 := JTF_VARCHAR2_TABLE_100();
171: a11 := JTF_NUMBER_TABLE();
172: a12 := JTF_NUMBER_TABLE();
173: a13 := JTF_NUMBER_TABLE();
174: a14 := JTF_VARCHAR2_TABLE_100();
175: a15 := JTF_NUMBER_TABLE();
176: a16 := JTF_VARCHAR2_TABLE_100();
169: a9 := JTF_NUMBER_TABLE();
170: a10 := JTF_VARCHAR2_TABLE_100();
171: a11 := JTF_NUMBER_TABLE();
172: a12 := JTF_NUMBER_TABLE();
173: a13 := JTF_NUMBER_TABLE();
174: a14 := JTF_VARCHAR2_TABLE_100();
175: a15 := JTF_NUMBER_TABLE();
176: a16 := JTF_VARCHAR2_TABLE_100();
177: a17 := JTF_NUMBER_TABLE();
171: a11 := JTF_NUMBER_TABLE();
172: a12 := JTF_NUMBER_TABLE();
173: a13 := JTF_NUMBER_TABLE();
174: a14 := JTF_VARCHAR2_TABLE_100();
175: a15 := JTF_NUMBER_TABLE();
176: a16 := JTF_VARCHAR2_TABLE_100();
177: a17 := JTF_NUMBER_TABLE();
178: a18 := JTF_VARCHAR2_TABLE_100();
179: a19 := JTF_NUMBER_TABLE();
173: a13 := JTF_NUMBER_TABLE();
174: a14 := JTF_VARCHAR2_TABLE_100();
175: a15 := JTF_NUMBER_TABLE();
176: a16 := JTF_VARCHAR2_TABLE_100();
177: a17 := JTF_NUMBER_TABLE();
178: a18 := JTF_VARCHAR2_TABLE_100();
179: a19 := JTF_NUMBER_TABLE();
180: a20 := JTF_VARCHAR2_TABLE_100();
181: a21 := JTF_NUMBER_TABLE();
175: a15 := JTF_NUMBER_TABLE();
176: a16 := JTF_VARCHAR2_TABLE_100();
177: a17 := JTF_NUMBER_TABLE();
178: a18 := JTF_VARCHAR2_TABLE_100();
179: a19 := JTF_NUMBER_TABLE();
180: a20 := JTF_VARCHAR2_TABLE_100();
181: a21 := JTF_NUMBER_TABLE();
182: a22 := JTF_VARCHAR2_TABLE_100();
183: a23 := JTF_VARCHAR2_TABLE_100();
177: a17 := JTF_NUMBER_TABLE();
178: a18 := JTF_VARCHAR2_TABLE_100();
179: a19 := JTF_NUMBER_TABLE();
180: a20 := JTF_VARCHAR2_TABLE_100();
181: a21 := JTF_NUMBER_TABLE();
182: a22 := JTF_VARCHAR2_TABLE_100();
183: a23 := JTF_VARCHAR2_TABLE_100();
184: a24 := JTF_VARCHAR2_TABLE_200();
185: a25 := JTF_VARCHAR2_TABLE_200();
196: a36 := JTF_VARCHAR2_TABLE_200();
197: a37 := JTF_VARCHAR2_TABLE_200();
198: a38 := JTF_VARCHAR2_TABLE_200();
199: a39 := JTF_VARCHAR2_TABLE_100();
200: a40 := JTF_NUMBER_TABLE();
201: else
202: a0 := JTF_NUMBER_TABLE();
203: a1 := JTF_NUMBER_TABLE();
204: a2 := JTF_DATE_TABLE();
198: a38 := JTF_VARCHAR2_TABLE_200();
199: a39 := JTF_VARCHAR2_TABLE_100();
200: a40 := JTF_NUMBER_TABLE();
201: else
202: a0 := JTF_NUMBER_TABLE();
203: a1 := JTF_NUMBER_TABLE();
204: a2 := JTF_DATE_TABLE();
205: a3 := JTF_NUMBER_TABLE();
206: a4 := JTF_DATE_TABLE();
199: a39 := JTF_VARCHAR2_TABLE_100();
200: a40 := JTF_NUMBER_TABLE();
201: else
202: a0 := JTF_NUMBER_TABLE();
203: a1 := JTF_NUMBER_TABLE();
204: a2 := JTF_DATE_TABLE();
205: a3 := JTF_NUMBER_TABLE();
206: a4 := JTF_DATE_TABLE();
207: a5 := JTF_NUMBER_TABLE();
201: else
202: a0 := JTF_NUMBER_TABLE();
203: a1 := JTF_NUMBER_TABLE();
204: a2 := JTF_DATE_TABLE();
205: a3 := JTF_NUMBER_TABLE();
206: a4 := JTF_DATE_TABLE();
207: a5 := JTF_NUMBER_TABLE();
208: a6 := JTF_NUMBER_TABLE();
209: a7 := JTF_NUMBER_TABLE();
203: a1 := JTF_NUMBER_TABLE();
204: a2 := JTF_DATE_TABLE();
205: a3 := JTF_NUMBER_TABLE();
206: a4 := JTF_DATE_TABLE();
207: a5 := JTF_NUMBER_TABLE();
208: a6 := JTF_NUMBER_TABLE();
209: a7 := JTF_NUMBER_TABLE();
210: a8 := JTF_VARCHAR2_TABLE_100();
211: a9 := JTF_NUMBER_TABLE();
204: a2 := JTF_DATE_TABLE();
205: a3 := JTF_NUMBER_TABLE();
206: a4 := JTF_DATE_TABLE();
207: a5 := JTF_NUMBER_TABLE();
208: a6 := JTF_NUMBER_TABLE();
209: a7 := JTF_NUMBER_TABLE();
210: a8 := JTF_VARCHAR2_TABLE_100();
211: a9 := JTF_NUMBER_TABLE();
212: a10 := JTF_VARCHAR2_TABLE_100();
205: a3 := JTF_NUMBER_TABLE();
206: a4 := JTF_DATE_TABLE();
207: a5 := JTF_NUMBER_TABLE();
208: a6 := JTF_NUMBER_TABLE();
209: a7 := JTF_NUMBER_TABLE();
210: a8 := JTF_VARCHAR2_TABLE_100();
211: a9 := JTF_NUMBER_TABLE();
212: a10 := JTF_VARCHAR2_TABLE_100();
213: a11 := JTF_NUMBER_TABLE();
207: a5 := JTF_NUMBER_TABLE();
208: a6 := JTF_NUMBER_TABLE();
209: a7 := JTF_NUMBER_TABLE();
210: a8 := JTF_VARCHAR2_TABLE_100();
211: a9 := JTF_NUMBER_TABLE();
212: a10 := JTF_VARCHAR2_TABLE_100();
213: a11 := JTF_NUMBER_TABLE();
214: a12 := JTF_NUMBER_TABLE();
215: a13 := JTF_NUMBER_TABLE();
209: a7 := JTF_NUMBER_TABLE();
210: a8 := JTF_VARCHAR2_TABLE_100();
211: a9 := JTF_NUMBER_TABLE();
212: a10 := JTF_VARCHAR2_TABLE_100();
213: a11 := JTF_NUMBER_TABLE();
214: a12 := JTF_NUMBER_TABLE();
215: a13 := JTF_NUMBER_TABLE();
216: a14 := JTF_VARCHAR2_TABLE_100();
217: a15 := JTF_NUMBER_TABLE();
210: a8 := JTF_VARCHAR2_TABLE_100();
211: a9 := JTF_NUMBER_TABLE();
212: a10 := JTF_VARCHAR2_TABLE_100();
213: a11 := JTF_NUMBER_TABLE();
214: a12 := JTF_NUMBER_TABLE();
215: a13 := JTF_NUMBER_TABLE();
216: a14 := JTF_VARCHAR2_TABLE_100();
217: a15 := JTF_NUMBER_TABLE();
218: a16 := JTF_VARCHAR2_TABLE_100();
211: a9 := JTF_NUMBER_TABLE();
212: a10 := JTF_VARCHAR2_TABLE_100();
213: a11 := JTF_NUMBER_TABLE();
214: a12 := JTF_NUMBER_TABLE();
215: a13 := JTF_NUMBER_TABLE();
216: a14 := JTF_VARCHAR2_TABLE_100();
217: a15 := JTF_NUMBER_TABLE();
218: a16 := JTF_VARCHAR2_TABLE_100();
219: a17 := JTF_NUMBER_TABLE();
213: a11 := JTF_NUMBER_TABLE();
214: a12 := JTF_NUMBER_TABLE();
215: a13 := JTF_NUMBER_TABLE();
216: a14 := JTF_VARCHAR2_TABLE_100();
217: a15 := JTF_NUMBER_TABLE();
218: a16 := JTF_VARCHAR2_TABLE_100();
219: a17 := JTF_NUMBER_TABLE();
220: a18 := JTF_VARCHAR2_TABLE_100();
221: a19 := JTF_NUMBER_TABLE();
215: a13 := JTF_NUMBER_TABLE();
216: a14 := JTF_VARCHAR2_TABLE_100();
217: a15 := JTF_NUMBER_TABLE();
218: a16 := JTF_VARCHAR2_TABLE_100();
219: a17 := JTF_NUMBER_TABLE();
220: a18 := JTF_VARCHAR2_TABLE_100();
221: a19 := JTF_NUMBER_TABLE();
222: a20 := JTF_VARCHAR2_TABLE_100();
223: a21 := JTF_NUMBER_TABLE();
217: a15 := JTF_NUMBER_TABLE();
218: a16 := JTF_VARCHAR2_TABLE_100();
219: a17 := JTF_NUMBER_TABLE();
220: a18 := JTF_VARCHAR2_TABLE_100();
221: a19 := JTF_NUMBER_TABLE();
222: a20 := JTF_VARCHAR2_TABLE_100();
223: a21 := JTF_NUMBER_TABLE();
224: a22 := JTF_VARCHAR2_TABLE_100();
225: a23 := JTF_VARCHAR2_TABLE_100();
219: a17 := JTF_NUMBER_TABLE();
220: a18 := JTF_VARCHAR2_TABLE_100();
221: a19 := JTF_NUMBER_TABLE();
222: a20 := JTF_VARCHAR2_TABLE_100();
223: a21 := JTF_NUMBER_TABLE();
224: a22 := JTF_VARCHAR2_TABLE_100();
225: a23 := JTF_VARCHAR2_TABLE_100();
226: a24 := JTF_VARCHAR2_TABLE_200();
227: a25 := JTF_VARCHAR2_TABLE_200();
238: a36 := JTF_VARCHAR2_TABLE_200();
239: a37 := JTF_VARCHAR2_TABLE_200();
240: a38 := JTF_VARCHAR2_TABLE_200();
241: a39 := JTF_VARCHAR2_TABLE_100();
242: a40 := JTF_NUMBER_TABLE();
243: if t.count > 0 then
244: a0.extend(t.count);
245: a1.extend(t.count);
246: a2.extend(t.count);
335: end if;
336: end if;
337: end rosetta_table_copy_out_p1;
338:
339: procedure rosetta_table_copy_in_p4(t out nocopy ahl_rm_rt_oper_resource_pvt.alt_resource_tbl_type, a0 JTF_NUMBER_TABLE
340: , a1 JTF_NUMBER_TABLE
341: , a2 JTF_DATE_TABLE
342: , a3 JTF_NUMBER_TABLE
343: , a4 JTF_DATE_TABLE
336: end if;
337: end rosetta_table_copy_out_p1;
338:
339: procedure rosetta_table_copy_in_p4(t out nocopy ahl_rm_rt_oper_resource_pvt.alt_resource_tbl_type, a0 JTF_NUMBER_TABLE
340: , a1 JTF_NUMBER_TABLE
341: , a2 JTF_DATE_TABLE
342: , a3 JTF_NUMBER_TABLE
343: , a4 JTF_DATE_TABLE
344: , a5 JTF_NUMBER_TABLE
338:
339: procedure rosetta_table_copy_in_p4(t out nocopy ahl_rm_rt_oper_resource_pvt.alt_resource_tbl_type, a0 JTF_NUMBER_TABLE
340: , a1 JTF_NUMBER_TABLE
341: , a2 JTF_DATE_TABLE
342: , a3 JTF_NUMBER_TABLE
343: , a4 JTF_DATE_TABLE
344: , a5 JTF_NUMBER_TABLE
345: , a6 JTF_NUMBER_TABLE
346: , a7 JTF_NUMBER_TABLE
340: , a1 JTF_NUMBER_TABLE
341: , a2 JTF_DATE_TABLE
342: , a3 JTF_NUMBER_TABLE
343: , a4 JTF_DATE_TABLE
344: , a5 JTF_NUMBER_TABLE
345: , a6 JTF_NUMBER_TABLE
346: , a7 JTF_NUMBER_TABLE
347: , a8 JTF_VARCHAR2_TABLE_100
348: , a9 JTF_NUMBER_TABLE
341: , a2 JTF_DATE_TABLE
342: , a3 JTF_NUMBER_TABLE
343: , a4 JTF_DATE_TABLE
344: , a5 JTF_NUMBER_TABLE
345: , a6 JTF_NUMBER_TABLE
346: , a7 JTF_NUMBER_TABLE
347: , a8 JTF_VARCHAR2_TABLE_100
348: , a9 JTF_NUMBER_TABLE
349: , a10 JTF_NUMBER_TABLE
342: , a3 JTF_NUMBER_TABLE
343: , a4 JTF_DATE_TABLE
344: , a5 JTF_NUMBER_TABLE
345: , a6 JTF_NUMBER_TABLE
346: , a7 JTF_NUMBER_TABLE
347: , a8 JTF_VARCHAR2_TABLE_100
348: , a9 JTF_NUMBER_TABLE
349: , a10 JTF_NUMBER_TABLE
350: , a11 JTF_VARCHAR2_TABLE_100
344: , a5 JTF_NUMBER_TABLE
345: , a6 JTF_NUMBER_TABLE
346: , a7 JTF_NUMBER_TABLE
347: , a8 JTF_VARCHAR2_TABLE_100
348: , a9 JTF_NUMBER_TABLE
349: , a10 JTF_NUMBER_TABLE
350: , a11 JTF_VARCHAR2_TABLE_100
351: , a12 JTF_VARCHAR2_TABLE_200
352: , a13 JTF_VARCHAR2_TABLE_200
345: , a6 JTF_NUMBER_TABLE
346: , a7 JTF_NUMBER_TABLE
347: , a8 JTF_VARCHAR2_TABLE_100
348: , a9 JTF_NUMBER_TABLE
349: , a10 JTF_NUMBER_TABLE
350: , a11 JTF_VARCHAR2_TABLE_100
351: , a12 JTF_VARCHAR2_TABLE_200
352: , a13 JTF_VARCHAR2_TABLE_200
353: , a14 JTF_VARCHAR2_TABLE_200
408: end loop;
409: end if;
410: end if;
411: end rosetta_table_copy_in_p4;
412: procedure rosetta_table_copy_out_p4(t ahl_rm_rt_oper_resource_pvt.alt_resource_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
413: , a1 out nocopy JTF_NUMBER_TABLE
414: , a2 out nocopy JTF_DATE_TABLE
415: , a3 out nocopy JTF_NUMBER_TABLE
416: , a4 out nocopy JTF_DATE_TABLE
409: end if;
410: end if;
411: end rosetta_table_copy_in_p4;
412: procedure rosetta_table_copy_out_p4(t ahl_rm_rt_oper_resource_pvt.alt_resource_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
413: , a1 out nocopy JTF_NUMBER_TABLE
414: , a2 out nocopy JTF_DATE_TABLE
415: , a3 out nocopy JTF_NUMBER_TABLE
416: , a4 out nocopy JTF_DATE_TABLE
417: , a5 out nocopy JTF_NUMBER_TABLE
411: end rosetta_table_copy_in_p4;
412: procedure rosetta_table_copy_out_p4(t ahl_rm_rt_oper_resource_pvt.alt_resource_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
413: , a1 out nocopy JTF_NUMBER_TABLE
414: , a2 out nocopy JTF_DATE_TABLE
415: , a3 out nocopy JTF_NUMBER_TABLE
416: , a4 out nocopy JTF_DATE_TABLE
417: , a5 out nocopy JTF_NUMBER_TABLE
418: , a6 out nocopy JTF_NUMBER_TABLE
419: , a7 out nocopy JTF_NUMBER_TABLE
413: , a1 out nocopy JTF_NUMBER_TABLE
414: , a2 out nocopy JTF_DATE_TABLE
415: , a3 out nocopy JTF_NUMBER_TABLE
416: , a4 out nocopy JTF_DATE_TABLE
417: , a5 out nocopy JTF_NUMBER_TABLE
418: , a6 out nocopy JTF_NUMBER_TABLE
419: , a7 out nocopy JTF_NUMBER_TABLE
420: , a8 out nocopy JTF_VARCHAR2_TABLE_100
421: , a9 out nocopy JTF_NUMBER_TABLE
414: , a2 out nocopy JTF_DATE_TABLE
415: , a3 out nocopy JTF_NUMBER_TABLE
416: , a4 out nocopy JTF_DATE_TABLE
417: , a5 out nocopy JTF_NUMBER_TABLE
418: , a6 out nocopy JTF_NUMBER_TABLE
419: , a7 out nocopy JTF_NUMBER_TABLE
420: , a8 out nocopy JTF_VARCHAR2_TABLE_100
421: , a9 out nocopy JTF_NUMBER_TABLE
422: , a10 out nocopy JTF_NUMBER_TABLE
415: , a3 out nocopy JTF_NUMBER_TABLE
416: , a4 out nocopy JTF_DATE_TABLE
417: , a5 out nocopy JTF_NUMBER_TABLE
418: , a6 out nocopy JTF_NUMBER_TABLE
419: , a7 out nocopy JTF_NUMBER_TABLE
420: , a8 out nocopy JTF_VARCHAR2_TABLE_100
421: , a9 out nocopy JTF_NUMBER_TABLE
422: , a10 out nocopy JTF_NUMBER_TABLE
423: , a11 out nocopy JTF_VARCHAR2_TABLE_100
417: , a5 out nocopy JTF_NUMBER_TABLE
418: , a6 out nocopy JTF_NUMBER_TABLE
419: , a7 out nocopy JTF_NUMBER_TABLE
420: , a8 out nocopy JTF_VARCHAR2_TABLE_100
421: , a9 out nocopy JTF_NUMBER_TABLE
422: , a10 out nocopy JTF_NUMBER_TABLE
423: , a11 out nocopy JTF_VARCHAR2_TABLE_100
424: , a12 out nocopy JTF_VARCHAR2_TABLE_200
425: , a13 out nocopy JTF_VARCHAR2_TABLE_200
418: , a6 out nocopy JTF_NUMBER_TABLE
419: , a7 out nocopy JTF_NUMBER_TABLE
420: , a8 out nocopy JTF_VARCHAR2_TABLE_100
421: , a9 out nocopy JTF_NUMBER_TABLE
422: , a10 out nocopy JTF_NUMBER_TABLE
423: , a11 out nocopy JTF_VARCHAR2_TABLE_100
424: , a12 out nocopy JTF_VARCHAR2_TABLE_200
425: , a13 out nocopy JTF_VARCHAR2_TABLE_200
426: , a14 out nocopy JTF_VARCHAR2_TABLE_200
440: ) as
441: ddindx binary_integer; indx binary_integer;
442: begin
443: if t is null or t.count = 0 then
444: a0 := JTF_NUMBER_TABLE();
445: a1 := JTF_NUMBER_TABLE();
446: a2 := JTF_DATE_TABLE();
447: a3 := JTF_NUMBER_TABLE();
448: a4 := JTF_DATE_TABLE();
441: ddindx binary_integer; indx binary_integer;
442: begin
443: if t is null or t.count = 0 then
444: a0 := JTF_NUMBER_TABLE();
445: a1 := JTF_NUMBER_TABLE();
446: a2 := JTF_DATE_TABLE();
447: a3 := JTF_NUMBER_TABLE();
448: a4 := JTF_DATE_TABLE();
449: a5 := JTF_NUMBER_TABLE();
443: if t is null or t.count = 0 then
444: a0 := JTF_NUMBER_TABLE();
445: a1 := JTF_NUMBER_TABLE();
446: a2 := JTF_DATE_TABLE();
447: a3 := JTF_NUMBER_TABLE();
448: a4 := JTF_DATE_TABLE();
449: a5 := JTF_NUMBER_TABLE();
450: a6 := JTF_NUMBER_TABLE();
451: a7 := JTF_NUMBER_TABLE();
445: a1 := JTF_NUMBER_TABLE();
446: a2 := JTF_DATE_TABLE();
447: a3 := JTF_NUMBER_TABLE();
448: a4 := JTF_DATE_TABLE();
449: a5 := JTF_NUMBER_TABLE();
450: a6 := JTF_NUMBER_TABLE();
451: a7 := JTF_NUMBER_TABLE();
452: a8 := JTF_VARCHAR2_TABLE_100();
453: a9 := JTF_NUMBER_TABLE();
446: a2 := JTF_DATE_TABLE();
447: a3 := JTF_NUMBER_TABLE();
448: a4 := JTF_DATE_TABLE();
449: a5 := JTF_NUMBER_TABLE();
450: a6 := JTF_NUMBER_TABLE();
451: a7 := JTF_NUMBER_TABLE();
452: a8 := JTF_VARCHAR2_TABLE_100();
453: a9 := JTF_NUMBER_TABLE();
454: a10 := JTF_NUMBER_TABLE();
447: a3 := JTF_NUMBER_TABLE();
448: a4 := JTF_DATE_TABLE();
449: a5 := JTF_NUMBER_TABLE();
450: a6 := JTF_NUMBER_TABLE();
451: a7 := JTF_NUMBER_TABLE();
452: a8 := JTF_VARCHAR2_TABLE_100();
453: a9 := JTF_NUMBER_TABLE();
454: a10 := JTF_NUMBER_TABLE();
455: a11 := JTF_VARCHAR2_TABLE_100();
449: a5 := JTF_NUMBER_TABLE();
450: a6 := JTF_NUMBER_TABLE();
451: a7 := JTF_NUMBER_TABLE();
452: a8 := JTF_VARCHAR2_TABLE_100();
453: a9 := JTF_NUMBER_TABLE();
454: a10 := JTF_NUMBER_TABLE();
455: a11 := JTF_VARCHAR2_TABLE_100();
456: a12 := JTF_VARCHAR2_TABLE_200();
457: a13 := JTF_VARCHAR2_TABLE_200();
450: a6 := JTF_NUMBER_TABLE();
451: a7 := JTF_NUMBER_TABLE();
452: a8 := JTF_VARCHAR2_TABLE_100();
453: a9 := JTF_NUMBER_TABLE();
454: a10 := JTF_NUMBER_TABLE();
455: a11 := JTF_VARCHAR2_TABLE_100();
456: a12 := JTF_VARCHAR2_TABLE_200();
457: a13 := JTF_VARCHAR2_TABLE_200();
458: a14 := JTF_VARCHAR2_TABLE_200();
469: a25 := JTF_VARCHAR2_TABLE_200();
470: a26 := JTF_VARCHAR2_TABLE_200();
471: a27 := JTF_VARCHAR2_TABLE_100();
472: else
473: a0 := JTF_NUMBER_TABLE();
474: a1 := JTF_NUMBER_TABLE();
475: a2 := JTF_DATE_TABLE();
476: a3 := JTF_NUMBER_TABLE();
477: a4 := JTF_DATE_TABLE();
470: a26 := JTF_VARCHAR2_TABLE_200();
471: a27 := JTF_VARCHAR2_TABLE_100();
472: else
473: a0 := JTF_NUMBER_TABLE();
474: a1 := JTF_NUMBER_TABLE();
475: a2 := JTF_DATE_TABLE();
476: a3 := JTF_NUMBER_TABLE();
477: a4 := JTF_DATE_TABLE();
478: a5 := JTF_NUMBER_TABLE();
472: else
473: a0 := JTF_NUMBER_TABLE();
474: a1 := JTF_NUMBER_TABLE();
475: a2 := JTF_DATE_TABLE();
476: a3 := JTF_NUMBER_TABLE();
477: a4 := JTF_DATE_TABLE();
478: a5 := JTF_NUMBER_TABLE();
479: a6 := JTF_NUMBER_TABLE();
480: a7 := JTF_NUMBER_TABLE();
474: a1 := JTF_NUMBER_TABLE();
475: a2 := JTF_DATE_TABLE();
476: a3 := JTF_NUMBER_TABLE();
477: a4 := JTF_DATE_TABLE();
478: a5 := JTF_NUMBER_TABLE();
479: a6 := JTF_NUMBER_TABLE();
480: a7 := JTF_NUMBER_TABLE();
481: a8 := JTF_VARCHAR2_TABLE_100();
482: a9 := JTF_NUMBER_TABLE();
475: a2 := JTF_DATE_TABLE();
476: a3 := JTF_NUMBER_TABLE();
477: a4 := JTF_DATE_TABLE();
478: a5 := JTF_NUMBER_TABLE();
479: a6 := JTF_NUMBER_TABLE();
480: a7 := JTF_NUMBER_TABLE();
481: a8 := JTF_VARCHAR2_TABLE_100();
482: a9 := JTF_NUMBER_TABLE();
483: a10 := JTF_NUMBER_TABLE();
476: a3 := JTF_NUMBER_TABLE();
477: a4 := JTF_DATE_TABLE();
478: a5 := JTF_NUMBER_TABLE();
479: a6 := JTF_NUMBER_TABLE();
480: a7 := JTF_NUMBER_TABLE();
481: a8 := JTF_VARCHAR2_TABLE_100();
482: a9 := JTF_NUMBER_TABLE();
483: a10 := JTF_NUMBER_TABLE();
484: a11 := JTF_VARCHAR2_TABLE_100();
478: a5 := JTF_NUMBER_TABLE();
479: a6 := JTF_NUMBER_TABLE();
480: a7 := JTF_NUMBER_TABLE();
481: a8 := JTF_VARCHAR2_TABLE_100();
482: a9 := JTF_NUMBER_TABLE();
483: a10 := JTF_NUMBER_TABLE();
484: a11 := JTF_VARCHAR2_TABLE_100();
485: a12 := JTF_VARCHAR2_TABLE_200();
486: a13 := JTF_VARCHAR2_TABLE_200();
479: a6 := JTF_NUMBER_TABLE();
480: a7 := JTF_NUMBER_TABLE();
481: a8 := JTF_VARCHAR2_TABLE_100();
482: a9 := JTF_NUMBER_TABLE();
483: a10 := JTF_NUMBER_TABLE();
484: a11 := JTF_VARCHAR2_TABLE_100();
485: a12 := JTF_VARCHAR2_TABLE_200();
486: a13 := JTF_VARCHAR2_TABLE_200();
487: a14 := JTF_VARCHAR2_TABLE_200();
576: , p_module_type VARCHAR2
577: , x_return_status out nocopy VARCHAR2
578: , x_msg_count out nocopy NUMBER
579: , x_msg_data out nocopy VARCHAR2
580: , p9_a0 in out nocopy JTF_NUMBER_TABLE
581: , p9_a1 in out nocopy JTF_NUMBER_TABLE
582: , p9_a2 in out nocopy JTF_DATE_TABLE
583: , p9_a3 in out nocopy JTF_NUMBER_TABLE
584: , p9_a4 in out nocopy JTF_DATE_TABLE
577: , x_return_status out nocopy VARCHAR2
578: , x_msg_count out nocopy NUMBER
579: , x_msg_data out nocopy VARCHAR2
580: , p9_a0 in out nocopy JTF_NUMBER_TABLE
581: , p9_a1 in out nocopy JTF_NUMBER_TABLE
582: , p9_a2 in out nocopy JTF_DATE_TABLE
583: , p9_a3 in out nocopy JTF_NUMBER_TABLE
584: , p9_a4 in out nocopy JTF_DATE_TABLE
585: , p9_a5 in out nocopy JTF_NUMBER_TABLE
579: , x_msg_data out nocopy VARCHAR2
580: , p9_a0 in out nocopy JTF_NUMBER_TABLE
581: , p9_a1 in out nocopy JTF_NUMBER_TABLE
582: , p9_a2 in out nocopy JTF_DATE_TABLE
583: , p9_a3 in out nocopy JTF_NUMBER_TABLE
584: , p9_a4 in out nocopy JTF_DATE_TABLE
585: , p9_a5 in out nocopy JTF_NUMBER_TABLE
586: , p9_a6 in out nocopy JTF_NUMBER_TABLE
587: , p9_a7 in out nocopy JTF_NUMBER_TABLE
581: , p9_a1 in out nocopy JTF_NUMBER_TABLE
582: , p9_a2 in out nocopy JTF_DATE_TABLE
583: , p9_a3 in out nocopy JTF_NUMBER_TABLE
584: , p9_a4 in out nocopy JTF_DATE_TABLE
585: , p9_a5 in out nocopy JTF_NUMBER_TABLE
586: , p9_a6 in out nocopy JTF_NUMBER_TABLE
587: , p9_a7 in out nocopy JTF_NUMBER_TABLE
588: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
589: , p9_a9 in out nocopy JTF_NUMBER_TABLE
582: , p9_a2 in out nocopy JTF_DATE_TABLE
583: , p9_a3 in out nocopy JTF_NUMBER_TABLE
584: , p9_a4 in out nocopy JTF_DATE_TABLE
585: , p9_a5 in out nocopy JTF_NUMBER_TABLE
586: , p9_a6 in out nocopy JTF_NUMBER_TABLE
587: , p9_a7 in out nocopy JTF_NUMBER_TABLE
588: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
589: , p9_a9 in out nocopy JTF_NUMBER_TABLE
590: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
583: , p9_a3 in out nocopy JTF_NUMBER_TABLE
584: , p9_a4 in out nocopy JTF_DATE_TABLE
585: , p9_a5 in out nocopy JTF_NUMBER_TABLE
586: , p9_a6 in out nocopy JTF_NUMBER_TABLE
587: , p9_a7 in out nocopy JTF_NUMBER_TABLE
588: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
589: , p9_a9 in out nocopy JTF_NUMBER_TABLE
590: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
591: , p9_a11 in out nocopy JTF_NUMBER_TABLE
585: , p9_a5 in out nocopy JTF_NUMBER_TABLE
586: , p9_a6 in out nocopy JTF_NUMBER_TABLE
587: , p9_a7 in out nocopy JTF_NUMBER_TABLE
588: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
589: , p9_a9 in out nocopy JTF_NUMBER_TABLE
590: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
591: , p9_a11 in out nocopy JTF_NUMBER_TABLE
592: , p9_a12 in out nocopy JTF_NUMBER_TABLE
593: , p9_a13 in out nocopy JTF_NUMBER_TABLE
587: , p9_a7 in out nocopy JTF_NUMBER_TABLE
588: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
589: , p9_a9 in out nocopy JTF_NUMBER_TABLE
590: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
591: , p9_a11 in out nocopy JTF_NUMBER_TABLE
592: , p9_a12 in out nocopy JTF_NUMBER_TABLE
593: , p9_a13 in out nocopy JTF_NUMBER_TABLE
594: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
595: , p9_a15 in out nocopy JTF_NUMBER_TABLE
588: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
589: , p9_a9 in out nocopy JTF_NUMBER_TABLE
590: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
591: , p9_a11 in out nocopy JTF_NUMBER_TABLE
592: , p9_a12 in out nocopy JTF_NUMBER_TABLE
593: , p9_a13 in out nocopy JTF_NUMBER_TABLE
594: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
595: , p9_a15 in out nocopy JTF_NUMBER_TABLE
596: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
589: , p9_a9 in out nocopy JTF_NUMBER_TABLE
590: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
591: , p9_a11 in out nocopy JTF_NUMBER_TABLE
592: , p9_a12 in out nocopy JTF_NUMBER_TABLE
593: , p9_a13 in out nocopy JTF_NUMBER_TABLE
594: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
595: , p9_a15 in out nocopy JTF_NUMBER_TABLE
596: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
597: , p9_a17 in out nocopy JTF_NUMBER_TABLE
591: , p9_a11 in out nocopy JTF_NUMBER_TABLE
592: , p9_a12 in out nocopy JTF_NUMBER_TABLE
593: , p9_a13 in out nocopy JTF_NUMBER_TABLE
594: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
595: , p9_a15 in out nocopy JTF_NUMBER_TABLE
596: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
597: , p9_a17 in out nocopy JTF_NUMBER_TABLE
598: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_100
599: , p9_a19 in out nocopy JTF_NUMBER_TABLE
593: , p9_a13 in out nocopy JTF_NUMBER_TABLE
594: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
595: , p9_a15 in out nocopy JTF_NUMBER_TABLE
596: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
597: , p9_a17 in out nocopy JTF_NUMBER_TABLE
598: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_100
599: , p9_a19 in out nocopy JTF_NUMBER_TABLE
600: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
601: , p9_a21 in out nocopy JTF_NUMBER_TABLE
595: , p9_a15 in out nocopy JTF_NUMBER_TABLE
596: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
597: , p9_a17 in out nocopy JTF_NUMBER_TABLE
598: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_100
599: , p9_a19 in out nocopy JTF_NUMBER_TABLE
600: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
601: , p9_a21 in out nocopy JTF_NUMBER_TABLE
602: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
603: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
597: , p9_a17 in out nocopy JTF_NUMBER_TABLE
598: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_100
599: , p9_a19 in out nocopy JTF_NUMBER_TABLE
600: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_100
601: , p9_a21 in out nocopy JTF_NUMBER_TABLE
602: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
603: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
604: , p9_a24 in out nocopy JTF_VARCHAR2_TABLE_200
605: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_200
616: , p9_a36 in out nocopy JTF_VARCHAR2_TABLE_200
617: , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_200
618: , p9_a38 in out nocopy JTF_VARCHAR2_TABLE_200
619: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100
620: , p9_a40 in out nocopy JTF_NUMBER_TABLE
621: , p_association_type_code VARCHAR2
622: , p_object_id NUMBER
623: )
624:
848: , x_return_status out nocopy VARCHAR2
849: , x_msg_count out nocopy NUMBER
850: , x_msg_data out nocopy VARCHAR2
851: , p_rt_oper_resource_id NUMBER
852: , p10_a0 in out nocopy JTF_NUMBER_TABLE
853: , p10_a1 in out nocopy JTF_NUMBER_TABLE
854: , p10_a2 in out nocopy JTF_DATE_TABLE
855: , p10_a3 in out nocopy JTF_NUMBER_TABLE
856: , p10_a4 in out nocopy JTF_DATE_TABLE
849: , x_msg_count out nocopy NUMBER
850: , x_msg_data out nocopy VARCHAR2
851: , p_rt_oper_resource_id NUMBER
852: , p10_a0 in out nocopy JTF_NUMBER_TABLE
853: , p10_a1 in out nocopy JTF_NUMBER_TABLE
854: , p10_a2 in out nocopy JTF_DATE_TABLE
855: , p10_a3 in out nocopy JTF_NUMBER_TABLE
856: , p10_a4 in out nocopy JTF_DATE_TABLE
857: , p10_a5 in out nocopy JTF_NUMBER_TABLE
851: , p_rt_oper_resource_id NUMBER
852: , p10_a0 in out nocopy JTF_NUMBER_TABLE
853: , p10_a1 in out nocopy JTF_NUMBER_TABLE
854: , p10_a2 in out nocopy JTF_DATE_TABLE
855: , p10_a3 in out nocopy JTF_NUMBER_TABLE
856: , p10_a4 in out nocopy JTF_DATE_TABLE
857: , p10_a5 in out nocopy JTF_NUMBER_TABLE
858: , p10_a6 in out nocopy JTF_NUMBER_TABLE
859: , p10_a7 in out nocopy JTF_NUMBER_TABLE
853: , p10_a1 in out nocopy JTF_NUMBER_TABLE
854: , p10_a2 in out nocopy JTF_DATE_TABLE
855: , p10_a3 in out nocopy JTF_NUMBER_TABLE
856: , p10_a4 in out nocopy JTF_DATE_TABLE
857: , p10_a5 in out nocopy JTF_NUMBER_TABLE
858: , p10_a6 in out nocopy JTF_NUMBER_TABLE
859: , p10_a7 in out nocopy JTF_NUMBER_TABLE
860: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
861: , p10_a9 in out nocopy JTF_NUMBER_TABLE
854: , p10_a2 in out nocopy JTF_DATE_TABLE
855: , p10_a3 in out nocopy JTF_NUMBER_TABLE
856: , p10_a4 in out nocopy JTF_DATE_TABLE
857: , p10_a5 in out nocopy JTF_NUMBER_TABLE
858: , p10_a6 in out nocopy JTF_NUMBER_TABLE
859: , p10_a7 in out nocopy JTF_NUMBER_TABLE
860: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
861: , p10_a9 in out nocopy JTF_NUMBER_TABLE
862: , p10_a10 in out nocopy JTF_NUMBER_TABLE
855: , p10_a3 in out nocopy JTF_NUMBER_TABLE
856: , p10_a4 in out nocopy JTF_DATE_TABLE
857: , p10_a5 in out nocopy JTF_NUMBER_TABLE
858: , p10_a6 in out nocopy JTF_NUMBER_TABLE
859: , p10_a7 in out nocopy JTF_NUMBER_TABLE
860: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
861: , p10_a9 in out nocopy JTF_NUMBER_TABLE
862: , p10_a10 in out nocopy JTF_NUMBER_TABLE
863: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_100
857: , p10_a5 in out nocopy JTF_NUMBER_TABLE
858: , p10_a6 in out nocopy JTF_NUMBER_TABLE
859: , p10_a7 in out nocopy JTF_NUMBER_TABLE
860: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
861: , p10_a9 in out nocopy JTF_NUMBER_TABLE
862: , p10_a10 in out nocopy JTF_NUMBER_TABLE
863: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_100
864: , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_200
865: , p10_a13 in out nocopy JTF_VARCHAR2_TABLE_200
858: , p10_a6 in out nocopy JTF_NUMBER_TABLE
859: , p10_a7 in out nocopy JTF_NUMBER_TABLE
860: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
861: , p10_a9 in out nocopy JTF_NUMBER_TABLE
862: , p10_a10 in out nocopy JTF_NUMBER_TABLE
863: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_100
864: , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_200
865: , p10_a13 in out nocopy JTF_VARCHAR2_TABLE_200
866: , p10_a14 in out nocopy JTF_VARCHAR2_TABLE_200