1 Package hr_competences_api as
2 /* $Header: pecpnapi.pkh 120.1 2005/11/28 03:21:27 dsaxby noship $ */
3 /*#
4 * This package contains competences APIs.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Competence
8 */
9 --
10 -- Package variable
11 --
12 g_ignore_df varchar2(1) := 'N';
13 --
14 -- ----------------------------------------------------------------------------
15 -- |------------------------< <create_competence> >---------------------------|
16 -- ----------------------------------------------------------------------------
17 -- {Start Of Comments}
18 /*#
19 * This API creates a competence.
20 *
21 *
22 * <p><b>Licensing</b><br>
23 * This API is licensed for use with Oracle Human Resources.
24 *
25 * <p><b>Prerequisites</b><br>
26 * No known prerequisites.
27 *
28 * <p><b>Post Success</b><br>
29 * The competence will have been created.
30 *
31 * <p><b>Post Failure</b><br>
32 * The competence will not be created and an error will be raised.
33 *
34 * @param p_validate If true, then validation alone will be performed and the
35 * database will remain unchanged. If false and all validation checks pass,
36 * then the database will be modified.
37 * @param p_effective_date Reference date for validating lookup values are
38 * applicable during the start to end active date range. This date does not
39 * determine when the changes take effect.
40 * @param p_language_code Specifies to which language the translation values
41 * apply. You can set to the base or any installed language. The default value
42 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
43 * value.
44 * @param p_business_group_id {@rep:casecolumn
45 * PER_COMPETENCES.BUSINESS_GROUP_ID}
46 * @param p_description {@rep:casecolumn PER_COMPETENCES.DESCRIPTION}
47 * @param p_competence_alias Competence alias
48 * @param p_date_from {@rep:casecolumn PER_COMPETENCES.DATE_FROM}
49 * @param p_date_to {@rep:casecolumn PER_COMPETENCES.DATE_TO}
50 * @param p_behavioural_indicator {@rep:casecolumn
51 * PER_COMPETENCES.BEHAVIOURAL_INDICATOR}
52 * @param p_certification_required Certification Requried, 'Yes' or 'No'. Valid
53 * values are defined by 'YES_NO' lookup type
54 * @param p_evaluation_method Evaluation Method. Valid values are defined by
55 * 'COMPETENCE_EVAL_TYPE' lookup type.
56 * @param p_renewal_period_frequency {@rep:casecolumn
57 * PER_COMPETENCES.RENEWAL_PERIOD_FREQUENCY}
58 * @param p_renewal_period_units Renewal period units. Valid values are defined
59 * by 'FREQUENCY' lookup type.
60 * @param p_rating_scale_id {@rep:casecolumn PER_COMPETENCES.RATING_SCALE_ID}
61 * @param p_attribute_category This context value determines which flexfield
62 * structure to use with the descriptive flexfield segments.
63 * @param p_attribute1 Descriptive flexfield segment.
64 * @param p_attribute2 Descriptive flexfield segment.
65 * @param p_attribute3 Descriptive flexfield segment.
66 * @param p_attribute4 Descriptive flexfield segment.
67 * @param p_attribute5 Descriptive flexfield segment.
68 * @param p_attribute6 Descriptive flexfield segment.
69 * @param p_attribute7 Descriptive flexfield segment.
70 * @param p_attribute8 Descriptive flexfield segment.
71 * @param p_attribute9 Descriptive flexfield segment.
72 * @param p_attribute10 Descriptive flexfield segment.
73 * @param p_attribute11 Descriptive flexfield segment.
74 * @param p_attribute12 Descriptive flexfield segment.
75 * @param p_attribute13 Descriptive flexfield segment.
76 * @param p_attribute14 Descriptive flexfield segment.
77 * @param p_attribute15 Descriptive flexfield segment.
78 * @param p_attribute16 Descriptive flexfield segment.
79 * @param p_attribute17 Descriptive flexfield segment.
80 * @param p_attribute18 Descriptive flexfield segment.
81 * @param p_attribute19 Descriptive flexfield segment.
82 * @param p_attribute20 Descriptive flexfield segment.
83 * @param p_segment1 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT1}
84 * @param p_segment2 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT2}
85 * @param p_segment3 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT3}
86 * @param p_segment4 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT4}
87 * @param p_segment5 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT5}
88 * @param p_segment6 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT6}
89 * @param p_segment7 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT7}
90 * @param p_segment8 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT8}
91 * @param p_segment9 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT9}
92 * @param p_segment10 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT10}
93 * @param p_segment11 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT11}
94 * @param p_segment12 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT12}
95 * @param p_segment13 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT13}
96 * @param p_segment14 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT14}
97 * @param p_segment15 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT15}
98 * @param p_segment16 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT16}
99 * @param p_segment17 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT17}
100 * @param p_segment18 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT18}
101 * @param p_segment19 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT19}
102 * @param p_segment20 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT20}
103 * @param p_segment21 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT21}
104 * @param p_segment22 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT22}
105 * @param p_segment23 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT23}
106 * @param p_segment24 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT24}
107 * @param p_segment25 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT25}
108 * @param p_segment26 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT26}
109 * @param p_segment27 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT27}
110 * @param p_segment28 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT28}
111 * @param p_segment29 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT29}
112 * @param p_segment30 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT30}
113 * @param p_concat_segments Concatenated competence name
114 * @param p_competence_id If p_validate is false, uniquely identifies the
115 * competence created. If p_validate is true, set to null.
116 * @param p_competence_definition_id If p_competence_definition_id is NULL, the
117 * API creates a record in PER_COMPETENCE_DEFINITIONS and pass the
118 * competence_definition_id. When the p_competence_definition_id is not NULL,
119 * the API will be set to the same value which was passed in if p_validate is
120 * false. If p_validate is true then will be set to the same value which was
121 * passed in.
122 * @param p_object_version_number If p_validate is false, then set to the
123 * version number of the created competence. If p_validate is true, then the
124 * value will be null.
125 * @param p_name If p_validate is false, then this set competence name derive
126 * from p_segment parameters or p_conct_segments parameter. If p_validate is
127 * true, then set to null.
128 * @param p_competence_cluster HR-XML Board specified field for competencies.
129 * This determines whether the competence is a unit standard competence or
130 * Normal competence.
131 * @param p_unit_standard_id Unique registered Number / Code for the Unit
132 * Standard.
133 * @param p_credit_type Credits attached to the Unit Standard.
134 * @param p_credits An indication of the value of the Unit Standard.
135 * @param p_level_type Unit Standard Level type.
136 * @param p_level_number Unit Standard Level. These level take into account the
137 * depth of how the knowledge, skills, and values in a specific sub-field have
138 * been advanced learning.
139 * @param p_field Field of Learning applies to the specific Industry / Sector
140 * for the Unit Standard.
141 * @param p_sub_field Sub-field of the Unit Standard.
142 * @param p_provider A unique code that identifies the Provider of the Unit
143 * Standard. Trading Quality Assurance Organizations allocate these codes to
144 * providers when they register with them.
145 * @param p_qa_organization A code that identifies the Trading qualify
146 * Assurance Organization that the provider is registered with.
147 * @param p_information_category This context value determines which flexfield
148 * structure to use with the developer descriptive flexfield segments.
149 * @param p_information1 Developer descriptive flexfield segment.
150 * @param p_information2 Developer descriptive flexfield segment.
151 * @param p_information3 Developer descriptive flexfield segment.
152 * @param p_information4 Developer descriptive flexfield segment.
153 * @param p_information5 Developer descriptive flexfield segment.
154 * @param p_information6 Developer descriptive flexfield segment.
155 * @param p_information7 Developer descriptive flexfield segment.
156 * @param p_information8 Developer descriptive flexfield segment.
157 * @param p_information9 Developer descriptive flexfield segment.
158 * @param p_information10 Developer descriptive flexfield segment.
159 * @param p_information11 Developer descriptive flexfield segment.
160 * @param p_information12 Developer descriptive flexfield segment.
161 * @param p_information13 Developer descriptive flexfield segment.
162 * @param p_information14 Developer descriptive flexfield segment.
163 * @param p_information15 Developer descriptive flexfield segment.
164 * @param p_information16 Developer descriptive flexfield segment.
165 * @param p_information17 Developer descriptive flexfield segment.
166 * @param p_information18 Developer descriptive flexfield segment.
167 * @param p_information19 Developer descriptive flexfield segment.
168 * @param p_information20 Developer descriptive flexfield segment.
169 * @rep:displayname Create a Competence
170 * @rep:category BUSINESS_ENTITY PER_COMPETENCE
171 * @rep:lifecycle active
172 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
173 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
174 * @rep:scope public
175 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
176 */
177 --
178 -- {End Of Comments}
179 --
180 procedure create_competence
181 (p_validate in boolean default false,
182 p_effective_date in date,
183 p_language_code in varchar2 default hr_api.userenv_lang ,
184 p_business_group_id in number default null,
185 p_description in varchar2 default null,
186 p_competence_alias in varchar2 default null,
187 p_date_from in date,
188 p_date_to in date default null,
189 p_behavioural_indicator in varchar2 default null,
190 p_certification_required in varchar2 default 'N',
191 p_evaluation_method in varchar2 default null,
192 p_renewal_period_frequency in number default null,
193 p_renewal_period_units in varchar2 default null,
194 p_rating_scale_id in number default null,
195 p_attribute_category in varchar2 default null,
199 p_attribute4 in varchar2 default null,
196 p_attribute1 in varchar2 default null,
197 p_attribute2 in varchar2 default null,
198 p_attribute3 in varchar2 default null,
200 p_attribute5 in varchar2 default null,
201 p_attribute6 in varchar2 default null,
202 p_attribute7 in varchar2 default null,
203 p_attribute8 in varchar2 default null,
204 p_attribute9 in varchar2 default null,
205 p_attribute10 in varchar2 default null,
206 p_attribute11 in varchar2 default null,
207 p_attribute12 in varchar2 default null,
208 p_attribute13 in varchar2 default null,
209 p_attribute14 in varchar2 default null,
210 p_attribute15 in varchar2 default null,
211 p_attribute16 in varchar2 default null,
212 p_attribute17 in varchar2 default null,
213 p_attribute18 in varchar2 default null,
214 p_attribute19 in varchar2 default null,
215 p_attribute20 in varchar2 default null,
216 p_segment1 in varchar2 default null,
217 p_segment2 in varchar2 default null,
218 p_segment3 in varchar2 default null,
219 p_segment4 in varchar2 default null,
220 p_segment5 in varchar2 default null,
221 p_segment6 in varchar2 default null,
222 p_segment7 in varchar2 default null,
223 p_segment8 in varchar2 default null,
224 p_segment9 in varchar2 default null,
225 p_segment10 in varchar2 default null,
226 p_segment11 in varchar2 default null,
227 p_segment12 in varchar2 default null,
228 p_segment13 in varchar2 default null,
229 p_segment14 in varchar2 default null,
230 p_segment15 in varchar2 default null,
231 p_segment16 in varchar2 default null,
232 p_segment17 in varchar2 default null,
233 p_segment18 in varchar2 default null,
234 p_segment19 in varchar2 default null,
235 p_segment20 in varchar2 default null,
236 p_segment21 in varchar2 default null,
237 p_segment22 in varchar2 default null,
238 p_segment23 in varchar2 default null,
239 p_segment24 in varchar2 default null,
240 p_segment25 in varchar2 default null,
241 p_segment26 in varchar2 default null,
242 p_segment27 in varchar2 default null,
243 p_segment28 in varchar2 default null,
244 p_segment29 in varchar2 default null,
245 p_segment30 in varchar2 default null,
246 p_concat_segments in varchar2 default null,
247 p_competence_id out nocopy number,
248 p_competence_definition_id in out nocopy number,
249 -- p_competence_definition_id out number,
250 p_object_version_number out nocopy number,
251 p_name out nocopy varchar2
252 ,p_competence_cluster in varchar2 default null
253 ,p_unit_standard_id in varchar2 default null
254 ,p_credit_type in varchar2 default null
255 ,p_credits in number default null
256 ,p_level_type in varchar2 default null
257 ,p_level_number in number default null
258 ,p_field in varchar2 default null
259 ,p_sub_field in varchar2 default null
260 ,p_provider in varchar2 default null
261 ,p_qa_organization in varchar2 default null
262 ,p_information_category in varchar2 default null
263 ,p_information1 in varchar2 default null
264 ,p_information2 in varchar2 default null
265 ,p_information3 in varchar2 default null
266 ,p_information4 in varchar2 default null
267 ,p_information5 in varchar2 default null
268 ,p_information6 in varchar2 default null
269 ,p_information7 in varchar2 default null
270 ,p_information8 in varchar2 default null
271 ,p_information9 in varchar2 default null
272 ,p_information10 in varchar2 default null
273 ,p_information11 in varchar2 default null
274 ,p_information12 in varchar2 default null
275 ,p_information13 in varchar2 default null
276 ,p_information14 in varchar2 default null
277 ,p_information15 in varchar2 default null
278 ,p_information16 in varchar2 default null
279 ,p_information17 in varchar2 default null
283 );
280 ,p_information18 in varchar2 default null
281 ,p_information19 in varchar2 default null
282 ,p_information20 in varchar2 default null
284 --
285 -- ----------------------------------------------------------------------------
286 -- |------------------------< <update_competence> >--------------------------|
287 -- ----------------------------------------------------------------------------
288 -- {Start Of Comments}
289 /*#
290 * This API updates the competence.
291 *
292 *
293 * <p><b>Licensing</b><br>
294 * This API is licensed for use with Oracle Human Resources.
295 *
296 * <p><b>Prerequisites</b><br>
297 * The competence must exist.
298 *
299 * <p><b>Post Success</b><br>
300 * The competence will have been updated.
301 *
302 * <p><b>Post Failure</b><br>
303 * The competence will not be updated and an error will be raised.
304 *
305 * @param p_validate If true, then validation alone will be performed and the
306 * database will remain unchanged. If false and all validation checks pass,
307 * then the database will be modified.
308 * @param p_effective_date Reference date for validating lookup values are
309 * applicable during the start to end active date range. This date does not
310 * determine when the changes take effect.
311 * @param p_competence_id {@rep:casecolumn PER_COMPETENCES.COMPETENCE_ID}
312 * @param p_object_version_number Pass in the current version number of the
313 * competence to be updated. When the API completes if p_validate is false,
314 * will be set to the new version number of the updated competence. If
315 * p_validate is true will be set to the same value which was passed in.
316 * @param p_language_code Specifies to which language the translation values
317 * apply. You can set to the base or any installed language. The default value
318 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
319 * value.
320 * @param p_name If p_validate is false, then this set competence name derive
321 * from p_segment parameters or p_conct_segments parameter. If p_validate is
322 * true, then set to null.
323 * @param p_description {@rep:casecolumn PER_COMPETENCES.DESCRIPTION}
324 * @param p_date_from {@rep:casecolumn PER_COMPETENCES.DATE_FROM}
325 * @param p_date_to {@rep:casecolumn PER_COMPETENCES.DATE_TO}
326 * @param p_behavioural_indicator {@rep:casecolumn
327 * PER_COMPETENCES.BEHAVIOURAL_INDICATOR}
328 * @param p_certification_required Certification Requried, 'Yes' or 'No'. Valid
329 * values are defined by 'YES_NO' lookup type
330 * @param p_evaluation_method Evaluation Method. Valid values are defined by
331 * 'COMPETENCE_EVAL_TYPE' lookup type.
332 * @param p_renewal_period_frequency {@rep:casecolumn
333 * PER_COMPETENCES.RENEWAL_PERIOD_FREQUENCY}
334 * @param p_renewal_period_units Renewal period units. Valid values are defined
335 * by 'FREQUENCY' lookup type.
336 * @param p_rating_scale_id {@rep:casecolumn PER_COMPETENCES.RATING_SCALE_ID}
337 * @param p_attribute_category This context value determines which flexfield
338 * structure to use with the descriptive flexfield segments.
339 * @param p_attribute1 Descriptive flexfield segment.
340 * @param p_attribute2 Descriptive flexfield segment.
341 * @param p_attribute3 Descriptive flexfield segment.
342 * @param p_attribute4 Descriptive flexfield segment.
343 * @param p_attribute5 Descriptive flexfield segment.
344 * @param p_attribute6 Descriptive flexfield segment.
345 * @param p_attribute7 Descriptive flexfield segment.
346 * @param p_attribute8 Descriptive flexfield segment.
347 * @param p_attribute9 Descriptive flexfield segment.
348 * @param p_attribute10 Descriptive flexfield segment.
349 * @param p_attribute11 Descriptive flexfield segment.
350 * @param p_attribute12 Descriptive flexfield segment.
351 * @param p_attribute13 Descriptive flexfield segment.
352 * @param p_attribute14 Descriptive flexfield segment.
353 * @param p_attribute15 Descriptive flexfield segment.
354 * @param p_attribute16 Descriptive flexfield segment.
355 * @param p_attribute17 Descriptive flexfield segment.
356 * @param p_attribute18 Descriptive flexfield segment.
357 * @param p_attribute19 Descriptive flexfield segment.
358 * @param p_attribute20 Descriptive flexfield segment.
359 * @param p_competence_alias Competence alias
360 * @param p_segment1 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT1}
361 * @param p_segment2 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT2}
362 * @param p_segment3 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT3}
363 * @param p_segment4 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT4}
364 * @param p_segment5 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT5}
365 * @param p_segment6 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT6}
366 * @param p_segment7 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT7}
367 * @param p_segment8 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT8}
368 * @param p_segment9 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT9}
369 * @param p_segment10 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT10}
370 * @param p_segment11 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT11}
371 * @param p_segment12 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT12}
372 * @param p_segment13 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT13}
373 * @param p_segment14 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT14}
374 * @param p_segment15 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT15}
375 * @param p_segment16 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT16}
376 * @param p_segment17 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT17}
380 * @param p_segment21 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT21}
377 * @param p_segment18 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT18}
378 * @param p_segment19 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT19}
379 * @param p_segment20 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT20}
381 * @param p_segment22 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT22}
382 * @param p_segment23 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT23}
383 * @param p_segment24 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT24}
384 * @param p_segment25 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT25}
385 * @param p_segment26 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT26}
386 * @param p_segment27 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT27}
387 * @param p_segment28 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT28}
388 * @param p_segment29 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT29}
389 * @param p_segment30 {@rep:casecolumn PER_COMPETENCE_DEFINITIONS.SEGMENT30}
390 * @param p_concat_segments Concatenated competence name
391 * @param p_competence_definition_id Unique identifier of the competence
392 * definition to update.
393 * @param p_competence_cluster HR-XML Board specified field for competencies.
394 * This determines whether the competence is a unit standard competence or
395 * Normal competence.
396 * @param p_unit_standard_id Unique registered Number / Code for the Unit
397 * Standard.
398 * @param p_credit_type Credits attached to the Unit Standard.
399 * @param p_credits An indication of the value of the Unit Standard.
400 * @param p_level_type Unit Standard Level type.
401 * @param p_level_number Unit Standard Level. These level take into account the
402 * depth of how the knowledge, skills, and values in a specific sub-field have
403 * been advanced learning.
404 * @param p_field Field of Learning applies to the specific Industry / Sector
405 * for the Unit Standard.
406 * @param p_sub_field Sub-field of the Unit Standard.
407 * @param p_provider A unique code that identifies the Provider of the Unit
408 * Standard. Trading Quality Assurance Organizations allocate these codes to
409 * providers when they register with them.
410 * @param p_qa_organization A code that identifies the Trading qualify
411 * Assurance Organization that the provider is registered with.
412 * @param p_information_category This context value determines which flexfield
413 * structure to use with the developer descriptive flexfield segments.
414 * @param p_information1 Developer descriptive flexfield segment.
415 * @param p_information2 Developer descriptive flexfield segment.
416 * @param p_information3 Developer descriptive flexfield segment.
417 * @param p_information4 Developer descriptive flexfield segment.
418 * @param p_information5 Developer descriptive flexfield segment.
419 * @param p_information6 Developer descriptive flexfield segment.
420 * @param p_information7 Developer descriptive flexfield segment.
421 * @param p_information8 Developer descriptive flexfield segment.
422 * @param p_information9 Developer descriptive flexfield segment.
423 * @param p_information10 Developer descriptive flexfield segment.
424 * @param p_information11 Developer descriptive flexfield segment.
425 * @param p_information12 Developer descriptive flexfield segment.
426 * @param p_information13 Developer descriptive flexfield segment.
427 * @param p_information14 Developer descriptive flexfield segment.
428 * @param p_information15 Developer descriptive flexfield segment.
429 * @param p_information16 Developer descriptive flexfield segment.
430 * @param p_information17 Developer descriptive flexfield segment.
431 * @param p_information18 Developer descriptive flexfield segment.
432 * @param p_information19 Developer descriptive flexfield segment.
433 * @param p_information20 Developer descriptive flexfield segment.
434 * @rep:displayname Update a Competence
435 * @rep:category BUSINESS_ENTITY PER_COMPETENCE
436 * @rep:lifecycle active
437 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
438 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
439 * @rep:scope public
440 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
441 */
442 --
443 -- {End Of Comments}
444 procedure update_competence
445 (p_validate in boolean default false,
446 p_effective_date in date,
447 p_competence_id in number,
448 p_object_version_number in out nocopy number,
449 p_language_code in varchar2 default hr_api.userenv_lang ,
450 p_name out nocopy varchar2 ,
451 p_description in varchar2 default hr_api.g_varchar2,
452 p_date_from in date default hr_api.g_date,
453 p_date_to in date default hr_api.g_date,
454 p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
455 p_certification_required in varchar2 default hr_api.g_varchar2,
456 p_evaluation_method in varchar2 default hr_api.g_varchar2,
457 p_renewal_period_frequency in number default hr_api.g_number,
458 p_renewal_period_units in varchar2 default hr_api.g_varchar2,
459 p_rating_scale_id in number default hr_api.g_number,
460 p_attribute_category in varchar2 default hr_api.g_varchar2,
461 p_attribute1 in varchar2 default hr_api.g_varchar2,
462 p_attribute2 in varchar2 default hr_api.g_varchar2,
463 p_attribute3 in varchar2 default hr_api.g_varchar2,
464 p_attribute4 in varchar2 default hr_api.g_varchar2,
468 p_attribute8 in varchar2 default hr_api.g_varchar2,
465 p_attribute5 in varchar2 default hr_api.g_varchar2,
466 p_attribute6 in varchar2 default hr_api.g_varchar2,
467 p_attribute7 in varchar2 default hr_api.g_varchar2,
469 p_attribute9 in varchar2 default hr_api.g_varchar2,
470 p_attribute10 in varchar2 default hr_api.g_varchar2,
471 p_attribute11 in varchar2 default hr_api.g_varchar2,
472 p_attribute12 in varchar2 default hr_api.g_varchar2,
473 p_attribute13 in varchar2 default hr_api.g_varchar2,
474 p_attribute14 in varchar2 default hr_api.g_varchar2,
475 p_attribute15 in varchar2 default hr_api.g_varchar2,
476 p_attribute16 in varchar2 default hr_api.g_varchar2,
477 p_attribute17 in varchar2 default hr_api.g_varchar2,
478 p_attribute18 in varchar2 default hr_api.g_varchar2,
479 p_attribute19 in varchar2 default hr_api.g_varchar2,
480 p_attribute20 in varchar2 default hr_api.g_varchar2,
481 p_competence_alias in varchar2 default hr_api.g_varchar2,
482 p_segment1 in varchar2 default hr_api.g_varchar2,
483 p_segment2 in varchar2 default hr_api.g_varchar2,
484 p_segment3 in varchar2 default hr_api.g_varchar2,
485 p_segment4 in varchar2 default hr_api.g_varchar2,
486 p_segment5 in varchar2 default hr_api.g_varchar2,
487 p_segment6 in varchar2 default hr_api.g_varchar2,
488 p_segment7 in varchar2 default hr_api.g_varchar2,
489 p_segment8 in varchar2 default hr_api.g_varchar2,
490 p_segment9 in varchar2 default hr_api.g_varchar2,
491 p_segment10 in varchar2 default hr_api.g_varchar2,
492 p_segment11 in varchar2 default hr_api.g_varchar2,
493 p_segment12 in varchar2 default hr_api.g_varchar2,
494 p_segment13 in varchar2 default hr_api.g_varchar2,
495 p_segment14 in varchar2 default hr_api.g_varchar2,
496 p_segment15 in varchar2 default hr_api.g_varchar2,
497 p_segment16 in varchar2 default hr_api.g_varchar2,
498 p_segment17 in varchar2 default hr_api.g_varchar2,
499 p_segment18 in varchar2 default hr_api.g_varchar2,
500 p_segment19 in varchar2 default hr_api.g_varchar2,
501 p_segment20 in varchar2 default hr_api.g_varchar2,
502 p_segment21 in varchar2 default hr_api.g_varchar2,
503 p_segment22 in varchar2 default hr_api.g_varchar2,
504 p_segment23 in varchar2 default hr_api.g_varchar2,
505 p_segment24 in varchar2 default hr_api.g_varchar2,
506 p_segment25 in varchar2 default hr_api.g_varchar2,
507 p_segment26 in varchar2 default hr_api.g_varchar2,
508 p_segment27 in varchar2 default hr_api.g_varchar2,
509 p_segment28 in varchar2 default hr_api.g_varchar2,
510 p_segment29 in varchar2 default hr_api.g_varchar2,
511 p_segment30 in varchar2 default hr_api.g_varchar2,
512 p_concat_segments in varchar2 default hr_api.g_varchar2,
513 p_competence_definition_id in out nocopy number
514 ,p_competence_cluster in varchar2 default hr_api.g_varchar2
515 ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
519 ,p_level_number in number default hr_api.g_number
516 ,p_credit_type in varchar2 default hr_api.g_varchar2
517 ,p_credits in number default hr_api.g_number
518 ,p_level_type in varchar2 default hr_api.g_varchar2
520 ,p_field in varchar2 default hr_api.g_varchar2
521 ,p_sub_field in varchar2 default hr_api.g_varchar2
522 ,p_provider in varchar2 default hr_api.g_varchar2
523 ,p_qa_organization in varchar2 default hr_api.g_varchar2
524 ,p_information_category in varchar2 default hr_api.g_varchar2
525 ,p_information1 in varchar2 default hr_api.g_varchar2
526 ,p_information2 in varchar2 default hr_api.g_varchar2
527 ,p_information3 in varchar2 default hr_api.g_varchar2
528 ,p_information4 in varchar2 default hr_api.g_varchar2
529 ,p_information5 in varchar2 default hr_api.g_varchar2
530 ,p_information6 in varchar2 default hr_api.g_varchar2
531 ,p_information7 in varchar2 default hr_api.g_varchar2
532 ,p_information8 in varchar2 default hr_api.g_varchar2
533 ,p_information9 in varchar2 default hr_api.g_varchar2
534 ,p_information10 in varchar2 default hr_api.g_varchar2
535 ,p_information11 in varchar2 default hr_api.g_varchar2
536 ,p_information12 in varchar2 default hr_api.g_varchar2
537 ,p_information13 in varchar2 default hr_api.g_varchar2
538 ,p_information14 in varchar2 default hr_api.g_varchar2
539 ,p_information15 in varchar2 default hr_api.g_varchar2
540 ,p_information16 in varchar2 default hr_api.g_varchar2
541 ,p_information17 in varchar2 default hr_api.g_varchar2
542 ,p_information18 in varchar2 default hr_api.g_varchar2
543 ,p_information19 in varchar2 default hr_api.g_varchar2
544 ,p_information20 in varchar2 default hr_api.g_varchar2
545 );
546 --
547 -- ----------------------------------------------------------------------------
548 -- |------------------------< <delete_competence> >--------------------------|
549 -- ----------------------------------------------------------------------------
550 -- {Start Of Comments}
551 /*#
552 * This API deletes the competence.
553 *
554 *
555 * <p><b>Licensing</b><br>
556 * This API is licensed for use with Oracle Human Resources.
557 *
558 * <p><b>Prerequisites</b><br>
559 * The competence must exist.
560 *
561 * <p><b>Post Success</b><br>
562 * The competence will have been deleted.
563 *
564 * <p><b>Post Failure</b><br>
565 * The competence will not be deleted and an error will be raised.
566 *
567 * @param p_validate If true, then validation alone will be performed and the
571 * @param p_object_version_number Current version number of the competence to
568 * database will remain unchanged. If false and all validation checks pass,
569 * then the database will be modified.
570 * @param p_competence_id {@rep:casecolumn PER_COMPETENCES.COMPETENCE_ID}
572 * be deleted.
573 * @rep:displayname Delete a Competence
574 * @rep:category BUSINESS_ENTITY PER_COMPETENCE
575 * @rep:lifecycle active
576 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
577 * @rep:scope public
578 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
579 */
580 --
581 -- {End Of Comments}
582 --
583 procedure delete_competence
584 (p_validate in boolean default false,
585 p_competence_id in number,
586 p_object_version_number in number
587 );
588 --
589 -- ----------------------------------------------------------------------------
590 -- |-------------------< <create_or_update_competence> >-----------------------|
591 -- ----------------------------------------------------------------------------
592 -- {Start Of Comments}
593 /*#
594 * This API creates a competence if the name does not exist and updates the
595 * competence if the name already exists.
596 *
597 * This API is used for skills vendor integration.
598 *
599 * <p><b>Licensing</b><br>
600 * This API is licensed for use with Oracle Human Resources.
601 *
602 * <p><b>Prerequisites</b><br>
603 * No known prerequisites.
604 *
605 * <p><b>Post Success</b><br>
606 * The competence will have been created or updated.
607 *
608 * <p><b>Post Failure</b><br>
609 * The competence will not be created or updated and an error will be raised.
610 *
611 * @param p_validate If true, then validation alone will be performed and the
612 * database will remain unchanged. If false and all validation checks pass,
613 * then the database will be modified.
614 * @param p_effective_date Reference date for validating lookup values are
615 * applicable during the start to end active date range. This date does not
616 * determine when the changes take effect.
617 * @param p_language_code Specifies to which language the translation values
618 * apply. You can set to the base or any installed language. The default value
619 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
620 * value.
621 * @param p_category Category name
622 * @param p_name Competence name
623 * @param p_date_from {@rep:casecolumn PER_COMPETENCES.DATE_FROM}
624 * @param p_date_to {@rep:casecolumn PER_COMPETENCES.DATE_TO}
625 * @param p_description {@rep:casecolumn PER_COMPETENCES.DESCRIPTION}
626 * @param p_competence_alias Competence alias
627 * @param p_behavioural_indicator {@rep:casecolumn
628 * PER_COMPETENCES.BEHAVIOURAL_INDICATOR}
629 * @param p_certification_required Certification Requried, 'Yes' or 'No'. Valid
630 * values are defined by 'YES_NO' lookup type
631 * @param p_evaluation_method Evaluation Method. Valid values are defined by
632 * 'COMPETENCE_EVAL_TYPE' lookup type.
633 * @param p_renewal_period_frequency {@rep:casecolumn
634 * PER_COMPETENCES.RENEWAL_PERIOD_FREQUENCY}
635 * @param p_renewal_period_units Renewal period units. Valid values are defined
636 * by 'FREQUENCY' lookup type.
637 * @param p_rating_scale_name Rating scale name
638 * @param p_translated_language If the name parameter is translated, this is
639 * the language code for the name
640 * @param p_source_category_name This is the category name with the source
641 * language code
642 * @param p_source_competence_name This is the competence name with the source
643 * language code
644 * @rep:displayname Create or Update a Competence
645 * @rep:category BUSINESS_ENTITY PER_COMPETENCE
646 * @rep:lifecycle active
647 * @rep:scope public
648 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
649 */
650 --
651 -- {End Of Comments}
652 --
653 procedure create_or_update_competence
654 (p_validate in boolean default false
655 ,p_effective_date in date default trunc(sysdate)
656 ,p_language_code in varchar2 default hr_api.userenv_lang
657 ,p_category in varchar2 default null
658 ,p_name in varchar2 default null
659 ,p_date_from in date default trunc(sysdate)
660 ,p_date_to in date default null
661 ,p_description in varchar2 default null
662 ,p_competence_alias in varchar2 default null
663 ,p_behavioural_indicator in varchar2 default null
664 ,p_certification_required in varchar2 default null
665 ,p_evaluation_method in varchar2 default null
666 ,p_renewal_period_frequency in number default null
667 ,p_renewal_period_units in varchar2 default null
668 ,p_rating_scale_name in varchar2 default null
669 ,p_translated_language in varchar2 default null
670 ,p_source_category_name in varchar2 default null
671 ,p_source_competence_name in varchar2 default null
672 );
673 --
674 end hr_competences_api;