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

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

Line: 57


Procedure dt_insert_dml
    (p_rec              in out nocopy ben_pep_shd.g_rec_type,
     p_effective_date     in    date,
     p_datetrack_mode     in    varchar2,
     p_validation_start_date in    date,
     p_validation_end_date     in    date) is
--
-- Cursor to select 'old' created AOL who column values
--
  Cursor C_Sel1 Is
    select t.created_by,
           t.creation_date
    from   ben_elig_per_f t
    where  t.elig_per_id       = p_rec.elig_per_id
    and    t.effective_start_date =
             ben_pep_shd.g_old_rec.effective_start_date
    and    t.effective_end_date   = (p_validation_start_date - 1);

Line: 75


  l_proc        varchar2(72) := g_package||'dt_insert_dml';

Line: 78


  l_last_update_date       ben_elig_per_f.last_update_date%TYPE;

Line: 79


  l_last_updated_by     ben_elig_per_f.last_updated_by%TYPE;

Line: 80


  l_last_update_login   ben_elig_per_f.last_update_login%TYPE;

Line: 103


  If (p_datetrack_mode <> 'INSERT') then
    hr_utility.set_location(l_proc, 10);

Line: 125


    l_last_update_date   := sysdate;

Line: 126


    l_last_updated_by    := fnd_global.user_id;

Line: 127


    l_last_update_login  := fnd_global.login_id;

