APPS.WF_PURGE dependencies on WF_ACTIVITIES

Line 570: from WF_ACTIVITIES WA

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

Line 575: from WF_ACTIVITIES WA

571: where WA.ITEM_TYPE = itemtype;
572:
573: cursor actcurs2 is
574: select distinct WA.ITEM_TYPE, WA.NAME
575: from WF_ACTIVITIES WA
576: where WA.ITEM_TYPE = itemtype
577: and WA.NAME = name;
578:
579: cursor actcurs3 is

Line 581: from WF_ACTIVITIES WA;

577: and WA.NAME = name;
578:
579: cursor actcurs3 is
580: select distinct WA.ITEM_TYPE, WA.NAME
581: from WF_ACTIVITIES WA;
582:
583:
584: /* JWSMITH BUG 2208127 - took out decode statment as this was */
585: /* preventing stats from being used and causing performance */

Line 595: from WF_ACTIVITIES WA

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
595: from WF_ACTIVITIES WA
596: where WA.ERROR_ITEM_TYPE = acttype
597: and WA.ERROR_PROCESS IS NOT NULL;
598:
599: -- Select processes using an activity in any version,

Line 608: from WF_ACTIVITIES WA

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
608: from WF_ACTIVITIES WA
609: where WA.ERROR_ITEM_TYPE = acttype
610: and WA.ERROR_PROCESS = actname;
611:
612: parent parentcurs1%rowtype;

Line 618: from WF_ACTIVITIES WA

614:
615: -- Select all versions of an activity before given enddate
616: cursor vercurs(acttype in varchar2, actname in varchar2) is
617: select WA.BEGIN_DATE, WA.END_DATE, WA.VERSION
618: from WF_ACTIVITIES WA
619: where WA.ITEM_TYPE = acttype
620: and WA.NAME = actname
621: and exists
622: (select null

Line 915: delete from WF_ACTIVITIES_TL WAT

911: and WAA.ACTIVITY_ITEM_TYPE = c_item_type
912: and WAA.ACTIVITY_VERSION = ver.version;
913:
914: -- Delete from activities table and _tl table.
915: delete from WF_ACTIVITIES_TL WAT
916: where WAT.NAME = c_name
917: and WAT.ITEM_TYPE = c_item_type
918: and WAT.VERSION = ver.version;
919:

Line 920: delete from WF_ACTIVITIES WA

916: where WAT.NAME = c_name
917: and WAT.ITEM_TYPE = c_item_type
918: and WAT.VERSION = ver.version;
919:
920: delete from WF_ACTIVITIES WA
921: where WA.NAME = c_name
922: and WA.ITEM_TYPE = c_item_type
923: and WA.VERSION = ver.version;
924: end if;

Line 932: from WF_ACTIVITIES WA

928: -- If no versions of activity are left, clear any references to
929: -- this activity in ROOT folders
930: select count(1)
931: into numvers
932: from WF_ACTIVITIES WA
933: where WA.NAME = c_name
934: and WA.ITEM_TYPE = c_item_type;
935:
936: if (numvers = 0) then