[Home] [Help]
PACKAGE BODY: APPS.OTA_CERTIFICATION_API
Source
1 Package Body ota_certification_api as
2 /* $Header: otcrtapi.pkb 120.1 2005/08/10 15:51 asud noship $ */
3 -- Package Variables
4 --
5 g_package varchar2(33) := ' OTA_CERTIFICATION_API.';
6 --
7 -- ----------------------------------------------------------------------------
8 -- |--------------------------< CREATE_CERTIFICATION >------------------------|
9 -- ----------------------------------------------------------------------------
10 -- {Start Of Comments}
11 --
12 -- Description:
13 --
14 --
15 -- Prerequisites:
16 --
17 --
18 -- In Parameters:
19 -- Name Reqd Type Description
20 --
21 -- Post Success:
22 --
23 --
24 --
25 -- Post Failure:
26 --
27 --
28 -- Access Status:
29 -- Public.
30 --
31 -- {End Of Comments}
32 --
33 procedure create_certification
34 (p_effective_date in date
35 ,p_validate in boolean default false
36 ,p_name in varchar2
37 ,p_business_group_id in number
38 ,p_public_flag in varchar2 default 'Y'
39 ,p_initial_completion_date in date default null
40 ,p_initial_completion_duration in number default null
41 ,p_initial_compl_duration_units in varchar2 default null
42 ,p_renewal_duration in number default null
43 ,p_renewal_duration_units in varchar2 default null
44 ,p_notify_days_before_expire in number default null
45 ,p_start_date_active in date default null
46 ,p_end_date_active in date default null
47 ,p_description in varchar2 default null
48 ,p_objectives in varchar2 default null
49 ,p_purpose in varchar2 default null
50 ,p_keywords in varchar2 default null
51 ,p_end_date_comments in varchar2 default null
52 ,p_initial_period_comments in varchar2 default null
53 ,p_renewal_period_comments in varchar2 default null
54 ,p_attribute_category in varchar2 default null
55 ,p_attribute1 in varchar2 default null
56 ,p_attribute2 in varchar2 default null
57 ,p_attribute3 in varchar2 default null
58 ,p_attribute4 in varchar2 default null
59 ,p_attribute5 in varchar2 default null
60 ,p_attribute6 in varchar2 default null
61 ,p_attribute7 in varchar2 default null
62 ,p_attribute8 in varchar2 default null
63 ,p_attribute9 in varchar2 default null
64 ,p_attribute10 in varchar2 default null
65 ,p_attribute11 in varchar2 default null
66 ,p_attribute12 in varchar2 default null
67 ,p_attribute13 in varchar2 default null
68 ,p_attribute14 in varchar2 default null
69 ,p_attribute15 in varchar2 default null
70 ,p_attribute16 in varchar2 default null
71 ,p_attribute17 in varchar2 default null
72 ,p_attribute18 in varchar2 default null
73 ,p_attribute19 in varchar2 default null
74 ,p_attribute20 in varchar2 default null
75 ,p_VALIDITY_DURATION in NUMBER default null
76 ,p_VALIDITY_DURATION_UNITS in VARCHAR2 default null
77 ,p_RENEWABLE_FLAG in VARCHAR2 default null
78 ,p_VALIDITY_START_TYPE in VARCHAR2 default null
79 ,p_COMPETENCY_UPDATE_LEVEL in VARCHAR2 default null
80 ,p_certification_id out nocopy number
81 ,p_object_version_number out nocopy number
82 ) is
83 --
84 -- Declare cursors and local variables
85 --
86 l_proc varchar2(72) := g_package||' create_certification';
87 l_certification_id number;
88 l_object_version_number number;
89 l_effective_date date;
90 begin
91 hr_utility.set_location('Entering:'|| l_proc, 10);
92 --
93 -- Issue a savepoint
94 --
95 savepoint CREATE_CERTIFICATION;
96 l_effective_date := trunc(p_effective_date);
97
98
99 begin
100 ota_certification_bk1.create_certification_b
101 (p_effective_date => p_effective_date
102 ,p_validate => p_validate
103 ,p_name => p_name
104 ,p_business_group_id => p_business_group_id
105 ,p_public_flag => p_public_flag
106 ,p_initial_completion_date => p_initial_completion_date
107 ,p_initial_completion_duration => p_initial_completion_duration
108 ,p_initial_compl_duration_units => p_initial_compl_duration_units
109 ,p_renewal_duration => p_renewal_duration
110 ,p_renewal_duration_units => p_renewal_duration_units
111 ,p_notify_days_before_expire => p_notify_days_before_expire
112 ,p_start_date_active => p_start_date_active
113 ,p_end_date_active => p_end_date_active
114 ,p_description => p_description
115 ,p_objectives => p_objectives
116 ,p_purpose => p_purpose
117 ,p_keywords => p_keywords
118 ,p_end_date_comments => p_end_date_comments
119 ,p_initial_period_comments => p_initial_period_comments
120 ,p_renewal_period_comments => p_renewal_period_comments
121 ,p_attribute_category => p_attribute_category
122 ,p_attribute1 => p_attribute1
123 ,p_attribute2 => p_attribute2
124 ,p_attribute3 => p_attribute3
125 ,p_attribute4 => p_attribute4
126 ,p_attribute5 => p_attribute5
127 ,p_attribute6 => p_attribute6
128 ,p_attribute7 => p_attribute7
129 ,p_attribute8 => p_attribute8
130 ,p_attribute9 => p_attribute9
131 ,p_attribute10 => p_attribute10
132 ,p_attribute11 => p_attribute11
133 ,p_attribute12 => p_attribute12
134 ,p_attribute13 => p_attribute13
135 ,p_attribute14 => p_attribute14
136 ,p_attribute15 => p_attribute15
137 ,p_attribute16 => p_attribute16
138 ,p_attribute17 => p_attribute17
139 ,p_attribute18 => p_attribute18
140 ,p_attribute19 => p_attribute19
141 ,p_attribute20 => p_attribute20
142 ,p_VALIDITY_DURATION => p_VALIDITY_DURATION
143 ,p_VALIDITY_DURATION_UNITS => p_VALIDITY_DURATION_UNITS
144 ,p_RENEWABLE_FLAG => p_RENEWABLE_FLAG
145 ,p_VALIDITY_START_TYPE => p_VALIDITY_START_TYPE
146 ,p_COMPETENCY_UPDATE_LEVEL => p_COMPETENCY_UPDATE_LEVEL
147 );
148 exception
149 when hr_api.cannot_find_prog_unit then
150 hr_api.cannot_find_prog_unit_error
151 (p_module_name => 'CREATE_CERTIFICATION'
152 ,p_hook_type => 'BP'
153 );
154 end;
155
156 --
157 -- Process Logic
158 --
159 ota_crt_ins.ins
160 (p_effective_date => p_effective_date
161 ,p_business_group_id => p_business_group_id
162 ,p_public_flag => p_public_flag
163 ,p_initial_completion_date => p_initial_completion_date
164 ,p_initial_completion_duration => p_initial_completion_duration
165 ,p_initial_compl_duration_units => p_initial_compl_duration_units
166 ,p_renewal_duration => p_renewal_duration
167 ,p_renewal_duration_units => p_renewal_duration_units
168 ,p_notify_days_before_expire => p_notify_days_before_expire
169 ,p_start_date_active => p_start_date_active
170 ,p_end_date_active => p_end_date_active
171 ,p_attribute_category => p_attribute_category
172 ,p_attribute1 => p_attribute1
173 ,p_attribute2 => p_attribute2
174 ,p_attribute3 => p_attribute3
175 ,p_attribute4 => p_attribute4
176 ,p_attribute5 => p_attribute5
177 ,p_attribute6 => p_attribute6
178 ,p_attribute7 => p_attribute7
179 ,p_attribute8 => p_attribute8
180 ,p_attribute9 => p_attribute9
181 ,p_attribute10 => p_attribute10
182 ,p_attribute11 => p_attribute11
183 ,p_attribute12 => p_attribute12
184 ,p_attribute13 => p_attribute13
185 ,p_attribute14 => p_attribute14
186 ,p_attribute15 => p_attribute15
187 ,p_attribute16 => p_attribute16
188 ,p_attribute17 => p_attribute17
189 ,p_attribute18 => p_attribute18
190 ,p_attribute19 => p_attribute19
191 ,p_attribute20 => p_attribute20
192 ,p_VALIDITY_DURATION => p_VALIDITY_DURATION
193 ,p_VALIDITY_DURATION_UNITS => p_VALIDITY_DURATION_UNITS
194 ,p_RENEWABLE_FLAG => p_RENEWABLE_FLAG
195 ,p_VALIDITY_START_TYPE => p_VALIDITY_START_TYPE
196 ,p_COMPETENCY_UPDATE_LEVEL => p_COMPETENCY_UPDATE_LEVEL
197 ,p_certification_id => l_certification_id
198 ,p_object_version_number => l_object_version_number
199 );
200 --
201 -- Set all output arguments
202 --
203 p_certification_id := l_certification_id;
204 p_object_version_number := l_object_version_number;
205
206
207 ota_ctl_ins.ins_tl
208 (
209 p_effective_date => p_effective_date
210 ,p_language_code => USERENV('LANG')
211 ,p_certification_id => p_certification_id
212 ,p_name => rtrim(p_name)
213 ,p_description => p_description
214 ,p_objectives => p_objectives
215 ,p_purpose => p_purpose
216 ,p_keywords => p_keywords
217 ,p_end_date_comments => p_end_date_comments
218 ,p_initial_period_comments => p_initial_period_comments
219 ,p_renewal_period_comments => p_renewal_period_comments
220 );
221
222
223 begin
224 ota_certification_bk1.create_certification_a
225 (p_effective_date => p_effective_date
226 ,p_certification_id => p_certification_id
227 ,p_validate => p_validate
228 ,p_name => p_name
229 ,p_business_group_id => p_business_group_id
230 ,p_public_flag => p_public_flag
231 ,p_initial_completion_date => p_initial_completion_date
232 ,p_initial_completion_duration => p_initial_completion_duration
233 ,p_initial_compl_duration_units => p_initial_compl_duration_units
234 ,p_renewal_duration => p_renewal_duration
235 ,p_renewal_duration_units => p_renewal_duration_units
236 ,p_notify_days_before_expire => p_notify_days_before_expire
237 ,p_start_date_active => p_start_date_active
238 ,p_end_date_active => p_end_date_active
239 ,p_description => p_description
240 ,p_objectives => p_objectives
241 ,p_purpose => p_purpose
242 ,p_keywords => p_keywords
246 ,p_attribute_category => p_attribute_category
243 ,p_end_date_comments => p_end_date_comments
244 ,p_initial_period_comments => p_initial_period_comments
245 ,p_renewal_period_comments => p_renewal_period_comments
247 ,p_attribute1 => p_attribute1
248 ,p_attribute2 => p_attribute2
249 ,p_attribute3 => p_attribute3
250 ,p_attribute4 => p_attribute4
251 ,p_attribute5 => p_attribute5
252 ,p_attribute6 => p_attribute6
253 ,p_attribute7 => p_attribute7
254 ,p_attribute8 => p_attribute8
255 ,p_attribute9 => p_attribute9
256 ,p_attribute10 => p_attribute10
257 ,p_attribute11 => p_attribute11
258 ,p_attribute12 => p_attribute12
259 ,p_attribute13 => p_attribute13
260 ,p_attribute14 => p_attribute14
261 ,p_attribute15 => p_attribute15
262 ,p_attribute16 => p_attribute16
263 ,p_attribute17 => p_attribute17
264 ,p_attribute18 => p_attribute18
265 ,p_attribute19 => p_attribute19
266 ,p_attribute20 => p_attribute20
267 ,p_VALIDITY_DURATION => p_VALIDITY_DURATION
268 ,p_VALIDITY_DURATION_UNITS => p_VALIDITY_DURATION_UNITS
269 ,p_RENEWABLE_FLAG => p_RENEWABLE_FLAG
270 ,p_VALIDITY_START_TYPE => p_VALIDITY_START_TYPE
271 ,p_COMPETENCY_UPDATE_LEVEL => p_COMPETENCY_UPDATE_LEVEL
272 );
273 exception
274 when hr_api.cannot_find_prog_unit then
275 hr_api.cannot_find_prog_unit_error
276 (p_module_name => 'CREATE_CERTIFICATION'
277 ,p_hook_type => 'AP'
278 );
279 end;
280
281 --
282 -- When in validation only mode raise the Validate_Enabled exception
283 --
284 if p_validate then
285 raise hr_api.validate_enabled;
286 end if;
287
288 hr_utility.set_location(' Leaving:'||l_proc, 70);
289 exception
290 when hr_api.validate_enabled then
291 --
292 -- As the Validate_Enabled exception has been raised
293 -- we must rollback to the savepoint
294 --
295 rollback to CREATE_CERTIFICATION;
296 --
297 -- Only set output warning arguments
298 -- (Any key or derived arguments must be set to null
299 -- when validation only mode is being used.)
300 --
301 p_certification_id := null;
302 p_object_version_number := null;
303 hr_utility.set_location(' Leaving:'||l_proc, 80);
304 when others then
305 --
306 -- A validation or unexpected error has occured
307 --
308 rollback to CREATE_CERTIFICATION;
309 p_certification_id := null;
310 p_object_version_number := null;
311 hr_utility.set_location(' Leaving:'||l_proc, 90);
312 raise;
313 end create_certification;
314 -- ----------------------------------------------------------------------------
315 -- |-------------------------< UPDATE_LEARNING_PATH >-------------------------|
316 -- ----------------------------------------------------------------------------
317 procedure update_certification
318 (p_effective_date in date
319 ,p_certification_id in number
320 ,p_object_version_number in out nocopy number
321 ,p_name in varchar2 default hr_api.g_varchar2
322 ,p_public_flag in varchar2 default hr_api.g_varchar2
323 ,p_initial_completion_date in date default hr_api.g_date
324 ,p_initial_completion_duration in number default hr_api.g_number
325 ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
326 ,p_renewal_duration in number default hr_api.g_number
327 ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
328 ,p_notify_days_before_expire in number default hr_api.g_number
329 ,p_start_date_active in date default hr_api.g_date
330 ,p_end_date_active in date default hr_api.g_date
331 ,p_description in varchar2 default hr_api.g_varchar2
332 ,p_objectives in varchar2 default hr_api.g_varchar2
333 ,p_purpose in varchar2 default hr_api.g_varchar2
334 ,p_keywords in varchar2 default hr_api.g_varchar2
335 ,p_end_date_comments in varchar2 default hr_api.g_varchar2
336 ,p_initial_period_comments in varchar2 default hr_api.g_varchar2
337 ,p_renewal_period_comments in varchar2 default hr_api.g_varchar2
338 ,p_attribute_category in varchar2 default hr_api.g_varchar2
339 ,p_attribute1 in varchar2 default hr_api.g_varchar2
340 ,p_attribute2 in varchar2 default hr_api.g_varchar2
341 ,p_attribute3 in varchar2 default hr_api.g_varchar2
342 ,p_attribute4 in varchar2 default hr_api.g_varchar2
343 ,p_attribute5 in varchar2 default hr_api.g_varchar2
344 ,p_attribute6 in varchar2 default hr_api.g_varchar2
345 ,p_attribute7 in varchar2 default hr_api.g_varchar2
346 ,p_attribute8 in varchar2 default hr_api.g_varchar2
347 ,p_attribute9 in varchar2 default hr_api.g_varchar2
348 ,p_attribute10 in varchar2 default hr_api.g_varchar2
349 ,p_attribute11 in varchar2 default hr_api.g_varchar2
350 ,p_attribute12 in varchar2 default hr_api.g_varchar2
351 ,p_attribute13 in varchar2 default hr_api.g_varchar2
355 ,p_attribute17 in varchar2 default hr_api.g_varchar2
352 ,p_attribute14 in varchar2 default hr_api.g_varchar2
353 ,p_attribute15 in varchar2 default hr_api.g_varchar2
354 ,p_attribute16 in varchar2 default hr_api.g_varchar2
356 ,p_attribute18 in varchar2 default hr_api.g_varchar2
357 ,p_attribute19 in varchar2 default hr_api.g_varchar2
358 ,p_attribute20 in varchar2 default hr_api.g_varchar2
359 ,p_business_group_id in number default hr_api.g_number
360 ,p_VALIDITY_DURATION in number default hr_api.g_number
361 ,p_VALIDITY_DURATION_UNITS in varchar2 default hr_api.g_varchar2
362 ,p_RENEWABLE_FLAG in varchar2 default hr_api.g_varchar2
363 ,p_VALIDITY_START_TYPE in varchar2 default hr_api.g_varchar2
364 ,p_COMPETENCY_UPDATE_LEVEL in varchar2 default hr_api.g_varchar2
365 ,p_validate in boolean default false
366 ) is
367 --
368 -- Declare cursors and local variables
369 --
370 l_proc varchar2(72) := g_package||' update_certification';
371 l_certification_id number;
372 l_object_version_number number;
373 l_effective_date date;
374 begin
375 hr_utility.set_location('Entering:'|| l_proc, 10);
376 --
377 -- Issue a savepoint
378 --
379 savepoint UPDATE_CERTIFICATION;
380 l_effective_date := trunc(p_effective_date);
381
382
383 begin
384 ota_certification_bk2.update_certification_b
385 (p_effective_date => p_effective_date
386 ,p_certification_id => p_certification_id
387 ,p_object_version_number => p_object_version_number
388 ,p_name => p_name
389 ,p_public_flag => p_public_flag
390 ,p_initial_completion_date => p_initial_completion_date
391 ,p_initial_completion_duration => p_initial_completion_duration
392 ,p_initial_compl_duration_units => p_initial_compl_duration_units
393 ,p_renewal_duration => p_renewal_duration
394 ,p_renewal_duration_units => p_renewal_duration_units
395 ,p_notify_days_before_expire => p_notify_days_before_expire
396 ,p_start_date_active => p_start_date_active
397 ,p_end_date_active => p_end_date_active
398 ,p_description => p_description
399 ,p_objectives => p_objectives
400 ,p_purpose => p_purpose
401 ,p_keywords => p_keywords
402 ,p_end_date_comments => p_end_date_comments
403 ,p_initial_period_comments => p_initial_period_comments
404 ,p_renewal_period_comments => p_renewal_period_comments
405 ,p_attribute_category => p_attribute_category
406 ,p_attribute1 => p_attribute1
407 ,p_attribute2 => p_attribute2
408 ,p_attribute3 => p_attribute3
409 ,p_attribute4 => p_attribute4
410 ,p_attribute5 => p_attribute5
411 ,p_attribute6 => p_attribute6
412 ,p_attribute7 => p_attribute7
413 ,p_attribute8 => p_attribute8
414 ,p_attribute9 => p_attribute9
415 ,p_attribute10 => p_attribute10
416 ,p_attribute11 => p_attribute11
417 ,p_attribute12 => p_attribute12
418 ,p_attribute13 => p_attribute13
419 ,p_attribute14 => p_attribute14
420 ,p_attribute15 => p_attribute15
421 ,p_attribute16 => p_attribute16
422 ,p_attribute17 => p_attribute17
423 ,p_attribute18 => p_attribute18
424 ,p_attribute19 => p_attribute19
425 ,p_attribute20 => p_attribute20
426 ,p_business_group_id => p_business_group_id
427 ,p_VALIDITY_DURATION => p_VALIDITY_DURATION
428 ,p_VALIDITY_DURATION_UNITS => p_VALIDITY_DURATION_UNITS
429 ,p_RENEWABLE_FLAG => p_RENEWABLE_FLAG
430 ,p_VALIDITY_START_TYPE => p_VALIDITY_START_TYPE
431 ,p_COMPETENCY_UPDATE_LEVEL => p_COMPETENCY_UPDATE_LEVEL
432 ,p_validate => p_validate
433 );
434 exception
435 when hr_api.cannot_find_prog_unit then
436 hr_api.cannot_find_prog_unit_error
437 (p_module_name => 'UDPATE_CERTIFICATION'
438 ,p_hook_type => 'BP'
439 );
440 end;
441
442 --
443 -- Process Logic
444 --
445 ota_crt_upd.upd
446 (p_effective_date => p_effective_date
447 ,p_business_group_id => p_business_group_id
448 ,p_public_flag => p_public_flag
449 ,p_initial_completion_date => p_initial_completion_date
450 ,p_initial_completion_duration => p_initial_completion_duration
451 ,p_initial_compl_duration_units => p_initial_compl_duration_units
452 ,p_renewal_duration => p_renewal_duration
453 ,p_renewal_duration_units => p_renewal_duration_units
454 ,p_notify_days_before_expire => p_notify_days_before_expire
455 ,p_start_date_active => p_start_date_active
456 ,p_end_date_active => p_end_date_active
457 ,p_attribute_category => p_attribute_category
458 ,p_attribute1 => p_attribute1
459 ,p_attribute2 => p_attribute2
460 ,p_attribute3 => p_attribute3
461 ,p_attribute4 => p_attribute4
462 ,p_attribute5 => p_attribute5
463 ,p_attribute6 => p_attribute6
464 ,p_attribute7 => p_attribute7
468 ,p_attribute11 => p_attribute11
465 ,p_attribute8 => p_attribute8
466 ,p_attribute9 => p_attribute9
467 ,p_attribute10 => p_attribute10
469 ,p_attribute12 => p_attribute12
470 ,p_attribute13 => p_attribute13
471 ,p_attribute14 => p_attribute14
472 ,p_attribute15 => p_attribute15
473 ,p_attribute16 => p_attribute16
474 ,p_attribute17 => p_attribute17
475 ,p_attribute18 => p_attribute18
476 ,p_attribute19 => p_attribute19
477 ,p_attribute20 => p_attribute20
478 ,p_VALIDITY_DURATION => p_VALIDITY_DURATION
479 ,p_VALIDITY_DURATION_UNITS => p_VALIDITY_DURATION_UNITS
480 ,p_RENEWABLE_FLAG => p_RENEWABLE_FLAG
481 ,p_VALIDITY_START_TYPE => p_VALIDITY_START_TYPE
482 ,p_COMPETENCY_UPDATE_LEVEL => p_COMPETENCY_UPDATE_LEVEL
483 ,p_certification_id => p_certification_id
484 ,p_object_version_number => p_object_version_number
485 );
486
487
488 ota_ctl_upd.upd_tl
489 (
490 p_effective_date => p_effective_date
491 ,p_language_code => USERENV('LANG')
492 ,p_certification_id => p_certification_id
493 ,p_name => rtrim(p_name)
494 ,p_description => p_description
495 ,p_objectives => p_objectives
496 ,p_purpose => p_purpose
497 ,p_keywords => p_keywords
498 ,p_end_date_comments => p_end_date_comments
499 ,p_initial_period_comments => p_initial_period_comments
500 ,p_renewal_period_comments => p_renewal_period_comments
501 );
502
503
504 begin
505 ota_certification_bk2.update_certification_a
506 (p_effective_date => p_effective_date
507 ,p_certification_id => p_certification_id
508 ,p_object_version_number => p_object_version_number
509 ,p_name => p_name
510 ,p_public_flag => p_public_flag
511 ,p_initial_completion_date => p_initial_completion_date
512 ,p_initial_completion_duration => p_initial_completion_duration
513 ,p_initial_compl_duration_units => p_initial_compl_duration_units
514 ,p_renewal_duration => p_renewal_duration
515 ,p_renewal_duration_units => p_renewal_duration_units
516 ,p_notify_days_before_expire => p_notify_days_before_expire
517 ,p_start_date_active => p_start_date_active
518 ,p_end_date_active => p_end_date_active
519 ,p_description => p_description
520 ,p_objectives => p_objectives
521 ,p_purpose => p_purpose
522 ,p_keywords => p_keywords
523 ,p_end_date_comments => p_end_date_comments
524 ,p_initial_period_comments => p_initial_period_comments
525 ,p_renewal_period_comments => p_renewal_period_comments
526 ,p_attribute_category => p_attribute_category
527 ,p_attribute1 => p_attribute1
528 ,p_attribute2 => p_attribute2
529 ,p_attribute3 => p_attribute3
530 ,p_attribute4 => p_attribute4
531 ,p_attribute5 => p_attribute5
532 ,p_attribute6 => p_attribute6
533 ,p_attribute7 => p_attribute7
534 ,p_attribute8 => p_attribute8
535 ,p_attribute9 => p_attribute9
536 ,p_attribute10 => p_attribute10
537 ,p_attribute11 => p_attribute11
538 ,p_attribute12 => p_attribute12
539 ,p_attribute13 => p_attribute13
540 ,p_attribute14 => p_attribute14
541 ,p_attribute15 => p_attribute15
542 ,p_attribute16 => p_attribute16
543 ,p_attribute17 => p_attribute17
544 ,p_attribute18 => p_attribute18
545 ,p_attribute19 => p_attribute19
546 ,p_attribute20 => p_attribute20
547 ,p_business_group_id => p_business_group_id
548 ,p_VALIDITY_DURATION => p_VALIDITY_DURATION
549 ,p_VALIDITY_DURATION_UNITS => p_VALIDITY_DURATION_UNITS
550 ,p_RENEWABLE_FLAG => p_RENEWABLE_FLAG
551 ,p_VALIDITY_START_TYPE => p_VALIDITY_START_TYPE
552 ,p_COMPETENCY_UPDATE_LEVEL => p_COMPETENCY_UPDATE_LEVEL
553 ,p_validate => p_validate
554 );
555 exception
556 when hr_api.cannot_find_prog_unit then
557 hr_api.cannot_find_prog_unit_error
558 (p_module_name => 'UPDATE_CERTIFICATION'
559 ,p_hook_type => 'AP'
560 );
561 end;
562
563 --
564 -- When in validation only mode raise the Validate_Enabled exception
565 --
566 if p_validate then
567 raise hr_api.validate_enabled;
568 end if;
569
570 hr_utility.set_location(' Leaving:'||l_proc, 70);
571 exception
572 when hr_api.validate_enabled then
573 --
574 -- As the Validate_Enabled exception has been raised
575 -- we must rollback to the savepoint
576 --
577 rollback to UPDATE_CERTIFICATION;
578 --
579 -- Only set output warning arguments
580 -- (Any key or derived arguments must be set to null
581 -- when validation only mode is being used.)
582 --
583 p_object_version_number := null;
584 hr_utility.set_location(' Leaving:'||l_proc, 80);
585 when others then
586 --
587 -- A validation or unexpected error has occured
591 hr_utility.set_location(' Leaving:'||l_proc, 90);
588 --
589 rollback to UPDATE_CERTIFICATION;
590 p_object_version_number := null;
592 raise;
593 end update_certification;
594
595 --
596 -- ----------------------------------------------------------------------------
597 -- |-------------------------< DELETE_CERTIFICATION >-------------------|
598 -- ----------------------------------------------------------------------------
599 --
600 procedure delete_certification
601 (
602 p_certification_id in number,
603 p_object_version_number in number,
604 p_validate in boolean
605 ) is
606 --
607 -- Declare cursors and local variables
608 --
609 l_proc varchar2(72) := g_package||' Delete Certification';
610 --
611 --
612 begin
613 hr_utility.set_location('Entering:'|| l_proc, 10);
614 --
615 -- Issue a savepoint
616 --
617 savepoint DELETE_CERTIFICATION;
618 --
619 -- Truncate the time portion from all IN date parameters
620 --
621 --
622
623 begin
624 ota_certification_bk3.delete_certification_b
625 (p_certification_id => p_certification_id
626 ,p_object_version_number => p_object_version_number
627 );
628 exception
629 when hr_api.cannot_find_prog_unit then
630 hr_api.cannot_find_prog_unit_error
631 (p_module_name => 'DELETE_CERTIFICATION'
632 ,p_hook_type => 'BP'
633 );
634 end;
635
636 --
637 -- Process Logic
638 --
639 ota_ctl_del.del_tl
640 (p_certification_id => p_certification_id
641 );
642
643 ota_crt_del.del
644 (
645 p_certification_id => p_certification_id ,
646 p_object_version_number => p_object_version_number
647 );
648 begin
649 ota_certification_bk3.delete_certification_a
650 (p_certification_id => p_certification_id
651 ,p_object_version_number => p_object_version_number
652 );
653 exception
654 when hr_api.cannot_find_prog_unit then
655 hr_api.cannot_find_prog_unit_error
656 (p_module_name => 'DELETE_CERTIFICATION'
657 ,p_hook_type => 'AP'
658 );
659 end;
660
661 --
662 -- When in validation only mode raise the Validate_Enabled exception
663 --
664 if p_validate then
665 raise hr_api.validate_enabled;
666 end if;
667 --
668 -- Set all output arguments
669 --
670 --
671 hr_utility.set_location(' Leaving:'||l_proc, 170);
672 exception
673 when hr_api.validate_enabled then
674 --
675 -- As the Validate_Enabled exception has been raised
676 -- we must rollback to the savepoint
677 --
678 rollback to DELETE_CERTIFICATION;
679 hr_utility.set_location(' Leaving:'||l_proc, 190);
680 raise;
681 end delete_certification;
682 --
683 end ota_certification_api;