---

CREATE OR REPLACE PROCEDURE report.actualize_fns_vcht_number_sequence(
    p_new_number bigint
)
LANGUAGE plpgsql
AS $$
BEGIN
    IF p_new_number > (
        SELECT last_value
        FROM report.fns_vcht_number_sequence
    ) THEN
        PERFORM setval(
            'report.fns_vcht_number_sequence',
            p_new_number,
            true
        );
    END IF;
END;
$$;



CALL report.actualize_fns_vcht_number_sequence(
    CAST(:new_number AS bigint)
);