[Home] [Help]
Skip to content
PACKAGE BODY: APPS.IRC_RECRUITING_SITES_SWI
Source
1 Package Body irc_recruiting_sites_swi As
2 /* $Header: irrseswi.pkb 120.0.12010000.3 2010/01/18 14:30:52 mkjayara ship $ */
3 --
4 -- Package variables
5 --
6 g_package varchar2(33) := 'irc_recruiting_sites_swi.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_recruiting_site >------------------------|
10 -- ----------------------------------------------------------------------------
11 PROCEDURE create_recruiting_site
12 (p_validate in number default hr_api.g_false_num
13 ,p_effective_date in date
14 ,p_site_name in varchar2
15 ,p_date_from in date default null
16 ,p_date_to in date default null
17 ,p_posting_username in varchar2 default null
18 ,p_posting_password in varchar2 default null
19 ,p_internal in varchar2 default 'N'
20 ,p_external in varchar2 default 'N'
21 ,p_third_party in varchar2 default 'Y'
22 ,p_redirection_url in varchar2 default null
23 ,p_posting_url in varchar2 default null
24 ,p_posting_cost in number default null
25 ,p_posting_cost_period in varchar2 default null
26 ,p_posting_cost_currency in varchar2 default null
27 ,p_stylesheet in varchar2 default null
28 ,p_attribute_category in varchar2 default null
29 ,p_attribute1 in varchar2 default null
30 ,p_attribute2 in varchar2 default null
31 ,p_attribute3 in varchar2 default null
32 ,p_attribute4 in varchar2 default null
33 ,p_attribute5 in varchar2 default null
34 ,p_attribute6 in varchar2 default null
35 ,p_attribute7 in varchar2 default null
36 ,p_attribute8 in varchar2 default null
37 ,p_attribute9 in varchar2 default null
38 ,p_attribute10 in varchar2 default null
39 ,p_attribute11 in varchar2 default null
40 ,p_attribute12 in varchar2 default null
41 ,p_attribute13 in varchar2 default null
42 ,p_attribute14 in varchar2 default null
43 ,p_attribute15 in varchar2 default null
44 ,p_attribute16 in varchar2 default null
45 ,p_attribute17 in varchar2 default null
46 ,p_attribute18 in varchar2 default null
47 ,p_attribute19 in varchar2 default null
48 ,p_attribute20 in varchar2 default null
49 ,p_attribute21 in varchar2 default null
50 ,p_attribute22 in varchar2 default null
51 ,p_attribute23 in varchar2 default null
52 ,p_attribute24 in varchar2 default null
53 ,p_attribute25 in varchar2 default null
54 ,p_attribute26 in varchar2 default null
55 ,p_attribute27 in varchar2 default null
56 ,p_attribute28 in varchar2 default null
57 ,p_attribute29 in varchar2 default null
58 ,p_attribute30 in varchar2 default null
59 ,p_recruiting_site_id in number
60 ,p_object_version_number out nocopy number
61 ,p_return_status out nocopy varchar2
62 ,p_posting_impl_class in varchar2 default null
63 ) is
64 --
65 -- Variables for API Boolean parameters
66 l_validate boolean;
67 --
68 -- Variables for IN/OUT parameters
69 --
70 -- Other variables
71 l_recruiting_site_id number;
72 l_proc varchar2(72) := g_package ||'create_recruiting_site';
73 Begin
74 hr_utility.set_location(' Entering:' || l_proc,10);
75 --
76 -- Issue a savepoint
77 --
78 savepoint create_recruiting_site_swi;
79 --
80 -- Initialise Multiple Message Detection
81 --
82 hr_multi_message.enable_message_list;
83 --
84 -- Remember IN OUT parameter IN values
85 --
86 --
87 -- Convert constant values to their corresponding boolean value
88 --
89 l_validate :=
90 hr_api.constant_to_boolean
91 (p_constant_value => p_validate);
92 --
93 -- Register Surrogate ID or user key values
94 --
95 irc_rse_ins.set_base_key_value
96 (p_recruiting_site_id => p_recruiting_site_id
97 );
98 --
99 -- Call API
100 --
101 irc_recruiting_sites_api.create_recruiting_site
102 (p_validate => l_validate
103 ,p_effective_date => p_effective_date
104 ,p_site_name => p_site_name
105 ,p_date_from => p_date_from
106 ,p_date_to => p_date_to
107 ,p_posting_username => p_posting_username
108 ,p_posting_password => p_posting_password
109 ,p_internal => p_internal
110 ,p_external => p_external
111 ,p_third_party => p_third_party
112 ,p_redirection_url => p_redirection_url
113 ,p_posting_url => p_posting_url
114 ,p_posting_cost => p_posting_cost
115 ,p_posting_cost_period => p_posting_cost_period
116 ,p_posting_cost_currency => p_posting_cost_currency
117 ,p_stylesheet => p_stylesheet
118 ,p_attribute_category => p_attribute_category
119 ,p_attribute1 => p_attribute1
120 ,p_attribute2 => p_attribute2
121 ,p_attribute3 => p_attribute3
122 ,p_attribute4 => p_attribute4
123 ,p_attribute5 => p_attribute5
124 ,p_attribute6 => p_attribute6
125 ,p_attribute7 => p_attribute7
126 ,p_attribute8 => p_attribute8
127 ,p_attribute9 => p_attribute9
128 ,p_attribute10 => p_attribute10
129 ,p_attribute11 => p_attribute11
130 ,p_attribute12 => p_attribute12
131 ,p_attribute13 => p_attribute13
132 ,p_attribute14 => p_attribute14
133 ,p_attribute15 => p_attribute15
134 ,p_attribute16 => p_attribute16
135 ,p_attribute17 => p_attribute17
136 ,p_attribute18 => p_attribute18
137 ,p_attribute19 => p_attribute19
138 ,p_attribute20 => p_attribute20
139 ,p_attribute21 => p_attribute21
140 ,p_attribute22 => p_attribute22
141 ,p_attribute23 => p_attribute23
142 ,p_attribute24 => p_attribute24
143 ,p_attribute25 => p_attribute25
144 ,p_attribute26 => p_attribute26
145 ,p_attribute27 => p_attribute27
146 ,p_attribute28 => p_attribute28
147 ,p_attribute29 => p_attribute29
148 ,p_attribute30 => p_attribute30
149 ,p_recruiting_site_id => l_recruiting_site_id
150 ,p_object_version_number => p_object_version_number
151 ,p_posting_impl_class => p_posting_impl_class
152 );
153 --
154 -- Convert API warning boolean parameter values to specific
155 -- messages and add them to Multiple Message List
156 --
157 --
158 -- Convert API non-warning boolean parameter values
159 --
160 --
161 -- Derive the API return status value based on whether
162 -- messages of any type exist in the Multiple Message List.
163 -- Also disable Multiple Message Detection.
164 --
165 p_return_status := hr_multi_message.get_return_status_disable;
166 hr_utility.set_location(' Leaving:' || l_proc,20);
167 --
168 exception
169 when hr_multi_message.error_message_exist then
170 --
171 -- Catch the Multiple Message List exception which
172 -- indicates API processing has been aborted because
173 -- at least one message exists in the list.
174 --
175 rollback to create_recruiting_site_swi;
176 --
177 -- Reset IN OUT parameters and set OUT parameters
178 --
179 p_object_version_number := null;
180 p_return_status := hr_multi_message.get_return_status_disable;
181 hr_utility.set_location(' Leaving:' || l_proc, 30);
182 when others then
183 --
184 -- When Multiple Message Detection is enabled catch
185 -- any Application specific or other unexpected
186 -- exceptions. Adding appropriate details to the
187 -- Multiple Message List. Otherwise re-raise the
188 -- error.
189 --
190 rollback to create_recruiting_site_swi;
191 if hr_multi_message.unexpected_error_add(l_proc) then
192 hr_utility.set_location(' Leaving:' || l_proc,40);
193 raise;
194 end if;
195 --
196 -- Reset IN OUT and set OUT parameters
197 --
198 p_object_version_number := null;
199 p_return_status := hr_multi_message.get_return_status_disable;
200 hr_utility.set_location(' Leaving:' || l_proc,50);
201 end create_recruiting_site;
202 -- ----------------------------------------------------------------------------
203 -- |------------------------< delete_recruiting_site >------------------------|
204 -- ----------------------------------------------------------------------------
205 PROCEDURE delete_recruiting_site
206 (p_validate in number default hr_api.g_false_num
207 ,p_recruiting_site_id in number
208 ,p_object_version_number in number
209 ,p_return_status out nocopy varchar2
210 ) is
211 --
212 -- Variables for API Boolean parameters
213 l_validate boolean;
214 --
215 -- Variables for IN/OUT parameters
216 --
217 -- Other variables
218 l_proc varchar2(72) := g_package ||'delete_recruiting_site';
219 l_object_version_number irc_all_recruiting_sites.object_version_number%TYPE;
220
221 cursor get_object_version_number(p_recruiting_site_id irc_all_recruiting_sites.recruiting_site_id%TYPE) is
222 select object_version_number
223 from irc_all_recruiting_sites
224 where recruiting_site_id = p_recruiting_site_id;
225 Begin
226 hr_utility.set_location(' Entering:' || l_proc,10);
227 --
228 -- Issue a savepoint
229 --
230 savepoint delete_recruiting_site_swi;
231 --
232 -- Initialise Multiple Message Detection
233 --
234 hr_multi_message.enable_message_list;
235 --
236 -- Remember IN OUT parameter IN values
237 --
238 --
239 -- Convert constant values to their corresponding boolean value
240 --
241 l_validate :=
242 hr_api.constant_to_boolean
243 (p_constant_value => p_validate);
244 --
245 -- Register Surrogate ID or user key values
246 --
247 --
248 -- Call API
249 --
250 l_object_version_number := p_object_version_number;
251 if(p_object_version_number is null or p_object_version_number < 0) then
252 open get_object_version_number(p_recruiting_site_id);
253 fetch get_object_version_number into l_object_version_number;
254 close get_object_version_number;
255 end if;
256 --
257 irc_recruiting_sites_api.delete_recruiting_site
258 (p_validate => l_validate
259 ,p_recruiting_site_id => p_recruiting_site_id
260 ,p_object_version_number => l_object_version_number
261 );
262 --
263 -- Convert API warning boolean parameter values to specific
264 -- messages and add them to Multiple Message List
265 --
266 --
267 -- Convert API non-warning boolean parameter values
268 --
269 --
270 -- Derive the API return status value based on whether
271 -- messages of any type exist in the Multiple Message List.
272 -- Also disable Multiple Message Detection.
273 --
274 p_return_status := hr_multi_message.get_return_status_disable;
275 hr_utility.set_location(' Leaving:' || l_proc,20);
276 --
277 exception
278 when hr_multi_message.error_message_exist then
279 --
280 -- Catch the Multiple Message List exception which
281 -- indicates API processing has been aborted because
282 -- at least one message exists in the list.
283 --
284 rollback to delete_recruiting_site_swi;
285 --
286 -- Reset IN OUT parameters and set OUT parameters
287 --
288 p_return_status := hr_multi_message.get_return_status_disable;
289 hr_utility.set_location(' Leaving:' || l_proc, 30);
290 when others then
291 --
292 -- When Multiple Message Detection is enabled catch
293 -- any Application specific or other unexpected
294 -- exceptions. Adding appropriate details to the
295 -- Multiple Message List. Otherwise re-raise the
296 -- error.
297 --
298 rollback to delete_recruiting_site_swi;
299 if hr_multi_message.unexpected_error_add(l_proc) then
300 hr_utility.set_location(' Leaving:' || l_proc,40);
301 raise;
302 end if;
303 --
304 -- Reset IN OUT and set OUT parameters
305 --
306 p_return_status := hr_multi_message.get_return_status_disable;
307 hr_utility.set_location(' Leaving:' || l_proc,50);
308 end delete_recruiting_site;
309 -- ----------------------------------------------------------------------------
310 -- |------------------------< update_recruiting_site >------------------------|
311 -- ----------------------------------------------------------------------------
312 PROCEDURE update_recruiting_site
313 (p_recruiting_site_id in number
314 ,p_validate in number default hr_api.g_false_num
315 ,p_effective_date in date
316 ,p_site_name in varchar2 default hr_api.g_varchar2
317 ,p_date_from in date default hr_api.g_date
318 ,p_date_to in date default hr_api.g_date
319 ,p_posting_username in varchar2 default hr_api.g_varchar2
320 ,p_posting_password in varchar2 default hr_api.g_varchar2
321 ,p_internal in varchar2 default hr_api.g_varchar2
322 ,p_external in varchar2 default hr_api.g_varchar2
323 ,p_third_party in varchar2 default hr_api.g_varchar2
324 ,p_redirection_url in varchar2 default hr_api.g_varchar2
325 ,p_posting_url in varchar2 default hr_api.g_varchar2
326 ,p_posting_cost in number default hr_api.g_number
327 ,p_posting_cost_period in varchar2 default hr_api.g_varchar2
328 ,p_posting_cost_currency in varchar2 default hr_api.g_varchar2
329 ,p_stylesheet in varchar2 default hr_api.g_varchar2
330 ,p_attribute_category in varchar2 default hr_api.g_varchar2
331 ,p_attribute1 in varchar2 default hr_api.g_varchar2
332 ,p_attribute2 in varchar2 default hr_api.g_varchar2
333 ,p_attribute3 in varchar2 default hr_api.g_varchar2
334 ,p_attribute4 in varchar2 default hr_api.g_varchar2
335 ,p_attribute5 in varchar2 default hr_api.g_varchar2
336 ,p_attribute6 in varchar2 default hr_api.g_varchar2
337 ,p_attribute7 in varchar2 default hr_api.g_varchar2
338 ,p_attribute8 in varchar2 default hr_api.g_varchar2
339 ,p_attribute9 in varchar2 default hr_api.g_varchar2
340 ,p_attribute10 in varchar2 default hr_api.g_varchar2
341 ,p_attribute11 in varchar2 default hr_api.g_varchar2
342 ,p_attribute12 in varchar2 default hr_api.g_varchar2
343 ,p_attribute13 in varchar2 default hr_api.g_varchar2
344 ,p_attribute14 in varchar2 default hr_api.g_varchar2
345 ,p_attribute15 in varchar2 default hr_api.g_varchar2
346 ,p_attribute16 in varchar2 default hr_api.g_varchar2
347 ,p_attribute17 in varchar2 default hr_api.g_varchar2
348 ,p_attribute18 in varchar2 default hr_api.g_varchar2
349 ,p_attribute19 in varchar2 default hr_api.g_varchar2
350 ,p_attribute20 in varchar2 default hr_api.g_varchar2
351 ,p_attribute21 in varchar2 default hr_api.g_varchar2
352 ,p_attribute22 in varchar2 default hr_api.g_varchar2
353 ,p_attribute23 in varchar2 default hr_api.g_varchar2
354 ,p_attribute24 in varchar2 default hr_api.g_varchar2
355 ,p_attribute25 in varchar2 default hr_api.g_varchar2
356 ,p_attribute26 in varchar2 default hr_api.g_varchar2
357 ,p_attribute27 in varchar2 default hr_api.g_varchar2
358 ,p_attribute28 in varchar2 default hr_api.g_varchar2
359 ,p_attribute29 in varchar2 default hr_api.g_varchar2
360 ,p_attribute30 in varchar2 default hr_api.g_varchar2
361 ,p_object_version_number in out nocopy number
362 ,p_return_status out nocopy varchar2
363 ,p_posting_impl_class in varchar2 default hr_api.g_varchar2
364 ) is
365 --
366 -- Variables for API Boolean parameters
367 l_validate boolean;
368 --
369 -- Variables for IN/OUT parameters
370 l_object_version_number number;
371 --
372 -- Other variables
373 l_proc varchar2(72) := g_package ||'update_recruiting_site';
374 Begin
375 hr_utility.set_location(' Entering:' || l_proc,10);
376 --
377 -- Issue a savepoint
378 --
379 savepoint update_recruiting_site_swi;
380 --
381 -- Initialise Multiple Message Detection
382 --
383 hr_multi_message.enable_message_list;
384 --
385 -- Remember IN OUT parameter IN values
386 --
387 l_object_version_number := p_object_version_number;
388 --
389 -- Convert constant values to their corresponding boolean value
390 --
391 l_validate :=
392 hr_api.constant_to_boolean
393 (p_constant_value => p_validate);
394 --
395 -- Register Surrogate ID or user key values
396 --
397 --
398 -- Call API
399 --
400 irc_recruiting_sites_api.update_recruiting_site
401 (p_recruiting_site_id => p_recruiting_site_id
402 ,p_validate => l_validate
403 ,p_effective_date => p_effective_date
404 ,p_site_name => p_site_name
405 ,p_date_from => p_date_from
406 ,p_date_to => p_date_to
407 ,p_posting_username => p_posting_username
408 ,p_posting_password => p_posting_password
409 ,p_internal => p_internal
410 ,p_external => p_external
411 ,p_third_party => p_third_party
412 ,p_redirection_url => p_redirection_url
413 ,p_posting_url => p_posting_url
414 ,p_posting_cost => p_posting_cost
415 ,p_posting_cost_period => p_posting_cost_period
416 ,p_posting_cost_currency => p_posting_cost_currency
417 ,p_stylesheet => p_stylesheet
418 ,p_attribute_category => p_attribute_category
419 ,p_attribute1 => p_attribute1
420 ,p_attribute2 => p_attribute2
421 ,p_attribute3 => p_attribute3
422 ,p_attribute4 => p_attribute4
423 ,p_attribute5 => p_attribute5
424 ,p_attribute6 => p_attribute6
425 ,p_attribute7 => p_attribute7
426 ,p_attribute8 => p_attribute8
427 ,p_attribute9 => p_attribute9
428 ,p_attribute10 => p_attribute10
429 ,p_attribute11 => p_attribute11
430 ,p_attribute12 => p_attribute12
431 ,p_attribute13 => p_attribute13
432 ,p_attribute14 => p_attribute14
433 ,p_attribute15 => p_attribute15
434 ,p_attribute16 => p_attribute16
435 ,p_attribute17 => p_attribute17
436 ,p_attribute18 => p_attribute18
437 ,p_attribute19 => p_attribute19
438 ,p_attribute20 => p_attribute20
439 ,p_attribute21 => p_attribute21
440 ,p_attribute22 => p_attribute22
441 ,p_attribute23 => p_attribute23
442 ,p_attribute24 => p_attribute24
443 ,p_attribute25 => p_attribute25
444 ,p_attribute26 => p_attribute26
445 ,p_attribute27 => p_attribute27
446 ,p_attribute28 => p_attribute28
447 ,p_attribute29 => p_attribute29
448 ,p_attribute30 => p_attribute30
449 ,p_object_version_number => p_object_version_number
450 ,p_posting_impl_class => p_posting_impl_class
451 );
452 --
453 -- Convert API warning boolean parameter values to specific
454 -- messages and add them to Multiple Message List
455 --
456 --
457 -- Convert API non-warning boolean parameter values
458 --
459 --
460 -- Derive the API return status value based on whether
461 -- messages of any type exist in the Multiple Message List.
462 -- Also disable Multiple Message Detection.
463 --
464 p_return_status := hr_multi_message.get_return_status_disable;
465 hr_utility.set_location(' Leaving:' || l_proc,20);
466 --
467 exception
468 when hr_multi_message.error_message_exist then
469 --
470 -- Catch the Multiple Message List exception which
471 -- indicates API processing has been aborted because
472 -- at least one message exists in the list.
473 --
474 rollback to update_recruiting_site_swi;
475 --
476 -- Reset IN OUT parameters and set OUT parameters
477 --
478 p_object_version_number := l_object_version_number;
479 p_return_status := hr_multi_message.get_return_status_disable;
480 hr_utility.set_location(' Leaving:' || l_proc, 30);
481 when others then
482 --
483 -- When Multiple Message Detection is enabled catch
484 -- any Application specific or other unexpected
485 -- exceptions. Adding appropriate details to the
486 -- Multiple Message List. Otherwise re-raise the
487 -- error.
488 --
489 rollback to update_recruiting_site_swi;
490 if hr_multi_message.unexpected_error_add(l_proc) then
491 hr_utility.set_location(' Leaving:' || l_proc,40);
492 raise;
493 end if;
494 --
495 -- Reset IN OUT and set OUT parameters
496 --
497 p_object_version_number := l_object_version_number;
498 p_return_status := hr_multi_message.get_return_status_disable;
499 hr_utility.set_location(' Leaving:' || l_proc,50);
500 end update_recruiting_site;
501 end irc_recruiting_sites_swi;