1 Package irc_communications_swi As
2 /* $Header: ircomswi.pkh 120.0.12010000.2 2008/11/13 18:44:38 amikukum ship $ */
3 -- ----------------------------------------------------------------------------
4 -- |--------------------------< close_communication >-------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: irc_communications_api.close_communication
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE close_communication
27 (p_validate in number default hr_api.g_false_num
28 ,p_effective_date in date
29 ,p_communication_property_id in number
30 ,p_object_type in varchar2
31 ,p_object_id in number
32 ,p_start_date in date
33 ,p_end_date in date
34 ,p_communication_id in number
35 ,p_object_version_number in out nocopy number
36 ,p_return_status out nocopy varchar2
37 );
38 -- ----------------------------------------------------------------------------
39 -- |--------------------------< close_communication >-------------------------|
40 -- ----------------------------------------------------------------------------
41 -- {Start of comments}
42 --
43 -- Description:
44 -- This procedure is the self-service wrapper procedure to the following
45 -- API: irc_communications_api.close_communication
46 --
47 -- Pre-requisites
48 -- All 'IN' parameters to this procedure have been appropriately derived.
49 --
50 -- Post Success:
51 -- p_return_status will return value indicating success.
52 --
53 -- Post Failure:
54 -- p_return_status will return value indication failure.
55 --
56 -- Access Status:
57 -- Internal Development use only.
58 --
59 -- {End of comments}
60 -- ----------------------------------------------------------------------------
61 PROCEDURE update_communication
62 (p_validate in number default hr_api.g_false_num
63 ,p_effective_date in date
64 ,p_communication_property_id in number
65 ,p_object_type in varchar2
66 ,p_object_id in number
67 ,p_status in varchar2
68 ,p_start_date in date
69 ,p_end_date in date
70 ,p_communication_id in number
71 ,p_object_version_number in out nocopy number
72 ,p_return_status out nocopy varchar2
73 );
74 -- ----------------------------------------------------------------------------
75 -- |------------------------< define_comm_properties >------------------------|
76 -- ----------------------------------------------------------------------------
77 -- {Start of comments}
78 --
79 -- Description:
80 -- This procedure is the self-service wrapper procedure to the following
81 -- API: irc_communications_api.define_comm_properties
82 --
83 -- Pre-requisites
84 -- All 'IN' parameters to this procedure have been appropriately derived.
85 --
86 -- Post Success:
87 -- p_return_status will return value indicating success.
88 --
89 -- Post Failure:
90 -- p_return_status will return value indication failure.
91 --
92 -- Access Status:
93 -- Internal Development use only.
94 --
95 -- {End of comments}
96 -- ----------------------------------------------------------------------------
97 PROCEDURE define_comm_properties
98 (p_validate in number default hr_api.g_false_num
99 ,p_effective_date in date
100 ,p_object_type in varchar2
101 ,p_object_id in number
102 ,p_default_comm_status in varchar2
103 ,p_allow_attachment_flag in varchar2
104 ,p_auto_notification_flag in varchar2
105 ,p_allow_add_recipients in varchar2
106 ,p_default_moderator in varchar2
107 ,p_attribute_category in varchar2 default hr_api.g_varchar2
108 ,p_attribute1 in varchar2 default hr_api.g_varchar2
109 ,p_attribute2 in varchar2 default hr_api.g_varchar2
110 ,p_attribute3 in varchar2 default hr_api.g_varchar2
111 ,p_attribute4 in varchar2 default hr_api.g_varchar2
112 ,p_attribute5 in varchar2 default hr_api.g_varchar2
113 ,p_attribute6 in varchar2 default hr_api.g_varchar2
114 ,p_attribute7 in varchar2 default hr_api.g_varchar2
115 ,p_attribute8 in varchar2 default hr_api.g_varchar2
116 ,p_attribute9 in varchar2 default hr_api.g_varchar2
117 ,p_attribute10 in varchar2 default hr_api.g_varchar2
118 ,p_information_category in varchar2 default hr_api.g_varchar2
119 ,p_information1 in varchar2 default hr_api.g_varchar2
120 ,p_information2 in varchar2 default hr_api.g_varchar2
121 ,p_information3 in varchar2 default hr_api.g_varchar2
122 ,p_information4 in varchar2 default hr_api.g_varchar2
123 ,p_information5 in varchar2 default hr_api.g_varchar2
124 ,p_information6 in varchar2 default hr_api.g_varchar2
125 ,p_information7 in varchar2 default hr_api.g_varchar2
126 ,p_information8 in varchar2 default hr_api.g_varchar2
127 ,p_information9 in varchar2 default hr_api.g_varchar2
128 ,p_information10 in varchar2 default hr_api.g_varchar2
129 ,p_communication_property_id in number
130 ,p_object_version_number out nocopy number
131 ,p_return_status out nocopy varchar2
132 );
133 -- ----------------------------------------------------------------------------
134 -- |--------------------------< create_communication >-------------------------|
135 -- ----------------------------------------------------------------------------
136 -- {Start of comments}
137 --
138 -- Description:
139 -- This procedure is the self-service wrapper procedure to the following
140 -- API: irc_communications_api.start_communication
141 --
142 -- Pre-requisites
143 -- All 'IN' parameters to this procedure have been appropriately derived.
144 --
145 -- Post Success:
146 -- p_return_status will return value indicating success.
147 --
148 -- Post Failure:
149 -- p_return_status will return value indication failure.
150 --
151 -- Access Status:
152 -- Internal Development use only.
153 --
154 -- {End of comments}
155 -- ----------------------------------------------------------------------------
156 PROCEDURE create_communication
157 (p_validate in number default hr_api.g_false_num
158 ,p_effective_date in date
159 ,p_communication_property_id in number
160 ,p_object_type in varchar2
161 ,p_object_id in number
162 ,p_status in varchar2
163 ,p_start_date in date
164 ,p_communication_id in number
165 ,p_object_version_number out nocopy number
166 ,p_return_status out nocopy varchar2
167 );
168 -- ----------------------------------------------------------------------------
169 -- |------------------------< update_comm_properties >------------------------|
170 -- ----------------------------------------------------------------------------
171 -- {Start of comments}
172 --
173 -- Description:
174 -- This procedure is the self-service wrapper procedure to the following
175 -- API: irc_communications_api.update_comm_properties
176 --
177 -- Pre-requisites
178 -- All 'IN' parameters to this procedure have been appropriately derived.
179 --
180 -- Post Success:
181 -- p_return_status will return value indicating success.
182 --
183 -- Post Failure:
184 -- p_return_status will return value indication failure.
185 --
186 -- Access Status:
187 -- Internal Development use only.
188 --
189 -- {End of comments}
190 -- ----------------------------------------------------------------------------
191 PROCEDURE update_comm_properties
192 (p_validate in number default hr_api.g_false_num
193 ,p_effective_date in date
194 ,p_object_type in varchar2
195 ,p_object_id in number
196 ,p_default_comm_status in varchar2
197 ,p_allow_attachment_flag in varchar2
198 ,p_auto_notification_flag in varchar2
199 ,p_allow_add_recipients in varchar2
200 ,p_default_moderator in varchar2
201 ,p_attribute_category in varchar2 default hr_api.g_varchar2
202 ,p_attribute1 in varchar2 default hr_api.g_varchar2
203 ,p_attribute2 in varchar2 default hr_api.g_varchar2
204 ,p_attribute3 in varchar2 default hr_api.g_varchar2
205 ,p_attribute4 in varchar2 default hr_api.g_varchar2
206 ,p_attribute5 in varchar2 default hr_api.g_varchar2
207 ,p_attribute6 in varchar2 default hr_api.g_varchar2
208 ,p_attribute7 in varchar2 default hr_api.g_varchar2
209 ,p_attribute8 in varchar2 default hr_api.g_varchar2
210 ,p_attribute9 in varchar2 default hr_api.g_varchar2
211 ,p_attribute10 in varchar2 default hr_api.g_varchar2
212 ,p_information_category in varchar2 default hr_api.g_varchar2
213 ,p_information1 in varchar2 default hr_api.g_varchar2
214 ,p_information2 in varchar2 default hr_api.g_varchar2
215 ,p_information3 in varchar2 default hr_api.g_varchar2
216 ,p_information4 in varchar2 default hr_api.g_varchar2
217 ,p_information5 in varchar2 default hr_api.g_varchar2
218 ,p_information6 in varchar2 default hr_api.g_varchar2
219 ,p_information7 in varchar2 default hr_api.g_varchar2
220 ,p_information8 in varchar2 default hr_api.g_varchar2
221 ,p_information9 in varchar2 default hr_api.g_varchar2
222 ,p_information10 in varchar2 default hr_api.g_varchar2
223 ,p_communication_property_id in number
224 ,p_object_version_number in out nocopy number
225 ,p_return_status out nocopy varchar2
226 );
227 -- ----------------------------------------------------------------------------
228 -- |-----------------------------< delete_comm_properties >-----------------------------|
229 -- ----------------------------------------------------------------------------
230 -- {Start of comments}
231 --
232 -- Description:
233 -- This procedure is the self-service wrapper procedure to the following
234 -- API: irc_communications_api.delete_comm_properties
235 --
236 -- Pre-requisites
237 -- All 'IN' parameters to this procedure have been appropriately derived.
238 --
239 -- Post Success:
240 -- p_return_status will return value indicating success.
241 --
242 -- Post Failure:
243 -- p_return_status will return value indication failure.
244 --
245 -- Access Status:
246 -- Internal Development use only.
247 --
248 -- {End of comments}
249 -- ----------------------------------------------------------------------------
250 PROCEDURE delete_comm_properties
251 (p_validate in number default hr_api.g_false_num
252 ,p_object_version_number in number
253 ,p_communication_property_id in number
254 ,p_effective_date in date default hr_api.g_date
255 ,p_return_status out nocopy varchar2
256 );
257
258 --
259 -- ----------------------------------------------------------------------------
260 -- |----------------------------< create_comm_topic >------------------------------|
261 -- ----------------------------------------------------------------------------
262 --
263 procedure create_comm_topic
264 (p_validate in number default hr_api.g_false_num
265 ,p_effective_date in date
266 ,p_communication_id in number
267 ,p_subject in varchar2
268 ,p_status in varchar2
269 ,p_communication_topic_id in number
270 ,p_object_version_number out nocopy number
271 ,p_return_status out nocopy varchar2
272 );
273 --
274 -- ----------------------------------------------------------------------------
275 -- |----------------------------< CREATE_MESSAGE >-----------------------------|
276 -- ----------------------------------------------------------------------------
277 --
278 procedure create_message
279 (p_validate in number default hr_api.g_false_num
280 ,p_effective_date in date
281 ,p_communication_topic_id in number
282 ,p_parent_id in number default hr_api.g_number
283 ,p_message_subject in varchar2 default hr_api.g_varchar2
284 ,p_message_post_date in date
285 ,p_sender_type in varchar2
286 ,p_sender_id in number
287 ,p_message_body in varchar2 default hr_api.g_varchar2
288 ,p_document_type in varchar2 default hr_api.g_varchar2
289 ,p_document_id in number default hr_api.g_number
290 ,p_deleted_flag in varchar2 default hr_api.g_varchar2
291 ,p_communication_message_id in number
292 ,p_object_version_number out nocopy number
293 ,p_return_status out nocopy varchar2
294 );
295 --
296 -- ----------------------------------------------------------------------------
297 -- |----------------------------< UPDATE_MESSAGE >----------------------------|
298 -- ----------------------------------------------------------------------------
299 --
300 procedure update_message
301 (p_validate in number default hr_api.g_false_num
302 ,p_effective_date in date
303 ,p_deleted_flag in varchar2 default hr_api.g_varchar2
304 ,p_communication_message_id in number
305 ,p_object_version_number in out nocopy number
306 ,p_return_status out nocopy varchar2
307 );
308 --
309 -- ----------------------------------------------------------------------------
310 -- |----------------------------< ADD_RECIPIENT >-----------------------------|
311 -- ----------------------------------------------------------------------------
312 --
313 procedure ADD_RECIPIENT
314 (p_validate in number default hr_api.g_false_num
315 ,p_effective_date in date
316 ,p_communication_object_type in varchar2
317 ,p_communication_object_id in number
318 ,p_recipient_type in varchar2
319 ,p_recipient_id in number
320 ,p_start_date_active in date
321 ,p_end_date_active in date default hr_api.g_date
322 ,p_primary_flag in varchar2 default hr_api.g_varchar2
323 ,p_communication_recipient_id in number
324 ,p_object_version_number out nocopy number
325 ,p_return_status out nocopy varchar2
326 );
327
328 --Save For Later Code Changes
329 -- ----------------------------------------------------------------------------
330 -- |-------------------------< process_com_api >--------------------------|
331 -- ----------------------------------------------------------------------------
332 procedure process_com_api
333 (
334 p_document in CLOB
335 ,p_return_status out nocopy VARCHAR2
336 ,p_validate in number default hr_api.g_false_num
337 ,p_effective_date in date default null
338 );
339 --
340 -- ----------------------------------------------------------------------------
341 -- |--------------------------< start_mass_communication >---------------------|
342 -- ----------------------------------------------------------------------------
343 --
344 PROCEDURE start_mass_communication
345 (
346 p_assignmentIdListGIn in varchar2
347 ,p_return_status out nocopy varchar2
348 );
349 --
350 -- ----------------------------------------------------------------------------
351 -- |--------------------------< close_mass_communication >---------------------|
352 -- ----------------------------------------------------------------------------
353 --
354 PROCEDURE close_mass_communication
355 (
356 p_assignmentIdListGIn in varchar2
357 ,p_return_status out nocopy varchar2
358 );
359 --
360 --
361 end irc_communications_swi;