[Home] [Help]
65: -- -------------------------------------------------------------------+
66: -- {Start Of Comments}
67:
68: -- Description:
69: -- - Validates that the appraisal id exists in per_appraisals
70:
71: -- Pre-requisites:
72: -- - None
73:
100: l_api_updating boolean;
101: l_proc varchar2(72) := g_package||'chk_appraisal_id';
102: l_exists varchar2(1);
103:
104: -- Cursor to check that the specified appraisal_id exists in per_appraisals
105:
106: cursor csr_id_exists is
107: select null
108: from per_appraisals
104: -- Cursor to check that the specified appraisal_id exists in per_appraisals
105:
106: cursor csr_id_exists is
107: select null
108: from per_appraisals
109: where appraisal_id = p_appraisal_id;
110:
111: begin
112:
162:
163: -- Description:
164: -- - Checks that the specified objective_id exists in per_objectives
165: -- for the same business group.
166: -- - Checks that the appraisal date in per_appraisals is between the
167: -- effective start/end dates in per_objectives
168: -- - Validates that the objective_id is unique for the appraisal_id
169:
170: -- Pre-requisites:
210: l_exists varchar2(1);
211: l_business_group_id per_objectives.business_group_id%TYPE;
212:
213: -- Cursor to check that the specified objective_id exists in per_objectives
214: -- where the business_group_id in per_objectives exists in per_appraisals
215:
216: cursor csr_id_exists is
217: select o.business_group_id
218: from per_objectives o
219: where o.objective_id = p_objective_id;
220:
221: cursor csr_bg_exists (l_business_group_id IN per_objectives.business_group_id%TYPE) is
222: select null
223: from per_appraisals a
224: where a.appraisal_id = p_appraisal_id
225: and a.business_group_id = l_business_group_id;
226:
227: cursor csr_objective_id_exists is
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;
389:
390: -- Cursor to check if the rating_scale_id exists in per_appraisal_templates
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
400: and t.objective_asmnt_type_id = a.assessment_type_id(+)