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

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

Line: 242


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

Line: 258


  savepoint delete_performance_rating;

Line: 263


	hr_performance_ratings_bk3.delete_performance_rating_b
		(
		p_performance_rating_id   =>	p_performance_rating_id,
		p_object_version_number   =>	p_object_version_number
	);

Line: 271


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

Line: 293


	hr_performance_ratings_bk3.delete_performance_rating_a	(
		p_performance_rating_id   =>	p_performance_rating_id,
		p_object_version_number   =>	p_object_version_number
	);

Line: 300


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

Line: 321


    ROLLBACK TO delete_performance_rating;

Line: 330


    ROLLBACK TO delete_performance_rating;

Line: 337


end delete_performance_rating;

Line: 343


procedure update_performance_rating
  (p_validate                      in     boolean     default false
  ,p_effective_date                in     date
  ,p_performance_rating_id         in     number
  ,p_person_id                     in     number default null
  ,p_object_version_number         in out nocopy number
  ,p_appraisal_id                  in     number      default hr_api.g_number
  ,p_objective_id                  in     number      default hr_api.g_number
  ,p_performance_level_id          in     number      default hr_api.g_number
  ,p_comments                      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_appr_line_score               in     number      default hr_api.g_number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                     varchar2(72) := g_package||'update_performance_rating';

Line: 388


  savepoint update_performance_rating;

Line: 393


	hr_performance_ratings_bk2.update_performance_rating_b	(
         p_effective_date           => p_effective_date
        ,p_performance_rating_id    => p_performance_rating_id
        ,p_object_version_number    => p_object_version_number
        ,p_appraisal_id             => p_appraisal_id
        ,p_person_id                => p_person_id
        ,p_objective_id             => p_objective_id
        ,p_performance_level_id     => p_performance_level_id
        ,p_comments                 => p_comments
        ,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_appr_line_score          => p_appr_line_score
	);

Line: 428


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

Line: 478


	hr_performance_ratings_bk2.update_performance_rating_a	(
         p_effective_date           => p_effective_date
        ,p_performance_rating_id    => p_performance_rating_id
        ,p_object_version_number    => l_object_version_number
        ,p_appraisal_id             => p_appraisal_id
	,p_person_id                => p_person_id
        ,p_objective_id             => p_objective_id
        ,p_performance_level_id     => p_performance_level_id
        ,p_comments                 => p_comments
        ,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_appr_line_score          => p_appr_line_score
	);

Line: 513


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

Line: 538


    ROLLBACK TO update_performance_rating;

Line: 555


    ROLLBACK TO update_performance_rating;

Line: 562


end update_performance_rating;