Package Question

[akkerend]

With this query you get the parameters of procedures and functions in the package:
SELECT * FROM user_arguments
WHERE package_name = 'PKG_VALIDATION' ;


With this query you get procedures and functions in the package:
SELECT object_name,
decode(min(position),0,'FUNCTION',1,'PROCEDURE',null) TYPE
FROM user_arguments
WHERE package_name = 'PKG_VALIDATION'
GROUP BY object_name;