1 Package PER_QUALIFICATIONS_API as
2 /* $Header: pequaapi.pkh 120.1.12010000.2 2008/11/11 12:17:21 rvagvala ship $ */
3 /*#
4 * This package contains Qualification APIs.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Qualification
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |---------------------------< create_qualification >-----------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates qualification.
17 *
18 * A qualification is a record of an educational qualification, certificates,
19 * licenses, etc that a person holds or is acquiring.
20 *
21 * <p><b>Licensing</b><br>
22 * This API is licensed for use with Human Resources and iRecruitment.
23 *
24 * <p><b>Prerequisites</b><br>
25 * Person for whom the qualification is being created must exist. A valid
26 * QUALIFICATION_TYPE must exist.
27 *
28 * <p><b>Post Success</b><br>
29 * Qualification record is created.
30 *
31 * <p><b>Post Failure</b><br>
32 * Qualification is not created and an error is raised.
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 Reference date for validating lookup values are
37 * applicable during the start to end active date range. This date does not
38 * determine when the changes take effect.
39 * @param p_qualification_type_id Identifies the qualification type.
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 Identifies the business group of the person
45 * @param p_person_id Identifies the person who holds the qualification.
46 * @param p_title Title (name) of the qualification.
47 * @param p_grade_attained Grade attained for the qualification.
48 * @param p_status Status of this qualification. Valid values are defined by
49 * PER_SUBJECT_STATUSES lookup type.
50 * @param p_awarded_date Date qualification awarded
51 * @param p_fee Cost of qualification (tuition fee).
52 * @param p_fee_currency Currency in which fee is paid.
53 * @param p_training_completed_amount Amount of training completed
54 * @param p_reimbursement_arrangements Reimbursement condition information.
55 * @param p_training_completed_units Holds the current unit of training
56 * @param p_total_training_amount Total number of training units
57 * @param p_start_date Start date of training
58 * @param p_end_date End date of training
59 * @param p_license_number Number of license
60 * @param p_expiry_date Date license expires
61 * @param p_license_restrictions License restrictions
62 * @param p_projected_completion_date Projected completion date of
63 * qualification.
64 * @param p_awarding_body Awarding body.
65 * @param p_tuition_method Method of tuition. Valid values are defined by
66 * PER_TUITION_METHODS lookup type.
67 * @param p_group_ranking Ranking within study group
68 * @param p_comments Comment text.
69 * @param p_attendance_id Identifies the attendance record for this
70 * qualification.
71 * @param p_attribute_category This context value determines which flexfield
72 * structure to use with the descriptive flexfield segments.
73 * @param p_attribute1 Descriptive flexfield segment.
74 * @param p_attribute2 Descriptive flexfield segment.
75 * @param p_attribute3 Descriptive flexfield segment.
76 * @param p_attribute4 Descriptive flexfield segment.
77 * @param p_attribute5 Descriptive flexfield segment.
78 * @param p_attribute6 Descriptive flexfield segment.
79 * @param p_attribute7 Descriptive flexfield segment.
80 * @param p_attribute8 Descriptive flexfield segment.
81 * @param p_attribute9 Descriptive flexfield segment.
82 * @param p_attribute10 Descriptive flexfield segment.
83 * @param p_attribute11 Descriptive flexfield segment.
84 * @param p_attribute12 Descriptive flexfield segment.
85 * @param p_attribute13 Descriptive flexfield segment.
86 * @param p_attribute14 Descriptive flexfield segment.
87 * @param p_attribute15 Descriptive flexfield segment.
88 * @param p_attribute16 Descriptive flexfield segment.
89 * @param p_attribute17 Descriptive flexfield segment.
90 * @param p_attribute18 Descriptive flexfield segment.
91 * @param p_attribute19 Descriptive flexfield segment.
92 * @param p_attribute20 Descriptive flexfield segment.
93 * @param p_party_id Identifies the Party associated with this qualification.
94 * @param p_qua_information_category This context value determines which
95 * Flexfield Structure to use with the Developer Descriptive flexfield segments
96 * @param p_qua_information1 Developer Descriptive flexfield segment.
97 * @param p_qua_information2 Developer Descriptive flexfield segment.
98 * @param p_qua_information3 Developer Descriptive flexfield segment.
99 * @param p_qua_information4 Developer Descriptive flexfield segment.
100 * @param p_qua_information5 Developer Descriptive flexfield segment.
101 * @param p_qua_information6 Developer Descriptive flexfield segment.
102 * @param p_qua_information7 Developer Descriptive flexfield segment.
103 * @param p_qua_information8 Developer Descriptive flexfield segment.
104 * @param p_qua_information9 Developer Descriptive flexfield segment.
105 * @param p_qua_information10 Developer Descriptive flexfield segment.
106 * @param p_qua_information11 Developer Descriptive flexfield segment.
107 * @param p_qua_information12 Developer Descriptive flexfield segment.
108 * @param p_qua_information13 Developer Descriptive flexfield segment.
109 * @param p_qua_information14 Developer Descriptive flexfield segment.
110 * @param p_qua_information15 Developer Descriptive flexfield segment.
111 * @param p_qua_information16 Developer Descriptive flexfield segment.
112 * @param p_qua_information17 Developer Descriptive flexfield segment.
113 * @param p_qua_information18 Developer Descriptive flexfield segment.
114 * @param p_qua_information19 Developer Descriptive flexfield segment.
115 * @param p_qua_information20 Developer Descriptive flexfield segment.
116 * @param p_professional_body_name Name of professional body associated with
117 * this qualification.
118 * @param p_membership_number Membership number for professional body
119 * associated with this qualification.
120 * @param p_membership_category Membership category of the professional body
121 * which is associated with this qualification.
122 * @param p_subscription_payment_method Method of payment of subscription
123 * charge for professional body belonged to this qualification.
124 * @param p_qualification_id If p_validate is false, then this uniquely
125 * identifies the qualification created. If p_validate is true, then set to
126 * null.
127 * @param p_object_version_number If p_validate is false, then set to the
128 * version number of the created qualification. If p_validate is true, then the
129 * value will be null.
130 * @rep:displayname Create Qualification
131 * @rep:category BUSINESS_ENTITY PER_QUALIFICATION
132 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
133 * @rep:scope public
134 * @rep:lifecycle active
135 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
136 */
137 --
138 -- {End Of Comments}
139 --
140 procedure CREATE_QUALIFICATION
141 (p_validate in boolean default false
142 ,p_effective_date in date
143 ,p_qualification_type_id in number
144 ,p_language_code in varchar2 default hr_api.userenv_lang
145 ,p_business_group_id in number default null
146 ,p_person_id in number default null
147 ,p_title in varchar2 default null
148 ,p_grade_attained in varchar2 default null
149 ,p_status in varchar2 default null
150 ,p_awarded_date in date default null
151 ,p_fee in number default null
152 ,p_fee_currency in varchar2 default null
153 ,p_training_completed_amount in number default null
154 ,p_reimbursement_arrangements in varchar2 default null
155 ,p_training_completed_units in varchar2 default null
156 ,p_total_training_amount in number default null
157 ,p_start_date in date default null
158 ,p_end_date in date default null
159 ,p_license_number in varchar2 default null
160 ,p_expiry_date in date default null
161 ,p_license_restrictions in varchar2 default null
162 ,p_projected_completion_date in date default null
163 ,p_awarding_body in varchar2 default null
164 ,p_tuition_method in varchar2 default null
165 ,p_group_ranking in varchar2 default null
166 ,p_comments in varchar2 default null
167 ,p_attendance_id in number default null
168 ,p_attribute_category in varchar2 default null
169 ,p_attribute1 in varchar2 default null
170 ,p_attribute2 in varchar2 default null
171 ,p_attribute3 in varchar2 default null
172 ,p_attribute4 in varchar2 default null
173 ,p_attribute5 in varchar2 default null
174 ,p_attribute6 in varchar2 default null
175 ,p_attribute7 in varchar2 default null
176 ,p_attribute8 in varchar2 default null
177 ,p_attribute9 in varchar2 default null
178 ,p_attribute10 in varchar2 default null
179 ,p_attribute11 in varchar2 default null
180 ,p_attribute12 in varchar2 default null
181 ,p_attribute13 in varchar2 default null
182 ,p_attribute14 in varchar2 default null
183 ,p_attribute15 in varchar2 default null
184 ,p_attribute16 in varchar2 default null
185 ,p_attribute17 in varchar2 default null
186 ,p_attribute18 in varchar2 default null
187 ,p_attribute19 in varchar2 default null
188 ,p_attribute20 in varchar2 default null
189 ,p_party_id in number default null
190 ,p_qua_information_category in varchar2 default null
191 ,p_qua_information1 in varchar2 default null
192 ,p_qua_information2 in varchar2 default null
193 ,p_qua_information3 in varchar2 default null
194 ,p_qua_information4 in varchar2 default null
195 ,p_qua_information5 in varchar2 default null
196 ,p_qua_information6 in varchar2 default null
197 ,p_qua_information7 in varchar2 default null
198 ,p_qua_information8 in varchar2 default null
199 ,p_qua_information9 in varchar2 default null
200 ,p_qua_information10 in varchar2 default null
201 ,p_qua_information11 in varchar2 default null
202 ,p_qua_information12 in varchar2 default null
203 ,p_qua_information13 in varchar2 default null
204 ,p_qua_information14 in varchar2 default null
205 ,p_qua_information15 in varchar2 default null
206 ,p_qua_information16 in varchar2 default null
207 ,p_qua_information17 in varchar2 default null
208 ,p_qua_information18 in varchar2 default null
209 ,p_qua_information19 in varchar2 default null
210 ,p_qua_information20 in varchar2 default null
211 ,p_professional_body_name in varchar2 default null
212 ,p_membership_number in varchar2 default null
213 ,p_membership_category in varchar2 default null
214 ,p_subscription_payment_method in varchar2 default null
215 ,p_qualification_id out nocopy number
216 ,p_object_version_number out nocopy number
217 );
218 --
219 -- ----------------------------------------------------------------------------
220 -- |---------------------------< update_qualification >-----------------------|
221 -- ----------------------------------------------------------------------------
222 --
223 -- {Start Of Comments}
224 /*#
225 * This API updates qualification.
226 *
227 * A qualification is a record of educational qualification, certificates,
228 * licenses, etc that a person holds or is acquiring.
229 *
230 * <p><b>Licensing</b><br>
231 * This API is licensed for use with iRecruitment and Human Resources.
232 *
233 * <p><b>Prerequisites</b><br>
234 * The person must be created and have a type of 'EMPLOYEE', the
235 * QUALIFICATION_TYPE_ID must exist in PER_QUALIFICATION_TYPES and the
236 * QUALIFICATION_ID must exist in PER_QUALIFICATIONS.
237 *
238 * <p><b>Post Success</b><br>
239 * Qualification is updated.
240 *
241 * <p><b>Post Failure</b><br>
242 * Qualification is not updated and an error is raised.
243 * @param p_validate If true, then validation alone will be performed and the
244 * database will remain unchanged. If false and all validation checks pass,
245 * then the database will be modified.
246 * @param p_effective_date Reference date for validating lookup values are
247 * applicable during the start to end active date range. This date does not
248 * determine when the changes take effect.
249 * @param p_qualification_id Identifies the qualification record to be updated.
250 * @param p_language_code Specifies to which language the translation values
251 * apply. You can set to the base or any installed language. The default value
252 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
253 * value.
254 * @param p_qualification_type_id Identifies the qualification type.
255 * @param p_title Title (name) of the qualification.
256 * @param p_grade_attained Grade attained for the qualification.
257 * @param p_status Status of this qualification. Valid values are defined by
258 * PER_SUBJECT_STATUSES lookup type.
259 * @param p_awarded_date Date qualification awarded
260 * @param p_fee Cost of qualification (tuition fee).
261 * @param p_fee_currency Currency in which fee is paid.
262 * @param p_training_completed_amount Amount of training completed
263 * @param p_reimbursement_arrangements Reimbursement condition information.
264 * @param p_training_completed_units Holds the current unit of training
265 * @param p_total_training_amount Total number of training units
266 * @param p_start_date Start date of training
267 * @param p_end_date End date of training
268 * @param p_license_number Number of license
269 * @param p_expiry_date Date license expires
270 * @param p_license_restrictions License restrictions
271 * @param p_projected_completion_date Projected completion date of
272 * qualification.
273 * @param p_awarding_body Awarding body
274 * @param p_tuition_method Method of tuition. Valid values are defined by
275 * PER_TUITION_METHODS lookup type.
276 * @param p_group_ranking Ranking within study group
277 * @param p_comments Comment text.
278 * @param p_attendance_id Identifies the attendance record for this
279 * qualification.
280 * @param p_attribute_category This context value determines which flexfield
281 * structure to use with the descriptive flexfield segments.
282 * @param p_attribute1 Descriptive flexfield segment.
283 * @param p_attribute2 Descriptive flexfield segment.
284 * @param p_attribute3 Descriptive flexfield segment.
285 * @param p_attribute4 Descriptive flexfield segment.
286 * @param p_attribute5 Descriptive flexfield segment.
287 * @param p_attribute6 Descriptive flexfield segment.
288 * @param p_attribute7 Descriptive flexfield segment.
289 * @param p_attribute8 Descriptive flexfield segment.
290 * @param p_attribute9 Descriptive flexfield segment.
291 * @param p_attribute10 Descriptive flexfield segment.
292 * @param p_attribute11 Descriptive flexfield segment.
293 * @param p_attribute12 Descriptive flexfield segment.
294 * @param p_attribute13 Descriptive flexfield segment.
295 * @param p_attribute14 Descriptive flexfield segment.
296 * @param p_attribute15 Descriptive flexfield segment.
297 * @param p_attribute16 Descriptive flexfield segment.
298 * @param p_attribute17 Descriptive flexfield segment.
299 * @param p_attribute18 Descriptive flexfield segment.
303 * Flexfield Structure to use with the Developer Descriptive flexfield segments
300 * @param p_attribute19 Descriptive flexfield segment.
301 * @param p_attribute20 Descriptive flexfield segment.
302 * @param p_qua_information_category This context value determines which
304 * @param p_qua_information1 Developer Descriptive flexfield segment.
305 * @param p_qua_information2 Developer Descriptive flexfield segment.
306 * @param p_qua_information3 Developer Descriptive flexfield segment.
307 * @param p_qua_information4 Developer Descriptive flexfield segment.
308 * @param p_qua_information5 Developer Descriptive flexfield segment.
309 * @param p_qua_information6 Developer Descriptive flexfield segment.
310 * @param p_qua_information7 Developer Descriptive flexfield segment.
311 * @param p_qua_information8 Developer Descriptive flexfield segment.
312 * @param p_qua_information9 Developer Descriptive flexfield segment.
313 * @param p_qua_information10 Developer Descriptive flexfield segment.
314 * @param p_qua_information11 Developer Descriptive flexfield segment.
315 * @param p_qua_information12 Developer Descriptive flexfield segment.
316 * @param p_qua_information13 Developer Descriptive flexfield segment.
317 * @param p_qua_information14 Developer Descriptive flexfield segment.
318 * @param p_qua_information15 Developer Descriptive flexfield segment.
319 * @param p_qua_information16 Developer Descriptive flexfield segment.
320 * @param p_qua_information17 Developer Descriptive flexfield segment.
321 * @param p_qua_information18 Developer Descriptive flexfield segment.
322 * @param p_qua_information19 Developer Descriptive flexfield segment.
323 * @param p_qua_information20 Developer Descriptive flexfield segment.
324 * @param p_professional_body_name Name of professional body associated with
325 * this qualification.
326 * @param p_membership_number Membership number for professional body
327 * associated with this qualification.
328 * @param p_membership_category Category of membership for the professional
329 * body associated with this qualification.
330 * @param p_subscription_payment_method Method of payment of subscription
331 * charge for professional body associated with this qualification.
332 * @param p_object_version_number Pass in the current version number of the
333 * qualification to be updated. When the API completes if p_validate is false,
334 * will be set to the new version number of the updated qualification. If
335 * p_validate is true will be set to the same value which was passed in
336 * @rep:displayname Update Qualification
337 * @rep:category BUSINESS_ENTITY PER_QUALIFICATION
338 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
339 * @rep:scope public
340 * @rep:lifecycle active
341 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
342 */
343 --
344 -- {End Of Comments}
345 --
346 procedure UPDATE_QUALIFICATION
347 (p_validate in boolean default false
348 ,p_effective_date in date
349 ,p_qualification_id in number
350 ,p_language_code in varchar2 default hr_api.userenv_lang
351 ,p_qualification_type_id in number default hr_api.g_number
352 ,p_title in varchar2 default hr_api.g_varchar2
353 ,p_grade_attained in varchar2 default hr_api.g_varchar2
354 ,p_status in varchar2 default hr_api.g_varchar2
355 ,p_awarded_date in date default hr_api.g_date
356 ,p_fee in number default hr_api.g_number
357 ,p_fee_currency in varchar2 default hr_api.g_varchar2
358 ,p_training_completed_amount in number default hr_api.g_number
359 ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2
360 ,p_training_completed_units in varchar2 default hr_api.g_varchar2
361 ,p_total_training_amount in number default hr_api.g_number
362 ,p_start_date in date default hr_api.g_date
363 ,p_end_date in date default hr_api.g_date
364 ,p_license_number in varchar2 default hr_api.g_varchar2
365 ,p_expiry_date in date default hr_api.g_date
366 ,p_license_restrictions in varchar2 default hr_api.g_varchar2
367 ,p_projected_completion_date in date default hr_api.g_date
368 ,p_awarding_body in varchar2 default hr_api.g_varchar2
369 ,p_tuition_method in varchar2 default hr_api.g_varchar2
370 ,p_group_ranking in varchar2 default hr_api.g_varchar2
371 ,p_comments in varchar2 default hr_api.g_varchar2
372 ,p_attendance_id in number default hr_api.g_number
373 ,p_attribute_category in varchar2 default hr_api.g_varchar2
374 ,p_attribute1 in varchar2 default hr_api.g_varchar2
375 ,p_attribute2 in varchar2 default hr_api.g_varchar2
376 ,p_attribute3 in varchar2 default hr_api.g_varchar2
377 ,p_attribute4 in varchar2 default hr_api.g_varchar2
378 ,p_attribute5 in varchar2 default hr_api.g_varchar2
379 ,p_attribute6 in varchar2 default hr_api.g_varchar2
380 ,p_attribute7 in varchar2 default hr_api.g_varchar2
381 ,p_attribute8 in varchar2 default hr_api.g_varchar2
382 ,p_attribute9 in varchar2 default hr_api.g_varchar2
383 ,p_attribute10 in varchar2 default hr_api.g_varchar2
384 ,p_attribute11 in varchar2 default hr_api.g_varchar2
388 ,p_attribute15 in varchar2 default hr_api.g_varchar2
385 ,p_attribute12 in varchar2 default hr_api.g_varchar2
386 ,p_attribute13 in varchar2 default hr_api.g_varchar2
387 ,p_attribute14 in varchar2 default hr_api.g_varchar2
389 ,p_attribute16 in varchar2 default hr_api.g_varchar2
390 ,p_attribute17 in varchar2 default hr_api.g_varchar2
391 ,p_attribute18 in varchar2 default hr_api.g_varchar2
392 ,p_attribute19 in varchar2 default hr_api.g_varchar2
393 ,p_attribute20 in varchar2 default hr_api.g_varchar2
394 ,p_qua_information_category in varchar2 default hr_api.g_varchar2
395 ,p_qua_information1 in varchar2 default hr_api.g_varchar2
396 ,p_qua_information2 in varchar2 default hr_api.g_varchar2
397 ,p_qua_information3 in varchar2 default hr_api.g_varchar2
398 ,p_qua_information4 in varchar2 default hr_api.g_varchar2
399 ,p_qua_information5 in varchar2 default hr_api.g_varchar2
400 ,p_qua_information6 in varchar2 default hr_api.g_varchar2
401 ,p_qua_information7 in varchar2 default hr_api.g_varchar2
402 ,p_qua_information8 in varchar2 default hr_api.g_varchar2
403 ,p_qua_information9 in varchar2 default hr_api.g_varchar2
404 ,p_qua_information10 in varchar2 default hr_api.g_varchar2
405 ,p_qua_information11 in varchar2 default hr_api.g_varchar2
406 ,p_qua_information12 in varchar2 default hr_api.g_varchar2
407 ,p_qua_information13 in varchar2 default hr_api.g_varchar2
408 ,p_qua_information14 in varchar2 default hr_api.g_varchar2
409 ,p_qua_information15 in varchar2 default hr_api.g_varchar2
410 ,p_qua_information16 in varchar2 default hr_api.g_varchar2
411 ,p_qua_information17 in varchar2 default hr_api.g_varchar2
412 ,p_qua_information18 in varchar2 default hr_api.g_varchar2
413 ,p_qua_information19 in varchar2 default hr_api.g_varchar2
414 ,p_qua_information20 in varchar2 default hr_api.g_varchar2
415 ,p_professional_body_name in varchar2 default hr_api.g_varchar2
416 ,p_membership_number in varchar2 default hr_api.g_varchar2
417 ,p_membership_category in varchar2 default hr_api.g_varchar2
418 ,p_subscription_payment_method in varchar2 default hr_api.g_varchar2
419 ,p_object_version_number in out nocopy number
420 );
421 --
422 -- ----------------------------------------------------------------------------
423 -- |---------------------------< delete_qualification >-----------------------|
424 -- ----------------------------------------------------------------------------
425 --
426 -- {Start Of Comments}
427 /*#
428 * This API deletes qualification.
429 *
430 * A qualification is a record of educational qualification, certificates,
431 * licenses, etc that a person holds or is acquiring.
432 *
433 * <p><b>Licensing</b><br>
434 * This API is licensed for use with iRecruitment and Human Resources.
435 *
436 * <p><b>Prerequisites</b><br>
437 * The qualification to be deleted must exist.
438 *
439 * <p><b>Post Success</b><br>
440 * The record will be deleted.
441 *
442 * <p><b>Post Failure</b><br>
443 * The record will not be deleted and an error is raised.
444 * @param p_validate If true, then validation alone will be performed and the
445 * database will remain unchanged. If false and all validation checks pass,
446 * then the database will be modified.
447 * @param p_qualification_id Identifies the qualification to be deleted.
448 * @param p_object_version_number Current version number of the qualification
449 * to be deleted.
450 * @rep:displayname Delete Qualification
451 * @rep:category BUSINESS_ENTITY PER_QUALIFICATION
452 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
453 * @rep:scope public
454 * @rep:lifecycle active
455 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
456 */
457 --
458 -- {End Of Comments}
459 --
460 procedure DELETE_QUALIFICATION
461 (p_validate in boolean default false
462 ,p_qualification_id in number
463 ,p_object_version_number in number
464 );
465
466
467 end PER_QUALIFICATIONS_API;