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

Line 41: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

37: wf_resourceList_rec_t INDEX BY BINARY_INTEGER;
38:
39: cursor g_urls(p_nid varchar2) is
40: select WMA.TYPE, WMA.DISPLAY_NAME, WNA.TEXT_VALUE, WNA.NAME
41: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
42: WF_MESSAGE_ATTRIBUTES_VL WMA
43: where WNA.NOTIFICATION_ID = p_nid
44: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
45: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 1034: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

1030: cursor c_attr(p_nid varchar2) is
1031: select WMA.TYPE, WMA.DISPLAY_NAME,
1032: decode(WMA.TYPE, 'URL', WF_NOTIFICATION.GetUrlText(WNA.TEXT_VALUE,
1033: p_nid), WNA.TEXT_VALUE) URL, WNA.NAME
1034: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
1035: WF_MESSAGE_ATTRIBUTES_VL WMA
1036: where WNA.NOTIFICATION_ID = p_nid
1037: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1038: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 1392: WF_NOTIFICATIONS WN,

1388: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1389: 'LOOKUP', WNA.TEXT_VALUE,
1390: WNA.TEXT_VALUE) VALUE
1391: from WF_NOTIFICATION_ATTRIBUTES WNA,
1392: WF_NOTIFICATIONS WN,
1393: WF_MESSAGE_ATTRIBUTES_VL WMA
1394: where WNA.NOTIFICATION_ID = p_nid
1395: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1396: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 1464: l_priority wf_notifications.priority%TYPE;

1460: l_pos integer;
1461: l_occurance integer := 1;
1462: l_item_type wf_items.item_type%TYPE;
1463: l_item_key wf_items.item_key%TYPE;
1464: l_priority wf_notifications.priority%TYPE;
1465: l_access_key wf_notifications.access_key%TYPE;
1466:
1467: l_response integer;
1468:

Line 1465: l_access_key wf_notifications.access_key%TYPE;

1461: l_occurance integer := 1;
1462: l_item_type wf_items.item_type%TYPE;
1463: l_item_key wf_items.item_key%TYPE;
1464: l_priority wf_notifications.priority%TYPE;
1465: l_access_key wf_notifications.access_key%TYPE;
1466:
1467: l_response integer;
1468:
1469: l_attrlist wf_xml_attr_table_type;

Line 1551: from wf_notifications_view

1547:
1548: begin
1549: select priority, access_key, status
1550: into l_priority, l_access_key, l_status
1551: from wf_notifications_view
1552: where notification_id = p_nid;
1553: exception
1554: when NO_DATA_FOUND then
1555: wf_core.raise('WFNTFGM_FAILED');

Line 1628: WF_NOTIFICATIONS N

1624: select 1 into l_response
1625: from dual
1626: where exists (select NULL
1627: from WF_MESSAGE_ATTRIBUTES MA,
1628: WF_NOTIFICATIONS N
1629: where N.NOTIFICATION_ID = p_nid
1630: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE
1631: and MA.MESSAGE_NAME = N.MESSAGE_NAME
1632: and MA.SUBTYPE = 'RESPOND');

Line 1683: l_priority wf_notifications.priority%TYPE;

1679: -- l_doc CLOB;
1680: l_docIdx pls_integer;
1681: l_pos integer;
1682: l_occurance integer := 1;
1683: l_priority wf_notifications.priority%TYPE;
1684: l_status wf_notifications.status%TYPE;
1685: l_recipient wf_notifications.recipient_role%TYPE;
1686:
1687: l_attrlist wf_xml_attr_table_type;

Line 1684: l_status wf_notifications.status%TYPE;

1680: l_docIdx pls_integer;
1681: l_pos integer;
1682: l_occurance integer := 1;
1683: l_priority wf_notifications.priority%TYPE;
1684: l_status wf_notifications.status%TYPE;
1685: l_recipient wf_notifications.recipient_role%TYPE;
1686:
1687: l_attrlist wf_xml_attr_table_type;
1688: l_str varchar2 (250);

Line 1685: l_recipient wf_notifications.recipient_role%TYPE;

1681: l_pos integer;
1682: l_occurance integer := 1;
1683: l_priority wf_notifications.priority%TYPE;
1684: l_status wf_notifications.status%TYPE;
1685: l_recipient wf_notifications.recipient_role%TYPE;
1686:
1687: l_attrlist wf_xml_attr_table_type;
1688: l_str varchar2 (250);
1689:

Line 1730: from wf_notifications

1726:
1727: begin
1728: select recipient_role, priority, status, more_info_role
1729: into l_recipient, l_priority, l_status, l_more_info_role
1730: from wf_notifications
1731: where notification_id = p_nid;
1732: exception
1733: when NO_DATA_FOUND then
1734: wf_core.raise('WFNTFGM_FAILED');

Line 1791: l_priority wf_notifications.priority%TYPE;

1787: p_message in out NOCOPY VARCHAR2)
1788: is
1789: l_pos integer;
1790: l_occurance integer := 1;
1791: l_priority wf_notifications.priority%TYPE;
1792: l_status wf_notifications.status%TYPE;
1793: l_recipient wf_notifications.recipient_role%TYPE;
1794:
1795: l_attrlist wf_xml_attr_table_type;

Line 1792: l_status wf_notifications.status%TYPE;

1788: is
1789: l_pos integer;
1790: l_occurance integer := 1;
1791: l_priority wf_notifications.priority%TYPE;
1792: l_status wf_notifications.status%TYPE;
1793: l_recipient wf_notifications.recipient_role%TYPE;
1794:
1795: l_attrlist wf_xml_attr_table_type;
1796: l_str varchar2 (250);

