postgresql7.4
SELECT n.uos_code
FROM cc_uos_name n, cc_uos u
WHERE u.uos_name_id = n.name_id
AND u.uos_id = :uos_id
SELECT s.latest_revision_id
FROM cc_uos u, cc_uos_revisions r, cr_items i, cc_uos_gradattr_set s
WHERE u.uos_id = :uos_id
AND i.item_id = u.uos_id
AND r.uos_revision_id = i.latest_revision
AND s.parent_uos_id = :uos_id
SELECT cc_uos_gradattr__map (
:latest_revision_id,
:gradattr_id
);
UPDATE cc_uos_gradattr
SET name_id = :name_id,
identifier = :identifier,
description = :description,
level = :level
WHERE gradattr_id = :gradattr_id
UPDATE acs_objects
SET modifying_user = :modifying_user,
modifying_ip = :modifying_ip,
package_id = :package_id
WHERE object_id = :gradattr_id