-- -- acs_message__new_extlink/9 -- create or replace function acs_message__new_extlink( character varying, integer, character varying, character varying, text, integer, timestamp with time zone, integer, character varying ) returns int4 as $$ declare p_name alias for $1; -- default null p_extlink_id alias for $2; -- default null p_url alias for $3; p_label alias for $4; -- default null p_description alias for $5; -- default null p_parent_id alias for $6; p_creation_date alias for $7; -- default sysdate p_creation_user alias for $8; -- default null p_creation_ip alias for $9; -- default null v_extlink_id cr_extlinks.extlink_id%TYPE; begin v_extlink_id := content_extlink__new ( p_name, -- name p_url, -- url p_label, -- label p_description, -- description p_parent_id, -- parent_id p_extlink_id, -- extlink_id p_creation_date, -- creation_date p_creation_user, -- creation_user p_creation_ip -- creation_ip ); return v_extlink_id; end;$$ language plpgsql;