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 dependencies on WF_NOTIFICATION

Line 381: from WF_NOTIFICATIONS WN

377: -- Get recipient and original recipient of this notification
378: begin
379: select RECIPIENT_ROLE, ORIGINAL_RECIPIENT
380: into recipient, orig_recipient
381: from WF_NOTIFICATIONS WN
382: where WN.NOTIFICATION_ID = nid;
383: exception
384: when no_data_found then
385: Wf_Core.Token('NID', nid);

Line 497: username := Wf_Notification.AccessCheck(wfsession);

493: else
494: wfsession := to_char(nid)||'/'||nkey;
495: end if;
496:
497: username := Wf_Notification.AccessCheck(wfsession);
498: if (username is null) then
499: wf_core.raise('WFNTF_ACCESS_KEY');
500: end if;
501: end if;

Line 613: WF_NOTIFICATIONS N

609: -- Count of multiline response fields
610: select count(1)
611: into urlcnt
612: from WF_MESSAGE_ATTRIBUTES MA,
613: WF_NOTIFICATIONS N
614: where N.NOTIFICATION_ID = nid
615: and MA.MESSAGE_NAME = N.MESSAGE_NAME
616: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE
617: and MA.SUBTYPE = 'RESPOND'

Line 627: from WF_NOTIFICATION_ATTRIBUTES NA,

623:
624: -- Count of all response fields
625: select count(1)
626: into respcnt
627: from WF_NOTIFICATION_ATTRIBUTES NA,
628: WF_MESSAGE_ATTRIBUTES MA,
629: WF_NOTIFICATIONS N
630: where N.NOTIFICATION_ID = nid
631: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID

Line 629: WF_NOTIFICATIONS N

625: select count(1)
626: into respcnt
627: from WF_NOTIFICATION_ATTRIBUTES NA,
628: WF_MESSAGE_ATTRIBUTES MA,
629: WF_NOTIFICATIONS N
630: where N.NOTIFICATION_ID = nid
631: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
632: and MA.MESSAGE_NAME = N.MESSAGE_NAME
633: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE

Line 642: from WF_NOTIFICATION_ATTRIBUTES NA,

638:
639: -- Count of multiline response fields
640: select count(1)
641: into longcnt
642: from WF_NOTIFICATION_ATTRIBUTES NA,
643: WF_MESSAGE_ATTRIBUTES MA,
644: WF_NOTIFICATIONS N
645: where N.NOTIFICATION_ID = nid
646: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID

Line 644: WF_NOTIFICATIONS N

640: select count(1)
641: into longcnt
642: from WF_NOTIFICATION_ATTRIBUTES NA,
643: WF_MESSAGE_ATTRIBUTES MA,
644: WF_NOTIFICATIONS N
645: where N.NOTIFICATION_ID = nid
646: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
647: and MA.MESSAGE_NAME = N.MESSAGE_NAME
648: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE

Line 723: Wf_Notification.GetInfo(nid, username, s0, s0, s0, s0, status);

719: -- Authenticate the user has access
720: username := Wfa_Html.Authenticate(nid, nkey);
721:
722: -- Get notification recipient and status
723: Wf_Notification.GetInfo(nid, username, s0, s0, s0, s0, status);
724: Wf_Directory.GetRoleInfo(username, realname, s0, s0, s0, s0);
725:
726: -- Set title
727: result := htf.htmlOpen ||g_newLine;

Line 838: Wf_Notification.GetInfo(nid, username, s0, s0, s0, s0, status);

834: -- Authenticate the user has access
835: username := Wfa_Html.Authenticate(nid, nkey);
836:
837: -- Get notification recipient and status
838: Wf_Notification.GetInfo(nid, username, s0, s0, s0, s0, status);
839: Wf_Directory.GetRoleInfo(username, realname, s0, s0, s0, s0);
840:
841: -- Set title
842: result := htf.htmlOpen ||g_newLine;

Line 1063: -- Wf_Notification.Forward(nid, upper(l_forwardee), comments, username);

