select rl_resource__new_item (
null,
:resource_name,
:description,
now(),
:user_id,
:peeraddr,
:package_id
);
select rl_resource__new_revision (
:resource_item_id,
:resource_name,
:description,
now(),
:user_id,
:peeraddr,
:package_id
);
select
item_id as resource_item_id,
title as resource_name,
description
FROM
rl_resources_revisionsx
where resource_revision_id = :resource_revision_id
select
item_id as resource_item_id
FROM
rl_resources_revisionsx
where resource_revision_id = :resource_revision_id
select
category_id as category_type_id,
short_name as type_short_name
FROM
rl_resource_category_type
ORDER BY
ordering
select
short_name,
category_id
FROM
rl_resource_category
WHERE
category_type = :category_type_id
ORDER BY
short_name
insert into
rl_resource_category_map
(resource_item_id, category_id)
values
(:resource_item_id, :category_to_insert)
select
c.category_id
FROM
rl_resource_category c,
rl_resource_category_map m,
rl_resources_revisionsx r
WHERE
m.resource_item_id = r.item_id and
c.category_id = m.category_id and
r.resource_revision_id = :resource_revision_id
delete from rl_resource_category_map where resource_item_id = :resource_item_id
select current_timestamp from dual;