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

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

Line: 288


procedure update_balance_category
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_datetrack_update_mode         in     varchar2
  ,p_balance_category_id           in     number
  ,p_object_version_number         in out nocopy number
  ,p_business_group_id             in     number   default hr_api.g_number
  ,p_legislation_code              in     varchar2 default hr_api.g_varchar2
  ,p_save_run_balance_enabled      in     varchar2 default hr_api.g_varchar2
  ,p_user_category_name            in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information_category      in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information1              in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information2              in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information3              in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information4              in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information5              in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information6              in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information7              in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information8              in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information9              in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information10             in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information11             in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information12             in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information13             in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information14             in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information15             in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information16             in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information17             in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information18             in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information19             in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information20             in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information21             in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information22             in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information23             in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information24             in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information25             in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information26             in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information27             in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information28             in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information29             in     varchar2 default hr_api.g_varchar2
  ,p_pbc_information30             in     varchar2 default hr_api.g_varchar2
  ,p_effective_start_date             out nocopy date
  ,p_effective_end_date               out nocopy date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'update_balance_category';

Line: 353


  savepoint update_balance_category;

Line: 363


    pay_balance_category_bk2.update_balance_category_b
      (p_effective_date                => l_effective_date
      ,p_datetrack_update_mode         => p_datetrack_update_mode
      ,p_balance_category_id           => p_balance_category_id
      ,p_object_version_number         => p_object_version_number
      ,p_save_run_balance_enabled      => p_save_run_balance_enabled
      ,p_user_category_name            => p_user_category_name
      ,p_pbc_information_category      => p_pbc_information_category
      ,p_pbc_information1              => p_pbc_information1
      ,p_pbc_information2              => p_pbc_information2
      ,p_pbc_information3              => p_pbc_information3
      ,p_pbc_information4              => p_pbc_information4
      ,p_pbc_information5              => p_pbc_information5
      ,p_pbc_information6              => p_pbc_information6
      ,p_pbc_information7              => p_pbc_information7
      ,p_pbc_information8              => p_pbc_information8
      ,p_pbc_information9              => p_pbc_information9
      ,p_pbc_information10             => p_pbc_information10
      ,p_pbc_information11             => p_pbc_information11
      ,p_pbc_information12             => p_pbc_information12
      ,p_pbc_information13             => p_pbc_information13
      ,p_pbc_information14             => p_pbc_information14
      ,p_pbc_information15             => p_pbc_information15
      ,p_pbc_information16             => p_pbc_information16
      ,p_pbc_information17             => p_pbc_information17
      ,p_pbc_information18             => p_pbc_information18
      ,p_pbc_information19             => p_pbc_information19
      ,p_pbc_information20             => p_pbc_information20
      ,p_pbc_information21             => p_pbc_information21
      ,p_pbc_information22             => p_pbc_information22
      ,p_pbc_information23             => p_pbc_information23
      ,p_pbc_information24             => p_pbc_information24
      ,p_pbc_information25             => p_pbc_information25
      ,p_pbc_information26             => p_pbc_information26
      ,p_pbc_information27             => p_pbc_information27
      ,p_pbc_information28             => p_pbc_information28
      ,p_pbc_information29             => p_pbc_information29
      ,p_pbc_information30             => p_pbc_information30
      );

Line: 405


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

Line: 421


      ,p_datetrack_mode                => p_datetrack_update_mode
      ,p_balance_category_id           => p_balance_category_id
      ,p_object_version_number         => p_object_version_number
      ,p_save_run_balance_enabled      => p_save_run_balance_enabled
      ,p_user_category_name            => p_user_category_name
      ,p_pbc_information_category      => p_pbc_information_category
      ,p_pbc_information1              => p_pbc_information1
      ,p_pbc_information2              => p_pbc_information2
      ,p_pbc_information3              => p_pbc_information3
      ,p_pbc_information4              => p_pbc_information4
      ,p_pbc_information5              => p_pbc_information5
      ,p_pbc_information6              => p_pbc_information6
      ,p_pbc_information7              => p_pbc_information7
      ,p_pbc_information8              => p_pbc_information8
      ,p_pbc_information9              => p_pbc_information9
      ,p_pbc_information10             => p_pbc_information10
      ,p_pbc_information11             => p_pbc_information11
      ,p_pbc_information12             => p_pbc_information12
      ,p_pbc_information13             => p_pbc_information13
      ,p_pbc_information14             => p_pbc_information14
      ,p_pbc_information15             => p_pbc_information15
      ,p_pbc_information16             => p_pbc_information16
      ,p_pbc_information17             => p_pbc_information17
      ,p_pbc_information18             => p_pbc_information18
      ,p_pbc_information19             => p_pbc_information19
      ,p_pbc_information20             => p_pbc_information20
      ,p_pbc_information21             => p_pbc_information21
      ,p_pbc_information22             => p_pbc_information22
      ,p_pbc_information23             => p_pbc_information23
      ,p_pbc_information24             => p_pbc_information24
      ,p_pbc_information25             => p_pbc_information25
      ,p_pbc_information26             => p_pbc_information26
      ,p_pbc_information27             => p_pbc_information27
      ,p_pbc_information28             => p_pbc_information28
      ,p_pbc_information29             => p_pbc_information29
      ,p_pbc_information30             => p_pbc_information30
      ,p_effective_start_date          => l_effective_start_date
      ,p_effective_end_date            => l_effective_end_date
      );

