APPS.PQH_ROUTING_HIST_ATTRIB_API SQL Statements

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

Line: 179

procedure update_routing_hist_attrib
  (p_validate                       in  boolean   default false
  ,p_routing_hist_attrib_id         in  number
  ,p_routing_history_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_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_range_type_cd                  in  varchar2  default hr_api.g_varchar2
  ,p_value_date                     in  date      default hr_api.g_date
  ,p_value_number                   in  number    default hr_api.g_number
  ,p_value_char                     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_routing_hist_attrib';

Line: 209

  savepoint update_routing_hist_attrib;

Line: 221

    pqh_routing_hist_attrib_bk2.update_routing_hist_attrib_b
      (
       p_routing_hist_attrib_id         =>  p_routing_hist_attrib_id
      ,p_routing_history_id             =>  p_routing_history_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_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_range_type_cd                  =>  p_range_type_cd
      ,p_value_date                     =>  p_value_date
      ,p_value_number                   =>  p_value_number
      ,p_value_char                     =>  p_value_char
    ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 242

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

Line: 273

    pqh_routing_hist_attrib_bk2.update_routing_hist_attrib_a
      (
       p_routing_hist_attrib_id         =>  p_routing_hist_attrib_id
      ,p_routing_history_id             =>  p_routing_history_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_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_range_type_cd                  =>  p_range_type_cd
      ,p_value_date                     =>  p_value_date
      ,p_value_number                   =>  p_value_number
      ,p_value_char                     =>  p_value_char
      ,p_effective_date                => trunc(p_effective_date)
      );

Line: 294

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

Line: 323

    ROLLBACK TO update_routing_hist_attrib;

Line: 336

    ROLLBACK TO update_routing_hist_attrib;

Line: 339

end update_routing_hist_attrib;

Line: 344

procedure delete_routing_hist_attrib
  (p_validate                       in  boolean  default false
  ,p_routing_hist_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_routing_hist_attrib';

Line: 362

  savepoint delete_routing_hist_attrib;

Line: 375

    pqh_routing_hist_attrib_bk3.delete_routing_hist_attrib_b
      (
       p_routing_hist_attrib_id         =>  p_routing_hist_attrib_id
      ,p_object_version_number          =>  p_object_version_number
      ,p_effective_date                 =>  trunc(p_effective_date)
      );

Line: 384

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

Line: 402

    pqh_routing_hist_attrib_bk3.delete_routing_hist_attrib_a
      (
       p_routing_hist_attrib_id         =>  p_routing_hist_attrib_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 411

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

Line: 436

    ROLLBACK TO delete_routing_hist_attrib;

Line: 447

    ROLLBACK TO delete_routing_hist_attrib;

Line: 450

end delete_routing_hist_attrib;