APPS.BEN_CPY_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_cpy_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';

Line: 65

  insert into ben_popl_yr_perd
  (	popl_yr_perd_id,
	yr_perd_id,
	business_group_id,
	pl_id,
	pgm_id,
	ordr_num,
	acpt_clm_rqsts_thru_dt,
	py_clms_thru_dt,
	cpy_attribute_category,
	cpy_attribute1,
	cpy_attribute2,
	cpy_attribute3,
	cpy_attribute4,
	cpy_attribute5,
	cpy_attribute6,
	cpy_attribute7,
	cpy_attribute8,
	cpy_attribute9,
	cpy_attribute10,
	cpy_attribute11,
	cpy_attribute12,
	cpy_attribute13,
	cpy_attribute14,
	cpy_attribute15,
	cpy_attribute16,
	cpy_attribute17,
	cpy_attribute18,
	cpy_attribute19,
	cpy_attribute20,
	cpy_attribute21,
	cpy_attribute22,
	cpy_attribute23,
	cpy_attribute24,
	cpy_attribute25,
	cpy_attribute26,
	cpy_attribute27,
	cpy_attribute28,
	cpy_attribute29,
	cpy_attribute30,
	object_version_number
  )
  Values
  (	p_rec.popl_yr_perd_id,
	p_rec.yr_perd_id,
	p_rec.business_group_id,
	p_rec.pl_id,
	p_rec.pgm_id,
	p_rec.ordr_num,
	p_rec.acpt_clm_rqsts_thru_dt,
	p_rec.py_clms_thru_dt,
	p_rec.cpy_attribute_category,
	p_rec.cpy_attribute1,
	p_rec.cpy_attribute2,
	p_rec.cpy_attribute3,
	p_rec.cpy_attribute4,
	p_rec.cpy_attribute5,
	p_rec.cpy_attribute6,
	p_rec.cpy_attribute7,
	p_rec.cpy_attribute8,
	p_rec.cpy_attribute9,
	p_rec.cpy_attribute10,
	p_rec.cpy_attribute11,
	p_rec.cpy_attribute12,
	p_rec.cpy_attribute13,
	p_rec.cpy_attribute14,
	p_rec.cpy_attribute15,
	p_rec.cpy_attribute16,
	p_rec.cpy_attribute17,
	p_rec.cpy_attribute18,
	p_rec.cpy_attribute19,
	p_rec.cpy_attribute20,
	p_rec.cpy_attribute21,
	p_rec.cpy_attribute22,
	p_rec.cpy_attribute23,
	p_rec.cpy_attribute24,
	p_rec.cpy_attribute25,
	p_rec.cpy_attribute26,
	p_rec.cpy_attribute27,
	p_rec.cpy_attribute28,
	p_rec.cpy_attribute29,
	p_rec.cpy_attribute30,
	p_rec.object_version_number
  );

Line: 172

End insert_dml;

Line: 211

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

Line: 215

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

Line: 228

End pre_insert;

Line: 262

Procedure post_insert(p_rec in ben_cpy_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_insert';

Line: 274

    ben_cpy_rki.after_insert
      (
       p_popl_yr_perd_id               =>p_rec.popl_yr_perd_id
      ,p_yr_perd_id                    =>p_rec.yr_perd_id
      ,p_business_group_id             =>p_rec.business_group_id
      ,p_pl_id                         =>p_rec.pl_id
      ,p_pgm_id                        =>p_rec.pgm_id
      ,p_ordr_num                      =>p_rec.ordr_num
      ,p_acpt_clm_rqsts_thru_dt        =>p_rec.acpt_clm_rqsts_thru_dt
      ,p_py_clms_thru_dt               =>p_rec.py_clms_thru_dt
      ,p_cpy_attribute_category        =>p_rec.cpy_attribute_category
      ,p_cpy_attribute1                =>p_rec.cpy_attribute1
      ,p_cpy_attribute2                =>p_rec.cpy_attribute2
      ,p_cpy_attribute3                =>p_rec.cpy_attribute3
      ,p_cpy_attribute4                =>p_rec.cpy_attribute4
      ,p_cpy_attribute5                =>p_rec.cpy_attribute5
      ,p_cpy_attribute6                =>p_rec.cpy_attribute6
      ,p_cpy_attribute7                =>p_rec.cpy_attribute7
      ,p_cpy_attribute8                =>p_rec.cpy_attribute8
      ,p_cpy_attribute9                =>p_rec.cpy_attribute9
      ,p_cpy_attribute10               =>p_rec.cpy_attribute10
      ,p_cpy_attribute11               =>p_rec.cpy_attribute11
      ,p_cpy_attribute12               =>p_rec.cpy_attribute12
      ,p_cpy_attribute13               =>p_rec.cpy_attribute13
      ,p_cpy_attribute14               =>p_rec.cpy_attribute14
      ,p_cpy_attribute15               =>p_rec.cpy_attribute15
      ,p_cpy_attribute16               =>p_rec.cpy_attribute16
      ,p_cpy_attribute17               =>p_rec.cpy_attribute17
      ,p_cpy_attribute18               =>p_rec.cpy_attribute18
      ,p_cpy_attribute19               =>p_rec.cpy_attribute19
      ,p_cpy_attribute20               =>p_rec.cpy_attribute20
      ,p_cpy_attribute21               =>p_rec.cpy_attribute21
      ,p_cpy_attribute22               =>p_rec.cpy_attribute22
      ,p_cpy_attribute23               =>p_rec.cpy_attribute23
      ,p_cpy_attribute24               =>p_rec.cpy_attribute24
      ,p_cpy_attribute25               =>p_rec.cpy_attribute25
      ,p_cpy_attribute26               =>p_rec.cpy_attribute26
      ,p_cpy_attribute27               =>p_rec.cpy_attribute27
      ,p_cpy_attribute28               =>p_rec.cpy_attribute28
      ,p_cpy_attribute29               =>p_rec.cpy_attribute29
      ,p_cpy_attribute30               =>p_rec.cpy_attribute30
      ,p_object_version_number         =>p_rec.object_version_number
      );

Line: 332

End post_insert;

Line: 349

  ben_cpy_bus.insert_validate(p_rec);

Line: 353

  pre_insert(p_rec);

Line: 357

  insert_dml(p_rec);

Line: 361

  post_insert(p_rec);