DBA Data[Home] [Help]

PACKAGE: APPS.WFA_HTML_JSP

Source


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;