[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: --
84: );
85: --
86: --
87: --
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: Exception
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: --
151: --
152: l_proc varchar2(72) := g_package||'pre_insert';
153: --
154: Begin
155: hr_utility.set_location('Entering:'||l_proc, 5);
156: --
157: p_rec.competence_id := p_competence_id;
158: --
159: hr_utility.set_location(' Leaving:'||l_proc, 10);
155: hr_utility.set_location('Entering:'||l_proc, 5);
156: --
157: p_rec.competence_id := p_competence_id;
158: --
159: hr_utility.set_location(' Leaving:'||l_proc, 10);
160: End pre_insert;
161: --
162: -- ----------------------------------------------------------------------------
163: -- |-----------------------------< post_insert >------------------------------|
198: --
199: l_proc varchar2(72) := g_package||'post_insert';
200: --
201: Begin
202: hr_utility.set_location('Entering:'||l_proc, 5);
203: begin
204: --
205: per_cpl_rki.after_insert
206: (p_effective_date => p_effective_date
229: ,p_hook_type => 'AI');
230: --
231: end;
232: --
233: hr_utility.set_location(' Leaving:'||l_proc, 10);
234: End post_insert;
235: --
236: -- ----------------------------------------------------------------------------
237: -- |---------------------------------< ins >----------------------------------|
244: --
245: l_proc varchar2(72) := g_package||'ins';
246: --
247: Begin
248: hr_utility.set_location('Entering:'||l_proc, 5);
249: --
250: -- Call the supporting insert validate operations
251: --
252: per_cpl_bus.insert_validate
277: --
278: -- Call to raise any errors on multi-message list
279: hr_multi_message.end_validation_set;
280: --
281: hr_utility.set_location('Leaving:'||l_proc, 20);
282: end ins;
283: --
284: -- ----------------------------------------------------------------------------
285: -- |---------------------------------< ins >----------------------------------|
298: l_rec per_cpl_shd.g_rec_type;
299: l_proc varchar2(72) := g_package||'ins';
300: --
301: Begin
302: hr_utility.set_location('Entering:'||l_proc, 5);
303: --
304: -- Call conversion function to turn arguments into the
305: -- p_rec structure.
306: --
328: -- are specified as an OUT's we must set these values.
329: --
330: --
331: --
332: hr_utility.set_location(' Leaving:'||l_proc, 10);
333: End ins;
334: --
335: -- ----------------------------------------------------------------------------
336: -- |------------------------------< ins_tl >----------------------------------|
358: --
359: l_proc varchar2(72) := g_package || 'ins_tl';
360: --
361: Begin
362: hr_utility.set_location('Entering:'||l_proc,10);
363: --
364: -- Insert a row for the base language and every installed language.
365: --
366: for l_lang in csr_ins_langs loop
375: ,p_description => p_description
376: );
377: end loop;
378: --
379: hr_utility.set_location('Leaving:'||l_proc,20);
380:
381: --
382: --
383: per_cpl_upd.upd_key_flex_meanings( p_competence_id );
381: --
382: --
383: per_cpl_upd.upd_key_flex_meanings( p_competence_id );
384: --
385: hr_utility.set_location(' Leaving:'||l_proc,20);
386: End ins_tl;
387: end per_cpl_ins;