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

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

Line: 69


  ,p_program_update_date            in  date      default null
  ,p_mx_wout_ctfn_val               in  number    default null
  ,p_mx_wo_ctfn_flag                in  varchar2  default 'N'
  ,p_object_version_number          out nocopy number
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_enrt_bnft_id ben_enrt_bnft.enrt_bnft_id%TYPE;

Line: 154


      ,p_program_update_date          =>  p_program_update_date
      ,p_mx_wout_ctfn_val             =>  p_mx_wout_ctfn_val
      ,p_mx_wo_ctfn_flag              =>  p_mx_wo_ctfn_flag
      ,p_object_version_number        =>  l_object_version_number
      ,p_effective_date               =>  trunc(p_effective_date)
      );

Line: 232


    ,p_program_update_date           => p_program_update_date
    ,p_object_version_number         => l_object_version_number
    );

Line: 297


      ,p_program_update_date           => p_program_update_date
      ,p_mx_wout_ctfn_val              => p_mx_wout_ctfn_val
      ,p_mx_wo_ctfn_flag               => p_mx_wo_ctfn_flag
      ,p_object_version_number         => l_object_version_number
      ,p_effective_date                => trunc(p_effective_date)
      );

Line: 361


procedure update_enrt_bnft
  (
   p_validate                       in  boolean   default false
  ,p_enrt_bnft_id                   in  number
  ,p_dflt_flag                      in  varchar2  default hr_api.g_varchar2
  ,p_val_has_bn_prortd_flag         in  varchar2  default hr_api.g_varchar2
  ,p_bndry_perd_cd                  in  varchar2  default hr_api.g_varchar2
  ,p_val                            in  number    default hr_api.g_number
  ,p_nnmntry_uom                    in  varchar2  default hr_api.g_varchar2
  ,p_bnft_typ_cd                    in  varchar2  default hr_api.g_varchar2
  ,p_entr_val_at_enrt_flag          in  varchar2  default hr_api.g_varchar2
  ,p_mn_val                         in  number    default hr_api.g_number
  ,p_mx_val                         in  number    default hr_api.g_number
  ,p_incrmt_val                     in  number    default hr_api.g_number
  ,p_dflt_val                       in  number    default hr_api.g_number
  ,p_rt_typ_cd                      in  varchar2  default hr_api.g_varchar2
  ,p_cvg_mlt_cd                     in  varchar2  default hr_api.g_varchar2
  ,p_ctfn_rqd_flag                  in  varchar2  default hr_api.g_varchar2
  ,p_ordr_num                       in  number    default hr_api.g_number
  ,p_crntly_enrld_flag              in  varchar2  default hr_api.g_varchar2
  ,p_elig_per_elctbl_chc_id         in  number    default hr_api.g_number
  ,p_prtt_enrt_rslt_id              in  number    default hr_api.g_number
  ,p_comp_lvl_fctr_id               in  number    default hr_api.g_number
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_enb_attribute_category         in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute1                 in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute2                 in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute3                 in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute4                 in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute5                 in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute6                 in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute7                 in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute8                 in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute9                 in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute10                in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute11                in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute12                in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute13                in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute14                in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute15                in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute16                in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute17                in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute18                in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute19                in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute20                in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute21                in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute22                in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute23                in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute24                in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute25                in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute26                in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute27                in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute28                in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute29                in  varchar2  default hr_api.g_varchar2
  ,p_enb_attribute30                in  varchar2  default hr_api.g_varchar2
  ,p_request_id                     in  number    default hr_api.g_number
  ,p_program_application_id         in  number    default hr_api.g_number
  ,p_program_id                     in  number    default hr_api.g_number
  ,p_program_update_date            in  date      default hr_api.g_date
  ,p_mx_wout_ctfn_val               in  number    default hr_api.g_number
  ,p_mx_wo_ctfn_flag                in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_enrt_bnft';

Line: 437


  savepoint update_enrt_bnft;

Line: 449


    ben_enrt_bnft_bk2.update_enrt_bnft_b
      (
       p_enrt_bnft_id                  => p_enrt_bnft_id
      ,p_dflt_flag                     => p_dflt_flag
      ,p_val_has_bn_prortd_flag        => p_val_has_bn_prortd_flag
      ,p_bndry_perd_cd                 => p_bndry_perd_cd
      ,p_val                           => p_val
      ,p_nnmntry_uom                   => p_nnmntry_uom
      ,p_bnft_typ_cd                   => p_bnft_typ_cd
      ,p_entr_val_at_enrt_flag         => p_entr_val_at_enrt_flag
      ,p_mn_val                        => p_mn_val
      ,p_mx_val                        => p_mx_val
      ,p_incrmt_val                    => p_incrmt_val
      ,p_dflt_val                      => p_dflt_val
      ,p_rt_typ_cd                     => p_rt_typ_cd
      ,p_cvg_mlt_cd                    => p_cvg_mlt_cd
      ,p_ctfn_rqd_flag                 => p_ctfn_rqd_flag
      ,p_ordr_num                      => p_ordr_num
      ,p_crntly_enrld_flag             => p_crntly_enrld_flag
      ,p_elig_per_elctbl_chc_id        => p_elig_per_elctbl_chc_id
      ,p_prtt_enrt_rslt_id             => p_prtt_enrt_rslt_id
      ,p_comp_lvl_fctr_id              => p_comp_lvl_fctr_id
      ,p_business_group_id             => p_business_group_id
      ,p_enb_attribute_category        => p_enb_attribute_category
      ,p_enb_attribute1                => p_enb_attribute1
      ,p_enb_attribute2                => p_enb_attribute2
      ,p_enb_attribute3                => p_enb_attribute3
      ,p_enb_attribute4                => p_enb_attribute4
      ,p_enb_attribute5                => p_enb_attribute5
      ,p_enb_attribute6                => p_enb_attribute6
      ,p_enb_attribute7                => p_enb_attribute7
      ,p_enb_attribute8                => p_enb_attribute8
      ,p_enb_attribute9                => p_enb_attribute9
      ,p_enb_attribute10               => p_enb_attribute10
      ,p_enb_attribute11               => p_enb_attribute11
      ,p_enb_attribute12               => p_enb_attribute12
      ,p_enb_attribute13               => p_enb_attribute13
      ,p_enb_attribute14               => p_enb_attribute14
      ,p_enb_attribute15               => p_enb_attribute15
      ,p_enb_attribute16               => p_enb_attribute16
      ,p_enb_attribute17               => p_enb_attribute17
      ,p_enb_attribute18               => p_enb_attribute18
      ,p_enb_attribute19               => p_enb_attribute19
      ,p_enb_attribute20               => p_enb_attribute20
      ,p_enb_attribute21               => p_enb_attribute21
      ,p_enb_attribute22               => p_enb_attribute22
      ,p_enb_attribute23               => p_enb_attribute23
      ,p_enb_attribute24               => p_enb_attribute24
      ,p_enb_attribute25               => p_enb_attribute25
      ,p_enb_attribute26               => p_enb_attribute26
      ,p_enb_attribute27               => p_enb_attribute27
      ,p_enb_attribute28               => p_enb_attribute28
      ,p_enb_attribute29               => p_enb_attribute29
      ,p_enb_attribute30               => p_enb_attribute30
      ,p_request_id                    => p_request_id
      ,p_program_application_id        => p_program_application_id
      ,p_program_id                    => p_program_id
      ,p_program_update_date           => p_program_update_date
      ,p_mx_wout_ctfn_val              => p_mx_wout_ctfn_val
      ,p_mx_wo_ctfn_flag               => p_mx_wo_ctfn_flag
      ,p_object_version_number         => l_object_version_number
      ,p_effective_date                => trunc(p_effective_date)
      );

Line: 515


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

Line: 580


      ,p_program_update_date           => p_program_update_date
      ,p_mx_wout_ctfn_val              => p_mx_wout_ctfn_val
      ,p_mx_wo_ctfn_flag               => p_mx_wo_ctfn_flag
      ,p_object_version_number         => l_object_version_number
      ,p_effective_date                => trunc(p_effective_date)
    );

