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_bei_shd.g_api_dml := true; -- Set the api dml status
62: --
88: );
89: --
90: ben_bei_shd.g_api_dml := false; -- Unset the api dml status
91: --
92: hr_utility.set_location(' Leaving:'||l_proc, 10);
93: Exception
94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: ben_bei_shd.g_api_dml := false; -- Unset the api dml status
154: --
155: Cursor C_Sel1 is select ben_batch_elig_info_s.nextval from sys.dual;
156: --
157: Begin
158: hr_utility.set_location('Entering:'||l_proc, 5);
159: --
160: --
161: -- Select the next sequence number
162: --
163: Open C_Sel1;
164: Fetch C_Sel1 Into p_rec.batch_elig_id;
165: Close C_Sel1;
166: --
167: hr_utility.set_location(' Leaving:'||l_proc, 10);
168: End pre_insert;
169: --
170: -- ----------------------------------------------------------------------------
171: -- |-----------------------------< post_insert >------------------------------|
204: --
205: l_proc varchar2(72) := g_package||'post_insert';
206: --
207: Begin
208: hr_utility.set_location('Entering:'||l_proc, 5);
209: --
210: --
211: -- Start of API User Hook for post_insert.
212: --
237: --
238: -- End of API User Hook for post_insert.
239: --
240: --
241: hr_utility.set_location(' Leaving:'||l_proc, 10);
242: End post_insert;
243: --
244: -- ----------------------------------------------------------------------------
245: -- |---------------------------------< ins >----------------------------------|
252: --
253: l_proc varchar2(72) := g_package||'ins';
254: --
255: Begin
256: hr_utility.set_location('Entering:'||l_proc, 5);
257: --
258: -- Call the supporting insert validate operations
259: --
260: ben_bei_bus.insert_validate(p_rec,p_effective_date);
294: l_rec ben_bei_shd.g_rec_type;
295: l_proc varchar2(72) := g_package||'ins';
296: --
297: Begin
298: hr_utility.set_location('Entering:'||l_proc, 5);
299: --
300: -- Call conversion function to turn arguments into the
301: -- p_rec structure.
302: --
325: --
326: p_batch_elig_id := l_rec.batch_elig_id;
327: p_object_version_number := l_rec.object_version_number;
328: --
329: hr_utility.set_location(' Leaving:'||l_proc, 10);
330: End ins;
331: --
332: end ben_bei_ins;