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

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

Line: 278


    /* Inserted for nocopy changes */
    p_ler_enrt_ctfn_id := null;

Line: 290


procedure update_ler_enrt_ctfn
  (p_validate                       in  boolean   default false
  ,p_ler_enrt_ctfn_id               in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_rqd_flag                       in  varchar2  default hr_api.g_varchar2
  ,p_enrt_ctfn_typ_cd               in  varchar2  default hr_api.g_varchar2
  ,p_ctfn_rqd_when_rl               in  number    default hr_api.g_number
  ,p_ler_rqrs_enrt_ctfn_id          in  number    default hr_api.g_number
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_lnc_attribute_category         in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute1                 in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute2                 in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute3                 in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute4                 in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute5                 in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute6                 in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute7                 in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute8                 in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute9                 in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute10                in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute11                in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute12                in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute13                in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute14                in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute15                in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute16                in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute17                in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute18                in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute19                in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute20                in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute21                in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute22                in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute23                in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute24                in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute25                in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute26                in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute27                in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute28                in  varchar2  default hr_api.g_varchar2
  ,p_lnc_attribute29                in  varchar2  default hr_api.g_varchar2
  ,p_lnc_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_ler_enrt_ctfn';

Line: 349


  savepoint update_ler_enrt_ctfn;

Line: 361


    ben_ler_enrt_ctfn_bk2.update_ler_enrt_ctfn_b
      (
       p_ler_enrt_ctfn_id               =>  p_ler_enrt_ctfn_id
      ,p_rqd_flag                       =>  p_rqd_flag
      ,p_enrt_ctfn_typ_cd               =>  p_enrt_ctfn_typ_cd
      ,p_ctfn_rqd_when_rl               =>  p_ctfn_rqd_when_rl
      ,p_ler_rqrs_enrt_ctfn_id          =>  p_ler_rqrs_enrt_ctfn_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_lnc_attribute_category         =>  p_lnc_attribute_category
      ,p_lnc_attribute1                 =>  p_lnc_attribute1
      ,p_lnc_attribute2                 =>  p_lnc_attribute2
      ,p_lnc_attribute3                 =>  p_lnc_attribute3
      ,p_lnc_attribute4                 =>  p_lnc_attribute4
      ,p_lnc_attribute5                 =>  p_lnc_attribute5
      ,p_lnc_attribute6                 =>  p_lnc_attribute6
      ,p_lnc_attribute7                 =>  p_lnc_attribute7
      ,p_lnc_attribute8                 =>  p_lnc_attribute8
      ,p_lnc_attribute9                 =>  p_lnc_attribute9
      ,p_lnc_attribute10                =>  p_lnc_attribute10
      ,p_lnc_attribute11                =>  p_lnc_attribute11
      ,p_lnc_attribute12                =>  p_lnc_attribute12
      ,p_lnc_attribute13                =>  p_lnc_attribute13
      ,p_lnc_attribute14                =>  p_lnc_attribute14
      ,p_lnc_attribute15                =>  p_lnc_attribute15
      ,p_lnc_attribute16                =>  p_lnc_attribute16
      ,p_lnc_attribute17                =>  p_lnc_attribute17
      ,p_lnc_attribute18                =>  p_lnc_attribute18
      ,p_lnc_attribute19                =>  p_lnc_attribute19
      ,p_lnc_attribute20                =>  p_lnc_attribute20
      ,p_lnc_attribute21                =>  p_lnc_attribute21
      ,p_lnc_attribute22                =>  p_lnc_attribute22
      ,p_lnc_attribute23                =>  p_lnc_attribute23
      ,p_lnc_attribute24                =>  p_lnc_attribute24
      ,p_lnc_attribute25                =>  p_lnc_attribute25
      ,p_lnc_attribute26                =>  p_lnc_attribute26
      ,p_lnc_attribute27                =>  p_lnc_attribute27
      ,p_lnc_attribute28                =>  p_lnc_attribute28
      ,p_lnc_attribute29                =>  p_lnc_attribute29
      ,p_lnc_attribute30                =>  p_lnc_attribute30
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
    ,p_datetrack_mode                      => p_datetrack_mode
      );

Line: 407


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

Line: 465


    ben_ler_enrt_ctfn_bk2.update_ler_enrt_ctfn_a
      (
       p_ler_enrt_ctfn_id               =>  p_ler_enrt_ctfn_id
      ,p_effective_start_date           =>  l_effective_start_date
      ,p_effective_end_date             =>  l_effective_end_date
      ,p_rqd_flag                       =>  p_rqd_flag
      ,p_enrt_ctfn_typ_cd               =>  p_enrt_ctfn_typ_cd
      ,p_ctfn_rqd_when_rl               =>  p_ctfn_rqd_when_rl
      ,p_ler_rqrs_enrt_ctfn_id          =>  p_ler_rqrs_enrt_ctfn_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_lnc_attribute_category         =>  p_lnc_attribute_category
      ,p_lnc_attribute1                 =>  p_lnc_attribute1
      ,p_lnc_attribute2                 =>  p_lnc_attribute2
      ,p_lnc_attribute3                 =>  p_lnc_attribute3
      ,p_lnc_attribute4                 =>  p_lnc_attribute4
      ,p_lnc_attribute5                 =>  p_lnc_attribute5
      ,p_lnc_attribute6                 =>  p_lnc_attribute6
      ,p_lnc_attribute7                 =>  p_lnc_attribute7
      ,p_lnc_attribute8                 =>  p_lnc_attribute8
      ,p_lnc_attribute9                 =>  p_lnc_attribute9
      ,p_lnc_attribute10                =>  p_lnc_attribute10
      ,p_lnc_attribute11                =>  p_lnc_attribute11
      ,p_lnc_attribute12                =>  p_lnc_attribute12
      ,p_lnc_attribute13                =>  p_lnc_attribute13
      ,p_lnc_attribute14                =>  p_lnc_attribute14
      ,p_lnc_attribute15                =>  p_lnc_attribute15
      ,p_lnc_attribute16                =>  p_lnc_attribute16
      ,p_lnc_attribute17                =>  p_lnc_attribute17
      ,p_lnc_attribute18                =>  p_lnc_attribute18
      ,p_lnc_attribute19                =>  p_lnc_attribute19
      ,p_lnc_attribute20                =>  p_lnc_attribute20
      ,p_lnc_attribute21                =>  p_lnc_attribute21
      ,p_lnc_attribute22                =>  p_lnc_attribute22
      ,p_lnc_attribute23                =>  p_lnc_attribute23
      ,p_lnc_attribute24                =>  p_lnc_attribute24
      ,p_lnc_attribute25                =>  p_lnc_attribute25
      ,p_lnc_attribute26                =>  p_lnc_attribute26
      ,p_lnc_attribute27                =>  p_lnc_attribute27
      ,p_lnc_attribute28                =>  p_lnc_attribute28
      ,p_lnc_attribute29                =>  p_lnc_attribute29
      ,p_lnc_attribute30                =>  p_lnc_attribute30
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                     => trunc(p_effective_date)
      ,p_datetrack_mode                     => p_datetrack_mode
      );

Line: 513


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

Line: 544


    ROLLBACK TO update_ler_enrt_ctfn;

Line: 556


    ROLLBACK TO update_ler_enrt_ctfn;

Line: 557


    /* Inserted for nocopy changes */
    p_object_version_number := l_object_version_number;

Line: 563


end update_ler_enrt_ctfn;

Line: 568


procedure delete_ler_enrt_ctfn
  (p_validate                       in  boolean  default false
  ,p_ler_enrt_ctfn_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_ler_enrt_ctfn';

Line: 591


  savepoint delete_ler_enrt_ctfn;

Line: 604


    ben_ler_enrt_ctfn_bk3.delete_ler_enrt_ctfn_b
      (
       p_ler_enrt_ctfn_id               =>  p_ler_enrt_ctfn_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
    ,p_datetrack_mode                      => p_datetrack_mode
      );

Line: 614


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

Line: 636


    ben_ler_enrt_ctfn_bk3.delete_ler_enrt_ctfn_a
      (
       p_ler_enrt_ctfn_id               =>  p_ler_enrt_ctfn_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: 648


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

Line: 673


    ROLLBACK TO delete_ler_enrt_ctfn;

Line: 686


    ROLLBACK TO delete_ler_enrt_ctfn;

Line: 687


    /* Inserted for nocopy changes */
    p_object_version_number := l_object_version_number;

Line: 693


end delete_ler_enrt_ctfn;