DBA Data[Home] [Help]

APPS.HR_APPRAISAL_TEMPLATES_API dependencies on HR_API

Line 175: when hr_api.cannot_find_prog_unit then

171: ,p_SHOW_FUTURE_TERM_EMPLOYEE => p_SHOW_FUTURE_TERM_EMPLOYEE -- 6181267 bug fix
172:
173: );
174: exception
175: when hr_api.cannot_find_prog_unit then
176: hr_api.cannot_find_prog_unit_error
177: (p_module_name => 'create_appraisal_template',
178: p_hook_type => 'BP'
179: );

Line 176: hr_api.cannot_find_prog_unit_error

172:
173: );
174: exception
175: when hr_api.cannot_find_prog_unit then
176: hr_api.cannot_find_prog_unit_error
177: (p_module_name => 'create_appraisal_template',
178: p_hook_type => 'BP'
179: );
180: end;

Line 360: when hr_api.cannot_find_prog_unit then

356: ,p_SHOW_FUTURE_TERM_EMPLOYEE => p_SHOW_FUTURE_TERM_EMPLOYEE -- 6181267 bug fix
357:
358: );
359: exception
360: when hr_api.cannot_find_prog_unit then
361: hr_api.cannot_find_prog_unit_error
362: (p_module_name => 'create_appraisal_template',
363: p_hook_type => 'AP'
364: );

Line 361: hr_api.cannot_find_prog_unit_error

357:
358: );
359: exception
360: when hr_api.cannot_find_prog_unit then
361: hr_api.cannot_find_prog_unit_error
362: (p_module_name => 'create_appraisal_template',
363: p_hook_type => 'AP'
364: );
365: end;

Line 372: raise hr_api.validate_enabled;

368: --
369: -- When in validation only mode raise the Validate_Enabled exception
370: --
371: if p_validate then
372: raise hr_api.validate_enabled;
373: end if;
374: --
375: -- Set all output arguments
376: --

Line 382: when hr_api.validate_enabled then

378: p_object_version_number := l_object_version_number;
379: --
380: hr_utility.set_location(' Leaving:'||l_proc, 11);
381: exception
382: when hr_api.validate_enabled then
383: --
384: -- As the Validate_Enabled exception has been raised
385: -- we must rollback to the savepoint
386: --

Line 420: p_name in varchar2 default hr_api.g_varchar2,

