DBA Data[Home] [Help]

APPS.BEN_CTU_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_ctu_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_cm_typ_usg_f
    set
        cm_typ_usg_id                   = p_rec.cm_typ_usg_id,
    all_r_any_cd                    = p_rec.all_r_any_cd,
    cm_usg_rl                       = p_rec.cm_usg_rl,
    descr_text                      = p_rec.descr_text,
    pgm_id                          = p_rec.pgm_id,
    pl_id                           = p_rec.pl_id,
    pl_typ_id                       = p_rec.pl_typ_id,
    enrt_perd_id                    = p_rec.enrt_perd_id,
    actn_typ_id                     = p_rec.actn_typ_id,
    cm_typ_id                       = p_rec.cm_typ_id,
    ler_id                          = p_rec.ler_id,
    business_group_id               = p_rec.business_group_id,
    ctu_attribute_category          = p_rec.ctu_attribute_category,
    ctu_attribute1                  = p_rec.ctu_attribute1,
    ctu_attribute2                  = p_rec.ctu_attribute2,
    ctu_attribute3                  = p_rec.ctu_attribute3,
    ctu_attribute4                  = p_rec.ctu_attribute4,
    ctu_attribute5                  = p_rec.ctu_attribute5,
    ctu_attribute6                  = p_rec.ctu_attribute6,
    ctu_attribute7                  = p_rec.ctu_attribute7,
    ctu_attribute8                  = p_rec.ctu_attribute8,
    ctu_attribute9                  = p_rec.ctu_attribute9,
    ctu_attribute10                 = p_rec.ctu_attribute10,
    ctu_attribute11                 = p_rec.ctu_attribute11,
    ctu_attribute12                 = p_rec.ctu_attribute12,
    ctu_attribute13                 = p_rec.ctu_attribute13,
    ctu_attribute14                 = p_rec.ctu_attribute14,
    ctu_attribute15                 = p_rec.ctu_attribute15,
    ctu_attribute16                 = p_rec.ctu_attribute16,
    ctu_attribute17                 = p_rec.ctu_attribute17,
    ctu_attribute18                 = p_rec.ctu_attribute18,
    ctu_attribute19                 = p_rec.ctu_attribute19,
    ctu_attribute20                 = p_rec.ctu_attribute20,
    ctu_attribute21                 = p_rec.ctu_attribute21,
    ctu_attribute22                 = p_rec.ctu_attribute22,
    ctu_attribute23                 = p_rec.ctu_attribute23,
    ctu_attribute24                 = p_rec.ctu_attribute24,
    ctu_attribute25                 = p_rec.ctu_attribute25,
    ctu_attribute26                 = p_rec.ctu_attribute26,
    ctu_attribute27                 = p_rec.ctu_attribute27,
    ctu_attribute28                 = p_rec.ctu_attribute28,
    ctu_attribute29                 = p_rec.ctu_attribute29,
    ctu_attribute30                 = p_rec.ctu_attribute30,
    object_version_number           = p_rec.object_version_number
    where   cm_typ_usg_id = p_rec.cm_typ_usg_id
    and     effective_start_date = p_validation_start_date
    and     effective_end_date   = p_validation_end_date;
Line: 158

End dt_update_dml;
Line: 191

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

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

End update_dml;
Line: 255

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

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

      ben_ctu_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: 297

    ben_ctu_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: 305

End dt_pre_update;
Line: 340

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

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

End pre_update;
Line: 396

