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
10: , a7 JTF_NUMBER_TABLE
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
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
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
47: , a7 out nocopy JTF_NUMBER_TABLE
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
47: , a7 out nocopy JTF_NUMBER_TABLE
48: , a8 out nocopy JTF_DATE_TABLE
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();
61: a7 := JTF_NUMBER_TABLE();
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();
61: a7 := JTF_NUMBER_TABLE();
62: a8 := JTF_DATE_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();
72: a7 := JTF_NUMBER_TABLE();
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();
72: a7 := JTF_NUMBER_TABLE();
73: a8 := JTF_DATE_TABLE();
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
200: , p5_a7 JTF_NUMBER_TABLE
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
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
209: , p6_a6 out nocopy JTF_DATE_TABLE
210: , p6_a7 out nocopy 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
210: , p6_a7 out nocopy JTF_NUMBER_TABLE
211: , p6_a8 out nocopy JTF_DATE_TABLE
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
360: , p5_a7 JTF_NUMBER_TABLE
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
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
369: , p6_a6 out nocopy JTF_DATE_TABLE
370: , p6_a7 out nocopy 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
370: , p6_a7 out nocopy JTF_NUMBER_TABLE
371: , p6_a8 out nocopy JTF_DATE_TABLE
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
496: , p5_a7 JTF_NUMBER_TABLE
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
496: , p5_a7 JTF_NUMBER_TABLE
497: , p5_a8 JTF_DATE_TABLE