oracle8.1.6
declare
v_workflow_key varchar(40);
begin
v_workflow_key := workflow.create_workflow(
workflow_key => '[db_quote $workflow_key]',
pretty_name => '[db_quote $workflow_name]',
pretty_plural => '[db_quote $workflow_name]',
description => '[db_quote $workflow_description]',
table_name => '[db_quote $workflow_cases_table]'
);
end;
declare
v_attribute_id acs_attributes.attribute_id%TYPE;
begin
v_attribute_id := workflow.create_attribute(
workflow_key => '[db_quote $workflow_key]',
attribute_name => '[db_quote $task($transition_key,loop_attribute_name)]',
datatype => 'boolean',
pretty_name => '[db_quote "$task($transition_key,loop_question)"]',
default_value => '[ad_decode $task($transition_key,loop_answer) "t" "f" "t"]'
);
insert into wf_transition_attribute_map (workflow_key, transition_key, attribute_id, sort_order)
values ('[db_quote $workflow_key]', '[db_quote $transition_key]', v_attribute_id, 1);
end;
select constraint_name from user_constraints
insert into wf_arcs (workflow_key, transition_key, place_key, direction,
guard_callback, guard_custom_arg, guard_description)
values ('[db_quote $workflow_key]', '[db_quote $transition_key]', '[db_quote $true_place]', 'out',
'wf_callback.guard_attribute_true', '[db_quote $task($transition_key,loop_attribute_name)]',
'[db_quote $task($transition_key,loop_question)]')