APPS.WF_LOAD dependencies on WF_PROCESS_ACTIVITIES

Line 1759: select WF_PROCESS_ACTIVITIES_S.NEXTVAL

1755: x_level_error := 0;
1756: begin
1757: -- instance_id of zero means generate locally
1758: if (x_instance_id = 0) then
1759: select WF_PROCESS_ACTIVITIES_S.NEXTVAL
1760: into x_instance_id
1761: from sys.dual;
1762:
1763: raise NO_DATA_FOUND; --jump to insert

Line 1767: from WF_PROCESS_ACTIVITIES

1763: raise NO_DATA_FOUND; --jump to insert
1764: else
1765: select PROTECT_LEVEL, CUSTOM_LEVEL
1766: into protection_level, customization_level
1767: from WF_PROCESS_ACTIVITIES
1768: where INSTANCE_ID = x_instance_id;
1769:
1770: if (x_process_name <> 'ROOT') then
1771: if ((wf_core.upload_mode <> 'FORCE') and

Line 1811: update WF_PROCESS_ACTIVITIES set

1807: end if;
1808: end if;
1809:
1810: -- Update existing row
1811: update WF_PROCESS_ACTIVITIES set
1812: PROCESS_ITEM_TYPE = x_process_item_type,
1813: PROCESS_NAME = x_process_name,
1814: PROCESS_VERSION = x_process_version,
1815: ACTIVITY_ITEM_TYPE = x_activity_item_type,

Line 1910: from WF_PROCESS_ACTIVITIES

1906: -- Check if ROOT process of such activity has already been inserted,
1907: -- since each process activity must be attached to ROOT.
1908: select count(1)
1909: into noinsert
1910: from WF_PROCESS_ACTIVITIES
1911: where PROCESS_NAME = 'ROOT'
1912: and ACTIVITY_ITEM_TYPE = x_process_item_type
1913: and ACTIVITY_NAME = x_activity_name
1914: and rownum=1;

Line 1919: insert into WF_PROCESS_ACTIVITIES (

1915:
1916: -- no need to insert when ROOT already exists (noinsert > 0)
1917: if (x_process_name <> 'ROOT' or noinsert <= 0) then
1918: -- Insert new row
1919: insert into WF_PROCESS_ACTIVITIES (
1920: PROCESS_ITEM_TYPE,
1921: PROCESS_NAME,
1922: PROCESS_VERSION,
1923: ACTIVITY_ITEM_TYPE,

Line 2033: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA,

2029: --
2030: begin
2031: select WAA.TYPE
2032: into l_type
2033: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA,
2034: WF_ACTIVITY_ATTRIBUTES WAA
2035: where WPA.INSTANCE_ID = x_process_activity_id
2036: and WPA.ACTIVITY_ITEM_TYPE = WA.ITEM_TYPE
2037: and WPA.ACTIVITY_NAME = WA.NAME

Line 2889: from WF_PROCESS_ACTIVITIES

2885: WF_CACHE.Reset;
2886:
2887: select ICON_GEOMETRY, ACTIVITY_NAME, INSTANCE_LABEL
2888: into l_icon_geometry, p_activity_name, p_instance_label
2889: from WF_PROCESS_ACTIVITIES
2890: where instance_id = p_activity_instance;
2891:
2892: comma_position := instr(l_icon_geometry, ',');
2893: p_xcor := to_number(substr(l_icon_geometry, 1, comma_position - 1));

Line 3144: type t_pacTable is table of WF_PROCESS_ACTIVITIES.INSTANCE_ID%TYPE

3140: and ACTIVITY_NAME = actname
3141: and ACTIVITY_VERSION = ver
3142: order by SEQUENCE;
3143:
3144: type t_pacTable is table of WF_PROCESS_ACTIVITIES.INSTANCE_ID%TYPE
3145: index by binary_integer;
3146:
3147: v_opac t_pacTable;
3148: v_npac t_pacTable;

Line 3155: from WF_PROCESS_ACTIVITIES

3151: select ACTIVITY_ITEM_TYPE, ACTIVITY_NAME, INSTANCE_ID, START_END,
3152: DEFAULT_RESULT, ICON_GEOMETRY, PERFORM_ROLE,
3153: USER_COMMENT, PERFORM_ROLE_TYPE, INSTANCE_LABEL,
3154: PROTECT_LEVEL, CUSTOM_LEVEL
3155: from WF_PROCESS_ACTIVITIES
3156: where PROCESS_ITEM_TYPE = itt
3157: and PROCESS_NAME = actname
3158: and PROCESS_VERSION = ver
3159: order by INSTANCE_ID;

Line 3557: from WF_PROCESS_ACTIVITIES

3553:
3554: -- check if process activity already exists
3555: begin
3556: select INSTANCE_ID into v_npac(i)
3557: from WF_PROCESS_ACTIVITIES
3558: where INSTANCE_LABEL = pacr.instance_label
3559: and PROCESS_ITEM_TYPE = p_destination_item_type
3560: and PROCESS_NAME = l_pname
3561: and PROCESS_VERSION = 1;

Line 3729: delete from WF_PROCESS_ACTIVITIES where INSTANCE_ID = p_step;

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:
3731: exception
3732: when OTHERS then
3733: Wf_Core.Context('Wf_Load', 'Delete_Process_Activity',

Line 4132: from WF_PROCESS_ACTIVITIES

4128: end if;
4129:
4130: if (p_instance_label is not null) then
4131: select INSTANCE_ID into id
4132: from WF_PROCESS_ACTIVITIES
4133: where INSTANCE_LABEL = p_instance_label
4134: and PROCESS_NAME = p_process_name
4135: and PROCESS_ITEM_TYPE = p_process_item_type
4136: and PROCESS_VERSION = p_process_version;

Line 4143: from WF_PROCESS_ACTIVITIES

4139: end if;
4140:
4141: -- return only the first row if there are more.
4142: select INSTANCE_ID into id
4143: from WF_PROCESS_ACTIVITIES
4144: where PROCESS_NAME = p_process_name
4145: and PROCESS_ITEM_TYPE = p_process_item_type
4146: and PROCESS_VERSION = p_process_version
4147: and ACTIVITY_ITEM_TYPE = p_activity_item_type

Line 4176: from WF_PROCESS_ACTIVITIES

4172: l_actname varchar2(30);
4173: begin
4174: select ACTIVITY_NAME
4175: into l_actname
4176: from WF_PROCESS_ACTIVITIES
4177: where INSTANCE_ID = p_instance_id;
4178:
4179: return l_actname;
4180: exception

Line 4409: from WF_PROCESS_ACTIVITIES

4405: p_instance_ids out NOCOPY t_instanceidTab
4406: )is
4407: cursor paccur is
4408: select INSTANCE_ID
4409: from WF_PROCESS_ACTIVITIES
4410: where PROCESS_NAME = p_process_name
4411: and PROCESS_ITEM_TYPE = p_process_item_type
4412: and PROCESS_VERSION = p_process_version;
4413:

Line 4585: from WF_PROCESS_ACTIVITIES WPA,

4581: n number;
4582:
4583: cursor actcur(ver number) is
4584: select WPA.ACTIVITY_ITEM_TYPE, WPA.ACTIVITY_NAME
4585: from WF_PROCESS_ACTIVITIES WPA,
4586: WF_ACTIVITIES WA
4587: where WPA.PROCESS_ITEM_TYPE = p_process_item_type
4588: and WPA.PROCESS_NAME = p_process_name
4589: and WPA.PROCESS_VERSION = ver

Line 4626: from WF_PROCESS_ACTIVITIES

4622: end;
4623:
4624: -- then check to see if such activity exist
4625: select count(1) into n
4626: from WF_PROCESS_ACTIVITIES
4627: where PROCESS_ITEM_TYPE = p_process_item_type
4628: and PROCESS_NAME = p_process_name
4629: and PROCESS_VERSION = m_version
4630: and ACTIVITY_ITEM_TYPE = nvl(p_activity_item_type, p_process_item_type)