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.HR_RATE_SWI SQL Statements

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

Line: 321


PROCEDURE delete_rate
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_rate_id                      in     number
  ,p_rate_type                    in     varchar2
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 337


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

Line: 343


  savepoint delete_rate_swi;

Line: 364


  hr_rate_api.delete_rate
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_rate_id                      => p_rate_id
    ,p_rate_type                    => p_rate_type
    ,p_object_version_number        => p_object_version_number
    );

Line: 393


    rollback to delete_rate_swi;

Line: 408


    rollback to delete_rate_swi;

Line: 419


end delete_rate;

Line: 423


PROCEDURE update_assignment_rate
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_rate_id                      in     number
  ,p_object_version_number        in out nocopy number
  ,p_effective_date               in     date
  ,p_name                         in     varchar2  default hr_api.g_varchar2
  ,p_rate_basis                   in     varchar2  default hr_api.g_varchar2
  ,p_asg_rate_type                in     varchar2  default hr_api.g_varchar2
  ,p_attribute_category           in     varchar2  default hr_api.g_varchar2
  ,p_attribute1                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute2                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute3                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute4                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute5                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute6                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute7                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute8                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute9                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute10                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute11                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute12                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute13                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute14                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute15                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute16                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute17                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute18                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute19                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute20                  in     varchar2  default hr_api.g_varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 462


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

Line: 468


  savepoint update_assignment_rate_swi;

Line: 489


  hr_rate_api.update_assignment_rate
    (p_validate                     => l_validate
    ,p_rate_id                      => p_rate_id
    ,p_object_version_number        => p_object_version_number
    ,p_effective_date               => p_effective_date
    ,p_name                         => p_name
    ,p_rate_basis                   => p_rate_basis
    ,p_asg_rate_type                => p_asg_rate_type
    ,p_attribute_category           => p_attribute_category
    ,p_attribute1                   => p_attribute1
    ,p_attribute2                   => p_attribute2
    ,p_attribute3                   => p_attribute3
    ,p_attribute4                   => p_attribute4
    ,p_attribute5                   => p_attribute5
    ,p_attribute6                   => p_attribute6
    ,p_attribute7                   => p_attribute7
    ,p_attribute8                   => p_attribute8
    ,p_attribute9                   => p_attribute9
    ,p_attribute10                  => p_attribute10
    ,p_attribute11                  => p_attribute11
    ,p_attribute12                  => p_attribute12
    ,p_attribute13                  => p_attribute13
    ,p_attribute14                  => p_attribute14
    ,p_attribute15                  => p_attribute15
    ,p_attribute16                  => p_attribute16
    ,p_attribute17                  => p_attribute17
    ,p_attribute18                  => p_attribute18
    ,p_attribute19                  => p_attribute19
    ,p_attribute20                  => p_attribute20
    );

Line: 541


    rollback to update_assignment_rate_swi;

Line: 556


    rollback to update_assignment_rate_swi;

Line: 567


end update_assignment_rate;

Line: 571


PROCEDURE update_rate
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_rate_id                      in     number
  ,p_object_version_number        in out nocopy number
  ,p_effective_date               in     date
  ,p_name                         in     varchar2  default hr_api.g_varchar2
  ,p_rate_uom                     in     varchar2  default hr_api.g_varchar2
  ,p_parent_spine_id              in     number    default hr_api.g_number
  ,p_comments                     in     varchar2  default hr_api.g_varchar2
  ,p_rate_basis                   in     varchar2  default hr_api.g_varchar2
  ,p_asg_rate_type                in     varchar2  default hr_api.g_varchar2
  ,p_attribute_category           in     varchar2  default hr_api.g_varchar2
  ,p_attribute1                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute2                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute3                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute4                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute5                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute6                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute7                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute8                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute9                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute10                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute11                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute12                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute13                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute14                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute15                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute16                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute17                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute18                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute19                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute20                  in     varchar2  default hr_api.g_varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 613


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

Line: 619


  savepoint update_rate_swi;

Line: 640


  hr_rate_api.update_rate
    (p_validate                     => l_validate
    ,p_rate_id                      => p_rate_id
    ,p_object_version_number        => p_object_version_number
    ,p_effective_date               => p_effective_date
    ,p_name                         => p_name
    ,p_rate_uom                     => p_rate_uom
    ,p_parent_spine_id              => p_parent_spine_id
    ,p_comments                     => p_comments
    ,p_rate_basis                   => p_rate_basis
    ,p_asg_rate_type                => p_asg_rate_type
    ,p_attribute_category           => p_attribute_category
    ,p_attribute1                   => p_attribute1
    ,p_attribute2                   => p_attribute2
    ,p_attribute3                   => p_attribute3
    ,p_attribute4                   => p_attribute4
    ,p_attribute5                   => p_attribute5
    ,p_attribute6                   => p_attribute6
    ,p_attribute7                   => p_attribute7
    ,p_attribute8                   => p_attribute8
    ,p_attribute9                   => p_attribute9
    ,p_attribute10                  => p_attribute10
    ,p_attribute11                  => p_attribute11
    ,p_attribute12                  => p_attribute12
    ,p_attribute13                  => p_attribute13
    ,p_attribute14                  => p_attribute14
    ,p_attribute15                  => p_attribute15
    ,p_attribute16                  => p_attribute16
    ,p_attribute17                  => p_attribute17
    ,p_attribute18                  => p_attribute18
    ,p_attribute19                  => p_attribute19
    ,p_attribute20                  => p_attribute20
    );

Line: 695


    rollback to update_rate_swi;

Line: 710


    rollback to update_rate_swi;

Line: 721


end update_rate;