[Home] [Help]
PACKAGE: APPS.AMS_VENUE_RATES_PVT
Source
1 PACKAGE AMS_Venue_Rates_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvvrts.pls 115.6 2002/12/24 18:59:48 mukumar ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Venue_Rates_PVT
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 attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
85 rate_code 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
105 g_miss_venue_rates_rec venue_rates_rec_type;
106 TYPE venue_rates_tbl_type IS TABLE OF venue_rates_rec_type INDEX BY BINARY_INTEGER;
107 g_miss_venue_rates_tbl venue_rates_tbl_type;
108
109 -- ==============================================================================
110 -- Start of Comments
111 -- ==============================================================================
112 -- API Name
113 -- Create_Venue_Rates
114 -- Type
115 -- Private
116 -- Pre-Req
117 --
118 -- Parameters
119 --
120 -- IN
121 -- p_api_version_number IN NUMBER Required
122 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
123 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
124 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
125 -- p_venue_rates_rec IN venue_rates_rec_type Required
126 --
127 -- OUT
128 -- x_return_status OUT VARCHAR2
129 -- x_msg_count OUT NUMBER
130 -- x_msg_data OUT VARCHAR2
131 -- Version : Current version 1.0
132 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
133 -- and basic operation, developer must manually add parameters and business logic as necessary.
134 --
135 -- End of Comments
136 -- ==============================================================================
137 --
138
139 PROCEDURE Create_Venue_Rates(
140 p_api_version_number IN NUMBER,
141 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142 p_commit IN VARCHAR2 := FND_API.G_FALSE,
143 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
144
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148
149 p_venue_rates_rec IN venue_rates_rec_type := g_miss_venue_rates_rec,
150 x_rate_id OUT NOCOPY NUMBER
151 );
152
153 -- ==============================================================================
154 -- Start of Comments
155 -- ==============================================================================
156 -- API Name
157 -- Update_Venue_Rates
158 -- Type
159 -- Private
160 -- Pre-Req
161 --
162 -- Parameters
163 --
164 -- IN
165 -- p_api_version_number IN NUMBER Required
166 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
167 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
168 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
169 -- p_venue_rates_rec IN venue_rates_rec_type Required
170 --
171 -- OUT
172 -- x_return_status OUT VARCHAR2
173 -- x_msg_count OUT NUMBER
174 -- x_msg_data OUT VARCHAR2
175 -- Version : Current version 1.0
176 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
177 -- and basic operation, developer must manually add parameters and business logic as necessary.
178 --
179 -- End of Comments
180 -- ==============================================================================
181 --
182
183 PROCEDURE Update_Venue_Rates(
184 p_api_version_number IN NUMBER,
185 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186 p_commit IN VARCHAR2 := FND_API.G_FALSE,
187 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188
189 x_return_status OUT NOCOPY VARCHAR2,
190 x_msg_count OUT NOCOPY NUMBER,
191 x_msg_data OUT NOCOPY VARCHAR2,
192
193 p_venue_rates_rec IN venue_rates_rec_type,
194 x_object_version_number OUT NOCOPY NUMBER
195 );
196
197 -- ==============================================================================
198 -- Start of Comments
199 -- ==============================================================================
200 -- API Name
201 -- Delete_Venue_Rates
202 -- Type
203 -- Private
204 -- Pre-Req
205 --
206 -- Parameters
207 --
208 -- IN
209 -- p_api_version_number IN NUMBER Required
210 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
211 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
212 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
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 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
233 x_return_status OUT NOCOPY VARCHAR2,
234 x_msg_count OUT NOCOPY NUMBER,
235 x_msg_data OUT NOCOPY VARCHAR2,
236 p_rate_id IN NUMBER,
237 p_object_version_number IN NUMBER
238 );
239
240 -- ==============================================================================
241 -- Start of Comments
242 -- ==============================================================================
243 -- API Name
244 -- Lock_Venue_Rates
245 -- Type
246 -- Private
247 -- Pre-Req
248 --
249 -- Parameters
250 --
251 -- IN
252 -- p_api_version_number IN NUMBER Required
253 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
254 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
255 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
256 -- p_venue_rates_rec IN venue_rates_rec_type Required
257 --
258 -- OUT
259 -- x_return_status OUT VARCHAR2
260 -- x_msg_count OUT NUMBER
261 -- x_msg_data OUT VARCHAR2
262 -- Version : Current version 1.0
263 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
264 -- and basic operation, developer must manually add parameters and business logic as necessary.
265 --
266 -- End of Comments
267 -- ==============================================================================
268 --
269
270 PROCEDURE Lock_Venue_Rates(
271 p_api_version_number IN NUMBER,
272 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
273
274 x_return_status OUT NOCOPY VARCHAR2,
275 x_msg_count OUT NOCOPY NUMBER,
276 x_msg_data OUT NOCOPY VARCHAR2,
277
278 p_rate_id IN NUMBER,
279 p_object_version IN NUMBER
280 );
281
282
283 -- Start of Comments
284 --
285 -- validation procedures
286 --
287 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
288 -- For create: G_CREATE, for update: G_UPDATE
289 -- Note: 1. This is automated generated item level validation procedure.
290 -- The actual validation detail is needed to be added.
291 -- 2. We can also validate table instead of record. There will be an option for user to choose.
292 -- End of Comments
293
294 PROCEDURE Validate_venue_rates(
295 p_api_version_number IN NUMBER,
296 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
297 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
298 p_venue_rates_rec IN venue_rates_rec_type,
299 p_validation_mode IN VARCHAR2,
300 x_return_status OUT NOCOPY VARCHAR2,
301 x_msg_count OUT NOCOPY NUMBER,
302 x_msg_data OUT NOCOPY VARCHAR2
303 );
304
305 -- Start of Comments
306 --
307 -- validation procedures
308 --
309 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
310 -- For create: G_CREATE, for update: G_UPDATE
311 -- Note: 1. This is automated generated item level validation procedure.
312 -- The actual validation detail is needed to be added.
313 -- 2. Validate the unique keys, lookups here
314 -- End of Comments
315
316 PROCEDURE Check_venue_rates_Items (
317 P_venue_rates_rec IN venue_rates_rec_type,
318 p_validation_mode IN VARCHAR2,
319 x_return_status OUT NOCOPY VARCHAR2
320 );
321
322 -- Start of Comments
323 --
324 -- Record level validation procedures
325 --
326 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
327 -- For create: G_CREATE, for update: G_UPDATE
328 -- Note: 1. This is automated generated item level validation procedure.
329 -- The actual validation detail is needed to be added.
330 -- 2. Developer can manually added inter-field level validation.
331 -- End of Comments
332
333 PROCEDURE Validate_venue_rates_rec(
334 p_api_version_number IN NUMBER,
335 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
336 x_return_status OUT NOCOPY VARCHAR2,
337 x_msg_count OUT NOCOPY NUMBER,
338 x_msg_data OUT NOCOPY VARCHAR2,
339 p_venue_rates_rec IN venue_rates_rec_type
340 );
341 END AMS_Venue_Rates_PVT;