DBA Data[Home] [Help]

APPS.WF_XML dependencies on WF_MESSAGE_ATTRIBUTES_VL

Line 40: WF_MESSAGE_ATTRIBUTES_VL WMA

36:
37: cursor g_urls(p_nid varchar2) is
38: select WMA.TYPE, WMA.DISPLAY_NAME, WNA.TEXT_VALUE, WNA.NAME
39: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
40: WF_MESSAGE_ATTRIBUTES_VL WMA
41: where WNA.NOTIFICATION_ID = p_nid
42: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
43: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
44: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 918: WF_MESSAGE_ATTRIBUTES_VL WMA

914: select WMA.TYPE, WMA.DISPLAY_NAME,
915: decode(WMA.TYPE, 'URL', WF_NOTIFICATION.GetUrlText(WNA.TEXT_VALUE,
916: p_nid), WNA.TEXT_VALUE) URL, WNA.NAME
917: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
918: WF_MESSAGE_ATTRIBUTES_VL WMA
919: where WNA.NOTIFICATION_ID = p_nid
920: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
921: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
922: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 1322: WF_MESSAGE_ATTRIBUTES_VL WMA

1318: 'LOOKUP', WNA.TEXT_VALUE,
1319: WNA.TEXT_VALUE) VALUE
1320: from WF_NOTIFICATION_ATTRIBUTES WNA,
1321: WF_NOTIFICATIONS WN,
1322: WF_MESSAGE_ATTRIBUTES_VL WMA
1323: where WNA.NOTIFICATION_ID = p_nid
1324: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1325: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
1326: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME