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 963: update WF_NOTIFICATIONS

959: end if;
960: end;
961:
962: -- Set the mail_status to INVALID (mailer will pick this up)
963: update WF_NOTIFICATIONS
964: set MAIL_STATUS = 'INVALID'
965: where NOTIFICATION_ID = nid;
966: -- wf_xml.enqueueNotification(nid);
967:

Line 970: from wf_notifications

966: -- wf_xml.enqueueNotification(nid);
967:
968: select recipient_role, group_id, message_type, message_name
969: into role, group_id, mType, mName
970: from wf_notifications
971: where notification_id = nid;
972:
973: wf_event.AddParameterToList('NOTIFICATION_ID', nid, parameterlist);
974: wf_event.AddParameterToList('ROLE', role, parameterlist);

Line 1310: WF_NOTIFICATIONS WN,

1306: 'LOOKUP', WNA.TEXT_VALUE,
1307: WNA.TEXT_VALUE) VALUE,
1308: WNA.DATE_VALUE -- value is Date type <
1309: from WF_NOTIFICATION_ATTRIBUTES WNA,
1310: WF_NOTIFICATIONS WN,
1311: WF_MESSAGE_ATTRIBUTES_VL WMA
1312: where WNA.NOTIFICATION_ID = nid
1313: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1314: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 1387: WF_NOTIFICATIONS WN,

1383: 'LOOKUP', WNA.TEXT_VALUE,
1384: WNA.TEXT_VALUE) VALUE,
1385: WNA.DATE_VALUE
1386: from WF_NOTIFICATION_ATTRIBUTES WNA,
1387: WF_NOTIFICATIONS WN,
1388: WF_MESSAGE_ATTRIBUTES_VL WMA
1389: where WNA.NOTIFICATION_ID = nid
1390: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1391: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 1618: wf_notifications ntf

1614: from wf_item_activity_statuses_h ias
1615: where ias.item_type = itemType
1616: and ias.item_key = itemKey)
1617: iantf,
1618: wf_notifications ntf
1619: where iantf.notification_id = ntf.group_id
1620: AND ntf.group_id = nid
1621:
1622: UNION ALL

Line 1640: wf_notifications ntf

1636: from wf_item_activity_statuses_h ias
1637: where ias.item_type = itemType
1638: and ias.item_key = itemKey)
1639: iantf,
1640: wf_notifications ntf
1641: where iantf.notification_id = ntf.group_id
1642: and ntf.group_id = nid
1643:
1644: UNION ALL

Line 1661: wf_notifications ntf

1657: where ias.item_type = itemType
1658: and ias.item_key = itemKey
1659: )
1660: iantf,
1661: wf_notifications ntf
1662: where iantf.notification_id = ntf.group_id
1663: and ntf.group_id = nid
1664: and ntf.from_role is not null
1665:

Line 1688: from wf_notifications

1684: begin
1685:
1686: select context
1687: into context
1688: from wf_notifications
1689: where notification_id = nid;
1690:
1691: -- get item type and item key from the context
1692: if context is not null then

Line 1903: WF_NOTIFICATIONS WN,

1899: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1900: 'LOOKUP', WNA.TEXT_VALUE,
1901: WNA.TEXT_VALUE) VALUE
1902: from WF_NOTIFICATION_ATTRIBUTES WNA,
1903: WF_NOTIFICATIONS WN,
1904: WF_MESSAGE_ATTRIBUTES_VL WMA
1905: where WNA.NOTIFICATION_ID = nid
1906: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1907: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 1991: WF_NOTIFICATIONS WN,

1987: 'LOOKUP', WNA.TEXT_VALUE,
1988: WNA.TEXT_VALUE) VALUE,
1989: WNA.DATE_VALUE -- << sstomar: bug8430385 >>
1990: from WF_NOTIFICATION_ATTRIBUTES WNA,
1991: WF_NOTIFICATIONS WN,
1992: WF_MESSAGE_ATTRIBUTES_VL WMA
1993: where WNA.NOTIFICATION_ID = nid
1994: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1995: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 2109: WF_NOTIFICATIONS WN,

2105: -- SQL Statement for fetching URL RESPONSE attributes.
2106: cursor c1 is
2107: select WMA.NAME, WMA.DISPLAY_NAME, WNA.TEXT_VALUE, WMA.DESCRIPTION
2108: from WF_NOTIFICATION_ATTRIBUTES WNA,
2109: WF_NOTIFICATIONS WN,
2110: WF_MESSAGE_ATTRIBUTES_VL WMA
2111: where WNA.NOTIFICATION_ID = nid
2112: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
2113: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 2181: WF_NOTIFICATIONS WN,

