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

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

Line: 293


procedure update_Contribution_History
  (p_validate                       in  boolean   default false
  ,p_contr_history_id               in  number
  ,p_person_id                      in  number    default hr_api.g_number
  ,p_date_from                      in  date      default hr_api.g_date
  ,p_date_to                        in  date      default hr_api.g_date
  ,p_contr_type                     in  varchar2  default hr_api.g_varchar2
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_legislation_code               in  varchar2  default hr_api.g_varchar2
  ,p_amt_contr                      in  number    default hr_api.g_number
  ,p_max_contr_allowed              in  number    default hr_api.g_number
  ,p_includable_comp                in  number    default hr_api.g_number
  ,p_tax_unit_id                    in  number    default hr_api.g_number
  ,p_source_system                  in  varchar2  default hr_api.g_varchar2
  ,p_contr_information_category     in  varchar2  default hr_api.g_varchar2
  ,p_contr_information1             in  varchar2  default hr_api.g_varchar2
  ,p_contr_information2             in  varchar2  default hr_api.g_varchar2
  ,p_contr_information3             in  varchar2  default hr_api.g_varchar2
  ,p_contr_information4             in  varchar2  default hr_api.g_varchar2
  ,p_contr_information5             in  varchar2  default hr_api.g_varchar2
  ,p_contr_information6             in  varchar2  default hr_api.g_varchar2
  ,p_contr_information7             in  varchar2  default hr_api.g_varchar2
  ,p_contr_information8             in  varchar2  default hr_api.g_varchar2
  ,p_contr_information9             in  varchar2  default hr_api.g_varchar2
  ,p_contr_information10            in  varchar2  default hr_api.g_varchar2
  ,p_contr_information11            in  varchar2  default hr_api.g_varchar2
  ,p_contr_information12            in  varchar2  default hr_api.g_varchar2
  ,p_contr_information13            in  varchar2  default hr_api.g_varchar2
  ,p_contr_information14            in  varchar2  default hr_api.g_varchar2
  ,p_contr_information15            in  varchar2  default hr_api.g_varchar2
  ,p_contr_information16            in  varchar2  default hr_api.g_varchar2
  ,p_contr_information17            in  varchar2  default hr_api.g_varchar2
  ,p_contr_information18            in  varchar2  default hr_api.g_varchar2
  ,p_contr_information19            in  varchar2  default hr_api.g_varchar2
  ,p_contr_information20            in  varchar2  default hr_api.g_varchar2
  ,p_contr_information21            in  varchar2  default hr_api.g_varchar2
  ,p_contr_information22            in  varchar2  default hr_api.g_varchar2
  ,p_contr_information23            in  varchar2  default hr_api.g_varchar2
  ,p_contr_information24            in  varchar2  default hr_api.g_varchar2
  ,p_contr_information25            in  varchar2  default hr_api.g_varchar2
  ,p_contr_information26            in  varchar2  default hr_api.g_varchar2
  ,p_contr_information27            in  varchar2  default hr_api.g_varchar2
  ,p_contr_information28            in  varchar2  default hr_api.g_varchar2
  ,p_contr_information29            in  varchar2  default hr_api.g_varchar2
  ,p_contr_information30            in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_Contribution_History';

Line: 352


  savepoint update_Contribution_History;

Line: 364


    pay_Contribution_History_bk2.update_Contribution_History_b
      (
       p_contr_history_id               =>  p_contr_history_id
      ,p_person_id                      =>  p_person_id
      ,p_date_from                      =>  p_date_from
      ,p_date_to                        =>  p_date_to
      ,p_contr_type                     =>  p_contr_type
      ,p_business_group_id              =>  p_business_group_id
      ,p_legislation_code               =>  p_legislation_code
      ,p_amt_contr                      =>  p_amt_contr
      ,p_max_contr_allowed              =>  p_max_contr_allowed
      ,p_includable_comp                =>  p_includable_comp
      ,p_tax_unit_id                    =>  p_tax_unit_id
      ,p_source_system                  =>  p_source_system
      ,p_contr_information_category     =>  p_contr_information_category
      ,p_contr_information1             =>  p_contr_information1
      ,p_contr_information2             =>  p_contr_information2
      ,p_contr_information3             =>  p_contr_information3
      ,p_contr_information4             =>  p_contr_information4
      ,p_contr_information5             =>  p_contr_information5
      ,p_contr_information6             =>  p_contr_information6
      ,p_contr_information7             =>  p_contr_information7
      ,p_contr_information8             =>  p_contr_information8
      ,p_contr_information9             =>  p_contr_information9
      ,p_contr_information10            =>  p_contr_information10
      ,p_contr_information11            =>  p_contr_information11
      ,p_contr_information12            =>  p_contr_information12
      ,p_contr_information13            =>  p_contr_information13
      ,p_contr_information14            =>  p_contr_information14
      ,p_contr_information15            =>  p_contr_information15
      ,p_contr_information16            =>  p_contr_information16
      ,p_contr_information17            =>  p_contr_information17
      ,p_contr_information18            =>  p_contr_information18
      ,p_contr_information19            =>  p_contr_information19
      ,p_contr_information20            =>  p_contr_information20
      ,p_contr_information21            =>  p_contr_information21
      ,p_contr_information22            =>  p_contr_information22
      ,p_contr_information23            =>  p_contr_information23
      ,p_contr_information24            =>  p_contr_information24
      ,p_contr_information25            =>  p_contr_information25
      ,p_contr_information26            =>  p_contr_information26
      ,p_contr_information27            =>  p_contr_information27
      ,p_contr_information28            =>  p_contr_information28
      ,p_contr_information29            =>  p_contr_information29
      ,p_contr_information30            =>  p_contr_information30
      ,p_object_version_number          =>  p_object_version_number
      );

Line: 414


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

Line: 474


    pay_Contribution_History_bk2.update_Contribution_History_a
      (
       p_contr_history_id               =>  p_contr_history_id
      ,p_person_id                      =>  p_person_id
      ,p_date_from                      =>  p_date_from
      ,p_date_to                        =>  p_date_to
      ,p_contr_type                     =>  p_contr_type
      ,p_business_group_id              =>  p_business_group_id
      ,p_legislation_code               =>  p_legislation_code
      ,p_amt_contr                      =>  p_amt_contr
      ,p_max_contr_allowed              =>  p_max_contr_allowed
      ,p_includable_comp                =>  p_includable_comp
      ,p_tax_unit_id                    =>  p_tax_unit_id
      ,p_source_system                  =>  p_source_system
      ,p_contr_information_category     =>  p_contr_information_category
      ,p_contr_information1             =>  p_contr_information1
      ,p_contr_information2             =>  p_contr_information2
      ,p_contr_information3             =>  p_contr_information3
      ,p_contr_information4             =>  p_contr_information4
      ,p_contr_information5             =>  p_contr_information5
      ,p_contr_information6             =>  p_contr_information6
      ,p_contr_information7             =>  p_contr_information7
      ,p_contr_information8             =>  p_contr_information8
      ,p_contr_information9             =>  p_contr_information9
      ,p_contr_information10            =>  p_contr_information10
      ,p_contr_information11            =>  p_contr_information11
      ,p_contr_information12            =>  p_contr_information12
      ,p_contr_information13            =>  p_contr_information13
      ,p_contr_information14            =>  p_contr_information14
      ,p_contr_information15            =>  p_contr_information15
      ,p_contr_information16            =>  p_contr_information16
      ,p_contr_information17            =>  p_contr_information17
      ,p_contr_information18            =>  p_contr_information18
      ,p_contr_information19            =>  p_contr_information19
      ,p_contr_information20            =>  p_contr_information20
      ,p_contr_information21            =>  p_contr_information21
      ,p_contr_information22            =>  p_contr_information22
      ,p_contr_information23            =>  p_contr_information23
      ,p_contr_information24            =>  p_contr_information24
      ,p_contr_information25            =>  p_contr_information25
      ,p_contr_information26            =>  p_contr_information26
      ,p_contr_information27            =>  p_contr_information27
      ,p_contr_information28            =>  p_contr_information28
      ,p_contr_information29            =>  p_contr_information29
      ,p_contr_information30            =>  p_contr_information30
      ,p_object_version_number          =>  l_object_version_number
      );

Line: 524


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

Line: 553


    ROLLBACK TO update_Contribution_History;

Line: 565


    ROLLBACK TO update_Contribution_History;

Line: 568


end update_Contribution_History;

Line: 573


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

Line: 590


  savepoint delete_Contribution_History;

Line: 603


    pay_Contribution_History_bk3.delete_Contribution_History_b
      (
       p_contr_history_id               =>  p_contr_history_id
      ,p_object_version_number          =>  p_object_version_number
      );

Line: 611


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

Line: 629


    pay_Contribution_History_bk3.delete_Contribution_History_a
      (
       p_contr_history_id               =>  p_contr_history_id
      ,p_object_version_number          =>  l_object_version_number
      );

Line: 637


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

Line: 662


    ROLLBACK TO delete_Contribution_History;

Line: 673


    ROLLBACK TO delete_Contribution_History;

Line: 676


end delete_Contribution_History;