DBA Data[Home] [Help]

APPS.JTF_UM_WF_APPROVAL dependencies on WF_NOTIFICATION

Line 1459: from wf_process_activities wpa, wf_item_activity_statuses wias, wf_notifications wn

1455: notificationID number (15);
1456:
1457: cursor getNotificationID is
1458: select wias.notification_id
1459: from wf_process_activities wpa, wf_item_activity_statuses wias, wf_notifications wn
1460: where wpa.PROCESS_ITEM_TYPE = p_itemtype
1461: and wpa.ACTIVITY_ITEM_TYPE = wpa.PROCESS_ITEM_TYPE
1462: and (wpa.INSTANCE_LABEL = 'NTF_APPROVAL_USERTYPE_REQUIRED'
1463: or wpa.INSTANCE_LABEL = 'NTF_REMIND_USERTYPE_REQUIRED'

Line 1490: wf_notification.cancel (notificationID);

1486: open getNotificationID;
1487: -- We have two notification that we need to cancel.
1488: fetch getNotificationID into notificationID;
1489: while getNotificationID%found loop
1490: wf_notification.cancel (notificationID);
1491: fetch getNotificationID into notificationID;
1492: end loop;
1493: close getNotificationID;
1494: