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

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

Line: 252


procedure Update_resource
  (p_validate                     in     boolean  default false
  ,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_offering_id                  in     number    default hr_api.g_number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||'Update_resource';

Line: 301


  savepoint UPDATE_RESOURCE;

Line: 311


    ota_resource_usage_bk2.Update_resource_b
  (p_effective_date                    => l_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: 351


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

Line: 404


  ota_resource_usage_bk2.Update_resource_a
  (p_effective_date                    => l_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: 444


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

Line: 465


    rollback to UPDATE_RESOURCE;

Line: 477


    rollback to UPDATE_RESOURCE;

Line: 481


end Update_resource;

Line: 487


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

Line: 504


  savepoint DELETE_RESOURCE;

Line: 513


    ota_resource_usage_bk3.Delete_resource_b
  (p_resource_usage_id           => p_resource_usage_id
  ,p_object_version_number       => p_object_version_number
  );

Line: 520


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

Line: 540


  ota_resource_usage_bk3.Delete_resource_a
  (p_resource_usage_id           => p_resource_usage_id
  ,p_object_version_number       => p_object_version_number
  );

Line: 547


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

Line: 569


    rollback to DELETE_RESOURCE;

Line: 580


    rollback to DELETE_RESOURCE;

Line: 583


end Delete_resource;