DBA Data[Home] [Help]

APPS.HR_CONTRACT_API dependencies on HR_API

Line 199: when hr_api.cannot_find_prog_unit then

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'

Line 200: hr_api.cannot_find_prog_unit_error

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: );

Line 212: hr_api.mandatory_arg_error

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: );

Line 218: hr_api.mandatory_arg_error

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: );

Line 372: when hr_api.cannot_find_prog_unit then

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: );

Line 373: hr_api.cannot_find_prog_unit_error

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: --

Line 387: raise hr_api.validate_enabled;

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: --

Line 401: when hr_api.validate_enabled then

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: --

Line 446: ,p_status_reason in varchar2 default hr_api.g_varchar2

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

Line 447: ,p_doc_status in varchar2 default hr_api.g_varchar2

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

Line 448: ,p_doc_status_change_date in date default hr_api.g_date

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

Line 449: ,p_description 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

Line 450: ,p_duration in number default hr_api.g_number

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

Line 451: ,p_duration_units 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

Line 452: ,p_contractual_job_title 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

Line 453: ,p_parties in varchar2 default hr_api.g_varchar2

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

Line 454: ,p_start_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

Line 455: ,p_end_reason in varchar2 default hr_api.g_varchar2

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

Line 456: ,p_number_of_extensions in number default hr_api.g_number

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

Line 457: ,p_extension_reason 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

Line 458: ,p_extension_period in number default hr_api.g_number

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

Line 459: ,p_extension_period_units 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

Line 460: ,p_ctr_information_category 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

Line 461: ,p_ctr_information1 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

Line 462: ,p_ctr_information2 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

Line 463: ,p_ctr_information3 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

Line 464: ,p_ctr_information4 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

Line 465: ,p_ctr_information5 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

Line 466: ,p_ctr_information6 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

Line 467: ,p_ctr_information7 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

Line 468: ,p_ctr_information8 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

Line 469: ,p_ctr_information9 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

Line 470: ,p_ctr_information10 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

Line 471: ,p_ctr_information11 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

Line 472: ,p_ctr_information12 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

Line 473: ,p_ctr_information13 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

Line 474: ,p_ctr_information14 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

Line 475: ,p_ctr_information15 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

Line 476: ,p_ctr_information16 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

Line 477: ,p_ctr_information17 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

Line 478: ,p_ctr_information18 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

Line 479: ,p_ctr_information19 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

Line 480: ,p_ctr_information20 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

Line 481: ,p_attribute_category 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

Line 482: ,p_attribute1 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

Line 483: ,p_attribute2 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

Line 484: ,p_attribute3 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

Line 485: ,p_attribute4 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

Line 486: ,p_attribute5 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

Line 487: ,p_attribute6 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

Line 488: ,p_attribute7 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

Line 489: ,p_attribute8 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

Line 490: ,p_attribute9 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

Line 491: ,p_attribute10 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

Line 492: ,p_attribute11 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

Line 493: ,p_attribute12 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

Line 494: ,p_attribute13 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

Line 495: ,p_attribute14 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

Line 496: ,p_attribute15 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

Line 497: ,p_attribute16 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

Line 498: ,p_attribute17 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

Line 499: ,p_attribute18 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
503: ,p_datetrack_mode in varchar2

Line 500: ,p_attribute19 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
504: ) is

Line 501: ,p_attribute20 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
505: --

Line 626: when hr_api.cannot_find_prog_unit then

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: );

Line 627: hr_api.cannot_find_prog_unit_error

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: --

Line 637: hr_api.mandatory_arg_error

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: );

Line 643: hr_api.mandatory_arg_error

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: );

Line 793: when hr_api.cannot_find_prog_unit then

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: );

Line 794: hr_api.cannot_find_prog_unit_error

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: --

Line 808: raise hr_api.validate_enabled;

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: --

Line 821: when hr_api.validate_enabled then

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: --

Line 901: when hr_api.cannot_find_prog_unit then

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: );

Line 902: hr_api.cannot_find_prog_unit_error

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: --

Line 935: when hr_api.cannot_find_prog_unit then

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: );

Line 936: hr_api.cannot_find_prog_unit_error

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: --

Line 950: raise hr_api.validate_enabled;

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: --

Line 957: when hr_api.validate_enabled then

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: --