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_NOTIFICATION

Line 393: Wf_Notification.CancelGroup(gid=>notid, timeout=>TRUE);

389: Wf_Item_Activity_Status.Notification_Status(itemtype, itemkey, actid,
390: notid, user);
391: if ((notid is not null) and (lresult <> wf_engine.eng_null)) then
392: begin
393: Wf_Notification.CancelGroup(gid=>notid, timeout=>TRUE);
394: exception
395: when others then
396: -- Ignore any errors from cancelling notifications
397: null;

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 1231: Wf_Notification.CancelGroup(notid);

1227: Wf_Item_Activity_Status.Notification_Status(itemtype, itemkey, actid,
1228: notid, user);
1229: if (notid is not null) then
1230: begin
1231: Wf_Notification.CancelGroup(notid);
1232: exception
1233: when others then
1234: null; -- Ignore errors in cancelling
1235: end;

Line 1835: not Wf_Notification.OpenNotificationsExist(id)) then

1831: end if;
1832: end if;
1833:
1834: if ((nvl(id, wf_engine.eng_null) <> wf_engine.eng_null) and
1835: not Wf_Notification.OpenNotificationsExist(id)) then
1836: -- Notification has already been closed, presumably by an
1837: -- auto-routing rule that has already submitted the response.
1838: -- If this is the case, the notification has been responded to
1839: -- and is closed, but CB did NOT continue execution following

Line 2383: Wf_Notification.CancelGroup(notid,'');

2379: Wf_Item_Activity_Status.Notification_Status(itemtype, itemkey,
2380: childid, notid, user);
2381: if (notid is not null) then
2382: begin
2383: Wf_Notification.CancelGroup(notid,'');
2384: exception
2385: when others then
2386: null; -- Ignore errors in cancelling
2387: end;

