eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_COMPETENCE_ELEMENT_API dependencies on HR_API

Line 395: p_proficiency_level_id in number default hr_api.g_number,

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,

Line 396: p_high_proficiency_level_id in number default hr_api.g_number,

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,

Line 397: p_weighting_level_id in number default hr_api.g_number,

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,

Line 398: p_rating_level_id in number default hr_api.g_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,

Line 399: p_mandatory in varchar2 default hr_api.g_varchar2,

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,

Line 400: p_effective_date_from in date default hr_api.g_date,

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,

Line 401: p_effective_date_to in date default hr_api.g_date,

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,

Line 402: p_group_competence_type in varchar2 default hr_api.g_varchar2,

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,

Line 403: p_competence_type in varchar2 default hr_api.g_varchar2,

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,

Line 404: p_normal_elapse_duration in number default hr_api.g_number,

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,

Line 405: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,

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,

Line 406: p_sequence_number in number default hr_api.g_number,

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,

Line 407: p_source_of_proficiency_level 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,

Line 408: p_line_score in number default hr_api.g_number,

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,

Line 409: p_certification_date in date default hr_api.g_date,

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,

Line 410: p_certification_method 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,

Line 411: p_next_certification_date in date default hr_api.g_date,

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,

Line 412: p_comments 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,

Line 413: p_attribute_category in varchar2 default hr_api.g_varchar2,

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,

Line 414: p_attribute1 in varchar2 default hr_api.g_varchar2,

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,

Line 415: p_attribute2 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,

Line 416: p_attribute3 in varchar2 default hr_api.g_varchar2,

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,

Line 417: p_attribute4 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,

Line 418: p_attribute5 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,

Line 419: p_attribute6 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,

Line 420: p_attribute7 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,

Line 421: p_attribute8 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,

Line 422: p_attribute9 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,

Line 423: p_attribute10 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,

Line 424: p_attribute11 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,

Line 425: p_attribute12 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,

Line 426: p_attribute13 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,

Line 427: p_attribute14 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,

Line 428: p_attribute15 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,

Line 429: p_attribute16 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,

Line 430: p_attribute17 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,

Line 431: p_attribute18 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,

Line 432: p_attribute19 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

Line 433: p_attribute20 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

Line 437: ,p_qualification_type_id in number default hr_api.g_number

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

Line 438: ,p_unit_standard_type 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

Line 439: ,p_status in varchar2 default hr_api.g_varchar2

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

Line 440: ,p_information_category in varchar2 default hr_api.g_varchar2

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

Line 441: ,p_information1 in varchar2 default hr_api.g_varchar2

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

Line 442: ,p_information2 in varchar2 default hr_api.g_varchar2

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

Line 443: ,p_information3 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

Line 444: ,p_information4 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

Line 445: ,p_information5 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

Line 446: ,p_information6 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

Line 447: ,p_information7 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

Line 448: ,p_information8 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

Line 449: ,p_information9 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

Line 450: ,p_information10 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

Line 451: ,p_information11 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

Line 452: ,p_information12 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

Line 453: ,p_information13 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

Line 454: ,p_information14 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

Line 455: ,p_information15 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

Line 456: ,p_information16 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

Line 457: ,p_information17 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

Line 458: ,p_information18 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

Line 459: ,p_information19 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: );

Line 460: ,p_information20 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: --

Line 461: ,p_achieved_date in date default hr_api.g_date

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: -- ----------------------------------------------------------------------------

Line 462: ,p_appr_line_score in number default hr_api.g_number

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 >---------------------|

Line 478: p_proficiency_level_id in number default hr_api.g_number,

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,

Line 479: p_high_proficiency_level_id in number default hr_api.g_number,

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,

Line 480: p_weighting_level_id in number default hr_api.g_number,

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,

Line 481: p_rating_level_id in number default hr_api.g_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,

Line 482: p_mandatory in varchar2 default hr_api.g_varchar2,

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,

Line 483: p_effective_date_from in date default hr_api.g_date,

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,

Line 484: p_effective_date_to in date default hr_api.g_date,

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,

Line 485: p_group_competence_type in varchar2 default hr_api.g_varchar2,

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,

Line 486: p_competence_type in varchar2 default hr_api.g_varchar2,

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,

Line 487: p_normal_elapse_duration in number default hr_api.g_number,

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,

Line 488: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,

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,

Line 489: p_sequence_number in number default hr_api.g_number,

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,

Line 490: p_source_of_proficiency_level 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,

Line 491: p_line_score in number default hr_api.g_number,

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,

Line 492: p_certification_date in date default hr_api.g_date,

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,

Line 493: p_certification_method 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,

Line 494: p_next_certification_date in date default hr_api.g_date,

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,

Line 495: p_comments 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,

Line 496: p_attribute_category in varchar2 default hr_api.g_varchar2,

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,

Line 497: p_attribute1 in varchar2 default hr_api.g_varchar2,

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,

Line 498: p_attribute2 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,

Line 499: p_attribute3 in varchar2 default hr_api.g_varchar2,

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,

Line 500: p_attribute4 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,

Line 501: p_attribute5 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,

Line 502: p_attribute6 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,

Line 503: p_attribute7 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,

Line 504: p_attribute8 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,

Line 505: p_attribute9 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,

Line 506: p_attribute10 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,

Line 507: p_attribute11 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,

Line 508: p_attribute12 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,

Line 509: p_attribute13 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,

Line 510: p_attribute14 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,

Line 511: p_attribute15 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,

Line 512: p_attribute16 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,

Line 513: p_attribute17 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,

Line 514: p_attribute18 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

Line 515: p_attribute19 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: );

Line 516: p_attribute20 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: --

Line 613: p_proficiency_level_id in number default hr_api.g_number,

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,

Line 614: p_effective_date_from in date default hr_api.g_date,

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,

Line 615: p_effective_date_to in date default hr_api.g_date,

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,

Line 616: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,

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,

Line 617: p_certification_date in date default hr_api.g_date,

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,

Line 618: p_certification_method in varchar2 default hr_api.g_varchar2,

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,

Line 619: p_next_certification_date 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,

Line 620: p_comments in varchar2 default hr_api.g_varchar2,

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,

Line 621: p_attribute_category 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,

Line 622: p_attribute1 in varchar2 default hr_api.g_varchar2,

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,

Line 623: p_attribute2 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,

Line 624: p_attribute3 in varchar2 default hr_api.g_varchar2,

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,

Line 625: p_attribute4 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,

Line 626: p_attribute5 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,

Line 627: p_attribute6 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,

Line 628: p_attribute7 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,

Line 629: p_attribute8 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,

Line 630: p_attribute9 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,

Line 631: p_attribute10 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,

Line 632: p_attribute11 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,

Line 633: p_attribute12 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,

Line 634: p_attribute13 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,

Line 635: p_attribute14 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,

Line 636: p_attribute15 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,

Line 637: p_attribute16 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,

Line 638: p_attribute17 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,

Line 639: p_attribute18 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 ,

Line 640: p_attribute19 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,

Line 641: p_attribute20 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