oracle8.1.6
select
element_id,
name,
datasource_id,
template_id,
description,
config_id,
exportable_p,
filename,
decode(acs_permission.permission_p(element_id, :user_id, 'read'), 't', 1, 'f', 0) as element_read_p,
decode(acs_permission.permission_p(template_id, :user_id, 'read'), 't', 1, 'f', 0) as template_read_p
from portal_elem_tmpl
where
element_id = :element_id
select key, value
from portal_element_parameters
where
config_id = :config_id and
acs_permission.permission_p(config_id, :user_id, 'read') = 't'
order by key
select
datasource_id,
name,
description,
content,
mime_type,
data_type,
default_config_id,
decode(acs_permission.permission_p(datasource_id, :user_id, 'read'), 't', 1, 'f', 0) as datasource_read_p
from portal_datasources
where datasource_id = :datasource_id
select m.element_id, m.region, m.sort_key
from portal_element_map m
where m.portal_id = :portal_id and
acs_permission.permission_p(m.element_id, :user_id, 'read') = 't'
order by region, sort_key, element_id
select portal.parent(default_portal_id) as info_value
from (
select portal_id as default_portal_id
from portals
where package_id = :package_id and owner_id is null
)
select
region,
decode(immutable_p, 't', 1, 'f', 0) as immutable_p
from portal_supported_regions
where template_id = :template_id