DBA Data[Home] [Help]

PACKAGE: APPS.OKL_FE_ADJ_MATRIX_PVT_W

Source


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