_news__c_db-news-status (private)

 _news__c_db-news-status

Defined in packages/news/tcl/test/news-db-test-init.tcl

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Source code:

    aa_export_vars {p_publish_date p_archive_date status}

    set status [db_exec_plsql get-status {}]

Generic XQL file:

packages/news/tcl/test/news-db-test-init.xql

PostgreSQL XQL file:

<fullquery name="_news__c_db-news-status.get-status">
    <querytext>
     select news__status(to_timestamp(:p_publish_date, 'YYYY-MM-DD'), to_timestamp(:p_archive_date, 'YYYY-MM-DD'));
  </querytext>
</fullquery>

packages/news/tcl/test/news-db-test-init-postgresql.xql

Oracle XQL file:

<fullquery name="_news__c_db-news-status.get-status">
    <querytext>
    begin
      :1 := news.status(to_date(:p_publish_date, 'YYYY-MM-DD'), to_date(:p_archive_date, 'YYYY-MM-DD'));
    end;
  </querytext>
</fullquery>

packages/news/tcl/test/news-db-test-init-oracle.xql