79: hr_utility.set_location('Entering:'||l_proc, 5);
80: p_rec.object_version_number := 1; -- Initialise the object version
81: --
82: --
83: -- Insert the row into: hr_quest_fields
84: --
85: insert into hr_quest_fields
86: ( field_id,
87: questionnaire_template_id,
81: --
82: --
83: -- Insert the row into: hr_quest_fields
84: --
85: insert into hr_quest_fields
86: ( field_id,
87: questionnaire_template_id,
88: name,
89: type,
169: --
170: l_proc varchar2(72) := g_package||'pre_insert';
171: l_exists varchar2(1);
172: --
173: Cursor C_Sel1 is select hr_quest_fields_s.nextval from sys.dual;
174: --
175: Cursor C_Sel2 is
176: select null
177: from hr_quest_fields
173: Cursor C_Sel1 is select hr_quest_fields_s.nextval from sys.dual;
174: --
175: Cursor C_Sel2 is
176: select null
177: from hr_quest_fields
178: where field_id = hr_qsf_ins.g_field_id_i;
179: --
180: Begin
181: hr_utility.set_location('Entering:'||l_proc, 5);
272: );
273: exception
274: when hr_api.cannot_find_prog_unit then
275: hr_api.cannot_find_prog_unit_error
276: (p_module_name => 'HR_QUEST_FIELDS'
277: ,p_hook_type => 'AI'
278: );
279: end;
280: --