APPS.BEN_CRT_INS SQL Statements

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

Line: 53

Procedure insert_dml(p_rec in out nocopy ben_crt_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';

Line: 65

  insert into ben_crt_ordr
  (	crt_ordr_id,
	crt_ordr_typ_cd,
	apls_perd_endg_dt,
	apls_perd_strtg_dt,
	crt_ident,
	description,
	detd_qlfd_ordr_dt,
	issue_dt,
	qdro_amt,
	qdro_dstr_mthd_cd,
	qdro_pct,
	rcvd_dt,
	uom,
	crt_issng,
	pl_id,
	person_id,
	business_group_id,
	crt_attribute_category,
	crt_attribute1,
	crt_attribute2,
	crt_attribute3,
	crt_attribute4,
	crt_attribute5,
	crt_attribute6,
	crt_attribute7,
	crt_attribute8,
	crt_attribute9,
	crt_attribute10,
	crt_attribute11,
	crt_attribute12,
	crt_attribute13,
	crt_attribute14,
	crt_attribute15,
	crt_attribute16,
	crt_attribute17,
	crt_attribute18,
	crt_attribute19,
	crt_attribute20,
	crt_attribute21,
	crt_attribute22,
	crt_attribute23,
	crt_attribute24,
	crt_attribute25,
	crt_attribute26,
	crt_attribute27,
	crt_attribute28,
	crt_attribute29,
	crt_attribute30,
	object_version_number,
	qdro_num_pymt_val,
	qdro_per_perd_cd,
	pl_typ_id
  )
  Values
  (	p_rec.crt_ordr_id,
	p_rec.crt_ordr_typ_cd,
	p_rec.apls_perd_endg_dt,
	p_rec.apls_perd_strtg_dt,
	p_rec.crt_ident,
	p_rec.description,
	p_rec.detd_qlfd_ordr_dt,
	p_rec.issue_dt,
	p_rec.qdro_amt,
	p_rec.qdro_dstr_mthd_cd,
	p_rec.qdro_pct,
	p_rec.rcvd_dt,
	p_rec.uom,
	p_rec.crt_issng,
	p_rec.pl_id,
	p_rec.person_id,
	p_rec.business_group_id,
	p_rec.crt_attribute_category,
	p_rec.crt_attribute1,
	p_rec.crt_attribute2,
	p_rec.crt_attribute3,
	p_rec.crt_attribute4,
	p_rec.crt_attribute5,
	p_rec.crt_attribute6,
	p_rec.crt_attribute7,
	p_rec.crt_attribute8,
	p_rec.crt_attribute9,
	p_rec.crt_attribute10,
	p_rec.crt_attribute11,
	p_rec.crt_attribute12,
	p_rec.crt_attribute13,
	p_rec.crt_attribute14,
	p_rec.crt_attribute15,
	p_rec.crt_attribute16,
	p_rec.crt_attribute17,
	p_rec.crt_attribute18,
	p_rec.crt_attribute19,
	p_rec.crt_attribute20,
	p_rec.crt_attribute21,
	p_rec.crt_attribute22,
	p_rec.crt_attribute23,
	p_rec.crt_attribute24,
	p_rec.crt_attribute25,
	p_rec.crt_attribute26,
	p_rec.crt_attribute27,
	p_rec.crt_attribute28,
	p_rec.crt_attribute29,
	p_rec.crt_attribute30,
	p_rec.object_version_number,
	p_rec.qdro_num_pymt_val,
	p_rec.qdro_per_perd_cd,
	p_rec.pl_typ_id
  );

Line: 196

End insert_dml;

Line: 235

Procedure pre_insert(p_rec  in out nocopy ben_crt_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'pre_insert';

Line: 239

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

Line: 252

End pre_insert;

Line: 286

Procedure post_insert(
p_effective_date in date,p_rec in ben_crt_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_insert';

Line: 312

    ben_crt_rki.after_insert
      (
  p_crt_ordr_id                   =>p_rec.crt_ordr_id
 ,p_crt_ordr_typ_cd               =>p_rec.crt_ordr_typ_cd
 ,p_apls_perd_endg_dt             =>p_rec.apls_perd_endg_dt
 ,p_apls_perd_strtg_dt            =>p_rec.apls_perd_strtg_dt
 ,p_crt_ident                     =>p_rec.crt_ident
 ,p_description                   =>p_rec.description
 ,p_detd_qlfd_ordr_dt             =>p_rec.detd_qlfd_ordr_dt
 ,p_issue_dt                      =>p_rec.issue_dt
 ,p_qdro_amt                      =>p_rec.qdro_amt
 ,p_qdro_dstr_mthd_cd             =>p_rec.qdro_dstr_mthd_cd
 ,p_qdro_pct                      =>p_rec.qdro_pct
 ,p_rcvd_dt                       =>p_rec.rcvd_dt
 ,p_uom                           =>p_rec.uom
 ,p_crt_issng                     =>p_rec.crt_issng
 ,p_pl_id                         =>p_rec.pl_id
 ,p_person_id                     =>p_rec.person_id
 ,p_business_group_id             =>p_rec.business_group_id
 ,p_crt_attribute_category        =>p_rec.crt_attribute_category
 ,p_crt_attribute1                =>p_rec.crt_attribute1
 ,p_crt_attribute2                =>p_rec.crt_attribute2
 ,p_crt_attribute3                =>p_rec.crt_attribute3
 ,p_crt_attribute4                =>p_rec.crt_attribute4
 ,p_crt_attribute5                =>p_rec.crt_attribute5
 ,p_crt_attribute6                =>p_rec.crt_attribute6
 ,p_crt_attribute7                =>p_rec.crt_attribute7
 ,p_crt_attribute8                =>p_rec.crt_attribute8
 ,p_crt_attribute9                =>p_rec.crt_attribute9
 ,p_crt_attribute10               =>p_rec.crt_attribute10
 ,p_crt_attribute11               =>p_rec.crt_attribute11
 ,p_crt_attribute12               =>p_rec.crt_attribute12
 ,p_crt_attribute13               =>p_rec.crt_attribute13
 ,p_crt_attribute14               =>p_rec.crt_attribute14
 ,p_crt_attribute15               =>p_rec.crt_attribute15
 ,p_crt_attribute16               =>p_rec.crt_attribute16
 ,p_crt_attribute17               =>p_rec.crt_attribute17
 ,p_crt_attribute18               =>p_rec.crt_attribute18
 ,p_crt_attribute19               =>p_rec.crt_attribute19
 ,p_crt_attribute20               =>p_rec.crt_attribute20
 ,p_crt_attribute21               =>p_rec.crt_attribute21
 ,p_crt_attribute22               =>p_rec.crt_attribute22
 ,p_crt_attribute23               =>p_rec.crt_attribute23
 ,p_crt_attribute24               =>p_rec.crt_attribute24
 ,p_crt_attribute25               =>p_rec.crt_attribute25
 ,p_crt_attribute26               =>p_rec.crt_attribute26
 ,p_crt_attribute27               =>p_rec.crt_attribute27
 ,p_crt_attribute28               =>p_rec.crt_attribute28
 ,p_crt_attribute29               =>p_rec.crt_attribute29
 ,p_crt_attribute30               =>p_rec.crt_attribute30
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_qdro_num_pymt_val             =>p_rec.qdro_num_pymt_val
 ,p_qdro_per_perd_cd              =>p_rec.qdro_per_perd_cd
 ,p_pl_typ_id                     =>p_rec.pl_typ_id
 ,p_effective_date                =>p_effective_date
      );

Line: 391

End post_insert;

Line: 408

  ben_crt_bus.insert_validate(p_rec => p_rec
  ,p_effective_date => p_effective_date);

Line: 413

  pre_insert(p_rec);

Line: 417

  insert_dml(p_rec);

Line: 421

  post_insert(p_rec =>  p_rec,p_effective_Date => p_effective_date);