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.offering_id := p_offering_id;
154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 10);
151: hr_utility.set_location('Entering:'||l_proc, 5);
152: --
153: p_rec.offering_id := p_offering_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_ont_rki.after_insert
202: (p_effective_date => p_effective_date
222: ,p_hook_type => 'AI');
223: --
224: end;
225: --
226: hr_utility.set_location(' Leaving:'||l_proc, 10);
227: End post_insert;
228: --
229: -- ----------------------------------------------------------------------------
230: -- |---------------------------------< ins >----------------------------------|
237: --
238: l_proc varchar2(72) := g_package||'ins';
239: --
240: Begin
241: hr_utility.set_location('Entering:'||l_proc, 5);
242: --
243: -- Call the supporting insert validate operations
244: --
245: ota_ont_bus.insert_validate
271: --
272: -- Call to raise any errors on multi-message list
273: hr_multi_message.end_validation_set;
274: --
275: hr_utility.set_location('Leaving:'||l_proc, 20);
276: end ins;
277: --
278: -- ----------------------------------------------------------------------------
279: -- |---------------------------------< ins >----------------------------------|
290: l_rec ota_ont_shd.g_rec_type;
291: l_proc varchar2(72) := g_package||'ins';
292: --
293: Begin
294: hr_utility.set_location('Entering:'||l_proc, 5);
295: --
296: -- Call conversion function to turn arguments into the
297: -- p_rec structure.
298: --
318: -- are specified as an OUT's we must set these values.
319: --
320: --
321: --
322: hr_utility.set_location(' Leaving:'||l_proc, 10);
323: End ins;
324: --
325: -- ----------------------------------------------------------------------------
326: -- |------------------------------< ins_tl >----------------------------------|
346: --
347: l_proc varchar2(72) := g_package || 'ins_tl';
348: --
349: Begin
350: hr_utility.set_location('Entering:'||l_proc,10);
351: --
352: -- Insert a row for the base language and every installed language.
353: --
354: for l_lang in csr_ins_langs loop
361: ,p_description => p_description
362: );
363: end loop;
364: --
365: hr_utility.set_location('Leaving:'||l_proc,20);
366: End ins_tl;
367: --
368: end ota_ont_ins;