APPS.PQH_WORKSHEETS_API SQL Statements

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

Line: 175

procedure update_WORKSHEET
  (p_validate                       in  boolean   default false
  ,p_worksheet_id                   in  number
  ,p_budget_id                      in  number    default hr_api.g_number
  ,p_worksheet_name                 in  varchar2  default hr_api.g_varchar2
  ,p_version_number                 in  number    default hr_api.g_number
  ,p_action_date                    in  date      default hr_api.g_date
  ,p_date_from                      in  date      default hr_api.g_date
  ,p_date_to                        in  date      default hr_api.g_date
  ,p_worksheet_mode_cd              in  varchar2  default hr_api.g_varchar2
  ,p_transaction_status             in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_budget_version_id              in  number    default hr_api.g_number
  ,p_propagation_method             in  varchar2  default hr_api.g_varchar2
  ,p_effective_date                 in  date
  ,p_wf_transaction_category_id     in  number    default hr_api.g_number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_WORKSHEET';

Line: 204

  savepoint update_WORKSHEET;

Line: 216

    pqh_WORKSHEETS_bk2.update_WORKSHEET_b
      (
       p_worksheet_id                   =>  p_worksheet_id
      ,p_budget_id                      =>  p_budget_id
      ,p_worksheet_name                 =>  p_worksheet_name
      ,p_version_number                 =>  p_version_number
      ,p_action_date                    =>  p_action_date
      ,p_date_from                      =>  p_date_from
      ,p_date_to                        =>  p_date_to
      ,p_worksheet_mode_cd              =>  p_worksheet_mode_cd
      ,p_transaction_status             =>  p_transaction_status
      ,p_object_version_number          =>  p_object_version_number
      ,p_budget_version_id              =>  p_budget_version_id
      ,p_propagation_method             =>  p_propagation_method
      ,p_effective_date                 =>  trunc(p_effective_date)
      ,p_wf_transaction_category_id     =>  p_wf_transaction_category_id
      );

Line: 236

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

Line: 266

    pqh_WORKSHEETS_bk2.update_WORKSHEET_a
      (
       p_worksheet_id                   =>  p_worksheet_id
      ,p_budget_id                      =>  p_budget_id
      ,p_worksheet_name                 =>  p_worksheet_name
      ,p_version_number                 =>  p_version_number
      ,p_action_date                    =>  p_action_date
      ,p_date_from                      =>  p_date_from
      ,p_date_to                        =>  p_date_to
      ,p_worksheet_mode_cd              =>  p_worksheet_mode_cd
      ,p_transaction_status             =>  p_transaction_status
      ,p_object_version_number          =>  l_object_version_number
      ,p_budget_version_id              =>  p_budget_version_id
      ,p_propagation_method             =>  p_propagation_method
      ,p_effective_date                 =>  trunc(p_effective_date)
      ,p_wf_transaction_category_id     =>  p_wf_transaction_category_id
      );

Line: 286

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

Line: 315

    ROLLBACK TO update_WORKSHEET;

Line: 328

    ROLLBACK TO update_WORKSHEET;

Line: 331

end update_WORKSHEET;

Line: 336

procedure delete_WORKSHEET
  (p_validate                       in  boolean  default false
  ,p_worksheet_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_WORKSHEET';

Line: 354

  savepoint delete_WORKSHEET;

Line: 367

    pqh_WORKSHEETS_bk3.delete_WORKSHEET_b
      (
       p_worksheet_id                   =>  p_worksheet_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 376

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

Line: 395

    pqh_WORKSHEETS_bk3.delete_WORKSHEET_a
      (
       p_worksheet_id                   =>  p_worksheet_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 404

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

Line: 429

    ROLLBACK TO delete_WORKSHEET;

Line: 440

    ROLLBACK TO delete_WORKSHEET;

Line: 443

end delete_WORKSHEET;