APPS.HR_CAL_ENTRY_VALUE_SWI SQL Statements

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

Line: 133

PROCEDURE delete_entry_value
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_cal_entry_value_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: 146

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

Line: 152

  savepoint delete_entry_value_swi;

Line: 172

  hr_cal_entry_value_api.delete_entry_value
    (p_validate                     => l_validate
    ,p_cal_entry_value_id           => p_cal_entry_value_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 199

    rollback to delete_entry_value_swi;

Line: 213

    rollback to delete_entry_value_swi;

Line: 223

end delete_entry_value;

Line: 227

PROCEDURE update_entry_value
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_cal_entry_value_id           in     number
  ,p_object_version_number        in out nocopy number
  ,p_override_name                in     varchar2  default hr_api.g_varchar2
  ,p_override_type                in     varchar2  default hr_api.g_varchar2
  ,p_parent_entry_value_id        in     number    default hr_api.g_number
  ,p_usage_flag                   in     varchar2  default hr_api.g_varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 246

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

Line: 252

  savepoint update_entry_value_swi;

Line: 273

  hr_cal_entry_value_api.update_entry_value
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_cal_entry_value_id           => p_cal_entry_value_id
    ,p_object_version_number        => p_object_version_number
    ,p_override_name                => p_override_name
    ,p_override_type                => p_override_type
    ,p_parent_entry_value_id        => p_parent_entry_value_id
    ,p_usage_flag                   => p_usage_flag
    );

Line: 305

    rollback to update_entry_value_swi;

Line: 320

    rollback to update_entry_value_swi;

Line: 331

end update_entry_value;