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_MAIL dependencies on WF_NOTIFICATIONS

Line 174: from wf_notifications

170: parameterList wf_parameter_list_t;
171: begin
172: select message_type, message_name, mail_status, recipient_role
173: into l_mType, l_mName, l_currState, l_role
174: from wf_notifications
175: where notification_id = nid;
176:
177: -- If the prevsious state was FAILED, then preserve this state.
178: -- A new status of null means that a null message was sent.

Line 189: update WF_NOTIFICATIONS

185: end if;
186:
187: if updateState then
188: -- This notification had already locked by wfmail() in the mailer
189: update WF_NOTIFICATIONS
190: set MAIL_STATUS = UpdateStatus2.status
191: where NOTIFICATION_ID = nid;
192: end if;
193:

Line 247: update WF_NOTIFICATIONS N

243: -- This is contrary to the behaviour of previous releases
244: -- and will be re-Addressed a little later on.
245:
246: -- close this notification if there is no response
247: update WF_NOTIFICATIONS N
248: set N.STATUS = 'CLOSED',
249: N.END_DATE = sysdate
250: where N.NOTIFICATION_ID = nid
251: and not exists (select NULL

Line 284: l_recipient WF_NOTIFICATIONS.RECIPIENT_ROLE%TYPE;

280: -- Queue number on which to process
281: procedure ResetFailed(p_queue varchar2)
282: is
283: l_nid number;
284: l_recipient WF_NOTIFICATIONS.RECIPIENT_ROLE%TYPE;
285: l_status varchar2 (8);
286: l_timeout boolean;
287: l_error_result varchar2(2000);
288:

Line 299: update WF_NOTIFICATIONS N

295: while not l_timeout loop
296: wf_xml.GetExceptionMessage(p_queue, l_nid, l_recipient, l_status,
297: l_timeout, l_error_result);
298: if ( not l_timeout ) then
299: update WF_NOTIFICATIONS N
300: set N.MAIL_STATUS = 'MAIL'
301: where N.NOTIFICATION_ID = l_nid;
302: -- wf_xml.EnqueueNotification(l_nid);
303: end if;

Line 342: from WF_NOTIFICATIONS

338: begin
339: -- Get the callback function.
340: select CALLBACK, CONTEXT, RECIPIENT_ROLE
341: into cb, ctx, role
342: from WF_NOTIFICATIONS
343: where NOTIFICATION_ID = nid;
344:
345: -- If there is no callback, just clear any error and return.
346: if (cb is null) then

Line 502: from wf_notifications

498: end if;
499:
500: select recipient_role
501: into recipient
502: from wf_notifications
503: where notification_id = nid;
504:
505: exception
506: when no_data_found then

Line 952: update WF_NOTIFICATIONS

948: end if;
949: end;
950:
951: -- Set the mail_status to INVALID (mailer will pick this up)
952: update WF_NOTIFICATIONS
953: set MAIL_STATUS = 'INVALID'
954: where NOTIFICATION_ID = nid;
955: -- wf_xml.enqueueNotification(nid);
956:

Line 959: from wf_notifications

955: -- wf_xml.enqueueNotification(nid);
956:
957: select recipient_role, group_id, message_type, message_name
958: into role, group_id, mType, mName
959: from wf_notifications
960: where notification_id = nid;
961:
962: wf_event.AddParameterToList('NOTIFICATION_ID', nid, parameterlist);
963: wf_event.AddParameterToList('ROLE', role, parameterlist);

Line 1293: WF_NOTIFICATIONS WN,

1289: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1290: 'LOOKUP', WNA.TEXT_VALUE,
1291: WNA.TEXT_VALUE) VALUE
1292: from WF_NOTIFICATION_ATTRIBUTES WNA,
1293: WF_NOTIFICATIONS WN,
1294: WF_MESSAGE_ATTRIBUTES_VL WMA
1295: where WNA.NOTIFICATION_ID = nid
1296: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1297: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 1364: WF_NOTIFICATIONS WN,

