eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_UM_WF_APPROVAL dependencies on WF_NOTIFICATION

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

1467: notificationID number (15);
1468:
1469: cursor getNotificationID is
1470: select wias.notification_id
1471: from wf_process_activities wpa, wf_item_activity_statuses wias, wf_notifications wn
1472: where wpa.PROCESS_ITEM_TYPE = p_itemtype
1473: and wpa.ACTIVITY_ITEM_TYPE = wpa.PROCESS_ITEM_TYPE
1474: and (wpa.INSTANCE_LABEL = 'NTF_APPROVAL_USERTYPE_REQUIRED'
1475: or wpa.INSTANCE_LABEL = 'NTF_REMIND_USERTYPE_REQUIRED'

Line 1502: wf_notification.cancel (notificationID);

1498: open getNotificationID;
1499: -- We have two notification that we need to cancel.
1500: fetch getNotificationID into notificationID;
1501: while getNotificationID%found loop
1502: wf_notification.cancel (notificationID);
1503: fetch getNotificationID into notificationID;
1504: end loop;
1505: close getNotificationID;
1506: