What is the use of StoredProcedureNotification?

Hi All,
The use of basic notification is that, if we disable the basic notification then DB objects (buffer table,sequnce,index) won’t be dropped from the DB and we have to create the DB objects for basic notification.

Like basic notification, do we have any specfic use of StoredProcedureNotification? I would like to know the advantage or when we can use StoredProcedureNotification.