If you need to find the procedure or package in Oracle that mentions a specific string, you can use this query to find the name of the procedure or package.
This will only work if you have access to the procedure or package, such as it’s in your user_source, or you’re a super user.
SELECT DISTINCT name, type FROM all_source WHERE UPPER(text) LIKE UPPER(‘%string%’);