DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER_WF_PKG dependencies on WF_NOTIFICATION

Line 280: from WF_NOTIFICATIONS WN, WF_ITEM_ACTIVITY_STATUSES WIAS

276: */
277:
278: CURSOR c_notification_id(p_item_key varchar2,p_item_type varchar2) is
279: select wn.notification_id nid
280: from WF_NOTIFICATIONS WN, WF_ITEM_ACTIVITY_STATUSES WIAS
281: where WN.GROUP_ID = WIAS.NOTIFICATION_ID
282: and WIAS.ITEM_TYPE = p_item_type
283: and WIAS.ITEM_KEY = p_item_key;
284:

Line 319: wf_notification.cancel(l_ntfid);

315: fetch c_notification_id into l_ntfid;
316: close c_notification_id;
317:
318: if l_ntfid is not Null then
319: wf_notification.cancel(l_ntfid);
320: end if;
321: END;
322:
323: EXCEPTION