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

Line 1: package body FND_WF_NOTIFICATION as

1: package body FND_WF_NOTIFICATION as
2: /* $Header: afwfntfb.pls 115.3 2003/09/08 15:01:01 ctilley noship $ */
3:
4: -- AddAttr
5: -- Add a new run-time notification attribute.

Line 16: wf_notification.AddAttr(nid,

12: procedure AddAttr(nid in number,
13: aname in varchar2)
14: is
15: begin
16: wf_notification.AddAttr(nid,
17: aname);
18: end AddAttr;
19:
20:

Line 36: wf_notification.SetAttrText(nid,

32: aname in varchar2,
33: avalue in varchar2)
34: is
35: begin
36: wf_notification.SetAttrText(nid,
37: aname,
38: avalue);
39: end SetAttrText;
40:

Line 55: wf_notification.SetAttrNumber(nid,

51: aname in varchar2,
52: avalue in number)
53: is
54: begin
55: wf_notification.SetAttrNumber(nid,
56: aname,
57: avalue);
58: end SetAttrNumber;
59:

Line 74: wf_notification.SetAttrDate(nid,

70: aname in varchar2,
71: avalue in date)
72: is
73: begin
74: wf_notification.SetAttrDate(nid,
75: aname,
76: avalue);
77: end SetAttrDate;
78:

Line 97: wf_notification.GetAttrInfo(nid,

93: subtype out nocopy varchar2,
94: format out nocopy varchar2)
95: is
96: begin
97: wf_notification.GetAttrInfo(nid,
98: aname,
99: atype,
100: subtype,
101: format);

Line 121: lvalue := wf_notification.GetAttrText(nid,

117: aname in varchar2)
118: return varchar2 is
119: lvalue varchar2(4000);
120: begin
121: lvalue := wf_notification.GetAttrText(nid,
122: aname);
123: return lvalue;
124: end GetAttrText;
125:

Line 140: lvalue := wf_notification.GetAttrNumber(nid,

136: aname in varchar2)
137: return number is
138: lvalue number;
139: begin
140: lvalue := wf_notification.GetAttrNumber(nid,
141: aname);
142: return lvalue;
143: end GetAttrNumber;
144:

Line 160: lvalue := wf_notification.GetAttrDate(nid,

156: aname in varchar2)
157: return date is
158: lvalue date;
159: begin
160: lvalue := wf_notification.GetAttrDate(nid,
161: aname);
162: return lvalue;
163: end GetAttrDate;
164:

Line 190: lvalue := wf_notification.GetAttrDoc(nid,

186: disptype in varchar2)
187: return varchar2 is
188: lvalue varchar2(32000);
189: begin
190: lvalue := wf_notification.GetAttrDoc(nid,
191: aname,
192: disptype);
193: return lvalue;
194: end GetAttrDoc;

Line 219: lvalue := wf_notification.GetText(some_text,

215: disptype in varchar2 default '')
216: return varchar2 is
217: lvalue varchar2(32000);
218: begin
219: lvalue := wf_notification.GetText(some_text,
220: nid,
221: disptype);
222: return lvalue;
223: end GetText;

Line 245: lvalue := wf_notification.GetUrlText(some_text,

241: nid in number)
242: return varchar2 is
243: lvalue varchar2(32000);
244: begin
245: lvalue := wf_notification.GetUrlText(some_text,
246: nid);
247: return lvalue;
248: end GetUrlText;
249:

Line 270: lvalue := wf_notification.GetShortText(some_text,

266: nid in number)
267: return varchar2 is
268: lvalue varchar2(32000);
269: begin
270: lvalue := wf_notification.GetShortText(some_text,
271: nid);
272: return lvalue;
273: end GetShortText;
274:

Line 287: -- wf_notifications_view view.

283: -- NOTE:
284: -- If errors are detected this routine returns the subject unsubstituted,
285: -- or null if all else fails, instead of raising exceptions. It must do
286: -- this so the routine can be pragma'd and used in the
287: -- wf_notifications_view view.
288: --
289: function GetSubject(
290: nid in number)
291: return varchar2 is

Line 294: lvalue := wf_notification.GetSubject(nid);

290: nid in number)
291: return varchar2 is
292: lvalue varchar2(240);
293: begin
294: lvalue := wf_notification.GetSubject(nid);
295: return lvalue;
296: end GetSubject;
297:
298: --

