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_MESSAGE_ATTRIBUTES

Line 252: from WF_MESSAGE_ATTRIBUTES MA

248: set N.STATUS = 'CLOSED',
249: N.END_DATE = sysdate
250: where N.NOTIFICATION_ID = nid
251: and not exists (select NULL
252: from WF_MESSAGE_ATTRIBUTES MA
253: where MA.MESSAGE_TYPE = N.MESSAGE_TYPE
254: and MA.MESSAGE_NAME = N.MESSAGE_NAME
255: and MA.SUBTYPE = 'RESPOND')
256: and (UpdateStatus2.autoclose = 'Y'

Line 1294: WF_MESSAGE_ATTRIBUTES_VL WMA

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
1298: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 1365: WF_MESSAGE_ATTRIBUTES_VL WMA

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
1369: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 1773: WF_MESSAGE_ATTRIBUTES_VL WMA

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
1777: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 1857: WF_MESSAGE_ATTRIBUTES_VL WMA

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
1861: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 1960: WF_MESSAGE_ATTRIBUTES_VL WMA

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
1964: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 2032: WF_MESSAGE_ATTRIBUTES_VL WMA

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
2036: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 2353: from WF_MESSAGE_ATTRIBUTES MA,

2349: begin
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

Line 2530: from WF_MESSAGE_ATTRIBUTES_VL WMA,

2526: document_type in out NOCOPY varchar2)
2527: is
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

Line 2978: from WF_MESSAGE_ATTRIBUTES_TL

2974: -- Get Click here Response display value
2975: begin
2976: select DESCRIPTION
2977: into n_disp_click
2978: from WF_MESSAGE_ATTRIBUTES_TL
2979: where MESSAGE_TYPE = t_type
2980: and MESSAGE_NAME = t_name
2981: and NAME = 'CLICK_HERE_RESPONSE'
2982: and LANGUAGE = userenv('LANG');

Line 4267: WF_MESSAGE_ATTRIBUTES_VL WMA

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
4271: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 4352: WF_MESSAGE_ATTRIBUTES_VL WMA

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
4356: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 5168: from WF_MESSAGE_ATTRIBUTES_TL

5164: -- Get Click here Response display value
5165: begin
5166: select DESCRIPTION
5167: into n_disp_click
5168: from WF_MESSAGE_ATTRIBUTES_TL
5169: where MESSAGE_TYPE = t_type
5170: and MESSAGE_NAME = t_name
5171: and NAME = 'CLICK_HERE_RESPONSE'
5172: and LANGUAGE = userenv('LANG');

Line 6425: from WF_MESSAGE_ATTRIBUTES_VL

6421: -- Order-by is to insure longest prompts are processed first to prevent
6422: -- problems where one prompt is a substring of another prompt.
6423: cursor c1 is
6424: select NAME, DISPLAY_NAME, TYPE, FORMAT
6425: from WF_MESSAGE_ATTRIBUTES_VL
6426: where MESSAGE_NAME = msg_name
6427: and MESSAGE_TYPE = msg_type
6428: and SUBTYPE = 'RESPOND'
6429: and TYPE not in ('FORM', 'URL')

Line 6656: WF_MESSAGE_ATTRIBUTES_VL WMA

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
6660: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 6977: WF_MESSAGE_ATTRIBUTES_VL WMA

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
6981: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME