APPS.GHR_DUT_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 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
--
-- Cursor to select 'old' created AOL who column values
--
  Cursor C_Sel1 Is
    select t.created_by,
           t.creation_date
    from   ghr_duty_stations_f t
    where  t.duty_station_id       = p_rec.duty_station_id
    and    t.effective_start_date =
             ghr_dut_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   	ghr_duty_stations_f.last_update_date%TYPE;

Line: 79

  l_last_updated_by     ghr_duty_stations_f.last_updated_by%TYPE;

Line: 80

  l_last_update_login   ghr_duty_stations_f.last_update_login%TYPE;

Line: 103

  If (p_datetrack_mode <> 'INSERT') then
    hr_utility.set_location(l_proc, 10);

Line: 125

    l_last_update_date   := sysdate;

Line: 126

    l_last_updated_by    := fnd_global.user_id;

Line: 127

    l_last_update_login  := fnd_global.login_id;

Line: 134

  insert into ghr_duty_stations_f
  (	duty_station_id,
	effective_start_date,
	effective_end_date,
	locality_pay_area_id,
        leo_pay_area_code,
        name,
        duty_station_code,
        msa_code  ,
        cmsa_code ,
        state_or_country_code,
        county_code,
        is_duty_station,
	object_version_number,
	created_by,
   	creation_date,
   	last_update_date,
   	last_updated_by,
   	last_update_login
  )
  Values
  (	p_rec.duty_station_id,
	p_rec.effective_start_date,
	p_rec.effective_end_date,
	p_rec.locality_pay_area_id,
        p_rec.leo_pay_area_code,
        p_rec.name,
        p_rec.duty_station_code,
        p_rec.msa_code  ,
        p_rec.cmsa_code ,
        p_rec.state_or_country_code,
        p_rec.county_code,
        p_rec.is_duty_station,
	p_rec.object_version_number,
	l_created_by,
   	l_creation_date,
   	l_last_update_date,
   	l_last_updated_by,
   	l_last_update_login
  );

Line: 192

End dt_insert_dml;

Line: 197

Procedure insert_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||'insert_dml';

Line: 209

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

End insert_dml;

Line: 257

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

Line: 268

      select ghr_duty_stations_f_s.nextval
      from dual;

Line: 280

End pre_insert;

Line: 314

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

Line: 326

  ghr_dut_rki.after_insert(
			    p_duty_station_id 	     =>   p_rec.duty_station_id
			   ,p_effective_start_date   =>   p_rec.effective_start_date
			   ,p_effective_end_date     =>   p_rec.effective_end_date
			   ,p_locality_pay_area_id   =>   p_rec.locality_pay_area_id
			   ,p_leo_pay_area_code      =>   p_rec.leo_pay_area_code
			   ,p_name                   =>   p_rec.name
			   ,p_duty_station_code      =>   p_rec.duty_station_code
			   ,p_msa_code		     =>	  p_rec.msa_code
			   ,p_cmsa_code              =>	  p_rec.cmsa_code
			   ,p_state_or_country_code  =>   p_rec.state_or_country_code
			   ,p_county_code	     =>	  p_rec.county_code
			   ,p_is_duty_station	     =>   p_rec.is_duty_station
			   ,p_effective_date         =>   trunc(p_effective_date)
			   ,p_object_version_number  =>   p_rec.object_version_number
			   );

Line: 343

End post_insert;

Line: 427

  l_datetrack_mode		varchar2(30) := 'INSERT';

Line: 445

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

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

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

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