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_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

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

Line 105: hr_api.constant_to_boolean

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

Line 237: ,p_competence_type in varchar2 default hr_api.g_varchar2

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

Line 238: ,p_validate in number default hr_api.g_false_num

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

Line 266: hr_api.constant_to_boolean

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

Line 331: (p_validate in number default hr_api.g_false_num

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

Line 370: hr_api.constant_to_boolean

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

Line 453: ,p_validate in number default hr_api.g_false_num

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

Line 482: hr_api.constant_to_boolean

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

Line 565: if p_current_value = hr_api.g_date then

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;

Line 582: if p_current_value = hr_api.g_number then

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;

Line 599: if p_current_value = hr_api.g_varchar2 then

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;

Line 614: ,p_competence_id in number default hr_api.g_number

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

Line 615: ,p_proficiency_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

Line 616: ,p_high_proficiency_level_id in number default hr_api.g_number

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

Line 617: ,p_weighting_level_id in number default hr_api.g_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
621: ,p_effective_date_to in date default hr_api.g_date

Line 618: ,p_rating_level_id in number default hr_api.g_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
622: ,p_group_competence_type in varchar2 default hr_api.g_varchar2

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

Line 620: ,p_effective_date_from in date default hr_api.g_date

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

Line 621: ,p_effective_date_to in date default hr_api.g_date

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

Line 622: ,p_group_competence_type 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

Line 623: ,p_competence_type in varchar2 default hr_api.g_varchar2

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

Line 624: ,p_normal_elapse_duration in number default hr_api.g_number

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

Line 625: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2

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

Line 626: ,p_sequence_number in number default hr_api.g_number

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

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

Line 628: ,p_line_score in number default hr_api.g_number

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

Line 629: ,p_certification_date in date default hr_api.g_date

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

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

Line 631: ,p_next_certification_date in date default hr_api.g_date

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 651: ,p_attribute18 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
655: ,p_validate in number default hr_api.g_false_num

Line 652: ,p_attribute19 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
656: ,p_party_id in number

Line 653: ,p_attribute20 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
657: ,p_return_status out nocopy varchar2

Line 655: ,p_validate in number default hr_api.g_false_num

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

Line 658: ,p_datetrack_update_mode in varchar2 default hr_api.g_correction

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

Line 659: ,p_appr_line_score in number default hr_api.g_number

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

Line 697: hr_api.constant_to_boolean

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

Line 707: if p_competence_id<>hr_api.g_number

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.

Line 787: if (nvl(p_datetrack_update_mode, '#') <> hr_api.g_update) then

783: ,p_appr_line_score => get_non_gmisc_value( per_cel_shd.g_old_rec.appr_line_score, p_appr_line_score)
784: ,p_status => get_non_gmisc_value( per_cel_shd.g_old_rec.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:

Line 840: elsif (p_datetrack_update_mode = hr_api.g_update) then

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.

Line 943: raise hr_api.validate_enabled;

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

Line 961: when hr_api.validate_enabled then

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

Line 1002: ,p_validate in number default hr_api.g_false_num

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

Line 1030: hr_api.constant_to_boolean

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

Line 1099: ,p_proficiency_level_id in number default hr_api.g_number

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

Line 1100: ,p_effective_date_from 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

Line 1101: ,p_effective_date_to in date default hr_api.g_date

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

Line 1102: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2

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

Line 1103: ,p_certification_date in date default hr_api.g_date

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

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

Line 1105: ,p_next_certification_date 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
1109: ,p_attribute2 in varchar2 default hr_api.g_varchar2

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

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

Line 1108: ,p_attribute1 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

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

Line 1110: ,p_attribute3 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1125: ,p_attribute18 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
1129: ,p_validate in number default hr_api.g_false_num

Line 1126: ,p_attribute19 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
1130: ,p_ins_ovn out nocopy number

Line 1127: ,p_attribute20 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
1131: ,p_ins_comp_id out nocopy number

Line 1129: ,p_validate in number default hr_api.g_false_num

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

Line 1161: hr_api.constant_to_boolean

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

Line 1267: ,p_validate in number default hr_api.g_false_num

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

Line 1434: ,p_datetrack_update_mode => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DatetrackUpdate',hr_api.g_correction)

1430: ,p_validate => p_validate
1431: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId')
1432: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
1433: ,p_return_status => l_return_status
1434: ,p_datetrack_update_mode => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DatetrackUpdate',hr_api.g_correction)
1435: );
1436:
1437: elsif l_postState = '3' then
1438: