1 package IEM_MAILITEM_PUB as
2 /* $Header: iemclnts.pls 120.0 2005/06/02 14:15:57 appldev noship $*/
3 TYPE email_count_rec_type IS RECORD (
4 email_account_id number,
5 rt_classification_id number,
6 rt_classification_name varchar2(30),
7 email_account_name varchar2(100),
8 email_que_count number,
9 email_acq_count number,
10 email_max_qwait number, -- Wait Time in Queue
11 email_max_await number, -- Wait Time in Acquired
12 email_status number); -- 0 for old 1 for New
13
14 TYPE email_count_tbl IS TABLE OF email_count_rec_type
15 INDEX BY BINARY_INTEGER;
16 TYPE class_count_rec_type IS RECORD (
17 rt_classification_id number,
18 rt_classification_name varchar2(30),
19 email_count number);
20
21 TYPE class_count_tbl IS TABLE OF class_count_rec_type
22 INDEX BY BINARY_INTEGER;
23
24 TYPE t_number_table IS TABLE OF NUMBER;
25
26 TYPE acq_email_info_rec_type IS RECORD (
27 message_id number,
28 rt_classification_id number,
29 rt_classification_name varchar2(30),
30 rt_media_item_id number,
31 rt_interaction_id number,
32 email_account_id number,
33 message_flag varchar2(1),
34 sender_name varchar2(128),
35 subject varchar2(240),
36 priority varchar2(30),
37 msg_status varchar2(50),
38 sent_date varchar2(60),
39 -- message_type varchar2(30),
40 mail_item_status varchar2(30),
41 from_agent_id number,
42 read_status varchar2(10),
43 description varchar2(240));
44
45 TYPE acq_email_info_tbl IS TABLE OF acq_email_info_rec_type
46 INDEX BY BINARY_INTEGER;
47
48 TYPE keyVals_rec_type is RECORD (
49 key iem_route_rules.key_type_code%type,
50 value iem_route_rules.value%type,
51 datatype varchar2(1));
52
53 --Table of Key-Values
54 TYPE keyVals_tbl_type is TABLE OF keyVals_rec_type INDEX BY BINARY_INTEGER;
55
56 PROCEDURE GetMailItemCount (p_api_version_number IN NUMBER,
57 p_init_msg_list IN VARCHAR2 ,
58 p_commit IN VARCHAR2 ,
59 p_resource_id in number,
60 p_tbl in t_number_table:=NULL,
61 x_email_count out NOCOPY email_count_tbl,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2);
65 PROCEDURE GetMailItemCount (p_api_version_number IN NUMBER,
66 p_init_msg_list IN VARCHAR2 ,
67 p_commit IN VARCHAR2 ,
68 p_resource_id in number,
69 p_tbl in t_number_table:=NULL,
70 p_email_account_id in number,
71 x_class_bin out NOCOPY class_count_tbl,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2);
75
76 PROCEDURE GetMailItemCount (p_api_version_number IN NUMBER,
77 p_init_msg_list IN VARCHAR2 ,
78 p_commit IN VARCHAR2 ,
79 p_email_account_id in number,
80 x_class_bin out NOCOPY class_count_tbl,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2);
84
85 PROCEDURE GetMailItemCount (p_api_version_number IN NUMBER,
86 p_init_msg_list IN VARCHAR2 ,
87 p_commit IN VARCHAR2 ,
88 p_resource_id in number,
89 p_tbl in t_number_table:=NULL,
90 p_email_account_id in number,
91 p_classification_id in number,
92 x_count OUT NOCOPY NUMBER,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2);
96
97 -- This will return POST MDT Data when called by EMC CLient
98 PROCEDURE GetMailItem (p_api_version_number IN NUMBER,
99 p_init_msg_list IN VARCHAR2 ,
100 p_commit IN VARCHAR2 ,
101 p_resource_id in number,
102 p_tbl in t_number_table:=NULL,
103 p_rt_classification in number,
104 p_account_id in number,
105 x_email_data out NOCOPY iem_rt_proc_emails%rowtype,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2);
109
110 -- This will return the Tag information along with POST MDT Data Called by
111 -- EMC Client
112 PROCEDURE GetMailItem (p_api_version_number IN NUMBER,
113 p_init_msg_list IN VARCHAR2 ,
114 p_commit IN VARCHAR2 ,
115 p_resource_id in number,
116 p_tbl in t_number_table:=NULL,
117 p_rt_classification in number,
118 p_account_id in number,
119 x_email_data out NOCOPY iem_rt_proc_emails%rowtype,
120 x_tag_key_value OUT NOCOPY keyVals_tbl_type,
121 x_encrypted_id OUT NOCOPY VARCHAR2,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2);
125 -- This will return POST MDT Data when called by UWQ
126 PROCEDURE GetMailItem(p_api_version_number IN NUMBER,
127 p_init_msg_list IN VARCHAR2 ,
128 p_commit IN VARCHAR2 ,
129 p_resource_id in number,
130 p_acct_rt_class_id in number,
131 x_email_data out NOCOPY iem_rt_proc_emails%rowtype,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2);
135 PROCEDURE DisposeMailItem (p_api_version_number IN NUMBER,
136 p_init_msg_list IN VARCHAR2 ,
137 p_commit IN VARCHAR2 ,
138 p_message_id in number,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2);
142
143 PROCEDURE ResolvedMessage (p_api_version_number IN NUMBER,
144 p_init_msg_list IN VARCHAR2 ,
145 p_commit IN VARCHAR2 ,
146 p_message_id in number,
147 p_action_flag in varchar2,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2);
151 PROCEDURE getGroupDetails(p_api_version_number IN NUMBER,
152 p_init_msg_list IN VARCHAR2 ,
153 p_commit IN VARCHAR2 ,
154 p_resource_id in number,
155 x_tbl out NOCOPY t_number_table,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2);
159
160 PROCEDURE UpdateMailItem (p_api_version_number IN NUMBER,
161 p_init_msg_list IN VARCHAR2 ,
162 p_commit IN VARCHAR2 ,
163 p_email_data in iem_rt_proc_emails%rowtype,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2);
167 PROCEDURE getMailItemInfo(p_api_version_number IN NUMBER,
168 p_init_msg_list IN VARCHAR2 ,
169 p_commit IN VARCHAR2 ,
170 p_message_id in number,
171 p_account_id in number,
172 p_agent_id in number,
173 x_email_data out NOCOPY iem_rt_proc_emails%rowtype,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2);
177 PROCEDURE getEmailHeaders(p_api_version_number IN NUMBER,
178 p_init_msg_list IN VARCHAR2 ,
179 p_commit IN VARCHAR2 ,
180 p_resource_id in number,
181 p_email_account_id in number,
182 p_display_size in NUMBER,
183 p_page_count in NUMBER,
184 p_sort_by in VARCHAR2,
185 p_sort_order in number,
186 x_total_message OUT NOCOPY NUMBER,
187 x_acq_email_data out NOCOPY acq_email_info_tbl,
188 x_return_status OUT NOCOPY VARCHAR2,
189 x_msg_count OUT NOCOPY NUMBER,
190 x_msg_data OUT NOCOPY VARCHAR2);
191 /* This Api Will Return the meta Data and Tag Data for a message Id */
192 PROCEDURE GetQueueItemData (p_api_version_number IN NUMBER,
193 p_init_msg_list IN VARCHAR2 ,
194 p_commit IN VARCHAR2 ,
195 p_message_id in number,
196 p_from_agent_id in number,
197 p_to_agent_id in number,
198 p_mail_item_status in varchar2,
199 x_email_data out NOCOPY iem_rt_proc_emails%rowtype,
200 x_tag_key_value OUT NOCOPY keyVals_tbl_type,
201 x_encrypted_id OUT NOCOPY VARCHAR2,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2);
205 end IEM_MAILITEM_PUB;