you can check all_arguments

if for a given object_name in a given package_name if there is an
argument at position 0 then it is a function otherwise it is a
procedure.

there is a neat decode that I submitted to OTN few months ago, but
can't locate it.

Raj
--
http://www.freelists.org/webpage/oracle-l