postgresql7.1 select apm_package_version__new( :version_id, :package_key, :version_name, :version_uri, :summary, :description_format, :description, :release_date, :vendor, :vendor_uri, :auto_mount, 't', 't' ); select apm_package_type__drop_type( :package_key, 't' ); select apm_package_version__delete(:version_id); update apm_package_versions set installed_p = (version_id = :version_id) where package_key = :package_key select apm_package_version__disable( :version_id ); select apm__register_application ( :package_key, :pretty_name, :pretty_plural, :package_uri, :initial_install_p, :singleton_p, :implements_subsite_p, :inherit_templates_p, :spec_file_path, :spec_file_mtime ); select apm__register_service ( :package_key, :pretty_name, :pretty_plural, :package_uri, :initial_install_p, :singleton_p, :implements_subsite_p, :inherit_templates_p, :spec_file_path, :spec_file_mtime ); select apm_package_version__edit( null, :version_id, :version_name, :version_uri, :summary, :description_format, :description, :release_date, :vendor, :vendor_uri, :auto_mount, 't', 't' ); select apm_package_version__upgrade(:version_id); select apm_package_version__upgrade_p( :path, :initial_version_name, :final_version_name ); select apm_package_version__sortable_version_name(:f1_version_from); select apm_package_version__sortable_version_name(:f2_version_from); select apm_package_version__version_name_greater(service_version, :dependency_version) as version_p from apm_package_dependencies d, apm_package_types a, apm_package_versions v where d.dependency_type = 'provides' and d.version_id = v.version_id and d.service_uri = :dependency_uri and v.installed_p = 't' and a.package_key = v.package_key select apm_package_version__version_name_greater(:provided_version, :dependency_version) select version_id from apm_package_versions where package_key = :package_key and version_id = apm_package__highest_version(:package_key) select apm__parameter_p(:descendent_package_key, :parameter_name); select apm__register_parameter(null, :descendent_package_key, :parameter_name, :description, :scope, :datatype, :default_value, :section_name, :min_n_values, :max_n_values) select apm__parameter_p(:new_package_key, :parameter_name); select apm__register_parameter(null, :new_package_key, :parameter_name, :description, :scope, :datatype, :default_value, :section_name, :min_n_values, :max_n_values) select apm_package_version__version_name_greater(:version_name, version_name) as upgrade_p from apm_package_versions where package_key = :package_key and version_id = apm_package__highest_version (:package_key) select apm_package_version__enable( :version_id ); select version_name from apm_package_versions where package_key = :package_key and version_id = apm_package__highest_version(:package_key) select apm_package_version__sortable_version_name(:version_name_1) as sortable_version_1, apm_package_version__sortable_version_name(:version_name_2) as sortable_version_2 from dual select apm_package_version__sortable_version_name(:version)