oracle8.1.6 begin content_workflow.reject( task_id => :task_id, user_id => :user_id, ip_address => :ip_address, transition_key => :transition_key, msg => :msg ); end; select content_workflow.can_reject( :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 tk.case_id = c.case_id and content_workflow.can_reject( tk.task_id, :user_id ) = 't' select trans.transition_name, trans.transition_key from wf_places src, wf_places dest, wf_tasks t, wf_transitions trans where src.workflow_key = dest.workflow_key and src.workflow_key = 'publishing_wf' and src.workflow_key = trans.workflow_key and src.place_key = content_workflow.get_this_place( t.transition_key ) and -- for the publishing_wf, past transitions have a lower sort order dest.sort_order < src.sort_order and -- get the transition associated with that place content_workflow.get_this_place( trans.transition_key ) = dest.place_key and t.task_id = :task_id order by dest.sort_order desc