oracle 8.1.6
select node_id, object_id, site_node.url(node_id) as url from site_nodes
begin apm_package.del(:p_package_id); end;
begin apm_package.del(:p_package_id); end;
select content_item.get_root_folder from dual
begin :1 := news.new( text => :p_text, title => :p_title, package_id => :p_package_id, archive_date => :p_archive_date, approval_user => :p_approval_user, approval_date => :p_approval_date, approval_ip => :p_approval_ip, is_live_p => :p_is_live ); end;
begin news.revision_delete(:p_revision_id); end;
begin :1 := news.revision_new( item_id => :p_item_id, text => :p_text, title => :p_title, description => :p_description, package_id => :p_package_id, archive_date => :p_archive_date, approval_user => :p_approval_user, approval_date => :p_approval_date, approval_ip => :p_approval_ip, make_active_revision_p => :p_make_active_revision_p ); end;
begin :1 := content_item.get_live_revision(:p_item_id); end;
begin :1 := content_item.get_latest_revision(:p_item_id); end;
begin news.set_approve(revision_id => :p_revision_id, approve_p => :p_approve_p); end;
begin news.set_approve(revision_id => :p_revision_id, approve_p => :p_approve_p, publish_date => :p_publish_date, archive_date => :p_archive_date, approval_user => :p_approval_user, approval_date => :p_approval_date, approval_ip => :p_approval_ip, live_revision_p => :p_live_revision_p); end;
begin news.revision_set_active(:p_revision_id); end;
begin news.del(:p_item_id); end;
begin news.make_permanent(:p_item_id); end;
begin news.archive(item_id => :p_item_id, archive_date => :p_archive_date); end;
begin news.archive(item_id => :p_item_id); end;
begin :1 := news.status(to_date(:p_publish_date, 'YYYY-MM-DD'), to_date(:p_archive_date, 'YYYY-MM-DD')); end;
begin :1 := news.name(news_id => :p_news_id); end;