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_qsf_ins.g_field_id_i := p_field_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: hr_qsf_ins.g_field_id_i := p_field_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: --
83: -- Insert the row into: hr_quest_fields
103: p_rec.object_version_number
104: );
105: --
106: --
107: hr_utility.set_location(' Leaving:'||l_proc, 10);
108: Exception
109: When hr_api.check_integrity_violated Then
110: -- A check constraint has been violated
111: hr_qsf_shd.constraint_error
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);
176: --
177: if hr_qsf_ins.g_field_id_i is not null then
178: --
179: -- Verify registered primary key values not already in use
204: Fetch C_Sel1 Into p_rec.field_id;
205: Close C_Sel1;
206: end if;
207: --
208: hr_utility.set_location(' Leaving:'||l_proc, 10);
209: End pre_insert;
210: --
211: -- ----------------------------------------------------------------------------
212: -- |-----------------------------< post_insert >------------------------------|
246: --
247: l_proc varchar2(72) := g_package||'post_insert';
248: --
249: Begin
250: hr_utility.set_location('Entering:'||l_proc, 5);
251: --
252: begin
253: hr_qsf_rki.after_insert
254: (p_field_id => p_rec.field_id
268: ,p_hook_type => 'AI'
269: );
270: end;
271: --
272: hr_utility.set_location(' Leaving:'||l_proc, 10);
273: End post_insert;
274: --
275: -- ----------------------------------------------------------------------------
276: -- |---------------------------------< ins >----------------------------------|
283: --
284: l_proc varchar2(72) := g_package||'ins';
285: --
286: Begin
287: hr_utility.set_location('Entering:'||l_proc, 5);
288: --
289: -- Call the supporting insert validate operations
290: --
291: hr_qsf_bus.insert_validate(p_rec, p_effective_date);
324: l_rec hr_qsf_shd.g_rec_type;
325: l_proc varchar2(72) := g_package||'ins';
326: --
327: Begin
328: hr_utility.set_location('Entering:'||l_proc, 5);
329: --
330: -- Call conversion function to turn arguments into the
331: -- p_rec structure.
332: --
353: --
354: p_field_id := l_rec.field_id;
355: p_object_version_number := l_rec.object_version_number;
356: --
357: hr_utility.set_location(' Leaving:'||l_proc, 10);
358: End ins;
359: --
360: end hr_qsf_ins;