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.PAY_CNT_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 pay_cnt_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   pay_us_emp_county_tax_rules_f t
    where  t.emp_county_tax_rule_id       = p_rec.emp_county_tax_rule_id
    and    t.effective_start_date =
             pay_cnt_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    pay_us_emp_county_tax_rules_f.last_update_date%TYPE;

Line: 79


  l_last_updated_by     pay_us_emp_county_tax_rules_f.last_updated_by%TYPE;

Line: 80


  l_last_update_login   pay_us_emp_county_tax_rules_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 pay_us_emp_county_tax_rules_f
  (   emp_county_tax_rule_id,
      effective_start_date,
      effective_end_date,
      assignment_id,
      state_code,
      county_code,
      business_group_id,
      additional_wa_rate,
      filing_status_code,
      jurisdiction_code,
      lit_additional_tax,
      lit_override_amount,
      lit_override_rate,
      withholding_allowances,
      lit_exempt,
      sd_exempt,
      ht_exempt,
      wage_exempt,
      school_district_code,
      object_version_number
      , created_by,
      creation_date,
      last_update_date,
      last_updated_by,
      last_update_login,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      attribute16,
      attribute17,
      attribute18,
      attribute19,
      attribute20,
      attribute21,
      attribute22,
      attribute23,
      attribute24,
      attribute25,
      attribute26,
      attribute27,
      attribute28,
      attribute29,
      attribute30,
      cnt_information_category,
      cnt_information1,
      cnt_information2,
      cnt_information3,
      cnt_information4,
      cnt_information5,
      cnt_information6,
      cnt_information7,
      cnt_information8,
      cnt_information9,
      cnt_information10,
      cnt_information11,
      cnt_information12,
      cnt_information13,
      cnt_information14,
      cnt_information15,
      cnt_information16,
      cnt_information17,
      cnt_information18,
      cnt_information19,
      cnt_information20,
      cnt_information21,
      cnt_information22,
      cnt_information23,
      cnt_information24,
      cnt_information25,
      cnt_information26,
      cnt_information27,
      cnt_information28,
      cnt_information29,
      cnt_information30

  )
  Values
  (   p_rec.emp_county_tax_rule_id,
      p_rec.effective_start_date,
      p_rec.effective_end_date,
      p_rec.assignment_id,
      p_rec.state_code,
      p_rec.county_code,
      p_rec.business_group_id,
      p_rec.additional_wa_rate,
      p_rec.filing_status_code,
      p_rec.jurisdiction_code,
      p_rec.lit_additional_tax,
      p_rec.lit_override_amount,
      p_rec.lit_override_rate,
      p_rec.withholding_allowances,
      p_rec.lit_exempt,
      p_rec.sd_exempt,
      p_rec.ht_exempt,
      p_rec.wage_exempt,
      p_rec.school_district_code,
      p_rec.object_version_number
      , l_created_by,
      l_creation_date,
      l_last_update_date,
      l_last_updated_by,
      l_last_update_login,
      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.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.cnt_information_category,
      p_rec.cnt_information1,
      p_rec.cnt_information2,
      p_rec.cnt_information3,
      p_rec.cnt_information4,
      p_rec.cnt_information5,
      p_rec.cnt_information6,
      p_rec.cnt_information7,
      p_rec.cnt_information8,
      p_rec.cnt_information9,
      p_rec.cnt_information10,
      p_rec.cnt_information11,
      p_rec.cnt_information12,
      p_rec.cnt_information13,
      p_rec.cnt_information14,
      p_rec.cnt_information15,
      p_rec.cnt_information16,
      p_rec.cnt_information17,
      p_rec.cnt_information18,
      p_rec.cnt_information19,
      p_rec.cnt_information20,
      p_rec.cnt_information21,
      p_rec.cnt_information22,
      p_rec.cnt_information23,
      p_rec.cnt_information24,
      p_rec.cnt_information25,
      p_rec.cnt_information26,
      p_rec.cnt_information27,
      p_rec.cnt_information28,
      p_rec.cnt_information29,
      p_rec.cnt_information30
  );

Line: 330


End dt_insert_dml;

Line: 335


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


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


End insert_dml;

Line: 395


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


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

Line: 418


End pre_insert;

Line: 452


Procedure post_insert
      (p_rec                   in pay_cnt_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


    pay_cnt_rki.after_insert
      (
  p_emp_county_tax_rule_id        =>p_rec.emp_county_tax_rule_id
 ,p_effective_start_date          =>p_rec.effective_start_date
 ,p_effective_end_date            =>p_rec.effective_end_date
 ,p_assignment_id                 =>p_rec.assignment_id
 ,p_state_code                    =>p_rec.state_code
 ,p_county_code                   =>p_rec.county_code
 ,p_business_group_id             =>p_rec.business_group_id
 ,p_additional_wa_rate            =>p_rec.additional_wa_rate
 ,p_filing_status_code            =>p_rec.filing_status_code
 ,p_jurisdiction_code             =>p_rec.jurisdiction_code
 ,p_lit_additional_tax            =>p_rec.lit_additional_tax
 ,p_lit_override_amount           =>p_rec.lit_override_amount
 ,p_lit_override_rate             =>p_rec.lit_override_rate
 ,p_withholding_allowances        =>p_rec.withholding_allowances
 ,p_lit_exempt                    =>p_rec.lit_exempt
 ,p_sd_exempt                     =>p_rec.sd_exempt
 ,p_ht_exempt                     =>p_rec.ht_exempt
 ,p_wage_exempt                   =>p_rec.wage_exempt
 ,p_school_district_code          =>p_rec.school_district_code
 ,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: 513


End post_insert;

Line: 601


  l_datetrack_mode            varchar2(30) := 'INSERT';

Line: 619


  pay_cnt_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: 628


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


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


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