select page_id, sort_key
from portal_pages
where portal_id = :portal_id
and pretty_name = :fs_link
update portal_element_map
set page_id = :page_id,
state = 'full'
where element_id = :element_id
select cp.man_id, cp.fs_package_id, cp.folder_id
from ims_cp_manifests cp, -- acs_objects acs, ims_cp_manifest_class cpmc
where cp.man_id = cpmc.man_id
and cpmc.lorsm_instance_id = :package
and cpmc.isenabled = 't'
order by cp.man_id desc -- acs.creation_date desc
select i.ims_item_id as item_id, i.item_title as item_title
from ims_cp_items i
where i.org_id = :org_id
and exists
(select 1
from acs_object_party_privilege_map p
where p.object_id = i.ims_item_id
and p.party_id = :user_id
and p.privilege = 'read')
order by i.ims_item_id
select key
from fs_folders
where folder_id = :folder_id
select href
from ims_cp_resources r, ims_cp_items_to_resources ir
where ir.ims_item_id = :item_id and ir.res_id = r.res_id