20: --
21: l_proc varchar2(72) := g_package||'set_base_key_value';
22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: hr_qsv_ins.g_quest_answer_val_id_i := p_quest_answer_val_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: hr_qsv_ins.g_quest_answer_val_id_i := p_quest_answer_val_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: -- ----------------------------------------------------------------------------
32: -- |------------------------------< insert_dml >------------------------------|
75: --
76: l_proc varchar2(72) := g_package||'insert_dml';
77: --
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: --
95: p_rec.object_version_number,
96: p_rec.value
97: );
98: --
99: hr_utility.set_location(' Leaving:'||l_proc, 10);
100: Exception
101: When hr_api.check_integrity_violated Then
102: -- A check constraint has been violated
103: hr_qsv_shd.constraint_error
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);
168: --
169: if hr_qsv_ins.g_quest_answer_val_id_i is not null then
170: --
171: -- Verify registered primary key values not already in use
196: Close C_Sel1;
197: --
198: end if;
199: --
200: hr_utility.set_location(' Leaving:'||l_proc, 10);
201: End pre_insert;
202: --
203: -- ----------------------------------------------------------------------------
204: -- |-----------------------------< post_insert >------------------------------|
236: --
237: l_proc varchar2(72) := g_package||'post_insert';
238: --
239: Begin
240: hr_utility.set_location('Entering:'||l_proc, 5);
241: --
242: begin
243: hr_qsv_rki.after_insert
244: (p_quest_answer_val_id => p_rec.quest_answer_val_id
254: ,p_hook_type => 'AI'
255: );
256: end;
257: --
258: hr_utility.set_location(' Leaving:'||l_proc, 10);
259: End post_insert;
260: --
261: -- ----------------------------------------------------------------------------
262: -- |---------------------------------< ins >----------------------------------|
268: --
269: l_proc varchar2(72) := g_package||'ins';
270: --
271: Begin
272: hr_utility.set_location('Entering:'||l_proc, 5);
273: --
274: -- Call the supporting insert validate operations
275: --
276: hr_qsv_bus.insert_validate(p_rec);
303: l_rec hr_qsv_shd.g_rec_type;
304: l_proc varchar2(72) := g_package||'ins';
305: --
306: Begin
307: hr_utility.set_location('Entering:'||l_proc, 5);
308: --
309: -- Call conversion function to turn arguments into the
310: -- p_rec structure.
311: --
329: --
330: p_quest_answer_val_id := l_rec.quest_answer_val_id;
331: p_object_version_number := l_rec.object_version_number;
332: --
333: hr_utility.set_location(' Leaving:'||l_proc, 10);
334: End ins;
335: --
336: end hr_qsv_ins;