[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.option_type_id := p_option_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.option_type_id := p_option_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:
199: hr_ott_rki.after_insert
216: ,p_hook_type => 'AI');
217: --
218: end;
219: --
220: hr_utility.set_location(' Leaving:'||l_proc, 10);
221: End post_insert;
222: --
223: -- ----------------------------------------------------------------------------
224: -- |---------------------------------< ins >----------------------------------|
230: --
231: l_proc varchar2(72) := g_package||'ins';
232: --
233: Begin
234: hr_utility.set_location('Entering:'||l_proc, 5);
235: --
236: -- Call the supporting insert validate operations
237: --
238: hr_ott_bus.insert_validate
262: --
263: -- Call to raise any errors on multi-message list
264: hr_multi_message.end_validation_set;
265: --
266: hr_utility.set_location('Leaving:'||l_proc, 20);
267: end ins;
268: --
269: -- ----------------------------------------------------------------------------
270: -- |---------------------------------< ins >----------------------------------|
279: l_rec hr_ott_shd.g_rec_type;
280: l_proc varchar2(72) := g_package||'ins';
281: --
282: Begin
283: hr_utility.set_location('Entering:'||l_proc, 5);
284: --
285: -- Call conversion function to turn arguments into the
286: -- p_rec structure.
287: --
305: -- are specified as an OUT's we must set these values.
306: --
307: --
308: --
309: hr_utility.set_location(' Leaving:'||l_proc, 10);
310: End ins;
311: --
312: -- ----------------------------------------------------------------------------
313: -- |------------------------------< ins_tl >----------------------------------|
332: --
333: l_proc varchar2(72) := g_package || 'ins_tl';
334: --
335: Begin
336: hr_utility.set_location('Entering:'||l_proc,10);
337: --
338: -- Insert a row for the base language and every installed language.
339: --
340: for l_lang in csr_ins_langs loop
345: ,p_option_name => p_option_name
346: );
347: end loop;
348: --
349: hr_utility.set_location('Leaving:'||l_proc,20);
350: End ins_tl;
351: --
352: end hr_ott_ins;