postgresql7.1 select node_id, object_id, site_node__url(node_id) as url from site_nodes select apm_package__delete(:p_package_id); select apm_package__delete(:p_package_id); select content_item_globals.c_root_folder_id; select news__new( null, null, current_timestamp, :p_text, null, :p_title, 'text/plain', :p_package_id, :p_archive_date, :p_approval_user, :p_approval_date, :p_approval_ip, null, null,null, :p_is_live,null ); select news__delete(:p_item_id); select news__revision_new( :p_item_id, current_timestamp, :p_text, :p_title, :p_description, 'text/plain', :p_package_id, :p_archive_date, :p_approval_user, :p_approval_date, :p_approval_ip, current_timestamp, null, null, :p_make_active_revision_p ); select content_item__get_live_revision(:p_item_id); select content_item__get_latest_revision(:p_item_id); select news__set_approve(:p_revision_id, :p_approve_p, null, null, null, null, null, null); select news__set_approve(:p_revision_id, :p_approve_p, :p_publish_date, :p_archive_date, :p_approval_user, :p_approval_date, :p_approval_ip, :p_live_revision_p); select news__revision_set_active(:p_revision_id); select news__revision_delete(:p_revision_id); select news__make_permanent(:p_item_id); select news__archive(:p_item_id); select news__archive(:p_item_id, :p_archive_date); select news__status(to_timestamp(:p_publish_date, 'YYYY-MM-DD'), to_timestamp(:p_archive_date, 'YYYY-MM-DD')); select news__name(:p_news_id);