Project

General

Profile

TR_REQUEST_APP_SCRIPT.txt

Truong Nguyen Vu, 09/04/2020 02:13 PM

 
1
EXEC dbo.TR_REQ_PROCESS_CHILD_App @p_REQ_ID = '',       -- varchar(20)
2
                                  @p_PROCESS_ID = '',   -- varchar(20)
3
                                  @p_TLNAME = '',       -- varchar(20)
4
                                  @p_MAKER_ID = '',     -- varchar(20)
5
                                  @p_TYPE_JOB = '',     -- varchar(20)
6
                                  @p_PROCESS_DES = N'', -- nvarchar(500)
7
                                  @p_REF_ID = 0,        -- int
8
                                  @p_XMLDATA = NULL     -- xml
9

    
10
EXEC dbo.TR_REQUEST_PROCESS_App @p_REQ_ID = '',                        -- varchar(15)
11
                                @p_AUTH_STATUS = '',                   -- varchar(1)
12
                                @p_CHECKER_ID = '',                    -- varchar(15)
13
                                @p_APPROVE_DT = '2020-09-04 07:15:19', -- datetime
14
                                @p_ROLE_LOGIN = '',                    -- varchar(50)
15
                                @p_BRANCH_LOGIN = '',                  -- varchar(15)
16
                                @p_PROCESS_DESC = N'',                 -- nvarchar(max)
17
                                @p_XMLDATA = NULL                      -- xml
18