DBA Data[Home] [Help]

APPS.BEN_ENO_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 ben_eno_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   ben_elig_no_othr_cvg_prte_f t
    where  t.elig_no_othr_cvg_prte_id       = p_rec.elig_no_othr_cvg_prte_id
    and    t.effective_start_date =
             ben_eno_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   	ben_elig_no_othr_cvg_prte_f.last_update_date%TYPE;
Line: 79

  l_last_updated_by     ben_elig_no_othr_cvg_prte_f.last_updated_by%TYPE;
Line: 80

  l_last_update_login   ben_elig_no_othr_cvg_prte_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 ben_elig_no_othr_cvg_prte_f
  (	elig_no_othr_cvg_prte_id,
	effective_start_date,
	effective_end_date,
	coord_ben_no_cvg_flag,
	eligy_prfl_id,
	business_group_id,
	eno_attribute_category,
	eno_attribute1,
	eno_attribute2,
	eno_attribute3,
	eno_attribute4,
	eno_attribute5,
	eno_attribute6,
	eno_attribute7,
	eno_attribute8,
	eno_attribute9,
	eno_attribute10,
	eno_attribute11,
	eno_attribute12,
	eno_attribute13,
	eno_attribute14,
	eno_attribute15,
	eno_attribute16,
	eno_attribute17,
	eno_attribute18,
	eno_attribute19,
	eno_attribute20,
	eno_attribute21,
	eno_attribute22,
	eno_attribute23,
	eno_attribute24,
	eno_attribute25,
	eno_attribute26,
	eno_attribute27,
	eno_attribute28,
	eno_attribute29,
	eno_attribute30,
	object_version_number
   	, created_by,
   	creation_date,
   	last_update_date,
   	last_updated_by,
   	last_update_login
  )
  Values
  (	p_rec.elig_no_othr_cvg_prte_id,
	p_rec.effective_start_date,
	p_rec.effective_end_date,
	p_rec.coord_ben_no_cvg_flag,
	p_rec.eligy_prfl_id,
	p_rec.business_group_id,
	p_rec.eno_attribute_category,
	p_rec.eno_attribute1,
	p_rec.eno_attribute2,
	p_rec.eno_attribute3,
	p_rec.eno_attribute4,
	p_rec.eno_attribute5,
	p_rec.eno_attribute6,
	p_rec.eno_attribute7,
	p_rec.eno_attribute8,
	p_rec.eno_attribute9,
	p_rec.eno_attribute10,
	p_rec.eno_attribute11,
	p_rec.eno_attribute12,
	p_rec.eno_attribute13,
	p_rec.eno_attribute14,
	p_rec.eno_attribute15,
	p_rec.eno_attribute16,
	p_rec.eno_attribute17,
	p_rec.eno_attribute18,
	p_rec.eno_attribute19,
	p_rec.eno_attribute20,
	p_rec.eno_attribute21,
	p_rec.eno_attribute22,
	p_rec.eno_attribute23,
	p_rec.eno_attribute24,
	p_rec.eno_attribute25,
	p_rec.eno_attribute26,
	p_rec.eno_attribute27,
	p_rec.eno_attribute28,
	p_rec.eno_attribute29,
	p_rec.eno_attribute30,
	p_rec.object_version_number
	, l_created_by,
   	l_creation_date,
   	l_last_update_date,
   	l_last_updated_by,
   	l_last_update_login
  );
Line: 241

End dt_insert_dml;
Line: 246

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

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

End insert_dml;
Line: 306

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

  select ben_elig_no_othr_cvg_prte_f_s.nextval
    into p_rec.elig_no_othr_cvg_prte_id from sys.dual;
Line: 326

End pre_insert;
Line: 360

Procedure post_insert
	(p_rec 			 in ben_eno_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: 377

    ben_eno_rki.after_insert
      (
  p_elig_no_othr_cvg_prte_id      =>p_rec.elig_no_othr_cvg_prte_id
 ,p_effective_start_date          =>p_rec.effective_start_date
 ,p_effective_end_date            =>p_rec.effective_end_date
 ,p_coord_ben_no_cvg_flag         =>p_rec.coord_ben_no_cvg_flag
 ,p_eligy_prfl_id                 =>p_rec.eligy_prfl_id
 ,p_business_group_id             =>p_rec.business_group_id
 ,p_eno_attribute_category        =>p_rec.eno_attribute_category
 ,p_eno_attribute1                =>p_rec.eno_attribute1
 ,p_eno_attribute2                =>p_rec.eno_attribute2
 ,p_eno_attribute3                =>p_rec.eno_attribute3
 ,p_eno_attribute4                =>p_rec.eno_attribute4
 ,p_eno_attribute5                =>p_rec.eno_attribute5
 ,p_eno_attribute6                =>p_rec.eno_attribute6
 ,p_eno_attribute7                =>p_rec.eno_attribute7
 ,p_eno_attribute8                =>p_rec.eno_attribute8
 ,p_eno_attribute9                =>p_rec.eno_attribute9
 ,p_eno_attribute10               =>p_rec.eno_attribute10
 ,p_eno_attribute11               =>p_rec.eno_attribute11
 ,p_eno_attribute12               =>p_rec.eno_attribute12
 ,p_eno_attribute13               =>p_rec.eno_attribute13
 ,p_eno_attribute14               =>p_rec.eno_attribute14
 ,p_eno_attribute15               =>p_rec.eno_attribute15
 ,p_eno_attribute16               =>p_rec.eno_attribute16
 ,p_eno_attribute17               =>p_rec.eno_attribute17
 ,p_eno_attribute18               =>p_rec.eno_attribute18
 ,p_eno_attribute19               =>p_rec.eno_attribute19
 ,p_eno_attribute20               =>p_rec.eno_attribute20
 ,p_eno_attribute21               =>p_rec.eno_attribute21
 ,p_eno_attribute22               =>p_rec.eno_attribute22
 ,p_eno_attribute23               =>p_rec.eno_attribute23
 ,p_eno_attribute24               =>p_rec.eno_attribute24
 ,p_eno_attribute25               =>p_rec.eno_attribute25
 ,p_eno_attribute26               =>p_rec.eno_attribute26
 ,p_eno_attribute27               =>p_rec.eno_attribute27
 ,p_eno_attribute28               =>p_rec.eno_attribute28
 ,p_eno_attribute29               =>p_rec.eno_attribute29
 ,p_eno_attribute30               =>p_rec.eno_attribute30
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_effective_date                =>p_effective_date
 ,p_validation_start_date         =>p_validation_start_date
 ,p_validation_end_date           =>p_validation_end_date
      );
Line: 436

End post_insert;
Line: 524

  l_datetrack_mode		varchar2(30) := 'INSERT';
Line: 542

  ben_eno_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: 551

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

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

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