APPS.PQH_BDGT_POOL_REALLOCTIONS_SWI SQL Statements

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

Line: 235

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

Line: 248

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

Line: 254

  savepoint delete_realloc_txn_dtl_swi;

Line: 274

  pqh_bdgt_pool_realloctions_api.delete_realloc_txn_dtl
    (p_validate                     => l_validate
    ,p_txn_detail_id                => p_txn_detail_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 301

    rollback to delete_realloc_txn_dtl_swi;

Line: 315

    rollback to delete_realloc_txn_dtl_swi;

Line: 325

end delete_realloc_txn_dtl;

Line: 329

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

Line: 342

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

Line: 348

  savepoint delete_realloc_txn_period_swi;

Line: 368

  pqh_bdgt_pool_realloctions_api.delete_realloc_txn_period
    (p_validate                     => l_validate
    ,p_reallocation_period_id       => p_reallocation_period_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 395

    rollback to delete_realloc_txn_period_swi;

Line: 409

    rollback to delete_realloc_txn_period_swi;

Line: 419

end delete_realloc_txn_period;

Line: 423

PROCEDURE update_realloc_txn_dtl
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_transaction_id               in     number    default hr_api.g_number
  ,p_transaction_type             in     varchar2  default hr_api.g_varchar2
  ,p_entity_id                    in     number    default hr_api.g_number
  ,p_budget_detail_id             in     number    default hr_api.g_number
  ,p_txn_detail_id                in     number
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 442

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

Line: 448

  savepoint update_realloc_txn_dtl_swi;

Line: 469

  pqh_bdgt_pool_realloctions_api.update_realloc_txn_dtl
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_transaction_id               => p_transaction_id
    ,p_transaction_type             => p_transaction_type
    ,p_entity_id                    => p_entity_id
    ,p_budget_detail_id             => p_budget_detail_id
    ,p_txn_detail_id                => p_txn_detail_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 501

    rollback to update_realloc_txn_dtl_swi;

Line: 516

    rollback to update_realloc_txn_dtl_swi;

Line: 527

end update_realloc_txn_dtl;

Line: 531

PROCEDURE update_realloc_txn_period
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_txn_detail_id                in     number    default hr_api.g_number
  ,p_transaction_type             in     varchar2  default hr_api.g_varchar2
  ,p_entity_id                    in     number    default hr_api.g_number
  ,p_budget_period_id             in     number    default hr_api.g_number
  ,p_start_date                   in     date      default hr_api.g_date
  ,p_end_date                     in     date      default hr_api.g_date
  ,p_reallocation_amt             in     number    default hr_api.g_number
  ,p_reserved_amt                 in     number    default hr_api.g_number
  ,p_reallocation_period_id       in     number
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 554

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

Line: 560

  savepoint update_realloc_txn_period_swi;

Line: 581

  pqh_bdgt_pool_realloctions_api.update_realloc_txn_period
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_txn_detail_id                => p_txn_detail_id
    ,p_transaction_type             => p_transaction_type
    ,p_entity_id                    => p_entity_id
    ,p_budget_period_id             => p_budget_period_id
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    ,p_reallocation_amt             => p_reallocation_amt
    ,p_reserved_amt                 => p_reserved_amt
    ,p_reallocation_period_id       => p_reallocation_period_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 617

    rollback to update_realloc_txn_period_swi;

Line: 632

    rollback to update_realloc_txn_period_swi;

Line: 643

end update_realloc_txn_period;