This statement is ANSI SQL:2011 compliant, but includes non-ANSI Teradata extensions.
The requirement that parentheses appear when the argument list is empty is a Teradata extension to preserve compatibility with existing applications.
The RETURNS data_type or RETURNS STYLE clauses are Teradata extensions to the ANSI SQL standard.