select item_id
from cr_revisions
where revision_id=:object_id
select package_id
from cr_news
where news_id=:object_id
select max(o.last_modified)
from acs_objects o, cr_news n
where n.package_id=:package_id
and o.object_id=n.news_id
select ao.object_id as package_id
from acs_objects ao, apm_packages ap, dotlrn_communities_all dc
where ao.object_type = 'apm_package' and ao.context_id = dc.package_id and dc.community_id = :community_id and ao.object_id = ap.package_id and ap.package_key = 'news'
select news__new(
null, -- p_item_id
null, -- p_locale
:publish_date_ansi, -- p_publish_date
:publish_body, -- p_text
null, -- p_nls_language
:publish_title, -- p_title
:mime_type, -- p_mime_type
:package_id, -- p_package_id
:archive_date_ansi, -- p_archive_date
:approval_user, -- p_approval_user
:approval_date, -- p_approval_date
:approval_ip, -- p_approval_ip
null, -- p_relation_tag
:creation_ip, -- p_creation_ip
:user_id, -- p_creation_user
:live_revision_p -- p_is_live_p
)