1360: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1361: 'LOOKUP', WNA.TEXT_VALUE,
1362: WNA.TEXT_VALUE) VALUE
1363: from WF_NOTIFICATION_ATTRIBUTES WNA,
1364: WF_NOTIFICATIONS WN,
1365: WF_MESSAGE_ATTRIBUTES_VL WMA
1366: where WNA.NOTIFICATION_ID = nid
1367: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1368: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 1557: and ias.item_key = itemKey) intf, wf_notifications ntf

1553: union all
1554: select notification_id
1555: from wf_item_activity_statuses_h ias
1556: where ias.item_type = itemType
1557: and ias.item_key = itemKey) intf, wf_notifications ntf
1558: where intf.notification_id = ntf.group_id)
1559: where role <> current_role
1560: and role not in (select wur.role_name
1561: from wf_user_roles wur

Line 1571: from wf_notifications

1567:
1568: begin
1569: select context
1570: into context
1571: from wf_notifications
1572: where notification_id = nid;
1573:
1574: -- get item type and item key from the context
1575: pos := instr(context, ':', 1, 1);

Line 1772: WF_NOTIFICATIONS WN,

1768: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1769: 'LOOKUP', WNA.TEXT_VALUE,
1770: WNA.TEXT_VALUE) VALUE
1771: from WF_NOTIFICATION_ATTRIBUTES WNA,
1772: WF_NOTIFICATIONS WN,
1773: WF_MESSAGE_ATTRIBUTES_VL WMA
1774: where WNA.NOTIFICATION_ID = nid
1775: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1776: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 1856: WF_NOTIFICATIONS WN,

1852: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1853: 'LOOKUP', WNA.TEXT_VALUE,
1854: WNA.TEXT_VALUE) VALUE
1855: from WF_NOTIFICATION_ATTRIBUTES WNA,
1856: WF_NOTIFICATIONS WN,
1857: WF_MESSAGE_ATTRIBUTES_VL WMA
1858: where WNA.NOTIFICATION_ID = nid
1859: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1860: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 1959: WF_NOTIFICATIONS WN,

1955: -- SQL Statement for fetching URL RESPONSE attributes.
1956: cursor c1 is
1957: select WMA.NAME, WMA.DISPLAY_NAME, WNA.TEXT_VALUE, WMA.DESCRIPTION
1958: from WF_NOTIFICATION_ATTRIBUTES WNA,
1959: WF_NOTIFICATIONS WN,
1960: WF_MESSAGE_ATTRIBUTES_VL WMA
1961: where WNA.NOTIFICATION_ID = nid
1962: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1963: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 2031: WF_NOTIFICATIONS WN,

2027: 'LOOKUP', WNA.TEXT_VALUE,
2028: WNA.TEXT_VALUE), WMA.DESCRIPTION
2029: into disp_name, attr_type, attr_format, attr_value, attr_desc
2030: from WF_NOTIFICATION_ATTRIBUTES WNA,
2031: WF_NOTIFICATIONS WN,
2032: WF_MESSAGE_ATTRIBUTES_VL WMA
2033: where WNA.NOTIFICATION_ID = nid
2034: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
2035: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 2354: WF_NOTIFICATIONS N

2350: select 1 into fyi
2351: from dual
2352: where not exists (select NULL
2353: from WF_MESSAGE_ATTRIBUTES MA,
2354: WF_NOTIFICATIONS N
2355: where N.NOTIFICATION_ID = nid
2356: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE
2357: and MA.MESSAGE_NAME = N.MESSAGE_NAME
2358: and MA.SUBTYPE = 'RESPOND');

Line 2380: from wf_notifications

2376: end if;
2377:
2378: select message_type, message_name
2379: into mType, mName
2380: from wf_notifications
2381: where notification_id = nid;
2382:
2383: -- Now that the template name has been derrived, see
2384: -- if the default value has been overridden.

