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

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

Line: 276


procedure update_role
  (p_validate                       in  boolean
  ,p_role_id                        in  number
  ,p_role_name                      in  varchar2
  ,p_role_type_cd                   in  varchar2
  ,p_enable_flag                    in  varchar2
  ,p_object_version_number          in out nocopy number
  ,p_business_group_id              in  number
  ,p_effective_date                 in  date
  ,p_information_category           in varchar2
  ,p_information1                   in varchar2
  ,p_information2                   in varchar2
  ,p_information3                   in varchar2
  ,p_information4                   in varchar2
  ,p_information5                   in varchar2
  ,p_information6                   in varchar2
  ,p_information7                   in varchar2
  ,p_information8                   in varchar2
  ,p_information9                   in varchar2
  ,p_information10                  in varchar2
  ,p_information11                  in varchar2
  ,p_information12                  in varchar2
  ,p_information13                  in varchar2
  ,p_information14                  in varchar2
  ,p_information15                  in varchar2
  ,p_information16                  in varchar2
  ,p_information17                  in varchar2
  ,p_information18                  in varchar2
  ,p_information19                  in varchar2
  ,p_information20                  in varchar2
  ,p_information21                  in varchar2
  ,p_information22                  in varchar2
  ,p_information23                  in varchar2
  ,p_information24                  in varchar2
  ,p_information25                  in varchar2
  ,p_information26                  in varchar2
  ,p_information27                  in varchar2
  ,p_information28                  in varchar2
  ,p_information29                  in varchar2
  ,p_information30                  in varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_role';

Line: 329


  savepoint update_role;

Line: 341


    pqh_roles_bk2.update_role_b
      (
       p_role_id                        =>  p_role_id
      ,p_role_name                      =>  p_role_name
      ,p_role_type_cd                   =>  p_role_type_cd
      ,p_enable_flag                    =>  p_enable_flag
      ,p_object_version_number          =>  p_object_version_number
      ,p_business_group_id              =>  p_business_group_id
      ,p_effective_date                 => trunc(p_effective_date)
      ,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
      );

Line: 385


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

Line: 439


    pqh_roles_bk2.update_role_a
      (
       p_role_id                        =>  p_role_id
      ,p_role_name                      =>  p_role_name
      ,p_role_type_cd                   =>  p_role_type_cd
      ,p_enable_flag                    =>  p_enable_flag
      ,p_object_version_number          =>  l_object_version_number
      ,p_business_group_id              =>  p_business_group_id
      ,p_effective_date                => trunc(p_effective_date)
      ,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
      );

Line: 483


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

Line: 512


    ROLLBACK TO update_role;

Line: 525


    ROLLBACK TO update_role;

Line: 528


end update_role;

Line: 533


procedure delete_role
  (p_validate                       in  boolean
  ,p_role_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_role';

Line: 551


  savepoint delete_role;

Line: 564


    pqh_roles_bk3.delete_role_b
      (
       p_role_id                        =>  p_role_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 573


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

Line: 592


    pqh_roles_bk3.delete_role_a
      (
       p_role_id                        =>  p_role_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 601


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

Line: 626


    ROLLBACK TO delete_role;

Line: 637


    ROLLBACK TO delete_role;

Line: 640


end delete_role;