Procedure post_update
	(p_rec 			 in ben_ctu_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: 413

    ben_ctu_rku.after_update
      (p_cm_typ_usg_id                 =>p_rec.cm_typ_usg_id
      ,p_effective_start_date          =>p_rec.effective_start_date
      ,p_effective_end_date            =>p_rec.effective_end_date
      ,p_all_r_any_cd                  =>p_rec.all_r_any_cd
      ,p_cm_usg_rl                     =>p_rec.cm_usg_rl
      ,p_descr_text                    =>p_rec.descr_text
      ,p_pgm_id                        =>p_rec.pgm_id
      ,p_pl_id                         =>p_rec.pl_id
      ,p_pl_typ_id                     =>p_rec.pl_typ_id
      ,p_enrt_perd_id                  =>p_rec.enrt_perd_id
      ,p_actn_typ_id                   =>p_rec.actn_typ_id
      ,p_cm_typ_id                     =>p_rec.cm_typ_id
      ,p_ler_id                        =>p_rec.ler_id
      ,p_business_group_id             =>p_rec.business_group_id
      ,p_ctu_attribute_category        =>p_rec.ctu_attribute_category
      ,p_ctu_attribute1                =>p_rec.ctu_attribute1
      ,p_ctu_attribute2                =>p_rec.ctu_attribute2
      ,p_ctu_attribute3                =>p_rec.ctu_attribute3
      ,p_ctu_attribute4                =>p_rec.ctu_attribute4
      ,p_ctu_attribute5                =>p_rec.ctu_attribute5
      ,p_ctu_attribute6                =>p_rec.ctu_attribute6
      ,p_ctu_attribute7                =>p_rec.ctu_attribute7
      ,p_ctu_attribute8                =>p_rec.ctu_attribute8
      ,p_ctu_attribute9                =>p_rec.ctu_attribute9
      ,p_ctu_attribute10               =>p_rec.ctu_attribute10
      ,p_ctu_attribute11               =>p_rec.ctu_attribute11
      ,p_ctu_attribute12               =>p_rec.ctu_attribute12
      ,p_ctu_attribute13               =>p_rec.ctu_attribute13
      ,p_ctu_attribute14               =>p_rec.ctu_attribute14
      ,p_ctu_attribute15               =>p_rec.ctu_attribute15
      ,p_ctu_attribute16               =>p_rec.ctu_attribute16
      ,p_ctu_attribute17               =>p_rec.ctu_attribute17
      ,p_ctu_attribute18               =>p_rec.ctu_attribute18
      ,p_ctu_attribute19               =>p_rec.ctu_attribute19
      ,p_ctu_attribute20               =>p_rec.ctu_attribute20
      ,p_ctu_attribute21               =>p_rec.ctu_attribute21
      ,p_ctu_attribute22               =>p_rec.ctu_attribute22
      ,p_ctu_attribute23               =>p_rec.ctu_attribute23
      ,p_ctu_attribute24               =>p_rec.ctu_attribute24
      ,p_ctu_attribute25               =>p_rec.ctu_attribute25
      ,p_ctu_attribute26               =>p_rec.ctu_attribute26
      ,p_ctu_attribute27               =>p_rec.ctu_attribute27
      ,p_ctu_attribute28               =>p_rec.ctu_attribute28
      ,p_ctu_attribute29               =>p_rec.ctu_attribute29
      ,p_ctu_attribute30               =>p_rec.ctu_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_ctu_shd.g_old_rec.effective_start_date
      ,p_effective_end_date_o          =>ben_ctu_shd.g_old_rec.effective_end_date
      ,p_all_r_any_cd_o                =>ben_ctu_shd.g_old_rec.all_r_any_cd
      ,p_cm_usg_rl_o                   =>ben_ctu_shd.g_old_rec.cm_usg_rl
      ,p_descr_text_o                  =>ben_ctu_shd.g_old_rec.descr_text
      ,p_pgm_id_o                      =>ben_ctu_shd.g_old_rec.pgm_id
      ,p_pl_id_o                       =>ben_ctu_shd.g_old_rec.pl_id
      ,p_pl_typ_id_o                   =>ben_ctu_shd.g_old_rec.pl_typ_id
      ,p_enrt_perd_id_o                =>ben_ctu_shd.g_old_rec.enrt_perd_id
      ,p_actn_typ_id_o                 =>ben_ctu_shd.g_old_rec.actn_typ_id
      ,p_cm_typ_id_o                   =>ben_ctu_shd.g_old_rec.cm_typ_id
      ,p_ler_id_o                      =>ben_ctu_shd.g_old_rec.ler_id
      ,p_business_group_id_o           =>ben_ctu_shd.g_old_rec.business_group_id
      ,p_ctu_attribute_category_o      =>ben_ctu_shd.g_old_rec.ctu_attribute_category
      ,p_ctu_attribute1_o              =>ben_ctu_shd.g_old_rec.ctu_attribute1
      ,p_ctu_attribute2_o              =>ben_ctu_shd.g_old_rec.ctu_attribute2
      ,p_ctu_attribute3_o              =>ben_ctu_shd.g_old_rec.ctu_attribute3
      ,p_ctu_attribute4_o              =>ben_ctu_shd.g_old_rec.ctu_attribute4
      ,p_ctu_attribute5_o              =>ben_ctu_shd.g_old_rec.ctu_attribute5
      ,p_ctu_attribute6_o              =>ben_ctu_shd.g_old_rec.ctu_attribute6
      ,p_ctu_attribute7_o              =>ben_ctu_shd.g_old_rec.ctu_attribute7
      ,p_ctu_attribute8_o              =>ben_ctu_shd.g_old_rec.ctu_attribute8
      ,p_ctu_attribute9_o              =>ben_ctu_shd.g_old_rec.ctu_attribute9
      ,p_ctu_attribute10_o             =>ben_ctu_shd.g_old_rec.ctu_attribute10
      ,p_ctu_attribute11_o             =>ben_ctu_shd.g_old_rec.ctu_attribute11
      ,p_ctu_attribute12_o             =>ben_ctu_shd.g_old_rec.ctu_attribute12
      ,p_ctu_attribute13_o             =>ben_ctu_shd.g_old_rec.ctu_attribute13
      ,p_ctu_attribute14_o             =>ben_ctu_shd.g_old_rec.ctu_attribute14
      ,p_ctu_attribute15_o             =>ben_ctu_shd.g_old_rec.ctu_attribute15
      ,p_ctu_attribute16_o             =>ben_ctu_shd.g_old_rec.ctu_attribute16
      ,p_ctu_attribute17_o             =>ben_ctu_shd.g_old_rec.ctu_attribute17
      ,p_ctu_attribute18_o             =>ben_ctu_shd.g_old_rec.ctu_attribute18
      ,p_ctu_attribute19_o             =>ben_ctu_shd.g_old_rec.ctu_attribute19
      ,p_ctu_attribute20_o             =>ben_ctu_shd.g_old_rec.ctu_attribute20
      ,p_ctu_attribute21_o             =>ben_ctu_shd.g_old_rec.ctu_attribute21
      ,p_ctu_attribute22_o             =>ben_ctu_shd.g_old_rec.ctu_attribute22
      ,p_ctu_attribute23_o             =>ben_ctu_shd.g_old_rec.ctu_attribute23
      ,p_ctu_attribute24_o             =>ben_ctu_shd.g_old_rec.ctu_attribute24
      ,p_ctu_attribute25_o             =>ben_ctu_shd.g_old_rec.ctu_attribute25
      ,p_ctu_attribute26_o             =>ben_ctu_shd.g_old_rec.ctu_attribute26
      ,p_ctu_attribute27_o             =>ben_ctu_shd.g_old_rec.ctu_attribute27
      ,p_ctu_attribute28_o             =>ben_ctu_shd.g_old_rec.ctu_attribute28
      ,p_ctu_attribute29_o             =>ben_ctu_shd.g_old_rec.ctu_attribute29
      ,p_ctu_attribute30_o             =>ben_ctu_shd.g_old_rec.ctu_attribute30
      ,p_object_version_number_o       =>ben_ctu_shd.g_old_rec.object_version_number);
Line: 524

End post_update;
Line: 794

  ben_ctu_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: 803

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

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

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