Search all packages for a line of code:

SELECT  *

FROM    ALL_SOURCE

WHERE   TYPE IN ('PACKAGE', 'PACKAGE BODY')

AND     TEXT LIKE '%XXXX%'