184: ,p_attribute29 => p_attribute29
185: ,p_attribute30 => p_attribute30
186: );
187: exception
188: when hr_api.cannot_find_prog_unit then
189: hr_api.cannot_find_prog_unit_error
190: (p_module_name => 'CREATE_SITUATION'
191: ,p_hook_type => 'BP'
192: );
185: ,p_attribute30 => p_attribute30
186: );
187: exception
188: when hr_api.cannot_find_prog_unit then
189: hr_api.cannot_find_prog_unit_error
190: (p_module_name => 'CREATE_SITUATION'
191: ,p_hook_type => 'BP'
192: );
193: end;
360: ,p_situation_id => l_situation_id
361: ,p_object_version_number => l_object_version_number
362: );
363: exception
364: when hr_api.cannot_find_prog_unit then
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'CREATE_SITUATION'
367: ,p_hook_type => 'AP'
368: );
361: ,p_object_version_number => l_object_version_number
362: );
363: exception
364: when hr_api.cannot_find_prog_unit then
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'CREATE_SITUATION'
367: ,p_hook_type => 'AP'
368: );
369: end;
370: --
371: -- When in validation only mode raise the Validate_Enabled exception
372: --
373: if p_validate then
374: raise hr_api.validate_enabled;
375: end if;
376: --
377: -- Set all output arguments
378: --
380: p_object_version_number := l_object_version_number;
381: --
382: hr_utility.set_location(' Leaving:'||l_proc, 70);
383: exception
384: when hr_api.validate_enabled then
385: --
386: -- As the Validate_Enabled exception has been raised
387: -- we must rollback to the savepoint
388: --
415: (p_validate in boolean default false
416: ,p_effective_date in date
417: ,p_situation_id in number
418: ,p_object_version_number in out nocopy number
419: ,p_situation in varchar2 default hr_api.g_varchar2
420: ,p_effective_start_date in date default hr_api.g_date
421: ,p_business_group_id in number default hr_api.g_number
422: ,p_situation_type in varchar2 default hr_api.g_varchar2
423: ,p_length_of_service in varchar2 default hr_api.g_varchar2
416: ,p_effective_date in date
417: ,p_situation_id in number
418: ,p_object_version_number in out nocopy number
419: ,p_situation in varchar2 default hr_api.g_varchar2
420: ,p_effective_start_date in date default hr_api.g_date
421: ,p_business_group_id in number default hr_api.g_number
422: ,p_situation_type in varchar2 default hr_api.g_varchar2
423: ,p_length_of_service in varchar2 default hr_api.g_varchar2
424: ,p_effective_end_date in date default hr_api.g_date
417: ,p_situation_id in number
418: ,p_object_version_number in out nocopy number
419: ,p_situation in varchar2 default hr_api.g_varchar2
420: ,p_effective_start_date in date default hr_api.g_date
421: ,p_business_group_id in number default hr_api.g_number
422: ,p_situation_type in varchar2 default hr_api.g_varchar2
423: ,p_length_of_service in varchar2 default hr_api.g_varchar2
424: ,p_effective_end_date in date default hr_api.g_date
425: ,p_employee_type in varchar2 default hr_api.g_varchar2
418: ,p_object_version_number in out nocopy number
419: ,p_situation in varchar2 default hr_api.g_varchar2
420: ,p_effective_start_date in date default hr_api.g_date
421: ,p_business_group_id in number default hr_api.g_number
422: ,p_situation_type in varchar2 default hr_api.g_varchar2
423: ,p_length_of_service in varchar2 default hr_api.g_varchar2
424: ,p_effective_end_date in date default hr_api.g_date
425: ,p_employee_type in varchar2 default hr_api.g_varchar2
426: ,p_entitlement_flag in varchar2 default hr_api.g_varchar2
419: ,p_situation in varchar2 default hr_api.g_varchar2
420: ,p_effective_start_date in date default hr_api.g_date
421: ,p_business_group_id in number default hr_api.g_number
422: ,p_situation_type in varchar2 default hr_api.g_varchar2
423: ,p_length_of_service in varchar2 default hr_api.g_varchar2
424: ,p_effective_end_date in date default hr_api.g_date
425: ,p_employee_type in varchar2 default hr_api.g_varchar2
426: ,p_entitlement_flag in varchar2 default hr_api.g_varchar2
427: ,p_worktime_proportional in varchar2 default hr_api.g_varchar2
420: ,p_effective_start_date in date default hr_api.g_date
421: ,p_business_group_id in number default hr_api.g_number
422: ,p_situation_type in varchar2 default hr_api.g_varchar2
423: ,p_length_of_service in varchar2 default hr_api.g_varchar2
424: ,p_effective_end_date in date default hr_api.g_date
425: ,p_employee_type in varchar2 default hr_api.g_varchar2
426: ,p_entitlement_flag in varchar2 default hr_api.g_varchar2
427: ,p_worktime_proportional in varchar2 default hr_api.g_varchar2
428: ,p_entitlement_value in number default hr_api.g_number
421: ,p_business_group_id in number default hr_api.g_number
422: ,p_situation_type in varchar2 default hr_api.g_varchar2
423: ,p_length_of_service in varchar2 default hr_api.g_varchar2
424: ,p_effective_end_date in date default hr_api.g_date
425: ,p_employee_type in varchar2 default hr_api.g_varchar2
426: ,p_entitlement_flag in varchar2 default hr_api.g_varchar2
427: ,p_worktime_proportional in varchar2 default hr_api.g_varchar2
428: ,p_entitlement_value in number default hr_api.g_number
429: ,p_information_category in varchar2 default hr_api.g_varchar2
422: ,p_situation_type in varchar2 default hr_api.g_varchar2
423: ,p_length_of_service in varchar2 default hr_api.g_varchar2
424: ,p_effective_end_date in date default hr_api.g_date
425: ,p_employee_type in varchar2 default hr_api.g_varchar2
426: ,p_entitlement_flag in varchar2 default hr_api.g_varchar2
427: ,p_worktime_proportional in varchar2 default hr_api.g_varchar2
428: ,p_entitlement_value in number default hr_api.g_number
429: ,p_information_category in varchar2 default hr_api.g_varchar2
430: ,p_information1 in varchar2 default hr_api.g_varchar2
423: ,p_length_of_service in varchar2 default hr_api.g_varchar2
424: ,p_effective_end_date in date default hr_api.g_date
425: ,p_employee_type in varchar2 default hr_api.g_varchar2
426: ,p_entitlement_flag in varchar2 default hr_api.g_varchar2
427: ,p_worktime_proportional in varchar2 default hr_api.g_varchar2
428: ,p_entitlement_value in number default hr_api.g_number
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_effective_end_date in date default hr_api.g_date
425: ,p_employee_type in varchar2 default hr_api.g_varchar2
426: ,p_entitlement_flag in varchar2 default hr_api.g_varchar2
427: ,p_worktime_proportional in varchar2 default hr_api.g_varchar2
428: ,p_entitlement_value in number default hr_api.g_number
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_employee_type in varchar2 default hr_api.g_varchar2
426: ,p_entitlement_flag in varchar2 default hr_api.g_varchar2
427: ,p_worktime_proportional in varchar2 default hr_api.g_varchar2
428: ,p_entitlement_value in number default hr_api.g_number
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_entitlement_flag in varchar2 default hr_api.g_varchar2
427: ,p_worktime_proportional in varchar2 default hr_api.g_varchar2
428: ,p_entitlement_value in number default hr_api.g_number
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_worktime_proportional in varchar2 default hr_api.g_varchar2
428: ,p_entitlement_value in number default hr_api.g_number
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_entitlement_value in number default hr_api.g_number
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_attribute_category 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_attribute_category in varchar2 default hr_api.g_varchar2
461: ,p_attribute1 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_attribute_category in varchar2 default hr_api.g_varchar2
461: ,p_attribute1 in varchar2 default hr_api.g_varchar2
462: ,p_attribute2 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_attribute_category in varchar2 default hr_api.g_varchar2
461: ,p_attribute1 in varchar2 default hr_api.g_varchar2
462: ,p_attribute2 in varchar2 default hr_api.g_varchar2
463: ,p_attribute3 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_attribute_category in varchar2 default hr_api.g_varchar2
461: ,p_attribute1 in varchar2 default hr_api.g_varchar2
462: ,p_attribute2 in varchar2 default hr_api.g_varchar2
463: ,p_attribute3 in varchar2 default hr_api.g_varchar2
464: ,p_attribute4 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_attribute_category in varchar2 default hr_api.g_varchar2
461: ,p_attribute1 in varchar2 default hr_api.g_varchar2
462: ,p_attribute2 in varchar2 default hr_api.g_varchar2
463: ,p_attribute3 in varchar2 default hr_api.g_varchar2
464: ,p_attribute4 in varchar2 default hr_api.g_varchar2
465: ,p_attribute5 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_attribute_category in varchar2 default hr_api.g_varchar2
461: ,p_attribute1 in varchar2 default hr_api.g_varchar2
462: ,p_attribute2 in varchar2 default hr_api.g_varchar2
463: ,p_attribute3 in varchar2 default hr_api.g_varchar2
464: ,p_attribute4 in varchar2 default hr_api.g_varchar2
465: ,p_attribute5 in varchar2 default hr_api.g_varchar2
466: ,p_attribute6 in varchar2 default hr_api.g_varchar2
459: ,p_information30 in varchar2 default hr_api.g_varchar2
460: ,p_attribute_category in varchar2 default hr_api.g_varchar2
461: ,p_attribute1 in varchar2 default hr_api.g_varchar2
462: ,p_attribute2 in varchar2 default hr_api.g_varchar2
463: ,p_attribute3 in varchar2 default hr_api.g_varchar2
464: ,p_attribute4 in varchar2 default hr_api.g_varchar2
465: ,p_attribute5 in varchar2 default hr_api.g_varchar2
466: ,p_attribute6 in varchar2 default hr_api.g_varchar2
467: ,p_attribute7 in varchar2 default hr_api.g_varchar2
460: ,p_attribute_category in varchar2 default hr_api.g_varchar2
461: ,p_attribute1 in varchar2 default hr_api.g_varchar2
462: ,p_attribute2 in varchar2 default hr_api.g_varchar2
463: ,p_attribute3 in varchar2 default hr_api.g_varchar2
464: ,p_attribute4 in varchar2 default hr_api.g_varchar2
465: ,p_attribute5 in varchar2 default hr_api.g_varchar2
466: ,p_attribute6 in varchar2 default hr_api.g_varchar2
467: ,p_attribute7 in varchar2 default hr_api.g_varchar2
468: ,p_attribute8 in varchar2 default hr_api.g_varchar2
461: ,p_attribute1 in varchar2 default hr_api.g_varchar2
462: ,p_attribute2 in varchar2 default hr_api.g_varchar2
463: ,p_attribute3 in varchar2 default hr_api.g_varchar2
464: ,p_attribute4 in varchar2 default hr_api.g_varchar2
465: ,p_attribute5 in varchar2 default hr_api.g_varchar2
466: ,p_attribute6 in varchar2 default hr_api.g_varchar2
467: ,p_attribute7 in varchar2 default hr_api.g_varchar2
468: ,p_attribute8 in varchar2 default hr_api.g_varchar2
469: ,p_attribute9 in varchar2 default hr_api.g_varchar2
462: ,p_attribute2 in varchar2 default hr_api.g_varchar2
463: ,p_attribute3 in varchar2 default hr_api.g_varchar2
464: ,p_attribute4 in varchar2 default hr_api.g_varchar2
465: ,p_attribute5 in varchar2 default hr_api.g_varchar2
466: ,p_attribute6 in varchar2 default hr_api.g_varchar2
467: ,p_attribute7 in varchar2 default hr_api.g_varchar2
468: ,p_attribute8 in varchar2 default hr_api.g_varchar2
469: ,p_attribute9 in varchar2 default hr_api.g_varchar2
470: ,p_attribute10 in varchar2 default hr_api.g_varchar2
463: ,p_attribute3 in varchar2 default hr_api.g_varchar2
464: ,p_attribute4 in varchar2 default hr_api.g_varchar2
465: ,p_attribute5 in varchar2 default hr_api.g_varchar2
466: ,p_attribute6 in varchar2 default hr_api.g_varchar2
467: ,p_attribute7 in varchar2 default hr_api.g_varchar2
468: ,p_attribute8 in varchar2 default hr_api.g_varchar2
469: ,p_attribute9 in varchar2 default hr_api.g_varchar2
470: ,p_attribute10 in varchar2 default hr_api.g_varchar2
471: ,p_attribute11 in varchar2 default hr_api.g_varchar2
464: ,p_attribute4 in varchar2 default hr_api.g_varchar2
465: ,p_attribute5 in varchar2 default hr_api.g_varchar2
466: ,p_attribute6 in varchar2 default hr_api.g_varchar2
467: ,p_attribute7 in varchar2 default hr_api.g_varchar2
468: ,p_attribute8 in varchar2 default hr_api.g_varchar2
469: ,p_attribute9 in varchar2 default hr_api.g_varchar2
470: ,p_attribute10 in varchar2 default hr_api.g_varchar2
471: ,p_attribute11 in varchar2 default hr_api.g_varchar2
472: ,p_attribute12 in varchar2 default hr_api.g_varchar2
465: ,p_attribute5 in varchar2 default hr_api.g_varchar2
466: ,p_attribute6 in varchar2 default hr_api.g_varchar2
467: ,p_attribute7 in varchar2 default hr_api.g_varchar2
468: ,p_attribute8 in varchar2 default hr_api.g_varchar2
469: ,p_attribute9 in varchar2 default hr_api.g_varchar2
470: ,p_attribute10 in varchar2 default hr_api.g_varchar2
471: ,p_attribute11 in varchar2 default hr_api.g_varchar2
472: ,p_attribute12 in varchar2 default hr_api.g_varchar2
473: ,p_attribute13 in varchar2 default hr_api.g_varchar2
466: ,p_attribute6 in varchar2 default hr_api.g_varchar2
467: ,p_attribute7 in varchar2 default hr_api.g_varchar2
468: ,p_attribute8 in varchar2 default hr_api.g_varchar2
469: ,p_attribute9 in varchar2 default hr_api.g_varchar2
470: ,p_attribute10 in varchar2 default hr_api.g_varchar2
471: ,p_attribute11 in varchar2 default hr_api.g_varchar2
472: ,p_attribute12 in varchar2 default hr_api.g_varchar2
473: ,p_attribute13 in varchar2 default hr_api.g_varchar2
474: ,p_attribute14 in varchar2 default hr_api.g_varchar2
467: ,p_attribute7 in varchar2 default hr_api.g_varchar2
468: ,p_attribute8 in varchar2 default hr_api.g_varchar2
469: ,p_attribute9 in varchar2 default hr_api.g_varchar2
470: ,p_attribute10 in varchar2 default hr_api.g_varchar2
471: ,p_attribute11 in varchar2 default hr_api.g_varchar2
472: ,p_attribute12 in varchar2 default hr_api.g_varchar2
473: ,p_attribute13 in varchar2 default hr_api.g_varchar2
474: ,p_attribute14 in varchar2 default hr_api.g_varchar2
475: ,p_attribute15 in varchar2 default hr_api.g_varchar2
468: ,p_attribute8 in varchar2 default hr_api.g_varchar2
469: ,p_attribute9 in varchar2 default hr_api.g_varchar2
470: ,p_attribute10 in varchar2 default hr_api.g_varchar2
471: ,p_attribute11 in varchar2 default hr_api.g_varchar2
472: ,p_attribute12 in varchar2 default hr_api.g_varchar2
473: ,p_attribute13 in varchar2 default hr_api.g_varchar2
474: ,p_attribute14 in varchar2 default hr_api.g_varchar2
475: ,p_attribute15 in varchar2 default hr_api.g_varchar2
476: ,p_attribute16 in varchar2 default hr_api.g_varchar2
469: ,p_attribute9 in varchar2 default hr_api.g_varchar2
470: ,p_attribute10 in varchar2 default hr_api.g_varchar2
471: ,p_attribute11 in varchar2 default hr_api.g_varchar2
472: ,p_attribute12 in varchar2 default hr_api.g_varchar2
473: ,p_attribute13 in varchar2 default hr_api.g_varchar2
474: ,p_attribute14 in varchar2 default hr_api.g_varchar2
475: ,p_attribute15 in varchar2 default hr_api.g_varchar2
476: ,p_attribute16 in varchar2 default hr_api.g_varchar2
477: ,p_attribute17 in varchar2 default hr_api.g_varchar2
470: ,p_attribute10 in varchar2 default hr_api.g_varchar2
471: ,p_attribute11 in varchar2 default hr_api.g_varchar2
472: ,p_attribute12 in varchar2 default hr_api.g_varchar2
473: ,p_attribute13 in varchar2 default hr_api.g_varchar2
474: ,p_attribute14 in varchar2 default hr_api.g_varchar2
475: ,p_attribute15 in varchar2 default hr_api.g_varchar2
476: ,p_attribute16 in varchar2 default hr_api.g_varchar2
477: ,p_attribute17 in varchar2 default hr_api.g_varchar2
478: ,p_attribute18 in varchar2 default hr_api.g_varchar2
471: ,p_attribute11 in varchar2 default hr_api.g_varchar2
472: ,p_attribute12 in varchar2 default hr_api.g_varchar2
473: ,p_attribute13 in varchar2 default hr_api.g_varchar2
474: ,p_attribute14 in varchar2 default hr_api.g_varchar2
475: ,p_attribute15 in varchar2 default hr_api.g_varchar2
476: ,p_attribute16 in varchar2 default hr_api.g_varchar2
477: ,p_attribute17 in varchar2 default hr_api.g_varchar2
478: ,p_attribute18 in varchar2 default hr_api.g_varchar2
479: ,p_attribute19 in varchar2 default hr_api.g_varchar2
472: ,p_attribute12 in varchar2 default hr_api.g_varchar2
473: ,p_attribute13 in varchar2 default hr_api.g_varchar2
474: ,p_attribute14 in varchar2 default hr_api.g_varchar2
475: ,p_attribute15 in varchar2 default hr_api.g_varchar2
476: ,p_attribute16 in varchar2 default hr_api.g_varchar2
477: ,p_attribute17 in varchar2 default hr_api.g_varchar2
478: ,p_attribute18 in varchar2 default hr_api.g_varchar2
479: ,p_attribute19 in varchar2 default hr_api.g_varchar2
480: ,p_attribute20 in varchar2 default hr_api.g_varchar2
473: ,p_attribute13 in varchar2 default hr_api.g_varchar2
474: ,p_attribute14 in varchar2 default hr_api.g_varchar2
475: ,p_attribute15 in varchar2 default hr_api.g_varchar2
476: ,p_attribute16 in varchar2 default hr_api.g_varchar2
477: ,p_attribute17 in varchar2 default hr_api.g_varchar2
478: ,p_attribute18 in varchar2 default hr_api.g_varchar2
479: ,p_attribute19 in varchar2 default hr_api.g_varchar2
480: ,p_attribute20 in varchar2 default hr_api.g_varchar2
481: ,p_attribute21 in varchar2 default hr_api.g_varchar2
474: ,p_attribute14 in varchar2 default hr_api.g_varchar2
475: ,p_attribute15 in varchar2 default hr_api.g_varchar2
476: ,p_attribute16 in varchar2 default hr_api.g_varchar2
477: ,p_attribute17 in varchar2 default hr_api.g_varchar2
478: ,p_attribute18 in varchar2 default hr_api.g_varchar2
479: ,p_attribute19 in varchar2 default hr_api.g_varchar2
480: ,p_attribute20 in varchar2 default hr_api.g_varchar2
481: ,p_attribute21 in varchar2 default hr_api.g_varchar2
482: ,p_attribute22 in varchar2 default hr_api.g_varchar2
475: ,p_attribute15 in varchar2 default hr_api.g_varchar2
476: ,p_attribute16 in varchar2 default hr_api.g_varchar2
477: ,p_attribute17 in varchar2 default hr_api.g_varchar2
478: ,p_attribute18 in varchar2 default hr_api.g_varchar2
479: ,p_attribute19 in varchar2 default hr_api.g_varchar2
480: ,p_attribute20 in varchar2 default hr_api.g_varchar2
481: ,p_attribute21 in varchar2 default hr_api.g_varchar2
482: ,p_attribute22 in varchar2 default hr_api.g_varchar2
483: ,p_attribute23 in varchar2 default hr_api.g_varchar2
476: ,p_attribute16 in varchar2 default hr_api.g_varchar2
477: ,p_attribute17 in varchar2 default hr_api.g_varchar2
478: ,p_attribute18 in varchar2 default hr_api.g_varchar2
479: ,p_attribute19 in varchar2 default hr_api.g_varchar2
480: ,p_attribute20 in varchar2 default hr_api.g_varchar2
481: ,p_attribute21 in varchar2 default hr_api.g_varchar2
482: ,p_attribute22 in varchar2 default hr_api.g_varchar2
483: ,p_attribute23 in varchar2 default hr_api.g_varchar2
484: ,p_attribute24 in varchar2 default hr_api.g_varchar2
477: ,p_attribute17 in varchar2 default hr_api.g_varchar2
478: ,p_attribute18 in varchar2 default hr_api.g_varchar2
479: ,p_attribute19 in varchar2 default hr_api.g_varchar2
480: ,p_attribute20 in varchar2 default hr_api.g_varchar2
481: ,p_attribute21 in varchar2 default hr_api.g_varchar2
482: ,p_attribute22 in varchar2 default hr_api.g_varchar2
483: ,p_attribute23 in varchar2 default hr_api.g_varchar2
484: ,p_attribute24 in varchar2 default hr_api.g_varchar2
485: ,p_attribute25 in varchar2 default hr_api.g_varchar2
478: ,p_attribute18 in varchar2 default hr_api.g_varchar2
479: ,p_attribute19 in varchar2 default hr_api.g_varchar2
480: ,p_attribute20 in varchar2 default hr_api.g_varchar2
481: ,p_attribute21 in varchar2 default hr_api.g_varchar2
482: ,p_attribute22 in varchar2 default hr_api.g_varchar2
483: ,p_attribute23 in varchar2 default hr_api.g_varchar2
484: ,p_attribute24 in varchar2 default hr_api.g_varchar2
485: ,p_attribute25 in varchar2 default hr_api.g_varchar2
486: ,p_attribute26 in varchar2 default hr_api.g_varchar2
479: ,p_attribute19 in varchar2 default hr_api.g_varchar2
480: ,p_attribute20 in varchar2 default hr_api.g_varchar2
481: ,p_attribute21 in varchar2 default hr_api.g_varchar2
482: ,p_attribute22 in varchar2 default hr_api.g_varchar2
483: ,p_attribute23 in varchar2 default hr_api.g_varchar2
484: ,p_attribute24 in varchar2 default hr_api.g_varchar2
485: ,p_attribute25 in varchar2 default hr_api.g_varchar2
486: ,p_attribute26 in varchar2 default hr_api.g_varchar2
487: ,p_attribute27 in varchar2 default hr_api.g_varchar2
480: ,p_attribute20 in varchar2 default hr_api.g_varchar2
481: ,p_attribute21 in varchar2 default hr_api.g_varchar2
482: ,p_attribute22 in varchar2 default hr_api.g_varchar2
483: ,p_attribute23 in varchar2 default hr_api.g_varchar2
484: ,p_attribute24 in varchar2 default hr_api.g_varchar2
485: ,p_attribute25 in varchar2 default hr_api.g_varchar2
486: ,p_attribute26 in varchar2 default hr_api.g_varchar2
487: ,p_attribute27 in varchar2 default hr_api.g_varchar2
488: ,p_attribute28 in varchar2 default hr_api.g_varchar2
481: ,p_attribute21 in varchar2 default hr_api.g_varchar2
482: ,p_attribute22 in varchar2 default hr_api.g_varchar2
483: ,p_attribute23 in varchar2 default hr_api.g_varchar2
484: ,p_attribute24 in varchar2 default hr_api.g_varchar2
485: ,p_attribute25 in varchar2 default hr_api.g_varchar2
486: ,p_attribute26 in varchar2 default hr_api.g_varchar2
487: ,p_attribute27 in varchar2 default hr_api.g_varchar2
488: ,p_attribute28 in varchar2 default hr_api.g_varchar2
489: ,p_attribute29 in varchar2 default hr_api.g_varchar2
482: ,p_attribute22 in varchar2 default hr_api.g_varchar2
483: ,p_attribute23 in varchar2 default hr_api.g_varchar2
484: ,p_attribute24 in varchar2 default hr_api.g_varchar2
485: ,p_attribute25 in varchar2 default hr_api.g_varchar2
486: ,p_attribute26 in varchar2 default hr_api.g_varchar2
487: ,p_attribute27 in varchar2 default hr_api.g_varchar2
488: ,p_attribute28 in varchar2 default hr_api.g_varchar2
489: ,p_attribute29 in varchar2 default hr_api.g_varchar2
490: ,p_attribute30 in varchar2 default hr_api.g_varchar2
483: ,p_attribute23 in varchar2 default hr_api.g_varchar2
484: ,p_attribute24 in varchar2 default hr_api.g_varchar2
485: ,p_attribute25 in varchar2 default hr_api.g_varchar2
486: ,p_attribute26 in varchar2 default hr_api.g_varchar2
487: ,p_attribute27 in varchar2 default hr_api.g_varchar2
488: ,p_attribute28 in varchar2 default hr_api.g_varchar2
489: ,p_attribute29 in varchar2 default hr_api.g_varchar2
490: ,p_attribute30 in varchar2 default hr_api.g_varchar2
491: ) is
484: ,p_attribute24 in varchar2 default hr_api.g_varchar2
485: ,p_attribute25 in varchar2 default hr_api.g_varchar2
486: ,p_attribute26 in varchar2 default hr_api.g_varchar2
487: ,p_attribute27 in varchar2 default hr_api.g_varchar2
488: ,p_attribute28 in varchar2 default hr_api.g_varchar2
489: ,p_attribute29 in varchar2 default hr_api.g_varchar2
490: ,p_attribute30 in varchar2 default hr_api.g_varchar2
491: ) is
492: --
485: ,p_attribute25 in varchar2 default hr_api.g_varchar2
486: ,p_attribute26 in varchar2 default hr_api.g_varchar2
487: ,p_attribute27 in varchar2 default hr_api.g_varchar2
488: ,p_attribute28 in varchar2 default hr_api.g_varchar2
489: ,p_attribute29 in varchar2 default hr_api.g_varchar2
490: ,p_attribute30 in varchar2 default hr_api.g_varchar2
491: ) is
492: --
493: -- Declare cursors and local variables
486: ,p_attribute26 in varchar2 default hr_api.g_varchar2
487: ,p_attribute27 in varchar2 default hr_api.g_varchar2
488: ,p_attribute28 in varchar2 default hr_api.g_varchar2
489: ,p_attribute29 in varchar2 default hr_api.g_varchar2
490: ,p_attribute30 in varchar2 default hr_api.g_varchar2
491: ) is
492: --
493: -- Declare cursors and local variables
494: --
587: ,p_situation_id => p_situation_id
588: ,p_object_version_number => p_object_version_number
589: );
590: exception
591: when hr_api.cannot_find_prog_unit then
592: hr_api.cannot_find_prog_unit_error
593: (p_module_name => 'UPDATE_SITUATION'
594: ,p_hook_type => 'BP'
595: );
588: ,p_object_version_number => p_object_version_number
589: );
590: exception
591: when hr_api.cannot_find_prog_unit then
592: hr_api.cannot_find_prog_unit_error
593: (p_module_name => 'UPDATE_SITUATION'
594: ,p_hook_type => 'BP'
595: );
596: end;
763: ,p_situation_id => p_situation_id
764: ,p_object_version_number => p_object_version_number
765: );
766: exception
767: when hr_api.cannot_find_prog_unit then
768: hr_api.cannot_find_prog_unit_error
769: (p_module_name => 'UPDATE_SITUATION'
770: ,p_hook_type => 'AP'
771: );
764: ,p_object_version_number => p_object_version_number
765: );
766: exception
767: when hr_api.cannot_find_prog_unit then
768: hr_api.cannot_find_prog_unit_error
769: (p_module_name => 'UPDATE_SITUATION'
770: ,p_hook_type => 'AP'
771: );
772: end;
773: --
774: -- When in validation only mode raise the Validate_Enabled exception
775: --
776: if p_validate then
777: raise hr_api.validate_enabled;
778: end if;
779: --
780: -- Set all output arguments
781: --
782: p_object_version_number := p_object_version_number;
783: --
784: hr_utility.set_location(' Leaving:'||l_proc, 70);
785: exception
786: when hr_api.validate_enabled then
787: --
788: -- As the Validate_Enabled exception has been raised
789: -- we must rollback to the savepoint
790: --
840: (p_situation_id => p_situation_id
841: ,p_object_version_number => p_object_version_number
842: );
843: exception
844: when hr_api.cannot_find_prog_unit then
845: hr_api.cannot_find_prog_unit_error
846: (p_module_name => 'DELETE_SITUATION'
847: ,p_hook_type => 'BP'
848: );
841: ,p_object_version_number => p_object_version_number
842: );
843: exception
844: when hr_api.cannot_find_prog_unit then
845: hr_api.cannot_find_prog_unit_error
846: (p_module_name => 'DELETE_SITUATION'
847: ,p_hook_type => 'BP'
848: );
849: end;
870: (p_situation_id => p_situation_id
871: ,p_object_version_number => p_object_version_number
872: );
873: exception
874: when hr_api.cannot_find_prog_unit then
875: hr_api.cannot_find_prog_unit_error
876: (p_module_name => 'DELETE_SITUATION'
877: ,p_hook_type => 'AP'
878: );
871: ,p_object_version_number => p_object_version_number
872: );
873: exception
874: when hr_api.cannot_find_prog_unit then
875: hr_api.cannot_find_prog_unit_error
876: (p_module_name => 'DELETE_SITUATION'
877: ,p_hook_type => 'AP'
878: );
879: end;
880: --
881: -- When in validation only mode raise the Validate_Enabled exception
882: --
883: if p_validate then
884: raise hr_api.validate_enabled;
885: end if;
886: --
887: -- Set all output arguments
888: --
888: --
889: --
890: hr_utility.set_location(' Leaving:'||l_proc, 70);
891: exception
892: when hr_api.validate_enabled then
893: --
894: -- As the Validate_Enabled exception has been raised
895: -- we must rollback to the savepoint
896: --