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

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

Line: 266


procedure update_rating_scale
 (p_language_code                in varchar2 default hr_api.userenv_lang,
  p_validate                     in boolean	default false,
  p_effective_date               in date,
  p_rating_scale_id              in number,
  p_object_version_number        in out NOCOPY number,
  p_name                         in varchar2    default hr_api.g_varchar2,
  p_description                  in varchar2    default hr_api.g_varchar2,
  p_default_flag                 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
  ) is
  --
  -- Declare cursors and local variables
  --

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

Line: 310


  savepoint update_rating_scale;

Line: 318


	hr_rating_scales_bk2.update_rating_scale_b	(
	 p_language_code               =>     l_language_code,
         p_effective_date               =>     p_effective_date,
         p_rating_scale_id              =>     p_rating_scale_id,
         p_object_version_number        =>     p_object_version_number,
         p_name                         =>     p_name,
         p_description                  =>     p_description,
         p_default_flag                 =>     p_default_flag,
         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: 351


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

Line: 410


	hr_rating_scales_bk2.update_rating_scale_a	(
	 p_language_code                =>     l_language_code,
         p_effective_date               =>     p_effective_date,
         p_rating_scale_id              =>     p_rating_scale_id,
         p_object_version_number        =>     l_object_version_number,
         p_name                         =>     p_name,
         p_description                  =>     p_description,
         p_default_flag                 =>     p_default_flag,
         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: 443


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

Line: 469


    ROLLBACK TO update_rating_scale;

Line: 485


    ROLLBACK TO update_rating_scale;

Line: 492


end update_rating_scale;

Line: 499


procedure delete_rating_scale
(p_validate                           in boolean default false,
 p_rating_scale_id                    in number,
 p_object_version_number              in number
) is
  --
  -- Declare cursors and local variables
  --
  cursor csr_get_rat_levels(c_rating_scale_id  per_rating_scales.rating_scale_id%TYPE)
   is
   select	rating_level_id,
		object_version_number
   from		per_rating_levels
   where	rating_scale_id	= c_rating_scale_id;

Line: 515


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

Line: 521


  savepoint delete_rating_scale;

Line: 527


	hr_rating_scales_bk3.delete_rating_scale_b
		(
		p_rating_scale_id       =>   p_rating_scale_id,
		p_object_version_number =>   p_object_version_number
		);

Line: 535


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

Line: 577


	hr_rating_scales_bk3.delete_rating_scale_a	(
		p_rating_scale_id        =>   p_rating_scale_id,
		p_object_version_number  =>   p_object_version_number
		);

Line: 584


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

Line: 604


    ROLLBACK TO delete_rating_scale;

Line: 613


    ROLLBACK TO delete_rating_scale;

Line: 619


end delete_rating_scale;

Line: 624


procedure create_or_update_rating_scale
 (p_language_code                in varchar2    default hr_api.userenv_lang
 ,p_validate                     in boolean     default false
 ,p_effective_date               in date        default trunc(sysdate)
 ,p_name                         in varchar2    default null
 ,p_type                         in varchar2    default null
 ,p_description                  in varchar2    default null
 ,p_default_flag                 in varchar2    default null
 ,p_translated_language          in varchar2    default null
 ,p_source_rating_scale_name     in varchar2    default null
) is

 --
 -- Declare cursor and local variables
 --
 l_proc              varchar2(72) := g_package||'create_or_update_rating_scale';

Line: 651


  select rating_scale_id , object_version_number
  from per_rating_scales_v
  where business_group_id is null
  and name = p_rating_scale_name;

Line: 669


         select  flv.lookup_code
         from    fnd_lookup_values flv
         where   flv.lookup_type     = p_lookup_type
         and     flv.meaning         = p_meaning
         and     flv.language        = p_language_code
         and     flv.enabled_flag = 'Y';

Line: 695


  savepoint create_or_update_rating_scale;

Line: 773


      update_rating_scale
      (p_language_code              => l_language_code
      ,p_validate                   => p_validate
      ,p_effective_date             => l_effective_date
      ,p_rating_scale_id            => l_rating_scale_id
      ,p_object_version_number      => l_ovn
      ,p_name                       => p_name
      ,p_default_flag               => l_default_flag
      ,p_description                => p_description
      );

Line: 818


	hr_rating_scales_bk2.update_rating_scale_a	(
 	   p_language_code                =>     l_translated_language,
           p_effective_date               =>     l_effective_date,
           p_rating_scale_id              =>     l_source_rating_scale_id,
           p_object_version_number        =>     l_source_ovn,
           p_name                         =>     p_source_rating_scale_name,
           p_description                  =>     p_description,
           p_default_flag                 =>     p_default_flag,
           p_attribute_category           =>     NULL,
           p_attribute1                   =>     NULL,
           p_attribute2                   =>     NULL,
           p_attribute3                   =>     NULL,
           p_attribute4                   =>     NULL,
           p_attribute5                   =>     NULL,
           p_attribute6                   =>     NULL,
           p_attribute7                   =>     NULL,
           p_attribute8                   =>     NULL,
           p_attribute9                   =>     NULL,
           p_attribute10                  =>     NULL,
           p_attribute11                  =>     NULL,
           p_attribute12                  =>     NULL,
           p_attribute13                  =>     NULL,
           p_attribute14                  =>     NULL,
           p_attribute15                  =>     NULL,
           p_attribute16                  =>     NULL,
           p_attribute17                  =>     NULL,
           p_attribute18                  =>     NULL,
           p_attribute19                  =>     NULL,
           p_attribute20                  =>     NULL
	);

Line: 852


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

Line: 870


    ROLLBACK TO create_or_update_rating_scale;

Line: 879


    ROLLBACK TO create_or_update_rating_scale;

Line: 885


end create_or_update_rating_scale;