/*** Update User Profile ***/
	UPDATE [cdds_User_Profile] 
	SET [FirstName] = @FirstName, [LastName] = @LastName, [Title] = @Title, 
		[Phone] = @Phone, [AcctType] = @AcctType, [AcctStatus] = @AcctStatus, 
		[LastUpdatedDate] = GETDATE() 
		WHERE  ([FirstName] = @Original_FirstName AND [LastName] = @Original_LastName 
			AND [Title]=@Original_Title AND [Phone]=@Original_Phone 
			AND [AcctType]=@Original_AcctType AND [AcctStatus]= @Original_AcctStatus 
			AND [AgencyUniqueId] = @Original_AgencyUniqueId
			AND [UserId] = @Original_UserId);
		IF @@ROWCOUNT = 0
			BEGIN
				SET @err_message = 'Data has been edited by another user since you began viewing this information.'
				RAISERROR (@err_message,11, 1)
				ROLLBACK TRANSACTION
				RETURN
			END	      	
		IF @@ERROR <> 0 
	        	BEGIN
				ROLLBACK TRANSACTION
				RETURN
		 	END	

IF @blnPrimary = 1 
		BEGIN 
IF LOWER(@AcctStatus) <> LOWER(@AgencyAcctStatus)
				/*** Update Users Acct. Status ***/
				/* update all users in same agency profile */
				UPDATE [cdds_User_Profile] 
					SET [AcctStatus] = @AcctStatus,[LastUpdatedDate] = GETDATE() 
					WHERE  ([AgencyUniqueId] = @Original_AgencyUniqueId
						AND [UserId] = @Original_UserId);
			  	IF @@ROWCOUNT = 0
					BEGIN
						SET @err_message = 'Data for this agency has been edited by another user since you began viewing this information.'
						RAISERROR (@err_message,11, 1)
						ROLLBACK TRANSACTION
						RETURN
					END
				IF @@ERROR <> 0 
			  		BEGIN
						ROLLBACK TRANSACTION
						RETURN
			   		END
END