[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.event_id := p_event_id;
152: --
153: hr_utility.set_location(' Leaving:'||l_proc, 10);
149: hr_utility.set_location('Entering:'||l_proc, 5);
150: --
151: p_rec.event_id := p_event_id;
152: --
153: hr_utility.set_location(' Leaving:'||l_proc, 10);
154: End pre_insert;
155: --
156: -- ----------------------------------------------------------------------------
157: -- |-----------------------------< post_insert >------------------------------|
192: --
193: l_proc varchar2(72) := g_package||'post_insert';
194: --
195: Begin
196: hr_utility.set_location('Entering:'||l_proc, 5);
197: begin
198: --
199: ota_ent_rki.after_insert
200: (p_effective_date => p_effective_date
217: ,p_hook_type => 'AI');
218: --
219: end;
220: --
221: hr_utility.set_location(' Leaving:'||l_proc, 10);
222: End post_insert;
223: --
224: -- ----------------------------------------------------------------------------
225: -- |---------------------------------< ins >----------------------------------|
232: --
233: l_proc varchar2(72) := g_package||'ins';
234: --
235: Begin
236: hr_utility.set_location('Entering:'||l_proc, 5);
237: --
238: -- Call the supporting insert validate operations
239: --
240: ota_ent_bus.insert_validate
266: --
267: -- Call to raise any errors on multi-message list
268: hr_multi_message.end_validation_set;
269: --
270: hr_utility.set_location('Leaving:'||l_proc, 20);
271: end ins;
272: --
273: -- ----------------------------------------------------------------------------
274: -- |---------------------------------< ins >----------------------------------|
284: l_rec ota_ent_shd.g_rec_type;
285: l_proc varchar2(72) := g_package||'ins';
286: --
287: Begin
288: hr_utility.set_location('Entering:'||l_proc, 5);
289: --
290: -- Call conversion function to turn arguments into the
291: -- p_rec structure.
292: --
311: -- are specified as an OUT's we must set these values.
312: --
313: --
314: --
315: hr_utility.set_location(' Leaving:'||l_proc, 10);
316: End ins;
317: --
318: -- ----------------------------------------------------------------------------
319: -- |------------------------------< ins_tl >----------------------------------|
338: --
339: l_proc varchar2(72) := g_package || 'ins_tl';
340: --
341: Begin
342: hr_utility.set_location('Entering:'||l_proc,10);
343: --
344: -- Insert a row for the base language and every installed language.
345: --
346: for l_lang in csr_ins_langs loop
352: ,p_title => p_title
353: );
354: end loop;
355: --
356: hr_utility.set_location('Leaving:'||l_proc,20);
357: End ins_tl;
358: --
359: end ota_ent_ins;