DELETE FROM PL_PROCESS WHERE ID ='532260'
UPDATE PL_REQUEST_PROCESS_CHILD SET STATUS_JOB = 'C' WHERE ID ='184679'
UPDATE PL_REQUEST_PROCESS SET [STATUS] = 'C' WHERE ID = '104442'
UPDATE TR_REQUEST_DOC SET PROCESS_ID = 'DMMS' WHERE REQ_ID = 'TRRD00000258757'
DECLARE @p_REQ_ID varchar(20) = 'TRRD00000258757' 
DECLARE @p_PROCESS_ID varchar(20) = 'DMMS' 
DECLARE @p_TLNAME varchar(20) = 'sontv1' 
DECLARE @p_MAKER_ID varchar(20) = 'sontv1'
DECLARE @p_TYPE_JOB varchar(20) = 'TP'
DECLARE @p_PROCESS_DES nvarchar(max) = N'Phê duyệt'
DECLARE @p_REF_ID int = 0 
DECLARE @p_XMLDATA XML = NULL 

EXECUTE dbo.TR_REQ_PROCESS_CHILD_App @p_REQ_ID,@p_PROCESS_ID,@p_TLNAME,@p_MAKER_ID,@p_TYPE_JOB,@p_PROCESS_DES,@p_REF_ID,@p_XMLDATA