[Home] [Help]
PACKAGE: APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT_W
Source
1 package ahl_prd_blk_parts_change_pvt_w AUTHID CURRENT_USER as
2 /* $Header: AHLWBPCS.pls 120.0.12020000.2 2012/12/11 05:52:21 prakkum noship $ */
3 procedure rosetta_table_copy_in_p5(t out nocopy ahl_prd_blk_parts_change_pvt.uc_details_hgrid_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_VARCHAR2_TABLE_300
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_VARCHAR2_TABLE_300
16 , a13 JTF_NUMBER_TABLE
17 , a14 JTF_VARCHAR2_TABLE_100
18 , a15 JTF_VARCHAR2_TABLE_100
19 , a16 JTF_VARCHAR2_TABLE_100
20 , a17 JTF_NUMBER_TABLE
21 , a18 JTF_VARCHAR2_TABLE_100
22 , a19 JTF_VARCHAR2_TABLE_100
23 , a20 JTF_VARCHAR2_TABLE_300
24 , a21 JTF_VARCHAR2_TABLE_100
25 , a22 JTF_VARCHAR2_TABLE_100
26 , a23 JTF_VARCHAR2_TABLE_100
27 , a24 JTF_VARCHAR2_TABLE_100
28 , a25 JTF_NUMBER_TABLE
29 , a26 JTF_NUMBER_TABLE
30 , a27 JTF_NUMBER_TABLE
31 , a28 JTF_VARCHAR2_TABLE_300
32 , a29 JTF_VARCHAR2_TABLE_100
33 , a30 JTF_VARCHAR2_TABLE_100
34 , a31 JTF_NUMBER_TABLE
35 , a32 JTF_NUMBER_TABLE
36 , a33 JTF_NUMBER_TABLE
37 , a34 JTF_DATE_TABLE
38 , a35 JTF_DATE_TABLE
39 , a36 JTF_NUMBER_TABLE
40 , a37 JTF_VARCHAR2_TABLE_100
41 , a38 JTF_VARCHAR2_TABLE_100
42 , a39 JTF_VARCHAR2_TABLE_100
43 , a40 JTF_VARCHAR2_TABLE_100
44 , a41 JTF_NUMBER_TABLE
45 , a42 JTF_VARCHAR2_TABLE_300
46 , a43 JTF_VARCHAR2_TABLE_100
47 , a44 JTF_VARCHAR2_TABLE_100
48 , a45 JTF_NUMBER_TABLE
49 , a46 JTF_NUMBER_TABLE
50 , a47 JTF_VARCHAR2_TABLE_100
51 , a48 JTF_NUMBER_TABLE
52 , a49 JTF_VARCHAR2_TABLE_2000
53 , a50 JTF_VARCHAR2_TABLE_100
54 , a51 JTF_VARCHAR2_TABLE_200
55 , a52 JTF_VARCHAR2_TABLE_100
56 , a53 JTF_VARCHAR2_TABLE_200
57 , a54 JTF_NUMBER_TABLE
58 , a55 JTF_NUMBER_TABLE
59 , a56 JTF_NUMBER_TABLE
60 , a57 JTF_VARCHAR2_TABLE_200
61 , a58 JTF_VARCHAR2_TABLE_100
62 , a59 JTF_VARCHAR2_TABLE_100
63 , a60 JTF_NUMBER_TABLE
64 , a61 JTF_VARCHAR2_TABLE_100
65 , a62 JTF_VARCHAR2_TABLE_100
66 , a63 JTF_VARCHAR2_TABLE_100
67 , a64 JTF_NUMBER_TABLE
68 , a65 JTF_VARCHAR2_TABLE_100
69 , a66 JTF_VARCHAR2_TABLE_100
70 , a67 JTF_VARCHAR2_TABLE_300
71 , a68 JTF_NUMBER_TABLE
72 , a69 JTF_VARCHAR2_TABLE_100
73 , a70 JTF_VARCHAR2_TABLE_100
74 , a71 JTF_VARCHAR2_TABLE_100
75 );
76 procedure rosetta_table_copy_out_p5(t ahl_prd_blk_parts_change_pvt.uc_details_hgrid_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
77 , a1 out nocopy JTF_NUMBER_TABLE
78 , a2 out nocopy JTF_NUMBER_TABLE
79 , a3 out nocopy JTF_NUMBER_TABLE
80 , a4 out nocopy JTF_NUMBER_TABLE
81 , a5 out nocopy JTF_NUMBER_TABLE
82 , a6 out nocopy JTF_VARCHAR2_TABLE_300
83 , a7 out nocopy JTF_NUMBER_TABLE
84 , a8 out nocopy JTF_NUMBER_TABLE
85 , a9 out nocopy JTF_NUMBER_TABLE
86 , a10 out nocopy JTF_NUMBER_TABLE
87 , a11 out nocopy JTF_NUMBER_TABLE
88 , a12 out nocopy JTF_VARCHAR2_TABLE_300
89 , a13 out nocopy JTF_NUMBER_TABLE
90 , a14 out nocopy JTF_VARCHAR2_TABLE_100
91 , a15 out nocopy JTF_VARCHAR2_TABLE_100
92 , a16 out nocopy JTF_VARCHAR2_TABLE_100
93 , a17 out nocopy JTF_NUMBER_TABLE
94 , a18 out nocopy JTF_VARCHAR2_TABLE_100
95 , a19 out nocopy JTF_VARCHAR2_TABLE_100
96 , a20 out nocopy JTF_VARCHAR2_TABLE_300
97 , a21 out nocopy JTF_VARCHAR2_TABLE_100
98 , a22 out nocopy JTF_VARCHAR2_TABLE_100
99 , a23 out nocopy JTF_VARCHAR2_TABLE_100
100 , a24 out nocopy JTF_VARCHAR2_TABLE_100
101 , a25 out nocopy JTF_NUMBER_TABLE
102 , a26 out nocopy JTF_NUMBER_TABLE
103 , a27 out nocopy JTF_NUMBER_TABLE
104 , a28 out nocopy JTF_VARCHAR2_TABLE_300
105 , a29 out nocopy JTF_VARCHAR2_TABLE_100
106 , a30 out nocopy JTF_VARCHAR2_TABLE_100
107 , a31 out nocopy JTF_NUMBER_TABLE
108 , a32 out nocopy JTF_NUMBER_TABLE
109 , a33 out nocopy JTF_NUMBER_TABLE
110 , a34 out nocopy JTF_DATE_TABLE
111 , a35 out nocopy JTF_DATE_TABLE
112 , a36 out nocopy JTF_NUMBER_TABLE
113 , a37 out nocopy JTF_VARCHAR2_TABLE_100
114 , a38 out nocopy JTF_VARCHAR2_TABLE_100
115 , a39 out nocopy JTF_VARCHAR2_TABLE_100
116 , a40 out nocopy JTF_VARCHAR2_TABLE_100
117 , a41 out nocopy JTF_NUMBER_TABLE
118 , a42 out nocopy JTF_VARCHAR2_TABLE_300
119 , a43 out nocopy JTF_VARCHAR2_TABLE_100
120 , a44 out nocopy JTF_VARCHAR2_TABLE_100
121 , a45 out nocopy JTF_NUMBER_TABLE
122 , a46 out nocopy JTF_NUMBER_TABLE
123 , a47 out nocopy JTF_VARCHAR2_TABLE_100
124 , a48 out nocopy JTF_NUMBER_TABLE
125 , a49 out nocopy JTF_VARCHAR2_TABLE_2000
126 , a50 out nocopy JTF_VARCHAR2_TABLE_100
127 , a51 out nocopy JTF_VARCHAR2_TABLE_200
128 , a52 out nocopy JTF_VARCHAR2_TABLE_100
129 , a53 out nocopy JTF_VARCHAR2_TABLE_200
130 , a54 out nocopy JTF_NUMBER_TABLE
131 , a55 out nocopy JTF_NUMBER_TABLE
132 , a56 out nocopy JTF_NUMBER_TABLE
133 , a57 out nocopy JTF_VARCHAR2_TABLE_200
134 , a58 out nocopy JTF_VARCHAR2_TABLE_100
135 , a59 out nocopy JTF_VARCHAR2_TABLE_100
136 , a60 out nocopy JTF_NUMBER_TABLE
137 , a61 out nocopy JTF_VARCHAR2_TABLE_100
138 , a62 out nocopy JTF_VARCHAR2_TABLE_100
139 , a63 out nocopy JTF_VARCHAR2_TABLE_100
140 , a64 out nocopy JTF_NUMBER_TABLE
141 , a65 out nocopy JTF_VARCHAR2_TABLE_100
142 , a66 out nocopy JTF_VARCHAR2_TABLE_100
143 , a67 out nocopy JTF_VARCHAR2_TABLE_300
144 , a68 out nocopy JTF_NUMBER_TABLE
145 , a69 out nocopy JTF_VARCHAR2_TABLE_100
146 , a70 out nocopy JTF_VARCHAR2_TABLE_100
147 , a71 out nocopy JTF_VARCHAR2_TABLE_100
148 );
149
150 procedure rosetta_table_copy_in_p8(t out nocopy ahl_prd_blk_parts_change_pvt.filter_records_tbl_type, a0 JTF_VARCHAR2_TABLE_100
151 , a1 JTF_VARCHAR2_TABLE_300
152 );
153 procedure rosetta_table_copy_out_p8(t ahl_prd_blk_parts_change_pvt.filter_records_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
154 , a1 out nocopy JTF_VARCHAR2_TABLE_300
155 );
156
157 procedure rosetta_table_copy_in_p12(t out nocopy ahl_prd_blk_parts_change_pvt.part_change_tbl_type, a0 JTF_NUMBER_TABLE
158 , a1 JTF_NUMBER_TABLE
159 , a2 JTF_NUMBER_TABLE
160 , a3 JTF_VARCHAR2_TABLE_100
161 , a4 JTF_NUMBER_TABLE
162 , a5 JTF_NUMBER_TABLE
163 , a6 JTF_NUMBER_TABLE
164 , a7 JTF_NUMBER_TABLE
165 , a8 JTF_NUMBER_TABLE
166 , a9 JTF_VARCHAR2_TABLE_100
167 , a10 JTF_NUMBER_TABLE
168 , a11 JTF_VARCHAR2_TABLE_100
169 , a12 JTF_NUMBER_TABLE
170 , a13 JTF_NUMBER_TABLE
171 , a14 JTF_DATE_TABLE
172 , a15 JTF_NUMBER_TABLE
173 , a16 JTF_VARCHAR2_TABLE_100
174 , a17 JTF_NUMBER_TABLE
175 , a18 JTF_NUMBER_TABLE
176 , a19 JTF_VARCHAR2_TABLE_100
177 , a20 JTF_VARCHAR2_TABLE_100
178 , a21 JTF_NUMBER_TABLE
179 , a22 JTF_VARCHAR2_TABLE_100
180 , a23 JTF_DATE_TABLE
181 , a24 JTF_NUMBER_TABLE
182 , a25 JTF_VARCHAR2_TABLE_100
183 , a26 JTF_NUMBER_TABLE
184 , a27 JTF_VARCHAR2_TABLE_100
185 , a28 JTF_VARCHAR2_TABLE_100
186 , a29 JTF_VARCHAR2_TABLE_100
187 , a30 JTF_VARCHAR2_TABLE_100
188 , a31 JTF_VARCHAR2_TABLE_100
189 , a32 JTF_VARCHAR2_TABLE_300
190 , a33 JTF_NUMBER_TABLE
191 , a34 JTF_VARCHAR2_TABLE_100
192 , a35 JTF_VARCHAR2_TABLE_100
193 , a36 JTF_VARCHAR2_TABLE_100
194 , a37 JTF_VARCHAR2_TABLE_100
195 , a38 JTF_NUMBER_TABLE
196 , a39 JTF_NUMBER_TABLE
197 , a40 JTF_VARCHAR2_TABLE_100
198 , a41 JTF_VARCHAR2_TABLE_100
199 , a42 JTF_VARCHAR2_TABLE_100
200 , a43 JTF_VARCHAR2_TABLE_100
201 , a44 JTF_VARCHAR2_TABLE_100
202 , a45 JTF_VARCHAR2_TABLE_2000
203 , a46 JTF_NUMBER_TABLE
204 , a47 JTF_NUMBER_TABLE
205 , a48 JTF_NUMBER_TABLE
206 );
207 procedure rosetta_table_copy_out_p12(t ahl_prd_blk_parts_change_pvt.part_change_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
208 , a1 out nocopy JTF_NUMBER_TABLE
209 , a2 out nocopy JTF_NUMBER_TABLE
210 , a3 out nocopy JTF_VARCHAR2_TABLE_100
211 , a4 out nocopy JTF_NUMBER_TABLE
212 , a5 out nocopy JTF_NUMBER_TABLE
213 , a6 out nocopy JTF_NUMBER_TABLE
214 , a7 out nocopy JTF_NUMBER_TABLE
215 , a8 out nocopy JTF_NUMBER_TABLE
216 , a9 out nocopy JTF_VARCHAR2_TABLE_100
217 , a10 out nocopy JTF_NUMBER_TABLE
218 , a11 out nocopy JTF_VARCHAR2_TABLE_100
219 , a12 out nocopy JTF_NUMBER_TABLE
220 , a13 out nocopy JTF_NUMBER_TABLE
221 , a14 out nocopy JTF_DATE_TABLE
222 , a15 out nocopy JTF_NUMBER_TABLE
223 , a16 out nocopy JTF_VARCHAR2_TABLE_100
224 , a17 out nocopy JTF_NUMBER_TABLE
225 , a18 out nocopy JTF_NUMBER_TABLE
226 , a19 out nocopy JTF_VARCHAR2_TABLE_100
227 , a20 out nocopy JTF_VARCHAR2_TABLE_100
228 , a21 out nocopy JTF_NUMBER_TABLE
229 , a22 out nocopy JTF_VARCHAR2_TABLE_100
230 , a23 out nocopy JTF_DATE_TABLE
231 , a24 out nocopy JTF_NUMBER_TABLE
232 , a25 out nocopy JTF_VARCHAR2_TABLE_100
233 , a26 out nocopy JTF_NUMBER_TABLE
234 , a27 out nocopy JTF_VARCHAR2_TABLE_100
235 , a28 out nocopy JTF_VARCHAR2_TABLE_100
236 , a29 out nocopy JTF_VARCHAR2_TABLE_100
237 , a30 out nocopy JTF_VARCHAR2_TABLE_100
238 , a31 out nocopy JTF_VARCHAR2_TABLE_100
239 , a32 out nocopy JTF_VARCHAR2_TABLE_300
240 , a33 out nocopy JTF_NUMBER_TABLE
241 , a34 out nocopy JTF_VARCHAR2_TABLE_100
242 , a35 out nocopy JTF_VARCHAR2_TABLE_100
243 , a36 out nocopy JTF_VARCHAR2_TABLE_100
244 , a37 out nocopy JTF_VARCHAR2_TABLE_100
245 , a38 out nocopy JTF_NUMBER_TABLE
246 , a39 out nocopy JTF_NUMBER_TABLE
247 , a40 out nocopy JTF_VARCHAR2_TABLE_100
248 , a41 out nocopy JTF_VARCHAR2_TABLE_100
249 , a42 out nocopy JTF_VARCHAR2_TABLE_100
250 , a43 out nocopy JTF_VARCHAR2_TABLE_100
251 , a44 out nocopy JTF_VARCHAR2_TABLE_100
252 , a45 out nocopy JTF_VARCHAR2_TABLE_2000
253 , a46 out nocopy JTF_NUMBER_TABLE
254 , a47 out nocopy JTF_NUMBER_TABLE
255 , a48 out nocopy JTF_NUMBER_TABLE
256 );
257
258 procedure rosetta_table_copy_in_p14(t out nocopy ahl_prd_blk_parts_change_pvt.error_msg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
259 , a1 JTF_VARCHAR2_TABLE_4000
260 );
261 procedure rosetta_table_copy_out_p14(t ahl_prd_blk_parts_change_pvt.error_msg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
262 , a1 out nocopy JTF_VARCHAR2_TABLE_4000
263 );
264
265 procedure get_bulk_part_chg_details(p_api_version NUMBER
266 , p_init_msg_list VARCHAR2
267 , p_commit VARCHAR2
268 , p_validation_level NUMBER
269 , p_default VARCHAR2
270 , p_module_type VARCHAR2
271 , p_workorder_id NUMBER
272 , p_bulk_process_flag VARCHAR2
273 , p8_a0 out nocopy JTF_NUMBER_TABLE
274 , p8_a1 out nocopy JTF_NUMBER_TABLE
275 , p8_a2 out nocopy JTF_NUMBER_TABLE
276 , p8_a3 out nocopy JTF_NUMBER_TABLE
277 , p8_a4 out nocopy JTF_NUMBER_TABLE
278 , p8_a5 out nocopy JTF_NUMBER_TABLE
279 , p8_a6 out nocopy JTF_VARCHAR2_TABLE_300
280 , p8_a7 out nocopy JTF_NUMBER_TABLE
281 , p8_a8 out nocopy JTF_NUMBER_TABLE
282 , p8_a9 out nocopy JTF_NUMBER_TABLE
283 , p8_a10 out nocopy JTF_NUMBER_TABLE
284 , p8_a11 out nocopy JTF_NUMBER_TABLE
285 , p8_a12 out nocopy JTF_VARCHAR2_TABLE_300
286 , p8_a13 out nocopy JTF_NUMBER_TABLE
287 , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
288 , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
289 , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
290 , p8_a17 out nocopy JTF_NUMBER_TABLE
291 , p8_a18 out nocopy JTF_VARCHAR2_TABLE_100
292 , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100
293 , p8_a20 out nocopy JTF_VARCHAR2_TABLE_300
294 , p8_a21 out nocopy JTF_VARCHAR2_TABLE_100
295 , p8_a22 out nocopy JTF_VARCHAR2_TABLE_100
296 , p8_a23 out nocopy JTF_VARCHAR2_TABLE_100
297 , p8_a24 out nocopy JTF_VARCHAR2_TABLE_100
298 , p8_a25 out nocopy JTF_NUMBER_TABLE
299 , p8_a26 out nocopy JTF_NUMBER_TABLE
300 , p8_a27 out nocopy JTF_NUMBER_TABLE
301 , p8_a28 out nocopy JTF_VARCHAR2_TABLE_300
302 , p8_a29 out nocopy JTF_VARCHAR2_TABLE_100
303 , p8_a30 out nocopy JTF_VARCHAR2_TABLE_100
304 , p8_a31 out nocopy JTF_NUMBER_TABLE
305 , p8_a32 out nocopy JTF_NUMBER_TABLE
306 , p8_a33 out nocopy JTF_NUMBER_TABLE
307 , p8_a34 out nocopy JTF_DATE_TABLE
308 , p8_a35 out nocopy JTF_DATE_TABLE
309 , p8_a36 out nocopy JTF_NUMBER_TABLE
310 , p8_a37 out nocopy JTF_VARCHAR2_TABLE_100
311 , p8_a38 out nocopy JTF_VARCHAR2_TABLE_100
312 , p8_a39 out nocopy JTF_VARCHAR2_TABLE_100
313 , p8_a40 out nocopy JTF_VARCHAR2_TABLE_100
314 , p8_a41 out nocopy JTF_NUMBER_TABLE
315 , p8_a42 out nocopy JTF_VARCHAR2_TABLE_300
316 , p8_a43 out nocopy JTF_VARCHAR2_TABLE_100
317 , p8_a44 out nocopy JTF_VARCHAR2_TABLE_100
318 , p8_a45 out nocopy JTF_NUMBER_TABLE
319 , p8_a46 out nocopy JTF_NUMBER_TABLE
320 , p8_a47 out nocopy JTF_VARCHAR2_TABLE_100
321 , p8_a48 out nocopy JTF_NUMBER_TABLE
322 , p8_a49 out nocopy JTF_VARCHAR2_TABLE_2000
323 , p8_a50 out nocopy JTF_VARCHAR2_TABLE_100
324 , p8_a51 out nocopy JTF_VARCHAR2_TABLE_200
325 , p8_a52 out nocopy JTF_VARCHAR2_TABLE_100
326 , p8_a53 out nocopy JTF_VARCHAR2_TABLE_200
327 , p8_a54 out nocopy JTF_NUMBER_TABLE
328 , p8_a55 out nocopy JTF_NUMBER_TABLE
329 , p8_a56 out nocopy JTF_NUMBER_TABLE
330 , p8_a57 out nocopy JTF_VARCHAR2_TABLE_200
331 , p8_a58 out nocopy JTF_VARCHAR2_TABLE_100
332 , p8_a59 out nocopy JTF_VARCHAR2_TABLE_100
333 , p8_a60 out nocopy JTF_NUMBER_TABLE
334 , p8_a61 out nocopy JTF_VARCHAR2_TABLE_100
335 , p8_a62 out nocopy JTF_VARCHAR2_TABLE_100
336 , p8_a63 out nocopy JTF_VARCHAR2_TABLE_100
337 , p8_a64 out nocopy JTF_NUMBER_TABLE
338 , p8_a65 out nocopy JTF_VARCHAR2_TABLE_100
339 , p8_a66 out nocopy JTF_VARCHAR2_TABLE_100
340 , p8_a67 out nocopy JTF_VARCHAR2_TABLE_300
341 , p8_a68 out nocopy JTF_NUMBER_TABLE
342 , p8_a69 out nocopy JTF_VARCHAR2_TABLE_100
343 , p8_a70 out nocopy JTF_VARCHAR2_TABLE_100
344 , p8_a71 out nocopy JTF_VARCHAR2_TABLE_100
345 , x_return_status out nocopy VARCHAR2
346 , x_msg_count out nocopy NUMBER
347 , x_msg_data out nocopy VARCHAR2
348 );
349 procedure filter_records_uc_details(p_api_version NUMBER
350 , p_init_msg_list VARCHAR2
351 , p_commit VARCHAR2
352 , p_validation_level NUMBER
353 , p_default VARCHAR2
354 , p_module_type VARCHAR2
355 , p6_a0 JTF_VARCHAR2_TABLE_100
356 , p6_a1 JTF_VARCHAR2_TABLE_300
357 , x_hgrid_node_path out nocopy VARCHAR2
358 , x_return_status out nocopy VARCHAR2
359 , x_msg_count out nocopy NUMBER
360 , x_msg_data out nocopy VARCHAR2
361 );
362 procedure calc_qty_on_inst_selection(p0_a0 in out nocopy NUMBER
363 , p0_a1 in out nocopy NUMBER
364 , p0_a2 in out nocopy NUMBER
365 , p0_a3 in out nocopy NUMBER
366 , p0_a4 in out nocopy NUMBER
367 , p0_a5 in out nocopy NUMBER
368 , p0_a6 in out nocopy VARCHAR2
369 , p0_a7 in out nocopy NUMBER
370 , p0_a8 in out nocopy NUMBER
371 , p0_a9 in out nocopy NUMBER
372 , p0_a10 in out nocopy NUMBER
373 , p0_a11 in out nocopy NUMBER
374 , p0_a12 in out nocopy VARCHAR2
375 , p0_a13 in out nocopy NUMBER
376 , p0_a14 in out nocopy VARCHAR2
377 , p0_a15 in out nocopy VARCHAR2
378 , p0_a16 in out nocopy VARCHAR2
379 , p0_a17 in out nocopy NUMBER
380 , p0_a18 in out nocopy VARCHAR2
381 , p0_a19 in out nocopy VARCHAR2
382 , p0_a20 in out nocopy VARCHAR2
383 , p0_a21 in out nocopy VARCHAR2
384 , p0_a22 in out nocopy VARCHAR2
385 , p0_a23 in out nocopy VARCHAR2
386 , p0_a24 in out nocopy VARCHAR2
387 , p0_a25 in out nocopy NUMBER
388 , p0_a26 in out nocopy NUMBER
389 , p0_a27 in out nocopy NUMBER
390 , p0_a28 in out nocopy VARCHAR2
391 , p0_a29 in out nocopy VARCHAR2
392 , p0_a30 in out nocopy VARCHAR2
393 , p0_a31 in out nocopy NUMBER
394 , p0_a32 in out nocopy NUMBER
395 , p0_a33 in out nocopy NUMBER
396 , p0_a34 in out nocopy DATE
397 , p0_a35 in out nocopy DATE
398 , p0_a36 in out nocopy NUMBER
399 , p0_a37 in out nocopy VARCHAR2
400 , p0_a38 in out nocopy VARCHAR2
401 , p0_a39 in out nocopy VARCHAR2
402 , p0_a40 in out nocopy VARCHAR2
403 , p0_a41 in out nocopy NUMBER
404 , p0_a42 in out nocopy VARCHAR2
405 , p0_a43 in out nocopy VARCHAR2
406 , p0_a44 in out nocopy VARCHAR2
407 , p0_a45 in out nocopy NUMBER
408 , p0_a46 in out nocopy NUMBER
409 , p0_a47 in out nocopy VARCHAR2
410 , p0_a48 in out nocopy NUMBER
411 , p0_a49 in out nocopy VARCHAR2
412 , p0_a50 in out nocopy VARCHAR2
413 , p0_a51 in out nocopy VARCHAR2
414 , p0_a52 in out nocopy VARCHAR2
415 , p0_a53 in out nocopy VARCHAR2
416 , p0_a54 in out nocopy NUMBER
417 , p0_a55 in out nocopy NUMBER
418 , p0_a56 in out nocopy NUMBER
419 , p0_a57 in out nocopy VARCHAR2
420 , p0_a58 in out nocopy VARCHAR2
421 , p0_a59 in out nocopy VARCHAR2
422 , p0_a60 in out nocopy NUMBER
423 , p0_a61 in out nocopy VARCHAR2
424 , p0_a62 in out nocopy VARCHAR2
425 , p0_a63 in out nocopy VARCHAR2
426 , p0_a64 in out nocopy NUMBER
427 , p0_a65 in out nocopy VARCHAR2
428 , p0_a66 in out nocopy VARCHAR2
429 , p0_a67 in out nocopy VARCHAR2
430 , p0_a68 in out nocopy NUMBER
431 , p0_a69 in out nocopy VARCHAR2
432 , p0_a70 in out nocopy VARCHAR2
433 , p0_a71 in out nocopy VARCHAR2
434 );
435 procedure process_part_changes(p_api_version NUMBER
436 , p_init_msg_list VARCHAR2
437 , p_commit VARCHAR2
438 , p_validation_level NUMBER
439 , p_module_type VARCHAR2
440 , p_default VARCHAR2
441 , p6_a0 in out nocopy JTF_NUMBER_TABLE
442 , p6_a1 in out nocopy JTF_NUMBER_TABLE
443 , p6_a2 in out nocopy JTF_NUMBER_TABLE
444 , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_100
445 , p6_a4 in out nocopy JTF_NUMBER_TABLE
446 , p6_a5 in out nocopy JTF_NUMBER_TABLE
447 , p6_a6 in out nocopy JTF_NUMBER_TABLE
448 , p6_a7 in out nocopy JTF_NUMBER_TABLE
449 , p6_a8 in out nocopy JTF_NUMBER_TABLE
450 , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_100
451 , p6_a10 in out nocopy JTF_NUMBER_TABLE
452 , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_100
453 , p6_a12 in out nocopy JTF_NUMBER_TABLE
454 , p6_a13 in out nocopy JTF_NUMBER_TABLE
455 , p6_a14 in out nocopy JTF_DATE_TABLE
456 , p6_a15 in out nocopy JTF_NUMBER_TABLE
457 , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_100
458 , p6_a17 in out nocopy JTF_NUMBER_TABLE
459 , p6_a18 in out nocopy JTF_NUMBER_TABLE
460 , p6_a19 in out nocopy JTF_VARCHAR2_TABLE_100
461 , p6_a20 in out nocopy JTF_VARCHAR2_TABLE_100
462 , p6_a21 in out nocopy JTF_NUMBER_TABLE
463 , p6_a22 in out nocopy JTF_VARCHAR2_TABLE_100
464 , p6_a23 in out nocopy JTF_DATE_TABLE
465 , p6_a24 in out nocopy JTF_NUMBER_TABLE
466 , p6_a25 in out nocopy JTF_VARCHAR2_TABLE_100
467 , p6_a26 in out nocopy JTF_NUMBER_TABLE
468 , p6_a27 in out nocopy JTF_VARCHAR2_TABLE_100
469 , p6_a28 in out nocopy JTF_VARCHAR2_TABLE_100
470 , p6_a29 in out nocopy JTF_VARCHAR2_TABLE_100
471 , p6_a30 in out nocopy JTF_VARCHAR2_TABLE_100
472 , p6_a31 in out nocopy JTF_VARCHAR2_TABLE_100
473 , p6_a32 in out nocopy JTF_VARCHAR2_TABLE_300
474 , p6_a33 in out nocopy JTF_NUMBER_TABLE
475 , p6_a34 in out nocopy JTF_VARCHAR2_TABLE_100
476 , p6_a35 in out nocopy JTF_VARCHAR2_TABLE_100
477 , p6_a36 in out nocopy JTF_VARCHAR2_TABLE_100
478 , p6_a37 in out nocopy JTF_VARCHAR2_TABLE_100
479 , p6_a38 in out nocopy JTF_NUMBER_TABLE
480 , p6_a39 in out nocopy JTF_NUMBER_TABLE
481 , p6_a40 in out nocopy JTF_VARCHAR2_TABLE_100
482 , p6_a41 in out nocopy JTF_VARCHAR2_TABLE_100
483 , p6_a42 in out nocopy JTF_VARCHAR2_TABLE_100
484 , p6_a43 in out nocopy JTF_VARCHAR2_TABLE_100
485 , p6_a44 in out nocopy JTF_VARCHAR2_TABLE_100
486 , p6_a45 in out nocopy JTF_VARCHAR2_TABLE_2000
487 , p6_a46 in out nocopy JTF_NUMBER_TABLE
488 , p6_a47 in out nocopy JTF_NUMBER_TABLE
489 , p6_a48 in out nocopy JTF_NUMBER_TABLE
490 , p7_a0 JTF_NUMBER_TABLE
491 , p7_a1 JTF_VARCHAR2_TABLE_100
492 , p7_a2 JTF_NUMBER_TABLE
493 , p7_a3 JTF_NUMBER_TABLE
494 , p7_a4 JTF_NUMBER_TABLE
495 , p7_a5 JTF_NUMBER_TABLE
496 , p7_a6 JTF_VARCHAR2_TABLE_100
497 , p7_a7 JTF_NUMBER_TABLE
498 , p7_a8 JTF_VARCHAR2_TABLE_100
499 , p7_a9 JTF_NUMBER_TABLE
500 , x_return_status out nocopy VARCHAR2
501 , x_msg_count out nocopy NUMBER
502 , x_msg_data out nocopy VARCHAR2
503 , p11_a0 out nocopy JTF_VARCHAR2_TABLE_100
504 , p11_a1 out nocopy JTF_VARCHAR2_TABLE_4000
505 );
506 end ahl_prd_blk_parts_change_pvt_w;