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 39: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

35:
36:
37: cursor g_urls(p_nid varchar2) is
38: select WMA.TYPE, WMA.DISPLAY_NAME, WNA.TEXT_VALUE, WNA.NAME
39: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
40: WF_MESSAGE_ATTRIBUTES_VL WMA
41: where WNA.NOTIFICATION_ID = p_nid
42: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
43: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 82: -- Bug 10202313: global variables to store status, mail_status of WF_NOTIFICATIONS table

78: g_base_nlsNumericCharacters v$nls_parameters.value%TYPE := wf_core.nls_numeric_characters;
79:
80: g_WebMail_PostScript_Msg varchar2(1024);
81:
82: -- Bug 10202313: global variables to store status, mail_status of WF_NOTIFICATIONS table
83: -- which will be passed as parameters to WF_MAIL.GetLOBMessage4() API
84: g_status wf_notifications.status%TYPE;
85: g_mstatus wf_notifications.mail_status%TYPE;
86:

Line 84: g_status wf_notifications.status%TYPE;

80: g_WebMail_PostScript_Msg varchar2(1024);
81:
82: -- Bug 10202313: global variables to store status, mail_status of WF_NOTIFICATIONS table
83: -- which will be passed as parameters to WF_MAIL.GetLOBMessage4() API
84: g_status wf_notifications.status%TYPE;
85: g_mstatus wf_notifications.mail_status%TYPE;
86:
87:
88: -- Return TRUE if the URL points to a image file.

Line 85: g_mstatus wf_notifications.mail_status%TYPE;

81:
82: -- Bug 10202313: global variables to store status, mail_status of WF_NOTIFICATIONS table
83: -- which will be passed as parameters to WF_MAIL.GetLOBMessage4() API
84: g_status wf_notifications.status%TYPE;
85: g_mstatus wf_notifications.mail_status%TYPE;
86:
87:
88: -- Return TRUE if the URL points to a image file.
89: -- The URL is pretested to ensure that it does NOT contain

Line 917: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

913: cursor c_attr(p_nid varchar2) is
914: select WMA.TYPE, WMA.DISPLAY_NAME,
915: decode(WMA.TYPE, 'URL', WF_NOTIFICATION.GetUrlText(WNA.TEXT_VALUE,
916: p_nid), WNA.TEXT_VALUE) URL, WNA.NAME
917: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
918: WF_MESSAGE_ATTRIBUTES_VL WMA
919: where WNA.NOTIFICATION_ID = p_nid
920: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
921: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 1321: WF_NOTIFICATIONS WN,

1317: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1318: 'LOOKUP', WNA.TEXT_VALUE,
1319: WNA.TEXT_VALUE) VALUE
1320: from WF_NOTIFICATION_ATTRIBUTES WNA,
1321: WF_NOTIFICATIONS WN,
1322: WF_MESSAGE_ATTRIBUTES_VL WMA
1323: where WNA.NOTIFICATION_ID = p_nid
1324: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1325: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 1393: l_priority wf_notifications.priority%TYPE;

1389: l_pos integer;
1390: l_occurance integer := 1;
1391: l_item_type wf_items.item_type%TYPE;
1392: l_item_key wf_items.item_key%TYPE;
1393: l_priority wf_notifications.priority%TYPE;
1394: l_access_key wf_notifications.access_key%TYPE;
1395:
1396: l_response integer;
1397:

Line 1394: l_access_key wf_notifications.access_key%TYPE;

1390: l_occurance integer := 1;
1391: l_item_type wf_items.item_type%TYPE;
1392: l_item_key wf_items.item_key%TYPE;
1393: l_priority wf_notifications.priority%TYPE;
1394: l_access_key wf_notifications.access_key%TYPE;
1395:
1396: l_response integer;
1397:
1398: l_attrlist wf_xml_attr_table_type;

Line 1480: from wf_notifications_view

1476:
1477: begin
1478: select priority, access_key, status
1479: into l_priority, l_access_key, l_status
1480: from wf_notifications_view
1481: where notification_id = p_nid;
1482: exception
1483: when NO_DATA_FOUND then
1484: wf_core.raise('WFNTFGM_FAILED');

Line 1557: WF_NOTIFICATIONS N

