1: package ams_venue_rates_pvt_w AUTHID CURRENT_USER as
2: /* $Header: amswvrts.pls 115.6 2002/12/24 18:59:52 mukumar ship $ */
3: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_venue_rates_pvt.venue_rates_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package ams_venue_rates_pvt_w AUTHID CURRENT_USER as
2: /* $Header: amswvrts.pls 115.6 2002/12/24 18:59:52 mukumar ship $ */
3: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_venue_rates_pvt.venue_rates_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_venue_rates_pvt.venue_rates_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_200
34: , a31 JTF_VARCHAR2_TABLE_200
35: , a32 JTF_VARCHAR2_TABLE_4000
36: );
37: procedure rosetta_table_copy_out_p3(t ams_venue_rates_pvt.venue_rates_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
38: , a1 OUT NOCOPY JTF_DATE_TABLE
39: , a2 OUT NOCOPY JTF_NUMBER_TABLE
40: , a3 OUT NOCOPY JTF_DATE_TABLE
41: , a4 OUT NOCOPY JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_4000
36: );
37: procedure rosetta_table_copy_out_p3(t ams_venue_rates_pvt.venue_rates_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
38: , a1 OUT NOCOPY JTF_DATE_TABLE
39: , a2 OUT NOCOPY JTF_NUMBER_TABLE
40: , a3 OUT NOCOPY JTF_DATE_TABLE
41: , a4 OUT NOCOPY JTF_NUMBER_TABLE
42: , a5 OUT NOCOPY JTF_NUMBER_TABLE
43: , a6 OUT NOCOPY JTF_NUMBER_TABLE
37: procedure rosetta_table_copy_out_p3(t ams_venue_rates_pvt.venue_rates_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
38: , a1 OUT NOCOPY JTF_DATE_TABLE
39: , a2 OUT NOCOPY JTF_NUMBER_TABLE
40: , a3 OUT NOCOPY JTF_DATE_TABLE
41: , a4 OUT NOCOPY JTF_NUMBER_TABLE
42: , a5 OUT NOCOPY JTF_NUMBER_TABLE
43: , a6 OUT NOCOPY JTF_NUMBER_TABLE
44: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
45: , a8 OUT NOCOPY JTF_NUMBER_TABLE
38: , a1 OUT NOCOPY JTF_DATE_TABLE
39: , a2 OUT NOCOPY JTF_NUMBER_TABLE
40: , a3 OUT NOCOPY JTF_DATE_TABLE
41: , a4 OUT NOCOPY JTF_NUMBER_TABLE
42: , a5 OUT NOCOPY JTF_NUMBER_TABLE
43: , a6 OUT NOCOPY JTF_NUMBER_TABLE
44: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
45: , a8 OUT NOCOPY JTF_NUMBER_TABLE
46: , a9 OUT NOCOPY JTF_NUMBER_TABLE
39: , a2 OUT NOCOPY JTF_NUMBER_TABLE
40: , a3 OUT NOCOPY JTF_DATE_TABLE
41: , a4 OUT NOCOPY JTF_NUMBER_TABLE
42: , a5 OUT NOCOPY JTF_NUMBER_TABLE
43: , a6 OUT NOCOPY JTF_NUMBER_TABLE
44: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
45: , a8 OUT NOCOPY JTF_NUMBER_TABLE
46: , a9 OUT NOCOPY JTF_NUMBER_TABLE
47: , a10 OUT NOCOPY JTF_NUMBER_TABLE
41: , a4 OUT NOCOPY JTF_NUMBER_TABLE
42: , a5 OUT NOCOPY JTF_NUMBER_TABLE
43: , a6 OUT NOCOPY JTF_NUMBER_TABLE
44: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
45: , a8 OUT NOCOPY JTF_NUMBER_TABLE
46: , a9 OUT NOCOPY JTF_NUMBER_TABLE
47: , a10 OUT NOCOPY JTF_NUMBER_TABLE
48: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
49: , a12 OUT NOCOPY JTF_NUMBER_TABLE
42: , a5 OUT NOCOPY JTF_NUMBER_TABLE
43: , a6 OUT NOCOPY JTF_NUMBER_TABLE
44: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
45: , a8 OUT NOCOPY JTF_NUMBER_TABLE
46: , a9 OUT NOCOPY JTF_NUMBER_TABLE
47: , a10 OUT NOCOPY JTF_NUMBER_TABLE
48: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
49: , a12 OUT NOCOPY JTF_NUMBER_TABLE
50: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
43: , a6 OUT NOCOPY JTF_NUMBER_TABLE
44: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
45: , a8 OUT NOCOPY JTF_NUMBER_TABLE
46: , a9 OUT NOCOPY JTF_NUMBER_TABLE
47: , a10 OUT NOCOPY JTF_NUMBER_TABLE
48: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
49: , a12 OUT NOCOPY JTF_NUMBER_TABLE
50: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
51: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
45: , a8 OUT NOCOPY JTF_NUMBER_TABLE
46: , a9 OUT NOCOPY JTF_NUMBER_TABLE
47: , a10 OUT NOCOPY JTF_NUMBER_TABLE
48: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
49: , a12 OUT NOCOPY JTF_NUMBER_TABLE
50: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
51: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
52: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
53: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100