APPS.PER_PRT_BUS dependencies on PER_RATING_LEVELS

Line 326: -- - Checks that the specified rating_level_id exists in per_rating_levels

322: -- -------------------------------------------------------------------+
323: -- {Start Of Comments}
324:
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:

Line 328: -- - Checks that the rating scale in per_rating_levels also exists in

324:
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

Line 342: -- * The performance_level_id exists in per_rating_levels

338: -- - p_object_version_number
339:
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:

Line 343: -- * The rating scale in per_rating_levels also exists in

339:
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

Line 350: -- per_rating_levels

346: -- Post Failure:
347: -- - An application error is raised and processing is terminated if any of
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:

Line 351: -- * The rating scale in per_rating levels does not exist in

347: -- - An application error is raised and processing is terminated if any of
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

Line 373: l_business_group_id per_rating_levels.business_group_id%TYPE;

369:
370: l_proc varchar2(72) := g_package||'chk_performance_level_id';
371: l_exists varchar2(1);
372: l_api_updating boolean;
373: l_business_group_id per_rating_levels.business_group_id%TYPE;
374:
375: -- Cursor to check if the rating_level_id exists for the same business group
376:
377: cursor csr_id_exists is

Line 379: from per_rating_levels r

375: -- Cursor to check if the rating_level_id exists for the same business group
376:
377: cursor csr_id_exists is
378: select r.business_group_id
379: from per_rating_levels r
380: where r.rating_level_id = p_performance_level_id;
381:
382: -- Cursor to check if the appraisal_id exists for the same business group
383:

Line 384: cursor csr_bg_exists (l_business_group_id in per_rating_levels.business_group_id%TYPE) is

380: where r.rating_level_id = p_performance_level_id;
381:
382: -- Cursor to check if the appraisal_id exists for the same business group
383:
384: cursor csr_bg_exists (l_business_group_id in per_rating_levels.business_group_id%TYPE) is
385: select null
386: from per_appraisals a
387: where a.appraisal_id = p_appraisal_id
388: and a.business_group_id = l_business_group_id;

Line 394: from per_rating_levels r,

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,
395: per_appraisal_templates t,
396: per_appraisals p,
397: per_assessment_types a
398: where p.appraisal_id = p_appraisal_id