197: ,p_reason_for_no_acco => p_reason_for_no_acco
198: ,p_indemnity_currency => p_indemnity_currency
199: );
200: exception
201: when hr_api.cannot_find_prog_unit then
202: hr_api.cannot_find_prog_unit_error
203: (p_module_name => 'CREATE_ASSIGN_ACCOMMODATION'
204: ,p_hook_type => 'BP'
205: );
198: ,p_indemnity_currency => p_indemnity_currency
199: );
200: exception
201: when hr_api.cannot_find_prog_unit then
202: hr_api.cannot_find_prog_unit_error
203: (p_module_name => 'CREATE_ASSIGN_ACCOMMODATION'
204: ,p_hook_type => 'BP'
205: );
206: end create_assign_accommodation;
385: ,p_effective_start_date => l_effective_start_date
386: ,p_effective_end_date => l_effective_end_date
387: );
388: exception
389: when hr_api.cannot_find_prog_unit then
390: hr_api.cannot_find_prog_unit_error
391: (p_module_name => 'CREATE_ASSIGN_ACCOMMODATION'
392: ,p_hook_type => 'AP'
393: );
386: ,p_effective_end_date => l_effective_end_date
387: );
388: exception
389: when hr_api.cannot_find_prog_unit then
390: hr_api.cannot_find_prog_unit_error
391: (p_module_name => 'CREATE_ASSIGN_ACCOMMODATION'
392: ,p_hook_type => 'AP'
393: );
394: end;
395: --
396: -- When in validation only mode raise the Validate_Enabled exception
397: --
398: if p_validate then
399: raise hr_api.validate_enabled;
400: end if;
401: --
402: -- Set all output arguments
403: --
407: p_effective_end_date := l_effective_end_date;
408: --
409: hr_utility.set_location(' Leaving:'||l_proc, 70);
410: exception
411: when hr_api.validate_enabled then
412: --
413: -- As the Validate_Enabled exception has been raised
414: -- we must rollback to the savepoint
415: --
448: ,p_effective_date in date
449: ,p_datetrack_mode in varchar2
450: ,p_assignment_acco_id in number
451: ,p_object_version_number in out nocopy number
452: ,p_business_group_id in number default hr_api.g_number
453: ,p_assignment_id in number default hr_api.g_number
454: ,p_accommodation_given in varchar2 default hr_api.g_varchar2
455: ,p_temporary_assignment in varchar2 default hr_api.g_varchar2
456: ,p_accommodation_id in number default hr_api.g_number
449: ,p_datetrack_mode in varchar2
450: ,p_assignment_acco_id in number
451: ,p_object_version_number in out nocopy number
452: ,p_business_group_id in number default hr_api.g_number
453: ,p_assignment_id in number default hr_api.g_number
454: ,p_accommodation_given in varchar2 default hr_api.g_varchar2
455: ,p_temporary_assignment in varchar2 default hr_api.g_varchar2
456: ,p_accommodation_id in number default hr_api.g_number
457: ,p_acceptance_date in date default hr_api.g_date
450: ,p_assignment_acco_id in number
451: ,p_object_version_number in out nocopy number
452: ,p_business_group_id in number default hr_api.g_number
453: ,p_assignment_id in number default hr_api.g_number
454: ,p_accommodation_given in varchar2 default hr_api.g_varchar2
455: ,p_temporary_assignment in varchar2 default hr_api.g_varchar2
456: ,p_accommodation_id in number default hr_api.g_number
457: ,p_acceptance_date in date default hr_api.g_date
458: ,p_moving_date in date default hr_api.g_date
451: ,p_object_version_number in out nocopy number
452: ,p_business_group_id in number default hr_api.g_number
453: ,p_assignment_id in number default hr_api.g_number
454: ,p_accommodation_given in varchar2 default hr_api.g_varchar2
455: ,p_temporary_assignment in varchar2 default hr_api.g_varchar2
456: ,p_accommodation_id in number default hr_api.g_number
457: ,p_acceptance_date in date default hr_api.g_date
458: ,p_moving_date in date default hr_api.g_date
459: ,p_refusal_date in date default hr_api.g_date
452: ,p_business_group_id in number default hr_api.g_number
453: ,p_assignment_id in number default hr_api.g_number
454: ,p_accommodation_given in varchar2 default hr_api.g_varchar2
455: ,p_temporary_assignment in varchar2 default hr_api.g_varchar2
456: ,p_accommodation_id in number default hr_api.g_number
457: ,p_acceptance_date in date default hr_api.g_date
458: ,p_moving_date in date default hr_api.g_date
459: ,p_refusal_date in date default hr_api.g_date
460: ,p_comments in varchar2 default hr_api.g_varchar2
453: ,p_assignment_id in number default hr_api.g_number
454: ,p_accommodation_given in varchar2 default hr_api.g_varchar2
455: ,p_temporary_assignment in varchar2 default hr_api.g_varchar2
456: ,p_accommodation_id in number default hr_api.g_number
457: ,p_acceptance_date in date default hr_api.g_date
458: ,p_moving_date in date default hr_api.g_date
459: ,p_refusal_date in date default hr_api.g_date
460: ,p_comments in varchar2 default hr_api.g_varchar2
461: ,p_indemnity_entitlement in varchar2 default hr_api.g_varchar2
454: ,p_accommodation_given in varchar2 default hr_api.g_varchar2
455: ,p_temporary_assignment in varchar2 default hr_api.g_varchar2
456: ,p_accommodation_id in number default hr_api.g_number
457: ,p_acceptance_date in date default hr_api.g_date
458: ,p_moving_date in date default hr_api.g_date
459: ,p_refusal_date in date default hr_api.g_date
460: ,p_comments in varchar2 default hr_api.g_varchar2
461: ,p_indemnity_entitlement in varchar2 default hr_api.g_varchar2
462: ,p_indemnity_amount in number default hr_api.g_number
455: ,p_temporary_assignment in varchar2 default hr_api.g_varchar2
456: ,p_accommodation_id in number default hr_api.g_number
457: ,p_acceptance_date in date default hr_api.g_date
458: ,p_moving_date in date default hr_api.g_date
459: ,p_refusal_date in date default hr_api.g_date
460: ,p_comments in varchar2 default hr_api.g_varchar2
461: ,p_indemnity_entitlement in varchar2 default hr_api.g_varchar2
462: ,p_indemnity_amount in number default hr_api.g_number
463: ,p_type_of_payment in varchar2 default hr_api.g_varchar2
456: ,p_accommodation_id in number default hr_api.g_number
457: ,p_acceptance_date in date default hr_api.g_date
458: ,p_moving_date in date default hr_api.g_date
459: ,p_refusal_date in date default hr_api.g_date
460: ,p_comments in varchar2 default hr_api.g_varchar2
461: ,p_indemnity_entitlement in varchar2 default hr_api.g_varchar2
462: ,p_indemnity_amount in number default hr_api.g_number
463: ,p_type_of_payment in varchar2 default hr_api.g_varchar2
464: ,p_information_category in varchar2 default hr_api.g_varchar2
457: ,p_acceptance_date in date default hr_api.g_date
458: ,p_moving_date in date default hr_api.g_date
459: ,p_refusal_date in date default hr_api.g_date
460: ,p_comments in varchar2 default hr_api.g_varchar2
461: ,p_indemnity_entitlement in varchar2 default hr_api.g_varchar2
462: ,p_indemnity_amount in number default hr_api.g_number
463: ,p_type_of_payment in varchar2 default hr_api.g_varchar2
464: ,p_information_category in varchar2 default hr_api.g_varchar2
465: ,p_information1 in varchar2 default hr_api.g_varchar2
458: ,p_moving_date in date default hr_api.g_date
459: ,p_refusal_date in date default hr_api.g_date
460: ,p_comments in varchar2 default hr_api.g_varchar2
461: ,p_indemnity_entitlement in varchar2 default hr_api.g_varchar2
462: ,p_indemnity_amount in number default hr_api.g_number
463: ,p_type_of_payment in varchar2 default hr_api.g_varchar2
464: ,p_information_category in varchar2 default hr_api.g_varchar2
465: ,p_information1 in varchar2 default hr_api.g_varchar2
466: ,p_information2 in varchar2 default hr_api.g_varchar2
459: ,p_refusal_date in date default hr_api.g_date
460: ,p_comments in varchar2 default hr_api.g_varchar2
461: ,p_indemnity_entitlement in varchar2 default hr_api.g_varchar2
462: ,p_indemnity_amount in number default hr_api.g_number
463: ,p_type_of_payment in varchar2 default hr_api.g_varchar2
464: ,p_information_category in varchar2 default hr_api.g_varchar2
465: ,p_information1 in varchar2 default hr_api.g_varchar2
466: ,p_information2 in varchar2 default hr_api.g_varchar2
467: ,p_information3 in varchar2 default hr_api.g_varchar2
460: ,p_comments in varchar2 default hr_api.g_varchar2
461: ,p_indemnity_entitlement in varchar2 default hr_api.g_varchar2
462: ,p_indemnity_amount in number default hr_api.g_number
463: ,p_type_of_payment in varchar2 default hr_api.g_varchar2
464: ,p_information_category in varchar2 default hr_api.g_varchar2
465: ,p_information1 in varchar2 default hr_api.g_varchar2
466: ,p_information2 in varchar2 default hr_api.g_varchar2
467: ,p_information3 in varchar2 default hr_api.g_varchar2
468: ,p_information4 in varchar2 default hr_api.g_varchar2
461: ,p_indemnity_entitlement in varchar2 default hr_api.g_varchar2
462: ,p_indemnity_amount in number default hr_api.g_number
463: ,p_type_of_payment in varchar2 default hr_api.g_varchar2
464: ,p_information_category in varchar2 default hr_api.g_varchar2
465: ,p_information1 in varchar2 default hr_api.g_varchar2
466: ,p_information2 in varchar2 default hr_api.g_varchar2
467: ,p_information3 in varchar2 default hr_api.g_varchar2
468: ,p_information4 in varchar2 default hr_api.g_varchar2
469: ,p_information5 in varchar2 default hr_api.g_varchar2
462: ,p_indemnity_amount in number default hr_api.g_number
463: ,p_type_of_payment in varchar2 default hr_api.g_varchar2
464: ,p_information_category in varchar2 default hr_api.g_varchar2
465: ,p_information1 in varchar2 default hr_api.g_varchar2
466: ,p_information2 in varchar2 default hr_api.g_varchar2
467: ,p_information3 in varchar2 default hr_api.g_varchar2
468: ,p_information4 in varchar2 default hr_api.g_varchar2
469: ,p_information5 in varchar2 default hr_api.g_varchar2
470: ,p_information6 in varchar2 default hr_api.g_varchar2
463: ,p_type_of_payment in varchar2 default hr_api.g_varchar2
464: ,p_information_category in varchar2 default hr_api.g_varchar2
465: ,p_information1 in varchar2 default hr_api.g_varchar2
466: ,p_information2 in varchar2 default hr_api.g_varchar2
467: ,p_information3 in varchar2 default hr_api.g_varchar2
468: ,p_information4 in varchar2 default hr_api.g_varchar2
469: ,p_information5 in varchar2 default hr_api.g_varchar2
470: ,p_information6 in varchar2 default hr_api.g_varchar2
471: ,p_information7 in varchar2 default hr_api.g_varchar2
464: ,p_information_category in varchar2 default hr_api.g_varchar2
465: ,p_information1 in varchar2 default hr_api.g_varchar2
466: ,p_information2 in varchar2 default hr_api.g_varchar2
467: ,p_information3 in varchar2 default hr_api.g_varchar2
468: ,p_information4 in varchar2 default hr_api.g_varchar2
469: ,p_information5 in varchar2 default hr_api.g_varchar2
470: ,p_information6 in varchar2 default hr_api.g_varchar2
471: ,p_information7 in varchar2 default hr_api.g_varchar2
472: ,p_information8 in varchar2 default hr_api.g_varchar2
465: ,p_information1 in varchar2 default hr_api.g_varchar2
466: ,p_information2 in varchar2 default hr_api.g_varchar2
467: ,p_information3 in varchar2 default hr_api.g_varchar2
468: ,p_information4 in varchar2 default hr_api.g_varchar2
469: ,p_information5 in varchar2 default hr_api.g_varchar2
470: ,p_information6 in varchar2 default hr_api.g_varchar2
471: ,p_information7 in varchar2 default hr_api.g_varchar2
472: ,p_information8 in varchar2 default hr_api.g_varchar2
473: ,p_information9 in varchar2 default hr_api.g_varchar2
466: ,p_information2 in varchar2 default hr_api.g_varchar2
467: ,p_information3 in varchar2 default hr_api.g_varchar2
468: ,p_information4 in varchar2 default hr_api.g_varchar2
469: ,p_information5 in varchar2 default hr_api.g_varchar2
470: ,p_information6 in varchar2 default hr_api.g_varchar2
471: ,p_information7 in varchar2 default hr_api.g_varchar2
472: ,p_information8 in varchar2 default hr_api.g_varchar2
473: ,p_information9 in varchar2 default hr_api.g_varchar2
474: ,p_information10 in varchar2 default hr_api.g_varchar2
467: ,p_information3 in varchar2 default hr_api.g_varchar2
468: ,p_information4 in varchar2 default hr_api.g_varchar2
469: ,p_information5 in varchar2 default hr_api.g_varchar2
470: ,p_information6 in varchar2 default hr_api.g_varchar2
471: ,p_information7 in varchar2 default hr_api.g_varchar2
472: ,p_information8 in varchar2 default hr_api.g_varchar2
473: ,p_information9 in varchar2 default hr_api.g_varchar2
474: ,p_information10 in varchar2 default hr_api.g_varchar2
475: ,p_information11 in varchar2 default hr_api.g_varchar2
468: ,p_information4 in varchar2 default hr_api.g_varchar2
469: ,p_information5 in varchar2 default hr_api.g_varchar2
470: ,p_information6 in varchar2 default hr_api.g_varchar2
471: ,p_information7 in varchar2 default hr_api.g_varchar2
472: ,p_information8 in varchar2 default hr_api.g_varchar2
473: ,p_information9 in varchar2 default hr_api.g_varchar2
474: ,p_information10 in varchar2 default hr_api.g_varchar2
475: ,p_information11 in varchar2 default hr_api.g_varchar2
476: ,p_information12 in varchar2 default hr_api.g_varchar2
469: ,p_information5 in varchar2 default hr_api.g_varchar2
470: ,p_information6 in varchar2 default hr_api.g_varchar2
471: ,p_information7 in varchar2 default hr_api.g_varchar2
472: ,p_information8 in varchar2 default hr_api.g_varchar2
473: ,p_information9 in varchar2 default hr_api.g_varchar2
474: ,p_information10 in varchar2 default hr_api.g_varchar2
475: ,p_information11 in varchar2 default hr_api.g_varchar2
476: ,p_information12 in varchar2 default hr_api.g_varchar2
477: ,p_information13 in varchar2 default hr_api.g_varchar2
470: ,p_information6 in varchar2 default hr_api.g_varchar2
471: ,p_information7 in varchar2 default hr_api.g_varchar2
472: ,p_information8 in varchar2 default hr_api.g_varchar2
473: ,p_information9 in varchar2 default hr_api.g_varchar2
474: ,p_information10 in varchar2 default hr_api.g_varchar2
475: ,p_information11 in varchar2 default hr_api.g_varchar2
476: ,p_information12 in varchar2 default hr_api.g_varchar2
477: ,p_information13 in varchar2 default hr_api.g_varchar2
478: ,p_information14 in varchar2 default hr_api.g_varchar2
471: ,p_information7 in varchar2 default hr_api.g_varchar2
472: ,p_information8 in varchar2 default hr_api.g_varchar2
473: ,p_information9 in varchar2 default hr_api.g_varchar2
474: ,p_information10 in varchar2 default hr_api.g_varchar2
475: ,p_information11 in varchar2 default hr_api.g_varchar2
476: ,p_information12 in varchar2 default hr_api.g_varchar2
477: ,p_information13 in varchar2 default hr_api.g_varchar2
478: ,p_information14 in varchar2 default hr_api.g_varchar2
479: ,p_information15 in varchar2 default hr_api.g_varchar2
472: ,p_information8 in varchar2 default hr_api.g_varchar2
473: ,p_information9 in varchar2 default hr_api.g_varchar2
474: ,p_information10 in varchar2 default hr_api.g_varchar2
475: ,p_information11 in varchar2 default hr_api.g_varchar2
476: ,p_information12 in varchar2 default hr_api.g_varchar2
477: ,p_information13 in varchar2 default hr_api.g_varchar2
478: ,p_information14 in varchar2 default hr_api.g_varchar2
479: ,p_information15 in varchar2 default hr_api.g_varchar2
480: ,p_information16 in varchar2 default hr_api.g_varchar2
473: ,p_information9 in varchar2 default hr_api.g_varchar2
474: ,p_information10 in varchar2 default hr_api.g_varchar2
475: ,p_information11 in varchar2 default hr_api.g_varchar2
476: ,p_information12 in varchar2 default hr_api.g_varchar2
477: ,p_information13 in varchar2 default hr_api.g_varchar2
478: ,p_information14 in varchar2 default hr_api.g_varchar2
479: ,p_information15 in varchar2 default hr_api.g_varchar2
480: ,p_information16 in varchar2 default hr_api.g_varchar2
481: ,p_information17 in varchar2 default hr_api.g_varchar2
474: ,p_information10 in varchar2 default hr_api.g_varchar2
475: ,p_information11 in varchar2 default hr_api.g_varchar2
476: ,p_information12 in varchar2 default hr_api.g_varchar2
477: ,p_information13 in varchar2 default hr_api.g_varchar2
478: ,p_information14 in varchar2 default hr_api.g_varchar2
479: ,p_information15 in varchar2 default hr_api.g_varchar2
480: ,p_information16 in varchar2 default hr_api.g_varchar2
481: ,p_information17 in varchar2 default hr_api.g_varchar2
482: ,p_information18 in varchar2 default hr_api.g_varchar2
475: ,p_information11 in varchar2 default hr_api.g_varchar2
476: ,p_information12 in varchar2 default hr_api.g_varchar2
477: ,p_information13 in varchar2 default hr_api.g_varchar2
478: ,p_information14 in varchar2 default hr_api.g_varchar2
479: ,p_information15 in varchar2 default hr_api.g_varchar2
480: ,p_information16 in varchar2 default hr_api.g_varchar2
481: ,p_information17 in varchar2 default hr_api.g_varchar2
482: ,p_information18 in varchar2 default hr_api.g_varchar2
483: ,p_information19 in varchar2 default hr_api.g_varchar2
476: ,p_information12 in varchar2 default hr_api.g_varchar2
477: ,p_information13 in varchar2 default hr_api.g_varchar2
478: ,p_information14 in varchar2 default hr_api.g_varchar2
479: ,p_information15 in varchar2 default hr_api.g_varchar2
480: ,p_information16 in varchar2 default hr_api.g_varchar2
481: ,p_information17 in varchar2 default hr_api.g_varchar2
482: ,p_information18 in varchar2 default hr_api.g_varchar2
483: ,p_information19 in varchar2 default hr_api.g_varchar2
484: ,p_information20 in varchar2 default hr_api.g_varchar2
477: ,p_information13 in varchar2 default hr_api.g_varchar2
478: ,p_information14 in varchar2 default hr_api.g_varchar2
479: ,p_information15 in varchar2 default hr_api.g_varchar2
480: ,p_information16 in varchar2 default hr_api.g_varchar2
481: ,p_information17 in varchar2 default hr_api.g_varchar2
482: ,p_information18 in varchar2 default hr_api.g_varchar2
483: ,p_information19 in varchar2 default hr_api.g_varchar2
484: ,p_information20 in varchar2 default hr_api.g_varchar2
485: ,p_information21 in varchar2 default hr_api.g_varchar2
478: ,p_information14 in varchar2 default hr_api.g_varchar2
479: ,p_information15 in varchar2 default hr_api.g_varchar2
480: ,p_information16 in varchar2 default hr_api.g_varchar2
481: ,p_information17 in varchar2 default hr_api.g_varchar2
482: ,p_information18 in varchar2 default hr_api.g_varchar2
483: ,p_information19 in varchar2 default hr_api.g_varchar2
484: ,p_information20 in varchar2 default hr_api.g_varchar2
485: ,p_information21 in varchar2 default hr_api.g_varchar2
486: ,p_information22 in varchar2 default hr_api.g_varchar2
479: ,p_information15 in varchar2 default hr_api.g_varchar2
480: ,p_information16 in varchar2 default hr_api.g_varchar2
481: ,p_information17 in varchar2 default hr_api.g_varchar2
482: ,p_information18 in varchar2 default hr_api.g_varchar2
483: ,p_information19 in varchar2 default hr_api.g_varchar2
484: ,p_information20 in varchar2 default hr_api.g_varchar2
485: ,p_information21 in varchar2 default hr_api.g_varchar2
486: ,p_information22 in varchar2 default hr_api.g_varchar2
487: ,p_information23 in varchar2 default hr_api.g_varchar2
480: ,p_information16 in varchar2 default hr_api.g_varchar2
481: ,p_information17 in varchar2 default hr_api.g_varchar2
482: ,p_information18 in varchar2 default hr_api.g_varchar2
483: ,p_information19 in varchar2 default hr_api.g_varchar2
484: ,p_information20 in varchar2 default hr_api.g_varchar2
485: ,p_information21 in varchar2 default hr_api.g_varchar2
486: ,p_information22 in varchar2 default hr_api.g_varchar2
487: ,p_information23 in varchar2 default hr_api.g_varchar2
488: ,p_information24 in varchar2 default hr_api.g_varchar2
481: ,p_information17 in varchar2 default hr_api.g_varchar2
482: ,p_information18 in varchar2 default hr_api.g_varchar2
483: ,p_information19 in varchar2 default hr_api.g_varchar2
484: ,p_information20 in varchar2 default hr_api.g_varchar2
485: ,p_information21 in varchar2 default hr_api.g_varchar2
486: ,p_information22 in varchar2 default hr_api.g_varchar2
487: ,p_information23 in varchar2 default hr_api.g_varchar2
488: ,p_information24 in varchar2 default hr_api.g_varchar2
489: ,p_information25 in varchar2 default hr_api.g_varchar2
482: ,p_information18 in varchar2 default hr_api.g_varchar2
483: ,p_information19 in varchar2 default hr_api.g_varchar2
484: ,p_information20 in varchar2 default hr_api.g_varchar2
485: ,p_information21 in varchar2 default hr_api.g_varchar2
486: ,p_information22 in varchar2 default hr_api.g_varchar2
487: ,p_information23 in varchar2 default hr_api.g_varchar2
488: ,p_information24 in varchar2 default hr_api.g_varchar2
489: ,p_information25 in varchar2 default hr_api.g_varchar2
490: ,p_information26 in varchar2 default hr_api.g_varchar2
483: ,p_information19 in varchar2 default hr_api.g_varchar2
484: ,p_information20 in varchar2 default hr_api.g_varchar2
485: ,p_information21 in varchar2 default hr_api.g_varchar2
486: ,p_information22 in varchar2 default hr_api.g_varchar2
487: ,p_information23 in varchar2 default hr_api.g_varchar2
488: ,p_information24 in varchar2 default hr_api.g_varchar2
489: ,p_information25 in varchar2 default hr_api.g_varchar2
490: ,p_information26 in varchar2 default hr_api.g_varchar2
491: ,p_information27 in varchar2 default hr_api.g_varchar2
484: ,p_information20 in varchar2 default hr_api.g_varchar2
485: ,p_information21 in varchar2 default hr_api.g_varchar2
486: ,p_information22 in varchar2 default hr_api.g_varchar2
487: ,p_information23 in varchar2 default hr_api.g_varchar2
488: ,p_information24 in varchar2 default hr_api.g_varchar2
489: ,p_information25 in varchar2 default hr_api.g_varchar2
490: ,p_information26 in varchar2 default hr_api.g_varchar2
491: ,p_information27 in varchar2 default hr_api.g_varchar2
492: ,p_information28 in varchar2 default hr_api.g_varchar2
485: ,p_information21 in varchar2 default hr_api.g_varchar2
486: ,p_information22 in varchar2 default hr_api.g_varchar2
487: ,p_information23 in varchar2 default hr_api.g_varchar2
488: ,p_information24 in varchar2 default hr_api.g_varchar2
489: ,p_information25 in varchar2 default hr_api.g_varchar2
490: ,p_information26 in varchar2 default hr_api.g_varchar2
491: ,p_information27 in varchar2 default hr_api.g_varchar2
492: ,p_information28 in varchar2 default hr_api.g_varchar2
493: ,p_information29 in varchar2 default hr_api.g_varchar2
486: ,p_information22 in varchar2 default hr_api.g_varchar2
487: ,p_information23 in varchar2 default hr_api.g_varchar2
488: ,p_information24 in varchar2 default hr_api.g_varchar2
489: ,p_information25 in varchar2 default hr_api.g_varchar2
490: ,p_information26 in varchar2 default hr_api.g_varchar2
491: ,p_information27 in varchar2 default hr_api.g_varchar2
492: ,p_information28 in varchar2 default hr_api.g_varchar2
493: ,p_information29 in varchar2 default hr_api.g_varchar2
494: ,p_information30 in varchar2 default hr_api.g_varchar2
487: ,p_information23 in varchar2 default hr_api.g_varchar2
488: ,p_information24 in varchar2 default hr_api.g_varchar2
489: ,p_information25 in varchar2 default hr_api.g_varchar2
490: ,p_information26 in varchar2 default hr_api.g_varchar2
491: ,p_information27 in varchar2 default hr_api.g_varchar2
492: ,p_information28 in varchar2 default hr_api.g_varchar2
493: ,p_information29 in varchar2 default hr_api.g_varchar2
494: ,p_information30 in varchar2 default hr_api.g_varchar2
495: ,p_attribute_category in varchar2 default hr_api.g_varchar2
488: ,p_information24 in varchar2 default hr_api.g_varchar2
489: ,p_information25 in varchar2 default hr_api.g_varchar2
490: ,p_information26 in varchar2 default hr_api.g_varchar2
491: ,p_information27 in varchar2 default hr_api.g_varchar2
492: ,p_information28 in varchar2 default hr_api.g_varchar2
493: ,p_information29 in varchar2 default hr_api.g_varchar2
494: ,p_information30 in varchar2 default hr_api.g_varchar2
495: ,p_attribute_category in varchar2 default hr_api.g_varchar2
496: ,p_attribute1 in varchar2 default hr_api.g_varchar2
489: ,p_information25 in varchar2 default hr_api.g_varchar2
490: ,p_information26 in varchar2 default hr_api.g_varchar2
491: ,p_information27 in varchar2 default hr_api.g_varchar2
492: ,p_information28 in varchar2 default hr_api.g_varchar2
493: ,p_information29 in varchar2 default hr_api.g_varchar2
494: ,p_information30 in varchar2 default hr_api.g_varchar2
495: ,p_attribute_category in varchar2 default hr_api.g_varchar2
496: ,p_attribute1 in varchar2 default hr_api.g_varchar2
497: ,p_attribute2 in varchar2 default hr_api.g_varchar2
490: ,p_information26 in varchar2 default hr_api.g_varchar2
491: ,p_information27 in varchar2 default hr_api.g_varchar2
492: ,p_information28 in varchar2 default hr_api.g_varchar2
493: ,p_information29 in varchar2 default hr_api.g_varchar2
494: ,p_information30 in varchar2 default hr_api.g_varchar2
495: ,p_attribute_category in varchar2 default hr_api.g_varchar2
496: ,p_attribute1 in varchar2 default hr_api.g_varchar2
497: ,p_attribute2 in varchar2 default hr_api.g_varchar2
498: ,p_attribute3 in varchar2 default hr_api.g_varchar2
491: ,p_information27 in varchar2 default hr_api.g_varchar2
492: ,p_information28 in varchar2 default hr_api.g_varchar2
493: ,p_information29 in varchar2 default hr_api.g_varchar2
494: ,p_information30 in varchar2 default hr_api.g_varchar2
495: ,p_attribute_category in varchar2 default hr_api.g_varchar2
496: ,p_attribute1 in varchar2 default hr_api.g_varchar2
497: ,p_attribute2 in varchar2 default hr_api.g_varchar2
498: ,p_attribute3 in varchar2 default hr_api.g_varchar2
499: ,p_attribute4 in varchar2 default hr_api.g_varchar2
492: ,p_information28 in varchar2 default hr_api.g_varchar2
493: ,p_information29 in varchar2 default hr_api.g_varchar2
494: ,p_information30 in varchar2 default hr_api.g_varchar2
495: ,p_attribute_category in varchar2 default hr_api.g_varchar2
496: ,p_attribute1 in varchar2 default hr_api.g_varchar2
497: ,p_attribute2 in varchar2 default hr_api.g_varchar2
498: ,p_attribute3 in varchar2 default hr_api.g_varchar2
499: ,p_attribute4 in varchar2 default hr_api.g_varchar2
500: ,p_attribute5 in varchar2 default hr_api.g_varchar2
493: ,p_information29 in varchar2 default hr_api.g_varchar2
494: ,p_information30 in varchar2 default hr_api.g_varchar2
495: ,p_attribute_category in varchar2 default hr_api.g_varchar2
496: ,p_attribute1 in varchar2 default hr_api.g_varchar2
497: ,p_attribute2 in varchar2 default hr_api.g_varchar2
498: ,p_attribute3 in varchar2 default hr_api.g_varchar2
499: ,p_attribute4 in varchar2 default hr_api.g_varchar2
500: ,p_attribute5 in varchar2 default hr_api.g_varchar2
501: ,p_attribute6 in varchar2 default hr_api.g_varchar2
494: ,p_information30 in varchar2 default hr_api.g_varchar2
495: ,p_attribute_category in varchar2 default hr_api.g_varchar2
496: ,p_attribute1 in varchar2 default hr_api.g_varchar2
497: ,p_attribute2 in varchar2 default hr_api.g_varchar2
498: ,p_attribute3 in varchar2 default hr_api.g_varchar2
499: ,p_attribute4 in varchar2 default hr_api.g_varchar2
500: ,p_attribute5 in varchar2 default hr_api.g_varchar2
501: ,p_attribute6 in varchar2 default hr_api.g_varchar2
502: ,p_attribute7 in varchar2 default hr_api.g_varchar2
495: ,p_attribute_category in varchar2 default hr_api.g_varchar2
496: ,p_attribute1 in varchar2 default hr_api.g_varchar2
497: ,p_attribute2 in varchar2 default hr_api.g_varchar2
498: ,p_attribute3 in varchar2 default hr_api.g_varchar2
499: ,p_attribute4 in varchar2 default hr_api.g_varchar2
500: ,p_attribute5 in varchar2 default hr_api.g_varchar2
501: ,p_attribute6 in varchar2 default hr_api.g_varchar2
502: ,p_attribute7 in varchar2 default hr_api.g_varchar2
503: ,p_attribute8 in varchar2 default hr_api.g_varchar2
496: ,p_attribute1 in varchar2 default hr_api.g_varchar2
497: ,p_attribute2 in varchar2 default hr_api.g_varchar2
498: ,p_attribute3 in varchar2 default hr_api.g_varchar2
499: ,p_attribute4 in varchar2 default hr_api.g_varchar2
500: ,p_attribute5 in varchar2 default hr_api.g_varchar2
501: ,p_attribute6 in varchar2 default hr_api.g_varchar2
502: ,p_attribute7 in varchar2 default hr_api.g_varchar2
503: ,p_attribute8 in varchar2 default hr_api.g_varchar2
504: ,p_attribute9 in varchar2 default hr_api.g_varchar2
497: ,p_attribute2 in varchar2 default hr_api.g_varchar2
498: ,p_attribute3 in varchar2 default hr_api.g_varchar2
499: ,p_attribute4 in varchar2 default hr_api.g_varchar2
500: ,p_attribute5 in varchar2 default hr_api.g_varchar2
501: ,p_attribute6 in varchar2 default hr_api.g_varchar2
502: ,p_attribute7 in varchar2 default hr_api.g_varchar2
503: ,p_attribute8 in varchar2 default hr_api.g_varchar2
504: ,p_attribute9 in varchar2 default hr_api.g_varchar2
505: ,p_attribute10 in varchar2 default hr_api.g_varchar2
498: ,p_attribute3 in varchar2 default hr_api.g_varchar2
499: ,p_attribute4 in varchar2 default hr_api.g_varchar2
500: ,p_attribute5 in varchar2 default hr_api.g_varchar2
501: ,p_attribute6 in varchar2 default hr_api.g_varchar2
502: ,p_attribute7 in varchar2 default hr_api.g_varchar2
503: ,p_attribute8 in varchar2 default hr_api.g_varchar2
504: ,p_attribute9 in varchar2 default hr_api.g_varchar2
505: ,p_attribute10 in varchar2 default hr_api.g_varchar2
506: ,p_attribute11 in varchar2 default hr_api.g_varchar2
499: ,p_attribute4 in varchar2 default hr_api.g_varchar2
500: ,p_attribute5 in varchar2 default hr_api.g_varchar2
501: ,p_attribute6 in varchar2 default hr_api.g_varchar2
502: ,p_attribute7 in varchar2 default hr_api.g_varchar2
503: ,p_attribute8 in varchar2 default hr_api.g_varchar2
504: ,p_attribute9 in varchar2 default hr_api.g_varchar2
505: ,p_attribute10 in varchar2 default hr_api.g_varchar2
506: ,p_attribute11 in varchar2 default hr_api.g_varchar2
507: ,p_attribute12 in varchar2 default hr_api.g_varchar2
500: ,p_attribute5 in varchar2 default hr_api.g_varchar2
501: ,p_attribute6 in varchar2 default hr_api.g_varchar2
502: ,p_attribute7 in varchar2 default hr_api.g_varchar2
503: ,p_attribute8 in varchar2 default hr_api.g_varchar2
504: ,p_attribute9 in varchar2 default hr_api.g_varchar2
505: ,p_attribute10 in varchar2 default hr_api.g_varchar2
506: ,p_attribute11 in varchar2 default hr_api.g_varchar2
507: ,p_attribute12 in varchar2 default hr_api.g_varchar2
508: ,p_attribute13 in varchar2 default hr_api.g_varchar2
501: ,p_attribute6 in varchar2 default hr_api.g_varchar2
502: ,p_attribute7 in varchar2 default hr_api.g_varchar2
503: ,p_attribute8 in varchar2 default hr_api.g_varchar2
504: ,p_attribute9 in varchar2 default hr_api.g_varchar2
505: ,p_attribute10 in varchar2 default hr_api.g_varchar2
506: ,p_attribute11 in varchar2 default hr_api.g_varchar2
507: ,p_attribute12 in varchar2 default hr_api.g_varchar2
508: ,p_attribute13 in varchar2 default hr_api.g_varchar2
509: ,p_attribute14 in varchar2 default hr_api.g_varchar2
502: ,p_attribute7 in varchar2 default hr_api.g_varchar2
503: ,p_attribute8 in varchar2 default hr_api.g_varchar2
504: ,p_attribute9 in varchar2 default hr_api.g_varchar2
505: ,p_attribute10 in varchar2 default hr_api.g_varchar2
506: ,p_attribute11 in varchar2 default hr_api.g_varchar2
507: ,p_attribute12 in varchar2 default hr_api.g_varchar2
508: ,p_attribute13 in varchar2 default hr_api.g_varchar2
509: ,p_attribute14 in varchar2 default hr_api.g_varchar2
510: ,p_attribute15 in varchar2 default hr_api.g_varchar2
503: ,p_attribute8 in varchar2 default hr_api.g_varchar2
504: ,p_attribute9 in varchar2 default hr_api.g_varchar2
505: ,p_attribute10 in varchar2 default hr_api.g_varchar2
506: ,p_attribute11 in varchar2 default hr_api.g_varchar2
507: ,p_attribute12 in varchar2 default hr_api.g_varchar2
508: ,p_attribute13 in varchar2 default hr_api.g_varchar2
509: ,p_attribute14 in varchar2 default hr_api.g_varchar2
510: ,p_attribute15 in varchar2 default hr_api.g_varchar2
511: ,p_attribute16 in varchar2 default hr_api.g_varchar2
504: ,p_attribute9 in varchar2 default hr_api.g_varchar2
505: ,p_attribute10 in varchar2 default hr_api.g_varchar2
506: ,p_attribute11 in varchar2 default hr_api.g_varchar2
507: ,p_attribute12 in varchar2 default hr_api.g_varchar2
508: ,p_attribute13 in varchar2 default hr_api.g_varchar2
509: ,p_attribute14 in varchar2 default hr_api.g_varchar2
510: ,p_attribute15 in varchar2 default hr_api.g_varchar2
511: ,p_attribute16 in varchar2 default hr_api.g_varchar2
512: ,p_attribute17 in varchar2 default hr_api.g_varchar2
505: ,p_attribute10 in varchar2 default hr_api.g_varchar2
506: ,p_attribute11 in varchar2 default hr_api.g_varchar2
507: ,p_attribute12 in varchar2 default hr_api.g_varchar2
508: ,p_attribute13 in varchar2 default hr_api.g_varchar2
509: ,p_attribute14 in varchar2 default hr_api.g_varchar2
510: ,p_attribute15 in varchar2 default hr_api.g_varchar2
511: ,p_attribute16 in varchar2 default hr_api.g_varchar2
512: ,p_attribute17 in varchar2 default hr_api.g_varchar2
513: ,p_attribute18 in varchar2 default hr_api.g_varchar2
506: ,p_attribute11 in varchar2 default hr_api.g_varchar2
507: ,p_attribute12 in varchar2 default hr_api.g_varchar2
508: ,p_attribute13 in varchar2 default hr_api.g_varchar2
509: ,p_attribute14 in varchar2 default hr_api.g_varchar2
510: ,p_attribute15 in varchar2 default hr_api.g_varchar2
511: ,p_attribute16 in varchar2 default hr_api.g_varchar2
512: ,p_attribute17 in varchar2 default hr_api.g_varchar2
513: ,p_attribute18 in varchar2 default hr_api.g_varchar2
514: ,p_attribute19 in varchar2 default hr_api.g_varchar2
507: ,p_attribute12 in varchar2 default hr_api.g_varchar2
508: ,p_attribute13 in varchar2 default hr_api.g_varchar2
509: ,p_attribute14 in varchar2 default hr_api.g_varchar2
510: ,p_attribute15 in varchar2 default hr_api.g_varchar2
511: ,p_attribute16 in varchar2 default hr_api.g_varchar2
512: ,p_attribute17 in varchar2 default hr_api.g_varchar2
513: ,p_attribute18 in varchar2 default hr_api.g_varchar2
514: ,p_attribute19 in varchar2 default hr_api.g_varchar2
515: ,p_attribute20 in varchar2 default hr_api.g_varchar2
508: ,p_attribute13 in varchar2 default hr_api.g_varchar2
509: ,p_attribute14 in varchar2 default hr_api.g_varchar2
510: ,p_attribute15 in varchar2 default hr_api.g_varchar2
511: ,p_attribute16 in varchar2 default hr_api.g_varchar2
512: ,p_attribute17 in varchar2 default hr_api.g_varchar2
513: ,p_attribute18 in varchar2 default hr_api.g_varchar2
514: ,p_attribute19 in varchar2 default hr_api.g_varchar2
515: ,p_attribute20 in varchar2 default hr_api.g_varchar2
516: ,p_attribute21 in varchar2 default hr_api.g_varchar2
509: ,p_attribute14 in varchar2 default hr_api.g_varchar2
510: ,p_attribute15 in varchar2 default hr_api.g_varchar2
511: ,p_attribute16 in varchar2 default hr_api.g_varchar2
512: ,p_attribute17 in varchar2 default hr_api.g_varchar2
513: ,p_attribute18 in varchar2 default hr_api.g_varchar2
514: ,p_attribute19 in varchar2 default hr_api.g_varchar2
515: ,p_attribute20 in varchar2 default hr_api.g_varchar2
516: ,p_attribute21 in varchar2 default hr_api.g_varchar2
517: ,p_attribute22 in varchar2 default hr_api.g_varchar2
510: ,p_attribute15 in varchar2 default hr_api.g_varchar2
511: ,p_attribute16 in varchar2 default hr_api.g_varchar2
512: ,p_attribute17 in varchar2 default hr_api.g_varchar2
513: ,p_attribute18 in varchar2 default hr_api.g_varchar2
514: ,p_attribute19 in varchar2 default hr_api.g_varchar2
515: ,p_attribute20 in varchar2 default hr_api.g_varchar2
516: ,p_attribute21 in varchar2 default hr_api.g_varchar2
517: ,p_attribute22 in varchar2 default hr_api.g_varchar2
518: ,p_attribute23 in varchar2 default hr_api.g_varchar2
511: ,p_attribute16 in varchar2 default hr_api.g_varchar2
512: ,p_attribute17 in varchar2 default hr_api.g_varchar2
513: ,p_attribute18 in varchar2 default hr_api.g_varchar2
514: ,p_attribute19 in varchar2 default hr_api.g_varchar2
515: ,p_attribute20 in varchar2 default hr_api.g_varchar2
516: ,p_attribute21 in varchar2 default hr_api.g_varchar2
517: ,p_attribute22 in varchar2 default hr_api.g_varchar2
518: ,p_attribute23 in varchar2 default hr_api.g_varchar2
519: ,p_attribute24 in varchar2 default hr_api.g_varchar2
512: ,p_attribute17 in varchar2 default hr_api.g_varchar2
513: ,p_attribute18 in varchar2 default hr_api.g_varchar2
514: ,p_attribute19 in varchar2 default hr_api.g_varchar2
515: ,p_attribute20 in varchar2 default hr_api.g_varchar2
516: ,p_attribute21 in varchar2 default hr_api.g_varchar2
517: ,p_attribute22 in varchar2 default hr_api.g_varchar2
518: ,p_attribute23 in varchar2 default hr_api.g_varchar2
519: ,p_attribute24 in varchar2 default hr_api.g_varchar2
520: ,p_attribute25 in varchar2 default hr_api.g_varchar2
513: ,p_attribute18 in varchar2 default hr_api.g_varchar2
514: ,p_attribute19 in varchar2 default hr_api.g_varchar2
515: ,p_attribute20 in varchar2 default hr_api.g_varchar2
516: ,p_attribute21 in varchar2 default hr_api.g_varchar2
517: ,p_attribute22 in varchar2 default hr_api.g_varchar2
518: ,p_attribute23 in varchar2 default hr_api.g_varchar2
519: ,p_attribute24 in varchar2 default hr_api.g_varchar2
520: ,p_attribute25 in varchar2 default hr_api.g_varchar2
521: ,p_attribute26 in varchar2 default hr_api.g_varchar2
514: ,p_attribute19 in varchar2 default hr_api.g_varchar2
515: ,p_attribute20 in varchar2 default hr_api.g_varchar2
516: ,p_attribute21 in varchar2 default hr_api.g_varchar2
517: ,p_attribute22 in varchar2 default hr_api.g_varchar2
518: ,p_attribute23 in varchar2 default hr_api.g_varchar2
519: ,p_attribute24 in varchar2 default hr_api.g_varchar2
520: ,p_attribute25 in varchar2 default hr_api.g_varchar2
521: ,p_attribute26 in varchar2 default hr_api.g_varchar2
522: ,p_attribute27 in varchar2 default hr_api.g_varchar2
515: ,p_attribute20 in varchar2 default hr_api.g_varchar2
516: ,p_attribute21 in varchar2 default hr_api.g_varchar2
517: ,p_attribute22 in varchar2 default hr_api.g_varchar2
518: ,p_attribute23 in varchar2 default hr_api.g_varchar2
519: ,p_attribute24 in varchar2 default hr_api.g_varchar2
520: ,p_attribute25 in varchar2 default hr_api.g_varchar2
521: ,p_attribute26 in varchar2 default hr_api.g_varchar2
522: ,p_attribute27 in varchar2 default hr_api.g_varchar2
523: ,p_attribute28 in varchar2 default hr_api.g_varchar2
516: ,p_attribute21 in varchar2 default hr_api.g_varchar2
517: ,p_attribute22 in varchar2 default hr_api.g_varchar2
518: ,p_attribute23 in varchar2 default hr_api.g_varchar2
519: ,p_attribute24 in varchar2 default hr_api.g_varchar2
520: ,p_attribute25 in varchar2 default hr_api.g_varchar2
521: ,p_attribute26 in varchar2 default hr_api.g_varchar2
522: ,p_attribute27 in varchar2 default hr_api.g_varchar2
523: ,p_attribute28 in varchar2 default hr_api.g_varchar2
524: ,p_attribute29 in varchar2 default hr_api.g_varchar2
517: ,p_attribute22 in varchar2 default hr_api.g_varchar2
518: ,p_attribute23 in varchar2 default hr_api.g_varchar2
519: ,p_attribute24 in varchar2 default hr_api.g_varchar2
520: ,p_attribute25 in varchar2 default hr_api.g_varchar2
521: ,p_attribute26 in varchar2 default hr_api.g_varchar2
522: ,p_attribute27 in varchar2 default hr_api.g_varchar2
523: ,p_attribute28 in varchar2 default hr_api.g_varchar2
524: ,p_attribute29 in varchar2 default hr_api.g_varchar2
525: ,p_attribute30 in varchar2 default hr_api.g_varchar2
518: ,p_attribute23 in varchar2 default hr_api.g_varchar2
519: ,p_attribute24 in varchar2 default hr_api.g_varchar2
520: ,p_attribute25 in varchar2 default hr_api.g_varchar2
521: ,p_attribute26 in varchar2 default hr_api.g_varchar2
522: ,p_attribute27 in varchar2 default hr_api.g_varchar2
523: ,p_attribute28 in varchar2 default hr_api.g_varchar2
524: ,p_attribute29 in varchar2 default hr_api.g_varchar2
525: ,p_attribute30 in varchar2 default hr_api.g_varchar2
526: ,p_reason_for_no_acco in varchar2 default hr_api.g_varchar2
519: ,p_attribute24 in varchar2 default hr_api.g_varchar2
520: ,p_attribute25 in varchar2 default hr_api.g_varchar2
521: ,p_attribute26 in varchar2 default hr_api.g_varchar2
522: ,p_attribute27 in varchar2 default hr_api.g_varchar2
523: ,p_attribute28 in varchar2 default hr_api.g_varchar2
524: ,p_attribute29 in varchar2 default hr_api.g_varchar2
525: ,p_attribute30 in varchar2 default hr_api.g_varchar2
526: ,p_reason_for_no_acco in varchar2 default hr_api.g_varchar2
527: ,p_indemnity_currency in varchar2 default hr_api.g_varchar2
520: ,p_attribute25 in varchar2 default hr_api.g_varchar2
521: ,p_attribute26 in varchar2 default hr_api.g_varchar2
522: ,p_attribute27 in varchar2 default hr_api.g_varchar2
523: ,p_attribute28 in varchar2 default hr_api.g_varchar2
524: ,p_attribute29 in varchar2 default hr_api.g_varchar2
525: ,p_attribute30 in varchar2 default hr_api.g_varchar2
526: ,p_reason_for_no_acco in varchar2 default hr_api.g_varchar2
527: ,p_indemnity_currency in varchar2 default hr_api.g_varchar2
528: ,p_effective_start_date out nocopy date
521: ,p_attribute26 in varchar2 default hr_api.g_varchar2
522: ,p_attribute27 in varchar2 default hr_api.g_varchar2
523: ,p_attribute28 in varchar2 default hr_api.g_varchar2
524: ,p_attribute29 in varchar2 default hr_api.g_varchar2
525: ,p_attribute30 in varchar2 default hr_api.g_varchar2
526: ,p_reason_for_no_acco in varchar2 default hr_api.g_varchar2
527: ,p_indemnity_currency in varchar2 default hr_api.g_varchar2
528: ,p_effective_start_date out nocopy date
529: ,p_effective_end_date out nocopy date
522: ,p_attribute27 in varchar2 default hr_api.g_varchar2
523: ,p_attribute28 in varchar2 default hr_api.g_varchar2
524: ,p_attribute29 in varchar2 default hr_api.g_varchar2
525: ,p_attribute30 in varchar2 default hr_api.g_varchar2
526: ,p_reason_for_no_acco in varchar2 default hr_api.g_varchar2
527: ,p_indemnity_currency in varchar2 default hr_api.g_varchar2
528: ,p_effective_start_date out nocopy date
529: ,p_effective_end_date out nocopy date
530: ) is
523: ,p_attribute28 in varchar2 default hr_api.g_varchar2
524: ,p_attribute29 in varchar2 default hr_api.g_varchar2
525: ,p_attribute30 in varchar2 default hr_api.g_varchar2
526: ,p_reason_for_no_acco in varchar2 default hr_api.g_varchar2
527: ,p_indemnity_currency in varchar2 default hr_api.g_varchar2
528: ,p_effective_start_date out nocopy date
529: ,p_effective_end_date out nocopy date
530: ) is
531: --
634: ,p_reason_for_no_acco => p_reason_for_no_acco
635: ,p_indemnity_currency => p_indemnity_currency
636: );
637: exception
638: when hr_api.cannot_find_prog_unit then
639: hr_api.cannot_find_prog_unit_error
640: (p_module_name => 'UPDATE_ASSIGN_ACCOMMODATION'
641: ,p_hook_type => 'BP'
642: );
635: ,p_indemnity_currency => p_indemnity_currency
636: );
637: exception
638: when hr_api.cannot_find_prog_unit then
639: hr_api.cannot_find_prog_unit_error
640: (p_module_name => 'UPDATE_ASSIGN_ACCOMMODATION'
641: ,p_hook_type => 'BP'
642: );
643: end;
824: ,p_effective_start_date => l_effective_start_date
825: ,p_effective_end_date => l_effective_end_date
826: );
827: exception
828: when hr_api.cannot_find_prog_unit then
829: hr_api.cannot_find_prog_unit_error
830: (p_module_name => 'UPDATE_ASSIGN_ACCOMMODATION'
831: ,p_hook_type => 'AP'
832: );
825: ,p_effective_end_date => l_effective_end_date
826: );
827: exception
828: when hr_api.cannot_find_prog_unit then
829: hr_api.cannot_find_prog_unit_error
830: (p_module_name => 'UPDATE_ASSIGN_ACCOMMODATION'
831: ,p_hook_type => 'AP'
832: );
833: end;
834: --
835: -- When in validation only mode raise the Validate_Enabled exception
836: --
837: if p_validate then
838: raise hr_api.validate_enabled;
839: end if;
840: --
841: -- Set all output arguments
842: --
845: p_effective_end_date := l_effective_end_date;
846: --
847: hr_utility.set_location(' Leaving:'||l_proc, 70);
848: exception
849: when hr_api.validate_enabled then
850: --
851: -- As the Validate_Enabled exception has been raised
852: -- we must rollback to the savepoint
853: --
918: ,p_assignment_acco_id => p_assignment_acco_id
919: ,p_object_version_number => p_object_version_number
920: );
921: exception
922: when hr_api.cannot_find_prog_unit then
923: hr_api.cannot_find_prog_unit_error
924: (p_module_name => 'DELETE_ASSIGN_ACCOMMODATION'
925: ,p_hook_type => 'BP'
926: );
919: ,p_object_version_number => p_object_version_number
920: );
921: exception
922: when hr_api.cannot_find_prog_unit then
923: hr_api.cannot_find_prog_unit_error
924: (p_module_name => 'DELETE_ASSIGN_ACCOMMODATION'
925: ,p_hook_type => 'BP'
926: );
927: end;
956: ,p_effective_start_date => l_effective_start_date
957: ,p_effective_end_date => l_effective_end_date
958: );
959: exception
960: when hr_api.cannot_find_prog_unit then
961: hr_api.cannot_find_prog_unit_error
962: (p_module_name => 'DELETE_ASSIGN_ACCOMMODATION'
963: ,p_hook_type => 'AP'
964: );
957: ,p_effective_end_date => l_effective_end_date
958: );
959: exception
960: when hr_api.cannot_find_prog_unit then
961: hr_api.cannot_find_prog_unit_error
962: (p_module_name => 'DELETE_ASSIGN_ACCOMMODATION'
963: ,p_hook_type => 'AP'
964: );
965: end;
966: --
967: -- When in validation only mode raise the Validate_Enabled exception
968: --
969: if p_validate then
970: raise hr_api.validate_enabled;
971: end if;
972: --
973: p_object_version_number := p_object_version_number;
974: p_effective_start_date := l_effective_start_date;
976: --
977: --
978: hr_utility.set_location(' Leaving:'||l_proc, 70);
979: exception
980: when hr_api.validate_enabled then
981: --
982: -- As the Validate_Enabled exception has been raised
983: -- we must rollback to the savepoint
984: --