| |
211 |
211 |
<querytext> |
| |
212 |
212 |
|
| |
213 |
213 |
begin |
| |
214 |
214 |
:1 := apm_package_version.sortable_version_name('$f1_version_from'); |
| |
215 |
215 |
end; |
| |
216 |
216 |
|
| |
217 |
217 |
</querytext> |
| |
218 |
218 |
</fullquery> |
| |
219 |
219 |
|
| |
220 |
220 |
|
| |
221 |
221 |
<fullquery name="apm_upgrade_script_compare.test_f2"> |
| |
222 |
222 |
<querytext> |
| |
223 |
223 |
|
| |
224 |
224 |
begin |
| |
225 |
225 |
:1 := apm_package_version.sortable_version_name('$f2_version_from'); |
| |
226 |
226 |
end; |
| |
227 |
227 |
|
| |
228 |
228 |
</querytext> |
| |
229 |
229 |
</fullquery> |
| |
230 |
230 |
|
| |
231 |
|
<fullquery name="apm_dependency_provided_p.get_service_versions"> |
| |
|
231 |
<fullquery name="apm_dependency_provided_p.apm_dependency_check"> |
| |
232 |
232 |
<querytext> |
| |
233 |
233 |
|
| |
234 |
|
select service_version |
| |
|
234 |
select apm_package_version.version_name_greater(service_version, :dependency_version) as version_p |
| |
235 |
235 |
from apm_package_dependencies d, apm_package_types a, apm_package_versions v |
| |
236 |
236 |
where d.dependency_type = 'provides' |
| |
237 |
237 |
and d.version_id = v.version_id |
| |
238 |
238 |
and d.service_uri = :dependency_uri |
| |
239 |
239 |
and v.installed_p = 't' |
| |
240 |
240 |
and a.package_key = v.package_key |
| |
241 |
241 |
|
| |
242 |
242 |
</querytext> |
| |
243 |
243 |
</fullquery> |
| |
244 |
244 |
|
| |
|
245 |
<fullquery name="apm_dependency_provided_p.version_greater_p"> |
| |
|
246 |
<querytext> |
| |
|
247 |
select apm_package_version.version_name_greater(:provided_version, :dependency_version) from dual |
| |
|
248 |
</querytext> |
| |
|
249 |
</fullquery> |
| |
|
250 |
|
| |
245 |
251 |
<fullquery name="apm_copy_param_to_descendents.param_exists"> |
| |
246 |
252 |
<querytext> |
| |
247 |
253 |
begin |
| |
248 |
254 |
:1 := apm.parameter_p( |
| |
249 |
255 |
package_key => :descendent_package_key, |
| |
250 |
256 |
parameter_name => :parameter_name); |
| |
251 |
257 |
end; |
| |
252 |
258 |
</querytext> |
| |
253 |
259 |
</fullquery> |
| |
254 |
260 |
|
| |
255 |
261 |
<fullquery name="apm_copy_param_to_descendents.copy_descendent_param"> |
| |
256 |
262 |
<querytext> |
| |
257 |
263 |
begin |
| |
258 |
264 |
:1 := apm.register_parameter( |
| |
259 |
265 |
package_key => :descendent_package_key, |
| |
260 |
266 |
parameter_name => :parameter_name, |
| |
261 |
267 |
description => :description, |
| |
262 |
268 |
scope => :scope, |
| |
263 |
269 |
datatype => :datatype, |
| |
264 |
270 |
default_value => :default_value, |