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_enp_shd.g_api_dml := true; -- Set the api dml status
62: --
220: );
221: --
222: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
223: --
224: hr_utility.set_location(' Leaving:'||l_proc, 10);
225: Exception
226: When hr_api.check_integrity_violated Then
227: -- A check constraint has been violated
228: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
286: --
287: Cursor C_Sel1 is select ben_enrt_perd_s.nextval from sys.dual;
288: --
289: Begin
290: hr_utility.set_location('Entering:'||l_proc, 5);
291: --
292: --
293: -- Select the next sequence number
294: --
295: Open C_Sel1;
296: Fetch C_Sel1 Into p_rec.enrt_perd_id;
297: Close C_Sel1;
298: --
299: hr_utility.set_location(' Leaving:'||l_proc, 10);
300: End pre_insert;
301: --
302: -- ----------------------------------------------------------------------------
303: -- |-----------------------------< post_insert >------------------------------|
336: --
337: l_proc varchar2(72) := g_package||'post_insert';
338: --
339: Begin
340: hr_utility.set_location('Entering:'||l_proc, 5);
341: --
342: --
343: -- Start of API User Hook for post_insert.
344: --
439: -- End of API User Hook for post_insert.
440: --
441: --
442: --
443: hr_utility.set_location(' Leaving:'||l_proc, 10);
444: End post_insert;
445: --
446: -- ----------------------------------------------------------------------------
447: -- |---------------------------------< ins >----------------------------------|
454: --
455: l_proc varchar2(72) := g_package||'ins';
456: --
457: Begin
458: hr_utility.set_location('Entering:'||l_proc, 5);
459: --
460: -- Call the supporting insert validate operations
461: --
462: ben_enp_bus.insert_validate(p_rec
564: l_rec ben_enp_shd.g_rec_type;
565: l_proc varchar2(72) := g_package||'ins';
566: --
567: Begin
568: hr_utility.set_location('Entering:'||l_proc, 5);
569: --
570: -- Call conversion function to turn arguments into the
571: -- p_rec structure.
572: --
663: --
664: p_enrt_perd_id := l_rec.enrt_perd_id;
665: p_object_version_number := l_rec.object_version_number;
666: --
667: hr_utility.set_location(' Leaving:'||l_proc, 10);
668: End ins;
669: --
670: end ben_enp_ins;