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

Line 100: hr_api.mandatory_arg_error

96: -- for a job in accordance with that Jobs's new Date from,
97: -- (ie. p_maintenance_mode = 'DATE_EFFECTIVE') then the p_date_from
98: -- parameter should have been set.
99: --
100: hr_api.mandatory_arg_error
101: (p_api_name => l_proc
102: ,p_argument => 'date_effective'
103: ,p_argument_value => p_date_from);
104: --

Line 116: nvl(c_vgr_rec.date_to, hr_api.g_eot) > p_date_from ) then

112: -- valid grade's Date From to that new Date from.
113: --
114: hr_utility.set_location(l_proc, 15);
115: if (c_vgr_rec.date_from < p_date_from and
116: nvl(c_vgr_rec.date_to, hr_api.g_eot) > p_date_from ) then
117: --
118: hr_utility.set_location(l_proc, 20);
119: --
120: per_vgr_upd.upd

Line 157: hr_api.mandatory_arg_error

153: -- for a job in accordance with that job's new Date to,
154: -- (ie. p_maintenance_mode = 'DATE_TO') then the p_date_to parameter
155: -- should have been set.
156: --
157: hr_api.mandatory_arg_error
158: (p_api_name => l_proc
159: ,p_argument => 'date_to'
160: ,p_argument_value => p_date_to);
161: --

Line 174: nvl(c_vgr_rec.date_to, hr_api.g_eot) > p_date_to ) then

170: --
171: hr_utility.set_location(l_proc, 35);
172: --
173: if (c_vgr_rec.date_from < p_date_to and
174: nvl(c_vgr_rec.date_to, hr_api.g_eot) > p_date_to ) then
175: --
176: hr_utility.set_location(l_proc, 40);
177: --
178: per_vgr_upd.upd

Line 302: ,p_language_code in varchar2 default hr_api.userenv_lang

298: ,p_segment28 in varchar2 default null
299: ,p_segment29 in varchar2 default null
300: ,p_segment30 in varchar2 default null
301: ,p_concat_segments in varchar2 default null
302: ,p_language_code in varchar2 default hr_api.userenv_lang
303: ,p_job_id out nocopy number
304: ,p_object_version_number out nocopy number
305: --
306: -- bug 2242339 change p_job_definition_id from an out to an in/out parameter -- to enable value to be passed into program when known and required.

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

414: -- Validate the language parameter. l_language_code should be passed
415: -- instead of p_language_code from now on, to allow an IN OUT parameter to
416: -- be passed through.
417: --
418: hr_api.validate_language_code(p_language_code => l_language_code);
419: --
420: -- Truncate date_from and date_to
421: --
422: l_date_from := trunc(p_date_from);

Line 582: when hr_api.cannot_find_prog_unit then

578: ,p_segment30 => l_segment30
579: ,p_concat_segments => p_concat_segments
580: );
581: exception
582: when hr_api.cannot_find_prog_unit then
583: hr_api.cannot_find_prog_unit_error
584: (p_module_name => 'CREATE_JOB'
585: ,p_hook_type => 'BP'
586: );

Line 583: hr_api.cannot_find_prog_unit_error

579: ,p_concat_segments => p_concat_segments
580: );
581: exception
582: when hr_api.cannot_find_prog_unit then
583: hr_api.cannot_find_prog_unit_error
584: (p_module_name => 'CREATE_JOB'
585: ,p_hook_type => 'BP'
586: );
587: --

Line 808: when hr_api.cannot_find_prog_unit then

804: ,p_job_definition_id => l_job_definition_id
805: ,p_name => l_name
806: );
807: exception
808: when hr_api.cannot_find_prog_unit then
809: hr_api.cannot_find_prog_unit_error
810: (p_module_name => 'CREATE_JOB'
811: ,p_hook_type => 'AP'
812: );

Line 809: hr_api.cannot_find_prog_unit_error

805: ,p_name => l_name
806: );
807: exception
808: when hr_api.cannot_find_prog_unit then
809: hr_api.cannot_find_prog_unit_error
810: (p_module_name => 'CREATE_JOB'
811: ,p_hook_type => 'AP'
812: );
813: --

Line 822: raise hr_api.validate_enabled;

818: -- When in validation only mode raise the Validate_Enabled exception
819: --
820: if p_validate
821: then
822: raise hr_api.validate_enabled;
823: end if;
824: --
825: hr_utility.set_location(' Leaving:'||l_proc, 50);
826: --

Line 838: when hr_api.validate_enabled then

834: hr_utility.set_location(' Leaving:'||l_proc, 60);
835: --
836: exception
837: --
838: when hr_api.validate_enabled then
839: --
840: -- As the Validate_Enabled exception has been raised
841: -- we must rollback to the savepoint
842: --

Line 890: ,p_date_from in date default hr_api.g_date

