PACKAGE: APPS.OE_NOTIFY_USER_WF

Source

1 PACKAGE oe_notify_user_wf AUTHID CURRENT_USER as
2 /* $Header: OEXWNTFS.pls 120.1 2011/01/20 11:49:24 kshashan noship $ */
3 
4 TYPE User_Type IS RECORD
5 (user_Id NUMBER, user_name VARCHAR2(1000));
6 
7 TYPE User_List_Type IS TABLE OF User_Type INDEX BY BINARY_INTEGER;
8 
9 G_USER_TAB User_List_Type;
10 
11 PROCEDURE sendNotification  (
12                               itemtype IN VARCHAR2,
13                               itemkey IN VARCHAR2,
14                               actid IN NUMBER,
15                               funcmode IN VARCHAR2,
16                               resultout IN OUT NOCOPY VARCHAR2
17                             );
18 
19 PROCEDURE getUserList (
20                         itemtype IN VARCHAR2,
21                         itemkey IN VARCHAR2,
22                         actid IN NUMBER,
23                         funcmode IN VARCHAR2,
24                         resultout IN OUT NOCOPY VARCHAR2
25                       );
26 
27 PROCEDURE validateContingency (
28                                 itemtype IN VARCHAR2,
29                                 itemkey IN VARCHAR2,
30                                 actid IN NUMBER,
31                                 funcmode IN VARCHAR2,
32                                 resultout IN OUT NOCOPY VARCHAR2
33                               );
34 
35 
36 FUNCTION SetUserPreference(
37                             p_user_id NUMBER,
38                             p_value   VARCHAR2
39                           )
40 RETURN VARCHAR2;
41 
42 END oe_notify_user_wf;