2177: 'LOOKUP', WNA.TEXT_VALUE,
2178: WNA.TEXT_VALUE), WMA.DESCRIPTION
2179: into disp_name, attr_type, attr_format, attr_value, attr_desc
2180: from WF_NOTIFICATION_ATTRIBUTES WNA,
2181: WF_NOTIFICATIONS WN,
2182: WF_MESSAGE_ATTRIBUTES_VL WMA
2183: where WNA.NOTIFICATION_ID = nid
2184: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
2185: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 2508: WF_NOTIFICATIONS N

2504: select 1 into fyi
2505: from dual
2506: where not exists (select NULL
2507: from WF_MESSAGE_ATTRIBUTES MA,
2508: WF_NOTIFICATIONS N
2509: where N.NOTIFICATION_ID = nid
2510: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE
2511: and MA.MESSAGE_NAME = N.MESSAGE_NAME
2512: and MA.SUBTYPE = 'RESPOND');

Line 2534: from wf_notifications

2530: end if;
2531:
2532: select message_type, message_name
2533: into mType, mName
2534: from wf_notifications
2535: where notification_id = nid;
2536:
2537: -- Now that the template name has been derrived, see
2538: -- if the default value has been overridden.

Line 2686: WF_NOTIFICATIONS WN

2682: cursor headers(nid in Number) is
2683: select WMA.NAME
2684: from WF_MESSAGE_ATTRIBUTES_VL WMA,
2685: WF_NOTIFICATION_ATTRIBUTES WNA,
2686: WF_NOTIFICATIONS WN
2687: where WNA.NOTIFICATION_ID = nid
2688: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
2689: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
2690: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 2726: FROM wf_notifications

2722:
2723: begin
2724: SELECT due_date, from_user
2725: INTO l_due_date, l_from_user
2726: FROM wf_notifications
2727: WHERE notification_id = nid;
2728: exception
2729: when no_data_found then
2730: wf_core.token('NID', to_char(nid));

Line 2909: -- Bug 2094159 get from_user from wf_notifications

2905: n_dir varchar2(16);
2906:
2907: begin
2908: -- Get notification information
2909: -- Bug 2094159 get from_user from wf_notifications
2910: begin
2911: select STATUS, MAIL_STATUS, ACCESS_KEY,
2912: RECIPIENT_ROLE, PRIORITY, USER_COMMENT,
2913: BEGIN_DATE, END_DATE, DUE_DATE, FROM_USER,

Line 2919: from WF_NOTIFICATIONS

2915: into n_status, n_mstatus, n_key,
2916: n_to_role, n_priority, n_comment,
2917: n_start_date, n_end_date, n_due_date, n_from_user,
2918: n_more_info_role
2919: from WF_NOTIFICATIONS
2920: where NOTIFICATION_ID = nid;
2921: exception
2922: when no_data_found then
2923: wf_core.token('NID', to_char(nid));

Line 4422: WF_NOTIFICATIONS WN,

4418: -- SQL Statement for fetching URL RESPONSE attributes.
4419: cursor c1 is
4420: select WMA.NAME, WMA.DISPLAY_NAME, WNA.TEXT_VALUE, WMA.DESCRIPTION
4421: from WF_NOTIFICATION_ATTRIBUTES WNA,
4422: WF_NOTIFICATIONS WN,
4423: WF_MESSAGE_ATTRIBUTES_VL WMA
4424: where WNA.NOTIFICATION_ID = nid
4425: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
4426: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 4513: WF_NOTIFICATIONS WN,

4509: -- WNA.TEXT_VALUE),
4510: WMA.DESCRIPTION
4511: into disp_name, attr_type, attr_format, attr_desc
4512: from WF_NOTIFICATION_ATTRIBUTES WNA,
4513: WF_NOTIFICATIONS WN,
4514: WF_MESSAGE_ATTRIBUTES_VL WMA
4515: where WNA.NOTIFICATION_ID = nid
4516: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
4517: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 4823: FROM wf_notifications

4819: begin
4820:
4821: SELECT context, callback
4822: into context, callback
4823: FROM wf_notifications
4824: where notification_id = nid;
4825:
4826: wf_engine.preserved_context := FALSE;
4827: if (callback is not null) then

Line 4931: FROM wf_notifications n, wf_messages_vl wm

4927: l_get_text := false;
4928:
4929: SELECT wm.body, wm.html_body
4930: INTO l_text_body, l_html_body
4931: FROM wf_notifications n, wf_messages_vl wm
4932: WHERE n.notification_id = p_nid
4933: AND n.message_name = wm.name
4934: AND n.message_type = wm.type;
4935:

Line 5002: -- columns of wf_notifications table which are propagated from WF_XML.GenerateMessage() API

