[Home] [Help]
38: htp.tableData(htf.br, cattributes=>'id=""');
39: end if;
40:
41: -- Print URL
42: urlstring:=wf_notification.GetURLText(value, nid);
43:
44: -- Bug 4634849
45: urlstring := wfa_html.encode_url(urlstring);
46: htp.p('
199: buf varchar2(4000);
200: begin
201: select text_value
202: into buf
203: from WF_NOTIFICATION_ATTRIBUTES NA,
204: WF_MESSAGE_ATTRIBUTES_VL MA,
205: WF_NOTIFICATIONS N
206: where N.NOTIFICATION_ID = nid
207: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
201: select text_value
202: into buf
203: from WF_NOTIFICATION_ATTRIBUTES NA,
204: WF_MESSAGE_ATTRIBUTES_VL MA,
205: WF_NOTIFICATIONS N
206: where N.NOTIFICATION_ID = nid
207: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
208: and MA.MESSAGE_NAME = N.MESSAGE_NAME
209: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE
252: value := to_char(nvalue, format);
253: end if;
254: elsif (type = 'DATE') then
255: --
256: value := wf_notification_util.GetCalendarDate( wf_notification_util.getCurrentNID() , dvalue, format);
257: elsif (type = 'LOOKUP') then
258: value := wfa_html_util.GetLookupMeaning(format, tvalue);
259: elsif (type = 'URL') then
260: value := tvalue;
275: end GetDisplayValue;
276:
277: --
278: -- GetDenormalizedValues
279: -- Populate WF_NOTIFICATIONS with the needed values with supplied langcode.
280: -- Then returns those values via the out variables.
281: -- IN:
282: -- nid - notification id
283: -- langcode - language code
292: to_user out nocopy varchar2,
293: subject out nocopy varchar2)
294: is
295: begin
296: Wf_Notification.Denormalize_Notification(nid=>nid,langcode=>langcode);
297:
298: begin
299: select FROM_USER, TO_USER, SUBJECT
300: into from_user, to_user, subject
297:
298: begin
299: select FROM_USER, TO_USER, SUBJECT
300: into from_user, to_user, subject
301: from WF_NOTIFICATIONS
302: where NOTIFICATION_ID = nid;
303: exception
304: when OTHERS then
305: from_user := null;