886: procedure update_job
887: (p_validate in boolean default false
888: ,p_job_id in number
889: ,p_object_version_number in out nocopy number
890: ,p_date_from in date default hr_api.g_date
891: ,p_comments in varchar2 default hr_api.g_varchar2
892: ,p_date_to in date default hr_api.g_date
893: ,p_benchmark_job_flag in varchar2 default hr_api.g_varchar2
894: ,p_benchmark_job_id in number default hr_api.g_number

Line 891: ,p_comments in varchar2 default hr_api.g_varchar2

887: (p_validate in boolean default false
888: ,p_job_id in number
889: ,p_object_version_number in out nocopy number
890: ,p_date_from in date default hr_api.g_date
891: ,p_comments in varchar2 default hr_api.g_varchar2
892: ,p_date_to in date default hr_api.g_date
893: ,p_benchmark_job_flag in varchar2 default hr_api.g_varchar2
894: ,p_benchmark_job_id in number default hr_api.g_number
895: ,p_emp_rights_flag in varchar2 default hr_api.g_varchar2

Line 892: ,p_date_to in date default hr_api.g_date

888: ,p_job_id in number
889: ,p_object_version_number in out nocopy number
890: ,p_date_from in date default hr_api.g_date
891: ,p_comments in varchar2 default hr_api.g_varchar2
892: ,p_date_to in date default hr_api.g_date
893: ,p_benchmark_job_flag in varchar2 default hr_api.g_varchar2
894: ,p_benchmark_job_id in number default hr_api.g_number
895: ,p_emp_rights_flag in varchar2 default hr_api.g_varchar2
896: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 893: ,p_benchmark_job_flag in varchar2 default hr_api.g_varchar2

889: ,p_object_version_number in out nocopy number
890: ,p_date_from in date default hr_api.g_date
891: ,p_comments in varchar2 default hr_api.g_varchar2
892: ,p_date_to in date default hr_api.g_date
893: ,p_benchmark_job_flag in varchar2 default hr_api.g_varchar2
894: ,p_benchmark_job_id in number default hr_api.g_number
895: ,p_emp_rights_flag in varchar2 default hr_api.g_varchar2
896: ,p_attribute_category in varchar2 default hr_api.g_varchar2
897: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 894: ,p_benchmark_job_id in number default hr_api.g_number

890: ,p_date_from in date default hr_api.g_date
891: ,p_comments in varchar2 default hr_api.g_varchar2
892: ,p_date_to in date default hr_api.g_date
893: ,p_benchmark_job_flag in varchar2 default hr_api.g_varchar2
894: ,p_benchmark_job_id in number default hr_api.g_number
895: ,p_emp_rights_flag in varchar2 default hr_api.g_varchar2
896: ,p_attribute_category in varchar2 default hr_api.g_varchar2
897: ,p_attribute1 in varchar2 default hr_api.g_varchar2
898: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 895: ,p_emp_rights_flag in varchar2 default hr_api.g_varchar2

891: ,p_comments in varchar2 default hr_api.g_varchar2
892: ,p_date_to in date default hr_api.g_date
893: ,p_benchmark_job_flag in varchar2 default hr_api.g_varchar2
894: ,p_benchmark_job_id in number default hr_api.g_number
895: ,p_emp_rights_flag in varchar2 default hr_api.g_varchar2
896: ,p_attribute_category in varchar2 default hr_api.g_varchar2
897: ,p_attribute1 in varchar2 default hr_api.g_varchar2
898: ,p_attribute2 in varchar2 default hr_api.g_varchar2
899: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 896: ,p_attribute_category in varchar2 default hr_api.g_varchar2

892: ,p_date_to in date default hr_api.g_date
893: ,p_benchmark_job_flag in varchar2 default hr_api.g_varchar2
894: ,p_benchmark_job_id in number default hr_api.g_number
895: ,p_emp_rights_flag in varchar2 default hr_api.g_varchar2
896: ,p_attribute_category in varchar2 default hr_api.g_varchar2
897: ,p_attribute1 in varchar2 default hr_api.g_varchar2
898: ,p_attribute2 in varchar2 default hr_api.g_varchar2
899: ,p_attribute3 in varchar2 default hr_api.g_varchar2
900: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 897: ,p_attribute1 in varchar2 default hr_api.g_varchar2

893: ,p_benchmark_job_flag in varchar2 default hr_api.g_varchar2
894: ,p_benchmark_job_id in number default hr_api.g_number
895: ,p_emp_rights_flag in varchar2 default hr_api.g_varchar2
896: ,p_attribute_category in varchar2 default hr_api.g_varchar2
897: ,p_attribute1 in varchar2 default hr_api.g_varchar2
898: ,p_attribute2 in varchar2 default hr_api.g_varchar2
899: ,p_attribute3 in varchar2 default hr_api.g_varchar2
900: ,p_attribute4 in varchar2 default hr_api.g_varchar2
901: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 898: ,p_attribute2 in varchar2 default hr_api.g_varchar2

894: ,p_benchmark_job_id in number default hr_api.g_number
895: ,p_emp_rights_flag in varchar2 default hr_api.g_varchar2
896: ,p_attribute_category in varchar2 default hr_api.g_varchar2
897: ,p_attribute1 in varchar2 default hr_api.g_varchar2
898: ,p_attribute2 in varchar2 default hr_api.g_varchar2
899: ,p_attribute3 in varchar2 default hr_api.g_varchar2
900: ,p_attribute4 in varchar2 default hr_api.g_varchar2
901: ,p_attribute5 in varchar2 default hr_api.g_varchar2
902: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 899: ,p_attribute3 in varchar2 default hr_api.g_varchar2

895: ,p_emp_rights_flag in varchar2 default hr_api.g_varchar2
896: ,p_attribute_category in varchar2 default hr_api.g_varchar2
897: ,p_attribute1 in varchar2 default hr_api.g_varchar2
898: ,p_attribute2 in varchar2 default hr_api.g_varchar2
899: ,p_attribute3 in varchar2 default hr_api.g_varchar2
900: ,p_attribute4 in varchar2 default hr_api.g_varchar2
901: ,p_attribute5 in varchar2 default hr_api.g_varchar2
902: ,p_attribute6 in varchar2 default hr_api.g_varchar2
903: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 900: ,p_attribute4 in varchar2 default hr_api.g_varchar2

896: ,p_attribute_category in varchar2 default hr_api.g_varchar2
897: ,p_attribute1 in varchar2 default hr_api.g_varchar2
898: ,p_attribute2 in varchar2 default hr_api.g_varchar2
899: ,p_attribute3 in varchar2 default hr_api.g_varchar2
900: ,p_attribute4 in varchar2 default hr_api.g_varchar2
901: ,p_attribute5 in varchar2 default hr_api.g_varchar2
902: ,p_attribute6 in varchar2 default hr_api.g_varchar2
903: ,p_attribute7 in varchar2 default hr_api.g_varchar2
904: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 901: ,p_attribute5 in varchar2 default hr_api.g_varchar2

897: ,p_attribute1 in varchar2 default hr_api.g_varchar2
898: ,p_attribute2 in varchar2 default hr_api.g_varchar2
899: ,p_attribute3 in varchar2 default hr_api.g_varchar2
900: ,p_attribute4 in varchar2 default hr_api.g_varchar2
901: ,p_attribute5 in varchar2 default hr_api.g_varchar2
902: ,p_attribute6 in varchar2 default hr_api.g_varchar2
903: ,p_attribute7 in varchar2 default hr_api.g_varchar2
904: ,p_attribute8 in varchar2 default hr_api.g_varchar2
905: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 902: ,p_attribute6 in varchar2 default hr_api.g_varchar2

898: ,p_attribute2 in varchar2 default hr_api.g_varchar2
899: ,p_attribute3 in varchar2 default hr_api.g_varchar2
900: ,p_attribute4 in varchar2 default hr_api.g_varchar2
901: ,p_attribute5 in varchar2 default hr_api.g_varchar2
902: ,p_attribute6 in varchar2 default hr_api.g_varchar2
903: ,p_attribute7 in varchar2 default hr_api.g_varchar2
904: ,p_attribute8 in varchar2 default hr_api.g_varchar2
905: ,p_attribute9 in varchar2 default hr_api.g_varchar2
906: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 903: ,p_attribute7 in varchar2 default hr_api.g_varchar2

899: ,p_attribute3 in varchar2 default hr_api.g_varchar2
900: ,p_attribute4 in varchar2 default hr_api.g_varchar2
901: ,p_attribute5 in varchar2 default hr_api.g_varchar2
902: ,p_attribute6 in varchar2 default hr_api.g_varchar2
903: ,p_attribute7 in varchar2 default hr_api.g_varchar2
904: ,p_attribute8 in varchar2 default hr_api.g_varchar2
905: ,p_attribute9 in varchar2 default hr_api.g_varchar2
906: ,p_attribute10 in varchar2 default hr_api.g_varchar2
907: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 904: ,p_attribute8 in varchar2 default hr_api.g_varchar2

900: ,p_attribute4 in varchar2 default hr_api.g_varchar2
901: ,p_attribute5 in varchar2 default hr_api.g_varchar2
902: ,p_attribute6 in varchar2 default hr_api.g_varchar2
903: ,p_attribute7 in varchar2 default hr_api.g_varchar2
904: ,p_attribute8 in varchar2 default hr_api.g_varchar2
905: ,p_attribute9 in varchar2 default hr_api.g_varchar2
906: ,p_attribute10 in varchar2 default hr_api.g_varchar2
907: ,p_attribute11 in varchar2 default hr_api.g_varchar2
908: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 905: ,p_attribute9 in varchar2 default hr_api.g_varchar2

901: ,p_attribute5 in varchar2 default hr_api.g_varchar2
902: ,p_attribute6 in varchar2 default hr_api.g_varchar2
903: ,p_attribute7 in varchar2 default hr_api.g_varchar2
904: ,p_attribute8 in varchar2 default hr_api.g_varchar2
905: ,p_attribute9 in varchar2 default hr_api.g_varchar2
906: ,p_attribute10 in varchar2 default hr_api.g_varchar2
907: ,p_attribute11 in varchar2 default hr_api.g_varchar2
908: ,p_attribute12 in varchar2 default hr_api.g_varchar2
909: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 906: ,p_attribute10 in varchar2 default hr_api.g_varchar2

902: ,p_attribute6 in varchar2 default hr_api.g_varchar2
903: ,p_attribute7 in varchar2 default hr_api.g_varchar2
904: ,p_attribute8 in varchar2 default hr_api.g_varchar2
905: ,p_attribute9 in varchar2 default hr_api.g_varchar2
906: ,p_attribute10 in varchar2 default hr_api.g_varchar2
907: ,p_attribute11 in varchar2 default hr_api.g_varchar2
908: ,p_attribute12 in varchar2 default hr_api.g_varchar2
909: ,p_attribute13 in varchar2 default hr_api.g_varchar2
910: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 907: ,p_attribute11 in varchar2 default hr_api.g_varchar2

903: ,p_attribute7 in varchar2 default hr_api.g_varchar2
904: ,p_attribute8 in varchar2 default hr_api.g_varchar2
905: ,p_attribute9 in varchar2 default hr_api.g_varchar2
906: ,p_attribute10 in varchar2 default hr_api.g_varchar2
907: ,p_attribute11 in varchar2 default hr_api.g_varchar2
908: ,p_attribute12 in varchar2 default hr_api.g_varchar2
909: ,p_attribute13 in varchar2 default hr_api.g_varchar2
910: ,p_attribute14 in varchar2 default hr_api.g_varchar2
911: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 908: ,p_attribute12 in varchar2 default hr_api.g_varchar2

904: ,p_attribute8 in varchar2 default hr_api.g_varchar2
905: ,p_attribute9 in varchar2 default hr_api.g_varchar2
906: ,p_attribute10 in varchar2 default hr_api.g_varchar2
907: ,p_attribute11 in varchar2 default hr_api.g_varchar2
908: ,p_attribute12 in varchar2 default hr_api.g_varchar2
909: ,p_attribute13 in varchar2 default hr_api.g_varchar2
910: ,p_attribute14 in varchar2 default hr_api.g_varchar2
911: ,p_attribute15 in varchar2 default hr_api.g_varchar2
912: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 909: ,p_attribute13 in varchar2 default hr_api.g_varchar2

905: ,p_attribute9 in varchar2 default hr_api.g_varchar2
906: ,p_attribute10 in varchar2 default hr_api.g_varchar2
907: ,p_attribute11 in varchar2 default hr_api.g_varchar2
908: ,p_attribute12 in varchar2 default hr_api.g_varchar2
909: ,p_attribute13 in varchar2 default hr_api.g_varchar2
910: ,p_attribute14 in varchar2 default hr_api.g_varchar2
911: ,p_attribute15 in varchar2 default hr_api.g_varchar2
912: ,p_attribute16 in varchar2 default hr_api.g_varchar2
913: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 910: ,p_attribute14 in varchar2 default hr_api.g_varchar2

906: ,p_attribute10 in varchar2 default hr_api.g_varchar2
907: ,p_attribute11 in varchar2 default hr_api.g_varchar2
908: ,p_attribute12 in varchar2 default hr_api.g_varchar2
909: ,p_attribute13 in varchar2 default hr_api.g_varchar2
910: ,p_attribute14 in varchar2 default hr_api.g_varchar2
911: ,p_attribute15 in varchar2 default hr_api.g_varchar2
912: ,p_attribute16 in varchar2 default hr_api.g_varchar2
913: ,p_attribute17 in varchar2 default hr_api.g_varchar2
914: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 911: ,p_attribute15 in varchar2 default hr_api.g_varchar2

907: ,p_attribute11 in varchar2 default hr_api.g_varchar2
908: ,p_attribute12 in varchar2 default hr_api.g_varchar2
909: ,p_attribute13 in varchar2 default hr_api.g_varchar2
910: ,p_attribute14 in varchar2 default hr_api.g_varchar2
911: ,p_attribute15 in varchar2 default hr_api.g_varchar2
912: ,p_attribute16 in varchar2 default hr_api.g_varchar2
913: ,p_attribute17 in varchar2 default hr_api.g_varchar2
914: ,p_attribute18 in varchar2 default hr_api.g_varchar2
915: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 912: ,p_attribute16 in varchar2 default hr_api.g_varchar2

908: ,p_attribute12 in varchar2 default hr_api.g_varchar2
909: ,p_attribute13 in varchar2 default hr_api.g_varchar2
910: ,p_attribute14 in varchar2 default hr_api.g_varchar2
911: ,p_attribute15 in varchar2 default hr_api.g_varchar2
912: ,p_attribute16 in varchar2 default hr_api.g_varchar2
913: ,p_attribute17 in varchar2 default hr_api.g_varchar2
914: ,p_attribute18 in varchar2 default hr_api.g_varchar2
915: ,p_attribute19 in varchar2 default hr_api.g_varchar2
916: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 913: ,p_attribute17 in varchar2 default hr_api.g_varchar2

909: ,p_attribute13 in varchar2 default hr_api.g_varchar2
910: ,p_attribute14 in varchar2 default hr_api.g_varchar2
911: ,p_attribute15 in varchar2 default hr_api.g_varchar2
912: ,p_attribute16 in varchar2 default hr_api.g_varchar2
913: ,p_attribute17 in varchar2 default hr_api.g_varchar2
914: ,p_attribute18 in varchar2 default hr_api.g_varchar2
915: ,p_attribute19 in varchar2 default hr_api.g_varchar2
916: ,p_attribute20 in varchar2 default hr_api.g_varchar2
917: ,p_job_information_category in varchar2 default hr_api.g_varchar2

Line 914: ,p_attribute18 in varchar2 default hr_api.g_varchar2

910: ,p_attribute14 in varchar2 default hr_api.g_varchar2
911: ,p_attribute15 in varchar2 default hr_api.g_varchar2
912: ,p_attribute16 in varchar2 default hr_api.g_varchar2
913: ,p_attribute17 in varchar2 default hr_api.g_varchar2
914: ,p_attribute18 in varchar2 default hr_api.g_varchar2
915: ,p_attribute19 in varchar2 default hr_api.g_varchar2
916: ,p_attribute20 in varchar2 default hr_api.g_varchar2
917: ,p_job_information_category in varchar2 default hr_api.g_varchar2
918: ,p_job_information1 in varchar2 default hr_api.g_varchar2

Line 915: ,p_attribute19 in varchar2 default hr_api.g_varchar2

911: ,p_attribute15 in varchar2 default hr_api.g_varchar2
912: ,p_attribute16 in varchar2 default hr_api.g_varchar2
913: ,p_attribute17 in varchar2 default hr_api.g_varchar2
914: ,p_attribute18 in varchar2 default hr_api.g_varchar2
915: ,p_attribute19 in varchar2 default hr_api.g_varchar2
916: ,p_attribute20 in varchar2 default hr_api.g_varchar2
917: ,p_job_information_category in varchar2 default hr_api.g_varchar2
918: ,p_job_information1 in varchar2 default hr_api.g_varchar2
919: ,p_job_information2 in varchar2 default hr_api.g_varchar2

Line 916: ,p_attribute20 in varchar2 default hr_api.g_varchar2

912: ,p_attribute16 in varchar2 default hr_api.g_varchar2
913: ,p_attribute17 in varchar2 default hr_api.g_varchar2
914: ,p_attribute18 in varchar2 default hr_api.g_varchar2
915: ,p_attribute19 in varchar2 default hr_api.g_varchar2
916: ,p_attribute20 in varchar2 default hr_api.g_varchar2
917: ,p_job_information_category in varchar2 default hr_api.g_varchar2
918: ,p_job_information1 in varchar2 default hr_api.g_varchar2
919: ,p_job_information2 in varchar2 default hr_api.g_varchar2
920: ,p_job_information3 in varchar2 default hr_api.g_varchar2

Line 917: ,p_job_information_category in varchar2 default hr_api.g_varchar2

913: ,p_attribute17 in varchar2 default hr_api.g_varchar2
914: ,p_attribute18 in varchar2 default hr_api.g_varchar2
915: ,p_attribute19 in varchar2 default hr_api.g_varchar2
916: ,p_attribute20 in varchar2 default hr_api.g_varchar2
917: ,p_job_information_category in varchar2 default hr_api.g_varchar2
918: ,p_job_information1 in varchar2 default hr_api.g_varchar2
919: ,p_job_information2 in varchar2 default hr_api.g_varchar2
920: ,p_job_information3 in varchar2 default hr_api.g_varchar2
921: ,p_job_information4 in varchar2 default hr_api.g_varchar2

Line 918: ,p_job_information1 in varchar2 default hr_api.g_varchar2

914: ,p_attribute18 in varchar2 default hr_api.g_varchar2
915: ,p_attribute19 in varchar2 default hr_api.g_varchar2
916: ,p_attribute20 in varchar2 default hr_api.g_varchar2
917: ,p_job_information_category in varchar2 default hr_api.g_varchar2
918: ,p_job_information1 in varchar2 default hr_api.g_varchar2
919: ,p_job_information2 in varchar2 default hr_api.g_varchar2
920: ,p_job_information3 in varchar2 default hr_api.g_varchar2
921: ,p_job_information4 in varchar2 default hr_api.g_varchar2
922: ,p_job_information5 in varchar2 default hr_api.g_varchar2

Line 919: ,p_job_information2 in varchar2 default hr_api.g_varchar2

915: ,p_attribute19 in varchar2 default hr_api.g_varchar2
916: ,p_attribute20 in varchar2 default hr_api.g_varchar2
917: ,p_job_information_category in varchar2 default hr_api.g_varchar2
918: ,p_job_information1 in varchar2 default hr_api.g_varchar2
919: ,p_job_information2 in varchar2 default hr_api.g_varchar2
920: ,p_job_information3 in varchar2 default hr_api.g_varchar2
921: ,p_job_information4 in varchar2 default hr_api.g_varchar2
922: ,p_job_information5 in varchar2 default hr_api.g_varchar2
923: ,p_job_information6 in varchar2 default hr_api.g_varchar2

Line 920: ,p_job_information3 in varchar2 default hr_api.g_varchar2

916: ,p_attribute20 in varchar2 default hr_api.g_varchar2
917: ,p_job_information_category in varchar2 default hr_api.g_varchar2
918: ,p_job_information1 in varchar2 default hr_api.g_varchar2
919: ,p_job_information2 in varchar2 default hr_api.g_varchar2
920: ,p_job_information3 in varchar2 default hr_api.g_varchar2
921: ,p_job_information4 in varchar2 default hr_api.g_varchar2
922: ,p_job_information5 in varchar2 default hr_api.g_varchar2
923: ,p_job_information6 in varchar2 default hr_api.g_varchar2
924: ,p_job_information7 in varchar2 default hr_api.g_varchar2

Line 921: ,p_job_information4 in varchar2 default hr_api.g_varchar2

917: ,p_job_information_category in varchar2 default hr_api.g_varchar2
918: ,p_job_information1 in varchar2 default hr_api.g_varchar2
919: ,p_job_information2 in varchar2 default hr_api.g_varchar2
920: ,p_job_information3 in varchar2 default hr_api.g_varchar2
921: ,p_job_information4 in varchar2 default hr_api.g_varchar2
922: ,p_job_information5 in varchar2 default hr_api.g_varchar2
923: ,p_job_information6 in varchar2 default hr_api.g_varchar2
924: ,p_job_information7 in varchar2 default hr_api.g_varchar2
925: ,p_job_information8 in varchar2 default hr_api.g_varchar2

Line 922: ,p_job_information5 in varchar2 default hr_api.g_varchar2

918: ,p_job_information1 in varchar2 default hr_api.g_varchar2
919: ,p_job_information2 in varchar2 default hr_api.g_varchar2
920: ,p_job_information3 in varchar2 default hr_api.g_varchar2
921: ,p_job_information4 in varchar2 default hr_api.g_varchar2
922: ,p_job_information5 in varchar2 default hr_api.g_varchar2
923: ,p_job_information6 in varchar2 default hr_api.g_varchar2
924: ,p_job_information7 in varchar2 default hr_api.g_varchar2
925: ,p_job_information8 in varchar2 default hr_api.g_varchar2
926: ,p_job_information9 in varchar2 default hr_api.g_varchar2

Line 923: ,p_job_information6 in varchar2 default hr_api.g_varchar2

919: ,p_job_information2 in varchar2 default hr_api.g_varchar2
920: ,p_job_information3 in varchar2 default hr_api.g_varchar2
921: ,p_job_information4 in varchar2 default hr_api.g_varchar2
922: ,p_job_information5 in varchar2 default hr_api.g_varchar2
923: ,p_job_information6 in varchar2 default hr_api.g_varchar2
924: ,p_job_information7 in varchar2 default hr_api.g_varchar2
925: ,p_job_information8 in varchar2 default hr_api.g_varchar2
926: ,p_job_information9 in varchar2 default hr_api.g_varchar2
927: ,p_job_information10 in varchar2 default hr_api.g_varchar2

Line 924: ,p_job_information7 in varchar2 default hr_api.g_varchar2

920: ,p_job_information3 in varchar2 default hr_api.g_varchar2
921: ,p_job_information4 in varchar2 default hr_api.g_varchar2
922: ,p_job_information5 in varchar2 default hr_api.g_varchar2
923: ,p_job_information6 in varchar2 default hr_api.g_varchar2
924: ,p_job_information7 in varchar2 default hr_api.g_varchar2
925: ,p_job_information8 in varchar2 default hr_api.g_varchar2
926: ,p_job_information9 in varchar2 default hr_api.g_varchar2
927: ,p_job_information10 in varchar2 default hr_api.g_varchar2
928: ,p_job_information11 in varchar2 default hr_api.g_varchar2

Line 925: ,p_job_information8 in varchar2 default hr_api.g_varchar2

921: ,p_job_information4 in varchar2 default hr_api.g_varchar2
922: ,p_job_information5 in varchar2 default hr_api.g_varchar2
923: ,p_job_information6 in varchar2 default hr_api.g_varchar2
924: ,p_job_information7 in varchar2 default hr_api.g_varchar2
925: ,p_job_information8 in varchar2 default hr_api.g_varchar2
926: ,p_job_information9 in varchar2 default hr_api.g_varchar2
927: ,p_job_information10 in varchar2 default hr_api.g_varchar2
928: ,p_job_information11 in varchar2 default hr_api.g_varchar2
929: ,p_job_information12 in varchar2 default hr_api.g_varchar2

Line 926: ,p_job_information9 in varchar2 default hr_api.g_varchar2

922: ,p_job_information5 in varchar2 default hr_api.g_varchar2
923: ,p_job_information6 in varchar2 default hr_api.g_varchar2
924: ,p_job_information7 in varchar2 default hr_api.g_varchar2
925: ,p_job_information8 in varchar2 default hr_api.g_varchar2
926: ,p_job_information9 in varchar2 default hr_api.g_varchar2
927: ,p_job_information10 in varchar2 default hr_api.g_varchar2
928: ,p_job_information11 in varchar2 default hr_api.g_varchar2
929: ,p_job_information12 in varchar2 default hr_api.g_varchar2
930: ,p_job_information13 in varchar2 default hr_api.g_varchar2

Line 927: ,p_job_information10 in varchar2 default hr_api.g_varchar2

923: ,p_job_information6 in varchar2 default hr_api.g_varchar2
924: ,p_job_information7 in varchar2 default hr_api.g_varchar2
925: ,p_job_information8 in varchar2 default hr_api.g_varchar2
926: ,p_job_information9 in varchar2 default hr_api.g_varchar2
927: ,p_job_information10 in varchar2 default hr_api.g_varchar2
928: ,p_job_information11 in varchar2 default hr_api.g_varchar2
929: ,p_job_information12 in varchar2 default hr_api.g_varchar2
930: ,p_job_information13 in varchar2 default hr_api.g_varchar2
931: ,p_job_information14 in varchar2 default hr_api.g_varchar2

Line 928: ,p_job_information11 in varchar2 default hr_api.g_varchar2

924: ,p_job_information7 in varchar2 default hr_api.g_varchar2
925: ,p_job_information8 in varchar2 default hr_api.g_varchar2
926: ,p_job_information9 in varchar2 default hr_api.g_varchar2
927: ,p_job_information10 in varchar2 default hr_api.g_varchar2
928: ,p_job_information11 in varchar2 default hr_api.g_varchar2
929: ,p_job_information12 in varchar2 default hr_api.g_varchar2
930: ,p_job_information13 in varchar2 default hr_api.g_varchar2
931: ,p_job_information14 in varchar2 default hr_api.g_varchar2
932: ,p_job_information15 in varchar2 default hr_api.g_varchar2

Line 929: ,p_job_information12 in varchar2 default hr_api.g_varchar2

925: ,p_job_information8 in varchar2 default hr_api.g_varchar2
926: ,p_job_information9 in varchar2 default hr_api.g_varchar2
927: ,p_job_information10 in varchar2 default hr_api.g_varchar2
928: ,p_job_information11 in varchar2 default hr_api.g_varchar2
929: ,p_job_information12 in varchar2 default hr_api.g_varchar2
930: ,p_job_information13 in varchar2 default hr_api.g_varchar2
931: ,p_job_information14 in varchar2 default hr_api.g_varchar2
932: ,p_job_information15 in varchar2 default hr_api.g_varchar2
933: ,p_job_information16 in varchar2 default hr_api.g_varchar2

Line 930: ,p_job_information13 in varchar2 default hr_api.g_varchar2

926: ,p_job_information9 in varchar2 default hr_api.g_varchar2
927: ,p_job_information10 in varchar2 default hr_api.g_varchar2
928: ,p_job_information11 in varchar2 default hr_api.g_varchar2
929: ,p_job_information12 in varchar2 default hr_api.g_varchar2
930: ,p_job_information13 in varchar2 default hr_api.g_varchar2
931: ,p_job_information14 in varchar2 default hr_api.g_varchar2
932: ,p_job_information15 in varchar2 default hr_api.g_varchar2
933: ,p_job_information16 in varchar2 default hr_api.g_varchar2
934: ,p_job_information17 in varchar2 default hr_api.g_varchar2

Line 931: ,p_job_information14 in varchar2 default hr_api.g_varchar2

927: ,p_job_information10 in varchar2 default hr_api.g_varchar2
928: ,p_job_information11 in varchar2 default hr_api.g_varchar2
929: ,p_job_information12 in varchar2 default hr_api.g_varchar2
930: ,p_job_information13 in varchar2 default hr_api.g_varchar2
931: ,p_job_information14 in varchar2 default hr_api.g_varchar2
932: ,p_job_information15 in varchar2 default hr_api.g_varchar2
933: ,p_job_information16 in varchar2 default hr_api.g_varchar2
934: ,p_job_information17 in varchar2 default hr_api.g_varchar2
935: ,p_job_information18 in varchar2 default hr_api.g_varchar2

Line 932: ,p_job_information15 in varchar2 default hr_api.g_varchar2

928: ,p_job_information11 in varchar2 default hr_api.g_varchar2
929: ,p_job_information12 in varchar2 default hr_api.g_varchar2
930: ,p_job_information13 in varchar2 default hr_api.g_varchar2
931: ,p_job_information14 in varchar2 default hr_api.g_varchar2
932: ,p_job_information15 in varchar2 default hr_api.g_varchar2
933: ,p_job_information16 in varchar2 default hr_api.g_varchar2
934: ,p_job_information17 in varchar2 default hr_api.g_varchar2
935: ,p_job_information18 in varchar2 default hr_api.g_varchar2
936: ,p_job_information19 in varchar2 default hr_api.g_varchar2

Line 933: ,p_job_information16 in varchar2 default hr_api.g_varchar2

929: ,p_job_information12 in varchar2 default hr_api.g_varchar2
930: ,p_job_information13 in varchar2 default hr_api.g_varchar2
931: ,p_job_information14 in varchar2 default hr_api.g_varchar2
932: ,p_job_information15 in varchar2 default hr_api.g_varchar2
933: ,p_job_information16 in varchar2 default hr_api.g_varchar2
934: ,p_job_information17 in varchar2 default hr_api.g_varchar2
935: ,p_job_information18 in varchar2 default hr_api.g_varchar2
936: ,p_job_information19 in varchar2 default hr_api.g_varchar2
937: ,p_job_information20 in varchar2 default hr_api.g_varchar2

Line 934: ,p_job_information17 in varchar2 default hr_api.g_varchar2

930: ,p_job_information13 in varchar2 default hr_api.g_varchar2
931: ,p_job_information14 in varchar2 default hr_api.g_varchar2
932: ,p_job_information15 in varchar2 default hr_api.g_varchar2
933: ,p_job_information16 in varchar2 default hr_api.g_varchar2
934: ,p_job_information17 in varchar2 default hr_api.g_varchar2
935: ,p_job_information18 in varchar2 default hr_api.g_varchar2
936: ,p_job_information19 in varchar2 default hr_api.g_varchar2
937: ,p_job_information20 in varchar2 default hr_api.g_varchar2
938: ,p_segment1 in varchar2 default hr_api.g_varchar2

Line 935: ,p_job_information18 in varchar2 default hr_api.g_varchar2

931: ,p_job_information14 in varchar2 default hr_api.g_varchar2
932: ,p_job_information15 in varchar2 default hr_api.g_varchar2
933: ,p_job_information16 in varchar2 default hr_api.g_varchar2
934: ,p_job_information17 in varchar2 default hr_api.g_varchar2
935: ,p_job_information18 in varchar2 default hr_api.g_varchar2
936: ,p_job_information19 in varchar2 default hr_api.g_varchar2
937: ,p_job_information20 in varchar2 default hr_api.g_varchar2
938: ,p_segment1 in varchar2 default hr_api.g_varchar2
939: ,p_segment2 in varchar2 default hr_api.g_varchar2

Line 936: ,p_job_information19 in varchar2 default hr_api.g_varchar2

932: ,p_job_information15 in varchar2 default hr_api.g_varchar2
933: ,p_job_information16 in varchar2 default hr_api.g_varchar2
934: ,p_job_information17 in varchar2 default hr_api.g_varchar2
935: ,p_job_information18 in varchar2 default hr_api.g_varchar2
936: ,p_job_information19 in varchar2 default hr_api.g_varchar2
937: ,p_job_information20 in varchar2 default hr_api.g_varchar2
938: ,p_segment1 in varchar2 default hr_api.g_varchar2
939: ,p_segment2 in varchar2 default hr_api.g_varchar2
940: ,p_segment3 in varchar2 default hr_api.g_varchar2

Line 937: ,p_job_information20 in varchar2 default hr_api.g_varchar2

933: ,p_job_information16 in varchar2 default hr_api.g_varchar2
934: ,p_job_information17 in varchar2 default hr_api.g_varchar2
935: ,p_job_information18 in varchar2 default hr_api.g_varchar2
936: ,p_job_information19 in varchar2 default hr_api.g_varchar2
937: ,p_job_information20 in varchar2 default hr_api.g_varchar2
938: ,p_segment1 in varchar2 default hr_api.g_varchar2
939: ,p_segment2 in varchar2 default hr_api.g_varchar2
940: ,p_segment3 in varchar2 default hr_api.g_varchar2
941: ,p_segment4 in varchar2 default hr_api.g_varchar2

Line 938: ,p_segment1 in varchar2 default hr_api.g_varchar2

934: ,p_job_information17 in varchar2 default hr_api.g_varchar2
935: ,p_job_information18 in varchar2 default hr_api.g_varchar2
936: ,p_job_information19 in varchar2 default hr_api.g_varchar2
937: ,p_job_information20 in varchar2 default hr_api.g_varchar2
938: ,p_segment1 in varchar2 default hr_api.g_varchar2
939: ,p_segment2 in varchar2 default hr_api.g_varchar2
940: ,p_segment3 in varchar2 default hr_api.g_varchar2
941: ,p_segment4 in varchar2 default hr_api.g_varchar2
942: ,p_segment5 in varchar2 default hr_api.g_varchar2

Line 939: ,p_segment2 in varchar2 default hr_api.g_varchar2

935: ,p_job_information18 in varchar2 default hr_api.g_varchar2
936: ,p_job_information19 in varchar2 default hr_api.g_varchar2
937: ,p_job_information20 in varchar2 default hr_api.g_varchar2
938: ,p_segment1 in varchar2 default hr_api.g_varchar2
939: ,p_segment2 in varchar2 default hr_api.g_varchar2
940: ,p_segment3 in varchar2 default hr_api.g_varchar2
941: ,p_segment4 in varchar2 default hr_api.g_varchar2
942: ,p_segment5 in varchar2 default hr_api.g_varchar2
943: ,p_segment6 in varchar2 default hr_api.g_varchar2

Line 940: ,p_segment3 in varchar2 default hr_api.g_varchar2

936: ,p_job_information19 in varchar2 default hr_api.g_varchar2
937: ,p_job_information20 in varchar2 default hr_api.g_varchar2
938: ,p_segment1 in varchar2 default hr_api.g_varchar2
939: ,p_segment2 in varchar2 default hr_api.g_varchar2
940: ,p_segment3 in varchar2 default hr_api.g_varchar2
941: ,p_segment4 in varchar2 default hr_api.g_varchar2
942: ,p_segment5 in varchar2 default hr_api.g_varchar2
943: ,p_segment6 in varchar2 default hr_api.g_varchar2
944: ,p_segment7 in varchar2 default hr_api.g_varchar2

Line 941: ,p_segment4 in varchar2 default hr_api.g_varchar2

937: ,p_job_information20 in varchar2 default hr_api.g_varchar2
938: ,p_segment1 in varchar2 default hr_api.g_varchar2
939: ,p_segment2 in varchar2 default hr_api.g_varchar2
940: ,p_segment3 in varchar2 default hr_api.g_varchar2
941: ,p_segment4 in varchar2 default hr_api.g_varchar2
942: ,p_segment5 in varchar2 default hr_api.g_varchar2
943: ,p_segment6 in varchar2 default hr_api.g_varchar2
944: ,p_segment7 in varchar2 default hr_api.g_varchar2
945: ,p_segment8 in varchar2 default hr_api.g_varchar2

Line 942: ,p_segment5 in varchar2 default hr_api.g_varchar2

938: ,p_segment1 in varchar2 default hr_api.g_varchar2
939: ,p_segment2 in varchar2 default hr_api.g_varchar2
940: ,p_segment3 in varchar2 default hr_api.g_varchar2
941: ,p_segment4 in varchar2 default hr_api.g_varchar2
942: ,p_segment5 in varchar2 default hr_api.g_varchar2
943: ,p_segment6 in varchar2 default hr_api.g_varchar2
944: ,p_segment7 in varchar2 default hr_api.g_varchar2
945: ,p_segment8 in varchar2 default hr_api.g_varchar2
946: ,p_segment9 in varchar2 default hr_api.g_varchar2

Line 943: ,p_segment6 in varchar2 default hr_api.g_varchar2

939: ,p_segment2 in varchar2 default hr_api.g_varchar2
940: ,p_segment3 in varchar2 default hr_api.g_varchar2
941: ,p_segment4 in varchar2 default hr_api.g_varchar2
942: ,p_segment5 in varchar2 default hr_api.g_varchar2
943: ,p_segment6 in varchar2 default hr_api.g_varchar2
944: ,p_segment7 in varchar2 default hr_api.g_varchar2
945: ,p_segment8 in varchar2 default hr_api.g_varchar2
946: ,p_segment9 in varchar2 default hr_api.g_varchar2
947: ,p_segment10 in varchar2 default hr_api.g_varchar2

Line 944: ,p_segment7 in varchar2 default hr_api.g_varchar2

940: ,p_segment3 in varchar2 default hr_api.g_varchar2
941: ,p_segment4 in varchar2 default hr_api.g_varchar2
942: ,p_segment5 in varchar2 default hr_api.g_varchar2
943: ,p_segment6 in varchar2 default hr_api.g_varchar2
944: ,p_segment7 in varchar2 default hr_api.g_varchar2
945: ,p_segment8 in varchar2 default hr_api.g_varchar2
946: ,p_segment9 in varchar2 default hr_api.g_varchar2
947: ,p_segment10 in varchar2 default hr_api.g_varchar2
948: ,p_segment11 in varchar2 default hr_api.g_varchar2

Line 945: ,p_segment8 in varchar2 default hr_api.g_varchar2

941: ,p_segment4 in varchar2 default hr_api.g_varchar2
942: ,p_segment5 in varchar2 default hr_api.g_varchar2
943: ,p_segment6 in varchar2 default hr_api.g_varchar2
944: ,p_segment7 in varchar2 default hr_api.g_varchar2
945: ,p_segment8 in varchar2 default hr_api.g_varchar2
946: ,p_segment9 in varchar2 default hr_api.g_varchar2
947: ,p_segment10 in varchar2 default hr_api.g_varchar2
948: ,p_segment11 in varchar2 default hr_api.g_varchar2
949: ,p_segment12 in varchar2 default hr_api.g_varchar2

Line 946: ,p_segment9 in varchar2 default hr_api.g_varchar2

942: ,p_segment5 in varchar2 default hr_api.g_varchar2
943: ,p_segment6 in varchar2 default hr_api.g_varchar2
944: ,p_segment7 in varchar2 default hr_api.g_varchar2
945: ,p_segment8 in varchar2 default hr_api.g_varchar2
946: ,p_segment9 in varchar2 default hr_api.g_varchar2
947: ,p_segment10 in varchar2 default hr_api.g_varchar2
948: ,p_segment11 in varchar2 default hr_api.g_varchar2
949: ,p_segment12 in varchar2 default hr_api.g_varchar2
950: ,p_segment13 in varchar2 default hr_api.g_varchar2

Line 947: ,p_segment10 in varchar2 default hr_api.g_varchar2

943: ,p_segment6 in varchar2 default hr_api.g_varchar2
944: ,p_segment7 in varchar2 default hr_api.g_varchar2
945: ,p_segment8 in varchar2 default hr_api.g_varchar2
946: ,p_segment9 in varchar2 default hr_api.g_varchar2
947: ,p_segment10 in varchar2 default hr_api.g_varchar2
948: ,p_segment11 in varchar2 default hr_api.g_varchar2
949: ,p_segment12 in varchar2 default hr_api.g_varchar2
950: ,p_segment13 in varchar2 default hr_api.g_varchar2
951: ,p_segment14 in varchar2 default hr_api.g_varchar2

Line 948: ,p_segment11 in varchar2 default hr_api.g_varchar2

944: ,p_segment7 in varchar2 default hr_api.g_varchar2
945: ,p_segment8 in varchar2 default hr_api.g_varchar2
946: ,p_segment9 in varchar2 default hr_api.g_varchar2
947: ,p_segment10 in varchar2 default hr_api.g_varchar2
948: ,p_segment11 in varchar2 default hr_api.g_varchar2
949: ,p_segment12 in varchar2 default hr_api.g_varchar2
950: ,p_segment13 in varchar2 default hr_api.g_varchar2
951: ,p_segment14 in varchar2 default hr_api.g_varchar2
952: ,p_segment15 in varchar2 default hr_api.g_varchar2

Line 949: ,p_segment12 in varchar2 default hr_api.g_varchar2

945: ,p_segment8 in varchar2 default hr_api.g_varchar2
946: ,p_segment9 in varchar2 default hr_api.g_varchar2
947: ,p_segment10 in varchar2 default hr_api.g_varchar2
948: ,p_segment11 in varchar2 default hr_api.g_varchar2
949: ,p_segment12 in varchar2 default hr_api.g_varchar2
950: ,p_segment13 in varchar2 default hr_api.g_varchar2
951: ,p_segment14 in varchar2 default hr_api.g_varchar2
952: ,p_segment15 in varchar2 default hr_api.g_varchar2
953: ,p_segment16 in varchar2 default hr_api.g_varchar2

Line 950: ,p_segment13 in varchar2 default hr_api.g_varchar2

946: ,p_segment9 in varchar2 default hr_api.g_varchar2
947: ,p_segment10 in varchar2 default hr_api.g_varchar2
948: ,p_segment11 in varchar2 default hr_api.g_varchar2
949: ,p_segment12 in varchar2 default hr_api.g_varchar2
950: ,p_segment13 in varchar2 default hr_api.g_varchar2
951: ,p_segment14 in varchar2 default hr_api.g_varchar2
952: ,p_segment15 in varchar2 default hr_api.g_varchar2
953: ,p_segment16 in varchar2 default hr_api.g_varchar2
954: ,p_segment17 in varchar2 default hr_api.g_varchar2

Line 951: ,p_segment14 in varchar2 default hr_api.g_varchar2

947: ,p_segment10 in varchar2 default hr_api.g_varchar2
948: ,p_segment11 in varchar2 default hr_api.g_varchar2
949: ,p_segment12 in varchar2 default hr_api.g_varchar2
950: ,p_segment13 in varchar2 default hr_api.g_varchar2
951: ,p_segment14 in varchar2 default hr_api.g_varchar2
952: ,p_segment15 in varchar2 default hr_api.g_varchar2
953: ,p_segment16 in varchar2 default hr_api.g_varchar2
954: ,p_segment17 in varchar2 default hr_api.g_varchar2
955: ,p_segment18 in varchar2 default hr_api.g_varchar2

Line 952: ,p_segment15 in varchar2 default hr_api.g_varchar2

948: ,p_segment11 in varchar2 default hr_api.g_varchar2
949: ,p_segment12 in varchar2 default hr_api.g_varchar2
950: ,p_segment13 in varchar2 default hr_api.g_varchar2
951: ,p_segment14 in varchar2 default hr_api.g_varchar2
952: ,p_segment15 in varchar2 default hr_api.g_varchar2
953: ,p_segment16 in varchar2 default hr_api.g_varchar2
954: ,p_segment17 in varchar2 default hr_api.g_varchar2
955: ,p_segment18 in varchar2 default hr_api.g_varchar2
956: ,p_segment19 in varchar2 default hr_api.g_varchar2

Line 953: ,p_segment16 in varchar2 default hr_api.g_varchar2

949: ,p_segment12 in varchar2 default hr_api.g_varchar2
950: ,p_segment13 in varchar2 default hr_api.g_varchar2
951: ,p_segment14 in varchar2 default hr_api.g_varchar2
952: ,p_segment15 in varchar2 default hr_api.g_varchar2
953: ,p_segment16 in varchar2 default hr_api.g_varchar2
954: ,p_segment17 in varchar2 default hr_api.g_varchar2
955: ,p_segment18 in varchar2 default hr_api.g_varchar2
956: ,p_segment19 in varchar2 default hr_api.g_varchar2
957: ,p_segment20 in varchar2 default hr_api.g_varchar2

Line 954: ,p_segment17 in varchar2 default hr_api.g_varchar2

950: ,p_segment13 in varchar2 default hr_api.g_varchar2
951: ,p_segment14 in varchar2 default hr_api.g_varchar2
952: ,p_segment15 in varchar2 default hr_api.g_varchar2
953: ,p_segment16 in varchar2 default hr_api.g_varchar2
954: ,p_segment17 in varchar2 default hr_api.g_varchar2
955: ,p_segment18 in varchar2 default hr_api.g_varchar2
956: ,p_segment19 in varchar2 default hr_api.g_varchar2
957: ,p_segment20 in varchar2 default hr_api.g_varchar2
958: ,p_segment21 in varchar2 default hr_api.g_varchar2

Line 955: ,p_segment18 in varchar2 default hr_api.g_varchar2

951: ,p_segment14 in varchar2 default hr_api.g_varchar2
952: ,p_segment15 in varchar2 default hr_api.g_varchar2
953: ,p_segment16 in varchar2 default hr_api.g_varchar2
954: ,p_segment17 in varchar2 default hr_api.g_varchar2
955: ,p_segment18 in varchar2 default hr_api.g_varchar2
956: ,p_segment19 in varchar2 default hr_api.g_varchar2
957: ,p_segment20 in varchar2 default hr_api.g_varchar2
958: ,p_segment21 in varchar2 default hr_api.g_varchar2
959: ,p_segment22 in varchar2 default hr_api.g_varchar2

Line 956: ,p_segment19 in varchar2 default hr_api.g_varchar2

952: ,p_segment15 in varchar2 default hr_api.g_varchar2
953: ,p_segment16 in varchar2 default hr_api.g_varchar2
954: ,p_segment17 in varchar2 default hr_api.g_varchar2
955: ,p_segment18 in varchar2 default hr_api.g_varchar2
956: ,p_segment19 in varchar2 default hr_api.g_varchar2
957: ,p_segment20 in varchar2 default hr_api.g_varchar2
958: ,p_segment21 in varchar2 default hr_api.g_varchar2
959: ,p_segment22 in varchar2 default hr_api.g_varchar2
960: ,p_segment23 in varchar2 default hr_api.g_varchar2

Line 957: ,p_segment20 in varchar2 default hr_api.g_varchar2

953: ,p_segment16 in varchar2 default hr_api.g_varchar2
954: ,p_segment17 in varchar2 default hr_api.g_varchar2
955: ,p_segment18 in varchar2 default hr_api.g_varchar2
956: ,p_segment19 in varchar2 default hr_api.g_varchar2
957: ,p_segment20 in varchar2 default hr_api.g_varchar2
958: ,p_segment21 in varchar2 default hr_api.g_varchar2
959: ,p_segment22 in varchar2 default hr_api.g_varchar2
960: ,p_segment23 in varchar2 default hr_api.g_varchar2
961: ,p_segment24 in varchar2 default hr_api.g_varchar2

Line 958: ,p_segment21 in varchar2 default hr_api.g_varchar2

954: ,p_segment17 in varchar2 default hr_api.g_varchar2
955: ,p_segment18 in varchar2 default hr_api.g_varchar2
956: ,p_segment19 in varchar2 default hr_api.g_varchar2
957: ,p_segment20 in varchar2 default hr_api.g_varchar2
958: ,p_segment21 in varchar2 default hr_api.g_varchar2
959: ,p_segment22 in varchar2 default hr_api.g_varchar2
960: ,p_segment23 in varchar2 default hr_api.g_varchar2
961: ,p_segment24 in varchar2 default hr_api.g_varchar2
962: ,p_segment25 in varchar2 default hr_api.g_varchar2

Line 959: ,p_segment22 in varchar2 default hr_api.g_varchar2

955: ,p_segment18 in varchar2 default hr_api.g_varchar2
956: ,p_segment19 in varchar2 default hr_api.g_varchar2
957: ,p_segment20 in varchar2 default hr_api.g_varchar2
958: ,p_segment21 in varchar2 default hr_api.g_varchar2
959: ,p_segment22 in varchar2 default hr_api.g_varchar2
960: ,p_segment23 in varchar2 default hr_api.g_varchar2
961: ,p_segment24 in varchar2 default hr_api.g_varchar2
962: ,p_segment25 in varchar2 default hr_api.g_varchar2
963: ,p_segment26 in varchar2 default hr_api.g_varchar2

Line 960: ,p_segment23 in varchar2 default hr_api.g_varchar2

956: ,p_segment19 in varchar2 default hr_api.g_varchar2
957: ,p_segment20 in varchar2 default hr_api.g_varchar2
958: ,p_segment21 in varchar2 default hr_api.g_varchar2
959: ,p_segment22 in varchar2 default hr_api.g_varchar2
960: ,p_segment23 in varchar2 default hr_api.g_varchar2
961: ,p_segment24 in varchar2 default hr_api.g_varchar2
962: ,p_segment25 in varchar2 default hr_api.g_varchar2
963: ,p_segment26 in varchar2 default hr_api.g_varchar2
964: ,p_segment27 in varchar2 default hr_api.g_varchar2

Line 961: ,p_segment24 in varchar2 default hr_api.g_varchar2

957: ,p_segment20 in varchar2 default hr_api.g_varchar2
958: ,p_segment21 in varchar2 default hr_api.g_varchar2
959: ,p_segment22 in varchar2 default hr_api.g_varchar2
960: ,p_segment23 in varchar2 default hr_api.g_varchar2
961: ,p_segment24 in varchar2 default hr_api.g_varchar2
962: ,p_segment25 in varchar2 default hr_api.g_varchar2
963: ,p_segment26 in varchar2 default hr_api.g_varchar2
964: ,p_segment27 in varchar2 default hr_api.g_varchar2
965: ,p_segment28 in varchar2 default hr_api.g_varchar2

Line 962: ,p_segment25 in varchar2 default hr_api.g_varchar2

958: ,p_segment21 in varchar2 default hr_api.g_varchar2
959: ,p_segment22 in varchar2 default hr_api.g_varchar2
960: ,p_segment23 in varchar2 default hr_api.g_varchar2
961: ,p_segment24 in varchar2 default hr_api.g_varchar2
962: ,p_segment25 in varchar2 default hr_api.g_varchar2
963: ,p_segment26 in varchar2 default hr_api.g_varchar2
964: ,p_segment27 in varchar2 default hr_api.g_varchar2
965: ,p_segment28 in varchar2 default hr_api.g_varchar2
966: ,p_segment29 in varchar2 default hr_api.g_varchar2

Line 963: ,p_segment26 in varchar2 default hr_api.g_varchar2

959: ,p_segment22 in varchar2 default hr_api.g_varchar2
960: ,p_segment23 in varchar2 default hr_api.g_varchar2
961: ,p_segment24 in varchar2 default hr_api.g_varchar2
962: ,p_segment25 in varchar2 default hr_api.g_varchar2
963: ,p_segment26 in varchar2 default hr_api.g_varchar2
964: ,p_segment27 in varchar2 default hr_api.g_varchar2
965: ,p_segment28 in varchar2 default hr_api.g_varchar2
966: ,p_segment29 in varchar2 default hr_api.g_varchar2
967: ,p_segment30 in varchar2 default hr_api.g_varchar2

Line 964: ,p_segment27 in varchar2 default hr_api.g_varchar2

960: ,p_segment23 in varchar2 default hr_api.g_varchar2
961: ,p_segment24 in varchar2 default hr_api.g_varchar2
962: ,p_segment25 in varchar2 default hr_api.g_varchar2
963: ,p_segment26 in varchar2 default hr_api.g_varchar2
964: ,p_segment27 in varchar2 default hr_api.g_varchar2
965: ,p_segment28 in varchar2 default hr_api.g_varchar2
966: ,p_segment29 in varchar2 default hr_api.g_varchar2
967: ,p_segment30 in varchar2 default hr_api.g_varchar2
968: ,p_concat_segments in varchar2 default hr_api.g_varchar2

Line 965: ,p_segment28 in varchar2 default hr_api.g_varchar2

961: ,p_segment24 in varchar2 default hr_api.g_varchar2
962: ,p_segment25 in varchar2 default hr_api.g_varchar2
963: ,p_segment26 in varchar2 default hr_api.g_varchar2
964: ,p_segment27 in varchar2 default hr_api.g_varchar2
965: ,p_segment28 in varchar2 default hr_api.g_varchar2
966: ,p_segment29 in varchar2 default hr_api.g_varchar2
967: ,p_segment30 in varchar2 default hr_api.g_varchar2
968: ,p_concat_segments in varchar2 default hr_api.g_varchar2
969: ,p_approval_authority in number default hr_api.g_number

Line 966: ,p_segment29 in varchar2 default hr_api.g_varchar2

962: ,p_segment25 in varchar2 default hr_api.g_varchar2
963: ,p_segment26 in varchar2 default hr_api.g_varchar2
964: ,p_segment27 in varchar2 default hr_api.g_varchar2
965: ,p_segment28 in varchar2 default hr_api.g_varchar2
966: ,p_segment29 in varchar2 default hr_api.g_varchar2
967: ,p_segment30 in varchar2 default hr_api.g_varchar2
968: ,p_concat_segments in varchar2 default hr_api.g_varchar2
969: ,p_approval_authority in number default hr_api.g_number
970: ,p_language_code in varchar2 default hr_api.userenv_lang

Line 967: ,p_segment30 in varchar2 default hr_api.g_varchar2

963: ,p_segment26 in varchar2 default hr_api.g_varchar2
964: ,p_segment27 in varchar2 default hr_api.g_varchar2
965: ,p_segment28 in varchar2 default hr_api.g_varchar2
966: ,p_segment29 in varchar2 default hr_api.g_varchar2
967: ,p_segment30 in varchar2 default hr_api.g_varchar2
968: ,p_concat_segments in varchar2 default hr_api.g_varchar2
969: ,p_approval_authority in number default hr_api.g_number
970: ,p_language_code in varchar2 default hr_api.userenv_lang
971: --

Line 968: ,p_concat_segments in varchar2 default hr_api.g_varchar2

964: ,p_segment27 in varchar2 default hr_api.g_varchar2
965: ,p_segment28 in varchar2 default hr_api.g_varchar2
966: ,p_segment29 in varchar2 default hr_api.g_varchar2
967: ,p_segment30 in varchar2 default hr_api.g_varchar2
968: ,p_concat_segments in varchar2 default hr_api.g_varchar2
969: ,p_approval_authority in number default hr_api.g_number
970: ,p_language_code in varchar2 default hr_api.userenv_lang
971: --
972: -- bug 2242339 change p_job_definition_id from an out to an in/out parameter

Line 969: ,p_approval_authority in number default hr_api.g_number

965: ,p_segment28 in varchar2 default hr_api.g_varchar2
966: ,p_segment29 in varchar2 default hr_api.g_varchar2
967: ,p_segment30 in varchar2 default hr_api.g_varchar2
968: ,p_concat_segments in varchar2 default hr_api.g_varchar2
969: ,p_approval_authority in number default hr_api.g_number
970: ,p_language_code in varchar2 default hr_api.userenv_lang
971: --
972: -- bug 2242339 change p_job_definition_id from an out to an in/out parameter
973: -- to enable value to be passed into program when known and required.

Line 970: ,p_language_code in varchar2 default hr_api.userenv_lang

966: ,p_segment29 in varchar2 default hr_api.g_varchar2
967: ,p_segment30 in varchar2 default hr_api.g_varchar2
968: ,p_concat_segments in varchar2 default hr_api.g_varchar2
969: ,p_approval_authority in number default hr_api.g_number
970: ,p_language_code in varchar2 default hr_api.userenv_lang
971: --
972: -- bug 2242339 change p_job_definition_id from an out to an in/out parameter
973: -- to enable value to be passed into program when known and required.
974: --

Line 979: ,p_effective_date in date default hr_api.g_date --Added for Bug# 1760707

975: ,p_job_definition_id in out nocopy number
976: ,p_name out nocopy varchar2
977: ,p_valid_grades_changed_warning out nocopy boolean
978: -- Defaulting it for fix 3138252
979: ,p_effective_date in date default hr_api.g_date --Added for Bug# 1760707
980: ) is
981: --
982: -- Declare cursors and local variables
983: --

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

1089: -- Validate the language parameter. l_language_code should be passed
1090: -- instead of p_language_code from now on, to allow an IN OUT parameter to
1091: -- be passed through.
1092: --
1093: hr_api.validate_language_code(p_language_code => l_language_code);
1094: --
1095: hr_utility.set_location(l_proc, 10);
1096: --
1097: l_object_version_number := p_object_version_number;

Line 1264: when hr_api.cannot_find_prog_unit

1260: ,p_job_definition_id => p_job_definition_id
1261: ,p_effective_date => p_effective_date --Added for bug# 1760707
1262: );
1263: exception
1264: when hr_api.cannot_find_prog_unit
1265: then
1266: hr_api.cannot_find_prog_unit_error
1267: (p_module_name => 'UPDATE_JOB'
1268: ,p_hook_type => 'BP'

Line 1266: hr_api.cannot_find_prog_unit_error

1262: );
1263: exception
1264: when hr_api.cannot_find_prog_unit
1265: then
1266: hr_api.cannot_find_prog_unit_error
1267: (p_module_name => 'UPDATE_JOB'
1268: ,p_hook_type => 'BP'
1269: );
1270: end; -- End of API User Hook for the before hook of update_job