1059: -- Delegating to forwardee with comments
1060: if (fmode = 'DELEGATE') then
1061: if (comments is not null) then
1062: -- ### implement this in next release
1063: -- Wf_Notification.Forward(nid, upper(l_forwardee), comments, username);
1064: Wf_Notification.Forward(nid, upper(l_forwardee), comments);
1065: else
1066: -- ### implement this in next release
1067: -- Wf_Notification.Forward(nid, upper(l_forwardee), '', username);

Line 1064: Wf_Notification.Forward(nid, upper(l_forwardee), comments);

1060: if (fmode = 'DELEGATE') then
1061: if (comments is not null) then
1062: -- ### implement this in next release
1063: -- Wf_Notification.Forward(nid, upper(l_forwardee), comments, username);
1064: Wf_Notification.Forward(nid, upper(l_forwardee), comments);
1065: else
1066: -- ### implement this in next release
1067: -- Wf_Notification.Forward(nid, upper(l_forwardee), '', username);
1068: Wf_Notification.Forward(nid, upper(l_forwardee));

Line 1067: -- Wf_Notification.Forward(nid, upper(l_forwardee), '', username);

1063: -- Wf_Notification.Forward(nid, upper(l_forwardee), comments, username);
1064: Wf_Notification.Forward(nid, upper(l_forwardee), comments);
1065: else
1066: -- ### implement this in next release
1067: -- Wf_Notification.Forward(nid, upper(l_forwardee), '', username);
1068: Wf_Notification.Forward(nid, upper(l_forwardee));
1069: end if;
1070: elsif (fmode = 'TRANSFER') then
1071: -- Transferring to fowardee with comments

Line 1068: Wf_Notification.Forward(nid, upper(l_forwardee));

1064: Wf_Notification.Forward(nid, upper(l_forwardee), comments);
1065: else
1066: -- ### implement this in next release
1067: -- Wf_Notification.Forward(nid, upper(l_forwardee), '', username);
1068: Wf_Notification.Forward(nid, upper(l_forwardee));
1069: end if;
1070: elsif (fmode = 'TRANSFER') then
1071: -- Transferring to fowardee with comments
1072:

Line 1075: -- Wf_Notification.Transfer(nid, upper(l_forwardee), comments, username);

1071: -- Transferring to fowardee with comments
1072:
1073: if (comments is not null) then
1074: -- ### implement this in next release
1075: -- Wf_Notification.Transfer(nid, upper(l_forwardee), comments, username);
1076: Wf_Notification.Transfer(nid, upper(l_forwardee), comments);
1077: else
1078: -- ### implement this in next release
1079: -- Wf_Notification.Transfer(nid, upper(l_forwardee), '', username);

Line 1076: Wf_Notification.Transfer(nid, upper(l_forwardee), comments);

1072:
1073: if (comments is not null) then
1074: -- ### implement this in next release
1075: -- Wf_Notification.Transfer(nid, upper(l_forwardee), comments, username);
1076: Wf_Notification.Transfer(nid, upper(l_forwardee), comments);
1077: else
1078: -- ### implement this in next release
1079: -- Wf_Notification.Transfer(nid, upper(l_forwardee), '', username);
1080: Wf_Notification.Transfer(nid, upper(l_forwardee));

Line 1079: -- Wf_Notification.Transfer(nid, upper(l_forwardee), '', username);

1075: -- Wf_Notification.Transfer(nid, upper(l_forwardee), comments, username);
1076: Wf_Notification.Transfer(nid, upper(l_forwardee), comments);
1077: else
1078: -- ### implement this in next release
1079: -- Wf_Notification.Transfer(nid, upper(l_forwardee), '', username);
1080: Wf_Notification.Transfer(nid, upper(l_forwardee));
1081: end if;
1082: end if;
1083: end loop;

Line 1080: Wf_Notification.Transfer(nid, upper(l_forwardee));

1076: Wf_Notification.Transfer(nid, upper(l_forwardee), comments);
1077: else
1078: -- ### implement this in next release
1079: -- Wf_Notification.Transfer(nid, upper(l_forwardee), '', username);
1080: Wf_Notification.Transfer(nid, upper(l_forwardee));
1081: end if;
1082: end if;
1083: end loop;
1084:

