[Home] [Help]
PACKAGE: APPS.IRC_COMMUNICATIONS_API
Source
1 Package IRC_COMMUNICATIONS_API AUTHID CURRENT_USER as
2 /* $Header: ircomapi.pkh 120.5 2010/04/07 09:53:21 vmummidi ship $ */
3 --
4 --
5 --
6 --
7 type assoc_arr is table of number index by binary_integer;
8 --
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-------------------------< DEFINE_COMM_PROPERTIES >------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 procedure DEFINE_COMM_PROPERTIES
15 (p_validate in boolean default false
16 ,p_effective_date in date
17 ,p_object_type in varchar2
18 ,p_object_id in number
19 ,p_default_comm_status in varchar2
20 ,p_allow_attachment_flag in varchar2
21 ,p_auto_notification_flag in varchar2
22 ,p_allow_add_recipients in varchar2
23 ,p_default_moderator in varchar2
24 ,p_attribute_category in varchar2 default null
25 ,p_attribute1 in varchar2 default null
26 ,p_attribute2 in varchar2 default null
27 ,p_attribute3 in varchar2 default null
28 ,p_attribute4 in varchar2 default null
29 ,p_attribute5 in varchar2 default null
30 ,p_attribute6 in varchar2 default null
31 ,p_attribute7 in varchar2 default null
32 ,p_attribute8 in varchar2 default null
33 ,p_attribute9 in varchar2 default null
34 ,p_attribute10 in varchar2 default null
35 ,p_information_category in varchar2 default null
36 ,p_information1 in varchar2 default null
37 ,p_information2 in varchar2 default null
38 ,p_information3 in varchar2 default null
39 ,p_information4 in varchar2 default null
40 ,p_information5 in varchar2 default null
41 ,p_information6 in varchar2 default null
42 ,p_information7 in varchar2 default null
43 ,p_information8 in varchar2 default null
44 ,p_information9 in varchar2 default null
45 ,p_information10 in varchar2 default null
46 ,p_communication_property_id out nocopy number
47 ,p_object_version_number out nocopy number
48 );
49 --
50 --
51 -- ----------------------------------------------------------------------------
52 -- |----------------------------< UPDATE_COMM_PROPERTIES >--------------- -----|
53 -- ----------------------------------------------------------------------------
54 --
55 procedure UPDATE_COMM_PROPERTIES
56 (p_validate in boolean default false
57 ,p_effective_date in date
58 ,p_object_type in varchar2
59 ,p_object_id in number
60 ,p_default_comm_status in varchar2
61 ,p_allow_attachment_flag in varchar2
62 ,p_auto_notification_flag in varchar2
63 ,p_allow_add_recipients in varchar2
64 ,p_default_moderator in varchar2
65 ,p_attribute_category in varchar2 default null
66 ,p_attribute1 in varchar2 default null
67 ,p_attribute2 in varchar2 default null
68 ,p_attribute3 in varchar2 default null
69 ,p_attribute4 in varchar2 default null
70 ,p_attribute5 in varchar2 default null
71 ,p_attribute6 in varchar2 default null
72 ,p_attribute7 in varchar2 default null
73 ,p_attribute8 in varchar2 default null
74 ,p_attribute9 in varchar2 default null
75 ,p_attribute10 in varchar2 default null
76 ,p_information_category in varchar2 default null
77 ,p_information1 in varchar2 default null
78 ,p_information2 in varchar2 default null
79 ,p_information3 in varchar2 default null
80 ,p_information4 in varchar2 default null
81 ,p_information5 in varchar2 default null
82 ,p_information6 in varchar2 default null
83 ,p_information7 in varchar2 default null
84 ,p_information8 in varchar2 default null
85 ,p_information9 in varchar2 default null
86 ,p_information10 in varchar2 default null
87 ,p_communication_property_id in number
88 ,p_object_version_number in out nocopy number
89 );
90 --
91 --
92 -- ----------------------------------------------------------------------------
93 -- |----------------------------< CREATE_COMMUNICATION >-----------------------|
94 -- ----------------------------------------------------------------------------
95 --
96 procedure create_communication
97 (p_validate in boolean default false
98 ,p_effective_date in date
99 ,p_communication_property_id in number
100 ,p_object_type in varchar2
101 ,p_object_id in number
102 ,p_status in varchar2
103 ,p_start_date in date
104 ,p_object_version_number out nocopy number
105 ,p_communication_id out nocopy number
106 );
107 --
108 -- ----------------------------------------------------------------------------
109 -- |----------------------------< START_COMMUNICATION >-----------------------|
110 -- ----------------------------------------------------------------------------
111 --
112 procedure start_communication
113 (p_validate in boolean default false
114 ,p_effective_date in date
115 ,p_communication_property_id in number
116 ,p_object_type in varchar2
117 ,p_object_id in number
118 ,p_start_date in date
119 ,p_object_version_number out nocopy number
120 ,p_communication_id out nocopy number
121 );
122 --
123 --
124 --
125 -- ----------------------------------------------------------------------------
126 -- |----------------------------< CLOSE_COMMUNICATION >------------------------|
127 -- ----------------------------------------------------------------------------
128 --
129 procedure close_communication
130 (p_validate in boolean default false
131 ,p_effective_date in date
132 ,p_communication_property_id in number
133 ,p_object_type in varchar2
134 ,p_object_id in number
135 ,p_start_date in date
136 ,p_end_date in date
137 ,p_communication_id in number
138 ,p_object_version_number in out nocopy number
139 );
140 --
141 -- ----------------------------------------------------------------------------
142 -- |----------------------------< UPDATE_COMMUNICATION >----------------------|
143 -- ----------------------------------------------------------------------------
144 --
145 procedure update_communication
146 (p_validate in boolean default false
147 ,p_effective_date in date
148 ,p_communication_property_id in number
149 ,p_object_type in varchar2
150 ,p_object_id in number
151 ,p_status in varchar2
152 ,p_start_date in date
153 ,p_end_date in date
154 ,p_communication_id in number
155 ,p_object_version_number in out nocopy number
156 );
157 --
158 -- ----------------------------------------------------------------------------
159 -- |---------------------------< DELETE_COMM_PROPERTIES >---------------------|
160 -- ----------------------------------------------------------------------------
161 --
162 procedure delete_comm_properties
163 (
164 p_validate in boolean default false
165 , p_object_version_number in number
166 , p_communication_property_id in number
167 , p_effective_date in date default null
168 );
169 --
170 -- ----------------------------------------------------------------------------
171 -- |----------------------------< CREATE_COMM_TOPIC >------------------------------|
172 -- ----------------------------------------------------------------------------
173 --
174 procedure create_comm_topic
175 (p_validate in boolean default false
176 ,p_effective_date in date
177 ,p_communication_id in number
178 ,p_subject in varchar2
179 ,p_status in varchar2
180 ,p_communication_topic_id out nocopy number
181 ,p_object_version_number out nocopy number
182 );
183 --
184 -- ----------------------------------------------------------------------------
185 -- |----------------------------< CREATE_MESSAGE >-----------------------------|
186 -- ----------------------------------------------------------------------------
187 --
188 procedure create_message
189 (p_validate in boolean default false
190 ,p_effective_date in date
191 ,p_communication_topic_id in number
192 ,p_parent_id in number
193 ,p_message_subject in varchar2
194 ,p_message_post_date in date
195 ,p_sender_type in varchar2
196 ,p_sender_id in number
197 ,p_message_body in varchar2
198 ,p_document_type in varchar2
199 ,p_document_id in number
200 ,p_deleted_flag in varchar2
201 ,p_communication_message_id out nocopy number
202 ,p_object_version_number out nocopy number
203 );
204 --
205 -- ----------------------------------------------------------------------------
206 -- |----------------------------< UPDATE_MESSAGE >----------------------------|
207 -- ----------------------------------------------------------------------------
208 --
209 procedure update_message
210 (p_validate in boolean default false
211 ,p_effective_date in date
212 ,p_deleted_flag in varchar2
213 ,p_communication_message_id in number
214 ,p_object_version_number in out nocopy number
215 );
216 --
217 -- ----------------------------------------------------------------------------
218 -- |----------------------------< ADD_RECIPIENT >-----------------------------|
219 -- ----------------------------------------------------------------------------
220 --
221 procedure ADD_RECIPIENT
222 (p_validate in boolean default false
223 ,p_effective_date in date
224 ,p_communication_object_type in varchar2
225 ,p_communication_object_id in number
226 ,p_recipient_type in varchar2
227 ,p_recipient_id in number
228 ,p_start_date_active in date
229 ,p_end_date_active in date
230 ,p_primary_flag in varchar2
231 ,p_communication_recipient_id out nocopy number
232 ,p_object_version_number out nocopy number
233 );
234
235 --
236 -- ----------------------------------------------------------------------------
237 -- |----------------------------< GET_RECIPIENT_LIST >---------------------|
238 -- ----------------------------------------------------------------------------
239 --
240 function get_rcpt_list(p_object_id IN number,filter varchar2 ) return varchar2;
241
242 --
243 -- ----------------------------------------------------------------------------
244 -- |----------------------------< GET_LOOKUP_MEANING >---------------------|
245 -- ----------------------------------------------------------------------------
246 --
247 function get_lookup_meaning (
248 p_lookup_code hr_lookups.lookup_code%TYPE
249 ,p_lookup_type hr_lookups.lookup_type%TYPE)
250 return varchar2;
251 --
252 -- ----------------------------------------------------------------------------
253 -- |----------------------------< COMMUNICATION_EXISTS>------------------------|
254 -- ----------------------------------------------------------------------------
255 --
256 function communication_exists
257 (
258 p_assignmentIdIn in number
259 ,p_communicationIdOut out nocopy number
260 ,p_communicationStatusOut out nocopy varchar2
261 ,p_object_version_numberOut out nocopy number
262 ,p_object_typeOut out nocopy varchar2
263 ,p_start_dateOut out nocopy date
264 ) return boolean;
265 --
266 -- ----------------------------------------------------------------------------
267 -- |----------------------------< START_MASS_COMMUNICATION>--------------------|
268 -- ----------------------------------------------------------------------------
269 --
270 procedure start_mass_communication
271 (
272 p_assignmentIdListIn in varchar2
273 );
274 --
275 -- ----------------------------------------------------------------------------
276 -- |----------------------------< CLOSE_MASS_COMMUNICATION>--------------------|
277 -- ----------------------------------------------------------------------------
278 --
279 procedure close_mass_communication
280 (
281 p_assignmentIdListIn in varchar2
282 );
283 --
284 -- ----------------------------------------------------------------------------
285 -- |----------------------------< HANDLE_ATTACHMENTS_ON_COMMIT>---------------|
286 -- ----------------------------------------------------------------------------
287 --
288 procedure handle_attachments_on_commit
289 (
290 p_message_list in varchar2
291 ,p_dummy_attachment_id number
292 );
293 --
294 -- ----------------------------------------------------------------------------
295 -- |----------------------------< COPY_COMM_TO_APL_ASG>-----------------------|
296 -- ----------------------------------------------------------------------------
297 --
298 procedure copy_comm_to_apl_asg
299 (
300 p_target_asg_id in number
301 ,p_source_asg_id in number
302 );
303 --
304 end IRC_COMMUNICATIONS_API;