[Home] [Help]
PACKAGE BODY: APPS.HR_OBJECTIVE_LIBRARY_SWI
Source
1 Package Body hr_objective_library_swi As
2 /* $Header: pepmlswi.pkb 120.4.12010000.2 2008/11/24 14:51:46 rsykam ship $ */
3 --
4 -- Package variables
5 --
6 g_package varchar2(33) := 'hr_objective_library_swi.';
7
8 --
9 -- ----------------------------------------------------------------------------
10 -- |-----------------------< create_library_objective >-----------------------|
11 -- ----------------------------------------------------------------------------
12 PROCEDURE create_library_objective
13 (p_validate in number default hr_api.g_false_num
14 ,p_effective_date in date
15 ,p_objective_name in varchar2
16 ,p_valid_from in date default null
17 ,p_valid_to in date default null
18 ,p_target_date in date default null
19 ,p_next_review_date in date default null
20 ,p_group_code in varchar2 default null
21 ,p_priority_code in varchar2 default null
22 ,p_appraise_flag in varchar2 default 'Y'
23 ,p_weighting_percent in number default null
24 ,p_measurement_style_code in varchar2 default 'N_M'
25 ,p_measure_name in varchar2 default null
26 ,p_target_value in number default null
27 ,p_uom_code in varchar2 default null
28 ,p_measure_type_code in varchar2 default null
29 ,p_measure_comments in varchar2 default null
30 ,p_eligibility_type_code in varchar2 default 'N_P'
31 ,p_details in varchar2 default null
32 ,p_success_criteria in varchar2 default null
33 ,p_comments in varchar2 default null
34 ,p_attribute_category in varchar2 default null
35 ,p_attribute1 in varchar2 default null
36 ,p_attribute2 in varchar2 default null
37 ,p_attribute3 in varchar2 default null
38 ,p_attribute4 in varchar2 default null
39 ,p_attribute5 in varchar2 default null
40 ,p_attribute6 in varchar2 default null
41 ,p_attribute7 in varchar2 default null
42 ,p_attribute8 in varchar2 default null
43 ,p_attribute9 in varchar2 default null
44 ,p_attribute10 in varchar2 default null
45 ,p_attribute11 in varchar2 default null
46 ,p_attribute12 in varchar2 default null
47 ,p_attribute13 in varchar2 default null
48 ,p_attribute14 in varchar2 default null
49 ,p_attribute15 in varchar2 default null
50 ,p_attribute16 in varchar2 default null
51 ,p_attribute17 in varchar2 default null
52 ,p_attribute18 in varchar2 default null
53 ,p_attribute19 in varchar2 default null
54 ,p_attribute20 in varchar2 default null
55 ,p_attribute21 in varchar2 default null
56 ,p_attribute22 in varchar2 default null
57 ,p_attribute23 in varchar2 default null
58 ,p_attribute24 in varchar2 default null
59 ,p_attribute25 in varchar2 default null
60 ,p_attribute26 in varchar2 default null
61 ,p_attribute27 in varchar2 default null
62 ,p_attribute28 in varchar2 default null
63 ,p_attribute29 in varchar2 default null
64 ,p_attribute30 in varchar2 default null
65 ,p_objective_id in out nocopy number
66 ,p_object_version_number out nocopy number
67 ,p_return_status out nocopy varchar2
68 ) is
69 --
70 -- Variables for API Boolean parameters
71 l_validate boolean;
72 l_duplicate_name_warning boolean;
73 l_weighting_over_100_warning boolean;
74 l_weighting_appraisal_warning boolean;
75 l_objective_id number := 0;
76 --
77 -- Variables for IN/OUT parameters
78 --
79 -- Other variables
80 l_proc varchar2(72) := g_package ||'create_library_objective';
81 Begin
82 hr_utility.set_location(' Entering:' || l_proc,10);
83 --
84 -- Issue a savepoint
85 --
86 savepoint create_library_objective_swi;
87 --
88 -- Initialise Multiple Message Detection
89 --
90 hr_multi_message.enable_message_list;
91 --
92 -- Remember IN OUT parameter IN values
93 --
94 --
95 --
96 -- Convert constant values to their corresponding boolean value
97 --
98 l_validate :=
99 hr_api.constant_to_boolean
100 (p_constant_value => p_validate);
101 --
102 -- Register Surrogate ID or user key values
103 --
104
105 per_pml_ins.set_base_key_value
106 (p_objective_id => p_objective_id
107 );
108
109 --
110 -- Call API
111 --
112 hr_objective_library_api.create_library_objective
113 (p_validate => l_validate
114 ,p_effective_date => p_effective_date
115 ,p_objective_name => p_objective_name
116 ,p_valid_from => p_valid_from
117 ,p_valid_to => p_valid_to
118 ,p_target_date => p_target_date
119 ,p_next_review_date => p_next_review_date
120 ,p_group_code => p_group_code
121 ,p_priority_code => p_priority_code
122 ,p_appraise_flag => p_appraise_flag
123 ,p_weighting_percent => p_weighting_percent
124 ,p_measurement_style_code => p_measurement_style_code
125 ,p_measure_name => p_measure_name
126 ,p_target_value => p_target_value
127 ,p_uom_code => p_uom_code
128 ,p_measure_type_code => p_measure_type_code
129 ,p_measure_comments => p_measure_comments
130 ,p_eligibility_type_code => p_eligibility_type_code
131 ,p_details => p_details
132 ,p_success_criteria => p_success_criteria
133 ,p_comments => p_comments
134 ,p_attribute_category => p_attribute_category
135 ,p_attribute1 => p_attribute1
136 ,p_attribute2 => p_attribute2
137 ,p_attribute3 => p_attribute3
138 ,p_attribute4 => p_attribute4
139 ,p_attribute5 => p_attribute5
140 ,p_attribute6 => p_attribute6
141 ,p_attribute7 => p_attribute7
142 ,p_attribute8 => p_attribute8
143 ,p_attribute9 => p_attribute9
144 ,p_attribute10 => p_attribute10
145 ,p_attribute11 => p_attribute11
146 ,p_attribute12 => p_attribute12
147 ,p_attribute13 => p_attribute13
148 ,p_attribute14 => p_attribute14
149 ,p_attribute15 => p_attribute15
150 ,p_attribute16 => p_attribute16
151 ,p_attribute17 => p_attribute17
152 ,p_attribute18 => p_attribute18
153 ,p_attribute19 => p_attribute19
154 ,p_attribute20 => p_attribute20
155 ,p_attribute21 => p_attribute21
156 ,p_attribute22 => p_attribute22
157 ,p_attribute23 => p_attribute23
158 ,p_attribute24 => p_attribute24
159 ,p_attribute25 => p_attribute25
160 ,p_attribute26 => p_attribute26
161 ,p_attribute27 => p_attribute27
162 ,p_attribute28 => p_attribute28
163 ,p_attribute29 => p_attribute29
164 ,p_attribute30 => p_attribute30
165 ,p_objective_id => p_objective_id
166 ,p_object_version_number => p_object_version_number
167 ,p_duplicate_name_warning => l_duplicate_name_warning
168 ,p_weighting_over_100_warning => l_weighting_over_100_warning
169 ,p_weighting_appraisal_warning => l_weighting_appraisal_warning
170 );
171 --
172 p_return_status := hr_multi_message.get_return_status;
173 --
174 -- Convert API warning boolean parameter values to specific
175 -- messages and add them to Multiple Message List
176 --
177 if(p_return_status ='S')then
178 if l_duplicate_name_warning then
179 fnd_message.set_name('PER', 'HR_50181_WPM_OBJ_EXIST_WARN');
180 hr_multi_message.add
181 (p_message_type => hr_multi_message.g_warning_msg
182 );
183 p_return_status:='W';
184 end if;
185 if l_weighting_over_100_warning then
186 fnd_message.set_name('PER', 'HR_50198_WPM_WEIGHT_WARN');
187 hr_multi_message.add
188 (p_message_type => hr_multi_message.g_warning_msg
189 );
190 p_return_status:='W';
191
192 end if;
193 if l_weighting_appraisal_warning then
194 fnd_message.set_name('PER', 'HR_50223_WPM_APPRAISE_WARN');
195 hr_multi_message.add
196 (p_message_type => hr_multi_message.g_warning_msg
197 );
198 p_return_status:='W';
199 end if; --
200 end if;
201 --
202 --
203 hr_multi_message.disable_message_list;
204 -- Convert API non-warning boolean parameter values
205 --
206 --
207 -- Derive the API return status value based on whether
208 -- messages of any type exist in the Multiple Message List.
209 -- Also disable Multiple Message Detection.
210 hr_utility.set_location(' Leaving:' || l_proc,20);
211 --
212 exception
213 when hr_multi_message.error_message_exist then
214 --
215 -- Catch the Multiple Message List exception which
216 -- indicates API processing has been aborted because
217 -- at least one message exists in the list.
218 --
219 rollback to create_library_objective_swi;
220 --
221 -- Reset IN OUT parameters and set OUT parameters
222 --
223 -- p_objective_id := null;
224 p_object_version_number := null;
225 p_return_status := hr_multi_message.get_return_status_disable;
226 hr_utility.set_location(' Leaving:' || l_proc, 30);
227 when others then
228 --
229 -- When Multiple Message Detection is enabled catch
230 -- any Application specific or other unexpected
231 -- exceptions. Adding appropriate details to the
232 -- Multiple Message List. Otherwise re-raise the
233 -- error.
234 --
235 rollback to create_library_objective_swi;
236 p_return_status := hr_multi_message.get_return_status_disable;
237 if p_return_status<>'E' and hr_multi_message.unexpected_error_add(l_proc) then
238 hr_utility.set_location(' Leaving:' || l_proc,40);
239 raise;
240 end if;
241 --
242 -- Reset IN OUT and set OUT parameters
243 --
244 -- p_objective_id := null;
245 p_object_version_number := null;
246 hr_utility.set_location(' Leaving:' || l_proc,50);
247 end create_library_objective;
248 -- ----------------------------------------------------------------------------
249 -- |-----------------------< delete_library_objective >-----------------------|
250 -- ----------------------------------------------------------------------------
251 PROCEDURE delete_library_objective
252 (p_validate in number default hr_api.g_false_num
253 ,p_objective_id in number
254 ,p_object_version_number in number
255 ,p_return_status out nocopy varchar2
256 ) is
257 --
258 -- Variables for API Boolean parameters
259 l_validate boolean;
260 --
261 -- Variables for IN/OUT parameters
262 --
263 -- Other variables
264 l_proc varchar2(72) := g_package ||'delete_library_objective';
265 Begin
266 hr_utility.set_location(' Entering:' || l_proc,10);
267 --
268 -- Issue a savepoint
269 --
270 savepoint delete_library_objective_swi;
271 --
272 -- Initialise Multiple Message Detection
273 --
274 hr_multi_message.enable_message_list;
275 --
276 -- Remember IN OUT parameter IN values
277 --
278 --
279 -- Convert constant values to their corresponding boolean value
280 --
281 l_validate :=
282 hr_api.constant_to_boolean
283 (p_constant_value => p_validate);
284 --
285 -- Register Surrogate ID or user key values
286 --
287 --
288 -- Call API
289 --
290 hr_objective_library_api.delete_library_objective
291 (p_validate => l_validate
292 ,p_objective_id => p_objective_id
293 ,p_object_version_number => p_object_version_number
294 );
295 --
296 -- Convert API warning boolean parameter values to specific
297 -- messages and add them to Multiple Message List
298 --
299 --
300 -- Convert API non-warning boolean parameter values
301 --
302 --
303 -- Derive the API return status value based on whether
304 -- messages of any type exist in the Multiple Message List.
305 -- Also disable Multiple Message Detection.
306 --
307 p_return_status := hr_multi_message.get_return_status_disable;
308 hr_utility.set_location(' Leaving:' || l_proc,20);
309 --
310 exception
311 when hr_multi_message.error_message_exist then
312 --
313 -- Catch the Multiple Message List exception which
314 -- indicates API processing has been aborted because
315 -- at least one message exists in the list.
316 --
317 rollback to delete_library_objective_swi;
318 --
319 -- Reset IN OUT parameters and set OUT parameters
320 --
321 p_return_status := hr_multi_message.get_return_status_disable;
322 hr_utility.set_location(' Leaving:' || l_proc, 30);
323 when others then
324 --
325 -- When Multiple Message Detection is enabled catch
326 -- any Application specific or other unexpected
327 -- exceptions. Adding appropriate details to the
328 -- Multiple Message List. Otherwise re-raise the
329 -- error.
330 --
331 rollback to delete_library_objective_swi;
332 if hr_multi_message.unexpected_error_add(l_proc) then
333 hr_utility.set_location(' Leaving:' || l_proc,40);
334 raise;
335 end if;
336 --
337 -- Reset IN OUT and set OUT parameters
338 --
339 p_return_status := hr_multi_message.get_return_status_disable;
340 hr_utility.set_location(' Leaving:' || l_proc,50);
341 end delete_library_objective;
342 -- ----------------------------------------------------------------------------
343 -- |-----------------------< update_library_objective >-----------------------|
344 -- ----------------------------------------------------------------------------
345 PROCEDURE update_library_objective
346 (p_validate in number default hr_api.g_false_num
347 ,p_effective_date in date
348 ,p_objective_id in number
349 ,p_objective_name in varchar2 default hr_api.g_varchar2
350 ,p_valid_from in date default hr_api.g_date
351 ,p_valid_to in date default hr_api.g_date
352 ,p_target_date in date default hr_api.g_date
353 ,p_next_review_date in date default hr_api.g_date
354 ,p_group_code in varchar2 default hr_api.g_varchar2
355 ,p_priority_code in varchar2 default hr_api.g_varchar2
356 ,p_appraise_flag in varchar2 default hr_api.g_varchar2
357 ,p_weighting_percent in number default hr_api.g_number
358 ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
359 ,p_measure_name in varchar2 default hr_api.g_varchar2
360 ,p_target_value in number default hr_api.g_number
361 ,p_uom_code in varchar2 default hr_api.g_varchar2
362 ,p_measure_type_code in varchar2 default hr_api.g_varchar2
363 ,p_measure_comments in varchar2 default hr_api.g_varchar2
364 ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
365 ,p_details in varchar2 default hr_api.g_varchar2
366 ,p_success_criteria in varchar2 default hr_api.g_varchar2
367 ,p_comments in varchar2 default hr_api.g_varchar2
368 ,p_attribute_category in varchar2 default hr_api.g_varchar2
369 ,p_attribute1 in varchar2 default hr_api.g_varchar2
370 ,p_attribute2 in varchar2 default hr_api.g_varchar2
371 ,p_attribute3 in varchar2 default hr_api.g_varchar2
372 ,p_attribute4 in varchar2 default hr_api.g_varchar2
373 ,p_attribute5 in varchar2 default hr_api.g_varchar2
374 ,p_attribute6 in varchar2 default hr_api.g_varchar2
375 ,p_attribute7 in varchar2 default hr_api.g_varchar2
376 ,p_attribute8 in varchar2 default hr_api.g_varchar2
377 ,p_attribute9 in varchar2 default hr_api.g_varchar2
378 ,p_attribute10 in varchar2 default hr_api.g_varchar2
379 ,p_attribute11 in varchar2 default hr_api.g_varchar2
380 ,p_attribute12 in varchar2 default hr_api.g_varchar2
381 ,p_attribute13 in varchar2 default hr_api.g_varchar2
382 ,p_attribute14 in varchar2 default hr_api.g_varchar2
383 ,p_attribute15 in varchar2 default hr_api.g_varchar2
384 ,p_attribute16 in varchar2 default hr_api.g_varchar2
385 ,p_attribute17 in varchar2 default hr_api.g_varchar2
386 ,p_attribute18 in varchar2 default hr_api.g_varchar2
387 ,p_attribute19 in varchar2 default hr_api.g_varchar2
388 ,p_attribute20 in varchar2 default hr_api.g_varchar2
389 ,p_attribute21 in varchar2 default hr_api.g_varchar2
390 ,p_attribute22 in varchar2 default hr_api.g_varchar2
391 ,p_attribute23 in varchar2 default hr_api.g_varchar2
392 ,p_attribute24 in varchar2 default hr_api.g_varchar2
393 ,p_attribute25 in varchar2 default hr_api.g_varchar2
394 ,p_attribute26 in varchar2 default hr_api.g_varchar2
395 ,p_attribute27 in varchar2 default hr_api.g_varchar2
396 ,p_attribute28 in varchar2 default hr_api.g_varchar2
397 ,p_attribute29 in varchar2 default hr_api.g_varchar2
398 ,p_attribute30 in varchar2 default hr_api.g_varchar2
399 ,p_object_version_number in out nocopy number
400 ,p_return_status out nocopy varchar2
401 ) is
402 --
403 -- Variables for API Boolean parameters
404 l_validate boolean;
405 l_duplicate_name_warning boolean;
406 l_weighting_over_100_warning boolean;
407 l_weighting_appraisal_warning boolean;
408 --
409 -- Variables for IN/OUT parameters
410 l_object_version_number number;
411 --
412 -- Other variables
413 l_proc varchar2(72) := g_package ||'update_library_objective';
414 Begin
415 hr_utility.set_location(' Entering:' || l_proc,10);
416 --
417 -- Issue a savepoint
418 --
419 savepoint update_library_objective_swi;
420 --
421 -- Initialise Multiple Message Detection
422 --
423 hr_multi_message.enable_message_list;
424 --
425 -- Remember IN OUT parameter IN values
426 --
427 l_object_version_number := p_object_version_number;
428 --
429 -- Convert constant values to their corresponding boolean value
430 --
431 l_validate :=
432 hr_api.constant_to_boolean
433 (p_constant_value => p_validate);
434 --
435 -- Register Surrogate ID or user key values
436 --
437 --
438 -- Call API
439 --
440 hr_objective_library_api.update_library_objective
441 (p_validate => l_validate
442 ,p_effective_date => p_effective_date
443 ,p_objective_id => p_objective_id
444 ,p_objective_name => p_objective_name
445 ,p_valid_from => p_valid_from
446 ,p_valid_to => p_valid_to
447 ,p_target_date => p_target_date
448 ,p_next_review_date => p_next_review_date
449 ,p_group_code => p_group_code
450 ,p_priority_code => p_priority_code
451 ,p_appraise_flag => p_appraise_flag
452 ,p_weighting_percent => p_weighting_percent
453 ,p_measurement_style_code => p_measurement_style_code
454 ,p_measure_name => p_measure_name
455 ,p_target_value => p_target_value
456 ,p_uom_code => p_uom_code
457 ,p_measure_type_code => p_measure_type_code
458 ,p_measure_comments => p_measure_comments
459 ,p_eligibility_type_code => p_eligibility_type_code
460 ,p_details => p_details
461 ,p_success_criteria => p_success_criteria
462 ,p_comments => p_comments
463 ,p_attribute_category => p_attribute_category
464 ,p_attribute1 => p_attribute1
465 ,p_attribute2 => p_attribute2
466 ,p_attribute3 => p_attribute3
467 ,p_attribute4 => p_attribute4
468 ,p_attribute5 => p_attribute5
469 ,p_attribute6 => p_attribute6
470 ,p_attribute7 => p_attribute7
471 ,p_attribute8 => p_attribute8
472 ,p_attribute9 => p_attribute9
473 ,p_attribute10 => p_attribute10
474 ,p_attribute11 => p_attribute11
475 ,p_attribute12 => p_attribute12
476 ,p_attribute13 => p_attribute13
477 ,p_attribute14 => p_attribute14
478 ,p_attribute15 => p_attribute15
479 ,p_attribute16 => p_attribute16
480 ,p_attribute17 => p_attribute17
481 ,p_attribute18 => p_attribute18
482 ,p_attribute19 => p_attribute19
483 ,p_attribute20 => p_attribute20
484 ,p_attribute21 => p_attribute21
485 ,p_attribute22 => p_attribute22
486 ,p_attribute23 => p_attribute23
487 ,p_attribute24 => p_attribute24
488 ,p_attribute25 => p_attribute25
489 ,p_attribute26 => p_attribute26
490 ,p_attribute27 => p_attribute27
491 ,p_attribute28 => p_attribute28
492 ,p_attribute29 => p_attribute29
493 ,p_attribute30 => p_attribute30
494 ,p_object_version_number => p_object_version_number
495 ,p_duplicate_name_warning => l_duplicate_name_warning
496 ,p_weighting_over_100_warning => l_weighting_over_100_warning
497 ,p_weighting_appraisal_warning => l_weighting_appraisal_warning
498 );
499 --
500 p_return_status:=hr_multi_message.get_return_status;
501 --
502 -- Convert API warning boolean parameter values to specific
503 -- messages and add them to Multiple Message List
504 --
505 if(p_return_status ='S')then
506 if l_duplicate_name_warning then
507 fnd_message.set_name('PER', 'HR_50181_WPM_OBJ_EXIST_WARN');
508 hr_multi_message.add
509 (p_message_type => hr_multi_message.g_warning_msg
510 );
511 p_return_status:='W';
512 end if;
513 if l_weighting_over_100_warning then
514 fnd_message.set_name('PER', 'HR_50198_WPM_WEIGHT_WARN');
515 hr_multi_message.add
516 (p_message_type => hr_multi_message.g_warning_msg
517 );
518 p_return_status:='W';
519 end if;
520 if l_weighting_appraisal_warning then
521 fnd_message.set_name('PER', 'HR_50223_WPM_APPRAISE_WARN');
522 hr_multi_message.add
523 (p_message_type => hr_multi_message.g_warning_msg
524 );
525 p_return_status:='W';
526 end if; --
527 end if;
528 -- Convert API non-warning boolean parameter values
529 --
530 --
531 -- Derive the API return status value based on whether
532 -- messages of any type exist in the Multiple Message List.
533 -- Also disable Multiple Message Detection.
534 --
535 hr_multi_message.disable_message_list;
536 hr_utility.set_location(' Leaving:' || l_proc,20);
537 --
538 exception
539 when hr_multi_message.error_message_exist then
540 --
541 -- Catch the Multiple Message List exception which
542 -- indicates API processing has been aborted because
543 -- at least one message exists in the list.
544 --
545 rollback to update_library_objective_swi;
546 --
547 -- Reset IN OUT parameters and set OUT parameters
548 --
549 p_object_version_number := l_object_version_number;
550 p_return_status := hr_multi_message.get_return_status_disable;
551 hr_utility.set_location(' Leaving:' || l_proc, 30);
552 when others then
553 --
554 -- When Multiple Message Detection is enabled catch
555 -- any Application specific or other unexpected
556 -- exceptions. Adding appropriate details to the
557 -- Multiple Message List. Otherwise re-raise the
558 -- error.
559 --
560 rollback to update_library_objective_swi;
561 p_return_status := hr_multi_message.get_return_status_disable;
562 if p_return_status<>'E' and hr_multi_message.unexpected_error_add(l_proc) then
563 hr_utility.set_location(' Leaving:' || l_proc,40);
564 raise;
565 end if;
566 --
567 -- Reset IN OUT and set OUT parameters
568 --
569 p_object_version_number := l_object_version_number;
570
571 hr_utility.set_location(' Leaving:' || l_proc,50);
572 end update_library_objective;
573 --
574 -- ----------------------------------------------------------------------------
575 -- |-------------------------< create_eligy_profile >-------------------------|
576 -- ----------------------------------------------------------------------------
577 -- {Start Of Comments}
578 --
579 -- Description:
580 --
581 --
582 -- Prerequisites:
583 --
584 --
585 -- In Parameters:
586 -- Name Reqd Type Description
587 -- p_validate Yes boolean Commit or Rollback.
588 -- p_name Yes varchar2
589 -- p_elig_pstn_flag No varchar2
590 -- p_elig_grd_flag No varchar2
591 -- p_elig_org_unit_flag No varchar2
592 -- p_elig_job_flag No varchar2
593 --
594 -- Post Success:
595 --
596 -- Out Parameters:
597 -- Name Reqd Type Description
598 -- p_eligy_prfl_id Yes number PK of record
599 --
600 -- Post Failure:
601 --
602 --
603 -- Access Status:
604 -- Public.
605 --
606 -- {End Of Comments}
607 --
608
609 procedure create_eligy_profile
610 (p_validate in number default hr_api.g_false_num
611 ,p_name in varchar2 default null
612 ,p_bnft_cagr_prtn_cd in varchar2 default null
613 ,p_stat_cd in varchar2 default null
614 ,p_asmt_to_use_cd in varchar2 default null
615 ,p_eligy_prfl_id in out nocopy number
616 ,p_elig_grd_flag in varchar2 default 'N'
617 ,p_elig_org_unit_flag in varchar2 default 'N'
618 ,p_elig_job_flag in varchar2 default 'N'
619 ,p_elig_pstn_flag in varchar2 default 'N'
620 ,p_object_version_number out nocopy number
621 ,p_business_group_id in number
622 ,p_effective_date in date
623 ,p_effective_start_date out nocopy date
624 ,p_effective_end_date out nocopy date
625 ,p_return_status out nocopy varchar2
626 ) is
627
628 --
629 -- Variables for API Boolean parameters
630 l_validate boolean;
631 --
632 -- Other variables
633 l_proc varchar2(72) := g_package ||'create_eligy_profile';
634 l_eligy_prfl_id number;
635 msgName varchar2(100);
636 begin
637 hr_utility.set_location(' Entering:' || l_proc,10);
638 --
639 -- Issue a savepoint
640 --
641 savepoint create_eligy_profile_swi;
642 --
643 -- Initialise Multiple Message Detection
644 --
645 hr_multi_message.enable_message_list;
646 --
647 -- Remember IN OUT parameter IN values
648 --
649 --
650 -- Convert constant values to their corresponding boolean value
651 --
652 l_validate :=
653 hr_api.constant_to_boolean
654 (p_constant_value => p_validate);
655 --
656 -- Register Surrogate ID or user key values
657 --
658 ben_elp_ins.set_base_key_value(p_eligy_prfl_id => p_eligy_prfl_id);
659 --
660 -- Call API
661 --
662
663 hr_objective_library_api.create_eligy_profile
664 (p_validate => l_validate
665 ,p_name => p_name
666 ,p_bnft_cagr_prtn_cd => p_bnft_cagr_prtn_cd
667 ,p_stat_cd => p_stat_cd
668 ,p_asmt_to_use_cd => p_asmt_to_use_cd
669 ,p_eligy_prfl_id => l_eligy_prfl_id
670 ,p_elig_grd_flag => p_elig_grd_flag
671 ,p_elig_org_unit_flag => p_elig_org_unit_flag
672 ,p_elig_job_flag => p_elig_job_flag
673 ,p_elig_pstn_flag => p_elig_pstn_flag
674 ,p_object_version_number => p_object_version_number
675 ,p_business_group_id => p_business_group_id
676 ,p_effective_date => p_effective_date
677 ,p_effective_start_date => p_effective_start_date
678 ,p_effective_end_date => p_effective_end_date
679 );
680
681 p_eligy_prfl_id := l_eligy_prfl_id;
682 p_return_status := hr_multi_message.get_return_status_disable;
683 hr_utility.set_location(' Leaving:' || l_proc,20);
684
685 exception
686 when hr_multi_message.error_message_exist then
687
688 --
689 -- Catch the Multiple Message List exception which
690 -- indicates API processing has been aborted because
691 -- at least one message exists in the list.
692 --
693 rollback to create_eligy_profile_swi;
694 --
695 -- Reset IN OUT parameters and set OUT parameters
696 --
697 p_eligy_prfl_id := null;
698 p_effective_start_date := null;
699 p_effective_end_date := null;
700 p_object_version_number := null;
701 p_return_status := hr_multi_message.get_return_status_disable;
702
703 when others then
704 -- Catch the Multiple Message List exception which
705 -- indicates API processing has been aborted because
706 -- at least one message exists in the list.
707 --
708 rollback to create_eligy_profile_swi;
709 --
710 -- Reset IN OUT parameters and set OUT parameters
711 --
712 if(fnd_message.get_number('BEN','BEN_91009_NAME_NOT_UNIQUE') <> null)then
713 fnd_message.set_name('PER', 'HR_51795_WPM_ELIGY_NAME_EXIST');
714 hr_multi_message.add
715 (p_message_type => hr_multi_message.G_ERROR_MSG
716 );
717 end if;
718
719 if hr_multi_message.unexpected_error_add(l_proc) then
720 hr_utility.set_location(' Leaving:' || l_proc,40);
721 raise;
722 end if;
723
724 p_effective_start_date := null;
725 p_effective_end_date := null;
726 p_object_version_number := null;
727 p_return_status := hr_multi_message.get_return_status_disable;
728 hr_utility.set_location(' Leaving:' || l_proc, 30);
729 end create_eligy_profile;
730 --
731 --
732 -- ----------------------------------------------------------------------------
733 -- |-------------------------< create_eligy_profile >-------------------------|
734 -- ----------------------------------------------------------------------------
735 -- {Start Of Comments}
736 --
737 -- Description:
738 --
739 --
740 -- Prerequisites:
741 --
742 --
743 -- In Parameters:
744 -- Name Reqd Type Description
745 -- Post Success:
746 --
747 -- Out Parameters:
748 -- Name Reqd Type Description
749 -- p_eligy_prfl_id Yes number PK of record
750 --
751 -- Post Failure:
752 --
753 --
754 -- Access Status:
755 -- Public.
756 --
757 -- {End Of Comments}
758 --
759 procedure update_eligy_profile
760 ( p_validate in number default hr_api.g_false_num
761 ,p_effective_date in date
762 ,p_business_group_id in number
763 ,p_name in varchar2 default null
764 ,p_bnft_cagr_prtn_cd in varchar2 default null
765 ,p_stat_cd in varchar2 default null
766 ,p_asmt_to_use_cd in varchar2 default null
767 ,p_elig_grd_flag in varchar2 default 'N'
768 ,p_elig_org_unit_flag in varchar2 default 'N'
769 ,p_elig_job_flag in varchar2 default 'N'
770 ,p_elig_pstn_flag in varchar2 default 'N'
771 ,p_eligy_prfl_id in number
772 ,p_object_version_number in out nocopy number
773 ,p_effective_start_date out nocopy date
774 ,p_effective_end_date out nocopy date
775 ,p_datetrack_mode in varchar2
776 ,p_return_status out nocopy varchar2
777 ) is
778 -- Variables for API Boolean parameters
779 l_validate boolean;
780 --
781 -- Other variables
782 l_proc varchar2(72) := g_package ||'update_eligy_position';
783
784 begin
785 hr_utility.set_location(' Entering:' || l_proc,10);
786 --
787 -- Issue a savepoint
788 --
789 savepoint update_eligy_profile_swi;
790 --
791 -- Initialise Multiple Message Detection
792 --
793 hr_multi_message.enable_message_list;
794 --
795 -- Remember IN OUT parameter IN values
796 --
797 --
798 -- Convert constant values to their corresponding boolean value
799 --
800 l_validate := hr_api.constant_to_boolean(p_constant_value => p_validate);
801 --
802 HR_OBJECTIVE_LIBRARY_api.update_eligy_profile
803 (
804 p_validate => l_validate
805 ,p_eligy_prfl_id => p_eligy_prfl_id
806 ,p_name => p_name
807 ,p_stat_cd => p_stat_cd
808 ,p_asmt_to_use_cd => p_asmt_to_use_cd
809 ,p_elig_grd_flag => p_elig_grd_flag
810 ,p_elig_org_unit_flag => p_elig_org_unit_flag
811 ,p_elig_job_flag => p_elig_job_flag
812 ,p_elig_pstn_flag => p_elig_pstn_flag
813 ,p_object_version_number => p_object_version_number
814 ,p_effective_start_date => p_effective_start_date
815 ,p_effective_end_date => p_effective_end_date
816 ,p_datetrack_mode => p_datetrack_mode
817 ,p_business_group_id => p_business_group_id
818 ,p_effective_date => p_effective_date
819 );
820
821 p_return_status := hr_multi_message.get_return_status_disable;
822 hr_utility.set_location(' Leaving:' || l_proc,20);
823 --
824 exception
825 when hr_multi_message.error_message_exist then
826 --
827 -- Catch the Multiple Message List exception which
828 -- indicates API processing has been aborted because
829 -- at least one message exists in the list.
830 --
831 rollback to update_eligy_profile_swi;
832 --
833 -- Reset IN OUT parameters and set OUT parameters
834 --
835 p_effective_start_date := null;
836 p_effective_end_date := null;
837 p_object_version_number := null;
838 p_return_status := hr_multi_message.get_return_status_disable;
839
840 when others then
841 -- Catch the Multiple Message List exception which
842 -- indicates API processing has been aborted because
843 -- at least one message exists in the list.
844 --
845 rollback to update_eligy_profile_swi;
846 --
847 -- Reset IN OUT parameters and set OUT parameters
848 --
849 if(fnd_message.get_number('BEN','BEN_91009_NAME_NOT_UNIQUE')<> null)then
850 fnd_message.set_name('PER', 'HR_51795_WPM_ELIGY_NAME_EXIST');
851 hr_multi_message.add
852 (p_message_type => hr_multi_message.G_ERROR_MSG
853 );
854 end if;
855
856 if hr_multi_message.unexpected_error_add(l_proc) then
857 hr_utility.set_location(' Leaving:' || l_proc,40);
858 raise;
859 end if;
860
861 p_effective_start_date := null;
862 p_effective_end_date := null;
863 p_object_version_number := null;
864 p_return_status := hr_multi_message.get_return_status_disable;
865 hr_utility.set_location(' Leaving:' || l_proc, 30);
866
867 end update_eligy_profile;
868 -- ----------------------------------------------------------------------------
869 -- |--------------------------< create_eligy_object >-------------------------|
870 -- ----------------------------------------------------------------------------
871 -- {Start Of Comments}
872 --
873 -- Description:
874 --
875 --
876 -- Prerequisites:
877 --
878 --
879 -- In Parameters:
880 -- Name Reqd Type Description
881 -- p_validate Yes boolean Commit or Rollback.
882 --
883 -- Post Success:
884 --
885 -- Out Parameters:
886 -- Name Reqd Type Description
887 --
888 -- Post Failure:
889 --
890 --
891 -- Access Status:
892 -- Public.
893 --
894 -- {End Of Comments}
895 --
896 procedure create_eligy_object
897 (p_validate in number default hr_api.g_false_num
898 ,p_elig_obj_id in out nocopy number
899 ,p_effective_start_date out nocopy date
900 ,p_effective_end_date out nocopy date
901 ,p_business_group_id in number
902 ,p_table_name in varchar2
903 ,p_column_name in varchar2
904 ,p_column_value in varchar2
905 ,p_object_version_number out nocopy number
906 ,p_effective_date in date
907 ) is
908 --
909 -- Variables for API Boolean parameters
910 l_validate boolean;
911 --
912 -- Other variables
913 l_proc varchar2(72) := g_package ||'create_eligy_obj';
914
915 begin
916 hr_utility.set_location(' Entering:' || l_proc,10);
917 --
918 -- Issue a savepoint
919 --
920 savepoint create_eligy_object_swi;
921 --
922 -- Initialise Multiple Message Detection
923 --
924 hr_multi_message.enable_message_list;
925 --
926 -- Remember IN OUT parameter IN values
927 --
928 --
929 -- Convert constant values to their corresponding boolean value
930 --
931 l_validate :=
932 hr_api.constant_to_boolean
933 (p_constant_value => p_validate);
934 --
935 -- Register Surrogate ID or user key values
936 --
937 ben_beo_ins.set_base_key_value
938 (p_elig_obj_id => p_elig_obj_id);
939
940 --
941 -- Call API
942 --
943 hr_objective_library_api.create_eligy_object
944 (p_validate => l_validate
945 ,p_elig_obj_id => p_elig_obj_id
946 ,p_effective_start_date => p_effective_start_date
947 ,p_effective_end_date => p_effective_end_date
948 ,p_business_group_id => p_business_group_id
949 ,p_table_name => p_table_name
950 ,p_column_name => p_column_name
951 ,p_column_value => p_column_value
952 ,p_object_version_number => p_object_version_number
953 ,p_effective_date => p_effective_date
954 );
955
956 exception
957 when hr_multi_message.error_message_exist then
958 --
959 -- Catch the Multiple Message List exception which
960 -- indicates API processing has been aborted because
961 -- at least one message exists in the list.
962 --
963 rollback to create_eligy_object_swi;
964 --
965 -- Reset IN OUT parameters and set OUT parameters
966 --
967 p_elig_obj_id := null;
968 p_effective_start_date := null;
969 p_effective_end_date := null;
970 p_object_version_number := null;
971
972 hr_utility.set_location(' Leaving:' || l_proc, 30);
973
974 end create_eligy_object;
975 --
976 -- ----------------------------------------------------------------------------
977 -- |--------------------------< update_eligy_object >-------------------------|
978 -- ----------------------------------------------------------------------------
979 -- {Start Of Comments}
980 --
981 -- Description:
982 --
983 --
984 -- Prerequisites:
985 --
986 --
987 -- In Parameters:
988 -- Name Reqd Type Description
989 -- p_validate Yes boolean Commit or Rollback.
990 --
991 -- Post Success:
992 --
993 -- Out Parameters:
994 -- Name Reqd Type Description
995 --
996 -- Post Failure:
997 --
998 --
999 -- Access Status:
1000 -- Public.
1001 --
1002 -- {End Of Comments}
1003 --
1004 procedure update_eligy_object
1005 (p_validate in number default hr_api.g_false_num
1006 ,p_elig_obj_id in number
1007 ,p_effective_start_date out nocopy date
1008 ,p_effective_end_date out nocopy date
1009 ,p_business_group_id in number default hr_api.g_number
1010 ,p_table_name in varchar2 default hr_api.g_varchar2
1011 ,p_column_name in varchar2 default hr_api.g_varchar2
1012 ,p_column_value in varchar2 default hr_api.g_varchar2
1013 ,p_object_version_number in out nocopy number
1014 ,p_effective_date in date
1015 ,p_datetrack_mode in varchar2
1016 ) is
1017 --
1018 -- Variables for API Boolean parameters
1019 l_validate boolean;
1020 --
1021 -- Other variables
1022 l_proc varchar2(72) := g_package ||'update_eligy_object';
1023
1024 begin
1025 hr_utility.set_location(' Entering:' || l_proc,10);
1026 --
1027 -- Issue a savepoint
1028 --
1029 savepoint update_eligy_object_swi;
1030 --
1031 -- Initialise Multiple Message Detection
1032 --
1033 hr_multi_message.enable_message_list;
1034 --
1035 -- Remember IN OUT parameter IN values
1036 --
1037 --
1038 -- Convert constant values to their corresponding boolean value
1039 --
1040 l_validate :=
1041 hr_api.constant_to_boolean
1042 (p_constant_value => p_validate);
1043 --
1044 -- Register Surrogate ID or user key values
1045 --
1046 --
1047 -- Call API
1048 --
1049 hr_objective_library_api.update_eligy_object
1050 (p_validate => l_validate
1051 ,p_elig_obj_id => p_elig_obj_id
1052 ,p_effective_start_date => p_effective_start_date
1053 ,p_effective_end_date => p_effective_end_date
1054 ,p_business_group_id => p_business_group_id
1055 ,p_table_name => p_table_name
1056 ,p_column_name => p_column_name
1057 ,p_column_value => p_column_value
1058 ,p_object_version_number => p_object_version_number
1059 ,p_effective_date => p_effective_date
1060 ,p_datetrack_mode => p_datetrack_mode
1061 );
1062 hr_utility.set_location(' Leaving:' || l_proc,20);
1063 --
1064
1065 exception
1066 when hr_multi_message.error_message_exist then
1067 --
1068 -- Catch the Multiple Message List exception which
1069 -- indicates API processing has been aborted because
1070 -- at least one message exists in the list.
1071 --
1072 rollback to update_eligy_object_swi;
1073 --
1074 -- Reset IN OUT parameters and set OUT parameters
1075 --
1076 p_effective_start_date := null;
1077 p_effective_end_date := null;
1078 p_object_version_number := null;
1079
1080 hr_utility.set_location(' Leaving:' || l_proc, 30);
1081
1082 end update_eligy_object;
1083 --
1084 -- ----------------------------------------------------------------------------
1085 -- |--------------------------< delete_eligy_object >-------------------------|
1086 -- ----------------------------------------------------------------------------
1087 -- {Start Of Comments}
1088 --
1089 -- Description:
1090 --
1091 --
1092 -- Prerequisites:
1093 --
1094 --
1095 -- In Parameters:
1096 -- Name Reqd Type Description
1097 -- p_validate Yes boolean Commit or Rollback.
1098 --
1099 -- Post Success:
1100 --
1101 -- Out Parameters:
1102 -- Name Reqd Type Description
1103 --
1104 -- Post Failure:
1105 --
1106 --
1107 -- Access Status:
1108 -- Public.
1109 --
1110 -- {End Of Comments}
1111 --
1112 procedure delete_eligy_object
1113 (p_validate number default hr_api.g_false_num
1114 ,p_elig_obj_id in number
1115 ,p_effective_start_date out nocopy date
1116 ,p_effective_end_date out nocopy date
1117 ,p_object_version_number in out nocopy number
1118 ,p_effective_date in date
1119 ,p_datetrack_mode in varchar2
1120 ) is
1121 --
1122 -- Variables for API Boolean parameters
1123 l_validate boolean;
1124 --
1125 -- Other variables
1126 l_proc varchar2(72) := g_package ||'delete_eligy_object';
1127
1128 begin
1129 hr_utility.set_location(' Entering:' || l_proc,10);
1130 --
1131 -- Issue a savepoint
1132 --
1133 savepoint delete_eligy_object_swi;
1134 --
1135 -- Initialise Multiple Message Detection
1136 --
1137 hr_multi_message.enable_message_list;
1138 --
1139 -- Remember IN OUT parameter IN values
1140 --
1141 --
1142 -- Convert constant values to their corresponding boolean value
1143 --
1144 l_validate :=
1145 hr_api.constant_to_boolean
1146 (p_constant_value => p_validate);
1147 --
1148 -- Register Surrogate ID or user key values
1149 --
1150 --
1151 -- Call API
1152 --
1153 hr_objective_library_api.delete_eligy_object
1154 (p_validate => l_validate
1155 ,p_elig_obj_id => p_elig_obj_id
1156 ,p_effective_start_date => p_effective_start_date
1157 ,p_effective_end_date => p_effective_end_date
1158 ,p_object_version_number => p_object_version_number
1159 ,p_effective_date => p_effective_date
1160 ,p_datetrack_mode => p_datetrack_mode
1161 );
1162 hr_utility.set_location(' Leaving:' || l_proc,20);
1163 --
1164 exception
1165 when hr_multi_message.error_message_exist then
1166 --
1167 -- Catch the Multiple Message List exception which
1168 -- indicates API processing has been aborted because
1169 -- at least one message exists in the list.
1170 --
1171 rollback to delete_eligy_object_swi;
1172 --
1173 -- Reset IN OUT parameters and set OUT parameters
1174 --
1175 p_effective_start_date := null;
1176 p_effective_end_date := null;
1177 p_object_version_number := null;
1178
1179 hr_utility.set_location(' Leaving:' || l_proc, 30);
1180
1181 end delete_eligy_object;
1182 --
1183 --
1184 -- ----------------------------------------------------------------------------
1185 -- |-----------------------< create_elig_obj_elig_prfl >----------------------|
1186 -- ----------------------------------------------------------------------------
1187 -- {Start Of Comments}
1188 --
1189 -- Description:
1190 --
1191 --
1192 -- Prerequisites:
1193 --
1194 --
1195 -- In Parameters:
1196 -- Name Reqd Type Description
1197 -- p_validate Yes boolean Commit or Rollback.
1198 --
1199 -- Post Success:
1200 --
1201 -- Out Parameters:
1202 -- Name Reqd Type Description
1203 --
1204 -- Post Failure:
1205 --
1206 --
1207 -- Access Status:
1208 -- Public.
1209 --
1210 -- {End Of Comments}
1211 --
1212 procedure create_elig_obj_elig_prfl
1213 (p_validate in number default hr_api.g_false_num
1214 ,p_elig_obj_elig_prfl_id in out nocopy number
1215 ,p_effective_start_date out nocopy date
1216 ,p_effective_end_date out nocopy date
1217 ,p_business_group_id in number default null
1218 ,p_elig_obj_id in number default null
1219 ,p_elig_prfl_id in number default null
1220 ,p_object_version_number out nocopy number
1221 ,p_effective_date in date
1222 ) is
1223 --
1224 -- Variables for API Boolean parameters
1225 l_validate boolean;
1226 --
1227 -- Other variables
1228 l_proc varchar2(72) := g_package ||'create_elig_obj_elig_prfl';
1229
1230 begin
1231 hr_utility.set_location(' Entering:' || l_proc,10);
1232 --
1233 -- Issue a savepoint
1234 --
1235 savepoint create_elig_obj_elig_prfl_swi;
1236 --
1237 -- Initialise Multiple Message Detection
1238 --
1239 hr_multi_message.enable_message_list;
1240 --
1241 -- Remember IN OUT parameter IN values
1242 --
1243 --
1244 -- Convert constant values to their corresponding boolean value
1245 --
1246 l_validate :=
1247 hr_api.constant_to_boolean
1248 (p_constant_value => p_validate);
1249 --
1250 -- Register Surrogate ID or user key values
1251 --
1252 ben_bep_ins.set_base_key_value
1253 (p_elig_obj_elig_prfl_id => p_elig_obj_elig_prfl_id);
1254
1255 --
1256 -- Call API
1257 --
1258 hr_objective_library_api.create_elig_obj_elig_prfl
1259 (p_validate => l_validate
1260 ,p_elig_obj_elig_prfl_id => p_elig_obj_elig_prfl_id
1261 ,p_effective_start_date => p_effective_start_date
1262 ,p_effective_end_date => p_effective_end_date
1263 ,p_business_group_id => p_business_group_id
1264 ,p_elig_obj_id => p_elig_obj_id
1265 ,p_elig_prfl_id => p_elig_prfl_id
1266 ,p_object_version_number => p_object_version_number
1267 ,p_effective_date => p_effective_date
1268 );
1269
1270 hr_utility.set_location(' Leaving:' || l_proc,20);
1271 --
1272
1273 exception
1274 when hr_multi_message.error_message_exist then
1275 --
1276 -- Catch the Multiple Message List exception which
1277 -- indicates API processing has been aborted because
1278 -- at least one message exists in the list.
1279 --
1280 rollback to create_elig_obj_elig_prfl_swi;
1281 --
1282 -- Reset IN OUT parameters and set OUT parameters
1283 --
1284 p_elig_obj_elig_prfl_id := null;
1285 p_effective_start_date := null;
1286 p_effective_end_date := null;
1287 p_object_version_number := null;
1288
1289 hr_utility.set_location(' Leaving:' || l_proc, 30);
1290
1291
1292 end create_elig_obj_elig_prfl;
1293 --
1294 -- ----------------------------------------------------------------------------
1295 -- |-----------------------< update_elig_obj_elig_prfl >----------------------|
1296 -- ----------------------------------------------------------------------------
1297 -- {Start Of Comments}
1298 --
1299 -- Description:
1300 --
1301 --
1302 -- Prerequisites:
1303 --
1304 --
1305 -- In Parameters:
1306 -- Name Reqd Type Description
1307 -- p_validate Yes boolean Commit or Rollback.
1308 --
1309 -- Post Success:
1310 --
1311 -- Out Parameters:
1312 -- Name Reqd Type Description
1313 --
1314 -- Post Failure:
1315 --
1316 --
1317 -- Access Status:
1318 -- Public.
1319 --
1320 -- {End Of Comments}
1321 --
1322 procedure update_elig_obj_elig_prfl
1323 (p_validate in number default hr_api.g_false_num
1324 ,p_elig_obj_elig_prfl_id in number
1325 ,p_effective_start_date out nocopy date
1326 ,p_effective_end_date out nocopy date
1327 ,p_elig_obj_id in number default hr_api.g_number
1328 ,p_elig_prfl_id in number default hr_api.g_number
1329 ,p_object_version_number in out nocopy number
1330 ,p_effective_date in date
1331 ,p_datetrack_mode in varchar2
1332 ) is
1333 --
1334 -- Variables for API Boolean parameters
1335 l_validate boolean;
1336 --
1337 -- Other variables
1338 l_proc varchar2(72) := g_package ||'update_elig_obj_elig_prfl';
1339
1340 begin
1341 hr_utility.set_location(' Entering:' || l_proc,10);
1342 --
1343 -- Issue a savepoint
1344 --
1345 savepoint update_elig_obj_elig_prfl_swi;
1346 --
1347 -- Initialise Multiple Message Detection
1348 --
1349 hr_multi_message.enable_message_list;
1350 --
1351 -- Remember IN OUT parameter IN values
1352 --
1353 --
1354 -- Convert constant values to their corresponding boolean value
1355 --
1356 l_validate :=
1357 hr_api.constant_to_boolean
1358 (p_constant_value => p_validate);
1359 --
1360 -- Register Surrogate ID or user key values
1361 --
1362 --
1363 -- Call API
1364 --
1365 hr_objective_library_api.update_elig_obj_elig_prfl
1366 (p_validate => l_validate
1367 ,p_elig_obj_elig_prfl_id => p_elig_obj_elig_prfl_id
1368 ,p_effective_start_date => p_effective_start_date
1369 ,p_effective_end_date => p_effective_end_date
1370 ,p_elig_obj_id => p_elig_obj_id
1371 ,p_elig_prfl_id => p_elig_prfl_id
1372 ,p_object_version_number => p_object_version_number
1373 ,p_effective_date => p_effective_date
1374 ,p_datetrack_mode => p_datetrack_mode
1375 );
1376 hr_utility.set_location(' Leaving:' || l_proc,20);
1377 --
1378
1379 exception
1380 when hr_multi_message.error_message_exist then
1381 --
1382 -- Catch the Multiple Message List exception which
1383 -- indicates API processing has been aborted because
1384 -- at least one message exists in the list.
1385 --
1386 rollback to update_elig_obj_elig_prfl_swi;
1387 --
1388 -- Reset IN OUT parameters and set OUT parameters
1389 --
1390 p_effective_start_date := null;
1391 p_effective_end_date := null;
1392 p_object_version_number := null;
1393
1394 hr_utility.set_location(' Leaving:' || l_proc, 30);
1395
1396 end update_elig_obj_elig_prfl;
1397 --
1398 --
1399 -- ----------------------------------------------------------------------------
1400 -- |-----------------------< delete_elig_obj_elig_prfl >----------------------|
1401 -- ----------------------------------------------------------------------------
1402 -- {Start Of Comments}
1403 --
1404 -- Description:
1405 --
1406 --
1407 -- Prerequisites:
1408 --
1409 --
1410 -- In Parameters:
1411 -- Name Reqd Type Description
1412 -- p_validate Yes boolean Commit or Rollback.
1413 --
1414 -- Post Success:
1415 --
1416 -- Out Parameters:
1417 -- Name Reqd Type Description
1418 --
1419 -- Post Failure:
1420 --
1421 --
1422 -- Access Status:
1423 -- Public.
1424 --
1425 -- {End Of Comments}
1426 --
1427 procedure delete_elig_obj_elig_prfl
1428 (p_validate in number default hr_api.g_false_num
1429 ,p_elig_obj_elig_prfl_id in number
1430 ,p_effective_start_date out nocopy date
1431 ,p_effective_end_date out nocopy date
1432 ,p_object_version_number in out nocopy number
1433 ,p_effective_date in date
1434 ,p_datetrack_mode in varchar2
1435 ) is
1436 --
1437 -- Variables for API Boolean parameters
1438 l_validate boolean;
1439 --
1440 -- Other variables
1441 l_proc varchar2(72) := g_package ||'delete_elig_obj_elig_prfl';
1442
1443 begin
1444 hr_utility.set_location(' Entering:' || l_proc,10);
1445 --
1446 -- Issue a savepoint
1447 --
1448 savepoint delete_elig_obj_elig_prfl_swi;
1449 --
1450 -- Initialise Multiple Message Detection
1451 --
1452 hr_multi_message.enable_message_list;
1453 --
1454 -- Remember IN OUT parameter IN values
1455 --
1456 --
1457 -- Convert constant values to their corresponding boolean value
1458 --
1459 l_validate :=
1460 hr_api.constant_to_boolean
1461 (p_constant_value => p_validate);
1462 --
1463 -- Register Surrogate ID or user key values
1464 --
1465 --
1466 -- Call API
1467 --
1468 hr_objective_library_api.delete_elig_obj_elig_prfl
1469 (p_validate => l_validate
1470 ,p_elig_obj_elig_prfl_id => p_elig_obj_elig_prfl_id
1471 ,p_effective_start_date => p_effective_start_date
1472 ,p_effective_end_date => p_effective_end_date
1473 ,p_object_version_number => p_object_version_number
1474 ,p_effective_date => p_effective_date
1475 ,p_datetrack_mode => p_datetrack_mode
1476 );
1477 hr_utility.set_location(' Leaving:' || l_proc,20);
1478 --
1479
1480 exception
1481 when hr_multi_message.error_message_exist then
1482 --
1483 -- Catch the Multiple Message List exception which
1484 -- indicates API processing has been aborted because
1485 -- at least one message exists in the list.
1486 --
1487 rollback to delete_elig_obj_elig_prfl_swi;
1488 --
1489 -- Reset IN OUT parameters and set OUT parameters
1490 --
1491 p_effective_start_date := null;
1492 p_effective_end_date := null;
1493 p_object_version_number := null;
1494
1495 hr_utility.set_location(' Leaving:' || l_proc, 30);
1496
1497 end delete_elig_obj_elig_prfl;
1498 --
1499 --
1500 -- ----------------------------------------------------------------------------
1501 -- |----------------------------< create_eligy_grade >------------------------|
1502 -- ----------------------------------------------------------------------------
1503 -- {Start Of Comments}
1504 --
1505 -- Description:
1506 --
1507 --
1508 -- Prerequisites:
1509 --
1510 --
1511 -- In Parameters:
1512 -- Name Reqd Type Description
1513 -- p_validate Yes boolean Commit or Rollback.
1514 --
1515 -- Post Success:
1516 --
1517 -- Out Parameters:
1518 -- Name Reqd Type Description
1519 -- p_eligy_prfl_id Yes number PK of record
1520 --
1521 -- Post Failure:
1522 --
1523 --
1524 -- Access Status:
1525 -- Public.
1526 --
1527 -- {End Of Comments}
1528 --
1529 procedure create_eligy_grade
1530 (p_validate in number default hr_api.g_false_num
1531 ,p_elig_grd_prte_id in out nocopy number
1532 ,p_effective_start_date out nocopy date
1533 ,p_effective_end_date out nocopy date
1534 ,p_business_group_id in number default null
1535 ,p_eligy_prfl_id in number default null
1536 ,p_grade_id in number default null
1537 ,p_ordr_num in number default null
1538 ,p_object_version_number out nocopy number
1539 ,p_effective_date in date
1540 ) is
1541 --
1542 -- Variables for API Boolean parameters
1543 l_validate boolean;
1544
1545 --
1546 -- Other variables
1547 l_proc varchar2(72) := g_package ||'create_eligy_grade';
1548
1549 begin
1550 hr_utility.set_location(' Entering:' || l_proc,10);
1551 --
1552 -- Issue a savepoint
1553 --
1554 savepoint create_eligy_grade_swi;
1555 --
1556 -- Initialise Multiple Message Detection
1557 --
1558 hr_multi_message.enable_message_list;
1559 --
1560 -- Remember IN OUT parameter IN values
1561 --
1562 --
1563 -- Convert constant values to their corresponding boolean value
1564 --
1565 l_validate :=
1566 hr_api.constant_to_boolean
1567 (p_constant_value => p_validate);
1568 --
1569 -- Register Surrogate ID or user key values
1570 --
1571 --
1572 --
1573 ben_egr_ins.set_base_key_value(p_elig_grd_prte_id => p_elig_grd_prte_id);
1574
1575 -- Call API
1576 --
1577 hr_objective_library_api.create_eligy_grade
1578 (p_validate => l_validate
1579 ,p_elig_grd_prte_id => p_elig_grd_prte_id
1580 ,p_effective_start_date => p_effective_start_date
1581 ,p_effective_end_date => p_effective_end_date
1582 ,p_business_group_id => p_business_group_id
1583 ,p_eligy_prfl_id => p_eligy_prfl_id
1584 ,p_grade_id => p_grade_id
1585 ,p_ordr_num => p_ordr_num
1586 ,p_object_version_number => p_object_version_number
1587 ,p_effective_date => p_effective_date
1588 );
1589
1590 hr_utility.set_location(' Leaving:' || l_proc,20);
1591 --
1592
1593 exception
1594 when hr_multi_message.error_message_exist then
1595 --
1596 -- Catch the Multiple Message List exception which
1597 -- indicates API processing has been aborted because
1598 -- at least one message exists in the list.
1599 --
1600 rollback to create_eligy_grade_swi;
1601 --
1602 -- Reset IN OUT parameters and set OUT parameters
1603 --
1604 p_elig_grd_prte_id := null;
1605 p_effective_start_date := null;
1606 p_effective_end_date := null;
1607 p_object_version_number := null;
1608
1609 hr_utility.set_location(' Leaving:' || l_proc, 30);
1610
1611 end create_eligy_grade;
1612 --
1613 -- ----------------------------------------------------------------------------
1614 -- |-------------------------< update_eligy_grade >------------------------|
1615 -- ----------------------------------------------------------------------------
1616 -- {Start Of Comments}
1617 --
1618 -- Description:
1619 --
1620 --
1621 -- Prerequisites:
1622 --
1623 --
1624 -- In Parameters:
1625 -- Name Reqd Type Description
1626 -- p_validate Yes boolean Commit or Rollback.
1627 --
1628 -- Post Success:
1629 --
1630 -- Out Parameters:
1631 -- Name Reqd Type Description
1632 -- p_eligy_prfl_id Yes number PK of record
1633 --
1634 -- Post Failure:
1635 --
1636 --
1637 -- Access Status:
1638 -- Public.
1639 --
1640 -- {End Of Comments}
1641 --
1642 procedure update_eligy_grade
1643 (p_validate in number default hr_api.g_false_num
1644 ,p_elig_grd_prte_id in number
1645 ,p_effective_start_date out nocopy date
1646 ,p_effective_end_date out nocopy date
1647 ,p_business_group_id in number default hr_api.g_number
1648 ,p_eligy_prfl_id in number default hr_api.g_number
1649 ,p_grade_id in number default hr_api.g_number
1650 ,p_object_version_number in out nocopy number
1651 ,p_effective_date in date
1652 ,p_datetrack_mode in varchar2
1653 ) is
1654 --
1655 -- Variables for API Boolean parameters
1656 l_validate boolean;
1657 --
1658 -- Other variables
1659 l_proc varchar2(72) := g_package ||'update_eligy_grade';
1660
1661 begin
1662 hr_utility.set_location(' Entering:' || l_proc,10);
1663 --
1664 -- Issue a savepoint
1665 --
1666 savepoint update_eligy_grade_swi;
1667 --
1668 -- Initialise Multiple Message Detection
1669 --
1670 hr_multi_message.enable_message_list;
1671 --
1672 -- Remember IN OUT parameter IN values
1673 --
1674 --
1675 -- Convert constant values to their corresponding boolean value
1676 --
1677 l_validate :=
1678 hr_api.constant_to_boolean
1679 (p_constant_value => p_validate);
1680 --
1681 -- Register Surrogate ID or user key values
1682 --
1683 --
1684 -- Call API
1685 --
1686 hr_objective_library_api.update_eligy_grade
1687 (p_validate => l_validate
1688 ,p_elig_grd_prte_id => p_elig_grd_prte_id
1689 ,p_effective_start_date => p_effective_start_date
1690 ,p_effective_end_date => p_effective_end_date
1691 ,p_business_group_id => p_business_group_id
1692 ,p_eligy_prfl_id => p_eligy_prfl_id
1693 ,p_grade_id => p_grade_id
1694 ,p_object_version_number => p_object_version_number
1695 ,p_effective_date => p_effective_date
1696 ,p_datetrack_mode => p_datetrack_mode
1697 );
1698
1699 hr_utility.set_location(' Leaving:' || l_proc,20);
1700 --
1701 exception
1702 when hr_multi_message.error_message_exist then
1703 --
1704 -- Catch the Multiple Message List exception which
1705 -- indicates API processing has been aborted because
1706 -- at least one message exists in the list.
1707 --
1708 rollback to update_eligy_grade_swi;
1709 --
1710 -- Reset IN OUT parameters and set OUT parameters
1711 --
1712 p_effective_start_date := null;
1713 p_effective_end_date := null;
1714 p_object_version_number := null;
1715
1716 hr_utility.set_location(' Leaving:' || l_proc, 30);
1717
1718 end update_eligy_grade;
1719 --
1720 -- ----------------------------------------------------------------------------
1721 -- |----------------------------< delete_eligy_grade >--------------------------|
1722 -- ----------------------------------------------------------------------------
1723 -- {Start Of Comments}
1724 --
1725 -- Description:
1726 --
1727 --
1728 -- Prerequisites:
1729 --
1730 --
1731 -- In Parameters:
1732 -- Name Reqd Type Description
1733 -- p_validate Yes boolean Commit or Rollback.
1734 --
1735 -- Post Success:
1736 --
1737 -- Out Parameters:
1738 -- Name Reqd Type Description
1739 -- p_eligy_prfl_id Yes number PK of record
1740 --
1741 -- Post Failure:
1742 --
1743 --
1744 -- Access Status:
1745 -- Public.
1746 --
1747 -- {End Of Comments}
1748 --
1749 procedure delete_eligy_grade
1750 (p_validate in number default hr_api.g_false_num
1751 ,p_elig_grd_prte_id in number
1752 ,p_effective_start_date out nocopy date
1753 ,p_effective_end_date out nocopy date
1754 ,p_object_version_number in out nocopy number
1755 ,p_effective_date in date
1756 ,p_datetrack_mode in varchar2
1757 ) is
1758 --
1759 -- Variables for API Boolean parameters
1760 l_validate boolean;
1761 --
1762 -- Other variables
1763 l_proc varchar2(72) := g_package ||'delete_eligy_grade';
1764
1765 begin
1766 hr_utility.set_location(' Entering:' || l_proc,10);
1767 --
1768 -- Issue a savepoint
1769 --
1770 savepoint delete_eligy_grade_swi;
1771 --
1772 -- Initialise Multiple Message Detection
1773 --
1774 hr_multi_message.enable_message_list;
1775 --
1776 -- Remember IN OUT parameter IN values
1777 --
1778 --
1779 -- Convert constant values to their corresponding boolean value
1780 --
1781 l_validate :=
1782 hr_api.constant_to_boolean
1783 (p_constant_value => p_validate);
1784 --
1785 -- Register Surrogate ID or user key values
1786 --
1787 --
1788 -- Call API
1789 --
1790 hr_objective_library_api.delete_eligy_grade
1791 (p_validate => l_validate
1792 ,p_elig_grd_prte_id => p_elig_grd_prte_id
1793 ,p_effective_start_date => p_effective_start_date
1794 ,p_effective_end_date => p_effective_end_date
1795 ,p_object_version_number => p_object_version_number
1796 ,p_effective_date => p_effective_date
1797 ,p_datetrack_mode => p_datetrack_mode
1798 );
1799
1800 hr_utility.set_location(' Leaving:' || l_proc,20);
1801 --
1802 exception
1803 when hr_multi_message.error_message_exist then
1804 --
1805 -- Catch the Multiple Message List exception which
1806 -- indicates API processing has been aborted because
1807 -- at least one message exists in the list.
1808 --
1809 rollback to delete_eligy_grade_swi;
1810 --
1811 -- Reset IN OUT parameters and set OUT parameters
1812 --
1813 p_effective_start_date := null;
1814 p_effective_end_date := null;
1815 p_object_version_number := null;
1816
1817 hr_utility.set_location(' Leaving:' || l_proc, 30);
1818
1819 end delete_eligy_grade;
1820 --
1821 --
1822 -- ----------------------------------------------------------------------------
1823 -- |----------------------------< create_eligy_org >------------------------|
1824 -- ----------------------------------------------------------------------------
1825 -- {Start Of Comments}
1826 --
1827 -- Description:
1828 --
1829 --
1830 -- Prerequisites:
1831 --
1832 --
1833 -- In Parameters:
1834 -- Name Reqd Type Description
1835 -- p_validate Yes boolean Commit or Rollback.
1836 --
1837 -- Post Success:
1838 --
1839 -- Out Parameters:
1840 -- Name Reqd Type Description
1841 -- p_eligy_prfl_id Yes number PK of record
1842 --
1843 -- Post Failure:
1844 --
1845 --
1846 -- Access Status:
1847 -- Public.
1848 --
1849 -- {End Of Comments}
1850 --
1851 procedure create_eligy_org
1852 (p_validate in number default hr_api.g_false_num
1853 ,p_elig_org_unit_prte_id in out nocopy number
1854 ,p_effective_start_date out nocopy date
1855 ,p_effective_end_date out nocopy date
1856 ,p_business_group_id in number default null
1857 ,p_eligy_prfl_id in number default null
1858 ,p_organization_id in number default null
1859 ,p_ordr_num in number default null
1860 ,p_object_version_number out nocopy number
1861 ,p_effective_date in date
1862 ) is
1863 --
1864 -- Variables for API Boolean parameters
1865 l_validate boolean;
1866
1867 --
1868 -- Other variables
1869 l_proc varchar2(72) := g_package ||'create_eligy_org';
1870 begin
1871 hr_utility.set_location(' Entering:' || l_proc,10);
1872 --
1873 -- Issue a savepoint
1874 --
1875 savepoint create_eligy_org_swi;
1876 --
1877 -- Initialise Multiple Message Detection
1878 --
1879 hr_multi_message.enable_message_list;
1880 --
1881 -- Remember IN OUT parameter IN values
1882 --
1883 --
1884 -- Convert constant values to their corresponding boolean value
1885 --
1886 l_validate :=
1887 hr_api.constant_to_boolean
1888 (p_constant_value => p_validate);
1889 --
1890 -- Register Surrogate ID or user key values
1891 --
1892 ben_eou_ins.set_base_key_value(p_elig_org_unit_prte_id => p_elig_org_unit_prte_id);
1893 --
1894 -- Call API
1895 --
1896 hr_objective_library_api.create_eligy_org
1897 (p_validate => l_validate
1898 ,p_elig_org_unit_prte_id => p_elig_org_unit_prte_id
1899 ,p_effective_start_date => p_effective_start_date
1900 ,p_effective_end_date => p_effective_end_date
1901 ,p_business_group_id => p_business_group_id
1902 ,p_eligy_prfl_id => p_eligy_prfl_id
1903 ,p_organization_id => p_organization_id
1904 ,p_ordr_num => p_ordr_num
1905 ,p_object_version_number => p_object_version_number
1906 ,p_effective_date => p_effective_date
1907 );
1908
1909 hr_utility.set_location(' Leaving:' || l_proc,20);
1910 --
1911
1912 exception
1913 when hr_multi_message.error_message_exist then
1914 --
1915 -- Catch the Multiple Message List exception which
1916 -- indicates API processing has been aborted because
1917 -- at least one message exists in the list.
1918 --
1919 rollback to create_eligy_org_swi;
1920 --
1921 --
1922 -- Reset IN OUT parameters and set OUT parameters
1923 --
1924 p_elig_org_unit_prte_id := null;
1925 p_effective_start_date := null;
1926 p_effective_end_date := null;
1927 p_object_version_number := null;
1928
1929 hr_utility.set_location(' Leaving:' || l_proc, 30);
1930
1931 end create_eligy_org;
1932 --
1933 -- ----------------------------------------------------------------------------
1934 -- |-------------------------< update_eligy_org >------------------------|
1935 -- ----------------------------------------------------------------------------
1936 -- {Start Of Comments}
1937 --
1938 -- Description:
1939 --
1940 --
1941 -- Prerequisites:
1942 --
1943 --
1944 -- In Parameters:
1945 -- Name Reqd Type Description
1946 -- p_validate Yes boolean Commit or Rollback.
1947 --
1948 -- Post Success:
1949 --
1950 -- Out Parameters:
1951 -- Name Reqd Type Description
1952 -- p_eligy_prfl_id Yes number PK of record
1953 --
1954 -- Post Failure:
1955 --
1956 --
1957 -- Access Status:
1958 -- Public.
1959 --
1960 -- {End Of Comments}
1961 --
1962 procedure update_eligy_org
1963 (p_validate in number default hr_api.g_false_num
1964 ,p_elig_org_unit_prte_id in number
1965 ,p_effective_start_date out nocopy date
1966 ,p_effective_end_date out nocopy date
1967 ,p_business_group_id in number default hr_api.g_number
1968 ,p_eligy_prfl_id in number default hr_api.g_number
1969 ,p_organization_id in number default hr_api.g_number
1970 ,p_object_version_number in out nocopy number
1971 ,p_effective_date in date
1972 ,p_datetrack_mode in varchar2
1973 ) is
1974 --
1975 -- Variables for API Boolean parameters
1976 l_validate boolean;
1977 --
1978 -- Other variables
1979 l_proc varchar2(72) := g_package ||'update_eligy_org';
1980
1981 begin
1982 hr_utility.set_location(' Entering:' || l_proc,10);
1983 --
1984 -- Issue a savepoint
1985 --
1986 savepoint update_eligy_org_swi;
1987 --
1988 -- Initialise Multiple Message Detection
1989 --
1990 hr_multi_message.enable_message_list;
1991 --
1992 -- Remember IN OUT parameter IN values
1993 --
1994 --
1995 -- Convert constant values to their corresponding boolean value
1996 --
1997 l_validate :=
1998 hr_api.constant_to_boolean
1999 (p_constant_value => p_validate);
2000 --
2001 -- Register Surrogate ID or user key values
2002 --
2003 --
2004 -- Call API
2005 --
2006 hr_objective_library_api.update_eligy_org
2007 (p_validate => l_validate
2008 ,p_elig_org_unit_prte_id => p_elig_org_unit_prte_id
2009 ,p_effective_start_date => p_effective_start_date
2010 ,p_effective_end_date => p_effective_end_date
2011 ,p_business_group_id => p_business_group_id
2012 ,p_eligy_prfl_id => p_eligy_prfl_id
2013 ,p_organization_id => p_organization_id
2014 ,p_object_version_number => p_object_version_number
2015 ,p_effective_date => p_effective_date
2016 ,p_datetrack_mode => p_datetrack_mode
2017 );
2018
2019 hr_utility.set_location(' Leaving:' || l_proc,20);
2020 --
2021 exception
2022 when hr_multi_message.error_message_exist then
2023 --
2024 -- Catch the Multiple Message List exception which
2025 -- indicates API processing has been aborted because
2026 -- at least one message exists in the list.
2027 --
2028 rollback to update_eligy_org_swi;
2029 --
2030 -- Reset IN OUT parameters and set OUT parameters
2031 --
2032 p_effective_start_date := null;
2033 p_effective_end_date := null;
2034 p_object_version_number := null;
2035
2036 hr_utility.set_location(' Leaving:' || l_proc, 30);
2037
2038 end update_eligy_org;
2039 --
2040 -- ----------------------------------------------------------------------------
2041 -- |----------------------------< delete_eligy_org >--------------------------|
2042 -- ----------------------------------------------------------------------------
2043 -- {Start Of Comments}
2044 --
2045 -- Description:
2046 --
2047 --
2048 -- Prerequisites:
2049 --
2050 --
2051 -- In Parameters:
2052 -- Name Reqd Type Description
2053 -- p_validate Yes boolean Commit or Rollback.
2054 --
2055 -- Post Success:
2056 --
2057 -- Out Parameters:
2058 -- Name Reqd Type Description
2059 -- p_eligy_prfl_id Yes number PK of record
2060 --
2061 -- Post Failure:
2062 --
2063 --
2064 -- Access Status:
2065 -- Public.
2066 --
2067 -- {End Of Comments}
2068 --
2069 procedure delete_eligy_org
2070 (p_validate in number default hr_api.g_false_num
2071 ,p_elig_org_unit_prte_id in number
2072 ,p_effective_start_date out nocopy date
2073 ,p_effective_end_date out nocopy date
2074 ,p_object_version_number in out nocopy number
2075 ,p_effective_date in date
2076 ,p_datetrack_mode in varchar2
2077 ) is
2078 --
2079 -- Variables for API Boolean parameters
2080 l_validate boolean;
2081 --
2082 -- Other variables
2083 l_proc varchar2(72) := g_package ||'delete_eligy_org';
2084
2085 begin
2086 hr_utility.set_location(' Entering:' || l_proc,10);
2087 --
2088 -- Issue a savepoint
2089 --
2090 savepoint delete_eligy_org_swi;
2091 --
2092 -- Initialise Multiple Message Detection
2093 --
2094 hr_multi_message.enable_message_list;
2095 --
2096 -- Remember IN OUT parameter IN values
2097 --
2098 --
2099 -- Convert constant values to their corresponding boolean value
2100 --
2101 l_validate :=
2102 hr_api.constant_to_boolean
2103 (p_constant_value => p_validate);
2104 --
2105 -- Register Surrogate ID or user key values
2106 --
2107 --
2108 -- Call API
2109 --
2110 hr_objective_library_api.delete_eligy_org
2111 (p_validate => l_validate
2112 ,p_elig_org_unit_prte_id => p_elig_org_unit_prte_id
2113 ,p_effective_start_date => p_effective_start_date
2114 ,p_effective_end_date => p_effective_end_date
2115 ,p_object_version_number => p_object_version_number
2116 ,p_effective_date => p_effective_date
2117 ,p_datetrack_mode => p_datetrack_mode
2118 );
2119
2120 hr_utility.set_location(' Leaving:' || l_proc,20);
2121 --
2122 exception
2123 when hr_multi_message.error_message_exist then
2124 --
2125 -- Catch the Multiple Message List exception which
2126 -- indicates API processing has been aborted because
2127 -- at least one message exists in the list.
2128 --
2129 rollback to delete_eligy_org_swi;
2130 --
2131 -- Reset IN OUT parameters and set OUT parameters
2132 --
2133 p_effective_start_date := null;
2134 p_effective_end_date := null;
2135 p_object_version_number := null;
2136
2137 hr_utility.set_location(' Leaving:' || l_proc, 30);
2138
2139 end delete_eligy_org;
2140 --
2141 --
2142 -- ----------------------------------------------------------------------------
2143 -- |----------------------------< create_eligy_job >------------------------|
2144 -- ----------------------------------------------------------------------------
2145 -- {Start Of Comments}
2146 --
2147 -- Description:
2148 --
2149 --
2150 -- Prerequisites:
2151 --
2152 --
2153 -- In Parameters:
2154 -- Name Reqd Type Description
2155 -- p_validate Yes boolean Commit or Rollback.
2156 --
2157 -- Post Success:
2158 --
2159 -- Out Parameters:
2160 -- Name Reqd Type Description
2161 -- p_eligy_prfl_id Yes number PK of record
2162 --
2163 -- Post Failure:
2164 --
2165 --
2166 -- Access Status:
2167 -- Public.
2168 --
2169 -- {End Of Comments}
2170 --
2171 procedure create_eligy_job
2172 (p_validate in number default hr_api.g_false_num
2173 ,p_elig_job_prte_id in out nocopy number
2174 ,p_effective_start_date out nocopy date
2175 ,p_effective_end_date out nocopy date
2176 ,p_business_group_id in number default null
2177 ,p_eligy_prfl_id in number default null
2178 ,p_job_id in number default null
2179 ,p_ordr_num in number default null
2180 ,p_object_version_number out nocopy number
2181 ,p_effective_date in date
2182 ) is
2183 --
2184 -- Variables for API Boolean parameters
2185 l_validate boolean;
2186
2187 --
2188 -- Other variables
2189 l_proc varchar2(72) := g_package ||'create_eligy_job';
2190 begin
2191 hr_utility.set_location(' Entering:' || l_proc,10);
2192 --
2193 -- Issue a savepoint
2194 --
2195 savepoint create_eligy_job_swi;
2196 --
2197 -- Initialise Multiple Message Detection
2198 --
2199 hr_multi_message.enable_message_list;
2200 --
2201 -- Remember IN OUT parameter IN values
2202 --
2203 --
2204 -- Convert constant values to their corresponding boolean value
2205 --
2206 l_validate :=
2207 hr_api.constant_to_boolean
2208 (p_constant_value => p_validate);
2209 --
2210 -- Register Surrogate ID or user key values
2211 --
2212 --
2213 ben_ejp_ins.set_base_key_value(p_elig_job_prte_id => p_elig_job_prte_id);
2214 -- Call API
2215 --
2216 hr_objective_library_api.create_eligy_job
2217 (p_validate => l_validate
2218 ,p_elig_job_prte_id => p_elig_job_prte_id
2219 ,p_effective_start_date => p_effective_start_date
2220 ,p_effective_end_date => p_effective_end_date
2221 ,p_business_group_id => p_business_group_id
2222 ,p_eligy_prfl_id => p_eligy_prfl_id
2223 ,p_job_id => p_job_id
2224 ,p_ordr_num => p_ordr_num
2225 ,p_object_version_number => p_object_version_number
2226 ,p_effective_date => p_effective_date
2227 );
2228
2229 hr_utility.set_location(' Leaving:' || l_proc,20);
2230 --
2231
2232 exception
2233 when hr_multi_message.error_message_exist then
2234 --
2235 -- Catch the Multiple Message List exception which
2236 -- indicates API processing has been aborted because
2237 -- at least one message exists in the list.
2238 --
2239 rollback to create_eligy_job_swi;
2240 --
2241 --
2242 -- Reset IN OUT parameters and set OUT parameters
2243 --
2244 p_elig_job_prte_id := null;
2245 p_effective_start_date := null;
2246 p_effective_end_date := null;
2247 p_object_version_number := null;
2248
2249 hr_utility.set_location(' Leaving:' || l_proc, 30);
2250
2251 end create_eligy_job;
2252 --
2253 -- ----------------------------------------------------------------------------
2254 -- |-------------------------< update_eligy_job >------------------------|
2255 -- ----------------------------------------------------------------------------
2256 -- {Start Of Comments}
2257 --
2258 -- Description:
2259 --
2260 --
2261 -- Prerequisites:
2262 --
2263 --
2264 -- In Parameters:
2265 -- Name Reqd Type Description
2266 -- p_validate Yes boolean Commit or Rollback.
2267 --
2268 -- Post Success:
2269 --
2270 -- Out Parameters:
2271 -- Name Reqd Type Description
2272 -- p_eligy_prfl_id Yes number PK of record
2273 --
2274 -- Post Failure:
2275 --
2276 --
2277 -- Access Status:
2278 -- Public.
2279 --
2280 -- {End Of Comments}
2281 --
2282 procedure update_eligy_job
2283 (p_validate in number default hr_api.g_false_num
2284 ,p_elig_job_prte_id in number
2285 ,p_effective_start_date out nocopy date
2286 ,p_effective_end_date out nocopy date
2287 ,p_business_group_id in number default hr_api.g_number
2288 ,p_eligy_prfl_id in number default hr_api.g_number
2289 ,p_job_id in number default hr_api.g_number
2290 ,p_object_version_number in out nocopy number
2291 ,p_effective_date in date
2292 ,p_datetrack_mode in varchar2
2293 ) is
2294 --
2295 -- Variables for API Boolean parameters
2296 l_validate boolean;
2297 --
2298 -- Other variables
2299 l_proc varchar2(72) := g_package ||'update_eligy_job';
2300
2301 begin
2302 hr_utility.set_location(' Entering:' || l_proc,10);
2303 --
2304 -- Issue a savepoint
2305 --
2306 savepoint update_eligy_job_swi;
2307 --
2308 -- Initialise Multiple Message Detection
2309 --
2310 hr_multi_message.enable_message_list;
2311 --
2312 -- Remember IN OUT parameter IN values
2313 --
2314 --
2315 -- Convert constant values to their corresponding boolean value
2316 --
2317 l_validate :=
2318 hr_api.constant_to_boolean
2319 (p_constant_value => p_validate);
2320 --
2321 -- Register Surrogate ID or user key values
2322 --
2323 --
2324 -- Call API
2325 --
2326 hr_objective_library_api.update_eligy_job
2327 (p_validate => l_validate
2328 ,p_elig_job_prte_id => p_elig_job_prte_id
2329 ,p_effective_start_date => p_effective_start_date
2330 ,p_effective_end_date => p_effective_end_date
2331 ,p_business_group_id => p_business_group_id
2332 ,p_eligy_prfl_id => p_eligy_prfl_id
2333 ,p_job_id => p_job_id
2334 ,p_object_version_number => p_object_version_number
2335 ,p_effective_date => p_effective_date
2336 ,p_datetrack_mode => p_datetrack_mode
2337 );
2338
2339 hr_utility.set_location(' Leaving:' || l_proc,20);
2340 --
2341 exception
2342 when hr_multi_message.error_message_exist then
2343 --
2344 -- Catch the Multiple Message List exception which
2345 -- indicates API processing has been aborted because
2346 -- at least one message exists in the list.
2347 --
2348 rollback to update_eligy_job_swi;
2349 --
2350 -- Reset IN OUT parameters and set OUT parameters
2351 --
2352 p_effective_start_date := null;
2353 p_effective_end_date := null;
2354 p_object_version_number := null;
2355
2356 hr_utility.set_location(' Leaving:' || l_proc, 30);
2357
2358 end update_eligy_job;
2359 --
2360 -- ----------------------------------------------------------------------------
2361 -- |----------------------------< delete_eligy_job >--------------------------|
2362 -- ----------------------------------------------------------------------------
2363 -- {Start Of Comments}
2364 --
2365 -- Description:
2366 --
2367 --
2368 -- Prerequisites:
2369 --
2370 --
2371 -- In Parameters:
2372 -- Name Reqd Type Description
2373 -- p_validate Yes boolean Commit or Rollback.
2374 --
2375 -- Post Success:
2376 --
2377 -- Out Parameters:
2378 -- Name Reqd Type Description
2379 -- p_eligy_prfl_id Yes number PK of record
2380 --
2381 -- Post Failure:
2382 --
2383 --
2384 -- Access Status:
2385 -- Public.
2386 --
2387 -- {End Of Comments}
2388 --
2389 procedure delete_eligy_job
2390 (p_validate in number default hr_api.g_false_num
2391 ,p_elig_job_prte_id in number
2392 ,p_effective_start_date out nocopy date
2393 ,p_effective_end_date out nocopy date
2394 ,p_object_version_number in out nocopy number
2395 ,p_effective_date in date
2396 ,p_datetrack_mode in varchar2
2397 ) is
2398 --
2399 -- Variables for API Boolean parameters
2400 l_validate boolean;
2401 --
2402 -- Other variables
2403 l_proc varchar2(72) := g_package ||'delete_eligy_job';
2404
2405 begin
2406 hr_utility.set_location(' Entering:' || l_proc,10);
2407 --
2408 -- Issue a savepoint
2409 --
2410 savepoint delete_eligy_job_swi;
2411 --
2412 -- Initialise Multiple Message Detection
2413 --
2414 hr_multi_message.enable_message_list;
2415 --
2416 -- Remember IN OUT parameter IN values
2417 --
2418 --
2419 -- Convert constant values to their corresponding boolean value
2420 --
2421 l_validate :=
2422 hr_api.constant_to_boolean
2423 (p_constant_value => p_validate);
2424 --
2425 -- Register Surrogate ID or user key values
2426 --
2427 --
2428 -- Call API
2429 --
2430 hr_objective_library_api.delete_eligy_job
2431 (p_validate => l_validate
2432 ,p_elig_job_prte_id => p_elig_job_prte_id
2433 ,p_effective_start_date => p_effective_start_date
2434 ,p_effective_end_date => p_effective_end_date
2435 ,p_object_version_number => p_object_version_number
2436 ,p_effective_date => p_effective_date
2437 ,p_datetrack_mode => p_datetrack_mode
2438 );
2439
2440 hr_utility.set_location(' Leaving:' || l_proc,20);
2441 --
2442 exception
2443 when hr_multi_message.error_message_exist then
2444 --
2445 -- Catch the Multiple Message List exception which
2446 -- indicates API processing has been aborted because
2447 -- at least one message exists in the list.
2448 --
2449 rollback to delete_eligy_job_swi;
2450 --
2451 -- Reset IN OUT parameters and set OUT parameters
2452 --
2453 p_effective_start_date := null;
2454 p_effective_end_date := null;
2455 p_object_version_number := null;
2456
2457 hr_utility.set_location(' Leaving:' || l_proc, 30);
2458
2459 end delete_eligy_job;
2460 --
2461 --
2462 -- ----------------------------------------------------------------------------
2463 -- |----------------------------< create_eligy_position>------------------------|
2464 -- ----------------------------------------------------------------------------
2465 -- {Start Of Comments}
2466 --
2467 -- Description:
2468 --
2469 --
2470 -- Prerequisites:
2471 --
2472 --
2473 -- In Parameters:
2474 -- Name Reqd Type Description
2475 -- p_validate Yes boolean Commit or Rollback.
2476 --
2477 -- Post Success:
2478 --
2479 -- Out Parameters:
2480 -- Name Reqd Type Description
2481 -- p_eligy_prfl_id Yes number PK of record
2482 --
2483 -- Post Failure:
2484 --
2485 --
2486 -- Access Status:
2487 -- Public.
2488 --
2489 -- {End Of Comments}
2490 --
2491 procedure create_eligy_position
2492 (p_validate in number default hr_api.g_false_num
2493 ,p_elig_pstn_prte_id in out nocopy number
2494 ,p_effective_start_date out nocopy date
2495 ,p_effective_end_date out nocopy date
2496 ,p_business_group_id in number default null
2497 ,p_eligy_prfl_id in number default null
2498 ,p_position_id in number default null
2499 ,p_ordr_num in number default null
2500 ,p_object_version_number out nocopy number
2501 ,p_effective_date in date
2502 ) is
2503 --
2504 -- Variables for API Boolean parameters
2505 l_validate boolean;
2506
2507 --
2508 -- Other variables
2509 l_proc varchar2(72) := g_package ||'create_eligy_position';
2510 begin
2511 hr_utility.set_location(' Entering:' || l_proc,10);
2512 --
2513 -- Issue a savepoint
2514 --
2515 savepoint create_eligy_position_swi;
2516 --
2517 -- Initialise Multiple Message Detection
2518 --
2519 hr_multi_message.enable_message_list;
2520 --
2521 -- Remember IN OUT parameter IN values
2522 --
2523 --
2524 -- Convert constant values to their corresponding boolean value
2525 --
2526 l_validate :=
2527 hr_api.constant_to_boolean
2528 (p_constant_value => p_validate);
2529 --
2530 -- Register Surrogate ID or user key values
2531 --
2532 ben_eps_ins.set_base_key_value(p_elig_pstn_prte_id => p_elig_pstn_prte_id);
2533 --
2534 -- Call API
2535 --
2536 hr_objective_library_api.create_eligy_position
2537 (p_validate => l_validate
2538 ,p_elig_pstn_prte_id => p_elig_pstn_prte_id
2539 ,p_effective_start_date => p_effective_start_date
2540 ,p_effective_end_date => p_effective_end_date
2541 ,p_business_group_id => p_business_group_id
2542 ,p_eligy_prfl_id => p_eligy_prfl_id
2543 ,p_position_id => p_position_id
2544 ,p_ordr_num => p_ordr_num
2545 ,p_object_version_number => p_object_version_number
2546 ,p_effective_date => p_effective_date
2547 );
2548
2549 hr_utility.set_location(' Leaving:' || l_proc,20);
2550 --
2551
2552 exception
2553 when hr_multi_message.error_message_exist then
2554 --
2555 -- Catch the Multiple Message List exception which
2556 -- indicates API processing has been aborted because
2557 -- at least one message exists in the list.
2558 --
2559 rollback to create_eligy_position_swi;
2560 --
2561 --
2562 -- Reset IN OUT parameters and set OUT parameters
2563 --
2564 p_elig_pstn_prte_id := null;
2565 p_effective_start_date := null;
2566 p_effective_end_date := null;
2567 p_object_version_number := null;
2568
2569 hr_utility.set_location(' Leaving:' || l_proc, 30);
2570
2571 end create_eligy_position;
2572 --
2573 -- ----------------------------------------------------------------------------
2574 -- |-------------------------< update_eligy_position >------------------------|
2575 -- ----------------------------------------------------------------------------
2576 -- {Start Of Comments}
2577 --
2578 -- Description:
2579 --
2580 --
2581 -- Prerequisites:
2582 --
2583 --
2584 -- In Parameters:
2585 -- Name Reqd Type Description
2586 -- p_validate Yes boolean Commit or Rollback.
2587 --
2588 -- Post Success:
2589 --
2590 -- Out Parameters:
2591 -- Name Reqd Type Description
2592 -- p_eligy_prfl_id Yes number PK of record
2593 --
2594 -- Post Failure:
2595 --
2596 --
2597 -- Access Status:
2598 -- Public.
2599 --
2600 -- {End Of Comments}
2601 --
2602 procedure update_eligy_position
2603 (p_validate in number default hr_api.g_false_num
2604 ,p_elig_pstn_prte_id in number
2605 ,p_effective_start_date out nocopy date
2606 ,p_effective_end_date out nocopy date
2607 ,p_business_group_id in number default hr_api.g_number
2608 ,p_eligy_prfl_id in number default hr_api.g_number
2609 ,p_position_id in number default hr_api.g_number
2610 ,p_object_version_number in out nocopy number
2611 ,p_effective_date in date
2612 ,p_datetrack_mode in varchar2
2613 ) is
2614 --
2615 -- Variables for API Boolean parameters
2616 l_validate boolean;
2617 --
2618 -- Other variables
2619 l_proc varchar2(72) := g_package ||'update_eligy_position';
2620
2621 begin
2622 hr_utility.set_location(' Entering:' || l_proc,10);
2623 --
2624 -- Issue a savepoint
2625 --
2626 savepoint update_eligy_position_swi;
2627 --
2628 -- Initialise Multiple Message Detection
2629 --
2630 hr_multi_message.enable_message_list;
2631 --
2632 -- Remember IN OUT parameter IN values
2633 --
2634 --
2635 -- Convert constant values to their corresponding boolean value
2636 --
2637 l_validate :=
2638 hr_api.constant_to_boolean
2639 (p_constant_value => p_validate);
2640 --
2641 -- Register Surrogate ID or user key values
2642 --
2643 --
2644 -- Call API
2645 --
2646 hr_objective_library_api.update_eligy_position
2647 (p_validate => l_validate
2648 ,p_elig_pstn_prte_id => p_elig_pstn_prte_id
2649 ,p_effective_start_date => p_effective_start_date
2650 ,p_effective_end_date => p_effective_end_date
2651 ,p_business_group_id => p_business_group_id
2652 ,p_eligy_prfl_id => p_eligy_prfl_id
2653 ,p_position_id => p_position_id
2654 ,p_object_version_number => p_object_version_number
2655 ,p_effective_date => p_effective_date
2656 ,p_datetrack_mode => p_datetrack_mode
2657 );
2658
2659 hr_utility.set_location(' Leaving:' || l_proc,20);
2660 --
2661 exception
2662 when hr_multi_message.error_message_exist then
2663 --
2664 -- Catch the Multiple Message List exception which
2665 -- indicates API processing has been aborted because
2666 -- at least one message exists in the list.
2667 --
2668 rollback to update_eligy_position_swi;
2669 --
2670 -- Reset IN OUT parameters and set OUT parameters
2671 --
2672 p_effective_start_date := null;
2673 p_effective_end_date := null;
2674 p_object_version_number := null;
2675
2676 hr_utility.set_location(' Leaving:' || l_proc, 30);
2677
2678 end update_eligy_position;
2679 --
2680 -- ----------------------------------------------------------------------------
2681 -- |-----------------------< delete_eligy_position >--------------------------|
2682 -- ----------------------------------------------------------------------------
2683 -- {Start Of Comments}
2684 --
2685 -- Description:
2686 --
2687 --
2688 -- Prerequisites:
2689 --
2690 --
2691 -- In Parameters:
2692 -- Name Reqd Type Description
2693 -- p_validate Yes boolean Commit or Rollback.
2694 --
2695 -- Post Success:
2696 --
2697 -- Out Parameters:
2698 -- Name Reqd Type Description
2699 -- p_eligy_prfl_id Yes number PK of record
2700 --
2701 -- Post Failure:
2702 --
2703 --
2704 -- Access Status:
2705 -- Public.
2706 --
2707 -- {End Of Comments}
2708 --
2709 procedure delete_eligy_position
2710 (p_validate in number default hr_api.g_false_num
2711 ,p_elig_pstn_prte_id in number
2712 ,p_effective_start_date out nocopy date
2713 ,p_effective_end_date out nocopy date
2714 ,p_object_version_number in out nocopy number
2715 ,p_effective_date in date
2716 ,p_datetrack_mode in varchar2
2717 ) is
2718 --
2719 -- Variables for API Boolean parameters
2720 l_validate boolean;
2721 --
2722 -- Other variables
2723 l_proc varchar2(72) := g_package ||'delete_eligy_position';
2724
2725 begin
2726 hr_utility.set_location(' Entering:' || l_proc,10);
2727 --
2728 -- Issue a savepoint
2729 --
2730 savepoint delete_eligy_position_swi;
2731 --
2732 -- Initialise Multiple Message Detection
2733 --
2734 hr_multi_message.enable_message_list;
2735 --
2736 -- Remember IN OUT parameter IN values
2737 --
2738 --
2739 -- Convert constant values to their corresponding boolean value
2740 --
2741 l_validate :=
2742 hr_api.constant_to_boolean
2743 (p_constant_value => p_validate);
2744 --
2745 -- Register Surrogate ID or user key values
2746 --
2747 --
2748 -- Call API
2749 --
2750 hr_objective_library_api.delete_eligy_position
2751 (p_validate => l_validate
2752 ,p_elig_pstn_prte_id => p_elig_pstn_prte_id
2753 ,p_effective_start_date => p_effective_start_date
2754 ,p_effective_end_date => p_effective_end_date
2755 ,p_object_version_number => p_object_version_number
2756 ,p_effective_date => p_effective_date
2757 ,p_datetrack_mode => p_datetrack_mode
2758 );
2759
2760 hr_utility.set_location(' Leaving:' || l_proc,20);
2761 --
2762 exception
2763 when hr_multi_message.error_message_exist then
2764 --
2765 -- Catch the Multiple Message List exception which
2766 -- indicates API processing has been aborted because
2767 -- at least one message exists in the list.
2768 --
2769 rollback to delete_eligy_position_swi;
2770 --
2771 -- Reset IN OUT parameters and set OUT parameters
2772 --
2773 p_effective_start_date := null;
2774 p_effective_end_date := null;
2775 p_object_version_number := null;
2776
2777 hr_utility.set_location(' Leaving:' || l_proc, 30);
2778
2779 end delete_eligy_position;
2780 --
2781
2782 end hr_objective_library_swi;