UPDATE dbo.TR_REQUEST_DOC SET PROCESS_ID='APPROVE' WHERE REQ_ID='TRRDI0000100088'
	DECLARE @ID INT
	INSERT INTO dbo.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
		(   'TRRDI0000100088',        -- REQ_ID - varchar(15)
		    'DMMS',        -- PROCESS_ID - varchar(10)
		    'C',        -- STATUS - varchar(5)
		    'GDDV',        -- ROLE_USER - varchar(50)
		    '',        -- BRANCH_ID - varchar(15)
		    '',        -- CHECKER_ID - varchar(15)
			NULL, -- APPROVE_DT - datetime
		    '',        -- PARENT_PROCESS_ID - varchar(10)
		    '',        -- IS_LEAF - varchar(1)
		    '',        -- COST_ID - varchar(15)
		    '',        -- DVDM_ID - varchar(15)
		    N'',       -- NOTES - nvarchar(500)
		    1,      -- IS_HAS_CHILD - bit
		    ''         -- DEP_ID - varchar(20)
		    )
			
				SET @ID = (SELECT ID FROM dbo.PL_REQUEST_PROCESS WHERE REQ_ID='TRRDI0000100088' AND PROCESS_ID='DMMS')


				INSERT INTO dbo.PL_REQUEST_PROCESS_CHILD
				(
				    REQ_ID,
				    PROCESS_ID,
				    TLNAME,
				    TYPE_JOB,
				    LEVEL_JOB,
				    STATUS_JOB,
				    RECORD_STATUS,
				    MAKER_ID,
				    TRANFER_DT
				)
				VALUES
				(   'TRRDI0000100088',       -- REQ_ID - varchar(20)
				    @ID,       -- PROCESS_ID - varchar(20)
				    'phuongtln1',       -- TLNAME - varchar(50)
				    'TP',       -- TYPE_JOB - varchar(50)
				    1,        -- LEVEL_JOB - int
				    'U',       -- STATUS_JOB - varchar(10)
				    '1',       -- RECORD_STATUS - varchar(15)
				    '',       -- MAKER_ID - varchar(15)
				    GETDATE() -- TRANFER_DT - datetime
				    )
					INSERT INTO dbo.PL_REQUEST_PROCESS_CHILD
				(
				    REQ_ID,
				    PROCESS_ID,
				    TLNAME,
				    TYPE_JOB,
				    LEVEL_JOB,
				    STATUS_JOB,
				    RECORD_STATUS,
				    MAKER_ID,
				    TRANFER_DT
				)
				VALUES
				(   'TRRDI0000100088',       -- REQ_ID - varchar(20)
				    @ID,       -- PROCESS_ID - varchar(20)
				    'vanpt2',       -- TLNAME - varchar(50)
				    'KS',       -- TYPE_JOB - varchar(50)
				    2,        -- LEVEL_JOB - int
				    'U',       -- STATUS_JOB - varchar(10)
				    '1',       -- RECORD_STATUS - varchar(15)
				    '',       -- MAKER_ID - varchar(15)
				    GETDATE() -- TRANFER_DT - datetime
				    )
				INSERT INTO dbo.PL_REQUEST_PROCESS_CHILD
				(
				    REQ_ID,
				    PROCESS_ID,
				    TLNAME,
				    TYPE_JOB,
				    LEVEL_JOB,
				    STATUS_JOB,
				    RECORD_STATUS,
				    MAKER_ID,
				    TRANFER_DT
				)
				VALUES
				(   'TRRDI0000100088',       -- REQ_ID - varchar(20)
				    @ID,       -- PROCESS_ID - varchar(20)
				    'tuyenlt',       -- TLNAME - varchar(50)
				    'XL',       -- TYPE_JOB - varchar(50)
				    3,        -- LEVEL_JOB - int
				    'C',       -- STATUS_JOB - varchar(10)
				    '1',       -- RECORD_STATUS - varchar(15)
				    '',       -- MAKER_ID - varchar(15)
				    GETDATE() -- TRANFER_DT - datetime
				    )