APPS.HR_CAGR_PARAMETER_API SQL Statements

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

Line: 118

procedure update_cagr_parameter
  (p_validate                       in     boolean   default false
  ,p_effective_date                 in     date
  ,p_cagr_api_param_id              in     number
  ,p_cagr_api_id                    in     number    default hr_api.g_number
  ,p_display_name                   in     varchar2  default hr_api.g_varchar2
  ,p_parameter_name                 in     varchar2  default hr_api.g_varchar2
  ,p_column_type                    in     varchar2  default hr_api.g_varchar2
  ,p_column_size                    in     number    default hr_api.g_number
  ,p_uom_parameter                  in     varchar2  default hr_api.g_varchar2
  ,p_uom_lookup                     in     varchar2  default hr_api.g_varchar2
  ,p_default_uom                    in     varchar2  default hr_api.g_varchar2
  ,p_hidden                         in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'update_cagr_parameter';

Line: 147

  savepoint update_cagr_parameter;

Line: 197

    ROLLBACK TO update_cagr_parameter;

Line: 209

    ROLLBACK TO update_cagr_parameter;

Line: 217

end update_cagr_parameter;

Line: 222

procedure delete_cagr_parameter
  (
   p_cagr_api_param_id              in     number
  ,p_validate                       in     boolean  default false
  ,p_object_version_number          in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_cagr_parameter';

Line: 240

  savepoint delete_cagr_parameter;

Line: 271

    ROLLBACK TO delete_cagr_parameter;

Line: 282

    ROLLBACK TO delete_cagr_parameter;

Line: 289

end delete_cagr_parameter;