update acs_objects
set context_id = :new_package_id,package_id=:new_package_id
where object_id = :object_id
update acs_objects
set package_id = :new_package_id
where context_id = :object_id
UPDATE acs_objects
SET context_id = :trash_package_id,package_id=:trash_package_id
WHERE object_id = :object_id
UPDATE acs_objects
SET package_id = :trash_package_id
WHERE context_id = :object_id
SELECT b.object_id as package_id
FROM acs_objects as a,acs_objects as b
WHERE a.context_id=:selected_community and a.object_type='apm_package' and a.object_id=b.context_id and b.title='FAQ';
SELECT faq_name,separate_p
FROM faqs
WHERE faq_id=:object_id;
SELECT question,
answer
FROM faq_q_and_as
WHERE faq_id=:object_id;
select faq__new_q_and_a (
:entry_id,
:faq_id,
:one_question,
:one_answer,
:sort_key,
'faq_q_and_a',
now(),
:user_id,
:creation_ip,
:faq_id
);
--SELECT FAQS
select f.faq_id,
f.faq_name,
f.separate_p,
f.disabled_p,
ao.creation_ip,
ao.context_id,
u.username as creation_user
from faqs f,
acs_objects ao,
users u
where f.faq_id = ao.object_id and
f.faq_id = :object_id and
ao.creation_user = u.user_id
--SELECT FAQ_Q_AND_AS
select question,
answer
from faq_q_and_as
where faq_id = :faq_id
order by sort_key