388: /* 10 Levels inserted */
389: /*************************************************/
390:
391: edw_log.put_line( 'About to call Supervisor Hierarchy summary table population routine' );
392: hri_struct_summary.load_all_sup_hierarchies;
393:
394: open cur_check_sprvsr_hrchy;
395: fetch cur_check_sprvsr_hrchy into l_check_sprvsr_id;
396:
399: if cur_check_sprvsr_hrchy%ISOPEN then
400: if cur_check_sprvsr_hrchy%NOTFOUND then
401: edw_log.put_line( 'Supervisor hierarchy is empty' );
402: else
403: edw_log.put_line( 'hri_struct_summary.load_all_sup_hierarchies completed OK.' );
404: end if;
405: end if;
406:
407: edw_log.put_line( ' ' );