oracle8.1.6
begin
:1 := apm_package.highest_version (
package_key => :package_key
);
end;
select version_name
from apm_package_versions
where package_key = :package_key
and version_id = apm_package.highest_version(:package_key)
begin
:1 := apm_package.num_instances(
package_key => :package_key
);
end;
begin
:1 := apm.register_parameter(
parameter_id => :parameter_id,
parameter_name => :parameter_name,
package_key => :package_key,
description => :description,
datatype => :datatype,
default_value => :default_value,
section_name => :section_name,
min_n_values => :min_n_values,
max_n_values => :max_n_values
);
end;
select nvl(v.package_id, 0) as package_id, p.parameter_name,
decode(v.value_id, null, p.default_value, v.attr_value) as attr_value
from apm_parameters p, apm_parameter_values v
where p.package_key = :package_key
and p.parameter_id = v.parameter_id (+)
begin
:1 := apm_package_version.add_dependency(
dependency_type => :dependency_type,
dependency_id => :dependency_id,
version_id => :version_id,
dependency_uri => :dependency_uri,
dependency_version => :dependency_version
);
end;
begin
apm_package_version.remove_dependency(
dependency_id => :dependency_id
);
end;
begin
:1 := apm_package_version.add_interface(
interface_id => :interface_id,
version_id => :version_id,
interface_uri => :interface_uri,
interface_version => :interface_version
);
end;
begin
apm_package_version.remove_interface(
interface_id => :interface_id
);
end;
select decode(count(*), 0, 0, 1) from apm_package_versions
where package_key = :package_key
and version_name = :version_name
select decode(count(*), 0, 0, 1) from apm_package_versions
where package_key = :package_key
and version_name = :version_name
begin
:1 := apm_package.new(
package_id => :package_id,
instance_name => :instance_name,
package_key => :package_key,
context_id => :context_id
);
end;
begin
apm_package.del(
package_id => :package_id
);
end;
select site_node.url(min(node_id))
from site_nodes
where object_id = :package_id
select package_key, pretty_name
from apm_package_types
where not (apm_package.singleton_p(package_key) = 1 and
apm_package.num_instances(package_key) >= 1)
order by pretty_name
select apm_parameter_value.new(
package_id => :package_id,
parameter_id => ap.parameter_id,
value => ap.default_value)
from apm_parameters ap
where ap.package_key = :new_package_key
and not exists (select 1
from apm_parameters ap2
where ap2.package_key = :old_package_key
and ap2.parameter_name = ap.parameter_name)