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.HR_APPRAISAL_TEMPLATES_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |-----------------------< create_appraisal_template >----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_appraisal_template
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_business_group_id in number
15: ,p_appraisal_template_id in number
16: ,p_name in varchar2

Line 97: hr_api.constant_to_boolean

93: --
94: -- Convert constant values to their corresponding boolean value
95: --
96: l_validate :=
97: hr_api.constant_to_boolean
98: (p_constant_value => p_validate);
99: --
100: -- Register Surrogate ID or user key values
101: per_apt_ins.set_base_key_value(

Line 218: (p_validate in number default hr_api.g_false_num

214: -- ----------------------------------------------------------------------------
215: -- |-----------------------< delete_appraisal_template >----------------------|
216: -- ----------------------------------------------------------------------------
217: PROCEDURE delete_appraisal_template
218: (p_validate in number default hr_api.g_false_num
219: ,p_appraisal_template_id in number
220: ,p_object_version_number in number
221: ,p_return_status out nocopy varchar2
222: ) is

Line 248: hr_api.constant_to_boolean

244: --
245: -- Convert constant values to their corresponding boolean value
246: --
247: l_validate :=
248: hr_api.constant_to_boolean
249: (p_constant_value => p_validate);
250: --
251: -- Register Surrogate ID or user key values
252: --

Line 312: (p_validate in number default hr_api.g_false_num

308: -- ----------------------------------------------------------------------------
309: -- |-----------------------< update_appraisal_template >----------------------|
310: -- ----------------------------------------------------------------------------
311: PROCEDURE update_appraisal_template
312: (p_validate in number default hr_api.g_false_num
313: ,p_effective_date in date
314: ,p_appraisal_template_id in number
315: ,p_object_version_number in out nocopy number
316: ,p_name in varchar2 default hr_api.g_varchar2

Line 316: ,p_name in varchar2 default hr_api.g_varchar2

312: (p_validate in number default hr_api.g_false_num
313: ,p_effective_date in date
314: ,p_appraisal_template_id in number
315: ,p_object_version_number in out nocopy number
316: ,p_name in varchar2 default hr_api.g_varchar2
317: ,p_description in varchar2 default hr_api.g_varchar2
318: ,p_instructions in varchar2 default hr_api.g_varchar2
319: ,p_date_from in date default hr_api.g_date
320: ,p_date_to in date default hr_api.g_date

Line 317: ,p_description in varchar2 default hr_api.g_varchar2

313: ,p_effective_date in date
314: ,p_appraisal_template_id in number
315: ,p_object_version_number in out nocopy number
316: ,p_name in varchar2 default hr_api.g_varchar2
317: ,p_description in varchar2 default hr_api.g_varchar2
318: ,p_instructions in varchar2 default hr_api.g_varchar2
319: ,p_date_from in date default hr_api.g_date
320: ,p_date_to in date default hr_api.g_date
321: ,p_assessment_type_id in number default hr_api.g_number

Line 318: ,p_instructions in varchar2 default hr_api.g_varchar2

314: ,p_appraisal_template_id in number
315: ,p_object_version_number in out nocopy number
316: ,p_name in varchar2 default hr_api.g_varchar2
317: ,p_description in varchar2 default hr_api.g_varchar2
318: ,p_instructions in varchar2 default hr_api.g_varchar2
319: ,p_date_from in date default hr_api.g_date
320: ,p_date_to in date default hr_api.g_date
321: ,p_assessment_type_id in number default hr_api.g_number
322: ,p_rating_scale_id in number default hr_api.g_number

Line 319: ,p_date_from in date default hr_api.g_date

315: ,p_object_version_number in out nocopy number
316: ,p_name in varchar2 default hr_api.g_varchar2
317: ,p_description in varchar2 default hr_api.g_varchar2
318: ,p_instructions in varchar2 default hr_api.g_varchar2
319: ,p_date_from in date default hr_api.g_date
320: ,p_date_to in date default hr_api.g_date
321: ,p_assessment_type_id in number default hr_api.g_number
322: ,p_rating_scale_id in number default hr_api.g_number
323: ,p_questionnaire_template_id in number default hr_api.g_number

Line 320: ,p_date_to in date default hr_api.g_date

316: ,p_name in varchar2 default hr_api.g_varchar2
317: ,p_description in varchar2 default hr_api.g_varchar2
318: ,p_instructions in varchar2 default hr_api.g_varchar2
319: ,p_date_from in date default hr_api.g_date
320: ,p_date_to in date default hr_api.g_date
321: ,p_assessment_type_id in number default hr_api.g_number
322: ,p_rating_scale_id in number default hr_api.g_number
323: ,p_questionnaire_template_id in number default hr_api.g_number
324: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 321: ,p_assessment_type_id in number default hr_api.g_number

317: ,p_description in varchar2 default hr_api.g_varchar2
318: ,p_instructions in varchar2 default hr_api.g_varchar2
319: ,p_date_from in date default hr_api.g_date
320: ,p_date_to in date default hr_api.g_date
321: ,p_assessment_type_id in number default hr_api.g_number
322: ,p_rating_scale_id in number default hr_api.g_number
323: ,p_questionnaire_template_id in number default hr_api.g_number
324: ,p_attribute_category in varchar2 default hr_api.g_varchar2
325: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 322: ,p_rating_scale_id in number default hr_api.g_number

318: ,p_instructions in varchar2 default hr_api.g_varchar2
319: ,p_date_from in date default hr_api.g_date
320: ,p_date_to in date default hr_api.g_date
321: ,p_assessment_type_id in number default hr_api.g_number
322: ,p_rating_scale_id in number default hr_api.g_number
323: ,p_questionnaire_template_id in number default hr_api.g_number
324: ,p_attribute_category in varchar2 default hr_api.g_varchar2
325: ,p_attribute1 in varchar2 default hr_api.g_varchar2
326: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 323: ,p_questionnaire_template_id in number default hr_api.g_number

319: ,p_date_from in date default hr_api.g_date
320: ,p_date_to in date default hr_api.g_date
321: ,p_assessment_type_id in number default hr_api.g_number
322: ,p_rating_scale_id in number default hr_api.g_number
323: ,p_questionnaire_template_id in number default hr_api.g_number
324: ,p_attribute_category in varchar2 default hr_api.g_varchar2
325: ,p_attribute1 in varchar2 default hr_api.g_varchar2
326: ,p_attribute2 in varchar2 default hr_api.g_varchar2
327: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 324: ,p_attribute_category in varchar2 default hr_api.g_varchar2

320: ,p_date_to in date default hr_api.g_date
321: ,p_assessment_type_id in number default hr_api.g_number
322: ,p_rating_scale_id in number default hr_api.g_number
323: ,p_questionnaire_template_id in number default hr_api.g_number
324: ,p_attribute_category in varchar2 default hr_api.g_varchar2
325: ,p_attribute1 in varchar2 default hr_api.g_varchar2
326: ,p_attribute2 in varchar2 default hr_api.g_varchar2
327: ,p_attribute3 in varchar2 default hr_api.g_varchar2
328: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 325: ,p_attribute1 in varchar2 default hr_api.g_varchar2

321: ,p_assessment_type_id in number default hr_api.g_number
322: ,p_rating_scale_id in number default hr_api.g_number
323: ,p_questionnaire_template_id in number default hr_api.g_number
324: ,p_attribute_category in varchar2 default hr_api.g_varchar2
325: ,p_attribute1 in varchar2 default hr_api.g_varchar2
326: ,p_attribute2 in varchar2 default hr_api.g_varchar2
327: ,p_attribute3 in varchar2 default hr_api.g_varchar2
328: ,p_attribute4 in varchar2 default hr_api.g_varchar2
329: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 326: ,p_attribute2 in varchar2 default hr_api.g_varchar2

322: ,p_rating_scale_id in number default hr_api.g_number
323: ,p_questionnaire_template_id in number default hr_api.g_number
324: ,p_attribute_category in varchar2 default hr_api.g_varchar2
325: ,p_attribute1 in varchar2 default hr_api.g_varchar2
326: ,p_attribute2 in varchar2 default hr_api.g_varchar2
327: ,p_attribute3 in varchar2 default hr_api.g_varchar2
328: ,p_attribute4 in varchar2 default hr_api.g_varchar2
329: ,p_attribute5 in varchar2 default hr_api.g_varchar2
330: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 327: ,p_attribute3 in varchar2 default hr_api.g_varchar2

323: ,p_questionnaire_template_id in number default hr_api.g_number
324: ,p_attribute_category in varchar2 default hr_api.g_varchar2
325: ,p_attribute1 in varchar2 default hr_api.g_varchar2
326: ,p_attribute2 in varchar2 default hr_api.g_varchar2
327: ,p_attribute3 in varchar2 default hr_api.g_varchar2
328: ,p_attribute4 in varchar2 default hr_api.g_varchar2
329: ,p_attribute5 in varchar2 default hr_api.g_varchar2
330: ,p_attribute6 in varchar2 default hr_api.g_varchar2
331: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 328: ,p_attribute4 in varchar2 default hr_api.g_varchar2

324: ,p_attribute_category in varchar2 default hr_api.g_varchar2
325: ,p_attribute1 in varchar2 default hr_api.g_varchar2
326: ,p_attribute2 in varchar2 default hr_api.g_varchar2
327: ,p_attribute3 in varchar2 default hr_api.g_varchar2
328: ,p_attribute4 in varchar2 default hr_api.g_varchar2
329: ,p_attribute5 in varchar2 default hr_api.g_varchar2
330: ,p_attribute6 in varchar2 default hr_api.g_varchar2
331: ,p_attribute7 in varchar2 default hr_api.g_varchar2
332: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 329: ,p_attribute5 in varchar2 default hr_api.g_varchar2

325: ,p_attribute1 in varchar2 default hr_api.g_varchar2
326: ,p_attribute2 in varchar2 default hr_api.g_varchar2
327: ,p_attribute3 in varchar2 default hr_api.g_varchar2
328: ,p_attribute4 in varchar2 default hr_api.g_varchar2
329: ,p_attribute5 in varchar2 default hr_api.g_varchar2
330: ,p_attribute6 in varchar2 default hr_api.g_varchar2
331: ,p_attribute7 in varchar2 default hr_api.g_varchar2
332: ,p_attribute8 in varchar2 default hr_api.g_varchar2
333: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 330: ,p_attribute6 in varchar2 default hr_api.g_varchar2

326: ,p_attribute2 in varchar2 default hr_api.g_varchar2
327: ,p_attribute3 in varchar2 default hr_api.g_varchar2
328: ,p_attribute4 in varchar2 default hr_api.g_varchar2
329: ,p_attribute5 in varchar2 default hr_api.g_varchar2
330: ,p_attribute6 in varchar2 default hr_api.g_varchar2
331: ,p_attribute7 in varchar2 default hr_api.g_varchar2
332: ,p_attribute8 in varchar2 default hr_api.g_varchar2
333: ,p_attribute9 in varchar2 default hr_api.g_varchar2
334: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 331: ,p_attribute7 in varchar2 default hr_api.g_varchar2

327: ,p_attribute3 in varchar2 default hr_api.g_varchar2
328: ,p_attribute4 in varchar2 default hr_api.g_varchar2
329: ,p_attribute5 in varchar2 default hr_api.g_varchar2
330: ,p_attribute6 in varchar2 default hr_api.g_varchar2
331: ,p_attribute7 in varchar2 default hr_api.g_varchar2
332: ,p_attribute8 in varchar2 default hr_api.g_varchar2
333: ,p_attribute9 in varchar2 default hr_api.g_varchar2
334: ,p_attribute10 in varchar2 default hr_api.g_varchar2
335: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 332: ,p_attribute8 in varchar2 default hr_api.g_varchar2

328: ,p_attribute4 in varchar2 default hr_api.g_varchar2
329: ,p_attribute5 in varchar2 default hr_api.g_varchar2
330: ,p_attribute6 in varchar2 default hr_api.g_varchar2
331: ,p_attribute7 in varchar2 default hr_api.g_varchar2
332: ,p_attribute8 in varchar2 default hr_api.g_varchar2
333: ,p_attribute9 in varchar2 default hr_api.g_varchar2
334: ,p_attribute10 in varchar2 default hr_api.g_varchar2
335: ,p_attribute11 in varchar2 default hr_api.g_varchar2
336: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 333: ,p_attribute9 in varchar2 default hr_api.g_varchar2

329: ,p_attribute5 in varchar2 default hr_api.g_varchar2
330: ,p_attribute6 in varchar2 default hr_api.g_varchar2
331: ,p_attribute7 in varchar2 default hr_api.g_varchar2
332: ,p_attribute8 in varchar2 default hr_api.g_varchar2
333: ,p_attribute9 in varchar2 default hr_api.g_varchar2
334: ,p_attribute10 in varchar2 default hr_api.g_varchar2
335: ,p_attribute11 in varchar2 default hr_api.g_varchar2
336: ,p_attribute12 in varchar2 default hr_api.g_varchar2
337: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 334: ,p_attribute10 in varchar2 default hr_api.g_varchar2

330: ,p_attribute6 in varchar2 default hr_api.g_varchar2
331: ,p_attribute7 in varchar2 default hr_api.g_varchar2
332: ,p_attribute8 in varchar2 default hr_api.g_varchar2
333: ,p_attribute9 in varchar2 default hr_api.g_varchar2
334: ,p_attribute10 in varchar2 default hr_api.g_varchar2
335: ,p_attribute11 in varchar2 default hr_api.g_varchar2
336: ,p_attribute12 in varchar2 default hr_api.g_varchar2
337: ,p_attribute13 in varchar2 default hr_api.g_varchar2
338: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 335: ,p_attribute11 in varchar2 default hr_api.g_varchar2

331: ,p_attribute7 in varchar2 default hr_api.g_varchar2
332: ,p_attribute8 in varchar2 default hr_api.g_varchar2
333: ,p_attribute9 in varchar2 default hr_api.g_varchar2
334: ,p_attribute10 in varchar2 default hr_api.g_varchar2
335: ,p_attribute11 in varchar2 default hr_api.g_varchar2
336: ,p_attribute12 in varchar2 default hr_api.g_varchar2
337: ,p_attribute13 in varchar2 default hr_api.g_varchar2
338: ,p_attribute14 in varchar2 default hr_api.g_varchar2
339: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 336: ,p_attribute12 in varchar2 default hr_api.g_varchar2

332: ,p_attribute8 in varchar2 default hr_api.g_varchar2
333: ,p_attribute9 in varchar2 default hr_api.g_varchar2
334: ,p_attribute10 in varchar2 default hr_api.g_varchar2
335: ,p_attribute11 in varchar2 default hr_api.g_varchar2
336: ,p_attribute12 in varchar2 default hr_api.g_varchar2
337: ,p_attribute13 in varchar2 default hr_api.g_varchar2
338: ,p_attribute14 in varchar2 default hr_api.g_varchar2
339: ,p_attribute15 in varchar2 default hr_api.g_varchar2
340: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 337: ,p_attribute13 in varchar2 default hr_api.g_varchar2

333: ,p_attribute9 in varchar2 default hr_api.g_varchar2
334: ,p_attribute10 in varchar2 default hr_api.g_varchar2
335: ,p_attribute11 in varchar2 default hr_api.g_varchar2
336: ,p_attribute12 in varchar2 default hr_api.g_varchar2
337: ,p_attribute13 in varchar2 default hr_api.g_varchar2
338: ,p_attribute14 in varchar2 default hr_api.g_varchar2
339: ,p_attribute15 in varchar2 default hr_api.g_varchar2
340: ,p_attribute16 in varchar2 default hr_api.g_varchar2
341: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 338: ,p_attribute14 in varchar2 default hr_api.g_varchar2

334: ,p_attribute10 in varchar2 default hr_api.g_varchar2
335: ,p_attribute11 in varchar2 default hr_api.g_varchar2
336: ,p_attribute12 in varchar2 default hr_api.g_varchar2
337: ,p_attribute13 in varchar2 default hr_api.g_varchar2
338: ,p_attribute14 in varchar2 default hr_api.g_varchar2
339: ,p_attribute15 in varchar2 default hr_api.g_varchar2
340: ,p_attribute16 in varchar2 default hr_api.g_varchar2
341: ,p_attribute17 in varchar2 default hr_api.g_varchar2
342: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 339: ,p_attribute15 in varchar2 default hr_api.g_varchar2

335: ,p_attribute11 in varchar2 default hr_api.g_varchar2
336: ,p_attribute12 in varchar2 default hr_api.g_varchar2
337: ,p_attribute13 in varchar2 default hr_api.g_varchar2
338: ,p_attribute14 in varchar2 default hr_api.g_varchar2
339: ,p_attribute15 in varchar2 default hr_api.g_varchar2
340: ,p_attribute16 in varchar2 default hr_api.g_varchar2
341: ,p_attribute17 in varchar2 default hr_api.g_varchar2
342: ,p_attribute18 in varchar2 default hr_api.g_varchar2
343: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 340: ,p_attribute16 in varchar2 default hr_api.g_varchar2

336: ,p_attribute12 in varchar2 default hr_api.g_varchar2
337: ,p_attribute13 in varchar2 default hr_api.g_varchar2
338: ,p_attribute14 in varchar2 default hr_api.g_varchar2
339: ,p_attribute15 in varchar2 default hr_api.g_varchar2
340: ,p_attribute16 in varchar2 default hr_api.g_varchar2
341: ,p_attribute17 in varchar2 default hr_api.g_varchar2
342: ,p_attribute18 in varchar2 default hr_api.g_varchar2
343: ,p_attribute19 in varchar2 default hr_api.g_varchar2
344: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 341: ,p_attribute17 in varchar2 default hr_api.g_varchar2

337: ,p_attribute13 in varchar2 default hr_api.g_varchar2
338: ,p_attribute14 in varchar2 default hr_api.g_varchar2
339: ,p_attribute15 in varchar2 default hr_api.g_varchar2
340: ,p_attribute16 in varchar2 default hr_api.g_varchar2
341: ,p_attribute17 in varchar2 default hr_api.g_varchar2
342: ,p_attribute18 in varchar2 default hr_api.g_varchar2
343: ,p_attribute19 in varchar2 default hr_api.g_varchar2
344: ,p_attribute20 in varchar2 default hr_api.g_varchar2
345: ,p_objective_asmnt_type_id in number default hr_api.g_number

Line 342: ,p_attribute18 in varchar2 default hr_api.g_varchar2

338: ,p_attribute14 in varchar2 default hr_api.g_varchar2
339: ,p_attribute15 in varchar2 default hr_api.g_varchar2
340: ,p_attribute16 in varchar2 default hr_api.g_varchar2
341: ,p_attribute17 in varchar2 default hr_api.g_varchar2
342: ,p_attribute18 in varchar2 default hr_api.g_varchar2
343: ,p_attribute19 in varchar2 default hr_api.g_varchar2
344: ,p_attribute20 in varchar2 default hr_api.g_varchar2
345: ,p_objective_asmnt_type_id in number default hr_api.g_number
346: ,p_ma_quest_template_id in number default hr_api.g_number

Line 343: ,p_attribute19 in varchar2 default hr_api.g_varchar2

339: ,p_attribute15 in varchar2 default hr_api.g_varchar2
340: ,p_attribute16 in varchar2 default hr_api.g_varchar2
341: ,p_attribute17 in varchar2 default hr_api.g_varchar2
342: ,p_attribute18 in varchar2 default hr_api.g_varchar2
343: ,p_attribute19 in varchar2 default hr_api.g_varchar2
344: ,p_attribute20 in varchar2 default hr_api.g_varchar2
345: ,p_objective_asmnt_type_id in number default hr_api.g_number
346: ,p_ma_quest_template_id in number default hr_api.g_number
347: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2

Line 344: ,p_attribute20 in varchar2 default hr_api.g_varchar2

340: ,p_attribute16 in varchar2 default hr_api.g_varchar2
341: ,p_attribute17 in varchar2 default hr_api.g_varchar2
342: ,p_attribute18 in varchar2 default hr_api.g_varchar2
343: ,p_attribute19 in varchar2 default hr_api.g_varchar2
344: ,p_attribute20 in varchar2 default hr_api.g_varchar2
345: ,p_objective_asmnt_type_id in number default hr_api.g_number
346: ,p_ma_quest_template_id in number default hr_api.g_number
347: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
348: ,p_final_score_formula_id in number default hr_api.g_number

Line 345: ,p_objective_asmnt_type_id in number default hr_api.g_number

341: ,p_attribute17 in varchar2 default hr_api.g_varchar2
342: ,p_attribute18 in varchar2 default hr_api.g_varchar2
343: ,p_attribute19 in varchar2 default hr_api.g_varchar2
344: ,p_attribute20 in varchar2 default hr_api.g_varchar2
345: ,p_objective_asmnt_type_id in number default hr_api.g_number
346: ,p_ma_quest_template_id in number default hr_api.g_number
347: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
348: ,p_final_score_formula_id in number default hr_api.g_number
349: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2

Line 346: ,p_ma_quest_template_id in number default hr_api.g_number

342: ,p_attribute18 in varchar2 default hr_api.g_varchar2
343: ,p_attribute19 in varchar2 default hr_api.g_varchar2
344: ,p_attribute20 in varchar2 default hr_api.g_varchar2
345: ,p_objective_asmnt_type_id in number default hr_api.g_number
346: ,p_ma_quest_template_id in number default hr_api.g_number
347: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
348: ,p_final_score_formula_id in number default hr_api.g_number
349: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
350: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2

Line 347: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2

343: ,p_attribute19 in varchar2 default hr_api.g_varchar2
344: ,p_attribute20 in varchar2 default hr_api.g_varchar2
345: ,p_objective_asmnt_type_id in number default hr_api.g_number
346: ,p_ma_quest_template_id in number default hr_api.g_number
347: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
348: ,p_final_score_formula_id in number default hr_api.g_number
349: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
350: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
351: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2

Line 348: ,p_final_score_formula_id in number default hr_api.g_number

344: ,p_attribute20 in varchar2 default hr_api.g_varchar2
345: ,p_objective_asmnt_type_id in number default hr_api.g_number
346: ,p_ma_quest_template_id in number default hr_api.g_number
347: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
348: ,p_final_score_formula_id in number default hr_api.g_number
349: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
350: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
351: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
352: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2

Line 349: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2

345: ,p_objective_asmnt_type_id in number default hr_api.g_number
346: ,p_ma_quest_template_id in number default hr_api.g_number
347: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
348: ,p_final_score_formula_id in number default hr_api.g_number
349: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
350: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
351: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
352: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
353: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2

Line 350: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2

346: ,p_ma_quest_template_id in number default hr_api.g_number
347: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
348: ,p_final_score_formula_id in number default hr_api.g_number
349: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
350: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
351: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
352: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
353: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
354: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2

Line 351: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2

347: ,p_link_appr_to_learning_path in varchar2 default hr_api.g_varchar2
348: ,p_final_score_formula_id in number default hr_api.g_number
349: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
350: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
351: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
352: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
353: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
354: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
355: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2

Line 352: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2

348: ,p_final_score_formula_id in number default hr_api.g_number
349: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
350: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
351: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
352: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
353: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
354: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
355: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
356: ,p_show_participant_details in varchar2 default hr_api.g_varchar2

Line 353: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2

349: ,p_update_personal_comp_profile in varchar2 default hr_api.g_varchar2
350: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
351: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
352: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
353: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
354: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
355: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
356: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
357: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2

Line 354: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2

350: ,p_comp_profile_source_type in varchar2 default hr_api.g_varchar2
351: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
352: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
353: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
354: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
355: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
356: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
357: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
358: ,p_show_additional_details in varchar2 default hr_api.g_varchar2

Line 355: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2

351: ,p_show_competency_ratings in varchar2 default hr_api.g_varchar2
352: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
353: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
354: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
355: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
356: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
357: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
358: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
359: ,p_show_participant_names in varchar2 default hr_api.g_varchar2

Line 356: ,p_show_participant_details in varchar2 default hr_api.g_varchar2

352: ,p_show_objective_ratings in varchar2 default hr_api.g_varchar2
353: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
354: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
355: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
356: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
357: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
358: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
359: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
360: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2

Line 357: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2

353: ,p_show_overall_ratings in varchar2 default hr_api.g_varchar2
354: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
355: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
356: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
357: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
358: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
359: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
360: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
361: ,p_available_flag in varchar2 default hr_api.g_varchar2

Line 358: ,p_show_additional_details in varchar2 default hr_api.g_varchar2

354: ,p_show_overall_comments in varchar2 default hr_api.g_varchar2
355: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
356: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
357: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
358: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
359: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
360: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
361: ,p_available_flag in varchar2 default hr_api.g_varchar2
362: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2

Line 359: ,p_show_participant_names in varchar2 default hr_api.g_varchar2

355: ,p_provide_overall_feedback in varchar2 default hr_api.g_varchar2
356: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
357: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
358: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
359: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
360: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
361: ,p_available_flag in varchar2 default hr_api.g_varchar2
362: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
363: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2

Line 360: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2

356: ,p_show_participant_details in varchar2 default hr_api.g_varchar2
357: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
358: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
359: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
360: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
361: ,p_available_flag in varchar2 default hr_api.g_varchar2
362: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
363: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
364: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2

Line 361: ,p_available_flag in varchar2 default hr_api.g_varchar2

357: ,p_allow_add_participant in varchar2 default hr_api.g_varchar2
358: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
359: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
360: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
361: ,p_available_flag in varchar2 default hr_api.g_varchar2
362: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
363: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
364: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
365: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2

Line 362: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2

358: ,p_show_additional_details in varchar2 default hr_api.g_varchar2
359: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
360: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
361: ,p_available_flag in varchar2 default hr_api.g_varchar2
362: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
363: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
364: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
365: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
366: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2

Line 363: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2

359: ,p_show_participant_names in varchar2 default hr_api.g_varchar2
360: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
361: ,p_available_flag in varchar2 default hr_api.g_varchar2
362: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
363: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
364: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
365: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
366: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
367: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2

Line 364: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2

360: ,p_show_participant_ratings in varchar2 default hr_api.g_varchar2
361: ,p_available_flag in varchar2 default hr_api.g_varchar2
362: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
363: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
364: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
365: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
366: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
367: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2
368: ,p_return_status out nocopy varchar2

Line 365: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2

361: ,p_available_flag in varchar2 default hr_api.g_varchar2
362: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
363: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
364: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
365: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
366: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
367: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2
368: ,p_return_status out nocopy varchar2
369: ) is

Line 366: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2

362: ,p_show_questionnaire_info in varchar2 default hr_api.g_varchar2
363: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
364: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
365: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
366: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
367: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2
368: ,p_return_status out nocopy varchar2
369: ) is
370: --

Line 367: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2

363: ,p_ma_off_template_code in varchar2 default hr_api.g_varchar2
364: ,p_appraisee_off_template_code in varchar2 default hr_api.g_varchar2
365: ,p_other_part_off_template_code in varchar2 default hr_api.g_varchar2
366: ,p_part_app_off_template_code in varchar2 default hr_api.g_varchar2
367: ,p_part_rev_off_template_code in varchar2 default hr_api.g_varchar2
368: ,p_return_status out nocopy varchar2
369: ) is
370: --
371: -- Variables for API Boolean parameters

Line 397: hr_api.constant_to_boolean

393: --
394: -- Convert constant values to their corresponding boolean value
395: --
396: l_validate :=
397: hr_api.constant_to_boolean
398: (p_constant_value => p_validate);
399: --
400: -- Register Surrogate ID or user key values
401: --