in IR subscription is one function in action menu which does same thing which you are expected
read more about Customizing Interactive Reports
and Martin Giffy D'Souza on Oracle APEX: APEX IR: Subscriptions with Bind Variables and VPD hope this helps you..
Pars has this spot on, i suggest you
If you can't send an email using the package and you're using 11g you may want to ensure that your network ACLs are configured properly.
Hope this helps