USP_VOLUNTEER_CHECKSTEPSCOMPLETE

            create procedure dbo.USP_VOLUNTEER_CHECKSTEPSCOMPLETE(
                @VOLUNTEERSCREENPLANID uniqueidentifier = null,
                @CHANGEAGENTID uniqueidentifier = null
            )
            as
                set nocount on;
                declare @CURRENTDATE datetime;
                declare @VOLUNTEERID uniqueidentifier;

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                set @CURRENTDATE = getdate();

                begin try
                    if (select count(*)
                            from dbo.VOLUNTEERSCREENPLANSTEP
                            where SCREENPLANID = @VOLUNTEERSCREENPLANID and STATUSCODE <> 1) = 0
                    begin
                        update dbo.VOLUNTEERVOLUNTEERTYPE
                        set STATUSCODE = 1,
                            @VOLUNTEERID = VOLUNTEERID,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE
                        where VOLUNTEERSCREENPLANID = @VOLUNTEERSCREENPLANID and STATUSCODE = 0;
                    end
                end try

                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;