[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: --
92: );
93: --
94: --
95: --
96: hr_utility.set_location(' Leaving:'||l_proc, 10);
97: Exception
98: When hr_api.check_integrity_violated Then
99: -- A check constraint has been violated
100: --
159: --
160: l_proc varchar2(72) := g_package||'pre_insert';
161: --
162: Begin
163: hr_utility.set_location('Entering:'||l_proc, 5);
164: --
165: p_rec.certification_id := p_certification_id;
166: --
167: hr_utility.set_location(' Leaving:'||l_proc, 10);
163: hr_utility.set_location('Entering:'||l_proc, 5);
164: --
165: p_rec.certification_id := p_certification_id;
166: --
167: hr_utility.set_location(' Leaving:'||l_proc, 10);
168: End pre_insert;
169: --
170: -- ----------------------------------------------------------------------------
171: -- |-----------------------------< post_insert >------------------------------|
206: --
207: l_proc varchar2(72) := g_package||'post_insert';
208: --
209: Begin
210: hr_utility.set_location('Entering:'||l_proc, 5);
211: begin
212: --
213: ota_ctl_rki.after_insert
214: (p_effective_date => p_effective_date
245: ,p_hook_type => 'AI');
246: --
247: end;
248: --
249: hr_utility.set_location(' Leaving:'||l_proc, 10);
250: End post_insert;
251: --
252: -- ----------------------------------------------------------------------------
253: -- |---------------------------------< ins >----------------------------------|
260: --
261: l_proc varchar2(72) := g_package||'ins';
262: --
263: Begin
264: hr_utility.set_location('Entering:'||l_proc, 5);
265: --
266: -- Call the supporting insert validate operations
267: --
268: --Modified for Bug#4775354
295: --
296: -- Call to raise any errors on multi-message list
297: hr_multi_message.end_validation_set;
298: --
299: hr_utility.set_location('Leaving:'||l_proc, 20);
300: end ins;
301: --
302: -- ----------------------------------------------------------------------------
303: -- |---------------------------------< ins >----------------------------------|
320: l_rec ota_ctl_shd.g_rec_type;
321: l_proc varchar2(72) := g_package||'ins';
322: --
323: Begin
324: hr_utility.set_location('Entering:'||l_proc, 5);
325: --
326: -- Call conversion function to turn arguments into the
327: -- p_rec structure.
328: --
354: -- are specified as an OUT's we must set these values.
355: --
356: --
357: --
358: hr_utility.set_location(' Leaving:'||l_proc, 10);
359: End ins;
360: --
361: -- ----------------------------------------------------------------------------
362: -- |------------------------------< ins_tl >----------------------------------|
388: --
389: l_proc varchar2(72) := g_package || 'ins_tl';
390: --
391: Begin
392: hr_utility.set_location('Entering:'||l_proc,10);
393: --
394: -- Insert a row for the base language and every installed language.
395: --
396: for l_lang in csr_ins_langs loop
409: ,p_renewal_period_comments => p_renewal_period_comments
410: );
411: end loop;
412: --
413: hr_utility.set_location('Leaving:'||l_proc,20);
414: End ins_tl;
415: --
416: end ota_ctl_ins;