DBA Data[Home] [Help]

APPS.HR_APPRAISAL_TEMPLATES_API dependencies on HR_API

Line 164: when hr_api.cannot_find_prog_unit then

160: ,p_part_app_off_template_code => p_part_app_off_template_code
161: ,p_part_rev_off_template_code => p_part_rev_off_template_code
162: );
163: exception
164: when hr_api.cannot_find_prog_unit then
165: hr_api.cannot_find_prog_unit_error
166: (p_module_name => 'create_appraisal_template',
167: p_hook_type => 'BP'
168: );

Line 165: hr_api.cannot_find_prog_unit_error

161: ,p_part_rev_off_template_code => p_part_rev_off_template_code
162: );
163: exception
164: when hr_api.cannot_find_prog_unit then
165: hr_api.cannot_find_prog_unit_error
166: (p_module_name => 'create_appraisal_template',
167: p_hook_type => 'BP'
168: );
169: end;

Line 337: when hr_api.cannot_find_prog_unit then

333: ,p_part_app_off_template_code => p_part_app_off_template_code
334: ,p_part_rev_off_template_code => p_part_rev_off_template_code
335: );
336: exception
337: when hr_api.cannot_find_prog_unit then
338: hr_api.cannot_find_prog_unit_error
339: (p_module_name => 'create_appraisal_template',
340: p_hook_type => 'AP'
341: );

Line 338: hr_api.cannot_find_prog_unit_error

334: ,p_part_rev_off_template_code => p_part_rev_off_template_code
335: );
336: exception
337: when hr_api.cannot_find_prog_unit then
338: hr_api.cannot_find_prog_unit_error
339: (p_module_name => 'create_appraisal_template',
340: p_hook_type => 'AP'
341: );
342: end;

Line 349: raise hr_api.validate_enabled;

345: --
346: -- When in validation only mode raise the Validate_Enabled exception
347: --
348: if p_validate then
349: raise hr_api.validate_enabled;
350: end if;
351: --
352: -- Set all output arguments
353: --

Line 359: when hr_api.validate_enabled then

355: p_object_version_number := l_object_version_number;
356: --
357: hr_utility.set_location(' Leaving:'||l_proc, 11);
358: exception
359: when hr_api.validate_enabled then
360: --
361: -- As the Validate_Enabled exception has been raised
362: -- we must rollback to the savepoint
363: --

Line 397: p_name in varchar2 default hr_api.g_varchar2,

