DECLARE @REQ_ID VARCHAR(15)
SELECT @REQ_ID = REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2024/002046'
UPDATE TR_REQUEST_DOC SET PROCESS_ID = 'DMMS' WHERE REQ_ID = @REQ_ID 
UPDATE PL_REQUEST_PROCESS SET STATUS = 'P' WHERE REQ_ID = @REQ_ID AND PROCESS_ID = 'APPROVE'
UPDATE PL_REQUEST_PROCESS SET STATUS = 'C' WHERE REQ_ID = @REQ_ID AND PROCESS_ID = 'DMMS'
UPDATE PL_REQUEST_PROCESS_CHILD SET STATUS_JOB = 'C' WHERE REQ_ID = @REQ_ID AND TYPE_JOB = 'XL' AND TLNAME = 'anhtm1'
SELECT @REQ_ID = REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2024/001817'
UPDATE TR_REQUEST_DOC SET PROCESS_ID = 'APPROVE' WHERE REQ_ID = @REQ_ID 
UPDATE PL_REQUEST_PROCESS SET STATUS = 'C' WHERE REQ_ID = @REQ_ID AND PROCESS_ID = 'APPROVE'
UPDATE PL_REQUEST_PROCESS SET STATUS = 'P' WHERE REQ_ID = @REQ_ID AND PROCESS_ID = 'DMMS'
UPDATE PL_REQUEST_PROCESS_CHILD SET STATUS_JOB = 'P' WHERE REQ_ID = @REQ_ID AND TYPE_JOB = 'XL' AND TLNAME = 'anhtm1'