APPS.PQH_ROUTING_HISTORY_API SQL Statements

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

Line: 215

procedure update_routing_history
  (p_validate                       in  boolean   default false
  ,p_routing_history_id             in  number
  ,p_approval_cd                    in  varchar2  default hr_api.g_varchar2
  ,p_comments                       in  varchar2  default hr_api.g_varchar2
  ,p_forwarded_by_assignment_id     in  number    default hr_api.g_number
  ,p_forwarded_by_member_id         in  number    default hr_api.g_number
  ,p_forwarded_by_position_id       in  number    default hr_api.g_number
  ,p_forwarded_by_user_id           in  number    default hr_api.g_number
  ,p_forwarded_by_role_id           in  number    default hr_api.g_number
  ,p_forwarded_to_assignment_id     in  number    default hr_api.g_number
  ,p_forwarded_to_member_id         in  number    default hr_api.g_number
  ,p_forwarded_to_position_id       in  number    default hr_api.g_number
  ,p_forwarded_to_user_id           in  number    default hr_api.g_number
  ,p_forwarded_to_role_id           in  number    default hr_api.g_number
  ,p_notification_date              in  date      default hr_api.g_date
  ,p_pos_structure_version_id       in  number    default hr_api.g_number
  ,p_routing_category_id            in  number    default hr_api.g_number
  ,p_transaction_category_id        in  number    default hr_api.g_number
  ,p_transaction_id                 in  number    default hr_api.g_number
  ,p_user_action_cd                 in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_from_range_name                in  varchar2  default hr_api.g_varchar2
  ,p_to_range_name                  in  varchar2  default hr_api.g_varchar2
  ,p_list_range_name                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_history';

Line: 254

  savepoint update_routing_history;

Line: 266

    pqh_routing_history_bk2.update_routing_history_b
      (
       p_routing_history_id             =>  p_routing_history_id
      ,p_approval_cd                    =>  p_approval_cd
      ,p_comments                       =>  p_comments
      ,p_forwarded_by_assignment_id     =>  p_forwarded_by_assignment_id
      ,p_forwarded_by_member_id         =>  p_forwarded_by_member_id
      ,p_forwarded_by_position_id       =>  p_forwarded_by_position_id
      ,p_forwarded_by_user_id           =>  p_forwarded_by_user_id
      ,p_forwarded_by_role_id           =>  p_forwarded_by_role_id
      ,p_forwarded_to_assignment_id     =>  p_forwarded_to_assignment_id
      ,p_forwarded_to_member_id         =>  p_forwarded_to_member_id
      ,p_forwarded_to_position_id       =>  p_forwarded_to_position_id
      ,p_forwarded_to_user_id           =>  p_forwarded_to_user_id
      ,p_forwarded_to_role_id           =>  p_forwarded_to_role_id
      ,p_notification_date              =>  p_notification_date
      ,p_pos_structure_version_id       =>  p_pos_structure_version_id
      ,p_routing_category_id            =>  p_routing_category_id
      ,p_transaction_category_id        =>  p_transaction_category_id
      ,p_transaction_id                 =>  p_transaction_id
      ,p_user_action_cd                 =>  p_user_action_cd
      ,p_object_version_number          =>  p_object_version_number
      ,p_from_range_name                =>  p_from_range_name
      ,p_to_range_name                  =>  p_to_range_name
      ,p_list_range_name                =>  p_list_range_name
    ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 296

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

Line: 336

    pqh_routing_history_bk2.update_routing_history_a
      (
       p_routing_history_id             =>  p_routing_history_id
      ,p_approval_cd                    =>  p_approval_cd
      ,p_comments                       =>  p_comments
      ,p_forwarded_by_assignment_id     =>  p_forwarded_by_assignment_id
      ,p_forwarded_by_member_id         =>  p_forwarded_by_member_id
      ,p_forwarded_by_position_id       =>  p_forwarded_by_position_id
      ,p_forwarded_by_user_id           =>  p_forwarded_by_user_id
      ,p_forwarded_by_role_id           =>  p_forwarded_by_role_id
      ,p_forwarded_to_assignment_id     =>  p_forwarded_to_assignment_id
      ,p_forwarded_to_member_id         =>  p_forwarded_to_member_id
      ,p_forwarded_to_position_id       =>  p_forwarded_to_position_id
      ,p_forwarded_to_user_id           =>  p_forwarded_to_user_id
      ,p_forwarded_to_role_id           =>  p_forwarded_to_role_id
      ,p_notification_date              =>  p_notification_date
      ,p_pos_structure_version_id       =>  p_pos_structure_version_id
      ,p_routing_category_id            =>  p_routing_category_id
      ,p_transaction_category_id        =>  p_transaction_category_id
      ,p_transaction_id                 =>  p_transaction_id
      ,p_user_action_cd                 =>  p_user_action_cd
      ,p_object_version_number          =>  l_object_version_number
      ,p_from_range_name                =>  p_from_range_name
      ,p_to_range_name                  =>  p_to_range_name
      ,p_list_range_name                =>  p_list_range_name
      ,p_effective_date                => trunc(p_effective_date)
      );

Line: 366

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

Line: 395

    ROLLBACK TO update_routing_history;

Line: 408

    ROLLBACK TO update_routing_history;

Line: 411

end update_routing_history;

Line: 416

procedure delete_routing_history
  (p_validate                       in  boolean  default false
  ,p_routing_history_id             in  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_routing_history';

Line: 434

  savepoint delete_routing_history;

Line: 447

    pqh_routing_history_bk3.delete_routing_history_b
      (
       p_routing_history_id             =>  p_routing_history_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 456

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

Line: 467

    delete from pqh_routing_hist_attribs
    where routing_history_id = p_routing_history_id;

Line: 484

    pqh_routing_history_bk3.delete_routing_history_a
      (
       p_routing_history_id             =>  p_routing_history_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 493

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

Line: 518

    ROLLBACK TO delete_routing_history;

Line: 529

    ROLLBACK TO delete_routing_history;

Line: 532

end delete_routing_history;

Line: 598

  This procedure will call the create_routing_history API and then insert records into
  pqh_routing_hist_attribs by calling create_routing_hist_attrib API in loop
*/


l_proc                         varchar2(72) := g_package||'create_routing_history_bp';

Line: 655

        hr_utility.set_location(' Inserting Into pqh_routing_hist_attribs: '||l_proc, 5);

Line: 679

        hr_utility.set_location(' Done Inserting Into pqh_routing_hist_attribs: '||l_routing_hist_attrib_id, 7);