DBA Data[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;