news_items_archive (public)

 news_items_archive id_list when

Defined in packages/news/tcl/news-procs.tcl

Immediately gives all news items in list id_list a status of archived as of ANSI date in when, i.e. when must be like 2000-10-11.

Parameters:

id_list (required)

when (required)

Testcases:

No testcase defined.

Source code:

    foreach id $id_list {
        db_exec_plsql news_item_archive {}
    }

Generic XQL file:

packages/news/tcl/news-procs.xql

PostgreSQL XQL file:

<fullquery name="news_items_archive.news_item_archive">
    <querytext>

          select news__archive(
	      :id, -- item_id
	      :when -- archive_date
	  );

      </querytext>
</fullquery>

packages/news/tcl/news-procs-postgresql.xql

Oracle XQL file:

<fullquery name="news_items_archive.news_item_archive">
    <querytext>

	    begin
	    news.archive(
	        item_id => :id,
	        archive_date => :when);
	    end;

      </querytext>
</fullquery>

packages/news/tcl/news-procs-oracle.xql