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

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

Line: 59


    select null from
         ben_vrbl_rt_elig_prfl_f vep
    where
          vep.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
     and  vep.eligy_prfl_id    = p_eligy_prfl_id
     and  p_effective_date between vep.effective_start_date and
                                   vep.effective_end_date ;

Line: 68


    select vrbl_rt_elig_prfl_id, vep.effective_end_date from
         ben_vrbl_rt_elig_prfl_f vep
    where
      vep.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
     and  vep.eligy_prfl_id    = p_eligy_prfl_id
     and  vep.effective_start_date  > p_effective_date ;

Line: 106


      hr_utility.set_location('Record already exists. no need to insert another record', 20 ) ;

Line: 124


      update ben_vrbl_rt_elig_prfl_f
      set effective_start_date = p_effective_date
      where vrbl_rt_elig_prfl_id = l_future_vrbl_rt_elig_prfl_id ;

Line: 360


procedure update_vrbl_rt_elig_prfl
  (p_validate                       in  boolean   default false
  ,p_vrbl_rt_elig_prfl_id                       in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_vrbl_rt_prfl_id                      in  number    default hr_api.g_number
  ,p_eligy_prfl_id                         in  number    default hr_api.g_number
  ,p_mndtry_flag                     in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute_category         in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute1                 in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute2                 in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute3                 in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute4                 in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute5                 in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute6                 in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute7                 in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute8                 in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute9                 in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute10                in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute11                in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute12                in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute13                in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute14                in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute15                in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute16                in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute17                in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute18                in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute19                in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute20                in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute21                in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute22                in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute23                in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute24                in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute25                in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute26                in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute27                in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute28                in  varchar2  default hr_api.g_varchar2
  ,p_vep_attribute29                in  varchar2  default hr_api.g_varchar2
  ,p_vep_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_vrbl_rt_elig_prfl';

Line: 418


  savepoint update_vrbl_rt_elig_prfl;

Line: 430


    ben_vrbl_rt_elig_prfl_bk2.update_vrbl_rt_elig_prfl_b
      (
       p_vrbl_rt_elig_prfl_id                       =>  p_vrbl_rt_elig_prfl_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_vrbl_rt_prfl_id                      =>  p_vrbl_rt_prfl_id
      ,p_eligy_prfl_id                         =>  p_eligy_prfl_id
      ,p_mndtry_flag                    =>  p_mndtry_flag
      ,p_vep_attribute_category         =>  p_vep_attribute_category
      ,p_vep_attribute1                 =>  p_vep_attribute1
      ,p_vep_attribute2                 =>  p_vep_attribute2
      ,p_vep_attribute3                 =>  p_vep_attribute3
      ,p_vep_attribute4                 =>  p_vep_attribute4
      ,p_vep_attribute5                 =>  p_vep_attribute5
      ,p_vep_attribute6                 =>  p_vep_attribute6
      ,p_vep_attribute7                 =>  p_vep_attribute7
      ,p_vep_attribute8                 =>  p_vep_attribute8
      ,p_vep_attribute9                 =>  p_vep_attribute9
      ,p_vep_attribute10                =>  p_vep_attribute10
      ,p_vep_attribute11                =>  p_vep_attribute11
      ,p_vep_attribute12                =>  p_vep_attribute12
      ,p_vep_attribute13                =>  p_vep_attribute13
      ,p_vep_attribute14                =>  p_vep_attribute14
      ,p_vep_attribute15                =>  p_vep_attribute15
      ,p_vep_attribute16                =>  p_vep_attribute16
      ,p_vep_attribute17                =>  p_vep_attribute17
      ,p_vep_attribute18                =>  p_vep_attribute18
      ,p_vep_attribute19                =>  p_vep_attribute19
      ,p_vep_attribute20                =>  p_vep_attribute20
      ,p_vep_attribute21                =>  p_vep_attribute21
      ,p_vep_attribute22                =>  p_vep_attribute22
      ,p_vep_attribute23                =>  p_vep_attribute23
      ,p_vep_attribute24                =>  p_vep_attribute24
      ,p_vep_attribute25                =>  p_vep_attribute25
      ,p_vep_attribute26                =>  p_vep_attribute26
      ,p_vep_attribute27                =>  p_vep_attribute27
      ,p_vep_attribute28                =>  p_vep_attribute28
      ,p_vep_attribute29                =>  p_vep_attribute29
      ,p_vep_attribute30                =>  p_vep_attribute30
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
    ,p_datetrack_mode                      => p_datetrack_mode
      );

Line: 475


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

Line: 532


    ben_vrbl_rt_elig_prfl_bk2.update_vrbl_rt_elig_prfl_a
      (
       p_vrbl_rt_elig_prfl_id                       =>  p_vrbl_rt_elig_prfl_id
      ,p_effective_start_date           =>  l_effective_start_date
      ,p_effective_end_date             =>  l_effective_end_date
      ,p_business_group_id              =>  p_business_group_id
      ,p_vrbl_rt_prfl_id                      =>  p_vrbl_rt_prfl_id
      ,p_eligy_prfl_id                         =>  p_eligy_prfl_id
      ,p_mndtry_flag                    => p_mndtry_flag
      ,p_vep_attribute_category         =>  p_vep_attribute_category
      ,p_vep_attribute1                 =>  p_vep_attribute1
      ,p_vep_attribute2                 =>  p_vep_attribute2
      ,p_vep_attribute3                 =>  p_vep_attribute3
      ,p_vep_attribute4                 =>  p_vep_attribute4
      ,p_vep_attribute5                 =>  p_vep_attribute5
      ,p_vep_attribute6                 =>  p_vep_attribute6
      ,p_vep_attribute7                 =>  p_vep_attribute7
      ,p_vep_attribute8                 =>  p_vep_attribute8
      ,p_vep_attribute9                 =>  p_vep_attribute9
      ,p_vep_attribute10                =>  p_vep_attribute10
      ,p_vep_attribute11                =>  p_vep_attribute11
      ,p_vep_attribute12                =>  p_vep_attribute12
      ,p_vep_attribute13                =>  p_vep_attribute13
      ,p_vep_attribute14                =>  p_vep_attribute14
      ,p_vep_attribute15                =>  p_vep_attribute15
      ,p_vep_attribute16                =>  p_vep_attribute16
      ,p_vep_attribute17                =>  p_vep_attribute17
      ,p_vep_attribute18                =>  p_vep_attribute18
      ,p_vep_attribute19                =>  p_vep_attribute19
      ,p_vep_attribute20                =>  p_vep_attribute20
      ,p_vep_attribute21                =>  p_vep_attribute21
      ,p_vep_attribute22                =>  p_vep_attribute22
      ,p_vep_attribute23                =>  p_vep_attribute23
      ,p_vep_attribute24                =>  p_vep_attribute24
      ,p_vep_attribute25                =>  p_vep_attribute25
      ,p_vep_attribute26                =>  p_vep_attribute26
      ,p_vep_attribute27                =>  p_vep_attribute27
      ,p_vep_attribute28                =>  p_vep_attribute28
      ,p_vep_attribute29                =>  p_vep_attribute29
      ,p_vep_attribute30                =>  p_vep_attribute30
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                     => trunc(p_effective_date)
      ,p_datetrack_mode                     => p_datetrack_mode
      );

Line: 579


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

Line: 610


    ROLLBACK TO update_vrbl_rt_elig_prfl;

Line: 625


    ROLLBACK TO update_vrbl_rt_elig_prfl;

Line: 633


end update_vrbl_rt_elig_prfl;

Line: 638


procedure delete_vrbl_rt_elig_prfl
  (p_validate                       in  boolean  default false
  ,p_vrbl_rt_elig_prfl_id           in  number
  ,p_vrbl_rt_prfl_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_vrbl_rt_elig_prfl';

Line: 662


  savepoint delete_vrbl_rt_elig_prfl;

Line: 675


    ben_vrbl_rt_elig_prfl_bk3.delete_vrbl_rt_elig_prfl_b
      (
       p_vrbl_rt_elig_prfl_id                       =>  p_vrbl_rt_elig_prfl_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
    ,p_datetrack_mode                      => p_datetrack_mode
      );

Line: 685


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

Line: 707


    ben_vrbl_rt_elig_prfl_bk3.delete_vrbl_rt_elig_prfl_a
      (
       p_vrbl_rt_elig_prfl_id                       =>  p_vrbl_rt_elig_prfl_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: 719


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

Line: 730


    (p_event                       => 'DELETE',
     p_base_table                  => 'BEN_VRBL_RT_PRFL_F',
     p_base_table_column           => 'VRBL_RT_PRFL_ID',
     p_base_table_column_value     => p_vrbl_rt_prfl_id,
     p_base_table_reference_column => 'RT_ELIG_PRFL_FLAG',
     p_reference_table             => 'BEN_VRBL_RT_ELIG_PRFL_F',
     p_reference_table_column      => 'VRBL_RT_PRFL_ID');

Line: 753


    ROLLBACK TO delete_vrbl_rt_elig_prfl;

Line: 766


    ROLLBACK TO delete_vrbl_rt_elig_prfl;

Line: 774


end delete_vrbl_rt_elig_prfl;