APPS.HR_QSF_BUS dependencies on HR_QUEST_FIELDS

Line 108: in hr_quest_fields.questionnaire_template_id%TYPE

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

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

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

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

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

Line 159: (p_name in hr_quest_fields.name%TYPE

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

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

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

Line 192: (p_type in hr_quest_fields.type%TYPE

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

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

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

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

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

Line 236: (p_html_text in hr_quest_fields.html_text%TYPE

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

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

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

Line 279: (p_sql_required_flag in hr_quest_fields.sql_required_flag%TYPE

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

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

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

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

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

Line 395: (p_field_id in hr_quest_fields.field_id%TYPE

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

Line 404: , hr_quest_fields qsf

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