oracle8.1.6
begin
acs_object_type.create_type (
object_type => :content_type,
pretty_name => :pretty_name,
pretty_plural => :pretty_plural,
supertype => 'content_revision',
table_name => :content_type,
id_column => :content_type
);
end;
begin
:1 := acs_attribute.create_attribute (
object_type => :content_type,
attribute_name => :a_name,
datatype => :a_datatype,
pretty_name => :a_pretty_name,
pretty_plural => :a_pretty_plural,
default_value => :a_default,
min_n_values => 1,
max_n_values => 1,
storage => 'generic'
);
end;
begin
:1 := etp.create_page(
package_id => :package_id,
name => :name,
title => :title,
content_type => :content_type
);
end;
select object_id as package_id
from site_nodes
where node_id = site_node.node_id(:url_stub, null)
select 1 from cr_items
where parent_id = etp.get_folder_id(:package_id)
and name = :name
select i.item_id, i.name, r.revision_id, r.title,
r.description, r.publish_date, r.content $extended_attributes
from cr_items i, cr_revisions r
where i.parent_id = etp.get_folder_id(:package_id)
and i.name = :name
and i.item_id = r.item_id
and r.revision_id = i.live_revision
select i.item_id, i.name, r.revision_id, r.title,
r.description, r.publish_date, r.content $extended_attributes
from cr_items i, cr_revisions r
where i.parent_id = etp.get_folder_id(:package_id)
and i.name = :name
and i.item_id = r.item_id
and r.revision_id = :revision_id
select max(revision_id) as revision_id
from cr_revisions r, cr_items i
where i.parent_id = etp.get_folder_id(:package_id)
and i.name = :name
and i.item_id = r.item_id
select live_revision as revision_id
from cr_items i
where i.parent_id = etp.get_folder_id(:package_id)
and i.name = :name
select * from
(select * from (
select $columns
from cr_items i, cr_revisions r
where i.parent_id = etp.get_folder_id(:package_id)
and i.name != 'index'
and i.live_revision = r.revision_id(+)
) attributes
where $extra_where_clauses
order by $orderby)
$limit_clause
select child.name, child.node_id, child.object_id as package_id,
etp.package_title(child.object_id) as title,
etp.package_description(child.object_id) as description
from site_nodes parent, site_nodes child, apm_packages p
where parent.object_id = :package_id
and child.parent_id = parent.node_id
and child.object_id = p.package_id
and p.package_key = 'edit-this-page'
etp.get_attribute_value(r.revision_id, $attribute_id)
sort_order
i.item_id, i.name,
to_char(r.publish_date, 'Mon DD, YYYY') as publish_date, rownum as sort_order,
(select object_type from acs_objects
where object_id = i.item_id) as object_type,
etp.get_relative_url(i.item_id, i.name) as url,
etp.get_title(i.item_id, r.title) as title,
etp.get_description(i.item_id, r.description) as description