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_EPA_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_epa_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_prtn_elig_f t
    where  t.prtn_elig_id       = p_rec.prtn_elig_id
    and    t.effective_start_date =
             ben_epa_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_prtn_elig_f.last_update_date%TYPE;

Line: 79


  l_last_updated_by     ben_prtn_elig_f.last_updated_by%TYPE;

Line: 80


  l_last_update_login   ben_prtn_elig_f.last_update_login%TYPE;

Line: 102


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

Line: 124


    l_last_update_date   := sysdate;

Line: 125


    l_last_updated_by    := fnd_global.user_id;

Line: 126


    l_last_update_login  := fnd_global.login_id;

Line: 133


  insert into ben_prtn_elig_f
  (    prtn_elig_id,
    effective_start_date,
    effective_end_date,
    business_group_id,
    pgm_id,
    pl_id,
    oipl_id,
    ptip_id,
    plip_id,
    trk_scr_for_inelg_flag,
    prtn_eff_strt_dt_cd,
    prtn_eff_end_dt_cd,
    prtn_eff_strt_dt_rl,
    prtn_eff_end_dt_rl,
    wait_perd_dt_to_use_cd,
    wait_perd_dt_to_use_rl,
    wait_perd_val,
    wait_perd_uom,
    wait_perd_rl,
    mx_poe_det_dt_cd,
    mx_poe_det_dt_rl,
    mx_poe_val,
    mx_poe_uom,
    mx_poe_rl,
    mx_poe_apls_cd,
    epa_attribute_category,
    epa_attribute1,
    epa_attribute2,
    epa_attribute3,
    epa_attribute4,
    epa_attribute5,
    epa_attribute6,
    epa_attribute7,
    epa_attribute8,
    epa_attribute9,
    epa_attribute10,
    epa_attribute11,
    epa_attribute12,
    epa_attribute13,
    epa_attribute14,
    epa_attribute15,
    epa_attribute16,
    epa_attribute17,
    epa_attribute18,
    epa_attribute19,
    epa_attribute20,
    epa_attribute21,
    epa_attribute22,
    epa_attribute23,
    epa_attribute24,
    epa_attribute25,
    epa_attribute26,
    epa_attribute27,
    epa_attribute28,
    epa_attribute29,
    epa_attribute30,
    object_version_number,
    created_by,
       creation_date,
       last_update_date,
       last_updated_by,
       last_update_login
  )
  Values
  (    p_rec.prtn_elig_id,
    p_rec.effective_start_date,
    p_rec.effective_end_date,
    p_rec.business_group_id,
    p_rec.pgm_id,
    p_rec.pl_id,
    p_rec.oipl_id,
    p_rec.ptip_id,
    p_rec.plip_id,
    nvl(p_rec.trk_scr_for_inelg_flag,'N'),
    p_rec.prtn_eff_strt_dt_cd,
    p_rec.prtn_eff_end_dt_cd,
    p_rec.prtn_eff_strt_dt_rl,
    p_rec.prtn_eff_end_dt_rl,
    p_rec.wait_perd_dt_to_use_cd,
    p_rec.wait_perd_dt_to_use_rl,
    p_rec.wait_perd_val,
    p_rec.wait_perd_uom,
    p_rec.wait_perd_rl,
    p_rec.mx_poe_det_dt_cd,
    p_rec.mx_poe_det_dt_rl,
    p_rec.mx_poe_val,
    p_rec.mx_poe_uom,
    p_rec.mx_poe_rl,
    p_rec.mx_poe_apls_cd,
    p_rec.epa_attribute_category,
    p_rec.epa_attribute1,
    p_rec.epa_attribute2,
    p_rec.epa_attribute3,
    p_rec.epa_attribute4,
    p_rec.epa_attribute5,
    p_rec.epa_attribute6,
    p_rec.epa_attribute7,
    p_rec.epa_attribute8,
    p_rec.epa_attribute9,
    p_rec.epa_attribute10,
    p_rec.epa_attribute11,
    p_rec.epa_attribute12,
    p_rec.epa_attribute13,
    p_rec.epa_attribute14,
    p_rec.epa_attribute15,
    p_rec.epa_attribute16,
    p_rec.epa_attribute17,
    p_rec.epa_attribute18,
    p_rec.epa_attribute19,
    p_rec.epa_attribute20,
    p_rec.epa_attribute21,
    p_rec.epa_attribute22,
    p_rec.epa_attribute23,
    p_rec.epa_attribute24,
    p_rec.epa_attribute25,
    p_rec.epa_attribute26,
    p_rec.epa_attribute27,
    p_rec.epa_attribute28,
    p_rec.epa_attribute29,
    p_rec.epa_attribute30,
    p_rec.object_version_number,
    l_created_by,
       l_creation_date,
       l_last_update_date,
       l_last_updated_by,
       l_last_update_login
  );