Line: 591


    ben_enrt_bnft_bk2.update_enrt_bnft_a
      (
       p_enrt_bnft_id                  => p_enrt_bnft_id
      ,p_dflt_flag                     => p_dflt_flag
      ,p_val_has_bn_prortd_flag        => p_val_has_bn_prortd_flag
      ,p_bndry_perd_cd                 => p_bndry_perd_cd
      ,p_val                           => p_val
      ,p_nnmntry_uom                   => p_nnmntry_uom
      ,p_bnft_typ_cd                   => p_bnft_typ_cd
      ,p_entr_val_at_enrt_flag         => p_entr_val_at_enrt_flag
      ,p_mn_val                        => p_mn_val
      ,p_mx_val                        => p_mx_val
      ,p_incrmt_val                    => p_incrmt_val
      ,p_dflt_val                      => p_dflt_val
      ,p_rt_typ_cd                     => p_rt_typ_cd
      ,p_cvg_mlt_cd                    => p_cvg_mlt_cd
      ,p_ctfn_rqd_flag                 => p_ctfn_rqd_flag
      ,p_ordr_num                      => p_ordr_num
      ,p_crntly_enrld_flag             => p_crntly_enrld_flag
      ,p_elig_per_elctbl_chc_id        => p_elig_per_elctbl_chc_id
      ,p_prtt_enrt_rslt_id             => p_prtt_enrt_rslt_id
      ,p_comp_lvl_fctr_id              => p_comp_lvl_fctr_id
      ,p_business_group_id             => p_business_group_id
      ,p_enb_attribute_category        => p_enb_attribute_category
      ,p_enb_attribute1                => p_enb_attribute1
      ,p_enb_attribute2                => p_enb_attribute2
      ,p_enb_attribute3                => p_enb_attribute3
      ,p_enb_attribute4                => p_enb_attribute4
      ,p_enb_attribute5                => p_enb_attribute5
      ,p_enb_attribute6                => p_enb_attribute6
      ,p_enb_attribute7                => p_enb_attribute7
      ,p_enb_attribute8                => p_enb_attribute8
      ,p_enb_attribute9                => p_enb_attribute9
      ,p_enb_attribute10               => p_enb_attribute10
      ,p_enb_attribute11               => p_enb_attribute11
      ,p_enb_attribute12               => p_enb_attribute12
      ,p_enb_attribute13               => p_enb_attribute13
      ,p_enb_attribute14               => p_enb_attribute14
      ,p_enb_attribute15               => p_enb_attribute15
      ,p_enb_attribute16               => p_enb_attribute16
      ,p_enb_attribute17               => p_enb_attribute17
      ,p_enb_attribute18               => p_enb_attribute18
      ,p_enb_attribute19               => p_enb_attribute19
      ,p_enb_attribute20               => p_enb_attribute20
      ,p_enb_attribute21               => p_enb_attribute21
      ,p_enb_attribute22               => p_enb_attribute22
      ,p_enb_attribute23               => p_enb_attribute23
      ,p_enb_attribute24               => p_enb_attribute24
      ,p_enb_attribute25               => p_enb_attribute25
      ,p_enb_attribute26               => p_enb_attribute26
      ,p_enb_attribute27               => p_enb_attribute27
      ,p_enb_attribute28               => p_enb_attribute28
      ,p_enb_attribute29               => p_enb_attribute29
      ,p_enb_attribute30               => p_enb_attribute30
      ,p_request_id                    => p_request_id
      ,p_program_application_id        => p_program_application_id
      ,p_program_id                    => p_program_id
      ,p_program_update_date           => p_program_update_date
      ,p_mx_wout_ctfn_val              => p_mx_wout_ctfn_val
      ,p_mx_wo_ctfn_flag               => p_mx_wo_ctfn_flag
      ,p_object_version_number         => l_object_version_number
      ,p_effective_date                => trunc(p_effective_date)
      );

Line: 657


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

Line: 686


    ROLLBACK TO update_enrt_bnft;

Line: 698


    ROLLBACK TO update_enrt_bnft;

Line: 702


end update_enrt_bnft;

Line: 707


procedure delete_enrt_bnft
  (p_validate                       in  boolean  default false
  ,p_enrt_bnft_id                   in  number
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_enrt_bnft';

Line: 725


  savepoint delete_enrt_bnft;

Line: 738


    ben_enrt_bnft_bk3.delete_enrt_bnft_b
      (
       p_enrt_bnft_id                   =>  p_enrt_bnft_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 747


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

Line: 766


    ben_enrt_bnft_bk3.delete_enrt_bnft_a
      (
       p_enrt_bnft_id                   =>  p_enrt_bnft_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 775


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

Line: 800


    ROLLBACK TO delete_enrt_bnft;

Line: 812


    ROLLBACK TO delete_enrt_bnft;

Line: 816


end delete_enrt_bnft;