-- -- apm_package_version__new/12 -- create or replace function apm_package_version__new( integer, character varying, character varying, character varying, character varying, character varying, character varying, timestamp with time zone, character varying, character varying, boolean, boolean ) returns int4 as $$ declare apm_pkg_ver__version_id alias for $1; -- default null apm_pkg_ver__package_key alias for $2; apm_pkg_ver__version_name alias for $3; -- default null apm_pkg_ver__version_uri alias for $4; apm_pkg_ver__summary alias for $5; apm_pkg_ver__description_format alias for $6; apm_pkg_ver__description alias for $7; apm_pkg_ver__release_date alias for $8; apm_pkg_ver__vendor alias for $9; apm_pkg_ver__vendor_uri alias for $10; apm_pkg_ver__installed_p alias for $11; -- default 'f' apm_pkg_ver__data_model_loaded_p alias for $12; -- default 'f' v_version_id apm_package_versions.version_id%TYPE; begin if apm_pkg_ver__version_id = '' or apm_pkg_ver__version_id is null then select nextval('t_acs_object_id_seq') into v_version_id from dual; else v_version_id := apm_pkg_ver__version_id; end if; v_version_id := acs_object__new( v_version_id, 'apm_package_version', now(), null, null, null ); insert into apm_package_versions (version_id, package_key, version_name, version_uri, summary, description_format, description, release_date, vendor, vendor_uri, installed_p, data_model_loaded_p) values (v_version_id, apm_pkg_ver__package_key, apm_pkg_ver__version_name, apm_pkg_ver__version_uri, apm_pkg_ver__summary, apm_pkg_ver__description_format, apm_pkg_ver__description, apm_pkg_ver__release_date, apm_pkg_ver__vendor, apm_pkg_ver__vendor_uri, apm_pkg_ver__installed_p, apm_pkg_ver__data_model_loaded_p); return v_version_id; end;$$ language plpgsql; -- -- apm_package_version__new/13 -- create or replace function apm_package_version__new( integer, character varying, character varying, character varying, character varying, character varying, character varying, timestamp with time zone, character varying, character varying, character varying, boolean, boolean ) returns int4 as $$ declare apm_pkg_ver__version_id alias for $1; -- default null apm_pkg_ver__package_key alias for $2; apm_pkg_ver__version_name alias for $3; -- default null apm_pkg_ver__version_uri alias for $4; apm_pkg_ver__summary alias for $5; apm_pkg_ver__description_format alias for $6; apm_pkg_ver__description alias for $7; apm_pkg_ver__release_date alias for $8; apm_pkg_ver__vendor alias for $9; apm_pkg_ver__vendor_uri alias for $10; apm_pkg_ver__auto_mount alias for $11; apm_pkg_ver__installed_p alias for $12; -- default 'f' apm_pkg_ver__data_model_loaded_p alias for $13; -- default 'f' v_version_id apm_package_versions.version_id%TYPE; begin if apm_pkg_ver__version_id is null then select nextval('t_acs_object_id_seq') into v_version_id from dual; else v_version_id := apm_pkg_ver__version_id; end if; v_version_id := acs_object__new( v_version_id, 'apm_package_version', now(), null, null, null, 't', apm_pkg_ver__package_key || ', Version ' || apm_pkg_ver__version_name, null ); insert into apm_package_versions (version_id, package_key, version_name, version_uri, summary, description_format, description, release_date, vendor, vendor_uri, auto_mount, installed_p, data_model_loaded_p) values (v_version_id, apm_pkg_ver__package_key, apm_pkg_ver__version_name, apm_pkg_ver__version_uri, apm_pkg_ver__summary, apm_pkg_ver__description_format, apm_pkg_ver__description, apm_pkg_ver__release_date, apm_pkg_ver__vendor, apm_pkg_ver__vendor_uri, apm_pkg_ver__auto_mount, apm_pkg_ver__installed_p, apm_pkg_ver__data_model_loaded_p); return v_version_id; end;$$ language plpgsql;