Line: 135


  insert into ben_elig_per_f
  (
    elig_per_id,
    effective_start_date,
    effective_end_date,
    business_group_id,
    pl_id,
    pgm_id,
    plip_id,
    ptip_id,
    ler_id,
    person_id,
    per_in_ler_id,
    dpnt_othr_pl_cvrd_rl_flag,
    prtn_ovridn_thru_dt,
    pl_key_ee_flag,
    pl_hghly_compd_flag,
    elig_flag,
    comp_ref_amt,
    cmbn_age_n_los_val,
    comp_ref_uom,
    age_val,
    los_val,
    prtn_end_dt,
    prtn_strt_dt,
    wait_perd_cmpltn_dt,
    wait_perd_strt_dt ,
    wv_ctfn_typ_cd,
    hrs_wkd_val,
    hrs_wkd_bndry_perd_cd,
    prtn_ovridn_flag,
    no_mx_prtn_ovrid_thru_flag,
    prtn_ovridn_rsn_cd,
    age_uom,
    los_uom,
    ovrid_svc_dt,
    inelg_rsn_cd,
    frz_los_flag,
    frz_age_flag,
    frz_cmp_lvl_flag,
    frz_pct_fl_tm_flag,
    frz_hrs_wkd_flag,
    frz_comb_age_and_los_flag,
    dstr_rstcn_flag,
    pct_fl_tm_val,
    wv_prtn_rsn_cd,
    pl_wvd_flag,
    rt_comp_ref_amt,
    rt_cmbn_age_n_los_val,
    rt_comp_ref_uom,
    rt_age_val,
    rt_los_val,
    rt_hrs_wkd_val,
    rt_hrs_wkd_bndry_perd_cd,
    rt_age_uom,
    rt_los_uom,
    rt_pct_fl_tm_val,
    rt_frz_los_flag,
    rt_frz_age_flag,
    rt_frz_cmp_lvl_flag,
    rt_frz_pct_fl_tm_flag,
    rt_frz_hrs_wkd_flag,
    rt_frz_comb_age_and_los_flag,
    once_r_cntug_cd,
    pl_ordr_num,
    plip_ordr_num,
    ptip_ordr_num,
    pep_attribute_category,
    pep_attribute1,
    pep_attribute2,
    pep_attribute3,
    pep_attribute4,
    pep_attribute5,
    pep_attribute6,
    pep_attribute7,
    pep_attribute8,
    pep_attribute9,
    pep_attribute10,
    pep_attribute11,
    pep_attribute12,
    pep_attribute13,
    pep_attribute14,
    pep_attribute15,
    pep_attribute16,
    pep_attribute17,
    pep_attribute18,
    pep_attribute19,
    pep_attribute20,
    pep_attribute21,
    pep_attribute22,
    pep_attribute23,
    pep_attribute24,
    pep_attribute25,
    pep_attribute26,
    pep_attribute27,
    pep_attribute28,
    pep_attribute29,
    pep_attribute30,
    request_id,
    program_application_id,
    program_id,
    program_update_date,
    object_version_number,
    created_by,
    creation_date,
    last_update_date,
    last_updated_by,
    last_update_login
  )
  Values
  (
    p_rec.elig_per_id,
    p_rec.effective_start_date,
    p_rec.effective_end_date,
    p_rec.business_group_id,
    p_rec.pl_id,
    p_rec.pgm_id,
    p_rec.plip_id,
    p_rec.ptip_id,
    p_rec.ler_id,
    p_rec.person_id,
    p_rec.per_in_ler_id,
    p_rec.dpnt_othr_pl_cvrd_rl_flag,
    p_rec.prtn_ovridn_thru_dt,
    p_rec.pl_key_ee_flag,
    p_rec.pl_hghly_compd_flag,
    p_rec.elig_flag,
    p_rec.comp_ref_amt,
    p_rec.cmbn_age_n_los_val,
    p_rec.comp_ref_uom,
    p_rec.age_val,
    p_rec.los_val,
    p_rec.prtn_end_dt,
    p_rec.prtn_strt_dt,
    p_rec.wait_perd_cmpltn_dt,
    p_rec.wait_perd_strt_dt ,
    p_rec.wv_ctfn_typ_cd,
    p_rec.hrs_wkd_val,
    p_rec.hrs_wkd_bndry_perd_cd,
    p_rec.prtn_ovridn_flag,
    p_rec.no_mx_prtn_ovrid_thru_flag,
    p_rec.prtn_ovridn_rsn_cd,
    p_rec.age_uom,
    p_rec.los_uom,
    p_rec.ovrid_svc_dt,
    p_rec.inelg_rsn_cd,
    p_rec.frz_los_flag,
    p_rec.frz_age_flag,
    p_rec.frz_cmp_lvl_flag,
    p_rec.frz_pct_fl_tm_flag,
    p_rec.frz_hrs_wkd_flag,
    p_rec.frz_comb_age_and_los_flag,
    p_rec.dstr_rstcn_flag,
    p_rec.pct_fl_tm_val,
    p_rec.wv_prtn_rsn_cd,
    p_rec.pl_wvd_flag,
    p_rec.rt_comp_ref_amt,
    p_rec.rt_cmbn_age_n_los_val,
    p_rec.rt_comp_ref_uom,
    p_rec.rt_age_val,
    p_rec.rt_los_val,
    p_rec.rt_hrs_wkd_val,
    p_rec.rt_hrs_wkd_bndry_perd_cd,
    p_rec.rt_age_uom,
    p_rec.rt_los_uom,
    p_rec.rt_pct_fl_tm_val,
    p_rec.rt_frz_los_flag,
    p_rec.rt_frz_age_flag,
    p_rec.rt_frz_cmp_lvl_flag,
    p_rec.rt_frz_pct_fl_tm_flag,
    p_rec.rt_frz_hrs_wkd_flag,
    p_rec.rt_frz_comb_age_and_los_flag,
    p_rec.once_r_cntug_cd,
    p_rec.pl_ordr_num,
    p_rec.plip_ordr_num,
    p_rec.ptip_ordr_num,
    p_rec.pep_attribute_category,
    p_rec.pep_attribute1,
    p_rec.pep_attribute2,
    p_rec.pep_attribute3,
    p_rec.pep_attribute4,
    p_rec.pep_attribute5,
    p_rec.pep_attribute6,
    p_rec.pep_attribute7,
    p_rec.pep_attribute8,
    p_rec.pep_attribute9,
    p_rec.pep_attribute10,
    p_rec.pep_attribute11,
    p_rec.pep_attribute12,
    p_rec.pep_attribute13,
    p_rec.pep_attribute14,
    p_rec.pep_attribute15,
    p_rec.pep_attribute16,
    p_rec.pep_attribute17,
    p_rec.pep_attribute18,
    p_rec.pep_attribute19,
    p_rec.pep_attribute20,
    p_rec.pep_attribute21,
    p_rec.pep_attribute22,
    p_rec.pep_attribute23,
    p_rec.pep_attribute24,
    p_rec.pep_attribute25,
    p_rec.pep_attribute26,
    p_rec.pep_attribute27,
    p_rec.pep_attribute28,
    p_rec.pep_attribute29,
    p_rec.pep_attribute30,
    p_rec.request_id,
    p_rec.program_application_id,
    p_rec.program_id,
    p_rec.program_update_date,
    p_rec.object_version_number,
    l_created_by,
    l_creation_date,
    l_last_update_date,
    l_last_updated_by,
    l_last_update_login
  );

