Oracle PL/SQL Tutorial/System Tables Data Dictionary/user method params
Query user_method_params
SQL>
SQL> select distinct method_name, type_name from user_method_params order by type_name;
--
SQL>
SQL> select distinct method_name, type_name from user_method_params order by type_name;
--