DBA Data[Home] [Help]

APPS.BEN_PBR_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 ben_pbr_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: 85

    update  ben_py_bss_rt_f
    set
        py_bss_rt_id                    = p_rec.py_bss_rt_id,
    vrbl_rt_prfl_id                 = p_rec.vrbl_rt_prfl_id,
    pay_basis_id                    = p_rec.pay_basis_id,
    excld_flag                      = p_rec.excld_flag,
    ordr_num                        = p_rec.ordr_num,
    business_group_id               = p_rec.business_group_id,
    pbr_attribute_category          = p_rec.pbr_attribute_category,
    pbr_attribute1                  = p_rec.pbr_attribute1,
    pbr_attribute2                  = p_rec.pbr_attribute2,
    pbr_attribute3                  = p_rec.pbr_attribute3,
    pbr_attribute4                  = p_rec.pbr_attribute4,
    pbr_attribute5                  = p_rec.pbr_attribute5,
    pbr_attribute6                  = p_rec.pbr_attribute6,
    pbr_attribute7                  = p_rec.pbr_attribute7,
    pbr_attribute8                  = p_rec.pbr_attribute8,
    pbr_attribute9                  = p_rec.pbr_attribute9,
    pbr_attribute10                 = p_rec.pbr_attribute10,
    pbr_attribute11                 = p_rec.pbr_attribute11,
    pbr_attribute12                 = p_rec.pbr_attribute12,
    pbr_attribute13                 = p_rec.pbr_attribute13,
    pbr_attribute14                 = p_rec.pbr_attribute14,
    pbr_attribute15                 = p_rec.pbr_attribute15,
    pbr_attribute16                 = p_rec.pbr_attribute16,
    pbr_attribute17                 = p_rec.pbr_attribute17,
    pbr_attribute18                 = p_rec.pbr_attribute18,
    pbr_attribute19                 = p_rec.pbr_attribute19,
    pbr_attribute20                 = p_rec.pbr_attribute20,
    pbr_attribute21                 = p_rec.pbr_attribute21,
    pbr_attribute22                 = p_rec.pbr_attribute22,
    pbr_attribute23                 = p_rec.pbr_attribute23,
    pbr_attribute24                 = p_rec.pbr_attribute24,
    pbr_attribute25                 = p_rec.pbr_attribute25,
    pbr_attribute26                 = p_rec.pbr_attribute26,
    pbr_attribute27                 = p_rec.pbr_attribute27,
    pbr_attribute28                 = p_rec.pbr_attribute28,
    pbr_attribute29                 = p_rec.pbr_attribute29,
    pbr_attribute30                 = p_rec.pbr_attribute30,
    object_version_number           = p_rec.object_version_number
    where   py_bss_rt_id = p_rec.py_bss_rt_id
    and     effective_start_date = p_validation_start_date
    and     effective_end_date   = p_validation_end_date;
Line: 152

End dt_update_dml;
Line: 185

