The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure chk_non_updateable_args
(p_effective_date in date
,p_rec in hxc_egc_shd.g_rec_type
) IS
--
l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
End chk_non_updateable_args;
SELECT 'error'
FROM sys.dual
WHERE NOT EXISTS (
SELECT 'x'
FROM hxc_time_entry_rules ter
WHERE ter.time_entry_rule_id = p_entity_id );
SELECT 'error'
FROM dual
WHERE NOT EXISTS (
SELECT 'x'
FROM hxc_time_recipients tr
WHERE tr.time_recipient_id = p_entity_id );
SELECT 'error'
FROM dual
WHERE NOT EXISTS (
SELECT 'x'
FROM hxc_retrieval_rules rr
WHERE rr.retrieval_rule_id = p_entity_id );
SELECT 'error'
FROM dual
WHERE NOT EXISTS (
SELECT 'x'
FROM hxc_template_summary hts
WHERE hts.template_id = p_entity_id
and hts.template_type = 'PUBLIC');
SELECT 'error'
FROM sys.dual
WHERE NOT EXISTS (
SELECT 'x'
FROM hxc_entity_groups egc
WHERE egc.entity_group_id = p_entity_group_id );
SELECT 'error'
FROM sys.dual
WHERE NOT EXISTS (
SELECT 'x'
FROM hr_lookups lk
WHERE lk.lookup_type = 'HXC_ENTITIES'
AND lk.lookup_code = p_entity_type
AND p_effective_date BETWEEN
lk.start_date_active and NVL(lk.end_date_active, hr_general.end_of_time) );
select 'Y'
from hxc_entity_groups heg,
hxc_entity_group_comps hec,
hxc_time_entry_rules hte1,
hxc_time_entry_rules hte2
where heg.entity_type = 'TIME_ENTRY_RULES' and
heg.entity_group_id = nvl(p_entity_group_id,-999) and
hec.ENTITY_GROUP_ID =heg.entity_group_id and
hec.entity_id = hte1.TIME_ENTRY_RULE_ID and
hte1.attribute1 = hte2.attribute1 and
hte2.time_entry_rule_id = nvl(p_entity_id,-999) and
hec.entity_group_comp_id <> nvl(p_entity_group_comp_id,-999);
Procedure insert_validate
(p_effective_date in date
,p_rec in hxc_egc_shd.g_rec_type
,p_called_from_form in varchar2
) is
--
l_proc varchar2(72);
l_proc := g_package||'insert_validate';
End insert_validate;
Procedure update_validate
(p_effective_date in date
,p_rec in hxc_egc_shd.g_rec_type
,p_called_from_form in varchar2
) is
--
l_proc varchar2(72);
l_proc := g_package||'update_validate';
chk_non_updateable_args
(p_effective_date => p_effective_date
,p_rec => p_rec
);
End update_validate;
Procedure delete_validate
(p_rec in hxc_egc_shd.g_rec_type
) is
--
l_proc varchar2(72);
l_proc := g_package||'delete_validate';
End delete_validate;