1 PACKAGE AMS_EvtRegs_PVT AUTHID CURRENT_USER as
2 /*$Header: amsvregs.pls 115.33 2002/11/22 23:37:27 dbiswas ship $*/
3 -- Start of Comments
4 -- Package name : AMS_EvtRegs_PVT
5 -- Purpose : This package is a Private API for managing event registrations
6 -- Procedures :
7 -- create_evtregs
8 -- update_evtregs
9 -- delete_evtregs
10 -- lock_evtregs
11 -- validate_evtregs
12 -- History : created sugupta 10/15/99
13 -- 01-MAR-2002 dcastlem Implemented invite list validation and
14 -- automatic registration for capacity changes
15 -- 12-MAR-2002 dcastlem Added support for general Public API
16 -- (AMS_Registrants_PUB)
17 -- 05-APR-2002 dcastlem Refined waitlist code
18 -- 08-APR-2002 dcastlem Copied write_interaction from AMS_ScheduleRules_PVT
19 -- NOTE :
20 -- End of Comments
21
22 -- *******************************************************
23 -- Start of Comments
24 -- -------------------------------------------------------
25 -- Record name:evt_regs_Rec_Type
26 -- -------------------------------------------------------
27 -- End of Comments
28
29 TYPE evt_regs_Rec_Type
30 IS RECORD
31 (
32 EVENT_REGISTRATION_ID NUMBER,
33 LAST_UPDATE_DATE DATE,
34 LAST_UPDATED_BY NUMBER ,
35 CREATION_DATE DATE,
36 CREATED_BY NUMBER,
37 LAST_UPDATE_LOGIN NUMBER,
38 OBJECT_VERSION_NUMBER NUMBER,
39 EVENT_OFFER_ID NUMBER,
40 APPLICATION_ID NUMBER,
41 ACTIVE_FLAG VARCHAR2(1),
42 OWNER_USER_ID NUMBER,
43 SYSTEM_STATUS_CODE VARCHAR2(30),
44 DATE_REGISTRATION_PLACED DATE,
45 USER_STATUS_ID NUMBER,
46 LAST_REG_STATUS_DATE DATE,
47 REG_SOURCE_TYPE_CODE VARCHAR2(30),
48 REGISTRATION_SOURCE_ID NUMBER,
49 CONFIRMATION_CODE VARCHAR2(30),
50 SOURCE_CODE VARCHAR2(30),
51 REGISTRATION_GROUP_ID NUMBER,
52 REGISTRANT_PARTY_ID NUMBER,
53 REGISTRANT_CONTACT_ID NUMBER,
54 REGISTRANT_ACCOUNT_ID NUMBER,
55 ATTENDANT_PARTY_ID NUMBER,
56 ATTENDANT_CONTACT_ID NUMBER,
57 ATTENDANT_ACCOUNT_ID NUMBER,
58 ORIGINAL_REGISTRANT_CONTACT_ID NUMBER,
59 PROSPECT_FLAG VARCHAR2(1),
60 ATTENDED_FLAG VARCHAR2(1),
61 CONFIRMED_FLAG VARCHAR2(1),
62 EVALUATED_FLAG VARCHAR2(1),
63 WAITLISTED_FLAG VARCHAR2(1),
64 ATTENDANCE_RESULT_CODE VARCHAR2(4000),
65 WAITLISTED_PRIORITY NUMBER,
66 TARGET_LIST_ID NUMBER,
67 INBOUND_MEDIA_ID NUMBER,
68 INBOUND_CHANNEL_ID NUMBER,
69 CANCELLATION_CODE VARCHAR2(30),
70 CANCELLATION_REASON_CODE VARCHAR2(30),
71 ATTENDANCE_FAILURE_REASON VARCHAR2(30),
72 ATTENDANT_LANGUAGE VARCHAR2(4),
73 SALESREP_ID NUMBER,
74 ORDER_HEADER_ID NUMBER,
75 ORDER_LINE_ID NUMBER,
76 DESCRIPTION VARCHAR2(4000),
77 MAX_ATTENDEE_OVERRIDE_FLAG VARCHAR2(1),
78 INVITE_ONLY_OVERRIDE_FLAG VARCHAR2(1),
79 PAYMENT_STATUS_CODE VARCHAR2(30),
80 AUTO_REGISTER_FLAG VARCHAR2(1),
81 ATTRIBUTE_CATEGORY VARCHAR2(30),
82 ATTRIBUTE1 VARCHAR2(150),
83 ATTRIBUTE2 VARCHAR2(150),
84 ATTRIBUTE3 VARCHAR2(150),
85 ATTRIBUTE4 VARCHAR2(150),
86 ATTRIBUTE5 VARCHAR2(150),
87 ATTRIBUTE6 VARCHAR2(150),
88 ATTRIBUTE7 VARCHAR2(150),
89 ATTRIBUTE8 VARCHAR2(150),
90 ATTRIBUTE9 VARCHAR2(150),
91 ATTRIBUTE10 VARCHAR2(150),
92 ATTRIBUTE11 VARCHAR2(150),
93 ATTRIBUTE12 VARCHAR2(150),
94 ATTRIBUTE13 VARCHAR2(150),
95 ATTRIBUTE14 VARCHAR2(150),
96 ATTRIBUTE15 VARCHAR2(150),
97 attendee_role_type VARCHAR2(30), -- Hornet : added for imeeting integration
98 notification_type VARCHAR2(30), -- Hornet : added for imeeting integration
99 last_notified_time DATE, -- Hornet : added for imeeting integration
100 EVENT_JOIN_TIME DATE, -- Hornet : added for imeeting integration
101 EVENT_EXIT_TIME DATE, -- Hornet : added for imeeting integration*/
102 MEETING_ENCRYPTION_KEY_CODE VARCHAR2(150) -- Hornet : added for imeeting integration
103 );
104
105 /* murali jun17 2001
106 I am commenting following function , because the generating rosetta wrapper does not dupport function
107 returing record type. The comment will break the support given to tele sales. This version does not
108 support tele sales*/
109 -- FUNCTION GET_Reg_Rec RETURN AMS_EvtRegs_PVT.evt_regs_Rec_Type;
110
111 FUNCTION check_reg_availability( p_effective_capacity IN NUMBER
112 , p_event_offer_id IN NUMBER
113 )
114 RETURN NUMBER;
115
116 FUNCTION check_number_registered(p_event_offer_id IN NUMBER)
117 RETURN NUMBER;
118
119 FUNCTION check_number_waitlisted(p_event_offer_id IN NUMBER)
120 RETURN NUMBER;
121
122 -----------------------------------------------------------------------------------
123 -- API Name : Create_evtregs
124 -- Type : Private
125 -- Pre-Req :
126 -- Parameters:
127 -- IN
128 -- p_api_version_number IN NUMBER Required
129 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132 -- P_evt_regs_Rec IN evt_regs_Rec_Type Required
133 -- p_system_status_code IN VARCHAR2 Required
134 -- OUT
135 -- x_EVENT_REGISTRATION_ID OUT NUMBER
136 -- x_return_status OUT VARCHAR2
137 -- x_msg_count OUT NUMBER
138 -- x_msg_data OUT VARCHAR2
139 -- NOTES
140 -- 1. object_version_number will be set to 1.
141 -- 2. If EVENT_REGISTRATION_ID is passed in, the uniqueness will be checked.
142 -- Raise exception in case of duplicates.
143 -- 3. If EVENT_REGISTRATION_ID is not passed in, generate a unique one from
144 -- the sequence.
145 -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
146 -- Raise exception for invalid flag.
147 -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
148 -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
149 -----------------------------------------------------------------------------------
150 PROCEDURE Create_evtregs( P_Api_Version_Number IN NUMBER
151 , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
152 , P_Commit IN VARCHAR2 := FND_API.G_FALSE
153 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
154 , p_evt_regs_rec IN evt_regs_Rec_Type
155 , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
156 , x_event_registration_id OUT NOCOPY NUMBER
157 , x_confirmation_code OUT NOCOPY VARCHAR2
158 , x_system_status_code OUT NOCOPY VARCHAR2
159 , x_return_status OUT NOCOPY VARCHAR2
160 , x_msg_count OUT NOCOPY NUMBER
161 , x_msg_data OUT NOCOPY VARCHAR2
162 );
163
164 -----------------------------------------------------------------------------------
165 -- API Name : Update_evtregs
166 -- Type : Private
167 -- Pre-Req :
168 -- Parameters:
169 -- IN
170 -- p_api_version_number IN NUMBER Required
171 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
172 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
173 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
174 -- P_evt_regs_Rec IN evt_regs_Rec_Type Required (record with new items)
175 -- OUT
176 -- x_return_status OUT VARCHAR2
177 -- x_msg_count OUT NUMBER
178 -- x_msg_data OUT VARCHAR2
179 -- NOTES
180 -- 1. Raise exception if the object_version_number doesn't match.
181 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
182 -- that column won't be updated.
183 -----------------------------------------------------------------------------------
184 PROCEDURE Update_evtregs( 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 , P_evt_regs_Rec IN evt_regs_Rec_Type
189 , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
190 , X_Return_Status OUT NOCOPY VARCHAR2
191 , X_Msg_Count OUT NOCOPY NUMBER
192 , X_Msg_Data OUT NOCOPY VARCHAR2
193 );
194
195 -----------------------------------------------------------------------------------
196 -- API Name: Update_evtregs_wrapper
197 -- Type : Private
198 -- Pre-Req :
199 -- Parameters:
200 -- IN
201 -- p_api_version_number IN NUMBER Required
202 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
203 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
204 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
205 -- P_evt_regs_Rec IN evt_regs_Rec_Type Required (record with new items)
206 -- p_cancellation_reason_code IN VARCHAR2 Optional Default = NULL
207 -- OUT
208 -- x_cancellation_code OUT VARCHAR2
209 -- x_return_status OUT VARCHAR2
210 -- x_msg_count OUT NUMBER
211 -- x_msg_data OUT VARCHAR2
212 -- NOTES
213 -- 1. Call update or cancel depending on the status code
214 -----------------------------------------------------------------------------------
215 PROCEDURE UPDATE_evtregs_wrapper( P_Api_Version_Number 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 , P_evt_regs_Rec IN evt_regs_Rec_Type
220 , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
221 , p_cancellation_reason_code IN VARCHAR2 := NULL
222 , x_cancellation_code OUT NOCOPY VARCHAR2
223 , X_Return_Status OUT NOCOPY VARCHAR2
224 , X_Msg_Count OUT NOCOPY NUMBER
225 , X_Msg_Data OUT NOCOPY VARCHAR2
226 );
227
228 -----------------------------------------------------------------------------------
229 -- API Name : Cancel_evtregs
230 -- Type : Private
231 -- Pre-Req :
232 -- Parameters:
233 -- IN
234 -- p_api_version_number IN NUMBER Required
235 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
236 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
237 -- p_event_offer_id IN NUMBER Required
238 -- p_registrant_party_id IN NUMBER
239 -- p_confirmation_code IN VARCHAR2 Required
240 -- p_registration_group_id IN NUMBER
241 -- p_cancellation_reason_code IN VARCHAR2 Required
242 -- OUT
243 -- x_return_status OUT VARCHAR2
244 -- x_msg_count OUT NUMBER
245 -- x_msg_data OUT VARCHAR2
246 -- NOTES
247 -- 1. Raise exception if the object_version_number doesn't match.
248 -- modified sugupta 06/21/2000 return cancellation code as varchar2
249 -----------------------------------------------------------------------------------
250 PROCEDURE Cancel_evtregs( P_Api_Version_Number IN NUMBER
251 , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
252 , P_Commit IN VARCHAR2 := FND_API.G_FALSE
253 , p_object_version IN NUMBER
254 , p_event_offer_id IN NUMBER
255 , p_registrant_party_id IN NUMBER
256 , p_confirmation_code IN VARCHAR2
257 , p_registration_group_id IN NUMBER
258 , p_cancellation_reason_code IN VARCHAR2
259 , p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE
260 , x_cancellation_code OUT NOCOPY VARCHAR2
261 , X_Return_Status OUT NOCOPY VARCHAR2
262 , X_Msg_Count OUT NOCOPY NUMBER
263 , X_Msg_Data OUT NOCOPY VARCHAR2
264 );
265
266 -------------------------------------------------------------------
267 -- PROCEDURE
268 -- lock_evtregs
269 --
270 -- PURPOSE
271 -- Lock a event registration.
272 --
273 -- PARAMETERS
274 -- P_EVENT_REGISTRATION_ID
275 -- p_object_version: the object_version_number
276 --
277 -- NOTES
278 -- 1. Raise exception if the object_version_number doesn't match.
279 --------------------------------------------------------------------
280 PROCEDURE lock_evtregs(
281 p_api_version_Number IN NUMBER,
282 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
283 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
284
285 x_return_status OUT NOCOPY VARCHAR2,
286 x_msg_count OUT NOCOPY NUMBER,
287 x_msg_data OUT NOCOPY VARCHAR2,
288
289 P_EVENT_REGISTRATION_ID IN NUMBER,
290 p_object_version IN NUMBER
291 );
292
293 PROCEDURE delete_evtRegs(
294 p_api_version_number IN NUMBER,
295 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
296 p_commit IN VARCHAR2 := FND_API.g_false,
297 p_object_version IN NUMBER,
298 p_event_registration_id IN NUMBER,
299
300 x_return_status OUT NOCOPY VARCHAR2,
304
301 x_msg_count OUT NOCOPY NUMBER,
302 x_msg_data OUT NOCOPY VARCHAR2
303 );
305 PROCEDURE prioritize_waitlist(
306 p_api_version_number IN NUMBER,
307 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
308 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
309 p_override_availability IN VARCHAR2 := FND_API.G_FALSE,
310 p_event_offer_id IN NUMBER,
311
312 x_return_status OUT NOCOPY VARCHAR2,
313 x_msg_count OUT NOCOPY NUMBER,
314 x_msg_data OUT NOCOPY VARCHAR2
315 );
316 -------------------------------------------------------
317 -- Start of Comments
318 --
319 -- PROCEDURE
320 -- substitute_and_validate
321 --
322 -- HISTORY
323 -- 11/16/99 sugupta Added.
324 -- PURPOSE
325 -- called by substitute_enrollee in PUB API..
326 -- Substitute an enrollee(attendant) for an existing event registration..
327 -- Who can substitute is NOT verified in this API call...
328 -- If registrant information is also provided, then the existing
329 -- 'registrant information' is replaced...
330 -- 'Attendant information' is mandatory, but for account information...
331 -- if registrant info is changed, reg_contact id is stored in original_reg_contact_id column..
332 -------------------------------------------------------------
333
334 PROCEDURE substitute_and_validate(
335 P_Api_Version_Number IN NUMBER,
336 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
337 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
338
339 p_confirmation_code IN VARCHAR2, -- required
340 p_attendant_party_id IN NUMBER, -- required
341 p_attendant_contact_id IN NUMBER, -- required
342 p_attendant_account_id IN NUMBER, -- required
343 p_registrant_party_id IN NUMBER,
344 p_registrant_contact_id IN NUMBER, -- required
345 p_registrant_account_id IN NUMBER,
346
347 X_Return_Status OUT NOCOPY VARCHAR2,
348 X_Msg_Count OUT NOCOPY NUMBER,
349 X_Msg_Data OUT NOCOPY VARCHAR2
350 );
351 -------------------------------------------------------
352 -- Start of Comments
353 --
354 -- PROCEDURE
355 -- transfer_and_validate
356 --
357 -- HISTORY
358 -- 11/16/99 sugupta Added.
359 -- PURPOSE
360 -- called by transfer_enrollee in PUB API..
361 -- TRansfer an enrollee(attendant) for an existing event registration..
362 -- from one event offering to another offering..id's are mandatory..
363 -- Who can transfer is NOT verified in this API call...
364 -- Waitlist flag input is mandatory which means that if the other offering is full, is
365 -- the attendant willing to get waitlisted....
366 -- if the offering is full, and waitlisting is not wanted or even wailist is full, then
367 -- the transfer will fail...
368 -- PAYMENT details are not taken care of in this API call....
369 --------------------------------------------------------------
370
371 PROCEDURE transfer_and_validate(
372 P_Api_Version_Number IN NUMBER,
373 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
374 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
375 p_object_version IN NUMBER,
376 p_old_confirmation_code IN VARCHAR2, --required
377 p_old_offer_id IN NUMBER, --required
378 p_new_offer_id IN NUMBER, --required
379 p_waitlist_flag IN VARCHAR2, --required
380 p_registrant_account_id IN NUMBER, -- can be null
381 p_registrant_party_id IN NUMBER, -- can be null
382 p_registrant_contact_id IN NUMBER, -- can be null
383 p_attendant_party_id IN NUMBER,-- can be null
384 p_attendant_contact_id IN NUMBER,-- can be null
385 x_new_confirmation_code OUT NOCOPY VARCHAR2,
386 x_old_cancellation_code OUT NOCOPY VARCHAR2,
387 x_new_registration_id OUT NOCOPY NUMBER,
388 x_old_system_status_code OUT NOCOPY VARCHAR2,
389 x_new_system_status_code OUT NOCOPY VARCHAR2,
390 X_Return_Status OUT NOCOPY VARCHAR2,
391 X_Msg_Count OUT NOCOPY NUMBER,
392 X_Msg_Data OUT NOCOPY VARCHAR2
393 );
394 ----------------------------------------------------------------------
395 -- Start of Comments
396 --
397 -- PROCEDURE
398 -- check_evtRegs_items
399 -- check_evtRegs_req_items
400 -- check_evtRegs_uk_items
401 -- check_evtREgs_fk_items
402 -- check_evtRegs_lookup_items
403 -- check_evtRegs_flag_items
404 --
405 -- HISTORY
406 -- 11/01/99 sugupta Created.
407 -- PURPOSE
408 -- Validate the event registration colums against criteria, self explanatory
409 -- with the name of procedures- checking for required fields, unique key,
410 -- foreign keys, lookup items, flag values .
411 ---------------------------------------------------------------------
412 PROCEDURE check_evtRegs_items(
413 p_evt_Regs_rec IN evt_regs_Rec_Type,
414 p_validation_mode IN VARCHAR2,
415 x_return_status OUT NOCOPY VARCHAR2
416 );
417
418 PROCEDURE check_evtRegs_req_items(
419 p_evt_Regs_rec IN evt_regs_Rec_Type,
420 x_return_status OUT NOCOPY VARCHAR2
421 );
422
423 PROCEDURE check_evtRegs_uk_items(
424 p_confirmation_code IN VARCHAR2,
428 );
425 p_event_registration_id IN NUMBER,
426 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
427 x_return_status OUT NOCOPY VARCHAR2
429
430 PROCEDURE check_evtRegs_fk_items(
431 p_evt_Regs_rec IN evt_regs_Rec_Type,
432 p_validation_mode IN VARCHAR2,
433 x_return_status OUT NOCOPY VARCHAR2
434
435 );
436
437 PROCEDURE check_evtRegs_lookup_items(
438 p_evt_Regs_rec IN evt_regs_Rec_Type,
439 x_return_status OUT NOCOPY VARCHAR2
440 );
441
442 PROCEDURE check_evtRegs_flag_items(
443 p_evt_Regs_rec IN evt_regs_Rec_Type,
444 x_return_status OUT NOCOPY VARCHAR2
445 );
446
447 PROCEDURE check_evtRegs_record(
448 p_evt_Regs_rec IN evt_regs_Rec_Type,
449 x_return_status OUT NOCOPY VARCHAR2
450 );
451
452 -- Start of Comments
453 --
454 -- PURPOSE
455 -- Validate a event registration record.
456 --
457 -- NOTES
458 -- 1. P_evt_regs_Rec should be the complete evevt reg record. There
459 -- should not be any FND_API.g_miss_char/num/date in it.
460 --
461 -- End of Comments
462
463 PROCEDURE Validate_evtregs(
464 p_api_version_number IN NUMBER,
465 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
466 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
467 P_evt_regs_Rec IN evt_regs_Rec_Type,
468 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
469
470 X_Return_Status OUT NOCOPY VARCHAR2,
471 X_Msg_Count OUT NOCOPY NUMBER,
472 X_Msg_Data OUT NOCOPY VARCHAR2
473
474 );
475 ---------------------------------------------------------------------
476 -- PROCEDURE
477 -- init_evtregs_rec
478 --
479 -- HISTORY
480 -- 06/29/2000 sugupta Create.
481 ---------------------------------------------------------------------
482 PROCEDURE init_evtregs_rec(
483 x_evt_regs_rec OUT NOCOPY evt_regs_Rec_Type
484 );
485 -------------------------------------------------------
486 -- Start of Comments
487 --
488 -- PROCEDURE
489 -- COMPLETE_EVTREG_REC
490 --
491 -- HISTORY
492 -- 11/01/99 sugupta Created.
493 -- PURPOSE
494 -- complete a partial record passed in with col values to be updated
495 -- with other unchanged col values in existing row in table..
496 -- to be used in update_evtRegs ..
497 -------------------------------------------------------------
498
499 PROCEDURE COMPLETE_EVTREG_REC(
500 P_evt_regs_Rec IN evt_regs_Rec_Type,
501 x_complete_Rec OUT NOCOPY evt_regs_Rec_Type
502 );
503
504 --========================================================================
505 -- PROCEDURE
506 -- write_interaction
507 --
508 -- PURPOSE
509 -- This api is called in update_Status to write to interaction history
510 -- if it was DIRECT_MARKETING Direct Mail
511 --
512 -- NOTE
513 --
514 -- HISTORY
515 -- 19-mar-2002 soagrawa Created to log interactions for
516 -- DIRECT_MARKETING MAIL
517 -- 08-APR-2002 dcastlem Copied from AMS_ScheduleRules_PVT
518 --========================================================================
519
520 PROCEDURE write_interaction( p_event_offer_id IN NUMBER
521 , p_party_id IN NUMBER
522 );
523
524
525 End AMS_EvtRegs_PVT;