case (@block_type)
        when  0  then
            if exists (select  1  from ITSIDBO.NOMENCLATURE_PLAN_CTC where CTC_ID = @ctc_id and NOM_ID = @nom_id) then
                select CTC_NOM_ID into @ctc_nom_id from ITSIDBO.NOMENCLATURE_PLAN_CTC where CTC = @ctc_id and NOM_ID = @nom_id;
                set @msg = ITSIDBO.ACL_OBJECT_LOCK_SET( 197 , @ctc_nom_id,  2000 , @current_user_id,  0 );
            end if;

        when  1  then
            select PUD_ID, "NUMBER" into @pud_id, @number from ITSIDBO.CTC where CTC_ID = @ctc_id;
            select first @msg = #TMP.MSG 
                    from (select ITSIDBO.ACL_OBJECT_LOCK_SET( 197 , CTC_NOM_ID,  2000 , @current_user_id,  0 ) as MSG 
                                from ITSIDBO.CTC
                                    join ITSIDBO.NOMENCLATURE_PLAN_CTC on NOMENCLATURE_PLAN_CTC.CTC_ID = CTC.CTC_ID
                                where NOMENCLATURE_PLAN_CTC.NOM_ID = @nom_id and CTC.PUD_ID = @pud_id and CTC.NUMBER = @number
                          ) as #TMP
                    where  #TMP.MSG <> '' order by	 1  asc;
    end case;

  if(@block_type) = 
   0 
    if exists(select  1  from ITSIDBO.NOMENCLATURE_PLAN_CTC where CTC_ID = @ctc_id and NOM_ID = @nom_id)
      begin
        select @ctc_nom_id = CTC_NOM_ID from ITSIDBO.NOMENCLATURE_PLAN_CTC where CTC = @ctc_id and NOM_ID = @nom_id
        set @msg=ITSIDBO.ACL_OBJECT_LOCK_SET( 197 ,@ctc_nom_id, 2000 ,@current_user_id, 0 )
      end
  else if(@block_type) = 
   1  begin
      select @pud_id = PUD_ID,@number = NUMBER from ITSIDBO.CTC where CTC_ID = @ctc_id
      select first @msg = #TMP.MSG from
        (select MSG=ITSIDBO.ACL_OBJECT_LOCK_SET( 197 ,CTC_NOM_ID, 2000 ,@current_user_id, 0 ) from
          ITSIDBO.CTC join
          ITSIDBO.NOMENCLATURE_PLAN_CTC on NOMENCLATURE_PLAN_CTC.CTC_ID = CTC.CTC_ID where
          NOMENCLATURE_PLAN_CTC.NOM_ID = @nom_id and CTC.PUD_ID = @pud_id and CTC.NUMBER = @number) as #TMP where
        #TMP.MSG <> '' order by  1  asc
    end

select * from SYS.SYSPROCEDURE where PROC_NAME = 'XXX' and USER_NAME(CREATOR) = 'YYY';