[Home] [Help]
PACKAGE: APPS.AS_MULTI_CURRENCIES_PKG_W
Source
1 package as_multi_currencies_pkg_w AUTHID CURRENT_USER as
2 /* $Header: asxwmcps.pls 120.1 2005/06/24 22:26 appldev ship $ */
3 procedure rosetta_table_copy_in_p3(t out nocopy as_multi_currencies_pkg.type_mappings_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_VARCHAR2_TABLE_100
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_DATE_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_DATE_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_NUMBER_TABLE
15 );
16 procedure rosetta_table_copy_out_p3(t as_multi_currencies_pkg.type_mappings_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
17 , a1 out nocopy JTF_VARCHAR2_TABLE_100
18 , a2 out nocopy JTF_VARCHAR2_TABLE_100
19 , a3 out nocopy JTF_VARCHAR2_TABLE_100
20 , a4 out nocopy JTF_VARCHAR2_TABLE_100
21 , a5 out nocopy JTF_VARCHAR2_TABLE_100
22 , a6 out nocopy JTF_DATE_TABLE
23 , a7 out nocopy JTF_NUMBER_TABLE
24 , a8 out nocopy JTF_DATE_TABLE
25 , a9 out nocopy JTF_NUMBER_TABLE
26 , a10 out nocopy JTF_NUMBER_TABLE
27 , a11 out nocopy JTF_NUMBER_TABLE
28 );
29
30 procedure rosetta_table_copy_in_p7(t out nocopy as_multi_currencies_pkg.period_rates_tbl_type, a0 JTF_VARCHAR2_TABLE_100
31 , a1 JTF_VARCHAR2_TABLE_100
32 , a2 JTF_DATE_TABLE
33 , a3 JTF_VARCHAR2_TABLE_100
34 , a4 JTF_NUMBER_TABLE
35 );
36 procedure rosetta_table_copy_out_p7(t as_multi_currencies_pkg.period_rates_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
37 , a1 out nocopy JTF_VARCHAR2_TABLE_100
38 , a2 out nocopy JTF_DATE_TABLE
39 , a3 out nocopy JTF_VARCHAR2_TABLE_100
40 , a4 out nocopy JTF_NUMBER_TABLE
41 );
42
43 procedure insert_type_mappings(p0_a0 JTF_VARCHAR2_TABLE_100
44 , p0_a1 JTF_VARCHAR2_TABLE_100
45 , p0_a2 JTF_VARCHAR2_TABLE_100
46 , p0_a3 JTF_VARCHAR2_TABLE_100
47 , p0_a4 JTF_VARCHAR2_TABLE_100
48 , p0_a5 JTF_VARCHAR2_TABLE_100
49 , p0_a6 JTF_DATE_TABLE
50 , p0_a7 JTF_NUMBER_TABLE
51 , p0_a8 JTF_DATE_TABLE
52 , p0_a9 JTF_NUMBER_TABLE
53 , p0_a10 JTF_NUMBER_TABLE
54 , p0_a11 JTF_NUMBER_TABLE
55 , x_return_status out nocopy VARCHAR2
56 , x_msg_count out nocopy NUMBER
57 , x_msg_data out nocopy VARCHAR2
58 );
59 procedure update_type_mappings(p0_a0 JTF_VARCHAR2_TABLE_100
60 , p0_a1 JTF_VARCHAR2_TABLE_100
61 , p0_a2 JTF_VARCHAR2_TABLE_100
62 , p0_a3 JTF_VARCHAR2_TABLE_100
63 , p0_a4 JTF_VARCHAR2_TABLE_100
64 , p0_a5 JTF_VARCHAR2_TABLE_100
65 , p0_a6 JTF_DATE_TABLE
66 , p0_a7 JTF_NUMBER_TABLE
67 , p0_a8 JTF_DATE_TABLE
68 , p0_a9 JTF_NUMBER_TABLE
69 , p0_a10 JTF_NUMBER_TABLE
70 , p0_a11 JTF_NUMBER_TABLE
71 , x_return_status out nocopy VARCHAR2
72 , x_msg_count out nocopy NUMBER
73 , x_msg_data out nocopy VARCHAR2
74 );
75 procedure delete_type_mappings(p0_a0 JTF_VARCHAR2_TABLE_100
76 , p0_a1 JTF_VARCHAR2_TABLE_100
77 , p0_a2 JTF_VARCHAR2_TABLE_100
78 , p0_a3 JTF_VARCHAR2_TABLE_100
79 , p0_a4 JTF_VARCHAR2_TABLE_100
80 , p0_a5 JTF_VARCHAR2_TABLE_100
81 , p0_a6 JTF_DATE_TABLE
82 , p0_a7 JTF_NUMBER_TABLE
83 , p0_a8 JTF_DATE_TABLE
84 , p0_a9 JTF_NUMBER_TABLE
85 , p0_a10 JTF_NUMBER_TABLE
86 , p0_a11 JTF_NUMBER_TABLE
87 , x_return_status out nocopy VARCHAR2
88 , x_msg_count out nocopy NUMBER
89 , x_msg_data out nocopy VARCHAR2
90 );
91 procedure insert_period_rates(p0_a0 JTF_VARCHAR2_TABLE_100
92 , p0_a1 JTF_VARCHAR2_TABLE_100
93 , p0_a2 JTF_DATE_TABLE
94 , p0_a3 JTF_VARCHAR2_TABLE_100
95 , p0_a4 JTF_NUMBER_TABLE
96 , x_return_status out nocopy VARCHAR2
97 , x_msg_count out nocopy NUMBER
98 , x_msg_data out nocopy VARCHAR2
99 );
100 procedure update_period_rates(p0_a0 JTF_VARCHAR2_TABLE_100
101 , p0_a1 JTF_VARCHAR2_TABLE_100
102 , p0_a2 JTF_DATE_TABLE
103 , p0_a3 JTF_VARCHAR2_TABLE_100
104 , p0_a4 JTF_NUMBER_TABLE
105 , x_return_status out nocopy VARCHAR2
106 , x_msg_count out nocopy NUMBER
107 , x_msg_data out nocopy VARCHAR2
108 );
109 procedure delete_period_rates(p0_a0 JTF_VARCHAR2_TABLE_100
110 , p0_a1 JTF_VARCHAR2_TABLE_100
111 , p0_a2 JTF_DATE_TABLE
112 , p0_a3 JTF_VARCHAR2_TABLE_100
113 , p0_a4 JTF_NUMBER_TABLE
114 , x_return_status out nocopy VARCHAR2
115 , x_msg_count out nocopy NUMBER
116 , x_msg_data out nocopy VARCHAR2
117 );
118 end as_multi_currencies_pkg_w;