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 1128: WF_MESSAGE_ATTRIBUTES WMA

1124: begin
1125: select WMA.TYPE, WMA.FORMAT
1126: into atype, format
1127: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
1128: WF_MESSAGE_ATTRIBUTES WMA
1129: where WNA.NOTIFICATION_ID = nid
1130: and WNA.NAME = aname
1131: and WNA.NOTIFICATION_ID = WN.NOTIFICATION_ID
1132: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 1482: WF_MESSAGE_ATTRIBUTES_VL WMA

1478: cursor notification_attrs_cursor(nid number) is
1479: select WNA.NAME, WMA.TYPE, WMA.FORMAT, WMA.DISPLAY_NAME,
1480: WNA.TEXT_VALUE, WNA.NUMBER_VALUE, WNA.DATE_VALUE
1481: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
1482: WF_MESSAGE_ATTRIBUTES_VL WMA
1483: where WNA.NOTIFICATION_ID = nid
1484: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1485: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
1486: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 1796: WF_MESSAGE_ATTRIBUTES_VL WMA

1792: cursor notification_attrs_cursor(nid number) is
1793: select WNA.NAME, WMA.TYPE, WMA.FORMAT, WMA.DISPLAY_NAME,
1794: WNA.TEXT_VALUE, WNA.NUMBER_VALUE, WNA.DATE_VALUE
1795: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
1796: WF_MESSAGE_ATTRIBUTES_VL WMA
1797: where WNA.NOTIFICATION_ID = nid
1798: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1799: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
1800: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 2161: WF_MESSAGE_ATTRIBUTES WMA

2157: begin
2158: select WMA.TYPE, WMA.SUBTYPE, WMA.FORMAT
2159: into atype, subtype, format
2160: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
2161: WF_MESSAGE_ATTRIBUTES WMA
2162: where WNA.NOTIFICATION_ID = nid
2163: and WNA.NAME = aname
2164: and WNA.NOTIFICATION_ID = WN.NOTIFICATION_ID
2165: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 2216: WF_MESSAGE_ATTRIBUTES WMA

2212: begin
2213: select WMA.TYPE, WMA.FORMAT
2214: into atype, format
2215: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
2216: WF_MESSAGE_ATTRIBUTES WMA
2217: where WNA.NOTIFICATION_ID = nid
2218: and WNA.NAME = aname
2219: and WNA.NOTIFICATION_ID = WN.NOTIFICATION_ID
2220: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 2537: WF_MESSAGE_ATTRIBUTES_TL WMATL, WF_MESSAGE_ATTRIBUTES WMA

2533: begin
2534: select WMATL.DISPLAY_NAME, NVL(WMA.FORMAT, '_blank')
2535: into display_name, target
2536: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
2537: WF_MESSAGE_ATTRIBUTES_TL WMATL, WF_MESSAGE_ATTRIBUTES WMA
2538: where WNA.NOTIFICATION_ID = nid
2539: and WNA.NAME = aname
2540: and WNA.NOTIFICATION_ID = WN.NOTIFICATION_ID
2541: and WN.MESSAGE_NAME = WMATL.MESSAGE_NAME

Line 2712: FROM wf_message_attributes wma,

2708: -- 2. FYI notification with at least one Reassign action
2709: -- Query to check if the ntf is FYI or not
2710: SELECT count(1)
2711: INTO l_resp_cnt
2712: FROM wf_message_attributes wma,
2713: wf_notifications wn
2714: WHERE wn.notification_id = nid
2715: AND wma.message_type = wn.message_type
2716: AND wma.message_name = wn.message_name

Line 3121: WF_MESSAGE_ATTRIBUTES WMA

3117: cursor attrcurs(ruleid in number) is
3118: select WRRA.NAME, WRRA.TEXT_VALUE, WRRA.NUMBER_VALUE, WRRA.DATE_VALUE,
3119: WMA.TYPE
3120: from WF_ROUTING_RULE_ATTRIBUTES WRRA, WF_ROUTING_RULES WRR,
3121: WF_MESSAGE_ATTRIBUTES WMA
3122: where WRRA.RULE_ID = ruleid
3123: and WRRA.RULE_ID = WRR.RULE_ID
3124: and WRR.MESSAGE_TYPE = WMA.MESSAGE_TYPE
3125: and WRR.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 3608: from WF_MESSAGE_ATTRIBUTES

3604:
3605: cursor message_attrs_cursor(msg_type varchar2, msg_name varchar2) is
3606: select NAME, TYPE, SUBTYPE, VALUE_TYPE,
3607: TEXT_DEFAULT, NUMBER_DEFAULT, DATE_DEFAULT
3608: from WF_MESSAGE_ATTRIBUTES
3609: where MESSAGE_TYPE = msg_type
3610: and MESSAGE_NAME = msg_name;
3611: begin
3612: -- Check role is valid and get mail preference

Line 4554: from WF_NOTIFICATIONS WN, WF_MESSAGE_ATTRIBUTES WMA

4550: -- regardless of role notification_preference setting.
4551: begin
4552: select 1 into dummy from sys.dual where exists
4553: (select NULL
4554: from WF_NOTIFICATIONS WN, WF_MESSAGE_ATTRIBUTES WMA
4555: where WN.NOTIFICATION_ID = nid
4556: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME
4557: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
4558: and WMA.SUBTYPE = 'RESPOND');

