postgresql7.1
select apm_package__highest_version (
:package_key
);
select apm_package__num_instances(
:package_key
);
select apm__register_parameter(
:parameter_id,
:package_key,
:parameter_name,
:description,
:datatype,
:default_value,
:section_name,
:min_n_values,
:max_n_values
);
select apm_package_version__add_dependency(
:dependency_id,
:version_id,
:dependency_uri,
:dependency_version
);
select apm_package_version__remove_dependency(
:dependency_id
);
select apm_package_version__add_interface(
:interface_id,
:version_id,
:interface_uri,
:interface_version
);
select apm_package_version__remove_interface(
:interface_id
);
select case when count(*) = 0 then 0 else 1 end
from apm_package_versions
where package_key = :package_key
and version_name = :version_name
select apm_package__new(
:package_id,
:instance_name,
:package_key,
'apm_package',
now(),
null,
null,
:context_id
);
begin
delete from apm_parameter_values
where parameter_id = :parameter_id;
delete from apm_parameters
where parameter_id = :parameter_id;
PERFORM acs_object__delete(:parameter_id);
return null;
end;
select site_node__url(node_id)
from site_nodes
where object_id = :package_id