APPS.OTA_EVT_API_UPD2 dependencies on OTA_EVT_BUS2

Line 107: l_total_places := ota_evt_bus2.get_total_places('ALL',p_event_id);

103: -- Then reset the Event Status to Full. Would only apply if changing
104: -- Event Status from Closed to Normal.
105: --
106: if p_event_status in ('N') and p_maximum_attendees is not null then
107: l_total_places := ota_evt_bus2.get_total_places('ALL',p_event_id);
108: if l_total_places = p_maximum_attendees then
109: p_event_status := 'F';
110: end if;
111: end if;

Line 165: l_total_places := ota_evt_bus2.get_total_places('ALL',p_event_id);

161: end if;
162: else
163:
164: if p_event_status in ('F','N') then
165: l_total_places := ota_evt_bus2.get_total_places('ALL',p_event_id);
166: if (p_maximum_attendees > p_old_max_attendees) and (l_total_places < p_maximum_attendees)
167: and (p_event_status = 'F') then
168:
169: -- *** Check if total places > max attendees + wait list then change the status to 'N' else 'F'

Line 338: l_total_places := ota_evt_bus2.get_total_places('ALL',p_event_id);

334: -- Closed.
335: --
336: if p_event_status in ('C') then
337: if p_reset_max_attendees then
338: l_total_places := ota_evt_bus2.get_total_places('ALL',p_event_id);
339: l_total_internal_places := ota_evt_bus2.get_total_places('INTERNAL',p_event_id);
340: if p_maximum_internal_attendees > l_total_places then
341: p_maximum_internal_attendees := l_total_places;
342: p_maximum_attendees := l_total_places;

Line 339: l_total_internal_places := ota_evt_bus2.get_total_places('INTERNAL',p_event_id);

335: --
336: if p_event_status in ('C') then
337: if p_reset_max_attendees then
338: l_total_places := ota_evt_bus2.get_total_places('ALL',p_event_id);
339: l_total_internal_places := ota_evt_bus2.get_total_places('INTERNAL',p_event_id);
340: if p_maximum_internal_attendees > l_total_places then
341: p_maximum_internal_attendees := l_total_places;
342: p_maximum_attendees := l_total_places;
343: else