APPS.HR_LEG_API_HOOK_CALL_INTERNAL SQL Statements

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

Line: 46

   select api_hook_call_id from hr_api_hook_calls
   where api_hook_id = p_api_hook_id
   and   nvl(legislation_code,'x') = nvl(p_legislation_code,'x')
   and   nvl(call_package, 'x') = nvl(p_call_package,'x')
   and   nvl(call_procedure, 'x') = nvl(p_call_procedure, 'x')
   and   application_id IS NULL;

Line: 149

procedure delete_leg_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_leg_api_hook_call';

Line: 161

  savepoint delete_leg_api_hook_call;

Line: 190

    ROLLBACK TO delete_leg_api_hook_call;

Line: 192

    ROLLBACK TO delete_leg_api_hook_call;

Line: 194

end delete_leg_api_hook_call;

Line: 201

procedure update_leg_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
  --
  -- Declare cursors and local variables
  --
  l_effective_date      date;

Line: 220

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

Line: 236

  savepoint update_leg_api_hook_call;

Line: 280

    ROLLBACK TO update_leg_api_hook_call;

Line: 283

    ROLLBACK TO update_leg_api_hook_call;

Line: 286

end update_leg_api_hook_call;