APPS.BEN_PEI_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_pei_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_pl_extract_identifier_f t
    where  t.pl_extract_identifier_id = p_rec.pl_extract_identifier_id
    and    t.effective_start_date =  ben_pei_shd.g_old_rec.effective_start_date
    and    t.effective_end_date   = (p_validation_start_date - 1);

Line: 74

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

Line: 77

  l_last_update_date    ben_pl_extract_identifier_f.last_update_date%TYPE;

Line: 78

  l_last_updated_by     ben_pl_extract_identifier_f.last_updated_by%TYPE;

Line: 79

  l_last_update_login   ben_pl_extract_identifier_f.last_update_login%TYPE;

Line: 101

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

Line: 123

    l_last_update_date   := sysdate;

Line: 124

    l_last_updated_by    := fnd_global.user_id;

Line: 125

    l_last_update_login  := fnd_global.login_id;

Line: 132

  insert into ben_pl_extract_identifier_f
    (
     pl_extract_identifier_id
    ,pl_id
    ,plip_id
    ,oipl_id
    ,third_party_identifier
    ,organization_id
    ,job_id
    ,position_id
    ,people_group_id
    ,grade_id
    ,payroll_id
    ,home_state
    ,home_zip
    ,effective_start_date
    ,effective_end_date
    ,created_by
    ,creation_date
    ,last_update_date
    ,last_updated_by
    ,last_update_login
    ,object_version_number
    ,business_group_id
    )
  values
    (
     p_rec.pl_extract_identifier_id
    ,p_rec.pl_id
    ,p_rec.plip_id
    ,p_rec.oipl_id
    ,p_rec.third_party_identifier
    ,p_rec.organization_id
    ,p_rec.job_id
    ,p_rec.position_id
    ,p_rec.people_group_id
    ,p_rec.grade_id
    ,p_rec.payroll_id
    ,p_rec.home_state
    ,p_rec.home_zip
    ,p_rec.effective_start_date
    ,p_rec.effective_end_date
    ,p_rec.created_by
    ,p_rec.creation_date
    ,p_rec.last_update_date
    ,p_rec.last_updated_by
    ,p_rec.last_update_login
    ,p_rec.object_version_number
    ,p_rec.business_group_id
    );

Line: 200

End dt_insert_dml;

Line: 205

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

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

End insert_dml;

Line: 265

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

    select ben_pl_extract_identifier_s.nextval
    from   sys.dual;

Line: 286

End pre_insert;

Line: 320

Procedure post_insert
    (p_rec			in ben_pei_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: 336

    ben_pei_rki.after_insert
    (
      p_pl_extract_identifier_id => p_rec.pl_extract_identifier_id
     ,p_pl_id                    => p_rec.pl_id
     ,p_plip_id                  => p_rec.plip_id
     ,p_oipl_id                  => p_rec.oipl_id
     ,p_third_party_identifier   => p_rec.third_party_identifier
     ,p_organization_id          => p_rec.organization_id
     ,p_job_id                   => p_rec.job_id
     ,p_position_id              => p_rec.position_id
     ,p_people_group_id          => p_rec.people_group_id
     ,p_grade_id                 => p_rec.grade_id
     ,p_payroll_id               => p_rec.payroll_id
     ,p_home_state               => p_rec.home_state
     ,p_home_zip                 => p_rec.home_zip
     ,p_effective_start_date     => p_rec.effective_start_date
     ,p_effective_end_date       => p_rec.effective_end_date
     ,p_object_version_number    => p_rec.object_version_number
     ,p_business_group_id        => p_rec.business_group_id
     ,p_effective_date           => p_effective_date
     ,p_validation_start_date    => p_validation_start_date
     ,p_validation_end_date      => p_validation_end_date
    );

Line: 373

End post_insert;

Line: 458

  l_datetrack_mode        varchar2(30) := 'INSERT';

Line: 477

  ben_pei_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: 487

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

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

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