APPS.WF_PURGE dependencies on WF_PROCESS_ACTIVITIES

Line 584: from WF_PROCESS_ACTIVITIES WPA

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

Line 597: from WF_PROCESS_ACTIVITIES WPA

593: -- Select processes using an activity in any version,
594: -- or referencing this activity as an error process
595: cursor parentcurs2(acttype in varchar2, actname in varchar2) is
596: select WPA.PROCESS_ITEM_TYPE, WPA.PROCESS_NAME
597: from WF_PROCESS_ACTIVITIES WPA
598: where WPA.ACTIVITY_ITEM_TYPE = acttype
599: and WPA.ACTIVITY_NAME = actname
600: union
601: select WA.ITEM_TYPE PROCESS_ITEM_TYPE, WA.NAME PROCESS_NAME

Line 871: from WF_PROCESS_ACTIVITIES WPA

867: -- their attribute values and transitions
868: delete from WF_ACTIVITY_ATTR_VALUES WAAV
869: where WAAV.PROCESS_ACTIVITY_ID in
870: (select WPA.INSTANCE_ID
871: from WF_PROCESS_ACTIVITIES WPA
872: where WPA.PROCESS_NAME = c_name
873: and WPA.PROCESS_ITEM_TYPE = c_item_type
874: and WPA.PROCESS_VERSION = ver.version);
875:

Line 879: from WF_PROCESS_ACTIVITIES WPA

875:
876: delete from WF_ACTIVITY_TRANSITIONS WAT
877: where WAT.TO_PROCESS_ACTIVITY in
878: (select WPA.INSTANCE_ID
879: from WF_PROCESS_ACTIVITIES WPA
880: where WPA.PROCESS_NAME = c_name
881: and WPA.PROCESS_ITEM_TYPE = c_item_type
882: and WPA.PROCESS_VERSION = ver.version);
883:

Line 887: from WF_PROCESS_ACTIVITIES WPA

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

Line 892: delete from WF_PROCESS_ACTIVITIES WPA

888: where WPA.PROCESS_NAME = c_name
889: and WPA.PROCESS_ITEM_TYPE = c_item_type
890: and WPA.PROCESS_VERSION = ver.version);
891:
892: delete from WF_PROCESS_ACTIVITIES WPA
893: where WPA.PROCESS_NAME = c_name
894: and WPA.PROCESS_ITEM_TYPE = c_item_type
895: and WPA.PROCESS_VERSION = ver.version;
896:

Line 931: delete from WF_PROCESS_ACTIVITIES WPA

927: where WA.NAME = c_name
928: and WA.ITEM_TYPE = c_item_type;
929:
930: if (numvers = 0) then
931: delete from WF_PROCESS_ACTIVITIES WPA
932: where WPA.PROCESS_ITEM_TYPE = c_item_type
933: and WPA.PROCESS_NAME = 'ROOT'
934: and WPA.ACTIVITY_ITEM_TYPE = c_item_type
935: and WPA.ACTIVITY_NAME = c_name;