Line 2532: WF_NOTIFICATIONS WN

2528: cursor headers(nid in Number) is
2529: select WMA.NAME
2530: from WF_MESSAGE_ATTRIBUTES_VL WMA,
2531: WF_NOTIFICATION_ATTRIBUTES WNA,
2532: WF_NOTIFICATIONS WN
2533: where WNA.NOTIFICATION_ID = nid
2534: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
2535: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
2536: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 2572: FROM wf_notifications

2568:
2569: begin
2570: SELECT due_date, from_user
2571: INTO l_due_date, l_from_user
2572: FROM wf_notifications
2573: WHERE notification_id = nid;
2574: exception
2575: when no_data_found then
2576: wf_core.token('NID', to_char(nid));

Line 2755: -- Bug 2094159 get from_user from wf_notifications

2751: n_dir varchar2(16);
2752:
2753: begin
2754: -- Get notification information
2755: -- Bug 2094159 get from_user from wf_notifications
2756: begin
2757: select STATUS, MAIL_STATUS, ACCESS_KEY,
2758: RECIPIENT_ROLE, PRIORITY, USER_COMMENT,
2759: BEGIN_DATE, END_DATE, DUE_DATE, FROM_USER,

Line 2765: from WF_NOTIFICATIONS

2761: into n_status, n_mstatus, n_key,
2762: n_to_role, n_priority, n_comment,
2763: n_start_date, n_end_date, n_due_date, n_from_user,
2764: n_more_info_role
2765: from WF_NOTIFICATIONS
2766: where NOTIFICATION_ID = nid;
2767: exception
2768: when no_data_found then
2769: wf_core.token('NID', to_char(nid));

Line 4266: WF_NOTIFICATIONS WN,

4262: -- SQL Statement for fetching URL RESPONSE attributes.
4263: cursor c1 is
4264: select WMA.NAME, WMA.DISPLAY_NAME, WNA.TEXT_VALUE, WMA.DESCRIPTION
4265: from WF_NOTIFICATION_ATTRIBUTES WNA,
4266: WF_NOTIFICATIONS WN,
4267: WF_MESSAGE_ATTRIBUTES_VL WMA
4268: where WNA.NOTIFICATION_ID = nid
4269: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
4270: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 4351: WF_NOTIFICATIONS WN,

4347: 'LOOKUP', WNA.TEXT_VALUE,
4348: WNA.TEXT_VALUE), WMA.DESCRIPTION
4349: into disp_name, attr_type, attr_format, attr_value, attr_desc
4350: from WF_NOTIFICATION_ATTRIBUTES WNA,
4351: WF_NOTIFICATIONS WN,
4352: WF_MESSAGE_ATTRIBUTES_VL WMA
4353: where WNA.NOTIFICATION_ID = nid
4354: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
4355: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 4646: FROM wf_notifications

4642: begin
4643:
4644: SELECT context, callback
4645: into context, callback
4646: FROM wf_notifications
4647: where notification_id = nid;
4648:
4649: wf_engine.preserved_context := FALSE;
4650: if (callback is not null) then

Line 4754: FROM wf_notifications n, wf_messages_vl wm

4750: l_get_text := false;
4751:
4752: SELECT wm.body, wm.html_body
4753: INTO l_text_body, l_html_body
4754: FROM wf_notifications n, wf_messages_vl wm
4755: WHERE n.notification_id = p_nid
4756: AND n.message_name = wm.name
4757: AND n.message_type = wm.type;
4758:

Line 4980: from WF_NOTIFICATIONS

4976: into n_status, n_mstatus, n_key,
4977: n_priority, n_comment,
4978: n_start_date, n_end_date, n_due_date, n_from_user,
4979: n_more_info_role
4980: from WF_NOTIFICATIONS
4981: where NOTIFICATION_ID = nid;
4982: exception
4983: when no_data_found then
4984: wf_core.token('NID', to_char(nid));

