eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_QUALIFICATIONS_API dependencies on HR_API

Line 16: ,p_language_code in varchar2 default hr_api.userenv_lang

12: procedure CREATE_QUALIFICATION
13: (p_validate in boolean default false
14: ,p_effective_date in date
15: ,p_qualification_type_id in number
16: ,p_language_code in varchar2 default hr_api.userenv_lang
17: ,p_business_group_id in number default null
18: ,p_person_id in number default null
19: ,p_title in varchar2 default null
20: ,p_grade_attained in varchar2 default null

Line 125: hr_api.validate_language_code(p_language_code => l_language_code);

121: -- instead of p_language_code from now on, to allow an IN OUT parameter to
122: -- be passed through.
123: --
124: l_language_code := p_language_code;
125: hr_api.validate_language_code(p_language_code => l_language_code);
126:
127: --
128: -- Call Before Process User Hook
129: --

Line 206: when hr_Api.cannot_find_prog_unit then

202: ,p_membership_category => p_membership_category
203: ,p_subscription_payment_method => p_subscription_payment_method
204: ,p_language_code => l_language_code);
205: exception
206: when hr_Api.cannot_find_prog_unit then
207: hr_Api.cannot_find_prog_unit_error
208: (p_module_name => 'CREATE_QUALIFICATION'
209: ,p_hook_type => 'BP'
210: );

Line 207: hr_Api.cannot_find_prog_unit_error

203: ,p_subscription_payment_method => p_subscription_payment_method
204: ,p_language_code => l_language_code);
205: exception
206: when hr_Api.cannot_find_prog_unit then
207: hr_Api.cannot_find_prog_unit_error
208: (p_module_name => 'CREATE_QUALIFICATION'
209: ,p_hook_type => 'BP'
210: );
211: end;

Line 390: when hr_Api.cannot_find_prog_unit then

386: ,p_membership_category => p_membership_category
387: ,p_subscription_payment_method => p_subscription_payment_method
388: ,p_language_code => l_language_code);
389: exception
390: when hr_Api.cannot_find_prog_unit then
391: hr_Api.cannot_find_prog_unit_error
392: (p_module_name => 'CREATE_QUALIFICATION'
393: ,p_hook_type => 'AP'
394: );

Line 391: hr_Api.cannot_find_prog_unit_error

387: ,p_subscription_payment_method => p_subscription_payment_method
388: ,p_language_code => l_language_code);
389: exception
390: when hr_Api.cannot_find_prog_unit then
391: hr_Api.cannot_find_prog_unit_error
392: (p_module_name => 'CREATE_QUALIFICATION'
393: ,p_hook_type => 'AP'
394: );
395: end;

Line 400: raise hr_Api.validate_enabled;

396: --
397: -- When in validation only mode raise the Validate_Enabled exception
398: --
399: if p_validate then
400: raise hr_Api.validate_enabled;
401: end if;
402: --
403: -- Set all output arguments
404: --

Line 410: when hr_Api.validate_enabled then

406: p_object_version_number := l_object_version_number;
407: --
408: hr_utility.set_location(' Leaving:'||l_proc, 70);
409: exception
410: when hr_Api.validate_enabled then
411: --
412: -- As the Validate_Enabled exception has been raised
413: -- we must rollback to the savepoint
414: --

Line 445: ,p_language_code in varchar2 default hr_api.userenv_lang