Line 320: lvalue := wf_notification.GetBody(nid,

316: disptype in varchar2 default '')
317: return varchar2 is
318: lvalue varchar2(32000);
319: begin
320: lvalue := wf_notification.GetBody(nid,
321: disptype);
322: return lvalue;
323: end GetBody;
324:

Line 340: -- wf_notifications_view view.

336: -- NOTE:
337: -- If errors are detected this routine returns the body unsubstituted,
338: -- or null if all else fails, instead of raising exceptions. It must do
339: -- this so the routine can be pragma'd and used in the
340: -- wf_notifications_view view.
341: --
342: function GetShortBody(nid in number)
343: return varchar2 is
344: lvalue varchar2(32000);

Line 347: lvalue := wf_notification.GetShortBody(nid);

343: return varchar2 is
344: lvalue varchar2(32000);
345: begin
346:
347: lvalue := wf_notification.GetShortBody(nid);
348: return lvalue;
349: end GetShortBody;
350:
351: --

Line 373: wf_notification.GetInfo(nid,

369: due_date out nocopy varchar2,
370: status out nocopy varchar2)
371: is
372: begin
373: wf_notification.GetInfo(nid,
374: role,
375: message_type,
376: message_name,
377: priority,

Line 396: lvalue := wf_notification.Responder(nid);

392: nid in number)
393: return varchar2 is
394: lvalue varchar2(240);
395: begin
396: lvalue := wf_notification.Responder(nid);
397: return lvalue;
398: end Responder;
399:
400:

Line 412: lvalue := wf_notification.AccessCheck(access_str);

408: function AccessCheck(access_str in varchar2)
409: return varchar2 is
410: lvalue varchar2(320);
411: begin
412: lvalue := wf_notification.AccessCheck(access_str);
413: return lvalue;
414: end AccessCheck;
415:
416: --

