APPS.HR_AMD_BUS SQL Statements

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

Line: 14

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

Line: 64

end chk_non_updateable_args;

Line: 168

   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: 260

    select null
        from hr_api_hooks hk
        where hk.api_module_id = p_api_module_id
        and (legislation_package is not null
              or legislation_function is not null) ;

Line: 350

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

Line: 479

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

Line: 489

    select api_module_id
    from hr_api_hooks hah
    where hah.api_module_id = p_api_module_id;

Line: 514

end chk_delete;

Line: 520

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

Line: 573

End insert_validate;

Line: 578

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

Line: 596

  hr_amd_bus.chk_non_updateable_args(p_rec => p_rec);

Line: 623

End update_validate;

Line: 628

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

Line: 636

    chk_delete(p_api_module_id   =>   p_rec.api_module_id);

Line: 639

End delete_validate;