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_NOTIFICATION dependencies on WF_MESSAGE_ATTRIBUTES

Line 341: from WF_MESSAGE_ATTRIBUTES_VL MA,

337: NA.TEXT_VALUE,
338: NA.NUMBER_VALUE,
339: NA.DATE_VALUE
340: into l_dispname, l_type, l_format, l_textv, l_numberv, l_datev
341: from WF_MESSAGE_ATTRIBUTES_VL MA,
342: WF_NOTIFICATION_ATTRIBUTES NA,
343: WF_NOTIFICATIONS N
344: where NA.NAME = l_attr
345: and NA.NOTIFICATION_ID = nid

Line 1167: WF_MESSAGE_ATTRIBUTES WMA

1163: begin
1164: select WMA.TYPE, WMA.FORMAT
1165: into atype, format
1166: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
1167: WF_MESSAGE_ATTRIBUTES WMA
1168: where WNA.NOTIFICATION_ID = nid
1169: and WNA.NAME = aname
1170: and WNA.NOTIFICATION_ID = WN.NOTIFICATION_ID
1171: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 1522: WF_MESSAGE_ATTRIBUTES_VL WMA

1518: cursor notification_attrs_cursor(nid number) is
1519: select WNA.NAME, WMA.TYPE, WMA.FORMAT, WMA.DISPLAY_NAME,
1520: WNA.TEXT_VALUE, WNA.NUMBER_VALUE, WNA.DATE_VALUE
1521: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
1522: WF_MESSAGE_ATTRIBUTES_VL WMA
1523: where WNA.NOTIFICATION_ID = nid
1524: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1525: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
1526: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 1863: WF_MESSAGE_ATTRIBUTES_VL WMA

1859: cursor notification_attrs_cursor(nid number) is
1860: select WNA.NAME, WMA.TYPE, WMA.FORMAT, WMA.DISPLAY_NAME,
1861: WNA.TEXT_VALUE, WNA.NUMBER_VALUE, WNA.DATE_VALUE
1862: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
1863: WF_MESSAGE_ATTRIBUTES_VL WMA
1864: where WNA.NOTIFICATION_ID = nid
1865: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1866: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
1867: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 2228: WF_MESSAGE_ATTRIBUTES WMA

2224: begin
2225: select WMA.TYPE, WMA.SUBTYPE, WMA.FORMAT
2226: into atype, subtype, format
2227: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
2228: WF_MESSAGE_ATTRIBUTES WMA
2229: where WNA.NOTIFICATION_ID = nid
2230: and WNA.NAME = aname
2231: and WNA.NOTIFICATION_ID = WN.NOTIFICATION_ID
2232: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 2283: WF_MESSAGE_ATTRIBUTES WMA

2279: begin
2280: select WMA.TYPE, WMA.FORMAT
2281: into atype, format
2282: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
2283: WF_MESSAGE_ATTRIBUTES WMA
2284: where WNA.NOTIFICATION_ID = nid
2285: and WNA.NAME = aname
2286: and WNA.NOTIFICATION_ID = WN.NOTIFICATION_ID
2287: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 2623: WF_MESSAGE_ATTRIBUTES_TL WMATL, WF_MESSAGE_ATTRIBUTES WMA

2619: begin
2620: select WMATL.DISPLAY_NAME, NVL(WMA.FORMAT, '_blank')
2621: into display_name, target
2622: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
2623: WF_MESSAGE_ATTRIBUTES_TL WMATL, WF_MESSAGE_ATTRIBUTES WMA
2624: where WNA.NOTIFICATION_ID = nid
2625: and WNA.NAME = aname
2626: and WNA.NOTIFICATION_ID = WN.NOTIFICATION_ID
2627: and WN.MESSAGE_NAME = WMATL.MESSAGE_NAME

Line 2798: FROM wf_message_attributes wma,