Line 1588: doctext := wf_notification.getattrdoc(nid, aname,wf_notification.doc_html);

1584:
1585: username := upper(username);
1586:
1587: -- note that GetAttrDoc will not translate for PLSQLCLOB
1588: doctext := wf_notification.getattrdoc(nid, aname,wf_notification.doc_html);
1589:
1590: -- if the attribute wasn't translated then try to translate for plsqlclobs.
1591: if doctext = '&'||aname then
1592: dbms_lob.createTemporary(clob_loc, false, dbms_lob.call);

Line 1593: Wf_Notification.GetAttrCLOB(nid, aname, wf_notification.doc_html,

1589:
1590: -- if the attribute wasn't translated then try to translate for plsqlclobs.
1591: if doctext = '&'||aname then
1592: dbms_lob.createTemporary(clob_loc, false, dbms_lob.call);
1593: Wf_Notification.GetAttrCLOB(nid, aname, wf_notification.doc_html,
1594: clob_loc, doctype, attr_name);
1595: if (doctype is not null) then
1596: Wf_Mail_Util.ParseContentType(doctype, l_mime_type, l_filename, l_extension, l_encoding);
1597: end if;

Line 1600: if l_mime_type in (wf_notification.doc_text, wf_notification.doc_html) then

1596: Wf_Mail_Util.ParseContentType(doctype, l_mime_type, l_filename, l_extension, l_encoding);
1597: end if;
1598: -- We have the document. Now determine the output method. HTML documents can be output as
1599: -- they are. Binary documents can only be downloaded
1600: if l_mime_type in (wf_notification.doc_text, wf_notification.doc_html) then
1601: -- HTML or text document.
1602: htp.htmlOpen;
1603: htp.headOpen;
1604: htp.p('');

Line 1614: wf_notification.clob_chunk := 0;

1610: htp.br;
1611:
1612: lobsize := dbms_lob.getlength(clob_loc);
1613: amount := 32000;
1614: wf_notification.clob_chunk := 0;
1615: while not (end_of_text) loop
1616: wf_notification.readattrclob(nid, aname, doctext, end_of_text);
1617: htp.prn(doctext);
1618: end loop;

Line 1616: wf_notification.readattrclob(nid, aname, doctext, end_of_text);

1612: lobsize := dbms_lob.getlength(clob_loc);
1613: amount := 32000;
1614: wf_notification.clob_chunk := 0;
1615: while not (end_of_text) loop
1616: wf_notification.readattrclob(nid, aname, doctext, end_of_text);
1617: htp.prn(doctext);
1618: end loop;
1619: wfa_sec.Footer;
1620: htp.htmlClose;

Line 1649: wf_notification.clob_chunk := 0;

1645: -- stored as raw in varchar.
1646: owa_util.mime_header(l_mime_type, TRUE);
1647: lobsize := dbms_lob.getlength(clob_loc);
1648: amount := 32000;
1649: wf_notification.clob_chunk := 0;
1650: while not (end_of_text) loop
1651: wf_notification.readattrclob(nid, aname, doctext, end_of_text);
1652: htp.p(doctext);
1653: end loop;

Line 1651: wf_notification.readattrclob(nid, aname, doctext, end_of_text);

1647: lobsize := dbms_lob.getlength(clob_loc);
1648: amount := 32000;
1649: wf_notification.clob_chunk := 0;
1650: while not (end_of_text) loop
1651: wf_notification.readattrclob(nid, aname, doctext, end_of_text);
1652: htp.p(doctext);
1653: end loop;
1654: end if;
1655: else

Line 1658: Wf_Notification.GetAttrBLOB(nid, aname, wf_notification.doc_html,

1654: end if;
1655: else
1656: -- attr_name is null try for a PLSQLBLOB document
1657: dbms_lob.createTemporary(blob_loc, false, dbms_lob.call);
1658: Wf_Notification.GetAttrBLOB(nid, aname, wf_notification.doc_html,
1659: blob_loc, doctype, attr_name);
1660: if (doctype is not null) then
1661: Wf_Mail_Util.ParseContentType(doctype, l_mime_type, l_filename, l_extension, l_encoding);
1662: end if;