Depends on the platform. SQL server vs oracle vs whatever else.
In oracle you can get a list off stored procs that you have access to via the ALL_OBJECTS view (with approriate where clause). then essentially you are gonna 'describe' each stored procedure to get the internal functions and parameters for each