[Home] [Help]
PACKAGE BODY: APPS.IRC_RECRUITING_SITES_API
Source
1 Package Body IRC_RECRUITING_SITES_API as
2 /* $Header: irrseapi.pkb 120.1.12010000.2 2010/01/18 14:33:48 mkjayara ship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := 'IRC_RECRUITING_SITES_API.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |---------------------< CREATE_RECRUITING_SITE >----------------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure CREATE_RECRUITING_SITE
13 (p_validate in boolean default false
14 ,p_language_code in varchar2 default hr_api.userenv_lang
15 ,p_effective_date in date
16 ,p_site_name in varchar2
17 ,p_date_from in date default null
18 ,p_date_to in date default null
19 ,p_posting_username in varchar2 default null
20 ,p_posting_password in varchar2 default null
21 ,p_internal in varchar2 default 'N'
22 ,p_external in varchar2 default 'N'
23 ,p_third_party in varchar2 default 'Y'
24 ,p_redirection_url in varchar2 default null
25 ,p_posting_url in varchar2 default null
26 ,p_posting_cost in number default null
27 ,p_posting_cost_period in varchar2 default null
28 ,p_posting_cost_currency in varchar2 default null
29 ,p_stylesheet in varchar2 default null
30 ,p_attribute_category in varchar2 default null
31 ,p_attribute1 in varchar2 default null
32 ,p_attribute2 in varchar2 default null
33 ,p_attribute3 in varchar2 default null
34 ,p_attribute4 in varchar2 default null
35 ,p_attribute5 in varchar2 default null
36 ,p_attribute6 in varchar2 default null
37 ,p_attribute7 in varchar2 default null
38 ,p_attribute8 in varchar2 default null
39 ,p_attribute9 in varchar2 default null
40 ,p_attribute10 in varchar2 default null
41 ,p_attribute11 in varchar2 default null
42 ,p_attribute12 in varchar2 default null
43 ,p_attribute13 in varchar2 default null
44 ,p_attribute14 in varchar2 default null
45 ,p_attribute15 in varchar2 default null
46 ,p_attribute16 in varchar2 default null
47 ,p_attribute17 in varchar2 default null
48 ,p_attribute18 in varchar2 default null
49 ,p_attribute19 in varchar2 default null
50 ,p_attribute20 in varchar2 default null
51 ,p_attribute21 in varchar2 default null
52 ,p_attribute22 in varchar2 default null
53 ,p_attribute23 in varchar2 default null
54 ,p_attribute24 in varchar2 default null
55 ,p_attribute25 in varchar2 default null
56 ,p_attribute26 in varchar2 default null
57 ,p_attribute27 in varchar2 default null
58 ,p_attribute28 in varchar2 default null
59 ,p_attribute29 in varchar2 default null
60 ,p_attribute30 in varchar2 default null
61 ,p_recruiting_site_id out nocopy number
62 ,p_object_version_number out nocopy number
63 ,p_posting_impl_class in varchar2 default null
64 ) is
65 --
66 -- Declare cursors and local variables
67 --
68 l_proc varchar2(72) := g_package||'CREATE_RECRUITING_SITE';
69 l_object_version_number number;
70 l_recruiting_site_id number;
71 l_effective_date date;
72 l_language_code varchar2(30);
73
74 begin
75 hr_utility.set_location('Entering:'|| l_proc, 10);
76 --
77 -- Issue a savepoint
78 --
79 savepoint CREATE_RECRUITING_SITE;
80 --
81 -- Truncate the time portion from all IN date parameters
82 --
83 l_effective_date := trunc(p_effective_date);
84
85 l_language_code := p_language_code;
86 hr_api.validate_language_code(p_language_code => l_language_code);
87 --
88 -- Call Before Process User Hook
89 --
90 begin
91 hr_utility.set_location(l_proc, 20);
92 IRC_RECRUITING_SITES_BK1.CREATE_RECRUITING_SITE_B
93 (p_effective_date => p_effective_date
94 ,p_language_code => l_language_code
95 ,p_site_name => p_site_name
96 ,p_date_from => p_date_from
97 ,p_date_to => p_date_to
98 ,p_posting_username => p_posting_username
99 ,p_posting_password => p_posting_password
100 ,p_internal => p_internal
101 ,p_external => p_external
102 ,p_third_party => p_third_party
103 ,p_redirection_url => p_redirection_url
104 ,p_posting_url => p_posting_url
105 ,p_posting_cost => p_posting_cost
106 ,p_posting_cost_period => p_posting_cost_period
107 ,p_posting_cost_currency => p_posting_cost_currency
108 ,p_stylesheet => p_stylesheet
109 ,p_attribute_category => p_attribute_category
110 ,p_attribute1 => p_attribute1
111 ,p_attribute2 => p_attribute2
112 ,p_attribute3 => p_attribute3
113 ,p_attribute4 => p_attribute4
114 ,p_attribute5 => p_attribute5
115 ,p_attribute6 => p_attribute6
116 ,p_attribute7 => p_attribute7
117 ,p_attribute8 => p_attribute8
118 ,p_attribute9 => p_attribute9
119 ,p_attribute10 => p_attribute10
120 ,p_attribute11 => p_attribute11
121 ,p_attribute12 => p_attribute12
122 ,p_attribute13 => p_attribute13
123 ,p_attribute14 => p_attribute14
124 ,p_attribute15 => p_attribute15
125 ,p_attribute16 => p_attribute16
126 ,p_attribute17 => p_attribute17
127 ,p_attribute18 => p_attribute18
128 ,p_attribute19 => p_attribute19
129 ,p_attribute20 => p_attribute20
130 ,p_attribute21 => p_attribute21
131 ,p_attribute22 => p_attribute22
132 ,p_attribute23 => p_attribute23
133 ,p_attribute24 => p_attribute24
134 ,p_attribute25 => p_attribute25
135 ,p_attribute26 => p_attribute26
136 ,p_attribute27 => p_attribute27
137 ,p_attribute28 => p_attribute28
138 ,p_attribute29 => p_attribute29
139 ,p_attribute30 => p_attribute30
140 ,p_posting_impl_class => p_posting_impl_class
141 );
142 hr_utility.set_location(l_proc, 30);
143 exception
144 when hr_api.cannot_find_prog_unit then
145 hr_api.cannot_find_prog_unit_error
146 (p_module_name => 'CREATE_RECRUITING_SITE'
147 ,p_hook_type => 'BP'
148 );
149 end;
150 --
151 -- Validation in addition to Row Handlers
152 --
153 --
154 -- Process Logic
155 --
156 hr_utility.set_location(l_proc, 40);
157 irc_rse_ins.ins
158 (p_effective_date => l_effective_date
159 ,p_date_from => p_date_from
160 ,p_date_to => p_date_to
161 ,p_posting_username => p_posting_username
162 ,p_internal => p_internal
163 ,p_external => p_external
164 ,p_third_party => p_third_party
165 ,p_posting_cost => p_posting_cost
166 ,p_posting_cost_period => p_posting_cost_period
167 ,p_posting_cost_currency => p_posting_cost_currency
168 ,p_stylesheet => p_stylesheet
169 ,p_attribute_category => p_attribute_category
170 ,p_attribute1 => p_attribute1
171 ,p_attribute2 => p_attribute2
172 ,p_attribute3 => p_attribute3
173 ,p_attribute4 => p_attribute4
174 ,p_attribute5 => p_attribute5
175 ,p_attribute6 => p_attribute6
176 ,p_attribute7 => p_attribute7
177 ,p_attribute8 => p_attribute8
178 ,p_attribute9 => p_attribute9
179 ,p_attribute10 => p_attribute10
180 ,p_attribute11 => p_attribute11
181 ,p_attribute12 => p_attribute12
182 ,p_attribute13 => p_attribute13
183 ,p_attribute14 => p_attribute14
184 ,p_attribute15 => p_attribute15
185 ,p_attribute16 => p_attribute16
186 ,p_attribute17 => p_attribute17
187 ,p_attribute18 => p_attribute18
188 ,p_attribute19 => p_attribute19
189 ,p_attribute20 => p_attribute20
190 ,p_attribute21 => p_attribute21
191 ,p_attribute22 => p_attribute22
192 ,p_attribute23 => p_attribute23
193 ,p_attribute24 => p_attribute24
194 ,p_attribute25 => p_attribute25
195 ,p_attribute26 => p_attribute26
196 ,p_attribute27 => p_attribute27
197 ,p_attribute28 => p_attribute28
198 ,p_attribute29 => p_attribute29
199 ,p_attribute30 => p_attribute30
200 ,p_recruiting_site_id => l_recruiting_site_id
201 ,p_object_version_number => l_object_version_number
202 ,p_internal_name => p_site_name
203 ,p_posting_impl_class => p_posting_impl_class
204 );
205 --
206 irc_irt_ins.ins_tl
207 (p_recruiting_site_id => l_recruiting_site_id
208 ,p_language_code => l_language_code
209 ,p_site_name => p_site_name
210 ,p_redirection_url => p_redirection_url
211 ,p_posting_url => p_posting_url
212 );
213 --
214 --save the password to the encrypted store
215 if (p_posting_password is not null) then
216 fnd_vault.put('IRC_SITE',l_recruiting_site_id,p_posting_password);
217 end if;
218
219 hr_utility.set_location(l_proc, 50);
220 -- Call After Process User Hook
221 --
222 begin
223 IRC_RECRUITING_SITES_BK1.CREATE_RECRUITING_SITE_A
224 (p_effective_date => l_effective_date
225 ,p_language_code => l_language_code
226 ,p_site_name => p_site_name
227 ,p_date_from => p_date_from
228 ,p_date_to => p_date_to
229 ,p_posting_username => p_posting_username
230 ,p_posting_password => p_posting_password
231 ,p_internal => p_internal
232 ,p_external => p_external
233 ,p_third_party => p_third_party
234 ,p_redirection_url => p_redirection_url
235 ,p_posting_url => p_posting_url
236 ,p_posting_cost => p_posting_cost
237 ,p_posting_cost_period => p_posting_cost_period
238 ,p_posting_cost_currency=> p_posting_cost_currency
239 ,p_stylesheet => p_stylesheet
240 ,p_object_version_number=> l_object_version_number
241 ,p_attribute_category => p_attribute_category
242 ,p_attribute1 => p_attribute1
243 ,p_attribute2 => p_attribute2
244 ,p_attribute3 => p_attribute3
245 ,p_attribute4 => p_attribute4
246 ,p_attribute5 => p_attribute5
247 ,p_attribute6 => p_attribute6
248 ,p_attribute7 => p_attribute7
249 ,p_attribute8 => p_attribute8
250 ,p_attribute9 => p_attribute9
251 ,p_attribute10 => p_attribute10
252 ,p_attribute11 => p_attribute11
253 ,p_attribute12 => p_attribute12
254 ,p_attribute13 => p_attribute13
255 ,p_attribute14 => p_attribute14
256 ,p_attribute15 => p_attribute15
257 ,p_attribute16 => p_attribute16
258 ,p_attribute17 => p_attribute17
259 ,p_attribute18 => p_attribute18
260 ,p_attribute19 => p_attribute19
261 ,p_attribute20 => p_attribute20
262 ,p_attribute21 => p_attribute21
263 ,p_attribute22 => p_attribute22
264 ,p_attribute23 => p_attribute23
265 ,p_attribute24 => p_attribute24
266 ,p_attribute25 => p_attribute25
267 ,p_attribute26 => p_attribute26
268 ,p_attribute27 => p_attribute27
269 ,p_attribute28 => p_attribute28
270 ,p_attribute29 => p_attribute29
271 ,p_attribute30 => p_attribute30
272 ,p_recruiting_site_id => l_recruiting_site_id
273 ,p_posting_impl_class => p_posting_impl_class
274 );
275 hr_utility.set_location(l_proc, 60);
276 exception
277 when hr_api.cannot_find_prog_unit then
278 hr_api.cannot_find_prog_unit_error
279 (p_module_name => 'CREATE_RECRUITING_SITE'
280 ,p_hook_type => 'AP'
281 );
282 end;
283 --
284 -- When in validation only mode raise the Validate_Enabled exception
285 --
286 if p_validate then
287 raise hr_api.validate_enabled;
288 end if;
289 --
290 -- Set all output arguments
291 --
292 p_object_version_number := l_object_version_number;
293 p_recruiting_site_id := l_recruiting_site_id;
294 --
295 hr_utility.set_location(' Leaving:'||l_proc, 70);
296 exception
297 when hr_api.validate_enabled then
298 --
299 -- As the Validate_Enabled exception has been raised
300 -- we must rollback to the savepoint
301 --
302 rollback to CREATE_RECRUITING_SITE;
303 --
304 -- Only set output warning arguments
305 -- (Any key or derived arguments must be set to null
306 -- when validation only mode is being used.)
307 --
308 --
309 -- Reset IN OUT parameters and set OUT parameters
310 --
311 p_recruiting_site_id := null;
312 p_object_version_number := null;
313 hr_utility.set_location(' Leaving:'||l_proc, 80);
314 when others then
315 --
316 -- A validation or unexpected error has occured
317 --
318 p_object_version_number := null;
319 rollback to CREATE_RECRUITING_SITE;
320 --
321 -- Reset IN OUT parameters and set OUT parameters
322 --
323 p_recruiting_site_id := null;
324 p_object_version_number := null;
325 hr_utility.set_location(' Leaving:'||l_proc, 90);
326 raise;
327 end CREATE_RECRUITING_SITE;
328 --
329 -- ----------------------------------------------------------------------------
330 -- |---------------------< UPDATE_RECRUITING_SITE >--------------------------|
331 -- ----------------------------------------------------------------------------
332 --
333 procedure UPDATE_RECRUITING_SITE
334 (p_recruiting_site_id in number
335 ,p_validate in boolean default false
336 ,p_language_code in varchar2 default hr_api.userenv_lang
337 ,p_effective_date in date
338 ,p_site_name in varchar2 default hr_api.g_varchar2
339 ,p_date_from in date default hr_api.g_date
340 ,p_date_to in date default hr_api.g_date
341 ,p_posting_username in varchar2 default hr_api.g_varchar2
342 ,p_posting_password in varchar2 default hr_api.g_varchar2
343 ,p_internal in varchar2 default hr_api.g_varchar2
344 ,p_external in varchar2 default hr_api.g_varchar2
345 ,p_third_party in varchar2 default hr_api.g_varchar2
346 ,p_redirection_url in varchar2 default hr_api.g_varchar2
347 ,p_posting_url in varchar2 default hr_api.g_varchar2
348 ,p_posting_cost in number default hr_api.g_number
349 ,p_posting_cost_period in varchar2 default hr_api.g_varchar2
350 ,p_posting_cost_currency in varchar2 default hr_api.g_varchar2
351 ,p_stylesheet in varchar2 default hr_api.g_varchar2
352 ,p_attribute_category in varchar2 default hr_api.g_varchar2
353 ,p_attribute1 in varchar2 default hr_api.g_varchar2
354 ,p_attribute2 in varchar2 default hr_api.g_varchar2
355 ,p_attribute3 in varchar2 default hr_api.g_varchar2
356 ,p_attribute4 in varchar2 default hr_api.g_varchar2
357 ,p_attribute5 in varchar2 default hr_api.g_varchar2
358 ,p_attribute6 in varchar2 default hr_api.g_varchar2
359 ,p_attribute7 in varchar2 default hr_api.g_varchar2
360 ,p_attribute8 in varchar2 default hr_api.g_varchar2
361 ,p_attribute9 in varchar2 default hr_api.g_varchar2
362 ,p_attribute10 in varchar2 default hr_api.g_varchar2
363 ,p_attribute11 in varchar2 default hr_api.g_varchar2
364 ,p_attribute12 in varchar2 default hr_api.g_varchar2
365 ,p_attribute13 in varchar2 default hr_api.g_varchar2
366 ,p_attribute14 in varchar2 default hr_api.g_varchar2
367 ,p_attribute15 in varchar2 default hr_api.g_varchar2
368 ,p_attribute16 in varchar2 default hr_api.g_varchar2
369 ,p_attribute17 in varchar2 default hr_api.g_varchar2
370 ,p_attribute18 in varchar2 default hr_api.g_varchar2
371 ,p_attribute19 in varchar2 default hr_api.g_varchar2
372 ,p_attribute20 in varchar2 default hr_api.g_varchar2
373 ,p_attribute21 in varchar2 default hr_api.g_varchar2
374 ,p_attribute22 in varchar2 default hr_api.g_varchar2
375 ,p_attribute23 in varchar2 default hr_api.g_varchar2
376 ,p_attribute24 in varchar2 default hr_api.g_varchar2
377 ,p_attribute25 in varchar2 default hr_api.g_varchar2
378 ,p_attribute26 in varchar2 default hr_api.g_varchar2
379 ,p_attribute27 in varchar2 default hr_api.g_varchar2
380 ,p_attribute28 in varchar2 default hr_api.g_varchar2
381 ,p_attribute29 in varchar2 default hr_api.g_varchar2
382 ,p_attribute30 in varchar2 default hr_api.g_varchar2
383 ,p_object_version_number in out nocopy number
384 ,p_posting_impl_class in varchar2 default hr_api.g_varchar2
385 ) is
386 --
387 -- Declare cursors and local variables
388 --
389 l_proc varchar2(72) := g_package||'UPDATE_RECRUITING_SITE';
390 --
391 l_effective_date date;
392 l_language_code varchar2(30);
393 l_object_version_number number := p_object_version_number;
394 BEGIN
395 --
396 hr_utility.set_location('Entering:'|| l_proc, 10);
397 --
398 -- Issue a savepoint
399 --
400 savepoint UPDATE_RECRUITING_SITE;
401 --
402 -- Truncate the time portion from all IN date parameters
403 --
404 l_effective_date := trunc(p_effective_date);
405
406 l_language_code:=p_language_code;
407 hr_api.validate_language_code(p_language_code => l_language_code);
408 --
409 -- Call Before Process User Hook
410 --
411 begin
412 IRC_RECRUITING_SITES_BK2.UPDATE_RECRUITING_SITE_B
413 (p_recruiting_site_id => p_recruiting_site_id
414 ,p_effective_date => l_effective_date
415 ,p_language_code => l_language_code
416 ,p_site_name => p_site_name
417 ,p_date_from => p_date_from
418 ,p_date_to => p_date_to
419 ,p_posting_username => p_posting_username
420 ,p_posting_password => p_posting_password
421 ,p_internal => p_internal
422 ,p_external => p_external
423 ,p_third_party => p_third_party
424 ,p_redirection_url => p_redirection_url
425 ,p_posting_url => p_posting_url
426 ,p_posting_cost => p_posting_cost
427 ,p_posting_cost_period => p_posting_cost_period
428 ,p_posting_cost_currency=> p_posting_cost_currency
429 ,p_stylesheet => p_stylesheet
430 ,p_object_version_number=> l_object_version_number
431 ,p_attribute_category => p_attribute_category
432 ,p_attribute1 => p_attribute1
433 ,p_attribute2 => p_attribute2
434 ,p_attribute3 => p_attribute3
435 ,p_attribute4 => p_attribute4
436 ,p_attribute5 => p_attribute5
437 ,p_attribute6 => p_attribute6
438 ,p_attribute7 => p_attribute7
439 ,p_attribute8 => p_attribute8
440 ,p_attribute9 => p_attribute9
441 ,p_attribute10 => p_attribute10
442 ,p_attribute11 => p_attribute11
443 ,p_attribute12 => p_attribute12
444 ,p_attribute13 => p_attribute13
445 ,p_attribute14 => p_attribute14
446 ,p_attribute15 => p_attribute15
447 ,p_attribute16 => p_attribute16
448 ,p_attribute17 => p_attribute17
449 ,p_attribute18 => p_attribute18
450 ,p_attribute19 => p_attribute19
451 ,p_attribute20 => p_attribute20
452 ,p_attribute21 => p_attribute21
453 ,p_attribute22 => p_attribute22
454 ,p_attribute23 => p_attribute23
455 ,p_attribute24 => p_attribute24
456 ,p_attribute25 => p_attribute25
457 ,p_attribute26 => p_attribute26
458 ,p_attribute27 => p_attribute27
459 ,p_attribute28 => p_attribute28
460 ,p_attribute29 => p_attribute29
461 ,p_attribute30 => p_attribute30
462 ,p_posting_impl_class => p_posting_impl_class
463 );
464 exception
465 when hr_api.cannot_find_prog_unit then
466 hr_api.cannot_find_prog_unit_error
467 (p_module_name => 'UPDATE_RECRUITING_SITE'
468 ,p_hook_type => 'BP'
469 );
470 end;
471 --
472 -- Validation in addition to Row Handlers
473 --
474 --
475 --
476 -- Process Logic
477 --
478 --
479 irc_rse_upd.upd
480 (p_effective_date => l_effective_date
481 ,p_recruiting_site_id => p_recruiting_site_id
482 ,p_object_version_number => l_object_version_number
483 ,p_date_from => p_date_from
484 ,p_date_to => p_date_to
485 ,p_posting_username => p_posting_username
486 ,p_internal => p_internal
487 ,p_external => p_external
488 ,p_third_party => p_third_party
489 ,p_posting_cost => p_posting_cost
490 ,p_posting_cost_period => p_posting_cost_period
491 ,p_posting_cost_currency => p_posting_cost_currency
492 ,p_stylesheet => p_stylesheet
493 ,p_attribute_category => p_attribute_category
494 ,p_attribute1 => p_attribute1
495 ,p_attribute2 => p_attribute2
496 ,p_attribute3 => p_attribute3
497 ,p_attribute4 => p_attribute4
498 ,p_attribute5 => p_attribute5
499 ,p_attribute6 => p_attribute6
500 ,p_attribute7 => p_attribute7
501 ,p_attribute8 => p_attribute8
502 ,p_attribute9 => p_attribute9
503 ,p_attribute10 => p_attribute10
504 ,p_attribute11 => p_attribute11
505 ,p_attribute12 => p_attribute12
506 ,p_attribute13 => p_attribute13
507 ,p_attribute14 => p_attribute14
508 ,p_attribute15 => p_attribute15
509 ,p_attribute16 => p_attribute16
510 ,p_attribute17 => p_attribute17
511 ,p_attribute18 => p_attribute18
512 ,p_attribute19 => p_attribute19
513 ,p_attribute20 => p_attribute20
514 ,p_attribute21 => p_attribute21
515 ,p_attribute22 => p_attribute22
516 ,p_attribute23 => p_attribute23
517 ,p_attribute24 => p_attribute24
518 ,p_attribute25 => p_attribute25
519 ,p_attribute26 => p_attribute26
520 ,p_attribute27 => p_attribute27
521 ,p_attribute28 => p_attribute28
522 ,p_attribute29 => p_attribute29
523 ,p_attribute30 => p_attribute30
524 ,p_internal_name => p_site_name
525 ,p_posting_impl_class => p_posting_impl_class
526 );
527 --
528 --
529 -- Process Translation Logic
530 --
531
532 irc_irt_upd.upd_tl
533 (p_recruiting_site_id => p_recruiting_site_id
534 ,p_language_code => l_language_code
535 ,p_site_name => p_site_name
536 ,p_redirection_url => p_redirection_url
537 ,p_posting_url => p_posting_url
538 );
539 --
540 --save the password to the encrypted store
541 if (p_posting_password <>hr_api.g_varchar2) then
542 fnd_vault.put('IRC_SITE',p_recruiting_site_id,p_posting_password);
543 end if;
544 --
545 -- Call After Process User Hook
546 --
547 begin
548 IRC_RECRUITING_SITES_BK2.UPDATE_RECRUITING_SITE_A
549 (p_recruiting_site_id => p_recruiting_site_id
550 ,p_effective_date => l_effective_date
551 ,p_language_code => l_language_code
552 ,p_site_name => p_site_name
553 ,p_date_from => p_date_from
554 ,p_date_to => p_date_to
555 ,p_posting_username => p_posting_username
556 ,p_posting_password => p_posting_password
557 ,p_internal => p_internal
558 ,p_external => p_external
559 ,p_third_party => p_third_party
560 ,p_redirection_url => p_redirection_url
561 ,p_posting_url => p_posting_url
562 ,p_posting_cost => p_posting_cost
563 ,p_posting_cost_period => p_posting_cost_period
564 ,p_posting_cost_currency=> p_posting_cost_currency
565 ,p_stylesheet => p_stylesheet
566 ,p_object_version_number=> l_object_version_number
567 ,p_attribute_category => p_attribute_category
568 ,p_attribute1 => p_attribute1
569 ,p_attribute2 => p_attribute2
570 ,p_attribute3 => p_attribute3
571 ,p_attribute4 => p_attribute4
572 ,p_attribute5 => p_attribute5
573 ,p_attribute6 => p_attribute6
574 ,p_attribute7 => p_attribute7
575 ,p_attribute8 => p_attribute8
576 ,p_attribute9 => p_attribute9
577 ,p_attribute10 => p_attribute10
578 ,p_attribute11 => p_attribute11
579 ,p_attribute12 => p_attribute12
580 ,p_attribute13 => p_attribute13
581 ,p_attribute14 => p_attribute14
582 ,p_attribute15 => p_attribute15
583 ,p_attribute16 => p_attribute16
584 ,p_attribute17 => p_attribute17
585 ,p_attribute18 => p_attribute18
586 ,p_attribute19 => p_attribute19
587 ,p_attribute20 => p_attribute20
588 ,p_attribute21 => p_attribute21
589 ,p_attribute22 => p_attribute22
590 ,p_attribute23 => p_attribute23
591 ,p_attribute24 => p_attribute24
592 ,p_attribute25 => p_attribute25
593 ,p_attribute26 => p_attribute26
594 ,p_attribute27 => p_attribute27
595 ,p_attribute28 => p_attribute28
596 ,p_attribute29 => p_attribute29
597 ,p_attribute30 => p_attribute30
598 ,p_posting_impl_class => p_posting_impl_class
599 );
600 exception
601 when hr_api.cannot_find_prog_unit then
602 hr_api.cannot_find_prog_unit_error
603 (p_module_name => 'UPDATE_RECRUITING_SITE'
604 ,p_hook_type => 'AP'
605 );
606 end;
607 --
608 -- When in validation only mode raise the Validate_Enabled exception
609 --
610 if p_validate then
611 raise hr_api.validate_enabled;
612 end if;
613 --
614 -- Set all output arguments
615 --
616 --
617 p_object_version_number := l_object_version_number;
618 hr_utility.set_location(' Leaving:'||l_proc, 70);
619 exception
620 when hr_api.validate_enabled then
621 --
622 -- As the Validate_Enabled exception has been raised
623 -- we must rollback to the savepoint
624 --
625 rollback to UPDATE_RECRUITING_SITE;
626 --
627 -- Only set output warning arguments
628 -- (Any key or derived arguments must be set to null
629 -- when validation only mode is being used.)
630 --
631 --
632 -- Reset IN OUT parameters and set OUT parameters
633 --
634 p_object_version_number := l_object_version_number;
635 hr_utility.set_location(' Leaving:'||l_proc, 80);
636 when others then
637 --
638 -- A validation or unexpected error has occured
639 --
640 rollback to UPDATE_RECRUITING_SITE;
641 --
642 -- Reset IN OUT parameters and set OUT parameters
643 --
644 p_object_version_number := l_object_version_number;
645 hr_utility.set_location(' Leaving:'||l_proc, 90);
646 raise;
647 end UPDATE_RECRUITING_SITE;
648 --
649 -- ----------------------------------------------------------------------------
650 -- |---------------------< DELETE_RECRUITING_SITE >------------------------|
651 -- ----------------------------------------------------------------------------
652 --
653 procedure DELETE_RECRUITING_SITE
654 (p_validate in boolean default false
655 ,p_recruiting_site_id in number
656 ,p_object_version_number in number
657 ) is
658 --
659 -- Declare cursors and local variables
660 --
661 l_proc varchar2(72) := g_package||'DELETE_RECRUITING_SITE';
662 --
663 begin
664 hr_utility.set_location('Entering:'|| l_proc, 10);
665 --
666 -- Issue a savepoint
667 --
668 savepoint DELETE_RECRUITING_SITE;
669 --
670 -- Truncate the time portion from all IN date parameters
671 --
672 --
673 -- Call Before Process User Hook
674 --
675 begin
676 IRC_RECRUITING_SITES_BK3.DELETE_RECRUITING_SITE_B
677 (p_recruiting_site_id => p_recruiting_site_id
678 ,p_object_version_number => p_object_version_number
679 );
680 exception
681 when hr_api.cannot_find_prog_unit then
682 hr_api.cannot_find_prog_unit_error
683 (p_module_name => 'DELETE_RECRUITING_SITE'
684 ,p_hook_type => 'BP'
685 );
686 end;
687 --
688 -- Validation in addition to Row Handlers
689 --
690 --
691 -- Process Logic
692 --
693 --
694 -- Process Translation Logic
695 --
696 irc_rse_shd.lck
697 (p_recruiting_site_id => p_recruiting_site_id
698 ,p_object_version_number => p_object_version_number
699 );
700 --
701 irc_irt_del.del_tl
702 (p_recruiting_site_id => p_recruiting_site_id
703 );
704
705 irc_rse_del.del
706 (p_recruiting_site_id => p_recruiting_site_id
707 ,p_object_version_number => p_object_version_number
708 );
709 --
710 -- delete the password
711 --
712 if (fnd_vault.tst('IRC_SITE',p_recruiting_site_id)=true) then
713 fnd_vault.del('IRC_SITE',p_recruiting_site_id);
714 end if;
715 --
716 -- Call After Process User Hook
717 --
718 begin
719 IRC_RECRUITING_SITES_BK3.DELETE_RECRUITING_SITE_A
720 (p_recruiting_site_id => p_recruiting_site_id
721 ,p_object_version_number => p_object_version_number
722 );
723 exception
724 when hr_api.cannot_find_prog_unit then
725 hr_api.cannot_find_prog_unit_error
726 (p_module_name => 'DELETE_RECRUITING_SITE'
727 ,p_hook_type => 'AP'
728 );
729 end;
730 --
731 -- When in validation only mode raise the Validate_Enabled exception
732 --
733 if p_validate then
734 raise hr_api.validate_enabled;
735 end if;
736 --
737 -- Set all output arguments
738 --
739 --
740 hr_utility.set_location(' Leaving:'||l_proc, 70);
741 exception
742 when hr_api.validate_enabled then
743 --
744 -- As the Validate_Enabled exception has been raised
745 -- we must rollback to the savepoint
746 --
747 rollback to DELETE_RECRUITING_SITE;
748 --
749 -- Only set output warning arguments
750 -- (Any key or derived arguments must be set to null
751 -- when validation only mode is being used.)
752 --
753 --
754 hr_utility.set_location(' Leaving:'||l_proc, 80);
755 when others then
756 --
757 -- A validation or unexpected error has occured
758 --
759 rollback to DELETE_RECRUITING_SITE;
760 hr_utility.set_location(' Leaving:'||l_proc, 90);
761 raise;
762 end DELETE_RECRUITING_SITE;
763 --
764 end IRC_RECRUITING_SITES_API;