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

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

Line: 53


Procedure insert_dml(p_rec in out nocopy ben_enp_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';

Line: 65


  insert into ben_enrt_perd
  (	enrt_perd_id,
	business_group_id,
	yr_perd_id,
	popl_enrt_typ_cycl_id,
	end_dt,
	strt_dt,
        asnd_lf_evt_dt ,
	cls_enrt_dt_to_use_cd,
	dflt_enrt_dt,
	enrt_cvg_strt_dt_cd,
	rt_strt_dt_rl,
	enrt_cvg_end_dt_cd,
	enrt_cvg_strt_dt_rl,
	enrt_cvg_end_dt_rl,
	procg_end_dt,
	rt_strt_dt_cd,
	rt_end_dt_cd,
	rt_end_dt_rl,
        bdgt_upd_strt_dt,
        bdgt_upd_end_dt,
        ws_upd_strt_dt,
        ws_upd_end_dt,
        dflt_ws_acc_cd,
        prsvr_bdgt_cd,
        uses_bdgt_flag,
        auto_distr_flag,
        hrchy_to_use_cd,
        pos_structure_version_id,
        emp_interview_type_cd,
        wthn_yr_perd_id,
        ler_id,
        perf_revw_strt_dt,
        asg_updt_eff_date,
	enp_attribute_category,
	enp_attribute1,
	enp_attribute2,
	enp_attribute3,
	enp_attribute4,
	enp_attribute5,
	enp_attribute6,
	enp_attribute7,
	enp_attribute8,
	enp_attribute9,
	enp_attribute10,
	enp_attribute11,
	enp_attribute12,
	enp_attribute13,
	enp_attribute14,
	enp_attribute15,
	enp_attribute16,
	enp_attribute17,
	enp_attribute18,
	enp_attribute19,
	enp_attribute20,
	enp_attribute21,
	enp_attribute22,
	enp_attribute23,
	enp_attribute24,
	enp_attribute25,
	enp_attribute26,
	enp_attribute27,
	enp_attribute28,
	enp_attribute29,
	enp_attribute30,
	enrt_perd_det_ovrlp_bckdt_cd,
        --cwb
        data_freeze_date   ,
        Sal_chg_reason_cd ,
        Approval_mode_cd ,
        hrchy_ame_trn_cd,
        hrchy_rl     ,
        hrchy_ame_app_id ,
	object_version_number,
	reinstate_cd,
	reinstate_ovrdn_cd,
	reopen_le_on_reprocess,
	defer_deenrol_flag
  )
  Values
  (	p_rec.enrt_perd_id,
	p_rec.business_group_id,
	p_rec.yr_perd_id,
	p_rec.popl_enrt_typ_cycl_id,
	p_rec.end_dt,
	p_rec.strt_dt,
        p_rec.asnd_lf_evt_dt,
	p_rec.cls_enrt_dt_to_use_cd,
	p_rec.dflt_enrt_dt,
	p_rec.enrt_cvg_strt_dt_cd,
	p_rec.rt_strt_dt_rl,
	p_rec.enrt_cvg_end_dt_cd,
	p_rec.enrt_cvg_strt_dt_rl,
	p_rec.enrt_cvg_end_dt_rl,
	p_rec.procg_end_dt,
	p_rec.rt_strt_dt_cd,
	p_rec.rt_end_dt_cd,
	p_rec.rt_end_dt_rl,
        p_rec.bdgt_upd_strt_dt,
        p_rec.bdgt_upd_end_dt,
        p_rec.ws_upd_strt_dt,
        p_rec.ws_upd_end_dt,
        p_rec.dflt_ws_acc_cd,
        p_rec.prsvr_bdgt_cd,
        p_rec.uses_bdgt_flag,
        p_rec.auto_distr_flag,
        p_rec.hrchy_to_use_cd,
        p_rec.pos_structure_version_id,
        p_rec.emp_interview_type_cd,
        p_rec.wthn_yr_perd_id,
        p_rec.ler_id,
        p_rec.perf_revw_strt_dt,
        p_rec.asg_updt_eff_date,
	p_rec.enp_attribute_category,
	p_rec.enp_attribute1,
	p_rec.enp_attribute2,
	p_rec.enp_attribute3,
	p_rec.enp_attribute4,
	p_rec.enp_attribute5,
	p_rec.enp_attribute6,
	p_rec.enp_attribute7,
	p_rec.enp_attribute8,
	p_rec.enp_attribute9,
	p_rec.enp_attribute10,
	p_rec.enp_attribute11,
	p_rec.enp_attribute12,
	p_rec.enp_attribute13,
	p_rec.enp_attribute14,
	p_rec.enp_attribute15,
	p_rec.enp_attribute16,
	p_rec.enp_attribute17,
	p_rec.enp_attribute18,
	p_rec.enp_attribute19,
	p_rec.enp_attribute20,
	p_rec.enp_attribute21,
	p_rec.enp_attribute22,
	p_rec.enp_attribute23,
	p_rec.enp_attribute24,
	p_rec.enp_attribute25,
	p_rec.enp_attribute26,
	p_rec.enp_attribute27,
	p_rec.enp_attribute28,
	p_rec.enp_attribute29,
	p_rec.enp_attribute30,
	p_rec.enrt_perd_det_ovrlp_bckdt_cd,
         --cwb
        p_rec.data_freeze_date   ,
        p_rec.Sal_chg_reason_cd ,
        p_rec.Approval_mode_cd ,
        p_rec.hrchy_ame_trn_cd,
        p_rec.hrchy_rl     ,
        p_rec.hrchy_ame_app_id ,
	p_rec.object_version_number ,
	p_rec.reinstate_cd,
	p_rec.reinstate_ovrdn_cd,
	p_rec.reopen_le_on_reprocess,
	p_rec.defer_deenrol_flag
  );

Line: 246


End insert_dml;

Line: 285


Procedure pre_insert(p_rec  in out nocopy ben_enp_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'pre_insert';

Line: 289


  Cursor C_Sel1 is select ben_enrt_perd_s.nextval from sys.dual;

Line: 302


End pre_insert;

Line: 336


Procedure post_insert(
p_effective_date in date,p_rec in ben_enp_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_insert';

Line: 349


    ben_enp_rki.after_insert
      (
  p_enrt_perd_id                  =>p_rec.enrt_perd_id
 ,p_business_group_id             =>p_rec.business_group_id
 ,p_yr_perd_id                    =>p_rec.yr_perd_id
 ,p_popl_enrt_typ_cycl_id         =>p_rec.popl_enrt_typ_cycl_id
 ,p_end_dt                        =>p_rec.end_dt
 ,p_strt_dt                       =>p_rec.strt_dt
 ,p_asnd_lf_evt_dt                =>p_rec.asnd_lf_evt_dt
 ,p_cls_enrt_dt_to_use_cd         =>p_rec.cls_enrt_dt_to_use_cd
 ,p_dflt_enrt_dt                  =>p_rec.dflt_enrt_dt
 ,p_enrt_cvg_strt_dt_cd           =>p_rec.enrt_cvg_strt_dt_cd
 ,p_rt_strt_dt_rl                 =>p_rec.rt_strt_dt_rl
 ,p_enrt_cvg_end_dt_cd            =>p_rec.enrt_cvg_end_dt_cd
 ,p_enrt_cvg_strt_dt_rl           =>p_rec.enrt_cvg_strt_dt_rl
 ,p_enrt_cvg_end_dt_rl            =>p_rec.enrt_cvg_end_dt_rl
 ,p_procg_end_dt                  =>p_rec.procg_end_dt
 ,p_rt_strt_dt_cd                 =>p_rec.rt_strt_dt_cd
 ,p_rt_end_dt_cd                  =>p_rec.rt_end_dt_cd
 ,p_rt_end_dt_rl                  =>p_rec.rt_end_dt_rl
 ,p_bdgt_upd_strt_dt              =>p_rec.bdgt_upd_strt_dt
 ,p_bdgt_upd_end_dt               =>p_rec.bdgt_upd_end_dt
 ,p_ws_upd_strt_dt                =>p_rec.ws_upd_strt_dt
 ,p_ws_upd_end_dt                 =>p_rec.ws_upd_end_dt
 ,p_dflt_ws_acc_cd                =>p_rec.dflt_ws_acc_cd
 ,p_prsvr_bdgt_cd                 =>p_rec.prsvr_bdgt_cd
 ,p_uses_bdgt_flag                =>p_rec.uses_bdgt_flag
 ,p_auto_distr_flag               =>p_rec.auto_distr_flag
 ,p_hrchy_to_use_cd               =>p_rec.hrchy_to_use_cd
 ,p_pos_structure_version_id         =>p_rec.pos_structure_version_id
 ,p_emp_interview_type_cd         =>p_rec.emp_interview_type_cd
 ,p_wthn_yr_perd_id               =>p_rec.wthn_yr_perd_id
 ,p_ler_id                        =>p_rec.ler_id
 ,p_perf_revw_strt_dt             =>p_rec.perf_revw_strt_dt
 ,p_asg_updt_eff_date             =>p_rec.asg_updt_eff_date
 ,p_enp_attribute_category        =>p_rec.enp_attribute_category
 ,p_enp_attribute1                =>p_rec.enp_attribute1
 ,p_enp_attribute2                =>p_rec.enp_attribute2
 ,p_enp_attribute3                =>p_rec.enp_attribute3
 ,p_enp_attribute4                =>p_rec.enp_attribute4
 ,p_enp_attribute5                =>p_rec.enp_attribute5
 ,p_enp_attribute6                =>p_rec.enp_attribute6
 ,p_enp_attribute7                =>p_rec.enp_attribute7
 ,p_enp_attribute8                =>p_rec.enp_attribute8
 ,p_enp_attribute9                =>p_rec.enp_attribute9
 ,p_enp_attribute10               =>p_rec.enp_attribute10
 ,p_enp_attribute11               =>p_rec.enp_attribute11
 ,p_enp_attribute12               =>p_rec.enp_attribute12
 ,p_enp_attribute13               =>p_rec.enp_attribute13
 ,p_enp_attribute14               =>p_rec.enp_attribute14
 ,p_enp_attribute15               =>p_rec.enp_attribute15
 ,p_enp_attribute16               =>p_rec.enp_attribute16
 ,p_enp_attribute17               =>p_rec.enp_attribute17
 ,p_enp_attribute18               =>p_rec.enp_attribute18
 ,p_enp_attribute19               =>p_rec.enp_attribute19
 ,p_enp_attribute20               =>p_rec.enp_attribute20
 ,p_enp_attribute21               =>p_rec.enp_attribute21
 ,p_enp_attribute22               =>p_rec.enp_attribute22
 ,p_enp_attribute23               =>p_rec.enp_attribute23
 ,p_enp_attribute24               =>p_rec.enp_attribute24
 ,p_enp_attribute25               =>p_rec.enp_attribute25
 ,p_enp_attribute26               =>p_rec.enp_attribute26
 ,p_enp_attribute27               =>p_rec.enp_attribute27
 ,p_enp_attribute28               =>p_rec.enp_attribute28
 ,p_enp_attribute29               =>p_rec.enp_attribute29
 ,p_enp_attribute30               =>p_rec.enp_attribute30
 ,p_enrt_perd_det_ovrlp_bckdt_cd  =>p_rec.enrt_perd_det_ovrlp_bckdt_cd
    --cwb
 ,p_data_freeze_date              =>p_rec.data_freeze_date
 ,p_Sal_chg_reason_cd             =>p_rec.Sal_chg_reason_cd
 ,p_Approval_mode_cd              =>p_rec.Approval_mode_cd
 ,p_hrchy_ame_trn_cd              =>p_rec.hrchy_ame_trn_cd
 ,p_hrchy_rl                      =>p_rec.hrchy_rl
 ,p_hrchy_ame_app_id              =>p_rec.hrchy_ame_app_id
  --
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_effective_date                =>p_effective_date
 ,p_reinstate_cd		  =>p_rec.reinstate_cd
 ,p_reinstate_ovrdn_cd		  =>p_rec.reinstate_ovrdn_cd
 ,p_reopen_le_on_reprocess        =>p_rec.reopen_le_on_reprocess
 ,p_defer_deenrol_flag            =>p_rec.defer_deenrol_flag
      );

Line: 447


End post_insert;

Line: 465


  ben_enp_bus.insert_validate(p_rec
                             ,p_effective_date);

Line: 470


  pre_insert(p_rec);

Line: 474


  insert_dml(p_rec);

Line: 478


  post_insert(
p_effective_date,p_rec);