APPS.BEN_BATCH_RANGES_API SQL Statements

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

Line: 98

procedure update_batch_ranges
  (p_validate                       in boolean   default false
  ,p_range_id                       in number
  ,p_benefit_action_id              in number    default hr_api.g_number
  ,p_range_status_cd                in varchar2  default hr_api.g_varchar2
  ,p_starting_person_action_id      in number    default hr_api.g_number
  ,p_ending_person_action_id        in number    default hr_api.g_number
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in date) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'update_batch_ranges';

Line: 119

  savepoint update_batch_ranges;

Line: 157

    ROLLBACK TO update_batch_ranges;

Line: 169

    ROLLBACK TO update_batch_ranges;

Line: 172

end update_batch_ranges;

Line: 177

procedure delete_batch_ranges
  (p_validate                       in boolean  default false
  ,p_range_id                       in number
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in date) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_batch_ranges';

Line: 194

  savepoint delete_batch_ranges;

Line: 224

    ROLLBACK TO delete_batch_ranges;

Line: 235

    ROLLBACK TO delete_batch_ranges;

Line: 238

end delete_batch_ranges;