Line 444: lvalue := wf_notification.Send(role,

440: priority in number default null)
441: return number is
442: lvalue number;
443: begin
444: lvalue := wf_notification.Send(role,
445: msg_type,
446: msg_name,
447: due_date,
448: callback,

Line 482: lvalue := wf_notification.SendGroup(role,

478: priority in number default null)
479: return number is
480: lvalue number;
481: begin
482: lvalue := wf_notification.SendGroup(role,
483: msg_type,
484: msg_name,
485: due_date,
486: callback,

Line 511: wf_notification.Forward(nid,

507: user in varchar2 default null,
508: cnt in number default 0)
509: is
510: begin
511: wf_notification.Forward(nid,
512: new_role,
513: forward_comment,
514: user,
515: cnt);

Line 536: wf_notification.Transfer(nid,

532: user in varchar2 default null,
533: cnt in number default 0)
534: is
535: begin
536: wf_notification.Transfer(nid,
537: new_role,
538: forward_comment,
539: user,
540: cnt);

Line 554: wf_notification.Cancel(nid, cancel_comment);

550: procedure Cancel(nid in number,
551: cancel_comment in varchar2 default null)
552: is
553: begin
554: wf_notification.Cancel(nid, cancel_comment);
555: end Cancel;
556:
557: --
558: -- CancelGroup

Line 568: wf_notification.CancelGroup(gid, cancel_comment);

564: procedure CancelGroup(gid in number,
565: cancel_comment in varchar2 default null)
566: is
567: begin
568: wf_notification.CancelGroup(gid, cancel_comment);
569: end CancelGroup;
570:
571: --
572: -- Respond

Line 584: wf_notification.Respond(nid,

580: respond_comment in varchar2 default null,
581: responder in varchar2 default null)
582: is
583: begin
584: wf_notification.Respond(nid,
585: respond_comment,
586: responder);
587: end Respond;
588:

Line 604: return (wf_notification.TestContext(nid));

600: return boolean
601: is
602: begin
603:
604: return (wf_notification.TestContext(nid));
605:
606: end TestContext;
607:
608: --

Line 627: wf_notification.VoteCount(Gid,

623: PercentOfTotalPop out nocopy number,
624: PercentOfVotes out nocopy number )
625: is
626: begin
627: wf_notification.VoteCount(Gid,
628: ResultCode,
629: ResultCount,
630: PercentOfTotalPop,
631: PercentOfVotes);

Line 648: return (wf_notification.OpenNotificationsExist(Gid));

644: function OpenNotificationsExist( Gid in Number )
645: return Boolean
646: is
647: begin
648: return (wf_notification.OpenNotificationsExist(Gid));
649:
650: end OpenNotificationsExist;
651:
652: --

Line 666: lvalue := wf_notification.WorkCount(username);

662: return number
663: is
664: lvalue number;
665: begin
666: lvalue := wf_notification.WorkCount(username);
667: return lvalue;
668: end WorkCount;
669:
670: --

Line 682: wf_notification.Close(nid,

678: procedure Close(nid in number,
679: responder in varchar2 default null)
680: is
681: begin
682: wf_notification.Close(nid,
683: responder);
684: end Close;
685:
686: -- GetSubSubjectDisplay

Line 700: lvalue := wf_notification.GetSubSubjectDisplay(message_type,

696: is
697: lvalue varchar2(2000);
698: begin
699:
700: lvalue := wf_notification.GetSubSubjectDisplay(message_type,
701: message_name);
702: return lvalue;
703: end GetSubSubjectDisplay;
704:

Line 719: lvalue := wf_notification.GetSubSubjectDisplayShort(message_type,

715: is
716: lvalue varchar2(2000);
717: begin
718:
719: lvalue := wf_notification.GetSubSubjectDisplayShort(message_type,
720: message_name);
721: return lvalue;
722: end GetSubSubjectDisplayShort;
723:

Line 732: -- wf_notification.getfullbody(nid,msgbody,end_of_msgbody);

728: -- and returns the message in 32K chunks in the msgbody out variable.
729: -- Call this repeatedly until end_of_body is true.
730: -- Call syntax is
731: --while not (end_of_msgbody) loop
732: -- wf_notification.getfullbody(nid,msgbody,end_of_msgbody);
733: --end loop;
734: procedure GetFullBody (nid in number,
735: msgbody out nocopy varchar2,
736: end_of_body in out nocopy boolean,

Line 740: wf_notification.GetFullBody(nid,

736: end_of_body in out nocopy boolean,
737: disptype in varchar2 default 'text/plain')
738: is
739: begin
740: wf_notification.GetFullBody(nid,
741: msgbody,
742: end_of_body,
743: disptype);
744: end GetFullBody;

Line 754: -- wf_notification.getfullbody(nid,msgbody,end_of_msgbody);

750: -- instead of boolean like GetFullBody for end_of_msg_body. Created
751: -- since booleans cannot be passed via JDBC.
752: -- Call syntax is
753: --while (end_of_msgbody <> "Y") loop
754: -- wf_notification.getfullbody(nid,msgbody,end_of_msgbody);
755: --end loop;
756: procedure GetFullBodyWrapper (nid in number,
757: msgbody out nocopy varchar2,
758: end_of_body out nocopy varchar2,

Line 762: wf_notification.GetFullBodyWrapper(nid,

758: end_of_body out nocopy varchar2,
759: disptype in varchar2 default 'text/plain')
760: is
761: begin
762: wf_notification.GetFullBodyWrapper(nid,
763: msgbody,
764: end_of_body,
765: disptype);
766: end GetFullBodyWrapper;

Line 770: END FND_WF_NOTIFICATION;

766: end GetFullBodyWrapper;
767:
768:
769:
770: END FND_WF_NOTIFICATION;