The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'error'
FROM sys.dual
WHERE EXISTS (
SELECT 'x'
FROM hxc_time_recipients tr
WHERE tr.name = p_name
AND ( tr.time_recipient_id <> p_time_recipient_id
OR p_time_recipient_id IS NULL) );
SELECT 'N'
FROM fnd_application
WHERE application_id = p_application_id;
Procedure chk_delete
(
p_time_recipient_id in hxc_time_recipients.time_recipient_id%TYPE
) IS
l_used_elsewhere VARCHAR2(1) := 'N';
SELECT 'Y'
FROM sys.dual
WHERE EXISTS (
SELECT 'x'
FROM hxc_retrieval_processes ret
WHERE ret.time_recipient_id = p_time_recipient_id);
SELECT 'Y'
FROM sys.dual
WHERE EXISTS (
SELECT 'x'
FROM hxc_retrieval_rule_comps rrc
WHERE rrc.time_recipient_id = p_time_recipient_id);
SELECT 'Y'
FROM sys.dual
WHERE EXISTS (
SELECT 'x'
FROM hxc_approval_period_comps apc
WHERE apc.time_recipient_id = p_time_recipient_id);
SELECT 'Y'
FROM sys.dual
WHERE EXISTS (
SELECT 'x'
FROM hxc_data_app_rule_usages daru
WHERE daru.time_recipient_id = p_time_recipient_id);
SELECT 'Y'
FROM sys.dual
WHERE EXISTS (
SELECT 'x'
FROM hxc_approval_comps ac
WHERE ac.time_recipient_id = p_time_recipient_id);
SELECT 'Y'
FROM sys.dual
WHERE EXISTS (
SELECT 'x'
FROM hxc_application_set_comps_v appsc
WHERE appsc.time_recipient_id = p_time_recipient_id);
BEGIN -- chk_delete
OPEN csr_chk_ret;
END chk_delete;
Procedure chk_non_updateable_args
(p_effective_date in date
,p_rec in hxc_htr_shd.g_rec_type
) IS
--
l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
End chk_non_updateable_args;
Procedure insert_validate
(p_effective_date in date
,p_rec in hxc_htr_shd.g_rec_type
) 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_htr_shd.g_rec_type
) 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_htr_shd.g_rec_type
) is
--
l_proc varchar2(72);
l_proc := g_package||'delete_validate';
hxc_htr_bus.chk_delete ( p_time_recipient_id => p_rec.time_recipient_id );
End delete_validate;