18: procedure set_base_key_value
19: (p_vacancy_consideration_id in number) is
20: l_proc varchar2(72):=g_package||'set_base_key_value';
21: begin
22: hr_utility.set_location('Entering'||l_proc,10);
23: irc_ivc_ins.g_vacancy_consideration_id_i:=p_vacancy_consideration_id;
24: hr_utility.set_location('Leaving'||l_proc,20);
25: end set_base_key_value;
26: --
20: l_proc varchar2(72):=g_package||'set_base_key_value';
21: begin
22: hr_utility.set_location('Entering'||l_proc,10);
23: irc_ivc_ins.g_vacancy_consideration_id_i:=p_vacancy_consideration_id;
24: hr_utility.set_location('Leaving'||l_proc,20);
25: end set_base_key_value;
26: --
27: --
28: -- ----------------------------------------------------------------------------
74: --
75: l_proc varchar2(72) := g_package||'insert_dml';
76: --
77: Begin
78: hr_utility.set_location('Entering:'||l_proc, 5);
79: p_rec.object_version_number := 1; -- Initialise the object version
80: --
81: --
82: --
100: );
101: --
102: --
103: --
104: hr_utility.set_location(' Leaving:'||l_proc, 10);
105: Exception
106: When hr_api.check_integrity_violated Then
107: -- A check constraint has been violated
108: --
171: l_proc varchar2(72) := g_package||'pre_insert';
172: l_exists varchar2(1);
173: --
174: Begin
175: hr_utility.set_location('Entering:'||l_proc, 5);
176: --
177: If (irc_ivc_ins.g_vacancy_consideration_id_i is not null) Then
178:
179: open c2;
197: fetch c1 into p_rec.vacancy_consideration_id;
198: close c1;
199: End If;
200: --
201: hr_utility.set_location(' Leaving:'||l_proc, 10);
202: End pre_insert;
203: --
204: -- ----------------------------------------------------------------------------
205: -- |-----------------------------< post_insert >------------------------------|
240: --
241: l_proc varchar2(72) := g_package||'post_insert';
242: --
243: Begin
244: hr_utility.set_location('Entering:'||l_proc, 5);
245: begin
246: --
247: irc_ivc_rki.after_insert
248: (p_effective_date => p_effective_date
267: ,p_hook_type => 'AI');
268: --
269: end;
270: --
271: hr_utility.set_location(' Leaving:'||l_proc, 10);
272: End post_insert;
273: --
274: -- ----------------------------------------------------------------------------
275: -- |---------------------------------< ins >----------------------------------|
281: --
282: l_proc varchar2(72) := g_package||'ins';
283: --
284: Begin
285: hr_utility.set_location('Entering:'||l_proc, 5);
286: --
287: -- Call the supporting insert validate operations
288: --
289: irc_ivc_bus.insert_validate
310: );
311: --
312: -- Call to raise any errors on multi-message list
313: hr_multi_message.end_validation_set;
314: hr_utility.set_location('Leaving:'||l_proc, 20);
315: end ins;
316: --
317: -- ----------------------------------------------------------------------------
318: -- |---------------------------------< ins >----------------------------------|
329: l_rec irc_ivc_shd.g_rec_type;
330: l_proc varchar2(72) := g_package||'ins';
331: --
332: Begin
333: hr_utility.set_location('Entering:'||l_proc, 5);
334: --
335: -- Call conversion function to turn arguments into the
336: -- p_rec structure.
337: --
358: --
359: p_object_version_number := l_rec.object_version_number;
360: p_vacancy_consideration_id := l_rec.vacancy_consideration_id;
361: --
362: hr_utility.set_location(' Leaving:'||l_proc, 10);
363: End ins;
364: --
365: end irc_ivc_ins;