Line: 466


    pay_balance_category_bk2.update_balance_category_a
      (p_effective_date                => l_effective_date
      ,p_datetrack_update_mode         => p_datetrack_update_mode
      ,p_balance_category_id           => p_balance_category_id
      ,p_object_version_number         => p_object_version_number
      ,p_save_run_balance_enabled      => p_save_run_balance_enabled
      ,p_user_category_name            => p_user_category_name
      ,p_pbc_information_category      => p_pbc_information_category
      ,p_pbc_information1              => p_pbc_information1
      ,p_pbc_information2              => p_pbc_information2
      ,p_pbc_information3              => p_pbc_information3
      ,p_pbc_information4              => p_pbc_information4
      ,p_pbc_information5              => p_pbc_information5
      ,p_pbc_information6              => p_pbc_information6
      ,p_pbc_information7              => p_pbc_information7
      ,p_pbc_information8              => p_pbc_information8
      ,p_pbc_information9              => p_pbc_information9
      ,p_pbc_information10             => p_pbc_information10
      ,p_pbc_information11             => p_pbc_information11
      ,p_pbc_information12             => p_pbc_information12
      ,p_pbc_information13             => p_pbc_information13
      ,p_pbc_information14             => p_pbc_information14
      ,p_pbc_information15             => p_pbc_information15
      ,p_pbc_information16             => p_pbc_information16
      ,p_pbc_information17             => p_pbc_information17
      ,p_pbc_information18             => p_pbc_information18
      ,p_pbc_information19             => p_pbc_information19
      ,p_pbc_information20             => p_pbc_information20
      ,p_pbc_information21             => p_pbc_information21
      ,p_pbc_information22             => p_pbc_information22
      ,p_pbc_information23             => p_pbc_information23
      ,p_pbc_information24             => p_pbc_information24
      ,p_pbc_information25             => p_pbc_information25
      ,p_pbc_information26             => p_pbc_information26
      ,p_pbc_information27             => p_pbc_information27
      ,p_pbc_information28             => p_pbc_information28
      ,p_pbc_information29             => p_pbc_information29
      ,p_pbc_information30             => p_pbc_information30
      ,p_effective_start_date          => l_effective_start_date
      ,p_effective_end_date            => l_effective_end_date
      );

Line: 510


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

Line: 554


    rollback to update_balance_category;

Line: 558


end update_balance_category;

Line: 564


procedure delete_balance_category
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_datetrack_delete_mode         in     varchar2
  ,p_balance_category_id           in     number
  ,p_object_version_number         in out nocopy number
  ,p_business_group_id             in     number   default hr_api.g_number
  ,p_legislation_code              in     varchar2 default hr_api.g_varchar2
  ,p_effective_start_date             out nocopy date
  ,p_effective_end_date               out nocopy date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc               varchar2(72) := g_package||'delete_balance_category';

Line: 593


  savepoint delete_balance_category;

Line: 603


    pay_balance_category_bk3.delete_balance_category_b
      (p_effective_date                => l_effective_date
      ,p_datetrack_delete_mode         => p_datetrack_delete_mode
      ,p_balance_category_id           => p_balance_category_id
      ,p_object_version_number         => p_object_version_number
      ,p_business_group_id             => p_business_group_id
      ,p_legislation_code              => p_legislation_code
      );

Line: 614


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

Line: 641


       ,p_datetrack_mode        => p_datetrack_delete_mode
       ,p_balance_category_id   => p_balance_category_id
       ,p_object_version_number => p_object_version_number
       ,p_effective_start_date  => l_effective_start_date
       ,p_effective_end_date    => l_effective_end_date
       );

Line: 653


   pay_balance_category_bk3.delete_balance_category_a
      (p_effective_date        => l_effective_date
      ,p_datetrack_delete_mode => p_datetrack_delete_mode
      ,p_balance_category_id   => p_balance_category_id
      ,p_object_version_number => p_object_version_number
      ,p_business_group_id     => p_business_group_id
      ,p_legislation_code      => p_legislation_code
      ,p_effective_start_date  => l_effective_start_date
      ,p_effective_end_date    => l_effective_end_date
      );

Line: 666


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

Line: 691


    rollback to delete_balance_category;

Line: 706


    rollback to delete_balance_category;

Line: 709


end delete_balance_category;