416: (p_validate in boolean default false,
417: p_effective_date in date,
418: p_appraisal_template_id in number,
419: p_object_version_number in out nocopy number,
420: p_name in varchar2 default hr_api.g_varchar2,
421: p_description in varchar2 default hr_api.g_varchar2,
422: p_instructions in varchar2 default hr_api.g_varchar2,
423: p_date_from in date default hr_api.g_date,
424: p_date_to in date default hr_api.g_date,

Line 421: p_description in varchar2 default hr_api.g_varchar2,

417: p_effective_date in date,
418: p_appraisal_template_id in number,
419: p_object_version_number in out nocopy number,
420: p_name in varchar2 default hr_api.g_varchar2,
421: p_description in varchar2 default hr_api.g_varchar2,
422: p_instructions in varchar2 default hr_api.g_varchar2,
423: p_date_from in date default hr_api.g_date,
424: p_date_to in date default hr_api.g_date,
425: p_assessment_type_id in number default hr_api.g_number,

Line 422: p_instructions in varchar2 default hr_api.g_varchar2,

418: p_appraisal_template_id in number,
419: p_object_version_number in out nocopy number,
420: p_name in varchar2 default hr_api.g_varchar2,
421: p_description in varchar2 default hr_api.g_varchar2,
422: p_instructions in varchar2 default hr_api.g_varchar2,
423: p_date_from in date default hr_api.g_date,
424: p_date_to in date default hr_api.g_date,
425: p_assessment_type_id in number default hr_api.g_number,
426: p_rating_scale_id in number default hr_api.g_number,

Line 423: p_date_from in date default hr_api.g_date,

419: p_object_version_number in out nocopy number,
420: p_name in varchar2 default hr_api.g_varchar2,
421: p_description in varchar2 default hr_api.g_varchar2,
422: p_instructions in varchar2 default hr_api.g_varchar2,
423: p_date_from in date default hr_api.g_date,
424: p_date_to in date default hr_api.g_date,
425: p_assessment_type_id in number default hr_api.g_number,
426: p_rating_scale_id in number default hr_api.g_number,
427: p_questionnaire_template_id in number default hr_api.g_number,

Line 424: p_date_to in date default hr_api.g_date,

420: p_name in varchar2 default hr_api.g_varchar2,
421: p_description in varchar2 default hr_api.g_varchar2,
422: p_instructions in varchar2 default hr_api.g_varchar2,
423: p_date_from in date default hr_api.g_date,
424: p_date_to in date default hr_api.g_date,
425: p_assessment_type_id in number default hr_api.g_number,
426: p_rating_scale_id in number default hr_api.g_number,
427: p_questionnaire_template_id in number default hr_api.g_number,
428: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 425: p_assessment_type_id in number default hr_api.g_number,

421: p_description in varchar2 default hr_api.g_varchar2,
422: p_instructions in varchar2 default hr_api.g_varchar2,
423: p_date_from in date default hr_api.g_date,
424: p_date_to in date default hr_api.g_date,
425: p_assessment_type_id in number default hr_api.g_number,
426: p_rating_scale_id in number default hr_api.g_number,
427: p_questionnaire_template_id in number default hr_api.g_number,
428: p_attribute_category in varchar2 default hr_api.g_varchar2,
429: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 426: p_rating_scale_id in number default hr_api.g_number,

422: p_instructions in varchar2 default hr_api.g_varchar2,
423: p_date_from in date default hr_api.g_date,
424: p_date_to in date default hr_api.g_date,
425: p_assessment_type_id in number default hr_api.g_number,
426: p_rating_scale_id in number default hr_api.g_number,
427: p_questionnaire_template_id in number default hr_api.g_number,
428: p_attribute_category in varchar2 default hr_api.g_varchar2,
429: p_attribute1 in varchar2 default hr_api.g_varchar2,
430: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 427: p_questionnaire_template_id in number default hr_api.g_number,

423: p_date_from in date default hr_api.g_date,
424: p_date_to in date default hr_api.g_date,
425: p_assessment_type_id in number default hr_api.g_number,
426: p_rating_scale_id in number default hr_api.g_number,
427: p_questionnaire_template_id in number default hr_api.g_number,
428: p_attribute_category in varchar2 default hr_api.g_varchar2,
429: p_attribute1 in varchar2 default hr_api.g_varchar2,
430: p_attribute2 in varchar2 default hr_api.g_varchar2,
431: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 428: p_attribute_category in varchar2 default hr_api.g_varchar2,

424: p_date_to in date default hr_api.g_date,
425: p_assessment_type_id in number default hr_api.g_number,
426: p_rating_scale_id in number default hr_api.g_number,
427: p_questionnaire_template_id in number default hr_api.g_number,
428: p_attribute_category in varchar2 default hr_api.g_varchar2,
429: p_attribute1 in varchar2 default hr_api.g_varchar2,
430: p_attribute2 in varchar2 default hr_api.g_varchar2,
431: p_attribute3 in varchar2 default hr_api.g_varchar2,
432: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 429: p_attribute1 in varchar2 default hr_api.g_varchar2,

425: p_assessment_type_id in number default hr_api.g_number,
426: p_rating_scale_id in number default hr_api.g_number,
427: p_questionnaire_template_id in number default hr_api.g_number,
428: p_attribute_category in varchar2 default hr_api.g_varchar2,
429: p_attribute1 in varchar2 default hr_api.g_varchar2,
430: p_attribute2 in varchar2 default hr_api.g_varchar2,
431: p_attribute3 in varchar2 default hr_api.g_varchar2,
432: p_attribute4 in varchar2 default hr_api.g_varchar2,
433: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 430: p_attribute2 in varchar2 default hr_api.g_varchar2,

426: p_rating_scale_id in number default hr_api.g_number,
427: p_questionnaire_template_id in number default hr_api.g_number,
428: p_attribute_category in varchar2 default hr_api.g_varchar2,
429: p_attribute1 in varchar2 default hr_api.g_varchar2,
430: p_attribute2 in varchar2 default hr_api.g_varchar2,
431: p_attribute3 in varchar2 default hr_api.g_varchar2,
432: p_attribute4 in varchar2 default hr_api.g_varchar2,
433: p_attribute5 in varchar2 default hr_api.g_varchar2,
434: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 431: p_attribute3 in varchar2 default hr_api.g_varchar2,

427: p_questionnaire_template_id in number default hr_api.g_number,
428: p_attribute_category in varchar2 default hr_api.g_varchar2,
429: p_attribute1 in varchar2 default hr_api.g_varchar2,
430: p_attribute2 in varchar2 default hr_api.g_varchar2,
431: p_attribute3 in varchar2 default hr_api.g_varchar2,
432: p_attribute4 in varchar2 default hr_api.g_varchar2,
433: p_attribute5 in varchar2 default hr_api.g_varchar2,
434: p_attribute6 in varchar2 default hr_api.g_varchar2,
435: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 432: p_attribute4 in varchar2 default hr_api.g_varchar2,

428: p_attribute_category in varchar2 default hr_api.g_varchar2,
429: p_attribute1 in varchar2 default hr_api.g_varchar2,
430: p_attribute2 in varchar2 default hr_api.g_varchar2,
431: p_attribute3 in varchar2 default hr_api.g_varchar2,
432: p_attribute4 in varchar2 default hr_api.g_varchar2,
433: p_attribute5 in varchar2 default hr_api.g_varchar2,
434: p_attribute6 in varchar2 default hr_api.g_varchar2,
435: p_attribute7 in varchar2 default hr_api.g_varchar2,
436: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 433: p_attribute5 in varchar2 default hr_api.g_varchar2,

429: p_attribute1 in varchar2 default hr_api.g_varchar2,
430: p_attribute2 in varchar2 default hr_api.g_varchar2,
431: p_attribute3 in varchar2 default hr_api.g_varchar2,
432: p_attribute4 in varchar2 default hr_api.g_varchar2,
433: p_attribute5 in varchar2 default hr_api.g_varchar2,
434: p_attribute6 in varchar2 default hr_api.g_varchar2,
435: p_attribute7 in varchar2 default hr_api.g_varchar2,
436: p_attribute8 in varchar2 default hr_api.g_varchar2,
437: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 434: p_attribute6 in varchar2 default hr_api.g_varchar2,

430: p_attribute2 in varchar2 default hr_api.g_varchar2,
431: p_attribute3 in varchar2 default hr_api.g_varchar2,
432: p_attribute4 in varchar2 default hr_api.g_varchar2,
433: p_attribute5 in varchar2 default hr_api.g_varchar2,
434: p_attribute6 in varchar2 default hr_api.g_varchar2,
435: p_attribute7 in varchar2 default hr_api.g_varchar2,
436: p_attribute8 in varchar2 default hr_api.g_varchar2,
437: p_attribute9 in varchar2 default hr_api.g_varchar2,
438: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 435: p_attribute7 in varchar2 default hr_api.g_varchar2,

431: p_attribute3 in varchar2 default hr_api.g_varchar2,
432: p_attribute4 in varchar2 default hr_api.g_varchar2,
433: p_attribute5 in varchar2 default hr_api.g_varchar2,
434: p_attribute6 in varchar2 default hr_api.g_varchar2,
435: p_attribute7 in varchar2 default hr_api.g_varchar2,
436: p_attribute8 in varchar2 default hr_api.g_varchar2,
437: p_attribute9 in varchar2 default hr_api.g_varchar2,
438: p_attribute10 in varchar2 default hr_api.g_varchar2,
439: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 436: p_attribute8 in varchar2 default hr_api.g_varchar2,

432: p_attribute4 in varchar2 default hr_api.g_varchar2,
433: p_attribute5 in varchar2 default hr_api.g_varchar2,
434: p_attribute6 in varchar2 default hr_api.g_varchar2,
435: p_attribute7 in varchar2 default hr_api.g_varchar2,
436: p_attribute8 in varchar2 default hr_api.g_varchar2,
437: p_attribute9 in varchar2 default hr_api.g_varchar2,
438: p_attribute10 in varchar2 default hr_api.g_varchar2,
439: p_attribute11 in varchar2 default hr_api.g_varchar2,
440: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 437: p_attribute9 in varchar2 default hr_api.g_varchar2,

433: p_attribute5 in varchar2 default hr_api.g_varchar2,
434: p_attribute6 in varchar2 default hr_api.g_varchar2,
435: p_attribute7 in varchar2 default hr_api.g_varchar2,
436: p_attribute8 in varchar2 default hr_api.g_varchar2,
437: p_attribute9 in varchar2 default hr_api.g_varchar2,
438: p_attribute10 in varchar2 default hr_api.g_varchar2,
439: p_attribute11 in varchar2 default hr_api.g_varchar2,
440: p_attribute12 in varchar2 default hr_api.g_varchar2,
441: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 438: p_attribute10 in varchar2 default hr_api.g_varchar2,

434: p_attribute6 in varchar2 default hr_api.g_varchar2,
435: p_attribute7 in varchar2 default hr_api.g_varchar2,
436: p_attribute8 in varchar2 default hr_api.g_varchar2,
437: p_attribute9 in varchar2 default hr_api.g_varchar2,
438: p_attribute10 in varchar2 default hr_api.g_varchar2,
439: p_attribute11 in varchar2 default hr_api.g_varchar2,
440: p_attribute12 in varchar2 default hr_api.g_varchar2,
441: p_attribute13 in varchar2 default hr_api.g_varchar2,
442: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 439: p_attribute11 in varchar2 default hr_api.g_varchar2,

435: p_attribute7 in varchar2 default hr_api.g_varchar2,
436: p_attribute8 in varchar2 default hr_api.g_varchar2,
437: p_attribute9 in varchar2 default hr_api.g_varchar2,
438: p_attribute10 in varchar2 default hr_api.g_varchar2,
439: p_attribute11 in varchar2 default hr_api.g_varchar2,
440: p_attribute12 in varchar2 default hr_api.g_varchar2,
441: p_attribute13 in varchar2 default hr_api.g_varchar2,
442: p_attribute14 in varchar2 default hr_api.g_varchar2,
443: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 440: p_attribute12 in varchar2 default hr_api.g_varchar2,

436: p_attribute8 in varchar2 default hr_api.g_varchar2,
437: p_attribute9 in varchar2 default hr_api.g_varchar2,
438: p_attribute10 in varchar2 default hr_api.g_varchar2,
439: p_attribute11 in varchar2 default hr_api.g_varchar2,
440: p_attribute12 in varchar2 default hr_api.g_varchar2,
441: p_attribute13 in varchar2 default hr_api.g_varchar2,
442: p_attribute14 in varchar2 default hr_api.g_varchar2,
443: p_attribute15 in varchar2 default hr_api.g_varchar2,
444: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 441: p_attribute13 in varchar2 default hr_api.g_varchar2,

437: p_attribute9 in varchar2 default hr_api.g_varchar2,
438: p_attribute10 in varchar2 default hr_api.g_varchar2,
439: p_attribute11 in varchar2 default hr_api.g_varchar2,
440: p_attribute12 in varchar2 default hr_api.g_varchar2,
441: p_attribute13 in varchar2 default hr_api.g_varchar2,
442: p_attribute14 in varchar2 default hr_api.g_varchar2,
443: p_attribute15 in varchar2 default hr_api.g_varchar2,
444: p_attribute16 in varchar2 default hr_api.g_varchar2,
445: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 442: p_attribute14 in varchar2 default hr_api.g_varchar2,

438: p_attribute10 in varchar2 default hr_api.g_varchar2,
439: p_attribute11 in varchar2 default hr_api.g_varchar2,
440: p_attribute12 in varchar2 default hr_api.g_varchar2,
441: p_attribute13 in varchar2 default hr_api.g_varchar2,
442: p_attribute14 in varchar2 default hr_api.g_varchar2,
443: p_attribute15 in varchar2 default hr_api.g_varchar2,
444: p_attribute16 in varchar2 default hr_api.g_varchar2,
445: p_attribute17 in varchar2 default hr_api.g_varchar2,
446: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 443: p_attribute15 in varchar2 default hr_api.g_varchar2,

439: p_attribute11 in varchar2 default hr_api.g_varchar2,
440: p_attribute12 in varchar2 default hr_api.g_varchar2,
441: p_attribute13 in varchar2 default hr_api.g_varchar2,
442: p_attribute14 in varchar2 default hr_api.g_varchar2,
443: p_attribute15 in varchar2 default hr_api.g_varchar2,
444: p_attribute16 in varchar2 default hr_api.g_varchar2,
445: p_attribute17 in varchar2 default hr_api.g_varchar2,
446: p_attribute18 in varchar2 default hr_api.g_varchar2,
447: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 444: p_attribute16 in varchar2 default hr_api.g_varchar2,

440: p_attribute12 in varchar2 default hr_api.g_varchar2,
441: p_attribute13 in varchar2 default hr_api.g_varchar2,
442: p_attribute14 in varchar2 default hr_api.g_varchar2,
443: p_attribute15 in varchar2 default hr_api.g_varchar2,
444: p_attribute16 in varchar2 default hr_api.g_varchar2,
445: p_attribute17 in varchar2 default hr_api.g_varchar2,
446: p_attribute18 in varchar2 default hr_api.g_varchar2,
447: p_attribute19 in varchar2 default hr_api.g_varchar2,
448: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 445: p_attribute17 in varchar2 default hr_api.g_varchar2,

441: p_attribute13 in varchar2 default hr_api.g_varchar2,
442: p_attribute14 in varchar2 default hr_api.g_varchar2,
443: p_attribute15 in varchar2 default hr_api.g_varchar2,
444: p_attribute16 in varchar2 default hr_api.g_varchar2,
445: p_attribute17 in varchar2 default hr_api.g_varchar2,
446: p_attribute18 in varchar2 default hr_api.g_varchar2,
447: p_attribute19 in varchar2 default hr_api.g_varchar2,
448: p_attribute20 in varchar2 default hr_api.g_varchar2,
449: p_objective_asmnt_type_id in number default hr_api.g_number

Line 446: p_attribute18 in varchar2 default hr_api.g_varchar2,

442: p_attribute14 in varchar2 default hr_api.g_varchar2,
443: p_attribute15 in varchar2 default hr_api.g_varchar2,
444: p_attribute16 in varchar2 default hr_api.g_varchar2,
445: p_attribute17 in varchar2 default hr_api.g_varchar2,
446: p_attribute18 in varchar2 default hr_api.g_varchar2,
447: p_attribute19 in varchar2 default hr_api.g_varchar2,
448: p_attribute20 in varchar2 default hr_api.g_varchar2,
449: p_objective_asmnt_type_id in number default hr_api.g_number
450: ,p_ma_quest_template_id in number default hr_api.g_number

Line 447: p_attribute19 in varchar2 default hr_api.g_varchar2,

443: p_attribute15 in varchar2 default hr_api.g_varchar2,
444: p_attribute16 in varchar2 default hr_api.g_varchar2,
445: p_attribute17 in varchar2 default hr_api.g_varchar2,
446: p_attribute18 in varchar2 default hr_api.g_varchar2,
447: p_attribute19 in varchar2 default hr_api.g_varchar2,
448: p_attribute20 in varchar2 default hr_api.g_varchar2,
449: p_objective_asmnt_type_id in number default hr_api.g_number
450: ,p_ma_quest_template_id in number default hr_api.g_number
451: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2

Line 448: p_attribute20 in varchar2 default hr_api.g_varchar2,

444: p_attribute16 in varchar2 default hr_api.g_varchar2,
445: p_attribute17 in varchar2 default hr_api.g_varchar2,
446: p_attribute18 in varchar2 default hr_api.g_varchar2,
447: p_attribute19 in varchar2 default hr_api.g_varchar2,
448: p_attribute20 in varchar2 default hr_api.g_varchar2,
449: p_objective_asmnt_type_id in number default hr_api.g_number
450: ,p_ma_quest_template_id in number default hr_api.g_number
451: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
452: ,p_final_score_formula_id in number default hr_api.g_number

Line 449: p_objective_asmnt_type_id in number default hr_api.g_number

445: p_attribute17 in varchar2 default hr_api.g_varchar2,
446: p_attribute18 in varchar2 default hr_api.g_varchar2,
447: p_attribute19 in varchar2 default hr_api.g_varchar2,
448: p_attribute20 in varchar2 default hr_api.g_varchar2,
449: p_objective_asmnt_type_id in number default hr_api.g_number
450: ,p_ma_quest_template_id in number default hr_api.g_number
451: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
452: ,p_final_score_formula_id in number default hr_api.g_number
453: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2

Line 450: ,p_ma_quest_template_id in number default hr_api.g_number

446: p_attribute18 in varchar2 default hr_api.g_varchar2,
447: p_attribute19 in varchar2 default hr_api.g_varchar2,
448: p_attribute20 in varchar2 default hr_api.g_varchar2,
449: p_objective_asmnt_type_id in number default hr_api.g_number
450: ,p_ma_quest_template_id in number default hr_api.g_number
451: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
452: ,p_final_score_formula_id in number default hr_api.g_number
453: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
454: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2

Line 451: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2

447: p_attribute19 in varchar2 default hr_api.g_varchar2,
448: p_attribute20 in varchar2 default hr_api.g_varchar2,
449: p_objective_asmnt_type_id in number default hr_api.g_number
450: ,p_ma_quest_template_id in number default hr_api.g_number
451: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
452: ,p_final_score_formula_id in number default hr_api.g_number
453: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
454: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
455: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2

Line 452: ,p_final_score_formula_id in number default hr_api.g_number

448: p_attribute20 in varchar2 default hr_api.g_varchar2,
449: p_objective_asmnt_type_id in number default hr_api.g_number
450: ,p_ma_quest_template_id in number default hr_api.g_number
451: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
452: ,p_final_score_formula_id in number default hr_api.g_number
453: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
454: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
455: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
456: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2

Line 453: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2

449: p_objective_asmnt_type_id in number default hr_api.g_number
450: ,p_ma_quest_template_id in number default hr_api.g_number
451: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
452: ,p_final_score_formula_id in number default hr_api.g_number
453: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
454: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
455: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
456: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
457: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2

Line 454: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2

450: ,p_ma_quest_template_id in number default hr_api.g_number
451: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
452: ,p_final_score_formula_id in number default hr_api.g_number
453: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
454: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
455: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
456: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
457: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2

Line 455: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2

451: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
452: ,p_final_score_formula_id in number default hr_api.g_number
453: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
454: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
455: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
456: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
457: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
459: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2

Line 456: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2

452: ,p_final_score_formula_id in number default hr_api.g_number
453: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
454: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
455: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
456: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
457: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
459: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
460: ,p_show_participant_details in varchar2 default hr_api.g_varchar2

Line 457: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2

453: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
454: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
455: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
456: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
457: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
459: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
460: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
461: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2

Line 458: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2

454: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
455: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
456: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
457: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
459: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
460: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
461: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
462: ,p_show_additional_details in varchar2 default hr_api.g_varchar2

Line 459: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2

455: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
456: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
457: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
459: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
460: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
461: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
462: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
463: ,p_show_participant_names in varchar2 default hr_api.g_varchar2

Line 460: ,p_show_participant_details in varchar2 default hr_api.g_varchar2

456: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
457: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
459: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
460: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
461: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
462: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
463: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
464: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2

Line 461: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2

457: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
458: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
459: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
460: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
461: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
462: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
463: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
464: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
465: ,p_available_flag in varchar2 default hr_api.g_varchar2

Line 462: ,p_show_additional_details in varchar2 default hr_api.g_varchar2

458: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
459: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
460: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
461: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
462: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
463: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
464: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
465: ,p_available_flag in varchar2 default hr_api.g_varchar2
466: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2

Line 463: ,p_show_participant_names in varchar2 default hr_api.g_varchar2

459: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
460: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
461: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
462: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
463: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
464: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
465: ,p_available_flag in varchar2 default hr_api.g_varchar2
466: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
467: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2

Line 464: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2

460: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
461: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
462: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
463: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
464: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
465: ,p_available_flag in varchar2 default hr_api.g_varchar2
466: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
467: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
468: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2

Line 465: ,p_available_flag in varchar2 default hr_api.g_varchar2

461: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
462: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
463: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
464: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
465: ,p_available_flag in varchar2 default hr_api.g_varchar2
466: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
467: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
468: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
469: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2

Line 466: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2

462: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
463: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
464: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
465: ,p_available_flag in varchar2 default hr_api.g_varchar2
466: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
467: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
468: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
469: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
470: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2

Line 467: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2

463: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
464: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
465: ,p_available_flag in varchar2 default hr_api.g_varchar2
466: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
467: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
468: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
469: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
470: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
471: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2

Line 468: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2

464: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
465: ,p_available_flag in varchar2 default hr_api.g_varchar2
466: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
467: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
468: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
469: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
470: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
471: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2
472: ,p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix

Line 469: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2

465: ,p_available_flag in varchar2 default hr_api.g_varchar2
466: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
467: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
468: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
469: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
470: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
471: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2
472: ,p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
473:

Line 470: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2

466: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
467: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
468: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
469: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
470: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
471: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2
472: ,p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
473:
474: ,p_show_term_employee in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix

Line 471: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2

467: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
468: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
469: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
470: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
471: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2
472: ,p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
473:
474: ,p_show_term_employee in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
475: ,p_show_term_contigent in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix

Line 472: ,p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix

468: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
469: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
470: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
471: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2
472: ,p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
473:
474: ,p_show_term_employee in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
475: ,p_show_term_contigent in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
476: ,p_disp_term_emp_period_from in number default hr_api.g_number -- 6181267 bug fix

Line 474: ,p_show_term_employee in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix

470: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
471: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2
472: ,p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
473:
474: ,p_show_term_employee in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
475: ,p_show_term_contigent in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
476: ,p_disp_term_emp_period_from in number default hr_api.g_number -- 6181267 bug fix
477: ,p_SHOW_FUTURE_TERM_EMPLOYEE in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
478:

Line 475: ,p_show_term_contigent in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix

471: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2
472: ,p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
473:
474: ,p_show_term_employee in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
475: ,p_show_term_contigent in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
476: ,p_disp_term_emp_period_from in number default hr_api.g_number -- 6181267 bug fix
477: ,p_SHOW_FUTURE_TERM_EMPLOYEE in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
478:
479: ) is

