APPS.PER_PRT_BUS dependencies on PER_APPRAISAL_TEMPLATES

Line 329: -- per_appraisal_templates

325: -- Description:
326: -- - Checks that the specified rating_level_id exists in per_rating_levels
327: -- for the same business group.
328: -- - Checks that the rating scale in per_rating_levels also exists in
329: -- per_appraisal_templates
330:
331: -- Pre-requisites:
332: -- - None
333:

Line 344: -- per_appraisal_templates

340: -- Post Success:
341: -- - Processing continues if:
342: -- * The performance_level_id exists in per_rating_levels
343: -- * The rating scale in per_rating_levels also exists in
344: -- per_appraisal_templates
345:
346: -- Post Failure:
347: -- - An application error is raised and processing is terminated if any of
348: -- the following cases are found:

Line 352: -- per_appraisal_templates

348: -- the following cases are found:
349: -- * The specified performance_level_id does not exists in
350: -- per_rating_levels
351: -- * The rating scale in per_rating levels does not exist in
352: -- per_appraisal_templates
353:
354: -- Developer/Implementation Notes:
355: -- - None
356:

Line 390: -- Cursor to check if the rating_scale_id exists in per_appraisal_templates

386: from per_appraisals a
387: where a.appraisal_id = p_appraisal_id
388: and a.business_group_id = l_business_group_id;
389:
390: -- Cursor to check if the rating_scale_id exists in per_appraisal_templates
391:
392: cursor csr_check_rating_scale_id is
393: select null
394: from per_rating_levels r,

Line 395: per_appraisal_templates t,

391:
392: cursor csr_check_rating_scale_id is
393: select null
394: from per_rating_levels r,
395: per_appraisal_templates t,
396: per_appraisals p,
397: per_assessment_types a
398: where p.appraisal_id = p_appraisal_id
399: and p.appraisal_template_id = t.appraisal_template_id