ALTER PROCEDURE [dbo].[RET_MASTER_Del]
@RET_ID	varchar(15)
AS
	DECLARE @ERRORSYS NVARCHAR(15) = '' 
	IF ( NOT EXISTS ( SELECT * FROM RET_MASTER WHERE  RET_ID= @RET_ID))
		SET @ERRORSYS = 'RETM-00001'
	IF @ERRORSYS <> ''
	BEGIN
		SELECT ErrorCode Result, ErrorDesc ErrorDesc FROM SYS_ERROR WHERE ErrorCode = @ERRORSYS 
		RETURN '0'
	END
BEGIN TRANSACTION
	IF( (SELECT AUTH_STATUS FROM RET_MASTER WHERE  RET_ID= @RET_ID) = 'A')
	BEGIN
		UPDATE RET_MASTER SET RECORD_STATUS = '0' 
		WHERE RET_ID = @RET_ID -- 23/10 thieu where nen khi xoa bi xoa het
		IF @@Error <> 0 GOTO ABORT
	END
	------------BAODNQ 10/3/2022 : KO CHO XÓA BDS KHI ĐÃ GỬI YC PHÊ DUYỆT------
	IF(EXISTS(SELECT * FROM RET_MASTER WHERE RET_ID = @RET_ID AND IS_SEND_APPR = 'Y'))
	BEGIN
		ROLLBACK TRANSACTION
		SELECT '-1' as Result, N'Không thể xóa BDS đã được gửi yêu cầu phê duyệt' ErrorDesc
		RETURN '-1'
	END
	ELSE
	BEGIN
		Delete FROM RET_MASTER WHERE  RET_ID= @RET_ID
		IF @@Error <> 0 GOTO ABORT
	END
COMMIT TRANSACTION
SELECT '0' as Result, '' ErrorDesc
RETURN '0'

ABORT:
BEGIN
		ROLLBACK TRANSACTION
		SELECT '-1' as Result, '' ErrorDesc
		RETURN '-1'
End