The following lines contain the word 'select', 'insert', 'update' or 'delete':
select pbg.security_group_id
from per_business_groups pbg
, per_solution_type_cmpts stc
-- , EDIT_HERE table_name(s) 333
where stc.component_name = p_component_name
and stc.solution_type_name = p_solution_type_name;
select stc.legislation_code
from per_solution_type_cmpts stc
where stc.component_name = p_component_name
and stc.solution_type_name = p_solution_type_name;
Procedure chk_non_updateable_args
(p_effective_date in date
,p_rec in per_stc_shd.g_rec_type
) IS
--
l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
End chk_non_updateable_args;
procedure chk_updateable
(p_component_name in per_solution_type_cmpts.component_name%TYPE
,p_solution_type_name in per_solution_type_cmpts.solution_type_name%TYPE
,p_legislation_code in per_solution_type_cmpts.legislation_code%TYPE
,p_updateable in per_solution_type_cmpts.updateable%TYPE
,p_effective_date in date
,p_object_version_number in per_solution_type_cmpts.object_version_number%TYPE
)
is
--
l_exists varchar2(1);
l_proc varchar2(72) := g_package||'chk_updateable';
,p_argument => 'updateable'
,p_argument_value => p_updateable
);
and nvl(per_stc_shd.g_old_rec.updateable, hr_api.g_varchar2)
<> nvl(p_updateable,hr_api.g_varchar2))
or
(NOT l_api_updating))
then
hr_utility.set_location(l_proc, 40);
if p_updateable is not null then
--
-- Check that the updateable flag exists in HR_STANDARD_LOOKUPS for the
-- lookup type 'YES_NO' with an enabled flag set to 'Y'
-- and that the effective date is between start date
-- active and end date active in HR_STANDARD_LOOKUPS.
--
if hr_api.not_exists_in_hrstanlookups
(p_effective_date => p_effective_date
,p_lookup_type => 'YES_NO'
,p_lookup_code => p_updateable
)
then
--
hr_utility.set_message(801, 'HR_EDIT');
end chk_updateable;
Procedure insert_validate
(p_effective_date in date
,p_rec in per_stc_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'insert_validate';
chk_updateable
(p_component_name => p_rec.component_name
,p_solution_type_name => p_rec.solution_type_name
,p_legislation_code => p_rec.legislation_code
,p_updateable => p_rec.updateable
,p_effective_date => p_effective_date
,p_object_version_number => p_rec.object_version_number
);
End insert_validate;
Procedure update_validate
(p_effective_date in date
,p_rec in per_stc_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'update_validate';
chk_non_updateable_args
(p_effective_date => p_effective_date
,p_rec => p_rec
);
chk_updateable
(p_component_name => p_rec.component_name
,p_solution_type_name => p_rec.solution_type_name
,p_legislation_code => p_rec.legislation_code
,p_updateable => p_rec.updateable
,p_effective_date => p_effective_date
,p_object_version_number => p_rec.object_version_number
);
End update_validate;
Procedure delete_validate
(p_rec in per_stc_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'delete_validate';
End delete_validate;