USP_FAFAGGREGATES_CALCULATE

create procedure dbo.USP_FAFAGGREGATES_CALCULATE      
(      
 @NUMBERPROCESSED int = 0 output      
)      

as
begin
set nocount on;

declare @CHANGEAGENTID uniqueidentifier
  exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

declare @CURRENTDATE datetime
  set @CURRENTDATE = GETDATE();

set @NUMBERPROCESSED = 0
declare @NUMBERPROCESSEDIND int

begin try

        set @NUMBERPROCESSEDIND = 0
    exec dbo.USP_FAFRAISEDTOTAL_CATEGORIZED_CALCULATE @NUMBERPROCESSED=@NUMBERPROCESSEDIND output, @CURRENTDATE=@CURRENTDATE
        set @NUMBERPROCESSED = @NUMBERPROCESSEDIND

        set @NUMBERPROCESSEDIND = 0
    exec dbo.USP_FAFGROUPSUMMARYINFORMATION_CATEGORIZED_CALCULATE @NUMBERPROCESSED=@NUMBERPROCESSEDIND output, @CHANGEAGENTID=@CHANGEAGENTID, @CURRENTDATE=@CURRENTDATE 
        set @NUMBERPROCESSED = @NUMBERPROCESSED + @NUMBERPROCESSEDIND

        set @NUMBERPROCESSEDIND = 0
     exec dbo.USP_FAFREGISTRANTBENEFIT_CALCULATE @NUMBERPROCESSED=@NUMBERPROCESSEDIND output, @CHANGEAGENTID=@CHANGEAGENTID, @CURRENTDATE=@CURRENTDATE 
        set @NUMBERPROCESSED = @NUMBERPROCESSED + @NUMBERPROCESSEDIND

        set @NUMBERPROCESSEDIND = 0
    exec dbo.USP_FAFREGISTRANT_EXTEND_CALCULATE @NUMBERPROCESSED=@NUMBERPROCESSEDIND output, @CHANGEAGENTID=@CHANGEAGENTID, @CURRENTDATE=@CURRENTDATE
        set @NUMBERPROCESSED = @NUMBERPROCESSED + @NUMBERPROCESSEDIND

    set @NUMBERPROCESSED = isnull(@NUMBERPROCESSED, 0)

end try
begin catch
     exec dbo.USP_RAISE_ERROR;
end catch

end