PACKAGE: APPS.MWA_UTL_SM_PKG

Source

1 PACKAGE MWA_UTL_SM_PKG AUTHID CURRENT_USER as
2 /*$Header: MWASMGRS.pls 120.2 2008/12/04 06:41:18 pbonthu ship $ */
3 
4 TYPE t_user_table IS TABLE OF VARCHAR2(32)
5 	INDEX BY BINARY_INTEGER;
6 
7 Procedure Get_Users
8 (num_of_users		OUT nocopy INTEGER,
9  user_table		OUT nocopy t_user_table,
10  status			OUT nocopy VARCHAR2,
11  status_msg             OUT nocopy VARCHAR2,
12  server_host		IN  VARCHAR2,
13  server_port		IN  VARCHAR2,
14  proxy_host		IN  VARCHAR2,
15  user_name		IN  VARCHAR2,
16  password		IN  VARCHAR2
17 );
18 
19 Procedure Send_Message
20 (status		OUT nocopy VARCHAR2,
21  status_msg     OUT nocopy VARCHAR2,
22  server_host	IN  VARCHAR2,
23  server_port	IN  VARCHAR2,
24  proxy_host	IN  VARCHAR2,
25  user_name	IN  VARCHAR2,
26  password	IN  VARCHAR2,
27  recipient	IN  VARCHAR2,
28  message	IN  VARCHAR2
29 );
30 
31 --Added for bug 7584728 start
32 
33 function test(function_name in varchar2,
34               test_maint_avilability in varchar2 default NULL)
35     return NUMBER;
36 --Added for bug 7584728 end
37 
38 
39 END MWA_UTL_SM_PKG;