[Home] [Help]
PACKAGE: APPS.AMS_EVENTOFFER_PVT
Source
1 PACKAGE AMS_EventOffer_PVT AUTHID CURRENT_USER as
2 /*$Header: amsvevos.pls 120.1 2006/04/18 09:27:13 anskumar noship $*/
3
4 TYPE evo_rec_type IS RECORD(
5 EVENT_OFFER_ID NUMBER,
6 LAST_UPDATE_DATE DATE,
7 LAST_UPDATED_BY NUMBER,
8 CREATION_DATE DATE,
9 CREATED_BY NUMBER,
10 LAST_UPDATE_LOGIN NUMBER,
11 OBJECT_VERSION_NUMBER NUMBER,
12 APPLICATION_ID NUMBER,
13 EVENT_HEADER_ID NUMBER,
14 PRIVATE_FLAG VARCHAR2(1),
15 ACTIVE_FLAG VARCHAR2(1),
16 SOURCE_CODE VARCHAR2(30),
17 EVENT_LEVEL VARCHAR2(30),
18 USER_STATUS_ID NUMBER,
19 LAST_STATUS_DATE DATE,
20 SYSTEM_STATUS_CODE VARCHAR2(30),
21 EVENT_TYPE_CODE VARCHAR2(30),
22 EVENT_DELIVERY_METHOD_ID NUMBER,
23 -- note that delv_method_id not being currently used by offers API..
24 -- but copy api will use this id to copy..
25 EVENT_DELIVERY_METHOD_CODE VARCHAR2(30),
26 EVENT_REQUIRED_FLAG VARCHAR2(1),
27 EVENT_LANGUAGE_CODE VARCHAR2(30),
28 EVENT_LOCATION_ID NUMBER,
29 -- adding city,stste,country cols to evo_rec.. from create and update screens, these
30 -- cols would be passed on.. wthese values will be passed to hz_loc api to create loc_id..
31 -- these values will not be stored in event_offers table
32 CITY VARCHAR2(60),
33 STATE VARCHAR2(60),
34 PROVINCE VARCHAR2(60),
35 COUNTRY VARCHAR2(60),
36 OVERFLOW_FLAG VARCHAR2(1),
37 PARTNER_FLAG VARCHAR2(1),
38 EVENT_STANDALONE_FLAG VARCHAR2(1),
39 REG_FROZEN_FLAG VARCHAR2(1),
40 REG_REQUIRED_FLAG VARCHAR2(1),
41 REG_CHARGE_FLAG VARCHAR2(1),
42 REG_INVITED_ONLY_FLAG VARCHAR2(1),
43 REG_WAITLIST_ALLOWED_FLAG VARCHAR2(1),
44 REG_OVERBOOK_ALLOWED_FLAG VARCHAR2(1),
45 PARENT_EVENT_OFFER_ID NUMBER,
46 EVENT_DURATION NUMBER,
47 EVENT_DURATION_UOM_CODE VARCHAR2(3),
48 EVENT_START_DATE DATE,
49 EVENT_START_DATE_TIME DATE,
50 EVENT_END_DATE DATE,
51 EVENT_END_DATE_TIME DATE,
52 REG_START_DATE DATE,
53 REG_START_TIME DATE,
54 REG_END_DATE DATE,
55 REG_END_TIME DATE,
56 REG_MAXIMUM_CAPACITY NUMBER,
57 REG_OVERBOOK_PCT NUMBER,
58 REG_EFFECTIVE_CAPACITY NUMBER,
59 REG_WAITLIST_PCT NUMBER,
60 REG_MINIMUM_CAPACITY NUMBER,
61 REG_MINIMUM_REQ_BY_DATE DATE,
62 INVENTORY_ITEM_ID NUMBER,
63 INVENTORY_ITEM VARCHAR2(1000),
64 ORGANIZATION_ID NUMBER,
65 PRICELIST_HEADER_ID NUMBER,
66 PRICELIST_LINE_ID NUMBER,
67 ORG_ID NUMBER,
68 WAITLIST_ACTION_TYPE_CODE VARCHAR2(30),
69 STREAM_TYPE_CODE VARCHAR2(30),
70 OWNER_USER_ID NUMBER,
71 EVENT_FULL_FLAG VARCHAR2(1),
72 FORECASTED_REVENUE NUMBER,
73 ACTUAL_REVENUE NUMBER,
74 FORECASTED_COST NUMBER,
75 ACTUAL_COST NUMBER,
76 FUND_SOURCE_TYPE_CODE VARCHAR2(30),
77 FUND_SOURCE_ID NUMBER,
78 CERT_CREDIT_TYPE_CODE VARCHAR2(30),
79 CERTIFICATION_CREDITS NUMBER,
80 COORDINATOR_ID NUMBER,
81 PRIORITY_TYPE_CODE VARCHAR2(30),
82 CANCELLATION_REASON_CODE VARCHAR2(30),
83 AUTO_REGISTER_FLAG VARCHAR2(1),
84 EMAIL VARCHAR2(120),
85 PHONE VARCHAR2(25),
86 FUND_AMOUNT_TC NUMBER,
87 FUND_AMOUNT_FC NUMBER,
88 CURRENCY_CODE_TC VARCHAR2(15),
89 CURRENCY_CODE_FC VARCHAR2(15),
90 URL VARCHAR2(4000),
91 TIMEZONE_ID NUMBER,
92 EVENT_VENUE_ID NUMBER,
93 PRICELIST_HEADER_CURRENCY_CODE VARCHAR2(30),
94 PRICELIST_LIST_PRICE NUMBER,
95 INBOUND_SCRIPT_NAME VARCHAR2(240),
96 ATTRIBUTE_CATEGORY VARCHAR2(30),
97 ATTRIBUTE1 VARCHAR2(150),
98 ATTRIBUTE2 VARCHAR2(150),
99 ATTRIBUTE3 VARCHAR2(150),
100 ATTRIBUTE4 VARCHAR2(150),
101 ATTRIBUTE5 VARCHAR2(150),
102 ATTRIBUTE6 VARCHAR2(150),
103 ATTRIBUTE7 VARCHAR2(150),
104 ATTRIBUTE8 VARCHAR2(150),
105 ATTRIBUTE9 VARCHAR2(150),
106 ATTRIBUTE10 VARCHAR2(150),
107 ATTRIBUTE11 VARCHAR2(150),
108 ATTRIBUTE12 VARCHAR2(150),
109 ATTRIBUTE13 VARCHAR2(150),
110 ATTRIBUTE14 VARCHAR2(150),
111 ATTRIBUTE15 VARCHAR2(150),
112 EVENT_OFFER_NAME VARCHAR2(240),
113 EVENT_MKTG_MESSAGE VARCHAR2(4000),
114 DESCRIPTION VARCHAR2(4000),
115 CUSTOM_SETUP_ID NUMBER,
116 COUNTRY_CODE VARCHAR2(30),
117 BUSINESS_UNIT_ID NUMBER,
118 EVENT_CALENDAR VARCHAR2(15),
119 START_PERIOD_NAME VARCHAR2(15),
120 END_PERIOD_NAME VARCHAR2(15),
121 GLOBAL_FLAG VARCHAR2(1),
122 TASK_ID NUMBER, /* Hornet : */
123 --PROGRAM_ID NUMBER, /* Hornet : */
124 PARENT_TYPE VARCHAR2(30), /* Hornet : */
125 PARENT_ID NUMBER /* Hornet : */
126 ,CREATE_ATTENDANT_LEAD_FLAG VARCHAR2(1) /*hornet*/
127 ,CREATE_REGISTRANT_LEAD_FLAG VARCHAR2(1) /*hornet*/
128 ,EVENT_OBJECT_TYPE VARCHAR2(30) /* Hornet : added by gdeodhar */
129 ,REG_TIMEZONE_ID NUMBER /* HORnet */
130 ,event_password VARCHAR2(30) /* Hornet : added for imeeting integration*/
131 ,record_event_flag VARCHAR2(1) /* Hornet : added for imeeting integration*/
132 ,allow_register_in_middle_flag VARCHAR2(1) /* Hornet : added for imeeting integration*/
133 ,publish_attendees_flag VARCHAR2(1) /* Hornet : added for imeeting integration*/
134 ,direct_join_flag VARCHAR2(1) /* Hornet : added for imeeting integration*/
135 ,event_notification_method VARCHAR2(30) /* Hornet : added for imeeting integration*/
136 ,actual_start_time DATE /* Hornet : added for imeeting integration*/
137 ,actual_end_time DATE /* Hornet : added for imeeting integration*/
138 ,SERVER_ID NUMBER /* Hornet : added for imeeting integration*/
139 ,owner_fnd_user_id NUMBER /* Hornet : added for imeeting integration aug13*/
140 ,meeting_dial_in_info VARCHAR2(4000) /* Hornet : added for imeeting integration aug13*/
141 ,meeting_email_subject VARCHAR2(4000) /* Hornet : added for imeeting integration aug13*/
142 ,meeting_schedule_type VARCHAR2(30) /* Hornet : added for imeeting integration aug13*/
143 ,meeting_status VARCHAR2(30) /* Hornet : added for imeeting integration aug13*/
144 ,meeting_misc_info VARCHAR2(4000) /* Hornet : added for imeeting integration aug13*/
145 ,publish_flag VARCHAR2(1) /* Hornet : added for imeeting integration aug13*/
146 ,meeting_encryption_key_code VARCHAR2(150) /* Hornet : added for imeeting integration aug13*/
147 ,number_of_attendees NUMBER /* Hornet : added for imeeting integration aug13*/
148 ,EVENT_PURPOSE_CODE VARCHAR2(30) /* Hornet */
149 );
150
151 ---------------------------------------------------------------------
152 -- PROCEDURE
153 -- create_event_offer
154 --
155 -- PURPOSE
156 -- Create a new event offer or agenda item for the event offer.
157 --
158 -- PARAMETERS
159 -- p_evo_rec: the new record to be inserted
160 -- x_evo_id: return the event_offer_id of the new event offer
161 --
162 -- NOTES
163 -- 1. object_version_number will be set to 1.
164 -- 2. If event_offer_id is passed in, the uniqueness will be checked.
165 -- Raise exception in case of duplicates.
166 -- 3. If event_offer_id is not passed in, generate a unique one from
167 -- the sequence.
168 -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
169 -- Raise exception for invalid flag.
170 -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
171 -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
172 ---------------------------------------------------------------------
173
174 PROCEDURE create_event_offer(
175 p_api_version IN NUMBER,
176 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
177 p_commit IN VARCHAR2 := FND_API.g_false,
178 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
179
180 p_evo_rec IN evo_rec_type,
181
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185
186 x_evo_id OUT NOCOPY NUMBER
187 );
188
189
190 --------------------------------------------------------------------
191 -- PROCEDURE
192 -- delete_event_offer
193 --
194 -- PURPOSE
195 -- Delete an event offer.
196 --
197 -- PARAMETERS
198 -- p_evo_id: the event_offer_id
199 -- p_object_version: the object_version_number
200 --
201 -- NOTES
202 -- 1. Raise exception if the object_version_number doesn't match.
203 --------------------------------------------------------------------
204 PROCEDURE delete_event_offer(
205 p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
207 p_commit IN VARCHAR2 := FND_API.g_false,
208
209 p_evo_id IN NUMBER,
210 p_object_version IN NUMBER,
211
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2
215 );
216
217
218 -------------------------------------------------------------------
219 -- PROCEDURE
220 -- lock_event_offer
221 --
222 -- PURPOSE
223 -- Lock the event offer.
224 --
225 -- PARAMETERS
226 -- p_evo_id: the event_offer_id
227 -- p_object_version: the object_version_number
228 --
229 -- NOTES
230 -- 1. Raise exception if the object_version_number doesn't match.
231 --------------------------------------------------------------------
232 PROCEDURE lock_event_offer(
233 p_api_version IN NUMBER,
234 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
235
236 p_evo_id IN NUMBER,
237 p_object_version IN NUMBER,
238
239 x_return_status OUT NOCOPY VARCHAR2,
240 x_msg_count OUT NOCOPY NUMBER,
241 x_msg_data OUT NOCOPY VARCHAR2
242 );
243
244
245 ---------------------------------------------------------------------
246 -- PROCEDURE
247 -- update_event_offer
248 --
249 -- PURPOSE
250 -- Update the event offer.
251 --
252 -- PARAMETERS
253 -- p_evo_rec: the record with new items
254 --
255 -- NOTES
256 -- 1. Raise exception if the object_version_number doesn't match.
257 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
258 -- that column won't be updated.
259 ----------------------------------------------------------------------
260 PROCEDURE update_event_offer(
261 p_api_version IN NUMBER,
262 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
263 p_commit IN VARCHAR2 := FND_API.g_false,
264 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
265
266 p_evo_rec IN evo_rec_type,
267
268 x_return_status OUT NOCOPY VARCHAR2,
269 x_msg_count OUT NOCOPY NUMBER,
270 x_msg_data OUT NOCOPY VARCHAR2
271 );
272
273
274 ---------------------------------------------------------------------
275 -- PROCEDURE
276 -- validate_event_offer
277 --
278 -- PURPOSE
279 -- Validate the event offer record.
280 --
281 -- PARAMETERS
282 -- p_evo_rec: the event offer record to be validated
283 --
284 -- NOTES
285 -- 1. p_evo_rec should be the complete event offer record. There
286 -- should not be any FND_API.g_miss_char/num/date in it.
287 ----------------------------------------------------------------------
288 PROCEDURE validate_event_offer(
289 p_api_version IN NUMBER,
290 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
291 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
292
293 p_evo_rec IN evo_rec_type,
294
295 x_return_status OUT NOCOPY VARCHAR2,
296 x_msg_count OUT NOCOPY NUMBER,
297 x_msg_data OUT NOCOPY VARCHAR2
298 );
299
300
301 ---------------------------------------------------------------------
302 -- PROCEDURE
303 -- check_evo_items
304 --
305 -- PURPOSE
306 -- Perform the item level checking including unique keys,
307 -- required columns, foreign keys, domain constraints.
308 --
309 -- PARAMETERS
310 -- p_evo_rec: the record to be validated
311 -- p_validation_mode: JTF_PLSQL_API.g_create/g_update
312 ---------------------------------------------------------------------
313 PROCEDURE check_evo_items(
314 p_evo_rec IN evo_rec_type,
315 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
316 x_return_status OUT NOCOPY VARCHAR2
317 );
318
319
320 ---------------------------------------------------------------------
321 -- PROCEDURE
322 -- check_evo_record
323 --
324 -- PURPOSE
325 -- Check the record level business rules.
326 --
327 -- PARAMETERS
328 -- p_evo_rec: the record to be validated; may contain attributes
329 -- as FND_API.g_miss_char/num/date
330 -- p_complete_rec: the complete record after all "g_miss" items
331 -- have been replaced by current database values
332 ---------------------------------------------------------------------
333 PROCEDURE check_evo_record(
334 p_evo_rec IN evo_rec_type,
335 p_complete_rec IN evo_rec_type := NULL,
336 x_return_status OUT NOCOPY VARCHAR2
337 );
338
339
340 ---------------------------------------------------------------------
341 -- PROCEDURE
342 -- init_evo_rec
343 --
344 -- PURPOSE
345 -- Initialize all attributes to be FND_API.g_miss_char/num/date.
346 ---------------------------------------------------------------------
347 PROCEDURE init_evo_rec(
348 x_evo_rec OUT NOCOPY evo_rec_type
349 );
350
351
352 ---------------------------------------------------------------------
353 -- PROCEDURE
354 -- complete_evo_rec
355 --
356 -- PURPOSE
357 -- For update_event_offer, some attributes may be passed in as
358 -- FND_API.g_miss_char/num/date if the user doesn't want to
359 -- update those attributes. This procedure will replace the
360 -- "g_miss" attributes with current database values.
361 --
362 -- PARAMETERS
363 -- p_evo_rec: the record which may contain attributes as
364 -- FND_API.g_miss_char/num/date
365 -- x_complete_rec: the complete record after all "g_miss" items
366 -- have been replaced by current database values
367 ---------------------------------------------------------------------
368 PROCEDURE complete_evo_rec(
369 p_evo_rec IN evo_rec_type,
370 x_complete_rec OUT NOCOPY evo_rec_type
371 );
372
373 PROCEDURE Unit_Test_Insert;
374
375 PROCEDURE fulfill_event_offer(
376 p_evo_rec IN evo_rec_type,
377 x_return_status OUT NOCOPY VARCHAR2
378 );
379
380 END AMS_Eventoffer_PVT;