Procedure update_dml
	(p_rec 			 in out nocopy ben_pbr_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: 197

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

End update_dml;
Line: 249

Procedure dt_pre_update
	(p_rec 			 in out nocopy ben_pbr_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: 274

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

      ben_pbr_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: 291

    ben_pbr_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: 299

End dt_pre_update;
Line: 334

Procedure pre_update
	(p_rec 			 in out nocopy ben_pbr_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: 348

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

End pre_update;
Line: 390

Procedure post_update
	(p_rec 			 in ben_pbr_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: 407

    ben_pbr_rku.after_update
      (
  p_py_bss_rt_id                  =>p_rec.py_bss_rt_id
 ,p_effective_start_date          =>p_rec.effective_start_date
 ,p_effective_end_date            =>p_rec.effective_end_date
 ,p_vrbl_rt_prfl_id               =>p_rec.vrbl_rt_prfl_id
 ,p_pay_basis_id                  =>p_rec.pay_basis_id
 ,p_excld_flag                    =>p_rec.excld_flag
 ,p_ordr_num                      =>p_rec.ordr_num
 ,p_business_group_id             =>p_rec.business_group_id
 ,p_pbr_attribute_category        =>p_rec.pbr_attribute_category
 ,p_pbr_attribute1                =>p_rec.pbr_attribute1
 ,p_pbr_attribute2                =>p_rec.pbr_attribute2
 ,p_pbr_attribute3                =>p_rec.pbr_attribute3
 ,p_pbr_attribute4                =>p_rec.pbr_attribute4
 ,p_pbr_attribute5                =>p_rec.pbr_attribute5
 ,p_pbr_attribute6                =>p_rec.pbr_attribute6
 ,p_pbr_attribute7                =>p_rec.pbr_attribute7
 ,p_pbr_attribute8                =>p_rec.pbr_attribute8
 ,p_pbr_attribute9                =>p_rec.pbr_attribute9
 ,p_pbr_attribute10               =>p_rec.pbr_attribute10
 ,p_pbr_attribute11               =>p_rec.pbr_attribute11
 ,p_pbr_attribute12               =>p_rec.pbr_attribute12
 ,p_pbr_attribute13               =>p_rec.pbr_attribute13
 ,p_pbr_attribute14               =>p_rec.pbr_attribute14
 ,p_pbr_attribute15               =>p_rec.pbr_attribute15
 ,p_pbr_attribute16               =>p_rec.pbr_attribute16
 ,p_pbr_attribute17               =>p_rec.pbr_attribute17
 ,p_pbr_attribute18               =>p_rec.pbr_attribute18
 ,p_pbr_attribute19               =>p_rec.pbr_attribute19
 ,p_pbr_attribute20               =>p_rec.pbr_attribute20
 ,p_pbr_attribute21               =>p_rec.pbr_attribute21
 ,p_pbr_attribute22               =>p_rec.pbr_attribute22
 ,p_pbr_attribute23               =>p_rec.pbr_attribute23
 ,p_pbr_attribute24               =>p_rec.pbr_attribute24
 ,p_pbr_attribute25               =>p_rec.pbr_attribute25
 ,p_pbr_attribute26               =>p_rec.pbr_attribute26
 ,p_pbr_attribute27               =>p_rec.pbr_attribute27
 ,p_pbr_attribute28               =>p_rec.pbr_attribute28
 ,p_pbr_attribute29               =>p_rec.pbr_attribute29
 ,p_pbr_attribute30               =>p_rec.pbr_attribute30
 ,p_object_version_number         =>p_rec.object_version_number
 ,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
 ,p_effective_start_date_o        =>ben_pbr_shd.g_old_rec.effective_start_date
 ,p_effective_end_date_o          =>ben_pbr_shd.g_old_rec.effective_end_date
 ,p_vrbl_rt_prfl_id_o             =>ben_pbr_shd.g_old_rec.vrbl_rt_prfl_id
 ,p_pay_basis_id_o                =>ben_pbr_shd.g_old_rec.pay_basis_id
 ,p_excld_flag_o                  =>ben_pbr_shd.g_old_rec.excld_flag
 ,p_ordr_num_o                    =>ben_pbr_shd.g_old_rec.ordr_num
 ,p_business_group_id_o           =>ben_pbr_shd.g_old_rec.business_group_id
 ,p_pbr_attribute_category_o      =>ben_pbr_shd.g_old_rec.pbr_attribute_category
 ,p_pbr_attribute1_o              =>ben_pbr_shd.g_old_rec.pbr_attribute1
 ,p_pbr_attribute2_o              =>ben_pbr_shd.g_old_rec.pbr_attribute2
 ,p_pbr_attribute3_o              =>ben_pbr_shd.g_old_rec.pbr_attribute3
 ,p_pbr_attribute4_o              =>ben_pbr_shd.g_old_rec.pbr_attribute4
 ,p_pbr_attribute5_o              =>ben_pbr_shd.g_old_rec.pbr_attribute5
 ,p_pbr_attribute6_o              =>ben_pbr_shd.g_old_rec.pbr_attribute6
 ,p_pbr_attribute7_o              =>ben_pbr_shd.g_old_rec.pbr_attribute7
 ,p_pbr_attribute8_o              =>ben_pbr_shd.g_old_rec.pbr_attribute8
 ,p_pbr_attribute9_o              =>ben_pbr_shd.g_old_rec.pbr_attribute9
 ,p_pbr_attribute10_o             =>ben_pbr_shd.g_old_rec.pbr_attribute10
 ,p_pbr_attribute11_o             =>ben_pbr_shd.g_old_rec.pbr_attribute11
 ,p_pbr_attribute12_o             =>ben_pbr_shd.g_old_rec.pbr_attribute12
 ,p_pbr_attribute13_o             =>ben_pbr_shd.g_old_rec.pbr_attribute13
 ,p_pbr_attribute14_o             =>ben_pbr_shd.g_old_rec.pbr_attribute14
 ,p_pbr_attribute15_o             =>ben_pbr_shd.g_old_rec.pbr_attribute15
 ,p_pbr_attribute16_o             =>ben_pbr_shd.g_old_rec.pbr_attribute16
 ,p_pbr_attribute17_o             =>ben_pbr_shd.g_old_rec.pbr_attribute17
 ,p_pbr_attribute18_o             =>ben_pbr_shd.g_old_rec.pbr_attribute18
 ,p_pbr_attribute19_o             =>ben_pbr_shd.g_old_rec.pbr_attribute19
 ,p_pbr_attribute20_o             =>ben_pbr_shd.g_old_rec.pbr_attribute20
 ,p_pbr_attribute21_o             =>ben_pbr_shd.g_old_rec.pbr_attribute21
 ,p_pbr_attribute22_o             =>ben_pbr_shd.g_old_rec.pbr_attribute22
 ,p_pbr_attribute23_o             =>ben_pbr_shd.g_old_rec.pbr_attribute23
 ,p_pbr_attribute24_o             =>ben_pbr_shd.g_old_rec.pbr_attribute24
 ,p_pbr_attribute25_o             =>ben_pbr_shd.g_old_rec.pbr_attribute25
 ,p_pbr_attribute26_o             =>ben_pbr_shd.g_old_rec.pbr_attribute26
 ,p_pbr_attribute27_o             =>ben_pbr_shd.g_old_rec.pbr_attribute27
 ,p_pbr_attribute28_o             =>ben_pbr_shd.g_old_rec.pbr_attribute28
 ,p_pbr_attribute29_o             =>ben_pbr_shd.g_old_rec.pbr_attribute29
 ,p_pbr_attribute30_o             =>ben_pbr_shd.g_old_rec.pbr_attribute30
 ,p_object_version_number_o       =>ben_pbr_shd.g_old_rec.object_version_number
      );
Line: 508

End post_update;
Line: 754

  ben_pbr_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: 763

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

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

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