Line: 279


End dt_insert_dml;

Line: 284


Procedure insert_dml
    (p_rec              in out nocopy ben_epa_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: 296


  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: 303


End insert_dml;

Line: 344


Procedure pre_insert
    (p_rec              in out nocopy ben_epa_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: 353


  cursor c1 is select ben_prtn_elig_f_s.nextval from sys.dual;

Line: 363


End pre_insert;

Line: 397


Procedure post_insert
    (p_rec              in ben_epa_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: 413


    ben_epa_rki.after_insert
      (
       p_prtn_elig_id                  =>p_rec.prtn_elig_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_pgm_id                        =>p_rec.pgm_id
      ,p_pl_id                         =>p_rec.pl_id
      ,p_oipl_id                       =>p_rec.oipl_id
      ,p_ptip_id                       =>p_rec.ptip_id
      ,p_plip_id                       =>p_rec.plip_id
      ,p_trk_scr_for_inelg_flag        =>p_rec.trk_scr_for_inelg_flag
      ,p_prtn_eff_strt_dt_cd           =>p_rec.prtn_eff_strt_dt_cd
      ,p_prtn_eff_end_dt_cd            =>p_rec.prtn_eff_end_dt_cd
      ,p_prtn_eff_strt_dt_rl           =>p_rec.prtn_eff_strt_dt_rl
      ,p_prtn_eff_end_dt_rl            =>p_rec.prtn_eff_end_dt_rl
      ,p_wait_perd_dt_to_use_cd        =>p_rec.wait_perd_dt_to_use_cd
      ,p_wait_perd_dt_to_use_rl        =>p_rec.wait_perd_dt_to_use_rl
      ,p_wait_perd_val                 =>p_rec.wait_perd_val
      ,p_wait_perd_uom                 =>p_rec.wait_perd_uom
      ,p_wait_perd_rl                  =>p_rec.wait_perd_rl
      ,p_mx_poe_det_dt_cd              =>p_rec.mx_poe_det_dt_cd
      ,p_mx_poe_det_dt_rl              =>p_rec.mx_poe_det_dt_rl
      ,p_mx_poe_val                    =>p_rec.mx_poe_val
      ,p_mx_poe_uom                    =>p_rec.mx_poe_uom
      ,p_mx_poe_rl                     =>p_rec.mx_poe_rl
      ,p_mx_poe_apls_cd                =>p_rec.mx_poe_apls_cd
      ,p_epa_attribute_category        =>p_rec.epa_attribute_category
      ,p_epa_attribute1                =>p_rec.epa_attribute1
      ,p_epa_attribute2                =>p_rec.epa_attribute2
      ,p_epa_attribute3                =>p_rec.epa_attribute3
      ,p_epa_attribute4                =>p_rec.epa_attribute4
      ,p_epa_attribute5                =>p_rec.epa_attribute5
      ,p_epa_attribute6                =>p_rec.epa_attribute6
      ,p_epa_attribute7                =>p_rec.epa_attribute7
      ,p_epa_attribute8                =>p_rec.epa_attribute8
      ,p_epa_attribute9                =>p_rec.epa_attribute9
      ,p_epa_attribute10               =>p_rec.epa_attribute10
      ,p_epa_attribute11               =>p_rec.epa_attribute11
      ,p_epa_attribute12               =>p_rec.epa_attribute12
      ,p_epa_attribute13               =>p_rec.epa_attribute13
      ,p_epa_attribute14               =>p_rec.epa_attribute14
      ,p_epa_attribute15               =>p_rec.epa_attribute15
      ,p_epa_attribute16               =>p_rec.epa_attribute16
      ,p_epa_attribute17               =>p_rec.epa_attribute17
      ,p_epa_attribute18               =>p_rec.epa_attribute18
      ,p_epa_attribute19               =>p_rec.epa_attribute19
      ,p_epa_attribute20               =>p_rec.epa_attribute20
      ,p_epa_attribute21               =>p_rec.epa_attribute21
      ,p_epa_attribute22               =>p_rec.epa_attribute22
      ,p_epa_attribute23               =>p_rec.epa_attribute23
      ,p_epa_attribute24               =>p_rec.epa_attribute24
      ,p_epa_attribute25               =>p_rec.epa_attribute25
      ,p_epa_attribute26               =>p_rec.epa_attribute26
      ,p_epa_attribute27               =>p_rec.epa_attribute27
      ,p_epa_attribute28               =>p_rec.epa_attribute28
      ,p_epa_attribute29               =>p_rec.epa_attribute29
      ,p_epa_attribute30               =>p_rec.epa_attribute30
      ,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: 491


End post_insert;

Line: 594


  l_datetrack_mode        varchar2(30) := 'INSERT';

Line: 612


  ben_epa_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: 621


  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: 630


  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: 639


  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);