APPS.OTA_EVT_API_UPD2 SQL Statements

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

Line: 23

   SELECT null
     FROM ota_delegate_bookings odb
    WHERE event_id = p_event_id AND
          booking_status_type_id IN
          (SELECT booking_status_type_id
             FROM ota_booking_status_types
            WHERE type = 'A');

Line: 140

select  count(*)
from    ota_delegate_bookings odb
where   event_id = p_event_id and
        booking_status_type_id in
        (select booking_status_type_id
         from   ota_booking_status_types
         where  type = 'W');

Line: 212

			      ,p_update_finance_line in varchar2 default 'N'
			      ,p_booking_status_type_id in varchar2 default null
			      ,p_date_status_changed in date)  is

l_daemon_flag varchar2(1);

Line: 222

select  tdb.booking_id, tdb.object_version_number, fl.object_version_number tfl_object_version_number,
         fl.finance_line_id,
        date_booking_placed, line_id,org_id,daemon_flag,daemon_type, tdb.booking_status_type_id,
	tdb.delegate_person_id
from    ota_delegate_bookings tdb
,	ota_booking_status_types bst
,     ota_finance_lines fl
where	tdb.event_id = p_event_id
and	tdb.booking_status_type_id = bst.booking_status_type_id
and   fl.booking_id(+) = tdb.booking_id
and	(((p_event_status = 'P') and (bst.type not in ('C','W')))
or	((p_event_status = 'C') and (bst.type in ('R')))
or	((p_event_status = 'A') and (bst.type <> 'C')));  -- Added check for "bst.type <> 'C'" for bug #2065808

Line: 237

select type
from ota_booking_status_types
where booking_status_type_id = p_booking_status_type_id;

Line: 277

       ota_tdb_api_upd2.update_enrollment(p_booking_id		=> c_get_enrollment.booking_id
		      ,p_object_version_number	=> c_get_enrollment.object_version_number
		      ,p_finance_line_id	=> c_get_enrollment.finance_line_id
		      ,p_event_id       	=> p_event_id
		      ,p_booking_status_type_id	=> p_booking_status_type_id
		      ,p_status_change_comments => l_status_change_comments
		      ,p_date_booking_placed    => c_get_enrollment.date_booking_placed
		      ,p_update_finance_line	=> p_update_finance_line
		      ,p_tfl_object_version_number => c_get_enrollment.tfl_object_version_number
		      ,p_date_status_changed	=> p_date_status_changed
                  ,p_line_id              => c_get_enrollment.line_id
                  ,p_org_id			=> c_get_enrollment.org_id
		      ,p_daemon_flag		=> l_daemon_flag
		      ,p_daemon_type          => l_daemon_type);

Line: 362

procedure update_event
  (
  p_event			 in varchar2,
  p_event_id                     in number,
  p_object_version_number        in out nocopy number,
  p_event_status                 in out nocopy varchar2,
  p_validate                     in boolean default false,
  p_reset_max_attendees		 in boolean default false,
  p_update_finance_line		 in varchar2 default 'N',
  p_booking_status_type_id	 in number default null,
  p_date_status_changed 	 in date default null,
  p_maximum_attendees		 in number default null) is
--
  l_event_rec			ota_evt_shd.g_rec_type;

Line: 381

  l_proc 	varchar2(72) := g_package||'update_event';

Line: 390

      savepoint update_enrollment;

Line: 422

		        ,p_update_finance_line => p_update_finance_line
		        ,p_booking_status_type_id => p_booking_status_type_id
		      	,p_date_status_changed => p_date_status_changed);

Line: 501

      ROLLBACK TO update_event;

Line: 507

  end Update_Event;