441: procedure UPDATE_QUALIFICATION
442: (p_validate in boolean default false
443: ,p_effective_date in date
444: ,p_qualification_id in number
445: ,p_language_code in varchar2 default hr_api.userenv_lang
446: ,p_qualification_type_id in number default hr_api.g_number
447: ,p_title in varchar2 default hr_api.g_varchar2
448: ,p_grade_attained in varchar2 default hr_api.g_varchar2
449: ,p_status in varchar2 default hr_api.g_varchar2

Line 446: ,p_qualification_type_id in number default hr_api.g_number

442: (p_validate in boolean default false
443: ,p_effective_date in date
444: ,p_qualification_id in number
445: ,p_language_code in varchar2 default hr_api.userenv_lang
446: ,p_qualification_type_id in number default hr_api.g_number
447: ,p_title in varchar2 default hr_api.g_varchar2
448: ,p_grade_attained in varchar2 default hr_api.g_varchar2
449: ,p_status in varchar2 default hr_api.g_varchar2
450: ,p_awarded_date in date default hr_api.g_date

Line 447: ,p_title in varchar2 default hr_api.g_varchar2

443: ,p_effective_date in date
444: ,p_qualification_id in number
445: ,p_language_code in varchar2 default hr_api.userenv_lang
446: ,p_qualification_type_id in number default hr_api.g_number
447: ,p_title in varchar2 default hr_api.g_varchar2
448: ,p_grade_attained in varchar2 default hr_api.g_varchar2
449: ,p_status in varchar2 default hr_api.g_varchar2
450: ,p_awarded_date in date default hr_api.g_date
451: ,p_fee in number default hr_api.g_number

Line 448: ,p_grade_attained in varchar2 default hr_api.g_varchar2

444: ,p_qualification_id in number
445: ,p_language_code in varchar2 default hr_api.userenv_lang
446: ,p_qualification_type_id in number default hr_api.g_number
447: ,p_title in varchar2 default hr_api.g_varchar2
448: ,p_grade_attained in varchar2 default hr_api.g_varchar2
449: ,p_status in varchar2 default hr_api.g_varchar2
450: ,p_awarded_date in date default hr_api.g_date
451: ,p_fee in number default hr_api.g_number
452: ,p_fee_currency in varchar2 default hr_api.g_varchar2

Line 449: ,p_status in varchar2 default hr_api.g_varchar2

445: ,p_language_code in varchar2 default hr_api.userenv_lang
446: ,p_qualification_type_id in number default hr_api.g_number
447: ,p_title in varchar2 default hr_api.g_varchar2
448: ,p_grade_attained in varchar2 default hr_api.g_varchar2
449: ,p_status in varchar2 default hr_api.g_varchar2
450: ,p_awarded_date in date default hr_api.g_date
451: ,p_fee in number default hr_api.g_number
452: ,p_fee_currency in varchar2 default hr_api.g_varchar2
453: ,p_training_completed_amount in number default hr_api.g_number

Line 450: ,p_awarded_date in date default hr_api.g_date

446: ,p_qualification_type_id in number default hr_api.g_number
447: ,p_title in varchar2 default hr_api.g_varchar2
448: ,p_grade_attained in varchar2 default hr_api.g_varchar2
449: ,p_status in varchar2 default hr_api.g_varchar2
450: ,p_awarded_date in date default hr_api.g_date
451: ,p_fee in number default hr_api.g_number
452: ,p_fee_currency in varchar2 default hr_api.g_varchar2
453: ,p_training_completed_amount in number default hr_api.g_number
454: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2

Line 451: ,p_fee in number default hr_api.g_number

447: ,p_title in varchar2 default hr_api.g_varchar2
448: ,p_grade_attained in varchar2 default hr_api.g_varchar2
449: ,p_status in varchar2 default hr_api.g_varchar2
450: ,p_awarded_date in date default hr_api.g_date
451: ,p_fee in number default hr_api.g_number
452: ,p_fee_currency in varchar2 default hr_api.g_varchar2
453: ,p_training_completed_amount in number default hr_api.g_number
454: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2
455: ,p_training_completed_units in varchar2 default hr_api.g_varchar2

Line 452: ,p_fee_currency in varchar2 default hr_api.g_varchar2

448: ,p_grade_attained in varchar2 default hr_api.g_varchar2
449: ,p_status in varchar2 default hr_api.g_varchar2
450: ,p_awarded_date in date default hr_api.g_date
451: ,p_fee in number default hr_api.g_number
452: ,p_fee_currency in varchar2 default hr_api.g_varchar2
453: ,p_training_completed_amount in number default hr_api.g_number
454: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2
455: ,p_training_completed_units in varchar2 default hr_api.g_varchar2
456: ,p_total_training_amount in number default hr_api.g_number

Line 453: ,p_training_completed_amount in number default hr_api.g_number

449: ,p_status in varchar2 default hr_api.g_varchar2
450: ,p_awarded_date in date default hr_api.g_date
451: ,p_fee in number default hr_api.g_number
452: ,p_fee_currency in varchar2 default hr_api.g_varchar2
453: ,p_training_completed_amount in number default hr_api.g_number
454: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2
455: ,p_training_completed_units in varchar2 default hr_api.g_varchar2
456: ,p_total_training_amount in number default hr_api.g_number
457: ,p_start_date in date default hr_api.g_date

Line 454: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2

450: ,p_awarded_date in date default hr_api.g_date
451: ,p_fee in number default hr_api.g_number
452: ,p_fee_currency in varchar2 default hr_api.g_varchar2
453: ,p_training_completed_amount in number default hr_api.g_number
454: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2
455: ,p_training_completed_units in varchar2 default hr_api.g_varchar2
456: ,p_total_training_amount in number default hr_api.g_number
457: ,p_start_date in date default hr_api.g_date
458: ,p_end_date in date default hr_api.g_date

Line 455: ,p_training_completed_units in varchar2 default hr_api.g_varchar2

451: ,p_fee in number default hr_api.g_number
452: ,p_fee_currency in varchar2 default hr_api.g_varchar2
453: ,p_training_completed_amount in number default hr_api.g_number
454: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2
455: ,p_training_completed_units in varchar2 default hr_api.g_varchar2
456: ,p_total_training_amount in number default hr_api.g_number
457: ,p_start_date in date default hr_api.g_date
458: ,p_end_date in date default hr_api.g_date
459: ,p_license_number in varchar2 default hr_api.g_varchar2

Line 456: ,p_total_training_amount in number default hr_api.g_number

452: ,p_fee_currency in varchar2 default hr_api.g_varchar2
453: ,p_training_completed_amount in number default hr_api.g_number
454: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2
455: ,p_training_completed_units in varchar2 default hr_api.g_varchar2
456: ,p_total_training_amount in number default hr_api.g_number
457: ,p_start_date in date default hr_api.g_date
458: ,p_end_date in date default hr_api.g_date
459: ,p_license_number in varchar2 default hr_api.g_varchar2
460: ,p_expiry_date in date default hr_api.g_date

Line 457: ,p_start_date in date default hr_api.g_date

453: ,p_training_completed_amount in number default hr_api.g_number
454: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2
455: ,p_training_completed_units in varchar2 default hr_api.g_varchar2
456: ,p_total_training_amount in number default hr_api.g_number
457: ,p_start_date in date default hr_api.g_date
458: ,p_end_date in date default hr_api.g_date
459: ,p_license_number in varchar2 default hr_api.g_varchar2
460: ,p_expiry_date in date default hr_api.g_date
461: ,p_license_restrictions in varchar2 default hr_api.g_varchar2

Line 458: ,p_end_date in date default hr_api.g_date

454: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2
455: ,p_training_completed_units in varchar2 default hr_api.g_varchar2
456: ,p_total_training_amount in number default hr_api.g_number
457: ,p_start_date in date default hr_api.g_date
458: ,p_end_date in date default hr_api.g_date
459: ,p_license_number in varchar2 default hr_api.g_varchar2
460: ,p_expiry_date in date default hr_api.g_date
461: ,p_license_restrictions in varchar2 default hr_api.g_varchar2
462: ,p_projected_completion_date in date default hr_api.g_date

Line 459: ,p_license_number in varchar2 default hr_api.g_varchar2

455: ,p_training_completed_units in varchar2 default hr_api.g_varchar2
456: ,p_total_training_amount in number default hr_api.g_number
457: ,p_start_date in date default hr_api.g_date
458: ,p_end_date in date default hr_api.g_date
459: ,p_license_number in varchar2 default hr_api.g_varchar2
460: ,p_expiry_date in date default hr_api.g_date
461: ,p_license_restrictions in varchar2 default hr_api.g_varchar2
462: ,p_projected_completion_date in date default hr_api.g_date
463: ,p_awarding_body in varchar2 default hr_api.g_varchar2

Line 460: ,p_expiry_date in date default hr_api.g_date

456: ,p_total_training_amount in number default hr_api.g_number
457: ,p_start_date in date default hr_api.g_date
458: ,p_end_date in date default hr_api.g_date
459: ,p_license_number in varchar2 default hr_api.g_varchar2
460: ,p_expiry_date in date default hr_api.g_date
461: ,p_license_restrictions in varchar2 default hr_api.g_varchar2
462: ,p_projected_completion_date in date default hr_api.g_date
463: ,p_awarding_body in varchar2 default hr_api.g_varchar2
464: ,p_tuition_method in varchar2 default hr_api.g_varchar2

Line 461: ,p_license_restrictions in varchar2 default hr_api.g_varchar2

457: ,p_start_date in date default hr_api.g_date
458: ,p_end_date in date default hr_api.g_date
459: ,p_license_number in varchar2 default hr_api.g_varchar2
460: ,p_expiry_date in date default hr_api.g_date
461: ,p_license_restrictions in varchar2 default hr_api.g_varchar2
462: ,p_projected_completion_date in date default hr_api.g_date
463: ,p_awarding_body in varchar2 default hr_api.g_varchar2
464: ,p_tuition_method in varchar2 default hr_api.g_varchar2
465: ,p_group_ranking in varchar2 default hr_api.g_varchar2

Line 462: ,p_projected_completion_date in date default hr_api.g_date

458: ,p_end_date in date default hr_api.g_date
459: ,p_license_number in varchar2 default hr_api.g_varchar2
460: ,p_expiry_date in date default hr_api.g_date
461: ,p_license_restrictions in varchar2 default hr_api.g_varchar2
462: ,p_projected_completion_date in date default hr_api.g_date
463: ,p_awarding_body in varchar2 default hr_api.g_varchar2
464: ,p_tuition_method in varchar2 default hr_api.g_varchar2
465: ,p_group_ranking in varchar2 default hr_api.g_varchar2
466: ,p_comments in varchar2 default hr_api.g_varchar2

Line 463: ,p_awarding_body in varchar2 default hr_api.g_varchar2

459: ,p_license_number in varchar2 default hr_api.g_varchar2
460: ,p_expiry_date in date default hr_api.g_date
461: ,p_license_restrictions in varchar2 default hr_api.g_varchar2
462: ,p_projected_completion_date in date default hr_api.g_date
463: ,p_awarding_body in varchar2 default hr_api.g_varchar2
464: ,p_tuition_method in varchar2 default hr_api.g_varchar2
465: ,p_group_ranking in varchar2 default hr_api.g_varchar2
466: ,p_comments in varchar2 default hr_api.g_varchar2
467: ,p_attendance_id in number default hr_api.g_number

Line 464: ,p_tuition_method in varchar2 default hr_api.g_varchar2

460: ,p_expiry_date in date default hr_api.g_date
461: ,p_license_restrictions in varchar2 default hr_api.g_varchar2
462: ,p_projected_completion_date in date default hr_api.g_date
463: ,p_awarding_body in varchar2 default hr_api.g_varchar2
464: ,p_tuition_method in varchar2 default hr_api.g_varchar2
465: ,p_group_ranking in varchar2 default hr_api.g_varchar2
466: ,p_comments in varchar2 default hr_api.g_varchar2
467: ,p_attendance_id in number default hr_api.g_number
468: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 465: ,p_group_ranking in varchar2 default hr_api.g_varchar2

461: ,p_license_restrictions in varchar2 default hr_api.g_varchar2
462: ,p_projected_completion_date in date default hr_api.g_date
463: ,p_awarding_body in varchar2 default hr_api.g_varchar2
464: ,p_tuition_method in varchar2 default hr_api.g_varchar2
465: ,p_group_ranking in varchar2 default hr_api.g_varchar2
466: ,p_comments in varchar2 default hr_api.g_varchar2
467: ,p_attendance_id in number default hr_api.g_number
468: ,p_attribute_category in varchar2 default hr_api.g_varchar2
469: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 466: ,p_comments in varchar2 default hr_api.g_varchar2

462: ,p_projected_completion_date in date default hr_api.g_date
463: ,p_awarding_body in varchar2 default hr_api.g_varchar2
464: ,p_tuition_method in varchar2 default hr_api.g_varchar2
465: ,p_group_ranking in varchar2 default hr_api.g_varchar2
466: ,p_comments in varchar2 default hr_api.g_varchar2
467: ,p_attendance_id in number default hr_api.g_number
468: ,p_attribute_category in varchar2 default hr_api.g_varchar2
469: ,p_attribute1 in varchar2 default hr_api.g_varchar2
470: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 467: ,p_attendance_id in number default hr_api.g_number

463: ,p_awarding_body in varchar2 default hr_api.g_varchar2
464: ,p_tuition_method in varchar2 default hr_api.g_varchar2
465: ,p_group_ranking in varchar2 default hr_api.g_varchar2
466: ,p_comments in varchar2 default hr_api.g_varchar2
467: ,p_attendance_id in number default hr_api.g_number
468: ,p_attribute_category in varchar2 default hr_api.g_varchar2
469: ,p_attribute1 in varchar2 default hr_api.g_varchar2
470: ,p_attribute2 in varchar2 default hr_api.g_varchar2
471: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 468: ,p_attribute_category in varchar2 default hr_api.g_varchar2

464: ,p_tuition_method in varchar2 default hr_api.g_varchar2
465: ,p_group_ranking in varchar2 default hr_api.g_varchar2
466: ,p_comments in varchar2 default hr_api.g_varchar2
467: ,p_attendance_id in number default hr_api.g_number
468: ,p_attribute_category in varchar2 default hr_api.g_varchar2
469: ,p_attribute1 in varchar2 default hr_api.g_varchar2
470: ,p_attribute2 in varchar2 default hr_api.g_varchar2
471: ,p_attribute3 in varchar2 default hr_api.g_varchar2
472: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 469: ,p_attribute1 in varchar2 default hr_api.g_varchar2

465: ,p_group_ranking in varchar2 default hr_api.g_varchar2
466: ,p_comments in varchar2 default hr_api.g_varchar2
467: ,p_attendance_id in number default hr_api.g_number
468: ,p_attribute_category in varchar2 default hr_api.g_varchar2
469: ,p_attribute1 in varchar2 default hr_api.g_varchar2
470: ,p_attribute2 in varchar2 default hr_api.g_varchar2
471: ,p_attribute3 in varchar2 default hr_api.g_varchar2
472: ,p_attribute4 in varchar2 default hr_api.g_varchar2
473: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 470: ,p_attribute2 in varchar2 default hr_api.g_varchar2

466: ,p_comments in varchar2 default hr_api.g_varchar2
467: ,p_attendance_id in number default hr_api.g_number
468: ,p_attribute_category in varchar2 default hr_api.g_varchar2
469: ,p_attribute1 in varchar2 default hr_api.g_varchar2
470: ,p_attribute2 in varchar2 default hr_api.g_varchar2
471: ,p_attribute3 in varchar2 default hr_api.g_varchar2
472: ,p_attribute4 in varchar2 default hr_api.g_varchar2
473: ,p_attribute5 in varchar2 default hr_api.g_varchar2
474: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 471: ,p_attribute3 in varchar2 default hr_api.g_varchar2

467: ,p_attendance_id in number default hr_api.g_number
468: ,p_attribute_category in varchar2 default hr_api.g_varchar2
469: ,p_attribute1 in varchar2 default hr_api.g_varchar2
470: ,p_attribute2 in varchar2 default hr_api.g_varchar2
471: ,p_attribute3 in varchar2 default hr_api.g_varchar2
472: ,p_attribute4 in varchar2 default hr_api.g_varchar2
473: ,p_attribute5 in varchar2 default hr_api.g_varchar2
474: ,p_attribute6 in varchar2 default hr_api.g_varchar2
475: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 472: ,p_attribute4 in varchar2 default hr_api.g_varchar2

468: ,p_attribute_category in varchar2 default hr_api.g_varchar2
469: ,p_attribute1 in varchar2 default hr_api.g_varchar2
470: ,p_attribute2 in varchar2 default hr_api.g_varchar2
471: ,p_attribute3 in varchar2 default hr_api.g_varchar2
472: ,p_attribute4 in varchar2 default hr_api.g_varchar2
473: ,p_attribute5 in varchar2 default hr_api.g_varchar2
474: ,p_attribute6 in varchar2 default hr_api.g_varchar2
475: ,p_attribute7 in varchar2 default hr_api.g_varchar2
476: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 473: ,p_attribute5 in varchar2 default hr_api.g_varchar2

469: ,p_attribute1 in varchar2 default hr_api.g_varchar2
470: ,p_attribute2 in varchar2 default hr_api.g_varchar2
471: ,p_attribute3 in varchar2 default hr_api.g_varchar2
472: ,p_attribute4 in varchar2 default hr_api.g_varchar2
473: ,p_attribute5 in varchar2 default hr_api.g_varchar2
474: ,p_attribute6 in varchar2 default hr_api.g_varchar2
475: ,p_attribute7 in varchar2 default hr_api.g_varchar2
476: ,p_attribute8 in varchar2 default hr_api.g_varchar2
477: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 474: ,p_attribute6 in varchar2 default hr_api.g_varchar2

470: ,p_attribute2 in varchar2 default hr_api.g_varchar2
471: ,p_attribute3 in varchar2 default hr_api.g_varchar2
472: ,p_attribute4 in varchar2 default hr_api.g_varchar2
473: ,p_attribute5 in varchar2 default hr_api.g_varchar2
474: ,p_attribute6 in varchar2 default hr_api.g_varchar2
475: ,p_attribute7 in varchar2 default hr_api.g_varchar2
476: ,p_attribute8 in varchar2 default hr_api.g_varchar2
477: ,p_attribute9 in varchar2 default hr_api.g_varchar2
478: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 475: ,p_attribute7 in varchar2 default hr_api.g_varchar2

471: ,p_attribute3 in varchar2 default hr_api.g_varchar2
472: ,p_attribute4 in varchar2 default hr_api.g_varchar2
473: ,p_attribute5 in varchar2 default hr_api.g_varchar2
474: ,p_attribute6 in varchar2 default hr_api.g_varchar2
475: ,p_attribute7 in varchar2 default hr_api.g_varchar2
476: ,p_attribute8 in varchar2 default hr_api.g_varchar2
477: ,p_attribute9 in varchar2 default hr_api.g_varchar2
478: ,p_attribute10 in varchar2 default hr_api.g_varchar2
479: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 476: ,p_attribute8 in varchar2 default hr_api.g_varchar2

472: ,p_attribute4 in varchar2 default hr_api.g_varchar2
473: ,p_attribute5 in varchar2 default hr_api.g_varchar2
474: ,p_attribute6 in varchar2 default hr_api.g_varchar2
475: ,p_attribute7 in varchar2 default hr_api.g_varchar2
476: ,p_attribute8 in varchar2 default hr_api.g_varchar2
477: ,p_attribute9 in varchar2 default hr_api.g_varchar2
478: ,p_attribute10 in varchar2 default hr_api.g_varchar2
479: ,p_attribute11 in varchar2 default hr_api.g_varchar2
480: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 477: ,p_attribute9 in varchar2 default hr_api.g_varchar2

473: ,p_attribute5 in varchar2 default hr_api.g_varchar2
474: ,p_attribute6 in varchar2 default hr_api.g_varchar2
475: ,p_attribute7 in varchar2 default hr_api.g_varchar2
476: ,p_attribute8 in varchar2 default hr_api.g_varchar2
477: ,p_attribute9 in varchar2 default hr_api.g_varchar2
478: ,p_attribute10 in varchar2 default hr_api.g_varchar2
479: ,p_attribute11 in varchar2 default hr_api.g_varchar2
480: ,p_attribute12 in varchar2 default hr_api.g_varchar2
481: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 478: ,p_attribute10 in varchar2 default hr_api.g_varchar2

474: ,p_attribute6 in varchar2 default hr_api.g_varchar2
475: ,p_attribute7 in varchar2 default hr_api.g_varchar2
476: ,p_attribute8 in varchar2 default hr_api.g_varchar2
477: ,p_attribute9 in varchar2 default hr_api.g_varchar2
478: ,p_attribute10 in varchar2 default hr_api.g_varchar2
479: ,p_attribute11 in varchar2 default hr_api.g_varchar2
480: ,p_attribute12 in varchar2 default hr_api.g_varchar2
481: ,p_attribute13 in varchar2 default hr_api.g_varchar2
482: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 479: ,p_attribute11 in varchar2 default hr_api.g_varchar2

475: ,p_attribute7 in varchar2 default hr_api.g_varchar2
476: ,p_attribute8 in varchar2 default hr_api.g_varchar2
477: ,p_attribute9 in varchar2 default hr_api.g_varchar2
478: ,p_attribute10 in varchar2 default hr_api.g_varchar2
479: ,p_attribute11 in varchar2 default hr_api.g_varchar2
480: ,p_attribute12 in varchar2 default hr_api.g_varchar2
481: ,p_attribute13 in varchar2 default hr_api.g_varchar2
482: ,p_attribute14 in varchar2 default hr_api.g_varchar2
483: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 480: ,p_attribute12 in varchar2 default hr_api.g_varchar2

476: ,p_attribute8 in varchar2 default hr_api.g_varchar2
477: ,p_attribute9 in varchar2 default hr_api.g_varchar2
478: ,p_attribute10 in varchar2 default hr_api.g_varchar2
479: ,p_attribute11 in varchar2 default hr_api.g_varchar2
480: ,p_attribute12 in varchar2 default hr_api.g_varchar2
481: ,p_attribute13 in varchar2 default hr_api.g_varchar2
482: ,p_attribute14 in varchar2 default hr_api.g_varchar2
483: ,p_attribute15 in varchar2 default hr_api.g_varchar2
484: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 481: ,p_attribute13 in varchar2 default hr_api.g_varchar2

477: ,p_attribute9 in varchar2 default hr_api.g_varchar2
478: ,p_attribute10 in varchar2 default hr_api.g_varchar2
479: ,p_attribute11 in varchar2 default hr_api.g_varchar2
480: ,p_attribute12 in varchar2 default hr_api.g_varchar2
481: ,p_attribute13 in varchar2 default hr_api.g_varchar2
482: ,p_attribute14 in varchar2 default hr_api.g_varchar2
483: ,p_attribute15 in varchar2 default hr_api.g_varchar2
484: ,p_attribute16 in varchar2 default hr_api.g_varchar2
485: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 482: ,p_attribute14 in varchar2 default hr_api.g_varchar2

478: ,p_attribute10 in varchar2 default hr_api.g_varchar2
479: ,p_attribute11 in varchar2 default hr_api.g_varchar2
480: ,p_attribute12 in varchar2 default hr_api.g_varchar2
481: ,p_attribute13 in varchar2 default hr_api.g_varchar2
482: ,p_attribute14 in varchar2 default hr_api.g_varchar2
483: ,p_attribute15 in varchar2 default hr_api.g_varchar2
484: ,p_attribute16 in varchar2 default hr_api.g_varchar2
485: ,p_attribute17 in varchar2 default hr_api.g_varchar2
486: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 483: ,p_attribute15 in varchar2 default hr_api.g_varchar2

479: ,p_attribute11 in varchar2 default hr_api.g_varchar2
480: ,p_attribute12 in varchar2 default hr_api.g_varchar2
481: ,p_attribute13 in varchar2 default hr_api.g_varchar2
482: ,p_attribute14 in varchar2 default hr_api.g_varchar2
483: ,p_attribute15 in varchar2 default hr_api.g_varchar2
484: ,p_attribute16 in varchar2 default hr_api.g_varchar2
485: ,p_attribute17 in varchar2 default hr_api.g_varchar2
486: ,p_attribute18 in varchar2 default hr_api.g_varchar2
487: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 484: ,p_attribute16 in varchar2 default hr_api.g_varchar2

480: ,p_attribute12 in varchar2 default hr_api.g_varchar2
481: ,p_attribute13 in varchar2 default hr_api.g_varchar2
482: ,p_attribute14 in varchar2 default hr_api.g_varchar2
483: ,p_attribute15 in varchar2 default hr_api.g_varchar2
484: ,p_attribute16 in varchar2 default hr_api.g_varchar2
485: ,p_attribute17 in varchar2 default hr_api.g_varchar2
486: ,p_attribute18 in varchar2 default hr_api.g_varchar2
487: ,p_attribute19 in varchar2 default hr_api.g_varchar2
488: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 485: ,p_attribute17 in varchar2 default hr_api.g_varchar2

481: ,p_attribute13 in varchar2 default hr_api.g_varchar2
482: ,p_attribute14 in varchar2 default hr_api.g_varchar2
483: ,p_attribute15 in varchar2 default hr_api.g_varchar2
484: ,p_attribute16 in varchar2 default hr_api.g_varchar2
485: ,p_attribute17 in varchar2 default hr_api.g_varchar2
486: ,p_attribute18 in varchar2 default hr_api.g_varchar2
487: ,p_attribute19 in varchar2 default hr_api.g_varchar2
488: ,p_attribute20 in varchar2 default hr_api.g_varchar2
489: ,p_qua_information_category in varchar2 default hr_api.g_varchar2

Line 486: ,p_attribute18 in varchar2 default hr_api.g_varchar2

482: ,p_attribute14 in varchar2 default hr_api.g_varchar2
483: ,p_attribute15 in varchar2 default hr_api.g_varchar2
484: ,p_attribute16 in varchar2 default hr_api.g_varchar2
485: ,p_attribute17 in varchar2 default hr_api.g_varchar2
486: ,p_attribute18 in varchar2 default hr_api.g_varchar2
487: ,p_attribute19 in varchar2 default hr_api.g_varchar2
488: ,p_attribute20 in varchar2 default hr_api.g_varchar2
489: ,p_qua_information_category in varchar2 default hr_api.g_varchar2
490: ,p_qua_information1 in varchar2 default hr_api.g_varchar2

Line 487: ,p_attribute19 in varchar2 default hr_api.g_varchar2

483: ,p_attribute15 in varchar2 default hr_api.g_varchar2
484: ,p_attribute16 in varchar2 default hr_api.g_varchar2
485: ,p_attribute17 in varchar2 default hr_api.g_varchar2
486: ,p_attribute18 in varchar2 default hr_api.g_varchar2
487: ,p_attribute19 in varchar2 default hr_api.g_varchar2
488: ,p_attribute20 in varchar2 default hr_api.g_varchar2
489: ,p_qua_information_category in varchar2 default hr_api.g_varchar2
490: ,p_qua_information1 in varchar2 default hr_api.g_varchar2
491: ,p_qua_information2 in varchar2 default hr_api.g_varchar2

Line 488: ,p_attribute20 in varchar2 default hr_api.g_varchar2

484: ,p_attribute16 in varchar2 default hr_api.g_varchar2
485: ,p_attribute17 in varchar2 default hr_api.g_varchar2
486: ,p_attribute18 in varchar2 default hr_api.g_varchar2
487: ,p_attribute19 in varchar2 default hr_api.g_varchar2
488: ,p_attribute20 in varchar2 default hr_api.g_varchar2
489: ,p_qua_information_category in varchar2 default hr_api.g_varchar2
490: ,p_qua_information1 in varchar2 default hr_api.g_varchar2
491: ,p_qua_information2 in varchar2 default hr_api.g_varchar2
492: ,p_qua_information3 in varchar2 default hr_api.g_varchar2

Line 489: ,p_qua_information_category in varchar2 default hr_api.g_varchar2

485: ,p_attribute17 in varchar2 default hr_api.g_varchar2
486: ,p_attribute18 in varchar2 default hr_api.g_varchar2
487: ,p_attribute19 in varchar2 default hr_api.g_varchar2
488: ,p_attribute20 in varchar2 default hr_api.g_varchar2
489: ,p_qua_information_category in varchar2 default hr_api.g_varchar2
490: ,p_qua_information1 in varchar2 default hr_api.g_varchar2
491: ,p_qua_information2 in varchar2 default hr_api.g_varchar2
492: ,p_qua_information3 in varchar2 default hr_api.g_varchar2
493: ,p_qua_information4 in varchar2 default hr_api.g_varchar2

Line 490: ,p_qua_information1 in varchar2 default hr_api.g_varchar2

486: ,p_attribute18 in varchar2 default hr_api.g_varchar2
487: ,p_attribute19 in varchar2 default hr_api.g_varchar2
488: ,p_attribute20 in varchar2 default hr_api.g_varchar2
489: ,p_qua_information_category in varchar2 default hr_api.g_varchar2
490: ,p_qua_information1 in varchar2 default hr_api.g_varchar2
491: ,p_qua_information2 in varchar2 default hr_api.g_varchar2
492: ,p_qua_information3 in varchar2 default hr_api.g_varchar2
493: ,p_qua_information4 in varchar2 default hr_api.g_varchar2
494: ,p_qua_information5 in varchar2 default hr_api.g_varchar2

Line 491: ,p_qua_information2 in varchar2 default hr_api.g_varchar2

487: ,p_attribute19 in varchar2 default hr_api.g_varchar2
488: ,p_attribute20 in varchar2 default hr_api.g_varchar2
489: ,p_qua_information_category in varchar2 default hr_api.g_varchar2
490: ,p_qua_information1 in varchar2 default hr_api.g_varchar2
491: ,p_qua_information2 in varchar2 default hr_api.g_varchar2
492: ,p_qua_information3 in varchar2 default hr_api.g_varchar2
493: ,p_qua_information4 in varchar2 default hr_api.g_varchar2
494: ,p_qua_information5 in varchar2 default hr_api.g_varchar2
495: ,p_qua_information6 in varchar2 default hr_api.g_varchar2

Line 492: ,p_qua_information3 in varchar2 default hr_api.g_varchar2

488: ,p_attribute20 in varchar2 default hr_api.g_varchar2
489: ,p_qua_information_category in varchar2 default hr_api.g_varchar2
490: ,p_qua_information1 in varchar2 default hr_api.g_varchar2
491: ,p_qua_information2 in varchar2 default hr_api.g_varchar2
492: ,p_qua_information3 in varchar2 default hr_api.g_varchar2
493: ,p_qua_information4 in varchar2 default hr_api.g_varchar2
494: ,p_qua_information5 in varchar2 default hr_api.g_varchar2
495: ,p_qua_information6 in varchar2 default hr_api.g_varchar2
496: ,p_qua_information7 in varchar2 default hr_api.g_varchar2

Line 493: ,p_qua_information4 in varchar2 default hr_api.g_varchar2

489: ,p_qua_information_category in varchar2 default hr_api.g_varchar2
490: ,p_qua_information1 in varchar2 default hr_api.g_varchar2
491: ,p_qua_information2 in varchar2 default hr_api.g_varchar2
492: ,p_qua_information3 in varchar2 default hr_api.g_varchar2
493: ,p_qua_information4 in varchar2 default hr_api.g_varchar2
494: ,p_qua_information5 in varchar2 default hr_api.g_varchar2
495: ,p_qua_information6 in varchar2 default hr_api.g_varchar2
496: ,p_qua_information7 in varchar2 default hr_api.g_varchar2
497: ,p_qua_information8 in varchar2 default hr_api.g_varchar2

Line 494: ,p_qua_information5 in varchar2 default hr_api.g_varchar2

490: ,p_qua_information1 in varchar2 default hr_api.g_varchar2
491: ,p_qua_information2 in varchar2 default hr_api.g_varchar2
492: ,p_qua_information3 in varchar2 default hr_api.g_varchar2
493: ,p_qua_information4 in varchar2 default hr_api.g_varchar2
494: ,p_qua_information5 in varchar2 default hr_api.g_varchar2
495: ,p_qua_information6 in varchar2 default hr_api.g_varchar2
496: ,p_qua_information7 in varchar2 default hr_api.g_varchar2
497: ,p_qua_information8 in varchar2 default hr_api.g_varchar2
498: ,p_qua_information9 in varchar2 default hr_api.g_varchar2

Line 495: ,p_qua_information6 in varchar2 default hr_api.g_varchar2

491: ,p_qua_information2 in varchar2 default hr_api.g_varchar2
492: ,p_qua_information3 in varchar2 default hr_api.g_varchar2
493: ,p_qua_information4 in varchar2 default hr_api.g_varchar2
494: ,p_qua_information5 in varchar2 default hr_api.g_varchar2
495: ,p_qua_information6 in varchar2 default hr_api.g_varchar2
496: ,p_qua_information7 in varchar2 default hr_api.g_varchar2
497: ,p_qua_information8 in varchar2 default hr_api.g_varchar2
498: ,p_qua_information9 in varchar2 default hr_api.g_varchar2
499: ,p_qua_information10 in varchar2 default hr_api.g_varchar2

Line 496: ,p_qua_information7 in varchar2 default hr_api.g_varchar2

492: ,p_qua_information3 in varchar2 default hr_api.g_varchar2
493: ,p_qua_information4 in varchar2 default hr_api.g_varchar2
494: ,p_qua_information5 in varchar2 default hr_api.g_varchar2
495: ,p_qua_information6 in varchar2 default hr_api.g_varchar2
496: ,p_qua_information7 in varchar2 default hr_api.g_varchar2
497: ,p_qua_information8 in varchar2 default hr_api.g_varchar2
498: ,p_qua_information9 in varchar2 default hr_api.g_varchar2
499: ,p_qua_information10 in varchar2 default hr_api.g_varchar2
500: ,p_qua_information11 in varchar2 default hr_api.g_varchar2

Line 497: ,p_qua_information8 in varchar2 default hr_api.g_varchar2

493: ,p_qua_information4 in varchar2 default hr_api.g_varchar2
494: ,p_qua_information5 in varchar2 default hr_api.g_varchar2
495: ,p_qua_information6 in varchar2 default hr_api.g_varchar2
496: ,p_qua_information7 in varchar2 default hr_api.g_varchar2
497: ,p_qua_information8 in varchar2 default hr_api.g_varchar2
498: ,p_qua_information9 in varchar2 default hr_api.g_varchar2
499: ,p_qua_information10 in varchar2 default hr_api.g_varchar2
500: ,p_qua_information11 in varchar2 default hr_api.g_varchar2
501: ,p_qua_information12 in varchar2 default hr_api.g_varchar2

Line 498: ,p_qua_information9 in varchar2 default hr_api.g_varchar2

494: ,p_qua_information5 in varchar2 default hr_api.g_varchar2
495: ,p_qua_information6 in varchar2 default hr_api.g_varchar2
496: ,p_qua_information7 in varchar2 default hr_api.g_varchar2
497: ,p_qua_information8 in varchar2 default hr_api.g_varchar2
498: ,p_qua_information9 in varchar2 default hr_api.g_varchar2
499: ,p_qua_information10 in varchar2 default hr_api.g_varchar2
500: ,p_qua_information11 in varchar2 default hr_api.g_varchar2
501: ,p_qua_information12 in varchar2 default hr_api.g_varchar2
502: ,p_qua_information13 in varchar2 default hr_api.g_varchar2

Line 499: ,p_qua_information10 in varchar2 default hr_api.g_varchar2

495: ,p_qua_information6 in varchar2 default hr_api.g_varchar2
496: ,p_qua_information7 in varchar2 default hr_api.g_varchar2
497: ,p_qua_information8 in varchar2 default hr_api.g_varchar2
498: ,p_qua_information9 in varchar2 default hr_api.g_varchar2
499: ,p_qua_information10 in varchar2 default hr_api.g_varchar2
500: ,p_qua_information11 in varchar2 default hr_api.g_varchar2
501: ,p_qua_information12 in varchar2 default hr_api.g_varchar2
502: ,p_qua_information13 in varchar2 default hr_api.g_varchar2
503: ,p_qua_information14 in varchar2 default hr_api.g_varchar2

Line 500: ,p_qua_information11 in varchar2 default hr_api.g_varchar2

496: ,p_qua_information7 in varchar2 default hr_api.g_varchar2
497: ,p_qua_information8 in varchar2 default hr_api.g_varchar2
498: ,p_qua_information9 in varchar2 default hr_api.g_varchar2
499: ,p_qua_information10 in varchar2 default hr_api.g_varchar2
500: ,p_qua_information11 in varchar2 default hr_api.g_varchar2
501: ,p_qua_information12 in varchar2 default hr_api.g_varchar2
502: ,p_qua_information13 in varchar2 default hr_api.g_varchar2
503: ,p_qua_information14 in varchar2 default hr_api.g_varchar2
504: ,p_qua_information15 in varchar2 default hr_api.g_varchar2

Line 501: ,p_qua_information12 in varchar2 default hr_api.g_varchar2

497: ,p_qua_information8 in varchar2 default hr_api.g_varchar2
498: ,p_qua_information9 in varchar2 default hr_api.g_varchar2
499: ,p_qua_information10 in varchar2 default hr_api.g_varchar2
500: ,p_qua_information11 in varchar2 default hr_api.g_varchar2
501: ,p_qua_information12 in varchar2 default hr_api.g_varchar2
502: ,p_qua_information13 in varchar2 default hr_api.g_varchar2
503: ,p_qua_information14 in varchar2 default hr_api.g_varchar2
504: ,p_qua_information15 in varchar2 default hr_api.g_varchar2
505: ,p_qua_information16 in varchar2 default hr_api.g_varchar2

Line 502: ,p_qua_information13 in varchar2 default hr_api.g_varchar2

498: ,p_qua_information9 in varchar2 default hr_api.g_varchar2
499: ,p_qua_information10 in varchar2 default hr_api.g_varchar2
500: ,p_qua_information11 in varchar2 default hr_api.g_varchar2
501: ,p_qua_information12 in varchar2 default hr_api.g_varchar2
502: ,p_qua_information13 in varchar2 default hr_api.g_varchar2
503: ,p_qua_information14 in varchar2 default hr_api.g_varchar2
504: ,p_qua_information15 in varchar2 default hr_api.g_varchar2
505: ,p_qua_information16 in varchar2 default hr_api.g_varchar2
506: ,p_qua_information17 in varchar2 default hr_api.g_varchar2

Line 503: ,p_qua_information14 in varchar2 default hr_api.g_varchar2

499: ,p_qua_information10 in varchar2 default hr_api.g_varchar2
500: ,p_qua_information11 in varchar2 default hr_api.g_varchar2
501: ,p_qua_information12 in varchar2 default hr_api.g_varchar2
502: ,p_qua_information13 in varchar2 default hr_api.g_varchar2
503: ,p_qua_information14 in varchar2 default hr_api.g_varchar2
504: ,p_qua_information15 in varchar2 default hr_api.g_varchar2
505: ,p_qua_information16 in varchar2 default hr_api.g_varchar2
506: ,p_qua_information17 in varchar2 default hr_api.g_varchar2
507: ,p_qua_information18 in varchar2 default hr_api.g_varchar2

Line 504: ,p_qua_information15 in varchar2 default hr_api.g_varchar2

500: ,p_qua_information11 in varchar2 default hr_api.g_varchar2
501: ,p_qua_information12 in varchar2 default hr_api.g_varchar2
502: ,p_qua_information13 in varchar2 default hr_api.g_varchar2
503: ,p_qua_information14 in varchar2 default hr_api.g_varchar2
504: ,p_qua_information15 in varchar2 default hr_api.g_varchar2
505: ,p_qua_information16 in varchar2 default hr_api.g_varchar2
506: ,p_qua_information17 in varchar2 default hr_api.g_varchar2
507: ,p_qua_information18 in varchar2 default hr_api.g_varchar2
508: ,p_qua_information19 in varchar2 default hr_api.g_varchar2

Line 505: ,p_qua_information16 in varchar2 default hr_api.g_varchar2

501: ,p_qua_information12 in varchar2 default hr_api.g_varchar2
502: ,p_qua_information13 in varchar2 default hr_api.g_varchar2
503: ,p_qua_information14 in varchar2 default hr_api.g_varchar2
504: ,p_qua_information15 in varchar2 default hr_api.g_varchar2
505: ,p_qua_information16 in varchar2 default hr_api.g_varchar2
506: ,p_qua_information17 in varchar2 default hr_api.g_varchar2
507: ,p_qua_information18 in varchar2 default hr_api.g_varchar2
508: ,p_qua_information19 in varchar2 default hr_api.g_varchar2
509: ,p_qua_information20 in varchar2 default hr_api.g_varchar2

Line 506: ,p_qua_information17 in varchar2 default hr_api.g_varchar2

502: ,p_qua_information13 in varchar2 default hr_api.g_varchar2
503: ,p_qua_information14 in varchar2 default hr_api.g_varchar2
504: ,p_qua_information15 in varchar2 default hr_api.g_varchar2
505: ,p_qua_information16 in varchar2 default hr_api.g_varchar2
506: ,p_qua_information17 in varchar2 default hr_api.g_varchar2
507: ,p_qua_information18 in varchar2 default hr_api.g_varchar2
508: ,p_qua_information19 in varchar2 default hr_api.g_varchar2
509: ,p_qua_information20 in varchar2 default hr_api.g_varchar2
510: ,p_professional_body_name in varchar2 default hr_api.g_varchar2

Line 507: ,p_qua_information18 in varchar2 default hr_api.g_varchar2

503: ,p_qua_information14 in varchar2 default hr_api.g_varchar2
504: ,p_qua_information15 in varchar2 default hr_api.g_varchar2
505: ,p_qua_information16 in varchar2 default hr_api.g_varchar2
506: ,p_qua_information17 in varchar2 default hr_api.g_varchar2
507: ,p_qua_information18 in varchar2 default hr_api.g_varchar2
508: ,p_qua_information19 in varchar2 default hr_api.g_varchar2
509: ,p_qua_information20 in varchar2 default hr_api.g_varchar2
510: ,p_professional_body_name in varchar2 default hr_api.g_varchar2
511: ,p_membership_number in varchar2 default hr_api.g_varchar2

Line 508: ,p_qua_information19 in varchar2 default hr_api.g_varchar2

504: ,p_qua_information15 in varchar2 default hr_api.g_varchar2
505: ,p_qua_information16 in varchar2 default hr_api.g_varchar2
506: ,p_qua_information17 in varchar2 default hr_api.g_varchar2
507: ,p_qua_information18 in varchar2 default hr_api.g_varchar2
508: ,p_qua_information19 in varchar2 default hr_api.g_varchar2
509: ,p_qua_information20 in varchar2 default hr_api.g_varchar2
510: ,p_professional_body_name in varchar2 default hr_api.g_varchar2
511: ,p_membership_number in varchar2 default hr_api.g_varchar2
512: ,p_membership_category in varchar2 default hr_api.g_varchar2

Line 509: ,p_qua_information20 in varchar2 default hr_api.g_varchar2

505: ,p_qua_information16 in varchar2 default hr_api.g_varchar2
506: ,p_qua_information17 in varchar2 default hr_api.g_varchar2
507: ,p_qua_information18 in varchar2 default hr_api.g_varchar2
508: ,p_qua_information19 in varchar2 default hr_api.g_varchar2
509: ,p_qua_information20 in varchar2 default hr_api.g_varchar2
510: ,p_professional_body_name in varchar2 default hr_api.g_varchar2
511: ,p_membership_number in varchar2 default hr_api.g_varchar2
512: ,p_membership_category in varchar2 default hr_api.g_varchar2
513: ,p_subscription_payment_method in varchar2 default hr_api.g_varchar2

Line 510: ,p_professional_body_name in varchar2 default hr_api.g_varchar2

506: ,p_qua_information17 in varchar2 default hr_api.g_varchar2
507: ,p_qua_information18 in varchar2 default hr_api.g_varchar2
508: ,p_qua_information19 in varchar2 default hr_api.g_varchar2
509: ,p_qua_information20 in varchar2 default hr_api.g_varchar2
510: ,p_professional_body_name in varchar2 default hr_api.g_varchar2
511: ,p_membership_number in varchar2 default hr_api.g_varchar2
512: ,p_membership_category in varchar2 default hr_api.g_varchar2
513: ,p_subscription_payment_method in varchar2 default hr_api.g_varchar2
514: ,p_object_version_number in out nocopy number

Line 511: ,p_membership_number in varchar2 default hr_api.g_varchar2

507: ,p_qua_information18 in varchar2 default hr_api.g_varchar2
508: ,p_qua_information19 in varchar2 default hr_api.g_varchar2
509: ,p_qua_information20 in varchar2 default hr_api.g_varchar2
510: ,p_professional_body_name in varchar2 default hr_api.g_varchar2
511: ,p_membership_number in varchar2 default hr_api.g_varchar2
512: ,p_membership_category in varchar2 default hr_api.g_varchar2
513: ,p_subscription_payment_method in varchar2 default hr_api.g_varchar2
514: ,p_object_version_number in out nocopy number
515: ) is

Line 512: ,p_membership_category in varchar2 default hr_api.g_varchar2

508: ,p_qua_information19 in varchar2 default hr_api.g_varchar2
509: ,p_qua_information20 in varchar2 default hr_api.g_varchar2
510: ,p_professional_body_name in varchar2 default hr_api.g_varchar2
511: ,p_membership_number in varchar2 default hr_api.g_varchar2
512: ,p_membership_category in varchar2 default hr_api.g_varchar2
513: ,p_subscription_payment_method in varchar2 default hr_api.g_varchar2
514: ,p_object_version_number in out nocopy number
515: ) is
516: --

