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

APPS.HR_GRADE_API dependencies on HR_API

Line 100: ,p_language_code in varchar2 default hr_api.userenv_lang

96: ,p_segment27 in varchar2 default null
97: ,p_segment28 in varchar2 default null
98: ,p_segment29 in varchar2 default null
99: ,p_segment30 in varchar2 default null
100: ,p_language_code in varchar2 default hr_api.userenv_lang
101: ,p_concat_segments in varchar2 default null
102: ,p_short_name in varchar2 default null
103: ,p_grade_id out nocopy number
104: ,p_object_version_number out nocopy number

Line 216: hr_api.validate_language_code(p_language_code => l_language_code);

212: -- Validate the language parameter. l_language_code should be passed
213: -- instead of p_language_code from now on, to allow an IN OUT parameter to
214: -- be passed through.
215: --
216: hr_api.validate_language_code(p_language_code => l_language_code);
217: --
218: -- Truncate date_from and date_to
219: --
220: l_date_from := trunc(p_date_from);

Line 385: when hr_api.cannot_find_prog_unit then

381: ,p_effective_date => p_effective_date
382: ,p_short_name => p_short_name
383: );
384: exception
385: when hr_api.cannot_find_prog_unit then
386: hr_api.cannot_find_prog_unit_error
387: (p_module_name => 'CREATE_GRADE'
388: ,p_hook_type => 'BP'
389: );

Line 386: hr_api.cannot_find_prog_unit_error

382: ,p_short_name => p_short_name
383: );
384: exception
385: when hr_api.cannot_find_prog_unit then
386: hr_api.cannot_find_prog_unit_error
387: (p_module_name => 'CREATE_GRADE'
388: ,p_hook_type => 'BP'
389: );
390: --

Line 622: when hr_api.cannot_find_prog_unit then

618: ,p_language_code => l_language_code
619: ,p_short_name => p_short_name
620: );
621: exception
622: when hr_api.cannot_find_prog_unit then
623: hr_api.cannot_find_prog_unit_error
624: (p_module_name => 'CREATE_GRADE'
625: ,p_hook_type => 'AP'
626: );

Line 623: hr_api.cannot_find_prog_unit_error

619: ,p_short_name => p_short_name
620: );
621: exception
622: when hr_api.cannot_find_prog_unit then
623: hr_api.cannot_find_prog_unit_error
624: (p_module_name => 'CREATE_GRADE'
625: ,p_hook_type => 'AP'
626: );
627: --

Line 636: raise hr_api.validate_enabled;

632: -- When in validation only mode raise the Validate_Enabled exception
633: --
634: if p_validate
635: then
636: raise hr_api.validate_enabled;
637: end if;
638: --
639: hr_utility.set_location(' Leaving:'||l_proc, 50);
640: --

Line 652: when hr_api.validate_enabled then

648: hr_utility.set_location(' Leaving:'||l_proc, 60);
649: --
650: exception
651: --
652: when hr_api.validate_enabled then
653: --
654: -- As the Validate_Enabled exception has been raised
655: -- we must rollback to the savepoint
656: --

Line 696: ,p_sequence in number default hr_api.g_number