Line 1358: if ((nvl(p_date_from, hr_api.g_date) <> hr_api.g_date) and

1354: --
1355: -- If date_from is being updated , then need to maintain valid grades
1356: -- accordingly for that job.
1357: --
1358: if ((nvl(p_date_from, hr_api.g_date) <> hr_api.g_date) and
1359: per_job_shd.g_old_rec.date_from <>
1360: nvl(p_date_from, hr_api.g_date))
1361: then
1362: --

Line 1360: nvl(p_date_from, hr_api.g_date))

1356: -- accordingly for that job.
1357: --
1358: if ((nvl(p_date_from, hr_api.g_date) <> hr_api.g_date) and
1359: per_job_shd.g_old_rec.date_from <>
1360: nvl(p_date_from, hr_api.g_date))
1361: then
1362: --
1363: maintain_valid_grades
1364: (p_validate => p_validate

Line 1378: if ((nvl(p_date_to, hr_api.g_date) <> hr_api.g_date) and

1374: --
1375: -- If date_end is being updated , then need to maintain valid grades
1376: -- accordingly for that job.
1377: --
1378: if ((nvl(p_date_to, hr_api.g_date) <> hr_api.g_date) and
1379: nvl(per_job_shd.g_old_rec.date_to, hr_api.g_date) <>
1380: nvl(p_date_to, hr_api.g_date))
1381: then
1382: maintain_valid_grades

Line 1379: nvl(per_job_shd.g_old_rec.date_to, hr_api.g_date) <>

1375: -- If date_end is being updated , then need to maintain valid grades
1376: -- accordingly for that job.
1377: --
1378: if ((nvl(p_date_to, hr_api.g_date) <> hr_api.g_date) and
1379: nvl(per_job_shd.g_old_rec.date_to, hr_api.g_date) <>
1380: nvl(p_date_to, hr_api.g_date))
1381: then
1382: maintain_valid_grades
1383: (p_validate => p_validate

Line 1380: nvl(p_date_to, hr_api.g_date))

1376: -- accordingly for that job.
1377: --
1378: if ((nvl(p_date_to, hr_api.g_date) <> hr_api.g_date) and
1379: nvl(per_job_shd.g_old_rec.date_to, hr_api.g_date) <>
1380: nvl(p_date_to, hr_api.g_date))
1381: then
1382: maintain_valid_grades
1383: (p_validate => p_validate
1384: ,p_job_id => p_job_id

Line 1556: when hr_api.cannot_find_prog_unit then

1552: ,p_effective_date => p_effective_date --Added for Bug# 1760707
1553: );
1554: --
1555: exception
1556: when hr_api.cannot_find_prog_unit then
1557: hr_api.cannot_find_prog_unit_error
1558: (p_module_name => 'UPDATE_JOB'
1559: ,p_hook_type => 'AP'
1560: );

Line 1557: hr_api.cannot_find_prog_unit_error

1553: );
1554: --
1555: exception
1556: when hr_api.cannot_find_prog_unit then
1557: hr_api.cannot_find_prog_unit_error
1558: (p_module_name => 'UPDATE_JOB'
1559: ,p_hook_type => 'AP'
1560: );
1561: end; -- End of API User Hook for the after hook of update_job

Line 1569: raise hr_api.validate_enabled;

1565: -- When in validation only mode raise the Validate_Enabled exception
1566: --
1567: if p_validate
1568: then
1569: raise hr_api.validate_enabled;
1570: end if;
1571: --
1572: p_object_version_number := l_object_version_number;
1573: if l_valid_grades_changed1 or l_valid_grades_changed2

Line 1584: when hr_api.validate_enabled then

1580: p_name := l_name;
1581: --
1582: hr_utility.set_location(' Leaving:'||l_proc, 100);
1583: exception
1584: when hr_api.validate_enabled then
1585: --
1586: -- As the Validate_Enabled exception has been raised
1587: -- we must rollback to the savepoint
1588: --

Line 1654: when hr_api.cannot_find_prog_unit then

1650: (p_validate => p_validate
1651: ,p_job_id => p_job_id
1652: ,p_object_version_number => p_object_version_number);
1653: exception
1654: when hr_api.cannot_find_prog_unit then
1655: hr_api.cannot_find_prog_unit_error
1656: (p_module_name => 'DELETE_JOB'
1657: ,p_hook_type => 'BP'
1658: );

Line 1655: hr_api.cannot_find_prog_unit_error

1651: ,p_job_id => p_job_id
1652: ,p_object_version_number => p_object_version_number);
1653: exception
1654: when hr_api.cannot_find_prog_unit then
1655: hr_api.cannot_find_prog_unit_error
1656: (p_module_name => 'DELETE_JOB'
1657: ,p_hook_type => 'BP'
1658: );
1659: end;

