Project

General

Profile

FILE APP_REQUEST_DOC.txt

Truong Nguyen Vu, 10/20/2020 01:32 PM

 
1
EXEC dbo.PL_REQUEST_PROCESS_App @p_REQ_ID = '',                        -- varchar(15)
2
                                @p_AUTH_STATUS = '',                   -- varchar(1)
3
                                @p_CHECKER_ID = '',                    -- varchar(15)
4
                                @p_APPROVE_DT = '2020-10-20 06:29:14', -- datetime
5
                                @p_ROLE_LOGIN = '',                    -- varchar(50)
6
                                @p_BRANCH_LOGIN = '',                  -- varchar(15)
7
                                @p_PROCESS_DESC = N''                  -- nvarchar(max)
8
EXEC dbo.PL_REQ_PROCESS_CHILD_App @p_REQ_ID = '',       -- varchar(20)
9
                                  @p_PROCESS_ID = '',   -- varchar(20)
10
                                  @p_TLNAME = '',       -- varchar(20)
11
                                  @p_MAKER_ID = '',     -- varchar(20)
12
                                  @p_TYPE_JOB = '',     -- varchar(20)
13
                                  @p_PROCESS_DES = N'', -- nvarchar(20)
14
                                  @p_REF_ID = 0         -- int
15

    
16

    
17
EXEC dbo.PL_REQUEST_DOC_App @p_REQ_ID = '',                        -- varchar(15)
18
                            @p_AUTH_STATUS = '',                   -- varchar(1)
19
                            @p_CHECKER_ID = '',                    -- varchar(15)
20
                            @p_APPROVE_DT = '2020-10-20 06:29:28', -- datetime
21
                            @p_ROLE_LOGIN = '',                    -- varchar(50)
22
                            @p_BRANCH_LOGIN = '',                  -- varchar(15)
23
                            @p_PROCESS_DES = N''                   -- nvarchar(500)