393: (p_validate in boolean default false,
394: p_effective_date in date,
395: p_appraisal_template_id in number,
396: p_object_version_number in out nocopy number,
397: p_name in varchar2 default hr_api.g_varchar2,
398: p_description in varchar2 default hr_api.g_varchar2,
399: p_instructions in varchar2 default hr_api.g_varchar2,
400: p_date_from in date default hr_api.g_date,
401: p_date_to in date default hr_api.g_date,

Line 398: p_description in varchar2 default hr_api.g_varchar2,

394: p_effective_date in date,
395: p_appraisal_template_id in number,
396: p_object_version_number in out nocopy number,
397: p_name in varchar2 default hr_api.g_varchar2,
398: p_description in varchar2 default hr_api.g_varchar2,
399: p_instructions in varchar2 default hr_api.g_varchar2,
400: p_date_from in date default hr_api.g_date,
401: p_date_to in date default hr_api.g_date,
402: p_assessment_type_id in number default hr_api.g_number,

Line 399: p_instructions in varchar2 default hr_api.g_varchar2,

395: p_appraisal_template_id in number,
396: p_object_version_number in out nocopy number,
397: p_name in varchar2 default hr_api.g_varchar2,
398: p_description in varchar2 default hr_api.g_varchar2,
399: p_instructions in varchar2 default hr_api.g_varchar2,
400: p_date_from in date default hr_api.g_date,
401: p_date_to in date default hr_api.g_date,
402: p_assessment_type_id in number default hr_api.g_number,
403: p_rating_scale_id in number default hr_api.g_number,

Line 400: p_date_from in date default hr_api.g_date,

396: p_object_version_number in out nocopy number,
397: p_name in varchar2 default hr_api.g_varchar2,
398: p_description in varchar2 default hr_api.g_varchar2,
399: p_instructions in varchar2 default hr_api.g_varchar2,
400: p_date_from in date default hr_api.g_date,
401: p_date_to in date default hr_api.g_date,
402: p_assessment_type_id in number default hr_api.g_number,
403: p_rating_scale_id in number default hr_api.g_number,
404: p_questionnaire_template_id in number default hr_api.g_number,

Line 401: p_date_to in date default hr_api.g_date,

397: p_name in varchar2 default hr_api.g_varchar2,
398: p_description in varchar2 default hr_api.g_varchar2,
399: p_instructions in varchar2 default hr_api.g_varchar2,
400: p_date_from in date default hr_api.g_date,
401: p_date_to in date default hr_api.g_date,
402: p_assessment_type_id in number default hr_api.g_number,
403: p_rating_scale_id in number default hr_api.g_number,
404: p_questionnaire_template_id in number default hr_api.g_number,
405: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 402: p_assessment_type_id in number default hr_api.g_number,

398: p_description in varchar2 default hr_api.g_varchar2,
399: p_instructions in varchar2 default hr_api.g_varchar2,
400: p_date_from in date default hr_api.g_date,
401: p_date_to in date default hr_api.g_date,
402: p_assessment_type_id in number default hr_api.g_number,
403: p_rating_scale_id in number default hr_api.g_number,
404: p_questionnaire_template_id in number default hr_api.g_number,
405: p_attribute_category in varchar2 default hr_api.g_varchar2,
406: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 403: p_rating_scale_id in number default hr_api.g_number,

399: p_instructions in varchar2 default hr_api.g_varchar2,
400: p_date_from in date default hr_api.g_date,
401: p_date_to in date default hr_api.g_date,
402: p_assessment_type_id in number default hr_api.g_number,
403: p_rating_scale_id in number default hr_api.g_number,
404: p_questionnaire_template_id in number default hr_api.g_number,
405: p_attribute_category in varchar2 default hr_api.g_varchar2,
406: p_attribute1 in varchar2 default hr_api.g_varchar2,
407: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 404: p_questionnaire_template_id in number default hr_api.g_number,

400: p_date_from in date default hr_api.g_date,
401: p_date_to in date default hr_api.g_date,
402: p_assessment_type_id in number default hr_api.g_number,
403: p_rating_scale_id in number default hr_api.g_number,
404: p_questionnaire_template_id in number default hr_api.g_number,
405: p_attribute_category in varchar2 default hr_api.g_varchar2,
406: p_attribute1 in varchar2 default hr_api.g_varchar2,
407: p_attribute2 in varchar2 default hr_api.g_varchar2,
408: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 405: p_attribute_category in varchar2 default hr_api.g_varchar2,

401: p_date_to in date default hr_api.g_date,
402: p_assessment_type_id in number default hr_api.g_number,
403: p_rating_scale_id in number default hr_api.g_number,
404: p_questionnaire_template_id in number default hr_api.g_number,
405: p_attribute_category in varchar2 default hr_api.g_varchar2,
406: p_attribute1 in varchar2 default hr_api.g_varchar2,
407: p_attribute2 in varchar2 default hr_api.g_varchar2,
408: p_attribute3 in varchar2 default hr_api.g_varchar2,
409: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 406: p_attribute1 in varchar2 default hr_api.g_varchar2,

402: p_assessment_type_id in number default hr_api.g_number,
403: p_rating_scale_id in number default hr_api.g_number,
404: p_questionnaire_template_id in number default hr_api.g_number,
405: p_attribute_category in varchar2 default hr_api.g_varchar2,
406: p_attribute1 in varchar2 default hr_api.g_varchar2,
407: p_attribute2 in varchar2 default hr_api.g_varchar2,
408: p_attribute3 in varchar2 default hr_api.g_varchar2,
409: p_attribute4 in varchar2 default hr_api.g_varchar2,
410: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 407: p_attribute2 in varchar2 default hr_api.g_varchar2,

403: p_rating_scale_id in number default hr_api.g_number,
404: p_questionnaire_template_id in number default hr_api.g_number,
405: p_attribute_category in varchar2 default hr_api.g_varchar2,
406: p_attribute1 in varchar2 default hr_api.g_varchar2,
407: p_attribute2 in varchar2 default hr_api.g_varchar2,
408: p_attribute3 in varchar2 default hr_api.g_varchar2,
409: p_attribute4 in varchar2 default hr_api.g_varchar2,
410: p_attribute5 in varchar2 default hr_api.g_varchar2,
411: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 408: p_attribute3 in varchar2 default hr_api.g_varchar2,

404: p_questionnaire_template_id in number default hr_api.g_number,
405: p_attribute_category in varchar2 default hr_api.g_varchar2,
406: p_attribute1 in varchar2 default hr_api.g_varchar2,
407: p_attribute2 in varchar2 default hr_api.g_varchar2,
408: p_attribute3 in varchar2 default hr_api.g_varchar2,
409: p_attribute4 in varchar2 default hr_api.g_varchar2,
410: p_attribute5 in varchar2 default hr_api.g_varchar2,
411: p_attribute6 in varchar2 default hr_api.g_varchar2,
412: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 409: p_attribute4 in varchar2 default hr_api.g_varchar2,

405: p_attribute_category in varchar2 default hr_api.g_varchar2,
406: p_attribute1 in varchar2 default hr_api.g_varchar2,
407: p_attribute2 in varchar2 default hr_api.g_varchar2,
408: p_attribute3 in varchar2 default hr_api.g_varchar2,
409: p_attribute4 in varchar2 default hr_api.g_varchar2,
410: p_attribute5 in varchar2 default hr_api.g_varchar2,
411: p_attribute6 in varchar2 default hr_api.g_varchar2,
412: p_attribute7 in varchar2 default hr_api.g_varchar2,
413: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 410: p_attribute5 in varchar2 default hr_api.g_varchar2,

406: p_attribute1 in varchar2 default hr_api.g_varchar2,
407: p_attribute2 in varchar2 default hr_api.g_varchar2,
408: p_attribute3 in varchar2 default hr_api.g_varchar2,
409: p_attribute4 in varchar2 default hr_api.g_varchar2,
410: p_attribute5 in varchar2 default hr_api.g_varchar2,
411: p_attribute6 in varchar2 default hr_api.g_varchar2,
412: p_attribute7 in varchar2 default hr_api.g_varchar2,
413: p_attribute8 in varchar2 default hr_api.g_varchar2,
414: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 411: p_attribute6 in varchar2 default hr_api.g_varchar2,

407: p_attribute2 in varchar2 default hr_api.g_varchar2,
408: p_attribute3 in varchar2 default hr_api.g_varchar2,
409: p_attribute4 in varchar2 default hr_api.g_varchar2,
410: p_attribute5 in varchar2 default hr_api.g_varchar2,
411: p_attribute6 in varchar2 default hr_api.g_varchar2,
412: p_attribute7 in varchar2 default hr_api.g_varchar2,
413: p_attribute8 in varchar2 default hr_api.g_varchar2,
414: p_attribute9 in varchar2 default hr_api.g_varchar2,
415: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 412: p_attribute7 in varchar2 default hr_api.g_varchar2,

408: p_attribute3 in varchar2 default hr_api.g_varchar2,
409: p_attribute4 in varchar2 default hr_api.g_varchar2,
410: p_attribute5 in varchar2 default hr_api.g_varchar2,
411: p_attribute6 in varchar2 default hr_api.g_varchar2,
412: p_attribute7 in varchar2 default hr_api.g_varchar2,
413: p_attribute8 in varchar2 default hr_api.g_varchar2,
414: p_attribute9 in varchar2 default hr_api.g_varchar2,
415: p_attribute10 in varchar2 default hr_api.g_varchar2,
416: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 413: p_attribute8 in varchar2 default hr_api.g_varchar2,

409: p_attribute4 in varchar2 default hr_api.g_varchar2,
410: p_attribute5 in varchar2 default hr_api.g_varchar2,
411: p_attribute6 in varchar2 default hr_api.g_varchar2,
412: p_attribute7 in varchar2 default hr_api.g_varchar2,
413: p_attribute8 in varchar2 default hr_api.g_varchar2,
414: p_attribute9 in varchar2 default hr_api.g_varchar2,
415: p_attribute10 in varchar2 default hr_api.g_varchar2,
416: p_attribute11 in varchar2 default hr_api.g_varchar2,
417: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 414: p_attribute9 in varchar2 default hr_api.g_varchar2,

410: p_attribute5 in varchar2 default hr_api.g_varchar2,
411: p_attribute6 in varchar2 default hr_api.g_varchar2,
412: p_attribute7 in varchar2 default hr_api.g_varchar2,
413: p_attribute8 in varchar2 default hr_api.g_varchar2,
414: p_attribute9 in varchar2 default hr_api.g_varchar2,
415: p_attribute10 in varchar2 default hr_api.g_varchar2,
416: p_attribute11 in varchar2 default hr_api.g_varchar2,
417: p_attribute12 in varchar2 default hr_api.g_varchar2,
418: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 415: p_attribute10 in varchar2 default hr_api.g_varchar2,

411: p_attribute6 in varchar2 default hr_api.g_varchar2,
412: p_attribute7 in varchar2 default hr_api.g_varchar2,
413: p_attribute8 in varchar2 default hr_api.g_varchar2,
414: p_attribute9 in varchar2 default hr_api.g_varchar2,
415: p_attribute10 in varchar2 default hr_api.g_varchar2,
416: p_attribute11 in varchar2 default hr_api.g_varchar2,
417: p_attribute12 in varchar2 default hr_api.g_varchar2,
418: p_attribute13 in varchar2 default hr_api.g_varchar2,
419: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 416: p_attribute11 in varchar2 default hr_api.g_varchar2,

412: p_attribute7 in varchar2 default hr_api.g_varchar2,
413: p_attribute8 in varchar2 default hr_api.g_varchar2,
414: p_attribute9 in varchar2 default hr_api.g_varchar2,
415: p_attribute10 in varchar2 default hr_api.g_varchar2,
416: p_attribute11 in varchar2 default hr_api.g_varchar2,
417: p_attribute12 in varchar2 default hr_api.g_varchar2,
418: p_attribute13 in varchar2 default hr_api.g_varchar2,
419: p_attribute14 in varchar2 default hr_api.g_varchar2,
420: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 417: p_attribute12 in varchar2 default hr_api.g_varchar2,

413: p_attribute8 in varchar2 default hr_api.g_varchar2,
414: p_attribute9 in varchar2 default hr_api.g_varchar2,
415: p_attribute10 in varchar2 default hr_api.g_varchar2,
416: p_attribute11 in varchar2 default hr_api.g_varchar2,
417: p_attribute12 in varchar2 default hr_api.g_varchar2,
418: p_attribute13 in varchar2 default hr_api.g_varchar2,
419: p_attribute14 in varchar2 default hr_api.g_varchar2,
420: p_attribute15 in varchar2 default hr_api.g_varchar2,
421: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 418: p_attribute13 in varchar2 default hr_api.g_varchar2,

414: p_attribute9 in varchar2 default hr_api.g_varchar2,
415: p_attribute10 in varchar2 default hr_api.g_varchar2,
416: p_attribute11 in varchar2 default hr_api.g_varchar2,
417: p_attribute12 in varchar2 default hr_api.g_varchar2,
418: p_attribute13 in varchar2 default hr_api.g_varchar2,
419: p_attribute14 in varchar2 default hr_api.g_varchar2,
420: p_attribute15 in varchar2 default hr_api.g_varchar2,
421: p_attribute16 in varchar2 default hr_api.g_varchar2,
422: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 419: p_attribute14 in varchar2 default hr_api.g_varchar2,

415: p_attribute10 in varchar2 default hr_api.g_varchar2,
416: p_attribute11 in varchar2 default hr_api.g_varchar2,
417: p_attribute12 in varchar2 default hr_api.g_varchar2,
418: p_attribute13 in varchar2 default hr_api.g_varchar2,
419: p_attribute14 in varchar2 default hr_api.g_varchar2,
420: p_attribute15 in varchar2 default hr_api.g_varchar2,
421: p_attribute16 in varchar2 default hr_api.g_varchar2,
422: p_attribute17 in varchar2 default hr_api.g_varchar2,
423: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 420: p_attribute15 in varchar2 default hr_api.g_varchar2,

416: p_attribute11 in varchar2 default hr_api.g_varchar2,
417: p_attribute12 in varchar2 default hr_api.g_varchar2,
418: p_attribute13 in varchar2 default hr_api.g_varchar2,
419: p_attribute14 in varchar2 default hr_api.g_varchar2,
420: p_attribute15 in varchar2 default hr_api.g_varchar2,
421: p_attribute16 in varchar2 default hr_api.g_varchar2,
422: p_attribute17 in varchar2 default hr_api.g_varchar2,
423: p_attribute18 in varchar2 default hr_api.g_varchar2,
424: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 421: p_attribute16 in varchar2 default hr_api.g_varchar2,

417: p_attribute12 in varchar2 default hr_api.g_varchar2,
418: p_attribute13 in varchar2 default hr_api.g_varchar2,
419: p_attribute14 in varchar2 default hr_api.g_varchar2,
420: p_attribute15 in varchar2 default hr_api.g_varchar2,
421: p_attribute16 in varchar2 default hr_api.g_varchar2,
422: p_attribute17 in varchar2 default hr_api.g_varchar2,
423: p_attribute18 in varchar2 default hr_api.g_varchar2,
424: p_attribute19 in varchar2 default hr_api.g_varchar2,
425: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 422: p_attribute17 in varchar2 default hr_api.g_varchar2,

418: p_attribute13 in varchar2 default hr_api.g_varchar2,
419: p_attribute14 in varchar2 default hr_api.g_varchar2,
420: p_attribute15 in varchar2 default hr_api.g_varchar2,
421: p_attribute16 in varchar2 default hr_api.g_varchar2,
422: p_attribute17 in varchar2 default hr_api.g_varchar2,
423: p_attribute18 in varchar2 default hr_api.g_varchar2,
424: p_attribute19 in varchar2 default hr_api.g_varchar2,
425: p_attribute20 in varchar2 default hr_api.g_varchar2,
426: p_objective_asmnt_type_id in number default hr_api.g_number

Line 423: p_attribute18 in varchar2 default hr_api.g_varchar2,

419: p_attribute14 in varchar2 default hr_api.g_varchar2,
420: p_attribute15 in varchar2 default hr_api.g_varchar2,
421: p_attribute16 in varchar2 default hr_api.g_varchar2,
422: p_attribute17 in varchar2 default hr_api.g_varchar2,
423: p_attribute18 in varchar2 default hr_api.g_varchar2,
424: p_attribute19 in varchar2 default hr_api.g_varchar2,
425: p_attribute20 in varchar2 default hr_api.g_varchar2,
426: p_objective_asmnt_type_id in number default hr_api.g_number
427: ,p_ma_quest_template_id in number default hr_api.g_number

Line 424: p_attribute19 in varchar2 default hr_api.g_varchar2,

420: p_attribute15 in varchar2 default hr_api.g_varchar2,
421: p_attribute16 in varchar2 default hr_api.g_varchar2,
422: p_attribute17 in varchar2 default hr_api.g_varchar2,
423: p_attribute18 in varchar2 default hr_api.g_varchar2,
424: p_attribute19 in varchar2 default hr_api.g_varchar2,
425: p_attribute20 in varchar2 default hr_api.g_varchar2,
426: p_objective_asmnt_type_id in number default hr_api.g_number
427: ,p_ma_quest_template_id in number default hr_api.g_number
428: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2

Line 425: p_attribute20 in varchar2 default hr_api.g_varchar2,

421: p_attribute16 in varchar2 default hr_api.g_varchar2,
422: p_attribute17 in varchar2 default hr_api.g_varchar2,
423: p_attribute18 in varchar2 default hr_api.g_varchar2,
424: p_attribute19 in varchar2 default hr_api.g_varchar2,
425: p_attribute20 in varchar2 default hr_api.g_varchar2,
426: p_objective_asmnt_type_id in number default hr_api.g_number
427: ,p_ma_quest_template_id in number default hr_api.g_number
428: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
429: ,p_final_score_formula_id in number default hr_api.g_number

Line 426: p_objective_asmnt_type_id in number default hr_api.g_number

422: p_attribute17 in varchar2 default hr_api.g_varchar2,
423: p_attribute18 in varchar2 default hr_api.g_varchar2,
424: p_attribute19 in varchar2 default hr_api.g_varchar2,
425: p_attribute20 in varchar2 default hr_api.g_varchar2,
426: p_objective_asmnt_type_id in number default hr_api.g_number
427: ,p_ma_quest_template_id in number default hr_api.g_number
428: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
429: ,p_final_score_formula_id in number default hr_api.g_number
430: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2

Line 427: ,p_ma_quest_template_id in number default hr_api.g_number

423: p_attribute18 in varchar2 default hr_api.g_varchar2,
424: p_attribute19 in varchar2 default hr_api.g_varchar2,
425: p_attribute20 in varchar2 default hr_api.g_varchar2,
426: p_objective_asmnt_type_id in number default hr_api.g_number
427: ,p_ma_quest_template_id in number default hr_api.g_number
428: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
429: ,p_final_score_formula_id in number default hr_api.g_number
430: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
431: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2

Line 428: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2

424: p_attribute19 in varchar2 default hr_api.g_varchar2,
425: p_attribute20 in varchar2 default hr_api.g_varchar2,
426: p_objective_asmnt_type_id in number default hr_api.g_number
427: ,p_ma_quest_template_id in number default hr_api.g_number
428: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
429: ,p_final_score_formula_id in number default hr_api.g_number
430: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
431: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
432: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2

Line 429: ,p_final_score_formula_id in number default hr_api.g_number

425: p_attribute20 in varchar2 default hr_api.g_varchar2,
426: p_objective_asmnt_type_id in number default hr_api.g_number
427: ,p_ma_quest_template_id in number default hr_api.g_number
428: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
429: ,p_final_score_formula_id in number default hr_api.g_number
430: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
431: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
432: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
433: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2

Line 430: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2

426: p_objective_asmnt_type_id in number default hr_api.g_number
427: ,p_ma_quest_template_id in number default hr_api.g_number
428: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
429: ,p_final_score_formula_id in number default hr_api.g_number
430: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
431: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
432: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
433: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
434: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2

Line 431: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2

427: ,p_ma_quest_template_id in number default hr_api.g_number
428: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
429: ,p_final_score_formula_id in number default hr_api.g_number
430: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
431: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
432: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
433: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
434: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
435: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2

Line 432: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2

428: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
429: ,p_final_score_formula_id in number default hr_api.g_number
430: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
431: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
432: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
433: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
434: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
435: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
436: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2

Line 433: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2

429: ,p_final_score_formula_id in number default hr_api.g_number
430: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
431: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
432: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
433: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
434: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
435: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
436: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
437: ,p_show_participant_details in varchar2 default hr_api.g_varchar2

Line 434: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2

430: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
431: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
432: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
433: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
434: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
435: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
436: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
437: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
438: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2

Line 435: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2

431: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
432: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
433: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
434: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
435: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
436: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
437: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
438: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
439: ,p_show_additional_details in varchar2 default hr_api.g_varchar2

Line 436: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2

432: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
433: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
434: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
435: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
436: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
437: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
438: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
439: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
440: ,p_show_participant_names in varchar2 default hr_api.g_varchar2

Line 437: ,p_show_participant_details in varchar2 default hr_api.g_varchar2

433: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
434: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
435: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
436: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
437: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
438: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
439: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
440: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
441: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2

Line 438: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2

434: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
435: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
436: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
437: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
438: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
439: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
440: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
441: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
442: ,p_available_flag in varchar2 default hr_api.g_varchar2

Line 439: ,p_show_additional_details in varchar2 default hr_api.g_varchar2

435: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
436: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
437: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
438: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
439: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
440: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
441: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
442: ,p_available_flag in varchar2 default hr_api.g_varchar2
443: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2

Line 440: ,p_show_participant_names in varchar2 default hr_api.g_varchar2

436: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
437: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
438: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
439: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
440: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
441: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
442: ,p_available_flag in varchar2 default hr_api.g_varchar2
443: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
444: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2

Line 441: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2

437: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
438: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
439: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
440: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
441: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
442: ,p_available_flag in varchar2 default hr_api.g_varchar2
443: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
444: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
445: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2

Line 442: ,p_available_flag in varchar2 default hr_api.g_varchar2

438: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
439: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
440: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
441: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
442: ,p_available_flag in varchar2 default hr_api.g_varchar2
443: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
444: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
445: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
446: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2

Line 443: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2

439: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
440: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
441: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
442: ,p_available_flag in varchar2 default hr_api.g_varchar2
443: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
444: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
445: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
446: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
447: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2

Line 444: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2

440: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
441: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
442: ,p_available_flag in varchar2 default hr_api.g_varchar2
443: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
444: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
445: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
446: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
447: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
448: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2

Line 445: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2

441: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
442: ,p_available_flag in varchar2 default hr_api.g_varchar2
443: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
444: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
445: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
446: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
447: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
448: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2
449: ) is

