APPS.HR_QSA_BUS dependencies on PER_APPRAISAL_TEMPLATES

Line 75: -- PER_APPRAISAL_TEMPLATES table, when type = 'APPRAISAL', or valid against

71: --
72: -- Description:
73: -- Validates that the questionnaire_template_id exists in HR_QUESTIONNAIRES.
74: -- Also, validates that the questionnaire_template_id is valid against the
75: -- PER_APPRAISAL_TEMPLATES table, when type = 'APPRAISAL', or valid against
76: -- the PER_APPRAISALS table when type = 'PARTICIPANT'.
77: --
78: -- Pre-requisites:
79: -- p_type, p_type_object_id and p_business_group_id are all valid.

Line 129: from per_appraisal_templates pat,

125: -- the type = 'APPRAISAL'
126: --
127: cursor csr_appraisal_valid is
128: select null
129: from per_appraisal_templates pat,
130: per_appraisals pa
131: where p_questionnaire_template_id = pat.questionnaire_template_id
132: and p_type_object_id = pa.appraisal_id
133: and pa.appraisal_template_id = pat.appraisal_template_id;

Line 163: -- PER_APPRAISAL_TEMPLATES

159: hr_utility.set_location(l_proc,30);
160: --
161: if p_type = 'APPRAISAL' then
162: -- Check that questionnaire_template_id is valid against
163: -- PER_APPRAISAL_TEMPLATES
164: open csr_appraisal_valid;
165: fetch csr_appraisal_valid into l_exists;
166: if csr_appraisal_valid%NOTFOUND then
167: -- Invalid questionnaire_template_id, according to

Line 168: -- per_appraisal_templates and per_appraisals.

164: open csr_appraisal_valid;
165: fetch csr_appraisal_valid into l_exists;
166: if csr_appraisal_valid%NOTFOUND then
167: -- Invalid questionnaire_template_id, according to
168: -- per_appraisal_templates and per_appraisals.
169: close csr_appraisal_valid;
170: fnd_message.set_name('PER','PER_52431_QSA_INVAL_TEMP_ID');
171: fnd_message.raise_error;
172: end if;