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