Line 476: ,p_disp_term_emp_period_from in number default hr_api.g_number -- 6181267 bug fix

472: ,p_show_participant_comments in varchar2 default hr_api.g_varchar2 -- 8651478 bug fix
473:
474: ,p_show_term_employee in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
475: ,p_show_term_contigent in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
476: ,p_disp_term_emp_period_from in number default hr_api.g_number -- 6181267 bug fix
477: ,p_SHOW_FUTURE_TERM_EMPLOYEE in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
478:
479: ) is
480: --

Line 477: ,p_SHOW_FUTURE_TERM_EMPLOYEE in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix

473:
474: ,p_show_term_employee in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
475: ,p_show_term_contigent in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
476: ,p_disp_term_emp_period_from in number default hr_api.g_number -- 6181267 bug fix
477: ,p_SHOW_FUTURE_TERM_EMPLOYEE in varchar2 default hr_api.g_varchar2 -- 6181267 bug fix
478:
479: ) is
480: --
481: -- Declare cursors and local variables

Line 582: when hr_api.cannot_find_prog_unit then

578: ,p_SHOW_FUTURE_TERM_EMPLOYEE => p_SHOW_FUTURE_TERM_EMPLOYEE -- 6181267 bug fix
579:
580: );
581: exception
582: when hr_api.cannot_find_prog_unit then
583: hr_api.cannot_find_prog_unit_error
584: (p_module_name => 'update_appraisal_template',
585: p_hook_type => 'BP'
586: );

