APPS.HR_QSV_BUS dependencies on HR_QUEST_ANSWER_VALUES

Line 78: in hr_quest_answer_values.questionnaire_answer_id%TYPE

74: -- |-------------------< chk_questionnaire_answer_id >------------------------|
75: -- ----------------------------------------------------------------------------
76: procedure chk_questionnaire_answer_id
77: (p_questionnaire_answer_id
78: in hr_quest_answer_values.questionnaire_answer_id%TYPE
79: )
80: is
81: --
82: l_proc varchar2(72) := g_package || 'chk_questionnaire_answer_id';

Line 108: hr_qsv_shd.constraint_error('HR_QUEST_ANSWER_VALUES_FK1');

104: fetch csr_id_exists into g_questionnaire_template_id;
105: if csr_id_exists%NOTFOUND then
106: -- id doent exist, so error.
107: close csr_id_exists;
108: hr_qsv_shd.constraint_error('HR_QUEST_ANSWER_VALUES_FK1');
109: end if;
110: close csr_id_exists;
111: end if;
112: --

Line 122: (p_field_id in hr_quest_answer_values.field_id%TYPE

118: -- |----------------------------< chk_field_id >------------------------------|
119: -- ----------------------------------------------------------------------------
120: --
121: procedure chk_field_id
122: (p_field_id in hr_quest_answer_values.field_id%TYPE
123: ,p_questionnaire_answer_id
124: in hr_quest_answer_values.questionnaire_answer_id%TYPE
125: )
126: is

Line 124: in hr_quest_answer_values.questionnaire_answer_id%TYPE

120: --
121: procedure chk_field_id
122: (p_field_id in hr_quest_answer_values.field_id%TYPE
123: ,p_questionnaire_answer_id
124: in hr_quest_answer_values.questionnaire_answer_id%TYPE
125: )
126: is
127: --
128: l_proc varchar2(72) := g_package || 'chk_field_id';

Line 144: from hr_quest_answer_values qsv

140: -- Cursor to determine if id is unique for the given questionnaire_answer_id
141: --
142: cursor csr_chk_unique is
143: select null
144: from hr_quest_answer_values qsv
145: where qsv.questionnaire_answer_id = p_questionnaire_answer_id
146: and qsv.field_id = p_field_id;
147: --
148: begin

Line 163: hr_qsv_shd.constraint_error('HR_QUEST_ANSWER_VALUES_FK2');

159: fetch csr_id_exists into l_questionnaire_template_id;
160: if csr_id_exists%NOTFOUND then
161: -- Id does not exist, so error.
162: close csr_id_exists;
163: hr_qsv_shd.constraint_error('HR_QUEST_ANSWER_VALUES_FK2');
164: end if;
165: close csr_id_exists;
166: --
167: hr_utility.set_location(l_proc,20);

Line 176: hr_qsv_shd.constraint_error('HR_QUEST_ANSWER_VALUES_UK1');

172: fetch csr_chk_unique into l_exists;
173: if csr_chk_unique%FOUND then
174: -- field_id is not unique, so error
175: close csr_chk_unique;
176: hr_qsv_shd.constraint_error('HR_QUEST_ANSWER_VALUES_UK1');
177: end if;
178: close csr_chk_unique;
179: --
180: hr_utility.set_location(l_proc,30);

Line 202: (p_value in hr_quest_answer_values.value%TYPE

198: -- |-----------------------< chk_delete_allowed >-----------------------------|
199: -- ----------------------------------------------------------------------------
200: --
201: procedure chk_delete_allowed
202: (p_value in hr_quest_answer_values.value%TYPE
203: )
204: is
205: --
206: l_proc varchar2(72) := g_package || 'chk_delete_allowed';

Line 308: (p_quest_answer_val_id in hr_quest_answer_values.quest_answer_val_id%TYPE

304: -- |---------------------< return_legislation_code >--------------------------|
305: -- ----------------------------------------------------------------------------
306: --
307: function return_legislation_code
308: (p_quest_answer_val_id in hr_quest_answer_values.quest_answer_val_id%TYPE
309: ) return varchar2 is
310: --
311: -- Cursor to find legislation code
312: --

Line 317: , hr_quest_answer_values qsv

313: cursor csr_leg_code is
314: select pbg.legislation_code
315: from per_business_groups pbg
316: , hr_quest_answers qsa
317: , hr_quest_answer_values qsv
318: where p_quest_answer_val_id = qsv.quest_answer_val_id
319: and qsv.questionnaire_answer_id = qsa.questionnaire_answer_id
320: and qsa.business_group_id = pbg.business_group_id;
321: --