|
1
|
DECLARE @REQ_ID VARCHAR(15)
|
|
2
|
SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0075/2021/TTr-0690405')
|
|
3
|
EXEC dbo.PL_REQUEST_PROCESS_App @p_REQ_ID = @REQ_ID, -- varchar(15)
|
|
4
|
@p_AUTH_STATUS = 'A', -- varchar(1)
|
|
5
|
@p_CHECKER_ID = 'trungnq1', -- varchar(15)
|
|
6
|
@p_APPROVE_DT = '2021-08-16 12:00:00 AM', -- datetime
|
|
7
|
@p_ROLE_LOGIN = 'TGD', -- varchar(50)
|
|
8
|
@p_BRANCH_LOGIN = 'DV0001', -- varchar(15)
|
|
9
|
@p_PROCESS_DESC = N'Phê duyệt' -- nvarchar(max)
|
|
10
|
|
|
11
|
DELETE FROM PL_PROCESS WHERE REQ_ID =@REQ_ID AND CHECKER_ID ='trungnq1'
|
|
12
|
DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='TGD'
|
|
13
|
|
|
14
|
SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0077/2021/TTr-0690405')
|
|
15
|
EXEC dbo.PL_REQUEST_PROCESS_App @p_REQ_ID = @REQ_ID, -- varchar(15)
|
|
16
|
@p_AUTH_STATUS = 'A', -- varchar(1)
|
|
17
|
@p_CHECKER_ID = 'trungnq1', -- varchar(15)
|
|
18
|
@p_APPROVE_DT = '2021-08-16 12:00:00 AM', -- datetime
|
|
19
|
@p_ROLE_LOGIN = 'TGD', -- varchar(50)
|
|
20
|
@p_BRANCH_LOGIN = 'DV0001', -- varchar(15)
|
|
21
|
@p_PROCESS_DESC = N'Phê duyệt' -- nvarchar(max)
|
|
22
|
|
|
23
|
DELETE FROM PL_PROCESS WHERE REQ_ID =@REQ_ID AND CHECKER_ID ='trungnq1'
|
|
24
|
DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='TGD'
|