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.HR_PERSON_ABSENCE_CASE_API SQL Statements

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

Line: 397


procedure update_person_absence_case
  (p_validate                      in     boolean  default false
  ,p_absence_case_id               in     number
  ,p_name                          in     varchar2 default hr_api.g_varchar2
  ,p_incident_id                   in     number   default hr_api.g_number
  ,p_absence_category              in     varchar2 default null
  ,p_ac_attribute_category         in     varchar2 default hr_api.g_varchar2
  ,p_attribute1                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute2                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute3                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute4                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute5                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute6                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute7                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute8                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute9                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute10                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute11                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute12                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute13                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute14                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute15                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute16                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute17                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute18                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute19                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute20                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute21                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute22                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute23                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute24                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute25                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute26                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute27                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute28                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute29                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute30                   in     varchar2 default hr_api.g_varchar2
  ,p_ac_information_category       in     varchar2 default hr_api.g_varchar2
  ,p_ac_information1               in     varchar2 default hr_api.g_varchar2
  ,p_ac_information2               in     varchar2 default hr_api.g_varchar2
  ,p_ac_information3               in     varchar2 default hr_api.g_varchar2
  ,p_ac_information4               in     varchar2 default hr_api.g_varchar2
  ,p_ac_information5               in     varchar2 default hr_api.g_varchar2
  ,p_ac_information6               in     varchar2 default hr_api.g_varchar2
  ,p_ac_information7               in     varchar2 default hr_api.g_varchar2
  ,p_ac_information8               in     varchar2 default hr_api.g_varchar2
  ,p_ac_information9               in     varchar2 default hr_api.g_varchar2
  ,p_ac_information10              in     varchar2 default hr_api.g_varchar2
  ,p_ac_information11              in     varchar2 default hr_api.g_varchar2
  ,p_ac_information12              in     varchar2 default hr_api.g_varchar2
  ,p_ac_information13              in     varchar2 default hr_api.g_varchar2
  ,p_ac_information14              in     varchar2 default hr_api.g_varchar2
  ,p_ac_information15              in     varchar2 default hr_api.g_varchar2
  ,p_ac_information16              in     varchar2 default hr_api.g_varchar2
  ,p_ac_information17              in     varchar2 default hr_api.g_varchar2
  ,p_ac_information18              in     varchar2 default hr_api.g_varchar2
  ,p_ac_information19              in     varchar2 default hr_api.g_varchar2
  ,p_ac_information20              in     varchar2 default hr_api.g_varchar2
  ,p_ac_information21              in     varchar2 default hr_api.g_varchar2
  ,p_ac_information22              in     varchar2 default hr_api.g_varchar2
  ,p_ac_information23              in     varchar2 default hr_api.g_varchar2
  ,p_ac_information24              in     varchar2 default hr_api.g_varchar2
  ,p_ac_information25              in     varchar2 default hr_api.g_varchar2
  ,p_ac_information26              in     varchar2 default hr_api.g_varchar2
  ,p_ac_information27              in     varchar2 default hr_api.g_varchar2
  ,p_ac_information28              in     varchar2 default hr_api.g_varchar2
  ,p_ac_information29              in     varchar2 default hr_api.g_varchar2
  ,p_ac_information30              in     varchar2 default hr_api.g_varchar2
  ,p_comments                      in     varchar2 default hr_api.g_varchar2
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'update_person_absence_case';

Line: 486


  savepoint update_person_absence_case;

Line: 496


    hr_person_absence_case_bk2.update_person_absence_case_b
      (p_absence_case_id               => p_absence_case_id
      ,p_object_version_number         => p_object_version_number
      ,p_name                          => p_name
      ,p_incident_id                   => p_incident_id
      ,p_absence_category              => p_absence_category
      ,p_ac_attribute_category         => p_ac_attribute_category
      ,p_attribute1                    => p_attribute1
      ,p_attribute2                    => p_attribute2
      ,p_attribute3                    => p_attribute3
      ,p_attribute4                    => p_attribute4
      ,p_attribute5                    => p_attribute5
      ,p_attribute6                    => p_attribute6
      ,p_attribute7                    => p_attribute7
      ,p_attribute8                    => p_attribute8
      ,p_attribute9                    => p_attribute9
      ,p_attribute10                   => p_attribute10
      ,p_attribute11                   => p_attribute11
      ,p_attribute12                   => p_attribute12
      ,p_attribute13                   => p_attribute13
      ,p_attribute14                   => p_attribute14
      ,p_attribute15                   => p_attribute15
      ,p_attribute16                   => p_attribute16
      ,p_attribute17                   => p_attribute17
      ,p_attribute18                   => p_attribute18
      ,p_attribute19                   => p_attribute19
      ,p_attribute20                   => p_attribute20
      ,p_attribute21                   => p_attribute21
      ,p_attribute22                   => p_attribute22
      ,p_attribute23                   => p_attribute23
      ,p_attribute24                   => p_attribute24
      ,p_attribute25                   => p_attribute25
      ,p_attribute26                   => p_attribute26
      ,p_attribute27                   => p_attribute27
      ,p_attribute28                   => p_attribute28
      ,p_attribute29                   => p_attribute29
      ,p_attribute30                   => p_attribute30
      ,p_ac_information_category       => p_ac_information_category
      ,p_ac_information1               => p_ac_information1
      ,p_ac_information2               => p_ac_information2
      ,p_ac_information3               => p_ac_information3
      ,p_ac_information4               => p_ac_information4
      ,p_ac_information5               => p_ac_information5
      ,p_ac_information6               => p_ac_information6
      ,p_ac_information7               => p_ac_information7
      ,p_ac_information8               => p_ac_information8
      ,p_ac_information9               => p_ac_information9
      ,p_ac_information10              => p_ac_information10
      ,p_ac_information11              => p_ac_information11
      ,p_ac_information12              => p_ac_information12
      ,p_ac_information13              => p_ac_information13
      ,p_ac_information14              => p_ac_information14
      ,p_ac_information15              => p_ac_information15
      ,p_ac_information16              => p_ac_information16
      ,p_ac_information17              => p_ac_information17
      ,p_ac_information18              => p_ac_information18
      ,p_ac_information19              => p_ac_information19
      ,p_ac_information20              => p_ac_information20
      ,p_ac_information21              => p_ac_information21
      ,p_ac_information22              => p_ac_information22
      ,p_ac_information23              => p_ac_information23
      ,p_ac_information24              => p_ac_information24
      ,p_ac_information25              => p_ac_information25
      ,p_ac_information26              => p_ac_information26
      ,p_ac_information27              => p_ac_information27
      ,p_ac_information28              => p_ac_information28
      ,p_ac_information29              => p_ac_information29
      ,p_ac_information30              => p_ac_information30
      ,p_comments                      => p_comments
      );

Line: 569


        (p_module_name => 'UPDATE_PERSON_ABSENCE'
        ,p_hook_type   => 'BP'
        );

Line: 661


    hr_person_absence_case_bk2.update_person_absence_case_a
      (p_absence_case_id               => p_absence_case_id
      ,p_object_version_number         => l_object_version_number
      ,p_name                          => p_name
      ,p_incident_id                   => p_incident_id
      ,p_absence_category              => p_absence_category
      ,p_ac_attribute_category         => p_ac_attribute_category
      ,p_attribute1                    => p_attribute1
      ,p_attribute2                    => p_attribute2
      ,p_attribute3                    => p_attribute3
      ,p_attribute4                    => p_attribute4
      ,p_attribute5                    => p_attribute5
      ,p_attribute6                    => p_attribute6
      ,p_attribute7                    => p_attribute7
      ,p_attribute8                    => p_attribute8
      ,p_attribute9                    => p_attribute9
      ,p_attribute10                   => p_attribute10
      ,p_attribute11                   => p_attribute11
      ,p_attribute12                   => p_attribute12
      ,p_attribute13                   => p_attribute13
      ,p_attribute14                   => p_attribute14
      ,p_attribute15                   => p_attribute15
      ,p_attribute16                   => p_attribute16
      ,p_attribute17                   => p_attribute17
      ,p_attribute18                   => p_attribute18
      ,p_attribute19                   => p_attribute19
      ,p_attribute20                   => p_attribute20
      ,p_attribute21                   => p_attribute21
      ,p_attribute22                   => p_attribute22
      ,p_attribute23                   => p_attribute23
      ,p_attribute24                   => p_attribute24
      ,p_attribute25                   => p_attribute25
      ,p_attribute26                   => p_attribute26
      ,p_attribute27                   => p_attribute27
      ,p_attribute28                   => p_attribute28
      ,p_attribute29                   => p_attribute29
      ,p_attribute30                   => p_attribute30
      ,p_ac_information_category       => p_ac_information_category
      ,p_ac_information1               => p_ac_information1
      ,p_ac_information2               => p_ac_information2
      ,p_ac_information3               => p_ac_information3
      ,p_ac_information4               => p_ac_information4
      ,p_ac_information5               => p_ac_information5
      ,p_ac_information6               => p_ac_information6
      ,p_ac_information7               => p_ac_information7
      ,p_ac_information8               => p_ac_information8
      ,p_ac_information9               => p_ac_information9
      ,p_ac_information10              => p_ac_information10
      ,p_ac_information11              => p_ac_information11
      ,p_ac_information12              => p_ac_information12
      ,p_ac_information13              => p_ac_information13
      ,p_ac_information14              => p_ac_information14
      ,p_ac_information15              => p_ac_information15
      ,p_ac_information16              => p_ac_information16
      ,p_ac_information17              => p_ac_information17
      ,p_ac_information18              => p_ac_information18
      ,p_ac_information19              => p_ac_information19
      ,p_ac_information20              => p_ac_information20
      ,p_ac_information21              => p_ac_information21
      ,p_ac_information22              => p_ac_information22
      ,p_ac_information23              => p_ac_information23
      ,p_ac_information24              => p_ac_information24
      ,p_ac_information25              => p_ac_information25
      ,p_ac_information26              => p_ac_information26
      ,p_ac_information27              => p_ac_information27
      ,p_ac_information28              => p_ac_information28
      ,p_ac_information29              => p_ac_information29
      ,p_ac_information30              => p_ac_information30
      ,p_comments                      => p_comments
      );

Line: 734


        (p_module_name => 'UPDATE_PERSON_ABSENCE_CASE'
        ,p_hook_type   => 'AP'
        );

Line: 753


    rollback to update_person_absence_case;

Line: 767


    rollback to update_person_absence_case;

Line: 770


end update_person_absence_case;

Line: 776


procedure delete_person_absence_case
  (p_validate                      in     boolean default false
  ,p_absence_case_id               in     number
  ,p_object_version_number         in     number
  ) is

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

Line: 790


  savepoint delete_person_absence_case;

Line: 796


    hr_person_absence_case_bk3.delete_person_absence_case_b
      (p_absence_case_id               => p_absence_case_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 803


        (p_module_name => 'DELETE_PERSON_ABSENCE_CASE'
        ,p_hook_type   => 'BP'
        );

Line: 822


    update per_absence_attendances
    set absence_case_id = null
    where absence_case_id =p_absence_case_id;

Line: 833


    hr_person_absence_case_bk3.delete_person_absence_case_a
      (p_absence_case_id               => p_absence_case_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 840


        (p_module_name => 'DELETE_PERSON_ABSENCE_CASE'
        ,p_hook_type   => 'AP'
        );

Line: 859


    rollback to delete_person_absence_case;

Line: 870


    rollback to delete_person_absence_case;

Line: 874


end delete_person_absence_case;