[Home] [Help]
PACKAGE: APPS.AMS_VENUE_PVT
Source
1 PACKAGE AMS_Venue_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvvnus.pls 120.1 2005/08/12 09:00:34 appldev ship $ */
3 -----------------------------------------------------------
4 -- PACKAGE
5 -- AMS_Venue_PVT
6 --
7 -- PURPOSE
8 -- This package is a Private API for managing Venue information in
9 -- AMS. It contains specification for pl/sql records and tables
10 --
11 -- AMS_VENUES_VL:
12 -- Create_Venue (see below for specification)
13 -- Update_Venue (see below for specification)
14 -- Delete_Venue (see below for specification)
15 -- Lock_Venue (see below for specification)
16 -- Validate_Venue (see below for specification)
17 --
18 -- Check_Venue_Items (see below for specification)
19 -- Check_Venue_Record (see below for specification)
20 -- Init_Venue_Rec
21 -- Complete_Venue_Rec
22 --
23
24 -- NOTES
25 --
26 --
27 -- HISTORY
28 -- 10-Dec-1999 rvaka Modified
29 -- 19-APR-2002 dcastlem TCA integration
30 -----------------------------------------------------------
31
32 -------------------------------------
33 ----- VENUE -----
34 -------------------------------------
35 -- Record for AMS_VENUE_VL
36 TYPE Venue_Rec_Type IS RECORD (
37 venue_id NUMBER,
38 custom_setup_id NUMBER,
39 last_update_date DATE,
40 last_updated_by NUMBER,
41 creation_date DATE,
42 created_by NUMBER,
43 last_update_login NUMBER,
44 object_version_number NUMBER,
45 venue_type_code VARCHAR2(30),
46 venue_type_name VARCHAR2(80),
47 direct_phone_flag VARCHAR2(1),
48 internal_flag VARCHAR2(1),
49 enabled_flag VARCHAR2(1),
50 rating_code VARCHAR2(30),
51 telecom_code VARCHAR2(30),
52 rating_name varchar2(80),
53 capacity NUMBER,
54 area_size NUMBER,
55 area_size_uom_code VARCHAR2(3),
56 ceiling_height NUMBER,
57 ceiling_height_uom_code VARCHAR2(3),
58 usage_cost NUMBER,
59 usage_cost_uom_code VARCHAR2(30),
60 usage_cost_currency_code VARCHAR2(15),
61 parent_venue_id NUMBER,
62 location_id NUMBER,
63 directions VARCHAR2(4000),
64 venue_code VARCHAR2(30),
65 object_type VARCHAR2(30),
66 attribute_category VARCHAR2(30),
67 attribute1 VARCHAR2(150),
68 attribute2 VARCHAR2(150),
69 attribute3 VARCHAR2(150),
70 attribute4 VARCHAR2(150),
71 attribute5 VARCHAR2(150),
72 attribute6 VARCHAR2(150),
73 attribute7 VARCHAR2(150),
74 attribute8 VARCHAR2(150),
75 attribute9 VARCHAR2(150),
76 attribute10 VARCHAR2(150),
77 attribute11 VARCHAR2(150),
78 attribute12 VARCHAR2(150),
79 attribute13 VARCHAR2(150),
80 attribute14 VARCHAR2(150),
81 attribute15 VARCHAR2(150),
82 venue_name VARCHAR2(120),
83 party_id NUMBER,
84 description VARCHAR2(4000),
85 ADDRESS1 VARCHAR2(240),
86 ADDRESS2 VARCHAR2(240),
87 ADDRESS3 VARCHAR2(240),
88 ADDRESS4 VARCHAR2(240),
89 COUNTRY_CODE VARCHAR2(80),
90 COUNTRY VARCHAR2(60),
91 CITY VARCHAR2(60),
92 POSTAL_CODE VARCHAR2(60),
93 STATE VARCHAR2(60),
94 PROVINCE VARCHAR2(60),
95 COUNTY VARCHAR2(60),
96 salesforce_id NUMBER,
97 sales_group_id NUMBER,
98 person_id NUMBER
99 );
100
101
102 --------------------------------------------------------------------
103 -- PROCEDURE
104 -- Create_Venue
105 --
106 -- PURPOSE
107 -- Create Venue entry.
108 --
109 -- PARAMETERS
110 -- p_venue_rec: the record representing AMS_VENUE_VL view..
111 -- x_venue_id: the venue_id.
112 --
113 -- NOTES
114 -- 1. object_version_number will be set to 1.
115 -- 2. If venue_id is passed in, the uniqueness will be checked.
116 -- Raise exception in case of duplicates.
117 -- 3. If a flag column is passed in, check if it is 'Y' or 'N'
118 -- Raise exception for invalid flag.
119 -- 5. If a flag column is not passed in, default it to 'Y' or 'N'
120 -- 6. Please don't pass in any FND_API.g_miss_char/num/date.
121 --------------------------------------------------------------------
122 PROCEDURE Create_Venue (
123 p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
125 p_commit IN VARCHAR2 := FND_API.g_false,
126 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
127
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2,
131
132 p_venue_rec IN Venue_Rec_Type,
133 x_venue_id OUT NOCOPY NUMBER
134 );
135
136 --------------------------------------------------------------------
137 -- PROCEDURE
138 -- Create_Room
139 --
140 -- PURPOSE
141 -- Create ROOM entry.
142 --
143 -- PARAMETERS
144 -- p_venue_rec: the record representing AMS_VENUE_VL view..
145 -- x_venue_id: the venue_id.
146 --
147 -- NOTES
148 -- 1. object_version_number will be set to 1.
149 -- 2. If venue_id is passed in, the uniqueness will be checked.
150 -- Raise exception in case of duplicates.
151 -- 3. If a flag column is passed in, check if it is 'Y' or 'N'
152 -- Raise exception for invalid flag.
153 -- 4. If a flag column is not passed in, default it to 'Y' or 'N'
154 -- 5. Please don't pass in any FND_API.g_miss_char/num/date.
155 --------------------------------------------------------------------
156 PROCEDURE Create_Room (
157 p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
159 p_commit IN VARCHAR2 := FND_API.g_false,
160 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
161
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2,
165
166 p_venue_rec IN Venue_Rec_Type,
167 x_venue_id OUT NOCOPY NUMBER
168 );
169
170
171 --------------------------------------------------------------------
172 -- PROCEDURE
173 -- Update_Venue
174 --
175 -- PURPOSE
176 -- Update a venue entry.
177 --
178 -- PARAMETERS
179 -- p_venue_rec: the record representing AMS_VENUE_VL (without the ROW_ID column).
180 --
181 -- NOTES
182 -- 1. Raise exception if the object_version_number doesn't match.
183 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
184 -- that column won't be updated.
185 --------------------------------------------------------------------
186 PROCEDURE Update_Venue (
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
189 p_commit IN VARCHAR2 := FND_API.g_false,
190 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
191
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2,
195
196 p_venue_rec IN Venue_Rec_Type
197 );
198
199 --------------------------------------------------------------------
200 -- PROCEDURE
201 -- Update_Room
202 --
203 -- PURPOSE
204 -- Update a room entry.
205 --
206 -- PARAMETERS
207 -- p_venue_rec: the record representing AMS_VENUE_VL (without the ROW_ID column).
208 --
209 -- NOTES
210 -- 1. Raise exception if the object_version_number doesn't match.
211 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
212 -- that column won't be updated.
213 --------------------------------------------------------------------
214 PROCEDURE Update_Room (
215 p_api_version IN NUMBER,
216 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
217 p_commit IN VARCHAR2 := FND_API.g_false,
218 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
219
220 x_return_status OUT NOCOPY VARCHAR2,
221 x_msg_count OUT NOCOPY NUMBER,
222 x_msg_data OUT NOCOPY VARCHAR2,
223
224 p_venue_rec IN Venue_Rec_Type
225 );
226
227
228 --------------------------------------------------------------------
229 -- PROCEDURE
230 -- Delete_Venue
231 --
232 -- PURPOSE
233 -- Delete a venue entry.
234 --
235 -- PARAMETERS
236 -- p_venue_id: the venue_id
237 -- p_object_version: the object_version_number
238 --
239 -- ISSUES
240 --
241 -- NOTES
242 -- 1. Raise exception if the object_version_number doesn't match.
243 --------------------------------------------------------------------
244 PROCEDURE Delete_Venue (
245 p_api_version IN NUMBER,
246 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
247 p_commit IN VARCHAR2 := FND_API.g_false,
248 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
249
250 x_return_status OUT NOCOPY VARCHAR2,
251 x_msg_count OUT NOCOPY NUMBER,
252 x_msg_data OUT NOCOPY VARCHAR2,
253
254 p_venue_id IN NUMBER,
255 p_object_version IN NUMBER
256 );
257
258 --------------------------------------------------------------------
259 -- PROCEDURE
260 -- Lock_Venue
261 --
262 -- PURPOSE
263 -- Lock a venue entry.
264 --
265 -- PARAMETERS
266 -- p_venue_id: the venue id
267 -- p_object_version: the object_version_number
268 --
269 -- ISSUES
270 --
271 -- NOTES
272 -- 1. Raise exception if the object_version_number doesn't match.
273 --------------------------------------------------------------------
274 PROCEDURE Lock_venue (
275 p_api_version IN NUMBER,
276 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
277 p_commit IN VARCHAR2 := FND_API.g_false,
278 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
279
280 x_return_status OUT NOCOPY VARCHAR2,
281 x_msg_count OUT NOCOPY NUMBER,
282 x_msg_data OUT NOCOPY VARCHAR2,
283
284 p_venue_id IN NUMBER,
285 p_object_version IN NUMBER
286 );
287
288 --------------------------------------------------------------------
289 -- PROCEDURE
290 -- Validate_Venue
291 --
292 -- PURPOSE
293 -- Validate a Venue entry.
294 --
295 -- PARAMETERS
296 -- p_Venue_rec: the record representing AMS_Venue_VL (without ROW_ID).
297 --
298 -- NOTES
299 -- 1. p_Venue_rec should be the complete Venue record. There
300 -- should not be any FND_API.g_miss_char/num/date in it.
301 -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
302 -- an exception, as those values are not handled.
303 --------------------------------------------------------------------
304 PROCEDURE Validate_Venue (
305 p_api_version IN NUMBER,
306 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
307 p_commit IN VARCHAR2 := FND_API.g_false,
308 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
309
310 x_return_status OUT NOCOPY VARCHAR2,
311 x_msg_count OUT NOCOPY NUMBER,
312 x_msg_data OUT NOCOPY VARCHAR2,
313
314 p_Venue_rec IN Venue_Rec_Type,
315 p_object_type IN VARCHAR2
316 );
317
318 ---------------------------------------------------------------------
319 -- PROCEDURE
320 -- Check_Venue_Items
321 --
322 -- PURPOSE
323 -- Perform the item level checking including unique keys,
324 -- required columns, foreign keys, domain constraints.
325 --
326 -- PARAMETERS
327 -- p_Venue_rec: the record to be validated
328 -- p_validation_mode: JTF_PLSQL_API.g_create/g_update
329 ---------------------------------------------------------------------
330 PROCEDURE Check_Venue_Items (
331 p_Venue_rec IN Venue_Rec_Type,
332 p_object_type IN VARCHAR2,
333 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
334 x_return_status OUT NOCOPY VARCHAR2
335 );
336
337 ---------------------------------------------------------------------
338 -- PROCEDURE
339 -- Check_Venue_Record
340 --
341 -- PURPOSE
342 -- Check the record level business rules.
343 --
344 -- PARAMETERS
345 -- p_Venue_rec: the record to be validated; may contain attributes
346 -- as FND_API.g_miss_char/num/date
347 -- p_complete_rec: the complete record after all "g_miss" items
348 -- have been replaced by current database values
349 ---------------------------------------------------------------------
350 PROCEDURE Check_Venue_Record (
351 p_Venue_rec IN Venue_Rec_Type,
352 p_complete_rec IN Venue_Rec_Type := NULL,
353 x_return_status OUT NOCOPY VARCHAR2
354 );
355
356 ---------------------------------------------------------------------
357 -- PROCEDURE
358 -- Init_Venue_Rec
359 --
360 -- PURPOSE
361 -- Initialize all attributes to be FND_API.g_miss_char/num/date.
362 ---------------------------------------------------------------------
363 PROCEDURE Init_Venue_Rec (
364 x_Venue_rec OUT NOCOPY Venue_Rec_Type
365 );
366
367 ---------------------------------------------------------------------
368 -- PROCEDURE
369 -- Complete_Venue_Rec
370 --
371 -- PURPOSE
372 -- For Update_Venue, some attributes may be passed in as
373 -- FND_API.g_miss_char/num/date if the user doesn't want to
374 -- update those attributes. This procedure will replace the
375 -- "g_miss" attributes with current database values.
376 --
377 -- PARAMETERS
378 -- p_Venue_rec: the record which may contain attributes as
379 -- FND_API.g_miss_char/num/date
380 -- x_complete_rec: the complete record after all "g_miss" items
381 -- have been replaced by current database values
382 ---------------------------------------------------------------------
383 PROCEDURE Complete_Venue_Rec (
384 p_Venue_rec IN Venue_Rec_Type,
385 x_complete_rec OUT NOCOPY Venue_Rec_Type
386 );
387
388
389 ---------------------------------------------------------------------
390 -- PROCEDURE
391 -- Create_Location
392 --
393 -- PURPOSE
394 -- Create the location info in HZ_LOCATIONS using call to
395 -- hz_location_pub.create_location
396 --
397 -- PARAMETERS
398 -- p_Venue_loc_rec: the record which may contain attributes as
399 -- FND_API.g_miss_char/num/date
400 -- HZ_PARTY_PUB.G_MISS_CONTENT_SOURCE_TYPE BugFix sikalyan TCAV2 Uptake
401 ---------------------------------------------------------------------
402 TYPE Location_Rec_Type IS RECORD
403 (
404 LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
405 ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
406 ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
407 ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
408 ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
409 COUNTRY_CODE VARCHAR2(80) := FND_API.G_MISS_CHAR,
410 COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
411 CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
412 POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
413 STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
414 PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
415 COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
416 ORIG_SYSTEM_REFERENCE VARCHAR2(240):= FND_API.G_MISS_CHAR,
417 CONTENT_SOURCE_TYPE VARCHAR2(30):= HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE
418
419 );
420
421
422
423 END AMS_Venue_PVT;