Annotation: transactions.perform_eod_operation

Information: transactions.perform_eod_operation

Implementation: transactions.perform_eod_operation

CREATE OR REPLACE FUNCTION transactions.perform_eod_operation(_login_id bigint)
 RETURNS boolean
 LANGUAGE plpgsql
AS $function$
    DECLARE _user_id    integer;
    DECLARE _office_id integer;
    DECLARE _value_date date;
BEGIN
    SELECT 
        user_id,
        office_id,
        transactions.get_value_date(office_id)
    INTO
        _user_id,
        _office_id,
        _value_date
    FROM audit.logins
    WHERE login_id=$1;

    RETURN transactions.perform_eod_operation(_user_id, _office_id, _value_date);
END
$function$