[Home] [Help]
PACKAGE: APPS.OZF_CLAIMS_HISTORY_PVT_W
Source
1 package ozf_claims_history_pvt_w AUTHID CURRENT_USER as
2 /* $Header: ozfwchis.pls 115.3 2003/12/02 23:54:07 yizhang noship $ */
3 procedure rosetta_table_copy_in_p3(t out nocopy ozf_claims_history_pvt.claims_history_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_DATE_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_DATE_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_DATE_TABLE
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_VARCHAR2_TABLE_100
15 , a12 JTF_NUMBER_TABLE
16 , a13 JTF_NUMBER_TABLE
17 , a14 JTF_VARCHAR2_TABLE_100
18 , a15 JTF_NUMBER_TABLE
19 , a16 JTF_VARCHAR2_TABLE_100
20 , a17 JTF_DATE_TABLE
21 , a18 JTF_DATE_TABLE
22 , a19 JTF_NUMBER_TABLE
23 , a20 JTF_VARCHAR2_TABLE_100
24 , a21 JTF_DATE_TABLE
25 , a22 JTF_VARCHAR2_TABLE_2000
26 , a23 JTF_NUMBER_TABLE
27 , a24 JTF_NUMBER_TABLE
28 , a25 JTF_DATE_TABLE
29 , a26 JTF_NUMBER_TABLE
30 , a27 JTF_NUMBER_TABLE
31 , a28 JTF_NUMBER_TABLE
32 , a29 JTF_NUMBER_TABLE
33 , a30 JTF_NUMBER_TABLE
34 , a31 JTF_NUMBER_TABLE
35 , a32 JTF_NUMBER_TABLE
36 , a33 JTF_NUMBER_TABLE
37 , a34 JTF_NUMBER_TABLE
38 , a35 JTF_NUMBER_TABLE
39 , a36 JTF_VARCHAR2_TABLE_100
40 , a37 JTF_VARCHAR2_TABLE_100
41 , a38 JTF_VARCHAR2_TABLE_100
42 , a39 JTF_VARCHAR2_TABLE_100
43 , a40 JTF_DATE_TABLE
44 , a41 JTF_NUMBER_TABLE
45 , a42 JTF_NUMBER_TABLE
46 , a43 JTF_DATE_TABLE
47 , a44 JTF_NUMBER_TABLE
48 , a45 JTF_VARCHAR2_TABLE_100
49 , a46 JTF_NUMBER_TABLE
50 , a47 JTF_VARCHAR2_TABLE_100
51 , a48 JTF_NUMBER_TABLE
52 , a49 JTF_NUMBER_TABLE
53 , a50 JTF_NUMBER_TABLE
54 , a51 JTF_NUMBER_TABLE
55 , a52 JTF_VARCHAR2_TABLE_100
56 , a53 JTF_NUMBER_TABLE
57 , a54 JTF_NUMBER_TABLE
58 , a55 JTF_VARCHAR2_TABLE_100
59 , a56 JTF_NUMBER_TABLE
60 , a57 JTF_NUMBER_TABLE
61 , a58 JTF_VARCHAR2_TABLE_100
62 , a59 JTF_NUMBER_TABLE
63 , a60 JTF_NUMBER_TABLE
64 , a61 JTF_VARCHAR2_TABLE_100
65 , a62 JTF_NUMBER_TABLE
66 , a63 JTF_NUMBER_TABLE
67 , a64 JTF_NUMBER_TABLE
68 , a65 JTF_NUMBER_TABLE
69 , a66 JTF_NUMBER_TABLE
70 , a67 JTF_NUMBER_TABLE
71 , a68 JTF_DATE_TABLE
72 , a69 JTF_VARCHAR2_TABLE_100
73 , a70 JTF_NUMBER_TABLE
74 , a71 JTF_NUMBER_TABLE
75 , a72 JTF_VARCHAR2_TABLE_100
76 , a73 JTF_NUMBER_TABLE
77 , a74 JTF_NUMBER_TABLE
78 , a75 JTF_DATE_TABLE
79 , a76 JTF_VARCHAR2_TABLE_100
80 , a77 JTF_NUMBER_TABLE
81 , a78 JTF_VARCHAR2_TABLE_100
82 , a79 JTF_NUMBER_TABLE
83 , a80 JTF_VARCHAR2_TABLE_100
84 , a81 JTF_DATE_TABLE
85 , a82 JTF_VARCHAR2_TABLE_100
86 , a83 JTF_VARCHAR2_TABLE_100
87 , a84 JTF_DATE_TABLE
88 , a85 JTF_NUMBER_TABLE
89 , a86 JTF_DATE_TABLE
90 , a87 JTF_NUMBER_TABLE
91 , a88 JTF_DATE_TABLE
92 , a89 JTF_NUMBER_TABLE
93 , a90 JTF_NUMBER_TABLE
94 , a91 JTF_NUMBER_TABLE
95 , a92 JTF_NUMBER_TABLE
96 , a93 JTF_VARCHAR2_TABLE_2000
97 , a94 JTF_NUMBER_TABLE
98 , a95 JTF_DATE_TABLE
99 , a96 JTF_NUMBER_TABLE
100 , a97 JTF_VARCHAR2_TABLE_100
101 , a98 JTF_VARCHAR2_TABLE_100
102 , a99 JTF_VARCHAR2_TABLE_200
103 , a100 JTF_VARCHAR2_TABLE_200
104 , a101 JTF_VARCHAR2_TABLE_200
105 , a102 JTF_VARCHAR2_TABLE_200
106 , a103 JTF_VARCHAR2_TABLE_200
107 , a104 JTF_VARCHAR2_TABLE_200
108 , a105 JTF_VARCHAR2_TABLE_200
109 , a106 JTF_VARCHAR2_TABLE_200
110 , a107 JTF_VARCHAR2_TABLE_200
111 , a108 JTF_VARCHAR2_TABLE_200
112 , a109 JTF_VARCHAR2_TABLE_200
113 , a110 JTF_VARCHAR2_TABLE_200
114 , a111 JTF_VARCHAR2_TABLE_200
115 , a112 JTF_VARCHAR2_TABLE_200
116 , a113 JTF_VARCHAR2_TABLE_200
117 , a114 JTF_VARCHAR2_TABLE_100
118 , a115 JTF_VARCHAR2_TABLE_200
119 , a116 JTF_VARCHAR2_TABLE_200
120 , a117 JTF_VARCHAR2_TABLE_200
121 , a118 JTF_VARCHAR2_TABLE_200
122 , a119 JTF_VARCHAR2_TABLE_200
123 , a120 JTF_VARCHAR2_TABLE_200
124 , a121 JTF_VARCHAR2_TABLE_200
125 , a122 JTF_VARCHAR2_TABLE_200
126 , a123 JTF_VARCHAR2_TABLE_200
127 , a124 JTF_VARCHAR2_TABLE_200
128 , a125 JTF_VARCHAR2_TABLE_200
129 , a126 JTF_VARCHAR2_TABLE_200
130 , a127 JTF_VARCHAR2_TABLE_200
131 , a128 JTF_VARCHAR2_TABLE_200
132 , a129 JTF_VARCHAR2_TABLE_200
133 , a130 JTF_NUMBER_TABLE
134 , a131 JTF_VARCHAR2_TABLE_100
135 , a132 JTF_NUMBER_TABLE
136 , a133 JTF_VARCHAR2_TABLE_100
137 , a134 JTF_VARCHAR2_TABLE_100
138 , a135 JTF_NUMBER_TABLE
139 , a136 JTF_NUMBER_TABLE
140 , a137 JTF_NUMBER_TABLE
141 , a138 JTF_VARCHAR2_TABLE_100
142 , a139 JTF_NUMBER_TABLE
143 , a140 JTF_NUMBER_TABLE
144 , a141 JTF_VARCHAR2_TABLE_300
145 , a142 JTF_VARCHAR2_TABLE_300
146 , a143 JTF_VARCHAR2_TABLE_100
147 );
148 procedure rosetta_table_copy_out_p3(t ozf_claims_history_pvt.claims_history_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
149 , a1 out nocopy JTF_NUMBER_TABLE
150 , a2 out nocopy JTF_DATE_TABLE
151 , a3 out nocopy JTF_NUMBER_TABLE
152 , a4 out nocopy JTF_DATE_TABLE
153 , a5 out nocopy JTF_NUMBER_TABLE
154 , a6 out nocopy JTF_NUMBER_TABLE
155 , a7 out nocopy JTF_NUMBER_TABLE
156 , a8 out nocopy JTF_NUMBER_TABLE
157 , a9 out nocopy JTF_DATE_TABLE
158 , a10 out nocopy JTF_NUMBER_TABLE
159 , a11 out nocopy JTF_VARCHAR2_TABLE_100
160 , a12 out nocopy JTF_NUMBER_TABLE
161 , a13 out nocopy JTF_NUMBER_TABLE
162 , a14 out nocopy JTF_VARCHAR2_TABLE_100
163 , a15 out nocopy JTF_NUMBER_TABLE
164 , a16 out nocopy JTF_VARCHAR2_TABLE_100
165 , a17 out nocopy JTF_DATE_TABLE
166 , a18 out nocopy JTF_DATE_TABLE
167 , a19 out nocopy JTF_NUMBER_TABLE
168 , a20 out nocopy JTF_VARCHAR2_TABLE_100
169 , a21 out nocopy JTF_DATE_TABLE
170 , a22 out nocopy JTF_VARCHAR2_TABLE_2000
171 , a23 out nocopy JTF_NUMBER_TABLE
172 , a24 out nocopy JTF_NUMBER_TABLE
173 , a25 out nocopy JTF_DATE_TABLE
174 , a26 out nocopy JTF_NUMBER_TABLE
175 , a27 out nocopy JTF_NUMBER_TABLE
176 , a28 out nocopy JTF_NUMBER_TABLE
177 , a29 out nocopy JTF_NUMBER_TABLE
178 , a30 out nocopy JTF_NUMBER_TABLE
179 , a31 out nocopy JTF_NUMBER_TABLE
180 , a32 out nocopy JTF_NUMBER_TABLE
181 , a33 out nocopy JTF_NUMBER_TABLE
182 , a34 out nocopy JTF_NUMBER_TABLE
183 , a35 out nocopy JTF_NUMBER_TABLE
184 , a36 out nocopy JTF_VARCHAR2_TABLE_100
185 , a37 out nocopy JTF_VARCHAR2_TABLE_100
186 , a38 out nocopy JTF_VARCHAR2_TABLE_100
187 , a39 out nocopy JTF_VARCHAR2_TABLE_100
188 , a40 out nocopy JTF_DATE_TABLE
189 , a41 out nocopy JTF_NUMBER_TABLE
190 , a42 out nocopy JTF_NUMBER_TABLE
191 , a43 out nocopy JTF_DATE_TABLE
192 , a44 out nocopy JTF_NUMBER_TABLE
193 , a45 out nocopy JTF_VARCHAR2_TABLE_100
194 , a46 out nocopy JTF_NUMBER_TABLE
195 , a47 out nocopy JTF_VARCHAR2_TABLE_100
196 , a48 out nocopy JTF_NUMBER_TABLE
197 , a49 out nocopy JTF_NUMBER_TABLE
198 , a50 out nocopy JTF_NUMBER_TABLE
199 , a51 out nocopy JTF_NUMBER_TABLE
200 , a52 out nocopy JTF_VARCHAR2_TABLE_100
201 , a53 out nocopy JTF_NUMBER_TABLE
202 , a54 out nocopy JTF_NUMBER_TABLE
203 , a55 out nocopy JTF_VARCHAR2_TABLE_100
204 , a56 out nocopy JTF_NUMBER_TABLE
205 , a57 out nocopy JTF_NUMBER_TABLE
206 , a58 out nocopy JTF_VARCHAR2_TABLE_100
207 , a59 out nocopy JTF_NUMBER_TABLE
208 , a60 out nocopy JTF_NUMBER_TABLE
209 , a61 out nocopy JTF_VARCHAR2_TABLE_100
210 , a62 out nocopy JTF_NUMBER_TABLE
211 , a63 out nocopy JTF_NUMBER_TABLE
212 , a64 out nocopy JTF_NUMBER_TABLE
213 , a65 out nocopy JTF_NUMBER_TABLE
214 , a66 out nocopy JTF_NUMBER_TABLE
215 , a67 out nocopy JTF_NUMBER_TABLE
216 , a68 out nocopy JTF_DATE_TABLE
217 , a69 out nocopy JTF_VARCHAR2_TABLE_100
218 , a70 out nocopy JTF_NUMBER_TABLE
219 , a71 out nocopy JTF_NUMBER_TABLE
220 , a72 out nocopy JTF_VARCHAR2_TABLE_100
221 , a73 out nocopy JTF_NUMBER_TABLE
222 , a74 out nocopy JTF_NUMBER_TABLE
223 , a75 out nocopy JTF_DATE_TABLE
224 , a76 out nocopy JTF_VARCHAR2_TABLE_100
225 , a77 out nocopy JTF_NUMBER_TABLE
226 , a78 out nocopy JTF_VARCHAR2_TABLE_100
227 , a79 out nocopy JTF_NUMBER_TABLE
228 , a80 out nocopy JTF_VARCHAR2_TABLE_100
229 , a81 out nocopy JTF_DATE_TABLE
230 , a82 out nocopy JTF_VARCHAR2_TABLE_100
231 , a83 out nocopy JTF_VARCHAR2_TABLE_100
232 , a84 out nocopy JTF_DATE_TABLE
233 , a85 out nocopy JTF_NUMBER_TABLE
234 , a86 out nocopy JTF_DATE_TABLE
235 , a87 out nocopy JTF_NUMBER_TABLE
236 , a88 out nocopy JTF_DATE_TABLE
237 , a89 out nocopy JTF_NUMBER_TABLE
238 , a90 out nocopy JTF_NUMBER_TABLE
239 , a91 out nocopy JTF_NUMBER_TABLE
240 , a92 out nocopy JTF_NUMBER_TABLE
241 , a93 out nocopy JTF_VARCHAR2_TABLE_2000
242 , a94 out nocopy JTF_NUMBER_TABLE
243 , a95 out nocopy JTF_DATE_TABLE
244 , a96 out nocopy JTF_NUMBER_TABLE
245 , a97 out nocopy JTF_VARCHAR2_TABLE_100
246 , a98 out nocopy JTF_VARCHAR2_TABLE_100
247 , a99 out nocopy JTF_VARCHAR2_TABLE_200
248 , a100 out nocopy JTF_VARCHAR2_TABLE_200
249 , a101 out nocopy JTF_VARCHAR2_TABLE_200
250 , a102 out nocopy JTF_VARCHAR2_TABLE_200
251 , a103 out nocopy JTF_VARCHAR2_TABLE_200
252 , a104 out nocopy JTF_VARCHAR2_TABLE_200
253 , a105 out nocopy JTF_VARCHAR2_TABLE_200
254 , a106 out nocopy JTF_VARCHAR2_TABLE_200
255 , a107 out nocopy JTF_VARCHAR2_TABLE_200
256 , a108 out nocopy JTF_VARCHAR2_TABLE_200
257 , a109 out nocopy JTF_VARCHAR2_TABLE_200
258 , a110 out nocopy JTF_VARCHAR2_TABLE_200
259 , a111 out nocopy JTF_VARCHAR2_TABLE_200
260 , a112 out nocopy JTF_VARCHAR2_TABLE_200
261 , a113 out nocopy JTF_VARCHAR2_TABLE_200
262 , a114 out nocopy JTF_VARCHAR2_TABLE_100
263 , a115 out nocopy JTF_VARCHAR2_TABLE_200
264 , a116 out nocopy JTF_VARCHAR2_TABLE_200
265 , a117 out nocopy JTF_VARCHAR2_TABLE_200
266 , a118 out nocopy JTF_VARCHAR2_TABLE_200
267 , a119 out nocopy JTF_VARCHAR2_TABLE_200
268 , a120 out nocopy JTF_VARCHAR2_TABLE_200
269 , a121 out nocopy JTF_VARCHAR2_TABLE_200
270 , a122 out nocopy JTF_VARCHAR2_TABLE_200
271 , a123 out nocopy JTF_VARCHAR2_TABLE_200
272 , a124 out nocopy JTF_VARCHAR2_TABLE_200
273 , a125 out nocopy JTF_VARCHAR2_TABLE_200
274 , a126 out nocopy JTF_VARCHAR2_TABLE_200
275 , a127 out nocopy JTF_VARCHAR2_TABLE_200
276 , a128 out nocopy JTF_VARCHAR2_TABLE_200
277 , a129 out nocopy JTF_VARCHAR2_TABLE_200
278 , a130 out nocopy JTF_NUMBER_TABLE
279 , a131 out nocopy JTF_VARCHAR2_TABLE_100
280 , a132 out nocopy JTF_NUMBER_TABLE
281 , a133 out nocopy JTF_VARCHAR2_TABLE_100
282 , a134 out nocopy JTF_VARCHAR2_TABLE_100
283 , a135 out nocopy JTF_NUMBER_TABLE
284 , a136 out nocopy JTF_NUMBER_TABLE
285 , a137 out nocopy JTF_NUMBER_TABLE
286 , a138 out nocopy JTF_VARCHAR2_TABLE_100
287 , a139 out nocopy JTF_NUMBER_TABLE
288 , a140 out nocopy JTF_NUMBER_TABLE
289 , a141 out nocopy JTF_VARCHAR2_TABLE_300
290 , a142 out nocopy JTF_VARCHAR2_TABLE_300
291 , a143 out nocopy JTF_VARCHAR2_TABLE_100
292 );
293
294 procedure create_claims_history(p_api_version_number NUMBER
295 , p_init_msg_list VARCHAR2
296 , p_commit VARCHAR2
297 , p_validation_level NUMBER
298 , x_return_status out nocopy VARCHAR2
299 , x_msg_count out nocopy NUMBER
300 , x_msg_data out nocopy VARCHAR2
301 , p7_a0 NUMBER
302 , p7_a1 NUMBER
303 , p7_a2 DATE
304 , p7_a3 NUMBER
305 , p7_a4 DATE
306 , p7_a5 NUMBER
307 , p7_a6 NUMBER
308 , p7_a7 NUMBER
309 , p7_a8 NUMBER
310 , p7_a9 DATE
311 , p7_a10 NUMBER
312 , p7_a11 VARCHAR2
313 , p7_a12 NUMBER
314 , p7_a13 NUMBER
315 , p7_a14 VARCHAR2
316 , p7_a15 NUMBER
317 , p7_a16 VARCHAR2
318 , p7_a17 DATE
319 , p7_a18 DATE
320 , p7_a19 NUMBER
321 , p7_a20 VARCHAR2
322 , p7_a21 DATE
323 , p7_a22 VARCHAR2
324 , p7_a23 NUMBER
325 , p7_a24 NUMBER
326 , p7_a25 DATE
327 , p7_a26 NUMBER
328 , p7_a27 NUMBER
329 , p7_a28 NUMBER
330 , p7_a29 NUMBER
331 , p7_a30 NUMBER
332 , p7_a31 NUMBER
333 , p7_a32 NUMBER
334 , p7_a33 NUMBER
335 , p7_a34 NUMBER
336 , p7_a35 NUMBER
337 , p7_a36 VARCHAR2
338 , p7_a37 VARCHAR2
339 , p7_a38 VARCHAR2
340 , p7_a39 VARCHAR2
341 , p7_a40 DATE
342 , p7_a41 NUMBER
343 , p7_a42 NUMBER
344 , p7_a43 DATE
345 , p7_a44 NUMBER
346 , p7_a45 VARCHAR2
347 , p7_a46 NUMBER
348 , p7_a47 VARCHAR2
349 , p7_a48 NUMBER
350 , p7_a49 NUMBER
351 , p7_a50 NUMBER
352 , p7_a51 NUMBER
353 , p7_a52 VARCHAR2
354 , p7_a53 NUMBER
355 , p7_a54 NUMBER
356 , p7_a55 VARCHAR2
357 , p7_a56 NUMBER
358 , p7_a57 NUMBER
359 , p7_a58 VARCHAR2
360 , p7_a59 NUMBER
361 , p7_a60 NUMBER
362 , p7_a61 VARCHAR2
363 , p7_a62 NUMBER
364 , p7_a63 NUMBER
365 , p7_a64 NUMBER
366 , p7_a65 NUMBER
367 , p7_a66 NUMBER
368 , p7_a67 NUMBER
369 , p7_a68 DATE
370 , p7_a69 VARCHAR2
371 , p7_a70 NUMBER
372 , p7_a71 NUMBER
373 , p7_a72 VARCHAR2
374 , p7_a73 NUMBER
375 , p7_a74 NUMBER
376 , p7_a75 DATE
377 , p7_a76 VARCHAR2
378 , p7_a77 NUMBER
379 , p7_a78 VARCHAR2
380 , p7_a79 NUMBER
381 , p7_a80 VARCHAR2
382 , p7_a81 DATE
383 , p7_a82 VARCHAR2
384 , p7_a83 VARCHAR2
385 , p7_a84 DATE
386 , p7_a85 NUMBER
387 , p7_a86 DATE
388 , p7_a87 NUMBER
389 , p7_a88 DATE
390 , p7_a89 NUMBER
391 , p7_a90 NUMBER
392 , p7_a91 NUMBER
393 , p7_a92 NUMBER
394 , p7_a93 VARCHAR2
395 , p7_a94 NUMBER
396 , p7_a95 DATE
397 , p7_a96 NUMBER
398 , p7_a97 VARCHAR2
399 , p7_a98 VARCHAR2
400 , p7_a99 VARCHAR2
401 , p7_a100 VARCHAR2
402 , p7_a101 VARCHAR2
403 , p7_a102 VARCHAR2
404 , p7_a103 VARCHAR2
405 , p7_a104 VARCHAR2
406 , p7_a105 VARCHAR2
407 , p7_a106 VARCHAR2
408 , p7_a107 VARCHAR2
409 , p7_a108 VARCHAR2
410 , p7_a109 VARCHAR2
411 , p7_a110 VARCHAR2
412 , p7_a111 VARCHAR2
413 , p7_a112 VARCHAR2
414 , p7_a113 VARCHAR2
415 , p7_a114 VARCHAR2
416 , p7_a115 VARCHAR2
417 , p7_a116 VARCHAR2
418 , p7_a117 VARCHAR2
419 , p7_a118 VARCHAR2
420 , p7_a119 VARCHAR2
421 , p7_a120 VARCHAR2
422 , p7_a121 VARCHAR2
423 , p7_a122 VARCHAR2
424 , p7_a123 VARCHAR2
425 , p7_a124 VARCHAR2
426 , p7_a125 VARCHAR2
427 , p7_a126 VARCHAR2
428 , p7_a127 VARCHAR2
429 , p7_a128 VARCHAR2
430 , p7_a129 VARCHAR2
431 , p7_a130 NUMBER
432 , p7_a131 VARCHAR2
433 , p7_a132 NUMBER
434 , p7_a133 VARCHAR2
435 , p7_a134 VARCHAR2
436 , p7_a135 NUMBER
437 , p7_a136 NUMBER
438 , p7_a137 NUMBER
439 , p7_a138 VARCHAR2
440 , p7_a139 NUMBER
441 , p7_a140 NUMBER
442 , p7_a141 VARCHAR2
443 , p7_a142 VARCHAR2
444 , p7_a143 VARCHAR2
445 , x_claim_history_id out nocopy NUMBER
446 );
447 procedure update_claims_history(p_api_version_number NUMBER
448 , p_init_msg_list VARCHAR2
449 , p_commit VARCHAR2
450 , p_validation_level NUMBER
451 , x_return_status out nocopy VARCHAR2
452 , x_msg_count out nocopy NUMBER
453 , x_msg_data out nocopy VARCHAR2
454 , p7_a0 NUMBER
455 , p7_a1 NUMBER
456 , p7_a2 DATE
457 , p7_a3 NUMBER
458 , p7_a4 DATE
459 , p7_a5 NUMBER
460 , p7_a6 NUMBER
461 , p7_a7 NUMBER
462 , p7_a8 NUMBER
463 , p7_a9 DATE
464 , p7_a10 NUMBER
465 , p7_a11 VARCHAR2
466 , p7_a12 NUMBER
467 , p7_a13 NUMBER
468 , p7_a14 VARCHAR2
469 , p7_a15 NUMBER
470 , p7_a16 VARCHAR2
471 , p7_a17 DATE
472 , p7_a18 DATE
473 , p7_a19 NUMBER
474 , p7_a20 VARCHAR2
475 , p7_a21 DATE
476 , p7_a22 VARCHAR2
477 , p7_a23 NUMBER
478 , p7_a24 NUMBER
479 , p7_a25 DATE
480 , p7_a26 NUMBER
481 , p7_a27 NUMBER
482 , p7_a28 NUMBER
483 , p7_a29 NUMBER
484 , p7_a30 NUMBER
485 , p7_a31 NUMBER
486 , p7_a32 NUMBER
487 , p7_a33 NUMBER
488 , p7_a34 NUMBER
489 , p7_a35 NUMBER
490 , p7_a36 VARCHAR2
491 , p7_a37 VARCHAR2
492 , p7_a38 VARCHAR2
493 , p7_a39 VARCHAR2
494 , p7_a40 DATE
495 , p7_a41 NUMBER
496 , p7_a42 NUMBER
497 , p7_a43 DATE
498 , p7_a44 NUMBER
499 , p7_a45 VARCHAR2
500 , p7_a46 NUMBER
501 , p7_a47 VARCHAR2
502 , p7_a48 NUMBER
503 , p7_a49 NUMBER
504 , p7_a50 NUMBER
505 , p7_a51 NUMBER
506 , p7_a52 VARCHAR2
507 , p7_a53 NUMBER
508 , p7_a54 NUMBER
509 , p7_a55 VARCHAR2
510 , p7_a56 NUMBER
511 , p7_a57 NUMBER
512 , p7_a58 VARCHAR2
513 , p7_a59 NUMBER
514 , p7_a60 NUMBER
515 , p7_a61 VARCHAR2
516 , p7_a62 NUMBER
517 , p7_a63 NUMBER
518 , p7_a64 NUMBER
519 , p7_a65 NUMBER
520 , p7_a66 NUMBER
521 , p7_a67 NUMBER
522 , p7_a68 DATE
523 , p7_a69 VARCHAR2
524 , p7_a70 NUMBER
525 , p7_a71 NUMBER
526 , p7_a72 VARCHAR2
527 , p7_a73 NUMBER
528 , p7_a74 NUMBER
529 , p7_a75 DATE
530 , p7_a76 VARCHAR2
531 , p7_a77 NUMBER
532 , p7_a78 VARCHAR2
533 , p7_a79 NUMBER
534 , p7_a80 VARCHAR2
535 , p7_a81 DATE
536 , p7_a82 VARCHAR2
537 , p7_a83 VARCHAR2
538 , p7_a84 DATE
539 , p7_a85 NUMBER
540 , p7_a86 DATE
541 , p7_a87 NUMBER
542 , p7_a88 DATE
543 , p7_a89 NUMBER
544 , p7_a90 NUMBER
545 , p7_a91 NUMBER
546 , p7_a92 NUMBER
547 , p7_a93 VARCHAR2
548 , p7_a94 NUMBER
549 , p7_a95 DATE
550 , p7_a96 NUMBER
551 , p7_a97 VARCHAR2
552 , p7_a98 VARCHAR2
553 , p7_a99 VARCHAR2
554 , p7_a100 VARCHAR2
555 , p7_a101 VARCHAR2
556 , p7_a102 VARCHAR2
557 , p7_a103 VARCHAR2
558 , p7_a104 VARCHAR2
559 , p7_a105 VARCHAR2
560 , p7_a106 VARCHAR2
561 , p7_a107 VARCHAR2
562 , p7_a108 VARCHAR2
563 , p7_a109 VARCHAR2
564 , p7_a110 VARCHAR2
565 , p7_a111 VARCHAR2
566 , p7_a112 VARCHAR2
567 , p7_a113 VARCHAR2
568 , p7_a114 VARCHAR2
569 , p7_a115 VARCHAR2
570 , p7_a116 VARCHAR2
571 , p7_a117 VARCHAR2
572 , p7_a118 VARCHAR2
573 , p7_a119 VARCHAR2
574 , p7_a120 VARCHAR2
575 , p7_a121 VARCHAR2
576 , p7_a122 VARCHAR2
577 , p7_a123 VARCHAR2
578 , p7_a124 VARCHAR2
579 , p7_a125 VARCHAR2
580 , p7_a126 VARCHAR2
581 , p7_a127 VARCHAR2
582 , p7_a128 VARCHAR2
583 , p7_a129 VARCHAR2
584 , p7_a130 NUMBER
585 , p7_a131 VARCHAR2
586 , p7_a132 NUMBER
587 , p7_a133 VARCHAR2
588 , p7_a134 VARCHAR2
589 , p7_a135 NUMBER
590 , p7_a136 NUMBER
591 , p7_a137 NUMBER
592 , p7_a138 VARCHAR2
593 , p7_a139 NUMBER
594 , p7_a140 NUMBER
595 , p7_a141 VARCHAR2
596 , p7_a142 VARCHAR2
597 , p7_a143 VARCHAR2
598 , x_object_version_number out nocopy NUMBER
599 );
600 procedure validate_claims_history(p_api_version_number NUMBER
601 , p_init_msg_list VARCHAR2
602 , p_validation_level NUMBER
603 , p3_a0 NUMBER
604 , p3_a1 NUMBER
605 , p3_a2 DATE
606 , p3_a3 NUMBER
607 , p3_a4 DATE
608 , p3_a5 NUMBER
609 , p3_a6 NUMBER
610 , p3_a7 NUMBER
611 , p3_a8 NUMBER
612 , p3_a9 DATE
613 , p3_a10 NUMBER
614 , p3_a11 VARCHAR2
615 , p3_a12 NUMBER
616 , p3_a13 NUMBER
617 , p3_a14 VARCHAR2
618 , p3_a15 NUMBER
619 , p3_a16 VARCHAR2
620 , p3_a17 DATE
621 , p3_a18 DATE
622 , p3_a19 NUMBER
623 , p3_a20 VARCHAR2
624 , p3_a21 DATE
625 , p3_a22 VARCHAR2
626 , p3_a23 NUMBER
627 , p3_a24 NUMBER
628 , p3_a25 DATE
629 , p3_a26 NUMBER
630 , p3_a27 NUMBER
631 , p3_a28 NUMBER
632 , p3_a29 NUMBER
633 , p3_a30 NUMBER
634 , p3_a31 NUMBER
635 , p3_a32 NUMBER
636 , p3_a33 NUMBER
637 , p3_a34 NUMBER
638 , p3_a35 NUMBER
639 , p3_a36 VARCHAR2
640 , p3_a37 VARCHAR2
641 , p3_a38 VARCHAR2
642 , p3_a39 VARCHAR2
643 , p3_a40 DATE
644 , p3_a41 NUMBER
645 , p3_a42 NUMBER
646 , p3_a43 DATE
647 , p3_a44 NUMBER
648 , p3_a45 VARCHAR2
649 , p3_a46 NUMBER
650 , p3_a47 VARCHAR2
651 , p3_a48 NUMBER
652 , p3_a49 NUMBER
653 , p3_a50 NUMBER
654 , p3_a51 NUMBER
655 , p3_a52 VARCHAR2
656 , p3_a53 NUMBER
657 , p3_a54 NUMBER
658 , p3_a55 VARCHAR2
659 , p3_a56 NUMBER
660 , p3_a57 NUMBER
661 , p3_a58 VARCHAR2
662 , p3_a59 NUMBER
663 , p3_a60 NUMBER
664 , p3_a61 VARCHAR2
665 , p3_a62 NUMBER
666 , p3_a63 NUMBER
667 , p3_a64 NUMBER
668 , p3_a65 NUMBER
669 , p3_a66 NUMBER
670 , p3_a67 NUMBER
671 , p3_a68 DATE
672 , p3_a69 VARCHAR2
673 , p3_a70 NUMBER
674 , p3_a71 NUMBER
675 , p3_a72 VARCHAR2
676 , p3_a73 NUMBER
677 , p3_a74 NUMBER
678 , p3_a75 DATE
679 , p3_a76 VARCHAR2
680 , p3_a77 NUMBER
681 , p3_a78 VARCHAR2
682 , p3_a79 NUMBER
683 , p3_a80 VARCHAR2
684 , p3_a81 DATE
685 , p3_a82 VARCHAR2
686 , p3_a83 VARCHAR2
687 , p3_a84 DATE
688 , p3_a85 NUMBER
689 , p3_a86 DATE
690 , p3_a87 NUMBER
691 , p3_a88 DATE
692 , p3_a89 NUMBER
693 , p3_a90 NUMBER
694 , p3_a91 NUMBER
695 , p3_a92 NUMBER
696 , p3_a93 VARCHAR2
697 , p3_a94 NUMBER
698 , p3_a95 DATE
699 , p3_a96 NUMBER
700 , p3_a97 VARCHAR2
701 , p3_a98 VARCHAR2
702 , p3_a99 VARCHAR2
703 , p3_a100 VARCHAR2
704 , p3_a101 VARCHAR2
705 , p3_a102 VARCHAR2
706 , p3_a103 VARCHAR2
707 , p3_a104 VARCHAR2
708 , p3_a105 VARCHAR2
709 , p3_a106 VARCHAR2
710 , p3_a107 VARCHAR2
711 , p3_a108 VARCHAR2
712 , p3_a109 VARCHAR2
713 , p3_a110 VARCHAR2
714 , p3_a111 VARCHAR2
715 , p3_a112 VARCHAR2
716 , p3_a113 VARCHAR2
717 , p3_a114 VARCHAR2
718 , p3_a115 VARCHAR2
719 , p3_a116 VARCHAR2
720 , p3_a117 VARCHAR2
721 , p3_a118 VARCHAR2
722 , p3_a119 VARCHAR2
723 , p3_a120 VARCHAR2
724 , p3_a121 VARCHAR2
725 , p3_a122 VARCHAR2
726 , p3_a123 VARCHAR2
727 , p3_a124 VARCHAR2
728 , p3_a125 VARCHAR2
729 , p3_a126 VARCHAR2
730 , p3_a127 VARCHAR2
731 , p3_a128 VARCHAR2
732 , p3_a129 VARCHAR2
733 , p3_a130 NUMBER
734 , p3_a131 VARCHAR2
735 , p3_a132 NUMBER
736 , p3_a133 VARCHAR2
737 , p3_a134 VARCHAR2
738 , p3_a135 NUMBER
739 , p3_a136 NUMBER
740 , p3_a137 NUMBER
741 , p3_a138 VARCHAR2
742 , p3_a139 NUMBER
743 , p3_a140 NUMBER
744 , p3_a141 VARCHAR2
745 , p3_a142 VARCHAR2
746 , p3_a143 VARCHAR2
747 , x_return_status out nocopy VARCHAR2
748 , x_msg_count out nocopy NUMBER
749 , x_msg_data out nocopy VARCHAR2
750 );
751 end ozf_claims_history_pvt_w;