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