APPS.HXC_EGC_INS SQL Statements

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

Line: 52

Procedure insert_dml
  (p_rec in out nocopy hxc_egc_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72);

Line: 60

	l_proc := g_package||'insert_dml';

Line: 69

  insert into hxc_entity_group_comps
      (entity_group_comp_id
      ,entity_group_id
      ,entity_id
      ,entity_type
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,attribute16
      ,attribute17
      ,attribute18
      ,attribute19
      ,attribute20
      ,attribute21
      ,attribute22
      ,attribute23
      ,attribute24
      ,attribute25
      ,attribute26
      ,attribute27
      ,attribute28
      ,attribute29
      ,attribute30
      ,object_version_number
      ,creation_date
,created_by
,last_updated_by
,last_update_date
,last_update_login
      )
  Values
    (p_rec.entity_group_comp_id
    ,p_rec.entity_group_id
    ,p_rec.entity_id
    ,p_rec.entity_type
    ,p_rec.attribute_category
    ,p_rec.attribute1
    ,p_rec.attribute2
    ,p_rec.attribute3
    ,p_rec.attribute4
    ,p_rec.attribute5
    ,p_rec.attribute6
    ,p_rec.attribute7
    ,p_rec.attribute8
    ,p_rec.attribute9
    ,p_rec.attribute10
    ,p_rec.attribute11
    ,p_rec.attribute12
    ,p_rec.attribute13
    ,p_rec.attribute14
    ,p_rec.attribute15
    ,p_rec.attribute16
    ,p_rec.attribute17
    ,p_rec.attribute18
    ,p_rec.attribute19
    ,p_rec.attribute20
    ,p_rec.attribute21
    ,p_rec.attribute22
    ,p_rec.attribute23
    ,p_rec.attribute24
    ,p_rec.attribute25
    ,p_rec.attribute26
    ,p_rec.attribute27
    ,p_rec.attribute28
    ,p_rec.attribute29
    ,p_rec.attribute30
    ,p_rec.object_version_number
     ,sysdate
 ,fnd_global.user_id
 ,fnd_global.user_id
 ,sysdate
 ,fnd_global.login_id
    );

Line: 180

End insert_dml;

Line: 217

Procedure pre_insert
  (p_rec  in out nocopy hxc_egc_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) ;

Line: 223

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

Line: 227

	l_proc:= g_package||'pre_insert';

Line: 241

End pre_insert;

Line: 273

Procedure post_insert
  (p_effective_date               in date
  ,p_rec                          in hxc_egc_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72);

Line: 282

	l_proc := g_package||'post_insert';

Line: 287

    hxc_egc_rki.after_insert
      (p_effective_date              => p_effective_date
      ,p_entity_group_comp_id
      => p_rec.entity_group_comp_id
      ,p_entity_group_id
      => p_rec.entity_group_id
      ,p_entity_id
      => p_rec.entity_id
      ,p_entity_type
      => p_rec.entity_type
      ,p_attribute_category
      => p_rec.attribute_category
      ,p_attribute1
      => p_rec.attribute1
      ,p_attribute2
      => p_rec.attribute2
      ,p_attribute3
      => p_rec.attribute3
      ,p_attribute4
      => p_rec.attribute4
      ,p_attribute5
      => p_rec.attribute5
      ,p_attribute6
      => p_rec.attribute6
      ,p_attribute7
      => p_rec.attribute7
      ,p_attribute8
      => p_rec.attribute8
      ,p_attribute9
      => p_rec.attribute9
      ,p_attribute10
      => p_rec.attribute10
      ,p_attribute11
      => p_rec.attribute11
      ,p_attribute12
      => p_rec.attribute12
      ,p_attribute13
      => p_rec.attribute13
      ,p_attribute14
      => p_rec.attribute14
      ,p_attribute15
      => p_rec.attribute15
      ,p_attribute16
      => p_rec.attribute16
      ,p_attribute17
      => p_rec.attribute17
      ,p_attribute18
      => p_rec.attribute18
      ,p_attribute19
      => p_rec.attribute19
      ,p_attribute20
      => p_rec.attribute20
      ,p_attribute21
      => p_rec.attribute21
      ,p_attribute22
      => p_rec.attribute22
      ,p_attribute23
      => p_rec.attribute23
      ,p_attribute24
      => p_rec.attribute24
      ,p_attribute25
      => p_rec.attribute25
      ,p_attribute26
      => p_rec.attribute26
      ,p_attribute27
      => p_rec.attribute27
      ,p_attribute28
      => p_rec.attribute28
      ,p_attribute29
      => p_rec.attribute29
      ,p_attribute30
      => p_rec.attribute30
      ,p_object_version_number
      => p_rec.object_version_number
      );

Line: 376

End post_insert;

Line: 402

  hxc_egc_bus.insert_validate
     (p_effective_date
     ,p_rec
     ,p_called_from_form => p_called_from_form
     );

Line: 413

  hxc_egc_ins.pre_insert(p_rec);

Line: 417

  hxc_egc_ins.insert_dml(p_rec);

Line: 421

  hxc_egc_ins.post_insert
     (p_effective_date
     ,p_rec
     );