APPS.PER_RSC_INS SQL Statements

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

Line: 47

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

Line: 58

  insert into per_rating_scales
  (   rating_scale_id,
      business_group_id,
      name,
      type,
      object_version_number,
      description,
      max_scale_step,
      min_scale_step,
      default_flag,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      attribute16,
      attribute17,
      attribute18,
      attribute19,
      attribute20
  )
  Values
  (   p_rec.rating_scale_id,
      p_rec.business_group_id,
      p_rec.name,
      p_rec.type,
      p_rec.object_version_number,
      p_rec.description,
      p_rec.max_scale_step,
      p_rec.min_scale_step,
      p_rec.default_flag,
      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
  );

Line: 140

End insert_dml;

Line: 179

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

Line: 183

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

Line: 197

End pre_insert;

Line: 231

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

Line: 241

     per_rsc_rki.after_insert	(
      p_rating_scale_id        => p_rec.rating_scale_id      ,
      p_business_group_id      => p_rec.business_group_id    ,
      p_object_version_number  => p_rec.object_version_number,
      p_name                   => p_rec.name                 ,
      p_type                   => p_rec.type                 ,
      p_description            => p_rec.description          ,
      p_default_flag           => p_rec.default_flag         ,
      p_max_scale_step         => p_rec.max_scale_step       ,
      p_min_scale_step         => p_rec.min_scale_step       ,
      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  );

Line: 283

End post_insert;

Line: 311

  per_rsc_bus.insert_validate(p_rec, p_effective_date);

Line: 315

  pre_insert(p_rec);

Line: 319

  insert_dml(p_rec);

Line: 323

  post_insert(p_rec);