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

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

Line: 42


  ,p_last_update_date              in 	  date     default null
  ,p_last_updated_by               in 	  number   default null
  ,p_last_update_login             in 	  number   default null
  ,p_created_by                    in 	  number   default null
  ,p_creation_date                 in 	  date     default null
  ,p_information_category          in     varchar2 default null
  ,p_information1 	           in     varchar2 default null
  ,p_information2 	           in     varchar2 default null
  ,p_information3 	           in     varchar2 default null
  ,p_information4 	           in     varchar2 default null
  ,p_information5 	           in     varchar2 default null
  ,p_information6 	           in     varchar2 default null
  ,p_information7 	           in     varchar2 default null
  ,p_information8 	           in     varchar2 default null
  ,p_information9 	           in     varchar2 default null
  ,p_information10 	           in     varchar2 default null
  ,p_information11 	           in     varchar2 default null
  ,p_information12 	           in     varchar2 default null
  ,p_information13 	           in     varchar2 default null
  ,p_information14 	           in     varchar2 default null
  ,p_information15 	           in     varchar2 default null
  ,p_information16 	           in     varchar2 default null
  ,p_information17 	           in     varchar2 default null
  ,p_information18 	           in     varchar2 default null
  ,p_information19 	           in     varchar2 default null
  ,p_information20 	           in     varchar2 default null
  ,p_pay_basis_id                  out    nocopy number
  ,p_object_version_number         out    nocopy number
   ) is
--
-- Declare cursors and local variables
--
   l_pay_basis_id          per_pay_bases.pay_basis_id%TYPE;

Line: 130


    ,p_last_update_date              => p_last_update_date
    ,p_last_updated_by               => p_last_updated_by
    ,p_last_update_login             => p_last_update_login
    ,p_created_by                    => p_created_by
    ,p_creation_date                 => p_creation_date
    ,p_information_category          => p_information_category
    ,p_information1                  => p_information1
    ,p_information2                  => p_information2
    ,p_information3                  => p_information3
    ,p_information4                  => p_information4
    ,p_information5                  => p_information5
    ,p_information6                  => p_information6
    ,p_information7                  => p_information7
    ,p_information8                  => p_information8
    ,p_information9                  => p_information9
    ,p_information10                 => p_information10
    ,p_information11                 => p_information11
    ,p_information12                 => p_information12
    ,p_information13                 => p_information13
    ,p_information14                 => p_information14
    ,p_information15                 => p_information15
    ,p_information16                 => p_information16
    ,p_information17                 => p_information17
    ,p_information18                 => p_information18
    ,p_information19                 => p_information19
    ,p_information20 	             => p_information20
    ,p_pay_basis_id                  => l_pay_basis_id
    ,p_object_version_number         => l_object_version_number
     );

Line: 269


    ,p_last_update_date              => p_last_update_date
    ,p_last_updated_by               => p_last_updated_by
    ,p_last_update_login             => p_last_update_login
    ,p_created_by                    => p_created_by
    ,p_creation_date                 => p_creation_date
    ,p_information_category          => p_information_category
    ,p_information1                  => p_information1
    ,p_information2                  => p_information2
    ,p_information3                  => p_information3
    ,p_information4                  => p_information4
    ,p_information5                  => p_information5
    ,p_information6                  => p_information6
    ,p_information7                  => p_information7
    ,p_information8                  => p_information8
    ,p_information9                  => p_information9
    ,p_information10                 => p_information10
    ,p_information11                 => p_information11
    ,p_information12                 => p_information12
    ,p_information13                 => p_information13
    ,p_information14                 => p_information14
    ,p_information15                 => p_information15
    ,p_information16                 => p_information16
    ,p_information17                 => p_information17
    ,p_information18                 => p_information18
    ,p_information19                 => p_information19
    ,p_information20 	             => p_information20
    ,p_pay_basis_id                  => l_pay_basis_id
    ,p_object_version_number         => l_object_version_number
      );

Line: 361


