155: ,p_shp_information19 => p_shp_information19
156: ,p_shp_information20 => p_shp_information20
157: );
158: exception
159: when hr_api.cannot_find_prog_unit then
160: hr_api.cannot_find_prog_unit_error
161: (p_module_name => 'create_service_history_period'
162: ,p_hook_type => 'BP'
163: );
156: ,p_shp_information20 => p_shp_information20
157: );
158: exception
159: when hr_api.cannot_find_prog_unit then
160: hr_api.cannot_find_prog_unit_error
161: (p_module_name => 'create_service_history_period'
162: ,p_hook_type => 'BP'
163: );
164: end;
299: ,p_shp_information19 => p_shp_information19
300: ,p_shp_information20 => p_shp_information20
301: );
302: exception
303: when hr_api.cannot_find_prog_unit then
304: hr_api.cannot_find_prog_unit_error
305: (p_module_name => 'create_service_history_period'
306: ,p_hook_type => 'AP'
307: );
300: ,p_shp_information20 => p_shp_information20
301: );
302: exception
303: when hr_api.cannot_find_prog_unit then
304: hr_api.cannot_find_prog_unit_error
305: (p_module_name => 'create_service_history_period'
306: ,p_hook_type => 'AP'
307: );
308: end;
310: --
311: -- When in validation only mode raise the Validate_Enabled exception
312: --
313: if p_validate then
314: raise hr_api.validate_enabled;
315: end if;
316: --
317: -- Set all output arguments
318: --
320: p_object_version_number := l_object_version_number;
321: --
322: hr_utility.set_location(' Leaving:'||l_proc, 70);
323: exception
324: when hr_api.validate_enabled then
325: --
326: -- As the Validate_Enabled exception has been raised
327: -- we must rollback to the savepoint
328: --
352: --
353: procedure update_service_history_period
354: (p_validate in boolean default false
355: ,p_service_history_period_id in number
356: ,p_assignment_id in number default hr_api.g_number
357: ,p_start_date in date default hr_api.g_date
358: ,p_end_date in date default hr_api.g_date
359: ,p_employer_name in varchar2 default hr_api.g_varchar2
360: ,p_employer_address in varchar2 default hr_api.g_varchar2
353: procedure update_service_history_period
354: (p_validate in boolean default false
355: ,p_service_history_period_id in number
356: ,p_assignment_id in number default hr_api.g_number
357: ,p_start_date in date default hr_api.g_date
358: ,p_end_date in date default hr_api.g_date
359: ,p_employer_name in varchar2 default hr_api.g_varchar2
360: ,p_employer_address in varchar2 default hr_api.g_varchar2
361: ,p_employer_type in varchar2 default hr_api.g_varchar2
354: (p_validate in boolean default false
355: ,p_service_history_period_id in number
356: ,p_assignment_id in number default hr_api.g_number
357: ,p_start_date in date default hr_api.g_date
358: ,p_end_date in date default hr_api.g_date
359: ,p_employer_name in varchar2 default hr_api.g_varchar2
360: ,p_employer_address in varchar2 default hr_api.g_varchar2
361: ,p_employer_type in varchar2 default hr_api.g_varchar2
362: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
355: ,p_service_history_period_id in number
356: ,p_assignment_id in number default hr_api.g_number
357: ,p_start_date in date default hr_api.g_date
358: ,p_end_date in date default hr_api.g_date
359: ,p_employer_name in varchar2 default hr_api.g_varchar2
360: ,p_employer_address in varchar2 default hr_api.g_varchar2
361: ,p_employer_type in varchar2 default hr_api.g_varchar2
362: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
363: ,p_description in varchar2 default hr_api.g_varchar2
356: ,p_assignment_id in number default hr_api.g_number
357: ,p_start_date in date default hr_api.g_date
358: ,p_end_date in date default hr_api.g_date
359: ,p_employer_name in varchar2 default hr_api.g_varchar2
360: ,p_employer_address in varchar2 default hr_api.g_varchar2
361: ,p_employer_type in varchar2 default hr_api.g_varchar2
362: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
363: ,p_description in varchar2 default hr_api.g_varchar2
364: ,p_continuous_service in varchar2 default hr_api.g_varchar2
357: ,p_start_date in date default hr_api.g_date
358: ,p_end_date in date default hr_api.g_date
359: ,p_employer_name in varchar2 default hr_api.g_varchar2
360: ,p_employer_address in varchar2 default hr_api.g_varchar2
361: ,p_employer_type in varchar2 default hr_api.g_varchar2
362: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
363: ,p_description in varchar2 default hr_api.g_varchar2
364: ,p_continuous_service in varchar2 default hr_api.g_varchar2
365: ,p_all_assignments in varchar2 default hr_api.g_varchar2
358: ,p_end_date in date default hr_api.g_date
359: ,p_employer_name in varchar2 default hr_api.g_varchar2
360: ,p_employer_address in varchar2 default hr_api.g_varchar2
361: ,p_employer_type in varchar2 default hr_api.g_varchar2
362: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
363: ,p_description in varchar2 default hr_api.g_varchar2
364: ,p_continuous_service in varchar2 default hr_api.g_varchar2
365: ,p_all_assignments in varchar2 default hr_api.g_varchar2
366: ,p_period_years in number default hr_api.g_number
359: ,p_employer_name in varchar2 default hr_api.g_varchar2
360: ,p_employer_address in varchar2 default hr_api.g_varchar2
361: ,p_employer_type in varchar2 default hr_api.g_varchar2
362: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
363: ,p_description in varchar2 default hr_api.g_varchar2
364: ,p_continuous_service in varchar2 default hr_api.g_varchar2
365: ,p_all_assignments in varchar2 default hr_api.g_varchar2
366: ,p_period_years in number default hr_api.g_number
367: ,p_period_days in number default hr_api.g_number
360: ,p_employer_address in varchar2 default hr_api.g_varchar2
361: ,p_employer_type in varchar2 default hr_api.g_varchar2
362: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
363: ,p_description in varchar2 default hr_api.g_varchar2
364: ,p_continuous_service in varchar2 default hr_api.g_varchar2
365: ,p_all_assignments in varchar2 default hr_api.g_varchar2
366: ,p_period_years in number default hr_api.g_number
367: ,p_period_days in number default hr_api.g_number
368: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
361: ,p_employer_type in varchar2 default hr_api.g_varchar2
362: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
363: ,p_description in varchar2 default hr_api.g_varchar2
364: ,p_continuous_service in varchar2 default hr_api.g_varchar2
365: ,p_all_assignments in varchar2 default hr_api.g_varchar2
366: ,p_period_years in number default hr_api.g_number
367: ,p_period_days in number default hr_api.g_number
368: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
362: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
363: ,p_description in varchar2 default hr_api.g_varchar2
364: ,p_continuous_service in varchar2 default hr_api.g_varchar2
365: ,p_all_assignments in varchar2 default hr_api.g_varchar2
366: ,p_period_years in number default hr_api.g_number
367: ,p_period_days in number default hr_api.g_number
368: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
363: ,p_description in varchar2 default hr_api.g_varchar2
364: ,p_continuous_service in varchar2 default hr_api.g_varchar2
365: ,p_all_assignments in varchar2 default hr_api.g_varchar2
366: ,p_period_years in number default hr_api.g_number
367: ,p_period_days in number default hr_api.g_number
368: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
364: ,p_continuous_service in varchar2 default hr_api.g_varchar2
365: ,p_all_assignments in varchar2 default hr_api.g_varchar2
366: ,p_period_years in number default hr_api.g_number
367: ,p_period_days in number default hr_api.g_number
368: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
365: ,p_all_assignments in varchar2 default hr_api.g_varchar2
366: ,p_period_years in number default hr_api.g_number
367: ,p_period_days in number default hr_api.g_number
368: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
366: ,p_period_years in number default hr_api.g_number
367: ,p_period_days in number default hr_api.g_number
368: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
367: ,p_period_days in number default hr_api.g_number
368: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
368: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
369: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
370: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
371: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
372: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
373: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
374: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
375: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
376: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
377: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
378: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
379: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
380: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
381: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
382: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
390: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
383: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
390: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
391: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
384: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
390: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
391: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
392: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
385: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
390: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
391: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
392: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
393: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
386: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
390: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
391: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
392: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
393: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
394: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
387: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
390: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
391: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
392: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
393: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
394: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
395: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
388: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
390: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
391: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
392: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
393: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
394: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
395: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
396: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
389: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
390: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
391: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
392: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
393: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
394: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
395: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
396: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
397: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
390: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
391: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
392: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
393: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
394: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
395: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
396: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
397: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
398: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
391: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
392: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
393: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
394: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
395: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
396: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
397: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
398: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
399: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
392: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
393: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
394: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
395: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
396: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
397: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
398: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
399: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
400: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
393: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
394: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
395: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
396: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
397: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
398: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
399: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
400: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
401: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
394: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
395: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
396: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
397: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
398: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
399: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
400: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
401: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
402: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
395: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
396: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
397: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
398: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
399: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
400: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
401: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
402: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
403: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
396: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
397: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
398: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
399: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
400: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
401: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
402: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
403: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
404: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
397: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
398: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
399: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
400: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
401: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
402: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
403: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
404: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
405: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
398: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
399: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
400: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
401: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
402: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
403: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
404: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
405: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
406: ,p_shp_information17 in varchar2 default hr_api.g_varchar2
399: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
400: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
401: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
402: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
403: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
404: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
405: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
406: ,p_shp_information17 in varchar2 default hr_api.g_varchar2
407: ,p_shp_information18 in varchar2 default hr_api.g_varchar2
400: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
401: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
402: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
403: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
404: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
405: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
406: ,p_shp_information17 in varchar2 default hr_api.g_varchar2
407: ,p_shp_information18 in varchar2 default hr_api.g_varchar2
408: ,p_shp_information19 in varchar2 default hr_api.g_varchar2
401: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
402: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
403: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
404: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
405: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
406: ,p_shp_information17 in varchar2 default hr_api.g_varchar2
407: ,p_shp_information18 in varchar2 default hr_api.g_varchar2
408: ,p_shp_information19 in varchar2 default hr_api.g_varchar2
409: ,p_shp_information20 in varchar2 default hr_api.g_varchar2
402: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
403: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
404: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
405: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
406: ,p_shp_information17 in varchar2 default hr_api.g_varchar2
407: ,p_shp_information18 in varchar2 default hr_api.g_varchar2
408: ,p_shp_information19 in varchar2 default hr_api.g_varchar2
409: ,p_shp_information20 in varchar2 default hr_api.g_varchar2
410: ,p_object_version_number in out nocopy number
403: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
404: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
405: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
406: ,p_shp_information17 in varchar2 default hr_api.g_varchar2
407: ,p_shp_information18 in varchar2 default hr_api.g_varchar2
408: ,p_shp_information19 in varchar2 default hr_api.g_varchar2
409: ,p_shp_information20 in varchar2 default hr_api.g_varchar2
410: ,p_object_version_number in out nocopy number
411: ) is
404: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
405: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
406: ,p_shp_information17 in varchar2 default hr_api.g_varchar2
407: ,p_shp_information18 in varchar2 default hr_api.g_varchar2
408: ,p_shp_information19 in varchar2 default hr_api.g_varchar2
409: ,p_shp_information20 in varchar2 default hr_api.g_varchar2
410: ,p_object_version_number in out nocopy number
411: ) is
412:
405: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
406: ,p_shp_information17 in varchar2 default hr_api.g_varchar2
407: ,p_shp_information18 in varchar2 default hr_api.g_varchar2
408: ,p_shp_information19 in varchar2 default hr_api.g_varchar2
409: ,p_shp_information20 in varchar2 default hr_api.g_varchar2
410: ,p_object_version_number in out nocopy number
411: ) is
412:
413: --
493: ,p_shp_information19 => p_shp_information19
494: ,p_shp_information20 => p_shp_information20
495: );
496: exception
497: when hr_api.cannot_find_prog_unit then
498: hr_api.cannot_find_prog_unit_error
499: (p_module_name => 'update_service_history_period'
500: ,p_hook_type => 'BP'
501: );
494: ,p_shp_information20 => p_shp_information20
495: );
496: exception
497: when hr_api.cannot_find_prog_unit then
498: hr_api.cannot_find_prog_unit_error
499: (p_module_name => 'update_service_history_period'
500: ,p_hook_type => 'BP'
501: );
502: end;
636: ,p_shp_information19 => p_shp_information19
637: ,p_shp_information20 => p_shp_information20
638: );
639: exception
640: when hr_api.cannot_find_prog_unit then
641: hr_api.cannot_find_prog_unit_error
642: (p_module_name => 'update_service_history_period'
643: ,p_hook_type => 'AP'
644: );
637: ,p_shp_information20 => p_shp_information20
638: );
639: exception
640: when hr_api.cannot_find_prog_unit then
641: hr_api.cannot_find_prog_unit_error
642: (p_module_name => 'update_service_history_period'
643: ,p_hook_type => 'AP'
644: );
645: end;
647: --
648: -- When in validation only mode raise the Validate_Enabled exception
649: --
650: if p_validate then
651: raise hr_api.validate_enabled;
652: end if;
653: --
654: -- Set all output arguments
655: --
656: p_object_version_number := l_object_version_number;
657: --
658: hr_utility.set_location(' Leaving:'||l_proc, 70);
659: exception
660: when hr_api.validate_enabled then
661: --
662: -- As the Validate_Enabled exception has been raised
663: -- we must rollback to the savepoint
664: --
712: (p_service_history_period_id => p_service_history_period_id
713: ,p_object_version_number => p_object_version_number
714: );
715: exception
716: when hr_api.cannot_find_prog_unit then
717: hr_api.cannot_find_prog_unit_error
718: (p_module_name => 'delete_service_history_period'
719: ,p_hook_type => 'BP'
720: );
713: ,p_object_version_number => p_object_version_number
714: );
715: exception
716: when hr_api.cannot_find_prog_unit then
717: hr_api.cannot_find_prog_unit_error
718: (p_module_name => 'delete_service_history_period'
719: ,p_hook_type => 'BP'
720: );
721: end;
746: (p_service_history_period_id => p_service_history_period_id
747: ,p_object_version_number => p_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_service_history_period'
753: ,p_hook_type => 'AP'
754: );
747: ,p_object_version_number => p_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_service_history_period'
753: ,p_hook_type => 'AP'
754: );
755: end;
757: --
758: -- When in validation only mode raise the Validate_Enabled exception
759: --
760: if p_validate then
761: raise hr_api.validate_enabled;
762: end if;
763: --
764: -- Set all output arguments
765: --
765: --
766: --
767: hr_utility.set_location(' Leaving:'||l_proc, 70);
768: exception
769: when hr_api.validate_enabled then
770: --
771: -- As the Validate_Enabled exception has been raised
772: -- we must rollback to the savepoint
773: --