1: package body okl_fe_eo_term_options_pvt_w as
2: /* $Header: OKLEEOTB.pls 120.0 2005/07/07 10:37:19 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: ) as
24: end loop;
25: end if;
26: end if;
27: end rosetta_table_copy_in_p9;
28: procedure rosetta_table_copy_out_p9(t okl_fe_eo_term_options_pvt.invalid_object_tbl, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_VARCHAR2_TABLE_300
30: , a2 out nocopy JTF_VARCHAR2_TABLE_100
31: , a3 out nocopy JTF_VARCHAR2_TABLE_100
32: ) as
32: ) as
33: ddindx binary_integer; indx binary_integer;
34: begin
35: if t is null or t.count = 0 then
36: a0 := JTF_NUMBER_TABLE();
37: a1 := JTF_VARCHAR2_TABLE_300();
38: a2 := JTF_VARCHAR2_TABLE_100();
39: a3 := JTF_VARCHAR2_TABLE_100();
40: else
37: a1 := JTF_VARCHAR2_TABLE_300();
38: a2 := JTF_VARCHAR2_TABLE_100();
39: a3 := JTF_VARCHAR2_TABLE_100();
40: else
41: a0 := JTF_NUMBER_TABLE();
42: a1 := JTF_VARCHAR2_TABLE_300();
43: a2 := JTF_VARCHAR2_TABLE_100();
44: a3 := JTF_VARCHAR2_TABLE_100();
45: if t.count > 0 then
70: , x_msg_count out nocopy NUMBER
71: , x_msg_data out nocopy VARCHAR2
72: , p_end_of_term_id NUMBER
73: , p_version VARCHAR2
74: , p7_a0 out nocopy JTF_NUMBER_TABLE
75: , p7_a1 out nocopy JTF_NUMBER_TABLE
76: , p7_a2 out nocopy JTF_NUMBER_TABLE
77: , p7_a3 out nocopy JTF_NUMBER_TABLE
78: , p7_a4 out nocopy JTF_NUMBER_TABLE
71: , x_msg_data out nocopy VARCHAR2
72: , p_end_of_term_id NUMBER
73: , p_version VARCHAR2
74: , p7_a0 out nocopy JTF_NUMBER_TABLE
75: , p7_a1 out nocopy JTF_NUMBER_TABLE
76: , p7_a2 out nocopy JTF_NUMBER_TABLE
77: , p7_a3 out nocopy JTF_NUMBER_TABLE
78: , p7_a4 out nocopy JTF_NUMBER_TABLE
79: , p7_a5 out nocopy JTF_NUMBER_TABLE
72: , p_end_of_term_id NUMBER
73: , p_version VARCHAR2
74: , p7_a0 out nocopy JTF_NUMBER_TABLE
75: , p7_a1 out nocopy JTF_NUMBER_TABLE
76: , p7_a2 out nocopy JTF_NUMBER_TABLE
77: , p7_a3 out nocopy JTF_NUMBER_TABLE
78: , p7_a4 out nocopy JTF_NUMBER_TABLE
79: , p7_a5 out nocopy JTF_NUMBER_TABLE
80: , p7_a6 out nocopy JTF_NUMBER_TABLE
73: , p_version VARCHAR2
74: , p7_a0 out nocopy JTF_NUMBER_TABLE
75: , p7_a1 out nocopy JTF_NUMBER_TABLE
76: , p7_a2 out nocopy JTF_NUMBER_TABLE
77: , p7_a3 out nocopy JTF_NUMBER_TABLE
78: , p7_a4 out nocopy JTF_NUMBER_TABLE
79: , p7_a5 out nocopy JTF_NUMBER_TABLE
80: , p7_a6 out nocopy JTF_NUMBER_TABLE
81: , p7_a7 out nocopy JTF_NUMBER_TABLE
74: , p7_a0 out nocopy JTF_NUMBER_TABLE
75: , p7_a1 out nocopy JTF_NUMBER_TABLE
76: , p7_a2 out nocopy JTF_NUMBER_TABLE
77: , p7_a3 out nocopy JTF_NUMBER_TABLE
78: , p7_a4 out nocopy JTF_NUMBER_TABLE
79: , p7_a5 out nocopy JTF_NUMBER_TABLE
80: , p7_a6 out nocopy JTF_NUMBER_TABLE
81: , p7_a7 out nocopy JTF_NUMBER_TABLE
82: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
75: , p7_a1 out nocopy JTF_NUMBER_TABLE
76: , p7_a2 out nocopy JTF_NUMBER_TABLE
77: , p7_a3 out nocopy JTF_NUMBER_TABLE
78: , p7_a4 out nocopy JTF_NUMBER_TABLE
79: , p7_a5 out nocopy JTF_NUMBER_TABLE
80: , p7_a6 out nocopy JTF_NUMBER_TABLE
81: , p7_a7 out nocopy JTF_NUMBER_TABLE
82: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
83: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_500
76: , p7_a2 out nocopy JTF_NUMBER_TABLE
77: , p7_a3 out nocopy JTF_NUMBER_TABLE
78: , p7_a4 out nocopy JTF_NUMBER_TABLE
79: , p7_a5 out nocopy JTF_NUMBER_TABLE
80: , p7_a6 out nocopy JTF_NUMBER_TABLE
81: , p7_a7 out nocopy JTF_NUMBER_TABLE
82: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
83: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_500
84: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_500
77: , p7_a3 out nocopy JTF_NUMBER_TABLE
78: , p7_a4 out nocopy JTF_NUMBER_TABLE
79: , p7_a5 out nocopy JTF_NUMBER_TABLE
80: , p7_a6 out nocopy JTF_NUMBER_TABLE
81: , p7_a7 out nocopy JTF_NUMBER_TABLE
82: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
83: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_500
84: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_500
85: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_500
94: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_500
95: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_500
96: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_500
97: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_500
98: , p7_a24 out nocopy JTF_NUMBER_TABLE
99: , p7_a25 out nocopy JTF_DATE_TABLE
100: , p7_a26 out nocopy JTF_NUMBER_TABLE
101: , p7_a27 out nocopy JTF_DATE_TABLE
102: , p7_a28 out nocopy JTF_NUMBER_TABLE
96: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_500
97: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_500
98: , p7_a24 out nocopy JTF_NUMBER_TABLE
99: , p7_a25 out nocopy JTF_DATE_TABLE
100: , p7_a26 out nocopy JTF_NUMBER_TABLE
101: , p7_a27 out nocopy JTF_DATE_TABLE
102: , p7_a28 out nocopy JTF_NUMBER_TABLE
103: )
104:
98: , p7_a24 out nocopy JTF_NUMBER_TABLE
99: , p7_a25 out nocopy JTF_DATE_TABLE
100: , p7_a26 out nocopy JTF_NUMBER_TABLE
101: , p7_a27 out nocopy JTF_DATE_TABLE
102: , p7_a28 out nocopy JTF_NUMBER_TABLE
103: )
104:
105: as
106: ddx_eto_tbl okl_fe_eo_term_options_pvt.okl_eto_tbl;
172: , x_msg_count out nocopy NUMBER
173: , x_msg_data out nocopy VARCHAR2
174: , p_end_of_term_id NUMBER
175: , p_version VARCHAR2
176: , p7_a0 out nocopy JTF_NUMBER_TABLE
177: , p7_a1 out nocopy JTF_NUMBER_TABLE
178: , p7_a2 out nocopy JTF_NUMBER_TABLE
179: , p7_a3 out nocopy JTF_NUMBER_TABLE
180: , p7_a4 out nocopy JTF_NUMBER_TABLE
173: , x_msg_data out nocopy VARCHAR2
174: , p_end_of_term_id NUMBER
175: , p_version VARCHAR2
176: , p7_a0 out nocopy JTF_NUMBER_TABLE
177: , p7_a1 out nocopy JTF_NUMBER_TABLE
178: , p7_a2 out nocopy JTF_NUMBER_TABLE
179: , p7_a3 out nocopy JTF_NUMBER_TABLE
180: , p7_a4 out nocopy JTF_NUMBER_TABLE
181: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
174: , p_end_of_term_id NUMBER
175: , p_version VARCHAR2
176: , p7_a0 out nocopy JTF_NUMBER_TABLE
177: , p7_a1 out nocopy JTF_NUMBER_TABLE
178: , p7_a2 out nocopy JTF_NUMBER_TABLE
179: , p7_a3 out nocopy JTF_NUMBER_TABLE
180: , p7_a4 out nocopy JTF_NUMBER_TABLE
181: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
182: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_500
175: , p_version VARCHAR2
176: , p7_a0 out nocopy JTF_NUMBER_TABLE
177: , p7_a1 out nocopy JTF_NUMBER_TABLE
178: , p7_a2 out nocopy JTF_NUMBER_TABLE
179: , p7_a3 out nocopy JTF_NUMBER_TABLE
180: , p7_a4 out nocopy JTF_NUMBER_TABLE
181: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
182: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_500
183: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_500
176: , p7_a0 out nocopy JTF_NUMBER_TABLE
177: , p7_a1 out nocopy JTF_NUMBER_TABLE
178: , p7_a2 out nocopy JTF_NUMBER_TABLE
179: , p7_a3 out nocopy JTF_NUMBER_TABLE
180: , p7_a4 out nocopy JTF_NUMBER_TABLE
181: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
182: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_500
183: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_500
184: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_500
193: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_500
194: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_500
195: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_500
196: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_500
197: , p7_a21 out nocopy JTF_NUMBER_TABLE
198: , p7_a22 out nocopy JTF_DATE_TABLE
199: , p7_a23 out nocopy JTF_NUMBER_TABLE
200: , p7_a24 out nocopy JTF_DATE_TABLE
201: , p7_a25 out nocopy JTF_NUMBER_TABLE
195: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_500
196: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_500
197: , p7_a21 out nocopy JTF_NUMBER_TABLE
198: , p7_a22 out nocopy JTF_DATE_TABLE
199: , p7_a23 out nocopy JTF_NUMBER_TABLE
200: , p7_a24 out nocopy JTF_DATE_TABLE
201: , p7_a25 out nocopy JTF_NUMBER_TABLE
202: )
203:
197: , p7_a21 out nocopy JTF_NUMBER_TABLE
198: , p7_a22 out nocopy JTF_DATE_TABLE
199: , p7_a23 out nocopy JTF_NUMBER_TABLE
200: , p7_a24 out nocopy JTF_DATE_TABLE
201: , p7_a25 out nocopy JTF_NUMBER_TABLE
202: )
203:
204: as
205: ddx_etv_tbl okl_fe_eo_term_options_pvt.okl_etv_tbl;
330: , p8_a24 out nocopy DATE
331: , p8_a25 out nocopy NUMBER
332: , p8_a26 out nocopy DATE
333: , p8_a27 out nocopy NUMBER
334: , p9_a0 out nocopy JTF_NUMBER_TABLE
335: , p9_a1 out nocopy JTF_NUMBER_TABLE
336: , p9_a2 out nocopy JTF_NUMBER_TABLE
337: , p9_a3 out nocopy JTF_NUMBER_TABLE
338: , p9_a4 out nocopy JTF_NUMBER_TABLE
331: , p8_a25 out nocopy NUMBER
332: , p8_a26 out nocopy DATE
333: , p8_a27 out nocopy NUMBER
334: , p9_a0 out nocopy JTF_NUMBER_TABLE
335: , p9_a1 out nocopy JTF_NUMBER_TABLE
336: , p9_a2 out nocopy JTF_NUMBER_TABLE
337: , p9_a3 out nocopy JTF_NUMBER_TABLE
338: , p9_a4 out nocopy JTF_NUMBER_TABLE
339: , p9_a5 out nocopy JTF_NUMBER_TABLE
332: , p8_a26 out nocopy DATE
333: , p8_a27 out nocopy NUMBER
334: , p9_a0 out nocopy JTF_NUMBER_TABLE
335: , p9_a1 out nocopy JTF_NUMBER_TABLE
336: , p9_a2 out nocopy JTF_NUMBER_TABLE
337: , p9_a3 out nocopy JTF_NUMBER_TABLE
338: , p9_a4 out nocopy JTF_NUMBER_TABLE
339: , p9_a5 out nocopy JTF_NUMBER_TABLE
340: , p9_a6 out nocopy JTF_NUMBER_TABLE
333: , p8_a27 out nocopy NUMBER
334: , p9_a0 out nocopy JTF_NUMBER_TABLE
335: , p9_a1 out nocopy JTF_NUMBER_TABLE
336: , p9_a2 out nocopy JTF_NUMBER_TABLE
337: , p9_a3 out nocopy JTF_NUMBER_TABLE
338: , p9_a4 out nocopy JTF_NUMBER_TABLE
339: , p9_a5 out nocopy JTF_NUMBER_TABLE
340: , p9_a6 out nocopy JTF_NUMBER_TABLE
341: , p9_a7 out nocopy JTF_NUMBER_TABLE
334: , p9_a0 out nocopy JTF_NUMBER_TABLE
335: , p9_a1 out nocopy JTF_NUMBER_TABLE
336: , p9_a2 out nocopy JTF_NUMBER_TABLE
337: , p9_a3 out nocopy JTF_NUMBER_TABLE
338: , p9_a4 out nocopy JTF_NUMBER_TABLE
339: , p9_a5 out nocopy JTF_NUMBER_TABLE
340: , p9_a6 out nocopy JTF_NUMBER_TABLE
341: , p9_a7 out nocopy JTF_NUMBER_TABLE
342: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
335: , p9_a1 out nocopy JTF_NUMBER_TABLE
336: , p9_a2 out nocopy JTF_NUMBER_TABLE
337: , p9_a3 out nocopy JTF_NUMBER_TABLE
338: , p9_a4 out nocopy JTF_NUMBER_TABLE
339: , p9_a5 out nocopy JTF_NUMBER_TABLE
340: , p9_a6 out nocopy JTF_NUMBER_TABLE
341: , p9_a7 out nocopy JTF_NUMBER_TABLE
342: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
343: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_500
336: , p9_a2 out nocopy JTF_NUMBER_TABLE
337: , p9_a3 out nocopy JTF_NUMBER_TABLE
338: , p9_a4 out nocopy JTF_NUMBER_TABLE
339: , p9_a5 out nocopy JTF_NUMBER_TABLE
340: , p9_a6 out nocopy JTF_NUMBER_TABLE
341: , p9_a7 out nocopy JTF_NUMBER_TABLE
342: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
343: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_500
344: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_500
337: , p9_a3 out nocopy JTF_NUMBER_TABLE
338: , p9_a4 out nocopy JTF_NUMBER_TABLE
339: , p9_a5 out nocopy JTF_NUMBER_TABLE
340: , p9_a6 out nocopy JTF_NUMBER_TABLE
341: , p9_a7 out nocopy JTF_NUMBER_TABLE
342: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
343: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_500
344: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_500
345: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_500
354: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_500
355: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500
356: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500
357: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
358: , p9_a24 out nocopy JTF_NUMBER_TABLE
359: , p9_a25 out nocopy JTF_DATE_TABLE
360: , p9_a26 out nocopy JTF_NUMBER_TABLE
361: , p9_a27 out nocopy JTF_DATE_TABLE
362: , p9_a28 out nocopy JTF_NUMBER_TABLE
356: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500
357: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
358: , p9_a24 out nocopy JTF_NUMBER_TABLE
359: , p9_a25 out nocopy JTF_DATE_TABLE
360: , p9_a26 out nocopy JTF_NUMBER_TABLE
361: , p9_a27 out nocopy JTF_DATE_TABLE
362: , p9_a28 out nocopy JTF_NUMBER_TABLE
363: , p10_a0 out nocopy JTF_NUMBER_TABLE
364: , p10_a1 out nocopy JTF_NUMBER_TABLE
358: , p9_a24 out nocopy JTF_NUMBER_TABLE
359: , p9_a25 out nocopy JTF_DATE_TABLE
360: , p9_a26 out nocopy JTF_NUMBER_TABLE
361: , p9_a27 out nocopy JTF_DATE_TABLE
362: , p9_a28 out nocopy JTF_NUMBER_TABLE
363: , p10_a0 out nocopy JTF_NUMBER_TABLE
364: , p10_a1 out nocopy JTF_NUMBER_TABLE
365: , p10_a2 out nocopy JTF_NUMBER_TABLE
366: , p10_a3 out nocopy JTF_NUMBER_TABLE
359: , p9_a25 out nocopy JTF_DATE_TABLE
360: , p9_a26 out nocopy JTF_NUMBER_TABLE
361: , p9_a27 out nocopy JTF_DATE_TABLE
362: , p9_a28 out nocopy JTF_NUMBER_TABLE
363: , p10_a0 out nocopy JTF_NUMBER_TABLE
364: , p10_a1 out nocopy JTF_NUMBER_TABLE
365: , p10_a2 out nocopy JTF_NUMBER_TABLE
366: , p10_a3 out nocopy JTF_NUMBER_TABLE
367: , p10_a4 out nocopy JTF_NUMBER_TABLE
360: , p9_a26 out nocopy JTF_NUMBER_TABLE
361: , p9_a27 out nocopy JTF_DATE_TABLE
362: , p9_a28 out nocopy JTF_NUMBER_TABLE
363: , p10_a0 out nocopy JTF_NUMBER_TABLE
364: , p10_a1 out nocopy JTF_NUMBER_TABLE
365: , p10_a2 out nocopy JTF_NUMBER_TABLE
366: , p10_a3 out nocopy JTF_NUMBER_TABLE
367: , p10_a4 out nocopy JTF_NUMBER_TABLE
368: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
361: , p9_a27 out nocopy JTF_DATE_TABLE
362: , p9_a28 out nocopy JTF_NUMBER_TABLE
363: , p10_a0 out nocopy JTF_NUMBER_TABLE
364: , p10_a1 out nocopy JTF_NUMBER_TABLE
365: , p10_a2 out nocopy JTF_NUMBER_TABLE
366: , p10_a3 out nocopy JTF_NUMBER_TABLE
367: , p10_a4 out nocopy JTF_NUMBER_TABLE
368: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
369: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_500
362: , p9_a28 out nocopy JTF_NUMBER_TABLE
363: , p10_a0 out nocopy JTF_NUMBER_TABLE
364: , p10_a1 out nocopy JTF_NUMBER_TABLE
365: , p10_a2 out nocopy JTF_NUMBER_TABLE
366: , p10_a3 out nocopy JTF_NUMBER_TABLE
367: , p10_a4 out nocopy JTF_NUMBER_TABLE
368: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
369: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_500
370: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_500
363: , p10_a0 out nocopy JTF_NUMBER_TABLE
364: , p10_a1 out nocopy JTF_NUMBER_TABLE
365: , p10_a2 out nocopy JTF_NUMBER_TABLE
366: , p10_a3 out nocopy JTF_NUMBER_TABLE
367: , p10_a4 out nocopy JTF_NUMBER_TABLE
368: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
369: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_500
370: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_500
371: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_500
380: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_500
381: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_500
382: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_500
383: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
384: , p10_a21 out nocopy JTF_NUMBER_TABLE
385: , p10_a22 out nocopy JTF_DATE_TABLE
386: , p10_a23 out nocopy JTF_NUMBER_TABLE
387: , p10_a24 out nocopy JTF_DATE_TABLE
388: , p10_a25 out nocopy JTF_NUMBER_TABLE
382: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_500
383: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
384: , p10_a21 out nocopy JTF_NUMBER_TABLE
385: , p10_a22 out nocopy JTF_DATE_TABLE
386: , p10_a23 out nocopy JTF_NUMBER_TABLE
387: , p10_a24 out nocopy JTF_DATE_TABLE
388: , p10_a25 out nocopy JTF_NUMBER_TABLE
389: )
390:
384: , p10_a21 out nocopy JTF_NUMBER_TABLE
385: , p10_a22 out nocopy JTF_DATE_TABLE
386: , p10_a23 out nocopy JTF_NUMBER_TABLE
387: , p10_a24 out nocopy JTF_DATE_TABLE
388: , p10_a25 out nocopy JTF_NUMBER_TABLE
389: )
390:
391: as
392: ddx_ethv_rec okl_fe_eo_term_options_pvt.okl_ethv_rec;
619: , p6_a24 DATE
620: , p6_a25 NUMBER
621: , p6_a26 DATE
622: , p6_a27 NUMBER
623: , p7_a0 JTF_NUMBER_TABLE
624: , p7_a1 JTF_NUMBER_TABLE
625: , p7_a2 JTF_NUMBER_TABLE
626: , p7_a3 JTF_NUMBER_TABLE
627: , p7_a4 JTF_NUMBER_TABLE
620: , p6_a25 NUMBER
621: , p6_a26 DATE
622: , p6_a27 NUMBER
623: , p7_a0 JTF_NUMBER_TABLE
624: , p7_a1 JTF_NUMBER_TABLE
625: , p7_a2 JTF_NUMBER_TABLE
626: , p7_a3 JTF_NUMBER_TABLE
627: , p7_a4 JTF_NUMBER_TABLE
628: , p7_a5 JTF_NUMBER_TABLE
621: , p6_a26 DATE
622: , p6_a27 NUMBER
623: , p7_a0 JTF_NUMBER_TABLE
624: , p7_a1 JTF_NUMBER_TABLE
625: , p7_a2 JTF_NUMBER_TABLE
626: , p7_a3 JTF_NUMBER_TABLE
627: , p7_a4 JTF_NUMBER_TABLE
628: , p7_a5 JTF_NUMBER_TABLE
629: , p7_a6 JTF_NUMBER_TABLE
622: , p6_a27 NUMBER
623: , p7_a0 JTF_NUMBER_TABLE
624: , p7_a1 JTF_NUMBER_TABLE
625: , p7_a2 JTF_NUMBER_TABLE
626: , p7_a3 JTF_NUMBER_TABLE
627: , p7_a4 JTF_NUMBER_TABLE
628: , p7_a5 JTF_NUMBER_TABLE
629: , p7_a6 JTF_NUMBER_TABLE
630: , p7_a7 JTF_NUMBER_TABLE
623: , p7_a0 JTF_NUMBER_TABLE
624: , p7_a1 JTF_NUMBER_TABLE
625: , p7_a2 JTF_NUMBER_TABLE
626: , p7_a3 JTF_NUMBER_TABLE
627: , p7_a4 JTF_NUMBER_TABLE
628: , p7_a5 JTF_NUMBER_TABLE
629: , p7_a6 JTF_NUMBER_TABLE
630: , p7_a7 JTF_NUMBER_TABLE
631: , p7_a8 JTF_VARCHAR2_TABLE_100
624: , p7_a1 JTF_NUMBER_TABLE
625: , p7_a2 JTF_NUMBER_TABLE
626: , p7_a3 JTF_NUMBER_TABLE
627: , p7_a4 JTF_NUMBER_TABLE
628: , p7_a5 JTF_NUMBER_TABLE
629: , p7_a6 JTF_NUMBER_TABLE
630: , p7_a7 JTF_NUMBER_TABLE
631: , p7_a8 JTF_VARCHAR2_TABLE_100
632: , p7_a9 JTF_VARCHAR2_TABLE_500
625: , p7_a2 JTF_NUMBER_TABLE
626: , p7_a3 JTF_NUMBER_TABLE
627: , p7_a4 JTF_NUMBER_TABLE
628: , p7_a5 JTF_NUMBER_TABLE
629: , p7_a6 JTF_NUMBER_TABLE
630: , p7_a7 JTF_NUMBER_TABLE
631: , p7_a8 JTF_VARCHAR2_TABLE_100
632: , p7_a9 JTF_VARCHAR2_TABLE_500
633: , p7_a10 JTF_VARCHAR2_TABLE_500
626: , p7_a3 JTF_NUMBER_TABLE
627: , p7_a4 JTF_NUMBER_TABLE
628: , p7_a5 JTF_NUMBER_TABLE
629: , p7_a6 JTF_NUMBER_TABLE
630: , p7_a7 JTF_NUMBER_TABLE
631: , p7_a8 JTF_VARCHAR2_TABLE_100
632: , p7_a9 JTF_VARCHAR2_TABLE_500
633: , p7_a10 JTF_VARCHAR2_TABLE_500
634: , p7_a11 JTF_VARCHAR2_TABLE_500
643: , p7_a20 JTF_VARCHAR2_TABLE_500
644: , p7_a21 JTF_VARCHAR2_TABLE_500
645: , p7_a22 JTF_VARCHAR2_TABLE_500
646: , p7_a23 JTF_VARCHAR2_TABLE_500
647: , p7_a24 JTF_NUMBER_TABLE
648: , p7_a25 JTF_DATE_TABLE
649: , p7_a26 JTF_NUMBER_TABLE
650: , p7_a27 JTF_DATE_TABLE
651: , p7_a28 JTF_NUMBER_TABLE
645: , p7_a22 JTF_VARCHAR2_TABLE_500
646: , p7_a23 JTF_VARCHAR2_TABLE_500
647: , p7_a24 JTF_NUMBER_TABLE
648: , p7_a25 JTF_DATE_TABLE
649: , p7_a26 JTF_NUMBER_TABLE
650: , p7_a27 JTF_DATE_TABLE
651: , p7_a28 JTF_NUMBER_TABLE
652: , p8_a0 JTF_NUMBER_TABLE
653: , p8_a1 JTF_NUMBER_TABLE
647: , p7_a24 JTF_NUMBER_TABLE
648: , p7_a25 JTF_DATE_TABLE
649: , p7_a26 JTF_NUMBER_TABLE
650: , p7_a27 JTF_DATE_TABLE
651: , p7_a28 JTF_NUMBER_TABLE
652: , p8_a0 JTF_NUMBER_TABLE
653: , p8_a1 JTF_NUMBER_TABLE
654: , p8_a2 JTF_NUMBER_TABLE
655: , p8_a3 JTF_NUMBER_TABLE
648: , p7_a25 JTF_DATE_TABLE
649: , p7_a26 JTF_NUMBER_TABLE
650: , p7_a27 JTF_DATE_TABLE
651: , p7_a28 JTF_NUMBER_TABLE
652: , p8_a0 JTF_NUMBER_TABLE
653: , p8_a1 JTF_NUMBER_TABLE
654: , p8_a2 JTF_NUMBER_TABLE
655: , p8_a3 JTF_NUMBER_TABLE
656: , p8_a4 JTF_NUMBER_TABLE
649: , p7_a26 JTF_NUMBER_TABLE
650: , p7_a27 JTF_DATE_TABLE
651: , p7_a28 JTF_NUMBER_TABLE
652: , p8_a0 JTF_NUMBER_TABLE
653: , p8_a1 JTF_NUMBER_TABLE
654: , p8_a2 JTF_NUMBER_TABLE
655: , p8_a3 JTF_NUMBER_TABLE
656: , p8_a4 JTF_NUMBER_TABLE
657: , p8_a5 JTF_VARCHAR2_TABLE_100
650: , p7_a27 JTF_DATE_TABLE
651: , p7_a28 JTF_NUMBER_TABLE
652: , p8_a0 JTF_NUMBER_TABLE
653: , p8_a1 JTF_NUMBER_TABLE
654: , p8_a2 JTF_NUMBER_TABLE
655: , p8_a3 JTF_NUMBER_TABLE
656: , p8_a4 JTF_NUMBER_TABLE
657: , p8_a5 JTF_VARCHAR2_TABLE_100
658: , p8_a6 JTF_VARCHAR2_TABLE_500
651: , p7_a28 JTF_NUMBER_TABLE
652: , p8_a0 JTF_NUMBER_TABLE
653: , p8_a1 JTF_NUMBER_TABLE
654: , p8_a2 JTF_NUMBER_TABLE
655: , p8_a3 JTF_NUMBER_TABLE
656: , p8_a4 JTF_NUMBER_TABLE
657: , p8_a5 JTF_VARCHAR2_TABLE_100
658: , p8_a6 JTF_VARCHAR2_TABLE_500
659: , p8_a7 JTF_VARCHAR2_TABLE_500
652: , p8_a0 JTF_NUMBER_TABLE
653: , p8_a1 JTF_NUMBER_TABLE
654: , p8_a2 JTF_NUMBER_TABLE
655: , p8_a3 JTF_NUMBER_TABLE
656: , p8_a4 JTF_NUMBER_TABLE
657: , p8_a5 JTF_VARCHAR2_TABLE_100
658: , p8_a6 JTF_VARCHAR2_TABLE_500
659: , p8_a7 JTF_VARCHAR2_TABLE_500
660: , p8_a8 JTF_VARCHAR2_TABLE_500
669: , p8_a17 JTF_VARCHAR2_TABLE_500
670: , p8_a18 JTF_VARCHAR2_TABLE_500
671: , p8_a19 JTF_VARCHAR2_TABLE_500
672: , p8_a20 JTF_VARCHAR2_TABLE_500
673: , p8_a21 JTF_NUMBER_TABLE
674: , p8_a22 JTF_DATE_TABLE
675: , p8_a23 JTF_NUMBER_TABLE
676: , p8_a24 JTF_DATE_TABLE
677: , p8_a25 JTF_NUMBER_TABLE
671: , p8_a19 JTF_VARCHAR2_TABLE_500
672: , p8_a20 JTF_VARCHAR2_TABLE_500
673: , p8_a21 JTF_NUMBER_TABLE
674: , p8_a22 JTF_DATE_TABLE
675: , p8_a23 JTF_NUMBER_TABLE
676: , p8_a24 JTF_DATE_TABLE
677: , p8_a25 JTF_NUMBER_TABLE
678: , p9_a0 out nocopy NUMBER
679: , p9_a1 out nocopy NUMBER
673: , p8_a21 JTF_NUMBER_TABLE
674: , p8_a22 JTF_DATE_TABLE
675: , p8_a23 JTF_NUMBER_TABLE
676: , p8_a24 JTF_DATE_TABLE
677: , p8_a25 JTF_NUMBER_TABLE
678: , p9_a0 out nocopy NUMBER
679: , p9_a1 out nocopy NUMBER
680: , p9_a2 out nocopy VARCHAR2
681: , p9_a3 out nocopy VARCHAR2
736: , p10_a24 out nocopy DATE
737: , p10_a25 out nocopy NUMBER
738: , p10_a26 out nocopy DATE
739: , p10_a27 out nocopy NUMBER
740: , p11_a0 out nocopy JTF_NUMBER_TABLE
741: , p11_a1 out nocopy JTF_NUMBER_TABLE
742: , p11_a2 out nocopy JTF_NUMBER_TABLE
743: , p11_a3 out nocopy JTF_NUMBER_TABLE
744: , p11_a4 out nocopy JTF_NUMBER_TABLE
737: , p10_a25 out nocopy NUMBER
738: , p10_a26 out nocopy DATE
739: , p10_a27 out nocopy NUMBER
740: , p11_a0 out nocopy JTF_NUMBER_TABLE
741: , p11_a1 out nocopy JTF_NUMBER_TABLE
742: , p11_a2 out nocopy JTF_NUMBER_TABLE
743: , p11_a3 out nocopy JTF_NUMBER_TABLE
744: , p11_a4 out nocopy JTF_NUMBER_TABLE
745: , p11_a5 out nocopy JTF_NUMBER_TABLE
738: , p10_a26 out nocopy DATE
739: , p10_a27 out nocopy NUMBER
740: , p11_a0 out nocopy JTF_NUMBER_TABLE
741: , p11_a1 out nocopy JTF_NUMBER_TABLE
742: , p11_a2 out nocopy JTF_NUMBER_TABLE
743: , p11_a3 out nocopy JTF_NUMBER_TABLE
744: , p11_a4 out nocopy JTF_NUMBER_TABLE
745: , p11_a5 out nocopy JTF_NUMBER_TABLE
746: , p11_a6 out nocopy JTF_NUMBER_TABLE
739: , p10_a27 out nocopy NUMBER
740: , p11_a0 out nocopy JTF_NUMBER_TABLE
741: , p11_a1 out nocopy JTF_NUMBER_TABLE
742: , p11_a2 out nocopy JTF_NUMBER_TABLE
743: , p11_a3 out nocopy JTF_NUMBER_TABLE
744: , p11_a4 out nocopy JTF_NUMBER_TABLE
745: , p11_a5 out nocopy JTF_NUMBER_TABLE
746: , p11_a6 out nocopy JTF_NUMBER_TABLE
747: , p11_a7 out nocopy JTF_NUMBER_TABLE
740: , p11_a0 out nocopy JTF_NUMBER_TABLE
741: , p11_a1 out nocopy JTF_NUMBER_TABLE
742: , p11_a2 out nocopy JTF_NUMBER_TABLE
743: , p11_a3 out nocopy JTF_NUMBER_TABLE
744: , p11_a4 out nocopy JTF_NUMBER_TABLE
745: , p11_a5 out nocopy JTF_NUMBER_TABLE
746: , p11_a6 out nocopy JTF_NUMBER_TABLE
747: , p11_a7 out nocopy JTF_NUMBER_TABLE
748: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
741: , p11_a1 out nocopy JTF_NUMBER_TABLE
742: , p11_a2 out nocopy JTF_NUMBER_TABLE
743: , p11_a3 out nocopy JTF_NUMBER_TABLE
744: , p11_a4 out nocopy JTF_NUMBER_TABLE
745: , p11_a5 out nocopy JTF_NUMBER_TABLE
746: , p11_a6 out nocopy JTF_NUMBER_TABLE
747: , p11_a7 out nocopy JTF_NUMBER_TABLE
748: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
749: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_500
742: , p11_a2 out nocopy JTF_NUMBER_TABLE
743: , p11_a3 out nocopy JTF_NUMBER_TABLE
744: , p11_a4 out nocopy JTF_NUMBER_TABLE
745: , p11_a5 out nocopy JTF_NUMBER_TABLE
746: , p11_a6 out nocopy JTF_NUMBER_TABLE
747: , p11_a7 out nocopy JTF_NUMBER_TABLE
748: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
749: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_500
750: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_500
743: , p11_a3 out nocopy JTF_NUMBER_TABLE
744: , p11_a4 out nocopy JTF_NUMBER_TABLE
745: , p11_a5 out nocopy JTF_NUMBER_TABLE
746: , p11_a6 out nocopy JTF_NUMBER_TABLE
747: , p11_a7 out nocopy JTF_NUMBER_TABLE
748: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
749: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_500
750: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_500
751: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_500
760: , p11_a20 out nocopy JTF_VARCHAR2_TABLE_500
761: , p11_a21 out nocopy JTF_VARCHAR2_TABLE_500
762: , p11_a22 out nocopy JTF_VARCHAR2_TABLE_500
763: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_500
764: , p11_a24 out nocopy JTF_NUMBER_TABLE
765: , p11_a25 out nocopy JTF_DATE_TABLE
766: , p11_a26 out nocopy JTF_NUMBER_TABLE
767: , p11_a27 out nocopy JTF_DATE_TABLE
768: , p11_a28 out nocopy JTF_NUMBER_TABLE
762: , p11_a22 out nocopy JTF_VARCHAR2_TABLE_500
763: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_500
764: , p11_a24 out nocopy JTF_NUMBER_TABLE
765: , p11_a25 out nocopy JTF_DATE_TABLE
766: , p11_a26 out nocopy JTF_NUMBER_TABLE
767: , p11_a27 out nocopy JTF_DATE_TABLE
768: , p11_a28 out nocopy JTF_NUMBER_TABLE
769: , p12_a0 out nocopy JTF_NUMBER_TABLE
770: , p12_a1 out nocopy JTF_NUMBER_TABLE
764: , p11_a24 out nocopy JTF_NUMBER_TABLE
765: , p11_a25 out nocopy JTF_DATE_TABLE
766: , p11_a26 out nocopy JTF_NUMBER_TABLE
767: , p11_a27 out nocopy JTF_DATE_TABLE
768: , p11_a28 out nocopy JTF_NUMBER_TABLE
769: , p12_a0 out nocopy JTF_NUMBER_TABLE
770: , p12_a1 out nocopy JTF_NUMBER_TABLE
771: , p12_a2 out nocopy JTF_NUMBER_TABLE
772: , p12_a3 out nocopy JTF_NUMBER_TABLE
765: , p11_a25 out nocopy JTF_DATE_TABLE
766: , p11_a26 out nocopy JTF_NUMBER_TABLE
767: , p11_a27 out nocopy JTF_DATE_TABLE
768: , p11_a28 out nocopy JTF_NUMBER_TABLE
769: , p12_a0 out nocopy JTF_NUMBER_TABLE
770: , p12_a1 out nocopy JTF_NUMBER_TABLE
771: , p12_a2 out nocopy JTF_NUMBER_TABLE
772: , p12_a3 out nocopy JTF_NUMBER_TABLE
773: , p12_a4 out nocopy JTF_NUMBER_TABLE
766: , p11_a26 out nocopy JTF_NUMBER_TABLE
767: , p11_a27 out nocopy JTF_DATE_TABLE
768: , p11_a28 out nocopy JTF_NUMBER_TABLE
769: , p12_a0 out nocopy JTF_NUMBER_TABLE
770: , p12_a1 out nocopy JTF_NUMBER_TABLE
771: , p12_a2 out nocopy JTF_NUMBER_TABLE
772: , p12_a3 out nocopy JTF_NUMBER_TABLE
773: , p12_a4 out nocopy JTF_NUMBER_TABLE
774: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
767: , p11_a27 out nocopy JTF_DATE_TABLE
768: , p11_a28 out nocopy JTF_NUMBER_TABLE
769: , p12_a0 out nocopy JTF_NUMBER_TABLE
770: , p12_a1 out nocopy JTF_NUMBER_TABLE
771: , p12_a2 out nocopy JTF_NUMBER_TABLE
772: , p12_a3 out nocopy JTF_NUMBER_TABLE
773: , p12_a4 out nocopy JTF_NUMBER_TABLE
774: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
775: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_500
768: , p11_a28 out nocopy JTF_NUMBER_TABLE
769: , p12_a0 out nocopy JTF_NUMBER_TABLE
770: , p12_a1 out nocopy JTF_NUMBER_TABLE
771: , p12_a2 out nocopy JTF_NUMBER_TABLE
772: , p12_a3 out nocopy JTF_NUMBER_TABLE
773: , p12_a4 out nocopy JTF_NUMBER_TABLE
774: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
775: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_500
776: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_500
769: , p12_a0 out nocopy JTF_NUMBER_TABLE
770: , p12_a1 out nocopy JTF_NUMBER_TABLE
771: , p12_a2 out nocopy JTF_NUMBER_TABLE
772: , p12_a3 out nocopy JTF_NUMBER_TABLE
773: , p12_a4 out nocopy JTF_NUMBER_TABLE
774: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
775: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_500
776: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_500
777: , p12_a8 out nocopy JTF_VARCHAR2_TABLE_500
786: , p12_a17 out nocopy JTF_VARCHAR2_TABLE_500
787: , p12_a18 out nocopy JTF_VARCHAR2_TABLE_500
788: , p12_a19 out nocopy JTF_VARCHAR2_TABLE_500
789: , p12_a20 out nocopy JTF_VARCHAR2_TABLE_500
790: , p12_a21 out nocopy JTF_NUMBER_TABLE
791: , p12_a22 out nocopy JTF_DATE_TABLE
792: , p12_a23 out nocopy JTF_NUMBER_TABLE
793: , p12_a24 out nocopy JTF_DATE_TABLE
794: , p12_a25 out nocopy JTF_NUMBER_TABLE
788: , p12_a19 out nocopy JTF_VARCHAR2_TABLE_500
789: , p12_a20 out nocopy JTF_VARCHAR2_TABLE_500
790: , p12_a21 out nocopy JTF_NUMBER_TABLE
791: , p12_a22 out nocopy JTF_DATE_TABLE
792: , p12_a23 out nocopy JTF_NUMBER_TABLE
793: , p12_a24 out nocopy JTF_DATE_TABLE
794: , p12_a25 out nocopy JTF_NUMBER_TABLE
795: )
796:
790: , p12_a21 out nocopy JTF_NUMBER_TABLE
791: , p12_a22 out nocopy JTF_DATE_TABLE
792: , p12_a23 out nocopy JTF_NUMBER_TABLE
793: , p12_a24 out nocopy JTF_DATE_TABLE
794: , p12_a25 out nocopy JTF_NUMBER_TABLE
795: )
796:
797: as
798: ddp_ethv_rec okl_fe_eo_term_options_pvt.okl_ethv_rec;
1120: , p5_a24 DATE
1121: , p5_a25 NUMBER
1122: , p5_a26 DATE
1123: , p5_a27 NUMBER
1124: , p6_a0 JTF_NUMBER_TABLE
1125: , p6_a1 JTF_NUMBER_TABLE
1126: , p6_a2 JTF_NUMBER_TABLE
1127: , p6_a3 JTF_NUMBER_TABLE
1128: , p6_a4 JTF_NUMBER_TABLE
1121: , p5_a25 NUMBER
1122: , p5_a26 DATE
1123: , p5_a27 NUMBER
1124: , p6_a0 JTF_NUMBER_TABLE
1125: , p6_a1 JTF_NUMBER_TABLE
1126: , p6_a2 JTF_NUMBER_TABLE
1127: , p6_a3 JTF_NUMBER_TABLE
1128: , p6_a4 JTF_NUMBER_TABLE
1129: , p6_a5 JTF_NUMBER_TABLE
1122: , p5_a26 DATE
1123: , p5_a27 NUMBER
1124: , p6_a0 JTF_NUMBER_TABLE
1125: , p6_a1 JTF_NUMBER_TABLE
1126: , p6_a2 JTF_NUMBER_TABLE
1127: , p6_a3 JTF_NUMBER_TABLE
1128: , p6_a4 JTF_NUMBER_TABLE
1129: , p6_a5 JTF_NUMBER_TABLE
1130: , p6_a6 JTF_NUMBER_TABLE
1123: , p5_a27 NUMBER
1124: , p6_a0 JTF_NUMBER_TABLE
1125: , p6_a1 JTF_NUMBER_TABLE
1126: , p6_a2 JTF_NUMBER_TABLE
1127: , p6_a3 JTF_NUMBER_TABLE
1128: , p6_a4 JTF_NUMBER_TABLE
1129: , p6_a5 JTF_NUMBER_TABLE
1130: , p6_a6 JTF_NUMBER_TABLE
1131: , p6_a7 JTF_NUMBER_TABLE
1124: , p6_a0 JTF_NUMBER_TABLE
1125: , p6_a1 JTF_NUMBER_TABLE
1126: , p6_a2 JTF_NUMBER_TABLE
1127: , p6_a3 JTF_NUMBER_TABLE
1128: , p6_a4 JTF_NUMBER_TABLE
1129: , p6_a5 JTF_NUMBER_TABLE
1130: , p6_a6 JTF_NUMBER_TABLE
1131: , p6_a7 JTF_NUMBER_TABLE
1132: , p6_a8 JTF_VARCHAR2_TABLE_100
1125: , p6_a1 JTF_NUMBER_TABLE
1126: , p6_a2 JTF_NUMBER_TABLE
1127: , p6_a3 JTF_NUMBER_TABLE
1128: , p6_a4 JTF_NUMBER_TABLE
1129: , p6_a5 JTF_NUMBER_TABLE
1130: , p6_a6 JTF_NUMBER_TABLE
1131: , p6_a7 JTF_NUMBER_TABLE
1132: , p6_a8 JTF_VARCHAR2_TABLE_100
1133: , p6_a9 JTF_VARCHAR2_TABLE_500
1126: , p6_a2 JTF_NUMBER_TABLE
1127: , p6_a3 JTF_NUMBER_TABLE
1128: , p6_a4 JTF_NUMBER_TABLE
1129: , p6_a5 JTF_NUMBER_TABLE
1130: , p6_a6 JTF_NUMBER_TABLE
1131: , p6_a7 JTF_NUMBER_TABLE
1132: , p6_a8 JTF_VARCHAR2_TABLE_100
1133: , p6_a9 JTF_VARCHAR2_TABLE_500
1134: , p6_a10 JTF_VARCHAR2_TABLE_500
1127: , p6_a3 JTF_NUMBER_TABLE
1128: , p6_a4 JTF_NUMBER_TABLE
1129: , p6_a5 JTF_NUMBER_TABLE
1130: , p6_a6 JTF_NUMBER_TABLE
1131: , p6_a7 JTF_NUMBER_TABLE
1132: , p6_a8 JTF_VARCHAR2_TABLE_100
1133: , p6_a9 JTF_VARCHAR2_TABLE_500
1134: , p6_a10 JTF_VARCHAR2_TABLE_500
1135: , p6_a11 JTF_VARCHAR2_TABLE_500
1144: , p6_a20 JTF_VARCHAR2_TABLE_500
1145: , p6_a21 JTF_VARCHAR2_TABLE_500
1146: , p6_a22 JTF_VARCHAR2_TABLE_500
1147: , p6_a23 JTF_VARCHAR2_TABLE_500
1148: , p6_a24 JTF_NUMBER_TABLE
1149: , p6_a25 JTF_DATE_TABLE
1150: , p6_a26 JTF_NUMBER_TABLE
1151: , p6_a27 JTF_DATE_TABLE
1152: , p6_a28 JTF_NUMBER_TABLE
1146: , p6_a22 JTF_VARCHAR2_TABLE_500
1147: , p6_a23 JTF_VARCHAR2_TABLE_500
1148: , p6_a24 JTF_NUMBER_TABLE
1149: , p6_a25 JTF_DATE_TABLE
1150: , p6_a26 JTF_NUMBER_TABLE
1151: , p6_a27 JTF_DATE_TABLE
1152: , p6_a28 JTF_NUMBER_TABLE
1153: , p7_a0 JTF_NUMBER_TABLE
1154: , p7_a1 JTF_NUMBER_TABLE
1148: , p6_a24 JTF_NUMBER_TABLE
1149: , p6_a25 JTF_DATE_TABLE
1150: , p6_a26 JTF_NUMBER_TABLE
1151: , p6_a27 JTF_DATE_TABLE
1152: , p6_a28 JTF_NUMBER_TABLE
1153: , p7_a0 JTF_NUMBER_TABLE
1154: , p7_a1 JTF_NUMBER_TABLE
1155: , p7_a2 JTF_NUMBER_TABLE
1156: , p7_a3 JTF_NUMBER_TABLE
1149: , p6_a25 JTF_DATE_TABLE
1150: , p6_a26 JTF_NUMBER_TABLE
1151: , p6_a27 JTF_DATE_TABLE
1152: , p6_a28 JTF_NUMBER_TABLE
1153: , p7_a0 JTF_NUMBER_TABLE
1154: , p7_a1 JTF_NUMBER_TABLE
1155: , p7_a2 JTF_NUMBER_TABLE
1156: , p7_a3 JTF_NUMBER_TABLE
1157: , p7_a4 JTF_NUMBER_TABLE
1150: , p6_a26 JTF_NUMBER_TABLE
1151: , p6_a27 JTF_DATE_TABLE
1152: , p6_a28 JTF_NUMBER_TABLE
1153: , p7_a0 JTF_NUMBER_TABLE
1154: , p7_a1 JTF_NUMBER_TABLE
1155: , p7_a2 JTF_NUMBER_TABLE
1156: , p7_a3 JTF_NUMBER_TABLE
1157: , p7_a4 JTF_NUMBER_TABLE
1158: , p7_a5 JTF_VARCHAR2_TABLE_100
1151: , p6_a27 JTF_DATE_TABLE
1152: , p6_a28 JTF_NUMBER_TABLE
1153: , p7_a0 JTF_NUMBER_TABLE
1154: , p7_a1 JTF_NUMBER_TABLE
1155: , p7_a2 JTF_NUMBER_TABLE
1156: , p7_a3 JTF_NUMBER_TABLE
1157: , p7_a4 JTF_NUMBER_TABLE
1158: , p7_a5 JTF_VARCHAR2_TABLE_100
1159: , p7_a6 JTF_VARCHAR2_TABLE_500
1152: , p6_a28 JTF_NUMBER_TABLE
1153: , p7_a0 JTF_NUMBER_TABLE
1154: , p7_a1 JTF_NUMBER_TABLE
1155: , p7_a2 JTF_NUMBER_TABLE
1156: , p7_a3 JTF_NUMBER_TABLE
1157: , p7_a4 JTF_NUMBER_TABLE
1158: , p7_a5 JTF_VARCHAR2_TABLE_100
1159: , p7_a6 JTF_VARCHAR2_TABLE_500
1160: , p7_a7 JTF_VARCHAR2_TABLE_500
1153: , p7_a0 JTF_NUMBER_TABLE
1154: , p7_a1 JTF_NUMBER_TABLE
1155: , p7_a2 JTF_NUMBER_TABLE
1156: , p7_a3 JTF_NUMBER_TABLE
1157: , p7_a4 JTF_NUMBER_TABLE
1158: , p7_a5 JTF_VARCHAR2_TABLE_100
1159: , p7_a6 JTF_VARCHAR2_TABLE_500
1160: , p7_a7 JTF_VARCHAR2_TABLE_500
1161: , p7_a8 JTF_VARCHAR2_TABLE_500
1170: , p7_a17 JTF_VARCHAR2_TABLE_500
1171: , p7_a18 JTF_VARCHAR2_TABLE_500
1172: , p7_a19 JTF_VARCHAR2_TABLE_500
1173: , p7_a20 JTF_VARCHAR2_TABLE_500
1174: , p7_a21 JTF_NUMBER_TABLE
1175: , p7_a22 JTF_DATE_TABLE
1176: , p7_a23 JTF_NUMBER_TABLE
1177: , p7_a24 JTF_DATE_TABLE
1178: , p7_a25 JTF_NUMBER_TABLE
1172: , p7_a19 JTF_VARCHAR2_TABLE_500
1173: , p7_a20 JTF_VARCHAR2_TABLE_500
1174: , p7_a21 JTF_NUMBER_TABLE
1175: , p7_a22 JTF_DATE_TABLE
1176: , p7_a23 JTF_NUMBER_TABLE
1177: , p7_a24 JTF_DATE_TABLE
1178: , p7_a25 JTF_NUMBER_TABLE
1179: , p8_a0 out nocopy NUMBER
1180: , p8_a1 out nocopy NUMBER
1174: , p7_a21 JTF_NUMBER_TABLE
1175: , p7_a22 JTF_DATE_TABLE
1176: , p7_a23 JTF_NUMBER_TABLE
1177: , p7_a24 JTF_DATE_TABLE
1178: , p7_a25 JTF_NUMBER_TABLE
1179: , p8_a0 out nocopy NUMBER
1180: , p8_a1 out nocopy NUMBER
1181: , p8_a2 out nocopy VARCHAR2
1182: , p8_a3 out nocopy DATE
1203: , p8_a24 out nocopy DATE
1204: , p8_a25 out nocopy NUMBER
1205: , p8_a26 out nocopy DATE
1206: , p8_a27 out nocopy NUMBER
1207: , p9_a0 out nocopy JTF_NUMBER_TABLE
1208: , p9_a1 out nocopy JTF_NUMBER_TABLE
1209: , p9_a2 out nocopy JTF_NUMBER_TABLE
1210: , p9_a3 out nocopy JTF_NUMBER_TABLE
1211: , p9_a4 out nocopy JTF_NUMBER_TABLE
1204: , p8_a25 out nocopy NUMBER
1205: , p8_a26 out nocopy DATE
1206: , p8_a27 out nocopy NUMBER
1207: , p9_a0 out nocopy JTF_NUMBER_TABLE
1208: , p9_a1 out nocopy JTF_NUMBER_TABLE
1209: , p9_a2 out nocopy JTF_NUMBER_TABLE
1210: , p9_a3 out nocopy JTF_NUMBER_TABLE
1211: , p9_a4 out nocopy JTF_NUMBER_TABLE
1212: , p9_a5 out nocopy JTF_NUMBER_TABLE
1205: , p8_a26 out nocopy DATE
1206: , p8_a27 out nocopy NUMBER
1207: , p9_a0 out nocopy JTF_NUMBER_TABLE
1208: , p9_a1 out nocopy JTF_NUMBER_TABLE
1209: , p9_a2 out nocopy JTF_NUMBER_TABLE
1210: , p9_a3 out nocopy JTF_NUMBER_TABLE
1211: , p9_a4 out nocopy JTF_NUMBER_TABLE
1212: , p9_a5 out nocopy JTF_NUMBER_TABLE
1213: , p9_a6 out nocopy JTF_NUMBER_TABLE
1206: , p8_a27 out nocopy NUMBER
1207: , p9_a0 out nocopy JTF_NUMBER_TABLE
1208: , p9_a1 out nocopy JTF_NUMBER_TABLE
1209: , p9_a2 out nocopy JTF_NUMBER_TABLE
1210: , p9_a3 out nocopy JTF_NUMBER_TABLE
1211: , p9_a4 out nocopy JTF_NUMBER_TABLE
1212: , p9_a5 out nocopy JTF_NUMBER_TABLE
1213: , p9_a6 out nocopy JTF_NUMBER_TABLE
1214: , p9_a7 out nocopy JTF_NUMBER_TABLE
1207: , p9_a0 out nocopy JTF_NUMBER_TABLE
1208: , p9_a1 out nocopy JTF_NUMBER_TABLE
1209: , p9_a2 out nocopy JTF_NUMBER_TABLE
1210: , p9_a3 out nocopy JTF_NUMBER_TABLE
1211: , p9_a4 out nocopy JTF_NUMBER_TABLE
1212: , p9_a5 out nocopy JTF_NUMBER_TABLE
1213: , p9_a6 out nocopy JTF_NUMBER_TABLE
1214: , p9_a7 out nocopy JTF_NUMBER_TABLE
1215: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
1208: , p9_a1 out nocopy JTF_NUMBER_TABLE
1209: , p9_a2 out nocopy JTF_NUMBER_TABLE
1210: , p9_a3 out nocopy JTF_NUMBER_TABLE
1211: , p9_a4 out nocopy JTF_NUMBER_TABLE
1212: , p9_a5 out nocopy JTF_NUMBER_TABLE
1213: , p9_a6 out nocopy JTF_NUMBER_TABLE
1214: , p9_a7 out nocopy JTF_NUMBER_TABLE
1215: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
1216: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_500
1209: , p9_a2 out nocopy JTF_NUMBER_TABLE
1210: , p9_a3 out nocopy JTF_NUMBER_TABLE
1211: , p9_a4 out nocopy JTF_NUMBER_TABLE
1212: , p9_a5 out nocopy JTF_NUMBER_TABLE
1213: , p9_a6 out nocopy JTF_NUMBER_TABLE
1214: , p9_a7 out nocopy JTF_NUMBER_TABLE
1215: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
1216: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_500
1217: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_500
1210: , p9_a3 out nocopy JTF_NUMBER_TABLE
1211: , p9_a4 out nocopy JTF_NUMBER_TABLE
1212: , p9_a5 out nocopy JTF_NUMBER_TABLE
1213: , p9_a6 out nocopy JTF_NUMBER_TABLE
1214: , p9_a7 out nocopy JTF_NUMBER_TABLE
1215: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
1216: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_500
1217: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_500
1218: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_500
1227: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_500
1228: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500
1229: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500
1230: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
1231: , p9_a24 out nocopy JTF_NUMBER_TABLE
1232: , p9_a25 out nocopy JTF_DATE_TABLE
1233: , p9_a26 out nocopy JTF_NUMBER_TABLE
1234: , p9_a27 out nocopy JTF_DATE_TABLE
1235: , p9_a28 out nocopy JTF_NUMBER_TABLE
1229: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500
1230: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
1231: , p9_a24 out nocopy JTF_NUMBER_TABLE
1232: , p9_a25 out nocopy JTF_DATE_TABLE
1233: , p9_a26 out nocopy JTF_NUMBER_TABLE
1234: , p9_a27 out nocopy JTF_DATE_TABLE
1235: , p9_a28 out nocopy JTF_NUMBER_TABLE
1236: , p10_a0 out nocopy JTF_NUMBER_TABLE
1237: , p10_a1 out nocopy JTF_NUMBER_TABLE
1231: , p9_a24 out nocopy JTF_NUMBER_TABLE
1232: , p9_a25 out nocopy JTF_DATE_TABLE
1233: , p9_a26 out nocopy JTF_NUMBER_TABLE
1234: , p9_a27 out nocopy JTF_DATE_TABLE
1235: , p9_a28 out nocopy JTF_NUMBER_TABLE
1236: , p10_a0 out nocopy JTF_NUMBER_TABLE
1237: , p10_a1 out nocopy JTF_NUMBER_TABLE
1238: , p10_a2 out nocopy JTF_NUMBER_TABLE
1239: , p10_a3 out nocopy JTF_NUMBER_TABLE
1232: , p9_a25 out nocopy JTF_DATE_TABLE
1233: , p9_a26 out nocopy JTF_NUMBER_TABLE
1234: , p9_a27 out nocopy JTF_DATE_TABLE
1235: , p9_a28 out nocopy JTF_NUMBER_TABLE
1236: , p10_a0 out nocopy JTF_NUMBER_TABLE
1237: , p10_a1 out nocopy JTF_NUMBER_TABLE
1238: , p10_a2 out nocopy JTF_NUMBER_TABLE
1239: , p10_a3 out nocopy JTF_NUMBER_TABLE
1240: , p10_a4 out nocopy JTF_NUMBER_TABLE
1233: , p9_a26 out nocopy JTF_NUMBER_TABLE
1234: , p9_a27 out nocopy JTF_DATE_TABLE
1235: , p9_a28 out nocopy JTF_NUMBER_TABLE
1236: , p10_a0 out nocopy JTF_NUMBER_TABLE
1237: , p10_a1 out nocopy JTF_NUMBER_TABLE
1238: , p10_a2 out nocopy JTF_NUMBER_TABLE
1239: , p10_a3 out nocopy JTF_NUMBER_TABLE
1240: , p10_a4 out nocopy JTF_NUMBER_TABLE
1241: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
1234: , p9_a27 out nocopy JTF_DATE_TABLE
1235: , p9_a28 out nocopy JTF_NUMBER_TABLE
1236: , p10_a0 out nocopy JTF_NUMBER_TABLE
1237: , p10_a1 out nocopy JTF_NUMBER_TABLE
1238: , p10_a2 out nocopy JTF_NUMBER_TABLE
1239: , p10_a3 out nocopy JTF_NUMBER_TABLE
1240: , p10_a4 out nocopy JTF_NUMBER_TABLE
1241: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
1242: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_500
1235: , p9_a28 out nocopy JTF_NUMBER_TABLE
1236: , p10_a0 out nocopy JTF_NUMBER_TABLE
1237: , p10_a1 out nocopy JTF_NUMBER_TABLE
1238: , p10_a2 out nocopy JTF_NUMBER_TABLE
1239: , p10_a3 out nocopy JTF_NUMBER_TABLE
1240: , p10_a4 out nocopy JTF_NUMBER_TABLE
1241: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
1242: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_500
1243: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_500
1236: , p10_a0 out nocopy JTF_NUMBER_TABLE
1237: , p10_a1 out nocopy JTF_NUMBER_TABLE
1238: , p10_a2 out nocopy JTF_NUMBER_TABLE
1239: , p10_a3 out nocopy JTF_NUMBER_TABLE
1240: , p10_a4 out nocopy JTF_NUMBER_TABLE
1241: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
1242: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_500
1243: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_500
1244: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_500
1253: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_500
1254: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_500
1255: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_500
1256: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
1257: , p10_a21 out nocopy JTF_NUMBER_TABLE
1258: , p10_a22 out nocopy JTF_DATE_TABLE
1259: , p10_a23 out nocopy JTF_NUMBER_TABLE
1260: , p10_a24 out nocopy JTF_DATE_TABLE
1261: , p10_a25 out nocopy JTF_NUMBER_TABLE
1255: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_500
1256: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
1257: , p10_a21 out nocopy JTF_NUMBER_TABLE
1258: , p10_a22 out nocopy JTF_DATE_TABLE
1259: , p10_a23 out nocopy JTF_NUMBER_TABLE
1260: , p10_a24 out nocopy JTF_DATE_TABLE
1261: , p10_a25 out nocopy JTF_NUMBER_TABLE
1262: )
1263:
1257: , p10_a21 out nocopy JTF_NUMBER_TABLE
1258: , p10_a22 out nocopy JTF_DATE_TABLE
1259: , p10_a23 out nocopy JTF_NUMBER_TABLE
1260: , p10_a24 out nocopy JTF_DATE_TABLE
1261: , p10_a25 out nocopy JTF_NUMBER_TABLE
1262: )
1263:
1264: as
1265: ddp_eve_rec okl_fe_eo_term_options_pvt.okl_eve_rec;
1511: , p5_a24 DATE
1512: , p5_a25 NUMBER
1513: , p5_a26 DATE
1514: , p5_a27 NUMBER
1515: , p6_a0 JTF_NUMBER_TABLE
1516: , p6_a1 JTF_NUMBER_TABLE
1517: , p6_a2 JTF_NUMBER_TABLE
1518: , p6_a3 JTF_NUMBER_TABLE
1519: , p6_a4 JTF_NUMBER_TABLE
1512: , p5_a25 NUMBER
1513: , p5_a26 DATE
1514: , p5_a27 NUMBER
1515: , p6_a0 JTF_NUMBER_TABLE
1516: , p6_a1 JTF_NUMBER_TABLE
1517: , p6_a2 JTF_NUMBER_TABLE
1518: , p6_a3 JTF_NUMBER_TABLE
1519: , p6_a4 JTF_NUMBER_TABLE
1520: , p6_a5 JTF_NUMBER_TABLE
1513: , p5_a26 DATE
1514: , p5_a27 NUMBER
1515: , p6_a0 JTF_NUMBER_TABLE
1516: , p6_a1 JTF_NUMBER_TABLE
1517: , p6_a2 JTF_NUMBER_TABLE
1518: , p6_a3 JTF_NUMBER_TABLE
1519: , p6_a4 JTF_NUMBER_TABLE
1520: , p6_a5 JTF_NUMBER_TABLE
1521: , p6_a6 JTF_NUMBER_TABLE
1514: , p5_a27 NUMBER
1515: , p6_a0 JTF_NUMBER_TABLE
1516: , p6_a1 JTF_NUMBER_TABLE
1517: , p6_a2 JTF_NUMBER_TABLE
1518: , p6_a3 JTF_NUMBER_TABLE
1519: , p6_a4 JTF_NUMBER_TABLE
1520: , p6_a5 JTF_NUMBER_TABLE
1521: , p6_a6 JTF_NUMBER_TABLE
1522: , p6_a7 JTF_NUMBER_TABLE
1515: , p6_a0 JTF_NUMBER_TABLE
1516: , p6_a1 JTF_NUMBER_TABLE
1517: , p6_a2 JTF_NUMBER_TABLE
1518: , p6_a3 JTF_NUMBER_TABLE
1519: , p6_a4 JTF_NUMBER_TABLE
1520: , p6_a5 JTF_NUMBER_TABLE
1521: , p6_a6 JTF_NUMBER_TABLE
1522: , p6_a7 JTF_NUMBER_TABLE
1523: , p6_a8 JTF_VARCHAR2_TABLE_100
1516: , p6_a1 JTF_NUMBER_TABLE
1517: , p6_a2 JTF_NUMBER_TABLE
1518: , p6_a3 JTF_NUMBER_TABLE
1519: , p6_a4 JTF_NUMBER_TABLE
1520: , p6_a5 JTF_NUMBER_TABLE
1521: , p6_a6 JTF_NUMBER_TABLE
1522: , p6_a7 JTF_NUMBER_TABLE
1523: , p6_a8 JTF_VARCHAR2_TABLE_100
1524: , p6_a9 JTF_VARCHAR2_TABLE_500
1517: , p6_a2 JTF_NUMBER_TABLE
1518: , p6_a3 JTF_NUMBER_TABLE
1519: , p6_a4 JTF_NUMBER_TABLE
1520: , p6_a5 JTF_NUMBER_TABLE
1521: , p6_a6 JTF_NUMBER_TABLE
1522: , p6_a7 JTF_NUMBER_TABLE
1523: , p6_a8 JTF_VARCHAR2_TABLE_100
1524: , p6_a9 JTF_VARCHAR2_TABLE_500
1525: , p6_a10 JTF_VARCHAR2_TABLE_500
1518: , p6_a3 JTF_NUMBER_TABLE
1519: , p6_a4 JTF_NUMBER_TABLE
1520: , p6_a5 JTF_NUMBER_TABLE
1521: , p6_a6 JTF_NUMBER_TABLE
1522: , p6_a7 JTF_NUMBER_TABLE
1523: , p6_a8 JTF_VARCHAR2_TABLE_100
1524: , p6_a9 JTF_VARCHAR2_TABLE_500
1525: , p6_a10 JTF_VARCHAR2_TABLE_500
1526: , p6_a11 JTF_VARCHAR2_TABLE_500
1535: , p6_a20 JTF_VARCHAR2_TABLE_500
1536: , p6_a21 JTF_VARCHAR2_TABLE_500
1537: , p6_a22 JTF_VARCHAR2_TABLE_500
1538: , p6_a23 JTF_VARCHAR2_TABLE_500
1539: , p6_a24 JTF_NUMBER_TABLE
1540: , p6_a25 JTF_DATE_TABLE
1541: , p6_a26 JTF_NUMBER_TABLE
1542: , p6_a27 JTF_DATE_TABLE
1543: , p6_a28 JTF_NUMBER_TABLE
1537: , p6_a22 JTF_VARCHAR2_TABLE_500
1538: , p6_a23 JTF_VARCHAR2_TABLE_500
1539: , p6_a24 JTF_NUMBER_TABLE
1540: , p6_a25 JTF_DATE_TABLE
1541: , p6_a26 JTF_NUMBER_TABLE
1542: , p6_a27 JTF_DATE_TABLE
1543: , p6_a28 JTF_NUMBER_TABLE
1544: , p7_a0 JTF_NUMBER_TABLE
1545: , p7_a1 JTF_NUMBER_TABLE
1539: , p6_a24 JTF_NUMBER_TABLE
1540: , p6_a25 JTF_DATE_TABLE
1541: , p6_a26 JTF_NUMBER_TABLE
1542: , p6_a27 JTF_DATE_TABLE
1543: , p6_a28 JTF_NUMBER_TABLE
1544: , p7_a0 JTF_NUMBER_TABLE
1545: , p7_a1 JTF_NUMBER_TABLE
1546: , p7_a2 JTF_NUMBER_TABLE
1547: , p7_a3 JTF_NUMBER_TABLE
1540: , p6_a25 JTF_DATE_TABLE
1541: , p6_a26 JTF_NUMBER_TABLE
1542: , p6_a27 JTF_DATE_TABLE
1543: , p6_a28 JTF_NUMBER_TABLE
1544: , p7_a0 JTF_NUMBER_TABLE
1545: , p7_a1 JTF_NUMBER_TABLE
1546: , p7_a2 JTF_NUMBER_TABLE
1547: , p7_a3 JTF_NUMBER_TABLE
1548: , p7_a4 JTF_NUMBER_TABLE
1541: , p6_a26 JTF_NUMBER_TABLE
1542: , p6_a27 JTF_DATE_TABLE
1543: , p6_a28 JTF_NUMBER_TABLE
1544: , p7_a0 JTF_NUMBER_TABLE
1545: , p7_a1 JTF_NUMBER_TABLE
1546: , p7_a2 JTF_NUMBER_TABLE
1547: , p7_a3 JTF_NUMBER_TABLE
1548: , p7_a4 JTF_NUMBER_TABLE
1549: , p7_a5 JTF_VARCHAR2_TABLE_100
1542: , p6_a27 JTF_DATE_TABLE
1543: , p6_a28 JTF_NUMBER_TABLE
1544: , p7_a0 JTF_NUMBER_TABLE
1545: , p7_a1 JTF_NUMBER_TABLE
1546: , p7_a2 JTF_NUMBER_TABLE
1547: , p7_a3 JTF_NUMBER_TABLE
1548: , p7_a4 JTF_NUMBER_TABLE
1549: , p7_a5 JTF_VARCHAR2_TABLE_100
1550: , p7_a6 JTF_VARCHAR2_TABLE_500
1543: , p6_a28 JTF_NUMBER_TABLE
1544: , p7_a0 JTF_NUMBER_TABLE
1545: , p7_a1 JTF_NUMBER_TABLE
1546: , p7_a2 JTF_NUMBER_TABLE
1547: , p7_a3 JTF_NUMBER_TABLE
1548: , p7_a4 JTF_NUMBER_TABLE
1549: , p7_a5 JTF_VARCHAR2_TABLE_100
1550: , p7_a6 JTF_VARCHAR2_TABLE_500
1551: , p7_a7 JTF_VARCHAR2_TABLE_500
1544: , p7_a0 JTF_NUMBER_TABLE
1545: , p7_a1 JTF_NUMBER_TABLE
1546: , p7_a2 JTF_NUMBER_TABLE
1547: , p7_a3 JTF_NUMBER_TABLE
1548: , p7_a4 JTF_NUMBER_TABLE
1549: , p7_a5 JTF_VARCHAR2_TABLE_100
1550: , p7_a6 JTF_VARCHAR2_TABLE_500
1551: , p7_a7 JTF_VARCHAR2_TABLE_500
1552: , p7_a8 JTF_VARCHAR2_TABLE_500
1561: , p7_a17 JTF_VARCHAR2_TABLE_500
1562: , p7_a18 JTF_VARCHAR2_TABLE_500
1563: , p7_a19 JTF_VARCHAR2_TABLE_500
1564: , p7_a20 JTF_VARCHAR2_TABLE_500
1565: , p7_a21 JTF_NUMBER_TABLE
1566: , p7_a22 JTF_DATE_TABLE
1567: , p7_a23 JTF_NUMBER_TABLE
1568: , p7_a24 JTF_DATE_TABLE
1569: , p7_a25 JTF_NUMBER_TABLE
1563: , p7_a19 JTF_VARCHAR2_TABLE_500
1564: , p7_a20 JTF_VARCHAR2_TABLE_500
1565: , p7_a21 JTF_NUMBER_TABLE
1566: , p7_a22 JTF_DATE_TABLE
1567: , p7_a23 JTF_NUMBER_TABLE
1568: , p7_a24 JTF_DATE_TABLE
1569: , p7_a25 JTF_NUMBER_TABLE
1570: , p8_a0 out nocopy NUMBER
1571: , p8_a1 out nocopy NUMBER
1565: , p7_a21 JTF_NUMBER_TABLE
1566: , p7_a22 JTF_DATE_TABLE
1567: , p7_a23 JTF_NUMBER_TABLE
1568: , p7_a24 JTF_DATE_TABLE
1569: , p7_a25 JTF_NUMBER_TABLE
1570: , p8_a0 out nocopy NUMBER
1571: , p8_a1 out nocopy NUMBER
1572: , p8_a2 out nocopy VARCHAR2
1573: , p8_a3 out nocopy DATE
1594: , p8_a24 out nocopy DATE
1595: , p8_a25 out nocopy NUMBER
1596: , p8_a26 out nocopy DATE
1597: , p8_a27 out nocopy NUMBER
1598: , p9_a0 out nocopy JTF_NUMBER_TABLE
1599: , p9_a1 out nocopy JTF_NUMBER_TABLE
1600: , p9_a2 out nocopy JTF_NUMBER_TABLE
1601: , p9_a3 out nocopy JTF_NUMBER_TABLE
1602: , p9_a4 out nocopy JTF_NUMBER_TABLE
1595: , p8_a25 out nocopy NUMBER
1596: , p8_a26 out nocopy DATE
1597: , p8_a27 out nocopy NUMBER
1598: , p9_a0 out nocopy JTF_NUMBER_TABLE
1599: , p9_a1 out nocopy JTF_NUMBER_TABLE
1600: , p9_a2 out nocopy JTF_NUMBER_TABLE
1601: , p9_a3 out nocopy JTF_NUMBER_TABLE
1602: , p9_a4 out nocopy JTF_NUMBER_TABLE
1603: , p9_a5 out nocopy JTF_NUMBER_TABLE
1596: , p8_a26 out nocopy DATE
1597: , p8_a27 out nocopy NUMBER
1598: , p9_a0 out nocopy JTF_NUMBER_TABLE
1599: , p9_a1 out nocopy JTF_NUMBER_TABLE
1600: , p9_a2 out nocopy JTF_NUMBER_TABLE
1601: , p9_a3 out nocopy JTF_NUMBER_TABLE
1602: , p9_a4 out nocopy JTF_NUMBER_TABLE
1603: , p9_a5 out nocopy JTF_NUMBER_TABLE
1604: , p9_a6 out nocopy JTF_NUMBER_TABLE
1597: , p8_a27 out nocopy NUMBER
1598: , p9_a0 out nocopy JTF_NUMBER_TABLE
1599: , p9_a1 out nocopy JTF_NUMBER_TABLE
1600: , p9_a2 out nocopy JTF_NUMBER_TABLE
1601: , p9_a3 out nocopy JTF_NUMBER_TABLE
1602: , p9_a4 out nocopy JTF_NUMBER_TABLE
1603: , p9_a5 out nocopy JTF_NUMBER_TABLE
1604: , p9_a6 out nocopy JTF_NUMBER_TABLE
1605: , p9_a7 out nocopy JTF_NUMBER_TABLE
1598: , p9_a0 out nocopy JTF_NUMBER_TABLE
1599: , p9_a1 out nocopy JTF_NUMBER_TABLE
1600: , p9_a2 out nocopy JTF_NUMBER_TABLE
1601: , p9_a3 out nocopy JTF_NUMBER_TABLE
1602: , p9_a4 out nocopy JTF_NUMBER_TABLE
1603: , p9_a5 out nocopy JTF_NUMBER_TABLE
1604: , p9_a6 out nocopy JTF_NUMBER_TABLE
1605: , p9_a7 out nocopy JTF_NUMBER_TABLE
1606: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
1599: , p9_a1 out nocopy JTF_NUMBER_TABLE
1600: , p9_a2 out nocopy JTF_NUMBER_TABLE
1601: , p9_a3 out nocopy JTF_NUMBER_TABLE
1602: , p9_a4 out nocopy JTF_NUMBER_TABLE
1603: , p9_a5 out nocopy JTF_NUMBER_TABLE
1604: , p9_a6 out nocopy JTF_NUMBER_TABLE
1605: , p9_a7 out nocopy JTF_NUMBER_TABLE
1606: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
1607: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_500
1600: , p9_a2 out nocopy JTF_NUMBER_TABLE
1601: , p9_a3 out nocopy JTF_NUMBER_TABLE
1602: , p9_a4 out nocopy JTF_NUMBER_TABLE
1603: , p9_a5 out nocopy JTF_NUMBER_TABLE
1604: , p9_a6 out nocopy JTF_NUMBER_TABLE
1605: , p9_a7 out nocopy JTF_NUMBER_TABLE
1606: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
1607: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_500
1608: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_500
1601: , p9_a3 out nocopy JTF_NUMBER_TABLE
1602: , p9_a4 out nocopy JTF_NUMBER_TABLE
1603: , p9_a5 out nocopy JTF_NUMBER_TABLE
1604: , p9_a6 out nocopy JTF_NUMBER_TABLE
1605: , p9_a7 out nocopy JTF_NUMBER_TABLE
1606: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
1607: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_500
1608: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_500
1609: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_500
1618: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_500
1619: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500
1620: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500
1621: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
1622: , p9_a24 out nocopy JTF_NUMBER_TABLE
1623: , p9_a25 out nocopy JTF_DATE_TABLE
1624: , p9_a26 out nocopy JTF_NUMBER_TABLE
1625: , p9_a27 out nocopy JTF_DATE_TABLE
1626: , p9_a28 out nocopy JTF_NUMBER_TABLE
1620: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500
1621: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
1622: , p9_a24 out nocopy JTF_NUMBER_TABLE
1623: , p9_a25 out nocopy JTF_DATE_TABLE
1624: , p9_a26 out nocopy JTF_NUMBER_TABLE
1625: , p9_a27 out nocopy JTF_DATE_TABLE
1626: , p9_a28 out nocopy JTF_NUMBER_TABLE
1627: , p10_a0 out nocopy JTF_NUMBER_TABLE
1628: , p10_a1 out nocopy JTF_NUMBER_TABLE
1622: , p9_a24 out nocopy JTF_NUMBER_TABLE
1623: , p9_a25 out nocopy JTF_DATE_TABLE
1624: , p9_a26 out nocopy JTF_NUMBER_TABLE
1625: , p9_a27 out nocopy JTF_DATE_TABLE
1626: , p9_a28 out nocopy JTF_NUMBER_TABLE
1627: , p10_a0 out nocopy JTF_NUMBER_TABLE
1628: , p10_a1 out nocopy JTF_NUMBER_TABLE
1629: , p10_a2 out nocopy JTF_NUMBER_TABLE
1630: , p10_a3 out nocopy JTF_NUMBER_TABLE
1623: , p9_a25 out nocopy JTF_DATE_TABLE
1624: , p9_a26 out nocopy JTF_NUMBER_TABLE
1625: , p9_a27 out nocopy JTF_DATE_TABLE
1626: , p9_a28 out nocopy JTF_NUMBER_TABLE
1627: , p10_a0 out nocopy JTF_NUMBER_TABLE
1628: , p10_a1 out nocopy JTF_NUMBER_TABLE
1629: , p10_a2 out nocopy JTF_NUMBER_TABLE
1630: , p10_a3 out nocopy JTF_NUMBER_TABLE
1631: , p10_a4 out nocopy JTF_NUMBER_TABLE
1624: , p9_a26 out nocopy JTF_NUMBER_TABLE
1625: , p9_a27 out nocopy JTF_DATE_TABLE
1626: , p9_a28 out nocopy JTF_NUMBER_TABLE
1627: , p10_a0 out nocopy JTF_NUMBER_TABLE
1628: , p10_a1 out nocopy JTF_NUMBER_TABLE
1629: , p10_a2 out nocopy JTF_NUMBER_TABLE
1630: , p10_a3 out nocopy JTF_NUMBER_TABLE
1631: , p10_a4 out nocopy JTF_NUMBER_TABLE
1632: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
1625: , p9_a27 out nocopy JTF_DATE_TABLE
1626: , p9_a28 out nocopy JTF_NUMBER_TABLE
1627: , p10_a0 out nocopy JTF_NUMBER_TABLE
1628: , p10_a1 out nocopy JTF_NUMBER_TABLE
1629: , p10_a2 out nocopy JTF_NUMBER_TABLE
1630: , p10_a3 out nocopy JTF_NUMBER_TABLE
1631: , p10_a4 out nocopy JTF_NUMBER_TABLE
1632: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
1633: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_500
1626: , p9_a28 out nocopy JTF_NUMBER_TABLE
1627: , p10_a0 out nocopy JTF_NUMBER_TABLE
1628: , p10_a1 out nocopy JTF_NUMBER_TABLE
1629: , p10_a2 out nocopy JTF_NUMBER_TABLE
1630: , p10_a3 out nocopy JTF_NUMBER_TABLE
1631: , p10_a4 out nocopy JTF_NUMBER_TABLE
1632: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
1633: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_500
1634: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_500
1627: , p10_a0 out nocopy JTF_NUMBER_TABLE
1628: , p10_a1 out nocopy JTF_NUMBER_TABLE
1629: , p10_a2 out nocopy JTF_NUMBER_TABLE
1630: , p10_a3 out nocopy JTF_NUMBER_TABLE
1631: , p10_a4 out nocopy JTF_NUMBER_TABLE
1632: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
1633: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_500
1634: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_500
1635: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_500
1644: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_500
1645: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_500
1646: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_500
1647: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
1648: , p10_a21 out nocopy JTF_NUMBER_TABLE
1649: , p10_a22 out nocopy JTF_DATE_TABLE
1650: , p10_a23 out nocopy JTF_NUMBER_TABLE
1651: , p10_a24 out nocopy JTF_DATE_TABLE
1652: , p10_a25 out nocopy JTF_NUMBER_TABLE
1646: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_500
1647: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
1648: , p10_a21 out nocopy JTF_NUMBER_TABLE
1649: , p10_a22 out nocopy JTF_DATE_TABLE
1650: , p10_a23 out nocopy JTF_NUMBER_TABLE
1651: , p10_a24 out nocopy JTF_DATE_TABLE
1652: , p10_a25 out nocopy JTF_NUMBER_TABLE
1653: )
1654:
1648: , p10_a21 out nocopy JTF_NUMBER_TABLE
1649: , p10_a22 out nocopy JTF_DATE_TABLE
1650: , p10_a23 out nocopy JTF_NUMBER_TABLE
1651: , p10_a24 out nocopy JTF_DATE_TABLE
1652: , p10_a25 out nocopy JTF_NUMBER_TABLE
1653: )
1654:
1655: as
1656: ddp_eve_rec okl_fe_eo_term_options_pvt.okl_eve_rec;
1875: , x_return_status out nocopy VARCHAR2
1876: , x_msg_count out nocopy NUMBER
1877: , x_msg_data out nocopy VARCHAR2
1878: , p_version_id NUMBER
1879: , p6_a0 out nocopy JTF_NUMBER_TABLE
1880: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
1881: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1882: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1883: )