eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_CPD_INS SQL Statements

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

Line: 82


Procedure insert_dml
  (p_rec in out nocopy pqh_cpd_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) ;

Line: 90


    l_proc := g_package||'insert_dml';

Line: 99


  insert into pqh_corps_definitions
      (corps_definition_id
      ,business_group_id
      ,name
      ,status_cd
      ,retirement_age
      ,category_cd
      ,recruitment_end_date
      ,corps_type_cd
      ,starting_grade_step_id
      ,task_desc
      ,secondment_threshold
      ,normal_hours
      ,normal_hours_frequency
      ,minimum_hours
      ,minimum_hours_frequency
      ,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
      ,attribute_category
      ,object_version_number
      ,type_of_ps
      ,date_from
      ,date_to
      ,primary_prof_field_id
      ,starting_grade_id
      ,ben_pgm_id
      ,probation_period
      ,probation_units
      )
  Values
    (p_rec.corps_definition_id
    ,p_rec.business_group_id
    ,p_rec.name
    ,p_rec.status_cd
    ,p_rec.retirement_age
    ,p_rec.category_cd
    ,p_rec.recruitment_end_date
    ,p_rec.corps_type_cd
    ,p_rec.starting_grade_step_id
    ,p_rec.task_desc
    ,p_rec.secondment_threshold
    ,p_rec.normal_hours
    ,p_rec.normal_hours_frequency
    ,p_rec.minimum_hours
    ,p_rec.minimum_hours_frequency
    ,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.attribute_category
    ,p_rec.object_version_number
    ,p_rec.type_of_ps
    ,p_rec.date_from
    ,p_rec.date_to
    ,p_rec.primary_prof_field_id
    ,p_rec.starting_grade_id
    ,p_rec.ben_pgm_id
    ,p_rec.probation_period
    ,p_rec.probation_units
    );

Line: 238


End insert_dml;

Line: 277


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

Line: 284


    Select null
      from pqh_corps_definitions
     where corps_definition_id =
             pqh_cpd_ins.g_corps_definition_id_i;

Line: 294


    l_proc := g_package||'pre_insert';

Line: 335


End pre_insert;

Line: 369


Procedure post_insert
  (p_effective_date               in date
  ,p_rec                          in pqh_cpd_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72);

Line: 378


     l_proc :=  g_package||'post_insert';

Line: 383


    pqh_cpd_rki.after_insert
      (p_effective_date              => p_effective_date
      ,p_corps_definition_id
      => p_rec.corps_definition_id
      ,p_business_group_id
      => p_rec.business_group_id
      ,p_name
      => p_rec.name
      ,p_status_cd
      => p_rec.status_cd
      ,p_retirement_age
      => p_rec.retirement_age
      ,p_category_cd
      => p_rec.category_cd
      ,p_recruitment_end_date
      => p_rec.recruitment_end_date
      ,p_corps_type_cd
      => p_rec.corps_type_cd
      ,p_starting_grade_step_id
      => p_rec.starting_grade_step_id
      ,p_task_desc
      => p_rec.task_desc
      ,p_secondment_threshold
      => p_rec.secondment_threshold
      ,p_normal_hours
      => p_rec.normal_hours
      ,p_normal_hours_frequency
      => p_rec.normal_hours_frequency
      ,p_minimum_hours
      => p_rec.minimum_hours
      ,p_minimum_hours_frequency
      => p_rec.minimum_hours_frequency
      ,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_attribute_category
      => p_rec.attribute_category
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_type_of_ps
      => p_rec.type_of_ps
      ,p_date_from
      => p_rec.date_from
      ,p_date_to
      => p_rec.date_to
      ,p_primary_prof_field_id
      => p_rec.primary_prof_field_id
      ,p_starting_grade_id
      => p_rec.starting_grade_id
      ,p_ben_pgm_id
      => p_rec.ben_pgm_id
      ,p_probation_period
      => p_rec.probation_period
      ,p_probation_units
      => p_rec.probation_units
      );

Line: 510


End post_insert;

Line: 530


  pqh_cpd_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 540


  pqh_cpd_ins.pre_insert(p_rec);

Line: 544


  pqh_cpd_ins.insert_dml(p_rec);

Line: 548


  pqh_cpd_ins.post_insert
     (p_effective_date
     ,p_rec
     );