APPS.HR_QSA_BUS dependencies on HR_QUESTIONNAIRES

Line 73: -- Validates that the questionnaire_template_id exists in HR_QUESTIONNAIRES.

69: -- |-------------------< chk_questionnaire_template_id >----------------------|
70: -- ----------------------------------------------------------------------------
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: --

Line 117: -- HR_QUESTIONNAIRES.

113: l_exists varchar2(1);
114: l_bus_grp_id HR_QUEST_ANSWERS.business_group_id%TYPE;
115: --
116: -- Cursor to determins if questionnaire_template_id exists in
117: -- HR_QUESTIONNAIRES.
118: --
119: cursor csr_id_exists is
120: select business_group_id
121: from hr_questionnaires qsn

Line 121: from hr_questionnaires qsn

117: -- HR_QUESTIONNAIRES.
118: --
119: cursor csr_id_exists is
120: select business_group_id
121: from hr_questionnaires qsn
122: where qsn.questionnaire_template_id = p_questionnaire_template_id;
123: --
124: -- Cursor to determine if questionnaire_template_id is valid when
125: -- the type = 'APPRAISAL'

Line 149: -- Check item exists in hr_questionnaires.

145: fnd_message.raise_error;
146: else
147: hr_utility.set_location(l_proc,20);
148: --
149: -- Check item exists in hr_questionnaires.
150: open csr_id_exists;
151: fetch csr_id_exists into l_bus_grp_id;
152: if csr_id_exists%NOTFOUND then
153: -- questionnaire_template_id doesnt exist in hr_questionnaires

Line 153: -- questionnaire_template_id doesnt exist in hr_questionnaires

149: -- Check item exists in hr_questionnaires.
150: open csr_id_exists;
151: fetch csr_id_exists into l_bus_grp_id;
152: if csr_id_exists%NOTFOUND then
153: -- questionnaire_template_id doesnt exist in hr_questionnaires
154: close csr_id_exists;
155: hr_qsa_shd.constraint_error('HR_QUEST_ANSWERS_FK1');
156: end if;
157: close csr_id_exists;