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 563: from WF_NOTIFICATIONS WN, WF_ITEM_TYPES_VL WIT, WF_LOOKUPS WL

559: WN.FROM_USER,
560: WN.TO_USER,
561: WN.SUBJECT,
562: WN.LANGUAGE
563: from WF_NOTIFICATIONS WN, WF_ITEM_TYPES_VL WIT, WF_LOOKUPS WL
564: where WN.NOTIFICATION_ID = to_number(nid)
565: and WN.MESSAGE_TYPE = WIT.NAME
566: and WL.LOOKUP_TYPE = 'WF_NOTIFICATION_STATUS'
567: and WN.STATUS = WL.LOOKUP_CODE;

Line 566: and WL.LOOKUP_TYPE = 'WF_NOTIFICATION_STATUS'

562: WN.LANGUAGE
563: from WF_NOTIFICATIONS WN, WF_ITEM_TYPES_VL WIT, WF_LOOKUPS WL
564: where WN.NOTIFICATION_ID = to_number(nid)
565: and WN.MESSAGE_TYPE = WIT.NAME
566: and WL.LOOKUP_TYPE = 'WF_NOTIFICATION_STATUS'
567: and WN.STATUS = WL.LOOKUP_CODE;
568:
569: notrec notcurs%rowtype;
570:

Line 578: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

574: -- of another.
575: cursor notification_attrs_cursor(nid number) is
576: select WNA.NAME, WMA.TYPE, WMA.FORMAT, WMA.DISPLAY_NAME,
577: WNA.TEXT_VALUE
578: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
579: WF_MESSAGE_ATTRIBUTES_VL WMA
580: where WNA.NOTIFICATION_ID = nid
581: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
582: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 595: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

591: -- similar to the above except FORMS do not set ATTACH to Y
592: cursor ntf_forms_attrs_cursor(nid number) is
593: select WNA.NAME, WMA.TYPE, WMA.FORMAT, WMA.DISPLAY_NAME,
594: WNA.TEXT_VALUE
595: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
596: WF_MESSAGE_ATTRIBUTES_VL WMA
597: where WNA.NOTIFICATION_ID = nid
598: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
599: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 684: l_subject := Wf_Notification.GetSubject(to_number(nid));

680: disprole := notrec.to_user;
681: l_subject := wf_core.substitutespecialchars(notrec.subject);
682: else
683: Wf_Directory.GetRoleInfo(notrec.recipient_role, disprole, s0, s0, s0, s0);
684: l_subject := Wf_Notification.GetSubject(to_number(nid));
685: end if;
686: titlerole := disprole;
687:
688: --

Line 829: wf_notification.getfullbody(to_number(nid),msgbody,end_of_text,

825: end_of_text:=FALSE;
826: -- print message body. This may be in sections.
827: htp.p('');
828: while not (end_of_text) loop
829: wf_notification.getfullbody(to_number(nid),msgbody,end_of_text,
830: wf_notification.doc_html);
831: htp.prn(msgbody);
832: end loop;
833: htp.p('');

Line 830: wf_notification.doc_html);

826: -- print message body. This may be in sections.
827: htp.p('');
828: while not (end_of_text) loop
829: wf_notification.getfullbody(to_number(nid),msgbody,end_of_text,
830: wf_notification.doc_html);
831: htp.prn(msgbody);
832: end loop;
833: htp.p('');
834:

Line 892: link_text := wf_notification.geturltext(not_attr_row.text_value, nid);

888: end if;
889:
890: elsif (not_attr_row.type = 'URL') then
891:
892: link_text := wf_notification.geturltext(not_attr_row.text_value, nid);
893: link_text := wf_notification.SetFrameworkAgent(link_text);
894:
895: -- Bug 4634849
896: -- Do not display potentially harmful url

Line 893: link_text := wf_notification.SetFrameworkAgent(link_text);

