DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

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