BEGIN TRY
BEGIN TRANSACTION
DECLARE @REQ_CODE VARCHAR(20),@NOTES NVARCHAR(4000),@REQ_ID VARCHAR(20)
SET @REQ_CODE ='AFT-23-002382' --- MÃ SỐ PHIẾU 
SET @NOTES =N'Hủy theo yêu cầu' --- LÝ DO HỦY PHIẾU
--- THỰC THI CÂU LỆNH
SELECT @REQ_ID=REQ_CODE FROM TR_REQUEST_CAR WHERE REQ_CODE = @REQ_CODE

EXEC TR_REQUEST_JOB_FORM_PROCESS_Upd @p_REQ_ID = @REQ_ID
                                    ,@p_TYPE_PROCESS = 'CANCEL'
                                    ,@p_CHECKER_ID = 'admin'
                      ,@p_NOTES = @NOTES

COMMIT TRANSACTION
SELECT 'SUCCESSFULL' RESULT
END TRY
BEGIN CATCH
   		ROLLBACK TRANSACTION
    		SELECT ERROR_MESSAGE() ERROR
END CATCH
---17052023_SECRETKEY