oracle8.1.6 begin :1 := workflow_case.begin_task_action( task_id => :task_id, action => :action, action_ip => :modifying_ip, user_id => :user_id, msg => :msg); end; begin :1 := workflow_case.new(case_id => :case_id, workflow_key => :workflow_key, context_key => :context_key, object_id => :object_id, creation_user => :user_id, creation_ip => :creation_ip ); end; begin workflow_case.start_case(case_id => :case_id, creation_user => :user_id, creation_ip => :creation_ip ); end; begin :1 := journal_entry.new( object_id => :case_id, action => 'comment', creation_user => :user_id, creation_ip => :ip_address, msg => :msg ); end; begin :1 := workflow.simple_p(:workflow_key); end; select case_id, acs_object.name(object_id) as object_name, state from wf_cases where case_id = :case_id select t.task_id, t.case_id, c.object_id, acs_object.name(c.object_id) as object_name, ot.pretty_name as object_type_pretty, c.workflow_key, tr.transition_name as task_name, t.state, t.enabled_date, to_char(t.enabled_date, :date_format) as enabled_date_pretty, t.started_date, to_char(t.started_date, :date_format) as started_date_pretty, t.canceled_date, to_char(t.canceled_date, :date_format) as canceled_date_pretty, t.finished_date, to_char(t.finished_date, :date_format) as finished_date_pretty, t.overridden_date, to_char(t.overridden_date, :date_format) as overridden_date_pretty, t.holding_user, acs_object.name(t.holding_user) as holding_user_name, p.email as holding_user_email, t.hold_timeout, to_char(t.hold_timeout, :date_format) as hold_timeout_pretty, t.deadline, to_char(t.deadline, :date_format) as deadline_pretty, t.deadline - sysdate as days_till_deadline, tr.estimated_minutes, tr.access_privilege, sysdate from wf_tasks t, wf_cases c, wf_transition_info tr, acs_objects o, acs_object_types ot, parties p where t.task_id = :task_id and c.case_id = t.case_id and tr.transition_key = t.transition_key and tr.workflow_key = t.workflow_key and tr.context_key = c.context_key and o.object_id = c.object_id and ot.object_type = o.object_type and p.party_id (+) = t.holding_user select a.attribute_id, a.attribute_name, a.pretty_name, a.datatype, acs_object.get_attribute(c.case_id, a.attribute_name) as value, wfai.wf_datatype, '' as attribute_widget from acs_attributes a, wf_transition_attribute_map m, wf_tasks t, wf_cases c, wf_attribute_info wfai where t.task_id = :task_id and c.case_id = t.case_id and m.workflow_key = c.workflow_key and m.transition_key = t.transition_key and a.attribute_id = m.attribute_id and wfai.attribute_id = a.attribute_id order by m.sort_order select ut.user_id, acs_object.name(ut.user_id) as name, p.email as email from wf_user_tasks ut, parties p where ut.task_id = :task_id and p.party_id = ut.user_id select j.journal_id, j.action, j.action_pretty, o.creation_date, to_char(o.creation_date, :date_format) as creation_date_pretty, o.creation_user, acs_object.name(o.creation_user) as creation_user_name, p.email as creation_user_email, o.creation_ip, j.msg from journal_entries j, acs_objects o, parties p where j.object_id = :case_id and o.object_id = j.journal_id and p.party_id (+) = o.creation_user order by o.creation_date $sql_order begin workflow_case.set_attribute_value( journal_id => :journal_id, attribute_name => :attribute_name, value => :value ); end; begin workflow_case.clear_manual_assignments( case_id => :case_id, transition_key => :transition_key ); end; begin workflow_case.add_manual_assignment( case_id => :case_id, transition_key => :transition_key, party_id => :party_id ); end; begin workflow_case.end_task_action( journal_id => :journal_id, action => :action, task_id => :task_id ); end; begin workflow_case.fire_message_transition( task_id => :task_id ); end; begin workflow_case.suspend( case_id => :case_id, user_id => :user_id, ip_address => :ip_address, msg => :msg ); end; begin workflow_case.resume( case_id => :case_id, user_id => :user_id, ip_address => :ip_address, msg => :msg ); end; begin workflow_case.cancel( case_id => :case_id, user_id => :user_id, ip_address => :ip_address, msg => :msg ); end; declare v_workflow_key varchar2(40); begin v_workflow_key := workflow.create_workflow( workflow_key => '[db_quote $new_workflow_key]', pretty_name => '[db_quote $new_workflow_pretty_name]', pretty_plural => '[db_quote $new_workflow_pretty_plural]', description => '[db_quote $description]', table_name => '[db_quote $new_table_name]' ); end; / show errors declare v_attribute_id acs_attributes.attribute_id%TYPE; begin v_attribute_id := workflow.create_attribute( workflow_key => '[db_quote $new_workflow_key]', attribute_name => '[db_quote $attribute_name]', datatype => '[db_quote $datatype]', pretty_name => '[db_quote $pretty_name]', default_value => '[db_quote $default_value]' ); insert into wf_transition_attribute_map (workflow_key, transition_key, attribute_id, sort_order) values ('[db_quote $new_workflow_key]', '[db_quote $transition_key]', v_attribute_id, [ad_decode $sort_order "" "null" $sort_order]); end; / show errors; commit;