create procedure dbo.%PROC% @sid varchar(30) = null, .ARGLIST as .BEGIN('N') .CHECK_USER .CHECK_UPDATE .ARGCONVERT select @open_date=getdate() select @is_company=1 .INIT_VARS if rtrim(ltrim(.GET_CONST('CLIENT_CODE'))) <> 'WEBINVEST' .TEST_UNIQUE begin tran .UPDATE_ITEMS .UPDATE .RELGEN .UPDATE_STATE .ACTION_HISTORY commit tran select sid = convert(varchar, @id) .END