APPS.HR_API_MODULE_INTERNAL SQL Statements

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

Line: 36

  select api_module_id from hr_api_modules ham
  where ham.module_name = p_module_name
  and   ham.api_module_type = p_api_module_type;

Line: 121

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

Line: 133

    savepoint delete_api_module;

Line: 162

    ROLLBACK TO delete_api_module;

Line: 163

end delete_api_module;

Line: 170

procedure update_api_module
  (p_validate                      in      boolean  default false,
   p_api_module_id                 in      number,
   p_module_name                   IN      varchar2 default hr_api.g_varchar2,
   p_module_package                IN      varchar2 default hr_api.g_varchar2,
   p_data_within_business_group    IN      varchar2 default hr_api.g_varchar2,
   p_effective_date                IN      date
  )  is
  --
  l_proc                       varchar2(72) := g_package||'update_api_module';

Line: 187

    savepoint update_api_module;

Line: 221

    ROLLBACK TO update_api_module;

Line: 222

end update_api_module;