889:
890: elsif (not_attr_row.type = 'URL') then
891:
892: link_text := wf_notification.geturltext(not_attr_row.text_value, nid);
893: link_text := wf_notification.SetFrameworkAgent(link_text);
894:
895: -- Bug 4634849
896: -- Do not display potentially harmful url
897: begin

Line 938: fname=>Wf_Notification.GetShortText(not_attr_row.text_value, nid),

934: Wfa_Sec.Get_Profile_Value('SOCKET_LISTENER_PORT',username);
935:
936: htp.p('');
937: Wf_Forms.Applet(
938: fname=>Wf_Notification.GetShortText(not_attr_row.text_value, nid),
939: status=>l_status,
940: dispname=>not_attr_row.display_name,
941: port=>nvl(l_forms_port, '0'));
942: htp.p('');

Line 1000: link_text := wf_notification.geturltext(not_attr_row.text_value, nid);

996: end if;
997:
998: elsif (not_attr_row.type = 'URL') then
999:
1000: link_text := wf_notification.geturltext(not_attr_row.text_value, nid);
1001: link_text := wf_notification.SetFrameworkAgent(link_text);
1002:
1003: -- Bug 4634849
1004: -- Do not display potentially harmful url

Line 1001: link_text := wf_notification.SetFrameworkAgent(link_text);

997:
998: elsif (not_attr_row.type = 'URL') then
999:
1000: link_text := wf_notification.geturltext(not_attr_row.text_value, nid);
1001: link_text := wf_notification.SetFrameworkAgent(link_text);
1002:
1003: -- Bug 4634849
1004: -- Do not display potentially harmful url
1005: begin

Line 1102: from WF_NOTIFICATION_ATTRIBUTES NA,

1098: NA.NUMBER_VALUE,
1099: NA.DATE_VALUE,
1100: MA.TYPE,
1101: MA.FORMAT
1102: from WF_NOTIFICATION_ATTRIBUTES NA,
1103: WF_MESSAGE_ATTRIBUTES_VL MA,
1104: WF_NOTIFICATIONS N
1105: where N.NOTIFICATION_ID = to_number(ResponseFrame.nid)
1106: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID

Line 1104: WF_NOTIFICATIONS N

1100: MA.TYPE,
1101: MA.FORMAT
1102: from WF_NOTIFICATION_ATTRIBUTES NA,
1103: WF_MESSAGE_ATTRIBUTES_VL MA,
1104: WF_NOTIFICATIONS N
1105: where N.NOTIFICATION_ID = to_number(ResponseFrame.nid)
1106: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
1107: and MA.MESSAGE_NAME = N.MESSAGE_NAME
1108: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE

Line 1124: from WF_NOTIFICATION_ATTRIBUTES NA,

