APPS.WF_NOTIFICATION dependencies on WF_MESSAGE_ATTRIBUTES_VL

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 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 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 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