APPS.PER_ECO_INS SQL Statements

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

Line: 53

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

Line: 60

  l_last_update_date    per_election_constituencys.last_update_date%TYPE;

Line: 61

  l_last_updated_by     per_election_constituencys.last_updated_by%TYPE;

Line: 62

  l_last_update_login   per_election_constituencys.last_update_login%TYPE;

Line: 74

  l_last_update_date   := sysdate;

Line: 75

  l_last_updated_by    := fnd_global.user_id;

Line: 76

  l_last_update_login  := fnd_global.login_id;

Line: 81

  insert into per_election_constituencys
      (election_constituency_id
      ,election_id
      ,business_group_id
      ,constituency_id
      ,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_update_date
      ,last_updated_by
      ,last_update_login
      )
  Values
    (p_rec.election_constituency_id
    ,p_rec.election_id
    ,p_rec.business_group_id
    ,p_rec.constituency_id
    ,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
    ,l_creation_date
    ,l_created_by
    ,l_last_update_date
    ,l_last_updated_by
    ,l_last_update_login
    );

Line: 194

End insert_dml;

Line: 233

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

Line: 239

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

Line: 252

End pre_insert;

Line: 286

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

Line: 297

    per_eco_rki.after_insert
      (p_effective_date              => p_effective_date
      ,p_election_constituency_id
      => p_rec.election_constituency_id
      ,p_election_id
      => p_rec.election_id
      ,p_business_group_id
      => p_rec.business_group_id
      ,p_constituency_id
      => p_rec.constituency_id
      ,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: 384

End post_insert;

Line: 411

  per_eco_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 418

  per_eco_ins.pre_insert(p_rec);

Line: 422

  per_eco_ins.insert_dml(p_rec);

Line: 426

  per_eco_ins.post_insert
     (p_effective_date
     ,p_rec
     );