1553: select 1 into l_response
1554: from dual
1555: where exists (select NULL
1556: from WF_MESSAGE_ATTRIBUTES MA,
1557: WF_NOTIFICATIONS N
1558: where N.NOTIFICATION_ID = p_nid
1559: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE
1560: and MA.MESSAGE_NAME = N.MESSAGE_NAME
1561: and MA.SUBTYPE = 'RESPOND');

Line 1612: l_priority wf_notifications.priority%TYPE;

1608: -- l_doc CLOB;
1609: l_docIdx pls_integer;
1610: l_pos integer;
1611: l_occurance integer := 1;
1612: l_priority wf_notifications.priority%TYPE;
1613: l_status wf_notifications.status%TYPE;
1614: l_recipient wf_notifications.recipient_role%TYPE;
1615:
1616: l_attrlist wf_xml_attr_table_type;

Line 1613: l_status wf_notifications.status%TYPE;

1609: l_docIdx pls_integer;
1610: l_pos integer;
1611: l_occurance integer := 1;
1612: l_priority wf_notifications.priority%TYPE;
1613: l_status wf_notifications.status%TYPE;
1614: l_recipient wf_notifications.recipient_role%TYPE;
1615:
1616: l_attrlist wf_xml_attr_table_type;
1617: l_str varchar2 (250);

Line 1614: l_recipient wf_notifications.recipient_role%TYPE;

1610: l_pos integer;
1611: l_occurance integer := 1;
1612: l_priority wf_notifications.priority%TYPE;
1613: l_status wf_notifications.status%TYPE;
1614: l_recipient wf_notifications.recipient_role%TYPE;
1615:
1616: l_attrlist wf_xml_attr_table_type;
1617: l_str varchar2 (250);
1618:

Line 1659: from wf_notifications

1655:
1656: begin
1657: select recipient_role, priority, status, more_info_role
1658: into l_recipient, l_priority, l_status, l_more_info_role
1659: from wf_notifications
1660: where notification_id = p_nid;
1661: exception
1662: when NO_DATA_FOUND then
1663: wf_core.raise('WFNTFGM_FAILED');

Line 1720: l_priority wf_notifications.priority%TYPE;

1716: p_message in out NOCOPY VARCHAR2)
1717: is
1718: l_pos integer;
1719: l_occurance integer := 1;
1720: l_priority wf_notifications.priority%TYPE;
1721: l_status wf_notifications.status%TYPE;
1722: l_recipient wf_notifications.recipient_role%TYPE;
1723:
1724: l_attrlist wf_xml_attr_table_type;

Line 1721: l_status wf_notifications.status%TYPE;

1717: is
1718: l_pos integer;
1719: l_occurance integer := 1;
1720: l_priority wf_notifications.priority%TYPE;
1721: l_status wf_notifications.status%TYPE;
1722: l_recipient wf_notifications.recipient_role%TYPE;
1723:
1724: l_attrlist wf_xml_attr_table_type;
1725: l_str varchar2 (250);

Line 1722: l_recipient wf_notifications.recipient_role%TYPE;

1718: l_pos integer;
1719: l_occurance integer := 1;
1720: l_priority wf_notifications.priority%TYPE;
1721: l_status wf_notifications.status%TYPE;
1722: l_recipient wf_notifications.recipient_role%TYPE;
1723:
1724: l_attrlist wf_xml_attr_table_type;
1725: l_str varchar2 (250);
1726:

Line 1762: from wf_notifications

1758:
1759: begin
1760: select recipient_role, priority, status, more_info_role
1761: into l_recipient, l_priority, l_status, l_more_info_role
1762: from wf_notifications
1763: where notification_id = p_nid;
1764: exception
1765: when NO_DATA_FOUND then
1766: wf_core.raise('WFNTFGM_FAILED');

Line 1831: from wf_notifications

1827: -- indicates that a notification should be sent.
1828: begin
1829: select recipient_role
1830: into l_recipient_role
1831: from wf_notifications
1832: where notification_id = p_nid
1833: and ((MAIL_STATUS = 'MAIL' and STATUS <> 'CLOSED')
1834: or (MAIL_STATUS = 'INVALID'));
1835: exception

Line 1949: from wf_notifications

1945: -- indicates that a notification should be sent.
1946: begin
1947: select recipient_role
1948: into l_recipient_role
1949: from wf_notifications
1950: where notification_id = p_nid
1951: and MAIL_STATUS in ('MAIL', 'INVALID');
1952: exception
1953: when NO_DATA_FOUND then

