[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.setup_sub_task_code := p_setup_sub_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_sub_task_code := p_setup_sub_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_sst_rki.after_insert
201: (p_setup_sub_task_code => p_rec.setup_sub_task_code
214: ,p_hook_type => 'AI');
215: --
216: end;
217: --
218: hr_utility.set_location(' Leaving:'||l_proc, 10);
219: End post_insert;
220: --
221: -- ----------------------------------------------------------------------------
222: -- |---------------------------------< ins >----------------------------------|
228: --
229: l_proc varchar2(72) := g_package||'ins';
230: --
231: Begin
232: hr_utility.set_location('Entering:'||l_proc, 5);
233: --
234: -- Call the supporting insert validate operations
235: --
236: per_sst_bus.insert_validate
259: --
260: -- Call to raise any errors on multi-message list
261: hr_multi_message.end_validation_set;
262: --
263: hr_utility.set_location('Leaving:'||l_proc, 20);
264: end ins;
265: --
266: -- ----------------------------------------------------------------------------
267: -- |---------------------------------< ins >----------------------------------|
277: l_rec per_sst_shd.g_rec_type;
278: l_proc varchar2(72) := g_package||'ins';
279: --
280: Begin
281: hr_utility.set_location('Entering:'||l_proc, 5);
282: --
283: -- Call conversion function to turn arguments into the
284: -- p_rec structure.
285: --
304: -- are specified as an OUT's we must set these values.
305: --
306: --
307: --
308: hr_utility.set_location(' Leaving:'||l_proc, 10);
309: End ins;
310: --
311: -- ----------------------------------------------------------------------------
312: -- |------------------------------< ins_tl >----------------------------------|
331: --
332: l_proc varchar2(72) := g_package || 'ins_tl';
333: --
334: Begin
335: hr_utility.set_location('Entering:'||l_proc,10);
336: --
337: -- Insert a row for the base language and every installed language.
338: --
339: for l_lang in csr_ins_langs loop
345: ,p_setup_sub_task_description => p_setup_sub_task_description
346: );
347: end loop;
348: --
349: hr_utility.set_location('Leaving:'||l_proc,20);
350: End ins_tl;
351: --
352: end per_sst_ins;