For the moment, the only documentation for this is the source.
You can find all information about procedures by examining the following files:
sql/sql_analyse.cc
sql/procedure.h
sql/procedure.cc
sql/sql_select.cc