692: --
693: procedure update_grade(
694: p_validate in boolean default false
695: ,p_grade_id in number
696: ,p_sequence in number default hr_api.g_number
697: ,p_date_from in date default hr_api.g_date
698: ,p_effective_date in date default hr_api.g_date
699: ,p_date_to in date default hr_api.g_date
700: ,p_request_id in number default hr_api.g_number

Line 697: ,p_date_from in date default hr_api.g_date

693: procedure update_grade(
694: p_validate in boolean default false
695: ,p_grade_id in number
696: ,p_sequence in number default hr_api.g_number
697: ,p_date_from in date default hr_api.g_date
698: ,p_effective_date in date default hr_api.g_date
699: ,p_date_to in date default hr_api.g_date
700: ,p_request_id in number default hr_api.g_number
701: ,p_program_application_id in number default hr_api.g_number

Line 698: ,p_effective_date in date default hr_api.g_date

694: p_validate in boolean default false
695: ,p_grade_id in number
696: ,p_sequence in number default hr_api.g_number
697: ,p_date_from in date default hr_api.g_date
698: ,p_effective_date in date default hr_api.g_date
699: ,p_date_to in date default hr_api.g_date
700: ,p_request_id in number default hr_api.g_number
701: ,p_program_application_id in number default hr_api.g_number
702: ,p_program_id in number default hr_api.g_number

Line 699: ,p_date_to in date default hr_api.g_date

695: ,p_grade_id in number
696: ,p_sequence in number default hr_api.g_number
697: ,p_date_from in date default hr_api.g_date
698: ,p_effective_date in date default hr_api.g_date
699: ,p_date_to in date default hr_api.g_date
700: ,p_request_id in number default hr_api.g_number
701: ,p_program_application_id in number default hr_api.g_number
702: ,p_program_id in number default hr_api.g_number
703: ,p_program_update_date in date default hr_api.g_date

Line 700: ,p_request_id in number default hr_api.g_number

696: ,p_sequence in number default hr_api.g_number
697: ,p_date_from in date default hr_api.g_date
698: ,p_effective_date in date default hr_api.g_date
699: ,p_date_to in date default hr_api.g_date
700: ,p_request_id in number default hr_api.g_number
701: ,p_program_application_id in number default hr_api.g_number
702: ,p_program_id in number default hr_api.g_number
703: ,p_program_update_date in date default hr_api.g_date
704: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 701: ,p_program_application_id in number default hr_api.g_number

697: ,p_date_from in date default hr_api.g_date
698: ,p_effective_date in date default hr_api.g_date
699: ,p_date_to in date default hr_api.g_date
700: ,p_request_id in number default hr_api.g_number
701: ,p_program_application_id in number default hr_api.g_number
702: ,p_program_id in number default hr_api.g_number
703: ,p_program_update_date in date default hr_api.g_date
704: ,p_attribute_category in varchar2 default hr_api.g_varchar2
705: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 702: ,p_program_id in number default hr_api.g_number

698: ,p_effective_date in date default hr_api.g_date
699: ,p_date_to in date default hr_api.g_date
700: ,p_request_id in number default hr_api.g_number
701: ,p_program_application_id in number default hr_api.g_number
702: ,p_program_id in number default hr_api.g_number
703: ,p_program_update_date in date default hr_api.g_date
704: ,p_attribute_category in varchar2 default hr_api.g_varchar2
705: ,p_attribute1 in varchar2 default hr_api.g_varchar2
706: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 703: ,p_program_update_date in date default hr_api.g_date

699: ,p_date_to in date default hr_api.g_date
700: ,p_request_id in number default hr_api.g_number
701: ,p_program_application_id in number default hr_api.g_number
702: ,p_program_id in number default hr_api.g_number
703: ,p_program_update_date in date default hr_api.g_date
704: ,p_attribute_category in varchar2 default hr_api.g_varchar2
705: ,p_attribute1 in varchar2 default hr_api.g_varchar2
706: ,p_attribute2 in varchar2 default hr_api.g_varchar2
707: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 704: ,p_attribute_category in varchar2 default hr_api.g_varchar2

700: ,p_request_id in number default hr_api.g_number
701: ,p_program_application_id in number default hr_api.g_number
702: ,p_program_id in number default hr_api.g_number
703: ,p_program_update_date in date default hr_api.g_date
704: ,p_attribute_category in varchar2 default hr_api.g_varchar2
705: ,p_attribute1 in varchar2 default hr_api.g_varchar2
706: ,p_attribute2 in varchar2 default hr_api.g_varchar2
707: ,p_attribute3 in varchar2 default hr_api.g_varchar2
708: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 705: ,p_attribute1 in varchar2 default hr_api.g_varchar2

701: ,p_program_application_id in number default hr_api.g_number
702: ,p_program_id in number default hr_api.g_number
703: ,p_program_update_date in date default hr_api.g_date
704: ,p_attribute_category in varchar2 default hr_api.g_varchar2
705: ,p_attribute1 in varchar2 default hr_api.g_varchar2
706: ,p_attribute2 in varchar2 default hr_api.g_varchar2
707: ,p_attribute3 in varchar2 default hr_api.g_varchar2
708: ,p_attribute4 in varchar2 default hr_api.g_varchar2
709: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 706: ,p_attribute2 in varchar2 default hr_api.g_varchar2

702: ,p_program_id in number default hr_api.g_number
703: ,p_program_update_date in date default hr_api.g_date
704: ,p_attribute_category in varchar2 default hr_api.g_varchar2
705: ,p_attribute1 in varchar2 default hr_api.g_varchar2
706: ,p_attribute2 in varchar2 default hr_api.g_varchar2
707: ,p_attribute3 in varchar2 default hr_api.g_varchar2
708: ,p_attribute4 in varchar2 default hr_api.g_varchar2
709: ,p_attribute5 in varchar2 default hr_api.g_varchar2
710: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 707: ,p_attribute3 in varchar2 default hr_api.g_varchar2

703: ,p_program_update_date in date default hr_api.g_date
704: ,p_attribute_category in varchar2 default hr_api.g_varchar2
705: ,p_attribute1 in varchar2 default hr_api.g_varchar2
706: ,p_attribute2 in varchar2 default hr_api.g_varchar2
707: ,p_attribute3 in varchar2 default hr_api.g_varchar2
708: ,p_attribute4 in varchar2 default hr_api.g_varchar2
709: ,p_attribute5 in varchar2 default hr_api.g_varchar2
710: ,p_attribute6 in varchar2 default hr_api.g_varchar2
711: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 708: ,p_attribute4 in varchar2 default hr_api.g_varchar2

704: ,p_attribute_category in varchar2 default hr_api.g_varchar2
705: ,p_attribute1 in varchar2 default hr_api.g_varchar2
706: ,p_attribute2 in varchar2 default hr_api.g_varchar2
707: ,p_attribute3 in varchar2 default hr_api.g_varchar2
708: ,p_attribute4 in varchar2 default hr_api.g_varchar2
709: ,p_attribute5 in varchar2 default hr_api.g_varchar2
710: ,p_attribute6 in varchar2 default hr_api.g_varchar2
711: ,p_attribute7 in varchar2 default hr_api.g_varchar2
712: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 709: ,p_attribute5 in varchar2 default hr_api.g_varchar2

705: ,p_attribute1 in varchar2 default hr_api.g_varchar2
706: ,p_attribute2 in varchar2 default hr_api.g_varchar2
707: ,p_attribute3 in varchar2 default hr_api.g_varchar2
708: ,p_attribute4 in varchar2 default hr_api.g_varchar2
709: ,p_attribute5 in varchar2 default hr_api.g_varchar2
710: ,p_attribute6 in varchar2 default hr_api.g_varchar2
711: ,p_attribute7 in varchar2 default hr_api.g_varchar2
712: ,p_attribute8 in varchar2 default hr_api.g_varchar2
713: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 710: ,p_attribute6 in varchar2 default hr_api.g_varchar2

706: ,p_attribute2 in varchar2 default hr_api.g_varchar2
707: ,p_attribute3 in varchar2 default hr_api.g_varchar2
708: ,p_attribute4 in varchar2 default hr_api.g_varchar2
709: ,p_attribute5 in varchar2 default hr_api.g_varchar2
710: ,p_attribute6 in varchar2 default hr_api.g_varchar2
711: ,p_attribute7 in varchar2 default hr_api.g_varchar2
712: ,p_attribute8 in varchar2 default hr_api.g_varchar2
713: ,p_attribute9 in varchar2 default hr_api.g_varchar2
714: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 711: ,p_attribute7 in varchar2 default hr_api.g_varchar2

707: ,p_attribute3 in varchar2 default hr_api.g_varchar2
708: ,p_attribute4 in varchar2 default hr_api.g_varchar2
709: ,p_attribute5 in varchar2 default hr_api.g_varchar2
710: ,p_attribute6 in varchar2 default hr_api.g_varchar2
711: ,p_attribute7 in varchar2 default hr_api.g_varchar2
712: ,p_attribute8 in varchar2 default hr_api.g_varchar2
713: ,p_attribute9 in varchar2 default hr_api.g_varchar2
714: ,p_attribute10 in varchar2 default hr_api.g_varchar2
715: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 712: ,p_attribute8 in varchar2 default hr_api.g_varchar2

708: ,p_attribute4 in varchar2 default hr_api.g_varchar2
709: ,p_attribute5 in varchar2 default hr_api.g_varchar2
710: ,p_attribute6 in varchar2 default hr_api.g_varchar2
711: ,p_attribute7 in varchar2 default hr_api.g_varchar2
712: ,p_attribute8 in varchar2 default hr_api.g_varchar2
713: ,p_attribute9 in varchar2 default hr_api.g_varchar2
714: ,p_attribute10 in varchar2 default hr_api.g_varchar2
715: ,p_attribute11 in varchar2 default hr_api.g_varchar2
716: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 713: ,p_attribute9 in varchar2 default hr_api.g_varchar2

709: ,p_attribute5 in varchar2 default hr_api.g_varchar2
710: ,p_attribute6 in varchar2 default hr_api.g_varchar2
711: ,p_attribute7 in varchar2 default hr_api.g_varchar2
712: ,p_attribute8 in varchar2 default hr_api.g_varchar2
713: ,p_attribute9 in varchar2 default hr_api.g_varchar2
714: ,p_attribute10 in varchar2 default hr_api.g_varchar2
715: ,p_attribute11 in varchar2 default hr_api.g_varchar2
716: ,p_attribute12 in varchar2 default hr_api.g_varchar2
717: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 714: ,p_attribute10 in varchar2 default hr_api.g_varchar2

710: ,p_attribute6 in varchar2 default hr_api.g_varchar2
711: ,p_attribute7 in varchar2 default hr_api.g_varchar2
712: ,p_attribute8 in varchar2 default hr_api.g_varchar2
713: ,p_attribute9 in varchar2 default hr_api.g_varchar2
714: ,p_attribute10 in varchar2 default hr_api.g_varchar2
715: ,p_attribute11 in varchar2 default hr_api.g_varchar2
716: ,p_attribute12 in varchar2 default hr_api.g_varchar2
717: ,p_attribute13 in varchar2 default hr_api.g_varchar2
718: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 715: ,p_attribute11 in varchar2 default hr_api.g_varchar2

711: ,p_attribute7 in varchar2 default hr_api.g_varchar2
712: ,p_attribute8 in varchar2 default hr_api.g_varchar2
713: ,p_attribute9 in varchar2 default hr_api.g_varchar2
714: ,p_attribute10 in varchar2 default hr_api.g_varchar2
715: ,p_attribute11 in varchar2 default hr_api.g_varchar2
716: ,p_attribute12 in varchar2 default hr_api.g_varchar2
717: ,p_attribute13 in varchar2 default hr_api.g_varchar2
718: ,p_attribute14 in varchar2 default hr_api.g_varchar2
719: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 716: ,p_attribute12 in varchar2 default hr_api.g_varchar2

712: ,p_attribute8 in varchar2 default hr_api.g_varchar2
713: ,p_attribute9 in varchar2 default hr_api.g_varchar2
714: ,p_attribute10 in varchar2 default hr_api.g_varchar2
715: ,p_attribute11 in varchar2 default hr_api.g_varchar2
716: ,p_attribute12 in varchar2 default hr_api.g_varchar2
717: ,p_attribute13 in varchar2 default hr_api.g_varchar2
718: ,p_attribute14 in varchar2 default hr_api.g_varchar2
719: ,p_attribute15 in varchar2 default hr_api.g_varchar2
720: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 717: ,p_attribute13 in varchar2 default hr_api.g_varchar2

713: ,p_attribute9 in varchar2 default hr_api.g_varchar2
714: ,p_attribute10 in varchar2 default hr_api.g_varchar2
715: ,p_attribute11 in varchar2 default hr_api.g_varchar2
716: ,p_attribute12 in varchar2 default hr_api.g_varchar2
717: ,p_attribute13 in varchar2 default hr_api.g_varchar2
718: ,p_attribute14 in varchar2 default hr_api.g_varchar2
719: ,p_attribute15 in varchar2 default hr_api.g_varchar2
720: ,p_attribute16 in varchar2 default hr_api.g_varchar2
721: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 718: ,p_attribute14 in varchar2 default hr_api.g_varchar2

714: ,p_attribute10 in varchar2 default hr_api.g_varchar2
715: ,p_attribute11 in varchar2 default hr_api.g_varchar2
716: ,p_attribute12 in varchar2 default hr_api.g_varchar2
717: ,p_attribute13 in varchar2 default hr_api.g_varchar2
718: ,p_attribute14 in varchar2 default hr_api.g_varchar2
719: ,p_attribute15 in varchar2 default hr_api.g_varchar2
720: ,p_attribute16 in varchar2 default hr_api.g_varchar2
721: ,p_attribute17 in varchar2 default hr_api.g_varchar2
722: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 719: ,p_attribute15 in varchar2 default hr_api.g_varchar2

715: ,p_attribute11 in varchar2 default hr_api.g_varchar2
716: ,p_attribute12 in varchar2 default hr_api.g_varchar2
717: ,p_attribute13 in varchar2 default hr_api.g_varchar2
718: ,p_attribute14 in varchar2 default hr_api.g_varchar2
719: ,p_attribute15 in varchar2 default hr_api.g_varchar2
720: ,p_attribute16 in varchar2 default hr_api.g_varchar2
721: ,p_attribute17 in varchar2 default hr_api.g_varchar2
722: ,p_attribute18 in varchar2 default hr_api.g_varchar2
723: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 720: ,p_attribute16 in varchar2 default hr_api.g_varchar2

716: ,p_attribute12 in varchar2 default hr_api.g_varchar2
717: ,p_attribute13 in varchar2 default hr_api.g_varchar2
718: ,p_attribute14 in varchar2 default hr_api.g_varchar2
719: ,p_attribute15 in varchar2 default hr_api.g_varchar2
720: ,p_attribute16 in varchar2 default hr_api.g_varchar2
721: ,p_attribute17 in varchar2 default hr_api.g_varchar2
722: ,p_attribute18 in varchar2 default hr_api.g_varchar2
723: ,p_attribute19 in varchar2 default hr_api.g_varchar2
724: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 721: ,p_attribute17 in varchar2 default hr_api.g_varchar2

717: ,p_attribute13 in varchar2 default hr_api.g_varchar2
718: ,p_attribute14 in varchar2 default hr_api.g_varchar2
719: ,p_attribute15 in varchar2 default hr_api.g_varchar2
720: ,p_attribute16 in varchar2 default hr_api.g_varchar2
721: ,p_attribute17 in varchar2 default hr_api.g_varchar2
722: ,p_attribute18 in varchar2 default hr_api.g_varchar2
723: ,p_attribute19 in varchar2 default hr_api.g_varchar2
724: ,p_attribute20 in varchar2 default hr_api.g_varchar2
725: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 722: ,p_attribute18 in varchar2 default hr_api.g_varchar2

718: ,p_attribute14 in varchar2 default hr_api.g_varchar2
719: ,p_attribute15 in varchar2 default hr_api.g_varchar2
720: ,p_attribute16 in varchar2 default hr_api.g_varchar2
721: ,p_attribute17 in varchar2 default hr_api.g_varchar2
722: ,p_attribute18 in varchar2 default hr_api.g_varchar2
723: ,p_attribute19 in varchar2 default hr_api.g_varchar2
724: ,p_attribute20 in varchar2 default hr_api.g_varchar2
725: ,p_information_category in varchar2 default hr_api.g_varchar2
726: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 723: ,p_attribute19 in varchar2 default hr_api.g_varchar2

719: ,p_attribute15 in varchar2 default hr_api.g_varchar2
720: ,p_attribute16 in varchar2 default hr_api.g_varchar2
721: ,p_attribute17 in varchar2 default hr_api.g_varchar2
722: ,p_attribute18 in varchar2 default hr_api.g_varchar2
723: ,p_attribute19 in varchar2 default hr_api.g_varchar2
724: ,p_attribute20 in varchar2 default hr_api.g_varchar2
725: ,p_information_category in varchar2 default hr_api.g_varchar2
726: ,p_information1 in varchar2 default hr_api.g_varchar2
727: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 724: ,p_attribute20 in varchar2 default hr_api.g_varchar2

720: ,p_attribute16 in varchar2 default hr_api.g_varchar2
721: ,p_attribute17 in varchar2 default hr_api.g_varchar2
722: ,p_attribute18 in varchar2 default hr_api.g_varchar2
723: ,p_attribute19 in varchar2 default hr_api.g_varchar2
724: ,p_attribute20 in varchar2 default hr_api.g_varchar2
725: ,p_information_category in varchar2 default hr_api.g_varchar2
726: ,p_information1 in varchar2 default hr_api.g_varchar2
727: ,p_information2 in varchar2 default hr_api.g_varchar2
728: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 725: ,p_information_category in varchar2 default hr_api.g_varchar2

721: ,p_attribute17 in varchar2 default hr_api.g_varchar2
722: ,p_attribute18 in varchar2 default hr_api.g_varchar2
723: ,p_attribute19 in varchar2 default hr_api.g_varchar2
724: ,p_attribute20 in varchar2 default hr_api.g_varchar2
725: ,p_information_category in varchar2 default hr_api.g_varchar2
726: ,p_information1 in varchar2 default hr_api.g_varchar2
727: ,p_information2 in varchar2 default hr_api.g_varchar2
728: ,p_information3 in varchar2 default hr_api.g_varchar2
729: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 726: ,p_information1 in varchar2 default hr_api.g_varchar2

722: ,p_attribute18 in varchar2 default hr_api.g_varchar2
723: ,p_attribute19 in varchar2 default hr_api.g_varchar2
724: ,p_attribute20 in varchar2 default hr_api.g_varchar2
725: ,p_information_category in varchar2 default hr_api.g_varchar2
726: ,p_information1 in varchar2 default hr_api.g_varchar2
727: ,p_information2 in varchar2 default hr_api.g_varchar2
728: ,p_information3 in varchar2 default hr_api.g_varchar2
729: ,p_information4 in varchar2 default hr_api.g_varchar2
730: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 727: ,p_information2 in varchar2 default hr_api.g_varchar2

723: ,p_attribute19 in varchar2 default hr_api.g_varchar2
724: ,p_attribute20 in varchar2 default hr_api.g_varchar2
725: ,p_information_category in varchar2 default hr_api.g_varchar2
726: ,p_information1 in varchar2 default hr_api.g_varchar2
727: ,p_information2 in varchar2 default hr_api.g_varchar2
728: ,p_information3 in varchar2 default hr_api.g_varchar2
729: ,p_information4 in varchar2 default hr_api.g_varchar2
730: ,p_information5 in varchar2 default hr_api.g_varchar2
731: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 728: ,p_information3 in varchar2 default hr_api.g_varchar2

724: ,p_attribute20 in varchar2 default hr_api.g_varchar2
725: ,p_information_category in varchar2 default hr_api.g_varchar2
726: ,p_information1 in varchar2 default hr_api.g_varchar2
727: ,p_information2 in varchar2 default hr_api.g_varchar2
728: ,p_information3 in varchar2 default hr_api.g_varchar2
729: ,p_information4 in varchar2 default hr_api.g_varchar2
730: ,p_information5 in varchar2 default hr_api.g_varchar2
731: ,p_information6 in varchar2 default hr_api.g_varchar2
732: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 729: ,p_information4 in varchar2 default hr_api.g_varchar2

725: ,p_information_category in varchar2 default hr_api.g_varchar2
726: ,p_information1 in varchar2 default hr_api.g_varchar2
727: ,p_information2 in varchar2 default hr_api.g_varchar2
728: ,p_information3 in varchar2 default hr_api.g_varchar2
729: ,p_information4 in varchar2 default hr_api.g_varchar2
730: ,p_information5 in varchar2 default hr_api.g_varchar2
731: ,p_information6 in varchar2 default hr_api.g_varchar2
732: ,p_information7 in varchar2 default hr_api.g_varchar2
733: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 730: ,p_information5 in varchar2 default hr_api.g_varchar2

726: ,p_information1 in varchar2 default hr_api.g_varchar2
727: ,p_information2 in varchar2 default hr_api.g_varchar2
728: ,p_information3 in varchar2 default hr_api.g_varchar2
729: ,p_information4 in varchar2 default hr_api.g_varchar2
730: ,p_information5 in varchar2 default hr_api.g_varchar2
731: ,p_information6 in varchar2 default hr_api.g_varchar2
732: ,p_information7 in varchar2 default hr_api.g_varchar2
733: ,p_information8 in varchar2 default hr_api.g_varchar2
734: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 731: ,p_information6 in varchar2 default hr_api.g_varchar2

727: ,p_information2 in varchar2 default hr_api.g_varchar2
728: ,p_information3 in varchar2 default hr_api.g_varchar2
729: ,p_information4 in varchar2 default hr_api.g_varchar2
730: ,p_information5 in varchar2 default hr_api.g_varchar2
731: ,p_information6 in varchar2 default hr_api.g_varchar2
732: ,p_information7 in varchar2 default hr_api.g_varchar2
733: ,p_information8 in varchar2 default hr_api.g_varchar2
734: ,p_information9 in varchar2 default hr_api.g_varchar2
735: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 732: ,p_information7 in varchar2 default hr_api.g_varchar2

728: ,p_information3 in varchar2 default hr_api.g_varchar2
729: ,p_information4 in varchar2 default hr_api.g_varchar2
730: ,p_information5 in varchar2 default hr_api.g_varchar2
731: ,p_information6 in varchar2 default hr_api.g_varchar2
732: ,p_information7 in varchar2 default hr_api.g_varchar2
733: ,p_information8 in varchar2 default hr_api.g_varchar2
734: ,p_information9 in varchar2 default hr_api.g_varchar2
735: ,p_information10 in varchar2 default hr_api.g_varchar2
736: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 733: ,p_information8 in varchar2 default hr_api.g_varchar2

729: ,p_information4 in varchar2 default hr_api.g_varchar2
730: ,p_information5 in varchar2 default hr_api.g_varchar2
731: ,p_information6 in varchar2 default hr_api.g_varchar2
732: ,p_information7 in varchar2 default hr_api.g_varchar2
733: ,p_information8 in varchar2 default hr_api.g_varchar2
734: ,p_information9 in varchar2 default hr_api.g_varchar2
735: ,p_information10 in varchar2 default hr_api.g_varchar2
736: ,p_information11 in varchar2 default hr_api.g_varchar2
737: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 734: ,p_information9 in varchar2 default hr_api.g_varchar2

730: ,p_information5 in varchar2 default hr_api.g_varchar2
731: ,p_information6 in varchar2 default hr_api.g_varchar2
732: ,p_information7 in varchar2 default hr_api.g_varchar2
733: ,p_information8 in varchar2 default hr_api.g_varchar2
734: ,p_information9 in varchar2 default hr_api.g_varchar2
735: ,p_information10 in varchar2 default hr_api.g_varchar2
736: ,p_information11 in varchar2 default hr_api.g_varchar2
737: ,p_information12 in varchar2 default hr_api.g_varchar2
738: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 735: ,p_information10 in varchar2 default hr_api.g_varchar2

731: ,p_information6 in varchar2 default hr_api.g_varchar2
732: ,p_information7 in varchar2 default hr_api.g_varchar2
733: ,p_information8 in varchar2 default hr_api.g_varchar2
734: ,p_information9 in varchar2 default hr_api.g_varchar2
735: ,p_information10 in varchar2 default hr_api.g_varchar2
736: ,p_information11 in varchar2 default hr_api.g_varchar2
737: ,p_information12 in varchar2 default hr_api.g_varchar2
738: ,p_information13 in varchar2 default hr_api.g_varchar2
739: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 736: ,p_information11 in varchar2 default hr_api.g_varchar2

732: ,p_information7 in varchar2 default hr_api.g_varchar2
733: ,p_information8 in varchar2 default hr_api.g_varchar2
734: ,p_information9 in varchar2 default hr_api.g_varchar2
735: ,p_information10 in varchar2 default hr_api.g_varchar2
736: ,p_information11 in varchar2 default hr_api.g_varchar2
737: ,p_information12 in varchar2 default hr_api.g_varchar2
738: ,p_information13 in varchar2 default hr_api.g_varchar2
739: ,p_information14 in varchar2 default hr_api.g_varchar2
740: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 737: ,p_information12 in varchar2 default hr_api.g_varchar2

733: ,p_information8 in varchar2 default hr_api.g_varchar2
734: ,p_information9 in varchar2 default hr_api.g_varchar2
735: ,p_information10 in varchar2 default hr_api.g_varchar2
736: ,p_information11 in varchar2 default hr_api.g_varchar2
737: ,p_information12 in varchar2 default hr_api.g_varchar2
738: ,p_information13 in varchar2 default hr_api.g_varchar2
739: ,p_information14 in varchar2 default hr_api.g_varchar2
740: ,p_information15 in varchar2 default hr_api.g_varchar2
741: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 738: ,p_information13 in varchar2 default hr_api.g_varchar2

734: ,p_information9 in varchar2 default hr_api.g_varchar2
735: ,p_information10 in varchar2 default hr_api.g_varchar2
736: ,p_information11 in varchar2 default hr_api.g_varchar2
737: ,p_information12 in varchar2 default hr_api.g_varchar2
738: ,p_information13 in varchar2 default hr_api.g_varchar2
739: ,p_information14 in varchar2 default hr_api.g_varchar2
740: ,p_information15 in varchar2 default hr_api.g_varchar2
741: ,p_information16 in varchar2 default hr_api.g_varchar2
742: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 739: ,p_information14 in varchar2 default hr_api.g_varchar2

735: ,p_information10 in varchar2 default hr_api.g_varchar2
736: ,p_information11 in varchar2 default hr_api.g_varchar2
737: ,p_information12 in varchar2 default hr_api.g_varchar2
738: ,p_information13 in varchar2 default hr_api.g_varchar2
739: ,p_information14 in varchar2 default hr_api.g_varchar2
740: ,p_information15 in varchar2 default hr_api.g_varchar2
741: ,p_information16 in varchar2 default hr_api.g_varchar2
742: ,p_information17 in varchar2 default hr_api.g_varchar2
743: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 740: ,p_information15 in varchar2 default hr_api.g_varchar2

736: ,p_information11 in varchar2 default hr_api.g_varchar2
737: ,p_information12 in varchar2 default hr_api.g_varchar2
738: ,p_information13 in varchar2 default hr_api.g_varchar2
739: ,p_information14 in varchar2 default hr_api.g_varchar2
740: ,p_information15 in varchar2 default hr_api.g_varchar2
741: ,p_information16 in varchar2 default hr_api.g_varchar2
742: ,p_information17 in varchar2 default hr_api.g_varchar2
743: ,p_information18 in varchar2 default hr_api.g_varchar2
744: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 741: ,p_information16 in varchar2 default hr_api.g_varchar2

737: ,p_information12 in varchar2 default hr_api.g_varchar2
738: ,p_information13 in varchar2 default hr_api.g_varchar2
739: ,p_information14 in varchar2 default hr_api.g_varchar2
740: ,p_information15 in varchar2 default hr_api.g_varchar2
741: ,p_information16 in varchar2 default hr_api.g_varchar2
742: ,p_information17 in varchar2 default hr_api.g_varchar2
743: ,p_information18 in varchar2 default hr_api.g_varchar2
744: ,p_information19 in varchar2 default hr_api.g_varchar2
745: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 742: ,p_information17 in varchar2 default hr_api.g_varchar2

738: ,p_information13 in varchar2 default hr_api.g_varchar2
739: ,p_information14 in varchar2 default hr_api.g_varchar2
740: ,p_information15 in varchar2 default hr_api.g_varchar2
741: ,p_information16 in varchar2 default hr_api.g_varchar2
742: ,p_information17 in varchar2 default hr_api.g_varchar2
743: ,p_information18 in varchar2 default hr_api.g_varchar2
744: ,p_information19 in varchar2 default hr_api.g_varchar2
745: ,p_information20 in varchar2 default hr_api.g_varchar2
746: ,p_last_update_date in date default hr_api.g_date

Line 743: ,p_information18 in varchar2 default hr_api.g_varchar2

739: ,p_information14 in varchar2 default hr_api.g_varchar2
740: ,p_information15 in varchar2 default hr_api.g_varchar2
741: ,p_information16 in varchar2 default hr_api.g_varchar2
742: ,p_information17 in varchar2 default hr_api.g_varchar2
743: ,p_information18 in varchar2 default hr_api.g_varchar2
744: ,p_information19 in varchar2 default hr_api.g_varchar2
745: ,p_information20 in varchar2 default hr_api.g_varchar2
746: ,p_last_update_date in date default hr_api.g_date
747: ,p_last_updated_by in number default hr_api.g_number

Line 744: ,p_information19 in varchar2 default hr_api.g_varchar2

740: ,p_information15 in varchar2 default hr_api.g_varchar2
741: ,p_information16 in varchar2 default hr_api.g_varchar2
742: ,p_information17 in varchar2 default hr_api.g_varchar2
743: ,p_information18 in varchar2 default hr_api.g_varchar2
744: ,p_information19 in varchar2 default hr_api.g_varchar2
745: ,p_information20 in varchar2 default hr_api.g_varchar2
746: ,p_last_update_date in date default hr_api.g_date
747: ,p_last_updated_by in number default hr_api.g_number
748: ,p_last_update_login in number default hr_api.g_number

Line 745: ,p_information20 in varchar2 default hr_api.g_varchar2

741: ,p_information16 in varchar2 default hr_api.g_varchar2
742: ,p_information17 in varchar2 default hr_api.g_varchar2
743: ,p_information18 in varchar2 default hr_api.g_varchar2
744: ,p_information19 in varchar2 default hr_api.g_varchar2
745: ,p_information20 in varchar2 default hr_api.g_varchar2
746: ,p_last_update_date in date default hr_api.g_date
747: ,p_last_updated_by in number default hr_api.g_number
748: ,p_last_update_login in number default hr_api.g_number
749: ,p_created_by in number default hr_api.g_number

Line 746: ,p_last_update_date in date default hr_api.g_date

742: ,p_information17 in varchar2 default hr_api.g_varchar2
743: ,p_information18 in varchar2 default hr_api.g_varchar2
744: ,p_information19 in varchar2 default hr_api.g_varchar2
745: ,p_information20 in varchar2 default hr_api.g_varchar2
746: ,p_last_update_date in date default hr_api.g_date
747: ,p_last_updated_by in number default hr_api.g_number
748: ,p_last_update_login in number default hr_api.g_number
749: ,p_created_by in number default hr_api.g_number
750: ,p_creation_date in date default hr_api.g_date

Line 747: ,p_last_updated_by in number default hr_api.g_number

743: ,p_information18 in varchar2 default hr_api.g_varchar2
744: ,p_information19 in varchar2 default hr_api.g_varchar2
745: ,p_information20 in varchar2 default hr_api.g_varchar2
746: ,p_last_update_date in date default hr_api.g_date
747: ,p_last_updated_by in number default hr_api.g_number
748: ,p_last_update_login in number default hr_api.g_number
749: ,p_created_by in number default hr_api.g_number
750: ,p_creation_date in date default hr_api.g_date
751: ,p_segment1 in varchar2 default hr_api.g_varchar2

Line 748: ,p_last_update_login in number default hr_api.g_number

744: ,p_information19 in varchar2 default hr_api.g_varchar2
745: ,p_information20 in varchar2 default hr_api.g_varchar2
746: ,p_last_update_date in date default hr_api.g_date
747: ,p_last_updated_by in number default hr_api.g_number
748: ,p_last_update_login in number default hr_api.g_number
749: ,p_created_by in number default hr_api.g_number
750: ,p_creation_date in date default hr_api.g_date
751: ,p_segment1 in varchar2 default hr_api.g_varchar2
752: ,p_segment2 in varchar2 default hr_api.g_varchar2

Line 749: ,p_created_by in number default hr_api.g_number

745: ,p_information20 in varchar2 default hr_api.g_varchar2
746: ,p_last_update_date in date default hr_api.g_date
747: ,p_last_updated_by in number default hr_api.g_number
748: ,p_last_update_login in number default hr_api.g_number
749: ,p_created_by in number default hr_api.g_number
750: ,p_creation_date in date default hr_api.g_date
751: ,p_segment1 in varchar2 default hr_api.g_varchar2
752: ,p_segment2 in varchar2 default hr_api.g_varchar2
753: ,p_segment3 in varchar2 default hr_api.g_varchar2

Line 750: ,p_creation_date in date default hr_api.g_date

746: ,p_last_update_date in date default hr_api.g_date
747: ,p_last_updated_by in number default hr_api.g_number
748: ,p_last_update_login in number default hr_api.g_number
749: ,p_created_by in number default hr_api.g_number
750: ,p_creation_date in date default hr_api.g_date
751: ,p_segment1 in varchar2 default hr_api.g_varchar2
752: ,p_segment2 in varchar2 default hr_api.g_varchar2
753: ,p_segment3 in varchar2 default hr_api.g_varchar2
754: ,p_segment4 in varchar2 default hr_api.g_varchar2

Line 751: ,p_segment1 in varchar2 default hr_api.g_varchar2

747: ,p_last_updated_by in number default hr_api.g_number
748: ,p_last_update_login in number default hr_api.g_number
749: ,p_created_by in number default hr_api.g_number
750: ,p_creation_date in date default hr_api.g_date
751: ,p_segment1 in varchar2 default hr_api.g_varchar2
752: ,p_segment2 in varchar2 default hr_api.g_varchar2
753: ,p_segment3 in varchar2 default hr_api.g_varchar2
754: ,p_segment4 in varchar2 default hr_api.g_varchar2
755: ,p_segment5 in varchar2 default hr_api.g_varchar2

Line 752: ,p_segment2 in varchar2 default hr_api.g_varchar2

748: ,p_last_update_login in number default hr_api.g_number
749: ,p_created_by in number default hr_api.g_number
750: ,p_creation_date in date default hr_api.g_date
751: ,p_segment1 in varchar2 default hr_api.g_varchar2
752: ,p_segment2 in varchar2 default hr_api.g_varchar2
753: ,p_segment3 in varchar2 default hr_api.g_varchar2
754: ,p_segment4 in varchar2 default hr_api.g_varchar2
755: ,p_segment5 in varchar2 default hr_api.g_varchar2
756: ,p_segment6 in varchar2 default hr_api.g_varchar2

Line 753: ,p_segment3 in varchar2 default hr_api.g_varchar2

749: ,p_created_by in number default hr_api.g_number
750: ,p_creation_date in date default hr_api.g_date
751: ,p_segment1 in varchar2 default hr_api.g_varchar2
752: ,p_segment2 in varchar2 default hr_api.g_varchar2
753: ,p_segment3 in varchar2 default hr_api.g_varchar2
754: ,p_segment4 in varchar2 default hr_api.g_varchar2
755: ,p_segment5 in varchar2 default hr_api.g_varchar2
756: ,p_segment6 in varchar2 default hr_api.g_varchar2
757: ,p_segment7 in varchar2 default hr_api.g_varchar2

Line 754: ,p_segment4 in varchar2 default hr_api.g_varchar2

750: ,p_creation_date in date default hr_api.g_date
751: ,p_segment1 in varchar2 default hr_api.g_varchar2
752: ,p_segment2 in varchar2 default hr_api.g_varchar2
753: ,p_segment3 in varchar2 default hr_api.g_varchar2
754: ,p_segment4 in varchar2 default hr_api.g_varchar2
755: ,p_segment5 in varchar2 default hr_api.g_varchar2
756: ,p_segment6 in varchar2 default hr_api.g_varchar2
757: ,p_segment7 in varchar2 default hr_api.g_varchar2
758: ,p_segment8 in varchar2 default hr_api.g_varchar2

Line 755: ,p_segment5 in varchar2 default hr_api.g_varchar2

751: ,p_segment1 in varchar2 default hr_api.g_varchar2
752: ,p_segment2 in varchar2 default hr_api.g_varchar2
753: ,p_segment3 in varchar2 default hr_api.g_varchar2
754: ,p_segment4 in varchar2 default hr_api.g_varchar2
755: ,p_segment5 in varchar2 default hr_api.g_varchar2
756: ,p_segment6 in varchar2 default hr_api.g_varchar2
757: ,p_segment7 in varchar2 default hr_api.g_varchar2
758: ,p_segment8 in varchar2 default hr_api.g_varchar2
759: ,p_segment9 in varchar2 default hr_api.g_varchar2

Line 756: ,p_segment6 in varchar2 default hr_api.g_varchar2

752: ,p_segment2 in varchar2 default hr_api.g_varchar2
753: ,p_segment3 in varchar2 default hr_api.g_varchar2
754: ,p_segment4 in varchar2 default hr_api.g_varchar2
755: ,p_segment5 in varchar2 default hr_api.g_varchar2
756: ,p_segment6 in varchar2 default hr_api.g_varchar2
757: ,p_segment7 in varchar2 default hr_api.g_varchar2
758: ,p_segment8 in varchar2 default hr_api.g_varchar2
759: ,p_segment9 in varchar2 default hr_api.g_varchar2
760: ,p_segment10 in varchar2 default hr_api.g_varchar2

Line 757: ,p_segment7 in varchar2 default hr_api.g_varchar2

753: ,p_segment3 in varchar2 default hr_api.g_varchar2
754: ,p_segment4 in varchar2 default hr_api.g_varchar2
755: ,p_segment5 in varchar2 default hr_api.g_varchar2
756: ,p_segment6 in varchar2 default hr_api.g_varchar2
757: ,p_segment7 in varchar2 default hr_api.g_varchar2
758: ,p_segment8 in varchar2 default hr_api.g_varchar2
759: ,p_segment9 in varchar2 default hr_api.g_varchar2
760: ,p_segment10 in varchar2 default hr_api.g_varchar2
761: ,p_segment11 in varchar2 default hr_api.g_varchar2

Line 758: ,p_segment8 in varchar2 default hr_api.g_varchar2

754: ,p_segment4 in varchar2 default hr_api.g_varchar2
755: ,p_segment5 in varchar2 default hr_api.g_varchar2
756: ,p_segment6 in varchar2 default hr_api.g_varchar2
757: ,p_segment7 in varchar2 default hr_api.g_varchar2
758: ,p_segment8 in varchar2 default hr_api.g_varchar2
759: ,p_segment9 in varchar2 default hr_api.g_varchar2
760: ,p_segment10 in varchar2 default hr_api.g_varchar2
761: ,p_segment11 in varchar2 default hr_api.g_varchar2
762: ,p_segment12 in varchar2 default hr_api.g_varchar2

Line 759: ,p_segment9 in varchar2 default hr_api.g_varchar2

755: ,p_segment5 in varchar2 default hr_api.g_varchar2
756: ,p_segment6 in varchar2 default hr_api.g_varchar2
757: ,p_segment7 in varchar2 default hr_api.g_varchar2
758: ,p_segment8 in varchar2 default hr_api.g_varchar2
759: ,p_segment9 in varchar2 default hr_api.g_varchar2
760: ,p_segment10 in varchar2 default hr_api.g_varchar2
761: ,p_segment11 in varchar2 default hr_api.g_varchar2
762: ,p_segment12 in varchar2 default hr_api.g_varchar2
763: ,p_segment13 in varchar2 default hr_api.g_varchar2

Line 760: ,p_segment10 in varchar2 default hr_api.g_varchar2

756: ,p_segment6 in varchar2 default hr_api.g_varchar2
757: ,p_segment7 in varchar2 default hr_api.g_varchar2
758: ,p_segment8 in varchar2 default hr_api.g_varchar2
759: ,p_segment9 in varchar2 default hr_api.g_varchar2
760: ,p_segment10 in varchar2 default hr_api.g_varchar2
761: ,p_segment11 in varchar2 default hr_api.g_varchar2
762: ,p_segment12 in varchar2 default hr_api.g_varchar2
763: ,p_segment13 in varchar2 default hr_api.g_varchar2
764: ,p_segment14 in varchar2 default hr_api.g_varchar2

Line 761: ,p_segment11 in varchar2 default hr_api.g_varchar2

757: ,p_segment7 in varchar2 default hr_api.g_varchar2
758: ,p_segment8 in varchar2 default hr_api.g_varchar2
759: ,p_segment9 in varchar2 default hr_api.g_varchar2
760: ,p_segment10 in varchar2 default hr_api.g_varchar2
761: ,p_segment11 in varchar2 default hr_api.g_varchar2
762: ,p_segment12 in varchar2 default hr_api.g_varchar2
763: ,p_segment13 in varchar2 default hr_api.g_varchar2
764: ,p_segment14 in varchar2 default hr_api.g_varchar2
765: ,p_segment15 in varchar2 default hr_api.g_varchar2

Line 762: ,p_segment12 in varchar2 default hr_api.g_varchar2

758: ,p_segment8 in varchar2 default hr_api.g_varchar2
759: ,p_segment9 in varchar2 default hr_api.g_varchar2
760: ,p_segment10 in varchar2 default hr_api.g_varchar2
761: ,p_segment11 in varchar2 default hr_api.g_varchar2
762: ,p_segment12 in varchar2 default hr_api.g_varchar2
763: ,p_segment13 in varchar2 default hr_api.g_varchar2
764: ,p_segment14 in varchar2 default hr_api.g_varchar2
765: ,p_segment15 in varchar2 default hr_api.g_varchar2
766: ,p_segment16 in varchar2 default hr_api.g_varchar2

Line 763: ,p_segment13 in varchar2 default hr_api.g_varchar2

759: ,p_segment9 in varchar2 default hr_api.g_varchar2
760: ,p_segment10 in varchar2 default hr_api.g_varchar2
761: ,p_segment11 in varchar2 default hr_api.g_varchar2
762: ,p_segment12 in varchar2 default hr_api.g_varchar2
763: ,p_segment13 in varchar2 default hr_api.g_varchar2
764: ,p_segment14 in varchar2 default hr_api.g_varchar2
765: ,p_segment15 in varchar2 default hr_api.g_varchar2
766: ,p_segment16 in varchar2 default hr_api.g_varchar2
767: ,p_segment17 in varchar2 default hr_api.g_varchar2

Line 764: ,p_segment14 in varchar2 default hr_api.g_varchar2

760: ,p_segment10 in varchar2 default hr_api.g_varchar2
761: ,p_segment11 in varchar2 default hr_api.g_varchar2
762: ,p_segment12 in varchar2 default hr_api.g_varchar2
763: ,p_segment13 in varchar2 default hr_api.g_varchar2
764: ,p_segment14 in varchar2 default hr_api.g_varchar2
765: ,p_segment15 in varchar2 default hr_api.g_varchar2
766: ,p_segment16 in varchar2 default hr_api.g_varchar2
767: ,p_segment17 in varchar2 default hr_api.g_varchar2
768: ,p_segment18 in varchar2 default hr_api.g_varchar2

Line 765: ,p_segment15 in varchar2 default hr_api.g_varchar2

761: ,p_segment11 in varchar2 default hr_api.g_varchar2
762: ,p_segment12 in varchar2 default hr_api.g_varchar2
763: ,p_segment13 in varchar2 default hr_api.g_varchar2
764: ,p_segment14 in varchar2 default hr_api.g_varchar2
765: ,p_segment15 in varchar2 default hr_api.g_varchar2
766: ,p_segment16 in varchar2 default hr_api.g_varchar2
767: ,p_segment17 in varchar2 default hr_api.g_varchar2
768: ,p_segment18 in varchar2 default hr_api.g_varchar2
769: ,p_segment19 in varchar2 default hr_api.g_varchar2

Line 766: ,p_segment16 in varchar2 default hr_api.g_varchar2

762: ,p_segment12 in varchar2 default hr_api.g_varchar2
763: ,p_segment13 in varchar2 default hr_api.g_varchar2
764: ,p_segment14 in varchar2 default hr_api.g_varchar2
765: ,p_segment15 in varchar2 default hr_api.g_varchar2
766: ,p_segment16 in varchar2 default hr_api.g_varchar2
767: ,p_segment17 in varchar2 default hr_api.g_varchar2
768: ,p_segment18 in varchar2 default hr_api.g_varchar2
769: ,p_segment19 in varchar2 default hr_api.g_varchar2
770: ,p_segment20 in varchar2 default hr_api.g_varchar2

Line 767: ,p_segment17 in varchar2 default hr_api.g_varchar2

763: ,p_segment13 in varchar2 default hr_api.g_varchar2
764: ,p_segment14 in varchar2 default hr_api.g_varchar2
765: ,p_segment15 in varchar2 default hr_api.g_varchar2
766: ,p_segment16 in varchar2 default hr_api.g_varchar2
767: ,p_segment17 in varchar2 default hr_api.g_varchar2
768: ,p_segment18 in varchar2 default hr_api.g_varchar2
769: ,p_segment19 in varchar2 default hr_api.g_varchar2
770: ,p_segment20 in varchar2 default hr_api.g_varchar2
771: ,p_segment21 in varchar2 default hr_api.g_varchar2

Line 768: ,p_segment18 in varchar2 default hr_api.g_varchar2

764: ,p_segment14 in varchar2 default hr_api.g_varchar2
765: ,p_segment15 in varchar2 default hr_api.g_varchar2
766: ,p_segment16 in varchar2 default hr_api.g_varchar2
767: ,p_segment17 in varchar2 default hr_api.g_varchar2
768: ,p_segment18 in varchar2 default hr_api.g_varchar2
769: ,p_segment19 in varchar2 default hr_api.g_varchar2
770: ,p_segment20 in varchar2 default hr_api.g_varchar2
771: ,p_segment21 in varchar2 default hr_api.g_varchar2
772: ,p_segment22 in varchar2 default hr_api.g_varchar2

Line 769: ,p_segment19 in varchar2 default hr_api.g_varchar2

765: ,p_segment15 in varchar2 default hr_api.g_varchar2
766: ,p_segment16 in varchar2 default hr_api.g_varchar2
767: ,p_segment17 in varchar2 default hr_api.g_varchar2
768: ,p_segment18 in varchar2 default hr_api.g_varchar2
769: ,p_segment19 in varchar2 default hr_api.g_varchar2
770: ,p_segment20 in varchar2 default hr_api.g_varchar2
771: ,p_segment21 in varchar2 default hr_api.g_varchar2
772: ,p_segment22 in varchar2 default hr_api.g_varchar2
773: ,p_segment23 in varchar2 default hr_api.g_varchar2

Line 770: ,p_segment20 in varchar2 default hr_api.g_varchar2

766: ,p_segment16 in varchar2 default hr_api.g_varchar2
767: ,p_segment17 in varchar2 default hr_api.g_varchar2
768: ,p_segment18 in varchar2 default hr_api.g_varchar2
769: ,p_segment19 in varchar2 default hr_api.g_varchar2
770: ,p_segment20 in varchar2 default hr_api.g_varchar2
771: ,p_segment21 in varchar2 default hr_api.g_varchar2
772: ,p_segment22 in varchar2 default hr_api.g_varchar2
773: ,p_segment23 in varchar2 default hr_api.g_varchar2
774: ,p_segment24 in varchar2 default hr_api.g_varchar2

Line 771: ,p_segment21 in varchar2 default hr_api.g_varchar2

767: ,p_segment17 in varchar2 default hr_api.g_varchar2
768: ,p_segment18 in varchar2 default hr_api.g_varchar2
769: ,p_segment19 in varchar2 default hr_api.g_varchar2
770: ,p_segment20 in varchar2 default hr_api.g_varchar2
771: ,p_segment21 in varchar2 default hr_api.g_varchar2
772: ,p_segment22 in varchar2 default hr_api.g_varchar2
773: ,p_segment23 in varchar2 default hr_api.g_varchar2
774: ,p_segment24 in varchar2 default hr_api.g_varchar2
775: ,p_segment25 in varchar2 default hr_api.g_varchar2

Line 772: ,p_segment22 in varchar2 default hr_api.g_varchar2

768: ,p_segment18 in varchar2 default hr_api.g_varchar2
769: ,p_segment19 in varchar2 default hr_api.g_varchar2
770: ,p_segment20 in varchar2 default hr_api.g_varchar2
771: ,p_segment21 in varchar2 default hr_api.g_varchar2
772: ,p_segment22 in varchar2 default hr_api.g_varchar2
773: ,p_segment23 in varchar2 default hr_api.g_varchar2
774: ,p_segment24 in varchar2 default hr_api.g_varchar2
775: ,p_segment25 in varchar2 default hr_api.g_varchar2
776: ,p_segment26 in varchar2 default hr_api.g_varchar2

Line 773: ,p_segment23 in varchar2 default hr_api.g_varchar2

769: ,p_segment19 in varchar2 default hr_api.g_varchar2
770: ,p_segment20 in varchar2 default hr_api.g_varchar2
771: ,p_segment21 in varchar2 default hr_api.g_varchar2
772: ,p_segment22 in varchar2 default hr_api.g_varchar2
773: ,p_segment23 in varchar2 default hr_api.g_varchar2
774: ,p_segment24 in varchar2 default hr_api.g_varchar2
775: ,p_segment25 in varchar2 default hr_api.g_varchar2
776: ,p_segment26 in varchar2 default hr_api.g_varchar2
777: ,p_segment27 in varchar2 default hr_api.g_varchar2

Line 774: ,p_segment24 in varchar2 default hr_api.g_varchar2

770: ,p_segment20 in varchar2 default hr_api.g_varchar2
771: ,p_segment21 in varchar2 default hr_api.g_varchar2
772: ,p_segment22 in varchar2 default hr_api.g_varchar2
773: ,p_segment23 in varchar2 default hr_api.g_varchar2
774: ,p_segment24 in varchar2 default hr_api.g_varchar2
775: ,p_segment25 in varchar2 default hr_api.g_varchar2
776: ,p_segment26 in varchar2 default hr_api.g_varchar2
777: ,p_segment27 in varchar2 default hr_api.g_varchar2
778: ,p_segment28 in varchar2 default hr_api.g_varchar2

Line 775: ,p_segment25 in varchar2 default hr_api.g_varchar2

771: ,p_segment21 in varchar2 default hr_api.g_varchar2
772: ,p_segment22 in varchar2 default hr_api.g_varchar2
773: ,p_segment23 in varchar2 default hr_api.g_varchar2
774: ,p_segment24 in varchar2 default hr_api.g_varchar2
775: ,p_segment25 in varchar2 default hr_api.g_varchar2
776: ,p_segment26 in varchar2 default hr_api.g_varchar2
777: ,p_segment27 in varchar2 default hr_api.g_varchar2
778: ,p_segment28 in varchar2 default hr_api.g_varchar2
779: ,p_segment29 in varchar2 default hr_api.g_varchar2

Line 776: ,p_segment26 in varchar2 default hr_api.g_varchar2

772: ,p_segment22 in varchar2 default hr_api.g_varchar2
773: ,p_segment23 in varchar2 default hr_api.g_varchar2
774: ,p_segment24 in varchar2 default hr_api.g_varchar2
775: ,p_segment25 in varchar2 default hr_api.g_varchar2
776: ,p_segment26 in varchar2 default hr_api.g_varchar2
777: ,p_segment27 in varchar2 default hr_api.g_varchar2
778: ,p_segment28 in varchar2 default hr_api.g_varchar2
779: ,p_segment29 in varchar2 default hr_api.g_varchar2
780: ,p_segment30 in varchar2 default hr_api.g_varchar2

Line 777: ,p_segment27 in varchar2 default hr_api.g_varchar2

773: ,p_segment23 in varchar2 default hr_api.g_varchar2
774: ,p_segment24 in varchar2 default hr_api.g_varchar2
775: ,p_segment25 in varchar2 default hr_api.g_varchar2
776: ,p_segment26 in varchar2 default hr_api.g_varchar2
777: ,p_segment27 in varchar2 default hr_api.g_varchar2
778: ,p_segment28 in varchar2 default hr_api.g_varchar2
779: ,p_segment29 in varchar2 default hr_api.g_varchar2
780: ,p_segment30 in varchar2 default hr_api.g_varchar2
781: ,p_language_code in varchar2 default hr_api.userenv_lang

Line 778: ,p_segment28 in varchar2 default hr_api.g_varchar2

774: ,p_segment24 in varchar2 default hr_api.g_varchar2
775: ,p_segment25 in varchar2 default hr_api.g_varchar2
776: ,p_segment26 in varchar2 default hr_api.g_varchar2
777: ,p_segment27 in varchar2 default hr_api.g_varchar2
778: ,p_segment28 in varchar2 default hr_api.g_varchar2
779: ,p_segment29 in varchar2 default hr_api.g_varchar2
780: ,p_segment30 in varchar2 default hr_api.g_varchar2
781: ,p_language_code in varchar2 default hr_api.userenv_lang
782: ,p_short_name in varchar2 default hr_api.g_varchar2

Line 779: ,p_segment29 in varchar2 default hr_api.g_varchar2

775: ,p_segment25 in varchar2 default hr_api.g_varchar2
776: ,p_segment26 in varchar2 default hr_api.g_varchar2
777: ,p_segment27 in varchar2 default hr_api.g_varchar2
778: ,p_segment28 in varchar2 default hr_api.g_varchar2
779: ,p_segment29 in varchar2 default hr_api.g_varchar2
780: ,p_segment30 in varchar2 default hr_api.g_varchar2
781: ,p_language_code in varchar2 default hr_api.userenv_lang
782: ,p_short_name in varchar2 default hr_api.g_varchar2
783: ,p_concat_segments in out nocopy varchar2

Line 780: ,p_segment30 in varchar2 default hr_api.g_varchar2

776: ,p_segment26 in varchar2 default hr_api.g_varchar2
777: ,p_segment27 in varchar2 default hr_api.g_varchar2
778: ,p_segment28 in varchar2 default hr_api.g_varchar2
779: ,p_segment29 in varchar2 default hr_api.g_varchar2
780: ,p_segment30 in varchar2 default hr_api.g_varchar2
781: ,p_language_code in varchar2 default hr_api.userenv_lang
782: ,p_short_name in varchar2 default hr_api.g_varchar2
783: ,p_concat_segments in out nocopy varchar2
784: ,p_name in out nocopy varchar2

Line 781: ,p_language_code in varchar2 default hr_api.userenv_lang

777: ,p_segment27 in varchar2 default hr_api.g_varchar2
778: ,p_segment28 in varchar2 default hr_api.g_varchar2
779: ,p_segment29 in varchar2 default hr_api.g_varchar2
780: ,p_segment30 in varchar2 default hr_api.g_varchar2
781: ,p_language_code in varchar2 default hr_api.userenv_lang
782: ,p_short_name in varchar2 default hr_api.g_varchar2
783: ,p_concat_segments in out nocopy varchar2
784: ,p_name in out nocopy varchar2
785: ,p_object_version_number in out nocopy number

Line 782: ,p_short_name in varchar2 default hr_api.g_varchar2

778: ,p_segment28 in varchar2 default hr_api.g_varchar2
779: ,p_segment29 in varchar2 default hr_api.g_varchar2
780: ,p_segment30 in varchar2 default hr_api.g_varchar2
781: ,p_language_code in varchar2 default hr_api.userenv_lang
782: ,p_short_name in varchar2 default hr_api.g_varchar2
783: ,p_concat_segments in out nocopy varchar2
784: ,p_name in out nocopy varchar2
785: ,p_object_version_number in out nocopy number
786: ,p_grade_definition_id in out nocopy number

Line 899: hr_api.validate_language_code(p_language_code => l_language_code);

895: --
896: -- Validate the language parameter. l_language_code should be passed
897: -- instead of p_language_code from now on, to allow an IN OUT parameter to
898: -- be passed through.
899: hr_api.validate_language_code(p_language_code => l_language_code);
900: --
901: l_grade_definition_id := p_grade_definition_id;
902: l_object_version_number := p_object_version_number;
903: --

Line 1083: when hr_api.cannot_find_prog_unit then

1079: ,p_grade_definition_id => p_grade_definition_id);
1080: --
1081: exception
1082: --
1083: when hr_api.cannot_find_prog_unit then
1084: hr_api.cannot_find_prog_unit_error(
1085: p_module_name => 'UPDATE_GRADE'
1086: ,p_hook_type => 'BP');
1087: --

Line 1084: hr_api.cannot_find_prog_unit_error(

1080: --
1081: exception
1082: --
1083: when hr_api.cannot_find_prog_unit then
1084: hr_api.cannot_find_prog_unit_error(
1085: p_module_name => 'UPDATE_GRADE'
1086: ,p_hook_type => 'BP');
1087: --
1088: end; -- End of API User Hook for the before hook of update_grade

Line 1255: if p_date_from <> hr_api.g_date then

1251: IF l_exists = 'Y' THEN
1252:
1253: l_date_to_old := l_date_to;
1254:
1255: if p_date_from <> hr_api.g_date then
1256: l_date_from := p_date_from;
1257: end if;
1258:
1259: if p_date_to <> hr_api.g_date then

Line 1259: if p_date_to <> hr_api.g_date then

1255: if p_date_from <> hr_api.g_date then
1256: l_date_from := p_date_from;
1257: end if;
1258:
1259: if p_date_to <> hr_api.g_date then
1260: l_date_to := p_date_to;
1261: end if;
1262:
1263: per_grades_pkg.postup2(p_grade_id,

Line 1374: when hr_api.cannot_find_prog_unit then

1370: ,p_effective_date => p_effective_date);
1371: --
1372: exception
1373: --
1374: when hr_api.cannot_find_prog_unit then
1375: hr_api.cannot_find_prog_unit_error(
1376: p_module_name => 'UPDATE_GRADE'
1377: ,p_hook_type => 'AP');
1378: end; -- End of API User Hook for the after hook of update_grade

Line 1375: hr_api.cannot_find_prog_unit_error(

1371: --
1372: exception
1373: --
1374: when hr_api.cannot_find_prog_unit then
1375: hr_api.cannot_find_prog_unit_error(
1376: p_module_name => 'UPDATE_GRADE'
1377: ,p_hook_type => 'AP');
1378: end; -- End of API User Hook for the after hook of update_grade
1379: --

Line 1384: raise hr_api.validate_enabled;

1380: hr_utility.set_location(l_proc, 90);
1381: --
1382: -- When in validation only mode raise the Validate_Enabled exception
1383: if p_validate then
1384: raise hr_api.validate_enabled;
1385: end if;
1386: --
1387: p_object_version_number := l_object_version_number;
1388: p_grade_definition_id := l_grade_definition_id;

Line 1395: when hr_api.validate_enabled then

1391: hr_utility.set_location(' Leaving:'||l_proc, 100);
1392: --
1393: exception
1394: --
1395: when hr_api.validate_enabled then
1396: --
1397: -- As the Validate_Enabled exception has been raised
1398: -- we must rollback to the savepoint
1399: rollback to update_grade;

Line 1449: when hr_api.cannot_find_prog_unit then

1445: ,p_grade_id => p_grade_id
1446: ,p_object_version_number => p_object_version_number
1447: );
1448: exception
1449: when hr_api.cannot_find_prog_unit then
1450: hr_api.cannot_find_prog_unit_error
1451: (p_module_name => 'DELETE_GRADE'
1452: ,p_hook_type => 'BP'
1453: );

Line 1450: hr_api.cannot_find_prog_unit_error

1446: ,p_object_version_number => p_object_version_number
1447: );
1448: exception
1449: when hr_api.cannot_find_prog_unit then
1450: hr_api.cannot_find_prog_unit_error
1451: (p_module_name => 'DELETE_GRADE'
1452: ,p_hook_type => 'BP'
1453: );
1454: end;

Line 1481: when hr_api.cannot_find_prog_unit then

1477: (p_validate => p_validate
1478: ,p_grade_id => p_grade_id
1479: ,p_object_version_number => l_object_version_number);
1480: exception
1481: when hr_api.cannot_find_prog_unit then
1482: hr_api.cannot_find_prog_unit_error
1483: (p_module_name => 'DELETE_GRADE'
1484: ,p_hook_type => 'AP'
1485: );

Line 1482: hr_api.cannot_find_prog_unit_error

1478: ,p_grade_id => p_grade_id
1479: ,p_object_version_number => l_object_version_number);
1480: exception
1481: when hr_api.cannot_find_prog_unit then
1482: hr_api.cannot_find_prog_unit_error
1483: (p_module_name => 'DELETE_GRADE'
1484: ,p_hook_type => 'AP'
1485: );
1486: end;

Line 1491: raise hr_api.validate_enabled;

1487: --
1488: -- When in validation only mode raise the Validate_Enabled exception
1489: --
1490: if p_validate then
1491: raise hr_api.validate_enabled;
1492: end if;
1493: --
1494: -- Set all output arguments
1495: --

Line 1501: when hr_api.validate_enabled then

1497: p_object_version_number := l_object_version_number;
1498:
1499: hr_utility.set_location(' Leaving:'||l_proc, 100);
1500: exception
1501: when hr_api.validate_enabled then
1502: hr_utility.set_location(' Leaving...:'||l_proc, 80);
1503: --
1504: -- As the Validate_Enabled exception has been raised
1505: -- we must rollback to the savepoint