DELETE FROM dbo.PL_REQUEST_PROCESS WHERE REQ_ID='PLRD00000200412'
DELETE FROM dbo.PL_PROCESS WHERE REQ_ID='PLRD00000200412'

UPDATE dbo.PL_TRADEDETAIL SET AMT_APP = AMT_APP + 203775000 WHERE TRADE_ID='PLT000000071040'

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'PLRD00000200412',N'APPNEW',N'P',N'GDDV',N'DV0001',N'hoacq',N'Oct 22 2020  5:10PM',NULL,N'N',NULL,NULL,N'Trưởng đơn vị phê duyệt',NULL,N'DEP000000000015')
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'PLRD00000200412',N'DVCM',N'P',N'GDDV',N'',N'namdt',N'Oct 22 2020  5:13PM',N'APPNEW',N'N',N'',N'DM0000000000006',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'PLRD00000200412',N'TC',N'P',N'TC',N'',N'hoattm',N'Oct 22 2020  5:13PM',N'DVCM',N'N',N'',N'',N'Phòng tài chính đã 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'PLRD00000200412',N'GDK_DC',N'P',N'PTGD',N'',N'tupa',N'Oct 22 2020 10:12AM',N'TC',N'N',N'',N'DM0000000000017',N'Giám đốc khối đã phê duyệ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'PLRD00000200412',N'TGD_DC',N'C',N'TGD',N'',N'',NULL,N'GDK_DC',N'',N'',N'',N'Chờ tổng giám đốc phê duyệ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'PLRD00000200412',N'APPROVE',N'U',N'',N'',N'',NULL,N'TGD_DC',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'PLRD00000200412',N'GDK_DC',N'P',N'GDK',N'',N'cuongpv2',N'Oct 22 2020 10:12AM',N'TC',N'',N'',N'DM0000000000022',N'Giám đốc khối đã phê duyệt',NULL,N'')


INSERT INTO [PL_PROCESS] ([REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(N'PLRD00000200412',N'SEND',N'tuyentt',N'Oct 22 2020  8:52AM',N'Người tạo tờ trình gửi phê duyệt thành công',N'Nhân viên gửi phê duyệt')
INSERT INTO [PL_PROCESS] ([REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(N'PLRD00000200412',N'APPNEW',N'hoacq',N'Oct 22 2020  5:06PM',N'Phê duyệt',N'Trưởng đơn vị phê duyệt')
INSERT INTO [PL_PROCESS] ([REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(N'PLRD00000200412',N'DVCM',N'namdt',N'Oct 22 2020  5:13PM',N'',N'Trưởng đơn vị đã phê duyệt')
INSERT INTO [PL_PROCESS] ([REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(N'PLRD00000200412',N'TC',N'hoattm',N'Oct 22 2020  5:13PM',N'Phê duyệt',N'Trưởng đơn vị đã phê duyệt')
INSERT INTO [PL_PROCESS] ([REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(N'PLRD00000200412',N'GDK_DC',N'tupa',N'Oct 22 2020  5:17PM',N'',N'Giám đốc khối đã phê duyệt')
INSERT INTO [PL_PROCESS] ([REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(N'PLRD00000200412',N'GDK_DC',N'cuongpv2',N'Oct 22 2020  5:17PM',N'',N'Giám đốc khối đã phê duyệt')


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

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