1 Package hr_objective_library_swi As
2 /* $Header: pepmlswi.pkh 120.1.12010000.1 2008/07/28 05:22:26 appldev ship $ */
3 -- ----------------------------------------------------------------------------
4 -- |-----------------------< create_library_objective >-----------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: hr_objective_library_api.create_library_objective
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_library_objective
27 (p_validate in number default hr_api.g_false_num
28 ,p_effective_date in date
29 ,p_objective_name in varchar2
30 ,p_valid_from in date default null
31 ,p_valid_to in date default null
32 ,p_target_date in date default null
33 ,p_next_review_date in date default null
34 ,p_group_code in varchar2 default null
35 ,p_priority_code in varchar2 default null
36 ,p_appraise_flag in varchar2 default 'Y'
37 ,p_weighting_percent in number default null
38 ,p_measurement_style_code in varchar2 default 'N_M'
39 ,p_measure_name in varchar2 default null
40 ,p_target_value in number default null
41 ,p_uom_code in varchar2 default null
42 ,p_measure_type_code in varchar2 default null
43 ,p_measure_comments in varchar2 default null
44 ,p_eligibility_type_code in varchar2 default 'N_P'
45 ,p_details in varchar2 default null
46 ,p_success_criteria in varchar2 default null
47 ,p_comments in varchar2 default null
48 ,p_attribute_category in varchar2 default null
49 ,p_attribute1 in varchar2 default null
50 ,p_attribute2 in varchar2 default null
51 ,p_attribute3 in varchar2 default null
52 ,p_attribute4 in varchar2 default null
53 ,p_attribute5 in varchar2 default null
54 ,p_attribute6 in varchar2 default null
55 ,p_attribute7 in varchar2 default null
56 ,p_attribute8 in varchar2 default null
57 ,p_attribute9 in varchar2 default null
58 ,p_attribute10 in varchar2 default null
59 ,p_attribute11 in varchar2 default null
60 ,p_attribute12 in varchar2 default null
61 ,p_attribute13 in varchar2 default null
62 ,p_attribute14 in varchar2 default null
63 ,p_attribute15 in varchar2 default null
64 ,p_attribute16 in varchar2 default null
65 ,p_attribute17 in varchar2 default null
66 ,p_attribute18 in varchar2 default null
67 ,p_attribute19 in varchar2 default null
68 ,p_attribute20 in varchar2 default null
69 ,p_attribute21 in varchar2 default null
70 ,p_attribute22 in varchar2 default null
71 ,p_attribute23 in varchar2 default null
72 ,p_attribute24 in varchar2 default null
73 ,p_attribute25 in varchar2 default null
74 ,p_attribute26 in varchar2 default null
75 ,p_attribute27 in varchar2 default null
76 ,p_attribute28 in varchar2 default null
77 ,p_attribute29 in varchar2 default null
78 ,p_attribute30 in varchar2 default null
79 ,p_objective_id in out nocopy number
80 ,p_object_version_number out nocopy number
81 ,p_return_status out nocopy varchar2
82 );
83 -- ----------------------------------------------------------------------------
84 -- |-----------------------< delete_library_objective >-----------------------|
85 -- ----------------------------------------------------------------------------
86 -- {Start of comments}
87 --
88 -- Description:
89 -- This procedure is the self-service wrapper procedure to the following
90 -- API: hr_objective_library_api.delete_library_objective
91 --
92 -- Pre-requisites
93 -- All 'IN' parameters to this procedure have been appropriately derived.
94 --
95 -- Post Success:
96 -- p_return_status will return value indicating success.
97 --
98 -- Post Failure:
99 -- p_return_status will return value indication failure.
100 --
101 -- Access Status:
102 -- Internal Development use only.
103 --
104 -- {End of comments}
105 -- ----------------------------------------------------------------------------
106 PROCEDURE delete_library_objective
107 (p_validate in number default hr_api.g_false_num
108 ,p_objective_id in number
109 ,p_object_version_number in number
110 ,p_return_status out nocopy varchar2
111 );
112 -- ----------------------------------------------------------------------------
113 -- |-----------------------< update_library_objective >-----------------------|
114 -- ----------------------------------------------------------------------------
115 -- {Start of comments}
116 --
117 -- Description:
118 -- This procedure is the self-service wrapper procedure to the following
119 -- API: hr_objective_library_api.update_library_objective
120 --
121 -- Pre-requisites
122 -- All 'IN' parameters to this procedure have been appropriately derived.
123 --
124 -- Post Success:
125 -- p_return_status will return value indicating success.
126 --
127 -- Post Failure:
128 -- p_return_status will return value indication failure.
129 --
130 -- Access Status:
131 -- Internal Development use only.
132 --
133 -- {End of comments}
134 -- ----------------------------------------------------------------------------
135 PROCEDURE update_library_objective
136 (p_validate in number default hr_api.g_false_num
137 ,p_effective_date in date
138 ,p_objective_id in number
139 ,p_objective_name in varchar2 default hr_api.g_varchar2
140 ,p_valid_from in date default hr_api.g_date
141 ,p_valid_to in date default hr_api.g_date
142 ,p_target_date in date default hr_api.g_date
143 ,p_next_review_date in date default hr_api.g_date
144 ,p_group_code in varchar2 default hr_api.g_varchar2
145 ,p_priority_code in varchar2 default hr_api.g_varchar2
146 ,p_appraise_flag in varchar2 default hr_api.g_varchar2
147 ,p_weighting_percent in number default hr_api.g_number
148 ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
149 ,p_measure_name in varchar2 default hr_api.g_varchar2
150 ,p_target_value in number default hr_api.g_number
151 ,p_uom_code in varchar2 default hr_api.g_varchar2
152 ,p_measure_type_code in varchar2 default hr_api.g_varchar2
153 ,p_measure_comments in varchar2 default hr_api.g_varchar2
154 ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
155 ,p_details in varchar2 default hr_api.g_varchar2
156 ,p_success_criteria in varchar2 default hr_api.g_varchar2
157 ,p_comments in varchar2 default hr_api.g_varchar2
158 ,p_attribute_category in varchar2 default hr_api.g_varchar2
159 ,p_attribute1 in varchar2 default hr_api.g_varchar2
160 ,p_attribute2 in varchar2 default hr_api.g_varchar2
161 ,p_attribute3 in varchar2 default hr_api.g_varchar2
162 ,p_attribute4 in varchar2 default hr_api.g_varchar2
163 ,p_attribute5 in varchar2 default hr_api.g_varchar2
164 ,p_attribute6 in varchar2 default hr_api.g_varchar2
165 ,p_attribute7 in varchar2 default hr_api.g_varchar2
166 ,p_attribute8 in varchar2 default hr_api.g_varchar2
167 ,p_attribute9 in varchar2 default hr_api.g_varchar2
168 ,p_attribute10 in varchar2 default hr_api.g_varchar2
169 ,p_attribute11 in varchar2 default hr_api.g_varchar2
170 ,p_attribute12 in varchar2 default hr_api.g_varchar2
171 ,p_attribute13 in varchar2 default hr_api.g_varchar2
172 ,p_attribute14 in varchar2 default hr_api.g_varchar2
173 ,p_attribute15 in varchar2 default hr_api.g_varchar2
174 ,p_attribute16 in varchar2 default hr_api.g_varchar2
175 ,p_attribute17 in varchar2 default hr_api.g_varchar2
176 ,p_attribute18 in varchar2 default hr_api.g_varchar2
177 ,p_attribute19 in varchar2 default hr_api.g_varchar2
178 ,p_attribute20 in varchar2 default hr_api.g_varchar2
179 ,p_attribute21 in varchar2 default hr_api.g_varchar2
180 ,p_attribute22 in varchar2 default hr_api.g_varchar2
181 ,p_attribute23 in varchar2 default hr_api.g_varchar2
182 ,p_attribute24 in varchar2 default hr_api.g_varchar2
183 ,p_attribute25 in varchar2 default hr_api.g_varchar2
184 ,p_attribute26 in varchar2 default hr_api.g_varchar2
185 ,p_attribute27 in varchar2 default hr_api.g_varchar2
186 ,p_attribute28 in varchar2 default hr_api.g_varchar2
187 ,p_attribute29 in varchar2 default hr_api.g_varchar2
188 ,p_attribute30 in varchar2 default hr_api.g_varchar2
189 ,p_object_version_number in out nocopy number
190 ,p_return_status out nocopy varchar2
191 );
192 --
193 -- ----------------------------------------------------------------------------
194 -- |-------------------------< create_eligy_profile >-------------------------|
195 -- ----------------------------------------------------------------------------
196 -- {Start Of Comments}
197 --
198 -- Description:
199 --
200 --
201 -- Prerequisites:
202 --
203 --
204 -- In Parameters:
205 -- Name Reqd Type Description
206 -- p_validate Yes number Commit or Rollback.
207 -- p_name Yes varchar2
208 -- p_elig_pstn_flag No varchar2
209 -- p_elig_grd_flag No varchar2
210 -- p_elig_org_unit_flag No varchar2
211 -- p_elig_job_flag No varchar2
212 --
213 -- Post Success:
214 --
215 -- Out Parameters:
216 -- Name Reqd Type Description
217 -- p_eligy_prfl_id Yes number PK of record
218 --
219 -- Post Failure:
220 --
221 --
222 -- Access Status:
223 -- Public.
224 --
225 -- {End Of Comments}
226 --
227 procedure create_eligy_profile
228 (p_validate in number default hr_api.g_false_num
229 ,p_name in varchar2 default null
230 ,p_bnft_cagr_prtn_cd in varchar2 default null
231 ,p_stat_cd in varchar2 default null
232 ,p_asmt_to_use_cd in varchar2 default null
233 ,p_eligy_prfl_id in out nocopy number
234 ,p_elig_grd_flag in varchar2 default 'N'
235 ,p_elig_org_unit_flag in varchar2 default 'N'
236 ,p_elig_job_flag in varchar2 default 'N'
237 ,p_elig_pstn_flag in varchar2 default 'N'
238 ,p_object_version_number out nocopy number
239 ,p_business_group_id in number
240 ,p_effective_date in date
241 ,p_effective_start_date out nocopy date
242 ,p_effective_end_date out nocopy date
243 ,p_return_status out nocopy varchar2
244 );
245
246 -- ----------------------------------------------------------------------------
247 -- |-------------------------< update_eligy_profile >-------------------------|
248 -- ----------------------------------------------------------------------------
249 -- {Start Of Comments}
250 --
251 -- Description:
252 --
253 --
254 -- Prerequisites:
255 --
256 --
257 -- In Parameters:
258
259
260 procedure update_eligy_profile
261 ( p_validate in number default hr_api.g_false_num
262 ,p_effective_date in date
263 ,p_business_group_id in number
264 ,p_name in varchar2 default null
265 ,p_bnft_cagr_prtn_cd in varchar2 default null
266 ,p_stat_cd in varchar2 default null
267 ,p_asmt_to_use_cd in varchar2 default null
268 ,p_elig_grd_flag in varchar2 default 'N'
269 ,p_elig_org_unit_flag in varchar2 default 'N'
270 ,p_elig_job_flag in varchar2 default 'N'
271 ,p_elig_pstn_flag in varchar2 default 'N'
272 ,p_eligy_prfl_id in number
273 ,p_object_version_number in out nocopy number
274 ,p_effective_start_date out nocopy date
275 ,p_effective_end_date out nocopy date
276 ,p_datetrack_mode in varchar2
277 ,p_return_status out nocopy varchar2
278 );
279 --
280 -- ----------------------------------------------------------------------------
281 -- |--------------------------< create_eligy_object >-------------------------|
282 -- ----------------------------------------------------------------------------
283 -- {Start Of Comments}
284 --
285 -- Description:
286 --
287 --
288 -- Prerequisites:
289 --
290 --
291 -- In Parameters:
292 -- Name Reqd Type Description
293 -- p_validate Yes number Commit or Rollback.
294 --
295 -- Post Success:
296 --
297 -- Out Parameters:
298 -- Name Reqd Type Description
299 --
300 -- Post Failure:
301 --
302 --
303 -- Access Status:
304 -- Public.
305 --
306 -- {End Of Comments}
307 --
308 procedure create_eligy_object
309 (p_validate in number default hr_api.g_false_num
310 ,p_elig_obj_id in out nocopy number
311 ,p_effective_start_date out nocopy date
312 ,p_effective_end_date out nocopy date
313 ,p_business_group_id in number
314 ,p_table_name in varchar2
315 ,p_column_name in varchar2
316 ,p_column_value in varchar2
317 ,p_object_version_number out nocopy number
318 ,p_effective_date in date
319 );
320 --
321 -- ----------------------------------------------------------------------------
322 -- |--------------------------< update_eligy_object >-------------------------|
323 -- ----------------------------------------------------------------------------
324 -- {Start Of Comments}
325 --
326 -- Description:
327 --
328 --
329 -- Prerequisites:
330 --
331 --
332 -- In Parameters:
333 -- Name Reqd Type Description
334 -- p_validate Yes number Commit or Rollback.
335 --
336 -- Post Success:
337 --
338 -- Out Parameters:
339 -- Name Reqd Type Description
340 --
341 -- Post Failure:
342 --
343 --
344 -- Access Status:
345 -- Public.
346 --
347 -- {End Of Comments}
348 --
349 procedure update_eligy_object
350 (p_validate in number default hr_api.g_false_num
351 ,p_elig_obj_id in number
352 ,p_effective_start_date out nocopy date
353 ,p_effective_end_date out nocopy date
354 ,p_business_group_id in number default hr_api.g_number
355 ,p_table_name in varchar2 default hr_api.g_varchar2
356 ,p_column_name in varchar2 default hr_api.g_varchar2
357 ,p_column_value in varchar2 default hr_api.g_varchar2
358 ,p_object_version_number in out nocopy number
359 ,p_effective_date in date
360 ,p_datetrack_mode in varchar2
361 );
362 --
363 -- ----------------------------------------------------------------------------
364 -- |--------------------------< delete_eligy_object >-------------------------|
365 -- ----------------------------------------------------------------------------
366 -- {Start Of Comments}
367 --
368 -- Description:
369 --
370 --
371 -- Prerequisites:
372 --
373 --
374 -- In Parameters:
375 -- Name Reqd Type Description
376 -- p_validate Yes number Commit or Rollback.
377 --
378 -- Post Success:
379 --
380 -- Out Parameters:
381 -- Name Reqd Type Description
382 --
383 -- Post Failure:
384 --
385 --
386 -- Access Status:
387 -- Public.
388 --
389 -- {End Of Comments}
390 --
391 procedure delete_eligy_object
392 (p_validate in number default hr_api.g_false_num
393 ,p_elig_obj_id in number
394 ,p_effective_start_date out nocopy date
395 ,p_effective_end_date out nocopy date
396 ,p_object_version_number in out nocopy number
397 ,p_effective_date in date
398 ,p_datetrack_mode in varchar2
399 );
400 --
401 -- ----------------------------------------------------------------------------
402 -- |-----------------------< create_elig_obj_elig_prfl >----------------------|
403 -- ----------------------------------------------------------------------------
404 -- {Start Of Comments}
405 --
406 -- Description:
407 --
408 --
409 -- Prerequisites:
410 --
411 --
412 -- In Parameters:
413 -- Name Reqd Type Description
414 -- p_validate Yes boolean Commit or Rollback.
415 --
416 -- Post Success:
417 --
418 -- Out Parameters:
419 -- Name Reqd Type Description
420 --
421 -- Post Failure:
422 --
423 --
424 -- Access Status:
425 -- Public.
426 --
427 -- {End Of Comments}
428 --
429 procedure create_elig_obj_elig_prfl
430 (p_validate in number default hr_api.g_false_num
431 ,p_elig_obj_elig_prfl_id in out nocopy number
432 ,p_effective_start_date out nocopy date
433 ,p_effective_end_date out nocopy date
434 ,p_business_group_id in number default null
435 ,p_elig_obj_id in number default null
436 ,p_elig_prfl_id in number default null
437 ,p_object_version_number out nocopy number
438 ,p_effective_date in date
439 );
440 -- ----------------------------------------------------------------------------
441 -- |-----------------------< update_elig_obj_elig_prfl >----------------------|
442 -- ----------------------------------------------------------------------------
443 -- {Start Of Comments}
444 --
445 -- Description:
446 --
447 --
448 -- Prerequisites:
449 --
450 --
451 -- In Parameters:
452 -- Name Reqd Type Description
453 -- p_validate Yes boolean Commit or Rollback.
454 --
455 -- Post Success:
456 --
457 -- Out Parameters:
458 -- Name Reqd Type Description
459 --
460 -- Post Failure:
461 --
462 --
463 -- Access Status:
464 -- Public.
465 --
466 -- {End Of Comments}
467 --
468 procedure update_elig_obj_elig_prfl
469 (p_validate in number default hr_api.g_false_num
470 ,p_elig_obj_elig_prfl_id in number
471 ,p_effective_start_date out nocopy date
472 ,p_effective_end_date out nocopy date
473 ,p_elig_obj_id in number default hr_api.g_number
474 ,p_elig_prfl_id in number default hr_api.g_number
475 ,p_object_version_number in out nocopy number
476 ,p_effective_date in date
477 ,p_datetrack_mode in varchar2
478 );
479 --
480 -- ----------------------------------------------------------------------------
481 -- |-----------------------< delete_elig_obj_elig_prfl >----------------------|
482 -- ----------------------------------------------------------------------------
483 -- {Start Of Comments}
484 --
485 -- Description:
486 --
487 --
488 -- Prerequisites:
489 --
490 --
491 -- In Parameters:
492 -- Name Reqd Type Description
493 -- p_validate Yes number Commit or Rollback.
494 --
495 -- Post Success:
496 --
497 -- Out Parameters:
498 -- Name Reqd Type Description
499 --
500 -- Post Failure:
501 --
502 --
503 -- Access Status:
504 -- Public.
505 --
506 -- {End Of Comments}
507 --
508 procedure delete_elig_obj_elig_prfl
509 (p_validate in number default hr_api.g_false_num
510 ,p_elig_obj_elig_prfl_id in number
511 ,p_effective_start_date out nocopy date
512 ,p_effective_end_date out nocopy date
513 ,p_object_version_number in out nocopy number
514 ,p_effective_date in date
515 ,p_datetrack_mode in varchar2
516 );
517 --
518 -- ----------------------------------------------------------------------------
519 -- |----------------------------< create_eligy_grade >------------------------|
520 -- ----------------------------------------------------------------------------
521 -- {Start Of Comments}
522 --
523 -- Description:
524 --
525 --
526 -- Prerequisites:
527 --
528 --
529 -- In Parameters:
530 -- Name Reqd Type Description
531 -- p_validate Yes boolean Commit or Rollback.
532 --
533 -- Post Success:
534 --
535 -- Out Parameters:
536 -- Name Reqd Type Description
537 -- p_eligy_prfl_id Yes number PK of record
538 --
539 -- Post Failure:
540 --
541 --
542 -- Access Status:
543 -- Public.
544 --
545 -- {End Of Comments}
546 --
547 procedure create_eligy_grade
548 (p_validate in number default hr_api.g_false_num
549 ,p_elig_grd_prte_id in out nocopy number
550 ,p_effective_start_date out nocopy date
551 ,p_effective_end_date out nocopy date
552 ,p_business_group_id in number default null
553 ,p_eligy_prfl_id in number default null
554 ,p_grade_id in number default null
555 ,p_ordr_num in number default null
556 ,p_object_version_number out nocopy number
557 ,p_effective_date in date
558 );
559 --
560 -- ----------------------------------------------------------------------------
561 -- |-------------------------< update_eligy_grade >------------------------|
562 -- ----------------------------------------------------------------------------
563 -- {Start Of Comments}
564 --
565 -- Description:
566 --
567 --
568 -- Prerequisites:
569 --
570 --
571 -- In Parameters:
572 -- Name Reqd Type Description
573 -- p_validate Yes boolean Commit or Rollback.
574 --
575 -- Post Success:
576 --
577 -- Out Parameters:
578 -- Name Reqd Type Description
579 -- p_eligy_prfl_id Yes number PK of record
580 --
581 -- Post Failure:
582 --
583 --
584 -- Access Status:
585 -- Public.
586 --
587 -- {End Of Comments}
588 --
589 procedure update_eligy_grade
590 (p_validate in number default hr_api.g_false_num
591 ,p_elig_grd_prte_id in number
592 ,p_effective_start_date out nocopy date
593 ,p_effective_end_date out nocopy date
594 ,p_business_group_id in number default hr_api.g_number
595 ,p_eligy_prfl_id in number default hr_api.g_number
596 ,p_grade_id in number default hr_api.g_number
597 ,p_object_version_number in out nocopy number
598 ,p_effective_date in date
599 ,p_datetrack_mode in varchar2
600 );
601 --
602 -- ----------------------------------------------------------------------------
603 -- |----------------------------< delete_eligy_grade >--------------------------|
604 -- ----------------------------------------------------------------------------
605 -- {Start Of Comments}
606 --
607 -- Description:
608 --
609 --
610 -- Prerequisites:
611 --
612 --
613 -- In Parameters:
614 -- Name Reqd Type Description
615 -- p_validate Yes boolean Commit or Rollback.
616 --
617 -- Post Success:
618 --
619 -- Out Parameters:
620 -- Name Reqd Type Description
621 -- p_eligy_prfl_id Yes number PK of record
622 --
623 -- Post Failure:
624 --
625 --
626 -- Access Status:
627 -- Public.
628 --
629 -- {End Of Comments}
630 --
631 procedure delete_eligy_grade
632 (p_validate in number default hr_api.g_false_num
633 ,p_elig_grd_prte_id in number
634 ,p_effective_start_date out nocopy date
635 ,p_effective_end_date out nocopy date
636 ,p_object_version_number in out nocopy number
637 ,p_effective_date in date
638 ,p_datetrack_mode in varchar2
639 );
640 --
641 -- ----------------------------------------------------------------------------
642 -- |----------------------------< create_eligy_org >--------------------------|
643 -- ----------------------------------------------------------------------------
644 -- {Start Of Comments}
645 --
646 -- Description:
647 --
648 --
649 -- Prerequisites:
650 --
651 --
652 -- In Parameters:
653 -- Name Reqd Type Description
654 -- p_validate Yes boolean Commit or Rollback.
655 --
656 -- Post Success:
657 --
658 -- Out Parameters:
659 -- Name Reqd Type Description
660 -- p_eligy_prfl_id Yes number PK of record
661 --
662 -- Post Failure:
663 --
664 --
665 -- Access Status:
666 -- Public.
667 --
668 -- {End Of Comments}
669 --
670 procedure create_eligy_org
671 (p_validate in number default hr_api.g_false_num
672 ,p_elig_org_unit_prte_id in out nocopy number
673 ,p_effective_start_date out nocopy date
674 ,p_effective_end_date out nocopy date
675 ,p_business_group_id in number default null
676 ,p_eligy_prfl_id in number default null
677 ,p_organization_id in number default null
678 ,p_ordr_num in number default null
679 ,p_object_version_number out nocopy number
680 ,p_effective_date in date
681 );
682 --
683 -- ----------------------------------------------------------------------------
684 -- |----------------------------< update_eligy_org >--------------------------|
685 -- ----------------------------------------------------------------------------
686 -- {Start Of Comments}
687 --
688 -- Description:
689 --
690 --
691 -- Prerequisites:
692 --
693 --
694 -- In Parameters:
695 -- Name Reqd Type Description
696 -- p_validate Yes boolean Commit or Rollback.
697 --
698 -- Post Success:
699 --
700 -- Out Parameters:
701 -- Name Reqd Type Description
702 -- p_eligy_prfl_id Yes number PK of record
703 --
704 -- Post Failure:
705 --
706 --
707 -- Access Status:
708 -- Public.
709 --
710 -- {End Of Comments}
711 --
712 procedure update_eligy_org
713 (p_validate in number default hr_api.g_false_num
714 ,p_elig_org_unit_prte_id in number
715 ,p_effective_start_date out nocopy date
716 ,p_effective_end_date out nocopy date
717 ,p_business_group_id in number default hr_api.g_number
718 ,p_eligy_prfl_id in number default hr_api.g_number
719 ,p_organization_id in number default hr_api.g_number
720 ,p_object_version_number in out nocopy number
721 ,p_effective_date in date
722 ,p_datetrack_mode in varchar2
723 );
724 --
725 -- ----------------------------------------------------------------------------
726 -- |----------------------------< delete_eligy_org >--------------------------|
727 -- ----------------------------------------------------------------------------
728 -- {Start Of Comments}
729 --
730 -- Description:
731 --
732 --
733 -- Prerequisites:
734 --
735 --
736 -- In Parameters:
737 -- Name Reqd Type Description
738 -- p_validate Yes boolean Commit or Rollback.
739 --
740 -- Post Success:
741 --
742 -- Out Parameters:
743 -- Name Reqd Type Description
744 -- p_eligy_prfl_id Yes number PK of record
745 --
746 -- Post Failure:
747 --
748 --
749 -- Access Status:
750 -- Public.
751 --
752 -- {End Of Comments}
753 --
754 procedure delete_eligy_org
755 (p_validate in number default hr_api.g_false_num
756 ,p_elig_org_unit_prte_id in number
757 ,p_effective_start_date out nocopy date
758 ,p_effective_end_date out nocopy date
759 ,p_object_version_number in out nocopy number
760 ,p_effective_date in date
761 ,p_datetrack_mode in varchar2
762 );
763 --
764 --
765 -- ----------------------------------------------------------------------------
766 -- |--------------------------< create_eligy_positon >------------------------|
767 -- ----------------------------------------------------------------------------
768 -- {Start Of Comments}
769 --
770 -- Description:
771 --
772 --
773 -- Prerequisites:
774 --
775 --
776 -- In Parameters:
777 -- Name Reqd Type Description
778 -- p_validate Yes boolean Commit or Rollback.
779 --
780 -- Post Success:
781 --
782 -- Out Parameters:
783 -- Name Reqd Type Description
784 -- p_eligy_prfl_id Yes number PK of record
785 --
786 -- Post Failure:
787 --
788 --
789 -- Access Status:
790 -- Public.
791 --
792 -- {End Of Comments}
793 --
794 procedure create_eligy_position
795 (p_validate in number default hr_api.g_false_num
796 ,p_elig_pstn_prte_id in out nocopy number
797 ,p_effective_start_date out nocopy date
798 ,p_effective_end_date out nocopy date
799 ,p_business_group_id in number default null
800 ,p_eligy_prfl_id in number default null
801 ,p_position_id in number default null
802 ,p_ordr_num in number default null
803 ,p_object_version_number out nocopy number
804 ,p_effective_date in date
805 );
806 --
807 -- ----------------------------------------------------------------------------
808 -- |-------------------------< update_eligy_position >------------------------|
809 -- ----------------------------------------------------------------------------
810 -- {Start Of Comments}
811 --
812 -- Description:
813 --
814 --
815 -- Prerequisites:
816 --
817 --
818 -- In Parameters:
819 -- Name Reqd Type Description
820 -- p_validate Yes boolean Commit or Rollback.
821 --
822 -- Post Success:
823 --
824 -- Out Parameters:
825 -- Name Reqd Type Description
826 -- p_eligy_prfl_id Yes number PK of record
827 --
828 -- Post Failure:
829 --
830 --
831 -- Access Status:
832 -- Public.
833 --
834 -- {End Of Comments}
835 --
836 procedure update_eligy_position
837 (p_validate in number default hr_api.g_false_num
838 ,p_elig_pstn_prte_id in number
839 ,p_effective_start_date out nocopy date
840 ,p_effective_end_date out nocopy date
841 ,p_business_group_id in number default hr_api.g_number
842 ,p_eligy_prfl_id in number default hr_api.g_number
843 ,p_position_id in number default hr_api.g_number
844 ,p_object_version_number in out nocopy number
845 ,p_effective_date in date
846 ,p_datetrack_mode in varchar2
847 );
848 --
849 -- ----------------------------------------------------------------------------
850 -- |--------------------------< delete_eligy_position >-----------------------|
851 -- ----------------------------------------------------------------------------
852 -- {Start Of Comments}
853 --
854 -- Description:
855 --
856 --
857 -- Prerequisites:
858 --
859 --
860 -- In Parameters:
861 -- Name Reqd Type Description
862 -- p_validate Yes boolean Commit or Rollback.
863 --
864 -- Post Success:
865 --
866 -- Out Parameters:
867 -- Name Reqd Type Description
868 -- p_eligy_prfl_id Yes number PK of record
869 --
870 -- Post Failure:
871 --
872 --
873 -- Access Status:
874 -- Public.
875 --
876 -- {End Of Comments}
877 --
878 procedure delete_eligy_position
879 (p_validate in number default hr_api.g_false_num
880 ,p_elig_pstn_prte_id in number
881 ,p_effective_start_date out nocopy date
882 ,p_effective_end_date out nocopy date
883 ,p_object_version_number in out nocopy number
884 ,p_effective_date in date
885 ,p_datetrack_mode in varchar2
886 );
887 --
888 -- ----------------------------------------------------------------------------
889 -- |----------------------------< create_eligy_job >------------------------|
890 -- ----------------------------------------------------------------------------
891 -- {Start Of Comments}
892 --
893 -- Description:
894 --
895 --
896 -- Prerequisites:
897 --
898 --
899 -- In Parameters:
900 -- Name Reqd Type Description
901 -- p_validate Yes boolean Commit or Rollback.
902 --
903 -- Post Success:
904 --
905 -- Out Parameters:
906 -- Name Reqd Type Description
907 -- p_eligy_prfl_id Yes number PK of record
908 --
909 -- Post Failure:
910 --
911 --
912 -- Access Status:
913 -- Public.
914 --
915 -- {End Of Comments}
916 --
917 procedure create_eligy_job
918 (p_validate in number default hr_api.g_false_num
919 ,p_elig_job_prte_id in out nocopy number
920 ,p_effective_start_date out nocopy date
921 ,p_effective_end_date out nocopy date
922 ,p_business_group_id in number default null
923 ,p_eligy_prfl_id in number default null
924 ,p_job_id in number default null
925 ,p_ordr_num in number default null
926 ,p_object_version_number out nocopy number
927 ,p_effective_date in date
928 );
929 --
930 -- ----------------------------------------------------------------------------
931 -- |-------------------------< update_eligy_job >------------------------|
932 -- ----------------------------------------------------------------------------
933 -- {Start Of Comments}
934 --
935 -- Description:
936 --
937 --
938 -- Prerequisites:
939 --
940 --
941 -- In Parameters:
942 -- Name Reqd Type Description
943 -- p_validate Yes boolean Commit or Rollback.
944 --
945 -- Post Success:
946 --
947 -- Out Parameters:
948 -- Name Reqd Type Description
949 -- p_eligy_prfl_id Yes number PK of record
950 --
951 -- Post Failure:
952 --
953 --
954 -- Access Status:
955 -- Public.
956 --
957 -- {End Of Comments}
958 --
959 procedure update_eligy_job
960 (p_validate in number default hr_api.g_false_num
961 ,p_elig_job_prte_id in number
962 ,p_effective_start_date out nocopy date
963 ,p_effective_end_date out nocopy date
964 ,p_business_group_id in number default hr_api.g_number
965 ,p_eligy_prfl_id in number default hr_api.g_number
966 ,p_job_id in number default hr_api.g_number
967 ,p_object_version_number in out nocopy number
968 ,p_effective_date in date
969 ,p_datetrack_mode in varchar2
970 );
971 --
972 -- ----------------------------------------------------------------------------
973 -- |----------------------------< delete_eligy_job >--------------------------|
974 -- ----------------------------------------------------------------------------
975 -- {Start Of Comments}
976 --
977 -- Description:
978 --
979 --
980 -- Prerequisites:
981 --
982 --
983 -- In Parameters:
984 -- Name Reqd Type Description
985 -- p_validate Yes boolean Commit or Rollback.
986 --
987 -- Post Success:
988 --
989 -- Out Parameters:
990 -- Name Reqd Type Description
991 -- p_eligy_prfl_id Yes number PK of record
992 --
993 -- Post Failure:
994 --
995 --
996 -- Access Status:
997 -- Public.
998 --
999 -- {End Of Comments}
1000 --
1001 procedure delete_eligy_job
1002 (p_validate in number default hr_api.g_false_num
1003 ,p_elig_job_prte_id in number
1004 ,p_effective_start_date out nocopy date
1005 ,p_effective_end_date out nocopy date
1006 ,p_object_version_number in out nocopy number
1007 ,p_effective_date in date
1008 ,p_datetrack_mode in varchar2
1009 );
1010 --
1011
1012
1013 end hr_objective_library_swi;
[Home] [Help]