195: ,p_attribute20 => p_attribute20
196: ,p_effective_date => trunc(p_effective_date)
197: );
198: exception
199: when hr_api.cannot_find_prog_unit then
200: hr_api.cannot_find_prog_unit_error
201: (
202: p_module_name => 'CREATE_contract'
203: ,p_hook_type => 'BP'
196: ,p_effective_date => trunc(p_effective_date)
197: );
198: exception
199: when hr_api.cannot_find_prog_unit then
200: hr_api.cannot_find_prog_unit_error
201: (
202: p_module_name => 'CREATE_contract'
203: ,p_hook_type => 'BP'
204: );
208: hr_utility.set_location(l_proc, 30);
209: --
210: --
211: -- Validation in addition to Table Handlers
212: hr_api.mandatory_arg_error
213: (p_api_name => l_proc
214: ,p_argument => 'person_id'
215: ,p_argument_value => p_person_id
216: );
214: ,p_argument => 'person_id'
215: ,p_argument_value => p_person_id
216: );
217: --
218: hr_api.mandatory_arg_error
219: (p_api_name => l_proc
220: ,p_argument => 'effective_date'
221: ,p_argument_value => l_effective_date
222: );
368: ,p_attribute20 => p_attribute20
369: ,p_effective_date => trunc(p_effective_date)
370: );
371: exception
372: when hr_api.cannot_find_prog_unit then
373: hr_api.cannot_find_prog_unit_error
374: (p_module_name => 'CREATE_contract'
375: ,p_hook_type => 'AP'
376: );
369: ,p_effective_date => trunc(p_effective_date)
370: );
371: exception
372: when hr_api.cannot_find_prog_unit then
373: hr_api.cannot_find_prog_unit_error
374: (p_module_name => 'CREATE_contract'
375: ,p_hook_type => 'AP'
376: );
377: --
383: --
384: -- When in validation only mode raise the Validate_Enabled exception
385: --
386: if p_validate then
387: raise hr_api.validate_enabled;
388: end if;
389: --
390: -- Set all output arguments
391: --
397: hr_utility.set_location(' Leaving:'||l_proc, 70);
398: --
399: exception
400: --
401: when hr_api.validate_enabled then
402: --
403: -- As the Validate_Enabled exception has been raised
404: -- we must rollback to the savepoint
405: --
442: ,p_person_id in number
443: ,p_reference in varchar2
444: ,p_type in varchar2
445: ,p_status in varchar2
446: ,p_status_reason in varchar2 default hr_api.g_varchar2
447: ,p_doc_status in varchar2 default hr_api.g_varchar2
448: ,p_doc_status_change_date in date default hr_api.g_date
449: ,p_description in varchar2 default hr_api.g_varchar2
450: ,p_duration in number default hr_api.g_number
443: ,p_reference in varchar2
444: ,p_type in varchar2
445: ,p_status in varchar2
446: ,p_status_reason in varchar2 default hr_api.g_varchar2
447: ,p_doc_status in varchar2 default hr_api.g_varchar2
448: ,p_doc_status_change_date in date default hr_api.g_date
449: ,p_description in varchar2 default hr_api.g_varchar2
450: ,p_duration in number default hr_api.g_number
451: ,p_duration_units in varchar2 default hr_api.g_varchar2
444: ,p_type in varchar2
445: ,p_status in varchar2
446: ,p_status_reason in varchar2 default hr_api.g_varchar2
447: ,p_doc_status in varchar2 default hr_api.g_varchar2
448: ,p_doc_status_change_date in date default hr_api.g_date
449: ,p_description in varchar2 default hr_api.g_varchar2
450: ,p_duration in number default hr_api.g_number
451: ,p_duration_units in varchar2 default hr_api.g_varchar2
452: ,p_contractual_job_title in varchar2 default hr_api.g_varchar2
445: ,p_status in varchar2
446: ,p_status_reason in varchar2 default hr_api.g_varchar2
447: ,p_doc_status in varchar2 default hr_api.g_varchar2
448: ,p_doc_status_change_date in date default hr_api.g_date
449: ,p_description in varchar2 default hr_api.g_varchar2
450: ,p_duration in number default hr_api.g_number
451: ,p_duration_units in varchar2 default hr_api.g_varchar2
452: ,p_contractual_job_title in varchar2 default hr_api.g_varchar2
453: ,p_parties in varchar2 default hr_api.g_varchar2
446: ,p_status_reason in varchar2 default hr_api.g_varchar2
447: ,p_doc_status in varchar2 default hr_api.g_varchar2
448: ,p_doc_status_change_date in date default hr_api.g_date
449: ,p_description in varchar2 default hr_api.g_varchar2
450: ,p_duration in number default hr_api.g_number
451: ,p_duration_units in varchar2 default hr_api.g_varchar2
452: ,p_contractual_job_title in varchar2 default hr_api.g_varchar2
453: ,p_parties in varchar2 default hr_api.g_varchar2
454: ,p_start_reason in varchar2 default hr_api.g_varchar2
447: ,p_doc_status in varchar2 default hr_api.g_varchar2
448: ,p_doc_status_change_date in date default hr_api.g_date
449: ,p_description in varchar2 default hr_api.g_varchar2
450: ,p_duration in number default hr_api.g_number
451: ,p_duration_units in varchar2 default hr_api.g_varchar2
452: ,p_contractual_job_title in varchar2 default hr_api.g_varchar2
453: ,p_parties in varchar2 default hr_api.g_varchar2
454: ,p_start_reason in varchar2 default hr_api.g_varchar2
455: ,p_end_reason in varchar2 default hr_api.g_varchar2
448: ,p_doc_status_change_date in date default hr_api.g_date
449: ,p_description in varchar2 default hr_api.g_varchar2
450: ,p_duration in number default hr_api.g_number
451: ,p_duration_units in varchar2 default hr_api.g_varchar2
452: ,p_contractual_job_title in varchar2 default hr_api.g_varchar2
453: ,p_parties in varchar2 default hr_api.g_varchar2
454: ,p_start_reason in varchar2 default hr_api.g_varchar2
455: ,p_end_reason in varchar2 default hr_api.g_varchar2
456: ,p_number_of_extensions in number default hr_api.g_number
449: ,p_description in varchar2 default hr_api.g_varchar2
450: ,p_duration in number default hr_api.g_number
451: ,p_duration_units in varchar2 default hr_api.g_varchar2
452: ,p_contractual_job_title in varchar2 default hr_api.g_varchar2
453: ,p_parties in varchar2 default hr_api.g_varchar2
454: ,p_start_reason in varchar2 default hr_api.g_varchar2
455: ,p_end_reason in varchar2 default hr_api.g_varchar2
456: ,p_number_of_extensions in number default hr_api.g_number
457: ,p_extension_reason in varchar2 default hr_api.g_varchar2
450: ,p_duration in number default hr_api.g_number
451: ,p_duration_units in varchar2 default hr_api.g_varchar2
452: ,p_contractual_job_title in varchar2 default hr_api.g_varchar2
453: ,p_parties in varchar2 default hr_api.g_varchar2
454: ,p_start_reason in varchar2 default hr_api.g_varchar2
455: ,p_end_reason in varchar2 default hr_api.g_varchar2
456: ,p_number_of_extensions in number default hr_api.g_number
457: ,p_extension_reason in varchar2 default hr_api.g_varchar2
458: ,p_extension_period in number default hr_api.g_number
451: ,p_duration_units in varchar2 default hr_api.g_varchar2
452: ,p_contractual_job_title in varchar2 default hr_api.g_varchar2
453: ,p_parties in varchar2 default hr_api.g_varchar2
454: ,p_start_reason in varchar2 default hr_api.g_varchar2
455: ,p_end_reason in varchar2 default hr_api.g_varchar2
456: ,p_number_of_extensions in number default hr_api.g_number
457: ,p_extension_reason in varchar2 default hr_api.g_varchar2
458: ,p_extension_period in number default hr_api.g_number
459: ,p_extension_period_units in varchar2 default hr_api.g_varchar2
452: ,p_contractual_job_title in varchar2 default hr_api.g_varchar2
453: ,p_parties in varchar2 default hr_api.g_varchar2
454: ,p_start_reason in varchar2 default hr_api.g_varchar2
455: ,p_end_reason in varchar2 default hr_api.g_varchar2
456: ,p_number_of_extensions in number default hr_api.g_number
457: ,p_extension_reason in varchar2 default hr_api.g_varchar2
458: ,p_extension_period in number default hr_api.g_number
459: ,p_extension_period_units in varchar2 default hr_api.g_varchar2
460: ,p_ctr_information_category in varchar2 default hr_api.g_varchar2
453: ,p_parties in varchar2 default hr_api.g_varchar2
454: ,p_start_reason in varchar2 default hr_api.g_varchar2
455: ,p_end_reason in varchar2 default hr_api.g_varchar2
456: ,p_number_of_extensions in number default hr_api.g_number
457: ,p_extension_reason in varchar2 default hr_api.g_varchar2
458: ,p_extension_period in number default hr_api.g_number
459: ,p_extension_period_units in varchar2 default hr_api.g_varchar2
460: ,p_ctr_information_category in varchar2 default hr_api.g_varchar2
461: ,p_ctr_information1 in varchar2 default hr_api.g_varchar2
454: ,p_start_reason in varchar2 default hr_api.g_varchar2
455: ,p_end_reason in varchar2 default hr_api.g_varchar2
456: ,p_number_of_extensions in number default hr_api.g_number
457: ,p_extension_reason in varchar2 default hr_api.g_varchar2
458: ,p_extension_period in number default hr_api.g_number
459: ,p_extension_period_units in varchar2 default hr_api.g_varchar2
460: ,p_ctr_information_category in varchar2 default hr_api.g_varchar2
461: ,p_ctr_information1 in varchar2 default hr_api.g_varchar2
462: ,p_ctr_information2 in varchar2 default hr_api.g_varchar2
455: ,p_end_reason in varchar2 default hr_api.g_varchar2
456: ,p_number_of_extensions in number default hr_api.g_number
457: ,p_extension_reason in varchar2 default hr_api.g_varchar2
458: ,p_extension_period in number default hr_api.g_number
459: ,p_extension_period_units in varchar2 default hr_api.g_varchar2
460: ,p_ctr_information_category in varchar2 default hr_api.g_varchar2
461: ,p_ctr_information1 in varchar2 default hr_api.g_varchar2
462: ,p_ctr_information2 in varchar2 default hr_api.g_varchar2
463: ,p_ctr_information3 in varchar2 default hr_api.g_varchar2
456: ,p_number_of_extensions in number default hr_api.g_number
457: ,p_extension_reason in varchar2 default hr_api.g_varchar2
458: ,p_extension_period in number default hr_api.g_number
459: ,p_extension_period_units in varchar2 default hr_api.g_varchar2
460: ,p_ctr_information_category in varchar2 default hr_api.g_varchar2
461: ,p_ctr_information1 in varchar2 default hr_api.g_varchar2
462: ,p_ctr_information2 in varchar2 default hr_api.g_varchar2
463: ,p_ctr_information3 in varchar2 default hr_api.g_varchar2
464: ,p_ctr_information4 in varchar2 default hr_api.g_varchar2
457: ,p_extension_reason in varchar2 default hr_api.g_varchar2
458: ,p_extension_period in number default hr_api.g_number
459: ,p_extension_period_units in varchar2 default hr_api.g_varchar2
460: ,p_ctr_information_category in varchar2 default hr_api.g_varchar2
461: ,p_ctr_information1 in varchar2 default hr_api.g_varchar2
462: ,p_ctr_information2 in varchar2 default hr_api.g_varchar2
463: ,p_ctr_information3 in varchar2 default hr_api.g_varchar2
464: ,p_ctr_information4 in varchar2 default hr_api.g_varchar2
465: ,p_ctr_information5 in varchar2 default hr_api.g_varchar2
458: ,p_extension_period in number default hr_api.g_number
459: ,p_extension_period_units in varchar2 default hr_api.g_varchar2
460: ,p_ctr_information_category in varchar2 default hr_api.g_varchar2
461: ,p_ctr_information1 in varchar2 default hr_api.g_varchar2
462: ,p_ctr_information2 in varchar2 default hr_api.g_varchar2
463: ,p_ctr_information3 in varchar2 default hr_api.g_varchar2
464: ,p_ctr_information4 in varchar2 default hr_api.g_varchar2
465: ,p_ctr_information5 in varchar2 default hr_api.g_varchar2
466: ,p_ctr_information6 in varchar2 default hr_api.g_varchar2
459: ,p_extension_period_units in varchar2 default hr_api.g_varchar2
460: ,p_ctr_information_category in varchar2 default hr_api.g_varchar2
461: ,p_ctr_information1 in varchar2 default hr_api.g_varchar2
462: ,p_ctr_information2 in varchar2 default hr_api.g_varchar2
463: ,p_ctr_information3 in varchar2 default hr_api.g_varchar2
464: ,p_ctr_information4 in varchar2 default hr_api.g_varchar2
465: ,p_ctr_information5 in varchar2 default hr_api.g_varchar2
466: ,p_ctr_information6 in varchar2 default hr_api.g_varchar2
467: ,p_ctr_information7 in varchar2 default hr_api.g_varchar2
460: ,p_ctr_information_category in varchar2 default hr_api.g_varchar2
461: ,p_ctr_information1 in varchar2 default hr_api.g_varchar2
462: ,p_ctr_information2 in varchar2 default hr_api.g_varchar2
463: ,p_ctr_information3 in varchar2 default hr_api.g_varchar2
464: ,p_ctr_information4 in varchar2 default hr_api.g_varchar2
465: ,p_ctr_information5 in varchar2 default hr_api.g_varchar2
466: ,p_ctr_information6 in varchar2 default hr_api.g_varchar2
467: ,p_ctr_information7 in varchar2 default hr_api.g_varchar2
468: ,p_ctr_information8 in varchar2 default hr_api.g_varchar2
461: ,p_ctr_information1 in varchar2 default hr_api.g_varchar2
462: ,p_ctr_information2 in varchar2 default hr_api.g_varchar2
463: ,p_ctr_information3 in varchar2 default hr_api.g_varchar2
464: ,p_ctr_information4 in varchar2 default hr_api.g_varchar2
465: ,p_ctr_information5 in varchar2 default hr_api.g_varchar2
466: ,p_ctr_information6 in varchar2 default hr_api.g_varchar2
467: ,p_ctr_information7 in varchar2 default hr_api.g_varchar2
468: ,p_ctr_information8 in varchar2 default hr_api.g_varchar2
469: ,p_ctr_information9 in varchar2 default hr_api.g_varchar2
462: ,p_ctr_information2 in varchar2 default hr_api.g_varchar2
463: ,p_ctr_information3 in varchar2 default hr_api.g_varchar2
464: ,p_ctr_information4 in varchar2 default hr_api.g_varchar2
465: ,p_ctr_information5 in varchar2 default hr_api.g_varchar2
466: ,p_ctr_information6 in varchar2 default hr_api.g_varchar2
467: ,p_ctr_information7 in varchar2 default hr_api.g_varchar2
468: ,p_ctr_information8 in varchar2 default hr_api.g_varchar2
469: ,p_ctr_information9 in varchar2 default hr_api.g_varchar2
470: ,p_ctr_information10 in varchar2 default hr_api.g_varchar2
463: ,p_ctr_information3 in varchar2 default hr_api.g_varchar2
464: ,p_ctr_information4 in varchar2 default hr_api.g_varchar2
465: ,p_ctr_information5 in varchar2 default hr_api.g_varchar2
466: ,p_ctr_information6 in varchar2 default hr_api.g_varchar2
467: ,p_ctr_information7 in varchar2 default hr_api.g_varchar2
468: ,p_ctr_information8 in varchar2 default hr_api.g_varchar2
469: ,p_ctr_information9 in varchar2 default hr_api.g_varchar2
470: ,p_ctr_information10 in varchar2 default hr_api.g_varchar2
471: ,p_ctr_information11 in varchar2 default hr_api.g_varchar2
464: ,p_ctr_information4 in varchar2 default hr_api.g_varchar2
465: ,p_ctr_information5 in varchar2 default hr_api.g_varchar2
466: ,p_ctr_information6 in varchar2 default hr_api.g_varchar2
467: ,p_ctr_information7 in varchar2 default hr_api.g_varchar2
468: ,p_ctr_information8 in varchar2 default hr_api.g_varchar2
469: ,p_ctr_information9 in varchar2 default hr_api.g_varchar2
470: ,p_ctr_information10 in varchar2 default hr_api.g_varchar2
471: ,p_ctr_information11 in varchar2 default hr_api.g_varchar2
472: ,p_ctr_information12 in varchar2 default hr_api.g_varchar2
465: ,p_ctr_information5 in varchar2 default hr_api.g_varchar2
466: ,p_ctr_information6 in varchar2 default hr_api.g_varchar2
467: ,p_ctr_information7 in varchar2 default hr_api.g_varchar2
468: ,p_ctr_information8 in varchar2 default hr_api.g_varchar2
469: ,p_ctr_information9 in varchar2 default hr_api.g_varchar2
470: ,p_ctr_information10 in varchar2 default hr_api.g_varchar2
471: ,p_ctr_information11 in varchar2 default hr_api.g_varchar2
472: ,p_ctr_information12 in varchar2 default hr_api.g_varchar2
473: ,p_ctr_information13 in varchar2 default hr_api.g_varchar2
466: ,p_ctr_information6 in varchar2 default hr_api.g_varchar2
467: ,p_ctr_information7 in varchar2 default hr_api.g_varchar2
468: ,p_ctr_information8 in varchar2 default hr_api.g_varchar2
469: ,p_ctr_information9 in varchar2 default hr_api.g_varchar2
470: ,p_ctr_information10 in varchar2 default hr_api.g_varchar2
471: ,p_ctr_information11 in varchar2 default hr_api.g_varchar2
472: ,p_ctr_information12 in varchar2 default hr_api.g_varchar2
473: ,p_ctr_information13 in varchar2 default hr_api.g_varchar2
474: ,p_ctr_information14 in varchar2 default hr_api.g_varchar2
467: ,p_ctr_information7 in varchar2 default hr_api.g_varchar2
468: ,p_ctr_information8 in varchar2 default hr_api.g_varchar2
469: ,p_ctr_information9 in varchar2 default hr_api.g_varchar2
470: ,p_ctr_information10 in varchar2 default hr_api.g_varchar2
471: ,p_ctr_information11 in varchar2 default hr_api.g_varchar2
472: ,p_ctr_information12 in varchar2 default hr_api.g_varchar2
473: ,p_ctr_information13 in varchar2 default hr_api.g_varchar2
474: ,p_ctr_information14 in varchar2 default hr_api.g_varchar2
475: ,p_ctr_information15 in varchar2 default hr_api.g_varchar2
468: ,p_ctr_information8 in varchar2 default hr_api.g_varchar2
469: ,p_ctr_information9 in varchar2 default hr_api.g_varchar2
470: ,p_ctr_information10 in varchar2 default hr_api.g_varchar2
471: ,p_ctr_information11 in varchar2 default hr_api.g_varchar2
472: ,p_ctr_information12 in varchar2 default hr_api.g_varchar2
473: ,p_ctr_information13 in varchar2 default hr_api.g_varchar2
474: ,p_ctr_information14 in varchar2 default hr_api.g_varchar2
475: ,p_ctr_information15 in varchar2 default hr_api.g_varchar2
476: ,p_ctr_information16 in varchar2 default hr_api.g_varchar2
469: ,p_ctr_information9 in varchar2 default hr_api.g_varchar2
470: ,p_ctr_information10 in varchar2 default hr_api.g_varchar2
471: ,p_ctr_information11 in varchar2 default hr_api.g_varchar2
472: ,p_ctr_information12 in varchar2 default hr_api.g_varchar2
473: ,p_ctr_information13 in varchar2 default hr_api.g_varchar2
474: ,p_ctr_information14 in varchar2 default hr_api.g_varchar2
475: ,p_ctr_information15 in varchar2 default hr_api.g_varchar2
476: ,p_ctr_information16 in varchar2 default hr_api.g_varchar2
477: ,p_ctr_information17 in varchar2 default hr_api.g_varchar2
470: ,p_ctr_information10 in varchar2 default hr_api.g_varchar2
471: ,p_ctr_information11 in varchar2 default hr_api.g_varchar2
472: ,p_ctr_information12 in varchar2 default hr_api.g_varchar2
473: ,p_ctr_information13 in varchar2 default hr_api.g_varchar2
474: ,p_ctr_information14 in varchar2 default hr_api.g_varchar2
475: ,p_ctr_information15 in varchar2 default hr_api.g_varchar2
476: ,p_ctr_information16 in varchar2 default hr_api.g_varchar2
477: ,p_ctr_information17 in varchar2 default hr_api.g_varchar2
478: ,p_ctr_information18 in varchar2 default hr_api.g_varchar2
471: ,p_ctr_information11 in varchar2 default hr_api.g_varchar2
472: ,p_ctr_information12 in varchar2 default hr_api.g_varchar2
473: ,p_ctr_information13 in varchar2 default hr_api.g_varchar2
474: ,p_ctr_information14 in varchar2 default hr_api.g_varchar2
475: ,p_ctr_information15 in varchar2 default hr_api.g_varchar2
476: ,p_ctr_information16 in varchar2 default hr_api.g_varchar2
477: ,p_ctr_information17 in varchar2 default hr_api.g_varchar2
478: ,p_ctr_information18 in varchar2 default hr_api.g_varchar2
479: ,p_ctr_information19 in varchar2 default hr_api.g_varchar2
472: ,p_ctr_information12 in varchar2 default hr_api.g_varchar2
473: ,p_ctr_information13 in varchar2 default hr_api.g_varchar2
474: ,p_ctr_information14 in varchar2 default hr_api.g_varchar2
475: ,p_ctr_information15 in varchar2 default hr_api.g_varchar2
476: ,p_ctr_information16 in varchar2 default hr_api.g_varchar2
477: ,p_ctr_information17 in varchar2 default hr_api.g_varchar2
478: ,p_ctr_information18 in varchar2 default hr_api.g_varchar2
479: ,p_ctr_information19 in varchar2 default hr_api.g_varchar2
480: ,p_ctr_information20 in varchar2 default hr_api.g_varchar2
473: ,p_ctr_information13 in varchar2 default hr_api.g_varchar2
474: ,p_ctr_information14 in varchar2 default hr_api.g_varchar2
475: ,p_ctr_information15 in varchar2 default hr_api.g_varchar2
476: ,p_ctr_information16 in varchar2 default hr_api.g_varchar2
477: ,p_ctr_information17 in varchar2 default hr_api.g_varchar2
478: ,p_ctr_information18 in varchar2 default hr_api.g_varchar2
479: ,p_ctr_information19 in varchar2 default hr_api.g_varchar2
480: ,p_ctr_information20 in varchar2 default hr_api.g_varchar2
481: ,p_attribute_category in varchar2 default hr_api.g_varchar2
474: ,p_ctr_information14 in varchar2 default hr_api.g_varchar2
475: ,p_ctr_information15 in varchar2 default hr_api.g_varchar2
476: ,p_ctr_information16 in varchar2 default hr_api.g_varchar2
477: ,p_ctr_information17 in varchar2 default hr_api.g_varchar2
478: ,p_ctr_information18 in varchar2 default hr_api.g_varchar2
479: ,p_ctr_information19 in varchar2 default hr_api.g_varchar2
480: ,p_ctr_information20 in varchar2 default hr_api.g_varchar2
481: ,p_attribute_category in varchar2 default hr_api.g_varchar2
482: ,p_attribute1 in varchar2 default hr_api.g_varchar2
475: ,p_ctr_information15 in varchar2 default hr_api.g_varchar2
476: ,p_ctr_information16 in varchar2 default hr_api.g_varchar2
477: ,p_ctr_information17 in varchar2 default hr_api.g_varchar2
478: ,p_ctr_information18 in varchar2 default hr_api.g_varchar2
479: ,p_ctr_information19 in varchar2 default hr_api.g_varchar2
480: ,p_ctr_information20 in varchar2 default hr_api.g_varchar2
481: ,p_attribute_category in varchar2 default hr_api.g_varchar2
482: ,p_attribute1 in varchar2 default hr_api.g_varchar2
483: ,p_attribute2 in varchar2 default hr_api.g_varchar2
476: ,p_ctr_information16 in varchar2 default hr_api.g_varchar2
477: ,p_ctr_information17 in varchar2 default hr_api.g_varchar2
478: ,p_ctr_information18 in varchar2 default hr_api.g_varchar2
479: ,p_ctr_information19 in varchar2 default hr_api.g_varchar2
480: ,p_ctr_information20 in varchar2 default hr_api.g_varchar2
481: ,p_attribute_category in varchar2 default hr_api.g_varchar2
482: ,p_attribute1 in varchar2 default hr_api.g_varchar2
483: ,p_attribute2 in varchar2 default hr_api.g_varchar2
484: ,p_attribute3 in varchar2 default hr_api.g_varchar2
477: ,p_ctr_information17 in varchar2 default hr_api.g_varchar2
478: ,p_ctr_information18 in varchar2 default hr_api.g_varchar2
479: ,p_ctr_information19 in varchar2 default hr_api.g_varchar2
480: ,p_ctr_information20 in varchar2 default hr_api.g_varchar2
481: ,p_attribute_category in varchar2 default hr_api.g_varchar2
482: ,p_attribute1 in varchar2 default hr_api.g_varchar2
483: ,p_attribute2 in varchar2 default hr_api.g_varchar2
484: ,p_attribute3 in varchar2 default hr_api.g_varchar2
485: ,p_attribute4 in varchar2 default hr_api.g_varchar2
478: ,p_ctr_information18 in varchar2 default hr_api.g_varchar2
479: ,p_ctr_information19 in varchar2 default hr_api.g_varchar2
480: ,p_ctr_information20 in varchar2 default hr_api.g_varchar2
481: ,p_attribute_category in varchar2 default hr_api.g_varchar2
482: ,p_attribute1 in varchar2 default hr_api.g_varchar2
483: ,p_attribute2 in varchar2 default hr_api.g_varchar2
484: ,p_attribute3 in varchar2 default hr_api.g_varchar2
485: ,p_attribute4 in varchar2 default hr_api.g_varchar2
486: ,p_attribute5 in varchar2 default hr_api.g_varchar2
479: ,p_ctr_information19 in varchar2 default hr_api.g_varchar2
480: ,p_ctr_information20 in varchar2 default hr_api.g_varchar2
481: ,p_attribute_category in varchar2 default hr_api.g_varchar2
482: ,p_attribute1 in varchar2 default hr_api.g_varchar2
483: ,p_attribute2 in varchar2 default hr_api.g_varchar2
484: ,p_attribute3 in varchar2 default hr_api.g_varchar2
485: ,p_attribute4 in varchar2 default hr_api.g_varchar2
486: ,p_attribute5 in varchar2 default hr_api.g_varchar2
487: ,p_attribute6 in varchar2 default hr_api.g_varchar2
480: ,p_ctr_information20 in varchar2 default hr_api.g_varchar2
481: ,p_attribute_category in varchar2 default hr_api.g_varchar2
482: ,p_attribute1 in varchar2 default hr_api.g_varchar2
483: ,p_attribute2 in varchar2 default hr_api.g_varchar2
484: ,p_attribute3 in varchar2 default hr_api.g_varchar2
485: ,p_attribute4 in varchar2 default hr_api.g_varchar2
486: ,p_attribute5 in varchar2 default hr_api.g_varchar2
487: ,p_attribute6 in varchar2 default hr_api.g_varchar2
488: ,p_attribute7 in varchar2 default hr_api.g_varchar2
481: ,p_attribute_category in varchar2 default hr_api.g_varchar2
482: ,p_attribute1 in varchar2 default hr_api.g_varchar2
483: ,p_attribute2 in varchar2 default hr_api.g_varchar2
484: ,p_attribute3 in varchar2 default hr_api.g_varchar2
485: ,p_attribute4 in varchar2 default hr_api.g_varchar2
486: ,p_attribute5 in varchar2 default hr_api.g_varchar2
487: ,p_attribute6 in varchar2 default hr_api.g_varchar2
488: ,p_attribute7 in varchar2 default hr_api.g_varchar2
489: ,p_attribute8 in varchar2 default hr_api.g_varchar2
482: ,p_attribute1 in varchar2 default hr_api.g_varchar2
483: ,p_attribute2 in varchar2 default hr_api.g_varchar2
484: ,p_attribute3 in varchar2 default hr_api.g_varchar2
485: ,p_attribute4 in varchar2 default hr_api.g_varchar2
486: ,p_attribute5 in varchar2 default hr_api.g_varchar2
487: ,p_attribute6 in varchar2 default hr_api.g_varchar2
488: ,p_attribute7 in varchar2 default hr_api.g_varchar2
489: ,p_attribute8 in varchar2 default hr_api.g_varchar2
490: ,p_attribute9 in varchar2 default hr_api.g_varchar2
483: ,p_attribute2 in varchar2 default hr_api.g_varchar2
484: ,p_attribute3 in varchar2 default hr_api.g_varchar2
485: ,p_attribute4 in varchar2 default hr_api.g_varchar2
486: ,p_attribute5 in varchar2 default hr_api.g_varchar2
487: ,p_attribute6 in varchar2 default hr_api.g_varchar2
488: ,p_attribute7 in varchar2 default hr_api.g_varchar2
489: ,p_attribute8 in varchar2 default hr_api.g_varchar2
490: ,p_attribute9 in varchar2 default hr_api.g_varchar2
491: ,p_attribute10 in varchar2 default hr_api.g_varchar2
484: ,p_attribute3 in varchar2 default hr_api.g_varchar2
485: ,p_attribute4 in varchar2 default hr_api.g_varchar2
486: ,p_attribute5 in varchar2 default hr_api.g_varchar2
487: ,p_attribute6 in varchar2 default hr_api.g_varchar2
488: ,p_attribute7 in varchar2 default hr_api.g_varchar2
489: ,p_attribute8 in varchar2 default hr_api.g_varchar2
490: ,p_attribute9 in varchar2 default hr_api.g_varchar2
491: ,p_attribute10 in varchar2 default hr_api.g_varchar2
492: ,p_attribute11 in varchar2 default hr_api.g_varchar2
485: ,p_attribute4 in varchar2 default hr_api.g_varchar2
486: ,p_attribute5 in varchar2 default hr_api.g_varchar2
487: ,p_attribute6 in varchar2 default hr_api.g_varchar2
488: ,p_attribute7 in varchar2 default hr_api.g_varchar2
489: ,p_attribute8 in varchar2 default hr_api.g_varchar2
490: ,p_attribute9 in varchar2 default hr_api.g_varchar2
491: ,p_attribute10 in varchar2 default hr_api.g_varchar2
492: ,p_attribute11 in varchar2 default hr_api.g_varchar2
493: ,p_attribute12 in varchar2 default hr_api.g_varchar2
486: ,p_attribute5 in varchar2 default hr_api.g_varchar2
487: ,p_attribute6 in varchar2 default hr_api.g_varchar2
488: ,p_attribute7 in varchar2 default hr_api.g_varchar2
489: ,p_attribute8 in varchar2 default hr_api.g_varchar2
490: ,p_attribute9 in varchar2 default hr_api.g_varchar2
491: ,p_attribute10 in varchar2 default hr_api.g_varchar2
492: ,p_attribute11 in varchar2 default hr_api.g_varchar2
493: ,p_attribute12 in varchar2 default hr_api.g_varchar2
494: ,p_attribute13 in varchar2 default hr_api.g_varchar2
487: ,p_attribute6 in varchar2 default hr_api.g_varchar2
488: ,p_attribute7 in varchar2 default hr_api.g_varchar2
489: ,p_attribute8 in varchar2 default hr_api.g_varchar2
490: ,p_attribute9 in varchar2 default hr_api.g_varchar2
491: ,p_attribute10 in varchar2 default hr_api.g_varchar2
492: ,p_attribute11 in varchar2 default hr_api.g_varchar2
493: ,p_attribute12 in varchar2 default hr_api.g_varchar2
494: ,p_attribute13 in varchar2 default hr_api.g_varchar2
495: ,p_attribute14 in varchar2 default hr_api.g_varchar2
488: ,p_attribute7 in varchar2 default hr_api.g_varchar2
489: ,p_attribute8 in varchar2 default hr_api.g_varchar2
490: ,p_attribute9 in varchar2 default hr_api.g_varchar2
491: ,p_attribute10 in varchar2 default hr_api.g_varchar2
492: ,p_attribute11 in varchar2 default hr_api.g_varchar2
493: ,p_attribute12 in varchar2 default hr_api.g_varchar2
494: ,p_attribute13 in varchar2 default hr_api.g_varchar2
495: ,p_attribute14 in varchar2 default hr_api.g_varchar2
496: ,p_attribute15 in varchar2 default hr_api.g_varchar2
489: ,p_attribute8 in varchar2 default hr_api.g_varchar2
490: ,p_attribute9 in varchar2 default hr_api.g_varchar2
491: ,p_attribute10 in varchar2 default hr_api.g_varchar2
492: ,p_attribute11 in varchar2 default hr_api.g_varchar2
493: ,p_attribute12 in varchar2 default hr_api.g_varchar2
494: ,p_attribute13 in varchar2 default hr_api.g_varchar2
495: ,p_attribute14 in varchar2 default hr_api.g_varchar2
496: ,p_attribute15 in varchar2 default hr_api.g_varchar2
497: ,p_attribute16 in varchar2 default hr_api.g_varchar2
490: ,p_attribute9 in varchar2 default hr_api.g_varchar2
491: ,p_attribute10 in varchar2 default hr_api.g_varchar2
492: ,p_attribute11 in varchar2 default hr_api.g_varchar2
493: ,p_attribute12 in varchar2 default hr_api.g_varchar2
494: ,p_attribute13 in varchar2 default hr_api.g_varchar2
495: ,p_attribute14 in varchar2 default hr_api.g_varchar2
496: ,p_attribute15 in varchar2 default hr_api.g_varchar2
497: ,p_attribute16 in varchar2 default hr_api.g_varchar2
498: ,p_attribute17 in varchar2 default hr_api.g_varchar2
491: ,p_attribute10 in varchar2 default hr_api.g_varchar2
492: ,p_attribute11 in varchar2 default hr_api.g_varchar2
493: ,p_attribute12 in varchar2 default hr_api.g_varchar2
494: ,p_attribute13 in varchar2 default hr_api.g_varchar2
495: ,p_attribute14 in varchar2 default hr_api.g_varchar2
496: ,p_attribute15 in varchar2 default hr_api.g_varchar2
497: ,p_attribute16 in varchar2 default hr_api.g_varchar2
498: ,p_attribute17 in varchar2 default hr_api.g_varchar2
499: ,p_attribute18 in varchar2 default hr_api.g_varchar2
492: ,p_attribute11 in varchar2 default hr_api.g_varchar2
493: ,p_attribute12 in varchar2 default hr_api.g_varchar2
494: ,p_attribute13 in varchar2 default hr_api.g_varchar2
495: ,p_attribute14 in varchar2 default hr_api.g_varchar2
496: ,p_attribute15 in varchar2 default hr_api.g_varchar2
497: ,p_attribute16 in varchar2 default hr_api.g_varchar2
498: ,p_attribute17 in varchar2 default hr_api.g_varchar2
499: ,p_attribute18 in varchar2 default hr_api.g_varchar2
500: ,p_attribute19 in varchar2 default hr_api.g_varchar2
493: ,p_attribute12 in varchar2 default hr_api.g_varchar2
494: ,p_attribute13 in varchar2 default hr_api.g_varchar2
495: ,p_attribute14 in varchar2 default hr_api.g_varchar2
496: ,p_attribute15 in varchar2 default hr_api.g_varchar2
497: ,p_attribute16 in varchar2 default hr_api.g_varchar2
498: ,p_attribute17 in varchar2 default hr_api.g_varchar2
499: ,p_attribute18 in varchar2 default hr_api.g_varchar2
500: ,p_attribute19 in varchar2 default hr_api.g_varchar2
501: ,p_attribute20 in varchar2 default hr_api.g_varchar2
494: ,p_attribute13 in varchar2 default hr_api.g_varchar2
495: ,p_attribute14 in varchar2 default hr_api.g_varchar2
496: ,p_attribute15 in varchar2 default hr_api.g_varchar2
497: ,p_attribute16 in varchar2 default hr_api.g_varchar2
498: ,p_attribute17 in varchar2 default hr_api.g_varchar2
499: ,p_attribute18 in varchar2 default hr_api.g_varchar2
500: ,p_attribute19 in varchar2 default hr_api.g_varchar2
501: ,p_attribute20 in varchar2 default hr_api.g_varchar2
502: ,p_effective_date in date
495: ,p_attribute14 in varchar2 default hr_api.g_varchar2
496: ,p_attribute15 in varchar2 default hr_api.g_varchar2
497: ,p_attribute16 in varchar2 default hr_api.g_varchar2
498: ,p_attribute17 in varchar2 default hr_api.g_varchar2
499: ,p_attribute18 in varchar2 default hr_api.g_varchar2
500: ,p_attribute19 in varchar2 default hr_api.g_varchar2
501: ,p_attribute20 in varchar2 default hr_api.g_varchar2
502: ,p_effective_date in date
503: ,p_datetrack_mode in varchar2
496: ,p_attribute15 in varchar2 default hr_api.g_varchar2
497: ,p_attribute16 in varchar2 default hr_api.g_varchar2
498: ,p_attribute17 in varchar2 default hr_api.g_varchar2
499: ,p_attribute18 in varchar2 default hr_api.g_varchar2
500: ,p_attribute19 in varchar2 default hr_api.g_varchar2
501: ,p_attribute20 in varchar2 default hr_api.g_varchar2
502: ,p_effective_date in date
503: ,p_datetrack_mode in varchar2
504: ) is
497: ,p_attribute16 in varchar2 default hr_api.g_varchar2
498: ,p_attribute17 in varchar2 default hr_api.g_varchar2
499: ,p_attribute18 in varchar2 default hr_api.g_varchar2
500: ,p_attribute19 in varchar2 default hr_api.g_varchar2
501: ,p_attribute20 in varchar2 default hr_api.g_varchar2
502: ,p_effective_date in date
503: ,p_datetrack_mode in varchar2
504: ) is
505: --
622: ,p_effective_date => trunc(p_effective_date)
623: ,p_datetrack_mode => p_datetrack_mode
624: );
625: exception
626: when hr_api.cannot_find_prog_unit then
627: hr_api.cannot_find_prog_unit_error
628: (p_module_name => 'UPDATE_contract'
629: ,p_hook_type => 'BP'
630: );
623: ,p_datetrack_mode => p_datetrack_mode
624: );
625: exception
626: when hr_api.cannot_find_prog_unit then
627: hr_api.cannot_find_prog_unit_error
628: (p_module_name => 'UPDATE_contract'
629: ,p_hook_type => 'BP'
630: );
631: --
633: --
634: end;
635: --
636: -- Validation in addition to Table Handlers
637: hr_api.mandatory_arg_error
638: (p_api_name => l_proc
639: ,p_argument => 'person_id'
640: ,p_argument_value => p_person_id
641: );
639: ,p_argument => 'person_id'
640: ,p_argument_value => p_person_id
641: );
642: --
643: hr_api.mandatory_arg_error
644: (p_api_name => l_proc
645: ,p_argument => 'effective_date'
646: ,p_argument_value => p_effective_date
647: );
789: ,p_effective_date => trunc(p_effective_date)
790: ,p_datetrack_mode => p_datetrack_mode
791: );
792: exception
793: when hr_api.cannot_find_prog_unit then
794: hr_api.cannot_find_prog_unit_error
795: (p_module_name => 'UPDATE_contract'
796: ,p_hook_type => 'AP'
797: );
790: ,p_datetrack_mode => p_datetrack_mode
791: );
792: exception
793: when hr_api.cannot_find_prog_unit then
794: hr_api.cannot_find_prog_unit_error
795: (p_module_name => 'UPDATE_contract'
796: ,p_hook_type => 'AP'
797: );
798: --
804: --
805: -- When in validation only mode raise the Validate_Enabled exception
806: --
807: if p_validate then
808: raise hr_api.validate_enabled;
809: end if;
810: --
811: -- Set all output arguments
812: --
817: hr_utility.set_location(' Leaving:'||l_proc, 70);
818: --
819: exception
820: --
821: when hr_api.validate_enabled then
822: --
823: -- As the Validate_Enabled exception has been raised
824: -- we must rollback to the savepoint
825: --
897: ,p_effective_date => trunc(p_effective_date)
898: ,p_datetrack_mode => p_datetrack_mode
899: );
900: exception
901: when hr_api.cannot_find_prog_unit then
902: hr_api.cannot_find_prog_unit_error
903: (p_module_name => 'DELETE_contract'
904: ,p_hook_type => 'BP'
905: );
898: ,p_datetrack_mode => p_datetrack_mode
899: );
900: exception
901: when hr_api.cannot_find_prog_unit then
902: hr_api.cannot_find_prog_unit_error
903: (p_module_name => 'DELETE_contract'
904: ,p_hook_type => 'BP'
905: );
906: --
931: ,p_effective_date => trunc(p_effective_date)
932: ,p_datetrack_mode => p_datetrack_mode
933: );
934: exception
935: when hr_api.cannot_find_prog_unit then
936: hr_api.cannot_find_prog_unit_error
937: (p_module_name => 'DELETE_CONTRACT'
938: ,p_hook_type => 'AP'
939: );
932: ,p_datetrack_mode => p_datetrack_mode
933: );
934: exception
935: when hr_api.cannot_find_prog_unit then
936: hr_api.cannot_find_prog_unit_error
937: (p_module_name => 'DELETE_CONTRACT'
938: ,p_hook_type => 'AP'
939: );
940: --
946: --
947: -- When in validation only mode raise the Validate_Enabled exception
948: --
949: if p_validate then
950: raise hr_api.validate_enabled;
951: end if;
952: --
953: hr_utility.set_location(' Leaving:'||l_proc, 70);
954: --
953: hr_utility.set_location(' Leaving:'||l_proc, 70);
954: --
955: exception
956: --
957: when hr_api.validate_enabled then
958: --
959: -- As the Validate_Enabled exception has been raised
960: -- we must rollback to the savepoint
961: --