Line 1793: l_recipient wf_notifications.recipient_role%TYPE;

1789: l_pos integer;
1790: l_occurance integer := 1;
1791: l_priority wf_notifications.priority%TYPE;
1792: l_status wf_notifications.status%TYPE;
1793: l_recipient wf_notifications.recipient_role%TYPE;
1794:
1795: l_attrlist wf_xml_attr_table_type;
1796: l_str varchar2 (250);
1797:

Line 1833: from wf_notifications

1829:
1830: begin
1831: select recipient_role, priority, status, more_info_role
1832: into l_recipient, l_priority, l_status, l_more_info_role
1833: from wf_notifications
1834: where notification_id = p_nid;
1835: exception
1836: when NO_DATA_FOUND then
1837: wf_core.raise('WFNTFGM_FAILED');

Line 1902: from wf_notifications

1898: -- indicates that a notification should be sent.
1899: begin
1900: select recipient_role
1901: into l_recipient_role
1902: from wf_notifications
1903: where notification_id = p_nid
1904: and ((MAIL_STATUS = 'MAIL' and STATUS <> 'CLOSED')
1905: or (MAIL_STATUS = 'INVALID'));
1906: exception

Line 2020: from wf_notifications

2016: -- indicates that a notification should be sent.
2017: begin
2018: select recipient_role
2019: into l_recipient_role
2020: from wf_notifications
2021: where notification_id = p_nid
2022: and MAIL_STATUS in ('MAIL', 'INVALID');
2023: exception
2024: when NO_DATA_FOUND then

Line 2084: from wf_notifications

2080: -- indicates that a notification should be sent.
2081: begin
2082: select recipient_role, more_info_role
2083: into l_recipient_role, l_more_info_role
2084: from wf_notifications
2085: where notification_id = p_nid
2086: and MAIL_STATUS in ('MAIL', 'INVALID')
2087: and STATUS <> 'CLOSED';
2088: exception

Line 2392: l_recipient WF_NOTIFICATIONS.RECIPIENT_ROLE%TYPE := NULL;

2388: l_nid number;
2389: l_queue_name varchar2(255);
2390: l_status varchar2(8) := NULL;
2391: l_currstatus varchar2(8);
2392: l_recipient WF_NOTIFICATIONS.RECIPIENT_ROLE%TYPE := NULL;
2393: l_attrlist wf_xml_attr_table_type;
2394: l_timeout BOOLEAN;
2395: l_pos integer;
2396: l_statusOK boolean;

Line 2437: from wf_notifications

2433: -- Verify that the status of the notification is
2434: -- still OK.
2435: begin
2436: select status into l_currstatus
2437: from wf_notifications
2438: where notification_id = l_nid
2439: and status in ('OPEN','CANCELED', 'CLOSED')
2440: and mail_status in ('MAIL','INVALID','FAILED');
2441: l_statusOK := TRUE;

Line 3203: from WF_NOTIFICATIONS

3199: select ACCESS_KEY, PRIORITY, STATUS, MESSAGE_TYPE,
3200: MESSAGE_NAME, MORE_INFO_ROLE
3201: into access_key, priority, status, messageType,
3202: messageName, moreInfoRole
3203: from WF_NOTIFICATIONS
3204: where NOTIFICATION_ID = nid;
3205: exception
3206: when no_data_found then
3207: -- 4104735 Empty documents now provide a document type and

Line 4239: from WF_NOTIFICATIONS

4235: begin -- 3741599 If there is no notification, exit gracefully
4236: select NVL(MORE_INFO_ROLE, RECIPIENT_ROLE), STATUS, MAIL_STATUS,
4237: MESSAGE_TYPE, MESSAGE_NAME
4238: into recipient_role, status, mail_status, messageType, messageName
4239: from WF_NOTIFICATIONS
4240: where NOTIFICATION_ID = nid;
4241: exception
4242: when no_data_found then
4243: str := '';

Line 5135: from wf_notifications

5131: begin
5132: begin
5133: select 1
5134: into l_open
5135: from wf_notifications
5136: where notification_id = nid
5137: and status = 'OPEN';
5138: exception
5139: when others then l_open := 0;

Line 5824: FROM wf_notifications

5820: -- to recepient_role if notification more_info_role is not null.
5821: CURSOR c_get_summary_roles is
5822: SELECT recipient from
5823: (SELECT distinct nvl(more_info_role,recipient_role) recipient
5824: FROM wf_notifications
5825: WHERE mail_status is null
5826: AND status = 'OPEN'
5827: AND rownum > 0)
5828: WHERE Wf_Directory.GetRoleNtfPref(recipient) in ('SUMMARY', 'SUMHTML');

Line 6068: from WF_NOTIFICATIONS

6064: error_stack := p_event.getErrorStack;
6065: begin
6066: select MESSAGE_TYPE, CALLBACK, CONTEXT, STATUS
6067: into itemType, cb, ctx, status
6068: from WF_NOTIFICATIONS
6069: where NOTIFICATION_ID = nid;
6070:
6071: -- If the notification is closed, then do not bother
6072: -- to process any errors.

Line 6077: update wf_notifications

6073: if status = 'CLOSED' then
6074: return 'SUCCESS';
6075: end if;
6076:
6077: update wf_notifications
6078: set mail_status = 'ERROR'
6079: where notification_id = nid;
6080:
6081: if ctx is not null then