[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: --
86: );
87: --
88: --
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 10);
91: Exception
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: --
153: --
154: l_proc varchar2(72) := g_package||'pre_insert';
155: --
156: Begin
157: hr_utility.set_location('Entering:'||l_proc, 5);
158: --
159: p_rec.learning_path_id := p_learning_path_id;
160: --
161: hr_utility.set_location(' Leaving:'||l_proc, 10);
157: hr_utility.set_location('Entering:'||l_proc, 5);
158: --
159: p_rec.learning_path_id := p_learning_path_id;
160: --
161: hr_utility.set_location(' Leaving:'||l_proc, 10);
162: End pre_insert;
163: --
164: -- ----------------------------------------------------------------------------
165: -- |-----------------------------< post_insert >------------------------------|
200: --
201: l_proc varchar2(72) := g_package||'post_insert';
202: --
203: Begin
204: hr_utility.set_location('Entering:'||l_proc, 5);
205: begin
206: --
207: ota_lpt_rki.after_insert
208: (p_effective_date => p_effective_date
233: ,p_hook_type => 'AI');
234: --
235: end;
236: --
237: hr_utility.set_location(' Leaving:'||l_proc, 10);
238: End post_insert;
239: --
240: -- ----------------------------------------------------------------------------
241: -- |---------------------------------< ins >----------------------------------|
248: --
249: l_proc varchar2(72) := g_package||'ins';
250: --
251: Begin
252: hr_utility.set_location('Entering:'||l_proc, 5);
253: --
254: -- Call the supporting insert validate operations
255: --
256: --Modified for Bug#4310348
283: --
284: -- Call to raise any errors on multi-message list
285: hr_multi_message.end_validation_set;
286: --
287: hr_utility.set_location('Leaving:'||l_proc, 20);
288: end ins;
289: --
290: -- ----------------------------------------------------------------------------
291: -- |---------------------------------< ins >----------------------------------|
305: l_rec ota_lpt_shd.g_rec_type;
306: l_proc varchar2(72) := g_package||'ins';
307: --
308: Begin
309: hr_utility.set_location('Entering:'||l_proc, 5);
310: --
311: -- Call conversion function to turn arguments into the
312: -- p_rec structure.
313: --
336: -- are specified as an OUT's we must set these values.
337: --
338: --
339: --
340: hr_utility.set_location(' Leaving:'||l_proc, 10);
341: End ins;
342: --
343: -- ----------------------------------------------------------------------------
344: -- |------------------------------< ins_tl >----------------------------------|
367: --
368: l_proc varchar2(72) := g_package || 'ins_tl';
369: --
370: Begin
371: hr_utility.set_location('Entering:'||l_proc,10);
372: --
373: -- Insert a row for the base language and every installed language.
374: --
375: for l_lang in csr_ins_langs loop
385: ,p_keywords => p_keywords
386: );
387: end loop;
388: --
389: hr_utility.set_location('Leaving:'||l_proc,20);
390: End ins_tl;
391: --
392: end ota_lpt_ins;