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

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

Line: 17


  ,p_delete_flag                    in  varchar2  default null
  ,p_assignment_id                  in  number    default null
  ,p_attribute_id                   in  number    default null
  ,p_from_char                      in  varchar2  default null
  ,p_from_date                      in  date      default null
  ,p_from_number                    in  number    default null
  ,p_position_id                    in  number    default null
  ,p_range_name                     in  varchar2
  ,p_routing_category_id            in  number
  ,p_routing_list_member_id         in  number    default null
  ,p_to_char                        in  varchar2  default null
  ,p_to_date                        in  date      default null
  ,p_to_number                      in  number    default null
  ,p_object_version_number          out nocopy number
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_attribute_range_id pqh_attribute_ranges.attribute_range_id%TYPE;

Line: 60


      ,p_delete_flag                  =>  p_delete_flag
      ,p_assignment_id                  =>  p_assignment_id
      ,p_attribute_id                   =>  p_attribute_id
      ,p_from_char                      =>  p_from_char
      ,p_from_date                      =>  p_from_date
      ,p_from_number                    =>  p_from_number
      ,p_position_id                    =>  p_position_id
      ,p_range_name                     =>  p_range_name
      ,p_routing_category_id            =>  p_routing_category_id
      ,p_routing_list_member_id         =>  p_routing_list_member_id
      ,p_to_char                        =>  p_to_char
      ,p_to_date                        =>  p_to_date
      ,p_to_number                      =>  p_to_number
      ,p_effective_date               => trunc(p_effective_date)
      );

Line: 92


      ,p_delete_flag                  =>  p_delete_flag
    ,p_assignment_id                 => p_assignment_id
    ,p_attribute_id                  => p_attribute_id
    ,p_from_char                     => p_from_char
    ,p_from_date                     => p_from_date
    ,p_from_number                   => p_from_number
    ,p_position_id                   => p_position_id
    ,p_range_name                    => p_range_name
    ,p_routing_category_id           => p_routing_category_id
    ,p_routing_list_member_id        => p_routing_list_member_id
    ,p_to_char                       => p_to_char
    ,p_to_date                       => p_to_date
    ,p_to_number                     => p_to_number
    ,p_object_version_number         => l_object_version_number
    ,p_effective_date                => trunc(p_effective_date)
    );

Line: 118


      ,p_delete_flag                  =>  p_delete_flag
      ,p_assignment_id                  =>  p_assignment_id
      ,p_attribute_id                   =>  p_attribute_id
      ,p_from_char                      =>  p_from_char
      ,p_from_date                      =>  p_from_date
      ,p_from_number                    =>  p_from_number
      ,p_position_id                    =>  p_position_id
      ,p_range_name                     =>  p_range_name
      ,p_routing_category_id            =>  p_routing_category_id
      ,p_routing_list_member_id         =>  p_routing_list_member_id
      ,p_to_char                        =>  p_to_char
      ,p_to_date                        =>  p_to_date
      ,p_to_number                      =>  p_to_number
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 191


