[Home] [Help]
PACKAGE: APPS.OKL_VP_CHANGE_REQUEST_PVT_W
Source
1 package okl_vp_change_request_pvt_w as
2 /* $Header: OKLEVCRS.pls 120.0 2005/08/03 07:55:01 sjalasut noship $ */
3 procedure create_change_request_header(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , x_return_status out nocopy VARCHAR2
6 , x_msg_count out nocopy NUMBER
7 , x_msg_data out nocopy VARCHAR2
8 , p5_a0 NUMBER
9 , p5_a1 NUMBER
10 , p5_a2 NUMBER
11 , p5_a3 NUMBER
12 , p5_a4 VARCHAR2
13 , p5_a5 VARCHAR2
14 , p5_a6 DATE
15 , p5_a7 DATE
16 , p5_a8 DATE
17 , p5_a9 DATE
18 , p5_a10 DATE
19 , p5_a11 DATE
20 , p5_a12 VARCHAR2
21 , p5_a13 VARCHAR2
22 , p5_a14 VARCHAR2
23 , p5_a15 VARCHAR2
24 , p5_a16 VARCHAR2
25 , p5_a17 VARCHAR2
26 , p5_a18 VARCHAR2
27 , p5_a19 VARCHAR2
28 , p5_a20 VARCHAR2
29 , p5_a21 VARCHAR2
30 , p5_a22 VARCHAR2
31 , p5_a23 VARCHAR2
32 , p5_a24 VARCHAR2
33 , p5_a25 VARCHAR2
34 , p5_a26 VARCHAR2
35 , p5_a27 VARCHAR2
36 , p5_a28 NUMBER
37 , p5_a29 NUMBER
38 , p5_a30 NUMBER
39 , p5_a31 DATE
40 , p5_a32 NUMBER
41 , p5_a33 DATE
42 , p5_a34 NUMBER
43 , p5_a35 DATE
44 , p5_a36 NUMBER
45 , p6_a0 out nocopy NUMBER
46 , p6_a1 out nocopy NUMBER
47 , p6_a2 out nocopy NUMBER
48 , p6_a3 out nocopy NUMBER
49 , p6_a4 out nocopy VARCHAR2
50 , p6_a5 out nocopy VARCHAR2
51 , p6_a6 out nocopy DATE
52 , p6_a7 out nocopy DATE
53 , p6_a8 out nocopy DATE
54 , p6_a9 out nocopy DATE
55 , p6_a10 out nocopy DATE
56 , p6_a11 out nocopy DATE
57 , p6_a12 out nocopy VARCHAR2
58 , p6_a13 out nocopy VARCHAR2
59 , p6_a14 out nocopy VARCHAR2
60 , p6_a15 out nocopy VARCHAR2
61 , p6_a16 out nocopy VARCHAR2
62 , p6_a17 out nocopy VARCHAR2
63 , p6_a18 out nocopy VARCHAR2
64 , p6_a19 out nocopy VARCHAR2
65 , p6_a20 out nocopy VARCHAR2
66 , p6_a21 out nocopy VARCHAR2
67 , p6_a22 out nocopy VARCHAR2
68 , p6_a23 out nocopy VARCHAR2
69 , p6_a24 out nocopy VARCHAR2
70 , p6_a25 out nocopy VARCHAR2
71 , p6_a26 out nocopy VARCHAR2
72 , p6_a27 out nocopy VARCHAR2
73 , p6_a28 out nocopy NUMBER
74 , p6_a29 out nocopy NUMBER
75 , p6_a30 out nocopy NUMBER
76 , p6_a31 out nocopy DATE
77 , p6_a32 out nocopy NUMBER
78 , p6_a33 out nocopy DATE
79 , p6_a34 out nocopy NUMBER
80 , p6_a35 out nocopy DATE
81 , p6_a36 out nocopy NUMBER
82 );
83 procedure update_change_request_header(p_api_version NUMBER
84 , p_init_msg_list VARCHAR2
85 , x_return_status out nocopy VARCHAR2
86 , x_msg_count out nocopy NUMBER
87 , x_msg_data out nocopy VARCHAR2
88 , p5_a0 NUMBER
89 , p5_a1 NUMBER
90 , p5_a2 NUMBER
91 , p5_a3 NUMBER
92 , p5_a4 VARCHAR2
93 , p5_a5 VARCHAR2
94 , p5_a6 DATE
95 , p5_a7 DATE
96 , p5_a8 DATE
97 , p5_a9 DATE
98 , p5_a10 DATE
99 , p5_a11 DATE
100 , p5_a12 VARCHAR2
101 , p5_a13 VARCHAR2
102 , p5_a14 VARCHAR2
103 , p5_a15 VARCHAR2
104 , p5_a16 VARCHAR2
105 , p5_a17 VARCHAR2
106 , p5_a18 VARCHAR2
107 , p5_a19 VARCHAR2
108 , p5_a20 VARCHAR2
109 , p5_a21 VARCHAR2
110 , p5_a22 VARCHAR2
111 , p5_a23 VARCHAR2
112 , p5_a24 VARCHAR2
113 , p5_a25 VARCHAR2
114 , p5_a26 VARCHAR2
115 , p5_a27 VARCHAR2
116 , p5_a28 NUMBER
117 , p5_a29 NUMBER
118 , p5_a30 NUMBER
119 , p5_a31 DATE
120 , p5_a32 NUMBER
121 , p5_a33 DATE
122 , p5_a34 NUMBER
123 , p5_a35 DATE
124 , p5_a36 NUMBER
125 , p6_a0 out nocopy NUMBER
126 , p6_a1 out nocopy NUMBER
127 , p6_a2 out nocopy NUMBER
128 , p6_a3 out nocopy NUMBER
129 , p6_a4 out nocopy VARCHAR2
130 , p6_a5 out nocopy VARCHAR2
131 , p6_a6 out nocopy DATE
132 , p6_a7 out nocopy DATE
133 , p6_a8 out nocopy DATE
134 , p6_a9 out nocopy DATE
135 , p6_a10 out nocopy DATE
136 , p6_a11 out nocopy DATE
137 , p6_a12 out nocopy VARCHAR2
138 , p6_a13 out nocopy VARCHAR2
139 , p6_a14 out nocopy VARCHAR2
140 , p6_a15 out nocopy VARCHAR2
141 , p6_a16 out nocopy VARCHAR2
142 , p6_a17 out nocopy VARCHAR2
143 , p6_a18 out nocopy VARCHAR2
144 , p6_a19 out nocopy VARCHAR2
145 , p6_a20 out nocopy VARCHAR2
146 , p6_a21 out nocopy VARCHAR2
147 , p6_a22 out nocopy VARCHAR2
148 , p6_a23 out nocopy VARCHAR2
149 , p6_a24 out nocopy VARCHAR2
150 , p6_a25 out nocopy VARCHAR2
151 , p6_a26 out nocopy VARCHAR2
152 , p6_a27 out nocopy VARCHAR2
153 , p6_a28 out nocopy NUMBER
154 , p6_a29 out nocopy NUMBER
155 , p6_a30 out nocopy NUMBER
156 , p6_a31 out nocopy DATE
157 , p6_a32 out nocopy NUMBER
158 , p6_a33 out nocopy DATE
159 , p6_a34 out nocopy NUMBER
160 , p6_a35 out nocopy DATE
161 , p6_a36 out nocopy NUMBER
162 );
163 procedure create_change_request_lines(p_api_version NUMBER
164 , p_init_msg_list VARCHAR2
165 , x_return_status out nocopy VARCHAR2
166 , x_msg_count out nocopy NUMBER
167 , x_msg_data out nocopy VARCHAR2
168 , p5_a0 JTF_NUMBER_TABLE
169 , p5_a1 JTF_NUMBER_TABLE
170 , p5_a2 JTF_NUMBER_TABLE
171 , p5_a3 JTF_VARCHAR2_TABLE_100
172 , p5_a4 JTF_VARCHAR2_TABLE_400
173 , p5_a5 JTF_VARCHAR2_TABLE_2000
174 , p5_a6 JTF_VARCHAR2_TABLE_100
175 , p5_a7 JTF_VARCHAR2_TABLE_500
176 , p5_a8 JTF_VARCHAR2_TABLE_500
177 , p5_a9 JTF_VARCHAR2_TABLE_500
178 , p5_a10 JTF_VARCHAR2_TABLE_500
179 , p5_a11 JTF_VARCHAR2_TABLE_500
180 , p5_a12 JTF_VARCHAR2_TABLE_500
181 , p5_a13 JTF_VARCHAR2_TABLE_500
182 , p5_a14 JTF_VARCHAR2_TABLE_500
183 , p5_a15 JTF_VARCHAR2_TABLE_500
184 , p5_a16 JTF_VARCHAR2_TABLE_500
185 , p5_a17 JTF_VARCHAR2_TABLE_500
186 , p5_a18 JTF_VARCHAR2_TABLE_500
187 , p5_a19 JTF_VARCHAR2_TABLE_500
188 , p5_a20 JTF_VARCHAR2_TABLE_500
189 , p5_a21 JTF_VARCHAR2_TABLE_500
190 , p5_a22 JTF_NUMBER_TABLE
191 , p5_a23 JTF_NUMBER_TABLE
192 , p5_a24 JTF_NUMBER_TABLE
193 , p5_a25 JTF_DATE_TABLE
194 , p5_a26 JTF_NUMBER_TABLE
195 , p5_a27 JTF_DATE_TABLE
196 , p5_a28 JTF_NUMBER_TABLE
197 , p5_a29 JTF_DATE_TABLE
198 , p5_a30 JTF_NUMBER_TABLE
199 , p6_a0 out nocopy JTF_NUMBER_TABLE
200 , p6_a1 out nocopy JTF_NUMBER_TABLE
201 , p6_a2 out nocopy JTF_NUMBER_TABLE
202 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
203 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
204 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
205 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
206 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
207 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
208 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
209 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
210 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
211 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
212 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
213 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
214 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
215 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
216 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
217 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
218 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
219 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
220 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
221 , p6_a22 out nocopy JTF_NUMBER_TABLE
222 , p6_a23 out nocopy JTF_NUMBER_TABLE
223 , p6_a24 out nocopy JTF_NUMBER_TABLE
224 , p6_a25 out nocopy JTF_DATE_TABLE
225 , p6_a26 out nocopy JTF_NUMBER_TABLE
226 , p6_a27 out nocopy JTF_DATE_TABLE
227 , p6_a28 out nocopy JTF_NUMBER_TABLE
228 , p6_a29 out nocopy JTF_DATE_TABLE
229 , p6_a30 out nocopy JTF_NUMBER_TABLE
230 , x_request_status out nocopy VARCHAR2
231 );
232 procedure update_change_request_lines(p_api_version NUMBER
233 , p_init_msg_list VARCHAR2
234 , x_return_status out nocopy VARCHAR2
235 , x_msg_count out nocopy NUMBER
236 , x_msg_data out nocopy VARCHAR2
237 , p5_a0 JTF_NUMBER_TABLE
238 , p5_a1 JTF_NUMBER_TABLE
239 , p5_a2 JTF_NUMBER_TABLE
240 , p5_a3 JTF_VARCHAR2_TABLE_100
241 , p5_a4 JTF_VARCHAR2_TABLE_400
242 , p5_a5 JTF_VARCHAR2_TABLE_2000
243 , p5_a6 JTF_VARCHAR2_TABLE_100
244 , p5_a7 JTF_VARCHAR2_TABLE_500
245 , p5_a8 JTF_VARCHAR2_TABLE_500
246 , p5_a9 JTF_VARCHAR2_TABLE_500
247 , p5_a10 JTF_VARCHAR2_TABLE_500
248 , p5_a11 JTF_VARCHAR2_TABLE_500
249 , p5_a12 JTF_VARCHAR2_TABLE_500
250 , p5_a13 JTF_VARCHAR2_TABLE_500
251 , p5_a14 JTF_VARCHAR2_TABLE_500
252 , p5_a15 JTF_VARCHAR2_TABLE_500
253 , p5_a16 JTF_VARCHAR2_TABLE_500
254 , p5_a17 JTF_VARCHAR2_TABLE_500
255 , p5_a18 JTF_VARCHAR2_TABLE_500
256 , p5_a19 JTF_VARCHAR2_TABLE_500
257 , p5_a20 JTF_VARCHAR2_TABLE_500
258 , p5_a21 JTF_VARCHAR2_TABLE_500
259 , p5_a22 JTF_NUMBER_TABLE
260 , p5_a23 JTF_NUMBER_TABLE
261 , p5_a24 JTF_NUMBER_TABLE
262 , p5_a25 JTF_DATE_TABLE
263 , p5_a26 JTF_NUMBER_TABLE
264 , p5_a27 JTF_DATE_TABLE
265 , p5_a28 JTF_NUMBER_TABLE
266 , p5_a29 JTF_DATE_TABLE
267 , p5_a30 JTF_NUMBER_TABLE
268 , p6_a0 out nocopy JTF_NUMBER_TABLE
269 , p6_a1 out nocopy JTF_NUMBER_TABLE
270 , p6_a2 out nocopy JTF_NUMBER_TABLE
271 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
272 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
273 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
274 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
275 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
276 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
277 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
278 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
279 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
280 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
281 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
282 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
283 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
284 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
285 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
286 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
287 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
288 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
289 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
290 , p6_a22 out nocopy JTF_NUMBER_TABLE
291 , p6_a23 out nocopy JTF_NUMBER_TABLE
292 , p6_a24 out nocopy JTF_NUMBER_TABLE
293 , p6_a25 out nocopy JTF_DATE_TABLE
294 , p6_a26 out nocopy JTF_NUMBER_TABLE
295 , p6_a27 out nocopy JTF_DATE_TABLE
296 , p6_a28 out nocopy JTF_NUMBER_TABLE
297 , p6_a29 out nocopy JTF_DATE_TABLE
298 , p6_a30 out nocopy JTF_NUMBER_TABLE
299 , x_request_status out nocopy VARCHAR2
300 );
301 procedure delete_change_request_lines(p_api_version NUMBER
302 , p_init_msg_list VARCHAR2
303 , x_return_status out nocopy VARCHAR2
304 , x_msg_count out nocopy NUMBER
305 , x_msg_data out nocopy VARCHAR2
309 , p5_a3 JTF_VARCHAR2_TABLE_100
306 , p5_a0 JTF_NUMBER_TABLE
307 , p5_a1 JTF_NUMBER_TABLE
308 , p5_a2 JTF_NUMBER_TABLE
310 , p5_a4 JTF_VARCHAR2_TABLE_400
311 , p5_a5 JTF_VARCHAR2_TABLE_2000
312 , p5_a6 JTF_VARCHAR2_TABLE_100
313 , p5_a7 JTF_VARCHAR2_TABLE_500
314 , p5_a8 JTF_VARCHAR2_TABLE_500
315 , p5_a9 JTF_VARCHAR2_TABLE_500
316 , p5_a10 JTF_VARCHAR2_TABLE_500
317 , p5_a11 JTF_VARCHAR2_TABLE_500
318 , p5_a12 JTF_VARCHAR2_TABLE_500
319 , p5_a13 JTF_VARCHAR2_TABLE_500
320 , p5_a14 JTF_VARCHAR2_TABLE_500
321 , p5_a15 JTF_VARCHAR2_TABLE_500
322 , p5_a16 JTF_VARCHAR2_TABLE_500
323 , p5_a17 JTF_VARCHAR2_TABLE_500
324 , p5_a18 JTF_VARCHAR2_TABLE_500
325 , p5_a19 JTF_VARCHAR2_TABLE_500
326 , p5_a20 JTF_VARCHAR2_TABLE_500
327 , p5_a21 JTF_VARCHAR2_TABLE_500
328 , p5_a22 JTF_NUMBER_TABLE
329 , p5_a23 JTF_NUMBER_TABLE
330 , p5_a24 JTF_NUMBER_TABLE
331 , p5_a25 JTF_DATE_TABLE
332 , p5_a26 JTF_NUMBER_TABLE
333 , p5_a27 JTF_DATE_TABLE
334 , p5_a28 JTF_NUMBER_TABLE
335 , p5_a29 JTF_DATE_TABLE
336 , p5_a30 JTF_NUMBER_TABLE
337 , x_request_status out nocopy VARCHAR2
338 );
339 procedure create_change_request(p_api_version NUMBER
340 , p_init_msg_list VARCHAR2
341 , x_return_status out nocopy VARCHAR2
342 , x_msg_count out nocopy NUMBER
343 , x_msg_data out nocopy VARCHAR2
344 , p5_a0 NUMBER
345 , p5_a1 NUMBER
346 , p5_a2 NUMBER
347 , p5_a3 NUMBER
348 , p5_a4 VARCHAR2
349 , p5_a5 VARCHAR2
350 , p5_a6 DATE
351 , p5_a7 DATE
352 , p5_a8 DATE
353 , p5_a9 DATE
354 , p5_a10 DATE
355 , p5_a11 DATE
356 , p5_a12 VARCHAR2
357 , p5_a13 VARCHAR2
358 , p5_a14 VARCHAR2
359 , p5_a15 VARCHAR2
360 , p5_a16 VARCHAR2
361 , p5_a17 VARCHAR2
362 , p5_a18 VARCHAR2
363 , p5_a19 VARCHAR2
364 , p5_a20 VARCHAR2
365 , p5_a21 VARCHAR2
366 , p5_a22 VARCHAR2
367 , p5_a23 VARCHAR2
368 , p5_a24 VARCHAR2
369 , p5_a25 VARCHAR2
370 , p5_a26 VARCHAR2
371 , p5_a27 VARCHAR2
372 , p5_a28 NUMBER
373 , p5_a29 NUMBER
374 , p5_a30 NUMBER
375 , p5_a31 DATE
376 , p5_a32 NUMBER
377 , p5_a33 DATE
378 , p5_a34 NUMBER
379 , p5_a35 DATE
380 , p5_a36 NUMBER
381 , p6_a0 JTF_NUMBER_TABLE
382 , p6_a1 JTF_NUMBER_TABLE
383 , p6_a2 JTF_NUMBER_TABLE
384 , p6_a3 JTF_VARCHAR2_TABLE_100
385 , p6_a4 JTF_VARCHAR2_TABLE_400
386 , p6_a5 JTF_VARCHAR2_TABLE_2000
387 , p6_a6 JTF_VARCHAR2_TABLE_100
388 , p6_a7 JTF_VARCHAR2_TABLE_500
389 , p6_a8 JTF_VARCHAR2_TABLE_500
390 , p6_a9 JTF_VARCHAR2_TABLE_500
391 , p6_a10 JTF_VARCHAR2_TABLE_500
392 , p6_a11 JTF_VARCHAR2_TABLE_500
393 , p6_a12 JTF_VARCHAR2_TABLE_500
394 , p6_a13 JTF_VARCHAR2_TABLE_500
395 , p6_a14 JTF_VARCHAR2_TABLE_500
396 , p6_a15 JTF_VARCHAR2_TABLE_500
397 , p6_a16 JTF_VARCHAR2_TABLE_500
398 , p6_a17 JTF_VARCHAR2_TABLE_500
399 , p6_a18 JTF_VARCHAR2_TABLE_500
400 , p6_a19 JTF_VARCHAR2_TABLE_500
401 , p6_a20 JTF_VARCHAR2_TABLE_500
402 , p6_a21 JTF_VARCHAR2_TABLE_500
403 , p6_a22 JTF_NUMBER_TABLE
404 , p6_a23 JTF_NUMBER_TABLE
405 , p6_a24 JTF_NUMBER_TABLE
406 , p6_a25 JTF_DATE_TABLE
407 , p6_a26 JTF_NUMBER_TABLE
408 , p6_a27 JTF_DATE_TABLE
409 , p6_a28 JTF_NUMBER_TABLE
410 , p6_a29 JTF_DATE_TABLE
411 , p6_a30 JTF_NUMBER_TABLE
412 , p7_a0 out nocopy NUMBER
413 , p7_a1 out nocopy NUMBER
414 , p7_a2 out nocopy NUMBER
415 , p7_a3 out nocopy NUMBER
416 , p7_a4 out nocopy VARCHAR2
417 , p7_a5 out nocopy VARCHAR2
418 , p7_a6 out nocopy DATE
419 , p7_a7 out nocopy DATE
420 , p7_a8 out nocopy DATE
421 , p7_a9 out nocopy DATE
422 , p7_a10 out nocopy DATE
423 , p7_a11 out nocopy DATE
424 , p7_a12 out nocopy VARCHAR2
425 , p7_a13 out nocopy VARCHAR2
426 , p7_a14 out nocopy VARCHAR2
427 , p7_a15 out nocopy VARCHAR2
428 , p7_a16 out nocopy VARCHAR2
429 , p7_a17 out nocopy VARCHAR2
430 , p7_a18 out nocopy VARCHAR2
431 , p7_a19 out nocopy VARCHAR2
432 , p7_a20 out nocopy VARCHAR2
433 , p7_a21 out nocopy VARCHAR2
434 , p7_a22 out nocopy VARCHAR2
435 , p7_a23 out nocopy VARCHAR2
436 , p7_a24 out nocopy VARCHAR2
437 , p7_a25 out nocopy VARCHAR2
438 , p7_a26 out nocopy VARCHAR2
439 , p7_a27 out nocopy VARCHAR2
440 , p7_a28 out nocopy NUMBER
441 , p7_a29 out nocopy NUMBER
442 , p7_a30 out nocopy NUMBER
443 , p7_a31 out nocopy DATE
444 , p7_a32 out nocopy NUMBER
445 , p7_a33 out nocopy DATE
446 , p7_a34 out nocopy NUMBER
447 , p7_a35 out nocopy DATE
448 , p7_a36 out nocopy NUMBER
449 , p8_a0 out nocopy JTF_NUMBER_TABLE
450 , p8_a1 out nocopy JTF_NUMBER_TABLE
451 , p8_a2 out nocopy JTF_NUMBER_TABLE
452 , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
453 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_400
454 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_2000
455 , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
456 , p8_a7 out nocopy JTF_VARCHAR2_TABLE_500
457 , p8_a8 out nocopy JTF_VARCHAR2_TABLE_500
458 , p8_a9 out nocopy JTF_VARCHAR2_TABLE_500
459 , p8_a10 out nocopy JTF_VARCHAR2_TABLE_500
460 , p8_a11 out nocopy JTF_VARCHAR2_TABLE_500
461 , p8_a12 out nocopy JTF_VARCHAR2_TABLE_500
462 , p8_a13 out nocopy JTF_VARCHAR2_TABLE_500
463 , p8_a14 out nocopy JTF_VARCHAR2_TABLE_500
464 , p8_a15 out nocopy JTF_VARCHAR2_TABLE_500
465 , p8_a16 out nocopy JTF_VARCHAR2_TABLE_500
466 , p8_a17 out nocopy JTF_VARCHAR2_TABLE_500
467 , p8_a18 out nocopy JTF_VARCHAR2_TABLE_500
468 , p8_a19 out nocopy JTF_VARCHAR2_TABLE_500
469 , p8_a20 out nocopy JTF_VARCHAR2_TABLE_500
470 , p8_a21 out nocopy JTF_VARCHAR2_TABLE_500
471 , p8_a22 out nocopy JTF_NUMBER_TABLE
472 , p8_a23 out nocopy JTF_NUMBER_TABLE
473 , p8_a24 out nocopy JTF_NUMBER_TABLE
474 , p8_a25 out nocopy JTF_DATE_TABLE
475 , p8_a26 out nocopy JTF_NUMBER_TABLE
476 , p8_a27 out nocopy JTF_DATE_TABLE
477 , p8_a28 out nocopy JTF_NUMBER_TABLE
478 , p8_a29 out nocopy JTF_DATE_TABLE
479 , p8_a30 out nocopy JTF_NUMBER_TABLE
480 );
481 procedure abandon_change_request(p_api_version NUMBER
482 , p_init_msg_list VARCHAR2
483 , x_return_status out nocopy VARCHAR2
484 , x_msg_count out nocopy NUMBER
485 , x_msg_data out nocopy VARCHAR2
486 , p5_a0 NUMBER
487 , p5_a1 NUMBER
488 , p5_a2 NUMBER
489 , p5_a3 NUMBER
490 , p5_a4 VARCHAR2
491 , p5_a5 VARCHAR2
492 , p5_a6 DATE
493 , p5_a7 DATE
494 , p5_a8 DATE
495 , p5_a9 DATE
496 , p5_a10 DATE
497 , p5_a11 DATE
498 , p5_a12 VARCHAR2
499 , p5_a13 VARCHAR2
500 , p5_a14 VARCHAR2
501 , p5_a15 VARCHAR2
502 , p5_a16 VARCHAR2
503 , p5_a17 VARCHAR2
504 , p5_a18 VARCHAR2
505 , p5_a19 VARCHAR2
506 , p5_a20 VARCHAR2
507 , p5_a21 VARCHAR2
508 , p5_a22 VARCHAR2
509 , p5_a23 VARCHAR2
510 , p5_a24 VARCHAR2
511 , p5_a25 VARCHAR2
512 , p5_a26 VARCHAR2
513 , p5_a27 VARCHAR2
514 , p5_a28 NUMBER
515 , p5_a29 NUMBER
516 , p5_a30 NUMBER
517 , p5_a31 DATE
518 , p5_a32 NUMBER
519 , p5_a33 DATE
520 , p5_a34 NUMBER
521 , p5_a35 DATE
522 , p5_a36 NUMBER
523 , p6_a0 out nocopy NUMBER
524 , p6_a1 out nocopy NUMBER
525 , p6_a2 out nocopy NUMBER
526 , p6_a3 out nocopy NUMBER
527 , p6_a4 out nocopy VARCHAR2
528 , p6_a5 out nocopy VARCHAR2
529 , p6_a6 out nocopy DATE
530 , p6_a7 out nocopy DATE
531 , p6_a8 out nocopy DATE
532 , p6_a9 out nocopy DATE
533 , p6_a10 out nocopy DATE
534 , p6_a11 out nocopy DATE
535 , p6_a12 out nocopy VARCHAR2
536 , p6_a13 out nocopy VARCHAR2
537 , p6_a14 out nocopy VARCHAR2
538 , p6_a15 out nocopy VARCHAR2
539 , p6_a16 out nocopy VARCHAR2
540 , p6_a17 out nocopy VARCHAR2
541 , p6_a18 out nocopy VARCHAR2
542 , p6_a19 out nocopy VARCHAR2
543 , p6_a20 out nocopy VARCHAR2
544 , p6_a21 out nocopy VARCHAR2
545 , p6_a22 out nocopy VARCHAR2
546 , p6_a23 out nocopy VARCHAR2
547 , p6_a24 out nocopy VARCHAR2
548 , p6_a25 out nocopy VARCHAR2
549 , p6_a26 out nocopy VARCHAR2
550 , p6_a27 out nocopy VARCHAR2
551 , p6_a28 out nocopy NUMBER
552 , p6_a29 out nocopy NUMBER
553 , p6_a30 out nocopy NUMBER
554 , p6_a31 out nocopy DATE
555 , p6_a32 out nocopy NUMBER
556 , p6_a33 out nocopy DATE
557 , p6_a34 out nocopy NUMBER
558 , p6_a35 out nocopy DATE
559 , p6_a36 out nocopy NUMBER
560 );
561 end okl_vp_change_request_pvt_w;