[Home] [Help]
PACKAGE: APPS.AMS_VENUE_RATES_PUB
Source
1 PACKAGE AMS_Venue_Rates_PUB AUTHID CURRENT_USER AS
2 /* $Header: amspvrts.pls 115.4 2002/11/16 00:48:09 dbiswas ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Venue_Rates_PUB
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 --===================================================================
19 -- Start of Comments
20 -- -------------------------------------------------------
21 -- Record name
22 -- venue_rates_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- rate_id
26 -- last_update_date
27 -- last_updated_by
28 -- creation_date
29 -- created_by
30 -- last_update_login
31 -- object_version_number
32 -- active_flag
33 -- venue_id
34 -- metric_id
35 -- transactional_value
36 -- transactional_currency_code
37 -- functional_value
38 -- functional_currency_code
39 -- uom_code
40 -- attribute_category
41 -- attribute1
42 -- attribute2
43 -- attribute3
44 -- attribute4
45 -- attribute5
46 -- attribute6
47 -- attribute7
48 -- attribute8
49 -- attribute9
50 -- attribute10
51 -- attribute11
52 -- attribute12
53 -- attribute13
54 -- attribute14
55 -- attribute15
56 --
57 -- Required
58 --
59 -- Defaults
60 --
61 -- Note: This is automatic generated record definition, it includes all columns
62 -- defined in the table, developer must manually add or delete some of the attributes.
63 --
64 -- End of Comments
65
66 --===================================================================
67 TYPE venue_rates_rec_type IS RECORD
68 (
69 rate_id NUMBER := FND_API.G_MISS_NUM,
70 last_update_date DATE := FND_API.G_MISS_DATE,
71 last_updated_by NUMBER := FND_API.G_MISS_NUM,
72 creation_date DATE := FND_API.G_MISS_DATE,
73 created_by NUMBER := FND_API.G_MISS_NUM,
74 last_update_login NUMBER := FND_API.G_MISS_NUM,
75 object_version_number NUMBER := FND_API.G_MISS_NUM,
76 active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
77 venue_id NUMBER := FND_API.G_MISS_NUM,
78 metric_id NUMBER := FND_API.G_MISS_NUM,
79 transactional_value NUMBER := FND_API.G_MISS_NUM,
80 transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
81 functional_value NUMBER := FND_API.G_MISS_NUM,
82 functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
83 uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
84 rate_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
85 attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
86 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101 description VARCHAR2(4000) := FND_API.G_MISS_CHAR
102 );
103
104 g_miss_venue_rates_rec venue_rates_rec_type;
105 TYPE venue_rates_tbl_type IS TABLE OF venue_rates_rec_type INDEX BY BINARY_INTEGER;
106 g_miss_venue_rates_tbl venue_rates_tbl_type;
107
108 TYPE venue_rates_sort_rec_type IS RECORD
109 (
110 -- Please define your own sort by record here.
111 last_update_date NUMBER := NULL
112 );
113
114 -- ==============================================================================
115 -- Start of Comments
116 -- ==============================================================================
117 -- API Name
118 -- Create_Venue_Rates
119 -- Type
120 -- Public
121 -- Pre-Req
122 --
123 -- Parameters
124 --
125 -- IN
126 -- p_api_version_number IN NUMBER Required
127 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129 -- p_venue_rates_rec IN venue_rates_rec_type Required
130 --
131 -- OUT
132 -- x_return_status OUT VARCHAR2
133 -- x_msg_count OUT NUMBER
134 -- x_msg_data OUT VARCHAR2
135 -- Version : Current version 1.0
136 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
137 -- and basic operation, developer must manually add parameters and business logic as necessary.
138 --
139 -- End of Comments
140 -- ==============================================================================
141 --
142
143 PROCEDURE Create_Venue_Rates(
144 p_api_version_number IN NUMBER,
145 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146 p_commit IN VARCHAR2 := FND_API.G_FALSE,
147
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151
152 p_venue_rates_rec IN venue_rates_rec_type := g_miss_venue_rates_rec,
153 x_rate_id OUT NOCOPY NUMBER
154 );
155
156 -- ==============================================================================
157 -- Start of Comments
158 -- ==============================================================================
159 -- API Name
160 -- Update_Venue_Rates
161 -- Type
162 -- Public
163 -- Pre-Req
164 --
165 -- Parameters
166 --
167 -- IN
168 -- p_api_version_number IN NUMBER Required
169 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
170 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
171 -- p_venue_rates_rec IN venue_rates_rec_type Required
172 --
173 -- OUT
174 -- x_return_status OUT VARCHAR2
175 -- x_msg_count OUT NUMBER
176 -- x_msg_data OUT VARCHAR2
177 -- Version : Current version 1.0
178 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
179 -- and basic operation, developer must manually add parameters and business logic as necessary.
180 --
181 -- End of Comments
182 -- ==============================================================================
183 --
184
185 PROCEDURE Update_Venue_Rates(
186 p_api_version_number IN NUMBER,
187 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188 p_commit IN VARCHAR2 := FND_API.G_FALSE,
189
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193
194 p_venue_rates_rec IN venue_rates_rec_type,
195 x_object_version_number OUT NOCOPY NUMBER
196 );
197
198 -- ==============================================================================
199 -- Start of Comments
200 -- ==============================================================================
201 -- API Name
202 -- Delete_Venue_Rates
203 -- Type
204 -- Public
205 -- Pre-Req
206 --
207 -- Parameters
208 --
209 -- IN
210 -- p_api_version_number IN NUMBER Required
211 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
212 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
213 -- p_RATE_ID IN NUMBER
214 -- p_object_version_number IN NUMBER Optional Default = NULL
215 --
216 -- OUT
217 -- x_return_status OUT VARCHAR2
218 -- x_msg_count OUT NUMBER
219 -- x_msg_data OUT VARCHAR2
220 -- Version : Current version 1.0
221 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
222 -- and basic operation, developer must manually add parameters and business logic as necessary.
223 --
224 -- End of Comments
225 -- ==============================================================================
226 --
227
228 PROCEDURE Delete_Venue_Rates(
229 p_api_version_number IN NUMBER,
230 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
231 p_commit IN VARCHAR2 := FND_API.G_FALSE,
232 x_return_status OUT NOCOPY VARCHAR2,
233 x_msg_count OUT NOCOPY NUMBER,
234 x_msg_data OUT NOCOPY VARCHAR2,
235 p_rate_id IN NUMBER,
236 p_object_version_number IN NUMBER
237 );
238
239 -- ==============================================================================
240 -- Start of Comments
241 -- ==============================================================================
242 -- API Name
243 -- Lock_Venue_Rates
244 -- Type
245 -- Public
246 -- Pre-Req
247 --
248 -- Parameters
249 --
250 -- IN
251 -- p_api_version_number IN NUMBER Required
252 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
253 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
254 -- p_venue_rates_rec IN venue_rates_rec_type Required
255 --
256 -- OUT
257 -- x_return_status OUT VARCHAR2
258 -- x_msg_count OUT NUMBER
259 -- x_msg_data OUT VARCHAR2
260 -- Version : Current version 1.0
261 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
262 -- and basic operation, developer must manually add parameters and business logic as necessary.
263 --
264 -- End of Comments
265 -- ==============================================================================
266 --
267
268 PROCEDURE Lock_Venue_Rates(
269 p_api_version_number IN NUMBER,
270 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
271 x_return_status OUT NOCOPY VARCHAR2,
272 x_msg_count OUT NOCOPY NUMBER,
273 x_msg_data OUT NOCOPY VARCHAR2,
274
275 p_rate_id IN NUMBER,
276 p_object_version IN NUMBER
277 );
278
279 END AMS_Venue_Rates_PUB;