The following lines contain the word 'select', 'insert', 'update' or 'delete':
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';
end chk_non_updateable_args;
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;
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) ;
select territory_code
from fnd_territories ft
where ft.territory_code = p_legislation_code;
Procedure chk_delete
(p_api_module_id in number
) is
--
-- Local declarations
l_proc varchar2(72) := g_package||'chk_delete';
select api_module_id
from hr_api_hooks hah
where hah.api_module_id = p_api_module_id;
end chk_delete;
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';
End insert_validate;
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';
hr_amd_bus.chk_non_updateable_args(p_rec => p_rec);
End update_validate;
Procedure delete_validate(p_rec in hr_amd_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'delete_validate';
chk_delete(p_api_module_id => p_rec.api_module_id);
End delete_validate;