How to use % before the like operator in the query

SELECT *  
FROM all_source |
  WHERE owner       = 'APPS'
    AND UPPER(type) = UPPER(p_type)
    AND UPPER(name) = UPPER(p_name)
    AND UPPER(text) like UPPER (''||'%'||:p_text||'%'||'');