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

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

Line: 275


procedure update_copy_entity_attrib
  (p_validate                       in  boolean   default false
  ,p_copy_entity_attrib_id          in  number
  ,p_copy_entity_txn_id             in  number    default hr_api.g_number
  ,p_row_type_cd                    in  varchar2  default hr_api.g_varchar2
  ,p_information_category           in  varchar2  default hr_api.g_varchar2
  ,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_check_information1             in  varchar2  default hr_api.g_varchar2
  ,p_check_information2             in  varchar2  default hr_api.g_varchar2
  ,p_check_information3             in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_copy_entity_attrib';

Line: 329


  savepoint update_copy_entity_attrib;

Line: 341


    pqh_copy_entity_attribs_bk2.update_copy_entity_attrib_b
      (
       p_copy_entity_attrib_id          =>  p_copy_entity_attrib_id
      ,p_copy_entity_txn_id             =>  p_copy_entity_txn_id
      ,p_row_type_cd                    =>  p_row_type_cd
      ,p_information_category           =>  p_information_category
      ,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_check_information1             =>  p_check_information1
      ,p_check_information2             =>  p_check_information2
      ,p_check_information3             =>  p_check_information3
      ,p_object_version_number          =>  p_object_version_number
      ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 386


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

Line: 441


    pqh_copy_entity_attribs_bk2.update_copy_entity_attrib_a
      (
       p_copy_entity_attrib_id          =>  p_copy_entity_attrib_id
      ,p_copy_entity_txn_id             =>  p_copy_entity_txn_id
      ,p_row_type_cd                    =>  p_row_type_cd
      ,p_information_category           =>  p_information_category
      ,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_check_information1             =>  p_check_information1
      ,p_check_information2             =>  p_check_information2
      ,p_check_information3             =>  p_check_information3
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 486


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

Line: 515


    ROLLBACK TO update_copy_entity_attrib;

Line: 528


    ROLLBACK TO update_copy_entity_attrib;

Line: 531


end update_copy_entity_attrib;

Line: 536


procedure delete_copy_entity_attrib
  (p_validate                       in  boolean  default false
  ,p_copy_entity_attrib_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_copy_entity_attrib';

Line: 554


  savepoint delete_copy_entity_attrib;

Line: 567


    pqh_copy_entity_attribs_bk3.delete_copy_entity_attrib_b
      (
       p_copy_entity_attrib_id          =>  p_copy_entity_attrib_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 576


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

Line: 595


    pqh_copy_entity_attribs_bk3.delete_copy_entity_attrib_a
      (
       p_copy_entity_attrib_id          =>  p_copy_entity_attrib_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 604


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

Line: 629


    ROLLBACK TO delete_copy_entity_attrib;

Line: 640


    ROLLBACK TO delete_copy_entity_attrib;

Line: 643


end delete_copy_entity_attrib;