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

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

Line: 277


procedure update_Aplcn_To_Benefit_Pool
  (p_validate                       in  boolean   default false
  ,p_aplcn_to_bnft_pool_id          in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_acty_base_rt_id                in  number    default hr_api.g_number
  ,p_bnft_prvdr_pool_id             in  number    default hr_api.g_number
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_abp_attribute_category         in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute1                 in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute2                 in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute3                 in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute4                 in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute5                 in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute6                 in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute7                 in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute8                 in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute9                 in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute10                in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute11                in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute12                in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute13                in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute14                in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute15                in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute16                in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute17                in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute18                in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute19                in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute20                in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute21                in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute22                in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute23                in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute24                in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute25                in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute26                in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute27                in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute28                in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute29                in  varchar2  default hr_api.g_varchar2
  ,p_abp_attribute30                in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_Aplcn_To_Benefit_Pool';

Line: 334


  savepoint update_Aplcn_To_Benefit_Pool;

Line: 346


    ben_Aplcn_To_Benefit_Pool_bk2.update_Aplcn_To_Benefit_Pool_b
      (
       p_aplcn_to_bnft_pool_id          =>  p_aplcn_to_bnft_pool_id
      ,p_acty_base_rt_id                =>  p_acty_base_rt_id
      ,p_bnft_prvdr_pool_id             =>  p_bnft_prvdr_pool_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_abp_attribute_category         =>  p_abp_attribute_category
      ,p_abp_attribute1                 =>  p_abp_attribute1
      ,p_abp_attribute2                 =>  p_abp_attribute2
      ,p_abp_attribute3                 =>  p_abp_attribute3
      ,p_abp_attribute4                 =>  p_abp_attribute4
      ,p_abp_attribute5                 =>  p_abp_attribute5
      ,p_abp_attribute6                 =>  p_abp_attribute6
      ,p_abp_attribute7                 =>  p_abp_attribute7
      ,p_abp_attribute8                 =>  p_abp_attribute8
      ,p_abp_attribute9                 =>  p_abp_attribute9
      ,p_abp_attribute10                =>  p_abp_attribute10
      ,p_abp_attribute11                =>  p_abp_attribute11
      ,p_abp_attribute12                =>  p_abp_attribute12
      ,p_abp_attribute13                =>  p_abp_attribute13
      ,p_abp_attribute14                =>  p_abp_attribute14
      ,p_abp_attribute15                =>  p_abp_attribute15
      ,p_abp_attribute16                =>  p_abp_attribute16
      ,p_abp_attribute17                =>  p_abp_attribute17
      ,p_abp_attribute18                =>  p_abp_attribute18
      ,p_abp_attribute19                =>  p_abp_attribute19
      ,p_abp_attribute20                =>  p_abp_attribute20
      ,p_abp_attribute21                =>  p_abp_attribute21
      ,p_abp_attribute22                =>  p_abp_attribute22
      ,p_abp_attribute23                =>  p_abp_attribute23
      ,p_abp_attribute24                =>  p_abp_attribute24
      ,p_abp_attribute25                =>  p_abp_attribute25
      ,p_abp_attribute26                =>  p_abp_attribute26
      ,p_abp_attribute27                =>  p_abp_attribute27
      ,p_abp_attribute28                =>  p_abp_attribute28
      ,p_abp_attribute29                =>  p_abp_attribute29
      ,p_abp_attribute30                =>  p_abp_attribute30
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
    ,p_datetrack_mode                      => p_datetrack_mode
      );

Line: 390


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

Line: 446


    ben_Aplcn_To_Benefit_Pool_bk2.update_Aplcn_To_Benefit_Pool_a
      (
       p_aplcn_to_bnft_pool_id          =>  p_aplcn_to_bnft_pool_id
      ,p_effective_start_date           =>  l_effective_start_date
      ,p_effective_end_date             =>  l_effective_end_date
      ,p_acty_base_rt_id                =>  p_acty_base_rt_id
      ,p_bnft_prvdr_pool_id             =>  p_bnft_prvdr_pool_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_abp_attribute_category         =>  p_abp_attribute_category
      ,p_abp_attribute1                 =>  p_abp_attribute1
      ,p_abp_attribute2                 =>  p_abp_attribute2
      ,p_abp_attribute3                 =>  p_abp_attribute3
      ,p_abp_attribute4                 =>  p_abp_attribute4
      ,p_abp_attribute5                 =>  p_abp_attribute5
      ,p_abp_attribute6                 =>  p_abp_attribute6
      ,p_abp_attribute7                 =>  p_abp_attribute7
      ,p_abp_attribute8                 =>  p_abp_attribute8
      ,p_abp_attribute9                 =>  p_abp_attribute9
      ,p_abp_attribute10                =>  p_abp_attribute10
      ,p_abp_attribute11                =>  p_abp_attribute11
      ,p_abp_attribute12                =>  p_abp_attribute12
      ,p_abp_attribute13                =>  p_abp_attribute13
      ,p_abp_attribute14                =>  p_abp_attribute14
      ,p_abp_attribute15                =>  p_abp_attribute15
      ,p_abp_attribute16                =>  p_abp_attribute16
      ,p_abp_attribute17                =>  p_abp_attribute17
      ,p_abp_attribute18                =>  p_abp_attribute18
      ,p_abp_attribute19                =>  p_abp_attribute19
      ,p_abp_attribute20                =>  p_abp_attribute20
      ,p_abp_attribute21                =>  p_abp_attribute21
      ,p_abp_attribute22                =>  p_abp_attribute22
      ,p_abp_attribute23                =>  p_abp_attribute23
      ,p_abp_attribute24                =>  p_abp_attribute24
      ,p_abp_attribute25                =>  p_abp_attribute25
      ,p_abp_attribute26                =>  p_abp_attribute26
      ,p_abp_attribute27                =>  p_abp_attribute27
      ,p_abp_attribute28                =>  p_abp_attribute28
      ,p_abp_attribute29                =>  p_abp_attribute29
      ,p_abp_attribute30                =>  p_abp_attribute30
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                     => trunc(p_effective_date)
      ,p_datetrack_mode                     => p_datetrack_mode
      );

Line: 492


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

Line: 523


    ROLLBACK TO update_Aplcn_To_Benefit_Pool;

Line: 535


    ROLLBACK TO update_Aplcn_To_Benefit_Pool;

Line: 538


end update_Aplcn_To_Benefit_Pool;

Line: 543


procedure delete_Aplcn_To_Benefit_Pool
  (p_validate                       in  boolean  default false
  ,p_aplcn_to_bnft_pool_id          in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_Aplcn_To_Benefit_Pool';

Line: 566


  savepoint delete_Aplcn_To_Benefit_Pool;

Line: 579


    ben_Aplcn_To_Benefit_Pool_bk3.delete_Aplcn_To_Benefit_Pool_b
      (
       p_aplcn_to_bnft_pool_id          =>  p_aplcn_to_bnft_pool_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
    ,p_datetrack_mode                      => p_datetrack_mode
      );

Line: 589


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

Line: 611


    ben_Aplcn_To_Benefit_Pool_bk3.delete_Aplcn_To_Benefit_Pool_a
      (
       p_aplcn_to_bnft_pool_id          =>  p_aplcn_to_bnft_pool_id
      ,p_effective_start_date           =>  l_effective_start_date
      ,p_effective_end_date             =>  l_effective_end_date
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
    ,p_datetrack_mode                      => p_datetrack_mode
      );

Line: 623


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

Line: 648


    ROLLBACK TO delete_Aplcn_To_Benefit_Pool;

Line: 661


    ROLLBACK TO delete_Aplcn_To_Benefit_Pool;

Line: 664


end delete_Aplcn_To_Benefit_Pool;