136: ,p_information29 => p_information29
137: ,p_information30 => p_information30
138: );
139: exception
140: when hr_api.cannot_find_prog_unit then
141: hr_api.cannot_find_prog_unit_error
142: (p_module_name => 'CREATE_GRADE_STEP'
143: ,p_hook_type => 'BP'
144: );
137: ,p_information30 => p_information30
138: );
139: exception
140: when hr_api.cannot_find_prog_unit then
141: hr_api.cannot_find_prog_unit_error
142: (p_module_name => 'CREATE_GRADE_STEP'
143: ,p_hook_type => 'BP'
144: );
145: --
257: ,p_effective_start_date => l_effective_start_date
258: ,p_effective_end_date => l_effective_end_date
259: );
260: exception
261: when hr_api.cannot_find_prog_unit then
262: hr_api.cannot_find_prog_unit_error
263: (p_module_name => 'CREATE_GRADE_STEP'
264: ,p_hook_type => 'AP'
265: );
258: ,p_effective_end_date => l_effective_end_date
259: );
260: exception
261: when hr_api.cannot_find_prog_unit then
262: hr_api.cannot_find_prog_unit_error
263: (p_module_name => 'CREATE_GRADE_STEP'
264: ,p_hook_type => 'AP'
265: );
266: --
271: -- When in validation only mode raise the Validate_Enabled exception
272: --
273: if p_validate
274: then
275: raise hr_api.validate_enabled;
276: end if;
277: --
278: hr_utility.set_location(l_proc, 50);
279: --
287: hr_utility.set_location(' Leaving:' ||l_proc, 60);
288: --
289: exception
290: --
291: when hr_api.validate_enabled then
292: --
293: -- As the Validate_Enabled exception has been raised
294: -- we must rollback to the savepoint
295: --
329: -- ----------------------------------------------------------------------------
330: --
331: procedure update_grade_step
332: (p_validate in boolean default false
333: ,p_effective_date in date default hr_api.g_date
334: ,p_datetrack_mode in varchar2
335: ,p_step_id in number
336: ,p_object_version_number in out nocopy number
337: ,p_business_group_id in number default hr_api.g_number
333: ,p_effective_date in date default hr_api.g_date
334: ,p_datetrack_mode in varchar2
335: ,p_step_id in number
336: ,p_object_version_number in out nocopy number
337: ,p_business_group_id in number default hr_api.g_number
338: ,p_spinal_point_id in number default hr_api.g_number
339: ,p_grade_spine_id in number default hr_api.g_number
340: ,p_sequence in number default hr_api.g_number
341: ,p_request_id in number default hr_api.g_number
334: ,p_datetrack_mode in varchar2
335: ,p_step_id in number
336: ,p_object_version_number in out nocopy number
337: ,p_business_group_id in number default hr_api.g_number
338: ,p_spinal_point_id in number default hr_api.g_number
339: ,p_grade_spine_id in number default hr_api.g_number
340: ,p_sequence in number default hr_api.g_number
341: ,p_request_id in number default hr_api.g_number
342: ,p_program_application_id in number default hr_api.g_number
335: ,p_step_id in number
336: ,p_object_version_number in out nocopy number
337: ,p_business_group_id in number default hr_api.g_number
338: ,p_spinal_point_id in number default hr_api.g_number
339: ,p_grade_spine_id in number default hr_api.g_number
340: ,p_sequence in number default hr_api.g_number
341: ,p_request_id in number default hr_api.g_number
342: ,p_program_application_id in number default hr_api.g_number
343: ,p_program_id in number default hr_api.g_number
336: ,p_object_version_number in out nocopy number
337: ,p_business_group_id in number default hr_api.g_number
338: ,p_spinal_point_id in number default hr_api.g_number
339: ,p_grade_spine_id in number default hr_api.g_number
340: ,p_sequence in number default hr_api.g_number
341: ,p_request_id in number default hr_api.g_number
342: ,p_program_application_id in number default hr_api.g_number
343: ,p_program_id in number default hr_api.g_number
344: ,p_program_update_date in date default hr_api.g_date
337: ,p_business_group_id in number default hr_api.g_number
338: ,p_spinal_point_id in number default hr_api.g_number
339: ,p_grade_spine_id in number default hr_api.g_number
340: ,p_sequence in number default hr_api.g_number
341: ,p_request_id in number default hr_api.g_number
342: ,p_program_application_id in number default hr_api.g_number
343: ,p_program_id in number default hr_api.g_number
344: ,p_program_update_date in date default hr_api.g_date
345: ,p_information_category in varchar2 default hr_api.g_varchar2
338: ,p_spinal_point_id in number default hr_api.g_number
339: ,p_grade_spine_id in number default hr_api.g_number
340: ,p_sequence in number default hr_api.g_number
341: ,p_request_id in number default hr_api.g_number
342: ,p_program_application_id in number default hr_api.g_number
343: ,p_program_id in number default hr_api.g_number
344: ,p_program_update_date in date default hr_api.g_date
345: ,p_information_category in varchar2 default hr_api.g_varchar2
346: ,p_information1 in varchar2 default hr_api.g_varchar2
339: ,p_grade_spine_id in number default hr_api.g_number
340: ,p_sequence in number default hr_api.g_number
341: ,p_request_id in number default hr_api.g_number
342: ,p_program_application_id in number default hr_api.g_number
343: ,p_program_id in number default hr_api.g_number
344: ,p_program_update_date in date default hr_api.g_date
345: ,p_information_category in varchar2 default hr_api.g_varchar2
346: ,p_information1 in varchar2 default hr_api.g_varchar2
347: ,p_information2 in varchar2 default hr_api.g_varchar2
340: ,p_sequence in number default hr_api.g_number
341: ,p_request_id in number default hr_api.g_number
342: ,p_program_application_id in number default hr_api.g_number
343: ,p_program_id in number default hr_api.g_number
344: ,p_program_update_date in date default hr_api.g_date
345: ,p_information_category in varchar2 default hr_api.g_varchar2
346: ,p_information1 in varchar2 default hr_api.g_varchar2
347: ,p_information2 in varchar2 default hr_api.g_varchar2
348: ,p_information3 in varchar2 default hr_api.g_varchar2
341: ,p_request_id in number default hr_api.g_number
342: ,p_program_application_id in number default hr_api.g_number
343: ,p_program_id in number default hr_api.g_number
344: ,p_program_update_date in date default hr_api.g_date
345: ,p_information_category in varchar2 default hr_api.g_varchar2
346: ,p_information1 in varchar2 default hr_api.g_varchar2
347: ,p_information2 in varchar2 default hr_api.g_varchar2
348: ,p_information3 in varchar2 default hr_api.g_varchar2
349: ,p_information4 in varchar2 default hr_api.g_varchar2
342: ,p_program_application_id in number default hr_api.g_number
343: ,p_program_id in number default hr_api.g_number
344: ,p_program_update_date in date default hr_api.g_date
345: ,p_information_category in varchar2 default hr_api.g_varchar2
346: ,p_information1 in varchar2 default hr_api.g_varchar2
347: ,p_information2 in varchar2 default hr_api.g_varchar2
348: ,p_information3 in varchar2 default hr_api.g_varchar2
349: ,p_information4 in varchar2 default hr_api.g_varchar2
350: ,p_information5 in varchar2 default hr_api.g_varchar2
343: ,p_program_id in number default hr_api.g_number
344: ,p_program_update_date in date default hr_api.g_date
345: ,p_information_category in varchar2 default hr_api.g_varchar2
346: ,p_information1 in varchar2 default hr_api.g_varchar2
347: ,p_information2 in varchar2 default hr_api.g_varchar2
348: ,p_information3 in varchar2 default hr_api.g_varchar2
349: ,p_information4 in varchar2 default hr_api.g_varchar2
350: ,p_information5 in varchar2 default hr_api.g_varchar2
351: ,p_information6 in varchar2 default hr_api.g_varchar2
344: ,p_program_update_date in date default hr_api.g_date
345: ,p_information_category in varchar2 default hr_api.g_varchar2
346: ,p_information1 in varchar2 default hr_api.g_varchar2
347: ,p_information2 in varchar2 default hr_api.g_varchar2
348: ,p_information3 in varchar2 default hr_api.g_varchar2
349: ,p_information4 in varchar2 default hr_api.g_varchar2
350: ,p_information5 in varchar2 default hr_api.g_varchar2
351: ,p_information6 in varchar2 default hr_api.g_varchar2
352: ,p_information7 in varchar2 default hr_api.g_varchar2
345: ,p_information_category in varchar2 default hr_api.g_varchar2
346: ,p_information1 in varchar2 default hr_api.g_varchar2
347: ,p_information2 in varchar2 default hr_api.g_varchar2
348: ,p_information3 in varchar2 default hr_api.g_varchar2
349: ,p_information4 in varchar2 default hr_api.g_varchar2
350: ,p_information5 in varchar2 default hr_api.g_varchar2
351: ,p_information6 in varchar2 default hr_api.g_varchar2
352: ,p_information7 in varchar2 default hr_api.g_varchar2
353: ,p_information8 in varchar2 default hr_api.g_varchar2
346: ,p_information1 in varchar2 default hr_api.g_varchar2
347: ,p_information2 in varchar2 default hr_api.g_varchar2
348: ,p_information3 in varchar2 default hr_api.g_varchar2
349: ,p_information4 in varchar2 default hr_api.g_varchar2
350: ,p_information5 in varchar2 default hr_api.g_varchar2
351: ,p_information6 in varchar2 default hr_api.g_varchar2
352: ,p_information7 in varchar2 default hr_api.g_varchar2
353: ,p_information8 in varchar2 default hr_api.g_varchar2
354: ,p_information9 in varchar2 default hr_api.g_varchar2
347: ,p_information2 in varchar2 default hr_api.g_varchar2
348: ,p_information3 in varchar2 default hr_api.g_varchar2
349: ,p_information4 in varchar2 default hr_api.g_varchar2
350: ,p_information5 in varchar2 default hr_api.g_varchar2
351: ,p_information6 in varchar2 default hr_api.g_varchar2
352: ,p_information7 in varchar2 default hr_api.g_varchar2
353: ,p_information8 in varchar2 default hr_api.g_varchar2
354: ,p_information9 in varchar2 default hr_api.g_varchar2
355: ,p_information10 in varchar2 default hr_api.g_varchar2
348: ,p_information3 in varchar2 default hr_api.g_varchar2
349: ,p_information4 in varchar2 default hr_api.g_varchar2
350: ,p_information5 in varchar2 default hr_api.g_varchar2
351: ,p_information6 in varchar2 default hr_api.g_varchar2
352: ,p_information7 in varchar2 default hr_api.g_varchar2
353: ,p_information8 in varchar2 default hr_api.g_varchar2
354: ,p_information9 in varchar2 default hr_api.g_varchar2
355: ,p_information10 in varchar2 default hr_api.g_varchar2
356: ,p_information11 in varchar2 default hr_api.g_varchar2
349: ,p_information4 in varchar2 default hr_api.g_varchar2
350: ,p_information5 in varchar2 default hr_api.g_varchar2
351: ,p_information6 in varchar2 default hr_api.g_varchar2
352: ,p_information7 in varchar2 default hr_api.g_varchar2
353: ,p_information8 in varchar2 default hr_api.g_varchar2
354: ,p_information9 in varchar2 default hr_api.g_varchar2
355: ,p_information10 in varchar2 default hr_api.g_varchar2
356: ,p_information11 in varchar2 default hr_api.g_varchar2
357: ,p_information12 in varchar2 default hr_api.g_varchar2
350: ,p_information5 in varchar2 default hr_api.g_varchar2
351: ,p_information6 in varchar2 default hr_api.g_varchar2
352: ,p_information7 in varchar2 default hr_api.g_varchar2
353: ,p_information8 in varchar2 default hr_api.g_varchar2
354: ,p_information9 in varchar2 default hr_api.g_varchar2
355: ,p_information10 in varchar2 default hr_api.g_varchar2
356: ,p_information11 in varchar2 default hr_api.g_varchar2
357: ,p_information12 in varchar2 default hr_api.g_varchar2
358: ,p_information13 in varchar2 default hr_api.g_varchar2
351: ,p_information6 in varchar2 default hr_api.g_varchar2
352: ,p_information7 in varchar2 default hr_api.g_varchar2
353: ,p_information8 in varchar2 default hr_api.g_varchar2
354: ,p_information9 in varchar2 default hr_api.g_varchar2
355: ,p_information10 in varchar2 default hr_api.g_varchar2
356: ,p_information11 in varchar2 default hr_api.g_varchar2
357: ,p_information12 in varchar2 default hr_api.g_varchar2
358: ,p_information13 in varchar2 default hr_api.g_varchar2
359: ,p_information14 in varchar2 default hr_api.g_varchar2
352: ,p_information7 in varchar2 default hr_api.g_varchar2
353: ,p_information8 in varchar2 default hr_api.g_varchar2
354: ,p_information9 in varchar2 default hr_api.g_varchar2
355: ,p_information10 in varchar2 default hr_api.g_varchar2
356: ,p_information11 in varchar2 default hr_api.g_varchar2
357: ,p_information12 in varchar2 default hr_api.g_varchar2
358: ,p_information13 in varchar2 default hr_api.g_varchar2
359: ,p_information14 in varchar2 default hr_api.g_varchar2
360: ,p_information15 in varchar2 default hr_api.g_varchar2
353: ,p_information8 in varchar2 default hr_api.g_varchar2
354: ,p_information9 in varchar2 default hr_api.g_varchar2
355: ,p_information10 in varchar2 default hr_api.g_varchar2
356: ,p_information11 in varchar2 default hr_api.g_varchar2
357: ,p_information12 in varchar2 default hr_api.g_varchar2
358: ,p_information13 in varchar2 default hr_api.g_varchar2
359: ,p_information14 in varchar2 default hr_api.g_varchar2
360: ,p_information15 in varchar2 default hr_api.g_varchar2
361: ,p_information16 in varchar2 default hr_api.g_varchar2
354: ,p_information9 in varchar2 default hr_api.g_varchar2
355: ,p_information10 in varchar2 default hr_api.g_varchar2
356: ,p_information11 in varchar2 default hr_api.g_varchar2
357: ,p_information12 in varchar2 default hr_api.g_varchar2
358: ,p_information13 in varchar2 default hr_api.g_varchar2
359: ,p_information14 in varchar2 default hr_api.g_varchar2
360: ,p_information15 in varchar2 default hr_api.g_varchar2
361: ,p_information16 in varchar2 default hr_api.g_varchar2
362: ,p_information17 in varchar2 default hr_api.g_varchar2
355: ,p_information10 in varchar2 default hr_api.g_varchar2
356: ,p_information11 in varchar2 default hr_api.g_varchar2
357: ,p_information12 in varchar2 default hr_api.g_varchar2
358: ,p_information13 in varchar2 default hr_api.g_varchar2
359: ,p_information14 in varchar2 default hr_api.g_varchar2
360: ,p_information15 in varchar2 default hr_api.g_varchar2
361: ,p_information16 in varchar2 default hr_api.g_varchar2
362: ,p_information17 in varchar2 default hr_api.g_varchar2
363: ,p_information18 in varchar2 default hr_api.g_varchar2
356: ,p_information11 in varchar2 default hr_api.g_varchar2
357: ,p_information12 in varchar2 default hr_api.g_varchar2
358: ,p_information13 in varchar2 default hr_api.g_varchar2
359: ,p_information14 in varchar2 default hr_api.g_varchar2
360: ,p_information15 in varchar2 default hr_api.g_varchar2
361: ,p_information16 in varchar2 default hr_api.g_varchar2
362: ,p_information17 in varchar2 default hr_api.g_varchar2
363: ,p_information18 in varchar2 default hr_api.g_varchar2
364: ,p_information19 in varchar2 default hr_api.g_varchar2
357: ,p_information12 in varchar2 default hr_api.g_varchar2
358: ,p_information13 in varchar2 default hr_api.g_varchar2
359: ,p_information14 in varchar2 default hr_api.g_varchar2
360: ,p_information15 in varchar2 default hr_api.g_varchar2
361: ,p_information16 in varchar2 default hr_api.g_varchar2
362: ,p_information17 in varchar2 default hr_api.g_varchar2
363: ,p_information18 in varchar2 default hr_api.g_varchar2
364: ,p_information19 in varchar2 default hr_api.g_varchar2
365: ,p_information20 in varchar2 default hr_api.g_varchar2
358: ,p_information13 in varchar2 default hr_api.g_varchar2
359: ,p_information14 in varchar2 default hr_api.g_varchar2
360: ,p_information15 in varchar2 default hr_api.g_varchar2
361: ,p_information16 in varchar2 default hr_api.g_varchar2
362: ,p_information17 in varchar2 default hr_api.g_varchar2
363: ,p_information18 in varchar2 default hr_api.g_varchar2
364: ,p_information19 in varchar2 default hr_api.g_varchar2
365: ,p_information20 in varchar2 default hr_api.g_varchar2
366: ,p_information21 in varchar2 default hr_api.g_varchar2
359: ,p_information14 in varchar2 default hr_api.g_varchar2
360: ,p_information15 in varchar2 default hr_api.g_varchar2
361: ,p_information16 in varchar2 default hr_api.g_varchar2
362: ,p_information17 in varchar2 default hr_api.g_varchar2
363: ,p_information18 in varchar2 default hr_api.g_varchar2
364: ,p_information19 in varchar2 default hr_api.g_varchar2
365: ,p_information20 in varchar2 default hr_api.g_varchar2
366: ,p_information21 in varchar2 default hr_api.g_varchar2
367: ,p_information22 in varchar2 default hr_api.g_varchar2
360: ,p_information15 in varchar2 default hr_api.g_varchar2
361: ,p_information16 in varchar2 default hr_api.g_varchar2
362: ,p_information17 in varchar2 default hr_api.g_varchar2
363: ,p_information18 in varchar2 default hr_api.g_varchar2
364: ,p_information19 in varchar2 default hr_api.g_varchar2
365: ,p_information20 in varchar2 default hr_api.g_varchar2
366: ,p_information21 in varchar2 default hr_api.g_varchar2
367: ,p_information22 in varchar2 default hr_api.g_varchar2
368: ,p_information23 in varchar2 default hr_api.g_varchar2
361: ,p_information16 in varchar2 default hr_api.g_varchar2
362: ,p_information17 in varchar2 default hr_api.g_varchar2
363: ,p_information18 in varchar2 default hr_api.g_varchar2
364: ,p_information19 in varchar2 default hr_api.g_varchar2
365: ,p_information20 in varchar2 default hr_api.g_varchar2
366: ,p_information21 in varchar2 default hr_api.g_varchar2
367: ,p_information22 in varchar2 default hr_api.g_varchar2
368: ,p_information23 in varchar2 default hr_api.g_varchar2
369: ,p_information24 in varchar2 default hr_api.g_varchar2
362: ,p_information17 in varchar2 default hr_api.g_varchar2
363: ,p_information18 in varchar2 default hr_api.g_varchar2
364: ,p_information19 in varchar2 default hr_api.g_varchar2
365: ,p_information20 in varchar2 default hr_api.g_varchar2
366: ,p_information21 in varchar2 default hr_api.g_varchar2
367: ,p_information22 in varchar2 default hr_api.g_varchar2
368: ,p_information23 in varchar2 default hr_api.g_varchar2
369: ,p_information24 in varchar2 default hr_api.g_varchar2
370: ,p_information25 in varchar2 default hr_api.g_varchar2
363: ,p_information18 in varchar2 default hr_api.g_varchar2
364: ,p_information19 in varchar2 default hr_api.g_varchar2
365: ,p_information20 in varchar2 default hr_api.g_varchar2
366: ,p_information21 in varchar2 default hr_api.g_varchar2
367: ,p_information22 in varchar2 default hr_api.g_varchar2
368: ,p_information23 in varchar2 default hr_api.g_varchar2
369: ,p_information24 in varchar2 default hr_api.g_varchar2
370: ,p_information25 in varchar2 default hr_api.g_varchar2
371: ,p_information26 in varchar2 default hr_api.g_varchar2
364: ,p_information19 in varchar2 default hr_api.g_varchar2
365: ,p_information20 in varchar2 default hr_api.g_varchar2
366: ,p_information21 in varchar2 default hr_api.g_varchar2
367: ,p_information22 in varchar2 default hr_api.g_varchar2
368: ,p_information23 in varchar2 default hr_api.g_varchar2
369: ,p_information24 in varchar2 default hr_api.g_varchar2
370: ,p_information25 in varchar2 default hr_api.g_varchar2
371: ,p_information26 in varchar2 default hr_api.g_varchar2
372: ,p_information27 in varchar2 default hr_api.g_varchar2
365: ,p_information20 in varchar2 default hr_api.g_varchar2
366: ,p_information21 in varchar2 default hr_api.g_varchar2
367: ,p_information22 in varchar2 default hr_api.g_varchar2
368: ,p_information23 in varchar2 default hr_api.g_varchar2
369: ,p_information24 in varchar2 default hr_api.g_varchar2
370: ,p_information25 in varchar2 default hr_api.g_varchar2
371: ,p_information26 in varchar2 default hr_api.g_varchar2
372: ,p_information27 in varchar2 default hr_api.g_varchar2
373: ,p_information28 in varchar2 default hr_api.g_varchar2
366: ,p_information21 in varchar2 default hr_api.g_varchar2
367: ,p_information22 in varchar2 default hr_api.g_varchar2
368: ,p_information23 in varchar2 default hr_api.g_varchar2
369: ,p_information24 in varchar2 default hr_api.g_varchar2
370: ,p_information25 in varchar2 default hr_api.g_varchar2
371: ,p_information26 in varchar2 default hr_api.g_varchar2
372: ,p_information27 in varchar2 default hr_api.g_varchar2
373: ,p_information28 in varchar2 default hr_api.g_varchar2
374: ,p_information29 in varchar2 default hr_api.g_varchar2
367: ,p_information22 in varchar2 default hr_api.g_varchar2
368: ,p_information23 in varchar2 default hr_api.g_varchar2
369: ,p_information24 in varchar2 default hr_api.g_varchar2
370: ,p_information25 in varchar2 default hr_api.g_varchar2
371: ,p_information26 in varchar2 default hr_api.g_varchar2
372: ,p_information27 in varchar2 default hr_api.g_varchar2
373: ,p_information28 in varchar2 default hr_api.g_varchar2
374: ,p_information29 in varchar2 default hr_api.g_varchar2
375: ,p_information30 in varchar2 default hr_api.g_varchar2
368: ,p_information23 in varchar2 default hr_api.g_varchar2
369: ,p_information24 in varchar2 default hr_api.g_varchar2
370: ,p_information25 in varchar2 default hr_api.g_varchar2
371: ,p_information26 in varchar2 default hr_api.g_varchar2
372: ,p_information27 in varchar2 default hr_api.g_varchar2
373: ,p_information28 in varchar2 default hr_api.g_varchar2
374: ,p_information29 in varchar2 default hr_api.g_varchar2
375: ,p_information30 in varchar2 default hr_api.g_varchar2
376: ,p_effective_start_date out nocopy date
369: ,p_information24 in varchar2 default hr_api.g_varchar2
370: ,p_information25 in varchar2 default hr_api.g_varchar2
371: ,p_information26 in varchar2 default hr_api.g_varchar2
372: ,p_information27 in varchar2 default hr_api.g_varchar2
373: ,p_information28 in varchar2 default hr_api.g_varchar2
374: ,p_information29 in varchar2 default hr_api.g_varchar2
375: ,p_information30 in varchar2 default hr_api.g_varchar2
376: ,p_effective_start_date out nocopy date
377: ,p_effective_end_date out nocopy date
370: ,p_information25 in varchar2 default hr_api.g_varchar2
371: ,p_information26 in varchar2 default hr_api.g_varchar2
372: ,p_information27 in varchar2 default hr_api.g_varchar2
373: ,p_information28 in varchar2 default hr_api.g_varchar2
374: ,p_information29 in varchar2 default hr_api.g_varchar2
375: ,p_information30 in varchar2 default hr_api.g_varchar2
376: ,p_effective_start_date out nocopy date
377: ,p_effective_end_date out nocopy date
378: ) is
371: ,p_information26 in varchar2 default hr_api.g_varchar2
372: ,p_information27 in varchar2 default hr_api.g_varchar2
373: ,p_information28 in varchar2 default hr_api.g_varchar2
374: ,p_information29 in varchar2 default hr_api.g_varchar2
375: ,p_information30 in varchar2 default hr_api.g_varchar2
376: ,p_effective_start_date out nocopy date
377: ,p_effective_end_date out nocopy date
378: ) is
379:
464: ,p_datetrack_mode => p_datetrack_mode
465: ,p_object_version_number => l_object_version_number
466: );
467: exception
468: when hr_api.cannot_find_prog_unit then
469: hr_api.cannot_find_prog_unit_error
470: (p_module_name => 'UPDATE_GRADE_STEP'
471: ,p_hook_type => 'BP'
472: );
465: ,p_object_version_number => l_object_version_number
466: );
467: exception
468: when hr_api.cannot_find_prog_unit then
469: hr_api.cannot_find_prog_unit_error
470: (p_module_name => 'UPDATE_GRADE_STEP'
471: ,p_hook_type => 'BP'
472: );
473: --
594: ,p_effective_start_date => l_effective_start_date
595: ,p_effective_end_date => l_effective_end_date
596: );
597: exception
598: when hr_api.cannot_find_prog_unit then
599: hr_api.cannot_find_prog_unit_error
600: (p_module_name => 'UPDATE_GRADE_STEP'
601: ,p_hook_type => 'AP'
602: );
595: ,p_effective_end_date => l_effective_end_date
596: );
597: exception
598: when hr_api.cannot_find_prog_unit then
599: hr_api.cannot_find_prog_unit_error
600: (p_module_name => 'UPDATE_GRADE_STEP'
601: ,p_hook_type => 'AP'
602: );
603: --
608: -- When in validation only mode raise the Validate_Enabled exception
609: --
610: if p_validate
611: then
612: raise hr_api.validate_enabled;
613: end if;
614: --
615: hr_utility.set_location(l_proc, 50);
616: --
623: hr_utility.set_location(' Leaving:' ||l_proc, 60);
624: --
625: exception
626: --
627: when hr_api.validate_enabled then
628: --
629: -- As the Validate_Enabled exception has been raised
630: -- we must rollback to the savepoint
631: --
746: ,p_step_id => p_step_id
747: ,p_object_version_number => l_object_version_number
748: );
749: exception
750: when hr_api.cannot_find_prog_unit then
751: hr_api.cannot_find_prog_unit_error
752: (p_module_name => 'DELETE_GRADE_STEP'
753: ,p_hook_type => 'BP'
754: );
747: ,p_object_version_number => l_object_version_number
748: );
749: exception
750: when hr_api.cannot_find_prog_unit then
751: hr_api.cannot_find_prog_unit_error
752: (p_module_name => 'DELETE_GRADE_STEP'
753: ,p_hook_type => 'BP'
754: );
755: end;
784: ,p_effective_start_date => l_effective_start_date
785: ,p_effective_end_date => l_effective_end_date
786: );
787: exception
788: when hr_api.cannot_find_prog_unit then
789: hr_api.cannot_find_prog_unit_error
790: (p_module_name => 'DELETE_GRADE_STEP'
791: ,p_hook_type => 'AP'
792: );
785: ,p_effective_end_date => l_effective_end_date
786: );
787: exception
788: when hr_api.cannot_find_prog_unit then
789: hr_api.cannot_find_prog_unit_error
790: (p_module_name => 'DELETE_GRADE_STEP'
791: ,p_hook_type => 'AP'
792: );
793: end;
798: --
799: -- When in validation only mode raise the Validate_Enabled exception
800: --
801: if p_validate then
802: raise hr_api.validate_enabled;
803: end if;
804:
805: --
806: -- Set all output arguments (returned by some dt modes only)
808: p_object_version_number := l_object_version_number;
809:
810: hr_utility.set_location(' Leaving:'||l_proc, 100);
811: exception
812: when hr_api.validate_enabled then
813: hr_utility.set_location(' Leaving...:'||l_proc, 50);
814: --
815: -- As the Validate_Enabled exception has been raised
816: -- we must rollback to the savepoint