APPS.PAY_CNT_DEL SQL Statements

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

Line: 53

Procedure dt_delete_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||'dt_delete_dml';

Line: 64

  If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
    hr_utility.set_location(l_proc, 10);

Line: 71

    delete from pay_us_emp_county_tax_rules_f
    where       emp_county_tax_rule_id = p_rec.emp_county_tax_rule_id
    and        effective_start_date = p_validation_start_date;

Line: 83

    delete from pay_us_emp_county_tax_rules_f
    where        emp_county_tax_rule_id = p_rec.emp_county_tax_rule_id
    and        effective_start_date >= p_validation_start_date;

Line: 96

End dt_delete_dml;

Line: 101

Procedure delete_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||'delete_dml';

Line: 113

  dt_delete_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: 120

End delete_dml;

Line: 155

Procedure dt_pre_delete
      (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||'dt_pre_delete';

Line: 171

    If (p_datetrack_mode = 'DELETE') then
      p_rec.effective_end_date := p_validation_start_date - 1;

Line: 191

End dt_pre_delete;

Line: 226

Procedure pre_delete
      (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_delete';

Line: 242

  dt_pre_delete
    (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: 250

End pre_delete;

Line: 284

Procedure post_delete
      (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_delete';

Line: 302

    pay_cnt_rkd.after_delete
      (
  p_emp_county_tax_rule_id     =>p_rec.emp_county_tax_rule_id
 ,p_datetrack_mode             =>p_datetrack_mode
 ,p_effective_date             =>p_effective_date
 ,p_object_version_number      =>p_rec.object_version_number
 ,p_validation_start_date      =>p_validation_start_date
 ,p_validation_end_date        =>p_validation_end_date
 ,p_effective_start_date       =>p_rec.effective_start_date
 ,p_effective_end_date         =>p_rec.effective_end_date
 ,p_effective_start_date_o     =>pay_cnt_shd.g_old_rec.effective_start_date
 ,p_effective_end_date_o       =>pay_cnt_shd.g_old_rec.effective_end_date
 ,p_assignment_id_o            =>pay_cnt_shd.g_old_rec.assignment_id
 ,p_state_code_o               =>pay_cnt_shd.g_old_rec.state_code
 ,p_county_code_o              =>pay_cnt_shd.g_old_rec.county_code
 ,p_business_group_id_o        =>pay_cnt_shd.g_old_rec.business_group_id
 ,p_additional_wa_rate_o       =>pay_cnt_shd.g_old_rec.additional_wa_rate
 ,p_filing_status_code_o       =>pay_cnt_shd.g_old_rec.filing_status_code
 ,p_jurisdiction_code_o        =>pay_cnt_shd.g_old_rec.jurisdiction_code
 ,p_lit_additional_tax_o       =>pay_cnt_shd.g_old_rec.lit_additional_tax
 ,p_lit_override_amount_o      =>pay_cnt_shd.g_old_rec.lit_override_amount
 ,p_lit_override_rate_o        =>pay_cnt_shd.g_old_rec.lit_override_rate
 ,p_withholding_allowances_o   =>pay_cnt_shd.g_old_rec.withholding_allowances
 ,p_lit_exempt_o               =>pay_cnt_shd.g_old_rec.lit_exempt
 ,p_sd_exempt_o                =>pay_cnt_shd.g_old_rec.sd_exempt
 ,p_ht_exempt_o                =>pay_cnt_shd.g_old_rec.ht_exempt
 ,p_wage_exempt_o              =>pay_cnt_shd.g_old_rec.wage_exempt
 ,p_school_district_code_o     =>pay_cnt_shd.g_old_rec.school_district_code
 ,p_object_version_number_o    =>pay_cnt_shd.g_old_rec.object_version_number
      );

Line: 349

End post_delete;

Line: 359

  p_delete_routine      in      varchar2
  ) is
--
  l_proc                  varchar2(72) := g_package||'del';

Line: 385

  pay_cnt_bus.delete_validate
      (p_rec                   => p_rec,
       p_effective_date        => p_effective_date,
       p_datetrack_mode        => p_datetrack_mode,
       p_delete_routine        => p_delete_routine,
       p_validation_start_date => l_validation_start_date,
       p_validation_end_date   => l_validation_end_date);

Line: 395

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

Line: 404

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

Line: 413

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

Line: 432

  p_delete_routine         in     varchar2
  ) is
--
  l_rec      pay_cnt_shd.g_rec_type;

Line: 453

  del(l_rec, p_effective_date, p_datetrack_mode, p_delete_routine);