SELECT OBJECT_TYPE,
       OBJECT_NAME,
       STATUS,
       TO_CHAR( CREATED, 'YYYY.MM.DD' ) AS CREATED,
       TO_CHAR( LAST_DDL_TIME, 'YYYY.MM.DD' ) AS LAST_DDL_TIME
  FROM USER_OBJECTS
 WHERE OBJECT_TYPE IN ( 'FUNCTION', 'PROCEDURE' )
   AND TO_CHAR( LAST_DDL_TIME, 'YYYYMMDD' ) > '20151006'
 ORDER BY OBJECT_TYPE,
       OBJECT_NAME

SELECT TYPE,
       NAME,
       LINE,
       TEXT
  FROM USER_SOURCE B
 WHERE TYPE IN ( 'FUNCTION', 'PROCEDURE' )
   AND TEXT LIKE '%''TEXT''%'
 ORDER BY TYPE,
       NAME,
       LINE