added the manager.
added the stored proc.