APPS.AME_TRANS_TYPE_SWI SQL Statements

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

Line: 125

PROCEDURE update_ame_transaction_type
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_application_name             in     varchar2  default hr_api.g_varchar2
  ,p_transaction_type_id          in     varchar2  default hr_api.g_varchar2
  ,p_application_id               in     number
  ,p_object_version_number        in out nocopy number
  ,p_start_date                      out nocopy date
  ,p_end_date                        out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 143

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

Line: 149

  savepoint update_ame_txn_type_swi;

Line: 170

  ame_trans_type_api.update_ame_transaction_type
    (p_validate                     => l_validate
    ,p_application_name             => p_application_name
    ,p_application_id               => p_application_id
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 200

    rollback to update_ame_txn_type_swi;

Line: 217

    rollback to update_ame_txn_type_swi;

Line: 230

end update_ame_transaction_type;

Line: 234

PROCEDURE delete_ame_transaction_type
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_application_id               in     number
  ,p_object_version_number        in out nocopy number
  ,p_start_date                      out nocopy date
  ,p_end_date                        out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 250

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

Line: 256

  savepoint delete_ame_txn_type_swi;

Line: 277

  ame_trans_type_api.delete_ame_transaction_type
    (p_validate                     => l_validate
    ,p_application_id               => p_application_id
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 306

    rollback to delete_ame_txn_type_swi;

Line: 323

    rollback to delete_ame_txn_type_swi;

Line: 336

end delete_ame_transaction_type;