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_RESOURCE_BOOKING_API SQL Statements

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

Line: 74


select osr.trainer_id from ota_suppliable_resources osr
where
osr.resource_type ='T'
and osr.supplied_resource_id = p_supplied_resource_id;

Line: 334


procedure update_resource_booking
  (p_effective_date                 in     date
  ,p_supplied_resource_id           in     number
  ,p_date_booking_placed            in     date
  ,p_status                         in     varchar2
  ,p_event_id                       in     number   default hr_api.g_number
  ,p_absolute_price                 in     number   default hr_api.g_number
  ,p_booking_person_id              in     number   default hr_api.g_number
  ,p_comments                       in     varchar2 default hr_api.g_varchar2
  ,p_contact_name                   in     varchar2 default hr_api.g_varchar2
  ,p_contact_phone_number           in     varchar2 default hr_api.g_varchar2
  ,p_delegates_per_unit             in     number   default hr_api.g_number
  ,p_quantity                       in     number   default hr_api.g_number
  ,p_required_date_from             in     date     default hr_api.g_date
  ,p_required_date_to               in     date     default hr_api.g_date
  ,p_required_end_time              in     varchar2 default hr_api.g_varchar2
  ,p_required_start_time            in     varchar2 default hr_api.g_varchar2
  ,p_deliver_to                     in     varchar2 default hr_api.g_varchar2
  ,p_primary_venue_flag             in     varchar2 default hr_api.g_varchar2
  ,p_role_to_play                   in     varchar2 default hr_api.g_varchar2
  ,p_trb_information_category       in     varchar2 default hr_api.g_varchar2
  ,p_trb_information1               in     varchar2 default hr_api.g_varchar2
  ,p_trb_information2               in     varchar2 default hr_api.g_varchar2
  ,p_trb_information3               in     varchar2 default hr_api.g_varchar2
  ,p_trb_information4               in     varchar2 default hr_api.g_varchar2
  ,p_trb_information5               in     varchar2 default hr_api.g_varchar2
  ,p_trb_information6               in     varchar2 default hr_api.g_varchar2
  ,p_trb_information7               in     varchar2 default hr_api.g_varchar2
  ,p_trb_information8               in     varchar2 default hr_api.g_varchar2
  ,p_trb_information9               in     varchar2 default hr_api.g_varchar2
  ,p_trb_information10              in     varchar2 default hr_api.g_varchar2
  ,p_trb_information11              in     varchar2 default hr_api.g_varchar2
  ,p_trb_information12              in     varchar2 default hr_api.g_varchar2
  ,p_trb_information13              in     varchar2 default hr_api.g_varchar2
  ,p_trb_information14              in     varchar2 default hr_api.g_varchar2
  ,p_trb_information15              in     varchar2 default hr_api.g_varchar2
  ,p_trb_information16              in     varchar2 default hr_api.g_varchar2
  ,p_trb_information17              in     varchar2 default hr_api.g_varchar2
  ,p_trb_information18              in     varchar2 default hr_api.g_varchar2
  ,p_trb_information19              in     varchar2 default hr_api.g_varchar2
  ,p_trb_information20              in     varchar2 default hr_api.g_varchar2
  ,p_display_to_learner_flag      in     varchar2  default hr_api.g_varchar2
  ,p_book_entire_period_flag    in     varchar2  default hr_api.g_varchar2
 -- ,p_unbook_request_flag    in     varchar2  default hr_api.g_varchar2
  ,p_chat_id                        in     number   default hr_api.g_number
  ,p_forum_id                       in     number   default hr_api.g_number
  ,p_validate                       in  boolean
  ,p_resource_booking_id            in  number
  ,p_object_version_number          in out nocopy number
  ,p_timezone_code                  IN VARCHAR2    DEFAULT hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' update_resource_booking ';

Line: 395


  select orb.status,orb.event_id,orb.required_date_from
  from ota_resource_bookings orb
  where resource_booking_id = p_resource_booking_id;

Line: 400


select osr.trainer_id from ota_suppliable_resources osr
where
osr.resource_type ='T'
and osr.supplied_resource_id = p_supplied_resource_id;

Line: 418


  savepoint update_resource_booking ;

Line: 439


  ota_resource_booking_bk2.update_resource_booking_b (
  p_effective_date               => l_effective_date      ,
  p_resource_booking_id          => p_resource_booking_id ,
  p_object_version_number        => l_object_version_number,
  p_supplied_resource_id         => p_supplied_resource_id ,
  p_date_booking_placed          => p_date_booking_placed ,
  p_status                       => p_status              ,
  p_event_id                     => p_event_id            ,
  p_absolute_price               => p_absolute_price      ,
  p_booking_person_id            => p_booking_person_id   ,
  p_comments                     => p_comments            ,
  p_contact_name                 => p_contact_name        ,
  p_contact_phone_number         => p_contact_phone_number,
  p_delegates_per_unit           => p_delegates_per_unit   ,
  p_quantity                     => p_quantity            ,
  p_required_date_from           => p_required_date_from  ,
  p_required_date_to             => p_required_date_to    ,
  p_required_end_time            => p_required_end_time   ,
  p_required_start_time          => p_required_start_time ,
  p_deliver_to                   => p_deliver_to          ,
  p_primary_venue_flag           => p_primary_venue_flag  ,
  p_role_to_play                 => p_role_to_play        ,
  p_trb_information_category     => p_trb_information_category    ,
  p_trb_information1             => p_trb_information1            ,
  p_trb_information2             => p_trb_information2            ,
  p_trb_information3             => p_trb_information3            ,
  p_trb_information4             => p_trb_information4            ,
  p_trb_information5             => p_trb_information5            ,
  p_trb_information6             => p_trb_information6            ,
  p_trb_information7             => p_trb_information7            ,
  p_trb_information8             => p_trb_information8            ,
  p_trb_information9             => p_trb_information9            ,
  p_trb_information10            => p_trb_information10            ,
  p_trb_information11            => p_trb_information11            ,
  p_trb_information12            => p_trb_information12            ,
  p_trb_information13            => p_trb_information13           ,
  p_trb_information14            => p_trb_information14            ,
  p_trb_information15            => p_trb_information15            ,
  p_trb_information16            => p_trb_information16            ,
  p_trb_information17            => p_trb_information17            ,
  p_trb_information18            => p_trb_information18            ,
  p_trb_information19            => p_trb_information19            ,
  p_trb_information20            => p_trb_information20
  ,p_display_to_learner_flag      => p_display_to_learner_flag
    ,p_book_entire_period_flag    => p_book_entire_period_flag
 --   ,p_unbook_request_flag    => p_unbook_request_flag
  ,p_chat_id                     => p_chat_id
  ,p_forum_id                    => p_forum_id
  ,p_timezone_code               => p_timezone_code
 );

Line: 493


        (p_module_name => 'update_resource_booking'
        ,p_hook_type   => 'BP'
        );

Line: 558


  OTA_resource_booking_bk2.update_resource_booking_a (
  p_effective_date               => l_effective_date      ,
  p_resource_booking_id          => p_resource_booking_id ,
  p_object_version_number        => l_object_version_number,
  p_supplied_resource_id         => p_supplied_resource_id ,
  p_date_booking_placed          => p_date_booking_placed ,
  p_status                       => p_status              ,
  p_event_id                     => p_event_id            ,
  p_absolute_price               => p_absolute_price      ,
  p_booking_person_id            => p_booking_person_id   ,
  p_comments                     => p_comments            ,
  p_contact_name                 => p_contact_name        ,
  p_contact_phone_number         => p_contact_phone_number,
  p_delegates_per_unit           => p_delegates_per_unit   ,
  p_quantity                     => p_quantity            ,
  p_required_date_from           => p_required_date_from  ,
  p_required_date_to             => p_required_date_to    ,
  p_required_end_time            => p_required_end_time   ,
  p_required_start_time          => p_required_start_time ,
  p_deliver_to                   => p_deliver_to          ,
  p_primary_venue_flag           => p_primary_venue_flag  ,
  p_role_to_play                 => p_role_to_play        ,
  p_trb_information_category     => p_trb_information_category    ,
  p_trb_information1             => p_trb_information1            ,
  p_trb_information2             => p_trb_information2            ,
  p_trb_information3             => p_trb_information3            ,
  p_trb_information4             => p_trb_information4            ,
  p_trb_information5             => p_trb_information5            ,
  p_trb_information6             => p_trb_information6            ,
  p_trb_information7             => p_trb_information7            ,
  p_trb_information8             => p_trb_information8            ,
  p_trb_information9             => p_trb_information9            ,
  p_trb_information10            => p_trb_information10           ,
  p_trb_information11            => p_trb_information11           ,
  p_trb_information12            => p_trb_information12           ,
  p_trb_information13            => p_trb_information13           ,
  p_trb_information14            => p_trb_information14           ,
  p_trb_information15            => p_trb_information15           ,
  p_trb_information16            => p_trb_information16           ,
  p_trb_information17            => p_trb_information17           ,
  p_trb_information18            => p_trb_information18           ,
  p_trb_information19            => p_trb_information19           ,
  p_trb_information20            => p_trb_information20
  ,p_display_to_learner_flag      => p_display_to_learner_flag
    ,p_book_entire_period_flag    => p_book_entire_period_flag
   -- ,p_unbook_request_flag    => p_unbook_request_flag
 ,p_chat_id                     => p_chat_id
 ,p_forum_id                    => p_forum_id
 ,p_timezone_code               => p_timezone_code
    );

Line: 612


        (p_module_name => 'update_resource_booking'
        ,p_hook_type   => 'AP'
        );

Line: 668


    rollback to update_resource_booking ;

Line: 680


    rollback to update_resource_booking ;

Line: 684


end update_resource_booking ;

Line: 691


procedure delete_resource_booking
 (
  p_resource_booking_id                in number,
  p_object_version_number              in number,
  p_validate                           in boolean
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' delete_resource_booking ';

Line: 704


  select orb.required_date_From,orb.required_date_to,
  orb.required_start_time,orb.required_end_time,
  orb.status,orb.supplied_resource_id,orb.event_id
  from ota_resource_bookings orb
  where resource_booking_id = p_resource_booking_id;

Line: 711


select osr.trainer_id from ota_suppliable_resources osr
where
osr.resource_type ='T'
and osr.supplied_resource_id = crs_sup_res_id;

Line: 731


  savepoint delete_resource_booking ;

Line: 747


    OTA_resource_booking_bk3.delete_resource_booking_b
    (p_resource_booking_id    => p_resource_booking_id ,
     p_object_version_number  => p_object_version_number,
     p_validate               => p_validate);

Line: 755


        (p_module_name => 'delete_resource_booking'
        ,p_hook_type   => 'BP'
        );

Line: 773


  OTA_resource_booking_bk3.delete_resource_booking_a
    (p_resource_booking_id    => p_resource_booking_id ,
     p_object_version_number  => p_object_version_number,
     p_validate               => p_validate);

Line: 780


        (p_module_name => 'delete_resource_booking'
        ,p_hook_type   => 'AP'
        );

Line: 820


    rollback to delete_resource_booking ;

Line: 831


    rollback to delete_resource_booking ;

Line: 834


end delete_resource_booking;