APPS.HR_QSV_INS dependencies on HR_QUEST_ANSWER_VALUES

Line 82: -- Insert the row into: hr_quest_answer_values

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

Line 84: insert into hr_quest_answer_values

80: p_rec.object_version_number := 1; -- Initialise the object version
81: --
82: -- Insert the row into: hr_quest_answer_values
83: --
84: insert into hr_quest_answer_values
85: ( quest_answer_val_id,
86: questionnaire_answer_id,
87: field_id,
88: object_version_number,

Line 159: Cursor C_Sel1 is select hr_quest_answer_values_s.nextval from sys.dual;

155: --
156: l_proc varchar2(72) := g_package||'pre_insert';
157: l_exists varchar2(1);
158: --
159: Cursor C_Sel1 is select hr_quest_answer_values_s.nextval from sys.dual;
160: --
161: Cursor C_Sel2 is
162: select null
163: from hr_quest_answer_values

Line 163: from hr_quest_answer_values

159: Cursor C_Sel1 is select hr_quest_answer_values_s.nextval from sys.dual;
160: --
161: Cursor C_Sel2 is
162: select null
163: from hr_quest_answer_values
164: where quest_answer_val_id = hr_qsv_ins.g_quest_answer_val_id_i;
165: --
166: Begin
167: hr_utility.set_location('Entering:'||l_proc, 5);

Line 181: fnd_message.set_token('TABLE_NAME','hr_quest_answer_values');

177: --
178: -- The primary key values are already in use.
179: --
180: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
181: fnd_message.set_token('TABLE_NAME','hr_quest_answer_values');
182: fnd_message.raise_error;
183: end if;
184: Close C_Sel2;
185: --

Line 253: (p_module_name => 'HR_QUEST_ANSWER_VALUES'

249: );
250: exception
251: when hr_api.cannot_find_prog_unit then
252: hr_api.cannot_find_prog_unit_error
253: (p_module_name => 'HR_QUEST_ANSWER_VALUES'
254: ,p_hook_type => 'AI'
255: );
256: end;
257: --