UPDATE  TR_REQUEST_DOC_DT SET PRICE =28588389, TOTAL_AMT=28588389 WHERE REQ_DOC_ID =(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE='PUR/2023/000116') AND PRICE =28588388
UPDATE TR_REQUEST_DOC SET TOTAL_AMT= TOTAL_AMT +1 WHERE REQ_CODE='PUR/2023/000116'
UPDATE TR_REQUEST_DOC SET PROCESS_ID='', AUTH_STATUS='E', APPROVE_DT=NULL, CHECKER_ID='' WHERE REQ_CODE='PUR/2023/000176'