create procedure dbo.%PROC% @sid varchar(30) = null,
.ARGLIST(ALL,1)
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 tran

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

.CHECK_USER
.CHECK_UPDATE

.ARGCONVERT(ALL,1)

if @in_no is null
  begin
    .INIT_VARS(AFTER,ALL,1)
    .BACK_GEN_NO(@in_no,@depo_doc_type,@in_date)
  end


--.TEST_UNIQUE(ALL,1)
SELECT @in_no = LTRIM(RTRIM(UPPER(@in_no))) 
.TEST_UNIQUE(ALL, 1, N)

.UPDATE(ALL,1)

.RELGEN
.UPDATE_STATE
.ACTION_HISTORY

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