eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_EVENT_SWI SQL Statements

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

Line: 255


PROCEDURE delete_event
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_event_id                     in     number
  ,p_object_version_number        in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 268


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

Line: 274


  savepoint delete_event_swi;

Line: 294


  ota_event_api.delete_class
    (p_validate                     => l_validate
    ,p_event_id                     => p_event_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 321


    rollback to delete_event_swi;

Line: 335


    rollback to delete_event_swi;

Line: 345


end delete_event;

Line: 349


PROCEDURE update_event
  (p_event_id                     in     number
  ,p_effective_date               in     date      default trunc(sysdate)
  ,p_vendor_id                    in     number    default hr_api.g_number
  ,p_activity_version_id          in     number    default hr_api.g_number
  ,p_business_group_id            in     number    default hr_api.g_number
  ,p_organization_id              in     number    default hr_api.g_number
  ,p_event_type                   in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number        in out nocopy number
  ,p_title                        in     varchar2  default hr_api.g_varchar2
  ,p_budget_cost                  in     number    default hr_api.g_number
  ,p_actual_cost                  in     number    default hr_api.g_number
  ,p_budget_currency_code         in     varchar2  default hr_api.g_varchar2
  ,p_centre                       in     varchar2  default hr_api.g_varchar2
  ,p_comments                     in     varchar2  default hr_api.g_varchar2
  ,p_course_end_date              in     date      default hr_api.g_date
  ,p_course_end_time              in     varchar2  default hr_api.g_varchar2
  ,p_course_start_date            in     date      default hr_api.g_date
  ,p_course_start_time            in     varchar2  default hr_api.g_varchar2
  ,p_duration                     in     number    default hr_api.g_number
  ,p_duration_units               in     varchar2  default hr_api.g_varchar2
  ,p_enrolment_end_date           in     date      default hr_api.g_date
  ,p_enrolment_start_date         in     date      default hr_api.g_date
  ,p_language_id                  in     number    default hr_api.g_number
  ,p_user_status                  in     varchar2  default hr_api.g_varchar2
  ,p_development_event_type       in     varchar2  default hr_api.g_varchar2
  ,p_event_status                 in     varchar2  default hr_api.g_varchar2
  ,p_price_basis                  in     varchar2  default hr_api.g_varchar2
  ,p_currency_code                in     varchar2  default hr_api.g_varchar2
  ,p_maximum_attendees            in     number    default hr_api.g_number
  ,p_maximum_internal_attendees   in     number    default hr_api.g_number
  ,p_minimum_attendees            in     number    default hr_api.g_number
  ,p_standard_price               in     number    default hr_api.g_number
  ,p_category_code                in     varchar2  default hr_api.g_varchar2
  ,p_parent_event_id              in     number    default hr_api.g_number
  ,p_book_independent_flag        in     varchar2  default hr_api.g_varchar2
  ,p_public_event_flag            in     varchar2  default hr_api.g_varchar2
  ,p_secure_event_flag            in     varchar2  default hr_api.g_varchar2
  ,p_evt_information_category     in     varchar2  default hr_api.g_varchar2
  ,p_evt_information1             in     varchar2  default hr_api.g_varchar2
  ,p_evt_information2             in     varchar2  default hr_api.g_varchar2
  ,p_evt_information3             in     varchar2  default hr_api.g_varchar2
  ,p_evt_information4             in     varchar2  default hr_api.g_varchar2
  ,p_evt_information5             in     varchar2  default hr_api.g_varchar2
  ,p_evt_information6             in     varchar2  default hr_api.g_varchar2
  ,p_evt_information7             in     varchar2  default hr_api.g_varchar2
  ,p_evt_information8             in     varchar2  default hr_api.g_varchar2
  ,p_evt_information9             in     varchar2  default hr_api.g_varchar2
  ,p_evt_information10            in     varchar2  default hr_api.g_varchar2
  ,p_evt_information11            in     varchar2  default hr_api.g_varchar2
  ,p_evt_information12            in     varchar2  default hr_api.g_varchar2
  ,p_evt_information13            in     varchar2  default hr_api.g_varchar2
  ,p_evt_information14            in     varchar2  default hr_api.g_varchar2
  ,p_evt_information15            in     varchar2  default hr_api.g_varchar2
  ,p_evt_information16            in     varchar2  default hr_api.g_varchar2
  ,p_evt_information17            in     varchar2  default hr_api.g_varchar2
  ,p_evt_information18            in     varchar2  default hr_api.g_varchar2
  ,p_evt_information19            in     varchar2  default hr_api.g_varchar2
  ,p_evt_information20            in     varchar2  default hr_api.g_varchar2
  ,p_project_id                   in     number    default hr_api.g_number
  ,p_owner_id                     in     number    default hr_api.g_number
  ,p_line_id                      in     number    default hr_api.g_number
  ,p_org_id                       in     number    default hr_api.g_number
  ,p_training_center_id           in     number    default hr_api.g_number
  ,p_location_id                  in     number    default hr_api.g_number
  ,p_offering_id                  in     number    default hr_api.g_number
  ,p_timezone                     in     varchar2  default hr_api.g_varchar2
  ,p_parent_offering_id           in     number    default hr_api.g_number
  ,p_validate                     in     number    default hr_api.g_false_num
  ,p_return_status                   out nocopy varchar2
  ,p_data_source                  in     varchar2  default hr_api.g_varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 429


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

Line: 435


  savepoint update_event_swi;

Line: 456


  ota_event_api.update_class
    (p_event_id                     => p_event_id
    ,p_effective_date               => p_effective_date
    ,p_vendor_id                    => p_vendor_id
    ,p_activity_version_id          => p_activity_version_id
    ,p_business_group_id            => p_business_group_id
    ,p_organization_id              => p_organization_id
    ,p_event_type                   => p_event_type
    ,p_object_version_number        => p_object_version_number
    ,p_title                        => p_title
    ,p_budget_cost                  => p_budget_cost
    ,p_actual_cost                  => p_actual_cost
    ,p_budget_currency_code         => p_budget_currency_code
    ,p_centre                       => p_centre
    ,p_comments                     => p_comments
    ,p_course_end_date              => p_course_end_date
    ,p_course_end_time              => p_course_end_time
    ,p_course_start_date            => p_course_start_date
    ,p_course_start_time            => p_course_start_time
    ,p_duration                     => p_duration
    ,p_duration_units               => p_duration_units
    ,p_enrolment_end_date           => p_enrolment_end_date
    ,p_enrolment_start_date         => p_enrolment_start_date
    ,p_language_id                  => p_language_id
    ,p_user_status                  => p_user_status
    ,p_development_event_type       => p_development_event_type
    ,p_event_status                 => p_event_status
    ,p_price_basis                  => p_price_basis
    ,p_currency_code                => p_currency_code
    ,p_maximum_attendees            => p_maximum_attendees
    ,p_maximum_internal_attendees   => p_maximum_internal_attendees
    ,p_minimum_attendees            => p_minimum_attendees
    ,p_standard_price               => p_standard_price
    ,p_category_code                => p_category_code
    ,p_parent_event_id              => p_parent_event_id
    ,p_book_independent_flag        => p_book_independent_flag
    ,p_public_event_flag            => p_public_event_flag
    ,p_secure_event_flag            => p_secure_event_flag
    ,p_evt_information_category     => p_evt_information_category
    ,p_evt_information1             => p_evt_information1
    ,p_evt_information2             => p_evt_information2
    ,p_evt_information3             => p_evt_information3
    ,p_evt_information4             => p_evt_information4
    ,p_evt_information5             => p_evt_information5
    ,p_evt_information6             => p_evt_information6
    ,p_evt_information7             => p_evt_information7
    ,p_evt_information8             => p_evt_information8
    ,p_evt_information9             => p_evt_information9
    ,p_evt_information10            => p_evt_information10
    ,p_evt_information11            => p_evt_information11
    ,p_evt_information12            => p_evt_information12
    ,p_evt_information13            => p_evt_information13
    ,p_evt_information14            => p_evt_information14
    ,p_evt_information15            => p_evt_information15
    ,p_evt_information16            => p_evt_information16
    ,p_evt_information17            => p_evt_information17
    ,p_evt_information18            => p_evt_information18
    ,p_evt_information19            => p_evt_information19
    ,p_evt_information20            => p_evt_information20
    ,p_project_id                   => p_project_id
    ,p_owner_id                     => p_owner_id
    ,p_line_id                      => p_line_id
    ,p_org_id                       => p_org_id
    ,p_training_center_id           => p_training_center_id
    ,p_location_id                  => p_location_id
    ,p_offering_id                  => p_offering_id
    ,p_timezone                     => p_timezone
    ,p_parent_offering_id           => p_parent_offering_id
    ,p_validate                     => l_validate
    ,p_data_source                  => p_data_source
    );

Line: 549


    rollback to update_event_swi;

Line: 564


    rollback to update_event_swi;

Line: 575


end update_event;

Line: 581


procedure update_enrollment     (p_booking_id 	IN	NUMBER,
					             p_daemon_flag	IN	VARCHAR2,
					             p_daemon_type	IN	VARCHAR2,
					             p_booking_status_type_id        IN    NUMBER,
                                 p_event_id IN NUMBER,
                                 p_object_version_number  IN NUMBER,
					             p_return_status out nocopy varchar2) is

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

Line: 595


     savepoint update_enrollment;

Line: 599


  ota_tdb_api_upd2.update_enrollment
  (
  p_booking_id                   => p_booking_id,
  p_booking_status_type_id       => p_booking_status_type_id ,
  P_event_id                     => p_event_id,
  p_enrollment_type              => 'S' ,
  p_daemon_flag                  => p_daemon_flag  ,
  p_daemon_type                  => p_daemon_type ,
    p_object_version_number	     =>    l_object_version_number,
  p_tfl_object_version_number        =>    l_tfl_object_version_number,
  p_finance_line_id                  =>    l_finance_line_id
  );

Line: 622


    rollback to update_enrollment;

Line: 637


    rollback to update_enrollment;

Line: 648


end update_enrollment;

Line: 655


 procedure upd2_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 number default hr_api.g_false_num,
  p_reset_max_attendees		     in number default hr_api.g_false_num,
  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,
  p_change_status		         in varchar2 default 'A',
  p_return_status                out nocopy varchar2,
  p_check_for_warning            in varchar2 default 'Y',
  p_message_name                 out nocopy varchar2) is
  --
  --
  l_event_type 		varchar2(30);

Line: 687


SELECT to_date(to_char(evt.Course_start_date,'DD-MM-YYYY')||EVT.Course_start_time,'DD-MM-YYYYHH24:MI'),EVENT_TYPE,TITLE,OWNER_ID,MAXIMUM_ATTENDEES
FROM   OTA_EVENTS  EVT
WHERE  evt.event_id = p_event_id;

Line: 692


SELECT SYSDATE
FROM DUAL;

Line: 700


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

Line: 708


       savepoint upd2_update_event;

Line: 751


     OTA_EVT_API_UPD2.UPDATE_EVENT (
    P_EVENT			 => p_event,
    P_EVENT_ID                   => p_event_id,
    P_OBJECT_VERSION_NUMBER      => p_object_version_number  ,
    P_EVENT_STATUS               => p_event_status  ,
    P_VALIDATE		         => l_validate   ,
    P_BOOKING_STATUS_TYPE_ID     => p_booking_status_type_id,
    P_UPDATE_FINANCE_LINE	 => p_update_finance_line,
    P_RESET_MAX_ATTENDEES        => 	l_reset_max_attendees,
    P_DATE_STATUS_CHANGED	 => p_date_status_changed ,
    P_maximum_attendees		 => p_maximum_attendees	);

Line: 806


	select to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS') into l_sysdate from dual;

Line: 856


    rollback to upd2_update_event;

Line: 870


    rollback to upd2_update_event;

Line: 881


end upd2_update_event;

Line: 897


  select nvl(course_start_time, '-99:99') course_start_time,
         nvl(course_end_time, '99:99') course_end_time
  from ota_events
  where event_id <> p_event_id
  and parent_event_id = p_parent_event_id
  and nvl(course_start_date, sysdate) = nvl(p_session_date, sysdate)
  and event_type = 'SESSION';