1.While importing object into Informatica, listed objects are always owned by the "connecting" user. If your object is owned by some other user, you wont see it. To see objects not owned by connecting user, you'd have to choose "All" in the schema text box, while connecting.
2.You should be looking for object_type='PROCEDURE' and not "FUNCTION". Therefore, your query should read as select * from all_objects where object_type='PROCEDURE'
3.If all this is done and you still dont see the object, check privileges on that object to your connecting user. For this, the best course is a. ask your dba to grant execute privileges on that object to your connecting user. OR b. connect to database as the owner of that object and run the following command grant execute on