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

  select @action_id = %ACTION_ID%
   select @id = convert(numeric, @sid)
/*
.CHECK_USER
.CHECK_UPDATE
*/
.GET_PROPS


---.UPDATE_STATE
.ACTION_HISTORY

declare @is_comis int,
        @oper_id numeric,
        @fact_date datetime

     select @fact_date=@in_date

     select @oper_id=null

.BACK_BSPARMS_BEGIN
.BACK_BSPARMS_GET(@id)

declare @subc_str_4_1 varchar(255),
@back_sec_plan_id numeric,
@out_method_id numeric,
@plan_money numeric,
@money_plan_cur_id numeric,
@broker_id numeric,
@is_realiz int,
@iz_p2l_comis int,
@is_com_in int,
@is_allow_short4stocks int,
@is_allow_short4money int,
@asset4pereoc_type_id numeric

select @subc_str_4_1=''

.BACK_GET_ORG_PARMS(@owner_id,@broker_id,@plan_money,@back_sec_plan_id,@out_method_id,@is_realiz,@iz_p2l_comis,@is_com_in,@is_allow_short4stocks,@is_allow_short4money,@asset4pereoc_type_id)

declare @direct_id numeric,
@object_id numeric

.BACK_GET_OBJ2BROK2TS(@asset_place_id,@owner_id,@direct_id,@object_id)

declare @subc_str varchar(255)
select @subc_str=@bs1_investor_subc_str

.SUBC_STR_ADD(@subc_str,'stock_emis',@stock_id)
.SUBC_STR_ADD(@subc_str,'doc_sec',@id)

declare
@fin_result int

if exists(select 1 from tb_contracts where id=@client_contract_id)
begin
   select @fin_result=(select fin_result from tb_contracts where id=@client_contract_id)
end else
begin
   select @fin_result=1
end

.BACK_CURSOR_FOR_COMIS(@id,@fact_date,@id,@oper_id,@action_id,@action_history_id,@owner_id,1,@plan_money,@fin_result,@character_id,@subc_str,@is_realiz,@iz_p2l_comis)

select @money_plan_cur_id=(select cur_id from t_plans where id = @plan_money)

if @character_id=2 select @broker_id=@client_contract_id

.SUBC_STR_ADD(@subc_str_4_1,'investors',@broker_id)
.SUBC_STR_ADD(@subc_str_4_1,'investor2portfolio',@portfolio_sub_id)
.SUBC_STR_ADD(@subc_str_4_1,'portfolio',@portfolio_id)
.SUBC_STR_ADD(@subc_str_4_1,'DOC_SEC',@id)

.BACK_CORRECT_OPERATION_OUTBROK(@id,@fact_date,@id,@oper_id,@action_id,@action_history_id,@owner_id,@subc_str_4_1,@character_id,@plan_money,@money_plan_cur_id)

/*-------Проводки ----------*/

end

---commit tran