oracle8.1.6
begin :1 := workflow_case.new(
workflow_key => 'publishing_wf',
context_key => NULL,
object_id => :item_id,
creation_user => :user_id,
creation_ip => :creation_ip,
case_id => :case_id
);
end;
begin
workflow_case.add_manual_assignment(
case_id => :case_id,
role_key => 'author',
party_id => :value
);
end;
begin
workflow_case.add_manual_assignment(
case_id => :case_id,
role_key => :transition,
party_id => :new_value
);
end;
begin
workflow_case.start_case(
case_id => :case_id,
creation_user => :user_id,
creation_ip => :creation_ip,
msg => :msg
);
end;
select
person.name(user_id) name, user_id
from
users
where
user_id > 0
order by
name
select acs_object_id_seq.nextval from dual