Line 583: hr_api.cannot_find_prog_unit_error

579:
580: );
581: exception
582: when hr_api.cannot_find_prog_unit then
583: hr_api.cannot_find_prog_unit_error
584: (p_module_name => 'update_appraisal_template',
585: p_hook_type => 'BP'
586: );
587: end;

Line 766: when hr_api.cannot_find_prog_unit then

762: ,p_SHOW_FUTURE_TERM_EMPLOYEE => p_SHOW_FUTURE_TERM_EMPLOYEE -- 6181267 bug fix
763:
764: );
765: exception
766: when hr_api.cannot_find_prog_unit then
767: hr_api.cannot_find_prog_unit_error
768: (p_module_name => 'update_appraisal_template',
769: p_hook_type => 'AP'
770: );

Line 767: hr_api.cannot_find_prog_unit_error

763:
764: );
765: exception
766: when hr_api.cannot_find_prog_unit then
767: hr_api.cannot_find_prog_unit_error
768: (p_module_name => 'update_appraisal_template',
769: p_hook_type => 'AP'
770: );
771: end;

Line 778: raise hr_api.validate_enabled;

774: --
775: -- When in validation only mode raise the Validate_Enabled exception
776: --
777: if p_validate then
778: raise hr_api.validate_enabled;
779: end if;
780: --
781: -- Set all output arguments. l_object_version_number now has the new
782: -- object version number as the update was successful

