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

Line: 89


  insert into per_absence_cases
      (absence_case_id
      ,name
      ,person_id
      ,incident_id
      ,absence_category
      ,ac_information_category
      ,ac_information1
      ,ac_information2
      ,ac_information3
      ,ac_information4
      ,ac_information5
      ,ac_information6
      ,ac_information7
      ,ac_information8
      ,ac_information9
      ,ac_information10
      ,ac_information11
      ,ac_information12
      ,ac_information13
      ,ac_information14
      ,ac_information15
      ,ac_information16
      ,ac_information17
      ,ac_information18
      ,ac_information19
      ,ac_information20
      ,ac_information21
      ,ac_information22
      ,ac_information23
      ,ac_information24
      ,ac_information25
      ,ac_information26
      ,ac_information27
      ,ac_information28
      ,ac_information29
      ,ac_information30
      ,ac_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
      ,business_group_id
      ,comments
      )
  Values
    (p_rec.absence_case_id
    ,p_rec.name
    ,p_rec.person_id
    ,p_rec.incident_id
    ,p_rec.absence_category
    ,p_rec.ac_information_category
    ,p_rec.ac_information1
    ,p_rec.ac_information2
    ,p_rec.ac_information3
    ,p_rec.ac_information4
    ,p_rec.ac_information5
    ,p_rec.ac_information6
    ,p_rec.ac_information7
    ,p_rec.ac_information8
    ,p_rec.ac_information9
    ,p_rec.ac_information10
    ,p_rec.ac_information11
    ,p_rec.ac_information12
    ,p_rec.ac_information13
    ,p_rec.ac_information14
    ,p_rec.ac_information15
    ,p_rec.ac_information16
    ,p_rec.ac_information17
    ,p_rec.ac_information18
    ,p_rec.ac_information19
    ,p_rec.ac_information20
    ,p_rec.ac_information21
    ,p_rec.ac_information22
    ,p_rec.ac_information23
    ,p_rec.ac_information24
    ,p_rec.ac_information25
    ,p_rec.ac_information26
    ,p_rec.ac_information27
    ,p_rec.ac_information28
    ,p_rec.ac_information29
    ,p_rec.ac_information30
    ,p_rec.ac_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
    ,p_rec.business_group_id
    ,p_rec.comments
    );

Line: 256


End insert_dml;

Line: 295


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

Line: 302


    Select null
      from per_absence_cases
     where absence_case_id =
             per_abc_ins.g_absence_case_id_i;

Line: 307


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

Line: 348


End pre_insert;

Line: 382


Procedure post_insert
  (p_rec                          in per_abc_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'post_insert';

Line: 392


    per_abc_rki.after_insert
      (p_absence_case_id
      => p_rec.absence_case_id
      ,p_name
      => p_rec.name
      ,p_person_id
      => p_rec.person_id
      ,p_incident_id
      => p_rec.incident_id
      ,p_absence_category
      => p_rec.absence_category
      ,p_ac_information_category
      => p_rec.ac_information_category
      ,p_ac_information1
      => p_rec.ac_information1
      ,p_ac_information2
      => p_rec.ac_information2
      ,p_ac_information3
      => p_rec.ac_information3
      ,p_ac_information4
      => p_rec.ac_information4
      ,p_ac_information5
      => p_rec.ac_information5
      ,p_ac_information6
      => p_rec.ac_information6
      ,p_ac_information7
      => p_rec.ac_information7
      ,p_ac_information8
      => p_rec.ac_information8
      ,p_ac_information9
      => p_rec.ac_information9
      ,p_ac_information10
      => p_rec.ac_information10
      ,p_ac_information11
      => p_rec.ac_information11
      ,p_ac_information12
      => p_rec.ac_information12
      ,p_ac_information13
      => p_rec.ac_information13
      ,p_ac_information14
      => p_rec.ac_information14
      ,p_ac_information15
      => p_rec.ac_information15
      ,p_ac_information16
      => p_rec.ac_information16
      ,p_ac_information17
      => p_rec.ac_information17
      ,p_ac_information18
      => p_rec.ac_information18
      ,p_ac_information19
      => p_rec.ac_information19
      ,p_ac_information20
      => p_rec.ac_information20
      ,p_ac_information21
      => p_rec.ac_information21
      ,p_ac_information22
      => p_rec.ac_information22
      ,p_ac_information23
      => p_rec.ac_information23
      ,p_ac_information24
      => p_rec.ac_information24
      ,p_ac_information25
      => p_rec.ac_information25
      ,p_ac_information26
      => p_rec.ac_information26
      ,p_ac_information27
      => p_rec.ac_information27
      ,p_ac_information28
      => p_rec.ac_information28
      ,p_ac_information29
      => p_rec.ac_information29
      ,p_ac_information30
      => p_rec.ac_information30
      ,p_ac_attribute_category
      => p_rec.ac_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
      ,p_business_group_id
      => p_rec.business_group_id
      ,p_comments
      => p_rec.comments
      );

Line: 546


End post_insert;

Line: 562


  per_abc_bus.insert_validate
     (p_rec
     );

Line: 571


  per_abc_ins.pre_insert(p_rec);

Line: 575


  per_abc_ins.insert_dml(p_rec);

Line: 579


  per_abc_ins.post_insert
     (p_rec
     );