Line 446: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2

442: ,p_available_flag in varchar2 default hr_api.g_varchar2
443: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
444: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
445: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
446: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
447: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
448: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2
449: ) is
450: --

Line 447: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2

443: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
444: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
445: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
446: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
447: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
448: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2
449: ) is
450: --
451: -- Declare cursors and local variables

Line 448: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2

444: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
445: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
446: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
447: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
448: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2
449: ) is
450: --
451: -- Declare cursors and local variables
452: --

Line 546: when hr_api.cannot_find_prog_unit then

542: ,p_part_app_off_template_code => p_part_app_off_template_code
543: ,p_part_rev_off_template_code => p_part_rev_off_template_code
544: );
545: exception
546: when hr_api.cannot_find_prog_unit then
547: hr_api.cannot_find_prog_unit_error
548: (p_module_name => 'update_appraisal_template',
549: p_hook_type => 'BP'
550: );

Line 547: hr_api.cannot_find_prog_unit_error

543: ,p_part_rev_off_template_code => p_part_rev_off_template_code
544: );
545: exception
546: when hr_api.cannot_find_prog_unit then
547: hr_api.cannot_find_prog_unit_error
548: (p_module_name => 'update_appraisal_template',
549: p_hook_type => 'BP'
550: );
551: end;

Line 718: when hr_api.cannot_find_prog_unit then

