Will this syntax work:
fcn_stats are all in the same schema
CREATE OR REPLACE FUNCTION insert_stats(p_date date)
RETURNS void AS $$
BEGIN
insert into stats (
date,
stats1,
stats2
) (select
p_date,
fcn_stats1(p_date,'basic'),
fcn_stats2(p_date,'basic',0)
from dual
);
END;
$$ LANGUAGE 'plpgsql';