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;