APPS.PQH_PSU_INS SQL Statements

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

Line: 75

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

Line: 89

  insert into pqh_fr_emp_stat_situations
      (emp_stat_situation_id
      ,statutory_situation_id
      ,person_id
      ,provisional_start_date
      ,provisional_end_date
      ,actual_start_date
      ,actual_end_date
      ,approval_flag
      ,comments
      ,contact_person_id
      ,contact_relationship
      ,external_organization_id
      ,renewal_flag
      ,renew_stat_situation_id
      ,seconded_career_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
      ,object_version_number
      )
  Values
    (p_rec.emp_stat_situation_id
    ,p_rec.statutory_situation_id
    ,p_rec.person_id
    ,p_rec.provisional_start_date
    ,p_rec.provisional_end_date
    ,p_rec.actual_start_date
    ,p_rec.actual_end_date
    ,p_rec.approval_flag
    ,p_rec.comments
    ,p_rec.contact_person_id
    ,p_rec.contact_relationship
    ,p_rec.external_organization_id
    ,p_rec.renewal_flag
    ,p_rec.renew_stat_situation_id
    ,p_rec.seconded_career_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
    ,p_rec.object_version_number
    );

Line: 210

End insert_dml;

Line: 249

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

Line: 256

    Select null
      from pqh_fr_emp_stat_situations
     where emp_stat_situation_id =
             pqh_psu_ins.g_emp_stat_situation_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 pqh_psu_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'post_insert';

Line: 347

    pqh_psu_rki.after_insert
      (p_effective_date              => p_effective_date
      ,p_emp_stat_situation_id
      => p_rec.emp_stat_situation_id
      ,p_statutory_situation_id
      => p_rec.statutory_situation_id
      ,p_person_id
      => p_rec.person_id
      ,p_provisional_start_date
      => p_rec.provisional_start_date
      ,p_provisional_end_date
      => p_rec.provisional_end_date
      ,p_actual_start_date
      => p_rec.actual_start_date
      ,p_actual_end_date
      => p_rec.actual_end_date
      ,p_approval_flag
      => p_rec.approval_flag
      ,p_comments
      => p_rec.comments
      ,p_contact_person_id
      => p_rec.contact_person_id
      ,p_contact_relationship
      => p_rec.contact_relationship
      ,p_external_organization_id
      => p_rec.external_organization_id
      ,p_renewal_flag
      => p_rec.renewal_flag
      ,p_renew_stat_situation_id
      => p_rec.renew_stat_situation_id
      ,p_seconded_career_id
      => p_rec.seconded_career_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
      ,p_object_version_number
      => p_rec.object_version_number
      );

Line: 456

End post_insert;

Line: 473

  pqh_psu_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 483

  pqh_psu_ins.pre_insert(p_rec);

Line: 487

  pqh_psu_ins.insert_dml(p_rec);

Line: 491

  pqh_psu_ins.post_insert
     (p_effective_date
     ,p_rec
     );