2794: -- 2. FYI notification with at least one Reassign action
2795: -- Query to check if the ntf is FYI or not
2796: SELECT count(1)
2797: INTO l_resp_cnt
2798: FROM wf_message_attributes wma,
2799: wf_notifications wn
2800: WHERE wn.notification_id = nid
2801: AND wma.message_type = wn.message_type
2802: AND wma.message_name = wn.message_name

Line 3212: WF_MESSAGE_ATTRIBUTES WMA

3208: cursor attrcurs(ruleid in number) is
3209: select WRRA.NAME, WRRA.TEXT_VALUE, WRRA.NUMBER_VALUE, WRRA.DATE_VALUE,
3210: WMA.TYPE
3211: from WF_ROUTING_RULE_ATTRIBUTES WRRA, WF_ROUTING_RULES WRR,
3212: WF_MESSAGE_ATTRIBUTES WMA
3213: where WRRA.RULE_ID = ruleid
3214: and WRRA.RULE_ID = WRR.RULE_ID
3215: and WRR.MESSAGE_TYPE = WMA.MESSAGE_TYPE
3216: and WRR.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 3723: from WF_MESSAGE_ATTRIBUTES

3719:
3720: cursor message_attrs_cursor(msg_type varchar2, msg_name varchar2) is
3721: select NAME, TYPE, SUBTYPE, VALUE_TYPE,
3722: TEXT_DEFAULT, NUMBER_DEFAULT, DATE_DEFAULT
3723: from WF_MESSAGE_ATTRIBUTES
3724: where MESSAGE_TYPE = msg_type
3725: and MESSAGE_NAME = msg_name;
3726: begin
3727: -- Check role is valid and get mail preference

Line 4719: from WF_NOTIFICATIONS WN, WF_MESSAGE_ATTRIBUTES WMA

4715: -- regardless of role notification_preference setting.
4716: begin
4717: select 1 into dummy from sys.dual where exists
4718: (select NULL
4719: from WF_NOTIFICATIONS WN, WF_MESSAGE_ATTRIBUTES WMA
4720: where WN.NOTIFICATION_ID = nid
4721: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME
4722: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
4723: and WMA.SUBTYPE = 'RESPOND');

Line 5186: WF_MESSAGE_ATTRIBUTES_VL MA,

5182: -- Any existence of response attribute constitutes a response required.
5183: cursor attrs(mnid in number) is
5184: select MA.NAME
5185: from WF_NOTIFICATION_ATTRIBUTES NA,
5186: WF_MESSAGE_ATTRIBUTES_VL MA,
5187: WF_NOTIFICATIONS N
5188: where N.NOTIFICATION_ID = mnid
5189: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
5190: and MA.MESSAGE_NAME = N.MESSAGE_NAME

Line 5300: from WF_MESSAGE_ATTRIBUTES_VL WMA

5296: -- of another.
5297: cursor message_attrs_cursor(c_message_type VARCHAR2,
5298: c_message_name VARCHAR2) is
5299: select WMA.NAME, WMA.DISPLAY_NAME, WMA.TYPE
5300: from WF_MESSAGE_ATTRIBUTES_VL WMA
5301: where WMA.MESSAGE_TYPE = c_message_type
5302: and WMA.MESSAGE_NAME = c_message_name
5303: order by length(WMA.NAME) desc;
5304:

Line 5372: from WF_MESSAGE_ATTRIBUTES_VL WMA

5368: -- of another.
5369: cursor message_attrs_cursor(c_message_type VARCHAR2,
5370: c_message_name VARCHAR2) is
5371: select WMA.NAME, WMA.DISPLAY_NAME, WMA.TYPE
5372: from WF_MESSAGE_ATTRIBUTES_VL WMA
5373: where WMA.MESSAGE_TYPE = c_message_type
5374: and WMA.MESSAGE_NAME = c_message_name
5375: order by length(WMA.NAME) desc;
5376:

Line 5700: WF_MESSAGE_ATTRIBUTES WMA,

