APPS.OTA_EVT_BUS2 dependencies on OTA_TDB_BUS

Line 367: ota_tdb_bus.places_for_status(p_event_id => p_event_id

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);
366: l_total_waitlisted number :=
367: ota_tdb_bus.places_for_status(p_event_id => p_event_id
368: ,p_all_or_internal => 'ALL'
369: ,p_status_type => 'W');
370: l_proc varchar2(72) := g_package||'wait_list_required';
371: --

Line 380: l_old_booking_status := ota_tdb_bus.booking_status_type(

376: hr_utility.set_location('Entering:'|| l_proc, 5);
377: --
378: if p_event_type = 'ENROLLMENT' then
379: --
380: l_old_booking_status := ota_tdb_bus.booking_status_type(
381: ota_tdb_shd.g_old_rec.booking_status_type_id);
382: l_new_booking_status := ota_tdb_bus.booking_status_type(
383: p_booking_status_type_id);
384: if l_old_booking_status in ('P','A','E') and --6683076.Added 'E' as new status.

Line 382: l_new_booking_status := ota_tdb_bus.booking_status_type(

378: if p_event_type = 'ENROLLMENT' then
379: --
380: l_old_booking_status := ota_tdb_bus.booking_status_type(
381: ota_tdb_shd.g_old_rec.booking_status_type_id);
382: l_new_booking_status := ota_tdb_bus.booking_status_type(
383: p_booking_status_type_id);
384: if l_old_booking_status in ('P','A','E') and --6683076.Added 'E' as new status.
385: l_new_booking_status in ('W','C','R') and
386: l_total_waitlisted <> 0 then