CREATE OR REPLACE FUNCTION "billing"."create_refusal_decree1788"("case_id_i" int4, "cert_num_i" varchar, "clinic_id_i" int4, "creation_date_i" varchar, "empl_issued_id_i" int4, "patient_id_i" int4, "period_begin_i" varchar, "period_end_i" varchar, "receiver_id_i" int4, "remark_i" varchar)
  RETURNS "pg_catalog"."int4" AS $BODY$
DECLARE
  cert_id_l INTEGER;
BEGIN
  INSERT INTO billing.services_cost_certificate (
    case_id, clinic_id, creation_date, employee_issued_id, number, patient_id, receiver_id, refused, remark)
  VALUES (
    case_id_i, clinic_id_i, to_date(creation_date_i, 'DD.MM.YYYY'), empl_issued_id_i, cert_num_i, patient_id_i, receiver_id_i, true, remark_i)
  RETURNING id
    INTO cert_id_l;
  RETURN cert_id_l;
END;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE COST 100
;