APPS.GHR_DUT_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 ghr_dut_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

        hr_utility.set_location('dt_delete_dml NAR IF ',10);

Line: 72

    delete from ghr_duty_stations_f
    where       duty_station_id = p_rec.duty_station_id
    and	  effective_start_date = p_validation_start_date;

Line: 84

    hr_utility.set_location('dt_delete_dml NAR ELSE ',15);

Line: 85

    delete from ghr_duty_stations_f
    where        duty_station_id = p_rec.duty_station_id
    and	  effective_start_date >= p_validation_start_date;

Line: 98

End dt_delete_dml;

Line: 103

Procedure delete_dml
	(p_rec 			 in out nocopy ghr_dut_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: 115

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

End delete_dml;

Line: 157

Procedure dt_pre_delete
	(p_rec 			 in out nocopy ghr_dut_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: 173

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

Line: 193

End dt_pre_delete;

Line: 228

Procedure pre_delete
	(p_rec 			 in out nocopy ghr_dut_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: 244

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

End pre_delete;

Line: 286

Procedure post_delete
	(p_rec 			 in ghr_dut_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: 298

  ghr_dut_rkd.after_delete(
 		            p_duty_station_id         => p_rec.duty_station_id
                           ,p_object_version_number   => p_rec. object_version_number
			   );

Line: 303

End post_delete;

Line: 338

	  ghr_dut_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: 348

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

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

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