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

Line: 56

  l_last_update_date   date := sysdate;

Line: 57

  l_last_updated_by    number := fnd_global.user_id;

Line: 58

  l_last_update_login  number := fnd_global.login_id;

Line: 69

  insert into ben_rptg_grp
  (	rptg_grp_id,
	name,
	business_group_id,
	rptg_prps_cd,
	rpg_desc,
	bnr_attribute_category,
	bnr_attribute1,
	bnr_attribute2,
	bnr_attribute3,
	bnr_attribute4,
	bnr_attribute5,
	bnr_attribute6,
	bnr_attribute7,
	bnr_attribute8,
	bnr_attribute9,
	bnr_attribute10,
	bnr_attribute11,
	bnr_attribute12,
	bnr_attribute13,
	bnr_attribute14,
	bnr_attribute15,
	bnr_attribute16,
	bnr_attribute17,
	bnr_attribute18,
	bnr_attribute19,
	bnr_attribute20,
	bnr_attribute21,
	bnr_attribute22,
	bnr_attribute23,
	bnr_attribute24,
	bnr_attribute25,
	bnr_attribute26,
	bnr_attribute27,
	bnr_attribute28,
	bnr_attribute29,
	bnr_attribute30,
        function_code,
        legislation_code,
	object_version_number,
	ordr_num                      --iRec
  )
  Values
  (	p_rec.rptg_grp_id,
	p_rec.name,
	p_rec.business_group_id,
	p_rec.rptg_prps_cd,
	p_rec.rpg_desc,
	p_rec.bnr_attribute_category,
	p_rec.bnr_attribute1,
	p_rec.bnr_attribute2,
	p_rec.bnr_attribute3,
	p_rec.bnr_attribute4,
	p_rec.bnr_attribute5,
	p_rec.bnr_attribute6,
	p_rec.bnr_attribute7,
	p_rec.bnr_attribute8,
	p_rec.bnr_attribute9,
	p_rec.bnr_attribute10,
	p_rec.bnr_attribute11,
	p_rec.bnr_attribute12,
	p_rec.bnr_attribute13,
	p_rec.bnr_attribute14,
	p_rec.bnr_attribute15,
	p_rec.bnr_attribute16,
	p_rec.bnr_attribute17,
	p_rec.bnr_attribute18,
	p_rec.bnr_attribute19,
	p_rec.bnr_attribute20,
	p_rec.bnr_attribute21,
	p_rec.bnr_attribute22,
	p_rec.bnr_attribute23,
	p_rec.bnr_attribute24,
	p_rec.bnr_attribute25,
	p_rec.bnr_attribute26,
	p_rec.bnr_attribute27,
	p_rec.bnr_attribute28,
	p_rec.bnr_attribute29,
	p_rec.bnr_attribute30,
        p_rec.function_code,
        p_rec.legislation_code,
	p_rec.object_version_number,
	p_rec.ordr_num                      --iRec
  );

Line: 155

   insert into ben_rptg_grp_tl (
    rptg_grp_id,
    function_code,
    name,
    language,
    source_lang,
    last_update_date,
    last_updated_by,
    last_update_login,
    created_by,
    creation_date
  )
  select
    p_rec.rptg_grp_id,
    p_rec.function_code,
    p_rec.name,
    l.language_code,
    userenv('LANG'),
    l_last_update_date,
    l_last_updated_by,
    l_last_update_login,
    fnd_global.user_id,
    sysdate
  from fnd_languages l
  where l.installed_flag in ('I', 'B')
  and not exists
    (select null
    from ben_rptg_grp_tl t
    where t.rptg_grp_id = p_rec.rptg_grp_id
    and   t.language = l.language_code);

Line: 208

End insert_dml;

Line: 247

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

Line: 251

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

Line: 254

     select legislation_code
     from   per_business_groups
     where  business_group_id = p_rec.business_group_id;

Line: 273

End pre_insert;

Line: 307

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

Line: 320

    ben_bnr_rki.after_insert
      (
  p_rptg_grp_id                   =>p_rec.rptg_grp_id
 ,p_name                          =>p_rec.name
 ,p_business_group_id             =>p_rec.business_group_id
 ,p_rptg_prps_cd                  =>p_rec.rptg_prps_cd
 ,p_rpg_desc                      =>p_rec.rpg_desc
 ,p_bnr_attribute_category        =>p_rec.bnr_attribute_category
 ,p_bnr_attribute1                =>p_rec.bnr_attribute1
 ,p_bnr_attribute2                =>p_rec.bnr_attribute2
 ,p_bnr_attribute3                =>p_rec.bnr_attribute3
 ,p_bnr_attribute4                =>p_rec.bnr_attribute4
 ,p_bnr_attribute5                =>p_rec.bnr_attribute5
 ,p_bnr_attribute6                =>p_rec.bnr_attribute6
 ,p_bnr_attribute7                =>p_rec.bnr_attribute7
 ,p_bnr_attribute8                =>p_rec.bnr_attribute8
 ,p_bnr_attribute9                =>p_rec.bnr_attribute9
 ,p_bnr_attribute10               =>p_rec.bnr_attribute10
 ,p_bnr_attribute11               =>p_rec.bnr_attribute11
 ,p_bnr_attribute12               =>p_rec.bnr_attribute12
 ,p_bnr_attribute13               =>p_rec.bnr_attribute13
 ,p_bnr_attribute14               =>p_rec.bnr_attribute14
 ,p_bnr_attribute15               =>p_rec.bnr_attribute15
 ,p_bnr_attribute16               =>p_rec.bnr_attribute16
 ,p_bnr_attribute17               =>p_rec.bnr_attribute17
 ,p_bnr_attribute18               =>p_rec.bnr_attribute18
 ,p_bnr_attribute19               =>p_rec.bnr_attribute19
 ,p_bnr_attribute20               =>p_rec.bnr_attribute20
 ,p_bnr_attribute21               =>p_rec.bnr_attribute21
 ,p_bnr_attribute22               =>p_rec.bnr_attribute22
 ,p_bnr_attribute23               =>p_rec.bnr_attribute23
 ,p_bnr_attribute24               =>p_rec.bnr_attribute24
 ,p_bnr_attribute25               =>p_rec.bnr_attribute25
 ,p_bnr_attribute26               =>p_rec.bnr_attribute26
 ,p_bnr_attribute27               =>p_rec.bnr_attribute27
 ,p_bnr_attribute28               =>p_rec.bnr_attribute28
 ,p_bnr_attribute29               =>p_rec.bnr_attribute29
 ,p_bnr_attribute30               =>p_rec.bnr_attribute30
 ,p_function_code                 =>p_rec.function_code
 ,p_legislation_code              =>p_rec.legislation_code
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_ordr_num                      =>p_rec.ordr_num                      --iRec
 ,p_effective_date                =>p_effective_date
      );

Line: 379

End post_insert;

Line: 397

  ben_bnr_bus.insert_validate(p_rec
  ,p_effective_date);

Line: 402

  pre_insert(p_rec);

Line: 406

  insert_dml(p_rec);

Line: 410

  post_insert(
p_effective_date,p_rec);