DBA Data[Home] [Help]

APPS.WF_XML dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 41: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

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

Line 1034: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

1030: cursor c_attr(p_nid varchar2) is
1031: select WMA.TYPE, WMA.DISPLAY_NAME,
1032: decode(WMA.TYPE, 'URL', WF_NOTIFICATION.GetUrlText(WNA.TEXT_VALUE,
1033: p_nid), WNA.TEXT_VALUE) URL, WNA.NAME
1034: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
1035: WF_MESSAGE_ATTRIBUTES_VL WMA
1036: where WNA.NOTIFICATION_ID = p_nid
1037: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1038: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 1391: from WF_NOTIFICATION_ATTRIBUTES WNA,

1387: '', to_char(WNA.DATE_VALUE),
1388: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1389: 'LOOKUP', WNA.TEXT_VALUE,
1390: WNA.TEXT_VALUE) VALUE
1391: from WF_NOTIFICATION_ATTRIBUTES WNA,
1392: WF_NOTIFICATIONS WN,
1393: WF_MESSAGE_ATTRIBUTES_VL WMA
1394: where WNA.NOTIFICATION_ID = p_nid
1395: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID