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

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

Line: 351


procedure update_shared_type
  (p_validate                       in  boolean   default false
  ,p_shared_type_id                 in  number
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_shared_type_name               in  varchar2  default hr_api.g_varchar2
  ,p_shared_type_code               in  varchar2  default hr_api.g_varchar2
  ,p_system_type_cd                 in  varchar2  default hr_api.g_varchar2
  ,p_language_code                  in  varchar2  default hr_api.userenv_lang
  ,p_information1                   in  varchar2  default hr_api.g_varchar2
  ,p_information2                   in  varchar2  default hr_api.g_varchar2
  ,p_information3                   in  varchar2  default hr_api.g_varchar2
  ,p_information4                   in  varchar2  default hr_api.g_varchar2
  ,p_information5                   in  varchar2  default hr_api.g_varchar2
  ,p_information6                   in  varchar2  default hr_api.g_varchar2
  ,p_information7                   in  varchar2  default hr_api.g_varchar2
  ,p_information8                   in  varchar2  default hr_api.g_varchar2
  ,p_information9                   in  varchar2  default hr_api.g_varchar2
  ,p_information10                  in  varchar2  default hr_api.g_varchar2
  ,p_information11                  in  varchar2  default hr_api.g_varchar2
  ,p_information12                  in  varchar2  default hr_api.g_varchar2
  ,p_information13                  in  varchar2  default hr_api.g_varchar2
  ,p_information14                  in  varchar2  default hr_api.g_varchar2
  ,p_information15                  in  varchar2  default hr_api.g_varchar2
  ,p_information16                  in  varchar2  default hr_api.g_varchar2
  ,p_information17                  in  varchar2  default hr_api.g_varchar2
  ,p_information18                  in  varchar2  default hr_api.g_varchar2
  ,p_information19                  in  varchar2  default hr_api.g_varchar2
  ,p_information20                  in  varchar2  default hr_api.g_varchar2
  ,p_information21                  in  varchar2  default hr_api.g_varchar2
  ,p_information22                  in  varchar2  default hr_api.g_varchar2
  ,p_information23                  in  varchar2  default hr_api.g_varchar2
  ,p_information24                  in  varchar2  default hr_api.g_varchar2
  ,p_information25                  in  varchar2  default hr_api.g_varchar2
  ,p_information26                  in  varchar2  default hr_api.g_varchar2
  ,p_information27                  in  varchar2  default hr_api.g_varchar2
  ,p_information28                  in  varchar2  default hr_api.g_varchar2
  ,p_information29                  in  varchar2  default hr_api.g_varchar2
  ,p_information30                  in  varchar2  default hr_api.g_varchar2
  ,p_information_category           in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_lookup_type                    in  varchar2  default hr_api.g_varchar2
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_shared_type';

Line: 408


  savepoint update_shared_type;

Line: 424


    per_shared_types_bk2.update_shared_type_b
      (
       p_shared_type_id                 =>  p_shared_type_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_shared_type_name               =>  p_shared_type_name
      ,p_shared_type_code               =>  p_shared_type_code
      ,p_system_type_cd                 =>  p_system_type_cd
      ,p_information1                   =>  p_information1
      ,p_information2                   =>  p_information2
      ,p_information3                   =>  p_information3
      ,p_information4                   =>  p_information4
      ,p_information5                   =>  p_information5
      ,p_information6                   =>  p_information6
      ,p_information7                   =>  p_information7
      ,p_information8                   =>  p_information8
      ,p_information9                   =>  p_information9
      ,p_information10                  =>  p_information10
      ,p_information11                  =>  p_information11
      ,p_information12                  =>  p_information12
      ,p_information13                  =>  p_information13
      ,p_information14                  =>  p_information14
      ,p_information15                  =>  p_information15
      ,p_information16                  =>  p_information16
      ,p_information17                  =>  p_information17
      ,p_information18                  =>  p_information18
      ,p_information19                  =>  p_information19
      ,p_information20                  =>  p_information20
      ,p_information21                  =>  p_information21
      ,p_information22                  =>  p_information22
      ,p_information23                  =>  p_information23
      ,p_information24                  =>  p_information24
      ,p_information25                  =>  p_information25
      ,p_information26                  =>  p_information26
      ,p_information27                  =>  p_information27
      ,p_information28                  =>  p_information28
      ,p_information29                  =>  p_information29
      ,p_information30                  =>  p_information30
      ,p_information_category           =>  p_information_category
      ,p_object_version_number          =>  p_object_version_number
      ,p_lookup_type                    =>  p_lookup_type
    ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 469


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

Line: 528


    per_shared_types_bk2.update_shared_type_a
      (
       p_shared_type_id                 =>  p_shared_type_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_shared_type_name               =>  p_shared_type_name
      ,p_shared_type_code               =>  p_shared_type_code
      ,p_system_type_cd                 =>  p_system_type_cd
      ,p_information1                   =>  p_information1
      ,p_information2                   =>  p_information2
      ,p_information3                   =>  p_information3
      ,p_information4                   =>  p_information4
      ,p_information5                   =>  p_information5
      ,p_information6                   =>  p_information6
      ,p_information7                   =>  p_information7
      ,p_information8                   =>  p_information8
      ,p_information9                   =>  p_information9
      ,p_information10                  =>  p_information10
      ,p_information11                  =>  p_information11
      ,p_information12                  =>  p_information12
      ,p_information13                  =>  p_information13
      ,p_information14                  =>  p_information14
      ,p_information15                  =>  p_information15
      ,p_information16                  =>  p_information16
      ,p_information17                  =>  p_information17
      ,p_information18                  =>  p_information18
      ,p_information19                  =>  p_information19
      ,p_information20                  =>  p_information20
      ,p_information21                  =>  p_information21
      ,p_information22                  =>  p_information22
      ,p_information23                  =>  p_information23
      ,p_information24                  =>  p_information24
      ,p_information25                  =>  p_information25
      ,p_information26                  =>  p_information26
      ,p_information27                  =>  p_information27
      ,p_information28                  =>  p_information28
      ,p_information29                  =>  p_information29
      ,p_information30                  =>  p_information30
      ,p_information_category           =>  p_information_category
      ,p_object_version_number          =>  l_object_version_number
      ,p_lookup_type                    =>  p_lookup_type
      ,p_effective_date                => trunc(p_effective_date)
      );

Line: 573


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

Line: 602


    ROLLBACK TO update_shared_type;

Line: 615


    ROLLBACK TO update_shared_type;

Line: 618


end update_shared_type;

Line: 623


procedure delete_shared_type
  (p_validate                       in  boolean  default false
  ,p_shared_type_id                 in  number
  ,p_object_version_number          in  number
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'delete_shared_type';

Line: 641


  savepoint delete_shared_type;

Line: 654


    per_shared_types_bk3.delete_shared_type_b
      (
       p_shared_type_id                 =>  p_shared_type_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 663


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

Line: 692


    per_shared_types_bk3.delete_shared_type_a
      (
       p_shared_type_id                 =>  p_shared_type_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 701


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

Line: 726


    ROLLBACK TO delete_shared_type;

Line: 737


    ROLLBACK TO delete_shared_type;

Line: 740


end delete_shared_type;