129: ,p_information29 => p_information29
130: ,p_information30 => p_information30
131: );
132: exception
133: when hr_api.cannot_find_prog_unit then
134: hr_api.cannot_find_prog_unit_error
135: (p_module_name => 'CREATE_PROGRESSION_POINT'
136: ,p_hook_type => 'BP'
137: );
130: ,p_information30 => p_information30
131: );
132: exception
133: when hr_api.cannot_find_prog_unit then
134: hr_api.cannot_find_prog_unit_error
135: (p_module_name => 'CREATE_PROGRESSION_POINT'
136: ,p_hook_type => 'BP'
137: );
138: --
246: ,p_information29 => p_information29
247: ,p_information30 => p_information30
248: );
249: exception
250: when hr_api.cannot_find_prog_unit then
251: hr_api.cannot_find_prog_unit_error
252: (p_module_name => 'CREATE_PREGORESSION_POINT'
253: ,p_hook_type => 'AP'
254: );
247: ,p_information30 => p_information30
248: );
249: exception
250: when hr_api.cannot_find_prog_unit then
251: hr_api.cannot_find_prog_unit_error
252: (p_module_name => 'CREATE_PREGORESSION_POINT'
253: ,p_hook_type => 'AP'
254: );
255: --
260: -- When in validation only mode raise the Validate_Enabled exception
261: --
262: if p_validate
263: then
264: raise hr_api.validate_enabled;
265: end if;
266: --
267: hr_utility.set_location(l_proc, 50);
268: --
274: hr_utility.set_location(' Leaving:' ||l_proc, 60);
275: --
276: exception
277: --
278: when hr_api.validate_enabled then
279: --
280: -- As the Validate_Enabled exception has been raised
281: -- we must rollback to the savepoint
282: --
314: --
315: procedure update_progression_point
316: (p_validate in boolean default false
317: ,p_spinal_point_id in number
318: ,p_effective_date in date default hr_api.g_date
319: ,p_business_group_id in number default hr_api.g_number
320: ,p_parent_spine_id in number default hr_api.g_number
321: ,p_sequence in number default hr_api.g_number
322: ,p_spinal_point in varchar2 default hr_api.g_varchar2
315: procedure update_progression_point
316: (p_validate in boolean default false
317: ,p_spinal_point_id in number
318: ,p_effective_date in date default hr_api.g_date
319: ,p_business_group_id in number default hr_api.g_number
320: ,p_parent_spine_id in number default hr_api.g_number
321: ,p_sequence in number default hr_api.g_number
322: ,p_spinal_point in varchar2 default hr_api.g_varchar2
323: ,p_request_id in number default hr_api.g_number
316: (p_validate in boolean default false
317: ,p_spinal_point_id in number
318: ,p_effective_date in date default hr_api.g_date
319: ,p_business_group_id in number default hr_api.g_number
320: ,p_parent_spine_id in number default hr_api.g_number
321: ,p_sequence in number default hr_api.g_number
322: ,p_spinal_point in varchar2 default hr_api.g_varchar2
323: ,p_request_id in number default hr_api.g_number
324: ,p_program_application_id in number default hr_api.g_number
317: ,p_spinal_point_id in number
318: ,p_effective_date in date default hr_api.g_date
319: ,p_business_group_id in number default hr_api.g_number
320: ,p_parent_spine_id in number default hr_api.g_number
321: ,p_sequence in number default hr_api.g_number
322: ,p_spinal_point in varchar2 default hr_api.g_varchar2
323: ,p_request_id in number default hr_api.g_number
324: ,p_program_application_id in number default hr_api.g_number
325: ,p_program_id in number default hr_api.g_number
318: ,p_effective_date in date default hr_api.g_date
319: ,p_business_group_id in number default hr_api.g_number
320: ,p_parent_spine_id in number default hr_api.g_number
321: ,p_sequence in number default hr_api.g_number
322: ,p_spinal_point in varchar2 default hr_api.g_varchar2
323: ,p_request_id in number default hr_api.g_number
324: ,p_program_application_id in number default hr_api.g_number
325: ,p_program_id in number default hr_api.g_number
326: ,p_program_update_date in date default hr_api.g_date
319: ,p_business_group_id in number default hr_api.g_number
320: ,p_parent_spine_id in number default hr_api.g_number
321: ,p_sequence in number default hr_api.g_number
322: ,p_spinal_point in varchar2 default hr_api.g_varchar2
323: ,p_request_id in number default hr_api.g_number
324: ,p_program_application_id in number default hr_api.g_number
325: ,p_program_id in number default hr_api.g_number
326: ,p_program_update_date in date default hr_api.g_date
327: ,p_information_category in varchar2 default hr_api.g_varchar2
320: ,p_parent_spine_id in number default hr_api.g_number
321: ,p_sequence in number default hr_api.g_number
322: ,p_spinal_point in varchar2 default hr_api.g_varchar2
323: ,p_request_id in number default hr_api.g_number
324: ,p_program_application_id in number default hr_api.g_number
325: ,p_program_id in number default hr_api.g_number
326: ,p_program_update_date in date default hr_api.g_date
327: ,p_information_category in varchar2 default hr_api.g_varchar2
328: ,p_information1 in varchar2 default hr_api.g_varchar2
321: ,p_sequence in number default hr_api.g_number
322: ,p_spinal_point in varchar2 default hr_api.g_varchar2
323: ,p_request_id in number default hr_api.g_number
324: ,p_program_application_id in number default hr_api.g_number
325: ,p_program_id in number default hr_api.g_number
326: ,p_program_update_date in date default hr_api.g_date
327: ,p_information_category in varchar2 default hr_api.g_varchar2
328: ,p_information1 in varchar2 default hr_api.g_varchar2
329: ,p_information2 in varchar2 default hr_api.g_varchar2
322: ,p_spinal_point in varchar2 default hr_api.g_varchar2
323: ,p_request_id in number default hr_api.g_number
324: ,p_program_application_id in number default hr_api.g_number
325: ,p_program_id in number default hr_api.g_number
326: ,p_program_update_date in date default hr_api.g_date
327: ,p_information_category in varchar2 default hr_api.g_varchar2
328: ,p_information1 in varchar2 default hr_api.g_varchar2
329: ,p_information2 in varchar2 default hr_api.g_varchar2
330: ,p_information3 in varchar2 default hr_api.g_varchar2
323: ,p_request_id in number default hr_api.g_number
324: ,p_program_application_id in number default hr_api.g_number
325: ,p_program_id in number default hr_api.g_number
326: ,p_program_update_date in date default hr_api.g_date
327: ,p_information_category in varchar2 default hr_api.g_varchar2
328: ,p_information1 in varchar2 default hr_api.g_varchar2
329: ,p_information2 in varchar2 default hr_api.g_varchar2
330: ,p_information3 in varchar2 default hr_api.g_varchar2
331: ,p_information4 in varchar2 default hr_api.g_varchar2
324: ,p_program_application_id in number default hr_api.g_number
325: ,p_program_id in number default hr_api.g_number
326: ,p_program_update_date in date default hr_api.g_date
327: ,p_information_category in varchar2 default hr_api.g_varchar2
328: ,p_information1 in varchar2 default hr_api.g_varchar2
329: ,p_information2 in varchar2 default hr_api.g_varchar2
330: ,p_information3 in varchar2 default hr_api.g_varchar2
331: ,p_information4 in varchar2 default hr_api.g_varchar2
332: ,p_information5 in varchar2 default hr_api.g_varchar2
325: ,p_program_id in number default hr_api.g_number
326: ,p_program_update_date in date default hr_api.g_date
327: ,p_information_category in varchar2 default hr_api.g_varchar2
328: ,p_information1 in varchar2 default hr_api.g_varchar2
329: ,p_information2 in varchar2 default hr_api.g_varchar2
330: ,p_information3 in varchar2 default hr_api.g_varchar2
331: ,p_information4 in varchar2 default hr_api.g_varchar2
332: ,p_information5 in varchar2 default hr_api.g_varchar2
333: ,p_information6 in varchar2 default hr_api.g_varchar2
326: ,p_program_update_date in date default hr_api.g_date
327: ,p_information_category in varchar2 default hr_api.g_varchar2
328: ,p_information1 in varchar2 default hr_api.g_varchar2
329: ,p_information2 in varchar2 default hr_api.g_varchar2
330: ,p_information3 in varchar2 default hr_api.g_varchar2
331: ,p_information4 in varchar2 default hr_api.g_varchar2
332: ,p_information5 in varchar2 default hr_api.g_varchar2
333: ,p_information6 in varchar2 default hr_api.g_varchar2
334: ,p_information7 in varchar2 default hr_api.g_varchar2
327: ,p_information_category in varchar2 default hr_api.g_varchar2
328: ,p_information1 in varchar2 default hr_api.g_varchar2
329: ,p_information2 in varchar2 default hr_api.g_varchar2
330: ,p_information3 in varchar2 default hr_api.g_varchar2
331: ,p_information4 in varchar2 default hr_api.g_varchar2
332: ,p_information5 in varchar2 default hr_api.g_varchar2
333: ,p_information6 in varchar2 default hr_api.g_varchar2
334: ,p_information7 in varchar2 default hr_api.g_varchar2
335: ,p_information8 in varchar2 default hr_api.g_varchar2
328: ,p_information1 in varchar2 default hr_api.g_varchar2
329: ,p_information2 in varchar2 default hr_api.g_varchar2
330: ,p_information3 in varchar2 default hr_api.g_varchar2
331: ,p_information4 in varchar2 default hr_api.g_varchar2
332: ,p_information5 in varchar2 default hr_api.g_varchar2
333: ,p_information6 in varchar2 default hr_api.g_varchar2
334: ,p_information7 in varchar2 default hr_api.g_varchar2
335: ,p_information8 in varchar2 default hr_api.g_varchar2
336: ,p_information9 in varchar2 default hr_api.g_varchar2
329: ,p_information2 in varchar2 default hr_api.g_varchar2
330: ,p_information3 in varchar2 default hr_api.g_varchar2
331: ,p_information4 in varchar2 default hr_api.g_varchar2
332: ,p_information5 in varchar2 default hr_api.g_varchar2
333: ,p_information6 in varchar2 default hr_api.g_varchar2
334: ,p_information7 in varchar2 default hr_api.g_varchar2
335: ,p_information8 in varchar2 default hr_api.g_varchar2
336: ,p_information9 in varchar2 default hr_api.g_varchar2
337: ,p_information10 in varchar2 default hr_api.g_varchar2
330: ,p_information3 in varchar2 default hr_api.g_varchar2
331: ,p_information4 in varchar2 default hr_api.g_varchar2
332: ,p_information5 in varchar2 default hr_api.g_varchar2
333: ,p_information6 in varchar2 default hr_api.g_varchar2
334: ,p_information7 in varchar2 default hr_api.g_varchar2
335: ,p_information8 in varchar2 default hr_api.g_varchar2
336: ,p_information9 in varchar2 default hr_api.g_varchar2
337: ,p_information10 in varchar2 default hr_api.g_varchar2
338: ,p_information11 in varchar2 default hr_api.g_varchar2
331: ,p_information4 in varchar2 default hr_api.g_varchar2
332: ,p_information5 in varchar2 default hr_api.g_varchar2
333: ,p_information6 in varchar2 default hr_api.g_varchar2
334: ,p_information7 in varchar2 default hr_api.g_varchar2
335: ,p_information8 in varchar2 default hr_api.g_varchar2
336: ,p_information9 in varchar2 default hr_api.g_varchar2
337: ,p_information10 in varchar2 default hr_api.g_varchar2
338: ,p_information11 in varchar2 default hr_api.g_varchar2
339: ,p_information12 in varchar2 default hr_api.g_varchar2
332: ,p_information5 in varchar2 default hr_api.g_varchar2
333: ,p_information6 in varchar2 default hr_api.g_varchar2
334: ,p_information7 in varchar2 default hr_api.g_varchar2
335: ,p_information8 in varchar2 default hr_api.g_varchar2
336: ,p_information9 in varchar2 default hr_api.g_varchar2
337: ,p_information10 in varchar2 default hr_api.g_varchar2
338: ,p_information11 in varchar2 default hr_api.g_varchar2
339: ,p_information12 in varchar2 default hr_api.g_varchar2
340: ,p_information13 in varchar2 default hr_api.g_varchar2
333: ,p_information6 in varchar2 default hr_api.g_varchar2
334: ,p_information7 in varchar2 default hr_api.g_varchar2
335: ,p_information8 in varchar2 default hr_api.g_varchar2
336: ,p_information9 in varchar2 default hr_api.g_varchar2
337: ,p_information10 in varchar2 default hr_api.g_varchar2
338: ,p_information11 in varchar2 default hr_api.g_varchar2
339: ,p_information12 in varchar2 default hr_api.g_varchar2
340: ,p_information13 in varchar2 default hr_api.g_varchar2
341: ,p_information14 in varchar2 default hr_api.g_varchar2
334: ,p_information7 in varchar2 default hr_api.g_varchar2
335: ,p_information8 in varchar2 default hr_api.g_varchar2
336: ,p_information9 in varchar2 default hr_api.g_varchar2
337: ,p_information10 in varchar2 default hr_api.g_varchar2
338: ,p_information11 in varchar2 default hr_api.g_varchar2
339: ,p_information12 in varchar2 default hr_api.g_varchar2
340: ,p_information13 in varchar2 default hr_api.g_varchar2
341: ,p_information14 in varchar2 default hr_api.g_varchar2
342: ,p_information15 in varchar2 default hr_api.g_varchar2
335: ,p_information8 in varchar2 default hr_api.g_varchar2
336: ,p_information9 in varchar2 default hr_api.g_varchar2
337: ,p_information10 in varchar2 default hr_api.g_varchar2
338: ,p_information11 in varchar2 default hr_api.g_varchar2
339: ,p_information12 in varchar2 default hr_api.g_varchar2
340: ,p_information13 in varchar2 default hr_api.g_varchar2
341: ,p_information14 in varchar2 default hr_api.g_varchar2
342: ,p_information15 in varchar2 default hr_api.g_varchar2
343: ,p_information16 in varchar2 default hr_api.g_varchar2
336: ,p_information9 in varchar2 default hr_api.g_varchar2
337: ,p_information10 in varchar2 default hr_api.g_varchar2
338: ,p_information11 in varchar2 default hr_api.g_varchar2
339: ,p_information12 in varchar2 default hr_api.g_varchar2
340: ,p_information13 in varchar2 default hr_api.g_varchar2
341: ,p_information14 in varchar2 default hr_api.g_varchar2
342: ,p_information15 in varchar2 default hr_api.g_varchar2
343: ,p_information16 in varchar2 default hr_api.g_varchar2
344: ,p_information17 in varchar2 default hr_api.g_varchar2
337: ,p_information10 in varchar2 default hr_api.g_varchar2
338: ,p_information11 in varchar2 default hr_api.g_varchar2
339: ,p_information12 in varchar2 default hr_api.g_varchar2
340: ,p_information13 in varchar2 default hr_api.g_varchar2
341: ,p_information14 in varchar2 default hr_api.g_varchar2
342: ,p_information15 in varchar2 default hr_api.g_varchar2
343: ,p_information16 in varchar2 default hr_api.g_varchar2
344: ,p_information17 in varchar2 default hr_api.g_varchar2
345: ,p_information18 in varchar2 default hr_api.g_varchar2
338: ,p_information11 in varchar2 default hr_api.g_varchar2
339: ,p_information12 in varchar2 default hr_api.g_varchar2
340: ,p_information13 in varchar2 default hr_api.g_varchar2
341: ,p_information14 in varchar2 default hr_api.g_varchar2
342: ,p_information15 in varchar2 default hr_api.g_varchar2
343: ,p_information16 in varchar2 default hr_api.g_varchar2
344: ,p_information17 in varchar2 default hr_api.g_varchar2
345: ,p_information18 in varchar2 default hr_api.g_varchar2
346: ,p_information19 in varchar2 default hr_api.g_varchar2
339: ,p_information12 in varchar2 default hr_api.g_varchar2
340: ,p_information13 in varchar2 default hr_api.g_varchar2
341: ,p_information14 in varchar2 default hr_api.g_varchar2
342: ,p_information15 in varchar2 default hr_api.g_varchar2
343: ,p_information16 in varchar2 default hr_api.g_varchar2
344: ,p_information17 in varchar2 default hr_api.g_varchar2
345: ,p_information18 in varchar2 default hr_api.g_varchar2
346: ,p_information19 in varchar2 default hr_api.g_varchar2
347: ,p_information20 in varchar2 default hr_api.g_varchar2
340: ,p_information13 in varchar2 default hr_api.g_varchar2
341: ,p_information14 in varchar2 default hr_api.g_varchar2
342: ,p_information15 in varchar2 default hr_api.g_varchar2
343: ,p_information16 in varchar2 default hr_api.g_varchar2
344: ,p_information17 in varchar2 default hr_api.g_varchar2
345: ,p_information18 in varchar2 default hr_api.g_varchar2
346: ,p_information19 in varchar2 default hr_api.g_varchar2
347: ,p_information20 in varchar2 default hr_api.g_varchar2
348: ,p_information21 in varchar2 default hr_api.g_varchar2
341: ,p_information14 in varchar2 default hr_api.g_varchar2
342: ,p_information15 in varchar2 default hr_api.g_varchar2
343: ,p_information16 in varchar2 default hr_api.g_varchar2
344: ,p_information17 in varchar2 default hr_api.g_varchar2
345: ,p_information18 in varchar2 default hr_api.g_varchar2
346: ,p_information19 in varchar2 default hr_api.g_varchar2
347: ,p_information20 in varchar2 default hr_api.g_varchar2
348: ,p_information21 in varchar2 default hr_api.g_varchar2
349: ,p_information22 in varchar2 default hr_api.g_varchar2
342: ,p_information15 in varchar2 default hr_api.g_varchar2
343: ,p_information16 in varchar2 default hr_api.g_varchar2
344: ,p_information17 in varchar2 default hr_api.g_varchar2
345: ,p_information18 in varchar2 default hr_api.g_varchar2
346: ,p_information19 in varchar2 default hr_api.g_varchar2
347: ,p_information20 in varchar2 default hr_api.g_varchar2
348: ,p_information21 in varchar2 default hr_api.g_varchar2
349: ,p_information22 in varchar2 default hr_api.g_varchar2
350: ,p_information23 in varchar2 default hr_api.g_varchar2
343: ,p_information16 in varchar2 default hr_api.g_varchar2
344: ,p_information17 in varchar2 default hr_api.g_varchar2
345: ,p_information18 in varchar2 default hr_api.g_varchar2
346: ,p_information19 in varchar2 default hr_api.g_varchar2
347: ,p_information20 in varchar2 default hr_api.g_varchar2
348: ,p_information21 in varchar2 default hr_api.g_varchar2
349: ,p_information22 in varchar2 default hr_api.g_varchar2
350: ,p_information23 in varchar2 default hr_api.g_varchar2
351: ,p_information24 in varchar2 default hr_api.g_varchar2
344: ,p_information17 in varchar2 default hr_api.g_varchar2
345: ,p_information18 in varchar2 default hr_api.g_varchar2
346: ,p_information19 in varchar2 default hr_api.g_varchar2
347: ,p_information20 in varchar2 default hr_api.g_varchar2
348: ,p_information21 in varchar2 default hr_api.g_varchar2
349: ,p_information22 in varchar2 default hr_api.g_varchar2
350: ,p_information23 in varchar2 default hr_api.g_varchar2
351: ,p_information24 in varchar2 default hr_api.g_varchar2
352: ,p_information25 in varchar2 default hr_api.g_varchar2
345: ,p_information18 in varchar2 default hr_api.g_varchar2
346: ,p_information19 in varchar2 default hr_api.g_varchar2
347: ,p_information20 in varchar2 default hr_api.g_varchar2
348: ,p_information21 in varchar2 default hr_api.g_varchar2
349: ,p_information22 in varchar2 default hr_api.g_varchar2
350: ,p_information23 in varchar2 default hr_api.g_varchar2
351: ,p_information24 in varchar2 default hr_api.g_varchar2
352: ,p_information25 in varchar2 default hr_api.g_varchar2
353: ,p_information26 in varchar2 default hr_api.g_varchar2
346: ,p_information19 in varchar2 default hr_api.g_varchar2
347: ,p_information20 in varchar2 default hr_api.g_varchar2
348: ,p_information21 in varchar2 default hr_api.g_varchar2
349: ,p_information22 in varchar2 default hr_api.g_varchar2
350: ,p_information23 in varchar2 default hr_api.g_varchar2
351: ,p_information24 in varchar2 default hr_api.g_varchar2
352: ,p_information25 in varchar2 default hr_api.g_varchar2
353: ,p_information26 in varchar2 default hr_api.g_varchar2
354: ,p_information27 in varchar2 default hr_api.g_varchar2
347: ,p_information20 in varchar2 default hr_api.g_varchar2
348: ,p_information21 in varchar2 default hr_api.g_varchar2
349: ,p_information22 in varchar2 default hr_api.g_varchar2
350: ,p_information23 in varchar2 default hr_api.g_varchar2
351: ,p_information24 in varchar2 default hr_api.g_varchar2
352: ,p_information25 in varchar2 default hr_api.g_varchar2
353: ,p_information26 in varchar2 default hr_api.g_varchar2
354: ,p_information27 in varchar2 default hr_api.g_varchar2
355: ,p_information28 in varchar2 default hr_api.g_varchar2
348: ,p_information21 in varchar2 default hr_api.g_varchar2
349: ,p_information22 in varchar2 default hr_api.g_varchar2
350: ,p_information23 in varchar2 default hr_api.g_varchar2
351: ,p_information24 in varchar2 default hr_api.g_varchar2
352: ,p_information25 in varchar2 default hr_api.g_varchar2
353: ,p_information26 in varchar2 default hr_api.g_varchar2
354: ,p_information27 in varchar2 default hr_api.g_varchar2
355: ,p_information28 in varchar2 default hr_api.g_varchar2
356: ,p_information29 in varchar2 default hr_api.g_varchar2
349: ,p_information22 in varchar2 default hr_api.g_varchar2
350: ,p_information23 in varchar2 default hr_api.g_varchar2
351: ,p_information24 in varchar2 default hr_api.g_varchar2
352: ,p_information25 in varchar2 default hr_api.g_varchar2
353: ,p_information26 in varchar2 default hr_api.g_varchar2
354: ,p_information27 in varchar2 default hr_api.g_varchar2
355: ,p_information28 in varchar2 default hr_api.g_varchar2
356: ,p_information29 in varchar2 default hr_api.g_varchar2
357: ,p_information30 in varchar2 default hr_api.g_varchar2
350: ,p_information23 in varchar2 default hr_api.g_varchar2
351: ,p_information24 in varchar2 default hr_api.g_varchar2
352: ,p_information25 in varchar2 default hr_api.g_varchar2
353: ,p_information26 in varchar2 default hr_api.g_varchar2
354: ,p_information27 in varchar2 default hr_api.g_varchar2
355: ,p_information28 in varchar2 default hr_api.g_varchar2
356: ,p_information29 in varchar2 default hr_api.g_varchar2
357: ,p_information30 in varchar2 default hr_api.g_varchar2
358: ,p_object_version_number in out nocopy number
351: ,p_information24 in varchar2 default hr_api.g_varchar2
352: ,p_information25 in varchar2 default hr_api.g_varchar2
353: ,p_information26 in varchar2 default hr_api.g_varchar2
354: ,p_information27 in varchar2 default hr_api.g_varchar2
355: ,p_information28 in varchar2 default hr_api.g_varchar2
356: ,p_information29 in varchar2 default hr_api.g_varchar2
357: ,p_information30 in varchar2 default hr_api.g_varchar2
358: ,p_object_version_number in out nocopy number
359: ) is
352: ,p_information25 in varchar2 default hr_api.g_varchar2
353: ,p_information26 in varchar2 default hr_api.g_varchar2
354: ,p_information27 in varchar2 default hr_api.g_varchar2
355: ,p_information28 in varchar2 default hr_api.g_varchar2
356: ,p_information29 in varchar2 default hr_api.g_varchar2
357: ,p_information30 in varchar2 default hr_api.g_varchar2
358: ,p_object_version_number in out nocopy number
359: ) is
360: begin
353: ,p_information26 in varchar2 default hr_api.g_varchar2
354: ,p_information27 in varchar2 default hr_api.g_varchar2
355: ,p_information28 in varchar2 default hr_api.g_varchar2
356: ,p_information29 in varchar2 default hr_api.g_varchar2
357: ,p_information30 in varchar2 default hr_api.g_varchar2
358: ,p_object_version_number in out nocopy number
359: ) is
360: begin
361: --
416: --
417: procedure update_progression_point
418: (p_validate in boolean default false
419: ,p_spinal_point_id in number
420: ,p_effective_date in date default hr_api.g_date
421: ,p_business_group_id in number default hr_api.g_number
422: ,p_parent_spine_id in number default hr_api.g_number
423: ,p_sequence in number default hr_api.g_number
424: ,p_spinal_point in varchar2 default hr_api.g_varchar2
417: procedure update_progression_point
418: (p_validate in boolean default false
419: ,p_spinal_point_id in number
420: ,p_effective_date in date default hr_api.g_date
421: ,p_business_group_id in number default hr_api.g_number
422: ,p_parent_spine_id in number default hr_api.g_number
423: ,p_sequence in number default hr_api.g_number
424: ,p_spinal_point in varchar2 default hr_api.g_varchar2
425: ,p_request_id in number default hr_api.g_number
418: (p_validate in boolean default false
419: ,p_spinal_point_id in number
420: ,p_effective_date in date default hr_api.g_date
421: ,p_business_group_id in number default hr_api.g_number
422: ,p_parent_spine_id in number default hr_api.g_number
423: ,p_sequence in number default hr_api.g_number
424: ,p_spinal_point in varchar2 default hr_api.g_varchar2
425: ,p_request_id in number default hr_api.g_number
426: ,p_program_application_id in number default hr_api.g_number
419: ,p_spinal_point_id in number
420: ,p_effective_date in date default hr_api.g_date
421: ,p_business_group_id in number default hr_api.g_number
422: ,p_parent_spine_id in number default hr_api.g_number
423: ,p_sequence in number default hr_api.g_number
424: ,p_spinal_point in varchar2 default hr_api.g_varchar2
425: ,p_request_id in number default hr_api.g_number
426: ,p_program_application_id in number default hr_api.g_number
427: ,p_program_id in number default hr_api.g_number
420: ,p_effective_date in date default hr_api.g_date
421: ,p_business_group_id in number default hr_api.g_number
422: ,p_parent_spine_id in number default hr_api.g_number
423: ,p_sequence in number default hr_api.g_number
424: ,p_spinal_point in varchar2 default hr_api.g_varchar2
425: ,p_request_id in number default hr_api.g_number
426: ,p_program_application_id in number default hr_api.g_number
427: ,p_program_id in number default hr_api.g_number
428: ,p_program_update_date in date default hr_api.g_date
421: ,p_business_group_id in number default hr_api.g_number
422: ,p_parent_spine_id in number default hr_api.g_number
423: ,p_sequence in number default hr_api.g_number
424: ,p_spinal_point in varchar2 default hr_api.g_varchar2
425: ,p_request_id in number default hr_api.g_number
426: ,p_program_application_id in number default hr_api.g_number
427: ,p_program_id in number default hr_api.g_number
428: ,p_program_update_date in date default hr_api.g_date
429: ,p_information_category in varchar2 default hr_api.g_varchar2
422: ,p_parent_spine_id in number default hr_api.g_number
423: ,p_sequence in number default hr_api.g_number
424: ,p_spinal_point in varchar2 default hr_api.g_varchar2
425: ,p_request_id in number default hr_api.g_number
426: ,p_program_application_id in number default hr_api.g_number
427: ,p_program_id in number default hr_api.g_number
428: ,p_program_update_date in date default hr_api.g_date
429: ,p_information_category in varchar2 default hr_api.g_varchar2
430: ,p_information1 in varchar2 default hr_api.g_varchar2
423: ,p_sequence in number default hr_api.g_number
424: ,p_spinal_point in varchar2 default hr_api.g_varchar2
425: ,p_request_id in number default hr_api.g_number
426: ,p_program_application_id in number default hr_api.g_number
427: ,p_program_id in number default hr_api.g_number
428: ,p_program_update_date in date default hr_api.g_date
429: ,p_information_category in varchar2 default hr_api.g_varchar2
430: ,p_information1 in varchar2 default hr_api.g_varchar2
431: ,p_information2 in varchar2 default hr_api.g_varchar2
424: ,p_spinal_point in varchar2 default hr_api.g_varchar2
425: ,p_request_id in number default hr_api.g_number
426: ,p_program_application_id in number default hr_api.g_number
427: ,p_program_id in number default hr_api.g_number
428: ,p_program_update_date in date default hr_api.g_date
429: ,p_information_category in varchar2 default hr_api.g_varchar2
430: ,p_information1 in varchar2 default hr_api.g_varchar2
431: ,p_information2 in varchar2 default hr_api.g_varchar2
432: ,p_information3 in varchar2 default hr_api.g_varchar2
425: ,p_request_id in number default hr_api.g_number
426: ,p_program_application_id in number default hr_api.g_number
427: ,p_program_id in number default hr_api.g_number
428: ,p_program_update_date in date default hr_api.g_date
429: ,p_information_category in varchar2 default hr_api.g_varchar2
430: ,p_information1 in varchar2 default hr_api.g_varchar2
431: ,p_information2 in varchar2 default hr_api.g_varchar2
432: ,p_information3 in varchar2 default hr_api.g_varchar2
433: ,p_information4 in varchar2 default hr_api.g_varchar2
426: ,p_program_application_id in number default hr_api.g_number
427: ,p_program_id in number default hr_api.g_number
428: ,p_program_update_date in date default hr_api.g_date
429: ,p_information_category in varchar2 default hr_api.g_varchar2
430: ,p_information1 in varchar2 default hr_api.g_varchar2
431: ,p_information2 in varchar2 default hr_api.g_varchar2
432: ,p_information3 in varchar2 default hr_api.g_varchar2
433: ,p_information4 in varchar2 default hr_api.g_varchar2
434: ,p_information5 in varchar2 default hr_api.g_varchar2
427: ,p_program_id in number default hr_api.g_number
428: ,p_program_update_date in date default hr_api.g_date
429: ,p_information_category in varchar2 default hr_api.g_varchar2
430: ,p_information1 in varchar2 default hr_api.g_varchar2
431: ,p_information2 in varchar2 default hr_api.g_varchar2
432: ,p_information3 in varchar2 default hr_api.g_varchar2
433: ,p_information4 in varchar2 default hr_api.g_varchar2
434: ,p_information5 in varchar2 default hr_api.g_varchar2
435: ,p_information6 in varchar2 default hr_api.g_varchar2
428: ,p_program_update_date in date default hr_api.g_date
429: ,p_information_category in varchar2 default hr_api.g_varchar2
430: ,p_information1 in varchar2 default hr_api.g_varchar2
431: ,p_information2 in varchar2 default hr_api.g_varchar2
432: ,p_information3 in varchar2 default hr_api.g_varchar2
433: ,p_information4 in varchar2 default hr_api.g_varchar2
434: ,p_information5 in varchar2 default hr_api.g_varchar2
435: ,p_information6 in varchar2 default hr_api.g_varchar2
436: ,p_information7 in varchar2 default hr_api.g_varchar2
429: ,p_information_category in varchar2 default hr_api.g_varchar2
430: ,p_information1 in varchar2 default hr_api.g_varchar2
431: ,p_information2 in varchar2 default hr_api.g_varchar2
432: ,p_information3 in varchar2 default hr_api.g_varchar2
433: ,p_information4 in varchar2 default hr_api.g_varchar2
434: ,p_information5 in varchar2 default hr_api.g_varchar2
435: ,p_information6 in varchar2 default hr_api.g_varchar2
436: ,p_information7 in varchar2 default hr_api.g_varchar2
437: ,p_information8 in varchar2 default hr_api.g_varchar2
430: ,p_information1 in varchar2 default hr_api.g_varchar2
431: ,p_information2 in varchar2 default hr_api.g_varchar2
432: ,p_information3 in varchar2 default hr_api.g_varchar2
433: ,p_information4 in varchar2 default hr_api.g_varchar2
434: ,p_information5 in varchar2 default hr_api.g_varchar2
435: ,p_information6 in varchar2 default hr_api.g_varchar2
436: ,p_information7 in varchar2 default hr_api.g_varchar2
437: ,p_information8 in varchar2 default hr_api.g_varchar2
438: ,p_information9 in varchar2 default hr_api.g_varchar2
431: ,p_information2 in varchar2 default hr_api.g_varchar2
432: ,p_information3 in varchar2 default hr_api.g_varchar2
433: ,p_information4 in varchar2 default hr_api.g_varchar2
434: ,p_information5 in varchar2 default hr_api.g_varchar2
435: ,p_information6 in varchar2 default hr_api.g_varchar2
436: ,p_information7 in varchar2 default hr_api.g_varchar2
437: ,p_information8 in varchar2 default hr_api.g_varchar2
438: ,p_information9 in varchar2 default hr_api.g_varchar2
439: ,p_information10 in varchar2 default hr_api.g_varchar2
432: ,p_information3 in varchar2 default hr_api.g_varchar2
433: ,p_information4 in varchar2 default hr_api.g_varchar2
434: ,p_information5 in varchar2 default hr_api.g_varchar2
435: ,p_information6 in varchar2 default hr_api.g_varchar2
436: ,p_information7 in varchar2 default hr_api.g_varchar2
437: ,p_information8 in varchar2 default hr_api.g_varchar2
438: ,p_information9 in varchar2 default hr_api.g_varchar2
439: ,p_information10 in varchar2 default hr_api.g_varchar2
440: ,p_information11 in varchar2 default hr_api.g_varchar2
433: ,p_information4 in varchar2 default hr_api.g_varchar2
434: ,p_information5 in varchar2 default hr_api.g_varchar2
435: ,p_information6 in varchar2 default hr_api.g_varchar2
436: ,p_information7 in varchar2 default hr_api.g_varchar2
437: ,p_information8 in varchar2 default hr_api.g_varchar2
438: ,p_information9 in varchar2 default hr_api.g_varchar2
439: ,p_information10 in varchar2 default hr_api.g_varchar2
440: ,p_information11 in varchar2 default hr_api.g_varchar2
441: ,p_information12 in varchar2 default hr_api.g_varchar2
434: ,p_information5 in varchar2 default hr_api.g_varchar2
435: ,p_information6 in varchar2 default hr_api.g_varchar2
436: ,p_information7 in varchar2 default hr_api.g_varchar2
437: ,p_information8 in varchar2 default hr_api.g_varchar2
438: ,p_information9 in varchar2 default hr_api.g_varchar2
439: ,p_information10 in varchar2 default hr_api.g_varchar2
440: ,p_information11 in varchar2 default hr_api.g_varchar2
441: ,p_information12 in varchar2 default hr_api.g_varchar2
442: ,p_information13 in varchar2 default hr_api.g_varchar2
435: ,p_information6 in varchar2 default hr_api.g_varchar2
436: ,p_information7 in varchar2 default hr_api.g_varchar2
437: ,p_information8 in varchar2 default hr_api.g_varchar2
438: ,p_information9 in varchar2 default hr_api.g_varchar2
439: ,p_information10 in varchar2 default hr_api.g_varchar2
440: ,p_information11 in varchar2 default hr_api.g_varchar2
441: ,p_information12 in varchar2 default hr_api.g_varchar2
442: ,p_information13 in varchar2 default hr_api.g_varchar2
443: ,p_information14 in varchar2 default hr_api.g_varchar2
436: ,p_information7 in varchar2 default hr_api.g_varchar2
437: ,p_information8 in varchar2 default hr_api.g_varchar2
438: ,p_information9 in varchar2 default hr_api.g_varchar2
439: ,p_information10 in varchar2 default hr_api.g_varchar2
440: ,p_information11 in varchar2 default hr_api.g_varchar2
441: ,p_information12 in varchar2 default hr_api.g_varchar2
442: ,p_information13 in varchar2 default hr_api.g_varchar2
443: ,p_information14 in varchar2 default hr_api.g_varchar2
444: ,p_information15 in varchar2 default hr_api.g_varchar2
437: ,p_information8 in varchar2 default hr_api.g_varchar2
438: ,p_information9 in varchar2 default hr_api.g_varchar2
439: ,p_information10 in varchar2 default hr_api.g_varchar2
440: ,p_information11 in varchar2 default hr_api.g_varchar2
441: ,p_information12 in varchar2 default hr_api.g_varchar2
442: ,p_information13 in varchar2 default hr_api.g_varchar2
443: ,p_information14 in varchar2 default hr_api.g_varchar2
444: ,p_information15 in varchar2 default hr_api.g_varchar2
445: ,p_information16 in varchar2 default hr_api.g_varchar2
438: ,p_information9 in varchar2 default hr_api.g_varchar2
439: ,p_information10 in varchar2 default hr_api.g_varchar2
440: ,p_information11 in varchar2 default hr_api.g_varchar2
441: ,p_information12 in varchar2 default hr_api.g_varchar2
442: ,p_information13 in varchar2 default hr_api.g_varchar2
443: ,p_information14 in varchar2 default hr_api.g_varchar2
444: ,p_information15 in varchar2 default hr_api.g_varchar2
445: ,p_information16 in varchar2 default hr_api.g_varchar2
446: ,p_information17 in varchar2 default hr_api.g_varchar2
439: ,p_information10 in varchar2 default hr_api.g_varchar2
440: ,p_information11 in varchar2 default hr_api.g_varchar2
441: ,p_information12 in varchar2 default hr_api.g_varchar2
442: ,p_information13 in varchar2 default hr_api.g_varchar2
443: ,p_information14 in varchar2 default hr_api.g_varchar2
444: ,p_information15 in varchar2 default hr_api.g_varchar2
445: ,p_information16 in varchar2 default hr_api.g_varchar2
446: ,p_information17 in varchar2 default hr_api.g_varchar2
447: ,p_information18 in varchar2 default hr_api.g_varchar2
440: ,p_information11 in varchar2 default hr_api.g_varchar2
441: ,p_information12 in varchar2 default hr_api.g_varchar2
442: ,p_information13 in varchar2 default hr_api.g_varchar2
443: ,p_information14 in varchar2 default hr_api.g_varchar2
444: ,p_information15 in varchar2 default hr_api.g_varchar2
445: ,p_information16 in varchar2 default hr_api.g_varchar2
446: ,p_information17 in varchar2 default hr_api.g_varchar2
447: ,p_information18 in varchar2 default hr_api.g_varchar2
448: ,p_information19 in varchar2 default hr_api.g_varchar2
441: ,p_information12 in varchar2 default hr_api.g_varchar2
442: ,p_information13 in varchar2 default hr_api.g_varchar2
443: ,p_information14 in varchar2 default hr_api.g_varchar2
444: ,p_information15 in varchar2 default hr_api.g_varchar2
445: ,p_information16 in varchar2 default hr_api.g_varchar2
446: ,p_information17 in varchar2 default hr_api.g_varchar2
447: ,p_information18 in varchar2 default hr_api.g_varchar2
448: ,p_information19 in varchar2 default hr_api.g_varchar2
449: ,p_information20 in varchar2 default hr_api.g_varchar2
442: ,p_information13 in varchar2 default hr_api.g_varchar2
443: ,p_information14 in varchar2 default hr_api.g_varchar2
444: ,p_information15 in varchar2 default hr_api.g_varchar2
445: ,p_information16 in varchar2 default hr_api.g_varchar2
446: ,p_information17 in varchar2 default hr_api.g_varchar2
447: ,p_information18 in varchar2 default hr_api.g_varchar2
448: ,p_information19 in varchar2 default hr_api.g_varchar2
449: ,p_information20 in varchar2 default hr_api.g_varchar2
450: ,p_information21 in varchar2 default hr_api.g_varchar2
443: ,p_information14 in varchar2 default hr_api.g_varchar2
444: ,p_information15 in varchar2 default hr_api.g_varchar2
445: ,p_information16 in varchar2 default hr_api.g_varchar2
446: ,p_information17 in varchar2 default hr_api.g_varchar2
447: ,p_information18 in varchar2 default hr_api.g_varchar2
448: ,p_information19 in varchar2 default hr_api.g_varchar2
449: ,p_information20 in varchar2 default hr_api.g_varchar2
450: ,p_information21 in varchar2 default hr_api.g_varchar2
451: ,p_information22 in varchar2 default hr_api.g_varchar2
444: ,p_information15 in varchar2 default hr_api.g_varchar2
445: ,p_information16 in varchar2 default hr_api.g_varchar2
446: ,p_information17 in varchar2 default hr_api.g_varchar2
447: ,p_information18 in varchar2 default hr_api.g_varchar2
448: ,p_information19 in varchar2 default hr_api.g_varchar2
449: ,p_information20 in varchar2 default hr_api.g_varchar2
450: ,p_information21 in varchar2 default hr_api.g_varchar2
451: ,p_information22 in varchar2 default hr_api.g_varchar2
452: ,p_information23 in varchar2 default hr_api.g_varchar2
445: ,p_information16 in varchar2 default hr_api.g_varchar2
446: ,p_information17 in varchar2 default hr_api.g_varchar2
447: ,p_information18 in varchar2 default hr_api.g_varchar2
448: ,p_information19 in varchar2 default hr_api.g_varchar2
449: ,p_information20 in varchar2 default hr_api.g_varchar2
450: ,p_information21 in varchar2 default hr_api.g_varchar2
451: ,p_information22 in varchar2 default hr_api.g_varchar2
452: ,p_information23 in varchar2 default hr_api.g_varchar2
453: ,p_information24 in varchar2 default hr_api.g_varchar2
446: ,p_information17 in varchar2 default hr_api.g_varchar2
447: ,p_information18 in varchar2 default hr_api.g_varchar2
448: ,p_information19 in varchar2 default hr_api.g_varchar2
449: ,p_information20 in varchar2 default hr_api.g_varchar2
450: ,p_information21 in varchar2 default hr_api.g_varchar2
451: ,p_information22 in varchar2 default hr_api.g_varchar2
452: ,p_information23 in varchar2 default hr_api.g_varchar2
453: ,p_information24 in varchar2 default hr_api.g_varchar2
454: ,p_information25 in varchar2 default hr_api.g_varchar2
447: ,p_information18 in varchar2 default hr_api.g_varchar2
448: ,p_information19 in varchar2 default hr_api.g_varchar2
449: ,p_information20 in varchar2 default hr_api.g_varchar2
450: ,p_information21 in varchar2 default hr_api.g_varchar2
451: ,p_information22 in varchar2 default hr_api.g_varchar2
452: ,p_information23 in varchar2 default hr_api.g_varchar2
453: ,p_information24 in varchar2 default hr_api.g_varchar2
454: ,p_information25 in varchar2 default hr_api.g_varchar2
455: ,p_information26 in varchar2 default hr_api.g_varchar2
448: ,p_information19 in varchar2 default hr_api.g_varchar2
449: ,p_information20 in varchar2 default hr_api.g_varchar2
450: ,p_information21 in varchar2 default hr_api.g_varchar2
451: ,p_information22 in varchar2 default hr_api.g_varchar2
452: ,p_information23 in varchar2 default hr_api.g_varchar2
453: ,p_information24 in varchar2 default hr_api.g_varchar2
454: ,p_information25 in varchar2 default hr_api.g_varchar2
455: ,p_information26 in varchar2 default hr_api.g_varchar2
456: ,p_information27 in varchar2 default hr_api.g_varchar2
449: ,p_information20 in varchar2 default hr_api.g_varchar2
450: ,p_information21 in varchar2 default hr_api.g_varchar2
451: ,p_information22 in varchar2 default hr_api.g_varchar2
452: ,p_information23 in varchar2 default hr_api.g_varchar2
453: ,p_information24 in varchar2 default hr_api.g_varchar2
454: ,p_information25 in varchar2 default hr_api.g_varchar2
455: ,p_information26 in varchar2 default hr_api.g_varchar2
456: ,p_information27 in varchar2 default hr_api.g_varchar2
457: ,p_information28 in varchar2 default hr_api.g_varchar2
450: ,p_information21 in varchar2 default hr_api.g_varchar2
451: ,p_information22 in varchar2 default hr_api.g_varchar2
452: ,p_information23 in varchar2 default hr_api.g_varchar2
453: ,p_information24 in varchar2 default hr_api.g_varchar2
454: ,p_information25 in varchar2 default hr_api.g_varchar2
455: ,p_information26 in varchar2 default hr_api.g_varchar2
456: ,p_information27 in varchar2 default hr_api.g_varchar2
457: ,p_information28 in varchar2 default hr_api.g_varchar2
458: ,p_information29 in varchar2 default hr_api.g_varchar2
451: ,p_information22 in varchar2 default hr_api.g_varchar2
452: ,p_information23 in varchar2 default hr_api.g_varchar2
453: ,p_information24 in varchar2 default hr_api.g_varchar2
454: ,p_information25 in varchar2 default hr_api.g_varchar2
455: ,p_information26 in varchar2 default hr_api.g_varchar2
456: ,p_information27 in varchar2 default hr_api.g_varchar2
457: ,p_information28 in varchar2 default hr_api.g_varchar2
458: ,p_information29 in varchar2 default hr_api.g_varchar2
459: ,p_information30 in varchar2 default hr_api.g_varchar2
452: ,p_information23 in varchar2 default hr_api.g_varchar2
453: ,p_information24 in varchar2 default hr_api.g_varchar2
454: ,p_information25 in varchar2 default hr_api.g_varchar2
455: ,p_information26 in varchar2 default hr_api.g_varchar2
456: ,p_information27 in varchar2 default hr_api.g_varchar2
457: ,p_information28 in varchar2 default hr_api.g_varchar2
458: ,p_information29 in varchar2 default hr_api.g_varchar2
459: ,p_information30 in varchar2 default hr_api.g_varchar2
460: ,p_object_version_number in out nocopy number
453: ,p_information24 in varchar2 default hr_api.g_varchar2
454: ,p_information25 in varchar2 default hr_api.g_varchar2
455: ,p_information26 in varchar2 default hr_api.g_varchar2
456: ,p_information27 in varchar2 default hr_api.g_varchar2
457: ,p_information28 in varchar2 default hr_api.g_varchar2
458: ,p_information29 in varchar2 default hr_api.g_varchar2
459: ,p_information30 in varchar2 default hr_api.g_varchar2
460: ,p_object_version_number in out nocopy number
461: ,p_called_from in varchar2 --added for bug 9328526
454: ,p_information25 in varchar2 default hr_api.g_varchar2
455: ,p_information26 in varchar2 default hr_api.g_varchar2
456: ,p_information27 in varchar2 default hr_api.g_varchar2
457: ,p_information28 in varchar2 default hr_api.g_varchar2
458: ,p_information29 in varchar2 default hr_api.g_varchar2
459: ,p_information30 in varchar2 default hr_api.g_varchar2
460: ,p_object_version_number in out nocopy number
461: ,p_called_from in varchar2 --added for bug 9328526
462: ) is
455: ,p_information26 in varchar2 default hr_api.g_varchar2
456: ,p_information27 in varchar2 default hr_api.g_varchar2
457: ,p_information28 in varchar2 default hr_api.g_varchar2
458: ,p_information29 in varchar2 default hr_api.g_varchar2
459: ,p_information30 in varchar2 default hr_api.g_varchar2
460: ,p_object_version_number in out nocopy number
461: ,p_called_from in varchar2 --added for bug 9328526
462: ) is
463:
540: ,p_information29 => p_information29
541: ,p_information30 => p_information30
542: );
543: exception
544: when hr_api.cannot_find_prog_unit then
545: hr_api.cannot_find_prog_unit_error
546: (p_module_name => 'UPDATE_PROGRESSION_POINT'
547: ,p_hook_type => 'BP'
548: );
541: ,p_information30 => p_information30
542: );
543: exception
544: when hr_api.cannot_find_prog_unit then
545: hr_api.cannot_find_prog_unit_error
546: (p_module_name => 'UPDATE_PROGRESSION_POINT'
547: ,p_hook_type => 'BP'
548: );
549: --
673: ,p_information29 => p_information29
674: ,p_information30 => p_information30
675: );
676: exception
677: when hr_api.cannot_find_prog_unit then
678: hr_api.cannot_find_prog_unit_error
679: (p_module_name => 'UPDATE_PROGRESSION_POINT'
680: ,p_hook_type => 'AP'
681: );
674: ,p_information30 => p_information30
675: );
676: exception
677: when hr_api.cannot_find_prog_unit then
678: hr_api.cannot_find_prog_unit_error
679: (p_module_name => 'UPDATE_PROGRESSION_POINT'
680: ,p_hook_type => 'AP'
681: );
682: --
687: -- When in validation only mode raise the Validate_Enabled exception
688: --
689: if p_validate
690: then
691: raise hr_api.validate_enabled;
692: end if;
693: --
694: hr_utility.set_location(l_proc, 50);
695: --
700: hr_utility.set_location(' Leaving:' ||l_proc, 60);
701: --
702: exception
703: --
704: when hr_api.validate_enabled then
705: --
706: -- As the Validate_Enabled exception has been raised
707: -- we must rollback to the savepoint
708: --
802: ,p_spinal_point_id => p_spinal_point_id
803: ,p_object_version_number => p_object_version_number
804: );
805: exception
806: when hr_api.cannot_find_prog_unit then
807: hr_api.cannot_find_prog_unit_error
808: (p_module_name => 'DELETE_PROGRESSSION_POINT'
809: ,p_hook_type => 'BP'
810: );
803: ,p_object_version_number => p_object_version_number
804: );
805: exception
806: when hr_api.cannot_find_prog_unit then
807: hr_api.cannot_find_prog_unit_error
808: (p_module_name => 'DELETE_PROGRESSSION_POINT'
809: ,p_hook_type => 'BP'
810: );
811: end;
853: (p_validate => p_validate
854: ,p_spinal_point_id => p_spinal_point_id
855: ,p_object_version_number => p_object_version_number);
856: exception
857: when hr_api.cannot_find_prog_unit then
858: hr_api.cannot_find_prog_unit_error
859: (p_module_name => 'DELETE_PROGRESSSION_POINT'
860: ,p_hook_type => 'AP'
861: );
854: ,p_spinal_point_id => p_spinal_point_id
855: ,p_object_version_number => p_object_version_number);
856: exception
857: when hr_api.cannot_find_prog_unit then
858: hr_api.cannot_find_prog_unit_error
859: (p_module_name => 'DELETE_PROGRESSSION_POINT'
860: ,p_hook_type => 'AP'
861: );
862: end;
866: --
867: -- When in validation only mode raise the Validate_Enabled exception
868: --
869: if p_validate then
870: raise hr_api.validate_enabled;
871: end if;
872:
873: hr_utility.set_location(' Leaving:'||l_proc, 100);
874: exception
871: end if;
872:
873: hr_utility.set_location(' Leaving:'||l_proc, 100);
874: exception
875: when hr_api.validate_enabled then
876: hr_utility.set_location(' Leaving...:'||l_proc, 50);
877: --
878: -- As the Validate_Enabled exception has been raised
879: -- we must rollback to the savepoint