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