-- -- faq__new_q_and_a/10 -- create or replace function faq__new_q_and_a( p_entry_id integer, p_faq_id integer, p_question text, p_answer text, p_sort_key integer, p_object_type character varying, p_creation_date timestamp with time zone, p_creation_user integer, p_creation_ip character varying, p_context_id integer ) returns int4 as $$ DECLARE v_entry_id faq_q_and_as.entry_id%TYPE; v_package_id acs_objects.package_id%TYPE; BEGIN select package_id into v_package_id from acs_objects where object_id = p_faq_id; v_entry_id := acs_object__new ( p_entry_id, p_object_type, p_creation_date, p_creation_user, p_creation_ip, p_context_id, 't', p_question, v_package_id ); insert into faq_q_and_as (entry_id, faq_id, question, answer, sort_key) values (v_entry_id, p_faq_id, p_question, p_answer, p_sort_key); return v_entry_id; END; $$ language plpgsql;