Line 1681: when hr_api.cannot_find_prog_unit then

1677: (p_validate => p_validate
1678: ,p_job_id => p_job_id
1679: ,p_object_version_number => l_object_version_number);
1680: exception
1681: when hr_api.cannot_find_prog_unit then
1682: hr_api.cannot_find_prog_unit_error
1683: (p_module_name => 'DELETE_JOB'
1684: ,p_hook_type => 'AP'
1685: );

Line 1682: hr_api.cannot_find_prog_unit_error

1678: ,p_job_id => p_job_id
1679: ,p_object_version_number => l_object_version_number);
1680: exception
1681: when hr_api.cannot_find_prog_unit then
1682: hr_api.cannot_find_prog_unit_error
1683: (p_module_name => 'DELETE_JOB'
1684: ,p_hook_type => 'AP'
1685: );
1686: end;

Line 1691: raise hr_api.validate_enabled;

1687: --
1688: -- When in validation only mode raise the Validate_Enabled exception
1689: --
1690: if p_validate then
1691: raise hr_api.validate_enabled;
1692: end if;
1693: --
1694: -- Set all output arguments
1695: --

Line 1701: when hr_api.validate_enabled then

1697: p_object_version_number := l_object_version_number;
1698:
1699: hr_utility.set_location(' Leaving:'||l_proc, 70);
1700: exception
1701: when hr_api.validate_enabled then
1702: --
1703: -- As the Validate_Enabled exception has been raised
1704: -- we must rollback to the savepoint
1705: --