417: --
418: -- Description:
419: -- This procedure ensures that a delete occurs only if there are no child
420: -- rows for a record in hr_ki_hierarchies. The tables that contain child rows
421: -- are hr_ki_hierarchies, hr_ki_hierarchy_node_maps,hr_ki_hierarchies_tl.
422:
423: -- Pre Conditions:
424: -- g_rec has been populated with details of the values
425: -- from the ins or the upd procedures
451: CURSOR csr_hnm_id is
452: select
453: distinct 'found'
454: From
455: hr_ki_hierarchy_node_maps hnm
456: where
457: hnm.hierarchy_id = p_hierarchy_id;
458:
459: CURSOR csr_htl_id is