[Home] [Help]
PACKAGE: APPS.AHL_UC_INSTANCE_PVT_W
Source
1 package ahl_uc_instance_pvt_w as
2 /* $Header: AHLWUCIS.pls 120.1.12010000.4 2008/11/20 11:47:07 sathapli ship $ */
3 procedure rosetta_table_copy_in_p3(t out nocopy ahl_uc_instance_pvt.uc_child_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_VARCHAR2_TABLE_100
8 );
9 procedure rosetta_table_copy_out_p3(t ahl_uc_instance_pvt.uc_child_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
10 , a1 out nocopy JTF_NUMBER_TABLE
11 , a2 out nocopy JTF_NUMBER_TABLE
12 , a3 out nocopy JTF_VARCHAR2_TABLE_100
13 , a4 out nocopy JTF_VARCHAR2_TABLE_100
14 );
15
16 procedure rosetta_table_copy_in_p5(t out nocopy ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17 , a1 JTF_NUMBER_TABLE
18 , a2 JTF_NUMBER_TABLE
19 , a3 JTF_NUMBER_TABLE
20 , a4 JTF_NUMBER_TABLE
21 , a5 JTF_VARCHAR2_TABLE_100
22 , a6 JTF_VARCHAR2_TABLE_100
23 );
24 procedure rosetta_table_copy_out_p5(t ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
25 , a1 out nocopy JTF_NUMBER_TABLE
26 , a2 out nocopy JTF_NUMBER_TABLE
27 , a3 out nocopy JTF_NUMBER_TABLE
28 , a4 out nocopy JTF_NUMBER_TABLE
29 , a5 out nocopy JTF_VARCHAR2_TABLE_100
30 , a6 out nocopy JTF_VARCHAR2_TABLE_100
31 );
32
33 procedure rosetta_table_copy_in_p7(t out nocopy ahl_uc_instance_pvt.available_instance_tbl_type, a0 JTF_NUMBER_TABLE
34 , a1 JTF_NUMBER_TABLE
35 , a2 JTF_NUMBER_TABLE
36 , a3 JTF_NUMBER_TABLE
37 , a4 JTF_VARCHAR2_TABLE_100
38 , a5 JTF_VARCHAR2_TABLE_300
39 , a6 JTF_VARCHAR2_TABLE_300
40 , a7 JTF_VARCHAR2_TABLE_100
41 , a8 JTF_VARCHAR2_TABLE_100
42 , a9 JTF_VARCHAR2_TABLE_100
43 , a10 JTF_VARCHAR2_TABLE_100
44 , a11 JTF_VARCHAR2_TABLE_100
45 , a12 JTF_NUMBER_TABLE
46 , a13 JTF_NUMBER_TABLE
47 , a14 JTF_DATE_TABLE
48 , a15 JTF_DATE_TABLE
49 , a16 JTF_VARCHAR2_TABLE_4000
50 , a17 JTF_VARCHAR2_TABLE_100
51 , a18 JTF_NUMBER_TABLE
52 , a19 JTF_VARCHAR2_TABLE_400
53 , a20 JTF_VARCHAR2_TABLE_400
54 , a21 JTF_NUMBER_TABLE
55 , a22 JTF_VARCHAR2_TABLE_100
56 , a23 JTF_NUMBER_TABLE
57 , a24 JTF_VARCHAR2_TABLE_100
58 , a25 JTF_VARCHAR2_TABLE_300
59 , a26 JTF_NUMBER_TABLE
60 , a27 JTF_VARCHAR2_TABLE_100
61 , a28 JTF_VARCHAR2_TABLE_100
62 , a29 JTF_NUMBER_TABLE
63 , a30 JTF_VARCHAR2_TABLE_100
64 , a31 JTF_VARCHAR2_TABLE_100
65 , a32 JTF_VARCHAR2_TABLE_100
66 , a33 JTF_VARCHAR2_TABLE_100
67 , a34 JTF_VARCHAR2_TABLE_300
68 , a35 JTF_NUMBER_TABLE
69 , a36 JTF_VARCHAR2_TABLE_100
70 , a37 JTF_NUMBER_TABLE
71 , a38 JTF_VARCHAR2_TABLE_300
72 );
73 procedure rosetta_table_copy_out_p7(t ahl_uc_instance_pvt.available_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
74 , a1 out nocopy JTF_NUMBER_TABLE
75 , a2 out nocopy JTF_NUMBER_TABLE
76 , a3 out nocopy JTF_NUMBER_TABLE
77 , a4 out nocopy JTF_VARCHAR2_TABLE_100
78 , a5 out nocopy JTF_VARCHAR2_TABLE_300
79 , a6 out nocopy JTF_VARCHAR2_TABLE_300
80 , a7 out nocopy JTF_VARCHAR2_TABLE_100
81 , a8 out nocopy JTF_VARCHAR2_TABLE_100
82 , a9 out nocopy JTF_VARCHAR2_TABLE_100
83 , a10 out nocopy JTF_VARCHAR2_TABLE_100
84 , a11 out nocopy JTF_VARCHAR2_TABLE_100
85 , a12 out nocopy JTF_NUMBER_TABLE
86 , a13 out nocopy JTF_NUMBER_TABLE
87 , a14 out nocopy JTF_DATE_TABLE
88 , a15 out nocopy JTF_DATE_TABLE
89 , a16 out nocopy JTF_VARCHAR2_TABLE_4000
90 , a17 out nocopy JTF_VARCHAR2_TABLE_100
91 , a18 out nocopy JTF_NUMBER_TABLE
92 , a19 out nocopy JTF_VARCHAR2_TABLE_400
93 , a20 out nocopy JTF_VARCHAR2_TABLE_400
94 , a21 out nocopy JTF_NUMBER_TABLE
95 , a22 out nocopy JTF_VARCHAR2_TABLE_100
96 , a23 out nocopy JTF_NUMBER_TABLE
97 , a24 out nocopy JTF_VARCHAR2_TABLE_100
98 , a25 out nocopy JTF_VARCHAR2_TABLE_300
99 , a26 out nocopy JTF_NUMBER_TABLE
100 , a27 out nocopy JTF_VARCHAR2_TABLE_100
101 , a28 out nocopy JTF_VARCHAR2_TABLE_100
102 , a29 out nocopy JTF_NUMBER_TABLE
103 , a30 out nocopy JTF_VARCHAR2_TABLE_100
104 , a31 out nocopy JTF_VARCHAR2_TABLE_100
105 , a32 out nocopy JTF_VARCHAR2_TABLE_100
106 , a33 out nocopy JTF_VARCHAR2_TABLE_100
107 , a34 out nocopy JTF_VARCHAR2_TABLE_300
108 , a35 out nocopy JTF_NUMBER_TABLE
109 , a36 out nocopy JTF_VARCHAR2_TABLE_100
110 , a37 out nocopy JTF_NUMBER_TABLE
111 , a38 out nocopy JTF_VARCHAR2_TABLE_300
112 );
113
114 procedure update_instance_attr(p_api_version NUMBER
115 , p_init_msg_list VARCHAR2
116 , p_commit VARCHAR2
117 , p_validation_level NUMBER
118 , x_return_status out nocopy VARCHAR2
119 , x_msg_count out nocopy NUMBER
120 , x_msg_data out nocopy VARCHAR2
121 , p_uc_header_id NUMBER
122 , p8_a0 NUMBER
123 , p8_a1 NUMBER
124 , p8_a2 VARCHAR2
125 , p8_a3 VARCHAR2
126 , p8_a4 NUMBER
127 , p8_a5 VARCHAR2
128 , p8_a6 VARCHAR2
129 , p8_a7 VARCHAR2
130 , p8_a8 VARCHAR2
131 , p8_a9 VARCHAR2
132 , p8_a10 NUMBER
133 , p8_a11 VARCHAR2
134 , p8_a12 VARCHAR2
135 , p8_a13 DATE
136 , p8_a14 DATE
137 , p8_a15 NUMBER
138 , p8_a16 NUMBER
139 , p8_a17 VARCHAR2
140 , p8_a18 VARCHAR2
141 , p8_a19 VARCHAR2
142 , p8_a20 VARCHAR2
143 , p8_a21 VARCHAR2
144 , p8_a22 VARCHAR2
145 , p8_a23 VARCHAR2
146 , p8_a24 VARCHAR2
147 , p8_a25 VARCHAR2
148 , p8_a26 VARCHAR2
149 , p8_a27 VARCHAR2
150 , p8_a28 VARCHAR2
151 , p8_a29 VARCHAR2
152 , p8_a30 VARCHAR2
153 , p8_a31 VARCHAR2
154 , p8_a32 VARCHAR2
155 , p8_a33 VARCHAR2
156 , p8_a34 VARCHAR2
157 , p8_a35 VARCHAR2
158 , p8_a36 VARCHAR2
159 , p8_a37 VARCHAR2
160 , p8_a38 VARCHAR2
161 , p8_a39 VARCHAR2
162 , p8_a40 VARCHAR2
163 , p8_a41 VARCHAR2
164 , p8_a42 VARCHAR2
165 , p8_a43 VARCHAR2
166 , p8_a44 VARCHAR2
167 , p8_a45 VARCHAR2
168 , p8_a46 VARCHAR2
169 , p8_a47 VARCHAR2
170 , p_prod_user_flag VARCHAR2
171 );
172 procedure install_new_instance(p_api_version NUMBER
173 , p_init_msg_list VARCHAR2
174 , p_commit VARCHAR2
175 , p_validation_level NUMBER
176 , x_return_status out nocopy VARCHAR2
177 , x_msg_count out nocopy NUMBER
178 , x_msg_data out nocopy VARCHAR2
179 , p_uc_header_id NUMBER
180 , p_parent_instance_id NUMBER
181 , p_prod_user_flag VARCHAR2
182 , p10_a0 in out nocopy NUMBER
183 , p10_a1 in out nocopy NUMBER
184 , p10_a2 in out nocopy VARCHAR2
185 , p10_a3 in out nocopy VARCHAR2
186 , p10_a4 in out nocopy NUMBER
187 , p10_a5 in out nocopy VARCHAR2
188 , p10_a6 in out nocopy VARCHAR2
189 , p10_a7 in out nocopy VARCHAR2
190 , p10_a8 in out nocopy VARCHAR2
191 , p10_a9 in out nocopy VARCHAR2
192 , p10_a10 in out nocopy NUMBER
193 , p10_a11 in out nocopy VARCHAR2
194 , p10_a12 in out nocopy VARCHAR2
195 , p10_a13 in out nocopy DATE
196 , p10_a14 in out nocopy DATE
197 , p10_a15 in out nocopy NUMBER
198 , p10_a16 in out nocopy NUMBER
199 , p10_a17 in out nocopy VARCHAR2
200 , p10_a18 in out nocopy VARCHAR2
201 , p10_a19 in out nocopy VARCHAR2
202 , p10_a20 in out nocopy VARCHAR2
203 , p10_a21 in out nocopy VARCHAR2
204 , p10_a22 in out nocopy VARCHAR2
205 , p10_a23 in out nocopy VARCHAR2
206 , p10_a24 in out nocopy VARCHAR2
207 , p10_a25 in out nocopy VARCHAR2
208 , p10_a26 in out nocopy VARCHAR2
209 , p10_a27 in out nocopy VARCHAR2
210 , p10_a28 in out nocopy VARCHAR2
211 , p10_a29 in out nocopy VARCHAR2
212 , p10_a30 in out nocopy VARCHAR2
213 , p10_a31 in out nocopy VARCHAR2
214 , p10_a32 in out nocopy VARCHAR2
215 , p10_a33 in out nocopy VARCHAR2
216 , p10_a34 in out nocopy VARCHAR2
217 , p10_a35 in out nocopy VARCHAR2
218 , p10_a36 in out nocopy VARCHAR2
219 , p10_a37 in out nocopy VARCHAR2
220 , p10_a38 in out nocopy VARCHAR2
221 , p10_a39 in out nocopy VARCHAR2
222 , p10_a40 in out nocopy VARCHAR2
223 , p10_a41 in out nocopy VARCHAR2
224 , p10_a42 in out nocopy VARCHAR2
225 , p10_a43 in out nocopy VARCHAR2
226 , p10_a44 in out nocopy VARCHAR2
227 , p10_a45 in out nocopy VARCHAR2
228 , p10_a46 in out nocopy VARCHAR2
229 , p10_a47 in out nocopy VARCHAR2
230 , p11_a0 in out nocopy NUMBER
231 , p11_a1 in out nocopy VARCHAR2
232 , p11_a2 in out nocopy NUMBER
233 , p11_a3 in out nocopy VARCHAR2
234 , p11_a4 in out nocopy VARCHAR2
235 , p11_a5 in out nocopy NUMBER
236 , p11_a6 in out nocopy VARCHAR2
237 , p11_a7 in out nocopy VARCHAR2
238 , p11_a8 in out nocopy NUMBER
239 , p11_a9 in out nocopy VARCHAR2
240 , p11_a10 in out nocopy DATE
241 , p11_a11 in out nocopy DATE
242 , p11_a12 in out nocopy NUMBER
243 , p11_a13 in out nocopy VARCHAR2
244 , p11_a14 in out nocopy VARCHAR2
245 , p11_a15 in out nocopy VARCHAR2
246 , p11_a16 in out nocopy VARCHAR2
247 , p11_a17 in out nocopy VARCHAR2
248 , p11_a18 in out nocopy VARCHAR2
249 , p11_a19 in out nocopy VARCHAR2
250 , p11_a20 in out nocopy VARCHAR2
251 , p11_a21 in out nocopy VARCHAR2
252 , p11_a22 in out nocopy VARCHAR2
253 , p11_a23 in out nocopy VARCHAR2
254 , p11_a24 in out nocopy VARCHAR2
255 , p11_a25 in out nocopy VARCHAR2
256 , p11_a26 in out nocopy VARCHAR2
257 , p11_a27 in out nocopy VARCHAR2
258 , p11_a28 in out nocopy VARCHAR2
259 , x_warning_msg_tbl out nocopy JTF_VARCHAR2_TABLE_2000
260 );
261 procedure install_existing_instance(p_api_version NUMBER
262 , p_init_msg_list VARCHAR2
263 , p_commit VARCHAR2
264 , p_validation_level NUMBER
265 , x_return_status out nocopy VARCHAR2
266 , x_msg_count out nocopy NUMBER
267 , x_msg_data out nocopy VARCHAR2
268 , p_uc_header_id NUMBER
269 , p_parent_instance_id NUMBER
270 , p_instance_id NUMBER
271 , p_instance_number VARCHAR2
272 , p_relationship_id NUMBER
273 , p_csi_ii_ovn NUMBER
274 , p_prod_user_flag VARCHAR2
275 , x_warning_msg_tbl out nocopy JTF_VARCHAR2_TABLE_2000
276 );
277 procedure swap_instance(p_api_version NUMBER
278 , p_init_msg_list VARCHAR2
279 , p_commit VARCHAR2
280 , p_validation_level NUMBER
281 , x_return_status out nocopy VARCHAR2
282 , x_msg_count out nocopy NUMBER
283 , x_msg_data out nocopy VARCHAR2
284 , p_uc_header_id NUMBER
285 , p_parent_instance_id NUMBER
286 , p_old_instance_id NUMBER
287 , p_new_instance_id NUMBER
288 , p_new_instance_number VARCHAR2
289 , p_relationship_id NUMBER
290 , p_csi_ii_ovn NUMBER
291 , p_prod_user_flag VARCHAR2
292 , x_warning_msg_tbl out nocopy JTF_VARCHAR2_TABLE_2000
293 );
294 procedure get_available_instances(p_api_version NUMBER
295 , p_init_msg_list VARCHAR2
296 , p_validation_level NUMBER
297 , x_return_status out nocopy VARCHAR2
298 , x_msg_count out nocopy NUMBER
299 , x_msg_data out nocopy VARCHAR2
300 , p_parent_instance_id NUMBER
301 , p_relationship_id NUMBER
302 , p_item_number VARCHAR2
303 , p_serial_number VARCHAR2
304 , p_instance_number VARCHAR2
305 , p_workorder_id NUMBER
306 , p_start_row_index NUMBER
307 , p_max_rows NUMBER
308 , p14_a0 out nocopy JTF_NUMBER_TABLE
309 , p14_a1 out nocopy JTF_NUMBER_TABLE
310 , p14_a2 out nocopy JTF_NUMBER_TABLE
311 , p14_a3 out nocopy JTF_NUMBER_TABLE
312 , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
313 , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300
314 , p14_a6 out nocopy JTF_VARCHAR2_TABLE_300
315 , p14_a7 out nocopy JTF_VARCHAR2_TABLE_100
316 , p14_a8 out nocopy JTF_VARCHAR2_TABLE_100
317 , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100
318 , p14_a10 out nocopy JTF_VARCHAR2_TABLE_100
319 , p14_a11 out nocopy JTF_VARCHAR2_TABLE_100
320 , p14_a12 out nocopy JTF_NUMBER_TABLE
321 , p14_a13 out nocopy JTF_NUMBER_TABLE
322 , p14_a14 out nocopy JTF_DATE_TABLE
323 , p14_a15 out nocopy JTF_DATE_TABLE
324 , p14_a16 out nocopy JTF_VARCHAR2_TABLE_4000
325 , p14_a17 out nocopy JTF_VARCHAR2_TABLE_100
326 , p14_a18 out nocopy JTF_NUMBER_TABLE
327 , p14_a19 out nocopy JTF_VARCHAR2_TABLE_400
328 , p14_a20 out nocopy JTF_VARCHAR2_TABLE_400
329 , p14_a21 out nocopy JTF_NUMBER_TABLE
330 , p14_a22 out nocopy JTF_VARCHAR2_TABLE_100
331 , p14_a23 out nocopy JTF_NUMBER_TABLE
332 , p14_a24 out nocopy JTF_VARCHAR2_TABLE_100
333 , p14_a25 out nocopy JTF_VARCHAR2_TABLE_300
334 , p14_a26 out nocopy JTF_NUMBER_TABLE
335 , p14_a27 out nocopy JTF_VARCHAR2_TABLE_100
336 , p14_a28 out nocopy JTF_VARCHAR2_TABLE_100
337 , p14_a29 out nocopy JTF_NUMBER_TABLE
338 , p14_a30 out nocopy JTF_VARCHAR2_TABLE_100
339 , p14_a31 out nocopy JTF_VARCHAR2_TABLE_100
340 , p14_a32 out nocopy JTF_VARCHAR2_TABLE_100
341 , p14_a33 out nocopy JTF_VARCHAR2_TABLE_100
342 , p14_a34 out nocopy JTF_VARCHAR2_TABLE_300
343 , p14_a35 out nocopy JTF_NUMBER_TABLE
344 , p14_a36 out nocopy JTF_VARCHAR2_TABLE_100
345 , p14_a37 out nocopy JTF_NUMBER_TABLE
346 , p14_a38 out nocopy JTF_VARCHAR2_TABLE_300
347 , x_tbl_count out nocopy NUMBER
348 );
349 procedure get_avail_subinv_instances(p_api_version NUMBER
350 , p_init_msg_list VARCHAR2
351 , p_validation_level NUMBER
352 , x_return_status out nocopy VARCHAR2
353 , x_msg_count out nocopy NUMBER
354 , x_msg_data out nocopy VARCHAR2
355 , p_relationship_id NUMBER
356 , p_item_number VARCHAR2
357 , p_serial_number VARCHAR2
358 , p_instance_number VARCHAR2
359 , p_workorder_id NUMBER
360 , p_start_row_index NUMBER
361 , p_max_rows NUMBER
362 , p13_a0 out nocopy JTF_NUMBER_TABLE
363 , p13_a1 out nocopy JTF_NUMBER_TABLE
364 , p13_a2 out nocopy JTF_NUMBER_TABLE
365 , p13_a3 out nocopy JTF_NUMBER_TABLE
366 , p13_a4 out nocopy JTF_VARCHAR2_TABLE_100
367 , p13_a5 out nocopy JTF_VARCHAR2_TABLE_300
368 , p13_a6 out nocopy JTF_VARCHAR2_TABLE_300
369 , p13_a7 out nocopy JTF_VARCHAR2_TABLE_100
370 , p13_a8 out nocopy JTF_VARCHAR2_TABLE_100
371 , p13_a9 out nocopy JTF_VARCHAR2_TABLE_100
372 , p13_a10 out nocopy JTF_VARCHAR2_TABLE_100
373 , p13_a11 out nocopy JTF_VARCHAR2_TABLE_100
374 , p13_a12 out nocopy JTF_NUMBER_TABLE
375 , p13_a13 out nocopy JTF_NUMBER_TABLE
376 , p13_a14 out nocopy JTF_DATE_TABLE
377 , p13_a15 out nocopy JTF_DATE_TABLE
378 , p13_a16 out nocopy JTF_VARCHAR2_TABLE_4000
379 , p13_a17 out nocopy JTF_VARCHAR2_TABLE_100
380 , p13_a18 out nocopy JTF_NUMBER_TABLE
381 , p13_a19 out nocopy JTF_VARCHAR2_TABLE_400
382 , p13_a20 out nocopy JTF_VARCHAR2_TABLE_400
383 , p13_a21 out nocopy JTF_NUMBER_TABLE
384 , p13_a22 out nocopy JTF_VARCHAR2_TABLE_100
385 , p13_a23 out nocopy JTF_NUMBER_TABLE
386 , p13_a24 out nocopy JTF_VARCHAR2_TABLE_100
387 , p13_a25 out nocopy JTF_VARCHAR2_TABLE_300
388 , p13_a26 out nocopy JTF_NUMBER_TABLE
389 , p13_a27 out nocopy JTF_VARCHAR2_TABLE_100
390 , p13_a28 out nocopy JTF_VARCHAR2_TABLE_100
391 , p13_a29 out nocopy JTF_NUMBER_TABLE
392 , p13_a30 out nocopy JTF_VARCHAR2_TABLE_100
393 , p13_a31 out nocopy JTF_VARCHAR2_TABLE_100
394 , p13_a32 out nocopy JTF_VARCHAR2_TABLE_100
395 , p13_a33 out nocopy JTF_VARCHAR2_TABLE_100
396 , p13_a34 out nocopy JTF_VARCHAR2_TABLE_300
397 , p13_a35 out nocopy JTF_NUMBER_TABLE
398 , p13_a36 out nocopy JTF_VARCHAR2_TABLE_100
399 , p13_a37 out nocopy JTF_NUMBER_TABLE
400 , p13_a38 out nocopy JTF_VARCHAR2_TABLE_300
401 );
402 procedure create_unassigned_instance(p_api_version NUMBER
403 , p_init_msg_list VARCHAR2
404 , p_commit VARCHAR2
405 , p_validation_level NUMBER
406 , x_return_status out nocopy VARCHAR2
407 , x_msg_count out nocopy NUMBER
408 , x_msg_data out nocopy VARCHAR2
409 , p_uc_header_id NUMBER
410 , p8_a0 in out nocopy NUMBER
411 , p8_a1 in out nocopy NUMBER
412 , p8_a2 in out nocopy VARCHAR2
413 , p8_a3 in out nocopy VARCHAR2
414 , p8_a4 in out nocopy NUMBER
415 , p8_a5 in out nocopy VARCHAR2
416 , p8_a6 in out nocopy VARCHAR2
417 , p8_a7 in out nocopy VARCHAR2
418 , p8_a8 in out nocopy VARCHAR2
419 , p8_a9 in out nocopy VARCHAR2
420 , p8_a10 in out nocopy NUMBER
421 , p8_a11 in out nocopy VARCHAR2
422 , p8_a12 in out nocopy VARCHAR2
423 , p8_a13 in out nocopy DATE
424 , p8_a14 in out nocopy DATE
425 , p8_a15 in out nocopy NUMBER
426 , p8_a16 in out nocopy NUMBER
427 , p8_a17 in out nocopy VARCHAR2
428 , p8_a18 in out nocopy VARCHAR2
429 , p8_a19 in out nocopy VARCHAR2
430 , p8_a20 in out nocopy VARCHAR2
431 , p8_a21 in out nocopy VARCHAR2
432 , p8_a22 in out nocopy VARCHAR2
433 , p8_a23 in out nocopy VARCHAR2
434 , p8_a24 in out nocopy VARCHAR2
435 , p8_a25 in out nocopy VARCHAR2
436 , p8_a26 in out nocopy VARCHAR2
437 , p8_a27 in out nocopy VARCHAR2
438 , p8_a28 in out nocopy VARCHAR2
439 , p8_a29 in out nocopy VARCHAR2
440 , p8_a30 in out nocopy VARCHAR2
441 , p8_a31 in out nocopy VARCHAR2
442 , p8_a32 in out nocopy VARCHAR2
443 , p8_a33 in out nocopy VARCHAR2
444 , p8_a34 in out nocopy VARCHAR2
445 , p8_a35 in out nocopy VARCHAR2
446 , p8_a36 in out nocopy VARCHAR2
447 , p8_a37 in out nocopy VARCHAR2
448 , p8_a38 in out nocopy VARCHAR2
449 , p8_a39 in out nocopy VARCHAR2
450 , p8_a40 in out nocopy VARCHAR2
451 , p8_a41 in out nocopy VARCHAR2
452 , p8_a42 in out nocopy VARCHAR2
453 , p8_a43 in out nocopy VARCHAR2
454 , p8_a44 in out nocopy VARCHAR2
455 , p8_a45 in out nocopy VARCHAR2
456 , p8_a46 in out nocopy VARCHAR2
457 , p8_a47 in out nocopy VARCHAR2
458 );
459 end ahl_uc_instance_pvt_w;