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(N'PLRD00000200424',N'APPNEW',N'P',N'GDDV',N'DV0001',N'thanhnt',N'Oct 26 2020  1:10PM',NULL,N'N',NULL,NULL,N'Trưởng đơn vị phê duyệt',NULL,N'DEP000000000062')
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(N'PLRD00000200424',N'DVCM',N'P',N'GDDV',N'',N'hungnt4',N'Oct 26 2020  1:22PM',N'APPNEW',N'N',N'',N'DM0000000000001',N'Phòng kế toán đã phê duyệt',1,NULL)
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(N'PLRD00000200424',N'GDK_TT',N'P',N'GDK',N'',N'nhannt',N'Oct 26 2020  6:32AM',N'TC',N'N',N'',N'DM0000000000023',N'Giám đốc khối đã phê duyệt',0,NULL)
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(N'PLRD00000200424',N'PTGDK_TT',N'P',N'PTGD',N'',N'tupa',N'Oct 26 2020  6:32AM',N'GDK_TT',N'N',N'',N'DM0000000000017',N'Phó tổng giám đốc khối đã phê duyệt',0,NULL)
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(N'PLRD00000200424',N'TGD',N'C',N'TGD',N'',N'',NULL,N'PTGDK_TT',N'N',N'',N'',N'Chờ tổng giám đốc xác nhận',0,NULL)
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(N'PLRD00000200424',N'APPROVE',N'U',N'',N'',N'',NULL,N'TGD',N'Y',NULL,NULL,N'Hoàn tất',NULL,NULL)
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(N'PLRD00000200424',N'TC',N'P',N'TC',N'',N'hoattm',N'Oct 26 2020  1:30PM',N'DVCM',N'N',N'',N'',N'Phòng tài chính đã phê duyệt',0,NULL)

UPDATE dbo.PL_REQUEST_DOC SET PROCESS_ID='TGD' WHERE REQ_ID='PLRD00000200424'      

EXEC dbo.PL_REQUEST_PROCESS_App @p_REQ_ID = 'PLRD00000200424',                        -- varchar(15)
                                @p_AUTH_STATUS = 'A',                   -- varchar(1)
                                @p_CHECKER_ID = 'trungnq1',                    -- varchar(15)
                                @p_APPROVE_DT = '2020-10-26 06:32:14', -- datetime
                                @p_ROLE_LOGIN = 'TGD',                    -- varchar(50)
                                @p_BRANCH_LOGIN = 'DV0001',                  -- varchar(15)
                                @p_PROCESS_DESC = N'Phê duyệt'                  -- nvarchar(max)