[Home] [Help]
1237: -- cursor to check that the assessment_type_id is valid
1238: --
1239: cursor csr_valid_assessment_type_id is
1240: select business_group_id
1241: from per_assessment_types
1242: where p_assessment_type_id = assessment_type_id;
1243: --
1244: -- cursor to check that the rating_level_id is valid
1245: --
2485: --
2486: cursor csr_valid_rate_weight_id (c_rate_level_id in number,
2487: c_scale_type in varchar2)is
2488: select ast.rating_scale_id, ast.weighting_scale_id
2489: from per_assessment_types ast,
2490: per_assessments ass,
2491: per_rating_levels ral
2492: where ass.assessment_id = p_assessment_id
2493: and ass.assessment_type_id = ast.assessment_type_id
3090: -- commented the business_group_id check
3091: cursor csr_get_rating_scale_id(c_ass_type_id in number) is
3092: select ast.rating_scale_id, ast.weighting_scale_id
3093: from per_rating_levels ral,
3094: per_assessment_types ast,
3095:
3096: per_rating_scales ras
3097: where ast.assessment_type_id = c_ass_type_id
3098: -- and p_business_group_id +0 = ast.business_group_id
4489: ) is
4490: --
4491: l_proc varchar2(72):= g_package||'chk_comp_element_delete';
4492: l_exists varchar2(1);
4493: l_assessment_type_id per_assessment_types.assessment_type_id%TYPE;
4494: --
4495: -- Cursor which is used to check whether the competence being removed from the assessment template
4496: -- is being used by any assessments (ie.TYPE='ASSESSMENT'). This cursor only makes sure that the
4497: -- competence isnt' being used, not whether the assessment in which the competence is being used.