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.WF_ENGINE_UTIL dependencies on WF_NOTIFICATIONS

Line 1011: -- notification in WF_NOTIFICATIONS if the notification activity

1007: return;
1008:
1009: -- Bug 2111183
1010: -- resetting activity with status eng_notified prevents a orphaned
1011: -- notification in WF_NOTIFICATIONS if the notification activity
1012: -- is revisited in a loop simultaneously by two incoming transitions
1013:
1014: elsif (status in (wf_engine.eng_completed, wf_engine.eng_error,
1015: wf_engine.eng_notified)) then

Line 2751: from wf_notifications

2747: MAIL_STATUS, PRIORITY,
2748: BEGIN_DATE, END_DATE, DUE_DATE,
2749: USER_COMMENT,CALLBACK,
2750: CONTEXT
2751: from wf_notifications
2752: where group_id = copy_nid;
2753:
2754: begin
2755: for ntf_row in ntf_details loop

Line 2758: select WF_NOTIFICATIONS_S.NEXTVAL

2754: begin
2755: for ntf_row in ntf_details loop
2756:
2757: -- create a new notification
2758: select WF_NOTIFICATIONS_S.NEXTVAL
2759: into nid
2760: from SYS.DUAL;
2761:
2762: -- Use nid of the first notification as group id for the rest

Line 2768: insert into WF_NOTIFICATIONS (

2764: if (gid =0) then
2765: gid := nid;
2766: end if;
2767:
2768: insert into WF_NOTIFICATIONS (
2769: NOTIFICATION_ID, GROUP_ID,
2770: MESSAGE_TYPE, MESSAGE_NAME,
2771: RECIPIENT_ROLE, ORIGINAL_RECIPIENT,
2772: STATUS,

Line 2876: wf_notifications n,

2872: select ma.NAME, ma.TYPE, ma.SUBTYPE,
2873: ma.TEXT_DEFAULT, ma.NUMBER_DEFAULT, ma.DATE_DEFAULT,
2874: n.notification_id
2875: from wf_item_activity_statuses_h ias,
2876: wf_notifications n,
2877: wf_message_attributes ma
2878: where ias.item_type = itemtype
2879: and ias.item_key = itemkey
2880: and ias.notification_id = n.notification_id