Line 788: when hr_api.validate_enabled then

784: p_object_version_number := l_object_version_number;
785: --
786: hr_utility.set_location(' Leaving:'||l_proc, 11);
787: exception
788: when hr_api.validate_enabled then
789: --
790: -- As the Validate_Enabled exception has been raised
791: -- we must rollback to the savepoint
792: --

Line 851: when hr_api.cannot_find_prog_unit then

847: p_appraisal_template_id => p_appraisal_template_id,
848: p_object_version_number => p_object_version_number
849: );
850: exception
851: when hr_api.cannot_find_prog_unit then
852: hr_api.cannot_find_prog_unit_error
853: (p_module_name => 'delete_appraisal_template',
854: p_hook_type => 'BP'
855: );

Line 852: hr_api.cannot_find_prog_unit_error

848: p_object_version_number => p_object_version_number
849: );
850: exception
851: when hr_api.cannot_find_prog_unit then
852: hr_api.cannot_find_prog_unit_error
853: (p_module_name => 'delete_appraisal_template',
854: p_hook_type => 'BP'
855: );
856: end;

Line 883: when hr_api.cannot_find_prog_unit then

879: hr_appraisal_templates_bk3.delete_appraisal_template_a (
880: p_appraisal_template_id => p_appraisal_template_id,
881: p_object_version_number => p_object_version_number );
882: exception
883: when hr_api.cannot_find_prog_unit then
884: hr_api.cannot_find_prog_unit_error
885: (p_module_name => 'delete_appraisal_template',
886: p_hook_type => 'AP'
887: );

Line 884: hr_api.cannot_find_prog_unit_error

880: p_appraisal_template_id => p_appraisal_template_id,
881: p_object_version_number => p_object_version_number );
882: exception
883: when hr_api.cannot_find_prog_unit then
884: hr_api.cannot_find_prog_unit_error
885: (p_module_name => 'delete_appraisal_template',
886: p_hook_type => 'AP'
887: );
888: end;

Line 895: raise hr_api.validate_enabled;

891: --
892: -- When in validation only mode raise the Validate_Enabled exception
893: --
894: if p_validate then
895: raise hr_api.validate_enabled;
896: end if;
897: --
898: hr_utility.set_location(' Leaving:'||l_proc, 11);
899: exception

Line 900: when hr_api.validate_enabled then

896: end if;
897: --
898: hr_utility.set_location(' Leaving:'||l_proc, 11);
899: exception
900: when hr_api.validate_enabled then
901: --
902: -- As the Validate_Enabled exception has been raised
903: -- we must rollback to the savepoint
904: --