APPS.HR_APP_API_HOOK_CALL_INTERNAL SQL Statements

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

Line: 48

   select api_hook_call_id, object_version_number
     from hr_api_hook_calls
   where api_hook_id = p_api_hook_id
   and   nvl(application_id,hr_api.g_number)
       = nvl(p_application_id,hr_api.g_number)
   and   nvl(call_package, hr_api.g_varchar2)
       = nvl(p_call_package,hr_api.g_varchar2)
   and   nvl(call_procedure, hr_api.g_varchar2)
       = nvl(p_call_procedure, hr_api.g_varchar2)
   and   legislation_code IS NULL;

Line: 164

procedure delete_app_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_app_api_hook_call';

Line: 173

   SELECT 'Y'
     FROM hr_api_hook_calls
    WHERE api_hook_call_id = p_api_hook_call_id
      AND application_id IS NOT NULL;

Line: 180

   SELECT 'Y'
     FROM hr_api_hook_calls
    WHERE api_hook_call_id = p_api_hook_call_id;

Line: 191

  savepoint delete_app_api_hook_call;

Line: 244

    ROLLBACK TO delete_app_api_hook_call;

Line: 246

    ROLLBACK TO delete_app_api_hook_call;

Line: 248

end delete_app_api_hook_call;

Line: 255

procedure update_app_api_hook_call
  (p_validate                     in     boolean  default false,
   p_effective_date               in     date,
   p_api_hook_call_id             in     number,
   p_object_version_number        in out nocopy number,
   p_sequence                     in     number    default hr_api.g_number,
   p_app_install_status           in     varchar2  default hr_api.g_varchar2,
   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_pre_processor_date           in     date      default hr_api.g_date,
   p_encoded_error                in     varchar2  default hr_api.g_varchar2,
   p_status                       in     varchar2  default hr_api.g_varchar2
   ) is
  --
  -- Declare cursors and local variables
  --
  l_effective_date      date;

Line: 278

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

Line: 282

   SELECT 'Y'
     FROM hr_api_hook_calls
    WHERE api_hook_call_id = p_api_hook_call_id
      AND application_id IS NOT NULL;

Line: 289

   SELECT 'Y'
     FROM hr_api_hook_calls
    WHERE api_hook_call_id = p_api_hook_call_id;

Line: 309

  savepoint update_app_api_hook_call;

Line: 380

    ROLLBACK TO update_app_api_hook_call;

Line: 383

    ROLLBACK TO update_app_api_hook_call;

Line: 386

end update_app_api_hook_call;