APPS.PQH_COPY_ENTITY_CONTEXTS_API SQL Statements

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

Line: 142

procedure update_copy_entity_context
  (p_validate                       in  boolean   default false
  ,p_context                        in  varchar2
  ,p_application_short_name         in  varchar2  default hr_api.g_varchar2
  ,p_legislation_code               in  varchar2  default hr_api.g_varchar2
  ,p_responsibility_key             in  varchar2  default hr_api.g_varchar2
  ,p_transaction_short_name         in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_copy_entity_context';

Line: 163

  savepoint update_copy_entity_context;

Line: 175

    pqh_copy_entity_contexts_bk2.update_copy_entity_context_b
      (
       p_context                        =>  p_context
      ,p_application_short_name         =>  p_application_short_name
      ,p_legislation_code               =>  p_legislation_code
      ,p_responsibility_key             =>  p_responsibility_key
      ,p_transaction_short_name         =>  p_transaction_short_name
      ,p_object_version_number          =>  p_object_version_number
      );

Line: 187

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

Line: 209

    pqh_copy_entity_contexts_bk2.update_copy_entity_context_a
      (
       p_context                        =>  p_context
      ,p_application_short_name         =>  p_application_short_name
      ,p_legislation_code               =>  p_legislation_code
      ,p_responsibility_key             =>  p_responsibility_key
      ,p_transaction_short_name         =>  p_transaction_short_name
      ,p_object_version_number          =>  l_object_version_number
      );

Line: 221

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

Line: 250

    ROLLBACK TO update_copy_entity_context;

Line: 263

    ROLLBACK TO update_copy_entity_context;

Line: 266

end update_copy_entity_context;

Line: 271

procedure delete_copy_entity_context
  (p_validate                       in  boolean  default false
  ,p_context                        in  varchar2
  ,p_object_version_number          in number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'delete_copy_entity_context';

Line: 288

  savepoint delete_copy_entity_context;

Line: 301

    pqh_copy_entity_contexts_bk3.delete_copy_entity_context_b
      (
       p_context                        =>  p_context
      ,p_object_version_number          =>  p_object_version_number
      );

Line: 309

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

Line: 327

    pqh_copy_entity_contexts_bk3.delete_copy_entity_context_a
      (
       p_context                        =>  p_context
      ,p_object_version_number          =>  l_object_version_number
      );

Line: 335

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

Line: 360

    ROLLBACK TO delete_copy_entity_context;

Line: 371

    ROLLBACK TO delete_copy_entity_context;

Line: 374

end delete_copy_entity_context;