ALTER PROCEDURE [dbo].[MW_OUT_Del]
@p_OUT_ID	varchar(15)
AS

	DECLARE @sErrorCode VARCHAR(20) = ''
	DECLARE @l_AUTH_STATUS VARCHAR(1)
	--KIEM TRA TRANG THAI AUTH_STATUS
	SELECT @l_AUTH_STATUS = KT_AUTH_STATUS FROM MW_OUT WHERE OUT_ID = @p_OUT_ID
BEGIN TRANSACTION
	IF( (SELECT KT_CHECKER_ID FROM MW_OUT WHERE OUT_ID = @p_OUT_ID AND KT_AUTH_STATUS = 'A') IS NOT NULL)
	BEGIN
		ROLLBACK TRANSACTION
		SELECT '-1' as Result, N'Thông tin xuất vật liệu đã được kế toán duyệt!' ErrorDesc
		RETURN '-1'
	END
	ELSE
	BEGIN
		DELETE FROM MW_OUT WHERE OUT_ID = @p_OUT_ID
		DELETE FROM MW_OUT_DT WHERE  OUT_ID= @p_OUT_ID
	END
IF @@Error <> 0 GOTO ABORT
COMMIT TRANSACTION
SELECT '0' as Result, '' ErrorDesc
RETURN '0'

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