Line 513: ,p_subscription_payment_method in varchar2 default hr_api.g_varchar2

509: ,p_qua_information20 in varchar2 default hr_api.g_varchar2
510: ,p_professional_body_name in varchar2 default hr_api.g_varchar2
511: ,p_membership_number in varchar2 default hr_api.g_varchar2
512: ,p_membership_category in varchar2 default hr_api.g_varchar2
513: ,p_subscription_payment_method in varchar2 default hr_api.g_varchar2
514: ,p_object_version_number in out nocopy number
515: ) is
516: --
517: -- Declare cursors and local variables

Line 553: hr_api.validate_language_code(p_language_code => l_language_code);

549: -- instead of p_language_code from now on, to allow an IN OUT parameter to
550: -- be passed through.
551: --
552: l_language_code := p_language_code;
553: hr_api.validate_language_code(p_language_code => l_language_code);
554:
555: --
556: -- Call Before Process User Hook
557: --

Line 633: when hr_Api.cannot_find_prog_unit then

629: ,p_subscription_payment_method => p_subscription_payment_method
630: ,p_object_version_number => l_object_version_number
631: ,p_language_code => l_language_code);
632: exception
633: when hr_Api.cannot_find_prog_unit then
634: hr_Api.cannot_find_prog_unit_error
635: (p_module_name => 'UPDATE_QUALIFICATION'
636: ,p_hook_type => 'BP'
637: );

