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.setup_task_code := p_setup_task_code;
154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 10);
151: hr_utility.set_location('Entering:'||l_proc, 5);
152: --
153: p_rec.setup_task_code := p_setup_task_code;
154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 10);
156: End pre_insert;
157: --
158: -- ----------------------------------------------------------------------------
159: -- |-----------------------------< post_insert >------------------------------|
193: --
194: l_proc varchar2(72) := g_package||'post_insert';
195: --
196: Begin
197: hr_utility.set_location('Entering:'||l_proc, 5);
198: begin
199: --
200: per_stl_rki.after_insert
201: (p_setup_task_code => p_rec.setup_task_code
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_stl_bus.insert_validate
260: --
261: -- Call to raise any errors on multi-message list
262: hr_multi_message.end_validation_set;
263: --
264: hr_utility.set_location('Leaving:'||l_proc, 20);
265: end ins;
266: --
267: -- ----------------------------------------------------------------------------
268: -- |---------------------------------< ins >----------------------------------|
278: l_rec per_stl_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: --
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
346: ,p_setup_task_description => p_setup_task_description
347: );
348: end loop;
349: --
350: hr_utility.set_location('Leaving:'||l_proc,20);
351: End ins_tl;
352: --
353: end per_stl_ins;