oracle8.1.7 select node_id, object_id, site_node.url(node_id) as url from site_nodes begin apm_package.delete(:p_package_id); end; begin apm_package.delete(: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.delete(: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(:p_news_id); end; begin :1 := news.name(news_id => :p_news_id); end;