Line 634: hr_Api.cannot_find_prog_unit_error

630: ,p_object_version_number => l_object_version_number
631: ,p_language_code => l_language_code);
632: exception
633: when hr_Api.cannot_find_prog_unit then
634: hr_Api.cannot_find_prog_unit_error
635: (p_module_name => 'UPDATE_QUALIFICATION'
636: ,p_hook_type => 'BP'
637: );
638: end;

Line 814: when hr_Api.cannot_find_prog_unit then

810: ,p_subscription_payment_method => p_subscription_payment_method
811: ,p_object_version_number => l_object_version_number
812: ,p_language_code => l_language_code);
813: exception
814: when hr_Api.cannot_find_prog_unit then
815: hr_Api.cannot_find_prog_unit_error
816: (p_module_name => 'UPDATE_QUALIFICATION'
817: ,p_hook_type => 'AP'
818: );

Line 815: hr_Api.cannot_find_prog_unit_error

811: ,p_object_version_number => l_object_version_number
812: ,p_language_code => l_language_code);
813: exception
814: when hr_Api.cannot_find_prog_unit then
815: hr_Api.cannot_find_prog_unit_error
816: (p_module_name => 'UPDATE_QUALIFICATION'
817: ,p_hook_type => 'AP'
818: );
819: end;