Line 4760: WF_MESSAGE_ATTRIBUTES WMA,

4756: cursor notification_attrs_cursor(nid number) is
4757: select WNA.NAME, WMA.TYPE, WNA.TEXT_VALUE, WNA.NUMBER_VALUE,
4758: WNA.DATE_VALUE
4759: from WF_NOTIFICATION_ATTRIBUTES WNA,
4760: WF_MESSAGE_ATTRIBUTES WMA,
4761: WF_NOTIFICATIONS WN
4762: where WNA.NOTIFICATION_ID = nid
4763: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
4764: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 5350: WF_MESSAGE_ATTRIBUTES_VL MA,

5346: -- Any existence of response attribute constitutes a response required.
5347: cursor attrs(mnid in number) is
5348: select MA.NAME
5349: from WF_NOTIFICATION_ATTRIBUTES NA,
5350: WF_MESSAGE_ATTRIBUTES_VL MA,
5351: WF_NOTIFICATIONS N
5352: where N.NOTIFICATION_ID = mnid
5353: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
5354: and MA.MESSAGE_NAME = N.MESSAGE_NAME

Line 5463: from WF_MESSAGE_ATTRIBUTES_VL WMA

5459: -- of another.
5460: cursor message_attrs_cursor(c_message_type VARCHAR2,
5461: c_message_name VARCHAR2) is
5462: select WMA.NAME, WMA.DISPLAY_NAME, WMA.TYPE
5463: from WF_MESSAGE_ATTRIBUTES_VL WMA
5464: where WMA.MESSAGE_TYPE = c_message_type
5465: and WMA.MESSAGE_NAME = c_message_name
5466: order by length(WMA.NAME) desc;
5467:

Line 5535: from WF_MESSAGE_ATTRIBUTES_VL WMA

5531: -- of another.
5532: cursor message_attrs_cursor(c_message_type VARCHAR2,
5533: c_message_name VARCHAR2) is
5534: select WMA.NAME, WMA.DISPLAY_NAME, WMA.TYPE
5535: from WF_MESSAGE_ATTRIBUTES_VL WMA
5536: where WMA.MESSAGE_TYPE = c_message_type
5537: and WMA.MESSAGE_NAME = c_message_name
5538: order by length(WMA.NAME) desc;
5539:

Line 5858: WF_MESSAGE_ATTRIBUTES WMA,

5854: -- <7443088> improved query
5855: select NAME into aname from
5856: (select WMA.NAME
5857: from WF_NOTIFICATIONS WN,
5858: WF_MESSAGE_ATTRIBUTES WMA,
5859: WF_NOTIFICATION_ATTRIBUTES NA
5860: where WN.NOTIFICATION_ID = nid
5861: and wn.notification_id = na.notification_id
5862: and wma.name = na.name

Line 6548: from WF_MESSAGE_ATTRIBUTES WMA

6544: and BEGIN_DATE<=begindate
6545: and STATUS = 'OPEN'
6546: and not exists (
6547: select NULL
6548: from WF_MESSAGE_ATTRIBUTES WMA
6549: where WMA.MESSAGE_TYPE = WN.MESSAGE_TYPE
6550: and WMA.MESSAGE_NAME = WN.MESSAGE_NAME
6551: and WMA.SUBTYPE = 'RESPOND');
6552:

Line 8418: WF_MESSAGE_ATTRIBUTES WMA,

8414: -- <7443088> improved query
8415: select NAME into aname from
8416: (select WMA.NAME
8417: from WF_NOTIFICATIONS WN,
8418: WF_MESSAGE_ATTRIBUTES WMA,
8419: WF_NOTIFICATION_ATTRIBUTES NA
8420: where WN.NOTIFICATION_ID = nid
8421: and wn.notification_id = na.notification_id
8422: and wma.name = na.name

Line 8573: WF_MESSAGE_ATTRIBUTES_VL WMA

8569:
8570: cursor cur_hdr_region is
8571: select WNA.NAME, WNA.TEXT_VALUE
8572: from WF_NOTIFICATION_ATTRIBUTES WNA,
8573: WF_MESSAGE_ATTRIBUTES_VL WMA
8574: where WNA.NOTIFICATION_ID = nid
8575: and WMA.NAME = WNA.NAME
8576: and WMA.TYPE = 'DOCUMENT'
8577: and WNA.NAME = '#HDR_REGION';

Line 8718: WF_MESSAGE_ATTRIBUTES_VL WMA

8714: -- Cursur to check for each message Attribute
8715: cursor cur_msg_attrs(nid number, msgToken varchar2) is
8716: select WNA.NAME, WNA.TEXT_VALUE, WMA.TYPE
8717: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
8718: WF_MESSAGE_ATTRIBUTES_VL WMA
8719: where WNA.NOTIFICATION_ID = nid
8720: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
8721: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
8722: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 9474: FROM wf_message_attributes wma,

9470: AND (cp_from_date is null or wn.begin_date >= cp_from_date)
9471: AND (cp_to_date is null or wn.begin_date <= cp_to_date )
9472: AND NOT EXISTS (
9473: SELECT 1
9474: FROM wf_message_attributes wma,
9475: wf_notifications wn2
9476: WHERE wn2.notification_id = wn.notification_id
9477: AND wma.message_type = wn2.message_type
9478: AND wma.message_name = wn2.message_name