create procedure dbo.%PROC% @sid varchar(30) = null,
.ARGLIST(ALL,0)
as
declare @action_id numeric,
        @id numeric,
        @user_id numeric,
        @state_id numeric,
        @type_id numeric,
        @item_name varchar(100),
        @new_state_id numeric
begin
begin tran

select @action_id = %ACTION_ID%
select @id = convert(numeric, @sid)

.CHECK_USER
.CHECK_UPDATE

.ARGCONVERT(ALL,0)

.INIT_VARS

if rtrim(ltrim(.GET_CONST('CLIENT_CODE'))) <> 'WEBINVEST'
.TEST_UNIQUE

select @is_company=0

select @partner_name = ltrim(rtrim(@f_last_name + " " + @f_first_name + " " + isnull(@f_middle_name, '') ))
select @partner_short_name = ltrim(rtrim(@f_last_name + " " + .FIRST_LETTER(@f_first_name) + "." +  isnull(.FIRST_LETTER(@f_middle_name) + ".",'') ))

.UPDATE_ITEMS

.UPDATE(ALL,0)

/*.RELGEN*/
.UPDATE_STATE
.ACTION_HISTORY

commit tran
select sid = convert(varchar, @id)
end