[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: --
80: );
81: --
82: --
83: --
84: hr_utility.set_location(' Leaving:'||l_proc, 10);
85: Exception
86: When hr_api.check_integrity_violated Then
87: -- A check constraint has been violated
88: --
147: --
148: l_proc varchar2(72) := g_package||'pre_insert';
149: --
150: Begin
151: hr_utility.set_location('Entering:'||l_proc, 5);
152: --
153: p_rec.activity_id := p_activity_id;
154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 10);
151: hr_utility.set_location('Entering:'||l_proc, 5);
152: --
153: p_rec.activity_id := p_activity_id;
154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 10);
156: End pre_insert;
157: --
158: -- ----------------------------------------------------------------------------
159: -- |-----------------------------< post_insert >------------------------------|
194: --
195: l_proc varchar2(72) := g_package||'post_insert';
196: --
197: Begin
198: hr_utility.set_location('Entering:'||l_proc, 5);
199: begin
200: --
201: ota_adt_rki.after_insert
202: (p_effective_date => p_effective_date
221: ,p_hook_type => 'AI');
222: --
223: end;
224: --
225: hr_utility.set_location(' Leaving:'||l_proc, 10);
226: End post_insert;
227: --
228: -- ----------------------------------------------------------------------------
229: -- |---------------------------------< ins >----------------------------------|
236: --
237: l_proc varchar2(72) := g_package||'ins';
238: --
239: Begin
240: hr_utility.set_location('Entering:'||l_proc, 5);
241: --
242: -- Call the supporting insert validate operations
243: --
244: ota_adt_bus.insert_validate
270: --
271: -- Call to raise any errors on multi-message list
272: hr_multi_message.end_validation_set;
273: --
274: hr_utility.set_location('Leaving:'||l_proc, 20);
275: end ins;
276: --
277: -- ----------------------------------------------------------------------------
278: -- |---------------------------------< ins >----------------------------------|
289: l_rec ota_adt_shd.g_rec_type;
290: l_proc varchar2(72) := g_package||'ins';
291: --
292: Begin
293: hr_utility.set_location('Entering:'||l_proc, 5);
294: --
295: -- Call conversion function to turn arguments into the
296: -- p_rec structure.
297: --
317: -- are specified as an OUT's we must set these values.
318: --
319: --
320: --
321: hr_utility.set_location(' Leaving:'||l_proc, 10);
322: End ins;
323: --
324: -- ----------------------------------------------------------------------------
325: -- |------------------------------< ins_tl >----------------------------------|
345: --
346: l_proc varchar2(72) := g_package || 'ins_tl';
347: --
348: Begin
349: hr_utility.set_location('Entering:'||l_proc,10);
350: --
351: -- Insert a row for the base language and every installed language.
352: --
353: for l_lang in csr_ins_langs loop
360: ,p_description => p_description
361: );
362: end loop;
363: --
364: hr_utility.set_location('Leaving:'||l_proc,20);
365: End ins_tl;
366: --
367: end ota_adt_ins;