APPS.OTA_OM_TDB_WAITLIST_API SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 71

  select tdb.booking_id,
         tdb.delegate_person_id,
         tdb.delegate_contact_id,
         tdb.number_of_places,
         tdb.object_version_number,
         tfl.finance_line_id,
         tfl.object_version_number tfl_object_version_number,
         tdb.date_booking_placed  ,
         tdb.internal_booking_flag
  from ota_delegate_bookings tdb,
       ota_booking_status_types bst,
       ota_finance_lines tfl
  where  tfl.booking_id(+) = tdb.booking_id
  and tdb.booking_status_type_id = bst.booking_status_type_id
  and bst.type = 'W'
  and tdb.event_id = p_event_id
  order by tdb.date_booking_placed;

Line: 90

  select tdb.booking_id,
         tdb.delegate_person_id,
         tdb.delegate_contact_id,
         tdb.number_of_places,
         tdb.object_version_number,
         tfl.finance_line_id,
         tfl.object_version_number tfl_object_version_number,
         tdb.date_booking_placed ,
         tdb.internal_booking_flag
  from ota_delegate_bookings tdb,
       ota_booking_status_types bst,
       ota_finance_lines tfl
  where  tfl.booking_id(+)= tdb.booking_id
  and tdb.booking_status_type_id = bst.booking_status_type_id
  and bst.type = 'W'
  and tdb.event_id = p_event_id
  order by tdb.booking_priority,
           tdb.booking_id;

Line: 110

    select maximum_internal_attendees
    from   ota_events
    where  event_id = p_event_id;

Line: 115

    select sum(a.number_of_places)
    from   ota_delegate_bookings a,
           ota_booking_status_types b
    where  a.event_id = p_event_id
    and    a.booking_status_type_id = b.booking_status_type_id
    and    b.type in ('P','A')
    and    a.internal_booking_flag = 'Y'
    and    a.booking_id <> nvl(p_booking_id, hr_api.g_number);

Line: 357

             ota_tdb_api_upd2.update_enrollment(
                      p_booking_id                => t_waitlist_table(i).booking_id
                     ,p_object_version_number     => l_booking_ovn
                     ,p_tfl_object_version_number => l_finance_ovn
                     ,p_event_id                  => p_event_id
                     ,p_finance_line_id           => l_finance_line_id
                     ,p_booking_status_type_id    => l_status_type_id
                  ,p_number_of_places        => t_waitlist_table(i).number_of_places
                     ,p_date_status_changed       => sysdate   -- Added for bug# 1708632
                     ,p_date_booking_placed       => t_waitlist_table(i).date_booking_placed  -- Added for bug# 1708632
           ,p_status_change_comments    => null); /* Bug# 3469326 */