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_ecr_shd.g_api_dml := true; -- Set the api dml status
62: --
261: );
262: --
263: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
264: --
265: hr_utility.set_location(' Leaving:'||l_proc, 10);
266: Exception
267: When hr_api.check_integrity_violated Then
268: -- A check constraint has been violated
269: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
327: --
328: Cursor C_Sel1 is select ben_enrt_rt_s.nextval from sys.dual;
329: --
330: Begin
331: hr_utility.set_location('Entering:'||l_proc, 5);
332: --
333: --
334: -- Select the next sequence number
335: --
336: Open C_Sel1;
337: Fetch C_Sel1 Into p_rec.enrt_rt_id;
338: Close C_Sel1;
339: --
340: hr_utility.set_location(' Leaving:'||l_proc, 10);
341: End pre_insert;
342: --
343: -- ----------------------------------------------------------------------------
344: -- |-----------------------------< post_insert >------------------------------|
377: --
378: l_proc varchar2(72) := g_package||'post_insert';
379: --
380: Begin
381: hr_utility.set_location('Entering:'||l_proc, 5);
382: --
383: hr_utility.set_location(' Leaving:'||l_proc, 10);
384: End post_insert;
385: --
379: --
380: Begin
381: hr_utility.set_location('Entering:'||l_proc, 5);
382: --
383: hr_utility.set_location(' Leaving:'||l_proc, 10);
384: End post_insert;
385: --
386: -- ----------------------------------------------------------------------------
387: -- |---------------------------------< ins >----------------------------------|
392: --
393: l_proc varchar2(72) := g_package||'ins';
394: --
395: Begin
396: hr_utility.set_location('Entering:'||l_proc, 5);
397: --
398: -- Call the supporting insert validate operations
399: --
400: ben_ecr_bus.insert_validate(p_rec,p_effective_date);
520: l_rec ben_ecr_shd.g_rec_type;
521: l_proc varchar2(72) := g_package||'ins';
522: --
523: Begin
524: hr_utility.set_location('Entering:'||l_proc, 5);
525: --
526: -- Call conversion function to turn arguments into the
527: -- p_rec structure.
528: --
637: --
638: p_enrt_rt_id := l_rec.enrt_rt_id;
639: p_object_version_number := l_rec.object_version_number;
640: --
641: hr_utility.set_location(' Leaving:'||l_proc, 10);
642: End ins;
643: --
644: end ben_ecr_ins;