APPS.PER_PMS_INS SQL Statements

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

Line: 75

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

Line: 89

  insert into per_personal_scorecards
      (scorecard_id
      ,object_version_number
      ,scorecard_name
      ,person_id
      ,assignment_id
      ,start_date
      ,end_date
      ,plan_id
      ,status_code
      ,creator_type
      ,error_log
      ,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
      )
  Values
    (p_rec.scorecard_id
    ,p_rec.object_version_number
    ,p_rec.scorecard_name
    ,p_rec.person_id
    ,p_rec.assignment_id
    ,p_rec.start_date
    ,p_rec.end_date
    ,p_rec.plan_id
    ,p_rec.status_code
    ,p_rec.creator_type
    ,p_rec.error_log
    ,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
    );

Line: 200

End insert_dml;

Line: 239

Procedure pre_insert
  (p_rec  in out nocopy per_pms_shd.g_rec_type
  ) is
--
  Cursor C_Sel1 is select per_personal_scorecards_s.nextval from sys.dual;

Line: 246

    Select null
      from per_personal_scorecards
     where scorecard_id =
             per_pms_ins.g_scorecard_id_i;

Line: 251

  l_proc   varchar2(72) := g_package||'pre_insert';

Line: 292

End pre_insert;

Line: 326

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

Line: 338

    per_pms_rki.after_insert
      (p_effective_date              => p_effective_date
      ,p_scorecard_id
      => p_rec.scorecard_id
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_scorecard_name
      => p_rec.scorecard_name
      ,p_person_id
      => p_rec.person_id
      ,p_assignment_id
      => p_rec.assignment_id
      ,p_start_date
      => p_rec.start_date
      ,p_end_date
      => p_rec.end_date
      ,p_plan_id
      => p_rec.plan_id
      ,p_creator_type
      => p_rec.creator_type
      ,p_error_log
      => p_rec.error_log
      ,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_status_code
      => p_rec.status_code
      ,p_duplicate_name_warning
      => p_duplicate_name_warning
      );

Line: 439

End post_insert;

Line: 468

  per_pms_bus.insert_validate
     (p_effective_date         => p_effective_date
     ,p_rec                    => p_rec
     ,p_person_id              => l_person_id
     ,p_duplicate_name_warning => p_duplicate_name_warning
     );

Line: 487

  per_pms_ins.pre_insert(p_rec);

Line: 491

  per_pms_ins.insert_dml(p_rec);

Line: 495

  per_pms_ins.post_insert
     (p_effective_date         => p_effective_date
     ,p_rec                    => p_rec
     ,p_duplicate_name_warning => p_duplicate_name_warning
     );