APPS.WF_LOAD dependencies on WF_ACTIVITY_ATTR_VALUES

Line 2071: from WF_ACTIVITY_ATTR_VALUES

2067: x_level_error := 0;
2068: begin
2069: select PROTECT_LEVEL, CUSTOM_LEVEL
2070: into protection_level, customization_level
2071: from WF_ACTIVITY_ATTR_VALUES
2072: where PROCESS_ACTIVITY_ID = x_process_activity_id
2073: and NAME = x_name;
2074:
2075: if ((wf_core.upload_mode <> 'FORCE') and

Line 2088: update WF_ACTIVITY_ATTR_VALUES set

2084: return;
2085: end if;
2086:
2087: -- Update existing row
2088: update WF_ACTIVITY_ATTR_VALUES set
2089: PROTECT_LEVEL = x_protect_level,
2090: CUSTOM_LEVEL = x_custom_level,
2091: TEXT_VALUE = l_text_value,
2092: NUMBER_VALUE = l_number_value,

Line 2114: insert into WF_ACTIVITY_ATTR_VALUES (

2110: return;
2111: end if;
2112:
2113: -- Insert new row
2114: insert into WF_ACTIVITY_ATTR_VALUES (
2115: PROCESS_ACTIVITY_ID,
2116: NAME,
2117: PROTECT_LEVEL,
2118: CUSTOM_LEVEL,

Line 3173: from WF_ACTIVITY_ATTR_VALUES

3169: select NAME, VALUE_TYPE, PROTECT_LEVEL, CUSTOM_LEVEL,
3170: TEXT_VALUE,
3171: to_char(NUMBER_VALUE) NUMBER_VALUE,
3172: to_char(DATE_VALUE, 'YYYY/MM/DD HH24:MI:SS') DATE_VALUE
3173: from WF_ACTIVITY_ATTR_VALUES
3174: where PROCESS_ACTIVITY_ID = id;
3175:
3176: l_item_type varchar2(8);
3177: l_default varchar2(4000);

Line 3726: delete from WF_ACTIVITY_ATTR_VALUES where PROCESS_ACTIVITY_ID = p_step;

3722: Wf_Load.Delete_Transition(p_previous_step=>p_step);
3723: Wf_Load.Delete_Transition(p_next_step=>p_step);
3724:
3725: -- Delete all related attribute values
3726: delete from WF_ACTIVITY_ATTR_VALUES where PROCESS_ACTIVITY_ID = p_step;
3727:
3728: -- Delete the process activity
3729: delete from WF_PROCESS_ACTIVITIES where INSTANCE_ID = p_step;
3730:

Line 3759: from WF_ACTIVITY_ATTR_VALUES

3755: nvl(nvl(TEXT_VALUE, to_char(NUMBER_VALUE)),
3756: to_char(DATE_VALUE, 'YYYY/MM/DD HH24:MI:SS'))
3757: into p_attribute_value_type,
3758: p_attribute_value
3759: from WF_ACTIVITY_ATTR_VALUES
3760: where PROCESS_ACTIVITY_ID = p_process_instance_id
3761: and NAME = p_attribute_name;
3762: exception
3763: when OTHERS then