1 Package HR_OBJECTIVE_LIBRARY_API as
2 /* $Header: pepmlapi.pkh 120.5 2006/10/20 04:03:46 tpapired noship $ */
3 /*#
4 * This package contains objective library APIs.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Objective Library
8 */
9
10 --
11 -- ----------------------------------------------------------------------------
12 -- |-------------------------< create_library_objective >---------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17 * This API creates a new objective.
18 *
19 * This API allows for a new objective to be added into the objectives library.
20 *
21 * <p><b>Licensing</b><br>
22 * This API is licensed for use with Human Resources.
23 *
24 * <p><b>Prerequisites</b><br>
25 *
26 *
27 * <p><b>Post Success</b><br>
28 * An objective is added to the objectives library.
29 *
30 * <p><b>Post Failure</b><br>
31 * The objective is not created and an appropriate error is raised.
32 *
33 * @param p_validate If true, then validation alone will be performed and the
34 * database will remain unchanged. If false and all validation checks pass,
35 * then the database will be modified.
36 * @param p_effective_date Current date
37 * @param p_objective_name Objective name.
38 * @param p_valid_from The date from which the objective is valid.
39 * @param p_valid_to The date after which the objective is no longer valid.
40 * @param p_target_date The date by when the objective should be met.
41 * @param p_next_review_date Information only date to indicate when the
42 * objective should next be reviewed.
43 * @param p_group_code Uses the lookup type HR_WPM_GROUP to categorize
44 * objectives.
45 * @param p_priority_code Uses the lookup type HR_WPM_PRIORITY to
46 * provide a default priority.
47 * @param p_appraise_flag Uses the lookup type YES_NO to provide a default
48 * for whether this objective should be appraised.
49 * @param p_weighting_percent Provides a default weighting for this objective,
50 * used to score overall appraisal ratings.
51 * @param p_measurement_style_code Uses the lookup type HR_WPM_MEASUREMENT_STYLE
52 * to indicate the style of measurement.
53 * @param p_measure_name The measure by which this objectives' completion
54 * should be scored against.
55 * @param p_target_value The target measure, either a maximum target or a
56 * minimum target, depending on the measure type.
57 * @param p_uom_code Uses the lookup type HR_WPM_MEASURE_UOM to determine the
58 * measures' unit of measure.
59 * @param p_measure_type_code Uses the lookup type HR_WPM_MEASURE_TYPE to
60 * determine whether the target measure is a minimum or maximum.
61 * @param p_measure_comments Comments regarding the measure and target.
62 * @param p_eligibility_type_code Uses the lookup type HR_WPM_ELIGIBILITY to
63 * determine the eligibility.
64 * @param p_details Provides further objective details.
65 * @param p_success_criteria Additional criteria that determines the success
66 * of this objective.
67 * @param p_comments General comments about this objective.
68 * @param p_attribute_category This context value determines which flexfield
69 * structure to use with the descriptive flexfield segments.
70 * @param p_attribute1 Descriptive flexfield segment.
71 * @param p_attribute2 Descriptive flexfield segment.
72 * @param p_attribute3 Descriptive flexfield segment.
73 * @param p_attribute4 Descriptive flexfield segment.
74 * @param p_attribute5 Descriptive flexfield segment.
75 * @param p_attribute6 Descriptive flexfield segment.
76 * @param p_attribute7 Descriptive flexfield segment.
77 * @param p_attribute8 Descriptive flexfield segment.
78 * @param p_attribute9 Descriptive flexfield segment.
79 * @param p_attribute10 Descriptive flexfield segment.
80 * @param p_attribute11 Descriptive flexfield segment.
81 * @param p_attribute12 Descriptive flexfield segment.
82 * @param p_attribute13 Descriptive flexfield segment.
83 * @param p_attribute14 Descriptive flexfield segment.
84 * @param p_attribute15 Descriptive flexfield segment.
85 * @param p_attribute16 Descriptive flexfield segment.
86 * @param p_attribute17 Descriptive flexfield segment.
87 * @param p_attribute18 Descriptive flexfield segment.
88 * @param p_attribute19 Descriptive flexfield segment.
89 * @param p_attribute20 Descriptive flexfield segment.
90 * @param p_attribute21 Descriptive flexfield segment.
91 * @param p_attribute22 Descriptive flexfield segment.
92 * @param p_attribute23 Descriptive flexfield segment.
93 * @param p_attribute24 Descriptive flexfield segment.
94 * @param p_attribute25 Descriptive flexfield segment.
95 * @param p_attribute26 Descriptive flexfield segment.
96 * @param p_attribute27 Descriptive flexfield segment.
97 * @param p_attribute28 Descriptive flexfield segment.
98 * @param p_attribute29 Descriptive flexfield segment.
99 * @param p_attribute30 Descriptive flexfield segment.
100 * @param p_objective_id Objective id system generated objective primary key.
101 * @param p_object_version_number System generated version of row. Increments by
102 * one with each update.
103 * @param p_duplicate_name_warning Set to true if an objective with the same
104 * name already exists.
105 * @param p_weighting_over_100_warning Set to true if the weighting has been set
106 * to a value greater than 100 or to a negative value.
107 * @param p_weighting_appraisal_warning Set to true if a weighting has been
108 * defined but the objective has not been marked to be included in appraisals.
109 * @rep:displayname Create Library Objective
110 * @rep:category BUSINESS_ENTITY PER_OBJECTIVE_LIBRARY
111 * @rep:lifecycle active
112 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
113 * @rep:scope public
114 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
115 */
116 --
117 -- {End Of Comments}
118 --
119
120 procedure create_library_objective
121 (p_validate in boolean default false
122 ,p_effective_date in date
123 ,p_objective_name in varchar2
124 ,p_valid_from in date default null
125 ,p_valid_to in date default null
126 ,p_target_date in date default null
127 ,p_next_review_date in date default null
128 ,p_group_code in varchar2 default null
129 ,p_priority_code in varchar2 default null
130 ,p_appraise_flag in varchar2 default 'Y'
131 ,p_weighting_percent in number default null
132 ,p_measurement_style_code in varchar2 default 'N_M'
133 ,p_measure_name in varchar2 default null
134 ,p_target_value in number default null
135 ,p_uom_code in varchar2 default null
136 ,p_measure_type_code in varchar2 default null
137 ,p_measure_comments in varchar2 default null
141 ,p_comments in varchar2 default null
138 ,p_eligibility_type_code in varchar2 default 'N_P'
139 ,p_details in varchar2 default null
140 ,p_success_criteria in varchar2 default null
142 ,p_attribute_category in varchar2 default null
143 ,p_attribute1 in varchar2 default null
144 ,p_attribute2 in varchar2 default null
145 ,p_attribute3 in varchar2 default null
146 ,p_attribute4 in varchar2 default null
147 ,p_attribute5 in varchar2 default null
148 ,p_attribute6 in varchar2 default null
149 ,p_attribute7 in varchar2 default null
150 ,p_attribute8 in varchar2 default null
151 ,p_attribute9 in varchar2 default null
152 ,p_attribute10 in varchar2 default null
153 ,p_attribute11 in varchar2 default null
154 ,p_attribute12 in varchar2 default null
155 ,p_attribute13 in varchar2 default null
156 ,p_attribute14 in varchar2 default null
157 ,p_attribute15 in varchar2 default null
158 ,p_attribute16 in varchar2 default null
159 ,p_attribute17 in varchar2 default null
160 ,p_attribute18 in varchar2 default null
161 ,p_attribute19 in varchar2 default null
165 ,p_attribute23 in varchar2 default null
162 ,p_attribute20 in varchar2 default null
163 ,p_attribute21 in varchar2 default null
164 ,p_attribute22 in varchar2 default null
166 ,p_attribute24 in varchar2 default null
167 ,p_attribute25 in varchar2 default null
168 ,p_attribute26 in varchar2 default null
169 ,p_attribute27 in varchar2 default null
170 ,p_attribute28 in varchar2 default null
171 ,p_attribute29 in varchar2 default null
172 ,p_attribute30 in varchar2 default null
173 ,p_objective_id out nocopy number
174 ,p_object_version_number out nocopy number
175 ,p_duplicate_name_warning out nocopy boolean
176 ,p_weighting_over_100_warning out nocopy boolean
177 ,p_weighting_appraisal_warning out nocopy boolean
178 );
179 --
180 -- ----------------------------------------------------------------------------
181 -- |-------------------------< update_library_objective >---------------------|
182 -- ----------------------------------------------------------------------------
183 --
184 -- {Start Of Comments}
185 /*#
186 * This API updates an objective.
187 *
188 * This API updates an existing objective in the objectives library.
189 *
190 * <p><b>Licensing</b><br>
191 * This API is licensed for use with Human Resources.
192 *
193 * <p><b>Prerequisites</b><br>
194 * The objective id must exist in the objectives library.
195 *
196 * <p><b>Post Success</b><br>
197 * The objective is updated.
198 *
199 * <p><b>Post Failure</b><br>
200 * The objective is not updated and an error raised and any changes rolled back.
201 *
202 * @param p_validate If true, then validation alone will be performed and the
203 * database will remain unchanged. If false and all validation checks pass,
204 * then the database will be modified.
205 * @param p_effective_date Current date.
206 * @param p_objective_id Objective id system generated objective primary key.
207 * @param p_objective_name Objective name.
208 * @param p_valid_from The date from which the objective is valid.
212 * objective should next be reviewed.
209 * @param p_valid_to The date after which the objective is no longer valid.
210 * @param p_target_date The date by when the objective should be met.
211 * @param p_next_review_date Information only date to indicate when the
213 * @param p_group_code Uses the lookup type HR_WPM_GROUP to categorize
214 * objectives.
215 * @param p_priority_code Uses the lookup type HR_WPM_PRIORITY to
216 * provide a default priority.
217 * @param p_appraise_flag Uses the lookup type YES_NO to provide a default
218 * for whether this objective should be appraised.
219 * @param p_weighting_percent Provides a default weighting for this objective,
220 * used to score overall appraisal ratings.
221 * @param p_measurement_style_code Uses the lookup type HR_WPM_MEASUREMENT_STYLE
225 * @param p_target_value The target measure, either a maximum target or a
222 * to indicate the style of measurement.
223 * @param p_measure_name The measure by which this objective's completion
224 * should be scored against.
226 * minimum target, depending on the measure type.
227 * @param p_uom_code Uses the lookup type HR_WPM_MEASURE_UOM to determine the
228 * measure's unit of measure.
229 * @param p_measure_type_code Uses the lookup type HR_WPM_MEASURE_TYPE to
230 * determine whether the target measure is a minimum or maximum.
231 * @param p_measure_comments Comments regarding the measure and target.
232 * @param p_eligibility_type_code Uses the lookup type HR_WPM_ELIGIBILITY to
233 * determine the eligibility.
234 * @param p_details Provides further objective details.
235 * @param p_success_criteria Additional criteria that determines the success
236 * of this objective.
237 * @param p_comments General comments about this objective.
238 * @param p_attribute_category This context value determines which flexfield
239 * structure to use with the descriptive flexfield segments.
240 * @param p_attribute1 Descriptive flexfield segment.
241 * @param p_attribute2 Descriptive flexfield segment.
242 * @param p_attribute3 Descriptive flexfield segment.
243 * @param p_attribute4 Descriptive flexfield segment.
244 * @param p_attribute5 Descriptive flexfield segment.
245 * @param p_attribute6 Descriptive flexfield segment.
246 * @param p_attribute7 Descriptive flexfield segment.
247 * @param p_attribute8 Descriptive flexfield segment.
248 * @param p_attribute9 Descriptive flexfield segment.
249 * @param p_attribute10 Descriptive flexfield segment.
250 * @param p_attribute11 Descriptive flexfield segment.
251 * @param p_attribute12 Descriptive flexfield segment.
252 * @param p_attribute13 Descriptive flexfield segment.
253 * @param p_attribute14 Descriptive flexfield segment.
254 * @param p_attribute15 Descriptive flexfield segment.
255 * @param p_attribute16 Descriptive flexfield segment.
256 * @param p_attribute17 Descriptive flexfield segment.
257 * @param p_attribute18 Descriptive flexfield segment.
261 * @param p_attribute22 Descriptive flexfield segment.
258 * @param p_attribute19 Descriptive flexfield segment.
259 * @param p_attribute20 Descriptive flexfield segment.
260 * @param p_attribute21 Descriptive flexfield segment.
262 * @param p_attribute23 Descriptive flexfield segment.
263 * @param p_attribute24 Descriptive flexfield segment.
264 * @param p_attribute25 Descriptive flexfield segment.
265 * @param p_attribute26 Descriptive flexfield segment.
266 * @param p_attribute27 Descriptive flexfield segment.
267 * @param p_attribute28 Descriptive flexfield segment.
268 * @param p_attribute29 Descriptive flexfield segment.
269 * @param p_attribute30 Descriptive flexfield segment.
273 * name already exists.
270 * @param p_object_version_number System generated version of row. Increments by
271 * one with each update.
272 * @param p_duplicate_name_warning Set to true if an objective with the same
274 * @param p_weighting_over_100_warning Set to true if the weighting has been set
275 * to a value greater than 100 or to a negative value.
276 * @param p_weighting_appraisal_warning Set to true if a weighting has been
277 * defined but the objective has not been marked to be included in appraisals.
278 * @rep:displayname Update Library Objective
279 * @rep:category BUSINESS_ENTITY PER_OBJECTIVE_LIBRARY
280 * @rep:lifecycle active
281 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
282 * @rep:scope public
283 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
284 */
285 --
286 -- {End Of Comments}
287 --
288 procedure update_library_objective
289 (p_validate in boolean default false
290 ,p_effective_date in date
291 ,p_objective_id in number
292 ,p_objective_name in varchar2 default hr_api.g_varchar2
296 ,p_next_review_date in date default hr_api.g_date
293 ,p_valid_from in date default hr_api.g_date
294 ,p_valid_to in date default hr_api.g_date
295 ,p_target_date in date default hr_api.g_date
297 ,p_group_code in varchar2 default hr_api.g_varchar2
298 ,p_priority_code in varchar2 default hr_api.g_varchar2
299 ,p_appraise_flag in varchar2 default hr_api.g_varchar2
300 ,p_weighting_percent in number default hr_api.g_number
301 ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
302 ,p_measure_name in varchar2 default hr_api.g_varchar2
303 ,p_target_value in number default hr_api.g_number
304 ,p_uom_code in varchar2 default hr_api.g_varchar2
305 ,p_measure_type_code in varchar2 default hr_api.g_varchar2
306 ,p_measure_comments in varchar2 default hr_api.g_varchar2
307 ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
308 ,p_details in varchar2 default hr_api.g_varchar2
309 ,p_success_criteria in varchar2 default hr_api.g_varchar2
310 ,p_comments in varchar2 default hr_api.g_varchar2
311 ,p_attribute_category in varchar2 default hr_api.g_varchar2
312 ,p_attribute1 in varchar2 default hr_api.g_varchar2
313 ,p_attribute2 in varchar2 default hr_api.g_varchar2
314 ,p_attribute3 in varchar2 default hr_api.g_varchar2
315 ,p_attribute4 in varchar2 default hr_api.g_varchar2
316 ,p_attribute5 in varchar2 default hr_api.g_varchar2
317 ,p_attribute6 in varchar2 default hr_api.g_varchar2
318 ,p_attribute7 in varchar2 default hr_api.g_varchar2
319 ,p_attribute8 in varchar2 default hr_api.g_varchar2
320 ,p_attribute9 in varchar2 default hr_api.g_varchar2
321 ,p_attribute10 in varchar2 default hr_api.g_varchar2
322 ,p_attribute11 in varchar2 default hr_api.g_varchar2
323 ,p_attribute12 in varchar2 default hr_api.g_varchar2
324 ,p_attribute13 in varchar2 default hr_api.g_varchar2
325 ,p_attribute14 in varchar2 default hr_api.g_varchar2
326 ,p_attribute15 in varchar2 default hr_api.g_varchar2
327 ,p_attribute16 in varchar2 default hr_api.g_varchar2
328 ,p_attribute17 in varchar2 default hr_api.g_varchar2
329 ,p_attribute18 in varchar2 default hr_api.g_varchar2
330 ,p_attribute19 in varchar2 default hr_api.g_varchar2
331 ,p_attribute20 in varchar2 default hr_api.g_varchar2
332 ,p_attribute21 in varchar2 default hr_api.g_varchar2
336 ,p_attribute25 in varchar2 default hr_api.g_varchar2
333 ,p_attribute22 in varchar2 default hr_api.g_varchar2
334 ,p_attribute23 in varchar2 default hr_api.g_varchar2
335 ,p_attribute24 in varchar2 default hr_api.g_varchar2
337 ,p_attribute26 in varchar2 default hr_api.g_varchar2
338 ,p_attribute27 in varchar2 default hr_api.g_varchar2
339 ,p_attribute28 in varchar2 default hr_api.g_varchar2
340 ,p_attribute29 in varchar2 default hr_api.g_varchar2
341 ,p_attribute30 in varchar2 default hr_api.g_varchar2
342 ,p_object_version_number in out nocopy number
343 ,p_duplicate_name_warning out nocopy boolean
344 ,p_weighting_over_100_warning out nocopy boolean
345 ,p_weighting_appraisal_warning out nocopy boolean
346 );
347 --
348 -- ----------------------------------------------------------------------------
349 -- |-------------------------< delete_library_objective >---------------------|
350 -- ----------------------------------------------------------------------------
351 --
352 -- {Start Of Comments}
353 /*#
354 * This API deletes an objective.
355 *
356 * This API removes an objective from the objectives library.
357 *
358 * <p><b>Licensing</b><br>
359 * This API is licensed for use with Human Resources.
360 *
361 * <p><b>Prerequisites</b><br>
362 * The objective id must exist.
363 *
364 * <p><b>Post Success</b><br>
365 * The objective is deleted.
366 *
367 * <p><b>Post Failure</b><br>
368 * The objective is not deleted and an error is raised.
369 *
370 * @param p_validate If true, then validation alone will be performed and the
371 * database will remain unchanged. If false and all validation checks pass,
375 * @rep:displayname Delete Library Objective.
372 * then the database will be modified.
373 * @param p_objective_id Objective id system generated objective primary key.
374 * @param p_object_version_number System generated version of row.
376 * @rep:category BUSINESS_ENTITY PER_OBJECTIVE_LIBRARY
377 * @rep:lifecycle active
378 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
379 * @rep:scope public
380 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
381 */
382 --
383 -- {End Of Comments}
384 --
385
386 procedure delete_library_objective
387 (p_validate in boolean default false
388 ,p_objective_id in number
389 ,p_object_version_number in number
390 );
391 --
392 --
393 -- ----------------------------------------------------------------------------
394 -- |-------------------------< create_eligy_profile >-------------------------|
398 -- Description:
395 -- ----------------------------------------------------------------------------
396 -- {Start Of Comments}
397 --
399 --
400 --
401 -- Prerequisites:
402 --
403 --
404 -- In Parameters:
405 --
406 --
407 -- Post Success:
408 --
409 --
410 -- Out Parameters:
411 -- Name Reqd Type Description
412 --
413 -- Post Failure:
414 --
415 --
416 -- Access Status:
417 -- Internal Development Use Only.
418 --
419 -- {End Of Comments}
420 --
421 procedure create_eligy_profile
422 (p_validate in boolean default false
423 ,p_effective_date in date
424 ,p_business_group_id in number
425 ,p_name in varchar2 default null
426 ,p_bnft_cagr_prtn_cd in varchar2 default null
427 ,p_stat_cd in varchar2 default null
428 ,p_asmt_to_use_cd in varchar2 default null
429 ,p_elig_grd_flag in varchar2 default 'N'
430 ,p_elig_org_unit_flag in varchar2 default 'N'
431 ,p_elig_job_flag in varchar2 default 'N'
432 ,p_elig_pstn_flag in varchar2 default 'N'
433 ,p_eligy_prfl_id out nocopy number
434 ,p_object_version_number out nocopy number
435 ,p_effective_start_date out nocopy date
436 ,p_effective_end_date out nocopy date
437 );
438 --
439 -- ----------------------------------------------------------------------------
440 -- |-------------------------< update_eligy_profile >-------------------------|
444 -- Description:
441 -- ----------------------------------------------------------------------------
442 -- {Start Of Comments}
443 --
445 --
446 --
447 -- Prerequisites:
448 --
449 --
450 -- In Parameters:
451 --
452 --
453 -- Post Success:
454 --
455 --
456 -- Out Parameters:
457 -- Name Reqd Type Description
458 --
459 -- Post Failure:
460 --
461 --
462 -- Access Status:
463 -- Internal Development Use Only.
464 --
465 -- {End Of Comments}
466 --
467 procedure update_eligy_profile
468 ( p_validate in boolean default false
469 ,p_effective_date in date
470 ,p_business_group_id in number
471 ,p_name in varchar2 default null
472 ,p_bnft_cagr_prtn_cd in varchar2 default null
473 ,p_stat_cd in varchar2 default null
474 ,p_asmt_to_use_cd in varchar2 default null
475 ,p_elig_grd_flag in varchar2 default 'N'
476 ,p_elig_org_unit_flag in varchar2 default 'N'
477 ,p_elig_job_flag in varchar2 default 'N'
478 ,p_elig_pstn_flag in varchar2 default 'N'
479 ,p_eligy_prfl_id in number
480 ,p_object_version_number in out nocopy number
481 ,p_effective_start_date out nocopy date
482 ,p_effective_end_date out nocopy date
483 ,p_datetrack_mode in varchar2
484 );
485 -- ----------------------------------------------------------------------------
486 -- |--------------------------< create_eligy_object >-------------------------|
487 -- ----------------------------------------------------------------------------
488 -- {Start Of Comments}
489 --
490 -- Description:
491 --
492 --
493 -- Prerequisites:
494 --
495 --
496 -- In Parameters:
497 -- Name Reqd Type Description
498 --
499 --
500 -- Post Success:
501 --
502 --
503 -- Out Parameters:
504 -- Name Reqd Type Description
505 --
506 -- Post Failure:
507 --
508 --
509 -- Access Status:
510 -- Internal Development Use Only.
511 --
512 -- {End Of Comments}
513 --
514 procedure create_eligy_object
515 (p_validate in boolean default false
516 ,p_elig_obj_id out nocopy number
517 ,p_effective_start_date out nocopy date
518 ,p_effective_end_date out nocopy date
519 ,p_business_group_id in number
520 ,p_table_name in varchar2
521 ,p_column_name in varchar2
522 ,p_column_value in varchar2
523 ,p_object_version_number out nocopy number
524 ,p_effective_date in date
525 );
526 --
527 -- ----------------------------------------------------------------------------
528 -- |--------------------------< update_eligy_object >-------------------------|
529 -- ----------------------------------------------------------------------------
530 -- {Start Of Comments}
531 --
532 -- Description:
533 --
534 --
535 -- Prerequisites:
536 --
537 --
538 -- In Parameters:
539 -- Name Reqd Type Description
540 -- p_validate Yes boolean Commit or Rollback.
541 --
542 -- Post Success:
543 --
544 -- Out Parameters:
545 -- Name Reqd Type Description
546 --
550 -- Access Status:
547 -- Post Failure:
548 --
549 --
551 -- Internal Development Use Only.
552 --
553 -- {End Of Comments}
554 --
555 procedure update_eligy_object
556 (p_validate in boolean default false
557 ,p_elig_obj_id in number
558 ,p_effective_start_date out nocopy date
559 ,p_effective_end_date out nocopy date
560 ,p_business_group_id in number default hr_api.g_number
561 ,p_table_name in varchar2 default hr_api.g_varchar2
562 ,p_column_name in varchar2 default hr_api.g_varchar2
563 ,p_column_value in varchar2 default hr_api.g_varchar2
564 ,p_object_version_number in out nocopy number
565 ,p_effective_date in date
566 ,p_datetrack_mode in varchar2
567 );
568 --
569 --
570 -- ----------------------------------------------------------------------------
571 -- |--------------------------< delete_eligy_object >-------------------------|
572 -- ----------------------------------------------------------------------------
573 -- {Start Of Comments}
574 --
575 -- Description:
576 --
577 --
578 -- Prerequisites:
579 --
580 --
581 -- In Parameters:
582 -- Name Reqd Type Description
583 -- p_validate Yes boolean Commit or Rollback.
584 --
585 -- Post Success:
586 --
587 -- Out Parameters:
588 -- Name Reqd Type Description
589 --
590 -- Post Failure:
591 --
592 --
593 -- Access Status:
594 -- Internal Development Use Only.
595 --
596 -- {End Of Comments}
597 --
598 procedure delete_eligy_object
599 (p_validate in boolean default false
600 ,p_elig_obj_id in number
601 ,p_effective_start_date out nocopy date
605 ,p_datetrack_mode in varchar2
602 ,p_effective_end_date out nocopy date
603 ,p_object_version_number in out nocopy number
604 ,p_effective_date in date
606 );
607 --
608 -- ----------------------------------------------------------------------------
609 -- |-----------------------< create_elig_obj_elig_prfl >----------------------|
610 -- ----------------------------------------------------------------------------
611 -- {Start Of Comments}
612 --
613 -- Description:
614 --
615 --
616 -- Prerequisites:
617 --
618 --
619 -- In Parameters:
620 -- Name Reqd Type Description
621 -- p_validate Yes boolean Commit or Rollback.
622 --
623 -- Post Success:
624 --
625 -- Out Parameters:
626 -- Name Reqd Type Description
627 --
628 -- Post Failure:
629 --
630 --
631 -- Access Status:
632 -- Internal Development Use Only.
633 --
634 -- {End Of Comments}
635 --
636 procedure create_elig_obj_elig_prfl
637 (p_validate in boolean default false
638 ,p_elig_obj_elig_prfl_id out nocopy number
639 ,p_effective_start_date out nocopy date
640 ,p_effective_end_date out nocopy date
641 ,p_business_group_id in number default null
642 ,p_elig_obj_id in number default null
646 );
643 ,p_elig_prfl_id in number default null
644 ,p_object_version_number out nocopy number
645 ,p_effective_date in date
647 -- ----------------------------------------------------------------------------
648 -- |-----------------------< update_elig_obj_elig_prfl >----------------------|
649 -- ----------------------------------------------------------------------------
650 -- {Start Of Comments}
651 --
652 -- Description:
653 --
654 --
655 -- Prerequisites:
656 --
657 --
658 -- In Parameters:
659 -- Name Reqd Type Description
660 -- p_validate Yes boolean Commit or Rollback.
661 --
662 -- Post Success:
663 --
664 -- Out Parameters:
665 -- Name Reqd Type Description
666 --
667 -- Post Failure:
668 --
669 --
670 -- Access Status:
671 -- Internal Development Use Only.
672 --
673 -- {End Of Comments}
674 --
675 procedure update_elig_obj_elig_prfl
676 (p_validate in boolean default false
677 ,p_elig_obj_elig_prfl_id in number
678 ,p_effective_start_date out nocopy date
679 ,p_effective_end_date out nocopy date
680 ,p_elig_obj_id in number default hr_api.g_number
681 ,p_elig_prfl_id in number default hr_api.g_number
682 ,p_object_version_number in out nocopy number
683 ,p_effective_date in date
684 ,p_datetrack_mode in varchar2
685 );
686 --
687 -- ----------------------------------------------------------------------------
688 -- |-----------------------< delete_elig_obj_elig_prfl >----------------------|
689 -- ----------------------------------------------------------------------------
690 -- {Start Of Comments}
691 --
692 -- Description:
693 --
694 --
695 -- Prerequisites:
696 --
697 --
698 -- In Parameters:
699 -- Name Reqd Type Description
700 -- p_validate Yes boolean Commit or Rollback.
701 --
702 -- Post Success:
703 --
704 -- Out Parameters:
705 -- Name Reqd Type Description
706 --
707 -- Post Failure:
708 --
709 --
710 -- Access Status:
711 -- Internal Development Use Only.
712 --
713 -- {End Of Comments}
714 --
715 procedure delete_elig_obj_elig_prfl
716 (p_validate in boolean default false
717 ,p_elig_obj_elig_prfl_id in number
718 ,p_effective_start_date out nocopy date
719 ,p_effective_end_date out nocopy date
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 -- |----------------------------< create_eligy_grade >------------------------|
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 -- Internal Development Use Only.
751 --
752 -- {End Of Comments}
753 --
754 procedure create_eligy_grade
755 (p_validate in boolean default false
756 ,p_elig_grd_prte_id out nocopy number
757 ,p_effective_start_date out nocopy date
758 ,p_effective_end_date out nocopy date
759 ,p_business_group_id in number default null
760 ,p_eligy_prfl_id in number default null
761 ,p_grade_id in number default null
762 ,p_ordr_num in number default null
763 ,p_object_version_number out nocopy number
764 ,p_effective_date in date
765 );
766 --
767 --
768 -- ----------------------------------------------------------------------------
769 -- |-------------------------< update_eligy_grade >------------------------|
770 -- ----------------------------------------------------------------------------
771 -- {Start Of Comments}
772 --
773 -- Description:
774 --
775 --
776 -- Prerequisites:
777 --
778 --
779 -- In Parameters:
780 -- Name Reqd Type Description
781 -- p_validate Yes boolean Commit or Rollback.
782 --
783 -- Post Success:
784 --
785 -- Out Parameters:
786 -- Name Reqd Type Description
787 -- p_eligy_prfl_id Yes number PK of record
788 --
789 -- Post Failure:
790 --
791 --
792 -- Access Status:
793 -- Internal Development Use Only.
794 --
795 -- {End Of Comments}
796 --
797 procedure update_eligy_grade
798 (p_validate in boolean default false
799 ,p_elig_grd_prte_id in number
800 ,p_effective_start_date out nocopy date
801 ,p_effective_end_date out nocopy date
802 ,p_business_group_id in number default hr_api.g_number
806 ,p_effective_date in date
803 ,p_eligy_prfl_id in number default hr_api.g_number
804 ,p_grade_id in number default hr_api.g_number
805 ,p_object_version_number in out nocopy number
807 ,p_datetrack_mode in varchar2
808 );
809 --
810 -- ----------------------------------------------------------------------------
811 -- |----------------------------< delete_eligy_grade >--------------------------|
812 -- ----------------------------------------------------------------------------
813 -- {Start Of Comments}
814 --
815 -- Description:
816 --
817 --
818 -- Prerequisites:
819 --
820 --
821 -- In Parameters:
822 -- Name Reqd Type Description
823 -- p_validate Yes boolean Commit or Rollback.
824 --
825 -- Post Success:
826 --
827 -- Out Parameters:
828 -- Name Reqd Type Description
829 -- p_eligy_prfl_id Yes number PK of record
830 --
831 -- Post Failure:
832 --
833 --
834 -- Access Status:
835 -- Internal Development Use Only.
836 --
837 -- {End Of Comments}
838 --
839 procedure delete_eligy_grade
840 (p_validate in boolean default false
841 ,p_elig_grd_prte_id in number
842 ,p_effective_start_date out nocopy date
843 ,p_effective_end_date out nocopy date
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 -- |----------------------------< create_eligy_org >--------------------------|
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 -- Internal Development Use Only.
875 --
876 -- {End Of Comments}
877 --
878 procedure create_eligy_org
879 (p_validate in boolean default false
880 ,p_elig_org_unit_prte_id out nocopy number
881 ,p_effective_start_date out nocopy date
882 ,p_effective_end_date out nocopy date
883 ,p_business_group_id in number default null
884 ,p_eligy_prfl_id in number default null
885 ,p_organization_id in number default null
886 ,p_ordr_num in number default null
887 ,p_object_version_number out nocopy number
888 ,p_effective_date in date
889 );
890 --
891 -- ----------------------------------------------------------------------------
892 -- |----------------------------< update_eligy_org >--------------------------|
893 -- ----------------------------------------------------------------------------
894 -- {Start Of Comments}
895 --
896 -- Description:
897 --
898 --
899 -- Prerequisites:
900 --
901 --
902 -- In Parameters:
903 -- Name Reqd Type Description
904 -- p_validate Yes boolean Commit or Rollback.
905 --
906 -- Post Success:
907 --
908 -- Out Parameters:
909 -- Name Reqd Type Description
910 -- p_eligy_prfl_id Yes number PK of record
911 --
912 -- Post Failure:
913 --
914 --
915 -- Access Status:
916 -- Internal Development Use Only.
917 --
918 -- {End Of Comments}
919 --
920 procedure update_eligy_org
921 (p_validate in boolean default false
922 ,p_elig_org_unit_prte_id in number
923 ,p_effective_start_date out nocopy date
924 ,p_effective_end_date out nocopy date
925 ,p_business_group_id in number default hr_api.g_number
926 ,p_eligy_prfl_id in number default hr_api.g_number
927 ,p_organization_id in number default hr_api.g_number
928 ,p_object_version_number in out nocopy number
929 ,p_effective_date in date
930 ,p_datetrack_mode in varchar2
931 );
932 --
933 -- ----------------------------------------------------------------------------
934 -- |----------------------------< delete_eligy_org >--------------------------|
935 -- ----------------------------------------------------------------------------
936 -- {Start Of Comments}
937 --
938 -- Description:
939 --
940 --
941 -- Prerequisites:
942 --
943 --
944 -- In Parameters:
945 -- Name Reqd Type Description
946 -- p_validate Yes boolean Commit or Rollback.
947 --
948 -- Post Success:
949 --
950 -- Out Parameters:
951 -- Name Reqd Type Description
952 -- p_eligy_prfl_id Yes number PK of record
953 --
954 -- Post Failure:
955 --
956 --
957 -- Access Status:
958 -- Internal Development Use Only.
959 --
960 -- {End Of Comments}
961 --
962 procedure delete_eligy_org
966 ,p_effective_end_date out nocopy date
963 (p_validate in boolean default false
964 ,p_elig_org_unit_prte_id in number
965 ,p_effective_start_date out nocopy date
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 -- ----------------------------------------------------------------------------
974 -- |--------------------------< create_eligy_position >-----------------------|
975 -- ----------------------------------------------------------------------------
976 -- {Start Of Comments}
977 --
978 -- Description:
979 --
980 --
981 -- Prerequisites:
982 --
983 --
984 -- In Parameters:
985 -- Name Reqd Type Description
986 -- p_validate Yes boolean Commit or Rollback.
987 --
988 -- Post Success:
989 --
990 -- Out Parameters:
991 -- Name Reqd Type Description
992 -- p_eligy_prfl_id Yes number PK of record
993 --
994 -- Post Failure:
995 --
996 --
997 -- Access Status:
998 -- Internal Development Use Only.
999 --
1000 -- {End Of Comments}
1001 --
1002 procedure create_eligy_position
1003 (p_validate in boolean default false
1004 ,p_elig_pstn_prte_id out nocopy number
1005 ,p_effective_start_date out nocopy date
1006 ,p_effective_end_date out nocopy date
1007 ,p_business_group_id in number default null
1008 ,p_eligy_prfl_id in number default null
1009 ,p_position_id in number default null
1010 ,p_ordr_num in number default null
1011 ,p_object_version_number out nocopy number
1012 ,p_effective_date in date
1013 );
1014 --
1015 -- ----------------------------------------------------------------------------
1016 -- |-------------------------< update_eligy_position >------------------------|
1017 -- ----------------------------------------------------------------------------
1018 -- {Start Of Comments}
1019 --
1020 -- Description:
1021 --
1022 --
1023 -- Prerequisites:
1024 --
1025 --
1026 -- In Parameters:
1027 -- Name Reqd Type Description
1028 -- p_validate Yes boolean Commit or Rollback.
1029 --
1030 -- Post Success:
1031 --
1032 -- Out Parameters:
1033 -- Name Reqd Type Description
1034 -- p_eligy_prfl_id Yes number PK of record
1035 --
1036 -- Post Failure:
1037 --
1038 --
1039 -- Access Status:
1040 -- Internal Development Use Only.
1041 --
1042 -- {End Of Comments}
1043 --
1044 procedure update_eligy_position
1045 (p_validate in boolean default false
1046 ,p_elig_pstn_prte_id in number
1047 ,p_effective_start_date out nocopy date
1048 ,p_effective_end_date out nocopy date
1049 ,p_business_group_id in number default hr_api.g_number
1050 ,p_eligy_prfl_id in number default hr_api.g_number
1051 ,p_position_id in number default hr_api.g_number
1052 ,p_object_version_number in out nocopy number
1053 ,p_effective_date in date
1054 ,p_datetrack_mode in varchar2
1055 );
1056 --
1057 -- ----------------------------------------------------------------------------
1058 -- |----------------------------< delete_eligy_position >--------------------------|
1059 -- ----------------------------------------------------------------------------
1060 -- {Start Of Comments}
1061 --
1062 -- Description:
1063 --
1064 --
1065 -- Prerequisites:
1066 --
1067 --
1068 -- In Parameters:
1069 -- Name Reqd Type Description
1070 -- p_validate Yes boolean Commit or Rollback.
1071 --
1072 -- Post Success:
1073 --
1074 -- Out Parameters:
1075 -- Name Reqd Type Description
1076 -- p_eligy_prfl_id Yes number PK of record
1077 --
1078 -- Post Failure:
1079 --
1080 --
1081 -- Access Status:
1082 -- Internal Development Use Only.
1083 --
1084 -- {End Of Comments}
1085 --
1086 procedure delete_eligy_position
1087 (p_validate in boolean default false
1088 ,p_elig_pstn_prte_id in number
1089 ,p_effective_start_date out nocopy date
1090 ,p_effective_end_date out nocopy date
1091 ,p_object_version_number in out nocopy number
1092 ,p_effective_date in date
1093 ,p_datetrack_mode in varchar2
1094 );
1095
1096 --
1097 -- ----------------------------------------------------------------------------
1098 -- |----------------------------< create_eligy_job >------------------------|
1099 -- ----------------------------------------------------------------------------
1100 -- {Start Of Comments}
1101 --
1102 -- Description:
1103 --
1104 --
1105 -- Prerequisites:
1106 --
1107 --
1108 -- In Parameters:
1109 -- Name Reqd Type Description
1110 -- p_validate Yes boolean Commit or Rollback.
1111 --
1112 -- Post Success:
1113 --
1114 -- Out Parameters:
1115 -- Name Reqd Type Description
1116 -- p_eligy_prfl_id Yes number PK of record
1117 --
1118 -- Post Failure:
1119 --
1120 --
1121 -- Access Status:
1122 -- Internal Development Use Only.
1123 --
1124 -- {End Of Comments}
1125 --
1126 procedure create_eligy_job
1130 ,p_effective_end_date out nocopy date
1127 (p_validate in boolean default false
1128 ,p_elig_job_prte_id out nocopy number
1129 ,p_effective_start_date out nocopy date
1131 ,p_business_group_id in number default null
1132 ,p_eligy_prfl_id in number default null
1133 ,p_job_id in number default null
1134 ,p_ordr_num in number default null
1135 ,p_object_version_number out nocopy number
1136 ,p_effective_date in date
1137 );
1138 --
1139 -- ----------------------------------------------------------------------------
1140 -- |-------------------------< update_eligy_job >------------------------|
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 --
1154 -- Post Success:
1155 --
1156 -- Out Parameters:
1157 -- Name Reqd Type Description
1158 -- p_eligy_prfl_id Yes number PK of record
1159 --
1160 -- Post Failure:
1161 --
1162 --
1163 -- Access Status:
1164 -- Internal Development Use Only.
1165 --
1166 -- {End Of Comments}
1167 --
1168 procedure update_eligy_job
1169 (p_validate in boolean default false
1170 ,p_elig_job_prte_id in number
1171 ,p_effective_start_date out nocopy date
1172 ,p_effective_end_date out nocopy date
1173 ,p_business_group_id in number default hr_api.g_number
1174 ,p_eligy_prfl_id in number default hr_api.g_number
1175 ,p_job_id in number default hr_api.g_number
1176 ,p_object_version_number in out nocopy number
1177 ,p_effective_date in date
1178 ,p_datetrack_mode in varchar2
1179 );
1180 --
1181 -- ----------------------------------------------------------------------------
1182 -- |----------------------------< delete_eligy_job >--------------------------|
1183 -- ----------------------------------------------------------------------------
1184 -- {Start Of Comments}
1185 --
1186 -- Description:
1187 --
1188 --
1189 -- Prerequisites:
1190 --
1191 --
1192 -- In Parameters:
1193 -- Name Reqd Type Description
1194 -- p_validate Yes boolean Commit or Rollback.
1195 --
1196 -- Post Success:
1197 --
1198 -- Out Parameters:
1199 -- Name Reqd Type Description
1200 -- p_eligy_prfl_id Yes number PK of record
1201 --
1202 -- Post Failure:
1203 --
1204 --
1205 -- Access Status:
1206 -- Internal Development Use Only.
1207 --
1208 -- {End Of Comments}
1209 --
1210 procedure delete_eligy_job
1211 (p_validate in boolean default false
1212 ,p_elig_job_prte_id in number
1213 ,p_effective_start_date out nocopy date
1214 ,p_effective_end_date out nocopy date
1215 ,p_object_version_number in out nocopy number
1216 ,p_effective_date in date
1217 ,p_datetrack_mode in varchar2
1218 );
1219 --
1220 end HR_OBJECTIVE_LIBRARY_API;