DBA Data[Home] [Help]

APPS.BEN_SVA_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 ben_sva_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 ben_svc_area_f
    where       svc_area_id = p_rec.svc_area_id
    and	  effective_start_date = p_validation_start_date;
Line: 83

    delete from ben_svc_area_f
    where        svc_area_id = p_rec.svc_area_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 ben_sva_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 ben_sva_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 ben_sva_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 ben_sva_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

    ben_sva_rkd.after_delete
      (
  p_svc_area_id                   =>p_rec.svc_area_id
 ,p_datetrack_mode                =>p_datetrack_mode
 ,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        =>ben_sva_shd.g_old_rec.effective_start_date
 ,p_effective_end_date_o          =>ben_sva_shd.g_old_rec.effective_end_date
 ,p_name_o                        =>ben_sva_shd.g_old_rec.name
 ,p_org_unit_prdct_o              =>ben_sva_shd.g_old_rec.org_unit_prdct
 ,p_business_group_id_o           =>ben_sva_shd.g_old_rec.business_group_id
 ,p_sva_attribute_category_o      =>ben_sva_shd.g_old_rec.sva_attribute_category
 ,p_sva_attribute1_o              =>ben_sva_shd.g_old_rec.sva_attribute1
 ,p_sva_attribute2_o              =>ben_sva_shd.g_old_rec.sva_attribute2
 ,p_sva_attribute3_o              =>ben_sva_shd.g_old_rec.sva_attribute3
 ,p_sva_attribute4_o              =>ben_sva_shd.g_old_rec.sva_attribute4
 ,p_sva_attribute5_o              =>ben_sva_shd.g_old_rec.sva_attribute5
 ,p_sva_attribute6_o              =>ben_sva_shd.g_old_rec.sva_attribute6
 ,p_sva_attribute7_o              =>ben_sva_shd.g_old_rec.sva_attribute7
 ,p_sva_attribute8_o              =>ben_sva_shd.g_old_rec.sva_attribute8
 ,p_sva_attribute9_o              =>ben_sva_shd.g_old_rec.sva_attribute9
 ,p_sva_attribute10_o             =>ben_sva_shd.g_old_rec.sva_attribute10
 ,p_sva_attribute11_o             =>ben_sva_shd.g_old_rec.sva_attribute11
 ,p_sva_attribute12_o             =>ben_sva_shd.g_old_rec.sva_attribute12
 ,p_sva_attribute13_o             =>ben_sva_shd.g_old_rec.sva_attribute13
 ,p_sva_attribute14_o             =>ben_sva_shd.g_old_rec.sva_attribute14
 ,p_sva_attribute15_o             =>ben_sva_shd.g_old_rec.sva_attribute15
 ,p_sva_attribute16_o             =>ben_sva_shd.g_old_rec.sva_attribute16
 ,p_sva_attribute17_o             =>ben_sva_shd.g_old_rec.sva_attribute17
 ,p_sva_attribute18_o             =>ben_sva_shd.g_old_rec.sva_attribute18
 ,p_sva_attribute19_o             =>ben_sva_shd.g_old_rec.sva_attribute19
 ,p_sva_attribute20_o             =>ben_sva_shd.g_old_rec.sva_attribute20
 ,p_sva_attribute21_o             =>ben_sva_shd.g_old_rec.sva_attribute21
 ,p_sva_attribute22_o             =>ben_sva_shd.g_old_rec.sva_attribute22
 ,p_sva_attribute23_o             =>ben_sva_shd.g_old_rec.sva_attribute23
 ,p_sva_attribute24_o             =>ben_sva_shd.g_old_rec.sva_attribute24
 ,p_sva_attribute25_o             =>ben_sva_shd.g_old_rec.sva_attribute25
 ,p_sva_attribute26_o             =>ben_sva_shd.g_old_rec.sva_attribute26
 ,p_sva_attribute27_o             =>ben_sva_shd.g_old_rec.sva_attribute27
 ,p_sva_attribute28_o             =>ben_sva_shd.g_old_rec.sva_attribute28
 ,p_sva_attribute29_o             =>ben_sva_shd.g_old_rec.sva_attribute29
 ,p_sva_attribute30_o             =>ben_sva_shd.g_old_rec.sva_attribute30
 ,p_object_version_number_o       =>ben_sva_shd.g_old_rec.object_version_number
      );
Line: 362

End post_delete;
Line: 397

  ben_sva_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);
Line: 406

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

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

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