oracle8.1.6
begin
content_workflow.approve(
task_id => :task_id,
user_id => :user_id,
ip_address => :ip_address,
msg => :msg
);
end;
select content_workflow.can_approve( :task_id, :user_id ) from dual
select
c.object_id, content_item.get_title(c.object_id) title,
tr.transition_name
from
wf_tasks tk, wf_cases c,
wf_transitions tr
where
tk.task_id = :task_id
and
tk.transition_key = tr.transition_key
and
tk.workflow_key = tr.workflow_key
and
tk.workflow_key = 'publishing_wf'
and
c.case_id = tk.case_id
and
content_workflow.can_approve( tk.task_id, :user_id ) = 't'
select content_workflow.can_approve( :task_id, :user_id ) from dual