ALTER   PROCEDURE [dbo].[CON_REQUEST_DOC_SendApp]
@CONST_ID VARCHAR(15),
@TLNAME VARCHAR(100)
AS
BEGIN TRANSACTION
		IF(NOT EXISTS(SELECT * FROM CON_REQUEST_DOC WHERE CONSTRUCT_ID = @CONST_ID))
		BEGIN
			ROLLBACK TRANSACTION
			SELECT '-1' as Result, N'Vui lòng chọn tờ trình cho công trình này.' ErrorDesc
			RETURN '-1'
		END
		UPDATE CON_MASTER 
		SET [AUTH_STATUS] = 'U'
		WHERE CONSTRUCT_ID = @CONST_ID
		IF @@Error <> 0 GOTO ABORT

		UPDATE CON_REQUEST_DOC SET [AUTH_STATUS] = 'U'
		WHERE CONSTRUCT_ID = @CONST_ID
		IF @@Error <> 0 GOTO ABORT

		INSERT INTO dbo.PL_PROCESS
					(
					    REQ_ID,
					    PROCESS_ID,
					    CHECKER_ID,
					    APPROVE_DT,
					    PROCESS_DESC,
					    NOTES
					)
					VALUES
					(   @CONST_ID,        -- REQ_ID - varchar(15)
					    --@p_PROCESS_ID,        -- PROCESS_ID - varchar(10)
						'SEND',
					    @TLNAME,        -- CHECKER_ID - varchar(15)
					    GETDATE(), -- APPROVE_DT - datetime
					    N'Nhân viên tạo phiếu và gửi phê duyệt thành công' ,       -- PROCESS_DESC - nvarchar(1000)
					    N'Gửi phê duyệt'       -- NOTES - nvarchar(1000)
					 )
COMMIT TRANSACTION
SELECT '0' as Result, '' ErrorDesc
RETURN '0'

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