APPS.OTA_BOOKING_STATUS_TYPE_SWI SQL Statements

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

Line: 173

PROCEDURE update_booking_status_type
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_business_group_id            in     number
  ,p_active_flag                  in     varchar2  default hr_api.g_varchar2
  ,p_default_flag                 in     varchar2  default hr_api.g_varchar2
  ,p_name                         in     varchar2  default hr_api.g_varchar2
  ,p_type                         in     varchar2  default hr_api.g_varchar2
  ,p_place_used_flag              in     varchar2  default hr_api.g_varchar2
  ,p_comments                     in     varchar2  default hr_api.g_varchar2
  ,p_description                  in     varchar2  default hr_api.g_varchar2
  ,p_bst_information_category     in     varchar2  default hr_api.g_varchar2
  ,p_bst_information1             in     varchar2  default hr_api.g_varchar2
  ,p_bst_information2             in     varchar2  default hr_api.g_varchar2
  ,p_bst_information3             in     varchar2  default hr_api.g_varchar2
  ,p_bst_information4             in     varchar2  default hr_api.g_varchar2
  ,p_bst_information5             in     varchar2  default hr_api.g_varchar2
  ,p_bst_information6             in     varchar2  default hr_api.g_varchar2
  ,p_bst_information7             in     varchar2  default hr_api.g_varchar2
  ,p_bst_information8             in     varchar2  default hr_api.g_varchar2
  ,p_bst_information9             in     varchar2  default hr_api.g_varchar2
  ,p_bst_information10            in     varchar2  default hr_api.g_varchar2
  ,p_bst_information11            in     varchar2  default hr_api.g_varchar2
  ,p_bst_information12            in     varchar2  default hr_api.g_varchar2
  ,p_bst_information13            in     varchar2  default hr_api.g_varchar2
  ,p_bst_information14            in     varchar2  default hr_api.g_varchar2
  ,p_bst_information15            in     varchar2  default hr_api.g_varchar2
  ,p_bst_information16            in     varchar2  default hr_api.g_varchar2
  ,p_bst_information17            in     varchar2  default hr_api.g_varchar2
  ,p_bst_information18            in     varchar2  default hr_api.g_varchar2
  ,p_bst_information19            in     varchar2  default hr_api.g_varchar2
  ,p_bst_information20            in     varchar2  default hr_api.g_varchar2
  ,p_booking_status_type_id       in     number    default hr_api.g_number
  ,p_object_version_number        in out nocopy number
--  ,p_data_source                  in     varchar2  default hr_api.g_varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 218

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

Line: 224

  savepoint update_booking_status_type_swi;

Line: 245

  ota_booking_status_type_api.update_booking_status_type
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_business_group_id            => p_business_group_id
    ,p_active_flag                  => p_active_flag
    ,p_default_flag                 => p_default_flag
    ,p_name                         => p_name
    ,p_type                         => p_type
    ,p_place_used_flag              => p_place_used_flag
    ,p_comments                     => p_comments
    ,p_description                  => p_description
    ,p_bst_information_category     => p_bst_information_category
    ,p_bst_information1             => p_bst_information1
    ,p_bst_information2             => p_bst_information2
    ,p_bst_information3             => p_bst_information3
    ,p_bst_information4             => p_bst_information4
    ,p_bst_information5             => p_bst_information5
    ,p_bst_information6             => p_bst_information6
    ,p_bst_information7             => p_bst_information7
    ,p_bst_information8             => p_bst_information8
    ,p_bst_information9             => p_bst_information9
    ,p_bst_information10            => p_bst_information10
    ,p_bst_information11            => p_bst_information11
    ,p_bst_information12            => p_bst_information12
    ,p_bst_information13            => p_bst_information13
    ,p_bst_information14            => p_bst_information14
    ,p_bst_information15            => p_bst_information15
    ,p_bst_information16            => p_bst_information16
    ,p_bst_information17            => p_bst_information17
    ,p_bst_information18            => p_bst_information18
    ,p_bst_information19            => p_bst_information19
    ,p_bst_information20            => p_bst_information20
    ,p_booking_status_type_id       => p_booking_status_type_id
    ,p_object_version_number        => p_object_version_number
--    ,p_data_source                  => p_data_source
    );

Line: 303

    rollback to update_booking_status_type_swi;

Line: 318

    rollback to update_booking_status_type_swi;

Line: 329

end update_booking_status_type;

Line: 333

PROCEDURE delete_booking_status_type
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_booking_status_type_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: 346

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

Line: 352

  savepoint delete_booking_status_type_swi;

Line: 372

  ota_booking_status_type_api.delete_booking_status_type
    (p_validate                     => l_validate
    ,p_booking_status_type_id       => p_booking_status_type_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 399

    rollback to delete_booking_status_type_swi;

Line: 413

    rollback to delete_booking_status_type_swi;

Line: 423

end delete_booking_status_type;