procedure update_salary_basis
  (P_VALIDATE			    IN	  BOOLEAN default false
   ,P_PAY_BASIS_ID                  IN    NUMBER
   ,P_INPUT_VALUE_ID                IN    NUMBER default hr_api.g_number
   ,P_RATE_ID                       IN    NUMBER default hr_api.g_number
   ,P_NAME                          IN    VARCHAR2 default hr_api.g_varchar2
   ,P_PAY_BASIS                     IN    VARCHAR2 default hr_api.g_varchar2
   ,P_RATE_BASIS                    IN    VARCHAR2 default hr_api.g_varchar2
   ,P_PAY_ANNUALIZATION_FACTOR      IN    NUMBER default hr_api.g_number
   ,P_GRADE_ANNUALIZATION_FACTOR    IN    NUMBER default hr_api.g_number
   ,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_INFORMATION_CATEGORY          IN    VARCHAR2 default hr_api.g_varchar2
   ,P_INFORMATION1                  IN    VARCHAR2 default hr_api.g_varchar2
   ,P_INFORMATION2                  IN    VARCHAR2 default hr_api.g_varchar2
   ,P_INFORMATION3                  IN    VARCHAR2 default hr_api.g_varchar2
   ,P_INFORMATION4                  IN    VARCHAR2 default hr_api.g_varchar2
   ,P_INFORMATION5                  IN    VARCHAR2 default hr_api.g_varchar2
   ,P_INFORMATION6                  IN    VARCHAR2 default hr_api.g_varchar2
   ,P_INFORMATION7                  IN    VARCHAR2 default hr_api.g_varchar2
   ,P_INFORMATION8                  IN    VARCHAR2 default hr_api.g_varchar2
   ,P_INFORMATION9                  IN    VARCHAR2 default hr_api.g_varchar2
   ,P_INFORMATION10                 IN    VARCHAR2 default hr_api.g_varchar2
   ,P_INFORMATION11                 IN    VARCHAR2 default hr_api.g_varchar2
   ,P_INFORMATION12                 IN    VARCHAR2 default hr_api.g_varchar2
   ,P_INFORMATION13                 IN    VARCHAR2 default hr_api.g_varchar2
   ,P_INFORMATION14                 IN    VARCHAR2 default hr_api.g_varchar2
   ,P_INFORMATION15                 IN    VARCHAR2 default hr_api.g_varchar2
   ,P_INFORMATION16                 IN    VARCHAR2 default hr_api.g_varchar2
   ,P_INFORMATION17                 IN    VARCHAR2 default hr_api.g_varchar2
   ,P_INFORMATION18                 IN    VARCHAR2 default hr_api.g_varchar2
   ,P_INFORMATION19                 IN    VARCHAR2 default hr_api.g_varchar2
   ,P_INFORMATION20                 IN    VARCHAR2 default hr_api.g_varchar2
   ,P_LAST_UPDATE_DATE              IN    DATE default hr_api.g_date
   ,P_LAST_UPDATED_BY               IN    NUMBER default hr_api.g_number
   ,P_LAST_UPDATE_LOGIN             IN    NUMBER default hr_api.g_number
   ,P_CREATED_BY                    IN    NUMBER default hr_api.g_number
   ,P_CREATION_DATE                 IN    DATE default hr_api.g_date
   ,P_OBJECT_VERSION_NUMBER	    IN OUT nocopy NUMBER
    ) is
--
-- Declare cursors and local variables
--
    --
  l_object_version_number      per_pay_bases.object_version_number%TYPE;

Line: 429


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

Line: 446


   savepoint update_salary_basis;

Line: 470


   hr_utility.set_location('Entering: call - update_salary_basis_b',35);

