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

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

Line: 275


procedure update_perf_review
  (p_validate                       in  boolean   default false
  ,p_performance_review_id          in  number
  ,p_event_id                       in  number    default hr_api.g_number
  ,p_review_date                    in  date      default hr_api.g_date
  ,p_performance_rating             in  varchar2  default hr_api.g_varchar2
  ,p_next_perf_review_date          in  date      default hr_api.g_date
  ,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_attribute21                    in  varchar2  default hr_api.g_varchar2
  ,p_attribute22                    in  varchar2  default hr_api.g_varchar2
  ,p_attribute23                    in  varchar2  default hr_api.g_varchar2
  ,p_attribute24                    in  varchar2  default hr_api.g_varchar2
  ,p_attribute25                    in  varchar2  default hr_api.g_varchar2
  ,p_attribute26                    in  varchar2  default hr_api.g_varchar2
  ,p_attribute27                    in  varchar2  default hr_api.g_varchar2
  ,p_attribute28                    in  varchar2  default hr_api.g_varchar2
  ,p_attribute29                    in  varchar2  default hr_api.g_varchar2
  ,p_attribute30                    in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_next_review_date_warning       out nocopy boolean
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_perf_review';

Line: 329


  savepoint update_perf_review;

Line: 341


    hr_perf_review_bk2.update_perf_review_b
      (
       p_performance_review_id          =>  p_performance_review_id
      ,p_event_id                       =>  p_event_id
      ,p_review_date                    =>  p_review_date
      ,p_performance_rating             =>  p_performance_rating
      ,p_next_perf_review_date          =>  p_next_perf_review_date
      ,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
      ,p_attribute21                    =>  p_attribute21
      ,p_attribute22                    =>  p_attribute22
      ,p_attribute23                    =>  p_attribute23
      ,p_attribute24                    =>  p_attribute24
      ,p_attribute25                    =>  p_attribute25
      ,p_attribute26                    =>  p_attribute26
      ,p_attribute27                    =>  p_attribute27
      ,p_attribute28                    =>  p_attribute28
      ,p_attribute29                    =>  p_attribute29
      ,p_attribute30                    =>  p_attribute30
      ,p_object_version_number          =>  p_object_version_number
      );

Line: 384


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

Line: 439


    hr_perf_review_bk2.update_perf_review_a
      (
       p_performance_review_id          =>  p_performance_review_id
      ,p_event_id                       =>  p_event_id
      ,p_review_date                    =>  p_review_date
      ,p_performance_rating             =>  p_performance_rating
      ,p_next_perf_review_date          =>  p_next_perf_review_date
      ,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
      ,p_attribute21                    =>  p_attribute21
      ,p_attribute22                    =>  p_attribute22
      ,p_attribute23                    =>  p_attribute23
      ,p_attribute24                    =>  p_attribute24
      ,p_attribute25                    =>  p_attribute25
      ,p_attribute26                    =>  p_attribute26
      ,p_attribute27                    =>  p_attribute27
      ,p_attribute28                    =>  p_attribute28
      ,p_attribute29                    =>  p_attribute29
      ,p_attribute30                    =>  p_attribute30
      ,p_object_version_number          =>  l_object_version_number
      );

Line: 482


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

Line: 511


    ROLLBACK TO update_perf_review;

Line: 525


    ROLLBACK TO update_perf_review;

Line: 528


end update_perf_review;

Line: 533


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

Line: 551


  savepoint delete_perf_review;

Line: 564


    hr_perf_review_bk3.delete_perf_review_b
      (
       p_performance_review_id          =>  p_performance_review_id
      ,p_object_version_number          =>  p_object_version_number
      );

Line: 572


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

Line: 591


    hr_perf_review_bk3.delete_perf_review_a
      (
       p_performance_review_id          =>  p_performance_review_id
      ,p_object_version_number          =>  l_object_version_number
      );

Line: 599


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

Line: 624


    ROLLBACK TO delete_perf_review;

Line: 636


    ROLLBACK TO delete_perf_review;

Line: 639


end delete_perf_review;