APPS.OTA_RESOURCE_USAGE_SWI SQL Statements

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

Line: 177

PROCEDURE delete_resource
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_resource_usage_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: 190

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

Line: 196

  savepoint delete_resource_swi;

Line: 216

  ota_resource_usage_api.delete_resource
    (p_validate                     => l_validate
    ,p_resource_usage_id            => p_resource_usage_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 243

    rollback to delete_resource_swi;

Line: 257

    rollback to delete_resource_swi;

Line: 267

end delete_resource;

Line: 271

PROCEDURE update_resource
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_resource_usage_id            in     number
  ,p_object_version_number        in out nocopy number
  ,p_activity_version_id          in     number    default hr_api.g_number
  ,p_required_flag                in     varchar2  default hr_api.g_varchar2
  ,p_start_date                   in     date      default hr_api.g_date
  ,p_supplied_resource_id         in     number    default hr_api.g_number
  ,p_comments                     in     varchar2  default hr_api.g_varchar2
  ,p_end_date                     in     date      default hr_api.g_date
  ,p_quantity                     in     number    default hr_api.g_number
  ,p_resource_type                in     varchar2  default hr_api.g_varchar2
  ,p_role_to_play                 in     varchar2  default hr_api.g_varchar2
  ,p_usage_reason                 in     varchar2  default hr_api.g_varchar2
  ,p_rud_information_category     in     varchar2  default hr_api.g_varchar2
  ,p_rud_information1             in     varchar2  default hr_api.g_varchar2
  ,p_rud_information2             in     varchar2  default hr_api.g_varchar2
  ,p_rud_information3             in     varchar2  default hr_api.g_varchar2
  ,p_rud_information4             in     varchar2  default hr_api.g_varchar2
  ,p_rud_information5             in     varchar2  default hr_api.g_varchar2
  ,p_rud_information6             in     varchar2  default hr_api.g_varchar2
  ,p_rud_information7             in     varchar2  default hr_api.g_varchar2
  ,p_rud_information8             in     varchar2  default hr_api.g_varchar2
  ,p_rud_information9             in     varchar2  default hr_api.g_varchar2
  ,p_rud_information10            in     varchar2  default hr_api.g_varchar2
  ,p_rud_information11            in     varchar2  default hr_api.g_varchar2
  ,p_rud_information12            in     varchar2  default hr_api.g_varchar2
  ,p_rud_information13            in     varchar2  default hr_api.g_varchar2
  ,p_rud_information14            in     varchar2  default hr_api.g_varchar2
  ,p_rud_information15            in     varchar2  default hr_api.g_varchar2
  ,p_rud_information16            in     varchar2  default hr_api.g_varchar2
  ,p_rud_information17            in     varchar2  default hr_api.g_varchar2
  ,p_rud_information18            in     varchar2  default hr_api.g_varchar2
  ,p_rud_information19            in     varchar2  default hr_api.g_varchar2
  ,p_rud_information20            in     varchar2  default hr_api.g_varchar2
  ,p_return_status                   out nocopy varchar2
  ,p_offering_id                  in     number    default hr_api.g_number
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 318

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

Line: 324

  savepoint update_resource_swi;

Line: 345

  ota_resource_usage_api.update_resource
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_resource_usage_id            => p_resource_usage_id
    ,p_object_version_number        => p_object_version_number
    ,p_activity_version_id          => p_activity_version_id
    ,p_required_flag                => p_required_flag
    ,p_start_date                   => p_start_date
    ,p_supplied_resource_id         => p_supplied_resource_id
    ,p_comments                     => p_comments
    ,p_end_date                     => p_end_date
    ,p_quantity                     => p_quantity
    ,p_resource_type                => p_resource_type
    ,p_role_to_play                 => p_role_to_play
    ,p_usage_reason                 => p_usage_reason
    ,p_rud_information_category     => p_rud_information_category
    ,p_rud_information1             => p_rud_information1
    ,p_rud_information2             => p_rud_information2
    ,p_rud_information3             => p_rud_information3
    ,p_rud_information4             => p_rud_information4
    ,p_rud_information5             => p_rud_information5
    ,p_rud_information6             => p_rud_information6
    ,p_rud_information7             => p_rud_information7
    ,p_rud_information8             => p_rud_information8
    ,p_rud_information9             => p_rud_information9
    ,p_rud_information10            => p_rud_information10
    ,p_rud_information11            => p_rud_information11
    ,p_rud_information12            => p_rud_information12
    ,p_rud_information13            => p_rud_information13
    ,p_rud_information14            => p_rud_information14
    ,p_rud_information15            => p_rud_information15
    ,p_rud_information16            => p_rud_information16
    ,p_rud_information17            => p_rud_information17
    ,p_rud_information18            => p_rud_information18
    ,p_rud_information19            => p_rud_information19
    ,p_rud_information20            => p_rud_information20
    ,p_offering_id                  => p_offering_id
    );

Line: 405

    rollback to update_resource_swi;

Line: 420

    rollback to update_resource_swi;

Line: 431

end update_resource;