USP_FAFNFG_CALCULATE

CREATE procedure dbo.USP_FAFNFG_CALCULATE
(
                @NUMBERPROCESSED int = 0 output
)
as
begin
set nocount on;

  declare @CHANGEAGENTID uniqueidentifier,
          @NFGPROCESSED int, @NFGLEVELPROCESSED int;

  set @NUMBERPROCESSED = 0;

  --begin tran

  begin try

  exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

  -- update NFG Level Information

  exec dbo.USP_FAFNFGCAMPAIGNLEVEL_CALCULATE @NUMBERPROCESSED=@NFGLEVELPROCESSED output, @CHANGEAGENTID=@CHANGEAGENTID 

  -- update NFG information

  exec dbo.USP_FAFNFGCAMPAIGN_CALCULATE @NUMBERPROCESSED=@NFGPROCESSED output, @CHANGEAGENTID=@CHANGEAGENTID

  set @NUMBERPROCESSED = isnull(@NFGPROCESSED, 0) + isnull(@NFGLEVELPROCESSED,0);

  end try
  begin catch    
    exec dbo.USP_RAISE_ERROR;
      --IF @@TRANCOUNT > 0

          --ROLLBACK TRANSACTION;

  end catch

  --IF @@TRANCOUNT > 0

    --COMMIT TRANSACTION;  


end