DBA Data[Home] [Help]

PACKAGE: APPS.OKL_FE_STD_RATE_TMPL_PUB_W

Source


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