Para ver procedimientos de un esquema:

select * from all_procedures where OWNER = 'TEMPORAL';

Para ver los triggers de un esquema:
SELECT * FROM ALL_TRIGGERS WHERE   OWNER = 'TEMPORAL';


Para ver las tablas de un esquema:

SELECT * FROM ALL_TABLES WHERE OWNER = 'TEMPORAL';

Para ver los constraint de un esquema:
 

SELECT C.CONSTRAINT_TYPE,A.CONSTRAINT_NAME AS restriccion, A.TABLE_NAME AS tabla, A.COLUMN_NAME AS columna

FROM ALL_CONS_COLUMNS A JOIN ALL_CONSTRAINTS C  ON A.CONSTRAINT_NAME = C.CONSTRAINT_NAME

WHERE 1=1  AND C.CONSTRAINT_TYPE = 'R'

AND A.OWNER = 'TEMPORAL'

ORDER BY A.CONSTRAINT_NAME, A.TABLE_NAME, A.COLUMN_NAME;