Line 2668: notid := Wf_Notification.SendGroup(prole, msgtype, msg, duedate,

2664:
2665: -- Send notification, either to expanded role or singly
2666: -- depending on expand_role flag.
2667: if (expand_role = 'Y') then
2668: notid := Wf_Notification.SendGroup(prole, msgtype, msg, duedate,
2669: 'WF_ENGINE.CB', ctx, '', priority);
2670: else
2671: notid := Wf_Notification.Send(prole, msgtype, msg, duedate,
2672: 'WF_ENGINE.CB', ctx, '', priority);

Line 2671: notid := Wf_Notification.Send(prole, msgtype, msg, duedate,

2667: if (expand_role = 'Y') then
2668: notid := Wf_Notification.SendGroup(prole, msgtype, msg, duedate,
2669: 'WF_ENGINE.CB', ctx, '', priority);
2670: else
2671: notid := Wf_Notification.Send(prole, msgtype, msg, duedate,
2672: 'WF_ENGINE.CB', ctx, '', priority);
2673: end if;
2674:
2675: -- Check for a change in the performer. If the notification

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 2791: insert into WF_NOTIFICATION_ATTRIBUTES (

2787: replace(ntf_row.CONTEXT,':'||old_itemkey||':',':'||new_itemkey||':'));
2788:
2789:
2790: -- create notification attributes
2791: insert into WF_NOTIFICATION_ATTRIBUTES (
2792: NOTIFICATION_ID,
2793: NAME,
2794: TEXT_VALUE,
2795: NUMBER_VALUE,

Line 2803: from WF_NOTIFICATION_ATTRIBUTES

2799: NAME,
2800: TEXT_VALUE,
2801: NUMBER_VALUE,
2802: DATE_VALUE
2803: from WF_NOTIFICATION_ATTRIBUTES
2804: where notification_id = ntf_row.notification_id
2805: union all
2806: select nid,
2807: NAME,

Line 2816: from WF_NOTIFICATION_ATTRIBUTES

2812: where MESSAGE_TYPE = ntf_row.MESSAGE_TYPE
2813: and MESSAGE_NAME = ntf_row.MESSAGE_NAME
2814: and name not in
2815: (select name
2816: from WF_NOTIFICATION_ATTRIBUTES
2817: where notification_id = ntf_row.notification_id);
2818:
2819: -- Copy associated Notification Comments
2820: INSERT INTO wf_comments

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

Line 2912: update WF_NOTIFICATION_ATTRIBUTES

2908:
2909: --
2910: -- Update the notification attribute
2911: --
2912: update WF_NOTIFICATION_ATTRIBUTES
2913: set TEXT_VALUE = attr_tvalue,
2914: NUMBER_VALUE = attr_nvalue,
2915: DATE_VALUE = attr_dvalue
2916: where notification_id = message_attr_row.notification_id

Line 3285: wf_engine.context_user := wf_notification.g_context_user;

3281: Wf_Engine.context_text := ctx_text;
3282:
3283: -- Bug 3065814
3284: -- Set all context information for the post-notification function
3285: wf_engine.context_user := wf_notification.g_context_user;
3286: wf_engine.context_user_comment := wf_notification.g_context_user_comment ;
3287: wf_engine.context_recipient_role := wf_notification.g_context_recipient_role ;
3288: wf_engine.context_original_recipient:= wf_notification.g_context_original_recipient;
3289: wf_engine.context_from_role := wf_notification.g_context_from_role ;

Line 3286: wf_engine.context_user_comment := wf_notification.g_context_user_comment ;

3282:
3283: -- Bug 3065814
3284: -- Set all context information for the post-notification function
3285: wf_engine.context_user := wf_notification.g_context_user;
3286: wf_engine.context_user_comment := wf_notification.g_context_user_comment ;
3287: wf_engine.context_recipient_role := wf_notification.g_context_recipient_role ;
3288: wf_engine.context_original_recipient:= wf_notification.g_context_original_recipient;
3289: wf_engine.context_from_role := wf_notification.g_context_from_role ;
3290: wf_engine.context_new_role := wf_notification.g_context_new_role ;

Line 3287: wf_engine.context_recipient_role := wf_notification.g_context_recipient_role ;

3283: -- Bug 3065814
3284: -- Set all context information for the post-notification function
3285: wf_engine.context_user := wf_notification.g_context_user;
3286: wf_engine.context_user_comment := wf_notification.g_context_user_comment ;
3287: wf_engine.context_recipient_role := wf_notification.g_context_recipient_role ;
3288: wf_engine.context_original_recipient:= wf_notification.g_context_original_recipient;
3289: wf_engine.context_from_role := wf_notification.g_context_from_role ;
3290: wf_engine.context_new_role := wf_notification.g_context_new_role ;
3291: wf_engine.context_more_info_role := wf_notification.g_context_more_info_role ;

Line 3288: wf_engine.context_original_recipient:= wf_notification.g_context_original_recipient;

3284: -- Set all context information for the post-notification function
3285: wf_engine.context_user := wf_notification.g_context_user;
3286: wf_engine.context_user_comment := wf_notification.g_context_user_comment ;
3287: wf_engine.context_recipient_role := wf_notification.g_context_recipient_role ;
3288: wf_engine.context_original_recipient:= wf_notification.g_context_original_recipient;
3289: wf_engine.context_from_role := wf_notification.g_context_from_role ;
3290: wf_engine.context_new_role := wf_notification.g_context_new_role ;
3291: wf_engine.context_more_info_role := wf_notification.g_context_more_info_role ;
3292: wf_engine.context_proxy := wf_notification.g_context_proxy;

Line 3289: wf_engine.context_from_role := wf_notification.g_context_from_role ;

3285: wf_engine.context_user := wf_notification.g_context_user;
3286: wf_engine.context_user_comment := wf_notification.g_context_user_comment ;
3287: wf_engine.context_recipient_role := wf_notification.g_context_recipient_role ;
3288: wf_engine.context_original_recipient:= wf_notification.g_context_original_recipient;
3289: wf_engine.context_from_role := wf_notification.g_context_from_role ;
3290: wf_engine.context_new_role := wf_notification.g_context_new_role ;
3291: wf_engine.context_more_info_role := wf_notification.g_context_more_info_role ;
3292: wf_engine.context_proxy := wf_notification.g_context_proxy;
3293:

Line 3290: wf_engine.context_new_role := wf_notification.g_context_new_role ;

3286: wf_engine.context_user_comment := wf_notification.g_context_user_comment ;
3287: wf_engine.context_recipient_role := wf_notification.g_context_recipient_role ;
3288: wf_engine.context_original_recipient:= wf_notification.g_context_original_recipient;
3289: wf_engine.context_from_role := wf_notification.g_context_from_role ;
3290: wf_engine.context_new_role := wf_notification.g_context_new_role ;
3291: wf_engine.context_more_info_role := wf_notification.g_context_more_info_role ;
3292: wf_engine.context_proxy := wf_notification.g_context_proxy;
3293:
3294: wf_engine.context_user_key := wf_engine.GetItemUserKey(itemtype, itemkey);

Line 3291: wf_engine.context_more_info_role := wf_notification.g_context_more_info_role ;

3287: wf_engine.context_recipient_role := wf_notification.g_context_recipient_role ;
3288: wf_engine.context_original_recipient:= wf_notification.g_context_original_recipient;
3289: wf_engine.context_from_role := wf_notification.g_context_from_role ;
3290: wf_engine.context_new_role := wf_notification.g_context_new_role ;
3291: wf_engine.context_more_info_role := wf_notification.g_context_more_info_role ;
3292: wf_engine.context_proxy := wf_notification.g_context_proxy;
3293:
3294: wf_engine.context_user_key := wf_engine.GetItemUserKey(itemtype, itemkey);
3295:

Line 3292: wf_engine.context_proxy := wf_notification.g_context_proxy;

3288: wf_engine.context_original_recipient:= wf_notification.g_context_original_recipient;
3289: wf_engine.context_from_role := wf_notification.g_context_from_role ;
3290: wf_engine.context_new_role := wf_notification.g_context_new_role ;
3291: wf_engine.context_more_info_role := wf_notification.g_context_more_info_role ;
3292: wf_engine.context_proxy := wf_notification.g_context_proxy;
3293:
3294: wf_engine.context_user_key := wf_engine.GetItemUserKey(itemtype, itemkey);
3295:
3296: -- Call function in requested mode