APPS.WF_PURGE dependencies on WF_PROCESS_ACTIVITIES

Line 590: from WF_PROCESS_ACTIVITIES WPA

586: /* issues. Instead have two cursors and if logic to decide */
587: /* between them. See bug for more details. */
588: cursor parentcurs1(acttype in varchar2, actname in varchar2) is
589: select WPA.PROCESS_ITEM_TYPE, WPA.PROCESS_NAME
590: from WF_PROCESS_ACTIVITIES WPA
591: where WPA.ACTIVITY_ITEM_TYPE = acttype
592: and WPA.ACTIVITY_NAME = actname
593: union
594: select WA.ITEM_TYPE PROCESS_ITEM_TYPE, WA.NAME PROCESS_NAME

Line 603: from WF_PROCESS_ACTIVITIES WPA

599: -- Select processes using an activity in any version,
600: -- or referencing this activity as an error process
601: cursor parentcurs2(acttype in varchar2, actname in varchar2) is
602: select WPA.PROCESS_ITEM_TYPE, WPA.PROCESS_NAME
603: from WF_PROCESS_ACTIVITIES WPA
604: where WPA.ACTIVITY_ITEM_TYPE = acttype
605: and WPA.ACTIVITY_NAME = actname
606: union
607: select WA.ITEM_TYPE PROCESS_ITEM_TYPE, WA.NAME PROCESS_NAME

Line 877: from WF_PROCESS_ACTIVITIES WPA

873: -- their attribute values and transitions
874: delete from WF_ACTIVITY_ATTR_VALUES WAAV
875: where WAAV.PROCESS_ACTIVITY_ID in
876: (select WPA.INSTANCE_ID
877: from WF_PROCESS_ACTIVITIES WPA
878: where WPA.PROCESS_NAME = c_name
879: and WPA.PROCESS_ITEM_TYPE = c_item_type
880: and WPA.PROCESS_VERSION = ver.version);
881:

Line 885: from WF_PROCESS_ACTIVITIES WPA

881:
882: delete from WF_ACTIVITY_TRANSITIONS WAT
883: where WAT.TO_PROCESS_ACTIVITY in
884: (select WPA.INSTANCE_ID
885: from WF_PROCESS_ACTIVITIES WPA
886: where WPA.PROCESS_NAME = c_name
887: and WPA.PROCESS_ITEM_TYPE = c_item_type
888: and WPA.PROCESS_VERSION = ver.version);
889:

Line 893: from WF_PROCESS_ACTIVITIES WPA

889:
890: delete from WF_ACTIVITY_TRANSITIONS WAT
891: where WAT.FROM_PROCESS_ACTIVITY in
892: (select WPA.INSTANCE_ID
893: from WF_PROCESS_ACTIVITIES WPA
894: where WPA.PROCESS_NAME = c_name
895: and WPA.PROCESS_ITEM_TYPE = c_item_type
896: and WPA.PROCESS_VERSION = ver.version);
897:

Line 898: delete from WF_PROCESS_ACTIVITIES WPA

894: where WPA.PROCESS_NAME = c_name
895: and WPA.PROCESS_ITEM_TYPE = c_item_type
896: and WPA.PROCESS_VERSION = ver.version);
897:
898: delete from WF_PROCESS_ACTIVITIES WPA
899: where WPA.PROCESS_NAME = c_name
900: and WPA.PROCESS_ITEM_TYPE = c_item_type
901: and WPA.PROCESS_VERSION = ver.version;
902:

Line 937: delete from WF_PROCESS_ACTIVITIES WPA

933: where WA.NAME = c_name
934: and WA.ITEM_TYPE = c_item_type;
935:
936: if (numvers = 0) then
937: delete from WF_PROCESS_ACTIVITIES WPA
938: where WPA.PROCESS_ITEM_TYPE = c_item_type
939: and WPA.PROCESS_NAME = 'ROOT'
940: and WPA.ACTIVITY_ITEM_TYPE = c_item_type
941: and WPA.ACTIVITY_NAME = c_name;