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

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

Line: 213


procedure update_batch_rate_info
  (p_validate                       in  boolean   default false
  ,p_batch_rt_id                    in  number
  ,p_benefit_action_id              in  number    default hr_api.g_number
  ,p_person_id                      in  number    default hr_api.g_number
  ,p_pgm_id                         in  number    default hr_api.g_number
  ,p_pl_id                          in  number    default hr_api.g_number
  ,p_oipl_id                        in  number    default hr_api.g_number
  ,p_bnft_rt_typ_cd                 in  varchar2  default hr_api.g_varchar2
  ,p_dflt_flag                      in  varchar2  default hr_api.g_varchar2
  ,p_val                            in  number    default hr_api.g_number
  ,p_old_val                        in  number    default hr_api.g_number
  ,p_tx_typ_cd                      in  varchar2  default hr_api.g_varchar2
  ,p_acty_typ_cd                    in  varchar2  default hr_api.g_varchar2
  ,p_mn_elcn_val                    in  number    default hr_api.g_number
  ,p_mx_elcn_val                    in  number    default hr_api.g_number
  ,p_incrmt_elcn_val                in  number    default hr_api.g_number
  ,p_dflt_val                       in  number    default hr_api.g_number
  ,p_rt_strt_dt                     in  date      default hr_api.g_date
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_object_version_number          in out nocopy number
  ,p_enrt_cvg_strt_dt               in  date      default hr_api.g_date
  ,p_enrt_cvg_thru_dt               in  date      default hr_api.g_date
  ,p_actn_cd                        in  varchar2  default hr_api.g_varchar2
  ,p_close_actn_itm_dt              in  date      default hr_api.g_date
  ,p_effective_date                 in  date) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_batch_rate_info';

Line: 251


  savepoint update_batch_rate_info;

Line: 263


    ben_batch_rate_info_bk2.update_batch_rate_info_b
      (p_batch_rt_id                    =>  p_batch_rt_id
      ,p_benefit_action_id              =>  p_benefit_action_id
      ,p_person_id                      =>  p_person_id
      ,p_pgm_id                         =>  p_pgm_id
      ,p_pl_id                          =>  p_pl_id
      ,p_oipl_id                        =>  p_oipl_id
      ,p_bnft_rt_typ_cd                 =>  p_bnft_rt_typ_cd
      ,p_dflt_flag                      =>  p_dflt_flag
      ,p_val                            =>  p_val
      ,p_old_val                        =>  p_old_val
      ,p_tx_typ_cd                      =>  p_tx_typ_cd
      ,p_acty_typ_cd                    =>  p_acty_typ_cd
      ,p_mn_elcn_val                    =>  p_mn_elcn_val
      ,p_mx_elcn_val                    =>  p_mx_elcn_val
      ,p_incrmt_elcn_val                =>  p_incrmt_elcn_val
      ,p_dflt_val                       =>  p_dflt_val
      ,p_rt_strt_dt                     =>  p_rt_strt_dt
      ,p_business_group_id              =>  p_business_group_id
      ,p_object_version_number          =>  p_object_version_number
      ,p_enrt_cvg_strt_dt               =>  p_enrt_cvg_strt_dt
      ,p_enrt_cvg_thru_dt               =>  p_enrt_cvg_thru_dt
      ,p_actn_cd                        =>  p_actn_cd
      ,p_close_actn_itm_dt              =>  p_close_actn_itm_dt
      ,p_effective_date                 =>  trunc(p_effective_date));

Line: 294


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

Line: 331


    ben_batch_rate_info_bk2.update_batch_rate_info_a
      (p_batch_rt_id                    =>  p_batch_rt_id
      ,p_benefit_action_id              =>  p_benefit_action_id
      ,p_person_id                      =>  p_person_id
      ,p_pgm_id                         =>  p_pgm_id
      ,p_pl_id                          =>  p_pl_id
      ,p_oipl_id                        =>  p_oipl_id
      ,p_bnft_rt_typ_cd                 =>  p_bnft_rt_typ_cd
      ,p_dflt_flag                      =>  p_dflt_flag
      ,p_val                            =>  p_val
      ,p_old_val                        =>  p_old_val
      ,p_tx_typ_cd                      =>  p_tx_typ_cd
      ,p_acty_typ_cd                    =>  p_acty_typ_cd
      ,p_mn_elcn_val                    =>  p_mn_elcn_val
      ,p_mx_elcn_val                    =>  p_mx_elcn_val
      ,p_incrmt_elcn_val                =>  p_incrmt_elcn_val
      ,p_dflt_val                       =>  p_dflt_val
      ,p_rt_strt_dt                     =>  p_rt_strt_dt
      ,p_business_group_id              =>  p_business_group_id
      ,p_object_version_number          =>  l_object_version_number
      ,p_enrt_cvg_strt_dt               =>  p_enrt_cvg_strt_dt
      ,p_enrt_cvg_thru_dt               =>  p_enrt_cvg_thru_dt
      ,p_actn_cd                        =>  p_actn_cd
      ,p_close_actn_itm_dt              =>  p_close_actn_itm_dt
      ,p_effective_date                 =>  trunc(p_effective_date));

Line: 362


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

Line: 390


    ROLLBACK TO update_batch_rate_info;

Line: 405


    ROLLBACK TO update_batch_rate_info;

Line: 408


end update_batch_rate_info;

Line: 413


procedure delete_batch_rate_info
  (p_validate                       in  boolean  default false
  ,p_batch_rt_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_batch_rate_info';

Line: 430


  savepoint delete_batch_rate_info;

Line: 443


    ben_batch_rate_info_bk3.delete_batch_rate_info_b
      (p_batch_rt_id                    =>  p_batch_rt_id
      ,p_object_version_number          =>  p_object_version_number
      ,p_effective_date                 =>  trunc(p_effective_date));

Line: 453


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

Line: 469


    ben_batch_rate_info_bk3.delete_batch_rate_info_a
      (p_batch_rt_id                    =>  p_batch_rt_id
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                 =>  trunc(p_effective_date));

Line: 479


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

Line: 503


    ROLLBACK TO delete_batch_rate_info;

Line: 517


    ROLLBACK TO delete_batch_rate_info;

Line: 520


end delete_batch_rate_info;