APPS.PER_PMA_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_pma_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';

Line: 89

  insert into per_appraisal_periods
      (appraisal_period_id
      ,object_version_number
      ,plan_id
      ,appraisal_template_id
      ,start_date
      ,end_date
      ,task_start_date
      ,task_end_date
      ,initiator_code
      ,appraisal_system_type
      ,appraisal_type
      ,appraisal_assmt_status
      ,auto_conc_process
      ,days_before_task_st_dt
      ,participation_type
      ,questionnaire_template_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
      )
  Values
    (p_rec.appraisal_period_id
    ,p_rec.object_version_number
    ,p_rec.plan_id
    ,p_rec.appraisal_template_id
    ,p_rec.start_date
    ,p_rec.end_date
    ,p_rec.task_start_date
    ,p_rec.task_end_date
    ,p_rec.initiator_code
    ,p_rec.appraisal_system_type
    ,p_rec.appraisal_type
    ,p_rec.appraisal_assmt_status
    ,p_rec.auto_conc_process
    ,p_rec.days_before_task_st_dt
    ,p_rec.participation_type
    ,p_rec.questionnaire_template_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
    );

Line: 210

End insert_dml;

Line: 249

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

Line: 256

    Select null
      from per_appraisal_periods
     where appraisal_period_id =
             per_pma_ins.g_appraisal_period_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_pma_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'post_insert';

Line: 347

    per_pma_rki.after_insert
      (p_effective_date
      => p_effective_date
      ,p_appraisal_period_id
      => p_rec.appraisal_period_id
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_plan_id
      => p_rec.plan_id
      ,p_appraisal_template_id
      => p_rec.appraisal_template_id
      ,p_start_date
      => p_rec.start_date
      ,p_end_date
      => p_rec.end_date
      ,p_task_start_date
      => p_rec.task_start_date
      ,p_task_end_date
      => p_rec.task_end_date
      ,p_initiator_code
      => p_rec.initiator_code
      ,p_appraisal_system_type
      => p_rec.appraisal_system_type
      ,p_appraisal_type
      => p_rec.appraisal_type
      ,p_appraisal_assmt_status
      => p_rec.appraisal_assmt_status
      ,p_auto_conc_process
      => p_rec.auto_conc_process
      ,p_days_before_task_st_dt
      => p_rec.days_before_task_st_dt
      ,p_participation_type
      => p_rec.participation_type
      ,p_questionnaire_template_id
      => p_rec.questionnaire_template_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
      );

Line: 457

End post_insert;

Line: 474

  per_pma_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 484

  per_pma_ins.pre_insert(p_rec);

Line: 488

  per_pma_ins.insert_dml(p_rec);

Line: 492

  per_pma_ins.post_insert
     (p_effective_date
     ,p_rec
     );