Line 824: raise hr_Api.validate_enabled;

820: --
821: -- When in validation only mode raise the Validate_Enabled exception
822: --
823: if p_validate then
824: raise hr_Api.validate_enabled;
825: end if;
826: --
827: -- Set all output arguements
828: --

Line 832: when hr_Api.validate_enabled then

828: --
829: p_object_version_number := l_object_version_number;
830: hr_utility.set_location(' Leaving:'||l_proc, 70);
831: exception
832: when hr_Api.validate_enabled then
833: --
834: -- As the Validate_Enabled exception has been raised
835: -- we must rollback to the savepoint
836: --

Line 896: when hr_Api.cannot_find_prog_unit then

892: (p_qualification_id => p_qualification_id
893: ,p_object_version_number => p_object_version_number
894: );
895: exception
896: when hr_Api.cannot_find_prog_unit then
897: hr_Api.cannot_find_prog_unit_error
898: (p_module_name => 'DELETE_QUALIFICATION'
899: ,p_hook_type => 'BP'
900: );

Line 897: hr_Api.cannot_find_prog_unit_error

893: ,p_object_version_number => p_object_version_number
894: );
895: exception
896: when hr_Api.cannot_find_prog_unit then
897: hr_Api.cannot_find_prog_unit_error
898: (p_module_name => 'DELETE_QUALIFICATION'
899: ,p_hook_type => 'BP'
900: );
901: end;

