APPS.PAY_STA_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_sta_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_state_tax_rules_f
    where       emp_state_tax_rule_id = p_rec.emp_state_tax_rule_id
    and        effective_start_date = p_validation_start_date;

Line: 83

    delete from pay_us_emp_state_tax_rules_f
    where        emp_state_tax_rule_id = p_rec.emp_state_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_sta_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_sta_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_sta_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_sta_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: 301

 /*    pay_sta_rkd.after_delete
      (
  p_emp_state_tax_rule_id      =>p_rec.emp_state_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_sta_shd.g_old_rec.effective_start_date
 ,p_effective_end_date_o       =>pay_sta_shd.g_old_rec.effective_end_date
 ,p_assignment_id_o            =>pay_sta_shd.g_old_rec.assignment_id
 ,p_state_code_o               =>pay_sta_shd.g_old_rec.state_code
 ,p_jurisdiction_code_o        =>pay_sta_shd.g_old_rec.jurisdiction_code
 ,p_business_group_id_o        =>pay_sta_shd.g_old_rec.business_group_id
 ,p_additional_wa_amount_o     =>pay_sta_shd.g_old_rec.additional_wa_amount
 ,p_filing_status_code_o       =>pay_sta_shd.g_old_rec.filing_status_code
 ,p_remainder_percent_o        =>pay_sta_shd.g_old_rec.remainder_percent
 ,p_secondary_wa_o             =>pay_sta_shd.g_old_rec.secondary_wa
 ,p_sit_additional_tax_o       =>pay_sta_shd.g_old_rec.sit_additional_tax
 ,p_sit_override_amount_o      =>pay_sta_shd.g_old_rec.sit_override_amount
 ,p_sit_override_rate_o        =>pay_sta_shd.g_old_rec.sit_override_rate
 ,p_withholding_allowances_o   =>pay_sta_shd.g_old_rec.withholding_allowances
 ,p_excessive_wa_reject_date_o =>pay_sta_shd.g_old_rec.excessive_wa_reject_date
 ,p_sdi_exempt_o               =>pay_sta_shd.g_old_rec.sdi_exempt
 ,p_sit_exempt_o               =>pay_sta_shd.g_old_rec.sit_exempt
 ,p_sit_optional_calc_ind_o    =>pay_sta_shd.g_old_rec.sit_optional_calc_ind
 ,p_state_non_resident_cert_o  =>pay_sta_shd.g_old_rec.state_non_resident_cert
 ,p_sui_exempt_o               =>pay_sta_shd.g_old_rec.sui_exempt
 ,p_wc_exempt_o                =>pay_sta_shd.g_old_rec.wc_exempt
 ,p_wage_exempt_o              =>pay_sta_shd.g_old_rec.wage_exempt
 ,p_sui_wage_base_override_amo_o =>
                            pay_sta_shd.g_old_rec.sui_wage_base_override_amount
 ,p_supp_tax_override_rate_o   =>pay_sta_shd.g_old_rec.supp_tax_override_rate
 ,p_object_version_number_o    =>pay_sta_shd.g_old_rec.object_version_number
      );

Line: 356

End post_delete;

Line: 366

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

Line: 392

  pay_sta_bus.delete_validate
      (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
      ,p_delete_routine        => p_delete_routine
      );

Line: 403

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

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

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

  ,p_delete_routine        in     	 varchar2   default null
  ) is
--
  l_rec            pay_sta_shd.g_rec_type;

Line: 462

  del(l_rec, p_effective_date, p_datetrack_mode, p_delete_routine);