APPS.PAY_GROSSUP_BAL_EXCL_API SQL Statements

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

Line: 120

procedure update_grossup_bal
(
   p_validate                     in     boolean default false
  ,p_grossup_balances_id          in     number
  ,p_object_version_number        in out nocopy number
  ,p_start_date                   in     date      default hr_api.g_date
  ,p_end_date                     in     date      default hr_api.g_date
  ,p_source_id                    in     number    default hr_api.g_number
  ,p_source_type                  in     varchar2  default hr_api.g_varchar2
  ,p_balance_type_id              in     number    default hr_api.g_number
) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'update_grossup_bal.';

Line: 144

    savepoint update_grossup_bal;

Line: 176

    ROLLBACK TO update_grossup_bal;

Line: 178

end update_grossup_bal;

Line: 205

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

Line: 223

    savepoint delete_grossup_bal;

Line: 247

    ROLLBACK TO delete_grossup_bal;

Line: 249

end delete_grossup_bal;

Line: 284

  l_proc                  varchar2(72) := g_package||'update_grossup_bal.';