1 package WFA_HTML_JSP AUTHID CURRENT_USER as
2 /* $Header: wfjsps.pls 120.6 2006/04/27 23:46:05 hgandiko noship $ */
3
4 /* get notification id given item type, item key, username.
5 ** Created for integration with SSP Orders to Approve
6 **/
7 function getSSPNid (
8 username IN VARCHAR2,
9 itemtype IN VARCHAR2,
10 itemkey IN VARCHAR2
11 )
12 return number;
13 pragma restrict_references(getSSPNid, WNDS, WNPS);
14
15 /* get notification id given item type, item key, username.
16 ** Created for integration with SSP Orders to Approve
17 ** returns open notifications only
18 **/
19 function getSSPOpenNid (
20 username IN VARCHAR2,
21 itemtype IN VARCHAR2,
22 itemkey IN VARCHAR2
23 )
24 return number;
25 pragma restrict_references(getSSPOpenNid, WNDS, WNPS);
26
27 end WFA_HTML_JSP;