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