ALTER PROCEDURE "dba"."kp_korrigeeri_koik"( in a_par char(40),in a_id1 integer, in a_s1 char(20) )
BEGIN
  declare ll_pos integer;
  set ll_pos=Locate(a_par,'_NULL');
  if ll_pos>1 then
    set a_id1=null;
    set a_s1=null;
    set a_par=Left(a_par,ll_pos-1);
  end if;
  case a_par
    when 'KandedKorrastadaKontod' then
      update "kp_kanne" left outer join "gl_selectall" on "kp_kanne"."id"="gl_selectall"."id1" and "kp_kanne"."aasta"="gl_selectall"."id2"
        set "kp_kanne"."konto"=a_s1 where "gl_selectall"."id1" is not null
    when 'KandedKorrastadaMeetmed' then
      update "kp_kanne" left outer join "gl_selectall" on "kp_kanne"."id"="gl_selectall"."id1" and "kp_kanne"."aasta"="gl_selectall"."id2"
        set "kp_kanne"."meetnr"=a_id1 where "gl_selectall"."id1" is not null
    when 'KandedKorrastadaKuluobjektid' then
      update "kp_kanne" left outer join "gl_selectall" on "kp_kanne"."id"="gl_selectall"."id1" and "kp_kanne"."aasta"="gl_selectall"."id2"
        set "kp_kanne"."kulnr"=a_id1 where "gl_selectall"."id1" is not null
    when 'KandedKorrastadaTegevusalad' then
      update "kp_kanne" left outer join "gl_selectall" on "kp_kanne"."id"="gl_selectall"."id1" and "kp_kanne"."aasta"="gl_selectall"."id2"
        set "kp_kanne"."talnr"=a_id1 where "gl_selectall"."id1" is not null
    when 'KandedKorrastadaKululiigid' then
      update "kp_kanne" left outer join "gl_selectall" on "kp_kanne"."id"="gl_selectall"."id1" and "kp_kanne"."aasta"="gl_selectall"."id2"
        set "kp_kanne"."artnr"=a_id1 where "gl_selectall"."id1" is not null
    when 'KandedKorrastadaTululiigid' then
      update "kp_kanne" left outer join "gl_selectall" on "kp_kanne"."id"="gl_selectall"."id1" and "kp_kanne"."aasta"="gl_selectall"."id2"
        set "kp_kanne"."tulnr"=a_id1 where "gl_selectall"."id1" is not null
    when 'KandedKorrastadaProjektid' then
      update "kp_kanne" left outer join "gl_selectall" on "kp_kanne"."id"="gl_selectall"."id1" and "kp_kanne"."aasta"="gl_selectall"."id2"
        set "kp_kanne"."objectnr"=a_id1 where "gl_selectall"."id1" is not null
    when 'KandedKorrastadaOsakonnad' then
      update "kp_kanne" left outer join "gl_selectall" on "kp_kanne"."id"="gl_selectall"."id1" and "kp_kanne"."aasta"="gl_selectall"."id2"
        set "kp_kanne"."osaknr"=a_id1 where "gl_selectall"."id1" is not null
    when 'KandedKorrastadaSubjektid' then
      update "kp_kanne" left outer join "gl_selectall" on "kp_kanne"."id"="gl_selectall"."id1" and "kp_kanne"."aasta"="gl_selectall"."id2"
        set "kp_kanne"."subjectnr"=a_id1 where "gl_selectall"."id1" is not null
    when 'KandedKorrastadaTegevussuunad' then
      update "kp_kanne" left outer join "gl_selectall" on "kp_kanne"."id"="gl_selectall"."id1" and "kp_kanne"."aasta"="gl_selectall"."id2"
        set "kp_kanne"."suundnr"=a_id1 where "gl_selectall"."id1" is not null
    when 'KandedKorrastadaTaotlused' then
      update "kp_kanne" left outer join "gl_selectall" on "kp_kanne"."id"="gl_selectall"."id1" and "kp_kanne"."aasta"="gl_selectall"."id2"
        set "kp_kanne"."taotnr"=a_id1 where "gl_selectall"."id1" is not null
    when 'KandedKorrastadaAllikad' then
      update "kp_kanne" left outer join "gl_selectall" on "kp_kanne"."id"="gl_selectall"."id1" and "kp_kanne"."aasta"="gl_selectall"."id2"
        set "kp_kanne"."alliknr"=a_id1 where "gl_selectall"."id1" is not null
    when 'KandedKorrastadaRahavood' then
      update "kp_kanne" left outer join "gl_selectall" on "kp_kanne"."id"="gl_selectall"."id1" and "kp_kanne"."aasta"="gl_selectall"."id2"
        set "kp_kanne"."ravonr"=a_id1 where "gl_selectall"."id1" is not null
  end case;
END