PackageName1: Procedure1, Procedure2,...
PackageName2: Procedure1, Procedure2,...

select distinct name, type
from all_source
where owner ='HR'
and type='PACKAGE';