APPS.WF_PURGE dependencies on WF_ACTIVITIES

Line 564: from WF_ACTIVITIES WA

560:
561:
562: cursor actcurs1 is
563: select distinct WA.ITEM_TYPE, WA.NAME
564: from WF_ACTIVITIES WA
565: where WA.ITEM_TYPE = itemtype;
566:
567: cursor actcurs2 is
568: select distinct WA.ITEM_TYPE, WA.NAME

Line 569: from WF_ACTIVITIES WA

565: where WA.ITEM_TYPE = itemtype;
566:
567: cursor actcurs2 is
568: select distinct WA.ITEM_TYPE, WA.NAME
569: from WF_ACTIVITIES WA
570: where WA.ITEM_TYPE = itemtype
571: and WA.NAME = name;
572:
573: cursor actcurs3 is

Line 575: from WF_ACTIVITIES WA;

571: and WA.NAME = name;
572:
573: cursor actcurs3 is
574: select distinct WA.ITEM_TYPE, WA.NAME
575: from WF_ACTIVITIES WA;
576:
577:
578: /* JWSMITH BUG 2208127 - took out decode statment as this was */
579: /* preventing stats from being used and causing performance */

Line 589: from WF_ACTIVITIES WA

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
589: from WF_ACTIVITIES WA
590: where WA.ERROR_ITEM_TYPE = acttype
591: and WA.ERROR_PROCESS IS NOT NULL;
592:
593: -- Select processes using an activity in any version,

Line 602: from WF_ACTIVITIES WA

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
602: from WF_ACTIVITIES WA
603: where WA.ERROR_ITEM_TYPE = acttype
604: and WA.ERROR_PROCESS = actname;
605:
606: parent parentcurs1%rowtype;

Line 612: from WF_ACTIVITIES WA

608:
609: -- Select all versions of an activity before given enddate
610: cursor vercurs(acttype in varchar2, actname in varchar2) is
611: select WA.BEGIN_DATE, WA.END_DATE, WA.VERSION
612: from WF_ACTIVITIES WA
613: where WA.ITEM_TYPE = acttype
614: and WA.NAME = actname
615: and exists
616: (select null

Line 909: delete from WF_ACTIVITIES_TL WAT

905: and WAA.ACTIVITY_ITEM_TYPE = c_item_type
906: and WAA.ACTIVITY_VERSION = ver.version;
907:
908: -- Delete from activities table and _tl table.
909: delete from WF_ACTIVITIES_TL WAT
910: where WAT.NAME = c_name
911: and WAT.ITEM_TYPE = c_item_type
912: and WAT.VERSION = ver.version;
913:

Line 914: delete from WF_ACTIVITIES WA

910: where WAT.NAME = c_name
911: and WAT.ITEM_TYPE = c_item_type
912: and WAT.VERSION = ver.version;
913:
914: delete from WF_ACTIVITIES WA
915: where WA.NAME = c_name
916: and WA.ITEM_TYPE = c_item_type
917: and WA.VERSION = ver.version;
918: end if;

Line 926: from WF_ACTIVITIES WA

922: -- If no versions of activity are left, clear any references to
923: -- this activity in ROOT folders
924: select count(1)
925: into numvers
926: from WF_ACTIVITIES WA
927: where WA.NAME = c_name
928: and WA.ITEM_TYPE = c_item_type;
929:
930: if (numvers = 0) then