DBA Data[Home] [Help]

PACKAGE: APPS.OKL_FE_EO_TERM_OPTIONS_PVT_W

Source


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