eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.AMS_VENUE_RATES_PVT_W

Source


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
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
18     , a15 JTF_VARCHAR2_TABLE_100
19     , a16 JTF_VARCHAR2_TABLE_100
20     , a17 JTF_VARCHAR2_TABLE_200
21     , a18 JTF_VARCHAR2_TABLE_200
22     , a19 JTF_VARCHAR2_TABLE_200
23     , a20 JTF_VARCHAR2_TABLE_200
24     , a21 JTF_VARCHAR2_TABLE_200
25     , a22 JTF_VARCHAR2_TABLE_200
26     , a23 JTF_VARCHAR2_TABLE_200
27     , a24 JTF_VARCHAR2_TABLE_200
28     , a25 JTF_VARCHAR2_TABLE_200
29     , a26 JTF_VARCHAR2_TABLE_200
30     , a27 JTF_VARCHAR2_TABLE_200
31     , a28 JTF_VARCHAR2_TABLE_200
32     , a29 JTF_VARCHAR2_TABLE_200
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
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
51     , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
52     , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
53     , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100
54     , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_200
55     , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_200
56     , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_200
57     , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_200
58     , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_200
59     , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_200
60     , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_200
61     , a24 OUT NOCOPY JTF_VARCHAR2_TABLE_200
62     , a25 OUT NOCOPY JTF_VARCHAR2_TABLE_200
63     , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_200
64     , a27 OUT NOCOPY JTF_VARCHAR2_TABLE_200
65     , a28 OUT NOCOPY JTF_VARCHAR2_TABLE_200
66     , a29 OUT NOCOPY JTF_VARCHAR2_TABLE_200
67     , a30 OUT NOCOPY JTF_VARCHAR2_TABLE_200
68     , a31 OUT NOCOPY JTF_VARCHAR2_TABLE_200
69     , a32 OUT NOCOPY JTF_VARCHAR2_TABLE_4000
70     );
71 
72   procedure create_venue_rates(p_api_version_number  NUMBER
73     , p_init_msg_list  VARCHAR2
74     , p_commit  VARCHAR2
75     , p_validation_level  NUMBER
76     , x_return_status OUT NOCOPY  VARCHAR2
77     , x_msg_count OUT NOCOPY  NUMBER
78     , x_msg_data OUT NOCOPY  VARCHAR2
79     , x_rate_id OUT NOCOPY  NUMBER
80     , p7_a0  NUMBER := 0-1962.0724
81     , p7_a1  DATE := fnd_api.g_miss_date
82     , p7_a2  NUMBER := 0-1962.0724
83     , p7_a3  DATE := fnd_api.g_miss_date
84     , p7_a4  NUMBER := 0-1962.0724
85     , p7_a5  NUMBER := 0-1962.0724
86     , p7_a6  NUMBER := 0-1962.0724
87     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
88     , p7_a8  NUMBER := 0-1962.0724
89     , p7_a9  NUMBER := 0-1962.0724
90     , p7_a10  NUMBER := 0-1962.0724
91     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
92     , p7_a12  NUMBER := 0-1962.0724
93     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
94     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
95     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
96     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
97     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
98     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
99     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
100     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
101     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
102     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
103     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
104     , p7_a24  VARCHAR2 := fnd_api.g_miss_char
105     , p7_a25  VARCHAR2 := fnd_api.g_miss_char
106     , p7_a26  VARCHAR2 := fnd_api.g_miss_char
107     , p7_a27  VARCHAR2 := fnd_api.g_miss_char
108     , p7_a28  VARCHAR2 := fnd_api.g_miss_char
109     , p7_a29  VARCHAR2 := fnd_api.g_miss_char
110     , p7_a30  VARCHAR2 := fnd_api.g_miss_char
111     , p7_a31  VARCHAR2 := fnd_api.g_miss_char
112     , p7_a32  VARCHAR2 := fnd_api.g_miss_char
113   );
114   procedure update_venue_rates(p_api_version_number  NUMBER
115     , p_init_msg_list  VARCHAR2
116     , p_commit  VARCHAR2
117     , p_validation_level  NUMBER
118     , x_return_status OUT NOCOPY  VARCHAR2
119     , x_msg_count OUT NOCOPY  NUMBER
120     , x_msg_data OUT NOCOPY  VARCHAR2
121     , x_object_version_number OUT NOCOPY  NUMBER
122     , p7_a0  NUMBER := 0-1962.0724
123     , p7_a1  DATE := fnd_api.g_miss_date
124     , p7_a2  NUMBER := 0-1962.0724
125     , p7_a3  DATE := fnd_api.g_miss_date
126     , p7_a4  NUMBER := 0-1962.0724
127     , p7_a5  NUMBER := 0-1962.0724
128     , p7_a6  NUMBER := 0-1962.0724
129     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
130     , p7_a8  NUMBER := 0-1962.0724
131     , p7_a9  NUMBER := 0-1962.0724
132     , p7_a10  NUMBER := 0-1962.0724
133     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
134     , p7_a12  NUMBER := 0-1962.0724
135     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
136     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
137     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
138     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
139     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
140     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
141     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
142     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
143     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
144     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
145     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
146     , p7_a24  VARCHAR2 := fnd_api.g_miss_char
147     , p7_a25  VARCHAR2 := fnd_api.g_miss_char
148     , p7_a26  VARCHAR2 := fnd_api.g_miss_char
149     , p7_a27  VARCHAR2 := fnd_api.g_miss_char
150     , p7_a28  VARCHAR2 := fnd_api.g_miss_char
151     , p7_a29  VARCHAR2 := fnd_api.g_miss_char
152     , p7_a30  VARCHAR2 := fnd_api.g_miss_char
153     , p7_a31  VARCHAR2 := fnd_api.g_miss_char
154     , p7_a32  VARCHAR2 := fnd_api.g_miss_char
155   );
156   procedure validate_venue_rates(p_api_version_number  NUMBER
157     , p_init_msg_list  VARCHAR2
158     , p_validation_level  NUMBER
159     , p_validation_mode  VARCHAR2
160     , x_return_status OUT NOCOPY  VARCHAR2
161     , x_msg_count OUT NOCOPY  NUMBER
162     , x_msg_data OUT NOCOPY  VARCHAR2
163     , p3_a0  NUMBER := 0-1962.0724
164     , p3_a1  DATE := fnd_api.g_miss_date
165     , p3_a2  NUMBER := 0-1962.0724
166     , p3_a3  DATE := fnd_api.g_miss_date
167     , p3_a4  NUMBER := 0-1962.0724
168     , p3_a5  NUMBER := 0-1962.0724
169     , p3_a6  NUMBER := 0-1962.0724
170     , p3_a7  VARCHAR2 := fnd_api.g_miss_char
171     , p3_a8  NUMBER := 0-1962.0724
172     , p3_a9  NUMBER := 0-1962.0724
173     , p3_a10  NUMBER := 0-1962.0724
174     , p3_a11  VARCHAR2 := fnd_api.g_miss_char
175     , p3_a12  NUMBER := 0-1962.0724
176     , p3_a13  VARCHAR2 := fnd_api.g_miss_char
177     , p3_a14  VARCHAR2 := fnd_api.g_miss_char
178     , p3_a15  VARCHAR2 := fnd_api.g_miss_char
179     , p3_a16  VARCHAR2 := fnd_api.g_miss_char
180     , p3_a17  VARCHAR2 := fnd_api.g_miss_char
181     , p3_a18  VARCHAR2 := fnd_api.g_miss_char
182     , p3_a19  VARCHAR2 := fnd_api.g_miss_char
183     , p3_a20  VARCHAR2 := fnd_api.g_miss_char
184     , p3_a21  VARCHAR2 := fnd_api.g_miss_char
185     , p3_a22  VARCHAR2 := fnd_api.g_miss_char
186     , p3_a23  VARCHAR2 := fnd_api.g_miss_char
187     , p3_a24  VARCHAR2 := fnd_api.g_miss_char
188     , p3_a25  VARCHAR2 := fnd_api.g_miss_char
189     , p3_a26  VARCHAR2 := fnd_api.g_miss_char
190     , p3_a27  VARCHAR2 := fnd_api.g_miss_char
191     , p3_a28  VARCHAR2 := fnd_api.g_miss_char
192     , p3_a29  VARCHAR2 := fnd_api.g_miss_char
193     , p3_a30  VARCHAR2 := fnd_api.g_miss_char
194     , p3_a31  VARCHAR2 := fnd_api.g_miss_char
195     , p3_a32  VARCHAR2 := fnd_api.g_miss_char
196   );
197   procedure check_venue_rates_items(p_validation_mode  VARCHAR2
198     , x_return_status OUT NOCOPY  VARCHAR2
199     , p0_a0  NUMBER := 0-1962.0724
200     , p0_a1  DATE := fnd_api.g_miss_date
201     , p0_a2  NUMBER := 0-1962.0724
202     , p0_a3  DATE := fnd_api.g_miss_date
203     , p0_a4  NUMBER := 0-1962.0724
204     , p0_a5  NUMBER := 0-1962.0724
205     , p0_a6  NUMBER := 0-1962.0724
206     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
207     , p0_a8  NUMBER := 0-1962.0724
208     , p0_a9  NUMBER := 0-1962.0724
209     , p0_a10  NUMBER := 0-1962.0724
210     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
211     , p0_a12  NUMBER := 0-1962.0724
212     , p0_a13  VARCHAR2 := fnd_api.g_miss_char
213     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
214     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
215     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
216     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
217     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
218     , p0_a19  VARCHAR2 := fnd_api.g_miss_char
219     , p0_a20  VARCHAR2 := fnd_api.g_miss_char
220     , p0_a21  VARCHAR2 := fnd_api.g_miss_char
221     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
222     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
223     , p0_a24  VARCHAR2 := fnd_api.g_miss_char
224     , p0_a25  VARCHAR2 := fnd_api.g_miss_char
225     , p0_a26  VARCHAR2 := fnd_api.g_miss_char
226     , p0_a27  VARCHAR2 := fnd_api.g_miss_char
227     , p0_a28  VARCHAR2 := fnd_api.g_miss_char
228     , p0_a29  VARCHAR2 := fnd_api.g_miss_char
229     , p0_a30  VARCHAR2 := fnd_api.g_miss_char
230     , p0_a31  VARCHAR2 := fnd_api.g_miss_char
231     , p0_a32  VARCHAR2 := fnd_api.g_miss_char
232   );
233   procedure validate_venue_rates_rec(p_api_version_number  NUMBER
234     , p_init_msg_list  VARCHAR2
235     , x_return_status OUT NOCOPY  VARCHAR2
236     , x_msg_count OUT NOCOPY  NUMBER
237     , x_msg_data OUT NOCOPY  VARCHAR2
238     , p5_a0  NUMBER := 0-1962.0724
239     , p5_a1  DATE := fnd_api.g_miss_date
240     , p5_a2  NUMBER := 0-1962.0724
241     , p5_a3  DATE := fnd_api.g_miss_date
242     , p5_a4  NUMBER := 0-1962.0724
243     , p5_a5  NUMBER := 0-1962.0724
244     , p5_a6  NUMBER := 0-1962.0724
245     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
246     , p5_a8  NUMBER := 0-1962.0724
247     , p5_a9  NUMBER := 0-1962.0724
248     , p5_a10  NUMBER := 0-1962.0724
249     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
250     , p5_a12  NUMBER := 0-1962.0724
251     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
252     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
253     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
254     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
255     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
256     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
257     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
258     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
259     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
260     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
261     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
262     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
263     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
264     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
265     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
266     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
267     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
268     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
269     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
270     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
271   );
272 end ams_venue_rates_pvt_w;