5696: -- <7443088> improved query
5697: select NAME into aname from
5698: (select WMA.NAME
5699: from WF_NOTIFICATIONS WN,
5700: WF_MESSAGE_ATTRIBUTES WMA,
5701: WF_NOTIFICATION_ATTRIBUTES NA
5702: where WN.NOTIFICATION_ID = nid
5703: and wn.notification_id = na.notification_id
5704: and wma.name = na.name

Line 6378: from WF_MESSAGE_ATTRIBUTES WMA

6374: and BEGIN_DATE<=begindate
6375: and STATUS = 'OPEN'
6376: and not exists (
6377: select NULL
6378: from WF_MESSAGE_ATTRIBUTES WMA
6379: where WMA.MESSAGE_TYPE = WN.MESSAGE_TYPE
6380: and WMA.MESSAGE_NAME = WN.MESSAGE_NAME
6381: and WMA.SUBTYPE = 'RESPOND');
6382:

Line 8654: WF_MESSAGE_ATTRIBUTES WMA,

8650: -- <7443088> improved query
8651: select NAME into aname from
8652: (select WMA.NAME
8653: from WF_NOTIFICATIONS WN,
8654: WF_MESSAGE_ATTRIBUTES WMA,
8655: WF_NOTIFICATION_ATTRIBUTES NA
8656: where WN.NOTIFICATION_ID = nid
8657: and wn.notification_id = na.notification_id
8658: and wma.name = na.name

Line 8823: WF_MESSAGE_ATTRIBUTES_VL WMA

8819:
8820: cursor cur_hdr_region is
8821: select WNA.NAME, WNA.TEXT_VALUE
8822: from WF_NOTIFICATION_ATTRIBUTES WNA,
8823: WF_MESSAGE_ATTRIBUTES_VL WMA
8824: where WNA.NOTIFICATION_ID = nid
8825: and WMA.NAME = WNA.NAME
8826: and WMA.TYPE = 'DOCUMENT'
8827: and WNA.NAME = '#HDR_REGION';

Line 8968: WF_MESSAGE_ATTRIBUTES_VL WMA

8964: -- Cursur to check for each message Attribute
8965: cursor cur_msg_attrs(nid number, msgToken varchar2) is
8966: select WNA.NAME, WNA.TEXT_VALUE, WMA.TYPE
8967: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
8968: WF_MESSAGE_ATTRIBUTES_VL WMA
8969: where WNA.NOTIFICATION_ID = nid
8970: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
8971: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
8972: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 9722: FROM wf_message_attributes wma,

9718: AND (cp_from_date is null or wn.begin_date >= cp_from_date)
9719: AND (cp_to_date is null or wn.begin_date <= cp_to_date )
9720: AND NOT EXISTS (
9721: SELECT 1
9722: FROM wf_message_attributes wma,
9723: wf_notifications wn2
9724: WHERE wn2.notification_id = wn.notification_id
9725: AND wma.message_type = wn2.message_type
9726: AND wma.message_name = wn2.message_name

Line 9816: FROM wf_message_attributes wma,

9812: begin
9813:
9814: SELECT count(1)
9815: INTO l_resp_attr_cnt
9816: FROM wf_message_attributes wma,
9817: wf_notifications wn
9818: WHERE wn.notification_id = nid
9819: AND wma.message_type = wn.message_type
9820: AND wma.message_name = wn.message_name

Line 9870: WF_MESSAGE_ATTRIBUTES WMA,

9866: cursor notification_attrs_cursor(nid number) is
9867: select WNA.NAME, WMA.TYPE, WNA.TEXT_VALUE, WNA.NUMBER_VALUE,
9868: WNA.DATE_VALUE
9869: from WF_NOTIFICATION_ATTRIBUTES WNA,
9870: WF_MESSAGE_ATTRIBUTES WMA,
9871: WF_NOTIFICATIONS WN
9872: where WNA.NOTIFICATION_ID = nid
9873: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
9874: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE