1 Package hr_competence_element_api as
2 /* $Header: pecelapi.pkh 120.2 2006/02/13 14:05:47 vbala noship $ */
3 /*#
4 * This package contains Competence Element APIs.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Competence Element
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------< create_competence_element >---------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a competence element.
17 *
18 * A competence element is used to record an individual competence and an
19 * evaluation rating. Either a competence level or a specific rating scale step
20 * may be indicated as the evaluation rating.
21 *
22 * <p><b>Licensing</b><br>
23 * This API is licensed for use with Human Resources and HR Foundation.
24 *
25 * <p><b>Prerequisites</b><br>
26 * There are no prereqs for creating competence elements.
27 *
28 * <p><b>Restricted Usage Notes</b><br>
29 * HR Foundation users can only use the following parameters: p_effective_date
30 * p_type, p_validate p_business_group, p_competence_id, p_proficiency_level,
31 * p_rating_level, p_person_id, p_effective_date_from, p_effective_date_to,
32 * p_source_of_proficiency_level, p_certification_date, p_certification_method,
33 * p_next_certification_date, p_comments, p_attribute_category, p_attribute1 -
34 * 20, p_party_id.
35 *
36 * <p><b>Post Success</b><br>
37 * Competence element is created.
38 *
39 * <p><b>Post Failure</b><br>
40 * Competence element is not created and an error is raised.
41 * @param p_validate If true, then validation alone will be performed and the
42 * database will remain unchanged. If false and all validation checks pass,
43 * then the database will be modified.
44 * @param p_competence_element_id If p_validate is false, uniquely identifies
45 * the competence element created. If p_validate is true, set to null.
46 * @param p_object_version_number If p_validate is false, then set to the
47 * version number of the created competence element. If p_validate is true,
48 * then the value will be null.
49 * @param p_type Type of competence element. Valid values are defined by
50 * COMPETENCE_ELEMENT_TYPE lookup type.
51 * @param p_business_group_id Business group in which the competence element is
52 * created.
53 * @param p_enterprise_id Identifies the enterprise organization for which the
54 * competence element is defined.
55 * @param p_competence_id Competence for the element.
56 * @param p_proficiency_level_id Proficiency level for the competence.
57 * @param p_high_proficiency_level_id The highest proficiency level that can be
58 * achieved for the competence referenced by the element.
59 * @param p_weighting_level_id Weighting level associated with the competence
60 * referenced by the element.
61 * @param p_rating_level_id Rating level associated with the competence
62 * referenced by the element.
63 * @param p_person_id Person for whom this competence element applies.
64 * @param p_job_id Identifies job
65 * @param p_valid_grade_id Identifies grade
66 * @param p_position_id Identifies position
67 * @param p_organization_id Identifies organization
68 * @param p_parent_competence_element_id Identifies the parent competence
69 * element. Parent competences must be of type ASSESSMENT GROUP and if a
70 * competence element is to have a parent, it must have a type of
71 * ASSESSMENT_COMPETENCE.
72 * @param p_activity_version_id Activity version
73 * @param p_assessment_id Identifies Assessment
74 * @param p_assessment_type_id Identifies the assessment type
75 * @param p_mandatory Indicates that the associated competence is essential for
76 * the competence requirements. Valid values are defined by YES_NO lookup type.
77 * @param p_effective_date_from The effective start date of this competence
78 * element.
79 * @param p_effective_date_to The effective end date of this competence
80 * element.
81 * @param p_group_competence_type Competence type for the group. Validated
82 * values are defined in COMPETENCE_TYPE lookup type.
83 * @param p_competence_type Competence type. Validated values are defined by
84 * COMPETENCE_TYPE lookup type.
85 * @param p_normal_elapse_duration The time needed for a competence of type
86 * 'Path'.
87 * @param p_normal_elapse_duration_unit Units of the duration. Valid values are
88 * defined by ELAPSE_DURATION lookup type.
89 * @param p_sequence_number Number to control the display sequence.
90 * @param p_source_of_proficiency_level Source of proficiency level. Valid
91 * values are defined by PROFICIENCY_SOURCE lookup type.
92 * @param p_line_score The score related to an assessment.
93 * @param p_certification_date Date on which the certification was obtained.
94 * @param p_certification_method Method by which the certification is obtained.
95 * Valid values are defined in CERTIFICATION_METHOD lookup type.
96 * @param p_next_certification_date Date when the next certification is due.
97 * @param p_comments Comment text.
98 * @param p_attribute_category This context value determines which flexfield
99 * structure to use with the descriptive flexfield segments.
100 * @param p_attribute1 Descriptive flexfield segment.
101 * @param p_attribute2 Descriptive flexfield segment.
102 * @param p_attribute3 Descriptive flexfield segment.
103 * @param p_attribute4 Descriptive flexfield segment.
104 * @param p_attribute5 Descriptive flexfield segment.
105 * @param p_attribute6 Descriptive flexfield segment.
106 * @param p_attribute7 Descriptive flexfield segment.
107 * @param p_attribute8 Descriptive flexfield segment.
108 * @param p_attribute9 Descriptive flexfield segment.
109 * @param p_attribute10 Descriptive flexfield segment.
110 * @param p_attribute11 Descriptive flexfield segment.
111 * @param p_attribute12 Descriptive flexfield segment.
112 * @param p_attribute13 Descriptive flexfield segment.
113 * @param p_attribute14 Descriptive flexfield segment.
114 * @param p_attribute15 Descriptive flexfield segment.
115 * @param p_attribute16 Descriptive flexfield segment.
116 * @param p_attribute17 Descriptive flexfield segment.
117 * @param p_attribute18 Descriptive flexfield segment.
118 * @param p_attribute19 Descriptive flexfield segment.
119 * @param p_attribute20 Descriptive flexfield segment.
120 * @param p_effective_date Reference date for validating lookup values are
121 * applicable during the start to end active date range. This date does not
122 * determine when the changes take effect.
123 * @param p_object_id Identifier for a generic object that is linked with a
124 * competence.
125 * @param p_object_name Identifies the generic object that is linked with a
126 * competence e.g. Project Resource.
127 * @param p_party_id The party for whom the competence element applies.
128 * @param p_qualification_type_id Identifies the qualification type
129 * @param p_unit_standard_type Unit standard type.
130 * @param p_status Indicates whether the competence has been achieved or is
131 * still being worked towards.
132 * @param p_information_category This context value determines which flexfield
133 * structure to use with the developer descriptive flexfield segments.
134 * @param p_information1 Developer descriptive flexfield segment.
135 * @param p_information2 Developer descriptive flexfield segment.
136 * @param p_information3 Developer descriptive flexfield segment.
137 * @param p_information4 Developer descriptive flexfield segment.
138 * @param p_information5 Developer descriptive flexfield segment.
139 * @param p_information6 Developer descriptive flexfield segment.
140 * @param p_information7 Developer descriptive flexfield segment.
141 * @param p_information8 Developer descriptive flexfield segment.
142 * @param p_information9 Developer descriptive flexfield segment.
143 * @param p_information10 Developer descriptive flexfield segment.
144 * @param p_information11 Developer descriptive flexfield segment.
145 * @param p_information12 Developer descriptive flexfield segment.
146 * @param p_information13 Developer descriptive flexfield segment.
147 * @param p_information14 Developer descriptive flexfield segment.
148 * @param p_information15 Developer descriptive flexfield segment.
149 * @param p_information16 Developer descriptive flexfield segment.
150 * @param p_information17 Developer descriptive flexfield segment.
151 * @param p_information18 Developer descriptive flexfield segment.
152 * @param p_information19 Developer descriptive flexfield segment.
153 * @param p_information20 Developer descriptive flexfield segment.
154 * @param p_achieved_date The date on which the 'Status' changes to 'Achieved'
155 * @param p_appr_line_score The score related to an appraisal competency assessment.
156 * @rep:displayname Create Competence Element
157 * @rep:category BUSINESS_ENTITY PER_COMPETENCE_ELEMENT
158 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
159 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
160 * @rep:scope public
161 * @rep:lifecycle active
162 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
163 */
164 --
165 -- {End Of Comments}
166 --
167 procedure create_competence_element
168 (p_validate in boolean default false,
169 p_competence_element_id out nocopy number,
170 p_object_version_number out nocopy number,
171 p_type in varchar2,
172 p_business_group_id in number default null,
173 p_enterprise_id in number default null,
174 p_competence_id in number default null,
175 p_proficiency_level_id in number default null,
176 p_high_proficiency_level_id in number default null,
177 p_weighting_level_id in number default null,
178 p_rating_level_id in number default null,
179 p_person_id in number default null,
180 p_job_id in number default null,
181 p_valid_grade_id in number default null,
182 p_position_id in number default null,
183 p_organization_id in number default null,
184 p_parent_competence_element_id in number default null,
185 p_activity_version_id in number default null,
186 p_assessment_id in number default null,
187 p_assessment_type_id in number default null,
188 p_mandatory in varchar2 default null,
189 p_effective_date_from in date default null,
190 p_effective_date_to in date default null,
191 p_group_competence_type in varchar2 default null,
192 p_competence_type in varchar2 default null,
193 p_normal_elapse_duration in number default null,
194 p_normal_elapse_duration_unit in varchar2 default null,
195 p_sequence_number in number default null,
196 p_source_of_proficiency_level in varchar2 default null,
197 p_line_score in number default null,
198 p_certification_date in date default null,
199 p_certification_method in varchar2 default null,
200 p_next_certification_date in date default null,
201 p_comments in varchar2 default null,
202 p_attribute_category in varchar2 default null,
203 p_attribute1 in varchar2 default null,
204 p_attribute2 in varchar2 default null,
205 p_attribute3 in varchar2 default null,
206 p_attribute4 in varchar2 default null,
207 p_attribute5 in varchar2 default null,
208 p_attribute6 in varchar2 default null,
209 p_attribute7 in varchar2 default null,
210 p_attribute8 in varchar2 default null,
211 p_attribute9 in varchar2 default null,
212 p_attribute10 in varchar2 default null,
213 p_attribute11 in varchar2 default null,
214 p_attribute12 in varchar2 default null,
215 p_attribute13 in varchar2 default null,
216 p_attribute14 in varchar2 default null,
217 p_attribute15 in varchar2 default null,
218 p_attribute16 in varchar2 default null,
219 p_attribute17 in varchar2 default null,
220 p_attribute18 in varchar2 default null,
221 p_attribute19 in varchar2 default null,
222 p_attribute20 in varchar2 default null,
223 p_effective_date in Date,
224 p_object_id in number default null,
225 p_object_name in varchar2 default null,
226 p_party_id in number default null -- HR/TCA merge
227 ,p_qualification_type_id in number default null
228 ,p_unit_standard_type in varchar2 default null
229 ,p_status in varchar2 default null
230 ,p_information_category in varchar2 default null
231 ,p_information1 in varchar2 default null
232 ,p_information2 in varchar2 default null
233 ,p_information3 in varchar2 default null
234 ,p_information4 in varchar2 default null
235 ,p_information5 in varchar2 default null
236 ,p_information6 in varchar2 default null
237 ,p_information7 in varchar2 default null
238 ,p_information8 in varchar2 default null
239 ,p_information9 in varchar2 default null
240 ,p_information10 in varchar2 default null
241 ,p_information11 in varchar2 default null
242 ,p_information12 in varchar2 default null
243 ,p_information13 in varchar2 default null
244 ,p_information14 in varchar2 default null
245 ,p_information15 in varchar2 default null
246 ,p_information16 in varchar2 default null
247 ,p_information17 in varchar2 default null
248 ,p_information18 in varchar2 default null
249 ,p_information19 in varchar2 default null
250 ,p_information20 in varchar2 default null
251 ,p_achieved_date in date default null
252 ,p_appr_line_score in number default null
253 );
254 --
255 -- ----------------------------------------------------------------------------
256 -- |------------------------< update_competence_element >---------------------|
257 -- ----------------------------------------------------------------------------
258 --
259 -- {Start Of Comments}
260 /*#
261 * This API updates competence element details.
262 *
263 * A competence element is used to record an individual competence and an
264 * evaluation rating. Either a competence level or a specific rating scale step
265 * may be indicated as the evaluation rating.
266 *
267 * <p><b>Licensing</b><br>
268 * This API is licensed for use with Human Resources and HR Foundation.
269 *
270 * <p><b>Prerequisites</b><br>
271 * Competence element must exist.
272 *
273 * <p><b>Restricted Usage Notes</b><br>
274 * HR Foundation users can only use the following parameters: p_effective_date,
275 * p_competence_element_id, p_object_version_number, p_validate,
276 * p_proficiency_level, p_rating_level, p_effective_date_from,
277 * p_effective_date_to, p_source_of_proficiency_level, p_certification_date,
278 * p_certification_method, p_next_certification_date, p_comments,
279 * p_attribute_category, p_attribute1 - 20, p_party_id.
280 *
281 * <p><b>Post Success</b><br>
282 * Competence element is updated.
283 *
284 * <p><b>Post Failure</b><br>
285 * Competence element is not updated and an error is raised.
286 * @param p_competence_element_id Identifies the competence element record to
287 * be modified.
288 * @param p_object_version_number Pass in the current version number of the
289 * competence element to be updated. When the API completes if p_validate is
290 * false, will be set to the new version number of the updated competence
291 * element. If p_validate is true will be set to the same value which was
292 * passed in.
293 * @param p_proficiency_level_id Proficiency level for the competence.
294 * @param p_high_proficiency_level_id The highest proficiency level that can be
295 * achieved for the competence referenced by the element.
296 * @param p_weighting_level_id Weighting level associated with the competence
297 * referenced by the element.
298 * @param p_rating_level_id The level associated with the competence referenced
299 * by the element.
300 * @param p_mandatory Indicates that the associated competence is essential for
301 * the competence requirements. Valid values are defined by YES_NO lookup type.
302 * @param p_effective_date_from The effective start date of this competence
303 * element.
304 * @param p_effective_date_to The effective end date of this competence
305 * element.
306 * @param p_group_competence_type Competence type for the group. Validated
307 * values are defined in COMPETENCE_TYPE lookup type.
308 * @param p_competence_type Competence type. Validated values are defined by
309 * COMPETENCE_TYPE lookup type.
310 * @param p_normal_elapse_duration The time needed for a competence of type
311 * 'Path'.
312 * @param p_normal_elapse_duration_unit Units of the duration. Valid values are
313 * defined by ELAPSE_DURATION lookup type.
314 * @param p_sequence_number Number to control the display sequence.
315 * @param p_source_of_proficiency_level Source of proficiency level. Valid
316 * values are defined by PROFICIENCY_SOURCE lookup type.
317 * @param p_line_score The score related to an assessment.
318 * @param p_certification_date The date on which the certification was
319 * obtained.
320 * @param p_certification_method Method by which the certification is obtained.
321 * Valid values are defined in CERTIFICATION_METHOD lookup type.
322 * @param p_next_certification_date Date when the next certification is due.
323 * @param p_comments Comment text.
324 * @param p_attribute_category This context value determines which flexfield
325 * structure to use with the descriptive flexfield segments.
326 * @param p_attribute1 Descriptive flexfield segment.
327 * @param p_attribute2 Descriptive flexfield segment.
328 * @param p_attribute3 Descriptive flexfield segment.
329 * @param p_attribute4 Descriptive flexfield segment.
330 * @param p_attribute5 Descriptive flexfield segment.
331 * @param p_attribute6 Descriptive flexfield segment.
332 * @param p_attribute7 Descriptive flexfield segment.
333 * @param p_attribute8 Descriptive flexfield segment.
334 * @param p_attribute9 Descriptive flexfield segment.
335 * @param p_attribute10 Descriptive flexfield segment.
336 * @param p_attribute11 Descriptive flexfield segment.
337 * @param p_attribute12 Descriptive flexfield segment.
338 * @param p_attribute13 Descriptive flexfield segment.
339 * @param p_attribute14 Descriptive flexfield segment.
340 * @param p_attribute15 Descriptive flexfield segment.
341 * @param p_attribute16 Descriptive flexfield segment.
342 * @param p_attribute17 Descriptive flexfield segment.
343 * @param p_attribute18 Descriptive flexfield segment.
344 * @param p_attribute19 Descriptive flexfield segment.
345 * @param p_attribute20 Descriptive flexfield segment.
346 * @param p_effective_date Reference date for validating lookup values are
347 * applicable during the start to end active date range. This date does not
348 * determine when the changes take effect.
349 * @param p_validate If true, then validation alone will be performed and the
350 * database will remain unchanged. If false and all validation checks pass,
351 * then the database will be modified.
352 * @param p_party_id The party for whom the competence element applies.
353 * @param p_qualification_type_id Identifies the qualification type
354 * @param p_unit_standard_type Unit standard type.
355 * @param p_status Indicates whether the competence has been achieved or is
356 * still being worked towards.
357 * @param p_information_category This context value determines which flexfield
358 * structure to use with the developer descriptive flexfield segments.
359 * @param p_information1 Developer descriptive flexfield segment.
360 * @param p_information2 Developer descriptive flexfield segment.
361 * @param p_information3 Developer descriptive flexfield segment.
362 * @param p_information4 Developer descriptive flexfield segment.
363 * @param p_information5 Developer descriptive flexfield segment.
364 * @param p_information6 Developer descriptive flexfield segment.
365 * @param p_information7 Developer descriptive flexfield segment.
366 * @param p_information8 Developer descriptive flexfield segment.
367 * @param p_information9 Developer descriptive flexfield segment.
368 * @param p_information10 Developer descriptive flexfield segment.
369 * @param p_information11 Developer descriptive flexfield segment.
370 * @param p_information12 Developer descriptive flexfield segment.
371 * @param p_information13 Developer descriptive flexfield segment.
372 * @param p_information14 Developer descriptive flexfield segment.
373 * @param p_information15 Developer descriptive flexfield segment.
374 * @param p_information16 Developer descriptive flexfield segment.
375 * @param p_information17 Developer descriptive flexfield segment.
376 * @param p_information18 Developer descriptive flexfield segment.
377 * @param p_information19 Developer descriptive flexfield segment.
378 * @param p_information20 Developer descriptive flexfield segment.
379 * @param p_achieved_date The date on which the 'Status' changes to 'Achieved'
380 * @param p_appr_line_score The score related to an appraisal competency assessment.
381 * @rep:displayname Update Competence Element
382 * @rep:category BUSINESS_ENTITY PER_COMPETENCE_ELEMENT
383 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
384 * @rep:scope public
385 * @rep:lifecycle active
386 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
387 */
388 --
389 -- {End Of Comments}
390 --
391 procedure update_competence_element
392 (
393 p_competence_element_id in number,
394 p_object_version_number in out nocopy number,
395 p_proficiency_level_id in number default hr_api.g_number,
396 p_high_proficiency_level_id in number default hr_api.g_number,
397 p_weighting_level_id in number default hr_api.g_number,
398 p_rating_level_id in number default hr_api.g_number,
399 p_mandatory in varchar2 default hr_api.g_varchar2,
400 p_effective_date_from in date default hr_api.g_date,
401 p_effective_date_to in date default hr_api.g_date,
402 p_group_competence_type in varchar2 default hr_api.g_varchar2,
403 p_competence_type in varchar2 default hr_api.g_varchar2,
404 p_normal_elapse_duration in number default hr_api.g_number,
405 p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
406 p_sequence_number in number default hr_api.g_number,
407 p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
408 p_line_score in number default hr_api.g_number,
409 p_certification_date in date default hr_api.g_date,
410 p_certification_method in varchar2 default hr_api.g_varchar2,
411 p_next_certification_date in date default hr_api.g_date,
412 p_comments in varchar2 default hr_api.g_varchar2,
413 p_attribute_category in varchar2 default hr_api.g_varchar2,
414 p_attribute1 in varchar2 default hr_api.g_varchar2,
415 p_attribute2 in varchar2 default hr_api.g_varchar2,
416 p_attribute3 in varchar2 default hr_api.g_varchar2,
417 p_attribute4 in varchar2 default hr_api.g_varchar2,
418 p_attribute5 in varchar2 default hr_api.g_varchar2,
419 p_attribute6 in varchar2 default hr_api.g_varchar2,
420 p_attribute7 in varchar2 default hr_api.g_varchar2,
421 p_attribute8 in varchar2 default hr_api.g_varchar2,
422 p_attribute9 in varchar2 default hr_api.g_varchar2,
423 p_attribute10 in varchar2 default hr_api.g_varchar2,
424 p_attribute11 in varchar2 default hr_api.g_varchar2,
425 p_attribute12 in varchar2 default hr_api.g_varchar2,
426 p_attribute13 in varchar2 default hr_api.g_varchar2,
427 p_attribute14 in varchar2 default hr_api.g_varchar2,
428 p_attribute15 in varchar2 default hr_api.g_varchar2,
429 p_attribute16 in varchar2 default hr_api.g_varchar2,
430 p_attribute17 in varchar2 default hr_api.g_varchar2,
431 p_attribute18 in varchar2 default hr_api.g_varchar2,
432 p_attribute19 in varchar2 default hr_api.g_varchar2,
433 p_attribute20 in varchar2 default hr_api.g_varchar2,
434 p_effective_date in Date,
435 p_validate in boolean default false,
436 p_party_id in number
437 ,p_qualification_type_id in number default hr_api.g_number
438 ,p_unit_standard_type in varchar2 default hr_api.g_varchar2
439 ,p_status in varchar2 default hr_api.g_varchar2
440 ,p_information_category in varchar2 default hr_api.g_varchar2
441 ,p_information1 in varchar2 default hr_api.g_varchar2
442 ,p_information2 in varchar2 default hr_api.g_varchar2
443 ,p_information3 in varchar2 default hr_api.g_varchar2
444 ,p_information4 in varchar2 default hr_api.g_varchar2
445 ,p_information5 in varchar2 default hr_api.g_varchar2
446 ,p_information6 in varchar2 default hr_api.g_varchar2
447 ,p_information7 in varchar2 default hr_api.g_varchar2
448 ,p_information8 in varchar2 default hr_api.g_varchar2
449 ,p_information9 in varchar2 default hr_api.g_varchar2
450 ,p_information10 in varchar2 default hr_api.g_varchar2
451 ,p_information11 in varchar2 default hr_api.g_varchar2
452 ,p_information12 in varchar2 default hr_api.g_varchar2
453 ,p_information13 in varchar2 default hr_api.g_varchar2
454 ,p_information14 in varchar2 default hr_api.g_varchar2
455 ,p_information15 in varchar2 default hr_api.g_varchar2
456 ,p_information16 in varchar2 default hr_api.g_varchar2
457 ,p_information17 in varchar2 default hr_api.g_varchar2
458 ,p_information18 in varchar2 default hr_api.g_varchar2
459 ,p_information19 in varchar2 default hr_api.g_varchar2
460 ,p_information20 in varchar2 default hr_api.g_varchar2
461 ,p_achieved_date in date default hr_api.g_date
462 ,p_appr_line_score in number default hr_api.g_number
463 );
464 --
465 -- ----------------------------------------------------------------------------
466 -- |------------------------< update_competence_element >---------------------|
467 -- ----------------------------------------------------------------------------
468 --
469 -- This version of the API is now out-of-date however it has been provided to
470 -- you for backward compatibility support and will be removed in the future.
471 -- Oracle recommends you to modify existing calling programs in advance of the
472 -- support being withdrawn thus avoiding any potential disruption.
473 --
474 procedure update_competence_element
475 (
476 p_competence_element_id in number,
477 p_object_version_number in out nocopy number,
478 p_proficiency_level_id in number default hr_api.g_number,
479 p_high_proficiency_level_id in number default hr_api.g_number,
480 p_weighting_level_id in number default hr_api.g_number,
481 p_rating_level_id in number default hr_api.g_number,
482 p_mandatory in varchar2 default hr_api.g_varchar2,
483 p_effective_date_from in date default hr_api.g_date,
484 p_effective_date_to in date default hr_api.g_date,
485 p_group_competence_type in varchar2 default hr_api.g_varchar2,
486 p_competence_type in varchar2 default hr_api.g_varchar2,
487 p_normal_elapse_duration in number default hr_api.g_number,
488 p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
489 p_sequence_number in number default hr_api.g_number,
490 p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
491 p_line_score in number default hr_api.g_number,
492 p_certification_date in date default hr_api.g_date,
493 p_certification_method in varchar2 default hr_api.g_varchar2,
494 p_next_certification_date in date default hr_api.g_date,
495 p_comments in varchar2 default hr_api.g_varchar2,
496 p_attribute_category in varchar2 default hr_api.g_varchar2,
497 p_attribute1 in varchar2 default hr_api.g_varchar2,
498 p_attribute2 in varchar2 default hr_api.g_varchar2,
499 p_attribute3 in varchar2 default hr_api.g_varchar2,
500 p_attribute4 in varchar2 default hr_api.g_varchar2,
501 p_attribute5 in varchar2 default hr_api.g_varchar2,
502 p_attribute6 in varchar2 default hr_api.g_varchar2,
503 p_attribute7 in varchar2 default hr_api.g_varchar2,
504 p_attribute8 in varchar2 default hr_api.g_varchar2,
505 p_attribute9 in varchar2 default hr_api.g_varchar2,
506 p_attribute10 in varchar2 default hr_api.g_varchar2,
507 p_attribute11 in varchar2 default hr_api.g_varchar2,
508 p_attribute12 in varchar2 default hr_api.g_varchar2,
509 p_attribute13 in varchar2 default hr_api.g_varchar2,
510 p_attribute14 in varchar2 default hr_api.g_varchar2,
511 p_attribute15 in varchar2 default hr_api.g_varchar2,
512 p_attribute16 in varchar2 default hr_api.g_varchar2,
513 p_attribute17 in varchar2 default hr_api.g_varchar2,
514 p_attribute18 in varchar2 default hr_api.g_varchar2,
515 p_attribute19 in varchar2 default hr_api.g_varchar2,
516 p_attribute20 in varchar2 default hr_api.g_varchar2,
517 p_effective_date in Date,
518 p_validate in boolean default false
519 );
520 --
521 -- ----------------------------------------------------------------------------
522 -- |-----------------------< update_personal_comp_element >-------------------|
523 -- ----------------------------------------------------------------------------
524 --
525 -- {Start Of Comments}
526 /*#
527 * This API Updates a personal competence element.
528 *
529 * Use this API for updating the competence element of type PERSONAL. A
530 * competence element is used to record an individual competence and an
531 * evaluation rating. Either a competence level or a specific rating scale step
532 * may be indicated as the evaluation rating.
533 *
534 * <p><b>Licensing</b><br>
535 * This API is licensed for use with Human Resources and HR Foundation.
536 *
537 * <p><b>Prerequisites</b><br>
538 * A valid competence element must already exist.
539 *
540 * <p><b>Post Success</b><br>
541 * Competence element is updated.
542 *
543 * <p><b>Post Failure</b><br>
544 * Does not update a competence element and an error is raised.
545 * @param p_competence_element_id Identifies the competence element record to
546 * be updated.
547 * @param p_object_version_number Pass in the current version number of the
548 * competence element to be updated. When the API completes if p_validate is
549 * false, will be set to the new version number of the updated competence
550 * element. If p_validate is true will be set to the same value which was
551 * passed in.
552 * @param p_proficiency_level_id The proficiency level for the competence
553 * @param p_effective_date_from The effective start date of this competence
554 * element.
555 * @param p_effective_date_to The effective end date of this competence
556 * element.
557 * @param p_source_of_proficiency_level The source of the proficiency level.
558 * @param p_certification_date The date on which the certification was
559 * obtained.
560 * @param p_certification_method The method by which the certification is
561 * obtained.
562 * @param p_next_certification_date The date for next certification
563 * @param p_comments Comments Text
564 * @param p_attribute_category This context value determines which flexfield
565 * structure to use with the descriptive flexfield segments.
566 * @param p_attribute1 Descriptive flexfield segment.
567 * @param p_attribute2 Descriptive flexfield segment.
568 * @param p_attribute3 Descriptive flexfield segment.
569 * @param p_attribute4 Descriptive flexfield segment.
570 * @param p_attribute5 Descriptive flexfield segment.
571 * @param p_attribute6 Descriptive flexfield segment.
572 * @param p_attribute7 Descriptive flexfield segment.
573 * @param p_attribute8 Descriptive flexfield segment.
574 * @param p_attribute9 Descriptive flexfield segment.
575 * @param p_attribute10 Descriptive flexfield segment.
576 * @param p_attribute11 Descriptive flexfield segment.
577 * @param p_attribute12 Descriptive flexfield segment.
578 * @param p_attribute13 Descriptive flexfield segment.
579 * @param p_attribute14 Descriptive flexfield segment.
580 * @param p_attribute15 Descriptive flexfield segment.
581 * @param p_attribute16 Descriptive flexfield segment.
582 * @param p_attribute17 Descriptive flexfield segment.
583 * @param p_attribute18 Descriptive flexfield segment.
584 * @param p_attribute19 Descriptive flexfield segment.
585 * @param p_attribute20 Descriptive flexfield segment.
586 * @param p_effective_date Reference date for validating lookup values are
587 * applicable during the start to end active date range. This date does not
588 * determine when the changes take effect.
589 * @param p_validate If true, then validation alone will be performed and the
590 * database will remain unchanged. If false and all validation checks pass,
591 * then the database will be modified.
592 * @param p_ins_ovn Identifies the object version number of the new record
593 * created. This happens when an existing competence element is updated and a
594 * new competence element is created ( for maintaining the date track of this
595 * competence).
596 * @param p_ins_comp_id Identifies the new competence record created. This
597 * happens when an existing competence element is updated and a new competence
598 * element is created ( for maintaining the date track of this competence).
599 * @rep:displayname Update Personal Competence Element
600 * @rep:category BUSINESS_ENTITY PER_COMPETENCE_ELEMENT
601 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
602 * @rep:scope public
603 * @rep:lifecycle active
604 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
605 */
606 --
607 -- {End Of Comments}
608 --
609 procedure update_personal_comp_element
610 (
611 p_competence_element_id in number,
612 p_object_version_number in out nocopy number,
613 p_proficiency_level_id in number default hr_api.g_number,
614 p_effective_date_from in date default hr_api.g_date,
615 p_effective_date_to in date default hr_api.g_date,
616 p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
617 p_certification_date in date default hr_api.g_date,
618 p_certification_method in varchar2 default hr_api.g_varchar2,
619 p_next_certification_date in date default hr_api.g_date,
620 p_comments in varchar2 default hr_api.g_varchar2,
621 p_attribute_category in varchar2 default hr_api.g_varchar2,
622 p_attribute1 in varchar2 default hr_api.g_varchar2,
623 p_attribute2 in varchar2 default hr_api.g_varchar2,
624 p_attribute3 in varchar2 default hr_api.g_varchar2,
625 p_attribute4 in varchar2 default hr_api.g_varchar2,
626 p_attribute5 in varchar2 default hr_api.g_varchar2,
627 p_attribute6 in varchar2 default hr_api.g_varchar2,
628 p_attribute7 in varchar2 default hr_api.g_varchar2,
629 p_attribute8 in varchar2 default hr_api.g_varchar2,
630 p_attribute9 in varchar2 default hr_api.g_varchar2,
631 p_attribute10 in varchar2 default hr_api.g_varchar2,
632 p_attribute11 in varchar2 default hr_api.g_varchar2,
633 p_attribute12 in varchar2 default hr_api.g_varchar2,
634 p_attribute13 in varchar2 default hr_api.g_varchar2,
635 p_attribute14 in varchar2 default hr_api.g_varchar2,
636 p_attribute15 in varchar2 default hr_api.g_varchar2,
637 p_attribute16 in varchar2 default hr_api.g_varchar2,
638 p_attribute17 in varchar2 default hr_api.g_varchar2,
639 p_attribute18 in varchar2 default hr_api.g_varchar2,
640 p_attribute19 in varchar2 default hr_api.g_varchar2,
641 p_attribute20 in varchar2 default hr_api.g_varchar2,
642 p_effective_date in Date,
643 p_validate in boolean default false ,
644 p_ins_ovn out nocopy number,
645 p_ins_comp_id out nocopy number
646 );
647 --
648 -- ----------------------------------------------------------------------------
649 -- |------------------------< delete_competence_element >---------------------|
650 -- ----------------------------------------------------------------------------
651 --
652 -- {Start Of Comments}
653 /*#
654 * This API deletes a competence element.
655 *
656 * A competence element is used to record an individual competence and an
657 * evaluation rating. Either a competence level or a specific rating scale step
658 * may be indicated as the evaluation rating.
659 *
660 * <p><b>Licensing</b><br>
661 * This API is licensed for use with Human Resources and HR Foundation.
662 *
663 * <p><b>Prerequisites</b><br>
664 * A valid competence element must already exist.
665 *
666 * <p><b>Post Success</b><br>
667 * Competence element is deleted.
668 *
669 * <p><b>Post Failure</b><br>
670 * Competence element is not deleted and an error is raised.
671 * @param p_validate If true, then validation alone will be performed and the
672 * database will remain unchanged. If false and all validation checks pass,
673 * then the database will be modified.
674 * @param p_competence_element_id Identifies the competence element record to
675 * delete.
676 * @param p_object_version_number Current version number of the competence
677 * element to be deleted.
678 * @rep:displayname Delete Competence Element
679 * @rep:category BUSINESS_ENTITY PER_COMPETENCE_ELEMENT
680 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
681 * @rep:scope public
682 * @rep:lifecycle active
683 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
684 */
685 --
686 -- {End Of Comments}
687 --
688 procedure delete_competence_element
689 (p_validate in boolean default false,
690 p_competence_element_id in number,
691 p_object_version_number in number
692 );
693 --
694 -- ----------------------------------------------------------------------------
695 -- |----------------------< maintain_student_comp_element >-------------------|
696 -- ----------------------------------------------------------------------------
697 --
698 -- {Start Of Comments}
699 /*#
700 * This API maintains the details of student competence element.
701 *
702 * A competence element is used to record an individual competence and an
703 * evaluation rating. Either a competence level or a specific rating scale step
704 * may be indicated as the evaluation rating.
705 *
706 * <p><b>Licensing</b><br>
707 * This API is licensed for use with Human Resources.
708 *
709 * <p><b>Prerequisites</b><br>
710 * To modify competence element, an existing and valid competence element must
711 * exist.
712 *
713 * <p><b>Post Success</b><br>
714 * If p_validate is false and the competence element does not exist, then this
715 * process creates the competence element. If the competence element already
716 * exists and is a valid one, then the process updates it. If p_validate is
717 * true then no records are created or updated.
718 *
719 * <p><b>Post Failure</b><br>
720 * The competence element is not created or updated and an error is raised.
721 * @param p_person_id Identifies the person record
722 * @param p_competence_id Competence for this element.
723 * @param p_proficiency_level_id Proficiency level for the competence.
724 * @param p_business_group_id Business group in which the competence is
725 * created.
726 * @param p_effective_date_from The effective start date of this competence
727 * element
728 * @param p_effective_date_to The effective end date of this competence
729 * element.
730 * @param p_certification_date The date on which the certification was
731 * obtained.
732 * @param p_certification_method The method by which the certification is
733 * obtained.
734 * @param p_next_certification_date The date for next certification.
735 * @param p_source_of_proficiency_level Source of proficiency level. Valid
736 * values are defined by PROFICIENCY_SOURCE lookup type.
737 * @param p_comments Comment text.
738 * @param p_effective_date Reference date for validating lookup values are
739 * applicable during the start to end active date range. This date does not
740 * determine when the changes take effect.
741 * @param p_validate If true, then validation alone will be performed and the
742 * database will remain unchanged. If false and all validation checks pass,
743 * then the database will be modified.
744 * @param p_competence_created Identifies the number of competence elements
745 * created, updated or both. If a new competence element is created this is set
746 * to 1. If an existing competence element is updated, then also this is set to
747 * 1. If an existing competence element is updated and a new competence element
748 * record is created then this is set to 2.
749 * @rep:displayname Maintain Student Competence Element
750 * @rep:category BUSINESS_ENTITY PER_COMPETENCE_ELEMENT
751 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
752 * @rep:scope public
753 * @rep:lifecycle active
754 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
755 */
756 --
757 -- {End Of Comments}
758 --
759 procedure maintain_student_comp_element
760 (p_person_id in number
761 ,p_competence_id in number
762 ,p_proficiency_level_id in number
763 ,p_business_group_id in number
764 ,p_effective_date_from in date
765 ,p_effective_date_to in date
766 ,p_certification_date in date
767 ,p_certification_method in varchar2
768 ,p_next_certification_date in date
769 ,p_source_of_proficiency_level in varchar2
770 ,p_comments in varchar2
771 ,p_effective_date in date
772 ,p_validate in boolean default false
773 ,p_competence_created out nocopy number);
774 --
775 -- ----------------------------------------------------------------------------
776 -- |----------------------------< copy_competencies >-------------------------|
777 -- ----------------------------------------------------------------------------
778 --
779 -- {Start Of Comments}
780 /*#
781 * This API copies competence element.
782 *
783 * Use this API to copy an existing competence element details to a new
784 * competence element.
785 *
786 * <p><b>Licensing</b><br>
787 * This API is licensed for use with Human Resources.
788 *
789 * <p><b>Prerequisites</b><br>
790 * Competence element to be copied from must exist.
791 *
792 * <p><b>Post Success</b><br>
793 * If p_validate is false, then the competence elements are copied. If
794 * p_validate is true then no competence elements are copied.
795 *
796 * <p><b>Post Failure</b><br>
797 * Does not copy competencies and an error is raised.
798 * @param p_activity_version_from Activity version from which the competence is
799 * being copied.
800 * @param p_activity_version_to Activity version to which the competence is
801 * being copied.
802 * @param p_competence_type Competence type to be copied, TRAINER or DELIVERY
803 * @param p_validate If true, then validation alone will be performed and the
804 * database will remain unchanged. If false and all validation checks pass,
805 * then the database will be modified.
806 * @rep:displayname Copy Competence Elements
807 * @rep:category BUSINESS_ENTITY PER_COMPETENCE_ELEMENT
808 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
809 * @rep:scope public
810 * @rep:lifecycle active
811 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
812 */
813 --
814 -- {End Of Comments}
815 --
816 procedure copy_competencies(p_activity_version_from number
817 ,p_activity_version_to number
818 ,p_competence_type VARCHAR2 default null -- Bug 1868713
819 ,p_validate in boolean default false
820 );
821 --
822 -- ----------------------------------------------------------------------------
823 -- |--------------------------< update_delivered_dates >----------------------|
824 -- ----------------------------------------------------------------------------
825 --
826 -- {Start Of Comments}
827 /*#
828 * This API updates the competence element delivered dates.
829 *
830 * If p_validate is false then this procedure will update the competence
831 * element with the latest of p_old_start_date and p_start_date, and the
832 * earliest of p_old_end_date and p_end_date. If p_validate is true, then no
833 * rows will be updated.
834 *
835 * <p><b>Licensing</b><br>
836 * This API is licensed for use with Human Resources.
837 *
838 * <p><b>Prerequisites</b><br>
839 * A valid competence element must already exist.
840 *
841 * <p><b>Post Success</b><br>
842 * Delivered dates are updated.
843 *
844 * <p><b>Post Failure</b><br>
845 * Does not update a delivered date and an error is raised.
846 * @param p_activity_version_id The activity version for the competence
847 * element.
848 * @param p_old_start_date The existing start date of the competence element.
849 * @param p_start_date The new start date for the competence element.
850 * @param p_old_end_date The existing end date of the competence element.
851 * @param p_end_date The new end date for the competence element.
852 * @param p_validate If true, then validation alone will be performed and the
853 * database will remain unchanged. If false and all validation checks pass,
854 * then the database will be modified.
855 * @rep:displayname Update Competence Element Delivered Dates
856 * @rep:category BUSINESS_ENTITY PER_COMPETENCE_ELEMENT
857 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
858 * @rep:scope public
859 * @rep:lifecycle active
860 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
861 */
862 --
863 -- {End Of Comments}
864 --
865 procedure update_delivered_dates
866 (p_activity_version_id in number,
867 p_old_start_date in date,
868 p_start_date in date,
869 p_old_end_date in date,
870 p_end_date in date,
871 p_validate in boolean default false
872 );
873 --
874 end hr_competence_element_api;