DBA Data[Home] [Help]

APPS.HR_QSF_INS dependencies on HR_QUEST_FIELDS

Line 83: -- Insert the row into: hr_quest_fields

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,

Line 85: insert into hr_quest_fields

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,

Line 167: Cursor C_Sel1 is select hr_quest_fields_s.nextval from sys.dual;

163: --
164: l_proc varchar2(72) := g_package||'pre_insert';
165: l_exists varchar2(1);
166: --
167: Cursor C_Sel1 is select hr_quest_fields_s.nextval from sys.dual;
168: --
169: Cursor C_Sel2 is
170: select null
171: from hr_quest_fields

Line 171: from hr_quest_fields

167: Cursor C_Sel1 is select hr_quest_fields_s.nextval from sys.dual;
168: --
169: Cursor C_Sel2 is
170: select null
171: from hr_quest_fields
172: where field_id = hr_qsf_ins.g_field_id_i;
173: --
174: Begin
175: hr_utility.set_location('Entering:'||l_proc, 5);

Line 267: (p_module_name => 'HR_QUEST_FIELDS'

263: );
264: exception
265: when hr_api.cannot_find_prog_unit then
266: hr_api.cannot_find_prog_unit_error
267: (p_module_name => 'HR_QUEST_FIELDS'
268: ,p_hook_type => 'AI'
269: );
270: end;
271: --