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