DBA Data[Home] [Help]

PACKAGE: APPS.OKL_FE_EO_TERM_OPTIONS_PUB_W

Source


1 package okl_fe_eo_term_options_pub_w AUTHID CURRENT_USER as
2   /* $Header: OKLUEOTS.pls 120.0 2005/07/07 10:46:10 viselvar noship $ */
3   procedure get_item_lines(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_po_id  NUMBER
9     , p_po_version  VARCHAR2
10     , p7_a0 out nocopy JTF_NUMBER_TABLE
11     , p7_a1 out nocopy JTF_NUMBER_TABLE
12     , p7_a2 out nocopy JTF_NUMBER_TABLE
13     , p7_a3 out nocopy JTF_NUMBER_TABLE
14     , p7_a4 out nocopy JTF_NUMBER_TABLE
15     , p7_a5 out nocopy JTF_NUMBER_TABLE
16     , p7_a6 out nocopy JTF_NUMBER_TABLE
17     , p7_a7 out nocopy JTF_NUMBER_TABLE
18     , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
19     , p7_a9 out nocopy JTF_VARCHAR2_TABLE_500
20     , p7_a10 out nocopy JTF_VARCHAR2_TABLE_500
21     , p7_a11 out nocopy JTF_VARCHAR2_TABLE_500
22     , p7_a12 out nocopy JTF_VARCHAR2_TABLE_500
23     , p7_a13 out nocopy JTF_VARCHAR2_TABLE_500
24     , p7_a14 out nocopy JTF_VARCHAR2_TABLE_500
25     , p7_a15 out nocopy JTF_VARCHAR2_TABLE_500
26     , p7_a16 out nocopy JTF_VARCHAR2_TABLE_500
27     , p7_a17 out nocopy JTF_VARCHAR2_TABLE_500
28     , p7_a18 out nocopy JTF_VARCHAR2_TABLE_500
29     , p7_a19 out nocopy JTF_VARCHAR2_TABLE_500
30     , p7_a20 out nocopy JTF_VARCHAR2_TABLE_500
31     , p7_a21 out nocopy JTF_VARCHAR2_TABLE_500
32     , p7_a22 out nocopy JTF_VARCHAR2_TABLE_500
33     , p7_a23 out nocopy JTF_VARCHAR2_TABLE_500
34     , p7_a24 out nocopy JTF_NUMBER_TABLE
35     , p7_a25 out nocopy JTF_DATE_TABLE
36     , p7_a26 out nocopy JTF_NUMBER_TABLE
37     , p7_a27 out nocopy JTF_DATE_TABLE
38     , p7_a28 out nocopy JTF_NUMBER_TABLE
39   );
40   procedure get_eo_term_values(p_api_version  NUMBER
41     , p_init_msg_list  VARCHAR2
42     , x_return_status out nocopy  VARCHAR2
43     , x_msg_count out nocopy  NUMBER
44     , x_msg_data out nocopy  VARCHAR2
45     , p_po_id  NUMBER
46     , p_po_version  VARCHAR2
47     , p7_a0 out nocopy JTF_NUMBER_TABLE
48     , p7_a1 out nocopy JTF_NUMBER_TABLE
49     , p7_a2 out nocopy JTF_NUMBER_TABLE
50     , p7_a3 out nocopy JTF_NUMBER_TABLE
51     , p7_a4 out nocopy JTF_NUMBER_TABLE
52     , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
53     , p7_a6 out nocopy JTF_VARCHAR2_TABLE_500
54     , p7_a7 out nocopy JTF_VARCHAR2_TABLE_500
55     , p7_a8 out nocopy JTF_VARCHAR2_TABLE_500
56     , p7_a9 out nocopy JTF_VARCHAR2_TABLE_500
57     , p7_a10 out nocopy JTF_VARCHAR2_TABLE_500
58     , p7_a11 out nocopy JTF_VARCHAR2_TABLE_500
59     , p7_a12 out nocopy JTF_VARCHAR2_TABLE_500
60     , p7_a13 out nocopy JTF_VARCHAR2_TABLE_500
61     , p7_a14 out nocopy JTF_VARCHAR2_TABLE_500
62     , p7_a15 out nocopy JTF_VARCHAR2_TABLE_500
63     , p7_a16 out nocopy JTF_VARCHAR2_TABLE_500
64     , p7_a17 out nocopy JTF_VARCHAR2_TABLE_500
65     , p7_a18 out nocopy JTF_VARCHAR2_TABLE_500
66     , p7_a19 out nocopy JTF_VARCHAR2_TABLE_500
67     , p7_a20 out nocopy JTF_VARCHAR2_TABLE_500
68     , p7_a21 out nocopy JTF_NUMBER_TABLE
69     , p7_a22 out nocopy JTF_DATE_TABLE
70     , p7_a23 out nocopy JTF_NUMBER_TABLE
71     , p7_a24 out nocopy JTF_DATE_TABLE
72     , p7_a25 out nocopy JTF_NUMBER_TABLE
73   );
74   procedure get_end_of_term_option(p_api_version  NUMBER
75     , p_init_msg_list  VARCHAR2
76     , x_return_status out nocopy  VARCHAR2
77     , x_msg_count out nocopy  NUMBER
78     , x_msg_data out nocopy  VARCHAR2
79     , p_po_id  NUMBER
80     , p_po_version  VARCHAR2
81     , p7_a0 out nocopy  NUMBER
82     , p7_a1 out nocopy  NUMBER
83     , p7_a2 out nocopy  VARCHAR2
84     , p7_a3 out nocopy  VARCHAR2
85     , p7_a4 out nocopy  NUMBER
86     , p7_a5 out nocopy  VARCHAR2
87     , p7_a6 out nocopy  VARCHAR2
88     , p7_a7 out nocopy  NUMBER
89     , p7_a8 out nocopy  VARCHAR2
90     , p7_a9 out nocopy  NUMBER
91     , p7_a10 out nocopy  VARCHAR2
92     , p7_a11 out nocopy  DATE
93     , p7_a12 out nocopy  DATE
94     , p7_a13 out nocopy  VARCHAR2
95     , p7_a14 out nocopy  VARCHAR2
96     , p7_a15 out nocopy  VARCHAR2
97     , p7_a16 out nocopy  VARCHAR2
98     , p7_a17 out nocopy  VARCHAR2
99     , p7_a18 out nocopy  VARCHAR2
100     , p7_a19 out nocopy  VARCHAR2
101     , p7_a20 out nocopy  VARCHAR2
102     , p7_a21 out nocopy  VARCHAR2
103     , p7_a22 out nocopy  VARCHAR2
104     , p7_a23 out nocopy  VARCHAR2
105     , p7_a24 out nocopy  VARCHAR2
106     , p7_a25 out nocopy  VARCHAR2
107     , p7_a26 out nocopy  VARCHAR2
108     , p7_a27 out nocopy  VARCHAR2
109     , p7_a28 out nocopy  VARCHAR2
110     , p7_a29 out nocopy  NUMBER
111     , p7_a30 out nocopy  DATE
112     , p7_a31 out nocopy  NUMBER
113     , p7_a32 out nocopy  DATE
114     , p7_a33 out nocopy  NUMBER
115     , p8_a0 out nocopy  NUMBER
116     , p8_a1 out nocopy  NUMBER
117     , p8_a2 out nocopy  VARCHAR2
118     , p8_a3 out nocopy  DATE
119     , p8_a4 out nocopy  DATE
120     , p8_a5 out nocopy  VARCHAR2
121     , p8_a6 out nocopy  NUMBER
122     , p8_a7 out nocopy  VARCHAR2
123     , p8_a8 out nocopy  VARCHAR2
124     , p8_a9 out nocopy  VARCHAR2
125     , p8_a10 out nocopy  VARCHAR2
126     , p8_a11 out nocopy  VARCHAR2
127     , p8_a12 out nocopy  VARCHAR2
128     , p8_a13 out nocopy  VARCHAR2
129     , p8_a14 out nocopy  VARCHAR2
130     , p8_a15 out nocopy  VARCHAR2
131     , p8_a16 out nocopy  VARCHAR2
132     , p8_a17 out nocopy  VARCHAR2
133     , p8_a18 out nocopy  VARCHAR2
134     , p8_a19 out nocopy  VARCHAR2
135     , p8_a20 out nocopy  VARCHAR2
136     , p8_a21 out nocopy  VARCHAR2
137     , p8_a22 out nocopy  VARCHAR2
138     , p8_a23 out nocopy  NUMBER
139     , p8_a24 out nocopy  DATE
140     , p8_a25 out nocopy  NUMBER
141     , p8_a26 out nocopy  DATE
142     , p8_a27 out nocopy  NUMBER
143     , p9_a0 out nocopy JTF_NUMBER_TABLE
144     , p9_a1 out nocopy JTF_NUMBER_TABLE
145     , p9_a2 out nocopy JTF_NUMBER_TABLE
146     , p9_a3 out nocopy JTF_NUMBER_TABLE
147     , p9_a4 out nocopy JTF_NUMBER_TABLE
148     , p9_a5 out nocopy JTF_NUMBER_TABLE
149     , p9_a6 out nocopy JTF_NUMBER_TABLE
150     , p9_a7 out nocopy JTF_NUMBER_TABLE
151     , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
152     , p9_a9 out nocopy JTF_VARCHAR2_TABLE_500
153     , p9_a10 out nocopy JTF_VARCHAR2_TABLE_500
154     , p9_a11 out nocopy JTF_VARCHAR2_TABLE_500
155     , p9_a12 out nocopy JTF_VARCHAR2_TABLE_500
156     , p9_a13 out nocopy JTF_VARCHAR2_TABLE_500
157     , p9_a14 out nocopy JTF_VARCHAR2_TABLE_500
158     , p9_a15 out nocopy JTF_VARCHAR2_TABLE_500
159     , p9_a16 out nocopy JTF_VARCHAR2_TABLE_500
160     , p9_a17 out nocopy JTF_VARCHAR2_TABLE_500
161     , p9_a18 out nocopy JTF_VARCHAR2_TABLE_500
162     , p9_a19 out nocopy JTF_VARCHAR2_TABLE_500
163     , p9_a20 out nocopy JTF_VARCHAR2_TABLE_500
164     , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500
165     , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500
166     , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
167     , p9_a24 out nocopy JTF_NUMBER_TABLE
168     , p9_a25 out nocopy JTF_DATE_TABLE
169     , p9_a26 out nocopy JTF_NUMBER_TABLE
170     , p9_a27 out nocopy JTF_DATE_TABLE
171     , p9_a28 out nocopy JTF_NUMBER_TABLE
172     , p10_a0 out nocopy JTF_NUMBER_TABLE
173     , p10_a1 out nocopy JTF_NUMBER_TABLE
174     , p10_a2 out nocopy JTF_NUMBER_TABLE
175     , p10_a3 out nocopy JTF_NUMBER_TABLE
176     , p10_a4 out nocopy JTF_NUMBER_TABLE
177     , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
178     , p10_a6 out nocopy JTF_VARCHAR2_TABLE_500
179     , p10_a7 out nocopy JTF_VARCHAR2_TABLE_500
180     , p10_a8 out nocopy JTF_VARCHAR2_TABLE_500
181     , p10_a9 out nocopy JTF_VARCHAR2_TABLE_500
182     , p10_a10 out nocopy JTF_VARCHAR2_TABLE_500
183     , p10_a11 out nocopy JTF_VARCHAR2_TABLE_500
184     , p10_a12 out nocopy JTF_VARCHAR2_TABLE_500
185     , p10_a13 out nocopy JTF_VARCHAR2_TABLE_500
186     , p10_a14 out nocopy JTF_VARCHAR2_TABLE_500
187     , p10_a15 out nocopy JTF_VARCHAR2_TABLE_500
188     , p10_a16 out nocopy JTF_VARCHAR2_TABLE_500
189     , p10_a17 out nocopy JTF_VARCHAR2_TABLE_500
190     , p10_a18 out nocopy JTF_VARCHAR2_TABLE_500
191     , p10_a19 out nocopy JTF_VARCHAR2_TABLE_500
192     , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
193     , p10_a21 out nocopy JTF_NUMBER_TABLE
194     , p10_a22 out nocopy JTF_DATE_TABLE
195     , p10_a23 out nocopy JTF_NUMBER_TABLE
196     , p10_a24 out nocopy JTF_DATE_TABLE
197     , p10_a25 out nocopy JTF_NUMBER_TABLE
198   );
199   procedure insert_end_of_term_option(p_api_version  NUMBER
200     , p_init_msg_list  VARCHAR2
201     , x_return_status out nocopy  VARCHAR2
202     , x_msg_count out nocopy  NUMBER
203     , x_msg_data out nocopy  VARCHAR2
204     , p5_a0  NUMBER
205     , p5_a1  NUMBER
206     , p5_a2  VARCHAR2
207     , p5_a3  VARCHAR2
208     , p5_a4  NUMBER
209     , p5_a5  VARCHAR2
210     , p5_a6  VARCHAR2
211     , p5_a7  NUMBER
212     , p5_a8  VARCHAR2
213     , p5_a9  NUMBER
214     , p5_a10  VARCHAR2
215     , p5_a11  DATE
216     , p5_a12  DATE
217     , p5_a13  VARCHAR2
218     , p5_a14  VARCHAR2
219     , p5_a15  VARCHAR2
220     , p5_a16  VARCHAR2
221     , p5_a17  VARCHAR2
222     , p5_a18  VARCHAR2
223     , p5_a19  VARCHAR2
224     , p5_a20  VARCHAR2
225     , p5_a21  VARCHAR2
226     , p5_a22  VARCHAR2
227     , p5_a23  VARCHAR2
228     , p5_a24  VARCHAR2
229     , p5_a25  VARCHAR2
230     , p5_a26  VARCHAR2
231     , p5_a27  VARCHAR2
232     , p5_a28  VARCHAR2
233     , p5_a29  NUMBER
234     , p5_a30  DATE
235     , p5_a31  NUMBER
236     , p5_a32  DATE
237     , p5_a33  NUMBER
238     , p6_a0  NUMBER
239     , p6_a1  NUMBER
240     , p6_a2  VARCHAR2
241     , p6_a3  DATE
242     , p6_a4  DATE
243     , p6_a5  VARCHAR2
244     , p6_a6  NUMBER
245     , p6_a7  VARCHAR2
246     , p6_a8  VARCHAR2
247     , p6_a9  VARCHAR2
248     , p6_a10  VARCHAR2
249     , p6_a11  VARCHAR2
250     , p6_a12  VARCHAR2
251     , p6_a13  VARCHAR2
252     , p6_a14  VARCHAR2
253     , p6_a15  VARCHAR2
254     , p6_a16  VARCHAR2
255     , p6_a17  VARCHAR2
256     , p6_a18  VARCHAR2
257     , p6_a19  VARCHAR2
258     , p6_a20  VARCHAR2
259     , p6_a21  VARCHAR2
260     , p6_a22  VARCHAR2
261     , p6_a23  NUMBER
262     , p6_a24  DATE
263     , p6_a25  NUMBER
264     , p6_a26  DATE
265     , p6_a27  NUMBER
266     , p7_a0 JTF_NUMBER_TABLE
267     , p7_a1 JTF_NUMBER_TABLE
268     , p7_a2 JTF_NUMBER_TABLE
269     , p7_a3 JTF_NUMBER_TABLE
270     , p7_a4 JTF_NUMBER_TABLE
271     , p7_a5 JTF_NUMBER_TABLE
272     , p7_a6 JTF_NUMBER_TABLE
273     , p7_a7 JTF_NUMBER_TABLE
274     , p7_a8 JTF_VARCHAR2_TABLE_100
275     , p7_a9 JTF_VARCHAR2_TABLE_500
276     , p7_a10 JTF_VARCHAR2_TABLE_500
277     , p7_a11 JTF_VARCHAR2_TABLE_500
278     , p7_a12 JTF_VARCHAR2_TABLE_500
279     , p7_a13 JTF_VARCHAR2_TABLE_500
280     , p7_a14 JTF_VARCHAR2_TABLE_500
281     , p7_a15 JTF_VARCHAR2_TABLE_500
282     , p7_a16 JTF_VARCHAR2_TABLE_500
283     , p7_a17 JTF_VARCHAR2_TABLE_500
284     , p7_a18 JTF_VARCHAR2_TABLE_500
285     , p7_a19 JTF_VARCHAR2_TABLE_500
286     , p7_a20 JTF_VARCHAR2_TABLE_500
287     , p7_a21 JTF_VARCHAR2_TABLE_500
288     , p7_a22 JTF_VARCHAR2_TABLE_500
289     , p7_a23 JTF_VARCHAR2_TABLE_500
290     , p7_a24 JTF_NUMBER_TABLE
291     , p7_a25 JTF_DATE_TABLE
292     , p7_a26 JTF_NUMBER_TABLE
293     , p7_a27 JTF_DATE_TABLE
294     , p7_a28 JTF_NUMBER_TABLE
295     , p8_a0 JTF_NUMBER_TABLE
296     , p8_a1 JTF_NUMBER_TABLE
297     , p8_a2 JTF_NUMBER_TABLE
298     , p8_a3 JTF_NUMBER_TABLE
299     , p8_a4 JTF_NUMBER_TABLE
300     , p8_a5 JTF_VARCHAR2_TABLE_100
301     , p8_a6 JTF_VARCHAR2_TABLE_500
302     , p8_a7 JTF_VARCHAR2_TABLE_500
303     , p8_a8 JTF_VARCHAR2_TABLE_500
304     , p8_a9 JTF_VARCHAR2_TABLE_500
305     , p8_a10 JTF_VARCHAR2_TABLE_500
306     , p8_a11 JTF_VARCHAR2_TABLE_500
307     , p8_a12 JTF_VARCHAR2_TABLE_500
308     , p8_a13 JTF_VARCHAR2_TABLE_500
309     , p8_a14 JTF_VARCHAR2_TABLE_500
310     , p8_a15 JTF_VARCHAR2_TABLE_500
311     , p8_a16 JTF_VARCHAR2_TABLE_500
312     , p8_a17 JTF_VARCHAR2_TABLE_500
313     , p8_a18 JTF_VARCHAR2_TABLE_500
314     , p8_a19 JTF_VARCHAR2_TABLE_500
315     , p8_a20 JTF_VARCHAR2_TABLE_500
316     , p8_a21 JTF_NUMBER_TABLE
317     , p8_a22 JTF_DATE_TABLE
318     , p8_a23 JTF_NUMBER_TABLE
319     , p8_a24 JTF_DATE_TABLE
320     , p8_a25 JTF_NUMBER_TABLE
321     , p9_a0 out nocopy  NUMBER
322     , p9_a1 out nocopy  NUMBER
323     , p9_a2 out nocopy  VARCHAR2
324     , p9_a3 out nocopy  VARCHAR2
325     , p9_a4 out nocopy  NUMBER
326     , p9_a5 out nocopy  VARCHAR2
327     , p9_a6 out nocopy  VARCHAR2
328     , p9_a7 out nocopy  NUMBER
329     , p9_a8 out nocopy  VARCHAR2
330     , p9_a9 out nocopy  NUMBER
331     , p9_a10 out nocopy  VARCHAR2
332     , p9_a11 out nocopy  DATE
333     , p9_a12 out nocopy  DATE
334     , p9_a13 out nocopy  VARCHAR2
335     , p9_a14 out nocopy  VARCHAR2
336     , p9_a15 out nocopy  VARCHAR2
337     , p9_a16 out nocopy  VARCHAR2
338     , p9_a17 out nocopy  VARCHAR2
339     , p9_a18 out nocopy  VARCHAR2
340     , p9_a19 out nocopy  VARCHAR2
341     , p9_a20 out nocopy  VARCHAR2
342     , p9_a21 out nocopy  VARCHAR2
343     , p9_a22 out nocopy  VARCHAR2
344     , p9_a23 out nocopy  VARCHAR2
345     , p9_a24 out nocopy  VARCHAR2
346     , p9_a25 out nocopy  VARCHAR2
347     , p9_a26 out nocopy  VARCHAR2
348     , p9_a27 out nocopy  VARCHAR2
349     , p9_a28 out nocopy  VARCHAR2
350     , p9_a29 out nocopy  NUMBER
351     , p9_a30 out nocopy  DATE
352     , p9_a31 out nocopy  NUMBER
353     , p9_a32 out nocopy  DATE
354     , p9_a33 out nocopy  NUMBER
355     , p10_a0 out nocopy  NUMBER
356     , p10_a1 out nocopy  NUMBER
357     , p10_a2 out nocopy  VARCHAR2
358     , p10_a3 out nocopy  DATE
359     , p10_a4 out nocopy  DATE
360     , p10_a5 out nocopy  VARCHAR2
361     , p10_a6 out nocopy  NUMBER
362     , p10_a7 out nocopy  VARCHAR2
363     , p10_a8 out nocopy  VARCHAR2
364     , p10_a9 out nocopy  VARCHAR2
365     , p10_a10 out nocopy  VARCHAR2
366     , p10_a11 out nocopy  VARCHAR2
367     , p10_a12 out nocopy  VARCHAR2
368     , p10_a13 out nocopy  VARCHAR2
369     , p10_a14 out nocopy  VARCHAR2
370     , p10_a15 out nocopy  VARCHAR2
371     , p10_a16 out nocopy  VARCHAR2
372     , p10_a17 out nocopy  VARCHAR2
373     , p10_a18 out nocopy  VARCHAR2
374     , p10_a19 out nocopy  VARCHAR2
375     , p10_a20 out nocopy  VARCHAR2
376     , p10_a21 out nocopy  VARCHAR2
377     , p10_a22 out nocopy  VARCHAR2
378     , p10_a23 out nocopy  NUMBER
379     , p10_a24 out nocopy  DATE
380     , p10_a25 out nocopy  NUMBER
381     , p10_a26 out nocopy  DATE
382     , p10_a27 out nocopy  NUMBER
383     , p11_a0 out nocopy JTF_NUMBER_TABLE
384     , p11_a1 out nocopy JTF_NUMBER_TABLE
385     , p11_a2 out nocopy JTF_NUMBER_TABLE
386     , p11_a3 out nocopy JTF_NUMBER_TABLE
387     , p11_a4 out nocopy JTF_NUMBER_TABLE
388     , p11_a5 out nocopy JTF_NUMBER_TABLE
389     , p11_a6 out nocopy JTF_NUMBER_TABLE
390     , p11_a7 out nocopy JTF_NUMBER_TABLE
391     , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
392     , p11_a9 out nocopy JTF_VARCHAR2_TABLE_500
393     , p11_a10 out nocopy JTF_VARCHAR2_TABLE_500
394     , p11_a11 out nocopy JTF_VARCHAR2_TABLE_500
395     , p11_a12 out nocopy JTF_VARCHAR2_TABLE_500
396     , p11_a13 out nocopy JTF_VARCHAR2_TABLE_500
397     , p11_a14 out nocopy JTF_VARCHAR2_TABLE_500
398     , p11_a15 out nocopy JTF_VARCHAR2_TABLE_500
399     , p11_a16 out nocopy JTF_VARCHAR2_TABLE_500
400     , p11_a17 out nocopy JTF_VARCHAR2_TABLE_500
401     , p11_a18 out nocopy JTF_VARCHAR2_TABLE_500
402     , p11_a19 out nocopy JTF_VARCHAR2_TABLE_500
403     , p11_a20 out nocopy JTF_VARCHAR2_TABLE_500
404     , p11_a21 out nocopy JTF_VARCHAR2_TABLE_500
405     , p11_a22 out nocopy JTF_VARCHAR2_TABLE_500
406     , p11_a23 out nocopy JTF_VARCHAR2_TABLE_500
407     , p11_a24 out nocopy JTF_NUMBER_TABLE
408     , p11_a25 out nocopy JTF_DATE_TABLE
409     , p11_a26 out nocopy JTF_NUMBER_TABLE
410     , p11_a27 out nocopy JTF_DATE_TABLE
411     , p11_a28 out nocopy JTF_NUMBER_TABLE
412     , p12_a0 out nocopy JTF_NUMBER_TABLE
413     , p12_a1 out nocopy JTF_NUMBER_TABLE
414     , p12_a2 out nocopy JTF_NUMBER_TABLE
415     , p12_a3 out nocopy JTF_NUMBER_TABLE
416     , p12_a4 out nocopy JTF_NUMBER_TABLE
417     , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
418     , p12_a6 out nocopy JTF_VARCHAR2_TABLE_500
419     , p12_a7 out nocopy JTF_VARCHAR2_TABLE_500
420     , p12_a8 out nocopy JTF_VARCHAR2_TABLE_500
421     , p12_a9 out nocopy JTF_VARCHAR2_TABLE_500
422     , p12_a10 out nocopy JTF_VARCHAR2_TABLE_500
423     , p12_a11 out nocopy JTF_VARCHAR2_TABLE_500
424     , p12_a12 out nocopy JTF_VARCHAR2_TABLE_500
425     , p12_a13 out nocopy JTF_VARCHAR2_TABLE_500
426     , p12_a14 out nocopy JTF_VARCHAR2_TABLE_500
427     , p12_a15 out nocopy JTF_VARCHAR2_TABLE_500
428     , p12_a16 out nocopy JTF_VARCHAR2_TABLE_500
429     , p12_a17 out nocopy JTF_VARCHAR2_TABLE_500
430     , p12_a18 out nocopy JTF_VARCHAR2_TABLE_500
431     , p12_a19 out nocopy JTF_VARCHAR2_TABLE_500
432     , p12_a20 out nocopy JTF_VARCHAR2_TABLE_500
433     , p12_a21 out nocopy JTF_NUMBER_TABLE
434     , p12_a22 out nocopy JTF_DATE_TABLE
435     , p12_a23 out nocopy JTF_NUMBER_TABLE
436     , p12_a24 out nocopy JTF_DATE_TABLE
437     , p12_a25 out nocopy JTF_NUMBER_TABLE
438   );
439   procedure update_end_of_term_option(p_api_version  NUMBER
440     , p_init_msg_list  VARCHAR2
441     , x_return_status out nocopy  VARCHAR2
442     , x_msg_count out nocopy  NUMBER
443     , x_msg_data out nocopy  VARCHAR2
444     , p5_a0  NUMBER
445     , p5_a1  NUMBER
446     , p5_a2  VARCHAR2
447     , p5_a3  DATE
448     , p5_a4  DATE
449     , p5_a5  VARCHAR2
450     , p5_a6  NUMBER
451     , p5_a7  VARCHAR2
452     , p5_a8  VARCHAR2
453     , p5_a9  VARCHAR2
454     , p5_a10  VARCHAR2
455     , p5_a11  VARCHAR2
456     , p5_a12  VARCHAR2
457     , p5_a13  VARCHAR2
458     , p5_a14  VARCHAR2
459     , p5_a15  VARCHAR2
460     , p5_a16  VARCHAR2
461     , p5_a17  VARCHAR2
462     , p5_a18  VARCHAR2
463     , p5_a19  VARCHAR2
464     , p5_a20  VARCHAR2
465     , p5_a21  VARCHAR2
466     , p5_a22  VARCHAR2
467     , p5_a23  NUMBER
468     , p5_a24  DATE
469     , p5_a25  NUMBER
470     , p5_a26  DATE
471     , p5_a27  NUMBER
472     , p6_a0 JTF_NUMBER_TABLE
473     , p6_a1 JTF_NUMBER_TABLE
474     , p6_a2 JTF_NUMBER_TABLE
475     , p6_a3 JTF_NUMBER_TABLE
476     , p6_a4 JTF_NUMBER_TABLE
477     , p6_a5 JTF_NUMBER_TABLE
478     , p6_a6 JTF_NUMBER_TABLE
479     , p6_a7 JTF_NUMBER_TABLE
480     , p6_a8 JTF_VARCHAR2_TABLE_100
481     , p6_a9 JTF_VARCHAR2_TABLE_500
482     , p6_a10 JTF_VARCHAR2_TABLE_500
483     , p6_a11 JTF_VARCHAR2_TABLE_500
484     , p6_a12 JTF_VARCHAR2_TABLE_500
485     , p6_a13 JTF_VARCHAR2_TABLE_500
486     , p6_a14 JTF_VARCHAR2_TABLE_500
487     , p6_a15 JTF_VARCHAR2_TABLE_500
488     , p6_a16 JTF_VARCHAR2_TABLE_500
489     , p6_a17 JTF_VARCHAR2_TABLE_500
490     , p6_a18 JTF_VARCHAR2_TABLE_500
491     , p6_a19 JTF_VARCHAR2_TABLE_500
492     , p6_a20 JTF_VARCHAR2_TABLE_500
493     , p6_a21 JTF_VARCHAR2_TABLE_500
494     , p6_a22 JTF_VARCHAR2_TABLE_500
495     , p6_a23 JTF_VARCHAR2_TABLE_500
496     , p6_a24 JTF_NUMBER_TABLE
497     , p6_a25 JTF_DATE_TABLE
498     , p6_a26 JTF_NUMBER_TABLE
499     , p6_a27 JTF_DATE_TABLE
500     , p6_a28 JTF_NUMBER_TABLE
501     , p7_a0 JTF_NUMBER_TABLE
502     , p7_a1 JTF_NUMBER_TABLE
503     , p7_a2 JTF_NUMBER_TABLE
504     , p7_a3 JTF_NUMBER_TABLE
505     , p7_a4 JTF_NUMBER_TABLE
506     , p7_a5 JTF_VARCHAR2_TABLE_100
507     , p7_a6 JTF_VARCHAR2_TABLE_500
508     , p7_a7 JTF_VARCHAR2_TABLE_500
509     , p7_a8 JTF_VARCHAR2_TABLE_500
510     , p7_a9 JTF_VARCHAR2_TABLE_500
511     , p7_a10 JTF_VARCHAR2_TABLE_500
512     , p7_a11 JTF_VARCHAR2_TABLE_500
513     , p7_a12 JTF_VARCHAR2_TABLE_500
514     , p7_a13 JTF_VARCHAR2_TABLE_500
515     , p7_a14 JTF_VARCHAR2_TABLE_500
516     , p7_a15 JTF_VARCHAR2_TABLE_500
517     , p7_a16 JTF_VARCHAR2_TABLE_500
518     , p7_a17 JTF_VARCHAR2_TABLE_500
519     , p7_a18 JTF_VARCHAR2_TABLE_500
520     , p7_a19 JTF_VARCHAR2_TABLE_500
521     , p7_a20 JTF_VARCHAR2_TABLE_500
522     , p7_a21 JTF_NUMBER_TABLE
523     , p7_a22 JTF_DATE_TABLE
524     , p7_a23 JTF_NUMBER_TABLE
525     , p7_a24 JTF_DATE_TABLE
526     , p7_a25 JTF_NUMBER_TABLE
527     , p8_a0 out nocopy  NUMBER
528     , p8_a1 out nocopy  NUMBER
529     , p8_a2 out nocopy  VARCHAR2
530     , p8_a3 out nocopy  DATE
531     , p8_a4 out nocopy  DATE
532     , p8_a5 out nocopy  VARCHAR2
533     , p8_a6 out nocopy  NUMBER
534     , p8_a7 out nocopy  VARCHAR2
535     , p8_a8 out nocopy  VARCHAR2
536     , p8_a9 out nocopy  VARCHAR2
537     , p8_a10 out nocopy  VARCHAR2
538     , p8_a11 out nocopy  VARCHAR2
539     , p8_a12 out nocopy  VARCHAR2
540     , p8_a13 out nocopy  VARCHAR2
541     , p8_a14 out nocopy  VARCHAR2
542     , p8_a15 out nocopy  VARCHAR2
543     , p8_a16 out nocopy  VARCHAR2
544     , p8_a17 out nocopy  VARCHAR2
545     , p8_a18 out nocopy  VARCHAR2
546     , p8_a19 out nocopy  VARCHAR2
547     , p8_a20 out nocopy  VARCHAR2
548     , p8_a21 out nocopy  VARCHAR2
549     , p8_a22 out nocopy  VARCHAR2
550     , p8_a23 out nocopy  NUMBER
551     , p8_a24 out nocopy  DATE
552     , p8_a25 out nocopy  NUMBER
553     , p8_a26 out nocopy  DATE
554     , p8_a27 out nocopy  NUMBER
555     , p9_a0 out nocopy JTF_NUMBER_TABLE
556     , p9_a1 out nocopy JTF_NUMBER_TABLE
557     , p9_a2 out nocopy JTF_NUMBER_TABLE
558     , p9_a3 out nocopy JTF_NUMBER_TABLE
559     , p9_a4 out nocopy JTF_NUMBER_TABLE
560     , p9_a5 out nocopy JTF_NUMBER_TABLE
561     , p9_a6 out nocopy JTF_NUMBER_TABLE
562     , p9_a7 out nocopy JTF_NUMBER_TABLE
563     , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
564     , p9_a9 out nocopy JTF_VARCHAR2_TABLE_500
565     , p9_a10 out nocopy JTF_VARCHAR2_TABLE_500
566     , p9_a11 out nocopy JTF_VARCHAR2_TABLE_500
567     , p9_a12 out nocopy JTF_VARCHAR2_TABLE_500
568     , p9_a13 out nocopy JTF_VARCHAR2_TABLE_500
569     , p9_a14 out nocopy JTF_VARCHAR2_TABLE_500
570     , p9_a15 out nocopy JTF_VARCHAR2_TABLE_500
571     , p9_a16 out nocopy JTF_VARCHAR2_TABLE_500
572     , p9_a17 out nocopy JTF_VARCHAR2_TABLE_500
573     , p9_a18 out nocopy JTF_VARCHAR2_TABLE_500
574     , p9_a19 out nocopy JTF_VARCHAR2_TABLE_500
575     , p9_a20 out nocopy JTF_VARCHAR2_TABLE_500
576     , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500
577     , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500
578     , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
579     , p9_a24 out nocopy JTF_NUMBER_TABLE
580     , p9_a25 out nocopy JTF_DATE_TABLE
581     , p9_a26 out nocopy JTF_NUMBER_TABLE
582     , p9_a27 out nocopy JTF_DATE_TABLE
583     , p9_a28 out nocopy JTF_NUMBER_TABLE
584     , p10_a0 out nocopy JTF_NUMBER_TABLE
585     , p10_a1 out nocopy JTF_NUMBER_TABLE
586     , p10_a2 out nocopy JTF_NUMBER_TABLE
587     , p10_a3 out nocopy JTF_NUMBER_TABLE
588     , p10_a4 out nocopy JTF_NUMBER_TABLE
589     , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
590     , p10_a6 out nocopy JTF_VARCHAR2_TABLE_500
591     , p10_a7 out nocopy JTF_VARCHAR2_TABLE_500
592     , p10_a8 out nocopy JTF_VARCHAR2_TABLE_500
593     , p10_a9 out nocopy JTF_VARCHAR2_TABLE_500
594     , p10_a10 out nocopy JTF_VARCHAR2_TABLE_500
595     , p10_a11 out nocopy JTF_VARCHAR2_TABLE_500
596     , p10_a12 out nocopy JTF_VARCHAR2_TABLE_500
597     , p10_a13 out nocopy JTF_VARCHAR2_TABLE_500
598     , p10_a14 out nocopy JTF_VARCHAR2_TABLE_500
599     , p10_a15 out nocopy JTF_VARCHAR2_TABLE_500
600     , p10_a16 out nocopy JTF_VARCHAR2_TABLE_500
601     , p10_a17 out nocopy JTF_VARCHAR2_TABLE_500
602     , p10_a18 out nocopy JTF_VARCHAR2_TABLE_500
603     , p10_a19 out nocopy JTF_VARCHAR2_TABLE_500
604     , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
605     , p10_a21 out nocopy JTF_NUMBER_TABLE
606     , p10_a22 out nocopy JTF_DATE_TABLE
607     , p10_a23 out nocopy JTF_NUMBER_TABLE
608     , p10_a24 out nocopy JTF_DATE_TABLE
609     , p10_a25 out nocopy JTF_NUMBER_TABLE
610   );
611   procedure create_version(p_api_version  NUMBER
612     , p_init_msg_list  VARCHAR2
613     , x_return_status out nocopy  VARCHAR2
614     , x_msg_count out nocopy  NUMBER
615     , x_msg_data out nocopy  VARCHAR2
616     , p5_a0  NUMBER
617     , p5_a1  NUMBER
618     , p5_a2  VARCHAR2
619     , p5_a3  DATE
620     , p5_a4  DATE
621     , p5_a5  VARCHAR2
622     , p5_a6  NUMBER
623     , p5_a7  VARCHAR2
624     , p5_a8  VARCHAR2
625     , p5_a9  VARCHAR2
626     , p5_a10  VARCHAR2
627     , p5_a11  VARCHAR2
628     , p5_a12  VARCHAR2
629     , p5_a13  VARCHAR2
630     , p5_a14  VARCHAR2
631     , p5_a15  VARCHAR2
632     , p5_a16  VARCHAR2
633     , p5_a17  VARCHAR2
634     , p5_a18  VARCHAR2
635     , p5_a19  VARCHAR2
636     , p5_a20  VARCHAR2
637     , p5_a21  VARCHAR2
638     , p5_a22  VARCHAR2
639     , p5_a23  NUMBER
640     , p5_a24  DATE
641     , p5_a25  NUMBER
642     , p5_a26  DATE
643     , p5_a27  NUMBER
644     , p6_a0 JTF_NUMBER_TABLE
645     , p6_a1 JTF_NUMBER_TABLE
646     , p6_a2 JTF_NUMBER_TABLE
647     , p6_a3 JTF_NUMBER_TABLE
648     , p6_a4 JTF_NUMBER_TABLE
649     , p6_a5 JTF_NUMBER_TABLE
650     , p6_a6 JTF_NUMBER_TABLE
651     , p6_a7 JTF_NUMBER_TABLE
652     , p6_a8 JTF_VARCHAR2_TABLE_100
653     , p6_a9 JTF_VARCHAR2_TABLE_500
654     , p6_a10 JTF_VARCHAR2_TABLE_500
655     , p6_a11 JTF_VARCHAR2_TABLE_500
656     , p6_a12 JTF_VARCHAR2_TABLE_500
657     , p6_a13 JTF_VARCHAR2_TABLE_500
658     , p6_a14 JTF_VARCHAR2_TABLE_500
659     , p6_a15 JTF_VARCHAR2_TABLE_500
660     , p6_a16 JTF_VARCHAR2_TABLE_500
661     , p6_a17 JTF_VARCHAR2_TABLE_500
662     , p6_a18 JTF_VARCHAR2_TABLE_500
663     , p6_a19 JTF_VARCHAR2_TABLE_500
664     , p6_a20 JTF_VARCHAR2_TABLE_500
665     , p6_a21 JTF_VARCHAR2_TABLE_500
666     , p6_a22 JTF_VARCHAR2_TABLE_500
667     , p6_a23 JTF_VARCHAR2_TABLE_500
668     , p6_a24 JTF_NUMBER_TABLE
669     , p6_a25 JTF_DATE_TABLE
670     , p6_a26 JTF_NUMBER_TABLE
671     , p6_a27 JTF_DATE_TABLE
672     , p6_a28 JTF_NUMBER_TABLE
673     , p7_a0 JTF_NUMBER_TABLE
674     , p7_a1 JTF_NUMBER_TABLE
675     , p7_a2 JTF_NUMBER_TABLE
676     , p7_a3 JTF_NUMBER_TABLE
677     , p7_a4 JTF_NUMBER_TABLE
678     , p7_a5 JTF_VARCHAR2_TABLE_100
679     , p7_a6 JTF_VARCHAR2_TABLE_500
680     , p7_a7 JTF_VARCHAR2_TABLE_500
681     , p7_a8 JTF_VARCHAR2_TABLE_500
682     , p7_a9 JTF_VARCHAR2_TABLE_500
683     , p7_a10 JTF_VARCHAR2_TABLE_500
684     , p7_a11 JTF_VARCHAR2_TABLE_500
685     , p7_a12 JTF_VARCHAR2_TABLE_500
686     , p7_a13 JTF_VARCHAR2_TABLE_500
687     , p7_a14 JTF_VARCHAR2_TABLE_500
688     , p7_a15 JTF_VARCHAR2_TABLE_500
689     , p7_a16 JTF_VARCHAR2_TABLE_500
690     , p7_a17 JTF_VARCHAR2_TABLE_500
691     , p7_a18 JTF_VARCHAR2_TABLE_500
692     , p7_a19 JTF_VARCHAR2_TABLE_500
693     , p7_a20 JTF_VARCHAR2_TABLE_500
694     , p7_a21 JTF_NUMBER_TABLE
695     , p7_a22 JTF_DATE_TABLE
696     , p7_a23 JTF_NUMBER_TABLE
697     , p7_a24 JTF_DATE_TABLE
698     , p7_a25 JTF_NUMBER_TABLE
699     , p8_a0 out nocopy  NUMBER
700     , p8_a1 out nocopy  NUMBER
701     , p8_a2 out nocopy  VARCHAR2
702     , p8_a3 out nocopy  DATE
703     , p8_a4 out nocopy  DATE
704     , p8_a5 out nocopy  VARCHAR2
705     , p8_a6 out nocopy  NUMBER
706     , p8_a7 out nocopy  VARCHAR2
707     , p8_a8 out nocopy  VARCHAR2
708     , p8_a9 out nocopy  VARCHAR2
709     , p8_a10 out nocopy  VARCHAR2
710     , p8_a11 out nocopy  VARCHAR2
711     , p8_a12 out nocopy  VARCHAR2
712     , p8_a13 out nocopy  VARCHAR2
713     , p8_a14 out nocopy  VARCHAR2
714     , p8_a15 out nocopy  VARCHAR2
715     , p8_a16 out nocopy  VARCHAR2
716     , p8_a17 out nocopy  VARCHAR2
717     , p8_a18 out nocopy  VARCHAR2
718     , p8_a19 out nocopy  VARCHAR2
719     , p8_a20 out nocopy  VARCHAR2
720     , p8_a21 out nocopy  VARCHAR2
721     , p8_a22 out nocopy  VARCHAR2
722     , p8_a23 out nocopy  NUMBER
723     , p8_a24 out nocopy  DATE
724     , p8_a25 out nocopy  NUMBER
725     , p8_a26 out nocopy  DATE
726     , p8_a27 out nocopy  NUMBER
727     , p9_a0 out nocopy JTF_NUMBER_TABLE
728     , p9_a1 out nocopy JTF_NUMBER_TABLE
729     , p9_a2 out nocopy JTF_NUMBER_TABLE
730     , p9_a3 out nocopy JTF_NUMBER_TABLE
731     , p9_a4 out nocopy JTF_NUMBER_TABLE
732     , p9_a5 out nocopy JTF_NUMBER_TABLE
733     , p9_a6 out nocopy JTF_NUMBER_TABLE
734     , p9_a7 out nocopy JTF_NUMBER_TABLE
735     , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
736     , p9_a9 out nocopy JTF_VARCHAR2_TABLE_500
737     , p9_a10 out nocopy JTF_VARCHAR2_TABLE_500
738     , p9_a11 out nocopy JTF_VARCHAR2_TABLE_500
739     , p9_a12 out nocopy JTF_VARCHAR2_TABLE_500
740     , p9_a13 out nocopy JTF_VARCHAR2_TABLE_500
741     , p9_a14 out nocopy JTF_VARCHAR2_TABLE_500
742     , p9_a15 out nocopy JTF_VARCHAR2_TABLE_500
743     , p9_a16 out nocopy JTF_VARCHAR2_TABLE_500
744     , p9_a17 out nocopy JTF_VARCHAR2_TABLE_500
745     , p9_a18 out nocopy JTF_VARCHAR2_TABLE_500
746     , p9_a19 out nocopy JTF_VARCHAR2_TABLE_500
747     , p9_a20 out nocopy JTF_VARCHAR2_TABLE_500
748     , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500
749     , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500
750     , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
751     , p9_a24 out nocopy JTF_NUMBER_TABLE
752     , p9_a25 out nocopy JTF_DATE_TABLE
753     , p9_a26 out nocopy JTF_NUMBER_TABLE
754     , p9_a27 out nocopy JTF_DATE_TABLE
755     , p9_a28 out nocopy JTF_NUMBER_TABLE
756     , p10_a0 out nocopy JTF_NUMBER_TABLE
757     , p10_a1 out nocopy JTF_NUMBER_TABLE
758     , p10_a2 out nocopy JTF_NUMBER_TABLE
759     , p10_a3 out nocopy JTF_NUMBER_TABLE
760     , p10_a4 out nocopy JTF_NUMBER_TABLE
761     , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
762     , p10_a6 out nocopy JTF_VARCHAR2_TABLE_500
763     , p10_a7 out nocopy JTF_VARCHAR2_TABLE_500
764     , p10_a8 out nocopy JTF_VARCHAR2_TABLE_500
765     , p10_a9 out nocopy JTF_VARCHAR2_TABLE_500
766     , p10_a10 out nocopy JTF_VARCHAR2_TABLE_500
767     , p10_a11 out nocopy JTF_VARCHAR2_TABLE_500
768     , p10_a12 out nocopy JTF_VARCHAR2_TABLE_500
769     , p10_a13 out nocopy JTF_VARCHAR2_TABLE_500
770     , p10_a14 out nocopy JTF_VARCHAR2_TABLE_500
771     , p10_a15 out nocopy JTF_VARCHAR2_TABLE_500
772     , p10_a16 out nocopy JTF_VARCHAR2_TABLE_500
773     , p10_a17 out nocopy JTF_VARCHAR2_TABLE_500
774     , p10_a18 out nocopy JTF_VARCHAR2_TABLE_500
775     , p10_a19 out nocopy JTF_VARCHAR2_TABLE_500
776     , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
777     , p10_a21 out nocopy JTF_NUMBER_TABLE
778     , p10_a22 out nocopy JTF_DATE_TABLE
779     , p10_a23 out nocopy JTF_NUMBER_TABLE
780     , p10_a24 out nocopy JTF_DATE_TABLE
781     , p10_a25 out nocopy JTF_NUMBER_TABLE
782   );
783   procedure invalid_objects(p_api_version  NUMBER
784     , p_init_msg_list  VARCHAR2
785     , x_return_status out nocopy  VARCHAR2
786     , x_msg_count out nocopy  NUMBER
787     , x_msg_data out nocopy  VARCHAR2
788     , p_version_id  NUMBER
789     , p6_a0 out nocopy JTF_NUMBER_TABLE
790     , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
791     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
792     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
793   );
794   procedure calc_start_date(p_api_version  NUMBER
795     , p_init_msg_list  VARCHAR2
796     , x_return_status out nocopy  VARCHAR2
797     , x_msg_count out nocopy  NUMBER
798     , x_msg_data out nocopy  VARCHAR2
799     , p5_a0  NUMBER
800     , p5_a1  NUMBER
801     , p5_a2  VARCHAR2
802     , p5_a3  DATE
803     , p5_a4  DATE
804     , p5_a5  VARCHAR2
805     , p5_a6  NUMBER
806     , p5_a7  VARCHAR2
807     , p5_a8  VARCHAR2
808     , p5_a9  VARCHAR2
809     , p5_a10  VARCHAR2
810     , p5_a11  VARCHAR2
811     , p5_a12  VARCHAR2
812     , p5_a13  VARCHAR2
813     , p5_a14  VARCHAR2
814     , p5_a15  VARCHAR2
815     , p5_a16  VARCHAR2
816     , p5_a17  VARCHAR2
817     , p5_a18  VARCHAR2
818     , p5_a19  VARCHAR2
819     , p5_a20  VARCHAR2
820     , p5_a21  VARCHAR2
821     , p5_a22  VARCHAR2
822     , p5_a23  NUMBER
823     , p5_a24  DATE
824     , p5_a25  NUMBER
825     , p5_a26  DATE
826     , p5_a27  NUMBER
827     , x_cal_eff_from out nocopy  DATE
828   );
829 end okl_fe_eo_term_options_pub_w;