3.0.28.11.2024 BVBank CAP NHAT YEU CAU LANCVT.txt
| 1 |
DECLARE @REQ_ID VARCHAR(15) |
|---|---|
| 2 |
SELECT @REQ_ID = REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2024/002046' |
| 3 |
UPDATE TR_REQUEST_DOC SET PROCESS_ID = 'DMMS' WHERE REQ_ID = @REQ_ID |
| 4 |
UPDATE PL_REQUEST_PROCESS SET STATUS = 'P' WHERE REQ_ID = @REQ_ID AND PROCESS_ID = 'APPROVE' |
| 5 |
UPDATE PL_REQUEST_PROCESS SET STATUS = 'C' WHERE REQ_ID = @REQ_ID AND PROCESS_ID = 'DMMS' |
| 6 |
UPDATE PL_REQUEST_PROCESS_CHILD SET STATUS_JOB = 'C' WHERE REQ_ID = @REQ_ID AND TYPE_JOB = 'XL' AND TLNAME = 'anhtm1' |
| 7 |
SELECT @REQ_ID = REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2024/001817' |
| 8 |
UPDATE TR_REQUEST_DOC SET PROCESS_ID = 'APPROVE' WHERE REQ_ID = @REQ_ID |
| 9 |
UPDATE PL_REQUEST_PROCESS SET STATUS = 'C' WHERE REQ_ID = @REQ_ID AND PROCESS_ID = 'APPROVE' |
| 10 |
UPDATE PL_REQUEST_PROCESS SET STATUS = 'P' WHERE REQ_ID = @REQ_ID AND PROCESS_ID = 'DMMS' |
| 11 |
UPDATE PL_REQUEST_PROCESS_CHILD SET STATUS_JOB = 'P' WHERE REQ_ID = @REQ_ID AND TYPE_JOB = 'XL' AND TLNAME = 'anhtm1' |