1120: MA.DESCRIPTION,
1121: -- remove quotes for onmouse over java func
1122: replace(MA.DESCRIPTION,'''') description2,
1123: NA.TEXT_VALUE
1124: from WF_NOTIFICATION_ATTRIBUTES NA,
1125: WF_MESSAGE_ATTRIBUTES_VL MA,
1126: WF_NOTIFICATIONS N
1127: where N.NOTIFICATION_ID = to_number(ResponseFrame.nid)
1128: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID

Line 1126: WF_NOTIFICATIONS N

1122: replace(MA.DESCRIPTION,'''') description2,
1123: NA.TEXT_VALUE
1124: from WF_NOTIFICATION_ATTRIBUTES NA,
1125: WF_MESSAGE_ATTRIBUTES_VL MA,
1126: WF_NOTIFICATIONS N
1127: where N.NOTIFICATION_ID = to_number(ResponseFrame.nid)
1128: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
1129: and MA.MESSAGE_NAME = N.MESSAGE_NAME
1130: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE

Line 1156: Wf_Notification.GetInfo(to_number(nid), recipient, s0, s0, s0, s0, status);

1152:
1153: begin
1154: -- Authenticate user
1155: username := Wfa_Html.Authenticate(to_number(nid), nkey);
1156: Wf_Notification.GetInfo(to_number(nid), recipient, s0, s0, s0, s0, status);
1157: Wf_Directory.GetRoleInfo(recipient, realname, s0, s0, s0, s0);
1158:
1159: -- if nkey is not null, it is from email, and we need to create a pseudo
1160: -- session for it.

Line 1193: -- GoToUrl(wf_notification.GetURLText(urlstring, nid),'_self');

1189: wfa_html_util.GetUrlCount(to_number(nid),urlcount,urlstring);
1190:
1191: -- If there is just one url then replace the response frame with the url
1192: if (urlcount = 1) then
1193: -- GoToUrl(wf_notification.GetURLText(urlstring, nid),'_self');
1194: owa_util.redirect_url(wf_notification.GetURLText(urlstring, nid));
1195: return;
1196: end if;
1197:

Line 1194: owa_util.redirect_url(wf_notification.GetURLText(urlstring, nid));

1190:
1191: -- If there is just one url then replace the response frame with the url
1192: if (urlcount = 1) then
1193: -- GoToUrl(wf_notification.GetURLText(urlstring, nid),'_self');
1194: owa_util.redirect_url(wf_notification.GetURLText(urlstring, nid));
1195: return;
1196: end if;
1197:
1198: -- bug 2167012 JWSMITH moved header_close to after owa_util.redirect

Line 1269: Wf_Forms.Applet(fname=>Wf_Notification.GetShortText(rec.text_value,

1265: l_forms_port :=
1266: Wfa_Sec.Get_Profile_Value('SOCKET_LISTENER_PORT',username);
1267:
1268: htp.p('');
1269: Wf_Forms.Applet(fname=>Wf_Notification.GetShortText(rec.text_value,
1270: to_number(ResponseFrame.nid)),
1271: status=>l_status,
1272: port=>nvl(l_forms_port, '0'));
1273: htp.p('');

Line 1537: hide_button := Wf_Notification.GetAttrText(nid, '#HIDE_REASSIGN');

1533: -- is set to Y.
1534: -- Exception handling is needed in case this attribute is not set.
1535: hide_button := 'N';
1536: begin
1537: hide_button := Wf_Notification.GetAttrText(nid, '#HIDE_REASSIGN');
1538: exception
1539: when OTHERS then
1540: -- Do not want anything on the error stack
1541: Wf_Core.Clear;

Line 1615: Wf_Notification.GetInfo(to_number(nid), recipient, s0, s0, s0, s0, status);

1611:
1612: begin
1613: -- Authenticate user
1614: username := Wfa_Html.Authenticate(to_number(nid), nkey);
1615: Wf_Notification.GetInfo(to_number(nid), recipient, s0, s0, s0, s0, status);
1616: Wf_Directory.GetRoleInfo(recipient, realname, s0, s0, s0, s0);
1617:
1618: -- Get language codeset
1619: lang_codeset := substr(userenv('LANGUAGE'),instr(userenv('LANGUAGE'),'.')+1,

Line 1794: from WF_NOTIFICATION_ATTRIBUTES NA,

1790: MA.DESCRIPTION,
1791: MA.TYPE,
1792: MA.FORMAT
1793: into dispname, description, attrtype, format
1794: from WF_NOTIFICATION_ATTRIBUTES NA,
1795: WF_MESSAGE_ATTRIBUTES_VL MA,
1796: WF_NOTIFICATIONS N
1797: where N.NOTIFICATION_ID = to_number(AttributeInfo.nid)
1798: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID

Line 1796: WF_NOTIFICATIONS N

1792: MA.FORMAT
1793: into dispname, description, attrtype, format
1794: from WF_NOTIFICATION_ATTRIBUTES NA,
1795: WF_MESSAGE_ATTRIBUTES_VL MA,
1796: WF_NOTIFICATIONS N
1797: where N.NOTIFICATION_ID = to_number(AttributeInfo.nid)
1798: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
1799: and MA.MESSAGE_NAME = N.MESSAGE_NAME
1800: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE

Line 1911: WF_NOTIFICATIONS N

1907: -- Count of multiline response fields
1908: select count(1)
1909: into urlcnt
1910: from WF_MESSAGE_ATTRIBUTES MA,
1911: WF_NOTIFICATIONS N
1912: where N.NOTIFICATION_ID = nid
1913: and MA.MESSAGE_NAME = N.MESSAGE_NAME
1914: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE
1915: and MA.SUBTYPE = 'RESPOND'

Line 1925: from WF_NOTIFICATION_ATTRIBUTES NA,

1921:
1922: -- Count of all response fields
1923: select count(1)
1924: into respcnt
1925: from WF_NOTIFICATION_ATTRIBUTES NA,
1926: WF_MESSAGE_ATTRIBUTES MA,
1927: WF_NOTIFICATIONS N
1928: where N.NOTIFICATION_ID = nid
1929: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID

Line 1927: WF_NOTIFICATIONS N

1923: select count(1)
1924: into respcnt
1925: from WF_NOTIFICATION_ATTRIBUTES NA,
1926: WF_MESSAGE_ATTRIBUTES MA,
1927: WF_NOTIFICATIONS N
1928: where N.NOTIFICATION_ID = nid
1929: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
1930: and MA.MESSAGE_NAME = N.MESSAGE_NAME
1931: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE

Line 1940: from WF_NOTIFICATION_ATTRIBUTES NA,

1936:
1937: -- Count of multiline response fields
1938: select count(1)
1939: into longcnt
1940: from WF_NOTIFICATION_ATTRIBUTES NA,
1941: WF_MESSAGE_ATTRIBUTES MA,
1942: WF_NOTIFICATIONS N
1943: where N.NOTIFICATION_ID = nid
1944: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID

Line 1942: WF_NOTIFICATIONS N

1938: select count(1)
1939: into longcnt
1940: from WF_NOTIFICATION_ATTRIBUTES NA,
1941: WF_MESSAGE_ATTRIBUTES MA,
1942: WF_NOTIFICATIONS N
1943: where N.NOTIFICATION_ID = nid
1944: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
1945: and MA.MESSAGE_NAME = N.MESSAGE_NAME
1946: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE

Line 1992: Wf_Notification.GetInfo(to_number(nid), recipient, s0, s0, s0, s0, status);

1988: showforms varchar2(1);
1989: begin
1990:
1991: -- Get status
1992: Wf_Notification.GetInfo(to_number(nid), recipient, s0, s0, s0, s0, status);
1993: username := Wfa_Html.Authenticate(to_number(nid), null);
1994: Wf_Directory.GetRoleInfo(username, realname, s0, s0, s0, s0);
1995:
1996: htp.htmlOpen;

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

2107: -- Authenticate the user has access
2108: username := Wfa_Html.Authenticate(nid, nkey);
2109:
2110: -- Get notification recipient and status
2111: Wf_Notification.GetInfo(nid, username, s0, s0, s0, s0, status);
2112: Wf_Directory.GetRoleInfo(username, realname, s0, s0, s0, s0);
2113:
2114: -- Set title
2115: result := htf.htmlOpen ||g_newLine;

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

2222: -- Authenticate the user has access
2223: username := Wfa_Html.Authenticate(nid, nkey);
2224:
2225: -- Get notification recipient and status
2226: Wf_Notification.GetInfo(nid, username, s0, s0, s0, s0, status);
2227: Wf_Directory.GetRoleInfo(username, realname, s0, s0, s0, s0);
2228:
2229: -- Set title
2230: result := htf.htmlOpen ||g_newLine;

Line 2361: -- wf_notification.Forward(nid, upper(l_forwardee), comments, username);

2357: -- Submit the forward
2358: if (fmode = 'DELEGATE') then
2359: if (comments is not null) then
2360: -- ### implement this in next release
2361: -- wf_notification.Forward(nid, upper(l_forwardee), comments, username);
2362: wf_notification.Forward(nid, upper(l_forwardee), comments);
2363: else
2364: -- ### implement this in next release
2365: -- wf_notification.Forward(nid, upper(l_forwardee), '', username);

Line 2362: wf_notification.Forward(nid, upper(l_forwardee), comments);

2358: if (fmode = 'DELEGATE') then
2359: if (comments is not null) then
2360: -- ### implement this in next release
2361: -- wf_notification.Forward(nid, upper(l_forwardee), comments, username);
2362: wf_notification.Forward(nid, upper(l_forwardee), comments);
2363: else
2364: -- ### implement this in next release
2365: -- wf_notification.Forward(nid, upper(l_forwardee), '', username);
2366: wf_notification.Forward(nid, upper(l_forwardee));

Line 2365: -- wf_notification.Forward(nid, upper(l_forwardee), '', username);

2361: -- wf_notification.Forward(nid, upper(l_forwardee), comments, username);
2362: wf_notification.Forward(nid, upper(l_forwardee), comments);
2363: else
2364: -- ### implement this in next release
2365: -- wf_notification.Forward(nid, upper(l_forwardee), '', username);
2366: wf_notification.Forward(nid, upper(l_forwardee));
2367: end if;
2368: elsif (fmode = 'TRANSFER') then
2369: if (comments is not null) then

Line 2366: wf_notification.Forward(nid, upper(l_forwardee));

2362: wf_notification.Forward(nid, upper(l_forwardee), comments);
2363: else
2364: -- ### implement this in next release
2365: -- wf_notification.Forward(nid, upper(l_forwardee), '', username);
2366: wf_notification.Forward(nid, upper(l_forwardee));
2367: end if;
2368: elsif (fmode = 'TRANSFER') then
2369: if (comments is not null) then
2370: -- ### implement this in next release

Line 2371: -- wf_notification.Transfer(nid,upper(l_forwardee), comments, username);

2367: end if;
2368: elsif (fmode = 'TRANSFER') then
2369: if (comments is not null) then
2370: -- ### implement this in next release
2371: -- wf_notification.Transfer(nid,upper(l_forwardee), comments, username);
2372: wf_notification.Transfer(nid,upper(l_forwardee), comments);
2373: else
2374: -- ### implement this in next release
2375: -- wf_notification.Transfer(nid,upper(l_forwardee), '', username);

Line 2372: wf_notification.Transfer(nid,upper(l_forwardee), comments);

2368: elsif (fmode = 'TRANSFER') then
2369: if (comments is not null) then
2370: -- ### implement this in next release
2371: -- wf_notification.Transfer(nid,upper(l_forwardee), comments, username);
2372: wf_notification.Transfer(nid,upper(l_forwardee), comments);
2373: else
2374: -- ### implement this in next release
2375: -- wf_notification.Transfer(nid,upper(l_forwardee), '', username);
2376: wf_notification.Transfer(nid,upper(l_forwardee));

Line 2375: -- wf_notification.Transfer(nid,upper(l_forwardee), '', username);

2371: -- wf_notification.Transfer(nid,upper(l_forwardee), comments, username);
2372: wf_notification.Transfer(nid,upper(l_forwardee), comments);
2373: else
2374: -- ### implement this in next release
2375: -- wf_notification.Transfer(nid,upper(l_forwardee), '', username);
2376: wf_notification.Transfer(nid,upper(l_forwardee));
2377: end if;
2378: end if;
2379:

Line 2376: wf_notification.Transfer(nid,upper(l_forwardee));

2372: wf_notification.Transfer(nid,upper(l_forwardee), comments);
2373: else
2374: -- ### implement this in next release
2375: -- wf_notification.Transfer(nid,upper(l_forwardee), '', username);
2376: wf_notification.Transfer(nid,upper(l_forwardee));
2377: end if;
2378: end if;
2379:
2380: if (pseudo_login) then

Line 2457: wf_notification.Respond(nid, null, username);

2453: -- otherwise, go back to the worklist
2454: begin
2455: -- Do not need to preserve context
2456: wf_engine.preserved_context := FALSE;
2457: wf_notification.Respond(nid, null, username);
2458:
2459: exception
2460: when others then
2461: -- ### We do not want this now. Since there is real error message

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

2609: -- Delegating to forwardee with comments
2610: if (fmode = 'DELEGATE') then
2611: if (comments is not null) then
2612: -- ### implement this in next release
2613: -- Wf_Notification.Forward(nid, upper(l_forwardee), comments, username);
2614: Wf_Notification.Forward(nid, upper(l_forwardee), comments);
2615: else
2616: -- ### implement this in next release
2617: -- Wf_Notification.Forward(nid, upper(l_forwardee), '', username);

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

2610: if (fmode = 'DELEGATE') then
2611: if (comments is not null) then
2612: -- ### implement this in next release
2613: -- Wf_Notification.Forward(nid, upper(l_forwardee), comments, username);
2614: Wf_Notification.Forward(nid, upper(l_forwardee), comments);
2615: else
2616: -- ### implement this in next release
2617: -- Wf_Notification.Forward(nid, upper(l_forwardee), '', username);
2618: Wf_Notification.Forward(nid, upper(l_forwardee));

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

2613: -- Wf_Notification.Forward(nid, upper(l_forwardee), comments, username);
2614: Wf_Notification.Forward(nid, upper(l_forwardee), comments);
2615: else
2616: -- ### implement this in next release
2617: -- Wf_Notification.Forward(nid, upper(l_forwardee), '', username);
2618: Wf_Notification.Forward(nid, upper(l_forwardee));
2619: end if;
2620: elsif (fmode = 'TRANSFER') then
2621: -- Transferring to fowardee with comments

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

2614: Wf_Notification.Forward(nid, upper(l_forwardee), comments);
2615: else
2616: -- ### implement this in next release
2617: -- Wf_Notification.Forward(nid, upper(l_forwardee), '', username);
2618: Wf_Notification.Forward(nid, upper(l_forwardee));
2619: end if;
2620: elsif (fmode = 'TRANSFER') then
2621: -- Transferring to fowardee with comments
2622:

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

2621: -- Transferring to fowardee with comments
2622:
2623: if (comments is not null) then
2624: -- ### implement this in next release
2625: -- Wf_Notification.Transfer(nid, upper(l_forwardee), comments, username);
2626: Wf_Notification.Transfer(nid, upper(l_forwardee), comments);
2627: else
2628: -- ### implement this in next release
2629: -- Wf_Notification.Transfer(nid, upper(l_forwardee), '', username);

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

2622:
2623: if (comments is not null) then
2624: -- ### implement this in next release
2625: -- Wf_Notification.Transfer(nid, upper(l_forwardee), comments, username);
2626: Wf_Notification.Transfer(nid, upper(l_forwardee), comments);
2627: else
2628: -- ### implement this in next release
2629: -- Wf_Notification.Transfer(nid, upper(l_forwardee), '', username);
2630: Wf_Notification.Transfer(nid, upper(l_forwardee));

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

2625: -- Wf_Notification.Transfer(nid, upper(l_forwardee), comments, username);
2626: Wf_Notification.Transfer(nid, upper(l_forwardee), comments);
2627: else
2628: -- ### implement this in next release
2629: -- Wf_Notification.Transfer(nid, upper(l_forwardee), '', username);
2630: Wf_Notification.Transfer(nid, upper(l_forwardee));
2631: end if;
2632: end if;
2633: end loop;

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

2626: Wf_Notification.Transfer(nid, upper(l_forwardee), comments);
2627: else
2628: -- ### implement this in next release
2629: -- Wf_Notification.Transfer(nid, upper(l_forwardee), '', username);
2630: Wf_Notification.Transfer(nid, upper(l_forwardee));
2631: end if;
2632: end if;
2633: end loop;
2634:

Line 3358: wrklstbuf := ' ('|| to_char(wf_notification.WorkCount(username)) ||

3354: htp.fontOpen(cface=>'ARIAL,HELVETICA',csize=>'-1');
3355: end if;
3356:
3357: if origin = 'NORMAL' then
3358: wrklstbuf := ' ('|| to_char(wf_notification.WorkCount(username)) ||
3359: ' ' || wf_core.translate('OPEN_NOTIFICATIONS') || ')';
3360: htp.tableopen(calign=>'LEFT', cattributes=>'WIDTH=80% summary=""');
3361: else
3362: -- dont print the "n open notifications" message next to Worklist

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

3710:
3711: username := upper(username);
3712:
3713: -- note that GetAttrDoc will not translate for PLSQLCLOB
3714: doctext := wf_notification.getattrdoc(nid, aname,wf_notification.doc_html);
3715:
3716: -- if the attribute wasn't translated then try to translate for plsqlclobs.
3717: if doctext = '&'||aname then
3718: dbms_lob.createTemporary(clob_loc, false, dbms_lob.call);

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

3715:
3716: -- if the attribute wasn't translated then try to translate for plsqlclobs.
3717: if doctext = '&'||aname then
3718: dbms_lob.createTemporary(clob_loc, false, dbms_lob.call);
3719: Wf_Notification.GetAttrCLOB(nid, aname, wf_notification.doc_html,
3720: clob_loc, doctype, attr_name);
3721: if (doctype is not null) then
3722: Wf_Mail_Util.ParseContentType(doctype, l_mime_type, l_filename, l_extension, l_encoding);
3723: end if;

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

3722: Wf_Mail_Util.ParseContentType(doctype, l_mime_type, l_filename, l_extension, l_encoding);
3723: end if;
3724: -- We have the document. Now determine the output method. HTML documents can be output as
3725: -- they are. Binary documents can only be downloaded
3726: if l_mime_type in (wf_notification.doc_text, wf_notification.doc_html) then
3727: -- HTML or text document.
3728: htp.htmlOpen;
3729: htp.headOpen;
3730: htp.p('');

Line 3740: wf_notification.clob_chunk := 0;

3736: htp.br;
3737:
3738: lobsize := dbms_lob.getlength(clob_loc);
3739: amount := 32000;
3740: wf_notification.clob_chunk := 0;
3741: while not (end_of_text) loop
3742: wf_notification.readattrclob(nid, aname, doctext, end_of_text);
3743: htp.prn(doctext);
3744: end loop;

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

3738: lobsize := dbms_lob.getlength(clob_loc);
3739: amount := 32000;
3740: wf_notification.clob_chunk := 0;
3741: while not (end_of_text) loop
3742: wf_notification.readattrclob(nid, aname, doctext, end_of_text);
3743: htp.prn(doctext);
3744: end loop;
3745: wfa_sec.Footer;
3746: htp.htmlClose;

Line 3775: wf_notification.clob_chunk := 0;

3771: -- stored as raw in varchar.
3772: owa_util.mime_header(l_mime_type, TRUE);
3773: lobsize := dbms_lob.getlength(clob_loc);
3774: amount := 32000;
3775: wf_notification.clob_chunk := 0;
3776: while not (end_of_text) loop
3777: wf_notification.readattrclob(nid, aname, doctext, end_of_text);
3778: htp.p(doctext);
3779: end loop;

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

3773: lobsize := dbms_lob.getlength(clob_loc);
3774: amount := 32000;
3775: wf_notification.clob_chunk := 0;
3776: while not (end_of_text) loop
3777: wf_notification.readattrclob(nid, aname, doctext, end_of_text);
3778: htp.p(doctext);
3779: end loop;
3780: end if;
3781: else

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

3780: end if;
3781: else
3782: -- attr_name is null try for a PLSQLBLOB document
3783: dbms_lob.createTemporary(blob_loc, false, dbms_lob.call);
3784: Wf_Notification.GetAttrBLOB(nid, aname, wf_notification.doc_html,
3785: blob_loc, doctype, attr_name);
3786: if (doctype is not null) then
3787: Wf_Mail_Util.ParseContentType(doctype, l_mime_type, l_filename, l_extension, l_encoding);
3788: end if;