Line: 477


     hr_salary_basis_bk2.update_salary_basis_b
      (p_pay_basis_id	               => p_pay_basis_id
      ,p_input_value_id                => p_input_value_id
      ,p_rate_id		       => p_rate_id
      ,p_name			       => p_name
      ,p_pay_basis		       => p_pay_basis
      ,p_rate_basis 		       => p_rate_basis
      ,p_pay_annualization_factor      => p_pay_annualization_factor
      ,p_grade_annualization_factor    => p_grade_annualization_factor
      ,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_last_update_date              => p_last_update_date
      ,p_last_updated_by               => p_last_updated_by
      ,p_last_update_login             => p_last_update_login
      ,p_created_by                    => p_created_by
      ,p_creation_date                 => p_creation_date
      ,p_information_category          => p_information_category
      ,p_information1                  => p_information1
      ,p_information2                  => p_information2
      ,p_information3                  => p_information3
      ,p_information4                  => p_information4
      ,p_information5                  => p_information5
      ,p_information6                  => p_information6
      ,p_information7                  => p_information7
      ,p_information8                  => p_information8
      ,p_information9                  => p_information9
      ,p_information10                 => p_information10
      ,p_information11                 => p_information11
      ,p_information12                 => p_information12
      ,p_information13                 => p_information13
      ,p_information14                 => p_information14
      ,p_information15                 => p_information15
      ,p_information16                 => p_information16
      ,p_information17                 => p_information17
      ,p_information18                 => p_information18
      ,p_information19                 => p_information19
      ,p_information20                 => p_information20
      ,p_object_version_number	       => l_object_version_number
      );

Line: 540


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

Line: 550


    select business_group_id
    into l_business_group_id
    from per_pay_bases
    where pay_basis_id = p_pay_basis_id;

Line: 611


  hr_utility.set_location('Entering: call - update_salary_basis_a',55);

Line: 615


  hr_salary_basis_bk2.update_salary_basis_a
     (p_pay_basis_id	               => p_pay_basis_id
      ,p_input_value_id                => p_input_value_id
      ,p_rate_id		       => p_rate_id
      ,p_name			       => p_name
      ,p_pay_basis		       => p_pay_basis
      ,p_rate_basis 		       => p_rate_basis
      ,p_pay_annualization_factor      => p_pay_annualization_factor
      ,p_grade_annualization_factor    => p_grade_annualization_factor
      ,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_last_update_date              => p_last_update_date
      ,p_last_updated_by               => p_last_updated_by
      ,p_last_update_login             => p_last_update_login
      ,p_created_by                    => p_created_by
      ,p_creation_date                 => p_creation_date
      ,p_information_category          => p_information_category
      ,p_information1                  => p_information1
      ,p_information2                  => p_information2
      ,p_information3                  => p_information3
      ,p_information4                  => p_information4
      ,p_information5                  => p_information5
      ,p_information6                  => p_information6
      ,p_information7                  => p_information7
      ,p_information8                  => p_information8
      ,p_information9                  => p_information9
      ,p_information10                 => p_information10
      ,p_information11                 => p_information11
      ,p_information12                 => p_information12
      ,p_information13                 => p_information13
      ,p_information14                 => p_information14
      ,p_information15                 => p_information15
      ,p_information16                 => p_information16
      ,p_information17                 => p_information17
      ,p_information18                 => p_information18
      ,p_information19                 => p_information19
      ,p_information20                 => p_information20
      ,p_object_version_number	       => l_object_version_number
     );

Line: 677


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

Line: 680


   end; -- End of API User Hook for the after hook of update_salary_basis

Line: 701


   ROLLBACK TO update_salary_basis;

Line: 714


   rollback to update_salary_basis;

Line: 717


end update_salary_basis;

Line: 723


procedure delete_salary_basis
  (p_validate                      in     boolean default false
  ,p_pay_basis_id                  in     number
  ,p_object_version_number         in out nocopy number) IS

  l_object_version_number       number(9);

Line: 729


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

Line: 736


  savepoint delete_salary_basis;

Line: 742


  hr_salary_basis_bk3.delete_salary_basis_b
    (p_validate                   =>  p_validate
    ,p_pay_basis_id               =>  p_pay_basis_id
    ,p_object_version_number      =>  p_object_version_number
    );

Line: 750


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

Line: 765


  hr_salary_basis_bk3.delete_salary_basis_a
    (p_validate                   =>  p_validate
    ,p_pay_basis_id                   =>  p_pay_basis_id
    ,p_object_version_number      =>  l_object_version_number);

Line: 772


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

Line: 795


    rollback to delete_salary_basis;

Line: 806


    rollback to delete_salary_basis;

Line: 809


end delete_salary_basis;