1 package iem_utility_pvt AUTHID CURRENT_USER as
2 /* $Header: iemutils.pls 115.4 2004/07/15 18:02:20 rtripath shipped $*/
3 TYPE email_account_rec_type IS RECORD (
4 email_account_id number,
5 account_name varchar2(256));
6
7 TYPE email_account_tbl IS TABLE OF email_account_rec_type
8 INDEX BY BINARY_INTEGER;
9 TYPE email_class_rec_type IS RECORD (
10 rt_classification_id number,
11 name varchar2(100));
12
13 TYPE email_class_tbl IS TABLE OF email_class_rec_type
14 INDEX BY BINARY_INTEGER;
15
16 PROCEDURE GetEmailAccountList(p_api_version_number IN NUMBER,
17 p_init_msg_list IN VARCHAR2 ,
18 p_commit IN VARCHAR2 ,
19 x_account_tbl out nocopy email_account_tbl,
20 x_return_status OUT NOCOPY VARCHAR2,
21 x_msg_count OUT NOCOPY NUMBER,
22 x_msg_data OUT NOCOPY VARCHAR2);
23 PROCEDURE GetClassLists(p_api_version_number IN NUMBER,
24 p_init_msg_list IN VARCHAR2 ,
25 p_commit IN VARCHAR2 ,
26 p_email_account_id in number,
27 x_class_tbl out nocopy email_class_tbl,
28 x_return_status OUT NOCOPY VARCHAR2,
29 x_msg_count OUT NOCOPY NUMBER,
30 x_msg_data OUT NOCOPY VARCHAR2);
31 FUNCTION gettimezone(p_date in date,
32 p_resource_id in number) return varchar2;
33 end IEM_UTILITY_PVT;