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
      ,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.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: 206

End insert_dml;

Line: 245

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

    Select null
      from per_appraisal_periods
     where appraisal_period_id =
             per_pma_ins.g_appraisal_period_id_i;

Line: 257

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

Line: 298

End pre_insert;

Line: 332

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

    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_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: 449

End post_insert;

Line: 466

  per_pma_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 476

  per_pma_ins.pre_insert(p_rec);

Line: 480

  per_pma_ins.insert_dml(p_rec);

Line: 484

  per_pma_ins.post_insert
     (p_effective_date
     ,p_rec
     );