714: ,p_part_app_off_template_code => p_part_app_off_template_code
715: ,p_part_rev_off_template_code => p_part_rev_off_template_code
716: );
717: exception
718: when hr_api.cannot_find_prog_unit then
719: hr_api.cannot_find_prog_unit_error
720: (p_module_name => 'update_appraisal_template',
721: p_hook_type => 'AP'
722: );

Line 719: hr_api.cannot_find_prog_unit_error

715: ,p_part_rev_off_template_code => p_part_rev_off_template_code
716: );
717: exception
718: when hr_api.cannot_find_prog_unit then
719: hr_api.cannot_find_prog_unit_error
720: (p_module_name => 'update_appraisal_template',
721: p_hook_type => 'AP'
722: );
723: end;

Line 730: raise hr_api.validate_enabled;

726: --
727: -- When in validation only mode raise the Validate_Enabled exception
728: --
729: if p_validate then
730: raise hr_api.validate_enabled;
731: end if;
732: --
733: -- Set all output arguments. l_object_version_number now has the new
734: -- object version number as the update was successful

Line 740: when hr_api.validate_enabled then

736: p_object_version_number := l_object_version_number;
737: --
738: hr_utility.set_location(' Leaving:'||l_proc, 11);
739: exception
740: when hr_api.validate_enabled then
741: --
742: -- As the Validate_Enabled exception has been raised
743: -- we must rollback to the savepoint
744: --

