APPS.HR_QSN_INS dependencies on HR_QUESTIONNAIRES

Line 83: -- Insert the row into: hr_questionnaires

79: Begin
80: hr_utility.set_location('Entering:'||l_proc, 5);
81: p_rec.object_version_number := 1; -- Initialise the object version
82: --
83: -- Insert the row into: hr_questionnaires
84: --
85: insert into hr_questionnaires
86: ( questionnaire_template_id,
87: name,

Line 85: insert into hr_questionnaires

81: p_rec.object_version_number := 1; -- Initialise the object version
82: --
83: -- Insert the row into: hr_questionnaires
84: --
85: insert into hr_questionnaires
86: ( questionnaire_template_id,
87: name,
88: text,
89: available_flag,

Line 164: Cursor C_Sel1 is select hr_questionnaires_s.nextval from sys.dual;

160: --
161: l_proc varchar2(72) := g_package||'pre_insert';
162: l_exists varchar2(1);
163: --
164: Cursor C_Sel1 is select hr_questionnaires_s.nextval from sys.dual;
165: --
166: Cursor C_Sel2 is
167: select null
168: from hr_questionnaires

Line 168: from hr_questionnaires

164: Cursor C_Sel1 is select hr_questionnaires_s.nextval from sys.dual;
165: --
166: Cursor C_Sel2 is
167: select null
168: from hr_questionnaires
169: where questionnaire_template_id = hr_qsn_ins.g_questionnaire_template_id_i;
170: --
171: Begin
172: hr_utility.set_location('Entering:'||l_proc, 5);

Line 186: fnd_message.set_token('TABLE_NAME','hr_questionnaires');

182: --
183: -- The primary key values are already in use.
184: --
185: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
186: fnd_message.set_token('TABLE_NAME','hr_questionnaires');
187: fnd_message.raise_error;
188: end if;
189: Close C_Sel2;
190: --

Line 262: (p_module_name => 'HR_QUESTIONNAIRES'

258: );
259: exception
260: when hr_api.cannot_find_prog_unit then
261: hr_api.cannot_find_prog_unit_error
262: (p_module_name => 'HR_QUESTIONNAIRES'
263: ,p_hook_type => 'AI'
264: );
265: end;
266: hr_utility.set_location(' Leaving:'||l_proc, 10);