Line: 371


End dt_insert_dml;

Line: 376


Procedure insert_dml
    (p_rec              in out nocopy ben_pep_shd.g_rec_type,
     p_effective_date     in    date,
     p_datetrack_mode     in    varchar2,
     p_validation_start_date in    date,
     p_validation_end_date     in    date) is
--
  l_proc    varchar2(72) := g_package||'insert_dml';

Line: 388


  dt_insert_dml(p_rec            => p_rec,
        p_effective_date    => p_effective_date,
        p_datetrack_mode    => p_datetrack_mode,
               p_validation_start_date    => p_validation_start_date,
        p_validation_end_date    => p_validation_end_date);

Line: 395


End insert_dml;

Line: 436


Procedure pre_insert
    (p_rec              in out nocopy ben_pep_shd.g_rec_type,
     p_effective_date        in date,
     p_datetrack_mode        in varchar2,
     p_validation_start_date    in date,
     p_validation_end_date        in date) is
--
  l_proc    varchar2(72) := g_package||'pre_insert';

Line: 445


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

Line: 459


End pre_insert;

Line: 493


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

Line: 505


ben_pep_rki.after_insert
  (
 p_elig_per_id                    => p_rec.elig_per_id,
 p_effective_start_date           => p_rec.effective_start_date,
 p_effective_end_date             => p_rec.effective_end_date,
 p_business_group_id              => p_rec.business_group_id,
 p_pl_id                          => p_rec.pl_id,
 p_pgm_id                         => p_rec.pgm_id,
 p_plip_id                        => p_rec.plip_id,
 p_ptip_id                        => p_rec.ptip_id,
 p_ler_id                         => p_rec.ler_id,
 p_person_id                      => p_rec.person_id,
 p_per_in_ler_id                      => p_rec.per_in_ler_id,
 p_dpnt_othr_pl_cvrd_rl_flag      => p_rec.dpnt_othr_pl_cvrd_rl_flag,
 p_prtn_ovridn_thru_dt            => p_rec.prtn_ovridn_thru_dt,
 p_pl_key_ee_flag                 => p_rec.pl_key_ee_flag,
 p_pl_hghly_compd_flag            => p_rec.pl_hghly_compd_flag,
 p_elig_flag                      => p_rec.elig_flag,
 p_comp_ref_amt                   => p_rec.comp_ref_amt,
 p_cmbn_age_n_los_val             => p_rec.cmbn_age_n_los_val,
 p_comp_ref_uom                   => p_rec.comp_ref_uom,
 p_age_val                        => p_rec.age_val,
 p_los_val                        => p_rec.los_val,
 p_prtn_end_dt                    => p_rec.prtn_end_dt,
 p_prtn_strt_dt                   => p_rec.prtn_strt_dt,
 p_wait_perd_cmpltn_dt            => p_rec.wait_perd_cmpltn_dt,
 p_wait_perd_strt_dt              => p_rec.wait_perd_strt_dt  ,
 p_wv_ctfn_typ_cd                 => p_rec.wv_ctfn_typ_cd,
 p_hrs_wkd_val                    => p_rec.hrs_wkd_val,
 p_hrs_wkd_bndry_perd_cd          => p_rec.hrs_wkd_bndry_perd_cd,
 p_prtn_ovridn_flag               => p_rec.prtn_ovridn_flag,
 p_no_mx_prtn_ovrid_thru_flag     => p_rec.no_mx_prtn_ovrid_thru_flag,
 p_prtn_ovridn_rsn_cd             => p_rec.prtn_ovridn_rsn_cd,
 p_age_uom                        => p_rec.age_uom,
 p_los_uom                        => p_rec.los_uom,
 p_ovrid_svc_dt                   => p_rec.ovrid_svc_dt,
 p_inelg_rsn_cd                   => p_rec.inelg_rsn_cd,
 p_frz_los_flag                   => p_rec.frz_los_flag,
 p_frz_age_flag                   => p_rec.frz_age_flag,
 p_frz_cmp_lvl_flag               => p_rec.frz_cmp_lvl_flag,
 p_frz_pct_fl_tm_flag             => p_rec.frz_pct_fl_tm_flag,
 p_frz_hrs_wkd_flag               => p_rec.frz_hrs_wkd_flag,
 p_frz_comb_age_and_los_flag      => p_rec.frz_comb_age_and_los_flag,
 p_dstr_rstcn_flag                => p_rec.dstr_rstcn_flag,
 p_pct_fl_tm_val                  => p_rec.pct_fl_tm_val,
 p_wv_prtn_rsn_cd                 => p_rec.wv_prtn_rsn_cd,
 p_pl_wvd_flag                    => p_rec.pl_wvd_flag,
 p_rt_comp_ref_amt                => p_rec.rt_comp_ref_amt,
 p_rt_cmbn_age_n_los_val          => p_rec.rt_cmbn_age_n_los_val,
 p_rt_comp_ref_uom                => p_rec.rt_comp_ref_uom,
 p_rt_age_val                     => p_rec.rt_age_val,
 p_rt_los_val                     => p_rec.rt_los_val,
 p_rt_hrs_wkd_val                 => p_rec.rt_hrs_wkd_val,
 p_rt_hrs_wkd_bndry_perd_cd       => p_rec.rt_hrs_wkd_bndry_perd_cd,
 p_rt_age_uom                     => p_rec.rt_age_uom,
 p_rt_los_uom                     => p_rec.rt_los_uom,
 p_rt_pct_fl_tm_val               => p_rec.rt_pct_fl_tm_val,
 p_rt_frz_los_flag                => p_rec.rt_frz_los_flag,
 p_rt_frz_age_flag                => p_rec.rt_frz_age_flag,
 p_rt_frz_cmp_lvl_flag            => p_rec.rt_frz_cmp_lvl_flag,
 p_rt_frz_pct_fl_tm_flag          => p_rec.rt_frz_pct_fl_tm_flag,
 p_rt_frz_hrs_wkd_flag            => p_rec.rt_frz_hrs_wkd_flag,
 p_rt_frz_comb_age_and_los_flag   => p_rec.rt_frz_comb_age_and_los_flag,
 p_once_r_cntug_cd                => p_rec.once_r_cntug_cd,
 p_pl_ordr_num                    => p_rec.pl_ordr_num,
 p_plip_ordr_num                  => p_rec.plip_ordr_num,
 p_ptip_ordr_num                  => p_rec.ptip_ordr_num,
 p_pep_attribute_category         => p_rec.pep_attribute_category,
 p_pep_attribute1                 => p_rec.pep_attribute1,
 p_pep_attribute2                 => p_rec.pep_attribute2,
 p_pep_attribute3                 => p_rec.pep_attribute3,
 p_pep_attribute4                 => p_rec.pep_attribute4,
 p_pep_attribute5                 => p_rec.pep_attribute5,
 p_pep_attribute6                 => p_rec.pep_attribute6,
 p_pep_attribute7                 => p_rec.pep_attribute7,
 p_pep_attribute8                 => p_rec.pep_attribute8,
 p_pep_attribute9                 => p_rec.pep_attribute9,
 p_pep_attribute10                => p_rec.pep_attribute10,
 p_pep_attribute11                => p_rec.pep_attribute11,
 p_pep_attribute12                => p_rec.pep_attribute12,
 p_pep_attribute13                => p_rec.pep_attribute13,
 p_pep_attribute14                => p_rec.pep_attribute14,
 p_pep_attribute15                => p_rec.pep_attribute15,
 p_pep_attribute16                => p_rec.pep_attribute16,
 p_pep_attribute17                => p_rec.pep_attribute17,
 p_pep_attribute18                => p_rec.pep_attribute18,
 p_pep_attribute19                => p_rec.pep_attribute19,
 p_pep_attribute20                => p_rec.pep_attribute20,
 p_pep_attribute21                => p_rec.pep_attribute21,
 p_pep_attribute22                => p_rec.pep_attribute22,
 p_pep_attribute23                => p_rec.pep_attribute23,
 p_pep_attribute24                => p_rec.pep_attribute24,
 p_pep_attribute25                => p_rec.pep_attribute25,
 p_pep_attribute26                => p_rec.pep_attribute26,
 p_pep_attribute27                => p_rec.pep_attribute27,
 p_pep_attribute28                => p_rec.pep_attribute28,
 p_pep_attribute29                => p_rec.pep_attribute29,
 p_pep_attribute30                => p_rec.pep_attribute30,
 p_request_id                     => p_rec.request_id,
 p_program_application_id         => p_rec.program_application_id,
 p_program_id                     => p_rec.program_id,
 p_program_update_date            => p_rec.program_update_date,
 p_object_version_number          => p_rec.object_version_number,
 p_effective_date                 => p_effective_date,
 p_validation_start_date          => p_validation_start_date,
 p_validation_end_date            => p_validation_end_date);

