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.HR_CLE_INS SQL Statements

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

Line: 79


Procedure dt_insert_dml
  (p_rec                     in out nocopy hr_cle_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   hr_de_soc_ins_contr_lvls_f t
    where  t.soc_ins_contr_lvls_id       = p_rec.soc_ins_contr_lvls_id
    and    t.effective_start_date =
             hr_cle_shd.g_old_rec.effective_start_date
    and    t.effective_end_date   = (p_validation_start_date - 1);

Line: 97


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

Line: 100


  l_last_update_date    hr_de_soc_ins_contr_lvls_f.last_update_date%TYPE;

Line: 101


  l_last_updated_by     hr_de_soc_ins_contr_lvls_f.last_updated_by%TYPE;

Line: 102


  l_last_update_login   hr_de_soc_ins_contr_lvls_f.last_update_login%TYPE;

Line: 125


  If (p_datetrack_mode <> hr_api.g_insert) then
    hr_utility.set_location(l_proc, 10);

Line: 147


    l_last_update_date   := sysdate;

Line: 148


    l_last_updated_by    := fnd_global.user_id;

Line: 149


    l_last_update_login  := fnd_global.login_id;

Line: 156


  insert into hr_de_soc_ins_contr_lvls_f
      (soc_ins_contr_lvls_id
      ,organization_id
      ,normal_percentage
      ,normal_amount
      ,increased_percentage
      ,increased_amount
      ,reduced_percentage
      ,reduced_amount
      ,effective_start_date
      ,effective_end_date
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,attribute16
      ,attribute17
      ,attribute18
      ,attribute19
      ,attribute20
      ,object_version_number
      ,attribute21
      ,attribute22
      ,attribute23
      ,attribute24
      ,attribute25
      ,attribute26
      ,attribute27
      ,attribute28
      ,attribute29
      ,attribute30
      ,flat_tax_limit_per_month
      ,flat_tax_limit_per_year
      ,min_increased_contribution
      ,max_increased_contribution
      ,month1
      ,month1_min_contribution
      ,month1_max_contribution
      ,month2
      ,month2_min_contribution
      ,month2_max_contribution
      ,employee_contribution
      ,contribution_level_type
      ,created_by
      ,creation_date
      ,last_update_date
      ,last_updated_by
      ,last_update_login
      )
  Values
    (p_rec.soc_ins_contr_lvls_id
    ,p_rec.organization_id
    ,p_rec.normal_percentage
    ,p_rec.normal_amount
    ,p_rec.increased_percentage
    ,p_rec.increased_amount
    ,p_rec.reduced_percentage
    ,p_rec.reduced_amount
    ,p_rec.effective_start_date
    ,p_rec.effective_end_date
    ,p_rec.attribute_category
    ,p_rec.attribute1
    ,p_rec.attribute2
    ,p_rec.attribute3
    ,p_rec.attribute4
    ,p_rec.attribute5
    ,p_rec.attribute6
    ,p_rec.attribute7
    ,p_rec.attribute8
    ,p_rec.attribute9
    ,p_rec.attribute10
    ,p_rec.attribute11
    ,p_rec.attribute12
    ,p_rec.attribute13
    ,p_rec.attribute14
    ,p_rec.attribute15
    ,p_rec.attribute16
    ,p_rec.attribute17
    ,p_rec.attribute18
    ,p_rec.attribute19
    ,p_rec.attribute20
    ,p_rec.object_version_number
    ,p_rec.attribute21
    ,p_rec.attribute22
    ,p_rec.attribute23
    ,p_rec.attribute24
    ,p_rec.attribute25
    ,p_rec.attribute26
    ,p_rec.attribute27
    ,p_rec.attribute28
    ,p_rec.attribute29
    ,p_rec.attribute30
    ,p_rec.flat_tax_limit_per_month
    ,p_rec.flat_tax_limit_per_year
    ,p_rec.min_increased_contribution
    ,p_rec.max_increased_contribution
    ,p_rec.month1
    ,p_rec.month1_min_contribution
    ,p_rec.month1_max_contribution
    ,p_rec.month2
    ,p_rec.month2_min_contribution
    ,p_rec.month2_max_contribution
    ,p_rec.employee_contribution
    ,p_rec.contribution_level_type
    ,l_created_by
    ,l_creation_date
    ,l_last_update_date
    ,l_last_updated_by
    ,l_last_update_login
    );

Line: 296


End dt_insert_dml;

Line: 301


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


  hr_cle_ins.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: 323


End insert_dml;

Line: 364


Procedure pre_insert
  (p_rec                   in out nocopy hr_cle_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 C_Sel1 is select hr_de_soc_ins_contr_lvls_s.nextval from sys.dual;

Line: 375


    Select null
      from hr_de_soc_ins_contr_lvls_f
     where soc_ins_contr_lvls_id =
             hr_cle_ins.g_soc_ins_contr_lvls_id_i;

Line: 380


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

Line: 422


End pre_insert;

Line: 456


Procedure post_insert
  (p_rec                   in hr_cle_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: 470


    hr_cle_rki.after_insert
      (p_effective_date
      => p_effective_date
      ,p_validation_start_date
      => p_validation_start_date
      ,p_validation_end_date
      => p_validation_end_date
      ,p_soc_ins_contr_lvls_id
      => p_rec.soc_ins_contr_lvls_id
      ,p_organization_id
      => p_rec.organization_id
      ,p_normal_percentage
      => p_rec.normal_percentage
      ,p_normal_amount
      => p_rec.normal_amount
      ,p_increased_percentage
      => p_rec.increased_percentage
      ,p_increased_amount
      => p_rec.increased_amount
      ,p_reduced_percentage
      => p_rec.reduced_percentage
      ,p_reduced_amount
      => p_rec.reduced_amount
      ,p_effective_start_date
      => p_rec.effective_start_date
      ,p_effective_end_date
      => p_rec.effective_end_date
      ,p_attribute_category
      => p_rec.attribute_category
      ,p_attribute1
      => p_rec.attribute1
      ,p_attribute2
      => p_rec.attribute2
      ,p_attribute3
      => p_rec.attribute3
      ,p_attribute4
      => p_rec.attribute4
      ,p_attribute5
      => p_rec.attribute5
      ,p_attribute6
      => p_rec.attribute6
      ,p_attribute7
      => p_rec.attribute7
      ,p_attribute8
      => p_rec.attribute8
      ,p_attribute9
      => p_rec.attribute9
      ,p_attribute10
      => p_rec.attribute10
      ,p_attribute11
      => p_rec.attribute11
      ,p_attribute12
      => p_rec.attribute12
      ,p_attribute13
      => p_rec.attribute13
      ,p_attribute14
      => p_rec.attribute14
      ,p_attribute15
      => p_rec.attribute15
      ,p_attribute16
      => p_rec.attribute16
      ,p_attribute17
      => p_rec.attribute17
      ,p_attribute18
      => p_rec.attribute18
      ,p_attribute19
      => p_rec.attribute19
      ,p_attribute20
      => p_rec.attribute20
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_attribute21
      => p_rec.attribute21
      ,p_attribute22
      => p_rec.attribute22
      ,p_attribute23
      => p_rec.attribute23
      ,p_attribute24
      => p_rec.attribute24
      ,p_attribute25
      => p_rec.attribute25
      ,p_attribute26
      => p_rec.attribute26
      ,p_attribute27
      => p_rec.attribute27
      ,p_attribute28
      => p_rec.attribute28
      ,p_attribute29
      => p_rec.attribute29
      ,p_attribute30
      => p_rec.attribute30
      ,p_flat_tax_limit_per_month
      => p_rec.flat_tax_limit_per_month
      ,p_flat_tax_limit_per_year
      => p_rec.flat_tax_limit_per_year
      ,p_min_increased_contribution
      => p_rec.min_increased_contribution
      ,p_max_increased_contribution
      => p_rec.max_increased_contribution
      ,p_month1
      => p_rec.month1
      ,p_month1_min_contribution
      => p_rec.month1_min_contribution
      ,p_month1_max_contribution
      => p_rec.month1_max_contribution
      ,p_month2
      => p_rec.month2
      ,p_month2_min_contribution
       => p_rec.month2_min_contribution
      ,p_month2_max_contribution
       => p_rec.month2_max_contribution
      ,p_employee_contribution
       => p_rec.employee_contribution
      ,p_contribution_level_type
      => p_rec.contribution_level_type
      );

Line: 598


End post_insert;

Line: 683


  l_datetrack_mode              varchar2(30) := hr_api.g_insert;

Line: 702


  hr_cle_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: 712


  hr_cle_ins.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: 722


  hr_cle_ins.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: 732


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