210: --
211: -- Description:
212: -- This procedure ensures that a delete occurs only if there are no child
213: -- rows for a record in hr_ki_topics. The tables that contain child rows are
214: -- hr_ki_hierarchy_node_maps,hr_ki_topic_integrations,hr_ki_topics_tl.
215:
216: -- Pre Conditions:
217: -- g_rec has been populated with details of the values
218: -- from the ins or the upd procedures
252: CURSOR csr_ttl_id is
253: select
254: distinct 'found'
255: From
256: hr_ki_topics_tl ttl
257: where
258: ttl.topic_id = p_topic_id;
259:
260: l_found varchar2(30);