Line: 619


End post_insert;

Line: 724


  l_datetrack_mode        varchar2(30) := 'INSERT';

Line: 746


    ben_pep_bus.insert_validate
      (p_rec             => p_rec,
       p_effective_date     => p_effective_date,
       p_datetrack_mode     => l_datetrack_mode,
       p_validation_start_date => l_validation_start_date,
       p_validation_end_date     => l_validation_end_date);

Line: 757


  pre_insert
     (p_rec             => p_rec,
     p_effective_date     => p_effective_date,
     p_datetrack_mode     => l_datetrack_mode,
     p_validation_start_date => l_validation_start_date,
     p_validation_end_date     => l_validation_end_date);

Line: 766


  insert_dml
     (p_rec             => p_rec,
     p_effective_date     => p_effective_date,
     p_datetrack_mode     => l_datetrack_mode,
     p_validation_start_date => l_validation_start_date,
     p_validation_end_date     => l_validation_end_date);

Line: 775


  post_insert
     (p_rec             => p_rec,
     p_effective_date     => p_effective_date,
     p_datetrack_mode     => l_datetrack_mode,
     p_validation_start_date => l_validation_start_date,
     p_validation_end_date     => l_validation_end_date);

Line: 887


  p_program_update_date          in date             default null,
  p_object_version_number        out nocopy number,
  p_effective_date		 in date,
  --
  p_override_validation          in boolean          default false
  )
is
--
  l_rec        ben_pep_shd.g_rec_type;

Line: 1006


  p_program_update_date,
  null
  );