[Home] [Help]
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
59: Begin
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: --
62: --
63: --
64: --
78: );
79: --
80: --
81: --
82: hr_utility.set_location(' Leaving:'||l_proc, 10);
83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: --
145: --
146: l_proc varchar2(72) := g_package||'pre_insert';
147: --
148: Begin
149: hr_utility.set_location('Entering:'||l_proc, 5);
150: --
151: p_rec.absence_attendance_type_id := p_absence_attendance_type_id;
152: --
153: hr_utility.set_location(' Leaving:'||l_proc, 10);
149: hr_utility.set_location('Entering:'||l_proc, 5);
150: --
151: p_rec.absence_attendance_type_id := p_absence_attendance_type_id;
152: --
153: hr_utility.set_location(' Leaving:'||l_proc, 10);
154: End pre_insert;
155: --
156: -- ----------------------------------------------------------------------------
157: -- |-----------------------------< post_insert >------------------------------|
191: --
192: l_proc varchar2(72) := g_package||'post_insert';
193: --
194: Begin
195: hr_utility.set_location('Entering:'||l_proc, 5);
196: begin
197: --
198: per_abt_rki.after_insert
199: (p_absence_attendance_type_id
215: ,p_hook_type => 'AI');
216: --
217: end;
218: --
219: hr_utility.set_location(' Leaving:'||l_proc, 10);
220: End post_insert;
221: --
222: -- ----------------------------------------------------------------------------
223: -- |---------------------------------< ins >----------------------------------|
229: --
230: l_proc varchar2(72) := g_package||'ins';
231: --
232: Begin
233: hr_utility.set_location('Entering:'||l_proc, 5);
234: --
235: -- Call the supporting insert validate operations
236: --
237: per_abt_bus.insert_validate
261: --
262: -- Call to raise any errors on multi-message list
263: hr_multi_message.end_validation_set;
264: --
265: hr_utility.set_location('Leaving:'||l_proc, 20);
266: end ins;
267: --
268: -- ----------------------------------------------------------------------------
269: -- |---------------------------------< ins >----------------------------------|
278: l_rec per_abt_shd.g_rec_type;
279: l_proc varchar2(72) := g_package||'ins';
280: --
281: Begin
282: hr_utility.set_location('Entering:'||l_proc, 5);
283: --
284: -- Call conversion function to turn arguments into the
285: -- p_rec structure.
286: --
304: -- are specified as an OUT's we must set these values.
305: --
306: --
307: --
308: hr_utility.set_location(' Leaving:'||l_proc, 10);
309: End ins;
310: --
311: -- ----------------------------------------------------------------------------
312: -- |------------------------------< ins_tl >----------------------------------|
330: --
331: l_proc varchar2(72) := g_package || 'ins_tl';
332: --
333: Begin
334: hr_utility.set_location('Entering:'||l_proc,10);
335: --
336: -- Insert a row for the base language and every installed language.
337: --
338: for l_lang in csr_ins_langs loop
343: ,p_name => p_name
344: );
345: end loop;
346: --
347: hr_utility.set_location('Leaving:'||l_proc,20);
348: End ins_tl;
349: --
350: end per_abt_ins;