1 package por_notification_pkg AUTHID CURRENT_USER as
2 /* $Header: PORNOTFS.pls 115.2 2002/11/19 00:45:41 jjessup ship $ */
3
4 -- NOTE: This package is modified from WFA_HTML_JSP, to support todo list
5 -- displayed in SSP home page. (See bug 1300992)
6 -- It requires username as an input variable. The middle-tier Java bean
7 -- should find out username from the cookie. Security is assumed
8 -- because a user would have a valid connection in order to make
9 -- a JDBC call to the plsql packages in the database.
10
11 -- see bug 1927860
12 -- getTodoNotifications is deprecated and getNotificationSubjects is used
13 -- the logic to get the notifications is moved to java code
14
15 procedure getTodoNotifications(
16 username in varchar2 default null,
17 subject1 out nocopy varchar2,
18 subject2 out nocopy varchar2,
19 subject3 out nocopy varchar2,
20 nid1 out nocopy varchar2,
21 nid2 out nocopy varchar2,
22 nid3 out nocopy varchar2,
23 display_more out nocopy varchar2);
24
25 procedure getNotificationSubjects(
26 nid1 in integer,
27 nid2 in integer,
28 nid3 in integer,
29 subject1 out nocopy varchar2,
30 subject2 out nocopy varchar2,
31 subject3 out nocopy varchar2);
32
33 end por_notification_pkg;
[Home] [Help]