check procedure exists in sql developer code example

Example: plsql find location of procedure

SELECT * 
FROM SYS.DBA_DEPENDENCIES 
WHERE  REFERENCED_NAME = '<NAME_OF_PKG_OR_PROC_FUNC>' AND 
REFERENCED_TYPE IN ('PACKAGE', 'PROCEDURE', 'FUNCTION');