Line 803: when hr_api.cannot_find_prog_unit then

799: p_appraisal_template_id => p_appraisal_template_id,
800: p_object_version_number => p_object_version_number
801: );
802: exception
803: when hr_api.cannot_find_prog_unit then
804: hr_api.cannot_find_prog_unit_error
805: (p_module_name => 'delete_appraisal_template',
806: p_hook_type => 'BP'
807: );

Line 804: hr_api.cannot_find_prog_unit_error

800: p_object_version_number => p_object_version_number
801: );
802: exception
803: when hr_api.cannot_find_prog_unit then
804: hr_api.cannot_find_prog_unit_error
805: (p_module_name => 'delete_appraisal_template',
806: p_hook_type => 'BP'
807: );
808: end;

Line 835: when hr_api.cannot_find_prog_unit then

831: hr_appraisal_templates_bk3.delete_appraisal_template_a (
832: p_appraisal_template_id => p_appraisal_template_id,
833: p_object_version_number => p_object_version_number );
834: exception
835: when hr_api.cannot_find_prog_unit then
836: hr_api.cannot_find_prog_unit_error
837: (p_module_name => 'delete_appraisal_template',
838: p_hook_type => 'AP'
839: );

Line 836: hr_api.cannot_find_prog_unit_error

832: p_appraisal_template_id => p_appraisal_template_id,
833: p_object_version_number => p_object_version_number );
834: exception
835: when hr_api.cannot_find_prog_unit then
836: hr_api.cannot_find_prog_unit_error
837: (p_module_name => 'delete_appraisal_template',
838: p_hook_type => 'AP'
839: );
840: end;

Line 847: raise hr_api.validate_enabled;

843: --
844: -- When in validation only mode raise the Validate_Enabled exception
845: --
846: if p_validate then
847: raise hr_api.validate_enabled;
848: end if;
849: --
850: hr_utility.set_location(' Leaving:'||l_proc, 11);
851: exception

Line 852: when hr_api.validate_enabled then

848: end if;
849: --
850: hr_utility.set_location(' Leaving:'||l_proc, 11);
851: exception
852: when hr_api.validate_enabled then
853: --
854: -- As the Validate_Enabled exception has been raised
855: -- we must rollback to the savepoint
856: --