[Home] [Help]
2068: x_level_error := 0;
2069: begin
2070: select PROTECT_LEVEL, CUSTOM_LEVEL
2071: into protection_level, customization_level
2072: from WF_ACTIVITY_ATTR_VALUES
2073: where PROCESS_ACTIVITY_ID = x_process_activity_id
2074: and NAME = x_name;
2075:
2076: if ((wf_core.upload_mode <> 'FORCE') and
2085: return;
2086: end if;
2087:
2088: -- Update existing row
2089: update WF_ACTIVITY_ATTR_VALUES set
2090: PROTECT_LEVEL = x_protect_level,
2091: CUSTOM_LEVEL = x_custom_level,
2092: TEXT_VALUE = l_text_value,
2093: NUMBER_VALUE = l_number_value,
2111: return;
2112: end if;
2113:
2114: -- Insert new row
2115: insert into WF_ACTIVITY_ATTR_VALUES (
2116: PROCESS_ACTIVITY_ID,
2117: NAME,
2118: PROTECT_LEVEL,
2119: CUSTOM_LEVEL,
3170: select NAME, VALUE_TYPE, PROTECT_LEVEL, CUSTOM_LEVEL,
3171: TEXT_VALUE,
3172: to_char(NUMBER_VALUE) NUMBER_VALUE,
3173: to_char(DATE_VALUE, 'YYYY/MM/DD HH24:MI:SS') DATE_VALUE
3174: from WF_ACTIVITY_ATTR_VALUES
3175: where PROCESS_ACTIVITY_ID = id;
3176:
3177: l_item_type varchar2(8);
3178: l_default varchar2(4000);
3723: Wf_Load.Delete_Transition(p_previous_step=>p_step);
3724: Wf_Load.Delete_Transition(p_next_step=>p_step);
3725:
3726: -- Delete all related attribute values
3727: delete from WF_ACTIVITY_ATTR_VALUES where PROCESS_ACTIVITY_ID = p_step;
3728:
3729: -- Delete the process activity
3730: delete from WF_PROCESS_ACTIVITIES where INSTANCE_ID = p_step;
3731:
3756: nvl(nvl(TEXT_VALUE, to_char(NUMBER_VALUE)),
3757: to_char(DATE_VALUE, 'YYYY/MM/DD HH24:MI:SS'))
3758: into p_attribute_value_type,
3759: p_attribute_value
3760: from WF_ACTIVITY_ATTR_VALUES
3761: where PROCESS_ACTIVITY_ID = p_process_instance_id
3762: and NAME = p_attribute_name;
3763: exception
3764: when OTHERS then
4721: WFTable TableName:=TableName ('WF_ACTIVITIES',
4722: 'WF_ACTIVITIES_TL',
4723: 'WF_ACTIVITY_ATTRIBUTES',
4724: 'WF_ACTIVITY_ATTRIBUTES_TL',
4725: 'WF_ACTIVITY_ATTR_VALUES',
4726: 'WF_ACTIVITY_TRANSITIONS',
4727: 'WF_ITEM_ATTRIBUTES',
4728: 'WF_ITEM_ATTRIBUTES_TL',
4729: 'WF_ITEM_TYPES',