APPS.WF_MAINTENANCE dependencies on WF_NOTIFICATIONS

Line 118: from WF_NOTIFICATIONS

114: and WIASH.ASSIGNED_USER = l_oldname;
115:
116: cursor cNotifications (l_oldname varchar2) is
117: select NOTIFICATION_ID
118: from WF_NOTIFICATIONS
119: where RECIPIENT_ROLE = l_oldname
120: or ORIGINAL_RECIPIENT = l_oldname
121: or more_info_role = l_oldname
122: or from_role = l_oldname

Line 128: from WF_NOTIFICATIONS WN

124:
125: -- Only notifications belonging to active items
126: cursor cNotifications2 (l_oldname varchar2) is
127: select NOTIFICATION_ID
128: from WF_NOTIFICATIONS WN
129: where (WN.RECIPIENT_ROLE = l_oldname
130: or WN.ORIGINAL_RECIPIENT = l_oldname
131: or WN.MORE_INFO_ROLE = l_oldname
132: or WN.FROM_ROLE = l_oldname

Line 355: update WF_NOTIFICATIONS

351: exit;
352: end if;
353:
354: forall i in numTbl.first..numTbl.last
355: update WF_NOTIFICATIONS
356: set RECIPIENT_ROLE = decode(RECIPIENT_ROLE, l_oldname, l_newname, RECIPIENT_ROLE),
357: ORIGINAL_RECIPIENT = decode(ORIGINAL_RECIPIENT, l_oldname, l_newname, ORIGINAL_RECIPIENT),
358: FROM_ROLE = decode(FROM_ROLE, l_oldname, l_newname, FROM_ROLE),
359: RESPONDER = decode(RESPONDER, l_oldname, l_newname, RESPONDER),

Line 483: update WF_NOTIFICATIONS

479: exit;
480: end if;
481:
482: forall i in numTbl.first..numTbl.last
483: update WF_NOTIFICATIONS
484: set RECIPIENT_ROLE = decode(RECIPIENT_ROLE, l_oldname, l_newname, RECIPIENT_ROLE),
485: ORIGINAL_RECIPIENT = decode(ORIGINAL_RECIPIENT, l_oldname, l_newname, ORIGINAL_RECIPIENT),
486: FROM_ROLE = decode(FROM_ROLE, l_oldname, l_newname, FROM_ROLE),
487: RESPONDER = decode(RESPONDER, l_oldname, l_newname, RESPONDER),

Line 2058: -- Determine rows to change in WF_NOTIFICATIONS

2054: end if;
2055: l_wfcount_tab.TABLE_NAME :='WF_ITEM_ACTIVITY_STATUSES_H';
2056: pipe ROW (l_wfcount_tab);
2057:
2058: -- Determine rows to change in WF_NOTIFICATIONS
2059: if (l_pvalue is null or l_pvalue = 'Y') then
2060: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2061: from WF_NOTIFICATIONS WN
2062: where RECIPIENT_ROLE = p_name

Line 2061: from WF_NOTIFICATIONS WN

2057:
2058: -- Determine rows to change in WF_NOTIFICATIONS
2059: if (l_pvalue is null or l_pvalue = 'Y') then
2060: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2061: from WF_NOTIFICATIONS WN
2062: where RECIPIENT_ROLE = p_name
2063: or ORIGINAL_RECIPIENT = p_name
2064: or more_info_role = p_name
2065: or from_role = p_name

Line 2069: from WF_NOTIFICATIONS WN

2065: or from_role = p_name
2066: or responder = p_name;
2067: else
2068: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2069: from WF_NOTIFICATIONS WN
2070: where (exists (select '1'
2071: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_ITEMS WI
2072: where WIAS.NOTIFICATION_ID = WN.NOTIFICATION_ID
2073: and WIAS.ITEM_TYPE = WI.ITEM_TYPE

Line 2088: l_wfcount_tab.TABLE_NAME := 'WF_NOTIFICATIONS';

2084: or more_info_role = p_name
2085: or from_role = p_name
2086: or responder = p_name);
2087: end if;
2088: l_wfcount_tab.TABLE_NAME := 'WF_NOTIFICATIONS';
2089: pipe ROW (l_wfcount_tab);
2090:
2091: -- Determine rows to change in WF_PROCESS_ACTIVITIES
2092: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT