-- TO TRINH CHU TRUONG
DECLARE @REQ_ID VARCHAR(15)
SET @REQ_ID = (SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='')
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID
---PYCMS
SET @REQ_ID = (SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='')
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID
---- UPDATE
UPDATE PL_REQUEST_PROCESS SET PROCESS_ID ='' WHERE REQ_ID =@REQ_ID AND ID =''
UPDATE PL_REQUEST_PROCESS SET STATUS ='' WHERE REQ_ID =@REQ_ID AND ID =''
UPDATE PL_REQUEST_PROCESS SET ROLE_USER ='' WHERE REQ_ID =@REQ_ID AND ID =''
UPDATE PL_REQUEST_PROCESS SET BRANCH_ID ='' WHERE REQ_ID =@REQ_ID AND ID =''
UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='' WHERE REQ_ID =@REQ_ID AND ID =''
UPDATE PL_REQUEST_PROCESS SET IS_LEAF ='' WHERE REQ_ID =@REQ_ID AND ID =''
UPDATE PL_REQUEST_PROCESS SET COST_ID ='' WHERE REQ_ID =@REQ_ID AND ID =''
UPDATE PL_REQUEST_PROCESS SET DVDM_ID ='' WHERE REQ_ID =@REQ_ID AND ID =''
UPDATE PL_REQUEST_PROCESS SET IS_HAS_CHILD ='' WHERE REQ_ID =@REQ_ID AND ID =''
UPDATE PL_REQUEST_PROCESS SET DEP_ID ='' WHERE REQ_ID =@REQ_ID AND ID =''
-- PROCESS_CHILD
UPDATE PL_REQUEST_PROCESS_CHILD SET PROCESS_ID ='' WHERE REQ_ID =@REQ_ID AND ID =''
UPDATE PL_REQUEST_PROCESS_CHILD SET TLNAME ='' WHERE REQ_ID =@REQ_ID AND ID =''
UPDATE PL_REQUEST_PROCESS_CHILD SET TYPE_JOB ='' WHERE REQ_ID =@REQ_ID AND ID =''
UPDATE PL_REQUEST_PROCESS_CHILD SET LEVEL_JOB ='' WHERE REQ_ID =@REQ_ID AND ID =''
UPDATE PL_REQUEST_PROCESS_CHILD SET STATUS_JOB ='' WHERE REQ_ID =@REQ_ID AND ID =''

-- GEN PYCMS TU TT CHU TRUONG
EXEC PL_REQ_DOC_Ins_To_TR_REQ_DOC @REQ_ID
-- GEN PO TU PYCMS
EXEC TR_REQ_DOC_Ins_To_PO @REQ_ID
--- THEM 1 BUOC VAO QUY TRINH
INSERT INTO PL_REQUEST_PROCESS (REQ_ID,PROCESS_ID,STATUS,ROLE_USER,BRANCH_ID,CHECKER_ID,APPROVE_DT,PARENT_PROCESS_ID,
IS_LEAF, COST_ID,DVDM_ID,NOTES,IS_HAS_CHILD,DEP_ID) VALUES (@REQ_ID,.....)
--- THEM 1 BUOC VAO DIEU PHOI
INSERT INTO PL_REQUEST_PROCESS_CHILD(REQ_ID,PROCESS_ID,TLNAME,TYPE_JOB,LEVEL_JOB,STATUS_JOB,RECORD_STATUS,MAKER_ID,TRANFER_DT) VALUES (@REQ_ID,..)
-- XOA 1 BUOC KHOI QUY TRINH
DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID AND ID =''
DELETE FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID AND ID =''
--- CAP NHAT LAI NGAN SACH
DECLARE @TRADE_ID VARCHAR(15), @PLAN_ID VARCHAR(15)
SET @TRADE_ID = (SELECT TRADE_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID)
---
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID =@TRADE_ID
SELECT * FROM PL_MASTER WHERE PLAN_ID =@PLAN_ID
-- CAP NHAT
UPDATE PL_TRADEDETAIL SET AMT_ETM=0, AMT_APP=0, AMT_EXE=0, AMT_RECEIVE_TF=0, AMT_TF =0 WHERE TRADE_ID =@TRADE_ID
-- CAP NHAT CHI PHI AM
UPDATE PL_TRADEDETAIL SET AMT_APP = ABS(AMT_APP)