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_TYPE_USAGE_API SQL Statements

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

Line: 12


procedure update_person_type_usage
  (p_validate                       in  boolean    default false
  ,p_person_type_usage_id           in  number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ,p_object_version_number          in  out nocopy number
  ,p_person_type_id                 in  number    default hr_api.g_number
  ,p_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_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_person_type_usage';

Line: 69


    savepoint update_person_type_usage;

Line: 83


    hr_person_type_usage_bk1.update_person_type_usage_b
      (
       p_person_type_usage_id           =>  p_person_type_usage_id
      ,p_object_version_number          =>  p_object_version_number
      ,p_attribute_category             =>  p_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_effective_date                      => l_effective_date
    ,p_datetrack_mode                      => p_datetrack_mode
      );

Line: 124


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

Line: 186


    hr_person_type_usage_bk1.update_person_type_usage_a
      (
       p_person_type_usage_id           =>  p_person_type_usage_id
      ,p_effective_start_date           =>  l_effective_start_date
      ,p_effective_end_date             =>  l_effective_end_date
      ,p_object_version_number          =>  l_object_version_number
      ,p_attribute_category             =>  p_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_effective_date                     => l_effective_date
      ,p_datetrack_mode                     => p_datetrack_mode
      );

Line: 229


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

Line: 260


    ROLLBACK TO update_person_type_usage;

Line: 268


end update_person_type_usage;

Line: 287


    select system_person_type
    from per_person_types ppt
    where p_person_type = system_person_type;

Line: 292


    select person_id
    from per_all_people_f
    where person_id = p_person_id;

Line: 297


    select 'Y'
    from per_person_types ppt,
         per_person_type_usages_f ptu
    where ptu.person_id = p_person_id
      and ptu.effective_start_date <= p_effective_date
      and ptu.effective_end_date   >= p_effective_date
      and ptu.person_type_id = ppt.person_type_id
      and ppt.system_person_type = p_person_type;

Line: 376


    select system_person_type
    from per_person_types ppt
    where p_person_type = system_person_type;

Line: 381


    select person_id
    from per_all_people_f
    where person_id = p_person_id;

Line: 386


    select 'Y'
    from per_person_types ppt,
         per_person_type_usages_f ptu
    where ptu.person_id = p_person_id
      and ppt.system_person_type = p_person_type
      and ptu.effective_end_date < p_effective_date
      and ptu.person_type_id = ppt.person_type_id
      and not exists (select 'Y' from per_person_types ppt1,
                                      per_person_type_usages_f ptu1
                      where ptu1.person_id = p_person_id
                        and ppt1.system_person_type = p_person_type
                        and ptu1.effective_end_date >= p_effective_date
                        and ptu1.effective_start_date <= p_effective_date
                        and ptu1.person_type_id = ppt1.person_type_id);

Line: 520


    select system_person_type
    from per_person_types
    where person_type_id = p_person_type_id;

Line: 761


procedure delete_person_type_usage
  ( p_validate                       in boolean        default false
  ,p_person_type_usage_id           in number
  ,p_effective_date                 in date
  ,p_datetrack_mode                 in varchar2
  ,p_object_version_number          in out nocopy number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ) is

  l_proc             varchar2(80) :=  g_package||'delete_person_type_usage';

Line: 779


  select ppt.system_person_type
  from per_person_type_usages_f ptu , per_person_types ppt
  where ptu.person_type_usage_id = p_person_type_usage_id
  and ptu.person_type_id = ppt.person_type_id
  and ( p_effective_date between
      ptu.effective_start_date and ptu.effective_end_date);

Line: 793


    savepoint delete_person_type_usage;

Line: 839


       hr_person_type_usage_bk3.delete_person_type_usage_b
         (p_person_type_usage_id           => p_person_type_usage_id
         ,p_effective_date                 => p_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode
         ,p_object_version_number          => l_object_version_number
         );

Line: 849


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

Line: 859


  hr_per_type_usage_internal.delete_person_type_usage
   (p_validate                        => FALSE
    ,p_person_type_usage_id           => p_person_type_usage_id
    ,p_effective_date                 => p_effective_date
    ,p_datetrack_mode                 => p_datetrack_mode
    ,p_object_version_number          => l_object_version_number
    ,p_effective_start_date           => l_effective_start_date
    ,p_effective_end_date             => l_effective_end_date
    );

Line: 880


       hr_person_type_usage_bk3.delete_person_type_usage_a
         (p_person_type_usage_id           => p_person_type_usage_id
         ,p_effective_date                 => p_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode
         ,p_object_version_number          => l_object_version_number
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         );

Line: 892


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

Line: 918


    ROLLBACK TO delete_person_type_usage;

Line: 926


end delete_person_type_usage;