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 t.tl_id, t.latest_revision_id
FROM cc_uos u, cc_uos_revisions r, cr_items i, cc_uos_tl t
WHERE u.uos_id = :uos_id
AND i.item_id = u.uos_id
AND r.uos_revision_id = i.latest_revision
AND t.parent_uos_id = :uos_id
SELECT t.latest_revision_id
FROM cc_uos u, cc_uos_revisions r, cr_items i, cc_uos_tl t
WHERE u.uos_id = :uos_id
AND i.item_id = u.uos_id
AND r.uos_revision_id = i.latest_revision
AND t.parent_uos_id = :uos_id
SELECT cc_uos_tl_method__map (
:latest_revision_id,
:method_id
);
UPDATE cc_uos_tl_method
SET name_id = :name_id,
identifier = :identifier,
description = :description
WHERE method_id = :method_id
UPDATE acs_objects
SET modifying_user = :modifying_user,
modifying_ip = :modifying_ip,
package_id = :package_id
WHERE object_id = :method_id