4998:
4999:
5000: -- GetLOBMessage4 - get email message data as a LOB
5001: -- Bug 10202313: Added n_status, n_mstatus parameters to store the status, mail_status
5002: -- columns of wf_notifications table which are propagated from WF_XML.GenerateMessage() API
5003: --
5004: -- IN
5005: -- notification id
5006: -- mailer node name

Line 5163: from WF_NOTIFICATIONS

5159: into n_key,
5160: n_priority, n_comment,
5161: n_start_date, n_end_date, n_due_date, n_from_user,
5162: n_more_info_role
5163: from WF_NOTIFICATIONS
5164: where NOTIFICATION_ID = nid;
5165: exception
5166: when no_data_found then
5167: wf_core.token('NID', to_char(nid));

Line 5668: from WF_NOTIFICATIONS

5664: select status,
5665: mail_status
5666: into n_status,
5667: n_mstatus
5668: from WF_NOTIFICATIONS
5669: where NOTIFICATION_ID = nid;
5670: exception
5671: when no_data_found then
5672: wf_core.token('NID', to_char(nid));

Line 5808: from WF_NOTIFICATIONS

5804: -- Get notification information
5805: begin
5806: select RECIPIENT_ROLE
5807: into n_to_role
5808: from WF_NOTIFICATIONS
5809: where NOTIFICATION_ID = nid;
5810: exception
5811: when no_data_found then
5812: wf_core.token('NID', to_char(nid));

Line 5938: from WF_NOTIFICATIONS

5934: -- Bug 1753464 included sort order for the query
5935: -- Bug 2439529 Altered query to use UNION instead of OR.
5936: cursor c1 is
5937: select NOTIFICATION_ID, RECIPIENT_ROLE, ACCESS_KEY, PRIORITY, DUE_DATE
5938: from WF_NOTIFICATIONS
5939: where STATUS = 'OPEN'
5940: and RECIPIENT_ROLE IN
5941: (select role from dual
5942: union

Line 6694: from WF_NOTIFICATIONS

6690: -- Get notification message and status
6691: begin
6692: select MESSAGE_NAME, MESSAGE_TYPE, STATUS
6693: into msg_name, msg_type, stat
6694: from WF_NOTIFICATIONS
6695: where NOTIFICATION_ID = nid;
6696: exception
6697: when no_data_found then
6698: wf_core.token('NID', to_char(nid));

Line 6909: WF_NOTIFICATIONS WN,

6905: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
6906: 'LOOKUP', WNA.TEXT_VALUE,
6907: WNA.TEXT_VALUE) VALUE
6908: from WF_NOTIFICATION_ATTRIBUTES WNA,
6909: WF_NOTIFICATIONS WN,
6910: WF_MESSAGE_ATTRIBUTES_VL WMA
6911: where WNA.NOTIFICATION_ID = nid
6912: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
6913: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 6938: from WF_NOTIFICATIONS

6934: -- Get notification message and status
6935: begin
6936: select MESSAGE_NAME, MESSAGE_TYPE, STATUS
6937: into msg_name, msg_type, stat
6938: from WF_NOTIFICATIONS
6939: where NOTIFICATION_ID = nid;
6940: exception
6941: when no_data_found then
6942: wf_core.token('NID', to_char(nid));

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

7103: comment := 'NULL';
7104: end if;
7105: -- validate the role before calling updateinfo
7106:
7107: -- update wf_notifications and wf_comments in QUESTION mode
7108: if (length(to_user) > 0 and length(comment) > 0) then
7109: wf_notification.UpdateInfo2(nid, to_user, from_addr, comment);
7110: end if;
7111: exception

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

7187: end if;
7188: end if;
7189: end if;
7190: end if;
7191: -- update wf_notifications and wf_comments in ANSWER mode
7192: to_user := NULL;
7193: wf_notification.UpdateInfo2(nid, to_user, from_addr, comment);
7194: exception
7195: when no_program_unit then

Line 7230: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

7226: select WMA.TYPE, WMA.DISPLAY_NAME,
7227: decode(WMA.TYPE, 'URL', WF_NOTIFICATION.GetUrlText(WNA.TEXT_VALUE,
7228: GetURLAttachment.nid), WNA.TEXT_VALUE) URL,
7229: WNA.NAME
7230: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
7231: WF_MESSAGE_ATTRIBUTES_VL WMA
7232: where WNA.NOTIFICATION_ID = GetURLAttachment.nid
7233: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
7234: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 8373: FROM wf_notifications

8369:
8370: -- Get message details
8371: SELECT message_type,message_name
8372: INTO l_msg_type,l_msg_name
8373: FROM wf_notifications
8374: WHERE notification_id = p_nid;
8375:
8376: -- Get template 'WARNING'
8377: SELECT subject, BODY, HTML_BODY