Line 929: when hr_Api.cannot_find_prog_unit then

925: ,p_object_version_number => p_object_version_number
926: ,p_person_id => l_person_id
927: );
928: exception
929: when hr_Api.cannot_find_prog_unit then
930: hr_Api.cannot_find_prog_unit_error
931: (p_module_name => 'DELETE_QUALIFICATION'
932: ,p_hook_type => 'AP'
933: );

Line 930: hr_Api.cannot_find_prog_unit_error

926: ,p_person_id => l_person_id
927: );
928: exception
929: when hr_Api.cannot_find_prog_unit then
930: hr_Api.cannot_find_prog_unit_error
931: (p_module_name => 'DELETE_QUALIFICATION'
932: ,p_hook_type => 'AP'
933: );
934: end;

Line 939: raise hr_Api.validate_enabled;

935: --
936: -- When in validation only mode raise the Validate_Enabled exception
937: --
938: if p_validate then
939: raise hr_Api.validate_enabled;
940: end if;
941: --
942: hr_utility.set_location(' Leaving:'||l_proc, 70);
943: exception

Line 944: when hr_Api.validate_enabled then

940: end if;
941: --
942: hr_utility.set_location(' Leaving:'||l_proc, 70);
943: exception
944: when hr_Api.validate_enabled then
945: --
946: -- As the Validate_Enabled exception has been raised
947: -- we must rollback to the savepoint
948: --