8: -- ----------------------------------------------------------------------------
9: -- |-----------------------< create_competence_element >----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_competence_element
12: (p_validate in number default hr_api.g_false_num
13: ,p_competence_element_id in number
14: ,p_object_version_number out nocopy number
15: ,p_type in varchar2
16: ,p_business_group_id in number default null
101: --
102: -- Convert constant values to their corresponding boolean value
103: --
104: l_validate :=
105: hr_api.constant_to_boolean
106: (p_constant_value => p_validate);
107: --
108: -- Register Surrogate ID or user key values
109: --
233: -- ----------------------------------------------------------------------------
234: PROCEDURE copy_competencies
235: (p_activity_version_from in number
236: ,p_activity_version_to in number
237: ,p_competence_type in varchar2 default hr_api.g_varchar2
238: ,p_validate in number default hr_api.g_false_num
239: ,p_return_status out nocopy varchar2
240: ) is
241: --
234: PROCEDURE copy_competencies
235: (p_activity_version_from in number
236: ,p_activity_version_to in number
237: ,p_competence_type in varchar2 default hr_api.g_varchar2
238: ,p_validate in number default hr_api.g_false_num
239: ,p_return_status out nocopy varchar2
240: ) is
241: --
242: -- Variables for API Boolean parameters
262: --
263: -- Convert constant values to their corresponding boolean value
264: --
265: l_validate :=
266: hr_api.constant_to_boolean
267: (p_constant_value => p_validate);
268: --
269: -- Register Surrogate ID or user key values
270: --
327: -- ----------------------------------------------------------------------------
328: -- |-----------------------< delete_competence_element >----------------------|
329: -- ----------------------------------------------------------------------------
330: PROCEDURE delete_competence_element
331: (p_validate in number default hr_api.g_false_num
332: ,p_competence_element_id in number
333: ,p_object_version_number in number
334: ,p_return_status out nocopy varchar2
335: ) is
366: --
367: -- Convert constant values to their corresponding boolean value
368: --
369: l_validate :=
370: hr_api.constant_to_boolean
371: (p_constant_value => p_validate);
372: --
373: -- Register Surrogate ID or user key values
374: --
449: ,p_next_certification_date in date
450: ,p_source_of_proficiency_level in varchar2
451: ,p_comments in varchar2
452: ,p_effective_date in date
453: ,p_validate in number default hr_api.g_false_num
454: ,p_competence_created out nocopy number
455: ,p_return_status out nocopy varchar2
456: ) is
457: --
478: --
479: -- Convert constant values to their corresponding boolean value
480: --
481: l_validate :=
482: hr_api.constant_to_boolean
483: (p_constant_value => p_validate);
484: --
485: -- Register Surrogate ID or user key values
486: --
561: (p_old_value in date
562: ,p_current_value in date
563: ) return date is
564: begin
565: if p_current_value = hr_api.g_date then
566: return p_old_value;
567: else
568: return p_current_value;
569: end if;
578: (p_old_value in number
579: ,p_current_value in number
580: ) return number is
581: begin
582: if p_current_value = hr_api.g_number then
583: return p_old_value;
584: else
585: return p_current_value;
586: end if;
595: (p_old_value in varchar2
596: ,p_current_value in varchar2
597: ) return varchar2 is
598: begin
599: if p_current_value = hr_api.g_varchar2 then
600: return p_old_value;
601: else
602: return p_current_value;
603: end if;
610: -- ----------------------------------------------------------------------------
611: PROCEDURE update_competence_element
612: (p_competence_element_id in number
613: ,p_object_version_number in out nocopy number
614: ,p_competence_id in number default hr_api.g_number
615: ,p_proficiency_level_id in number default hr_api.g_number
616: ,p_high_proficiency_level_id in number default hr_api.g_number
617: ,p_weighting_level_id in number default hr_api.g_number
618: ,p_rating_level_id in number default hr_api.g_number
611: PROCEDURE update_competence_element
612: (p_competence_element_id in number
613: ,p_object_version_number in out nocopy number
614: ,p_competence_id in number default hr_api.g_number
615: ,p_proficiency_level_id in number default hr_api.g_number
616: ,p_high_proficiency_level_id in number default hr_api.g_number
617: ,p_weighting_level_id in number default hr_api.g_number
618: ,p_rating_level_id in number default hr_api.g_number
619: ,p_mandatory in varchar2 default hr_api.g_varchar2
612: (p_competence_element_id in number
613: ,p_object_version_number in out nocopy number
614: ,p_competence_id in number default hr_api.g_number
615: ,p_proficiency_level_id in number default hr_api.g_number
616: ,p_high_proficiency_level_id in number default hr_api.g_number
617: ,p_weighting_level_id in number default hr_api.g_number
618: ,p_rating_level_id in number default hr_api.g_number
619: ,p_mandatory in varchar2 default hr_api.g_varchar2
620: ,p_effective_date_from in date default hr_api.g_date
613: ,p_object_version_number in out nocopy number
614: ,p_competence_id in number default hr_api.g_number
615: ,p_proficiency_level_id in number default hr_api.g_number
616: ,p_high_proficiency_level_id in number default hr_api.g_number
617: ,p_weighting_level_id in number default hr_api.g_number
618: ,p_rating_level_id in number default hr_api.g_number
619: ,p_mandatory in varchar2 default hr_api.g_varchar2
620: ,p_effective_date_from in date default hr_api.g_date
621: ,p_effective_date_to in date default hr_api.g_date
614: ,p_competence_id in number default hr_api.g_number
615: ,p_proficiency_level_id in number default hr_api.g_number
616: ,p_high_proficiency_level_id in number default hr_api.g_number
617: ,p_weighting_level_id in number default hr_api.g_number
618: ,p_rating_level_id in number default hr_api.g_number
619: ,p_mandatory in varchar2 default hr_api.g_varchar2
620: ,p_effective_date_from in date default hr_api.g_date
621: ,p_effective_date_to in date default hr_api.g_date
622: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
615: ,p_proficiency_level_id in number default hr_api.g_number
616: ,p_high_proficiency_level_id in number default hr_api.g_number
617: ,p_weighting_level_id in number default hr_api.g_number
618: ,p_rating_level_id in number default hr_api.g_number
619: ,p_mandatory in varchar2 default hr_api.g_varchar2
620: ,p_effective_date_from in date default hr_api.g_date
621: ,p_effective_date_to in date default hr_api.g_date
622: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
623: ,p_competence_type in varchar2 default hr_api.g_varchar2
616: ,p_high_proficiency_level_id in number default hr_api.g_number
617: ,p_weighting_level_id in number default hr_api.g_number
618: ,p_rating_level_id in number default hr_api.g_number
619: ,p_mandatory in varchar2 default hr_api.g_varchar2
620: ,p_effective_date_from in date default hr_api.g_date
621: ,p_effective_date_to in date default hr_api.g_date
622: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
623: ,p_competence_type in varchar2 default hr_api.g_varchar2
624: ,p_normal_elapse_duration in number default hr_api.g_number
617: ,p_weighting_level_id in number default hr_api.g_number
618: ,p_rating_level_id in number default hr_api.g_number
619: ,p_mandatory in varchar2 default hr_api.g_varchar2
620: ,p_effective_date_from in date default hr_api.g_date
621: ,p_effective_date_to in date default hr_api.g_date
622: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
623: ,p_competence_type in varchar2 default hr_api.g_varchar2
624: ,p_normal_elapse_duration in number default hr_api.g_number
625: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
618: ,p_rating_level_id in number default hr_api.g_number
619: ,p_mandatory in varchar2 default hr_api.g_varchar2
620: ,p_effective_date_from in date default hr_api.g_date
621: ,p_effective_date_to in date default hr_api.g_date
622: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
623: ,p_competence_type in varchar2 default hr_api.g_varchar2
624: ,p_normal_elapse_duration in number default hr_api.g_number
625: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
626: ,p_sequence_number in number default hr_api.g_number
619: ,p_mandatory in varchar2 default hr_api.g_varchar2
620: ,p_effective_date_from in date default hr_api.g_date
621: ,p_effective_date_to in date default hr_api.g_date
622: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
623: ,p_competence_type in varchar2 default hr_api.g_varchar2
624: ,p_normal_elapse_duration in number default hr_api.g_number
625: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
626: ,p_sequence_number in number default hr_api.g_number
627: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
620: ,p_effective_date_from in date default hr_api.g_date
621: ,p_effective_date_to in date default hr_api.g_date
622: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
623: ,p_competence_type in varchar2 default hr_api.g_varchar2
624: ,p_normal_elapse_duration in number default hr_api.g_number
625: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
626: ,p_sequence_number in number default hr_api.g_number
627: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
628: ,p_line_score in number default hr_api.g_number
621: ,p_effective_date_to in date default hr_api.g_date
622: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
623: ,p_competence_type in varchar2 default hr_api.g_varchar2
624: ,p_normal_elapse_duration in number default hr_api.g_number
625: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
626: ,p_sequence_number in number default hr_api.g_number
627: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
628: ,p_line_score in number default hr_api.g_number
629: ,p_certification_date in date default hr_api.g_date
622: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
623: ,p_competence_type in varchar2 default hr_api.g_varchar2
624: ,p_normal_elapse_duration in number default hr_api.g_number
625: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
626: ,p_sequence_number in number default hr_api.g_number
627: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
628: ,p_line_score in number default hr_api.g_number
629: ,p_certification_date in date default hr_api.g_date
630: ,p_certification_method in varchar2 default hr_api.g_varchar2
623: ,p_competence_type in varchar2 default hr_api.g_varchar2
624: ,p_normal_elapse_duration in number default hr_api.g_number
625: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
626: ,p_sequence_number in number default hr_api.g_number
627: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
628: ,p_line_score in number default hr_api.g_number
629: ,p_certification_date in date default hr_api.g_date
630: ,p_certification_method in varchar2 default hr_api.g_varchar2
631: ,p_next_certification_date in date default hr_api.g_date
624: ,p_normal_elapse_duration in number default hr_api.g_number
625: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
626: ,p_sequence_number in number default hr_api.g_number
627: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
628: ,p_line_score in number default hr_api.g_number
629: ,p_certification_date in date default hr_api.g_date
630: ,p_certification_method in varchar2 default hr_api.g_varchar2
631: ,p_next_certification_date in date default hr_api.g_date
632: ,p_comments in varchar2 default hr_api.g_varchar2
625: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
626: ,p_sequence_number in number default hr_api.g_number
627: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
628: ,p_line_score in number default hr_api.g_number
629: ,p_certification_date in date default hr_api.g_date
630: ,p_certification_method in varchar2 default hr_api.g_varchar2
631: ,p_next_certification_date in date default hr_api.g_date
632: ,p_comments in varchar2 default hr_api.g_varchar2
633: ,p_attribute_category in varchar2 default hr_api.g_varchar2
626: ,p_sequence_number in number default hr_api.g_number
627: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
628: ,p_line_score in number default hr_api.g_number
629: ,p_certification_date in date default hr_api.g_date
630: ,p_certification_method in varchar2 default hr_api.g_varchar2
631: ,p_next_certification_date in date default hr_api.g_date
632: ,p_comments in varchar2 default hr_api.g_varchar2
633: ,p_attribute_category in varchar2 default hr_api.g_varchar2
634: ,p_attribute1 in varchar2 default hr_api.g_varchar2
627: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
628: ,p_line_score in number default hr_api.g_number
629: ,p_certification_date in date default hr_api.g_date
630: ,p_certification_method in varchar2 default hr_api.g_varchar2
631: ,p_next_certification_date in date default hr_api.g_date
632: ,p_comments in varchar2 default hr_api.g_varchar2
633: ,p_attribute_category in varchar2 default hr_api.g_varchar2
634: ,p_attribute1 in varchar2 default hr_api.g_varchar2
635: ,p_attribute2 in varchar2 default hr_api.g_varchar2
628: ,p_line_score in number default hr_api.g_number
629: ,p_certification_date in date default hr_api.g_date
630: ,p_certification_method in varchar2 default hr_api.g_varchar2
631: ,p_next_certification_date in date default hr_api.g_date
632: ,p_comments in varchar2 default hr_api.g_varchar2
633: ,p_attribute_category in varchar2 default hr_api.g_varchar2
634: ,p_attribute1 in varchar2 default hr_api.g_varchar2
635: ,p_attribute2 in varchar2 default hr_api.g_varchar2
636: ,p_attribute3 in varchar2 default hr_api.g_varchar2
629: ,p_certification_date in date default hr_api.g_date
630: ,p_certification_method in varchar2 default hr_api.g_varchar2
631: ,p_next_certification_date in date default hr_api.g_date
632: ,p_comments in varchar2 default hr_api.g_varchar2
633: ,p_attribute_category in varchar2 default hr_api.g_varchar2
634: ,p_attribute1 in varchar2 default hr_api.g_varchar2
635: ,p_attribute2 in varchar2 default hr_api.g_varchar2
636: ,p_attribute3 in varchar2 default hr_api.g_varchar2
637: ,p_attribute4 in varchar2 default hr_api.g_varchar2
630: ,p_certification_method in varchar2 default hr_api.g_varchar2
631: ,p_next_certification_date in date default hr_api.g_date
632: ,p_comments in varchar2 default hr_api.g_varchar2
633: ,p_attribute_category in varchar2 default hr_api.g_varchar2
634: ,p_attribute1 in varchar2 default hr_api.g_varchar2
635: ,p_attribute2 in varchar2 default hr_api.g_varchar2
636: ,p_attribute3 in varchar2 default hr_api.g_varchar2
637: ,p_attribute4 in varchar2 default hr_api.g_varchar2
638: ,p_attribute5 in varchar2 default hr_api.g_varchar2
631: ,p_next_certification_date in date default hr_api.g_date
632: ,p_comments in varchar2 default hr_api.g_varchar2
633: ,p_attribute_category in varchar2 default hr_api.g_varchar2
634: ,p_attribute1 in varchar2 default hr_api.g_varchar2
635: ,p_attribute2 in varchar2 default hr_api.g_varchar2
636: ,p_attribute3 in varchar2 default hr_api.g_varchar2
637: ,p_attribute4 in varchar2 default hr_api.g_varchar2
638: ,p_attribute5 in varchar2 default hr_api.g_varchar2
639: ,p_attribute6 in varchar2 default hr_api.g_varchar2
632: ,p_comments in varchar2 default hr_api.g_varchar2
633: ,p_attribute_category in varchar2 default hr_api.g_varchar2
634: ,p_attribute1 in varchar2 default hr_api.g_varchar2
635: ,p_attribute2 in varchar2 default hr_api.g_varchar2
636: ,p_attribute3 in varchar2 default hr_api.g_varchar2
637: ,p_attribute4 in varchar2 default hr_api.g_varchar2
638: ,p_attribute5 in varchar2 default hr_api.g_varchar2
639: ,p_attribute6 in varchar2 default hr_api.g_varchar2
640: ,p_attribute7 in varchar2 default hr_api.g_varchar2
633: ,p_attribute_category in varchar2 default hr_api.g_varchar2
634: ,p_attribute1 in varchar2 default hr_api.g_varchar2
635: ,p_attribute2 in varchar2 default hr_api.g_varchar2
636: ,p_attribute3 in varchar2 default hr_api.g_varchar2
637: ,p_attribute4 in varchar2 default hr_api.g_varchar2
638: ,p_attribute5 in varchar2 default hr_api.g_varchar2
639: ,p_attribute6 in varchar2 default hr_api.g_varchar2
640: ,p_attribute7 in varchar2 default hr_api.g_varchar2
641: ,p_attribute8 in varchar2 default hr_api.g_varchar2
634: ,p_attribute1 in varchar2 default hr_api.g_varchar2
635: ,p_attribute2 in varchar2 default hr_api.g_varchar2
636: ,p_attribute3 in varchar2 default hr_api.g_varchar2
637: ,p_attribute4 in varchar2 default hr_api.g_varchar2
638: ,p_attribute5 in varchar2 default hr_api.g_varchar2
639: ,p_attribute6 in varchar2 default hr_api.g_varchar2
640: ,p_attribute7 in varchar2 default hr_api.g_varchar2
641: ,p_attribute8 in varchar2 default hr_api.g_varchar2
642: ,p_attribute9 in varchar2 default hr_api.g_varchar2
635: ,p_attribute2 in varchar2 default hr_api.g_varchar2
636: ,p_attribute3 in varchar2 default hr_api.g_varchar2
637: ,p_attribute4 in varchar2 default hr_api.g_varchar2
638: ,p_attribute5 in varchar2 default hr_api.g_varchar2
639: ,p_attribute6 in varchar2 default hr_api.g_varchar2
640: ,p_attribute7 in varchar2 default hr_api.g_varchar2
641: ,p_attribute8 in varchar2 default hr_api.g_varchar2
642: ,p_attribute9 in varchar2 default hr_api.g_varchar2
643: ,p_attribute10 in varchar2 default hr_api.g_varchar2
636: ,p_attribute3 in varchar2 default hr_api.g_varchar2
637: ,p_attribute4 in varchar2 default hr_api.g_varchar2
638: ,p_attribute5 in varchar2 default hr_api.g_varchar2
639: ,p_attribute6 in varchar2 default hr_api.g_varchar2
640: ,p_attribute7 in varchar2 default hr_api.g_varchar2
641: ,p_attribute8 in varchar2 default hr_api.g_varchar2
642: ,p_attribute9 in varchar2 default hr_api.g_varchar2
643: ,p_attribute10 in varchar2 default hr_api.g_varchar2
644: ,p_attribute11 in varchar2 default hr_api.g_varchar2
637: ,p_attribute4 in varchar2 default hr_api.g_varchar2
638: ,p_attribute5 in varchar2 default hr_api.g_varchar2
639: ,p_attribute6 in varchar2 default hr_api.g_varchar2
640: ,p_attribute7 in varchar2 default hr_api.g_varchar2
641: ,p_attribute8 in varchar2 default hr_api.g_varchar2
642: ,p_attribute9 in varchar2 default hr_api.g_varchar2
643: ,p_attribute10 in varchar2 default hr_api.g_varchar2
644: ,p_attribute11 in varchar2 default hr_api.g_varchar2
645: ,p_attribute12 in varchar2 default hr_api.g_varchar2
638: ,p_attribute5 in varchar2 default hr_api.g_varchar2
639: ,p_attribute6 in varchar2 default hr_api.g_varchar2
640: ,p_attribute7 in varchar2 default hr_api.g_varchar2
641: ,p_attribute8 in varchar2 default hr_api.g_varchar2
642: ,p_attribute9 in varchar2 default hr_api.g_varchar2
643: ,p_attribute10 in varchar2 default hr_api.g_varchar2
644: ,p_attribute11 in varchar2 default hr_api.g_varchar2
645: ,p_attribute12 in varchar2 default hr_api.g_varchar2
646: ,p_attribute13 in varchar2 default hr_api.g_varchar2
639: ,p_attribute6 in varchar2 default hr_api.g_varchar2
640: ,p_attribute7 in varchar2 default hr_api.g_varchar2
641: ,p_attribute8 in varchar2 default hr_api.g_varchar2
642: ,p_attribute9 in varchar2 default hr_api.g_varchar2
643: ,p_attribute10 in varchar2 default hr_api.g_varchar2
644: ,p_attribute11 in varchar2 default hr_api.g_varchar2
645: ,p_attribute12 in varchar2 default hr_api.g_varchar2
646: ,p_attribute13 in varchar2 default hr_api.g_varchar2
647: ,p_attribute14 in varchar2 default hr_api.g_varchar2
640: ,p_attribute7 in varchar2 default hr_api.g_varchar2
641: ,p_attribute8 in varchar2 default hr_api.g_varchar2
642: ,p_attribute9 in varchar2 default hr_api.g_varchar2
643: ,p_attribute10 in varchar2 default hr_api.g_varchar2
644: ,p_attribute11 in varchar2 default hr_api.g_varchar2
645: ,p_attribute12 in varchar2 default hr_api.g_varchar2
646: ,p_attribute13 in varchar2 default hr_api.g_varchar2
647: ,p_attribute14 in varchar2 default hr_api.g_varchar2
648: ,p_attribute15 in varchar2 default hr_api.g_varchar2
641: ,p_attribute8 in varchar2 default hr_api.g_varchar2
642: ,p_attribute9 in varchar2 default hr_api.g_varchar2
643: ,p_attribute10 in varchar2 default hr_api.g_varchar2
644: ,p_attribute11 in varchar2 default hr_api.g_varchar2
645: ,p_attribute12 in varchar2 default hr_api.g_varchar2
646: ,p_attribute13 in varchar2 default hr_api.g_varchar2
647: ,p_attribute14 in varchar2 default hr_api.g_varchar2
648: ,p_attribute15 in varchar2 default hr_api.g_varchar2
649: ,p_attribute16 in varchar2 default hr_api.g_varchar2
642: ,p_attribute9 in varchar2 default hr_api.g_varchar2
643: ,p_attribute10 in varchar2 default hr_api.g_varchar2
644: ,p_attribute11 in varchar2 default hr_api.g_varchar2
645: ,p_attribute12 in varchar2 default hr_api.g_varchar2
646: ,p_attribute13 in varchar2 default hr_api.g_varchar2
647: ,p_attribute14 in varchar2 default hr_api.g_varchar2
648: ,p_attribute15 in varchar2 default hr_api.g_varchar2
649: ,p_attribute16 in varchar2 default hr_api.g_varchar2
650: ,p_attribute17 in varchar2 default hr_api.g_varchar2
643: ,p_attribute10 in varchar2 default hr_api.g_varchar2
644: ,p_attribute11 in varchar2 default hr_api.g_varchar2
645: ,p_attribute12 in varchar2 default hr_api.g_varchar2
646: ,p_attribute13 in varchar2 default hr_api.g_varchar2
647: ,p_attribute14 in varchar2 default hr_api.g_varchar2
648: ,p_attribute15 in varchar2 default hr_api.g_varchar2
649: ,p_attribute16 in varchar2 default hr_api.g_varchar2
650: ,p_attribute17 in varchar2 default hr_api.g_varchar2
651: ,p_attribute18 in varchar2 default hr_api.g_varchar2
644: ,p_attribute11 in varchar2 default hr_api.g_varchar2
645: ,p_attribute12 in varchar2 default hr_api.g_varchar2
646: ,p_attribute13 in varchar2 default hr_api.g_varchar2
647: ,p_attribute14 in varchar2 default hr_api.g_varchar2
648: ,p_attribute15 in varchar2 default hr_api.g_varchar2
649: ,p_attribute16 in varchar2 default hr_api.g_varchar2
650: ,p_attribute17 in varchar2 default hr_api.g_varchar2
651: ,p_attribute18 in varchar2 default hr_api.g_varchar2
652: ,p_attribute19 in varchar2 default hr_api.g_varchar2
645: ,p_attribute12 in varchar2 default hr_api.g_varchar2
646: ,p_attribute13 in varchar2 default hr_api.g_varchar2
647: ,p_attribute14 in varchar2 default hr_api.g_varchar2
648: ,p_attribute15 in varchar2 default hr_api.g_varchar2
649: ,p_attribute16 in varchar2 default hr_api.g_varchar2
650: ,p_attribute17 in varchar2 default hr_api.g_varchar2
651: ,p_attribute18 in varchar2 default hr_api.g_varchar2
652: ,p_attribute19 in varchar2 default hr_api.g_varchar2
653: ,p_attribute20 in varchar2 default hr_api.g_varchar2
646: ,p_attribute13 in varchar2 default hr_api.g_varchar2
647: ,p_attribute14 in varchar2 default hr_api.g_varchar2
648: ,p_attribute15 in varchar2 default hr_api.g_varchar2
649: ,p_attribute16 in varchar2 default hr_api.g_varchar2
650: ,p_attribute17 in varchar2 default hr_api.g_varchar2
651: ,p_attribute18 in varchar2 default hr_api.g_varchar2
652: ,p_attribute19 in varchar2 default hr_api.g_varchar2
653: ,p_attribute20 in varchar2 default hr_api.g_varchar2
654: ,p_effective_date in date
647: ,p_attribute14 in varchar2 default hr_api.g_varchar2
648: ,p_attribute15 in varchar2 default hr_api.g_varchar2
649: ,p_attribute16 in varchar2 default hr_api.g_varchar2
650: ,p_attribute17 in varchar2 default hr_api.g_varchar2
651: ,p_attribute18 in varchar2 default hr_api.g_varchar2
652: ,p_attribute19 in varchar2 default hr_api.g_varchar2
653: ,p_attribute20 in varchar2 default hr_api.g_varchar2
654: ,p_effective_date in date
655: ,p_validate in number default hr_api.g_false_num
648: ,p_attribute15 in varchar2 default hr_api.g_varchar2
649: ,p_attribute16 in varchar2 default hr_api.g_varchar2
650: ,p_attribute17 in varchar2 default hr_api.g_varchar2
651: ,p_attribute18 in varchar2 default hr_api.g_varchar2
652: ,p_attribute19 in varchar2 default hr_api.g_varchar2
653: ,p_attribute20 in varchar2 default hr_api.g_varchar2
654: ,p_effective_date in date
655: ,p_validate in number default hr_api.g_false_num
656: ,p_party_id in number
649: ,p_attribute16 in varchar2 default hr_api.g_varchar2
650: ,p_attribute17 in varchar2 default hr_api.g_varchar2
651: ,p_attribute18 in varchar2 default hr_api.g_varchar2
652: ,p_attribute19 in varchar2 default hr_api.g_varchar2
653: ,p_attribute20 in varchar2 default hr_api.g_varchar2
654: ,p_effective_date in date
655: ,p_validate in number default hr_api.g_false_num
656: ,p_party_id in number
657: ,p_return_status out nocopy varchar2
651: ,p_attribute18 in varchar2 default hr_api.g_varchar2
652: ,p_attribute19 in varchar2 default hr_api.g_varchar2
653: ,p_attribute20 in varchar2 default hr_api.g_varchar2
654: ,p_effective_date in date
655: ,p_validate in number default hr_api.g_false_num
656: ,p_party_id in number
657: ,p_return_status out nocopy varchar2
658: ,p_datetrack_update_mode in varchar2 default hr_api.g_correction
659: ,p_appr_line_score in number default hr_api.g_number
654: ,p_effective_date in date
655: ,p_validate in number default hr_api.g_false_num
656: ,p_party_id in number
657: ,p_return_status out nocopy varchar2
658: ,p_datetrack_update_mode in varchar2 default hr_api.g_correction
659: ,p_appr_line_score in number default hr_api.g_number
660: ,p_status in varchar2 default null
661: ) is
662: --
655: ,p_validate in number default hr_api.g_false_num
656: ,p_party_id in number
657: ,p_return_status out nocopy varchar2
658: ,p_datetrack_update_mode in varchar2 default hr_api.g_correction
659: ,p_appr_line_score in number default hr_api.g_number
660: ,p_status in varchar2 default null
661: ) is
662: --
663: -- Variables for API Boolean parameters
693: --
694: -- Convert constant values to their corresponding boolean value
695: --
696: l_validate :=
697: hr_api.constant_to_boolean
698: (p_constant_value => p_validate);
699: --
700: -- look to see if the competence_id has been changed
701: --
703: (p_competence_element_id => p_competence_element_id
704: ,p_object_version_number => p_object_version_number
705: );
706: --
707: if p_competence_id<>hr_api.g_number
708: and per_cel_shd.g_old_rec.competence_id<>p_competence_id then
709: --
710: -- the competence has been updated, so delete the old competence element
711: -- and insert a new one.
783: ,p_appr_line_score => p_appr_line_score
784: ,p_status => p_status
785: );
786: else
787: if (nvl(p_datetrack_update_mode, '#') <> hr_api.g_update) then
788:
789: -- the competence has not been changed,
790: -- so correct the existing row since datetrackmode is correct
791:
836: ,p_party_id => p_party_id
837: ,p_appr_line_score => p_appr_line_score
838: ,p_status => p_status
839: );
840: elsif (p_datetrack_update_mode = hr_api.g_update) then
841:
842: -- the competence has not been changed,
843: -- so update the existing row since datetrackmode is update
844: -- Update implies Maintain history by end-dating the previous row and inserting a new Row.
939: --
940: -- When in validation only mode raise the Validate_Enabled exception
941: --
942: if l_validate then
943: raise hr_api.validate_enabled;
944: end if;
945: hr_utility.set_location(' Leaving:' || l_proc,20);
946: --
947: exception
957: --
958: p_object_version_number := l_object_version_number;
959: p_return_status := hr_multi_message.get_return_status_disable;
960: hr_utility.set_location(' Leaving:' || l_proc, 30);
961: when hr_api.validate_enabled then
962: --
963: -- As the Validate_Enabled exception has been raised
964: -- we must rollback to the savepoint
965: --
998: ,p_old_start_date in date
999: ,p_start_date in date
1000: ,p_old_end_date in date
1001: ,p_end_date in date
1002: ,p_validate in number default hr_api.g_false_num
1003: ,p_return_status out nocopy varchar2
1004: ) is
1005: --
1006: -- Variables for API Boolean parameters
1026: --
1027: -- Convert constant values to their corresponding boolean value
1028: --
1029: l_validate :=
1030: hr_api.constant_to_boolean
1031: (p_constant_value => p_validate);
1032: --
1033: -- Register Surrogate ID or user key values
1034: --
1095: -- ----------------------------------------------------------------------------
1096: PROCEDURE update_personal_comp_element
1097: (p_competence_element_id in number
1098: ,p_object_version_number in out nocopy number
1099: ,p_proficiency_level_id in number default hr_api.g_number
1100: ,p_effective_date_from in date default hr_api.g_date
1101: ,p_effective_date_to in date default hr_api.g_date
1102: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
1103: ,p_certification_date in date default hr_api.g_date
1096: PROCEDURE update_personal_comp_element
1097: (p_competence_element_id in number
1098: ,p_object_version_number in out nocopy number
1099: ,p_proficiency_level_id in number default hr_api.g_number
1100: ,p_effective_date_from in date default hr_api.g_date
1101: ,p_effective_date_to in date default hr_api.g_date
1102: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
1103: ,p_certification_date in date default hr_api.g_date
1104: ,p_certification_method in varchar2 default hr_api.g_varchar2
1097: (p_competence_element_id in number
1098: ,p_object_version_number in out nocopy number
1099: ,p_proficiency_level_id in number default hr_api.g_number
1100: ,p_effective_date_from in date default hr_api.g_date
1101: ,p_effective_date_to in date default hr_api.g_date
1102: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
1103: ,p_certification_date in date default hr_api.g_date
1104: ,p_certification_method in varchar2 default hr_api.g_varchar2
1105: ,p_next_certification_date in date default hr_api.g_date
1098: ,p_object_version_number in out nocopy number
1099: ,p_proficiency_level_id in number default hr_api.g_number
1100: ,p_effective_date_from in date default hr_api.g_date
1101: ,p_effective_date_to in date default hr_api.g_date
1102: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
1103: ,p_certification_date in date default hr_api.g_date
1104: ,p_certification_method in varchar2 default hr_api.g_varchar2
1105: ,p_next_certification_date in date default hr_api.g_date
1106: ,p_comments in varchar2 default hr_api.g_varchar2
1099: ,p_proficiency_level_id in number default hr_api.g_number
1100: ,p_effective_date_from in date default hr_api.g_date
1101: ,p_effective_date_to in date default hr_api.g_date
1102: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
1103: ,p_certification_date in date default hr_api.g_date
1104: ,p_certification_method in varchar2 default hr_api.g_varchar2
1105: ,p_next_certification_date in date default hr_api.g_date
1106: ,p_comments in varchar2 default hr_api.g_varchar2
1107: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1100: ,p_effective_date_from in date default hr_api.g_date
1101: ,p_effective_date_to in date default hr_api.g_date
1102: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
1103: ,p_certification_date in date default hr_api.g_date
1104: ,p_certification_method in varchar2 default hr_api.g_varchar2
1105: ,p_next_certification_date in date default hr_api.g_date
1106: ,p_comments in varchar2 default hr_api.g_varchar2
1107: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1108: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1101: ,p_effective_date_to in date default hr_api.g_date
1102: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
1103: ,p_certification_date in date default hr_api.g_date
1104: ,p_certification_method in varchar2 default hr_api.g_varchar2
1105: ,p_next_certification_date in date default hr_api.g_date
1106: ,p_comments in varchar2 default hr_api.g_varchar2
1107: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1108: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1109: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1102: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
1103: ,p_certification_date in date default hr_api.g_date
1104: ,p_certification_method in varchar2 default hr_api.g_varchar2
1105: ,p_next_certification_date in date default hr_api.g_date
1106: ,p_comments in varchar2 default hr_api.g_varchar2
1107: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1108: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1109: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1110: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1103: ,p_certification_date in date default hr_api.g_date
1104: ,p_certification_method in varchar2 default hr_api.g_varchar2
1105: ,p_next_certification_date in date default hr_api.g_date
1106: ,p_comments in varchar2 default hr_api.g_varchar2
1107: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1108: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1109: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1110: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1111: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1104: ,p_certification_method in varchar2 default hr_api.g_varchar2
1105: ,p_next_certification_date in date default hr_api.g_date
1106: ,p_comments in varchar2 default hr_api.g_varchar2
1107: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1108: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1109: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1110: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1111: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1112: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1105: ,p_next_certification_date in date default hr_api.g_date
1106: ,p_comments in varchar2 default hr_api.g_varchar2
1107: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1108: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1109: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1110: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1111: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1112: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1113: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1106: ,p_comments in varchar2 default hr_api.g_varchar2
1107: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1108: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1109: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1110: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1111: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1112: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1113: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1114: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1107: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1108: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1109: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1110: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1111: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1112: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1113: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1114: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1115: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1108: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1109: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1110: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1111: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1112: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1113: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1114: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1115: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1116: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1109: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1110: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1111: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1112: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1113: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1114: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1115: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1116: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1117: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1110: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1111: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1112: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1113: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1114: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1115: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1116: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1117: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1118: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1111: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1112: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1113: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1114: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1115: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1116: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1117: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1118: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1119: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1112: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1113: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1114: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1115: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1116: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1117: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1118: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1119: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1120: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1113: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1114: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1115: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1116: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1117: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1118: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1119: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1120: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1121: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1114: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1115: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1116: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1117: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1118: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1119: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1120: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1121: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1122: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1115: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1116: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1117: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1118: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1119: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1120: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1121: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1122: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1123: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1116: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1117: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1118: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1119: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1120: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1121: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1122: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1123: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1124: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1117: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1118: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1119: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1120: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1121: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1122: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1123: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1124: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1125: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1118: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1119: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1120: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1121: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1122: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1123: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1124: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1125: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1126: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1119: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1120: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1121: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1122: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1123: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1124: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1125: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1126: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1127: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1120: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1121: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1122: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1123: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1124: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1125: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1126: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1127: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1128: ,p_effective_date in date
1121: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1122: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1123: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1124: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1125: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1126: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1127: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1128: ,p_effective_date in date
1129: ,p_validate in number default hr_api.g_false_num
1122: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1123: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1124: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1125: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1126: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1127: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1128: ,p_effective_date in date
1129: ,p_validate in number default hr_api.g_false_num
1130: ,p_ins_ovn out nocopy number
1123: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1124: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1125: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1126: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1127: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1128: ,p_effective_date in date
1129: ,p_validate in number default hr_api.g_false_num
1130: ,p_ins_ovn out nocopy number
1131: ,p_ins_comp_id out nocopy number
1125: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1126: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1127: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1128: ,p_effective_date in date
1129: ,p_validate in number default hr_api.g_false_num
1130: ,p_ins_ovn out nocopy number
1131: ,p_ins_comp_id out nocopy number
1132: ,p_return_status out nocopy varchar2
1133: ) is
1157: --
1158: -- Convert constant values to their corresponding boolean value
1159: --
1160: l_validate :=
1161: hr_api.constant_to_boolean
1162: (p_constant_value => p_validate);
1163: --
1164: -- Register Surrogate ID or user key values
1165: --
1263:
1264: Procedure process_api
1265: ( p_document in CLOB
1266: ,p_return_status out nocopy VARCHAR2
1267: ,p_validate in number default hr_api.g_false_num
1268: ,p_effective_date in date default null
1269: )
1270: IS
1271: l_postState VARCHAR2(2);
1418: ,p_validate => p_validate
1419: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId')
1420: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
1421: ,p_return_status => l_return_status
1422: ,p_datetrack_update_mode => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DatetrackUpdate',hr_api.g_correction)
1423: );
1424:
1425: elsif l_postState = '3' then
1426: