postgresql 7.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, null );
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);