1 PACKAGE IEM_OUTBOX_PROC_PUB as
2 /* $Header: iemobprs.pls 120.2 2006/01/24 09:01:57 txliu noship $*/
3
4 TYPE QualifierRecord IS RECORD (
5 QUALIFIER_NAME VARCHAR2(256),
6 QUALIFIER_VALUE VARCHAR2(256)
7 );
8
9 TYPE QualifierRecordList IS
10 TABLE OF QualifierRecord INDEX BY BINARY_INTEGER;
11
12
13 TYPE keyVals_rec_type is RECORD (
14 key iem_route_rules.key_type_code%type,
15 value iem_route_rules.value%type,
16 datatype varchar2(1));
17
18 --Table of Key-Values
19 TYPE keyVals_tbl_type is TABLE OF keyVals_rec_type INDEX BY BINARY_INTEGER;
20
21
22 TYPE AcctRec IS RECORD (
23 ACCOUNT_NAME VARCHAR2(100),
24 ACCOUNT_ID NUMBER);
25
26 TYPE AcctRecList is TABLE OF AcctRec INDEX BY BINARY_INTEGER;
27
28
29 PROCEDURE createOutboxMessage(
30 p_api_version_number IN NUMBER,
31 p_init_msg_list IN VARCHAR2,
32 p_commit IN VARCHAR2,
33 p_resource_id IN NUMBER,
34 p_application_id IN NUMBER,
35 p_responsibility_id IN NUMBER,
36 p_master_account_id IN NUMBER,
37 p_to_address_list IN VARCHAR2,
38 p_cc_address_list IN VARCHAR2,
39 p_bcc_address_list IN VARCHAR2,
40 p_subject IN VARCHAR2,
41 p_sr_id IN NUMBER,
42 p_customer_id IN NUMBER,
43 p_contact_id IN NUMBER,
44 p_interaction_id IN NUMBER,
45 p_qualifiers IN QualifierRecordList,
46 p_message_type IN VARCHAR2,
47 p_encoding IN VARCHAR2,
48 p_character_set IN VARCHAR2,
49 p_option IN VARCHAR2, -- 'A' for auto-ack started from mini R
50 p_relationship_id IN NUMBER,
51 x_outbox_item_id OUT NOCOPY NUMBER,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2
55 );
56
57 PROCEDURE cancelOutboxMessage(
58 p_api_version_number IN NUMBER,
59 p_init_msg_list IN VARCHAR2,
60 p_commit IN VARCHAR2,
61 p_outbox_item_id IN NUMBER,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2
65 );
66
67 PROCEDURE submitOutboxMessage(
68 p_api_version_number IN NUMBER,
69 p_init_msg_list IN VARCHAR2,
70 p_commit IN VARCHAR2,
71 p_outbox_item_id IN NUMBER,
72 p_preview_bool IN VARCHAR2,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2
76 );
77
78 PROCEDURE writeOutboxError(
79 p_api_version_number IN NUMBER,
80 p_init_msg_list IN VARCHAR2,
81 p_commit IN VARCHAR2,
82 p_rt_media_item_id IN NUMBER,
83 p_error_summary IN VARCHAR2,
84 p_error_msg IN VARCHAR2,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2
88 );
89
90
91 PROCEDURE createAutoReply(
92 p_api_version_number IN NUMBER,
93 p_init_msg_list IN VARCHAR2,
94 p_commit IN VARCHAR2,
95 p_media_id IN NUMBER,
96 p_rfc822_message_id IN VARCHAR2,
97 p_folder_name IN VARCHAR2,
98 p_message_uid IN NUMBER,
99 p_master_account_id IN NUMBER,
100 p_to_address_list IN VARCHAR2,
101 p_cc_address_list IN VARCHAR2,
102 p_bcc_address_list IN VARCHAR2,
103 p_subject IN VARCHAR2,
104 p_tag_key_value_tbl IN keyVals_tbl_type,
105 p_customer_id IN NUMBER,
106 p_interaction_id IN NUMBER,
107 p_resource_id IN NUMBER,
108 p_qualifiers IN QualifierRecordList,
109 p_contact_id IN NUMBER,
110 p_relationship_id IN NUMBER,
111 p_mdt_message_id IN NUMBER,
112 x_outbox_item_id OUT NOCOPY NUMBER,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2
116 );
117
118
119 PROCEDURE insertBodyText(
120 p_api_version_number IN NUMBER,
121 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122 p_commit IN VARCHAR2 := FND_API.G_FALSE,
123 p_outbox_item_id IN NUMBER,
124 p_text IN BLOB,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2
128 );
129
130 PROCEDURE insertDocument(
131 p_api_version_number IN NUMBER,
132 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133 p_commit IN VARCHAR2 := FND_API.G_FALSE,
134 p_outbox_item_id IN NUMBER,
135 p_document_source IN VARCHAR2,
136 p_document_id IN NUMBER,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2
140 );
141
142 PROCEDURE attachDocument(
143 p_api_version_number IN NUMBER,
144 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145 p_commit IN VARCHAR2 := FND_API.G_FALSE,
146 p_outbox_item_id IN NUMBER,
147 p_document_source IN VARCHAR2,
148 p_document_id IN NUMBER,
149 p_binary_source IN BLOB,
150 p_attachment_name IN VARCHAR2,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2
154 );
155
156 PROCEDURE getAccountList(
157 p_api_version_number IN NUMBER,
158 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
159 p_commit IN VARCHAR2 := FND_API.G_FALSE,
160 p_resource_id IN NUMBER,
161 x_account_list OUT NOCOPY AcctRecList,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2
165 );
166
167 PROCEDURE redirectMessage(
168 p_api_version_number IN NUMBER,
169 p_init_msg_list IN VARCHAR2,
170 p_commit IN VARCHAR2,
171 p_mdt_msg_id IN NUMBER,
172 p_to_account_id IN NUMBER,
173 p_resource_id IN NUMBER,
174 x_outbox_item_id OUT NOCOPY NUMBER,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2
178 );
179
180
181 PROCEDURE autoForward(
182 p_api_version_number IN NUMBER,
183 p_init_msg_list IN VARCHAR2,
184 p_commit IN VARCHAR2,
185 p_media_id IN NUMBER,
186 p_rfc822_message_id IN VARCHAR2,
187 p_folder_name IN VARCHAR2,
188 p_message_uid IN NUMBER,
189 p_master_account_id IN NUMBER,
190 p_to_address_list IN VARCHAR2,
191 p_cc_address_list IN VARCHAR2,
192 p_bcc_address_list IN VARCHAR2,
193 p_subject IN VARCHAR2,
194 p_tag_key_value_tbl IN keyVals_tbl_type,
195 p_customer_id IN NUMBER,
196 p_interaction_id IN NUMBER,
197 p_resource_id IN NUMBER,
198 p_qualifiers IN QualifierRecordList,
199 p_contact_id IN NUMBER,
200 p_relationship_id IN NUMBER,
201 p_attach_inb IN VARCHAR2, -- if 'A' attach original inbound, if 'I' inbound is inlined
202 p_mdt_message_id IN NUMBER,
203 x_outbox_item_id OUT NOCOPY NUMBER,
204 x_return_status OUT NOCOPY VARCHAR2,
205 x_msg_count OUT NOCOPY NUMBER,
206 x_msg_data OUT NOCOPY VARCHAR2
207 );
208
209 PROCEDURE createSRAutoNotification(
210 p_api_version_number IN NUMBER,
211 p_init_msg_list IN VARCHAR2,
212 p_commit IN VARCHAR2,
213 p_media_id IN NUMBER,
214 p_master_account_id IN NUMBER,
215 p_to_address_list IN VARCHAR2,
216 p_cc_address_list IN VARCHAR2,
217 p_bcc_address_list IN VARCHAR2,
218 p_subject IN VARCHAR2,
219 p_tag_key_value_tbl IN keyVals_tbl_type,
220 p_customer_id IN NUMBER,
221 p_interaction_id IN NUMBER,
222 p_resource_id IN NUMBER,
223 p_qualifiers IN QualifierRecordList,
224 p_contact_id IN NUMBER,
225 p_relationship_id IN NUMBER,
226 p_message_id IN NUMBER,
227 p_sr_id IN NUMBER,
228 x_outbox_item_id OUT NOCOPY NUMBER,
229 x_return_status OUT NOCOPY VARCHAR2,
230 x_msg_count OUT NOCOPY NUMBER,
231 x_msg_data OUT NOCOPY VARCHAR2
232 );
233
234
235 END IEM_OUTBOX_PROC_PUB;