PROCEDURE get_user_company_cif(
    prm_id_in      IN NUMBER
    ,own_cif_out   OUT NUMBER
    ,po_err_code   OUT VARCHAR2
    ,po_err_desc   OUT VARCHAR2)
  IS
  BEGIN

   SELECT vbt_owners.own_cif
    INTO own_cif_out
    FROM hdt_permits
    JOIN vibank.vbt_owners ON (prm_own_id = own_id AND prm_id = prm_id_in);

   EXCEPTION
    WHEN OTHERS THEN
      po_err_code:=01001125;
      po_err_desc:='Wystapil blad podczas proby pobierania cif dla uzytkownika, prm_id = ' ||prm_id_in||'. ( '||SQLERRM||' )';
      Hdp_Log.fatal('hdp_adk', 'get_user_company_cif', po_err_code, po_err_desc||' ('') '||SQLERRM);

  END;

-- next err code = 01001125