APPS.WF_PURGE dependencies on WF_ITEM_TYPES

Line 79: FROM WF_ITEM_TYPES

75:
76: cursor item2purge is
77: SELECT WI.ITEM_TYPE, WI.ITEM_KEY
78: FROM (SELECT PERSISTENCE_DAYS, NAME
79: FROM WF_ITEM_TYPES
80: WHERE PERSISTENCE_TYPE = Wf_Purge.persistence_type and NAME=itemtype) WIT, WF_ITEMS WI
81: WHERE WI.ITEM_TYPE = WIT.NAME
82: AND WI.END_DATE <= enddate-nvl(WIT.PERSISTENCE_DAYS,0)
83: AND WI.END_DATE > xenddate

Line 112: from WF_ITEM_TYPES WIT

108: and WI.ITEM_KEY = itemkey
109: and WI.end_date <= enddate
110: and exists
111: (select null
112: from WF_ITEM_TYPES WIT
113: where WI.END_DATE+nvl(WIT.PERSISTENCE_DAYS,0)<=enddate
114: and WI.ITEM_TYPE = WIT.NAME
115: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type)
116: and not exists

Line 154: from WF_ITEM_TYPES WIT

150: where WI.END_DATE <= enddate
151: and WI.END_DATE > xenddate
152: and exists
153: (select null
154: from WF_ITEM_TYPES WIT
155: where WI.END_DATE+nvl(WIT.PERSISTENCE_DAYS,0)<=enddate
156: and WI.ITEM_TYPE = WIT.NAME
157: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type)
158: and not exists

Line 617: from WF_ITEM_TYPES WIT

613: where WA.ITEM_TYPE = acttype
614: and WA.NAME = actname
615: and exists
616: (select null
617: from WF_ITEM_TYPES WIT
618: where WA.END_DATE+nvl(WIT.PERSISTENCE_DAYS,0)<=enddate
619: and WA.ITEM_TYPE = WIT.NAME
620: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type);
621:

Line 1045: from WF_ITEM_TYPES WIT

1041: where WIAS.NOTIFICATION_ID = WN.GROUP_ID)
1042: and (
1043: exists(
1044: select null
1045: from WF_ITEM_TYPES WIT
1046: where WN.END_DATE+nvl(WIT.PERSISTENCE_DAYS,0) <= enddate
1047: and WN.MESSAGE_TYPE = WIT.NAME
1048: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type)
1049: or not exists(

Line 1051: from WF_ITEM_TYPES WIT

1047: and WN.MESSAGE_TYPE = WIT.NAME
1048: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type)
1049: or not exists(
1050: select null
1051: from WF_ITEM_TYPES WIT
1052: where WN.MESSAGE_TYPE = WIT.NAME))
1053: and(
1054: (purgesigs = 1)
1055: or not exists

Line 1075: from WF_ITEM_TYPES WIT

1071: where WIAS.NOTIFICATION_ID = WN.GROUP_ID)
1072: and (
1073: exists(
1074: select null
1075: from WF_ITEM_TYPES WIT
1076: where WN.END_DATE+nvl(WIT.PERSISTENCE_DAYS,0) <= enddate
1077: and WN.MESSAGE_TYPE = WIT.NAME
1078: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type)
1079: or not exists(

Line 1081: from WF_ITEM_TYPES WIT

1077: and WN.MESSAGE_TYPE = WIT.NAME
1078: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type)
1079: or not exists(
1080: select null
1081: from WF_ITEM_TYPES WIT
1082: where WN.MESSAGE_TYPE = WIT.NAME))
1083: and(
1084: (purgesigs = 1)
1085: or not exists

Line 1848: from WF_ITEM_TYPES WIT

1844: where WI.ITEM_TYPE = p_itemType
1845: and WI.END_DATE <= sysdate
1846: and exists
1847: (select null
1848: from WF_ITEM_TYPES WIT
1849: where WI.END_DATE+nvl(WIT.PERSISTENCE_DAYS,0)<=sysdate
1850: and WI.ITEM_TYPE = WIT.NAME
1851: )
1852: and not exists