Check the status for all stored procedures is by using the Oracle data dictionary view USER_OBJECTS : user_objects « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. user_objects

select object_type, object_name, status
from user_objects
where object_type in ('FUNCTION','PROCEDURE','PACKAGE','PACKAGE BODY','TRIGGER')
order by object_type,object_name;