What is an "application firewall"?
Solution 1:
Wikipedia is your friend here -- Basically an Application Firewall is a firewall that operates at the Application layer (as opposed to just the network layer like packet-filtering firewalls).
The major advantage of Application Firewalls is that they can say "World of Warcraft is allowed to use port 12345, but nobody else is", or "HTTP traffic on port 80 is OK, but if the packets don't look like HTTP data block them", depending on the sophistication of the firewall in question and where it is on the network (a local application firewall knows World of Warcraft tried to use a port, where one plugged in later can only do packet inspection to figure out what kind of application it's dealing with).
Solution 2:
Google is also your friend here, but apparently Leopard's "application" firewall is really just a socket firewall, allowing you to trust certain applications and ports, much like Windows Firewall or Zone Alarm.
For the proper definition of an application firewall, see voretaq7's answer.