[Home] [Help]
549: --
550: -- When in validation only mode raise the Validate_Enabled exception
551: --
552: if p_validate then
553: raise hr_api.validate_enabled;
554: end if;
555: --
556: -- Set remaining output arguments
557: --
563: if g_debug then
564: hr_utility.set_location(' Leaving:'||l_proc, 30);
565: end if;
566: exception
567: when hr_api.validate_enabled then
568: reset_hr_installation;
569: --
570: -- As the Validate_Enabled exception has been raised
571: -- we must rollback to the savepoint
714: procedure update_position
715: (p_validate in boolean default false
716: ,p_position_id in number
717: ,p_object_version_number in out nocopy number
718: ,p_language_code in varchar2 default hr_api.userenv_lang
719: ,p_successor_position_id in number default hr_api.g_number
720: ,p_relief_position_id in number default hr_api.g_number
721: ,p_location_id in number default hr_api.g_number
722: ,p_date_effective in date default hr_api.g_date
715: (p_validate in boolean default false
716: ,p_position_id in number
717: ,p_object_version_number in out nocopy number
718: ,p_language_code in varchar2 default hr_api.userenv_lang
719: ,p_successor_position_id in number default hr_api.g_number
720: ,p_relief_position_id in number default hr_api.g_number
721: ,p_location_id in number default hr_api.g_number
722: ,p_date_effective in date default hr_api.g_date
723: ,p_comments in varchar2 default hr_api.g_varchar2
716: ,p_position_id in number
717: ,p_object_version_number in out nocopy number
718: ,p_language_code in varchar2 default hr_api.userenv_lang
719: ,p_successor_position_id in number default hr_api.g_number
720: ,p_relief_position_id in number default hr_api.g_number
721: ,p_location_id in number default hr_api.g_number
722: ,p_date_effective in date default hr_api.g_date
723: ,p_comments in varchar2 default hr_api.g_varchar2
724: ,p_date_end in date default hr_api.g_date
717: ,p_object_version_number in out nocopy number
718: ,p_language_code in varchar2 default hr_api.userenv_lang
719: ,p_successor_position_id in number default hr_api.g_number
720: ,p_relief_position_id in number default hr_api.g_number
721: ,p_location_id in number default hr_api.g_number
722: ,p_date_effective in date default hr_api.g_date
723: ,p_comments in varchar2 default hr_api.g_varchar2
724: ,p_date_end in date default hr_api.g_date
725: ,p_frequency in varchar2 default hr_api.g_varchar2
718: ,p_language_code in varchar2 default hr_api.userenv_lang
719: ,p_successor_position_id in number default hr_api.g_number
720: ,p_relief_position_id in number default hr_api.g_number
721: ,p_location_id in number default hr_api.g_number
722: ,p_date_effective in date default hr_api.g_date
723: ,p_comments in varchar2 default hr_api.g_varchar2
724: ,p_date_end in date default hr_api.g_date
725: ,p_frequency in varchar2 default hr_api.g_varchar2
726: ,p_probation_period in number default hr_api.g_number
719: ,p_successor_position_id in number default hr_api.g_number
720: ,p_relief_position_id in number default hr_api.g_number
721: ,p_location_id in number default hr_api.g_number
722: ,p_date_effective in date default hr_api.g_date
723: ,p_comments in varchar2 default hr_api.g_varchar2
724: ,p_date_end in date default hr_api.g_date
725: ,p_frequency in varchar2 default hr_api.g_varchar2
726: ,p_probation_period in number default hr_api.g_number
727: ,p_probation_period_units in varchar2 default hr_api.g_varchar2
720: ,p_relief_position_id in number default hr_api.g_number
721: ,p_location_id in number default hr_api.g_number
722: ,p_date_effective in date default hr_api.g_date
723: ,p_comments in varchar2 default hr_api.g_varchar2
724: ,p_date_end in date default hr_api.g_date
725: ,p_frequency in varchar2 default hr_api.g_varchar2
726: ,p_probation_period in number default hr_api.g_number
727: ,p_probation_period_units in varchar2 default hr_api.g_varchar2
728: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
721: ,p_location_id in number default hr_api.g_number
722: ,p_date_effective in date default hr_api.g_date
723: ,p_comments in varchar2 default hr_api.g_varchar2
724: ,p_date_end in date default hr_api.g_date
725: ,p_frequency in varchar2 default hr_api.g_varchar2
726: ,p_probation_period in number default hr_api.g_number
727: ,p_probation_period_units in varchar2 default hr_api.g_varchar2
728: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
729: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
722: ,p_date_effective in date default hr_api.g_date
723: ,p_comments in varchar2 default hr_api.g_varchar2
724: ,p_date_end in date default hr_api.g_date
725: ,p_frequency in varchar2 default hr_api.g_varchar2
726: ,p_probation_period in number default hr_api.g_number
727: ,p_probation_period_units in varchar2 default hr_api.g_varchar2
728: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
729: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
730: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
723: ,p_comments in varchar2 default hr_api.g_varchar2
724: ,p_date_end in date default hr_api.g_date
725: ,p_frequency in varchar2 default hr_api.g_varchar2
726: ,p_probation_period in number default hr_api.g_number
727: ,p_probation_period_units in varchar2 default hr_api.g_varchar2
728: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
729: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
730: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
731: ,p_status in varchar2 default hr_api.g_varchar2
724: ,p_date_end in date default hr_api.g_date
725: ,p_frequency in varchar2 default hr_api.g_varchar2
726: ,p_probation_period in number default hr_api.g_number
727: ,p_probation_period_units in varchar2 default hr_api.g_varchar2
728: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
729: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
730: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
731: ,p_status in varchar2 default hr_api.g_varchar2
732: ,p_working_hours in number default hr_api.g_number
725: ,p_frequency in varchar2 default hr_api.g_varchar2
726: ,p_probation_period in number default hr_api.g_number
727: ,p_probation_period_units in varchar2 default hr_api.g_varchar2
728: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
729: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
730: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
731: ,p_status in varchar2 default hr_api.g_varchar2
732: ,p_working_hours in number default hr_api.g_number
733: ,p_attribute_category in varchar2 default hr_api.g_varchar2
726: ,p_probation_period in number default hr_api.g_number
727: ,p_probation_period_units in varchar2 default hr_api.g_varchar2
728: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
729: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
730: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
731: ,p_status in varchar2 default hr_api.g_varchar2
732: ,p_working_hours in number default hr_api.g_number
733: ,p_attribute_category in varchar2 default hr_api.g_varchar2
734: ,p_attribute1 in varchar2 default hr_api.g_varchar2
727: ,p_probation_period_units in varchar2 default hr_api.g_varchar2
728: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
729: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
730: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
731: ,p_status in varchar2 default hr_api.g_varchar2
732: ,p_working_hours in number default hr_api.g_number
733: ,p_attribute_category in varchar2 default hr_api.g_varchar2
734: ,p_attribute1 in varchar2 default hr_api.g_varchar2
735: ,p_attribute2 in varchar2 default hr_api.g_varchar2
728: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
729: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
730: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
731: ,p_status in varchar2 default hr_api.g_varchar2
732: ,p_working_hours in number default hr_api.g_number
733: ,p_attribute_category in varchar2 default hr_api.g_varchar2
734: ,p_attribute1 in varchar2 default hr_api.g_varchar2
735: ,p_attribute2 in varchar2 default hr_api.g_varchar2
736: ,p_attribute3 in varchar2 default hr_api.g_varchar2
729: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
730: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
731: ,p_status in varchar2 default hr_api.g_varchar2
732: ,p_working_hours in number default hr_api.g_number
733: ,p_attribute_category in varchar2 default hr_api.g_varchar2
734: ,p_attribute1 in varchar2 default hr_api.g_varchar2
735: ,p_attribute2 in varchar2 default hr_api.g_varchar2
736: ,p_attribute3 in varchar2 default hr_api.g_varchar2
737: ,p_attribute4 in varchar2 default hr_api.g_varchar2
730: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
731: ,p_status in varchar2 default hr_api.g_varchar2
732: ,p_working_hours in number default hr_api.g_number
733: ,p_attribute_category in varchar2 default hr_api.g_varchar2
734: ,p_attribute1 in varchar2 default hr_api.g_varchar2
735: ,p_attribute2 in varchar2 default hr_api.g_varchar2
736: ,p_attribute3 in varchar2 default hr_api.g_varchar2
737: ,p_attribute4 in varchar2 default hr_api.g_varchar2
738: ,p_attribute5 in varchar2 default hr_api.g_varchar2
731: ,p_status in varchar2 default hr_api.g_varchar2
732: ,p_working_hours in number default hr_api.g_number
733: ,p_attribute_category in varchar2 default hr_api.g_varchar2
734: ,p_attribute1 in varchar2 default hr_api.g_varchar2
735: ,p_attribute2 in varchar2 default hr_api.g_varchar2
736: ,p_attribute3 in varchar2 default hr_api.g_varchar2
737: ,p_attribute4 in varchar2 default hr_api.g_varchar2
738: ,p_attribute5 in varchar2 default hr_api.g_varchar2
739: ,p_attribute6 in varchar2 default hr_api.g_varchar2
732: ,p_working_hours in number default hr_api.g_number
733: ,p_attribute_category in varchar2 default hr_api.g_varchar2
734: ,p_attribute1 in varchar2 default hr_api.g_varchar2
735: ,p_attribute2 in varchar2 default hr_api.g_varchar2
736: ,p_attribute3 in varchar2 default hr_api.g_varchar2
737: ,p_attribute4 in varchar2 default hr_api.g_varchar2
738: ,p_attribute5 in varchar2 default hr_api.g_varchar2
739: ,p_attribute6 in varchar2 default hr_api.g_varchar2
740: ,p_attribute7 in varchar2 default hr_api.g_varchar2
733: ,p_attribute_category in varchar2 default hr_api.g_varchar2
734: ,p_attribute1 in varchar2 default hr_api.g_varchar2
735: ,p_attribute2 in varchar2 default hr_api.g_varchar2
736: ,p_attribute3 in varchar2 default hr_api.g_varchar2
737: ,p_attribute4 in varchar2 default hr_api.g_varchar2
738: ,p_attribute5 in varchar2 default hr_api.g_varchar2
739: ,p_attribute6 in varchar2 default hr_api.g_varchar2
740: ,p_attribute7 in varchar2 default hr_api.g_varchar2
741: ,p_attribute8 in varchar2 default hr_api.g_varchar2
734: ,p_attribute1 in varchar2 default hr_api.g_varchar2
735: ,p_attribute2 in varchar2 default hr_api.g_varchar2
736: ,p_attribute3 in varchar2 default hr_api.g_varchar2
737: ,p_attribute4 in varchar2 default hr_api.g_varchar2
738: ,p_attribute5 in varchar2 default hr_api.g_varchar2
739: ,p_attribute6 in varchar2 default hr_api.g_varchar2
740: ,p_attribute7 in varchar2 default hr_api.g_varchar2
741: ,p_attribute8 in varchar2 default hr_api.g_varchar2
742: ,p_attribute9 in varchar2 default hr_api.g_varchar2
735: ,p_attribute2 in varchar2 default hr_api.g_varchar2
736: ,p_attribute3 in varchar2 default hr_api.g_varchar2
737: ,p_attribute4 in varchar2 default hr_api.g_varchar2
738: ,p_attribute5 in varchar2 default hr_api.g_varchar2
739: ,p_attribute6 in varchar2 default hr_api.g_varchar2
740: ,p_attribute7 in varchar2 default hr_api.g_varchar2
741: ,p_attribute8 in varchar2 default hr_api.g_varchar2
742: ,p_attribute9 in varchar2 default hr_api.g_varchar2
743: ,p_attribute10 in varchar2 default hr_api.g_varchar2
736: ,p_attribute3 in varchar2 default hr_api.g_varchar2
737: ,p_attribute4 in varchar2 default hr_api.g_varchar2
738: ,p_attribute5 in varchar2 default hr_api.g_varchar2
739: ,p_attribute6 in varchar2 default hr_api.g_varchar2
740: ,p_attribute7 in varchar2 default hr_api.g_varchar2
741: ,p_attribute8 in varchar2 default hr_api.g_varchar2
742: ,p_attribute9 in varchar2 default hr_api.g_varchar2
743: ,p_attribute10 in varchar2 default hr_api.g_varchar2
744: ,p_attribute11 in varchar2 default hr_api.g_varchar2
737: ,p_attribute4 in varchar2 default hr_api.g_varchar2
738: ,p_attribute5 in varchar2 default hr_api.g_varchar2
739: ,p_attribute6 in varchar2 default hr_api.g_varchar2
740: ,p_attribute7 in varchar2 default hr_api.g_varchar2
741: ,p_attribute8 in varchar2 default hr_api.g_varchar2
742: ,p_attribute9 in varchar2 default hr_api.g_varchar2
743: ,p_attribute10 in varchar2 default hr_api.g_varchar2
744: ,p_attribute11 in varchar2 default hr_api.g_varchar2
745: ,p_attribute12 in varchar2 default hr_api.g_varchar2
738: ,p_attribute5 in varchar2 default hr_api.g_varchar2
739: ,p_attribute6 in varchar2 default hr_api.g_varchar2
740: ,p_attribute7 in varchar2 default hr_api.g_varchar2
741: ,p_attribute8 in varchar2 default hr_api.g_varchar2
742: ,p_attribute9 in varchar2 default hr_api.g_varchar2
743: ,p_attribute10 in varchar2 default hr_api.g_varchar2
744: ,p_attribute11 in varchar2 default hr_api.g_varchar2
745: ,p_attribute12 in varchar2 default hr_api.g_varchar2
746: ,p_attribute13 in varchar2 default hr_api.g_varchar2
739: ,p_attribute6 in varchar2 default hr_api.g_varchar2
740: ,p_attribute7 in varchar2 default hr_api.g_varchar2
741: ,p_attribute8 in varchar2 default hr_api.g_varchar2
742: ,p_attribute9 in varchar2 default hr_api.g_varchar2
743: ,p_attribute10 in varchar2 default hr_api.g_varchar2
744: ,p_attribute11 in varchar2 default hr_api.g_varchar2
745: ,p_attribute12 in varchar2 default hr_api.g_varchar2
746: ,p_attribute13 in varchar2 default hr_api.g_varchar2
747: ,p_attribute14 in varchar2 default hr_api.g_varchar2
740: ,p_attribute7 in varchar2 default hr_api.g_varchar2
741: ,p_attribute8 in varchar2 default hr_api.g_varchar2
742: ,p_attribute9 in varchar2 default hr_api.g_varchar2
743: ,p_attribute10 in varchar2 default hr_api.g_varchar2
744: ,p_attribute11 in varchar2 default hr_api.g_varchar2
745: ,p_attribute12 in varchar2 default hr_api.g_varchar2
746: ,p_attribute13 in varchar2 default hr_api.g_varchar2
747: ,p_attribute14 in varchar2 default hr_api.g_varchar2
748: ,p_attribute15 in varchar2 default hr_api.g_varchar2
741: ,p_attribute8 in varchar2 default hr_api.g_varchar2
742: ,p_attribute9 in varchar2 default hr_api.g_varchar2
743: ,p_attribute10 in varchar2 default hr_api.g_varchar2
744: ,p_attribute11 in varchar2 default hr_api.g_varchar2
745: ,p_attribute12 in varchar2 default hr_api.g_varchar2
746: ,p_attribute13 in varchar2 default hr_api.g_varchar2
747: ,p_attribute14 in varchar2 default hr_api.g_varchar2
748: ,p_attribute15 in varchar2 default hr_api.g_varchar2
749: ,p_attribute16 in varchar2 default hr_api.g_varchar2
742: ,p_attribute9 in varchar2 default hr_api.g_varchar2
743: ,p_attribute10 in varchar2 default hr_api.g_varchar2
744: ,p_attribute11 in varchar2 default hr_api.g_varchar2
745: ,p_attribute12 in varchar2 default hr_api.g_varchar2
746: ,p_attribute13 in varchar2 default hr_api.g_varchar2
747: ,p_attribute14 in varchar2 default hr_api.g_varchar2
748: ,p_attribute15 in varchar2 default hr_api.g_varchar2
749: ,p_attribute16 in varchar2 default hr_api.g_varchar2
750: ,p_attribute17 in varchar2 default hr_api.g_varchar2
743: ,p_attribute10 in varchar2 default hr_api.g_varchar2
744: ,p_attribute11 in varchar2 default hr_api.g_varchar2
745: ,p_attribute12 in varchar2 default hr_api.g_varchar2
746: ,p_attribute13 in varchar2 default hr_api.g_varchar2
747: ,p_attribute14 in varchar2 default hr_api.g_varchar2
748: ,p_attribute15 in varchar2 default hr_api.g_varchar2
749: ,p_attribute16 in varchar2 default hr_api.g_varchar2
750: ,p_attribute17 in varchar2 default hr_api.g_varchar2
751: ,p_attribute18 in varchar2 default hr_api.g_varchar2
744: ,p_attribute11 in varchar2 default hr_api.g_varchar2
745: ,p_attribute12 in varchar2 default hr_api.g_varchar2
746: ,p_attribute13 in varchar2 default hr_api.g_varchar2
747: ,p_attribute14 in varchar2 default hr_api.g_varchar2
748: ,p_attribute15 in varchar2 default hr_api.g_varchar2
749: ,p_attribute16 in varchar2 default hr_api.g_varchar2
750: ,p_attribute17 in varchar2 default hr_api.g_varchar2
751: ,p_attribute18 in varchar2 default hr_api.g_varchar2
752: ,p_attribute19 in varchar2 default hr_api.g_varchar2
745: ,p_attribute12 in varchar2 default hr_api.g_varchar2
746: ,p_attribute13 in varchar2 default hr_api.g_varchar2
747: ,p_attribute14 in varchar2 default hr_api.g_varchar2
748: ,p_attribute15 in varchar2 default hr_api.g_varchar2
749: ,p_attribute16 in varchar2 default hr_api.g_varchar2
750: ,p_attribute17 in varchar2 default hr_api.g_varchar2
751: ,p_attribute18 in varchar2 default hr_api.g_varchar2
752: ,p_attribute19 in varchar2 default hr_api.g_varchar2
753: ,p_attribute20 in varchar2 default hr_api.g_varchar2
746: ,p_attribute13 in varchar2 default hr_api.g_varchar2
747: ,p_attribute14 in varchar2 default hr_api.g_varchar2
748: ,p_attribute15 in varchar2 default hr_api.g_varchar2
749: ,p_attribute16 in varchar2 default hr_api.g_varchar2
750: ,p_attribute17 in varchar2 default hr_api.g_varchar2
751: ,p_attribute18 in varchar2 default hr_api.g_varchar2
752: ,p_attribute19 in varchar2 default hr_api.g_varchar2
753: ,p_attribute20 in varchar2 default hr_api.g_varchar2
754: ,p_segment1 in varchar2 default hr_api.g_varchar2
747: ,p_attribute14 in varchar2 default hr_api.g_varchar2
748: ,p_attribute15 in varchar2 default hr_api.g_varchar2
749: ,p_attribute16 in varchar2 default hr_api.g_varchar2
750: ,p_attribute17 in varchar2 default hr_api.g_varchar2
751: ,p_attribute18 in varchar2 default hr_api.g_varchar2
752: ,p_attribute19 in varchar2 default hr_api.g_varchar2
753: ,p_attribute20 in varchar2 default hr_api.g_varchar2
754: ,p_segment1 in varchar2 default hr_api.g_varchar2
755: ,p_segment2 in varchar2 default hr_api.g_varchar2
748: ,p_attribute15 in varchar2 default hr_api.g_varchar2
749: ,p_attribute16 in varchar2 default hr_api.g_varchar2
750: ,p_attribute17 in varchar2 default hr_api.g_varchar2
751: ,p_attribute18 in varchar2 default hr_api.g_varchar2
752: ,p_attribute19 in varchar2 default hr_api.g_varchar2
753: ,p_attribute20 in varchar2 default hr_api.g_varchar2
754: ,p_segment1 in varchar2 default hr_api.g_varchar2
755: ,p_segment2 in varchar2 default hr_api.g_varchar2
756: ,p_segment3 in varchar2 default hr_api.g_varchar2
749: ,p_attribute16 in varchar2 default hr_api.g_varchar2
750: ,p_attribute17 in varchar2 default hr_api.g_varchar2
751: ,p_attribute18 in varchar2 default hr_api.g_varchar2
752: ,p_attribute19 in varchar2 default hr_api.g_varchar2
753: ,p_attribute20 in varchar2 default hr_api.g_varchar2
754: ,p_segment1 in varchar2 default hr_api.g_varchar2
755: ,p_segment2 in varchar2 default hr_api.g_varchar2
756: ,p_segment3 in varchar2 default hr_api.g_varchar2
757: ,p_segment4 in varchar2 default hr_api.g_varchar2
750: ,p_attribute17 in varchar2 default hr_api.g_varchar2
751: ,p_attribute18 in varchar2 default hr_api.g_varchar2
752: ,p_attribute19 in varchar2 default hr_api.g_varchar2
753: ,p_attribute20 in varchar2 default hr_api.g_varchar2
754: ,p_segment1 in varchar2 default hr_api.g_varchar2
755: ,p_segment2 in varchar2 default hr_api.g_varchar2
756: ,p_segment3 in varchar2 default hr_api.g_varchar2
757: ,p_segment4 in varchar2 default hr_api.g_varchar2
758: ,p_segment5 in varchar2 default hr_api.g_varchar2
751: ,p_attribute18 in varchar2 default hr_api.g_varchar2
752: ,p_attribute19 in varchar2 default hr_api.g_varchar2
753: ,p_attribute20 in varchar2 default hr_api.g_varchar2
754: ,p_segment1 in varchar2 default hr_api.g_varchar2
755: ,p_segment2 in varchar2 default hr_api.g_varchar2
756: ,p_segment3 in varchar2 default hr_api.g_varchar2
757: ,p_segment4 in varchar2 default hr_api.g_varchar2
758: ,p_segment5 in varchar2 default hr_api.g_varchar2
759: ,p_segment6 in varchar2 default hr_api.g_varchar2
752: ,p_attribute19 in varchar2 default hr_api.g_varchar2
753: ,p_attribute20 in varchar2 default hr_api.g_varchar2
754: ,p_segment1 in varchar2 default hr_api.g_varchar2
755: ,p_segment2 in varchar2 default hr_api.g_varchar2
756: ,p_segment3 in varchar2 default hr_api.g_varchar2
757: ,p_segment4 in varchar2 default hr_api.g_varchar2
758: ,p_segment5 in varchar2 default hr_api.g_varchar2
759: ,p_segment6 in varchar2 default hr_api.g_varchar2
760: ,p_segment7 in varchar2 default hr_api.g_varchar2
753: ,p_attribute20 in varchar2 default hr_api.g_varchar2
754: ,p_segment1 in varchar2 default hr_api.g_varchar2
755: ,p_segment2 in varchar2 default hr_api.g_varchar2
756: ,p_segment3 in varchar2 default hr_api.g_varchar2
757: ,p_segment4 in varchar2 default hr_api.g_varchar2
758: ,p_segment5 in varchar2 default hr_api.g_varchar2
759: ,p_segment6 in varchar2 default hr_api.g_varchar2
760: ,p_segment7 in varchar2 default hr_api.g_varchar2
761: ,p_segment8 in varchar2 default hr_api.g_varchar2
754: ,p_segment1 in varchar2 default hr_api.g_varchar2
755: ,p_segment2 in varchar2 default hr_api.g_varchar2
756: ,p_segment3 in varchar2 default hr_api.g_varchar2
757: ,p_segment4 in varchar2 default hr_api.g_varchar2
758: ,p_segment5 in varchar2 default hr_api.g_varchar2
759: ,p_segment6 in varchar2 default hr_api.g_varchar2
760: ,p_segment7 in varchar2 default hr_api.g_varchar2
761: ,p_segment8 in varchar2 default hr_api.g_varchar2
762: ,p_segment9 in varchar2 default hr_api.g_varchar2
755: ,p_segment2 in varchar2 default hr_api.g_varchar2
756: ,p_segment3 in varchar2 default hr_api.g_varchar2
757: ,p_segment4 in varchar2 default hr_api.g_varchar2
758: ,p_segment5 in varchar2 default hr_api.g_varchar2
759: ,p_segment6 in varchar2 default hr_api.g_varchar2
760: ,p_segment7 in varchar2 default hr_api.g_varchar2
761: ,p_segment8 in varchar2 default hr_api.g_varchar2
762: ,p_segment9 in varchar2 default hr_api.g_varchar2
763: ,p_segment10 in varchar2 default hr_api.g_varchar2
756: ,p_segment3 in varchar2 default hr_api.g_varchar2
757: ,p_segment4 in varchar2 default hr_api.g_varchar2
758: ,p_segment5 in varchar2 default hr_api.g_varchar2
759: ,p_segment6 in varchar2 default hr_api.g_varchar2
760: ,p_segment7 in varchar2 default hr_api.g_varchar2
761: ,p_segment8 in varchar2 default hr_api.g_varchar2
762: ,p_segment9 in varchar2 default hr_api.g_varchar2
763: ,p_segment10 in varchar2 default hr_api.g_varchar2
764: ,p_segment11 in varchar2 default hr_api.g_varchar2
757: ,p_segment4 in varchar2 default hr_api.g_varchar2
758: ,p_segment5 in varchar2 default hr_api.g_varchar2
759: ,p_segment6 in varchar2 default hr_api.g_varchar2
760: ,p_segment7 in varchar2 default hr_api.g_varchar2
761: ,p_segment8 in varchar2 default hr_api.g_varchar2
762: ,p_segment9 in varchar2 default hr_api.g_varchar2
763: ,p_segment10 in varchar2 default hr_api.g_varchar2
764: ,p_segment11 in varchar2 default hr_api.g_varchar2
765: ,p_segment12 in varchar2 default hr_api.g_varchar2
758: ,p_segment5 in varchar2 default hr_api.g_varchar2
759: ,p_segment6 in varchar2 default hr_api.g_varchar2
760: ,p_segment7 in varchar2 default hr_api.g_varchar2
761: ,p_segment8 in varchar2 default hr_api.g_varchar2
762: ,p_segment9 in varchar2 default hr_api.g_varchar2
763: ,p_segment10 in varchar2 default hr_api.g_varchar2
764: ,p_segment11 in varchar2 default hr_api.g_varchar2
765: ,p_segment12 in varchar2 default hr_api.g_varchar2
766: ,p_segment13 in varchar2 default hr_api.g_varchar2
759: ,p_segment6 in varchar2 default hr_api.g_varchar2
760: ,p_segment7 in varchar2 default hr_api.g_varchar2
761: ,p_segment8 in varchar2 default hr_api.g_varchar2
762: ,p_segment9 in varchar2 default hr_api.g_varchar2
763: ,p_segment10 in varchar2 default hr_api.g_varchar2
764: ,p_segment11 in varchar2 default hr_api.g_varchar2
765: ,p_segment12 in varchar2 default hr_api.g_varchar2
766: ,p_segment13 in varchar2 default hr_api.g_varchar2
767: ,p_segment14 in varchar2 default hr_api.g_varchar2
760: ,p_segment7 in varchar2 default hr_api.g_varchar2
761: ,p_segment8 in varchar2 default hr_api.g_varchar2
762: ,p_segment9 in varchar2 default hr_api.g_varchar2
763: ,p_segment10 in varchar2 default hr_api.g_varchar2
764: ,p_segment11 in varchar2 default hr_api.g_varchar2
765: ,p_segment12 in varchar2 default hr_api.g_varchar2
766: ,p_segment13 in varchar2 default hr_api.g_varchar2
767: ,p_segment14 in varchar2 default hr_api.g_varchar2
768: ,p_segment15 in varchar2 default hr_api.g_varchar2
761: ,p_segment8 in varchar2 default hr_api.g_varchar2
762: ,p_segment9 in varchar2 default hr_api.g_varchar2
763: ,p_segment10 in varchar2 default hr_api.g_varchar2
764: ,p_segment11 in varchar2 default hr_api.g_varchar2
765: ,p_segment12 in varchar2 default hr_api.g_varchar2
766: ,p_segment13 in varchar2 default hr_api.g_varchar2
767: ,p_segment14 in varchar2 default hr_api.g_varchar2
768: ,p_segment15 in varchar2 default hr_api.g_varchar2
769: ,p_segment16 in varchar2 default hr_api.g_varchar2
762: ,p_segment9 in varchar2 default hr_api.g_varchar2
763: ,p_segment10 in varchar2 default hr_api.g_varchar2
764: ,p_segment11 in varchar2 default hr_api.g_varchar2
765: ,p_segment12 in varchar2 default hr_api.g_varchar2
766: ,p_segment13 in varchar2 default hr_api.g_varchar2
767: ,p_segment14 in varchar2 default hr_api.g_varchar2
768: ,p_segment15 in varchar2 default hr_api.g_varchar2
769: ,p_segment16 in varchar2 default hr_api.g_varchar2
770: ,p_segment17 in varchar2 default hr_api.g_varchar2
763: ,p_segment10 in varchar2 default hr_api.g_varchar2
764: ,p_segment11 in varchar2 default hr_api.g_varchar2
765: ,p_segment12 in varchar2 default hr_api.g_varchar2
766: ,p_segment13 in varchar2 default hr_api.g_varchar2
767: ,p_segment14 in varchar2 default hr_api.g_varchar2
768: ,p_segment15 in varchar2 default hr_api.g_varchar2
769: ,p_segment16 in varchar2 default hr_api.g_varchar2
770: ,p_segment17 in varchar2 default hr_api.g_varchar2
771: ,p_segment18 in varchar2 default hr_api.g_varchar2
764: ,p_segment11 in varchar2 default hr_api.g_varchar2
765: ,p_segment12 in varchar2 default hr_api.g_varchar2
766: ,p_segment13 in varchar2 default hr_api.g_varchar2
767: ,p_segment14 in varchar2 default hr_api.g_varchar2
768: ,p_segment15 in varchar2 default hr_api.g_varchar2
769: ,p_segment16 in varchar2 default hr_api.g_varchar2
770: ,p_segment17 in varchar2 default hr_api.g_varchar2
771: ,p_segment18 in varchar2 default hr_api.g_varchar2
772: ,p_segment19 in varchar2 default hr_api.g_varchar2
765: ,p_segment12 in varchar2 default hr_api.g_varchar2
766: ,p_segment13 in varchar2 default hr_api.g_varchar2
767: ,p_segment14 in varchar2 default hr_api.g_varchar2
768: ,p_segment15 in varchar2 default hr_api.g_varchar2
769: ,p_segment16 in varchar2 default hr_api.g_varchar2
770: ,p_segment17 in varchar2 default hr_api.g_varchar2
771: ,p_segment18 in varchar2 default hr_api.g_varchar2
772: ,p_segment19 in varchar2 default hr_api.g_varchar2
773: ,p_segment20 in varchar2 default hr_api.g_varchar2
766: ,p_segment13 in varchar2 default hr_api.g_varchar2
767: ,p_segment14 in varchar2 default hr_api.g_varchar2
768: ,p_segment15 in varchar2 default hr_api.g_varchar2
769: ,p_segment16 in varchar2 default hr_api.g_varchar2
770: ,p_segment17 in varchar2 default hr_api.g_varchar2
771: ,p_segment18 in varchar2 default hr_api.g_varchar2
772: ,p_segment19 in varchar2 default hr_api.g_varchar2
773: ,p_segment20 in varchar2 default hr_api.g_varchar2
774: ,p_segment21 in varchar2 default hr_api.g_varchar2
767: ,p_segment14 in varchar2 default hr_api.g_varchar2
768: ,p_segment15 in varchar2 default hr_api.g_varchar2
769: ,p_segment16 in varchar2 default hr_api.g_varchar2
770: ,p_segment17 in varchar2 default hr_api.g_varchar2
771: ,p_segment18 in varchar2 default hr_api.g_varchar2
772: ,p_segment19 in varchar2 default hr_api.g_varchar2
773: ,p_segment20 in varchar2 default hr_api.g_varchar2
774: ,p_segment21 in varchar2 default hr_api.g_varchar2
775: ,p_segment22 in varchar2 default hr_api.g_varchar2
768: ,p_segment15 in varchar2 default hr_api.g_varchar2
769: ,p_segment16 in varchar2 default hr_api.g_varchar2
770: ,p_segment17 in varchar2 default hr_api.g_varchar2
771: ,p_segment18 in varchar2 default hr_api.g_varchar2
772: ,p_segment19 in varchar2 default hr_api.g_varchar2
773: ,p_segment20 in varchar2 default hr_api.g_varchar2
774: ,p_segment21 in varchar2 default hr_api.g_varchar2
775: ,p_segment22 in varchar2 default hr_api.g_varchar2
776: ,p_segment23 in varchar2 default hr_api.g_varchar2
769: ,p_segment16 in varchar2 default hr_api.g_varchar2
770: ,p_segment17 in varchar2 default hr_api.g_varchar2
771: ,p_segment18 in varchar2 default hr_api.g_varchar2
772: ,p_segment19 in varchar2 default hr_api.g_varchar2
773: ,p_segment20 in varchar2 default hr_api.g_varchar2
774: ,p_segment21 in varchar2 default hr_api.g_varchar2
775: ,p_segment22 in varchar2 default hr_api.g_varchar2
776: ,p_segment23 in varchar2 default hr_api.g_varchar2
777: ,p_segment24 in varchar2 default hr_api.g_varchar2
770: ,p_segment17 in varchar2 default hr_api.g_varchar2
771: ,p_segment18 in varchar2 default hr_api.g_varchar2
772: ,p_segment19 in varchar2 default hr_api.g_varchar2
773: ,p_segment20 in varchar2 default hr_api.g_varchar2
774: ,p_segment21 in varchar2 default hr_api.g_varchar2
775: ,p_segment22 in varchar2 default hr_api.g_varchar2
776: ,p_segment23 in varchar2 default hr_api.g_varchar2
777: ,p_segment24 in varchar2 default hr_api.g_varchar2
778: ,p_segment25 in varchar2 default hr_api.g_varchar2
771: ,p_segment18 in varchar2 default hr_api.g_varchar2
772: ,p_segment19 in varchar2 default hr_api.g_varchar2
773: ,p_segment20 in varchar2 default hr_api.g_varchar2
774: ,p_segment21 in varchar2 default hr_api.g_varchar2
775: ,p_segment22 in varchar2 default hr_api.g_varchar2
776: ,p_segment23 in varchar2 default hr_api.g_varchar2
777: ,p_segment24 in varchar2 default hr_api.g_varchar2
778: ,p_segment25 in varchar2 default hr_api.g_varchar2
779: ,p_segment26 in varchar2 default hr_api.g_varchar2
772: ,p_segment19 in varchar2 default hr_api.g_varchar2
773: ,p_segment20 in varchar2 default hr_api.g_varchar2
774: ,p_segment21 in varchar2 default hr_api.g_varchar2
775: ,p_segment22 in varchar2 default hr_api.g_varchar2
776: ,p_segment23 in varchar2 default hr_api.g_varchar2
777: ,p_segment24 in varchar2 default hr_api.g_varchar2
778: ,p_segment25 in varchar2 default hr_api.g_varchar2
779: ,p_segment26 in varchar2 default hr_api.g_varchar2
780: ,p_segment27 in varchar2 default hr_api.g_varchar2
773: ,p_segment20 in varchar2 default hr_api.g_varchar2
774: ,p_segment21 in varchar2 default hr_api.g_varchar2
775: ,p_segment22 in varchar2 default hr_api.g_varchar2
776: ,p_segment23 in varchar2 default hr_api.g_varchar2
777: ,p_segment24 in varchar2 default hr_api.g_varchar2
778: ,p_segment25 in varchar2 default hr_api.g_varchar2
779: ,p_segment26 in varchar2 default hr_api.g_varchar2
780: ,p_segment27 in varchar2 default hr_api.g_varchar2
781: ,p_segment28 in varchar2 default hr_api.g_varchar2
774: ,p_segment21 in varchar2 default hr_api.g_varchar2
775: ,p_segment22 in varchar2 default hr_api.g_varchar2
776: ,p_segment23 in varchar2 default hr_api.g_varchar2
777: ,p_segment24 in varchar2 default hr_api.g_varchar2
778: ,p_segment25 in varchar2 default hr_api.g_varchar2
779: ,p_segment26 in varchar2 default hr_api.g_varchar2
780: ,p_segment27 in varchar2 default hr_api.g_varchar2
781: ,p_segment28 in varchar2 default hr_api.g_varchar2
782: ,p_segment29 in varchar2 default hr_api.g_varchar2
775: ,p_segment22 in varchar2 default hr_api.g_varchar2
776: ,p_segment23 in varchar2 default hr_api.g_varchar2
777: ,p_segment24 in varchar2 default hr_api.g_varchar2
778: ,p_segment25 in varchar2 default hr_api.g_varchar2
779: ,p_segment26 in varchar2 default hr_api.g_varchar2
780: ,p_segment27 in varchar2 default hr_api.g_varchar2
781: ,p_segment28 in varchar2 default hr_api.g_varchar2
782: ,p_segment29 in varchar2 default hr_api.g_varchar2
783: ,p_segment30 in varchar2 default hr_api.g_varchar2
776: ,p_segment23 in varchar2 default hr_api.g_varchar2
777: ,p_segment24 in varchar2 default hr_api.g_varchar2
778: ,p_segment25 in varchar2 default hr_api.g_varchar2
779: ,p_segment26 in varchar2 default hr_api.g_varchar2
780: ,p_segment27 in varchar2 default hr_api.g_varchar2
781: ,p_segment28 in varchar2 default hr_api.g_varchar2
782: ,p_segment29 in varchar2 default hr_api.g_varchar2
783: ,p_segment30 in varchar2 default hr_api.g_varchar2
784: ,p_concat_segments in varchar2 default hr_api.g_varchar2
777: ,p_segment24 in varchar2 default hr_api.g_varchar2
778: ,p_segment25 in varchar2 default hr_api.g_varchar2
779: ,p_segment26 in varchar2 default hr_api.g_varchar2
780: ,p_segment27 in varchar2 default hr_api.g_varchar2
781: ,p_segment28 in varchar2 default hr_api.g_varchar2
782: ,p_segment29 in varchar2 default hr_api.g_varchar2
783: ,p_segment30 in varchar2 default hr_api.g_varchar2
784: ,p_concat_segments in varchar2 default hr_api.g_varchar2
785: ,p_position_definition_id in out nocopy number
778: ,p_segment25 in varchar2 default hr_api.g_varchar2
779: ,p_segment26 in varchar2 default hr_api.g_varchar2
780: ,p_segment27 in varchar2 default hr_api.g_varchar2
781: ,p_segment28 in varchar2 default hr_api.g_varchar2
782: ,p_segment29 in varchar2 default hr_api.g_varchar2
783: ,p_segment30 in varchar2 default hr_api.g_varchar2
784: ,p_concat_segments in varchar2 default hr_api.g_varchar2
785: ,p_position_definition_id in out nocopy number
786: ,p_name in out nocopy varchar2
779: ,p_segment26 in varchar2 default hr_api.g_varchar2
780: ,p_segment27 in varchar2 default hr_api.g_varchar2
781: ,p_segment28 in varchar2 default hr_api.g_varchar2
782: ,p_segment29 in varchar2 default hr_api.g_varchar2
783: ,p_segment30 in varchar2 default hr_api.g_varchar2
784: ,p_concat_segments in varchar2 default hr_api.g_varchar2
785: ,p_position_definition_id in out nocopy number
786: ,p_name in out nocopy varchar2
787: ,p_valid_grades_changed_warning out nocopy boolean
780: ,p_segment27 in varchar2 default hr_api.g_varchar2
781: ,p_segment28 in varchar2 default hr_api.g_varchar2
782: ,p_segment29 in varchar2 default hr_api.g_varchar2
783: ,p_segment30 in varchar2 default hr_api.g_varchar2
784: ,p_concat_segments in varchar2 default hr_api.g_varchar2
785: ,p_position_definition_id in out nocopy number
786: ,p_name in out nocopy varchar2
787: ,p_valid_grades_changed_warning out nocopy boolean
788: ) is
1147: -- fnd_message.set_name('PQH','DATE-'||l_object_version_number);
1148: -- fnd_message.raise_error;
1149:
1150: -- changed it for bugfix 2997103
1151: if ( nvl(hr_psf_shd.g_old_rec.date_end, hr_api.g_date) <>
1152: nvl(p_date_end, hr_api.g_date)
1153: and p_date_end is not null) then
1154:
1155: create_eliminated_rec(
1148: -- fnd_message.raise_error;
1149:
1150: -- changed it for bugfix 2997103
1151: if ( nvl(hr_psf_shd.g_old_rec.date_end, hr_api.g_date) <>
1152: nvl(p_date_end, hr_api.g_date)
1153: and p_date_end is not null) then
1154:
1155: create_eliminated_rec(
1156: p_position_id => p_position_id,
1173: --
1174: -- When in validation only mode raise the Validate_Enabled exception
1175: --
1176: if p_validate then
1177: raise hr_api.validate_enabled;
1178: end if;
1179: --
1180: if l_valid_grades_changed1 or l_valid_grades_changed2 then
1181: p_valid_grades_changed_warning := TRUE;
1190: if g_debug then
1191: hr_utility.set_location(' Leaving:'||l_proc, 11);
1192: end if;
1193: exception
1194: when hr_api.validate_enabled then
1195: --
1196: -- As the Validate_Enabled exception has been raised
1197: -- we must rollback to the savepoint
1198: --
1339: procedure lck
1340: (
1341: p_position_id in number
1342: ,p_object_version_number in number
1343: ,p_language_code in varchar2 default hr_api.userenv_lang
1344: ) is
1345: l_proc varchar2(72);
1346: l_effective_date date;
1347: l_object_version_number number;
1477: -- for a position in accordance with that position's new Date Effective,
1478: -- (ie. p_maintenance_mode = 'DATE_EFFECTIVE') then the p_date_effective
1479: -- parameter should have been set.
1480: --
1481: hr_api.mandatory_arg_error
1482: (p_api_name => l_proc
1483: ,p_argument => 'date_effective'
1484: ,p_argument_value => p_date_effective);
1485: --
1497: if g_debug then
1498: hr_utility.set_location(l_proc, 15);
1499: end if;
1500: if (c_vgr_rec.date_from < p_date_effective and
1501: nvl(c_vgr_rec.date_to, hr_api.g_eot) > p_date_effective ) then
1502: --
1503: if g_debug then
1504: hr_utility.set_location(l_proc, 20);
1505: end if;
1542: -- for a position in accordance with that position's new Date End,
1543: -- (ie. p_maintenance_mode = 'DATE_END') then the p_date_end parameter
1544: -- should have been set.
1545: --
1546: hr_api.mandatory_arg_error
1547: (p_api_name => l_proc
1548: ,p_argument => 'date_end'
1549: ,p_argument_value => p_date_end);
1550: --
1563: hr_utility.set_location(l_proc, 35);
1564: end if;
1565: --
1566: if (c_vgr_rec.date_from < p_date_end and
1567: nvl(c_vgr_rec.date_to, hr_api.g_eot) > p_date_end ) then
1568: --
1569: if g_debug then
1570: hr_utility.set_location(l_proc, 40);
1571: end if;
1626: --
1627: l_ovn number;
1628: l_esd date;
1629: l_eed date;
1630: l_lck_mode varchar2(100):=hr_api.g_future_change;
1631: l_proc varchar2(30);
1632: --
1633: cursor c1 (p_position_id in number) is
1634: select object_version_number
1644: end if;
1645: --
1646: -- Check mandatory parameters have been set
1647: --
1648: hr_api.mandatory_arg_error
1649: (p_api_name => l_proc
1650: ,p_argument => 'position_id'
1651: ,p_argument_value => p_position_id
1652: );
1653: if g_debug then
1654: hr_utility.set_location(l_proc, 20);
1655: end if;
1656: --
1657: hr_api.mandatory_arg_error
1658: (p_api_name => l_proc
1659: ,p_argument => 'effective_date'
1660: ,p_argument_value => p_effective_date
1661: );
1663: hr_utility.set_location(l_proc, 30);
1664: end if;
1665: --
1666: /*
1667: hr_api.mandatory_arg_error
1668: (p_api_name => l_proc
1669: ,p_argument => 'datetrack_mode'
1670: ,p_argument_value => p_datetrack_mode
1671: );
1670: ,p_argument_value => p_datetrack_mode
1671: );
1672: */
1673: --
1674: if p_datetrack_mode = hr_api.g_zap then
1675: --
1676: -- lock row in per_all_positions
1677: --
1678: if g_debug then
1715: hr_utility.set_location(l_proc, 80);
1716: end if;
1717: --
1718: end if;
1719: elsif p_datetrack_mode = hr_api.g_update or
1720: p_datetrack_mode = hr_api.g_update_change_insert or
1721: p_datetrack_mode = hr_api.g_correction or
1722: p_datetrack_mode = hr_api.g_delete or
1723: p_datetrack_mode = hr_api.g_delete_next_change or
1716: end if;
1717: --
1718: end if;
1719: elsif p_datetrack_mode = hr_api.g_update or
1720: p_datetrack_mode = hr_api.g_update_change_insert or
1721: p_datetrack_mode = hr_api.g_correction or
1722: p_datetrack_mode = hr_api.g_delete or
1723: p_datetrack_mode = hr_api.g_delete_next_change or
1724: p_datetrack_mode = hr_api.g_future_change or
1717: --
1718: end if;
1719: elsif p_datetrack_mode = hr_api.g_update or
1720: p_datetrack_mode = hr_api.g_update_change_insert or
1721: p_datetrack_mode = hr_api.g_correction or
1722: p_datetrack_mode = hr_api.g_delete or
1723: p_datetrack_mode = hr_api.g_delete_next_change or
1724: p_datetrack_mode = hr_api.g_future_change or
1725: p_datetrack_mode is null
1718: end if;
1719: elsif p_datetrack_mode = hr_api.g_update or
1720: p_datetrack_mode = hr_api.g_update_change_insert or
1721: p_datetrack_mode = hr_api.g_correction or
1722: p_datetrack_mode = hr_api.g_delete or
1723: p_datetrack_mode = hr_api.g_delete_next_change or
1724: p_datetrack_mode = hr_api.g_future_change or
1725: p_datetrack_mode is null
1726: then
1719: elsif p_datetrack_mode = hr_api.g_update or
1720: p_datetrack_mode = hr_api.g_update_change_insert or
1721: p_datetrack_mode = hr_api.g_correction or
1722: p_datetrack_mode = hr_api.g_delete or
1723: p_datetrack_mode = hr_api.g_delete_next_change or
1724: p_datetrack_mode = hr_api.g_future_change or
1725: p_datetrack_mode is null
1726: then
1727: --
1720: p_datetrack_mode = hr_api.g_update_change_insert or
1721: p_datetrack_mode = hr_api.g_correction or
1722: p_datetrack_mode = hr_api.g_delete or
1723: p_datetrack_mode = hr_api.g_delete_next_change or
1724: p_datetrack_mode = hr_api.g_future_change or
1725: p_datetrack_mode is null
1726: then
1727: --
1728: -- update in per_all_positions table
1727: --
1728: -- update in per_all_positions table
1729: --
1730: begin
1731: -- if l_effective_end_date <> hr_api.g_eot then
1732: -- lock the position rows explicitly
1733: if g_debug then
1734: hr_utility.set_location(l_proc, 80);
1735: end if;
1758: set copied_to_old_table_flag = 'N'
1759: where position_id = p_position_id and
1760: effective_end_date >
1761: decode( p_datetrack_mode
1762: ,hr_api.g_update, p_effective_date
1763: ,hr_api.g_correction, p_effective_date
1764: ,hr_api.g_update_change_insert, p_effective_date
1765: ,hr_api.g_delete, p_effective_date - 1
1766: ,hr_api.g_delete_next_change, p_effective_date - 1
1759: where position_id = p_position_id and
1760: effective_end_date >
1761: decode( p_datetrack_mode
1762: ,hr_api.g_update, p_effective_date
1763: ,hr_api.g_correction, p_effective_date
1764: ,hr_api.g_update_change_insert, p_effective_date
1765: ,hr_api.g_delete, p_effective_date - 1
1766: ,hr_api.g_delete_next_change, p_effective_date - 1
1767: ,hr_api.g_future_change, p_effective_date - 1
1760: effective_end_date >
1761: decode( p_datetrack_mode
1762: ,hr_api.g_update, p_effective_date
1763: ,hr_api.g_correction, p_effective_date
1764: ,hr_api.g_update_change_insert, p_effective_date
1765: ,hr_api.g_delete, p_effective_date - 1
1766: ,hr_api.g_delete_next_change, p_effective_date - 1
1767: ,hr_api.g_future_change, p_effective_date - 1
1768: );
1761: decode( p_datetrack_mode
1762: ,hr_api.g_update, p_effective_date
1763: ,hr_api.g_correction, p_effective_date
1764: ,hr_api.g_update_change_insert, p_effective_date
1765: ,hr_api.g_delete, p_effective_date - 1
1766: ,hr_api.g_delete_next_change, p_effective_date - 1
1767: ,hr_api.g_future_change, p_effective_date - 1
1768: );
1769: --
1762: ,hr_api.g_update, p_effective_date
1763: ,hr_api.g_correction, p_effective_date
1764: ,hr_api.g_update_change_insert, p_effective_date
1765: ,hr_api.g_delete, p_effective_date - 1
1766: ,hr_api.g_delete_next_change, p_effective_date - 1
1767: ,hr_api.g_future_change, p_effective_date - 1
1768: );
1769: --
1770: if g_debug then
1763: ,hr_api.g_correction, p_effective_date
1764: ,hr_api.g_update_change_insert, p_effective_date
1765: ,hr_api.g_delete, p_effective_date - 1
1766: ,hr_api.g_delete_next_change, p_effective_date - 1
1767: ,hr_api.g_future_change, p_effective_date - 1
1768: );
1769: --
1770: if g_debug then
1771: hr_utility.set_location(l_proc, 100);
1807: ,p_job_id in number
1808: ,p_organization_id in number
1809: ,p_effective_date in date
1810: ,p_date_effective in date
1811: ,p_language_code in varchar2 default hr_api.userenv_lang
1812: ,p_validate in boolean default false
1813: ,p_availability_status_id in number default null
1814: ,p_business_group_id in number default null
1815: ,p_entry_step_id in number default null
2119: -- instead of p_language_code from now on, to allow an IN OUT parameter to
2120: -- be passed through.
2121: --
2122: l_language_code := p_language_code;
2123: hr_api.validate_language_code(p_language_code => l_language_code);
2124: --
2125: -- Get business_group_id using job.
2126: --
2127: if g_debug then
2426: ,p_effective_date => trunc(p_effective_date)
2427: ,p_language_code => l_language_code
2428: );
2429: exception
2430: when hr_api.cannot_find_prog_unit then
2431: hr_api.cannot_find_prog_unit_error
2432: (
2433: p_module_name => 'CREATE_POSITION'
2434: ,p_hook_type => 'BP'
2427: ,p_language_code => l_language_code
2428: );
2429: exception
2430: when hr_api.cannot_find_prog_unit then
2431: hr_api.cannot_find_prog_unit_error
2432: (
2433: p_module_name => 'CREATE_POSITION'
2434: ,p_hook_type => 'BP'
2435: );
2901: ,p_effective_date => trunc(p_effective_date)
2902: ,p_language_code => l_language_code
2903: );
2904: exception
2905: when hr_api.cannot_find_prog_unit then
2906: hr_api.cannot_find_prog_unit_error
2907: (p_module_name => 'CREATE_POSITION'
2908: ,p_hook_type => 'AP'
2909: );
2902: ,p_language_code => l_language_code
2903: );
2904: exception
2905: when hr_api.cannot_find_prog_unit then
2906: hr_api.cannot_find_prog_unit_error
2907: (p_module_name => 'CREATE_POSITION'
2908: ,p_hook_type => 'AP'
2909: );
2910: --
2918: --
2919: -- When in validation only mode raise the Validate_Enabled exception
2920: --
2921: if p_validate then
2922: raise hr_api.validate_enabled;
2923: end if;
2924: --
2925: -- Set all output arguments
2926: --
2936: end if;
2937: --
2938: exception
2939: --
2940: when hr_api.validate_enabled then
2941: --
2942: -- As the Validate_Enabled exception has been raised
2943: -- we must rollback to the savepoint
2944: --
2989: ,p_effective_end_date out nocopy date
2990: ,p_position_definition_id in out nocopy number
2991: ,p_valid_grades_changed_warning out nocopy boolean
2992: ,p_name in out nocopy varchar2
2993: ,p_language_code in varchar2 default hr_api.userenv_lang
2994: ,p_availability_status_id in number default hr_api.g_number
2995: -- ,p_business_group_id in number default hr_api.g_number
2996: ,p_entry_step_id in number default hr_api.g_number
2997: ,p_entry_grade_rule_id in number default hr_api.g_number
2990: ,p_position_definition_id in out nocopy number
2991: ,p_valid_grades_changed_warning out nocopy boolean
2992: ,p_name in out nocopy varchar2
2993: ,p_language_code in varchar2 default hr_api.userenv_lang
2994: ,p_availability_status_id in number default hr_api.g_number
2995: -- ,p_business_group_id in number default hr_api.g_number
2996: ,p_entry_step_id in number default hr_api.g_number
2997: ,p_entry_grade_rule_id in number default hr_api.g_number
2998: -- ,p_job_id in number default hr_api.g_number
2991: ,p_valid_grades_changed_warning out nocopy boolean
2992: ,p_name in out nocopy varchar2
2993: ,p_language_code in varchar2 default hr_api.userenv_lang
2994: ,p_availability_status_id in number default hr_api.g_number
2995: -- ,p_business_group_id in number default hr_api.g_number
2996: ,p_entry_step_id in number default hr_api.g_number
2997: ,p_entry_grade_rule_id in number default hr_api.g_number
2998: -- ,p_job_id in number default hr_api.g_number
2999: ,p_location_id in number default hr_api.g_number
2992: ,p_name in out nocopy varchar2
2993: ,p_language_code in varchar2 default hr_api.userenv_lang
2994: ,p_availability_status_id in number default hr_api.g_number
2995: -- ,p_business_group_id in number default hr_api.g_number
2996: ,p_entry_step_id in number default hr_api.g_number
2997: ,p_entry_grade_rule_id in number default hr_api.g_number
2998: -- ,p_job_id in number default hr_api.g_number
2999: ,p_location_id in number default hr_api.g_number
3000: -- ,p_organization_id in number default hr_api.g_number
2993: ,p_language_code in varchar2 default hr_api.userenv_lang
2994: ,p_availability_status_id in number default hr_api.g_number
2995: -- ,p_business_group_id in number default hr_api.g_number
2996: ,p_entry_step_id in number default hr_api.g_number
2997: ,p_entry_grade_rule_id in number default hr_api.g_number
2998: -- ,p_job_id in number default hr_api.g_number
2999: ,p_location_id in number default hr_api.g_number
3000: -- ,p_organization_id in number default hr_api.g_number
3001: ,p_pay_freq_payroll_id in number default hr_api.g_number
2994: ,p_availability_status_id in number default hr_api.g_number
2995: -- ,p_business_group_id in number default hr_api.g_number
2996: ,p_entry_step_id in number default hr_api.g_number
2997: ,p_entry_grade_rule_id in number default hr_api.g_number
2998: -- ,p_job_id in number default hr_api.g_number
2999: ,p_location_id in number default hr_api.g_number
3000: -- ,p_organization_id in number default hr_api.g_number
3001: ,p_pay_freq_payroll_id in number default hr_api.g_number
3002: ,p_position_transaction_id in number default hr_api.g_number
2995: -- ,p_business_group_id in number default hr_api.g_number
2996: ,p_entry_step_id in number default hr_api.g_number
2997: ,p_entry_grade_rule_id in number default hr_api.g_number
2998: -- ,p_job_id in number default hr_api.g_number
2999: ,p_location_id in number default hr_api.g_number
3000: -- ,p_organization_id in number default hr_api.g_number
3001: ,p_pay_freq_payroll_id in number default hr_api.g_number
3002: ,p_position_transaction_id in number default hr_api.g_number
3003: ,p_prior_position_id in number default hr_api.g_number
2996: ,p_entry_step_id in number default hr_api.g_number
2997: ,p_entry_grade_rule_id in number default hr_api.g_number
2998: -- ,p_job_id in number default hr_api.g_number
2999: ,p_location_id in number default hr_api.g_number
3000: -- ,p_organization_id in number default hr_api.g_number
3001: ,p_pay_freq_payroll_id in number default hr_api.g_number
3002: ,p_position_transaction_id in number default hr_api.g_number
3003: ,p_prior_position_id in number default hr_api.g_number
3004: ,p_relief_position_id in number default hr_api.g_number
2997: ,p_entry_grade_rule_id in number default hr_api.g_number
2998: -- ,p_job_id in number default hr_api.g_number
2999: ,p_location_id in number default hr_api.g_number
3000: -- ,p_organization_id in number default hr_api.g_number
3001: ,p_pay_freq_payroll_id in number default hr_api.g_number
3002: ,p_position_transaction_id in number default hr_api.g_number
3003: ,p_prior_position_id in number default hr_api.g_number
3004: ,p_relief_position_id in number default hr_api.g_number
3005: ,p_entry_grade_id in number default hr_api.g_number
2998: -- ,p_job_id in number default hr_api.g_number
2999: ,p_location_id in number default hr_api.g_number
3000: -- ,p_organization_id in number default hr_api.g_number
3001: ,p_pay_freq_payroll_id in number default hr_api.g_number
3002: ,p_position_transaction_id in number default hr_api.g_number
3003: ,p_prior_position_id in number default hr_api.g_number
3004: ,p_relief_position_id in number default hr_api.g_number
3005: ,p_entry_grade_id in number default hr_api.g_number
3006: ,p_successor_position_id in number default hr_api.g_number
2999: ,p_location_id in number default hr_api.g_number
3000: -- ,p_organization_id in number default hr_api.g_number
3001: ,p_pay_freq_payroll_id in number default hr_api.g_number
3002: ,p_position_transaction_id in number default hr_api.g_number
3003: ,p_prior_position_id in number default hr_api.g_number
3004: ,p_relief_position_id in number default hr_api.g_number
3005: ,p_entry_grade_id in number default hr_api.g_number
3006: ,p_successor_position_id in number default hr_api.g_number
3007: ,p_supervisor_position_id in number default hr_api.g_number
3000: -- ,p_organization_id in number default hr_api.g_number
3001: ,p_pay_freq_payroll_id in number default hr_api.g_number
3002: ,p_position_transaction_id in number default hr_api.g_number
3003: ,p_prior_position_id in number default hr_api.g_number
3004: ,p_relief_position_id in number default hr_api.g_number
3005: ,p_entry_grade_id in number default hr_api.g_number
3006: ,p_successor_position_id in number default hr_api.g_number
3007: ,p_supervisor_position_id in number default hr_api.g_number
3008: ,p_amendment_date in date default hr_api.g_date
3001: ,p_pay_freq_payroll_id in number default hr_api.g_number
3002: ,p_position_transaction_id in number default hr_api.g_number
3003: ,p_prior_position_id in number default hr_api.g_number
3004: ,p_relief_position_id in number default hr_api.g_number
3005: ,p_entry_grade_id in number default hr_api.g_number
3006: ,p_successor_position_id in number default hr_api.g_number
3007: ,p_supervisor_position_id in number default hr_api.g_number
3008: ,p_amendment_date in date default hr_api.g_date
3009: ,p_amendment_recommendation in varchar2 default hr_api.g_varchar2
3002: ,p_position_transaction_id in number default hr_api.g_number
3003: ,p_prior_position_id in number default hr_api.g_number
3004: ,p_relief_position_id in number default hr_api.g_number
3005: ,p_entry_grade_id in number default hr_api.g_number
3006: ,p_successor_position_id in number default hr_api.g_number
3007: ,p_supervisor_position_id in number default hr_api.g_number
3008: ,p_amendment_date in date default hr_api.g_date
3009: ,p_amendment_recommendation in varchar2 default hr_api.g_varchar2
3010: ,p_amendment_ref_number in varchar2 default hr_api.g_varchar2
3003: ,p_prior_position_id in number default hr_api.g_number
3004: ,p_relief_position_id in number default hr_api.g_number
3005: ,p_entry_grade_id in number default hr_api.g_number
3006: ,p_successor_position_id in number default hr_api.g_number
3007: ,p_supervisor_position_id in number default hr_api.g_number
3008: ,p_amendment_date in date default hr_api.g_date
3009: ,p_amendment_recommendation in varchar2 default hr_api.g_varchar2
3010: ,p_amendment_ref_number in varchar2 default hr_api.g_varchar2
3011: ,p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2
3004: ,p_relief_position_id in number default hr_api.g_number
3005: ,p_entry_grade_id in number default hr_api.g_number
3006: ,p_successor_position_id in number default hr_api.g_number
3007: ,p_supervisor_position_id in number default hr_api.g_number
3008: ,p_amendment_date in date default hr_api.g_date
3009: ,p_amendment_recommendation in varchar2 default hr_api.g_varchar2
3010: ,p_amendment_ref_number in varchar2 default hr_api.g_varchar2
3011: ,p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2
3012: ,p_comments in clob default hr_api.g_varchar2
3005: ,p_entry_grade_id in number default hr_api.g_number
3006: ,p_successor_position_id in number default hr_api.g_number
3007: ,p_supervisor_position_id in number default hr_api.g_number
3008: ,p_amendment_date in date default hr_api.g_date
3009: ,p_amendment_recommendation in varchar2 default hr_api.g_varchar2
3010: ,p_amendment_ref_number in varchar2 default hr_api.g_varchar2
3011: ,p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2
3012: ,p_comments in clob default hr_api.g_varchar2
3013: ,p_current_job_prop_end_date in date default hr_api.g_date
3006: ,p_successor_position_id in number default hr_api.g_number
3007: ,p_supervisor_position_id in number default hr_api.g_number
3008: ,p_amendment_date in date default hr_api.g_date
3009: ,p_amendment_recommendation in varchar2 default hr_api.g_varchar2
3010: ,p_amendment_ref_number in varchar2 default hr_api.g_varchar2
3011: ,p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2
3012: ,p_comments in clob default hr_api.g_varchar2
3013: ,p_current_job_prop_end_date in date default hr_api.g_date
3014: ,p_current_org_prop_end_date in date default hr_api.g_date
3007: ,p_supervisor_position_id in number default hr_api.g_number
3008: ,p_amendment_date in date default hr_api.g_date
3009: ,p_amendment_recommendation in varchar2 default hr_api.g_varchar2
3010: ,p_amendment_ref_number in varchar2 default hr_api.g_varchar2
3011: ,p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2
3012: ,p_comments in clob default hr_api.g_varchar2
3013: ,p_current_job_prop_end_date in date default hr_api.g_date
3014: ,p_current_org_prop_end_date in date default hr_api.g_date
3015: ,p_avail_status_prop_end_date in date default hr_api.g_date
3008: ,p_amendment_date in date default hr_api.g_date
3009: ,p_amendment_recommendation in varchar2 default hr_api.g_varchar2
3010: ,p_amendment_ref_number in varchar2 default hr_api.g_varchar2
3011: ,p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2
3012: ,p_comments in clob default hr_api.g_varchar2
3013: ,p_current_job_prop_end_date in date default hr_api.g_date
3014: ,p_current_org_prop_end_date in date default hr_api.g_date
3015: ,p_avail_status_prop_end_date in date default hr_api.g_date
3016: ,p_date_effective in date default hr_api.g_date
3009: ,p_amendment_recommendation in varchar2 default hr_api.g_varchar2
3010: ,p_amendment_ref_number in varchar2 default hr_api.g_varchar2
3011: ,p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2
3012: ,p_comments in clob default hr_api.g_varchar2
3013: ,p_current_job_prop_end_date in date default hr_api.g_date
3014: ,p_current_org_prop_end_date in date default hr_api.g_date
3015: ,p_avail_status_prop_end_date in date default hr_api.g_date
3016: ,p_date_effective in date default hr_api.g_date
3017: ,p_date_end in date default hr_api.g_date
3010: ,p_amendment_ref_number in varchar2 default hr_api.g_varchar2
3011: ,p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2
3012: ,p_comments in clob default hr_api.g_varchar2
3013: ,p_current_job_prop_end_date in date default hr_api.g_date
3014: ,p_current_org_prop_end_date in date default hr_api.g_date
3015: ,p_avail_status_prop_end_date in date default hr_api.g_date
3016: ,p_date_effective in date default hr_api.g_date
3017: ,p_date_end in date default hr_api.g_date
3018: ,p_earliest_hire_date in date default hr_api.g_date
3011: ,p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2
3012: ,p_comments in clob default hr_api.g_varchar2
3013: ,p_current_job_prop_end_date in date default hr_api.g_date
3014: ,p_current_org_prop_end_date in date default hr_api.g_date
3015: ,p_avail_status_prop_end_date in date default hr_api.g_date
3016: ,p_date_effective in date default hr_api.g_date
3017: ,p_date_end in date default hr_api.g_date
3018: ,p_earliest_hire_date in date default hr_api.g_date
3019: ,p_fill_by_date in date default hr_api.g_date
3012: ,p_comments in clob default hr_api.g_varchar2
3013: ,p_current_job_prop_end_date in date default hr_api.g_date
3014: ,p_current_org_prop_end_date in date default hr_api.g_date
3015: ,p_avail_status_prop_end_date in date default hr_api.g_date
3016: ,p_date_effective in date default hr_api.g_date
3017: ,p_date_end in date default hr_api.g_date
3018: ,p_earliest_hire_date in date default hr_api.g_date
3019: ,p_fill_by_date in date default hr_api.g_date
3020: ,p_frequency in varchar2 default hr_api.g_varchar2
3013: ,p_current_job_prop_end_date in date default hr_api.g_date
3014: ,p_current_org_prop_end_date in date default hr_api.g_date
3015: ,p_avail_status_prop_end_date in date default hr_api.g_date
3016: ,p_date_effective in date default hr_api.g_date
3017: ,p_date_end in date default hr_api.g_date
3018: ,p_earliest_hire_date in date default hr_api.g_date
3019: ,p_fill_by_date in date default hr_api.g_date
3020: ,p_frequency in varchar2 default hr_api.g_varchar2
3021: ,p_fte in number default hr_api.g_number
3014: ,p_current_org_prop_end_date in date default hr_api.g_date
3015: ,p_avail_status_prop_end_date in date default hr_api.g_date
3016: ,p_date_effective in date default hr_api.g_date
3017: ,p_date_end in date default hr_api.g_date
3018: ,p_earliest_hire_date in date default hr_api.g_date
3019: ,p_fill_by_date in date default hr_api.g_date
3020: ,p_frequency in varchar2 default hr_api.g_varchar2
3021: ,p_fte in number default hr_api.g_number
3022: ,p_max_persons in number default hr_api.g_number
3015: ,p_avail_status_prop_end_date in date default hr_api.g_date
3016: ,p_date_effective in date default hr_api.g_date
3017: ,p_date_end in date default hr_api.g_date
3018: ,p_earliest_hire_date in date default hr_api.g_date
3019: ,p_fill_by_date in date default hr_api.g_date
3020: ,p_frequency in varchar2 default hr_api.g_varchar2
3021: ,p_fte in number default hr_api.g_number
3022: ,p_max_persons in number default hr_api.g_number
3023: ,p_overlap_period in number default hr_api.g_number
3016: ,p_date_effective in date default hr_api.g_date
3017: ,p_date_end in date default hr_api.g_date
3018: ,p_earliest_hire_date in date default hr_api.g_date
3019: ,p_fill_by_date in date default hr_api.g_date
3020: ,p_frequency in varchar2 default hr_api.g_varchar2
3021: ,p_fte in number default hr_api.g_number
3022: ,p_max_persons in number default hr_api.g_number
3023: ,p_overlap_period in number default hr_api.g_number
3024: ,p_overlap_unit_cd in varchar2 default hr_api.g_varchar2
3017: ,p_date_end in date default hr_api.g_date
3018: ,p_earliest_hire_date in date default hr_api.g_date
3019: ,p_fill_by_date in date default hr_api.g_date
3020: ,p_frequency in varchar2 default hr_api.g_varchar2
3021: ,p_fte in number default hr_api.g_number
3022: ,p_max_persons in number default hr_api.g_number
3023: ,p_overlap_period in number default hr_api.g_number
3024: ,p_overlap_unit_cd in varchar2 default hr_api.g_varchar2
3025: ,p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2
3018: ,p_earliest_hire_date in date default hr_api.g_date
3019: ,p_fill_by_date in date default hr_api.g_date
3020: ,p_frequency in varchar2 default hr_api.g_varchar2
3021: ,p_fte in number default hr_api.g_number
3022: ,p_max_persons in number default hr_api.g_number
3023: ,p_overlap_period in number default hr_api.g_number
3024: ,p_overlap_unit_cd in varchar2 default hr_api.g_varchar2
3025: ,p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2
3026: ,p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2
3019: ,p_fill_by_date in date default hr_api.g_date
3020: ,p_frequency in varchar2 default hr_api.g_varchar2
3021: ,p_fte in number default hr_api.g_number
3022: ,p_max_persons in number default hr_api.g_number
3023: ,p_overlap_period in number default hr_api.g_number
3024: ,p_overlap_unit_cd in varchar2 default hr_api.g_varchar2
3025: ,p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2
3026: ,p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2
3027: ,p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2
3020: ,p_frequency in varchar2 default hr_api.g_varchar2
3021: ,p_fte in number default hr_api.g_number
3022: ,p_max_persons in number default hr_api.g_number
3023: ,p_overlap_period in number default hr_api.g_number
3024: ,p_overlap_unit_cd in varchar2 default hr_api.g_varchar2
3025: ,p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2
3026: ,p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2
3027: ,p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2
3028: ,p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2
3021: ,p_fte in number default hr_api.g_number
3022: ,p_max_persons in number default hr_api.g_number
3023: ,p_overlap_period in number default hr_api.g_number
3024: ,p_overlap_unit_cd in varchar2 default hr_api.g_varchar2
3025: ,p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2
3026: ,p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2
3027: ,p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2
3028: ,p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2
3029: ,p_position_type in varchar2 default hr_api.g_varchar2
3022: ,p_max_persons in number default hr_api.g_number
3023: ,p_overlap_period in number default hr_api.g_number
3024: ,p_overlap_unit_cd in varchar2 default hr_api.g_varchar2
3025: ,p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2
3026: ,p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2
3027: ,p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2
3028: ,p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2
3029: ,p_position_type in varchar2 default hr_api.g_varchar2
3030: ,p_posting_description in varchar2 default hr_api.g_varchar2
3023: ,p_overlap_period in number default hr_api.g_number
3024: ,p_overlap_unit_cd in varchar2 default hr_api.g_varchar2
3025: ,p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2
3026: ,p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2
3027: ,p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2
3028: ,p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2
3029: ,p_position_type in varchar2 default hr_api.g_varchar2
3030: ,p_posting_description in varchar2 default hr_api.g_varchar2
3031: ,p_probation_period in number default hr_api.g_number
3024: ,p_overlap_unit_cd in varchar2 default hr_api.g_varchar2
3025: ,p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2
3026: ,p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2
3027: ,p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2
3028: ,p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2
3029: ,p_position_type in varchar2 default hr_api.g_varchar2
3030: ,p_posting_description in varchar2 default hr_api.g_varchar2
3031: ,p_probation_period in number default hr_api.g_number
3032: ,p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2
3025: ,p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2
3026: ,p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2
3027: ,p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2
3028: ,p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2
3029: ,p_position_type in varchar2 default hr_api.g_varchar2
3030: ,p_posting_description in varchar2 default hr_api.g_varchar2
3031: ,p_probation_period in number default hr_api.g_number
3032: ,p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2
3033: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
3026: ,p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2
3027: ,p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2
3028: ,p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2
3029: ,p_position_type in varchar2 default hr_api.g_varchar2
3030: ,p_posting_description in varchar2 default hr_api.g_varchar2
3031: ,p_probation_period in number default hr_api.g_number
3032: ,p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2
3033: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
3034: ,p_review_flag in varchar2 default hr_api.g_varchar2
3027: ,p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2
3028: ,p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2
3029: ,p_position_type in varchar2 default hr_api.g_varchar2
3030: ,p_posting_description in varchar2 default hr_api.g_varchar2
3031: ,p_probation_period in number default hr_api.g_number
3032: ,p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2
3033: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
3034: ,p_review_flag in varchar2 default hr_api.g_varchar2
3035: ,p_seasonal_flag in varchar2 default hr_api.g_varchar2
3028: ,p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2
3029: ,p_position_type in varchar2 default hr_api.g_varchar2
3030: ,p_posting_description in varchar2 default hr_api.g_varchar2
3031: ,p_probation_period in number default hr_api.g_number
3032: ,p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2
3033: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
3034: ,p_review_flag in varchar2 default hr_api.g_varchar2
3035: ,p_seasonal_flag in varchar2 default hr_api.g_varchar2
3036: ,p_security_requirements in varchar2 default hr_api.g_varchar2
3029: ,p_position_type in varchar2 default hr_api.g_varchar2
3030: ,p_posting_description in varchar2 default hr_api.g_varchar2
3031: ,p_probation_period in number default hr_api.g_number
3032: ,p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2
3033: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
3034: ,p_review_flag in varchar2 default hr_api.g_varchar2
3035: ,p_seasonal_flag in varchar2 default hr_api.g_varchar2
3036: ,p_security_requirements in varchar2 default hr_api.g_varchar2
3037: ,p_status in varchar2 default hr_api.g_varchar2
3030: ,p_posting_description in varchar2 default hr_api.g_varchar2
3031: ,p_probation_period in number default hr_api.g_number
3032: ,p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2
3033: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
3034: ,p_review_flag in varchar2 default hr_api.g_varchar2
3035: ,p_seasonal_flag in varchar2 default hr_api.g_varchar2
3036: ,p_security_requirements in varchar2 default hr_api.g_varchar2
3037: ,p_status in varchar2 default hr_api.g_varchar2
3038: ,p_term_start_day_cd in varchar2 default hr_api.g_varchar2
3031: ,p_probation_period in number default hr_api.g_number
3032: ,p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2
3033: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
3034: ,p_review_flag in varchar2 default hr_api.g_varchar2
3035: ,p_seasonal_flag in varchar2 default hr_api.g_varchar2
3036: ,p_security_requirements in varchar2 default hr_api.g_varchar2
3037: ,p_status in varchar2 default hr_api.g_varchar2
3038: ,p_term_start_day_cd in varchar2 default hr_api.g_varchar2
3039: ,p_term_start_month_cd in varchar2 default hr_api.g_varchar2
3032: ,p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2
3033: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
3034: ,p_review_flag in varchar2 default hr_api.g_varchar2
3035: ,p_seasonal_flag in varchar2 default hr_api.g_varchar2
3036: ,p_security_requirements in varchar2 default hr_api.g_varchar2
3037: ,p_status in varchar2 default hr_api.g_varchar2
3038: ,p_term_start_day_cd in varchar2 default hr_api.g_varchar2
3039: ,p_term_start_month_cd in varchar2 default hr_api.g_varchar2
3040: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
3033: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
3034: ,p_review_flag in varchar2 default hr_api.g_varchar2
3035: ,p_seasonal_flag in varchar2 default hr_api.g_varchar2
3036: ,p_security_requirements in varchar2 default hr_api.g_varchar2
3037: ,p_status in varchar2 default hr_api.g_varchar2
3038: ,p_term_start_day_cd in varchar2 default hr_api.g_varchar2
3039: ,p_term_start_month_cd in varchar2 default hr_api.g_varchar2
3040: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
3041: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
3034: ,p_review_flag in varchar2 default hr_api.g_varchar2
3035: ,p_seasonal_flag in varchar2 default hr_api.g_varchar2
3036: ,p_security_requirements in varchar2 default hr_api.g_varchar2
3037: ,p_status in varchar2 default hr_api.g_varchar2
3038: ,p_term_start_day_cd in varchar2 default hr_api.g_varchar2
3039: ,p_term_start_month_cd in varchar2 default hr_api.g_varchar2
3040: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
3041: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
3042: ,p_update_source_cd in varchar2 default hr_api.g_varchar2
3035: ,p_seasonal_flag in varchar2 default hr_api.g_varchar2
3036: ,p_security_requirements in varchar2 default hr_api.g_varchar2
3037: ,p_status in varchar2 default hr_api.g_varchar2
3038: ,p_term_start_day_cd in varchar2 default hr_api.g_varchar2
3039: ,p_term_start_month_cd in varchar2 default hr_api.g_varchar2
3040: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
3041: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
3042: ,p_update_source_cd in varchar2 default hr_api.g_varchar2
3043: ,p_working_hours in number default hr_api.g_number
3036: ,p_security_requirements in varchar2 default hr_api.g_varchar2
3037: ,p_status in varchar2 default hr_api.g_varchar2
3038: ,p_term_start_day_cd in varchar2 default hr_api.g_varchar2
3039: ,p_term_start_month_cd in varchar2 default hr_api.g_varchar2
3040: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
3041: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
3042: ,p_update_source_cd in varchar2 default hr_api.g_varchar2
3043: ,p_working_hours in number default hr_api.g_number
3044: ,p_works_council_approval_flag in varchar2 default hr_api.g_varchar2
3037: ,p_status in varchar2 default hr_api.g_varchar2
3038: ,p_term_start_day_cd in varchar2 default hr_api.g_varchar2
3039: ,p_term_start_month_cd in varchar2 default hr_api.g_varchar2
3040: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
3041: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
3042: ,p_update_source_cd in varchar2 default hr_api.g_varchar2
3043: ,p_working_hours in number default hr_api.g_number
3044: ,p_works_council_approval_flag in varchar2 default hr_api.g_varchar2
3045: ,p_work_period_type_cd in varchar2 default hr_api.g_varchar2
3038: ,p_term_start_day_cd in varchar2 default hr_api.g_varchar2
3039: ,p_term_start_month_cd in varchar2 default hr_api.g_varchar2
3040: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
3041: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
3042: ,p_update_source_cd in varchar2 default hr_api.g_varchar2
3043: ,p_working_hours in number default hr_api.g_number
3044: ,p_works_council_approval_flag in varchar2 default hr_api.g_varchar2
3045: ,p_work_period_type_cd in varchar2 default hr_api.g_varchar2
3046: ,p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2
3039: ,p_term_start_month_cd in varchar2 default hr_api.g_varchar2
3040: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
3041: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
3042: ,p_update_source_cd in varchar2 default hr_api.g_varchar2
3043: ,p_working_hours in number default hr_api.g_number
3044: ,p_works_council_approval_flag in varchar2 default hr_api.g_varchar2
3045: ,p_work_period_type_cd in varchar2 default hr_api.g_varchar2
3046: ,p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2
3047: ,p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2
3040: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
3041: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
3042: ,p_update_source_cd in varchar2 default hr_api.g_varchar2
3043: ,p_working_hours in number default hr_api.g_number
3044: ,p_works_council_approval_flag in varchar2 default hr_api.g_varchar2
3045: ,p_work_period_type_cd in varchar2 default hr_api.g_varchar2
3046: ,p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2
3047: ,p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2
3048: ,p_proposed_fte_for_layoff in number default hr_api.g_number
3041: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
3042: ,p_update_source_cd in varchar2 default hr_api.g_varchar2
3043: ,p_working_hours in number default hr_api.g_number
3044: ,p_works_council_approval_flag in varchar2 default hr_api.g_varchar2
3045: ,p_work_period_type_cd in varchar2 default hr_api.g_varchar2
3046: ,p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2
3047: ,p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2
3048: ,p_proposed_fte_for_layoff in number default hr_api.g_number
3049: ,p_proposed_date_for_layoff in date default hr_api.g_date
3042: ,p_update_source_cd in varchar2 default hr_api.g_varchar2
3043: ,p_working_hours in number default hr_api.g_number
3044: ,p_works_council_approval_flag in varchar2 default hr_api.g_varchar2
3045: ,p_work_period_type_cd in varchar2 default hr_api.g_varchar2
3046: ,p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2
3047: ,p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2
3048: ,p_proposed_fte_for_layoff in number default hr_api.g_number
3049: ,p_proposed_date_for_layoff in date default hr_api.g_date
3050: ,p_pay_basis_id in number default hr_api.g_number
3043: ,p_working_hours in number default hr_api.g_number
3044: ,p_works_council_approval_flag in varchar2 default hr_api.g_varchar2
3045: ,p_work_period_type_cd in varchar2 default hr_api.g_varchar2
3046: ,p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2
3047: ,p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2
3048: ,p_proposed_fte_for_layoff in number default hr_api.g_number
3049: ,p_proposed_date_for_layoff in date default hr_api.g_date
3050: ,p_pay_basis_id in number default hr_api.g_number
3051: ,p_supervisor_id in number default hr_api.g_number
3044: ,p_works_council_approval_flag in varchar2 default hr_api.g_varchar2
3045: ,p_work_period_type_cd in varchar2 default hr_api.g_varchar2
3046: ,p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2
3047: ,p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2
3048: ,p_proposed_fte_for_layoff in number default hr_api.g_number
3049: ,p_proposed_date_for_layoff in date default hr_api.g_date
3050: ,p_pay_basis_id in number default hr_api.g_number
3051: ,p_supervisor_id in number default hr_api.g_number
3052: --,p_copied_to_old_table_flag in varchar2 default hr_api.g_varchar2
3045: ,p_work_period_type_cd in varchar2 default hr_api.g_varchar2
3046: ,p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2
3047: ,p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2
3048: ,p_proposed_fte_for_layoff in number default hr_api.g_number
3049: ,p_proposed_date_for_layoff in date default hr_api.g_date
3050: ,p_pay_basis_id in number default hr_api.g_number
3051: ,p_supervisor_id in number default hr_api.g_number
3052: --,p_copied_to_old_table_flag in varchar2 default hr_api.g_varchar2
3053: ,p_information1 in varchar2 default hr_api.g_varchar2
3046: ,p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2
3047: ,p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2
3048: ,p_proposed_fte_for_layoff in number default hr_api.g_number
3049: ,p_proposed_date_for_layoff in date default hr_api.g_date
3050: ,p_pay_basis_id in number default hr_api.g_number
3051: ,p_supervisor_id in number default hr_api.g_number
3052: --,p_copied_to_old_table_flag in varchar2 default hr_api.g_varchar2
3053: ,p_information1 in varchar2 default hr_api.g_varchar2
3054: ,p_information2 in varchar2 default hr_api.g_varchar2
3047: ,p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2
3048: ,p_proposed_fte_for_layoff in number default hr_api.g_number
3049: ,p_proposed_date_for_layoff in date default hr_api.g_date
3050: ,p_pay_basis_id in number default hr_api.g_number
3051: ,p_supervisor_id in number default hr_api.g_number
3052: --,p_copied_to_old_table_flag in varchar2 default hr_api.g_varchar2
3053: ,p_information1 in varchar2 default hr_api.g_varchar2
3054: ,p_information2 in varchar2 default hr_api.g_varchar2
3055: ,p_information3 in varchar2 default hr_api.g_varchar2
3048: ,p_proposed_fte_for_layoff in number default hr_api.g_number
3049: ,p_proposed_date_for_layoff in date default hr_api.g_date
3050: ,p_pay_basis_id in number default hr_api.g_number
3051: ,p_supervisor_id in number default hr_api.g_number
3052: --,p_copied_to_old_table_flag in varchar2 default hr_api.g_varchar2
3053: ,p_information1 in varchar2 default hr_api.g_varchar2
3054: ,p_information2 in varchar2 default hr_api.g_varchar2
3055: ,p_information3 in varchar2 default hr_api.g_varchar2
3056: ,p_information4 in varchar2 default hr_api.g_varchar2
3049: ,p_proposed_date_for_layoff in date default hr_api.g_date
3050: ,p_pay_basis_id in number default hr_api.g_number
3051: ,p_supervisor_id in number default hr_api.g_number
3052: --,p_copied_to_old_table_flag in varchar2 default hr_api.g_varchar2
3053: ,p_information1 in varchar2 default hr_api.g_varchar2
3054: ,p_information2 in varchar2 default hr_api.g_varchar2
3055: ,p_information3 in varchar2 default hr_api.g_varchar2
3056: ,p_information4 in varchar2 default hr_api.g_varchar2
3057: ,p_information5 in varchar2 default hr_api.g_varchar2
3050: ,p_pay_basis_id in number default hr_api.g_number
3051: ,p_supervisor_id in number default hr_api.g_number
3052: --,p_copied_to_old_table_flag in varchar2 default hr_api.g_varchar2
3053: ,p_information1 in varchar2 default hr_api.g_varchar2
3054: ,p_information2 in varchar2 default hr_api.g_varchar2
3055: ,p_information3 in varchar2 default hr_api.g_varchar2
3056: ,p_information4 in varchar2 default hr_api.g_varchar2
3057: ,p_information5 in varchar2 default hr_api.g_varchar2
3058: ,p_information6 in varchar2 default hr_api.g_varchar2
3051: ,p_supervisor_id in number default hr_api.g_number
3052: --,p_copied_to_old_table_flag in varchar2 default hr_api.g_varchar2
3053: ,p_information1 in varchar2 default hr_api.g_varchar2
3054: ,p_information2 in varchar2 default hr_api.g_varchar2
3055: ,p_information3 in varchar2 default hr_api.g_varchar2
3056: ,p_information4 in varchar2 default hr_api.g_varchar2
3057: ,p_information5 in varchar2 default hr_api.g_varchar2
3058: ,p_information6 in varchar2 default hr_api.g_varchar2
3059: ,p_information7 in varchar2 default hr_api.g_varchar2
3052: --,p_copied_to_old_table_flag in varchar2 default hr_api.g_varchar2
3053: ,p_information1 in varchar2 default hr_api.g_varchar2
3054: ,p_information2 in varchar2 default hr_api.g_varchar2
3055: ,p_information3 in varchar2 default hr_api.g_varchar2
3056: ,p_information4 in varchar2 default hr_api.g_varchar2
3057: ,p_information5 in varchar2 default hr_api.g_varchar2
3058: ,p_information6 in varchar2 default hr_api.g_varchar2
3059: ,p_information7 in varchar2 default hr_api.g_varchar2
3060: ,p_information8 in varchar2 default hr_api.g_varchar2
3053: ,p_information1 in varchar2 default hr_api.g_varchar2
3054: ,p_information2 in varchar2 default hr_api.g_varchar2
3055: ,p_information3 in varchar2 default hr_api.g_varchar2
3056: ,p_information4 in varchar2 default hr_api.g_varchar2
3057: ,p_information5 in varchar2 default hr_api.g_varchar2
3058: ,p_information6 in varchar2 default hr_api.g_varchar2
3059: ,p_information7 in varchar2 default hr_api.g_varchar2
3060: ,p_information8 in varchar2 default hr_api.g_varchar2
3061: ,p_information9 in varchar2 default hr_api.g_varchar2
3054: ,p_information2 in varchar2 default hr_api.g_varchar2
3055: ,p_information3 in varchar2 default hr_api.g_varchar2
3056: ,p_information4 in varchar2 default hr_api.g_varchar2
3057: ,p_information5 in varchar2 default hr_api.g_varchar2
3058: ,p_information6 in varchar2 default hr_api.g_varchar2
3059: ,p_information7 in varchar2 default hr_api.g_varchar2
3060: ,p_information8 in varchar2 default hr_api.g_varchar2
3061: ,p_information9 in varchar2 default hr_api.g_varchar2
3062: ,p_information10 in varchar2 default hr_api.g_varchar2
3055: ,p_information3 in varchar2 default hr_api.g_varchar2
3056: ,p_information4 in varchar2 default hr_api.g_varchar2
3057: ,p_information5 in varchar2 default hr_api.g_varchar2
3058: ,p_information6 in varchar2 default hr_api.g_varchar2
3059: ,p_information7 in varchar2 default hr_api.g_varchar2
3060: ,p_information8 in varchar2 default hr_api.g_varchar2
3061: ,p_information9 in varchar2 default hr_api.g_varchar2
3062: ,p_information10 in varchar2 default hr_api.g_varchar2
3063: ,p_information11 in varchar2 default hr_api.g_varchar2
3056: ,p_information4 in varchar2 default hr_api.g_varchar2
3057: ,p_information5 in varchar2 default hr_api.g_varchar2
3058: ,p_information6 in varchar2 default hr_api.g_varchar2
3059: ,p_information7 in varchar2 default hr_api.g_varchar2
3060: ,p_information8 in varchar2 default hr_api.g_varchar2
3061: ,p_information9 in varchar2 default hr_api.g_varchar2
3062: ,p_information10 in varchar2 default hr_api.g_varchar2
3063: ,p_information11 in varchar2 default hr_api.g_varchar2
3064: ,p_information12 in varchar2 default hr_api.g_varchar2
3057: ,p_information5 in varchar2 default hr_api.g_varchar2
3058: ,p_information6 in varchar2 default hr_api.g_varchar2
3059: ,p_information7 in varchar2 default hr_api.g_varchar2
3060: ,p_information8 in varchar2 default hr_api.g_varchar2
3061: ,p_information9 in varchar2 default hr_api.g_varchar2
3062: ,p_information10 in varchar2 default hr_api.g_varchar2
3063: ,p_information11 in varchar2 default hr_api.g_varchar2
3064: ,p_information12 in varchar2 default hr_api.g_varchar2
3065: ,p_information13 in varchar2 default hr_api.g_varchar2
3058: ,p_information6 in varchar2 default hr_api.g_varchar2
3059: ,p_information7 in varchar2 default hr_api.g_varchar2
3060: ,p_information8 in varchar2 default hr_api.g_varchar2
3061: ,p_information9 in varchar2 default hr_api.g_varchar2
3062: ,p_information10 in varchar2 default hr_api.g_varchar2
3063: ,p_information11 in varchar2 default hr_api.g_varchar2
3064: ,p_information12 in varchar2 default hr_api.g_varchar2
3065: ,p_information13 in varchar2 default hr_api.g_varchar2
3066: ,p_information14 in varchar2 default hr_api.g_varchar2
3059: ,p_information7 in varchar2 default hr_api.g_varchar2
3060: ,p_information8 in varchar2 default hr_api.g_varchar2
3061: ,p_information9 in varchar2 default hr_api.g_varchar2
3062: ,p_information10 in varchar2 default hr_api.g_varchar2
3063: ,p_information11 in varchar2 default hr_api.g_varchar2
3064: ,p_information12 in varchar2 default hr_api.g_varchar2
3065: ,p_information13 in varchar2 default hr_api.g_varchar2
3066: ,p_information14 in varchar2 default hr_api.g_varchar2
3067: ,p_information15 in varchar2 default hr_api.g_varchar2
3060: ,p_information8 in varchar2 default hr_api.g_varchar2
3061: ,p_information9 in varchar2 default hr_api.g_varchar2
3062: ,p_information10 in varchar2 default hr_api.g_varchar2
3063: ,p_information11 in varchar2 default hr_api.g_varchar2
3064: ,p_information12 in varchar2 default hr_api.g_varchar2
3065: ,p_information13 in varchar2 default hr_api.g_varchar2
3066: ,p_information14 in varchar2 default hr_api.g_varchar2
3067: ,p_information15 in varchar2 default hr_api.g_varchar2
3068: ,p_information16 in varchar2 default hr_api.g_varchar2
3061: ,p_information9 in varchar2 default hr_api.g_varchar2
3062: ,p_information10 in varchar2 default hr_api.g_varchar2
3063: ,p_information11 in varchar2 default hr_api.g_varchar2
3064: ,p_information12 in varchar2 default hr_api.g_varchar2
3065: ,p_information13 in varchar2 default hr_api.g_varchar2
3066: ,p_information14 in varchar2 default hr_api.g_varchar2
3067: ,p_information15 in varchar2 default hr_api.g_varchar2
3068: ,p_information16 in varchar2 default hr_api.g_varchar2
3069: ,p_information17 in varchar2 default hr_api.g_varchar2
3062: ,p_information10 in varchar2 default hr_api.g_varchar2
3063: ,p_information11 in varchar2 default hr_api.g_varchar2
3064: ,p_information12 in varchar2 default hr_api.g_varchar2
3065: ,p_information13 in varchar2 default hr_api.g_varchar2
3066: ,p_information14 in varchar2 default hr_api.g_varchar2
3067: ,p_information15 in varchar2 default hr_api.g_varchar2
3068: ,p_information16 in varchar2 default hr_api.g_varchar2
3069: ,p_information17 in varchar2 default hr_api.g_varchar2
3070: ,p_information18 in varchar2 default hr_api.g_varchar2
3063: ,p_information11 in varchar2 default hr_api.g_varchar2
3064: ,p_information12 in varchar2 default hr_api.g_varchar2
3065: ,p_information13 in varchar2 default hr_api.g_varchar2
3066: ,p_information14 in varchar2 default hr_api.g_varchar2
3067: ,p_information15 in varchar2 default hr_api.g_varchar2
3068: ,p_information16 in varchar2 default hr_api.g_varchar2
3069: ,p_information17 in varchar2 default hr_api.g_varchar2
3070: ,p_information18 in varchar2 default hr_api.g_varchar2
3071: ,p_information19 in varchar2 default hr_api.g_varchar2
3064: ,p_information12 in varchar2 default hr_api.g_varchar2
3065: ,p_information13 in varchar2 default hr_api.g_varchar2
3066: ,p_information14 in varchar2 default hr_api.g_varchar2
3067: ,p_information15 in varchar2 default hr_api.g_varchar2
3068: ,p_information16 in varchar2 default hr_api.g_varchar2
3069: ,p_information17 in varchar2 default hr_api.g_varchar2
3070: ,p_information18 in varchar2 default hr_api.g_varchar2
3071: ,p_information19 in varchar2 default hr_api.g_varchar2
3072: ,p_information20 in varchar2 default hr_api.g_varchar2
3065: ,p_information13 in varchar2 default hr_api.g_varchar2
3066: ,p_information14 in varchar2 default hr_api.g_varchar2
3067: ,p_information15 in varchar2 default hr_api.g_varchar2
3068: ,p_information16 in varchar2 default hr_api.g_varchar2
3069: ,p_information17 in varchar2 default hr_api.g_varchar2
3070: ,p_information18 in varchar2 default hr_api.g_varchar2
3071: ,p_information19 in varchar2 default hr_api.g_varchar2
3072: ,p_information20 in varchar2 default hr_api.g_varchar2
3073: ,p_information21 in varchar2 default hr_api.g_varchar2
3066: ,p_information14 in varchar2 default hr_api.g_varchar2
3067: ,p_information15 in varchar2 default hr_api.g_varchar2
3068: ,p_information16 in varchar2 default hr_api.g_varchar2
3069: ,p_information17 in varchar2 default hr_api.g_varchar2
3070: ,p_information18 in varchar2 default hr_api.g_varchar2
3071: ,p_information19 in varchar2 default hr_api.g_varchar2
3072: ,p_information20 in varchar2 default hr_api.g_varchar2
3073: ,p_information21 in varchar2 default hr_api.g_varchar2
3074: ,p_information22 in varchar2 default hr_api.g_varchar2
3067: ,p_information15 in varchar2 default hr_api.g_varchar2
3068: ,p_information16 in varchar2 default hr_api.g_varchar2
3069: ,p_information17 in varchar2 default hr_api.g_varchar2
3070: ,p_information18 in varchar2 default hr_api.g_varchar2
3071: ,p_information19 in varchar2 default hr_api.g_varchar2
3072: ,p_information20 in varchar2 default hr_api.g_varchar2
3073: ,p_information21 in varchar2 default hr_api.g_varchar2
3074: ,p_information22 in varchar2 default hr_api.g_varchar2
3075: ,p_information23 in varchar2 default hr_api.g_varchar2
3068: ,p_information16 in varchar2 default hr_api.g_varchar2
3069: ,p_information17 in varchar2 default hr_api.g_varchar2
3070: ,p_information18 in varchar2 default hr_api.g_varchar2
3071: ,p_information19 in varchar2 default hr_api.g_varchar2
3072: ,p_information20 in varchar2 default hr_api.g_varchar2
3073: ,p_information21 in varchar2 default hr_api.g_varchar2
3074: ,p_information22 in varchar2 default hr_api.g_varchar2
3075: ,p_information23 in varchar2 default hr_api.g_varchar2
3076: ,p_information24 in varchar2 default hr_api.g_varchar2
3069: ,p_information17 in varchar2 default hr_api.g_varchar2
3070: ,p_information18 in varchar2 default hr_api.g_varchar2
3071: ,p_information19 in varchar2 default hr_api.g_varchar2
3072: ,p_information20 in varchar2 default hr_api.g_varchar2
3073: ,p_information21 in varchar2 default hr_api.g_varchar2
3074: ,p_information22 in varchar2 default hr_api.g_varchar2
3075: ,p_information23 in varchar2 default hr_api.g_varchar2
3076: ,p_information24 in varchar2 default hr_api.g_varchar2
3077: ,p_information25 in varchar2 default hr_api.g_varchar2
3070: ,p_information18 in varchar2 default hr_api.g_varchar2
3071: ,p_information19 in varchar2 default hr_api.g_varchar2
3072: ,p_information20 in varchar2 default hr_api.g_varchar2
3073: ,p_information21 in varchar2 default hr_api.g_varchar2
3074: ,p_information22 in varchar2 default hr_api.g_varchar2
3075: ,p_information23 in varchar2 default hr_api.g_varchar2
3076: ,p_information24 in varchar2 default hr_api.g_varchar2
3077: ,p_information25 in varchar2 default hr_api.g_varchar2
3078: ,p_information26 in varchar2 default hr_api.g_varchar2
3071: ,p_information19 in varchar2 default hr_api.g_varchar2
3072: ,p_information20 in varchar2 default hr_api.g_varchar2
3073: ,p_information21 in varchar2 default hr_api.g_varchar2
3074: ,p_information22 in varchar2 default hr_api.g_varchar2
3075: ,p_information23 in varchar2 default hr_api.g_varchar2
3076: ,p_information24 in varchar2 default hr_api.g_varchar2
3077: ,p_information25 in varchar2 default hr_api.g_varchar2
3078: ,p_information26 in varchar2 default hr_api.g_varchar2
3079: ,p_information27 in varchar2 default hr_api.g_varchar2
3072: ,p_information20 in varchar2 default hr_api.g_varchar2
3073: ,p_information21 in varchar2 default hr_api.g_varchar2
3074: ,p_information22 in varchar2 default hr_api.g_varchar2
3075: ,p_information23 in varchar2 default hr_api.g_varchar2
3076: ,p_information24 in varchar2 default hr_api.g_varchar2
3077: ,p_information25 in varchar2 default hr_api.g_varchar2
3078: ,p_information26 in varchar2 default hr_api.g_varchar2
3079: ,p_information27 in varchar2 default hr_api.g_varchar2
3080: ,p_information28 in varchar2 default hr_api.g_varchar2
3073: ,p_information21 in varchar2 default hr_api.g_varchar2
3074: ,p_information22 in varchar2 default hr_api.g_varchar2
3075: ,p_information23 in varchar2 default hr_api.g_varchar2
3076: ,p_information24 in varchar2 default hr_api.g_varchar2
3077: ,p_information25 in varchar2 default hr_api.g_varchar2
3078: ,p_information26 in varchar2 default hr_api.g_varchar2
3079: ,p_information27 in varchar2 default hr_api.g_varchar2
3080: ,p_information28 in varchar2 default hr_api.g_varchar2
3081: ,p_information29 in varchar2 default hr_api.g_varchar2
3074: ,p_information22 in varchar2 default hr_api.g_varchar2
3075: ,p_information23 in varchar2 default hr_api.g_varchar2
3076: ,p_information24 in varchar2 default hr_api.g_varchar2
3077: ,p_information25 in varchar2 default hr_api.g_varchar2
3078: ,p_information26 in varchar2 default hr_api.g_varchar2
3079: ,p_information27 in varchar2 default hr_api.g_varchar2
3080: ,p_information28 in varchar2 default hr_api.g_varchar2
3081: ,p_information29 in varchar2 default hr_api.g_varchar2
3082: ,p_information30 in varchar2 default hr_api.g_varchar2
3075: ,p_information23 in varchar2 default hr_api.g_varchar2
3076: ,p_information24 in varchar2 default hr_api.g_varchar2
3077: ,p_information25 in varchar2 default hr_api.g_varchar2
3078: ,p_information26 in varchar2 default hr_api.g_varchar2
3079: ,p_information27 in varchar2 default hr_api.g_varchar2
3080: ,p_information28 in varchar2 default hr_api.g_varchar2
3081: ,p_information29 in varchar2 default hr_api.g_varchar2
3082: ,p_information30 in varchar2 default hr_api.g_varchar2
3083: ,p_information_category in varchar2 default hr_api.g_varchar2
3076: ,p_information24 in varchar2 default hr_api.g_varchar2
3077: ,p_information25 in varchar2 default hr_api.g_varchar2
3078: ,p_information26 in varchar2 default hr_api.g_varchar2
3079: ,p_information27 in varchar2 default hr_api.g_varchar2
3080: ,p_information28 in varchar2 default hr_api.g_varchar2
3081: ,p_information29 in varchar2 default hr_api.g_varchar2
3082: ,p_information30 in varchar2 default hr_api.g_varchar2
3083: ,p_information_category in varchar2 default hr_api.g_varchar2
3084: ,p_attribute1 in varchar2 default hr_api.g_varchar2
3077: ,p_information25 in varchar2 default hr_api.g_varchar2
3078: ,p_information26 in varchar2 default hr_api.g_varchar2
3079: ,p_information27 in varchar2 default hr_api.g_varchar2
3080: ,p_information28 in varchar2 default hr_api.g_varchar2
3081: ,p_information29 in varchar2 default hr_api.g_varchar2
3082: ,p_information30 in varchar2 default hr_api.g_varchar2
3083: ,p_information_category in varchar2 default hr_api.g_varchar2
3084: ,p_attribute1 in varchar2 default hr_api.g_varchar2
3085: ,p_attribute2 in varchar2 default hr_api.g_varchar2
3078: ,p_information26 in varchar2 default hr_api.g_varchar2
3079: ,p_information27 in varchar2 default hr_api.g_varchar2
3080: ,p_information28 in varchar2 default hr_api.g_varchar2
3081: ,p_information29 in varchar2 default hr_api.g_varchar2
3082: ,p_information30 in varchar2 default hr_api.g_varchar2
3083: ,p_information_category in varchar2 default hr_api.g_varchar2
3084: ,p_attribute1 in varchar2 default hr_api.g_varchar2
3085: ,p_attribute2 in varchar2 default hr_api.g_varchar2
3086: ,p_attribute3 in varchar2 default hr_api.g_varchar2
3079: ,p_information27 in varchar2 default hr_api.g_varchar2
3080: ,p_information28 in varchar2 default hr_api.g_varchar2
3081: ,p_information29 in varchar2 default hr_api.g_varchar2
3082: ,p_information30 in varchar2 default hr_api.g_varchar2
3083: ,p_information_category in varchar2 default hr_api.g_varchar2
3084: ,p_attribute1 in varchar2 default hr_api.g_varchar2
3085: ,p_attribute2 in varchar2 default hr_api.g_varchar2
3086: ,p_attribute3 in varchar2 default hr_api.g_varchar2
3087: ,p_attribute4 in varchar2 default hr_api.g_varchar2
3080: ,p_information28 in varchar2 default hr_api.g_varchar2
3081: ,p_information29 in varchar2 default hr_api.g_varchar2
3082: ,p_information30 in varchar2 default hr_api.g_varchar2
3083: ,p_information_category in varchar2 default hr_api.g_varchar2
3084: ,p_attribute1 in varchar2 default hr_api.g_varchar2
3085: ,p_attribute2 in varchar2 default hr_api.g_varchar2
3086: ,p_attribute3 in varchar2 default hr_api.g_varchar2
3087: ,p_attribute4 in varchar2 default hr_api.g_varchar2
3088: ,p_attribute5 in varchar2 default hr_api.g_varchar2
3081: ,p_information29 in varchar2 default hr_api.g_varchar2
3082: ,p_information30 in varchar2 default hr_api.g_varchar2
3083: ,p_information_category in varchar2 default hr_api.g_varchar2
3084: ,p_attribute1 in varchar2 default hr_api.g_varchar2
3085: ,p_attribute2 in varchar2 default hr_api.g_varchar2
3086: ,p_attribute3 in varchar2 default hr_api.g_varchar2
3087: ,p_attribute4 in varchar2 default hr_api.g_varchar2
3088: ,p_attribute5 in varchar2 default hr_api.g_varchar2
3089: ,p_attribute6 in varchar2 default hr_api.g_varchar2
3082: ,p_information30 in varchar2 default hr_api.g_varchar2
3083: ,p_information_category in varchar2 default hr_api.g_varchar2
3084: ,p_attribute1 in varchar2 default hr_api.g_varchar2
3085: ,p_attribute2 in varchar2 default hr_api.g_varchar2
3086: ,p_attribute3 in varchar2 default hr_api.g_varchar2
3087: ,p_attribute4 in varchar2 default hr_api.g_varchar2
3088: ,p_attribute5 in varchar2 default hr_api.g_varchar2
3089: ,p_attribute6 in varchar2 default hr_api.g_varchar2
3090: ,p_attribute7 in varchar2 default hr_api.g_varchar2
3083: ,p_information_category in varchar2 default hr_api.g_varchar2
3084: ,p_attribute1 in varchar2 default hr_api.g_varchar2
3085: ,p_attribute2 in varchar2 default hr_api.g_varchar2
3086: ,p_attribute3 in varchar2 default hr_api.g_varchar2
3087: ,p_attribute4 in varchar2 default hr_api.g_varchar2
3088: ,p_attribute5 in varchar2 default hr_api.g_varchar2
3089: ,p_attribute6 in varchar2 default hr_api.g_varchar2
3090: ,p_attribute7 in varchar2 default hr_api.g_varchar2
3091: ,p_attribute8 in varchar2 default hr_api.g_varchar2
3084: ,p_attribute1 in varchar2 default hr_api.g_varchar2
3085: ,p_attribute2 in varchar2 default hr_api.g_varchar2
3086: ,p_attribute3 in varchar2 default hr_api.g_varchar2
3087: ,p_attribute4 in varchar2 default hr_api.g_varchar2
3088: ,p_attribute5 in varchar2 default hr_api.g_varchar2
3089: ,p_attribute6 in varchar2 default hr_api.g_varchar2
3090: ,p_attribute7 in varchar2 default hr_api.g_varchar2
3091: ,p_attribute8 in varchar2 default hr_api.g_varchar2
3092: ,p_attribute9 in varchar2 default hr_api.g_varchar2
3085: ,p_attribute2 in varchar2 default hr_api.g_varchar2
3086: ,p_attribute3 in varchar2 default hr_api.g_varchar2
3087: ,p_attribute4 in varchar2 default hr_api.g_varchar2
3088: ,p_attribute5 in varchar2 default hr_api.g_varchar2
3089: ,p_attribute6 in varchar2 default hr_api.g_varchar2
3090: ,p_attribute7 in varchar2 default hr_api.g_varchar2
3091: ,p_attribute8 in varchar2 default hr_api.g_varchar2
3092: ,p_attribute9 in varchar2 default hr_api.g_varchar2
3093: ,p_attribute10 in varchar2 default hr_api.g_varchar2
3086: ,p_attribute3 in varchar2 default hr_api.g_varchar2
3087: ,p_attribute4 in varchar2 default hr_api.g_varchar2
3088: ,p_attribute5 in varchar2 default hr_api.g_varchar2
3089: ,p_attribute6 in varchar2 default hr_api.g_varchar2
3090: ,p_attribute7 in varchar2 default hr_api.g_varchar2
3091: ,p_attribute8 in varchar2 default hr_api.g_varchar2
3092: ,p_attribute9 in varchar2 default hr_api.g_varchar2
3093: ,p_attribute10 in varchar2 default hr_api.g_varchar2
3094: ,p_attribute11 in varchar2 default hr_api.g_varchar2
3087: ,p_attribute4 in varchar2 default hr_api.g_varchar2
3088: ,p_attribute5 in varchar2 default hr_api.g_varchar2
3089: ,p_attribute6 in varchar2 default hr_api.g_varchar2
3090: ,p_attribute7 in varchar2 default hr_api.g_varchar2
3091: ,p_attribute8 in varchar2 default hr_api.g_varchar2
3092: ,p_attribute9 in varchar2 default hr_api.g_varchar2
3093: ,p_attribute10 in varchar2 default hr_api.g_varchar2
3094: ,p_attribute11 in varchar2 default hr_api.g_varchar2
3095: ,p_attribute12 in varchar2 default hr_api.g_varchar2
3088: ,p_attribute5 in varchar2 default hr_api.g_varchar2
3089: ,p_attribute6 in varchar2 default hr_api.g_varchar2
3090: ,p_attribute7 in varchar2 default hr_api.g_varchar2
3091: ,p_attribute8 in varchar2 default hr_api.g_varchar2
3092: ,p_attribute9 in varchar2 default hr_api.g_varchar2
3093: ,p_attribute10 in varchar2 default hr_api.g_varchar2
3094: ,p_attribute11 in varchar2 default hr_api.g_varchar2
3095: ,p_attribute12 in varchar2 default hr_api.g_varchar2
3096: ,p_attribute13 in varchar2 default hr_api.g_varchar2
3089: ,p_attribute6 in varchar2 default hr_api.g_varchar2
3090: ,p_attribute7 in varchar2 default hr_api.g_varchar2
3091: ,p_attribute8 in varchar2 default hr_api.g_varchar2
3092: ,p_attribute9 in varchar2 default hr_api.g_varchar2
3093: ,p_attribute10 in varchar2 default hr_api.g_varchar2
3094: ,p_attribute11 in varchar2 default hr_api.g_varchar2
3095: ,p_attribute12 in varchar2 default hr_api.g_varchar2
3096: ,p_attribute13 in varchar2 default hr_api.g_varchar2
3097: ,p_attribute14 in varchar2 default hr_api.g_varchar2
3090: ,p_attribute7 in varchar2 default hr_api.g_varchar2
3091: ,p_attribute8 in varchar2 default hr_api.g_varchar2
3092: ,p_attribute9 in varchar2 default hr_api.g_varchar2
3093: ,p_attribute10 in varchar2 default hr_api.g_varchar2
3094: ,p_attribute11 in varchar2 default hr_api.g_varchar2
3095: ,p_attribute12 in varchar2 default hr_api.g_varchar2
3096: ,p_attribute13 in varchar2 default hr_api.g_varchar2
3097: ,p_attribute14 in varchar2 default hr_api.g_varchar2
3098: ,p_attribute15 in varchar2 default hr_api.g_varchar2
3091: ,p_attribute8 in varchar2 default hr_api.g_varchar2
3092: ,p_attribute9 in varchar2 default hr_api.g_varchar2
3093: ,p_attribute10 in varchar2 default hr_api.g_varchar2
3094: ,p_attribute11 in varchar2 default hr_api.g_varchar2
3095: ,p_attribute12 in varchar2 default hr_api.g_varchar2
3096: ,p_attribute13 in varchar2 default hr_api.g_varchar2
3097: ,p_attribute14 in varchar2 default hr_api.g_varchar2
3098: ,p_attribute15 in varchar2 default hr_api.g_varchar2
3099: ,p_attribute16 in varchar2 default hr_api.g_varchar2
3092: ,p_attribute9 in varchar2 default hr_api.g_varchar2
3093: ,p_attribute10 in varchar2 default hr_api.g_varchar2
3094: ,p_attribute11 in varchar2 default hr_api.g_varchar2
3095: ,p_attribute12 in varchar2 default hr_api.g_varchar2
3096: ,p_attribute13 in varchar2 default hr_api.g_varchar2
3097: ,p_attribute14 in varchar2 default hr_api.g_varchar2
3098: ,p_attribute15 in varchar2 default hr_api.g_varchar2
3099: ,p_attribute16 in varchar2 default hr_api.g_varchar2
3100: ,p_attribute17 in varchar2 default hr_api.g_varchar2
3093: ,p_attribute10 in varchar2 default hr_api.g_varchar2
3094: ,p_attribute11 in varchar2 default hr_api.g_varchar2
3095: ,p_attribute12 in varchar2 default hr_api.g_varchar2
3096: ,p_attribute13 in varchar2 default hr_api.g_varchar2
3097: ,p_attribute14 in varchar2 default hr_api.g_varchar2
3098: ,p_attribute15 in varchar2 default hr_api.g_varchar2
3099: ,p_attribute16 in varchar2 default hr_api.g_varchar2
3100: ,p_attribute17 in varchar2 default hr_api.g_varchar2
3101: ,p_attribute18 in varchar2 default hr_api.g_varchar2
3094: ,p_attribute11 in varchar2 default hr_api.g_varchar2
3095: ,p_attribute12 in varchar2 default hr_api.g_varchar2
3096: ,p_attribute13 in varchar2 default hr_api.g_varchar2
3097: ,p_attribute14 in varchar2 default hr_api.g_varchar2
3098: ,p_attribute15 in varchar2 default hr_api.g_varchar2
3099: ,p_attribute16 in varchar2 default hr_api.g_varchar2
3100: ,p_attribute17 in varchar2 default hr_api.g_varchar2
3101: ,p_attribute18 in varchar2 default hr_api.g_varchar2
3102: ,p_attribute19 in varchar2 default hr_api.g_varchar2
3095: ,p_attribute12 in varchar2 default hr_api.g_varchar2
3096: ,p_attribute13 in varchar2 default hr_api.g_varchar2
3097: ,p_attribute14 in varchar2 default hr_api.g_varchar2
3098: ,p_attribute15 in varchar2 default hr_api.g_varchar2
3099: ,p_attribute16 in varchar2 default hr_api.g_varchar2
3100: ,p_attribute17 in varchar2 default hr_api.g_varchar2
3101: ,p_attribute18 in varchar2 default hr_api.g_varchar2
3102: ,p_attribute19 in varchar2 default hr_api.g_varchar2
3103: ,p_attribute20 in varchar2 default hr_api.g_varchar2
3096: ,p_attribute13 in varchar2 default hr_api.g_varchar2
3097: ,p_attribute14 in varchar2 default hr_api.g_varchar2
3098: ,p_attribute15 in varchar2 default hr_api.g_varchar2
3099: ,p_attribute16 in varchar2 default hr_api.g_varchar2
3100: ,p_attribute17 in varchar2 default hr_api.g_varchar2
3101: ,p_attribute18 in varchar2 default hr_api.g_varchar2
3102: ,p_attribute19 in varchar2 default hr_api.g_varchar2
3103: ,p_attribute20 in varchar2 default hr_api.g_varchar2
3104: ,p_attribute21 in varchar2 default hr_api.g_varchar2
3097: ,p_attribute14 in varchar2 default hr_api.g_varchar2
3098: ,p_attribute15 in varchar2 default hr_api.g_varchar2
3099: ,p_attribute16 in varchar2 default hr_api.g_varchar2
3100: ,p_attribute17 in varchar2 default hr_api.g_varchar2
3101: ,p_attribute18 in varchar2 default hr_api.g_varchar2
3102: ,p_attribute19 in varchar2 default hr_api.g_varchar2
3103: ,p_attribute20 in varchar2 default hr_api.g_varchar2
3104: ,p_attribute21 in varchar2 default hr_api.g_varchar2
3105: ,p_attribute22 in varchar2 default hr_api.g_varchar2
3098: ,p_attribute15 in varchar2 default hr_api.g_varchar2
3099: ,p_attribute16 in varchar2 default hr_api.g_varchar2
3100: ,p_attribute17 in varchar2 default hr_api.g_varchar2
3101: ,p_attribute18 in varchar2 default hr_api.g_varchar2
3102: ,p_attribute19 in varchar2 default hr_api.g_varchar2
3103: ,p_attribute20 in varchar2 default hr_api.g_varchar2
3104: ,p_attribute21 in varchar2 default hr_api.g_varchar2
3105: ,p_attribute22 in varchar2 default hr_api.g_varchar2
3106: ,p_attribute23 in varchar2 default hr_api.g_varchar2
3099: ,p_attribute16 in varchar2 default hr_api.g_varchar2
3100: ,p_attribute17 in varchar2 default hr_api.g_varchar2
3101: ,p_attribute18 in varchar2 default hr_api.g_varchar2
3102: ,p_attribute19 in varchar2 default hr_api.g_varchar2
3103: ,p_attribute20 in varchar2 default hr_api.g_varchar2
3104: ,p_attribute21 in varchar2 default hr_api.g_varchar2
3105: ,p_attribute22 in varchar2 default hr_api.g_varchar2
3106: ,p_attribute23 in varchar2 default hr_api.g_varchar2
3107: ,p_attribute24 in varchar2 default hr_api.g_varchar2
3100: ,p_attribute17 in varchar2 default hr_api.g_varchar2
3101: ,p_attribute18 in varchar2 default hr_api.g_varchar2
3102: ,p_attribute19 in varchar2 default hr_api.g_varchar2
3103: ,p_attribute20 in varchar2 default hr_api.g_varchar2
3104: ,p_attribute21 in varchar2 default hr_api.g_varchar2
3105: ,p_attribute22 in varchar2 default hr_api.g_varchar2
3106: ,p_attribute23 in varchar2 default hr_api.g_varchar2
3107: ,p_attribute24 in varchar2 default hr_api.g_varchar2
3108: ,p_attribute25 in varchar2 default hr_api.g_varchar2
3101: ,p_attribute18 in varchar2 default hr_api.g_varchar2
3102: ,p_attribute19 in varchar2 default hr_api.g_varchar2
3103: ,p_attribute20 in varchar2 default hr_api.g_varchar2
3104: ,p_attribute21 in varchar2 default hr_api.g_varchar2
3105: ,p_attribute22 in varchar2 default hr_api.g_varchar2
3106: ,p_attribute23 in varchar2 default hr_api.g_varchar2
3107: ,p_attribute24 in varchar2 default hr_api.g_varchar2
3108: ,p_attribute25 in varchar2 default hr_api.g_varchar2
3109: ,p_attribute26 in varchar2 default hr_api.g_varchar2
3102: ,p_attribute19 in varchar2 default hr_api.g_varchar2
3103: ,p_attribute20 in varchar2 default hr_api.g_varchar2
3104: ,p_attribute21 in varchar2 default hr_api.g_varchar2
3105: ,p_attribute22 in varchar2 default hr_api.g_varchar2
3106: ,p_attribute23 in varchar2 default hr_api.g_varchar2
3107: ,p_attribute24 in varchar2 default hr_api.g_varchar2
3108: ,p_attribute25 in varchar2 default hr_api.g_varchar2
3109: ,p_attribute26 in varchar2 default hr_api.g_varchar2
3110: ,p_attribute27 in varchar2 default hr_api.g_varchar2
3103: ,p_attribute20 in varchar2 default hr_api.g_varchar2
3104: ,p_attribute21 in varchar2 default hr_api.g_varchar2
3105: ,p_attribute22 in varchar2 default hr_api.g_varchar2
3106: ,p_attribute23 in varchar2 default hr_api.g_varchar2
3107: ,p_attribute24 in varchar2 default hr_api.g_varchar2
3108: ,p_attribute25 in varchar2 default hr_api.g_varchar2
3109: ,p_attribute26 in varchar2 default hr_api.g_varchar2
3110: ,p_attribute27 in varchar2 default hr_api.g_varchar2
3111: ,p_attribute28 in varchar2 default hr_api.g_varchar2
3104: ,p_attribute21 in varchar2 default hr_api.g_varchar2
3105: ,p_attribute22 in varchar2 default hr_api.g_varchar2
3106: ,p_attribute23 in varchar2 default hr_api.g_varchar2
3107: ,p_attribute24 in varchar2 default hr_api.g_varchar2
3108: ,p_attribute25 in varchar2 default hr_api.g_varchar2
3109: ,p_attribute26 in varchar2 default hr_api.g_varchar2
3110: ,p_attribute27 in varchar2 default hr_api.g_varchar2
3111: ,p_attribute28 in varchar2 default hr_api.g_varchar2
3112: ,p_attribute29 in varchar2 default hr_api.g_varchar2
3105: ,p_attribute22 in varchar2 default hr_api.g_varchar2
3106: ,p_attribute23 in varchar2 default hr_api.g_varchar2
3107: ,p_attribute24 in varchar2 default hr_api.g_varchar2
3108: ,p_attribute25 in varchar2 default hr_api.g_varchar2
3109: ,p_attribute26 in varchar2 default hr_api.g_varchar2
3110: ,p_attribute27 in varchar2 default hr_api.g_varchar2
3111: ,p_attribute28 in varchar2 default hr_api.g_varchar2
3112: ,p_attribute29 in varchar2 default hr_api.g_varchar2
3113: ,p_attribute30 in varchar2 default hr_api.g_varchar2
3106: ,p_attribute23 in varchar2 default hr_api.g_varchar2
3107: ,p_attribute24 in varchar2 default hr_api.g_varchar2
3108: ,p_attribute25 in varchar2 default hr_api.g_varchar2
3109: ,p_attribute26 in varchar2 default hr_api.g_varchar2
3110: ,p_attribute27 in varchar2 default hr_api.g_varchar2
3111: ,p_attribute28 in varchar2 default hr_api.g_varchar2
3112: ,p_attribute29 in varchar2 default hr_api.g_varchar2
3113: ,p_attribute30 in varchar2 default hr_api.g_varchar2
3114: ,p_attribute_category in varchar2 default hr_api.g_varchar2
3107: ,p_attribute24 in varchar2 default hr_api.g_varchar2
3108: ,p_attribute25 in varchar2 default hr_api.g_varchar2
3109: ,p_attribute26 in varchar2 default hr_api.g_varchar2
3110: ,p_attribute27 in varchar2 default hr_api.g_varchar2
3111: ,p_attribute28 in varchar2 default hr_api.g_varchar2
3112: ,p_attribute29 in varchar2 default hr_api.g_varchar2
3113: ,p_attribute30 in varchar2 default hr_api.g_varchar2
3114: ,p_attribute_category in varchar2 default hr_api.g_varchar2
3115: ,p_segment1 in varchar2 default hr_api.g_varchar2
3108: ,p_attribute25 in varchar2 default hr_api.g_varchar2
3109: ,p_attribute26 in varchar2 default hr_api.g_varchar2
3110: ,p_attribute27 in varchar2 default hr_api.g_varchar2
3111: ,p_attribute28 in varchar2 default hr_api.g_varchar2
3112: ,p_attribute29 in varchar2 default hr_api.g_varchar2
3113: ,p_attribute30 in varchar2 default hr_api.g_varchar2
3114: ,p_attribute_category in varchar2 default hr_api.g_varchar2
3115: ,p_segment1 in varchar2 default hr_api.g_varchar2
3116: ,p_segment2 in varchar2 default hr_api.g_varchar2
3109: ,p_attribute26 in varchar2 default hr_api.g_varchar2
3110: ,p_attribute27 in varchar2 default hr_api.g_varchar2
3111: ,p_attribute28 in varchar2 default hr_api.g_varchar2
3112: ,p_attribute29 in varchar2 default hr_api.g_varchar2
3113: ,p_attribute30 in varchar2 default hr_api.g_varchar2
3114: ,p_attribute_category in varchar2 default hr_api.g_varchar2
3115: ,p_segment1 in varchar2 default hr_api.g_varchar2
3116: ,p_segment2 in varchar2 default hr_api.g_varchar2
3117: ,p_segment3 in varchar2 default hr_api.g_varchar2
3110: ,p_attribute27 in varchar2 default hr_api.g_varchar2
3111: ,p_attribute28 in varchar2 default hr_api.g_varchar2
3112: ,p_attribute29 in varchar2 default hr_api.g_varchar2
3113: ,p_attribute30 in varchar2 default hr_api.g_varchar2
3114: ,p_attribute_category in varchar2 default hr_api.g_varchar2
3115: ,p_segment1 in varchar2 default hr_api.g_varchar2
3116: ,p_segment2 in varchar2 default hr_api.g_varchar2
3117: ,p_segment3 in varchar2 default hr_api.g_varchar2
3118: ,p_segment4 in varchar2 default hr_api.g_varchar2
3111: ,p_attribute28 in varchar2 default hr_api.g_varchar2
3112: ,p_attribute29 in varchar2 default hr_api.g_varchar2
3113: ,p_attribute30 in varchar2 default hr_api.g_varchar2
3114: ,p_attribute_category in varchar2 default hr_api.g_varchar2
3115: ,p_segment1 in varchar2 default hr_api.g_varchar2
3116: ,p_segment2 in varchar2 default hr_api.g_varchar2
3117: ,p_segment3 in varchar2 default hr_api.g_varchar2
3118: ,p_segment4 in varchar2 default hr_api.g_varchar2
3119: ,p_segment5 in varchar2 default hr_api.g_varchar2
3112: ,p_attribute29 in varchar2 default hr_api.g_varchar2
3113: ,p_attribute30 in varchar2 default hr_api.g_varchar2
3114: ,p_attribute_category in varchar2 default hr_api.g_varchar2
3115: ,p_segment1 in varchar2 default hr_api.g_varchar2
3116: ,p_segment2 in varchar2 default hr_api.g_varchar2
3117: ,p_segment3 in varchar2 default hr_api.g_varchar2
3118: ,p_segment4 in varchar2 default hr_api.g_varchar2
3119: ,p_segment5 in varchar2 default hr_api.g_varchar2
3120: ,p_segment6 in varchar2 default hr_api.g_varchar2
3113: ,p_attribute30 in varchar2 default hr_api.g_varchar2
3114: ,p_attribute_category in varchar2 default hr_api.g_varchar2
3115: ,p_segment1 in varchar2 default hr_api.g_varchar2
3116: ,p_segment2 in varchar2 default hr_api.g_varchar2
3117: ,p_segment3 in varchar2 default hr_api.g_varchar2
3118: ,p_segment4 in varchar2 default hr_api.g_varchar2
3119: ,p_segment5 in varchar2 default hr_api.g_varchar2
3120: ,p_segment6 in varchar2 default hr_api.g_varchar2
3121: ,p_segment7 in varchar2 default hr_api.g_varchar2
3114: ,p_attribute_category in varchar2 default hr_api.g_varchar2
3115: ,p_segment1 in varchar2 default hr_api.g_varchar2
3116: ,p_segment2 in varchar2 default hr_api.g_varchar2
3117: ,p_segment3 in varchar2 default hr_api.g_varchar2
3118: ,p_segment4 in varchar2 default hr_api.g_varchar2
3119: ,p_segment5 in varchar2 default hr_api.g_varchar2
3120: ,p_segment6 in varchar2 default hr_api.g_varchar2
3121: ,p_segment7 in varchar2 default hr_api.g_varchar2
3122: ,p_segment8 in varchar2 default hr_api.g_varchar2
3115: ,p_segment1 in varchar2 default hr_api.g_varchar2
3116: ,p_segment2 in varchar2 default hr_api.g_varchar2
3117: ,p_segment3 in varchar2 default hr_api.g_varchar2
3118: ,p_segment4 in varchar2 default hr_api.g_varchar2
3119: ,p_segment5 in varchar2 default hr_api.g_varchar2
3120: ,p_segment6 in varchar2 default hr_api.g_varchar2
3121: ,p_segment7 in varchar2 default hr_api.g_varchar2
3122: ,p_segment8 in varchar2 default hr_api.g_varchar2
3123: ,p_segment9 in varchar2 default hr_api.g_varchar2
3116: ,p_segment2 in varchar2 default hr_api.g_varchar2
3117: ,p_segment3 in varchar2 default hr_api.g_varchar2
3118: ,p_segment4 in varchar2 default hr_api.g_varchar2
3119: ,p_segment5 in varchar2 default hr_api.g_varchar2
3120: ,p_segment6 in varchar2 default hr_api.g_varchar2
3121: ,p_segment7 in varchar2 default hr_api.g_varchar2
3122: ,p_segment8 in varchar2 default hr_api.g_varchar2
3123: ,p_segment9 in varchar2 default hr_api.g_varchar2
3124: ,p_segment10 in varchar2 default hr_api.g_varchar2
3117: ,p_segment3 in varchar2 default hr_api.g_varchar2
3118: ,p_segment4 in varchar2 default hr_api.g_varchar2
3119: ,p_segment5 in varchar2 default hr_api.g_varchar2
3120: ,p_segment6 in varchar2 default hr_api.g_varchar2
3121: ,p_segment7 in varchar2 default hr_api.g_varchar2
3122: ,p_segment8 in varchar2 default hr_api.g_varchar2
3123: ,p_segment9 in varchar2 default hr_api.g_varchar2
3124: ,p_segment10 in varchar2 default hr_api.g_varchar2
3125: ,p_segment11 in varchar2 default hr_api.g_varchar2
3118: ,p_segment4 in varchar2 default hr_api.g_varchar2
3119: ,p_segment5 in varchar2 default hr_api.g_varchar2
3120: ,p_segment6 in varchar2 default hr_api.g_varchar2
3121: ,p_segment7 in varchar2 default hr_api.g_varchar2
3122: ,p_segment8 in varchar2 default hr_api.g_varchar2
3123: ,p_segment9 in varchar2 default hr_api.g_varchar2
3124: ,p_segment10 in varchar2 default hr_api.g_varchar2
3125: ,p_segment11 in varchar2 default hr_api.g_varchar2
3126: ,p_segment12 in varchar2 default hr_api.g_varchar2
3119: ,p_segment5 in varchar2 default hr_api.g_varchar2
3120: ,p_segment6 in varchar2 default hr_api.g_varchar2
3121: ,p_segment7 in varchar2 default hr_api.g_varchar2
3122: ,p_segment8 in varchar2 default hr_api.g_varchar2
3123: ,p_segment9 in varchar2 default hr_api.g_varchar2
3124: ,p_segment10 in varchar2 default hr_api.g_varchar2
3125: ,p_segment11 in varchar2 default hr_api.g_varchar2
3126: ,p_segment12 in varchar2 default hr_api.g_varchar2
3127: ,p_segment13 in varchar2 default hr_api.g_varchar2
3120: ,p_segment6 in varchar2 default hr_api.g_varchar2
3121: ,p_segment7 in varchar2 default hr_api.g_varchar2
3122: ,p_segment8 in varchar2 default hr_api.g_varchar2
3123: ,p_segment9 in varchar2 default hr_api.g_varchar2
3124: ,p_segment10 in varchar2 default hr_api.g_varchar2
3125: ,p_segment11 in varchar2 default hr_api.g_varchar2
3126: ,p_segment12 in varchar2 default hr_api.g_varchar2
3127: ,p_segment13 in varchar2 default hr_api.g_varchar2
3128: ,p_segment14 in varchar2 default hr_api.g_varchar2
3121: ,p_segment7 in varchar2 default hr_api.g_varchar2
3122: ,p_segment8 in varchar2 default hr_api.g_varchar2
3123: ,p_segment9 in varchar2 default hr_api.g_varchar2
3124: ,p_segment10 in varchar2 default hr_api.g_varchar2
3125: ,p_segment11 in varchar2 default hr_api.g_varchar2
3126: ,p_segment12 in varchar2 default hr_api.g_varchar2
3127: ,p_segment13 in varchar2 default hr_api.g_varchar2
3128: ,p_segment14 in varchar2 default hr_api.g_varchar2
3129: ,p_segment15 in varchar2 default hr_api.g_varchar2
3122: ,p_segment8 in varchar2 default hr_api.g_varchar2
3123: ,p_segment9 in varchar2 default hr_api.g_varchar2
3124: ,p_segment10 in varchar2 default hr_api.g_varchar2
3125: ,p_segment11 in varchar2 default hr_api.g_varchar2
3126: ,p_segment12 in varchar2 default hr_api.g_varchar2
3127: ,p_segment13 in varchar2 default hr_api.g_varchar2
3128: ,p_segment14 in varchar2 default hr_api.g_varchar2
3129: ,p_segment15 in varchar2 default hr_api.g_varchar2
3130: ,p_segment16 in varchar2 default hr_api.g_varchar2
3123: ,p_segment9 in varchar2 default hr_api.g_varchar2
3124: ,p_segment10 in varchar2 default hr_api.g_varchar2
3125: ,p_segment11 in varchar2 default hr_api.g_varchar2
3126: ,p_segment12 in varchar2 default hr_api.g_varchar2
3127: ,p_segment13 in varchar2 default hr_api.g_varchar2
3128: ,p_segment14 in varchar2 default hr_api.g_varchar2
3129: ,p_segment15 in varchar2 default hr_api.g_varchar2
3130: ,p_segment16 in varchar2 default hr_api.g_varchar2
3131: ,p_segment17 in varchar2 default hr_api.g_varchar2
3124: ,p_segment10 in varchar2 default hr_api.g_varchar2
3125: ,p_segment11 in varchar2 default hr_api.g_varchar2
3126: ,p_segment12 in varchar2 default hr_api.g_varchar2
3127: ,p_segment13 in varchar2 default hr_api.g_varchar2
3128: ,p_segment14 in varchar2 default hr_api.g_varchar2
3129: ,p_segment15 in varchar2 default hr_api.g_varchar2
3130: ,p_segment16 in varchar2 default hr_api.g_varchar2
3131: ,p_segment17 in varchar2 default hr_api.g_varchar2
3132: ,p_segment18 in varchar2 default hr_api.g_varchar2
3125: ,p_segment11 in varchar2 default hr_api.g_varchar2
3126: ,p_segment12 in varchar2 default hr_api.g_varchar2
3127: ,p_segment13 in varchar2 default hr_api.g_varchar2
3128: ,p_segment14 in varchar2 default hr_api.g_varchar2
3129: ,p_segment15 in varchar2 default hr_api.g_varchar2
3130: ,p_segment16 in varchar2 default hr_api.g_varchar2
3131: ,p_segment17 in varchar2 default hr_api.g_varchar2
3132: ,p_segment18 in varchar2 default hr_api.g_varchar2
3133: ,p_segment19 in varchar2 default hr_api.g_varchar2
3126: ,p_segment12 in varchar2 default hr_api.g_varchar2
3127: ,p_segment13 in varchar2 default hr_api.g_varchar2
3128: ,p_segment14 in varchar2 default hr_api.g_varchar2
3129: ,p_segment15 in varchar2 default hr_api.g_varchar2
3130: ,p_segment16 in varchar2 default hr_api.g_varchar2
3131: ,p_segment17 in varchar2 default hr_api.g_varchar2
3132: ,p_segment18 in varchar2 default hr_api.g_varchar2
3133: ,p_segment19 in varchar2 default hr_api.g_varchar2
3134: ,p_segment20 in varchar2 default hr_api.g_varchar2
3127: ,p_segment13 in varchar2 default hr_api.g_varchar2
3128: ,p_segment14 in varchar2 default hr_api.g_varchar2
3129: ,p_segment15 in varchar2 default hr_api.g_varchar2
3130: ,p_segment16 in varchar2 default hr_api.g_varchar2
3131: ,p_segment17 in varchar2 default hr_api.g_varchar2
3132: ,p_segment18 in varchar2 default hr_api.g_varchar2
3133: ,p_segment19 in varchar2 default hr_api.g_varchar2
3134: ,p_segment20 in varchar2 default hr_api.g_varchar2
3135: ,p_segment21 in varchar2 default hr_api.g_varchar2
3128: ,p_segment14 in varchar2 default hr_api.g_varchar2
3129: ,p_segment15 in varchar2 default hr_api.g_varchar2
3130: ,p_segment16 in varchar2 default hr_api.g_varchar2
3131: ,p_segment17 in varchar2 default hr_api.g_varchar2
3132: ,p_segment18 in varchar2 default hr_api.g_varchar2
3133: ,p_segment19 in varchar2 default hr_api.g_varchar2
3134: ,p_segment20 in varchar2 default hr_api.g_varchar2
3135: ,p_segment21 in varchar2 default hr_api.g_varchar2
3136: ,p_segment22 in varchar2 default hr_api.g_varchar2
3129: ,p_segment15 in varchar2 default hr_api.g_varchar2
3130: ,p_segment16 in varchar2 default hr_api.g_varchar2
3131: ,p_segment17 in varchar2 default hr_api.g_varchar2
3132: ,p_segment18 in varchar2 default hr_api.g_varchar2
3133: ,p_segment19 in varchar2 default hr_api.g_varchar2
3134: ,p_segment20 in varchar2 default hr_api.g_varchar2
3135: ,p_segment21 in varchar2 default hr_api.g_varchar2
3136: ,p_segment22 in varchar2 default hr_api.g_varchar2
3137: ,p_segment23 in varchar2 default hr_api.g_varchar2
3130: ,p_segment16 in varchar2 default hr_api.g_varchar2
3131: ,p_segment17 in varchar2 default hr_api.g_varchar2
3132: ,p_segment18 in varchar2 default hr_api.g_varchar2
3133: ,p_segment19 in varchar2 default hr_api.g_varchar2
3134: ,p_segment20 in varchar2 default hr_api.g_varchar2
3135: ,p_segment21 in varchar2 default hr_api.g_varchar2
3136: ,p_segment22 in varchar2 default hr_api.g_varchar2
3137: ,p_segment23 in varchar2 default hr_api.g_varchar2
3138: ,p_segment24 in varchar2 default hr_api.g_varchar2
3131: ,p_segment17 in varchar2 default hr_api.g_varchar2
3132: ,p_segment18 in varchar2 default hr_api.g_varchar2
3133: ,p_segment19 in varchar2 default hr_api.g_varchar2
3134: ,p_segment20 in varchar2 default hr_api.g_varchar2
3135: ,p_segment21 in varchar2 default hr_api.g_varchar2
3136: ,p_segment22 in varchar2 default hr_api.g_varchar2
3137: ,p_segment23 in varchar2 default hr_api.g_varchar2
3138: ,p_segment24 in varchar2 default hr_api.g_varchar2
3139: ,p_segment25 in varchar2 default hr_api.g_varchar2
3132: ,p_segment18 in varchar2 default hr_api.g_varchar2
3133: ,p_segment19 in varchar2 default hr_api.g_varchar2
3134: ,p_segment20 in varchar2 default hr_api.g_varchar2
3135: ,p_segment21 in varchar2 default hr_api.g_varchar2
3136: ,p_segment22 in varchar2 default hr_api.g_varchar2
3137: ,p_segment23 in varchar2 default hr_api.g_varchar2
3138: ,p_segment24 in varchar2 default hr_api.g_varchar2
3139: ,p_segment25 in varchar2 default hr_api.g_varchar2
3140: ,p_segment26 in varchar2 default hr_api.g_varchar2
3133: ,p_segment19 in varchar2 default hr_api.g_varchar2
3134: ,p_segment20 in varchar2 default hr_api.g_varchar2
3135: ,p_segment21 in varchar2 default hr_api.g_varchar2
3136: ,p_segment22 in varchar2 default hr_api.g_varchar2
3137: ,p_segment23 in varchar2 default hr_api.g_varchar2
3138: ,p_segment24 in varchar2 default hr_api.g_varchar2
3139: ,p_segment25 in varchar2 default hr_api.g_varchar2
3140: ,p_segment26 in varchar2 default hr_api.g_varchar2
3141: ,p_segment27 in varchar2 default hr_api.g_varchar2
3134: ,p_segment20 in varchar2 default hr_api.g_varchar2
3135: ,p_segment21 in varchar2 default hr_api.g_varchar2
3136: ,p_segment22 in varchar2 default hr_api.g_varchar2
3137: ,p_segment23 in varchar2 default hr_api.g_varchar2
3138: ,p_segment24 in varchar2 default hr_api.g_varchar2
3139: ,p_segment25 in varchar2 default hr_api.g_varchar2
3140: ,p_segment26 in varchar2 default hr_api.g_varchar2
3141: ,p_segment27 in varchar2 default hr_api.g_varchar2
3142: ,p_segment28 in varchar2 default hr_api.g_varchar2
3135: ,p_segment21 in varchar2 default hr_api.g_varchar2
3136: ,p_segment22 in varchar2 default hr_api.g_varchar2
3137: ,p_segment23 in varchar2 default hr_api.g_varchar2
3138: ,p_segment24 in varchar2 default hr_api.g_varchar2
3139: ,p_segment25 in varchar2 default hr_api.g_varchar2
3140: ,p_segment26 in varchar2 default hr_api.g_varchar2
3141: ,p_segment27 in varchar2 default hr_api.g_varchar2
3142: ,p_segment28 in varchar2 default hr_api.g_varchar2
3143: ,p_segment29 in varchar2 default hr_api.g_varchar2
3136: ,p_segment22 in varchar2 default hr_api.g_varchar2
3137: ,p_segment23 in varchar2 default hr_api.g_varchar2
3138: ,p_segment24 in varchar2 default hr_api.g_varchar2
3139: ,p_segment25 in varchar2 default hr_api.g_varchar2
3140: ,p_segment26 in varchar2 default hr_api.g_varchar2
3141: ,p_segment27 in varchar2 default hr_api.g_varchar2
3142: ,p_segment28 in varchar2 default hr_api.g_varchar2
3143: ,p_segment29 in varchar2 default hr_api.g_varchar2
3144: ,p_segment30 in varchar2 default hr_api.g_varchar2
3137: ,p_segment23 in varchar2 default hr_api.g_varchar2
3138: ,p_segment24 in varchar2 default hr_api.g_varchar2
3139: ,p_segment25 in varchar2 default hr_api.g_varchar2
3140: ,p_segment26 in varchar2 default hr_api.g_varchar2
3141: ,p_segment27 in varchar2 default hr_api.g_varchar2
3142: ,p_segment28 in varchar2 default hr_api.g_varchar2
3143: ,p_segment29 in varchar2 default hr_api.g_varchar2
3144: ,p_segment30 in varchar2 default hr_api.g_varchar2
3145: ,p_concat_segments in varchar2 default hr_api.g_varchar2
3138: ,p_segment24 in varchar2 default hr_api.g_varchar2
3139: ,p_segment25 in varchar2 default hr_api.g_varchar2
3140: ,p_segment26 in varchar2 default hr_api.g_varchar2
3141: ,p_segment27 in varchar2 default hr_api.g_varchar2
3142: ,p_segment28 in varchar2 default hr_api.g_varchar2
3143: ,p_segment29 in varchar2 default hr_api.g_varchar2
3144: ,p_segment30 in varchar2 default hr_api.g_varchar2
3145: ,p_concat_segments in varchar2 default hr_api.g_varchar2
3146: ,p_request_id in number default hr_api.g_number
3139: ,p_segment25 in varchar2 default hr_api.g_varchar2
3140: ,p_segment26 in varchar2 default hr_api.g_varchar2
3141: ,p_segment27 in varchar2 default hr_api.g_varchar2
3142: ,p_segment28 in varchar2 default hr_api.g_varchar2
3143: ,p_segment29 in varchar2 default hr_api.g_varchar2
3144: ,p_segment30 in varchar2 default hr_api.g_varchar2
3145: ,p_concat_segments in varchar2 default hr_api.g_varchar2
3146: ,p_request_id in number default hr_api.g_number
3147: ,p_program_application_id in number default hr_api.g_number
3140: ,p_segment26 in varchar2 default hr_api.g_varchar2
3141: ,p_segment27 in varchar2 default hr_api.g_varchar2
3142: ,p_segment28 in varchar2 default hr_api.g_varchar2
3143: ,p_segment29 in varchar2 default hr_api.g_varchar2
3144: ,p_segment30 in varchar2 default hr_api.g_varchar2
3145: ,p_concat_segments in varchar2 default hr_api.g_varchar2
3146: ,p_request_id in number default hr_api.g_number
3147: ,p_program_application_id in number default hr_api.g_number
3148: ,p_program_id in number default hr_api.g_number
3141: ,p_segment27 in varchar2 default hr_api.g_varchar2
3142: ,p_segment28 in varchar2 default hr_api.g_varchar2
3143: ,p_segment29 in varchar2 default hr_api.g_varchar2
3144: ,p_segment30 in varchar2 default hr_api.g_varchar2
3145: ,p_concat_segments in varchar2 default hr_api.g_varchar2
3146: ,p_request_id in number default hr_api.g_number
3147: ,p_program_application_id in number default hr_api.g_number
3148: ,p_program_id in number default hr_api.g_number
3149: ,p_program_update_date in date default hr_api.g_date
3142: ,p_segment28 in varchar2 default hr_api.g_varchar2
3143: ,p_segment29 in varchar2 default hr_api.g_varchar2
3144: ,p_segment30 in varchar2 default hr_api.g_varchar2
3145: ,p_concat_segments in varchar2 default hr_api.g_varchar2
3146: ,p_request_id in number default hr_api.g_number
3147: ,p_program_application_id in number default hr_api.g_number
3148: ,p_program_id in number default hr_api.g_number
3149: ,p_program_update_date in date default hr_api.g_date
3150: ,p_object_version_number in out nocopy number
3143: ,p_segment29 in varchar2 default hr_api.g_varchar2
3144: ,p_segment30 in varchar2 default hr_api.g_varchar2
3145: ,p_concat_segments in varchar2 default hr_api.g_varchar2
3146: ,p_request_id in number default hr_api.g_number
3147: ,p_program_application_id in number default hr_api.g_number
3148: ,p_program_id in number default hr_api.g_number
3149: ,p_program_update_date in date default hr_api.g_date
3150: ,p_object_version_number in out nocopy number
3151: ,p_effective_date in date
3144: ,p_segment30 in varchar2 default hr_api.g_varchar2
3145: ,p_concat_segments in varchar2 default hr_api.g_varchar2
3146: ,p_request_id in number default hr_api.g_number
3147: ,p_program_application_id in number default hr_api.g_number
3148: ,p_program_id in number default hr_api.g_number
3149: ,p_program_update_date in date default hr_api.g_date
3150: ,p_object_version_number in out nocopy number
3151: ,p_effective_date in date
3152: ,p_datetrack_mode in varchar2
3145: ,p_concat_segments in varchar2 default hr_api.g_varchar2
3146: ,p_request_id in number default hr_api.g_number
3147: ,p_program_application_id in number default hr_api.g_number
3148: ,p_program_id in number default hr_api.g_number
3149: ,p_program_update_date in date default hr_api.g_date
3150: ,p_object_version_number in out nocopy number
3151: ,p_effective_date in date
3152: ,p_datetrack_mode in varchar2
3153: ) is
3274: -- instead of p_language_code from now on, to allow an IN OUT parameter to
3275: -- be passed through.
3276: --
3277: l_language_code := p_language_code;
3278: hr_api.validate_language_code(p_language_code => l_language_code);
3279: --
3280: if g_debug then
3281: hr_utility.set_location(l_proc, 20);
3282: end if;
3514: ,p_datetrack_mode => p_datetrack_mode
3515: ,p_language_code => l_language_code
3516: );
3517: exception
3518: when hr_api.cannot_find_prog_unit then
3519: hr_api.cannot_find_prog_unit_error
3520: (p_module_name => 'UPDATE_POSITION'
3521: ,p_hook_type => 'BP'
3522: );
3515: ,p_language_code => l_language_code
3516: );
3517: exception
3518: when hr_api.cannot_find_prog_unit then
3519: hr_api.cannot_find_prog_unit_error
3520: (p_module_name => 'UPDATE_POSITION'
3521: ,p_hook_type => 'BP'
3522: );
3523: --
3703: --
3704: -- If date_effective is being updated , then need to maintain valid grades
3705: -- accordingly for that position.
3706: --
3707: IF ((nvl(p_date_effective, hr_api.g_date) <> hr_api.g_date) and
3708: hr_psf_shd.g_old_rec.date_effective <>
3709: nvl(p_date_effective, hr_api.g_date)) THEN
3710: --
3711:
3705: -- accordingly for that position.
3706: --
3707: IF ((nvl(p_date_effective, hr_api.g_date) <> hr_api.g_date) and
3708: hr_psf_shd.g_old_rec.date_effective <>
3709: nvl(p_date_effective, hr_api.g_date)) THEN
3710: --
3711:
3712: PER_POSITIONS_PKG.maintain_valid_grades
3713: (p_validate => p_validate
3725: --
3726: -- If date_end is being updated , then need to maintain valid grades
3727: -- accordingly for that position.
3728: --
3729: IF ((nvl(p_date_end, hr_api.g_date) <> hr_api.g_date) and
3730: nvl(hr_psf_shd.g_old_rec.date_end, hr_api.g_date) <>
3731: nvl(p_date_end, hr_api.g_date)) THEN
3732: --
3733: pER_POSITIONS_PKG.maintain_valid_grades
3726: -- If date_end is being updated , then need to maintain valid grades
3727: -- accordingly for that position.
3728: --
3729: IF ((nvl(p_date_end, hr_api.g_date) <> hr_api.g_date) and
3730: nvl(hr_psf_shd.g_old_rec.date_end, hr_api.g_date) <>
3731: nvl(p_date_end, hr_api.g_date)) THEN
3732: --
3733: pER_POSITIONS_PKG.maintain_valid_grades
3734: (p_validate => p_validate
3727: -- accordingly for that position.
3728: --
3729: IF ((nvl(p_date_end, hr_api.g_date) <> hr_api.g_date) and
3730: nvl(hr_psf_shd.g_old_rec.date_end, hr_api.g_date) <>
3731: nvl(p_date_end, hr_api.g_date)) THEN
3732: --
3733: pER_POSITIONS_PKG.maintain_valid_grades
3734: (p_validate => p_validate
3735: ,p_position_id => p_position_id
3889: --
3890: -- PMFLETCH Update translation table if base table record is to eot and
3891: -- position_definition_id has been updated.
3892: --
3893: if ( l_effective_end_date = hr_api.g_eot
3894: AND (
3895: hr_psf_shd.g_old_rec.position_definition_id <> l_position_definition_id
3896: or
3897: hr_psf_shd.g_old_rec.name <> l_name
4099: ,p_datetrack_mode => p_datetrack_mode
4100: ,p_language_code => l_language_code
4101: );
4102: exception
4103: when hr_api.cannot_find_prog_unit then
4104: hr_api.cannot_find_prog_unit_error
4105: (p_module_name => 'UPDATE_POSITION'
4106: ,p_hook_type => 'AP'
4107: );
4100: ,p_language_code => l_language_code
4101: );
4102: exception
4103: when hr_api.cannot_find_prog_unit then
4104: hr_api.cannot_find_prog_unit_error
4105: (p_module_name => 'UPDATE_POSITION'
4106: ,p_hook_type => 'AP'
4107: );
4108: --
4127: --
4128: -- If date_effective is being updated , then need to maintain valid grades
4129: -- accordingly for that position.
4130: --
4131: IF ((nvl(p_date_effective, hr_api.g_date) <> hr_api.g_date) and
4132: hr_psf_shd.g_old_rec.date_effective <>
4133: nvl(p_date_effective, hr_api.g_date)) THEN
4134: --
4135:
4129: -- accordingly for that position.
4130: --
4131: IF ((nvl(p_date_effective, hr_api.g_date) <> hr_api.g_date) and
4132: hr_psf_shd.g_old_rec.date_effective <>
4133: nvl(p_date_effective, hr_api.g_date)) THEN
4134: --
4135:
4136: maintain_valid_grades
4137: (p_validate => p_validate
4149: --
4150: -- If date_end is being updated , then need to maintain valid grades
4151: -- accordingly for that position.
4152: --
4153: IF ((nvl(p_date_end, hr_api.g_date) <> hr_api.g_date) and
4154: nvl(hr_psf_shd.g_old_rec.date_end, hr_api.g_date) <>
4155: nvl(p_date_end, hr_api.g_date)) THEN
4156: --
4157: maintain_valid_grades
4150: -- If date_end is being updated , then need to maintain valid grades
4151: -- accordingly for that position.
4152: --
4153: IF ((nvl(p_date_end, hr_api.g_date) <> hr_api.g_date) and
4154: nvl(hr_psf_shd.g_old_rec.date_end, hr_api.g_date) <>
4155: nvl(p_date_end, hr_api.g_date)) THEN
4156: --
4157: maintain_valid_grades
4158: (p_validate => p_validate
4151: -- accordingly for that position.
4152: --
4153: IF ((nvl(p_date_end, hr_api.g_date) <> hr_api.g_date) and
4154: nvl(hr_psf_shd.g_old_rec.date_end, hr_api.g_date) <>
4155: nvl(p_date_end, hr_api.g_date)) THEN
4156: --
4157: maintain_valid_grades
4158: (p_validate => p_validate
4159: ,p_position_id => p_position_id
4176: --
4177: -- When in validation only mode raise the Validate_Enabled exception
4178: --
4179: if p_validate then
4180: raise hr_api.validate_enabled;
4181: end if;
4182: --
4183: -- Set all output arguments
4184: --
4195: end if;
4196: --
4197: exception
4198: --
4199: when hr_api.validate_enabled then
4200: --
4201: -- As the Validate_Enabled exception has been raised
4202: -- we must rollback to the savepoint
4203: --
4290: ,p_effective_date => trunc(p_effective_date)
4291: ,p_datetrack_mode => p_datetrack_mode
4292: );
4293: exception
4294: when hr_api.cannot_find_prog_unit then
4295: hr_api.cannot_find_prog_unit_error
4296: (p_module_name => 'DELETE_POSITION'
4297: ,p_hook_type => 'BP'
4298: );
4291: ,p_datetrack_mode => p_datetrack_mode
4292: );
4293: exception
4294: when hr_api.cannot_find_prog_unit then
4295: hr_api.cannot_find_prog_unit_error
4296: (p_module_name => 'DELETE_POSITION'
4297: ,p_hook_type => 'BP'
4298: );
4299: --
4415: ,p_effective_date => trunc(p_effective_date)
4416: ,p_datetrack_mode => p_datetrack_mode
4417: );
4418: exception
4419: when hr_api.cannot_find_prog_unit then
4420: hr_api.cannot_find_prog_unit_error
4421: (p_module_name => 'DELETE_POSITION'
4422: ,p_hook_type => 'AP'
4423: );
4416: ,p_datetrack_mode => p_datetrack_mode
4417: );
4418: exception
4419: when hr_api.cannot_find_prog_unit then
4420: hr_api.cannot_find_prog_unit_error
4421: (p_module_name => 'DELETE_POSITION'
4422: ,p_hook_type => 'AP'
4423: );
4424: --
4432: --
4433: -- When in validation only mode raise the Validate_Enabled exception
4434: --
4435: if p_validate then
4436: raise hr_api.validate_enabled;
4437: end if;
4438: --
4439: if g_debug then
4440: hr_utility.set_location(' Leaving:'||l_proc, 70);
4441: end if;
4442: --
4443: exception
4444: --
4445: when hr_api.validate_enabled then
4446: --
4447: -- As the Validate_Enabled exception has been raised
4448: -- we must rollback to the savepoint
4449: --
4480: ,p_effective_date in date
4481: ,p_datetrack_mode in varchar2
4482: ,p_validation_start_date out nocopy date
4483: ,p_validation_end_date out nocopy date
4484: ,p_language_code in varchar2 default hr_api.userenv_lang
4485: ) is
4486: --
4487: --
4488: -- Declare cursors and local variables
4531: psf.object_version_number, pd.id_flex_num
4532: from hr_all_positions_f psf, per_position_definitions pd
4533: where position_id = p_position_id
4534: and psf.position_definition_id = pd.position_definition_id
4535: and effective_end_date = hr_api.g_eot;
4536: --
4537: l_effective_start_date date;
4538: l_effective_end_date date;
4539: l_position_definition_id number;
4591: --
4592: cursor c_all_positions is
4593: select psf.position_id
4594: from hr_all_positions_f psf
4595: where psf.effective_end_date = hr_api.g_eot;
4596: --
4597: cursor c_bg_positions(p_business_group_id number) is
4598: select psf.position_id
4599: from hr_all_positions_f psf
4597: cursor c_bg_positions(p_business_group_id number) is
4598: select psf.position_id
4599: from hr_all_positions_f psf
4600: where psf.business_group_id = p_business_group_id
4601: and psf.effective_end_date = hr_api.g_eot;
4602: --
4603: cursor c_org_positions(p_organization_id number) is
4604: select psf.position_id
4605: from hr_all_positions_f psf
4603: cursor c_org_positions(p_organization_id number) is
4604: select psf.position_id
4605: from hr_all_positions_f psf
4606: where psf.organization_id = p_organization_id
4607: and psf.effective_end_date = hr_api.g_eot;
4608: --
4609: l_position_id number;
4610: --
4611: begin