APPS.HR_API_HOOK_INTERNAL SQL Statements

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

Line: 37

     select api_hook_id from hr_api_hooks hah
     where hah.hook_package = p_hook_package
     and   hah.hook_procedure = p_hook_procedure;

Line: 126

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

Line: 138

    savepoint delete_api_hook;

Line: 167

    ROLLBACK TO delete_api_hook;

Line: 169

end delete_api_hook;

Line: 175

procedure update_api_hook
  (p_validate                     in     boolean      default false,
   p_effective_date               in     date,
   p_api_hook_id                  in     number,
   p_api_hook_type                in     varchar2     default hr_api.g_varchar2,
   p_hook_package                 in     varchar2     default hr_api.g_varchar2,
   p_hook_procedure               in     varchar2     default hr_api.g_varchar2,
   p_legislation_package          in     varchar2     default hr_api.g_varchar2,
   p_legislation_function         in     varchar2     default hr_api.g_varchar2
  )
is
  --
  -- Declare cursors and local variables
  --
  l_effective_date      date;

Line: 195

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

Line: 208

    savepoint update_api_hook;

Line: 244

    ROLLBACK TO update_api_hook;

Line: 246

end update_api_hook;