APPS.OTA_EVT_BUS2 dependencies on OTA_EVT_SHD

Line 39: ota_evt_shd.lck(p_event_id

35: if get_event%notfound then
36: null;
37: end if;
38: --
39: ota_evt_shd.lck(p_event_id
40: ,l_evt_object_version_number);
41: --
42: hr_utility.set_location('Leaving:'||l_proc, 10);
43: --

Line 320: p_rec ota_evt_shd.g_rec_type;

316: -- Get current vacancies for a particular event.
317: --
318: Function Get_Vacancies(p_event_id in number) return number is
319: --
320: p_rec ota_evt_shd.g_rec_type;
321: p_event_exists boolean;
322: l_vacancies number;
323: l_total_places number := ota_evt_bus2.get_total_places('ALL',p_event_id);
324: l_proc varchar2(72) := g_package||'get_vacancies';

Line 331: ota_evt_shd.get_event_details(p_event_id,p_rec,p_event_exists);

327: begin
328: --
329: hr_utility.set_location('Entering:'|| l_proc, 5);
330: --
331: ota_evt_shd.get_event_details(p_event_id,p_rec,p_event_exists);
332: --
333: if p_rec.maximum_attendees is not null then
334: l_vacancies := p_rec.maximum_attendees - l_total_places;
335: else

Line 361: l_rec ota_evt_shd.g_rec_type;

357: ,p_event_status in varchar2
358: ,p_booking_status_type_id in number default null)
359: Return Boolean is
360: --
361: l_rec ota_evt_shd.g_rec_type;
362: l_event_exists boolean;
363: l_old_booking_status varchar2(30);
364: l_new_booking_status varchar2(30);
365: l_total_attendees number := ota_evt_bus2.get_total_places('ALL',p_event_id);

Line 374: ota_evt_shd.get_event_details(p_event_id,l_rec,l_event_exists);

370: l_proc varchar2(72) := g_package||'wait_list_required';
371: --
372: Begin
373: --
374: ota_evt_shd.get_event_details(p_event_id,l_rec,l_event_exists);
375: --
376: hr_utility.set_location('Entering:'|| l_proc, 5);
377: --
378: if p_event_type = 'ENROLLMENT' then