select 
	schema, package, object,
	case when argument_out_table >  0  then 'TABLE FUNCTION'
		when argument_out >  0  then 'FUNCTION'
		else 'PROCEDURE'
	end type
from
(
	select all_procedures.owner schema, all_procedures.object_name package, all_procedures.procedure_name object, 
	sum(case when all_arguments.in_out = 'OUT' and all_arguments.data_type = 'TABLE' then  1  else  0  end) argument_out_table,
	sum(case when all_arguments.in_out = 'OUT' then  1  else  0  end) argument_out
	from all_procedures inner join all_arguments on all_procedures.procedure_name = all_arguments.object_name
	group by all_procedures.owner, all_procedures.object_name, all_procedures.procedure_name
	order by all_procedures.owner, all_procedures.object_name, all_procedures.procedure_name
)