54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: ben_pel_shd.g_api_dml := true; -- Set the api dml status
62: --
226: );
227: --
228: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
229: --
230: hr_utility.set_location(' Leaving:'||l_proc, 10);
231: Exception
232: When hr_api.check_integrity_violated Then
233: -- A check constraint has been violated
234: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
292: --
293: Cursor C_Sel1 is select ben_pil_elctbl_chc_popl_s.nextval from sys.dual;
294: --
295: Begin
296: hr_utility.set_location('Entering:'||l_proc, 5);
297: --
298: --
299: -- Select the next sequence number
300: --
301: Open C_Sel1;
302: Fetch C_Sel1 Into p_rec.pil_elctbl_chc_popl_id;
303: Close C_Sel1;
304: --
305: hr_utility.set_location(' Leaving:'||l_proc, 10);
306: End pre_insert;
307: --
308: -- ----------------------------------------------------------------------------
309: -- |-----------------------------< post_insert >------------------------------|
342: --
343: l_proc varchar2(72) := g_package||'post_insert';
344: --
345: Begin
346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: --
349: -- Start of API User Hook for post_insert.
350: --
446: --
447: -- End of API User Hook for post_insert.
448: --
449: --
450: hr_utility.set_location(' Leaving:'||l_proc, 10);
451: End post_insert;
452: --
453: -- ----------------------------------------------------------------------------
454: -- |---------------------------------< ins >----------------------------------|
461: --
462: l_proc varchar2(72) := g_package||'ins';
463: --
464: Begin
465: hr_utility.set_location('Entering:'||l_proc, 5);
466: --
467: -- Call the supporting insert validate operations
468: --
469: ben_pel_bus.insert_validate(p_rec
587: l_rec ben_pel_shd.g_rec_type;
588: l_proc varchar2(72) := g_package||'ins';
589: --
590: Begin
591: hr_utility.set_location('Entering:'||l_proc, 5);
592: --
593: -- Call conversion function to turn arguments into the
594: -- p_rec structure.
595: --
688: --
689: p_pil_elctbl_chc_popl_id := l_rec.pil_elctbl_chc_popl_id;
690: p_object_version_number := l_rec.object_version_number;
691: --
692: hr_utility.set_location(' Leaving:'||l_proc, 10);
693: End ins;
694: --
695: end ben_pel_ins;