eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WFA_HTML_UTIL dependencies on WF_NOTIFICATION

Line 42: urlstring:=wf_notification.GetURLText(value, nid);

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(' '||urlstring||'');

Line 141: l_username := Wf_Notification.AccessCheck(wfsession);

137: else
138: wfsession := to_char(nid)||'/'||nkey;
139: end if;
140:
141: l_username := Wf_Notification.AccessCheck(wfsession);
142: if (l_username is null) then
143: wf_core.raise('WFNTF_ACCESS_KEY');
144: end if;
145:

Line 416: wf_notification.SetAttrDate(nid, attr_name,

412: length(attr_name_type)-second);
413:
414: if (attr_type = 'DATE') then
415: if (attr_fmt is not null) then
416: wf_notification.SetAttrDate(nid, attr_name,
417: to_date(attr_value, attr_fmt));
418: else
419: wf_notification.SetAttrDate(nid, attr_name,
420: to_date(attr_value,SYS_CONTEXT('USERENV','NLS_DATE_FORMAT')));

Line 419: wf_notification.SetAttrDate(nid, attr_name,

415: if (attr_fmt is not null) then
416: wf_notification.SetAttrDate(nid, attr_name,
417: to_date(attr_value, attr_fmt));
418: else
419: wf_notification.SetAttrDate(nid, attr_name,
420: to_date(attr_value,SYS_CONTEXT('USERENV','NLS_DATE_FORMAT')));
421: end if;
422: elsif (attr_type = 'NUMBER') then
423: if (attr_fmt is not null) then

Line 424: wf_notification.SetAttrNumber(nid, attr_name,

420: to_date(attr_value,SYS_CONTEXT('USERENV','NLS_DATE_FORMAT')));
421: end if;
422: elsif (attr_type = 'NUMBER') then
423: if (attr_fmt is not null) then
424: wf_notification.SetAttrNumber(nid, attr_name,
425: to_number(attr_value, attr_fmt));
426: else
427: wf_notification.SetAttrNumber(nid, attr_name,
428: to_number(attr_value));

Line 427: wf_notification.SetAttrNumber(nid, attr_name,

423: if (attr_fmt is not null) then
424: wf_notification.SetAttrNumber(nid, attr_name,
425: to_number(attr_value, attr_fmt));
426: else
427: wf_notification.SetAttrNumber(nid, attr_name,
428: to_number(attr_value));
429: end if;
430: elsif (attr_type = 'ROLE') then
431:

Line 444: wf_notification.SetAttrText(nid, attr_name, l_attr_value);

440:
441: --
442: -- Set the role to upper
443: --
444: wf_notification.SetAttrText(nid, attr_name, l_attr_value);
445:
446: elsif (attr_type = 'DOCUMENT') then
447: -- if PLSQL then use the display value into which the user typed
448: if upper(substr(doc_name,1, 5)) = 'PLSQL' then

Line 450: wf_notification.SetAttrText(nid, attr_name, doc_name);

446: elsif (attr_type = 'DOCUMENT') then
447: -- if PLSQL then use the display value into which the user typed
448: if upper(substr(doc_name,1, 5)) = 'PLSQL' then
449:
450: wf_notification.SetAttrText(nid, attr_name, doc_name);
451: -- use the hidden field populated by doc lov
452: else
453:
454: wf_notification.SetAttrText(nid, attr_name, attr_value);

Line 454: wf_notification.SetAttrText(nid, attr_name, attr_value);

450: wf_notification.SetAttrText(nid, attr_name, doc_name);
451: -- use the hidden field populated by doc lov
452: else
453:
454: wf_notification.SetAttrText(nid, attr_name, attr_value);
455:
456: end if;
457:
458: else

Line 460: wf_notification.SetAttrText(nid, attr_name, attr_value);

456: end if;
457:
458: else
459: -- VARCHAR2 or LOOKUP or misc value
460: wf_notification.SetAttrText(nid, attr_name, attr_value);
461: end if;
462:
463: exception
464: when others then

Line 518: from WF_NOTIFICATION_ATTRIBUTES NA,

514: buf pls_integer;
515: begin
516: select count(1),max(NA.TEXT_VALUE)
517: into urlcnt, urlstrg
518: from WF_NOTIFICATION_ATTRIBUTES NA,
519: WF_MESSAGE_ATTRIBUTES MA,
520: WF_NOTIFICATIONS N
521: where N.NOTIFICATION_ID = nid
522: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID

Line 520: WF_NOTIFICATIONS N

516: select count(1),max(NA.TEXT_VALUE)
517: into urlcnt, urlstrg
518: from WF_NOTIFICATION_ATTRIBUTES NA,
519: WF_MESSAGE_ATTRIBUTES MA,
520: WF_NOTIFICATIONS N
521: where N.NOTIFICATION_ID = nid
522: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
523: and MA.MESSAGE_NAME = N.MESSAGE_NAME
524: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE

Line 552: from WF_NOTIFICATION_ATTRIBUTES NA,

548: buf varchar2(4000);
549: begin
550: select text_value
551: into buf
552: from WF_NOTIFICATION_ATTRIBUTES NA,
553: WF_MESSAGE_ATTRIBUTES_VL MA,
554: WF_NOTIFICATIONS N
555: where N.NOTIFICATION_ID = nid
556: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID

Line 554: WF_NOTIFICATIONS N

550: select text_value
551: into buf
552: from WF_NOTIFICATION_ATTRIBUTES NA,
553: WF_MESSAGE_ATTRIBUTES_VL MA,
554: WF_NOTIFICATIONS N
555: where N.NOTIFICATION_ID = nid
556: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
557: and MA.MESSAGE_NAME = N.MESSAGE_NAME
558: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE

Line 605: value := wf_notification_util.GetCalendarDate( wf_notification_util.getCurrentNID() , dvalue, format);

601: value := to_char(nvalue, format);
602: end if;
603: elsif (type = 'DATE') then
604: --
605: value := wf_notification_util.GetCalendarDate( wf_notification_util.getCurrentNID() , dvalue, format);
606: elsif (type = 'LOOKUP') then
607: value := wfa_html_util.GetLookupMeaning(format, tvalue);
608: elsif (type = 'URL') then
609: value := tvalue;

Line 628: -- Populate WF_NOTIFICATIONS with the needed values with supplied langcode.

624: end GetDisplayValue;
625:
626: --
627: -- GetDenormalizedValues
628: -- Populate WF_NOTIFICATIONS with the needed values with supplied langcode.
629: -- Then returns those values via the out variables.
630: -- IN:
631: -- nid - notification id
632: -- langcode - language code

Line 645: Wf_Notification.Denormalize_Notification(nid=>nid,langcode=>langcode);

641: to_user out nocopy varchar2,
642: subject out nocopy varchar2)
643: is
644: begin
645: Wf_Notification.Denormalize_Notification(nid=>nid,langcode=>langcode);
646:
647: begin
648: select FROM_USER, TO_USER, SUBJECT
649: into from_user, to_user, subject

Line 650: from WF_NOTIFICATIONS

646:
647: begin
648: select FROM_USER, TO_USER, SUBJECT
649: into from_user, to_user, subject
650: from WF_NOTIFICATIONS
651: where NOTIFICATION_ID = nid;
652: exception
653: when OTHERS then
654: from_user := null;