[Home] [Help]
PACKAGE: APPS.OKL_FE_ADJ_MATRIX_PUB_W
Source
1 package okl_fe_adj_matrix_pub_w as
2 /* $Header: OKLUPAMS.pls 120.0 2005/07/07 10:46:30 viselvar noship $ */
3 procedure get_version(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 , p_adj_mat_id NUMBER
9 , p_version_number NUMBER
10 , p7_a0 out nocopy NUMBER
11 , p7_a1 out nocopy NUMBER
12 , p7_a2 out nocopy NUMBER
13 , p7_a3 out nocopy VARCHAR2
14 , p7_a4 out nocopy VARCHAR2
15 , p7_a5 out nocopy NUMBER
16 , p7_a6 out nocopy VARCHAR2
17 , p7_a7 out nocopy DATE
18 , p7_a8 out nocopy DATE
19 , p7_a9 out nocopy VARCHAR2
20 , p7_a10 out nocopy VARCHAR2
21 , p7_a11 out nocopy VARCHAR2
22 , p7_a12 out nocopy VARCHAR2
23 , p7_a13 out nocopy VARCHAR2
24 , p7_a14 out nocopy VARCHAR2
25 , p7_a15 out nocopy VARCHAR2
26 , p7_a16 out nocopy VARCHAR2
27 , p7_a17 out nocopy VARCHAR2
28 , p7_a18 out nocopy VARCHAR2
29 , p7_a19 out nocopy VARCHAR2
30 , p7_a20 out nocopy VARCHAR2
31 , p7_a21 out nocopy VARCHAR2
32 , p7_a22 out nocopy VARCHAR2
33 , p7_a23 out nocopy VARCHAR2
34 , p7_a24 out nocopy VARCHAR2
35 , p7_a25 out nocopy NUMBER
36 , p7_a26 out nocopy DATE
37 , p7_a27 out nocopy NUMBER
38 , p7_a28 out nocopy DATE
39 , p7_a29 out nocopy NUMBER
40 , p7_a30 out nocopy VARCHAR2
41 , p7_a31 out nocopy VARCHAR2
42 , p8_a0 out nocopy NUMBER
43 , p8_a1 out nocopy NUMBER
44 , p8_a2 out nocopy VARCHAR2
45 , p8_a3 out nocopy NUMBER
46 , p8_a4 out nocopy VARCHAR2
47 , p8_a5 out nocopy DATE
48 , p8_a6 out nocopy DATE
49 , p8_a7 out nocopy VARCHAR2
50 , p8_a8 out nocopy VARCHAR2
51 , p8_a9 out nocopy VARCHAR2
52 , p8_a10 out nocopy VARCHAR2
53 , p8_a11 out nocopy VARCHAR2
54 , p8_a12 out nocopy VARCHAR2
55 , p8_a13 out nocopy VARCHAR2
56 , p8_a14 out nocopy VARCHAR2
57 , p8_a15 out nocopy VARCHAR2
58 , p8_a16 out nocopy VARCHAR2
59 , p8_a17 out nocopy VARCHAR2
60 , p8_a18 out nocopy VARCHAR2
61 , p8_a19 out nocopy VARCHAR2
62 , p8_a20 out nocopy VARCHAR2
63 , p8_a21 out nocopy VARCHAR2
64 , p8_a22 out nocopy VARCHAR2
65 , p8_a23 out nocopy NUMBER
66 , p8_a24 out nocopy DATE
67 , p8_a25 out nocopy NUMBER
68 , p8_a26 out nocopy DATE
69 , p8_a27 out nocopy NUMBER
70 , p9_a0 out nocopy NUMBER
71 , p9_a1 out nocopy NUMBER
72 , p9_a2 out nocopy NUMBER
73 , p9_a3 out nocopy VARCHAR2
74 , p9_a4 out nocopy VARCHAR2
75 , p9_a5 out nocopy VARCHAR2
76 , p9_a6 out nocopy NUMBER
77 , p9_a7 out nocopy DATE
78 , p9_a8 out nocopy NUMBER
79 , p9_a9 out nocopy DATE
80 , p9_a10 out nocopy NUMBER
81 , p10_a0 out nocopy JTF_NUMBER_TABLE
82 , p10_a1 out nocopy JTF_NUMBER_TABLE
83 , p10_a2 out nocopy JTF_NUMBER_TABLE
84 , p10_a3 out nocopy JTF_NUMBER_TABLE
85 , p10_a4 out nocopy JTF_DATE_TABLE
86 , p10_a5 out nocopy JTF_DATE_TABLE
87 , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
88 , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
89 , p10_a8 out nocopy JTF_NUMBER_TABLE
90 , p10_a9 out nocopy JTF_DATE_TABLE
91 , p10_a10 out nocopy JTF_NUMBER_TABLE
92 , p10_a11 out nocopy JTF_DATE_TABLE
93 , p10_a12 out nocopy JTF_NUMBER_TABLE
94 , p11_a0 out nocopy JTF_NUMBER_TABLE
95 , p11_a1 out nocopy JTF_NUMBER_TABLE
96 , p11_a2 out nocopy JTF_NUMBER_TABLE
97 , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
98 , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
99 , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
100 , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
101 , p11_a7 out nocopy JTF_VARCHAR2_TABLE_300
102 , p11_a8 out nocopy JTF_VARCHAR2_TABLE_300
103 , p11_a9 out nocopy JTF_NUMBER_TABLE
104 , p11_a10 out nocopy JTF_NUMBER_TABLE
105 , p11_a11 out nocopy JTF_DATE_TABLE
106 , p11_a12 out nocopy JTF_DATE_TABLE
107 , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100
108 , p11_a14 out nocopy JTF_NUMBER_TABLE
109 , p11_a15 out nocopy JTF_NUMBER_TABLE
110 , p11_a16 out nocopy JTF_DATE_TABLE
111 , p11_a17 out nocopy JTF_NUMBER_TABLE
112 , p11_a18 out nocopy JTF_DATE_TABLE
113 , p11_a19 out nocopy JTF_NUMBER_TABLE
114 , p11_a20 out nocopy JTF_VARCHAR2_TABLE_100
115 , p11_a21 out nocopy JTF_VARCHAR2_TABLE_500
116 , p11_a22 out nocopy JTF_VARCHAR2_TABLE_500
117 , p11_a23 out nocopy JTF_VARCHAR2_TABLE_500
118 , p11_a24 out nocopy JTF_VARCHAR2_TABLE_500
119 , p11_a25 out nocopy JTF_VARCHAR2_TABLE_500
120 , p11_a26 out nocopy JTF_VARCHAR2_TABLE_500
121 , p11_a27 out nocopy JTF_VARCHAR2_TABLE_500
122 , p11_a28 out nocopy JTF_VARCHAR2_TABLE_500
123 , p11_a29 out nocopy JTF_VARCHAR2_TABLE_500
124 , p11_a30 out nocopy JTF_VARCHAR2_TABLE_500
125 , p11_a31 out nocopy JTF_VARCHAR2_TABLE_500
126 , p11_a32 out nocopy JTF_VARCHAR2_TABLE_500
127 , p11_a33 out nocopy JTF_VARCHAR2_TABLE_500
128 , p11_a34 out nocopy JTF_VARCHAR2_TABLE_500
129 , p11_a35 out nocopy JTF_VARCHAR2_TABLE_500
130 );
131 procedure get_version(p_api_version NUMBER
132 , p_init_msg_list VARCHAR2
133 , x_return_status out nocopy VARCHAR2
134 , x_msg_count out nocopy NUMBER
135 , x_msg_data out nocopy VARCHAR2
136 , p_adj_mat_id NUMBER
137 , p6_a0 out nocopy NUMBER
138 , p6_a1 out nocopy NUMBER
139 , p6_a2 out nocopy NUMBER
140 , p6_a3 out nocopy VARCHAR2
141 , p6_a4 out nocopy VARCHAR2
142 , p6_a5 out nocopy NUMBER
143 , p6_a6 out nocopy VARCHAR2
144 , p6_a7 out nocopy DATE
145 , p6_a8 out nocopy DATE
146 , p6_a9 out nocopy VARCHAR2
147 , p6_a10 out nocopy VARCHAR2
148 , p6_a11 out nocopy VARCHAR2
149 , p6_a12 out nocopy VARCHAR2
150 , p6_a13 out nocopy VARCHAR2
151 , p6_a14 out nocopy VARCHAR2
152 , p6_a15 out nocopy VARCHAR2
153 , p6_a16 out nocopy VARCHAR2
154 , p6_a17 out nocopy VARCHAR2
155 , p6_a18 out nocopy VARCHAR2
156 , p6_a19 out nocopy VARCHAR2
157 , p6_a20 out nocopy VARCHAR2
158 , p6_a21 out nocopy VARCHAR2
159 , p6_a22 out nocopy VARCHAR2
160 , p6_a23 out nocopy VARCHAR2
161 , p6_a24 out nocopy VARCHAR2
162 , p6_a25 out nocopy NUMBER
163 , p6_a26 out nocopy DATE
164 , p6_a27 out nocopy NUMBER
165 , p6_a28 out nocopy DATE
166 , p6_a29 out nocopy NUMBER
167 , p6_a30 out nocopy VARCHAR2
168 , p6_a31 out nocopy VARCHAR2
169 , p7_a0 out nocopy NUMBER
170 , p7_a1 out nocopy NUMBER
171 , p7_a2 out nocopy VARCHAR2
172 , p7_a3 out nocopy NUMBER
173 , p7_a4 out nocopy VARCHAR2
174 , p7_a5 out nocopy DATE
175 , p7_a6 out nocopy DATE
176 , p7_a7 out nocopy VARCHAR2
177 , p7_a8 out nocopy VARCHAR2
178 , p7_a9 out nocopy VARCHAR2
179 , p7_a10 out nocopy VARCHAR2
180 , p7_a11 out nocopy VARCHAR2
181 , p7_a12 out nocopy VARCHAR2
182 , p7_a13 out nocopy VARCHAR2
183 , p7_a14 out nocopy VARCHAR2
184 , p7_a15 out nocopy VARCHAR2
185 , p7_a16 out nocopy VARCHAR2
186 , p7_a17 out nocopy VARCHAR2
187 , p7_a18 out nocopy VARCHAR2
188 , p7_a19 out nocopy VARCHAR2
189 , p7_a20 out nocopy VARCHAR2
190 , p7_a21 out nocopy VARCHAR2
191 , p7_a22 out nocopy VARCHAR2
192 , p7_a23 out nocopy NUMBER
193 , p7_a24 out nocopy DATE
194 , p7_a25 out nocopy NUMBER
195 , p7_a26 out nocopy DATE
196 , p7_a27 out nocopy NUMBER
197 , p8_a0 out nocopy NUMBER
198 , p8_a1 out nocopy NUMBER
199 , p8_a2 out nocopy NUMBER
200 , p8_a3 out nocopy VARCHAR2
201 , p8_a4 out nocopy VARCHAR2
202 , p8_a5 out nocopy VARCHAR2
203 , p8_a6 out nocopy NUMBER
204 , p8_a7 out nocopy DATE
205 , p8_a8 out nocopy NUMBER
206 , p8_a9 out nocopy DATE
207 , p8_a10 out nocopy NUMBER
208 , p9_a0 out nocopy JTF_NUMBER_TABLE
209 , p9_a1 out nocopy JTF_NUMBER_TABLE
210 , p9_a2 out nocopy JTF_NUMBER_TABLE
211 , p9_a3 out nocopy JTF_NUMBER_TABLE
212 , p9_a4 out nocopy JTF_DATE_TABLE
213 , p9_a5 out nocopy JTF_DATE_TABLE
214 , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
215 , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
216 , p9_a8 out nocopy JTF_NUMBER_TABLE
217 , p9_a9 out nocopy JTF_DATE_TABLE
218 , p9_a10 out nocopy JTF_NUMBER_TABLE
219 , p9_a11 out nocopy JTF_DATE_TABLE
220 , p9_a12 out nocopy JTF_NUMBER_TABLE
221 , p10_a0 out nocopy JTF_NUMBER_TABLE
222 , p10_a1 out nocopy JTF_NUMBER_TABLE
223 , p10_a2 out nocopy JTF_NUMBER_TABLE
224 , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
225 , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
226 , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
227 , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
228 , p10_a7 out nocopy JTF_VARCHAR2_TABLE_300
229 , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300
230 , p10_a9 out nocopy JTF_NUMBER_TABLE
231 , p10_a10 out nocopy JTF_NUMBER_TABLE
232 , p10_a11 out nocopy JTF_DATE_TABLE
233 , p10_a12 out nocopy JTF_DATE_TABLE
234 , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
235 , p10_a14 out nocopy JTF_NUMBER_TABLE
236 , p10_a15 out nocopy JTF_NUMBER_TABLE
237 , p10_a16 out nocopy JTF_DATE_TABLE
238 , p10_a17 out nocopy JTF_NUMBER_TABLE
239 , p10_a18 out nocopy JTF_DATE_TABLE
240 , p10_a19 out nocopy JTF_NUMBER_TABLE
241 , p10_a20 out nocopy JTF_VARCHAR2_TABLE_100
242 , p10_a21 out nocopy JTF_VARCHAR2_TABLE_500
243 , p10_a22 out nocopy JTF_VARCHAR2_TABLE_500
244 , p10_a23 out nocopy JTF_VARCHAR2_TABLE_500
245 , p10_a24 out nocopy JTF_VARCHAR2_TABLE_500
246 , p10_a25 out nocopy JTF_VARCHAR2_TABLE_500
247 , p10_a26 out nocopy JTF_VARCHAR2_TABLE_500
248 , p10_a27 out nocopy JTF_VARCHAR2_TABLE_500
249 , p10_a28 out nocopy JTF_VARCHAR2_TABLE_500
250 , p10_a29 out nocopy JTF_VARCHAR2_TABLE_500
251 , p10_a30 out nocopy JTF_VARCHAR2_TABLE_500
252 , p10_a31 out nocopy JTF_VARCHAR2_TABLE_500
253 , p10_a32 out nocopy JTF_VARCHAR2_TABLE_500
254 , p10_a33 out nocopy JTF_VARCHAR2_TABLE_500
255 , p10_a34 out nocopy JTF_VARCHAR2_TABLE_500
256 , p10_a35 out nocopy JTF_VARCHAR2_TABLE_500
257 );
258 procedure create_version(p_api_version NUMBER
259 , p_init_msg_list VARCHAR2
260 , x_return_status out nocopy VARCHAR2
261 , x_msg_count out nocopy NUMBER
262 , x_msg_data out nocopy VARCHAR2
263 , p5_a0 NUMBER
264 , p5_a1 NUMBER
265 , p5_a2 VARCHAR2
266 , p5_a3 NUMBER
267 , p5_a4 VARCHAR2
268 , p5_a5 DATE
269 , p5_a6 DATE
270 , p5_a7 VARCHAR2
271 , p5_a8 VARCHAR2
272 , p5_a9 VARCHAR2
273 , p5_a10 VARCHAR2
274 , p5_a11 VARCHAR2
275 , p5_a12 VARCHAR2
276 , p5_a13 VARCHAR2
277 , p5_a14 VARCHAR2
278 , p5_a15 VARCHAR2
279 , p5_a16 VARCHAR2
280 , p5_a17 VARCHAR2
281 , p5_a18 VARCHAR2
282 , p5_a19 VARCHAR2
283 , p5_a20 VARCHAR2
284 , p5_a21 VARCHAR2
285 , p5_a22 VARCHAR2
286 , p5_a23 NUMBER
287 , p5_a24 DATE
288 , p5_a25 NUMBER
289 , p5_a26 DATE
290 , p5_a27 NUMBER
291 , p6_a0 out nocopy NUMBER
292 , p6_a1 out nocopy NUMBER
293 , p6_a2 out nocopy VARCHAR2
294 , p6_a3 out nocopy NUMBER
295 , p6_a4 out nocopy VARCHAR2
296 , p6_a5 out nocopy DATE
297 , p6_a6 out nocopy DATE
298 , p6_a7 out nocopy VARCHAR2
299 , p6_a8 out nocopy VARCHAR2
300 , p6_a9 out nocopy VARCHAR2
301 , p6_a10 out nocopy VARCHAR2
302 , p6_a11 out nocopy VARCHAR2
303 , p6_a12 out nocopy VARCHAR2
304 , p6_a13 out nocopy VARCHAR2
305 , p6_a14 out nocopy VARCHAR2
306 , p6_a15 out nocopy VARCHAR2
307 , p6_a16 out nocopy VARCHAR2
308 , p6_a17 out nocopy VARCHAR2
309 , p6_a18 out nocopy VARCHAR2
310 , p6_a19 out nocopy VARCHAR2
311 , p6_a20 out nocopy VARCHAR2
312 , p6_a21 out nocopy VARCHAR2
313 , p6_a22 out nocopy VARCHAR2
314 , p6_a23 out nocopy NUMBER
315 , p6_a24 out nocopy DATE
316 , p6_a25 out nocopy NUMBER
317 , p6_a26 out nocopy DATE
318 , p6_a27 out nocopy NUMBER
319 );
320 procedure insert_adj_mat(p_api_version NUMBER
321 , p_init_msg_list VARCHAR2
322 , x_return_status out nocopy VARCHAR2
323 , x_msg_count out nocopy NUMBER
324 , x_msg_data out nocopy VARCHAR2
325 , p5_a0 NUMBER
326 , p5_a1 NUMBER
327 , p5_a2 NUMBER
328 , p5_a3 VARCHAR2
329 , p5_a4 VARCHAR2
330 , p5_a5 NUMBER
331 , p5_a6 VARCHAR2
332 , p5_a7 DATE
333 , p5_a8 DATE
334 , p5_a9 VARCHAR2
335 , p5_a10 VARCHAR2
336 , p5_a11 VARCHAR2
337 , p5_a12 VARCHAR2
338 , p5_a13 VARCHAR2
339 , p5_a14 VARCHAR2
340 , p5_a15 VARCHAR2
341 , p5_a16 VARCHAR2
342 , p5_a17 VARCHAR2
343 , p5_a18 VARCHAR2
344 , p5_a19 VARCHAR2
345 , p5_a20 VARCHAR2
346 , p5_a21 VARCHAR2
347 , p5_a22 VARCHAR2
348 , p5_a23 VARCHAR2
349 , p5_a24 VARCHAR2
350 , p5_a25 NUMBER
351 , p5_a26 DATE
352 , p5_a27 NUMBER
353 , p5_a28 DATE
354 , p5_a29 NUMBER
355 , p5_a30 VARCHAR2
356 , p5_a31 VARCHAR2
357 , p6_a0 NUMBER
358 , p6_a1 NUMBER
359 , p6_a2 VARCHAR2
360 , p6_a3 NUMBER
361 , p6_a4 VARCHAR2
362 , p6_a5 DATE
363 , p6_a6 DATE
364 , p6_a7 VARCHAR2
365 , p6_a8 VARCHAR2
366 , p6_a9 VARCHAR2
367 , p6_a10 VARCHAR2
368 , p6_a11 VARCHAR2
369 , p6_a12 VARCHAR2
370 , p6_a13 VARCHAR2
371 , p6_a14 VARCHAR2
372 , p6_a15 VARCHAR2
373 , p6_a16 VARCHAR2
374 , p6_a17 VARCHAR2
375 , p6_a18 VARCHAR2
376 , p6_a19 VARCHAR2
377 , p6_a20 VARCHAR2
378 , p6_a21 VARCHAR2
379 , p6_a22 VARCHAR2
380 , p6_a23 NUMBER
381 , p6_a24 DATE
382 , p6_a25 NUMBER
383 , p6_a26 DATE
384 , p6_a27 NUMBER
385 , p7_a0 out nocopy NUMBER
386 , p7_a1 out nocopy NUMBER
387 , p7_a2 out nocopy NUMBER
388 , p7_a3 out nocopy VARCHAR2
389 , p7_a4 out nocopy VARCHAR2
390 , p7_a5 out nocopy NUMBER
391 , p7_a6 out nocopy VARCHAR2
392 , p7_a7 out nocopy DATE
393 , p7_a8 out nocopy DATE
394 , p7_a9 out nocopy VARCHAR2
395 , p7_a10 out nocopy VARCHAR2
396 , p7_a11 out nocopy VARCHAR2
397 , p7_a12 out nocopy VARCHAR2
398 , p7_a13 out nocopy VARCHAR2
399 , p7_a14 out nocopy VARCHAR2
400 , p7_a15 out nocopy VARCHAR2
401 , p7_a16 out nocopy VARCHAR2
402 , p7_a17 out nocopy VARCHAR2
403 , p7_a18 out nocopy VARCHAR2
404 , p7_a19 out nocopy VARCHAR2
405 , p7_a20 out nocopy VARCHAR2
406 , p7_a21 out nocopy VARCHAR2
407 , p7_a22 out nocopy VARCHAR2
408 , p7_a23 out nocopy VARCHAR2
409 , p7_a24 out nocopy VARCHAR2
410 , p7_a25 out nocopy NUMBER
411 , p7_a26 out nocopy DATE
412 , p7_a27 out nocopy NUMBER
413 , p7_a28 out nocopy DATE
414 , p7_a29 out nocopy NUMBER
415 , p7_a30 out nocopy VARCHAR2
416 , p7_a31 out nocopy VARCHAR2
417 , p8_a0 out nocopy NUMBER
418 , p8_a1 out nocopy NUMBER
419 , p8_a2 out nocopy VARCHAR2
420 , p8_a3 out nocopy NUMBER
421 , p8_a4 out nocopy VARCHAR2
422 , p8_a5 out nocopy DATE
423 , p8_a6 out nocopy DATE
424 , p8_a7 out nocopy VARCHAR2
425 , p8_a8 out nocopy VARCHAR2
426 , p8_a9 out nocopy VARCHAR2
427 , p8_a10 out nocopy VARCHAR2
428 , p8_a11 out nocopy VARCHAR2
429 , p8_a12 out nocopy VARCHAR2
430 , p8_a13 out nocopy VARCHAR2
431 , p8_a14 out nocopy VARCHAR2
432 , p8_a15 out nocopy VARCHAR2
433 , p8_a16 out nocopy VARCHAR2
434 , p8_a17 out nocopy VARCHAR2
435 , p8_a18 out nocopy VARCHAR2
436 , p8_a19 out nocopy VARCHAR2
437 , p8_a20 out nocopy VARCHAR2
438 , p8_a21 out nocopy VARCHAR2
439 , p8_a22 out nocopy VARCHAR2
440 , p8_a23 out nocopy NUMBER
441 , p8_a24 out nocopy DATE
442 , p8_a25 out nocopy NUMBER
443 , p8_a26 out nocopy DATE
444 , p8_a27 out nocopy NUMBER
445 );
446 procedure update_adj_mat(p_api_version NUMBER
447 , p_init_msg_list VARCHAR2
448 , x_return_status out nocopy VARCHAR2
449 , x_msg_count out nocopy NUMBER
450 , x_msg_data out nocopy VARCHAR2
451 , p5_a0 NUMBER
452 , p5_a1 NUMBER
453 , p5_a2 VARCHAR2
454 , p5_a3 NUMBER
455 , p5_a4 VARCHAR2
456 , p5_a5 DATE
457 , p5_a6 DATE
458 , p5_a7 VARCHAR2
459 , p5_a8 VARCHAR2
460 , p5_a9 VARCHAR2
461 , p5_a10 VARCHAR2
462 , p5_a11 VARCHAR2
463 , p5_a12 VARCHAR2
464 , p5_a13 VARCHAR2
465 , p5_a14 VARCHAR2
466 , p5_a15 VARCHAR2
467 , p5_a16 VARCHAR2
468 , p5_a17 VARCHAR2
469 , p5_a18 VARCHAR2
470 , p5_a19 VARCHAR2
471 , p5_a20 VARCHAR2
472 , p5_a21 VARCHAR2
473 , p5_a22 VARCHAR2
474 , p5_a23 NUMBER
475 , p5_a24 DATE
476 , p5_a25 NUMBER
477 , p5_a26 DATE
478 , p5_a27 NUMBER
479 , p6_a0 out nocopy NUMBER
480 , p6_a1 out nocopy NUMBER
481 , p6_a2 out nocopy VARCHAR2
482 , p6_a3 out nocopy NUMBER
483 , p6_a4 out nocopy VARCHAR2
484 , p6_a5 out nocopy DATE
485 , p6_a6 out nocopy DATE
486 , p6_a7 out nocopy VARCHAR2
487 , p6_a8 out nocopy VARCHAR2
488 , p6_a9 out nocopy VARCHAR2
489 , p6_a10 out nocopy VARCHAR2
490 , p6_a11 out nocopy VARCHAR2
491 , p6_a12 out nocopy VARCHAR2
492 , p6_a13 out nocopy VARCHAR2
493 , p6_a14 out nocopy VARCHAR2
494 , p6_a15 out nocopy VARCHAR2
495 , p6_a16 out nocopy VARCHAR2
496 , p6_a17 out nocopy VARCHAR2
497 , p6_a18 out nocopy VARCHAR2
498 , p6_a19 out nocopy VARCHAR2
499 , p6_a20 out nocopy VARCHAR2
500 , p6_a21 out nocopy VARCHAR2
501 , p6_a22 out nocopy VARCHAR2
502 , p6_a23 out nocopy NUMBER
503 , p6_a24 out nocopy DATE
504 , p6_a25 out nocopy NUMBER
505 , p6_a26 out nocopy DATE
506 , p6_a27 out nocopy NUMBER
507 );
508 procedure validate_adj_mat(p_api_version NUMBER
509 , p_init_msg_list VARCHAR2
510 , x_return_status out nocopy VARCHAR2
511 , x_msg_count out nocopy NUMBER
512 , x_msg_data out nocopy VARCHAR2
513 , p5_a0 NUMBER
514 , p5_a1 NUMBER
515 , p5_a2 VARCHAR2
516 , p5_a3 NUMBER
517 , p5_a4 VARCHAR2
518 , p5_a5 DATE
519 , p5_a6 DATE
520 , p5_a7 VARCHAR2
521 , p5_a8 VARCHAR2
522 , p5_a9 VARCHAR2
523 , p5_a10 VARCHAR2
524 , p5_a11 VARCHAR2
525 , p5_a12 VARCHAR2
526 , p5_a13 VARCHAR2
527 , p5_a14 VARCHAR2
528 , p5_a15 VARCHAR2
529 , p5_a16 VARCHAR2
530 , p5_a17 VARCHAR2
531 , p5_a18 VARCHAR2
532 , p5_a19 VARCHAR2
533 , p5_a20 VARCHAR2
534 , p5_a21 VARCHAR2
535 , p5_a22 VARCHAR2
536 , p5_a23 NUMBER
537 , p5_a24 DATE
538 , p5_a25 NUMBER
539 , p5_a26 DATE
540 , p5_a27 NUMBER
541 , p6_a0 NUMBER
542 , p6_a1 NUMBER
543 , p6_a2 NUMBER
544 , p6_a3 VARCHAR2
545 , p6_a4 VARCHAR2
546 , p6_a5 VARCHAR2
547 , p6_a6 NUMBER
548 , p6_a7 DATE
549 , p6_a8 NUMBER
550 , p6_a9 DATE
551 , p6_a10 NUMBER
552 , p7_a0 JTF_NUMBER_TABLE
553 , p7_a1 JTF_NUMBER_TABLE
554 , p7_a2 JTF_NUMBER_TABLE
555 , p7_a3 JTF_NUMBER_TABLE
556 , p7_a4 JTF_DATE_TABLE
557 , p7_a5 JTF_DATE_TABLE
558 , p7_a6 JTF_VARCHAR2_TABLE_100
559 , p7_a7 JTF_VARCHAR2_TABLE_100
560 , p7_a8 JTF_NUMBER_TABLE
561 , p7_a9 JTF_DATE_TABLE
562 , p7_a10 JTF_NUMBER_TABLE
563 , p7_a11 JTF_DATE_TABLE
564 , p7_a12 JTF_NUMBER_TABLE
565 , p8_a0 JTF_NUMBER_TABLE
566 , p8_a1 JTF_NUMBER_TABLE
567 , p8_a2 JTF_NUMBER_TABLE
568 , p8_a3 JTF_VARCHAR2_TABLE_100
569 , p8_a4 JTF_VARCHAR2_TABLE_100
570 , p8_a5 JTF_VARCHAR2_TABLE_100
571 , p8_a6 JTF_VARCHAR2_TABLE_100
572 , p8_a7 JTF_VARCHAR2_TABLE_300
573 , p8_a8 JTF_VARCHAR2_TABLE_300
574 , p8_a9 JTF_NUMBER_TABLE
575 , p8_a10 JTF_NUMBER_TABLE
576 , p8_a11 JTF_DATE_TABLE
577 , p8_a12 JTF_DATE_TABLE
578 , p8_a13 JTF_VARCHAR2_TABLE_100
579 , p8_a14 JTF_NUMBER_TABLE
580 , p8_a15 JTF_NUMBER_TABLE
581 , p8_a16 JTF_DATE_TABLE
582 , p8_a17 JTF_NUMBER_TABLE
583 , p8_a18 JTF_DATE_TABLE
584 , p8_a19 JTF_NUMBER_TABLE
585 , p8_a20 JTF_VARCHAR2_TABLE_100
586 , p8_a21 JTF_VARCHAR2_TABLE_500
587 , p8_a22 JTF_VARCHAR2_TABLE_500
588 , p8_a23 JTF_VARCHAR2_TABLE_500
589 , p8_a24 JTF_VARCHAR2_TABLE_500
590 , p8_a25 JTF_VARCHAR2_TABLE_500
591 , p8_a26 JTF_VARCHAR2_TABLE_500
592 , p8_a27 JTF_VARCHAR2_TABLE_500
593 , p8_a28 JTF_VARCHAR2_TABLE_500
594 , p8_a29 JTF_VARCHAR2_TABLE_500
595 , p8_a30 JTF_VARCHAR2_TABLE_500
596 , p8_a31 JTF_VARCHAR2_TABLE_500
597 , p8_a32 JTF_VARCHAR2_TABLE_500
598 , p8_a33 JTF_VARCHAR2_TABLE_500
599 , p8_a34 JTF_VARCHAR2_TABLE_500
600 , p8_a35 JTF_VARCHAR2_TABLE_500
601 );
602 procedure invalid_objects(p_api_version NUMBER
603 , p_init_msg_list VARCHAR2
604 , x_return_status out nocopy VARCHAR2
605 , x_msg_count out nocopy NUMBER
606 , x_msg_data out nocopy VARCHAR2
607 , p_version_id NUMBER
608 , p6_a0 out nocopy JTF_NUMBER_TABLE
609 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
610 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
611 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
612 );
613 procedure calc_start_date(p_api_version NUMBER
614 , p_init_msg_list VARCHAR2
615 , x_return_status out nocopy VARCHAR2
616 , x_msg_count out nocopy NUMBER
617 , x_msg_data out nocopy VARCHAR2
618 , p5_a0 NUMBER
619 , p5_a1 NUMBER
620 , p5_a2 VARCHAR2
621 , p5_a3 NUMBER
622 , p5_a4 VARCHAR2
623 , p5_a5 DATE
624 , p5_a6 DATE
625 , p5_a7 VARCHAR2
626 , p5_a8 VARCHAR2
627 , p5_a9 VARCHAR2
628 , p5_a10 VARCHAR2
629 , p5_a11 VARCHAR2
630 , p5_a12 VARCHAR2
631 , p5_a13 VARCHAR2
632 , p5_a14 VARCHAR2
633 , p5_a15 VARCHAR2
634 , p5_a16 VARCHAR2
635 , p5_a17 VARCHAR2
636 , p5_a18 VARCHAR2
637 , p5_a19 VARCHAR2
638 , p5_a20 VARCHAR2
639 , p5_a21 VARCHAR2
640 , p5_a22 VARCHAR2
641 , p5_a23 NUMBER
642 , p5_a24 DATE
643 , p5_a25 NUMBER
644 , p5_a26 DATE
645 , p5_a27 NUMBER
646 , x_cal_eff_from out nocopy DATE
647 );
648 end okl_fe_adj_matrix_pub_w;