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