APPS.HR_AHK_BUS SQL Statements

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

Line: 15

Procedure chk_non_updateable_args
  (p_rec            in hr_ahk_shd.g_rec_type
  ) is
--
  l_proc     varchar2(72) := g_package||'chk_non_updateable_args';

Line: 64

end chk_non_updateable_args;

Line: 103

    select api_module_type
    from hr_api_modules
    where api_module_id = p_api_module_id;

Line: 186

   select api_module_id from hr_api_hooks hah
   where hah.api_module_id = p_api_module_id
   and   hah.api_hook_type = p_api_hook_type;

Line: 193

   select api_module_type from hr_api_modules
   where api_module_id = p_api_module_id;

Line: 304

    select territory_code
    from fnd_territories ft
    where ft.territory_code = p_legislation_code;

Line: 469

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

Line: 546

      select data_within_business_group
      from hr_api_modules
      where api_module_id = p_api_module_id;

Line: 625

      select data_within_business_group
      from hr_api_modules
      where api_module_id = p_api_module_id;

Line: 742

Procedure chk_delete
       (p_api_hook_id		in	number
       ) is
--
--   Local declarations
  l_proc               varchar2(72) := g_package||'chk_delete';

Line: 752

    select api_hook_id
    from hr_api_hook_calls hahc
    where hahc.api_hook_id = p_api_hook_id;

Line: 777

end chk_delete;

Line: 784

Procedure insert_validate(p_rec in hr_ahk_shd.g_rec_type,
                          p_effective_date in date) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 861

End insert_validate;

Line: 866

Procedure update_validate(p_rec in hr_ahk_shd.g_rec_type,
                          p_effective_date in date) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 931

End update_validate;

Line: 936

Procedure delete_validate(p_rec in hr_ahk_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 944

    chk_delete(p_api_hook_id   =>   p_rec.api_hook_id);

Line: 947

End delete_validate;