APPS.HR_API_HOOK_CALL_API SQL Statements

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

Line: 125

procedure delete_api_hook_call
  (p_validate                           in     boolean  default false,
   p_api_hook_call_id                   in     number,
   p_object_version_number              in     number
  )  is
  --
  l_proc                   varchar2(72) := g_package||'delete_api_hook_call';

Line: 137

     Select legislation_code
     from   hr_api_hook_calls
     where api_hook_call_id = p_api_hook_call_id;

Line: 147

    savepoint delete_api_hook_call;

Line: 183

    ROLLBACK TO delete_api_hook_call;

Line: 184

end delete_api_hook_call;

Line: 190

procedure update_api_hook_call
  (p_validate                     in     boolean  default false,
   p_effective_date               in     date,
   p_api_hook_call_id             in     number,
   p_sequence                     in     number    default hr_api.g_number,
   p_enabled_flag                 in     varchar2  default hr_api.g_varchar2,
   p_call_package                 in     varchar2  default hr_api.g_varchar2,
   p_call_procedure               in     varchar2  default hr_api.g_varchar2,
   p_object_version_number        in out nocopy    number
  ) is
  --
  l_proc                   varchar2(72) := g_package||'update_api_hook_call';

Line: 214

     Select legislation_code
     from   hr_api_hook_calls
     where api_hook_call_id = p_api_hook_call_id;

Line: 233

    savepoint update_api_hook_call;

Line: 284

    ROLLBACK TO update_api_hook_call;

Line: 289

    ROLLBACK TO update_api_hook_call;

Line: 292

end update_api_hook_call;