ALTER         PROCEDURE _1sp_RegisterUpdate(@p1 char( 3 ), @p2 int, @p3 char( 9 ), @p4 char( 1 ))

AS

SET NOCOUNT ON


IF @p2 =  5517  AND @p4 != 'D'

	IF NOT EXISTS	(
						SELECT	Sc5517.Id
						FROM	Sc5517
								JOIN
								Sc4604 ON	Sc4604.Sp6608	= @p1
														AND
														Sc5517.Id		= @p3
														AND
														(
															Sc5517.Sp5508 = Sc4604.Id
															OR
															Sc5517.Sp5509 = Sc4604.Id
														)
					)
		RETURN

ELSE IF @p2 =  6329  AND @p4 != 'D'

	IF NOT EXISTS	(
						SELECT	Sc6329.Id
						FROM	Sc6329
								JOIN
								Sc4604 ON	Sc4604.Sp6608	= @p1
														AND
														Sc6329.Id		= @p3
														AND
														Sc6329.Sp6344	= Sc4604.Id
					)
		RETURN


UPDATE _1SUpdts

	SET	Deleted	= @p4,
		DwnldId	= '         '

WHERE	DBSign	= @p1
		AND
		TypeId	= @p2
		AND
		ObjId	= @p3


IF @@ROWCOUNT =  0 
	INSERT INTO _1SUpdts VALUES(@p1, @p2, @p3, @p4, '         ')