_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