APPS.BEN_ELIG_OBJ_ELIG_PROFL_SWI SQL Statements

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

Line: 149

procedure update_ELIG_OBJ_ELIG_PROFL
  (p_validate                       in  number   default hr_api.g_false_num
  ,p_elig_obj_elig_prfl_id          in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_elig_obj_id                    in  number    default hr_api.g_number
  ,p_elig_prfl_id                   in  number    default hr_api.g_number
  ,p_mndtry_flag                    in  varchar2  default 'N'
  ,p_bep_attribute_category         in  varchar2  default hr_api.g_varchar2
  ,p_bep_attribute1                 in  varchar2  default hr_api.g_varchar2
  ,p_bep_attribute2                 in  varchar2  default hr_api.g_varchar2
  ,p_bep_attribute3                 in  varchar2  default hr_api.g_varchar2
  ,p_bep_attribute4                 in  varchar2  default hr_api.g_varchar2
  ,p_bep_attribute5                 in  varchar2  default hr_api.g_varchar2
  ,p_bep_attribute6                 in  varchar2  default hr_api.g_varchar2
  ,p_bep_attribute7                 in  varchar2  default hr_api.g_varchar2
  ,p_bep_attribute8                 in  varchar2  default hr_api.g_varchar2
  ,p_bep_attribute9                 in  varchar2  default hr_api.g_varchar2
  ,p_bep_attribute10                in  varchar2  default hr_api.g_varchar2
  ,p_bep_attribute11                in  varchar2  default hr_api.g_varchar2
  ,p_bep_attribute12                in  varchar2  default hr_api.g_varchar2
  ,p_bep_attribute13                in  varchar2  default hr_api.g_varchar2
  ,p_bep_attribute14                in  varchar2  default hr_api.g_varchar2
  ,p_bep_attribute15                in  varchar2  default hr_api.g_varchar2
  ,p_bep_attribute16                in  varchar2  default hr_api.g_varchar2
  ,p_bep_attribute17                in  varchar2  default hr_api.g_varchar2
  ,p_bep_attribute18                in  varchar2  default hr_api.g_varchar2
  ,p_bep_attribute19                in  varchar2  default hr_api.g_varchar2
  ,p_bep_attribute20                in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ,p_return_status                  out nocopy varchar2
  ) is
   --

   --Variables for API Boolean parameters
  l_validate boolean;

Line: 192

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

Line: 202

  savepoint update_ELIG_OBJ_ELIG_PROFL;

Line: 211

  ben_elig_obj_elig_profl_api.update_ELIG_OBJ_ELIG_PROFL
  (p_validate                 => l_validate
  ,p_elig_obj_elig_prfl_id    => p_elig_obj_elig_prfl_id
  ,p_effective_start_date     => p_effective_start_date
  ,p_effective_end_date       => p_effective_end_date
  ,p_business_group_id        => p_business_group_id
  ,p_elig_obj_id              => p_elig_obj_id
  ,p_elig_prfl_id             => p_elig_prfl_id
  ,p_mndtry_flag              => p_mndtry_flag
  ,p_bep_attribute_category   => p_bep_attribute_category
  ,p_bep_attribute1           => p_bep_attribute1
  ,p_bep_attribute2           => p_bep_attribute2
  ,p_bep_attribute3           => p_bep_attribute3
  ,p_bep_attribute4           => p_bep_attribute4
  ,p_bep_attribute5           => p_bep_attribute5
  ,p_bep_attribute6           => p_bep_attribute6
  ,p_bep_attribute7           => p_bep_attribute7
  ,p_bep_attribute8           =>p_bep_attribute8
  ,p_bep_attribute9           =>p_bep_attribute9
  ,p_bep_attribute10          =>p_bep_attribute10
  ,p_bep_attribute11          =>p_bep_attribute11
  ,p_bep_attribute12          =>p_bep_attribute12
  ,p_bep_attribute13          =>p_bep_attribute13
  ,p_bep_attribute14          =>p_bep_attribute14
  ,p_bep_attribute15          =>p_bep_attribute15
  ,p_bep_attribute16          =>p_bep_attribute16
  ,p_bep_attribute17          =>p_bep_attribute17
  ,p_bep_attribute18          =>p_bep_attribute18
  ,p_bep_attribute19          =>p_bep_attribute19
  ,p_bep_attribute20          =>p_bep_attribute20
  ,p_object_version_number    => p_object_version_number
  ,p_effective_date           => p_effective_date
  ,p_datetrack_mode           =>p_datetrack_mode);

Line: 276

  end update_ELIG_OBJ_ELIG_PROFL;

Line: 282

procedure delete_ELIG_OBJ_ELIG_PROFL
  (p_validate                       in  number default hr_api.g_false_num
  ,p_elig_obj_elig_prfl_id          in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ,p_return_status                  out nocopy varchar2
  ) is
    --

   --Variables for API Boolean parameters
  l_validate boolean;

Line: 303

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

Line: 314

  savepoint delete_ELIG_OBJ_ELIG_PROFL;

Line: 324

  ben_elig_obj_elig_profl_api.delete_ELIG_OBJ_ELIG_PROFL
  (p_validate                  => l_validate
  ,p_elig_obj_elig_prfl_id     => p_elig_obj_elig_prfl_id
  ,p_effective_start_date      => p_effective_start_date
  ,p_effective_end_date        => p_effective_end_date
  ,p_object_version_number     => p_object_version_number
  ,p_effective_date            => l_effective_date
  ,p_datetrack_mode            => p_datetrack_mode);

Line: 339

   rollback to delete_ELIG_OBJ_ELIG_PROFL;

Line: 352

   rollback to delete_ELIG_OBJ_ELIG_PROFL;

Line: 364

  end delete_ELIG_OBJ_ELIG_PROFL;