APPS.HR_QSF_BUS dependencies on HR_QUEST_FIELDS

Line 105: in hr_quest_fields.questionnaire_template_id%TYPE

101: -- ----------------------------------------------------------------------------
102: --
103: Procedure chk_questionnaire_template_id
104: (p_questionnaire_template_id
105: in hr_quest_fields.questionnaire_template_id%TYPE
106: )
107: is
108: --
109: l_proc varchar2(72) := g_package || 'chk_questionnaire_template_id';

Line 129: hr_qsf_shd.constraint_error('HR_QUEST_FIELDS_FK');

125: fetch csr_id_exists into l_exists;
126: if csr_id_exists%notfound then
127: -- Questionnaire template id not found - raise error
128: close csr_id_exists;
129: hr_qsf_shd.constraint_error('HR_QUEST_FIELDS_FK');
130: end if;
131: close csr_id_exists;
132: else
133: -- Questionnaire template id is null - raise error

Line 142: (p_associated_column1 => 'HR_QUEST_FIELDS.QUESTIONNAIRE_TEMPLATE_ID'

138: hr_utility.set_location('Leaving: '||l_proc,50);
139:
140: exception when app_exception.application_exception then
141: if hr_multi_message.exception_add
142: (p_associated_column1 => 'HR_QUEST_FIELDS.QUESTIONNAIRE_TEMPLATE_ID'
143: ) then
144: hr_utility.set_location(' Leaving:'|| l_proc, 60);
145: raise;
146: end if;

Line 156: (p_name in hr_quest_fields.name%TYPE

152: -- |----------------------------< chk_name >----------------------------------|
153: -- ----------------------------------------------------------------------------
154: --
155: Procedure chk_name
156: (p_name in hr_quest_fields.name%TYPE
157: )
158: is
159: --
160: l_proc varchar2(72) := g_package || 'chk_name';

Line 176: (p_associated_column1 => 'HR_QUEST_FIELDS.NAME'

172: hr_utility.set_location('Leaving: '||l_proc,20);
173:
174: exception when app_exception.application_exception then
175: if hr_multi_message.exception_add
176: (p_associated_column1 => 'HR_QUEST_FIELDS.NAME'
177: ) then
178: hr_utility.set_location(' Leaving:'|| l_proc, 30);
179: raise;
180: end if;

Line 189: (p_type in hr_quest_fields.type%TYPE

185: -- |----------------------------< chk_type >----------------------------------|
186: -- ----------------------------------------------------------------------------
187: --
188: Procedure chk_type
189: (p_type in hr_quest_fields.type%TYPE
190: ,p_effective_date in date
191: ) is
192: --
193: l_proc varchar2(72) := g_package || 'chk_type';

Line 207: hr_qsf_shd.constraint_error('HR_QUEST_FIELDS_TYPE_CHK');

203: ,p_lookup_type => 'QUEST_FIELD_TYPE'
204: ,p_lookup_code => p_type
205: ) then
206: -- p_type does not exist in lookup
207: hr_qsf_shd.constraint_error('HR_QUEST_FIELDS_TYPE_CHK');
208: end if;
209: else
210: -- p_type is null
211: fnd_message.set_name('PER','PER_52426_QSF_MAND_TYPE');

Line 219: (p_associated_column1 => 'HR_QUEST_FIELDS.TYPE'

215: hr_utility.set_location('Leaving: '||l_proc,20);
216:
217: exception when app_exception.application_exception then
218: if hr_multi_message.exception_add
219: (p_associated_column1 => 'HR_QUEST_FIELDS.TYPE'
220: ) then
221: hr_utility.set_location(' Leaving:'|| l_proc, 30);
222: raise;
223: end if;

Line 233: (p_html_text in hr_quest_fields.html_text%TYPE

229: -- |----------------------< chk_html_text >----------------------------------|
230: -- ---------------------------------------------------------------------------
231: --
232: Procedure chk_html_text
233: (p_html_text in hr_quest_fields.html_text%TYPE
234: )
235: is
236: --
237: c_max_size CONSTANT number := 27648;

Line 262: (p_associated_column1 => 'HR_QUEST_FIELDS.HTML_TEXT'

258: hr_utility.set_location('Leaving: '||l_proc,20);
259:
260: exception when app_exception.application_exception then
261: if hr_multi_message.exception_add
262: (p_associated_column1 => 'HR_QUEST_FIELDS.HTML_TEXT'
263: ) then
264: hr_utility.set_location(' Leaving:'|| l_proc, 30);
265: raise;
266: end if;

Line 276: (p_sql_required_flag in hr_quest_fields.sql_required_flag%TYPE

272: -- |----------------------< chk_sql_required_flag >--------------------------|
273: -- ---------------------------------------------------------------------------
274: --
275: Procedure chk_sql_required_flag
276: (p_sql_required_flag in hr_quest_fields.sql_required_flag%TYPE
277: ,p_effective_date in date
278: ) is
279: --
280: l_proc varchar2(72) := g_package || 'chk_sql_required_flag';

Line 294: hr_qsf_shd.constraint_error('HR_QUEST_FIELDS_SQL_FLAG_CHK');

290: ,p_lookup_type => 'YES_NO'
291: ,p_lookup_code => p_sql_required_flag
292: ) then
293: -- Doesnt exist in lookups, so error
294: hr_qsf_shd.constraint_error('HR_QUEST_FIELDS_SQL_FLAG_CHK');
295: end if;
296: else
297: -- p_sql_required flag is null, yet is a mandatory column
298: fnd_message.set_name('PER','PER_52422_QSF_MAND_REQD_FLAG');

Line 306: (p_associated_column1 => 'HR_QUEST_FIELDS.SQL_REQUIRED_FLAG'

302: hr_utility.set_location('Leaving: '||l_proc,20);
303:
304: exception when app_exception.application_exception then
305: if hr_multi_message.exception_add
306: (p_associated_column1 => 'HR_QUEST_FIELDS.SQL_REQUIRED_FLAG'
307: ) then
308: hr_utility.set_location(' Leaving:'|| l_proc, 30);
309: raise;
310: end if;

Line 392: (p_field_id in hr_quest_fields.field_id%TYPE

388: -- ----------------------------------------------------------------------------
389: -- |--------------------< return_legislation_code >---------------------------|
390: -- ----------------------------------------------------------------------------
391: Function return_legislation_code
392: (p_field_id in hr_quest_fields.field_id%TYPE
393: ) return varchar2 is
394: --
395: -- Cursor to find legislation code
396: --

Line 401: , hr_quest_fields qsf

397: cursor csr_leg_code is
398: select pbg.legislation_code
399: from per_business_groups pbg
400: , hr_questionnaires qsn
401: , hr_quest_fields qsf
402: where qsf.field_id = p_field_id
403: and qsn.questionnaire_template_id = qsf.questionnaire_template_id
404: and qsn.business_group_id = pbg.business_group_id;
405: --