APPS.PQH_COPY_ENTITY_TXNS_SWI SQL Statements

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

Line: 137

PROCEDURE delete_copy_entity_txn
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_copy_entity_txn_id           in     number
  ,p_object_version_number        in     number
  ,p_effective_date               in     date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 151

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

Line: 157

  savepoint delete_copy_entity_txn_swi;

Line: 177

  pqh_copy_entity_txns_api.delete_copy_entity_txn
    (p_validate                     => l_validate
    ,p_copy_entity_txn_id           => p_copy_entity_txn_id
    ,p_object_version_number        => p_object_version_number
    ,p_effective_date               => p_effective_date
    );

Line: 205

    rollback to delete_copy_entity_txn_swi;

Line: 219

    rollback to delete_copy_entity_txn_swi;

Line: 229

end delete_copy_entity_txn;

Line: 233

PROCEDURE update_copy_entity_txn
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_copy_entity_txn_id           in     number
  ,p_transaction_category_id      in     number    default hr_api.g_number
  ,p_txn_category_attribute_id    in     number    default hr_api.g_number
  ,p_context_business_group_id    in     number    default hr_api.g_number
  ,p_datetrack_mode               in     varchar2  default hr_api.g_varchar2
  ,p_context                      in     varchar2  default hr_api.g_varchar2
  ,p_action_date                  in     date      default hr_api.g_date
  ,p_src_effective_date           in     date      default hr_api.g_date
  ,p_number_of_copies             in     number    default hr_api.g_number
  ,p_display_name                 in     varchar2  default hr_api.g_varchar2
  ,p_replacement_type_cd          in     varchar2  default hr_api.g_varchar2
  ,p_start_with                   in     varchar2  default hr_api.g_varchar2
  ,p_increment_by                 in     number    default hr_api.g_number
  ,p_status                       in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number        in out nocopy number
  ,p_effective_date               in     date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 261

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

Line: 267

  savepoint update_copy_entity_txn_swi;

Line: 288

  pqh_copy_entity_txns_api.update_copy_entity_txn
    (p_validate                     => l_validate
    ,p_copy_entity_txn_id           => p_copy_entity_txn_id
    ,p_transaction_category_id      => p_transaction_category_id
    ,p_txn_category_attribute_id    => p_txn_category_attribute_id
    ,p_context_business_group_id    => p_context_business_group_id
    ,p_datetrack_mode               => p_datetrack_mode
    ,p_context                      => p_context
    ,p_action_date                  => p_action_date
    ,p_src_effective_date           => p_src_effective_date
    ,p_number_of_copies             => p_number_of_copies
    ,p_display_name                 => p_display_name
    ,p_replacement_type_cd          => p_replacement_type_cd
    ,p_start_with                   => p_start_with
    ,p_increment_by                 => p_increment_by
    ,p_status                       => p_status
    ,p_object_version_number        => p_object_version_number
    ,p_effective_date               => p_effective_date
    );

Line: 329

    rollback to update_copy_entity_txn_swi;

Line: 344

    rollback to update_copy_entity_txn_swi;

Line: 355

end update_copy_entity_txn;