1: package body okl_eco_pvt_w as
2: /* $Header: OKLIECOB.pls 120.1 2005/10/30 04:58:42 appldev noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eco_pvt.okl_eco_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
1: package body okl_eco_pvt_w as
2: /* $Header: OKLIECOB.pls 120.1 2005/10/30 04:58:42 appldev noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eco_pvt.okl_eco_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
1: package body okl_eco_pvt_w as
2: /* $Header: OKLIECOB.pls 120.1 2005/10/30 04:58:42 appldev noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eco_pvt.okl_eco_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: ) as
14: ddindx binary_integer; indx binary_integer;
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: ) as
14: ddindx binary_integer; indx binary_integer;
15: begin
16: if a0 is not null and a0.count > 0 then
36: end loop;
37: end if;
38: end if;
39: end rosetta_table_copy_in_p1;
40: procedure rosetta_table_copy_out_p1(t okl_eco_pvt.okl_eco_tbl, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_NUMBER_TABLE
42: , a2 out nocopy JTF_NUMBER_TABLE
43: , a3 out nocopy JTF_VARCHAR2_TABLE_100
44: , a4 out nocopy JTF_VARCHAR2_TABLE_100
37: end if;
38: end if;
39: end rosetta_table_copy_in_p1;
40: procedure rosetta_table_copy_out_p1(t okl_eco_pvt.okl_eco_tbl, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_NUMBER_TABLE
42: , a2 out nocopy JTF_NUMBER_TABLE
43: , a3 out nocopy JTF_VARCHAR2_TABLE_100
44: , a4 out nocopy JTF_VARCHAR2_TABLE_100
45: , a5 out nocopy JTF_NUMBER_TABLE
38: end if;
39: end rosetta_table_copy_in_p1;
40: procedure rosetta_table_copy_out_p1(t okl_eco_pvt.okl_eco_tbl, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_NUMBER_TABLE
42: , a2 out nocopy JTF_NUMBER_TABLE
43: , a3 out nocopy JTF_VARCHAR2_TABLE_100
44: , a4 out nocopy JTF_VARCHAR2_TABLE_100
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_DATE_TABLE
41: , a1 out nocopy JTF_NUMBER_TABLE
42: , a2 out nocopy JTF_NUMBER_TABLE
43: , a3 out nocopy JTF_VARCHAR2_TABLE_100
44: , a4 out nocopy JTF_VARCHAR2_TABLE_100
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_DATE_TABLE
47: , a7 out nocopy JTF_NUMBER_TABLE
48: , a8 out nocopy JTF_DATE_TABLE
49: , a9 out nocopy JTF_NUMBER_TABLE
43: , a3 out nocopy JTF_VARCHAR2_TABLE_100
44: , a4 out nocopy JTF_VARCHAR2_TABLE_100
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_DATE_TABLE
47: , a7 out nocopy JTF_NUMBER_TABLE
48: , a8 out nocopy JTF_DATE_TABLE
49: , a9 out nocopy JTF_NUMBER_TABLE
50: ) as
51: ddindx binary_integer; indx binary_integer;
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_DATE_TABLE
47: , a7 out nocopy JTF_NUMBER_TABLE
48: , a8 out nocopy JTF_DATE_TABLE
49: , a9 out nocopy JTF_NUMBER_TABLE
50: ) as
51: ddindx binary_integer; indx binary_integer;
52: begin
53: if t is null or t.count = 0 then
50: ) as
51: ddindx binary_integer; indx binary_integer;
52: begin
53: if t is null or t.count = 0 then
54: a0 := JTF_NUMBER_TABLE();
55: a1 := JTF_NUMBER_TABLE();
56: a2 := JTF_NUMBER_TABLE();
57: a3 := JTF_VARCHAR2_TABLE_100();
58: a4 := JTF_VARCHAR2_TABLE_100();
51: ddindx binary_integer; indx binary_integer;
52: begin
53: if t is null or t.count = 0 then
54: a0 := JTF_NUMBER_TABLE();
55: a1 := JTF_NUMBER_TABLE();
56: a2 := JTF_NUMBER_TABLE();
57: a3 := JTF_VARCHAR2_TABLE_100();
58: a4 := JTF_VARCHAR2_TABLE_100();
59: a5 := JTF_NUMBER_TABLE();
52: begin
53: if t is null or t.count = 0 then
54: a0 := JTF_NUMBER_TABLE();
55: a1 := JTF_NUMBER_TABLE();
56: a2 := JTF_NUMBER_TABLE();
57: a3 := JTF_VARCHAR2_TABLE_100();
58: a4 := JTF_VARCHAR2_TABLE_100();
59: a5 := JTF_NUMBER_TABLE();
60: a6 := JTF_DATE_TABLE();
55: a1 := JTF_NUMBER_TABLE();
56: a2 := JTF_NUMBER_TABLE();
57: a3 := JTF_VARCHAR2_TABLE_100();
58: a4 := JTF_VARCHAR2_TABLE_100();
59: a5 := JTF_NUMBER_TABLE();
60: a6 := JTF_DATE_TABLE();
61: a7 := JTF_NUMBER_TABLE();
62: a8 := JTF_DATE_TABLE();
63: a9 := JTF_NUMBER_TABLE();
57: a3 := JTF_VARCHAR2_TABLE_100();
58: a4 := JTF_VARCHAR2_TABLE_100();
59: a5 := JTF_NUMBER_TABLE();
60: a6 := JTF_DATE_TABLE();
61: a7 := JTF_NUMBER_TABLE();
62: a8 := JTF_DATE_TABLE();
63: a9 := JTF_NUMBER_TABLE();
64: else
65: a0 := JTF_NUMBER_TABLE();
59: a5 := JTF_NUMBER_TABLE();
60: a6 := JTF_DATE_TABLE();
61: a7 := JTF_NUMBER_TABLE();
62: a8 := JTF_DATE_TABLE();
63: a9 := JTF_NUMBER_TABLE();
64: else
65: a0 := JTF_NUMBER_TABLE();
66: a1 := JTF_NUMBER_TABLE();
67: a2 := JTF_NUMBER_TABLE();
61: a7 := JTF_NUMBER_TABLE();
62: a8 := JTF_DATE_TABLE();
63: a9 := JTF_NUMBER_TABLE();
64: else
65: a0 := JTF_NUMBER_TABLE();
66: a1 := JTF_NUMBER_TABLE();
67: a2 := JTF_NUMBER_TABLE();
68: a3 := JTF_VARCHAR2_TABLE_100();
69: a4 := JTF_VARCHAR2_TABLE_100();
62: a8 := JTF_DATE_TABLE();
63: a9 := JTF_NUMBER_TABLE();
64: else
65: a0 := JTF_NUMBER_TABLE();
66: a1 := JTF_NUMBER_TABLE();
67: a2 := JTF_NUMBER_TABLE();
68: a3 := JTF_VARCHAR2_TABLE_100();
69: a4 := JTF_VARCHAR2_TABLE_100();
70: a5 := JTF_NUMBER_TABLE();
63: a9 := JTF_NUMBER_TABLE();
64: else
65: a0 := JTF_NUMBER_TABLE();
66: a1 := JTF_NUMBER_TABLE();
67: a2 := JTF_NUMBER_TABLE();
68: a3 := JTF_VARCHAR2_TABLE_100();
69: a4 := JTF_VARCHAR2_TABLE_100();
70: a5 := JTF_NUMBER_TABLE();
71: a6 := JTF_DATE_TABLE();
66: a1 := JTF_NUMBER_TABLE();
67: a2 := JTF_NUMBER_TABLE();
68: a3 := JTF_VARCHAR2_TABLE_100();
69: a4 := JTF_VARCHAR2_TABLE_100();
70: a5 := JTF_NUMBER_TABLE();
71: a6 := JTF_DATE_TABLE();
72: a7 := JTF_NUMBER_TABLE();
73: a8 := JTF_DATE_TABLE();
74: a9 := JTF_NUMBER_TABLE();
68: a3 := JTF_VARCHAR2_TABLE_100();
69: a4 := JTF_VARCHAR2_TABLE_100();
70: a5 := JTF_NUMBER_TABLE();
71: a6 := JTF_DATE_TABLE();
72: a7 := JTF_NUMBER_TABLE();
73: a8 := JTF_DATE_TABLE();
74: a9 := JTF_NUMBER_TABLE();
75: if t.count > 0 then
76: a0.extend(t.count);
70: a5 := JTF_NUMBER_TABLE();
71: a6 := JTF_DATE_TABLE();
72: a7 := JTF_NUMBER_TABLE();
73: a8 := JTF_DATE_TABLE();
74: a9 := JTF_NUMBER_TABLE();
75: if t.count > 0 then
76: a0.extend(t.count);
77: a1.extend(t.count);
78: a2.extend(t.count);
189: , p_init_msg_list VARCHAR2
190: , x_return_status out nocopy VARCHAR2
191: , x_msg_count out nocopy NUMBER
192: , x_msg_data out nocopy VARCHAR2
193: , p5_a0 JTF_NUMBER_TABLE
194: , p5_a1 JTF_NUMBER_TABLE
195: , p5_a2 JTF_NUMBER_TABLE
196: , p5_a3 JTF_VARCHAR2_TABLE_100
197: , p5_a4 JTF_VARCHAR2_TABLE_100
190: , x_return_status out nocopy VARCHAR2
191: , x_msg_count out nocopy NUMBER
192: , x_msg_data out nocopy VARCHAR2
193: , p5_a0 JTF_NUMBER_TABLE
194: , p5_a1 JTF_NUMBER_TABLE
195: , p5_a2 JTF_NUMBER_TABLE
196: , p5_a3 JTF_VARCHAR2_TABLE_100
197: , p5_a4 JTF_VARCHAR2_TABLE_100
198: , p5_a5 JTF_NUMBER_TABLE
191: , x_msg_count out nocopy NUMBER
192: , x_msg_data out nocopy VARCHAR2
193: , p5_a0 JTF_NUMBER_TABLE
194: , p5_a1 JTF_NUMBER_TABLE
195: , p5_a2 JTF_NUMBER_TABLE
196: , p5_a3 JTF_VARCHAR2_TABLE_100
197: , p5_a4 JTF_VARCHAR2_TABLE_100
198: , p5_a5 JTF_NUMBER_TABLE
199: , p5_a6 JTF_DATE_TABLE
194: , p5_a1 JTF_NUMBER_TABLE
195: , p5_a2 JTF_NUMBER_TABLE
196: , p5_a3 JTF_VARCHAR2_TABLE_100
197: , p5_a4 JTF_VARCHAR2_TABLE_100
198: , p5_a5 JTF_NUMBER_TABLE
199: , p5_a6 JTF_DATE_TABLE
200: , p5_a7 JTF_NUMBER_TABLE
201: , p5_a8 JTF_DATE_TABLE
202: , p5_a9 JTF_NUMBER_TABLE
196: , p5_a3 JTF_VARCHAR2_TABLE_100
197: , p5_a4 JTF_VARCHAR2_TABLE_100
198: , p5_a5 JTF_NUMBER_TABLE
199: , p5_a6 JTF_DATE_TABLE
200: , p5_a7 JTF_NUMBER_TABLE
201: , p5_a8 JTF_DATE_TABLE
202: , p5_a9 JTF_NUMBER_TABLE
203: , p6_a0 out nocopy JTF_NUMBER_TABLE
204: , p6_a1 out nocopy JTF_NUMBER_TABLE
198: , p5_a5 JTF_NUMBER_TABLE
199: , p5_a6 JTF_DATE_TABLE
200: , p5_a7 JTF_NUMBER_TABLE
201: , p5_a8 JTF_DATE_TABLE
202: , p5_a9 JTF_NUMBER_TABLE
203: , p6_a0 out nocopy JTF_NUMBER_TABLE
204: , p6_a1 out nocopy JTF_NUMBER_TABLE
205: , p6_a2 out nocopy JTF_NUMBER_TABLE
206: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
199: , p5_a6 JTF_DATE_TABLE
200: , p5_a7 JTF_NUMBER_TABLE
201: , p5_a8 JTF_DATE_TABLE
202: , p5_a9 JTF_NUMBER_TABLE
203: , p6_a0 out nocopy JTF_NUMBER_TABLE
204: , p6_a1 out nocopy JTF_NUMBER_TABLE
205: , p6_a2 out nocopy JTF_NUMBER_TABLE
206: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
207: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
200: , p5_a7 JTF_NUMBER_TABLE
201: , p5_a8 JTF_DATE_TABLE
202: , p5_a9 JTF_NUMBER_TABLE
203: , p6_a0 out nocopy JTF_NUMBER_TABLE
204: , p6_a1 out nocopy JTF_NUMBER_TABLE
205: , p6_a2 out nocopy JTF_NUMBER_TABLE
206: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
207: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
208: , p6_a5 out nocopy JTF_NUMBER_TABLE
201: , p5_a8 JTF_DATE_TABLE
202: , p5_a9 JTF_NUMBER_TABLE
203: , p6_a0 out nocopy JTF_NUMBER_TABLE
204: , p6_a1 out nocopy JTF_NUMBER_TABLE
205: , p6_a2 out nocopy JTF_NUMBER_TABLE
206: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
207: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
208: , p6_a5 out nocopy JTF_NUMBER_TABLE
209: , p6_a6 out nocopy JTF_DATE_TABLE
204: , p6_a1 out nocopy JTF_NUMBER_TABLE
205: , p6_a2 out nocopy JTF_NUMBER_TABLE
206: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
207: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
208: , p6_a5 out nocopy JTF_NUMBER_TABLE
209: , p6_a6 out nocopy JTF_DATE_TABLE
210: , p6_a7 out nocopy JTF_NUMBER_TABLE
211: , p6_a8 out nocopy JTF_DATE_TABLE
212: , p6_a9 out nocopy JTF_NUMBER_TABLE
206: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
207: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
208: , p6_a5 out nocopy JTF_NUMBER_TABLE
209: , p6_a6 out nocopy JTF_DATE_TABLE
210: , p6_a7 out nocopy JTF_NUMBER_TABLE
211: , p6_a8 out nocopy JTF_DATE_TABLE
212: , p6_a9 out nocopy JTF_NUMBER_TABLE
213: )
214:
208: , p6_a5 out nocopy JTF_NUMBER_TABLE
209: , p6_a6 out nocopy JTF_DATE_TABLE
210: , p6_a7 out nocopy JTF_NUMBER_TABLE
211: , p6_a8 out nocopy JTF_DATE_TABLE
212: , p6_a9 out nocopy JTF_NUMBER_TABLE
213: )
214:
215: as
216: ddp_eco_tbl okl_eco_pvt.okl_eco_tbl;
349: , p_init_msg_list VARCHAR2
350: , x_return_status out nocopy VARCHAR2
351: , x_msg_count out nocopy NUMBER
352: , x_msg_data out nocopy VARCHAR2
353: , p5_a0 JTF_NUMBER_TABLE
354: , p5_a1 JTF_NUMBER_TABLE
355: , p5_a2 JTF_NUMBER_TABLE
356: , p5_a3 JTF_VARCHAR2_TABLE_100
357: , p5_a4 JTF_VARCHAR2_TABLE_100
350: , x_return_status out nocopy VARCHAR2
351: , x_msg_count out nocopy NUMBER
352: , x_msg_data out nocopy VARCHAR2
353: , p5_a0 JTF_NUMBER_TABLE
354: , p5_a1 JTF_NUMBER_TABLE
355: , p5_a2 JTF_NUMBER_TABLE
356: , p5_a3 JTF_VARCHAR2_TABLE_100
357: , p5_a4 JTF_VARCHAR2_TABLE_100
358: , p5_a5 JTF_NUMBER_TABLE
351: , x_msg_count out nocopy NUMBER
352: , x_msg_data out nocopy VARCHAR2
353: , p5_a0 JTF_NUMBER_TABLE
354: , p5_a1 JTF_NUMBER_TABLE
355: , p5_a2 JTF_NUMBER_TABLE
356: , p5_a3 JTF_VARCHAR2_TABLE_100
357: , p5_a4 JTF_VARCHAR2_TABLE_100
358: , p5_a5 JTF_NUMBER_TABLE
359: , p5_a6 JTF_DATE_TABLE
354: , p5_a1 JTF_NUMBER_TABLE
355: , p5_a2 JTF_NUMBER_TABLE
356: , p5_a3 JTF_VARCHAR2_TABLE_100
357: , p5_a4 JTF_VARCHAR2_TABLE_100
358: , p5_a5 JTF_NUMBER_TABLE
359: , p5_a6 JTF_DATE_TABLE
360: , p5_a7 JTF_NUMBER_TABLE
361: , p5_a8 JTF_DATE_TABLE
362: , p5_a9 JTF_NUMBER_TABLE
356: , p5_a3 JTF_VARCHAR2_TABLE_100
357: , p5_a4 JTF_VARCHAR2_TABLE_100
358: , p5_a5 JTF_NUMBER_TABLE
359: , p5_a6 JTF_DATE_TABLE
360: , p5_a7 JTF_NUMBER_TABLE
361: , p5_a8 JTF_DATE_TABLE
362: , p5_a9 JTF_NUMBER_TABLE
363: , p6_a0 out nocopy JTF_NUMBER_TABLE
364: , p6_a1 out nocopy JTF_NUMBER_TABLE
358: , p5_a5 JTF_NUMBER_TABLE
359: , p5_a6 JTF_DATE_TABLE
360: , p5_a7 JTF_NUMBER_TABLE
361: , p5_a8 JTF_DATE_TABLE
362: , p5_a9 JTF_NUMBER_TABLE
363: , p6_a0 out nocopy JTF_NUMBER_TABLE
364: , p6_a1 out nocopy JTF_NUMBER_TABLE
365: , p6_a2 out nocopy JTF_NUMBER_TABLE
366: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
359: , p5_a6 JTF_DATE_TABLE
360: , p5_a7 JTF_NUMBER_TABLE
361: , p5_a8 JTF_DATE_TABLE
362: , p5_a9 JTF_NUMBER_TABLE
363: , p6_a0 out nocopy JTF_NUMBER_TABLE
364: , p6_a1 out nocopy JTF_NUMBER_TABLE
365: , p6_a2 out nocopy JTF_NUMBER_TABLE
366: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
367: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
360: , p5_a7 JTF_NUMBER_TABLE
361: , p5_a8 JTF_DATE_TABLE
362: , p5_a9 JTF_NUMBER_TABLE
363: , p6_a0 out nocopy JTF_NUMBER_TABLE
364: , p6_a1 out nocopy JTF_NUMBER_TABLE
365: , p6_a2 out nocopy JTF_NUMBER_TABLE
366: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
367: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
368: , p6_a5 out nocopy JTF_NUMBER_TABLE
361: , p5_a8 JTF_DATE_TABLE
362: , p5_a9 JTF_NUMBER_TABLE
363: , p6_a0 out nocopy JTF_NUMBER_TABLE
364: , p6_a1 out nocopy JTF_NUMBER_TABLE
365: , p6_a2 out nocopy JTF_NUMBER_TABLE
366: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
367: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
368: , p6_a5 out nocopy JTF_NUMBER_TABLE
369: , p6_a6 out nocopy JTF_DATE_TABLE
364: , p6_a1 out nocopy JTF_NUMBER_TABLE
365: , p6_a2 out nocopy JTF_NUMBER_TABLE
366: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
367: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
368: , p6_a5 out nocopy JTF_NUMBER_TABLE
369: , p6_a6 out nocopy JTF_DATE_TABLE
370: , p6_a7 out nocopy JTF_NUMBER_TABLE
371: , p6_a8 out nocopy JTF_DATE_TABLE
372: , p6_a9 out nocopy JTF_NUMBER_TABLE
366: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
367: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
368: , p6_a5 out nocopy JTF_NUMBER_TABLE
369: , p6_a6 out nocopy JTF_DATE_TABLE
370: , p6_a7 out nocopy JTF_NUMBER_TABLE
371: , p6_a8 out nocopy JTF_DATE_TABLE
372: , p6_a9 out nocopy JTF_NUMBER_TABLE
373: )
374:
368: , p6_a5 out nocopy JTF_NUMBER_TABLE
369: , p6_a6 out nocopy JTF_DATE_TABLE
370: , p6_a7 out nocopy JTF_NUMBER_TABLE
371: , p6_a8 out nocopy JTF_DATE_TABLE
372: , p6_a9 out nocopy JTF_NUMBER_TABLE
373: )
374:
375: as
376: ddp_eco_tbl okl_eco_pvt.okl_eco_tbl;
485: , p_init_msg_list VARCHAR2
486: , x_return_status out nocopy VARCHAR2
487: , x_msg_count out nocopy NUMBER
488: , x_msg_data out nocopy VARCHAR2
489: , p5_a0 JTF_NUMBER_TABLE
490: , p5_a1 JTF_NUMBER_TABLE
491: , p5_a2 JTF_NUMBER_TABLE
492: , p5_a3 JTF_VARCHAR2_TABLE_100
493: , p5_a4 JTF_VARCHAR2_TABLE_100
486: , x_return_status out nocopy VARCHAR2
487: , x_msg_count out nocopy NUMBER
488: , x_msg_data out nocopy VARCHAR2
489: , p5_a0 JTF_NUMBER_TABLE
490: , p5_a1 JTF_NUMBER_TABLE
491: , p5_a2 JTF_NUMBER_TABLE
492: , p5_a3 JTF_VARCHAR2_TABLE_100
493: , p5_a4 JTF_VARCHAR2_TABLE_100
494: , p5_a5 JTF_NUMBER_TABLE
487: , x_msg_count out nocopy NUMBER
488: , x_msg_data out nocopy VARCHAR2
489: , p5_a0 JTF_NUMBER_TABLE
490: , p5_a1 JTF_NUMBER_TABLE
491: , p5_a2 JTF_NUMBER_TABLE
492: , p5_a3 JTF_VARCHAR2_TABLE_100
493: , p5_a4 JTF_VARCHAR2_TABLE_100
494: , p5_a5 JTF_NUMBER_TABLE
495: , p5_a6 JTF_DATE_TABLE
490: , p5_a1 JTF_NUMBER_TABLE
491: , p5_a2 JTF_NUMBER_TABLE
492: , p5_a3 JTF_VARCHAR2_TABLE_100
493: , p5_a4 JTF_VARCHAR2_TABLE_100
494: , p5_a5 JTF_NUMBER_TABLE
495: , p5_a6 JTF_DATE_TABLE
496: , p5_a7 JTF_NUMBER_TABLE
497: , p5_a8 JTF_DATE_TABLE
498: , p5_a9 JTF_NUMBER_TABLE
492: , p5_a3 JTF_VARCHAR2_TABLE_100
493: , p5_a4 JTF_VARCHAR2_TABLE_100
494: , p5_a5 JTF_NUMBER_TABLE
495: , p5_a6 JTF_DATE_TABLE
496: , p5_a7 JTF_NUMBER_TABLE
497: , p5_a8 JTF_DATE_TABLE
498: , p5_a9 JTF_NUMBER_TABLE
499: )
500:
494: , p5_a5 JTF_NUMBER_TABLE
495: , p5_a6 JTF_DATE_TABLE
496: , p5_a7 JTF_NUMBER_TABLE
497: , p5_a8 JTF_DATE_TABLE
498: , p5_a9 JTF_NUMBER_TABLE
499: )
500:
501: as
502: ddp_eco_tbl okl_eco_pvt.okl_eco_tbl;