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_bec_shd.g_api_dml := true; -- Set the api dml status
62: --
102: );
103: --
104: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
105: --
106: hr_utility.set_location(' Leaving:'||l_proc, 10);
107: Exception
108: When hr_api.check_integrity_violated Then
109: -- A check constraint has been violated
110: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
168: --
169: Cursor C_Sel1 is select ben_batch_elctbl_chc_info_s.nextval from sys.dual;
170: --
171: Begin
172: hr_utility.set_location('Entering:'||l_proc, 5);
173: --
174: --
175: -- Select the next sequence number
176: --
177: Open C_Sel1;
178: Fetch C_Sel1 Into p_rec.batch_elctbl_id;
179: Close C_Sel1;
180: --
181: hr_utility.set_location(' Leaving:'||l_proc, 10);
182: End pre_insert;
183: --
184: -- ----------------------------------------------------------------------------
185: -- |-----------------------------< post_insert >------------------------------|
218: --
219: l_proc varchar2(72) := g_package||'post_insert';
220: --
221: Begin
222: hr_utility.set_location('Entering:'||l_proc, 5);
223: --
224: --
225: -- Start of API User Hook for post_insert.
226: --
258: --
259: -- End of API User Hook for post_insert.
260: --
261: --
262: hr_utility.set_location(' Leaving:'||l_proc, 10);
263: End post_insert;
264: --
265: -- ----------------------------------------------------------------------------
266: -- |---------------------------------< ins >----------------------------------|
273: --
274: l_proc varchar2(72) := g_package||'ins';
275: --
276: Begin
277: hr_utility.set_location('Entering:'||l_proc, 5);
278: --
279: -- Call the supporting insert validate operations
280: --
281: ben_bec_bus.insert_validate(p_rec,p_effective_date);
322: l_rec ben_bec_shd.g_rec_type;
323: l_proc varchar2(72) := g_package||'ins';
324: --
325: Begin
326: hr_utility.set_location('Entering:'||l_proc, 5);
327: --
328: -- Call conversion function to turn arguments into the
329: -- p_rec structure.
330: --
360: --
361: p_batch_elctbl_id := l_rec.batch_elctbl_id;
362: p_object_version_number := l_rec.object_version_number;
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 10);
365: End ins;
366: --
367: end ben_bec_ins;