APPS.PAY_GRR_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 pay_grr_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   pay_grade_rules_f t
    where  t.grade_rule_id       = p_rec.grade_rule_id
    and    t.effective_start_date =
             pay_grr_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   	pay_grade_rules_f.last_update_date%TYPE;

Line: 79

  l_last_updated_by     pay_grade_rules_f.last_updated_by%TYPE;

Line: 80

  l_last_update_login   pay_grade_rules_f.last_update_login%TYPE;

Line: 102

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

Line: 124

    l_last_update_date   := sysdate;

Line: 125

    l_last_updated_by    := fnd_global.user_id;

Line: 126

    l_last_update_login  := fnd_global.login_id;

Line: 133

  insert into pay_grade_rules_f
  (	grade_rule_id,
	effective_start_date,
	effective_end_date,
	business_group_id,
	rate_id,
	grade_or_spinal_point_id,
	rate_type,
	maximum,
	mid_value,
	minimum,
	sequence,
	value,
	request_id,
	program_application_id,
	program_id,
	program_update_date,
	object_version_number,
        currency_code,
   	created_by,
   	creation_date,
   	last_update_date,
   	last_updated_by,
   	last_update_login
  )
  Values
  (	p_rec.grade_rule_id,
	p_rec.effective_start_date,
	p_rec.effective_end_date,
	p_rec.business_group_id,
	p_rec.rate_id,
	p_rec.grade_or_spinal_point_id,
	p_rec.rate_type,
	p_rec.maximum,
	p_rec.mid_value,
	p_rec.minimum,
	p_rec.sequence,
	p_rec.value,
	p_rec.request_id,
	p_rec.program_application_id,
	p_rec.program_id,
	p_rec.program_update_date,
	p_rec.object_version_number,
        p_rec.currency_code,
	l_created_by,
   	l_creation_date,
   	l_last_update_date,
   	l_last_updated_by,
   	l_last_update_login
  );

Line: 201

End dt_insert_dml;

Line: 206

Procedure insert_dml
	(p_rec 			 in out nocopy pay_grr_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: 218

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

End insert_dml;

Line: 266

Procedure pre_insert
	(p_rec  			in out nocopy pay_grr_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: 275

  Cursor C_Sel1 is select pay_grade_rules_s.nextval from sys.dual;

Line: 289

End pre_insert;

Line: 323

Procedure post_insert
	(p_rec 			 in pay_grr_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: 336

End post_insert;

Line: 422

  l_datetrack_mode		varchar2(30) := 'INSERT';

Line: 449

  pay_grr_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: 458

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

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

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

Line: 519

  p_program_update_date          in date             default null,
  p_object_version_number        out nocopy number,
  p_effective_date		 in date,
  p_validate			 in boolean   default false,
  p_currency_code                in varchar2  default null
  ) is
--
  l_rec		pay_grr_shd.g_rec_type;

Line: 553

  p_program_update_date,
  null,
  p_currency_code
  );