Line 2013: from wf_notifications

2009: -- indicates that a notification should be sent.
2010: begin
2011: select recipient_role, more_info_role
2012: into l_recipient_role, l_more_info_role
2013: from wf_notifications
2014: where notification_id = p_nid
2015: and MAIL_STATUS in ('MAIL', 'INVALID')
2016: and STATUS <> 'CLOSED';
2017: exception

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

2317: l_nid number;
2318: l_queue_name varchar2(255);
2319: l_status varchar2(8) := NULL;
2320: l_currstatus varchar2(8);
2321: l_recipient WF_NOTIFICATIONS.RECIPIENT_ROLE%TYPE := NULL;
2322: l_attrlist wf_xml_attr_table_type;
2323: l_timeout BOOLEAN;
2324: l_pos integer;
2325: l_statusOK boolean;

Line 2366: from wf_notifications

2362: -- Verify that the status of the notification is
2363: -- still OK.
2364: begin
2365: select status into l_currstatus
2366: from wf_notifications
2367: where notification_id = l_nid
2368: and status in ('OPEN','CANCELED', 'CLOSED')
2369: and mail_status in ('MAIL','INVALID','FAILED');
2370: l_statusOK := TRUE;

Line 3210: from WF_NOTIFICATIONS

3206: select ACCESS_KEY, PRIORITY, STATUS, MESSAGE_TYPE,
3207: MESSAGE_NAME, MORE_INFO_ROLE
3208: into access_key, priority, status, messageType,
3209: messageName, moreInfoRole
3210: from WF_NOTIFICATIONS
3211: where NOTIFICATION_ID = nid;
3212: exception
3213: when no_data_found then
3214: GenerateEmptyDoc(nid, p_pos, p_doc, 'no_data_found', FALSE);

Line 4230: from WF_NOTIFICATIONS

4226: begin -- 3741599 If there is no notification, exit gracefully
4227: select NVL(MORE_INFO_ROLE, RECIPIENT_ROLE), STATUS, MAIL_STATUS,
4228: MESSAGE_TYPE, MESSAGE_NAME
4229: into recipient_role, status, mail_status, messageType, messageName
4230: from WF_NOTIFICATIONS
4231: where NOTIFICATION_ID = nid;
4232: exception
4233: when no_data_found then
4234: GenerateEmptyDoc(nid, 0, p_doc, 'no_data_found', TRUE);

Line 5022: from wf_notifications

5018: begin
5019: begin
5020: select 1
5021: into l_open
5022: from wf_notifications
5023: where notification_id = nid
5024: and status = 'OPEN';
5025: exception
5026: when others then l_open := 0;

Line 5728: FROM wf_notifications

5724: -- to recepient_role if notification more_info_role is not null.
5725: CURSOR c_get_summary_roles is
5726: SELECT recipient from
5727: (SELECT distinct nvl(more_info_role,recipient_role) recipient
5728: FROM wf_notifications
5729: WHERE mail_status is null
5730: AND status = 'OPEN'
5731: AND rownum > 0)
5732: WHERE Wf_Directory.GetRoleNtfPref(recipient) in ('SUMMARY', 'SUMHTML');

Line 5739: FROM wf_notifications

5735: -- and having some open notifications
5736: CURSOR c_get_query_roles is
5737: SELECT recipient from
5738: (SELECT distinct nvl(more_info_role,recipient_role) recipient
5739: FROM wf_notifications
5740: WHERE mail_status is null
5741: AND status = 'OPEN'
5742: AND rownum > 0) , wf_roles wr
5743: WHERE recipient = wr.NAME

Line 6029: from WF_NOTIFICATIONS

6025: error_stack := p_event.getErrorStack;
6026: begin
6027: select MESSAGE_TYPE, CALLBACK, CONTEXT, STATUS
6028: into itemType, cb, ctx, status
6029: from WF_NOTIFICATIONS
6030: where NOTIFICATION_ID = nid;
6031:
6032: -- If the notification is closed, then do not bother
6033: -- to process any errors.

Line 6038: update wf_notifications

6034: if status = 'CLOSED' then
6035: return 'SUCCESS';
6036: end if;
6037:
6038: update wf_notifications
6039: set mail_status = 'ERROR'
6040: where notification_id = nid;
6041:
6042: if ctx is not null then