Sorry to speak in such broad strokes but this is a question that was asked today. We had a download procedure go invalid today.

As far as I know dropping or altering the base tables, editing the proc will invalidate it, anything else?

A network glitch should not cause it to go invalid.
The proc basically downloads data through a db_link from another database.