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
	  ,obj_setting_deadline
	  ,supervisor_id
	  ,supervisor_assignment_id
	  ,eligibility_status
	  ,eligibility_eval_date
      )
  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
	,p_rec.obj_setting_deadline
	,p_rec.supervisor_id
	,p_rec.supervisor_assignment_id
	,p_rec.eligibility_status
	,p_rec.eligibility_eval_date
    );

Line: 210

End insert_dml;

Line: 249

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: 256

    Select null
      from per_personal_scorecards
     where scorecard_id =
             per_pms_ins.g_scorecard_id_i;

Line: 261

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

Line: 302

End pre_insert;

Line: 336

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: 348

    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
	  ,p_obj_setting_deadline
	  => p_rec.obj_setting_deadline
	  ,p_supervisor_id
	  => p_rec.supervisor_id
	  ,p_supervisor_assignment_id
	  => p_rec.supervisor_assignment_id
	  ,p_eligibility_status
	  => p_rec.eligibility_status
	  ,p_eligibility_eval_date
	  => p_rec.eligibility_eval_date
      );

Line: 459

End post_insert;

Line: 488

  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: 507

  per_pms_ins.pre_insert(p_rec);

Line: 511

  per_pms_ins.insert_dml(p_rec);

Line: 515

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