The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT inf.org_information14
FROM hr_organization_information inf
,ota_training_plan_members tpm
WHERE tpm.training_plan_member_id = p_training_plan_member_id
AND inf.organization_id = tpm.business_group_id
AND inf.org_information_context || '' = 'Business Group Information';
SELECT pbg.legislation_code
FROM per_business_groups pbg
, ota_training_plan_members ota
WHERE ota.training_plan_member_id = p_training_plan_member_id
AND pbg.business_group_id = ota.business_group_id;
PROCEDURE chk_non_updateable_args
(p_effective_date IN date
,p_rec IN ota_tpm_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 ota_tpm_shd.g_rec_type
) IS
--
l_proc varchar2(72) := g_package||'insert_validate';
END insert_validate;
PROCEDURE update_validate
(p_effective_date IN date
,p_rec IN ota_tpm_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
);
END update_validate;
PROCEDURE delete_validate
(p_rec IN ota_tpm_shd.g_rec_type
) IS
--
l_proc varchar2(72) := g_package||'delete_validate';
ota_tpm_bus1.chk_delete(
p_training_plan_member_id => ota_tpm_shd.g_old_rec.training_plan_member_id
,p_training_plan_id => ota_tpm_shd.g_old_rec.training_plan_id );
END delete_validate;