APPS.PAY_GRR_UPD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 57

Procedure dt_update_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||'dt_update_dml';

Line: 87

    update  pay_grade_rules_f
    set
    grade_rule_id                   = p_rec.grade_rule_id,
    maximum                         = p_rec.maximum,
    mid_value                       = p_rec.mid_value,
    minimum                         = p_rec.minimum,
    value                           = p_rec.value,
    request_id                      = p_rec.request_id,
    program_application_id          = p_rec.program_application_id,
    program_id                      = p_rec.program_id,
    program_update_date             = p_rec.program_update_date,
    object_version_number           = p_rec.object_version_number,
    currency_code                   = p_rec.currency_code
    where   grade_rule_id = p_rec.grade_rule_id
    and     effective_start_date = p_validation_start_date
    and     effective_end_date   = p_validation_end_date;

Line: 129

End dt_update_dml;

Line: 162

Procedure update_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||'update_dml';

Line: 174

  dt_update_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: 181

End update_dml;

Line: 226

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

Line: 251

    If (p_datetrack_mode = 'UPDATE_OVERRIDE') then
      hr_utility.set_location(l_proc, 15);

Line: 257

      pay_grr_del.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: 268

    pay_grr_ins.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: 276

End dt_pre_update;

Line: 311

Procedure pre_update
	(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_update';

Line: 323

  dt_pre_update
    (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: 331

End pre_update;

Line: 365

Procedure post_update
	(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_update';

Line: 378

End post_update;

Line: 484

  If (p_rec.program_update_date = hr_api.g_date) then
    p_rec.program_update_date :=
    pay_grr_shd.g_old_rec.program_update_date;

Line: 546

  pay_grr_bus.update_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: 555

  pre_update
	(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: 564

  update_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: 573

  post_update
	(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: 611

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

Line: 646

  p_program_update_date,
  p_object_version_number,
  p_currency_code
  );