procedure update_ATTRIBUTE_RANGE
  (p_validate                       in  boolean   default false
  ,p_attribute_range_id             in  number
  ,p_approver_flag                  in  varchar2  default hr_api.g_varchar2
  ,p_enable_flag                  in  varchar2  default hr_api.g_varchar2
  ,p_delete_flag                  in  varchar2  default hr_api.g_varchar2
  ,p_assignment_id                  in  number    default hr_api.g_number
  ,p_attribute_id                   in  number    default hr_api.g_number
  ,p_from_char                      in  varchar2  default hr_api.g_varchar2
  ,p_from_date                      in  date      default hr_api.g_date
  ,p_from_number                    in  number    default hr_api.g_number
  ,p_position_id                    in  number    default hr_api.g_number
  ,p_range_name                     in  varchar2  default hr_api.g_varchar2
  ,p_routing_category_id            in  number    default hr_api.g_number
  ,p_routing_list_member_id         in  number    default hr_api.g_number
  ,p_to_char                        in  varchar2  default hr_api.g_varchar2
  ,p_to_date                        in  date      default hr_api.g_date
  ,p_to_number                      in  number    default hr_api.g_number
  ,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_ATTRIBUTE_RANGE';

Line: 224


  savepoint update_ATTRIBUTE_RANGE;

Line: 236


    pqh_ATTRIBUTE_RANGES_bk2.update_ATTRIBUTE_RANGE_b
      (
       p_attribute_range_id             =>  p_attribute_range_id
      ,p_approver_flag                  =>  p_approver_flag
      ,p_enable_flag                  =>  p_enable_flag
      ,p_delete_flag                  =>  p_delete_flag
      ,p_assignment_id                  =>  p_assignment_id
      ,p_attribute_id                   =>  p_attribute_id
      ,p_from_char                      =>  p_from_char
      ,p_from_date                      =>  p_from_date
      ,p_from_number                    =>  p_from_number
      ,p_position_id                    =>  p_position_id
      ,p_range_name                     =>  p_range_name
      ,p_routing_category_id            =>  p_routing_category_id
      ,p_routing_list_member_id         =>  p_routing_list_member_id
      ,p_to_char                        =>  p_to_char
      ,p_to_date                        =>  p_to_date
      ,p_to_number                      =>  p_to_number
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 260


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

Line: 273


      ,p_delete_flag                  =>  p_delete_flag
    ,p_assignment_id                 => p_assignment_id
    ,p_attribute_id                  => p_attribute_id
    ,p_from_char                     => p_from_char
    ,p_from_date                     => p_from_date
    ,p_from_number                   => p_from_number
    ,p_position_id                   => p_position_id
    ,p_range_name                    => p_range_name
    ,p_routing_category_id           => p_routing_category_id
    ,p_routing_list_member_id        => p_routing_list_member_id
    ,p_to_char                       => p_to_char
    ,p_to_date                       => p_to_date
    ,p_to_number                     => p_to_number
    ,p_object_version_number         => l_object_version_number
    ,p_effective_date                => trunc(p_effective_date)
    );

Line: 294


    pqh_ATTRIBUTE_RANGES_bk2.update_ATTRIBUTE_RANGE_a
      (
       p_attribute_range_id             =>  p_attribute_range_id
      ,p_approver_flag                  =>  p_approver_flag
      ,p_enable_flag                  =>  p_enable_flag
      ,p_delete_flag                  =>  p_delete_flag
      ,p_assignment_id                  =>  p_assignment_id
      ,p_attribute_id                   =>  p_attribute_id
      ,p_from_char                      =>  p_from_char
      ,p_from_date                      =>  p_from_date
      ,p_from_number                    =>  p_from_number
      ,p_position_id                    =>  p_position_id
      ,p_range_name                     =>  p_range_name
      ,p_routing_category_id            =>  p_routing_category_id
      ,p_routing_list_member_id         =>  p_routing_list_member_id
      ,p_to_char                        =>  p_to_char
      ,p_to_date                        =>  p_to_date
      ,p_to_number                      =>  p_to_number
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                => trunc(p_effective_date)
      );

Line: 318


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

Line: 347


    ROLLBACK TO update_ATTRIBUTE_RANGE;

Line: 360


    ROLLBACK TO update_ATTRIBUTE_RANGE;

Line: 363


end update_ATTRIBUTE_RANGE;

Line: 368


procedure delete_ATTRIBUTE_RANGE
  (p_validate                       in  boolean  default false
  ,p_attribute_range_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_ATTRIBUTE_RANGE';

Line: 386


  savepoint delete_ATTRIBUTE_RANGE;

Line: 399


    pqh_ATTRIBUTE_RANGES_bk3.delete_ATTRIBUTE_RANGE_b
      (
       p_attribute_range_id             =>  p_attribute_range_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 408


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

Line: 427


    pqh_ATTRIBUTE_RANGES_bk3.delete_ATTRIBUTE_RANGE_a
      (
       p_attribute_range_id             =>  p_attribute_range_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 436


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

Line: 461


    ROLLBACK TO delete_ATTRIBUTE_RANGE;

Line: 472


    ROLLBACK TO delete_ATTRIBUTE_RANGE;

Line: 475


end delete_ATTRIBUTE_RANGE;