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.qualification_id := p_qualification_id;
166: --
167: hr_utility.set_location(' Leaving:'||l_proc, 10);
163: hr_utility.set_location('Entering:'||l_proc, 5);
164: --
165: p_rec.qualification_id := p_qualification_id;
166: --
167: hr_utility.set_location(' Leaving:'||l_proc, 10);
168: End pre_insert;
169: --
170: -- ----------------------------------------------------------------------------
171: -- |-----------------------------< post_insert >------------------------------|
205: --
206: l_proc varchar2(72) := g_package||'post_insert';
207: --
208: Begin
209: hr_utility.set_location('Entering:'||l_proc, 5);
210: begin
211: --
212: per_qat_rki.after_insert
213: (p_qualification_id
243: ,p_hook_type => 'AI');
244: --
245: end;
246: --
247: hr_utility.set_location(' Leaving:'||l_proc, 10);
248: End post_insert;
249: --
250: -- ----------------------------------------------------------------------------
251: -- |---------------------------------< ins >----------------------------------|
257: --
258: l_proc varchar2(72) := g_package||'ins';
259: --
260: Begin
261: hr_utility.set_location('Entering:'||l_proc, 5);
262: --
263: --
264: -- Call the supporting insert validate operations
265: --
290: --
291: -- Call to raise any errors on multi-message list
292: hr_multi_message.end_validation_set;
293: --
294: hr_utility.set_location('Leaving:'||l_proc, 20);
295: end ins;
296: --
297: -- ----------------------------------------------------------------------------
298: -- |---------------------------------< ins >----------------------------------|
314: l_rec per_qat_shd.g_rec_type;
315: l_proc varchar2(72) := g_package||'ins';
316: --
317: Begin
318: hr_utility.set_location('Entering:'||l_proc, 5);
319: --
320: -- Call conversion function to turn arguments into the
321: -- p_rec structure.
322: --
347: -- are specified as an OUT's we must set these values.
348: --
349: --
350: --
351: hr_utility.set_location(' Leaving:'||l_proc, 10);
352: End ins;
353: --
354: -- ----------------------------------------------------------------------------
355: -- |------------------------------< ins_tl >----------------------------------|
380: --
381: l_proc varchar2(72) := g_package || 'ins_tl';
382: --
383: Begin
384: hr_utility.set_location('Entering:'||l_proc,10);
385: --
386: -- Insert a row for the base language and every installed language.
387: --
388: for l_lang in csr_ins_langs loop
400: ,p_membership_category => p_membership_category
401: );
402: end loop;
403: --
404: hr_utility.set_location('Leaving:'||l_proc,20);
405: End ins_tl;
406: --
407: end per_qat_ins;