| |
147 |
147 |
end; |
| |
148 |
148 |
</querytext> |
| |
149 |
149 |
</fullquery> |
| |
150 |
150 |
|
| |
151 |
151 |
<fullquery name="_news__c_db-news-archive.archive-default"> |
| |
152 |
152 |
<querytext> |
| |
153 |
153 |
begin |
| |
154 |
154 |
news.archive(item_id => :p_item_id); |
| |
155 |
155 |
end; |
| |
156 |
156 |
</querytext> |
| |
157 |
157 |
</fullquery> |
| |
158 |
158 |
|
| |
159 |
159 |
<fullquery name="_news__c_db-news-status.get-status"> |
| |
160 |
160 |
<querytext> |
| |
161 |
161 |
begin |
| |
162 |
162 |
:1 := news.status(to_date(:p_publish_date, 'YYYY-MM-DD'), to_date(:p_archive_date, 'YYYY-MM-DD')); |
| |
163 |
163 |
end; |
| |
164 |
164 |
</querytext> |
| |
165 |
165 |
</fullquery> |
| |
166 |
166 |
|
| |
167 |
|
<fullquery name="_news__db-check-news-create.news-name"> |
| |
|
167 |
<fullquery name="_news__db_check_news_create.news-name"> |
| |
168 |
168 |
<querytext> |
| |
169 |
169 |
begin |
| |
170 |
170 |
:1 := news.name(news_id => :p_news_id); |
| |
171 |
171 |
end; |
| |
172 |
172 |
</querytext> |
| |
173 |
173 |
</fullquery> |
| |
174 |
174 |
|
| |
175 |
175 |
</queryset> |