Line 5544: from WF_NOTIFICATIONS

5540: -- Get notification information
5541: begin
5542: select RECIPIENT_ROLE
5543: into n_to_role
5544: from WF_NOTIFICATIONS
5545: where NOTIFICATION_ID = nid;
5546: exception
5547: when no_data_found then
5548: wf_core.token('NID', to_char(nid));

Line 5674: from WF_NOTIFICATIONS

5670: -- Bug 1753464 included sort order for the query
5671: -- Bug 2439529 Altered query to use UNION instead of OR.
5672: cursor c1 is
5673: select NOTIFICATION_ID, RECIPIENT_ROLE, ACCESS_KEY, PRIORITY, DUE_DATE
5674: from WF_NOTIFICATIONS
5675: where STATUS = 'OPEN'
5676: and RECIPIENT_ROLE IN
5677: (select role from dual
5678: union

Line 6440: from WF_NOTIFICATIONS

6436: -- Get notification message and status
6437: begin
6438: select MESSAGE_NAME, MESSAGE_TYPE, STATUS
6439: into msg_name, msg_type, stat
6440: from WF_NOTIFICATIONS
6441: where NOTIFICATION_ID = nid;
6442: exception
6443: when no_data_found then
6444: wf_core.token('NID', to_char(nid));

Line 6655: WF_NOTIFICATIONS WN,

6651: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
6652: 'LOOKUP', WNA.TEXT_VALUE,
6653: WNA.TEXT_VALUE) VALUE
6654: from WF_NOTIFICATION_ATTRIBUTES WNA,
6655: WF_NOTIFICATIONS WN,
6656: WF_MESSAGE_ATTRIBUTES_VL WMA
6657: where WNA.NOTIFICATION_ID = nid
6658: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
6659: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 6684: from WF_NOTIFICATIONS

6680: -- Get notification message and status
6681: begin
6682: select MESSAGE_NAME, MESSAGE_TYPE, STATUS
6683: into msg_name, msg_type, stat
6684: from WF_NOTIFICATIONS
6685: where NOTIFICATION_ID = nid;
6686: exception
6687: when no_data_found then
6688: wf_core.token('NID', to_char(nid));

Line 6853: -- update wf_notifications and wf_comments in QUESTION mode

6849: comment := 'NULL';
6850: end if;
6851: -- validate the role before calling updateinfo
6852:
6853: -- update wf_notifications and wf_comments in QUESTION mode
6854: if (length(to_user) > 0 and length(comment) > 0) then
6855: wf_notification.UpdateInfo2(nid, to_user, from_addr, comment);
6856: end if;
6857: exception

Line 6937: -- update wf_notifications and wf_comments in ANSWER mode

6933: end if;
6934: end if;
6935: end if;
6936: end if;
6937: -- update wf_notifications and wf_comments in ANSWER mode
6938: to_user := NULL;
6939: wf_notification.UpdateInfo2(nid, to_user, from_addr, comment);
6940: exception
6941: when no_program_unit then

Line 6976: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

6972: select WMA.TYPE, WMA.DISPLAY_NAME,
6973: decode(WMA.TYPE, 'URL', WF_NOTIFICATION.GetUrlText(WNA.TEXT_VALUE,
6974: GetURLAttachment.nid), WNA.TEXT_VALUE) URL,
6975: WNA.NAME
6976: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
6977: WF_MESSAGE_ATTRIBUTES_VL WMA
6978: where WNA.NOTIFICATION_ID = GetURLAttachment.nid
6979: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
6980: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 8054: FROM wf_notifications

8050:
8051: -- Get message details
8052: SELECT message_type,message_name
8053: INTO l_msg_type,l_msg_name
8054: FROM wf_notifications
8055: WHERE notification_id = p_nid;
8056:
8057: -- Get template 'WARNING'
8058: SELECT subject, BODY, HTML_BODY